{"text_format":"3","workbook":"xls","n_sheets":9,"sheets":["AutoOpen Stub Data","Anpassen der Abrechnung","Reisekostenabrechnung","Macros","ATW","Sperren","Mitarbeiter auswählen","TemplateInformation","Intl Data Table"],"not_rendered":{"images":3,"macros":1,"external_links":2,"defined_names":230,"comments":24},"unopened":[{"sheet":"AutoOpen Stub Data","index":0,"reason":"not_a_worksheet"},{"sheet":"Macros","index":3,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Anpassen der Abrechnung","index":1,"n_rows":49,"n_cols":8,"rows_kept":49,"merged":[[3,3,3,6],[9,3,9,5],[18,3,18,5],[28,6,28,7],[31,3,31,5]],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[]
[{"$nulls":7},"Führen Sie Ihren Mauszeiger"]
[{"$nulls":7},"HIERHER für einen nützlichen Tip!"]
[]
[{"$nulls":3},"Eingabe der Firmeninformationen:"]
[]
[{"$nulls":4},"Firma:  ","FIRMENNAME","Telefon-Nr.:  ","Telefon"]
[{"$nulls":4},"Anschrift:  ","Anschrift","Fax-Nr.:  ","Fax"]
[{"$nulls":4},"PLZ:  ","PLZ"]
[{"$nulls":4},"Stadt:  ","Stadt"]
[{"$nulls":4},"Land:  ","Land"]
[]
[]
[{"$nulls":3},"Eingabe der üblichen Reisekosten-Informationen:"]
[]
[{"$nulls":4},"Kilometergeld:  ",{"v":0.21,"d":"0.21 DM"},false,"Kosten der Kategorie Spesen/"]
[{"$nulls":4},"(pro km)  ",null,null,"Sonstiges werden nicht erstattet."]
[]
[{"$nulls":4},false,"Reisekostenabrechnungs-Numerierung"," Pfad der Zählerdatei:"]
[{"$nulls":5},"im Netzwerk freigeben."]
[]
[{"$nulls":4},true,"Mitarbeiterauswahl aktivieren.","  Allg. Datenbank:  "]
[]
[{"$nulls":5},"Datenbank des Vorlagenassistenten:  ","rkostdb.xls"]
[]
[]
[{"$nulls":3},"Formatierung der Formulare:"]
{"$rows_empty":12}
[{"$nulls":5},49]
[{"$nulls":5},0]
[{"$nulls":5},true]
[]
[{"$nulls":5},"Reisekostenabrechnung"]

{"sheet":"Reisekostenabrechnung","index":2,"n_rows":46,"n_cols":14,"rows_kept":46,"merged":[[12,4,12,5],[12,7,12,9],[13,4,13,5],[13,7,13,9],[14,4,14,5],[14,7,14,9],[37,3,40,4],[37,5,37,7],[38,5,40,7],[45,3,46,7],[45,8,46,13]],"flags":["formulas_cached_only"]}
[]
[]
[]
[{"$nulls":12},"Abrechnung Nr.:",""]
{"$rows_empty":8}
[{"$nulls":3},"Name","",null,"  Mitarb.Nr.","",{"$nulls":4},"Von",""]
[{"$nulls":3},"Soz.Vers.Nr.",null,null,"  Position  "]
[{"$nulls":3},"Abteilung",null,null,"  Vorgesetzter",{"$nulls":5},"Bis",""]
[]
[{"$nulls":3},"Datum","Konto","Beschreibung","Unterkunft","Fahrtkosten","Benzin","Mahlzeiten","Telefon","Spesen","Sonstiges","Gesamt"]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":6},"","","","","","",""]
[{"$nulls":12},"Zwischensumme  ",""]
[{"$nulls":12},"Vorauszahlungen  "]
[{"$nulls":5},"    Die aktuelle Kilometergeldpauschale beträgt 0,21 DM",{"$nulls":3},"Erstattung",null,null,"Gesamtbetrag  ",""]
[{"$nulls":10},1]
[{"$nulls":9},"Rückzahlung"]
[]
[]
[]
[]
[]
[{"$nulls":8},"Geben Sie hier Ihre Anmerkungen ein."]

{"sheet":"ATW","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true,"flags":["formulas_cached_only"]}

{"sheet":"Sperren","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true,"flags":["formulas_cached_only"]}

{"sheet":"Mitarbeiter auswählen","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true,"flags":["formulas_cached_only"]}

{"sheet":"TemplateInformation","index":7,"n_rows":9,"n_cols":13,"rows_kept":9,"hidden":true,"flags":["formulas_cached_only"]}
["AutoTemplateWizardDONTMESSWITHIT"]
["Datenbank Typ:","Excel 5.0"]
["Verzeichnis der Datenbank:","Rkostdb.xls"]
["Reserved"]
["Anzahl der Tabellen:",1]
[1,"Tabellenname:","Tabelle1","Anzahl der Felder:",12,null,-338312448]
["Feld Name:","Abrechnung Nr.","Mitarbeiter Name","Mitarbeiter Nr.","Mitarbeiter SVNr.","Mitarbeiter Position","Mitarbeiter Abteilung","Mitarbeiter Vorgesetzter","Zeitraum von","Zeitraum bis","Zwischensumme  ","Vorauszahlung","Gesamtbetrag"]
["Bezieht sich auf:","","=Reisekostenabrechnung!$E$13","","=Reisekostenabrechnung!$E$14",0,"=Reisekostenabrechnung!$E$15",0,"","","",0,""]
["Reserved"]

{"sheet":"Intl Data Table","index":8,"n_rows":8,"n_cols":33,"rows_kept":8,"hidden":true,"flags":["formulas_cached_only"]}
[]
[{"$nulls":3},"US","UK","Canada","Australia","New Zealand","Ireland","Arabic Countries","Austria","Belgium","Brazil","China","Denmark","France","Germany","Hungary","Israel","Italy","Japan","Korea","Luxembourg","Netherlands","Norway","Portugal","South Africa","Spain","Sweden","Switzerland","Taiwan","Turkey","Venezuela"]
["Sheet Name","Cell Address","Action Code",1,44,2,61,64,353,785,43,32,55,86,45,33,-999,36,972,39,81,82,352,31,47,351,27,34,46,41,886,90,58]
["Anpassen der Abrechnung","F21",2,"$#,##0.00_);(\"$\"#,##0.00)","£#,##0.00_);(\"£\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","IR£#,##0.00_);(\"IR£\"#,##0.00)","#,##0.00_);(#,##0.00)","ÖS #.##0,00_);(\"ÖS \"#.##0,00)","BF #.##0,00_);(\"BF \"#.##0,00)","R$ #.##0,00_);(\"R$ \"#.##0,00)","#,##0.00_);(#,##0.00)","kr #.##0,00_);(\"kr \"#.##0,00)","# ##0,00 \"F\"_);(# ##0,00 \"F\")","#.##0,00 \"DM\"_);(#.##0,00 \"DM\")","#.##0,00 \"Ft\"_);(#.##0,00 \"Ft\")","#,##0.00_D_M_);(#,##0.00_D_M)","L. #.##0,00_);(\"L. \"#.##0,00)","¥#,##0.00_);(\"¥\"#,##0.00)","#,##0.00_D_M_);(#,##0.00_D_M)","#.##0,00 \"F\"_);(#.##0,00 \"F\")","F #.##0,00_);(\"F \"#.##0,00)","kr # ##0,00_);(\"kr \"# ##0,00)","#.##0,00 \"PTE\"_);(#.##0,00 \"PTE\")","R #,##0.00_);(\"R \"#,##0.00)","#.##0,00 \"Pts\"_);(#.##0,00 \"Pts\")","# ##0,00 \"kr\"_);(# ##0,00 \"kr\")","SFr. #'##0.00_);(\"SFr. \"#'##0.00)","#,##0.00_D_M_);(#,##0.00_D_M)","#.##0,00 \"TL\"_);(#.##0,00 \"TL\")","Bs #.##0,00_);(\"Bs \"#.##0,00)"]
["Reisekostenabrechnung","G18:N35",2,"$#,##0.00_);(\"$\"#,##0.00)","£#,##0.00_);(\"£\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","IR£#,##0.00_);(\"IR£\"#,##0.00)","#,##0.00_);(#,##0.00)","ÖS #.##0,00_);(\"ÖS \"#.##0,00)","BF #.##0,00_);(\"BF \"#.##0,00)","R$ #.##0,00_);(\"R$ \"#.##0,00)","#,##0.00_);(#,##0.00)","kr #.##0,00_);(\"kr \"#.##0,00)","# ##0,00 \"F\"_);(# ##0,00 \"F\")","#.##0,00 \"DM\"_);(#.##0,00 \"DM\")","#.##0,00 \"Ft\"_);(#.##0,00 \"Ft\")","#,##0.00_D_M_);(#,##0.00_D_M)","L. #.##0,00_);(\"L. \"#.##0,00)","¥#,##0.00_);(\"¥\"#,##0.00)","#,##0.00_D_M_);(#,##0.00_D_M)","#.##0,00 \"F\"_);(#.##0,00 \"F\")","F #.##0,00_);(\"F \"#.##0,00)","kr # ##0,00_);(\"kr \"# ##0,00)","#.##0,00 \"PTE\"_);(#.##0,00 \"PTE\")","R #,##0.00_);(\"R \"#,##0.00)","#.##0,00 \"Pts\"_);(#.##0,00 \"Pts\")","# ##0,00 \"kr\"_);(# ##0,00 \"kr\")","SFr. #'##0.00_);(\"SFr. \"#'##0.00)","#,##0.00_D_M_);(#,##0.00_D_M)","#.##0,00 \"TL\"_);(#.##0,00 \"TL\")","Bs #.##0,00_);(\"Bs \"#.##0,00)"]
["Reisekostenabrechnung","N36:N38",2,"$#,##0.00_);(\"$\"#,##0.00)","£#,##0.00_);(\"£\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","$#,##0.00_);(\"$\"#,##0.00)","IR£#,##0.00_);(\"IR£\"#,##0.00)","#,##0.00_);(#,##0.00)","ÖS #.##0,00_);(\"ÖS \"#.##0,00)","BF #.##0,00_);(\"BF \"#.##0,00)","R$ #.##0,00_);(\"R$ \"#.##0,00)","#,##0.00_);(#,##0.00)","kr #.##0,00_);(\"kr \"#.##0,00)","# ##0,00 \"F\"_);(# ##0,00 \"F\")","#.##0,00 \"DM\"_);(#.##0,00 \"DM\")","#.##0,00 \"Ft\"_);(#.##0,00 \"Ft\")","#,##0.00_D_M_);(#,##0.00_D_M)","L. #.##0,00_);(\"L. \"#.##0,00)","¥#,##0.00_);(\"¥\"#,##0.00)","#,##0.00_D_M_);(#,##0.00_D_M)","#.##0,00 \"F\"_);(#.##0,00 \"F\")","F #.##0,00_);(\"F \"#.##0,00)","kr # ##0,00_);(\"kr \"# ##0,00)","#.##0,00 \"PTE\"_);(#.##0,00 \"PTE\")","R #,##0.00_);(\"R \"#,##0.00)","#.##0,00 \"Pts\"_);(#.##0,00 \"Pts\")","# ##0,00 \"kr\"_);(# ##0,00 \"kr\")","SFr. #'##0.00_);(\"SFr. \"#'##0.00)","#,##0.00_D_M_);(#,##0.00_D_M)","#.##0,00 \"TL\"_);(#.##0,00 \"TL\")","Bs #.##0,00_);(\"Bs \"#.##0,00)"]
["Reisekostenabrechnung","F38",3,"IF(dflt1<>\"\",\"    Current mileage reimbursement rate is \"&TEXT(dflt1,\"$.00\"),\"\")","IF(dflt1<>\"\",\"    Current mileage reimbursement rate is \"&TEXT(dflt1,\"£.00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometer reimbursement rate is \"&TEXT(dflt1,\"$.00\"),\"\")","IF(dflt1<>\"\",\"    Current mileage reimbursement rate is \"&TEXT(dflt1,\"$.00\"),\"\")","IF(dflt1<>\"\",\"    Current mileage reimbursement rate is \"&TEXT(dflt1,\"$.00\"),\"\")","IF(dflt1<>\"\",\"    Current mileage reimbursement rate is \"&TEXT(dflt1,\"IR£.00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"$.00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"ÖS,00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"BF,00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"R,00\"),\"\")","IF(dflt1<>\"\",\"    Current mileage reimbursement rate is \"&TEXT(dflt1,\"#.00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"kr,00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"#,00 F\"),\"\")","IF(dflt1<>\"\",\"    Die aktuelle Kilometergeldpauschale beträgt \"&TEXT(dflt1,\"#,00 DM\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"#,00 Ft\"),\"\")","IF(dflt1<>\"\",\"    Current mileage reimbursement rate is \"&TEXT(dflt1,\"#.00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"L. ###\"),\"\")","IF(dflt1<>\"\",\"    Current mileage reimbursement rate is \"&TEXT(dflt1,\"¥.00\"),\"\")","IF(dflt1<>\"\",\"    Current mileage reimbursement rate is \"&TEXT(dflt1,\"#.00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"#,00 F\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"F,00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"kr,00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"#,00 PTE\"),\"\")","IF(dflt1<>\"\",\"    Current mileage reimbursement rate is \"&TEXT(dflt1,\"R.00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"#,00 Pts\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"#,00 kr\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"SFr. .00\"),\"\")","IF(dflt1<>\"\",\"    Current mileage reimbursement rate is \"&TEXT(dflt1,\"#.00\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"#,00 TL\"),\"\")","IF(dflt1<>\"\",\"    Current kilometre reimbursement rate is \"&TEXT(dflt1,\"Bs.00\"),\"\")"]
["Reisekostenabrechnung","A1",4,1,9,1,9,9,9,9,9,9,1,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9]