{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["Übersicht Rechnung","Summen","Honorare","Fachkraftblatt (3)","Fachkraftblatt (4)","Fachkraftblatt (5)","Fachkraftblatt (6)","Fachkraftblatt (7)","Fachkraftblatt (8)","Fachkraftblatt (9)","Fachkraftblatt (10)","Vertragsbed.Kosten","Reisekosten","Nationales Personal","Ausrüstungsgüter","Betriebskosten","Unteraufträge","WS und FB","Zuschüsse","Sonstige_Kosten","Flexible Vergütungspos."],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":32,"comments":1,"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":"Übersicht Rechnung","index":0,"n_rows":64,"n_cols":13,"rows_kept":64,"cut":false,"hidden":false,"merged":[[56,5,56,6],[54,2,54,3],[56,1,57,1],[56,2,56,3],[57,2,57,3],[54,1,55,1],[54,5,54,6],[55,2,55,3],[46,4,46,6],[53,5,53,6],[19,5,19,9],[20,5,20,9],[33,7,33,9],[34,7,34,9],[35,7,35,9],[34,4,34,6],[37,4,37,6],[43,4,43,6],[54,0,55,0],[18,0,19,1],[18,2,19,3],[27,2,27,4],[28,8,28,9],[29,8,29,9],[47,4,47,6],[44,2,44,3],[55,5,55,6],[53,2,53,3],[52,11,52,14],[48,5,48,6],[50,5,50,6],[48,2,48,3],[49,2,49,3],[51,1,52,1],[51,5,51,6],[51,2,51,3],[52,2,52,3],[50,2,50,3],[49,5,49,6],[52,5,52,6],[0,0,0,4],[0,5,0,9],[1,4,6,4],[16,5,16,9],[7,0,7,9],[8,0,9,4],[8,5,8,9],[9,5,9,9],[10,0,15,3],[10,5,10,7],[11,5,11,7],[12,5,12,7],[6,0,6,3],[15,5,15,9],[13,5,14,9],[6,7,6,9],[2,5,2,6],[1,5,1,6],[3,5,3,6],[4,5,4,6],[5,5,5,6],[6,5,6,6],[1,0,1,3],[2,0,2,3],[63,0,63,3],[20,0,20,3],[21,1,21,3],[21,5,21,9],[22,0,22,3],[22,5,22,9],[24,0,24,3],[24,5,24,9],[23,0,23,2],[23,5,23,9],[25,0,25,9],[26,0,26,1],[26,2,26,3],[26,4,26,5],[26,6,26,7],[27,0,27,1],[39,4,39,6],[29,0,29,5],[29,6,29,7],[33,2,33,3],[33,4,33,6],[60,2,60,3],[38,2,38,3],[27,6,27,7],[61,0,61,1],[60,0,60,1],[39,2,39,3],[31,2,31,3],[31,4,31,5],[41,2,41,3],[47,2,47,3],[46,2,46,3],[45,4,45,6],[41,4,41,6],[51,0,52,0],[40,2,40,3],[40,4,40,6],[42,2,42,3],[60,4,60,6],[61,4,61,6],[44,4,44,6],[45,2,45,3],[43,2,43,3],[42,4,42,6],[56,0,57,0],[58,2,58,4],[58,5,58,6],[57,5,57,6],[3,0,3,3],[4,0,4,3],[5,0,5,3],[1,7,1,9],[2,7,2,9],[3,7,3,9],[4,7,4,9],[5,7,5,9],[61,2,61,3],[31,7,31,9],[32,7,32,9],[17,5,18,9],[28,0,28,5],[28,6,28,7],[38,4,38,6],[32,2,32,3],[32,4,32,6],[34,2,34,3],[35,2,35,3],[35,4,35,6],[36,4,36,6],[36,2,36,3],[30,0,30,6],[30,7,30,9]]}
["Auftragnehmer/-in (Bitte Anschrift aus dem Vertrag übernehmen)",null,null,null,null,"Bankverbindung"]
[null,null,null,null,null,"Bankname:"]
[null,null,null,null,null,"Kontonr.:"]
[null,null,null,null,null,"BLZ:"]
[null,null,null,null,null,"IBAN:"]
[null,null,null,null,null,"BIC (Swift-Code bei Auslandsbank):"]
[null,null,null,null,null,"Steuer-/USt-IdNr.:"]
[]
[null,null,null,null,null,"Von GIZ auszufüllen"]
[]
["Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH Bonn                    \nFriedrich-Ebert-Allee 36\n53113 Bonn",null,null,null,null,"VR",null,null,null,"1 1"]
[null,null,null,null,null,"LR",null,null,null,"1 1"]
[null,null,null,null,null,"KR   4 7"]
[null,null,null,null,null,"Kto.                                                             Kst."]
[]
[null,null,null,null,null,"Eingang OE 5240"]
[]
[null,null,null,null,null,"Basisdatum"]
["Laufende Rechnungs-Nr.:"]
[null,null,null,null,null,"Leistungsbestätigung (durch Fachabteilung)"]
[]
[null,null,null,null,null,"OE                 Datum                  Name"]
[]
["Tag der Arbeitsaufnahme:",null,null,null,null,"Sachl. rechn. richtig   (durch FiVa)"]
["(bei erster Vorauszahlungsanforderung bitte angeben)",null,null,null,null,"OE                 Datum                  Name"]
[]
["Vertragsnummer",null,"Projektbearb.-Nr./Kostenstelle",null,null,null,"Abrechnungszeitraum",null,null,"Rechnungsdatum"]
[]
["Projektkurzbezeichnung",null,null,null,null,null,"Land",null,"Leistungsort (gem. Vertrag)"]
[]
["Rechnung vollst. am:",null,null,null,null,null,null,"Für GIZ reserviert"]
["AVB §","Preis-\nblatt ","Vergütungsposition (Nettobeträge)",null,"Währung:"]
[null,"1","Milestone Nr. xx / Pauschalfestpreis "]
["3.3.1","2.1","Honorar",null,{"$f":"IFERROR(SUM(INDIRECT(\"'Honorare (2)'!E34\"))+Honorare!E34,Honorare!E34)+IFERROR(SUM(INDIRECT(\"'Honorare (3)'!E34\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Honorare (4)'!E34\"))+0,0)","v":0}]
["3.3.2","2.2","Vertragsbed. Kosten",null,{"$f":"IFERROR(SUM(INDIRECT(\"'Vertragsbed.Kosten (2)'!E27\"))+Vertragsbed.Kosten!E27,Vertragsbed.Kosten!E27)+IFERROR(SUM(INDIRECT(\"'Vertragsbed.Kosten (3)'!E27\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Vertragsbed.Kosten (4)'!E27\"))+0,0)","v":0}]
["3.3.3","2.3","Einsatz von nationalem Personal",null,{"$f":"'Nationales Personal'!H28","v":0}]
["3.3.4.1","3","Flugkosten",null,{"$f":"IFERROR(SUM(INDIRECT(\"'Reisekosten (2)'!J43\"))+Reisekosten!J43,Reisekosten!J43)+IFERROR(SUM(INDIRECT(\"'Reisekosten (3)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (4)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (5)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (6)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (7)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (8)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (9)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (10)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (11)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (12)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (13)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (14)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (15)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (16)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (17)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (18)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (19)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (20)'!J43\"))+0,0)","v":0}]
["3.3.4.1","3","Transport",null,{"$f":"IFERROR(SUM(INDIRECT(\"'Reisekosten (2)'!J46\"))+Reisekosten!J46,Reisekosten!J46)+IFERROR(SUM(INDIRECT(\"'Reisekosten (3)'!J46\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (4)'!J46\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (5)'!J46\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (6)'!J46\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (7)'!J46\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (8)'!J46\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (9)'!J46\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (10)'!J46\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (11)'!J46\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (12)'!J46\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (13)'!J46\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (14)'!J46\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (15)'!J46\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (16)'!J46\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (17)'!J46\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (18)'!J46\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (19)'!J46\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (20)'!J46\"))+0,0)","v":0}]
["3.3.4.2","3","Tagegeld",null,{"$f":"IFERROR(SUM(INDIRECT(\"'Reisekosten (2)'!J44\"))+Reisekosten!J44,Reisekosten!J44)+IFERROR(SUM(INDIRECT(\"'Reisekosten (3)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (4)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (5)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (6)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (7)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (8)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (9)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (10)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (11)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (12)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (13)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (14)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (15)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (16)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (17)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (18)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (19)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (20)'!J44\"))+0,0)","v":0}]
["3.3.4.3","3","Übernachtungsgeld",null,{"$f":"IFERROR(SUM(INDIRECT(\"'Reisekosten (2)'!J45\"))+Reisekosten!J45,Reisekosten!J45)+IFERROR(SUM(INDIRECT(\"'Reisekosten (3)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (4)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (5)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (6)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (7)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (8)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (9)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (10)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (11)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (12)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (13)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (14)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (15)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (16)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (17)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (18)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (19)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (20)'!J45\"))+0,0)","v":0}]
["3.3.4.4","3","Sonstige Reisekosten",null,{"$f":"IFERROR(SUM(INDIRECT(\"'Reisekosten (2)'!J47\"))+Reisekosten!J47,Reisekosten!J47)+IFERROR(SUM(INDIRECT(\"'Reisekosten (3)'!J47\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (4)'!J47\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (5)'!J47\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (6)'!J47\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (7)'!J47\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (8)'!J47\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (9)'!J47\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (10)'!J47\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (11)'!J47\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (12)'!J47\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (13)'!J47\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (14)'!J47\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (15)'!J47\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (16)'!J47\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (17)'!J47\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (18)'!J47\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (19)'!J47\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Reisekosten (20)'!J47\"))+0,0)","v":0}]
["3.3.5.1","4","Unteraufträge",null,{"$f":"SUM(Unteraufträge!G33)","v":0}]
["3.3.5.2","4","Ausrüstungsgüter",null,{"$f":"IFERROR(SUM(INDIRECT(\"'Ausrüstungsgüter (2)'!H41\"))+Ausrüstungsgüter!H41,Ausrüstungsgüter!H41)+IFERROR(SUM(INDIRECT(\"'Ausrüstungsgüter (3)'!H41\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Ausrüstungsgüter (4)'!H41\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Ausrüstungsgüter (5)'!H41\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Ausrüstungsgüter (6)'!H41\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Ausrüstungsgüter (7)'!H41\"))+0,0)","v":0},null,null,null,null,null,null,null,"Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH Bonn                    \nFriedrich-Ebert-Allee 40\n53113 Bonn"]
["3.3.5.3","4","Betriebskosten im Einsatzland",null,{"$f":"IFERROR(SUM(INDIRECT(\"'Betriebskosten (2)'!D52\"))+Betriebskosten!D52,Betriebskosten!D52)+IFERROR(SUM(INDIRECT(\"'Betriebskosten (3)'!D52\"))+0,0)","v":0},null,null,null,null,null,null,null,"Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH Eschborn              \nDag-Hammarskjöld-Weg 1-5\n65760 Eschborn"]
["3.3.5.4","4","Workshops/Aus- und Fortbildungen",null,{"$f":"IFERROR(SUM(INDIRECT(\"'WS und FB (2)'!G38\"))+'WS und FB'!G38,'WS und FB'!G38)+IFERROR(SUM(INDIRECT(\"'WS und FB (3)'!G38\"))+0,0)+IFERROR(SUM(INDIRECT(\"'WS und FB (4)'!G38\"))+0,0)+IFERROR(SUM(INDIRECT(\"'WS und FB (5)'!G38\"))+0,0)+IFERROR(SUM(INDIRECT(\"'WS und FB (6)'!G38\"))+0,0)+IFERROR(SUM(INDIRECT(\"'WS und FB (7)'!G38\"))+0,0)+IFERROR(SUM(INDIRECT(\"'WS und FB (8)'!G38\"))+0,0)+IFERROR(SUM(INDIRECT(\"'WS und FB (9)'!G38\"))+0,0)+IFERROR(SUM(INDIRECT(\"'WS und FB (10)'!G38\"))+0,0)","v":0}]
["3.3.5.5","4","Örtliche Zuschüsse",null,{"$f":"IFERROR(SUM(INDIRECT(\"'Zuschüsse (2)'!G23\"))+Zuschüsse!G23,Zuschüsse!G23)+IFERROR(SUM(INDIRECT(\"'Zuschüsse (3)'!G23\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Zuschüsse (4)'!G23\"))+0,0)","v":0}]
["3.3.5.6","4","Sonstige Kosten",null,{"$f":"IFERROR(SUM(INDIRECT(\"'Sonstige_Kosten (2)'!D57\"))+Sonstige_Kosten!D57,Sonstige_Kosten!D57)+IFERROR(SUM(INDIRECT(\"'Sonstige_Kosten (3)'!D57\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Sonstige_Kosten (4)'!D57\"))+0,0)","v":0}]
["3.3.5.7","4","Flexible Vergütungsposition",null,{"$f":"'Flexible Vergütungspos.'!E18","v":0}]
[null,null,"Rechnungsbetrag",null,"netto",{"$f":"SUM(E33:G48)","v":0}]
[null,null,"+ Umsatzsteuer (%)",null,null,{"$f":"SUM(F49*E50)","v":0}]
[null,null,"Rechnungsbetrag",null,"brutto",{"$f":"SUM(F49:G50)","v":0}]
["3.6.2",null,"./. Sicherheitseinbehalt von Kosten",null,"netto"]
[null,null,"./. Ust. Von Sicherheitsbehalt (%)",null,null,{"$f":"SUM(F52*E53)","v":0}]
[null,null,"Zwischensumme",null,null,{"$f":"SUM(F51)-(F52)-(F53)","v":0}]
["3.5.4",null,"+ Vorauszahlung",null,"netto"]
[null,null,"+ Ust. (%)",null,null,{"$f":"SUM(F55*E56)","v":0}]
["3.5.4",null,"./. Vorauszahlung (Tilgung)",null,"netto"]
[null,null,"./. Ust.  (%)",null,null,{"$f":"SUM(F57*E58)","v":0}]
[null,null,"ZAHLUNGSBETRAG",null,null,{"$f":"F54+F55+F56-F57-F58","v":0}]
[]
[]
["Ansprechpartner",null,"Telefon",null,"E-Mail"]
[]
["Alle Angaben wurden wahrheitsgemäß gemacht und die in Rechnung gestellten Aufwendungen und Kosten wurden weder bei einer dritten Partei abgerechnet noch in Rechnung gestellt."]

{"sheet":"Summen","index":1,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Fachkraft","Honorar (Nr. 5.4 AVB)","Tagegeld (Nr. 5.6. AVB)","Übernachtungsgeld (Nr. 5.7 AVB)","Flugkosten (Nr. 5.8 AVB)","Andere Reisekosten (Nr. 5.9 AVB)","Andere Reisekosten Monat","Übersiedlungsgut (Nr. 5.10. AVB)"]
[1,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[2,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[3,{"$f":"'Fachkraftblatt (3)'!G22","v":0},{"$f":"'Fachkraftblatt (3)'!G23","v":0},{"$f":"'Fachkraftblatt (3)'!G24","v":0},{"$f":"'Fachkraftblatt (3)'!H37","v":0},{"$f":"'Fachkraftblatt (3)'!H46","v":0},{"$f":"'Fachkraftblatt (3)'!H53","v":0},{"$f":"'Fachkraftblatt (3)'!E57","v":0}]
[4,{"$f":"'Fachkraftblatt (4)'!G22","v":0},{"$f":"'Fachkraftblatt (4)'!G23","v":0},{"$f":"'Fachkraftblatt (4)'!G24","v":0},{"$f":"'Fachkraftblatt (4)'!H37","v":0},{"$f":"'Fachkraftblatt (4)'!H46","v":0},{"$f":"'Fachkraftblatt (4)'!H53","v":0},{"$f":"'Fachkraftblatt (4)'!E57","v":0}]
[5,{"$f":"'Fachkraftblatt (5)'!G22","v":0},{"$f":"'Fachkraftblatt (5)'!G23","v":0},{"$f":"'Fachkraftblatt (5)'!G24","v":0},{"$f":"'Fachkraftblatt (5)'!H37","v":0},{"$f":"'Fachkraftblatt (5)'!H46","v":0},{"$f":"'Fachkraftblatt (5)'!H53","v":0},{"$f":"'Fachkraftblatt (5)'!E57","v":0}]
[6,{"$f":"'Fachkraftblatt (6)'!G22","v":0},{"$f":"'Fachkraftblatt (6)'!G23","v":0},{"$f":"'Fachkraftblatt (6)'!G24","v":0},{"$f":"'Fachkraftblatt (6)'!H37","v":0},{"$f":"'Fachkraftblatt (6)'!H46","v":0},{"$f":"'Fachkraftblatt (6)'!H53","v":0},{"$f":"'Fachkraftblatt (6)'!E57","v":0}]
[7,{"$f":"'Fachkraftblatt (7)'!G22","v":0},{"$f":"'Fachkraftblatt (7)'!G23","v":0},{"$f":"'Fachkraftblatt (7)'!G24","v":0},{"$f":"'Fachkraftblatt (7)'!H37","v":0},{"$f":"'Fachkraftblatt (7)'!H46","v":0},{"$f":"'Fachkraftblatt (7)'!H53","v":0},{"$f":"'Fachkraftblatt (7)'!E57","v":0}]
[8,{"$f":"'Fachkraftblatt (8)'!G22","v":0},{"$f":"'Fachkraftblatt (8)'!G23","v":0},{"$f":"'Fachkraftblatt (8)'!G24","v":0},{"$f":"'Fachkraftblatt (8)'!H37","v":0},{"$f":"'Fachkraftblatt (8)'!H46","v":0},{"$f":"'Fachkraftblatt (8)'!H53","v":0},{"$f":"'Fachkraftblatt (8)'!E57","v":0}]
[9,{"$f":"'Fachkraftblatt (9)'!G22","v":0},{"$f":"'Fachkraftblatt (9)'!G23","v":0},{"$f":"'Fachkraftblatt (9)'!G24","v":0},{"$f":"'Fachkraftblatt (9)'!H37","v":0},{"$f":"'Fachkraftblatt (9)'!H46","v":0},{"$f":"'Fachkraftblatt (9)'!H53","v":0},{"$f":"'Fachkraftblatt (9)'!E57","v":0}]
[10,{"$f":"'Fachkraftblatt (10)'!G22","v":0},{"$f":"'Fachkraftblatt (10)'!G23","v":0},{"$f":"'Fachkraftblatt (10)'!G24","v":0},{"$f":"'Fachkraftblatt (10)'!H37","v":0},{"$f":"'Fachkraftblatt (10)'!H46","v":0},{"$f":"'Fachkraftblatt (10)'!H53","v":0},{"$f":"'Fachkraftblatt (10)'!E57","v":0}]
["Summe",{"$f":"SUM(B2:B11)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(G2:G11)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[]
[null,{"$f":"B12+C12+D12+E12+F12","v":{"$error":"#REF!"}}]

{"sheet":"Honorare","index":2,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,5],[3,3,3,4],[3,1,3,2]]}
["AVB 3.3.1 Honorarsatz  "]
["(gemäß verpflichtendem Zeitnachweis - Grundlage AVB Zifer 3.5.2)"]
["Vertragsnummer:",null,"Bearbeitungsnr./Kst.:",null,"Abrechnungszeitraum:"]
[{"$f":"'Übersicht Rechnung'!A28:B28","v":0},{"$f":"'Übersicht Rechnung'!C28","v":0},null,{"$f":"'Übersicht Rechnung'!G28","v":0}]
[]
["Position","Name","Menge FKT","Vergütung","Summe","Erläuterung "]
[null,null,null,null,{"$f":"C7*D7","v":0}]
[null,null,null,null,{"$f":"C8*D8","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
["Gesamt",null,null,{"$f":"'Übersicht Rechnung'!G32","v":0},{"$f":"SUM(E7:E33)","v":0}]

{"sheet":"Fachkraftblatt (3)","index":3,"n_rows":136,"n_cols":40,"rows_kept":136,"cut":false,"hidden":true,"merged":[[52,3,52,4],[52,8,52,13],[8,2,9,4],[11,9,11,13],[5,15,7,15],[6,2,6,4],[6,7,6,8],[6,9,6,10],[6,11,6,12],[6,13,6,14],[7,2,7,4],[11,14,11,16],[13,9,13,13],[13,14,13,16],[14,9,14,13],[14,14,14,16],[1,3,1,4],[1,7,1,9],[5,7,5,8],[5,9,5,12],[5,13,5,14],[12,9,12,13],[12,14,12,16],[15,9,15,13],[15,14,15,16],[19,3,20,3],[19,4,19,5],[19,6,20,6],[19,7,20,13],[19,14,19,16],[23,7,23,13],[23,14,23,16],[16,9,16,13],[16,14,16,16],[16,20,16,21],[18,7,18,13],[18,14,18,16],[20,14,20,16],[21,7,21,13],[21,14,21,16],[22,7,22,13],[22,14,22,16],[26,8,26,15],[28,1,29,1],[28,3,28,5],[28,7,29,7],[28,8,29,13],[28,14,29,15],[30,8,30,13],[30,14,30,15],[31,8,31,13],[31,14,31,15],[32,8,32,13],[32,14,32,15],[33,8,33,13],[33,14,33,15],[34,8,34,13],[34,14,34,15],[35,8,35,13],[35,14,35,15],[45,3,45,4],[45,8,45,13],[36,3,36,4],[36,8,36,13],[36,14,36,15],[38,11,38,13],[39,3,40,3],[39,4,40,4],[39,6,40,6],[39,7,40,7],[39,8,40,13],[40,14,40,15],[48,5,49,5],[48,6,49,6],[41,8,41,13],[42,8,42,13],[43,8,43,13],[44,8,44,13],[56,0,56,1],[56,5,56,8],[56,9,56,11],[57,12,57,14],[48,8,49,13],[48,14,49,15],[50,3,50,4],[50,8,50,13],[51,3,51,4],[51,8,51,13],[48,7,49,7],[55,5,55,8],[55,9,55,11],[48,0,49,0],[48,1,48,2],[48,3,49,4]]}
["Nachweis über den Personaleinsatz (3)"]
[null,"Vertragsnummer:",null,"Bearbeitungsnr./Kst.:",null,null,null,"Abrechnungszeitraum:"]
[null,{"$f":"'Übersicht Rechnung'!A28","v":0},null,null,{"$f":"'Übersicht Rechnung'!C28","v":0},null,null,null,null,{"$f":"'Übersicht Rechnung'!G28","v":0}]
[]
[]
["Persönliche Daten",null,null,null,null,null,"Einsatzzeiten","Gesamtsollzeit",null,"Abrechnungszeitraum ",null,null,null,"Istzeit ",null,"Bemerkungen"]
["Name, Vorname:",null,null,null,null,null,null,"nach Vertrag",null,"Ist-Zeitraum",null,"Zeitraum",null,"insgesamt"]
["Funktion:",null,"bitte wählen",null,null,null,null,"Monate","Tage","tt/mm/jj","tt/mm/jj","Monate","Tage","Monate","Tage"]
["Funktionsbeschreibung",null,null,null,null,null,"Inland"]
[null,null,null,null,null,null,"Ausland"]
[]
[null,null,null,null,null,null,"Angaben zu Urlaub und Krankheit",null,null,"Bemerkungen",null,null,null,null,"Für GIZ reserviert"]
[null,null,null,null,null,null,"Anspruch gesamt Vertrag (Tage)"]
[null,null,null,null,null,null,"Restanspruch (Tage)"]
[null,null,null,null,null,null,"genommener Urlaub (Tage)"]
[null,null,null,null,null,null,"Resturlaub (Tage)",null,{"$f":"IF(I14>0,I14-I15,I13-I15)","v":0}]
[null,null,null,null,null,null,"Krankheit (Tage)"]
[]
["Personalkosten",null,null,null,null,null,null,null,null,null,null,null,null,null,"Für GIZ reserviert"]
[null,null,null,"Monatssatz\ngemäß Vertrag","Menge",null,"Betrag ","Bemerkungen"]
["Vergütungsposition",null,null,null,"Monate","Tage"]
["Honorar (Nr. 5.4 AVB)",null,null,null,null,null,{"$f":"SUM((D22*E22)+(D22*ROUND(F22/30,3)))","v":0}]
["Tagegeld (Nr. 5.6. AVB)",null,null,null,null,null,{"$f":"SUM((D23*E23)+(D23*ROUND(F23/30,3)))","v":0}]
["Übernachtungsgeld (Nr. 5.7 AVB)",null,null,null,null,null,{"$f":"SUM((D24*E24)+(D24*ROUND(F24/30,3)))","v":0}]
[]
[]
["Reisekosten"]
["Flugkosten (Nr. 5.8 AVB)"]
[null,"Name Reisender\n(nur wenn Angehörige reisen erforderlich)",null,"Reisedaten",null,null,null,"Betrag ","Bemerkungen",null,null,null,null,null,"Für GIZ reserviert"]
["Nr.",null,"Flugart","Reiseziel","Hinflug \n(tt/mm/jj)","Rückflug (tt/mm/jj)","Erstattungsart"]
[1,null,"bitte wählen",null,null,null,"bitte wählen",0]
[2,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
["SUMME",null,null,null,null,null,null,{"$f":"SUM(H31:H36)","v":0}]
[]
["Andere Reisekosten (Nr. 5.9 AVB)"]
[null,null,null,"Beginn (tt/mm/jj)","Ende \n(tt/mm/jj)","Anlass ","Erstattungsart","Betrag ","Bemerkungen"]
["Nr.","Reiseland","Art der Reisekosten",null,null,"der Reise",null,null,null,null,null,null,null,null,"Für GIZ reserviert"]
[1,null,"bitte wählen",null,null,null,"bitte wählen",0]
[2,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
["SUMME",null,null,null,null,null,null,{"$f":"SUM(H42:H45)","v":0}]
[]
["Andere Reisekosten (Nr. 5.9 AVB) MONATSPAUSCHALE"]
["Nr.","Abrechnungszeitraum",null,"Art der Reisekosten",null,"Erstattungsart","Preis","Betrag","Bemerkungen",null,null,null,null,null,"Für GIZ reserviert"]
[null,"Monate","Tage"]
[1,null,null,"bitte wählen",null,"Pauschal/Monat",0,{"$f":"B51*G51+ROUND((C51/30),3)*G51","v":0}]
[2,null,null,null,null,"Pauschal/Monat",null,{"$f":"B52*G52+ROUND((C52/30),3)*G52","v":0}]
["Summe",null,null,null,null,null,null,{"$f":"SUM(H51:H52)","v":0}]
[]
["Übersiedlungsgut (Nr. 5.10. AVB)"]
["Pauschale (in Vertragswährung)",null,"Menge","Preis ","Betrag","Bemerkungen",null,null,null,"Für GIZ reserviert"]
[null,null,1,null,{"$f":"D57*C57","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Summe Personaleinsatz 1",null,null,{"$f":"SUM(E57,H46,H37,G22,G23,G24,H51,H52)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fachkraft (Aus- und Rückreise)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Angehörige (Aus- und Rückreise) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urlaubsflüge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regionale und nationale Flüge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weitere Flüge"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pauschal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gegen Nachweis"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langzeitfachkraft int."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langzeitfachkraft reg."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langzeitfachkraft nat."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kurzzeitfachkraft int."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kurzzeitfachkraft reg."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kurzzeitfachkraft nat."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"andere (bitte angeben)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auslandsreisekosten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inlandsreisekosten"]

{"sheet":"Fachkraftblatt (4)","index":4,"n_rows":136,"n_cols":40,"rows_kept":136,"cut":false,"hidden":true,"merged":[[52,3,52,4],[52,8,52,13],[8,2,9,4],[11,9,11,13],[5,15,7,15],[6,2,6,4],[6,7,6,8],[6,9,6,10],[6,11,6,12],[6,13,6,14],[7,2,7,4],[11,14,11,16],[13,9,13,13],[13,14,13,16],[14,9,14,13],[14,14,14,16],[1,3,1,4],[1,7,1,9],[5,7,5,8],[5,9,5,12],[5,13,5,14],[12,9,12,13],[12,14,12,16],[15,9,15,13],[15,14,15,16],[19,3,20,3],[19,4,19,5],[19,6,20,6],[19,7,20,13],[19,14,19,16],[23,7,23,13],[23,14,23,16],[16,9,16,13],[16,14,16,16],[16,20,16,21],[18,7,18,13],[18,14,18,16],[20,14,20,16],[21,7,21,13],[21,14,21,16],[22,7,22,13],[22,14,22,16],[26,8,26,15],[28,1,29,1],[28,3,28,5],[28,7,29,7],[28,8,29,13],[28,14,29,15],[30,8,30,13],[30,14,30,15],[31,8,31,13],[31,14,31,15],[32,8,32,13],[32,14,32,15],[33,8,33,13],[33,14,33,15],[34,8,34,13],[34,14,34,15],[35,8,35,13],[35,14,35,15],[45,3,45,4],[45,8,45,13],[36,3,36,4],[36,8,36,13],[36,14,36,15],[38,11,38,13],[39,3,40,3],[39,4,40,4],[39,6,40,6],[39,7,40,7],[39,8,40,13],[40,14,40,15],[48,5,49,5],[48,6,49,6],[41,8,41,13],[42,8,42,13],[43,8,43,13],[44,8,44,13],[56,0,56,1],[56,5,56,8],[56,9,56,11],[57,12,57,14],[48,8,49,13],[48,14,49,15],[50,3,50,4],[50,8,50,13],[51,3,51,4],[51,8,51,13],[48,7,49,7],[55,5,55,8],[55,9,55,11],[48,0,49,0],[48,1,48,2],[48,3,49,4]]}
["Nachweis über den Personaleinsatz (4)"]
[null,"Vertragsnummer:",null,"Bearbeitungsnr./Kst.:",null,null,null,"Abrechnungszeitraum:"]
[null,{"$f":"'Übersicht Rechnung'!A28","v":0},null,null,{"$f":"'Übersicht Rechnung'!C28","v":0},null,null,null,null,{"$f":"'Übersicht Rechnung'!G28","v":0}]
[]
[]
["Persönliche Daten",null,null,null,null,null,"Einsatzzeiten","Gesamtsollzeit",null,"Abrechnungszeitraum ",null,null,null,"Istzeit ",null,"Bemerkungen"]
["Name, Vorname:",null,null,null,null,null,null,"nach Vertrag",null,"Ist-Zeitraum",null,"Zeitraum",null,"insgesamt"]
["Funktion:",null,"bitte wählen",null,null,null,null,"Monate","Tage","tt/mm/jj","tt/mm/jj","Monate","Tage","Monate","Tage"]
["Funktionsbeschreibung",null,null,null,null,null,"Inland"]
[null,null,null,null,null,null,"Ausland"]
[]
[null,null,null,null,null,null,"Angaben zu Urlaub und Krankheit",null,null,"Bemerkungen",null,null,null,null,"Für GIZ reserviert"]
[null,null,null,null,null,null,"Anspruch gesamt Vertrag (Tage)"]
[null,null,null,null,null,null,"Restanspruch (Tage)"]
[null,null,null,null,null,null,"genommener Urlaub (Tage)"]
[null,null,null,null,null,null,"Resturlaub (Tage)",null,{"$f":"IF(I14>0,I14-I15,I13-I15)","v":0}]
[null,null,null,null,null,null,"Krankheit (Tage)"]
[]
["Personalkosten",null,null,null,null,null,null,null,null,null,null,null,null,null,"Für GIZ reserviert"]
[null,null,null,"Monatssatz\ngemäß Vertrag","Menge",null,"Betrag ","Bemerkungen"]
["Vergütungsposition",null,null,null,"Monate","Tage"]
["Honorar (Nr. 5.4 AVB)",null,null,null,null,null,{"$f":"SUM((D22*E22)+(D22*ROUND(F22/30,3)))","v":0}]
["Tagegeld (Nr. 5.6. AVB)",null,null,null,null,null,{"$f":"SUM((D23*E23)+(D23*ROUND(F23/30,3)))","v":0}]
["Übernachtungsgeld (Nr. 5.7 AVB)",null,null,null,null,null,{"$f":"SUM((D24*E24)+(D24*ROUND(F24/30,3)))","v":0}]
[]
[]
["Reisekosten"]
["Flugkosten (Nr. 5.8 AVB)"]
[null,"Name Reisender\n(nur wenn Angehörige reisen erforderlich)",null,"Reisedaten",null,null,null,"Betrag ","Bemerkungen",null,null,null,null,null,"Für GIZ reserviert"]
["Nr.",null,"Flugart","Reiseziel","Hinflug \n(tt/mm/jj)","Rückflug (tt/mm/jj)","Erstattungsart"]
[1,null,"bitte wählen",null,null,null,"bitte wählen",0]
[2,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
["SUMME",null,null,null,null,null,null,{"$f":"SUM(H31:H36)","v":0}]
[]
["Andere Reisekosten (Nr. 5.9 AVB)"]
[null,null,null,"Beginn (tt/mm/jj)","Ende \n(tt/mm/jj)","Anlass ","Erstattungsart","Betrag ","Bemerkungen"]
["Nr.","Reiseland","Art der Reisekosten",null,null,"der Reise",null,null,null,null,null,null,null,null,"Für GIZ reserviert"]
[1,null,"bitte wählen",null,null,null,"bitte wählen",0]
[2,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
["SUMME",null,null,null,null,null,null,{"$f":"SUM(H42:H45)","v":0}]
[]
["Andere Reisekosten (Nr. 5.9 AVB) MONATSPAUSCHALE"]
["Nr.","Abrechnungszeitraum",null,"Art der Reisekosten",null,"Erstattungsart","Preis","Betrag","Bemerkungen",null,null,null,null,null,"Für GIZ reserviert"]
[null,"Monate","Tage"]
[1,null,null,"bitte wählen",null,"Pauschal/Monat",0,{"$f":"B51*G51+ROUND((C51/30),3)*G51","v":0}]
[2,null,null,null,null,"Pauschal/Monat",null,{"$f":"B52*G52+ROUND((C52/30),3)*G52","v":0}]
["Summe",null,null,null,null,null,null,{"$f":"SUM(H51:H52)","v":0}]
[]
["Übersiedlungsgut (Nr. 5.10. AVB)"]
["Pauschale (in Vertragswährung)",null,"Menge","Preis ","Betrag","Bemerkungen",null,null,null,"Für GIZ reserviert"]
[null,null,1,null,{"$f":"D57*C57","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Summe Personaleinsatz 1",null,null,{"$f":"SUM(E57,H46,H37,G22,G23,G24,H51,H52)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fachkraft (Aus- und Rückreise)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Angehörige (Aus- und Rückreise) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urlaubsflüge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regionale und nationale Flüge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weitere Flüge"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pauschal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gegen Nachweis"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langzeitfachkraft int."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langzeitfachkraft reg."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langzeitfachkraft nat."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kurzzeitfachkraft int."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kurzzeitfachkraft reg."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kurzzeitfachkraft nat."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"andere (bitte angeben)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auslandsreisekosten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inlandsreisekosten"]

{"sheet":"Fachkraftblatt (5)","index":5,"n_rows":136,"n_cols":40,"rows_kept":136,"cut":false,"hidden":true,"merged":[[52,3,52,4],[52,8,52,13],[8,2,9,4],[11,9,11,13],[5,15,7,15],[6,2,6,4],[6,7,6,8],[6,9,6,10],[6,11,6,12],[6,13,6,14],[7,2,7,4],[11,14,11,16],[13,9,13,13],[13,14,13,16],[14,9,14,13],[14,14,14,16],[1,3,1,4],[1,7,1,9],[5,7,5,8],[5,9,5,12],[5,13,5,14],[12,9,12,13],[12,14,12,16],[15,9,15,13],[15,14,15,16],[19,3,20,3],[19,4,19,5],[19,6,20,6],[19,7,20,13],[19,14,19,16],[23,7,23,13],[23,14,23,16],[16,9,16,13],[16,14,16,16],[16,20,16,21],[18,7,18,13],[18,14,18,16],[20,14,20,16],[21,7,21,13],[21,14,21,16],[22,7,22,13],[22,14,22,16],[26,8,26,15],[28,1,29,1],[28,3,28,5],[28,7,29,7],[28,8,29,13],[28,14,29,15],[30,8,30,13],[30,14,30,15],[31,8,31,13],[31,14,31,15],[32,8,32,13],[32,14,32,15],[33,8,33,13],[33,14,33,15],[34,8,34,13],[34,14,34,15],[35,8,35,13],[35,14,35,15],[45,3,45,4],[45,8,45,13],[36,3,36,4],[36,8,36,13],[36,14,36,15],[38,11,38,13],[39,3,40,3],[39,4,40,4],[39,6,40,6],[39,7,40,7],[39,8,40,13],[40,14,40,15],[48,5,49,5],[48,6,49,6],[41,8,41,13],[42,8,42,13],[43,8,43,13],[44,8,44,13],[56,0,56,1],[56,5,56,8],[56,9,56,11],[57,12,57,14],[48,8,49,13],[48,14,49,15],[50,3,50,4],[50,8,50,13],[51,3,51,4],[51,8,51,13],[48,7,49,7],[55,5,55,8],[55,9,55,11],[48,0,49,0],[48,1,48,2],[48,3,49,4]]}
["Nachweis über den Personaleinsatz (5)"]
[null,"Vertragsnummer:",null,"Bearbeitungsnr./Kst.:",null,null,null,"Abrechnungszeitraum:"]
[null,{"$f":"'Übersicht Rechnung'!A28","v":0},null,null,{"$f":"'Übersicht Rechnung'!C28","v":0},null,null,null,null,{"$f":"'Übersicht Rechnung'!G28","v":0}]
[]
[]
["Persönliche Daten",null,null,null,null,null,"Einsatzzeiten","Gesamtsollzeit",null,"Abrechnungszeitraum ",null,null,null,"Istzeit ",null,"Bemerkungen"]
["Name, Vorname:",null,null,null,null,null,null,"nach Vertrag",null,"Ist-Zeitraum",null,"Zeitraum",null,"insgesamt"]
["Funktion:",null,"bitte wählen",null,null,null,null,"Monate","Tage","tt/mm/jj","tt/mm/jj","Monate","Tage","Monate","Tage"]
["Funktionsbeschreibung",null,null,null,null,null,"Inland"]
[null,null,null,null,null,null,"Ausland"]
[]
[null,null,null,null,null,null,"Angaben zu Urlaub und Krankheit",null,null,"Bemerkungen",null,null,null,null,"Für GIZ reserviert"]
[null,null,null,null,null,null,"Anspruch gesamt Vertrag (Tage)"]
[null,null,null,null,null,null,"Restanspruch (Tage)"]
[null,null,null,null,null,null,"genommener Urlaub (Tage)"]
[null,null,null,null,null,null,"Resturlaub (Tage)",null,{"$f":"IF(I14>0,I14-I15,I13-I15)","v":0}]
[null,null,null,null,null,null,"Krankheit (Tage)"]
[]
["Personalkosten",null,null,null,null,null,null,null,null,null,null,null,null,null,"Für GIZ reserviert"]
[null,null,null,"Monatssatz\ngemäß Vertrag","Menge",null,"Betrag ","Bemerkungen"]
["Vergütungsposition",null,null,null,"Monate","Tage"]
["Honorar (Nr. 5.4 AVB)",null,null,null,null,null,{"$f":"SUM((D22*E22)+(D22*ROUND(F22/30,3)))","v":0}]
["Tagegeld (Nr. 5.6. AVB)",null,null,null,null,null,{"$f":"SUM((D23*E23)+(D23*ROUND(F23/30,3)))","v":0}]
["Übernachtungsgeld (Nr. 5.7 AVB)",null,null,null,null,null,{"$f":"SUM((D24*E24)+(D24*ROUND(F24/30,3)))","v":0}]
[]
[]
["Reisekosten"]
["Flugkosten (Nr. 5.8 AVB)"]
[null,"Name Reisender\n(nur wenn Angehörige reisen erforderlich)",null,"Reisedaten",null,null,null,"Betrag ","Bemerkungen",null,null,null,null,null,"Für GIZ reserviert"]
["Nr.",null,"Flugart","Reiseziel","Hinflug \n(tt/mm/jj)","Rückflug (tt/mm/jj)","Erstattungsart"]
[1,null,"bitte wählen",null,null,null,"bitte wählen",0]
[2,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
["SUMME",null,null,null,null,null,null,{"$f":"SUM(H31:H36)","v":0}]
[]
["Andere Reisekosten (Nr. 5.9 AVB)"]
[null,null,null,"Beginn (tt/mm/jj)","Ende \n(tt/mm/jj)","Anlass ","Erstattungsart","Betrag ","Bemerkungen"]
["Nr.","Reiseland","Art der Reisekosten",null,null,"der Reise",null,null,null,null,null,null,null,null,"Für GIZ reserviert"]
[1,null,"bitte wählen",null,null,null,"bitte wählen",0]
[2,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
["SUMME",null,null,null,null,null,null,{"$f":"SUM(H42:H45)","v":0}]
[]
["Andere Reisekosten (Nr. 5.9 AVB) MONATSPAUSCHALE"]
["Nr.","Abrechnungszeitraum",null,"Art der Reisekosten",null,"Erstattungsart","Preis","Betrag","Bemerkungen",null,null,null,null,null,"Für GIZ reserviert"]
[null,"Monate","Tage"]
[1,null,null,"bitte wählen",null,"Pauschal/Monat",0,{"$f":"B51*G51+ROUND((C51/30),3)*G51","v":0}]
[2,null,null,null,null,"Pauschal/Monat",null,{"$f":"B52*G52+ROUND((C52/30),3)*G52","v":0}]
["Summe",null,null,null,null,null,null,{"$f":"SUM(H51:H52)","v":0}]
[]
["Übersiedlungsgut (Nr. 5.10. AVB)"]
["Pauschale (in Vertragswährung)",null,"Menge","Preis ","Betrag","Bemerkungen",null,null,null,"Für GIZ reserviert"]
[null,null,1,null,{"$f":"D57*C57","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Summe Personaleinsatz 1",null,null,{"$f":"SUM(E57,H46,H37,G22,G23,G24,H51,H52)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fachkraft (Aus- und Rückreise)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Angehörige (Aus- und Rückreise) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urlaubsflüge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regionale und nationale Flüge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weitere Flüge"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pauschal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gegen Nachweis"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langzeitfachkraft int."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langzeitfachkraft reg."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langzeitfachkraft nat."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kurzzeitfachkraft int."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kurzzeitfachkraft reg."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kurzzeitfachkraft nat."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"andere (bitte angeben)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auslandsreisekosten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inlandsreisekosten"]

{"sheet":"Fachkraftblatt (6)","index":6,"n_rows":136,"n_cols":40,"rows_kept":136,"cut":false,"hidden":true,"merged":[[52,3,52,4],[52,8,52,13],[8,2,9,4],[11,9,11,13],[5,15,7,15],[6,2,6,4],[6,7,6,8],[6,9,6,10],[6,11,6,12],[6,13,6,14],[7,2,7,4],[11,14,11,16],[13,9,13,13],[13,14,13,16],[14,9,14,13],[14,14,14,16],[1,3,1,4],[1,7,1,9],[5,7,5,8],[5,9,5,12],[5,13,5,14],[12,9,12,13],[12,14,12,16],[15,9,15,13],[15,14,15,16],[19,3,20,3],[19,4,19,5],[19,6,20,6],[19,7,20,13],[19,14,19,16],[23,7,23,13],[23,14,23,16],[16,9,16,13],[16,14,16,16],[16,20,16,21],[18,7,18,13],[18,14,18,16],[20,14,20,16],[21,7,21,13],[21,14,21,16],[22,7,22,13],[22,14,22,16],[26,8,26,15],[28,1,29,1],[28,3,28,5],[28,7,29,7],[28,8,29,13],[28,14,29,15],[30,8,30,13],[30,14,30,15],[31,8,31,13],[31,14,31,15],[32,8,32,13],[32,14,32,15],[33,8,33,13],[33,14,33,15],[34,8,34,13],[34,14,34,15],[35,8,35,13],[35,14,35,15],[45,3,45,4],[45,8,45,13],[36,3,36,4],[36,8,36,13],[36,14,36,15],[38,11,38,13],[39,3,40,3],[39,4,40,4],[39,6,40,6],[39,7,40,7],[39,8,40,13],[40,14,40,15],[48,5,49,5],[48,6,49,6],[41,8,41,13],[42,8,42,13],[43,8,43,13],[44,8,44,13],[56,0,56,1],[56,5,56,8],[56,9,56,11],[57,12,57,14],[48,8,49,13],[48,14,49,15],[50,3,50,4],[50,8,50,13],[51,3,51,4],[51,8,51,13],[48,7,49,7],[55,5,55,8],[55,9,55,11],[48,0,49,0],[48,1,48,2],[48,3,49,4]]}
["Nachweis über den Personaleinsatz (6)"]
[null,"Vertragsnummer:",null,"Bearbeitungsnr./Kst.:",null,null,null,"Abrechnungszeitraum:"]
[null,{"$f":"'Übersicht Rechnung'!A28","v":0},null,null,{"$f":"'Übersicht Rechnung'!C28","v":0},null,null,null,null,{"$f":"'Übersicht Rechnung'!G28","v":0}]
[]
[]
["Persönliche Daten",null,null,null,null,null,"Einsatzzeiten","Gesamtsollzeit",null,"Abrechnungszeitraum ",null,null,null,"Istzeit ",null,"Bemerkungen"]
["Name, Vorname:",null,null,null,null,null,null,"nach Vertrag",null,"Ist-Zeitraum",null,"Zeitraum",null,"insgesamt"]
["Funktion:",null,"bitte wählen",null,null,null,null,"Monate","Tage","tt/mm/jj","tt/mm/jj","Monate","Tage","Monate","Tage"]
["Funktionsbeschreibung",null,null,null,null,null,"Inland"]
[null,null,null,null,null,null,"Ausland"]
[]
[null,null,null,null,null,null,"Angaben zu Urlaub und Krankheit",null,null,"Bemerkungen",null,null,null,null,"Für GIZ reserviert"]
[null,null,null,null,null,null,"Anspruch gesamt Vertrag (Tage)"]
[null,null,null,null,null,null,"Restanspruch (Tage)"]
[null,null,null,null,null,null,"genommener Urlaub (Tage)"]
[null,null,null,null,null,null,"Resturlaub (Tage)",null,{"$f":"IF(I14>0,I14-I15,I13-I15)","v":0}]
[null,null,null,null,null,null,"Krankheit (Tage)"]
[]
["Personalkosten",null,null,null,null,null,null,null,null,null,null,null,null,null,"Für GIZ reserviert"]
[null,null,null,"Monatssatz\ngemäß Vertrag","Menge",null,"Betrag ","Bemerkungen"]
["Vergütungsposition",null,null,null,"Monate","Tage"]
["Honorar (Nr. 5.4 AVB)",null,null,null,null,null,{"$f":"SUM((D22*E22)+(D22*ROUND(F22/30,3)))","v":0}]
["Tagegeld (Nr. 5.6. AVB)",null,null,null,null,null,{"$f":"SUM((D23*E23)+(D23*ROUND(F23/30,3)))","v":0}]
["Übernachtungsgeld (Nr. 5.7 AVB)",null,null,null,null,null,{"$f":"SUM((D24*E24)+(D24*ROUND(F24/30,3)))","v":0}]
[]
[]
["Reisekosten"]
["Flugkosten (Nr. 5.8 AVB)"]
[null,"Name Reisender\n(nur wenn Angehörige reisen erforderlich)",null,"Reisedaten",null,null,null,"Betrag ","Bemerkungen",null,null,null,null,null,"Für GIZ reserviert"]
["Nr.",null,"Flugart","Reiseziel","Hinflug \n(tt/mm/jj)","Rückflug (tt/mm/jj)","Erstattungsart"]
[1,null,"bitte wählen",null,null,null,"bitte wählen",0]
[2,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
["SUMME",null,null,null,null,null,null,{"$f":"SUM(H31:H36)","v":0}]
[]
["Andere Reisekosten (Nr. 5.9 AVB)"]
[null,null,null,"Beginn (tt/mm/jj)","Ende \n(tt/mm/jj)","Anlass ","Erstattungsart","Betrag ","Bemerkungen"]
["Nr.","Reiseland","Art der Reisekosten",null,null,"der Reise",null,null,null,null,null,null,null,null,"Für GIZ reserviert"]
[1,null,"bitte wählen",null,null,null,"bitte wählen",0]
[2,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
["SUMME",null,null,null,null,null,null,{"$f":"SUM(H42:H45)","v":0}]
[]
["Andere Reisekosten (Nr. 5.9 AVB) MONATSPAUSCHALE"]
["Nr.","Abrechnungszeitraum",null,"Art der Reisekosten",null,"Erstattungsart","Preis","Betrag","Bemerkungen",null,null,null,null,null,"Für GIZ reserviert"]
[null,"Monate","Tage"]
[1,null,null,"bitte wählen",null,"Pauschal/Monat",0,{"$f":"B51*G51+ROUND((C51/30),3)*G51","v":0}]
[2,null,null,null,null,"Pauschal/Monat",null,{"$f":"B52*G52+ROUND((C52/30),3)*G52","v":0}]
["Summe",null,null,null,null,null,null,{"$f":"SUM(H51:H52)","v":0}]
[]
["Übersiedlungsgut (Nr. 5.10. AVB)"]
["Pauschale (in Vertragswährung)",null,"Menge","Preis ","Betrag","Bemerkungen",null,null,null,"Für GIZ reserviert"]
[null,null,1,null,{"$f":"D57*C57","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Summe Personaleinsatz 1",null,null,{"$f":"SUM(E57,H46,H37,G22,G23,G24,H51,H52)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fachkraft (Aus- und Rückreise)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Angehörige (Aus- und Rückreise) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urlaubsflüge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regionale und nationale Flüge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weitere Flüge"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pauschal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gegen Nachweis"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langzeitfachkraft int."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langzeitfachkraft reg."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langzeitfachkraft nat."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kurzzeitfachkraft int."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kurzzeitfachkraft reg."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kurzzeitfachkraft nat."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"andere (bitte angeben)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auslandsreisekosten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inlandsreisekosten"]

{"sheet":"Fachkraftblatt (7)","index":7,"n_rows":136,"n_cols":40,"rows_kept":136,"cut":false,"hidden":true,"merged":[[52,3,52,4],[52,8,52,13],[8,2,9,4],[11,9,11,13],[5,15,7,15],[6,2,6,4],[6,7,6,8],[6,9,6,10],[6,11,6,12],[6,13,6,14],[7,2,7,4],[11,14,11,16],[13,9,13,13],[13,14,13,16],[14,9,14,13],[14,14,14,16],[1,3,1,4],[1,7,1,9],[5,7,5,8],[5,9,5,12],[5,13,5,14],[12,9,12,13],[12,14,12,16],[15,9,15,13],[15,14,15,16],[19,3,20,3],[19,4,19,5],[19,6,20,6],[19,7,20,13],[19,14,19,16],[23,7,23,13],[23,14,23,16],[16,9,16,13],[16,14,16,16],[16,20,16,21],[18,7,18,13],[18,14,18,16],[20,14,20,16],[21,7,21,13],[21,14,21,16],[22,7,22,13],[22,14,22,16],[26,8,26,15],[28,1,29,1],[28,3,28,5],[28,7,29,7],[28,8,29,13],[28,14,29,15],[30,8,30,13],[30,14,30,15],[31,8,31,13],[31,14,31,15],[32,8,32,13],[32,14,32,15],[33,8,33,13],[33,14,33,15],[34,8,34,13],[34,14,34,15],[35,8,35,13],[35,14,35,15],[45,3,45,4],[45,8,45,13],[36,3,36,4],[36,8,36,13],[36,14,36,15],[38,11,38,13],[39,3,40,3],[39,4,40,4],[39,6,40,6],[39,7,40,7],[39,8,40,13],[40,14,40,15],[48,5,49,5],[48,6,49,6],[41,8,41,13],[42,8,42,13],[43,8,43,13],[44,8,44,13],[56,0,56,1],[56,5,56,8],[56,9,56,11],[57,12,57,14],[48,8,49,13],[48,14,49,15],[50,3,50,4],[50,8,50,13],[51,3,51,4],[51,8,51,13],[48,7,49,7],[55,5,55,8],[55,9,55,11],[48,0,49,0],[48,1,48,2],[48,3,49,4]]}
["Nachweis über den Personaleinsatz (7)"]
[null,"Vertragsnummer:",null,"Bearbeitungsnr./Kst.:",null,null,null,"Abrechnungszeitraum:"]
[null,{"$f":"'Übersicht Rechnung'!A28","v":0},null,null,{"$f":"'Übersicht Rechnung'!C28","v":0},null,null,null,null,{"$f":"'Übersicht Rechnung'!G28","v":0}]
[]
[]
["Persönliche Daten",null,null,null,null,null,"Einsatzzeiten","Gesamtsollzeit",null,"Abrechnungszeitraum ",null,null,null,"Istzeit ",null,"Bemerkungen"]
["Name, Vorname:",null,null,null,null,null,null,"nach Vertrag",null,"Ist-Zeitraum",null,"Zeitraum",null,"insgesamt"]
["Funktion:",null,"bitte wählen",null,null,null,null,"Monate","Tage","tt/mm/jj","tt/mm/jj","Monate","Tage","Monate","Tage"]
["Funktionsbeschreibung",null,null,null,null,null,"Inland"]
[null,null,null,null,null,null,"Ausland"]
[]
[null,null,null,null,null,null,"Angaben zu Urlaub und Krankheit",null,null,"Bemerkungen",null,null,null,null,"Für GIZ reserviert"]
[null,null,null,null,null,null,"Anspruch gesamt Vertrag (Tage)"]
[null,null,null,null,null,null,"Restanspruch (Tage)"]
[null,null,null,null,null,null,"genommener Urlaub (Tage)"]
[null,null,null,null,null,null,"Resturlaub (Tage)",null,{"$f":"IF(I14>0,I14-I15,I13-I15)","v":0}]
[null,null,null,null,null,null,"Krankheit (Tage)"]
[]
["Personalkosten",null,null,null,null,null,null,null,null,null,null,null,null,null,"Für GIZ reserviert"]
[null,null,null,"Monatssatz\ngemäß Vertrag","Menge",null,"Betrag ","Bemerkungen"]
["Vergütungsposition",null,null,null,"Monate","Tage"]
["Honorar (Nr. 5.4 AVB)",null,null,null,null,null,{"$f":"SUM((D22*E22)+(D22*ROUND(F22/30,3)))","v":0}]
["Tagegeld (Nr. 5.6. AVB)",null,null,null,null,null,{"$f":"SUM((D23*E23)+(D23*ROUND(F23/30,3)))","v":0}]
["Übernachtungsgeld (Nr. 5.7 AVB)",null,null,null,null,null,{"$f":"SUM((D24*E24)+(D24*ROUND(F24/30,3)))","v":0}]
[]
[]
["Reisekosten"]
["Flugkosten (Nr. 5.8 AVB)"]
[null,"Name Reisender\n(nur wenn Angehörige reisen erforderlich)",null,"Reisedaten",null,null,null,"Betrag ","Bemerkungen",null,null,null,null,null,"Für GIZ reserviert"]
["Nr.",null,"Flugart","Reiseziel","Hinflug \n(tt/mm/jj)","Rückflug (tt/mm/jj)","Erstattungsart"]
[1,null,"bitte wählen",null,null,null,"bitte wählen",0]
[2,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
["SUMME",null,null,null,null,null,null,{"$f":"SUM(H31:H36)","v":0}]
[]
["Andere Reisekosten (Nr. 5.9 AVB)"]
[null,null,null,"Beginn (tt/mm/jj)","Ende \n(tt/mm/jj)","Anlass ","Erstattungsart","Betrag ","Bemerkungen"]
["Nr.","Reiseland","Art der Reisekosten",null,null,"der Reise",null,null,null,null,null,null,null,null,"Für GIZ reserviert"]
[1,null,"bitte wählen",null,null,null,"bitte wählen",0]
[2,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
["SUMME",null,null,null,null,null,null,{"$f":"SUM(H42:H45)","v":0}]
[]
["Andere Reisekosten (Nr. 5.9 AVB) MONATSPAUSCHALE"]
["Nr.","Abrechnungszeitraum",null,"Art der Reisekosten",null,"Erstattungsart","Preis","Betrag","Bemerkungen",null,null,null,null,null,"Für GIZ reserviert"]
[null,"Monate","Tage"]
[1,null,null,"bitte wählen",null,"Pauschal/Monat",0,{"$f":"B51*G51+ROUND((C51/30),3)*G51","v":0}]
[2,null,null,null,null,"Pauschal/Monat",null,{"$f":"B52*G52+ROUND((C52/30),3)*G52","v":0}]
["Summe",null,null,null,null,null,null,{"$f":"SUM(H51:H52)","v":0}]
[]
["Übersiedlungsgut (Nr. 5.10. AVB)"]
["Pauschale (in Vertragswährung)",null,"Menge","Preis ","Betrag","Bemerkungen",null,null,null,"Für GIZ reserviert"]
[null,null,1,null,{"$f":"D57*C57","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Summe Personaleinsatz 1",null,null,{"$f":"SUM(E57,H46,H37,G22,G23,G24,H51,H52)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fachkraft (Aus- und Rückreise)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Angehörige (Aus- und Rückreise) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urlaubsflüge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regionale und nationale Flüge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weitere Flüge"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pauschal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gegen Nachweis"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langzeitfachkraft int."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langzeitfachkraft reg."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langzeitfachkraft nat."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kurzzeitfachkraft int."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kurzzeitfachkraft reg."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kurzzeitfachkraft nat."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"andere (bitte angeben)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auslandsreisekosten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inlandsreisekosten"]

{"sheet":"Fachkraftblatt (8)","index":8,"n_rows":136,"n_cols":40,"rows_kept":136,"cut":false,"hidden":true,"merged":[[52,3,52,4],[52,8,52,13],[8,2,9,4],[11,9,11,13],[5,15,7,15],[6,2,6,4],[6,7,6,8],[6,9,6,10],[6,11,6,12],[6,13,6,14],[7,2,7,4],[11,14,11,16],[13,9,13,13],[13,14,13,16],[14,9,14,13],[14,14,14,16],[1,3,1,4],[1,7,1,9],[5,7,5,8],[5,9,5,12],[5,13,5,14],[12,9,12,13],[12,14,12,16],[15,9,15,13],[15,14,15,16],[19,3,20,3],[19,4,19,5],[19,6,20,6],[19,7,20,13],[19,14,19,16],[23,7,23,13],[23,14,23,16],[16,9,16,13],[16,14,16,16],[16,20,16,21],[18,7,18,13],[18,14,18,16],[20,14,20,16],[21,7,21,13],[21,14,21,16],[22,7,22,13],[22,14,22,16],[26,8,26,15],[28,1,29,1],[28,3,28,5],[28,7,29,7],[28,8,29,13],[28,14,29,15],[30,8,30,13],[30,14,30,15],[31,8,31,13],[31,14,31,15],[32,8,32,13],[32,14,32,15],[33,8,33,13],[33,14,33,15],[34,8,34,13],[34,14,34,15],[35,8,35,13],[35,14,35,15],[45,3,45,4],[45,8,45,13],[36,3,36,4],[36,8,36,13],[36,14,36,15],[38,11,38,13],[39,3,40,3],[39,4,40,4],[39,6,40,6],[39,7,40,7],[39,8,40,13],[40,14,40,15],[48,5,49,5],[48,6,49,6],[41,8,41,13],[42,8,42,13],[43,8,43,13],[44,8,44,13],[56,0,56,1],[56,5,56,8],[56,9,56,11],[57,12,57,14],[48,8,49,13],[48,14,49,15],[50,3,50,4],[50,8,50,13],[51,3,51,4],[51,8,51,13],[48,7,49,7],[55,5,55,8],[55,9,55,11],[48,0,49,0],[48,1,48,2],[48,3,49,4]]}
["Nachweis über den Personaleinsatz (8)"]
[null,"Vertragsnummer:",null,"Bearbeitungsnr./Kst.:",null,null,null,"Abrechnungszeitraum:"]
[null,{"$f":"'Übersicht Rechnung'!A28","v":0},null,null,{"$f":"'Übersicht Rechnung'!C28","v":0},null,null,null,null,{"$f":"'Übersicht Rechnung'!G28","v":0}]
[]
[]
["Persönliche Daten",null,null,null,null,null,"Einsatzzeiten","Gesamtsollzeit",null,"Abrechnungszeitraum ",null,null,null,"Istzeit ",null,"Bemerkungen"]
["Name, Vorname:",null,null,null,null,null,null,"nach Vertrag",null,"Ist-Zeitraum",null,"Zeitraum",null,"insgesamt"]
["Funktion:",null,"bitte wählen",null,null,null,null,"Monate","Tage","tt/mm/jj","tt/mm/jj","Monate","Tage","Monate","Tage"]
["Funktionsbeschreibung",null,null,null,null,null,"Inland"]
[null,null,null,null,null,null,"Ausland"]
[]
[null,null,null,null,null,null,"Angaben zu Urlaub und Krankheit",null,null,"Bemerkungen",null,null,null,null,"Für GIZ reserviert"]
[null,null,null,null,null,null,"Anspruch gesamt Vertrag (Tage)"]
[null,null,null,null,null,null,"Restanspruch (Tage)"]
[null,null,null,null,null,null,"genommener Urlaub (Tage)"]
[null,null,null,null,null,null,"Resturlaub (Tage)",null,{"$f":"IF(I14>0,I14-I15,I13-I15)","v":0}]
[null,null,null,null,null,null,"Krankheit (Tage)"]
[]
["Personalkosten",null,null,null,null,null,null,null,null,null,null,null,null,null,"Für GIZ reserviert"]
[null,null,null,"Monatssatz\ngemäß Vertrag","Menge",null,"Betrag ","Bemerkungen"]
["Vergütungsposition",null,null,null,"Monate","Tage"]
["Honorar (Nr. 5.4 AVB)",null,null,null,null,null,{"$f":"SUM((D22*E22)+(D22*ROUND(F22/30,3)))","v":0}]
["Tagegeld (Nr. 5.6. AVB)",null,null,null,null,null,{"$f":"SUM((D23*E23)+(D23*ROUND(F23/30,3)))","v":0}]
["Übernachtungsgeld (Nr. 5.7 AVB)",null,null,null,null,null,{"$f":"SUM((D24*E24)+(D24*ROUND(F24/30,3)))","v":0}]
[]
[]
["Reisekosten"]
["Flugkosten (Nr. 5.8 AVB)"]
[null,"Name Reisender\n(nur wenn Angehörige reisen erforderlich)",null,"Reisedaten",null,null,null,"Betrag ","Bemerkungen",null,null,null,null,null,"Für GIZ reserviert"]
["Nr.",null,"Flugart","Reiseziel","Hinflug \n(tt/mm/jj)","Rückflug (tt/mm/jj)","Erstattungsart"]
[1,null,"bitte wählen",null,null,null,"bitte wählen",0]
[2,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
["SUMME",null,null,null,null,null,null,{"$f":"SUM(H31:H36)","v":0}]
[]
["Andere Reisekosten (Nr. 5.9 AVB)"]
[null,null,null,"Beginn (tt/mm/jj)","Ende \n(tt/mm/jj)","Anlass ","Erstattungsart","Betrag ","Bemerkungen"]
["Nr.","Reiseland","Art der Reisekosten",null,null,"der Reise",null,null,null,null,null,null,null,null,"Für GIZ reserviert"]
[1,null,"bitte wählen",null,null,null,"bitte wählen",0]
[2,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
["SUMME",null,null,null,null,null,null,{"$f":"SUM(H42:H45)","v":0}]
[]
["Andere Reisekosten (Nr. 5.9 AVB) MONATSPAUSCHALE"]
["Nr.","Abrechnungszeitraum",null,"Art der Reisekosten",null,"Erstattungsart","Preis","Betrag","Bemerkungen",null,null,null,null,null,"Für GIZ reserviert"]
[null,"Monate","Tage"]
[1,null,null,"bitte wählen",null,"Pauschal/Monat",0,{"$f":"B51*G51+ROUND((C51/30),3)*G51","v":0}]
[2,null,null,null,null,"Pauschal/Monat",null,{"$f":"B52*G52+ROUND((C52/30),3)*G52","v":0}]
["Summe",null,null,null,null,null,null,{"$f":"SUM(H51:H52)","v":0}]
[]
["Übersiedlungsgut (Nr. 5.10. AVB)"]
["Pauschale (in Vertragswährung)",null,"Menge","Preis ","Betrag","Bemerkungen",null,null,null,"Für GIZ reserviert"]
[null,null,1,null,{"$f":"D57*C57","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Summe Personaleinsatz 1",null,null,{"$f":"SUM(E57,H46,H37,G22,G23,G24,H51,H52)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fachkraft (Aus- und Rückreise)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Angehörige (Aus- und Rückreise) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urlaubsflüge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regionale und nationale Flüge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weitere Flüge"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pauschal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gegen Nachweis"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langzeitfachkraft int."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langzeitfachkraft reg."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langzeitfachkraft nat."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kurzzeitfachkraft int."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kurzzeitfachkraft reg."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kurzzeitfachkraft nat."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"andere (bitte angeben)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auslandsreisekosten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inlandsreisekosten"]

{"sheet":"Fachkraftblatt (9)","index":9,"n_rows":136,"n_cols":40,"rows_kept":136,"cut":false,"hidden":true,"merged":[[52,3,52,4],[52,8,52,13],[8,2,9,4],[11,9,11,13],[5,15,7,15],[6,2,6,4],[6,7,6,8],[6,9,6,10],[6,11,6,12],[6,13,6,14],[7,2,7,4],[11,14,11,16],[13,9,13,13],[13,14,13,16],[14,9,14,13],[14,14,14,16],[1,3,1,4],[1,7,1,9],[5,7,5,8],[5,9,5,12],[5,13,5,14],[12,9,12,13],[12,14,12,16],[15,9,15,13],[15,14,15,16],[19,3,20,3],[19,4,19,5],[19,6,20,6],[19,7,20,13],[19,14,19,16],[23,7,23,13],[23,14,23,16],[16,9,16,13],[16,14,16,16],[16,20,16,21],[18,7,18,13],[18,14,18,16],[20,14,20,16],[21,7,21,13],[21,14,21,16],[22,7,22,13],[22,14,22,16],[26,8,26,15],[28,1,29,1],[28,3,28,5],[28,7,29,7],[28,8,29,13],[28,14,29,15],[30,8,30,13],[30,14,30,15],[31,8,31,13],[31,14,31,15],[32,8,32,13],[32,14,32,15],[33,8,33,13],[33,14,33,15],[34,8,34,13],[34,14,34,15],[35,8,35,13],[35,14,35,15],[45,3,45,4],[45,8,45,13],[36,3,36,4],[36,8,36,13],[36,14,36,15],[38,11,38,13],[39,3,40,3],[39,4,40,4],[39,6,40,6],[39,7,40,7],[39,8,40,13],[40,14,40,15],[48,5,49,5],[48,6,49,6],[41,8,41,13],[42,8,42,13],[43,8,43,13],[44,8,44,13],[56,0,56,1],[56,5,56,8],[56,9,56,11],[57,12,57,14],[48,8,49,13],[48,14,49,15],[50,3,50,4],[50,8,50,13],[51,3,51,4],[51,8,51,13],[48,7,49,7],[55,5,55,8],[55,9,55,11],[48,0,49,0],[48,1,48,2],[48,3,49,4]]}
["Nachweis über den Personaleinsatz (9)"]
[null,"Vertragsnummer:",null,"Bearbeitungsnr./Kst.:",null,null,null,"Abrechnungszeitraum:"]
[null,{"$f":"'Übersicht Rechnung'!A28","v":0},null,null,{"$f":"'Übersicht Rechnung'!C28","v":0},null,null,null,null,{"$f":"'Übersicht Rechnung'!G28","v":0}]
[]
[]
["Persönliche Daten",null,null,null,null,null,"Einsatzzeiten","Gesamtsollzeit",null,"Abrechnungszeitraum ",null,null,null,"Istzeit ",null,"Bemerkungen"]
["Name, Vorname:",null,null,null,null,null,null,"nach Vertrag",null,"Ist-Zeitraum",null,"Zeitraum",null,"insgesamt"]
["Funktion:",null,"bitte wählen",null,null,null,null,"Monate","Tage","tt/mm/jj","tt/mm/jj","Monate","Tage","Monate","Tage"]
["Funktionsbeschreibung",null,null,null,null,null,"Inland"]
[null,null,null,null,null,null,"Ausland"]
[]
[null,null,null,null,null,null,"Angaben zu Urlaub und Krankheit",null,null,"Bemerkungen",null,null,null,null,"Für GIZ reserviert"]
[null,null,null,null,null,null,"Anspruch gesamt Vertrag (Tage)"]
[null,null,null,null,null,null,"Restanspruch (Tage)"]
[null,null,null,null,null,null,"genommener Urlaub (Tage)"]
[null,null,null,null,null,null,"Resturlaub (Tage)",null,{"$f":"IF(I14>0,I14-I15,I13-I15)","v":0}]
[null,null,null,null,null,null,"Krankheit (Tage)"]
[]
["Personalkosten",null,null,null,null,null,null,null,null,null,null,null,null,null,"Für GIZ reserviert"]
[null,null,null,"Monatssatz\ngemäß Vertrag","Menge",null,"Betrag ","Bemerkungen"]
["Vergütungsposition",null,null,null,"Monate","Tage"]
["Honorar (Nr. 5.4 AVB)",null,null,null,null,null,{"$f":"SUM((D22*E22)+(D22*ROUND(F22/30,3)))","v":0}]
["Tagegeld (Nr. 5.6. AVB)",null,null,null,null,null,{"$f":"SUM((D23*E23)+(D23*ROUND(F23/30,3)))","v":0}]
["Übernachtungsgeld (Nr. 5.7 AVB)",null,null,null,null,null,{"$f":"SUM((D24*E24)+(D24*ROUND(F24/30,3)))","v":0}]
[]
[]
["Reisekosten"]
["Flugkosten (Nr. 5.8 AVB)"]
[null,"Name Reisender\n(nur wenn Angehörige reisen erforderlich)",null,"Reisedaten",null,null,null,"Betrag ","Bemerkungen",null,null,null,null,null,"Für GIZ reserviert"]
["Nr.",null,"Flugart","Reiseziel","Hinflug \n(tt/mm/jj)","Rückflug (tt/mm/jj)","Erstattungsart"]
[1,null,"bitte wählen",null,null,null,"bitte wählen",0]
[2,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
["SUMME",null,null,null,null,null,null,{"$f":"SUM(H31:H36)","v":0}]
[]
["Andere Reisekosten (Nr. 5.9 AVB)"]
[null,null,null,"Beginn (tt/mm/jj)","Ende \n(tt/mm/jj)","Anlass ","Erstattungsart","Betrag ","Bemerkungen"]
["Nr.","Reiseland","Art der Reisekosten",null,null,"der Reise",null,null,null,null,null,null,null,null,"Für GIZ reserviert"]
[1,null,"bitte wählen",null,null,null,"bitte wählen",0]
[2,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
["SUMME",null,null,null,null,null,null,{"$f":"SUM(H42:H45)","v":0}]
[]
["Andere Reisekosten (Nr. 5.9 AVB) MONATSPAUSCHALE"]
["Nr.","Abrechnungszeitraum",null,"Art der Reisekosten",null,"Erstattungsart","Preis","Betrag","Bemerkungen",null,null,null,null,null,"Für GIZ reserviert"]
[null,"Monate","Tage"]
[1,null,null,"bitte wählen",null,"Pauschal/Monat",0,{"$f":"B51*G51+ROUND((C51/30),3)*G51","v":0}]
[2,null,null,null,null,"Pauschal/Monat",null,{"$f":"B52*G52+ROUND((C52/30),3)*G52","v":0}]
["Summe",null,null,null,null,null,null,{"$f":"SUM(H51:H52)","v":0}]
[]
["Übersiedlungsgut (Nr. 5.10. AVB)"]
["Pauschale (in Vertragswährung)",null,"Menge","Preis ","Betrag","Bemerkungen",null,null,null,"Für GIZ reserviert"]
[null,null,1,null,{"$f":"D57*C57","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Summe Personaleinsatz 1",null,null,{"$f":"SUM(E57,H46,H37,G22,G23,G24,H51,H52)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fachkraft (Aus- und Rückreise)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Angehörige (Aus- und Rückreise) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urlaubsflüge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regionale und nationale Flüge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weitere Flüge"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pauschal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gegen Nachweis"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langzeitfachkraft int."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langzeitfachkraft reg."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langzeitfachkraft nat."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kurzzeitfachkraft int."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kurzzeitfachkraft reg."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kurzzeitfachkraft nat."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"andere (bitte angeben)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auslandsreisekosten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inlandsreisekosten"]

{"sheet":"Fachkraftblatt (10)","index":10,"n_rows":136,"n_cols":40,"rows_kept":136,"cut":false,"hidden":true,"merged":[[52,3,52,4],[52,8,52,13],[8,2,9,4],[11,9,11,13],[5,15,7,15],[6,2,6,4],[6,7,6,8],[6,9,6,10],[6,11,6,12],[6,13,6,14],[7,2,7,4],[11,14,11,16],[13,9,13,13],[13,14,13,16],[14,9,14,13],[14,14,14,16],[1,3,1,4],[1,7,1,9],[5,7,5,8],[5,9,5,12],[5,13,5,14],[12,9,12,13],[12,14,12,16],[15,9,15,13],[15,14,15,16],[19,3,20,3],[19,4,19,5],[19,6,20,6],[19,7,20,13],[19,14,19,16],[23,7,23,13],[23,14,23,16],[16,9,16,13],[16,14,16,16],[16,20,16,21],[18,7,18,13],[18,14,18,16],[20,14,20,16],[21,7,21,13],[21,14,21,16],[22,7,22,13],[22,14,22,16],[26,8,26,15],[28,1,29,1],[28,3,28,5],[28,7,29,7],[28,8,29,13],[28,14,29,15],[30,8,30,13],[30,14,30,15],[31,8,31,13],[31,14,31,15],[32,8,32,13],[32,14,32,15],[33,8,33,13],[33,14,33,15],[34,8,34,13],[34,14,34,15],[35,8,35,13],[35,14,35,15],[45,3,45,4],[45,8,45,13],[36,3,36,4],[36,8,36,13],[36,14,36,15],[38,11,38,13],[39,3,40,3],[39,4,40,4],[39,6,40,6],[39,7,40,7],[39,8,40,13],[40,14,40,15],[48,5,49,5],[48,6,49,6],[41,8,41,13],[42,8,42,13],[43,8,43,13],[44,8,44,13],[56,0,56,1],[56,5,56,8],[56,9,56,11],[57,12,57,14],[48,8,49,13],[48,14,49,15],[50,3,50,4],[50,8,50,13],[51,3,51,4],[51,8,51,13],[48,7,49,7],[55,5,55,8],[55,9,55,11],[48,0,49,0],[48,1,48,2],[48,3,49,4]]}
["Nachweis über den Personaleinsatz (10)"]
[null,"Vertragsnummer:",null,"Bearbeitungsnr./Kst.:",null,null,null,"Abrechnungszeitraum:"]
[null,{"$f":"'Übersicht Rechnung'!A28","v":0},null,null,{"$f":"'Übersicht Rechnung'!C28","v":0},null,null,null,null,{"$f":"'Übersicht Rechnung'!G28","v":0}]
[]
[]
["Persönliche Daten",null,null,null,null,null,"Einsatzzeiten","Gesamtsollzeit",null,"Abrechnungszeitraum ",null,null,null,"Istzeit ",null,"Bemerkungen"]
["Name, Vorname:",null,null,null,null,null,null,"nach Vertrag",null,"Ist-Zeitraum",null,"Zeitraum",null,"insgesamt"]
["Funktion:",null,"bitte wählen",null,null,null,null,"Monate","Tage","tt/mm/jj","tt/mm/jj","Monate","Tage","Monate","Tage"]
["Funktionsbeschreibung",null,null,null,null,null,"Inland"]
[null,null,null,null,null,null,"Ausland"]
[]
[null,null,null,null,null,null,"Angaben zu Urlaub und Krankheit",null,null,"Bemerkungen",null,null,null,null,"Für GIZ reserviert"]
[null,null,null,null,null,null,"Anspruch gesamt Vertrag (Tage)"]
[null,null,null,null,null,null,"Restanspruch (Tage)"]
[null,null,null,null,null,null,"genommener Urlaub (Tage)"]
[null,null,null,null,null,null,"Resturlaub (Tage)",null,{"$f":"IF(I14>0,I14-I15,I13-I15)","v":0}]
[null,null,null,null,null,null,"Krankheit (Tage)"]
[]
["Personalkosten",null,null,null,null,null,null,null,null,null,null,null,null,null,"Für GIZ reserviert"]
[null,null,null,"Monatssatz\ngemäß Vertrag","Menge",null,"Betrag ","Bemerkungen"]
["Vergütungsposition",null,null,null,"Monate","Tage"]
["Honorar (Nr. 5.4 AVB)",null,null,null,null,null,{"$f":"SUM((D22*E22)+(D22*ROUND(F22/30,3)))","v":0}]
["Tagegeld (Nr. 5.6. AVB)",null,null,null,null,null,{"$f":"SUM((D23*E23)+(D23*ROUND(F23/30,3)))","v":0}]
["Übernachtungsgeld (Nr. 5.7 AVB)",null,null,null,null,null,{"$f":"SUM((D24*E24)+(D24*ROUND(F24/30,3)))","v":0}]
[]
[]
["Reisekosten"]
["Flugkosten (Nr. 5.8 AVB)"]
[null,"Name Reisender\n(nur wenn Angehörige reisen erforderlich)",null,"Reisedaten",null,null,null,"Betrag ","Bemerkungen",null,null,null,null,null,"Für GIZ reserviert"]
["Nr.",null,"Flugart","Reiseziel","Hinflug \n(tt/mm/jj)","Rückflug (tt/mm/jj)","Erstattungsart"]
[1,null,"bitte wählen",null,null,null,"bitte wählen",0]
[2,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
["SUMME",null,null,null,null,null,null,{"$f":"SUM(H31:H36)","v":0}]
[]
["Andere Reisekosten (Nr. 5.9 AVB)"]
[null,null,null,"Beginn (tt/mm/jj)","Ende \n(tt/mm/jj)","Anlass ","Erstattungsart","Betrag ","Bemerkungen"]
["Nr.","Reiseland","Art der Reisekosten",null,null,"der Reise",null,null,null,null,null,null,null,null,"Für GIZ reserviert"]
[1,null,"bitte wählen",null,null,null,"bitte wählen",0]
[2,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
["SUMME",null,null,null,null,null,null,{"$f":"SUM(H42:H45)","v":0}]
[]
["Andere Reisekosten (Nr. 5.9 AVB) MONATSPAUSCHALE"]
["Nr.","Abrechnungszeitraum",null,"Art der Reisekosten",null,"Erstattungsart","Preis","Betrag","Bemerkungen",null,null,null,null,null,"Für GIZ reserviert"]
[null,"Monate","Tage"]
[1,null,null,"bitte wählen",null,"Pauschal/Monat",null,{"$f":"B51*G51+ROUND((C51/30),3)*G51","v":0}]
[2,null,null,null,null,"Pauschal/Monat",null,{"$f":"B52*G52+ROUND((C52/30),3)*G52","v":0}]
["Summe",null,null,null,null,null,null,{"$f":"SUM(H51:H52)","v":0}]
[]
["Übersiedlungsgut (Nr. 5.10. AVB)"]
["Pauschale (in Vertragswährung)",null,"Menge","Preis ","Betrag","Bemerkungen",null,null,null,"Für GIZ reserviert"]
[null,null,1,null,{"$f":"D57*C57","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Summe Personaleinsatz 1",null,null,{"$f":"SUM(E57,H46,H37,G22,G23,G24,H51,H52)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fachkraft (Aus- und Rückreise)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Angehörige (Aus- und Rückreise) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urlaubsflüge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regionale und nationale Flüge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weitere Flüge"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pauschal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gegen Nachweis"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langzeitfachkraft int."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langzeitfachkraft reg."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Langzeitfachkraft nat."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kurzzeitfachkraft int."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kurzzeitfachkraft reg."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kurzzeitfachkraft nat."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"andere (bitte angeben)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte wählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auslandsreisekosten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inlandsreisekosten"]

{"sheet":"Vertragsbed.Kosten","index":11,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,5],[3,1,3,2],[3,3,3,4]]}
["AVBS 3.3.2 Vertragsbed. Kosten im Einsatzland"]
[]
["Vertragsnummer:",null,"Bearbeitungsnr./Kst.:",null,"Abrechnungszeitraum:"]
[{"$f":"'Übersicht Rechnung'!A28:B28","v":0},{"$f":"'Übersicht Rechnung'!C28","v":0},null,{"$f":"'Übersicht Rechnung'!G28","v":0}]
[]
["Position","Name","Tage","Preis","Summe","Erläuterung"]
[null,null,null,null,{"$f":"C7*D7","v":0}]
[null,null,null,null,{"$f":"C8*D8","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
["Gesamt",null,null,{"$f":"'Übersicht Rechnung'!G32","v":0},{"$f":"SUM(E7:E26)","v":0}]

{"sheet":"Reisekosten","index":12,"n_rows":48,"n_cols":13,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,12],[3,3,3,4],[2,0,2,1]]}
["AVB 3.3.4 Reisekosten"]
[]
["Vertragsnummer:",null,"Bearbeitungsnr./Kst.:",null,"Abrechnungszeitraum:"]
[{"$f":"'Übersicht Rechnung'!A28:B28","v":0},null,{"$f":"'Übersicht Rechnung'!C28","v":0},{"$f":"'Übersicht Rechnung'!G28","v":0}]
[]
["Belegnr.","Position","Unterposition*","Erstattungs-\nart","Name","Menge","Betrag\n (des Belegs oder Pauschale)","Währ-ung","Kurs** \n","Summe \n","Datum \nHinreise (tt/mm/jj)","Datum \nRückreise (tt/mm/jj)","Erläuterung"]
["1",null,null,null,null,null,null,null,null,{"$f":"F7*G7*I7","v":0}]
["2",null,null,null,null,null,null,null,null,0]
["3",null,null,null,null,null,null,null,null,0]
["4",null,null,null,null,null,null,null,null,0]
["5",null,null,null,null,null,null,null,null,0]
["6",null,null,null,null,null,null,null,null,0]
["7",null,null,null,null,null,null,null,null,0]
["8",null,null,null,null,null,null,null,null,0]
["9",null,null,null,null,null,null,null,null,0]
["10",null,null,null,null,null,null,null,null,0]
["11",null,null,null,null,null,null,null,null,{"$f":"F17*G17*I17","v":0}]
["12",null,null,null,null,null,null,null,null,{"$f":"F18*G18*I18","v":0}]
["13",null,null,null,null,null,null,null,null,{"$f":"F19*G19*I19","v":0}]
["14",null,null,null,null,null,null,null,null,0]
["15",null,null,null,null,null,null,null,null,0]
["16",null,null,null,null,null,null,null,null,0]
["17",null,null,null,null,null,null,null,null,0]
["18",null,null,null,null,null,null,null,null,0]
["19",null,null,null,null,null,null,null,null,0]
["20",null,null,null,null,null,null,null,null,0]
["21",null,null,null,null,null,null,null,null,0]
["22",null,null,null,null,null,null,null,null,0]
["23",null,null,null,null,null,null,null,null,0]
["24",null,null,null,null,null,null,null,null,0]
["25",null,null,null,null,null,null,null,null,0]
["26",null,null,null,null,null,null,null,null,0]
["27",null,null,null,null,null,null,null,null,0]
["28",null,null,null,null,null,null,null,null,0]
["29",null,null,null,null,null,null,null,null,0]
["30",null,null,null,null,null,null,null,null,0]
["31",null,null,null,null,null,null,null,null,0]
["32",null,null,null,null,null,null,null,null,0]
["33",null,null,null,null,null,null,null,null,0]
["34",null,null,null,null,null,null,null,null,0]
["35",null,null,null,null,null,null,null,null,0]
["36",null,null,null,null,null,null,null,null,0]
[null,"Gesamt Flüge",null,null,null,null,null,null,null,{"$f":"SUMIF(B7:B42,\"Flüge\",J7:J42)","v":0}]
[null,"Gesamt Tagegeld",null,null,null,null,null,null,null,{"$f":"SUMIF(B7:B42,\"Tagegeld\",J7:J42)","v":0}]
[null,"Gesamt Übernachtung",null,null,null,null,null,null,null,{"$f":"SUMIF(B7:B42,\"Übernachtungsgeld\",J7:J42)","v":0}]
[null,"Gesamt Transport",null,null,null,null,null,null,null,{"$f":"SUMIF(B7:B42,\"Transport\",J7:J42)","v":0}]
[null,"Gesamt Sonst. RK",null,null,null,null,null,null,null,{"$f":"SUMIF(B7:B42,\"Sonstige Reisekosten\",J7:J42)","v":0}]
[null,"Gesamt",null,null,null,null,null,null,{"$f":"'Übersicht Rechnung'!G32","v":0},{"$f":"SUM(J43:J47)","v":0}]

{"sheet":"Nationales Personal","index":13,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["3.3.3   Einsatz von nationalem Personal (pauschal gegen Vorlage der Kopie des Arbeitsvertrages)"]
[]
[null,"Vertragsnummer:","Bearbeitungsnr./Kst.:",null,"Abrechnungszeitraum:"]
[null,{"$f":"'Übersicht Rechnung'!A28","v":0},{"$f":"'Übersicht Rechnung'!C28","v":0},null,{"$f":"'Übersicht Rechnung'!G28","v":0}]
[]
[]
["Belegnr.","Name ","Anfang im Abrechnungszeitraum\ntt/mm/jj","Ende im Abrechnungszeitraum\ntt/mm/jj","Kosten  \n/Monat","Monat","Tage","Gesamt","Bemerkungen"]
[1,null,null,null,null,null,null,{"$f":"(F8+(G8/30))*E8","v":0},null,null,null,"Pauschal"]
[2,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,0,null,null,null,"Pauschal"]
[12,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,0]
["Gesamt:",null,null,null,null,null,{"$f":"'Übersicht Rechnung'!G32","v":0},{"$f":"SUM(H8:H27)","v":0}]

{"sheet":"Ausrüstungsgüter","index":14,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["3.3.5.2  Ausrüstungsgüter (ausschließlich gegen Nachweis)"]
[null,"Vertragsnummer:","Bearbeitungsnr./Kst.:",null,null,null,null,"Abrechnungszeitraum:"]
[null,{"$f":"'Übersicht Rechnung'!A28","v":0},{"$f":"'Übersicht Rechnung'!C28","v":0},null,null,null,null,{"$f":"'Übersicht Rechnung'!G28","v":0}]
[]
[]
["Belegnr.","Beschafftes Ausrüstungsgut \n(in deutscher Sprache)","Lieferant","Belegdatum\ntt/mm/jj","Betrag \n(des Belegs)","Währung","Kurs**","Preis ","Bemerkungen "]
[1,null,null,null,null,null,null,{"$f":"E7*G7","v":0}]
[2,null,null,null,null,null,null,{"$f":"E8*G8","v":0}]
[3,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,{"$f":"E18*G18","v":0}]
[13,null,null,null,null,null,null,{"$f":"E19*G19","v":0}]
[14,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,{"$f":"E26*G26","v":0}]
[21,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,0]
[32,null,null,null,null,null,null,0]
[33,null,null,null,null,null,null,0]
[34,null,null,null,null,null,null,0]
["Gesamt:",null,null,null,null,null,{"$f":"'Übersicht Rechnung'!G32","v":0},{"$f":"SUM(H7:H40)","v":0}]

{"sheet":"Betriebskosten","index":15,"n_rows":52,"n_cols":6,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["3.3.5.3.   Betriebskosten im Einsatzland"]
[]
[null,"Vertragsnummer:",null,"Bearbeitungsnr./Kst.:",null,"Abrechnungszeitraum:"]
[null,{"$f":"'Übersicht Rechnung'!A28","v":0},null,{"$f":"'Übersicht Rechnung'!C28","v":0},null,{"$f":"'Übersicht Rechnung'!G28","v":0}]
[]
[]
[" Büro- und Betriebskosten"]
[]
["Pauschal"]
["Nr.","Art der Büro und Betriebskosten","Pauschal-betrag","Menge","Preis ","Bemerkungen"]
[1,null,null,null,{"$f":"C11*D11","v":0}]
[2,null,null,null,{"$f":"SUM(C12*D12)","v":0}]
[3,null,null,null,0]
[4,null,null,null,0]
[5,null,null,null,0]
[6,null,null,null,0]
[7,null,null,null,0]
[8,null,null,null,0]
[9,null,null,null,0]
[10,null,null,null,0]
["Zwischensumme:",null,null,{"$f":"'Übersicht Rechnung'!G32","v":0},{"$f":"SUM(E11:E20)","v":0}]
[]
["Gegen Nachweis"]
["Nr.","Art der Büro und Betriebskosten","Betrag","Menge","Preis ","Bemerkungen"]
[1,null,null,null,{"$f":"C25*D25","v":0}]
[2,null,null,null,{"$f":"C26*D26","v":0}]
[3,null,null,null,0]
[4,null,null,null,0]
[5,null,null,null,0]
[6,null,null,null,0]
[7,null,null,null,0]
[8,null,null,null,0]
[9,null,null,null,0]
[10,null,null,null,0]
[11,null,null,null,0]
[12,null,null,null,0]
[13,null,null,null,0]
[14,null,null,null,0]
[15,null,null,null,0]
[16,null,null,null,0]
[17,null,null,null,0]
[18,null,null,null,0]
[19,null,null,null,0]
[20,null,null,null,0]
[21,null,null,null,0]
[22,null,null,null,0]
[23,null,null,null,0]
[24,null,null,null,0]
[25,null,null,null,0]
["Zwischensumme:",null,{"$f":"'Übersicht Rechnung'!G32","v":0},null,{"$f":"SUM(E25:E49)","v":0}]
[]
["Gesamt:",null,{"$f":"C50","v":0},{"$f":"E50+E21","v":0}]

{"sheet":"Unteraufträge","index":16,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["3.3.5.1  Unteraufträge (ausschließlich gegen Nachweis)"]
[]
[null,"Vertragsnummer:","Bearbeitungsnr./Kst.:",null,"Abrechnungszeitraum:"]
[null,{"$f":"'Übersicht Rechnung'!A28","v":0},{"$f":"'Übersicht Rechnung'!C28","v":0},null,{"$f":"'Übersicht Rechnung'!G28","v":0}]
[]
[]
["Belegnr.","Name Unterauftragnehmer","Zweck der Beauftragung","Betrag\n (des Belegs)","Währung","Kurs**","Preis","Bemerkungen"]
[1,null,null,null,null,null,{"$f":"D8*F8","v":0}]
[2,null,null,null,null,null,{"$f":"D9*F9","v":0}]
[3,null,null,null,null,null,{"$f":"D10*F10","v":0}]
[4,null,null,null,null,null,0]
[5,null,null,null,null,null,0]
[6,null,null,null,null,null,0]
[7,null,null,null,null,null,0]
[8,null,null,null,null,null,0]
[9,null,null,null,null,null,0]
[10,null,null,null,null,null,0]
[11,null,null,null,null,null,0]
[12,null,null,null,null,null,0]
[13,null,null,null,null,null,0]
[14,null,null,null,null,null,0]
[15,null,null,null,null,null,0]
[16,null,null,null,null,null,0]
[17,null,null,null,null,null,0]
[18,null,null,null,null,null,0]
[19,null,null,null,null,null,0]
[20,null,null,null,null,null,0]
[21,null,null,null,null,null,0]
[22,null,null,null,null,null,0]
[23,null,null,null,null,null,0]
[24,null,null,null,null,null,0]
[25,null,null,null,null,null,0]
["Gesamt:",null,null,null,null,{"$f":"'Übersicht Rechnung'!G32","v":0},{"$f":"SUM(G8:G32)","v":0}]

{"sheet":"WS und FB","index":17,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,7],[37,1,37,2],[5,2,5,5]]}
["3.3.5.4.   Workshops, Aus- und Fortbildungen - Abrechnung erfolgt pro Workshop  (ausschließlich gegen Nachweis)"]
[]
[null,"Vertragsnummer:",null,"Bearbeitungsnr./Kst.:",null,"Abrechnungszeitraum:"]
[null,{"$f":"'Übersicht Rechnung'!A28","v":0},null,{"$f":"'Übersicht Rechnung'!C28","v":0},null,{"$f":"'Übersicht Rechnung'!G28","v":0}]
[]
["V1","Veranstaltungsart:",null,null,null,null,"Ort/Datum:"]
["Belegnr.","Beleginhalt\n (in Deutsch oder Englisch)","Belegdatum\ntt/mm/jj","Betrag \n(des Belegs)","Währung","Kurs**","Preis","Bemerkungen"]
[1,null,null,null,null,null,{"$f":"D8*F8","v":0}]
[2,null,null,null,null,null,{"$f":"D9*F9","v":0}]
[3,null,null,null,null,null,{"$f":"D10*F10","v":0}]
[4,null,null,null,null,null,0]
[5,null,null,null,null,null,0]
[6,null,null,null,null,null,0]
[7,null,null,null,null,null,0]
[8,null,null,null,null,null,0]
[9,null,null,null,null,null,0]
[10,null,null,null,null,null,0]
[11,null,null,null,null,null,0]
[12,null,null,null,null,null,0]
[13,null,null,null,null,null,0]
[14,null,null,null,null,null,0]
[15,null,null,null,null,null,0]
[16,null,null,null,null,null,0]
[17,null,null,null,null,null,0]
[18,null,null,null,null,null,0]
[19,null,null,null,null,null,0]
[20,null,null,null,null,null,0]
[21,null,null,null,null,null,0]
[22,null,null,null,null,null,0]
[23,null,null,null,null,null,0]
[24,null,null,null,null,null,0]
[25,null,null,null,null,null,0]
[26,null,null,null,null,null,0]
[27,null,null,null,null,null,0]
[28,null,null,null,null,null,0]
[29,null,null,null,null,null,0]
[30,null,null,null,null,null,{"$f":"D37*F37","v":0}]
[null,"Summe V1:",null,null,null,{"$f":"'Übersicht Rechnung'!G32","v":0},{"$f":"SUM(G8:G37)","v":0}]

{"sheet":"Zuschüsse","index":18,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["3.3.5.5  Örtliche Zuschüsse (ausschließlich gegen Nachweis)"]
[]
[null,"Vertragsnummer:",null,"Bearbeitungsnr./Kst.:",null,"Abrechnungszeitraum:"]
[null,{"$f":"'Übersicht Rechnung'!A28","v":0},null,{"$f":"'Übersicht Rechnung'!C28","v":0},null,{"$f":"'Übersicht Rechnung'!G28","v":0}]
[]
[]
["Belegnr.","Zuschussempfänger","Vertrags-nummer","Betrag\n(des Belegs)","Währung","Kurs**","Zuschuss","Bemerkungen"]
[1,null,null,null,null,null,{"$f":"D8*F8","v":0}]
[2,null,null,null,null,null,{"$f":"D9*F9","v":0}]
[3,null,null,null,null,null,{"$f":"D10*F10","v":0}]
[4,null,null,null,null,null,0]
[5,null,null,null,null,null,0]
[6,null,null,null,null,null,0]
[7,null,null,null,null,null,0]
[8,null,null,null,null,null,0]
[9,null,null,null,null,null,0]
[10,null,null,null,null,null,0]
[11,null,null,null,null,null,0]
[12,null,null,null,null,null,0]
[13,null,null,null,null,null,0]
[14,null,null,null,null,null,0]
[15,null,null,null,null,null,{"$f":"D22*F22","v":0}]
["GESAMT:",null,null,null,null,{"$f":"'Übersicht Rechnung'!G32","v":0},{"$f":"SUM(G8:G22)","v":0}]

{"sheet":"Sonstige_Kosten","index":19,"n_rows":57,"n_cols":8,"rows_kept":57,"cut":false,"hidden":false,"merged":[[15,5,15,7],[26,5,26,7],[27,5,27,7],[28,5,28,7],[6,0,6,7],[21,5,21,7],[22,5,22,7],[23,5,23,7],[24,5,24,7],[25,5,25,7],[16,5,16,7],[17,5,17,7],[18,5,18,7],[19,5,19,7],[20,5,20,7],[11,5,11,7],[12,5,12,7],[13,5,13,7],[14,5,14,7],[0,0,0,7],[7,5,7,7],[8,5,8,7],[9,5,9,7],[10,5,10,7]]}
["3.3.5.6  Sonstige Kosten"]
[]
[null,"Vertragsnummer:",null,"Bearbeitungsnr./Kst.:",null,"Abrechnungszeitraum:"]
[null,{"$f":"'Übersicht Rechnung'!A28","v":0},null,{"$f":"'Übersicht Rechnung'!C28","v":0},null,{"$f":"'Übersicht Rechnung'!G28","v":0}]
[]
[]
["Pauschal"]
["Nr.","Art der sonstigen Kosten","Pauschal-betrag","Menge","Preis ","Bermerkungen"]
[1,null,null,null,{"$f":"SUM(D9*C9)","v":0}]
[2,null,null,null,0]
[3,null,null,null,0]
[4,null,null,null,0]
[5,null,null,null,0]
[6,null,null,null,0]
[7,null,null,null,0]
[8,null,null,null,0]
[9,null,null,null,0]
[10,null,null,null,0]
[11,null,null,null,0]
[12,null,null,null,0]
[13,null,null,null,0]
[14,null,null,null,0]
[15,null,null,null,0]
[16,null,null,null,0]
[17,null,null,null,0]
[18,null,null,null,0]
[19,null,null,null,0]
[20,null,null,null,0]
["Zwischensumme:",null,null,{"$f":"'Übersicht Rechnung'!G32","v":0},{"$f":"SUM(E9:E28)","v":0}]
[]
[]
[]
["gegen Nachweis"]
["Belegnr.","Beleginhalt\n(in Deutsch oder Englisch)","Belegdatum\ntt/mm/jj","Betrag \n(des Belegs)","Währung","Kurs**","Preis","Bemerkungen"]
[1,null,null,null,null,null,{"$f":"D35*F35","v":0}]
[2,null,null,null,null,null,0]
[3,null,null,null,null,null,0]
[4,null,null,null,null,null,0]
[5,null,null,null,null,null,0]
[6,null,null,null,null,null,0]
[7,null,null,null,null,null,0]
[8,null,null,null,null,null,0]
[9,null,null,null,null,null,0]
[10,null,null,null,null,null,0]
[11,null,null,null,null,null,0]
[12,null,null,null,null,null,0]
[13,null,null,null,null,null,0]
[14,null,null,null,null,null,0]
[15,null,null,null,null,null,0]
[16,null,null,null,null,null,0]
[17,null,null,null,null,null,0]
[18,null,null,null,null,null,0]
[19,null,null,null,null,null,0]
[20,null,null,null,null,null,0]
["Zwischensumme:",null,null,null,null,{"$f":"'Übersicht Rechnung'!G32","v":0},{"$f":"SUM(G35:G54)","v":0}]
[]
["Summe sonstige Kosten:",null,null,{"$f":"G55+E29","v":0}]

{"sheet":"Flexible Vergütungspos.","index":20,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,7],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3]]}
["3.3.5.7  Flexible Vergütungsposition (nur beim Vorliegen der Zustimmung durch AV)"]
[]
[null,"Vertragsnummer:","Bearbeitungsnr./Kst.:","Abrechnungszeitraum:"]
[null,{"$f":"'Übersicht Rechnung'!A28","v":0},{"$f":"'Übersicht Rechnung'!C28","v":0},{"$f":"'Übersicht Rechnung'!G28","v":0}]
[]
[]
["Nr.","Überschrittene Vergütungsposition","Begründung",null,"Überschreitungs-wert","Bemerkungen"]
[1,null,null,null,0]
[2,null,null,null,0]
[3,null,null,null,0]
[4,null,null,null,0]
[5,null,null,null,0]
[6,null,null,null,0]
[7,null,null,null,0]
[8,null,null,null,0]
[9,null,null,null,0]
[10,null,null,null,0]
[null,null,"Beanspruchte flexible Vergütung",null,{"$f":"SUM(E8:E17)","v":0}]