{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Maandelijkse kostenstaat","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Maandelijkse kostenstaat","index":0,"n_rows":39,"n_cols":29,"rows_kept":39,"cut":false,"hidden":false,"merged":[[29,2,29,5],[8,0,8,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[1,0,1,1],[0,0,0,1],[15,26,15,27],[21,26,25,27],[15,7,15,24],[15,4,15,5],[7,26,7,27],[8,26,8,27],[9,26,9,27],[10,26,10,27]]}
["V.2023",null,null,"Kostenstaat",null,"2023/01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Datum",{"$f":"NOW()","v":"2023-01-10T15:15:55.230"},1]
["Januari"]
["Maatschappelijke Benaming :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BTW berekenen",{"$f":"IF(AC1=1,\"JA\",\"NEE\")","v":"JA"}]
["Identificatienummer :"]
["VTI : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wachttijd",{"$f":"Data!B7","v":41.53}]
["Adres :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prestatie",{"$f":"Data!B2","v":58.63}]
["Postcode :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Verplaatsing",{"$f":"Data!B6","v":0.64710000000000001}]
["BTW :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FOD Justitie"]
["Bankrekening  :  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waterloolaan 115"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1000 Brussel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BTW 0308.357.753"]
["N° Prestatie","Datum","Wachttijd Begin","Wachttijd Einde","Prestatie Begin","Prestatie Einde","Vorderende autoriteiten","Notitie","NJ","EX","Type","Idem avant","MA","JN","Forfait possible","Forfait heure","Jour","Nuit","Tno","Tsa","Tco","Tfe","Tatt","Suppl","Km","Afstand","Prestatie en wachttijd","Totaal"]
[{"$f":"ROW()-12","v":1},"2100-01-01",0,0,0,0,"ORIGINAL","ORIGINAL",{"$f":"WEEKDAY(Tableau1[Datum],2)","v":5},null,{"$f":"IF(OR(COUNTIF(Tableau3[Holidays],Tableau1[Datum]),Tableau1[NJ]=7),\"F\",IF(Tableau1[EX]=\"C\",\"C\",IF(Tableau1[NJ]=6,\"SA\",\"N\")))","v":"N"},{"$f":"COUNTIF($B$10:B13,Tableau1[Datum])","v":1},{"$f":"IF(Tableau1[Prestatie Begin]<12/24,0,1)","v":0},{"$f":"IF(OR(Tableau1[Prestatie Begin]<6/24,Tableau1[Prestatie Begin]>=22/24),\"NUIT\",\"JOUR\")","v":"NUIT"},{"$f":"IF(OR(Tableau1[Idem avant]=1,Tableau1[MA]<>INDIRECT(ADDRESS(ROW()-1,COLUMN()-2))),\"OUI\",\"NON\")","v":"OUI"},{"$f":"IF(AND(Tableau1[Prestatie Einde]-Tableau1[Prestatie Begin]<1/24,Tableau1[Forfait possible]=\"OUI\"),\"OUI\",\"NON\")","v":"OUI"},{"$f":"IF(Tableau1[[#This Row],[Prestatie Einde]]-Tableau1[[#This Row],[Prestatie Begin]]=0,0,IF(AND(Tableau1[Forfait heure]=\"OUI\",Tableau1[Type]=\"F\"),0,IF(AND(Tableau1[Forfait heure]=\"OUI\",Tableau1[JN]=\"NUIT\"),0,IF(AND(Tableau1[Forfait heure]=\"OUI\",Tableau1[JN]=\"JOUR\"),1/24,IF(Tableau1[[#This Row],[Type]]=\"F\",0,Tableau1[Prestatie Einde]-Tableau1[Prestatie Begin]-Tableau1[Nuit])))))","v":0},{"$f":"IF(Tableau1[[#This Row],[Prestatie Einde]]-Tableau1[[#This Row],[Prestatie Begin]]=0,0,IF(Tableau1[EX]=\"V\",0,IF(AND(Tableau1[Forfait heure]=\"OUI\",Tableau1[Type]=\"F\"),1/24,IF(AND(Tableau1[Forfait heure]=\"OUI\",Tableau1[JN]=\"NUIT\"),1/24,IF(AND(Tableau1[Forfait heure]=\"OUI\",Tableau1[JN]=\"JOUR\"),0,IF(Tableau1[[#This Row],[Type]]=\"F\",Tableau1[[#This Row],[Prestatie Einde]]-Tableau1[[#This Row],[Prestatie Begin]],IF(Tableau1[Prestatie Begin]>=22/24,Tableau1[Prestatie Einde]-Tableau1[Prestatie Begin],IF(Tableau1[Prestatie Einde]>=22/24,Tableau1[Prestatie Einde]-22/24,IF(Tableau1[Prestatie Einde]<6/24,Tableau1[Prestatie Einde]-Tableau1[Prestatie Begin],IF(Tableau1[Prestatie Begin]<6/24,6/24-Tableau1[Prestatie Begin],0))))))))))","v":0},{"$f":"IF(Tableau1[EX]=\"AN\",0,IF(OR(Tableau1[Type]=\"F\",Tableau1[Type]=\"SA\",Tableau1[Type]=\"C\"),0,Tableau1[Jour]))","v":0},{"$f":"IF(Tableau1[EX]=\"AN\",0,IF(Tableau1[Type]=\"SA\",Tableau1[Jour],0))","v":0},{"$f":"IF(Tableau1[EX]=\"AN\",0,IF(Tableau1[Type]=\"C\",Tableau1[Jour],0))","v":0},{"$f":"IF(Tableau1[EX]=\"AN\",0,Tableau1[Nuit])","v":0},{"$f":"IF(AND(Tableau1[EX]=\"AN\",Tableau1[Wachttijd Einde]-Tableau1[Wachttijd Begin]<1/24),1/24,IF(Tableau1[EX]=\"AN\",Tableau1[Wachttijd Einde]-Tableau1[Wachttijd Begin],IF(AND(Tableau1[Forfait heure]=\"OUI\",(Tableau1[Prestatie Einde]-Tableau1[Prestatie Begin])+(Tableau1[Wachttijd Einde]-Tableau1[Wachttijd Begin])<0.0416),0,Tableau1[Wachttijd Einde]-Tableau1[Wachttijd Begin])))","v":0},{"$f":"IF(Tableau1[EX]=\"S\",Tableau1[Jour]+Tableau1[Nuit],0)","v":0},0,{"$f":"Tableau1[Km]*Data!$B$6","v":0},{"$f":"Tableau1[Tno]*Data!$C$2+Tableau1[Tsa]*Data!$C$3+Tableau1[Tco]*Data!$C$4+Tableau1[Tfe]*Data!$C$5+Tableau1[Tatt]*Data!$C$7+Tableau1[Suppl]*Data!$C$8","v":0},{"$f":"Tableau1[Afstand]+Tableau1[Prestatie en wachttijd]","v":0}]
[]
[]
[null,null,null,null,"TOTAL verplaatsing",null,null,"Totaal zonder verplaatsing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAAL"]
[null,null,null,null,"excl. BTW",{"$f":"SUM(Tableau1[Afstand])","v":0},null,"excl. BTW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Tableau1[Prestatie en wachttijd])","v":0},null,"excl. BTW",{"$f":"SUM(Tableau1[Totaal])","v":0}]
[null,null,null,null,"BTW",{"$f":"IF($AC$1=1,F17*21%,0)","v":0},null,"BTW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AC$1=1,Y17*21%,0)","v":0},null,"BTW",{"$f":"IF($AC$1=1,AB17*21%,0)","v":0}]
[]
[null,null,null,null,"incl. BTW",{"$f":"F17+F18","v":0},null,"incl. BTW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y17+Y18","v":0},null,"incl. BTW",{"$f":"AB17+ROUND(AB18,2)","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,"Handtekening :"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ik verklaar op mijn eer dat bovenstaande verklaring correct en volledig is."]
[null,null,"Samenvatting"]
[null,null,"Samenvatting","Uren","Prijs","Tarief"]
[null,null,"Zonder verhoging",{"$f":"SUM(Tableau1[Tno])","v":0},{"$f":"D32*Data!$C$2","v":0},{"$f":"Data!B2","v":58.63}]
[null,null,"Verhoging 50%",{"$f":"SUM(Tableau1[Tsa])","v":0},{"$f":"D33*Data!$C$3","v":0},{"$f":"Data!B3","v":87.945000000000007}]
[null,null,"Verhoging 65%",{"$f":"SUM(Tableau1[Tco])","v":0},{"$f":"D34*Data!$C$4","v":0},{"$f":"Data!B4","v":96.739499999999992}]
[null,null,"Verhoging 100%",{"$f":"SUM(Tableau1[Tfe])","v":0},{"$f":"D35*Data!$C$5","v":0},{"$f":"Data!B5","v":117.26}]
[null,null,"Suppl COVID",{"$f":"SUM(Tableau1[Suppl])","v":0},{"$f":"D36*Data!$C$8","v":0},{"$f":"Data!B8","v":8.7944999999999993}]
[null,null,"Wachttijd",{"$f":"SUM(Tableau1[Tatt])","v":0},{"$f":"D37*Data!$C$7","v":0},{"$f":"Data!B7","v":41.53}]
[null,null,"Km",{"$f":"SUM(Tableau1[Km])","v":0},{"$f":"D38*Data!$B$6","v":0},{"$f":"Data!B6","v":0.64710000000000001}]
[null,null,null,null,null,{"$f":"SUM(E32:E38)","v":0}]

{"sheet":"Data","index":1,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Tarifs","heures","24h",null,null,"Holidays"]
["Normal",58.63,{"$f":"Tableau2[[#This Row],[heures]]*24","v":1407.1200000000001},null,null,"2023-01-01"]
["Samedi",{"$f":"B2*1.5","v":87.945000000000007},{"$f":"Tableau2[[#This Row],[heures]]*24","v":2110.6800000000003},null,null,"2023-04-10"]
["Coffre",{"$f":"B2*1.65","v":96.739499999999992},{"$f":"Tableau2[[#This Row],[heures]]*24","v":2321.7479999999996},null,null,"2023-05-01"]
["Holiday",{"$f":"B2*2","v":117.26},{"$f":"Tableau2[[#This Row],[heures]]*24","v":2814.2400000000002},null,null,"2023-05-18"]
["Distance",0.64710000000000001,{"$f":"Tableau2[[#This Row],[heures]]*24","v":15.5304},null,null,"2023-05-29"]
["Attente",41.53,{"$f":"Tableau2[[#This Row],[heures]]*24","v":996.72},null,null,"2023-07-21"]
["Covid",{"$f":"B2*15%","v":8.7944999999999993},{"$f":"Tableau2[[#This Row],[heures]]*24","v":211.06799999999998},null,null,"2023-08-15"]
[null,null,null,null,null,"2023-11-01"]
[null,null,null,null,null,"2023-11-11"]
[null,null,null,null,null,"2023-12-25"]