{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["Projektdaten","Fahrzeugklasse N1, N2","N2, N3, Umrüstungen","Ladeinfrastruktur","spezielle Ladeinfrastruktur","Vorlage für AZA"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":31,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Projektdaten","index":0,"n_rows":43,"n_cols":21,"rows_kept":43,"cut":false,"hidden":false,"merged":[[34,1,42,1],[20,0,42,0],[0,0,0,4],[3,0,17,6],[19,0,19,3],[1,0,1,4],[20,1,24,1],[25,1,33,1]]}
["Tabelle zur Ermittlung der förderfähigen Ausgaben (EfA)"]
["Anlage 2 zum Aufruf zur Antragseinreichung zur Förderung von elektrischen Nutzfahrzeugen für Handwerksunternehmen und KMU (08/2020)\n"]
[]
["Mithilfe dieser Tabelle können Sie die Grundlage für Ihre Förderung berechnen. Die Fördersumme berechnet sich aus der Multiplikation der hier berechneten förderfähigen Ausgaben mit der Förderquote. Bitte befüllen Sie diese Anlage, bevor Sie den Antrag in easy-Online ausfüllen. Im Reiter \"Fahrzeuge N1\" finden Sie als Auswahlfeld alle Fahrzeuge, für die aktuelle Preislisten veröffentlicht wurden. Für diese Fahrzeuge werden Pauschalen ausgezahlt. Nur wenn das Fahrzeug, welches Sie beantragen möchten, nicht darunter ist, können Sie es im Reiter \"N2, N3; Umrüstungen\" selbst eingeben.\n\nÜbertragung in easy-Online:\nIm letzten Reiter \"Vorlage für AZA\" finden Sie eine Aufstellung Ihrer Fördergegenstände. Bitte übertragen Sie diese in Ihr easy-Online Formular unter der Rubrik \"Gesamtfinanzierung\". Als \"Preis € / Stück\" werden die förderfähigen Ausgaben aus der EfA-Tabelle eingetragen.\n\nÜbermitteln Sie uns die Tabelle bitte in drei Varianten:\n1. Im pdf-Format als Anhang zum easy-Online Antrag, \n2. als Ausdruck per Post als Anlage zum Antrag sowie\n3. im Excel-Format per E-Mail für die Begleitforschung an: elektromobilitaet@now.de"]
{"$rows_empty":15}
["Übersichtsblatt Stammdaten - Bitte tragen Sie Ihre Projektdaten ein",{"$nulls":14},"JAoNEIN","Antragsteller","Raumkategorie","Einsatzkontext","Standortyp","Beschilderung"]
["Projekt","Allgemeine Infornationen","Projekt-Kurzbezeichnung (Akronym)",{"$nulls":12},"Ja","gewerblich","Großstadt/Metropolregion > 500.000 EW","Carsharing (1P)","Firmenparkplatz (Flotte)","Negative Beschilderung mit Zeichen 286,  290.1"]
[null,null,"Projekt-Beschreibung (Titel)",{"$nulls":12},"Nein","kommunal","Großstadt > 100.000 EW","CarSharing (Float)","Halböffentlich","Positive Beschilderung mit Zeichen 314, 314.1, 315"]
[null,null,"Ausführende Institution",{"$nulls":14},"Mittelstadt > 50.000 EW","Carsharing (nP)","Öffentlich am Wohnort","Nein"]
[null,null,"Raumkategorie",{"$nulls":14},"Kleinstadt > 10.000 EW","Dienstwagen","Öffentlich zentral"]
[null,null,"Gibt es einen Bezug zu einem aktuell eingereichten Forschungs- und Entwicklungsprojekt?",{"$nulls":14},"Stadt/Gemeinde < 10.000 EW","Flotte (Firmen)","Privat"]
[null,"Fahrzeug","Anzahl Fahrzeuge im gesamten Fuhrpark",{"$nulls":14},"Landgemeinde","Flotte (Kommunal)","Firmenparkplatz (private Nutzung)"]
[null,null,"             davon bereits E-Fahrzeuge",{"$nulls":14},"ausserhalb einer Ansiedlung","Flotte (Mietwagen)","Firmen- oder Betriebsgelände "]
[null,null,"Einsatzkontext",{"$nulls":15},"Kombination"]
[null,null,"Planen sie weitere Umstellungen auf alternative Antriebe innerhalb ihrer Flotte bis 2025 (bezogen auf die Gesamtanzahl in Zeile 26)?",{"$nulls":15},"ÖPNV-Flotte"]
[null,null,"Falls ja: Anzahl der Umstellung in den kommenden 1-2 Jahren (2021/22)",{"$nulls":15},"Privatwagen"]
[null,null,"Falls ja: Anzahl der Umstellung in den darauffolgenden 1-3 Jahren (2023 – 2025)",{"$nulls":15},"Lieferverkehr"]
[null,null,"Ersetzen die beantragten E-Fahrzeuge  vorhandene konventionelle Fahrzeuge?",{"$nulls":15},"Taxi"]
[null,null,"Fahren Ihre Fahrzeuge überwiegend im Stadtgebiet?",{"$nulls":15},"Leasing"]
[null,null,"An wievielen Tagen im Jahr werden die E-Fahrzeuge durchschnittlich im Einsatz sein?"]
[null,"Ladeinfrastruktur","Haben Sie bereits vorhandene Ladeinfrastruktur?"]
[null,null,"Falls ja, wieviele Ladepunkte?"]
[null,null,"Standorttyp der geplanten LIS"]
[null,null,"Wird die LIS öffentlich zugänglich?"]
[null,null,"Planen Sie eine Beschilderung des Parkplatzes?"]
[null,null,"Planen Sie den Parkplatz mit Parkraumsensoren auszustatten?"]
[null,null,"Planen Sie die Errichtung weiterer Ladepunkte?"]
[null,null,"Falls ja: Wie viele Ladepunkte in den kommenden 1-2 Jahren (2021-22)?"]
[null,null,"Falls ja: Wie viele Ladepunkte in den darauffolgenden 1-3 Jahren (2023-25)?"]

{"sheet":"Fahrzeugklasse N1, N2","index":1,"n_rows":83,"n_cols":23,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
["Tabelle zur Ermittlung der förderfähigen Ausgaben (EfA)",null,null,"ja","nein",null,"Stand: 09.09.2021",null,"FKZ: 03EMIN"]
["Hinweise:",{"$nulls":5},"korrigiert: 18.06.2021"]
["Die Registerkarte 'Vorlage für AZA' stellt Ihre Eingaben so dar, wie sie in das easy-Online-Formular eingetragen werden müssen.",{"$nulls":5},"ergänzt: 25.08.2023"]
[]
["Wählen Sie in der Liste unten die gewünschten Fahrzeuge (Auswahlbox) und die entsprechende Anzahl aus. "]
["Für Ladeinfrastruktur sowie Fahrzeuge der Klassen N2, N3 und Umrüstungen wählen Sie bitte die entsprechenden Registerkarten."]
["Speichern Sie die ausgefüllten Arbeitsblätter im pdf-Format und fügen Sie sie dem Antrag bei."]
["Grün unterlegte Felder sind Eingabefelder."]
[{"$nulls":13},0.16]
["Pos.","Typ E-Fahrzeug\n[Auswahlbox]","Nettopreis\nE-Fahrzeug","Typ Referenzfahrzeug","Nettopreis\nReferenzfahrzeug in Euro","Förderfähige Ausgaben pro Fahrzeug (netto) in Euro","Anzahl zu beschaffender Fahrzeuge des Typs","erwartete durchschnittliche Jahres-Fahrleistung pro Fahrzeug in km","Förderfähige Ausgaben in Euro ","Korrekturfeld PtJ"]
[1,null,{"$f":"IF($B11>0,VLOOKUP($B11,$L$34:$U$81,2,0),\"\")","v":""},{"$f":"IF($B11>0,VLOOKUP($B11,$L$34:$U$81,4,0),\"\")","v":""},{"$f":"IF($B11>0,VLOOKUP($B11,$L$34:$U$81,5,0),\"\")","v":""},{"$f":"IF(B11>0,VLOOKUP($B11,$L$34:$S$81,7,0),\"\")","v":""},3,null,{"$f":"IF(B11>0,F11*G11,\"\")","v":""}]
[{"$f":"A11+1","v":2},null,"","","","",null,null,""]
[{"$f":"A12+1","v":3},null,"","","","",null,null,""]
[{"$f":"A13+1","v":4},null,"","","","",null,null,""]
[{"$f":"A14+1","v":5},null,"","","","",null,null,""]
[{"$f":"A15+1","v":6},null,"","","","",null,null,""]
[7,null,"","","","",null,null,""]
[8,null,"","","","",null,null,""]
[{"$f":"A18+1","v":9},null,"","","","",null,null,""]
[10,null,"","","","",null,null,""]
[11,null,"","","","",null,null,""]
[12,null,"","","","",null,null,""]
[{"$f":"A22+1","v":13},null,"","","","",null,null,""]
[14,null,"","","","",null,null,""]
[15,null,"","","","",null,null,""]
[16,null,"","","","",null,null,""]
[{"$f":"A26+1","v":17},null,"","","","",null,null,""]
[{"$f":"A27+1","v":18},null,"","","","",null,null,""]
[{"$f":"A28+1","v":19},null,"","","","",null,null,""]
[{"$f":"A29+1","v":20},null,"","","","",null,null,""]
["Summe",{"$nulls":7},{"$f":"SUM(I11:I30)","v":0}]
[null,"die Formulierung \"alle N1-Versionen\" schließt auch aufgelastete Fahrzeuge mit N2-Zulassung mit ein."]
[{"$nulls":11},"E-Fahrzeug","E-Listenpreis netto","E-Listenpreis brutto","Vergleichsfahrzeug","Listenpreis netto","Listenpreis brutto","förderfähig netto","förderfähig brutto","Info Segment","Fahrzeugklassen Abkürzung",null,"Eingefügt/korrigiert"]
[{"$nulls":11},"ARI 901 (alle N1-Versionen)",29800,{"$f":"ROUND(M34*(1+$N$9),2)","v":34568},"Nissan NV200 Kasten",15350,{"$f":"ROUND(P34*(1+$N$9),2)","v":17806},{"$f":"ROUND(M34-P34,0)","v":14450},16762,"Utility","NFZ"]
[{"$nulls":11},"CITROËN E-JUMPY 50kWh (alle N1-Versionen)",35250,40890,"CITROËN E-JUMPY Blue HDi 120 90 kW",26500,{"$f":"P35*1.16","v":30739.999999999996},8750,10150,"Utility","NFZ","Vergleichsbasis: CITROËN E-JUMPY M 50kWh (Control)","2020-08-20"]
[{"$nulls":11},"CITROËN E-JUMPY 75kWh (alle N1-Versionen)",40250,46690,"CITROËN E-JUMPY Blue HDi 120 90 kW",26500,{"$f":"P36*1.16","v":30739.999999999996},13750,15950,"Utility","NFZ","Vergleichsbasis: CITROËN E-JUMPY M 75kWh (Control)","2020-08-20"]
[{"$nulls":11},"CITROËN Berlingo Electric L1",{"$f":"ROUND(N37/1.19,2)","v":20990},24978.1,"Citroën Berlingo L1",{"$f":"ROUND(Q37/1.19,2)","v":14500},17255,6490,7723,"Utility (N1)","NFZ",null,"2021-09-09"]
[{"$nulls":11},"CITROËN Berlingo Electric L1, Batterie zur Miete",15690,18671.099999999999,"Citroën Berlingo L1",14500,17255,1190,1416,"Utility (N1)","NFZ",null,"2021-09-09"]
[{"$nulls":11},"CITROËN Berlingo Electric L2",22040,26227.599999999999,"Citroën Berlingo L2",15350,18266.5,6690,7961,"Utility (N1)","NFZ",null,"2021-09-09"]
[{"$nulls":11},"CITROËN Berlingo Electric L2, Batterie zur Miete",16740,19920.599999999999,"Citroën Berlingo L2",15350,18266.5,1390,1654,"Utility (N1)","NFZ",null,"2021-09-09"]
[{"$nulls":11},"EVUM aCar (alle N1-Versionen)",28990,33628.400000000001,"Piaggio Porter Maxxi Chassis",16302.52,{"$f":"ROUND(P41*1.16,2)","v":18910.919999999998},12687,14717,"Utility","NFZ",null,"2020-08-20"]
[{"$nulls":11},"Fiat E-Ducato 47 kWh (alle N1/N2-Versionen)",56000,64960,"Fiat Ducato 88 KW",30840,35774.400000000001,{"$f":"ROUND(M42-P42,0)","v":25160},{"$f":"ROUND(N42-Q42,0)","v":29186},"Utility","NFZ","Vergleich L2H2 N2-Version als Ausstattungsvariante, da sonst schlechter gefördert und keine Version mit passender Zuladung als Vergleich verfügbar","2020-08-10"]
[{"$nulls":11},"Fiat E-Ducato 79 kWh (alle N1/N2-Versionen)",73000,84680,"Fiat Ducato 88 KW",30840,35774.400000000001,42160,48906,"Utility","NFZ","Vergleich L2H2 N2-Version als Ausstattungsvariante, da sonst schlechter gefördert und keine Version mit passender Zuladung als Vergleich verfügbar","2020-08-10"]
[{"$nulls":11},"Ford e-Transit (alle N1/N2 -Versionen)",57920,67187.199999999997,"Ford Transit (gleiche Nutzlast + Radstand)",37720,43755.199999999997,20200,23432,"Utility","NFZ","Mittelwert aus allen verfügbaren Modellen mit vorhandenem VGL-Fzg. Bei 4,25t-Variante fehlt vergleichbarer Verbrenner","2022-03-01"]
[{"$nulls":11},"ISEKI Goupil G4 (9 kWh) (alle N1-Versionen)",{"$f":"28486.55+1035.29+359.66","v":29881.5},34662.54,"Piaggio Porter Chassis",13193.28,15304.2,16688,19358,"Utility","NFZ"]
[{"$nulls":11},"ISEKI Goupil G4 (13,8 kWh) (alle N1-Versionen)",{"$f":"32268.07+1035.29+359.66","v":33663.020000000004},39049.1,"Piaggio Porter Chassis",13193.28,15304.2,{"$f":"ROUND(M46-P46,0)","v":20470},{"$f":"ROUND(N46-Q46,0)","v":23745},"Utility","NFZ"]
[{"$nulls":11},"ISEKI Goupil G5 (11,5 kWh) (alle N1-Versionen)",34967.230000000003,40561.99,"Piaggio Porter Chassis",13193.28,15304.2,{"$f":"ROUND(M47-P47,0)","v":21774},25258,"Utility","NFZ"]
[{"$nulls":11},"ISEKI Goupil G5 (19,2 kWh) (alle N1-Versionen)",44294.96,51382.15,"Piaggio Porter Chassis",13193.28,15304.2,31102,36078,"Utility","NFZ"]
[{"$nulls":11},"MAN e-TGE",null,null,"wie VW e-Crafter ",null,null,{"$f":"R80","v":18900},{"$f":"S80","v":22491},"Utility","NFZ",44250]
[{"$nulls":11},"Maxus EV 80 (alle N1-Versionen)",52400,60784,"Maxus Deliver 9",29990,{"$f":"ROUND(P50*(1+$N$9),2)","v":34788.400000000001},{"$f":"ROUND(M50-P50,0)","v":22410},{"$f":"ROUND(N50-Q50,0)","v":25996},"Utility","NFZ","Vergleich mit Deliver 9 aus eigenem Hause, Fahrgestell wie Panelvan","2020-08-10"]
[{"$nulls":11},"MAXUS eDELIVER 72 kWh (alle N1-Versionen)",64490,74808.399999999994,"Maxus Deliver 9",36490,42328.4,28000,{"$f":"ROUND(N51-Q51,0)","v":32480},"Utility","NFZ",null,"2023-08-25"]
[{"$nulls":11},"MAXUS eDELIVER 89 kWh (alle N1-Versionen)",{"$f":"64490+7500","v":71990},{"$f":"ROUND(M52*(1+$N$9),2)","v":83508.399999999994},"Maxus Deliver 9",36490,42328.4,{"$f":"ROUND(M52-P52,0)","v":35500},{"$f":"ROUND(N52-Q52,0)","v":41180},"Utility","NFZ",null,"2023-08-25"]
[{"$nulls":11},"Mercedes Benz eVito (alle N1-Versionen)",44990,52188.4,"Mercedes Benz Vito Kasten Worker",18990,22028.400000000001,{"$f":"ROUND(M53-P53,0)","v":26000},30160,"Utility","NFZ"]
[{"$nulls":11},"Mercedes Benz eSprinter 35 kWh (alle N1/N2-Versionen)",53900,62524,"Mercedes Benz Sprinter Kasten 211 CDI",32485,37682.6,{"$f":"ROUND(M54-P54,0)","v":21415},{"$f":"ROUND(N54-Q54,0)","v":24841},"Utility","NFZ","A2 Hochdach, installierte Kapazität 41 kWh"]
[{"$nulls":11},"Mercedes Benz eSprinter 47 kWh (alle N1/N2-Versionen)",61273,{"$f":"ROUND(M55*(1+$N$9),2)","v":71076.679999999993},"Mercedes Benz Sprinter Kasten 211 CDI",32485,{"$f":"ROUND(P55*(1+$N$9),2)","v":37682.6},{"$f":"ROUND(M55-P55,0)","v":28788},{"$f":"ROUND(N55-Q55,0)","v":33394},"Utility","NFZ","A2 Hochdach, installierte Kapazität 55 kWh","2020-08-20"]
[{"$nulls":11},"Nissan e-NV200 Kasten (alle N1-Versionen)",28660,0,"Nissan NV200 Kasten",15350,17806,13310,-17806,"Utility","NFZ","Nissan NV 200 ist nicht mehr erhältlich, Nachfolger Nissan NV 250"]
[{"$nulls":11},"Nissan Townstar EV (alle N1-Versionen)",33750,{"$f":"ROUND(M57*(1.19),2)","v":40162.5},"Nissan Townstar Visia ",20210,{"$f":"ROUND(P57*(1.19),2)","v":24049.9},13540,16113,"Utility","NFZ",null,"2023-01-23"]
[{"$nulls":11},"Opel Vivaro-E  50 kWh (alle N1-Versionen)",36240,42038.400000000001,"Opel Vivaro Cargo M 90 kW",28280,32804.800000000003,7960,9234,"Utility","NFZ"]
[{"$nulls":11},"Opel Vivaro-E 75 kWh (alle N1 Versionen)",41240,47838.400000000001,"Opel Vivaro Cargo M 90 kW",28280,32804.800000000003,12960,15034,"Utility","NFZ"]
[{"$nulls":11},"Peugeot Partner electrique (L1) (alle N1-Versionen)",21290,24696.400000000001,"Peugeot Partner (L1) BlueHDi 75",16630,19290.8,{"$f":"ROUND(M60-P60,0)","v":4660},5406,"Utility","NFZ"]
[{"$nulls":11},"Peugeot Partner electrique (L2) (alle N1-Versionen)",22340,25914.400000000001,"Peugeot Partner (L2) Blue Hdi 100",19380,22480.799999999999,2960,3434,"Utility","NFZ"]
[{"$nulls":11},"Peugeot E-Expert 50kWh (alle N1-Versionen)",35250,40890,"Peugeot Expert Blue HDi  120 90 kW (Pro)",26500,{"$f":"P62*1.16","v":30739.999999999996},8750,10150,"Utility","NFZ","Vergleich au Basis Peugeot Expert L2 ","2020-08-20"]
[{"$nulls":11},"Peugeot E-Expert 75kWh (alle N1-Versionen)",40250,46690,"Peugeot Expert Blue HDi  120 90 kW (Pro)",26500,{"$f":"P63*1.16","v":30739.999999999996},13750,15950,"Utility","NFZ","Vergleich au Basis Peugeot Expert L2 ","2020-08-20"]
[{"$nulls":11},"Renault Kangoo Z.E. 33 2-Sitzer, mit Batteriemiete (alle N1-Versionen)",20820,{"$f":"ROUND(M64*(1+$N$9),2)","v":24151.200000000001},"Renault Kangoo Rapid Blue dCi 80",17050,{"$f":"ROUND(P64*(1+$N$9),2)","v":19778},{"$f":"ROUND(M64-P64,0)","v":3770},{"$f":"ROUND(N64-Q64,0)","v":4373},"Utility","NFZ"]
[{"$nulls":11},"Renault Kangoo Z.E. 33 2-Sitzer (alle N1-Versionen)",29920,34707.199999999997,"Renault Kangoo Rapid Blue dCi 80",17050,19778,12870,14929,"Utility","NFZ"]
[{"$nulls":11},"Renault Kangoo Maxi Z.E. 33 mit Batteriemiete (alle N1-Versionen)",22020,25543.200000000001,"Renault Kangoo Rapid Maxi Blue dCi 95",19850,23026,2170,2517,"Utility","NFZ"]
[{"$nulls":11},"Renault Kangoo Maxi Z.E. 33 (alle N1-Versionen)",31120,36099.199999999997,"Renault Kangoo Rapid Maxi Blue dCi 95",19850,23026,11270,13073,"Utility","NFZ"]
[{"$nulls":11},"Renault Kangoo III E-Tech (alle N1-Versionen)",33990,{"$f":"ROUND(M68*(1.19),2)","v":40448.1},"Renault Kangoo Rapid III",20580,{"$f":"ROUND(P68*(1.19),2)","v":24490.2},{"$f":"ROUND(M68-P68,0)","v":13410},{"$f":"ROUND(N68-Q68,0)","v":15958},"Utility","NFZ",null,"2023-01-23"]
[{"$nulls":11},"Renault Master Z.E. Kasten (alle N1/N2-Versionen)",64000,74240,"Renault Master Kasten",31990,37108.400000000001,32010,37132,"Utility","NFZ","Korrektur, da falsche Version verglichen, nun beides L2H2","2020-08-10"]
[{"$nulls":11},"Renault Master Z.E. Plattform-FG (alle N1/N2-Versionen)",60850,70586,"Renault Master Plattform-FG",29590,34324.400000000001,31260,36262,"Utility","NFZ","Korrektur, da falsche Werte, beides L2H1","2020-08-10"]
[{"$nulls":11},"Streetscooter Work 40 (alle N1-Versionen)",42750,49590,"Nissan NV200 Kasten",15350,17806,27400,31784,"Utility","NFZ"]
[{"$nulls":11},"Streetscooter Work L 40 (alle N1-Versionen)",47650,{"$f":"ROUND(M72*(1+$N$9),2)","v":55274},"Renault Master Ecoline L1H1 2,8 t",25220,{"$f":"ROUND(P72*(1+$N$9),2)","v":29255.200000000001},{"$f":"ROUND(M72-P72,0)","v":22430},{"$f":"ROUND(N72-Q72,0)","v":26019},"Utility","NFZ"]
[{"$nulls":11},"Toyota Proace Electric 50 kWh (alle N1-Versionen)",36350,{"$f":"ROUND(M73*1.19,2)","v":43256.5},"Toyota Proace 88kW",27200,{"$f":"ROUND(P73*1.19,2)","v":32368},{"$f":"ROUND(M73-P73,0)","v":9150},{"$f":"ROUND(R73*1.19,2)","v":10888.5},"Utility","NFZ"]
[{"$nulls":11},"Toyota Proace Electric 75 kWh (alle N1-Versionen)",41350,{"$f":"ROUND(M74*1.19,2)","v":49206.5},"Toyota Proace 88kW",27200,{"$f":"ROUND(P74*1.19,2)","v":32368},{"$f":"ROUND(M74-P74,0)","v":14150},{"$f":"ROUND(R74*1.19,2)","v":16838.5},"Utility","NFZ"]
[{"$nulls":11},"Tropos Motors ABLE XT1  (13kWh) (alle N1-Versionen)",23000,{"$f":"M75*1.19","v":27370},"Piaggio Porter - Entry Level Chassis",11071.43,{"$f":"ROUNDUP(P75*1.19,2)","v":13175.01},{"$f":"ROUND(M75-P75,0)","v":11929},{"$f":"ROUND(N75-Q75,0)","v":14195},"Utility","NFZ",null,"2021-06-18"]
[{"$nulls":11},"Tropos Motors ABLE XT2 (26kWh) (alle N1-Versionen)",27000,{"$f":"M76*1.19","v":32130},"Piaggio Porter - Entry Level Chassis",11071.43,{"$f":"ROUNDUP(P76*1.19,2)","v":13175.01},15929,{"$f":"ROUND(N76-Q76,0)","v":18955},"Utility","NFZ"]
[{"$nulls":11},"Volkswagen ABT e-Caddy (alle N1-Versionen)",31500,{"$f":"ROUND(M77*1.19,2)","v":37485},"Volkswagen Caddy Kombi 75 kW TDI",22910,{"$f":"ROUND(P77*1.19,2)","v":27262.9},{"$f":"ROUND(M77-P77,0)","v":8590},10222,"Utility","NFZ",null,"2021-02-10"]
[{"$nulls":11},"Volkswagen ABT-e T6.1  Kasten (alle N1-Versionen)",null,null,"Elektrifizierungsumfang",null,null,25184,29969,"Utility","NFZ"]
[{"$nulls":11},"Volkswagen e-Crafter 35 MR EM85 (alle N1/N2-Versionen)",53900,{"$f":"ROUND(M79*(1+$N$9),2)","v":62524},"Crafter 30/35 TL (75 kW)",31800,{"$f":"ROUND(P79*(1+$N$9),2)","v":36888},{"$f":"ROUND(M79-P79,0)","v":22100},{"$f":"ROUND(N79-Q79,0)","v":25636},"Utility","NFZ","Radstand Mittellang mit Hochdach"]
[{"$nulls":11},"Volkswagen ID.Buzz Cargo 77kWh",45740,{"$f":"ROUND(M80*(1.19),2)","v":54430.6},"Caddy Cargo Maxi 2,0 TDI SCR",26840,{"$f":"ROUND(P80*1.19,2)","v":31939.599999999999},18900,22491,"Utility","NFZ",null,"2022-09-20"]
[]
[]
[{"$nulls":21},"Ergänzung bei Fahrzeugen der Sprinterklasse: \"alle N1/N2-Versionen, für die 4,25t-Varianten ","2020-09-09"]

{"sheet":"N2, N3, Umrüstungen","index":2,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,0,2,8],[3,0,3,8]]}
["Ermittlung der förderfähigen Ausgaben (EfA) für die Fahrzeugklassen N2 und N3 sowie Umrüstungen",{"$nulls":8},{"$f":"IF('Fahrzeugklasse N1, N2'!$J$1=0, \" \",\"FKZ: 03EMIN\"&'Fahrzeugklasse N1, N2'!$J$1)","v":" "}]
["Hinweise:"]
["Bitte legen Sie Ihrem Antrag für jeden hier aufgeführten Fahrzeugtyp entsprechende Angebote für das E-Fahrzeug und ein Referenzfahrzeug bei."]
["Möchten Sie eine Umrüstung durchführen lassen, machen Sie bitte im Feld \"Nettopreis Referenzfahrzeug\" keine Eingabe."]
[]
["Pos.","Typ E-Fahrzeug","Nettopreis","Typ Referenzfahrzeug","Nettopreis Referenzfahrzeug","Förderfähige Ausgaben pro Fahrzeug (netto)","Anzahl zu beschaffender Fahrzeuge des Typs","erwartete durchschnittliche Jahres-Fahrleistung in km*","Förderfähige Ausgaben ","Korrekturfeld PtJ"]
[1,{"$nulls":4},{"$f":"IF(B7>\"\",C7-E7,\"\")","v":""},null,null,{"$f":"IF(B7>\"\",F7*G7,\"\")","v":""}]
[]
[2,{"$nulls":4},{"$f":"IF(B9>\"\",C9-E9,\"\")","v":""},null,null,{"$f":"IF(B9>\"\",F9*G9,\"\")","v":""}]
[]
[3,{"$nulls":4},{"$f":"IF(B11>\"\",C11-E11,\"\")","v":""},null,null,{"$f":"IF(B11>\"\",F11*G11,\"\")","v":""}]
[]
[4,{"$nulls":4},{"$f":"IF(B13>\"\",C13-E13,\"\")","v":""},null,null,{"$f":"IF(B13>\"\",F13*G13,\"\")","v":""}]
[]
[5,{"$nulls":4},{"$f":"IF(B15>\"\",C15-E15,\"\")","v":""},null,null,{"$f":"IF(B15>\"\",F15*G15,\"\")","v":""}]
[]
[6,{"$nulls":4},{"$f":"IF(B17>\"\",C17-E17,\"\")","v":""},null,null,{"$f":"IF(B17>\"\",F17*G17,\"\")","v":""}]
[]
[7,{"$nulls":4},{"$f":"IF(B19>\"\",C19-E19,\"\")","v":""},null,null,{"$f":"IF(B19>\"\",F19*G19,\"\")","v":""}]
[]
[8,{"$nulls":4},{"$f":"IF(B21>\"\",C21-E21,\"\")","v":""},null,null,{"$f":"IF(B21>\"\",F21*G21,\"\")","v":""}]
[]
[9,{"$nulls":4},{"$f":"IF(B23>\"\",C23-E23,\"\")","v":""},null,null,{"$f":"IF(B23>\"\",F23*G23,\"\")","v":""}]
[]
[10,{"$nulls":4},{"$f":"IF(B25>\"\",C25-E25,\"\")","v":""},null,null,{"$f":"IF(B25>\"\",F25*G25,\"\")","v":""}]
[]
["Summe",{"$nulls":7},{"$f":"SUM(I7:I25)","v":0}]

{"sheet":"Ladeinfrastruktur","index":3,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,0,2,5]]}
["Ermittlung der förderfähigen Ausgaben (EfA) - Pauschalen für Ladeinfrastruktur",{"$nulls":4},{"$f":"IF('Fahrzeugklasse N1, N2'!$J$1=0, \" \",\"FKZ: 03EMIN\"&'Fahrzeugklasse N1, N2'!$J$1)","v":" "}]
[]
["Bitte wählen Sie die gewünschte Ladeinfrastruktur. Für diese brauchen Sie keine Angebote einreichen."]
[]
["Pos.","Typ Ladeinfrastruktur (LIS)*\n[Auswahlbox]","Förderfähige Ausgaben pro Ladesäule (netto)","Anzahl zu beschaffender Ladesäulen des Typs","Förderfähige Ausgaben ","Korrekturfeld PtJ",null,null,"Typ Ladeinfrastruktur","Ausgabenpauschale netto","Ausgabenpauschale brutto"]
[1,null,{"$f":"IF($B6>0,VLOOKUP($B6,$I$6:$K$12,2,0),\"\")","v":""},null,{"$f":"IF(AND(B6<>\"\",D6>0),C6*D6,\"\")","v":""},null,null,null,"Mobile Ladestationen [AC] ab 3,7 kW (1 Ladepunkt)",500,{"$f":"J6*1.19","v":595}]
[{"$nulls":8},"nicht öff. zugängl. [AC] ab 3,7 kW (1 Ladepunkt)",600,714]
[2,null,{"$f":"IF($B8>0,VLOOKUP($B8,$I$6:$K$12,2,0),\"\")","v":""},null,{"$f":"IF(AND(B8<>\"\",D8>0),C8*D8,\"\")","v":""},null,null,null,"nicht öff. zugängl. [AC] ab 11 kW (min. 2 Ladepunkte)",3000,3570]
[{"$nulls":8},"nicht öff. zugängl. [DC] bis 25 kW ",10000,11900]
[3,null,{"$f":"IF($B10>0,VLOOKUP($B10,$I$6:$K$12,2,0),\"\")","v":""},null,{"$f":"IF(AND(B10<>\"\",D10>0),C10*D10,\"\")","v":""},null,null,null,"nicht öff. zugängl. [DC] 25-50 kW",20000,23800]
[{"$nulls":8},"nicht öff. zugängl. [DC] 51-149 kW",35000,41650]
[4,null,{"$f":"IF($B12>0,VLOOKUP($B12,$I$6:$K$12,2,0),\"\")","v":""},null,{"$f":"IF(AND(B12<>\"\",D12>0),C12*D12,\"\")","v":""},null,null,null,"nicht öff. zugängl. [DC] ab 150 kW",50000,59500]
[]
[5,null,{"$f":"IF($B14>0,VLOOKUP($B14,$I$6:$K$12,2,0),\"\")","v":""},null,{"$f":"IF(AND(B14<>\"\",D14>0),C14*D14,\"\")","v":""}]
[]
[6,null,{"$f":"IF($B16>0,VLOOKUP($B16,$I$6:$K$12,2,0),\"\")","v":""},null,{"$f":"IF(AND(B16<>\"\",D16>0),C16*D16,\"\")","v":""}]
[]
[7,null,{"$f":"IF($B18>0,VLOOKUP($B18,$I$6:$K$12,2,0),\"\")","v":""},null,{"$f":"IF(AND(B18<>\"\",D18>0),C18*D18,\"\")","v":""}]
[]
[8,null,{"$f":"IF($B20>0,VLOOKUP($B20,$I$6:$K$12,2,0),\"\")","v":""},null,{"$f":"IF(AND(B20<>\"\",D20>0),C20*D20,\"\")","v":""}]
[]
[9,null,{"$f":"IF($B22>0,VLOOKUP($B22,$I$6:$K$12,2,0),\"\")","v":""},null,{"$f":"IF(AND(B22<>\"\",D22>0),C22*D22,\"\")","v":""}]
[]
[10,null,{"$f":"IF($B24>0,VLOOKUP($B24,$I$6:$K$12,2,0),\"\")","v":""},null,{"$f":"IF(AND(B24<>\"\",D24>0),C24*D24,\"\")","v":""}]
[]
["Summe",null,null,null,{"$f":"SUM(E6:E24)","v":0}]
[]
["* DC :","Gleichstrom-Ladeinfrastruktur"]
["* AC :","Wechselstrom-Ladeinfrastruktur"]

{"sheet":"spezielle Ladeinfrastruktur","index":4,"n_rows":27,"n_cols":6,"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":4},{"$f":"IF('Fahrzeugklasse N1, N2'!$J$1=0, \" \",\"FKZ: 03EMIN\"&'Fahrzeugklasse N1, N2'!$J$1)","v":" "}]
["Hinweise:"]
["Hierfür müssen Sie entsprechende Angebote für die Ladeinfrastruktur eingeholt haben. Diese Angebote sind beizufügen."]
[]
[]
["Pos.","Typ Ladeinfrastruktur (LIS)","Nettopreis LIS laut beigefügtem Angebot","Anzahl zu beschaffender LIS dieses Typs","Förderfähige Ausgaben ","Korrekturfeld PtJ"]
[1,null,null,null,{"$f":"IF(AND(B7<>\"\",C7>0),D7*C7,\"\")","v":""}]
[]
[2,null,null,null,{"$f":"IF(AND(B9<>\"\",C9>0),D9*C9,\"\")","v":""}]
[]
[3,null,null,null,{"$f":"IF(AND(B11<>\"\",C11>0),D11*C11,\"\")","v":""}]
[]
[4,null,null,null,{"$f":"IF(AND(B13<>\"\",C13>0),D13*C13,\"\")","v":""}]
[]
[5,null,null,null,{"$f":"IF(AND(B15<>\"\",C15>0),D15*C15,\"\")","v":""}]
[]
[6,null,null,null,{"$f":"IF(AND(B17<>\"\",C17>0),D17*C17,\"\")","v":""}]
[]
[7,null,null,null,{"$f":"IF(AND(B19<>\"\",C19>0),D19*C19,\"\")","v":""}]
[]
[8,null,null,null,{"$f":"IF(AND(B21<>\"\",C21>0),D21*C21,\"\")","v":""}]
[]
[9,null,null,null,{"$f":"IF(AND(B23<>\"\",C23>0),D23*C23,\"\")","v":""}]
[]
[10,null,null,null,{"$f":"IF(AND(B25<>\"\",C25>0),D25*C25,\"\")","v":""}]
[]
["Summe",null,null,null,{"$f":"SUM(E7:E26)","v":0}]

{"sheet":"Vorlage für AZA","index":5,"n_rows":60,"n_cols":5,"rows_kept":60,"cut":false,"hidden":false,"merged":[[6,0,6,7],[5,0,5,7],[1,0,1,4]]}
["Hinweis:",null,null,null,{"$f":"IF('Fahrzeugklasse N1, N2'!$J$1=0, \" \",\"FKZ: 03EMIN\"&'Fahrzeugklasse N1, N2'!$J$1)","v":" "}]
["Vorlage zum Übertragen der Daten aus dieser Tabelle in den AZA-Antrag in easy-Online. "]
["Bitte kopieren Sie die Bezeichung wie hier dargestellt in das easy-Online-Formular (Bezeichnungen werden z.T. abgeschnitten). "]
["Die Anzahl der zu beschaffenden Fahrzeuge/ Ladeinfrastruktur muss ggf. auf die Anschaffungsjahre aufgeteilt werden."]
["Beachten Sie, dass die hier angegebene Summe mit den Gesamtmitteln im easy-Online-Antrag überein stimmen muss."]
["Ignorieren Sie die Warnmeldung bei Eintragung von Beträgen <800€!"]
["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('Fahrzeugklasse N1, N2'!$B11>\"\",'Fahrzeugklasse N1, N2'!A11,0)","v":0},{"$f":"IF('Fahrzeugklasse N1, N2'!$B11>\"\",CONCATENATE('Fahrzeugklasse N1, N2'!U34,\" \",'Fahrzeugklasse N1, N2'!B11),\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B11>\"\",'Fahrzeugklasse N1, N2'!$F11,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B11>\"\",'Fahrzeugklasse N1, N2'!G11,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B11>\"\",'Fahrzeugklasse N1, N2'!I11,\"\")","v":""}]
[{"$f":"IF('Fahrzeugklasse N1, N2'!B12>\"\",'Fahrzeugklasse N1, N2'!A12,A10)","v":0},{"$f":"IF('Fahrzeugklasse N1, N2'!$B12>\"\",CONCATENATE('Fahrzeugklasse N1, N2'!U47,\" \",'Fahrzeugklasse N1, N2'!B12),\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B12>\"\",'Fahrzeugklasse N1, N2'!$F12,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B12>\"\",'Fahrzeugklasse N1, N2'!G12,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B12>\"\",'Fahrzeugklasse N1, N2'!I12,\"\")","v":""}]
[{"$f":"IF('Fahrzeugklasse N1, N2'!B13>\"\",'Fahrzeugklasse N1, N2'!A13,A11)","v":0},{"$f":"IF('Fahrzeugklasse N1, N2'!$B13>\"\",CONCATENATE('Fahrzeugklasse N1, N2'!U48,\" \",'Fahrzeugklasse N1, N2'!B13),\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B13>\"\",'Fahrzeugklasse N1, N2'!$F13,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B13>\"\",'Fahrzeugklasse N1, N2'!G13,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B13>\"\",'Fahrzeugklasse N1, N2'!I13,\"\")","v":""}]
[{"$f":"IF('Fahrzeugklasse N1, N2'!B14>\"\",'Fahrzeugklasse N1, N2'!A14,A12)","v":0},{"$f":"IF('Fahrzeugklasse N1, N2'!$B14>\"\",CONCATENATE('Fahrzeugklasse N1, N2'!U53,\" \",'Fahrzeugklasse N1, N2'!B14),\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B14>\"\",'Fahrzeugklasse N1, N2'!$F14,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B14>\"\",'Fahrzeugklasse N1, N2'!G14,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B14>\"\",'Fahrzeugklasse N1, N2'!I14,\"\")","v":""}]
[{"$f":"IF('Fahrzeugklasse N1, N2'!B15>\"\",'Fahrzeugklasse N1, N2'!A15,A13)","v":0},{"$f":"IF('Fahrzeugklasse N1, N2'!$B15>\"\",CONCATENATE('Fahrzeugklasse N1, N2'!U56,\" \",'Fahrzeugklasse N1, N2'!B15),\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B15>\"\",'Fahrzeugklasse N1, N2'!$F15,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B15>\"\",'Fahrzeugklasse N1, N2'!G15,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B15>\"\",'Fahrzeugklasse N1, N2'!I15,\"\")","v":""}]
[{"$f":"IF('Fahrzeugklasse N1, N2'!B16>\"\",'Fahrzeugklasse N1, N2'!A16,A14)","v":0},{"$f":"IF('Fahrzeugklasse N1, N2'!$B16>\"\",CONCATENATE('Fahrzeugklasse N1, N2'!U60,\" \",'Fahrzeugklasse N1, N2'!B16),\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B16>\"\",'Fahrzeugklasse N1, N2'!$F16,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B16>\"\",'Fahrzeugklasse N1, N2'!G16,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B16>\"\",'Fahrzeugklasse N1, N2'!I16,\"\")","v":""}]
[{"$f":"IF('Fahrzeugklasse N1, N2'!B17>\"\",'Fahrzeugklasse N1, N2'!A17,A15)","v":0},{"$f":"IF('Fahrzeugklasse N1, N2'!$B17>\"\",CONCATENATE('Fahrzeugklasse N1, N2'!U61,\" \",'Fahrzeugklasse N1, N2'!B17),\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B17>\"\",'Fahrzeugklasse N1, N2'!$F17,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B17>\"\",'Fahrzeugklasse N1, N2'!G17,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B17>\"\",'Fahrzeugklasse N1, N2'!I17,\"\")","v":""}]
[{"$f":"IF('Fahrzeugklasse N1, N2'!B18>\"\",'Fahrzeugklasse N1, N2'!A18,A16)","v":0},{"$f":"IF('Fahrzeugklasse N1, N2'!$B18>\"\",CONCATENATE('Fahrzeugklasse N1, N2'!U62,\" \",'Fahrzeugklasse N1, N2'!B18),\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B18>\"\",'Fahrzeugklasse N1, N2'!$F18,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B18>\"\",'Fahrzeugklasse N1, N2'!G18,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B18>\"\",'Fahrzeugklasse N1, N2'!I18,\"\")","v":""}]
[{"$f":"IF('Fahrzeugklasse N1, N2'!B19>\"\",'Fahrzeugklasse N1, N2'!A19,A17)","v":0},{"$f":"IF('Fahrzeugklasse N1, N2'!$B19>\"\",CONCATENATE('Fahrzeugklasse N1, N2'!U64,\" \",'Fahrzeugklasse N1, N2'!B19),\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B19>\"\",'Fahrzeugklasse N1, N2'!$F19,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B19>\"\",'Fahrzeugklasse N1, N2'!G19,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B19>\"\",'Fahrzeugklasse N1, N2'!I19,\"\")","v":""}]
[{"$f":"IF('Fahrzeugklasse N1, N2'!B20>\"\",'Fahrzeugklasse N1, N2'!A20,A18)","v":0},{"$f":"IF('Fahrzeugklasse N1, N2'!$B20>\"\",CONCATENATE('Fahrzeugklasse N1, N2'!U64,\" \",'Fahrzeugklasse N1, N2'!B20),\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B20>\"\",'Fahrzeugklasse N1, N2'!$F20,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B20>\"\",'Fahrzeugklasse N1, N2'!G20,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B20>\"\",'Fahrzeugklasse N1, N2'!I20,\"\")","v":""}]
[{"$f":"IF('Fahrzeugklasse N1, N2'!B21>\"\",'Fahrzeugklasse N1, N2'!A21,A19)","v":0},{"$f":"IF('Fahrzeugklasse N1, N2'!$B21>\"\",CONCATENATE('Fahrzeugklasse N1, N2'!U65,\" \",'Fahrzeugklasse N1, N2'!B21),\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B21>\"\",'Fahrzeugklasse N1, N2'!$F21,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B21>\"\",'Fahrzeugklasse N1, N2'!G21,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B21>\"\",'Fahrzeugklasse N1, N2'!I21,\"\")","v":""}]
[{"$f":"IF('Fahrzeugklasse N1, N2'!B22>\"\",'Fahrzeugklasse N1, N2'!A22,A20)","v":0},{"$f":"IF('Fahrzeugklasse N1, N2'!$B22>\"\",CONCATENATE('Fahrzeugklasse N1, N2'!U66,\" \",'Fahrzeugklasse N1, N2'!B22),\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B22>\"\",'Fahrzeugklasse N1, N2'!$F22,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B22>\"\",'Fahrzeugklasse N1, N2'!G22,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B22>\"\",'Fahrzeugklasse N1, N2'!I22,\"\")","v":""}]
[{"$f":"IF('Fahrzeugklasse N1, N2'!B23>\"\",'Fahrzeugklasse N1, N2'!A23,A21)","v":0},{"$f":"IF('Fahrzeugklasse N1, N2'!$B23>\"\",CONCATENATE('Fahrzeugklasse N1, N2'!U67,\" \",'Fahrzeugklasse N1, N2'!B23),\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B23>\"\",'Fahrzeugklasse N1, N2'!$F23,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B23>\"\",'Fahrzeugklasse N1, N2'!G23,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B23>\"\",'Fahrzeugklasse N1, N2'!I23,\"\")","v":""}]
[{"$f":"IF('Fahrzeugklasse N1, N2'!B24>\"\",'Fahrzeugklasse N1, N2'!A24,A22)","v":0},{"$f":"IF('Fahrzeugklasse N1, N2'!$B24>\"\",CONCATENATE('Fahrzeugklasse N1, N2'!U69,\" \",'Fahrzeugklasse N1, N2'!B24),\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B24>\"\",'Fahrzeugklasse N1, N2'!$F24,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B24>\"\",'Fahrzeugklasse N1, N2'!G24,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B24>\"\",'Fahrzeugklasse N1, N2'!I24,\"\")","v":""}]
[{"$f":"IF('Fahrzeugklasse N1, N2'!B25>\"\",'Fahrzeugklasse N1, N2'!A25,A23)","v":0},{"$f":"IF('Fahrzeugklasse N1, N2'!$B25>\"\",CONCATENATE('Fahrzeugklasse N1, N2'!U70,\" \",'Fahrzeugklasse N1, N2'!B25),\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B25>\"\",'Fahrzeugklasse N1, N2'!$F25,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B25>\"\",'Fahrzeugklasse N1, N2'!G25,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B25>\"\",'Fahrzeugklasse N1, N2'!I25,\"\")","v":""}]
[{"$f":"IF('Fahrzeugklasse N1, N2'!B26>\"\",'Fahrzeugklasse N1, N2'!A26,A24)","v":0},{"$f":"IF('Fahrzeugklasse N1, N2'!$B26>\"\",CONCATENATE('Fahrzeugklasse N1, N2'!U71,\" \",'Fahrzeugklasse N1, N2'!B26),\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B26>\"\",'Fahrzeugklasse N1, N2'!$F26,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B26>\"\",'Fahrzeugklasse N1, N2'!G26,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B26>\"\",'Fahrzeugklasse N1, N2'!I26,\"\")","v":""}]
[{"$f":"IF('Fahrzeugklasse N1, N2'!B27>\"\",'Fahrzeugklasse N1, N2'!A27,A25)","v":0},{"$f":"IF('Fahrzeugklasse N1, N2'!$B27>\"\",CONCATENATE('Fahrzeugklasse N1, N2'!U78,\" \",'Fahrzeugklasse N1, N2'!B27),\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B27>\"\",'Fahrzeugklasse N1, N2'!$F27,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B27>\"\",'Fahrzeugklasse N1, N2'!G27,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B27>\"\",'Fahrzeugklasse N1, N2'!I27,\"\")","v":""}]
[{"$f":"IF('Fahrzeugklasse N1, N2'!B28>\"\",'Fahrzeugklasse N1, N2'!A28,A26)","v":0},{"$f":"IF('Fahrzeugklasse N1, N2'!$B28>\"\",CONCATENATE('Fahrzeugklasse N1, N2'!U80,\" \",'Fahrzeugklasse N1, N2'!B28),\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B28>\"\",'Fahrzeugklasse N1, N2'!$F28,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B28>\"\",'Fahrzeugklasse N1, N2'!G28,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B28>\"\",'Fahrzeugklasse N1, N2'!I28,\"\")","v":""}]
[{"$f":"IF('Fahrzeugklasse N1, N2'!B29>\"\",'Fahrzeugklasse N1, N2'!A29,A27)","v":0},{"$f":"IF('Fahrzeugklasse N1, N2'!$B29>\"\",CONCATENATE('Fahrzeugklasse N1, N2'!U81,\" \",'Fahrzeugklasse N1, N2'!B29),\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B29>\"\",'Fahrzeugklasse N1, N2'!$F29,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B29>\"\",'Fahrzeugklasse N1, N2'!G29,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B29>\"\",'Fahrzeugklasse N1, N2'!I29,\"\")","v":""}]
[{"$f":"IF('Fahrzeugklasse N1, N2'!B30>\"\",'Fahrzeugklasse N1, N2'!A30,A28)","v":0},{"$f":"IF('Fahrzeugklasse N1, N2'!$B30>\"\",CONCATENATE('Fahrzeugklasse N1, N2'!U82,\" \",'Fahrzeugklasse N1, N2'!B30),\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B30>\"\",'Fahrzeugklasse N1, N2'!$F30,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B30>\"\",'Fahrzeugklasse N1, N2'!G30,\"\")","v":""},{"$f":"IF('Fahrzeugklasse N1, N2'!$B30>\"\",'Fahrzeugklasse N1, N2'!I30,\"\")","v":""}]
[{"$f":"IF('N2, N3, Umrüstungen'!B7>\"\",A29+1,A29)","v":0},{"$f":"IF('N2, N3, Umrüstungen'!$B7>\"\",CONCATENATE(\"LKW \",'N2, N3, Umrüstungen'!$B7),\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B7>\"\",'N2, N3, Umrüstungen'!F7,\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B7>\"\",'N2, N3, Umrüstungen'!G7,\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B7>\"\",'N2, N3, Umrüstungen'!I7,\"\")","v":""}]
[{"$f":"IF('N2, N3, Umrüstungen'!B9>\"\",A30+1,A30)","v":0},{"$f":"IF('N2, N3, Umrüstungen'!$B9>\"\",CONCATENATE(\"LKW \",'N2, N3, Umrüstungen'!$B9),\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B9>\"\",'N2, N3, Umrüstungen'!F9,\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B9>\"\",'N2, N3, Umrüstungen'!G9,\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B9>\"\",'N2, N3, Umrüstungen'!I9,\"\")","v":""}]
[{"$f":"IF('N2, N3, Umrüstungen'!B11>\"\",A31+1,A31)","v":0},{"$f":"IF('N2, N3, Umrüstungen'!$B11>\"\",CONCATENATE(\"LKW \",'N2, N3, Umrüstungen'!$B11),\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B11>\"\",'N2, N3, Umrüstungen'!F11,\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B11>\"\",'N2, N3, Umrüstungen'!G11,\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B11>\"\",'N2, N3, Umrüstungen'!I11,\"\")","v":""}]
[{"$f":"IF('N2, N3, Umrüstungen'!B13>\"\",A32+1,A32)","v":0},{"$f":"IF('N2, N3, Umrüstungen'!$B13>\"\",CONCATENATE(\"LKW \",'N2, N3, Umrüstungen'!$B13),\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B13>\"\",'N2, N3, Umrüstungen'!F13,\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B13>\"\",'N2, N3, Umrüstungen'!G13,\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B13>\"\",'N2, N3, Umrüstungen'!I13,\"\")","v":""}]
[{"$f":"IF('N2, N3, Umrüstungen'!B15>\"\",A33+1,A33)","v":0},{"$f":"IF('N2, N3, Umrüstungen'!$B15>\"\",CONCATENATE(\"LKW \",'N2, N3, Umrüstungen'!$B15),\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B15>\"\",'N2, N3, Umrüstungen'!F15,\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B15>\"\",'N2, N3, Umrüstungen'!G15,\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B15>\"\",'N2, N3, Umrüstungen'!I15,\"\")","v":""}]
[{"$f":"IF('N2, N3, Umrüstungen'!B17>\"\",A34+1,A34)","v":0},{"$f":"IF('N2, N3, Umrüstungen'!$B17>\"\",CONCATENATE(\"LKW \",'N2, N3, Umrüstungen'!$B17),\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B17>\"\",'N2, N3, Umrüstungen'!F17,\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B17>\"\",'N2, N3, Umrüstungen'!G17,\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B17>\"\",'N2, N3, Umrüstungen'!I17,\"\")","v":""}]
[{"$f":"IF('N2, N3, Umrüstungen'!B19>\"\",A35+1,A35)","v":0},{"$f":"IF('N2, N3, Umrüstungen'!$B19>\"\",CONCATENATE(\"LKW \",'N2, N3, Umrüstungen'!$B19),\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B19>\"\",'N2, N3, Umrüstungen'!F19,\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B19>\"\",'N2, N3, Umrüstungen'!G19,\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B19>\"\",'N2, N3, Umrüstungen'!I19,\"\")","v":""}]
[{"$f":"IF('N2, N3, Umrüstungen'!B21>\"\",A36+1,A36)","v":0},{"$f":"IF('N2, N3, Umrüstungen'!$B21>\"\",CONCATENATE(\"LKW \",'N2, N3, Umrüstungen'!$B21),\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B21>\"\",'N2, N3, Umrüstungen'!F21,\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B21>\"\",'N2, N3, Umrüstungen'!G21,\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B21>\"\",'N2, N3, Umrüstungen'!I21,\"\")","v":""}]
[{"$f":"IF('N2, N3, Umrüstungen'!B23>\"\",A37+1,A37)","v":0},{"$f":"IF('N2, N3, Umrüstungen'!$B23>\"\",CONCATENATE(\"LKW \",'N2, N3, Umrüstungen'!$B23),\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B23>\"\",'N2, N3, Umrüstungen'!F23,\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B23>\"\",'N2, N3, Umrüstungen'!G23,\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B23>\"\",'N2, N3, Umrüstungen'!I23,\"\")","v":""}]
[{"$f":"IF('N2, N3, Umrüstungen'!B25>\"\",A38+1,A38)","v":0},{"$f":"IF('N2, N3, Umrüstungen'!$B25>\"\",CONCATENATE(\"LKW \",'N2, N3, Umrüstungen'!$B25),\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B25>\"\",'N2, N3, Umrüstungen'!F25,\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B25>\"\",'N2, N3, Umrüstungen'!G25,\"\")","v":""},{"$f":"IF('N2, N3, Umrüstungen'!$B25>\"\",'N2, N3, Umrüstungen'!I25,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!$B6>\"\",A39+1,A39)","v":0},{"$f":"IF(Ladeinfrastruktur!$B6>\"\",CONCATENATE(\" LIS \",Ladeinfrastruktur!B6),\"\")","v":""},{"$f":"IF($B40>\"\",Ladeinfrastruktur!C6,\"\")","v":""},{"$f":"IF($B40>\"\",Ladeinfrastruktur!D6,\"\")","v":""},{"$f":"IF($B40>\"\",Ladeinfrastruktur!E6,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!$B8>\"\",A40+1,A40)","v":0},{"$f":"IF(Ladeinfrastruktur!$B8>\"\",CONCATENATE(\" LIS \",Ladeinfrastruktur!B8),\"\")","v":""},{"$f":"IF($B41>\"\",Ladeinfrastruktur!C8,\"\")","v":""},{"$f":"IF($B41>\"\",Ladeinfrastruktur!D8,\"\")","v":""},{"$f":"IF($B41>\"\",Ladeinfrastruktur!E8,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!$B10>\"\",A41+1,A41)","v":0},{"$f":"IF(Ladeinfrastruktur!$B10>\"\",CONCATENATE(\" LIS \",Ladeinfrastruktur!B10),\"\")","v":""},{"$f":"IF($B42>\"\",Ladeinfrastruktur!C10,\"\")","v":""},{"$f":"IF($B42>\"\",Ladeinfrastruktur!D10,\"\")","v":""},{"$f":"IF($B42>\"\",Ladeinfrastruktur!E10,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!$B12>\"\",A42+1,A42)","v":0},{"$f":"IF(Ladeinfrastruktur!$B12>\"\",CONCATENATE(\" LIS \",Ladeinfrastruktur!B12),\"\")","v":""},{"$f":"IF($B43>\"\",Ladeinfrastruktur!C12,\"\")","v":""},{"$f":"IF($B43>\"\",Ladeinfrastruktur!D12,\"\")","v":""},{"$f":"IF($B43>\"\",Ladeinfrastruktur!E12,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!$B14>\"\",A43+1,A43)","v":0},{"$f":"IF(Ladeinfrastruktur!$B14>\"\",CONCATENATE(\" LIS \",Ladeinfrastruktur!B14),\"\")","v":""},{"$f":"IF($B44>\"\",Ladeinfrastruktur!C14,\"\")","v":""},{"$f":"IF($B44>\"\",Ladeinfrastruktur!D14,\"\")","v":""},{"$f":"IF($B44>\"\",Ladeinfrastruktur!E14,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!$B16>\"\",A44+1,A44)","v":0},{"$f":"IF(Ladeinfrastruktur!$B16>\"\",CONCATENATE(\" LIS \",Ladeinfrastruktur!B16),\"\")","v":""},{"$f":"IF($B45>\"\",Ladeinfrastruktur!C16,\"\")","v":""},{"$f":"IF($B45>\"\",Ladeinfrastruktur!D16,\"\")","v":""},{"$f":"IF($B45>\"\",Ladeinfrastruktur!E16,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!$B18>\"\",A45+1,A45)","v":0},{"$f":"IF(Ladeinfrastruktur!$B18>\"\",CONCATENATE(\" LIS \",Ladeinfrastruktur!B18),\"\")","v":""},{"$f":"IF($B46>\"\",Ladeinfrastruktur!C18,\"\")","v":""},{"$f":"IF($B46>\"\",Ladeinfrastruktur!D18,\"\")","v":""},{"$f":"IF($B46>\"\",Ladeinfrastruktur!E18,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!$B20>\"\",A46+1,A46)","v":0},{"$f":"IF(Ladeinfrastruktur!$B20>\"\",CONCATENATE(\" LIS \",Ladeinfrastruktur!B20),\"\")","v":""},{"$f":"IF($B47>\"\",Ladeinfrastruktur!C20,\"\")","v":""},{"$f":"IF($B47>\"\",Ladeinfrastruktur!D20,\"\")","v":""},{"$f":"IF($B47>\"\",Ladeinfrastruktur!E20,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!$B22>\"\",A47+1,A47)","v":0},{"$f":"IF(Ladeinfrastruktur!$B22>\"\",CONCATENATE(\" LIS \",Ladeinfrastruktur!B22),\"\")","v":""},{"$f":"IF($B48>\"\",Ladeinfrastruktur!C22,\"\")","v":""},{"$f":"IF($B48>\"\",Ladeinfrastruktur!D22,\"\")","v":""},{"$f":"IF($B48>\"\",Ladeinfrastruktur!E22,\"\")","v":""}]
[{"$f":"IF(Ladeinfrastruktur!$B24>\"\",A48+1,A48)","v":0},{"$f":"IF(Ladeinfrastruktur!$B24>\"\",CONCATENATE(\" LIS \",Ladeinfrastruktur!B24),\"\")","v":""},{"$f":"IF($B49>\"\",Ladeinfrastruktur!C24,\"\")","v":""},{"$f":"IF($B49>\"\",Ladeinfrastruktur!D24,\"\")","v":""},{"$f":"IF($B49>\"\",Ladeinfrastruktur!E24,\"\")","v":""}]
[{"$f":"IF('spezielle Ladeinfrastruktur'!$B7>\"\",A49+1,A49)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!B7>\"\",CONCATENATE(\" LIS \",'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>\"\",A50+1,A50)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!B9>\"\",CONCATENATE(\" LIS \",'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>\"\",A51+1,A51)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!B11>\"\",CONCATENATE(\" LIS \",'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>\"\",A52+1,A52)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!B13>\"\",CONCATENATE(\" LIS \",'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>\"\",A53+1,A53)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!B15>\"\",CONCATENATE(\" LIS \",'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>\"\",A54+1,A54)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!B17>\"\",CONCATENATE(\" LIS \",'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>\"\",A55+1,A55)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!B19>\"\",CONCATENATE(\" LIS \",'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>\"\",A56+1,A56)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!B21>\"\",CONCATENATE(\" LIS \",'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>\"\",A57+1,A57)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!B23>\"\",CONCATENATE(\" LIS \",'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>\"\",A58+1,A58)","v":0},{"$f":"IF('spezielle Ladeinfrastruktur'!B25>\"\",CONCATENATE(\" LIS \",'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(E10:E59),0)","v":0}]