{
  "fields": [{"id":"_id","type":"int"},{"id":"this_sheet_provides_____a__estimation_of_ghg_emission_reduct","type":"text","info":{"label":"This sheet provides: "}},{"id":"unsafe_","type":"text","info":{"label":" (A) Estimation of GHG emission reduction from EV sales in Delhi in 2021 "}},{"id":"unsafe__2","type":"text","info":{"label":" (B) Estimation of GHG emission  from ICE vehicle sales in Delhi in 2021"}},{"id":"unsafe__3","type":"text","info":{"label":" "}},{"id":"unsafe__4","type":"text","info":{"label":" Note: For 2021 vehicles sales data for Delhi, approx. 5.6% of the total vehicle sales was EVs."}},{"id":"unsafe__5","type":"text","info":{"label":"Unnamed Column"}},{"id":"unsafe__6","type":"text","info":{"label":"Unnamed Column"}},{"id":"unsafe__7","type":"text","info":{"label":"Unnamed Column"}},{"id":"unsafe__8","type":"text","info":{"label":"Unnamed Column"}},{"id":"unsafe__9","type":"text","info":{"label":"Unnamed Column"}}],
  "records": [
    [1,"Main Calculation",null,null,null,null,null,null,null,null,null],
    [2,"Table 1-Emissions Calculation For ICE Vehicles for Delhi 2021",null,null,null,null,null,null,null,null,null],
    [3,"Vehicle Category","Fuel Type","No. of vehicles","Daily Utilization (km)","Total Fuel Consumed in L (annual)","Emission CO2 (Mt)","Emission CH4 (Mt)","Emission N2O (CO2 eq. Mt)","Total Emission CO2 (Mt)",null],
    [4,null,null,null,null,null,null,null,null,null,null],
    [5,"2 Wheeler","PETROL","267954","94.06725351320547","83388847.07172793","0.20482635617460446","0.0002550307917007324","0.0036852371764307273","0.20876662414273592",null],
    [6,"3 Wheeler","CNG","2045.3419160706721","207.82682628027348","2901075.0708744638","6.140846622839225e-6","1.2309633768464844e-8","1.323872097114988e-8","6.166394977578839e-6",null],
    [7,null,"DIESEL","310.6988773704802","207.82682628027348","457766.2492903939","0.0012390469943348512","1.5427464600808479e-6","0.000022292941846678654","0.0012628826826416107",null],
    [8,null,"PETROL","4232.959206558848","207.82682628027342","5373074.209787337","0.013197774648447095","0.000016432645584009236","0.0002374544501448417","0.013451661744175945",null],
    [9,"4 Wheeler","DIESEL","7258.301122629519","171.96036171704426","18489239.341042705","0.05004527194516651","0.00006231173352600364","0.0009004148690693733","0.05100799854776189",null],
    [10,null,"PETROL","98887.04079344115","171.96036171704432","196245539.7580058","0.48203399178280393","0.0006001840429472758","0.00867275881872834","0.49130693464447955",null],
    [11,null,"CNG","47781.658083929324","171.96036171704438","72811848.87049979","0.00015412437986456946","3.089500173914829e-7","3.322684615326154e-7","0.00015476559834349358",null],
    [12,null,null,null,null,"379667390.57122844","0.7515027067718443","0.0009358232198692618","0.013518503763402464","0.7659570337551159",null],
    [13,null,null,null,null,null,null,null,null,null,null],
    [14,"Table 2-Emission Reduction Calculation For EV for Delhi 2021",null,null,null,null,null,null,null,null,null],
    [15,"Vehicle Category","No. of vehicles","Proxy Fuel Type (ICE)","Proxy ICE Share No. of vehicles","Daily Utilization (km)","Total Fuel Consumed in L (annual) (ICE)","Emission Reduction CO2 (Mt)","Emission Reduction CH4 (CO2 eq. Mt)","Emission N2O Reduction (CO2 eq. Mt)","Total Emission Reduction CO2 (Mt)"],
    [16,null,null,null,null,null,null,null,null,null,null],
    [17,"2 Wheeler","7584","Petrol","7584","94.06725351320549","2360185.0175477304","0.0057972752234644745","7.218229712033983e-6","0.00010430461476988823","0.005908798067946397"],
    [18,"3 Wheeler","16242","CNG","5041.803521144309","207.82682628027345","7151200.683129919","0.000015137294103529317","3.03434620833823e-8","3.2633678253667676e-8","0.000015200271243866367"],
    [19,null,null,"DIESEL","765.8781554486781","207.8268262802734","1128401.794046832","0.003054272466533108","3.802896950164384e-6","0.000054952490738162785","0.0031130278542214353"],
    [20,null,null,"PETROL","10434.318323407011","207.82682628027348","13244721.705170123","0.03253274485355558","0.00004050675816899045","0.0005853293639782242","0.033158580975702796"],
    [21,"4 Wheeler","1952","DIESEL","92.0449550200603","171.96036171704432","234468.25569078437","0.0006346409066438314","7.901960269657638e-7","0.000011418463456205973","0.0006468495661270031"],
    [22,null,null,"PETROL","1254.0197861895385","171.96036171704432","2488655.6199213085","0.006112834992951419","7.611135485217552e-6","0.00010998216826260316","0.00623042829669924"],
    [23,null,null,"CNG","605.935258790401","171.96036171704438","923351.5172465887","1.954503040373942e-6","3.917898964757157e-9","4.2136079889276445e-9","1.9626345473276265e-6"],
    [24,null,null,null,null,null,"27530984.592753284","0.048148860240292315","0.000059963477704420266","0.0008660239484913269","0.049074847666488064"],
    [25,null,null,null,null,null,null,null,null,null,null],
    [26,"Result and Analysis",null,null,null,null,null,null,null,null,null],
    [27,"Table 3-Analysis of Total Emission Calculation for ICE Vehicles for Delhi 2021",null,null,null,null,null,null,null,null,null],
    [28,"Vehicle Category","Fuel Type","Share of Fuel (%)","Share of Fuel by Vehicle Category (%)","Share of CO2 Emission (Mt) (%)","Share of CO2 Emission (Mt) by Vehicle category (%)","Share of CH4 Emission (Mt) (%)","Share of CH4 Emission (Mt) by Vehicle category (%)","Share of N2O Emission (Mt)  (%)","Share of N2O Emission (Mt) by Vehicle category (%)"],
    [29,"2 Wheeler","PETROL","21.963657965532743","21.963657965532743","27.25557131450088","27.25557131450088","27.252026481706785","27.252026481706785","27.260688319719726","27.260688319719726"],
    [30,"3 Wheeler","CNG","0.7641096240869284","2.2998855700550407","0.0008171423159894994","1.9218776405272027","0.0013153802456605584","1.9221260272182068","0.00009793037160658255","1.92151909160036"],
    [31,null,"DIESEL","0.12057033620971815",null,"0.16487591903125706",null,"0.16485447543141488",null,"0.16490687310403762",null],
    [32,null,"PETROL","1.415205609758394",null,"1.7561845791799562",null,"1.7559561715411314",null,"1.7565142881247158",null],
    [33,"4 Wheeler","DIESEL","4.869851822992943","75.73645646441221","6.659360171853675","70.8225510449719","6.658494062020479","70.82584749107501","6.660610410946459","70.81779258867992"],
    [34,null,"PETROL","51.68880568403429",null,"64.1426820474712",null,"64.13433971334072",null,"64.15472429875996",null],
    [35,null,"CNG","19.177798957384976",null,"0.02050882564703277",null,"0.03301371571381232",null,"0.002457878973501036",null],
    [36,null,null,null,null,null,null,null,null,null,null],
    [37,null,null,null,null,null,null,null,null,null,null],
    [38,null,null,null,null,null,null,null,null,null,null],
    [39,"Table 4- Analysis of Total Emission Reduction for EV Vehicles for Delhi 2021",null,null,null,null,null,null,null,null,null],
    [40,"Vehicle Category","Proxy Fuel Type","Share of CO2 Emission (Mt) (%)","Share of CO2 Emission Reduction (Mt)  by Vehicle category (%)","Share of CH4 Emission Reduction (Mt)  (%)","Share of CH4 Emission (Mt) Reduction by Vehicle category (%)","Share of N2O Emission Reduction (Mt)  (%)","Share of N2O Emission Reduction (Mt) by Vehicle category (%)",null,null],
    [41,"2 Wheeler","PETROL","12.040316623347923","12.040316623347923","12.037710266931173","12.037710266931173","12.044079722228702","12.044079722228702",null,null],
    [42,"3 Wheeler","CNG","0.03143853048231037","73.94184293567004","0.0506032392466548","73.94500832624263","0.0037682189171001313","73.93727269437669",null,null],
    [43,null,"DIESEL","6.343395152637917",null,"6.342022003643811",null,"6.345377727012491",null,null,null],
    [44,null,"PETROL","67.56700925254981",null,"67.55238308335217",null,"67.5881267484471",null,null,null],
    [45,"4 Wheeler","DIESEL","1.3180808506714061","14.017840440982052","1.3177955269053945","14.017281406826195","1.3184928056663698","14.01864758339462",null,null],
    [46,null,"PETROL","0.006112834992951419",null,"12.692952071151286",null,"12.69966823136931",null,null,null],
    [47,null,"CNG","1.954503040373942e-6",null,"0.0065338087695142886",null,"0.00048654635893938486",null,null,null],
    [48,null,null,null,null,null,null,null,null,null,null],
    [49,null,null,null,null,null,null,null,null,null,null],
    [50,"Validation",null,null,null,null,null,null,null,null,null],
    [51,null,null,null,null,null,null,null,null,null,null],
    [52,"Table 5- Per Capita Emission for Road Transport (2W, 3W, 4W) for India (2022) from IESS Software",null,null,null,null,"Table 6- Per Capita Emission for New Registered (2W, 3W and 4W) for Delhi in 2021 from Calculations",null,null,null,null],
    [53,"CO2 Emission (Mt.)","CO2 Emission (Tonnes)","Population","Per Capita Emission CO2 in Tonnes",null,"CO2 Emission (Mt.)","CO2 Emission (Tonnes)","Population","Per Capita Emission CO2 in Tonnes",null],
    [54,"143.49040000000002","143490400.00000003","1383591897.89131","0.10370861539351983",null,"0.7659570337551159","765957.0337551159","22000000","0.03481622880705072",null],
    [55,null,null,null,null,null,null,null,null,null,null],
    [56,"Table 5.1- Percentage Share of Newly Registered Road Transport Vehicles (2W, 3W, 4W) Emissions for India",null,null,null,null,null,null,null,null,null],
    [57,"Year","New Registrations in Year","Total Registrations till Year","Total Scrapped Vehicles till Year (15 yr life assumed)","Total Plying Vehicles till Year","Percentage Share of Registered Vehicles to Fleet","Percentage Share of New Registered Vehicles Emissions for Year",null,null,null],
    [58,"2018","24421412","272587170","67000000","205587170","11.878859950258569","0.012319401178948522",null,null,null],
    [59,"2019","24562680","295771688","72700000","223071688","11.011114956013603","0.01141947486027049",null,null,null],
    [60,"Average Emissions for New Registered Vehicles",null,null,null,null,null,"0.011869438019609505","Source- MORTH 2011-12 Road Transport Yearbook",null,null],
    [61,null,null,null,null,null,null,null,null,null,null],
    [62,"Factors",null,null,null,null,null,null,null,null,null],
    [63,"Table 7-Population",null,null,"Table 8-Trip Rate Calculation",null,null,null,null,null,null],
    [64,"Data sources","In 2021(projected)",null,"Vehicle category","No. of trips/ daily trips","Population","Trip rate",null,null,null],
    [65,"MPD 2021","22000000",null,"2W","4753417","24880500","0.19104989851490123",null,null,null],
    [66,null,null,null,"3W","1186202","24880500","0.04767597114205904",null,null,null],
    [67,null,null,null,"4W","5954661","24880500","0.2393304395008139",null,null,null],
    [68,null,null,null,null,null,null,null,null,null,null],
    [69,"Table 9- Values of Avg. Trip length and Occupancy Factor",null,null,null,"Table 10- Conversion Factors",null,null,null,null,null],
    [70,"Variables","Vehicle Category","Values",null,"Tj/L Petrol","0.00003315",null,null,null,null],
    [71,"Av. Trip Length","2 Wheeler","7.4",null,"Tj/L -Diesel","0.00003653",null,null,null,null],
    [72,null,"3 Wheeler","9.5",null,"Tj/L -CNG","3.83e-8",null,null,null,null],
    [73,null,"4 Wheeler","11.2",null,"Tj to TWh","0.00027780000000000003",null,null,null,null],
    [74,"Occupancy Factor","2 Wheeler","1.2",null,null,null,null,null,null,null],
    [75,null,"3 Wheeler","2.1",null,null,null,null,null,null,null],
    [76,null,"4 Wheeler","2.2",null,null,null,null,null,null,null],
    [77,null,null,null,null,null,null,null,null,null,null],
    [78,"Table 11- Emissions factors for CO2 (Mt.) per TWH",null,null,"Table 12- Emissions factors for CH4 (Mt. of CO2 eq.) per TWH",null,null,"Table 13- Emissions factors for N2O (Mt. of CO2 eq.) per TWH",null,null,null],
    [79,"Petroleum Product","0.266724",null,"Petroleum Product","0.0003321",null,"Petroleum Product","0.0047989",null,null],
    [80,"Natural Gas","0.1989474",null,"Natural Gas","0.0003988",null,"Natural Gas","0.0004289",null,null],
    [81,null,null,null,null,null,null,null,null,null,null],
    [82,"Table 14- Mileage (km/l)",null,null,null,null,null,null,null,null,null],
    [83,"2 Wheeler","PETROL","60",null,null,null,null,null,null,null],
    [84,"3 Wheeler","CNG","29.09",null,null,null,null,null,null,null],
    [85,null,"DIESEL","28",null,null,null,null,null,null,null],
    [86,null,"PETROL","32.5",null,null,null,null,null,null,null],
    [87,"4 Wheeler","CNG","22.4",null,null,null,null,null,null,null],
    [88,null,"DIESEL","13.4",null,null,null,null,null,null,null],
    [89,null,"PETROL","17.2",null,null,null,null,null,null,null]
]}