{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Data input and assessment","1 Demand households","2 Demand MSMEs, others","3 Losses","4 Other supporting data"],"not_rendered":{"charts":4,"images":19,"macros":0,"external_links":0,"defined_names":0,"comments":5,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data input and assessment","index":0,"n_rows":366,"n_cols":15,"rows_kept":366,"cut":false,"hidden":false,"merged":[[66,3,66,5],[224,7,224,8],[76,2,76,4],[77,2,77,4]]}
["DUE DILIGENCE FINANCIAL ASSESSMENT OF PV MINI-GRIDS"]
[]
["DATA ENTRY"]
["Data input fields (data from developer)",null,"     For detailed calculation see worksheets (tabs below): 1 Demand households, 2 Demand MSMEs, others, "]
["Data input either directly, or from sheets 1, 2, 3, 4",null,"     3 Losses, 4 Other supporting data. The respective data is transferred to this sheet."]
[null,"CTRL + Z  or","    Changing input: return to previous data first"]
["All other data are generated by formulae"]
["Key parameters",2356]
["Data supported by benchmark, acceptable",12]
["Data suspiciously low (quality issue?) or high",34]
["Data very low or very high, need clarification",56,"    Red cells might also hint to mistyping."]
["Additional info, comments for consideration","italics"]
["More comments are visible when the cursor is on cells with a red triangle in the top right corner. See here…."]
[]
["Section","Contents, short description"]
["Demand","Electricity demand in location"]
["Configuration","Size of PV array and battery capacity"]
["Investment"]
[" - Site development","Costs in Naira, $, cost assessment, benchmarks"]
[" - Generation","Panels (array) and inverters, costs in Naira, $, cost assessment, benchmarks"]
[" - Storage","Batteries, related electronic equipment, costs in Naira, $, cost assessment, benchmarks"]
[" - Distribution","Poles,  lines, and connections, costs in Naira, $, cost assessment, benchmarks"]
[" - Others","Project development costs in Naira, $, cost assessment"]
["Investment summary","Overall investment assessment"]
["Capital cost","Depreciation and cost of funds (expected Return on Investment, RoI) simulation"]
["Income projection","Cash flow before debt service based on electricity tariff and operational cost simulation, income and cost per kWh"]
["Financing","Sources and cost of finance simulation"]
["Cash flow years 1 - 15","Start-up simulation, battery replacement simulation, inflation rate simulation "]
["Government subsidies and grants","Investment cost financing of PV mini-grids based on Electricity Vision 30:30:30"]
["Benchmark baselines","Data on benchmark adjustments for mini-grids < 100 kW"]
[]
["DEMAND"]
["Demand = consumption"]
["Details transferred from sheet tabs 1 Demand households, 2 Demand MSMEs, others"]
["Alternatively, data may be entered here directly."]
[null,null,null,"Group","Average"]
[null,null,null,"demand","per customer","Benchmark ","Demand"]
["Customer groups","Potential","Committed","kWh/day","kWh/day","kWh/day","acc. to group"]
["Households",{"$f":"'1 Demand households'!C12","v":500},{"$f":"'1 Demand households'!H62","v":647},{"$f":"'1 Demand households'!I62","v":168.81},{"$f":"D39/C39","v":0.26091190108191653},"0.5 - 0.7",{"$f":"D39/D$43","v":0.60179672738939793}]
["Commercial enterprises (MSMEs)",{"$f":"'1 Demand households'!C14","v":25},{"$f":"'2 Demand MSMEs, others'!A48","v":11},{"$f":"'2 Demand MSMEs, others'!F49","v":29.5},{"$f":"D40/C40","v":2.6818181818181817},"1 - 3",{"$f":"D40/D$43","v":0.10516559124451892}]
["Productive enterprises (MSMEs)",{"$f":"'1 Demand households'!C15","v":20},{"$f":"'2 Demand MSMEs, others'!A68","v":11},{"$f":"'2 Demand MSMEs, others'!F69","v":79.5},{"$f":"D41/C41","v":7.2272727272727275},"5 - 15",0.28341235606573739,{"$f":"IF(AND(G41>0.5,(C41/C43)<0.07),\"High dependance on few MSMEs\",IF(G41>0.5,\"High dependance on MSMEs\",\"\"))","v":""}]
["Public users",{"$f":"'1 Demand households'!C16","v":6},{"$f":"'2 Demand MSMEs, others'!A88","v":6},{"$f":"'2 Demand MSMEs, others'!F89","v":2.7},{"$f":"D42/C42","v":0.45},"1 - 5",9.6253253003457991E-3]
["Total Demand, kWh/day",{"$f":"SUM(B39:B42)","v":551},{"$f":"SUM(C39:C42)","v":675},{"$f":"SUM(D39:D42)","v":280.51},{"$f":"D43/C43","v":0.41557037037037037},"> 0.5",1]
[null,null,{"$f":"IF(OR(C39>B39,C40>B40,C41>B41,C42>B42),\"Number of committed customers must be smaller than potential.\",\"\")","v":"Number of committed customers must be smaller than potential."}]
["Additional info",{"$nulls":4},"Benchmark"]
["Demand of the largest productive MSMEs (of total %, in kWh/day)",null,{"$f":"D46/D43","v":0.27450001782467648},{"$f":"SUM('2 Demand MSMEs, others'!F58:F66)/30","v":77},null,"< 30%"]
["Estimated growth potential","Households:",{"$f":"(B39-C39)/C39","v":-0.22720247295208656},null,null,"> 35%"]
[null,"MSMEs, others:",{"$f":"(SUM(B40:B42)-SUM(C40:C42))/SUM(C40:C42)","v":0.8214285714285714},null,null,"> 35%"]
[]
["CONFIGURATION"]
[]
[]
["Irradiation (\"light\", \"sunshine\"), annual",{"$f":"'3 Losses'!E56","v":1850},"kWh/m2",null,null,"Verification: see map -->"]
[null,{"$f":"IF(OR(B53<1300,B53>2300),\"Review input data!\",\"\")","v":""}]
["Daytime electricity demand from 7 am to 5 pm",105,{"$f":"IF(B55>0.8*D43,\"Check input\",\"kWh/day \")","v":"kWh/day "},{"$f":"B55/D43","v":0.37431820612455885},"daily demand)"]
[]
["Technical, other electricity losses  ","kWh input","Losses","kWh demand",null,"Benchmark"]
["For details see \"3 Losses\"",{"$nulls":4},"for losses"]
["Direct feed, daytime ",{"$f":"D59/(1-C59)","v":153.84615384615384},{"$f":"'3 Losses'!E52","v":0.3175},{"$f":"IF(B55>0,B55,D55/100*D43)","v":105},{"$f":"IF(OR(C59<0.28,C59>0.55), \" out of range!\",\"\")","v":""},"30%-50%"]
["Battery feed, night",{"$f":"D60/C60","v":359.55953905249675},{"$f":"'3 Losses'!F52","v":0.48812500000000003},{"$f":"D43-D59","v":175.51},{"$f":"IF(OR(C60<0.35,C60>0.65), \" out of range!\",\"\")","v":""},"40%-60%"]
["Total feed",{"$f":"SUM(B59:B60)","v":513.40569289865061},null,{"$f":"SUM(D59:D60)","v":280.51}]
[null,null,{"$f":"IF(C59<25%,\" Very optimistic!\",\"\")","v":""}]
[{"$nulls":5},"Benchmark"]
["Multiplier for seasonal deficits (see sheet \"3 Losses\")",{"$f":"'3 Losses'!E58","v":1.2766985266208895},{"$f":"IF(OR(B64<1.1,B64>1.6),\"Review input!\",\"\")","v":""},null,null,"1.20 - 1.60"]
["PV array power required, approximately                      ",{"$f":"IF(B64<1.1,1.1*B61/(B53/365),B64*B61/(B53/365))","v":129.32133322384144},"kWp"]
[]
["PV array power proposed by developer                   ",90.6,"kWp",{"$f":"IF(B67<0.9*B65,\"May be > too small < for the present demand.\", IF(B67>1.1*B65,\"May be > too large < for the present demand.\", \"Approximately according to present demand.\"))","v":"May be > too small < for the present demand."}]
["Difference",{"$f":"(B67-B65)/B65","v":-0.29941953317801745},null,{"$f":"+'4 Other supporting data'!D19","v":"Panels fit probably into one 20 ft container"}]
[]
["Battery bank configuration"]
["  - Current voltage",6,"V"]
["  - Nameplate capacity @ 10-hour rate (\"C10\")",820,"Ah ",{"$nulls":4},"6 V(olt)"]
["  - Batteries",60,"units","Useable energy",0.6,{"$f":"E73*B74","v":177.11999999999998}]
["Nameplate energy ",{"$f":"B71*B72*B73/1000","v":295.2},"kWh","Weight of batteries , approx.",null,{"$f":"INT(B74*'4 Other supporting data'!B29/1000+0.5)&\"  ton\"","v":"12  ton"},null,"C10 = "]
[{"$nulls":7},"820 AH @ 10 HR"]
["Assessment of battery bank configuration",{"$nulls":4},"Benchmark "]
["Ratio 1: Nameplate energy / PV array power",{"$f":"B74/B67","v":3.2582781456953644},{"$f":"IF(B77<3,\"Limitations after consecutive cloudy days\",IF(B77>5,\"High investment for periods of cloudy days\",\"\"))","v":""},null,null,"3.0 - 4.5"]
["Ratio 2: Battery energy / night energy demand",{"$f":"B74*E73/D60","v":1.0091732664805424},{"$f":"IF(B78<2.3,\"  Limitations after consecutive cloudy days\",IF(B78>4.5,\"High investment for periods of cloudy days\",\"\"))","v":"  Limitations after consecutive cloudy days"},null,null,"2.3 - 3.5",null,"   Battery label  (producer: Trojan, USA)"]
[]
[]
["INVESTMENT",{"$nulls":11},"Local/Import component"]
[]
["Exchange rate Naira (NGN) / USD ($)",365]
[]
[]
["SITE DEVELOPMENT"]
[]
[{"$nulls":5},"Benchmark"]
["Land area                          ",1800,"m2",{"$f":"IF(B89<0.75*F89,\"rather tiny\",IF(B89<0.85*F89,\"small\",IF(B89>3*F89,\"very large\", IF(B89>1.5*F89,\"rather large\",\"appropriate\"))))","v":"appropriate"},null,{"$f":"15*B67","v":1359},"m2"]
[]
[null,"Naira","$","$/kWp",null,"Benchmark",{"$nulls":6},"Local component"]
[{"$nulls":12},"(estimate)","  Naira"]
["Land use right, compensation, fees",500000,{"$f":"B93/$B$83","v":1369.8630136986301},{"$f":"C93/B$67","v":15.119900813450665},{"$f":"IF(D93>100,\"Review recommended\",\"\")","v":""},"- . -",null,"Power house for batteries",{"$nulls":4},1,{"$f":"M93*B93","v":500000}]
["Land development, fence, power house, building permits",4200000,{"$f":"B94/$B$83","v":11506.849315068494},{"$f":"C94/B$67","v":127.00716683298559},{"$f":"IF(D94>160,\"Review all costs!\",\"\")","v":""},"80 - 120",null,"and electronic equipment, fence",{"$nulls":4},1,{"$f":"M94*B94","v":4200000}]
[]
["Total site development",{"$f":"SUM(B93:B94)","v":4700000},{"$f":"SUM(C93:C94)","v":12876.712328767124},{"$f":"SUM(D93:D94)","v":142.12706764643625},null,"< 150",null,null,"Site development ",{"$f":"\"$  \"&INT(D96+0.5)&\" /kWp\"","v":"$  142 /kWp"},{"$f":"C96/C172","v":3.243616287094548E-2}]
[]
[]
[]
["GENERATION",{"$nulls":6},"(All pictures from Bisanti/Niger State, GVE)"]
[null,"Naira","$","$/kWp",null,"Benchmark"]
["Solar panels (array)"]
["Panels, cif (cost, insurance, freight)",15250000,{"$f":"B103/$B$83","v":41780.821917808222},{"$f":"C103/B67","v":461.15697481024529},{"$f":"IF(D103<350,\" Quality?\",IF(D103>600,\" not competitive\",\"\"))","v":""},"350 - 500",{"$nulls":6},0,{"$f":"M103*B103","v":0}]
["Customs clearance, port fees",2600000,{"$f":"B104/$B$83","v":7123.2876712328771},{"$f":"C104/$B$67","v":78.623484229943458},{"$f":"IF(D104>110,\" Tax on panels?\",\"\")","v":""},"50 - 100",{"$nulls":6},1,{"$f":"M104*B104","v":2600000}]
["Land transport to destination, others",1900000,{"$f":"B105/$B$83","v":5205.4794520547948},{"$f":"C105/$B$67","v":57.455623091112528},{"$f":"IF(D105>50,\" Check destination\",\"\")","v":" Check destination"},"20 - 50",null,"Solar/photovoltaic panels (PV array)",{"$nulls":4},1,{"$f":"M105*B105","v":1900000}]
[]
["Mounting structures"]
["incl. piping to power house, transport, labour",6100000,{"$f":"B108/$B$83","v":16712.328767123287},{"$f":"C108/B$67","v":184.4627899240981},{"$f":"IF(D108<80,\" Quality?\",\"\")","v":""},"100 - 160",{"$nulls":6},1,{"$f":"M108*B108","v":6100000}]
[]
["Solar inverters"]
["Inverters, cif (incl. cost, insurance, freight) ",3400000,{"$f":"B111/$B$83","v":9315.0684931506858},{"$f":"C111/B$67","v":102.81532553146452},null,"100 - 150",null,"Mounting structures",{"$nulls":4},0,{"$f":"M111*B111","v":0}]
["Customs clearance, land transport",1900000,{"$f":"B112/$B$83","v":5205.4794520547948},{"$f":"C112/B$67","v":57.455623091112528},{"$f":"IF(D112>65,\" Import tax?\",\"\")","v":""},"20 - 50",{"$nulls":6},1,{"$f":"M112*B112","v":1900000}]
[]
["Electronic equipment, tools, etc. (balance of system, BOS)"]
["AC distribution box, cables,  circuit breakers, etc.",6100000,{"$f":"B115/$B$83","v":16712.328767123287},{"$f":"C115/B$67","v":184.4627899240981},null,"140 - 200",{"$nulls":6},0.1,{"$f":"M115*B115","v":610000}]
[]
["Other costs related to electricity generating, misc.",1000000,{"$f":"B117/$B$83","v":2739.7260273972602},{"$f":"C117/B67","v":30.239801626901329},null,"- . -",null,"Electronic equipment (also for remote control)",{"$nulls":4},1,{"$f":"M117*B117","v":1000000}]
[{"$f":"IF(B117>0.08*B119,\"Please specify\",\"\")","v":""},{"$nulls":5},{"$f":"IF(B117>0.05*SUM(B102:B116),\"...    \",\"\")","v":""}]
["Total generation",{"$f":"SUM(B102:B118)","v":38250000},{"$f":"B119/$B$83","v":104794.52054794521},{"$f":"SUM(D103:D118)","v":1156.6724122289756},null,"950-1,200",null,null,"Electricity generation ",{"$f":"\"$  \"&INT(D119+0.5)&\" /kWp\"","v":"$  1157 /kWp"},{"$f":"C119/C$172","v":0.2639751552795031}]
[]
[]
[]
["STORAGE"]
[]
["Applicable for lead batteries with about 50% to 60% maximum discharge."]
[]
[null,"Naira","$","$/kWh battery",null,"Benchmark"]
["Batteries, cif "]
["           open wet/flooded lead acid (OPzS)",15000000,{"$f":"B129/$B$83","v":41095.890410958906},{"$f":"C129/B$74","v":139.21372090433235},null,"100 - 150",{"$nulls":6},0,{"$f":"M129*B129","v":0}]
["  or:    closed gel type (OPzV, SLA, AGM)",null,{"$f":"B130/$B$83","v":0},{"$f":"C130/B$74","v":0},null,"130 - 200",{"$nulls":6},0,{"$f":"M130*B130","v":0}]
[{"$f":"IF(AND(B129>0,B130>0),\"Choose one battery type only!\",\"\")","v":""},{"$nulls":6},"Battery bank (open wet/flooded)"]
["Customs clearance, transport to site",4200000,{"$f":"B132/$B$83","v":11506.849315068494},{"$f":"C132/B$74","v":38.979841853213053},{"$f":"IF(D132>50,\" Import tax?\",\"\")","v":""},"20 - 50",{"$nulls":6},1,{"$f":"M132*B132","v":4200000}]
[]
["Electronic equipment for battery management"]
["Inverters or converters, interface, etc., cif",12600000,{"$f":"B135/$B$83","v":34520.547945205479},{"$f":"C135/B$74","v":116.93952555963916},null,"80 - 110",{"$nulls":6},0,{"$f":"M135*B135","v":0}]
["Customs clearance, transport to site, others",4800000,{"$f":"B136/$B$83","v":13150.684931506848},{"$f":"C136/B$74","v":44.548390689386345},null,"30 - 70",{"$nulls":6},1,{"$f":"M136*B136","v":4800000}]
[null,null,{"$f":"B137/$B$83","v":0}]
["Other costs related to storage/battery, racks, misc.",900000,{"$f":"B138/$B$83","v":2465.7534246575342},{"$f":"C138/B74","v":8.3528232542599401},null,"- . -",null,"Electronic equipment at the wall",{"$nulls":4},1,{"$f":"M138*B138","v":900000}]
[{"$f":"IF(B138>0.08*B140,\"Please specify\",\"\")","v":""}]
["Total storage ",{"$f":"SUM(B129:B139)","v":37500000},{"$f":"SUM(C129:C139)","v":102739.72602739728},{"$f":"SUM(D129:D139)","v":348.03430226083083},null,"250 - 400",null,null,"Storage ",{"$f":"\"$  \"&INT(C140/B67+0.5)&\" /kWp\"","v":"$  1134 /kWp"},{"$f":"C140/C172","v":0.25879917184265011}]
[]
[]
[]
["DISTRIBUTION"]
[{"$nulls":5},"Benchmark"]
["Layout"]
["Distance: power house - settlement centre (m)",600,{"$f":"IF(B147<150,\"  mistyping?\",\"\")","v":""},{"$f":"IF(C147=\"  mistyping?\",\"No\",\"\")","v":""},{"$f":"IF(D147=\"No\",200,B147)","v":600},"< 500"]
["Total length of distribution network  (m)",1800,null,"m/customer:",{"$f":"B149/SUM(C39:C42)","v":7.5555555555555554},"< 20"]
["Total length of cables or power lines (m)",5100,null,"m between poles:",{"$f":"B148/B150","v":22.5},"30 - 50",null,"Pole, power lines, insulators, "]
["Number of electric poles",80,null,"customers /pole:",{"$f":"SUM(C39:C42)/B150","v":8.4375},"> 3",null,"fixtures, street lights"]
[]
[null,"Naira","$",null,"$","Benchmark"]
[]
["Poles, transport, foundation, crane, labour",5500000,{"$f":"B154/B$83","v":15068.493150684932},"per pole:",{"$f":"C154/B150","v":188.35616438356163},"< 170",{"$nulls":6},1,{"$f":"M154*B154","v":5500000}]
["Power lines (cables), transport, accessories, labour",23500000,{"$f":"B155/B$83","v":64383.561643835616},"per meter:",{"$f":"C155/B149","v":12.624227773301101},"10 - 15",{"$nulls":6},0.5,{"$f":"M155*B155","v":11750000}]
["Customer connection: service line, equipment, labour",16200000,{"$f":"B156/B$83","v":44383.561643835616},"per customer:",{"$f":"C156/SUM(C39:C42)","v":65.753424657534239},"< 150",{"$nulls":6},0.5,{"$f":"M156*B156","v":8100000}]
[]
["Other costs directly related to distribution, misc.",1600000,{"$f":"B158/B$83","v":4383.5616438356165},null,null,"- . -",null,"Tools for prepayment meter,",{"$nulls":4},1,{"$f":"M158*B158","v":1600000}]
[{"$f":"IF(B158>0.08*B160,\"Please specify\",\"\")","v":""},{"$nulls":6},"Customer Interface Unit (CIU)"]
["Total distribution",{"$f":"SUM(B154:B159)","v":46800000},{"$f":"B160/B$83","v":128219.17808219178},"per customer:",{"$f":"C160/C43","v":189.95433789954336},"< 400",null,null,"Distribution ",{"$f":"\"$  \"&INT(C160/B67+0.5)&\" /kWp\"","v":"$  1415 /kWp"},{"$f":"C160/C172","v":0.32298136645962733}]
[{"$nulls":4},{"$f":"IF(F185/3.5>E160,\"Many customers but low demand.\",\"\")","v":"Many customers but low demand."}]
[]
["OTHERS"]
["Planning, administration, fees","Naira","$","in % of Grand",null,"Benchmark"]
[null,null,null,"Total Investment"]
["Project preparation, (pre-)feasibility, survey, design ",4000000,{"$f":"B166/B$83","v":10958.904109589041},{"$f":"C166/C172","v":2.7605244996549341E-2},null,"- . -",{"$nulls":6},1,{"$f":"M166*B166","v":4000000}]
["Authorizations, regulatory fees, studies (e.g., EIA), approvals",5100000,{"$f":"B167/B$83","v":13972.602739726028},{"$f":"C167/C172","v":3.5196687370600416E-2},null,"- . -",{"$nulls":6},1,5100000]
["Project management, supervision, travel, labour",8550000,{"$f":"B168/B$83","v":23424.657534246577},{"$f":"C168/C172","v":5.9006211180124224E-2},null,"- . -",{"$nulls":6},1,{"$f":"M168*B168","v":8550000}]
[]
["Total other costs (management, fees, travel, etc.)",{"$f":"SUM(B166:B169)","v":17650000},{"$f":"SUM(C166:C169)","v":48356.164383561641},{"$f":"SUM(D166:D169)","v":0.12180814354727398},null,"8% - 15%",null,null,"Other costs ",{"$f":"\"$ \"&INT((C168+C166+C167)/B67+0.5)&\" /kWp\"","v":"$ 534 /kWp"},{"$f":"C170/C172","v":0.12180814354727397}]
[]
["GRAND TOTAL INVESTMENT",{"$f":"B160+B170+B140+B119+B96","v":144900000},{"$f":"B172/B$83","v":396986.30136986304},{"$nulls":5},"GRAND TOTAL ",{"$f":"\"$ \"&INT(C172/B67+0.5)&\" /kWp\"","v":"$ 4382 /kWp"},1]
[]
["Local components, approximately",{"$f":"SUM(N93:N171)","v":73310000},{"$f":"C172*D175","v":196136.98630136988},{"$f":"B174/B$172","v":0.50593512767425808}]
["Imported components, approximately",{"$f":"B172-B174","v":71590000},{"$f":"C172-C174","v":200849.31506849316},{"$f":"B175/B$172","v":0.49406487232574187}]
["Imported solar panels, electronic equipment, batteries",{"$f":"B103+B111+0.5*B115+B129+B130+B135","v":49300000},{"$f":"B176/B83","v":135068.49315068492},0.34023464458247066," Based on experience, $-prices of these items decrease by 5% to 10% annually."]
[]
[]
["INVESTMENT SUMMARY"]
[null,null,"Naira",null,"$","Actual","Benchmark","$","Share","Share"]
[null,"Total","per kWp","per customer","Total","$/kWp","$/kWp","p. customer","Actual","Benchmark"]
["Site development",{"$f":"B96","v":4700000},{"$f":"B182/$B$67","v":51876.37969094923},{"$f":"B182/$C$43","v":6962.9629629629626},{"$f":"C96","v":12876.712328767124},{"$f":"E182/$B$67","v":142.12706764643625},150,{"$f":"E182/$C$43","v":19.076610857432776},{"$f":"H182/$H$187","v":3.243616287094548E-2},{"$f":"G182/G$187","v":3.3333333333333333E-2}]
["Electricity generation",{"$f":"B119","v":38250000},{"$f":"B183/$B$67","v":422185.43046357617},{"$f":"B183/$C$43","v":56666.666666666664},{"$f":"C119","v":104794.52054794521},{"$f":"E183/$B$67","v":1156.6724122289759},1200,155.25114155251143,{"$f":"H183/$H$187","v":0.2639751552795031},0.26666666666666666]
["Electricity storage",{"$f":"B140","v":37500000},413907.28476821195,55555.555555555555,{"$f":"C140","v":102739.72602739728},{"$f":"E184/$B$67","v":1133.9925610088001},1300,152.20700152207004,{"$f":"H184/$H$187","v":0.25879917184265011},0.28888888888888886]
["Electricity distribution",{"$f":"B160","v":46800000},516556.2913907285,69333.333333333328,{"$f":"C160","v":128219.17808219178},{"$f":"E185/$B$67","v":1415.2227161389822},1200,189.95433789954336,{"$f":"H185/$H$187","v":0.32298136645962727},0.26666666666666666]
["Other costs (preparation, fees, management, etc.)",{"$f":"B170","v":17650000},194812.36203090509,26148.14814814815,{"$f":"C170","v":48356.164383561641},{"$f":"E186/$B$67","v":533.73249871480846},650,71.638762049720953,{"$f":"H186/$H$187","v":0.12180814354727397},0.14444444444444443]
["Total",{"$f":"SUM(B182:B186)","v":144900000},1599337.7483443709,214666.66666666666,{"$f":"SUM(E182:E186)","v":396986.30136986304},4381.7472557380033,{"$f":"SUM(G182:G186)","v":4500},588.12785388127861,1,1]
[]
["Overall adjusted specific investment cost assessment"]
["Investment per kWp ",{"$f":"B172/B67","v":1599337.7483443709},{"$f":"C172/B67","v":4381.7472557380033}]
["Benchmark adjusted to PV power (kWp)",null,{"$f":"G187*(1+((1-B67/100)*IF(B67>100,0.2,IF(B67>40,0.4,0.7))))","v":4669.2000000000007}]
{"$rows_empty":13}
["CAPITAL COST"]
[]
["Additional simulation opportunity to assess the viability of PV mini-grids by comparing the actual income with capital costs."]
[]
["Capital cost per kWh sold",null,"p.a.","Lifetime"]
["Depreciation p.a. for batteries",null,0.12,{"$f":"1/C210","v":8.3333333333333339}]
["Depreciation p.a. others",null,0.04,{"$f":"1/C211","v":25}]
["Expected Return on Investment (RoI) p.a. (weighted equity, grant, debt)",null,7.0000000000000007E-2]
[]
["Capital cost per kWh for","Naira","$"]
[" - site development per kWh",{"$f":"B96/(365*D43)*(C212+C211)","v":5.049511091099725},{"$f":"B215/B83","v":1.3834276961917054E-2}]
[" - generation per kWh ",{"$f":"(B119/(365*D43))*(C211+C212)","v":41.094425369056275},{"$f":"B216/B83","v":0.11258746676453774}]
[" - storage per kWh (based on total sales!)",{"$f":"(SUM(B129:B132)/(365*D43))*(C210+C212)+(SUM(B134:B139)/(365*D43))*(C211+C212)","v":55.29068140563934},{"$f":"B217/B83","v":0.15148131891955985}]
[" - distribution per kWh",{"$f":"B160/(D43*365)*(C211+C212)","v":50.280238098610027},{"$f":"B218/B83","v":0.13775407698249323}]
["Total capital cost per kWh",{"$f":"SUM(B216:B218)","v":146.66534487330563},{"$f":"SUM(C216:C218)","v":0.40182286266659084}]
[]
[]
["INCOME PROJECTION"]
[]
["The data for the electricity tariff allow simulating the income, the data for expenses before loan service allow simulating cost and net cash flow before loan service"]
[{"$nulls":7},"Average per customer (Naira)"]
["Tariff  (Naira)","customers","fixed/month","per kWh","Naira, p.a.","Naira, p.m.",null,"Monthly bill  ","  Basic demand bill"]
[]
["Households",{"$f":"C39","v":647},1000,200,{"$f":"B228*C228*12+D$39*365*D228","v":20087130},null,null,{"$f":"E228/B228/12","v":2587.2140649149924},{"$f":"'1 Demand households'!G50*30/1000*D228+C228","v":1900}]
["Commercial enterprises (MSMEs)",{"$f":"C40","v":11},{"$f":"C228","v":1000},{"$f":"D228","v":200},{"$f":"B229*C229*12+D40*365*D229","v":2285500},null,null,{"$f":"E229/B229/12","v":17314.39393939394}]
["Productive enterprises (MSMEs)",{"$f":"C41","v":11},{"$f":"C228","v":1000},{"$f":"D228","v":200},{"$f":"B230*C230*12+D41*365*D230","v":5935500},null,null,{"$f":"E230/B230/12","v":44965.909090909088}]
["Public users",{"$f":"C42","v":6},{"$f":"C228","v":1000},{"$f":"D228","v":200},{"$f":"B231*C231*12+D42*365*D231","v":269100},null,null,{"$f":"E231/B231/12","v":3737.5}]
["Gross Revenues per year (month)",null,null,null,{"$f":"SUM(E228:E231)","v":28577230},{"$f":"E232/12","v":2381435.8333333335}]
[]
[]
["Expenses before loan service","p.a.",null,null,"p.a.         ",null,null,"Cost","Naira/kWh","$/kWh"]
["Smart meter royalty, collection fees",7.0000000000000007E-2," of gross revenues",null,{"$f":"E232*B236","v":2000406.1},null,null,"Operational  cost",{"$f":"E245/(365*D43)","v":107.38477421018371},{"$f":"I236/B$83","v":0.29420486084981839}]
["Land use right",100000,null,null,{"$f":"B237","v":100000},null,null,"Capital cost",{"$f":"B219","v":146.66534487330563},{"$f":"I237/B$83","v":0.40182286266659079}]
["Local guard, daily inspection",800000,null,null,{"$f":"B238","v":800000},null,null,"Total cost",{"$f":"SUM(I236:I237)","v":254.05011908348934},{"$f":"I238/B$83","v":0.69602772351640918}]
["Supervision visits (travel, honorarium)",250000," x   visits/year",3,{"$f":"B239*D239","v":750000}]
["Management (overheads)",0.1," of gross revenues",null,{"$f":"B240*E232","v":2857723},null,null,"Income",{"$f":"E232/(365*D43)","v":279.11226274256825},{"$f":"I240/B83","v":0.76469113080155682}]
["Insurance",100000,null,null,{"$f":"B241","v":100000},null,null,"(weighted average tariff)"]
["Others, minor repairs",100000,null,null,{"$f":"B242","v":100000}]
["Miscellaneous, contingencies",0.03," of gross revenues",null,{"$f":"B243*E232","v":857316.9}]
["Tax, estimate, VAT 5%, WHT 5%, CSR",0.12," of gross revenues",null,{"$f":"B244*E232","v":3429267.6}]
["Total Expenses per year  (month)",null,null,null,{"$f":"SUM(E236:E244)","v":10994713.6},{"$f":"E245/12","v":916226.1333333333}]
[]
["Net cash flow per year  (month)  b e f o r e   loan service",null,null,null,{"$f":"E232-E245","v":17582516.399999999},{"$f":"E247/12","v":1465209.7}]
[]
["FINANCING"]
[]
["The data for the fund composition allow simulating the debt and related loan service expenditures."]
[null,"Naira"]
["Investment",{"$f":"B172","v":144900000}]
["Interest during construction, estimated",3000000]
["Start-up cost",0]
["Others, contingencies",0]
["Total investment",{"$f":"SUM(B253:B256)","v":147900000}]
[]
[]
["Financing","share",null,"Naira"]
["Equity 1, developer",0.15,null,{"$f":"B261*B$257","v":22185000}]
["Equity 2",0.05,null,{"$f":"B262*B$257","v":7395000}]
["Government subsidy",0.2,null,{"$f":"B263*B$257","v":29580000}]
["Grant(s)",0.1,null,{"$f":"B264*B$257","v":14790000}]
[]
["Debt/Loan 1",0.4,null,{"$f":"B$257*B266","v":59160000}]
["- Interest rate",null,0.09,null,"Naira, p.a.","Naira, p.m."]
["- Tenor (years)",null,10]
["- Debt service  p.a. /  p.m.",null,null,null,{"$f":"12*F269","v":8992966.5300777107},{"$f":"IF(C268<>0,PMT(C267/12,C268*12,-D266),\"\")","v":749413.8775064759}]
[]
["Debt/Loan 2 (This is the remainder!)",{"$f":"1-SUM(B261:B270)-SUM(B272:B274)","v":9.9999999999999978E-2},{"$f":"IF((SUM(B261:B266)+B271)<>1,\"Check the input percentages!\",\"\")","v":""},{"$f":"IF(C271<>0,B$257*B344,\"\")","v":14790000}]
["- Interest rate",null,0.2]
["- Tenor (years)",null,5]
["- Debt service  p.a. /  p.m.",null,null,null,{"$f":"12*F274","v":4702134.4817357324},{"$f":"IF(C273<>0,PMT(C272/12,C273*12,-D271),\"\")","v":391844.54014464433}]
["Total investment financing",1,null,{"$f":"B257","v":147900000}]
["Total debt financing cost p.a. / p.m.",{"$f":"IF(SUM(B261:B274)=1,\"\",\"The total is not 100%!\")","v":""},null,null,{"$f":"+E274+E269","v":13695101.011813443},{"$f":"+F274+F269","v":1141258.4176511201}]
[]
["Net cash flow per year  (month)  a f t e r   loan service",null,null,null,{"$f":"E247-E276","v":3887415.3881865554},{"$f":"F247-F276","v":323951.28234887985}]
[]
[]
["CASH FLOW SIMULATION"]
[]
["Start-up simulation"]
["It may take up to about two or three years until the number "]
["of customers and their consumption has achieved the projected level."]
["Capacity use,  income and variable expenses in Year 1, 2, and 3 may be below 100%. ",{"$nulls":4},"Battery replacement simulation"]
["Capacity use Year 1",0.85,{"$f":"IF(B287>1,\" Revise input,   maximum 100%!\",\"\")","v":""},null,null,"Battery price development, $ ",-0.03,"per year"]
["Capacity use Year 2",0.95,{"$f":"IF(B288>1,\" Revise input,   maximum 100%!\",\"\")","v":""},null,null,"Battery scrap rescue value",0.15,"of purchase price"]
["Capacity use Year 3",1,"",null,null,"Battery replacement year",9]
[]
[]
["Inflation rate simulation",null,null,"Average tariff",null,"Data in million Naira",null,null,"Cash flow","Cash flow","Battery"]
[null,"Year","Inflation rate","Naira/kWh","Gross revenue","Expenses","Loan 1 service","Loan 2 service","Surplus (deficit)","Cumulative","replacement",null,null,"Inflator","Battery"]
["Inflation rates can be set individually per year",1,0.12,{"$f":"I240","v":279.11226274256825},{"$f":"E232/1000000*B287","v":24.2906455},{"$f":"(B244+B243+B240+B236)*E294+(E242+E241+E239+E238+E237)/1000000","v":9.6230065600000003},{"$f":"IF(C$268>B294,(E$269)/1000000,0)","v":8.9929665300777106},{"$f":"IF(C$273>B294,(E$274)/1000000,0)","v":4.7021344817357322},{"$f":"E294-F294-G294-H294-K294","v":0.97253792818655693},{"$f":"I294","v":0.97253792818655693},{"$f":"IF(G$289=B294,O294,\"0\")","v":"0"},null,null,1,{"$f":"(($B$129+$B$130+$B$132)/1000000)*N294*(1-$G$288)*(1+$G$287)^B294","v":15.830399999999999}]
[null,2,{"$f":"C294","v":0.12},{"$f":"D294*(1+C294)","v":312.60573427167645},{"$f":"E232/1000000*(1+$C294)*B288","v":30.406172720000001},{"$f":"(B244+B243+B240+B236)*E295+(E242+E241+E239+E238+E237)/1000000*(1+$C294)","v":11.801975270400002},{"$f":"IF(C$268>B295,(E$269)/1000000,0)","v":8.9929665300777106},{"$f":"IF(C$273>=B295,(E$274)/1000000,0)","v":4.7021344817357322},4.909096437786558,{"$f":"J294+I295","v":5.881634365973115},"0",null,null,{"$f":"1+C294","v":1.1200000000000001},17.198146560000001]
[null,3,0.12,{"$f":"D295*(1+C295)","v":350.11842238427766},{"$f":"E295*(1+C294)*(1+$C295)*B289","v":38.141503059968002},{"$f":"(B244+B243+B240+B236)*E296+(E242+E241+E239+E238+E237)/1000000*(1+$C294)*(1+$C295)","v":14.525920979189761},8.9929665300777106,4.7021344817357322,9.9204810689647971,15.802115434937912,"0",null,null,{"$f":"N295*(1+C295)","v":1.2544000000000002},18.684066422784003]
[null,4,0.12,392.13263307039102,{"$f":"E232*(1+$C296)*(1+$C295)*(1+C294)/1000000","v":40.148950589440012},{"$f":"(B244+B243+B240+B236)*E297+(E242+E241+E239+E238+E237)/1000000*(1+$C294)*(1+$C295)*(1+$C296)","v":15.446780988620805},8.9929665300777106,4.7021344817357322,11.007068589005765,26.809184023943679,"0",null,null,1.4049280000000004,20.298369761712539]
[null,5,{"$f":"C297","v":0.12},439.188549038838,{"$f":"E297*(1+$C297)","v":44.966824660172819},{"$f":"F297*(1+$C297)","v":17.300394707255304},{"$f":"IF(C$268>=B298,(E$269)/1000000,0)","v":8.9929665300777106},4.7021344817357322,13.971328941104069,40.780512965047748,"0",null,null,1.5735193600000006,22.052148909124504]
[null,6,0.12,491.89117492349862,50.362843619393558,{"$f":"F298*(1+$C298)","v":19.376442072125943},{"$f":"IF(C$268>=B299,(E$269)/1000000,0)","v":8.9929665300777106},0,21.993435017189903,62.773947982237651,"0",null,null,1.7623416832000007,23.957454574872862]
[null,7,0.12,550.91811591431849,56.406384853720787,21.70161512078106,8.9929665300777106,0,25.711803202862015,88.485751185099673,"0",null,null,1.9738226851840011,26.02737865014188]
[null,8,0.12,617.02828982403673,63.175151036167286,24.30580893527479,8.9929665300777106,0,29.876375570814787,118.36212675591446,"0",null,null,2.2106814074060814,28.276144165514147]
[null,9,0.12,691.07168460292121,70.756169160507369,27.222506007507768,8.9929665300777106,0,3.8214936015073242,122.18362035742179,30.719203021414568,null,null,2.4759631762948113,30.719203021414568]
[null,10,0.12,774.00028675527187,79.246909459768261,30.489206728408703,0,0,48.757702731359558,170.94132308878136,"0",null,null,2.7730787574501892,33.373342162464795]
[null,11,0.12,866.88032116590455,88.756538594940466,34.147911535817748,0,0,54.608627059122718,225.54995014790407,"0",null,null,3.105848208344212,36.256798925301744]
[null,12,0.12,970.90595970581319,99.407323226333332,38.245660920115881,0,0,61.161662306217451,286.71161245412151,"0",null,null,3.478549993345518,39.389386352447822]
["A positive cash flow depends highly on ",13,0.12,1087.4146748705109,111.33620201349335,42.835140230529788,0,0,68.501061782963561,355.21267423708508,"0",null,null,3.8959759925469806,42.792629333299324]
[" -  the electricity tariff at the beginning",14,0.12,1217.9044358549722,124.69654625511257,47.975357058193367,0,0,76.721189196919198,431.93386343400425,"0",null,null,4.3634931116526188,46.489912507696388]
[" -  the assumed inflation rate",15,0.12,1364.052968157569,139.66013180572608,53.732399905176578,0,0,85.927731900549503,517.86159533455373,"0",null,null,4.8871122850509332,50.506640948361365]
{"$rows_empty":19}
["GOVERNMENT SUBSIDY and grants for rural/mini-grid PV electrification"]
[]
["The following reflects the country-wide projected investment and its sources required to finance electrification with PV mini-grids "]
["to assess the probability of government subsidy and grant financing based on the financing profile presented above (rows 261-271)."]
[]
[null,"Power",2016,2020,2025,2030]
["Electricity Vision 30:30:30    Mini-grid  (end of year)","MW",5,180,1367,5314]
["Vision simulation (simulating power growth)","MW ",5,180,1367,5314]
["Periodic mini-grid growth (addition)","MW",5,{"$f":"D335-C335","v":175},{"$f":"E335-D335","v":1187},{"$f":"F335-E335","v":3947}]
["Investment cost for PV, estimated*) ","$  million/MW ",6,4.5,4,3.8,"Total 2016-30"]
["Growth (MW x Investment cost/MW, estimated*) ","$ million",{"$f":"C337*C336","v":30},{"$f":"D337*D336","v":787.5},{"$f":"E337*E336","v":4748},{"$f":"F337*F336","v":14998.599999999999},{"$f":"SUM(C338:F338)","v":20564.099999999999}]
["*) Investment/MW in USD decreases as equipment prices are expected to decrease."]
[{"$nulls":4},"$ million  p.a.",null,null,"For simulation","$","million  p.a."]
["Investment per average year","as above model",null,"2017-2020","2021-2025","2026-2030",null,null,"2017-2020","2021-2025","2026-2030"]
["Equity, private investors",{"$f":"B261+B262","v":0.2},null,{"$f":"$B342*D$346","v":39.375},189.92000000000002,599.94399999999996,null,0.2,{"$f":"$H342*I$346","v":39.375},{"$f":"$H342*J$346","v":189.92000000000002},599.94399999999996]
["Government subsidy (see B263)",{"$f":"B263","v":0.2},null,39.375,189.92000000000002,599.94399999999996,null,0.3,{"$f":"$H343*I$346","v":59.0625},284.88,899.91599999999994]
["Grants, foreign donors (Paris Agreement?)",{"$f":"B264","v":0.1},null,19.6875,94.960000000000008,299.97199999999998,null,0.2,39.375,189.92000000000002,599.94399999999996]
["Debt (potential bank financing)",{"$f":"1-SUM(B342:B344)","v":0.5},null,98.4375,474.8,1499.86,null,{"$f":"$H$346-SUM(H342:H344)","v":0.30000000000000004},59.062500000000007,284.88000000000005,899.91600000000005]
["Investment per average year",null,null,{"$f":"D338/(D333-C333)","v":196.875},949.6,{"$f":"F338/(F333-E333)","v":2999.72},null,{"$f":"100%","v":1},{"$f":"D346","v":196.875},{"$f":"E346","v":949.6},2999.72]
[]
["Until 2020, about $(D346) million per year would need to be invested in PV mini-grid development."]
["Based on the above financing model, the government would have to contribute subsidies amounting to ",null,null,null,{"$f":"D343","v":39.375},"each year."]
["For the following five years (2020-2025) the subsidy would increase to ",null,{"$f":"E343","v":189.92000000000002},"each year."]
[]
[]
["BENCHMARK BASELINES"]
["The specific cost ($/kWp) decrease with increasing power.  No data input or simulation, for consideration only."]
[]
["Array, power","kWp",10,50,100]
["Investment, mini-grid","total",{"$f":"C356*C358","v":73350},{"$f":"D356*D358","v":270000},450000]
["Investment","/kWp",{"$f":"($E358/$E356)*($E356*(1+($E356-C356)*IF(C356>40,0.004,0.007)))","v":7335},{"$f":"($E358/$E356)*($E356*(1+($E356-D356)*IF(D356>40,0.004,0.006)))","v":5400},4500]
["Investment per connection",null,{"$f":"C358/C362*C356","v":1833.75},{"$f":"D358/D362*D356","v":1350},{"$f":"E358/E362*E356","v":1125}]
[]
["Demand (consumption)","kWh/day",{"$f":"C356/$E356*$E361","v":20},{"$f":"D356/$E356*$E361","v":100},200]
["Connections (number of households, MSMEs, public institutions)",null,{"$f":"C356/$E356*$E362","v":40},{"$f":"D356/$E356*$E362","v":200},400]
["Power capacity per connection","kWp",{"$f":"C356/C362","v":0.25},{"$f":"D356/D362","v":0.25},{"$f":"E356/E362","v":0.25}]
["Consumption per connection","kWh/day",{"$f":"C361/C362","v":0.5},{"$f":"D361/D362","v":0.5},{"$f":"E361/E362","v":0.5}]
[]
["E N D "]

{"sheet":"1 Demand households","index":1,"n_rows":69,"n_cols":10,"rows_kept":69,"cut":false,"hidden":false,"merged":[[9,2,9,5],[38,5,39,9],[19,2,19,6],[21,2,23,6],[25,2,29,10],[12,3,12,6]]}
["1 Demand households"]
[]
["DATA ENTRY"]
[null,"Data pre-set, suggestion; data can be adjusted"]
[null,"Direct data input required, some data are connected with the worksheet \"Data input and assessment\"."]
[null,"Data calculated and connected with the worksheet \"Data input and assessment\""]
[]
[]
["Socio-economic data"]
["Name and location of settlement",null,"< Name, LGA, State>",null,null,null,"Coordinates","Nothing",null,"Easting"]
["Total population",null,2500]
["No. of households",null,500]
["Average members per household",null,{"$f":"IF(C12=0,\"\",C11/C12)","v":5},"Regional data from National Bureau of Stats could serve as a benchmark to validate this value."]
["No. of commercial enterprises",null,25]
["No. of productive enterprises",null,20]
["No. of public institutions",null,6]
["Distance to grid, km",null,8]
["Distance to all-weather road, km",null,6]
["Distance to port/Lagos, km",null,760]
[{"$f":"IF(C18>0,\"Access during rainy season\",\"\")","v":"Access during rainy season"}]
[]
["Major income sources, activities",{"$nulls":8},"Satellite picture of location"]
["Major commodities"]
["commodities, products"]
[]
["Other noteworthy facts"]
["(regulations, approvals, etc.)"]
[]
[]
[]
[]
[]
["Residential households and projected electricity demand"]
["The following classifies the residential households into four sub-groups according to their approximate electricity demand."]
[]
["Sub-groups",null,"Consumption kWh/"]
[null,null,"per day","per year"]
["A ","Basic household demand",{"$f":"G50/1000","v":0.15},{"$f":"365*G50/1000","v":54.75}]
["B","Advanced demand",{"$f":"G54/1000","v":0.55000000000000004},{"$f":"365*G54/1000","v":200.75},null,"For comparison, the average annual residential electricity consumption is about 100 kWh/capita (400-500 kWh/household)."]
["C","High demand",{"$f":"G57/1000","v":1.03},{"$f":"365*G57/1000","v":375.95}]
["D","Very high demand",{"$f":"G60/1000","v":3.43},{"$f":"365*G60/1000","v":1251.95}]
[]
["Residential household electricity consumption / demand assessment"]
[]
["Sub- group","Electric items  (\"load\")","No.","Common Watt range","Selected Watt","Operation hours/day","Consumption Wh/day  ","Committed households","  Village  kWh*)/day"]
[1,2,3,4,5,6,7,8,9]
[null,"Light, bulbs",4,"3 - 10",5,5,{"$f":"+F47*E47*C47","v":100}]
[null,"Radio",1,"2 - 20",5,8,{"$f":"+F48*E48*C48","v":40}]
[null,"Charging phone, batteries",1,null,5,2,{"$f":"+F49*E49*C49","v":10}]
["A","Basic demand",{"$nulls":4},{"$f":"SUM(G47:G49)","v":150},500,{"$f":"H50*G50/1000","v":75}]
[null,"Fan",1,"20 - 60",40,6,{"$f":"+F51*E51*C51","v":240}]
[null,"TV LED",1,"30 - 120",40,4,{"$f":"+F52*E52*C52","v":160}]
[null,"Others",{"$nulls":4},{"$f":"+F53*E53*C53","v":0}]
["B","Advanced demand",{"$nulls":4},{"$f":"SUM(G50:G53)","v":550},130,{"$f":"H54*G54/1000","v":71.5}]
[null,"Refrigerator",1,"50 - 120",60,8,{"$f":"+F55*E55*C55","v":480}]
[null,"Others",{"$nulls":4},{"$f":"+F56*E56*C56","v":0}]
["C","High demand",{"$nulls":4},{"$f":"G55+G54+G56","v":1030},15,{"$f":"H57*G57/1000","v":15.45}]
[null,"Air cond., small",1,"400 - 1,000",600,4,{"$f":"+F58*E58*C58","v":2400}]
[null,"Others",{"$nulls":4},{"$f":"+F59*E59*C59","v":0}]
["D","Very high demand",{"$nulls":4},{"$f":"SUM(G57:G59)","v":3430},2,{"$f":"H60*G60/1000","v":6.86}]
[]
[{"$nulls":6},"Total",{"$f":"SUM(H47:H61)","v":647},{"$f":"SUM(I47:I61)","v":168.81}]
["*)   1,000 Wh = 1 kWh"]
[]
["Assessment: comparison of demand with national average"]
["Average demand per household",null,{"$f":"365*I62/H62","v":95.232843894899545},"kWh/year"]
["Average demand per capita",null,{"$f":"+C66/C13","v":19.046568778979911},"kWh/year"]
["National demand, average/capita ",null,100,"kWh/year","Nigeria 2017"]
["In % of national average",null,{"$f":"C66/(C13*C68)","v":0.19046568778979908},"according to average number of households (see socio-economic data above)"]

{"sheet":"2 Demand MSMEs, others","index":2,"n_rows":119,"n_cols":19,"rows_kept":119,"cut":false,"hidden":false,"merged":[[33,18,35,18],[53,18,55,18],[73,18,75,18],[34,13,35,13],[34,14,35,14],[34,17,35,17],[54,13,55,13],[54,14,55,14],[54,17,55,17],[74,13,75,13],[74,14,75,14],[74,17,75,17],[74,15,75,15],[74,16,75,16],[27,2,27,7],[28,2,28,9],[33,13,33,14],[33,16,33,17],[29,2,29,9],[33,3,34,3],[34,15,35,15],[34,16,35,16],[33,11,34,11],[73,3,74,3],[73,11,74,11],[73,13,73,14],[73,16,73,17],[54,15,55,15],[54,16,55,16],[53,3,54,3],[53,11,54,11],[53,13,53,14],[53,16,53,17],[19,2,19,11],[20,2,20,11],[21,2,21,11],[25,2,25,11],[26,2,26,11],[22,2,22,10],[23,2,23,10]]}
["2 Demand MSMEs, others"]
[]
[null,"The PV developer shall support with these data on already registered customers the sale projection."]
[null,"Customers are separated: Commercial MSMEs, Productive MSMEs, Others. "]
[null,"The data shall be presented for maximum nine dominant customers per sub-group plus the aggregate figure for all other customers in the respective groups."]
[null,"The resulting data is the projected electricity demand in kWh/day (yellow cells)."]
[]
[null,"Considerations, additional data on present gen-set costs and gen-set specification"]
[null,"§ Many MSMEs own a gen-set and produce electricity themselves.  "]
[null,"§ Some MSMEs might have to invest in machinery when changing to grid electricity."]
[null,"§ The risk looms that MSMEs might remain with or revert to own electricity generation. For this, consider also Columns H - S (7 - 17)."]
[]
[null,null,"Direct data input required for further processing"]
[null,null,"Direct data input or accepting the pre-set data or data that the formula generates"]
[null,null,"Data generated by formula and connected with the worksheet \"Data input and assessment\""]
[]
[null,"DATA ENTRY"]
[null,"Column","Required data"]
[null,"1, Rows 47, 67, 87","Aggregate number of non-dominant, smaller customers"]
[null,2,"Name of MSME, institution; details on the maximum nine most dominant consumers, all others aggregated"]
[null,3,"Business, activity of the customer"]
[null,4,"Fuel consumption of customer's gen-set (litre per average month), data from survey"]
[null,5,"The gen-set efficiency is pre-set (default) at 1.5 kWh per litre fuel. An individual adjustment is possible for old and small, often idle running gen-sets (0.8 to 1.2) or new, larger (> 5 KVA) gen-sets (1.8 to 3.5). Data from survey."]
[null,6,"Estimated future electricity consumption based on present fuel consumption; direct data input is possible for new enterprises or if no info about fuel consumption is available. "]
[null,null,"Additional financial data for further analysis and consideration"]
[null,"7, Rows 36, 56, 76","Price paid per litre fuel at village level (including transport to village); "]
[null,8,"Expenses for service, maintenance, repair of gen-set, average per month"]
[null,9,"Total expenses presently for electricity or power"]
[null,"10, Rows 36, 56, 76","Projected kWh tariff; tariffs may differ according to customer group"]
[null,11,"Savings (in parenthesis: higher expenses) when using grid electricity; it is expected that in many MSMEs will have higher expenses, which they accept because of superior convenience and reliability."]
[]
[null,"12 -17","Additional gen-set data for consideration (only for the most dominant customers)"]
["C o m m e r c I a l   MSMEs producing electricity for their businesses (data from individual assessment)",{"$nulls":6},"Additional financial data for consideration",{"$nulls":5},"Additional gen-set data for consideration"]
["# ","Name of MSME","Business ","Present monthly fuel consumption ","Estimated gen-set efficiency","Estimated monthly",null,"Fuel expenses","Service maintenance repair","    Total    gen-set expenses","Projected cost of PV electricity","Lower (higher)       PV electricity cost/month",null,"Present gen-set specification",null,"Owner-ship","Loan finance of the gen-set",null,"Operation hours average per month"]
[{"$nulls":4}," kWh/litre  ","electricity demand",null,"Fuel price ₦/litre","   average per month ","per month","Tariff ₦/kWh",null,null,"kW","KVA","own / other","Y / N","MM/YY final payment due"]
[null,null,null,"Litre","(range: 0.8-3.5)","kWh",null,255,"₦ ","₦ ",200,"₦ "]
[1,2,3,4,5,"6 = 4 * 5",null,7,8,"9  = 7 + 8","10 = 6*Tariff","11 = 9 - 10",null,12,13,14,15,16,17]
[1,"Abcd ","Shop with refrigerators",200,1.5,{"$f":"IF(OR(E38<0.8,E38>3.5),\"<- Wrong data!\",E38*D38)","v":300},null,{"$f":"D38*H$36","v":51000},5000,{"$f":"I38+H38","v":56000},{"$f":"$K$36*F38","v":60000},{"$f":"J38-K38","v":-4000}]
[2,"Efgh ","Shop",90,1.5,{"$f":"IF(OR(E39<0.8,E39>3.5),\"<- Wrong data!\",E39*D39)","v":135},null,22950,2000,{"$f":"I39+H39","v":24950},27000,-2050]
[3,"Ijkl ","Restaurant/Bar",60,1.5,90,null,15300,4000,{"$f":"I40+H40","v":19300},18000,1300]
[4,"we","Beauty Salon",40,1.5,60,null,10200,1000,{"$f":"I41+H41","v":11200},12000,-800]
[5,null,null,null,1.5,0,null,0,null,0,0,0]
[6,null,null,null,1.5,0,null,0,null,0,0,0]
[7,null,null,null,1.5,0,null,0,null,0,0,0]
[8,null,null,null,1.5,0,null,0,null,0,0,0]
[9,null,null,null,1.5,0,null,0,null,0,0,0]
[7,"All others",null,200,1.5,300]
[{"$f":"COUNTA(B38:B46)+A47","v":11},"Total per month",null,null,null,{"$f":"SUM(F38:F47)","v":885}]
[null,null,null,"Estimated demand from commercial MSMEs","kWh/day  ",{"$f":"F48/30","v":29.5}]
[]
[{"$f":"IF(A48>'1 Demand households'!C14, \"Too many MSMEs! Compare: 1 Demand households, socio-economic data!\",\"\")","v":""},null,null,null,{"$f":"IF(A48>'1 Demand households'!C14, '1 Demand households'!C14,\"\")","v":""}]
[]
["P r o d u c t I v e   MSMEs producing electricity for their businesses (data from individual assessment)",{"$nulls":6},"Additional financial data for consideration",{"$nulls":5},"Additional gen-set data for consideration"]
["# ","Name of MSME","Business ","Present monthly fuel consumption ","Estimated gen-set efficiency","Estimated monthly",null,"Fuel expenses","Service maintenance repair","    Total    gen-set expenses","Projected cost of PV electricity","Lower (higher)       PV electricity cost/month",null,"Present gen-set specification",null,"Owner-ship","Loan finance of the gen-set",null,"Operation hours average per month"]
[{"$nulls":4}," kWh/litre  ","electricity demand",null,"Fuel price ₦/litre","   average per month ","per month","Tariff ₦/kWh",null,null,"kW","KVA","own / other","Y / N","MM/YY final payment due"]
[null,null,null,"Litre","(range: 0.8-3.5)","kWh",null,{"$f":"H36","v":255},"₦ ","₦ ",200,"₦ "]
[1,2,3,4,5,"6 = 4 * 5",null,7,8,"9  = 7 + 8","10 = 6*Tariff","11 = 9 - 10",null,12,13,14,15,16,17]
[1,"Abcd ","Mill",300,2.7,{"$f":"IF(OR(E58<0.8,E58>3.5),\"<- Wrong data!\",E58*D58)","v":810},null,{"$f":"D58*H$56","v":76500},5000,{"$f":"I58+H58","v":81500},{"$f":"$K$56*F58","v":162000},{"$f":"J58-K58","v":-80500}]
[2,"Efgh ","Mill",280,2.7,756,null,{"$f":"D59*H$56","v":71400},2000,{"$f":"I59+H59","v":73400},151200,-77800]
[3,"Ijkl ","Welding",190,2.4,456,null,48450,2000,{"$f":"I60+H60","v":50450},91200,-40750]
[4,"Mnop","Car repair",120,2.4,288,null,30600,2000,{"$f":"I61+H61","v":32600},57600,-25000]
[5,null,null,null,1.5,0,null,0,null,0,0,0]
[6,null,null,null,1.5,0,null,0,null,0,0,0]
[7,null,null,null,1.5,0,null,0,null,0,0,0]
[8,null,null,null,1.5,0,null,0,null,0,0,0]
[9,null,null,null,1.5,0,null,0,null,0,0,0]
[7,"All others",null,50,1.5,75]
[{"$f":"COUNTA(B58:B66)+A67","v":11},"Total per month",null,null,null,{"$f":"SUM(F58:F67)","v":2385}]
[null,null,null,"Estimated demand from productive MSMEs","kWh/day  ",{"$f":"F68/30","v":79.5}]
[]
[{"$f":"IF(A68>'1 Demand households'!C15, \"Too many MSMEs! Compare: 1 Demand households, socio-economic data!\",\"\")","v":""}]
[]
["P u b l I c   demand",{"$nulls":6},"Additional financial data for consideration",{"$nulls":5},"Additional gen-set data for consideration"]
["# ","Name of MSME","Business ","Present monthly fuel consumption ","Estimated gen-set efficiency","Estimated monthly",null,"Fuel expenses","Service maintenance repair","    Total    gen-set expenses","Projected cost of PV electricity","Lower (higher)       PV electricity cost/month",null,"Present gen-set specification",null,"Owner-ship","Loan finance of the gen-set",null,"Operation hours average per month"]
[{"$nulls":4}," kWh/litre  ","electricity demand",null,"Fuel price ₦/litre","   average per month ","per month","Tariff ₦/kWh",null,null,"Age years","kW / KVA","own / other","Y / N","MM/YY final payment due"]
[null,null,null,"Litre","(range: 0.8-3.5)","kWh",null,{"$f":"H36","v":255},"₦ ","₦ ",200,"₦ "]
[1,2,3,4,5,"6 = 4 * 5",null,7,8,"9  = 7 + 8","10 = 6*Tariff","11 = 9 - 10",null,12,13,14,15,16,17]
[1,"Abed ","School 1",20,1.5,{"$f":"IF(OR(E78<0.8,E78>3.5),\"<- Wrong data!\",E78*D78)","v":30},null,{"$f":"D78*H$76","v":5100},1000,{"$f":"I78+H78","v":6100},{"$f":"$K$76*F78","v":6000},{"$f":"J78-K78","v":100}]
[2,"Eight ","Street lamps",15,1.5,22.5,null,{"$f":"D79*H$76","v":3825},null,{"$f":"I79+H79","v":3825},4500,-675]
[3,"Jill ","Mosque",5,1.5,7.5,null,1275,null,{"$f":"I80+H80","v":1275},1500,-225]
[4,"Mop","Church",5,1.5,7.5,null,1275,null,{"$f":"I81+H81","v":1275},1500,-225]
[5,null,null,null,1.5,0,null,0,null,0,0,0]
[6,null,null,null,1.5,0,null,0,null,0,0,0]
[7,null,null,null,1.5,0,null,0,null,0,0,0]
[8,null,null,null,1.5,0,null,0,null,0,0,0]
[9,null,null,null,1.5,0,null,0,null,0,0,0]
[2,"All others",null,9,1.5,13.5]
[{"$f":"COUNTA(B78:B86)+A87","v":6},"Total per month",null,null,null,{"$f":"SUM(F78:F87)","v":81}]
[null,null,null,"Estimated demand from   p u b l I c  users","kWh/day  ",{"$f":"F88/30","v":2.7}]
[]
[{"$f":"IF(A88>'1 Demand households'!C16, \"Too many units! Compare: 1 Demand households, socio-economic data!\",\"\")","v":""}]
{"$rows_empty":7}
["DEMAND SURVEY QUESTIONNAIRE OUTLINE"]
["Suggestion for developers"]
[null,null,null,"Units"]
[" - General data"]
[null,"Fuel price at location",null,"₦/litre"]
[null,"Projected electricity tariff",null,"₦/kWh"]
[]
[" - Individual data"]
[null,"Name",null,"Text"]
[null,"Business",null,"Text"]
[null,"Present fuel consumption/month ",null,"Litre"]
[null,"Estimated gen-set efficiency",null,"kWh/litre"]
[null,"Service, maintenance, repair, average cost/month ",null,"₦"]
[]
[" - Gen-set assessment "]
[null,"age",null,"years"]
[null,"kW/KVA",null,"units"]
[null,"ownership (own property, rented, other)",null,"p/r/o"]
[null,"loan finance (Y/N)",null,"Y/N"]
[null,"final loan service payment (MM/YY)",null,"MM/YY"]
[null,"gen-set operation hours/month",null,"hours"]

{"sheet":"3 Losses","index":3,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":false,"merged":[[36,1,36,2]]}
["3  Losses"]
[]
[null,"The solar cells produce electricity. Some of this electricity is lost on its way to the consumer."]
[null,"The tables  below serve to assess these system losses."]
[null,"Investors may invest in more panels to balance higher technical losses of inexpensive equipment."]
[null,"The panel efficiency, i.e. the percentage of irradiation converted into electricity, is rather irrelevant."]
[]
[null,"The developer will have to prepare the data."]
[null,"Data to be entered in column E in orange cells"]
[null,"Data transferred to Sheet \"Data input and assessment\" are yellow marked."]
[]
[null,null,"Benchmarks",null,"Project"]
[]
[null,"System losses from panel to grid/power house exit"]
[null,"    Irradiance losses  ","3 - 7%",null,0.03]
[null,"    Tilt of panels  [close to equator, no hills]",0.1,null,0.1]
[null,"Dust   [guards as cleaners]","2 - 4%",null,0.02]
[null,"Solar inverters   [high efficiency]","2 - 6%",null,0.04]
[null,"Temperature  [moderate temperatures]","2 - 5%",null,0.03]
[null,"DC cables losses [from panel to power station/inverter]","1 - 3%",null,0.03]
[null,"Shadings  [no shadings]",0,null,0]
[null,"Others",0,null,0]
[null,"Losses low",0.25,null,{"$f":"SUM(E15:E22)","v":0.25},"  transferred to blue table \"Losses\" below"]
[null,"Losses acceptable","25 - 35%"]
[null,"Losses high",">  35%"]
[]
[null,"System losses from battery operation "]
[null,"Multitasker, electronic devices",0.03,null,0.03]
[null,"Battery in- or converters [high efficiency]","6 - 15%",null,0.06]
[null,"DC cables losses [internal wiring]","1 - 3%",null,0.01]
[null,"Charge/discharge battery (Pb/lead acid: up to 30%; Li-on: 8%)","8 - 30%",null,0.15]
[null,"Others",0,null,0]
[null,"Losses from lead acid battery operation, very low",0.25,null,{"$f":"SUM(E28:E32)","v":0.25},"  transferred to blue table \"Losses, summary\" below"]
[null,"Losses acceptable ","25 - 35%"]
[null,"Losses high","> 35%"]
[]
[null,"System losses from power house exit to consumer meter"]
[null,"AC cables losses [distribution lines, depending on length, diameter]",0.08,null,0.08,"  for more see:","http://photovoltaic-software.com/DC_AC_drop_voltage_energy_losses_calculator.php"]
[null,"Loss due to system manipulation, non- or lost payment",0.02,null,0.01]
[null,"Others",0,null,{"$f":"C40","v":0}]
[null,"Losses low","< 10%",null,{"$f":"SUM(E38:E40)","v":0.09},"  transferred to blue table \"Losses, summary\" below"]
[null,"Losses acceptable","10 - 15%"]
[null,"Losses high","> 15%"]
[]
[]
[null,"Losses, summary ","Losses ",null,"Remaining ","Remaining "]
[null,"calculated from the remainder",null,null,"daytime ","night "]
[null,"Losses from panel to power house ",{"$f":"E23","v":0.25},null,{"$f":"1-C48","v":0.75},{"$f":"1-C48","v":0.75}]
[null,"Losses from dis-/charging the battery (in/out) ",{"$f":"E33","v":0.25},null,null,{"$f":"F48*(1-C49)","v":0.5625}]
[null,"Losses from power house to customer meter ",{"$f":"E41","v":0.09},null,{"$f":"E48*(1-C50)","v":0.6825},{"$f":"F49*(1-C50)","v":0.51187499999999997}]
[]
[null,"Losses",null,null,{"$f":"1-E50","v":0.3175},{"$f":"1-F50","v":0.48812500000000003},"  transferred to \"Data input and assessment\", Configuration"]
[]
[]
[null,"Multiplier to balance seasonal irradiation deficits",null,null,"kWh/m2"]
[null,"Annual irradiation according to location (see map)",null,null,1850]
[null,"Daily irradiation, lowest value    (https://eosweb.larc.nasa.gov/sse/)",null,null,3.97]
[null,"Multiplier",null,null,{"$f":"(E56/365)/E57","v":1.2766985266208895},"  transferred to \"Data input and assessment\", configuration"]

{"sheet":"4 Other supporting data","index":4,"n_rows":67,"n_cols":7,"rows_kept":67,"cut":false,"hidden":false,"merged":[[9,3,9,4],[34,3,34,6],[44,3,44,6],[27,3,27,6]]}
["4  Other supporting data"]
["This sheet shall support the assessment of transport cost."]
["Recommendation: Enter data in worksheet \"Data input and assessment\" first."]
[]
["Data input cells"]
["Data from \"Data input and assessment.\"",null,"alternatively direct data input"]
[]
["Assessment of transport weight and volume of PV panels"]
["Panels"]
["PV capacity proposed by developer",{"$f":"+'Data input and assessment'!B67","v":90.6},"kWp",{"$f":"IF(B10-'Data input and assessment'!B67>2,\"Data inconsistent\",IF(B10-'Data input and assessment'!B67<-2,\"Data inconsistent\",\"\"))","v":""}]
["Panel name plate power rating",300,"Wp",null,null,"Panel name plate:"]
["Number of  panels",{"$f":"B10/(B11/1000)","v":302},null,null,null,"Max. power: 300 W"]
["Panel size, approximately"]
[" - Length",200,"cm"]
[" - Width",100,"cm"]
[" - Thickness",4.5,"cm"]
["Volume, net",{"$f":"B12*B14*B15*B16/1000000","v":27.18},"m3"]
["Addition for palettes, cardboards",0.25]
["Volume, gross",{"$f":"(1+B18)*B17","v":33.975000000000001},"m3",{"$f":"IF(B19<B20,\"Panels fit probably into one 20 ft container\", \"Probably, two 20 ft containers necessary for all panels\")","v":"Panels fit probably into one 20 ft container"}]
["Volume 20 ft container",38.5,"m3"]
["Weight per panel",20,"kg"]
["Weight all panels",{"$f":"B21*B12/1000","v":6.04},"ton"]
["Weight 20 ft container",2.4,"ton"]
["Total panel transport weight, est.",{"$f":"B23+B22","v":8.44},"ton"]
[]
["Assessment of transport weight of batteries"]
["Batteries"]
["Battery bank power  (C10)",{"$f":"'Data input and assessment'!B74","v":295.2},"kWh",{"$f":"IF(B28-'Data input and assessment'!B74>5,\"Data inconsistent\",IF(B28-'Data input and assessment'!B74<-5,\"Data inconsistent\",\"\"))","v":""}]
["Weight,  appr.",40,"kg/kWh"]
["Total battery weight, est.",{"$f":"B29*B28/1000","v":11.808},"ton"]
[]
["Assessment of transport weight of power lines"]
["Power lines, cables"]
["Aluminium, cut surface/section 50 mm2",0.3,"kg/m"]
["Cable length",3500,"m",{"$f":"IF(($B$35+$B$37+$B$39)<>'Data input and assessment'!$B$149,\"Correct total cable length difference:\",\"\")","v":""}]
["Aluminium, 95 mm2",0.5,"kg/m",{"$f":"IF(($B$35+$B$37+$B$39)<>'Data input and assessment'!$B$149,\"Total m here\",\"\")","v":""},null,null,{"$f":"IF(($B$35+$B$37+$B$39)<>'Data input and assessment'!$B$149,($B$35+$B$37+$B$39),\"\")","v":""}]
["Cable length",1100,"m",{"$f":"IF(($B$35+$B$37+$B$39)<>'Data input and assessment'!$B$149,\"Total m in 'Data input … ->B149'\",\"\")","v":""},null,null,{"$f":"IF(($B$35+$B$37+$B$39)<>'Data input and assessment'!$B$149,'Data input and assessment'!$B$149,\"\")","v":""}]
["Others:  120 mm2",0.6,"kg/m"]
["Cable length",500,"m"]
["Total cable weight, est.",{"$f":"(B34*B35+B36*B37+B38*B39)/1000","v":1.9},"ton"]
["Non-insulated cables weigh less."]
[]
["Assessment of transport weight of electric poles"]
["Poles"]
["Steel-reinforced concrete poles, 8 m",{"$f":"'Data input and assessment'!B150","v":80},"pieces",{"$f":"IF(B45-'Data input and assessment'!B150>5,\"Data inconsistent, see 'Data input …' B150\",IF(B45-'Data input and assessment'!B150<-5,\"Data inconsistent, see 'Data input …' B150\",\"\"))","v":""}]
["Weight,  appr.",700,"kg"]
["Total pole weight, est.",{"$f":"B46*B45/1000","v":56},"ton"]
[]
[]
["Transport cost"]
["Panels",null,1000000]
["Mounting structures",null,200000]
["Batteries",null,1000000]
["In-/converters, other electronic equipment",null,500000]
["Power lines, cable ",null,500000]
["Poles",null,2000000]
["Others"]
["Total cost of transport","Naira",{"$f":"SUM(C51:C57)","v":5200000}]
["Total cost of transport",null,{"$f":"C58/'Data input and assessment'!$B$83","v":14246.575342465754}]
[]
["Transport cost in % of total investment",null,{"$f":"C58/'Data input and assessment'!B172","v":3.5886818495514144E-2}]
[]
[]
["Location"]
["Location of the mini-grid",{"$f":"'1 Demand households'!C10","v":"< Name, LGA, State>"}]
["Distance from port/Lagos to destination",{"$f":"'1 Demand households'!C19","v":760},"km"]
["Non-asphalted road",{"$f":"'1 Demand households'!C18","v":6},"km"]