{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Time record","Lists"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":5,"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":"Time record","index":0,"n_rows":70,"n_cols":8,"rows_kept":70,"cut":false,"hidden":false,"merged":[[10,1,10,4],[12,1,12,4],[67,1,67,7],[68,1,68,7],[69,1,69,7],[61,1,61,7],[62,1,62,7],[64,1,64,7],[65,1,65,7],[66,1,66,7],[55,1,55,7],[57,1,57,7],[58,1,58,7],[59,1,59,7],[60,1,60,7],[4,5,4,6],[2,5,2,6],[14,2,14,4],[0,1,0,7],[54,1,54,7],[16,2,16,5],[6,5,6,7],[8,5,8,7],[10,5,10,7],[12,5,12,7],[17,2,17,5],[53,1,53,7],[4,1,4,4],[2,1,2,4],[6,1,6,4],[8,1,8,4]]}
[null,"\n\nTime record "]
[]
[null,"Contract number (VN):"]
[]
[null,"Project number (PN) / Cost centre (KST):"]
[]
[null,"Contractor:"]
[]
[null,"Contractor’s address:"]
[]
[null,"Name of expert:"]
[]
[null,"Role / position:"]
[]
[null,"Month:","please select",null,null,"Year:","please select"]
[]
[null,null,"1 = full day\n0,5 = half day\nx = yes / applicable",null,null,null,"\n\n"]
[]
[null," Date"," Expert-days"," Costs related to contract \n in country of assignment"," Per-diem allowance"," Overnight accommo-\n dation allowance","Location","Activity / Work content / Output"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[]
[null,"Total",{"$f":"SUM(C20:C50)","v":0},{"$f":"IFERROR(\"Fachkrafttage (FKT) im \"&TEXT(DATEVALUE(\"1 \"&C15&\" \"&G15),\"MMMM JJJJ\"),\"\")","v":""}]
[]
[null,"I hereby confirm that the content of the above statements is correct."]
[]
[null,"Expert (Name and date), electronic transmission, hence no signature"]
[]
[null,"Notes when the \"General Terms and Conditions (AVB)\" are applied:"]
[null,"• Expert-days see Section 3.3.1 Terms and Conditions 2023"]
[null,"• In the case of hourly billing, include the number of hours worked under \"Activities / Work content / Output\""]
[null,"• Costs related to contract in country of assignment, see Section 3.3.2 Terms and Conditions 2023"]
[null,"• Per-diem allowance, see Section 3.3.4.2 Terms and Conditions 2023"]
[null,"• Overnight accommodation allowance, see Section 3.3.4.3 Terms and Conditions 2023"]
[]
[null,"Notes when the \"Local General Terms and Conditions (AVB lokal)\" are applied:"]
[null,"• Expert-days see Section 3.1.1 AVB 2024 (local terms and conditions)"]
[null,"• In the case of hourly billing, include the number of hours worked under \"Activities / Work content / Output\""]
[null,"• Costs related to contract in country of assignment are not relevant for local contracts"]
[null,"• Per-diem allowance, see Section 3.1.2.2 AVB 2024 (local terms and conditions)"]
[null,"• Overnight accommodation allowance, see Section 3.1.2.3 AVB 2024 (local terms and conditions)"]

{"sheet":"Lists","index":1,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,"Monate",null,"Jahre",null,"Datum",null,"Fachfrakfttage"]
[null,null,"January","Januar",{"$f":"E6-1","v":2020},null,{"$f":"IFERROR(DATEVALUE(\"1 \"&VLOOKUP('Time record'!C15,$C$5:$D$16,2,0)&\" \"&'Time record'!G15),0)","v":0},null,1]
[null,null,"February","Februar",2021,null,{"$f":"IFERROR(DAY(DATE(YEAR(G5),MONTH(G5)+1,0)),31)","v":31},null,0.5]
[null,null,"March","März",2022]
[null,null,"April","April",2023]
[null,null,"May","Mai",{"$f":"YEAR(TODAY())","v":2024}]
[null,null,"June","Juni",{"$f":"E9+1","v":2025}]
[null,null,"July","Juli",{"$f":"E10+1","v":2026}]
[null,null,"August","August",{"$f":"E11+1","v":2027}]
[null,null,"September","September",2028]
[null,null,"October","Oktober",2029]
[null,null,"November","November",2030]
[null,null,"December","Dezember",2031]
[null,null,null,null,2032]
[null,null,null,null,{"$f":"E17+1","v":2033}]
[null,null,null,null,2034]