{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Monatliche Kostenaufstellung","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":"Monatliche Kostenaufstellung","index":0,"n_rows":39,"n_cols":29,"rows_kept":39,"cut":false,"hidden":false,"merged":[[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],[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]]}
["V.2023",null,null,"Kostenaufstellung ",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-17T14:34:03.940"},1]
["Januar"]
["Gesellschaftsname : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MwSt. berechnen",{"$f":"IF(AC1=1,\"JA\",\"NEIN\")","v":"JA"}]
["Identifizierungsnummer :"]
["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,"Wartezeit",{"$f":"Data!B7","v":41.53}]
["Adresse : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dienstleistung",{"$f":"Data!B2","v":58.63}]
["PLZ : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fahrtkosten",{"$f":"Data!B6","v":0.64710000000000001}]
["MwSt. : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FÖD Justiz"]
["Konto  :  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Boulevard de Waterloo 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 Brüssel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZUD : BE 0308.357.753"]
["N° Leistung","Datum","Beginn der Wartezeit","Wartezeit Ende","Beginn der Leistung","Leistung Ende","Auftraggebende Behörde","Aktenzeichen","NJ","EX","Type","Idem avant","MA","JN","Forfait possible","Forfait heure","Jour","Nuit","Tno","Tsa","Tco","Tfe","Tatt","Suppl","Km","Fahrtkosten","Leistung und Wartezeit","Gesamtbetrag"]
[{"$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[Beginn der Leistung]<12/24,0,1)","v":0},{"$f":"IF(OR(Tableau1[Beginn der Leistung]<6/24,Tableau1[Beginn der Leistung]>=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[Leistung Ende]-Tableau1[Beginn der Leistung]<1/24,Tableau1[Forfait possible]=\"OUI\"),\"OUI\",\"NON\")","v":"OUI"},{"$f":"IF(Tableau1[[#This Row],[Leistung Ende]]-Tableau1[[#This Row],[Beginn der Leistung]]=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[Leistung Ende]-Tableau1[Beginn der Leistung]-Tableau1[Nuit])))))","v":0},{"$f":"IF(Tableau1[[#This Row],[Leistung Ende]]-Tableau1[[#This Row],[Beginn der Leistung]]=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],[Leistung Ende]]-Tableau1[[#This Row],[Beginn der Leistung]],IF(Tableau1[Beginn der Leistung]>=22/24,Tableau1[Leistung Ende]-Tableau1[Beginn der Leistung],IF(Tableau1[Leistung Ende]>=22/24,Tableau1[Leistung Ende]-22/24,IF(Tableau1[Leistung Ende]<6/24,Tableau1[Leistung Ende]-Tableau1[Beginn der Leistung],IF(Tableau1[Beginn der Leistung]<6/24,6/24-Tableau1[Beginn der Leistung],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[Wartezeit Ende]-Tableau1[Beginn der Wartezeit]<1/24),1/24,IF(Tableau1[EX]=\"AN\",Tableau1[Wartezeit Ende]-Tableau1[Beginn der Wartezeit],IF(AND(Tableau1[Forfait heure]=\"OUI\",(Tableau1[Leistung Ende]-Tableau1[Beginn der Leistung])+(Tableau1[Wartezeit Ende]-Tableau1[Beginn der Wartezeit])<0.0416),0,Tableau1[Wartezeit Ende]-Tableau1[Beginn der Wartezeit])))","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[Fahrtkosten]+Tableau1[Leistung und Wartezeit]","v":0}]
[]
[]
[null,null,null,null,"Gesamtbetrag der Reisekosten",null,null,"Gesamtbetrag ohne Reisekosten",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gesamtbetrag"]
[null,null,null,null,"exkl. MwSt.",{"$f":"SUM(Tableau1[Fahrtkosten])","v":0},null,"exkl. MwSt.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Tableau1[Leistung und Wartezeit])","v":0},null,"exkl. MwSt.",{"$f":"SUM(Tableau1[Gesamtbetrag])","v":0}]
[null,null,null,null,"MwSt.",{"$f":"IF($AC$1=1,F17*21%,0)","v":0},null,"MwSt.",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,"MwSt.",{"$f":"IF($AC$1=1,AB17*21%,0)","v":0}]
[]
[null,null,null,null,"inkl. MwSt.",{"$f":"F17+F18","v":0},null,"inkl. MwSt.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y17+Y18","v":0},null,"inkl. MwSt.",{"$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,"Unterschrift :"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ich erkläre ehrenwörtlich, dass die oben genannte Erklärung richtig und vollständig ist."]
[null,null,"Zusammenfassung"]
[null,null,"Zusammenfassung","Stunden","Preis","Tarif"]
[null,null,"Ohne Erhöhung",{"$f":"SUM(Tableau1[Tno])","v":0},{"$f":"D32*Data!$C$2","v":0},{"$f":"Data!B2","v":58.63}]
[null,null,"Erhöhung um 50%",{"$f":"SUM(Tableau1[Tsa])","v":0},{"$f":"D33*Data!$C$3","v":0},{"$f":"Data!B3","v":87.945000000000007}]
[null,null,"Erhöhung um 65%",{"$f":"SUM(Tableau1[Tco])","v":0},{"$f":"D34*Data!$C$4","v":0},{"$f":"Data!B4","v":96.739499999999992}]
[null,null,"Erhöhung um 100%",{"$f":"SUM(Tableau1[Tfe])","v":0},{"$f":"D35*Data!$C$5","v":0},{"$f":"Data!B5","v":117.26}]
[null,null,"COVID-Zuschlag",{"$f":"SUM(Tableau1[Suppl])","v":0},{"$f":"D36*Data!$C$8","v":0},{"$f":"Data!B8","v":8.7944999999999993}]
[null,null,"Wartezeit",{"$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"]