{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Cover page","Results framework"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Cover page","index":0,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[[6,1,6,4],[12,2,13,4],[15,2,16,4],[2,0,2,5],[20,2,21,3],[23,2,25,3],[10,1,10,4],[27,2,27,3],[18,2,18,3],[34,2,34,3],[33,2,33,3],[29,2,29,3]]}
[]
[]
["Cold Chain for Ocean Communities - Illustrative Results Framework"]
[]
[null,"Introduction"]
[]
[null,"This results framework has been developed to help project developers measure and communicate impact to stakeholders. It has been intentionally simplified and serves as a starting point, with flexibility to be adapted to the needs of different users."]
[]
[null,"Key instructions and guidelines"]
[]
[null,"This section outlines key instructions that will serve as a guideline as developers interact with the tool. "]
[]
[null,1,"Only fill indicators that are realistically measurable. Not all projects will be able to collect all indicators, some require advanced metering, sensors, or surveys. If a metric cannot be measured, leave the monthly fields blank or mark as “N/A.” Avoid estimating or guessing values unless your methodology justifies it.\n\n"]
[]
[]
[null,2,"Complete the baseline value and baseline date first.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   Each indicator requires a starting point to measure change over time. Baseline Value = state before the project begins\nBaseline Date = date the baseline was recorded. This allows users to calculate percentage changes, improvements, or total impact over the project life."]
[]
[]
[null,3,"Follow a consistent data entry schedule, to maintain data quality. Developers should ideally input information at the same time every e.g., quarter. The blue formula cells will automatically update annually."]
[]
[null,4,"Ensure data sources are consistent and documented. In the template, an indication of what data sources/means of verification can be used has been provided, but please feel free to update based on what you will actually use. Every number you enter should come from a reliable and repeatable source\n"]
[]
[]
[null,5,"Pay attention to units of measurement. The tool relies on consistent units across all months:\n- kg (not tonnes) for volume stored, kWh for energy, Local currency for revenue and income, % for utilization and renewable share\nInconsistent units will produce inaccurate annual totals."]
[]
[]
[]
[null,6,"Train staff  on how to use this tool. Anyone entering data should receive training on where to input values, understand what the values are, avoid overwriting formulas and maintain consistent logs. This ensures continuity even when staff transit."]
[]
[null,7,"The third tab contains formulas that can be used to calculate selected indicators in the results framework. Please feel free to refer to them as needed."]
[]
[null,"Legend"]
[]
[null,null,"Enter data in white or input-designated cells (e.g., Baseline Value, Baseline Date, quarterly data fields)"]
[null,0.4,"Light-blue cells contain automated formulas for monthly totals, quarterly totals, annual totals, and derived metrics.Tampering with these cells will break calculations across the tool."]

{"sheet":"Results framework","index":1,"n_rows":43,"n_cols":23,"rows_kept":43,"cut":false,"hidden":false,"merged":[[2,0,2,22],[33,2,34,2],[33,1,34,1],[33,5,34,5],[33,6,34,6],[33,7,34,7],[33,8,34,8],[33,9,34,9],[33,10,34,10],[33,11,34,11],[33,12,34,12],[33,13,34,13],[33,14,34,14],[33,15,34,15],[33,16,34,16],[33,17,34,17],[33,18,34,18],[33,19,34,19],[33,20,34,20],[33,21,34,21],[33,22,34,22]]}
[]
[]
["Cold Chain for Ocean Communities - Illustrative Results Framework "]
[]
[null,"Economic indicators"]
[]
[null,"Indicator","Unit of measurement","Definition","Data source/Means of verification","Target value","Baseline Value","Baseline Date","Y1 - Q1","Y1 - Q2","Y1 - Q3","Y1 - Q4","Y2 - Q1","Y2 - Q2","Y2 - Q3","Y2 - Q4","Y3 - Q1","Y3 - Q2","Y3 - Q3","Y3 - Q4","Year 1","Year 2","Year 3"]
[null,"Volume of fish stored ","kg","Total quantity of fish stored/handled in kilograms by the cold chain facility","Weighbridge logs, delivery notes ",null,null,"YYYY-MM-DD",{"$nulls":12},{"$f":"SUM(I8:L8)","v":0},{"$f":"SUM(M8:P8)","v":0},{"$f":"SUM(Q8:T8)","v":0}]
[null,"Average storage utilization rate ","%","Percentage of total storage capacity that is occupied on average during a defined time period (e.g. per day, week or month); Average weight of product stored/total storage capacity","Inventory logs, design capacity",null,null,"YYYY-MM-DD",{"$nulls":12},{"$f":"IFERROR(AVERAGE(I9:L9),0)","v":0},{"$f":"IFERROR(AVERAGE(M9:P9),0)","v":0},{"$f":"IFERROR(AVERAGE(Q9:T9),0)","v":0}]
[null,"Cost per kg stored ","Local currency/kg","Total operational expenditure of the facility divided by the volume of fish stored during a defined time period","Monthly expenses, inventory logs",null,null,"YYYY-MM-DD",{"$nulls":12},{"$f":"IFERROR(AVERAGE(I10:L10),0)","v":0},{"$f":"IFERROR(AVERAGE(M10:P10),0)","v":0},{"$f":"IFERROR(AVERAGE(Q10:T10),0)","v":0}]
[null,"Reduction in post-harvest lossess","%","Percentage reduction in the volume or proportion of harvested produce that is lost during storage, transport, or marketing compared to a baseline period before the intervention","Self-reported losses from fishers/traders (survey)",null,null,"YYYY-MM-DD",{"$nulls":12},{"$f":"IFERROR(AVERAGE(I11:L11),0)","v":0},{"$f":"IFERROR(AVERAGE(M11:P11),0)","v":0},{"$f":"IFERROR(AVERAGE(Q11:T11),0)","v":0}]
[null,"Average price of fish per kg sold ","Local currency/kg","Average market price achieved by fishers for their product","Sales invoices",null,null,"YYYY-MM-DD",{"$nulls":12},{"$f":"IFERROR(AVERAGE(I12:L12),0)","v":0},{"$f":"IFERROR(AVERAGE(M12:P12),0)","v":0},{"$f":"IFERROR(AVERAGE(Q12:T12),0)","v":0}]
[null,"Revenue from cold storage facilities","Local currency","Total gross income generated by the cold chain facility through service fees","Financial statements",null,null,"YYYY-MM-DD",{"$nulls":12},{"$f":"SUM(I13:L13)","v":0},{"$f":"SUM(M13:P13)","v":0},{"$f":"SUM(Q13:T13)","v":0}]
[null,"Number of market linkages facilitated","Local currency/kg","Number of formal buyer relationships established between fishers and buyers as a direct result of the project","Monthly expenses, inventory logs",null,null,"YYYY-MM-DD",{"$nulls":12},0,0,0]
[null,"Average increase in fisher income","Local currency","Net change in fishers total's earnings, by comparing current income levels against a previous baseline timeframe to show growth","Self-reported earnings from fishers (survey)",null,null,"YYYY-MM-DD",{"$nulls":12},{"$f":"IFERROR(AVERAGE(I15:L15),0)","v":0},{"$f":"IFERROR(AVERAGE(M15:P15),0)","v":0},{"$f":"IFERROR(AVERAGE(Q15:T15),0)","v":0}]
[]
[null,"Social indicators"]
[]
[null,null,"Unit of measurement","Definition","Data source/means of verification","Target value","Baseline Value","Baseline Date","Y1 - Q1","Y1 - Q2","Y1 - Q3","Y1 - Q4","Y2 - Q1","Y2 - Q2","Y2 - Q3","Y2 - Q4","Y3 - Q1","Y3 - Q2","Y3 - Q3","Y3 - Q4","Year 1","Year 2","Year 3"]
[null,"Number of users trained to use cold chain facility","#","The total number individuals who have completed at least 80% of the prescribed cold chain or business management curriculum.","Attendance records",null,null,"YYYY-MM-DD",{"$nulls":12},{"$f":"SUM(I20:L20)","v":0},{"$f":"SUM(M20:P20)","v":0},{"$f":"SUM(Q20:T20)","v":0}]
[null,"Direct jobs created by cold chain facility project","#","Number of new, paid positions created specifically to run the cold chain facility or project operations, expressed in Full-Time Equivalents (FTE), where 1 FTE equals 40 hours of work per week","HR records",null,null,"YYYY-MM-DD",{"$nulls":12},{"$f":"SUM(I21:L21)","v":0},{"$f":"SUM(M21:P21)","v":0},{"$f":"SUM(Q21:T21)","v":0}]
[null,"Indirect jobs supported","#","Estimate of employment generated within the broader supply chain (e.g., local logistics, maintenance, or increased hiring by SME customers) as a result of the facility's operations","Periodic surveys",null,null,"YYYY-MM-DD",{"$nulls":12},{"$f":"SUM(I22:L22)","v":0},0,0]
[null,"% women-owned SMEs served as customers or supported","%","Proportion of small and medium enterprises utilizing the facility or services that are at least 51% owned or managed by women, calculated against the total number of SMEs served","Customer records",null,null,"YYYY-MM-DD",{"$nulls":12},{"$f":"IFERROR(AVERAGE(I23:L23),0)","v":0},{"$f":"IFERROR(AVERAGE(M23:P23),0)","v":0},{"$f":"IFERROR(AVERAGE(Q23:T23),0)","v":0}]
[null,"Number of youth engaged or supported through cold chain project ","#","Total number of unique individuals aged 15–35 (or per local definition) who actively utilize the cold chain services or participate in project-led economic activities put in place by the cold chain facility","Customer records",null,null,"YYYY-MM-DD",{"$nulls":12},{"$f":"SUM(I24:L24)","v":0},0,0]
[null,"Reduction in seasonal fluctuation of fish availability","%","The percentage decrease in the gap between peak and off-peak inventory throughput, compared against historical local market trends","Inventory logs",null,null,"YYYY-MM-DD",{"$nulls":12},{"$f":"IFERROR(AVERAGE(I25:L25),0)","v":0},{"$f":"IFERROR(AVERAGE(M25:P25),0)","v":0},{"$f":"IFERROR(AVERAGE(Q25:T25),0)","v":0}]
[null,"Reduction in stunting or malnutrition","%","Percentage decrease in the prevalence of chronic undernutrition (low height-for-age) among children under five in the target community","Longitudinal health surveys",null,null,"YYYY-MM-DD",{"$nulls":12},0,0,0]
[]
[null,"Environmental indicators"]
[]
[null,"Indicator","Unit of measurement","Definition","Data source/ means of verification","Target value","Baseline Value","Baseline Date","Y1 - Q1","Y1 - Q2","Y1 - Q3","Y1 - Q4","Y2 - Q1","Y2 - Q2","Y2 - Q3","Y2 - Q4","Y3 - Q1","Y3 - Q2","Y3 - Q3","Y3 - Q4","Year 1","Year 2","Year 3"]
[null,"Energy consumption ","Kwh","Total quantity of energy required to operate the cold chain technology during a specified timeframe, typically measured in kilowatt-hours (kWh) per day, month, or year","Electricity bill, inventory logs",null,null,"YYYY-MM-DD",{"$nulls":12},{"$f":"SUM(I31:L31)","v":0},{"$f":"SUM(M31:P31)","v":0},{"$f":"SUM(Q31:T31)","v":0}]
[null,"% renewable energy used","%","Percentage of the total energy consumed by the cold chain system that is generated from renewable sources (such as solar, wind, or hydro) over a defined period of time.\n\nRenewable Energy Share = (Energy from renewable sources (kWh)​ / Total energy consumed (kWh)) ×100","On-site generation logs",null,null,"YYYY-MM-DD",{"$nulls":12},{"$f":"IFERROR(AVERAGE(I32:L32),0)","v":0},{"$f":"IFERROR(AVERAGE(M32:P32),0)","v":0},{"$f":"IFERROR(AVERAGE(Q32:T32),0)","v":0}]
[null,"Cooling system efficiency ","kWh/kg","Measures how much energy is required to cool or freeze a specific unit of product, e.g, fish. Cooling system efficiency (kWh/kg) needs both energy consumption AND volume stored\n\nEfficiency = Total energy consumption (kWh)/ Total fish delivered or stored in cold chain facility (kg).                                                                                                                                                                  A lower value indicates a more optimized efficient and \"lean\" cooling process which is important for sustainable fishery projects","Records, i.e daily or monthly logs of product throughput (e.g., cubic metres or kilograms of space used for cooling)",null,null,"YYYY-MM-DD",{"$nulls":12},{"$f":"IFERROR(AVERAGE(I33:L33),0)","v":0},{"$f":"IFERROR(AVERAGE(M33:P33),0)","v":0},{"$f":"IFERROR(AVERAGE(Q33:T33),0)","v":0}]
[null,"CO2e from energy use","kg CO2e","Amount of carbon dioxide equivalent emissions generated by operating a system or facility through its energy consumption over a defined period (e.g., per day, month, or year)\n\nCO₂e = Energy consumption × Emission factor (use standard emission factor for each energy source)*\n","Electricity (emission factor):United States\n",null,null,"YYYY-MM-DD",{"$nulls":12},{"$f":"SUM(I34:L34)","v":0},{"$f":"SUM(M34:P34)","v":0},{"$f":"SUM(Q34:T34)","v":0}]
[null,null,null,"Optional computation: \nCO2 from refrigerant = Refrigerant leaked (kg) × Global Warming Potential (GWP)**\n\n","Refrigerant (GWP): United States Environmental Protection Agency (EPA)"]
[]
[null,"Notes:"]
[null,"* - Emission factor refers to the amount of CO₂ equivalent (CO₂e) released per unit of electricity consumed, expressed in kg CO₂e per kWh. For cold chain projects that run on electricity, use your country’s national grid emission factor. For solar-powered systems, emissions are considered negligible"]
[null,"Example: If a cold room consumes 1,000 kWh monthly and the national grid emission factor is 0.18 kg CO₂e/kWh, then CO₂e = 1,000 × 0.18 = 180 kg CO₂e/month"]
[]
[null,"** - Refrigerant leaked refers to the unintended release of refrigerant gas from cooling systems due to equipment faults, wear, or poor maintenance"]
[null,"Global Warming Potential (GWP) measures how much heat a refrigerant traps in the atmosphere relative to CO₂, expressed as a multiplier."]
[null,"To calculate emissions, multiply the amount of refrigerant leaked (kg) by its GWP value. Example: If 2 kg of R-134a leaks and its GWP is 1,430, then CO₂e = 2 × 1,430 = 2,860 kg CO₂e"]