{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["Auswertung_Segmente","Fahrzeuge","LKW, Busse, Sonderfahrzeuge","Ladeinfrastruktur","spezielle Ladeinfrastruktur","Vorlage für AZA"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":28,"comments":0,"pivot_tables":1},"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":"Auswertung_Segmente","index":0,"n_rows":99,"n_cols":9,"rows_kept":99,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Maximum von förderfähig brutto",{"$nulls":5},"Maximum von förderfähig brutto"]
["Info Segment","E-Fahrzeug","Ergebnis",null,null,null,"Info Segment","E-Fahrzeug","Ergebnis"]
["Kleinwagen","BMW i3 (120Ah)",8500,null,null,null,"Kleinwagen","Renault Zoe Life (41 kWh)",18610]
[null,"BMW i3s (120Ah)",7250,null,null,null,"Kompaktklasse","Opel Ampera-E Plus",18375]
[null,"Mercedes Benz smart forfour electric drive (alle Versionen)",10775,null,null,null,"Mini","Volkswagen e-load up",12845]
[null,"Renault Zoe Life (22 kWh)",14410,null,null,null,"Mittelklasse","Kia Optima 2.0 GDI Plug-in Hybrid (Sportswagon)",12050]
[null,"Renault Zoe Life (22 kWh), Batterie zur Miete",6410,null,null,null,"Obere Mittelklasse","Volvo V90 T8 TWIN ENGINE AWD",12700]
[null,"Renault Zoe Life (41 kWh)",18610,null,null,null,"Utility (N1)","Volkswagen e-Crafter",48338]
[null,"Renault Zoe Life (41 kWh), Batterie zur Miete",10610,null,null,null,"Geländewagen / SUV","Jaguar I-Pace",21490]
["Kleinwagen Ergebnis",null,18610,null,null,null,"Oberklasse","Tesla Model S Maximal-Reichweite",18080]
["Kompaktklasse","BMW 225xe iPerformance Active Tourer"]
[null,"Hyundai IONIQ Elektro",10650]
[null,"Hyundai IONIQ Plug-in-Hybrid",7250]
[null,"Kia e-Niro 39,2 kWh",11200]
[null,"Kia e-Niro 64 kWh",15000]
[null,"Kia Niro Plug-in Hybrid",9660]
[null,"Nissan Leaf ZE1 (40 kwh)",18310]
[null,"Opel Ampera-E Plus",18375]
[null,"Toyota Prius Plug-In Hybrid (alle Ausstattungen)",13760]
[null,"Volkswagen e-Golf",12385]
[null,"Volkswagen Golf GTE (PHEV)",10630]
["Kompaktklasse Ergebnis",null,18375]
["Leichtfahrzeug","Renault Twizzy 45 - Life, Intens, Cargo (5PS)",4000]
[null,"Renault Twizzy Life - Intens, Cargo (18PS)",4000]
["Leichtfahrzeug Ergebnis",null,4000]
["Mini","Citroën C-Zero",11100]
[null,"Citroën E-Mehari",9780]
[null,"Ego-Life  20",5910]
[null,"Ego-Life  40",7410]
[null,"Ego-Life  60",9910]
[null,"Mercedes Benz smart fortwo ED (alle Versionen)",10325]
[null,"Peugeot iOn",9350]
[null,"Volkswagen e-load up",12845]
[null,"Volkswagen e-up",11140]
["Mini Ergebnis",null,12845]
["Mini-Van","Kia Soul EV",12250]
["Mini-Van Ergebnis",null,12250]
["Mittelklasse","Tesla Model 3 75D Long Range / Performance",11630]
[null,"Volvo V60 T8 TWIN ENGINE AWD",10600]
[null,"Kia Optima 2.0 GDI Plug-in Hybrid ",12050]
[null,"Volkswagen Passat GTE (PHEV)",11905]
["Mittelklasse Ergebnis",null,12050]
["Obere Mittelklasse","BMW 530e iPerformance",2900]
[null,"Volvo S90 T8 TWIN ENGINE AWD",12700]
[null,"Volvo V90 T8 TWIN ENGINE AWD",12700]
[null,"Mercedes Benz E 300 e",2023]
[null,"Mercedes Benz E 300 de",3201]
["Obere Mittelklasse Ergebnis",null,12700]
["Oberklasse","Tesla Model S Standart-Reichweite",13080]
[null,"Tesla Model S Maximal-Reichweite",18080]
[null,"Tesla Model S Standart-Reichweite (Einsatz als Taxi)",30161]
[null,"Tesla Model S Maximal-Reichweite (Einsatz als Taxi)",21471]
[null,"BMW 745e, Le (ohne xDrive)",12500]
[null,"BMW 745e, Le xDrive",0]
["Oberklasse Ergebnis",null,30161]
["Sportwagen","BMW i8 Roadster",2741]
[null,"BMW i8 Coupé",10021]
["Sportwagen Ergebnis",null,10021]
["Utility (N1)","Mercedes Benz eVito (alle Varianten)",31535]
[null,"Nissan e-NV200 Evalia 5-Sitzer",20143]
[null,"Nissan e-NV200 Evalia 7-Sitzer",19010]
[null,"Nissan e-NV200 Kasten",15839]
[null,"Peugeot Partner electrique (L1)",5892]
[null,"Peugeot Partner electrique (L2)",3880]
[null,"Piaggio Porter Elektro (alle Versionen)",12761]
[null,"Renault Kangoo Maxi Z.E. 33 2-Sitzer",14899]
[null,"Renault Kangoo Maxi Z.E. 33 2-Sitzer, Batterie zur Miete",4070]
[null,"Renault Kangoo Maxi Z.E. 33 5-Sitzer",14661]
[null,"Renault Kangoo Maxi Z.E. 33 5-Sitzer, Batterie zur Miete",3832]
[null,"Renault Kangoo Z.E. 33 2-Sitzer",18576]
[null,"Renault Kangoo Z.E. 33 2-Sitzer, Batterie zur Miete",7747]
[null,"Renault Kangoo Z.E. 33 Doppelkabine",14843]
[null,"Renault Kangoo Z.E. 33 Doppelkabine, Batterie zur Miete",4014]
[null,"Renault Master Z.E. Kasten (alle Versionen)",38604]
[null,"Renault Master Z.E. Plattform-FG (alle Versionen)",40317]
[null,"SAIC MAXUS EV 80 (Cargo Mobile)",30000]
[null,"Streetscooter Work 20 (alle Versionen)",24514]
[null,"Streetscooter Work 40 (alle Versionen)",30464]
[null,"Streetscooter Work L 40 (alle Versionen)",26370]
[null,"Streetscooter Work XL (alle Versionen)",40282]
[null,"Volkswagen e-Crafter",48338]
["Utility (N1) Ergebnis",null,48338]
["(Leer)","Porsche Cayenne S E-Hybrid",0]
[null,"Porsche Panamera 4 E-Hybrid (alle Versionen)",0]
[null,"Porsche Panamera Turbo S E-Hybrid (alle Versionen)",0]
["(Leer) Ergebnis",null,0]
["Geländewagen / SUV","Audi e-tron 55 Quattro",18850]
[null,"Hyundai Kona Elektro (alle Versionen)",14000]
[null,"Jaguar I-Pace",21490]
[null,"Land Rover Range Rover P400e Plug-in Hybrid"]
[null,"Land Rover Range Rover Sport P400e Plug-in Hybrid"]
[null,"Mitsubishi PLUG-IN HYBRID OUTLANDER",12100]
[null,"Volvo XC 60 T8 TWIN ENGINE"]
[null,"Volvo XC 90 T8 TWIN ENGINE AWD"]
[null,"Tesla Model X Maximal-Reichweite",12300]
["Geländewagen / SUV Ergebnis",null,21490]
["Gesamtergebnis",null,48338]

{"sheet":"Fahrzeuge","index":1,"n_rows":262,"n_cols":55,"rows_kept":262,"cut":false,"hidden":false,"merged":[[0,0,0,1],[5,0,5,11],[6,0,6,11],[9,0,9,11],[8,0,8,11],[7,0,7,11],[4,0,4,11]]}
["Antragsteller ist vorsteuerabzugsberechtigt [Auswahlbox]:",{"$nulls":4},"ja","nein","Stand: 09.09.2021",null,null,null,"FKZ"]
[{"$nulls":7},"korrigiert: 23.06.2021",null,null,null,"03EMIS1"]
["Hinweise:",{"$nulls":6},"ergänzt: 01.03.2022"]
["Mit dieser Tabelle können Sie die förderfähigen Ausgaben 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. Geben sie die zu erwartende durchschnittliche Jahresfahrleistung für jedes Modell ein (bei PHEV automatisch gedeckelt)"]
["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","erwartete durchschnittliche Jahres- Fahrleistung in km","anerkannte durchschnittliche elektrische Jahres-Fahrleistung in km","Förderfähige Ausgaben ","Korrekturfeld PtJ",{"$nulls":30},"Kommentar","E-Fahrzeug","PHEV","E-Listenpreis netto","E-Listenpreis brutto","Vergleichsfahrzeug","Listenpreis netto","Listenpreis brutto","förderfähig netto","förderfähig brutto","Info Segment","Fahrzeugklasse Abkürzung","ergänzt am:"]
[1,null,{"$f":"IF(B13>0,CONCATENATE(VLOOKUP(B13,N$37:X$262,10,0),\" (\",VLOOKUP(B13,N$37:X$262,11,0),\")\"),\"\")","v":""},{"$f":"IF($B13>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B13,$N$37:$V$262,4,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B13,$N$37:$V$262,3,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},{"$f":"IF($B13>0,VLOOKUP($B13,$N$37:$V$262,5,0),\"\")","v":""},{"$f":"IF($B13>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B13,$N$37:$V$262,7,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B13,$N$37:$V$262,6,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},{"$f":"IF(B13>0,IF($C$1=\"nein\",VLOOKUP($B13,$N$37:$V$262,9,0),IF($C$1=\"ja\",VLOOKUP($B13,$N$37:$V$262,8,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},null,null,{"$f":"IF($B13>0,IF(VLOOKUP($B13,$N$37:$V$262,2,FALSE)=\"x\",IF(I13>10000,10000,I13),I13),\"\")","v":""},{"$f":"IF(B13>0,G13*H13,\"\")","v":""},{"$nulls":32},"Aixam eCity",null,{"$f":"ROUND(AU13/1.19,2)","v":12092.44},14390,"Mercedes Benz smart 52 kW",{"$f":"ROUND(AX13/1.19,2)","v":9382.35},11165,{"$f":"ROUND(AT13-AW13,0)","v":2710},{"$f":"ROUND(AU13-AX13,0)","v":3225},"Leichtfahrzeug","LFZ",43913]
[{"$f":"A13+1","v":2},null,"",{"$f":"IF($B14>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B14,$N$37:$V$262,4,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B14,$N$37:$V$262,3,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B14>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B14,$N$37:$V$262,7,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B14,$N$37:$V$262,6,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,null,"","",{"$nulls":32},"Audi A3 e-tron",null,{"$f":"ROUND(AU14/1.19,2)","v":31848.74},37900,"Audi A3 Sportback Attraction",23949.58,28500,7899,9400,"Kompaktklasse","PKW"]
[{"$f":"A14+1","v":3},null,"",{"$f":"IF($B15>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B15,$N$37:$V$262,4,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B15,$N$37:$V$262,3,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B15>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B15,$N$37:$V$262,7,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B15,$N$37:$V$262,6,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,null,"","",{"$nulls":32},"Audi e-tron 50 Quattro",null,{"$f":"ROUND(AU15/1.19,2)","v":58067.23},69100,"Audi A6 allroad quattro 3.0 TDI 200kW",51302.52,61050,6765,8050,"Geländewagen / SUV","PKW",43913]
[{"$f":"A15+1","v":4},null,"",{"$f":"IF($B16>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B16,$N$37:$V$262,4,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B16,$N$37:$V$262,3,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B16>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B16,$N$37:$V$262,7,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B16,$N$37:$V$262,6,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,null,"","",{"$nulls":32},"Audi e-tron 55 Quattro",null,{"$f":"ROUND(AU16/1.19,2)","v":67142.86},79900,"Audi A6 allroad quattro 3.0 TDI 200kW",51302.52,61050,15840,18850,"Geländewagen / SUV","PKW"]
[{"$f":"A16+1","v":5},null,"",{"$f":"IF($B17>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B17,$N$37:$V$262,4,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B17,$N$37:$V$262,3,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B17>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B17,$N$37:$V$262,7,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B17,$N$37:$V$262,6,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,null,"","",{"$nulls":32},"Audi Q5 TFSI e quattro","x",70101.679999999993,79753.36,"Audi Q5 sport 45 TFSI quattro",45378.15,54000,24724,25753,"Geländewagen / SUV","PKW"]
[{"$f":"A17+1","v":6},null,"",{"$f":"IF($B18>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B18,$N$37:$V$262,4,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B18,$N$37:$V$262,3,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B18>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B18,$N$37:$V$262,7,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B18,$N$37:$V$262,6,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,null,"","",{"$nulls":31},"jetzt 120Ah statt 94Ah","BMW i3 (42,2 kWh, 37,9 kWh nutzbar)",null,44067.23,50134.46,"BMW 218 i Active Tourer",24789.919999999998,29500,19277,20634,"Kleinwagen","PKW"]
[7,null,"",{"$f":"IF($B19>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B19,$N$37:$V$262,4,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B19,$N$37:$V$262,3,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B19>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B19,$N$37:$V$262,7,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B19,$N$37:$V$262,6,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,null,"","",{"$nulls":31},"jetzt 120Ah statt 94Ah","BMW i3s (42,2 kWh, 37,9 kWh nutzbar)",null,48242.02,54884.04,"BMW 218 i Active Tourer Sport Line",28865.55,34350,19376,20534,"Kleinwagen","PKW"]
[8,null,"",{"$f":"IF($B20>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B20,$N$37:$V$262,4,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B20,$N$37:$V$262,3,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B20>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B20,$N$37:$V$262,7,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B20,$N$37:$V$262,6,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,null,"","",{"$nulls":31},"46g CO2 /km; 40 km e-Reichweite","BMW i8 Roadster","x",{"$f":"ROUND(AU20/1.19,2)","v":130252.1},155000,"Porsche 911 Carrera 4S Cabrio",127948.74,152259,2303,2741,"Sportwagen","PKW"]
[{"$f":"A20+1","v":9},null,"",{"$f":"IF($B21>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B21,$N$37:$V$262,4,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B21,$N$37:$V$262,3,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B21>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B21,$N$37:$V$262,7,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B21,$N$37:$V$262,6,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,null,"","",{"$nulls":31},"42g CO2 /km; 40 km e-Reichweite","BMW i8 Coupé","x",{"$f":"ROUND(AU21/1.19,2)","v":115966.39},138000,"Porsche 911 Carrera 4S",107545.38,127979,8421,10021,"Sportwagen","PKW"]
[10,null,"",{"$f":"IF($B22>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B22,$N$37:$V$262,4,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B22,$N$37:$V$262,3,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B22>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B22,$N$37:$V$262,7,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B22,$N$37:$V$262,6,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,null,"","",{"$nulls":31},"52g CO2 /km; 41km e-Reichweite","BMW 225xe iPerformance Active Tourer (8,8 kWh)","x",45980.67,52311.34,"BMW 220i Active Tourer",40704.199999999997,46308.4,5276,6003,"Kompaktklasse","PKW"]
[11,null,"",{"$f":"IF($B23>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B23,$N$37:$V$262,4,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B23,$N$37:$V$262,3,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B23>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B23,$N$37:$V$262,7,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B23,$N$37:$V$262,6,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,null,"","",{"$nulls":31},"NEFZ Zyklus","BMW 330e Advantage (10,8 kWh)","x",59780.67,68011.34,"BMW 330i Advantage",51894.96,59039.92,{"$f":"ROUND(AT23-AW23,0)","v":7886},8971,"Mittelklasse","PKW"]
[12,null,"",{"$f":"IF($B24>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B24,$N$37:$V$262,4,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B24,$N$37:$V$262,3,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B24>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B24,$N$37:$V$262,7,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B24,$N$37:$V$262,6,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,null,"","",{"$nulls":31},"47g CO2 /km; 48 km e-Reichweite","BMW 530e iPerformance","x",{"$f":"ROUND(AU24/1.19,2)","v":47058.82},56000,"BMW 530i",{"$f":"ROUND(AX24/1.19,2)","v":44621.85},53100,2437,2900,"Obere Mittelklasse","PKW"]
[{"$f":"A24+1","v":13},null,"",{"$f":"IF($B25>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B25,$N$37:$V$262,4,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B25,$N$37:$V$262,3,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B25>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B25,$N$37:$V$262,7,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B25,$N$37:$V$262,6,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,null,"","",{"$nulls":31},"49g CO2 /kmBMW 740i nicht mehr verfügbar(?)","BMW 745e, Le (ohne xDrive)","x",{"$f":"ROUND(AU25/1.19,2)","v":89411.76},106400,"BMW 730 Ld",78907.56,93900,10504,12500,"Oberklasse","PKW"]
[14,null,"",{"$f":"IF($B26>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B26,$N$37:$V$262,4,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B26,$N$37:$V$262,3,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B26>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B26,$N$37:$V$262,7,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B26,$N$37:$V$262,6,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,null,"","",{"$nulls":31},">50g CO2 /km","BMW 745e, Le xDrive","x","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL",null,0,0,null,null,"Oberklasse","PKW"]
[15,null,"",{"$f":"IF($B27>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B27,$N$37:$V$262,4,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B27,$N$37:$V$262,3,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B27>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B27,$N$37:$V$262,7,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B27,$N$37:$V$262,6,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,null,"","",{"$nulls":31},"43g CO2/km; 57 km e-Reichw.","BMW X1 xDrive (alle Modelle)","x",{"$f":"ROUND(AU27/1.19,2)","v":38361.339999999997},45650,"BMW X1 sDrive 18i",29075.63,34600,{"$f":"ROUND(AT27-AW27,0)","v":9286},11050,"Geländewagen / SUV","PKW"]
[16,null,"",{"$f":"IF($B28>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B28,$N$37:$V$262,4,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B28,$N$37:$V$262,3,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B28>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B28,$N$37:$V$262,7,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B28,$N$37:$V$262,6,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,null,"","",{"$nulls":31},"48-54g CO2/km; 51-55 km e-Reichw.","BMW X3 xDrive (alle Modelle)","x",{"$f":"ROUND(AU28/1.19,2)","v":48235.29},57400,"BMW X3 xDrive 20i",39915.97,47500,8319,9900,"Geländewagen / SUV","PKW"]
[{"$f":"A28+1","v":17},null,"",{"$f":"IF($B29>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B29,$N$37:$V$262,4,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B29,$N$37:$V$262,3,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B29>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B29,$N$37:$V$262,7,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B29,$N$37:$V$262,6,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,null,"","",{"$nulls":31},"Citroën C1 Vti 68 (5 Türer) nicht mehr erhältlich","Citroën DS 7 CROSSBACK E-TENSE 4x4 be chic","x",{"$f":"ROUND(AU29/1.19,2)","v":42260.5},50290,"Citroën DS 7 CROSSBACK PureTech 225 Automatik 226",35159.660000000003,41840,7101,8450,"Geländewagen / SUV","PKW"]
[{"$f":"A29+1","v":18},null,"",{"$f":"IF($B30>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B30,$N$37:$V$262,4,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B30,$N$37:$V$262,3,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B30>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B30,$N$37:$V$262,7,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B30,$N$37:$V$262,6,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,null,"","",{"$nulls":32},"Citroën E-Mehari",null,{"$f":"ROUND(AU30/1.19,2)","v":21235.29},25270,"Fiat 500c",13016.81,15490,8218,9780,"Mini","PKW"]
[{"$f":"A30+1","v":19},null,"",{"$f":"IF($B31>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B31,$N$37:$V$262,4,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B31,$N$37:$V$262,3,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B31>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B31,$N$37:$V$262,7,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B31,$N$37:$V$262,6,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,null,"","",{"$nulls":32},"Citroën C-Zero",null,18319.330000000002,21800,"Citroën C1 Vti 72 Live (5 Türer)",8991.6,10700,9328,11100,"Mini","PKW"]
[{"$f":"A31+1","v":20},null,"",{"$f":"IF($B32>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B32,$N$37:$V$262,4,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B32,$N$37:$V$262,3,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",{"$f":"IF($B32>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B32,$N$37:$V$262,7,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B32,$N$37:$V$262,6,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},"",null,null,"","",{"$nulls":32},"DS3 Crossback E-Tense",null,32260.5,38390,"DS3 Crossback PureTech 130 So Chic (N)",24781.51,29490,7479,8900,"Geländewagen / SUV","PKW",43913]
["Summe",null,null,null,{"$f":"IF($B33>0,VLOOKUP($B33,$N$42:$V$262,5,0),\"\")","v":""},null,{"$f":"IF(B33>0,IF($C$1=\"nein\",VLOOKUP($B33,$N$42:$V$262,9,0),IF($C$1=\"ja\",VLOOKUP($B33,$N$42:$V$262,8,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},null,null,{"$f":"IF($B33>0,IF(VLOOKUP($B33,$N$42:$V$262,2,FALSE)=\"x\",IF(I33>10000,10000,I33),I33),\"\")","v":""},{"$f":"SUM(K13:K32)","v":0},{"$nulls":31},"26g CO2 /km","Ego-Life  20",null,13361.34,15900,"Hyundai i10",8394.9599999999991,9990,{"$f":"ROUND(AT33-AW33,0)","v":4966},{"$f":"ROUND(AU33-AX33,0)","v":5910},"Mini","PKW"]
[{"$nulls":43},"Ego-Life  40",null,14621.85,17400,"Hyundai i10",8394.9599999999991,9990,6227,7410,"Mini","PKW"]
["*","Bei Beantragung von Fahrzeugsegmenten erfolgt die Abrechnung nach den Pauschalwerten des tatsächlich beschafften Fahrzeugs!",{"$nulls":7},{"$f":"IF($H13>0,\"Durchschnittswert anerkannte Jahresfahrleistung: \",\"\")","v":""},{"$f":"IF(H13>0,(SUMPRODUCT(H13:H32,J13:J32)/SUM(H13:H32)),\"\")","v":""},{"$nulls":32},"Ego-Life  60",null,16722.689999999999,19900,"Hyundai i10",8394.9599999999991,9990,8328,9910,"Mini","PKW"]
[{"$nulls":13},"E-Fahrzeug","PHEV","E-Listenpreis netto","E-Listenpreis brutto","Vergleichsfahrzeug","Listenpreis netto","Listenpreis brutto","förderfähig netto","förderfähig brutto","Info Segment","Fahrzeugklasse Abkürzung","Kommentar","ergänzt am:",{"$nulls":17},"Ford Kuga  2,5 L Duratec PHEV Titanium","x",33025.21,39300,"Ford Kuga  1,5 L EcoBoost Titanium",26806.720000000001,31900,6218,7400,"Geländewagen / SUV","PKW"]
[{"$nulls":13},"AIWAYS U5 (alle Versionen)",null,{"$f":"(35403+3000)/1.19","v":32271.428571428572},{"$f":"ROUND(P37*1.19,2)","v":38403},"VW Tiguan Life 1.5 TSI OPF  Gang 110 kW",{"$f":"ROUND(29901.68/1.16,2)","v":25777.31},{"$f":"ROUND(S37*1.19,2)","v":30675},{"$f":"ROUND(P37-S37,0)","v":6494},{"$f":"ROUND(Q37-T37,0)","v":7728},"Geländewagen / SUV","PKW",null,"2021-06-22"]
[{"$nulls":13},"Aixam eCity",null,{"$f":"ROUND(Q38/1.19,2)","v":12092.44},14390,"Mercedes Benz smart 52 kW",{"$f":"ROUND(T38/1.19,2)","v":9382.35},11165,{"$f":"ROUND(P38-S38,0)","v":2710},{"$f":"ROUND(Q38-T38,0)","v":3225},"Leichtfahrzeug","LFZ",null,"2020-03-23",{"$nulls":17},"Ford Tourneo Custom Bus (PHEV)","x",{"$f":"ROUND(AU38/1.19,2)","v":60420},71899.8,"Ford Tourneo Custom Bus Titanium (130 PS, Automatik)",{"$f":"ROUND(AX38/1.19,2)","v":42170},50182.3,{"$f":"ROUND(AT38-AW38,0)","v":18250},{"$f":"ROUND(AU38-AX38,0)","v":21718},"Utility (N1)","NFZ"]
[{"$nulls":13},"Audi A3 e-tron",null,{"$f":"ROUND(Q39/1.19,2)","v":31848.74},37900,"Audi A3 Sportback Attraction",{"$f":"ROUND(T39/1.19,2)","v":23949.58},28500,{"$f":"ROUND(P39-S39,0)","v":7899},{"$f":"ROUND(Q39-T39,0)","v":9400},"Kompaktklasse","PKW",{"$nulls":19},"Ford Transit Custom Kombi PKW (PHEV)","x",52805,62837.95,"Ford Transit Custom Kombi PKW (130 PS, Automatik)",35505,42250.95,17300,20587,"Utility (N1)","NFZ"]
[{"$nulls":13},"Audi A3 Sportback 40 TFSIe (alle Varianten)","x",32302.52,{"$f":"ROUND(P40*1.19,2)","v":38440},"A3 Sportback 35 TFSI 6-Gang 110 kW",24285.71,{"$f":"ROUNDUP(S40*1.19,2)","v":28900},8017,9540,"Kompaktklasse","PKW",null,"2020-12-17"]
[{"$nulls":13},"Audi e-tron 50 Quattro",null,58067.23,69100,"Audi A6 allroad quattro 3.0 TDI 200kW",51302.52,61050,6765,8050,"Geländewagen / SUV","PKW",null,"2020-03-23",{"$nulls":17},"Ford Transit Custom Kastenwagen LKW  (PHEV)","x","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL","Ford Transit Custom Kastenwagen LKW ",{"$nulls":4},"Utility (N1)","NFZ"]
[{"$nulls":13},"Audi e-tron 55 Quattro",null,67142.86,79900,"Audi A6 allroad quattro 3.0 TDI 200kW",51302.52,61050,15840,18850,"Geländewagen / SUV","PKW",{"$nulls":19},"Honda e",null,{"$f":"ROUND(AU42/1.19,2)","v":28445.38},33850,"Honda Jazz Trend",{"$f":"ROUND(AX42/1.19,2)","v":14529.41},17290,{"$f":"ROUND(AT42-AW42,0)","v":13916},{"$f":"ROUND(AU42-AX42,0)","v":16560},"Kleinwagen","PKW",43913]
[{"$nulls":13},"Audi Q4 e-tron 55 kWh (alle Versionen)",null,35210.080000000002,{"$f":"ROUND(P43*1.19,2)","v":41900},"Audi Q3 35 TFSI 6-Gang 110 kW",30294.12,{"$f":"ROUND(S43*1.19,2)","v":36050},{"$f":"ROUND(P43-S43,0)","v":4916},{"$f":"ROUND(Q43-T43,0)","v":5850},"Geländewagen / SUV","PKW",null,"2021-09-07"]
[{"$nulls":13},"Audi Q4 e-tron 82 kWh (alle Versionen)",null,39915.97,{"$f":"ROUND(P44*1.19,2)","v":47500},"Audi Q3 35 TFSI 6-Gang 110 kW",30294.12,{"$f":"ROUND(S44*1.19,2)","v":36050},{"$f":"ROUND(P44-S44,0)","v":9622},{"$f":"ROUND(Q44-T44,0)","v":11450},"Geländewagen / SUV","PKW",null,"2021-09-07"]
[{"$nulls":13},"Audi Q5 TFSI e quattro","x",50798.32,60450,"Audi Q5 sport 45 TFSI quattro",45378.15,54000,5420,6450,"Geländewagen / SUV","PKW",{"$nulls":19},"Hyundai IONIQ Plug-in-Hybrid","x",25126.05,29900,"Hyundai i30 5T 1.4 T­GDI, 6­Gang, 103 kW",19033.61,22650,{"$f":"ROUND(AT45-AW45,0)","v":6092},{"$f":"ROUND(AU45-AX45,0)","v":7250},"Kompaktklasse","PKW"]
[{"$nulls":13},"BMW 225xe iPerformance Active Tourer (8,8 kWh)","x",33319.33,39650,"BMW 220i Active Tourer",29495.8,35100,3824,4550,"Kompaktklasse","PKW",{"$nulls":18},"29g CO2 /km 58km e-Reichweite Kia Ceed in der Variante Dream-Team nicht gefunden","Hyundai IONIQ Elektro",null,27983.19,33300,"Hyundai i30 5T 1.4 T­GDI, 6­Gang, 103 kW",19033.61,22650,8950,10650,"Kompaktklasse","PKW"]
[{"$nulls":13},"BMW 330e Advantage (10,8 kWh)","x",43319.33,51550,"BMW 330i Advantage (G20)",37605.040000000001,44750,5714,6800,"Mittelklasse","PKW",{"$nulls":19},"Hyundai Kona Elektro (alle Versionen)",null,29075.63,34600,"Hyundai Kona",17310.919999999998,20600,11765,14000,"Geländewagen / SUV","PKW"]
[{"$nulls":13},"BMW 530e iPerformance","x",47058.82,56000,"BMW 530i",44621.85,53100,2437,2900,"Obere Mittelklasse","PKW",{"$nulls":19},"ISEKI Goupil G4 (9 kWh)",null,29881.51,35559,"Piaggio Porter Chassis",13193.28,15700,16688,19859,"Utility (N1)","NFZ",43913]
[{"$nulls":13},"BMW 745e, Le (ohne xDrive)","x",89411.76,106400,"BMW 730 Ld",78907.56,93900,10504,12500,"Oberklasse","PKW",{"$nulls":19},"ISEKI Goupil G4 (13,8 kWh)",null,33663.03,40059,"Piaggio Porter Chassis",13193.28,15700,20470,24359,"Utility (N1)","NFZ",43913]
[{"$nulls":13},"BMW 745e, Le xDrive","x","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL",null,0,0,null,null,"Oberklasse","PKW",{"$nulls":19},"ISEKI Goupil G5 (11,5 kWh)",null,34967.230000000003,41611,"Piaggio Porter Chassis",13193.28,15700,21774,25911,"Utility (N1)","NFZ",43913]
[{"$nulls":13},"BMW i3 (42,2 kWh, 37,9 kWh nutzbar)",null,{"$f":"ROUND(Q51/1.19,2)","v":31932.77},38000,"BMW 218 i Active Tourer",24789.919999999998,29500,{"$f":"ROUND(P51-S51,0)","v":7143},{"$f":"ROUND(Q51-T51,0)","v":8500},"Kleinwagen","PKW",{"$nulls":19},"ISEKI Goupil G5 (19,2 kWh)",null,44294.96,52711,"Piaggio Porter Chassis",13193.28,15700,31102,37011,"Utility (N1)","NFZ",43913]
[{"$nulls":13},"BMW i3s (42,2 kWh, 37,9 kWh nutzbar)",null,34957.980000000003,41600,"BMW 218 i Active Tourer Sport Line",28865.55,34350,6092,7250,"Kleinwagen","PKW",{"$nulls":19},"Jaguar I-Pace",null,65747.899999999994,78240,"Jaguar F-Pace 30t AWD",47689.08,56750,18059,21490,"Geländewagen / SUV","PKW"]
[{"$nulls":13},"BMW i8 Coupé","x",115966.39,138000,"Porsche 911 Carrera 4S",107545.38,127979,8421,10021,"Sportwagen","PKW",{"$nulls":18},"33g CO2 /km 62km e-Reichweite","Kia Soul EV",null,24781.51,29490,"Kia Soul",14487.39,17240,10294,12250,"Mini-Van","PKW"]
[{"$nulls":13},"BMW i8 Roadster","x",130252.1,155000,"Porsche 911 Carrera 4S Cabrio",127948.74,152259,2303,2741,"Sportwagen","PKW",{"$nulls":19},"Kia Niro Plug-in Hybrid","x",{"$f":"ROUND(AU54/1.19,0)","v":27521},32750,"Kia Ceed SW 1.4 T-GDI ",{"$f":"ROUND(AX54/1.19,0)","v":19403},23090,8118,9660,"Kompaktklasse","PKW"]
[{"$nulls":13},"BMW iX3 (210 KW)",null,54159.66,{"$f":"ROUND(P55*1.19,2)","v":64450},"BMW X3 xDrive30i",{"$f":"ROUND(53028.56/1.16,2)","v":45714.28},{"$f":"ROUNDUP(S55*1.19,2)","v":54400},8445,{"$f":"ROUND(Q55-T55,0)","v":10050},"Geländewagen / SUV","PKW",null,"2020-12-17"]
[{"$nulls":13},"BMW X1 xDrive25e (alle Modelle)","x",38361.339999999997,45650,"BMW X1 xDrive 20i",35210.080000000002,41900,3151,3750,"Geländewagen / SUV","PKW",{"$nulls":19},"Kia e-Niro 39,2 kWh",null,{"$f":"ROUND(AU56/1.19,0)","v":28815},34290,"Kia Ceed SW 1.4 T-GDI ",{"$f":"ROUND(AX56/1.19,0)","v":19403},23090,9412,{"$f":"ROUND(AU56-AX56,0)","v":11200},"Kompaktklasse","PKW"]
[{"$nulls":13},"BMW X3 xDrive30e (alle Modelle)","x",48235.29,57400,"BMW X3 xDrive 30i",45714.29,54400,2521,3000,"Geländewagen / SUV","PKW",{"$nulls":18},">70g CO2/km 48km e-Reichweite","Kia e-Niro 64 kWh",null,{"$f":"ROUND(AU57/1.19,0)","v":32008},38090,"Kia Ceed SW 1.4 T-GDI ",{"$f":"ROUND(AX57/1.19,0)","v":19403},23090,12605,{"$f":"ROUND(AU57-AX57,0)","v":15000},"Kompaktklasse","PKW"]
[{"$nulls":13},"CITROËN Berlingo Electric L1",null,{"$f":"ROUND(Q58/1.19,2)","v":20990},24978.1,"Citroën Berlingo L1",{"$f":"ROUND(T58/1.19,2)","v":14500},17255,{"$f":"ROUND(P58-S58,0)","v":6490},7723,"Utility (N1)","NFZ","2021-06-23"]
[{"$nulls":13},"CITROËN Berlingo Electric L1, Batterie zur Miete",null,15690,18671.099999999999,"Citroën Berlingo L1",14500,17255,1190,1416,"Utility (N1)","NFZ",{"$nulls":19},">70g CO2/km 48km e-Reichweite","Kia Optima 2.0 GDI Plug-in Hybrid ","x",{"$f":"ROUND(AV59/1.19,2)","v":34235.29},40740,"Kia Optima 2.0 CVVL",{"$f":"ROUND(AY59/1.19,2)","v":24109.24},28690,10126,{"$f":"ROUND(AV59-AY59,0)","v":12050},"Mittelklasse","PKW"]
[{"$nulls":13},"CITROËN Berlingo Electric L2",null,22040,26227.599999999999,"Citroën Berlingo L2",15350,18266.5,6690,7961,"Utility (N1)","NFZ"]
[{"$nulls":13},"CITROËN Berlingo Electric L2, Batterie zur Miete",null,16740,19920.599999999999,"Citroën Berlingo L2",15350,18266.5,1390,1654,"Utility (N1)","NFZ","aus EMIN_EFA, 20.08.2020",{"$nulls":19},"Land Rover Range Rover Sport P400e Plug-in Hybrid","x","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL","Land Rover Range Rover Sport 3.0 TDV7",{"$nulls":4},"Geländewagen / SUV","PKW"]
[{"$nulls":13},"CITROËN ë-Berlingo (alle Versionen)",null,{"$f":"ROUND(36590/1.19,2)","v":30747.9},{"$f":"ROUND(P62*1.19,2)","v":36590},"Citroën Berlingo Feel 81 kW",{"$f":"ROUND(23740/1.19,2)","v":19949.580000000002},{"$f":"S62*1.19","v":23740.000200000002},10798,12850,"Großraum-Van","PKW",null,"aus EMIN_EFA, 20.08.2020",{"$nulls":17},"Land Rover Range Rover P400e Plug-in Hybrid","x","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL","Land Rover Range Rover 3.0 TDV7",{"$nulls":4},"Geländewagen / SUV","PKW"]
[{"$nulls":13},"CITROËN C-Zero",null,18319.330000000002,21800,"Citroën C1 Vti 72 Live (5 Türer)",8991.6,10700,9328,11100,"Mini","PKW",null,"2021-01-10"]
[{"$nulls":13},"CITROËN DS 7 CROSSBACK E-TENSE 4x4 be chic","x",42260.5,50290,"Citroën DS 7 CROSSBACK PureTech 225 Automatik 225",35159.660000000003,41840,7101,8450,"Geländewagen / SUV","PKW",null,"2021-01-10"]
[{"$nulls":13},"CITROËN E-JUMPY M 50kWh ",null,35250,{"$f":"ROUND(P65*1.19,2)","v":41947.5},"Citroën E-JUMPY M Blue HDi 120 90 kW",26500,{"$f":"ROUND(S65*1.19,2)","v":31535},8750,10413,"Utility (N1)","NFZ",{"$nulls":19},"Mercedes Benz smart fortwo ED (alle Versionen)",null,{"$f":"ROUND(AU65/1.19,2)","v":18436.97},21940,"Mercedes Benz smart 52 kW",{"$f":"ROUND(AX65/1.19,2)","v":9382.35},11165,{"$f":"ROUND(AT65-AW65,0)","v":9055},{"$f":"ROUND(AU65-AX65,0)","v":10775},"Mini","PKW"]
[{"$nulls":13},"CITROËN E-JUMPY M 75kWh",null,40250,{"$f":"ROUND(P66*1.19,2)","v":47897.5},"Citroën E-JUMPY M Blue HDi 120 90 kW",26500,{"$f":"ROUND(S66*1.19,2)","v":31535},13750,16363,"Utility (N1)","NFZ",null,"2020-12-17"]
[{"$nulls":13},"CITROËN ë-SpaceTourer 50kWh (alle Varianten)",null,{"$f":"ROUND(51440/1.19,2)","v":43226.89},{"$f":"P67*1.19","v":51439.999099999994},"CITROËN SpaceTourer M BlueHDi 145 (Business)",{"$f":"ROUND(39340/1.19,2)","v":33058.82},{"$f":"S67*1.19","v":39339.995799999997},10168,12100,"Großraum-Van","PKW",null,"2020-03-23",{"$nulls":17},"Mercedes Benz smart forfour electric drive (alle Versionen)",null,{"$f":"ROUND(AU67/1.19,2)","v":18991.599999999999},22600,"Mercedes Benz smart forfour 52 kW",{"$f":"ROUND(AX67/1.19,2)","v":9936.9699999999993},11825,9055,10775,"Kleinwagen","PKW"]
[{"$nulls":13},"CITROËN ë-SpaceTourer 75kWh (alle Varianten)",null,{"$f":"ROUND(57440/1.19,2)","v":48268.91},{"$f":"P68*1.19","v":57440.002899999999},"CITROËN SpaceTourer M BlueHDi 145 (Business)",{"$f":"ROUND(39340/1.19,2)","v":33058.82},{"$f":"S68*1.19","v":39339.995799999997},15210,18100,"Großraum-Van","PKW",{"$nulls":18},"39 - 41 CO2/km (NEFZ)","Mercedes Benz A 250 e ",null,42842.1,48740.65,"Mercedes Benz A 201",35666.1,40576.65,7176,8164,"Kompaktklasse","PKW"]
[{"$nulls":13},"CITROËN E-Mehari",null,{"$f":"ROUND(Q69/1.19,2)","v":21235.29},25270,"Fiat 500c",{"$f":"ROUND(T69/1.19,2)","v":13016.81},15490,8218,9780,"Mini","PKW"]
[{"$nulls":13},"CITROËN e-C4 Feel",null,{"$f":"34640/1.19","v":29109.243697478993},{"$f":"ROUND(P70*1.19,2)","v":34640},"CITROËN C4 PureTech 130 6-Gang",{"$f":"23940/1.19","v":20117.647058823532},{"$f":"ROUNDUP(S70*1.19,2)","v":23940},8992,{"$f":"ROUND(Q70-T70,0)","v":10700},"Kompaktklasse","PKW",{"$nulls":18},"40 - 42 CO2/km (NEFZ)","Mercedes Benz A 250 e (Limousine)",null,43256.1,49211.65,"Mercedes Benz A 200 (Limousine)",36080.1,41047.65,7176,8164,"Kompaktklasse","PKW"]
[{"$nulls":13},"CITROËN DS3 Crossback E-Tense",null,{"$f":"ROUND(Q71/1.19,2)","v":32260.5},38390,"DS3 Crossback PureTech 130 So Chic (N)",{"$f":"ROUND(T71/1.19,2)","v":24781.51},29490,7479,8900,"Geländewagen / SUV","PKW",null,"aus EMIN_EFA, 20.08.2020",{"$nulls":16},"46 g CO2 /km (NEFZ)","Mercedes Benz C 300 de","x",56945.7,64786.05,"Mercedes Benz C 300 d",53909.7,61332.05,3036,3454,"Obere Mittelklasse","PKW"]
[{"$nulls":13},"e.GO-Life  20",null,{"$f":"ROUND(Q72/1.19,2)","v":13361.34},15900,"Hyundai i10",{"$f":"ROUND(T72/1.19,2)","v":8394.9599999999991},9990,4966,5910,"Mini","PKW",null,"2020-12-17"]
[{"$nulls":13},"e.GO-Life  40",null,{"$f":"ROUND(Q73/1.19,2)","v":14621.85},17400,"Hyundai i10",{"$f":"ROUND(T73/1.19,2)","v":8394.9599999999991},9990,6227,7410,"Mini","PKW",null,"2020-12-17"]
[{"$nulls":13},"e.GO-Life  60",null,{"$f":"ROUND(Q74/1.19,2)","v":16722.689999999999},19900,"Hyundai i10",{"$f":"ROUND(T74/1.19,2)","v":8394.9599999999991},9990,8328,9910,"Mini","PKW",null,"aus EMIN_EFA, 13.08.2020",{"$nulls":16},"41 g CO2 /km (NEFZ)","Mercedes Benz C 300 de (T-Modell)","x",58877.7,66984.05,"Mercedes Benz C 300 d (T-Modell)",55841.7,63530.05,3036,3454,"Obere Mittelklasse","PKW"]
[{"$nulls":13},"EVUM aCar (alle Varianten)",null,28990,{"$f":"ROUND(P75*1.19,2)","v":34498.1},"Piaggio Porter Maxxi Chassis",16302.52,{"$f":"ROUND(S75*1.19,2)","v":19400},12687,15098,"Utility","NFZ",null,"aus EMIN_EFA, 13.08.2020",{"$nulls":16},"Preisliste zu Vito noch nicht online.\nFolgt laut Mercedes in Kürze (Stand: 15.03.2019), solange gilt der alte Preis","Mercedes Benz E 300 e","x",{"$f":"ROUND(AU75/1.19,2)","v":46300},55097,"Mercedes Benz E 301",{"$f":"ROUND(AX75/1.19,2)","v":44600},53074,1700,2023,"Obere Mittelklasse","PKW"]
[{"$nulls":13},"Fiat 500 Action 23,8 kWh",null,{"$f":"23560/1.19","v":19798.319327731093},{"$f":"ROUND(P76*1.19,2)","v":23560},"Fiat 500 LOUNGE",{"$f":"15684.37/1.16","v":13521.008620689658},{"$f":"ROUND(S76*1.19,2)","v":16090},6277,7470,"Kleinwagen","PKW",{"$nulls":19},"Mercedes Benz E 300 de (T-Modell)","x",67758,77087,"Mercedes Benz E 300 d (T-Modell)",64494.3,73373.95,3264,3713,"Obere Mittelklasse","PKW"]
[{"$nulls":13},"Fiat 500 Passion 42,0 kWh",null,{"$f":"27560/1.19","v":23159.663865546219},{"$f":"ROUND(P77*1.19,2)","v":27560},"Fiat 500 LOUNGE",{"$f":"15684.37/1.16","v":13521.008620689658},{"$f":"ROUND(S77*1.19,2)","v":16090},9639,11470,"Kleinwagen","PKW",{"$nulls":19},"Mercedes Benz eVito (alle Varianten)",null,{"$f":"ROUND(AU77/1.19,2)","v":44990},53538.1,"Mercedes Benz Vito Kastenwagen Worker",25516.2,29029.3,{"$f":"ROUND(AT77-AW77,0)","v":19474},24509,"Utility (N1)","NFZ"]
[{"$nulls":13},"Fiat E-Ducato 47 kWh (alle Versionen)",null,56000,{"$f":"ROUND(P78*1.19,2)","v":66640},"Fiat Ducato 88 KW",30840,{"$f":"ROUND(S78*1.19,2)","v":36699.599999999999},25160,29940,"Utility (N1)","NFZ",{"$nulls":18},"40g CO2 /km 54 km e-Reichweite","Mercedes Benz EQC 400 4MATIC",null,82662,94043,"Mercedes Benz GLC 300 4MATIC",62141.4,70697.100000000006,{"$f":"ROUND(AT78-AW78,0)","v":20521},23346,"Geländewagen / SUV","PKW"]
[{"$nulls":13},"Fiat E-Ducato 79 kWh (alle Versionen)",null,73000,{"$f":"ROUND(P79*1.19,2)","v":86870},"Fiat Ducato 88 KW",30840,{"$f":"ROUND(S79*1.19,2)","v":36699.599999999999},42160,50170,"Utility (N1)","NFZ",{"$nulls":19},"Mini Cooper SE 3-Türer Trim S",null,{"$f":"ROUND(AU79/1.19,2)","v":27310.92},32500,"Mini Cooper S 3-Türer",{"$f":"ROUND(AX79/1.19,2)","v":24327.73},28950,{"$f":"ROUND(AT79-AW79,0)","v":2983},3550,"Kleinwagen","PKW"]
[{"$nulls":13},"Ford Kuga  2,5 L Duratec PHEV Titanium","x",{"$f":"ROUND(Q80/1.19,2)","v":33025.21},39300,"Ford Kuga  1,5 L EcoBoost Titanium",{"$f":"ROUND(T80/1.19,2)","v":26806.720000000001},31900,6218,7400,"Geländewagen / SUV","PKW",null,"2020-12-17"]
[{"$nulls":13},"Ford Tourneo Custom Bus (PHEV)","x",{"$f":"ROUND(Q81/1.19,2)","v":60420},71899.8,"Ford Tourneo Custom Bus Titanium (130 PS, Automatik)",{"$f":"ROUND(T81/1.19,2)","v":42170},50182.3,18250,21718,"Großraum-Van","PKW",null,"2020-12-17"]
[{"$nulls":13},"Ford e-Transit (alle N1/N2 -Versionen)",null,57920,{"$f":"ROUND(P82*1.19,2)","v":68924.800000000003},"Ford Transit (gleiche Nutzlast + Radstand)",37720,{"$f":"ROUND(S82*1.19,2)","v":44886.8},{"$f":"ROUND(P82-S82,0)","v":20200},{"$f":"ROUND(Q82-T82,0)","v":24038},"Utility","NFZ","Mittelwert aus allen verfügbaren Modellen mit vorhandenem VGL-Fzg. Bei 4,25t-Variante fehlt vergleichbarer Verbrenner","2022-03-01"]
[{"$nulls":13},"Ford Transit Custom Kastenwagen LKW  (PHEV)","x","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL","Ford Transit Custom Kastenwagen LKW ",{"$nulls":4},"Utility (N1)","NFZ",null,"2020-03-23",{"$nulls":17},"Mitsubishi PLUG-IN HYBRID OUTLANDER","x",{"$f":"ROUND(AU83/1.19,2)","v":31924.37},37990,"Mitsubishi Outlander",{"$f":"ROUND(AX83/1.19,2)","v":21756.3},25890,{"$f":"ROUND(AT83-AW83,0)","v":10168},12100,"Geländewagen / SUV","PKW"]
[{"$nulls":13},"Ford Transit Custom Kombi PKW (PHEV)","x",{"$f":"ROUND(Q84/1.19,2)","v":52805},62837.95,"Ford Transit Custom Kombi PKW (130 PS, Automatik)",{"$f":"ROUND(T84/1.19,2)","v":35505},42250.95,{"$f":"ROUND(P84-S84,0)","v":17300},{"$f":"ROUND(Q84-T84,0)","v":20587},"Großraum-Van","PKW",{"$nulls":19},"Nissan Leaf ZE1 (40 kwh)",null,{"$f":"ROUND(AU84/1.19,2)","v":30924.37},36800,"Nissan Pulsar Visia",{"$f":"ROUND(AX84/1.19,2)","v":15537.82},18490,{"$f":"ROUND(AT84-AW84,0)","v":15387},18310,"Kompaktklasse","PKW"]
[{"$nulls":13},"Ford Mustang Mach-E Standard Range 75,7 kWh (alle Varianten)",null,{"$f":"46900/1.19","v":39411.764705882357},{"$f":"ROUND(P85*1.19,2)","v":46900},"Ford Mondeo 2,0l EcoBlue Limousine  110 kW",{"$f":"36554.62/1.16","v":31512.603448275866},{"$f":"ROUND(S85*1.19,2)","v":37500},7899,9400,"Geländewagen / SUV","PKW",null,"2021-01-14"]
[{"$nulls":13},"Ford Mustang Mach-E Extended Range 98,7 kWh (alle Varianten)",null,{"$f":"54475/1.19","v":45777.310924369747},{"$f":"ROUND(P86*1.19,2)","v":54475},"Ford Mondeo 2,0l EcoBlue Limousine  110 kW",{"$f":"36554.62/1.16","v":31512.603448275866},{"$f":"ROUND(S86*1.19,2)","v":37500},14265,16975,"Geländewagen / SUV","PKW",{"$nulls":19},"Nissan Leaf ZE1 e+ (62 kwh)",null,51836.97,58973.94,"Nissan Pulsar Visia",29453.59,33008.743999999999,36563.898000000001,40119.052000000003,"Kompaktklasse","PKW"]
[{"$nulls":13},"Honda e",null,28445.38,33850,"Honda Jazz Trend",14529.41,17290,13916,16560,"Kleinwagen","PKW",null,"2021-06-18"]
[{"$nulls":13},"Hyundai IONIQ Elektro 28 kWh",null,27983.19,33300,"Hyundai i30 5T 1.4 T­GDI, 6­Gang, 103 kW",19033.61,22650,8950,10650,"Kompaktklasse","PKW",null,"2021-06-18"]
[{"$nulls":13},"Hyundai IONIQ Elektro 38,3 kWh",null,{"$f":"ROUND(34458.82/1.16,2)","v":29705.88},{"$f":"ROUND(P89*1.19,2)","v":35350},"Hyundai i30 5T 1.5 T­GDI, 6­Gang, 117 kW",{"$f":"ROUND(25139.83/1.16,2)","v":21672.27},{"$f":"ROUND(S89*1.19,2)","v":25790},8034,9560,"Kompaktklasse","PKW"]
[{"$nulls":13},"Hyundai IONIQ Plug-in-Hybrid","x",25126.05,29900,"Hyundai i30 5T 1.4 T­GDI, 6­Gang, 103 kW",19033.61,22650,6092,7250,"Kompaktklasse","PKW",null,"2021-01-22"]
[{"$nulls":13},"Hyundai IONIQ 5 Elektro 58 kWh",null,{"$f":"ROUND(41900/1.19,2)","v":35210.080000000002},{"$f":"ROUND(P91*1.19,2)","v":41900},"Hyundai Tucson 48 V 1.6 T-GDI, 110 kW",{"$f":"ROUND(30500/1.19,2)","v":25630.25},{"$f":"ROUND(S91*1.19,2)","v":30500},9580,11400,"Geländewagen / SUV","PKW",null,"2020-03-23",{"$nulls":17},"Nissan e-NV200 Kasten",null,{"$f":"ROUND(AU91/1.19,2)","v":28660},34105.4,"Nissan NV200 Kasten",{"$f":"ROUND(AX91/1.19,2)","v":15350},18266.5,{"$f":"ROUND(AT91-AW91,0)","v":13310},15839,"Utility (N1)","NFZ"]
[{"$nulls":13},"Hyundai IONIQ 5 Elektro 72,6 kWh",null,{"$f":"ROUND((41900+3200)/1.19,2)","v":37899.160000000003},{"$f":"ROUND(P92*1.19,2)","v":45100},"Hyundai Tucson 48 V 1.6 T-GDI, 110 kW",{"$f":"ROUND(30500/1.19,2)","v":25630.25},{"$f":"ROUND(S92*1.19,2)","v":30500},12269,14600,"Geländewagen / SUV","PKW",null,"2020-03-23",{"$nulls":17},"Nissan e-NV200 Evalia 5-Sitzer",null,{"$f":"ROUND(AU92/1.19,2)","v":36498.32},43433,"Nissan NV200 Evalia 5-Sitzer",{"$f":"ROUND(AX92/1.19,2)","v":19571.43},23290,16927,20143,"Utility (N1)","NFZ"]
[{"$nulls":13},"Hyundai Kona Elektro 39,2 kWh",null,29075.63,34600,"Hyundai Kona",17310.919999999998,20600,11765,14000,"Geländewagen / SUV","PKW",null,"2020-03-23",{"$nulls":17},"Nissan e-NV200 Evalia 7-Sitzer",null,{"$f":"ROUND(AU93/1.19,2)","v":37168.07},{"$f":"AU92+797","v":44230},"Nissan NV200 Evalia 7-Sitzer",{"$f":"ROUND(AX93/1.19,2)","v":21193.279999999999},25220,15975,19010,"Utility (N1)","NFZ"]
[{"$nulls":13},"Hyundai Kona Elektro 64,0 kWh",null,{"$f":"ROUND(41850/1.19,2)","v":35168.07},{"$f":"ROUND(P94*1.19,2)","v":41850},"Hyundai Kona 1.6 GDI, Select",{"$f":"ROUND(26900/1.19,2)","v":22605.040000000001},{"$f":"ROUND(S94*1.19,2)","v":26900},12563,14950,"Geländewagen / SUV","PKW",null,"2020-03-23",{"$nulls":17},"Opel Ampera-E Plus",null,{"$f":"ROUND(AU94/1.19,2)","v":36126.050000000003},42990,"Opel Astra 1.4 Direct Injection Turbo (Start/Stop)",{"$f":"ROUND(AX94/1.19,2)","v":20684.87},24615,15441,18375,"Kompaktklasse","PKW"]
[{"$nulls":13},"ISEKI Goupil G4 (13,8 kWh)",null,33663.03,40059,"Piaggio Porter Chassis",13193.28,15700,20470,24359,"Utility (N1)","NFZ",{"$nulls":19},"Opel Corsa-e Edition",null,35543.699999999997,40437.4,"Opel Corsa Edition (74 kW)",20328.91,23127.82,15215,17310,"Kleinwagen","PKW"]
[{"$nulls":13},"ISEKI Goupil G4 (9 kWh)",null,29881.51,35559,"Piaggio Porter Chassis",13193.28,15700,16688,19859,"Utility (N1)","NFZ",null,"2020-12-18"]
[{"$nulls":13},"ISEKI Goupil G5 (11,5 kWh)",null,34967.230000000003,41611,"Piaggio Porter Chassis",13193.28,15700,21774,25911,"Utility (N1)","NFZ",null,"2020-12-18"]
[{"$nulls":13},"ISEKI Goupil G5 (19,2 kWh)",null,44294.96,52711,"Piaggio Porter Chassis",13193.28,15700,31102,37011,"Utility (N1)","NFZ",null,"2020-12-18"]
[{"$nulls":13},"Jaguar I-Pace",null,65747.899999999994,78240,"Jaguar F-Pace 30t AWD",47689.08,56750,18059,21490,"Geländewagen / SUV","PKW",null,"2020-12-18"]
[{"$nulls":13},"Jaguar E-Pace R-Dynamic S P300e","x",49025.21,{"$f":"ROUND(P100*1.19,2)","v":58340},"Jaguar E-Pace R-Dynamic S D165 AWD",43134.46,{"$f":"ROUNDDOWN(S100*1.19,2)","v":51330},5891,7010,"Geländewagen / SUV","PKW",null,"2020-09-10",{"$nulls":17},"Peugeot e-2008 (alle Versionen)",null,{"$f":"ROUND(AU100/1.19,2)","v":29621.85},35250,"Peugeot 2008 PureTech 130 Active",{"$f":"ROUND(AX100/1.19,2)","v":19537.82},23250,10084,12000,"Geländewagen / SUV","PKW",43913]
[{"$nulls":13},"Jaguar F-Pace P400e","x",59474.14,{"$f":"ROUND(P101*1.19,2)","v":70774.23},"Jaguar F-Pace D300 AWD",55232.76,{"$f":"ROUND(S101*1.19,2)","v":65726.98},4241,5047,"Geländewagen / SUV","PKW",{"$nulls":19},"Peugeot e-208 (alle Versionen)",null,25588.240000000002,30450,"Peugeot 208 PureTech 100 Active",15084.03,17950,10504,12500,"Kleinwagen","PKW",43913]
[{"$nulls":13},"Jeep Renegade 4xe 1.3I T-GDI I4 PHEV (alle Varianten)","x",35798.32,{"$f":"ROUND(P102*1.19,2)","v":42600},"Jeep Renegade 1.3I T-GDI I4",26638.66,{"$f":"ROUNDDOWN(S102*1.19,2)","v":31700},{"$f":"ROUND(P102-S102,0)","v":9160},{"$f":"ROUND(Q102-T102,0)","v":10900},"Geländewagen / SUV","PKW",{"$nulls":19},"Peugeot e-208 Allure",null,27058.82,32200,"Peugeot 208 Allure",17142.86,20400,{"$f":"ROUND(AT102-AW102,0)","v":9916},{"$f":"ROUND(AU102-AX102,0)","v":11800},"Kleinwagen","PKW"]
[{"$nulls":13},"Jeep Compass 4xe 1.3I T-GDI I4 PHEV (alle Varianten)","x",39159.660000000003,{"$f":"ROUND(P103*1.19,2)","v":46600},"Jeep Compass 1.3I T-GDI I4",31428.57,{"$f":"ROUND(S103*1.19,2)","v":37400},{"$f":"ROUND(P103-S103,0)","v":7731},{"$f":"ROUND(Q103-T103,0)","v":9200},"Geländewagen / SUV","PKW",{"$nulls":19},"Peugeot 508 SW GT Hybrid 225 e-EAT9","x",43361.34,51600,"Peugeot 508 SW GT PureTech 225 EAT9",39915.97,47500,3445,4100,"Mittelklasse","PKW"]
[{"$nulls":13},"Kia Ceed SW PHEV (alle Versionen)","x",29410.92,34999,"Kia Ceed SW 1.4 T-GDI ",21000,24990,8411,10009,"Kompaktklasse","PKW",{"$nulls":18},"Vti 68 jetzt Vti 73","Peugeot Partner electrique (L1)",null,21290,25335.1,"Peugeot Partner (L1) BlueHDi 76",16338.66,19443,4951,5892,"Utility (N1)","NFZ"]
[{"$nulls":13},"Kia e-Niro 39,2 kWh",null,28815.13,34290,"Kia Ceed SW 1.4 T-GDI ",19403.36,23090,9412,11200,"Kompaktklasse","PKW",{"$nulls":19},"Peugeot Partner electrique (L2)",null,22340,26584.6,"Peugeot Partner (L2) Blue Hdi 76",19079.830000000002,22705,3260,3880,"Utility (N1)","NFZ"]
[{"$nulls":13},"Kia e-Niro 64 kWh",null,32008.400000000001,38090,"Kia Ceed SW 1.4 T-GDI ",19403.36,23090,12605,15000,"Kompaktklasse","PKW",null,"2021-01-21"]
[{"$nulls":13},"Kia Niro Plug-in Hybrid","x",27521.01,32750,"Kia Ceed SW 1.4 T-GDI ",19403.36,23090,8118,9660,"Kompaktklasse","PKW",null,"2021-01-21"]
[{"$nulls":13},"Kia Optima 2.0 GDI Plug-in Hybrid ","x",34235.29,40740,"Kia Optima 2.0 CVVL",24109.24,28690,10126,12050,"Mittelklasse","PKW",null,"2020-09-10",{"$nulls":17},"Peugeot iOn",null,18319.330000000002,21800,"Peugeot 108 5-Türer Vti 73",10462.18,12450,7857,9350,"Mini","PKW"]
[{"$nulls":13},"Kia Soul EV (27 bzw. 30 kWh)",null,24781.51,29490,"Kia Soul",14487.39,17240,10294,12250,"Mini-Van","PKW",{"$nulls":19},"Piaggio Porter Elektro (alle Versionen)",null,23618.49,28106,"Piaggio Porter (alle Versionen)",12894.96,15345,10724,12761,"Utility (N1)","NFZ"]
[{"$nulls":13},"Kia e-Soul 39,2 kWh",null,28563.03,{"$f":"ROUNDDOWN(P110*1.19,2)","v":33990},"Kia Niro 1.6 GDI Hybrid",{"$f":"ROUND(26990/1.19,2)","v":22680.67},{"$f":"ROUND(S110*1.19,2)","v":26990},5882,7000,"Mini-Van","PKW"]
[{"$nulls":13},"Kia e-Soul 64,0 kWh",null,31756.3,{"$f":"ROUND(P111*1.19,2)","v":37790},"Kia Niro 1.6 GDI Hybrid",22680.67,26990,9076,10800,"Mini-Van","PKW",null,"2021-02-02"]
[{"$nulls":13},"Kia XCeed PHEV (alle Versionen)","x",30251.26,35999,"Kia XCeed Vision",20075.63,23890,10176,12109,"Kompaktklasse","PKW",null,"2021-02-02"]
[{"$nulls":13},"Land Rover Range Rover P400e Plug-in Hybrid","x","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL","Land Rover Range Rover 3.0 TDV6",{"$nulls":4},"Geländewagen / SUV","PKW",null,"2020-12-17"]
[{"$nulls":13},"Land Rover Range Rover Sport P400e Plug-in Hybrid","x","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL","Land Rover Range Rover Sport 3.0 TDV6",{"$nulls":4},"Geländewagen / SUV","PKW",null,"2021-06-18"]
[{"$nulls":13},"LEVC TX5 (alle Versionen)","x",61422.5,{"$f":"ROUND(P115*1.19,2)","v":73092.78},"Opel Vivaro Combi S 88 kW",30610,{"$f":"ROUND(S115*1.19,2)","v":36425.9},{"$f":"ROUND(P115-S115,0)","v":30813},36667,"Großraum-Van","PKW",{"$nulls":18},">60g CO2/km","Polaris Ranger EV",null,19076.5,21703,"Polaris Ranger 571",15760,17930,3317,3773,"Utility (N1)","NFZ"]
[{"$nulls":13},"LEVC VN5 (alle Versionen)","x",52450,{"$f":"ROUND(P116*1.19,2)","v":62415.5},"Opel Vivaro Cargo S 88kW",27470,{"$f":"ROUND(S116*1.19,2)","v":32689.3},{"$f":"ROUND(P116-S116,0)","v":24980},{"$f":"ROUND(Q116-T116,0)","v":29726},"Utility (N1)","NFZ",{"$nulls":18},">60g CO2/km","Polestar 3",null,{"$f":"ROUND(AU116/1.19,2)","v":50336.13},59900,"Volvo S60 T6 AWD",{"$f":"ROUND(AX116/1.19,2)","v":43865.55},52200,6471,7700,"Mittelklasse","PKW"]
[{"$nulls":13},"Mazda MX-30 e-SKYACTIV",null,28142.86,{"$f":"ROUND(P117*1.19,2)","v":33490},"CX-30 SKYACTIV-G 2.0 M Hybrid",20832.759999999998,{"$f":"ROUND(S117*1.19,2)","v":24790.98},{"$f":"ROUND(P117-S117,0)","v":7310},{"$f":"ROUND(Q117-T117,0)","v":8699},"Geländewagen / SUV","PKW",null,"2021-06-22",{"$nulls":17},"Porsche Panamera Turbo S E-Hybrid (alle Versionen)","x","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL",null,{"$f":"ROUND(AX117/1.19,2)","v":0},0,0,0,"Oberklasse","PKW"]
[{"$nulls":13},"MAN e-TGE",null,null,null,"wie VW e-Crafter ",null,null,{"$f":"U229","v":40620},{"$f":"V229","v":48338},"Utility (N1)","NFZ",null,"2021-06-22",{"$nulls":17},"Porsche Cayenne S E-Hybrid","x","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL",null,{"$f":"ROUND(AX118/1.19,2)","v":0},0,0,0,"Oberklasse","PKW"]
[{"$nulls":13},"Mercedes Benz A 250 e ","x",{"$f":"ROUND(Q119/1.19,2)","v":31045},36943.550000000003,"Mercedes Benz A 200 ",{"$f":"ROUND(T119/1.19,2)","v":25845},30755.55,{"$f":"ROUND(P119-S119,0)","v":5200},{"$f":"ROUND(Q119-T119,0)","v":6188},"Kompaktklasse","PKW",{"$nulls":19},"Renault Zoe Life (22 kWh), Batterie zur Miete",null,{"$f":"ROUND(AU119/1.19,2)","v":18403.36},21900,"Renault Clio Limited 5-türig",{"$f":"ROUND(AX119/1.19,2)","v":13016.81},15490,{"$f":"ROUND(AT119-AW119,0)","v":5387},{"$f":"ROUND(AU119-AX119,0)","v":6410},"Kleinwagen","PKW"]
[{"$nulls":13},"Mercedes Benz A 250 e (Limousine)","x",31345,37300.550000000003,"Mercedes Benz A 200 (Limousine)",26145,31112.55,5200,6188,"Kompaktklasse","PKW",{"$nulls":19},"Porsche Taycan 4S",null,122468.62,139330.23999999999,"Porsche Panamera 5",113360.62,128968.24,{"$f":"ROUND(AT120-AW120,0)","v":9108},10362,"Oberklasse","PKW"]
[{"$nulls":13},"Mercedes Benz C 300 (T) e (W205/S205)","x",39265,46725.35,"Mercedes Benz C 300",37360,44458.400000000001,1905,2267,"Mittelklasse","PKW",null,"2021-06-15"]
[{"$nulls":13},"Mercedes Benz C 300 (T) de (W205/S205)","x",41265,49105.35,"Mercedes Benz C 300 d",39065,46487.35,2200,2618,"Mittelklasse","PKW",{"$nulls":19},"Renault Zoe Life (22 kWh)",null,{"$f":"ROUND(AU122/1.19,2)","v":25126.05},29900,"Renault Clio Limited 5-türig",{"$f":"ROUND(AX122/1.19,2)","v":13016.81},15490,12109,14410,"Kleinwagen","PKW"]
[{"$nulls":13},"Mercedes Benz E 300 (T) e","x",{"$f":"ROUND(Q123/1.19,2)","v":46300},55097,"Mercedes Benz E 300",{"$f":"ROUND(T123/1.19,2)","v":44600},53074,{"$f":"ROUND(P123-S123,0)","v":1700},{"$f":"ROUND(Q123-T123,0)","v":2023},"Obere Mittelklasse","PKW",null,"2020-08-20",{"$nulls":17},"Renault Zoe Life (41 kWh), Batterie zur Miete",null,{"$f":"ROUND(AU123/1.19,2)","v":21932.77},26100,"Renault Clio Limited 5-türig",13016.81,15490,8916,10610,"Kleinwagen","PKW"]
[{"$nulls":13},"Mercedes Benz E 300 (T) de","x",49100,58429,"Mercedes Benz E 300 d (T-Modell)",46735,55614.65,2365,2814,"Obere Mittelklasse","PKW",null,"2020-12-17"]
[{"$nulls":13},"Mercedes Benz EQA 250",null,39950,{"$f":"ROUND(P125*1.19,2)","v":47540.5},"Mercedes Benz GLA 180",30920,{"$f":"ROUND(S125*1.19,2)","v":36794.800000000003},{"$f":"ROUND(P125-S125,0)","v":9030},{"$f":"ROUND(Q125-T125,0)","v":10746},"Geländewagen / SUV","PKW",null,"2020-12-17"]
[{"$nulls":13},"Mercedes Benz EQC 400 4MATIC",null,59900,71281,"Mercedes Benz GLC 300 4MATIC",45030,53585.7,14870,17695,"Geländewagen / SUV","PKW",null,"2020-12-17"]
[{"$nulls":13},"Mercedes Benz EQV 300 (alle Varianten)",null,60889,{"$f":"ROUND(P127*1.19,2)","v":72457.91},"Mercedes Benz V220D Lang",44280,{"$f":"ROUND(S127*1.19,2)","v":52693.2},16609,19765,"Großraum-Van","PKW",null,"aus EMIN_EFA, 13.08.2020",{"$nulls":17},"Renault Zoe Life (41 kWh)",null,{"$f":"ROUND(AU127/1.19,2)","v":28655.46},34100,"Renault Clio Limited 5-türig",13016.81,15490,15639,18610,"Kleinwagen","PKW"]
[{"$nulls":13},"Mercedes Benz GLA250e","x",38810,46183.9,"GLA200d",32890,39139.1,5920,7045,"Geländewagen / SUV","PKW",null,"aus EMIN_EFA, 13.08.2020",{"$nulls":17},"Renault Zoe (52 kWh, 108 PS), Batterie zur Miete",null,27715.97,31531.94,"Renault Clio Limited 5-türig",13016.81,15490,{"$f":"ROUND(AT128-AW128,0)","v":14699},{"$f":"ROUND(AU128-AX128,0)","v":16042},"Kleinwagen","PKW"]
[{"$nulls":13},"Mercedes Benz GLC 300 (d)e 4MATIC (ab 2019, MOPF, alle Varianten)","x",49950,59440.5,"GLC 220 d 4MATIC ",42435,50497.65,7515,8943,"Geländewagen / SUV","PKW",{"$nulls":19},"Renault Zoe (52 kWh, 108 PS)",null,37097.65,42205.3,"Renault Clio Limited 5-türig",13016.81,15490,24081,26715,"Kleinwagen","PKW"]
[{"$nulls":13},"Mercedes Benz GLE 350 (d)e 4MATIC (V 167, C167, alle Varianten)","x",64980,77326.2,"GLE 300 d 4MATIC ",58930,70126.7,6050,7200,"Geländewagen / SUV","PKW",null,"2020-09-10",{"$nulls":17},"Renault Zoe (52 kWh, 135 PS), Batterie zur Miete",null,32354.63,36809.26,"Renault Clio TCe 130 EDC GPF (130 PS)",24457.32,27824.639999999999,7897,8985,"Kleinwagen","PKW"]
[{"$nulls":13},"Mercedes Benz eSprinter 35 kWh (alle Varianten)",null,53900,64141,"Mercedes Benz Sprinter Kasten 211 CDI",32485,38657.15,21415,25484,"Utility (N1)","NFZ",{"$nulls":19},"Renault Zoe (52 kWh, 135 PS) ",null,41736.31,47482.62,"Renault Clio TCe 130 EDC GPF (130 PS)",24457.32,27824.639999999999,17279,19658,"Kleinwagen","PKW"]
[{"$nulls":13},"Mercedes Benz eSprinter 47 kWh (alle Varianten)",null,61273,72914.87,"Mercedes Benz Sprinter Kasten 211 CDI",32485,38657.15,28788,34258,"Utility (N1)","NFZ",{"$nulls":19},"Renault Kangoo Z.E. 33 2-Sitzer, Batterie zur Miete",null,{"$f":"ROUND(AU132/1.19,2)","v":20820},24775.8,"Renault Kangoo Rapid Compact (2-Sitzer)",{"$f":"ROUND(AX132/1.19,2)","v":14310},17028.900000000001,6510,7747,"Utility (N1)","NFZ"]
[{"$nulls":13},"Mercedes Benz eVito (alle Varianten)",null,{"$f":"ROUND(Q133/1.19,2)","v":44990},53538.1,"Mercedes Benz Vito Kastenwagen Worker",{"$f":"ROUND(T133/1.19,2)","v":18490},22003.1,26500,31535,"Utility (N1)","NFZ",null,"2021-06-22"]
[{"$nulls":13},"Mercedes Benz eVito Tourer (alle Varianten)",null,55232,{"$f":"ROUND(P134*1.19,2)","v":65726.080000000002},"MercedesBenz Vito Tourer, Base, Lang",30040,{"$f":"ROUND(S134*1.19,2)","v":35747.599999999999},25192,29978,"Großraum-Van","NFZ",{"$nulls":19},"Renault Kangoo Z.E. 33 2-Sitzer",null,29920,35604.800000000003,"Renault Kangoo Rapid Compact (2-Sitzer)",14310,17028.900000000001,15610,18576,"Utility (N1)","NFZ"]
[{"$nulls":13},"Mercedes Benz smart forfour electric drive (alle Versionen)",null,{"$f":"ROUND(Q135/1.19,2)","v":18991.599999999999},22600,"Mercedes Benz smart forfour 52 kW",{"$f":"ROUND(T135/1.19,2)","v":9936.9699999999993},11825,9055,10775,"Kleinwagen","PKW",{"$nulls":19},"Renault Kangoo Maxi Z.E. 33 2-Sitzer, Batterie zur Miete",null,22020,26203.8,"Renault Kangoo Rapid Maxi",18600,22134,3420,4070,"Utility (N1)","NFZ"]
[{"$nulls":13},"Mercedes Benz smart fortwo ED (alle Versionen)",null,18436.97,21940,"Mercedes Benz smart 52 kW",9382.35,11165,9055,10775,"Mini","PKW",{"$nulls":19},"Renault Kangoo Maxi Z.E. 33 2-Sitzer",null,31120,37032.800000000003,"Renault Kangoo Rapid Maxi",18600,22134,12520,14899,"Utility (N1)","NFZ"]
[{"$nulls":13},"MG ZS EV (alle Versionen)",null,{"$f":"(31990)/1.19","v":26882.352941176472},{"$f":"ROUND(P137*1.19,2)","v":31990},"Peugeot 2008 PureTech 130 Active",{"$f":"ROUND(T137/1.19,2)","v":19537.82},23250,7345,8740,"Kompaktklasse","PKW",{"$nulls":19},"Renault Kangoo Maxi Z.E. 33 5-Sitzer, Batterie zur Miete",null,22820,27155.8,"Renault Kangoo Rapid Maxi (Combi)",19600,23324,3220,3832,"Utility (N1)","NFZ"]
[{"$nulls":13},"Mini Cooper SE 3-Türer Trim S",null,27310.92,32500,"Mini Cooper S 3-Türer",24327.73,28950,2983,3550,"Kleinwagen","PKW",{"$nulls":19},"Renault Kangoo Maxi Z.E. 33 5-Sitzer",null,31920,37984.800000000003,"Renault Kangoo Rapid Maxi (Combi)",19600,23324,12320,14661,"Utility (N1)","NFZ"]
[{"$nulls":13},"Mitsubishi PLUG-IN HYBRID OUTLANDER","x",31924.37,37990,"Mitsubishi Outlander",21756.3,25890,10168,12100,"Geländewagen / SUV","PKW",{"$nulls":18},"Übernahme alter Preis","Renault Kangoo Z.E. 33 Doppelkabine, Batterie zur Miete",null,23220,27631.8,"Renault Kangoo Rapid Maxi (Doppelkabine)",19847.060000000001,23618,3373,4014,"Utility (N1)","NFZ"]
[{"$nulls":13},"Nissan e-NV200 Evalia 5-Sitzer",null,36498.32,43433,"Nissan NV200 Evalia 5-Sitzer",19571.43,23290,16927,20143,"Großraum-Van","NFZ",{"$nulls":19},"Renault Kangoo Z.E. 33 Doppelkabine",null,32320,38460.800000000003,"Renault Kangoo Rapid Maxi (Doppelkabine)",19847.060000000001,23618,12473,14843,"Utility (N1)","NFZ"]
[{"$nulls":13},"Nissan e-NV200 Evalia 7-Sitzer",null,37168.07,{"$f":"Q140+797","v":44230},"Nissan NV200 Evalia 7-Sitzer",21193.279999999999,25220,15975,19010,"Großraum-Van","NFZ",{"$nulls":19},"Renault Master Z.E. Kasten (alle Versionen)",null,64000,76160,"Renault Master Kasten (alle Versionen)",31560,37556.400000000001,32440,38604,"Utility (N1)","NFZ"]
[{"$nulls":13},"Nissan e-NV200 Kasten",null,28660,34105.4,"Nissan NV200 Kasten",15350,18266.5,13310,15839,"Utility (N1)","NFZ",null,"2021-06-23"]
[{"$nulls":13},"Nissan Leaf ZE1 (40 kwh)",null,30924.37,36800,"Nissan Pulsar Visia",15537.82,18490,15387,18310,"Kompaktklasse","PKW",{"$nulls":19},"Renault Master Z.E. Plattform-FG (alle Versionen)",null,62000,73780,"Renault Master Plattform-FG (alle Versionen)",28120,33462.799999999996,33880,40317,"Utility (N1)","NFZ"]
[{"$nulls":13},"Nissan Leaf ZE1 e+ (62 kwh)",null,37563.03,44700,"Nissan Pulsar Visia",15537.82,18490,22025,26210,"Kompaktklasse","PKW",null,"2020-04-17",{"$nulls":16},"Preis aus Projektunterlagen","Renault Twizzy Life - Intens, Cargo (18PS)",null,6428.57,7650,"Quad 400 ccm",3067.23,3650,3361,4000,"Leichtfahrzeug","LFZ"]
[{"$nulls":13},"Opel Ampera-E Plus",null,36126.050000000003,42990,"Opel Astra 1.4 Direct Injection Turbo (Start/Stop)",20684.87,24615,{"$f":"ROUND(P145-S145,0)","v":15441},{"$f":"ROUND(Q145-T145,0)","v":18375},"Kompaktklasse","PKW",null,"2020-12-18"]
[{"$nulls":13},"Opel Combo-e Life (alle Versionen)",null,{"$f":"ROUND(38100/1.19,2)","v":32016.81},{"$f":"P146*1.19","v":38100.003900000003},"Opel Combo Life Edition 81 kW",{"$f":"ROUND(25180/1.19,2)","v":21159.66},{"$f":"S146*1.19","v":25179.9954},{"$f":"ROUND(P146-S146,0)","v":10857},{"$f":"ROUND(Q146-T146,0)","v":12920},"Großraum-Van","PKW",null,"2020-12-18"]
[{"$nulls":13},"Opel Corsa-e Edition",null,25756.3,30650,"Opel Corsa Edition (74 kW)",14731.09,17530,11025,13120,"Kleinwagen","PKW",null,"2020-12-18"]
[{"$nulls":13},"Opel Grandland X (133 kW, alle Versionen)",null,37533.61,44665,"Opel Grandland X 1,6 Direct Injection Turbo (133 kW)",30504.2,36300,7029,8365,"Geländewagen / SUV","PKW",null,"2020-12-18"]
[{"$nulls":13},"Opel Mokka-E",null,{"$f":"ROUND(32158.32/1.16,2)","v":27722.69},{"$f":"P149*1.19","v":32990.001099999994},"Opel Mokka 1.2 74 kW",{"$f":"ROUND(19486.05/1.16,2)","v":16798.32},{"$f":"S149*1.19","v":19990.000799999998},10924,13000,"Kompaktklasse","PKW",null,"2020-12-18"]
[{"$nulls":13},"Opel Zafira Life 50 kWh (alle Versionen)",null,{"$f":"ROUND(55904.2/1.16,2)","v":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,"2021-01-11"]
[{"$nulls":13},"Opel Zafira Life 75 kWh (alle Versionen)",null,{"$f":"ROUND(61752.94/1.16,2)","v":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,"2021-01-11"]
[{"$nulls":13},"Opel Vivaro-E Cargo 50 kWh (alle Versionen)",null,36240,43125.599999999999,"Opel Vivaro Cargo M 90 kW",28280,33653.199999999997,7960,9472,"Utility","NFZ",{"$nulls":19},"Renault Twizzy 45 - Life, Intens, Cargo (5PS)",null,5840.34,6950,"Quad 300 ccm",2478.9899999999998,2950,3361,4000,"Leichtfahrzeug","LFZ"]
[{"$nulls":13},"Opel Vivaro-E Cargo 75 kWh (alle Versionen)",null,41240,49075.6,"Opel Vivaro Cargo M 90 kW",28280,33653.199999999997,12960,15422,"Utility","NFZ",null,"2020-12-18"]
[{"$nulls":13},"Opel Vivaro-E Kombi 50 kWh (alle Versionen)",null,42250,50277.5,"Opel Kombi 90 kW",34410,40947.9,{"$f":"ROUND(P154-S154,0)","v":7840},9330,"Großraum-Van","PKW",null,"2020-03-23",{"$nulls":16},"32-35g CO2 /km; 47,2-55,6km e-Reichweite","SAIC MAXUS EV 80 (Cargo Mobile)",null,48500,57715,"Renault Master Ecoline L1H1 2,8 t",23290,27715.1,25210,30000,"Utility (N1)","NFZ"]
[{"$nulls":13},"Opel Vivaro-E Kombi 75 kWh (alle Versionen)",null,47250,56227.5,"Opel Kombi 90 kW",34410,40947.9,{"$f":"ROUND(P155-S155,0)","v":12840},15280,"Großraum-Van","PKW",{"$nulls":19},"Seat Mii electric",null,17352.939999999999,20650,"Seat Mii 1.0 (55kW)",10134.450000000001,12060,{"$f":"ROUND(AT155-AW155,0)","v":7218},8590,"Mini","PKW",43913]
[{"$nulls":13},"Peugeot 508 SW GT Hybrid 225 e-EAT8","x",43361.34,51600,"Peugeot 508 SW GT PureTech 225 EAT8",39915.97,47500,3445,4100,"Mittelklasse","PKW",null,"aus EMIN_EFA, 20.08.2020",{"$nulls":16},"32-35g CO2 /km; 47,2-55,6km e-Reichweite","Skoda Citigo-e iV (alle Versionen)",null,17605.04,20950,"Skoda Citigo Ambition (55kW)",9327.73,11100,8277,9850,"Kleinwagen","PKW"]
[{"$nulls":13},"Peugeot 3008 Hybrid 225/300  (alle Versionen)","x",{"$f":"ROUND(45912.61/1.16,2)","v":39579.839999999997},{"$f":"ROUNDDOWN(P157*1.19,2)","v":47100},"Peugeot 3008 PureTech 180 EAT8",{"$f":"ROUND(39966.39/1.16,2)","v":34453.78},{"$f":"ROUND(S157*1.19,2)","v":41000},5126,6100,"Kompaktklasse","PKW",null,"aus EMIN_EFA, 20.08.2020",{"$nulls":17},"Skoda Superb iV (alle Versionen)","x",34949.58,41590,"Skoda Superb Ambition (110kW)",26596.639999999999,31650,8353,9940,"Mittelklasse","PKW"]
[{"$nulls":13},"Peugeot e-2008 (alle Versionen)",null,29621.85,35250,"Peugeot 2008 PureTech 130 Active",19537.82,23250,10084,12000,"Geländewagen / SUV","PKW",null,"2021-01-14"]
[{"$nulls":13},"Peugeot e-208 Allure",null,27058.82,32200,"Peugeot 208 Allure",17142.86,20400,9916,11800,"Kleinwagen","PKW",null,"2021-01-14"]
[{"$nulls":13},"Peugeot E-Expert 50kWh (alle Versionen)",null,35250,{"$f":"ROUND(P160*1.19,2)","v":41947.5},"Peugeot Expert L2 Blue HDi  120 90 kW ",26500,{"$f":"ROUND(S160*1.19,2)","v":31535},8750,10413,"Utility (N1)","NFZ",null,"2021-06-22"]
[{"$nulls":13},"Peugeot E-Expert 75kWh (alle Versionen)",null,40250,{"$f":"ROUND(P161*1.19,2)","v":47897.5},"Peugeot Expert L2 Blue HDi  120 90 kW ",26500,{"$f":"ROUND(S161*1.19,2)","v":31535},13750,16363,"Utility (N1)","NFZ",{"$nulls":19},"Skoda Superb Combi iV (alle Versionen)","x",35789.919999999998,42590,"Skoda Superb Combi Ambition (110kW)",27436.97,32650,8353,9940,"Mittelklasse","PKW"]
[{"$nulls":13},"Peugeot E-Expert Kombi 50kWh (alle Versionen)",null,{"$f":"ROUND(48388.57/1.16,2)","v":41714.28},{"$f":"ROUNDUP(P162*1.19,2)","v":49640},"Peugeot Expert L2 BlueHDi  120 88 kW",{"$f":"ROUND(34205.38/1.16,2)","v":29487.4},{"$f":"ROUNDDOWN(S162*1.19,2)","v":35090},12227,14550,"Großraum-Van","PKW",{"$nulls":19},"Streetscooter Work 20 (alle Versionen)",null,35950,42780.5,"Nissan NV200 Kasten",15350,18266.5,20600,24514,"Utility (N1)","NFZ"]
[{"$nulls":13},"Peugeot E-Traveller 50kWh (alle Versionen)",null,{"$f":"ROUND(54490.76/1.16,2)","v":46974.79},{"$f":"ROUND(P163*1.19,2)","v":55900},"Peugeot Expert L2 BlueHDi  120 88 kW",{"$f":"ROUND(40307.56/1.16,2)","v":34747.9},{"$f":"ROUNDDOWN(S163*1.19,2)","v":41350},12227,14550,"Großraum-Van","PKW",{"$nulls":19},"Streetscooter Work 40 (alle Versionen)",null,40950,48730.5,"Nissan NV200 Kasten",15350,18266.5,25600,30464,"Utility (N1)","NFZ"]
[{"$nulls":13},"Peugeot e-Rifter (alle Versionen)",null,{"$f":"ROUND(37590/1.19,2)","v":31588.240000000002},{"$f":"ROUNDDOWN(P164*1.19,2)","v":37590},"Peugeot e-Rifter PureTech 110 81 kW",{"$f":"ROUND(25140/1.19,2)","v":21126.05},{"$f":"S164*1.19","v":25139.999499999998},10462,12450,"Großraum-Van","PKW",{"$nulls":19},"Streetscooter Work L 40 (alle Versionen)",null,45450,54085.5,"Renault Master Ecoline L1H1 2,8 t",23290,27715.1,22160,26370,"Utility (N1)","NFZ"]
[{"$nulls":13},"Peugeot iOn",null,{"$f":"ROUND(Q165/1.19,2)","v":18319.330000000002},21800,"Peugeot 108 5-Türer Vti 72",{"$f":"ROUND(T165/1.19,2)","v":10462.18},12450,7857,9350,"Mini","PKW",{"$nulls":19},"Streetscooter Work XL (alle Versionen)",null,67000,79730,"Ford Transit 350 L4H4",46397,53345.5,20603,26385,"Utility (N1)","NFZ"]
[{"$nulls":13},"Peugeot Partner electrique (L1)",null,{"$f":"ROUND(Q166/1.19,2)","v":21290},25335.1,"Peugeot Partner (L1) BlueHDi 75",16338.66,19443,4951,5892,"Utility (N1)","NFZ",{"$nulls":19},"Tazzari Zero EM2 Space",null,19159.66,22800,"Mercedes Benz smart 52 kW",{"$f":"ROUND(AX166/1.19,2)","v":9382.35},11165,9777,11635,"Mini","PKW",43913]
[{"$nulls":13},"Peugeot Partner electrique (L2)",null,{"$f":"ROUND(Q167/1.19,2)","v":22340},26584.6,"Peugeot Partner (L2) Blue Hdi 75",19079.830000000002,22705,3260,3880,"Utility (N1)","NFZ",{"$nulls":19},"Tesla Model S Standard-Reichweite",null,68890.759999999995,81980,"BMW 640i GT",57899.16,68900,10992,13080,"Oberklasse","PKW"]
[{"$nulls":13},"Polaris Ranger EV",null,{"$f":"ROUND(Q168/1.19,2)","v":13823.53},16450,"Polaris Ranger 570",11420.17,13590,2403,2860,"Utility (N1)","NFZ",{"$nulls":18},"28g CO2/km neue Preisliste für Corolla demnächst, Preis aus Konfigurator","Tesla Model S Maximal-Reichweite",null,73092.44,86980,"BMW 640i GT",57899.16,68900,15193,18080,"Oberklasse","PKW"]
[{"$nulls":13},"Polestar 2",null,{"$f":"ROUND(Q169/1.19,2)","v":50336.13},59900,"Volvo S60 T6 AWD",43865.55,52200,6471,7700,"Mittelklasse","PKW",{"$nulls":19},"Tesla Model S Standard-Reichweite (Einsatz als Taxi)",null,68890.759999999995,81980,"Mercedes Benz E200 4MATIC",43545,51818.55,25346,30161,"Oberklasse","PKW"]
[{"$nulls":13},"Porsche Cayenne S E-Hybrid","x","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL",null,0,0,0,0,"Oberklasse","PKW",{"$nulls":18},"alter Preis für koventionelles Fahrzeug, \nda dieses nicht mehr verfügbar","Tesla Model S Maximal-Reichweite (Einsatz als Taxi)",null,73092.44,86980,"Mercedes Benz E400d 4MATIC",55050,65509.5,18042,21471,"Oberklasse","PKW"]
[{"$nulls":13},"Porsche Panamera 4 E-Hybrid (alle Versionen)","x","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL",null,0,0,0,0,"Oberklasse","PKW",{"$nulls":19},"Tesla Model X Maximal-Reichweite",null,76470.59,91000,"BMW X6 xDrive40D",66134.45,78700,10336,12300,"Geländewagen / SUV","PKW"]
[{"$nulls":13},"Porsche Panamera Turbo S E-Hybrid (alle Versionen)","x","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL",null,0,0,0,0,"Oberklasse","PKW",{"$nulls":18},"35-40 g CO2 / km 50km e-Reichweite","Tesla Model 3 Standard-Reichweite",null,51605.04,58710.080000000002,"BMW 320i",47488.24,54026.48,4117,4684,"Mittelklasse","PKW"]
[{"$nulls":13},"Porsche Taycan 4S",null,{"$f":"ROUND(Q173/1.19,2)","v":88745.38},105607,"Porsche Panamera 4",82145.38,97753,{"$f":"ROUND(P173-S173,0)","v":6600},{"$f":"ROUND(Q173-T173,0)","v":7854},"Oberklasse","PKW",{"$nulls":18},"Preis \nfür Limo (Variant als \"Sonderausstattung\"); 55km e-Reichweite","Tesla Model 3 75D Long Range / Performance",null,{"$f":"ROUND(AU173/1.19,2)","v":47378.15},56380,"BMW 330i ",{"$f":"ROUND(AX173/1.19,2)","v":37605.040000000001},44750,9773,11630,"Mittelklasse","PKW"]
[{"$nulls":13},"Renault Kangoo Maxi Z.E. 33 2-Sitzer",null,31120,37032.800000000003,"Renault Kangoo Rapid Maxi",18600,22134,12520,14899,"Utility (N1)","NFZ",{"$nulls":19},"Toyota Prius Plug-In Hybrid (alle Ausstattungen)","x",31554.62,37550,"Toyota Corolla 1.2 Comfort",19991.599999999999,23790,11563,13760,"Kompaktklasse","PKW"]
[{"$nulls":13},"Renault Kangoo Maxi Z.E. 33 2-Sitzer, Batterie zur Miete",null,22020,26203.8,"Renault Kangoo Rapid Maxi",18600,22134,3420,4070,"Utility (N1)","NFZ",{"$nulls":19},"Volkswagen e-up",null,19306.72,22975,"Volkswagen move up! 55KW 5 Gang",9945.3799999999992,11835,9361,11140,"Mini","PKW"]
[{"$nulls":13},"Renault Kangoo Maxi Z.E. 33 5-Sitzer",null,31920,37984.800000000003,"Renault Kangoo Rapid Maxi (Combi)",19600,23324,12320,14661,"Utility (N1)","NFZ",{"$nulls":19},"Volkswagen e-load up",null,20079.830000000002,23895,"Volkswagen load up!",9285.7099999999991,11050,10794,12845,"Mini","PKW"]
[{"$nulls":13},"Renault Kangoo Maxi Z.E. 33 5-Sitzer, Batterie zur Miete",null,22820,27155.8,"Renault Kangoo Rapid Maxi (Combi)",19600,23324,3220,3832,"Utility (N1)","NFZ",{"$nulls":19},"Volkswagen e-Golf",null,30168.07,35900,"Volkswagen Golf 85 KW TSI CL",19760.5,23515,10408,12385,"Kompaktklasse","PKW"]
[{"$nulls":13},"Renault Kangoo Z.E. 33 2-Sitzer",null,29920,35604.800000000003,"Renault Kangoo Rapid Compact (2-Sitzer)",14310,17028.900000000001,15610,18576,"Utility (N1)","NFZ",{"$nulls":19},"Volkswagen Golf GTE (PHEV)","x",31008.400000000001,36900,"Volkswagen Golf 1,5 TSI ACT 110 KW CL",22075.63,26270,8933,10630,"Kompaktklasse","PKW"]
[{"$nulls":13},"Renault Kangoo Z.E. 33 2-Sitzer, Batterie zur Miete",null,20820,24775.8,"Renault Kangoo Rapid Compact (2-Sitzer)",14310,17028.900000000001,6510,7747,"Utility (N1)","NFZ",{"$nulls":18},"43 g CO2 / km, 56 km e-Reichweite","Volkswagen Passat GTE (PHEV)","x",37184.870000000003,44250,"Volkswagen Passat 132 KW TSI CL",27180.67,32345,10004,11905,"Mittelklasse","PKW"]
[{"$nulls":13},"Renault Kangoo Z.E. 33 Doppelkabine",null,32320,38460.800000000003,"Renault Kangoo Rapid Maxi (Doppelkabine)",19847.060000000001,23618,12473,14843,"Utility (N1)","NFZ",{"$nulls":18},"45 g CO2 / km 49 km e-Reichweite","Volkswagen e-Crafter",null,69536,82747.839999999997,"VW Crafter 30 (75 kW / 102 PS)",28916,34410.04,40620,48338,"Utility (N1)","NFZ"]
[{"$nulls":13},"Renault Kangoo Z.E. 33 Doppelkabine, Batterie zur Miete",null,23220,27631.8,"Renault Kangoo Rapid Maxi (Doppelkabine)",19847.060000000001,23618,3373,4014,"Utility (N1)","NFZ",{"$nulls":18},"43 g CO2/km, 53 km e-Reichweite","Volvo V60 T6 TWIN ENGINE AWD","x",46932.77,55850,"Volvo V60 T5 AWD Momentum",42016.81,50000,4916,5850,"Mittelklasse","PKW"]
[{"$nulls":13},"Renault Master Z.E. Kasten (alle Versionen)",null,64000,76160,"Renault Master Kasten (alle Versionen)",31560,37556.400000000001,32440,38604,"Utility (N1)","NFZ",{"$nulls":18},"50 g CO2 / km 46 km e-Reichweite","Volvo V60 T8 TWIN ENGINE AWD","x",50504.2,60100,"Volvo V60 T6 AWD Momentum",41596.639999999999,49500,8908,10600,"Mittelklasse","PKW"]
[{"$nulls":13},"Renault Master Z.E. Plattform-FG (alle Versionen)",null,62000,73780,"Renault Master Plattform-FG (alle Versionen)",28120,33462.799999999996,33880,40317,"Utility (N1)","NFZ",{"$nulls":19},"Volvo S60 T8 TWIN ENGINE AWD",null,49579.83,59000,"Volvo S60 T6 AWD",43865.55,52200,5714,6800,"Mittelklasse","PKW",43913]
[{"$nulls":13},"Renault Twizzy 45 - Life, Intens, Cargo (5PS)",null,5840.34,6950,"Quad 300 ccm",2478.9899999999998,2950,3361,4000,"Leichtfahrzeug","LFZ",{"$nulls":18},"44 g CO2 /km, 42 km e-Reichweite","Volvo S90 T8 TWIN ENGINE AWD","x",59705.88,71050,"Volvo S90 T6 AWD Momentum",49033.61,58350,10672,12700,"Obere Mittelklasse","PKW"]
[{"$nulls":13},"Renault Twizzy Life - Intens, Cargo (18PS)",null,6428.57,7650,"Quad 400 ccm",3067.23,3650,3361,4000,"Leichtfahrzeug","LFZ",{"$nulls":18},"52 g CO2 / km 43 km e-Reichweite","Volvo V90 T8 TWIN ENGINE AWD","x",62268.91,74100,"Volvo V90 T6 AWD Momentum",51596.639999999999,61400,10672,12700,"Obere Mittelklasse","PKW"]
[{"$nulls":13},"Renault Zoe (52 kWh, 108 PS)",null,26882.35,31990,"Renault Clio Limited 5-türig",13016.81,15490,13866,16500,"Kleinwagen","PKW",{"$nulls":18},"57 g CO2 / km 37 km e-Reichweite","Volvo XC 40 T5 TWIN ENGINE DKG Momentum Pro  ","x",41176.47,49000,"Volvo XC 40 T4 AWD Momentum Pro",36260.5,43150,4916,5850,"Geländewagen / SUV","PKW"]
[{"$nulls":13},"Renault Zoe (52 kWh, 108 PS), Batterie zur Miete",null,20084.03,23900,"Renault Clio Limited 5-türig",13016.81,15490,7067,8410,"Kleinwagen","PKW",{"$nulls":19},"Volvo XC 60 T8 TWIN ENGINE","x","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL","Volvo XC 60 T6 AWD Momentum",{"$nulls":4},"Geländewagen / SUV","PKW"]
[{"$nulls":13},"Renault Zoe (52 kWh, 135 PS) ",null,30243.7,35990,"Renault Clio TCe 130 EDC GPF (130 PS)",17722.689999999999,21090,12521,14900,"Kleinwagen","PKW",{"$nulls":19},"Volvo XC 90 T8 TWIN ENGINE AWD","x","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL","Volvo XC 90 T6 AWD Momentum",{"$nulls":4},"Geländewagen / SUV","PKW"]
[{"$nulls":13},"Renault Zoe (52 kWh, 135 PS), Batterie zur Miete",null,23445.38,27900,"Renault Clio TCe 130 EDC GPF (130 PS)",17722.689999999999,21090,5723,6810,"Kleinwagen","PKW",{"$nulls":19},"Zhidou D2S (17 KWh)",null,{"$f":"ROUND(AU189/1.19,2)","v":15546.22},18500,"Hyundai I10 Trend (49 kWh)",{"$f":"ROUND(AX189/1.19,2)","v":11226.89},13360,{"$f":"ROUND(AT189-AW189,0)","v":4319},{"$f":"ROUND(AU189-AX189,0)","v":5140},"Mini","PKW"]
[{"$nulls":13},"Renault Zoe Life (22 kWh)",null,25126.05,29900,"Renault Clio Limited 5-türig",13016.81,15490,12109,14410,"Kleinwagen","PKW",null,"2020-12-18"]
[{"$nulls":13},"Renault Zoe Life (22 kWh), Batterie zur Miete",null,18403.36,21900,"Renault Clio Limited 5-türig",13016.81,15490,5387,6410,"Kleinwagen","PKW",{"$nulls":19},"Zhidou D2S (27 KWh)",null,{"$f":"ROUND(AU191/1.19,2)","v":18067.23},21500,"Hyundai I10 Style (64 kWh)",{"$f":"ROUND(AX191/1.19,2)","v":12823.53},15260,{"$f":"ROUND(AT191-AW191,0)","v":5244},{"$f":"ROUND(AU191-AX191,0)","v":6240},"Mini","PKW"]
[{"$nulls":13},"Renault Zoe Life (41 kWh)",null,28655.46,34100,"Renault Clio Limited 5-türig",13016.81,15490,15639,18610,"Kleinwagen","PKW",null,"2020-03-23"]
[{"$nulls":13},"Renault Zoe Life (41 kWh), Batterie zur Miete",null,21932.77,26100,"Renault Clio Limited 5-türig",13016.81,15490,8916,10610,"Kleinwagen","PKW",null,"2020-12-18"]
[{"$nulls":13},"Renault Twingo Electric Vibes",null,{"$f":"ROUND(24165.04/1.16,2)","v":20831.93},{"$f":"ROUND(P194*1.19,2)","v":24790},"Renault Twingo SCe 75 Intens",{"$f":"ROUND(13637.31/1.16,2)","v":11756.3},{"$f":"ROUND(S194*1.19,2)","v":13990},{"$f":"ROUND(P194-S194,0)","v":9076},{"$f":"ROUND(Q194-T194,0)","v":10800},"Kompaktklasse","PKW",{"$nulls":19},"Fahrzeugsegment Leichtfahrzeug",null,"*","*","z.B. Renault Twizzy Life, Aixam eCity…","*","*",{"$f":"ROUND(AZ194/1.19,0)","v":7507},{"$f":" AY178","v":8933},"Leichtfahrzeug","LFZ",43914]
[{"$nulls":13},"SAIC MAXUS EV 80 (Cargo Mobile)",null,48500,57715,"Renault Master Ecoline L1H1 2,8 t",23290,27715.1,25210,30000,"Utility (N1)","NFZ",null,"2020-12-18"]
[{"$nulls":13},"Seat Mii electric",null,17352.939999999999,20650,"Seat Mii 1.0 (55kW)",10134.450000000001,12060,7218,8590,"Mini","PKW",null,"2020-12-18"]
[{"$nulls":13},"Seat Leon 1.4 e-HYBRID XCELLENCE (alle Varianten)","x",{"$f":"34390.59/1.16","v":29647.060344827587},{"$f":"ROUND(P197*1.19,2)","v":35280},"Seat Leon 1.5 TSI 6-Gang XCELLENCE",{"$f":"26095.13/1.16","v":22495.801724137935},{"$f":"ROUND(S197*1.19,2)","v":26770},7151,8510,"Mittelklasse","PKW",null,"2020-12-18"]
[{"$nulls":13},"Skoda Citigo-e iV (alle Versionen)",null,17605.04,20950,"Skoda Citigo Ambition (55kW)",9327.73,11100,8277,9850,"Kleinwagen","PKW",null,"2020-12-18"]
[{"$nulls":13},"Skoda ENYAQ iV 50 (alle Versionen)",null,{"$f":"ROUND(33800/1.19,2)","v":28403.360000000001},{"$f":"ROUND(P199*1.19,2)","v":33800},"Skoda Kodiaq 1,5 l TSI ACT1 110 kW, 6 Gang",{"$f":"ROUND(29000/1.19,2)","v":24369.75},{"$f":"ROUND(S199*1.19,2)","v":29000},4034,4800,"Geländewagen / SUV","PKW",{"$nulls":19},"Fahrzeugsegment Kleinwagen",null,"*","*","Z.B. BMW i3, Renault Zoe…","*","*",{"$f":"ROUND(AZ199/1.19,0)","v":15051},17911,"Kleinwagen","PKW",43913]
[{"$nulls":13},"Skoda ENYAQ iV 60 (alle Versionen)",null,{"$f":"ROUND(38850/1.19,2)","v":32647.06},{"$f":"ROUND(P200*1.19,2)","v":38850},"Skoda Kodiaq 1,5 l TSI ACT1 110 kW, 6 Gang",{"$f":"ROUND(29000/1.19,2)","v":24369.75},{"$f":"ROUND(S200*1.19,2)","v":29000},8277,9850,"Geländewagen / SUV","PKW",{"$nulls":19},"Fahrzeugsegment Kompaktklasse",null,"*","*","z.B. Nissan Leaf, VW e-Golf, Opel Ampera-E…","*","*",{"$f":"ROUND(AZ200/1.19,0)","v":2903},{"$f":"AZ74","v":3454},"Kompaktklasse","PKW",43913]
[{"$nulls":13},"Skoda ENYAQ iV 80 (alle Versionen)",null,{"$f":"ROUND(43950/1.19,2)","v":36932.769999999997},{"$f":"ROUND(P201*1.19,2)","v":43950},"Skoda Kodiaq 1,5 l TSI ACT1 110 kW, 6 Gang",{"$f":"ROUND(29000/1.19,2)","v":24369.75},{"$f":"ROUND(S201*1.19,2)","v":29000},12563,14950,"Geländewagen / SUV","PKW",{"$nulls":19},"Fahrzeugsegment Mini",null,"*","*","z.B. VW e-up, Mitsubishi EV…","*","*",13819,16445,"Mini","PKW",43913]
[{"$nulls":13},"Skoda Octavia iV Style (alle Varianten)","x",{"$f":"37617/1.16","v":32428.448275862072},{"$f":"ROUND(P202*1.19,2)","v":38589.85},"Skoda Octavia 1.5 TSI ACT Style SG",{"$f":"29000/1.16","v":25000},{"$f":"ROUND(S202*1.19,2)","v":29750},7428,8840,"Mittelklasse","PKW",{"$nulls":19},"Fahrzeugsegment Mini-Van",null,"*","*","z.B. MB B250e, Nissan e-NV200 Evalia…","*","*",12617,15014.77,"Mini-Van","PKW",43913]
[{"$nulls":13},"Skoda Superb Combi iV (alle Versionen)","x",35789.919999999998,42590,"Skoda Superb Combi Ambition (110kW)",27436.97,32650,8353,9940,"Mittelklasse","PKW",{"$nulls":19},"Fahrzeugsegment Mittelklasse",null,"*","*","z.B. VW Passat GTE, BMW 330e…","*","*",10672,12700,"Mittelklasse","PKW",43913]
[{"$nulls":13},"Skoda Superb iV (alle Versionen)","x",34949.58,41590,"Skoda Superb Ambition (110kW)",26596.639999999999,31650,8353,9940,"Mittelklasse","PKW",{"$nulls":19},"Fahrzeugsegment Nutzfahrzeug (Utility) leicht",null,"*","*","z.B. Renault Kangoo, Nissan e-NV200, Streetscooter Work...","*","*",33880,{"$f":"AZ143","v":40317},"Utility (N1)","NFZ",43913]
[{"$nulls":13},"Streetscooter Work 20 (alle Versionen)",null,35950,42780.5,"Nissan NV200 Kasten",15350,18266.5,20600,24514,"Utility (N1)","NFZ",null,"2020-03-23",{"$nulls":17},"Fahrzeugsegment Nutzfahrzeug (Utility) mittel",null,"*","*","z.B. Streetscooter Work L, SAIC Maxus EV81","*","*",31885,37943.15,"Utility (N1)","PKW",43913]
[{"$nulls":13},"Streetscooter Work 40 (alle Versionen)",null,40950,48730.5,"Nissan NV200 Kasten",15350,18266.5,25600,30464,"Utility (N1)","NFZ",{"$nulls":19},"Fahrzeugsegment Obere Mittelklasse",null,"*","*","z.B. BMW 530e, MB E350e...","*","*",9832,11699.9967,"Obere Mittelklasse","PKW",43913]
[{"$nulls":13},"Streetscooter Work L 40 (alle Versionen)",null,45450,54085.5,"Renault Master Ecoline L1H1 2,8 t",23290,27715.1,22160,26370,"Utility (N1)","NFZ",{"$nulls":19},"Fahrzeugsegment Oberklasse",null,"*","*","z.B. BMW 740e, Tesla Model S","*","*",20000,23800,"Oberklasse","PKW",43913]
[{"$nulls":13},"Streetscooter Work XL (alle Versionen)",null,67000,79730,"Ford Transit 350 L4H3",33150,39448.5,33850,40282,"Utility (N1)","NFZ",{"$nulls":19},"Fahrzeugsegment SUV",null,"*","*","z.B. Audi Q7 e-tron, Volvo XC60 T8 Twin Engine…","*","*",15966,19000,"Geländewagen / SUV","PKW",43913]
[{"$nulls":13},"Tazzari Zero EM2 Space",null,19159.66,22800,"Mercedes Benz smart 52 kW",9382.35,11165,9777,11635,"Mini","PKW","Renault Zoe Life (41 kWh)"]
[{"$nulls":13},"Tesla Model 3 75D Long Range / Performance",null,47378.15,56380,"BMW 330i ",37605.040000000001,44750,9773,11630,"Mittelklasse","PKW","Nissan Leaf ZE1 e+ (62 kwh)"]
[{"$nulls":13},"Tesla Model 3 Standard-Reichweite",null,37394.959999999999,44500,"BMW 320i",34411.760000000002,40950,2983,3550,"Mittelklasse","PKW","Volkswagen e-load up",{"$nulls":25},"Werte netto waren fehlerhaft!"]
[{"$nulls":13},"Tesla Model S Maximal-Reichweite",null,73092.44,86980,"BMW 640i GT",57899.16,68900,15193,18080,"Oberklasse","PKW","Kia Optima 2.0 GDI Plug-in Hybrid (Sportswagon)"]
[{"$nulls":13},"Tesla Model S Maximal-Reichweite (Einsatz als Taxi)",null,73092.44,86980,"Mercedes Benz E400d 4MATIC",55050,65509.5,18042,21471,"Oberklasse","PKW",null,"2020-12-18"]
[{"$nulls":13},"Tesla Model S Standard-Reichweite",null,68890.759999999995,81980,"BMW 640i GT",57899.16,68900,10992,13080,"Oberklasse","PKW","Volkswagen e-Crafter"]
[{"$nulls":13},"Tesla Model S Standard-Reichweite (Einsatz als Taxi)",null,68890.759999999995,81980,"Mercedes Benz E200 4MATIC",43545,51818.55,25346,30161,"Oberklasse","PKW"]
[{"$nulls":13},"Tesla Model X Maximal-Reichweite",null,76470.59,91000,"BMW X6 xDrive40D",66134.45,78700,10336,12300,"Geländewagen / SUV","PKW"]
[{"$nulls":13},"Tesla Model Y LongRange (alle Versionen)",null,{"$f":"ROUND(58620/1.16,2)","v":50534.48},{"$f":"ROUND(P217*1.16,2)","v":58620},"BMW X3 xDrive30i",{"$f":"ROUND(53028.56/1.16,2)","v":45714.28},{"$f":"ROUNDUP(S217*1.19,2)","v":54400},4820,4220,"Geländewagen / SUV","PKW"]
[{"$nulls":13},"Toyota Prius Plug-In Hybrid (alle Ausstattungen)","x",31554.62,37550,"Toyota Corolla 1.2 Comfort",19991.599999999999,23790,11563,13760,"Kompaktklasse","PKW"]
[{"$nulls":13},"Toyota Proace Electric 50 kWh (alle Versionen)",null,36350,{"$f":"ROUND(P219*1.19,2)","v":43256.5},"Toyota Proace 88kW",27200,{"$f":"ROUND(S219*1.19,2)","v":32368},{"$f":"ROUND(P219-S219,0)","v":9150},{"$f":"ROUND(U219*1.19,2)","v":10888.5},"Utility (N1)","NFZ"]
[{"$nulls":13},"Toyota Proace Electric 75 kWh (alle Versionen)",null,41350,{"$f":"ROUND(P220*1.19,2)","v":49206.5},"Toyota Proace 88kW",27200,32368,14150,{"$f":"ROUND(U220*1.19,2)","v":16838.5},"Utility (N1)","NFZ",null,"2021-06-18"]
[{"$nulls":13},"Toyota Proace Verso Electric 50 kWh (alle Versionen)",null,{"$f":"ROUND(58530/1.19,2)","v":49184.87},{"$f":"ROUND(P221*1.19,2)","v":58530},"Toyota Proace Verso 88 kW",{"$f":"ROUND(43980/1.19,2)","v":36957.980000000003},43980,12227,{"$f":"ROUND(U221*1.19,2)","v":14550.13},"Großraum-Van","PKW",null,"2021-06-18"]
[{"$nulls":13},"Toyota Proace Verso Electric 75 kWh (alle Versionen)",null,{"$f":"ROUND(64530/1.19,2)","v":54226.89},{"$f":"ROUND(P222*1.19,2)","v":64530},"Toyota Proace Verso 88 kW",{"$f":"ROUND(43980/1.19,2)","v":36957.980000000003},43980,17269,{"$f":"ROUND(U222*1.19,2)","v":20550.11},"Großraum-Van","PKW",null,"2021-02-10"]
[{"$nulls":13},"Toyota RAV4 Plug-in Hybrid AWD (alle Versionen)","x",{"$f":"ROUND(47490/1.19,2)","v":39907.56},{"$f":"ROUND(P223*1.19,2)","v":47490},"Toyota RAV4 Comfort AWD",{"$f":"ROUND(39890/1.19,2)","v":33521.01},39890,6387,{"$f":"ROUND(U223*1.19,2)","v":7600.53},"Geländewagen / SUV","PKW",null,"2021-02-10"]
[{"$nulls":13},"Tropos Motors ABLE XT1  (13kWh) (alle Versionen, FIN:…..E...)",null,23000,{"$f":"P224*1.19","v":27370},"Piaggio Porter - Entry Level Chassis",11071.43,{"$f":"ROUNDUP(S224*1.19,2)","v":13175.01},11929,{"$f":"ROUND(Q224-T224,0)","v":14195},"Utility (N1)","NFZ","Volvo V90 T8 TWIN ENGINE AWD","2020-09-10"]
[{"$nulls":13},"Tropos Motors ABLE XT2 (26kWh) (alle Versionen, FIN:…..D...)",null,27000,{"$f":"P225*1.19","v":32130},"Piaggio Porter - Entry Level Chassis",11071.43,{"$f":"ROUNDUP(S225*1.19,2)","v":13175.01},15929,{"$f":"ROUND(Q225-T225,0)","v":18955},"Utility (N1)","NFZ","Tesla Model S Maximal-Reichweite"]
[{"$nulls":13},"Volkswagen ABT e-Caddy (alle M1-Versionen)",null,31500,{"$f":"ROUND(P226*1.19,2)","v":37485},"Volkswagen Caddy 75 kW TDI",22910,27262.9,8590,{"$f":"ROUND(Q226-T226,0)","v":10222},"Großraum-Van","PKW","Jaguar I-Pace"]
[{"$nulls":13},"Volkswagen ABT e-Caddy (alle N1 Versionen)",null,31500,{"$f":"ROUND(P227*1.19,2)","v":37485},"Volkswagen Caddy 75 kW TDI",22910,{"$f":"ROUND(S227*1.19,2)","v":27262.9},{"$f":"ROUND(P227-S227,0)","v":8590},10222,"Utility (N1)","NFZ"]
[{"$nulls":13},"Volkswagen Abt-e T6.1  Transporter / Caravelle / Kombi",null,null,null,"Elektrifizierungsumfang",null,null,25184,29969,"Utility (N1)","NFZ"]
[{"$nulls":13},"Volkswagen e-Crafter",null,{"$f":"ROUND(Q229/1.19,2)","v":69536},82747.839999999997,"VW Crafter 30 (75 kW / 102 PS)",{"$f":"ROUND(T229/1.19,2)","v":28916},34410.04,{"$f":"ROUND(P229-S229,0)","v":40620},{"$f":"ROUND(Q229-T229,0)","v":48338},"Utility (N1)","NFZ"]
[{"$nulls":13},"Volkswagen e-Golf",null,{"$f":"ROUND(Q230/1.19,2)","v":30168.07},35900,"Volkswagen Golf 85 KW TSI CL",{"$f":"ROUND(T230/1.19,2)","v":19760.5},23515,10408,12385,"Kompaktklasse","PKW",null,"2020-12-18"]
[{"$nulls":13},"Volkswagen e-load up",null,{"$f":"ROUND(Q231/1.19,2)","v":20079.830000000002},23895,"Volkswagen load up!",{"$f":"ROUND(T231/1.19,2)","v":9285.7099999999991},11050,10794,12845,"Mini","PKW",null,"2021-01-21"]
[{"$nulls":13},"Volkswagen e-up",null,{"$f":"ROUND(Q232/1.19,2)","v":19306.72},22975,"Volkswagen move up! 55KW 5 Gang",{"$f":"ROUND(T232/1.19,2)","v":9945.3799999999992},11835,9361,11140,"Mini","PKW",null,"aus EMIN_EFA, 13.08.2020"]
[{"$nulls":13},"Volkswagen Golf VII GTE","x",{"$f":"ROUND(Q233/1.19,2)","v":31008.400000000001},36900,"Volkswagen Golf 1,5 TSI ACT 110 KW CL",{"$f":"ROUND(T233/1.19,2)","v":22075.63},26270,8933,10630,"Kompaktklasse","PKW",null,"aus EMIN_EFA, 13.08.2020"]
[{"$nulls":13},"Volkswagen Golf VIII 1.4 eHybrid (alle Versionen)","x",{"$f":"ROUND(39781.18/1.16,2)","v":34294.120000000003},{"$f":"ROUND(P234*1.19,2)","v":40810},"VW Golf Style 1.5 TSI OPF 6-Gang 110 kW",{"$f":"ROUND(29248.58/1.16,2)","v":25214.29},{"$f":"ROUNDDOWN(S234*1.19,2)","v":30005},9080,10805,"Kompaktklasse","PKW"]
[{"$nulls":13},"Volkswagen ID.3  45 kWh (alle Versionen)",null,{"$f":"ROUND(31495/1.19,2)","v":26466.39},{"$f":"ROUND(P235*1.19,2)","v":31495},"VW Golf 1.5 TSI OPF 6-Gang 96 kW",{"$f":"ROUND(26036.64/1.16,2)","v":22445.38},{"$f":"ROUND(S235*1.19,2)","v":26710},4021,4785,"Kompaktklasse","PKW",null,"2020-12-18"]
[{"$nulls":13},"Volkswagen ID.3 Pro 58 kWh",null,30668.06,{"$f":"ROUNDUP(P236*1.19,2)","v":36495},"VW Golf Life 1.5 TSI OPF 6-Gang 110 kW",23302.52,{"$f":"ROUND(S236*1.19,2)","v":27730},7366,8765,"Kompaktklasse","PKW"]
[{"$nulls":13},"Volkswagen ID.3 Pro S 77 kWh",null,35289.919999999998,{"$f":"ROUND(P237*1.19,2)","v":41995},"VW Golf Life 1.5 TSI OPF 6-Gang 110 kW",23302.52,{"$f":"ROUND(S237*1.19,2)","v":27730},11987,14265,"Kompaktklasse","PKW",null,"2020-12-18"]
[{"$nulls":13},"Volkswagen ID.4  52 kWh (alle Versionen)",null,{"$f":"ROUND(38450/1.19,2)","v":32310.92},{"$f":"ROUNDUP(P238*1.19,2)","v":38450},"VW Tiguan Life 1.5 TSI OPF  Gang 110 kW",{"$f":"ROUND(29901.68/1.16,2)","v":25777.31},{"$f":"ROUND(S238*1.19,2)","v":30675},{"$f":"ROUND(P238-S238,0)","v":6534},{"$f":"ROUND(Q238-T238,0)","v":7775},"Geländewagen / SUV","PKW"]
[{"$nulls":13},"Volkswagen ID.4  Pro 77 kWh (alle Versionen)",null,{"$f":"ROUND(43329.42/1.16,2)","v":37352.949999999997},{"$f":"ROUNDDOWN(P239*1.19,2)-0.01","v":44450},"VW Tiguan Life 1.5 TSI OPF  Gang 110 kW",{"$f":"ROUND(29901.68/1.16,2)","v":25777.31},{"$f":"ROUND(S239*1.19,2)","v":30675},{"$f":"ROUND(P239-S239,0)","v":11576},13775,"Geländewagen / SUV","PKW",null,"2020-12-18"]
[{"$nulls":13},"Volkswagen Passat GTE (PHEV)","x",{"$f":"ROUND(Q240/1.19,2)","v":37184.870000000003},44250,"Volkswagen Passat 132 KW TSI CL",{"$f":"ROUND(T240/1.19,2)","v":27180.67},32345,10004,11905,"Mittelklasse","PKW",null,"2020-03-23"]
[{"$nulls":13},"Volkswagen Arteon 1.4 eHybrid (alle Versionen)","x",{"$f":"ROUND(51064.37/1.16,2)","v":44021.01},{"$f":"ROUND(P241*1.19,2)","v":52385},"Volkswagen Arteon 2.0 TDI SCR 110 kW",{"$f":"ROUND(43524.37/1.16,2)","v":37521.01},{"$f":"ROUND(S241*1.19,2)","v":44650},6500,7735,"Kompaktklasse","PKW"]
[{"$nulls":13},"Volkswagen Tiguan 1.4 eHybrid (alle Versionen)","x",{"$f":"ROUND(43510/1.19,2)","v":36563.03},{"$f":"ROUNDDOWN(P242*1.19,2)","v":43510},"VW Tiguan Life 1.5 TSI OPF  6Gang 110 kW",{"$f":"ROUND(29901.68/1.16,2)","v":25777.31},{"$f":"ROUND(S242*1.19,2)","v":30675},{"$f":"ROUND(P242-S242,0)","v":10786},{"$f":"ROUND(Q242-T242,0)","v":12835},"Geländewagen / SUV","PKW"]
[{"$nulls":13},"Volkswagen Touareg 3.0 V6 eHybrid 4MOTION","x",{"$f":"ROUND(72378.15/1.16,2)","v":62394.96},{"$f":"ROUND(P243*1.19,2)","v":74250},"Volkswagen Touareg 3.0 V6 TDI SCR 4MOTION 170 kW",{"$f":"ROUND(64482.35/1.16,2)","v":55588.23},{"$f":"ROUNDUP(S243*1.19,2)","v":66150},6807,8100,"Geländewagen / SUV","PKW"]
[{"$nulls":13},"Volvo S60 T8 TWIN ENGINE AWD","x",49579.83,59000,"Volvo S60 T6 AWD",43865.55,52200,5714,6800,"Mittelklasse","PKW"]
[{"$nulls":13},"Volvo S90 T8 TWIN ENGINE AWD","x",59705.88,71050,"Volvo S90 T6 AWD Momentum",49033.61,58350,10672,12700,"Obere Mittelklasse","PKW"]
[{"$nulls":13},"Volvo V60 T6 TWIN ENGINE AWD","x",46932.77,55850,"Volvo V60 T5 AWD Momentum",42016.81,50000,4916,5850,"Mittelklasse","PKW"]
[{"$nulls":13},"Volvo V60 T8 TWIN ENGINE AWD","x",50504.2,60100,"Volvo V60 T6 AWD Momentum",41596.639999999999,49500,8908,10600,"Mittelklasse","PKW"]
[{"$nulls":13},"Volvo V90 T8 TWIN ENGINE AWD","x",62268.91,74100,"Volvo V90 T6 AWD Momentum",51596.639999999999,61400,10672,12700,"Obere Mittelklasse","PKW",null,"2021-01-11"]
[{"$nulls":13},"Volvo XC 40 T5 TWIN ENGINE DKG Momentum Pro  ","x",41176.47,49000,"Volvo XC 40 T4 AWD Momentum Pro",36260.5,43150,4916,5850,"Geländewagen / SUV","PKW"]
[{"$nulls":13},"Volvo XC 60 T8 TWIN ENGINE","x","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL","Volvo XC 60 T6 AWD Momentum",{"$nulls":4},"Geländewagen / SUV","PKW"]
[{"$nulls":13},"Volvo XC 90 T8 TWIN ENGINE AWD","x","nicht förderfähig gemäß FRL","nicht förderfähig gemäß FRL","Volvo XC 90 T6 AWD Momentum",{"$nulls":4},"Geländewagen / SUV","PKW",null,"10.9.20 auf Werte aus dem Aufruf zurückgesetzt, da Segmentwerte nachträglich nicht geändert werden!!"]
[{"$nulls":13},"Volvo XC40 Recharge Pure Electric (alle Varianten)",null,52100.84,{"$f":"ROUND(P252*1.19,2)","v":62000},"Volvo XC40 B5 AWD",43403.360000000001,{"$f":"ROUND(S252*1.19,2)","v":51650},{"$f":"ROUND(P252-S252,0)","v":8697},10350,"Geländewagen / SUV","PKW",null,"10.9.20 auf Werte aus dem Aufruf zurückgesetzt, da Segmentwerte nachträglich nicht geändert werden!!"]
[{"$nulls":13},"Zhidou D2S (17 KWh)",null,{"$f":"ROUND(Q253/1.19,2)","v":15546.22},18500,"Hyundai I10 Trend (49 kW)",{"$f":"ROUND(T253/1.19,2)","v":11226.89},13360,4319,5140,"Mini","PKW",null,"10.9.20 auf Werte aus dem Aufruf zurückgesetzt, da Segmentwerte nachträglich nicht geändert werden!!"]
[{"$nulls":13},"Zhidou D2S (27 KWh)",null,{"$f":"ROUND(Q254/1.19,2)","v":18067.23},21500,"Hyundai I10 Style (64 kW)",{"$f":"ROUND(T254/1.19,2)","v":12823.53},15260,5244,6240,"Mini","PKW",null,"10.9.20 auf Werte aus dem Aufruf zurückgesetzt, da Segmentwerte nachträglich nicht geändert werden!!"]
[{"$nulls":13},"Fahrzeugsegment Kleinwagen",null,null,null,"Z.B. BMW i3, Renault Zoe…","*","*",15639,18610,"Kleinwagen","PKW",null,"10.9.20 auf Werte aus dem Aufruf zurückgesetzt, da Segmentwerte nachträglich nicht geändert werden!!"]
[{"$nulls":13},"Fahrzeugsegment Kompaktklasse",null,null,null,"z.B. Nissan Leaf, VW e-Golf…","*","*",22025,26210,"Kompaktklasse","PKW",null,"10.9.20 auf Werte aus dem Aufruf zurückgesetzt, da Segmentwerte nachträglich nicht geändert werden!!"]
[{"$nulls":13},"Fahrzeugsegment Mini",null,null,null,"z.B. VW e-up, Mitsubishi EV…","*","*",10794,12845,"Mini","PKW",null,"10.9.20 auf Werte aus dem Aufruf zurückgesetzt, da Segmentwerte nachträglich nicht geändert werden!!"]
[{"$nulls":13},"Fahrzeugsegment Mittelklasse",null,null,null,"z.B. VW Passat GTE, BMW 330e…","*","*",10126,12050,"Mittelklasse","PKW",null,"10.9.20 auf Werte aus dem Aufruf zurückgesetzt, da Segmentwerte nachträglich nicht geändert werden!!"]
[{"$nulls":13},"Fahrzeugsegment Utilities (Nutzfahrzeuge N1)",null,null,null,"z.B. Renault Kangoo, Nissan e-NV200, SAIC Maxus EV80","*","*",40620,48338,"Utility (N1)","NFZ"]
[{"$nulls":13},"Fahrzeugsegment Obere Mittelklasse",null,null,null,"z.B. BMW 530e, MB E350e, ...","*","*",10672,12700,"Obere Mittelklasse","PKW"]
[{"$nulls":13},"Fahrzeugsegment Oberklasse",null,null,null,"z.B. BMW 740e, Tesla Model S","*","*",15193,18080,"Oberklasse","PKW"]
[{"$nulls":13},"Fahrzeugsegment Geländewagen / SUV",null,null,null,"z.B. Mitsubishi Outlander, Tesla Model X, …","*","*",18059,21490,"Geländewagen / SUV","PKW"]

{"sheet":"LKW, Busse, Sonderfahrzeuge","index":2,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,0,2,9],[3,0,3,9],[0,0,0,9]]}
["Ermittlung der förderfähigen Ausgaben für LKW, Busse und Sonder-Fahrzeuge",{"$nulls":9},"FKZ:"]
["Hinweise:"]
["Hierfür müssen Sie entsprechende Angebote für das E-Fahrzeug und ein Referenzfahrzeug 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 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","erwartete durchschnittliche Jahres-Fahrleistung in km*","* alternativ: erwartete Jahresbetriebs-stunden","Förderfähige Ausgaben ","Korrekturfeld PtJ"]
[1,{"$nulls":4},{"$f":"IF(B7>\"\",IF($A$4=\"\",C7-E7,$F$6),\"\")","v":""},null,null,null,{"$f":"IF(B7>\"\",F7*G7,\"\")","v":""}]
[]
[2,{"$nulls":4},{"$f":"IF(B9>\"\",IF($A$4=\"\",C9-E9,$F$6),\"\")","v":""},null,null,null,{"$f":"IF(B9>\"\",F9*G9,\"\")","v":""}]
[]
[3,{"$nulls":4},"",null,null,null,""]
[]
[4,{"$nulls":4},"",null,null,null,""]
[]
[5,{"$nulls":4},"",null,null,null,""]
[]
[6,{"$nulls":4},"",null,null,null,""]
[]
[7,{"$nulls":4},"",null,null,null,""]
[]
[8,{"$nulls":4},"",null,null,null,""]
[]
[9,{"$nulls":4},"",null,null,null,""]
[]
[10,{"$nulls":4},"",null,null,null,""]
[]
["Summe",{"$nulls":8},{"$f":"SUM(J7:J25)","v":0}]

{"sheet":"Ladeinfrastruktur","index":3,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,0,2,5],[27,1,27,5]]}
["Ermittlung der förderfähigen Pauschalen für Ladeinfrastruktur",{"$nulls":4},"FKZ:"]
["Hinweis:"]
[{"$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($B6>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B6,$I$6:$K$15,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B6,$I$6:$K$15,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},null,{"$f":"IF(AND(B6<>\"\",D6>0),C6*D6,\"\")","v":""},null,null,null,"öff. zugängl. [AC] ≥ 3,7 kW (1 Ladepunkt)",2000,{"$f":"J6*1.19","v":2380}]
[{"$nulls":8},"öff. zugängl. [AC] ≥ 11 kW (min. 2 Ladepunkte)",5000,{"$f":"J7*1.19","v":5950}]
[2,null,{"$f":"IF($B8>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B8,$I$6:$K$15,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B8,$I$6:$K$15,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},null,{"$f":"IF(AND(B8<>\"\",D8>0),C8*D8,\"\")","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($B10>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B10,$I$6:$K$15,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B10,$I$6:$K$15,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},null,{"$f":"IF(AND(B10<>\"\",D10>0),C10*D10,\"\")","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($B12>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B12,$I$6:$K$15,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B12,$I$6:$K$15,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},null,{"$f":"IF(AND(B12<>\"\",D12>0),C12*D12,\"\")","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($B14>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B14,$I$6:$K$15,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B14,$I$6:$K$15,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},null,{"$f":"IF(AND(B14<>\"\",D14>0),C14*D14,\"\")","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($B16>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B16,$I$6:$K$15,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B16,$I$6:$K$15,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},null,{"$f":"IF(AND(B16<>\"\",D16>0),C16*D16,\"\")","v":""}]
[]
[7,null,{"$f":"IF($B18>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B18,$I$6:$K$15,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B18,$I$6:$K$15,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},null,{"$f":"IF(AND(B18<>\"\",D18>0),C18*D18,\"\")","v":""}]
[]
[8,null,{"$f":"IF($B20>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B20,$I$6:$K$15,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B20,$I$6:$K$15,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},null,{"$f":"IF(AND(B20<>\"\",D20>0),C20*D20,\"\")","v":""}]
[]
[9,null,{"$f":"IF($B22>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B22,$I$6:$K$15,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B22,$I$6:$K$15,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},null,{"$f":"IF(AND(B22<>\"\",D22>0),C22*D22,\"\")","v":""}]
[]
[10,null,{"$f":"IF($B24>0,IF(Fahrzeuge!$C$1=\"nein\",VLOOKUP($B24,$I$6:$K$15,3,0),IF(Fahrzeuge!$C$1=\"ja\",VLOOKUP($B24,$I$6:$K$15,2,0),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")),\"\")","v":""},null,{"$f":"IF(AND(B24<>\"\",D24>0),C24*D24,\"\")","v":""}]
[]
["Summe",null,null,null,{"$f":"SUM(E6:E24)","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":4,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[27,0,27,5],[2,0,2,6],[0,0,0,3]]}
["Ermittlung der förderfähigen Ausgaben für Ladeinfrastruktur die nicht in der Registerkarte \"Ladeinfrastruktur\" aufgeführt wird",{"$nulls":5},"FKZ:"]
["Hinweise:"]
["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(Fahrzeuge!$C$1>\"\",IF(AND(B7<>\"\",C7>0),D7*C7,\"\"),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")","v":"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!"}]
[]
[2,null,null,null,{"$f":"IF(Fahrzeuge!$C$1>\"\",IF(AND(B9<>\"\",C9>0),D9*C9,\"\"),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")","v":"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!"}]
[]
[3,null,null,null,{"$f":"IF(Fahrzeuge!$C$1>\"\",IF(AND(B11<>\"\",C11>0),D11*C11,\"\"),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")","v":"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!"}]
[]
[4,null,null,null,{"$f":"IF(Fahrzeuge!$C$1>\"\",IF(AND(B13<>\"\",C13>0),D13*C13,\"\"),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")","v":"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!"}]
[]
[5,null,null,null,{"$f":"IF(Fahrzeuge!$C$1>\"\",IF(AND(B15<>\"\",C15>0),D15*C15,\"\"),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")","v":"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!"}]
[]
[6,null,null,null,{"$f":"IF(Fahrzeuge!$C$1>\"\",IF(AND(B17<>\"\",C17>0),D17*C17,\"\"),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")","v":"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!"}]
[]
[7,null,null,null,{"$f":"IF(Fahrzeuge!$C$1>\"\",IF(AND(B19<>\"\",C19>0),D19*C19,\"\"),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")","v":"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!"}]
[]
[8,null,null,null,{"$f":"IF(Fahrzeuge!$C$1>\"\",IF(AND(B21<>\"\",C21>0),D21*C21,\"\"),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")","v":"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!"}]
[]
[9,null,null,null,{"$f":"IF(Fahrzeuge!$C$1>\"\",IF(AND(B23<>\"\",C23>0),D23*C23,\"\"),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")","v":"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!"}]
[]
[10,null,null,null,{"$f":"IF(Fahrzeuge!$C$1>\"\",IF(AND(B25<>\"\",C25>0),D25*C25,\"\"),\"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!\")","v":"Bitte wählen sie aus, ob sie zum Vorsteuerabzug berechtigt sind!"}]
[]
["Summe",null,null,null,{"$f":"IF(C7>0,SUM(E7:E25),\"\")","v":""}]

{"sheet":"Vorlage für AZA","index":5,"n_rows":61,"n_cols":5,"rows_kept":61,"cut":false,"hidden":false,"merged":[[2,0,2,7],[7,0,7,7],[4,0,4,7],[5,0,5,7]]}
["Hinweis:"]
[]
["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"]
[]
[{"$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\")"]
[]
["Gesamtfinanzierung - Gegenstände und andere Investitionen von mehr als 410 € im Einzelfall"]
[]
["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(LEFT(RIGHT(Fahrzeuge!C13,4),3),\" \",Fahrzeuge!B13),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B13>\"\",Fahrzeuge!G13,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B13>\"\",Fahrzeuge!H13,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B13>\"\",Fahrzeuge!K13,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!B14>\"\",Fahrzeuge!A14,A11)","v":0},{"$f":"IF(Fahrzeuge!$B14>\"\",CONCATENATE(LEFT(RIGHT(Fahrzeuge!C14,4),3),\" \",Fahrzeuge!B14),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B14>\"\",Fahrzeuge!G14,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B14>\"\",Fahrzeuge!H14,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B14>\"\",Fahrzeuge!K14,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!B15>\"\",Fahrzeuge!A15,A12)","v":0},{"$f":"IF(Fahrzeuge!$B15>\"\",CONCATENATE(LEFT(RIGHT(Fahrzeuge!C15,4),3),\" \",Fahrzeuge!B15),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B15>\"\",Fahrzeuge!G15,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B15>\"\",Fahrzeuge!H15,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B15>\"\",Fahrzeuge!K15,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!B16>\"\",Fahrzeuge!A16,A13)","v":0},{"$f":"IF(Fahrzeuge!$B16>\"\",CONCATENATE(LEFT(RIGHT(Fahrzeuge!C16,4),3),\" \",Fahrzeuge!B16),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B16>\"\",Fahrzeuge!G16,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B16>\"\",Fahrzeuge!H16,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B16>\"\",Fahrzeuge!K16,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!B17>\"\",Fahrzeuge!A17,A14)","v":0},{"$f":"IF(Fahrzeuge!$B17>\"\",CONCATENATE(LEFT(RIGHT(Fahrzeuge!C17,4),3),\" \",Fahrzeuge!B17),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B17>\"\",Fahrzeuge!G17,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B17>\"\",Fahrzeuge!H17,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B17>\"\",Fahrzeuge!K17,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!B18>\"\",Fahrzeuge!A18,A15)","v":0},{"$f":"IF(Fahrzeuge!$B18>\"\",CONCATENATE(LEFT(RIGHT(Fahrzeuge!C18,4),3),\" \",Fahrzeuge!B18),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B18>\"\",Fahrzeuge!G18,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B18>\"\",Fahrzeuge!H18,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B18>\"\",Fahrzeuge!K18,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!B19>\"\",Fahrzeuge!A19,A16)","v":0},{"$f":"IF(Fahrzeuge!$B19>\"\",CONCATENATE(LEFT(RIGHT(Fahrzeuge!C19,4),3),\" \",Fahrzeuge!B19),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B19>\"\",Fahrzeuge!G19,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B19>\"\",Fahrzeuge!H19,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B19>\"\",Fahrzeuge!K19,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!B20>\"\",Fahrzeuge!A20,A17)","v":0},{"$f":"IF(Fahrzeuge!$B20>\"\",CONCATENATE(LEFT(RIGHT(Fahrzeuge!C20,4),3),\" \",Fahrzeuge!B20),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B20>\"\",Fahrzeuge!G20,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B20>\"\",Fahrzeuge!H20,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B20>\"\",Fahrzeuge!K20,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!B21>\"\",Fahrzeuge!A21,A18)","v":0},{"$f":"IF(Fahrzeuge!$B21>\"\",CONCATENATE(LEFT(RIGHT(Fahrzeuge!C21,4),3),\" \",Fahrzeuge!B21),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B21>\"\",Fahrzeuge!G21,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B21>\"\",Fahrzeuge!H21,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B21>\"\",Fahrzeuge!K21,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!B22>\"\",Fahrzeuge!A22,A19)","v":0},{"$f":"IF(Fahrzeuge!$B22>\"\",CONCATENATE(LEFT(RIGHT(Fahrzeuge!C22,4),3),\" \",Fahrzeuge!B22),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B22>\"\",Fahrzeuge!G22,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B22>\"\",Fahrzeuge!H22,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B22>\"\",Fahrzeuge!K22,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!B23>\"\",Fahrzeuge!A23,A20)","v":0},{"$f":"IF(Fahrzeuge!$B23>\"\",CONCATENATE(LEFT(RIGHT(Fahrzeuge!C23,4),3),\" \",Fahrzeuge!B23),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B23>\"\",Fahrzeuge!G23,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B23>\"\",Fahrzeuge!H23,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B23>\"\",Fahrzeuge!K23,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!B24>\"\",Fahrzeuge!A24,A21)","v":0},{"$f":"IF(Fahrzeuge!$B24>\"\",CONCATENATE(LEFT(RIGHT(Fahrzeuge!C24,4),3),\" \",Fahrzeuge!B24),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B24>\"\",Fahrzeuge!G24,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B24>\"\",Fahrzeuge!H24,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B24>\"\",Fahrzeuge!K24,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!B25>\"\",Fahrzeuge!A25,A22)","v":0},{"$f":"IF(Fahrzeuge!$B25>\"\",CONCATENATE(LEFT(RIGHT(Fahrzeuge!C25,4),3),\" \",Fahrzeuge!B25),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B25>\"\",Fahrzeuge!G25,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B25>\"\",Fahrzeuge!H25,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B25>\"\",Fahrzeuge!K25,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!B26>\"\",Fahrzeuge!A26,A23)","v":0},{"$f":"IF(Fahrzeuge!$B26>\"\",CONCATENATE(LEFT(RIGHT(Fahrzeuge!C26,4),3),\" \",Fahrzeuge!B26),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B26>\"\",Fahrzeuge!G26,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B26>\"\",Fahrzeuge!H26,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B26>\"\",Fahrzeuge!K26,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!B27>\"\",Fahrzeuge!A27,A24)","v":0},{"$f":"IF(Fahrzeuge!$B27>\"\",CONCATENATE(LEFT(RIGHT(Fahrzeuge!C27,4),3),\" \",Fahrzeuge!B27),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B27>\"\",Fahrzeuge!G27,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B27>\"\",Fahrzeuge!H27,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B27>\"\",Fahrzeuge!K27,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!B28>\"\",Fahrzeuge!A28,A25)","v":0},{"$f":"IF(Fahrzeuge!$B28>\"\",CONCATENATE(LEFT(RIGHT(Fahrzeuge!C28,4),3),\" \",Fahrzeuge!B28),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B28>\"\",Fahrzeuge!G28,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B28>\"\",Fahrzeuge!H28,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B28>\"\",Fahrzeuge!K28,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!B29>\"\",Fahrzeuge!A29,A26)","v":0},{"$f":"IF(Fahrzeuge!$B29>\"\",CONCATENATE(LEFT(RIGHT(Fahrzeuge!C29,4),3),\" \",Fahrzeuge!B29),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B29>\"\",Fahrzeuge!G29,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B29>\"\",Fahrzeuge!H29,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B29>\"\",Fahrzeuge!K29,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!B30>\"\",Fahrzeuge!A30,A27)","v":0},{"$f":"IF(Fahrzeuge!$B30>\"\",CONCATENATE(LEFT(RIGHT(Fahrzeuge!C30,4),3),\" \",Fahrzeuge!B30),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B30>\"\",Fahrzeuge!G30,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B30>\"\",Fahrzeuge!H30,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B30>\"\",Fahrzeuge!K30,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!B31>\"\",Fahrzeuge!A31,A28)","v":0},{"$f":"IF(Fahrzeuge!$B31>\"\",CONCATENATE(LEFT(RIGHT(Fahrzeuge!C31,4),3),\" \",Fahrzeuge!B31),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B31>\"\",Fahrzeuge!G31,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B31>\"\",Fahrzeuge!H31,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B31>\"\",Fahrzeuge!K31,\"\")","v":""}]
[{"$f":"IF(Fahrzeuge!B32>\"\",Fahrzeuge!A32,A29)","v":0},{"$f":"IF(Fahrzeuge!$B32>\"\",CONCATENATE(LEFT(RIGHT(Fahrzeuge!C32,4),3),\" \",Fahrzeuge!B32),\"\")","v":""},{"$f":"IF(Fahrzeuge!$B32>\"\",Fahrzeuge!G32,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B32>\"\",Fahrzeuge!H32,\"\")","v":""},{"$f":"IF(Fahrzeuge!$B32>\"\",Fahrzeuge!K32,\"\")","v":""}]
[{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!B7>\"\",A30+1,A30)","v":0},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B7>\"\",'LKW, Busse, Sonderfahrzeuge'!$B7,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B7>\"\",'LKW, Busse, Sonderfahrzeuge'!F7,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B7>\"\",'LKW, Busse, Sonderfahrzeuge'!G7,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B7>\"\",'LKW, Busse, Sonderfahrzeuge'!J7,\"\")","v":""}]
[{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!B9>\"\",A31+1,A31)","v":0},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B9>\"\",'LKW, Busse, Sonderfahrzeuge'!$B9,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B9>\"\",'LKW, Busse, Sonderfahrzeuge'!F9,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B9>\"\",'LKW, Busse, Sonderfahrzeuge'!G9,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B9>\"\",'LKW, Busse, Sonderfahrzeuge'!J9,\"\")","v":""}]
[{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!B11>\"\",A32+1,A32)","v":0},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B11>\"\",'LKW, Busse, Sonderfahrzeuge'!$B11,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B11>\"\",'LKW, Busse, Sonderfahrzeuge'!F11,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B11>\"\",'LKW, Busse, Sonderfahrzeuge'!G11,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B11>\"\",'LKW, Busse, Sonderfahrzeuge'!J11,\"\")","v":""}]
[{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!B13>\"\",A33+1,A33)","v":0},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B13>\"\",'LKW, Busse, Sonderfahrzeuge'!$B13,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B13>\"\",'LKW, Busse, Sonderfahrzeuge'!F13,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B13>\"\",'LKW, Busse, Sonderfahrzeuge'!G13,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B13>\"\",'LKW, Busse, Sonderfahrzeuge'!J13,\"\")","v":""}]
[{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!B15>\"\",A34+1,A34)","v":0},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B15>\"\",'LKW, Busse, Sonderfahrzeuge'!$B15,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B15>\"\",'LKW, Busse, Sonderfahrzeuge'!F15,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B15>\"\",'LKW, Busse, Sonderfahrzeuge'!G15,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B15>\"\",'LKW, Busse, Sonderfahrzeuge'!J15,\"\")","v":""}]
[{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!B17>\"\",A35+1,A35)","v":0},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B17>\"\",'LKW, Busse, Sonderfahrzeuge'!$B17,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B17>\"\",'LKW, Busse, Sonderfahrzeuge'!F17,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B17>\"\",'LKW, Busse, Sonderfahrzeuge'!G17,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B17>\"\",'LKW, Busse, Sonderfahrzeuge'!J17,\"\")","v":""}]
[{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!B19>\"\",A36+1,A36)","v":0},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B19>\"\",'LKW, Busse, Sonderfahrzeuge'!$B19,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B19>\"\",'LKW, Busse, Sonderfahrzeuge'!F19,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B19>\"\",'LKW, Busse, Sonderfahrzeuge'!G19,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B19>\"\",'LKW, Busse, Sonderfahrzeuge'!J19,\"\")","v":""}]
[{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!B21>\"\",A37+1,A37)","v":0},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B21>\"\",'LKW, Busse, Sonderfahrzeuge'!$B21,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B21>\"\",'LKW, Busse, Sonderfahrzeuge'!F21,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B21>\"\",'LKW, Busse, Sonderfahrzeuge'!G21,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B21>\"\",'LKW, Busse, Sonderfahrzeuge'!J21,\"\")","v":""}]
[{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!B23>\"\",A38+1,A38)","v":0},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B23>\"\",'LKW, Busse, Sonderfahrzeuge'!$B23,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B23>\"\",'LKW, Busse, Sonderfahrzeuge'!F23,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B23>\"\",'LKW, Busse, Sonderfahrzeuge'!G23,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B23>\"\",'LKW, Busse, Sonderfahrzeuge'!J23,\"\")","v":""}]
[{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!B25>\"\",A39+1,A39)","v":0},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B25>\"\",'LKW, Busse, Sonderfahrzeuge'!$B25,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B25>\"\",'LKW, Busse, Sonderfahrzeuge'!F25,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B25>\"\",'LKW, Busse, Sonderfahrzeuge'!G25,\"\")","v":""},{"$f":"IF('LKW, Busse, Sonderfahrzeuge'!$B25>\"\",'LKW, Busse, Sonderfahrzeuge'!J25,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!$B6>\"\",A40+1,A40)","v":0},{"$f":"IF(Ladeinfrastruktur!$B6>\"\",Ladeinfrastruktur!B6,\"\")","v":""},{"$f":"IF($B41>\"\",Ladeinfrastruktur!C6,\"\")","v":""},{"$f":"IF($B41>\"\",Ladeinfrastruktur!D6,\"\")","v":""},{"$f":"IF($B41>\"\",Ladeinfrastruktur!E6,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!$B8>\"\",A41+1,A41)","v":0},{"$f":"IF(Ladeinfrastruktur!$B8>\"\",Ladeinfrastruktur!B8,\"\")","v":""},{"$f":"IF($B42>\"\",Ladeinfrastruktur!C8,\"\")","v":""},{"$f":"IF($B42>\"\",Ladeinfrastruktur!D8,\"\")","v":""},{"$f":"IF($B42>\"\",Ladeinfrastruktur!E8,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!$B10>\"\",A42+1,A42)","v":0},{"$f":"IF(Ladeinfrastruktur!$B10>\"\",Ladeinfrastruktur!B10,\"\")","v":""},{"$f":"IF($B43>\"\",Ladeinfrastruktur!C10,\"\")","v":""},{"$f":"IF($B43>\"\",Ladeinfrastruktur!D10,\"\")","v":""},{"$f":"IF($B43>\"\",Ladeinfrastruktur!E10,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!$B12>\"\",A43+1,A43)","v":0},{"$f":"IF(Ladeinfrastruktur!$B12>\"\",Ladeinfrastruktur!B12,\"\")","v":""},{"$f":"IF($B44>\"\",Ladeinfrastruktur!C12,\"\")","v":""},{"$f":"IF($B44>\"\",Ladeinfrastruktur!D12,\"\")","v":""},{"$f":"IF($B44>\"\",Ladeinfrastruktur!E12,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!$B14>\"\",A44+1,A44)","v":0},{"$f":"IF(Ladeinfrastruktur!$B14>\"\",Ladeinfrastruktur!B14,\"\")","v":""},{"$f":"IF($B45>\"\",Ladeinfrastruktur!C14,\"\")","v":""},{"$f":"IF($B45>\"\",Ladeinfrastruktur!D14,\"\")","v":""},{"$f":"IF($B45>\"\",Ladeinfrastruktur!E14,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!$B16>\"\",A45+1,A45)","v":0},{"$f":"IF(Ladeinfrastruktur!$B16>\"\",Ladeinfrastruktur!B16,\"\")","v":""},{"$f":"IF($B46>\"\",Ladeinfrastruktur!C16,\"\")","v":""},{"$f":"IF($B46>\"\",Ladeinfrastruktur!D16,\"\")","v":""},{"$f":"IF($B46>\"\",Ladeinfrastruktur!E16,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!$B18>\"\",A46+1,A46)","v":0},{"$f":"IF(Ladeinfrastruktur!$B18>\"\",Ladeinfrastruktur!B18,\"\")","v":""},{"$f":"IF($B47>\"\",Ladeinfrastruktur!C18,\"\")","v":""},{"$f":"IF($B47>\"\",Ladeinfrastruktur!D18,\"\")","v":""},{"$f":"IF($B47>\"\",Ladeinfrastruktur!E18,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!$B20>\"\",A47+1,A47)","v":0},{"$f":"IF(Ladeinfrastruktur!$B20>\"\",Ladeinfrastruktur!B20,\"\")","v":""},{"$f":"IF($B48>\"\",Ladeinfrastruktur!C20,\"\")","v":""},{"$f":"IF($B48>\"\",Ladeinfrastruktur!D20,\"\")","v":""},{"$f":"IF($B48>\"\",Ladeinfrastruktur!E20,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!$B22>\"\",A48+1,A48)","v":0},{"$f":"IF(Ladeinfrastruktur!$B22>\"\",Ladeinfrastruktur!B22,\"\")","v":""},{"$f":"IF($B49>\"\",Ladeinfrastruktur!C22,\"\")","v":""},{"$f":"IF($B49>\"\",Ladeinfrastruktur!D22,\"\")","v":""},{"$f":"IF($B49>\"\",Ladeinfrastruktur!E22,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!$B24>\"\",A49+1,A49)","v":0},{"$f":"IF(Ladeinfrastruktur!$B24>\"\",Ladeinfrastruktur!B24,\"\")","v":""},{"$f":"IF($B50>\"\",Ladeinfrastruktur!C24,\"\")","v":""},{"$f":"IF($B50>\"\",Ladeinfrastruktur!D24,\"\")","v":""},{"$f":"IF($B50>\"\",Ladeinfrastruktur!E24,\"\")","v":""}]
[{"$f":"IF('spezielle Ladeinfrastruktur'!$B7>\"\",A50+1,A50)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!$B7>\"\",'spezielle Ladeinfrastruktur'!B7,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B7>\"\",'spezielle Ladeinfrastruktur'!C7,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B7>\"\",'spezielle Ladeinfrastruktur'!D7,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B7>\"\",'spezielle Ladeinfrastruktur'!E7,\"\")","v":""}]
[{"$f":"IF('spezielle Ladeinfrastruktur'!$B9>\"\",A51+1,A51)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!$B9>\"\",'spezielle Ladeinfrastruktur'!B9,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B9>\"\",'spezielle Ladeinfrastruktur'!C9,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B9>\"\",'spezielle Ladeinfrastruktur'!D9,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B9>\"\",'spezielle Ladeinfrastruktur'!E9,\"\")","v":""}]
[{"$f":"IF('spezielle Ladeinfrastruktur'!$B11>\"\",A52+1,A52)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!$B11>\"\",'spezielle Ladeinfrastruktur'!B11,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B11>\"\",'spezielle Ladeinfrastruktur'!C11,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B11>\"\",'spezielle Ladeinfrastruktur'!D11,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B11>\"\",'spezielle Ladeinfrastruktur'!E11,\"\")","v":""}]
[{"$f":"IF('spezielle Ladeinfrastruktur'!$B13>\"\",A53+1,A53)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!$B13>\"\",'spezielle Ladeinfrastruktur'!B13,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B13>\"\",'spezielle Ladeinfrastruktur'!C13,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B13>\"\",'spezielle Ladeinfrastruktur'!D13,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B13>\"\",'spezielle Ladeinfrastruktur'!E13,\"\")","v":""}]
[{"$f":"IF('spezielle Ladeinfrastruktur'!$B15>\"\",A54+1,A54)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!$B15>\"\",'spezielle Ladeinfrastruktur'!B15,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B15>\"\",'spezielle Ladeinfrastruktur'!C15,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B15>\"\",'spezielle Ladeinfrastruktur'!D15,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B15>\"\",'spezielle Ladeinfrastruktur'!E15,\"\")","v":""}]
[{"$f":"IF('spezielle Ladeinfrastruktur'!$B17>\"\",A55+1,A55)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!$B17>\"\",'spezielle Ladeinfrastruktur'!B17,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B17>\"\",'spezielle Ladeinfrastruktur'!C17,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B17>\"\",'spezielle Ladeinfrastruktur'!D17,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B17>\"\",'spezielle Ladeinfrastruktur'!E17,\"\")","v":""}]
[{"$f":"IF('spezielle Ladeinfrastruktur'!$B19>\"\",A56+1,A56)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!$B19>\"\",'spezielle Ladeinfrastruktur'!B19,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B19>\"\",'spezielle Ladeinfrastruktur'!C19,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B19>\"\",'spezielle Ladeinfrastruktur'!D19,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B19>\"\",'spezielle Ladeinfrastruktur'!E19,\"\")","v":""}]
[{"$f":"IF('spezielle Ladeinfrastruktur'!$B21>\"\",A57+1,A57)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!$B21>\"\",'spezielle Ladeinfrastruktur'!B21,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B21>\"\",'spezielle Ladeinfrastruktur'!C21,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B21>\"\",'spezielle Ladeinfrastruktur'!D21,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B21>\"\",'spezielle Ladeinfrastruktur'!E21,\"\")","v":""}]
[{"$f":"IF('spezielle Ladeinfrastruktur'!$B23>\"\",A58+1,A58)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!$B23>\"\",'spezielle Ladeinfrastruktur'!B23,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B23>\"\",'spezielle Ladeinfrastruktur'!C23,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B23>\"\",'spezielle Ladeinfrastruktur'!D23,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B23>\"\",'spezielle Ladeinfrastruktur'!E23,\"\")","v":""}]
[{"$f":"IF('spezielle Ladeinfrastruktur'!$B25>\"\",A59+1,A59)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!$B25>\"\",'spezielle Ladeinfrastruktur'!B25,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B25>\"\",'spezielle Ladeinfrastruktur'!C25,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B25>\"\",'spezielle Ladeinfrastruktur'!D25,\"\")","v":""},{"$f":"IF('spezielle Ladeinfrastruktur'!$B25>\"\",'spezielle Ladeinfrastruktur'!E25,\"\")","v":""}]
[null,null,null,"Summe:",{"$f":"ROUND(SUM(E11:E60),0)","v":0}]