{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Overview Invoice","Summen","Fee","Fachkraftblatt (3)","Fachkraftblatt (4)","Fachkraftblatt (5)","Fachkraftblatt (6)","Fachkraftblatt (7)","Fachkraftblatt (8)","Fachkraftblatt (9)","Fachkraftblatt (10)","Travel costs","Other_costs","Flexible remuneration item"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":23,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Overview Invoice","index":0,"n_rows":56,"n_cols":12,"rows_kept":56,"cut":false,"hidden":false,"merged":[[54,2,54,3],[18,2,19,3],[44,0,45,0],[47,0,48,0],[49,0,50,0],[35,1,35,2],[27,2,27,4],[19,5,19,9],[36,1,36,2],[27,6,27,7],[28,0,28,5],[28,6,28,7],[36,3,36,5],[32,1,32,2],[32,3,32,5],[34,3,34,5],[34,1,34,2],[28,8,28,9],[29,8,29,9],[54,4,54,6],[35,3,35,5],[38,1,38,2],[38,3,38,5],[40,1,40,2],[53,10,53,13],[41,4,41,5],[43,4,43,5],[41,1,41,2],[42,1,42,2],[44,4,44,5],[44,1,44,2],[45,1,45,2],[44,6,44,9],[45,6,45,9],[46,6,46,9],[47,6,47,9],[48,6,48,9],[49,6,49,9],[50,6,50,9],[51,6,51,9],[43,1,43,2],[42,4,42,5],[49,1,49,2],[50,4,50,5],[50,1,50,2],[47,4,47,5],[48,1,48,2],[48,4,48,5],[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],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[5,0,5,3],[1,7,1,9],[13,5,14,9],[2,5,2,6],[1,5,1,6],[3,5,3,6],[4,5,4,6],[55,0,55,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],[37,3,37,5],[29,0,29,5],[29,6,29,7],[33,1,33,2],[51,1,51,3],[51,4,51,5],[45,4,45,5],[46,4,46,5],[5,5,5,6],[6,5,6,6],[3,7,3,9],[4,7,4,9],[5,7,5,9],[2,7,2,9],[6,7,6,9],[33,3,33,5],[30,0,30,5],[30,6,30,9],[20,5,20,9],[17,5,18,9],[18,0,19,1],[54,0,54,1],[53,0,53,1],[37,1,37,2],[31,4,31,5],[31,1,31,2],[34,6,34,9],[35,6,35,9],[36,6,36,9],[37,6,37,9],[38,6,38,9],[40,6,40,9],[41,6,41,9],[42,6,42,9],[43,6,43,9],[31,6,31,9],[32,6,32,9],[33,6,33,9],[53,2,53,3],[53,4,53,6],[40,3,40,5],[46,1,46,2],[49,4,49,5],[47,1,47,2],[39,1,39,2]]}
["Contractor (Please take the adress from your contract)",null,null,null,null,"Bank details:"]
[null,null,null,null,null,"Name of bank:"]
[null,null,null,null,null,"Acount no.:"]
[null,null,null,null,null,"Bank Code:"]
[null,null,null,null,null,"IBAN:"]
[null,null,null,null,null,"BIC (Swift-Code for foreign bank)"]
[null,null,null,null,null,"Tax/VAT ID No.:"]
[]
[null,null,null,null,null,"Dor GIZ use only"]
[]
["Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH Bonn                    \nFriedrich-Ebert-Allee 36\n53113 Bonn\nGermany",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"]
["Sequential inovice no."]
[null,null,null,null,null,"Leistungsbestätigung (durch Fachabteilung)"]
[]
[null,null,null,null,null,"OE                 Datum                  Name"]
[]
["Date of commencement of work:",null,null,null,null,"Sachl. rechn. richtig (durch FiVa)"]
["(please state on first request for advance payment)",null,null,null,null,"OE                 Datum                  Name"]
[]
["Contract number",null,"Project number / Cost Centre",null,null,null,"Accounting period",null,null,"Date of invoice"]
[]
["Brief project title",null,null,null,null,null,"Country",null,"Place of performance"]
[]
["Rechnung vollst. am:",null,null,null,null,null,"For GIZ use only"]
["Terms of contract \n§","Remuneration item (net amounts)",null,"Currency:"]
[null,"Lump-sum price"]
["3.3.1","Fee",null,{"$f":"IFERROR(SUM(INDIRECT(\"'Fee (2)'!E34\"))+Fee!E34,Fee!E34)+IFERROR(SUM(INDIRECT(\"'Fee (3)'!E34\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Fee (4)'!E34\"))+0,0)","v":0}]
["3.3.4.1","Air travel expenses",null,{"$f":"IFERROR(SUM(INDIRECT(\"'Travel costs (2)'!J43\"))+'Travel costs'!J43,'Travel costs'!J43)+IFERROR(SUM(INDIRECT(\"'Travel costs (3)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (4)'!J43\"))+0,0)","v":0}]
["3.3.4.1","Transportation",null,{"$f":"IFERROR(SUM(INDIRECT(\"'Travel costs (2)'!J46\"))+'Travel costs'!J46,'Travel costs'!J46)+IFERROR(SUM(INDIRECT(\"'Travel costs (3)'!J46\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (4)'!J46\"))+0,0)","v":0}]
["3.3.4.2","Per-diem allowance",null,{"$f":"IFERROR(SUM(INDIRECT(\"'Travel costs (2)'!J44\"))+'Travel costs'!J44,'Travel costs'!J44)+IFERROR(SUM(INDIRECT(\"'Travel costs (3)'!J44\"))+0,0)++IFERROR(SUM(INDIRECT(\"'Travel costs (4)'!J44\"))+0,0)","v":0}]
["3.3.4.3","Overnight accomodation allowance",null,{"$f":"IFERROR(SUM(INDIRECT(\"'Travel costs (2)'!J45\"))+'Travel costs'!J45,'Travel costs'!J45)+IFERROR(SUM(INDIRECT(\"'Travel costs (3)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (4)'!J45\"))+0,0)","v":0}]
["3.3.4.4","Other travel expenses",null,{"$f":"IFERROR(SUM(INDIRECT(\"'Travel costs (2)'!J47\"))+'Travel costs'!J47,'Travel costs'!J47)+IFERROR(SUM(INDIRECT(\"'Travel costs (3)'!J47\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (4)'!J47\"))+0,0)","v":0}]
["3.3.5.6","Other costs",null,null,null,{"$f":"IFERROR(SUM(INDIRECT(\"'Other_costs (2)'!D64\"))+Other_costs!D64,Other_costs!D64)+IFERROR(SUM(INDIRECT(\"'Other_costs (3)'!D64\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Other_costs (4)'!D64\"))+0,0)","v":0}]
["3.3.5.7","Flexible remuneration item",null,{"$f":"'Flexible remuneration item'!E18","v":0}]
[null,"Invoice amount",null,"netto",{"$f":"SUM(D33:F41)","v":0}]
[null,"+ VAT(%)",null,null,{"$f":"SUM(E42*D43)","v":0}]
[null,"Invoice amount",null,"brutto",{"$f":"SUM(E42:F43)","v":0},null,null,null,null,null,null,"Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH Bonn                    \nFriedrich-Ebert-Allee 40\n53113 Bonn\nGermany"]
["3.6.2","./. Retention of costs as security",null,"netto",0,null,null,null,null,null,null,"Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH Eschborn              \nDag-Hammarskjöld-Weg 1-5\n65760 Eschborn\nGermany"]
[null,"./. VAT on costs reained (%)",null,null,{"$f":"SUM(E45*D46)","v":0}]
[null,"Subtotal",null,null,{"$f":"SUM(E44)-(E45)-(E46)","v":0}]
["3.5.4","+ Advance payment",null,"netto"]
[null,"+ VAT (%)",null,null,{"$f":"SUM(E48*D49)","v":0}]
["3.5.4","./. Advance payment (deduction)",null,"netto"]
[null,"./. VAT (%)",null,null,{"$f":"SUM(E50*D51)","v":0}]
[null,"PAYMENT AMOUNT",null,null,{"$f":"E47+E48+E49-E50-E51","v":0}]
[]
[]
["contact person",null,"Telephone",null,"E-Mail"]
["I hereby confirm that all the information provided is truthful and declare that the expenditures and costs billed to the Client have neither been or will be settled with not billed to any third party. "]

{"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":"Fee","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],[1,0,1,4]]}
["3.3.1 Fee"]
["(according to obligatory time records - bases Term of condition No. 3.5.2)"]
["Contract number:",null,"Project no./Cost Centre:",null,"Account period:"]
[{"$f":"'Overview Invoice'!A28:B28","v":0},{"$f":"'Overview Invoice'!C28","v":0},null,{"$f":"'Overview Invoice'!G28","v":0}]
[]
["Position","Name","Quantity","Price","Amount","Remarks"]
[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]
["Total",null,null,{"$f":"'Overview Invoice'!E32","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":"'Overview Invoice'!A28","v":0},null,null,{"$f":"'Overview Invoice'!C28","v":0},null,null,null,null,{"$f":"'Overview Invoice'!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":"'Overview Invoice'!A28","v":0},null,null,{"$f":"'Overview Invoice'!C28","v":0},null,null,null,null,{"$f":"'Overview Invoice'!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":"'Overview Invoice'!A28","v":0},null,null,{"$f":"'Overview Invoice'!C28","v":0},null,null,null,null,{"$f":"'Overview Invoice'!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":"'Overview Invoice'!A28","v":0},null,null,{"$f":"'Overview Invoice'!C28","v":0},null,null,null,null,{"$f":"'Overview Invoice'!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":"'Overview Invoice'!A28","v":0},null,null,{"$f":"'Overview Invoice'!C28","v":0},null,null,null,null,{"$f":"'Overview Invoice'!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":"'Overview Invoice'!A28","v":0},null,null,{"$f":"'Overview Invoice'!C28","v":0},null,null,null,null,{"$f":"'Overview Invoice'!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":"'Overview Invoice'!A28","v":0},null,null,{"$f":"'Overview Invoice'!C28","v":0},null,null,null,null,{"$f":"'Overview Invoice'!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":"'Overview Invoice'!A28","v":0},null,null,{"$f":"'Overview Invoice'!C28","v":0},null,null,null,null,{"$f":"'Overview Invoice'!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":"Travel costs","index":11,"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]]}
["3.3.4 Travel costs"]
[]
["Contract number:",null,"Project no./Cost Centre:",null,"Accounting period:"]
[{"$f":"'Overview Invoice'!A28:B28","v":0},null,{"$f":"'Overview Invoice'!C28","v":0},{"$f":"'Overview Invoice'!G28","v":0}]
[]
["Voucher no.","Position","Sub position*","type pf reimbursement","Name","Quan-tity","Amount \n(from voucher or lump sum)","Cur-rency","Rate**","Total","Date       start (dd/mm/yy)","Date       End (dd/mm/yy)","Remarks"]
["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,0]
["12",null,null,null,null,null,null,null,null,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,"Total Air Travel",null,null,null,null,null,null,null,{"$f":"SUMIF(B7:B42,\"Air travel\",J7:J42)","v":0}]
[null,"Total per-diem",null,null,null,null,null,null,null,{"$f":"SUMIF(B7:B42,\"Per-diem\",J7:J42)","v":0}]
[null,"Total Overnight",null,null,null,null,null,null,null,{"$f":"SUMIF(B7:B42,\"Overnight\",J7:J42)","v":0}]
[null,"Total Transport",null,null,null,null,null,null,null,{"$f":"SUMIF(B7:B42,\"Transport\",J7:J42)","v":0}]
[null,"Total other travel costs",null,null,null,null,null,null,null,{"$f":"SUMIF(B7:B42,\"Other Travel costs\",J7:J42)","v":0}]
[null,"Total",null,null,null,null,null,null,{"$f":"'Overview Invoice'!E32","v":0},{"$f":"SUM(J43:J47)","v":0}]

{"sheet":"Other_costs","index":12,"n_rows":64,"n_cols":8,"rows_kept":64,"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  Other costs"]
[]
[null,"Contract number:",null,"project no./cost Centre:",null,"Accounting period:"]
[null,{"$f":"'Overview Invoice'!A28","v":0},null,{"$f":"'Overview Invoice'!C28","v":0},null,{"$f":"'Overview Invoice'!G28","v":0}]
[]
[]
["Lump sum"]
["No.","Type of other costs","Lump sum price","Quantity","Amount ","Remarks"]
[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]
["Sub total:",null,null,{"$f":"'Overview Invoice'!E32","v":0},{"$f":"SUM(E9:E28)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["against evidence"]
["Voucher no.","Content of the document\n (in german or english)","Date of voucher\n(dd/mm/yy)","Amount\n(from voucher)","Currency","Rate**","Amount","Remarks"]
[1,null,null,null,null,null,{"$f":"D42*F42","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]
["Sub total:",null,null,null,null,{"$f":"'Overview Invoice'!E32","v":0},{"$f":"SUM(G42:G61)","v":0}]
[]
["Total other costs:",null,null,{"$f":"G62+E29","v":0}]

{"sheet":"Flexible remuneration item","index":13,"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 remuneration item (only in the presence of confirmation by AV)"]
[]
[null,"Contract number:","Project no./Cost Centre:","Accounting period:"]
[null,{"$f":"'Overview Invoice'!A28","v":0},{"$f":"'Overview Invoice'!C28","v":0},{"$f":"'Overview Invoice'!G28","v":0}]
[]
[]
["No.","Exceeded remuneration item","Reason",null,"Exceeded value","Remarks"]
[1]
[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,"Claimed flexible remuneration",null,{"$f":"SUM(E8:E17)","v":0}]