{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Contents","Illustration","Consumer Economics","Minigrid Control","Energy Demand","End Uses","Hydro","Diesel","Solar and Battery","Solar Production","Demand and Supply Dispatch","Distribution","Financing Assumptions","Financial Model","Kerosene","Sample Prices","Backup"],"not_rendered":{"charts":26,"images":16,"macros":1,"external_links":0,"defined_names":76,"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":"Contents","index":0,"n_rows":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Contents"]
[null,null,null,null,null," Colour Codes ",null,null,null,null," File Name: ",null,{"$f":"IFERROR(File_name(),\"\")","v":"C:\\Users\\edwar\\OneDrive\\Courses New\\Chapter 5. Electricity\\Chapter 5. Electricity\\Renewable Energy\\12. Batteries and Storage\\Mini Grid Analysis\\Mini Grid Analysis - LATEST.xlsm"}]
[null,null,"Illustration",null,null,null," Inputs ",null,"1234567890"]
[null,null,null,null,null,null," Section Titles ",null,"TITLE ROW",null," Last Save Date ",null,{"$f":"IFERROR(lastsaved(),\"\")","v":"9/15/2021 6:48:52 AM"}]
[null,null,"Consumer Economics",null,null,null," Sum Column ",null,"1000000000"]
[null,null,null,null,null,null," True or 1 ",null,{"$f":"1=1","v":true},null," Last Save By",null,{"$f":"IFERROR(last_save_by(),\"\")","v":"Edward Bodmer"}]
[null,null,"Minigrid Control",null,null,null," False or 0 ",null,{"$f":"1=2","v":false}]
[null,null,null,"Demand Level and Demand Shape for Village",null,null," Other Sheet Links ",null,"|||||||||||||||||||"]
[null,null,null,"Supply Options and Characteristics"]
[null,null,null,"Distribution Parameters and Cost"]
[]
[null,null,"Demand Analysis"]
[null,null,null,"Alternate Village Profiles "]
[null,null,null,"End Uses for Alternative Household and Commercial Uses"]
[null,null,null,"Transpose"]
[null,null,null,"Graphs"]
[null,null,null,"Annual Growth"]
[null,null,null,"Total Quantity with Growth"]
[]
[null,null,"Hourly Load"]
[null,null,null,"Load by Hour of Day"]
[null,null,null,"Graphs"]
[null,null,null,"Graphs"]
[]
[null,null,"Hydro"]
[null,null,null,"Hydro Parameters"]
[null,null,null,"Costs"]
[null,null,null,"Notes"]
[]
[null,null,"Diesel"]
[null,null,null,"Diesel Parameters"]
[null,null,null,"Costs and Life"]
[]
[null,null,"Solar and Battery"]
[null,null,null,"Alterantive Solar and Battery Costs"]
[null,null,null,"Solar and Battery Parameters"]
[]
[null,null,"Solar Production"]
[]
[null,null,"Demand and Supply"]
[null,null,null,"Parameters"]
[null,null,null,"Chronological Analysis"]
[null,null,null,"Re-Ordered Hourly Analysis Beginning with Charge"]
[null,null,null,"Graphs"]
[]
[null,null,"Distribution"]
[]
[null,null,"Financing Assumptions"]
[null,null,null,"Finance"]
[]
[null,null,"Financial Model"]
[null,null,null,"Assumptions"]
[null,null,null,"Financial Model"]
[null,null,null,"Comparison with Kerosene Cost"]
[]
[null,null,"Kerosene"]
[null,null,null,"Conversions"]
[null,null,null,"Cost of Kerosene"]
[]
[null,null,"Sample Prices"]
[]
[null,null,"Backup"]

{"sheet":"Illustration","index":1,"n_rows":24,"n_cols":20,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["          ","Consumer Load and Kerosene",null,null,null,null,null,"Mini Grid",null,null,null,"Mini Grid Costs",null,null,null,null,"Annual Savings/Costs"]
[null,"Demand Profile"]
[null,"Daily Energy (kWh)",null,null,{"$f":"'Minigrid Control'!E9/1000","v":127.27},null,null,"Hydro Capacity (kW)",null,{"$f":"Hydro!F7","v":0}]
[null,"Maximum Load (kW)",null,null,{"$f":"'Minigrid Control'!E10/1000","v":11.18},null,null,"Diesel Capacity (kW)",null,{"$f":"Diesel!F7","v":0}]
[null,"Unserved Energy (kWh)",null,null,{"$f":"'Demand and Supply Dispatch'!E57","v":7.8907671668287662},null,null,"Solar Capacity (kW)",null,{"$f":"'Solar and Battery'!E14","v":29},null,"Hydro/kW",null,null,{"$f":"'Minigrid Control'!$F$37","v":3853}]
[null,"Cost/Litre of Kerosene",null,null,{"$f":"Kerosene!F17","v":1.1157894736842104},null,null,"Battery Capacity (kWh)",null,{"$f":"'Solar and Battery'!E17","v":57},null,"Solar Cost/kW",null,null,{"$f":"Solar_Cost","v":890},null,"Mini Grid Costs USD",null,null,{"$f":"J22","v":3725.998493724227}]
[null,null,null,null,null,null,null,null,null,null,null,"Battery Cost/kWh",null,null,{"$f":"'Solar and Battery'!E24","v":130},null,"Mini Grid Costs FRW"]
[null,"Annual Load Factor",null,null,{"$f":"'Consumer Economics'!K4","v":0.4743217054263566},null,null,"Solar Curve",null,null,null,"Diesel Cost/kW",null,null,{"$f":"Diesel!F19","v":650}]
[null,null,null,null,null,null,null,null,null,null,null,"Distribution Cost/m",null,null,{"$f":"Distribution!E26","v":12.049459486174888},null,"Total Demand",null,null,{"$f":"E3365/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retail Cost/kWh w/o Subsidy",null,null,{"$f":"E22","v":2583.3164611810503}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Target IRR",null,null,{"$f":"'Financing Assumptions'!$F$4","v":0.13},null,"Equivalent Kerosene Cost USD",null,null,{"$f":"T10-T6","v":-1142.6820325431768}]
[null,null,null,null,null,null,null,null,null,null,null,"Earned IRR",null,null,{"$f":"'Financial Model'!E135","v":0.1156351769548325},null,"Equivalent Kerosene Cost FRW"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Debt Funding Percent",null,null,null,null,"Energy Direct Savings",null,null,{"$f":"T12/T10","v":-0.44233141766176071}]
[null,null,null,null,null,null,null,null,null,null,null,"Tenure (Months)"]
[null,null,null,null,null,null,null,null,null,null,null,"Funding Interest Rate",null,null,null,null,"Percent Savings"]
[null,null,null,null,null,null,null,null,null,null,null,"Credit Spread and Fees"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kerosene Pollution Cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kerosene Quality Cost"]
[null,null,null,null,null,null,null,"Price/kWh Minigrid",null,{"$f":"Price","v":0.15422924414088282},null,"Battery Efficiency",null,null,{"$f":"Round_Trip","v":0.95}]
[null,"Imputed Kerosene Cost/yr",null,null,{"$f":"'Financial Model'!H145","v":2583.3164611810503},null,null,"Total Cost per Year",null,{"$f":"'Financial Model'!H114","v":3725.998493724227},null,"Depth of Discharge",null,null,{"$f":"'Consumer Economics'!K23","v":0.05},null,"Savings Including Other Cost"]
[null,null,null,null,null,null,null,null,null,null,null,"Capital Cost",null,null,{"$f":"'Financial Model'!G132","v":34578.42105263158}]
[null,"Note: Some Uses Converted to Kerosene Equivalent"]

{"sheet":"Consumer Economics","index":2,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["          "]
[]
[null,"Demand Profile",null,null,null,null,"Demand Profile"]
[null,null,null,null,null,null,null,null,"Load Factor",null,{"$f":"'Financial Model'!F19","v":0.4743217054263566},null,null,"Cost of Solar and Batteries",null,null,null,null,"Cost Comparison"]
[null,null,null,null,null,null,null,null,"Solar Capacity Factor",null,{"$f":"IFERROR('Financial Model'!F36,0)","v":0.22070253416281818},null,null,"Solar","Battery ","Hydro"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Capital Cost USD/kW",{"$f":"'Solar and Battery'!E23","v":890},{"$f":"'Solar and Battery'!E24","v":130},{"$f":"Illustration!O5","v":3853}]
[null,null,null,null,null,null,null,null,"Hydro Capacity (kW)",null,{"$f":"Illustration!J3","v":0},null,"Operating Cost USD/kWy",{"$f":"'Solar and Battery'!E27","v":4},{"$f":"'Solar and Battery'!E28","v":0.1},{"$f":"Hydro!F26","v":10}]
[null,null,null,null,null,null,null,null,"Diesel Capacity (kW)",null,{"$f":"Illustration!J4","v":0}]
[null,null,null,null,null,null,null,null,"Solar Capacity (kW)",null,{"$f":"Illustration!J5","v":29},null,"Capital Cost FRW/kW",{"$f":"N6*'Financial Model'!$F$13","v":845500},{"$f":"O6*'Financial Model'!$F$13","v":123500}]
[null,null,null,null,null,null,null,null,"Battery Capacity (kWh)",null,{"$f":"Illustration!J6","v":57},null,"Operating Cost FRW/kW",{"$f":"N7*'Financial Model'!$F$13","v":3800},{"$f":"O7*'Financial Model'!$F$13","v":95}]
[]
[null,null,null,null,null,null,null,null,"Unserved Energy (kWh)",null,{"$f":"Illustration!E5","v":7.8907671668287662},null,"Include Distribution"]
[null,null,null,null,null,null,null,null,"Demand Met (kWh)",null,{"$f":"Illustration!E3","v":127.27},null,"Cost of Kerosene USD/L",{"$f":"Kerosene!F17","v":1.1157894736842104}]
[null,null,null,null,null,null,null,null,"Wasted Renewable(kWh)",null,{"$f":"'Demand and Supply Dispatch'!E61","v":34.229730944150248},null,"Cost of Kerosene FRW/L",{"$f":"N13*'Financial Model'!F13","v":1060}]
[null,null,null,null,null,null,null,null,null,null,null,null,"IRR",{"$f":"Illustration!$O$13","v":0.1156351769548325}]
[null,null,null,null,null,null,null,null,"Price/kWh of Minigrid",null,{"$f":"Price","v":0.15422924414088282}]
[]
[null,null,null,null,null,null,null,null,"Battery Life",null,{"$f":"'Financing Assumptions'!F5","v":10}]
[null,null,null,null,null,null,null,null,"Solar Life",null,{"$f":"'Financing Assumptions'!F6","v":10}]
[null,{"$f":"'Demand and Supply Dispatch'!B71","v":"Demand"},null,"kWh/Day",{"$f":"SUM('Demand and Supply Dispatch'!G71:AD71)","v":127.27},null,null,null,"Target IRR",null,{"$f":"'Financing Assumptions'!$F$4","v":0.13}]
[null,{"$f":"'Demand and Supply Dispatch'!B72","v":"Hydro Production"},null,"kWh/Day",{"$f":"SUM('Demand and Supply Dispatch'!G72:AD72)","v":0}]
[null,{"$f":"'Demand and Supply Dispatch'!B73","v":"Solar Production"},null,"kWh/Day",{"$f":"SUM('Demand and Supply Dispatch'!G73:AD73)","v":153.60896377732146},null,null,null,"Round Trip Efficiency",null,{"$f":"Round_Trip","v":0.95}]
[null,{"$f":"'Demand and Supply Dispatch'!B74","v":"Diesel Production"},null,"kWh/Day",{"$f":"SUM('Demand and Supply Dispatch'!G74:AD74)","v":0},null,null,null,"Depth of Discharge",null,{"$f":"Depth_Discharge","v":0.05}]
[null,{"$f":"'Demand and Supply Dispatch'!B75","v":"Battery Discharge"},null,"kWh/Day",{"$f":"SUM('Demand and Supply Dispatch'!G75:AD75)","v":56.999999999999986}]
[]
[null,null,null,null,null,null,null,null,false]

{"sheet":"Minigrid Control","index":3,"n_rows":86,"n_cols":9,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
["          "]
[]
["Demand Level and Demand Shape for Village"]
[]
[null,"Village Profile"]
[null,"Year of Analysis"]
[null,"Growth Rate",null,null,{"$f":"'Energy Demand'!E153","v":0}]
[null,"Hourly Distribution"]
[null,"Daily Energy Demand",null,null,{"$f":"'End Uses'!J42","v":127270}]
[null,"Maximum Daily Load",null,null,{"$f":"'End Uses'!G43","v":11180}]
[]
[null,{"$f":"'Energy Demand'!B11","v":"Household 1"},null,null,{"$f":"'Energy Demand'!F11","v":50}]
[null,{"$f":"'Energy Demand'!B12","v":"Household 2"},null,null,{"$f":"'Energy Demand'!F12","v":50}]
[null,{"$f":"'Energy Demand'!B13","v":"Household 3"},null,null,{"$f":"'Energy Demand'!F13","v":36}]
[null,{"$f":"'Energy Demand'!B14","v":"Street Lights"},null,null,{"$f":"'Energy Demand'!F14","v":0}]
[null,{"$f":"'Energy Demand'!B15","v":"Schools and colleges"},null,null,{"$f":"'Energy Demand'!F15","v":1}]
[null,{"$f":"'Energy Demand'!B16","v":"Health posts and clinics"},null,null,{"$f":"'Energy Demand'!F16","v":0}]
[null,{"$f":"'Energy Demand'!B17","v":"Church and mosque"},null,null,{"$f":"'Energy Demand'!F17","v":2}]
[null,{"$f":"'Energy Demand'!B18","v":"Agro processing mill"},null,null,{"$f":"'Energy Demand'!F18","v":0}]
[null,{"$f":"'Energy Demand'!B19","v":"Saw/Furniture mill"},null,null,{"$f":"'Energy Demand'!F19","v":0}]
[null,{"$f":"'Energy Demand'!B20","v":"Welding workshop"},null,null,{"$f":"'Energy Demand'!F20","v":2}]
[null,{"$f":"'Energy Demand'!B21","v":"Local financial institutions"},null,null,{"$f":"'Energy Demand'!F21","v":4}]
[null,{"$f":"'Energy Demand'!B22","v":"Hotels and restaurants"},null,null,{"$f":"'Energy Demand'!F22","v":5}]
[null,{"$f":"'Energy Demand'!B23","v":"Government and other offices"},null,null,{"$f":"'Energy Demand'!F23","v":1}]
[]
[]
[]
[]
[]
[]
["Generation Supply Options and Characteristics"]
[]
[null,"Supply - Hydro"]
[null,null,"Include Hydro",null,"Flag",false]
[null,null,"Capacity (kW)",null,"kW",{"$f":"Hydro!F6","v":6}]
[null,null,"Hydro Capacity Applied",null,"kW",{"$f":"F34*F35","v":0}]
[null,null,"Cost/kW",null,"USD/kW ",{"$f":"Hydro!F24","v":3853}]
[null,null,"O&M Cost/kWy",null,"USD/kWy",{"$f":"Hydro!F26","v":10}]
[]
[null,null,"Head (meters)",null,"m",{"$f":"Hydro!$F$8","v":33}]
[null,null,"Production/Season",null,null,1,2,3,4]
[null,null,null,null,null,{"$f":"TRANSPOSE(Hydro!J15:J18)","v":"Winter"},"Spring","Summer","Autumn"]
[null,null,"Flow Rate",null,"m3/sec",{"$f":"TRANSPOSE(Hydro!F15:F18)","v":9.5000000000000001E-2},0.19,0.09,6.9000000000000006E-2]
[null,null,"Generation per Hour",null,"kW",{"$f":"TRANSPOSE(Hydro!I15:I18)","v":6},6,6,6]
[null,null,"Capacity Factor",null,"%",{"$f":"IFERROR(F44/$F$35,0)","v":1},{"$f":"IFERROR(G44/$F$35,0)","v":1},{"$f":"IFERROR(H44/$F$35,0)","v":1},{"$f":"IFERROR(I44/$F$35,0)","v":1}]
[null,null,"Annual Capacity Factor",null,"%",{"$f":"AVERAGE(F45:I45)","v":1}]
[]
[null,"Supply - Solar and Battery"]
[null,null,"Solar"]
[null,null,null,"Include Solar",null,true]
[null,null,null,"Solar Capacity","kW",{"$f":"'Solar and Battery'!E13","v":29}]
[null,null,null,"Applied Capacity","kW",{"$f":"F51*F50","v":29}]
[null,null,null,"Solar Profiles"]
[null,null,null,"Solar Daily Profiles"]
[null,null,null,"Solar (Inverter) Cost/kW","USD/kW",{"$f":"Solar_Cost","v":890}]
[null,null,null,"Solar (Inverter) O&M Cost/kW","USD/kWy",{"$f":"Solar_OM","v":4}]
[]
[]
[]
[null,null,"Battery"]
[null,null,null,"Inclde Battery",null,true]
[null,null,null,"Battery Capacity","kWh",{"$f":"'Solar and Battery'!E17","v":57}]
[null,null,null,"Round Trip Efficiecny","%",{"$f":"Round_Trip","v":0.95}]
[null,null,null,"Depth of Discharge","%",{"$f":"Depth_Discharge","v":0.05}]
[]
[]
[null,null,"Battery Capital Cost/kW",null,"USD/kW",{"$f":"Battery_Cost","v":130}]
[null,null,"Battery O&M Cost/kW",null,"USD/kWy",{"$f":"Battery_OM","v":0.1}]
[]
[]
[]
[null,"Supply - Diesel"]
[null,null,"Include Diesel",null,null,false]
[null,null,"Capacity",null,"kW",{"$f":"Diesel!F6","v":10}]
[null,null,"Cost/kW",null,"USD/kW",{"$f":"Diesel!$F$19","v":650}]
[null,null,"FixedO&M/kWy",null,"USD/kWy",{"$f":"Diesel!F21","v":15}]
[]
[null,null,"Heat Rate",null,"l/MWH",{"$f":"Diesel!F8","v":210}]
[null,null,"Fuel Price",null,"USD/Litre",{"$f":"Diesel!F13","v":1.145}]
[null,null,"Fuel Cost",null,"USD/MWH",{"$f":"F78*F79","v":240.45000000000002}]
[]
["Distribution Parameters and Cost"]
[null,"Meters",null,null,"m",{"$f":"Distribution!E18","v":4451.32}]
[null,"Cost/Meter",null,null,"USD/Meter",{"$f":"Distribution!E26","v":12.049459486174888}]
[null,"Apply Distribution in Analysis",null,null,"Flag",false]
[null,"Total Distribution Cost",null,null,null,{"$f":"F83*F84*F85","v":0}]

{"sheet":"Energy Demand","index":4,"n_rows":188,"n_cols":41,"rows_kept":188,"cut":false,"hidden":false,"merged":[]}
["Selection of Load Type to Drive Demand"]
[]
[null,null,null,null,null,null,null,null,"T1: Light + Mobile/Radio",null,null,null,"T2: T1 + TV",null,null,null,null,"T3: T2 + Home Appliances",null,null,null,null,null,null,null,null,"Street litghts",null,null,null,null,"Health posts and clinics",null,null,"Church and mosque","Productive Uses"]
[null,null,1,null,null,{"$f":"K52","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schools and colleges"]
[]
["Alternate Village Profiles "]
[]
[null,null,null,null,null,"Applied",null,null,null,null,null,null,"Number of Units"]
[null,null,null,null,null,"# of Units"]
[null,null,"Code",null,null,{"$f":"INDEX(J10:R10,$C$4)","v":"136 Households  "},null,{"$f":"INDEX(J10:S10,$C$4)","v":"136 Households  "},null,{"$f":"J25&\" Households  \"&J26","v":"136 Households  "},{"$f":"K25&\" Households  \"&K26","v":"156 Households  "},"2000 Households  ","6000 Households  ","1400 Households  ","1400 Households  ","Saw mills"," Households  ","2600 Households  "]
[null,"Household 1",1,"# of Units",null,{"$f":"INDEX(J11:R11,$C$4)","v":50},null,50,null,50,20,1400,2000,400,400,null,null,400]
[null,"Household 2",2,"# of Units",null,50,null,50,null,50,100,400,2000,300,300,null,null,800]
[null,"Household 3",3,"# of Units",null,36,null,36,null,36,36,200,2000,700,700,null,null,1400]
[null,"Street Lights",4,"# of Units",null,0,null,0,null,0,0,20,20,20,20,null,null,60]
[null,"Schools and colleges",5,"# of Units",null,1,null,1,null,1,1,5,5,7,7,null,null,7]
[null,"Health posts and clinics",6,"# of Units",null,0,null,0,null,null,null,3,7,3,3,null,null,3]
[null,"Church and mosque",7,"# of Units",null,2,null,2,null,2,2,1,3,3,3,null,null,3]
[null,"Agro processing mill",8,"# of Units",null,0,null,0,null,null,null,10,12,6,8,null,null,8]
[null,"Saw/Furniture mill",9,"# of Units",null,0,null,0,null,null,null,10,15,7,10,10,null,10]
[null,"Welding workshop",10,"# of Units",null,2,null,2,null,2,1,10,5,4,9,null,null,9]
[null,"Local financial institutions",11,"# of Units",null,4,null,4,null,4,6,1,15,1,4,null,null,4]
[null,"Hotels and restaurants",12,"# of Units",null,5,null,5,null,5,8,1,10,3,5,null,null,5]
[null,"Government and other offices",13,"# of Units",null,1,null,1,null,1,1,4,5,2,5,null,null,5]
[]
[null,"Total Households",null,null,null,{"$f":"INDEX(J25:R25,$C$4)","v":136},null,{"$f":"INDEX(J25:S25,$C$4)","v":136},null,{"$f":"SUM(J11:J13)","v":136},156,2000,6000,1400,1400,null,null,{"$f":"SUM(R11:R13)","v":2600}]
[]
[]
["End Uses for Alternative Household and Commercial Uses"]
[null,null,null,null,null,null,null,null,"Load in Watts for Infividual Different End Uses"]
[]
[null,null,null,null,null,"Total Load (W) for One Unit","Total Number of Units","Total Load (W) for Units","Bulb Living Room","Bulb Kitchen","Bulb Other Rooms","Mobile/Radio Charger","Bulb Living Room","Bulb Kitchen","Bulb Other Rooms","Mobile Charger","TV","Bulb Living Room","Bulb Kitchen","Bulb Other Rooms","Smart Phone","Radio/TV","Fan/cooler","Refrigerator","Iron","Cooking Appliance","Lights","Lights","Laptop and printer","Refrigerator","Multimedia projector","Lights","Refrigerator","Laptop and printer","Lights","Agro processing mill","Saw/Furniture mill","Welding workshop","Local financial institutions","Hotels and restaurants","Government and other offices"]
[null,"Household 1",1,"Load","Watt",{"$f":"SUM(I32:AO32)","v":17},{"$f":"F11","v":50},{"$f":"F32*G32","v":850},3,3,6,5]
[null,"Household 2",2,"Load","Watt",{"$f":"SUM(I33:AO33)","v":79},{"$f":"F12","v":50},{"$f":"F33*G33","v":3950},null,null,null,null,5,5,9,10,50]
[null,"Household 3",3,"Load","Watt",2165,36,77940,null,null,null,null,null,null,null,null,null,5,5,15,10,50,30,50,1000,1000]
[null,"Street Lights",4,"Load","Watt",75,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75]
[null,"Schools and colleges",5,"Load","Watt",328,1,328,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,300,0,0]
[null,"Health posts and clinics",6,"Load","Watt",125,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,75,0]
[null,"Church and mosque",7,"Load","Watt",20,2,40,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,null,20]
[null,"Agro processing mill",8,"Load","Watt",1500,0,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,null,null,1500]
[null,"Saw/Furniture mill",9,"Load","Watt",2500,0,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,null,null,null,2500]
[null,"Welding workshop",10,"Load","Watt",3000,2,6000,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,null,null,null,null,3000]
[null,"Local financial institutions",11,"Load","Watt",250,4,1000,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,null,null,null,null,null,250]
[null,"Hotels and restaurants",12,"Load","Watt",70,5,350,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,null,null,null,null,null,null,70]
[null,"Government and other offices",13,"Load","Watt",150,1,150,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,null,null,null,null,null,null,null,150]
[]
[null,"Selected Transposed Profile to Next Sheet",null,null,null,null,null,null,{"$f":"SUMPRODUCT(I32:I44,$G$32:$G$44)","v":150},{"$f":"SUMPRODUCT(J32:J44,$G$32:$G$44)","v":150},300,250,250,250,450,500,2500,180,180,540,360,1800,1080,1800,36000,36000,0,28,300,0,0,0,0,0,40,0,0,6000,1000,350,150]
[null,"Total Load for Single Unit Transposed",null,null,null,null,null,null,{"$f":"SUM(I32:I44)","v":3},{"$f":"SUM(J32:J44)","v":3},6,5,5,5,9,10,50,5,5,15,10,50,30,50,1000,1000,75,28,300,0,0,50,75,0,20,1500,2500,3000,250,70,150]
[]
[]
[]
["Transpose"]
[null,null,null,{"$f":"TRANSPOSE(H175:W175)","v":2020},null,null,null,null,null,null,1,{"$f":"INDEX(D52:D80,K52)","v":2020}]
[null,null,null,2021]
[null,null,null,2022]
[null,null,null,2023]
[null,null,null,2024]
[null,null,null,2025]
[null,null,null,2026]
[null,null,null,2027]
[null,null,null,2028]
[null,null,null,2029]
[null,null,null,2030]
[null,null,null,2031]
[null,null,null,2032]
[null,null,null,2033]
[null,null,null,2034]
[null,null,null,2035]
[null,null,null,{"$error":"#N/A"}]
[null,null,null,{"$error":"#N/A"}]
[null,null,null,{"$error":"#N/A"}]
[null,null,null,{"$error":"#N/A"}]
[null,null,null,{"$error":"#N/A"}]
[null,null,null,{"$error":"#N/A"}]
[null,null,null,{"$error":"#N/A"}]
[null,null,null,{"$error":"#N/A"}]
[null,null,null,{"$error":"#N/A"}]
[null,null,null,{"$error":"#N/A"}]
[null,null,null,{"$error":"#N/A"}]
[null,null,null,{"$error":"#N/A"}]
[null,null,null,{"$error":"#N/A"}]
[]
[]
[]
[null,null,null,{"$f":"TRANSPOSE(J10:R10)","v":"136 Households  "},null,null,null,null,null,null,null,5]
[null,null,null,"156 Households  "]
[null,null,null,"2000 Households  "]
[null,null,null,"6000 Households  "]
[null,null,null,"1400 Households  "]
[null,null,null,"1400 Households  "]
[null,null,null,"Saw mills"]
[]
[]
["Graphs"]
[]
[]
[null,null,"Load for One Unit"]
[null,{"$f":"B32","v":"Household 1"},{"$f":"F32","v":17}]
[null,"Household 2",79]
[null,"Household 3",2165]
[null,"Street Lights",75]
[null,"Schools and colleges",328]
[null,"Health posts and clinics",125]
[null,"Church and mosque",20]
[null,"Agro processing mill",1500]
[null,"Saw/Furniture mill",2500]
[null,"Welding workshop",3000]
[null,"Local financial institutions",250]
[null,"Hotels and restaurants",70]
[null,"Government and other offices",150]
[]
[]
[]
[null,null,"Number of Units"]
[null,{"$f":"B97","v":"Household 1"},{"$f":"F11","v":50}]
[null,{"$f":"B98","v":"Household 2"},50]
[null,"Household 3",36]
[null,"Street Lights",0]
[null,"Schools and colleges",1]
[null,"Health posts and clinics",0]
[null,"Church and mosque",2]
[null,"Agro processing mill",0]
[null,"Saw/Furniture mill",0]
[null,"Welding workshop",2]
[null,"Local financial institutions",4]
[null,"Hotels and restaurants",5]
[null,"Government and other offices",1]
[]
[]
[]
[]
[null,null,"Total Max kW"]
[null,{"$f":"B114","v":"Household 1"},{"$f":"H32","v":850}]
[null,{"$f":"B115","v":"Household 2"},{"$f":"H33","v":3950}]
[null,"Household 3",77940]
[null,"Street Lights",0]
[null,"Schools and colleges",328]
[null,"Health posts and clinics",0]
[null,"Church and mosque",40]
[null,"Agro processing mill",0]
[null,"Saw/Furniture mill",0]
[null,"Welding workshop",6000]
[null,"Local financial institutions",1000]
[null,"Hotels and restaurants",350]
[null,"Government and other offices",150]
[]
[]
[]
[]
[]
[]
["Annual Growth"]
[]
[null,null,"Growth Rate",null,{"$f":"G153/100","v":0},null,0]
[]
[null,null,"Code",null,null,"Initial Quantity",null,null,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035]
[null,"Household 1",1,"Capacity","Watt",{"$f":"F32","v":17},null,null,{"$f":"$E$153","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Household 2",2,"Capacity","Watt",79,null,null,{"$f":"I156","v":0},{"$f":"J156","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Household 3",3,"Capacity","Watt",2165,null,null,{"$f":"I157","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Street Lights",4,"Capacity","Watt",75,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Schools and colleges",5,"Capacity","Watt",328,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Health posts and clinics",6,"Capacity","Watt",125,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Church and mosque",7,"Capacity","Watt",20,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Agro processing mill",8,"Capacity","Watt",1500,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Saw/Furniture mill",9,"Capacity","Watt",2500,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Welding workshop",10,"Capacity","Watt",3000,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Local financial institutions",11,"Capacity","Watt",250,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Hotels and restaurants",12,"Capacity","Watt",70,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Government and other offices",13,"Capacity","Watt",150,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
["Total Quantity with Growth"]
[]
[null,null,"Code",null,null,"Initial Quantity",null,2020,{"$f":"H175+1","v":2021},{"$f":"I175+1","v":2022},2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035]
[null,"Household 1",1,"Capacity","Watt",{"$f":"F11","v":50},null,{"$f":"F176","v":50},{"$f":"H176*(1+I156)","v":50},50,50,50,50,50,50,50,50,50,50,50,50,50,50]
[null,"Household 2",2,"Capacity","Watt",50,null,50,{"$f":"H177*(1+I157)","v":50},50,50,50,50,50,50,50,50,50,50,50,50,50,50]
[null,"Household 3",3,"Capacity","Watt",36,null,36,{"$f":"H178*(1+I158)","v":36},36,36,36,36,36,36,36,36,36,36,36,36,36,36]
[null,"Street Lights",4,"Capacity","Watt",0,null,0,{"$f":"H179*(1+I159)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Schools and colleges",5,"Capacity","Watt",1,null,1,{"$f":"H180*(1+I160)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Health posts and clinics",6,"Capacity","Watt",0,null,0,{"$f":"H181*(1+I161)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Church and mosque",7,"Capacity","Watt",2,null,2,{"$f":"H182*(1+I162)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2]
[null,"Agro processing mill",8,"Capacity","Watt",0,null,0,{"$f":"H183*(1+I163)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Saw/Furniture mill",9,"Capacity","Watt",0,null,0,{"$f":"H184*(1+I164)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Welding workshop",10,"Capacity","Watt",2,null,2,{"$f":"H185*(1+I165)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2]
[null,"Local financial institutions",11,"Capacity","Watt",4,null,4,{"$f":"H186*(1+I166)","v":4},4,4,4,4,4,4,4,4,4,4,4,4,4,4]
[null,"Hotels and restaurants",12,"Capacity","Watt",5,null,5,{"$f":"H187*(1+I167)","v":5},5,5,5,5,5,5,5,5,5,5,5,5,5,5]
[null,"Government and other offices",13,"Capacity","Watt",1,null,1,{"$f":"H188*(1+I168)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1]

{"sheet":"End Uses","index":5,"n_rows":104,"n_cols":36,"rows_kept":104,"cut":false,"hidden":false,"merged":[]}
["Demand Selection"]
[null,null,null,null,null,null,null,null,null,null,null,"kwh=kw x hour"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percent of Hour"]
["Load by Hour of Day"]
[null,null,null,null,null,null,null,"Load in Watt","Hours of","Watthour","Watt Capacity","Watthour",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23]
[null,null,null,null,null,null,null,"Units x Watts","Full Load","for All Units"," for Single Unit"," for Single Unit"]
[null,null,{"$f":"'Energy Demand'!B32","v":"Household 1"},"T1: Light + Mobile/Radio","Bulb Living Room",null,null,{"$f":"TRANSPOSE('Energy Demand'!I46:AO46)","v":150},{"$f":"SUM(M7:AJ7)","v":4},{"$f":"H7*I7","v":600},{"$f":"TRANSPOSE('Energy Demand'!I47:AO47)","v":3},{"$f":"K7*I7","v":12},0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,0,0,0]
[null,null,{"$f":"C7","v":"Household 1"},null,"Bulb Kitchen",null,null,150,2,{"$f":"H8*I8","v":300},3,{"$f":"K8*I8","v":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.66666666666666663,0.66666666666666663,0.66666666666666663,0,0,0]
[null,null,{"$f":"C8","v":"Household 1"},null,"Bulb Other Rooms",null,null,300,4.9999999999999991,1499.9999999999998,6,29.999999999999993,0.2857142857142857,0.2857142857142857,0.2857142857142857,0.2857142857142857,0.5,0.5,0,0,0,0,0,0,0,0,0,0,0,0,0.66666666666666663,0.66666666666666663,0.66666666666666663,0.2857142857142857,0.2857142857142857,0.2857142857142857]
[null,null,{"$f":"C9","v":"Household 1"},null,"Mobile/Radio Charger",null,null,250,7.9999999999999991,1999.9999999999998,5,39.999999999999993,0.2857142857142857,0.2857142857142857,0.2857142857142857,0.2857142857142857,0,0,1,1,0,0,1,1,0,0,1,1,0,0,0,0,0,0.2857142857142857,0.2857142857142857,0.2857142857142857]
[null,null,{"$f":"'Energy Demand'!B33","v":"Household 2"},"T2: T1 + TV","Bulb Living Room",null,null,250,4,1000,5,20,0,0,0,0,0.5,0.5,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,0,0,0]
[null,null,{"$f":"C11","v":"Household 2"},null,"Bulb Kitchen",null,null,250,2,500,5,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.66666666666666663,0.66666666666666663,0.66666666666666663,0,0,0]
[null,null,{"$f":"C12","v":"Household 2"},null,"Bulb Other Rooms",null,null,450,4.9999999999999991,2249.9999999999995,9,44.999999999999993,0.2857142857142857,0.2857142857142857,0.2857142857142857,0.2857142857142857,0.5,0.5,0,0,0,0,0,0,0,0,0,0,0,0,0.66666666666666663,0.66666666666666663,0.66666666666666663,0.2857142857142857,0.2857142857142857,0.2857142857142857]
[null,null,{"$f":"C13","v":"Household 2"},null,"Mobile Charger",null,null,500,5,2500,10,50,0,0,0,0,0,0,1,1,0,0,1,1,0,0,0,0,0.5,0.5,0,0,0,0,0,0]
[null,null,{"$f":"C14","v":"Household 2"},null,"TV",null,null,2500,7.0000000000000018,17500.000000000004,50,350.00000000000011,0.14285714285714285,0.14285714285714285,0.14285714285714285,0.14285714285714285,0,0,0.5,0.5,0.5,0.5,0,0,0,0,0,0,1,1,0.66666666666666663,0.66666666666666663,0.66666666666666663,0.14285714285714285,0.14285714285714285,0.14285714285714285]
[null,null,{"$f":"'Energy Demand'!B34","v":"Household 3"},"T3: T2 + Home Appliances","Bulb Living Room",null,null,180,6.0000000000000009,1080.0000000000002,5,30.000000000000004,0.14285714285714285,0.14285714285714285,0.14285714285714285,0.14285714285714285,1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,0.14285714285714285,0.14285714285714285,0.14285714285714285]
[null,null,{"$f":"C16","v":"Household 3"},null,"Bulb Kitchen",null,null,180,2,360,5,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.66666666666666663,0.66666666666666663,0.66666666666666663,0,0,0]
[null,null,{"$f":"C17","v":"Household 3"},null,"Bulb Other Rooms",null,null,540,4.9999999999999991,2699.9999999999995,15,74.999999999999986,0.2857142857142857,0.2857142857142857,0.2857142857142857,0.2857142857142857,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0.66666666666666663,0.66666666666666663,0.66666666666666663,0.2857142857142857,0.2857142857142857,0.2857142857142857]
[null,null,"Household 3",null,"Smart Phone",null,null,360,6,2160,10,60,0.2857142857142857,0.2857142857142857,0.2857142857142857,0.2857142857142857,0,0,0.5,0.5,0,0,0.5,0.5,0,0,0,0,0,0,0.66666666666666663,0.66666666666666663,0.66666666666666663,0.2857142857142857,0.2857142857142857,0.2857142857142857]
[null,null,"Household 3",null,"Radio/TV",null,null,1800,6.0000000000000018,10800.000000000004,50,300.00000000000011,0.14285714285714285,0.14285714285714285,0.14285714285714285,0.14285714285714285,0,0,0.5,0.5,0.5,0.5,0.5,0.5,0,0,0,0,0,0,0.66666666666666663,0.66666666666666663,0.66666666666666663,0.14285714285714285,0.14285714285714285,0.14285714285714285]
[null,null,"Household 3",null,"Fan/cooler",null,null,1080,5.0000000000000009,5400.0000000000009,30,150.00000000000003,0.14285714285714285,0.14285714285714285,0.14285714285714285,0.14285714285714285,0,0,0,0,0,0,0.5,0.5,0.5,0.5,0,0,0,0,0.66666666666666663,0.66666666666666663,0.66666666666666663,0.14285714285714285,0.14285714285714285,0.14285714285714285]
[null,null,"Household 3",null,"Refrigerator",null,null,1800,9.9999999999999982,17999.999999999996,50,499.99999999999989,0,0,0,0,0,0,0,0,0.5,0.5,1,1,1,1,0.5,0.5,1,1,0.66666666666666663,0.66666666666666663,0.66666666666666663,0,0,0]
[null,null,"Household 3",null,"Iron",null,null,36000,0.2,7200,1000,200,0,0,0,0,0,0,0.1,0.1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Household 3",null,"Cooking Appliance",null,null,36000,0.49999999999999994,17999.999999999996,1000,499.99999999999994,0,0,0,0,0,0,0.125,0.125,0,0,0,0,0,0,0,0,0,0,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,0,0,0]
[null,null,{"$f":"'Energy Demand'!B35","v":"Street Lights"},"Street litghts","Lights",null,null,0,8,0,75,600,0.42857142857142855,0.42857142857142855,0.42857142857142855,0.42857142857142855,1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,0.42857142857142855,0.42857142857142855,0.42857142857142855]
[null,null,"Schools and colleges","Schools and colleges","Lights",null,null,28,4.9999999999999991,139.99999999999997,28,139.99999999999997,0,0,0,0,0,0,0,0,null,null,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.33333333333333331,0.33333333333333331,0.33333333333333331,0,0,0]
[null,null,{"$f":"C26","v":"Schools and colleges"},null,"Laptop and printer",null,null,300,9,2700,300,2700,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,0.5,0.5,0,0,0,0,0,0]
[null,null,{"$f":"C27","v":"Schools and colleges"},null,"Refrigerator",null,null,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]
[null,null,{"$f":"C28","v":"Schools and colleges"},null,"Multimedia projector",null,null,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]
[null,null,"Health posts and clinics","Health posts and clinics","Lights",null,null,0,2.9999999999999996,0,50,149.99999999999997,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0.66666666666666663,0.66666666666666663,0.66666666666666663,0,0,0]
[null,null,{"$f":"C30","v":"Health posts and clinics"},null,"Refrigerator",null,null,0,24,0,75,1800,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,{"$f":"C31","v":"Health posts and clinics"},null,"Laptop and printer",null,null,0,0.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.25,0.25,0,0,0,0,0,0]
[null,null,"Church and mosque","Church and mosque","Lights",null,null,40,12,480,20,240,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1]
[null,null,"Agro processing mill","Productive Uses","Agro processing mill",null,null,0,3.5,0,1500,5250,0,0,0,0,0,0,0,0,0.5,0.5,0.5,0.5,0.5,0.5,0.25,0.25,0,0,0,0,0,0,0,0]
[null,null,"Saw/Furniture mill",null,"Saw/Furniture mill",null,null,0,24,0,2500,60000,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"Welding workshop",null,"Welding workshop",null,null,6000,3,18000,3000,9000,0,0,0,0,0,0,0,0,0,0,0.5,0.5,0.5,0.5,0.5,0.5,0,0,0,0,0,0,0,0]
[null,null,"Local financial institutions",null,"Local financial institutions",null,null,1000,9,9000,250,2250,0,0,0,0,0,0,0,0,0.5,0.5,1,1,1,1,1,1,1,1,0,0,0,0,0,0]
[null,null,"Hotels and restaurants",null,"Hotels and restaurants",null,null,350,5.0000000000000009,1750.0000000000002,70,350.00000000000006,0.14285714285714285,0.14285714285714285,0.14285714285714285,0.14285714285714285,0,0,0,0,0.5,0.5,0,0,0,0,0,0,0.5,0.5,0.66666666666666663,0.66666666666666663,0.66666666666666663,0.14285714285714285,0.14285714285714285,0.14285714285714285]
[null,null,"Government and other offices",null,"Government and other offices",null,null,150,9,1350,150,1350,0,0,0,0,0,0,0,0,0.5,0.5,1,1,1,1,1,1,1,1,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M5","v":0},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23]
[null,null,null,null,"Total Energy Load",null,null,null,null,{"$f":"SUM(J7:J39)","v":127270},null,null,{"$f":"SUMPRODUCT(M7:M39,$H$7:$H$39)","v":1427.1428571428569},1427.1428571428569,1427.1428571428569,1427.1428571428569,720,1410,11180,11180,4100,4100,8634,8634,6804,6804,5614,5614,6039,6039,10136,10136,10136,1427.1428571428569,1427.1428571428569,1427.1428571428569]
[null,null,null,null,"Maximum Load",null,{"$f":"MAX(M42:AJ42)","v":11180}]
[]
[]
[]
[]
["Graphs",null,null,null,"Row",9]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M5","v":0},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23]
[null,null,null,null,{"$f":"INDEX(E:E,$F$48)","v":"Bulb Other Rooms"},null,null,null,null,null,null,null,{"$f":"INDEX(M:M,$F$48)","v":0.2857142857142857},0.2857142857142857,0.2857142857142857,0.2857142857142857,0.5,0.5,0,0,0,0,0,0,0,0,0,0,0,0,0.66666666666666663,0.66666666666666663,0.66666666666666663,0.2857142857142857,0.2857142857142857,0.2857142857142857]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Graphs",null,null,null,null,null,null,null,"Watthours/Day"]
[null,null,null,null,null,null,null,{"$f":"E7","v":"Bulb Living Room"},{"$f":"H7","v":150}]
[null,null,null,null,null,null,null,{"$f":"E8","v":"Bulb Kitchen"},{"$f":"H8","v":150}]
[null,null,null,null,null,null,null,"Bulb Other Rooms",300]
[null,null,null,null,null,null,null,"Mobile/Radio Charger",250]
[null,null,null,null,null,null,null,"Bulb Living Room",250]
[null,null,null,null,null,null,null,"Bulb Kitchen",250]
[null,null,null,null,null,null,null,"Bulb Other Rooms",450]
[null,null,null,null,null,null,null,"Mobile Charger",500]
[null,null,null,null,null,null,null,"TV",2500]
[null,null,null,null,null,null,null,"Bulb Living Room",180]
[null,null,null,null,null,null,null,"Bulb Kitchen",180]
[null,null,null,null,null,null,null,"Bulb Other Rooms",540]
[null,null,null,null,null,null,null,"Smart Phone",360]
[null,null,null,null,null,null,null,"Radio/TV",1800]
[null,null,null,null,null,null,null,"Fan/cooler",1080]
[null,null,null,null,null,null,null,"Refrigerator",1800]
[null,null,null,null,null,null,null,"Iron",36000]
[null,null,null,null,null,null,null,"Cooking Appliance",36000]
[null,null,null,null,null,null,null,"Lights",0]
[null,null,null,null,null,null,null,"Lights",28]
[null,null,null,null,null,null,null,"Laptop and printer",300]
[null,null,null,null,null,null,null,"Refrigerator",0]
[null,null,null,null,null,null,null,"Multimedia projector",0]
[null,null,null,null,null,null,null,"Lights",0]
[null,null,null,null,null,null,null,"Refrigerator",0]
[null,null,null,null,null,null,null,"Laptop and printer",0]
[null,null,null,null,null,null,null,"Lights",40]
[null,null,null,null,null,null,null,"Agro processing mill",0]
[null,null,null,null,null,null,null,"Saw/Furniture mill",0]
[null,null,null,null,null,null,null,"Welding workshop",6000]
[null,null,null,null,null,null,null,"Local financial institutions",1000]
[null,null,null,null,null,null,null,"Hotels and restaurants",350]

{"sheet":"Hydro","index":6,"n_rows":123,"n_cols":11,"rows_kept":123,"cut":false,"hidden":false,"merged":[]}
["          "]
[]
["Hydro Parameters"]
[]
[null,"Apply Hydro",null,null,null,{"$f":"'Minigrid Control'!$F$34","v":false}]
[null,"Generator",null,null,"kW",6,"Applied Hydro Capacity",null,20,"Base Hydro Capacity"]
[null,"Capacity Applied",null,null,"kW",{"$f":"F5*F6","v":0}]
[null,"Head",null,null,"m",33]
[null,"Gravity",null,null,"m/sec2",9.81]
[null,"Efficiency"]
[null,null,"Turbine",null,"%",0.76]
[null,null,"Generator",null,"%",0.9,null,null,null,3]
[]
[null,"Flow Rate",null,null,"m3/sec","m3/sec","Potential","Capacity","Production","Season"]
[null,null,"Season - Winter",null,0.09,{"$f":"G59","v":9.5000000000000001E-2},{"$f":"F15*$F$8*$F$9*$F$12*$F$11","v":21.035975400000002},{"$f":"$F$6","v":6},{"$f":"MIN(G15,H15)","v":6},"Winter"]
[null,null,"Season - Spring",null,0.09,{"$f":"G57","v":0.19},{"$f":"F16*$F$8*$F$9*$F$12*$F$11","v":42.071950800000003},{"$f":"$F$6","v":6},{"$f":"MIN(G16,H16)","v":6},"Spring"]
[null,null,"Season - Summer",null,0.09,0.09,{"$f":"F17*$F$8*$F$9*$F$12*$F$11","v":19.928818800000002},{"$f":"$F$6","v":6},{"$f":"MIN(G17,H17)","v":6},"Summer"]
[null,null,"Season - Autumn",null,0.09,{"$f":"G60","v":6.9000000000000006E-2},{"$f":"F18*$F$8*$F$9*$F$12*$F$11","v":15.278761080000002},{"$f":"$F$6","v":6},{"$f":"MIN(G18,H18)","v":6},"Autumn"]
[]
[null,null,{"$f":"INDEX(C15:C18,$J$12)","v":"Season - Summer"},null,{"$f":"INDEX(E15:E18,$J$12)","v":0.09},0.09,19.928818800000002,6,{"$f":"INDEX(I15:I18,$J$12)*F5","v":0},"Summer"]
[]
[]
["Costs"]
[null,null,"Hydro Cap Exp",null,"USD/kW",{"$f":"Hydro_Cost","v":3853},3853,"Hydro Cost",null,{"$f":"F37/20","v":4052.55},"Hydro Cost Base"]
[null,null,"Total Cap Exp",null,"USD ",{"$f":"F24*F6","v":23118}]
[null,null,"O&M Cost/kWy",null,"USD/kWy",{"$f":"Hydro_OM","v":10},10,"Hydro OM",null,10,"Hydro OM Base"]
[]
[null,null,"Project Life",null,"Years",30]
[]
[]
[]
[]
[]
["Notes"]
[null,null,null,"Civil Engineering Structure USD",null,35047]
[null,null,null,"Electromechanical equipment USD",null,46004]
[null,null,null,"Total",null,{"$f":"SUM(F35:F36)","v":81051}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Liters/m3",{"$f":"1/E54","v":1000}]
[]
[null,null,null,"m3/Litre",1E-3]
[]
[null,null,null,null,"L/Sec","m3/L","m3/Sec"]
[null,null,null,"Season 1",190,{"$f":"$E$54","v":1E-3},{"$f":"E57*F57","v":0.19}]
[null,null,null,"Season 2",95,{"$f":"$E$54","v":1E-3},{"$f":"E58*F58","v":9.5000000000000001E-2}]
[null,null,null,"Season 3",95,{"$f":"$E$54","v":1E-3},{"$f":"E59*F59","v":9.5000000000000001E-2}]
[null,null,null,"Season 4",69,{"$f":"$E$54","v":1E-3},{"$f":"E60*F60","v":6.9000000000000006E-2}]
[]
[]
[null,null,null,null,null,"m3/Second"]
[null,null,null,"2016-12-20",null,9.5000000000000001E-2]
[null,null,null,"2017-01-17",null,9.1999999999999998E-2]
[null,null,null,"2017-03-28",null,0.188]
[null,null,null,"2017-04-15",null,0.19]
[null,null,null,"2017-07-20",null,7.0999999999999994E-2]
[null,null,null,"2017-08-20",null,8.6999999999999994E-2]
[]
[]
[]
[]
[]
[null,null,null,"Basis of Estimate project developer's own"]
[null,null,null,"cost estimate or pro forma invoice"]
[null,null,null,"Civil Engineering"]
[null,null,null,"Structure"]
[null,null,null,"Dam/Weir project developer's own cost estimate referring",null,null,null,null,null,7242394,7936]
[null,null,null,"Sand trap and intake Explain",null,null,null,null,null,0,0]
[null,null,null,"Canal project developer's own cost estimate referring",null,null,null,null,null,10315118,11303]
[null,null,null,"Forebay project developer's own cost estimate referring",null,null,null,null,null,5514842,6043]
[null,null,null,"Penstock project developer's own cost estimate referring",null,null,null,null,null,3676865,4029]
[null,null,null,"Power house project developer's own cost estimate referring",null,null,null,null,null,4421547,4845]
[null,null,null,"Slope stabilisation Explain",null,null,null,null,null,null,0]
[null,null,null,"Preliminary sites works project developer's own cost estimate referring",null,null,null,null,null,547560,600]
[null,null,null,"Roads and bridges Explain",null,null,null,null,null,null,0]
[null,null,null,"Other Insurance for workers",null,null,null,null,null,265500,291]
[null,null,null,"Total",null,null,null,null,null,31083826,{"$f":"SUM(K79:K88)","v":35047}]
[null,null,null,"Turbine pro forma invoice Main cost of cross flow",null,null,null,null,null,null,12600]
[null,null,null,"Generator pro forma invoice Main cost of Generator and",null,null,null,null,null,null,4900]
[null,null,null,"Inlet valve pro forma invoice",null,null,null,null,null,null,1200]
[null,null,null,"Turbine controller pro forma invoice Load controller and ballast",null,null,null,null,null,null,2600]
[null,null,null,"pro forma invoice",null,null,null,null,null,null,2236]
[null,null,null,"Other pro forma invoice Shipment to Dar es Saalam",null,null,null,null,null,null,9800]
[null,null,null,"Duty taxes Assuming + VAT duties",null,null,null,null,null,20,18]
[null,null,null,"Total",null,null,null,null,null,null,46004]
[]
[null,null,null,"Distribution grid RWF Average of Beta prices and Crown solution",null,null,null,null,null,9944916,10897]
[null,null,null,"LV Poles Explain",null,null,null,null,null,4565000,5002]
[null,null,null,"Service connection",null,null,null,null,null,1296000,1420]
[null,null,null,"Meters/load limiters Pro forma invoice single phase meters;",null,null,null,null,null,10664,4]
[null,null,null,"Meters/load limiters Pro forma invoice single phase meters;",null,null,null,null,null,15392350,16866]
[null,null,null,"Other",null,null,null,null,null,2491,0]
[null,null,null,"Total",null,null,null,null,null,43203824,47341]
[null,null,null,"Virtual systems"]
[null,null,null,"Battery/SHS/PicoPV",null,null,null,null,null,0,4]
[null,null,null,"Expropriation project developer's own cost estimate",null,null,null,null,null,null,2402]
[null,null,null,"Simplified license kW USD",null,null,null,null,null,null,500]
[null,null,null,"Environmental management project developer's own cost estimate",null,null,null,null,null,null,1801]
[null,null,null,"Training of technicians Explain"]
[null,null,null,"Other project developer's own cost estimate",null,null,null,null,null,null,2092]
[null,null,null,"TOTAL",null,null,null,null,null,null,6295]
[null,null,null,"Table Total cost summary",null,null,null,null,null,null,0.33333333333333331]
[null,null,null,"Civil Engineering Structure",null,null,null,null,null,35047,26.02]
[null,null,null,"Electro mechanical equipment",null,null,null,null,null,46004,34.159999999999997]
[null,null,null,"Distribution system",null,null,null,null,null,47341,35.15]
[null,null,null,"Virtual system",null,null,null,null,null,null,0]
[null,null,null,"Office equipment",null,null,null,null,null,null,0]
[null,null,null,"Non Construction cost",null,null,null,null,null,6295,4.67]
[null,null,null,"TOTAL",null,null,null,null,null,null,134687]
[null,null,null,"Contingency *",null,null,null,null,null,13469,10]
[null,null,null,"GRAND TOTAL",null,null,null,null,null,null,148156]

{"sheet":"Diesel","index":7,"n_rows":75,"n_cols":12,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["          "]
[]
["Diesel Parameters"]
[]
[null,"Apply Diesel",null,null,"Flag",{"$f":"'Minigrid Control'!$F$73","v":false}]
[null,"Generator",null,null,"kW",10]
[null,"Diesel Applied",null,null,"kW",{"$f":"F5*F6","v":0}]
[null,"Heat Rate",null,null,"Litre/MWH",{"$f":"0.21*1000","v":210}]
[null,"BTU/Litre",null,null,"BTU/Litre",33025]
[null,"Litre/BTU",null,null,"Litre/BTU",{"$f":"1/F9","v":3.0280090840272521E-5}]
[null,"Heat Rate",null,null,"BTU/KWH",{"$f":"F8*F9/1000","v":6935.25}]
[]
[null,"Diesel Price",null,null,"USD/Litre",1.145]
[null,"Diesel Price",null,null,"USD/MMBTU",{"$f":"F13*F10*1000000","v":34.67070401211204}]
[null,"Diesel Cost",null,null,"USD/MWH",{"$f":"F14*F11/1000","v":240.45000000000002}]
[]
[]
["Costs and Life"]
[null,null,"Diesel Cost",null,"USD/kW",{"$f":"Hydro_Cost","v":650},650,"Diesel Cost",null,650,"Diesel Cost Base"]
[null,null,"Total Cap Exp",null,"USD ",{"$f":"F19*F6","v":6500}]
[null,null,"O&M Cost/kWy",null,"USD/kWy",{"$f":"Hydro_OM","v":15},15,"Diesel OM",null,15,"Diesel OM Base"]
[null,null,"Variable O&M",null,"USD/MWH",4]
[]
[null,null,"Project Life",null,"Years",20]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Diesel Efficiency "]
[]
[null,null,null,null,"Load ","Load / ","Engine  Power","Fuel  Rate","Fuel Efficiency","Litre/","MBTU","MMBTU"]
[null,null,null,null,"Percent","kW","kW","Litres  / hour","kWh  / litre","MWH","per Liter","per MWH"]
[null,null,null,null,100,925,983.2,233,3.97,{"$f":"1/I66*1000","v":251.88916876574308},3.0599999999999999E-2,{"$f":"J66/K66/1000","v":8.2316721818870278}]
[null,null,null,null,90,832.5,886,209.2,3.98,{"$f":"1/I67*1000","v":251.25628140703515},3.0599999999999999E-2,{"$f":"J67/K67/1000","v":8.2109895884652015}]
[null,null,null,null,80,740,789.8,186.6,3.97,251.88916876574308,3.0599999999999999E-2,8.2316721818870278]
[null,null,null,null,75,693.8,742,175.9,3.94,253.80710659898475,3.0599999999999999E-2,8.2943498888557112]
[null,null,null,null,70,647.5,694.2,165.2,3.92,255.10204081632654,3.0599999999999999E-2,8.3366680005335478]
[null,null,null,null,60,555,599,144,3.85,259.74025974025972,3.0599999999999999E-2,8.4882437823614296]
[null,null,null,null,50,462.5,504.4,123,3.76,265.95744680851061,3.0599999999999999E-2,8.6914198303434844]
[null,null,null,null,40,370,413.1,102.8,3.6,277.77777777777777,3.0599999999999999E-2,9.0777051561365294]
[null,null,null,null,30,277.5,319.60000000000002,82.3,3.37,296.73590504451039,3.0599999999999999E-2,9.6972517988402096]
[null,null,null,null,25,231.3,272,71.900000000000006,3.22,310.55900621118008,3.0599999999999999E-2,10.148987131084317]

{"sheet":"Solar and Battery","index":8,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Alterantive Solar and Battery Costs"]
[null,"Capacity",null,"kW",{"$f":"'Sample Prices'!K2","v":7},{"$f":"'Sample Prices'!L2","v":7},{"$f":"'Sample Prices'!R2","v":5},{"$f":"'Sample Prices'!S2","v":5},{"$f":"'Sample Prices'!W2","v":3},{"$f":"'Sample Prices'!X2","v":3},{"$f":"'Sample Prices'!AG2","v":2},{"$f":"'Sample Prices'!AH2","v":5}]
[null,"Storage Hours",null,"Hrs",5,5,5,5,{"$f":"'Sample Prices'!W4","v":1},{"$f":"'Sample Prices'!X4","v":1},5,5]
[null,"Energy",null,"kWh",{"$f":"E4*E5","v":35},35,25,25,3,3,10,25]
[null,"Total Cost",null,"USD",{"$f":"'Sample Prices'!K3","v":4800},{"$f":"'Sample Prices'!L3","v":7500},{"$f":"'Sample Prices'!R3","v":4000},{"$f":"'Sample Prices'!S3","v":4500},{"$f":"'Sample Prices'!W3","v":900},{"$f":"'Sample Prices'!X3","v":2370},{"$f":"'Sample Prices'!AG3","v":2500},{"$f":"'Sample Prices'!AH3","v":4500}]
[null,"Cost/kW",null,"USD/kW",{"$f":"E7/E4","v":685.71428571428567},1071.4285714285713,800,900,300,790,1250,900]
[null,"Cost/kWh",null,"USD/kWh",{"$f":"E7/E6","v":137.14285714285714},214.28571428571428,160,180,300,790,250,180]
[]
["Solar and Battery Parameters"]
[null,"Include Solar",null,"Flag",{"$f":"'Minigrid Control'!F50","v":true}]
[null,"Solar Capacity",null,"kW",29,null,null,null,65,"Base Solar Capacity"]
[null,"Solar Capacity Applied",null,"kW",{"$f":"E13*E12","v":29}]
[null,"Include Battery",null,null,{"$f":"'Minigrid Control'!$F$61","v":true}]
[null,"Base Battery Capacity",null,"kWh",57]
[null,"Base Battery Capacity",null,"kWh",{"$f":"E15*E16","v":57},"Applied Battery",null,null,250,"Base Solar Capacity"]
[null,"Round Trip Efficiecny",null,"%",{"$f":"G18/100","v":0.95},"Round Trip",95,null,80,"Base Round Trip"]
[null,"Depth of Discharge",null,"%",{"$f":"G19/100","v":0.05},"Depth Discharge",5,null,15,"Base Depth Discharge"]
[]
[null,"Solar and Battery Cost"]
[null,"Capital Cost"]
[null,null,"Solar and Inverter","USD/kW",890,"Solar Cost",null,null,600,"Base Solar Cost"]
[null,null,"Battery Cost","USD/kWh",130,"Battery Cost",null,null,150,"Base Battery Cost"]
[]
[null,"Applied O&M Cost"]
[null,null,"Solar and Inverter","USD/kWy",4,"Solar OM",null,null,5,"Base Solar OM"]
[null,null,"Battery Cost","USD/kWhy",{"$f":"G28/10","v":0.1},"Battery OM",1,null,1,"Base Battery OM"]

{"sheet":"Solar Production","index":9,"n_rows":69,"n_cols":31,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
["          "]
[]
[null,"          ",null,null,null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23]
[null,null,null,"Row",11]
[]
[null,1,{"$f":"D6&\" \"&E6","v":"January Typical"},"January","Typical","2013-01-25",0,0,0,0,0,0.12821694540042392,0.37091871428098722,0.58057253709288503,0.62419166178660757,0.56123778514034095,0.43443096115006347,0.69135697485915026,0.19990600366793285,0.43341832362734095,0.33470982491709422,9.4071186690302174E-3,4.2019725241945836E-3,0,0,0,0,0,0,0]
[null,2,{"$f":"D7&\" \"&E7","v":"May Typical"},"May","Typical","2013-05-01",0,0,0,0,0,2.4625073216113305E-2,0.13593948949894369,0.35483008074240435,0.53223092526048421,0.43881274781380686,0.70760649473311898,0.37874536130240372,0.43583161865812831,0.38364766258063071,0.14771258368835377,5.5799166672637984E-2,0,0,0,0,0,0,0,0]
[null,3,"July Typical","July","Typical","2013-07-01",0,0,0,0,0,4.6789531891031577E-2,0.35176377646799206,0.53835406990722734,0.59846877592903813,0.70284615198611466,0.73057538508496644,0.67612955640998562,0.60059815389737992,0.45670898664995996,0.1197467530374641,5.7616235872289707E-2,0,0,0,0,0,0,0,0]
[null,4,"November Typical","November","Typical","2013-11-06",0,0,0,0,1.2161114174752342E-2,8.1607227648941211E-2,8.0840651580338138E-2,0.2140734650839673,0.85984282361643893,0.90558186237642191,0.44501160367720211,0.6950478966709428,0.49646683929442276,6.2452289835946077E-2,0.28345333124358552,4.7215407484699955E-2,0,0,0,0,0,0,0,0]
[null,5,"January Low","January","Low","2013-01-03",0,0,0,0,0,2.2050891849940045E-2,3.0994279316975813E-2,5.1578266344280366E-2,0.26752558404038845,0.47220139435740716,0.42476831712483221,0.70662224891664094,0.10731118570234771,6.7449230134988283E-2,4.8019839161629094E-2,6.4155792210619553E-2,0,0,0,0,0,0,0,0]
[null,6,"May Low","May","Low","2013-05-04",0,0,0,0,0,1.5710077455322092E-2,0.10444362337164735,0.2236509339904649,0.22447429347155703,0.33187065429263846,0.43201766611927606,6.0748787461272595E-2,9.9399363562197557E-2,0.25647174640917386,4.0761026265103764E-2,3.9956594588174625E-2,0,0,0,0,0,0,0,0]
[null,7,"July Low","July","Low","2013-08-02",0,0,0,0,0,2.7852263825911397E-2,0.11824199260650255,0.50019561671454127,0.53011101119422388,0.45613168862298725,0.67399071453956227,0.27942170895685825,0.17176982277957589,0.23244289902419635,0.17567841433924333,6.8878279349297716E-2,0,0,0,0,0,0,0,0]
[null,8,"November Low","November","Low","2013-11-16",0,0,0,0,1.8170691996517118E-2,0.18937268065120186,0.31146648140488276,0.37164743474126422,6.7146385268379669E-2,0.10492628237780484,9.8576004081105367E-2,0.23937993924994999,0.33037535776375837,0.47667782004196579,0.28878150811548092,4.7802169413754148E-2,0,0,0,0,0,0,0,0]
[null,9,"January High","January","High","2013-01-07",0,0,0,0,0,7.2824726517291272E-2,0.36330027310536411,0.57967346639514072,0.71154347799903106,0.84028093801393855,0.81616691551022724,0.833656206556875,0.76836474609647309,0.54308602094798697,0.38725340927368962,8.7948042043559174E-2,0,0,0,0,0,0,0,0]
[null,10,"May High","May","High","2013-05-09",0,0,0,0,0,6.6446056514347235E-2,0.18431895693967049,0.42562006831216898,0.70478625191282629,0.84029986581810157,0.85610458229423891,0.81041286304466353,0.61007151988098074,0.24555986730918214,0.11869625990641547,5.9584727505245724E-2,0,0,0,0,0,0,0,0]
[null,11,"July High","July","High","2013-07-13",0,0,0,0,0,5.4985271093627323E-2,0.33642279119384927,0.53364104667063061,0.67493710474771418,0.76000812055849143,0.78976262870278835,0.7478091507754131,0.66942911373627001,0.53616790852639618,0.1246774460219357,6.9020237880520502E-2,0,0,0,0,0,0,0,0]
[null,12,"November High","November","High","2013-11-02",0,0,0,0,0,0.10194515322212624,0.42563899611633194,0.65855509024460435,0.72201055370119138,0.67320521066679628,0.83111041689694642,0.84342295350500296,0.72659108230864689,0.55718723504945067,0.28951022857575792,3.0095208619231478E-3,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,{"$f":"G3","v":0},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23]
[null,null,{"$f":"INDEX(C6:C17,$E$4)","v":"July High"},{"$f":"INDEX(D6:D17,$E$4)","v":"July"},"High","2013-07-13",0,0,0,0,0,5.4985271093627323E-2,0.33642279119384927,0.53364104667063061,0.67493710474771418,0.76000812055849143,0.78976262870278835,0.7478091507754131,0.66942911373627001,0.53616790852639618,0.1246774460219357,6.9020237880520502E-2,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Capacity Factor Data",null,null,null,null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23]
[null,null,null,"Area 6","Spring","2016-04-09",{"$f":"AVERAGE(H30:AE30)","v":0.17283958333333335},0,0,0,0,0,2.3019999999999999E-2,0.18187999999999999,0.19572000000000001,0.52816999999999992,0.61975000000000002,0.60487999999999997,0.67974999999999997,0.43069000000000002,0.53024000000000004,0.34300000000000003,1.1050000000000001E-2,0,0,0,0,0,0,0,0]
[null,null,null,"Area 6","Spring","2012-04-09",{"$f":"AVERAGE(H31:AE31)","v":0.15746041666666669},0,0,0,0,0,3.6150000000000002E-2,0.12881000000000001,0.65240999999999993,0.61465000000000003,0.75400999999999996,0.67852000000000001,0.44223000000000001,0.10199,0.26669999999999999,8.0810000000000007E-2,2.2769999999999999E-2,0,0,0,0,0,0,0,0]
[null,null,null,"Area 6","Summer","2016-07-13",0.2069391666666667,0,0,0,0,0,2.4559999999999998E-2,0.15364,0.28305999999999998,0.61036999999999997,0.71475999999999995,0.72872999999999999,0.70740000000000003,0.67932999999999999,0.61859000000000008,0.43135000000000001,1.4749999999999999E-2,0,0,0,0,0,0,0,0]
[null,null,null,"Area 6","Summer","2012-07-13",0.23781874999999997,0,0,0,0,0,2.3309999999999997E-2,0.47399000000000002,0.56258000000000008,0.69184000000000001,0.74070000000000003,0.71002999999999994,0.74623000000000006,0.54603000000000002,0.47202999999999995,0.53773000000000004,0.20318,0,0,0,0,0,0,0,0]
[null,null,null,"Area 1","Summer","2016-07-13",0.19974666666666671,0,0,0,0,0,3.934E-2,0.24023,0.44052999999999998,0.58698000000000006,0.67732999999999999,0.70604999999999996,0.67815000000000003,0.5990700000000001,0.46561000000000002,0.29952000000000001,6.1109999999999998E-2,0,0,0,0,0,0,0,0]
[null,null,null,"Area 1","Summer","2012-07-13",0.20499500000000004,0,0,0,0,0,8.6249999999999993E-2,0.23419999999999999,0.46905999999999998,0.60954999999999993,0.68337000000000003,0.70921000000000001,0.68700000000000006,0.60707,0.48149999999999998,0.30517,4.7500000000000001E-2,0,0,0,0,0,0,0,0]
[null,null,null,"Area 1","Summer","2016-07-11",0.17047916666666665,0,0,0,0,0,2.051E-2,0.14602999999999999,0.30351999999999996,0.54196,0.63273999999999997,0.67764000000000002,0.66766999999999999,0.48288999999999999,0.24265,0.31783999999999996,5.8049999999999997E-2,0,0,0,0,0,0,0,0]
[null,null,null,"Area 1","Summer","2012-07-11",0.20649250000000005,0,0,0,0,0,9.4500000000000001E-2,0.29513,0.47691,0.61234,0.68013000000000001,0.70596000000000003,0.67742999999999998,0.59935000000000005,0.46450000000000002,0.30232999999999999,4.7240000000000004E-2,0,0,0,0,0,0,0,0]
[null,null,null,"Area 2","Spring","2016-04-11",0.2040858333333333,0,0,0,0,0,4.1000000000000002E-2,0.24600999999999998,0.42501,0.60001000000000004,0.82899999999999996,0.82099999999999995,0.46300000000000002,0.70401000000000002,0.57301000000000002,0.18400999999999998,1.2E-2,0,0,0,0,0,0,0,0]
[null,null,null,"Area 2","Spring","2012-04-11",9.0333333333333321E-2,0,0,0,0,0,5.0000000000000001E-3,4.0000000000000001E-3,0.13900000000000001,0.22500000000000001,0.38500000000000001,0.50600000000000001,0.28599999999999998,0.19,0.22900000000000001,0.14899999999999999,0.05,0,0,0,0,0,0,0,0]
[null,null,null,"Area 3","Summer","2016-06-11",0.19887708333333334,0,0,0,0,0,0.11234000000000001,0.33071,0.49837999999999999,0.62285999999999997,0.68223,0.68070000000000008,0.66500999999999999,0.52607000000000004,0.29102999999999996,0.28426999999999997,7.9450000000000007E-2,0,0,0,0,0,0,0,0]
[null,null,null,"Area 3","Summer","2012-06-11",0.10458291666666668,0,0,0,0,0,3.6380000000000003E-2,1.9609999999999999E-2,3.3790000000000001E-2,0.19047999999999998,0.47447,0.29002,0.41099000000000002,0.22359999999999999,0.46979000000000004,0.27700999999999998,8.3849999999999994E-2,0,0,0,0,0,0,0,0]
[null,null,null,"Area 3","Spring","2016-05-10",0.16992249999999998,0,0,0,0,0,0.10387,0.26691000000000004,0.4496,0.47514000000000001,0.55235000000000001,0.61039999999999994,0.61676999999999993,0.58345000000000002,0.31423000000000001,9.5579999999999998E-2,9.8399999999999998E-3,0,0,0,0,0,0,0,0]
[null,null,null,"Area 3","Spring","2012-05-10",0.12808250000000002,0,0,0,0,0,2.4369999999999999E-2,0.20727000000000001,0.24922,7.7519999999999992E-2,0.42802999999999997,0.73648999999999998,0.60250999999999999,0.31945000000000001,0.17913999999999999,0.16946,8.0519999999999994E-2,0,0,0,0,0,0,0,0]
[null,null,null,"Area 4","Spring","2016-04-10",0.16582958333333334,0,0,0,0,0,0.10453,0.29583999999999999,0.54458000000000006,0.66291999999999995,0.76073000000000002,0.80537000000000003,0.52849000000000002,5.3789999999999998E-2,8.9700000000000002E-2,4.7719999999999999E-2,8.6239999999999997E-2,0,0,0,0,0,0,0,0]
[null,null,null,"Area 4","Fall","2012-10-10",0.21278708333333332,0,0,0,0,0,0.13131999999999999,0.32621,0.54500999999999999,0.50670999999999999,0.70444000000000007,0.79408000000000001,0.67365999999999993,0.65098,0.47105999999999998,0.23385,6.9569999999999993E-2,0,0,0,0,0,0,0,0]
[null,null,null,"Area 4","Summer","2016-07-09",0.17780666666666667,0,0,0,0,0,8.1709999999999991E-2,0.25901999999999997,0.38394,0.57578999999999991,0.64772000000000007,0.66486999999999996,0.61926000000000003,0.42233999999999999,0.28658,0.21328,0.11284999999999999,0,0,0,0,0,0,0,0]
[null,null,null,"Area 4","Summer","2012-07-09",0.19603041666666662,0,0,0,0,0,9.0389999999999998E-2,0.12856999999999999,0.44469999999999998,0.52800999999999998,0.68240000000000001,0.64602999999999999,0.68212000000000006,0.60546,0.48673,0.30543999999999999,0.10488,0,0,0,0,0,0,0,0]
[null,null,null,"Area 5","Winter","2016-01-09",0.18442333333333336,0,0,0,0,0,5.5630000000000006E-2,0.18872999999999998,0.33620999999999995,0.50367000000000006,0.65937999999999997,0.67725999999999997,0.65709000000000006,0.57574000000000003,0.45362999999999998,0.22333,9.5489999999999992E-2,0,0,0,0,0,0,0,0]
[null,null,null,"Area 5","Summer","2012-07-09",0.20233875000000001,0,0,0,0,0,5.9609999999999996E-2,0.25508000000000003,0.44508999999999999,0.58184999999999998,0.67186000000000001,0.67419000000000007,0.66705999999999999,0.60159000000000007,0.47993999999999998,0.30648999999999998,0.11337,0,0,0,0,0,0,0,0]
[]
[null,"Selections by Season"]
[]
[null,null,null,"Winter",20]
[null,null,null,null,null,null,null,{"$f":"H29","v":0},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23]
[null,null,null,{"$f":"INDEX(D:D,$E$53)","v":"July"},"High","2013-07-13",0,0,0,0,0,5.4985271093627323E-2,0.33642279119384927,0.53364104667063061,0.67493710474771418,0.76000812055849143,0.78976262870278835,0.7478091507754131,0.66942911373627001,0.53616790852639618,0.1246774460219357,6.9020237880520502E-2,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Spring",11]
[null,null,null,null,null,null,null,{"$f":"H54","v":0},{"$f":"I54","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23]
[null,null,null,{"$f":"INDEX(D:D,$E$57)","v":"May"},"Low","2013-05-04",0,0,0,0,0,1.5710077455322092E-2,0.10444362337164735,0.2236509339904649,0.22447429347155703,0.33187065429263846,0.43201766611927606,6.0748787461272595E-2,9.9399363562197557E-2,0.25647174640917386,4.0761026265103764E-2,3.9956594588174625E-2,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Summer",5]
[null,null,null,null,null,null,null,{"$f":"H58","v":0},{"$f":"I58","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23]
[null,null,null,{"$f":"INDEX(D:D,$E$61)","v":0},0,"00:00:00",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]
[]
[null,null,null,"Fall",17]
[null,null,null,null,null,null,null,{"$f":"H62","v":0},{"$f":"I62","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23]
[null,null,null,{"$f":"INDEX(D:D,$E$65)","v":"November"},"High","2013-11-02",0,0,0,0,0,0.10194515322212624,0.42563899611633194,0.65855509024460435,0.72201055370119138,0.67320521066679628,0.83111041689694642,0.84342295350500296,0.72659108230864689,0.55718723504945067,0.28951022857575792,3.0095208619231478E-3,0,0,0,0,0,0,0,0,0]
[]
[null,"Graphs"]

{"sheet":"Demand and Supply Dispatch","index":10,"n_rows":110,"n_cols":30,"rows_kept":110,"cut":false,"hidden":false,"merged":[]}
["Parameters"]
[null,"Daily Energy",{"$f":"'End Uses'!J42","v":127270}]
[]
[null,"Hydro Energy (kWhour)",{"$f":"Hydro!$I$20","v":0},null,null,null,null,"Hydro Season"]
[null,"Solar Capacity (kW)",{"$f":"'Solar and Battery'!E14","v":29},null,null,null,null,"Solar Shape"]
[null,"Battery Capacity (kWh)",{"$f":"'Solar and Battery'!E17","v":57}]
[null,"Diesel Capacity (kW)",{"$f":"Diesel!F7","v":0}]
[null,null,null,"Max Watt","Watthour","CF/LF","Watts per Hour"]
[null,null,null,null,null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23]
["Chronological Analysis"]
[null,"Demand ","kW/kWh",{"$f":"MAX(G11:AD11)","v":11.18},{"$f":"SUM(G11:AD11)","v":127.27},null,{"$f":"'End Uses'!M42/1000","v":1.4271428571428568},{"$f":"'End Uses'!N42/1000","v":1.4271428571428568},{"$f":"'End Uses'!O42/1000","v":1.4271428571428568},{"$f":"'End Uses'!P42/1000","v":1.4271428571428568},{"$f":"'End Uses'!Q42/1000","v":0.72},{"$f":"'End Uses'!R42/1000","v":1.41},{"$f":"'End Uses'!S42/1000","v":11.18},{"$f":"'End Uses'!T42/1000","v":11.18},{"$f":"'End Uses'!U42/1000","v":4.0999999999999996},{"$f":"'End Uses'!V42/1000","v":4.0999999999999996},{"$f":"'End Uses'!W42/1000","v":8.6340000000000003},{"$f":"'End Uses'!X42/1000","v":8.6340000000000003},{"$f":"'End Uses'!Y42/1000","v":6.8040000000000003},{"$f":"'End Uses'!Z42/1000","v":6.8040000000000003},{"$f":"'End Uses'!AA42/1000","v":5.6139999999999999},{"$f":"'End Uses'!AB42/1000","v":5.6139999999999999},{"$f":"'End Uses'!AC42/1000","v":6.0389999999999997},{"$f":"'End Uses'!AD42/1000","v":6.0389999999999997},{"$f":"'End Uses'!AE42/1000","v":10.135999999999999},{"$f":"'End Uses'!AF42/1000","v":10.135999999999999},{"$f":"'End Uses'!AG42/1000","v":10.135999999999999},{"$f":"'End Uses'!AH42/1000","v":1.4271428571428568},{"$f":"'End Uses'!AI42/1000","v":1.4271428571428568},{"$f":"'End Uses'!AJ42/1000","v":1.4271428571428568}]
[]
[null,"Solar Capacity Factor",null,null,null,{"$f":"AVERAGE(G13:AD13)","v":0.22070253416281818},{"$f":"'Solar Production'!H55","v":0},{"$f":"'Solar Production'!I55","v":0},{"$f":"'Solar Production'!J55","v":0},{"$f":"'Solar Production'!K55","v":0},{"$f":"'Solar Production'!L55","v":5.4985271093627323E-2},{"$f":"'Solar Production'!M55","v":0.33642279119384927},{"$f":"'Solar Production'!N55","v":0.53364104667063061},{"$f":"'Solar Production'!O55","v":0.67493710474771418},{"$f":"'Solar Production'!P55","v":0.76000812055849143},{"$f":"'Solar Production'!Q55","v":0.78976262870278835},{"$f":"'Solar Production'!R55","v":0.7478091507754131},{"$f":"'Solar Production'!S55","v":0.66942911373627001},{"$f":"'Solar Production'!T55","v":0.53616790852639618},{"$f":"'Solar Production'!U55","v":0.1246774460219357},{"$f":"'Solar Production'!V55","v":6.9020237880520502E-2},{"$f":"'Solar Production'!W55","v":0},{"$f":"'Solar Production'!X55","v":0},{"$f":"'Solar Production'!Y55","v":0},{"$f":"'Solar Production'!Z55","v":0},{"$f":"'Solar Production'!AA55","v":0},{"$f":"'Solar Production'!AB55","v":0},{"$f":"'Solar Production'!AC55","v":0},{"$f":"'Solar Production'!AD55","v":0},{"$f":"'Solar Production'!AE55","v":0}]
[null,"Solar Production","kW/kWh",{"$f":"C5","v":29},{"$f":"SUM(G14:AD14)","v":153.60896377732146},null,{"$f":"$D$14*G13","v":0},{"$f":"$D$14*H13","v":0},0,0,1.5945728617151924,9.7562609446216282,15.475590353448288,19.573176037683712,22.040235496196253,22.903116232380864,21.686465372486978,19.41344429835183,15.548869347265489,3.6156459346361354,2.0015868985350944,0,0,0,0,0,0,0,0,0]
[null,"Hydro Production","kW/kWh",{"$f":"C4","v":0},{"$f":"SUM(G15:AD15)","v":0},null,{"$f":"$D$15","v":0},{"$f":"$D$15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Renewable Production","kW/kWh",{"$f":"SUM(D14:D15)","v":29},{"$f":"SUM(G16:AD16)","v":153.60896377732146},null,{"$f":"G14+G15","v":0},{"$f":"H14+H15","v":0},0,0,1.5945728617151924,9.7562609446216282,15.475590353448288,19.573176037683712,22.040235496196253,22.903116232380864,21.686465372486978,19.41344429835183,15.548869347265489,3.6156459346361354,2.0015868985350944,0,0,0,0,0,0,0,0,0]
[]
[null,"Deficit from Load and Renewable","kW/kWh",null,{"$f":"SUM(G18:AD18)","v":64.890767166828752},null,{"$f":"MAX(G11-G16,0)","v":1.4271428571428568},{"$f":"MAX(H11-H16,0)","v":1.4271428571428568},1.4271428571428568,1.4271428571428568,0,0,0,0,0,0,0,0,0,3.1883540653638649,3.6124131014649055,5.6139999999999999,6.0389999999999997,6.0389999999999997,10.135999999999999,10.135999999999999,10.135999999999999,1.4271428571428568,1.4271428571428568,1.4271428571428568]
[null,"Surplus from Load and Renewable","kW/kWh",null,{"$f":"SUM(G19:AD19)","v":91.229730944150248},null,{"$f":"MAX(G16-G11,0)","v":0},{"$f":"MAX(H16-H11,0)","v":0},0,0,0.87457286171519244,8.346260944621628,4.2955903534482882,8.3931760376837126,17.940235496196252,18.803116232380866,13.052465372486978,10.77944429835183,8.7448693472654888,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Start of Charge",null,null,null,null,{"$f":"AND(G19>0,F19=0,H19>0)","v":false},{"$f":"AND(H19>0,G19=0,I19>0)","v":false},{"$f":"AND(I19>0,H19=0,J19>0)","v":false},false,true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,1,null,null,null,{"$f":"F22+G21","v":0},{"$f":"G22+H21","v":0},{"$f":"H22+I21","v":0},0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"First Period of Charge for Storage Analysis",{"$f":"MAX(C22,0)","v":1},{"$f":"IFERROR(MATCH(C23,G22:AD22,0)-1,2)","v":4}]
[]
["Re-Ordered Hourly Analysis Beginning with Charge"]
[null,"Time Period Re-Order and Battery Balance",null,null,null,null,{"$f":"D23","v":4},{"$f":"IF(G26>=23,0,G26+1)","v":5},{"$f":"IF(H26>=23,0,H26+1)","v":6},7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,0,1,2,3]
[null,"Match of Re-order",null,null,null,null,{"$f":"MATCH(G26,9:9,0)","v":11},12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,7,8,9,10]
[]
[null,"Demand",null,null,{"$f":"SUM(G29:AD29)","v":127.26999999999998},null,{"$f":"INDEX(11:11,G27)","v":0.72},1.41,11.18,11.18,4.0999999999999996,4.0999999999999996,8.6340000000000003,8.6340000000000003,6.8040000000000003,6.8040000000000003,5.6139999999999999,5.6139999999999999,6.0389999999999997,6.0389999999999997,10.135999999999999,10.135999999999999,10.135999999999999,1.4271428571428568,1.4271428571428568,1.4271428571428568,1.4271428571428568,1.4271428571428568,1.4271428571428568,1.4271428571428568]
[null,"Renewable Production",null,null,{"$f":"SUM(G30:AD30)","v":153.60896377732146},null,{"$f":"INDEX(14:14,G27)+INDEX(15:15,G27)","v":1.5945728617151924},{"$f":"INDEX(14:14,H27)+INDEX(15:15,H27)","v":9.7562609446216282},15.475590353448288,19.573176037683712,22.040235496196253,22.903116232380864,21.686465372486978,19.41344429835183,15.548869347265489,3.6156459346361354,2.0015868985350944,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Demand Directly Met from Renewable (Min Demand, Renewable)",null,null,null,null,{"$f":"MIN(G29,G30)","v":0.72},{"$f":"MIN(H29,H30)","v":1.41},11.18,11.18,4.0999999999999996,4.0999999999999996,8.6340000000000003,8.6340000000000003,6.8040000000000003,3.6156459346361354,2.0015868985350944,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Demand to be Met from Batteries and Diesel (Deamnd - Met)",null,null,null,null,{"$f":"G29-G32","v":0},{"$f":"H29-H32","v":0},0,0,0,0,0,0,0,3.1883540653638649,3.6124131014649055,5.6139999999999999,6.0389999999999997,6.0389999999999997,10.135999999999999,10.135999999999999,10.135999999999999,1.4271428571428568,1.4271428571428568,1.4271428571428568,1.4271428571428568,1.4271428571428568,1.4271428571428568,1.4271428571428568]
[null,"Renewable Available for Battery Storage",null,null,null,null,{"$f":"G30-G32","v":0.87457286171519244},{"$f":"H30-H32","v":8.346260944621628},4.2955903534482882,8.3931760376837126,17.940235496196252,18.803116232380866,13.052465372486978,10.77944429835183,8.7448693472654888,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Losses from Charge versus Discharge",null,{"$f":"1-'Consumer Economics'!K22","v":5.0000000000000044E-2},null,null,{"$f":"G34*$D$35","v":4.3728643085759661E-2},{"$f":"H34*$D$35","v":0.41731304723108176},0.2147795176724146,0.41965880188418603,0.89701177480981342,0.94015581161904416,0.6526232686243495,0.53897221491759195,0.43724346736327485,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Maximum Battery Storage Balance",null,{"$f":"C6","v":57},null,null,{"$f":"$D$37","v":57},57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57]
[null,"Less: Opening Balance",null,null,null,null,{"$f":"G44","v":0},{"$f":"H44","v":0.83084421862943281},8.7597921160199803,12.840602951795855,20.814120187595382,37.857343908981818,55.720304329743641,57,57,57,53.811645934636132,50.19923283317123,44.585232833171233,38.546232833171231,32.50723283317123,22.371232833171231,12.235232833171231,2.0992328331712322,0.67208997602837539,0,0,0,0,0]
[null,"Remaining to Charge",null,null,null,null,{"$f":"G37-G38","v":57},56.16915578137057,48.24020788398002,44.159397048204141,36.185879812404622,19.142656091018182,1.2796956702563591,0,0,0,3.1883540653638676,6.8007671668287699,12.414767166828767,18.453767166828769,24.49276716682877,34.628767166828766,44.764767166828769,54.900767166828771,56.327910023971626,57,57,57,57,57]
[null,"Input to Battery",null,{"$f":"1-D41","v":0.95},null,null,{"$f":"MIN(G39/$D$40,G34)","v":0.87457286171519244},{"$f":"MIN(H39/$D$40,H34)","v":8.346260944621628},4.2955903534482882,8.3931760376837126,17.940235496196252,18.803116232380866,1.3470480739540622,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Less: Losses from Round Trip Efficiency",null,{"$f":"D35","v":5.0000000000000044E-2},null,null,{"$f":"G40*$D$41","v":4.3728643085759661E-2},{"$f":"H40*$D$41","v":0.41731304723108176},0.2147795176724146,0.41965880188418603,0.89701177480981342,0.94015581161904416,6.7352403697703178E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Charging from Renewable",null,null,{"$f":"SUM(G42:AD42)","v":57},null,{"$f":"G40-G41","v":0.83084421862943281},{"$f":"H40-H41","v":7.9289478973905467},4.0808108357758739,7.9735172357995268,17.04322372138644,17.862960420761823,1.2796956702563591,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Opening Balance",null,null,null,null,{"$f":"F48","v":0},{"$f":"G48","v":0.83084421862943281},8.7597921160199803,12.840602951795855,20.814120187595382,37.857343908981818,55.720304329743641,57,57,57,53.811645934636132,50.19923283317123,44.585232833171233,38.546232833171231,32.50723283317123,22.371232833171231,12.235232833171231,2.0992328331712322,0.67208997602837539,0,0,0,0,0]
[null,"Add: Charge",null,null,{"$f":"SUM(G45:AD45)","v":57},null,{"$f":"G42","v":0.83084421862943281},{"$f":"H42","v":7.9289478973905467},4.0808108357758739,7.9735172357995268,17.04322372138644,17.862960420761823,1.2796956702563591,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Sub-total Before Discharge",null,null,null,null,{"$f":"G44+G45","v":0.83084421862943281},{"$f":"H44+H45","v":8.7597921160199803},12.840602951795855,20.814120187595382,37.857343908981818,55.720304329743641,57,57,57,57,53.811645934636132,50.19923283317123,44.585232833171233,38.546232833171231,32.50723283317123,22.371232833171231,12.235232833171231,2.0992328331712322,0.67208997602837539,0,0,0,0,0]
[null,"Less: Discharge to Meet Load",null,null,{"$f":"SUM(G47:AD47)","v":56.999999999999986},null,{"$f":"MIN(G46,G33)","v":0},{"$f":"MIN(H46,H33)","v":0},0,0,0,0,0,0,0,3.1883540653638649,3.6124131014649055,5.6139999999999999,6.0389999999999997,6.0389999999999997,10.135999999999999,10.135999999999999,10.135999999999999,1.4271428571428568,0.67208997602837539,0,0,0,0,0]
[null,"Closing Balance",null,null,null,null,{"$f":"G46-G47","v":0.83084421862943281},{"$f":"H46-H47","v":8.7597921160199803},12.840602951795855,20.814120187595382,37.857343908981818,55.720304329743641,57,57,57,53.811645934636132,50.19923283317123,44.585232833171233,38.546232833171231,32.50723283317123,22.371232833171231,12.235232833171231,2.0992328331712322,0.67208997602837539,0,0,0,0,0,0]
[]
[null,"Total Demand Met from Battery and Renewable",null,null,{"$f":"SUM(G50:AD50)","v":119.37923283317123},null,{"$f":"G47+G32","v":0.72},1.41,11.18,11.18,4.0999999999999996,4.0999999999999996,8.6340000000000003,8.6340000000000003,6.8040000000000003,6.8040000000000003,5.6139999999999999,5.6139999999999999,6.0389999999999997,6.0389999999999997,10.135999999999999,10.135999999999999,10.135999999999999,1.4271428571428568,0.67208997602837539,0,0,0,0,0]
[null,"Surplus Renewable Not Needed for Battery",null,null,{"$f":"SUM(G51:AD51)","v":29.668244396942718},null,{"$f":"G34-G35-G45","v":0},{"$f":"H34-H35-H45","v":0},0,0,0,0,11.120146433606269,10.240472083434238,8.3076258799022131,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Demand Not Met from Battery Discharge",null,null,{"$f":"SUM(G52:AD52)","v":7.8907671668287662},null,{"$f":"G29-G32-G47","v":0},{"$f":"H29-H32-H47","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.75505288111448143,1.4271428571428568,1.4271428571428568,1.4271428571428568,1.4271428571428568,1.4271428571428568]
[]
[null,"Diesel Capacity",null,{"$f":"C7","v":0},null,null,{"$f":"$D$54","v":0},{"$f":"$D$54","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Diesel Capacity Dispatched",null,null,{"$f":"SUM(G55:AD55)","v":0},null,{"$f":"MIN(G54,G52)","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]
[]
[null,"Final Un-Met Demand",null,null,{"$f":"SUM(G57:AD57)","v":7.8907671668287662},null,{"$f":"G52-G55","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.75505288111448143,1.4271428571428568,1.4271428571428568,1.4271428571428568,1.4271428571428568,1.4271428571428568]
[]
[null,"Renewable Lost from Battery Round Trip",null,{"$f":"D42","v":0},{"$f":"SUM(G59:AD59)","v":57},null,{"$f":"G45*(1-$D$59)","v":0.83084421862943281},7.9289478973905467,4.0808108357758739,7.9735172357995268,17.04322372138644,17.862960420761823,1.2796956702563591,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Net Battery Production",null,null,{"$f":"SUM(G60:AD60)","v":0},null,{"$f":"G47-G45","v":-0.83084421862943281},-7.9289478973905467,-4.0808108357758739,-7.9735172357995268,-17.04322372138644,-17.862960420761823,-1.2796956702563591,0,0,3.1883540653638649,3.6124131014649055,5.6139999999999999,6.0389999999999997,6.0389999999999997,10.135999999999999,10.135999999999999,10.135999999999999,1.4271428571428568,0.67208997602837539,0,0,0,0,0]
[null,"Wasted Renewable Energy",null,null,{"$f":"SUM(G61:AD61)","v":34.229730944150248},null,{"$f":"G30-G50","v":0.87457286171519244},8.346260944621628,4.2955903534482882,8.3931760376837126,17.940235496196252,18.803116232380866,13.052465372486978,10.77944429835183,8.7448693472654888,-3.1883540653638649,-3.6124131014649055,-5.6139999999999999,-6.0389999999999997,-6.0389999999999997,-10.135999999999999,-10.135999999999999,-10.135999999999999,-1.4271428571428568,-0.67208997602837539,0,0,0,0,0]
[null,"Total Demand Met",null,null,{"$f":"SUM(G62:AD62)","v":64.890767166828738},null,{"$f":"G47+G52","v":0},0,0,0,0,0,0,0,0,3.1883540653638649,3.6124131014649055,5.6139999999999999,6.0389999999999997,6.0389999999999997,10.135999999999999,10.135999999999999,10.135999999999999,1.4271428571428568,1.4271428571428568,1.4271428571428568,1.4271428571428568,1.4271428571428568,1.4271428571428568,1.4271428571428568]
[]
["Graphs"]
[]
[null,null,null,null,null,null,{"$f":"G9","v":0},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23]
[null,"Demand",null,null,null,null,{"$f":"G11","v":1.4271428571428568},1.4271428571428568,1.4271428571428568,1.4271428571428568,0.72,1.41,11.18,11.18,4.0999999999999996,4.0999999999999996,8.6340000000000003,8.6340000000000003,6.8040000000000003,6.8040000000000003,5.6139999999999999,5.6139999999999999,6.0389999999999997,6.0389999999999997,10.135999999999999,10.135999999999999,10.135999999999999,1.4271428571428568,1.4271428571428568,1.4271428571428568]
[]
[null,null,null,null,null,null,{"$f":"MATCH(G70,26:26,0)","v":27},28,29,30,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26]
[null,null,null,null,null,null,{"$f":"G9","v":0},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23]
[null,"Demand",null,null,null,null,{"$f":"G11","v":1.4271428571428568},1.4271428571428568,1.4271428571428568,1.4271428571428568,0.72,1.41,11.18,11.18,4.0999999999999996,4.0999999999999996,8.6340000000000003,8.6340000000000003,6.8040000000000003,6.8040000000000003,5.6139999999999999,5.6139999999999999,6.0389999999999997,6.0389999999999997,10.135999999999999,10.135999999999999,10.135999999999999,1.4271428571428568,1.4271428571428568,1.4271428571428568]
[null,"Hydro Production",null,null,null,null,{"$f":"G15","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]
[null,"Solar Production",null,null,null,null,{"$f":"G14","v":0},0,0,0,1.5945728617151924,9.7562609446216282,15.475590353448288,19.573176037683712,22.040235496196253,22.903116232380864,21.686465372486978,19.41344429835183,15.548869347265489,3.6156459346361354,2.0015868985350944,0,0,0,0,0,0,0,0,0]
[null,"Diesel Production",null,null,null,null,{"$f":"INDEX(55:55,G69)","v":0},{"$f":"INDEX(55:55,H69)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Battery Discharge",null,null,null,null,{"$f":"INDEX(47:47,G$69)","v":0},{"$f":"INDEX(47:47,H$69)","v":0},0,0,0,0,0,0,0,0,0,0,0,3.1883540653638649,3.6124131014649055,5.6139999999999999,6.0389999999999997,6.0389999999999997,10.135999999999999,10.135999999999999,10.135999999999999,1.4271428571428568,0.67208997602837539,0]
[null,"Battery Charge",null,null,null,null,{"$f":"-INDEX(45:45,G$69)","v":0},{"$f":"-INDEX(45:45,H$69)","v":0},0,0,-0.83084421862943281,-7.9289478973905467,-4.0808108357758739,-7.9735172357995268,-17.04322372138644,-17.862960420761823,-1.2796956702563591,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Unserved Energy",null,null,null,null,{"$f":"INDEX(57:57,G69)","v":1.4271428571428568},{"$f":"INDEX(57:57,H69)","v":1.4271428571428568},1.4271428571428568,1.4271428571428568,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.75505288111448143,1.4271428571428568]
[]
[null,null,null,null,null,null,{"$f":"G26","v":4},5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,0,1,2,3]
[null,"Charge",null,null,null,null,{"$f":"G45","v":0.83084421862943281},7.9289478973905467,4.0808108357758739,7.9735172357995268,17.04322372138644,17.862960420761823,1.2796956702563591,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Discharge",null,null,null,null,{"$f":"G47","v":0},0,0,0,0,0,0,0,0,3.1883540653638649,3.6124131014649055,5.6139999999999999,6.0389999999999997,6.0389999999999997,10.135999999999999,10.135999999999999,10.135999999999999,1.4271428571428568,0.67208997602837539,0,0,0,0,0]
[]
[null,null,null,null,null,null,{"$f":"G79","v":4},{"$f":"H79","v":5},6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,0,1,2,3]
[null,"Load",null,null,null,null,{"$f":"G11","v":1.4271428571428568},1.4271428571428568,1.4271428571428568,1.4271428571428568,0.72,1.41,11.18,11.18,4.0999999999999996,4.0999999999999996,8.6340000000000003,8.6340000000000003,6.8040000000000003,6.8040000000000003,5.6139999999999999,5.6139999999999999,6.0389999999999997,6.0389999999999997,10.135999999999999,10.135999999999999,10.135999999999999,1.4271428571428568,1.4271428571428568,1.4271428571428568]
[null,"Production",null,null,null,null,{"$f":"G14","v":0},0,0,0,1.5945728617151924,9.7562609446216282,15.475590353448288,19.573176037683712,22.040235496196253,22.903116232380864,21.686465372486978,19.41344429835183,15.548869347265489,3.6156459346361354,2.0015868985350944,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,{"$f":"G83","v":4},{"$f":"H83","v":5},6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,0,1,2,3]
[null,"Battery Balance",null,null,null,null,{"$f":"INDEX(48:48,MATCH(G87,9:9,0))","v":37.857343908981818},55.720304329743641,57,57,57,53.811645934636132,50.19923283317123,44.585232833171233,38.546232833171231,32.50723283317123,22.371232833171231,12.235232833171231,2.0992328331712322,0.67208997602837539,0,0,0,0,0,0,0.83084421862943281,8.7597921160199803,12.840602951795855,20.814120187595382]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Solar Capacity - Watt",{"$f":"Cap","v":29},"Demand - Wh",{"$f":"E11","v":127.27},null,null,"\nBattery Wh",{"$f":"E18","v":64.890767166828752}]

{"sheet":"Distribution","index":11,"n_rows":43,"n_cols":23,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Distribution Quantity"]
[null,"Three Phase Wires",null,null,"meters"]
[null,"Cost per meter",null,null,"USD/Meter"]
[]
[null,null,null,"  3phase Distribution branch point  to point ( refer to                       "]
[null,null,null,"  distribution map) 3x50 +54.6mm2 twisted cable                           "]
[null,null,null,"   m                               ",713.94]
[null,null,null,"  3phase distribution branch point to point 18( refer to                        "]
[null,null,null,"  distribution map) 3x50 +54.6mm2 twisted cable                           "]
[null,null,null,"   m                               ",443.31]
[null,null,null,"  total length of other branches feeding different corners                         "]
[null,null,null,"  of the villages will be 3x35 +54.6mm2 twisted cable                        "]
[null,null,null,"   m                               ",1674.07]
[null,null,null,"  service connection or customer connection by taking                          "]
[null,null,null,"  average of 10m cable to each customer                          "]
[null,null,null,"   m                               ",1620]
[]
[null,null,null,"Total Length",{"$f":"SUM(E5:E16)","v":4451.32}]
[]
[null,null,null,"Distribution line USD",47341]
[null,null,null,"Office equipment USD",0]
[null,null,null,"Other non construction costs USD",6295]
[null,null,null,"Total Distribution Cost",{"$f":"SUM(E20:E22)","v":53636}]
[]
[]
[null,null,null,"Cost per Meter (USD/Meter)",{"$f":"E23/E18","v":12.049459486174888}]
[]
[]
[]
[null,"Investment Cost, Distribution"]
[null,"Low Voltage Distribution Line, Distance ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"km",null,2]
[null,"Low Voltage Distribution Line, Cost ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USD/km",null,7000]
[null,null,"Transformer "]
[null,null,null,"Number of transformers",null,null,null,null,null,null,null,null,null,null,null,null,"unit",null,0,null,null,"Guidance [Ungroup to reveal]","Transformers would not be required for small mini-grids. They would only be needed for sizes upwards of 100 kW"]
[null,null,null,"Cost of transformer ",null,null,null,null,null,null,null,null,null,null,null,null,"USD/unit",null,0]
[]
[null,null,"End-User Equipment ",null,null,null,null,null,null,null,null,null,null,null,null,null,"USD/end-user",null,170,null,null,"Guidance [Ungroup to reveal]","Model assumes appliances are purchased/financed by the end-user and are not part of the modelling exercise. "]
[null,null,null,"Labor Cost",null,null,null,null,null,null,null,null,null,null,null,null,"USD/end-user",null,20]
[null,null,null,"Wires",null,null,null,null,null,null,null,null,null,null,null,null,"USD/end-user",null,120]
[null,null,null,"Meter",null,null,null,null,null,null,null,null,null,null,null,null,"USD/end-user",null,30]
[null,null,"Distribution network lifetime",null,null,null,null,null,null,null,null,null,null,null,null,null,"years",null,20]
[]
[null,"Depreciable Base of Distribution & Generation Assets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%",null,1]

{"sheet":"Financing Assumptions","index":12,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["          "]
[]
["Finance"]
[null,"Target IRR",null,null,"%",{"$f":"G4/1000","v":0.13},130,70]
[null,"Solar Life",null,null,"Years",10]
[null,"Battery Life",null,null,"Years",10]
[]
[]
["Hydro LCOE"]
[null,"Cost per kW",null,null,"USD/kW",null,{"$f":"Hydro!F24","v":3853}]
[null,"Cost of Capital",null,null,"%"]
[null,"Inflation Rate",null,null,"%"]
[null,"Real Carrying Charge",null,null,"%"]
[null,"Carrying Charge Rate",null,null,"%"]
[]
[null,"Annual Capital Cost",null,null,"USD/kWy"]
[]
[null,"O&M Cost Percent",null,null,"%"]
[null,"O&M Cost/kWy",null,null,"USD/kWy"]
[]
[null,"Total Costs",null,null,"USD/kWy"]
[null,"Total Costs ",null,null,"USD/MWH"]
[]
[]
[null,"Debt Funding Percent",null,null,"%"]
[null,"Tenure (Months)",null,null,"Month"]
[null,"Funding Interest Rate",null,null,"%"]
[null,"Credit Spread and Fees",null,null,"%"]

{"sheet":"Financial Model","index":13,"n_rows":152,"n_cols":47,"rows_kept":152,"cut":false,"hidden":false,"merged":[]}
["Timeline",null,null,null,null,null,"Price Result",{"$f":"F108","v":0.15422924414088282}]
[]
[null,"Period",null,null,null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40]
[null,"Life Flag",null,null,null,30,null,{"$f":"H3<=$F$4","v":true},{"$f":"I3<=$F$4","v":true},true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,false,false,false,false,false,false,false,false,false,false]
[null,"Battery Replacement",null,null,null,{"$f":"F10+1","v":31},null,{"$f":"MOD(H3,$F$5)=0","v":false},{"$f":"MOD(I3,$F$5)=0","v":false},false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,true,false,false,false,false,false,false,false,false,false]
[]
["Assumptions"]
[null,null,"Timing"]
[null,null,null,"Lifetime of Solar","Years",{"$f":"'Financing Assumptions'!F5","v":10}]
[null,null,null,"Battery Replacement","Years",30]
[]
[null,null,"Macro-Economic"]
[null,null,null,"Exchange Rate","FRW/USD",950]
[null,null,null,"USD Inflation Rate","% p.a.",0.02]
[]
[null,null,"Load and Solar"]
[null,null,null,"Load Required","kWh",{"$f":"'Demand and Supply Dispatch'!E11","v":127.27}]
[null,null,null,"Maximum Load","kW",{"$f":"'Demand and Supply Dispatch'!D11","v":11.18}]
[null,null,null,"Load Factor","%",{"$f":"F17/24/F18","v":0.4743217054263566}]
[null,null,null,"Demand Met","kWh",{"$f":"'Demand and Supply Dispatch'!E62","v":64.890767166828738}]
[null,null,null,"Unserved Energy","kWh",{"$f":"'Demand and Supply Dispatch'!E57","v":7.8907671668287662}]
[]
[null,null,null,"Solar Capacity","kW",{"$f":"'Solar and Battery'!E14","v":29}]
[null,null,null,"Hydro Capacity","kW",{"$f":"Hydro!F7","v":0}]
[null,null,null,"Diesel Capacity","kW",{"$f":"Diesel!F7","v":0}]
[null,null,null,"Battery Capacity","kWh",{"$f":"'Solar and Battery'!E17","v":57}]
[null,null,null,"Total Generating Capacity","kWh",{"$f":"SUM(F23:F26)","v":86}]
[]
[null,null,"Production per Day"]
[null,null,null,"Solar Production","kWh",{"$f":"'Demand and Supply Dispatch'!E14","v":153.60896377732146}]
[null,null,null,"Hydro Production","kWh",{"$f":"'Demand and Supply Dispatch'!E15","v":0}]
[null,null,null,"Diesel Production","kWh",{"$f":"'Demand and Supply Dispatch'!E55","v":0}]
[null,null,null,"Net Battery Production","kWh",{"$f":"'Demand and Supply Dispatch'!E60","v":0}]
[null,null,null,"Total Energy Produced","kWh",{"$f":"SUM(F30:F33)","v":153.60896377732146}]
[]
[null,null,null,"Capacity Factor",null,{"$f":"IFERROR(F30/24/F23,0)","v":0.22070253416281818}]
[null,null,null,"Battery Round Trip Efficiency","%",{"$f":"Round_Trip","v":0.95}]
[null,null,null,"Solar Capacity with Battery Adjustment","kW",{"$f":"F23/F37","v":30.526315789473685}]
[]
[null,null,"Battery Capacity"]
[null,null,null,"Battery Discharge Capacity","kWh",{"$f":"'Solar and Battery'!$E$17","v":57}]
[null,null,null,"Depth of Discharge Limit","%",{"$f":"Depth_Discharge","v":0.05}]
[null,null,null,"Capacity Required Adjusted for Depth of Discharge","kWh",{"$f":"F41*(1+F42)","v":59.85}]
[]
[null,null,"Capital Cost"]
[null,null,null,"Cost of Hydro","USD/kW",{"$f":"Hydro!F24","v":3853}]
[null,null,null,"Cost of Solar","USD/kW",{"$f":"Solar_Cost","v":890}]
[null,null,null,"Cost of Diesel","USD/kW",{"$f":"Diesel!F19","v":650}]
[null,null,null,"Battery Current","USD/kWh",{"$f":"Battery_Cost","v":130}]
[null,null,null,"Battery - Replacement 1","USD/kWh",{"$f":"F49","v":130}]
[null,null,null,"Battery - Replacement 2","USD/kWh",{"$f":"F50","v":130}]
[]
[null,null,"Total Cost",null,null,"USD","RFW"]
[null,null,null,"Total Cost of Hydro","USD/FRW",{"$f":"F46*F24","v":0},{"$f":"F54*$F$13","v":0}]
[null,null,null,"Total Cost of Solar","USD/FRW",{"$f":"F47*F38","v":27168.42105263158},{"$f":"F55*$F$13","v":25810000}]
[null,null,null,"Total Battery Cost","USD/FRW",{"$f":"F49*F41","v":7410},{"$f":"F56*$F$13","v":7039500}]
[null,null,null,"Total Diesel Cost","USD/FRW",{"$f":"F48*F25","v":0},{"$f":"F57*$F$13","v":0}]
[null,null,null,"Total Cost  ","USD/FRW",{"$f":"SUM(F54:F57)","v":34578.42105263158},{"$f":"F58*$F$13","v":32849500}]
[null,null,null,"Total Cost/kW","USD/FRW",{"$f":"IFERROR(F58/F38,0)","v":1132.7413793103449},{"$f":"IFERROR(G58/F23*1000,0)","v":1132741379.3103447}]
[null,null,null,"kWh","kWh",{"$f":"F41","v":57},{"$f":"F60","v":57}]
[null,null,null,"Total Cost/kWh","USD/FRW",{"$f":"IFERROR(F58/F60,0)","v":606.63896583564178},{"$f":"IFERROR(G58/G60*1000,0)","v":576307017.54385972}]
[]
[null,null,"O&M Cost"]
[null,null,null,"O&M on Solar","USD/kWy",10]
[null,null,null,"O&M on Battery","USD/kWhy",0.2]
[]
[null,null,"Distribution"]
[null,null,null,"Total Length of Distribution","metre",{"$f":"Distribution!E16","v":1620}]
[null,null,null,"Average Cost per Meter","USD/m",{"$f":"Distribution!E26","v":12.049459486174888}]
[null,null,null,"Total Distribution Cost","USD",{"$f":"F68*F69","v":19520.124367603319}]
[]
[null,null,"Pricing"]
[null,null,null,"Required IRR","%",{"$f":"'Financing Assumptions'!$F$4","v":0.13}]
[null,null,null,"Price Derived","USD/kWh",0.15422924414088282,"Price","USD/MWH"]
[null,null,null,"Price Derived","FRW/kWh",{"$f":"F74*F13","v":146.51778193383868}]
[null,null,null,"NPV","USD",{"$f":"F136","v":-3459.946720101203},"NPV"]
[null,null,null,null," "]
[null,null,"Kerosene"]
[null,null,null,"Conversion","L/kWh",{"$f":"Kerosene!F9","v":9.583395389332626E-2}]
[null,null,null,"Cost/Litre","USD/Litre",{"$f":"Kerosene!F17","v":1.1157894736842104}]
[null,null,null,"Indoor Pollution Cost","USD/Litre"]
[null,null,null,"Quality Cost","USD/Litre"]
[]
["Financial Model"]
[null,"Hydro Life",null,null,{"$f":"F24>0","v":false},{"$f":"Hydro!F28","v":30},null,{"$f":"(H$3<=$F85)*$E85","v":0},{"$f":"(I$3<=$F85)*$E85","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]
[null,"Solar Life",null,null,{"$f":"F23>0","v":true},{"$f":"'Consumer Economics'!K19","v":10},null,{"$f":"(H$3<=$F86)*$E86","v":1},1,1,1,1,1,1,1,1,1,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]
[null,"Battery Life",null,null,{"$f":"F26>0","v":true},{"$f":"'Consumer Economics'!K18","v":10},null,1,1,1,1,1,1,1,1,1,1,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]
[null,"Diesel Life",null,null,{"$f":"F25>0","v":false},{"$f":"Diesel!F24","v":20},null,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]
[null,"Demand Life",null,null,null,null,null,{"$f":"OR(H85:H88)","v":true},{"$f":"OR(I85:I88)","v":true},true,true,true,true,true,true,true,true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[]
[null,"Capacity and Production"]
[null,null,null,"Total Load Met","kWh/year",{"$f":"F20","v":64.890767166828738},null,{"$f":"$F$92*365*H4","v":23685.13001589249},23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Hydro Energy","kWh/Year",{"$f":"F31","v":0},null,{"$f":"$F$93*365*H85","v":0},{"$f":"$F$93*365*I85","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]
[null,null,null,"Solar Energy","kWh/Year",{"$f":"F30","v":153.60896377732146},null,{"$f":"$F$94*H4","v":153.60896377732146},153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,153.60896377732146,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Diesel Energy","kWh/Year",{"$f":"F25","v":0}]
[null,null,null,"Battery Capacity without Degradation","kWh/year",{"$f":"F41","v":57},null,{"$f":"$F$96*H4","v":57},57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Battery Production without Degradation","kWh/year",{"$f":"F41","v":57},null,{"$f":"$F$97*365","v":20805},{"$f":"$F$97*365","v":20805},20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805,20805]
[]
[null,"Captial Expenditure"]
[null,null,null,"Hydro Capital Expenditure","USD",{"$f":"F54","v":0},{"$f":"F100","v":0}]
[null,null,null,"Solar Capital Expenditure","USD",{"$f":"F55","v":27168.42105263158},{"$f":"F101","v":27168.42105263158}]
[null,null,null,"Battery Capital Expenditure","USD",{"$f":"F56","v":7410},{"$f":"F102","v":7410}]
[null,null,null,"Diesel Capital Expenditure","USD",{"$f":"F57","v":0},{"$f":"F103","v":0}]
[null,null,null,"Distribution Capital Expenditure","USD",{"$f":"F70*H104","v":0},{"$f":"F104","v":0},{"$f":"'Minigrid Control'!$F$85","v":false}]
[null,null,null,"Total","USD",{"$f":"SUM(F100:F104)","v":34578.42105263158},{"$f":"SUM(G100:G104)","v":34578.42105263158}]
[]
[null,"Revenues and O&M Expenses"]
[null,null,null,"Price/kWh","USD/kWh",{"$f":"F74","v":0.15422924414088282},null,{"$f":"$F$108","v":0.15422924414088282},{"$f":"$F$108","v":0.15422924414088282},0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282,0.15422924414088282]
[null,null,null,"Inflation Index","Index",{"$f":"F14","v":0.02},1,{"$f":"G109*(1+$F$109)","v":1.02},{"$f":"H109*(1+$F$109)","v":1.0404},1.0612079999999999,1.08243216,1.1040808032,1.1261624192640001,1.14868566764928,1.1716593810022657,1.1950925686223111,1.2189944199947573,1.2433743083946525,1.2682417945625455,1.2936066304537963,1.3194787630628724,1.3458683383241299,1.3727857050906125,1.4002414191924248,1.4282462475762734,1.4568111725277988,1.4859473959783549,1.5156663438979221,1.5459796707758806,1.5768992641913981,1.6084372494752261,1.6406059944647307,1.6734181143540252,1.7068864766411058,1.7410242061739281,1.7758446902974065,1.8113615841033548,1.8475888157854219,1.8845405921011305,1.9222314039431532,1.9606760320220162,1.9998895526624565,2.0398873437157055,2.0806850905900198,2.1222987924018204,2.1647447682498568,2.208039663614854]
[null,null,null,"Price/kWh Inflated","USD/kWh",null,null,{"$f":"H108*H109","v":0.15731382902370047},{"$f":"I108*I109","v":0.16046010560417448},0.16366930771625796,0.16694269387058314,0.17028154774799481,0.17368717870295469,0.1771609222770138,0.18070414072255409,0.18431822353700517,0.18800458800774528,0.19176467976790018,0.19559997336325818,0.19951197283052333,0.20350221228713383,0.2075722565328765,0.21172370166353405,0.21595817569680473,0.22027733921074083,0.22468288599495564,0.22917654371485477,0.23376007458915188,0.23843527608093493,0.24320398160255363,0.2480680612346047,0.25302942245929677,0.25809001090848271,0.26325181112665241,0.26851684734918546,0.27388718429616915,0.27936492798209256,{"$f":"AL108*AL109","v":0.28495222654173441},0.29065127107256911,0.29646429649402051,0.30239358242390091,0.30844145407237894,0.3146102831538265,0.32090248881690303,0.32732053859324112,0.33386694936510597,0.34054428835240808]
[]
[null,null,null,"Annual Demand Met","kWh",null,null,{"$f":"H92","v":23685.13001589249},{"$f":"I92","v":23685.13001589249},23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,23685.13001589249,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Revenues","USD",null,null,{"$f":"H110*H112","v":3725.998493724227},{"$f":"I110*I112","v":3800.5184635987116},3876.5288328706856,3954.0594095280999,4033.1405977186619,4113.8034096730353,4196.0794778664958,4280.0010674238265,4365.6010887723023,4452.9131105477491,4541.9713727587041,4632.8108002138779,4725.4670162181546,4819.9763565425192,4916.3758836733696,5014.7034013468365,5114.997469373774,5217.297418761249,5321.6433671364739,5428.0762344792038,5536.6377591687888,5647.3705143521647,5760.3179246392083,5875.524283131992,5993.0347687946314,6112.8954641705241,6235.1533734539353,6359.8564409230139,6487.0535697414743,6616.7946411363046,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Diesel Production","kWh",null,null,{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0},{"$f":"'Demand and Supply Dispatch'!$G$55","v":0}]
[null,null,null,"Diesel Cost","USD",{"$f":"Diesel!$F$15","v":240.45000000000002},null,{"$f":"$F$117*H116","v":0},{"$f":"$F$117*I116","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]
[]
[null,null,null,"Solar Capacity","kW",{"$f":"F23","v":29},null,{"$f":"$F119*H86","v":29},{"$f":"$F119*I86","v":29},29,29,29,29,29,29,29,29,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]
[null,null,null,"Battery Capacity","kW",{"$f":"F41","v":57},null,{"$f":"$F120*H87","v":57},{"$f":"$F120*I87","v":57},57,57,57,57,57,57,57,57,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]
[null,null,null,"Hydro Capacity","kW",{"$f":"F24","v":0},null,{"$f":"$F121*H85","v":0},{"$f":"$F121*I85","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]
[null,null,null,"Diesel Capacity","kW",{"$f":"F25","v":0},null,{"$f":"$F122*H88","v":0},{"$f":"$F122*I88","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]
[]
[]
[null,null,null,"O&M Cost - Solar","USD",{"$f":"F64","v":10},null,{"$f":"$F125*H119","v":290},{"$f":"$F125*I119","v":290},290,290,290,290,290,290,290,290,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]
[null,null,null,"O&M Cost - Battery","USD",{"$f":"F65","v":0.2},null,{"$f":"$F126*H120","v":11.4},11.4,11.4,11.4,11.4,11.4,11.4,11.4,11.4,11.4,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]
[null,null,null,"O&M Cost - Hydro","USD",{"$f":"Hydro!F26","v":10},null,{"$f":"$F127*H121","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]
[null,null,null,"O&M Cost - Diesel","USD",{"$f":"Diesel!F21","v":15},null,{"$f":"$F128*H122","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]
[]
[null,null,null,"EBITDA","USD",null,null,{"$f":"H114-H125-H126-H117-H127-H128","v":3424.598493724227},{"$f":"I114-I125-I126-I117-I127-I128","v":3499.1184635987115},3575.1288328706855,3652.6594095280998,3731.7405977186618,3812.4034096730352,3894.6794778664957,3978.6010674238264,4064.2010887723022,4151.5131105477494,4541.9713727587041,4632.8108002138779,4725.4670162181546,4819.9763565425192,4916.3758836733696,5014.7034013468365,5114.997469373774,5217.297418761249,5321.6433671364739,5428.0762344792038,5536.6377591687888,5647.3705143521647,5760.3179246392083,5875.524283131992,5993.0347687946314,6112.8954641705241,6235.1533734539353,6359.8564409230139,6487.0535697414743,6616.7946411363046,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Capital Expenditure",null,null,{"$f":"F105","v":34578.42105263158}]
[]
[null,null,null,"Cash Flow",null,null,{"$f":"G130-G132","v":-34578.42105263158},3424.598493724227,3499.1184635987115,3575.1288328706855,3652.6594095280998,3731.7405977186618,3812.4034096730352,3894.6794778664957,3978.6010674238264,4064.2010887723022,4151.5131105477494,4541.9713727587041,4632.8108002138779,4725.4670162181546,4819.9763565425192,4916.3758836733696,5014.7034013468365,5114.997469373774,5217.297418761249,5321.6433671364739,5428.0762344792038,5536.6377591687888,5647.3705143521647,5760.3179246392083,5875.524283131992,5993.0347687946314,6112.8954641705241,6235.1533734539353,6359.8564409230139,6487.0535697414743,6616.7946411363046,{"$f":"AL130-AL132","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"IRR",{"$f":"IRR(134:134)","v":0.1156351769548325}]
[null,null,null,"NPV",{"$f":"F73","v":0.13},{"$f":"NPV(E136,134:134)","v":-3459.946720101203}]
[null,null,null,"CCR","%",{"$f":"H130","v":3424.598493724227},{"$f":"G132","v":34578.42105263158},{"$f":"F137/G137","v":9.9038602384755189E-2},{"$f":"PMT(E136,F4,-1)","v":0.13341065033140481}]
[]
[]
["Comparison with Kerosene Cost"]
[null,"Liters per kWh",null,null,"L/kWh",{"$f":"F79","v":9.583395389332626E-2},null,{"$f":"$F$141","v":9.583395389332626E-2},{"$f":"$F$141","v":9.583395389332626E-2},9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2,9.583395389332626E-2]
[null,"Total Liters",null,null,"Litre",null,null,{"$f":"H141*H92","v":2269.8396579004789},2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,2269.8396579004789,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Cost per Liter",null,null,"USD/Litre",{"$f":"F80","v":1.1157894736842104},null,{"$f":"$F$144*H109","v":1.1381052631578947},1.1608673684210524,1.1840847157894736,1.207766410105263,1.2319217383073684,1.2565601730735159,1.281691376534986,1.307325204065686,1.3334717081469996,1.3601411423099397,1.3873439651561383,1.4150908444592611,1.4433926613484462,1.4722605145754153,1.5017057248669237,1.5317398393642623,1.5623746361515476,1.5936221288745787,1.6254945714520701,1.6580044628811117,1.691164552138734,1.7249878431815087,1.7594876000451389,1.7946773520460417,1.8305708990869625,1.8671823170687016,1.9045259634100757,1.9426164826782775,1.9814688123318429,2.0210981885784798,2.0615201523500497,2.1027505553970505,2.1448055665049917,2.1877016778350917,2.2314557113917934,2.2760848256196291,2.3216065221320221,2.3680386525746626,2.4153994256261559,2.4637074141386792]
[null,"Total",null,null,"USD  ",null,null,{"$f":"H144*H142","v":2583.3164611810503},{"$f":"I144*I142","v":2634.9827904046706},2687.6824462127647,2741.4360951370195,2796.2648170397601,2852.1901133805559,2909.2339156481667,2967.4185939611302,3026.7669658403529,3087.3023051571599,3149.0483512603028,3212.0293182855089,3276.2699046512189,3341.7953027442436,3408.6312087991287,3476.8038329751116,3546.3399096346138,3617.2667078273066,3689.6120419838521,3763.4042828235297,3838.6723684800004,3915.4458158496004,3993.7547321665929,4073.6298268099245,4155.102423346123,4238.2044718130455,4322.9685612493058,4409.4279324742929,4497.6164911237784,4587.5688209462542,{"$f":"AL144*AL142","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
[]
[null,null,null,null,null,null,"Cost of Mini Grid",{"$f":"H114","v":3725.998493724227}]
[null,null,null,null,null,null,"Cost of Kerosene",{"$f":"H145","v":2583.3164611810503}]
[]
[null,null,null,null,null,null,"Cost Savings Percent -- ",{"$f":"H149/H150","v":1.4423314176617608}]

{"sheet":"Kerosene","index":14,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["          "]
["Conversions"]
[null,"Gallons per kWh",null,null,"G/kWh",2.5316455599999999E-2]
[null,"kWh/Gallon",null,null,"kWh/G",{"$f":"1/F3","v":39.5000001501}]
[]
[null,"US Gallon/Litre",null,null,"G/L",0.26417000000000002]
[null,"Litre/Galon",null,null,"L/G",{"$f":"1/F6","v":3.7854411931710636}]
[]
[null,"Litres/kWh",null,"G/kWh x L/G",null,{"$f":"F3*F7","v":9.583395389332626E-2}]
[null,"kWh/Litre",null,"kWh/G x G/L",null,{"$f":"F4*F6","v":10.434715039651918}]
[]
[null,"The average retail price per liter kerosene for a remote household costs FRW 1,070."]
[]
["Cost of Kerosene"]
[null,"Cost/Litre",null,"FRW/L",null,1060,"cost litre",null,1070,"base cost litre"]
[null,"Conversion",null,"FRW/USD",null,{"$f":"'Financial Model'!F13","v":950}]
[null,"Cost/Litre",null,"USD/L",null,{"$f":"F15/F16","v":1.1157894736842104}]
[null,"Cost/kWh",null,"USD/L x L/KWH",null,{"$f":"F17*F9","v":0.1069305169757114}]
[]
[]
[null,"Region",null,null,null,"Cent/G","USD/G","G/L","USD/L"]
[null,"New York Statewide",null,null,null,363,{"$f":"F22/100","v":3.63},{"$f":"F6","v":0.26417000000000002},{"$f":"G22*H22","v":0.95893709999999999}]
[null,"Middle Hudson Region",null,null,null,375.9,3.7589999999999999,{"$f":"H22","v":0.26417000000000002},0.99301503000000002]
[null,"Capital District Region",null,null,null,335.2,3.3519999999999999,{"$f":"H23","v":0.26417000000000002},0.88549783999999998]
[null,"North Country Region",null,null,null,371.6,3.7160000000000002,{"$f":"H24","v":0.26417000000000002},0.98165572000000012]
[null,"Central Region",null,null,null,344.5,3.4449999999999998,{"$f":"H25","v":0.26417000000000002},0.91006565000000006]
[null,"Western Region",null,null,null,383.5,3.835,{"$f":"H26","v":0.26417000000000002},1.01309195]

{"sheet":"Sample Prices","index":15,"n_rows":10,"n_cols":34,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["          "]
[null,"Total Wh",null,{"$f":"30*10","v":300},null,null,null,"Total kW",null,null,7,{"$f":"K2","v":7},null,null,null,"Total kW",null,5,5,null,null,"Total kW",3,3,null,null,null,null,null,null,"Total kW",null,2,5]
[null,"Cost",null,399,null,null,null,"Cost",null,null,4800,7500,null,null,null,"Cost",null,4000,4500,null,null,"Cost",{"$f":"W6*W2","v":900},{"$f":"X6*X2","v":2370},null,null,null,null,null,null,"Cost",null,2500,4500]
[null,"Cost/Wh",null,{"$f":"D3/D2","v":1.33},null,null,null,"Hrs",null,null,5,{"$f":"K4","v":5},null,null,null,"Hrs",null,5,5,null,null,"Hrs",1,1,null,null,null,null,null,null,"Hrs",null,5,5]
[null,"Cost/kWh",null,{"$f":"D4*1000","v":1330},null,null,null,"kWh",null,null,{"$f":"K2*K4","v":35},{"$f":"L2*L4","v":35},null,null,null,"kWh",null,{"$f":"R2*R4","v":25},{"$f":"S2*S4","v":25},null,null,"kWh",{"$f":"W2*W4","v":3},{"$f":"X2*X4","v":3},null,null,null,null,null,null,"kWh",null,{"$f":"AG4*AG2","v":10},{"$f":"AH4*AH2","v":25}]
[null,null,null,null,null,null,null,"Cost/kW",null,null,{"$f":"K3/K2","v":685.71428571428567},{"$f":"L3/L2","v":1071.4285714285713},null,null,null,"Cost/kW",null,{"$f":"R3/R2","v":800},{"$f":"S3/S2","v":900},null,null,"Cost/kW",300,790,null,null,null,null,null,null,"Cost/kW",null,{"$f":"AG3/AG2","v":1250},{"$f":"AH3/AH2","v":900}]
[null,"Watt",null,30,null,null,null,"Cost/kWh",null,null,{"$f":"K3/K5","v":137.14285714285714},{"$f":"L3/L5","v":214.28571428571428},null,null,null,"Cost/kWh",null,{"$f":"R3/R5","v":160},{"$f":"S3/S5","v":180},null,null,"Cost/kWh",{"$f":"W6/W5","v":100},{"$f":"X6/X5","v":263.33333333333331},null,null,null,null,null,null,"Cost/kWh",null,{"$f":"AG3/AG5","v":250},{"$f":"AH3/AH5","v":180}]
[null,"Cost",null,{"$f":"D3","v":399}]
[null,"Cost/Watt",null,{"$f":"D8/D7","v":13.3}]
[null,"Cost/kW",null,{"$f":"D9*1000","v":13300}]

{"sheet":"Backup","index":16,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["          "]