{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["Safety","Environment","Cost","Effectiveness","Vehicle data","Sheet2","Safety Graphs","Environment Graphs","Cost Graphs","Effectiveness Graphs"],"not_rendered":{"charts":130,"comments":5},"read":"whole","date_system":"1900"}

{"sheet":"Safety","index":0,"n_rows":120,"n_cols":39,"rows_kept":120,"merged":[[1,1,1,14],[2,2,2,5],[4,2,4,13],[6,20,6,26],[7,10,7,14],[10,0,12,0],[13,10,13,14],[14,0,16,0],[17,0,19,0],[20,0,22,0],[23,0,27,0],[27,2,27,13],[28,0,29,0],[28,2,28,13],[29,2,29,13],[32,1,32,14],[34,2,34,13],[37,10,37,14],[40,0,42,0],[43,10,43,14],[44,0,46,0],[47,0,49,0],[50,0,52,0],[53,0,57,0],[57,2,57,13],[58,0,59,0],[58,2,58,13],[59,2,59,13],[62,1,62,14],[64,2,64,13],[67,10,67,14],[70,0,72,0],[73,10,73,14],[74,0,76,0],[77,0,79,0],[80,0,82,0],[83,0,87,0],[87,2,87,13],[88,0,89,0],[88,2,88,13],[89,2,89,13],[92,1,92,13],[94,2,94,13],[97,10,97,14],[100,0,102,0],[103,10,103,14],[104,0,106,0],[107,0,109,0],[110,0,112,0],[113,0,117,0],[117,2,117,13],[118,0,119,0],[118,2,118,13],[119,2,119,13]]}
[null,"Please fill out only the yellow cells only"]
[null,2013]
[null,"Reference country"]
[null,null,"January","February","March","April","May","June","July","August","September","October","November","December",2013,2014,2015,2016]
[null,"Reference period (number of months)",{"$nulls":13},{"$f":"O35","v":0},{"$f":"O65","v":0},{"$f":"O95","v":0}]
[null,"Total working days ",{"$nulls":12},{"$f":"SUM(C6:N6)","v":0},{"$f":"O36","v":0},{"$f":"O66","v":0},{"$f":"O96","v":0}]
[{"$nulls":20},"Green cells are produced from data filled in yellow cells"]
[2013,"Safety: Driver and passenger safety. Reduction of accidents.  ",{"$nulls":8},"Data Input for KPIs",{"$nulls":7},"Comments",null,"KPIs",{"$nulls":11},2013]
[null,null,"January","February","March","April","May","June","July","August","September","October","November","December",2013,2014,2015,2016,null,null,2013,2014,2015,2016,{"$nulls":3},"January","February","March","April","May","June","July","August","September","October","November","December"]
["Kilometers","Fleet kilometers driven ",{"$nulls":12},{"$f":"SUM(C10:N10)","v":0},{"$f":"O40","v":0},{"$f":"O70","v":0},{"$f":"O100","v":0},null,"Safety KPIS1.1           Km/fatal accidents per year",{"$f":"IF(O11=0,\"GOOD JOB!\",O$10/O11)","v":"GOOD JOB!"},{"$f":"IF(P11=0,\"GOOD JOB!\",P$10/P11)","v":"GOOD JOB!"},"GOOD JOB!","GOOD JOB!",null,null,"Safety KPIS1.1           Km/fatal accidents per month",{"$f":"IF(C11=0,0,C10/C11)","v":0},{"$f":"IF(D11=0,0,D10/D11)","v":0},0,0,0,0,0,0,0,0,0,0]
["Number of accidents","Number of fatal accidents",{"$nulls":12},{"$f":"SUM(C11:N11)","v":0},{"$f":"O41","v":0},{"$f":"O71","v":0},{"$f":"O101","v":0},null,"Safety KPIS1.2           Km/injury only accidents per year",{"$f":"IF(O12=0,\"GOOD JOB!\",O$10/O12)","v":"GOOD JOB!"},"GOOD JOB!","GOOD JOB!","GOOD JOB!",null,null,"Safety KPIS1.2           Km/injury only accidents per month",{"$f":"IF(C12=0,0,C10/C12)","v":0},{"$f":"IF(D12=0,0,D10/D12)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Number of injury-only accidents ",{"$nulls":12},{"$f":"SUM(C12:N12)","v":0},0,0,0,null,"Safety KPIS1.3           Km/damage only accidents per year",{"$f":"IF(O13=0,\"GOOD JOB!\",O$10/O13)","v":"GOOD JOB!"},"GOOD JOB!","GOOD JOB!","GOOD JOB!",null,null,"Safety KPIS1.3           Km/damage only accidents per month",{"$f":"IF(C13=0,0,C10/C13)","v":0},{"$f":"IF(D13=0,0,D10/D13)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Number of damage-only accidents during reference period",{"$nulls":12},{"$f":"SUM(C13:N13)","v":0},0,0,0,null,"Safety KPIS2.1           Fatal accidents per year",{"$f":"IF(O$5=0,0,O11*12/O$5)","v":0},0,0,0,null,null,"Safety KPIS2.1           Fatal accidents per month",{"$f":"C11","v":0},{"$f":"D11","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":10},"Data Input for PIs",{"$nulls":8},"Safety KPIS2.2           Injury only accidents per year",0,0,0,0,null,null,"Safety KPIS2.2           Injury only accidents per month",{"$f":"C12","v":0},{"$f":"D12","v":0},{"$f":"E12","v":0},{"$f":"F12","v":0},{"$f":"G12","v":0},{"$f":"H12","v":0},{"$f":"I12","v":0},{"$f":"J12","v":0},{"$f":"K12","v":0},{"$f":"L12","v":0},{"$f":"M12","v":0},{"$f":"N12","v":0}]
["Number of Staff in the reference country","Number of drivers ",{"$nulls":12},{"$f":"IF(O$5=0,0,(C15*O$5+(D15-C15)*(O$5-1)+(E15-D15)*(O$5-2)+(F15-E15)*(O$5-3)+(G15-F15)*(O$5-4)+(H15-G15)*(O$5-5)+(I15-H15)*(O$5-6)+(J15-I15)*(O$5-7)+(K15-J15)*(O$5-8)+(L15-K15)*(O$5-9)+(M15-L15)*(O$5-10)+(N15-M15))/O$5)","v":0},0,0,0,null,"Safety KPIS2.3           Damage only accidents per year",0,0,0,0,null,null,"Safety KPIS2.3           Damage only accidents per month",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Number of management staff  ",{"$nulls":12},0,0,0,0,null,"Safety KPIS2.4           Total Number of accidents per year",{"$f":"IF(O$5=0,0,SUM(O11:O13)*12/O$5)","v":0},{"$f":"IF(P$5=0,0,SUM(P11:P13)*12/P$5)","v":0},{"$f":"IF(Q$5=0,0,SUM(Q11:Q13)*12/Q$5)","v":0},{"$f":"IF(R$5=0,0,SUM(R11:R13)*12/R$5)","v":0},null,null,"Safety KPIS2.4           Total Number of accidents per month",{"$f":"SUM(AB13:AB15)","v":0},{"$f":"SUM(AC13:AC15)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Number of rest of the staff ",{"$nulls":12},0,0,0,0,null,null,"PIs"]
["Number of trained staff in the reference country","Number of drivers with  road & safety training ",{"$nulls":12},0,0,0,0,null,"S1:Country offices with road & safety action plan (%) (HQ level)",{"$f":"IF(O29=0,0,O30/O29)","v":{"v":0,"d":"0%"}},{"$f":"IF(P29=0,0,P30/P29)","v":{"v":0,"d":"0%"}},{"$f":"IF(Q29=0,0,Q30/Q29)","v":{"v":0,"d":"0%"}},{"$f":"IF(R29=0,0,R30/R29)","v":{"v":0,"d":"0%"}}]
[null,"Number of management staff with road & safety training",{"$nulls":12},0,0,0,0,null,"S2.1: Staff trained (%) (drivers)",{"$f":"IF(O15=0,0,O18/O15)","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,"S2.1: Staff trained (%) (drivers)",{"$f":"IF(C15=0,0,C18/C15)","v":0},{"$f":"IF(D15=0,0,D18/D15)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Number of the rest of staff with road & safety training",{"$nulls":12},0,0,0,0,null,"S2.2: Staff trained (%)  (management)",{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,"S2.2: Staff trained (%)  (management)",{"$f":"IF(C16=0,0,C19/C16)","v":0},{"$f":"IF(D16=0,0,D19/D16)","v":0},0,0,0,0,0,0,0,0,0,0]
["Training hours in  reference period","Number of road and safety taining hours for drivers",{"$nulls":12},{"$f":"SUM(C21:N21)","v":0},0,0,0,null,"S2.3: Staff trained (%) (rest of staff)",{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,null,"S2.3: Staff trained (%) (rest of staff)",{"$f":"IF(C17=0,0,C20/C17)","v":0},{"$f":"IF(D17=0,0,D20/D17)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Number of road and safety taining hours for management staff",{"$nulls":12},{"$f":"SUM(C22:N22)","v":0},0,0,0,null,"S3.1: Training hours per driver per year",{"$f":"IF(O15=0,0,O21/O15)","v":0},0,0,0,null,null,"S3.1: Training hours per driver per month",{"$f":"C21","v":0},{"$f":"D21","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(N15=0,0,N21/N15)","v":0}]
[null,"Number of driver training hours for rest of staff",{"$nulls":12},{"$f":"SUM(C23:N23)","v":0},0,0,0,null,"S3.2: Training hours per management staff per year",0,0,0,0,null,null,"S3.2: Training hours per management staff per month",{"$f":"C22","v":0},{"$f":"D22","v":0},{"$f":"E22","v":0},{"$f":"F22","v":0},{"$f":"G22","v":0},{"$f":"H22","v":0},{"$f":"I22","v":0},{"$f":"J22","v":0},{"$f":"K22","v":0},{"$f":"L22","v":0},{"$f":"M22","v":0},{"$f":"IF(N16=0,0,N22/N16)","v":0}]
["Data from data  collection system","Number of traffic fines",{"$nulls":12},{"$f":"SUM(C24:N24)","v":0},0,0,0,null,"S3.3: Training hours per rest of staff per year",0,0,0,0,null,null,"S3.3: Training hours per rest of staff per month",0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(N17=0,0,N23/N17)","v":0}]
[null,"Number of speed violation occurences",{"$nulls":12},{"$f":"IF(SUM(C15:N15)=0,0,(C25*C$15+D25*D$15+E25*E$15+F25*F$15+G25*G$15+H25*H$15+I25*I$15+J25*J$15+K25*K$15+L25*L$15+M25*M$15+N25*N$15)/SUM(C$15:N$15))","v":0},0,0,0,null,"S4: Average working hours per driver per day",{"$f":"O26","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,"S4: Average working hours per driver per day",{"$f":"C26","v":0},{"$f":"D26","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Average working hours per driver per day",{"$nulls":12},{"$f":"IF(SUM(C16:N16)=0,0,(C26*C$15+D26*D$15+E26*E$15+F26*F$15+G26*G$15+H26*H$15+I26*I$15+J26*J$15+K26*K$15+L26*L$15+M26*M$15+N26*N$15)/SUM(C$15:N$15))","v":0},0,0,0,null,"S5: Average night driving hours per driver per day ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,"S5: Average night driving hours per driver per day ",{"$f":"C27","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Average night driving hours per driver per day ",{"$nulls":12},{"$f":"IF(SUM(C17:N17)=0,0,(C27*C$15+D27*D$15+E27*E$15+F27*F$15+G27*G$15+H27*H$15+I27*I$15+J27*J$15+K27*K$15+L27*L$15+M27*M$15+N27*N$15)/SUM(C$15:N$15))","v":0},0,0,0,null,"S6: Average kilometers per driver per day ",{"$f":"IF(O10*O15*O6=0,0,O10/O15/O6)","v":{"v":0,"d":"0.00"}},{"$f":"IF(P10*P15*P6=0,0,P10/P15/P6)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Q10*Q15*Q6=0,0,Q10/Q15/Q6)","v":{"v":0,"d":"0.00"}},{"$f":"IF(R10*R15*R6=0,0,R10/R15/R6)","v":{"v":0,"d":"0.00"}},null,null,"S6: Average kilometers per driver per day ",{"$f":"IF(C10*C15*C6=0,0,C10/C15/C6)","v":0},{"$f":"IF(D10*D15*D6=0,0,D10/D15/D6)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Maintenance done on time according to maintenance schedule (%)",{"$nulls":13},0,0,0,null,"S7: Number of kms per speed violation occurrences",{"$f":"IF(O25=0,\"GOOD JOB!\",O$10/O25)","v":"GOOD JOB!"},{"$f":"IF(P25=0,\"GOOD JOB!\",P$10/P25)","v":"GOOD JOB!"},"GOOD JOB!","GOOD JOB!",null,null,"S7: Number of kms per speed violation occurence",{"$f":"IF(C25=0,0,C10/C25)","v":0},{"$f":"IF(D25=0,0,D10/D25)","v":0},0,0,0,0,0,0,0,0,0,0]
["Country offices","Total number of country offices (HQ level)",{"$nulls":13},0,0,0,null,"S8: Number of traffic fines per driver per year",{"$f":"IF(O5=0,0,(O24/O15)*12/O5)","v":{"v":0,"d":"0.00"}},{"$f":"IF(P5=0,0,(P24/P15)*12/P5)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Q5=0,0,(Q24/Q15)*12/Q5)","v":{"v":0,"d":"0.00"}},{"$f":"IF(R5=0,0,(R24/R15)*12/R5)","v":{"v":0,"d":"0.00"}},null,null,"S8: Number of traffic fines per driver per month",{"$f":"IF(C15=0,0,C24/C15)","v":0},{"$f":"IF(D15=0,0,D24/D15)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Number of country offices road & safety action plan (HQ level)",{"$nulls":13},0,0,0,null,"S9: Maintenance done on time according to maintenance schedule (%)",{"$f":"O28","v":{"v":0,"d":"0%"}},{"$f":"P28","v":{"v":0,"d":"0%"}},{"$f":"Q28","v":{"v":0,"d":"0%"}},{"$f":"R28","v":{"v":0,"d":"0%"}}]
[]
[]
[null,2014]
[null,null,"January","February","March","April","May","June","July","August","September","October","November","December",2014]
[null,"Reference period (number of months)"]
[null,"Total working days ",{"$nulls":12},{"$f":"SUM(C36:N36)","v":0}]
[]
[2014,"Safety: Driver and passenger safety. Reduction of accidents.  ",{"$nulls":8},"Data Input for KPIs",{"$nulls":21},2014]
[null,null,"January","February","March","April","May","June","July","August","September","October","November","December",2014,{"$nulls":12},"January","February","March","April","May","June","July","August","September","October","November","December"]
["Kilometers","Fleet kilometers driven ",{"$nulls":12},{"$f":"SUM(C40:N40)","v":0},{"$nulls":11},"Safety KPIS1.1           Km/fatal accidents per month",{"$f":"IF(C41=0,0,C40/C41)","v":0},{"$f":"IF(D41=0,0,D40/D41)","v":0},{"$f":"IF(E41=0,0,E40/E41)","v":0},{"$f":"IF(F41=0,0,F40/F41)","v":0},{"$f":"IF(G41=0,0,G40/G41)","v":0},{"$f":"IF(H41=0,0,H40/H41)","v":0},{"$f":"IF(I41=0,0,I40/I41)","v":0},{"$f":"IF(J41=0,0,J40/J41)","v":0},{"$f":"IF(K41=0,0,K40/K41)","v":0},{"$f":"IF(L41=0,0,L40/L41)","v":0},{"$f":"IF(M41=0,0,M40/M41)","v":0},{"$f":"IF(N41=0,0,N40/N41)","v":0}]
["Number of accidents","Number of fatal accidents",{"$nulls":12},{"$f":"SUM(C41:N41)","v":0},{"$nulls":11},"Safety KPIS1.2           Km/injury only accidents per month",{"$f":"IF(C42=0,0,C40/C42)","v":0},{"$f":"IF(D42=0,0,D40/D42)","v":0},{"$f":"IF(E42=0,0,E40/E42)","v":0},{"$f":"IF(F42=0,0,F40/F42)","v":0},{"$f":"IF(G42=0,0,G40/G42)","v":0},{"$f":"IF(H42=0,0,H40/H42)","v":0},{"$f":"IF(I42=0,0,I40/I42)","v":0},{"$f":"IF(J42=0,0,J40/J42)","v":0},{"$f":"IF(K42=0,0,K40/K42)","v":0},{"$f":"IF(L42=0,0,L40/L42)","v":0},{"$f":"IF(M42=0,0,M40/M42)","v":0},{"$f":"IF(N42=0,0,N40/N42)","v":0}]
[null,"Number of injury-only accidents ",{"$nulls":12},{"$f":"SUM(C42:N42)","v":0},{"$nulls":11},"Safety KPIS1.3           Km/damage only accidents per month",{"$f":"IF(C43=0,0,C40/C43)","v":0},{"$f":"IF(D43=0,0,D40/D43)","v":0},{"$f":"IF(E43=0,0,E40/E43)","v":0},{"$f":"IF(F43=0,0,F40/F43)","v":0},{"$f":"IF(G43=0,0,G40/G43)","v":0},{"$f":"IF(H43=0,0,H40/H43)","v":0},{"$f":"IF(I43=0,0,I40/I43)","v":0},{"$f":"IF(J43=0,0,J40/J43)","v":0},{"$f":"IF(K43=0,0,K40/K43)","v":0},{"$f":"IF(L43=0,0,L40/L43)","v":0},{"$f":"IF(M43=0,0,M40/M43)","v":0},{"$f":"IF(N43=0,0,N40/N43)","v":0}]
[null,"Number of damage-only accidents during reference period",{"$nulls":12},{"$f":"SUM(C43:N43)","v":0},{"$nulls":11},"Safety KPIS2.1           Fatal accidents per month",{"$f":"C41","v":0},{"$f":"D41","v":0},{"$f":"E41","v":0},{"$f":"F41","v":0},{"$f":"G41","v":0},{"$f":"H41","v":0},{"$f":"I41","v":0},{"$f":"J41","v":0},{"$f":"K41","v":0},{"$f":"L41","v":0},{"$f":"M41","v":0},{"$f":"N41","v":0}]
[{"$nulls":10},"Data Input for PIs",{"$nulls":15},"Safety KPIS2.2           Injury only accidents per month",{"$f":"C42","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Number of Staff in the reference country","Number of drivers ",{"$nulls":12},{"$f":"IF(O$35=0,0,(C45*O$35+(D45-C45)*(O$35-1)+(E45-D45)*(O$35-2)+(F45-E45)*(O$35-3)+(G45-F45)*(O$35-4)+(H45-G45)*(O$35-5)+(I45-H45)*(O$35-6)+(J45-I45)*(O$35-7)+(K45-J45)*(O$35-8)+(L45-K45)*(O$35-9)+(M45-L45)*(O$35-10)+(N45-M45))/O$35)","v":0},{"$nulls":11},"Safety KPIS2.3           Damage only accidents per month",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Number of management staff  ",{"$nulls":12},0,{"$nulls":11},"Safety KPIS2.4           Total Number of accidents per month",{"$f":"SUM(AB43:AB45)","v":0},{"$f":"SUM(AC43:AC45)","v":0},{"$f":"SUM(AD43:AD45)","v":0},{"$f":"SUM(AE43:AE45)","v":0},{"$f":"SUM(AF43:AF45)","v":0},{"$f":"SUM(AG43:AG45)","v":0},{"$f":"SUM(AH43:AH45)","v":0},{"$f":"SUM(AI43:AI45)","v":0},{"$f":"SUM(AJ43:AJ45)","v":0},{"$f":"SUM(AK43:AK45)","v":0},{"$f":"SUM(AL43:AL45)","v":0},{"$f":"SUM(AM43:AM45)","v":0}]
[null,"Number of rest of the staff ",{"$nulls":12},0]
["Number of trained staff in the reference country","Number of drivers with  road & safety training ",{"$nulls":12},0]
[null,"Number of management staff with road & safety training",{"$nulls":12},0,{"$nulls":11},"S2.1: Staff trained (%) (drivers)",{"$f":"IF(C45=0,0,C48/C45)","v":0},{"$f":"IF(D45=0,0,D48/D45)","v":0},{"$f":"IF(E45=0,0,E48/E45)","v":0},{"$f":"IF(F45=0,0,F48/F45)","v":0},{"$f":"IF(G45=0,0,G48/G45)","v":0},{"$f":"IF(H45=0,0,H48/H45)","v":0},{"$f":"IF(I45=0,0,I48/I45)","v":0},{"$f":"IF(J45=0,0,J48/J45)","v":0},{"$f":"IF(K45=0,0,K48/K45)","v":0},{"$f":"IF(L45=0,0,L48/L45)","v":0},{"$f":"IF(M45=0,0,M48/M45)","v":0},{"$f":"IF(N45=0,0,N48/N45)","v":0}]
[null,"Number of the rest of staff with road & safety training",{"$nulls":12},0,{"$nulls":11},"S2.2: Staff trained (%)  (management)",{"$f":"IF(C46=0,0,C49/C46)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Training hours in  reference period","Number of road and safety taining hours for drivers",{"$nulls":12},{"$f":"SUM(C51:N51)","v":0},{"$nulls":11},"S2.3: Staff trained (%) (rest of staff)",{"$f":"IF(C47=0,0,C50/C47)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Number of road and safety taining hours for management staff",{"$nulls":12},{"$f":"SUM(C52:N52)","v":0},{"$nulls":11},"S3.1: Training hours per driver per month",{"$f":"C51","v":0},{"$f":"D51","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Number of driver training hours for rest of staff",{"$nulls":12},{"$f":"SUM(C53:N53)","v":0},{"$nulls":11},"S3.2: Training hours per management staff per month",{"$f":"C52","v":0},{"$f":"D52","v":0},{"$f":"E52","v":0},{"$f":"F52","v":0},{"$f":"G52","v":0},{"$f":"H52","v":0},{"$f":"I52","v":0},{"$f":"J52","v":0},{"$f":"K52","v":0},{"$f":"L52","v":0},{"$f":"M52","v":0},{"$f":"N52","v":0}]
["Data from data  collection system","Number of traffic fines ",{"$nulls":12},{"$f":"SUM(C54:N54)","v":0},{"$nulls":11},"S3.3: Training hours per rest of staff per month",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Number of speed violation occurences",{"$nulls":12},{"$f":"IF(SUM(C$45:N$45)=0,0,(C55*C$45+D55*D$45+E55*E$45+F55*F$45+G55*G$45+H55*H$45+I55*I$45+J55*J$45+K55*K$45+L55*L$45+M55*M$45+N55*N$45)/SUM(C$45:N$45))","v":0},{"$nulls":11},"S4: Average working hours per driver per day",{"$f":"C56","v":0},{"$f":"D56","v":0},{"$f":"E56","v":0},{"$f":"F56","v":0},{"$f":"G56","v":0},{"$f":"H56","v":0},{"$f":"I56","v":0},{"$f":"J56","v":0},{"$f":"K56","v":0},{"$f":"L56","v":0},{"$f":"M56","v":0},{"$f":"N56","v":0}]
[null,"Average working hours per driver per day",{"$nulls":12},{"$f":"IF(SUM(C$45:N$45)=0,0,(C56*C$45+D56*D$45+E56*E$45+F56*F$45+G56*G$45+H56*H$45+I56*I$45+J56*J$45+K56*K$45+L56*L$45+M56*M$45+N56*N$45)/SUM(C$45:N$45))","v":0},{"$nulls":11},"S5: Average night driving hours per driver per day ",{"$f":"C57","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Average night driving hours per driver per day ",{"$nulls":12},{"$f":"IF(SUM(C$45:N$45)=0,0,(C57*C$45+D57*D$45+E57*E$45+F57*F$45+G57*G$45+H57*H$45+I57*I$45+J57*J$45+K57*K$45+L57*L$45+M57*M$45+N57*N$45)/SUM(C$45:N$45))","v":0},{"$nulls":11},"S6: Average kilometers per driver per day ",{"$f":"IF(C40*C45*C36=0,0,C40/C45/C36)","v":0},{"$f":"IF(D40*D45*D36=0,0,D40/D45/D36)","v":0},{"$f":"IF(E40*E45*E36=0,0,E40/E45/E36)","v":0},{"$f":"IF(F40*F45*F36=0,0,F40/F45/F36)","v":0},{"$f":"IF(G40*G45*G36=0,0,G40/G45/G36)","v":0},{"$f":"IF(H40*H45*H36=0,0,H40/H45/H36)","v":0},{"$f":"IF(I40*I45*I36=0,0,I40/I45/I36)","v":0},{"$f":"IF(J40*J45*J36=0,0,J40/J45/J36)","v":0},{"$f":"IF(K40*K45*K36=0,0,K40/K45/K36)","v":0},{"$f":"IF(L40*L45*L36=0,0,L40/L45/L36)","v":0},{"$f":"IF(M40*M45*M36=0,0,M40/M45/M36)","v":0},{"$f":"IF(N40*N45*N36=0,0,N40/N45/N36)","v":0}]
[null,"Maintenance done on time according to maintenance schedule (%)",{"$nulls":24},"S7: Number of kms per speed violation occurence",{"$f":"IF(C55=0,0,C40/C55)","v":0},{"$f":"IF(D55=0,0,D40/D55)","v":0},{"$f":"IF(E55=0,0,E40/E55)","v":0},{"$f":"IF(F55=0,0,F40/F55)","v":0},{"$f":"IF(G55=0,0,G40/G55)","v":0},{"$f":"IF(H55=0,0,H40/H55)","v":0},{"$f":"IF(I55=0,0,I40/I55)","v":0},{"$f":"IF(J55=0,0,J40/J55)","v":0},{"$f":"IF(K55=0,0,K40/K55)","v":0},{"$f":"IF(L55=0,0,L40/L55)","v":0},{"$f":"IF(M55=0,0,M40/M55)","v":0},{"$f":"IF(N55=0,0,N40/N55)","v":0}]
["Country offices","Total number of country offices (HQ level)",{"$nulls":24},"S8: Number of traffic fines per driver per month",{"$f":"IF(C45=0,0,C54/C45)","v":0},{"$f":"IF(D45=0,0,D54/D45)","v":0},{"$f":"IF(E45=0,0,E54/E45)","v":0},{"$f":"IF(F45=0,0,F54/F45)","v":0},{"$f":"IF(G45=0,0,G54/G45)","v":0},{"$f":"IF(H45=0,0,H54/H45)","v":0},{"$f":"IF(I45=0,0,I54/I45)","v":0},{"$f":"IF(J45=0,0,J54/J45)","v":0},{"$f":"IF(K45=0,0,K54/K45)","v":0},{"$f":"IF(L45=0,0,L54/L45)","v":0},{"$f":"IF(M45=0,0,M54/M45)","v":0},{"$f":"IF(N45=0,0,N54/N45)","v":0}]
[null,"Number of country offices road & safety action plan (HQ level)"]
[]
[]
[null,2015]
[null,null,"January","February","March","April","May","June","July","August","September","October","November","December",2015]
[null,"Reference period (number of months)"]
[null,"Total working days ",{"$nulls":12},{"$f":"SUM(C66:N66)","v":0}]
[]
[2015,"Safety: Driver and passenger safety. Reduction of accidents.  ",{"$nulls":8},"Data Input for KPIs",{"$nulls":21},2015]
[null,null,"January","February","March","April","May","June","July","August","September","October","November","December",2015,{"$nulls":12},"January","February","March","April","May","June","July","August","September","October","November","December"]
["Kilometers","Fleet kilometers driven ",{"$nulls":12},{"$f":"SUM(C70:N70)","v":0},{"$nulls":11},"Safety KPIS1.1           Km/fatal accidents per month",{"$f":"IF(C71=0,0,C70/C71)","v":0},{"$f":"IF(D71=0,0,D70/D71)","v":0},{"$f":"IF(E71=0,0,E70/E71)","v":0},{"$f":"IF(F71=0,0,F70/F71)","v":0},{"$f":"IF(G71=0,0,G70/G71)","v":0},{"$f":"IF(H71=0,0,H70/H71)","v":0},{"$f":"IF(I71=0,0,I70/I71)","v":0},{"$f":"IF(J71=0,0,J70/J71)","v":0},{"$f":"IF(K71=0,0,K70/K71)","v":0},{"$f":"IF(L71=0,0,L70/L71)","v":0},{"$f":"IF(M71=0,0,M70/M71)","v":0},{"$f":"IF(N71=0,0,N70/N71)","v":0}]
["Number of accidents","Number of fatal accidents",{"$nulls":12},{"$f":"SUM(C71:N71)","v":0},{"$nulls":11},"Safety KPIS1.2           Km/injury only accidents per month",{"$f":"IF(C72=0,0,C70/C72)","v":0},{"$f":"IF(D72=0,0,D70/D72)","v":0},{"$f":"IF(E72=0,0,E70/E72)","v":0},{"$f":"IF(F72=0,0,F70/F72)","v":0},{"$f":"IF(G72=0,0,G70/G72)","v":0},{"$f":"IF(H72=0,0,H70/H72)","v":0},{"$f":"IF(I72=0,0,I70/I72)","v":0},{"$f":"IF(J72=0,0,J70/J72)","v":0},{"$f":"IF(K72=0,0,K70/K72)","v":0},{"$f":"IF(L72=0,0,L70/L72)","v":0},{"$f":"IF(M72=0,0,M70/M72)","v":0},{"$f":"IF(N72=0,0,N70/N72)","v":0}]
[null,"Number of injury-only accidents ",{"$nulls":12},{"$f":"SUM(C72:N72)","v":0},{"$nulls":11},"Safety KPIS1.3           Km/damage only accidents per month",{"$f":"IF(C73=0,0,C70/C73)","v":0},{"$f":"IF(D73=0,0,D70/D73)","v":0},{"$f":"IF(E73=0,0,E70/E73)","v":0},{"$f":"IF(F73=0,0,F70/F73)","v":0},{"$f":"IF(G73=0,0,G70/G73)","v":0},{"$f":"IF(H73=0,0,H70/H73)","v":0},{"$f":"IF(I73=0,0,I70/I73)","v":0},{"$f":"IF(J73=0,0,J70/J73)","v":0},{"$f":"IF(K73=0,0,K70/K73)","v":0},{"$f":"IF(L73=0,0,L70/L73)","v":0},{"$f":"IF(M73=0,0,M70/M73)","v":0},{"$f":"IF(N73=0,0,N70/N73)","v":0}]
[null,"Number of damage-only accidents during reference period",{"$nulls":12},{"$f":"SUM(C73:N73)","v":0},{"$nulls":11},"Safety KPIS2.1           Fatal accidents per month",{"$f":"C71","v":0},{"$f":"D71","v":0},{"$f":"E71","v":0},{"$f":"F71","v":0},{"$f":"G71","v":0},{"$f":"H71","v":0},{"$f":"I71","v":0},{"$f":"J71","v":0},{"$f":"K71","v":0},{"$f":"L71","v":0},{"$f":"M71","v":0},{"$f":"N71","v":0}]
[{"$nulls":10},"Data Input for PIs",{"$nulls":15},"Safety KPIS2.2           Injury only accidents per month",{"$f":"C72","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Number of Staff in the reference country","Number of drivers ",{"$nulls":12},{"$f":"IF(O$65=0,0,(C75*O$65+(D75-C75)*(O$65-1)+(E75-D75)*(O$65-2)+(F75-E75)*(O$65-3)+(G75-F75)*(O$65-4)+(H75-G75)*(O$65-5)+(I75-H75)*(O$65-6)+(J75-I75)*(O$65-7)+(K75-J75)*(O$65-8)+(L75-K75)*(O$65-9)+(M75-L75)*(O$65-10)+(N75-M75))/O$65)","v":0},{"$nulls":11},"Safety KPIS2.3           Damage only accidents per month",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Number of management staff  ",{"$nulls":12},0,{"$nulls":11},"Safety KPIS2.4           Total Number of accidents per month",{"$f":"SUM(AB73:AB75)","v":0},{"$f":"SUM(AC73:AC75)","v":0},{"$f":"SUM(AD73:AD75)","v":0},{"$f":"SUM(AE73:AE75)","v":0},{"$f":"SUM(AF73:AF75)","v":0},{"$f":"SUM(AG73:AG75)","v":0},{"$f":"SUM(AH73:AH75)","v":0},{"$f":"SUM(AI73:AI75)","v":0},{"$f":"SUM(AJ73:AJ75)","v":0},{"$f":"SUM(AK73:AK75)","v":0},{"$f":"SUM(AL73:AL75)","v":0},{"$f":"SUM(AM73:AM75)","v":0}]
[null,"Number of rest of the staff ",{"$nulls":12},0]
["Number of trained staff in the reference country","Number of drivers with  road & safety training ",{"$nulls":12},0]
[null,"Number of management staff with road & safety training",{"$nulls":12},0,{"$nulls":11},"S2.1: Staff trained (%) (drivers)",{"$f":"IF(C75=0,0,C78/C75)","v":0},{"$f":"IF(D75=0,0,D78/D75)","v":0},{"$f":"IF(E75=0,0,E78/E75)","v":0},{"$f":"IF(F75=0,0,F78/F75)","v":0},{"$f":"IF(G75=0,0,G78/G75)","v":0},{"$f":"IF(H75=0,0,H78/H75)","v":0},{"$f":"IF(I75=0,0,I78/I75)","v":0},{"$f":"IF(J75=0,0,J78/J75)","v":0},{"$f":"IF(K75=0,0,K78/K75)","v":0},{"$f":"IF(L75=0,0,L78/L75)","v":0},{"$f":"IF(M75=0,0,M78/M75)","v":0},{"$f":"IF(N75=0,0,N78/N75)","v":0}]
[null,"Number of the rest of staff with road & safety training",{"$nulls":12},0,{"$nulls":11},"S2.2: Staff trained (%)  (management)",{"$f":"IF(C76=0,0,C79/C76)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Training hours in  reference period","Number of road and safety taining hours for drivers",{"$nulls":12},{"$f":"SUM(C81:N81)","v":0},{"$nulls":11},"S2.3: Staff trained (%) (rest of staff)",{"$f":"IF(C77=0,0,C80/C77)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Number of road and safety taining hours for management staff",{"$nulls":12},{"$f":"SUM(C82:N82)","v":0},{"$nulls":11},"S3.1: Training hours per driver per month",{"$f":"C81","v":0},{"$f":"D81","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Number of driver training hours for rest of staff",{"$nulls":12},{"$f":"SUM(C83:N83)","v":0},{"$nulls":11},"S3.2: Training hours per management staff per month",{"$f":"C82","v":0},{"$f":"D82","v":0},{"$f":"E82","v":0},{"$f":"F82","v":0},{"$f":"G82","v":0},{"$f":"H82","v":0},{"$f":"I82","v":0},{"$f":"J82","v":0},{"$f":"K82","v":0},{"$f":"L82","v":0},{"$f":"M82","v":0},{"$f":"N82","v":0}]
["Data from data  collection system","Number of traffic fines",{"$nulls":12},{"$f":"SUM(C84:N84)","v":0},{"$nulls":11},"S3.3: Training hours per rest of staff per month",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Number of speed violation occurences",{"$nulls":12},{"$f":"IF(SUM(C$75:N$75)=0,0,(C85*C$75+D85*D$75+E85*E$75+F85*F$75+G85*G$75+H85*H$75+I85*I$75+J85*J$75+K85*K$75+L85*L$75+M85*M$75+N85*N$75)/SUM(C$75:N$75))","v":0},{"$nulls":11},"S4: Average working hours per driver per day",{"$f":"C86","v":0},{"$f":"D86","v":0},{"$f":"E86","v":0},{"$f":"F86","v":0},{"$f":"G86","v":0},{"$f":"H86","v":0},{"$f":"I86","v":0},{"$f":"J86","v":0},{"$f":"K86","v":0},{"$f":"L86","v":0},{"$f":"M86","v":0},{"$f":"N86","v":0}]
[null,"Average working hours per driver per day",{"$nulls":12},{"$f":"IF(SUM(C$75:N$75)=0,0,(C86*C$75+D86*D$75+E86*E$75+F86*F$75+G86*G$75+H86*H$75+I86*I$75+J86*J$75+K86*K$75+L86*L$75+M86*M$75+N86*N$75)/SUM(C$75:N$75))","v":0},{"$nulls":11},"S5: Average night driving hours per driver per day ",{"$f":"C87","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Average night driving hours per driver per day ",{"$nulls":12},{"$f":"IF(SUM(C$75:N$75)=0,0,(C87*C$75+D87*D$75+E87*E$75+F87*F$75+G87*G$75+H87*H$75+I87*I$75+J87*J$75+K87*K$75+L87*L$75+M87*M$75+N87*N$75)/SUM(C$75:N$75))","v":0},{"$nulls":11},"S6: Average kilometers per driver per day ",{"$f":"IF(C70*C75*C66=0,0,C70/C75/C66)","v":0},{"$f":"IF(D70*D75*D66=0,0,D70/D75/D66)","v":0},{"$f":"IF(E70*E75*E66=0,0,E70/E75/E66)","v":0},{"$f":"IF(F70*F75*F66=0,0,F70/F75/F66)","v":0},{"$f":"IF(G70*G75*G66=0,0,G70/G75/G66)","v":0},{"$f":"IF(H70*H75*H66=0,0,H70/H75/H66)","v":0},{"$f":"IF(I70*I75*I66=0,0,I70/I75/I66)","v":0},{"$f":"IF(J70*J75*J66=0,0,J70/J75/J66)","v":0},{"$f":"IF(K70*K75*K66=0,0,K70/K75/K66)","v":0},{"$f":"IF(L70*L75*L66=0,0,L70/L75/L66)","v":0},{"$f":"IF(M70*M75*M66=0,0,M70/M75/M66)","v":0},{"$f":"IF(N70*N75*N66=0,0,N70/N75/N66)","v":0}]
[null,"Maintenance done on time according to maintenance schedule (%)",{"$nulls":24},"S7: Number of kms per speed violation occurence",{"$f":"IF(C85=0,0,C70/C85)","v":0},{"$f":"IF(D85=0,0,D70/D85)","v":0},{"$f":"IF(E85=0,0,E70/E85)","v":0},{"$f":"IF(F85=0,0,F70/F85)","v":0},{"$f":"IF(G85=0,0,G70/G85)","v":0},{"$f":"IF(H85=0,0,H70/H85)","v":0},{"$f":"IF(I85=0,0,I70/I85)","v":0},{"$f":"IF(J85=0,0,J70/J85)","v":0},{"$f":"IF(K85=0,0,K70/K85)","v":0},{"$f":"IF(L85=0,0,L70/L85)","v":0},{"$f":"IF(M85=0,0,M70/M85)","v":0},{"$f":"IF(N85=0,0,N70/N85)","v":0}]
["Country offices","Total number of country offices (HQ level)",{"$nulls":24},"S8: Number of traffic fines per driver per month",{"$f":"IF(C75=0,0,C84/C75)","v":0},{"$f":"IF(D75=0,0,D84/D75)","v":0},{"$f":"IF(E75=0,0,E84/E75)","v":0},{"$f":"IF(F75=0,0,F84/F75)","v":0},{"$f":"IF(G75=0,0,G84/G75)","v":0},{"$f":"IF(H75=0,0,H84/H75)","v":0},{"$f":"IF(I75=0,0,I84/I75)","v":0},{"$f":"IF(J75=0,0,J84/J75)","v":0},{"$f":"IF(K75=0,0,K84/K75)","v":0},{"$f":"IF(L75=0,0,L84/L75)","v":0},{"$f":"IF(M75=0,0,M84/M75)","v":0},{"$f":"IF(N75=0,0,N84/N75)","v":0}]
[null,"Number of country offices road & safety action plan (HQ level)"]
[]
[]
[null,2016]
[null,null,"January","February","March","April","May","June","July","August","September","October","November","December",2016]
[null,"Reference period (number of months)"]
[null,"Total working days ",{"$nulls":12},{"$f":"SUM(C96:N96)","v":0}]
[]
[2016,"Safety: Driver and passenger safety. Reduction of accidents.  ",{"$nulls":8},"Data Input for KPIs",{"$nulls":21},2016]
[null,null,"January","February","March","April","May","June","July","August","September","October","November","December",2016,{"$nulls":12},"January","February","March","April","May","June","July","August","September","October","November","December"]
["Kilometers","Fleet kilometers driven ",{"$nulls":12},{"$f":"SUM(C100:N100)","v":0},{"$nulls":11},"Safety KPIS1.1           Km/fatal accidents per month",{"$f":"IF(C101=0,0,C100/C101)","v":0},{"$f":"IF(D101=0,0,D100/D101)","v":0},{"$f":"IF(E101=0,0,E100/E101)","v":0},{"$f":"IF(F101=0,0,F100/F101)","v":0},{"$f":"IF(G101=0,0,G100/G101)","v":0},{"$f":"IF(H101=0,0,H100/H101)","v":0},{"$f":"IF(I101=0,0,I100/I101)","v":0},{"$f":"IF(J101=0,0,J100/J101)","v":0},{"$f":"IF(K101=0,0,K100/K101)","v":0},{"$f":"IF(L101=0,0,L100/L101)","v":0},{"$f":"IF(M101=0,0,M100/M101)","v":0},{"$f":"IF(N101=0,0,N100/N101)","v":0}]
["Number of accidents","Number of fatal accidents",{"$nulls":12},{"$f":"SUM(C101:N101)","v":0},{"$nulls":11},"Safety KPIS1.2           Km/injury only accidents per month",{"$f":"IF(C102=0,0,C100/C102)","v":0},{"$f":"IF(D102=0,0,D100/D102)","v":0},{"$f":"IF(E102=0,0,E100/E102)","v":0},{"$f":"IF(F102=0,0,F100/F102)","v":0},{"$f":"IF(G102=0,0,G100/G102)","v":0},{"$f":"IF(H102=0,0,H100/H102)","v":0},{"$f":"IF(I102=0,0,I100/I102)","v":0},{"$f":"IF(J102=0,0,J100/J102)","v":0},{"$f":"IF(K102=0,0,K100/K102)","v":0},{"$f":"IF(L102=0,0,L100/L102)","v":0},{"$f":"IF(M102=0,0,M100/M102)","v":0},{"$f":"IF(N102=0,0,N100/N102)","v":0}]
[null,"Number of injury-only accidents ",{"$nulls":12},{"$f":"SUM(C102:N102)","v":0},{"$nulls":11},"Safety KPIS1.3           Km/damage only accidents per month",{"$f":"IF(C103=0,0,C100/C103)","v":0},{"$f":"IF(D103=0,0,D100/D103)","v":0},{"$f":"IF(E103=0,0,E100/E103)","v":0},{"$f":"IF(F103=0,0,F100/F103)","v":0},{"$f":"IF(G103=0,0,G100/G103)","v":0},{"$f":"IF(H103=0,0,H100/H103)","v":0},{"$f":"IF(I103=0,0,I100/I103)","v":0},{"$f":"IF(J103=0,0,J100/J103)","v":0},{"$f":"IF(K103=0,0,K100/K103)","v":0},{"$f":"IF(L103=0,0,L100/L103)","v":0},{"$f":"IF(M103=0,0,M100/M103)","v":0},{"$f":"IF(N103=0,0,N100/N103)","v":0}]
[null,"Number of damage-only accidents during reference period",{"$nulls":12},{"$f":"SUM(C103:N103)","v":0},{"$nulls":11},"Safety KPIS2.1           Fatal accidents per month",{"$f":"C101","v":0},{"$f":"D101","v":0},{"$f":"E101","v":0},{"$f":"F101","v":0},{"$f":"G101","v":0},{"$f":"H101","v":0},{"$f":"I101","v":0},{"$f":"J101","v":0},{"$f":"K101","v":0},{"$f":"L101","v":0},{"$f":"M101","v":0},{"$f":"N101","v":0}]
[{"$nulls":10},"Data Input for PIs",{"$nulls":15},"Safety KPIS2.2           Injury only accidents per month",{"$f":"C102","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Number of Staff in the reference country","Number of drivers ",{"$nulls":12},{"$f":"IF(O$95=0,0,(C105*O$95+(D105-C105)*(O$95-1)+(E105-D105)*(O$95-2)+(F105-E105)*(O$95-3)+(G105-F105)*(O$95-4)+(H105-G105)*(O$95-5)+(I105-H105)*(O$95-6)+(J105-I105)*(O$95-7)+(K105-J105)*(O$95-8)+(L105-K105)*(O$95-9)+(M105-L105)*(O$95-10)+(N105-M105))/O$95)","v":0},{"$nulls":11},"Safety KPIS2.3           Damage only accidents per month",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Number of management staff  ",{"$nulls":12},0,{"$nulls":11},"Safety KPIS2.4           Total Number of accidents per month",{"$f":"SUM(AB103:AB105)","v":0},{"$f":"SUM(AC103:AC105)","v":0},{"$f":"SUM(AD103:AD105)","v":0},{"$f":"SUM(AE103:AE105)","v":0},{"$f":"SUM(AF103:AF105)","v":0},{"$f":"SUM(AG103:AG105)","v":0},{"$f":"SUM(AH103:AH105)","v":0},{"$f":"SUM(AI103:AI105)","v":0},{"$f":"SUM(AJ103:AJ105)","v":0},{"$f":"SUM(AK103:AK105)","v":0},{"$f":"SUM(AL103:AL105)","v":0},{"$f":"SUM(AM103:AM105)","v":0}]
[null,"Number of rest of the staff ",{"$nulls":12},0]
["Number of trained staff in the reference country","Number of drivers with  road & safety training ",{"$nulls":12},0]
[null,"Number of management staff with road & safety training",{"$nulls":12},0,{"$nulls":11},"S2.1: Staff trained (%) (drivers)",{"$f":"IF(C105=0,0,C108/C105)","v":0},{"$f":"IF(D105=0,0,D108/D105)","v":0},{"$f":"IF(E105=0,0,E108/E105)","v":0},{"$f":"IF(F105=0,0,F108/F105)","v":0},{"$f":"IF(G105=0,0,G108/G105)","v":0},{"$f":"IF(H105=0,0,H108/H105)","v":0},{"$f":"IF(I105=0,0,I108/I105)","v":0},{"$f":"IF(J105=0,0,J108/J105)","v":0},{"$f":"IF(K105=0,0,K108/K105)","v":0},{"$f":"IF(L105=0,0,L108/L105)","v":0},{"$f":"IF(M105=0,0,M108/M105)","v":0},{"$f":"IF(N105=0,0,N108/N105)","v":0}]
[null,"Number of the rest of staff with road & safety training",{"$nulls":12},0,{"$nulls":11},"S2.2: Staff trained (%)  (management)",{"$f":"IF(C106=0,0,C109/C106)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Training hours in  reference period","Number of road and safety taining hours for drivers",{"$nulls":12},{"$f":"SUM(C111:N111)","v":0},{"$nulls":11},"S2.3: Staff trained (%) (rest of staff)",{"$f":"IF(C107=0,0,C110/C107)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Number of road and safety taining hours for management staff",{"$nulls":12},{"$f":"SUM(C112:N112)","v":0},{"$nulls":11},"S3.1: Training hours per driver per month",{"$f":"C111","v":0},{"$f":"D111","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Number of driver training hours for rest of staff",{"$nulls":12},{"$f":"SUM(C113:N113)","v":0},{"$nulls":11},"S3.2: Training hours per management staff per month",{"$f":"C112","v":0},{"$f":"D112","v":0},{"$f":"E112","v":0},{"$f":"F112","v":0},{"$f":"G112","v":0},{"$f":"H112","v":0},{"$f":"I112","v":0},{"$f":"J112","v":0},{"$f":"K112","v":0},{"$f":"L112","v":0},{"$f":"M112","v":0},{"$f":"N112","v":0}]
["Data from data  collection system","Number of traffic fines",{"$nulls":12},{"$f":"SUM(C114:N114)","v":0},{"$nulls":11},"S3.3: Training hours per rest of staff per month",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Number of speed violation occurences",{"$nulls":12},{"$f":"IF(SUM(C$105:N$105)=0,0,(C115*C$105+D115*D$105+E115*E$105+F115*F$105+G115*G$105+H115*H$105+I115*I$105+J115*J$105+K115*K$105+L115*L$105+M115*M$105+N115*N$105)/SUM(C$105:N$105))","v":0},{"$nulls":11},"S4: Average working hours per driver per day",{"$f":"C116","v":0},{"$f":"D116","v":0},{"$f":"E116","v":0},{"$f":"F116","v":0},{"$f":"G116","v":0},{"$f":"H116","v":0},{"$f":"I116","v":0},{"$f":"J116","v":0},{"$f":"K116","v":0},{"$f":"L116","v":0},{"$f":"M116","v":0},{"$f":"N116","v":0}]
[null,"Average working hours per driver per day",{"$nulls":12},{"$f":"IF(SUM(C$105:N$105)=0,0,(C116*C$105+D116*D$105+E116*E$105+F116*F$105+G116*G$105+H116*H$105+I116*I$105+J116*J$105+K116*K$105+L116*L$105+M116*M$105+N116*N$105)/SUM(C$105:N$105))","v":0},{"$nulls":11},"S5: Average night driving hours per driver per day ",{"$f":"C117","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Average night driving hours per driver per day ",{"$nulls":12},{"$f":"IF(SUM(C$105:N$105)=0,0,(C117*C$105+D117*D$105+E117*E$105+F117*F$105+G117*G$105+H117*H$105+I117*I$105+J117*J$105+K117*K$105+L117*L$105+M117*M$105+N117*N$105)/SUM(C$105:N$105))","v":0},{"$nulls":11},"S6: Average kilometers per driver per day ",{"$f":"IF(C100*C105*C96=0,0,C100/C105/C96)","v":0},{"$f":"IF(D100*D105*D96=0,0,D100/D105/D96)","v":0},{"$f":"IF(E100*E105*E96=0,0,E100/E105/E96)","v":0},{"$f":"IF(F100*F105*F96=0,0,F100/F105/F96)","v":0},{"$f":"IF(G100*G105*G96=0,0,G100/G105/G96)","v":0},{"$f":"IF(H100*H105*H96=0,0,H100/H105/H96)","v":0},{"$f":"IF(I100*I105*I96=0,0,I100/I105/I96)","v":0},{"$f":"IF(J100*J105*J96=0,0,J100/J105/J96)","v":0},{"$f":"IF(K100*K105*K96=0,0,K100/K105/K96)","v":0},{"$f":"IF(L100*L105*L96=0,0,L100/L105/L96)","v":0},{"$f":"IF(M100*M105*M96=0,0,M100/M105/M96)","v":0},{"$f":"IF(N100*N105*N96=0,0,N100/N105/N96)","v":0}]
[null,"Maintenance done on time according to maintenance schedule (%)",{"$nulls":24},"S7: Number of kms per speed violation occurence",{"$f":"IF(C115=0,0,C100/C115)","v":0},{"$f":"IF(D115=0,0,D100/D115)","v":0},{"$f":"IF(E115=0,0,E100/E115)","v":0},{"$f":"IF(F115=0,0,F100/F115)","v":0},{"$f":"IF(G115=0,0,G100/G115)","v":0},{"$f":"IF(H115=0,0,H100/H115)","v":0},{"$f":"IF(I115=0,0,I100/I115)","v":0},{"$f":"IF(J115=0,0,J100/J115)","v":0},{"$f":"IF(K115=0,0,K100/K115)","v":0},{"$f":"IF(L115=0,0,L100/L115)","v":0},{"$f":"IF(M115=0,0,M100/M115)","v":0},{"$f":"IF(N115=0,0,N100/N115)","v":0}]
["Country offices","Total number of country offices (HQ level)",{"$nulls":24},"S8: Number of traffic fines per driver per month",{"$f":"IF(C105=0,0,C114/C105)","v":0},{"$f":"IF(D105=0,0,D114/D105)","v":0},{"$f":"IF(E105=0,0,E114/E105)","v":0},{"$f":"IF(F105=0,0,F114/F105)","v":0},{"$f":"IF(G105=0,0,G114/G105)","v":0},{"$f":"IF(H105=0,0,H114/H105)","v":0},{"$f":"IF(I105=0,0,I114/I105)","v":0},{"$f":"IF(J105=0,0,J114/J105)","v":0},{"$f":"IF(K105=0,0,K114/K105)","v":0},{"$f":"IF(L105=0,0,L114/L105)","v":0},{"$f":"IF(M105=0,0,M114/M105)","v":0},{"$f":"IF(N105=0,0,N114/N105)","v":0}]
[null,"Number of country offices road & safety action plan (HQ level)"]

{"sheet":"Environment","index":1,"n_rows":67,"n_cols":40,"rows_kept":67,"merged":[[1,2,1,14],[2,10,2,14],[4,0,5,0],[6,10,6,14],[7,0,15,0],[10,2,11,13],[18,2,18,14],[19,10,19,14],[21,0,22,0],[23,10,23,14],[24,0,32,0],[27,2,28,13],[35,2,35,14],[36,10,36,14],[38,0,39,0],[40,10,40,14],[41,0,49,0],[44,2,45,13],[52,2,52,14],[53,10,53,14],[55,0,56,0],[57,10,57,14],[58,0,66,0],[61,2,62,13]]}
[]
[null,null,2013]
[2013,"Environmental impact : Reduction of GHG emissions. ",{"$nulls":8},"Data Input for KPIs",{"$nulls":8},"Comments",null,null,"KPI",{"$nulls":10},2013]
[null,"Calculation of CO2 emissions by fuel records","January","February","March","April","May","June","July","August","September","October","November","December","Total ",2014,2015,2016,"kgCO2/lt",{"$nulls":3},2013,2014,2015,2016,null,null,"January","February","March","April","May","June","July","August","September","October","November","December"]
["Fuel Data","Fuel consuption of vehicles using gasoline (lt)",{"$nulls":12},{"$f":"SUM(C5:N5)","v":0},{"$f":"O22","v":0},{"$f":"O39","v":0},{"$f":"O56","v":0},2.3822,null,"Environmental KPIen   gasoline vehicles   g CO2/km driven",null,{"$f":"IF(O8=0,0,1000*$S$5*O5/O8)","v":0},{"$f":"IF(P8=0,0,1000*$S$5*P5/P8)","v":0},{"$f":"IF(Q8=0,0,1000*$S$5*Q5/Q8)","v":0},{"$f":"IF(R8=0,0,1000*$S$5*R5/R8)","v":0},null,"Environmental KPIen   gasoline vehicles   g CO2/km driven",{"$f":"IF(C8=0,0,1000*$S$5*C5/C8)","v":0},{"$f":"IF(D8=0,0,1000*$S$5*D5/D8)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Fuel consumption of vehicles using diesel (lt)",{"$nulls":12},{"$f":"SUM(C6:N6)","v":0},0,0,0,{"v":2.74577,"d":"2.7458"},null,"Environmental KPIen   diesel vehicles   g CO2/km driven",null,{"$f":"IF(O9=0,0,1000*$S$6*O6/O9)","v":0},{"$f":"IF(P9=0,0,1000*$S$6*P6/P9)","v":0},{"$f":"IF(Q9=0,0,1000*$S$6*Q6/Q9)","v":0},{"$f":"IF(R9=0,0,1000*$S$6*R6/R9)","v":0},null,"Environmental KPIen   diesel vehicles   g CO2/km driven",{"$f":"IF(C9=0,0,1000*$S$6*C6/C9)","v":0},{"$f":"IF(D9=0,0,1000*$S$6*D6/D9)","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":10},"Data Input for PIs",{"$nulls":4},0,0,0,null,null,"Environmental KPIen   all vehicles   g CO2/km driven",null,{"$f":"IF(SUM(O8:O10)=0,0,1000*($S$5*O5+$S$6*O6)/SUM(O8:O10))","v":0},{"$f":"IF(SUM(P8:P10)=0,0,1000*($S$5*P5+$S$6*P6)/SUM(P8:P10))","v":0},{"$f":"IF(SUM(Q8:Q10)=0,0,1000*($S$5*Q5+$S$6*Q6)/SUM(Q8:Q10))","v":0},{"$f":"IF(SUM(R8:R10)=0,0,1000*($S$5*R5+$S$6*R6)/SUM(R8:R10))","v":0},null,"Environmental KPIen   all vehicles   g CO2/km driven",{"$f":"IF(SUM(C8:C10)=0,0,1000*($S$5*C5+$S$6*C6)/SUM(C8:C10))","v":0},{"$f":"IF(SUM(D8:D10)=0,0,1000*($S$5*D5+$S$6*D6)/SUM(D8:D10))","v":0},0,0,0,0,0,0,0,0,0,0]
["Vehicle Data","Total km of vehicles using gasoline in the reference period",{"$nulls":12},{"$f":"SUM(C8:N8)","v":0},0,0,0,{"$nulls":4},"PIs"]
[null,"Total km of vehicles using diesel in the reference period",{"$nulls":12},{"$f":"SUM(C9:N9)","v":0},0,0,0,null,null,"En1.1: Gasoline consumption per 100 Kilometers per vehicle(lt/100km)",null,{"$f":"IF(O8=0,0,100*O5/O8)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"En1.1: Gasoline consumption per 100 Kilometers per vehicle(lt/100km)",{"$f":"IF(C8=0,0,100*C5/C8)","v":0},{"$f":"IF(D8=0,0,100*D5/D8)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Total km of electric vehicles",{"$nulls":12},{"$f":"SUM(C10:N10)","v":0},0,0,0,null,null,"En1.2: Diesel consumption per 100 Kilometers per vehicle(lt/100km)",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"En1.2: Diesel consumption per 100 Kilometers per vehicle(lt/100km)",{"$f":"IF(C9=0,0,100*C6/C9)","v":0},{"$f":"IF(D9=0,0,100*D6/D9)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Average age per vehicle (years) ",{"$nulls":13},0,0,0,null,null,"En2: Average age per vehicle (years) ",null,{"$f":"O11","v":0},0,0,0]
[null,"Average mileage per vehicle (km) ",{"$nulls":13},0,0,0,null,null,"En3: Average mileage per vehicle (km) ",null,0,0,0,0]
[null,"Number of vehicles",{"$nulls":12},{"$f":"IF(Safety!O$5=0,0,(C13*Safety!O$5+(D13-C13)*(Safety!O$5-1)+(E13-D13)*(Safety!O$5-2)+(F13-E13)*(Safety!O$5-3)+(G13-F13)*(Safety!O$5-4)+(H13-G13)*(Safety!O$5-5)+(I13-H13)*(Safety!O$5-6)+(J13-I13)*(Safety!O$5-7)+(K13-J13)*(Safety!O$5-8)+(L13-K13)*(Safety!O$5-9)+(M13-L13)*(Safety!O$5-10)+(N13-M13))/Safety!O$5)","v":0},{"$f":"O30","v":0},{"$f":"O47","v":0},{"$f":"O64","v":0},null,null,"En4: % of green vehicles (Euro 5 and Euro 6) used in field ",null,{"$f":"IF(O$13=0,0,O14/O$13)","v":{"v":0,"d":"0%"}},{"$f":"IF(P$13=0,0,P14/P$13)","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,"En4: % of green vehicles (Euro 5 and Euro 6) used in field ",{"$f":"IF(C$13=0,0,C14/C$13)","v":0},{"$f":"IF(D$13=0,0,D14/D$13)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Number of green vehicles (Euro 5 and Euro 6) ",{"$nulls":12},{"$f":"IF(Safety!O$5=0,0,(C14*Safety!O$5+(D14-C14)*(Safety!O$5-1)+(E14-D14)*(Safety!O$5-2)+(F14-E14)*(Safety!O$5-3)+(G14-F14)*(Safety!O$5-4)+(H14-G14)*(Safety!O$5-5)+(I14-H14)*(Safety!O$5-6)+(J14-I14)*(Safety!O$5-7)+(K14-J14)*(Safety!O$5-8)+(L14-K14)*(Safety!O$5-9)+(M14-L14)*(Safety!O$5-10)+(N14-M14))/Safety!O$5)","v":0},{"$f":"O31","v":0},{"$f":"O48","v":0},{"$f":"O65","v":0},null,null,"En5: % of green city vehicles (hybrids, electric cars) ",null,{"$f":"IF(O$13=0,0,O15/O$13)","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,"En5: % of green city vehicles (hybrids, electric cars) ",{"$f":"IF(C$13=0,0,C15/C$13)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Number of green city vehicles (hybrids, electric cars) ",{"$nulls":12},{"$f":"IF(Safety!O$5=0,0,(C15*Safety!O$5+(D15-C15)*(Safety!O$5-1)+(E15-D15)*(Safety!O$5-2)+(F15-E15)*(Safety!O$5-3)+(G15-F15)*(Safety!O$5-4)+(H15-G15)*(Safety!O$5-5)+(I15-H15)*(Safety!O$5-6)+(J15-I15)*(Safety!O$5-7)+(K15-J15)*(Safety!O$5-8)+(L15-K15)*(Safety!O$5-9)+(M15-L15)*(Safety!O$5-10)+(N15-M15))/Safety!O$5)","v":0},{"$f":"O32","v":0},{"$f":"O49","v":0},{"$f":"O66","v":0},null,null,"En6: % of 4-stroke motorbikes ",null,{"$f":"IF(O$13=0,0,O16/O$13)","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,"En6: % of 4-stroke motorbikes ",{"$f":"IF(C$13=0,0,C16/C$13)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Number of 4-stroke motorbikes ",{"$nulls":12},{"$f":"IF(Safety!O$5=0,0,(C16*Safety!O$5+(D16-C16)*(Safety!O$5-1)+(E16-D16)*(Safety!O$5-2)+(F16-E16)*(Safety!O$5-3)+(G16-F16)*(Safety!O$5-4)+(H16-G16)*(Safety!O$5-5)+(I16-H16)*(Safety!O$5-6)+(J16-I16)*(Safety!O$5-7)+(K16-J16)*(Safety!O$5-8)+(L16-K16)*(Safety!O$5-9)+(M16-L16)*(Safety!O$5-10)+(N16-M16))/Safety!O$5)","v":0},{"$f":"O33","v":0},{"$f":"O50","v":0},{"$f":"O67","v":0},null,null,"En7: % of drivers trained ",null,{"$f":"Safety!U19","v":{"v":0,"d":"0%"}},{"$f":"Safety!V19","v":{"v":0,"d":"0%"}},{"$f":"Safety!W19","v":{"v":0,"d":"0%"}},{"$f":"Safety!X19","v":{"v":0,"d":"0%"}}]
[{"$nulls":20},"En8: Training hours per driver per year",null,{"$f":"Safety!U22","v":0},{"$f":"Safety!V22","v":0},{"$f":"Safety!W22","v":0},{"$f":"Safety!X22","v":0}]
[{"$nulls":20},"En9: Number of kms per speed violation occurrences",null,{"$f":"Safety!U28","v":"GOOD JOB!"},{"$f":"Safety!V28","v":"GOOD JOB!"},{"$f":"Safety!W28","v":"GOOD JOB!"},{"$f":"Safety!X28","v":"GOOD JOB!"}]
[null,null,2014,{"$nulls":17},"En10: Maintenance done on time according to maintenance schedule (%) ",null,{"$f":"Safety!O28","v":{"v":0,"d":"0%"}},{"$f":"Safety!P28","v":{"v":0,"d":"0%"}},{"$f":"Safety!Q28","v":{"v":0,"d":"0%"}},{"$f":"Safety!R28","v":{"v":0,"d":"0%"}}]
[2014,"Environmental impact : Reduction of GHG emissions. ",{"$nulls":8},"Data Input for KPIs",{"$nulls":22},2014]
[null,"Calculation of CO2 emissions by fuel records","January","February","March","April","May","June","July","August","September","October","November","December","Total ",{"$nulls":13},"January","February","March","April","May","June","July","August","September","October","November","December"]
["Fuel Data","Fuel consuption of vehicles using gasoline (lt)",{"$nulls":12},{"$f":"SUM(C22:N22)","v":0},{"$nulls":12},"Environmental KPIen   gasoline vehicles   g CO2/km driven",{"$f":"IF(C25=0,0,1000*$S$5*C22/C25)","v":0},{"$f":"IF(D25=0,0,1000*$S$5*D22/D25)","v":0},{"$f":"IF(E25=0,0,1000*$S$5*E22/E25)","v":0},{"$f":"IF(F25=0,0,1000*$S$5*F22/F25)","v":0},{"$f":"IF(G25=0,0,1000*$S$5*G22/G25)","v":0},{"$f":"IF(H25=0,0,1000*$S$5*H22/H25)","v":0},{"$f":"IF(I25=0,0,1000*$S$5*I22/I25)","v":0},{"$f":"IF(J25=0,0,1000*$S$5*J22/J25)","v":0},{"$f":"IF(K25=0,0,1000*$S$5*K22/K25)","v":0},{"$f":"IF(L25=0,0,1000*$S$5*L22/L25)","v":0},{"$f":"IF(M25=0,0,1000*$S$5*M22/M25)","v":0},{"$f":"IF(N25=0,0,1000*$S$5*N22/N25)","v":0}]
[null,"Fuel consumption of vehicles using diesel (lt)",{"$nulls":12},{"$f":"SUM(C23:N23)","v":0},{"$nulls":12},"Environmental KPIen   diesel vehicles   g CO2/km driven",{"$f":"IF(C26=0,0,1000*$S$6*C23/C26)","v":0},{"$f":"IF(D26=0,0,1000*$S$6*D23/D26)","v":0},{"$f":"IF(E26=0,0,1000*$S$6*E23/E26)","v":0},{"$f":"IF(F26=0,0,1000*$S$6*F23/F26)","v":0},{"$f":"IF(G26=0,0,1000*$S$6*G23/G26)","v":0},{"$f":"IF(H26=0,0,1000*$S$6*H23/H26)","v":0},{"$f":"IF(I26=0,0,1000*$S$6*I23/I26)","v":0},{"$f":"IF(J26=0,0,1000*$S$6*J23/J26)","v":0},{"$f":"IF(K26=0,0,1000*$S$6*K23/K26)","v":0},{"$f":"IF(L26=0,0,1000*$S$6*L23/L26)","v":0},{"$f":"IF(M26=0,0,1000*$S$6*M23/M26)","v":0},{"$f":"IF(N26=0,0,1000*$S$6*N23/N26)","v":0}]
[{"$nulls":10},"Data Input for PIs",{"$nulls":16},"Environmental KPIen   all vehicles   g CO2/km driven",{"$f":"IF(SUM(C25:C27)=0,0,1000*($S$5*C22+$S$6*C23)/SUM(C25:C27))","v":0},{"$f":"IF(SUM(D25:D27)=0,0,1000*($S$5*D22+$S$6*D23)/SUM(D25:D27))","v":0},{"$f":"IF(SUM(E25:E27)=0,0,1000*($S$5*E22+$S$6*E23)/SUM(E25:E27))","v":0},{"$f":"IF(SUM(F25:F27)=0,0,1000*($S$5*F22+$S$6*F23)/SUM(F25:F27))","v":0},{"$f":"IF(SUM(G25:G27)=0,0,1000*($S$5*G22+$S$6*G23)/SUM(G25:G27))","v":0},{"$f":"IF(SUM(H25:H27)=0,0,1000*($S$5*H22+$S$6*H23)/SUM(H25:H27))","v":0},{"$f":"IF(SUM(I25:I27)=0,0,1000*($S$5*I22+$S$6*I23)/SUM(I25:I27))","v":0},{"$f":"IF(SUM(J25:J27)=0,0,1000*($S$5*J22+$S$6*J23)/SUM(J25:J27))","v":0},{"$f":"IF(SUM(K25:K27)=0,0,1000*($S$5*K22+$S$6*K23)/SUM(K25:K27))","v":0},{"$f":"IF(SUM(L25:L27)=0,0,1000*($S$5*L22+$S$6*L23)/SUM(L25:L27))","v":0},{"$f":"IF(SUM(M25:M27)=0,0,1000*($S$5*M22+$S$6*M23)/SUM(M25:M27))","v":0},{"$f":"IF(SUM(N25:N27)=0,0,1000*($S$5*N22+$S$6*N23)/SUM(N25:N27))","v":0}]
["Vehicle Data","Total km of vehicles using gasoline in the reference period",{"$nulls":12},{"$f":"SUM(C25:N25)","v":0}]
[null,"Total km of vehicles using diesel in the reference period",{"$nulls":12},{"$f":"SUM(C26:N26)","v":0},{"$nulls":12},"En1.1: Gasoline consumption per 100 Kilometers per vehicle(lt/100km)",{"$f":"IF(C25=0,0,100*C22/C25)","v":0},{"$f":"IF(D25=0,0,100*D22/D25)","v":0},{"$f":"IF(E25=0,0,100*E22/E25)","v":0},{"$f":"IF(F25=0,0,100*F22/F25)","v":0},{"$f":"IF(G25=0,0,100*G22/G25)","v":0},{"$f":"IF(H25=0,0,100*H22/H25)","v":0},{"$f":"IF(I25=0,0,100*I22/I25)","v":0},{"$f":"IF(J25=0,0,100*J22/J25)","v":0},{"$f":"IF(K25=0,0,100*K22/K25)","v":0},{"$f":"IF(L25=0,0,100*L22/L25)","v":0},{"$f":"IF(M25=0,0,100*M22/M25)","v":0},{"$f":"IF(N25=0,0,100*N22/N25)","v":0}]
[null,"Total km of electric vehicles",{"$nulls":12},{"$f":"SUM(C27:N27)","v":0},{"$nulls":12},"En1.2: Diesel consumption per 100 Kilometers per vehicle(lt/100km)",{"$f":"IF(C26=0,0,100*C23/C26)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Average age per vehicle (years) "]
[null,"Average mileage per vehicle (km) "]
[null,"Number of vehicles",{"$nulls":12},{"$f":"IF(Safety!O$35=0,0,(C30*Safety!O$35+(D30-C30)*(Safety!O$35-1)+(E30-D30)*(Safety!O$35-2)+(F30-E30)*(Safety!O$35-3)+(G30-F30)*(Safety!O$35-4)+(H30-G30)*(Safety!O$35-5)+(I30-H30)*(Safety!O$35-6)+(J30-I30)*(Safety!O$35-7)+(K30-J30)*(Safety!O$35-8)+(L30-K30)*(Safety!O$35-9)+(M30-L30)*(Safety!O$35-10)+(N30-M30))/Safety!O$35)","v":0},{"$nulls":12},"En4: % of green vehicles (Euro 5 and Euro 6) used in field ",{"$f":"IF(C$30=0,0,C31/C$30)","v":0},{"$f":"IF(D$30=0,0,D31/D$30)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Number of green vehicles (Euro 5 and Euro 6) ",{"$nulls":12},{"$f":"IF(Safety!O$35=0,0,(C31*Safety!O$35+(D31-C31)*(Safety!O$35-1)+(E31-D31)*(Safety!O$35-2)+(F31-E31)*(Safety!O$35-3)+(G31-F31)*(Safety!O$35-4)+(H31-G31)*(Safety!O$35-5)+(I31-H31)*(Safety!O$35-6)+(J31-I31)*(Safety!O$35-7)+(K31-J31)*(Safety!O$35-8)+(L31-K31)*(Safety!O$35-9)+(M31-L31)*(Safety!O$35-10)+(N31-M31))/Safety!O$35)","v":0},{"$nulls":12},"En5: % of green city vehicles (hybrids, electric cars) ",{"$f":"IF(C$30=0,0,C32/C$30)","v":0},{"$f":"IF(D$30=0,0,D32/D$30)","v":0},{"$f":"IF(E$30=0,0,E32/E$30)","v":0},{"$f":"IF(F$30=0,0,F32/F$30)","v":0},{"$f":"IF(G$30=0,0,G32/G$30)","v":0},{"$f":"IF(H$30=0,0,H32/H$30)","v":0},{"$f":"IF(I$30=0,0,I32/I$30)","v":0},{"$f":"IF(J$30=0,0,J32/J$30)","v":0},{"$f":"IF(K$30=0,0,K32/K$30)","v":0},{"$f":"IF(L$30=0,0,L32/L$30)","v":0},{"$f":"IF(M$30=0,0,M32/M$30)","v":0},{"$f":"IF(N$30=0,0,N32/N$30)","v":0}]
[null,"Number of green city vehicles (hybrids, electric cars) ",{"$nulls":12},{"$f":"IF(Safety!O$35=0,0,(C32*Safety!O$35+(D32-C32)*(Safety!O$35-1)+(E32-D32)*(Safety!O$35-2)+(F32-E32)*(Safety!O$35-3)+(G32-F32)*(Safety!O$35-4)+(H32-G32)*(Safety!O$35-5)+(I32-H32)*(Safety!O$35-6)+(J32-I32)*(Safety!O$35-7)+(K32-J32)*(Safety!O$35-8)+(L32-K32)*(Safety!O$35-9)+(M32-L32)*(Safety!O$35-10)+(N32-M32))/Safety!O$35)","v":0},{"$nulls":12},"En6: % of 4-stroke motorbikes ",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Number of 4-stroke motorbikes ",{"$nulls":12},{"$f":"IF(Safety!O$35=0,0,(C33*Safety!O$35+(D33-C33)*(Safety!O$35-1)+(E33-D33)*(Safety!O$35-2)+(F33-E33)*(Safety!O$35-3)+(G33-F33)*(Safety!O$35-4)+(H33-G33)*(Safety!O$35-5)+(I33-H33)*(Safety!O$35-6)+(J33-I33)*(Safety!O$35-7)+(K33-J33)*(Safety!O$35-8)+(L33-K33)*(Safety!O$35-9)+(M33-L33)*(Safety!O$35-10)+(N33-M33))/Safety!O$35)","v":0}]
[]
[]
[null,null,2015]
[2015,"Environmental impact : Reduction of GHG emissions. ",{"$nulls":8},"Data Input for KPIs",{"$nulls":22},2015]
[null,"Calculation of CO2 emissions by fuel records","January","February","March","April","May","June","July","August","September","October","November","December","Total ",{"$nulls":13},"January","February","March","April","May","June","July","August","September","October","November","December"]
["Fuel Data","Fuel consuption of vehicles using gasoline (lt)",{"$nulls":12},{"$f":"SUM(C39:N39)","v":0},{"$nulls":12},"Environmental KPIen   gasoline vehicles   g CO2/km driven",{"$f":"IF(C42=0,0,1000*$S$5*C39/C42)","v":0},{"$f":"IF(D42=0,0,1000*$S$5*D39/D42)","v":0},{"$f":"IF(E42=0,0,1000*$S$5*E39/E42)","v":0},{"$f":"IF(F42=0,0,1000*$S$5*F39/F42)","v":0},{"$f":"IF(G42=0,0,1000*$S$5*G39/G42)","v":0},{"$f":"IF(H42=0,0,1000*$S$5*H39/H42)","v":0},{"$f":"IF(I42=0,0,1000*$S$5*I39/I42)","v":0},{"$f":"IF(J42=0,0,1000*$S$5*J39/J42)","v":0},{"$f":"IF(K42=0,0,1000*$S$5*K39/K42)","v":0},{"$f":"IF(L42=0,0,1000*$S$5*L39/L42)","v":0},{"$f":"IF(M42=0,0,1000*$S$5*M39/M42)","v":0},{"$f":"IF(N42=0,0,1000*$S$5*N39/N42)","v":0}]
[null,"Fuel consumption of vehicles using diesel (lt)",{"$nulls":12},{"$f":"SUM(C40:N40)","v":0},{"$nulls":12},"Environmental KPIen   diesel vehicles   g CO2/km driven",{"$f":"IF(C43=0,0,1000*$S$6*C40/C43)","v":0},{"$f":"IF(D43=0,0,1000*$S$6*D40/D43)","v":0},{"$f":"IF(E43=0,0,1000*$S$6*E40/E43)","v":0},{"$f":"IF(F43=0,0,1000*$S$6*F40/F43)","v":0},{"$f":"IF(G43=0,0,1000*$S$6*G40/G43)","v":0},{"$f":"IF(H43=0,0,1000*$S$6*H40/H43)","v":0},{"$f":"IF(I43=0,0,1000*$S$6*I40/I43)","v":0},{"$f":"IF(J43=0,0,1000*$S$6*J40/J43)","v":0},{"$f":"IF(K43=0,0,1000*$S$6*K40/K43)","v":0},{"$f":"IF(L43=0,0,1000*$S$6*L40/L43)","v":0},{"$f":"IF(M43=0,0,1000*$S$6*M40/M43)","v":0},{"$f":"IF(N43=0,0,1000*$S$6*N40/N43)","v":0}]
[{"$nulls":10},"Data Input for PIs",{"$nulls":16},"Environmental KPIen   all vehicles   g CO2/km driven",{"$f":"IF(SUM(C42:C44)=0,0,1000*($S$5*C39+$S$6*C40)/SUM(C42:C44))","v":0},{"$f":"IF(SUM(D42:D44)=0,0,1000*($S$5*D39+$S$6*D40)/SUM(D42:D44))","v":0},{"$f":"IF(SUM(E42:E44)=0,0,1000*($S$5*E39+$S$6*E40)/SUM(E42:E44))","v":0},{"$f":"IF(SUM(F42:F44)=0,0,1000*($S$5*F39+$S$6*F40)/SUM(F42:F44))","v":0},{"$f":"IF(SUM(G42:G44)=0,0,1000*($S$5*G39+$S$6*G40)/SUM(G42:G44))","v":0},{"$f":"IF(SUM(H42:H44)=0,0,1000*($S$5*H39+$S$6*H40)/SUM(H42:H44))","v":0},{"$f":"IF(SUM(I42:I44)=0,0,1000*($S$5*I39+$S$6*I40)/SUM(I42:I44))","v":0},{"$f":"IF(SUM(J42:J44)=0,0,1000*($S$5*J39+$S$6*J40)/SUM(J42:J44))","v":0},{"$f":"IF(SUM(K42:K44)=0,0,1000*($S$5*K39+$S$6*K40)/SUM(K42:K44))","v":0},{"$f":"IF(SUM(L42:L44)=0,0,1000*($S$5*L39+$S$6*L40)/SUM(L42:L44))","v":0},{"$f":"IF(SUM(M42:M44)=0,0,1000*($S$5*M39+$S$6*M40)/SUM(M42:M44))","v":0},{"$f":"IF(SUM(N42:N44)=0,0,1000*($S$5*N39+$S$6*N40)/SUM(N42:N44))","v":0}]
["Vehicle Data","Total km of vehicles using gasoline in the reference period",{"$nulls":12},{"$f":"SUM(C42:N42)","v":0}]
[null,"Total km of vehicles using diesel in the reference period",{"$nulls":12},{"$f":"SUM(C43:N43)","v":0},{"$nulls":12},"En1.1: Gasoline consumption per 100 Kilometers per vehicle(lt/100km)",{"$f":"IF(C42=0,0,100*C39/C42)","v":0},{"$f":"IF(D42=0,0,100*D39/D42)","v":0},{"$f":"IF(E42=0,0,100*E39/E42)","v":0},{"$f":"IF(F42=0,0,100*F39/F42)","v":0},{"$f":"IF(G42=0,0,100*G39/G42)","v":0},{"$f":"IF(H42=0,0,100*H39/H42)","v":0},{"$f":"IF(I42=0,0,100*I39/I42)","v":0},{"$f":"IF(J42=0,0,100*J39/J42)","v":0},{"$f":"IF(K42=0,0,100*K39/K42)","v":0},{"$f":"IF(L42=0,0,100*L39/L42)","v":0},{"$f":"IF(M42=0,0,100*M39/M42)","v":0},{"$f":"IF(N42=0,0,100*N39/N42)","v":0}]
[null,"Total km of electric vehicles",{"$nulls":12},{"$f":"SUM(C44:N44)","v":0},{"$nulls":12},"En1.2: Diesel consumption per 100 Kilometers per vehicle(lt/100km)",{"$f":"IF(C43=0,0,100*C40/C43)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Average age per vehicle (years) "]
[null,"Average mileage per vehicle (km) "]
[null,"Number of vehicles",{"$nulls":12},{"$f":"IF(Safety!O$65=0,0,(C47*Safety!O$65+(D47-C47)*(Safety!O$65-1)+(E47-D47)*(Safety!O$65-2)+(F47-E47)*(Safety!O$65-3)+(G47-F47)*(Safety!O$65-4)+(H47-G47)*(Safety!O$65-5)+(I47-H47)*(Safety!O$65-6)+(J47-I47)*(Safety!O$65-7)+(K47-J47)*(Safety!O$65-8)+(L47-K47)*(Safety!O$65-9)+(M47-L47)*(Safety!O$65-10)+(N47-M47))/Safety!O$65)","v":0},{"$nulls":12},"En4: % of green vehicles (Euro 5 and Euro 6) used in field ",{"$f":"IF(C$47=0,0,C48/C$13)","v":0},{"$f":"IF(D$47=0,0,D48/D$13)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Number of green vehicles (Euro 5 and Euro 6) ",{"$nulls":12},{"$f":"IF(Safety!O$65=0,0,(C48*Safety!O$65+(D48-C48)*(Safety!O$65-1)+(E48-D48)*(Safety!O$65-2)+(F48-E48)*(Safety!O$65-3)+(G48-F48)*(Safety!O$65-4)+(H48-G48)*(Safety!O$65-5)+(I48-H48)*(Safety!O$65-6)+(J48-I48)*(Safety!O$65-7)+(K48-J48)*(Safety!O$65-8)+(L48-K48)*(Safety!O$65-9)+(M48-L48)*(Safety!O$65-10)+(N48-M48))/Safety!O$65)","v":0},{"$nulls":12},"En5: % of green city vehicles (hybrids, electric cars) ",{"$f":"IF(C$47=0,0,C49/C$13)","v":0},{"$f":"IF(D$47=0,0,D49/D$13)","v":0},{"$f":"IF(E$47=0,0,E49/E$13)","v":0},{"$f":"IF(F$47=0,0,F49/F$13)","v":0},{"$f":"IF(G$47=0,0,G49/G$13)","v":0},{"$f":"IF(H$47=0,0,H49/H$13)","v":0},{"$f":"IF(I$47=0,0,I49/I$13)","v":0},{"$f":"IF(J$47=0,0,J49/J$13)","v":0},{"$f":"IF(K$47=0,0,K49/K$13)","v":0},{"$f":"IF(L$47=0,0,L49/L$13)","v":0},{"$f":"IF(M$47=0,0,M49/M$13)","v":0},{"$f":"IF(N$47=0,0,N49/N$13)","v":0}]
[null,"Number of green city vehicles (hybrids, electric cars) ",{"$nulls":12},{"$f":"IF(Safety!O$65=0,0,(C49*Safety!O$65+(D49-C49)*(Safety!O$65-1)+(E49-D49)*(Safety!O$65-2)+(F49-E49)*(Safety!O$65-3)+(G49-F49)*(Safety!O$65-4)+(H49-G49)*(Safety!O$65-5)+(I49-H49)*(Safety!O$65-6)+(J49-I49)*(Safety!O$65-7)+(K49-J49)*(Safety!O$65-8)+(L49-K49)*(Safety!O$65-9)+(M49-L49)*(Safety!O$65-10)+(N49-M49))/Safety!O$65)","v":0},{"$nulls":12},"En6: % of 4-stroke motorbikes ",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Number of 4-stroke motorbikes ",{"$nulls":12},{"$f":"IF(Safety!O$65=0,0,(C50*Safety!O$65+(D50-C50)*(Safety!O$65-1)+(E50-D50)*(Safety!O$65-2)+(F50-E50)*(Safety!O$65-3)+(G50-F50)*(Safety!O$65-4)+(H50-G50)*(Safety!O$65-5)+(I50-H50)*(Safety!O$65-6)+(J50-I50)*(Safety!O$65-7)+(K50-J50)*(Safety!O$65-8)+(L50-K50)*(Safety!O$65-9)+(M50-L50)*(Safety!O$65-10)+(N50-M50))/Safety!O$65)","v":0}]
[]
[]
[null,null,2016]
[2016,"Environmental impact : Reduction of GHG emissions. ",{"$nulls":8},"Data Input for KPIs",{"$nulls":22},2016]
[null,"Calculation of CO2 emissions by fuel records","January","February","March","April","May","June","July","August","September","October","November","December","Total ",{"$nulls":13},"January","February","March","April","May","June","July","August","September","October","November","December"]
["Fuel Data","Fuel consuption of vehicles using gasoline (lt)",{"$nulls":12},{"$f":"SUM(C56:N56)","v":0},{"$nulls":12},"Environmental KPIen   gasoline vehicles   g CO2/km driven",{"$f":"IF(C59=0,0,1000*$S$5*C56/C59)","v":0},{"$f":"IF(D59=0,0,1000*$S$5*D56/D59)","v":0},{"$f":"IF(E59=0,0,1000*$S$5*E56/E59)","v":0},{"$f":"IF(F59=0,0,1000*$S$5*F56/F59)","v":0},{"$f":"IF(G59=0,0,1000*$S$5*G56/G59)","v":0},{"$f":"IF(H59=0,0,1000*$S$5*H56/H59)","v":0},{"$f":"IF(I59=0,0,1000*$S$5*I56/I59)","v":0},{"$f":"IF(J59=0,0,1000*$S$5*J56/J59)","v":0},{"$f":"IF(K59=0,0,1000*$S$5*K56/K59)","v":0},{"$f":"IF(L59=0,0,1000*$S$5*L56/L59)","v":0},{"$f":"IF(M59=0,0,1000*$S$5*M56/M59)","v":0},{"$f":"IF(N59=0,0,1000*$S$5*N56/N59)","v":0}]
[null,"Fuel consumption of vehicles using diesel (lt)",{"$nulls":12},{"$f":"SUM(C57:N57)","v":0},{"$nulls":12},"Environmental KPIen   diesel vehicles   g CO2/km driven",{"$f":"IF(C60=0,0,1000*$S$6*C57/C60)","v":0},{"$f":"IF(D60=0,0,1000*$S$6*D57/D60)","v":0},{"$f":"IF(E60=0,0,1000*$S$6*E57/E60)","v":0},{"$f":"IF(F60=0,0,1000*$S$6*F57/F60)","v":0},{"$f":"IF(G60=0,0,1000*$S$6*G57/G60)","v":0},{"$f":"IF(H60=0,0,1000*$S$6*H57/H60)","v":0},{"$f":"IF(I60=0,0,1000*$S$6*I57/I60)","v":0},{"$f":"IF(J60=0,0,1000*$S$6*J57/J60)","v":0},{"$f":"IF(K60=0,0,1000*$S$6*K57/K60)","v":0},{"$f":"IF(L60=0,0,1000*$S$6*L57/L60)","v":0},{"$f":"IF(M60=0,0,1000*$S$6*M57/M60)","v":0},{"$f":"IF(N60=0,0,1000*$S$6*N57/N60)","v":0}]
[{"$nulls":10},"Data Input for PIs",{"$nulls":16},"Environmental KPIen   all vehicles   g CO2/km driven",{"$f":"IF(SUM(C59:C61)=0,0,1000*($S$5*C56+$S$6*C57)/SUM(C59:C61))","v":0},{"$f":"IF(SUM(D59:D61)=0,0,1000*($S$5*D56+$S$6*D57)/SUM(D59:D61))","v":0},{"$f":"IF(SUM(E59:E61)=0,0,1000*($S$5*E56+$S$6*E57)/SUM(E59:E61))","v":0},{"$f":"IF(SUM(F59:F61)=0,0,1000*($S$5*F56+$S$6*F57)/SUM(F59:F61))","v":0},{"$f":"IF(SUM(G59:G61)=0,0,1000*($S$5*G56+$S$6*G57)/SUM(G59:G61))","v":0},{"$f":"IF(SUM(H59:H61)=0,0,1000*($S$5*H56+$S$6*H57)/SUM(H59:H61))","v":0},{"$f":"IF(SUM(I59:I61)=0,0,1000*($S$5*I56+$S$6*I57)/SUM(I59:I61))","v":0},{"$f":"IF(SUM(J59:J61)=0,0,1000*($S$5*J56+$S$6*J57)/SUM(J59:J61))","v":0},{"$f":"IF(SUM(K59:K61)=0,0,1000*($S$5*K56+$S$6*K57)/SUM(K59:K61))","v":0},{"$f":"IF(SUM(L59:L61)=0,0,1000*($S$5*L56+$S$6*L57)/SUM(L59:L61))","v":0},{"$f":"IF(SUM(M59:M61)=0,0,1000*($S$5*M56+$S$6*M57)/SUM(M59:M61))","v":0},{"$f":"IF(SUM(N59:N61)=0,0,1000*($S$5*N56+$S$6*N57)/SUM(N59:N61))","v":0}]
["Vehicle Data","Total km of vehicles using gasoline in the reference period",{"$nulls":12},{"$f":"SUM(C59:N59)","v":0}]
[null,"Total km of vehicles using diesel in the reference period",{"$nulls":12},{"$f":"SUM(C60:N60)","v":0},{"$nulls":12},"En1.1: Gasoline consumption per 100 Kilometers per vehicle(lt/100km)",{"$f":"IF(C59=0,0,100*C56/C59)","v":0},{"$f":"IF(D59=0,0,100*D56/D59)","v":0},{"$f":"IF(E59=0,0,100*E56/E59)","v":0},{"$f":"IF(F59=0,0,100*F56/F59)","v":0},{"$f":"IF(G59=0,0,100*G56/G59)","v":0},{"$f":"IF(H59=0,0,100*H56/H59)","v":0},{"$f":"IF(I59=0,0,100*I56/I59)","v":0},{"$f":"IF(J59=0,0,100*J56/J59)","v":0},{"$f":"IF(K59=0,0,100*K56/K59)","v":0},{"$f":"IF(L59=0,0,100*L56/L59)","v":0},{"$f":"IF(M59=0,0,100*M56/M59)","v":0},{"$f":"IF(N59=0,0,100*N56/N59)","v":0}]
[null,"Total km of electric vehicles",{"$nulls":12},{"$f":"SUM(C61:N61)","v":0},{"$nulls":12},"En1.2: Diesel consumption per 100 Kilometers per vehicle(lt/100km)",{"$f":"IF(C60=0,0,100*C57/C60)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Average age per vehicle (years) "]
[null,"Average mileage per vehicle (km) "]
[null,"Number of vehicles",{"$nulls":12},{"$f":"IF(Safety!O$95=0,0,(C64*Safety!O$95+(D64-C64)*(Safety!O$95-1)+(E64-D64)*(Safety!O$95-2)+(F64-E64)*(Safety!O$95-3)+(G64-F64)*(Safety!O$95-4)+(H64-G64)*(Safety!O$95-5)+(I64-H64)*(Safety!O$95-6)+(J64-I64)*(Safety!O$95-7)+(K64-J64)*(Safety!O$95-8)+(L64-K64)*(Safety!O$95-9)+(M64-L64)*(Safety!O$95-10)+(N64-M64))/Safety!O$95)","v":0},{"$nulls":12},"En4: % of green vehicles (Euro 5 and Euro 6) used in field ",{"$f":"IF(C$64=0,0,C65/C$64)","v":0},{"$f":"IF(D$64=0,0,D65/D$64)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Number of green vehicles (Euro 5 and Euro 6) ",{"$nulls":12},{"$f":"IF(Safety!O$95=0,0,(C65*Safety!O$95+(D65-C65)*(Safety!O$95-1)+(E65-D65)*(Safety!O$95-2)+(F65-E65)*(Safety!O$95-3)+(G65-F65)*(Safety!O$95-4)+(H65-G65)*(Safety!O$95-5)+(I65-H65)*(Safety!O$95-6)+(J65-I65)*(Safety!O$95-7)+(K65-J65)*(Safety!O$95-8)+(L65-K65)*(Safety!O$95-9)+(M65-L65)*(Safety!O$95-10)+(N65-M65))/Safety!O$95)","v":0},{"$nulls":12},"En5: % of green city vehicles (hybrids, electric cars) ",{"$f":"IF(C$64=0,0,C66/C$64)","v":0},{"$f":"IF(D$64=0,0,D66/D$64)","v":0},{"$f":"IF(E$64=0,0,E66/E$64)","v":0},{"$f":"IF(F$64=0,0,F66/F$64)","v":0},{"$f":"IF(G$64=0,0,G66/G$64)","v":0},{"$f":"IF(H$64=0,0,H66/H$64)","v":0},{"$f":"IF(I$64=0,0,I66/I$64)","v":0},{"$f":"IF(J$64=0,0,J66/J$64)","v":0},{"$f":"IF(K$64=0,0,K66/K$64)","v":0},{"$f":"IF(L$64=0,0,L66/L$64)","v":0},{"$f":"IF(M$64=0,0,M66/M$64)","v":0},{"$f":"IF(N$64=0,0,N66/N$64)","v":0}]
[null,"Number of green city vehicles (hybrids, electric cars) ",{"$nulls":12},{"$f":"IF(Safety!O$95=0,0,(C66*Safety!O$95+(D66-C66)*(Safety!O$95-1)+(E66-D66)*(Safety!O$95-2)+(F66-E66)*(Safety!O$95-3)+(G66-F66)*(Safety!O$95-4)+(H66-G66)*(Safety!O$95-5)+(I66-H66)*(Safety!O$95-6)+(J66-I66)*(Safety!O$95-7)+(K66-J66)*(Safety!O$95-8)+(L66-K66)*(Safety!O$95-9)+(M66-L66)*(Safety!O$95-10)+(N66-M66))/Safety!O$95)","v":0},{"$nulls":12},"En6: % of 4-stroke motorbikes ",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Number of 4-stroke motorbikes ",{"$nulls":12},{"$f":"IF(Safety!O$95=0,0,(C67*Safety!O$95+(D67-C67)*(Safety!O$95-1)+(E67-D67)*(Safety!O$95-2)+(F67-E67)*(Safety!O$95-3)+(G67-F67)*(Safety!O$95-4)+(H67-G67)*(Safety!O$95-5)+(I67-H67)*(Safety!O$95-6)+(J67-I67)*(Safety!O$95-7)+(K67-J67)*(Safety!O$95-8)+(L67-K67)*(Safety!O$95-9)+(M67-L67)*(Safety!O$95-10)+(N67-M67))/Safety!O$95)","v":0}]

{"sheet":"Cost","index":2,"n_rows":96,"n_cols":38,"rows_kept":96,"merged":[[1,2,1,14],[2,2,2,14],[4,0,6,0],[7,0,10,0],[11,0,15,0],[16,2,16,14],[17,0,22,0],[17,2,20,13],[25,2,25,14],[26,2,26,14],[28,0,30,0],[31,0,34,0],[35,0,39,0],[40,2,40,14],[41,0,46,0],[41,2,44,13],[49,2,49,14],[50,2,50,14],[52,0,54,0],[55,0,58,0],[59,0,63,0],[64,2,64,14],[65,0,70,0],[65,2,68,13],[73,2,73,14],[74,2,74,14],[76,0,78,0],[79,0,82,0],[83,0,87,0],[88,2,88,14],[89,0,94,0],[89,2,92,13]]}
[]
[null,null,2013]
[2013,"Efficiency: Reduction of operating costs","Data Input for KPIs",{"$nulls":15},"Comments",null,"KPI",{"$nulls":10},2013]
[null,null,"January","February","March","April","May","June","July","August","September","October","November","December",2013,2014,2015,2016,null,null,2013,2014,2015,2016,null,null,"January","February","March","April","May","June","July","August","September","October","November","December"]
["Standing costs","Fleet depreciation cost in reference period (USD)",{"$nulls":12},{"$f":"SUM(C5:N5)","v":0},{"$f":"O29","v":0},{"$f":"O53","v":0},{"$f":"O77","v":0},null,"Cost eficiency KPI                Whole Life cost/Vehicle (USD)",{"$f":"IF(Environment!O13=0,0,SUM(O5:O16)/Environment!O13)","v":0},{"$f":"IF(Environment!P13=0,0,SUM(P5:P16)/Environment!P13)","v":0},{"$f":"IF(Environment!Q13=0,0,SUM(Q5:Q16)/Environment!Q13)","v":0},{"$f":"IF(Environment!R13=0,0,SUM(R5:R16)/Environment!R13)","v":0},null,"Cost eficiency KPI                Whole Life cost/Vehicle (USD)",{"$f":"IF(Environment!C13=0,0,SUM(C5:C16)/Environment!C13)","v":0},{"$f":"IF(Environment!D13=0,0,SUM(D5:D16)/Environment!D13)","v":0},{"$f":"IF(Environment!E13=0,0,SUM(E5:E16)/Environment!E13)","v":0},{"$f":"IF(Environment!F13=0,0,SUM(F5:F16)/Environment!F13)","v":0},{"$f":"IF(Environment!G13=0,0,SUM(G5:G16)/Environment!G13)","v":0},{"$f":"IF(Environment!H13=0,0,SUM(H5:H16)/Environment!H13)","v":0},{"$f":"IF(Environment!I13=0,0,SUM(I5:I16)/Environment!I13)","v":0},{"$f":"IF(Environment!J13=0,0,SUM(J5:J16)/Environment!J13)","v":0},{"$f":"IF(Environment!K13=0,0,SUM(K5:K16)/Environment!K13)","v":0},{"$f":"IF(Environment!L13=0,0,SUM(L5:L16)/Environment!L13)","v":0},{"$f":"IF(Environment!M13=0,0,SUM(M5:M16)/Environment!M13)","v":0},{"$f":"IF(Environment!N13=0,0,SUM(N5:N16)/Environment!N13)","v":0}]
[null,"Fleet  insurance cost in reference period (USD)",{"$nulls":12},{"$f":"SUM(C6:N6)","v":0},0,0,0,null,null,"PIs"]
[null,"Fleet breakdown cover costs (USD)",{"$nulls":12},0,0,0,0,null,"C1: Average Purchasing cost per vehicle type (USD)",{"$f":"O18","v":0},{"$f":"P18","v":0},{"$f":"Q18","v":0},{"$f":"R18","v":0}]
["Running costs","Fleet scheduled maintainance cost in reference period (USD)",{"$nulls":12},0,0,0,0,null,"C2.1: Gasoline cost per kilometer  (USD/Km)(country level)",{"$f":"IF(Environment!O8=0,0,O10/Environment!O8)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Environment!P8=0,0,P10/Environment!P8)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Environment!Q8=0,0,Q10/Environment!Q8)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Environment!R8=0,0,R10/Environment!R8)","v":{"v":0,"d":"0.00"}},null,"C2.1: Gasoline cost per kilometerUSD/Km)(country level)",{"$f":"IF(Environment!C8=0,0,C10/Environment!C8)","v":0},{"$f":"IF(Environment!D8=0,0,D10/Environment!D8)","v":0},{"$f":"IF(Environment!E8=0,0,E10/Environment!E8)","v":0},{"$f":"IF(Environment!F8=0,0,F10/Environment!F8)","v":0},{"$f":"IF(Environment!G8=0,0,G10/Environment!G8)","v":0},{"$f":"IF(Environment!H8=0,0,H10/Environment!H8)","v":0},{"$f":"IF(Environment!I8=0,0,I10/Environment!I8)","v":0},{"$f":"IF(Environment!J8=0,0,J10/Environment!J8)","v":0},{"$f":"IF(Environment!K8=0,0,K10/Environment!K8)","v":0},{"$f":"IF(Environment!L8=0,0,L10/Environment!L8)","v":0},{"$f":"IF(Environment!M8=0,0,M10/Environment!M8)","v":0},{"$f":"IF(Environment!N8=0,0,N10/Environment!N8)","v":0}]
[null,"Fleet unscheduled repairs cost in reference period (USD)",{"$nulls":12},0,0,0,0,null,"C2.2: Diesel cost per kilometer  (USD/Km)(country level)",{"$f":"IF(Environment!O9=0,0,O11/Environment!O9)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Environment!P9=0,0,P11/Environment!P9)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Environment!Q9=0,0,Q11/Environment!Q9)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Environment!R9=0,0,R11/Environment!R9)","v":{"v":0,"d":"0.00"}},null,"C2.2: Diesel cost per kilometer(USD/Km)(country level)",{"$f":"IF(Environment!C9=0,0,C11/Environment!C9)","v":0},{"$f":"IF(Environment!D9=0,0,D11/Environment!D9)","v":0},{"$f":"IF(Environment!E9=0,0,E11/Environment!E9)","v":0},{"$f":"IF(Environment!F9=0,0,F11/Environment!F9)","v":0},{"$f":"IF(Environment!G9=0,0,G11/Environment!G9)","v":0},{"$f":"IF(Environment!H9=0,0,H11/Environment!H9)","v":0},{"$f":"IF(Environment!I9=0,0,I11/Environment!I9)","v":0},{"$f":"IF(Environment!J9=0,0,J11/Environment!J9)","v":0},{"$f":"IF(Environment!K9=0,0,K11/Environment!K9)","v":0},{"$f":"IF(Environment!L9=0,0,L11/Environment!L9)","v":0},{"$f":"IF(Environment!M9=0,0,M11/Environment!M9)","v":0},{"$f":"IF(Environment!N9=0,0,N11/Environment!N9)","v":0}]
[null,"Fleet gasoline fuel cost in reference period (USD)",{"$nulls":12},0,0,0,0,null,"C3.1: Gasoline consumption per 100 Kilometers per vehicle (lt/100km) ",{"$f":"Environment!W9","v":{"v":0,"d":"0.00"}},{"$f":"Environment!X9","v":{"v":0,"d":"0.00"}},{"$f":"Environment!Y9","v":{"v":0,"d":"0.00"}},{"$f":"Environment!Z9","v":{"v":0,"d":"0.00"}}]
[null,"Fleet diesel fuel cost in reference period (USD)",{"$nulls":12},0,0,0,0,null,"C3.2: Diesel consumption per 100 Kilometers per vehicle (lt/100km) ",{"$f":"Environment!W10","v":{"v":0,"d":"0.00"}},{"$f":"Environment!X10","v":{"v":0,"d":"0.00"}},{"$f":"Environment!Y10","v":{"v":0,"d":"0.00"}},{"$f":"Environment!Z10","v":{"v":0,"d":"0.00"}}]
["Overhead costs","Personnel cost (drivers) in the reference period (USD)",{"$nulls":12},0,0,0,0,null,"C4: Average age per vehicle (years) ",{"$f":"Environment!W11","v":{"v":0,"d":"0.00"}},{"$f":"Environment!X11","v":{"v":0,"d":"0.00"}},{"$f":"Environment!Y11","v":{"v":0,"d":"0.00"}},{"$f":"Environment!Z11","v":{"v":0,"d":"0.00"}}]
[null,"Personnel cost (management related to fleet) in the reference period (USD)",{"$nulls":12},0,0,0,0,null,"C5: Average mileage per vehicle (km) ",{"$f":"Environment!W12","v":0},{"$f":"Environment!X12","v":0},{"$f":"Environment!Y12","v":0},{"$f":"Environment!Z12","v":0}]
[null,"Personnel cost  (other staff related to fleet) in the reference period",{"$nulls":12},0,0,0,0,null,"C6: % of green field vehicles (Euro 5 and Euro 6) ",{"$f":"Environment!W13","v":{"v":0,"d":"0%"}},{"$f":"Environment!X13","v":{"v":0,"d":"0%"}},{"$f":"Environment!Y13","v":{"v":0,"d":"0%"}},{"$f":"Environment!Z13","v":{"v":0,"d":"0%"}}]
[null,"Facility costs in the reference period (USD)",{"$nulls":12},0,0,0,0,null,"C7: % of green city vehicles (hybrids, electric cars)",{"$f":"Environment!W14","v":{"v":0,"d":"0%"}},{"$f":"Environment!X14","v":{"v":0,"d":"0%"}},{"$f":"Environment!Y14","v":{"v":0,"d":"0%"}},{"$f":"Environment!Z14","v":{"v":0,"d":"0%"}}]
[null,"Other costs in the reference period (USD)",{"$nulls":12},0,0,0,0,null,"C8: % of 4-stroke motorbikes ",{"$f":"Environment!W15","v":{"v":0,"d":"0%"}},{"$f":"Environment!X15","v":{"v":0,"d":"0%"}},{"$f":"Environment!Y15","v":{"v":0,"d":"0%"}},{"$f":"Environment!Z15","v":{"v":0,"d":"0%"}}]
[null,null,"Data Input for PIs",{"$nulls":16},"C9: % of drivers trained ",{"$f":"Environment!W16","v":{"v":0,"d":"0%"}},{"$f":"Environment!X16","v":{"v":0,"d":"0%"}},{"$f":"Environment!Y16","v":{"v":0,"d":"0%"}},{"$f":"Environment!Z16","v":{"v":0,"d":"0%"}}]
["Various data","Average Purchasing cost per vehicle type (USD)",{"$nulls":17},"C10: Number of drivers’ training hours per year",{"$f":"Environment!W17","v":0},{"$f":"Environment!X17","v":0},{"$f":"Environment!Y17","v":0},{"$f":"Environment!Z17","v":0}]
[null,"Average replacement age per vehicle (years)",{"$nulls":17},"C11:Number of kms per speed violation occurrences",{"$f":"Environment!W18","v":"GOOD JOB!"},{"$f":"Environment!X18","v":"GOOD JOB!"},{"$f":"Environment!Y18","v":"GOOD JOB!"},{"$f":"Environment!Z18","v":"GOOD JOB!"}]
[null,"Average disposal cost per vehicle (country level)",{"$nulls":17},"C12: Maintenance done on time according to maintenance schedule (%) ",{"$f":"Environment!W19","v":{"v":0,"d":"0%"}},{"$f":"Environment!X19","v":{"v":0,"d":"0%"}},{"$f":"Environment!Y19","v":{"v":0,"d":"0%"}},{"$f":"Environment!Z19","v":{"v":0,"d":"0%"}}]
[null,"Average sales price per vehicle",{"$nulls":17},"C13.1: Scheduled maintenance cost per vehicle (USD) (country level)",{"$f":"IF(Environment!O13=0,0,O8/Environment!O13)","v":{"v":0,"d":"$0"}},{"$f":"IF(Environment!P13=0,0,P8/Environment!P13)","v":{"v":0,"d":"$0"}},{"$f":"IF(Environment!Q13=0,0,Q8/Environment!Q13)","v":{"v":0,"d":"$0"}},{"$f":"IF(Environment!R13=0,0,R8/Environment!R13)","v":{"v":0,"d":"$0"}},null,"C13.1: Scheduled maintenance cost per vehicle (USD) (country level)",{"$f":"IF(Environment!C13=0,0,C8/Environment!C13)","v":0},{"$f":"IF(Environment!D13=0,0,D8/Environment!D13)","v":0},{"$f":"IF(Environment!E13=0,0,E8/Environment!E13)","v":0},{"$f":"IF(Environment!F13=0,0,F8/Environment!F13)","v":0},{"$f":"IF(Environment!G13=0,0,G8/Environment!G13)","v":0},{"$f":"IF(Environment!H13=0,0,H8/Environment!H13)","v":0},{"$f":"IF(Environment!I13=0,0,I8/Environment!I13)","v":0},{"$f":"IF(Environment!J13=0,0,J8/Environment!J13)","v":0},{"$f":"IF(Environment!K13=0,0,K8/Environment!K13)","v":0},{"$f":"IF(Environment!L13=0,0,L8/Environment!L13)","v":0},{"$f":"IF(Environment!M13=0,0,M8/Environment!M13)","v":0},{"$f":"IF(Environment!N13=0,0,N8/Environment!N13)","v":0}]
[null,"Total number of vehicles rented",{"$nulls":12},{"$f":"IF(Safety!O$5=0,0,(C22*Safety!O$5+(D22-C22)*(Safety!O$5-1)+(E22-D22)*(Safety!O$5-2)+(F22-E22)*(Safety!O$5-3)+(G22-F22)*(Safety!O$5-4)+(H22-G22)*(Safety!O$5-5)+(I22-H22)*(Safety!O$5-6)+(J22-I22)*(Safety!O$5-7)+(K22-J22)*(Safety!O$5-8)+(L22-K22)*(Safety!O$5-9)+(M22-L22)*(Safety!O$5-10)+(N22-M22))/Safety!O$5)","v":0},{"$f":"O46","v":0},{"$f":"O70","v":0},{"$f":"O94","v":0},null,"C13.2 Unscheduled repair cost per vehicle (USD) (country level)",{"$f":"IF(Environment!O13=0,0,O9/Environment!O13)","v":{"v":0,"d":"$0"}},{"$f":"IF(Environment!P13=0,0,P9/Environment!P13)","v":{"v":0,"d":"$0"}},{"$f":"IF(Environment!Q13=0,0,Q9/Environment!Q13)","v":{"v":0,"d":"$0"}},{"$f":"IF(Environment!R13=0,0,R9/Environment!R13)","v":{"v":0,"d":"$0"}},null,"C13.2 Unscheduled repair cost per vehicle (USD) (country level)",{"$f":"IF(Environment!C13=0,0,C9/Environment!C13)","v":0},{"$f":"IF(Environment!D13=0,0,D9/Environment!D13)","v":0},{"$f":"IF(Environment!E13=0,0,E9/Environment!E13)","v":0},{"$f":"IF(Environment!F13=0,0,F9/Environment!F13)","v":0},{"$f":"IF(Environment!G13=0,0,G9/Environment!G13)","v":0},{"$f":"IF(Environment!H13=0,0,H9/Environment!H13)","v":0},{"$f":"IF(Environment!I13=0,0,I9/Environment!I13)","v":0},{"$f":"IF(Environment!J13=0,0,J9/Environment!J13)","v":0},{"$f":"IF(Environment!K13=0,0,K9/Environment!K13)","v":0},{"$f":"IF(Environment!L13=0,0,L9/Environment!L13)","v":0},{"$f":"IF(Environment!M13=0,0,M9/Environment!M13)","v":0},{"$f":"IF(Environment!N13=0,0,N9/Environment!N13)","v":0}]
[null,"Total programme costs served by the fleet in the reference period",{"$nulls":12},{"$f":"SUM(C23:N23)","v":0},{"$f":"O47","v":0},{"$f":"O71","v":0},{"$f":"O95","v":0},null,"C14: Average insurance premium per vehicle (USD) (country level)",{"$f":"IF(Environment!O13-O22=0,0,O6/(Environment!O13-O22))","v":{"v":0,"d":"$0"}},{"$f":"IF(Environment!P13-P22=0,0,P6/(Environment!P13-P22))","v":{"v":0,"d":"$0"}},{"$f":"IF(Environment!Q13-Q22=0,0,Q6/(Environment!Q13-Q22))","v":{"v":0,"d":"$0"}},{"$f":"IF(Environment!R13-R22=0,0,R6/(Environment!R13-R22))","v":{"v":0,"d":"$0"}},null,"C14: Average insurance premium per vehicle (USD) (country level)",{"$f":"IF(Environment!C13-C22=0,0,C6/(Environment!C13-C22))","v":0},{"$f":"IF(Environment!D13-D22=0,0,D6/(Environment!D13-D22))","v":0},{"$f":"IF(Environment!E13-E22=0,0,E6/(Environment!E13-E22))","v":0},{"$f":"IF(Environment!F13-F22=0,0,F6/(Environment!F13-F22))","v":0},{"$f":"IF(Environment!G13-G22=0,0,G6/(Environment!G13-G22))","v":0},{"$f":"IF(Environment!H13-H22=0,0,H6/(Environment!H13-H22))","v":0},{"$f":"IF(Environment!I13-I22=0,0,I6/(Environment!I13-I22))","v":0},{"$f":"IF(Environment!J13-J22=0,0,J6/(Environment!J13-J22))","v":0},{"$f":"IF(Environment!K13-K22=0,0,K6/(Environment!K13-K22))","v":0},{"$f":"IF(Environment!L13-L22=0,0,L6/(Environment!L13-L22))","v":0},{"$f":"IF(Environment!M13-M22=0,0,M6/(Environment!M13-M22))","v":0},{"$f":"IF(Environment!N13-N22=0,0,N6/(Environment!N13-N22))","v":0}]
[{"$nulls":19},"C15.1: Number of fatal accidents during reference period",{"$f":"Safety!O11","v":0},{"$f":"Safety!P11","v":0},{"$f":"Safety!Q11","v":0},{"$f":"Safety!R11","v":0},null,"C19: Total fleet costs as % of the Programme costs",{"$f":"IF(SUM(C5:C16)=0,0,SUM(C5:C16)/C23)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":19},"C15.2: Number of injury-only accidents during reference period",{"$f":"Safety!O12","v":0},{"$f":"Safety!P12","v":0},{"$f":"Safety!Q12","v":0},{"$f":"Safety!R12","v":0}]
[null,null,2014,{"$nulls":16},"C15.3: Number of damage-only accidents during reference period",{"$f":"Safety!O13","v":0},{"$f":"Safety!P13","v":0},{"$f":"Safety!Q13","v":0},{"$f":"Safety!R13","v":0}]
[2014,"Efficiency: Reduction of operating costs","Data Input for KPIs",{"$nulls":16},"C16: Average replacement age per vehicle",{"$f":"O19","v":0},0,0,0,{"$nulls":7},2014]
[null,null,"January","February","March","April","May","June","July","August","September","October","November","December",2014,{"$nulls":4},"C17: Average disposal cost per vehicle (country level)",0,0,0,0,null,null,"January","February","March","April","May","June","July","August","September","October","November","December"]
["Standing costs","Fleet depreciation cost in reference period (USD)",{"$nulls":12},{"$f":"SUM(C29:N29)","v":0},{"$nulls":4},"C18: Average sales price per vehicle (country level)",0,0,0,0,null,"Cost eficiency KPI                Whole Life cost/Vehicle (USD)",{"$f":"IF(Environment!C30=0,0,SUM(C29:C40)/Environment!C30)","v":0},{"$f":"IF(Environment!D30=0,0,SUM(D29:D40)/Environment!D30)","v":0},{"$f":"IF(Environment!E30=0,0,SUM(E29:E40)/Environment!E30)","v":0},{"$f":"IF(Environment!F30=0,0,SUM(F29:F40)/Environment!F30)","v":0},{"$f":"IF(Environment!G30=0,0,SUM(G29:G40)/Environment!G30)","v":0},{"$f":"IF(Environment!H30=0,0,SUM(H29:H40)/Environment!H30)","v":0},{"$f":"IF(Environment!I30=0,0,SUM(I29:I40)/Environment!I30)","v":0},{"$f":"IF(Environment!J30=0,0,SUM(J29:J40)/Environment!J30)","v":0},{"$f":"IF(Environment!K30=0,0,SUM(K29:K40)/Environment!K30)","v":0},{"$f":"IF(Environment!L30=0,0,SUM(L29:L40)/Environment!L30)","v":0},{"$f":"IF(Environment!M30=0,0,SUM(M29:M40)/Environment!M30)","v":0},{"$f":"IF(Environment!N30=0,0,SUM(N29:N40)/Environment!N30)","v":0}]
[null,"Fleet  insurance cost in reference period (USD)",{"$nulls":12},{"$f":"SUM(C30:N30)","v":0},{"$nulls":4},"C19: Total fleet costs as % of the Programme costs",{"$f":"IF(SUM(O5:O16)=0,0,SUM(O5:O16)/O23)","v":{"v":0,"d":"0%"}},{"$f":"IF(SUM(P5:P16)=0,0,SUM(P5:P16)/P23)","v":{"v":0,"d":"0%"}},{"$f":"IF(SUM(Q5:Q16)=0,0,SUM(Q5:Q16)/Q23)","v":{"v":0,"d":"0%"}},{"$f":"IF(SUM(R5:R16)=0,0,SUM(R5:R16)/R23)","v":{"v":0,"d":"0%"}}]
[null,"Fleet breakdown cover costs (USD)",{"$nulls":12},0]
["Running costs","Fleet scheduled maintainance cost in reference period (USD)",{"$nulls":12},0,{"$nulls":10},"C2.1: Gasoline cost per kilometer (USD/Km)(country level)",{"$f":"IF(Environment!C25=0,0,C34/Environment!C25)","v":0},{"$f":"IF(Environment!D25=0,0,D34/Environment!D25)","v":0},{"$f":"IF(Environment!E25=0,0,E34/Environment!E25)","v":0},{"$f":"IF(Environment!F25=0,0,F34/Environment!F25)","v":0},{"$f":"IF(Environment!G25=0,0,G34/Environment!G25)","v":0},{"$f":"IF(Environment!H25=0,0,H34/Environment!H25)","v":0},{"$f":"IF(Environment!I25=0,0,I34/Environment!I25)","v":0},{"$f":"IF(Environment!J25=0,0,J34/Environment!J25)","v":0},{"$f":"IF(Environment!K25=0,0,K34/Environment!K25)","v":0},{"$f":"IF(Environment!L25=0,0,L34/Environment!L25)","v":0},{"$f":"IF(Environment!M25=0,0,M34/Environment!M25)","v":0},{"$f":"IF(Environment!N25=0,0,N34/Environment!N25)","v":0}]
[null,"Fleet unscheduled repairs cost in reference period (USD)",{"$nulls":12},0,{"$nulls":10},"C2.2: Diesel cost per kilometer (USD/Km)(country level)",{"$f":"IF(Environment!C26=0,0,C35/Environment!C26)","v":0},{"$f":"IF(Environment!D26=0,0,D35/Environment!D26)","v":0},{"$f":"IF(Environment!E26=0,0,E35/Environment!E26)","v":0},{"$f":"IF(Environment!F26=0,0,F35/Environment!F26)","v":0},{"$f":"IF(Environment!G26=0,0,G35/Environment!G26)","v":0},{"$f":"IF(Environment!H26=0,0,H35/Environment!H26)","v":0},{"$f":"IF(Environment!I26=0,0,I35/Environment!I26)","v":0},{"$f":"IF(Environment!J26=0,0,J35/Environment!J26)","v":0},{"$f":"IF(Environment!K26=0,0,K35/Environment!K26)","v":0},{"$f":"IF(Environment!L26=0,0,L35/Environment!L26)","v":0},{"$f":"IF(Environment!M26=0,0,M35/Environment!M26)","v":0},{"$f":"IF(Environment!N26=0,0,N35/Environment!N26)","v":0}]
[null,"Fleet gasoline fuel cost in reference period (USD)",{"$nulls":12},0]
[null,"Fleet diesel fuel cost in reference period (USD)",{"$nulls":12},0]
["Overhead costs","Personnel cost (drivers) in the reference period (USD)",{"$nulls":12},0]
[null,"Personnel cost (management related to fleet) in the reference period (USD)",{"$nulls":12},0]
[null,"Personnel cost  (other staff related to fleet) in the reference period",{"$nulls":12},0]
[null,"Facility costs in the reference period (USD)",{"$nulls":12},0]
[null,"Other costs in the reference period (USD)",{"$nulls":12},0]
[null,null,"Data Input for PIs"]
["Various data","Average Purchasing cost per vehicle type (USD)"]
[null,"Average replacement age per vehicle (years)"]
[null,"Average disposal cost per vehicle (country level)"]
[null,"Average sales price per vehicle",{"$nulls":23},"C13.1: Scheduled maintenance cost per vehicle (USD) (country level)",{"$f":"IF(Environment!C30=0,0,C32/Environment!C30)","v":0},{"$f":"IF(Environment!D30=0,0,D32/Environment!D30)","v":0},{"$f":"IF(Environment!E30=0,0,E32/Environment!E30)","v":0},{"$f":"IF(Environment!F30=0,0,F32/Environment!F30)","v":0},{"$f":"IF(Environment!G30=0,0,G32/Environment!G30)","v":0},{"$f":"IF(Environment!H30=0,0,H32/Environment!H30)","v":0},{"$f":"IF(Environment!I30=0,0,I32/Environment!I30)","v":0},{"$f":"IF(Environment!J30=0,0,J32/Environment!J30)","v":0},{"$f":"IF(Environment!K30=0,0,K32/Environment!K30)","v":0},{"$f":"IF(Environment!L30=0,0,L32/Environment!L30)","v":0},{"$f":"IF(Environment!M30=0,0,M32/Environment!M30)","v":0},{"$f":"IF(Environment!N30=0,0,N32/Environment!N30)","v":0}]
[null,"Total number of vehicles rented",{"$nulls":12},{"$f":"IF(Safety!O35=0,0,(C46*12+(D46-C46)*11+(E46-D46)*10+(F46-E46)*9+(G46-F46)*8+(H46-G46)*7+(I46-H46)*6+(J46-I46)*5+(K46-J46)*4+(L46-K46)*3+(M46-L46)*2+(N46-M46))/Safety!O35)","v":0},{"$nulls":10},"C13.2 Unscheduled repair cost per vehicle (USD) (country level)",{"$f":"IF(Environment!C30=0,0,C33/Environment!C30)","v":0},{"$f":"IF(Environment!D30=0,0,D33/Environment!D30)","v":0},{"$f":"IF(Environment!E30=0,0,E33/Environment!E30)","v":0},{"$f":"IF(Environment!F30=0,0,F33/Environment!F30)","v":0},{"$f":"IF(Environment!G30=0,0,G33/Environment!G30)","v":0},{"$f":"IF(Environment!H30=0,0,H33/Environment!H30)","v":0},{"$f":"IF(Environment!I30=0,0,I33/Environment!I30)","v":0},{"$f":"IF(Environment!J30=0,0,J33/Environment!J30)","v":0},{"$f":"IF(Environment!K30=0,0,K33/Environment!K30)","v":0},{"$f":"IF(Environment!L30=0,0,L33/Environment!L30)","v":0},{"$f":"IF(Environment!M30=0,0,M33/Environment!M30)","v":0},{"$f":"IF(Environment!N30=0,0,N33/Environment!N30)","v":0}]
[null,"Total programme costs served by the fleet in the reference period",{"$nulls":12},{"$f":"SUM(C47:N47)","v":0},{"$nulls":10},"C14: Average insurance premium per vehicle (USD) (country level)",{"$f":"IF(Environment!C30-C46=0,0,C30/(Environment!C30-C46))","v":0},{"$f":"IF(Environment!D30-D46=0,0,D30/(Environment!D30-D46))","v":0},{"$f":"IF(Environment!E30-E46=0,0,E30/(Environment!E30-E46))","v":0},{"$f":"IF(Environment!F30-F46=0,0,F30/(Environment!F30-F46))","v":0},{"$f":"IF(Environment!G30-G46=0,0,G30/(Environment!G30-G46))","v":0},{"$f":"IF(Environment!H30-H46=0,0,H30/(Environment!H30-H46))","v":0},{"$f":"IF(Environment!I30-I46=0,0,I30/(Environment!I30-I46))","v":0},{"$f":"IF(Environment!J30-J46=0,0,J30/(Environment!J30-J46))","v":0},{"$f":"IF(Environment!K30-K46=0,0,K30/(Environment!K30-K46))","v":0},{"$f":"IF(Environment!L30-L46=0,0,L30/(Environment!L30-L46))","v":0},{"$f":"IF(Environment!M30-M46=0,0,M30/(Environment!M30-M46))","v":0},{"$f":"IF(Environment!N30-N46=0,0,N30/(Environment!N30-N46))","v":0}]
[{"$nulls":25},"C19: Total fleet costs as % of the Programme costs",{"$f":"IF(SUM(C29:C40)=0,0,SUM(C29:C40)/C47)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,2015]
[2015,"Efficiency: Reduction of operating costs","Data Input for KPIs",{"$nulls":28},2015]
[null,null,"January","February","March","April","May","June","July","August","September","October","November","December",2015,{"$nulls":11},"January","February","March","April","May","June","July","August","September","October","November","December"]
["Standing costs","Fleet depreciation cost in reference period (USD)",{"$nulls":12},{"$f":"SUM(C53:N53)","v":0},{"$nulls":10},"Cost eficiency KPI                Whole Life cost/Vehicle (USD)",{"$f":"IF(Environment!C47=0,0,SUM(C53:C64)/Environment!C47)","v":0},{"$f":"IF(Environment!D47=0,0,SUM(D53:D64)/Environment!D47)","v":0},{"$f":"IF(Environment!E47=0,0,SUM(E53:E64)/Environment!E47)","v":0},{"$f":"IF(Environment!F47=0,0,SUM(F53:F64)/Environment!F47)","v":0},{"$f":"IF(Environment!G47=0,0,SUM(G53:G64)/Environment!G47)","v":0},{"$f":"IF(Environment!H47=0,0,SUM(H53:H64)/Environment!H47)","v":0},{"$f":"IF(Environment!I47=0,0,SUM(I53:I64)/Environment!I47)","v":0},{"$f":"IF(Environment!J47=0,0,SUM(J53:J64)/Environment!J47)","v":0},{"$f":"IF(Environment!K47=0,0,SUM(K53:K64)/Environment!K47)","v":0},{"$f":"IF(Environment!L47=0,0,SUM(L53:L64)/Environment!L47)","v":0},{"$f":"IF(Environment!M47=0,0,SUM(M53:M64)/Environment!M47)","v":0},{"$f":"IF(Environment!N47=0,0,SUM(N53:N64)/Environment!N47)","v":0}]
[null,"Fleet  insurance cost in reference period (USD)",{"$nulls":12},{"$f":"SUM(C54:N54)","v":0}]
[null,"Fleet breakdown cover costs (USD)",{"$nulls":12},0]
["Running costs","Fleet scheduled maintainance cost in reference period (USD)",{"$nulls":12},0,{"$nulls":10},"C2.1: Gasoline cost per kilometer  (USD/Km)(country level)",{"$f":"IF(Environment!C42=0,0,C58/Environment!C42)","v":0},{"$f":"IF(Environment!D42=0,0,D58/Environment!D42)","v":0},{"$f":"IF(Environment!E42=0,0,E58/Environment!E42)","v":0},{"$f":"IF(Environment!F42=0,0,F58/Environment!F42)","v":0},{"$f":"IF(Environment!G42=0,0,G58/Environment!G42)","v":0},{"$f":"IF(Environment!H42=0,0,H58/Environment!H42)","v":0},{"$f":"IF(Environment!I42=0,0,I58/Environment!I42)","v":0},{"$f":"IF(Environment!J42=0,0,J58/Environment!J42)","v":0},{"$f":"IF(Environment!K42=0,0,K58/Environment!K42)","v":0},{"$f":"IF(Environment!L42=0,0,L58/Environment!L42)","v":0},{"$f":"IF(Environment!M42=0,0,M58/Environment!M42)","v":0},{"$f":"IF(Environment!N42=0,0,N58/Environment!N42)","v":0}]
[null,"Fleet unscheduled repairs cost in reference period (USD)",{"$nulls":12},0,{"$nulls":10},"C2.2: Diesel cost per kilometer  (USD/Km)(country level)",{"$f":"IF(Environment!C43=0,0,C59/Environment!C43)","v":0},{"$f":"IF(Environment!D43=0,0,D59/Environment!D43)","v":0},{"$f":"IF(Environment!E43=0,0,E59/Environment!E43)","v":0},{"$f":"IF(Environment!F43=0,0,F59/Environment!F43)","v":0},{"$f":"IF(Environment!G43=0,0,G59/Environment!G43)","v":0},{"$f":"IF(Environment!H43=0,0,H59/Environment!H43)","v":0},{"$f":"IF(Environment!I43=0,0,I59/Environment!I43)","v":0},{"$f":"IF(Environment!J43=0,0,J59/Environment!J43)","v":0},{"$f":"IF(Environment!K43=0,0,K59/Environment!K43)","v":0},{"$f":"IF(Environment!L43=0,0,L59/Environment!L43)","v":0},{"$f":"IF(Environment!M43=0,0,M59/Environment!M43)","v":0},{"$f":"IF(Environment!N43=0,0,N59/Environment!N43)","v":0}]
[null,"Fleet gasoline fuel cost in reference period (USD)",{"$nulls":12},0]
[null,"Fleet diesel fuel cost in reference period (USD)",{"$nulls":12},0]
["Overhead costs","Personnel cost (drivers) in the reference period (USD)",{"$nulls":12},0]
[null,"Personnel cost (management related to fleet) in the reference period (USD)",{"$nulls":12},0]
[null,"Personnel cost  (other staff related to fleet) in the reference period",{"$nulls":12},0]
[null,"Facility costs in the reference period (USD)",{"$nulls":12},0]
[null,"Other costs in the reference period (USD)",{"$nulls":12},0]
[null,null,"Data Input for PIs"]
["Various data","Average Purchasing cost per vehicle type (USD)"]
[null,"Average replacement age per vehicle (years)"]
[null,"Average disposal cost per vehicle (country level)"]
[null,"Average sales price per vehicle",{"$nulls":23},"C13.1: Scheduled maintenance cost per vehicle (USD) (country level)",{"$f":"IF(Environment!C47=0,0,C56/Environment!C47)","v":0},{"$f":"IF(Environment!D47=0,0,D56/Environment!D47)","v":0},{"$f":"IF(Environment!E47=0,0,E56/Environment!E47)","v":0},{"$f":"IF(Environment!F47=0,0,F56/Environment!F47)","v":0},{"$f":"IF(Environment!G47=0,0,G56/Environment!G47)","v":0},{"$f":"IF(Environment!H47=0,0,H56/Environment!H47)","v":0},{"$f":"IF(Environment!I47=0,0,I56/Environment!I47)","v":0},{"$f":"IF(Environment!J47=0,0,J56/Environment!J47)","v":0},{"$f":"IF(Environment!K47=0,0,K56/Environment!K47)","v":0},{"$f":"IF(Environment!L47=0,0,L56/Environment!L47)","v":0},{"$f":"IF(Environment!M47=0,0,M56/Environment!M47)","v":0},{"$f":"IF(Environment!N47=0,0,N56/Environment!N47)","v":0}]
[null,"Total number of vehicles rented",{"$nulls":12},{"$f":"IF(Safety!O65=0,0,(C70*12+(D70-C70)*11+(E70-D70)*10+(F70-E70)*9+(G70-F70)*8+(H70-G70)*7+(I70-H70)*6+(J70-I70)*5+(K70-J70)*4+(L70-K70)*3+(M70-L70)*2+(N70-M70))/Safety!O65)","v":0},{"$nulls":10},"C13.2 Unscheduled repair cost per vehicle (USD) (country level)",{"$f":"IF(Environment!C47=0,0,C57/Environment!C47)","v":0},{"$f":"IF(Environment!D47=0,0,D57/Environment!D47)","v":0},{"$f":"IF(Environment!E47=0,0,E57/Environment!E47)","v":0},{"$f":"IF(Environment!F47=0,0,F57/Environment!F47)","v":0},{"$f":"IF(Environment!G47=0,0,G57/Environment!G47)","v":0},{"$f":"IF(Environment!H47=0,0,H57/Environment!H47)","v":0},{"$f":"IF(Environment!I47=0,0,I57/Environment!I47)","v":0},{"$f":"IF(Environment!J47=0,0,J57/Environment!J47)","v":0},{"$f":"IF(Environment!K47=0,0,K57/Environment!K47)","v":0},{"$f":"IF(Environment!L47=0,0,L57/Environment!L47)","v":0},{"$f":"IF(Environment!M47=0,0,M57/Environment!M47)","v":0},{"$f":"IF(Environment!N47=0,0,N57/Environment!N47)","v":0}]
[null,"Total programme costs served by the fleet in the reference period",{"$nulls":12},{"$f":"SUM(C71:N71)","v":0},{"$nulls":10},"C14: Average insurance premium per vehicle (USD) (country level)",{"$f":"IF(Environment!C47-C70=0,0,C54/(Environment!C47-C70))","v":0},{"$f":"IF(Environment!D47-D70=0,0,D54/(Environment!D47-D70))","v":0},{"$f":"IF(Environment!E47-E70=0,0,E54/(Environment!E47-E70))","v":0},{"$f":"IF(Environment!F47-F70=0,0,F54/(Environment!F47-F70))","v":0},{"$f":"IF(Environment!G47-G70=0,0,G54/(Environment!G47-G70))","v":0},{"$f":"IF(Environment!H47-H70=0,0,H54/(Environment!H47-H70))","v":0},{"$f":"IF(Environment!I47-I70=0,0,I54/(Environment!I47-I70))","v":0},{"$f":"IF(Environment!J47-J70=0,0,J54/(Environment!J47-J70))","v":0},{"$f":"IF(Environment!K47-K70=0,0,K54/(Environment!K47-K70))","v":0},{"$f":"IF(Environment!L47-L70=0,0,L54/(Environment!L47-L70))","v":0},{"$f":"IF(Environment!M47-M70=0,0,M54/(Environment!M47-M70))","v":0},{"$f":"IF(Environment!N47-N70=0,0,N54/(Environment!N47-N70))","v":0}]
[{"$nulls":25},"C19: Total fleet costs as % of the Programme costs",{"$f":"IF(SUM(C53:C64)=0,0,SUM(C53:C64)/C71)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,2016]
[2016,"Efficiency: Reduction of operating costs","Data Input for KPIs",{"$nulls":28},2016]
[null,null,"January","February","March","April","May","June","July","August","September","October","November","December",2016,{"$nulls":11},"January","February","March","April","May","June","July","August","September","October","November","December"]
["Standing costs","Fleet depreciation cost in reference period (USD)",{"$nulls":12},{"$f":"SUM(C77:N77)","v":0},{"$nulls":10},"Cost eficiency KPI                Whole Life cost/Vehicle (USD)",{"$f":"IF(Environment!C64=0,0,SUM(C77:C88)/Environment!C64)","v":0},{"$f":"IF(Environment!D64=0,0,SUM(D77:D88)/Environment!D64)","v":0},{"$f":"IF(Environment!E64=0,0,SUM(E77:E88)/Environment!E64)","v":0},{"$f":"IF(Environment!F64=0,0,SUM(F77:F88)/Environment!F64)","v":0},{"$f":"IF(Environment!G64=0,0,SUM(G77:G88)/Environment!G64)","v":0},{"$f":"IF(Environment!H64=0,0,SUM(H77:H88)/Environment!H64)","v":0},{"$f":"IF(Environment!I64=0,0,SUM(I77:I88)/Environment!I64)","v":0},{"$f":"IF(Environment!J64=0,0,SUM(J77:J88)/Environment!J64)","v":0},{"$f":"IF(Environment!K64=0,0,SUM(K77:K88)/Environment!K64)","v":0},{"$f":"IF(Environment!L64=0,0,SUM(L77:L88)/Environment!L64)","v":0},{"$f":"IF(Environment!M64=0,0,SUM(M77:M88)/Environment!M64)","v":0},{"$f":"IF(Environment!N64=0,0,SUM(N77:N88)/Environment!N64)","v":0}]
[null,"Fleet  insurance cost in reference period (USD)",{"$nulls":12},{"$f":"SUM(C78:N78)","v":0}]
[null,"Fleet breakdown cover costs (USD)",{"$nulls":12},0]
["Running costs","Fleet scheduled maintainance cost in reference period (USD)",{"$nulls":12},0,{"$nulls":10},"C2.1: Gasoline cost per kilometer  (USD/Km)(country level)",{"$f":"IF(Environment!C59=0,0,C82/Environment!C59)","v":0},{"$f":"IF(Environment!D59=0,0,D82/Environment!D59)","v":0},{"$f":"IF(Environment!E59=0,0,E82/Environment!E59)","v":0},{"$f":"IF(Environment!F59=0,0,F82/Environment!F59)","v":0},{"$f":"IF(Environment!G59=0,0,G82/Environment!G59)","v":0},{"$f":"IF(Environment!H59=0,0,H82/Environment!H59)","v":0},{"$f":"IF(Environment!I59=0,0,I82/Environment!I59)","v":0},{"$f":"IF(Environment!J59=0,0,J82/Environment!J59)","v":0},{"$f":"IF(Environment!K59=0,0,K82/Environment!K59)","v":0},{"$f":"IF(Environment!L59=0,0,L82/Environment!L59)","v":0},{"$f":"IF(Environment!M59=0,0,M82/Environment!M59)","v":0},{"$f":"IF(Environment!N59=0,0,N82/Environment!N59)","v":0}]
[null,"Fleet unscheduled repairs cost in reference period (USD)",{"$nulls":12},0,{"$nulls":10},"C2.2: Diesel cost per kilometer  (USD/Km)(country level)",{"$f":"IF(Environment!C60=0,0,C83/Environment!C60)","v":0},{"$f":"IF(Environment!D60=0,0,D83/Environment!D60)","v":0},{"$f":"IF(Environment!E60=0,0,E83/Environment!E60)","v":0},{"$f":"IF(Environment!F60=0,0,F83/Environment!F60)","v":0},{"$f":"IF(Environment!G60=0,0,G83/Environment!G60)","v":0},{"$f":"IF(Environment!H60=0,0,H83/Environment!H60)","v":0},{"$f":"IF(Environment!I60=0,0,I83/Environment!I60)","v":0},{"$f":"IF(Environment!J60=0,0,J83/Environment!J60)","v":0},{"$f":"IF(Environment!K60=0,0,K83/Environment!K60)","v":0},{"$f":"IF(Environment!L60=0,0,L83/Environment!L60)","v":0},{"$f":"IF(Environment!M60=0,0,M83/Environment!M60)","v":0},{"$f":"IF(Environment!N60=0,0,N83/Environment!N60)","v":0}]
[null,"Fleet gasoline fuel cost in reference period (USD)",{"$nulls":12},0]
[null,"Fleet diesel fuel cost in reference period (USD)",{"$nulls":12},0]
["Overhead costs","Personnel cost (drivers) in the reference period (USD)",{"$nulls":12},0]
[null,"Personnel cost (management related to fleet) in the reference period (USD)",{"$nulls":12},0]
[null,"Personnel cost  (other staff related to fleet) in the reference period",{"$nulls":12},0]
[null,"Facility costs in the reference period (USD)",{"$nulls":12},0]
[null,"Other costs in the reference period (USD)",{"$nulls":12},0]
[null,null,"Data Input for PIs"]
["Various data","Average Purchasing cost per vehicle type (USD)"]
[null,"Average replacement age per vehicle (years)"]
[null,"Average disposal cost per vehicle (country level)"]
[null,"Average sales price per vehicle",{"$nulls":23},"C13.1: Scheduled maintenance cost per vehicle (USD) (country level)",{"$f":"IF(Environment!C64=0,0,C80/Environment!C64)","v":0},{"$f":"IF(Environment!D64=0,0,D80/Environment!D64)","v":0},{"$f":"IF(Environment!E64=0,0,E80/Environment!E64)","v":0},{"$f":"IF(Environment!F64=0,0,F80/Environment!F64)","v":0},{"$f":"IF(Environment!G64=0,0,G80/Environment!G64)","v":0},{"$f":"IF(Environment!H64=0,0,H80/Environment!H64)","v":0},{"$f":"IF(Environment!I64=0,0,I80/Environment!I64)","v":0},{"$f":"IF(Environment!J64=0,0,J80/Environment!J64)","v":0},{"$f":"IF(Environment!K64=0,0,K80/Environment!K64)","v":0},{"$f":"IF(Environment!L64=0,0,L80/Environment!L64)","v":0},{"$f":"IF(Environment!M64=0,0,M80/Environment!M64)","v":0},{"$f":"IF(Environment!N64=0,0,N80/Environment!N64)","v":0}]
[null,"Total number of vehicles rented",{"$nulls":12},{"$f":"IF(Safety!O95=0,0,(C94*12+(D94-C94)*11+(E94-D94)*10+(F94-E94)*9+(G94-F94)*8+(H94-G94)*7+(I94-H94)*6+(J94-I94)*5+(K94-J94)*4+(L94-K94)*3+(M94-L94)*2+(N94-M94))/Safety!O95)","v":0},{"$nulls":10},"C13.2 Unscheduled repair cost per vehicle (USD) (country level)",{"$f":"IF(Environment!C64=0,0,C81/Environment!C64)","v":0},{"$f":"IF(Environment!D64=0,0,D81/Environment!D64)","v":0},{"$f":"IF(Environment!E64=0,0,E81/Environment!E64)","v":0},{"$f":"IF(Environment!F64=0,0,F81/Environment!F64)","v":0},{"$f":"IF(Environment!G64=0,0,G81/Environment!G64)","v":0},{"$f":"IF(Environment!H64=0,0,H81/Environment!H64)","v":0},{"$f":"IF(Environment!I64=0,0,I81/Environment!I64)","v":0},{"$f":"IF(Environment!J64=0,0,J81/Environment!J64)","v":0},{"$f":"IF(Environment!K64=0,0,K81/Environment!K64)","v":0},{"$f":"IF(Environment!L64=0,0,L81/Environment!L64)","v":0},{"$f":"IF(Environment!M64=0,0,M81/Environment!M64)","v":0},{"$f":"IF(Environment!N64=0,0,N81/Environment!N64)","v":0}]
[null,"Total programme costs served by the fleet in the reference period",{"$nulls":12},{"$f":"SUM(C95:N95)","v":0},{"$nulls":10},"C14: Average insurance premium per vehicle (USD) (country level)",{"$f":"IF(Environment!C64-C94=0,0,C78/(Environment!C64-C94))","v":0},{"$f":"IF(Environment!D64-D94=0,0,D78/(Environment!D64-D94))","v":0},{"$f":"IF(Environment!E64-E94=0,0,E78/(Environment!E64-E94))","v":0},{"$f":"IF(Environment!F64-F94=0,0,F78/(Environment!F64-F94))","v":0},{"$f":"IF(Environment!G64-G94=0,0,G78/(Environment!G64-G94))","v":0},{"$f":"IF(Environment!H64-H94=0,0,H78/(Environment!H64-H94))","v":0},{"$f":"IF(Environment!I64-I94=0,0,I78/(Environment!I64-I94))","v":0},{"$f":"IF(Environment!J64-J94=0,0,J78/(Environment!J64-J94))","v":0},{"$f":"IF(Environment!K64-K94=0,0,K78/(Environment!K64-K94))","v":0},{"$f":"IF(Environment!L64-L94=0,0,L78/(Environment!L64-L94))","v":0},{"$f":"IF(Environment!M64-M94=0,0,M78/(Environment!M64-M94))","v":0},{"$f":"IF(Environment!N64-N94=0,0,N78/(Environment!N64-N94))","v":0}]
[{"$nulls":25},"C19: Total fleet costs as % of the Programme costs",{"$f":"IF(SUM(C77:C88)=0,0,SUM(C77:C88)/C95)","v":0},0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Effectiveness","index":3,"n_rows":51,"n_cols":41,"rows_kept":51,"merged":[[1,5,1,17],[2,1,2,13],[2,14,2,16],[3,1,3,4],[4,0,5,0],[4,1,4,4],[5,1,5,4],[6,14,6,16],[7,0,11,0],[7,1,7,4],[8,1,8,4],[9,1,9,4],[10,1,10,16],[11,1,11,16],[14,5,14,17],[15,1,15,13],[15,14,15,16],[16,1,16,4],[17,0,18,0],[17,1,17,4],[18,1,18,4],[19,14,19,16],[20,0,24,0],[20,1,20,4],[21,1,21,4],[22,1,22,4],[23,1,23,16],[24,1,24,16],[27,5,27,17],[28,1,28,13],[28,14,28,16],[29,1,29,4],[30,0,31,0],[30,1,30,4],[31,1,31,4],[32,14,32,16],[33,0,37,0],[33,1,33,4],[34,1,34,4],[35,1,35,4],[36,1,36,16],[37,1,37,16],[40,5,40,17],[41,1,41,13],[41,14,41,16],[42,1,42,4],[43,0,44,0],[43,1,43,4],[44,1,44,4],[45,14,45,16],[46,0,50,0],[46,1,46,4],[47,1,47,4],[48,1,48,4],[49,1,49,16],[50,1,50,16]]}
[]
[{"$nulls":5},2013]
[2013,"Effectivenes: increased programme delivery",{"$nulls":12},"Data Input for KPIs",{"$nulls":6},"Comments",null,"KPIs",{"$nulls":10},2013]
[{"$nulls":5},"January","February","March","April","May","June","July","August","September","October","November","December","Total",2014,2015,2016,null,null,2013,2014,2015,2016,null,null,"January","February","March","April","May","June","July","August","September","October","November","December"]
["Trips","Number of trips made",{"$nulls":15},{"$f":"IF(Safety!O$5=0,0,SUM(F5:Q5)*12/Safety!O$5)","v":0},{"$f":"R18","v":0},{"$f":"R31","v":0},{"$f":"R44","v":0},null,"Effectiveness KPIef1 Number of trips made/ number of trip requests",{"$f":"IF(R6=0,0,R5/R6)","v":{"v":0,"d":"0.00%"}},{"$f":"IF(S6=0,0,S5/S6)","v":{"v":0,"d":"0.00%"}},{"$f":"IF(T6=0,0,T5/T6)","v":{"v":0,"d":"0.00%"}},{"$f":"IF(U6=0,0,U5/U6)","v":{"v":0,"d":"0.00%"}},null,"Effectiveness KPIef1 Number of trips made/ number of trip requests",{"$f":"IF(F6=0,0,F5/F6)","v":0},{"$f":"IF(G6=0,0,G5/G6)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Number of trip requests ",{"$nulls":15},{"$f":"IF(Safety!O$5=0,0,SUM(F6:Q6)*12/Safety!O$5)","v":0},{"$f":"R19","v":0},{"$f":"R32","v":0},{"$f":"R45","v":0},null,"Effectiveness KPIef2 Number of trip requests per year",{"$f":"IF(Safety!O5=0,0,R6*12/Safety!O5)","v":0},{"$f":"IF(Safety!P5=0,0,S6*12/Safety!P5)","v":0},{"$f":"IF(Safety!Q5=0,0,T6*12/Safety!Q5)","v":0},{"$f":"IF(Safety!R5=0,0,U6*12/Safety!R5)","v":0},null,"Effectiveness KPIef2 Number of trip requests ",{"$f":"F6","v":0},{"$f":"G6","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":14},"Data Input for PIs",{"$nulls":8},"PIs"]
["Vehicle data","Average downtime per vehicle (days)",{"$nulls":15},{"$f":"IF(Safety!O$5=0,0,SUM(F8:Q8)*12/Safety!O$5)","v":0},{"$f":"R21","v":0},{"$f":"R34","v":0},{"$f":"R47","v":0},null,"Ef1: Vehicle Availability (%): Total days available/Number of working days",{"$f":"IF(Safety!O6=0,0,1-R8/Safety!O6)","v":{"v":0,"d":"0%"}},{"$f":"IF(Safety!P6=0,0,1-S8/Safety!P6)","v":{"v":0,"d":"0%"}},{"$f":"IF(Safety!Q6=0,0,1-T8/Safety!Q6)","v":{"v":0,"d":"0%"}},{"$f":"IF(Safety!R6=0,0,1-U8/Safety!R6)","v":{"v":0,"d":"0%"}},null,"Ef1: Vehicle Availability (%): Total days available/Number of working days",{"$f":"IF(Safety!C6=0,0,1-F8/Safety!C6)","v":0},{"$f":"IF(Safety!D6=0,0,1-G8/Safety!D6)","v":0},{"$f":"IF(Safety!E6=0,0,1-H8/Safety!E6)","v":0},{"$f":"IF(Safety!F6=0,0,1-I8/Safety!F6)","v":0},{"$f":"IF(Safety!G6=0,0,1-J8/Safety!G6)","v":0},{"$f":"IF(Safety!H6=0,0,1-K8/Safety!H6)","v":0},{"$f":"IF(Safety!I6=0,0,1-L8/Safety!I6)","v":0},{"$f":"IF(Safety!J6=0,0,1-M8/Safety!J6)","v":0},{"$f":"IF(Safety!K6=0,0,1-N8/Safety!K6)","v":0},{"$f":"IF(Safety!L6=0,0,1-O8/Safety!L6)","v":0},{"$f":"IF(Safety!M6=0,0,1-P8/Safety!M6)","v":0},{"$f":"IF(Safety!N6=0,0,1-Q8/Safety!N6)","v":0}]
[null,"Average idle time per vehicle (days)",{"$nulls":15},{"$f":"IF(Safety!O$5=0,0,SUM(F9:Q9)*12/Safety!O$5)","v":0},{"$nulls":4},"Ef2: Vehicle use (%): Total days used/Total days available",{"$f":"IF(Safety!O6*R8=0,0,R10/(Safety!O6-R8))","v":{"v":0,"d":"0%"}},{"$f":"IF(Safety!P6*S8=0,0,S10/(Safety!P6-S8))","v":{"v":0,"d":"0%"}},{"$f":"IF(Safety!Q6*T8=0,0,T10/(Safety!Q6-T8))","v":{"v":0,"d":"0%"}},{"$f":"IF(Safety!R6*U8=0,0,U10/(Safety!R6-U8))","v":{"v":0,"d":"0%"}},null,"Ef2: Vehicle use (%): Total days used/Total days available",{"$f":"IF((Safety!C6-F8)=0,0,F10/(Safety!C6-F8))","v":0},{"$f":"IF((Safety!D6-G8)=0,0,G10/(Safety!D6-G8))","v":0},{"$f":"IF((Safety!E6-H8)=0,0,H10/(Safety!E6-H8))","v":0},{"$f":"IF((Safety!F6-I8)=0,0,I10/(Safety!F6-I8))","v":0},{"$f":"IF((Safety!G6-J8)=0,0,J10/(Safety!G6-J8))","v":0},{"$f":"IF((Safety!H6-K8)=0,0,K10/(Safety!H6-K8))","v":0},{"$f":"IF((Safety!I6-L8)=0,0,L10/(Safety!I6-L8))","v":0},{"$f":"IF((Safety!J6-M8)=0,0,M10/(Safety!J6-M8))","v":0},{"$f":"IF((Safety!K6-N8)=0,0,N10/(Safety!K6-N8))","v":0},{"$f":"IF((Safety!L6-O8)=0,0,O10/(Safety!L6-O8))","v":0},{"$f":"IF((Safety!M6-P8)=0,0,P10/(Safety!M6-P8))","v":0},{"$f":"IF((Safety!N6-Q8)=0,0,Q10/(Safety!N6-Q8))","v":0}]
[null,"Average use time per vehicle  (days)",{"$nulls":15},{"$f":"IF(Safety!O$5=0,0,SUM(F10:Q10)*12/Safety!O$5)","v":0},{"$f":"R23","v":0},{"$f":"R36","v":0},{"$f":"R49","v":0},null,"Ef3: Maintenance done on time according to maintenance schedule (%) ",{"$f":"Safety!U30","v":{"v":0,"d":"0%"}},{"$f":"Safety!V30","v":{"v":0,"d":"0%"}},{"$f":"Safety!W30","v":{"v":0,"d":"0%"}},{"$f":"Safety!X30","v":{"v":0,"d":"0%"}}]
[null,"Average procurement time per vehicle (weeks)",{"$nulls":16},{"$f":"R24","v":0},{"$f":"R37","v":0},{"$f":"R50","v":0},null,"Ef4.1 Number of fatal accidents during reference period",{"$f":"Safety!O11","v":0},{"$f":"Safety!P11","v":0},{"$f":"Safety!Q11","v":0},{"$f":"Safety!R11","v":0}]
[null,"Procurement of vehicles on time according to the policy schedule (%)",{"$nulls":16},{"$f":"R25","v":0},{"$f":"R38","v":0},{"$f":"R51","v":0},null,"Ef4.2 Number of injury-only accidents during reference period",{"$f":"Safety!O12","v":0},{"$f":"Safety!P12","v":0},{"$f":"Safety!Q12","v":0},{"$f":"Safety!R12","v":0}]
[{"$nulls":22},"Ef4.3 Number of damage-only accidents during reference period",{"$f":"Safety!O13","v":0},{"$f":"Safety!P13","v":0},{"$f":"Safety!Q13","v":0},{"$f":"Safety!R13","v":0}]
[{"$nulls":22},"Ef5: Average procurement time per vehicle (weeks)",{"$f":"R11","v":0},0,0,0]
[{"$nulls":5},2014,{"$nulls":16},"Ef6: Procurement of vehicles on time according to the policy schedule (%)",{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[2014,"Effectivenes: increased programme delivery",{"$nulls":12},"Data Input for KPIs",{"$nulls":19},2014]
[{"$nulls":5},"January","February","March","April","May","June","July","August","September","October","November","December","Total",{"$nulls":11},"January","February","March","April","May","June","July","August","September","October","November","December"]
["Trips","Number of trips made",{"$nulls":15},{"$f":"IF(Safety!O$35=0,0,SUM(F18:Q18)*12/Safety!O$35)","v":0},{"$nulls":10},"Effectiveness KPIef1 Number of trips made/ number of trip requests",{"$f":"IF(F19=0,0,F18/F19)","v":0},{"$f":"IF(G19=0,0,G18/G19)","v":0},{"$f":"IF(H19=0,0,H18/H19)","v":0},{"$f":"IF(I19=0,0,I18/I19)","v":0},{"$f":"IF(J19=0,0,J18/J19)","v":0},{"$f":"IF(K19=0,0,K18/K19)","v":0},{"$f":"IF(L19=0,0,L18/L19)","v":0},{"$f":"IF(M19=0,0,M18/M19)","v":0},{"$f":"IF(N19=0,0,N18/N19)","v":0},{"$f":"IF(O19=0,0,O18/O19)","v":0},{"$f":"IF(P19=0,0,P18/P19)","v":0},{"$f":"IF(Q19=0,0,Q18/Q19)","v":0}]
[null,"Number of trip requests ",{"$nulls":15},{"$f":"IF(Safety!O$35=0,0,SUM(F19:Q19)*12/Safety!O$35)","v":0},{"$nulls":10},"Effectiveness KPIef2 Number of trip requests ",{"$f":"F19","v":0},{"$f":"G19","v":0},{"$f":"H19","v":0},{"$f":"I19","v":0},{"$f":"J19","v":0},{"$f":"K19","v":0},{"$f":"L19","v":0},{"$f":"M19","v":0},{"$f":"N19","v":0},{"$f":"O19","v":0},{"$f":"P19","v":0},{"$f":"Q19","v":0}]
[{"$nulls":14},"Data Input for PIs"]
["Vehicle data","Average downtime per vehicle (days)",{"$nulls":15},{"$f":"IF(Safety!O$35=0,0,SUM(F21:Q21)*12/Safety!O$35)","v":0},{"$nulls":10},"Ef1: Vehicle Availability (%): Total days available/Number of working days",{"$f":"IF(Safety!C36=0,0,1-F21/Safety!C36)","v":0},{"$f":"IF(Safety!D36=0,0,1-G21/Safety!D36)","v":0},{"$f":"IF(Safety!E36=0,0,1-H21/Safety!E36)","v":0},{"$f":"IF(Safety!F36=0,0,1-I21/Safety!F36)","v":0},{"$f":"IF(Safety!G36=0,0,1-J21/Safety!G36)","v":0},{"$f":"IF(Safety!H36=0,0,1-K21/Safety!H36)","v":0},{"$f":"IF(Safety!I36=0,0,1-L21/Safety!I36)","v":0},{"$f":"IF(Safety!J36=0,0,1-M21/Safety!J36)","v":0},{"$f":"IF(Safety!K36=0,0,1-N21/Safety!K36)","v":0},{"$f":"IF(Safety!L36=0,0,1-O21/Safety!L36)","v":0},{"$f":"IF(Safety!M36=0,0,1-P21/Safety!M36)","v":0},{"$f":"IF(Safety!N36=0,0,1-Q21/Safety!N36)","v":0}]
[null,"Average idle time per vehicle (days)",{"$nulls":15},{"$f":"IF(Safety!O$35=0,0,SUM(F22:Q22)*12/Safety!O$35)","v":0},{"$nulls":10},"Ef2: Vehicle use (%): Total days used/Total days available",{"$f":"IF((Safety!C36-F21)=0,0,F23/(Safety!C36-F21))","v":0},{"$f":"IF((Safety!D36-G21)=0,0,G23/(Safety!D36-G21))","v":0},{"$f":"IF((Safety!E36-H21)=0,0,H23/(Safety!E36-H21))","v":0},{"$f":"IF((Safety!F36-I21)=0,0,I23/(Safety!F36-I21))","v":0},{"$f":"IF((Safety!G36-J21)=0,0,J23/(Safety!G36-J21))","v":0},{"$f":"IF((Safety!H36-K21)=0,0,K23/(Safety!H36-K21))","v":0},{"$f":"IF((Safety!I36-L21)=0,0,L23/(Safety!I36-L21))","v":0},{"$f":"IF((Safety!J36-M21)=0,0,M23/(Safety!J36-M21))","v":0},{"$f":"IF((Safety!K36-N21)=0,0,N23/(Safety!K36-N21))","v":0},{"$f":"IF((Safety!L36-O21)=0,0,O23/(Safety!L36-O21))","v":0},{"$f":"IF((Safety!M36-P21)=0,0,P23/(Safety!M36-P21))","v":0},{"$f":"IF((Safety!N36-Q21)=0,0,Q23/(Safety!N36-Q21))","v":0}]
[null,"Average use time per vehicle  (days)",{"$nulls":15},{"$f":"IF(Safety!O$35=0,0,SUM(F23:Q23)*12/Safety!O$35)","v":0}]
[null,"Average procurement time per vehicle (weeks)"]
[null,"Procurement of vehicles on time according to the policy schedule (%)"]
[]
[]
[{"$nulls":5},2015]
[2015,"Effectivenes: increased programme delivery",{"$nulls":12},"Data Input for KPIs",{"$nulls":19},2015]
[{"$nulls":5},"January","February","March","April","May","June","July","August","September","October","November","December","Total",{"$nulls":11},"January","February","March","April","May","June","July","August","September","October","November","December"]
["Trips","Number of trips made",{"$nulls":15},{"$f":"IF(Safety!O$65=0,0,SUM(F31:Q31)*12/Safety!O$65)","v":0},{"$nulls":10},"Effectiveness KPIef1 Number of trips made/ number of trip requests",{"$f":"IF(F32=0,0,F31/F32)","v":0},{"$f":"IF(G32=0,0,G31/G32)","v":0},{"$f":"IF(H32=0,0,H31/H32)","v":0},{"$f":"IF(I32=0,0,I31/I32)","v":0},{"$f":"IF(J32=0,0,J31/J32)","v":0},{"$f":"IF(K32=0,0,K31/K32)","v":0},{"$f":"IF(L32=0,0,L31/L32)","v":0},{"$f":"IF(M32=0,0,M31/M32)","v":0},{"$f":"IF(N32=0,0,N31/N32)","v":0},{"$f":"IF(O32=0,0,O31/O32)","v":0},{"$f":"IF(P32=0,0,P31/P32)","v":0},{"$f":"IF(Q32=0,0,Q31/Q32)","v":0}]
[null,"Number of trip requests ",{"$nulls":15},{"$f":"IF(Safety!O$65=0,0,SUM(F32:Q32)*12/Safety!O$65)","v":0},{"$nulls":10},"Effectiveness KPIef2 Number of trip requests ",{"$f":"F32","v":0},{"$f":"G32","v":0},{"$f":"H32","v":0},{"$f":"I32","v":0},{"$f":"J32","v":0},{"$f":"K32","v":0},{"$f":"L32","v":0},{"$f":"M32","v":0},{"$f":"N32","v":0},{"$f":"O32","v":0},{"$f":"P32","v":0},{"$f":"Q32","v":0}]
[{"$nulls":14},"Data Input for PIs"]
["Vehicle data","Average downtime per vehicle (days)",{"$nulls":15},{"$f":"IF(Safety!O$65=0,0,SUM(F34:Q34)*12/Safety!O$65)","v":0},{"$nulls":10},"Ef1: Vehicle Availability (%): Total days available/Number of working days",{"$f":"IF(Safety!C66=0,0,1-F34/Safety!C66)","v":0},{"$f":"IF(Safety!D66=0,0,1-G34/Safety!D66)","v":0},{"$f":"IF(Safety!E66=0,0,1-H34/Safety!E66)","v":0},{"$f":"IF(Safety!F66=0,0,1-I34/Safety!F66)","v":0},{"$f":"IF(Safety!G66=0,0,1-J34/Safety!G66)","v":0},{"$f":"IF(Safety!H66=0,0,1-K34/Safety!H66)","v":0},{"$f":"IF(Safety!I66=0,0,1-L34/Safety!I66)","v":0},{"$f":"IF(Safety!J66=0,0,1-M34/Safety!J66)","v":0},{"$f":"IF(Safety!K66=0,0,1-N34/Safety!K66)","v":0},{"$f":"IF(Safety!L66=0,0,1-O34/Safety!L66)","v":0},{"$f":"IF(Safety!M66=0,0,1-P34/Safety!M66)","v":0},{"$f":"IF(Safety!N66=0,0,1-Q34/Safety!N66)","v":0}]
[null,"Average idle time per vehicle (days)",{"$nulls":15},{"$f":"IF(Safety!O$65=0,0,SUM(F35:Q35)*12/Safety!O$65)","v":0},{"$nulls":10},"Ef2: Vehicle use (%): Total days used/Total days available",{"$f":"IF((Safety!C66-F34)=0,0,F36/(Safety!C66-F34))","v":0},{"$f":"IF((Safety!D66-G34)=0,0,G36/(Safety!D66-G34))","v":0},{"$f":"IF((Safety!E66-H34)=0,0,H36/(Safety!E66-H34))","v":0},{"$f":"IF((Safety!F66-I34)=0,0,I36/(Safety!F66-I34))","v":0},{"$f":"IF((Safety!G66-J34)=0,0,J36/(Safety!G66-J34))","v":0},{"$f":"IF((Safety!H66-K34)=0,0,K36/(Safety!H66-K34))","v":0},{"$f":"IF((Safety!I66-L34)=0,0,L36/(Safety!I66-L34))","v":0},{"$f":"IF((Safety!J66-M34)=0,0,M36/(Safety!J66-M34))","v":0},{"$f":"IF((Safety!K66-N34)=0,0,N36/(Safety!K66-N34))","v":0},{"$f":"IF((Safety!L66-O34)=0,0,O36/(Safety!L66-O34))","v":0},{"$f":"IF((Safety!M66-P34)=0,0,P36/(Safety!M66-P34))","v":0},{"$f":"IF((Safety!N66-Q34)=0,0,Q36/(Safety!N66-Q34))","v":0}]
[null,"Average use time per vehicle  (days)",{"$nulls":15},{"$f":"IF(Safety!O$65=0,0,SUM(F36:Q36)*12/Safety!O$65)","v":0}]
[null,"Average procurement time per vehicle (weeks)"]
[null,"Procurement of vehicles on time according to the policy schedule (%)"]
[]
[]
[{"$nulls":5},2016]
[2016,"Effectivenes: increased programme delivery",{"$nulls":12},"Data Input for KPIs",{"$nulls":19},2016]
[{"$nulls":5},"January","February","March","April","May","June","July","August","September","October","November","December","Total",{"$nulls":11},"January","February","March","April","May","June","July","August","September","October","November","December"]
["Trips","Number of trips made",{"$nulls":15},{"$f":"IF(Safety!O$95=0,0,SUM(F44:Q44)*12/Safety!O$95)","v":0},{"$nulls":10},"Effectiveness KPIef1 Number of trips made/ number of trip requests",{"$f":"IF(F45=0,0,F44/F45)","v":0},{"$f":"IF(G45=0,0,G44/G45)","v":0},{"$f":"IF(H45=0,0,H44/H45)","v":0},{"$f":"IF(I45=0,0,I44/I45)","v":0},{"$f":"IF(J45=0,0,J44/J45)","v":0},{"$f":"IF(K45=0,0,K44/K45)","v":0},{"$f":"IF(L45=0,0,L44/L45)","v":0},{"$f":"IF(M45=0,0,M44/M45)","v":0},{"$f":"IF(N45=0,0,N44/N45)","v":0},{"$f":"IF(O45=0,0,O44/O45)","v":0},{"$f":"IF(P45=0,0,P44/P45)","v":0},{"$f":"IF(Q45=0,0,Q44/Q45)","v":0}]
[null,"Number of trip requests ",{"$nulls":15},{"$f":"IF(Safety!O$95=0,0,SUM(F45:Q45)*12/Safety!O$95)","v":0},{"$nulls":10},"Effectiveness KPIef2 Number of trip requests ",{"$f":"F45","v":0},{"$f":"G45","v":0},{"$f":"H45","v":0},{"$f":"I45","v":0},{"$f":"J45","v":0},{"$f":"K45","v":0},{"$f":"L45","v":0},{"$f":"M45","v":0},{"$f":"N45","v":0},{"$f":"O45","v":0},{"$f":"P45","v":0},{"$f":"Q45","v":0}]
[{"$nulls":14},"Data Input for PIs"]
["Vehicle data","Average downtime per vehicle (days)",{"$nulls":15},{"$f":"IF(Safety!O$95=0,0,SUM(F47:Q47)*12/Safety!O$95)","v":0},{"$f":"IF(Safety!P$95=0,0,SUM(G47:R47)*12/Safety!P$95)","v":0},{"$f":"IF(Safety!Q$95=0,0,SUM(H47:S47)*12/Safety!Q$95)","v":0},{"$f":"IF(Safety!R$95=0,0,SUM(I47:T47)*12/Safety!R$95)","v":0},{"$nulls":7},"Ef1: Vehicle Availability (%): Total days available/Number of working days",{"$f":"IF(Safety!C96=0,0,1-F47/Safety!C96)","v":0},{"$f":"IF(Safety!D96=0,0,1-G47/Safety!D96)","v":0},{"$f":"IF(Safety!E96=0,0,1-H47/Safety!E96)","v":0},{"$f":"IF(Safety!F96=0,0,1-I47/Safety!F96)","v":0},{"$f":"IF(Safety!G96=0,0,1-J47/Safety!G96)","v":0},{"$f":"IF(Safety!H96=0,0,1-K47/Safety!H96)","v":0},{"$f":"IF(Safety!I96=0,0,1-L47/Safety!I96)","v":0},{"$f":"IF(Safety!J96=0,0,1-M47/Safety!J96)","v":0},{"$f":"IF(Safety!K96=0,0,1-N47/Safety!K96)","v":0},{"$f":"IF(Safety!L96=0,0,1-O47/Safety!L96)","v":0},{"$f":"IF(Safety!M96=0,0,1-P47/Safety!M96)","v":0},{"$f":"IF(Safety!N96=0,0,1-Q47/Safety!N96)","v":0}]
[null,"Average idle time per vehicle (days)",{"$nulls":15},{"$f":"IF(Safety!O$95=0,0,SUM(F48:Q48)*12/Safety!O$95)","v":0},{"$nulls":10},"Ef2: Vehicle use (%): Total days used/Total days available",{"$f":"IF((Safety!C96-F47)=0,0,F49/(Safety!C96-F47))","v":0},{"$f":"IF((Safety!D96-G47)=0,0,G49/(Safety!D96-G47))","v":0},{"$f":"IF((Safety!E96-H47)=0,0,H49/(Safety!E96-H47))","v":0},{"$f":"IF((Safety!F96-I47)=0,0,I49/(Safety!F96-I47))","v":0},{"$f":"IF((Safety!G96-J47)=0,0,J49/(Safety!G96-J47))","v":0},{"$f":"IF((Safety!H96-K47)=0,0,K49/(Safety!H96-K47))","v":0},{"$f":"IF((Safety!I96-L47)=0,0,L49/(Safety!I96-L47))","v":0},{"$f":"IF((Safety!J96-M47)=0,0,M49/(Safety!J96-M47))","v":0},{"$f":"IF((Safety!K96-N47)=0,0,N49/(Safety!K96-N47))","v":0},{"$f":"IF((Safety!L96-O47)=0,0,O49/(Safety!L96-O47))","v":0},{"$f":"IF((Safety!M96-P47)=0,0,P49/(Safety!M96-P47))","v":0},{"$f":"IF((Safety!N96-Q47)=0,0,Q49/(Safety!N96-Q47))","v":0}]
[null,"Average use time per vehicle  (days)",{"$nulls":15},{"$f":"IF(Safety!O$95=0,0,SUM(F49:Q49)*12/Safety!O$95)","v":0}]
[null,"Average procurement time per vehicle (weeks)"]
[null,"Procurement of vehicles on time according to the policy schedule (%)"]

{"sheet":"Vehicle data","index":4,"n_rows":53,"n_cols":9,"rows_kept":53,"hidden":true}
[]
[]
[null,"Vehicle Type","Age (months)","Mileage (km)","Km in reference period","Fuel","Fuel Emissions Factor kg CO2/lt","Fuel consumption in reference period (lt)","CO2 emissions in reference period (kgCO2)"]
["Vehicle 1",{"$nulls":4},"Gasoline",{"$f":"IF(F4=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F4=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F4=\"LPG\",Sheet2!E$10,IF(F4=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},100,{"$f":"IF(F4=\"Electric\",0,H4*G4)","v":238.22}]
["Vehicle 2",{"$nulls":4},"Gasoline",{"$f":"IF(F5=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F5=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F5=\"LPG\",Sheet2!E$10,IF(F5=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,{"$f":"IF(F5=\"Electric\",0,H5*G5)","v":0}]
["Vehicle 3",{"$nulls":4},"Gasoline",{"$f":"IF(F6=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F6=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F6=\"LPG\",Sheet2!E$10,IF(F6=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 4",{"$nulls":4},"Gasoline",{"$f":"IF(F7=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F7=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F7=\"LPG\",Sheet2!E$10,IF(F7=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 5",{"$nulls":4},"Gasoline",{"$f":"IF(F8=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F8=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F8=\"LPG\",Sheet2!E$10,IF(F8=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 6",{"$nulls":4},"Gasoline",{"$f":"IF(F9=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F9=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F9=\"LPG\",Sheet2!E$10,IF(F9=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 7",{"$nulls":4},"Gasoline",{"$f":"IF(F10=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F10=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F10=\"LPG\",Sheet2!E$10,IF(F10=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 8",{"$nulls":4},"Gasoline",{"$f":"IF(F11=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F11=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F11=\"LPG\",Sheet2!E$10,IF(F11=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 9",{"$nulls":4},"Gasoline",{"$f":"IF(F12=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F12=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F12=\"LPG\",Sheet2!E$10,IF(F12=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 10",{"$nulls":4},"Gasoline",{"$f":"IF(F13=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F13=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F13=\"LPG\",Sheet2!E$10,IF(F13=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 11",{"$nulls":4},"Gasoline",{"$f":"IF(F14=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F14=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F14=\"LPG\",Sheet2!E$10,IF(F14=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 12",{"$nulls":4},"Gasoline",{"$f":"IF(F15=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F15=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F15=\"LPG\",Sheet2!E$10,IF(F15=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 13",{"$nulls":4},"Gasoline",{"$f":"IF(F16=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F16=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F16=\"LPG\",Sheet2!E$10,IF(F16=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 14",{"$nulls":4},"Gasoline",{"$f":"IF(F17=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F17=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F17=\"LPG\",Sheet2!E$10,IF(F17=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 15",{"$nulls":4},"Gasoline",{"$f":"IF(F18=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F18=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F18=\"LPG\",Sheet2!E$10,IF(F18=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 16",{"$nulls":4},"Gasoline",{"$f":"IF(F19=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F19=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F19=\"LPG\",Sheet2!E$10,IF(F19=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 17",{"$nulls":4},"Gasoline",{"$f":"IF(F20=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F20=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F20=\"LPG\",Sheet2!E$10,IF(F20=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 18",{"$nulls":4},"Gasoline",{"$f":"IF(F21=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F21=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F21=\"LPG\",Sheet2!E$10,IF(F21=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 19",{"$nulls":4},"Gasoline",{"$f":"IF(F22=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F22=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F22=\"LPG\",Sheet2!E$10,IF(F22=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 20",{"$nulls":4},"Gasoline",{"$f":"IF(F23=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F23=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F23=\"LPG\",Sheet2!E$10,IF(F23=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 21",{"$nulls":4},"Gasoline",{"$f":"IF(F24=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F24=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F24=\"LPG\",Sheet2!E$10,IF(F24=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 22",{"$nulls":4},"Gasoline",{"$f":"IF(F25=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F25=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F25=\"LPG\",Sheet2!E$10,IF(F25=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 23",{"$nulls":4},"Gasoline",{"$f":"IF(F26=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F26=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F26=\"LPG\",Sheet2!E$10,IF(F26=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 24",{"$nulls":4},"Gasoline",{"$f":"IF(F27=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F27=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F27=\"LPG\",Sheet2!E$10,IF(F27=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 25",{"$nulls":4},"Gasoline",{"$f":"IF(F28=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F28=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F28=\"LPG\",Sheet2!E$10,IF(F28=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 26",{"$nulls":4},"Gasoline",{"$f":"IF(F29=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F29=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F29=\"LPG\",Sheet2!E$10,IF(F29=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 27",{"$nulls":4},"Gasoline",{"$f":"IF(F30=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F30=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F30=\"LPG\",Sheet2!E$10,IF(F30=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 28",{"$nulls":4},"Gasoline",{"$f":"IF(F31=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F31=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F31=\"LPG\",Sheet2!E$10,IF(F31=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 29",{"$nulls":4},"Gasoline",{"$f":"IF(F32=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F32=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F32=\"LPG\",Sheet2!E$10,IF(F32=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 30",{"$nulls":4},"Gasoline",{"$f":"IF(F33=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F33=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F33=\"LPG\",Sheet2!E$10,IF(F33=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 31",{"$nulls":4},"Gasoline",{"$f":"IF(F34=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F34=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F34=\"LPG\",Sheet2!E$10,IF(F34=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 32",{"$nulls":4},"Gasoline",{"$f":"IF(F35=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F35=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F35=\"LPG\",Sheet2!E$10,IF(F35=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 33",{"$nulls":4},"Gasoline",{"$f":"IF(F36=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F36=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F36=\"LPG\",Sheet2!E$10,IF(F36=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 34",{"$nulls":4},"Gasoline",{"$f":"IF(F37=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F37=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F37=\"LPG\",Sheet2!E$10,IF(F37=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 35",{"$nulls":4},"Gasoline",{"$f":"IF(F38=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F38=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F38=\"LPG\",Sheet2!E$10,IF(F38=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 36",{"$nulls":4},"Gasoline",{"$f":"IF(F39=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F39=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F39=\"LPG\",Sheet2!E$10,IF(F39=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 37",{"$nulls":4},"Gasoline",{"$f":"IF(F40=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F40=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F40=\"LPG\",Sheet2!E$10,IF(F40=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 38",{"$nulls":4},"Gasoline",{"$f":"IF(F41=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F41=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F41=\"LPG\",Sheet2!E$10,IF(F41=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 39",{"$nulls":4},"Gasoline",{"$f":"IF(F42=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F42=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F42=\"LPG\",Sheet2!E$10,IF(F42=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 40",{"$nulls":4},"Gasoline",{"$f":"IF(F43=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F43=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F43=\"LPG\",Sheet2!E$10,IF(F43=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 41",{"$nulls":4},"Gasoline",{"$f":"IF(F44=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F44=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F44=\"LPG\",Sheet2!E$10,IF(F44=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 42",{"$nulls":4},"Gasoline",{"$f":"IF(F45=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F45=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F45=\"LPG\",Sheet2!E$10,IF(F45=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 43",{"$nulls":4},"Gasoline",{"$f":"IF(F46=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F46=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F46=\"LPG\",Sheet2!E$10,IF(F46=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 44",{"$nulls":4},"Gasoline",{"$f":"IF(F47=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F47=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F47=\"LPG\",Sheet2!E$10,IF(F47=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 45",{"$nulls":4},"Gasoline",{"$f":"IF(F48=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F48=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F48=\"LPG\",Sheet2!E$10,IF(F48=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 46",{"$nulls":4},"Gasoline",{"$f":"IF(F49=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F49=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F49=\"LPG\",Sheet2!E$10,IF(F49=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 47",{"$nulls":4},"Gasoline",{"$f":"IF(F50=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F50=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F50=\"LPG\",Sheet2!E$10,IF(F50=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 48",{"$nulls":4},"Gasoline",{"$f":"IF(F51=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F51=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F51=\"LPG\",Sheet2!E$10,IF(F51=\"Hybrid\",Sheet2!E$8,0))))))","v":2.3822},null,0]
["Vehicle 49",{"$nulls":4},"Electric",{"$f":"IF(F52=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F52=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F52=\"LPG\",Sheet2!E$10,IF(F52=\"Hybrid\",Sheet2!E$8,0))))))","v":0},null,0]
["Vehicle 50",{"$nulls":4},"Electric",{"$f":"IF(F53=\"Gasoline\",Sheet2!E$8,(IF('Vehicle data'!F53=\"Diesel\",Sheet2!E$9,(IF('Vehicle data'!F53=\"LPG\",Sheet2!E$10,IF(F53=\"Hybrid\",Sheet2!E$8,0))))))","v":0},null,0]

{"sheet":"Sheet2","index":5,"n_rows":12,"n_cols":5,"rows_kept":12,"hidden":true}
[]
[]
[]
[]
[]
[]
[{"$nulls":3},"Fuel","kgCO2/lt"]
[{"$nulls":3},"Gasoline",2.3822]
[{"$nulls":3},"Diesel",{"v":2.74577,"d":"2.7458"}]
[{"$nulls":3},"LPG",{"v":1.57368,"d":"1.5737"}]
[{"$nulls":3},"Hybrid",{"v":0,"d":"0.0000"}]
[{"$nulls":3},"Electric",{"v":0,"d":"0.0000"}]

{"sheet":"Safety Graphs","index":6,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Environment Graphs","index":7,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Cost Graphs","index":8,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Effectiveness Graphs","index":9,"n_rows":0,"n_cols":0,"rows_kept":0}