{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Input Data","Report","CO2 emissions factor"],"not_rendered":{"charts":2,"images":14,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input Data","index":0,"n_rows":2000,"n_cols":21,"rows_kept":2000,"cut":false,"hidden":false,"merged":[[6,3,6,6],[7,3,7,6],[9,1,11,8],[12,1,17,8],[31,1,32,8],[1033,1,1033,8],[1009,1,1010,1],[1038,1,1039,1],[999,1,1000,8],[41,1,42,1]]}
[]
[]
[]
[]
[]
[]
[null,null,null,"ENERGY EFFICIENCY IN"]
[null,null,null,"GROUNDWATER SYSTEMS"]
[]
[]
[]
[]
[null,"DISCLAIMER: This tool provides information to asses the initial potential Energy, CO2 and financial savings replacing old cold groundwater pumps by a new energy efficient ones at a municipal cold water utility company level (not designed for the individual residential cold water consumers). If the results provided by this tool are under the interest of municipality and it wants to upgrade existing pumps, as a next step we recommned to reach the cold water pumps manufacturing companies, which will provide detailed model and price for every individual pump.\nThe function of the tool is merely informative and the C2E2 does not have any legal responsibility, interest or involvement in any of the technical nor financial recommendations that may be provided to the user. \nFor more information access our institutional webpage at https://unepccc.org/. "]
[]
[]
[]
[]
[]
[]
[null,"How to use this Tool:"]
[null,"Please fill data in yellow cels. Mandatory to fill data cells on a top have \"Mandatory to fill ↓\". Other data in yellow cells are not mandatory to fill."]
[]
[null,"Mandatory to fill data:"]
[null,null,"Mandatory to fill ↓",null,"Press \"Clear input data\" button",null,"Press \"Calculate\" button"]
[]
[]
[null,"Not mandatory to fill data:"]
[]
[]
[]
[]
[null,"INPUT DATA"]
[]
[]
[]
[]
[]
[null,"Country","Mozambique"]
[]
[]
[]
[null,"No.","How much water is extracted from underground","Water supply per day","Electricity price","Old pump age","Old pump age power capacity","Old pump IE class (1-4)","Initial investment for new pump, Eur"]
[null,null,"m3/month","h/day","Eur/MWh","Year","kW",null,"Eur"]
[null,null,"Mandatory to fill ↓","Mandatory to fill ↓","Mandatory to fill ↓","Year","kW"]
[null,1,1000,8,150,2,1,1,367.76875000000007]
[null,2,2000,8,150,15,20,2,735.53750000000014]
[null,3,10000,8,150,10,89.833333333333343,3,3677.6875]
[null,4,50000,8,150,10,179.66666666666669,4,18388.4375]
[null,5,100000,8,150,15,179.66666666666669,1]
[null,6,110000,8,150,15,179.66666666666669,2]
[null,7,120000,8,150,20,179.66666666666669,3]
[null,8,130000,8,150,20,179.66666666666669,4]
[null,9,140000,8,150,25,179.66666666666669,null,36776.875]
[null,10,250000,8,150,30,179.66666666666669,4]
[null,null,{"$f":"+SUM(C45:C54)","v":913000},{"$f":"IF(SUM(D45:D54)=0,\"\",+AVERAGE(D45:D54))","v":8},{"$f":"IF(SUM(E45:E54)=0,\"\",+AVERAGE(E45:E54))","v":150}]
[]
[]
[null,"*CO2 emission factors are based on IEA data."]
[null,"*This tool is developed with kind support of a Grunfoss pumps manufacturing company."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INPUT DATA"]
[]
[]
[]
[]
[]
[null,"Country","Mozambique"]
[]
[]
[]
[null,"No.","How much water is extracted from underground","Water supply per day","Electricity price","Old pump age","Old pump age power capacity","Old pump IE class (1-4)","Initial investment for new pump, Eur"]
[null,null,"m3/month","h/day","Eur/MWh","Year","kW",null,"Eur"]
[null,null,"Mandatory to fill ↓","Mandatory to fill ↓","Mandatory to fill ↓","Year","kW"]
[null,1,1000,8,150,2,1,1,367.76875000000007]
[null,2,2000,8,150,15,20,2,735.53750000000014]
[null,3,10000,8,150,10,89.833333333333343,3,3677.6875]
[null,4,50000,8,150,10,179.66666666666669,4,18388.4375]
[null,5,100000,8,150,15,179.66666666666669,1]
[null,6,110000,8,150,15,179.66666666666669,2]
[null,7,120000,8,150,20,179.66666666666669,3]
[null,8,130000,8,150,20,179.66666666666669,4]
[null,9,140000,8,150,25,179.66666666666669,null,36776.875]
[null,10,250000,8,150,30,179.66666666666669,4]
[null,null,{"$f":"+SUM(C1013:C1022)","v":913000},{"$f":"+AVERAGE(D1013:D1022)","v":8},{"$f":"+AVERAGE(E1013:E1022)","v":150}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"OUTPUT DATA"]
[]
[]
[null,null,null,null,null,null,null,null,"Electricity savings"]
[null,null,null,null,null,"Electricity savings","Electricity savings","Electricity savings",1.5,"Electricity savings"]
[null,"No.","Water flow rate","Specific energy consumption","Pump power capacity, calculated","Efficiency savings due to oversizing","Efficiency savings due to IE","Efficiency savings due to oversizing + IE","Efficiency savings due to age","Selected efficiency savings","Energy consumption for water extraction of old pump","Energy consumption for water extraction of new pump","Energy savings","Financial savings","Initial investment for equipment","Simple payback period","CO2 emissions factor","CO2 baseline scenarios","CO2 scenarios after upgrade","CO2 savings","CO2 savings"]
[null,null,"m3/h","kWh/m3","kW","%","%","%","%","%","MWh/year","MWh/year","MWh/year","Eur/year","Eur","Years","t/MWh","tCO2/year","tCO2/year","tCO2/year","%"]
[]
[null,1,{"$f":"+IF(OR(C1013=\"\",D1013=\"\"),\"\",C1013/30/D1013)","v":4.166666666666667},{"$f":"IF(C1042=\"\",\"\",0.2873*C1042^(-0.053))","v":0.26637092681577557},{"$f":"IF(C1042=\"\",\"\", 0.2156*C1042)","v":0.89833333333333343},{"$f":"IF(C1042=\"\",\"\", +IF(G1013/E1042<=1,0,IF(G1013/E1042<1.5,0.15,0.25)))","v":0.15},{"$f":"IF(C1042=\"\",\"\",+IF(OR(H1013=\"\",H1013=1),12.282*E1042^(-0.281)/100,IF(H1013=2,8.8703*E1042^(-0.285)/100,IF(H1013=3,4.7564*E1042^(-0.285)/100,IF(H1013=4,0,\"?\")))))","v":0.12657652001483391},{"$f":"+IF(C1042=\"\",\"\",F1042+G1042)","v":0.2765765200148339},{"$f":"+IF(C1042=\"\",\"\",IF(F1013=\"\",(20*$I$1038/100),IF(F1013<20,(F1013*$I$1038/100),(20*$I$1038/100))))","v":0.03},{"$f":"IF(C1042=\"\",\"\",+MAX(H1042,I1042))","v":0.2765765200148339},{"$f":"IF(C1042=\"\",\"\",+L1042*(1+J1042))","v":4.0805144494513046},{"$f":"IF(C1042=\"\",\"\",+C1013*D1042/1000*12)","v":3.1964511217893068},{"$f":"IF(C1042=\"\",\"\",+(K1042-L1042))","v":0.8840633276619978},{"$f":"IF(OR(C1042=\"\",E1013=\"\"),\"\",+M1042*E1013)","v":132.60949914929967},{"$f":"IF(OR(C1042=\"\",E1013=\"\"),\"\",IF(I1013=\"\",58.843*C1042,I1013))","v":367.76875000000007},{"$f":"IF(OR(C1042=\"\",E1013=\"\"),\"\",+O1042/N1042)","v":2.7733213107602808},{"$f":"IF(C1042=\"\",\"\",IFERROR(VLOOKUP($C$1006,'CO2 emissions factor'!$D$7:$E$164,2,FALSE),'CO2 emissions factor'!$E$165))","v":0.99580000000000002},{"$f":"IF(C1042=\"\",\"\",+Q1042*K1042)","v":4.0633762887636093},{"$f":"IF(C1042=\"\",\"\",+Q1042*L1042)","v":3.1830260270777919},{"$f":"IF(C1042=\"\",\"\",+R1042-S1042)","v":0.88035026168581743},{"$f":"IF(C1042=\"\",\"\",+S1042/R1042)","v":0.78334512997965855}]
[null,2,8.3333333333333339,{"$f":"IF(C1043=\"\",\"\",0.2873*C1043^(-0.053))","v":0.25676287627322747},{"$f":"IF(C1043=\"\",\"\", 0.2156*C1043)","v":1.7966666666666669},{"$f":"IF(C1043=\"\",\"\", +IF(G1014/E1043<=1,0,IF(G1014/E1043<1.5,0.15,0.25)))","v":0.25},{"$f":"IF(C1043=\"\",\"\",+IF(OR(H1014=\"\",H1014=1),12.282*E1043^(-0.281)/100,IF(H1014=2,8.8703*E1043^(-0.285)/100,IF(H1014=3,4.7564*E1043^(-0.285)/100,IF(H1014=4,0,\"?\")))))","v":7.5061124743206073E-2},{"$f":"+IF(C1043=\"\",\"\",F1043+G1043)","v":0.32506112474320609},{"$f":"+IF(C1043=\"\",\"\",IF(F1014=\"\",(20*$I$1038/100),IF(F1014<20,(F1014*$I$1038/100),(20*$I$1038/100))))","v":0.22500000000000001},{"$f":"IF(C1043=\"\",\"\",+MAX(H1043,I1043))","v":0.32506112474320609},{"$f":"IF(C1043=\"\",\"\",+L1043*(1+J1043))","v":8.1654361350456828},{"$f":"IF(C1043=\"\",\"\",+C1014*D1043/1000*12)","v":6.1623090305574593},{"$f":"IF(C1043=\"\",\"\",+(K1043-L1043))","v":2.0031271044882235},{"$f":"IF(OR(C1043=\"\",E1014=\"\"),\"\",+M1043*E1014)","v":300.4690656732335},{"$f":"IF(OR(C1043=\"\",E1014=\"\"),\"\",IF(I1014=\"\",58.843*C1043,I1014))","v":735.53750000000014},{"$f":"IF(OR(C1043=\"\",E1014=\"\"),\"\",+O1043/N1043)","v":2.4479641468313842},{"$f":"IF(C1043=\"\",\"\",IFERROR(VLOOKUP($C$1006,'CO2 emissions factor'!$D$7:$E$164,2,FALSE),'CO2 emissions factor'!$E$165))","v":0.99580000000000002},{"$f":"IF(C1043=\"\",\"\",+Q1043*K1043)","v":8.1311413032784916},{"$f":"IF(C1043=\"\",\"\",+Q1043*L1043)","v":6.1364273326291183},{"$f":"IF(C1043=\"\",\"\",+R1043-S1043)","v":1.9947139706493733},{"$f":"IF(C1043=\"\",\"\",+S1043/R1043)","v":0.75468216622368856}]
[null,3,41.666666666666664,{"$f":"IF(C1044=\"\",\"\",0.2873*C1044^(-0.053))","v":0.23576906532975},8.9833333333333343,0.25,2.5441849469431586E-2,0.27544184946943157,0.15,0.27544184946943157,36.085167927822667,28.292287839570001,7.7928800882526659,1168.9320132378998,3677.6875,3.1461945248748364,{"$f":"IF(C1044=\"\",\"\",IFERROR(VLOOKUP($C$1006,'CO2 emissions factor'!$D$7:$E$164,2,FALSE),'CO2 emissions factor'!$E$165))","v":0.99580000000000002},35.933610222525814,28.173460230643808,7.760149991882006,0.78404201682419938]
[null,4,208.33333333333334,0.21649178017196083,44.916666666666671,0.25,0,0.25,0.15,0.25,162.36883512897063,129.8950681031765,32.473767025794132,4871.0650538691198,18388.4375,3.7750342679972917,{"$f":"IF(C1045=\"\",\"\",IFERROR(VLOOKUP($C$1006,'CO2 emissions factor'!$D$7:$E$164,2,FALSE),'CO2 emissions factor'!$E$165))","v":0.99580000000000002},161.68688602142896,129.34950881714315,32.337377204285815,0.79999999999999982]
[null,5,416.66666666666669,0.20868288003858779,89.833333333333343,0.25,3.4701891804518124E-2,0.2847018918045181,0.22500000000000001,0.2847018918045181,321.71434892734686,250.41945604630536,71.294892881041505,10694.233932156225,24517.916666666668,2.2926295443140026,{"$f":"IF(C1046=\"\",\"\",IFERROR(VLOOKUP($C$1006,'CO2 emissions factor'!$D$7:$E$164,2,FALSE),'CO2 emissions factor'!$E$165))","v":0.99580000000000002},320.36314866185199,249.36769433091087,70.995454330941129,0.7783906962224364]
[null,6,458.33333333333331,0.20763138909656931,98.816666666666663,0.25,2.3955856407915945E-2,0.27395585640791592,0.22500000000000001,0.27395585640791592,349.15745583006441,274.07343360747149,75.084022222592921,11262.603333388939,26969.708333333332,2.3946247181927602,{"$f":"IF(C1047=\"\",\"\",IFERROR(VLOOKUP($C$1006,'CO2 emissions factor'!$D$7:$E$164,2,FALSE),'CO2 emissions factor'!$E$165))","v":0.99580000000000002},347.69099451557815,272.92232518632011,74.768669329258046,0.78495655478960624]
[null,7,500,0.20667608000992865,107.80000000000001,0.25,1.2530893057479356E-2,0.26253089305747934,0.3,0.3,386.89762177858648,297.61355521429726,89.284066564289219,13392.609984643383,29421.5,2.1968458749815101,{"$f":"IF(C1048=\"\",\"\",IFERROR(VLOOKUP($C$1006,'CO2 emissions factor'!$D$7:$E$164,2,FALSE),'CO2 emissions factor'!$E$165))","v":0.99580000000000002},385.27265176711643,296.36357828239721,88.909073484719215,0.76923076923076916]
[null,8,541.66666666666663,0.20580116274492974,116.78333333333333,0.25,0,0.25,0.3,0.3,417.36475804671761,321.04981388209046,96.31494416462715,14447.241624694072,31873.291666666668,2.2061852701478299,{"$f":"IF(C1049=\"\",\"\",IFERROR(VLOOKUP($C$1006,'CO2 emissions factor'!$D$7:$E$164,2,FALSE),'CO2 emissions factor'!$E$165))","v":0.99580000000000002},415.61182606292141,319.70140466378569,95.910421399135714,0.76923076923076927]
[null,9,583.33333333333337,0.2049944182539124,125.76666666666668,0.15,3.1571206100223216E-2,0.1815712061002232,0.3,0.3,447.70780946654475,344.39062266657288,103.31718679997186,15497.578019995779,36776.875,2.3730724215453902,{"$f":"IF(C1050=\"\",\"\",IFERROR(VLOOKUP($C$1006,'CO2 emissions factor'!$D$7:$E$164,2,FALSE),'CO2 emissions factor'!$E$165))","v":0.99580000000000002},445.82743666678527,342.94418205137328,102.883254615412,0.76923076923076916]
[null,10,1041.6666666666667,0.19879067178076726,224.58333333333337,0,0,0,0.3,0.3,775.28361994499232,596.37201534230178,178.91160460269055,26836.740690403582,61294.791666666672,2.2839879243825156,{"$f":"IF(C1051=\"\",\"\",IFERROR(VLOOKUP($C$1006,'CO2 emissions factor'!$D$7:$E$164,2,FALSE),'CO2 emissions factor'!$E$165))","v":0.99580000000000002},772.02742874122339,593.86725287786408,178.16017586335931,0.76923076923076916]
[null,null,{"$f":"+SUM(C1042:C1051)","v":3804.166666666667},null,{"$f":"IF(SUM(E1042:E1051)=0,\"\",+SUM(E1042:E1051))","v":820.1783333333334},null,null,null,null,null,{"$f":"IF(SUM(K1042:K1051)=0,\"\",+SUM(K1042:K1051))","v":2908.8255676355429},{"$f":"IF(SUM(L1042:L1051)=0,\"\",+SUM(L1042:L1051))","v":2251.4650128541325},{"$f":"IF(SUM(M1042:M1051)=0,\"\",+SUM(M1042:M1051))","v":657.3605547814102},{"$f":"IF(SUM(N1042:N1051)=0,\"\",+SUM(N1042:N1051))","v":98604.083217211533},{"$f":"IF(SUM(O1042:O1051)=0,\"\",+SUM(O1042:O1051))","v":234023.51458333334},{"$f":"IF(SUM(P1042:P1051)=0,\"\",+O1052/N1052)","v":2.3733653510860298},{"$f":"IF(SUM(Q1042:Q1051)=0,\"\",+AVERAGE(Q1042:Q1051))","v":0.9957999999999998},{"$f":"IF(SUM(R1042:R1051)=0,\"\",+SUM(R1042:R1051))","v":2896.6085002514737},{"$f":"IF(SUM(S1042:S1051)=0,\"\",+SUM(S1042:S1051))","v":2242.0088598001448},{"$f":"IF(SUM(T1042:T1051)=0,\"\",+SUM(T1042:T1051))","v":654.59964045132847},{"$f":"IF(SUM(U1042:U1051)=0,\"\",+S1052/R1052)","v":0.77401169664644054}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["."]

{"sheet":"Report","index":1,"n_rows":1100,"n_cols":6,"rows_kept":1100,"cut":false,"hidden":false,"merged":[[45,1,47,6],[4,3,4,6],[5,3,5,6],[6,3,6,5],[7,1,9,6],[10,1,17,6]]}
[]
[]
[]
[]
[null,null,null,"ENERGY EFFICIENCY IN"]
[null,null,null,"GROUNDWATER SYSTEMS"]
[null,null,null,"REPORT"]
[]
[]
[]
[null,"DISCLAIMER: This tool provides information to asses the initial potential Energy, CO2 and financial savings replacing old cold groundwater pumps by a new energy efficient ones at a municipal cold water utility company level (not designed for the individual residential cold water consumers). If the results provided by this tool are under the interest of municipality and it wants to upgrade existing pumps, as a next step we recommned to reach the cold water pumps manufacturing companies, which will provide detailed model and price for every individual pump.\nThe function of the tool is merely informative and the C2E2 does not have any legal responsibility, interest or involvement in any of the technical nor financial recommendations that may be provided to the user. \nFor more information access our institutional webpage at https://unepccc.org/. \n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"No.","Name","Units","Value"]
[]
[]
[null,null,1,"Country",null,"Mozambique"]
[]
[null,null,2,"Water consumption","m3/month",913000]
[null,null,3,"Electricity price","Eur/MWh",150]
[null,null,4,"Power capacity","kW",820.1783333333334]
[]
[null,null,5,"Energy consumption for water extraction of old pump","MWh/year",2908.8255676355429]
[null,null,6,"Energy consumption for water extraction of new pump","MWh/year",2251.4650128541325]
[null,null,7,"Energy savings","MWh/year",657.3605547814102]
[]
[null,null,8,"Investment","Eur",234023.51458333334]
[null,null,9,"Financial savings","Eur/year",98604.083217211533]
[null,null,10,"Simple payback period","Years",2.3733653510860298]
[]
[null,null,11,"CO2 emissions factor","t/MWh",0.9957999999999998]
[null,null,12,"CO2 baseline scenarios","tCO2/year",2896.6085002514737]
[null,null,13,"CO2 scenarios after upgrade","tCO2/year",2242.0088598001448]
[null,null,14,"CO2 savings","tCO2/year",654.59964045132847]
[null,null,15,"CO2 savings","%",0.77401169664644054]
[]
[null,null,"*CO2 emission factors are based on IEA data."]
[]
[]
[]
[]
[]
[null,null,"*This tool is developed with kind support of a Grunfoss pumps manufacturing company."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"No.","Name","Units","Value"]
[]
[]
[null,null,1,"Country",null,{"$f":"+'Input Data'!C1006","v":"Mozambique"}]
[]
[null,null,2,"Water consumption","m3/month",{"$f":"+'Input Data'!C1023","v":913000}]
[null,null,3,"Electricity price","Eur/MWh",{"$f":"+'Input Data'!E1023","v":150}]
[null,null,4,"Power capacity","kW",{"$f":"+'Input Data'!E1052","v":820.1783333333334}]
[]
[null,null,5,"Energy consumption for water extraction of old pump","MWh/year",{"$f":"+'Input Data'!K1052","v":2908.8255676355429}]
[null,null,6,"Energy consumption for water extraction of new pump","MWh/year",{"$f":"+'Input Data'!L1052","v":2251.4650128541325}]
[null,null,7,"Energy savings","MWh/year",{"$f":"+'Input Data'!M1052","v":657.3605547814102}]
[]
[null,null,8,"Investment","Eur",{"$f":"+'Input Data'!O1052","v":234023.51458333334}]
[null,null,9,"Financial savings","Eur/year",{"$f":"+'Input Data'!N1052","v":98604.083217211533}]
[null,null,10,"Simple payback period","Years",{"$f":"+'Input Data'!P1052","v":2.3733653510860298}]
[]
[null,null,11,"CO2 emissions factor","t/MWh",{"$f":"+'Input Data'!Q1052","v":0.9957999999999998}]
[null,null,12,"CO2 baseline scenarios","tCO2/year",{"$f":"+'Input Data'!R1052","v":2896.6085002514737}]
[null,null,13,"CO2 scenarios after upgrade","tCO2/year",{"$f":"+'Input Data'!S1052","v":2242.0088598001448}]
[null,null,14,"CO2 savings","tCO2/year",{"$f":"+'Input Data'!T1052","v":654.59964045132847}]
[null,null,15,"CO2 savings","%",{"$f":"+'Input Data'!U1052","v":0.77401169664644054}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["."]

{"sheet":"CO2 emissions factor","index":2,"n_rows":165,"n_cols":5,"rows_kept":165,"cut":false,"hidden":false,"merged":[[5,2,6,2],[5,3,6,3]]}
[]
[]
[]
[]
[]
[null,null,"No.","Country","CO2 emissions factor"]
[null,null,null,null,"t/MWh"]
[null,null,1,"All countries",0.60286246884615402]
[null,null,{"$f":"+C8+1","v":2},"Afghanistan",0.31]
[null,null,{"$f":"+C9+1","v":3},"Albania",0.254]
[null,null,4,"Algeria",0.57999999999999996]
[null,null,5,"Angola",0.7944]
[null,null,6,"Antigua and Barbuda",0.84770000000000001]
[null,null,7,"Argentina",0.53300000000000003]
[null,null,8,"Armenia",0.53500000000000003]
[null,null,9,"Azerbaijan",0.62]
[null,null,10,"Bahamas",0.749]
[null,null,11,"Bahrain",0.63500000000000001]
[null,null,12,"Bangladesh",0.626]
[null,null,13,"Barbados",0.65423059999999866]
[null,null,14,"Belarus",0.45200000000000001]
[null,null,15,"Belize",0.30380000000000001]
[null,null,16,"Benin",0.72]
[null,null,17,"Bhutan",1.0004999999999999]
[null,null,18,"Bolivia",0.62]
[null,null,19,"Bosnia and Herzegovina",1.1247515400000001]
[null,null,20,"Botswana",1.7869999999999999]
[null,null,21,"Brazil",0.55800000000000005]
[null,null,22,"Brunei Darussalam",0.745]
[null,null,23,"Burkina Faso",0.27875]
[null,null,24,"Burundi",0.61599999999999999]
[null,null,25,"Cambodia",0.62570000000000003]
[null,null,26,"Cameroon",0.20100000000000001]
[null,null,27,"Cape Verde",0.49]
[null,null,28,"Central African Republic",0.61599999999999999]
[null,null,29,"Chad",0.61599999999999999]
[null,null,30,"Chile",0.98899999999999999]
[null,null,31,"China",1.1120000000000001]
[null,null,32,"Colombia",0.153]
[null,null,33,"Comoros",0.61599999999999999]
[null,null,34,"Congo, Dem. Rep. of the",3.0000000000000001E-3]
[null,null,35,"Congo, Rep.",0.247]
[null,null,36,"Cook Islands",0.51100000000000001]
[null,null,37,"Costa Rica",0.32890000000000003]
[null,null,38,"Côte d'Ivoire",0.62439999999999996]
[null,null,39,"Cuba",0.86140000000000005]
[null,null,40,"Djibouti",0.61599999999999999]
[null,null,41,"Dominica",0.65423059999999866]
[null,null,42,"Dominican Republic",0.80900000000000005]
[null,null,43,"Ecuador",0.72529999999999994]
[null,null,44,"Egypt",0.52229999999999999]
[null,null,45,"El Salvador",0.69]
[null,null,46,"Equatorial Guinea",0.61599999999999999]
[null,null,47,"Eritrea",0.84399999999999997]
[null,null,48,"Ethiopia",4.4999999999999998E-2]
[null,null,49,"Fiji",0.24879999999999999]
[null,null,50,"Gabon",0.373]
[null,null,51,"Gambia",0.49]
[null,null,52,"Georgia",0.52012000000000003]
[null,null,53,"Ghana",0.25168000000000001]
[null,null,54,"Grenada",0.65423059999999866]
[null,null,55,"Guatemala",0.68700000000000006]
[null,null,56,"Guinea",0.49]
[null,null,57,"Guinea-Bissau",0.49]
[null,null,58,"Guyana",0.94830000000000003]
[null,null,59,"Haiti",0.39100000000000001]
[null,null,60,"Honduras",0.64749999999999996]
[null,null,61,"India",0.99409999999999998]
[null,null,62,"Indonesia",0.64400000000000002]
[null,null,63,"Iran, Islamic Rep. of",0.74399999999999999]
[null,null,64,"Iraq",0.94599999999999995]
[null,null,65,"Israel",0.74490000000000001]
[null,null,66,"Jamaica",0.77200000000000002]
[null,null,{"$f":"+C73+1","v":67},"Jordan",0.60109999999999997]
[null,null,68,"Kazakhstan",0.93]
[null,null,69,"Kenya",0.66190000000000004]
[null,null,70,"Kiribati",0.51100000000000001]
[null,null,71,"Korea, Dem. Rep.",0.94]
[null,null,72,"Korea, Republic of ",0.74029999999999996]
[null,null,73,"Kuwait",0.75]
[null,null,74,"Kyrgyz Republic",5.0999999999999997E-2]
[null,null,75,"Lao People's Dem.  Rep.",0.5595]
[null,null,76,"Lebanon",0.67220000000000002]
[null,null,77,"Lesotho",0.64200000000000002]
[null,null,78,"Liberia",0.49]
[null,null,79,"Libya",0.81640000000000001]
[null,null,80,"Macedonia, FYR",0.88300000000000001]
[null,null,81,"Madagascar",0.47699999999999998]
[null,null,82,"Malawi",0.25519999999999998]
[null,null,83,"Malaysia",0.60299999999999998]
[null,null,84,"Maldives",0.72499999999999998]
[null,null,85,"Mali",0.64500000000000002]
[null,null,86,"Marshall Islands",0.51100000000000001]
[null,null,87,"Mauritania",0.61599999999999999]
[null,null,88,"Mauritius",1.0169999999999999]
[null,null,89,"Mexico",0.46710000000000002]
[null,null,90,"Micronesia, Fed. Sts.",0.51100000000000001]
[null,null,91,"Moldova",0.29299999999999998]
[null,null,92,"Mongolia",1.121]
[null,null,93,"Montenegro",0.6825]
[null,null,94,"Morocco",0.83109999999999995]
[null,null,95,"Mozambique",0.99580000000000002]
[null,null,96,"Myanmar",0.23899999999999999]
[null,null,97,"Namibia",0.95]
[null,null,98,"Nauru",0.51100000000000001]
[null,null,99,"Nepal",2E-3]
[null,null,100,"Nicaragua",0.71]
[null,null,101,"Niger",0.49]
[null,null,102,"Nigeria",0.55000000000000004]
[null,null,103,"Niue",0.51100000000000001]
[null,null,104,"Oman",0.76300000000000001]
[null,null,105,"Pakistan",0.70469999999999999]
[null,null,106,"Palau",0.51100000000000001]
[null,null,107,"Palestine",0.74299999999999999]
[null,null,108,"Panama",0.67900000000000005]
[null,null,109,"Papua New Guinea",0.65800000000000003]
[null,null,110,"Paraguay",1E-3]
[null,null,111,"Peru",0.85829999999999995]
[null,null,112,"Philippines",0.76500000000000001]
[null,null,113,"Qatar",0.497]
[null,null,114,"Russian Federation",0.41699999999999998]
[null,null,115,"Rwanda",0.66059999999999997]
[null,null,116,"Saint Kitts and Nevis",0.65423059999999866]
[null,null,117,"Saint Lucia",0.65423059999999866]
[null,null,118,"Saint Vincent and the Grenadines",0.65423059999999866]
[null,null,119,"Samoa",0.51100000000000001]
[null,null,120,"Sao Tome and Principe",0.61599999999999999]
[null,null,121,"Saudi Arabia",0.65400000000000003]
[null,null,122,"Senegal",0.67949999999999999]
[null,null,123,"Serbia",0.97065999999999997]
[null,null,124,"Seychelles",0.61599999999999999]
[null,null,125,"Sierra Leone",0.40200000000000002]
[null,null,126,"Singapore",0.51139999999999997]
[null,null,127,"Solomon Islands",0.51100000000000001]
[null,null,128,"Somalia",0.61599999999999999]
[null,null,129,"South Africa",0.92300000000000004]
[null,null,130,"South Sudan",0.61599999999999999]
[null,null,{"$f":"+C137+1","v":131},"Sri Lanka",0.69930000000000003]
[null,null,132,"Sudan",0.23100000000000001]
[null,null,133,"Suriname",0.36]
[null,null,134,"Swaziland",0.64319999999999999]
[null,null,135,"Syrian Arab Republic",0.60799999999999998]
[null,null,136,"Tajikistan",1.4999999999999999E-2]
[null,null,137,"Tanzania, U. Rep. of",0.53900000000000003]
[null,null,138,"Thailand",0.5383]
[null,null,139,"Timor-Leste",0.72499999999999998]
[null,null,140,"Togo",0.20699999999999999]
[null,null,141,"Tonga",0.51100000000000001]
[null,null,142,"Trinidad and Tobago",0.64100000000000001]
[null,null,143,"Tunisia",0.58330000000000004]
[null,null,144,"Turkey",0.47599999999999998]
[null,null,145,"Turkmenistan",0.93400000000000005]
[null,null,146,"Tuvalu",0.51100000000000001]
[null,null,147,"Uganda",0.61399999999999999]
[null,null,148,"Ukraine",0.42599999999999999]
[null,null,149,"United Arab Emirates",0.43690000000000001]
[null,null,150,"Uruguay",0.67500000000000004]
[null,null,151,"Uzbekistan",0.58399999999999996]
[null,null,152,"Vanuatu",0.51100000000000001]
[null,null,153,"Venezuela",0.23300000000000001]
[null,null,154,"Viet Nam",0.64480000000000004]
[null,null,155,"Yemen",0.64]
[null,null,156,"Zambia",0.99580000000000002]
[null,null,157,"Zimbabwe",0.35799999999999998]
[null,null,null,"Average",{"$f":"+AVERAGE(E9:E164)","v":0.60286246884615402}]