{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["Overview Invoice","Summen","Fee rate","Fachkraftblatt (3)","Fachkraftblatt (4)","Fachkraftblatt (5)","Fachkraftblatt (6)","Fachkraftblatt (7)","Fachkraftblatt (8)","Fachkraftblatt (9)","Fachkraftblatt (10)","Costs in the country o.a","National administative Staff","Travel costs","Procurement of ser. and works","Procurement of material goods","Operating_costs","WS & Training","Local_contributions","Other_costs","Flexible remuneration"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":32,"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":64,"n_cols":13,"rows_kept":64,"cut":false,"hidden":false,"merged":[[38,4,38,6],[45,2,45,3],[44,2,44,3],[43,4,43,6],[39,4,39,6],[43,2,43,3],[41,2,41,3],[40,4,40,6],[33,2,33,3],[33,4,33,6],[44,4,44,6],[40,2,40,3],[42,4,42,6],[41,4,41,6],[38,2,38,3],[37,2,37,3],[19,5,19,9],[20,5,20,9],[33,7,33,9],[34,7,34,9],[35,7,35,9],[34,4,34,6],[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],[30,0,30,6],[30,7,30,9],[28,8,28,9],[29,8,29,9],[27,7,27,8],[17,5,18,9],[28,0,28,5],[28,6,28,7],[37,4,37,6],[32,2,32,3],[32,4,32,6],[34,2,34,3],[35,2,35,3],[35,4,35,6],[36,4,36,6],[36,2,36,3],[27,0,27,1],[29,0,29,5],[29,6,29,7],[25,0,25,9],[27,2,27,3],[26,4,26,6],[27,4,27,6],[26,7,26,8],[20,0,20,3],[18,0,19,1],[18,2,19,3],[26,0,26,1],[26,2,26,3],[5,7,5,9],[6,7,6,9],[2,5,2,6],[1,5,1,6],[3,5,3,6],[4,5,4,6],[5,5,5,6],[6,5,6,6],[9,0,12,3],[3,7,3,9],[4,7,4,9],[16,0,16,3],[15,0,15,3],[14,0,14,3],[0,0,0,4],[0,5,0,9],[1,4,6,4],[16,5,16,9],[7,0,7,9],[8,5,8,9],[9,5,9,9],[10,5,10,7],[11,5,11,7],[12,5,12,7],[6,0,6,3],[15,5,15,9],[13,5,14,9],[1,0,1,3],[13,0,13,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[5,0,5,3],[1,7,1,9],[2,7,2,9],[52,5,52,6],[60,4,60,6],[51,11,51,14],[46,5,46,6],[49,5,49,6],[46,2,46,3],[48,2,48,3],[60,2,60,3],[47,2,47,3],[58,0,58,9],[50,1,51,1],[50,5,50,6],[50,2,50,3],[51,2,51,3],[49,2,49,3],[48,5,48,6],[51,5,51,6],[54,2,54,3],[50,0,51,0],[63,0,63,9],[61,4,61,6],[61,0,61,1],[60,0,60,1],[31,2,31,3],[31,4,31,5],[39,2,39,3],[61,2,61,3],[53,0,54,0],[55,0,56,0],[57,2,57,4],[57,5,57,6],[45,4,45,6],[42,2,42,3],[54,5,54,6],[56,5,56,6],[52,2,52,3],[55,5,55,6],[53,2,53,3],[55,1,56,1],[55,2,55,3],[56,2,56,3],[53,1,54,1],[53,5,53,6]]}
["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,"Account 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,"For GIZ use only "]
["Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH Bonn                    \nFriedrich-Ebert-Allee 36\n53113 Bonn\nGermany"]
[null,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,"expected Contract term",null,null,"Accounting period",null,"Date of invoice"]
["81XXXXXX",null,null,null,"DD.MM.YYYY-DD.MM.YYYY",null,null,"DD.MM.YYYY-DD.MM.YYYY",null,"DD.MM.YYYY"]
["Brief project title",null,null,null,null,null,"Country",null,"Place of performance"]
[]
["Rechnung vollst. am:",null,null,null,null,null,null,"For GIZ use only"]
[" Terms of Contract  §","price sheet","Remuneration item (net amounts)",null,"Currency:"]
[null,"1","Milestone No. xx / Lump-sum price"]
["3.6.1","2.1","Fee rate",null,{"$f":"IFERROR(SUM(INDIRECT(\"'Fee (2)'!E34\"))+'Fee rate'!E34,'Fee rate'!E34)+IFERROR(SUM(INDIRECT(\"'Fee (3)'!E34\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Fee (4)'!E34\"))+0,0)","v":0}]
["3.6.2","2.2","Contract-related costs in the country of assignment",null,{"$f":"IFERROR(SUM(INDIRECT(\"'Costs in the country o.a (2)'!E27\"))+'Costs in the country o.a'!E27,'Costs in the country o.a'!E27)+IFERROR(SUM(INDIRECT(\"'Costs in the country o.a (3)'!E27\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Costs in the country o.a (4)'!E27\"))+0,0)","v":0}]
["3.6.3","2.3","National administrative staff",null,{"$f":"'National administative Staff'!H28","v":0}]
["3.6.4.1","3","Transfer and visa costs",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)+IFERROR(SUM(INDIRECT(\"'Travel costs (5)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (6)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (7)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (8)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (9)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (10)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (11)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (12)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (13)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (14)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (15)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (16)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (17)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (18)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (19)'!J43\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (20)'!J43\"))+0,0)","v":0}]
["3.6.4.2","3","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)+IFERROR(SUM(INDIRECT(\"'Travel costs (5)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (6)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (7)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (8)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (9)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (10)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (11)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (12)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (13)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (14)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (15)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (16)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (17)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (18)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (19)'!J44\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (20)'!J44\"))+0,0)","v":0}]
["3.6.4.3","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)+IFERROR(SUM(INDIRECT(\"'Travel costs (5)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (6)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (7)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (8)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (9)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (10)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (11)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (12)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (13)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (14)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (15)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (16)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (17)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (18)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (19)'!J45\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Travel costs (20)'!J45\"))+0,0)","v":0}]
["3.6.5.1","4","Procurement of services and works",null,{"$f":"SUM('Procurement of ser. and works'!G33)","v":0}]
["3.6.5.2","4","Procurement of material goods",null,{"$f":"IFERROR(SUM(INDIRECT(\"'Equipment (2)'!H41\"))+'Procurement of material goods'!H41,'Procurement of material goods'!H41)+IFERROR(SUM(INDIRECT(\"'Equipment (3)'!H41\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Equipment (4)'!H41\"))+0,0)","v":0},null,null,null,null,null,null,null,"Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH Bonn                    \nFriedrich-Ebert-Allee 32 + 36\n53113 Bonn\nGermany"]
["3.6.5.3","4","Operating costs in the country o.a.",null,{"$f":"IFERROR(SUM(INDIRECT(\"'Operating_costs (2)'!D53\"))+Operating_costs!D53,Operating_costs!D53)+IFERROR(SUM(INDIRECT(\"'Operating_costs (3)'!D53\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Operating_costs (4)'!D53\"))+0,0)","v":0},null,null,null,null,null,null,null,"Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH Eschborn              \nDag-Hammarskjöld-Weg 1-5\n65760 Eschborn\nGermany"]
["3.6.5.4","4","Workshops and training costs",null,{"$f":"IFERROR(SUM(INDIRECT(\"'WS & Training (2)'!G38\"))+'WS & Training'!G38,'WS & Training'!G38)+IFERROR(SUM(INDIRECT(\"'WS & Training (3)'!G38\"))+0,0)+IFERROR(SUM(INDIRECT(\"'WS & Training (4)'!G38\"))+0,0)+IFERROR(SUM(INDIRECT(\"'WS & Training (5)'!G38\"))+0,0)+IFERROR(SUM(INDIRECT(\"'WS & Training (6)'!G38\"))+0,0)+IFERROR(SUM(INDIRECT(\"'WS & Training (7)'!G38\"))+0,0)+IFERROR(SUM(INDIRECT(\"'WS & Training (8)'!G38\"))+0,0)+IFERROR(SUM(INDIRECT(\"'WS & Training (9)'!G38\"))+0,0)+IFERROR(SUM(INDIRECT(\"'WS & Training (10)'!G38\"))+0,0)","v":0}]
["3.6.5.5","4","Local contributions",null,{"$f":"IFERROR(SUM(INDIRECT(\"'Local_subsidies (2)'!G23\"))+Local_contributions!G23,Local_contributions!G23)+IFERROR(SUM(INDIRECT(\"'Local_subsidies (3)'!G23\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Local_subsidies (4)'!G23\"))+0,0)","v":0}]
["3.6.5.6","4","Other costs",null,{"$f":"IFERROR(SUM(INDIRECT(\"'Other_costs (2)'!D57\"))+Other_costs!D57,Other_costs!D57)+IFERROR(SUM(INDIRECT(\"'Other_costs (3)'!D57\"))+0,0)+IFERROR(SUM(INDIRECT(\"'Other_costs (4)'!D57\"))+0,0)","v":0}]
["3.6.5.7","4","Flexible remuneration position",null,{"$f":"'Flexible remuneration'!E18","v":0}]
[null,null,"Invoice amount",null,"net",{"$f":"SUM(E33:G46)","v":0}]
[null,null,"VAT base amount"]
[null,null,"+ VAT (%)",null,null,{"$f":"SUM(G48*E49)","v":0}]
[null,null,"Invoice amount",null,"gross",{"$f":"(G48+F49)+(F47-G48)","v":0}]
[null,null,"./. Retention of costs as security",null,"net"]
[null,null,"./. VAT on costs reained (%)",null,null,{"$f":"SUM(F51*E52)","v":0}]
[null,null,"Subtotal",null,null,{"$f":"SUM(F50)-(F51)-(F52)","v":0}]
[null,null,"+ Advance payment",null,"net"]
[null,null,"+ VAT (%)",null,null,{"$f":"SUM(F54*E55)","v":0}]
[null,null,"./.Advance payment (deduction)",null,"net"]
[null,null,"./. VAT  (%)",null,null,{"$f":"SUM(F56*E57)","v":0}]
[null,null,"PAYMENT AMOUNT",null,null,{"$f":"F53+F54+F55-F56-F57","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 rate","index":2,"n_rows":34,"n_cols":7,"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.6.1 Fee"]
["https://www.giz.de/en/workingwithgiz/4184.html"]
["contract number:",null,"project no./Cost centre:",null,"Account period:"]
[{"$f":"'Overview Invoice'!A28:B28","v":"81XXXXXX"},{"$f":"'Overview Invoice'!C28","v":0},null,{"$f":"'Overview Invoice'!G28","v":0}]
[]
["Position","Name","Days","Accounting unit ","Total","Remarks","Reserved for GIZ"]
[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'!G32","v":0},{"$f":"SUM(E7:E33)","v":0}]

{"sheet":"Fachkraftblatt (3)","index":3,"n_rows":136,"n_cols":40,"rows_kept":136,"cut":false,"hidden":true,"merged":[[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],[48,5,49,5],[48,6,49,6],[41,8,41,13],[42,8,42,13],[43,8,43,13],[44,8,44,13],[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],[33,8,33,13],[33,14,33,15],[34,8,34,13],[34,14,34,15],[35,8,35,13],[35,14,35,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],[26,8,26,15],[28,1,29,1],[28,3,28,5],[28,7,29,7],[28,8,29,13],[28,14,29,15],[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],[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],[1,3,1,4],[1,7,1,9],[5,7,5,8],[5,9,5,12],[5,13,5,14],[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]]}
["Nachweis über den Personaleinsatz (3)"]
[null,"Vertragsnummer:",null,"Bearbeitungsnr./Kst.:",null,null,null,"Abrechnungszeitraum:"]
[null,{"$f":"'Overview Invoice'!A28","v":"81XXXXXX"},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":[[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],[48,5,49,5],[48,6,49,6],[41,8,41,13],[42,8,42,13],[43,8,43,13],[44,8,44,13],[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],[33,8,33,13],[33,14,33,15],[34,8,34,13],[34,14,34,15],[35,8,35,13],[35,14,35,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],[26,8,26,15],[28,1,29,1],[28,3,28,5],[28,7,29,7],[28,8,29,13],[28,14,29,15],[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],[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],[1,3,1,4],[1,7,1,9],[5,7,5,8],[5,9,5,12],[5,13,5,14],[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]]}
["Nachweis über den Personaleinsatz (4)"]
[null,"Vertragsnummer:",null,"Bearbeitungsnr./Kst.:",null,null,null,"Abrechnungszeitraum:"]
[null,{"$f":"'Overview Invoice'!A28","v":"81XXXXXX"},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":[[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],[48,5,49,5],[48,6,49,6],[41,8,41,13],[42,8,42,13],[43,8,43,13],[44,8,44,13],[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],[33,8,33,13],[33,14,33,15],[34,8,34,13],[34,14,34,15],[35,8,35,13],[35,14,35,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],[26,8,26,15],[28,1,29,1],[28,3,28,5],[28,7,29,7],[28,8,29,13],[28,14,29,15],[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],[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],[1,3,1,4],[1,7,1,9],[5,7,5,8],[5,9,5,12],[5,13,5,14],[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]]}
["Nachweis über den Personaleinsatz (5)"]
[null,"Vertragsnummer:",null,"Bearbeitungsnr./Kst.:",null,null,null,"Abrechnungszeitraum:"]
[null,{"$f":"'Overview Invoice'!A28","v":"81XXXXXX"},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":[[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],[48,5,49,5],[48,6,49,6],[41,8,41,13],[42,8,42,13],[43,8,43,13],[44,8,44,13],[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],[33,8,33,13],[33,14,33,15],[34,8,34,13],[34,14,34,15],[35,8,35,13],[35,14,35,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],[26,8,26,15],[28,1,29,1],[28,3,28,5],[28,7,29,7],[28,8,29,13],[28,14,29,15],[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],[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],[1,3,1,4],[1,7,1,9],[5,7,5,8],[5,9,5,12],[5,13,5,14],[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]]}
["Nachweis über den Personaleinsatz (6)"]
[null,"Vertragsnummer:",null,"Bearbeitungsnr./Kst.:",null,null,null,"Abrechnungszeitraum:"]
[null,{"$f":"'Overview Invoice'!A28","v":"81XXXXXX"},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":[[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],[48,5,49,5],[48,6,49,6],[41,8,41,13],[42,8,42,13],[43,8,43,13],[44,8,44,13],[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],[33,8,33,13],[33,14,33,15],[34,8,34,13],[34,14,34,15],[35,8,35,13],[35,14,35,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],[26,8,26,15],[28,1,29,1],[28,3,28,5],[28,7,29,7],[28,8,29,13],[28,14,29,15],[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],[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],[1,3,1,4],[1,7,1,9],[5,7,5,8],[5,9,5,12],[5,13,5,14],[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]]}
["Nachweis über den Personaleinsatz (7)"]
[null,"Vertragsnummer:",null,"Bearbeitungsnr./Kst.:",null,null,null,"Abrechnungszeitraum:"]
[null,{"$f":"'Overview Invoice'!A28","v":"81XXXXXX"},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":[[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],[48,5,49,5],[48,6,49,6],[41,8,41,13],[42,8,42,13],[43,8,43,13],[44,8,44,13],[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],[33,8,33,13],[33,14,33,15],[34,8,34,13],[34,14,34,15],[35,8,35,13],[35,14,35,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],[26,8,26,15],[28,1,29,1],[28,3,28,5],[28,7,29,7],[28,8,29,13],[28,14,29,15],[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],[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],[1,3,1,4],[1,7,1,9],[5,7,5,8],[5,9,5,12],[5,13,5,14],[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]]}
["Nachweis über den Personaleinsatz (8)"]
[null,"Vertragsnummer:",null,"Bearbeitungsnr./Kst.:",null,null,null,"Abrechnungszeitraum:"]
[null,{"$f":"'Overview Invoice'!A28","v":"81XXXXXX"},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":[[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],[48,5,49,5],[48,6,49,6],[41,8,41,13],[42,8,42,13],[43,8,43,13],[44,8,44,13],[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],[33,8,33,13],[33,14,33,15],[34,8,34,13],[34,14,34,15],[35,8,35,13],[35,14,35,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],[26,8,26,15],[28,1,29,1],[28,3,28,5],[28,7,29,7],[28,8,29,13],[28,14,29,15],[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],[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],[1,3,1,4],[1,7,1,9],[5,7,5,8],[5,9,5,12],[5,13,5,14],[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]]}
["Nachweis über den Personaleinsatz (9)"]
[null,"Vertragsnummer:",null,"Bearbeitungsnr./Kst.:",null,null,null,"Abrechnungszeitraum:"]
[null,{"$f":"'Overview Invoice'!A28","v":"81XXXXXX"},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":[[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],[48,5,49,5],[48,6,49,6],[41,8,41,13],[42,8,42,13],[43,8,43,13],[44,8,44,13],[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],[33,8,33,13],[33,14,33,15],[34,8,34,13],[34,14,34,15],[35,8,35,13],[35,14,35,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],[26,8,26,15],[28,1,29,1],[28,3,28,5],[28,7,29,7],[28,8,29,13],[28,14,29,15],[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],[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],[1,3,1,4],[1,7,1,9],[5,7,5,8],[5,9,5,12],[5,13,5,14],[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]]}
["Nachweis über den Personaleinsatz (10)"]
[null,"Vertragsnummer:",null,"Bearbeitungsnr./Kst.:",null,null,null,"Abrechnungszeitraum:"]
[null,{"$f":"'Overview Invoice'!A28","v":"81XXXXXX"},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":"Costs in the country o.a","index":11,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,5],[3,1,3,2],[3,3,3,4]]}
[" 3.6.2 Costs related to the contract in the country assignment"]
[]
["contract no:",null,"project no./Cost centre:",null,null,"Accounting period:"]
[{"$f":"'Overview Invoice'!A28:B28","v":"81XXXXXX"},{"$f":"'Overview Invoice'!C28","v":0},null,{"$f":"'Overview Invoice'!G28","v":0}]
[]
["Position","Name","Days","Price","Total","Remarks","Reserved for GIZ"]
[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]
["Total",null,null,{"$f":"'Overview Invoice'!G32","v":0},{"$f":"SUM(E7:E26)","v":0}]

{"sheet":"National administative Staff","index":12,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["3.6.3   National administrative staff (lump sum on submission of copy of employment contract)"]
[]
[null,"Contract number:","Project no./Cost Centre:",null,"Accounting period:"]
[null,{"$f":"'Overview Invoice'!A28","v":"81XXXXXX"},{"$f":"'Overview Invoice'!C28","v":0},null,{"$f":"'Overview Invoice'!G28","v":0}]
[]
[]
["Voucher \nno.","Name ","Start in the accounting period\n(dd/mm/yy)","End in the accounting period\n(dd/mm/yy)","Costs  \n/month","Month","Days","Total","Remarks"]
[1,null,null,null,null,null,null,{"$f":"(F8+(G8/30))*E8","v":0},null,null,null,"Pauschal"]
[2,null,null,null,null,null,null,{"$f":"(F9+(G9/30))*E9","v":0}]
[3,null,null,null,null,null,null,{"$f":"(F10+(G10/30))*E10","v":0}]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,0]
["Total:",null,null,null,null,null,{"$f":"'Overview Invoice'!G32","v":0},{"$f":"SUM(H8:H27)","v":0}]

{"sheet":"Travel costs","index":13,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,0,12],[3,3,3,4],[2,0,2,1]]}
[" 3.6.4 Travel costs"]
[]
["Contract number:",null,"project no./Cost centre:",null,"Accounting period:"]
[{"$f":"'Overview Invoice'!A28:B28","v":"81XXXXXX"},null,{"$f":"'Overview Invoice'!C28","v":0},{"$f":"'Overview Invoice'!G28","v":0}]
[]
["Voucher no.","Position","Sub position*","type of reimbursement","Name","Quantity","Amount \n(from voucher or lump sum)","Currency","rate**","Total","Date \nStart (dd/mm/yy)","Date \nEnd (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,{"$f":"F8*G8*I8","v":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,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 Transfer and visa costs",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 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'!G32","v":0},{"$f":"SUM(J43:J46)","v":0}]

{"sheet":"Procurement of ser. and works","index":14,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["3.6.5.1  Procurement of services and works (only against evidence)"]
[]
[null,"Contract number:","Project no. /Cost Centre:",null,"Accounting period:"]
[null,{"$f":"'Overview Invoice'!A28","v":"81XXXXXX"},{"$f":"'Overview Invoice'!C28","v":0},null,{"$f":"'Overview Invoice'!G28","v":0}]
[]
[]
["Voucher no.","Name of Subcontractor","Purpose of the assignment","Amount \n(from voucher)","Currency**","Rate","Amount","Remarks"]
[1,null,null,null,null,null,{"$f":"D8*F8","v":0}]
[2,null,null,null,null,null,{"$f":"D9*F9","v":0}]
[3,null,null,null,null,null,{"$f":"D10*F10","v":0}]
[4,null,null,null,null,null,0]
[5,null,null,null,null,null,0]
[6,null,null,null,null,null,0]
[7,null,null,null,null,null,0]
[8,null,null,null,null,null,0]
[9,null,null,null,null,null,0]
[10,null,null,null,null,null,0]
[11,null,null,null,null,null,0]
[12,null,null,null,null,null,0]
[13,null,null,null,null,null,0]
[14,null,null,null,null,null,0]
[15,null,null,null,null,null,0]
[16,null,null,null,null,null,0]
[17,null,null,null,null,null,0]
[18,null,null,null,null,null,0]
[19,null,null,null,null,null,0]
[20,null,null,null,null,null,0]
[21,null,null,null,null,null,0]
[22,null,null,null,null,null,0]
[23,null,null,null,null,null,0]
[24,null,null,null,null,null,0]
[25,null,null,null,null,null,0]
["Total:",null,null,null,null,{"$f":"'Overview Invoice'!G32","v":0},{"$f":"SUM(G8:G32)","v":0}]

{"sheet":"Procurement of material goods","index":15,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["3.6.5.2  Procurement of material goods (only against evidence)"]
[null,"Contract number:",null,"project number/Cost Center:",null,null,null,"Accounting period:"]
[null,{"$f":"'Overview Invoice'!A28","v":"81XXXXXX"},{"$f":"'Overview Invoice'!C28","v":0},null,null,null,null,{"$f":"'Overview Invoice'!G28","v":0}]
[]
[]
["Voucher\nno.","Procured eqipment","Supplier","Voucher date\n(dd/mm/yy)","Amount \n(from voucher)","Currency","rate**","Amount","Remarks"]
[1,null,null,null,null,null,null,{"$f":"E7*G7","v":0}]
[2,null,null,null,null,null,null,{"$f":"E8*G8","v":0}]
[3,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,{"$f":"E18*G18","v":0}]
[13,null,null,null,null,null,null,{"$f":"E19*G19","v":0}]
[14,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,0]
[32,null,null,null,null,null,null,0]
[33,null,null,null,null,null,null,0]
[34,null,null,null,null,null,null,0]
["Total:",null,null,null,null,null,{"$f":"'Overview Invoice'!G32","v":0},{"$f":"SUM(H7:H40)","v":0}]

{"sheet":"Operating_costs","index":16,"n_rows":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,0,7],[22,0,22,5]]}
["3.6.5.3.   Operating costs in country of assigment"]
[]
[null,"Contract number:",null,"Project number/Cost Centre:",null,"Accountingperiod:"]
[null,{"$f":"'Overview Invoice'!A28","v":"81XXXXXX"},null,{"$f":"'Overview Invoice'!C28","v":0},null,{"$f":"'Overview Invoice'!G28","v":0}]
[]
[]
["Operating costs in country of assigment"]
[]
["Lump sum"]
["No.","Type of operating costs","Lump sum price","Quantity","Amount ","Remarks"]
[1,null,null,null,{"$f":"C11*D11","v":0}]
[2,null,null,null,{"$f":"SUM(C12*D12)","v":0}]
[3,null,null,null,0]
[4,null,null,null,0]
[5,null,null,null,0]
[6,null,null,null,0]
[7,null,null,null,0]
[8,null,null,null,0]
[9,null,null,null,0]
[10,null,null,null,0]
["Sub total:",null,null,{"$f":"'Overview Invoice'!G32","v":0},{"$f":"SUM(E11:E20)","v":0}]
[]
["Against Evidence"]
["No.","Type of operating costs","Amount","Quantity","Amount ","Remarks"]
[1,null,null,null,{"$f":"C25*D25","v":0}]
[2,null,null,null,{"$f":"C26*D26","v":0}]
[3,null,null,null,0]
[4,null,null,null,0]
[5,null,null,null,0]
[6,null,null,null,0]
[7,null,null,null,0]
[8,null,null,null,0]
[9,null,null,null,0]
[10,null,null,null,0]
[11,null,null,null,0]
[12,null,null,null,0]
[13,null,null,null,0]
[14,null,null,null,0]
[15,null,null,null,0]
[16,null,null,null,0]
[17,null,null,null,0]
[18,null,null,null,0]
[19,null,null,null,0]
[20,null,null,null,0]
[21,null,null,null,0]
[22,null,null,null,0]
[23,null,null,null,0]
[24,null,null,null,0]
[25,null,null,null,0]
["Sub total:",null,null,{"$f":"'Overview Invoice'!G32","v":0},{"$f":"SUM(E25:E49)","v":0}]
[]
[]
["Total:",null,null,{"$f":"E50+E21","v":0}]

{"sheet":"WS & Training","index":17,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,7],[37,1,37,2],[5,2,5,5]]}
["3.6.5.4.   Workshops and Training - Invoicing per workshop (only against evidence)"]
[]
[null,"Contract number:",null,"Project no./Cost Centre:",null,"Accounting period:"]
[null,{"$f":"'Overview Invoice'!A28","v":"81XXXXXX"},null,{"$f":"'Overview Invoice'!C28","v":0},null,{"$f":"'Overview Invoice'!G28","v":0}]
[]
["V1","Type of event:",null,null,null,null,"Place/Date:"]
["Voucher no.","Content of the document","Date of voucher\n(dd/mm/yy)","Amount\n (from voucher)","Currency","Rate**","Amount","Remarks"]
[1,null,null,null,null,null,{"$f":"D8*F8","v":0}]
[2,null,null,null,null,null,{"$f":"D9*F9","v":0}]
[3,null,null,null,null,null,{"$f":"D10*F10","v":0}]
[4,null,null,null,null,null,0]
[5,null,null,null,null,null,0]
[6,null,null,null,null,null,0]
[7,null,null,null,null,null,0]
[8,null,null,null,null,null,0]
[9,null,null,null,null,null,0]
[10,null,null,null,null,null,0]
[11,null,null,null,null,null,0]
[12,null,null,null,null,null,0]
[13,null,null,null,null,null,0]
[14,null,null,null,null,null,0]
[15,null,null,null,null,null,0]
[16,null,null,null,null,null,0]
[17,null,null,null,null,null,0]
[18,null,null,null,null,null,0]
[19,null,null,null,null,null,0]
[20,null,null,null,null,null,0]
[21,null,null,null,null,null,0]
[22,null,null,null,null,null,0]
[23,null,null,null,null,null,0]
[24,null,null,null,null,null,0]
[25,null,null,null,null,null,0]
[26,null,null,null,null,null,0]
[27,null,null,null,null,null,0]
[28,null,null,null,null,null,0]
[29,null,null,null,null,null,0]
[30,null,null,null,null,null,{"$f":"D37*F37","v":0}]
[null,"Total V1:",null,null,null,{"$f":"'Overview Invoice'!G32","v":0},{"$f":"SUM(G8:G37)","v":0}]

{"sheet":"Local_contributions","index":18,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["3.6.5.5  Local contributions (only against evidence)"]
[]
[null,"Contract number:",null,"Project no./Costs Centre:",null,"Accounting period:"]
[null,{"$f":"'Overview Invoice'!A28","v":"81XXXXXX"},null,{"$f":"'Overview Invoice'!C28","v":0},null,{"$f":"'Overview Invoice'!G28","v":0}]
[]
[]
["Voucher no.","Recipient","Contract number","Amount \n(from voucher)","Currency","Rate**","Subsidy ","Remarks"]
[1,null,null,null,null,null,{"$f":"D8*F8","v":0}]
[2,null,null,null,null,null,{"$f":"D9*F9","v":0}]
[3,null,null,null,null,null,{"$f":"D10*F10","v":0}]
[4,null,null,null,null,null,0]
[5,null,null,null,null,null,0]
[6,null,null,null,null,null,0]
[7,null,null,null,null,null,0]
[8,null,null,null,null,null,0]
[9,null,null,null,null,null,0]
[10,null,null,null,null,null,0]
[11,null,null,null,null,null,0]
[12,null,null,null,null,null,0]
[13,null,null,null,null,null,0]
[14,null,null,null,null,null,0]
[15,null,null,null,null,null,{"$f":"D22*F22","v":0}]
["Total:",null,null,null,null,{"$f":"'Overview Invoice'!G32","v":0},{"$f":"SUM(G8:G22)","v":0}]

{"sheet":"Other_costs","index":19,"n_rows":57,"n_cols":8,"rows_kept":57,"cut":false,"hidden":false,"merged":[[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],[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]]}
["3.6.5.6  Other costs"]
[]
[null,"Contract number:",null,"project number /Cost centre:",null,"Accounting period:"]
[null,{"$f":"'Overview Invoice'!A28","v":"81XXXXXX"},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'!G32","v":0},{"$f":"SUM(E9:E28)","v":0}]
[]
[]
[]
["against evidence"]
["Voucher no.","Content of the document","Date of voucher\n(dd/mm/yy)","Amount \n(from voucher)","Currency","Rate**","Amount ","Remarks"]
[1,null,null,null,null,null,{"$f":"D35*F35","v":0}]
[2,null,null,null,null,null,0]
[3,null,null,null,null,null,0]
[4,null,null,null,null,null,0]
[5,null,null,null,null,null,0]
[6,null,null,null,null,null,0]
[7,null,null,null,null,null,0]
[8,null,null,null,null,null,0]
[9,null,null,null,null,null,0]
[10,null,null,null,null,null,0]
[11,null,null,null,null,null,0]
[12,null,null,null,null,null,0]
[13,null,null,null,null,null,0]
[14,null,null,null,null,null,0]
[15,null,null,null,null,null,0]
[16,null,null,null,null,null,0]
[17,null,null,null,null,null,0]
[18,null,null,null,null,null,0]
[19,null,null,null,null,null,0]
[20,null,null,null,null,null,0]
["Sub total:",null,null,null,null,{"$f":"'Overview Invoice'!G32","v":0},{"$f":"SUM(G35:G54)","v":0}]
[]
["Total Other costs:",null,null,{"$f":"G55+E29","v":0}]

{"sheet":"Flexible remuneration","index":20,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[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],[0,0,0,7],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3]]}
["3.6.5.7  Flexible remuneration position (only in the presence of confirmation by AV)"]
[]
[null,"Contract number:","project number /Cost Centre:","Accounting period:"]
[null,{"$f":"'Overview Invoice'!A28","v":"81XXXXXX"},{"$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}]