{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Read Me","Input-Output Module","M3-TCO-laadplein","Calculatie","M1-PowerSupply","M2-Subsidie","Invoer en categorieën","Parameters","Laadpleinkosten","Config"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":3,"defined_names":40,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Read Me","index":0,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Taal / Language"]
[null,null,"Nederlands"]
[null,null,null,null,null,null,{"$f":"IF($C$3=\"Nederlands\",J4,\nIF($C$3=\"English\",K4,K4))","v":"Voorwoord"},null,null,"Voorwoord","Preface"]
[null,null,null,null,null,null,{"$f":"IF($C$3=\"Nederlands\",J5,\nIF($C$3=\"English\",K5,K5))","v":"Het kostprijsmodel “TCO-ZET-Vracht” is in opdracht van Topsector Logistiek en het Ministerie van I&W door Panteia gebouwd en wordt door haar vervolgens onderhouden. Bij de ontwikkeling van dit TCO-model is gekozen voor een open en transparante opzet. Dit betekent dat helder is welke rekenregels zijn toegepast en welke waarde van de default data als uitgangswaarde is gehanteerd. Het TCO-model wordt mede onderschreven door RAI, evofenedex en TLN."},null,null,"Het kostprijsmodel “TCO-ZET-Vracht” is in opdracht van Topsector Logistiek en het Ministerie van I&W door Panteia gebouwd en wordt door haar vervolgens onderhouden. Bij de ontwikkeling van dit TCO-model is gekozen voor een open en transparante opzet. Dit betekent dat helder is welke rekenregels zijn toegepast en welke waarde van de default data als uitgangswaarde is gehanteerd. Het TCO-model wordt mede onderschreven door RAI, evofenedex en TLN.","The cost price model \"TCO-ZET-Vracht\" was built by Panteia on behalf of Top Sector Logistics and the Ministry of I&W and is subsequently maintained by it. In the development of this TCO-model an open and transparent approach has been chosen. This means that it is clear which calculation rules have been applied and which value of the default data has been used as a starting value. The TCO model is also endorsed by RAI, evofenedex and TLN."]
[]
[null,null,null,null,null,null,{"$f":"IF($C$3=\"Nederlands\",J7,\nIF($C$3=\"English\",K7,K7))","v":"Nieuw in TCO-ZET-Vracht versie 6.2 (d.d. 01-03-2024):"},null,null,"Nieuw in TCO-ZET-Vracht versie 6.2 (d.d. 01-03-2024):","New in TCO-ZET-Vracht version 6.2 (d.d. 01-03-2024):"]
[null,null,null,null,null,null,{"$f":"IF($C$3=\"Nederlands\",J8,\nIF($C$3=\"English\",K8,K8))","v":"In versie 6.2 zijn enkele functionele veranderingen doorgevoerd. Dit heeft invloed op de (keuze)mogelijkheden in het model en de invoer. De volgende functies zijn toegevoegd:\n- Extra voertuigen om uit te kiezen\n- Het model onderscheidt een extra optie voor zware trekkers: H2ICE\n- De optie om een laadplein in te voeren. Dit is optioneel. Zonder gebruik van het laadplein berekent het model kosten voor de laadinfra voor een EV-voertuig en koppelt deze geheel aan dat voertuig. Door gebruik te maken van het laadplein is het mogelijk deze laadinfra-kosten te verdelen over een vloot aan voertuigen.\n- De waarde vermeldt in de \"blauwe velden\" kan handmatig overschreven worden. De \"grijze velden\" zijn niet aanpasbaar. Met de resetknop: “Herstel invoervelden”, wordt teruggegaan naar de oorspronkelijke (default-) waarde.\n- Binnen de laadpleinmodule (sheet: M3-TCO-Laadplein) is informatie over de stationaire batterij toegevoegd. Als zo'n batterij vanuit kostenperspectief een interessante optie kan zijn, wordt hiervan een melding gegeven."},null,null,"In versie 6.2 zijn enkele functionele veranderingen doorgevoerd. Dit heeft invloed op de (keuze)mogelijkheden in het model en de invoer. De volgende functies zijn toegevoegd:\n- Extra voertuigen om uit te kiezen\n- Het model onderscheidt een extra optie voor zware trekkers: H2ICE\n- De optie om een laadplein in te voeren. Dit is optioneel. Zonder gebruik van het laadplein berekent het model kosten voor de laadinfra voor een EV-voertuig en koppelt deze geheel aan dat voertuig. Door gebruik te maken van het laadplein is het mogelijk deze laadinfra-kosten te verdelen over een vloot aan voertuigen.\n- De waarde vermeldt in de \"blauwe velden\" kan handmatig overschreven worden. De \"grijze velden\" zijn niet aanpasbaar. Met de resetknop: “Herstel invoervelden”, wordt teruggegaan naar de oorspronkelijke (default-) waarde.\n- Binnen de laadpleinmodule (sheet: M3-TCO-Laadplein) is informatie over de stationaire batterij toegevoegd. Als zo'n batterij vanuit kostenperspectief een interessante optie kan zijn, wordt hiervan een melding gegeven.","In version 6.2 some functional changes have been made. This influences the (input)abiliites of the model and the variables. The following functions have been added:\n- Extra vehicle types to choose from\n- The model will add an extra combustion type for the heavy tractor to the equation: H2ICE\n- The option to add the total charging-infra [optional]. Without this option the model calculates charging infra costs for the selected EV-vehicle and charges those costs completely to that vehicle. By using this option it is possible to divide the charging infra costs over all vehicles of the company.\n- The value listed in the \"blue fields\" can be manually overwritten. The \"grey fields\" are not editable. With the reset button: \"Reset input\", the original (default) value is returned to.\n- - Within the charging square module (sheet: M3-TCO-laadplein), information about the stationary battery has been added. If such a battery can be an interesting option from a cost perspective, a notification of this is given."]
[]
[null,null,null,null,null,null,{"$f":"IF($C$3=\"Nederlands\",J10,\nIF($C$3=\"English\",K10,K10))","v":"Nieuw in TCO-ZET-Vracht versie 5.0 (d.d. 19-5-2023):"},null,null,"Nieuw in TCO-ZET-Vracht versie 5.0 (d.d. 19-5-2023):","New in TCO-ZET-Vracht version 5.0 (d.d. 19-5-2023):"]
[null,null,null,null,null,null,{"$f":"IF($C$3=\"Nederlands\",J11,\nIF($C$3=\"English\",K11,K11))","v":"De belangrijkste wijziging ten opzichte van versie 4 betreft een verlegging van het basisjaar van 2022 naar 2023.\nGemeld moet worden dat het uitdagend is gebleken om voldoende onderbouwde veranderingen vast te stellen daar de (prijs-) ontwikkelingen in de energie- en transportmarkt aan sterke fluctuaties onderhevig zijn.\nDe doorgevoerde verhoging van belangrijke posten is als volgt:\n- Catalogusprijs van dieselvoertuigen: + 14%.\n- Catalogusprijs van BEV en FCEV: + 8%.\n- Rentepercentage  4,23% (2022: 3,93%).\n- Verzekeringspercentage 3,40% (2022: 3,22%).\n- Dieselprijs (default): 1,55 euro/liter (incl. accijns, excl. btw).\n- Elektriciteitsprijs (default): 0,12 euro/kWh (Zone 3, excl. btw).\n- Waarde van een HBE: 12 euro"},null,null,"De belangrijkste wijziging ten opzichte van versie 4 betreft een verlegging van het basisjaar van 2022 naar 2023.\nGemeld moet worden dat het uitdagend is gebleken om voldoende onderbouwde veranderingen vast te stellen daar de (prijs-) ontwikkelingen in de energie- en transportmarkt aan sterke fluctuaties onderhevig zijn.\nDe doorgevoerde verhoging van belangrijke posten is als volgt:\n- Catalogusprijs van dieselvoertuigen: + 14%.\n- Catalogusprijs van BEV en FCEV: + 8%.\n- Rentepercentage  4,23% (2022: 3,93%).\n- Verzekeringspercentage 3,40% (2022: 3,22%).\n- Dieselprijs (default): 1,55 euro/liter (incl. accijns, excl. btw).\n- Elektriciteitsprijs (default): 0,12 euro/kWh (Zone 3, excl. btw).\n- Waarde van een HBE: 12 euro","The most important change with respect to version 2 concerns a shift of the base year from 2021 to 2022.\nIt should be mentioned that it has proved challenging to establish sufficiently substantiated changes as the (price) developments in the energy and transport market are subject to strong fluctuations.\nThe implemented increase in key items is as follows:\n- Catalog price of diesel vehicles: + 14%.\n- List price of BEV and FCEV: + 8%.\n- Interest rate 4,23% (2022: 3,93%).\n- Insurance rate 3,40% (2022: 3,22%).\n- Diesel price (default): 1,55  euros/liter (incl. excise duty, excl. VAT).\n- Electricity price (default): 0.12 euro/kWh (Zone 3, excl. VAT).\n- Value of a HBE: 12 euro"]
[null,null,null,null,null,null,{"$f":"IF($C$3=\"Nederlands\",J12,\nIF($C$3=\"English\",K12,K12))","v":"Overige aanpassingen:\n- Bij FCEV wordt uitsluitend de waarde van HBE's berekend in geval van groene elektrolyse.\n- Ten behoeve van de berekening van de subsidiebedragen is een vraag over de bedrijfsgrootte toegevoegd.\n- De nieuwe voorwaarden voor de AanZET-subsidie zijn toegevoegd.\n- TCO-vracht is nu beschikbaar in het Nederlands en het Engels. Om van taal te switchen kan linksboven in de readme een keuze gemaakt worden.\n"},null,null,"Overige aanpassingen:\n- Bij FCEV wordt uitsluitend de waarde van HBE's berekend in geval van groene elektrolyse.\n- Ten behoeve van de berekening van de subsidiebedragen is een vraag over de bedrijfsgrootte toegevoegd.\n- De nieuwe voorwaarden voor de AanZET-subsidie zijn toegevoegd.\n- TCO-vracht is nu beschikbaar in het Nederlands en het Engels. Om van taal te switchen kan linksboven in de readme een keuze gemaakt worden.\n","Other adjustments:\n- For FCEV, the value of HBEs is calculated only in case of green electrolysis.\n- For the purpose of calculating subsidy amounts, a question about company size has been added.\n- The new values of the AanZet subsidy have been added.\n- The TCO tool is now available in both Dutch and English. To switch language use the language option at the top of the readme page."]
[]
[null,null,null,null,null,null," -  0  -  0  -  0  -  0  -"]
[]
[]
[null,null,null,null,null,null,{"$f":"IF($C$3=\"Nederlands\",J17,\nIF($C$3=\"English\",K17,K17))","v":"Het gebruik "},null,null,"Het gebruik ","Usage "]
[null,null,null,null,null,null,{"$f":"IF($C$3=\"Nederlands\",J18,\nIF($C$3=\"English\",K18,K18))","v":"De opzet van het TCO-Vracht is zo eenvoudig als mogelijk gehouden. Dit houdt in dat het TCO-Vracht op basis van een beperkte input reeds onderbouwde rekenresultaten produceert. Wel moet het veld “Enable Content” (soms) worden aangeklikt om gebruik te kunnen maken van voor de berekeningen noodzakelijke “Macros”. \nLet op: Sommige beveiligingssoftware verhindert het gebruik van deze Macros. Dit kan verholpen worden door de Excelfile eerst lokaal op te slaan en vanaf deze locatie te werken."},null,null,"De opzet van het TCO-Vracht is zo eenvoudig als mogelijk gehouden. Dit houdt in dat het TCO-Vracht op basis van een beperkte input reeds onderbouwde rekenresultaten produceert. Wel moet het veld “Enable Content” (soms) worden aangeklikt om gebruik te kunnen maken van voor de berekeningen noodzakelijke “Macros”. \nLet op: Sommige beveiligingssoftware verhindert het gebruik van deze Macros. Dit kan verholpen worden door de Excelfile eerst lokaal op te slaan en vanaf deze locatie te werken.","The design of the TCO-Freight has been kept as simple as possible. This means that the TCO-Force already produces substantiated calculation results based on a limited input. However, the field Enable Content\" must (sometimes) be clicked in order to be able to use \"Macros\" necessary for the calculations. Note: Some security software prevents the use of these Macros. This can be remedied by saving the Excel file locally first and working from this location."]
[]
[null,null,null,null,null,null,{"$f":"IF($C$3=\"Nederlands\",J20,\nIF($C$3=\"English\",K20,K20))","v":"Defaultwaarden"},null,null,"Defaultwaarden","Default values"]
[null,null,null,null,null,null,{"$f":"IF($C$3=\"Nederlands\",J21,\nIF($C$3=\"English\",K21,K21))","v":"Bij een groot aantal (input-) gegevens is in het TCO-Vracht reeds een defaultwaarde ingevuld. Deze defaultwaarde (=standaardwaarde) is gebaseerd op gegevens uit de transportwereld. Veel van deze gegevens kunnen naar eigen inzicht veranderd worden met een eigen getal door gebruik te maken van een aantal “knoppen”. Bij deze knoppen is telkens de gebruikte defaultwaarde weergegeven. Overigens, met de resetknop: “Herstel invoervelden”, wordt teruggegaan naar de oorspronkelijke (default-) waarden. \n"},null,null,"Bij een groot aantal (input-) gegevens is in het TCO-Vracht reeds een defaultwaarde ingevuld. Deze defaultwaarde (=standaardwaarde) is gebaseerd op gegevens uit de transportwereld. Veel van deze gegevens kunnen naar eigen inzicht veranderd worden met een eigen getal door gebruik te maken van een aantal “knoppen”. Bij deze knoppen is telkens de gebruikte defaultwaarde weergegeven. Overigens, met de resetknop: “Herstel invoervelden”, wordt teruggegaan naar de oorspronkelijke (default-) waarden. \n","For a large number of (input) data, a default value has already been entered in TCO-Freight. This default value (=standard value) is based on data from the transport world. Many of these data can be changed at one's own discretion with one's own number by using a number of buttons\". The default value used is always shown with these buttons. By the way, with the reset button: \"Reset input\", the original (default) values are returned to. "]
[]
[null,null,null,null,null,null,{"$f":"IF($C$3=\"Nederlands\",J23,\nIF($C$3=\"English\",K23,K23))","v":"Resultaten"},null,null,"Resultaten","Results"]
[null,null,null,null,null,null,{"$f":"IF($C$3=\"Nederlands\",J24,\nIF($C$3=\"English\",K24,K24))","v":"De rekenresultaten worden kolomsgewijs getoond voor telkens een elektrische, een brandstofcel en een dieselvariant van een voertuig met vergelijkbare transportkarakteristieken. De verwachte jaarkilometrage van het geselecteerde voertuig is een bepalend getal. Op basis hiervan worden niet alleen de kosten en emissies berekend maar wordt bijvoorbeeld ook een advies gegeven over optimale capaciteit van de batterij en het vermogen van het oplaadsysteem. "},null,null,"De rekenresultaten worden kolomsgewijs getoond voor telkens een elektrische, een brandstofcel en een dieselvariant van een voertuig met vergelijkbare transportkarakteristieken. De verwachte jaarkilometrage van het geselecteerde voertuig is een bepalend getal. Op basis hiervan worden niet alleen de kosten en emissies berekend maar wordt bijvoorbeeld ook een advies gegeven over optimale capaciteit van de batterij en het vermogen van het oplaadsysteem. ","The calculation results are shown columnwise for each of an electric, a fuel cell and a diesel variant of a vehicle with similar transport characteristics. The expected annual mileage of the selected vehicle is a decisive figure. On this basis, not only the costs and emissions are calculated but also, for example, advice is given on the optimum capacity of the battery and the power of the charging system. "]
[]
[null,null,null,null,null,null,{"$f":"IF($C$3=\"Nederlands\",J26,\nIF($C$3=\"English\",K26,K26))","v":"Emissies "},null,null,"Emissies ","Emissions "]
[null,null,null,null,null,null,{"$f":"IF($C$3=\"Nederlands\",J27,\nIF($C$3=\"English\",K27,K27))","v":"Hoewel het een kostprijsmodel betreft, worden tevens de emissies (WtW) van een aantal vervuilende stoffen van het geselecteerde voertuig berekend. Het betreft daarbij CO2, NOx en PMx. Het ligt voor de hand dat er met (batterij of brandstofcel) elektrische voertuigen op groene stroom c.q. groene waterstof gereden wordt. Wanneer dit om een of andere reden niet mogelijk is, kan bijvoorbeeld “grijze elektriciteit” worden geselecteerd. Er wordt in dat geval gerekend met (de uitstoot van) de Nederlandse elektriciteitsmix. \n"},null,null,"Hoewel het een kostprijsmodel betreft, worden tevens de emissies (WtW) van een aantal vervuilende stoffen van het geselecteerde voertuig berekend. Het betreft daarbij CO2, NOx en PMx. Het ligt voor de hand dat er met (batterij of brandstofcel) elektrische voertuigen op groene stroom c.q. groene waterstof gereden wordt. Wanneer dit om een of andere reden niet mogelijk is, kan bijvoorbeeld “grijze elektriciteit” worden geselecteerd. Er wordt in dat geval gerekend met (de uitstoot van) de Nederlandse elektriciteitsmix. \n","Although it is a cost model, it also calculates the emissions (WtW) of a number of pollutants of the selected vehicle. This concerns CO2, NOx and PMx. It is obvious that (battery or fuel cell) electric vehicles are driven on green electricity or green hydrogen. If, for some reason, this is not possible, then grey electricity\" can be selected, for example. In that case (the emissions of) the Dutch electricity mix is used. "]
[]
[null,null,null,null,null,null,{"$f":"IF($C$3=\"Nederlands\",J29,\nIF($C$3=\"English\",K29,K29))","v":"Nieuwe versies"},null,null,"Nieuwe versies","New versions"]
[null,null,null,null,null,null,{"$f":"IF($C$3=\"Nederlands\",J30,\nIF($C$3=\"English\",K30,K30))","v":"De ontwikkelingen met betrekking tot de energietransitie volgen elkaar in een hoog tempo op. Niet alleen verandert de defaultwaarde van de inputgegevens bijvoorbeeld in de vorm van prijsdalingen, ook komen er regelmatig nieuwe voertuigklassen beschikbaar. Om te zorgen dat het TCO-Vracht zo actueel mogelijk blijft, worden er daarom periodiek updates gemaakt. Deze nieuwe versies van het model worden vervolgens gratis ter beschikking gesteld. \n"},null,null,"De ontwikkelingen met betrekking tot de energietransitie volgen elkaar in een hoog tempo op. Niet alleen verandert de defaultwaarde van de inputgegevens bijvoorbeeld in de vorm van prijsdalingen, ook komen er regelmatig nieuwe voertuigklassen beschikbaar. Om te zorgen dat het TCO-Vracht zo actueel mogelijk blijft, worden er daarom periodiek updates gemaakt. Deze nieuwe versies van het model worden vervolgens gratis ter beschikking gesteld. \n","The developments related to the energy transition follow each other in rapid succession. Not only does the default value of the input data change, for example in the form of price drops, but also new vehicle classes regularly become available. To ensure that TCO-Freight remains as current as possible, updates are therefore made periodically. These new versions of the model are then made available free of charge. \r\n"]
[]
[null,null,null,null,null,null,{"$f":"IF($C$3=\"Nederlands\",J32,\nIF($C$3=\"English\",K32,K32))","v":"Disclaimer "},null,null,"Disclaimer ","Disclaimer "]
[null,null,null,null,null,null,{"$f":"IF($C$3=\"Nederlands\",J33,\nIF($C$3=\"English\",K33,K33))","v":"Veel zorg is besteed aan de correctheid van de rekenregels en de gebruikte inputdata c.q. defaultwaarden. Panteia of de Topsector Logistiek zijn echter niet aansprakelijk te houden voor de juistheid van de rekenresultaten. Deze kunnen ofwel lager dan wel hoger zijn. \n"},null,null,"Veel zorg is besteed aan de correctheid van de rekenregels en de gebruikte inputdata c.q. defaultwaarden. Panteia of de Topsector Logistiek zijn echter niet aansprakelijk te houden voor de juistheid van de rekenresultaten. Deze kunnen ofwel lager dan wel hoger zijn. \n","Great care has been taken to ensure the correctness of the calculation rules and the input data used or default values. However, Panteia or Top Sector Logistics cannot be held liable for the accuracy of the calculation results. These can be either lower or higher. \r\n"]
[]
[null,null,null,null,null,null,{"$f":"IF($C$3=\"Nederlands\",J35,\nIF($C$3=\"English\",K35,K35))","v":"Contact"},null,null,"Contact","Contact"]
[null,null,null,null,null,null,{"$f":"IF($C$3=\"Nederlands\",J36,\nIF($C$3=\"English\",K36,K36))","v":"Indien u vragen hebt dan kunt u deze bij voorkeur verzenden naar: \nTCO-Vracht@panteia.nl\n"},null,null,"Indien u vragen hebt dan kunt u deze bij voorkeur verzenden naar: \nTCO-Vracht@panteia.nl\n","If you have any questions, please send them to: \r\nTCO-Vracht@panteia.nl\r\n"]

{"sheet":"Input-Output Module","index":1,"n_rows":128,"n_cols":8,"rows_kept":128,"cut":false,"hidden":false,"merged":[[27,3,27,5],[19,5,19,7],[46,3,46,5],[55,4,55,7],[3,4,6,7]]}
[]
[]
[null,null,null,null,"Disclaimer:"]
[null,null,null,null,{"$f":"Config!$A$36","v":"De in het TCO-Vracht gebruikte default- c.q. standaardwaarden zijn met de grootste zorg verzameld. Het betreft echter gemiddelde cijfers, de werkelijke cijfers kunnen ofwel hoger dan wel lager zijn. Hoewel veel zorg is besteed aan de correctheid van de rekenregels en de gebruikte inputdata, is Panteia of de Topsector Logistiek niet aansprakelijk te houden voor de juistheid van de rekenresultaten. "}]
[]
[]
[]
[]
[null,"Input-output module",null,null,"TCO-ZET-Vracht"," "]
[null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",_xlfn.CONCAT(\"versie \",Config!$B$1),_xlfn.CONCAT(\"version \",Config!$B$1))","v":"versie 6.2"},"2024-03-01"]
[null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"BASIS INVOERGEGEVENS\",\"BASIC INPUT DATA\")","v":"BASIS INVOERGEGEVENS"}]
[null,null,null,{"$f":"IF(ISNA(MATCH(Voertuigtype,Voertuigen[[#All],[Voertuig]],0)),\nIF('Read Me'!$C$3=\"Nederlands\",\"Herstel invoervelden na taalwissel!\",\"Reset input after language change!\"),\n\"\")","v":""}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Voertuigtype \",\"Vehicle type \")","v":"Voertuigtype "},"Grote bakwagen (lvm > 16 ton)",null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Dieselvoertuig belastingen\",\"Diesel levies\")","v":"Dieselvoertuig belastingen"}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Koelmachine \",\"Cooling unit \")","v":"Koelmachine "},"Nee",null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"heffing\",\"levy\")","v":"heffing"},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"meenemen?\",\"incorporate?\")","v":"meenemen?"}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Verwacht jaarkilometrage [km] \",\"Expected annual mileage [km] \")","v":"Verwacht jaarkilometrage [km] "},{"$f":"INDEX(Voertuigen[[#All],[Kilometrage]],MATCH(Calculatie!$C$2,Voertuigen[[#All],[Voertuig ID]],0))","v":70000},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Meerprijs tolheffing \",\"affitional toll \")","v":"Meerprijs tolheffing "},0,"Nee","[€/km]"]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Grijze/groene elektriciciteit \",\"Grey/green electricity \")","v":"Grijze/groene elektriciciteit "},"Groen",{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Aandeel snelweg kilometers \",\"Share of highway kilometers \")","v":"Aandeel snelweg kilometers "},{"$f":"INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(Parameters!$B$20,InzetVoertuigPar[[#All],[Variabele]],0))","v":0.75}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Grijze/groene waterstof \",\"Grey/green hydrogen \")","v":"Grijze/groene waterstof "},"Electrolyse (hernieuwbare energie)",{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Vaste ZE-Voertuigheffing \",\"Fixed ZE-levy \")","v":"Vaste ZE-Voertuigheffing "},0,"Nee",{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"[€/jaar]\",\"[€/year]\")","v":"[€/jaar]"}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Rechtsvorm en belastingpercentage \",\"Legal form and tax rate \")","v":"Rechtsvorm en belastingpercentage "},"BV of NV met 19% belasting",{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"CO2 prijs \",\"CO2 price \")","v":"CO2 prijs "},0,"Nee",{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"[€/ton]\",\"[€/tonne]\")","v":"[€/ton]"}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Grootte van bedrijf \",\"Company size \")","v":"Grootte van bedrijf "},"Groot"]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Basisjaar prognose \",\"Base year forecast \")","v":"Basisjaar prognose "},2023,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Hernieuwbare Energie eenheden (HBE)\",\"Renewable Fuel units (HBE)\")","v":"Hernieuwbare Energie eenheden (HBE)"}]
[null,null,null,null,null,{"$f":"$E$35","v":"Batterij-elektrisch (BEV)"},{"$f":"$F$35","v":"Brandstofcel (FCEV)"}]
[null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Toepassen? \",\"Apply? \")","v":"Toepassen? "},"Nee","Nee"]
[null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Aantal \",\"Amount \")","v":"Aantal "},{"$f":"Calculatie!$C$56","v":1353},{"$f":"Calculatie!$D$56","v":1867}]
[null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Forfait \",\"Flat rate \")","v":"Forfait "},{"$f":"Calculatie!$C$52","v":1},{"$f":"Calculatie!$D$52","v":1}]
[null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Waarde per HBE \",\"Value per HBE \")","v":"Waarde per HBE "},{"$f":"Parameters!$I$7","v":12},{"$f":"Parameters!$I$7","v":12}]
[null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Totale waarde HBE's \",\"Total HBE value \")","v":"Totale waarde HBE's "},{"$f":"IF((F23*F25)-Parameters!$I$9<0,0,(F23*F25)-Parameters!$I$9)","v":14236},{"$f":"IF((G23*G25)-Parameters!$I$9<0,0,(G23*G25)-Parameters!$I$9)","v":20404}]
[]
[null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Inkoopprijzen energie\",\"Energy purchase prices\")","v":"Inkoopprijzen energie"}]
[null,null,null,{"$f":"_xlfn.CONCAT($D$35,\" [L]\")","v":"Diesel [L]"},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Elektriciteit [kWh]\",\"Electricity [kWh]\")","v":"Elektriciteit [kWh]"},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Waterstof [kg]\",\"Hydrogen [kg]\")","v":"Waterstof [kg]"}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Bruto prijs energie \",\"Basic energy price \")","v":"Bruto prijs energie "},{"$f":"Parameters!$D$4","v":1.03},{"$f":"Parameters!$D$6","v":0.122072892561983},{"$f":"INDEX(Energieprijzen[#All],MATCH(H2_type,Energieprijzen[[#All],[Variabele]],0),3)","v":19}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Subsidie / belasting (accijns) \",\"Subsidy / tax (duty) \")","v":"Subsidie / belasting (accijns) "},{"$f":"Parameters!$D$5","v":0.51619999999999999},0,0]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Netto inkoopprijs energie \",\"Net purchase price \")","v":"Netto inkoopprijs energie "},{"$f":"D30+D31","v":1.5462},{"$f":"E30+E31","v":0.122072892561983},{"$f":"F30+F31","v":19}]
[]
[null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"INZETGEGEVENS VOERTUIG SYSTEM\",\"VEHICLE SYSTEM DEPLOYMENT DATA\")","v":"INZETGEGEVENS VOERTUIG SYSTEM"}]
[null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Diesel\",\"Diesel\")","v":"Diesel"},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Batterij-elektrisch (BEV)\",\"Battery-electric (BEV)\")","v":"Batterij-elektrisch (BEV)"},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Brandstofcel (FCEV)\",\"Fuel Cell Electric (FCEV)\")","v":"Brandstofcel (FCEV)"},"H2ICE-CI"]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Economische levensduur [jaren] \",\"Economic lifespan [years] \")","v":"Economische levensduur [jaren] "},{"$f":"INDEX(Voertuigen[[#All],[Afschrijftermijn]],MATCH(Calculatie!$C$2,Voertuigen[[#All],[Voertuig ID]],0))","v":7},{"$f":"INDEX(Voertuigen[[#All],[Afschrijftermijn]],MATCH(Calculatie!$C$2,Voertuigen[[#All],[Voertuig ID]],0))","v":7},{"$f":"INDEX(Voertuigen[[#All],[Afschrijftermijn]],MATCH(Calculatie!$C$2,Voertuigen[[#All],[Voertuig ID]],0))","v":7},{"$f":"INDEX(Voertuigen[[#All],[Afschrijftermijn]],MATCH(Calculatie!$C$2,Voertuigen[[#All],[Voertuig ID]],0))","v":7}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Kosten van reparaties \",\"Cost of repairs \")","v":"Kosten van reparaties "},{"$f":"INDEX(EnergieverbruikEnOnderhoudPerType[#All],MATCH(Calculatie!$C$3,EnergieverbruikEnOnderhoudPerType[[#All],[Type ID]],0),9)","v":1000},{"$f":"INDEX(EnergieverbruikEnOnderhoudPerType[#All],MATCH(Calculatie!$C$3,EnergieverbruikEnOnderhoudPerType[[#All],[Type ID]],0),10)","v":1000},{"$f":"INDEX(EnergieverbruikEnOnderhoudPerType[#All],MATCH(Calculatie!$C$3,EnergieverbruikEnOnderhoudPerType[[#All],[Type ID]],0),11)","v":3000},{"$f":"INDEX(EnergieverbruikEnOnderhoudPerType[#All],MATCH(Calculatie!$C$3,EnergieverbruikEnOnderhoudPerType[[#All],[Type ID]],0),9)","v":1000}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Productieve uren per jaar \",\"Productive hours per year \")","v":"Productieve uren per jaar "},{"$f":"INDEX(Voertuigen[[#All],[Productive uren per jaar]],MATCH(Calculatie!$C$2,Voertuigen[[#All],[Voertuig ID]],0))","v":2600},{"$f":"Calculatie!$C$14","v":2600},{"$f":"Calculatie!$D$14","v":2600},{"$f":"Calculatie!$E$14","v":2600}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Stilstand [dagen per jaar] \",\"Downtime [days per year] \")","v":"Stilstand [dagen per jaar] "},null,0,0,0]
[]
[null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"AANSCHAFGEGEVENS VOERTUIG SYSTEM\",\"PURCHASE PRICE VEHICLE SYSTEM\")","v":"AANSCHAFGEGEVENS VOERTUIG SYSTEM"}]
[null,null,null,{"$f":"D35","v":"Diesel"},{"$f":"E35","v":"Batterij-elektrisch (BEV)"},{"$f":"F35","v":"Brandstofcel (FCEV)"},{"$f":"$G$35","v":"H2ICE-CI"}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Capaciteit vrachtwagenbatterij [kWh] \",\"Capacity batterypackage [kWh] \")","v":"Capaciteit vrachtwagenbatterij [kWh] "},null,{"$f":"'M1-PowerSupply'!$C$22","v":260},{"$f":"INDEX(FCEV_Variants[#All],MATCH('M1-PowerSupply'!$C$3,FCEV_Variants[[#All],[Type ID]],0),7)","v":140}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Waterstof opslag tank [kg] \",\"Hydrogen storage tank [kg] \")","v":"Waterstof opslag tank [kg] "},null,null,{"$f":"INDEX(FCEV_Variants[#All],MATCH('M1-PowerSupply'!$C$3,FCEV_Variants[[#All],[Type ID]],0),9)","v":20},{"$f":"INDEX(FCEV_Variants[#All],MATCH('M1-PowerSupply'!$C$3,FCEV_Variants[[#All],[Type ID]],0),10)","v":0}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Fuell cell systeem [kW] \",\"Fuell cell system [kW] \")","v":"Fuell cell systeem [kW] "},null,null,{"$f":"INDEX(FCEV_Variants[[#All],[FC power]],MATCH(Calculatie!$C$3,FCEV_Variants[[#All],[Type ID]],0))","v":45}]
[]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Voertuig \",\"Vehicle \")","v":"Voertuig "},{"$f":"Voertuigtype","v":"Grote bakwagen (lvm > 16 ton)"}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Bruto aankoopprijs \",\"Gross purchase price \")","v":"Bruto aankoopprijs "},{"$f":"INDEX(Voertuigen[[#All],[Casco kosten voertuig (DV)]],MATCH(Calculatie!$C$2,Voertuigen[[#All],[Voertuig ID]]))+IF(Koeling=Config!$A$11,INDEX(Voertuigen[[#All],[Aanschaf koelsysteem]],MATCH(Calculatie!$C$2,Voertuigen[[#All],[Voertuig ID]])),0)","v":150765},{"$f":"INDEX(Voertuigen[[#All],[Casco kosten voertuig (DV)]],MATCH(Calculatie!$C$2,Voertuigen[[#All],[Voertuig ID]]))+INDEX(ComponentPrijzen[[#All],[prijs/unit]],MATCH('Invoer en categorieën'!$S$31,ComponentPrijzen[[#All],[Component]],0))*Calculatie!$C$19+IF(Koeling=Config!$A$11,INDEX(Voertuigen[[#All],[Aanschaf koelsysteem]],MATCH(Calculatie!$C$2,Voertuigen[[#All],[Voertuig ID]])),0)","v":287265},{"$f":"(INDEX(Voertuigen[[#All],[Casco kosten voertuig (DV)]],MATCH(Calculatie!$C$2,Voertuigen[[#All],[Voertuig ID]]))+INDEX(ComponentPrijzen[[#All],[prijs/unit]],MATCH('Invoer en categorieën'!$S$31,ComponentPrijzen[[#All],[Component]],0))*Calculatie!$D$19+INDEX(ComponentPrijzen[[#All],[prijs/unit]],MATCH('Invoer en categorieën'!$S$33,ComponentPrijzen[[#All],[Component]],0))*Calculatie!$D$20+INDEX(ComponentPrijzen[[#All],[prijs/unit]],MATCH('Invoer en categorieën'!$S$32,ComponentPrijzen[[#All],[Component]],0))*Calculatie!$D$21)*INDEX(ComponentPrijzen[[#All],[prijs/unit]],MATCH('Invoer en categorieën'!$S$34,ComponentPrijzen[[#All],[Component]],0))+IF(Koeling=Config!$A$11,INDEX(Voertuigen[[#All],[Aanschaf koelsysteem]],MATCH(Calculatie!$C$2,Voertuigen[[#All],[Voertuig ID]])),0)","v":449564.39999999997},{"$f":"INDEX(Voertuigen[[#All],[H2ICE Casco]],MATCH(Calculatie!$C$2,Voertuigen[[#All],[Voertuig ID]]))+IF(Koeling=Config!$A$11,INDEX(Voertuigen[[#All],[Aanschaf koelsysteem]],MATCH(Calculatie!$C$2,Voertuigen[[#All],[Voertuig ID]])),0)","v":0}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"AanZET-subsidie \",\"APPROVAL subsidy \")","v":"AanZET-subsidie "},null,"Nee","Nee","Nee"]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"MIA-subsidie \",\"MIA-subsidy \")","v":"MIA-subsidie "},null,"Ja","Ja","Ja"]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Netto aankoopprijs \",\"Net purchase price \")","v":"Netto aankoopprijs "},{"$f":"$D$48","v":150765},{"$f":"$E$48-'M2-Subsidie'!$B$35-'M2-Subsidie'!$B$36","v":267616.07400000002},{"$f":"$F$48-'M2-Subsidie'!$C$35-'M2-Subsidie'!$C$36","v":418814.19503999996},{"$f":"$G$48-'M2-Subsidie'!$D$35-'M2-Subsidie'!$D$36","v":0}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Restwaarde \",\"Residual value \")","v":"Restwaarde "},{"$f":"INDEX(Afschrijving[[#All],[Percentage of value of new vehicle price (%)]],MATCH(IF($D$36>10,Parameters!$H$25,$D$36),Afschrijving[[#All],[Age]],0))*$D$48","v":34675.950000000004},{"$f":"INDEX(Afschrijving[[#All],[Percentage of value of new vehicle price (%)]],MATCH(IF($E$36>10,Parameters!$H$25,$E$36),Afschrijving[[#All],[Age]],0))*$E$48","v":66070.95},{"$f":"INDEX(Afschrijving[[#All],[Percentage of value of new vehicle price (%)]],MATCH(IF($F$36>10,Parameters!$H$25,$F$36),Afschrijving[[#All],[Age]],0))*$F$48","v":103399.81199999999},{"$f":"INDEX(Afschrijving[[#All],[Percentage of value of new vehicle price (%)]],MATCH(IF($G$36>10,Parameters!$H$25,$G$36),Afschrijving[[#All],[Age]],0))*$G$48","v":0}]
[]
[null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"GEGEVENS EN AANSCHAF OPLAADSYSTEEM\",\"PURCHASE DATA CHARGING SYSTEM\")","v":"GEGEVENS EN AANSCHAF OPLAADSYSTEEM"}]
[]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Kies invoermethode \",\"Choose input method \")","v":"Kies invoermethode "},"Enkele laadpaal",{"$f":"IF($D$56=Config!$A$32,\nIF('Read Me'!$C$3=\"Nederlands\",\n\"Vergeet niet tabblad 'M3-TCO-laadplein' voor uw situatie in te vullen!!\",\n\"Don't forget to fill in sheet 'M3-TCO-laadplein' for your own situation!!\"),\"\")","v":""}]
[null,null,null,{"$f":"IF($D$56=Config!$A$32,\nIF('Read Me'!$C$3=\"Nederlands\",\n\"Niet invullen\",\n\"Don't fill in\"),\"\")","v":""},null,{"$f":"IF($D$56=Config!$A$32,\nIF('Read Me'!$C$3=\"Nederlands\",\n\"Samenvatting huidige invoer:\",\n\"Summary current input:\"),\"\")","v":""}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Vermogen systeem \",\"Capacity charging systeem \")","v":"Vermogen systeem "},{"$f":"'M1-PowerSupply'!$C$31","v":"50 kW"},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Totaal voertuigen \",\"Vehicle amount \")","v":"Totaal voertuigen "},{"$f":"'M3-TCO-laadplein'!$I$16","v":0}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Bruto kosten oplaadsysteem \",\"Gross cost chargingsystem \")","v":"Bruto kosten oplaadsysteem "},{"$f":"INDEX(LaadinfraPrivaat[[#All],[Purchase (€)]],MATCH($D$58,LaadinfraPrivaat[[#All],[Power]],0))","v":19293.75},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Totaal laadpalen \",\"Number of charging stations \")","v":"Totaal laadpalen "},{"$f":"Calculatie!$R$16","v":0}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Bruto kosten aanleg oplaadsysteem \",\"Gross cost installation system \")","v":"Bruto kosten aanleg oplaadsysteem "},{"$f":"INDEX(LaadinfraPrivaat[[#All],[Installation costs (€)]],MATCH($D$58,LaadinfraPrivaat[[#All],[Power]],0))","v":12810.285},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Totale kosten [per kWh] \",\"Total costs [per kWh] \")","v":"Totale kosten [per kWh] "},{"$f":"'M3-TCO-laadplein'!$J$31","v":0},{"$f":"IF('M3-TCO-laadplein'!$J$29=Config!$A$11,\nIF('Read Me'!$C$3=\"Nederlands\",\" Kosten netverzwaring meegenomen\",\" Costs upgrading mains included\"),\nIF('Read Me'!$C$3=\"Nederlands\",\" Kosten netverzwaring niet meegenomen\",\" Costs upgrading mains excluded\"))","v":" Kosten netverzwaring niet meegenomen"}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"MIA-subsidie \",\"MIA-subsidy \")","v":"MIA-subsidie "},"Ja",{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"waarvan CAPEX \",\"of which CAPEX \")","v":"waarvan CAPEX "},{"$f":"MAX(F60-F62-E32,0)","v":0}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Netto kosten inkoop & aanleg \",\"Net cost purchase and installation \")","v":"Netto kosten inkoop & aanleg "},{"$f":"$D$59+$D$60-'M2-Subsidie'!$B$37","v":29908.119006000004},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"waarvan OPEX \",\"of which OPEX \")","v":"waarvan OPEX "},{"$f":"Calculatie!U32","v":0},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\" * exclusief energiekosten \",\" * excluding ernergy costs\")","v":" * exclusief energiekosten "}]
[]
[null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"RESULTATEN\",\"RESULTS\")","v":"RESULTATEN"}]
[null,null,null,{"$f":"D35","v":"Diesel"},{"$f":"E35","v":"Batterij-elektrisch (BEV)"},{"$f":"F35","v":"Brandstofcel (FCEV)"},{"$f":"G35","v":"H2ICE-CI"}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Scenario technisch mogelijk EV? \",\"Scenario technical valid EV? \")","v":"Scenario technisch mogelijk EV? "},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"n.v.t.\",\"n.a.\")","v":"n.v.t."},{"$f":"IF('M1-PowerSupply'!$B$51,\nIF('Read Me'!$C$3=\"Nederlands\",\"Scenario valide\",\"Valid scenario\"),\nIF('Read Me'!$C$3=\"Nederlands\",\"Scenario invalide\",\"Invalid scenario\")\n)","v":"Scenario valide"},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"n.v.t.\",\"n.a.\")","v":"n.v.t."},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"n.v.t.\",\"n.a.\")","v":"n.v.t."}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Uitvoering \",\"Variant \")","v":"Uitvoering "},{"$f":"INDEX(Voertuigen[[#All],[Type]],MATCH(Calculatie!$C$3,Voertuigen[[#All],[Type ID]],0))","v":"Grote bakwagen"},{"$f":"_xlfn.CONCAT(D67,\" \",E43,\" kWh\")","v":"Grote bakwagen 260 kWh"},{"$f":"_xlfn.CONCAT(D67,\" \",F45,\" kW\")","v":"Grote bakwagen 45 kW"},{"$f":"_xlfn.CONCAT(D67,\" \",G44,\" kg\")","v":"Grote bakwagen 0 kg"}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Eigen oplaadsysteem \",\"Own charging station \")","v":"Eigen oplaadsysteem "},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"n.v.t.\",\"n.a.\")","v":"n.v.t."},{"$f":"IF($D$56=Config!$A$31,'M1-PowerSupply'!$C$32,\nIF('Read Me'!$C$3=\"Nederlands\",\"Eigen laadplein\",\"Own Charging Hub\"))","v":"50 kW"},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"n.v.t.\",\"n.a.\")","v":"n.v.t."},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"n.v.t.\",\"n.a.\")","v":"n.v.t."}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Openbaar oplaadsysteem \",\"Public charging station \")","v":"Openbaar oplaadsysteem "},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"n.v.t.\",\"n.a.\")","v":"n.v.t."},{"$f":"'M1-PowerSupply'!$C$42","v":"HPC350"},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"n.v.t.\",\"n.a.\")","v":"n.v.t."},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"n.v.t.\",\"n.a.\")","v":"n.v.t."}]
[]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Aandeel eigen oplaadsysteem \",\"Share own charging station \")","v":"Aandeel eigen oplaadsysteem "},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"n.v.t.\",\"n.a.\")","v":"n.v.t."},{"$f":"IF($D$56=Config!$A$31,Calculatie!$C$29,1)","v":0.57519665681603782},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"n.v.t.\",\"n.a.\")","v":"n.v.t."},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"n.v.t.\",\"n.a.\")","v":"n.v.t."}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Aandeel extern (openbaar) laden \",\"Share external/public charging \")","v":"Aandeel extern (openbaar) laden "},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"n.v.t.\",\"n.a.\")","v":"n.v.t."},{"$f":"IF($D$56=Config!$A$31,Calculatie!$C$30,0)","v":0.42480334318396218},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"n.v.t.\",\"n.a.\")","v":"n.v.t."},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"n.v.t.\",\"n.a.\")","v":"n.v.t."}]
[]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Totale kosten per jaar \",\"Total cost per year \")","v":"Totale kosten per jaar "},{"$f":"D121+D125","v":176417.37894287478},{"$f":"E121+E125","v":203817.5611206165},{"$f":"F121+F125","v":333712.88896558108},{"$f":"G121+G125","v":109396.30236919994}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Totale kosten per km \",\"Total cost per km \")","v":"Totale kosten per km "},{"$f":"D74/Kilometrage","v":2.5202482706124969},{"$f":"E74/Kilometrage","v":2.9116794445802356},{"$f":"F74/Kilometrage","v":4.7673269852225868},{"$f":"G74/Kilometrage","v":1.5628043195599992}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Totale kosten per uur \",\"Total cost per hour \")","v":"Totale kosten per uur "},{"$f":"D74/D38","v":67.852838054951846},{"$f":"E74/E38","v":78.391369661775585},{"$f":"F74/F38","v":128.35111114060811},{"$f":"G74/G38","v":42.075500911230748}]
[]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Emissies (voor geselecteerde voertuig) \",\"Emissions (selected vehicle \")","v":"Emissies (voor geselecteerde voertuig) "}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"CO2 emissies (ton per jaar, WtW) \",\"CO2 emissions (tonne per year, WtW) \")","v":"CO2 emissies (ton per jaar, WtW) "},{"$f":"Calculatie!$B$40","v":64.716077686277629},{"$f":"Calculatie!$C$40","v":0},{"$f":"Calculatie!$D$40","v":0},{"$f":"F79","v":0}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"PM totaal (kg per jaar, TtW) \",\"PM total (kg per year, TtW) \")","v":"PM totaal (kg per jaar, TtW) "},{"$f":"Calculatie!$B$41+Calculatie!$B$42","v":6.4562274204741721},{"$f":"Calculatie!$C$41+Calculatie!$C$42","v":5.6844816480881075},{"$f":"Calculatie!$D$41+Calculatie!$D$42","v":5.6844816480881075},{"$f":"E80","v":5.6844816480881075}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"NOx (kg per jaar, TtW) \",\"NOx (kg per year, TtW) \")","v":"NOx (kg per jaar, TtW) "},{"$f":"MIN(Calculatie!$B$43,Calculatie!$B$45)","v":43.249208258100531},"n.v.t.","n.v.t.",{"$f":"D81","v":43.249208258100531}]
[]
[null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"ONDERBOUWING KOSTENBEREKENING\",\"SUBSTANTIATION OF COST CALCULATIONS\")","v":"ONDERBOUWING KOSTENBEREKENING"}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Vaste kosten per jaar (a) \",\"Fixed annual costs (a) \")","v":"Vaste kosten per jaar (a) "},{"$f":"SUM(D85:D90)","v":10182.150243103126},{"$f":"SUM(E85:E90)","v":17637.954727061278},{"$f":"SUM(F85:F90)","v":27137.645347136906},{"$f":"SUM(G85:G90)","v":823.79135999999994}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Wegenbelasting \",\"Road taks \")","v":"Wegenbelasting "},{"$f":"INDEX(OperationeleKostenPerType[[#All],[Wegenbelasting]],MATCH(Calculatie!$C$3,OperationeleKostenPerType[[#All],[Type ID]],0))","v":315.89999999999998},0,0,0]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Eurovignet \",\"Eurovignette \")","v":"Eurovignet "},{"$f":"INDEX(OperationeleKostenPerType[[#All],[Eurovignet]],MATCH(Calculatie!$C$3,OperationeleKostenPerType[[#All],[Type ID]],0))","v":750},{"$f":"INDEX(OperationeleKostenPerType[[#All],[Eurovignet]],MATCH(Calculatie!$C$3,OperationeleKostenPerType[[#All],[Type ID]],0))","v":750},{"$f":"INDEX(OperationeleKostenPerType[[#All],[Eurovignet]],MATCH(Calculatie!$C$3,OperationeleKostenPerType[[#All],[Type ID]],0))","v":750},{"$f":"INDEX(OperationeleKostenPerType[[#All],[Eurovignet]],MATCH(Calculatie!$C$3,OperationeleKostenPerType[[#All],[Type ID]],0))","v":750}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Rente \",\"Interest \")","v":"Rente "},{"$f":"AVERAGE($D$51,$D$52)*INDEX(FinPar[[#All],[Waarde]],MATCH(\"Rente\",FinPar[[#All],[Variabele]],0))","v":3918.3501202121251},{"$f":"AVERAGE($E$51,$E$52)*INDEX(FinPar[[#All],[Waarde]],MATCH(\"Rente\",FinPar[[#All],[Variabele]],0))","v":7050.7759510702808},{"$f":"AVERAGE($F$51,$F$52)*INDEX(FinPar[[#All],[Waarde]],MATCH(\"Rente\",FinPar[[#All],[Variabele]],0))","v":11034.333663959547},{"$f":"AVERAGE($G$51,$G$52)*INDEX(FinPar[[#All],[Waarde]],MATCH(\"Rente\",FinPar[[#All],[Variabele]],0))","v":0}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Verzekering \",\"Insurance \")","v":"Verzekering "},{"$f":"$D$48*INDEX(FinPar[[#All],[Waarde]],MATCH(\"Verzekering\",FinPar[[#All],[Variabele]],0))","v":5124.108762891},{"$f":"$E$48*INDEX(FinPar[[#All],[Waarde]],MATCH(\"Verzekering\",FinPar[[#All],[Variabele]],0))","v":9763.3874159909992},{"$f":"$F$48*INDEX(FinPar[[#All],[Waarde]],MATCH(\"Verzekering\",FinPar[[#All],[Variabele]],0))","v":15279.520323177358},{"$f":"$G$48*INDEX(FinPar[[#All],[Waarde]],MATCH(\"Verzekering\",FinPar[[#All],[Variabele]],0))","v":0}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Voertuigheffing \",\"Vehicle tax \")","v":"Voertuigheffing "},{"$f":"IF($G$17=Config!$A$11,'Input-Output Module'!$F$17,0)","v":0},0,0,0]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Diverse overige voertuigkosten \",\"Miscellaneous vehicle costs \")","v":"Diverse overige voertuigkosten "},{"$f":"INDEX(OperationeleKostenPerType[[#All],[Versch. voertuigkosten]],MATCH(Calculatie!$C$3,OperationeleKostenPerType[[#All],[Type ID]],0))","v":73.791359999999997},{"$f":"INDEX(OperationeleKostenPerType[[#All],[Versch. voertuigkosten]],MATCH(Calculatie!$C$3,OperationeleKostenPerType[[#All],[Type ID]],0))","v":73.791359999999997},{"$f":"INDEX(OperationeleKostenPerType[[#All],[Versch. voertuigkosten]],MATCH(Calculatie!$C$3,OperationeleKostenPerType[[#All],[Type ID]],0))","v":73.791359999999997},{"$f":"INDEX(OperationeleKostenPerType[[#All],[Versch. voertuigkosten]],MATCH(Calculatie!$C$3,OperationeleKostenPerType[[#All],[Type ID]],0))","v":73.791359999999997}]
[]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Variabele kosten per jaar (b) \",\"Variable annual costs (b) \")","v":"Variabele kosten per jaar (b) "},{"$f":"SUM(D93:D106)","v":56127.79712144412},{"$f":"SUM(E93:E106)","v":61341.910511425493},{"$f":"SUM(F93:F106)","v":174771.87962319158},{"$f":"SUM(G93:G106)","v":7709.3658548275343}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Afschrijving voertuig \",\"Depriciation vehicle \")","v":"Afschrijving voertuig "},{"$f":"(D$51-D$52)/D$36","v":16584.149999999998},{"$f":"(E$51-E$52)/E$36","v":28792.160571428572},{"$f":"(F$51-F$52)/F$36","v":45059.197577142855},{"$f":"(G$51-G$52)/G$36","v":0}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Brandstofverbruik voertuig \",\"Fuel consumption vehicle \")","v":"Brandstofverbruik voertuig "},{"$f":"Calculatie!$B$35","v":31834.281266616588},0,0,0]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Brandstofverbruik koeling \",\"Fuel consumption cooling unit \")","v":"Brandstofverbruik koeling "},{"$f":"Calculatie!$B$36","v":0},0,0,0]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Elektriciteitsverbruik \",\"Electricity consumption \")","v":"Elektriciteitsverbruik "},0,{"$f":"Calculatie!$C$37","v":27382.281849996929},0,0]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"H2 verbruik \",\"H2 Consumption \")","v":"H2 verbruik "},0,0,{"$f":"Calculatie!$D$37","v":118146.8479560487},{"$f":"Calculatie!$E$37","v":0}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Adblue verbruik \",\"Adblue consumption \")","v":"Adblue verbruik "},{"$f":"Calculatie!$B$47","v":342.71476482753457},0,0,{"$f":"Calculatie!$E$47","v":342.71476482753457}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Banden \",\"Tires \")","v":"Banden "},{"$f":"INDEX(OperationeleKostenPerType[[#All],[Bandenkosten (€/km)]],MATCH(Calculatie!$C$3,OperationeleKostenPerType[[#All],[Type ID]],0))*Kilometrage","v":1569.1838400000001},{"$f":"INDEX(OperationeleKostenPerType[[#All],[Bandenkosten (€/km)]],MATCH(Calculatie!$C$3,OperationeleKostenPerType[[#All],[Type ID]],0))*Kilometrage","v":1569.1838400000001},{"$f":"INDEX(OperationeleKostenPerType[[#All],[Bandenkosten (€/km)]],MATCH(Calculatie!$C$3,OperationeleKostenPerType[[#All],[Type ID]],0))*Kilometrage","v":1569.1838400000001},{"$f":"INDEX(OperationeleKostenPerType[[#All],[Bandenkosten (€/km)]],MATCH(Calculatie!$C$3,OperationeleKostenPerType[[#All],[Type ID]],0))*Kilometrage","v":1569.1838400000001}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Onderhoud \",\"Maintenance \")","v":"Onderhoud "},{"$f":"INDEX(EnergieverbruikEnOnderhoudPerType[[#All],[Onderhoud DV '[€/km']]],MATCH(Calculatie!$C$3,EnergieverbruikEnOnderhoudPerType[[#All],[Type ID]],0))*Kilometrage","v":4398.366},{"$f":"INDEX(EnergieverbruikEnOnderhoudPerType[[#All],[Onderhoud EV '[€/km']]],MATCH(Calculatie!$C$3,EnergieverbruikEnOnderhoudPerType[[#All],[Type ID]],0))*Kilometrage","v":2199.183},{"$f":"INDEX(EnergieverbruikEnOnderhoudPerType[[#All],[Onderhoud FC '[€/km']]],MATCH(Calculatie!$C$3,EnergieverbruikEnOnderhoudPerType[[#All],[Type ID]],0))*Kilometrage","v":6597.5489999999991},{"$f":"INDEX(EnergieverbruikEnOnderhoudPerType[[#All],[Onderhoud DV '[€/km']]],MATCH(Calculatie!$C$3,EnergieverbruikEnOnderhoudPerType[[#All],[Type ID]],0))*Kilometrage","v":4398.366}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Reparatie \",\"Repairs \")","v":"Reparatie "},{"$f":"D37","v":1000},{"$f":"E37","v":1000},3000,1000]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Reparatie/onderhoud koelunit \",\"Repairs/maintenance cooling unit \")","v":"Reparatie/onderhoud koelunit "},{"$f":"INDEX(OperationeleKostenPerType[[#All],[Onderhoud koeling]],MATCH(Calculatie!$C$3,OperationeleKostenPerType[[#All],[Type ID]],0))*Calculatie!$B$14*IF(Koeling=Config!$A$11,INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Aandeel koelunit\",InzetVoertuigPar[[#All],[Variabele]],0)),0)","v":0},{"$f":"INDEX(OperationeleKostenPerType[[#All],[Onderhoud koeling]],MATCH(Calculatie!$C$3,OperationeleKostenPerType[[#All],[Type ID]],0))*Calculatie!$B$14*IF(Koeling=Config!$A$11,INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Aandeel koelunit\",InzetVoertuigPar[[#All],[Variabele]],0)),0)","v":0},{"$f":"INDEX(OperationeleKostenPerType[[#All],[Onderhoud koeling]],MATCH(Calculatie!$C$3,OperationeleKostenPerType[[#All],[Type ID]],0))*Calculatie!$B$14*IF(Koeling=Config!$A$11,INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Aandeel koelunit\",InzetVoertuigPar[[#All],[Variabele]],0)),0)","v":0},{"$f":"INDEX(OperationeleKostenPerType[[#All],[Onderhoud koeling]],MATCH(Calculatie!$C$3,OperationeleKostenPerType[[#All],[Type ID]],0))*Calculatie!$B$14*IF(Koeling=Config!$A$11,INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Aandeel koelunit\",InzetVoertuigPar[[#All],[Variabele]],0)),0)","v":0}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Verschil Tolheffing (km-tarief) \",\"Difference tolls (km-rate) \")","v":"Verschil Tolheffing (km-tarief) "},{"$f":"IF($G$15=Config!$A$11,Kilometrage*'Input-Output Module'!$F$15*'Input-Output Module'!$F$16,0)","v":0},0,0,{"$f":"IF($G$15=Config!$A$11,Kilometrage*'Input-Output Module'!$F$15*'Input-Output Module'!$F$16,0)","v":0}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"CO2-prijs \",\"CO2-price \")","v":"CO2-prijs "},{"$f":"IF($G$18=Config!$A$11,'Input-Output Module'!$D$79*'Input-Output Module'!$F$18,0)","v":0},{"$f":"IF($G$18=Config!$A$11,'Input-Output Module'!$D$79*'Input-Output Module'!$F$18,0)","v":0},{"$f":"IF($G$18=Config!$A$11,'Input-Output Module'!$D$79*'Input-Output Module'!$F$18,0)","v":0},{"$f":"IF($G$18=Config!$A$11,'Input-Output Module'!$D$79*'Input-Output Module'!$F$18,0)","v":0}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Hernieuwbare Brandstof-Eenheden (HBE's) \",\"Renewable Fuel Costs (HBE's) \")","v":"Hernieuwbare Brandstof-Eenheden (HBE's) "},0,{"$f":"-IF($F$22=Config!$A$11,'Input-Output Module'!$F$26,0)","v":0},{"$f":"IF($G$22=Config!$A$11,'Input-Output Module'!$G$26,0)","v":0},{"$f":"IF($G$22=Config!$A$11,Calculatie!E56*'Input-Output Module'!G25,0)","v":0}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Specifieke vervoerskosten \",\"Specific vehicle costs \")","v":"Specifieke vervoerskosten "},{"$f":"INDEX(OperationeleKostenPerType[[#All],[Speciale transportkosten]],MATCH(Calculatie!$C$3,OperationeleKostenPerType[[#All],[Type ID]],0))","v":399.10124999999999},{"$f":"INDEX(OperationeleKostenPerType[[#All],[Speciale transportkosten]],MATCH(Calculatie!$C$3,OperationeleKostenPerType[[#All],[Type ID]],0))","v":399.10124999999999},{"$f":"INDEX(OperationeleKostenPerType[[#All],[Speciale transportkosten]],MATCH(Calculatie!$C$3,OperationeleKostenPerType[[#All],[Type ID]],0))","v":399.10124999999999},{"$f":"INDEX(OperationeleKostenPerType[[#All],[Speciale transportkosten]],MATCH(Calculatie!$C$3,OperationeleKostenPerType[[#All],[Type ID]],0))","v":399.10124999999999}]
[]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Kosten oplaadsysteem per jaar (c) \",\"Annual costs charging system (c) \")","v":"Kosten oplaadsysteem per jaar (c) "},{"$f":"D110+D109","v":0},{"$f":"E110+E109","v":7358.6095020350012},{"$f":"F110+F109","v":0},{"$f":"G110+G109","v":0}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Aankoop en installatie \",\"Purchase and installation \")","v":"Aankoop en installatie "},0,{"$f":"IF($D$56=Config!$A$31,'Input-Output Module'!$D$62/INDEX(LaadinfraPrivaat[[#All],[Afschrijftermijn]],MATCH('Input-Output Module'!$E$68,LaadinfraPrivaat[[#All],[Power]],0)),$F$61*Calculatie!$C$50)","v":2990.8119006000006},0,0]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Operationele kosten \",\"Operational costs \")","v":"Operationele kosten "},0,{"$f":"IF($D$56=Config!$A$31,INDEX(LaadinfraPrivaat[[#All],[Operational costs annual (€)]],MATCH('Input-Output Module'!$E$68,LaadinfraPrivaat[[#All],[Power]],0)),$F$62*Calculatie!$C$50)","v":4367.7976014350006},0,0]
[]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Totaal voertuig en systeem (a+b+c) per jaar \",\"Total vehicle and charging (a+b+c) per annum \")","v":"Totaal voertuig en systeem (a+b+c) per jaar "},{"$f":"D108+D92+D84","v":66309.947364547246},{"$f":"E108+E92+E84","v":86338.474740521779},{"$f":"F108+F92+F84","v":201909.52497032849},{"$f":"G108+G92+G84","v":8533.1572148275336}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"per km \",\"per km \")","v":"per km "},{"$f":"D112/Kilometrage","v":0.94728496235067494},{"$f":"E112/Kilometrage","v":1.2334067820074539},{"$f":"F112/Kilometrage","v":2.884421785290407},{"$f":"G112/Kilometrage","v":0.12190224592610763}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"per productief uur \",\"per productive hour \")","v":"per productief uur "},{"$f":"D112/D38","v":25.50382590944125},{"$f":"E112/E38","v":33.207105669431456},{"$f":"F112/F38","v":77.6575096039725},{"$f":"G112/G38","v":3.2819835441644361}]
[]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Chauffeurskosten per jaar (d) \",\"Driver costs per annum (d) \")","v":"Chauffeurskosten per jaar (d) "},{"$f":"SUM(D117:D119)","v":85774},{"$f":"SUM(E117:E119)","v":89366.31932897518},{"$f":"SUM(F117:F119)","v":85774},{"$f":"SUM(G117:G119)","v":85774}]
[null,null,{"$f":"_xlfn.CONCAT(\nIF('Read Me'!$C$3=\"Nederlands\",\"Uurloon incl. sociale lasten (\",\"Hourly wage (incl. social charges) (\"),TEXT(INDEX(Voertuigen[[#All],[Uurloon]],MATCH(Calculatie!$C$2,Voertuigen[[#All],[Voertuig ID]],0)),\"€#.##0,00\"),\")\")","v":"Uurloon incl. sociale lasten (€31,48)"},{"$f":"INDEX(Voertuigen[[#All],[Uurloon]],MATCH(Calculatie!$C$2,Voertuigen[[#All],[Voertuig ID]],0))*D38","v":81848},{"$f":"INDEX(Voertuigen[[#All],[Uurloon]],MATCH(Calculatie!$C$2,Voertuigen[[#All],[Voertuig ID]],0))*E38\n+INDEX(Voertuigen[[#All],[Uurloon]],MATCH(Calculatie!$C$2,Voertuigen[[#All],[Voertuig ID]],0)) * 'M1-PowerSupply'!$B$44 * Calculatie!$C$13","v":85440.31932897518},{"$f":"INDEX(Voertuigen[[#All],[Uurloon]],MATCH(Calculatie!$C$2,Voertuigen[[#All],[Voertuig ID]],0))*F38","v":81848},{"$f":"INDEX(Voertuigen[[#All],[Uurloon]],MATCH(Calculatie!$C$2,Voertuigen[[#All],[Voertuig ID]],0))*G38","v":81848}]
[null,null,{"$f":"_xlfn.CONCAT(\nIF('Read Me'!$C$3=\"Nederlands\",\"Verblijfkostenvergoeding (\",\"Accommodation allowance (\"),TEXT(INDEX(FinPar[[#All],[Waarde]],MATCH(\"Verblijfkostenvergoeding\",FinPar[[#All],[Variabele]],0)),\"€#.##0,00\"),\")\")","v":"Verblijfkostenvergoeding (€0,97)"},{"$f":"INDEX(FinPar[[#All],[Waarde]],MATCH(\"Verblijfkostenvergoeding\",FinPar[[#All],[Variabele]],0))*D38","v":2522},{"$f":"INDEX(FinPar[[#All],[Waarde]],MATCH(\"Verblijfkostenvergoeding\",FinPar[[#All],[Variabele]],0))*E38","v":2522},{"$f":"INDEX(FinPar[[#All],[Waarde]],MATCH(\"Verblijfkostenvergoeding\",FinPar[[#All],[Variabele]],0))*F38","v":2522},{"$f":"INDEX(FinPar[[#All],[Waarde]],MATCH(\"Verblijfkostenvergoeding\",FinPar[[#All],[Variabele]],0))*G38","v":2522}]
[null,null,{"$f":"_xlfn.CONCAT(\nIF('Read Me'!$C$3=\"Nederlands\",\"Overige kosten (\",\"Other costs (\"),TEXT(INDEX(FinPar[[#All],[Waarde]],MATCH(\"Overige chauffeurskosten\",FinPar[[#All],[Variabele]],0)),\"€#.##0,00\"),\")\")","v":"Overige kosten (€0,54)"},{"$f":"INDEX(FinPar[[#All],[Waarde]],MATCH(\"Overige chauffeurskosten\",FinPar[[#All],[Variabele]],0))*D38","v":1404},{"$f":"INDEX(FinPar[[#All],[Waarde]],MATCH(\"Overige chauffeurskosten\",FinPar[[#All],[Variabele]],0))*E38","v":1404},{"$f":"INDEX(FinPar[[#All],[Waarde]],MATCH(\"Overige chauffeurskosten\",FinPar[[#All],[Variabele]],0))*F38","v":1404},{"$f":"INDEX(FinPar[[#All],[Waarde]],MATCH(\"Overige chauffeurskosten\",FinPar[[#All],[Variabele]],0))*G38","v":1404}]
[]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Totale directe kosten (a+b+c+d) per jaar \",\"Total direct costs (a+b+c+d) per annum \")","v":"Totale directe kosten (a+b+c+d) per jaar "},{"$f":"D112+D116","v":152083.94736454723},{"$f":"E112+E116","v":175704.79406949697},{"$f":"F112+F116","v":287683.52497032849},{"$f":"G112+G116","v":94307.15721482753}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"per km \",\"per km \")","v":"per km "},{"$f":"D121/Kilometrage","v":2.172627819493532},{"$f":"E121/Kilometrage","v":2.5100684867070995},{"$f":"F121/Kilometrage","v":4.1097646424332641},{"$f":"G121/Kilometrage","v":1.3472451030689647}]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"per productief uur \",\"per productive hour \")","v":"per productief uur "},{"$f":"D121/D38","v":58.493825909441242},{"$f":"E121/E38","v":67.578766949806521},{"$f":"F121/F38","v":110.64750960397249},{"$f":"G121/G38","v":36.271983544164435}]
[]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Algemene kosten (overhead) per jaar (e) \",\"General costs (overhead) per annum (e) \")","v":"Algemene kosten (overhead) per jaar (e) "},{"$f":"SUM(D126:D128)","v":24333.43157832756},{"$f":"SUM(E126:E128)","v":28112.767051119517},{"$f":"SUM(F126:F128)","v":46029.363995252555},{"$f":"SUM(G126:G128)","v":15089.145154372405}]
[null,null,{"$f":"_xlfn.CONCAT(\nIF('Read Me'!$C$3=\"Nederlands\",\"Loon incl. sociale lasten (\",\"Wage (incl. social charges) (\"),TEXT(INDEX(FinPar[[#All],[Waarde]],MATCH(\"Loon incl. sociale lasten\",FinPar[[#All],[Variabele]],0)),\"#,0%\"),\")\")","v":"Loon incl. sociale lasten (8,4%)"},{"$f":"INDEX(FinPar[[#All],[Waarde]],MATCH(\"Loon incl. sociale lasten\",FinPar[[#All],[Variabele]],0))*D121","v":12775.051578621968},{"$f":"INDEX(FinPar[[#All],[Waarde]],MATCH(\"Loon incl. sociale lasten\",FinPar[[#All],[Variabele]],0))*E121","v":14759.202701837747},{"$f":"INDEX(FinPar[[#All],[Waarde]],MATCH(\"Loon incl. sociale lasten\",FinPar[[#All],[Variabele]],0))*F121","v":24165.416097507594},{"$f":"INDEX(FinPar[[#All],[Waarde]],MATCH(\"Loon incl. sociale lasten\",FinPar[[#All],[Variabele]],0))*G121","v":7921.801206045513}]
[null,null,{"$f":"_xlfn.CONCAT(\nIF('Read Me'!$C$3=\"Nederlands\",\"Huisvesting (\",\"Housing (\"),TEXT(INDEX(FinPar[[#All],[Waarde]],MATCH(\"Huisvesting\",FinPar[[#All],[Variabele]],0)),\"#,0%\"),\")\")","v":"Huisvesting (2,6%)"},{"$f":"INDEX(FinPar[[#All],[Waarde]],MATCH(\"Huisvesting\",FinPar[[#All],[Variabele]],0))*D121","v":3954.1826314782279},{"$f":"INDEX(FinPar[[#All],[Waarde]],MATCH(\"Huisvesting\",FinPar[[#All],[Variabele]],0))*E121","v":4568.3246458069207},{"$f":"INDEX(FinPar[[#All],[Waarde]],MATCH(\"Huisvesting\",FinPar[[#All],[Variabele]],0))*F121","v":7479.7716492285408},{"$f":"INDEX(FinPar[[#All],[Waarde]],MATCH(\"Huisvesting\",FinPar[[#All],[Variabele]],0))*G121","v":2451.9860875855156}]
[null,null,{"$f":"_xlfn.CONCAT(\nIF('Read Me'!$C$3=\"Nederlands\",\"Overig (\",\"Other (\"),TEXT(INDEX(FinPar[[#All],[Waarde]],MATCH(\"Overig overhead\",FinPar[[#All],[Variabele]],0)),\"#,0%\"),\")\")","v":"Overig (5,0%)"},{"$f":"INDEX(FinPar[[#All],[Waarde]],MATCH(\"Overig overhead\",FinPar[[#All],[Variabele]],0))*D121","v":7604.1973682273619},{"$f":"INDEX(FinPar[[#All],[Waarde]],MATCH(\"Overig overhead\",FinPar[[#All],[Variabele]],0))*E121","v":8785.2397034748483},{"$f":"INDEX(FinPar[[#All],[Waarde]],MATCH(\"Overig overhead\",FinPar[[#All],[Variabele]],0))*F121","v":14384.176248516425},{"$f":"INDEX(FinPar[[#All],[Waarde]],MATCH(\"Overig overhead\",FinPar[[#All],[Variabele]],0))*G121","v":4715.3578607413765}]

{"sheet":"M3-TCO-laadplein","index":2,"n_rows":50,"n_cols":23,"rows_kept":50,"cut":false,"hidden":false,"merged":[[21,18,21,19],[31,7,32,10],[46,7,46,9],[27,18,27,19],[25,18,25,19],[24,18,24,19],[23,18,23,19],[22,18,22,19],[52,6,53,12],[31,18,31,19],[30,18,30,19],[29,18,29,19],[28,18,28,19],[17,1,17,2],[19,1,25,4],[15,1,15,2],[16,1,16,2],[34,6,35,12],[2,1,3,8],[2,9,3,13],[2,15,3,22],[5,2,6,8],[5,12,5,13],[5,14,7,14],[5,15,7,15],[5,16,7,16],[5,17,6,22],[6,10,7,10],[6,11,7,11],[6,12,7,12],[6,13,7,13],[5,9,5,11],[6,9,7,9]]}
[]
[]
[null,{"$f":"Config!$A$54","v":"Stap 1\nVul het verwachte aantal elektrische vrachtvoertuigen per type op uw vestiging in de huidige situatie en in de komende tien jaar (per 2 jaar). Houd hierbij rekening met het aantal voertuigen dat tegelijk zal opladen (waardoor tegelijkertijd een laadbehoefte ontstaat).\nBelangrijk: Het invullen van het totale wagenpark moet voor ieder jaar afzonderlijk gebeuren. Vul in de eerste kolom het huidige aantal e-voertuigen in dat u al heeft."},null,null,null,null,null,null,null,{"$f":"Config!$A$55","v":"Stap 2\nGeef het verwachte jaarkilometrage (per voertuigtype) van uw voertuigen op. Op basis hiervan is een gemiddelde per dag berekend. Als dit sterk afwijkt van uw maximale dagelijkse afstand, vul dan zelf deze waarde in (kolom [Maximum per dag]). Per voertuigtype is een inschatting gemaakt van het gemiddelde energieverbruik. Weet u het energieverbruik? Vul deze dan zelf in de kolom [Eigen input] in."},null,null,null,null,null,{"$f":"Config!$A$56","v":"Stap 3\nVul per voertuigtype de hoeveel tijd (uren) in dat de vrachtwagens per dag kunnen opladen. Op basis van de benodigde energievraag wordt de kleinst mogelijke laadpaal berekend. U kunt deze vervangen met een eigen keuze. Let op: u kunt alleen een laadpaal met een hoger vermogen kiezen."}]
[]
[]
[null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\n\"Stel uw vloot samen\",\n\"set up your vehicle park\"\n)","v":"Stel uw vloot samen"},null,null,null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Kilometrage [km]\",\"Mileage [km]\")","v":"Kilometrage [km]"},null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Energie gebruik [kWh/km]\",\"Energy use [kWh/km]\")","v":"Energie gebruik [kWh/km]"},null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Jaarlijks energie gebruik per voertuig [kWh]\",\"Yearly energy use per vehicle [kWh]\")","v":"Jaarlijks energie gebruik per voertuig [kWh]"},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Aantal uren per dag terug op depot\",\"Amount of hours on own location\")","v":"Aantal uren per dag terug op depot"},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Kleinst bruikbare laadpaal\",\"Least heavy charging station\")","v":"Kleinst bruikbare laadpaal"},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Minimaal aantal benodigde laadpalen in:\",\"Minimum charging stations needed in:\")","v":"Minimaal aantal benodigde laadpalen in:"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Jaarlijks per voertuig\",\"annually per vehicle\")","v":"Jaarlijks per voertuig"},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Gemiddeld per dag\",\"Daily average\")","v":"Gemiddeld per dag"},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Maximum per dag\",\"Daily max\")","v":"Maximum per dag"},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Advies\",\"Advice\")","v":"Advies"},{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Eigen input\",\"Own input\")","v":"Eigen input"}]
[null,null,null,{"$f":"'Input-Output Module'!$D$20","v":2023},{"$f":"D8+2","v":2025},{"$f":"E8+2","v":2027},2029,2031,2033,null,null,null,null,null,null,null,null,{"$f":"D8","v":2023},{"$f":"E8","v":2025},2027,2029,2031,2033]
[null,null,"Bestelwagens (tot 3,5 ton)",0,{"$f":"$D$9","v":0},{"$f":"$E$9","v":0},{"$f":"$F$9","v":0},{"$f":"$G$9","v":0},{"$f":"$H$9","v":0},30000,{"$f":"J9/INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Productieve dagen per jaar\",InzetVoertuigPar[[#All],[Variabele]],0))","v":115.38461538461539},null,{"$f":"IF(C9=$C$9,0.3,INDEX(EnergieverbruikEnOnderhoudPerType[[#All],[Rijden EV '[kWh/km']]],MATCH('M3-TCO-laadplein'!B9,EnergieverbruikEnOnderhoudPerType[[#All],[Type ID]],0)))","v":0.3},null,{"$f":"IF(N9<>\"\",N9,M9)*J9","v":9000},8,{"$f":"IFERROR(INDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH((IF($L$9>0,$L$9,$K$9)*IF($N$9>0,$N$9,$M$9))/$P$9,LaadinfraPrivaat[[#All],[Power (kW)]],-1)),Config!$A$57)","v":"AC11"},{"$f":"ROUNDUP((D9*(IF($L9<>\"\",$L9,$K9)*IF($N9<>\"\",$N9,$M9))/$P9)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q9,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((E9*(IF($L9<>\"\",$L9,$K9)*IF($N9<>\"\",$N9,$M9))/$P9)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q9,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((F9*(IF($L9<>\"\",$L9,$K9)*IF($N9<>\"\",$N9,$M9))/$P9)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q9,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((G9*(IF($L9<>\"\",$L9,$K9)*IF($N9<>\"\",$N9,$M9))/$P9)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q9,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((H9*(IF($L9<>\"\",$L9,$K9)*IF($N9<>\"\",$N9,$M9))/$P9)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q9,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((I9*(IF($L9<>\"\",$L9,$K9)*IF($N9<>\"\",$N9,$M9))/$P9)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q9,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0}]
[null,1,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\n\"Kleine bakwagen (lvm <12 ton)\",\n\"Small truck (load <12 tonnes)\"\n)","v":"Kleine bakwagen (lvm <12 ton)"},0,{"$f":"$D$10","v":0},{"$f":"$E$10","v":0},{"$f":"$F$10","v":0},{"$f":"$G$10","v":0},{"$f":"$H$10","v":0},{"$f":"INDEX(Voertuigen[[#All],[Kilometrage]],MATCH($B$10,Voertuigen[[#All],[Type ID]],0))","v":35000},{"$f":"J10/INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Productieve dagen per jaar\",InzetVoertuigPar[[#All],[Variabele]],0))","v":134.61538461538461},null,{"$f":"IF(C10=$C$9,0.3,INDEX(EnergieverbruikEnOnderhoudPerType[[#All],[Rijden EV '[kWh/km']]],MATCH('M3-TCO-laadplein'!B10,EnergieverbruikEnOnderhoudPerType[[#All],[Type ID]],0)))","v":0.48154113423076755},null,{"$f":"IF(N10<>\"\",N10,M10)*J10","v":16853.939698076865},8,{"$f":"IFERROR(INDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH((IF($L$10>0,$L$10,$K$10)*IF($N$10>0,$N$10,$M$10))/P10,LaadinfraPrivaat[[#All],[Power (kW)]],-1)),Config!$A$57)","v":"AC11"},{"$f":"ROUNDUP((D10*(IF($L10<>\"\",$L10,$K10)*IF($N10<>\"\",$N10,$M10))/$P10)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q10,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((E10*(IF($L10<>\"\",$L10,$K10)*IF($N10<>\"\",$N10,$M10))/$P10)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q10,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((F10*(IF($L10<>\"\",$L10,$K10)*IF($N10<>\"\",$N10,$M10))/$P10)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q10,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((G10*(IF($L10<>\"\",$L10,$K10)*IF($N10<>\"\",$N10,$M10))/$P10)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q10,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((H10*(IF($L10<>\"\",$L10,$K10)*IF($N10<>\"\",$N10,$M10))/$P10)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q10,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((I10*(IF($L10<>\"\",$L10,$K10)*IF($N10<>\"\",$N10,$M10))/$P10)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q10,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0}]
[null,2,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\n\"Medium bakwagen (lvm 12-18 ton)\",\n\"Medium size truck (load 12-18 tonnes)\"\n)","v":"Medium bakwagen (lvm 12-18 ton)"},0,{"$f":"$D$11","v":0},{"$f":"$E$11","v":0},{"$f":"$F$11","v":0},{"$f":"$G$11","v":0},{"$f":"$H$11","v":0},{"$f":"INDEX(Voertuigen[[#All],[Kilometrage]],MATCH($B$11,Voertuigen[[#All],[Type ID]],0))","v":70000},{"$f":"J11/INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Productieve dagen per jaar\",InzetVoertuigPar[[#All],[Variabele]],0))","v":269.23076923076923},null,{"$f":"IF(C11=$C$9,0.3,INDEX(EnergieverbruikEnOnderhoudPerType[[#All],[Rijden EV '[kWh/km']]],MATCH('M3-TCO-laadplein'!B11,EnergieverbruikEnOnderhoudPerType[[#All],[Type ID]],0)))","v":0.94758884430654944},null,{"$f":"IF(N11<>\"\",N11,M11)*J11","v":66331.219101458468},8,{"$f":"IFERROR(INDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH((IF($L$11>0,$L$11,$K$11)*IF($N$11>0,$N$11,$M$11))/P11,LaadinfraPrivaat[[#All],[Power (kW)]],-1)),Config!$A$57)","v":"FC50"},{"$f":"ROUNDUP((D11*(IF($L11<>\"\",$L11,$K11)*IF($N11<>\"\",$N11,$M11))/$P11)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q11,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((E11*(IF($L11<>\"\",$L11,$K11)*IF($N11<>\"\",$N11,$M11))/$P11)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q11,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((F11*(IF($L11<>\"\",$L11,$K11)*IF($N11<>\"\",$N11,$M11))/$P11)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q11,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((G11*(IF($L11<>\"\",$L11,$K11)*IF($N11<>\"\",$N11,$M11))/$P11)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q11,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((H11*(IF($L11<>\"\",$L11,$K11)*IF($N11<>\"\",$N11,$M11))/$P11)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q11,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((I11*(IF($L11<>\"\",$L11,$K11)*IF($N11<>\"\",$N11,$M11))/$P11)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q11,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0}]
[null,3,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\n\"Grote bakwagen (lvm >18 ton)\",\n\"Large truck (load >18 tonnes)\"\n)","v":"Grote bakwagen (lvm >18 ton)"},0,{"$f":"$D$12","v":0},{"$f":"$E$12","v":0},{"$f":"$F$12","v":0},{"$f":"$G$12","v":0},{"$f":"$H$12","v":0},{"$f":"INDEX(Voertuigen[[#All],[Kilometrage]],MATCH($B$12,Voertuigen[[#All],[Type ID]],0))","v":70000},{"$f":"J12/INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Productieve dagen per jaar\",InzetVoertuigPar[[#All],[Variabele]],0))","v":269.23076923076923},null,{"$f":"IF(C12=$C$9,0.3,INDEX(EnergieverbruikEnOnderhoudPerType[[#All],[Rijden EV '[kWh/km']]],MATCH('M3-TCO-laadplein'!B12,EnergieverbruikEnOnderhoudPerType[[#All],[Type ID]],0)))","v":1.3431431136056065},null,{"$f":"IF(N12<>\"\",N12,M12)*J12","v":94020.017952392445},8,{"$f":"IFERROR(INDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH((IF($L$12>0,$L$12,$K$12)*IF($N$12>0,$N$12,$M$12))/P12,LaadinfraPrivaat[[#All],[Power (kW)]],-1)),Config!$A$57)","v":"FC50"},{"$f":"ROUNDUP((D12*(IF($L12<>\"\",$L12,$K12)*IF($N12<>\"\",$N12,$M12))/$P12)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q12,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((E12*(IF($L12<>\"\",$L12,$K12)*IF($N12<>\"\",$N12,$M12))/$P12)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q12,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((F12*(IF($L12<>\"\",$L12,$K12)*IF($N12<>\"\",$N12,$M12))/$P12)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q12,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((G12*(IF($L12<>\"\",$L12,$K12)*IF($N12<>\"\",$N12,$M12))/$P12)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q12,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((H12*(IF($L12<>\"\",$L12,$K12)*IF($N12<>\"\",$N12,$M12))/$P12)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q12,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((I12*(IF($L12<>\"\",$L12,$K12)*IF($N12<>\"\",$N12,$M12))/$P12)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q12,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0}]
[null,4,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\n\"Lichte trekker z/opl (GVW <40 ton)\",\n\"Light tractor (load <40 tonnes)\"\n)","v":"Lichte trekker z/opl (GVW <40 ton)"},0,{"$f":"$D$13","v":0},{"$f":"$E$13","v":0},{"$f":"$F$13","v":0},{"$f":"$G$13","v":0},{"$f":"$H$13","v":0},{"$f":"INDEX(Voertuigen[[#All],[Kilometrage]],MATCH($B$13,Voertuigen[[#All],[Type ID]],0))","v":100000},{"$f":"J13/INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Productieve dagen per jaar\",InzetVoertuigPar[[#All],[Variabele]],0))","v":384.61538461538464},null,{"$f":"IF(C13=$C$9,0.3,INDEX(EnergieverbruikEnOnderhoudPerType[[#All],[Rijden EV '[kWh/km']]],MATCH('M3-TCO-laadplein'!B13,EnergieverbruikEnOnderhoudPerType[[#All],[Type ID]],0)))","v":1.3913649711853182},null,{"$f":"IF(N13<>\"\",N13,M13)*J13","v":139136.49711853181},8,{"$f":"IFERROR(INDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH((IF($L$13>0,$L$13,$K$13)*IF($N$13>0,$N$13,$M$13))/P13,LaadinfraPrivaat[[#All],[Power (kW)]],-1)),Config!$A$57)","v":"HPC150"},{"$f":"ROUNDUP((D13*(IF($L13<>\"\",$L13,$K13)*IF($N13<>\"\",$N13,$M13))/$P13)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q13,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((E13*(IF($L13<>\"\",$L13,$K13)*IF($N13<>\"\",$N13,$M13))/$P13)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q13,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((F13*(IF($L13<>\"\",$L13,$K13)*IF($N13<>\"\",$N13,$M13))/$P13)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q13,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((G13*(IF($L13<>\"\",$L13,$K13)*IF($N13<>\"\",$N13,$M13))/$P13)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q13,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((H13*(IF($L13<>\"\",$L13,$K13)*IF($N13<>\"\",$N13,$M13))/$P13)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q13,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((I13*(IF($L13<>\"\",$L13,$K13)*IF($N13<>\"\",$N13,$M13))/$P13)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q13,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0}]
[null,5,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\n\"Zware trekker z/opl (GVW >40 ton)\",\n\"Heavy duty tractor (load >40 tonnes)\"\n)","v":"Zware trekker z/opl (GVW >40 ton)"},0,{"$f":"$D$14","v":0},{"$f":"$E$14","v":0},{"$f":"$F$14","v":0},{"$f":"$G$14","v":0},{"$f":"$H$14","v":0},{"$f":"INDEX(Voertuigen[[#All],[Kilometrage]],MATCH($B$14,Voertuigen[[#All],[Type ID]],0))","v":100000},{"$f":"J14/INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Productieve dagen per jaar\",InzetVoertuigPar[[#All],[Variabele]],0))","v":384.61538461538464},null,{"$f":"IF(C14=$C$9,0.3,INDEX(EnergieverbruikEnOnderhoudPerType[[#All],[Rijden EV '[kWh/km']]],MATCH('M3-TCO-laadplein'!B14,EnergieverbruikEnOnderhoudPerType[[#All],[Type ID]],0)))","v":1.66},null,166000,8,{"$f":"IFERROR(INDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH((IF($L$14>0,$L$14,$K$14)*IF($N$14>0,$N$14,$M$14))/P14,LaadinfraPrivaat[[#All],[Power (kW)]],-1)),Config!$A$57)","v":"HPC150"},{"$f":"ROUNDUP((D14*(IF($L14<>\"\",$L14,$K14)*IF($N14<>\"\",$N14,$M14))/$P14)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q14,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((E14*(IF($L14<>\"\",$L14,$K14)*IF($N14<>\"\",$N14,$M14))/$P14)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q14,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((F14*(IF($L14<>\"\",$L14,$K14)*IF($N14<>\"\",$N14,$M14))/$P14)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q14,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((G14*(IF($L14<>\"\",$L14,$K14)*IF($N14<>\"\",$N14,$M14))/$P14)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q14,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((H14*(IF($L14<>\"\",$L14,$K14)*IF($N14<>\"\",$N14,$M14))/$P14)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q14,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0},{"$f":"ROUNDUP((I14*(IF($L14<>\"\",$L14,$K14)*IF($N14<>\"\",$N14,$M14))/$P14)/INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M3-TCO-laadplein'!Q14,LaadinfraPrivaat[[#All],[Charging type]],0)),0)","v":0}]
[]
[null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Totaal e-voertuigen\",\"Total e-vehicles\")","v":"Totaal e-voertuigen"},null,{"$f":"SUM(D9:D14)","v":0},{"$f":"SUM(E9:E14)","v":0},0,0,0,0]
[null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Totale energievraag [kWh]\",\"Total energy demand [kWh]\")","v":"Totale energievraag [kWh]"},null,{"$f":"SUMPRODUCT(D9:D14,$O$9:$O$14)","v":0},{"$f":"SUMPRODUCT(E9:E14,$O$9:$O$14)","v":0},{"$f":"SUMPRODUCT(F9:F14,$O$9:$O$14)","v":0},0,0,0]
[null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Piekvermogen [kW/u]*\",\"Peak power [kW/h]*\")","v":"Piekvermogen [kW/u]*"},null,{"$f":"Calculatie!M$17","v":0},{"$f":"Calculatie!N$17","v":0},{"$f":"Calculatie!O$17","v":0},{"$f":"Calculatie!P$17","v":0},{"$f":"Calculatie!Q$17","v":0},{"$f":"Calculatie!R$17","v":0}]
[]
[null,{"$f":"Config!$A$58","v":"* Bovenstaand piekvermogen is van toepassing in het geval dat alle laadpalen gelijktijdig worden gebruikt. Let op dat wanneer deze piek groter is dan uw publieke aansluiting toestaat, de zekering van uw aansluiting op het publieke net springt! De piek kan verlaagd worden door de toepassing van een \"smart charging grid\". Daarnaast kan een aansluiting overwogen worden met een zonne- of windpark of een elektriciteitsopslag in batterijen."}]
[null,null,null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"TOTALE KOSTEN LAADPLEIN (afschrijftermijn is 10 jaar)\",\"TOTAL COST CHARGING HUB (depreciation period is 10 years)\")","v":"TOTALE KOSTEN LAADPLEIN (afschrijftermijn is 10 jaar)"},null,null,null,null,null,null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"SAMENVATTING STATIONAIRE BATTERIJ\",\"SUMMARY STATIONARY BATTERY\")","v":"SAMENVATTING STATIONAIRE BATTERIJ"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Afschrijftermijn [jaar]\",\"Depreciation [years]\")","v":"Afschrijftermijn [jaar]"},{"$f":"$J$40","v":15}]
[null,null,null,null,null,null,null,null,"CAPEX",{"$f":"Calculatie!U25","v":0},null,null,"Details CAPEX",null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Jaarcapaciteit [kWh]\",\"Yearly capacity [kWh]\")","v":"Jaarcapaciteit [kWh]"},{"$f":"$J$45","v":208000}]
[null,null,null,null,null,null,null,null,"OPEX",{"$f":"Calculatie!U31","v":0},null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"inkoopprijs laadpalen\",\"purchase charging stations\")","v":"inkoopprijs laadpalen"},{"$f":"Calculatie!U21","v":0},null,null,null,"CAPEX",{"$f":"SUM($N$41:$N$44)","v":556500}]
[null,null,null,null,null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Netverzwaring\",\"Upgrading mains\")","v":"Netverzwaring"},{"$f":"Calculatie!U35","v":0},null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"plaatsing\",\"installation\")","v":"plaatsing"},{"$f":"Calculatie!U22","v":0},null,null,null,"OPEX",{"$f":"SUM($N$48:$N$50)","v":27900}]
[null,null,null,null,null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Transformator\",\"Transformer\")","v":"Transformator"},{"$f":"IF(J23>0,Calculatie!U36,0)","v":0},null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"projectmanagement / advies\",\"projectmanagement / consulting\")","v":"projectmanagement / advies"},{"$f":"Calculatie!U23","v":0},null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Besparing per kWh\",\"Savings per kWh\")","v":"Besparing per kWh"},{"$f":"($J$48-$J$49)*$J$50","v":3.1036446280991503E-2}]
[null,null,null,null,null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Totaal\",\"Total\")","v":"Totaal"},{"$f":"SUM(J23:J26)","v":0},null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"aansluitkosten netbeheerder\",\"connection costs network operator\")","v":"aansluitkosten netbeheerder"},{"$f":"Calculatie!U24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Jaarlijkse kosten\",\"Yearly costs\")","v":"Jaarlijkse kosten"}]
[null,null,null," ",null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Netverzwaring meenemen* \",\"Include upgrading mains* \")","v":"Netverzwaring meenemen* "},"Nee",null,null,"Details OPEX",null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Bruto totale kosten\",\"Gross total costs\")","v":"Bruto totale kosten"},{"$f":"($S$24/$S$22)+$S$25","v":65000}]
[null,null,null,null,null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"kosten per jaar \",\"annual costs \")","v":"kosten per jaar "},{"$f":"IF($J$29=Config!$A$11,('M3-TCO-laadplein'!J23+'M3-TCO-laadplein'!J24+'M3-TCO-laadplein'!J25+'M3-TCO-laadplein'!J26),('M3-TCO-laadplein'!J23+'M3-TCO-laadplein'!J24))/10","v":0},null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"periodieke netkosten\",\"periodic costs network operator\")","v":"periodieke netkosten"},{"$f":"Calculatie!U28","v":0},null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Totale besparing\",\"Total savings\")","v":"Totale besparing"},{"$f":"$S$26*$S$23","v":6455.580826446233}]
[null,null,null,null,null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"kosten per kWh \",\"costs per kWh \")","v":"kosten per kWh "},{"$f":"IF(J27>0,\nIF($J$29=Config!$A$11,('M3-TCO-laadplein'!J23+'M3-TCO-laadplein'!J24+'M3-TCO-laadplein'!J25+'M3-TCO-laadplein'!J26),('M3-TCO-laadplein'!J23+'M3-TCO-laadplein'!J24))/\n(SUM(Calculatie!$M$18:$R$18)*2),0)","v":0},null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"operatie, onderhoud, service\",\"operations, maintenance and service\")","v":"operatie, onderhoud, service"},{"$f":"Calculatie!U29","v":0},null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Netto totale kosten\",\"Net total costs\")","v":"Netto totale kosten"},{"$f":"$S$29-$S$30","v":58544.419173553768}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($J$29=Config!$A$11,$J$31*(1+INDEX(PAR_STAT_BATTERY[#All],MATCH(\"Marge\",PAR_STAT_BATTERY[[#All],[Variabele]],0),3))>=$S$32),Config!$A$59,\"\")","v":""},null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"energiekosten\",\"energy costs\")","v":"energiekosten"},{"$f":"Calculatie!U30","v":0},null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Kosten per kWh\",\"Costs per kWh\")","v":"Kosten per kWh"},{"$f":"$S$31/$S$23","v":0.2814635537190085}]
[null,null,null," "]
[]
[null,null,null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\n\"*let op! Een netverzwaring of de aanschaf van een transformator is niet altijd nodig. Deze kosten kunnen genegeerd worden door hier voor 'nee' te kiezen\",\n\"*Note! Upgrading your mains of purchasing a transformer is not always needed. These costs can be excluded by chossing 'No' here\")","v":"*let op! Een netverzwaring of de aanschaf van een transformator is niet altijd nodig. Deze kosten kunnen genegeerd worden door hier voor 'nee' te kiezen"}]
[]
[]
[null,null,null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"AANSCHAF EN KOSTEN STATIONAIRE BATTERIJ\",\"PURCHASE AND OPERATING STATIONARY BATTERY\")","v":"AANSCHAF EN KOSTEN STATIONAIRE BATTERIJ"}]
[]
[null,null,null,null,null,null,null,null,{"$f":"Config!$A$60","v":"Afschrijftermijn [jaar] "},{"$f":"INDEX(PAR_STAT_BATTERY[[#All],[Waarde]],MATCH($I$40,PAR_STAT_BATTERY[[#All],[Variabele]],0))","v":15},null,null,"Details CAPEX"]
[null,null,null,null,null,null,null,null,{"$f":"Config!$A$61","v":"Prijs per kWh "},{"$f":"INDEX(PAR_STAT_BATTERY[[#All],[Waarde]],MATCH($I$41,PAR_STAT_BATTERY[[#All],[Variabele]],0))","v":550},null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Aanschafkosten batterijcontainer \",\"Purchase price batterycontainer \")","v":"Aanschafkosten batterijcontainer "},{"$f":"$J$41*$J$42","v":550000}]
[null,null,null,null,null,null,null,null,{"$f":"Config!$A$62","v":"Capaciteit batterij (kWh)"},{"$f":"INDEX(PAR_STAT_BATTERY[[#All],[Waarde]],MATCH($I$42,PAR_STAT_BATTERY[[#All],[Variabele]],0))","v":1000},null,null,{"$f":"Config!$A$67","v":"Afleveringsskosten "},{"$f":"INDEX(PAR_STAT_BATTERY[[#All],[Waarde]],MATCH($M$42,PAR_STAT_BATTERY[[#All],[Variabele]],0))","v":1500}]
[null,null,null,null,null,null,null,null,{"$f":"Config!$A$63","v":"Max. ontlading batterij "},{"$f":"INDEX(PAR_STAT_BATTERY[[#All],[Waarde]],MATCH($I$43,PAR_STAT_BATTERY[[#All],[Variabele]],0))","v":0.8},null,null,{"$f":"Config!$A$68","v":"Plaatsingskosten "},{"$f":"INDEX(PAR_STAT_BATTERY[[#All],[Waarde]],MATCH($M$43,PAR_STAT_BATTERY[[#All],[Variabele]],0))","v":5000}]
[null,null,null,null,null,null,null,null,{"$f":"Config!$A$64","v":"Sessies per week "},{"$f":"INDEX(PAR_STAT_BATTERY[[#All],[Waarde]],MATCH($I$44,PAR_STAT_BATTERY[[#All],[Variabele]],0))","v":5},null,null,{"$f":"Config!$A$69","v":"Extra opties "},{"$f":"INDEX(PAR_STAT_BATTERY[[#All],[Waarde]],MATCH($M$44,PAR_STAT_BATTERY[[#All],[Variabele]],0))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Jaarlijkse batterij capaciteit \",\"Yearly battery capacity \")","v":"Jaarlijkse batterij capaciteit "},{"$f":"J42*J44*J43*52","v":208000}]
[]
[null,null,null,null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Inkoopprijs elektriciteit\",\"Purchase price electricity\")","v":"Inkoopprijs elektriciteit"},null,null,null,null,"Details OPEX"]
[null,null,null,null,null,null,null,null,{"$f":"IF('Read Me'!$C$3=\"Nederlands\",\"Via publieke net \",\"Via power network \")","v":"Via publieke net "},{"$f":"'Input-Output Module'!$E$32","v":0.122072892561983},null,null,{"$f":"Config!$A$70","v":"Onderhoudscontract "},{"$f":"INDEX(PAR_STAT_BATTERY[[#All],[Waarde]],MATCH($M$48,PAR_STAT_BATTERY[[#All],[Variabele]],0))","v":5400}]
[null,null,null,null,null,null,null,null,{"$f":"Config!$A$65","v":"Eigen opwek "},{"$f":"INDEX(PAR_STAT_BATTERY[[#All],[Waarde]],MATCH($I$49,PAR_STAT_BATTERY[[#All],[Variabele]],0))","v":0.06},null,null,{"$f":"Config!$A$71","v":"Energiemanagement software "},{"$f":"INDEX(PAR_STAT_BATTERY[[#All],[Waarde]],MATCH($M$49,PAR_STAT_BATTERY[[#All],[Variabele]],0))","v":7500}]
[null,null,null,null,null,null,null,null,{"$f":"Config!$A$66","v":"Fractie eigen opwek "},{"$f":"INDEX(PAR_STAT_BATTERY[[#All],[Waarde]],MATCH($I$50,PAR_STAT_BATTERY[[#All],[Variabele]],0))","v":0.5},null,null,{"$f":"Config!$A$72","v":"Monitoring "},{"$f":"INDEX(PAR_STAT_BATTERY[[#All],[Waarde]],MATCH($M$50,PAR_STAT_BATTERY[[#All],[Variabele]],0))","v":15000}]

{"sheet":"Calculatie","index":3,"n_rows":56,"n_cols":25,"rows_kept":56,"cut":false,"hidden":false,"merged":[[14,1,14,4],[15,1,15,4]]}
["BASIS INVOERGEGEVENS"]
["Voertuig / ID",{"$f":"Voertuigtype","v":"Grote bakwagen (lvm > 16 ton)"},{"$f":"INDEX(Voertuigen[#All],MATCH(Calculatie!B2,Voertuigen[[#All],[Voertuig]],0),2)","v":5},null,null,"test","Dit is een overgenomen veld"]
["Voertuigtype / ID",{"$f":"INDEX(Voertuigen[#All],MATCH(Calculatie!B2,Voertuigen[[#All],[Voertuig]],0),3)","v":"Grote bakwagen"},{"$f":"INDEX(Voertuigen[#All],MATCH(Calculatie!B2,Voertuigen[[#All],[Voertuig]],0),4)","v":3},null,null,"test","Dit is een berekening"]
["Verwacht jaarkilometrage",{"$f":"Kilometrage","v":70000}]
["Grijze/groene elektriciciteit",{"$f":"Elec_type","v":"Groen"}]
["Grijze/groene waterstof",{"$f":"H2_type","v":"Electrolyse (hernieuwbare energie)"}]
["Rechtsvorm en belastingpercentage",{"$f":"Belasting","v":"BV of NV met 19% belasting"}]
["Grootte van bedrijf",{"$f":"Bedrijfsgrootte","v":"Groot"},null,null,null,null,null,null,null,null,"Berekeningen Laadpleinmodel"]
[null,null,null,null,null,null,null,null,null,null,"Aantal laadpalen en piekvermogen"]
["INZETGEGEVENS VOERTUIG SYSTEM","DV","EV","FC","H2ICE-CI",null,null,null,null,null,"Laadpaal","Vermogen [kW/u]","jaar 0","jaar 1-2","jaar 3-4","jaar 5-6","jaar 7-8","jaar 9-10","OPEX"]
["Economische levensduur [jaren]",{"$f":"'Input-Output Module'!D$36","v":7},{"$f":"'Input-Output Module'!E$36","v":7},{"$f":"'Input-Output Module'!F$36","v":7},{"$f":"'Input-Output Module'!G$36","v":7},null,null,null,null,null,"HPC350",{"$f":"INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH(Calculatie!K11,LaadinfraPrivaat[[#All],[Charging type]],0))","v":350},{"$f":"SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K11,'M3-TCO-laadplein'!R$9:R$14)","v":0},{"$f":"IF(\nSUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K11,'M3-TCO-laadplein'!S$9:S$14)<M11,\nM11,\nSUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K11,'M3-TCO-laadplein'!S$9:S$14))","v":0},{"$f":"IF(SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K11,'M3-TCO-laadplein'!T$9:T$14)<N11,\nN11,\nSUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K11,'M3-TCO-laadplein'!T$9:T$14))","v":0},{"$f":"IF(SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K11,'M3-TCO-laadplein'!U$9:U$14)<O11,\nO11,\nSUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K11,'M3-TCO-laadplein'!U$9:U$14))","v":0},{"$f":"IF(SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K11,'M3-TCO-laadplein'!V$9:V$14)<P11,P11,SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K11,'M3-TCO-laadplein'!V$9:V$14))","v":0},{"$f":"IF(SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K11,'M3-TCO-laadplein'!W$9:W$14)<Q11,Q11,SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K11,'M3-TCO-laadplein'!W$9:W$14))","v":0},{"$f":"SUM($N11:$R11)*2","v":0}]
["Kosten van reparaties",{"$f":"'Input-Output Module'!D$37","v":1000},{"$f":"'Input-Output Module'!E$37","v":1000},{"$f":"'Input-Output Module'!F$37","v":3000},{"$f":"'Input-Output Module'!G$37","v":1000},null,null,null,null,null,"HPC150",{"$f":"INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH(Calculatie!K12,LaadinfraPrivaat[[#All],[Charging type]],0))","v":150},{"$f":"SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K12,'M3-TCO-laadplein'!R$9:R$14)","v":0},{"$f":"IF(\nSUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K12,'M3-TCO-laadplein'!S$9:S$14)<M12,\nM12,\nSUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K12,'M3-TCO-laadplein'!S$9:S$14))","v":0},{"$f":"IF(SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K12,'M3-TCO-laadplein'!T$9:T$14)<N12,\nN12,\nSUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K12,'M3-TCO-laadplein'!T$9:T$14))","v":0},{"$f":"IF(SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K12,'M3-TCO-laadplein'!U$9:U$14)<O12,\nO12,\nSUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K12,'M3-TCO-laadplein'!U$9:U$14))","v":0},{"$f":"IF(SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K12,'M3-TCO-laadplein'!V$9:V$14)<P12,P12,SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K12,'M3-TCO-laadplein'!V$9:V$14))","v":0},{"$f":"IF(SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K12,'M3-TCO-laadplein'!W$9:W$14)<Q12,Q12,SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K12,'M3-TCO-laadplein'!W$9:W$14))","v":0},{"$f":"SUM($N12:$R12)*2","v":0}]
["Productieve dagen per jaar",{"$f":"Parameters!$C$15","v":260},{"$f":"B13-'Input-Output Module'!$E$39","v":260},{"$f":"B13-'Input-Output Module'!$F$39","v":260},{"$f":"B13-'Input-Output Module'!$G$39","v":260},null,null,null,null,null,"FC50",{"$f":"INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH(Calculatie!K13,LaadinfraPrivaat[[#All],[Charging type]],0))","v":50},{"$f":"SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K13,'M3-TCO-laadplein'!R$9:R$14)","v":0},{"$f":"IF(\nSUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K13,'M3-TCO-laadplein'!S$9:S$14)<M13,\nM13,\nSUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K13,'M3-TCO-laadplein'!S$9:S$14))","v":0},{"$f":"IF(SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K13,'M3-TCO-laadplein'!T$9:T$14)<N13,\nN13,\nSUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K13,'M3-TCO-laadplein'!T$9:T$14))","v":0},{"$f":"IF(SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K13,'M3-TCO-laadplein'!U$9:U$14)<O13,\nO13,\nSUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K13,'M3-TCO-laadplein'!U$9:U$14))","v":0},{"$f":"IF(SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K13,'M3-TCO-laadplein'!V$9:V$14)<P13,P13,SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K13,'M3-TCO-laadplein'!V$9:V$14))","v":0},{"$f":"IF(SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K13,'M3-TCO-laadplein'!W$9:W$14)<Q13,Q13,SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K13,'M3-TCO-laadplein'!W$9:W$14))","v":0},0]
["Productieve uren per jaar",{"$f":"'Input-Output Module'!$D$38","v":2600},{"$f":"$B$15*C13","v":2600},{"$f":"$B$15*D13","v":2600},{"$f":"$B$15*E13","v":2600},null,null,null,null,null,"AC22",{"$f":"INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH(Calculatie!K14,LaadinfraPrivaat[[#All],[Charging type]],0))","v":22},{"$f":"SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K14,'M3-TCO-laadplein'!R$9:R$14)","v":0},{"$f":"IF(\nSUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K14,'M3-TCO-laadplein'!S$9:S$14)<M14,\nM14,\nSUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K14,'M3-TCO-laadplein'!S$9:S$14))","v":0},{"$f":"IF(SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K14,'M3-TCO-laadplein'!T$9:T$14)<N14,\nN14,\nSUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K14,'M3-TCO-laadplein'!T$9:T$14))","v":0},{"$f":"IF(SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K14,'M3-TCO-laadplein'!U$9:U$14)<O14,\nO14,\nSUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K14,'M3-TCO-laadplein'!U$9:U$14))","v":0},{"$f":"IF(SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K14,'M3-TCO-laadplein'!V$9:V$14)<P14,P14,SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K14,'M3-TCO-laadplein'!V$9:V$14))","v":0},{"$f":"IF(SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K14,'M3-TCO-laadplein'!W$9:W$14)<Q14,Q14,SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K14,'M3-TCO-laadplein'!W$9:W$14))","v":0},0]
["Productieve uren per dag",{"$f":"B14/B13","v":10},null,null,null,null,null,null,null,null,"AC11",{"$f":"INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH(Calculatie!K15,LaadinfraPrivaat[[#All],[Charging type]],0))","v":11},{"$f":"SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K15,'M3-TCO-laadplein'!R$9:R$14)","v":0},{"$f":"IF(\nSUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K15,'M3-TCO-laadplein'!S$9:S$14)<M15,\nM15,\nSUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K15,'M3-TCO-laadplein'!S$9:S$14))","v":0},{"$f":"IF(SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K15,'M3-TCO-laadplein'!T$9:T$14)<N15,\nN15,\nSUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K15,'M3-TCO-laadplein'!T$9:T$14))","v":0},{"$f":"IF(SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K15,'M3-TCO-laadplein'!U$9:U$14)<O15,\nO15,\nSUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K15,'M3-TCO-laadplein'!U$9:U$14))","v":0},{"$f":"IF(SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K15,'M3-TCO-laadplein'!V$9:V$14)<P15,P15,SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K15,'M3-TCO-laadplein'!V$9:V$14))","v":0},{"$f":"IF(SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K15,'M3-TCO-laadplein'!W$9:W$14)<Q15,Q15,SUMIF('M3-TCO-laadplein'!$Q$9:$Q$14,Calculatie!$K15,'M3-TCO-laadplein'!W$9:W$14))","v":0},0]
["kilometers per dag",{"$f":"B4/B13","v":269.23076923076923},null,null,null,null,null,null,null,null,"Totaal",null,{"$f":"SUM(M11:M15)","v":0},{"$f":"SUM(N11:N15)","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,"Totaal piekvermogen [kW/u]",null,{"$f":"SUMPRODUCT($L$11:$L$15,M11:M15)","v":0},{"$f":"SUMPRODUCT($L$11:$L$15,N11:N15)","v":0},0,0,0,0]
["VOERTUIGKENMERKEN",null,null,null,null,null,null,null,null,null,"Totaal energie verbruik per jaar [kWh]",null,{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14<>\"\")*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!D$9:D$14)","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14<>\"\")*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!E$9:E$14)","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14<>\"\")*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!F$9:F$14)","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14<>\"\")*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!G$9:G$14)","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14<>\"\")*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!H$9:H$14)","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14<>\"\")*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!I$9:I$14)","v":0},null,{"$f":"SUM(N18:R18)*2","v":0}]
["Capaciteit vrachtwagenbatterij (kWh) ",null,{"$f":"'Input-Output Module'!$E$43","v":260},{"$f":"'Input-Output Module'!$F$43","v":140}]
["Waterstof opslag tank (kg)",null,null,{"$f":"'Input-Output Module'!$F$44","v":20},{"$f":"'Input-Output Module'!$G$44","v":0},null,null,null,null,null,"Inkoop"]
["Fuell cell system (kW)",null,null,{"$f":"'Input-Output Module'!$F$45","v":45},null,null,null,null,null,null,"Laadpaal","Kosten (inkoop + graafwerk)","jaar 0","jaar 1-2","jaar 3-4","jaar 5-6","jaar 7-8","jaar 9-10",null,"inkoopprijs",{"$f":"SUM(M27:R27)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"HPC350",{"$f":"INDEX(LaadinfraPrivaat[[#All],[Purchase (€)]],MATCH(Calculatie!K22,LaadinfraPrivaat[[#All],[Charging type]],0))","v":135056.25},0,{"$f":"N11-M11","v":0},{"$f":"O11-N11","v":0},0,0,0,null,"Graaf werk + civiele werken",{"$f":"SUMPRODUCT(LaadinfraPrivaat[Installation costs (€)]*(Calculatie!R11:R15-Calculatie!M11:M15))-U23-U24","v":0},null,"Installaties",{"$f":"INDEX(Piekvermogen[[#All],[Installaties per kW piekvermogen]],MATCH(IF(R17>2000,\"Meer dan 2MW\",\"Tot 2MW\"),Piekvermogen[[#All],[Piekvermogen]],0))*SUMPRODUCT(L11:L15*(R11:R15-M11:M15))","v":0}]
["ENERGIE EN KOSTEN"," Dieselvoertuig [L]"," Elektrisch voertuig [kWh]","Waterstof voertuig [kg]","H2ICE [kg]",null,null,null,null,null,"HPC150",{"$f":"INDEX(LaadinfraPrivaat[[#All],[Purchase (€)]],MATCH(Calculatie!K23,LaadinfraPrivaat[[#All],[Charging type]],0))","v":57881.25},0,{"$f":"N12-M12","v":0},0,0,0,0,null,"Projectmanagement/advies",{"$f":"SUMPRODUCT(LaadinfraPrivaat[Locatiebepaling, enginering, proj mgt ]*(Calculatie!R11:R15-Calculatie!M11:M15))","v":0}]
["Energie voor transport / jaar (bruto)",{"$f":"'M1-PowerSupply'!B$16*Calculatie!$B$4","v":19979.253814883396},{"$f":"'M1-PowerSupply'!C$16*Calculatie!$B$4","v":94020.017952392445},{"$f":"'M1-PowerSupply'!D$16*Calculatie!$B$4","v":6218.2551555815107},{"$f":"'M1-PowerSupply'!E$16*Calculatie!$B$4","v":0},null,null,null,null,null,"FC50",{"$f":"INDEX(LaadinfraPrivaat[[#All],[Purchase (€)]],MATCH(Calculatie!K24,LaadinfraPrivaat[[#All],[Charging type]],0))","v":19293.75},0,{"$f":"N13-M13","v":0},0,0,0,0,null,"aansluiten",{"$f":"SUMPRODUCT(LaadinfraPrivaat[Aansluitkosten netbeheerder (!)]*(Calculatie!R11:R15-Calculatie!M11:M15))","v":0}]
["Energie voor koeling / jaar (bruto)",{"$f":"'M1-PowerSupply'!B$17*Calculatie!B$14*INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Aandeel koelunit\",InzetVoertuigPar[[#All],[Variabele]],0))","v":0},{"$f":"'M1-PowerSupply'!C$17*Calculatie!C$14*INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Aandeel koelunit\",InzetVoertuigPar[[#All],[Variabele]],0))","v":0},{"$f":"'M1-PowerSupply'!D$17*Calculatie!D$14*INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Aandeel koelunit\",InzetVoertuigPar[[#All],[Variabele]],0))","v":0},{"$f":"'M1-PowerSupply'!E$17*Calculatie!E$14*INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Aandeel koelunit\",InzetVoertuigPar[[#All],[Variabele]],0))","v":0},null,null,null,null,null,"AC22",{"$f":"INDEX(LaadinfraPrivaat[[#All],[Purchase (€)]],MATCH(Calculatie!K25,LaadinfraPrivaat[[#All],[Charging type]],0))","v":2315.25},0,{"$f":"N14-M14","v":0},0,0,0,0,null,"CAPEX",{"$f":"SUM(U21:U24)","v":0}]
["Efficiëtie omzetting",{"$f":"INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Efficiëntie van transmissie overdracht (DV)\",InzetVoertuigPar[[#All],[Variabele]],0))","v":1},{"$f":"INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Efficiëntie van transmissie overdracht (EV)\",InzetVoertuigPar[[#All],[Variabele]],0))","v":1},{"$f":"INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Efficiëntie van transmissie overdracht (FC)\",InzetVoertuigPar[[#All],[Variabele]],0))","v":1},{"$f":"INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Efficiëntie van transmissie overdracht (H2ICE)\",InzetVoertuigPar[[#All],[Variabele]],0))","v":1},null,null,null,null,null,"AC11",{"$f":"INDEX(LaadinfraPrivaat[[#All],[Purchase (€)]],MATCH(Calculatie!K26,LaadinfraPrivaat[[#All],[Charging type]],0))","v":1984.5},0,{"$f":"N15-M15","v":0},0,0,0,0]
["Energie voor transport / jaar (netto)",{"$f":"B24/B$26","v":19979.253814883396},{"$f":"C24/C$26","v":94020.017952392445},{"$f":"D24/D$26","v":6218.2551555815107},{"$f":"E24/E$26","v":0},null,null,null,null,null,"Totale kosten",null,{"$f":"MAX(SUMPRODUCT($L$22:$L$26,M22:M26),0)","v":0},{"$f":"MAX(SUMPRODUCT($L$22:$L$26,N22:N26),0)","v":0},0,0,0,0]
["Energie voor koeling / jaar (netto)",{"$f":"B25/B$26","v":0},{"$f":"C25/C$26","v":0},{"$f":"D25/D$26","v":0},{"$f":"E25/E$26","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Periodieke net",{"$f":"SUMPRODUCT(S11:S15*LaadinfraPrivaat[Periodieke kosten netaansluiting (!)  ])","v":0},null," "]
["Aandeel depot laden (elektrisch)",null,{"$f":"'M1-PowerSupply'!B29/'M1-PowerSupply'!C18","v":0.57519665681603782},null,null,null,null,null,null,null,"Operationele kosten",null,null,null,null,null,null,null,null,"Operatie, onderhoud, service",{"$f":"SUMPRODUCT($S$11:$S$15,LaadinfraPrivaat[Operational costs annual (€)])-U28","v":0}]
["Aandeel extern laden (elektrisch)",null,{"$f":"'M1-PowerSupply'!B45/'M1-PowerSupply'!C18","v":0.42480334318396218},null,null,null,null,null,null,null,"Laadpaal","OPEX","jaar 0","jaar 1-2","jaar 3-4","jaar 5-6","jaar 7-8","jaar 9-10",null,"Energiekosten",{"$f":"SUM(M45:R45)*2","v":0}]
["Externe laadkosten (elektrisch)",null,{"$f":"INDEX(LaadinfraPubliek[[#All],[External energy costs (€)]],MATCH('M1-PowerSupply'!$C$42,LaadinfraPubliek[[#All],[Charging type]],0))","v":0.5},null,null,null,null,null,null,null,"HPC350",{"$f":"INDEX(LaadinfraPrivaat[[#All],[Operational costs annual (€)]],MATCH(Calculatie!$K31,LaadinfraPrivaat[[#All],[Charging type]],0))","v":18564.713210045},{"$f":"$L31*M11","v":0},{"$f":"$L31*N11","v":0},0,0,0,0,null,"OPEX",{"$f":"SUM(U28:U30)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"HPC150",{"$f":"INDEX(LaadinfraPrivaat[[#All],[Operational costs annual (€)]],MATCH(Calculatie!$K32,LaadinfraPrivaat[[#All],[Charging type]],0))","v":8506.8528043049992},{"$f":"$L32*M12","v":0},0,0,0,0,0,null,"(per kWh)",{"$f":"IF(U28+U29=0,0,\n(U28+U29)/(SUM($M$18:$R$18)*2))","v":0},"*exclusief energiekosten"]
["Jaarlijkse verandering kosten (depot)","n.v.t.",{"$f":"INDEX(JaarlijkseVeranderingen[[#All],[Waarde]],MATCH(\"Eigen energiekosten\",JaarlijkseVeranderingen[[#All],[Variabele]],0))","v":0.01},"n.v.t.","n.v.t.",null,null,null,null,null,"FC50",{"$f":"INDEX(LaadinfraPrivaat[[#All],[Operational costs annual (€)]],MATCH(Calculatie!$K33,LaadinfraPrivaat[[#All],[Charging type]],0))","v":4367.7976014350006},{"$f":"$L33*M13","v":0},0,0,0,0,0]
["Jaarlijkse verandering kosten (extern)",{"$f":"INDEX(JaarlijkseVeranderingen[[#All],[Waarde]],MATCH(\"Dieselprijs\",JaarlijkseVeranderingen[[#All],[Variabele]],0))","v":0.01},{"$f":"INDEX(JaarlijkseVeranderingen[[#All],[Waarde]],MATCH(\"Energiekosten extern opladen\",JaarlijkseVeranderingen[[#All],[Variabele]],0))","v":0.01},{"$f":"INDEX(JaarlijkseVeranderingen[[#All],[Waarde]],MATCH(\"Waterstof\",JaarlijkseVeranderingen[[#All],[Variabele]],0))","v":0},{"$f":"INDEX(JaarlijkseVeranderingen[[#All],[Waarde]],MATCH(\"Waterstof\",JaarlijkseVeranderingen[[#All],[Variabele]],0))","v":0},null,null,null,null,null,"AC22",{"$f":"INDEX(LaadinfraPrivaat[[#All],[Operational costs annual (€)]],MATCH(Calculatie!$K34,LaadinfraPrivaat[[#All],[Charging type]],0))","v":1571.8833121721998},{"$f":"$L34*M14","v":0},0,0,0,0,0]
["Energiekosten transport / jaar",{"$f":"B$27*'Input-Output Module'!D$32\n*IF(B34=0,1,(1-(1+B34)^B11)/(1-(1+B34))/B11)","v":31834.281266616588},{"$f":"C$27*'Input-Output Module'!E$32*$C$29*IF(C33=0,1,(1-(1+C33)^C11)/(1-(1+C33))/C11)\n+C$27*C31*C30*IF(C34=0,1,(1-(1+C34)^C11)/(1-(1+C34))/C11)","v":27382.281849996929},{"$f":"D$27*'Input-Output Module'!F$32\n*IF(D34=0,1,(1-(1+D34)^D11)/(1-(1+D34))/D11)","v":118146.8479560487},{"$f":"E$27*'Input-Output Module'!F$32\n*IF(E34=0,1,(1-(1+E34)^E11)/(1-(1+E34))/E11)","v":0},null,null,null,null,null,"AC11",{"$f":"INDEX(LaadinfraPrivaat[[#All],[Operational costs annual (€)]],MATCH(Calculatie!$K35,LaadinfraPrivaat[[#All],[Charging type]],0))","v":494.03169614760003},{"$f":"$L35*M15","v":0},0,0,0,0,0,null,"Netverzwaring ",{"$f":"0.5*U25","v":0}]
["Energiekosten koeling / jaar",{"$f":"B$28*'Input-Output Module'!D$32\n*IF(B34=0,1,(1-(1+B34)^B11)/(1-(1+B34))/B11)","v":0},{"$f":"C$28*'Input-Output Module'!E$32*$C$29*IF(C33=0,1,(1-(1+C33)^C11)/(1-(1+C33))/C11)\n+C$28*C31*C30*IF(C34=0,1,(1-(1+C34)^C11)/(1-(1+C34))/C11)","v":0},{"$f":"D$28*'Input-Output Module'!F$32\n*IF(D34=0,1,(1-(1+D34)^D11)/(1-(1+D34))/D11)","v":0},{"$f":"E$28*'Input-Output Module'!F$32\n*IF(E34=0,1,(1-(1+E34)^E11)/(1-(1+E34))/E11)","v":0},null,null,null,null,null,"Totale kosten",null,{"$f":"SUM(M31:M35)","v":0},{"$f":"SUM(N31:N35)","v":0},0,0,0,0,null,"Transformator",72000]
["Totale energiekosten / jaar",{"$f":"B35+B36","v":31834.281266616588},{"$f":"C35+C36","v":27382.281849996929},{"$f":"D35+D36","v":118146.8479560487},{"$f":"E35+E36","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Energiekosten"]
["EMISSIES",null,null,null,null,null,null,null,null,null,"Laadpaal","Kosten per kWh","jaar 0","jaar 1-2","jaar 3-4","jaar 5-6","jaar 7-8","jaar 9-10"]
["WTW CO2-eq (tonnes)",{"$f":"(B28+B27)*SUMIFS(Fuel_Emission_factors27[[#All],[CO2-eq (kg per unit)]],Fuel_Emission_factors27[[#All],[Fuel category ID]],B$10,Fuel_Emission_factors27[[#All],[Type ID]],$C$3)/1000","v":64.716077686277629},{"$f":"(C28+C27)*SUMIFS(Fuel_Emission_factors27[[#All],[CO2-eq (kg per unit)]],Fuel_Emission_factors27[[#All],[Fuel category ID]],C$10,Fuel_Emission_factors27[[#All],[Type ID]],$B$5)/1000","v":0},{"$f":"(D28+D27)*SUMIFS(Fuel_Emission_factors27[[#All],[CO2-eq (kg per unit)]],Fuel_Emission_factors27[[#All],[Fuel category ID]],D$10,Fuel_Emission_factors27[[#All],[Type ID]],$B$6)/1000","v":0},{"$f":"D40","v":0},null,null,null,null,null,"HPC350",{"$f":"'Input-Output Module'!$E$32","v":0.122072892561983},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K40)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!D$9:D$14)*Calculatie!$L40","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K40)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!E$9:E$14)*Calculatie!$L40","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K40)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!F$9:F$14)*Calculatie!$L40","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K40)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!G$9:G$14)*Calculatie!$L40","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K40)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!H$9:H$14)*Calculatie!$L40","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K40)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!I$9:I$14)*Calculatie!$L40","v":0},null,"Toegestane opties",1,2,3,4,5]
["PMc (kg)",{"$f":"(B28+B27)*SUMIFS(Fuel_Emission_factors27[[#All],[PM10 combustion (g per unit)]],Fuel_Emission_factors27[[#All],[Fuel category ID]],B$10,Fuel_Emission_factors27[[#All],[Type ID]],$C$3)/1000","v":0.77174577238606457},{"$f":"(C28+C27)*SUMIFS(Fuel_Emission_factors27[[#All],[PM10 combustion (g per unit)]],Fuel_Emission_factors27[[#All],[Fuel category ID]],C$10,Fuel_Emission_factors27[[#All],[Type ID]],$B$5)/1000","v":0},{"$f":"(D28+D27)*SUMIFS(Fuel_Emission_factors27[[#All],[PM10 combustion (g per unit)]],Fuel_Emission_factors27[[#All],[Fuel category ID]],D$10,Fuel_Emission_factors27[[#All],[Type ID]],$B$6)/1000","v":0},{"$f":"C41","v":0},null,null,null,null,null,"HPC150",{"$f":"'Input-Output Module'!$E$32","v":0.122072892561983},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K41)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!D$9:D$14)*Calculatie!$L41","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K41)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!E$9:E$14)*Calculatie!$L41","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K41)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!F$9:F$14)*Calculatie!$L41","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K41)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!G$9:G$14)*Calculatie!$L41","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K41)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!H$9:H$14)*Calculatie!$L41","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K41)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!I$9:I$14)*Calculatie!$L41","v":0},null,"Bestelwagens (tot 3,5 ton)",{"$f":"IFERROR(INDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH((IF('M3-TCO-laadplein'!L9<>\"\",'M3-TCO-laadplein'!L9,'M3-TCO-laadplein'!K9)*IF('M3-TCO-laadplein'!N9<>\"\",'M3-TCO-laadplein'!N9,'M3-TCO-laadplein'!M9))/'M3-TCO-laadplein'!P9,LaadinfraPrivaat[[#All],[Power (kW)]],-1)),\"Niet mogelijk\")","v":"AC11"},{"$f":"IF(OR(INDEX(LaadinfraPrivaat[Index],MATCH(U41,LaadinfraPrivaat[Charging type],0))+1>5,U41=\"\"),\"\",\nINDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH(INDEX(LaadinfraPrivaat[Index],MATCH(U41,LaadinfraPrivaat[Charging type],0))+1,LaadinfraPrivaat[[#All],[Index]],0)))","v":"AC22"},{"$f":"IF(V41=\"\",\"\",\nIF(INDEX(LaadinfraPrivaat[Index],MATCH(V41,LaadinfraPrivaat[Charging type],0))+1>5,\"\",\nINDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH(INDEX(LaadinfraPrivaat[Index],MATCH(V41,LaadinfraPrivaat[Charging type],0))+1,LaadinfraPrivaat[[#All],[Index]],0))))","v":"FC50"},{"$f":"IF(W41=\"\",\"\",\nIF(INDEX(LaadinfraPrivaat[Index],MATCH(W41,LaadinfraPrivaat[Charging type],0))+1>5,\"\",\nINDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH(INDEX(LaadinfraPrivaat[Index],MATCH(W41,LaadinfraPrivaat[Charging type],0))+1,LaadinfraPrivaat[[#All],[Index]],0))))","v":"HPC150"},{"$f":"IF(X41=\"\",\"\",\nIF(INDEX(LaadinfraPrivaat[Index],MATCH(X41,LaadinfraPrivaat[Charging type],0))+1>5,\"\",\nINDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH(INDEX(LaadinfraPrivaat[Index],MATCH(X41,LaadinfraPrivaat[Charging type],0))+1,LaadinfraPrivaat[[#All],[Index]],0))))","v":"HPC350"}]
["PM_tire (kg)",{"$f":"INDEX(OperationeleKostenPerType[[#All],[PM_wear from tires]],MATCH(Calculatie!$C$3,OperationeleKostenPerType[[#All],[Type ID]],0))*$B$4/1000","v":5.6844816480881075},{"$f":"INDEX(OperationeleKostenPerType[[#All],[PM_wear from tires]],MATCH(Calculatie!$C$3,OperationeleKostenPerType[[#All],[Type ID]],0))*$B$4/1000","v":5.6844816480881075},{"$f":"INDEX(OperationeleKostenPerType[[#All],[PM_wear from tires]],MATCH(Calculatie!$C$3,OperationeleKostenPerType[[#All],[Type ID]],0))*$B$4/1000","v":5.6844816480881075},{"$f":"C42","v":5.6844816480881075},null,null,null,null,null,"FC50",{"$f":"'Input-Output Module'!$E$32","v":0.122072892561983},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K42)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!D$9:D$14)*Calculatie!$L42","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K42)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!E$9:E$14)*Calculatie!$L42","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K42)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!F$9:F$14)*Calculatie!$L42","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K42)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!G$9:G$14)*Calculatie!$L42","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K42)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!H$9:H$14)*Calculatie!$L42","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K42)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!I$9:I$14)*Calculatie!$L42","v":0},1,"Kleine bakwagen (lvm <12 ton)",{"$f":"IFERROR(INDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH((IF('M3-TCO-laadplein'!L10<>\"\",'M3-TCO-laadplein'!L10,'M3-TCO-laadplein'!K10)*IF('M3-TCO-laadplein'!N10<>\"\",'M3-TCO-laadplein'!N10,'M3-TCO-laadplein'!M10))/'M3-TCO-laadplein'!P10,LaadinfraPrivaat[[#All],[Power (kW)]],-1)),\"Niet mogelijk\")","v":"AC11"},{"$f":"IF(OR(INDEX(LaadinfraPrivaat[Index],MATCH(U42,LaadinfraPrivaat[Charging type],0))+1>5,U42=\"\"),\"\",\nINDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH(INDEX(LaadinfraPrivaat[Index],MATCH(U42,LaadinfraPrivaat[Charging type],0))+1,LaadinfraPrivaat[[#All],[Index]],0)))","v":"AC22"},{"$f":"IF(V42=\"\",\"\",\nIF(INDEX(LaadinfraPrivaat[Index],MATCH(V42,LaadinfraPrivaat[Charging type],0))+1>5,\"\",\nINDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH(INDEX(LaadinfraPrivaat[Index],MATCH(V42,LaadinfraPrivaat[Charging type],0))+1,LaadinfraPrivaat[[#All],[Index]],0))))","v":"FC50"},{"$f":"IF(W42=\"\",\"\",\nIF(INDEX(LaadinfraPrivaat[Index],MATCH(W42,LaadinfraPrivaat[Charging type],0))+1>5,\"\",\nINDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH(INDEX(LaadinfraPrivaat[Index],MATCH(W42,LaadinfraPrivaat[Charging type],0))+1,LaadinfraPrivaat[[#All],[Index]],0))))","v":"HPC150"},{"$f":"IF(X42=\"\",\"\",\nIF(INDEX(LaadinfraPrivaat[Index],MATCH(X42,LaadinfraPrivaat[Charging type],0))+1>5,\"\",\nINDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH(INDEX(LaadinfraPrivaat[Index],MATCH(X42,LaadinfraPrivaat[Charging type],0))+1,LaadinfraPrivaat[[#All],[Index]],0))))","v":"HPC350"}]
["NOx (kg)",{"$f":"(B28+B27)*SUMIFS(Fuel_Emission_factors27[[#All],[NOx (g per unit)]],Fuel_Emission_factors27[[#All],[Fuel category ID]],B$10,Fuel_Emission_factors27[[#All],[Type ID]],$C$3)/1000","v":587.67420169038235},{"$f":"(C28+C27)*SUMIFS(Fuel_Emission_factors27[[#All],[NOx (g per unit)]],Fuel_Emission_factors27[[#All],[Fuel category ID]],C$10,Fuel_Emission_factors27[[#All],[Type ID]],$B$5)/1000","v":0},{"$f":"(D28+D27)*SUMIFS(Fuel_Emission_factors27[[#All],[NOx (g per unit)]],Fuel_Emission_factors27[[#All],[Fuel category ID]],D$10,Fuel_Emission_factors27[[#All],[Type ID]],$B$6)/1000","v":0},{"$f":"B43","v":587.67420169038235},null,null,null,null,null,"AC22",{"$f":"'Input-Output Module'!$E$32","v":0.122072892561983},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K43)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!D$9:D$14)*Calculatie!$L43","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K43)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!E$9:E$14)*Calculatie!$L43","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K43)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!F$9:F$14)*Calculatie!$L43","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K43)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!G$9:G$14)*Calculatie!$L43","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K43)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!H$9:H$14)*Calculatie!$L43","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K43)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!I$9:I$14)*Calculatie!$L43","v":0},2,"Medium bakwagen (lvm 12-18 ton)",{"$f":"IFERROR(INDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH((IF('M3-TCO-laadplein'!L11<>\"\",'M3-TCO-laadplein'!L11,'M3-TCO-laadplein'!K11)*IF('M3-TCO-laadplein'!N11<>\"\",'M3-TCO-laadplein'!N11,'M3-TCO-laadplein'!M11))/'M3-TCO-laadplein'!P11,LaadinfraPrivaat[[#All],[Power (kW)]],-1)),\"Niet mogelijk\")","v":"FC50"},{"$f":"IF(OR(INDEX(LaadinfraPrivaat[Index],MATCH(U43,LaadinfraPrivaat[Charging type],0))+1>5,U43=\"\"),\"\",\nINDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH(INDEX(LaadinfraPrivaat[Index],MATCH(U43,LaadinfraPrivaat[Charging type],0))+1,LaadinfraPrivaat[[#All],[Index]],0)))","v":"HPC150"},{"$f":"IF(V43=\"\",\"\",\nIF(INDEX(LaadinfraPrivaat[Index],MATCH(V43,LaadinfraPrivaat[Charging type],0))+1>5,\"\",\nINDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH(INDEX(LaadinfraPrivaat[Index],MATCH(V43,LaadinfraPrivaat[Charging type],0))+1,LaadinfraPrivaat[[#All],[Index]],0))))","v":"HPC350"},{"$f":"IF(W43=\"\",\"\",\nIF(INDEX(LaadinfraPrivaat[Index],MATCH(W43,LaadinfraPrivaat[Charging type],0))+1>5,\"\",\nINDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH(INDEX(LaadinfraPrivaat[Index],MATCH(W43,LaadinfraPrivaat[Charging type],0))+1,LaadinfraPrivaat[[#All],[Index]],0))))","v":""},{"$f":"IF(X43=\"\",\"\",\nIF(INDEX(LaadinfraPrivaat[Index],MATCH(X43,LaadinfraPrivaat[Charging type],0))+1>5,\"\",\nINDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH(INDEX(LaadinfraPrivaat[Index],MATCH(X43,LaadinfraPrivaat[Charging type],0))+1,LaadinfraPrivaat[[#All],[Index]],0))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"AC11",{"$f":"'Input-Output Module'!$E$32","v":0.122072892561983},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K44)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!D$9:D$14)*Calculatie!$L44","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K44)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!E$9:E$14)*Calculatie!$L44","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K44)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!F$9:F$14)*Calculatie!$L44","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K44)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!G$9:G$14)*Calculatie!$L44","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K44)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!H$9:H$14)*Calculatie!$L44","v":0},{"$f":"SUMPRODUCT(('M3-TCO-laadplein'!$Q$9:$Q$14=Calculatie!$K44)*'M3-TCO-laadplein'!$O$9:$O$14*'M3-TCO-laadplein'!I$9:I$14)*Calculatie!$L44","v":0},3,"Grote bakwagen (lvm >18 ton)",{"$f":"IFERROR(INDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH((IF('M3-TCO-laadplein'!L12<>\"\",'M3-TCO-laadplein'!L12,'M3-TCO-laadplein'!K12)*IF('M3-TCO-laadplein'!N12<>\"\",'M3-TCO-laadplein'!N12,'M3-TCO-laadplein'!M12))/'M3-TCO-laadplein'!P12,LaadinfraPrivaat[[#All],[Power (kW)]],-1)),\"Niet mogelijk\")","v":"FC50"},{"$f":"IF(OR(INDEX(LaadinfraPrivaat[Index],MATCH(U44,LaadinfraPrivaat[Charging type],0))+1>5,U44=\"\"),\"\",\nINDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH(INDEX(LaadinfraPrivaat[Index],MATCH(U44,LaadinfraPrivaat[Charging type],0))+1,LaadinfraPrivaat[[#All],[Index]],0)))","v":"HPC150"},{"$f":"IF(V44=\"\",\"\",\nIF(INDEX(LaadinfraPrivaat[Index],MATCH(V44,LaadinfraPrivaat[Charging type],0))+1>5,\"\",\nINDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH(INDEX(LaadinfraPrivaat[Index],MATCH(V44,LaadinfraPrivaat[Charging type],0))+1,LaadinfraPrivaat[[#All],[Index]],0))))","v":"HPC350"},{"$f":"IF(W44=\"\",\"\",\nIF(INDEX(LaadinfraPrivaat[Index],MATCH(W44,LaadinfraPrivaat[Charging type],0))+1>5,\"\",\nINDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH(INDEX(LaadinfraPrivaat[Index],MATCH(W44,LaadinfraPrivaat[Charging type],0))+1,LaadinfraPrivaat[[#All],[Index]],0))))","v":""},{"$f":"IF(X44=\"\",\"\",\nIF(INDEX(LaadinfraPrivaat[Index],MATCH(X44,LaadinfraPrivaat[Charging type],0))+1>5,\"\",\nINDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH(INDEX(LaadinfraPrivaat[Index],MATCH(X44,LaadinfraPrivaat[Charging type],0))+1,LaadinfraPrivaat[[#All],[Index]],0))))","v":""}]
["Allowed NOx (kg)",{"$f":"INDEX(EnergieverbruikEnOnderhoudPerType[[#All],[Rijden EV '[kWh/km']]],MATCH(Calculatie!$C$3,EnergieverbruikEnOnderhoudPerType[[#All],[Type ID]],0))\n*INDEX(AdBleu[[#All],[Waarde]],MATCH(\"Nox standaard (Euro VI)\",AdBleu[[#All],[Variabele]],0))\n*$B$4\n/ 1000","v":43.249208258100531},null,null,{"$f":"INDEX(EnergieverbruikEnOnderhoudPerType[[#All],[Rijden EV '[kWh/km']]],MATCH(Calculatie!$C$3,EnergieverbruikEnOnderhoudPerType[[#All],[Type ID]],0))\n*INDEX(AdBleu[[#All],[Waarde]],MATCH(\"Nox standaard (Euro VI)\",AdBleu[[#All],[Variabele]],0))\n*$B$4\n/ 1000","v":43.249208258100531},null,null,null,null,null,"Totale kosten",null,{"$f":"SUM(M40:M44)","v":0},{"$f":"SUM(N40:N44)","v":0},0,0,0,0,4,"Lichte trekker z/opl (GVW <40 ton)",{"$f":"IFERROR(INDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH((IF('M3-TCO-laadplein'!L13<>\"\",'M3-TCO-laadplein'!L13,'M3-TCO-laadplein'!K13)*IF('M3-TCO-laadplein'!N13<>\"\",'M3-TCO-laadplein'!N13,'M3-TCO-laadplein'!M13))/'M3-TCO-laadplein'!P13,LaadinfraPrivaat[[#All],[Power (kW)]],-1)),\"Niet mogelijk\")","v":"HPC150"},{"$f":"IF(OR(INDEX(LaadinfraPrivaat[Index],MATCH(U45,LaadinfraPrivaat[Charging type],0))+1>5,U45=\"\"),\"\",\nINDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH(INDEX(LaadinfraPrivaat[Index],MATCH(U45,LaadinfraPrivaat[Charging type],0))+1,LaadinfraPrivaat[[#All],[Index]],0)))","v":"HPC350"},{"$f":"IF(V45=\"\",\"\",\nIF(INDEX(LaadinfraPrivaat[Index],MATCH(V45,LaadinfraPrivaat[Charging type],0))+1>5,\"\",\nINDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH(INDEX(LaadinfraPrivaat[Index],MATCH(V45,LaadinfraPrivaat[Charging type],0))+1,LaadinfraPrivaat[[#All],[Index]],0))))","v":""},{"$f":"IF(W45=\"\",\"\",\nIF(INDEX(LaadinfraPrivaat[Index],MATCH(W45,LaadinfraPrivaat[Charging type],0))+1>5,\"\",\nINDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH(INDEX(LaadinfraPrivaat[Index],MATCH(W45,LaadinfraPrivaat[Charging type],0))+1,LaadinfraPrivaat[[#All],[Index]],0))))","v":""},{"$f":"IF(X45=\"\",\"\",\nIF(INDEX(LaadinfraPrivaat[Index],MATCH(X45,LaadinfraPrivaat[Charging type],0))+1>5,\"\",\nINDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH(INDEX(LaadinfraPrivaat[Index],MATCH(X45,LaadinfraPrivaat[Charging type],0))+1,LaadinfraPrivaat[[#All],[Index]],0))))","v":""}]
["Reduction of NOx by Adblue (kg)",{"$f":"MAX(0,B43-B45)","v":544.42499343228178},null,null,{"$f":"MAX(0,E43-E45)","v":544.42499343228178},null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Zware trekker z/opl (GVW >40 ton)",{"$f":"IFERROR(INDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH((IF('M3-TCO-laadplein'!L14<>\"\",'M3-TCO-laadplein'!L14,'M3-TCO-laadplein'!K14)*IF('M3-TCO-laadplein'!N14<>\"\",'M3-TCO-laadplein'!N14,'M3-TCO-laadplein'!M14))/'M3-TCO-laadplein'!P14,LaadinfraPrivaat[[#All],[Power (kW)]],-1)),\"Niet mogelijk\")","v":"HPC150"},{"$f":"IF(OR(INDEX(LaadinfraPrivaat[Index],MATCH(U46,LaadinfraPrivaat[Charging type],0))+1>5,U46=\"\"),\"\",\nINDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH(INDEX(LaadinfraPrivaat[Index],MATCH(U46,LaadinfraPrivaat[Charging type],0))+1,LaadinfraPrivaat[[#All],[Index]],0)))","v":"HPC350"},{"$f":"IF(V46=\"\",\"\",\nIF(INDEX(LaadinfraPrivaat[Index],MATCH(V46,LaadinfraPrivaat[Charging type],0))+1>5,\"\",\nINDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH(INDEX(LaadinfraPrivaat[Index],MATCH(V46,LaadinfraPrivaat[Charging type],0))+1,LaadinfraPrivaat[[#All],[Index]],0))))","v":""},{"$f":"IF(W46=\"\",\"\",\nIF(INDEX(LaadinfraPrivaat[Index],MATCH(W46,LaadinfraPrivaat[Charging type],0))+1>5,\"\",\nINDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH(INDEX(LaadinfraPrivaat[Index],MATCH(W46,LaadinfraPrivaat[Charging type],0))+1,LaadinfraPrivaat[[#All],[Index]],0))))","v":""},{"$f":"IF(X46=\"\",\"\",\nIF(INDEX(LaadinfraPrivaat[Index],MATCH(X46,LaadinfraPrivaat[Charging type],0))+1>5,\"\",\nINDEX(LaadinfraPrivaat[[#All],[Charging type]],MATCH(INDEX(LaadinfraPrivaat[Index],MATCH(X46,LaadinfraPrivaat[Charging type],0))+1,LaadinfraPrivaat[[#All],[Index]],0))))","v":""}]
["Adblue cost",{"$f":"B46 * 1000\n*INDEX(AdBleu[[#All],[Waarde]],MATCH(\"Adblue gebruik\",AdBleu[[#All],[Variabele]],0))\n*INDEX(AdBleu[[#All],[Waarde]],MATCH(\"Kosten Adblue\",AdBleu[[#All],[Variabele]],0))","v":342.71476482753457},null,null,{"$f":"E46 * 1000\n*INDEX(AdBleu[[#All],[Waarde]],MATCH(\"Adblue gebruik\",AdBleu[[#All],[Variabele]],0))\n*INDEX(AdBleu[[#All],[Waarde]],MATCH(\"Kosten Adblue\",AdBleu[[#All],[Variabele]],0))","v":342.71476482753457}]
[]
["HERNIEUWBARE ENERGIE-EENHEDEN"]
["Gebruikte energie",null,{"$f":"C27+C28","v":94020.017952392445},{"$f":"D27+D28","v":6218.2551555815107},{"$f":"E27+E28","v":0}]
["Omrekenen naar GJ",null,{"$f":"C50*0.0036","v":338.47206462861277},{"$f":"D50*INDEX(HBEs[[#All],[Waarde]],MATCH(\"Energiewaarde (MJ) per kg H2\",HBEs[[#All],[Variabele]],0))/1000","v":746.81244418533936},{"$f":"E50*INDEX(HBEs[[#All],[Waarde]],MATCH(\"Energiewaarde (MJ) per kg H2\",HBEs[[#All],[Variabele]],0))/1000","v":0},"Want 1 HBE = 1GJ"]
["Forfait",null,{"$f":"IF(Elec_type=Config!$A$16,1,INDEX(HBEs[[#All],[Waarde]],MATCH(\"Aandeel groene energie 'grijze' stroom\",HBEs[[#All],[Variabele]],0)))","v":1},{"$f":"IF(H2_type=Config!$A$19,1,0)","v":1},{"$f":"IF(H2_type=Config!$A$19,1,0)","v":1},"Als voor EV geen 100% groene stroom wordt gebruikt, dan mag niet alles worden meegenomen"]
["Hoeveelheid hernieuwbare energie",null,{"$f":"C52*C51","v":338.47206462861277},{"$f":"D52*D51","v":746.81244418533936},{"$f":"E52*E51","v":0}]
["Multiplier",null,{"$f":"INDEX(HBEs[[#All],[Waarde]],MATCH(_xlfn.CONCAT(\"Multiplier \",Calculatie!$C$10),HBEs[[#All],[Variabele]],0))","v":4},{"$f":"INDEX(HBEs[[#All],[Waarde]],MATCH(_xlfn.CONCAT(\"Multiplier \",Calculatie!$D$10),HBEs[[#All],[Variabele]],0))","v":2.5},{"$f":"INDEX(HBEs[[#All],[Waarde]],MATCH(_xlfn.CONCAT(\"Multiplier \",Calculatie!$D$10),HBEs[[#All],[Variabele]],0))","v":2.5}]
["HBE's (onafgerond)",null,{"$f":"C54*C53","v":1353.8882585144511},{"$f":"D54*D53","v":1867.0311104633483},{"$f":"E54*E53","v":0}]
["HBE's",null,{"$f":"ROUNDDOWN(C55,0)","v":1353},{"$f":"ROUNDDOWN(D55,0)","v":1867},{"$f":"ROUNDDOWN(E55,0)","v":0},"HBE's moeten altijd naar beneden worden afgerond"]

{"sheet":"M1-PowerSupply","index":4,"n_rows":51,"n_cols":14,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["BASIS INVOERGEGEVENS"]
["Voertuig / ID",{"$f":"Voertuigtype","v":"Grote bakwagen (lvm > 16 ton)"},{"$f":"INDEX(Voertuigen[#All],MATCH(Calculatie!B2,Voertuigen[[#All],[Voertuig]],0),2)","v":5},null,null,"test","Dit is een overgenomen veld"]
["Voertuigtype / ID",{"$f":"INDEX(Voertuigen[#All],MATCH(Calculatie!B2,Voertuigen[[#All],[Voertuig]],0),3)","v":"Grote bakwagen"},{"$f":"INDEX(Voertuigen[#All],MATCH(Calculatie!B2,Voertuigen[[#All],[Voertuig]],0),4)","v":3},null,null,"test","Dit is een berekening"]
["Verwacht jaarkilometrage",{"$f":"Kilometrage","v":70000}]
["Grijze/groene elektriciciteit",{"$f":"Elec_type","v":"Groen"}]
["Grijze/groene waterstof",{"$f":"H2_type","v":"Electrolyse (hernieuwbare energie)"}]
["Rechtsvorm en belastingpercentage",{"$f":"Belasting","v":"BV of NV met 19% belasting"}]
["Grootte van bedrijf",{"$f":"Bedrijfsgrootte","v":"Groot"}]
["Gekoeld?",{"$f":"Koeling","v":"Nee"}]
["Km/dag",{"$f":"Calculatie!B16","v":269.23076923076923}]
["Productieve uren per dag",{"$f":"Calculatie!B15","v":10}]
[]
[]
[null," Dieselvoertuig"," Elektrisch voertuig ","Waterstof voertuig",null,null,null,null,"Batterij opties per variant [EV]","[kWh]",null,"FCEV variants","Batterij [kWh]","FC-tank [L]"]
[null,"DV","EV","FC","H2ICE",null,null,null,4,{"$f":"INDEX(FCEV_Variants[#All],MATCH('M1-PowerSupply'!$C$3,FCEV_Variants[[#All],[Type ID]],0),6)","v":260},null,1,{"$f":"INDEX(FCEV_Variants[#All],MATCH('M1-PowerSupply'!$C$3,FCEV_Variants[[#All],[Type ID]],0),7)","v":140},{"$f":"INDEX(FCEV_Variants[#All],MATCH('M1-PowerSupply'!$C$3,FCEV_Variants[[#All],[Type ID]],0),9)","v":20}]
["Energieverbruik/km",{"$f":"INDEX(EnergieverbruikEnOnderhoudPerType[[#All],[Rijden DV '[L/km']]],MATCH('M1-PowerSupply'!$C$3,EnergieverbruikEnOnderhoudPerType[[#All],[Type ID]],0))","v":0.28541791164119135},{"$f":"INDEX(EnergieverbruikEnOnderhoudPerType[[#All],[Rijden EV '[kWh/km']]],MATCH('M1-PowerSupply'!$C$3,EnergieverbruikEnOnderhoudPerType[[#All],[Type ID]],0))","v":1.3431431136056065},{"$f":"INDEX(EnergieverbruikEnOnderhoudPerType[[#All],[Rijden FC '[kg H2/km']]],MATCH('M1-PowerSupply'!$C$3,EnergieverbruikEnOnderhoudPerType[[#All],[Type ID]],0))","v":8.8832216508307291E-2},{"$f":"INDEX(EnergieverbruikEnOnderhoudPerType[[#All],[Rijden H2ICE '[kg H2 /km']]],MATCH('M1-PowerSupply'!$C$3,EnergieverbruikEnOnderhoudPerType[[#All],[Type ID]],0))","v":0},null,null,null,3,{"$f":"INDEX(FCEV_Variants[#All],MATCH('M1-PowerSupply'!$C$3,FCEV_Variants[[#All],[Type ID]],0),5)","v":200},null,1.25,{"$f":"M$15*L16","v":175},{"$f":"N$15*L16","v":25}]
["Energieverbruik koeleenheid/uur",{"$f":"IF(Koeling=Config!$A$11,INDEX(EnergieverbruikEnOnderhoudPerType[[#All],[Koelen DV '[L/uur']]],MATCH('M1-PowerSupply'!$C$3,EnergieverbruikEnOnderhoudPerType[[#All],[Type ID]],0)),0)","v":0},{"$f":"IF(Koeling=Config!$A$11,INDEX(EnergieverbruikEnOnderhoudPerType[[#All],[Koelen EV '[kWh/uur']]],MATCH('M1-PowerSupply'!$C$3,EnergieverbruikEnOnderhoudPerType[[#All],[Type ID]],0)),0)","v":0},{"$f":"IF(Koeling=Config!$A$11,INDEX(EnergieverbruikEnOnderhoudPerType[[#All],[Koelen FC '[kg H2/uur']]],MATCH('M1-PowerSupply'!$C$3,EnergieverbruikEnOnderhoudPerType[[#All],[Type ID]],0)),0)","v":0},{"$f":"IF(Koeling=Config!$A$11,INDEX(EnergieverbruikEnOnderhoudPerType[[#All],[Koelen H2ICE '[kg H2/uur']]],MATCH('M1-PowerSupply'!$C$3,EnergieverbruikEnOnderhoudPerType[[#All],[Type ID]],0)),0)","v":0},null,null,null,2,{"$f":"INDEX(FCEV_Variants[#All],MATCH('M1-PowerSupply'!$C$3,FCEV_Variants[[#All],[Type ID]],0),4)","v":180},null,1.5,{"$f":"M$15*L17","v":210},{"$f":"N$15*L17","v":30}]
["Energieverbruik voertuig / dag",{"$f":"B$16*$B$10+($B$11*INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Aandeel koelunit\",InzetVoertuigPar[[#All],[Variabele]],0))*'M1-PowerSupply'!B$17)","v":76.843283903397662},{"$f":"C$16*$B$10+($B$11*INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Aandeel koelunit\",InzetVoertuigPar[[#All],[Variabele]],0))*'M1-PowerSupply'!C$17)","v":361.6154536630479},{"$f":"D$16*$B$10+($B$11*INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Aandeel koelunit\",InzetVoertuigPar[[#All],[Variabele]],0))*'M1-PowerSupply'!D$17)","v":23.916365983005807},{"$f":"E$16*$B$10+($B$11*INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Aandeel koelunit\",InzetVoertuigPar[[#All],[Variabele]],0))*'M1-PowerSupply'!E$17)","v":0},null,null,null,1,{"$f":"INDEX(FCEV_Variants[#All],MATCH('M1-PowerSupply'!$C$3,FCEV_Variants[[#All],[Type ID]],0),3)","v":160}]
["[unit]"," [liters]"," [kWh]","[kg H2]","[kg H2]"]
[]
["Gewenste restcapaciteit batterij",null,{"$f":"INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Gewenste restcapaciteit batterij\",InzetVoertuigPar[[#All],[Variabele]],0))","v":0.2}]
["Aanbevolen batterijcapaciteit [kWh]",null,{"$f":"IF(C18/(1-C21)>$J$15,$J$15,INDEX($J$15:$J$18,MATCH(C18/(1-C21),$J$15:$J$18,-1)))","v":260}]
[]
[]
["Berekening benodigde eigen laadinfra voor EV voertuig"]
["Tijd om 's nachts op te laden [uur]",{"$f":"IF(24-B11>=8,8,MAX(0,24-B11))","v":8}]
["Grenswaarde opladen batterij",{"$f":"1-INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Gewenste restcapaciteit batterij\",InzetVoertuigPar[[#All],[Variabele]],0))","v":0.8},"voor een lange levensduur van een batterij te hebben is het noodzaak deze nooit 100% op te laden (of te ontladen)"]
["Gebruikte batterij",{"$f":"'Input-Output Module'!$E$43","v":260},"Als er geen gebruiker input is, wordt berekende waarde overgenomen. Anders gebruikersinput"]
["Benodigde energie",{"$f":"MIN(B28*B27,C18)","v":208}]
["Benodigde laadcapaciteit [kW/u]",{"$f":"B29/B26","v":26}]
["Aanbevolen systeem",{"$f":"IF(B30>=MAX(LaadinfraPrivaat[[#All],[Power (kW)]]),MAX(LaadinfraPrivaat[[#All],[Power (kW)]]),INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH(B30,LaadinfraPrivaat[[#All],[Power (kW)]],-1)))","v":50},{"$f":"INDEX(LaadinfraPrivaat[[#All],[Power]],MATCH('M1-PowerSupply'!$B$31,LaadinfraPrivaat[[#All],[Power (kW)]],0))","v":"50 kW"}]
["Gebruikt systeem [kW]",{"$f":"INDEX(LaadinfraPrivaat[[#All],[Power (kW)]],MATCH('M1-PowerSupply'!$C$32,LaadinfraPrivaat[[#All],[Power]],0))","v":50},{"$f":"'Input-Output Module'!D58","v":"50 kW"},"Als er geen gebruiker input is, wordt berekende waarde overgenomen. Anders gebruikersinput"]
[]
["Max depotladen",{"$f":"MIN(B29,B32*B26)","v":208}]
["Rest depot laden",{"$f":"B29-B34","v":0}]
[]
["Berekening benodigde externe laadinfra voor EV voertuig"]
["Benodigde externe energie",{"$f":"C18-B34","v":153.6154536630479}]
["Tijd voor opladen",{"$f":"INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Max. tijd per dag opladen extern\",InzetVoertuigPar[[#All],[Variabele]],0))","v":1}]
["max aantal sessies",{"$f":"INDEX(InzetVoertuigPar[[#All],[Waarde]],MATCH(\"Max. # keer opladen extern / dag\",InzetVoertuigPar[[#All],[Variabele]],0))","v":1}]
["Min. benodigde laadcapaciteit [kW/u]",{"$f":"B38/(B39*B40)","v":153.6154536630479}]
["Aanbevolen systeem [kW]",{"$f":"IF(B41>=MAX(LaadinfraPubliek[[#All],[Power (kW)]]),MAX(LaadinfraPubliek[[#All],[Power (kW)]]),INDEX(LaadinfraPubliek[[#All],[Power (kW)]],MATCH('M1-PowerSupply'!$B$41,LaadinfraPubliek[[#All],[Power (kW)]],-1)))","v":350},{"$f":"INDEX(LaadinfraPubliek[[#All],[Charging type]],MATCH('M1-PowerSupply'!$B$42,LaadinfraPubliek[[#All],[Power (kW)]],0))","v":"HPC350"}]
["Maximale hoeveelheid energie extern op te laden",{"$f":"B42*B40*B39","v":350}]
["Benodigd aantal uren voor laden",{"$f":"B38/B42","v":0.43890129618013685}]
["Extern geladen energie",{"$f":"MIN(B44*B42,B43)","v":153.6154536630479}]
[]
["Check validiteit"]
["Extern opladen duur",{"$f":"IF(B38>=B43,FALSE,TRUE)","v":true},"Kan met de externe laadinfra benodigde energie binnen max tijd voor opladen geleverd worden?"]
["Extern opladen capaciteit",{"$f":"IF(B38>=B28*B27*B40,FALSE,TRUE)","v":true},"Kan met batterijcapaciteit het aantal dagelijkse kms gereden worden met max aantal oplaadsessies per dag?"]
[]
["Scenario valide?",{"$f":"IF(AND(B48,B49),TRUE,FALSE)","v":true},"Uitgangspunt is dat men zoveel mogelijk met depotladen probeert te laden. Als meer energie nodig is, gebeurt dat via extern laden\nPast dat binnen de uitgangspunten? Dan is er sprake van een valide scenario. Anders niet."]

{"sheet":"M2-Subsidie","index":5,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
["Samenvatting gegevens"]
["Voertuigtype",{"$f":"Calculatie!$B$3","v":"Grote bakwagen"},null,null,null,"Parameters"]
["Voertuigtype ID",{"$f":"Calculatie!$C$3","v":3},null,null,null,"Maximale steun per categorie",null,null,null,null,"Percentage en investering per jaar"]
["Voertuig categorie",{"$f":"INDEX(AanzetCAT[#All],$B$4+1,2)","v":"N3 Bakwagen (lvm > 18t)"},null,null,null,"AanZET categorie","Omvang bedrijf","Max. steun [%]","Max. steun [€]",null,"Jaartal","MIA %","Min. Investering"]
["Rechtsvorm en belastingpercentage",{"$f":"INDEX(Belastinggegevens[[#All],[Belastingsklasse]],MATCH(Calculatie!$B$7,Keuzevelden[[#All],[Rechtsvorm en belastingpercentage]],0))","v":"BV of NV met 19% belasting"},null,null,null,"N2","Middelgroot",0.12,14700,null,2021,0.36,2500]
["Basisjaar prognose",{"$f":"MIN(YEAR(NOW()),MAX(MIAperJaar[[#All],[Jaartal]]))","v":2023},null,null,null,"N2","Klein",0.14799999999999999,18800,null,2022,0.45,2500]
["Grootte van bedrijf",{"$f":"INDEX(MaxStaatsSteun[[#All],[Omvang bedrijf]],MATCH(Calculatie!$B$8,Keuzevelden[[#All],[Grootte van bedrijf]],0))","v":"Groot"},null,null,null,"N2","Groot",6.0999999999999999E-2,7500,null,2023,0.36,2500]
["Minimale investering",{"$f":"INDEX(MIAperJaar[[#All],[Min. Investering]],MATCH($B$7,MIAperJaar[[#All],[Jaartal]],0))","v":2500},null,null,null,"N3 Bakwagen (lvm <= 18t)","Middelgroot",0.2,60500]
[null,null,null,null,null,"N3 Bakwagen (lvm <= 18t)","Klein",0.28599999999999998,86600]
["Algemene subsidie gegevens","EV","FC","H2ICE",null,"N3 Bakwagen (lvm <= 18t)","Groot",0.10299999999999999,31100]
["Investering voertuig (bruto)",{"$f":"'Input-Output Module'!$E$48","v":287265},{"$f":"'Input-Output Module'!$F$48","v":449564.39999999997},{"$f":"'Input-Output Module'!$G$48","v":0},null,"N3 Bakwagen (lvm > 18t)","Middelgroot",0.21,83200]
["Meerprijs t.o.v. Dieselvoertuig",{"$f":"IF(B12-'Input-Output Module'!$D$48>0,B12-'Input-Output Module'!$D$48,0)","v":136500},{"$f":"IF(C12-'Input-Output Module'!$D$48>0,C12-'Input-Output Module'!$D$48,0)","v":298799.39999999997},{"$f":"IF(D12-'Input-Output Module'!$D$48>0,D12-'Input-Output Module'!$D$48,0)","v":0},null,"N3 Bakwagen (lvm > 18t)","Klein",0.28999999999999998,115200]
["Maximale steun op grond van EU-staatssteunkalender",{"$f":"INDEX(MaxStaatsSteun[[#All],[Maximale steun (% van meerprijs)]],MATCH($B$8,MaxStaatsSteun[[#All],[Omvang bedrijf]],0))*B13","v":54600},{"$f":"INDEX(MaxStaatsSteun[[#All],[Maximale steun (% van meerprijs)]],MATCH($B$8,MaxStaatsSteun[[#All],[Omvang bedrijf]],0))*C13","v":119519.76},{"$f":"INDEX(MaxStaatsSteun[[#All],[Maximale steun (% van meerprijs)]],MATCH($B$8,MaxStaatsSteun[[#All],[Omvang bedrijf]],0))*D13","v":0},null,"N3 Bakwagen (lvm > 18t)","Groot",0.111,43900]
["AanZET-subsidie",{"$f":"'Input-Output Module'!$E$49","v":"Nee"},{"$f":"'Input-Output Module'!$F$49","v":"Nee"},{"$f":"'Input-Output Module'!$G$49","v":"Nee"},null,"N3 Trekker","Middelgroot",0.21,83200]
["MIA-subsidie",{"$f":"'Input-Output Module'!$E$50","v":"Ja"},{"$f":"'Input-Output Module'!$F$50","v":"Ja"},{"$f":"'Input-Output Module'!$G$50","v":"Ja"},null,"N3 Trekker","Klein",0.28999999999999998,115200]
["MIA-subsidie laadpaal",{"$f":"'Input-Output Module'!$D$61","v":"Ja"},null,null,null,"N3 Trekker","Groot",0.111,43900]
[]
["AanZET subsidie",null,null,null,null,"Maximale steun op grond van EU-staatssteunkalender"]
["Maximale steun",{"$f":"IF($B$15=Config!$A$11,\nMIN(\n'M2-Subsidie'!$B$12*SUMIFS(MaxSteun[[#All],[Max. steun '[%']]],MaxSteun[[#All],[AanZET categorie]],'M2-Subsidie'!$B$5,MaxSteun[[#All],[Omvang bedrijf]],'M2-Subsidie'!$B$8),\nSUMIFS(MaxSteun[[#All],[Max. steun '[€']]],MaxSteun[[#All],[AanZET categorie]],'M2-Subsidie'!$B$5,MaxSteun[[#All],[Omvang bedrijf]],'M2-Subsidie'!$B$8),\nB$14),0)","v":0},{"$f":"IF($C$15=Config!$A$11,\nMIN(\n'M2-Subsidie'!$C$12*SUMIFS(MaxSteun[[#All],[Max. steun '[%']]],MaxSteun[[#All],[AanZET categorie]],'M2-Subsidie'!$B$5,MaxSteun[[#All],[Omvang bedrijf]],'M2-Subsidie'!$B$8),\nSUMIFS(MaxSteun[[#All],[Max. steun '[€']]],MaxSteun[[#All],[AanZET categorie]],'M2-Subsidie'!$B$5,MaxSteun[[#All],[Omvang bedrijf]],'M2-Subsidie'!$B$8),\nC$14),0)","v":0},{"$f":"IF($D$15=Config!$A$11,\nMIN(\n'M2-Subsidie'!$D$12*SUMIFS(MaxSteun[[#All],[Max. steun '[%']]],MaxSteun[[#All],[AanZET categorie]],'M2-Subsidie'!$B$5,MaxSteun[[#All],[Omvang bedrijf]],'M2-Subsidie'!$B$8),\nSUMIFS(MaxSteun[[#All],[Max. steun '[€']]],MaxSteun[[#All],[AanZET categorie]],'M2-Subsidie'!$B$5,MaxSteun[[#All],[Omvang bedrijf]],'M2-Subsidie'!$B$8),\nD$14),0)","v":0},null,"Omvang bedrijf","Maximale steun (% van meerprijs)","Toelichting"]
[null,null,null,null,null,"Groot",0.4,">250 fte, >€50 mil omzet"]
["MIA (Milieu Investerings Aftrek)",null,null,null,null,"Middelgroot",0.5,"<250 fte, <€50 mil omzet"]
["Belastingpercentage",{"$f":"INDEX(Belastinggegevens[[#All],[Procent]],MATCH($B$6,Belastinggegevens[[#All],[Belastingsklasse]],0))","v":0.19},{"$f":"INDEX(Belastinggegevens[[#All],[Procent]],MATCH($B$6,Belastinggegevens[[#All],[Belastingsklasse]],0))","v":0.19},{"$f":"INDEX(Belastinggegevens[[#All],[Procent]],MATCH($B$6,Belastinggegevens[[#All],[Belastingsklasse]],0))","v":0.19},null,"Klein",0.6,"<50 fte, <€10 mil omzet"]
["MIA percentage",{"$f":"IF($B$16=Config!$A$11,\nINDEX(MIAperJaar[[#All],[MIA %]],MATCH($B$7,MIAperJaar[[#All],[Jaartal]],0)),\n0)","v":0.36},{"$f":"IF($C$16=Config!$A$11,\nINDEX(MIAperJaar[[#All],[MIA %]],MATCH($B$7,MIAperJaar[[#All],[Jaartal]],0)),\n0)","v":0.36},{"$f":"IF($D$16=Config!$A$11,\nINDEX(MIAperJaar[[#All],[MIA %]],MATCH($B$7,MIAperJaar[[#All],[Jaartal]],0)),\n0)","v":0.36}]
["Fictieve fiscale winst",{"$f":"INDEX(Belastinggegevens[[#All],[Gebruikte fiscale winst voor berekening]],MATCH($B$6,Belastinggegevens[[#All],[Belastingsklasse]],0))","v":200000},{"$f":"INDEX(Belastinggegevens[[#All],[Gebruikte fiscale winst voor berekening]],MATCH($B$6,Belastinggegevens[[#All],[Belastingsklasse]],0))","v":200000},{"$f":"INDEX(Belastinggegevens[[#All],[Gebruikte fiscale winst voor berekening]],MATCH($B$6,Belastinggegevens[[#All],[Belastingsklasse]],0))","v":200000},null,"AanZET categorie verdeling"]
["Aftrekpost",{"$f":"IF(B12>=$B$9,(B12-B20)*B24,0)","v":103415.4},{"$f":"IF(C12>=$B$9,(C12-C20)*C24,0)","v":161843.18399999998},{"$f":"IF(D12>=$B$9,(D12-D20)*D24,0)","v":0},null,"Voertuigtype","AanZET categorie"]
["Fiscaal voordeel MIA",{"$f":"(B23*B25)-((B25-B26)*B23)","v":19648.925999999999},{"$f":"(C23*C25)-((C25-C26)*C23)","v":30750.204959999995},{"$f":"(D23*D25)-((D25-D26)*D23)","v":0},null,"Kleine bakwagen","N2"]
["MIA (Milieu Investerings Aftrek) Laadpaal",null,null,null,null,"Medium bakwagen","N3 Bakwagen (lvm <= 18t)"]
["Investering Laadpaal",{"$f":"'Input-Output Module'!$D$59+'Input-Output Module'!$D$60","v":32104.035},null,null,null,"Grote bakwagen","N3 Bakwagen (lvm > 18t)"]
["MIA percentage",{"$f":"IF($B$17=Config!$A$11,\nINDEX(MIAperJaar[[#All],[MIA %]],MATCH($B$7,MIAperJaar[[#All],[Jaartal]],0)),\n0)","v":0.36},null,null,null,"Lichte trekker z/opl","N3 Trekker"]
["Aftrekpost",{"$f":"IF(B29>=B9,B29*B30,0)","v":11557.452599999999},null,null,null,"Zware trekker z/opl","N3 Trekker"]
["Fiscaal voordeel MIA",{"$f":"(B23*B25)-((B25-B31)*B23)","v":2195.9159939999954}]
[null,null,null,null,null,"Belastinggegevens"]
["Uiteindelijke subsidie",null,null,null,null,"Belastingsklasse","Procent","Bovengrens Fiscale winst","Gebruikte fiscale winst voor berekening"]
["AanZET",{"$f":"B20","v":0},{"$f":"C20","v":0},{"$f":"D20","v":0},null,"BV of NV met 19% belasting",0.19,200000,200000]
["MIA",{"$f":"IF(B27<=(B14-B35),B27,IF(B14-B35<=0,0,B14-B35))","v":19648.925999999999},{"$f":"IF(C27<=(C14-C35),C27,IF(C14-C35<=0,0,C14-C35))","v":30750.204959999995},{"$f":"IF(D27<=(D14-D35),D27,IF(D14-D35<=0,0,D14-D35))","v":0},null,"BV of NV met 25,8% belasting",0.25800000000000001,null,400000]
["MIA Laadpaal",{"$f":"B32","v":2195.9159939999954},null,null,null,"Eenmanszaak met 36,93% belasting",0.36930000000000002,73031,73031]
["Totaal",{"$f":"SUM(B35:B37)","v":21844.841993999995},{"$f":"SUM(C35:C37)","v":30750.204959999995},{"$f":"SUM(D35:D37)","v":0},null,"Eenmanszaak met 49,5% belasting",0.495,null,146062]
[]
[null,"Als de totale hoeveelheid aan subsidies kleiner is dat de maximale steun gebeurt hier niks nieuws"]
[null,"Als dat wel het geval is, wordt eerst de maximale subsidie aan AanZET toegekend en dan MIA"]
[null,"Voor laadpalen is de aanname gemaakt dat de aanschaf van een Laadpaal los ingediend wordt en dus niet meetelt voor het maximum per project"]

{"sheet":"Invoer en categorieën","index":6,"n_rows":80,"n_cols":20,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Voertuigen en kenmerken",null,null,null,null,null,null,null,null,null,null,null,null,"Opties keuzevelden en defaultwaarden"]
[null,"Basisjaar financiële cijfers:",2023,"(relevant voor indexatie)"]
[null,"Voertuig","Voertuig ID","Type","Type ID","Casco kosten voertuig (DV)","H2ICE Casco","Aanschaf koelsysteem","Kilometrage","Productive uren per jaar","Afschrijftermijn","Uurloon",null,null,"Optie","Grijze/groene elektriciciteit","Grijze/groene waterstof","Rechtsvorm en belastingpercentage","Grootte van bedrijf"]
[null,{"$f":"Config!A37","v":"Kleine bakwagen (lvm ca. 6 ton)"},1,{"$f":"Config!A47","v":"Kleine bakwagen"},1,81937.5,0,17500,35000,2600,7,31.48,null,null,"keuze 1",{"$f":"Config!$A$15","v":"Grijs"},{"$f":"Config!$A$15","v":"Grijs"},{"$f":"Config!$A$20","v":"BV of NV met 19% belasting"},{"$f":"Config!$A$26","v":"Groot"}]
[null,{"$f":"Config!A38","v":"Kleine bakwagen/ Verhuiswagen"},2,{"$f":"Config!A47","v":"Kleine bakwagen"},1,66120,0,0,35000,1600,5,24.7,null,null,"keuze 2",{"$f":"Config!$A$16","v":"Groen"},{"$f":"Config!$A$17","v":"Blauw"},{"$f":"Config!$A$21","v":"BV of NV met 25,8% belasting"},{"$f":"Config!$A$25","v":"Middelgroot"}]
[null,{"$f":"Config!A39","v":"Medium bakwagen (lvm ca. 9 ton)"},3,{"$f":"Config!A48","v":"Medium bakwagen"},2,116351.24999999997,0,20000,70000,2600,7,31.48,null,null,"keuze 3",null,{"$f":"Config!$A$18","v":"Electrolyse (netstroom)"},{"$f":"Config!$A$22","v":"Eenmanszaak met 36,93% belasting"},{"$f":"Config!$A$24","v":"Klein"}]
[null,{"$f":"Config!A40","v":"Medium bakwagen/ Verhuiswagen"},4,{"$f":"Config!A48","v":"Medium bakwagen"},2,129959.99999999999,0,0,30000,1800,8,29.5,null,null,"keuze 4",null,{"$f":"Config!$A$19","v":"Electrolyse (hernieuwbare energie)"},{"$f":"Config!$A$23","v":"Eenmanszaak met 49,5% belasting"}]
[null,{"$f":"Config!A41","v":"Grote bakwagen (lvm > 16 ton)"},5,{"$f":"Config!A49","v":"Grote bakwagen"},3,150765,0,22500,70000,2600,7,31.48,null,null,"keuze 5"]
[null,{"$f":"Config!A42","v":"Grote bakwagen/ Verhuiswagen"},6,{"$f":"Config!A49","v":"Grote bakwagen"},3,150480,0,0,47000,2000,11,28.9,null,null,"keuze 6"]
[null,{"$f":"Config!A43","v":"Grote bakwagen/ Bouwvervoer"},7,{"$f":"Config!A49","v":"Grote bakwagen"},3,245616,0,0,42000,2600,7,31.479999999999997,null,null,"keuze 7"]
[null,{"$f":"Config!A44","v":"Lichte trekker z/opl (GVW < 40 ton)"},8,{"$f":"Config!A50","v":"Lichte trekker z/opl"},4,124872.74999999997,0,0,100000,2600,7,31.479999999999997,null,null,"keuze 8"]
[null,{"$f":"Config!A45","v":"Zware trekker z/opl (GVW > 40 ton)"},9,{"$f":"Config!A51","v":"Zware trekker z/opl"},5,144209.99999999997,171421,0,100000,2600,7,31.479999999999997,null,null,"keuze 9"]
[null,{"$f":"Config!A46","v":"Zware trekker z/opl/  Containertrucking"},10,{"$f":"Config!A51","v":"Zware trekker z/opl"},5,115000,142211,0,105000,2600,7,31.479999999999997,null,null,"keuze 10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defaultwaarde",{"$f":"P6","v":"Groen"},{"$f":"Q8","v":"Electrolyse (hernieuwbare energie)"},{"$f":"R5","v":"BV of NV met 19% belasting"},{"$f":"S5","v":"Groot"}]
[]
[]
[null,"Verschillende operationele kostenparameters per voertuigtype"]
[null,"Basisjaar financiële cijfers:",2023]
[null,"Type ID","Type","PM_wear from tires","Bandenkosten (€/km)","Versch. voertuigkosten","Speciale transportkosten","Onderhoud koeling","Eurovignet","Tolheffing","Wegenbelasting"]
[null,1,"Kleine bakwagen",8.120688068697296E-2,2.3121345000000001E-2,73.791359999999997,410.75625000000002,0.33928247454491889,750,0,315.89999999999998]
[null,2,"Medium bakwagen",8.120688068697296E-2,2.2769128499999999E-2,73.791359999999997,399.10124999999999,0.39397641101914582,750,0,315.89999999999998]
[null,3,"Grote bakwagen",8.120688068697296E-2,2.2416912000000001E-2,73.791359999999997,399.10124999999999,0.44867034749337281,750,0,315.89999999999998]
[null,4,"Lichte trekker z/opl",7.472008133479488E-2,3.4449939999999998E-2,73.791359999999997,996.82219999999995,0.56501921174668646,1250,0,851.61]
[null,5,"Zware trekker z/opl",6.8233281982616786E-2,4.6482967999999993E-2,73.791359999999997,996.82219999999995,0.68136807600000004,1250,0,851.61]
[]
[]
[null,"Energieverbruik en onderhoudskosten per voertuigtype en aandrijving",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prijzen van accus/power/tank"]
[null,"Basisjaar financiële cijfers:",2023,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Basisjaar financiële cijfers:",2023]
[null,"Type ID","Type","Rijden DV [L/km]","Rijden EV [kWh/km]","Rijden FC [kg H2/km]","Koelen DV [L/uur]","Koelen EV [kWh/uur]","Koelen FC [kg H2/uur]","Reparaties DV [€/jaar]","Reparaties EV [€/jaar]","Reparaties FC [€/jaar]","Onderhoud DV [€/km]","Onderhoud EV [€/km]","Onderhoud FC [€/km]","Rijden H2ICE [kg H2 /km]","Koelen H2ICE [kg H2/uur]",null,"Component","prijs/unit"]
[null,1,"Kleine bakwagen",0.1023274910240381,0.48154113423076755,3.1847958613146002E-2,1,3.92,0.25925925925925924,500,500,1500,5.2364500000000008E-2,2.6182250000000004E-2,7.8546750000000012E-2,null,null,null,"Battery (per kWh)",525]
[null,2,"Medium bakwagen",0.20136262941514174,0.94758884430654944,6.2671219861544267E-2,1.5,5.88,0.38888888888888884,500,500,1500,5.7599150000000002E-2,2.8799575000000001E-2,8.639872500000001E-2,null,null,null,"Fuel cell system (per kW)",1535]
[null,3,"Grote bakwagen",0.28541791164119135,1.3431431136056065,8.8832216508307291E-2,2.5,9.8000000000000007,0.64814814814814814,1000,1000,3000,6.2833799999999995E-2,3.1416899999999998E-2,9.4250699999999993E-2,null,null,null,"H2 storage (per kg)",1275]
[null,4,"Lichte trekker z/opl",0.29566505637688012,1.3913649711853182,9.2021492803261787E-2,null,null,null,1500,1500,5000,7.3295699999999991E-2,3.6647849999999996E-2,0.10994354999999999,null,null,null,"Fuel cell production costs (%)",1.41]
[null,5,"Zware trekker z/opl",0.44324279560022695,1.66,0.10978836,null,null,null,1500,1500,5000,8.3757600000000001E-2,4.1878800000000001E-2,0.12563640000000001,0.14299999999999999]
[]
[]
[null,"EV/FC varianten: accupakketten, power en tank"]
[null,"Basisjaar financiële cijfers:",2023]
[null,"Type ID","Type","EV accu 1 [kWh]","EV accu 2 [kWh]","EV accu 3 [kWh]","EV accu 4 [kWh]","FC accu","FC power","FC H2 tank","H2ICE H2 tank"]
[null,1,"Kleine bakwagen",80,120,160,200,70,30,15,0]
[null,2,"Medium bakwagen",120,160,180,240,150,40,15,0]
[null,3,"Grote bakwagen",160,180,200,260,140,45,20,0]
[null,4,"Lichte trekker z/opl",180,220,260,340,140,60,30,0]
[null,5,"Zware trekker z/opl",300,400,440,540,200,80,50,84]
[]
[]
[null,"Eigenschappen private laadinfra"]
[null,"Basisjaar financiële cijfers:",2023]
[null,"Index","Charging type","Power","Land type","Power (kW)","Purchase & installation (€) ","Purchase (€)","Installation costs (€)","Operational costs annual (€)","Afschrijftermijn","Graaf werk","Locatiebepaling, enginering, proj mgt ","Aansluitkosten netbeheerder (!)","Periodieke kosten netaansluiting (!)  ",null,"Piekvermogen","Installaties per kW piekvermogen"]
[null,5,"HPC350","350 kW","Privaat",350,{"$f":"INDEX(Laadpleinkosten!$C$29:$H$29,1,MATCH(LaadinfraPrivaat[[#This Row],[Power]],Laadpleinkosten!$C$21:$H$21,0))","v":208481.66999999998},{"$f":"INDEX(Laadpleinkosten!$C$24:$H$24,1,MATCH(LaadinfraPrivaat[[#This Row],[Power]],Laadpleinkosten!$C$21:$H$21,0))","v":135056.25},{"$f":"LaadinfraPrivaat[[#This Row],[Purchase & installation (€) ]]-LaadinfraPrivaat[[#This Row],[Purchase (€)]]","v":73425.419999999984},{"$f":"INDEX(Laadpleinkosten!$C$39:$H$39,1,MATCH(LaadinfraPrivaat[[#This Row],[Power]],Laadpleinkosten!$C$21:$H$21,0))","v":18564.713210045},10,{"$f":"INDEX(Laadpleinkosten!$C$24:$H$31,MATCH(L$50,Laadpleinkosten!$A$24:$A$31,0),MATCH(LaadinfraPrivaat[[#This Row],[Charging type]],Laadpleinkosten!$C$20:$H$20,0))","v":2894.4},{"$f":"INDEX(Laadpleinkosten!$C$24:$H$31,MATCH(M$50,Laadpleinkosten!$A$24:$A$31,0),MATCH(LaadinfraPrivaat[[#This Row],[Charging type]],Laadpleinkosten!$C$20:$H$20,0))","v":5307.12},{"$f":"INDEX(Laadpleinkosten!$C$24:$H$31,MATCH(N$50,Laadpleinkosten!$A$24:$A$31,0),MATCH(LaadinfraPrivaat[[#This Row],[Charging type]],Laadpleinkosten!$C$20:$H$20,0))","v":3307.5},{"$f":"INDEX(Laadpleinkosten!$C$24:$H$34,MATCH(O$50,Laadpleinkosten!$A$24:$A$34,0),MATCH(LaadinfraPrivaat[[#This Row],[Charging type]],Laadpleinkosten!$C$20:$H$20,0))","v":5932.4999999999991},null,"Tot 2MW",{"$f":"350*40%","v":140}]
[null,4,"HPC150","150 kW","Privaat",150,{"$f":"INDEX(Laadpleinkosten!$C$29:$H$29,1,MATCH(LaadinfraPrivaat[[#This Row],[Power]],Laadpleinkosten!$C$21:$H$21,0))","v":93217.77},{"$f":"INDEX(Laadpleinkosten!$C$24:$H$24,1,MATCH(LaadinfraPrivaat[[#This Row],[Power]],Laadpleinkosten!$C$21:$H$21,0))","v":57881.25},{"$f":"LaadinfraPrivaat[[#This Row],[Purchase & installation (€) ]]-LaadinfraPrivaat[[#This Row],[Purchase (€)]]","v":35336.520000000004},{"$f":"INDEX(Laadpleinkosten!$C$39:$H$39,1,MATCH(LaadinfraPrivaat[[#This Row],[Power]],Laadpleinkosten!$C$21:$H$21,0))","v":8506.8528043049992},10,{"$f":"INDEX(Laadpleinkosten!$C$24:$H$31,MATCH(L$50,Laadpleinkosten!$A$24:$A$31,0),MATCH(LaadinfraPrivaat[[#This Row],[Charging type]],Laadpleinkosten!$C$20:$H$20,0))","v":2170.8000000000002},{"$f":"INDEX(Laadpleinkosten!$C$24:$H$31,MATCH(M$50,Laadpleinkosten!$A$24:$A$31,0),MATCH(LaadinfraPrivaat[[#This Row],[Charging type]],Laadpleinkosten!$C$20:$H$20,0))","v":5307.12},{"$f":"INDEX(Laadpleinkosten!$C$24:$H$31,MATCH(N$50,Laadpleinkosten!$A$24:$A$31,0),MATCH(LaadinfraPrivaat[[#This Row],[Charging type]],Laadpleinkosten!$C$20:$H$20,0))","v":1323},{"$f":"INDEX(Laadpleinkosten!$C$24:$H$34,MATCH(O$50,Laadpleinkosten!$A$24:$A$34,0),MATCH(LaadinfraPrivaat[[#This Row],[Charging type]],Laadpleinkosten!$C$20:$H$20,0))","v":2966.2499999999995},null,"Meer dan 2MW",{"$f":"200*40%","v":80}]
[null,3,"FC50","50 kW","Privaat",50,{"$f":"INDEX(Laadpleinkosten!$C$29:$H$29,1,MATCH(LaadinfraPrivaat[[#This Row],[Power]],Laadpleinkosten!$C$21:$H$21,0))","v":32104.035},{"$f":"INDEX(Laadpleinkosten!$C$24:$H$24,1,MATCH(LaadinfraPrivaat[[#This Row],[Power]],Laadpleinkosten!$C$21:$H$21,0))","v":19293.75},{"$f":"LaadinfraPrivaat[[#This Row],[Purchase & installation (€) ]]-LaadinfraPrivaat[[#This Row],[Purchase (€)]]","v":12810.285},{"$f":"INDEX(Laadpleinkosten!$C$39:$H$39,1,MATCH(LaadinfraPrivaat[[#This Row],[Power]],Laadpleinkosten!$C$21:$H$21,0))","v":4367.7976014350006},10,{"$f":"INDEX(Laadpleinkosten!$C$24:$H$31,MATCH(L$50,Laadpleinkosten!$A$24:$A$31,0),MATCH(LaadinfraPrivaat[[#This Row],[Charging type]],Laadpleinkosten!$C$20:$H$20,0))","v":1447.2},{"$f":"INDEX(Laadpleinkosten!$C$24:$H$31,MATCH(M$50,Laadpleinkosten!$A$24:$A$31,0),MATCH(LaadinfraPrivaat[[#This Row],[Charging type]],Laadpleinkosten!$C$20:$H$20,0))","v":2021.7599999999998},{"$f":"INDEX(Laadpleinkosten!$C$24:$H$31,MATCH(N$50,Laadpleinkosten!$A$24:$A$31,0),MATCH(LaadinfraPrivaat[[#This Row],[Charging type]],Laadpleinkosten!$C$20:$H$20,0))","v":496.125},{"$f":"INDEX(Laadpleinkosten!$C$24:$H$34,MATCH(O$50,Laadpleinkosten!$A$24:$A$34,0),MATCH(LaadinfraPrivaat[[#This Row],[Charging type]],Laadpleinkosten!$C$20:$H$20,0))","v":2373}]
[null,2,"AC22","22 kW","Privaat",22,{"$f":"INDEX(Laadpleinkosten!$C$29:$H$29,1,MATCH(LaadinfraPrivaat[[#This Row],[Power]],Laadpleinkosten!$C$21:$H$21,0))","v":3639.06},{"$f":"INDEX(Laadpleinkosten!$C$24:$H$24,1,MATCH(LaadinfraPrivaat[[#This Row],[Power]],Laadpleinkosten!$C$21:$H$21,0))","v":2315.25},{"$f":"LaadinfraPrivaat[[#This Row],[Purchase & installation (€) ]]-LaadinfraPrivaat[[#This Row],[Purchase (€)]]","v":1323.81},{"$f":"INDEX(Laadpleinkosten!$C$39:$H$39,1,MATCH(LaadinfraPrivaat[[#This Row],[Power]],Laadpleinkosten!$C$21:$H$21,0))","v":1571.8833121721998},10,{"$f":"INDEX(Laadpleinkosten!$C$24:$H$31,MATCH(L$50,Laadpleinkosten!$A$24:$A$31,0),MATCH(LaadinfraPrivaat[[#This Row],[Charging type]],Laadpleinkosten!$C$20:$H$20,0))","v":723.6},{"$f":"INDEX(Laadpleinkosten!$C$24:$H$31,MATCH(M$50,Laadpleinkosten!$A$24:$A$31,0),MATCH(LaadinfraPrivaat[[#This Row],[Charging type]],Laadpleinkosten!$C$20:$H$20,0))","v":467.53199999999998},{"$f":"INDEX(Laadpleinkosten!$C$24:$H$31,MATCH(N$50,Laadpleinkosten!$A$24:$A$31,0),MATCH(LaadinfraPrivaat[[#This Row],[Charging type]],Laadpleinkosten!$C$20:$H$20,0))","v":0},{"$f":"INDEX(Laadpleinkosten!$C$24:$H$34,MATCH(O$50,Laadpleinkosten!$A$24:$A$34,0),MATCH(LaadinfraPrivaat[[#This Row],[Charging type]],Laadpleinkosten!$C$20:$H$20,0))","v":1067.8499999999999}]
[null,1,"AC11","11 kW","Privaat",11,{"$f":"INDEX(Laadpleinkosten!$C$29:$H$29,1,MATCH(LaadinfraPrivaat[[#This Row],[Power]],Laadpleinkosten!$C$21:$H$21,0))","v":3289.3560000000002},{"$f":"INDEX(Laadpleinkosten!$C$24:$H$24,1,MATCH(LaadinfraPrivaat[[#This Row],[Power]],Laadpleinkosten!$C$21:$H$21,0))","v":1984.5},{"$f":"LaadinfraPrivaat[[#This Row],[Purchase & installation (€) ]]-LaadinfraPrivaat[[#This Row],[Purchase (€)]]","v":1304.8560000000002},{"$f":"INDEX(Laadpleinkosten!$C$39:$H$39,1,MATCH(LaadinfraPrivaat[[#This Row],[Power]],Laadpleinkosten!$C$21:$H$21,0))","v":494.03169614760003},10,{"$f":"INDEX(Laadpleinkosten!$C$24:$H$31,MATCH(L$50,Laadpleinkosten!$A$24:$A$31,0),MATCH(LaadinfraPrivaat[[#This Row],[Charging type]],Laadpleinkosten!$C$20:$H$20,0))","v":723.6},{"$f":"INDEX(Laadpleinkosten!$C$24:$H$31,MATCH(M$50,Laadpleinkosten!$A$24:$A$31,0),MATCH(LaadinfraPrivaat[[#This Row],[Charging type]],Laadpleinkosten!$C$20:$H$20,0))","v":467.53199999999998},{"$f":"INDEX(Laadpleinkosten!$C$24:$H$31,MATCH(N$50,Laadpleinkosten!$A$24:$A$31,0),MATCH(LaadinfraPrivaat[[#This Row],[Charging type]],Laadpleinkosten!$C$20:$H$20,0))","v":0},{"$f":"INDEX(Laadpleinkosten!$C$24:$H$34,MATCH(O$50,Laadpleinkosten!$A$24:$A$34,0),MATCH(LaadinfraPrivaat[[#This Row],[Charging type]],Laadpleinkosten!$C$20:$H$20,0))","v":265.77600000000001}]
[]
[]
[null,"Eigenschappen publieke laadinfra"]
[null,"Basisjaar financiële cijfers:",2023,null,null,null,"Momenteel niet in gebruik","Momenteel niet in gebruik"]
[null,"Index","Charging type","Power","Land type","Power (kW)","Depth of discharge (%)","Efficiency (%)","External energy costs (€)"]
[null,5,"HPC350","350 kW","Publiek",350,0.7,0.88700000000000001,0.5]
[null,4,"HPC150","150 kW","Publiek",150,0.7,0.88700000000000001,0.45]
[null,3,"FC50","50 kW","Publiek",50,0.7,0.88700000000000001,0.35]
[null,2,"AC20","20 kW","Publiek",20,0.8,0.90200000000000002,0.3]
[null,1,"AC10","10 kW","Publiek",10,0.8,0.90200000000000002,0.3]
[]
[]
[null,"Uitstoot factoren"]
[null,"Fuel category ID","Fuel type / Vehicle type","Type ID","Unit","CO2-eq (kg per unit)","PM10 combustion (g per unit)","NOx (g per unit)"]
[null,"DV","Kleine bakwagen",1,"L",3.2391638990074729,4.0539399771117916E-2,38.259095801370762,"DV NOx","based on Euro III standards -> to calculate AdBlue"]
[null,"DV","Medium bakwagen",2,"L",3.2391638990074729,4.0778979734846912E-2,27.551466178794151,"PM","based on Euro VI standards"]
[null,"DV","Grote bakwagen",3,"L",3.2391638990074729,3.8627357134386989E-2,29.414221728971619]
[null,"DV","Lichte trekker z/opl",4,"L",3.2391638990074729,4.4191285143567863E-2,28.533630893083735]
[null,"DV","Zware trekker z/opl",5,"L",3.2391638990074729,2.8777608592971057E-2,28.533630893083735]
[null,"EV","Grijs",{"$f":"Config!$A$15","v":"Grijs"},"kWh",0.36899999999999999,0,0]
[null,"EV","Groen",{"$f":"Config!$A$16","v":"Groen"},"kWh",0,0,0]
[null,"FC","Grijs",{"$f":"Config!$A$15","v":"Grijs"},"kg H2",11.02,0,0]
[null,"FC","Blauw",{"$f":"Config!$A$17","v":"Blauw"},"kg H2",4.24,0,0]
[null,"FC","Electrolyse (netstroom)",{"$f":"Config!$A$18","v":"Electrolyse (netstroom)"},"kg H2",20.88,0,0]
[null,"FC","Electrolyse (hernieuwbare energie)",{"$f":"Config!$A$19","v":"Electrolyse (hernieuwbare energie)"},"kg H2",0,0,0]

{"sheet":"Parameters","index":7,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Energieprijzen",null,null,null,null,null,"HERNIEUWBARE ENERGIE-EENHEDEN (HEB's)"]
[null,"Item","Variabele","Waarde","toelichting",null,null,"Variabele","Waarde","toelichting"]
[null,"Dieselprijs","Literprijs",1.03,"Kale prijs diesel per liter",null,null,"Multiplier EV",4]
[null,"Dieselprijs","Accijns",0.51619999999999999,"Accijns diesel per liter",null,null,"Multiplier FC",2.5]
[null,"Elektriciteitsprijs","kWh",0.122072892561983,"inkoopprijs stroom per kWh",null,null,"Aandeel groene energie 'grijze' stroom",0.26400000000000001]
[null,"Waterstofprijs",{"$f":"Config!$A$15","v":"Grijs"},7.56,"Inkoopprijs grijze waterstof per liter",null,null,"Waarde HBE",12]
[null,"Waterstofprijs",{"$f":"Config!$A$17","v":"Blauw"},8.06,"Inkoopprijs blauwe waterstof per liter",null,null,"Energiewaarde (MJ) per kg H2",120.1]
[null,"Waterstofprijs",{"$f":"Config!$A$18","v":"Electrolyse (netstroom)"},10,"Inkoopprijs waterstof per liter",null,null,"Vaste kosten registratie (per jaar)",2000]
[null,"Waterstofprijs",{"$f":"Config!$A$19","v":"Electrolyse (hernieuwbare energie)"},19,"Inkoopprijs waterstof per liter"]
[]
[null,null,null,null,null,null,null,"Estimated value of vehicle according to age"]
[null,"INZETGEGEVENS VOERTUIG SYSTEM",null,null,null,null,null,"Age","Percentage of value of new vehicle price (%)"]
[null,"Variabele","Waarde","toelichting",null,null,null,0,1]
[null,"Productieve dagen per jaar",260,null,null,null,null,1,0.81]
[null,"Max. tijd per dag opladen extern",1,null,null,null,null,2,0.66]
[null,"Max. # keer opladen extern / dag",1,null,null,null,null,3,0.53]
[null,"Aandeel koelunit",0.5,null,null,null,null,4,0.43]
[null,"Gewenste restcapaciteit batterij",0.2,null,null,null,null,5,0.35]
[null,"Aandeel snelweg kilometers",0.75,"Gemiddeld aandeel op snelweg voor tolheffing",null,null,null,6,0.28999999999999998]
[null,"Efficiëntie van transmissie overdracht (EV)",1,null,null,null,null,7,0.23]
[null,"Efficiëntie van transmissie overdracht (DV)",1,null,null,null,null,8,0.19]
[null,"Efficiëntie van transmissie overdracht (FC)",1,null,null,null,null,9,0.15]
[null,"NOx standaard (Euro VI)",0.46,null,null,null,null,10,0.12]
[null,"Efficiëntie van transmissie overdracht (H2ICE)",1,null,null,null,null,">10",0.1]
[]
[]
[null,"Financiële parameters"]
[null,"Item","Variabele","Waarde","toelichting",null,null,"Jaarlijkse veranderingen"]
[null,"Financiering","Rente",4.2259814999999999E-2,"%",null,null,"Variabele","Waarde","toelichting"]
[null,"Financiering","Verzekering",3.3987389399999998E-2,"%",null,null,"Dieselprijs",0.01]
[null,"Chauffeurskosten","Verblijfkostenvergoeding",0.97,"€/uur",null,null,"Eigen energiekosten",0.01]
[null,"Chauffeurskosten","Overige chauffeurskosten",0.54,"€/uur",null,null,"Energiekosten extern opladen",0.01]
[null,"Overhead","Loon incl. sociale lasten",8.4000000000000005E-2,"%",null,null,"Waterstof",0]
[null,"Overhead","Huisvesting",2.5999999999999999E-2,"%"]
[null,"Overhead","Overig overhead",0.05,"%"]
[]
[]
[null,null,null,null,null,null,null,"Parameters stationaire batterij"]
[null,null,null,null,null,null,null,"Item","Variabele","Waarde","toelichting"]
[null,null,null,null,null,null,null,"Gebruik",{"$f":"Config!$A$60","v":"Afschrijftermijn [jaar] "},15,"jaar"]
[null,"AdBlue",null,null,null,null,null,"Gebruik",{"$f":"Config!$A$61","v":"Prijs per kWh "},550,"euro/kWh"]
[null,"Variabele","Waarde","toelichting",null,null,null,"Gebruik",{"$f":"Config!$A$62","v":"Capaciteit batterij (kWh)"},1000,"kWh. Gebruiker mag tussen 400 en 1500 invullen"]
[null,"NOx standaard (Euro VI)",0.46,null,null,null,null,"Gebruik",{"$f":"Config!$A$63","v":"Max. ontlading batterij "},0.8,"Maximale ontlading batterij"]
[null,"Adblue gebruik",8.3244986557656601E-4,"benodigd aantal L per g NOx reductie",null,null,null,"Gebruik",{"$f":"Config!$A$64","v":"Sessies per week "},5,"aantal keer per week dat voertuig hiermee geladen wordt"]
[null,"Kosten Adblue",0.75620000000000009,"per L",null,null,null,"Gebruik",{"$f":"Config!$A$66","v":"Fractie eigen opwek "},0.5,"Welk deel van energie voor opladen batterij komt van eigen opwek"]
[null,null,null,null,null,null,null,"OPEX",{"$f":"Config!$A$65","v":"Eigen opwek "},0.06,"euro/kWh"]
[null,null,null,null,null,null,null,"CAPEX",{"$f":"Config!$A$67","v":"Afleveringsskosten "},1500,"euro"]
[null,null,null,null,null,null,null,"CAPEX",{"$f":"Config!$A$68","v":"Plaatsingskosten "},5000,"euro"]
[null,null,null,null,null,null,null,"CAPEX",{"$f":"Config!$A$69","v":"Extra opties "},0,"euro"]
[null,null,null,null,null,null,null,"OPEX",{"$f":"Config!$A$70","v":"Onderhoudscontract "},5400,"euro/jaar"]
[null,null,null,null,null,null,null,"OPEX",{"$f":"Config!$A$71","v":"Energiemanagement software "},7500,"euro/jaar"]
[null,null,null,null,null,null,null,"OPEX",{"$f":"Config!$A$72","v":"Monitoring "},15000,"euro/jaar"]
[null,null,null,null,null,null,null,"Marge","Marge",0.1,"Bij welke marge (kosten/kWh laadplein tov batterij) wordt melding getoond dat stationaire batterij interessant zou kunnen zijn."]

{"sheet":"Laadpleinkosten","index":8,"n_rows":119,"n_cols":16,"rows_kept":119,"cut":false,"hidden":false,"merged":[]}
["Basis"]
["TCO-ZET-Vracht"]
["Index","Charging type","Power","Land type","Column1","Power (kW)","Depth of discharge (%)","Efficiency (%)","Column2","Column3","Installation costs (€)","Operational costs annual (€)","Own energy costs (€)","External energy costs (€)"]
[1,"AC3,7","3,7 kW","Privaat",null,3.7,0.8,0.85799999999999998,null,null,270,25,0.20500000000000002,{"$f":"Charging_system_table1114[[#This Row],[Own energy costs (€)]]","v":0.20500000000000002}]
[2,"AC10","10 kW","Publiek",null,10,0.8,0.90200000000000002,null,null,1620,600,null,0.30759999999999998]
[3,"AC20","20 kW","Publiek",null,20,0.8,0.90200000000000002,null,null,1620,1295,null,0.4466]
[4,"AC20","20 kW","Privaat",null,20,0.8,0.90200000000000002,null,null,620,165,0.13,{"$f":"Charging_system_table1114[[#This Row],[Own energy costs (€)]]","v":0.13}]
[5,"FC50","50 kW","Publiek",null,50,0.7,0.88700000000000001,null,null,6500,3687.5,null,0.2631444444444444]
[6,"FC50","50 kW","Privaat",null,50,0.7,0.88700000000000001,null,null,4000,2812.5,0.12,{"$f":"Charging_system_table1114[[#This Row],[Own energy costs (€)]]","v":0.12}]
[7,"HPC150","150 kW","Publiek",null,150,0.7,0.88700000000000001,null,null,11625,7962.5,null,0.25870000000000004]
[8,"HPC150","150 kW","Privaat",null,150,0.7,0.88700000000000001,null,null,11000,3300,0.08,{"$f":"Charging_system_table1114[[#This Row],[Own energy costs (€)]]","v":0.08}]
[9,"HPC350","350 kW","Publiek",null,350,0.7,0.88700000000000001,null,null,31250,19450,null,0.29939444444444446]
[10,"HPC350","350 kW","Privaat",null,350,0.7,0.88700000000000001,null,null,28000,8400,0.08,{"$f":"Charging_system_table1114[[#This Row],[Own energy costs (€)]]","v":0.08}]
[]
[null,null,null,"Inputgegevens",null,null,null," "]
[null,null,null,"Berekende gegevens",null,null,399.6]
["Overzicht aannames TCO/kWh prijs op diverse laadpalen"]
["Alle bedragen excl. BTW"]
[" ","2022-05-31"," "]
[null,null,"AC3,7","AC11","AC22","FC50","HPC150","HPC350",null,null,null," "]
[null,null,"3,7 kW","11 kW","22 kW","50 kW","150 kW","350 kW",null,null,null,null," "]
[null,null,"privaat","privaat","privaat","privaat","privaat","privaat","index 2022","index 2023",null," "]
["CAPEX, Plaatsing",null,"1x16A","3x16A","3x32A",null,null,null,null,null,null," "]
["Inkoopprijs paal ","eenmalig",{"$f":"C91*$I24*$J24","v":771.75},{"$f":"D91*$I24*$J24","v":1984.5},2315.25,19293.75,57881.25,135056.25,1.05,1.05,null,null,null,null,null,"Purchase price pile "]
["Locatiebepaling, enginering, proj mgt ","eenmalig",{"$f":"C92*$I25*$J25","v":341.17200000000003},467.53199999999998,467.53199999999998,2021.7599999999998,5307.12,5307.12,1.08,1.17,"(1)",null,null,null,null,"Site identification, enginering, proj mgt "]
["Civiele werken/plaatsing","eenmalig",{"$f":"C93*$I26*$J26","v":44.225999999999999},113.72399999999999,132.678,{"$f":"F93*$I26*$J26","v":8845.2000000000007},26535.599999999999,61916.399999999994,1.08,1.17,"(1)",null,null,null,null,"Civil works / placement"]
["Graaf werk","eenmalig",{"$f":"TRANSPOSE($G$74:$G$79)*$B$83","v":723.6},723.6,723.6,1447.2,2170.8000000000002,2894.4," ",null,null,null,null,null,null,"Excavation work"]
["Aansluitkosten netbeheerder (!)","eenmalig",{"$f":"C95*$I28*$J28","v":0},{"$f":"D95*$I28*$J28","v":0},0,496.125,1323,3307.5,1.05,1.05,null,null,null,null,null,"Connection costs network manager (!)"]
["Totaal","eenmalig",{"$f":"SUM(C24:C28)","v":1880.748},3289.3560000000002,3639.06,32104.035,93217.77,208481.66999999998,null,null,null,null,null,null,null,"Total"]
["Afschrijvingstermijn","jaar",{"$f":"$B$81","v":10},{"$f":"$B81","v":10},10,10,10,10,null,null,null,null,null,null,null,"Depreciation period"]
["Totaal","per jaar",{"$f":"C29/C30","v":188.07480000000001},328.93560000000002,363.90600000000001,3210.4034999999999,9321.777,20848.166999999998,null,null,null,null,null,null,null,"Total"]
[null,null,"AC3,7","AC11","AC22","FC50","HPC150","HPC350"]
["OPEX, Operationele kosten"]
["Periodieke kosten netaansluiting (!)  ","per jaar",{"$f":"C101*$I34*$J34","v":0},{"$f":"D101*$I34*$J34","v":265.77600000000001},1067.8499999999999,{"$f":"F101*$I34*$J34","v":2373},2966.2499999999995,5932.4999999999991,1.05,1.1299999999999999,"(1)",null,null,null,null,"Periodic grid connection costs (!)  "]
["Communicatiekosten","per jaar",{"$f":"C102*$I35*$J35","v":11.025},52.920000000000009,77.174999999999997,77.174999999999997,77.174999999999997,{"$f":"H102*$I35*$J35","v":77.174999999999997},1.05,1.05,null,null,null,null,null,"Communication costs"]
["Verzekeringspremie (schade)","per jaar",31.226104057400001,80.295696147600012,93.678312172200009,780.65260143499995,2341.9578043050001,5464.5682100449994,1.07,1.042259815,null,null,null,null,null,"Insurance premium (damage)"]
["Onderhoud/reparatie","per jaar",{"$f":"C104*$I37*$J37","v":22.68},22.68,260.82,992.25000000000011,2976.75,6945.7500000000009,1.05,1.08,"(2)",null,null,null,null,"Maintenance/repair"]
["Service bij gebruikersproblemen","per jaar",{"$f":"C105*$I38*$J38","v":72.36},72.36,72.36,144.72,144.72,144.72,1.08,{"$f":"D83","v":1.34},null,null,null,null,null,"Service in case of user problems"]
["Totaal","per jaar",{"$f":"SUM(C34:C38)","v":137.29110405739999},{"$f":"SUM(D34:D38)","v":494.03169614760003},1571.8833121721998,4367.7976014350006,8506.8528043049992,18564.713210045,null,null,null,null,null,null,null,"Total"]
[null,null,"AC3,7","AC11","AC22","FC50","HPC150","HPC350"]
["OPEX, Energiekosten"]
["Vergoeding leverancier (inkoop)","€/kWh",{"$f":"$D$66","v":8.2652892561983479E-2},{"$f":"$D66","v":8.2652892561983479E-2},{"$f":"$D66","v":8.2652892561983479E-2},{"$f":"$D66","v":8.2652892561983479E-2},{"$f":"$D66","v":8.2652892561983479E-2},{"$f":"$D66","v":8.2652892561983479E-2},2022,2023]
["Energiebelasting","€/kWh",{"$f":"$C66","v":3.9419999999999997E-2},{"$f":"$C66","v":3.9419999999999997E-2},3.9419999999999997E-2,3.9419999999999997E-2,3.9419999999999997E-2,3.9419999999999997E-2,2022,2023]
["Totaal","€/kWh",{"$f":"SUM(C42:C43)","v":0.12207289256198348},0.12207289256198348,0.12207289256198348,0.12207289256198348,0.12207289256198348,0.12207289256198348,null,null,null,null,"(1)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Zie file \"aansluitkosten aanleg en periodiek\""]
["Totale kosten ","\"vast\" per jaar",{"$f":"C31+C39","v":325.36590405740003},822.96729614760011,1935.7893121721997,7578.201101435001,17828.629804304997,39412.880210044998]
["Energiekosten medium","\"variabel\"per kWh",{"$f":"C44","v":0.12207289256198348},{"$f":"D44","v":0.12207289256198348},{"$f":"E44","v":0.12207289256198348},{"$f":"F44","v":0.12207289256198348},{"$f":"G44","v":0.12207289256198348},{"$f":"H44","v":0.12207289256198348},null,null,null,null,"(2)"]
[null,null,null,null,null,null," "]
["Calculatie voor één voertuig"]
[null,null,"AC3,7","AC11","AC22","AC22","FC50","FC50"]
["Laadhoeveelheid per jaar (kWh/jaar)"]
["laag scenario (suboptimaal gebruik laadinfra)","kWh/jaar",3000,{"$f":"(C52+F52)/2","v":7500},4000,12000,30000,35000]
["medium","kWh/jaar",7500,{"$f":"(C53+F53)/2","v":18750},5000,30000,45000,87500]
["hoog (optimala gebruik laadinfra)","kWh/jaar",12000,{"$f":"(C54+F54)/2","v":30000},6000,48000,60000,140000]
[]
[]
[]
["Laadkosten (euro/kWh) ",null,"AC3,7","AC11","AC22","AC22","FC50","FC50"]
[]
["laag scenario (suboptimaal gebruik laadinfra)",null,{"$f":"C$46/C52+C$47","v":0.23052819391445015},{"$f":"D$46/D52+D$47","v":0.23180186538166347},0.53044999999999998,{"$f":"#REF!/F52+#REF!","v":{"$error":"#REF!"}},0.33911666666666662,{"$f":"#REF!/H52+#REF!","v":{"$error":"#REF!"}}]
["medium",null,{"$f":"C$46/C53+C$47","v":0.16545501310297014},{"$f":"D$46/D53+D$47","v":0.16596448168985548},0.4466,{"$f":"#REF!/F53+#REF!","v":{"$error":"#REF!"}},0.2631444444444444,{"$f":"#REF!/H53+#REF!","v":{"$error":"#REF!"}}]
["hoog (optimala gebruik laadinfra)",null,0.14918671790010013,{"$f":"D$46/D54+D$47","v":0.14950513576690347},0.39070000000000005,{"$f":"#REF!/F54+#REF!","v":{"$error":"#REF!"}},0.22515833333333332,{"$f":"#REF!/H54+#REF!","v":{"$error":"#REF!"}}]
[]
[null,"staffel","e-belast+ODE","Kale prijs","Totaal",null,null,null,null,null,null," ","Algemene loonkostenontwikkeling"]
["zone 2","10-50 MWh",0.10045999999999999,8.2652892561983479E-2,{"$f":"SUM(C65:D65)","v":0.18311289256198349},2023,45041]
["zone 3","50-10.000 MWh",3.9419999999999997E-2,8.2652892561983479E-2,{"$f":"SUM(C66:D66)","v":0.12207289256198348},2023,45041]
[null,null," ",null,null," "," "]
["https://www.belastingdienst.nl/wps/wcm/connect/bldcontentnl/belastingdienst/zakelijk/overige_belastingen/belastingen_op_milieugrondslag/tarieven_milieubelastingen/tabellen_tarieven_milieubelastingen"]
[]
["https://zakelijkeenergietarieven.nl/grootverbruik-energie/"]
[]
[null,null,null,null,"norm ",null,"bij aanleg"]
[null,"kW","dagen","uur/dag","maxcap",null,"meters grondwerk"]
["capaciteit",3.7,250,12,{"$f":"B74*C74*D74","v":11100},"kWh",5,"meter"]
[null,11,250,10,{"$f":"B75*C75*D75","v":27500},"kWh",5,"meter"]
[null,22,200,10,{"$f":"B76*C76*D76","v":44000},"kWh",5,"meter"]
[null,50,250,10,{"$f":"B77*C77*D77","v":125000},"kWh",10,"meter"]
[null,150,200,8,240000,"kWh",15,"meter"]
[null,350,200,8,{"$f":"B79*C79*D79","v":560000},"kWh",20,"meter"]
[]
["afschrijvingstermijn (jaar)",10,"index"]
[null,null,2022,2023]
["Kost per meter grondwerk",{"$f":"B84*C83*D83","v":144.72},1.08,1.34,"(1)"]
["2021 (basis)",100," "]
[]
[]
[null,null,"AC3,7","AC11","AC22","FC50","HPC150","HPC350"]
[null,null,"3,7 kW","11 kW","22 kW","50 kW","150 kW","350 kW"]
[null,null,"privaat","privaat","privaat","privaat","privaat","privaat","index 2022"]
["CAPEX, Plaatsing",null,"1x16A","3x16A","3x32A"]
["Inkoopprijs paal ","eenmalig",700,1800,2100,17500,52500,122500,105]
["Locatiebepaling, enginering, proj mgt ","eenmalig",270,370,370,1600,4200,4200,108]
["Civiele werken/plaatsing","eenmalig",35,90,105,7000,21000,49000,108]
["Graaf werk","eenmalig",{"$f":"TRANSPOSE($G$74:$G$79)*$B$83","v":723.6},723.6,723.6,1447.2,2170.8000000000002,2894.4,108]
["Aansluitkosten netbeheerder (!)","eenmalig",0,0,0,450,1200,3000,105]
["Totaal","eenmalig",{"$f":"SUM(C91:C95)","v":1728.6},{"$f":"SUM(D91:D95)","v":2983.6},3298.6,27997.200000000001,81070.8,181594.4]
["Afschrijvingstermijn","jaar",{"$f":"$B$81","v":10},10,10,10,10,10,100]
["Totaal","per jaar",{"$f":"C96/C97","v":172.85999999999999},{"$f":"D96/D97","v":298.36},329.86,2799.7200000000003,8107.08,18159.439999999999]
[null,null,"AC3,7","AC11","AC22","FC50","HPC150","HPC350"]
["OPEX, Operationele kosten"]
["Periodieke kosten netaansluiting (!)  ","per jaar",0,224,900,2000,2500,5000,105]
["Communicatiekosten","per jaar",10,48,70,70,70,70,105]
["Verzekeringspremie (schade)","per jaar",{"$f":"C91*0.04","v":28},{"$f":"D91*0.04","v":72},84,700,2100,4900,107]
["Onderhoud/reparatie","per jaar",20,20,230,{"$f":"F91*0.05","v":875},{"$f":"G91*0.05","v":2625},6125,105]
["Service bij gebruikersproblemen","per jaar",50,50,50,100,100,100,108]
["Totaal","per jaar",{"$f":"SUM(C101:C105)","v":108},{"$f":"SUM(D101:D105)","v":414},1334,3745,7395,16195]
[null,null,"AC3,7","AC11","AC22","FC50","HPC150","HPC350"]
["OPEX, Energiekosten"]
["Vergoeding leverancier (inkoop)","€/kWh",{"$f":"$E$119","v":8.8700000000000001E-2},{"$f":"$E$119","v":8.8700000000000001E-2},8.8700000000000001E-2,8.8700000000000001E-2,8.8700000000000001E-2,8.8700000000000001E-2,2022]
["Energiebelasting","€/kWh",{"$f":"$D$119+$C$119","v":3.4790000000000001E-2},{"$f":"$D$119+$C$119","v":3.4790000000000001E-2},3.4790000000000001E-2,3.4790000000000001E-2,3.4790000000000001E-2,3.4790000000000001E-2,2022]
["Totaal","€/kWh",{"$f":"SUM(C109:C110)","v":0.12349},0.12349,0.12349,0.12349,0.12349,0.12349]
[]
["Totale kosten ","\"vast\" per jaar",{"$f":"C98+C106","v":280.86},712.36,1663.8600000000001,6544.72,15502.08,34354.44]
["Energiekosten medium","\"variabel\"per kWh",{"$f":"C111","v":0.12349},{"$f":"D111","v":0.12349},{"$f":"E111","v":0.12349},{"$f":"F111","v":0.12349},{"$f":"G111","v":0.12349},{"$f":"H111","v":0.12349}]
[]
[]
[null,"staffel","e-belast","ODE","Kale prijs","Totaal"]
["zone 2","10-50 MWh",4.3610000000000003E-2,4.1799999999999997E-2,8.8700000000000001E-2,0.17410999999999999,2021]
["zone 3","50-10.000 MWh",1.189E-2,2.29E-2,8.8700000000000001E-2,0.12349,2021]

{"sheet":"Config","index":9,"n_rows":72,"n_cols":17,"rows_kept":72,"cut":false,"hidden":false,"merged":[[8,0,8,2]]}
["Versie","6.2"]
[]
[]
[]
[]
[]
[]
[]
["Invoervelden",null,null,null,null,null,null,null,"Formatteren subsidie-waarden"]
["Lan","Dutch","English",null,null,null,null,null,null,"EV","FC","h2ICE"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B11,\nIF('Read Me'!$C$3=\"English\",C11,C11))","v":"Ja"},"Ja","Yes",null,null,null,null,null,"AanZET-subsidie",{"$f":"TEXT('M2-Subsidie'!B35,\"€#.##0,00\")","v":"€0,00"},{"$f":"TEXT('M2-Subsidie'!C35,\"€#.##0,00\")","v":"€0,00"},{"$f":"TEXT('M2-Subsidie'!D35,\"€#.##0,00\")","v":"€0,00"}]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B12,\nIF('Read Me'!$C$3=\"English\",C12,C12))","v":"Nee"},"Nee","No",null,null,null,null,null,"MIA-subsidie",{"$f":"TEXT('M2-Subsidie'!B36,\"€#.##0,00\")","v":"€19.648,93"},{"$f":"TEXT('M2-Subsidie'!C36,\"€#.##0,00\")","v":"€30.750,20"},{"$f":"TEXT('M2-Subsidie'!D36,\"€#.##0,00\")","v":"€0,00"}]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B13,\nIF('Read Me'!$C$3=\"English\",C13,C13))","v":"Koeling"},"Koeling","Cooling",null,null,null,null,null,"MIA-subsidie laadpaal",{"$f":"TEXT('M2-Subsidie'!B37,\"€#.##0,00\")","v":"€2.195,92"}]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B14,\nIF('Read Me'!$C$3=\"English\",C14,C14))","v":"Kan het voertuig koelen? Een koeling is enkel relevant voor bakwagens. Voor trekkers worden daarom geen (energie)kosten voor koeling meegenomen."},"Kan het voertuig koelen? Een koeling is enkel relevant voor bakwagens. Voor trekkers worden daarom geen (energie)kosten voor koeling meegenomen.","Is the vehicle able to cool? A cooling unit is only relevant for trucks. For tractors no (energy)costs for cooling are taken into account."]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B15,\nIF('Read Me'!$C$3=\"English\",C15,C15))","v":"Grijs"},"Grijs","Gray"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B16,\nIF('Read Me'!$C$3=\"English\",C16,C16))","v":"Groen"},"Groen","Green"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B17,\nIF('Read Me'!$C$3=\"English\",C17,C17))","v":"Blauw"},"Blauw","Blue"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B18,\nIF('Read Me'!$C$3=\"English\",C18,C18))","v":"Electrolyse (netstroom)"},"Electrolyse (netstroom)","Electrolysis (grid-average)"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B19,\nIF('Read Me'!$C$3=\"English\",C19,C19))","v":"Electrolyse (hernieuwbare energie)"},"Electrolyse (hernieuwbare energie)","Electrolysis (renewable energy)"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B20,\nIF('Read Me'!$C$3=\"English\",C20,C20))","v":"BV of NV met 19% belasting"},"BV of NV met 19% belasting","BV or NV with 19% tax"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B21,\nIF('Read Me'!$C$3=\"English\",C21,C21))","v":"BV of NV met 25,8% belasting"},"BV of NV met 25,8% belasting","BV or NV with 25.8% tax"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B22,\nIF('Read Me'!$C$3=\"English\",C22,C22))","v":"Eenmanszaak met 36,93% belasting"},"Eenmanszaak met 36,93% belasting","Sole proprietorship with 36,93% tax"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B23,\nIF('Read Me'!$C$3=\"English\",C23,C23))","v":"Eenmanszaak met 49,5% belasting"},"Eenmanszaak met 49,5% belasting","Sole proprietorship with 49.5% tax"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B24,\nIF('Read Me'!$C$3=\"English\",C24,C24))","v":"Klein"},"Klein","Small"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B25,\nIF('Read Me'!$C$3=\"English\",C25,C25))","v":"Middelgroot"},"Middelgroot","Medium"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B26,\nIF('Read Me'!$C$3=\"English\",C26,C26))","v":"Groot"},"Groot","Large"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B27,\nIF('Read Me'!$C$3=\"English\",C27,C27))","v":"Omvang bedrijf"},"Omvang bedrijf","Company size"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B28,\nIF('Read Me'!$C$3=\"English\",C28,C28))","v":"Groot: >250 fte, >€50 mil omzet\nMiddelgroot: <250 fte, <€50 mil omzet\nKlein: <50 fte, <€10 mil omzet\n"},"Groot: >250 fte, >€50 mil omzet\nMiddelgroot: <250 fte, <€50 mil omzet\nKlein: <50 fte, <€10 mil omzet\n","Large: >250 fte, >€50 mil revenue\nMedium: <250 fte, <€50 mil revenue\nSmall: <50 fte, <€10 mil revenue\n"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B29,\nIF('Read Me'!$C$3=\"English\",C29,C29))","v":"Herstel invoervelden"},"Herstel invoervelden","Reset input"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B30,\nIF('Read Me'!$C$3=\"English\",C30,C30))","v":"Toegepaste waarde:"},"Toegepaste waarde:","Applied value:"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B31,\nIF('Read Me'!$C$3=\"English\",C31,C31))","v":"Enkele laadpaal"},"Enkele laadpaal","Single installation"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B32,\nIF('Read Me'!$C$3=\"English\",C32,C32))","v":"Laadpleinmodel"},"Laadpleinmodel","Charging hub module"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B33,\nIF('Read Me'!$C$3=\"English\",C33,C33))","v":"Let op:\nNa 2025 kunnen er maatregelen van kracht worden die de economische levensduur van dieselvoertuigen verkorten."},"Let op:\nNa 2025 kunnen er maatregelen van kracht worden die de economische levensduur van dieselvoertuigen verkorten.","Please Note:\nAfter 2025, measures may take effect that shorten the economic life of diesel vehicles."]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B34,\nIF('Read Me'!$C$3=\"English\",C34,C34))","v":"Let op:   \nHet verdienen van HBE’s is aan strenge regels onderworpen.  \nEr wordt 2.000 euro per jaar in rekening gebracht voor kosten die gemaakt moeten worden om HBE's te innen.\n"},"Let op:   \nHet verdienen van HBE’s is aan strenge regels onderworpen.  \nEr wordt 2.000 euro per jaar in rekening gebracht voor kosten die gemaakt moeten worden om HBE's te innen.\n","Please Note:  \nEarning HBEs is subject to strict rules.  \nThere is a charge of 2,000 euros per year for costs incurred to collect HBEs.\n"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B35,\nIF('Read Me'!$C$3=\"English\",C35,C35))","v":"Let op:   \nHet budget van de AanZET-subsidie voor het jaar 2023 is reeds uitgeput.  \n"},"Let op:   \nHet budget van de AanZET-subsidie voor het jaar 2023 is reeds uitgeput.  \n","Please Note:   \nThe AanZET grant budget for the year 2023 has already been exhausted.  "]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B36,\nIF('Read Me'!$C$3=\"English\",C36,C36))","v":"De in het TCO-Vracht gebruikte default- c.q. standaardwaarden zijn met de grootste zorg verzameld. Het betreft echter gemiddelde cijfers, de werkelijke cijfers kunnen ofwel hoger dan wel lager zijn. Hoewel veel zorg is besteed aan de correctheid van de rekenregels en de gebruikte inputdata, is Panteia of de Topsector Logistiek niet aansprakelijk te houden voor de juistheid van de rekenresultaten. "},"De in het TCO-Vracht gebruikte default- c.q. standaardwaarden zijn met de grootste zorg verzameld. Het betreft echter gemiddelde cijfers, de werkelijke cijfers kunnen ofwel hoger dan wel lager zijn. Hoewel veel zorg is besteed aan de correctheid van de rekenregels en de gebruikte inputdata, is Panteia of de Topsector Logistiek niet aansprakelijk te houden voor de juistheid van de rekenresultaten. ","The default values used in TCO Freight have been compiled with the greatest care. However, these are average figures; the actual figures may be either higher or lower. Although great care was taken to ensure the correctness of the calculation rules and the input data used, Panteia or Top Sector Logistics cannot be held liable for the correctness of the calculation results. "]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B37,\nIF('Read Me'!$C$3=\"English\",C37,C37))","v":"Kleine bakwagen (lvm ca. 6 ton)"},"Kleine bakwagen (lvm ca. 6 ton)","Small truck (load approx. 6 tonnes)"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B38,\nIF('Read Me'!$C$3=\"English\",C38,C38))","v":"Kleine bakwagen/ Verhuiswagen"},"Kleine bakwagen/ Verhuiswagen","Small truck / moving van"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B39,\nIF('Read Me'!$C$3=\"English\",C39,C39))","v":"Medium bakwagen (lvm ca. 9 ton)"},"Medium bakwagen (lvm ca. 9 ton)","Medium size truck (load approx. 9 tonnes)"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B40,\nIF('Read Me'!$C$3=\"English\",C40,C40))","v":"Medium bakwagen/ Verhuiswagen"},"Medium bakwagen/ Verhuiswagen","Medium size truck / moving van"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B41,\nIF('Read Me'!$C$3=\"English\",C41,C41))","v":"Grote bakwagen (lvm > 16 ton)"},"Grote bakwagen (lvm > 16 ton)","Large truck (load >16 tonnes)"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B42,\nIF('Read Me'!$C$3=\"English\",C42,C42))","v":"Grote bakwagen/ Verhuiswagen"},"Grote bakwagen/ Verhuiswagen","Large truck / moving van",null,null,null,null,null,null,null,null,null,null,null,null,"Kleine bakwagen (lvm ca. 6 ton)","Small Truck (carr. cap. approx. 6 tons)"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B43,\nIF('Read Me'!$C$3=\"English\",C43,C43))","v":"Grote bakwagen/ Bouwvervoer"},"Grote bakwagen/ Bouwvervoer","Large truck / Concstruction",null,null,null,null,null,null,null,null,null,null,null,null,"Medium bakwagen (lvm ca. 9 ton)","Medium size truck (c. cap. approx. 9 tons)"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B44,\nIF('Read Me'!$C$3=\"English\",C44,C44))","v":"Lichte trekker z/opl (GVW < 40 ton)"},"Lichte trekker z/opl (GVW < 40 ton)","Light tractor (GVW <40 tonnes)",null,null,null,null,null,null,null,null,null,null,null,null,"Grote bakwagen (lvm > 16 ton)","Large truck (carr. cap. >16 tons)"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B45,\nIF('Read Me'!$C$3=\"English\",C45,C45))","v":"Zware trekker z/opl (GVW > 40 ton)"},"Zware trekker z/opl (GVW > 40 ton)","Heavy duty tractor (GVW >40 tonnes)",null,null,null,null,null,null,null,null,null,null,null,null,"Lichte trekker z/opl (GVW <40 ton)","Light tractor (GVW <40 tons)"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B46,\nIF('Read Me'!$C$3=\"English\",C46,C46))","v":"Zware trekker z/opl/  Containertrucking"},"Zware trekker z/opl/  Containertrucking","Heavy duty tractor / container transport",null,null,null,null,null,null,null,null,null,null,null,null,"Zware trekker z/opl (GVW >40 ton)","Heavy duty tractor (GVW >40 tons)"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B47,\nIF('Read Me'!$C$3=\"English\",C47,C47))","v":"Kleine bakwagen"},"Kleine bakwagen","Small truck"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B48,\nIF('Read Me'!$C$3=\"English\",C48,C48))","v":"Medium bakwagen"},"Medium bakwagen","Medium size truck"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B49,\nIF('Read Me'!$C$3=\"English\",C49,C49))","v":"Grote bakwagen"},"Grote bakwagen","Large truck"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B50,\nIF('Read Me'!$C$3=\"English\",C50,C50))","v":"Lichte trekker z/opl"},"Lichte trekker z/opl","Light tractor"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B51,\nIF('Read Me'!$C$3=\"English\",C51,C51))","v":"Zware trekker z/opl"},"Zware trekker z/opl","Heavy duty tractor"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B52,\nIF('Read Me'!$C$3=\"English\",C52,C52))","v":"Neem netverzwaring mee"},"Neem netverzwaring mee","Include upgrade mains connection"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B53,\nIF('Read Me'!$C$3=\"English\",C53,C53))","v":"Neem netverzwaring niet mee"},"Neem netverzwaring niet mee","Don't include upgrade mains connection"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B54,\nIF('Read Me'!$C$3=\"English\",C54,C54))","v":"Stap 1\nVul het verwachte aantal elektrische vrachtvoertuigen per type op uw vestiging in de huidige situatie en in de komende tien jaar (per 2 jaar). Houd hierbij rekening met het aantal voertuigen dat tegelijk zal opladen (waardoor tegelijkertijd een laadbehoefte ontstaat).\nBelangrijk: Het invullen van het totale wagenpark moet voor ieder jaar afzonderlijk gebeuren. Vul in de eerste kolom het huidige aantal e-voertuigen in dat u al heeft."},"Stap 1\nVul het verwachte aantal elektrische vrachtvoertuigen per type op uw vestiging in de huidige situatie en in de komende tien jaar (per 2 jaar). Houd hierbij rekening met het aantal voertuigen dat tegelijk zal opladen (waardoor tegelijkertijd een laadbehoefte ontstaat).\nBelangrijk: Het invullen van het totale wagenpark moet voor ieder jaar afzonderlijk gebeuren. Vul in de eerste kolom het huidige aantal e-voertuigen in dat u al heeft.","Step 1\nFill in the expected amount of eletric vehicles per type on your location for the next ten years (per 2 years). Keep the number of vehicles that need to charge simultaneous in mind (hence with overlap in loading demand). Important: the cells need to be filled in for all years. Use the first column for your current amount of e-vehicles."]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B55,\nIF('Read Me'!$C$3=\"English\",C55,C55))","v":"Stap 2\nGeef het verwachte jaarkilometrage (per voertuigtype) van uw voertuigen op. Op basis hiervan is een gemiddelde per dag berekend. Als dit sterk afwijkt van uw maximale dagelijkse afstand, vul dan zelf deze waarde in (kolom [Maximum per dag]). Per voertuigtype is een inschatting gemaakt van het gemiddelde energieverbruik. Weet u het energieverbruik? Vul deze dan zelf in de kolom [Eigen input] in."},"Stap 2\nGeef het verwachte jaarkilometrage (per voertuigtype) van uw voertuigen op. Op basis hiervan is een gemiddelde per dag berekend. Als dit sterk afwijkt van uw maximale dagelijkse afstand, vul dan zelf deze waarde in (kolom [Maximum per dag]). Per voertuigtype is een inschatting gemaakt van het gemiddelde energieverbruik. Weet u het energieverbruik? Vul deze dan zelf in de kolom [Eigen input] in.","Step 2\nFill in the expected annual mileage (in kilometres) per vehicle type. Based on this mileage a daily average is calculated. If this daily average differs strongly from your daily maximum, please give this maximum in column [daily max]. Per vehicle type an estimation is made of the average energy use. If you know the exact energy use of your vehicle please fill in column [own input]."]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B56,\nIF('Read Me'!$C$3=\"English\",C56,C56))","v":"Stap 3\nVul per voertuigtype de hoeveel tijd (uren) in dat de vrachtwagens per dag kunnen opladen. Op basis van de benodigde energievraag wordt de kleinst mogelijke laadpaal berekend. U kunt deze vervangen met een eigen keuze. Let op: u kunt alleen een laadpaal met een hoger vermogen kiezen."},"Stap 3\nVul per voertuigtype de hoeveel tijd (uren) in dat de vrachtwagens per dag kunnen opladen. Op basis van de benodigde energievraag wordt de kleinst mogelijke laadpaal berekend. U kunt deze vervangen met een eigen keuze. Let op: u kunt alleen een laadpaal met een hoger vermogen kiezen.","Step 3\nState the number of hours that a vehicle is able to charge (on your own location) per day. Based on the needed energy and available charging time the least heavy charging infra is calculated and advised. You can override with your own choice, but you can only choose charging infra with an higher output."]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B57,\nIF('Read Me'!$C$3=\"English\",C57,C57))","v":"Niet mogelijk"},"Niet mogelijk","Not possible"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B58,\nIF('Read Me'!$C$3=\"English\",C58,C58))","v":"* Bovenstaand piekvermogen is van toepassing in het geval dat alle laadpalen gelijktijdig worden gebruikt. Let op dat wanneer deze piek groter is dan uw publieke aansluiting toestaat, de zekering van uw aansluiting op het publieke net springt! De piek kan verlaagd worden door de toepassing van een \"smart charging grid\". Daarnaast kan een aansluiting overwogen worden met een zonne- of windpark of een elektriciteitsopslag in batterijen."},"* Bovenstaand piekvermogen is van toepassing in het geval dat alle laadpalen gelijktijdig worden gebruikt. Let op dat wanneer deze piek groter is dan uw publieke aansluiting toestaat, de zekering van uw aansluiting op het publieke net springt! De piek kan verlaagd worden door de toepassing van een \"smart charging grid\". Daarnaast kan een aansluiting overwogen worden met een zonne- of windpark of een elektriciteitsopslag in batterijen.","* The mentioned peak power is applicable when all charging stations are used simultaneously. Be aware that if peak power superceeds capacity of the mains, the fuses will pop! Peak power can be lowered by applying a \"smart charging grid\". Furthermore one can think of using solar- or windpower or using batteries."]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B59,\nIF('Read Me'!$C$3=\"English\",C59,C59))","v":"Vanwege de mogelijke netverzwaring kan een stationaire batterij voor u interessant zijn."},"Vanwege de mogelijke netverzwaring kan een stationaire batterij voor u interessant zijn.","Because of the potentially needed upgrade of your mains a stationairy battery might be beneficial."]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B60,\nIF('Read Me'!$C$3=\"English\",C60,C60))","v":"Afschrijftermijn [jaar] "},"Afschrijftermijn [jaar] ","Depreciation [years] "]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B61,\nIF('Read Me'!$C$3=\"English\",C61,C61))","v":"Prijs per kWh "},"Prijs per kWh ","Price per kWh "]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B62,\nIF('Read Me'!$C$3=\"English\",C62,C62))","v":"Capaciteit batterij (kWh)"},"Capaciteit batterij (kWh)","Battery capacity (kWh)"]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B63,\nIF('Read Me'!$C$3=\"English\",C63,C63))","v":"Max. ontlading batterij "},"Max. ontlading batterij ","Max. discharge battery "]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B64,\nIF('Read Me'!$C$3=\"English\",C64,C64))","v":"Sessies per week "},"Sessies per week ","Sessions per week "]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B65,\nIF('Read Me'!$C$3=\"English\",C65,C65))","v":"Eigen opwek "},"Eigen opwek ","Own generation "]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B66,\nIF('Read Me'!$C$3=\"English\",C66,C66))","v":"Fractie eigen opwek "},"Fractie eigen opwek ","Fraction own generation "]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B67,\nIF('Read Me'!$C$3=\"English\",C67,C67))","v":"Afleveringsskosten "},"Afleveringsskosten ","Delivery costs "]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B68,\nIF('Read Me'!$C$3=\"English\",C68,C68))","v":"Plaatsingskosten "},"Plaatsingskosten ","Installation "]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B69,\nIF('Read Me'!$C$3=\"English\",C69,C69))","v":"Extra opties "},"Extra opties ","Misc. "]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B70,\nIF('Read Me'!$C$3=\"English\",C70,C70))","v":"Onderhoudscontract "},"Onderhoudscontract ","Maintenance "]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B71,\nIF('Read Me'!$C$3=\"English\",C71,C71))","v":"Energiemanagement software "},"Energiemanagement software ","Energy management software "]
[{"$f":"IF('Read Me'!$C$3=\"Nederlands\",B72,\nIF('Read Me'!$C$3=\"English\",C72,C72))","v":"Monitoring "},"Monitoring ","Monitoring "]