{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Auftrag","Anlagenkartei"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Auftrag","index":0,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Aufträge"]
[]
["In dieser Anwendungen sollen Sie eine Anlagenkartei für verschiedene Anlagegüter führen."]
[]
["Vorgehensweise"]
["1. Wählen Sie die die Tabelle \"Anlagenkartei\"."]
[]
["2. Klicken Sie auf den Button \"Eingabe\" und geben Sie die Auftragsdaten ein."]
[]
["3. Legen Sie die Abschreibungsmethode durch Aktivierung des entsprechenden Opitionsfeldes fest."]
[]
["4. Die Daten des Anlagegutes und der Abschreibungsverlauf werden automatisch eingetragen."]
[]
["Arbeitsaufträge"]
["1. ","Die Tropic GmbH beschafft einen Pkw für den folgende Anlagedaten einzugeben sind:"]
[null,"- Inventar-Nr.: P 123"]
[null,"- Anschaffungsjahr: 2005",null,null,"- Anschaffungshalbjahr: 2"]
[null,"- Anlagenkonto: 0340"]
[null,"- Lieferant: Auto Wittmann GmbH, Industriestr. 18, 55596 Bad Sobernheim"]
[null,"- Anschaffungspreis: 35.000,00 €",null,null,"- Skonto in %: 3"]
[null,"- sonst. Anschaffungskosten: 200,00 €",null,null,"- Nutzungsdauer in Jahren: 5"]
[null,"- Kostenstelle: Vertrieb",null,null,"- Gewährleistung in Monaten: 24"]
[null,"- Abschreibungsmethode: linear"]
[null,"- Versicherung: Fortuna, Anschrift: Burgstr. 12, 55543 Bad Kreuznach"]
[null,"- Tel.: 0671-333",null,null,"- email: fortuna@t-online.de"]
[null,"- Versicherungs-Nr.: 555444"]
[]
["2.","Führen Sie die Anlagenkartei für den folgenden Vorgang:"]
[]
[null,"Die Tropic GmbH beschafft eine Zuschneidemaschine. (Inventar-Nr. 1235)",null,null,"- Anschaffungshalbjahr: 2"]
[null,"Anschaffungsdatum: 12. Mai 2005",null,null,"Anlagekonto: 0700",null,"Kostenstelle: Produktion"]
[null,"Die Maschine wird von der Mainzer Maschinenbau AG, Mombacher Str. 2, "]
[null,"55264 Mainz geliefert."]
[null,"Der Anschaffungspreis beträgt 225.000,00 €"]
[null,"Der Lieferer gewährt einen Skonto von 2% und berechnet 400,00 € für den "]
[null,"Transport. Für die Transportversicherung müssen 50,00 € gezahlt werden. Die"]
[null,"sonstigen Anschaffungskosten betragen insgesamt 150,00 €."]
[null,"Wegen der bisher guten Geschäftsbeziehungen gewährt der Lieferer einen"]
[null,"zusätzlichen Nachlass von 2.000,00 €"]
[null,"Die Maschine wird degressiv abgeschrieben und hat eine Nutzungsdauer von "]
[null,"15 Jahren. Der Lieferer gewährt eine Garantie von 4 Jahren."]
[null,"Die Maschine wird bei der folgenden Gesellschaft versichert:"]
[null,"- Fortuna, Anschrift: Burgstr. 12, 55543 Bad Kreuznach"]
[null,"- Tel.: 0671-333",null,null,"- email: fortuna@t-online.de"]
[null,"- Versicherungs-Nr.: 555444"]

{"sheet":"Anlagenkartei","index":1,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,5,2,6],[5,3,5,6],[1,2,1,3],[37,5,37,6],[13,5,13,6]]}
[]
[null,null,"Anlagenkartei",null,"Tropic GmbH Rheingrafenstr. 20 55543 Bad Kreuznach",null,"Abschreibungsmethode",1]
[null,null,"Inventar-Nr.:",null,"Bezeichnung:"]
[null,null,"Anschaffungsjahr",null,null,"Anschaffungshalbjahr"]
[null,null,"Anlagekonto:","","Direkte Abschreibungen"]
[null,null,"Lieferant: "]
[null,null,"Gewährleistung/Monate:",null,null,"Kostenstelle:"]
[null,null,"Ermittlung der Anschaffungskosten",null,null,"Versicherung"]
[null,null,"Anschaffungspreis"]
[null,null,"Skonto in %",null,{"$f":"E9*D10/100","v":0},"   Versicherungs-Nr.:",""]
[null,null,"Transportkosten",null,null,"   Telefon:"]
[null,null,"Versicherung",null,null,"   eMail:"]
[null,null,"sonstige Kosten",null,null,"   Anschrift:"]
[null,null,"andere Nachlässe"]
[null,null,"Anschaffungskosten",null,{"$f":"E9+E11+E12+E13-E10-E14","v":0},"Nutzungsdauer/Jahre: "]
[null,null,"Jahr (31.12.)","Methode","AfA-Satz in %","Jahres AfA","Buchwert"]
[null,null,{"$f":"$E$4","v":0},{"$f":"IF(H2=1,\"linear\",\"degressiv\")","v":"linear"},{"$f":"IF(E15>0,IF(G4=1,IF(D17=\"linear\",100/G15,(IF(D17=\"degressiv\",(IF((100/G15)*2>20,20,(100/G15)*2))))),IF(D17=\"linear\",100/G15,(IF(D17=\"degressiv\",(IF((100/G15)*2>20,20,(100/G15)*2)))))/2),\"\")","v":""},{"$f":"IF($E$15>0,IF(D17=\"linear\",($G$17*E17)/100,(G17*E17/100)),\"\")","v":""},{"$f":"E15","v":0}]
[null,null,{"$f":"C17+1","v":1},{"$f":"$D$17","v":"linear"},{"$f":"IF(E15>0,IF($D$18=\"linear\",100/$G$15,(IF($D$18=\"degressiv\",(IF((100/$G$15)*2>20,20,(100/$G$15)*2))))),\"\")","v":""},{"$f":"IF($E$15>0,IF(D18=\"linear\",($G$17*E18)/100,(G18*E18/100)),\"\")","v":""},{"$f":"IF($E$15>0,IF(G17-F17<=0,1,G17-F17),\"\")","v":""}]
[null,null,{"$f":"C18+1","v":2},{"$f":"$D$17","v":"linear"},{"$f":"IF($E$15>0,IF($D$18=\"linear\",100/$G$15,(IF($D$18=\"degressiv\",(IF((100/$G$15)*2>20,20,(100/$G$15)*2))))),\"\")","v":""},"",{"$f":"IF($E$15>0,IF(G18-F18<=0,1,G18-F18),\"\")","v":""}]
[null,null,3,"linear",{"$f":"IF($E$15>0,IF($D$18=\"linear\",100/$G$15,(IF($D$18=\"degressiv\",(IF((100/$G$15)*2>20,20,(100/$G$15)*2))))),\"\")","v":""},"",""]
[null,null,4,"linear","","",""]
[null,null,5,"linear","","",""]
[null,null,6,"linear","","",""]
[null,null,7,"linear","","",""]
[null,null,8,"linear","","",""]
[null,null,9,"linear","","",""]
[null,null,10,"linear","","",""]
[null,null,11,"linear","","",""]
[null,null,12,"linear","","",""]
[null,null,13,"linear","","",""]
[null,null,14,"linear","","",""]
[null,null,15,"linear","","",""]
[null,null,16,"linear","","",""]
[null,null,17,"linear","","",""]
[null,null,18,"linear","","",""]
[null,null,19,"linear","","",""]
[null,null,20,"linear","","",""]
[null,null,"ausgeschieden:",null,"Grund:"]