{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Fahrzeuge","LKW, Busse, Sonderfahrzeuge","Ladeinfrastruktur","spezielle Ladeinfrastruktur","Vorlage für AZA"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":26,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Fahrzeuge","index":0,"n_rows":296,"n_cols":23,"rows_kept":296,"cut":false,"hidden":false,"merged":[[0,0,0,1],[5,0,5,7],[6,0,6,7],[9,0,9,7],[8,0,8,7],[7,0,7,7],[4,0,4,7]]}
["Antragsteller ist vorsteuerabzugsberechtigt [Auswahlbox]:",null,null,null,"ja","nein","Stand: 05.07.2018",{"$f":"MATCH(\"Summe\",A:A,0)","v":33},"FKZ"]
[{"$nulls":6},"korrigiert: 11.05.2022",null,"03EMI3"]
["Hinweise:",{"$nulls":5},"ergänzt: 05.10.2022"]
["Mit dieser Tabelle können Sie die förderfähigen Investitionsmehrkosten ermitteln, die in das AZA-Formular in easyOnline eingegeben werden müssen."]
[{"$f":"IF(Fahrzeuge!C1=\"\",\"1.  Wählen Sie zunächst aus, ob Sie zum Vorsteuerabzug berechtigt sind!\",\"\")","v":"1.  Wählen Sie zunächst aus, ob Sie zum Vorsteuerabzug berechtigt sind!"}]
["2. Wählen Sie in der Liste unten die gewünschten Fahrzeuge(Auswahlbox) und die entsprechende Anzahl aus."]
["3. Für Ladeinfrastruktur sowie LKW, Busse und Sonderfahrzeuge wählen Sie bitte die entsprechenden Registerkarten."]
["4. Speichern sie die ausgefüllten Arbeitsblätter (außer 'Vorlage für AZA') als PDF und fügen Sie sie dem Antrag bei."]
["5. Grün unterlegte Felder sind Eingabefelder."]
["Die Registerkarte 'Vorlage für AZA' stellt Ihre Eingaben so dar, wie sie in das easyOnline-Formular eingetragen werden müssen."]
[]
["Pos.","Typ E-Fahrzeug\n[Auswahlbox]","Fahrzeugsegment nach Kraftfahrt-Bundesamt",{"$f":"IF(Fahrzeuge!$C$1=\"nein\",\"Bruttopreis\nE-Fahrzeug\",IF(Fahrzeuge!$C$1=\"ja\",\"Nettopreis\nE-Fahrzeug\",\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\"))","v":"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!"},"Typ Referenzfahrzeug",{"$f":"IF(Fahrzeuge!$C$1=\"nein\",\"Bruttopreis\nReferenzfahrzeug\",IF(Fahrzeuge!$C$1=\"ja\",\"Nettopreis\nReferenzfahrzeug\",\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\"))","v":"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!"},{"$f":"IF($C$1=\"nein\",\"Förderfähige Ausgaben pro Fahrzeug (brutto)\",IF($C$1=\"ja\",\"Förderfähige Ausgaben pro Fahrzeug (netto)\",\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\"))","v":"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!"},"Anzahl zu beschaffender Fahrzeuge des Typs","Förderfähige Ausgaben ","Korrekturfeld PtJ"]
[1,null,{"$f":"IF(B13>0,CONCATENATE(VLOOKUP(B13,L$38:U$296,9,0),\" (\",VLOOKUP(B13,L$38:U$296,10,0),\")\"),\"\")","v":""},{"$f":"IF($B13>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B13,$L$37:$S$296,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B13,$L$37:$S$296,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},{"$f":"IF($B13>0,VLOOKUP($B13,$L$37:$S$296,4,0),\"\")","v":""},{"$f":"IF($B13>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B13,$L$37:$S$296,6,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B13,$L$37:$S$296,5,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},{"$f":"IF(B13>0,IF($C$1=\"nein\",VLOOKUP($B13,$L$37:$S$296,8,0),IF($C$1=\"ja\",VLOOKUP($B13,$L$37:$S$296,7,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},null,{"$f":"IF(B13>0,G13*H13,\"\")","v":""}]
[{"$f":"A13+1","v":2},null,"",{"$f":"IF($B14>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B14,$L$37:$S$296,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B14,$L$37:$S$296,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B14>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B14,$L$37:$S$296,6,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B14,$L$37:$S$296,5,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,""]
[{"$f":"A14+1","v":3},null,"",{"$f":"IF($B15>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B15,$L$37:$S$296,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B15,$L$37:$S$296,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B15>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B15,$L$37:$S$296,6,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B15,$L$37:$S$296,5,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,""]
[{"$f":"A15+1","v":4},null,"",{"$f":"IF($B16>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B16,$L$37:$S$296,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B16,$L$37:$S$296,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B16>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B16,$L$37:$S$296,6,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B16,$L$37:$S$296,5,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,""]
[{"$f":"A16+1","v":5},null,"",{"$f":"IF($B17>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B17,$L$37:$S$296,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B17,$L$37:$S$296,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B17>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B17,$L$37:$S$296,6,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B17,$L$37:$S$296,5,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,""]
[{"$f":"A17+1","v":6},null,"",{"$f":"IF($B18>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B18,$L$37:$S$296,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B18,$L$37:$S$296,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B18>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B18,$L$37:$S$296,6,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B18,$L$37:$S$296,5,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,""]
[7,null,"",{"$f":"IF($B19>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B19,$L$37:$S$296,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B19,$L$37:$S$296,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B19>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B19,$L$37:$S$296,6,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B19,$L$37:$S$296,5,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,""]
[8,null,"",{"$f":"IF($B20>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B20,$L$37:$S$296,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B20,$L$37:$S$296,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B20>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B20,$L$37:$S$296,6,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B20,$L$37:$S$296,5,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,""]
[9,null,"",{"$f":"IF($B21>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B21,$L$37:$S$296,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B21,$L$37:$S$296,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B21>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B21,$L$37:$S$296,6,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B21,$L$37:$S$296,5,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,""]
[10,null,"",{"$f":"IF($B22>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B22,$L$37:$S$296,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B22,$L$37:$S$296,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B22>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B22,$L$37:$S$296,6,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B22,$L$37:$S$296,5,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,""]
[11,null,"",{"$f":"IF($B23>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B23,$L$37:$S$296,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B23,$L$37:$S$296,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B23>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B23,$L$37:$S$296,6,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B23,$L$37:$S$296,5,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,""]
[12,null,"",{"$f":"IF($B24>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B24,$L$37:$S$296,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B24,$L$37:$S$296,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B24>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B24,$L$37:$S$296,6,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B24,$L$37:$S$296,5,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,""]
[13,null,"",{"$f":"IF($B25>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B25,$L$37:$S$296,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B25,$L$37:$S$296,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B25>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B25,$L$37:$S$296,6,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B25,$L$37:$S$296,5,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,""]
[14,null,"",{"$f":"IF($B26>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B26,$L$37:$S$296,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B26,$L$37:$S$296,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B26>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B26,$L$37:$S$296,6,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B26,$L$37:$S$296,5,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,""]
[15,null,"",{"$f":"IF($B27>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B27,$L$37:$S$296,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B27,$L$37:$S$296,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B27>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B27,$L$37:$S$296,6,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B27,$L$37:$S$296,5,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,""]
[16,null,"",{"$f":"IF($B28>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B28,$L$37:$S$296,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B28,$L$37:$S$296,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B28>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B28,$L$37:$S$296,6,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B28,$L$37:$S$296,5,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,""]
[{"$f":"A28+1","v":17},null,"",{"$f":"IF($B29>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B29,$L$37:$S$296,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B29,$L$37:$S$296,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B29>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B29,$L$37:$S$296,6,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B29,$L$37:$S$296,5,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,""]
[{"$f":"A29+1","v":18},null,"",{"$f":"IF($B30>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B30,$L$37:$S$296,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B30,$L$37:$S$296,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B30>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B30,$L$37:$S$296,6,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B30,$L$37:$S$296,5,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,""]
[{"$f":"A30+1","v":19},null,"",{"$f":"IF($B31>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B31,$L$37:$S$296,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B31,$L$37:$S$296,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B31>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B31,$L$37:$S$296,6,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B31,$L$37:$S$296,5,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,""]
[{"$f":"A31+1","v":20},null,"",{"$f":"IF($B32>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B32,$L$37:$S$296,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B32,$L$37:$S$296,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B32>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B32,$L$37:$S$296,6,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B32,$L$37:$S$296,5,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,""]
["Summe",{"$nulls":7},{"$f":"SUM(I13:I32)","v":0}]
[]
["*","Bei Beantragung von Fahrzeugsegmenten erfolgt die Abrechnung nach den Pauschalwerten des tatsächlich beschafften Fahrzeugs!"]
[{"$nulls":11},"E-Fahrzeug","Listenpreis",null,"Vergleichsfahrzeug","Listenpreis",null,"förderfähige Mehrausgaben",null,"Info Segment","Fahzeug-klasse \nAbk.","Kommentare","ergänzt am"]
[{"$nulls":12},"netto","brutto",null,"netto","brutto","netto","brutto"]
[{"$nulls":11},"AIWAYS U5 (alle Versionen)",{"$f":"ROUND(N38/1.19,2)","v":32271.43},38403,"VW Tiguan Life 1.5 TSI OPF  Gang 110 kW",{"$f":"ROUND(29901.68/1.16,2)","v":25777.31},{"$f":"ROUND(P38*1.19,2)","v":30675},{"$f":"ROUND(M38-P38,0)","v":6494},{"$f":"ROUND(N38-Q38,0)","v":7728},"Geländewagen / SUV","PKW",null,"2021-06-22"]
[{"$nulls":11},"Aixam eCity",12092.44,14390,"Mercedes Benz smart 52 kW",{"$f":"ROUND(Q39/1.19,2)","v":9382.35},11165,{"$f":"ROUND(M39-P39,0)","v":2710},{"$f":"ROUND(N39-Q39,0)","v":3225},"Leichtfahrzeug","LFZ",null,"2020-03-24"]
[{"$nulls":11},"ARI 458 (alle Versionen)",11700,13923,"Piaggio Porter Entry Level Pick-Up",{"$f":"ROUND(Q40/1.19,2)","v":11214.29},13345,{"$f":"ROUND(M40-P40,0)","v":486},578,"Leichtfahrzeug","LFZ"]
[{"$nulls":11},"ARI 901  (alle Versionen)",29800,35462,"Nissan NV200 Kasten",15350,18266.5,14450,17196,"Utility (N1)","NFZ"]
[{"$nulls":11},"Audi A3 e-tron",31848.74,37900,"Audi A3 Sportback Attraction",23949.58,28500,7899,9400,"Kompaktklasse","PKW"]
[{"$nulls":11},"Audi A3 Sportback 40 TFSIe (alle Varianten)",32302.52,38440,"A3 Sportback 35 TFSI 6-Gang 110 kW",24285.71,{"$f":"ROUNDUP(P43*1.19,2)","v":28900},8017,9540,"Kompaktklasse","PKW",null,"2020-12-17"]
[{"$nulls":11},"Audi e-tron 50 quattro",58067.23,69100,"Audi A6 allroad quattro 3.0 TDI 200kW",51302.52,61050,6765,8050,"SUV","PKW",null,"2020-03-24"]
[{"$nulls":11},"Audi e-tron 55 Quattro",67142.86,79900,"Audi A6 allroad quattro 3.0 TDI 200kW",51302.52,61050,15840,18850,"SUV","PKW"]
[{"$nulls":11},"Audi Q4 e-tron 55 kWh (alle Varianten)",35210.080000000002,41900,"Audi Q3 35 TFSI 6-Gang 110 kW",30294.12,{"$f":"ROUND(P46*1.19,2)","v":36050},{"$f":"ROUND(M46-P46,0)","v":4916},{"$f":"ROUND(N46-Q46,0)","v":5850},"Geländewagen / SUV","PKW",null,"2021-09-07"]
[{"$nulls":11},"Audi Q4 e-tron 82 kWh (alle Varianten)",39915.97,47500,"Audi Q3 35 TFSI 6-Gang 110 kW",30294.12,{"$f":"ROUND(P47*1.19,2)","v":36050},{"$f":"ROUND(M47-P47,0)","v":9622},{"$f":"ROUND(N47-Q47,0)","v":11450},"Geländewagen / SUV","PKW",null,"2021-09-07"]
[{"$nulls":11},"Audi Q5 TFSI e quattro",50798.32,60450,"Audi Q5 sport 45 TFSI quattro",45378.15,54000,5420,6450,"Geländewagen / SUV","PKW"]
[{"$nulls":11},"Audi Q7 e-tron quattro",70084.03,83400,"Audi Q7 3.0 TDI 200 KW",54117.65,64400,{"$f":"ROUND(M49-P49,0)","v":15966},{"$f":"ROUND(N49-Q49,0)","v":19000},"Geländewagen / SUV","PKW"]
[{"$nulls":11},"BMW 225xe iPerformance Active Tourer",33319.33,39650,"BMW 220i Active Tourer",29411.759999999998,35000,{"$f":"ROUND(M50-P50,0)","v":3908},{"$f":"ROUND(N50-Q50,0)","v":4650},"Kompaktklasse","PKW"]
[{"$nulls":11},"BMW 330e Advantage (10,8 kWh)",43319.33,51550,"BMW 330i Advantage (G20)",37605.040000000001,44750,5714,6800,"Mittelklasse","PKW","Ab BJ 07/2020 Bezeichnung 330e xDrive (nutzbare Batterie-Gr. Nun 11,15kWh aber gleiche Batterie)"]
[{"$nulls":11},"BMW 330e iPerformance ( 7,4 kWh)",38361.339999999997,45649.99,"BMW 320i Advantage (F30)",32563.03,38750,{"$f":"ROUND(M52-P52,0)","v":5798},6900,"Mittelklasse","PKW","Ergänzung der Batteriegröße 10.9.20"]
[{"$nulls":11},"BMW 530e iPerformance",47058.82,56000,"BMW 530i",44621.85,53100,2437,2900,"Obere Mittelklasse","PKW"]
[{"$nulls":11},"BMW 740e, Le (Räderkategorie 1,2; ohne xDrive)",82268.91,97900,"BMW 740i",79159.66,94200,3109,3700,"Oberklasse","PKW"]
[{"$nulls":11},"BMW 740e, Le (Räderkategorie 3; xDrive)","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL",null,0,0,0,0,"Oberklasse","PKW"]
[{"$nulls":11},"BMW 745e, Le (ohne xDrive)",89411.76,106400,"BMW 730 Ld",78907.56,93900,10504,12500,"Oberklasse","PKW"]
[{"$nulls":11},"BMW i3 (33,2 kWh, 27,2 kWh nutzbar)",31554.62,37550,"BMW 218 i Active Tourer",24705.88,29400,{"$f":"ROUND(M57-P57,0)","v":6849},8150,"Kleinwagen","PKW"]
[{"$nulls":11},"BMW i3 (42,2 kWh, 37,9 kWh nutzbar)",31932.77,38000,"BMW 218 i Active Tourer",24705.88,29400,7227,8600,"Kleinwagen","PKW"]
[{"$nulls":11},"BMW i3 Range Extender (33,2 kWh, 27,2 kWh nutzbar)",31554.62,37550,"BMW 218 i Active Tourer",24705.88,29400,6849,8150,"Kleinwagen","PKW"]
[{"$nulls":11},"BMW i3s (33,2 kWh, 27,2 kWh nutzbar)",34579.83,41150,"BMW 218 i Active Tourer Sport Line",28781.51,34250,5798,6900,"Kleinwagen","PKW"]
[{"$nulls":11},"BMW i3s (42,2 kWh, 37,9 kWh nutzbar)",34957.980000000003,41600,"BMW 218 i Active Tourer Sport Line",28781.51,34250,6176,7350,"Kleinwagen","PKW"]
[{"$nulls":11},"BMW i3s Range Extender (33,2 kWh, 27,2 kWh nutzbar)",34579.83,41150,"BMW 218 i Active Tourer Sport Line",28781.51,34250,5798,6900,"Kleinwagen","PKW"]
[{"$nulls":11},"BMW i8 Coupé",115966.39,138000,"Porsche 911 Carrera 4S",107545.38,127979,8421,10021,"Sportwagen","PKW"]
[{"$nulls":11},"BMW i8 Roadster",130252.1,155000,"Porsche 911 Carrera 4S Cabrio",127948.74,152259,2303,2741,"Sportwagen","PKW"]
[{"$nulls":11},"BMW iX3 (210 KW)",54159.66,64450,"BMW X3 xDrive30i",{"$f":"ROUND(53028.56/1.16,2)","v":45714.28},{"$f":"ROUNDUP(P65*1.19,2)","v":54400},{"$f":"ROUND(M65-P65,0)","v":8445},10050,"Geländewagen / SUV","PKW",null,"2020-12-17"]
[{"$nulls":11},"BMW X1 xDrive25e (alle Modelle)",38361.339999999997,45650,"BMW X1 xDrive 20i",35210.080000000002,41900,{"$f":"ROUND(M66-P66,0)","v":3151},{"$f":"ROUND(N66-Q66,0)","v":3750},"SUV","PKW",null,"2020-04-24"]
[{"$nulls":11},"BMW X3 xDrive30e (alle Modelle)",48235.29,57400,"BMW X3 xDrive 30i",45714.29,54400,{"$f":"ROUND(M67-P67,0)","v":2521},{"$f":"ROUND(N67-Q67,0)","v":3000},"Geländewagen / SUV","PKW",null,"2020-04-24"]
[{"$nulls":11},"BMW X5 xDrive40e iPerformance","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL",null,0,0,0,0,"Geländewagen / SUV","PKW"]
[{"$nulls":11},"CITROËN Berlingo Electric L1",20990,24978.1,"Citroën Berlingo L1",14500,17255,{"$f":"ROUND(M69-P69,0)","v":6490},7723,"Utility (N1)","NFZ"]
[{"$nulls":11},"CITROËN Berlingo Electric L1, Batterie zur Miete",15690,18671.099999999999,"Citroën Berlingo L1",14500,17255,1190,1416,"Utility (N1)","NFZ"]
[{"$nulls":11},"CITROËN Berlingo Electric L2",22040,26227.599999999999,"Citroën Berlingo L2",15350,18266.5,6690,7961,"Utility (N1)","NFZ"]
[{"$nulls":11},"CITROËN Berlingo Electric L2, Batterie zur Miete",16740,19920.599999999999,"Citroën Berlingo L2",15350,18266.5,1390,1654,"Utility (N1)","NFZ"]
[{"$nulls":11},"CITROËN ë-Berlingo (alle Versionen)",30747.9,36590,"Citroën Berlingo Feel 81 kW",{"$f":"ROUND(23740/1.19,2)","v":19949.580000000002},{"$f":"P73*1.19","v":23740.000200000002},10798,12850,"Großraum-Van","PKW",null,"2021-06-23"]
[{"$nulls":11},"CITROËN C-Zero",18319.330000000002,21800,"Citroën C1 Cti 68 (5 Türer)",8907.56,10600,9412,11200,"Mini","PKW"]
[{"$nulls":11},"CITROËN DS 7 CROSSBACK E-TENSE 4x4 be chic",42260.5,50290,"Citroën DS 7 CROSSBACK PureTech 225 Automatik 225",35159.660000000003,41840,7101,8450,"Geländewagen / SUV","PKW"]
[{"$nulls":11},"CITROËN E-JUMPY M 50kWh ",35250,41947.5,"CITROËN E-JUMPY M Blue HDi 120 90 kW (Control)",26500,{"$f":"ROUND(P76*1.19,2)","v":31535},{"$f":"ROUND(M76-P76,0)","v":8750},{"$f":"ROUND(N76-Q76,0)","v":10413},"Utility (N1)","NFZ",null,"2020-09-10"]
[{"$nulls":11},"CITROËN E-JUMPY M 75kWh",40250,47897.5,"CITROËN E-JUMPY M Blue HDi 120 90 kW (Control)",26500,{"$f":"ROUND(P77*1.19,2)","v":31535},13750,16363,"Utility (N1)","NFZ",null,"2020-09-10"]
[{"$nulls":11},"CITROËN ë-SpaceTourer 50kWh (alle Varianten)",43226.89,51439.999099999994,"CITROËN SpaceTourer M BlueHDi 145 (Business)",{"$f":"ROUND(39340/1.19,2)","v":33058.82},{"$f":"P78*1.19","v":39339.995799999997},10168,12100,"Großraum-Van","PKW",null,"2021-01-10"]
[{"$nulls":11},"CITROËN ë-SpaceTourer 75kWh (alle Varianten)",48268.91,57440.002899999999,"CITROËN SpaceTourer M BlueHDi 145 (Business)",{"$f":"ROUND(39340/1.19,2)","v":33058.82},39339.995799999997,15210,18100,"Großraum-Van","PKW",null,"2021-01-10"]
[{"$nulls":11},"CITROËN E-Mehari",21235.29,25270,"Fiat 500c",{"$f":"ROUND(Q80/1.19,2)","v":12764.71},15190,8471,10080,"Kleinwagen","PKW"]
[{"$nulls":11},"CITROËN e-C4 Feel",29109.24,34640,"CITROËN C4 PureTech 130 6-Gang",{"$f":"23940/1.19","v":20117.647058823532},{"$f":"ROUNDUP(P81*1.19,2)","v":23940},{"$f":"ROUND(M81-P81,0)","v":8992},{"$f":"ROUND(N81-Q81,0)","v":10700},"Kompaktklasse","PKW",null,"2020-12-17"]
[{"$nulls":11},"CITROËN DS3 Crossback E-Tense",32260.5,38390,"DS3 Crossback PureTech 130 So Chic (N)",{"$f":"ROUND(Q82/1.19,2)","v":24781.51},29490,7479,8900,"Kleinwagen","PKW",null,"2020-03-24"]
[{"$nulls":11},"e.GO-Life 20",13361.34,15899.99,"Hyundai i10",{"$f":"ROUND(Q83/1.19,2)","v":8394.9599999999991},9990,4966,5910,"Mini","PKW"]
[{"$nulls":11},"e.GO-Life 40",14621.85,17400,"Hyundai i10",{"$f":"ROUND(Q84/1.19,2)","v":8394.9599999999991},9990,6227,7410,"Mini","PKW"]
[{"$nulls":11},"e.GO-Life 60",16722.689999999999,19900,"Hyundai i10",{"$f":"ROUND(Q85/1.19,2)","v":8394.9599999999991},9990,8328,9910,"Mini","PKW"]
[{"$nulls":11},"EVUM aCar (alle Varianten)",28990,34498.1,"Piaggio Porter Maxxi Chassis",16302.52,{"$f":"ROUND(P86*1.19,2)","v":19400},12687,15098,"Utility (N1)","NFZ",null,"2020-09-10"]
[{"$nulls":11},"Fiat 500 Action 23,8 kWh",19798.32,23560,"Fiat 500 LOUNGE",{"$f":"15684.37/1.16","v":13521.008620689658},{"$f":"ROUND(P87*1.19,2)","v":16090},6277,7470,"Kleinwagen","PKW",null,"2020-12-17"]
[{"$nulls":11},"Fiat 500 Passion 42,0 kWh",23159.66,27560,"Fiat 500 LOUNGE",{"$f":"15684.37/1.16","v":13521.008620689658},{"$f":"ROUND(P88*1.19,2)","v":16090},9639,11470,"Kleinwagen","PKW",null,"2020-12-17"]
[{"$nulls":11},"Fiat E-Ducato 47 kWh (alle Versionen)",56000,66640,"Fiat Ducato 88 KW",30840,{"$f":"ROUND(P89*1.19,2)","v":36699.599999999999},25160,29940,"Utility (N1)","NFZ",null,"2020-09-10"]
[{"$nulls":11},"Fiat E-Ducato 79 kWh (alle Versionen)",73000,86870,"Fiat Ducato 88 KW",30840,{"$f":"ROUND(P90*1.19,2)","v":36699.599999999999},42160,50170,"Utility (N1)","NFZ",null,"2020-09-10"]
[{"$nulls":11},"Ford Kuga  2,5 L Duratec PHEV Titanium",33025.21,39300,"Ford Kuga  1,5 L EcoBoost Titanium",{"$f":"ROUND(Q91/1.19,2)","v":26806.720000000001},31900,6218,7400,"Geländewagen / SUV","PKW"]
[{"$nulls":11},"Ford Tourneo Custom Bus (PHEV)",60420,71899.8,"Ford Tourneo Custom Bus Titanium (130 PS, Automatik)",{"$f":"ROUND(Q92/1.19,2)","v":42170},50182.3,18250,21718,"Großraum-Van","PKW","Segment korrigiert ","2020-09-10"]
[{"$nulls":11},"Ford e-Transit (alle N1/N2 -Versionen)",57920,68924.800000000003,"Ford Transit (gleiche Nutzlast + Radstand)",37720,{"$f":"ROUND(P93*1.19,2)","v":44886.8},20200,24038,"Utility","NFZ","Mittelwert aus allen verfügbaren Modellen mit vorhandenem VGL-Fzg. Bei 4,25t-Variante fehlt vergleichbarer Verbrenner","2022-03-01"]
[{"$nulls":11},"Ford Transit Custom Kastenwagen LKW  (PHEV)","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL","Ford Transit Custom Kastenwagen LKW ",{"$nulls":4},"Utility (N1)","NFZ"]
[{"$nulls":11},"Ford Transit Custom Kombi PKW (PHEV)",52805,62837.95,"Ford Transit Custom Kombi PKW (130 PS, Automatik)",{"$f":"ROUND(Q95/1.19,2)","v":35505},42250.95,{"$f":"ROUND(M95-P95,0)","v":17300},{"$f":"ROUND(N95-Q95,0)","v":20587},"Großraum-Van","PKW",null,"Segment korrigiert 10.9.20"]
[{"$nulls":11},"Ford Mustang Mach-E Standard Range 75,7 kWh (alle Varianten)",39411.760000000002,46900,"Ford Mondeo 2,0l EcoBlue Limousine  110 kW",{"$f":"36554.62/1.16","v":31512.603448275866},{"$f":"ROUND(P96*1.19,2)","v":37500},7899,9400,"Geländewagen / SUV","PKW",null,"2020-12-17"]
[{"$nulls":11},"Ford Mustang Mach-E Extended Range 98,7 kWh (alle Varianten)",45777.31,54475,"Ford Mondeo 2,0l EcoBlue Limousine  110 kW",{"$f":"36554.62/1.16","v":31512.603448275866},{"$f":"ROUND(P97*1.19,2)","v":37500},14265,16975,"Geländewagen / SUV","PKW",null,"2020-12-17"]
[{"$nulls":11},"Honda e",28445.38,33850,"Honda Jazz Trend",14529.41,17290,13916,16560,"Kleinwagen","PKW",null,"2020-03-24"]
[{"$nulls":11},"Hyundai IONIQ Elektro 28 kWh",27983.19,33300,"Hyundai i30 5T 1.4 T­GDI, 6­Gang, 103 kW",21378.15,25440,6605,7860,"Kompaktklasse","PKW"]
[{"$nulls":11},"Hyundai IONIQ Elektro 38,3 kWh",29705.88,35350,"Hyundai i30 5T 1.5 T­GDI, 6­Gang, 117 kW",{"$f":"ROUND(25139.83/1.16,2)","v":21672.27},{"$f":"ROUND(P100*1.19,2)","v":25790},8034,9560,"Kompaktklasse","PKW",null,"2021-01-14"]
[{"$nulls":11},"Hyundai IONIQ Plug-in-Hybrid",25126.05,29900,"Hyundai i30 5T 1.4 T­GDI, 6­Gang, 103 kW",18907.560000000001,22500,6218,7400,"Kompaktklasse","PKW"]
[{"$nulls":11},"Hyundai IONIQ 5 Elektro 58 kWh",{"$f":"ROUND(N102/1.19,2)","v":35210.080000000002},41900,"Hyundai Tucson 48 V 1.6 T-GDI, 110 kW",{"$f":"ROUND(30500/1.19,2)","v":25630.25},{"$f":"ROUND(P102*1.19,2)","v":30500},9580,11400,"Geländewagen / SUV","PKW",null,"2021-06-18"]
[{"$nulls":11},"Hyundai IONIQ 5 Elektro 72,6 kWh",37899.160000000003,45100,"Hyundai Tucson 48 V 1.6 T-GDI, 110 kW",{"$f":"ROUND(30500/1.19,2)","v":25630.25},{"$f":"ROUND(P103*1.19,2)","v":30500},12269,14600,"Geländewagen / SUV","PKW",null,"2021-06-18"]
[{"$nulls":11},"Hyundai Kona Elektro 39,2 kWh",29075.63,34600,"Hyundai Kona",17310.919999999998,20600,11765,14000,"SUV","PKW"]
[{"$nulls":11},"Hyundai Kona Elektro 64,0 kWh",35168.07,41850,"Hyundai Kona 1.6 GDI, Select",{"$f":"ROUND(26900/1.19,2)","v":22605.040000000001},{"$f":"ROUND(P105*1.19,2)","v":26900},12563,14950,"Geländewagen / SUV","PKW",null,"2021-01-21"]
[{"$nulls":11},"ISEKI Goupil G4 (13,8 kWh)",33663.03,40059,"Piaggio Porter Chassis",13193.28,15700,20470,24359,"Utility (N1)","NFZ",null,"2020-03-24"]
[{"$nulls":11},"ISEKI Goupil G4 (9 kWh)",29881.51,35559,"Piaggio Porter Chassis",13193.28,15700,16688,19859,"Utility (N1)","NFZ",null,"2020-03-24"]
[{"$nulls":11},"ISEKI Goupil G5 (11,5 kWh)",34967.230000000003,41611,"Piaggio Porter Chassis",13193.28,15700,21774,25911,"Utility (N1)","NFZ",null,"2020-03-24"]
[{"$nulls":11},"ISEKI Goupil G5 (19,2 kWh)",44294.96,52711,"Piaggio Porter Chassis",13193.28,15700,31102,37011,"Utility (N1)","NFZ",null,"2020-03-24"]
[{"$nulls":11},"Jaguar I-Pace",65420.17,77850,"Jaguar F-Pace 30t AWD",47689.08,56750,17731,21100,"SUV","PKW"]
[{"$nulls":11},"Jaguar E-Pace R-Dynamic S P300e",49025.21,58340,"Jaguar E-Pace R-Dynamic S D165 AWD",43134.46,{"$f":"ROUNDDOWN(P111*1.19,2)","v":51330},5891,7010,"Geländewagen / SUV","PKW",null,"2020-12-18"]
[{"$nulls":11},"Jaguar F-Pace P400e",59474.14,70774.23,"Jaguar F-Pace D300 AWD",55232.76,{"$f":"ROUND(P112*1.19,2)","v":65726.98},4241,5047,"Geländewagen / SUV","PKW",null,"2020-12-18"]
[{"$nulls":11},"Jeep Renegade 4xe 1.3I T-GDI I4 PHEV (alle Varianten)",35798.32,42600,"Jeep Renegade 1.3I T-GDI I4",26638.66,{"$f":"ROUNDDOWN(P113*1.19,2)","v":31700},{"$f":"ROUND(M113-P113,0)","v":9160},{"$f":"ROUND(N113-Q113,0)","v":10900},"Geländewagen / SUV","PKW",null,"2020-12-18"]
[{"$nulls":11},"Jeep Compass 4xe 1.3I T-GDI I4 PHEV (alle Varianten)",39159.660000000003,46600,"Jeep Compass 1.3I T-GDI I4",31428.57,{"$f":"ROUND(P114*1.19,2)","v":37400},{"$f":"ROUND(M114-P114,0)","v":7731},{"$f":"ROUND(N114-Q114,0)","v":9200},"Geländewagen / SUV","PKW",null,"2020-12-18"]
[{"$nulls":11},"Kia Ceed SW PHEV (alle Versionen)",29410.92,34999,"Kia Ceed SW 1.4 T-GDI ",21000,24990,8411,10009,"Kompaktklasse","PKW",null,"2020-07-28"]
[{"$nulls":11},"Kia e-Niro 39,2 kWh",28815.13,34290,"Kia Ceed SW 1.4 T-GDI ",19403.36,23090,9412,11200,"Kompaktklasse","PKW"]
[{"$nulls":11},"Kia e-Niro 64 kWh",32008.400000000001,38090,"Kia Ceed SW 1.4 T-GDI ",19403.36,23090,12605,15000,"Kompaktklasse","PKW"]
[{"$nulls":11},"Kia Niro Plug-in Hybrid",27521.01,32750,"Kia Ceed SW 1.6 GDI Dream-Team-Edition",18478.990000000002,21990,9042,10760,"Kompaktklasse","PKW"]
[{"$nulls":11},"Kia Optima 2.0 GDI Plug-in Hybrid (Sportswagon)",34025.21,40490,"Kia Optima 2.0 CVVL",23352.94,27790,10672,12700,"Mittelklasse","PKW"]
[{"$nulls":11},"Kia Soul EV (27 bzw. 30 kWh)",24781.51,29490,"Kia Soul",14487.39,17240,10294,12250,"Mini-Van","PKW"]
[{"$nulls":11},"Kia e-Soul 39,2 kWh",28563.03,33990,"Kia Niro 1.6 GDI Hybrid",{"$f":"ROUND(26990/1.19,2)","v":22680.67},{"$f":"ROUND(P121*1.19,2)","v":26990},5882,7000,"Mini-Van","PKW",null,"2021-01-21"]
[{"$nulls":11},"Kia e-Soul 64,0 kWh",31756.3,37790,"Kia Niro 1.6 GDI Hybrid",22680.67,26990,9076,10800,"Mini-Van","PKW",null,"2021-01-21"]
[{"$nulls":11},"Kia XCeed PHEV (alle Versionen)",30251.26,35999,"Kia XCeed Vision",20075.63,23890,10176,12109,"Kompaktklasse","PKW",null,"2020-05-28"]
[{"$nulls":11},"Kia Niro EV 64,8 kWh",39991.599999999999,47590,"Kia Niro 1.6 GDI Hybrid Vision",28563.03,33990,{"$f":"ROUND(M124-P124,0)","v":11429},{"$f":"ROUND(N124-Q124,0)","v":13600},"Geländewagen / SUV","PKW",null,"2022-09-20"]
[{"$nulls":11},"Kia EV6 (alle Versionen)",37806.720000000001,44990,"Kia Sportage Edition 7 1,6 T GDI",23352.94,27790,14454,17200,"Geländewagen / SUV","PKW",null,"2022-09-20"]
[{"$nulls":11},"Land Rover Range Rover P400e Plug-in Hybrid",99747.9,118700,"Land Rover Range Rover 3.0 TDV6",91008.4,108300,8740,10400,"Geländewagen / SUV","PKW"]
[{"$nulls":11},"Land Rover Range Rover Sport P400e Plug-in Hybrid",73193.279999999999,87100,"Land Rover Range Rover Sport 3.0 TDV6",60924.37,72500,12269,14600,"Geländewagen / SUV","PKW"]
[{"$nulls":11},"LEVC TX5 (alle Versionen)",61422.5,73092.78,"Opel Vivaro Combi S 88 kW",30610,{"$f":"ROUND(P128*1.19,2)","v":36425.9},30813,36667,"Großraum-Van","PKW",null,"2021-02-02"]
[{"$nulls":11},"LEVC VN5 (alle Versionen)",52450,62415.5,"Opel Vivaro Cargo S 88kW",27470,{"$f":"ROUND(P129*1.19,2)","v":32689.3},{"$f":"ROUND(M129-P129,0)","v":24980},{"$f":"ROUND(N129-Q129,0)","v":29726},"Utility (N1)","NFZ",null,"2021-02-02"]
[{"$nulls":11},"Mazda MX-30 e-SKYACTIV",28142.86,33490,"CX-30 SKYACTIV-G 2.0 M Hybrid",20832.759999999998,{"$f":"ROUND(P130*1.19,2)","v":24790.98},{"$f":"ROUND(M130-P130,0)","v":7310},{"$f":"ROUND(N130-Q130,0)","v":8699},"Geländewagen / SUV","PKW",null,"2020-12-17"]
[{"$nulls":11},"MAN e-TGE",null,null,"wie VW e-Crafter ",null,null,{"$f":"R256","v":40620},{"$f":"S256","v":48338},{"$f":"T256","v":"Utility (N1)"},"NFZ",null,"2021-02-23"]
[{"$nulls":11},"Mercedes Benz A 250 e ",31045,36943.550000000003,"Mercedes Benz A 200 ",{"$f":"ROUND(Q132/1.19,2)","v":25845},30755.55,5200,6188,"Kompaktklasse","PKW"]
[{"$nulls":11},"Mercedes Benz A 250 e (Limousine)",31345,37300.550000000003,"Mercedes Benz A 200 (Limousine)",26145,31112.55,5200,6188,"Kompaktklasse","PKW"]
[{"$nulls":11},"Mercedes Benz C 300 (T) e (W205/S205)",39265,46725.35,"Mercedes Benz C 300",37360,44458.400000000001,{"$f":"ROUND(M134-P134,0)","v":1905},2267,"Mittelklasse","PKW",null,"2021-06-22"]
[{"$nulls":11},"Mercedes Benz C 300 (T) de (W205/S205)",41265,49105.35,"Mercedes Benz C 300 d",39065,46487.35,2200,2618,"Mittelklasse","PKW",null,"2021-06-22"]
[{"$nulls":11},"Mercedes Benz E 300 (T) e",46300,55097,"Mercedes Benz E 300",{"$f":"ROUND(Q136/1.19,2)","v":44600},53074,1700,2023,"Obere Mittelklasse","PKW"]
[{"$nulls":11},"Mercedes Benz E 300 (T) de",49100,58429,"Mercedes Benz E 300 d (T-Modell)",46735,55614.65,2365,2814,"Obere Mittelklasse","PKW"]
[{"$nulls":11},"Mercedes Benz E 350 e",49950,59440.5,"Mercedes Benz E 300 d",43340,51574.6,{"$f":"ROUND(M138-P138,0)","v":6610},{"$f":"ROUND(N138-Q138,0)","v":7866},"Obere Mittelklasse","PKW"]
[{"$nulls":11},"Mercedes Benz EQA 250",39950,47540.5,"Mercedes Benz GLA 180",30920,{"$f":"ROUND(P139*1.19,2)","v":36794.800000000003},{"$f":"ROUND(M139-P139,0)","v":9030},{"$f":"ROUND(N139-Q139,0)","v":10746},"Geländewagen / SUV","PKW",null,"2021-06-15"]
[{"$nulls":11},"Mercedes Benz EQC 400 4MATIC",59900,71281,"Mercedes Benz GLC 300 4MATIC",45030,53585.7,14870,17695,"Geländewagen / SUV","PKW"]
[{"$nulls":11},"Mercedes Benz EQV 300 (alle Varianten)",60889,72457.91,"Mercedes Benz V220D Lang",44280,{"$f":"ROUND(P141*1.19,2)","v":52693.2},{"$f":"ROUND(M141-P141,0)","v":16609},{"$f":"ROUND(N141-Q141,0)","v":19765},"Großraum-Van","PKW",null,"2020-09-10"]
[{"$nulls":11},"Mercedes Benz eSprinter 35 kWh (alle Varianten)",53900,64141,"Mercedes Benz Sprinter Kasten 211 CDI",32485,{"$f":"ROUND(P142*1.19,2)","v":38657.15},{"$f":"ROUND(M142-P142,0)","v":21415},25484,"Utility (N1)","NFZ",null,"2020-09-10"]
[{"$nulls":11},"Mercedes Benz eSprinter 47 kWh (alle Varianten)",61273,72914.87,"Mercedes Benz Sprinter Kasten 211 CDI",32485,{"$f":"ROUND(P143*1.19,2)","v":38657.15},28788,34258,"Utility (N1)","NFZ",null,"2020-09-10"]
[{"$nulls":11},"Mercedes Benz eVito (alle Varianten)",39990,47588.1,"Mercedes Benz Vito Kastenwagen Worker",{"$f":"ROUND(Q144/1.19,2)","v":18490},22003.1,21500,25585,"Utility (N1)","NFZ"]
[{"$nulls":11},"Mercedes Benz eVito Tourer (alle Varianten)",55232,65726.080000000002,"MB Vito Tourer, Base, Lang",30040,{"$f":"ROUND(P145*1.19,2)","v":35747.599999999999},{"$f":"ROUND(M145-P145,0)","v":25192},{"$f":"ROUND(N145-Q145,0)","v":29978},"Großraum-Van","PKW",null,"2020-09-10"]
[{"$nulls":11},"Mercedes Benz GLC 350e 4MATIC (Coupé)","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL",null,0,0,0,0,"Geländewagen / SUV","PKW"]
[{"$nulls":11},"Mercedes Benz GLE 500e 4MATIC","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL",null,0,0,0,0,"Geländewagen / SUV","PKW"]
[{"$nulls":11},"Mercedes Benz S 500e Langversion ","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL",null,0,0,0,0,"Oberklasse","PKW"]
[{"$nulls":11},"Mercedes Benz S 560e Langversion ","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL",null,0,0,0,0,"Oberklasse","PKW"]
[{"$nulls":11},"Mercedes Benz GLA250e",38810,46183.9,"GLA200d",32890,{"$f":"ROUND(P150*1.19,2)","v":39139.1},{"$f":"ROUND(M150-P150,0)","v":5920},7045,"Geländewagen / SUV","PKW",null,"2020-12-17"]
[{"$nulls":11},"Mercedes Benz GLC 300 (d)e 4MATIC (ab 2019, MOPF, alle Varianten)",49950,59440.5,"GLC 220 d 4MATIC ",42435,50497.65,7515,8943,"Geländewagen / SUV","PKW",null,"2020-12-17"]
[{"$nulls":11},"Mercedes Benz GLE 350 (d)e 4MATIC (V 167, C167, alle Varianten)",64980,77326.2,"GLE 300 d 4MATIC ",58930,70126.7,6050,7200,"Geländewagen / SUV","PKW",null,"2020-12-17"]
[{"$nulls":11},"Mercedes Benz smart forfour electric drive (alle Versionen)",18991.599999999999,22600,"Mercedes Benz smart forfour 52 kW",10861.34,12925,{"$f":"ROUND(M153-P153,0)","v":8130},9675,"Mini","PKW"]
[{"$nulls":11},"Mercedes Benz smart fortwo ED (alle Versionen)",18436.97,21939.99,"Mercedes Benz smart 52 kW",10306.719999999999,12265,8130,9675,"Kleinwagen","PKW"]
[{"$nulls":11},"MG ZS EV (alle Versionen)",26882.35,31990,"Peugeot 2008 PureTech 130 Active",{"$f":"ROUND(Q155/1.19,2)","v":19537.82},23250,7345,8740,"Kompaktklasse","PKW",null,"2021-06-22"]
[{"$nulls":11},"Mini Cooper SE 3-Türer Trim S",27310.92,32500,"Mini Cooper S 3-Türer",24327.73,28950,2983,3550,"Kleinwagen","PKW"]
[{"$nulls":11},"Mini Cooper SE Contryman ALL4 Automatik",31512.61,37500,"Mini Countrymen Cooper S",28067.23,33400,3445,4100,"Kleinwagen","PKW"]
[{"$nulls":11},"Mitsubishi PLUG-IN HYBRID OUTLANDER",33605.040000000001,39990,"Mitsubishi Outlander",21000,24990,12605,15000,"Kompaktklasse","PKW"]
[{"$nulls":11},"Nissan e-NV200 Evalia 5-Sitzer",34498.32,41053,"Nissan NV200 Evalia 5-Sitzer",19571.43,23290,14927,17763,"Großraum-Van","PKW"]
[{"$nulls":11},"Nissan e-NV200 Evalia 7-Sitzer",35168.32,41850.300000000003,"Nissan NV200 Evalia 7-Sitzer",20306.72,24165,14862,17685,"Großraum-Van","PKW"]
[{"$nulls":11},"Nissan e-NV200 Kasten",28660,34105.4,"Nissan NV200 Kasten",15150,18028.5,13510,16077,"Utility (N1)","NFZ"]
[{"$nulls":11},"Nissan Leaf ZE1 (40 kwh)",26848.74,31950,"Nissan Pulsar Visia",15537.82,18490,{"$f":"ROUND(M162-P162,0)","v":11311},{"$f":"ROUND(N162-Q162,0)","v":13460},"Kompaktklasse","PKW"]
[{"$nulls":11},"Nissan Leaf ZE1 e+ (62 kwh)",37563.03,44700,"Nissan Pulsar Visia",15537.82,18490,22025,26210,"Kompaktklasse","PKW"]
[{"$nulls":11},"Opel Ampera-E Plus",36126.050000000003,42990,"Opel Astra 1.4 Direct Injection Turbo (Start/Stop)",20731.09,24670,{"$f":"ROUND(M164-P164,0)","v":15395},{"$f":"ROUND(N164-Q164,0)","v":18320},"Kleinwagen","PKW"]
[{"$nulls":11},"Opel Corsa-e Edition",25756.3,30650,"Opel Corsa Edition (74 kW)",14731.09,17530,11025,13120,"Kleinwagen","PKW"]
[{"$nulls":11},"Opel Combo-e Life (alle Versionen)",32016.81,38100.003900000003,"Opel Combo Life Edition 81 kW",{"$f":"ROUND(25180/1.19,2)","v":21159.66},{"$f":"P166*1.19","v":25179.9954},{"$f":"ROUND(M166-P166,0)","v":10857},{"$f":"ROUND(N166-Q166,0)","v":12920},"Großraum-Van","PKW",null,"2021-06-23"]
[{"$nulls":11},"Opel Grandland X (133 kW, alle Versionen)",37533.61,44665,"Opel Grandland X 1,6 Direct Injection Turbo (133 kW)",30504.2,36300,{"$f":"ROUND(M167-P167,0)","v":7029},8365,"Geländewagen / SUV","PKW",null,"2020-04-17"]
[{"$nulls":11},"Opel Mokka-E",{"$f":"ROUND(N168/1.19,2)","v":27722.69},32990.001099999994,"Opel Mokka 1.2 74 kW",{"$f":"ROUND(19486.05/1.16,2)","v":16798.32},{"$f":"P168*1.19","v":19990.000799999998},10924,13000,"Kompaktklasse","PKW",null,"2020-12-18"]
[{"$nulls":11},"Opel Zafira-E Life 50 kWh (alle Versionen)",48193.279999999999,57350.003199999999,"Opel Zafira Life M 88 kW",{"$f":"ROUND(43602.35/1.16,2)","v":37588.230000000003},44729.993699999999,10605,12620,"Großraum-Van","PKW",null,"2020-12-18"]
[{"$nulls":11},"Opel Zafira-E Life 75 kWh (alle Versionen)",53235.29,63349.9951,"Opel Zafira Life M 88 kW",{"$f":"ROUND(43602.35/1.16,2)","v":37588.230000000003},44729.993699999999,15647,18620,"Großraum-Van","PKW",null,"2020-12-18"]
[{"$nulls":11},"Opel Vivaro-E Cargo 50 kWh (alle Versionen)",36240,43125.599999999999,"Opel Vivaro Cargo M 90 kW",28280,33653.199999999997,7960,9472,"Utility","NFZ",null,"2020-12-18"]
[{"$nulls":11},"Opel Vivaro-E Cargo 75 kWh (alle Versionen)",41240,49075.6,"Opel Vivaro Cargo M 90 kW",28280,33653.199999999997,12960,15422,"Utility","NFZ",null,"2020-12-18"]
[{"$nulls":11},"Opel Vivaro-E Kombi 50 kWh (alle Versionen)",42250,50277.5,"Opel Kombi 90 kW",34410,40947.9,{"$f":"ROUND(M173-P173,0)","v":7840},9330,"Großraum-Van","PKW",null,"2021-01-11"]
[{"$nulls":11},"Opel Vivaro-E Kombi 75 kWh (alle Versionen)",47250,56227.5,"Opel Kombi 90 kW",34410,40947.9,{"$f":"ROUND(M174-P174,0)","v":12840},15280,"Großraum-Van","PKW",null,"2021-01-11"]
[{"$nulls":11},"Peugeot 508 SW GT Hybrid 225 e-EAT8",43361.34,51600,"Peugeot 508 SW GT PureTech 225 EAT8",39915.97,47500,3445,4100,"Mittelklasse","PKW"]
[{"$nulls":11},"Peugeot 3008 Hybrid 225/300  (alle Versionen)",39579.83,47100,"Peugeot 3008 PureTech 180 EAT8",{"$f":"ROUND(39966.39/1.16,2)","v":34453.78},{"$f":"ROUND(P176*1.19,2)","v":41000},5126,6100,"Kompaktklasse","PKW",null,"2020-12-18"]
[{"$nulls":11},"Peugeot e-2008 (alle Versionen)",29621.85,35250,"Peugeot 2008 PureTech 130 Active",19537.82,23250,10084,12000,"Geländewagen / SUV","PKW",null,"2020-03-24"]
[{"$nulls":11},"Peugeot e-208 Allure",27058.82,32200,"Peugeot 208 Allure",17142.86,20400,9916,11800,"Kleinwagen","PKW"]
[{"$nulls":11},"Peugeot E-Expert 50kWh (alle Versionen)",35250,41947.5,"Peugeot Expert L2 Blue HDi  120 90 kW (Pro)",26500,{"$f":"ROUND(P179*1.19,2)","v":31535},{"$f":"ROUND(M179-P179,0)","v":8750},10413,"Utility (N1)","NFZ",null,"2020-09-10"]
[{"$nulls":11},"Peugeot E-Expert 75kWh (alle Versionen)",40250,47897.5,"Peugeot Expert L2 Blue HDi  120 90 kW (Pro)",26500,{"$f":"ROUND(P180*1.19,2)","v":31535},13750,16363,"Utility (N1)","NFZ",null,"2020-09-10"]
[{"$nulls":11},"Peugeot E-Expert Kombi 50kWh (alle Versionen)",41714.29,49640,"Peugeot Expert L2 BlueHDi  120 88 kW",{"$f":"ROUND(34205.38/1.16,2)","v":29487.4},{"$f":"ROUNDDOWN(P181*1.19,2)","v":35090},12227,14550,"Großraum-Van","PKW",null,"2021-01-14"]
[{"$nulls":11},"Peugeot E-Traveller 50kWh (alle Versionen)",46974.79,55900,"Peugeot Expert L2 BlueHDi  120 88 kW",{"$f":"ROUND(40307.56/1.16,2)","v":34747.9},{"$f":"ROUNDDOWN(P182*1.19,2)","v":41350},12227,14550,"Großraum-Van","PKW",null,"2021-01-14"]
[{"$nulls":11},"Peugeot e-Rifter (alle Versionen)",31588.240000000002,37590,"Peugeot e-Rifter PureTech 110 81 kW",{"$f":"ROUND(25140/1.19,2)","v":21126.05},{"$f":"P183*1.19","v":25139.999499999998},10462,12450,"Großraum-Van","PKW",null,"2021-06-22"]
[{"$nulls":11},"Peugeot iOn",18319.330000000002,21800,"Peugeot 108 5-Türer Vti 68",{"$f":"ROUND(Q184/1.19,2)","v":9873.9500000000007},11750,8445,10050,"Utility (N1)","NFZ"]
[{"$nulls":11},"Peugeot Partner electrique (L1)",21290,25335.1,"Peugeot Partner (L1)",14600,17374,6690,7961,"Utility (N1)","NFZ"]
[{"$nulls":11},"Peugeot Partner electrique (L2)",22340,26584.6,"Peugeot Partner (L2)",15450,18385.5,6890,8199,"Utility (N1)","NFZ"]
[{"$nulls":11},"Piaggio Porter Elektro (alle Versionen)",22510.6,26787.61,"Piaggio Porter (alle Versionen)",12186.89,14502.4,10324,12285,"Utility (N1)","NFZ"]
[{"$nulls":11},"Polaris Ranger EV",13823.53,16450,"Polaris Ranger 570",11420.17,13590,2403,2860,"Utility (N1)","NFZ",null,"2019-06-27"]
[{"$nulls":11},"Polestar 2",50336.13,59900,"Volvo S60 T6 AWD",43865.55,52200,6471,7700,"Mittelklasse","PKW"]
[{"$nulls":11},"Porsche Cayenne S E-Hybrid","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL",null,0,0,0,0,"Oberklasse","PKW"]
[{"$nulls":11},"Porsche Panamera 4 E-Hybrid (alle Versionen)","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL",null,0,0,0,0,"Oberklasse","PKW"]
[{"$nulls":11},"Porsche Panamera Turbo S E-Hybrid (alle Versionen)","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL",null,0,0,0,0,"Oberklasse","PKW"]
[{"$nulls":11},"Porsche Taycan 4S",88745.38,105607,"Porsche Panamera 4",82145.38,97753,{"$f":"ROUND(M193-P193,0)","v":6600},{"$f":"ROUND(N193-Q193,0)","v":7854},"Oberklasse","PKW"]
[{"$nulls":11},"Renault Kangoo Maxi Z.E. 33 2-Sitzer",31120,37032.800000000003,"Renault Kangoo Rapid Maxi",18120,21562.799999999999,13000,15470,"Utility (N1)","NFZ"]
[{"$nulls":11},"Renault Kangoo Maxi Z.E. 33 2-Sitzer, Batterie zur Miete",22020,26203.8,"Renault Kangoo Rapid Maxi",18120,21562.799999999999,3900,4641,"Utility (N1)","NFZ"]
[{"$nulls":11},"Renault Kangoo Maxi Z.E. 33 5-Sitzer",31920,37984.800000000003,"Renault Kangoo Rapid Maxi (Combi)",19120,22752.799999999999,12800,15232,"Utility (N1)","NFZ"]
[{"$nulls":11},"Renault Kangoo Maxi Z.E. 33 5-Sitzer, Batterie zur Miete",22820,27155.8,"Renault Kangoo Rapid Maxi (Combi)",19120,22752.799999999999,3700,4403,"Utility (N1)","NFZ"]
[{"$nulls":11},"Renault Kangoo Z.E. 33 2-Sitzer",29920,35604.800000000003,"Renault Kangoo Rapid Compact (2-Sitzer)",16570,19718.3,13350,15887,"Utility (N1)","NFZ"]
[{"$nulls":11},"Renault Kangoo Z.E. 33 2-Sitzer, Batterie zur Miete",20820,24775.8,"Renault Kangoo Rapid Compact (2-Sitzer)",16570,19718.3,4250,5058,"Utility (N1)","NFZ"]
[{"$nulls":11},"Renault Kangoo Z.E. 33 Doppelkabine",32320,38460.800000000003,"Renault Kangoo Rapid Maxi (Doppelkabine)",19420,23109.8,12900,15351,"Utility (N1)","NFZ"]
[{"$nulls":11},"Renault Kangoo Z.E. 33 Doppelkabine, Batterie zur Miete",23220,27631.8,"Renault Kangoo Rapid Maxi (Doppelkabine)",19420,23109.8,3800,4522,"Utility (N1)","NFZ"]
[{"$nulls":11},"Renault Master Z.E. Kasten (alle Versionen)",64000,76160,"Renault Master Kasten (alle Versionen)",31560,37556.400000000001,32440,38604,"Utility (N1)","NFZ"]
[{"$nulls":11},"Renault Master Z.E. Plattform-FG (alle Versionen)",62000,73780,"Renault Master Plattform-FG (alle Versionen)",28120,33462.799999999996,33880,40317,"Utility (N1)","NFZ"]
[{"$nulls":11},"Renault Twizzy 45 - Life, Intens, Cargo (5PS)",5840.34,6950,"Quad 300 ccm",2478.9899999999998,2950,3361,4000,"Leichtfahrzeug","LFZ"]
[{"$nulls":11},"Renault Twizzy Life - Intens, Cargo (18PS)",6428.57,7650,"Quad 400 ccm",3067.23,3650,3361,4000,"Leichtfahrzeug","LFZ"]
[{"$nulls":11},"Renault Zoe (52 kWh, 108 PS)",26882.35,31990,"Renault Clio Limited 5-türig",13016.81,15490,13866,16500,"Kleinwagen","PKW"]
[{"$nulls":11},"Renault Zoe (52 kWh, 108 PS), Batterie zur Miete",20084.03,23900,"Renault Clio Limited 5-türig",13016.81,15490,7067,8410,"Kleinwagen","PKW"]
[{"$nulls":9},"x",null,"Renault Zoe (52 kWh, 135 PS) ",30243.7,35990,"Renault Clio TCe 130 EDC GPF (130 PS)",17722.689999999999,21090,12521,14900,"Kleinwagen","PKW"]
[{"$nulls":11},"Renault Zoe (52 kWh, 135 PS), Batterie zur Miete",23445.38,27900,"Renault Clio TCe 130 EDC GPF (130 PS)",17722.689999999999,21090,5723,6810,"Kleinwagen","PKW"]
[{"$nulls":11},"Renault Zoe Life (22 kWh)",25294.12,30100,"Renault Clio Limited 5-türig",13016.81,15490,{"$f":"ROUND(M210-P210,0)","v":12277},{"$f":"ROUND(N210-Q210,0)","v":14610},"Kleinwagen","PKW"]
[{"$nulls":11},"Renault Zoe Life (22 kWh), Batterie zur Miete",18571.43,22100,"Renault Clio Limited 5-türig",13016.81,15490,5555,6610,"Kleinwagen","PKW"]
[{"$nulls":11},"Renault Zoe Life (41 kWh)",28655.46,34100,"Renault Clio Limited 5-türig",13016.81,15490,15639,18610,"Kleinwagen","PKW"]
[{"$nulls":11},"Renault Zoe Life (41 kWh), Batterie zur Miete",21932.77,26100,"Renault Clio Limited 5-türig",13016.81,15490,8916,10610,"Kleinwagen","PKW"]
[{"$nulls":11},"Renault Twingo Electric Vibes",20831.93,24790,"Renault Twingo SCe 75 Intens",{"$f":"ROUND(13637.31/1.16,2)","v":11756.3},{"$f":"ROUND(P214*1.19,2)","v":13990},9076,10800,"Kompaktklasse","PKW",null,"2020-12-18"]
[{"$nulls":11},"SAIC MAXUS EV 80 (Cargo Mobile)",48500,57715,"Renault Master Ecoline L1H1 2,8 t",22990,27358.1,25510,30357,"Utility (N1)","NFZ"]
[{"$nulls":11},"Seat Mii electric",17352.939999999999,20650,"Seat Mii 1.0 (55kW)",10134.450000000001,12060,7218,8590,"Mini","PKW"]
[{"$nulls":11},"Seat Leon 1.4 e-HYBRID XCELLENCE (alle Varianten)",29647.06,35280,"Seat Leon 1.5 TSI 6-Gang XCELLENCE",{"$f":"26095.13/1.16","v":22495.801724137935},{"$f":"ROUND(P217*1.19,2)","v":26770},7151,8510,"Mittelklasse","PKW",null,"2020-12-18"]
[{"$nulls":11},"Skoda Citigo-e iV (alle Versionen)",17605.04,20950,"Skoda Citigo Ambition (55kW)",{"$f":"ROUND(Q218/1.19,2)","v":9327.73},11100,8277,9850,"Kleinwagen","PKW"]
[{"$nulls":11},"Skoda ENYAQ iV 50 (alle Versionen)",28403.360000000001,33800,"Skoda Kodiaq 1,5 l TSI ACT1 110 kW, 6 Gang",{"$f":"ROUND(29000/1.19,2)","v":24369.75},{"$f":"ROUND(P219*1.19,2)","v":29000},4034,4800,"Geländewagen / SUV","PKW",null,"2020-12-18"]
[{"$nulls":11},"Skoda ENYAQ iV 60 (alle Versionen)",32647.06,38850,"Skoda Kodiaq 1,5 l TSI ACT1 110 kW, 6 Gang",{"$f":"ROUND(29000/1.19,2)","v":24369.75},29000,8277,9850,"Geländewagen / SUV","PKW",null,"2020-12-18"]
[{"$nulls":11},"Skoda ENYAQ iV 80 (alle Versionen)",36932.769999999997,43950,"Skoda Kodiaq 1,5 l TSI ACT1 110 kW, 6 Gang",{"$f":"ROUND(29000/1.19,2)","v":24369.75},29000,12563,14950,"Geländewagen / SUV","PKW",null,"2020-12-18"]
[{"$nulls":11},"Skoda Octavia iV Style (alle Varianten)",32428.45,38589.85,"Skoda Octavia 1.5 TSI ACT Style SG",{"$f":"29000/1.16","v":25000},{"$f":"ROUND(P222*1.19,2)","v":29750},7428,8840,"Mittelklasse","PKW",null,"2020-12-18"]
[{"$nulls":11},"Skoda Superb Combi iV (alle Versionen)",35789.919999999998,42590,"Skoda Superb Combi Ambition (110kW)",27436.97,32650,8353,9940,"Mittelklasse","PKW"]
[{"$nulls":11},"Skoda Superb iV (alle Versionen)",34949.58,41590,"Skoda Superb Ambition (110kW)",26596.639999999999,31650,8353,9940,"Mittelklasse","PKW"]
[{"$nulls":11},"Streetscooter Work 20 (alle Versionen)",35950,42780.5,"Nissan NV200 Kasten ",15150,18028.5,20800,24752,"Utility (N1)","NFZ"]
[{"$nulls":11},"Streetscooter Work 40 (alle Versionen)",40950,48730.5,"Nissan NV200 Kasten ",15150,18028.5,25800,30702,"Utility (N1)","NFZ"]
[{"$nulls":11},"Streetscooter Work L 30 (alle Versionen)",42950,51110.5,"Renault Master Kasten Ecoline L1H1 2,8t",22990,27358.1,19960,23752,"Utility (N1)","NFZ"]
[{"$nulls":11},"Streetscooter Work L 40 (alle Versionen)",45450,54085.5,"Renault Master Kasten Ecoline L1H1 2,8t",22990,27358.1,22460,26727,"Utility (N1)","NFZ"]
[{"$nulls":11},"Streetscooter Work XL (alle Versionen)",67000,79730,"Ford Transit 350 L4H3",33150,39448.5,33850,40282,"Utility (N1)","NFZ"]
[{"$nulls":11},"Tazzari Zero EM2 Space",19159.66,22800,"Mercedes Benz smart 52 kW",9382.35,11165,9777,11635,"Mini","PKW"]
[{"$nulls":11},"Tesla Model 3 75D Long Range / Performance",47378.15,56380,"BMW 330i ",37605.040000000001,44750,9773,11630,"Mittelklasse","PKW"]
[{"$nulls":11},"Tesla Model 3 Standard-Reichweite",{"$f":"ROUND(N232/1.19,2)","v":37394.959999999999},44500,"BMW 320i",34411.760000000002,40950,2983,3550,"Mittelklasse","PKW"]
[{"$nulls":11},"Tesla Model S (P)100D",91008.4,108300,"BMW 640i Grand Coupe",71344.539999999994,84900,{"$f":"ROUND(M233-P233,0)","v":19664},23400,"Oberklasse","PKW"]
[{"$nulls":11},"Tesla Model S (P)100D (Einsatz als Taxi)",91008.4,108300,"Mercedes Benz E400d 4MATIC",52705,62718.95,38303,45581,"Oberklasse","PKW"]
[{"$nulls":11},"Tesla Model S 75D",60503.360000000001,71999,"BMW 630i GT",52352.94,62300,8150,9699,"Oberklasse","PKW"]
[{"$nulls":11},"Tesla Model S 75D (Einsatz als Taxi)",60503.360000000001,71999,"Mercedes Benz E200 4MATIC",40700,48433,19803,23566,"Oberklasse","PKW"]
[{"$nulls":11},"Tesla Model S Maximal-Reichweite (ab Modelljahr 2019)",73092.44,86980,"BMW 640i GT",57899.16,68900,15193,18080,"Oberklasse","PKW"]
[{"$nulls":11},"Tesla Model S Maximal-Reichweite (Einsatz als Taxi) (ab Modelljahr 2019)",73092.44,86980,"Mercedes Benz E400d 4MATIC",55050,65509.5,18042,21471,"Oberklasse","PKW"]
[{"$nulls":11},"Tesla Model S Standard-Reichweite (ab Modelljahr 2019)",68890.759999999995,81980,"BMW 640i GT",57899.16,68900,10992,13080,"Oberklasse","PKW"]
[{"$nulls":11},"Tesla Model S Standard-Reichweite (Einsatz als Taxi) (ab Modelljahr 2019)",68890.759999999995,81980,"Mercedes Benz E200 4MATIC",43545,51818.55,25346,30161,"Oberklasse","PKW"]
[{"$nulls":11},"Tesla Model X (P)100D",93932.77,111780,"BMW X6 xDrive50i",74453.78,88600,19479,{"$f":"ROUND(N241-Q241,0)","v":23180},"Geländewagen / SUV","PKW"]
[{"$nulls":11},"Tesla Model X 75D",77504.2,92230,"BMW X6 xDrive40D",65378.15,77800,{"$f":"ROUND(M242-P242,0)","v":12126},{"$f":"ROUND(N242-Q242,0)","v":14430},"Geländewagen / SUV","PKW"]
[{"$nulls":11},"Tesla Model X Maximal-Reichweite (ab Modelljahr 2019)",76470.59,91000,"BMW X6 xDrive40D",66134.45,78700,{"$f":"ROUND(M243-P243,0)","v":10336},12300,"Geländewagen / SUV","PKW"]
[{"$nulls":11},"Tesla Model Y LongRange (alle Versionen)",49260.5,58620,"BMW X3 xDrive30i",{"$f":"ROUND(53028.56/1.16,2)","v":45714.28},{"$f":"ROUNDUP(P244*1.19,2)","v":54400},{"$f":"ROUND(M244-P244,0)","v":3546},4220,"Geländewagen / SUV","PKW",null,"2020-12-18"]
[{"$nulls":11},"Toyota Prius Plug-In Hybrid (alle Ausstattungen)",31554.62,37550,"Toyota Corolla 1.6 Executive",22075.63,26270,{"$f":"ROUND(M245-P245,0)","v":9479},{"$f":"ROUND(N245-Q245,0)","v":11280},"Kompaktklasse","PKW"]
[{"$nulls":11},"Toyota Proace Electric 50 kWh (alle Versionen)",36350,43256.5,"Toyota Proace 88kW",27200,{"$f":"ROUND(P246*1.19,2)","v":32368},{"$f":"ROUND(M246-P246,0)","v":9150},10889,"Utility (N1)","NFZ"]
[{"$nulls":11},"Toyota Proace Electric 75 kWh (alle Versionen)",41350,49206.5,"Toyota Proace 88kW",27200,32368,14150,16839,"Utility (N1)","NFZ"]
[{"$nulls":11},"Toyota Proace Verso Electric 50 kWh (alle Versionen)",49184.87,58530,"Toyota Proace Verso 88 kW",{"$f":"ROUND(43980/1.19,2)","v":36957.980000000003},43980,12227,14550,"Großraum-Van","PKW"]
[{"$nulls":11},"Toyota Proace Verso Electric 75 kWh (alle Versionen)",54226.89,64530,"Toyota Proace Verso 88 kW",{"$f":"ROUND(43980/1.19,2)","v":36957.980000000003},43980,17269,20550,"Großraum-Van","PKW"]
[{"$nulls":11},"Toyota RAV4 Plug-in Hybrid AWD (alle Versionen)",39907.56,47490,"Toyota RAV4 Comfort AWD",{"$f":"ROUND(39890/1.19,2)","v":33521.01},39890,6387,7600,"Geländewagen / SUV","PKW"]
[{"$nulls":11},"Tropos Motors ABLE XT1  (13kWh) (alle Versionen, FIN:…..E...)",23000,27370,"Piaggio Porter - Entry Level Chassis",11071.43,{"$f":"ROUNDUP(P251*1.19,2)","v":13175.01},11929,{"$f":"ROUND(N251-Q251,0)","v":14195},"Utility (N1)","NFZ",null,"2021-06-18"]
[{"$nulls":11},"Tropos Motors ABLE XT2 (26kWh) (alle Versionen, FIN:…..D...)",27000,32130,"Piaggio Porter - Entry Level Chassis",11071.43,{"$f":"ROUNDUP(P252*1.19,2)","v":13175.01},15929,{"$f":"ROUND(N252-Q252,0)","v":18955},"Utility (N1)","NFZ",null,"2021-06-18"]
[{"$nulls":11},"Volkswagen ABT e-Caddy (alle M1-Versionen)",31500,37485,"Volkswagen Caddy 75 kW TDI",22910,27262.9,8590,{"$f":"ROUND(N253-Q253,0)","v":10222},"Großraum-Van","PKW",null,"2021-02-10"]
[{"$nulls":11},"Volkswagen ABT e-Caddy (alle N1 Versionen)",31500,37485,"Volkswagen Caddy 75 kW TDI",22910,{"$f":"ROUND(P254*1.19,2)","v":27262.9},{"$f":"ROUND(M254-P254,0)","v":8590},10222,"Utility (N1)","NFZ",null,"2021-02-10"]
[{"$nulls":11},"Volkswagen Abt-e T6.1  Transporter / Caravelle / Kombi",null,null,"Elektrifizierungsumfang",null,null,25184,29969,"Utility (N1)","NFZ",null,"2020-09-10"]
[{"$nulls":11},"Volkswagen e-Crafter",69536,82747.839999999997,"VW Crafter 30 (75 kW / 102 PS)",{"$f":"ROUND(Q256/1.19,2)","v":28916},34410.04,{"$f":"ROUND(M256-P256,0)","v":40620},{"$f":"ROUND(N256-Q256,0)","v":48338},"Utility (N1)","NFZ"]
[{"$nulls":11},"Volkswagen e-Golf",30168.07,35900,"Volkswagen Golf 81 KW TSI CL",{"$f":"ROUND(Q257/1.19,2)","v":18466.39},21975.000000000004,11702,13925,"Kompaktklasse","PKW"]
[{"$nulls":11},"Volkswagen e-load up",23105.040000000001,27495,"Volkswagen load up!",{"$f":"ROUND(Q258/1.19,2)","v":9285.7099999999991},11050,13819,16445,"Mini","PKW"]
[{"$nulls":11},"Volkswagen e-up",22605.040000000001,26900,"Volkswagen move up! 55KW 5 Gang",{"$f":"ROUND(Q259/1.19,2)","v":10000},11900,12605,15000,"Mini","PKW"]
[{"$nulls":11},"Volkswagen Golf VII GTE",31008.400000000001,36900,"Volkswagen Golf 1,5 TSI ACT 110 KW CL",{"$f":"ROUND(Q260/1.19,2)","v":22436.97},26700,8571,10200,"Kompaktklasse","PKW"]
[{"$nulls":11},"Volkswagen Golf VIII 1.4 eHybrid (alle Versionen)",34294.120000000003,40810,"VW Golf Style 1.5 TSI OPF 6-Gang 110 kW",{"$f":"ROUND(29248.58/1.16,2)","v":25214.29},{"$f":"ROUNDDOWN(P261*1.19,2)","v":30005},9080,10805,"Kompaktklasse","PKW",null,"2020-12-18"]
[{"$nulls":11},"Volkswagen ID.3  45 kWh (alle Versionen)",26466.39,31495,"VW Golf 1.5 TSI OPF 6-Gang 96 kW",{"$f":"ROUND(26036.64/1.16,2)","v":22445.38},{"$f":"ROUND(P262*1.19,2)","v":26710},4021,4785,"Kompaktklasse","PKW",null,"2021-01-21"]
[{"$nulls":11},"Volkswagen ID.3 58 kWh Performance (alle Versionen)",30668.07,36495,"VW Golf Life 1.5 TSI OPF 6-Gang 110 kW",23302.52,{"$f":"ROUND(P263*1.19,2)","v":27730},7366,8765,"Kompaktklasse","PKW",null,"10.09.2020, auf 19 % USt angepasst"]
[{"$nulls":11},"Volkswagen ID.3 77 kWh Performance (alle Versionen)",35289.919999999998,41995,"VW Golf Life 1.5 TSI OPF 6-Gang 110 kW",23302.52,{"$f":"ROUND(P264*1.19,2)","v":27730},11987,14265,"Kompaktklasse","PKW",null,"10.09.2020, auf 19 % USt angepasst"]
[{"$nulls":11},"Volkswagen ID.4  52 kWh (alle Versionen)",32310.92,38450,"VW Tiguan Life 1.5 TSI OPF  Gang 110 kW",{"$f":"ROUND(29901.68/1.16,2)","v":25777.31},{"$f":"ROUND(P265*1.19,2)","v":30675},{"$f":"ROUND(M265-P265,0)","v":6534},{"$f":"ROUND(N265-Q265,0)","v":7775},"Geländewagen / SUV","PKW",null,"2021-02-11"]
[{"$nulls":11},"Volkswagen ID.4  Pro 77 kWh (alle Versionen)",37352.94,44450,"VW Tiguan Life 1.5 TSI OPF  Gang 110 kW",{"$f":"ROUND(29901.68/1.16,2)","v":25777.31},{"$f":"ROUND(P266*1.19,2)","v":30675},{"$f":"ROUND(M266-P266,0)","v":11576},13775,"Geländewagen / SUV","PKW",null,"2020-12-18"]
[{"$nulls":11},"Volkswagen ID.5 (alle Versionen)",38936.97,46335,"VW Tiguan Life 1.5 TSI OPF  Gang 110 kW",{"$f":"ROUND(Q267/1.19,2)","v":29810.92},35475,9126,10860,"Geländewagen / SUV","PKW",null,"2022-09-20"]
[{"$nulls":11},"Volkswagen ID.Buzz 77 kWh",54270,64581.3,"VW Multivan 1.5 TSI OPF",{"$f":"ROUND(Q268/1.19,2)","v":37775},44952.25,16495,19629,"Großraum-Van","PKW",null,"2022-09-20"]
[{"$nulls":11},"Volkswagen ID.Buzz Cargo 77kWh",45740,54430.6,"Caddy Cargo Maxi 2,0 TDI SCR",26840,31939.599999999999,18900,22491,"Utility (N1)","NFZ",null,"2022-09-20"]
[{"$nulls":11},"Volkswagen Passat GTE (PHEV) Limo/Variant",37184.870000000003,44250,"Volkswagen Passat 132 KW TSI CL (Limo / Variant)",{"$f":"ROUND(Q270/1.19,2)","v":29579.83},35200,7605,9050,"Mittelklasse","PKW"]
[{"$nulls":11},"Volkswagen Arteon 1.4 eHybrid (alle Varianten)",44021.01,52385,"Volkswagen Arteon 2.0 TDI SCR 110 kW",{"$f":"ROUND(43524.37/1.16,2)","v":37521.01},{"$f":"ROUND(P271*1.19,2)","v":44650},6500,7735,"Kompaktklasse","PKW",null,"2020-12-18"]
[{"$nulls":11},"Volkswagen Tiguan 1.4 eHybrid (alle Varianten)",36563.03,43510,"VW Tiguan Life 1.5 TSI OPF  6Gang 110 kW",{"$f":"ROUND(29901.68/1.16,2)","v":25777.31},{"$f":"ROUND(P272*1.19,2)","v":30675},{"$f":"ROUND(M272-P272,0)","v":10786},{"$f":"ROUND(N272-Q272,0)","v":12835},"Geländewagen / SUV","PKW",null,"2021-01-21"]
[{"$nulls":11},"Volkswagen Touareg 3.0 V6 eHybrid 4MOTION",62394.96,74250,"Volkswagen Touareg 3.0 V6 TDI SCR 4MOTION 170 kW",{"$f":"ROUND(64482.35/1.16,2)","v":55588.23},{"$f":"ROUNDUP(P273*1.19,2)","v":66150},6807,8100,"Geländewagen / SUV","PKW",null,"2020-12-18"]
[{"$nulls":11},"Volvo S60 T8 TWIN ENGINE AWD",49579.83,59000,"Volvo S60 T6 AWD",43865.55,52200,5714,6800,"Mittelklasse","PKW"]
[{"$nulls":11},"Volvo S90 T8 TWIN ENGINE AWD",57352.94,68250,"Volvo S90 T6 AWD Momentum",49033.61,58350,8319,9900,"Obere Mittelklasse","PKW"]
[{"$nulls":11},"Volvo V60 D6 TWIN ENGINE AWD",48109.24,57250,"Volvo V60 D5 Momentum",37899.160000000003,45100,10210,12150,"Mittelklasse","PKW"]
[{"$nulls":11},"Volvo V60 T6 TWIN ENGINE AWD",46932.77,55850,"Volvo V60 T5 AWD Momentum",42016.81,50000,4916,5850,"Mittelklasse","PKW"]
[{"$nulls":11},"Volvo V60 T8 TWIN ENGINE AWD",50504.2,60100,"Volvo V60 T6 AWD Momentum",41596.639999999999,49500,{"$f":"ROUND(M278-P278,0)","v":8908},{"$f":"ROUND(N278-Q278,0)","v":10600},"Mittelklasse","PKW"]
[{"$nulls":11},"Volvo V90 T8 TWIN ENGINE AWD",59915.97,71300,"Volvo V90 T6 AWD Momentum",51596.639999999999,61400,{"$f":"ROUND(M279-P279,0)","v":8319},9900,"Obere Mittelklasse","PKW"]
[{"$nulls":11},"Volvo XC 40 T5 TWIN ENGINE DKG Momentum Pro  ",41176.47,49000,"Volvo XC 40 T4 AWD Momentum Pro",36260.5,43150,4916,5850,"Geländewagen / SUV","PKW"]
[{"$nulls":11},"Volvo XC 60 T8 TWIN ENGINE",56722.69,67500,"Volvo XC 60 T6 AWD Momentum",47058.82,56000,9664,11500,"Geländewagen / SUV","PKW"]
[{"$nulls":11},"Volvo XC60 T6 AWD PHEV (BJ 20/21)",56806.720000000001,67600,"Volvo XC60 B5 AWD",46974.79,55900,{"$f":"ROUND(M282-P282,0)","v":9832},{"$f":"ROUND(N282-Q282,0)","v":11700},"Geländewagen / SUV","PKW",null,"2022-07-13"]
[{"$nulls":11},"Volvo XC60 T6 AWD Recharge PHEV (ab BJ 22)",54033.61,64300,"Volvo XC60 B5 AWD",45294.12,53900,{"$f":"ROUND(M283-P283,0)","v":8739},{"$f":"ROUND(N283-Q283,0)","v":10400},"Geländewagen / SUV","PKW",null,"2022-07-13"]
[{"$nulls":11},"Volvo XC 90 T8 TWIN ENGINE AWD",61974.79,73750,"Volvo XC 90 T6 AWD Momentum",53571.43,63750,8403,10000,"Geländewagen / SUV","PKW"]
[{"$nulls":11},"Volvo XC40 Recharge Pure Electric (alle Varianten)",52100.84,62000,"Volvo XC40 B5 AWD",43403.360000000001,{"$f":"ROUND(P285*1.19,2)","v":51650},8697,10350,"Geländewagen / SUV","PKW",null,"2021-01-11"]
[{"$nulls":11},"Zhidou D2S (17 KWh)",15546.22,18500,"Hyundai I10 Trend (49 kW)",11226.89,13360,4319,5140,"Mini","PKW"]
[{"$nulls":11},"Zhidou D2S (27 KWh)",18067.23,21500,"Hyundai I10 Style (64 kW)",12823.53,15260,5244,6240,"Mini","PKW"]
[{"$nulls":11},"Fahrzeugsegment Kleinwagen","*","*","Z.B. BMW i3, Renault Zoe…","*","*",15639,18610,"Kleinwagen","LFZ","Segment-werte werden nicht nach-träglich angepasst, nur zur Veröffent-lichung der Liste","10.09.2020: auf Ursprungswerte zurückgesetzt, Segmentewerte sind nach der Bewilligungsphase nicht mehr anzupassen!!"]
[{"$nulls":11},"Fahrzeugsegment Kompaktklasse","*","*","z.B. Nissan Leaf, VW e-Golf…","*","*",15395,18320,"Kompaktklasse","PKW",null,"10.09.2020: auf Ursprungswerte zurückgesetzt, Segmentewerte sind nach der Bewilligungsphase nicht mehr anzupassen!!"]
[{"$nulls":11},"Fahrzeugsegment Mini","*","*","z.B. VW e-up, Mitsubishi EV…","*","*",13819,16445,"Mini","PKW",null,"10.09.2020: auf Ursprungswerte zurückgesetzt, Segmentewerte sind nach der Bewilligungsphase nicht mehr anzupassen!!"]
[{"$nulls":11},"Fahrzeugsegment Mittelklasse","*","*","z.B. VW Passat GTE, BMW 330e…","*","*",10672,12700,"Mittelklasse","PKW",null,"10.09.2020: auf Ursprungswerte zurückgesetzt, Segmentewerte sind nach der Bewilligungsphase nicht mehr anzupassen!!"]
[{"$nulls":11},"Fahrzeugsegment Utilities (Nutzfahrzeuge N1)","*","*","z.B. Renault Kangoo, Nissan e-NV200, SAIC Maxus EV80","*","*",33850,40282,"Utility (N1)","PKW",null,"10.09.2020: auf Ursprungswerte zurückgesetzt, Segmentewerte sind nach der Bewilligungsphase nicht mehr anzupassen!!"]
[{"$nulls":11},"Fahrzeugsegment Obere Mittelklasse","*","*","z.B. BMW 530e, MB E350e, ...","*","*",8319,9900,"Obere Mittelklasse","NFZ",null,"10.09.2020: auf Ursprungswerte zurückgesetzt, Segmentewerte sind nach der Bewilligungsphase nicht mehr anzupassen!!"]
[{"$nulls":11},"Fahrzeugsegment Oberklasse","*","*","z.B. BMW 740e, Tesla Model S","*","*",19664,23400,"Oberklasse","PKW",null,"10.09.2020: auf Ursprungswerte zurückgesetzt, Segmentewerte sind nach der Bewilligungsphase nicht mehr anzupassen!!"]
[{"$nulls":11},"Fahrzeugsegment SUV","*","*","z.B. Mitsubishi Outlander, Tesla Model X, …","*","*",19479,23180,"Geländewagen / SUV","PKW",null,"10.09.2020: auf Ursprungswerte zurückgesetzt, Segmentewerte sind nach der Bewilligungsphase nicht mehr anzupassen!!"]
[{"$nulls":11},"Fahrzeugsegment Geländewagen","*","*","z.B. Audi Q7 e-tron, Volvo XC60/XC90,  …","*","*",15966,19000,"Geländewagen / SUV","PKW",null,"10.09.2020: auf Ursprungswerte zurückgesetzt, Segmentewerte sind nach der Bewilligungsphase nicht mehr anzupassen!!"]

{"sheet":"LKW, Busse, Sonderfahrzeuge","index":1,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,0,1,7],[2,0,2,7],[0,0,0,7]]}
["Ermittlung der förderfähigen Ausgaben für LKW, Busse und Sonder-Fahrzeuge",{"$nulls":7},"FKZ:"]
["Hierfür müssen Sie entsprechende Angebote für das E-Fahrzeug und ein Referenzfahrzeug eingeholt haben. Diese Angebote sind beizufügen.",{"$nulls":7},{"$f":"Fahrzeuge!I2","v":"03EMI3"}]
[{"$f":"IF(Fahrzeuge!C1=\"\",\"Bitte geben Sie auf der Registerkarte 'Fahrzeuge'  an, ob Sie zum Vorsteuerabzug berechtigt sind\",\"\")","v":"Bitte geben Sie auf der Registerkarte 'Fahrzeuge'  an, ob Sie zum Vorsteuerabzug berechtigt sind"}]
[]
["Pos.","Typ E-Fahrzeug",{"$f":"IF(Fahrzeuge!$C$1=\"nein\",\"Bruttopreis\nE-Fahrzeug laut beigefügtem Angebot *\",IF(Fahrzeuge!$C$1=\"ja\",\"Nettopreis\nE-Fahrzeug laut beigefügtem Angebot *\",\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\"))","v":"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!"},"Typ Referenzfahrzeug",{"$f":"IF(Fahrzeuge!$C$1=\"nein\",\"Bruttopreis Referenzfahrzeug\nlaut beigefügtem Angebot *\",IF(Fahrzeuge!$C$1=\"ja\",\"Nettopreis Referenzfahrzeug\nlaut beigefügtem Angebot *\",\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\"))","v":"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!"},{"$f":"IF(Fahrzeuge!$C$1=\"nein\",\"Förderfähige Ausgaben pro Fahrzeug (brutto)\",IF(Fahrzeuge!$C$1=\"ja\",\"Förderfähige Ausgaben pro Fahrzeug (netto)\",\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\"))","v":"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!"},"Anzahl zu beschaffender Fahrzeuge des Typs","Förderfähige Ausgaben ","Korrekturfeld PtJ"]
[1,{"$nulls":4},{"$f":"IF(B6>\"\",IF($A$3=\"\",C6-E6,$F$5),\"\")","v":""},null,{"$f":"IF(B6>\"\",F6*G6,\"\")","v":""}]
[]
[2,{"$nulls":4},{"$f":"IF(B8>\"\",IF($A$3=\"\",C8-E8,$F$5),\"\")","v":""},null,{"$f":"IF(B8>\"\",F8*G8,\"\")","v":""}]
[]
[3,{"$nulls":4},"",null,""]
[]
[4,{"$nulls":4},"",null,""]
[]
[5,{"$nulls":4},"",null,""]
[]
[6,{"$nulls":4},"",null,""]
[]
[7,{"$nulls":4},"",null,""]
[]
[8,{"$nulls":4},"",null,""]
[]
[9,{"$nulls":4},"",null,""]
[]
[10,{"$nulls":4},"",null,""]
[]
["Summe",{"$nulls":6},{"$f":"SUM(H6:H24)","v":0}]

{"sheet":"Ladeinfrastruktur","index":2,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,0,1,5],[26,1,26,5]]}
["Ermittlung der förderfähigen Pauschalen für Ladeinfrastruktur",null,null,null,"FKZ:",{"$f":"Fahrzeuge!I2","v":"03EMI3"}]
[{"$f":"IF(Fahrzeuge!C1=\"\",\"Bitte geben Sie auf der Registerkarte 'Fahrzeuge'  an, ob Sie zum Vorsteuerabzug berechtigt sind\",\"\")","v":"Bitte geben Sie auf der Registerkarte 'Fahrzeuge'  an, ob Sie zum Vorsteuerabzug berechtigt sind"}]
[]
["Pos.","Typ Ladeinfrastruktur (LIS)*\n[Auswahlbox]",{"$f":"IF(Fahrzeuge!$C$1=\"nein\",\"Förderfähige Ausgaben pro Ladesäule (brutto)\",IF(Fahrzeuge!$C$1=\"ja\",\"Förderfähige Ausgaben pro Ladesäule (netto)\",\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\"))","v":"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!"},"Anzahl zu beschaffender Ladesäulen des Typs","Förderfähige Ausgaben ","Korrekturfeld PtJ",null,null,"Typ Ladeinfrastruktur","Ausgabenpauschale netto","Ausgabenpauschale netto"]
[1,null,{"$f":"IF($B5>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B5,$I$5:$K$14,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B5,$I$5:$K$14,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},null,{"$f":"IF(D5>0,C5*D5,\"\")","v":""},null,null,null,"öff. zugängl. [AC] ≥ 3,7 kW (1 Ladepunkt)",2000,{"$f":"J5*1.19","v":2380}]
[{"$nulls":8},"öff. zugängl. [AC] ≥ 11 kW (min. 2 Ladepunkte)",5000,{"$f":"J6*1.19","v":5950}]
[2,null,{"$f":"IF($B7>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B7,$I$5:$K$14,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B7,$I$5:$K$14,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},null,{"$f":"IF(D7>0,C7*D7,\"\")","v":""},null,null,null,"öff. zugängl. [DC] ≤ 50 kW",20000,23800]
[{"$nulls":8},"öff. zugängl. [DC] 51 kW-149 kW",35000,41650]
[3,null,{"$f":"IF($B9>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B9,$I$5:$K$14,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B9,$I$5:$K$14,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},null,{"$f":"IF(D9>0,C9*D9,\"\")","v":""},null,null,null,"öff. zugängl. [DC] ≥ 150 kW",50000,59500]
[{"$nulls":8},"nicht öff. zugängl. [AC] ≥ 3,7 kW (1 Ladepunkt)",900,1071]
[4,null,{"$f":"IF($B11>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B11,$I$5:$K$14,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B11,$I$5:$K$14,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},null,{"$f":"IF(D11>0,C11*D11,\"\")","v":""},null,null,null,"nicht öff. zugängl. [AC] ≥ 11 kW (min. 2 Ladepunkte)",3000,3570]
[{"$nulls":8},"nicht öff. zugängl. [DC] ≤ 50 kW",20000,23800]
[5,null,{"$f":"IF($B13>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B13,$I$5:$K$14,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B13,$I$5:$K$14,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},null,{"$f":"IF(D13>0,C13*D13,\"\")","v":""},null,null,null,"nicht öff. zugängl. [DC] 51 kW-149 kW",35000,41650]
[{"$nulls":8},"nicht öff. zugängl. [DC] ≥ 150 kW",50000,59500]
[6,null,{"$f":"IF($B15>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B15,$I$5:$K$14,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B15,$I$5:$K$14,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},null,{"$f":"IF(D15>0,C15*D15,\"\")","v":""}]
[]
[7,null,{"$f":"IF($B17>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B17,$I$5:$K$14,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B17,$I$5:$K$14,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},null,{"$f":"IF(D17>0,C17*D17,\"\")","v":""}]
[]
[8,null,{"$f":"IF($B19>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B19,$I$5:$K$14,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B19,$I$5:$K$14,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},null,{"$f":"IF(D19>0,C19*D19,\"\")","v":""}]
[]
[9,null,{"$f":"IF($B21>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B21,$I$5:$K$14,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B21,$I$5:$K$14,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},null,{"$f":"IF(D21>0,C21*D21,\"\")","v":""}]
[]
[10,null,{"$f":"IF($B23>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B23,$I$5:$K$14,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B23,$I$5:$K$14,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},null,{"$f":"IF(D23>0,C23*D23,\"\")","v":""}]
[]
["Summe",null,null,null,{"$f":"SUM(E5:E23)","v":0}]
[]
["* öff. zugängl.:"," öffentlich zugängliche Ladepunkte im Sinne der Verordnung über technische Mindestanforderungen an den sicheren und interoperablen Aufbau und Betrieb von öffentlich zugänglichen Ladepunkten für Elektromobile "]
["* nicht. öff. zugängl.:","LIS ist für die Öffentlichkeit nicht zugänglich"]
["* DC :","Gleichstrom-Ladeinfrastruktur"]
["* AC :","Wechselstrom-Ladeinfrastruktur"]

{"sheet":"spezielle Ladeinfrastruktur","index":3,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[26,0,26,5],[1,0,1,6],[0,0,0,3]]}
["Ermittlung der förderfähigen Ausgaben für Ladeinfrastruktur die nicht in der Registerkarte \"Ladeinfrastruktur\" aufgeführt wird",{"$nulls":4},"FKZ:",{"$f":"Fahrzeuge!I2","v":"03EMI3"}]
["Hierfür müssen Sie entsprechende Angebote für die Ladeinfrastruktur eingeholt haben. Diese Angebote sind beizufügen."]
[{"$f":"IF(Fahrzeuge!C1=\"\",\"Bitte geben Sie auf der Registerkarte 'Fahrzeuge'  an, ob Sie zum Vorsteuerabzug berechtigt sind\",\"\")","v":"Bitte geben Sie auf der Registerkarte 'Fahrzeuge'  an, ob Sie zum Vorsteuerabzug berechtigt sind"}]
[]
["Pos.","Typ Ladeinfrastruktur (LIS)",{"$f":"IF(Fahrzeuge!$C$1=\"nein\",\"Bruttopreis LIS laut beigefügtem Angebot *\",IF(Fahrzeuge!$C$1=\"ja\",\"Nettopreis LIS laut beigefügtem Angebot *\",\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\"))","v":"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!"},"Anzahl zu beschaffender LIS dieses Typs","Förderfähige Ausgaben ","Korrekturfeld PtJ"]
[1,null,null,null,{"$f":"IF(C6>0,D6*C6,\"\")","v":""}]
[]
[2,null,null,null,{"$f":"IF(C8>0,D8*C8,\"\")","v":""}]
[]
[3,null,null,null,{"$f":"IF(C10>0,D10*C10,\"\")","v":""}]
[]
[4,null,null,null,{"$f":"IF(C12>0,D12*C12,\"\")","v":""}]
[]
[5,null,null,null,{"$f":"IF(C14>0,D14*C14,\"\")","v":""}]
[]
[6,null,null,null,{"$f":"IF(C16>0,D16*C16,\"\")","v":""}]
[]
[7,null,null,null,{"$f":"IF(C18>0,D18*C18,\"\")","v":""}]
[]
[8,null,null,null,{"$f":"IF(C20>0,D20*C20,\"\")","v":""}]
[]
[9,null,null,null,{"$f":"IF(C22>0,D22*C22,\"\")","v":""}]
[]
[10,null,null,null,{"$f":"IF(C24>0,D24*C24,\"\")","v":""}]
[]
["Summe",null,null,null,{"$f":"IF(C6>0,SUM(E6:E24),\"\")","v":""}]

{"sheet":"Vorlage für AZA","index":4,"n_rows":59,"n_cols":5,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,0,2,7],[4,0,4,7],[5,0,5,7]]}
["Vorlage zum Übertragen der Daten aus dieser Tabelle in den AZA in easyOnline, die Anzahl der zu beschaffenden Fzg. / LIS muss ggf. auf die Anschaffungsjahre aufgeteilt werden"]
[]
["Gesamtfinanzierung - Gegenstände und andere Investitionen von mehr als 410 € im Einzelfall"]
[null,null,null,"FKZ:",{"$f":"Fahrzeuge!I2","v":"03EMI3"}]
[{"$f":"IF(Fahrzeuge!$C$1=\"nein\",\"Der Antragsteller ist nicht zum Vorsteuerabzug berechtigt.\",IF(Fahrzeuge!$C$1=\"ja\",\"Der Antragsteller ist zum Vorsteuerabzug berechtigt.\",\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\"))","v":"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!"}]
["(sollte diese Aussage nicht zutreffen, wählen Sie bitte die entsprechende Option auf der Registerkarte \"Fahrzeuge\")"]
[]
["lfd. Nr.","Bezeichnung","Zuwendungsfähige\nAusgaben / Stück*","Anzahl*","F0833 Betrag €"]
[{"$f":"IF(Fahrzeuge!$B13>\"\",Fahrzeuge!A13,0)","v":0},{"$f":"IF(Fahrzeuge!$B13>\"\",CONCATENATE(Fahrzeuge!C13,\" \",Fahrzeuge!B13),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B13>\"\",Fahrzeuge!G13,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B13>\"\",Fahrzeuge!H13,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B13>\"\",Fahrzeuge!I13,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!$B14>\"\",Fahrzeuge!A14,0)","v":0},{"$f":"IF(Fahrzeuge!$B14>\"\",CONCATENATE(Fahrzeuge!C14,\" \",Fahrzeuge!B14),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B14>\"\",Fahrzeuge!G14,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B14>\"\",Fahrzeuge!H14,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B14>\"\",Fahrzeuge!I14,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!$B15>\"\",Fahrzeuge!A15,0)","v":0},{"$f":"IF(Fahrzeuge!$B15>\"\",CONCATENATE(Fahrzeuge!C15,\" \",Fahrzeuge!B15),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B15>\"\",Fahrzeuge!G15,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B15>\"\",Fahrzeuge!H15,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B15>\"\",Fahrzeuge!I15,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!$B16>\"\",Fahrzeuge!A16,0)","v":0},{"$f":"IF(Fahrzeuge!$B16>\"\",CONCATENATE(Fahrzeuge!C16,\" \",Fahrzeuge!B16),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B16>\"\",Fahrzeuge!G16,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B16>\"\",Fahrzeuge!H16,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B16>\"\",Fahrzeuge!I16,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!$B17>\"\",Fahrzeuge!A17,0)","v":0},{"$f":"IF(Fahrzeuge!$B17>\"\",CONCATENATE(Fahrzeuge!C17,\" \",Fahrzeuge!B17),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B17>\"\",Fahrzeuge!G17,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B17>\"\",Fahrzeuge!H17,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B17>\"\",Fahrzeuge!I17,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!$B18>\"\",Fahrzeuge!A18,0)","v":0},{"$f":"IF(Fahrzeuge!$B18>\"\",CONCATENATE(Fahrzeuge!C18,\" \",Fahrzeuge!B18),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B18>\"\",Fahrzeuge!G18,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B18>\"\",Fahrzeuge!H18,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B18>\"\",Fahrzeuge!I18,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!$B19>\"\",Fahrzeuge!A19,0)","v":0},{"$f":"IF(Fahrzeuge!$B19>\"\",CONCATENATE(Fahrzeuge!C19,\" \",Fahrzeuge!B19),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B19>\"\",Fahrzeuge!G19,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B19>\"\",Fahrzeuge!H19,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B19>\"\",Fahrzeuge!I19,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!$B20>\"\",Fahrzeuge!A20,0)","v":0},{"$f":"IF(Fahrzeuge!$B20>\"\",CONCATENATE(Fahrzeuge!C20,\" \",Fahrzeuge!B20),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B20>\"\",Fahrzeuge!G20,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B20>\"\",Fahrzeuge!H20,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B20>\"\",Fahrzeuge!I20,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!$B21>\"\",Fahrzeuge!A21,0)","v":0},{"$f":"IF(Fahrzeuge!$B21>\"\",CONCATENATE(Fahrzeuge!C21,\" \",Fahrzeuge!B21),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B21>\"\",Fahrzeuge!G21,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B21>\"\",Fahrzeuge!H21,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B21>\"\",Fahrzeuge!I21,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!$B22>\"\",Fahrzeuge!A22,0)","v":0},{"$f":"IF(Fahrzeuge!$B22>\"\",CONCATENATE(Fahrzeuge!C22,\" \",Fahrzeuge!B22),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B22>\"\",Fahrzeuge!G22,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B22>\"\",Fahrzeuge!H22,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B22>\"\",Fahrzeuge!I22,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!$B23>\"\",Fahrzeuge!A23,0)","v":0},{"$f":"IF(Fahrzeuge!$B23>\"\",CONCATENATE(Fahrzeuge!C23,\" \",Fahrzeuge!B23),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B23>\"\",Fahrzeuge!G23,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B23>\"\",Fahrzeuge!H23,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B23>\"\",Fahrzeuge!I23,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!$B24>\"\",Fahrzeuge!A24,0)","v":0},{"$f":"IF(Fahrzeuge!$B24>\"\",CONCATENATE(Fahrzeuge!C24,\" \",Fahrzeuge!B24),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B24>\"\",Fahrzeuge!G24,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B24>\"\",Fahrzeuge!H24,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B24>\"\",Fahrzeuge!I24,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!$B25>\"\",Fahrzeuge!A25,0)","v":0},{"$f":"IF(Fahrzeuge!$B25>\"\",CONCATENATE(Fahrzeuge!C25,\" \",Fahrzeuge!B25),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B25>\"\",Fahrzeuge!G25,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B25>\"\",Fahrzeuge!H25,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B25>\"\",Fahrzeuge!I25,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!$B26>\"\",Fahrzeuge!A26,0)","v":0},{"$f":"IF(Fahrzeuge!$B26>\"\",CONCATENATE(Fahrzeuge!C26,\" \",Fahrzeuge!B26),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B26>\"\",Fahrzeuge!G26,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B26>\"\",Fahrzeuge!H26,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B26>\"\",Fahrzeuge!I26,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!$B27>\"\",Fahrzeuge!A27,0)","v":0},{"$f":"IF(Fahrzeuge!$B27>\"\",CONCATENATE(Fahrzeuge!C27,\" \",Fahrzeuge!B27),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B27>\"\",Fahrzeuge!G27,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B27>\"\",Fahrzeuge!H27,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B27>\"\",Fahrzeuge!I27,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!$B28>\"\",Fahrzeuge!A28,0)","v":0},{"$f":"IF(Fahrzeuge!$B28>\"\",CONCATENATE(Fahrzeuge!C28,\" \",Fahrzeuge!B28),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B28>\"\",Fahrzeuge!G28,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B28>\"\",Fahrzeuge!H28,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B28>\"\",Fahrzeuge!I28,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!$B29>\"\",Fahrzeuge!A29,0)","v":0},{"$f":"IF(Fahrzeuge!$B29>\"\",CONCATENATE(Fahrzeuge!C29,\" \",Fahrzeuge!B29),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B29>\"\",Fahrzeuge!G29,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B29>\"\",Fahrzeuge!H29,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B29>\"\",Fahrzeuge!I29,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!$B30>\"\",Fahrzeuge!A30,0)","v":0},{"$f":"IF(Fahrzeuge!$B30>\"\",CONCATENATE(Fahrzeuge!C30,\" \",Fahrzeuge!B30),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B30>\"\",Fahrzeuge!G30,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B30>\"\",Fahrzeuge!H30,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B30>\"\",Fahrzeuge!I30,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!$B31>\"\",Fahrzeuge!A31,0)","v":0},{"$f":"IF(Fahrzeuge!$B31>\"\",CONCATENATE(Fahrzeuge!C31,\" \",Fahrzeuge!B31),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B31>\"\",Fahrzeuge!G31,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B31>\"\",Fahrzeuge!H31,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B31>\"\",Fahrzeuge!I31,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!$B32>\"\",Fahrzeuge!A32,0)","v":0},{"$f":"IF(Fahrzeuge!$B32>\"\",CONCATENATE(Fahrzeuge!C32,\" \",Fahrzeuge!B32),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B32>\"\",Fahrzeuge!G32,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B32>\"\",Fahrzeuge!H32,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B32>\"\",Fahrzeuge!I32,\"\")","v":""}]
[{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!B6>\"\",A28+1,A28)","v":0},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B6>\"\",'LKW, Busse, Sonderfahrzeuge'!$B6,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B6>\"\",'LKW, Busse, Sonderfahrzeuge'!F6,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B6>\"\",'LKW, Busse, Sonderfahrzeuge'!G6,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B6>\"\",'LKW, Busse, Sonderfahrzeuge'!H6,\"\")","v":""}]
[{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!B8>\"\",A29+1,A29)","v":0},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B8>\"\",'LKW, Busse, Sonderfahrzeuge'!$B8,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B8>\"\",'LKW, Busse, Sonderfahrzeuge'!F8,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B8>\"\",'LKW, Busse, Sonderfahrzeuge'!G8,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B8>\"\",'LKW, Busse, Sonderfahrzeuge'!H8,\"\")","v":""}]
[{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!B10>\"\",A30+1,A30)","v":0},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B10>\"\",'LKW, Busse, Sonderfahrzeuge'!$B10,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B10>\"\",'LKW, Busse, Sonderfahrzeuge'!F10,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B10>\"\",'LKW, Busse, Sonderfahrzeuge'!G10,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B10>\"\",'LKW, Busse, Sonderfahrzeuge'!H10,\"\")","v":""}]
[{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!B12>\"\",A31+1,A31)","v":0},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B12>\"\",'LKW, Busse, Sonderfahrzeuge'!$B12,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B12>\"\",'LKW, Busse, Sonderfahrzeuge'!F12,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B12>\"\",'LKW, Busse, Sonderfahrzeuge'!G12,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B12>\"\",'LKW, Busse, Sonderfahrzeuge'!H12,\"\")","v":""}]
[{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!B14>\"\",A32+1,A32)","v":0},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B14>\"\",'LKW, Busse, Sonderfahrzeuge'!$B14,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B14>\"\",'LKW, Busse, Sonderfahrzeuge'!F14,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B14>\"\",'LKW, Busse, Sonderfahrzeuge'!G14,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B14>\"\",'LKW, Busse, Sonderfahrzeuge'!H14,\"\")","v":""}]
[{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!B16>\"\",A33+1,A33)","v":0},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B16>\"\",'LKW, Busse, Sonderfahrzeuge'!$B16,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B16>\"\",'LKW, Busse, Sonderfahrzeuge'!F16,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B16>\"\",'LKW, Busse, Sonderfahrzeuge'!G16,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B16>\"\",'LKW, Busse, Sonderfahrzeuge'!H16,\"\")","v":""}]
[{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!B18>\"\",A34+1,A34)","v":0},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B18>\"\",'LKW, Busse, Sonderfahrzeuge'!$B18,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B18>\"\",'LKW, Busse, Sonderfahrzeuge'!F18,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B18>\"\",'LKW, Busse, Sonderfahrzeuge'!G18,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B18>\"\",'LKW, Busse, Sonderfahrzeuge'!H18,\"\")","v":""}]
[{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!B20>\"\",A35+1,A35)","v":0},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B20>\"\",'LKW, Busse, Sonderfahrzeuge'!$B20,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B20>\"\",'LKW, Busse, Sonderfahrzeuge'!F20,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B20>\"\",'LKW, Busse, Sonderfahrzeuge'!G20,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B20>\"\",'LKW, Busse, Sonderfahrzeuge'!H20,\"\")","v":""}]
[{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!B22>\"\",A36+1,A36)","v":0},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B22>\"\",'LKW, Busse, Sonderfahrzeuge'!$B22,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B22>\"\",'LKW, Busse, Sonderfahrzeuge'!F22,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B22>\"\",'LKW, Busse, Sonderfahrzeuge'!G22,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B22>\"\",'LKW, Busse, Sonderfahrzeuge'!H22,\"\")","v":""}]
[{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!B24>\"\",A37+1,A37)","v":0},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B24>\"\",'LKW, Busse, Sonderfahrzeuge'!$B24,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B24>\"\",'LKW, Busse, Sonderfahrzeuge'!F24,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B24>\"\",'LKW, Busse, Sonderfahrzeuge'!G24,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B24>\"\",'LKW, Busse, Sonderfahrzeuge'!H24,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!B5>\"\",A38+1,A38)","v":0},{"$f":"IF(Ladeinfrastruktur!$B5>\"\",Ladeinfrastruktur!B5,\"\")","v":""},{"$f":"IF($B39>\"\",Ladeinfrastruktur!C5,\"\")","v":""},{"$f":"IF($B39>\"\",Ladeinfrastruktur!D5,\"\")","v":""},{"$f":"IF($B39>\"\",Ladeinfrastruktur!E5,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!B7>\"\",A39+1,A39)","v":0},{"$f":"IF(Ladeinfrastruktur!$B7>\"\",Ladeinfrastruktur!B7,\"\")","v":""},{"$f":"IF($B40>\"\",Ladeinfrastruktur!C7,\"\")","v":""},{"$f":"IF($B40>\"\",Ladeinfrastruktur!D7,\"\")","v":""},{"$f":"IF($B40>\"\",Ladeinfrastruktur!E7,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!B9>\"\",A40+1,A40)","v":0},{"$f":"IF(Ladeinfrastruktur!$B9>\"\",Ladeinfrastruktur!B9,\"\")","v":""},{"$f":"IF($B41>\"\",Ladeinfrastruktur!C9,\"\")","v":""},{"$f":"IF($B41>\"\",Ladeinfrastruktur!D9,\"\")","v":""},{"$f":"IF($B41>\"\",Ladeinfrastruktur!E9,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!B11>\"\",A41+1,A41)","v":0},{"$f":"IF(Ladeinfrastruktur!$B11>\"\",Ladeinfrastruktur!B11,\"\")","v":""},{"$f":"IF($B42>\"\",Ladeinfrastruktur!C11,\"\")","v":""},{"$f":"IF($B42>\"\",Ladeinfrastruktur!D11,\"\")","v":""},{"$f":"IF($B42>\"\",Ladeinfrastruktur!E11,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!B13>\"\",A42+1,A42)","v":0},{"$f":"IF(Ladeinfrastruktur!$B13>\"\",Ladeinfrastruktur!B13,\"\")","v":""},{"$f":"IF($B43>\"\",Ladeinfrastruktur!C13,\"\")","v":""},{"$f":"IF($B43>\"\",Ladeinfrastruktur!D13,\"\")","v":""},{"$f":"IF($B43>\"\",Ladeinfrastruktur!E13,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!B15>\"\",A43+1,A43)","v":0},{"$f":"IF(Ladeinfrastruktur!$B15>\"\",Ladeinfrastruktur!B15,\"\")","v":""},{"$f":"IF($B44>\"\",Ladeinfrastruktur!C15,\"\")","v":""},{"$f":"IF($B44>\"\",Ladeinfrastruktur!D15,\"\")","v":""},{"$f":"IF($B44>\"\",Ladeinfrastruktur!E15,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!B17>\"\",A44+1,A44)","v":0},{"$f":"IF(Ladeinfrastruktur!$B17>\"\",Ladeinfrastruktur!B17,\"\")","v":""},{"$f":"IF($B45>\"\",Ladeinfrastruktur!C17,\"\")","v":""},{"$f":"IF($B45>\"\",Ladeinfrastruktur!D17,\"\")","v":""},{"$f":"IF($B45>\"\",Ladeinfrastruktur!E17,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!B19>\"\",A45+1,A45)","v":0},{"$f":"IF(Ladeinfrastruktur!$B19>\"\",Ladeinfrastruktur!B19,\"\")","v":""},{"$f":"IF($B46>\"\",Ladeinfrastruktur!C19,\"\")","v":""},{"$f":"IF($B46>\"\",Ladeinfrastruktur!D19,\"\")","v":""},{"$f":"IF($B46>\"\",Ladeinfrastruktur!E19,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!B21>\"\",A46+1,A46)","v":0},{"$f":"IF(Ladeinfrastruktur!$B21>\"\",Ladeinfrastruktur!B21,\"\")","v":""},{"$f":"IF($B47>\"\",Ladeinfrastruktur!C21,\"\")","v":""},{"$f":"IF($B47>\"\",Ladeinfrastruktur!D21,\"\")","v":""},{"$f":"IF($B47>\"\",Ladeinfrastruktur!E21,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!B23>\"\",A47+1,A47)","v":0},{"$f":"IF(Ladeinfrastruktur!$B23>\"\",Ladeinfrastruktur!B23,\"\")","v":""},{"$f":"IF($B48>\"\",Ladeinfrastruktur!C23,\"\")","v":""},{"$f":"IF($B48>\"\",Ladeinfrastruktur!D23,\"\")","v":""},{"$f":"IF($B48>\"\",Ladeinfrastruktur!E23,\"\")","v":""}]
[{"$f":"IF('spezielle Ladeinfrastruktur'!B6>\"\",A48+1,A48)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!$B6>\"\",'spezielle Ladeinfrastruktur'!B6,\"\")","v":""},{"$f":"IF($B49>\"\",'spezielle Ladeinfrastruktur'!C6,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B6>\"\",'spezielle Ladeinfrastruktur'!D6,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B6>\"\",'spezielle Ladeinfrastruktur'!E6,\"\")","v":""}]
[{"$f":"IF('spezielle Ladeinfrastruktur'!B8>\"\",A49+1,A49)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!$B8>\"\",'spezielle Ladeinfrastruktur'!B8,\"\")","v":""},{"$f":"IF($B50>\"\",'spezielle Ladeinfrastruktur'!C8,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B8>\"\",'spezielle Ladeinfrastruktur'!D8,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B8>\"\",'spezielle Ladeinfrastruktur'!E8,\"\")","v":""}]
[{"$f":"IF('spezielle Ladeinfrastruktur'!B10>\"\",A50+1,A50)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!$B10>\"\",'spezielle Ladeinfrastruktur'!B10,\"\")","v":""},{"$f":"IF($B51>\"\",'spezielle Ladeinfrastruktur'!C10,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B10>\"\",'spezielle Ladeinfrastruktur'!D10,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B10>\"\",'spezielle Ladeinfrastruktur'!E10,\"\")","v":""}]
[{"$f":"IF('spezielle Ladeinfrastruktur'!B12>\"\",A51+1,A51)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!$B12>\"\",'spezielle Ladeinfrastruktur'!B12,\"\")","v":""},{"$f":"IF($B52>\"\",'spezielle Ladeinfrastruktur'!C12,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B12>\"\",'spezielle Ladeinfrastruktur'!D12,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B12>\"\",'spezielle Ladeinfrastruktur'!E12,\"\")","v":""}]
[{"$f":"IF('spezielle Ladeinfrastruktur'!B14>\"\",A52+1,A52)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!$B14>\"\",'spezielle Ladeinfrastruktur'!B14,\"\")","v":""},{"$f":"IF($B53>\"\",'spezielle Ladeinfrastruktur'!C14,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B14>\"\",'spezielle Ladeinfrastruktur'!D14,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B14>\"\",'spezielle Ladeinfrastruktur'!E14,\"\")","v":""}]
[{"$f":"IF('spezielle Ladeinfrastruktur'!B16>\"\",A53+1,A53)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!$B16>\"\",'spezielle Ladeinfrastruktur'!B16,\"\")","v":""},{"$f":"IF($B54>\"\",'spezielle Ladeinfrastruktur'!C16,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B16>\"\",'spezielle Ladeinfrastruktur'!D16,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B16>\"\",'spezielle Ladeinfrastruktur'!E16,\"\")","v":""}]
[{"$f":"IF('spezielle Ladeinfrastruktur'!B18>\"\",A54+1,A54)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!$B18>\"\",'spezielle Ladeinfrastruktur'!B18,\"\")","v":""},{"$f":"IF($B55>\"\",'spezielle Ladeinfrastruktur'!C18,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B18>\"\",'spezielle Ladeinfrastruktur'!D18,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B18>\"\",'spezielle Ladeinfrastruktur'!E18,\"\")","v":""}]
[{"$f":"IF('spezielle Ladeinfrastruktur'!B20>\"\",A55+1,A55)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!$B20>\"\",'spezielle Ladeinfrastruktur'!B20,\"\")","v":""},{"$f":"IF($B56>\"\",'spezielle Ladeinfrastruktur'!C20,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B20>\"\",'spezielle Ladeinfrastruktur'!D20,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B20>\"\",'spezielle Ladeinfrastruktur'!E20,\"\")","v":""}]
[{"$f":"IF('spezielle Ladeinfrastruktur'!B22>\"\",A56+1,A56)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!$B22>\"\",'spezielle Ladeinfrastruktur'!B22,\"\")","v":""},{"$f":"IF($B57>\"\",'spezielle Ladeinfrastruktur'!C22,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B22>\"\",'spezielle Ladeinfrastruktur'!D22,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B22>\"\",'spezielle Ladeinfrastruktur'!E22,\"\")","v":""}]
[{"$f":"IF('spezielle Ladeinfrastruktur'!B24>\"\",A57+1,A57)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!$B24>\"\",'spezielle Ladeinfrastruktur'!B24,\"\")","v":""},{"$f":"IF($B58>\"\",'spezielle Ladeinfrastruktur'!C24,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B24>\"\",'spezielle Ladeinfrastruktur'!D24,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B24>\"\",'spezielle Ladeinfrastruktur'!E24,\"\")","v":""}]
[null,null,null,"Summe:",{"$f":"ROUND(SUM(E9:E58),0)","v":0}]