{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Version history","COVER","Capacity factor calculation"],"not_rendered":{"charts":1,"images":4,"macros":1,"external_links":0,"defined_names":2,"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":"Version history","index":0,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Version","Comments"]

{"sheet":"COVER","index":1,"n_rows":61,"n_cols":19,"rows_kept":61,"cut":false,"hidden":false,"merged":[[8,2,10,22],[32,16,38,16],[37,8,37,12],[39,8,39,12],[59,3,59,20]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"INTRO"]
[null,null,"The ECOWAS Regional Centre for Renewable Energy and Energy Efficiency (ECREEE), on behalf of the members of the Economic Community of West African States (ECOWAS) , has requested EU Energy Initiative Partnership Dialogue Facility (EUEI PDF) support for the development of a set of tools (toolbox) to define tariffs for renewable energy and to provide technical assistance for renewable energy tariff calculation. As a result, EMRC (a member of the MRC Group of Companies) has been commissioned by EUEI PDF to develop a toolbox consisting of several standard tariff models to calculate tariffs for renewable technologies and an associated user manual. \nThis Excel based model covers tariff calculation related to RES based Independent Power Producers (IPPs)."]
[]
[]
[]
[]
[null,null,"MODEL CONTROL PANEL"]
[]
[]
[]
[]
[null,null,null,null,null,"Status:",{"$f":"WksProtected('Capacity factor calculation'!A1)","v":"Protected"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"TOOLBOX"]
[null,null,"This is the Wind Energy Profile model",null,null,"The toolbox is made up of 6 Excel models:"]
[]
[null,null,null,null,null," Three renewable project models",null,null,null,null,null,null,null,null,null,"One model"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"of policy goals"]
[]
[null,null,null,null,null,null,null,null,"1. Renewable IPP",null,"2. Prosumer",null,"3. Green Mini-Grid",null,null,null,"6. Supply curve model"]
[]
[]
[]
[]
[null,null,null,null,null," Two models that",null,null,"4. Wind energy profile"]
[null,null,null,null,null," support data conversion"]
[null,null,null,null,null," to model inputs",null,null,"5. Fuel unit conversion"]
[]
[]
[]
[]
[null,null,"LEGEND"]
[null,null,null,"Tabs:",null,null,null,null,null,null,null,null,null,null,null,null,"Cell coding:"]
[null,null,null,null,"Cover",null,"Cover sheet with model information"]
[null,null,null,null,"Capacity factor calculation",null,"Input, calculation and output sheet",null,null,null,null,null,null,null,null,null,null,12.34,"Input (hard coded data)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.34,"Formulas and references (calculations)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.34,"Scenario or assumption election"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.34,"Inactive area (with the current option selection)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"DISCLAIMER"]
[null,null,null,"This financial tool is for informational purposes only. MRC Group, ECREEE and the EUEI PDF are not responsible and do not accept any liability whatsoever for the accuracy of this financial tool or any data within it. "]
[null,null,null,"This financial tool does not represent an endorsement by MRC Group, ECREEE or the EUEI PDF of any activity or project."]

{"sheet":"Capacity factor calculation","index":2,"n_rows":75,"n_cols":8,"rows_kept":75,"cut":false,"hidden":false,"merged":[[3,0,3,2]]}
["Wind Power Capacity Factor and Full Load Hours Calculation"]
[]
["INPUTS"]
["Project and Wind Data"]
["Project name",null,"Reference project"]
["Location",null,"Location X"]
[]
["Wind Turbine Data"]
["Type",null,"G87 2MW","Data source, G87 2MW wind turbine power curve"]
["Manufacturer",null,"Gamesa"]
["Power capacity","MW",2]
[]
["Measurement results"]
["Metering height","metres"]
["Rotor height","metres",80]
["Average speed","m/s"]
["Stand dev","m/s"]
["Hours in Year","hours",8766]
[]
["CALCULATIONS"]
[]
[null,"Weibull Parameters","Metering Tower Height","Rotor Height"]
[null,"k",{"$f":"(C17/C16)^-1.086","v":{"$error":"#DIV/0!"}},{"$f":"C23*((1-0.088*LN($C$14/10))/(1-0.088*LN($C$15/10)))","v":{"$error":"#DIV/0!"}}]
[null,"c",{"$f":"C16*(0.568+0.433/C23)^(-1/C23)","v":{"$error":"#DIV/0!"}},{"$f":"C24*($C$15/$C$14)^D25","v":{"$error":"#DIV/0!"}}]
[null,"n",null,{"$f":"(0.37-0.088*LN(C24))/(1-0.088*LN($C$14/10))","v":{"$error":"#DIV/0!"}}]
[]
["Wind speed and power generation"]
["Range  m/s","Lower m/s","Upper m/s","Average  m/s \n(used in graph)","Probability (v)","Power aero (kW)","Power aero * probability (v) (kW)","Prod elec. (MWh)"]
["0 to 4.5",0,4.5,{"$f":"+AVERAGE(B29,C29)","v":2.25},{"$f":"(1-EXP(-1*(C29/$D$24)^$D$23))-(1-EXP(-1*(B29/$D$24)^$D$23))","v":{"$error":"#DIV/0!"}},180.2,{"$f":"E29*F29","v":{"$error":"#DIV/0!"}},{"$f":"G29*$C$18/1000","v":{"$error":"#DIV/0!"}}]
["4.5 to 5.5",4.5,5.5,{"$f":"+AVERAGE(B30,C30)","v":5},{"$error":"#DIV/0!"},181.2,{"$f":"E30*F30","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["5.5 to 6.5",5.5,6.5,6,{"$error":"#DIV/0!"},335.4,{"$f":"E31*F31","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["6.5 to 7.5",6.5,7.5,7,{"$error":"#DIV/0!"},549.79999999999995,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["7.5 to 8.5",7.5,8.5,8,{"$error":"#DIV/0!"},831.5,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["8.5 to 9.5",8.5,9.5,9,{"$error":"#DIV/0!"},1174.8,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["9.5 to 10.5",9.5,10.5,10,{"$error":"#DIV/0!"},1528.3,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["10.5 to 11.5",10.5,11.5,11,{"$error":"#DIV/0!"},1794.7,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["11.5 to 12.5",11.5,12.5,12,{"$error":"#DIV/0!"},1931.1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["12.5 to 13.5",12.5,13.5,13,{"$error":"#DIV/0!"},1981,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["13.5 to 14.5",13.5,14.5,14,{"$error":"#DIV/0!"},1995.3,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["14.5 to 15.5",14.5,15.5,15,{"$error":"#DIV/0!"},1998.9,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["15.5 to 16.5",15.5,16.5,16,{"$error":"#DIV/0!"},1999.8,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["16.5 to 17.5",16.5,17.5,17,{"$error":"#DIV/0!"},2000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["17.5 to 18.5",17.5,18.5,{"$f":"+AVERAGE(B43,C43)","v":18},{"$error":"#DIV/0!"},2000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["18.5 to 25",18.5,25,21.75,{"$error":"#DIV/0!"},2000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["OUTPUTS"]
[]
["Annual Energy Production"]
[]
["Renewable Energy delivered","MWh",{"$f":"+SUM(H29:H44)","v":{"$error":"#DIV/0!"}}]
["Capacity factor","%",{"$f":"+C72/C11/8760","v":{"$error":"#DIV/0!"}}]
[]
["Equivalent Full Load Hours","hours",{"$f":"+C73*C18","v":{"$error":"#DIV/0!"}}]