{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["_Guidance_and_input-output","EGS_illustration_","Engine_","EGS_temp_"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":6,"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":"_Guidance_and_input-output","index":0,"n_rows":73,"n_cols":28,"rows_kept":73,"cut":false,"hidden":false,"merged":[[3,26,4,26],[3,27,4,27],[3,25,4,25]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nr.","List of Energy Generation Systems (EGS):","ERy\n(tCO2)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"Engine_!C5","v":""},{"$f":"Engine_!A5","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"Engine_!C6","v":""},{"$f":"Engine_!A6","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"Engine_!C7","v":""},{"$f":"Engine_!A7","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"Engine_!C8","v":""},{"$f":"Engine_!A8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"Engine_!C9","v":""},{"$f":"Engine_!A9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"Engine_!C10","v":""},{"$f":"Engine_!A10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"Engine_!C11","v":""},{"$f":"Engine_!A11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"Engine_!C12","v":""},{"$f":"Engine_!A12","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"Engine_!C13","v":""},{"$f":"Engine_!A13","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"Engine_!C14","v":""},{"$f":"Engine_!A14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"Engine_!C15","v":""},{"$f":"Engine_!A15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,{"$f":"Engine_!C16","v":""},{"$f":"Engine_!A16","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"Engine_!C17","v":""},{"$f":"Engine_!A17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,{"$f":"Engine_!C18","v":""},{"$f":"Engine_!A18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,{"$f":"Engine_!C19","v":""},{"$f":"Engine_!A19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,{"$f":"Engine_!C20","v":""},{"$f":"Engine_!A20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"Engine_!C21","v":""},{"$f":"Engine_!A21","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,{"$f":"Engine_!C22","v":""},{"$f":"Engine_!A22","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,{"$f":"Engine_!C23","v":""},{"$f":"Engine_!A23","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,{"$f":"Engine_!C24","v":""},{"$f":"Engine_!A24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,{"$f":"Engine_!C25","v":""},{"$f":"Engine_!A25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,{"$f":"Engine_!C26","v":""},{"$f":"Engine_!A26","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,{"$f":"Engine_!C28","v":""},{"$f":"Engine_!A28","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,{"$f":"Engine_!C29","v":""},{"$f":"Engine_!A29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,{"$f":"Engine_!C30","v":""},{"$f":"Engine_!A30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,{"$f":"Engine_!C31","v":""},{"$f":"Engine_!A31","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,{"$f":"Engine_!C32","v":""},{"$f":"Engine_!A32","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,{"$f":"Engine_!C33","v":""},{"$f":"Engine_!A33","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,{"$f":"Engine_!C34","v":""},{"$f":"Engine_!A34","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,{"$f":"Engine_!C35","v":""},{"$f":"Engine_!A35","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,{"$f":"Engine_!C36","v":""},{"$f":"Engine_!A36","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,{"$f":"Engine_!C37","v":""},{"$f":"Engine_!A37","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,{"$f":"Engine_!C38","v":""},{"$f":"Engine_!A38","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,{"$f":"Engine_!C39","v":""},{"$f":"Engine_!A39","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,{"$f":"Engine_!C40","v":""},{"$f":"Engine_!A40","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,{"$f":"Engine_!C41","v":""},{"$f":"Engine_!A41","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,{"$f":"Engine_!C42","v":""},{"$f":"Engine_!A42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,{"$f":"Engine_!C43","v":""},{"$f":"Engine_!A43","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,{"$f":"Engine_!C44","v":""},{"$f":"Engine_!A44","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,{"$f":"Engine_!C45","v":""},{"$f":"Engine_!A45","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,{"$f":"Engine_!C46","v":""},{"$f":"Engine_!A46","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,{"$f":"Engine_!C47","v":""},{"$f":"Engine_!A47","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,{"$f":"Engine_!C48","v":""},{"$f":"Engine_!A48","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,{"$f":"Engine_!C49","v":""},{"$f":"Engine_!A49","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Engine_!A3>10000,\"Please, notice that the maximum eligible emissions reduction (ERy) for community projects is 10,000 tCO2 per year\",\"\")","v":""}]

{"sheet":"EGS_illustration_","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Engine_","index":2,"n_rows":100,"n_cols":7,"rows_kept":100,"cut":false,"hidden":true,"merged":[]}
["Splash",1,null,null,null,null,"_Guidance_and_input-output"]
[null,null,null,null,null,null,"EGS_illustration_"]
[{"$f":"SUM(A5:A100)","v":0},"Sum of emission reductions of each energy generation systems",null,null,null,null,"Engine_"]
[null,null,null,null,null,null,"EGS_temp_"]
[{"$f":"IF(ISNUMBER(B5),B5,0)","v":0},{"$f":"IF(C5=\"\",\"\",IF(INDIRECT(\"'\"&G5&\"'\"&\"!F$4\")=\"\",\"\",INDIRECT(\"'\"&G5&\"'\"&\"!F$4\")))","v":""},{"$f":"IF(G5=\"\",\"\",MID(G5,5,50))","v":""}]
[{"$f":"IF(ISNUMBER(B6),B6,0)","v":0},{"$f":"IF(C6=\"\",\"\",IF(INDIRECT(\"'\"&G6&\"'\"&\"!F$4\")=\"\",\"\",INDIRECT(\"'\"&G6&\"'\"&\"!F$4\")))","v":""},{"$f":"IF(G6=\"\",\"\",MID(G6,5,50))","v":""}]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[{"$f":"IF(ISNUMBER(B70),B70,0)","v":0},{"$f":"IF(C70=\"\",\"\",IF(INDIRECT(\"'\"&G70&\"'\"&\"!F$4\")=\"\",\"\",INDIRECT(\"'\"&G70&\"'\"&\"!F$4\")))","v":""},{"$f":"IF(G70=\"\",\"\",MID(G70,5,50))","v":""}]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]
[0,"",""]

{"sheet":"EGS_temp_","index":3,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":true,"merged":[[36,3,36,4],[25,5,25,6],[26,5,26,6],[36,5,36,6],[9,3,9,4],[9,5,9,6],[11,3,11,4],[11,5,11,6],[25,3,25,4],[26,3,26,4],[29,5,29,6],[30,5,30,6],[33,3,33,4],[33,5,33,6],[34,3,34,4],[34,5,34,6],[8,5,8,6],[8,3,8,4],[6,5,6,6],[1,3,1,4],[1,5,1,6],[3,3,3,4],[3,5,3,6],[4,3,4,4],[6,3,6,4]]}
[]
[null,null,null,"Energy Generation System:",null,{"$f":"MID(B1,1,100)","v":""}]
[]
[null,null,null,"ERy = Emissions Reduction in a year (t CO2) ",null,{"$f":"F12 - F7 - F9","v":0}]
[]
[]
[null,null,null,"PEy = Project Emission in a year ( t CO2)"]
[]
[null,null,null,"LEy = Leakage Emission in a year (t CO2)",null,{"$f":"IF(F37>=F26,IF((F10+F26)>=F37,(F10+F26-F37)/1000*1.3,0),F10/1000*1.3)","v":0}]
[null,null,null,"NEC = Non Eligible Consumers in a year (kWh)"]
[]
[null,null,null,"BEy = Baseline Emission in a year (t CO2)",null,{"$f":"IFERROR(MIN(F37/F26,1)*F26/1000*1.3,0)","v":0}]
[]
[null,null,null,"Consumer group (CG)","Default MSL for each consumer ","Default MSL for each consumer ","Default BE for each consumer","Number of the specific","Total MSL for each"]
[null,null,null,null,"group (kWh) per day","group (kWh) in a year","group (t CO2) in a year","consumer group (n)","consumer group (kWh)"]
[null,null,null,"Household (hh)",3,{"$f":"E16*365","v":1095},{"$f":"1.3*F16/1000","v":1.4235},null,{"$f":"F16 * H16","v":0}]
[null,null,null,"Health Center (hc)",8.6,{"$f":"E17*365","v":3139},{"$f":"1.3*F17/1000","v":4.0807000000000002},null,{"$f":"F17 * H17","v":0}]
[null,null,null,"Dispensary (d)",4.0999999999999996,{"$f":"E18*365","v":1496.4999999999998},1.9454499999999999,null,0]
[null,null,null,"School (s)",10,3650,4.7450000000000001,null,0]
[null,null,null,"Kindergarten (k)",4.4000000000000004,1606.0000000000002,2.0878000000000001,null,0]
[null,null,null,"Public Administration (pa)",4.4000000000000004,1606.0000000000002,2.0878000000000001,null,0]
[null,null,null,"Trading Place (tp)",11,4015,5.2195,null,0]
[null,null,null,null,null,0,0,null,0]
[null,null,null,null,null,{"$f":"E24*365","v":0},{"$f":"1.3*F24/1000","v":0},null,{"$f":"F24 * G24","v":0}]
[]
[null,null,null,"Total MSLec,y (kWh/year)",null,{"$f":"SUM(I16:OFFSET(I24,-1,0))","v":0}]
[null,null,null,"Baseline Emissions based on MSL (t CO2/year)",null,{"$f":"SUMPRODUCT(H16:H22,G16:G22)","v":0}]
[]
[null,null,null,"Method A: The electricity delivered is based on the installed capacity and and an availability factor."]
[null,null,null,"IC = Installed capacity (W or Wp)"]
[null,null,null,"AF = Availability factor (%)"]
[]
[null,null,null,"Method B: The electricity delivered is based on actual monitoring at generation-level and a default transmission and distribution losses' (TDL) factor"]
[null,null,null,"Emy = Electricity monitored in a year (in kWh/year)"]
[null,null,null,"TDL = Transmission and distribution losses' factor (%)",null,0.1]
[]
[null,null,null,"Edy = Electricity delivered in a year (in kWh/year)",null,{"$f":"IF(I39=1,F30*F31*8760/1000,F34*(1-F35))","v":0}]
[]
[null,null,null,null,null,null,null,null,1]