{"text_format":"1","workbook":"xlsx","n_sheets":22,"sheets":["Summary","Scaling Factors","Scaling Summary","AEP","BOM Cost","Mooring Cost","Grid Connection - MW Scale","Failure Costs","Install, Asm, O&M","7.2 Mooring Installation costs"," Mooring Installation Scaling","Torque Calcs","Shaft Scaling","Rotor Sizing Output","2.4 2400 FC Quick COE Baseline","2.4 2400 FC Quick COE","2.4 1600 FC Quick COE","2.4 1000 FC Quick COE","2.4 750 FC Quick COE","2.4 500 FC Quick COE","2.4 350 FC Quick COE","Pie Chart"],"not_rendered":{"charts":13,"images":0,"macros":1,"external_links":11,"defined_names":510,"comments":7,"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":"Summary","index":0,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"Name Plate Rating","Florida Current","% Difference","Rotor Diameter","Control Method","Input Pump",null,null,"Florida Target"]
[null,"kW","¢/kWh","%","m","-","#"]
[null,2400,{"$f":"'2.4 2400 FC Quick COE'!$R$10","v":10.403276790513571},null,45.5,null,"2X CBM 6000"]
[null,1050,12.6,{"$f":"(C4-$C$3)/$C$3","v":0.21115685506796791},27.841987613041795,"Stall 2.0","CBM 6000"]
[null,1600,{"$f":"'2.4 1600 FC Quick COE'!$R$10","v":12.321628621434908},{"$f":"(C5-$C$3)/$C$3","v":0.18439880717877494},35.078706289552613,"Stall","2X CBM 6000"]
[null,1500,{"$f":"'2.4 750 FC Quick COE'!$R$10","v":10.672404940111191},{"$f":"(C6-$C$3)/$C$3","v":2.5869555815628168E-2},34.9,"Ideal PDC 1.6","CBM 6000",null,2400,8]
[null,1500,{"$f":"'2.4 500 FC Quick COE'!$R$10","v":14.87000900052084},{"$f":"(C7-$C$3)/$C$3","v":0.42935820126215857},34.9,"Current PDC 1.6","CBM 6000",null,0,8]
[null,2000,{"$f":"'2.4 350 FC Quick COE'!$R$10","v":13.389924126472684},{"$f":"(C8-$C$3)/$C$3","v":0.28708717417598123},32.299999999999997,"Current PDC 1.8","CBM 6000"]

{"sheet":"Scaling Factors","index":1,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,3,1,8],[1,9,1,14]]}
[]
[null,"Factor","Units","Machine Configuration",null,null,null,null,null,"Cost Scale Factor"]
[null,"MW Rating","MW",2400,1600,1000,1500,1500,2000,{"$f":"D3/$D3","v":1},{"$f":"E3/$D3","v":0.66666666666666663},{"$f":"F3/$D3","v":0.41666666666666669},0.625,{"$f":"H3/$D3","v":0.625},{"$f":"I3/$D3","v":0.83333333333333337}]
[null,"Rotor Diameter","m",45.5,35.078706289552613,27.841987613041795,34.9,34.9,32.299999999999997,1,0.77096057779236515,0.61191181567124819,0.76703296703296697,0.76703296703296697,0.70989010989010981]
[null,"Rotor Area","m^2",{"$f":"PI()*D4^2/4","v":1625.9705477735672},966.44471972055237,608.82202210112121,{"$f":"PI()*G4^2/4","v":956.62281699972596},956.62281699972596,819.39804989092363,1,0.59438021250993756,0.37443607015808372,0.5883395725153967,0.5883395725153967,0.50394396811979225]
[null,"Design Torque","kNm",2509.1911764705878,1504.8253676470588,752.56433823529426,1260,1260,1260,1,0.59972527472527482,0.29992307692307701,0.50215384615384628,0.50215384615384628,0.50215384615384628]
[null,"Shaft Design Torque ","kNm",{"$f":"2*D9*210/1000","v":5040},2520.0000022897684,1259.999998454289,{"$f":"H7","v":2520},{"$f":"H6*2","v":2520},{"$f":"I6*2","v":2520},1,0.50000000045431914,0.2499999996933113,0.5,0.5,0.5]
[null,"Rotor Bending","kNm",5000,{"$f":"$D$8*E5/$D$5","v":2971.9010625496871},{"$f":"$D$8*F5/$D$5","v":1872.1803507904185},{"$f":"$D$8*G5/$D$5","v":2941.6978625769839},{"$f":"$D$8*H5/$D$5","v":2941.6978625769839},{"$f":"$D$8*I5/$D$5","v":2519.7198405989611},{"$f":"D8/$D8","v":1},{"$f":"E8/$D8","v":0.59438021250993744},{"$f":"F8/$D8","v":0.37443607015808372},{"$f":"G8/$D8","v":0.58833957251539681},{"$f":"H8/$D8","v":0.58833957251539681},{"$f":"I8/$D8","v":0.50394396811979225}]
[null,"VF Pump Rating","Nm/bar",12000,12000,6000,6000,6000,6000,1,1,0.5,0.5,0.5,0.5]
[null,"VF Pump Volume","l/rev",760,760,380,380,380,380,1,1,0.5,0.5,0.5,0.5]
[null,"Total Pump Weight","kg",{"$f":"7500*2","v":15000},15000,7500,7500,7500,7500,1,1,0.5,0.5,0.5,0.5]
[null,"VF Pump Weight","kg",{"$f":"7500*2","v":15000},15000,7500,{"$f":"G11","v":7500},{"$f":"H11","v":7500},{"$f":"I11","v":7500},1,1,0.5,0.5,0.5,0.5]
[null,"Pressure","bar",210,210,210,210,210,210,1,1,1,1,1,1]
[null,"Gen Torque","Nm",9744.1801892997173,6446.9279614498373,4061.310117111585,6090.1126183123224,6090.1126183123224,8120.1501577497629,1,0.66161830304917191,0.41679341291034339,0.62499999999999989,0.62499999999999989,0.83333333333333315]
[null,"HS Var Pump Weight","kg",1210,640,460,640,640,{"$f":"H15*1.3","v":832},1,0.52892561983471076,0.38016528925619836,0.52892561983471076,0.52892561983471076,0.68760330578512396]
[null,"HS Fixed Pump Weight","kg",880,440,330,440,440,{"$f":"H16*1.3","v":572},1,0.5,0.375,0.5,0.5,0.65]
[null,"TRB Design Weight","kg",{"$f":"54684","v":54684},31349.94353420243,20363.948558136559,33194,33194,{"$f":"H17","v":33194},1,0.57329280107897063,0.372393178226475,0.60701484895033286,0.60701484895033286,0.60701484895033286]
[null,"TRB Diameter","m",4.2,4.2,3.8,{"$f":"F18","v":3.8},{"$f":"F18","v":3.8},{"$f":"F18","v":3.8},1,1,0.90476190476190466,0.90476190476190466,0.90476190476190466,0.90476190476190466]
[null,"Blade Weight","kg",15472,{"$f":"0.0069*(E3/2)^2+4.7374*(E3/2)-138.94","v":8066.9800000000005},{"$f":"0.0069*(F3/2)^2+4.7374*(F3/2)-138.94","v":3954.7599999999998},{"$f":"0.0069*(G3/2)^2+4.7374*(G3/2)-138.94","v":7295.3600000000006},{"$f":"0.0069*(H3/2)^2+4.7374*(H3/2)-138.94","v":7295.3600000000006},{"$f":"H19*2","v":14590.720000000001},1,0.52139219234746648,0.25560754912099276,0.47152016546018616,0.47152016546018616,0.94304033092037232]
[null,"Hub Weight","kg",41200,27722,15910,{"$f":"E20","v":27722},{"$f":"E20","v":27722},{"$f":"H20*1.2","v":33266.400000000001},1,{"$f":"E20/$D20","v":0.67286407766990286},0.38616504854368933,{"$f":"G20/$D20","v":0.67286407766990286},{"$f":"H20/$D20","v":0.67286407766990286},{"$f":"I20/$D20","v":0.80743689320388357}]
[null,"Thrust Factor","kN",1646.873,{"$f":"$D$21*E5/$D$5","v":978.86872371687832},{"$f":"$D$21*F5/$D$5","v":616.64865416945383},{"$f":"$D$21*G5/$D$5","v":968.92055680714896},{"$f":"$D$21*H5/$D$5","v":968.92055680714896},{"$f":"$D$21*I5/$D$5","v":829.93171460934661},1,0.59438021250993744,0.37443607015808372,{"$f":"G21/$D21","v":0.5883395725153967},0.5883395725153967,0.50394396811979225]
[null,"Nacelle Length","m",15,15,12,12,12,12,1,1,0.8,0.8,0.8,0.8]
[null,"Nacelle Volume","m^3",{"$f":"D22*PI()*D18^2/4","v":207.8163540349648},207.8163540349648,136.09379375350983,{"$f":"G22*PI()*G18^2/4","v":136.09379375350983},136.09379375350983,136.09379375350983,1,1,0.65487528344671198,0.65487528344671198,0.65487528344671198,0.65487528344671198]

{"sheet":"Scaling Summary","index":2,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["C-Plane - 2400 kW","QTY","2400 Cost","1600 Cost","1000 Cost","1500 PPDC","1500 APDC","2000 APDC","Scaling Factor"]
[null,"-","$","$","$","$","$","$","-"]
[{"$f":"'BOM Cost'!A3","v":"System Total"},{"$f":"'BOM Cost'!B3","v":1},{"$f":"'BOM Cost'!E3","v":6775436.3957129624},{"$f":"'BOM Cost'!G3","v":4860632.151234813},{"$f":"'BOM Cost'!I3","v":2852993.6202363768},{"$f":"'BOM Cost'!K3","v":3827395.2404834926},{"$f":"'BOM Cost'!M3","v":3827395.2404834926},{"$f":"'BOM Cost'!O3","v":4489080.4762344081}]
[{"$f":"'BOM Cost'!A5","v":"Truss"},{"$f":"'BOM Cost'!B5","v":1},{"$f":"'BOM Cost'!E5","v":874500},{"$f":"'BOM Cost'!G5","v":519785.49583994038},{"$f":"'BOM Cost'!I5","v":327444.34335324424},{"$f":"'BOM Cost'!K5","v":514502.95616471441},{"$f":"'BOM Cost'!M5","v":514502.95616471441},{"$f":"'BOM Cost'!O5","v":440699.00012075831},{"$f":"'BOM Cost'!P6","v":"Rotor Area"}]
[{"$f":"'BOM Cost'!A8","v":"Nacelle Structure"},{"$f":"'BOM Cost'!B8","v":2},{"$f":"'BOM Cost'!E8","v":314178.27381899511},{"$f":"'BOM Cost'!G8","v":314178.27381899511},{"$f":"'BOM Cost'!I8","v":205747.58612001312},{"$f":"'BOM Cost'!K8","v":205747.58612001312},{"$f":"'BOM Cost'!M8","v":205747.58612001312},{"$f":"'BOM Cost'!O8","v":205747.58612001312},{"$f":"'BOM Cost'!P9","v":"Nacelle Volume"}]
[{"$f":"'BOM Cost'!A18","v":"Rotor"},{"$f":"'BOM Cost'!B18","v":2},{"$f":"'BOM Cost'!E18","v":783592},{"$f":"'BOM Cost'!G18","v":442882.28},{"$f":"'BOM Cost'!I18","v":229876.36},{"$f":"'BOM Cost'!K18","v":415103.96},{"$f":"'BOM Cost'!M18","v":415103.96},{"$f":"'BOM Cost'!O18","v":708231.12000000011}]
[{"$f":"'BOM Cost'!A19","v":"Blade "},{"$f":"'BOM Cost'!B19","v":2},{"$f":"'BOM Cost'!E19","v":278496},{"$f":"'BOM Cost'!G19","v":145205.64000000001},{"$f":"'BOM Cost'!I19","v":71185.679999999993},{"$f":"'BOM Cost'!K19","v":131316.48000000001},{"$f":"'BOM Cost'!M19","v":131316.48000000001},{"$f":"'BOM Cost'!O19","v":262632.96000000002},{"$f":"'BOM Cost'!P19","v":"Blade Weight"}]
[{"$f":"'BOM Cost'!A20","v":"Rotor Hub"},{"$f":"'BOM Cost'!B20","v":1},{"$f":"'BOM Cost'!E20","v":226600},{"$f":"'BOM Cost'!G20","v":152471},{"$f":"'BOM Cost'!I20","v":87505},{"$f":"'BOM Cost'!K20","v":152471},{"$f":"'BOM Cost'!M20","v":152471},{"$f":"'BOM Cost'!O20","v":182965.2},{"$f":"'BOM Cost'!P20","v":"Hub Weight"}]
[{"$f":"'BOM Cost'!A22","v":"Tail Cone"},{"$f":"'BOM Cost'!B22","v":2},{"$f":"'BOM Cost'!E22","v":135177},{"$f":"'BOM Cost'!G22","v":135177},{"$f":"'BOM Cost'!I22","v":88524.076190476189},{"$f":"'BOM Cost'!K22","v":88524.076190476189},{"$f":"'BOM Cost'!M22","v":88524.076190476189},{"$f":"'BOM Cost'!O22","v":88524.076190476189},{"$f":"'BOM Cost'!P23","v":"Nacelle Volume"}]
[{"$f":"'BOM Cost'!A25","v":"Drive Train (Internals)"},{"$f":"'BOM Cost'!B25","v":2},{"$f":"'BOM Cost'!E25","v":1717520.9240374858},{"$f":"'BOM Cost'!G25","v":1278185.773878441},{"$f":"'BOM Cost'!I25","v":738626.61613107694},{"$f":"'BOM Cost'!K25","v":947070.51984889968},{"$f":"'BOM Cost'!M25","v":947070.51984889968},{"$f":"'BOM Cost'!O25","v":1021687.9557463356}]
[{"$f":"'BOM Cost'!A26","v":"Hydraulics Package"},{"$f":"'BOM Cost'!B26","v":1},{"$f":"'BOM Cost'!E26","v":1014525.5415384615},{"$f":"'BOM Cost'!G26","v":864556.31076923071},{"$f":"'BOM Cost'!I26","v":471806.46307692304},{"$f":"'BOM Cost'!K26","v":518298.77076923073},{"$f":"'BOM Cost'!M26","v":518298.77076923073},{"$f":"'BOM Cost'!O26","v":569249.54}]
[{"$f":"'BOM Cost'!A27","v":"Low Speed Pump - CBM 6000"},{"$f":"'BOM Cost'!B27","v":2},{"$f":"'BOM Cost'!E27","v":309400},{"$f":"'BOM Cost'!G27","v":309400},{"$f":"'BOM Cost'!I27","v":154700},{"$f":"'BOM Cost'!K27","v":154700},{"$f":"'BOM Cost'!M27","v":154700},{"$f":"'BOM Cost'!O27","v":154700},{"$f":"'BOM Cost'!P27","v":"VF Pump Weight"}]
[{"$f":"'BOM Cost'!A31","v":"High Speed Variable Pump - A4VS 1000"},{"$f":"'BOM Cost'!B31","v":2},{"$f":"'BOM Cost'!E31","v":96800},{"$f":"'BOM Cost'!G31","v":51200},{"$f":"'BOM Cost'!I31","v":36800},{"$f":"'BOM Cost'!K31","v":51200},{"$f":"'BOM Cost'!M31","v":51200},{"$f":"'BOM Cost'!O31","v":66560},{"$f":"'BOM Cost'!P31","v":"HS Var Pump Weight"}]
[{"$f":"'BOM Cost'!A32","v":"High Speed Fixed Pump - A4FM 1000"},{"$f":"'BOM Cost'!B32","v":2},{"$f":"'BOM Cost'!E32","v":50769.230769230773},{"$f":"'BOM Cost'!G32","v":25384.615384615387},{"$f":"'BOM Cost'!I32","v":19038.461538461539},{"$f":"'BOM Cost'!K32","v":25384.615384615387},{"$f":"'BOM Cost'!M32","v":25384.615384615387},{"$f":"'BOM Cost'!O32","v":33000.000000000007},{"$f":"'BOM Cost'!P32","v":"HS Fixed Pump Weight"}]
[{"$f":"'BOM Cost'!A33","v":"Charge Pump - A11/190"},{"$f":"'BOM Cost'!B33","v":1},{"$f":"'BOM Cost'!E33","v":2650},{"$f":"'BOM Cost'!G33","v":2650},{"$f":"'BOM Cost'!I33","v":2650},{"$f":"'BOM Cost'!K33","v":2650},{"$f":"'BOM Cost'!M33","v":2650},{"$f":"'BOM Cost'!O33","v":2650},{"$f":"'BOM Cost'!P33","v":"Pressure"}]
[{"$f":"'BOM Cost'!A35","v":"Hex - Heat Exchanger"},{"$f":"'BOM Cost'!B35","v":1},{"$f":"'BOM Cost'!E35","v":24000},{"$f":"'BOM Cost'!G35","v":16000},{"$f":"'BOM Cost'!I35","v":10000},{"$f":"'BOM Cost'!K35","v":15000},{"$f":"'BOM Cost'!M35","v":15000},{"$f":"'BOM Cost'!O35","v":20000},{"$f":"'BOM Cost'!P35","v":"MW Rating"}]
[{"$f":"'BOM Cost'!A36","v":"Balance of Hydraulic System"},{"$f":"'BOM Cost'!B36","v":1},{"$f":"'BOM Cost'!E36","v":65000},{"$f":"'BOM Cost'!G36","v":65000},{"$f":"'BOM Cost'!I36","v":32500},{"$f":"'BOM Cost'!K36","v":32500},{"$f":"'BOM Cost'!M36","v":32500},{"$f":"'BOM Cost'!O36","v":32500},{"$f":"'BOM Cost'!P36","v":"VF Pump Volume"}]
[{"$f":"'BOM Cost'!A37","v":"Bearings & Seals Package"},{"$f":"'BOM Cost'!B37","v":1},{"$f":"'BOM Cost'!E37","v":589395.38249902427},{"$f":"'BOM Cost'!G37","v":337896.12977587694},{"$f":"'BOM Cost'!I37","v":219486.81972082052},{"$f":"'BOM Cost'!K37","v":357771.74907966889},{"$f":"'BOM Cost'!M37","v":357771.74907966889},{"$f":"'BOM Cost'!O37","v":357771.74907966889},{"$f":"'BOM Cost'!P38","v":"TRB Design Weight"}]
[{"$f":"'BOM Cost'!A56","v":"Electrical System"},{"$f":"'BOM Cost'!B56","v":1},{"$f":"'BOM Cost'!E56","v":113600},{"$f":"'BOM Cost'!G56","v":75733.333333333328},{"$f":"'BOM Cost'!I56","v":47333.333333333328},{"$f":"'BOM Cost'!K56","v":71000},{"$f":"'BOM Cost'!M56","v":71000},{"$f":"'BOM Cost'!O56","v":94666.666666666657},{"$f":"'BOM Cost'!P57","v":"MW Rating"}]
[{"$f":"'BOM Cost'!A66","v":"Monitoring/Controls"},{"$f":"'BOM Cost'!B66","v":1},{"$f":"'BOM Cost'!E66","v":0},{"$f":"'BOM Cost'!G66","v":0},{"$f":"'BOM Cost'!I66","v":0},{"$f":"'BOM Cost'!K66","v":0},{"$f":"'BOM Cost'!M66","v":0},{"$f":"'BOM Cost'!O66","v":0}]
[]
["Additional CAPEX"]
["Installation",null,{"$f":"'Install, Asm, O&M'!C9+'Install, Asm, O&M'!C16","v":1325516.0058321599},{"$f":"'Install, Asm, O&M'!D9+'Install, Asm, O&M'!D16","v":1218110.9726411058},{"$f":"'Install, Asm, O&M'!E9+'Install, Asm, O&M'!E16","v":888449.68101181882},{"$f":"'Install, Asm, O&M'!F9+'Install, Asm, O&M'!F16","v":1164951.8515764135},{"$f":"'Install, Asm, O&M'!G9+'Install, Asm, O&M'!G16","v":1164951.8515764135},{"$f":"'Install, Asm, O&M'!H9+'Install, Asm, O&M'!H16","v":1206054.0238117203},"Install Days"]
["Grid Connection",null,{"$f":"'Grid Connection - MW Scale'!C3","v":1177505.5813953488},{"$f":"'Grid Connection - MW Scale'!D3","v":872231.67173252278},{"$f":"'Grid Connection - MW Scale'!E3","v":628498.72340425535},{"$f":"'Grid Connection - MW Scale'!F3","v":832065.99555414414},{"$f":"'Grid Connection - MW Scale'!G3","v":832065.99555414414},{"$f":"'Grid Connection - MW Scale'!H3","v":1037817.4468085107},"MW Rating & # Machines"]
["Mooring",null,{"$f":"'Mooring Cost'!C4","v":750600},{"$f":"'Mooring Cost'!D4","v":665485.46114459157},{"$f":"'Mooring Cost'!E4","v":528196.16016926465},{"$f":"'Mooring Cost'!F4","v":662095.18681318674},{"$f":"'Mooring Cost'!G4","v":662095.18681318674},{"$f":"'Mooring Cost'!H4","v":662095.18681318674},"Thrust Load"]
[]
["OPEX"]
["O&M",null,{"$f":"'Install, Asm, O&M'!C33","v":239166.15982547859},{"$f":"'Install, Asm, O&M'!D33","v":210738.4984207495},{"$f":"'Install, Asm, O&M'!E33","v":147280.07744074505},{"$f":"'Install, Asm, O&M'!F33","v":189582.28890777996},{"$f":"'Install, Asm, O&M'!G33","v":189205.96890777996},{"$f":"'Install, Asm, O&M'!H33","v":197947.95419832939},"CAPEX $"]
["LRC",null,{"$f":"'Install, Asm, O&M'!C46","v":144499.99999999997},{"$f":"'Install, Asm, O&M'!D46","v":120866.44604033614},{"$f":"'Install, Asm, O&M'!E46","v":93656.489842072609},{"$f":"'Install, Asm, O&M'!F46","v":105712.89476434242},{"$f":"'Install, Asm, O&M'!G46","v":105712.89476434242},{"$f":"'Install, Asm, O&M'!H46","v":117010.25760042807},"CAPEX $"]

{"sheet":"AEP","index":3,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
["System Rating","kW",2400,1600,1000,1500,1500,1900]
["Florida Current","MWh",13650.835035832031,9031.642311611371,5689.5781236605226,{"$f":"4965.5*2*0.9","v":8937.9},{"$f":"3562.4*2*0.9","v":6412.3200000000006},{"$f":"4426.3*2*0.9","v":7967.34}]
[]
[]
[]
[]
[]
[null,"PPA",150,150,150,150,150,150]
[null,"Net Income/Yr",{"$f":"C3*(C9)-'Scaling Summary'!C28-'Scaling Summary'!C29","v":1663959.0955493259},{"$f":"D3*(D9)-'Scaling Summary'!D28-'Scaling Summary'!D29","v":1023141.40228062},{"$f":"E3*(E9)-'Scaling Summary'!E28-'Scaling Summary'!E29","v":612500.15126626065},{"$f":"F3*(F9)-'Scaling Summary'!F28-'Scaling Summary'!F29","v":1045389.8163278777},{"$f":"G3*(G9)-'Scaling Summary'!G28-'Scaling Summary'!G29","v":666929.13632787776},{"$f":"H3*(H9)-'Scaling Summary'!H28-'Scaling Summary'!H29","v":880142.78820124257}]
[null,"ICC",{"$f":"('Scaling Summary'!C3+'Scaling Summary'!C23+'Scaling Summary'!C24+'Scaling Summary'!C25)","v":10029057.982940471},{"$f":"('Scaling Summary'!D3+'Scaling Summary'!D23+'Scaling Summary'!D24+'Scaling Summary'!D25)","v":7616460.256753033},{"$f":"('Scaling Summary'!E3+'Scaling Summary'!E23+'Scaling Summary'!E24+'Scaling Summary'!E25)","v":4898138.1848217156},{"$f":"('Scaling Summary'!F3+'Scaling Summary'!F23+'Scaling Summary'!F24+'Scaling Summary'!F25)","v":6486508.2744272379},{"$f":"('Scaling Summary'!G3+'Scaling Summary'!G23+'Scaling Summary'!G24+'Scaling Summary'!G25)","v":6486508.2744272379},{"$f":"('Scaling Summary'!H3+'Scaling Summary'!H23+'Scaling Summary'!H24+'Scaling Summary'!H25)","v":7395047.1336678257}]
[null,"Simple Payback",{"$f":"C11/C10","v":6.0272262760338826},{"$f":"D11/D10","v":7.4441912327813755},7.9969583267783397,6.2048703489500987,9.725933268026127,8.4020993329743288]
[null,"ROI",{"$f":"-PV(0.07,20,C10)-C11","v":7598948.379265273},{"$f":"-PV(0.07,20,D10)-D11","v":3222714.3341852352},1590697.1430738531,4588366.3318678206,578948.49658008851,1929198.1026244508]
[null,"IRR",{"$f":"C13/C11","v":0.75769313450886022},{"$f":"D13/D11","v":0.42312494591274974},0.32475546484235251,0.70737076678946742,8.9254260086673518E-2,0.26087705294551644]

{"sheet":"BOM Cost","index":4,"n_rows":77,"n_cols":16,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["C-Plane","QTY","Weight",null,"Cost","Config1","1600 kW","Config2","1000 kW","Config 3","750 kW","config 4","500 kW","config 5","100 kW","Scaling Factor"]
[null,"-","kg","$/kg","$","-","$","-","$","-","$","-","$","-","$","-"]
["System Total",1,{"$f":"$B$4*C4+$B$25*C25","v":679244.85541074153},null,{"$f":"$B$4*E4+$B$25*E25","v":6775436.3957129624},null,{"$f":"$B$4*G4+$B$25*G25","v":4860632.151234813},null,{"$f":"$B$4*I4+$B$25*I25","v":2852993.6202363768},null,{"$f":"$B$4*K4+$B$25*K25","v":3827395.2404834926},null,{"$f":"$B$4*M4+$B$25*M25","v":3827395.2404834926},null,{"$f":"$B$4*O4+$B$25*O25","v":4489080.4762344081}]
["Platform",1,{"$f":"$B$5*C5+$B$8*C8+$B$18*C18+$B$22*C22","v":491852.56017264625},null,{"$f":"$B$5*E5+$B$8*E8+$B$18*E18+$B$22*E22","v":3340394.5476379902},null,{"$f":"$B$5*G5+$B$8*G8+$B$18*G18+$B$22*G22","v":2304260.6034779307},null,{"$f":"$B$5*I5+$B$8*I8+$B$18*I18+$B$22*I22","v":1375740.3879742229},null,{"$f":"$B$5*K5+$B$8*K8+$B$18*K18+$B$22*K22","v":1933254.200785693},null,{"$f":"$B$5*M5+$B$8*M8+$B$18*M18+$B$22*M22","v":1933254.200785693},null,{"$f":"$B$5*O5+$B$8*O8+$B$18*O18+$B$22*O22","v":2445704.5647417372}]
["Truss",1,{"$f":"SUMPRODUCT($B$6:$B$7,C6:C7)","v":159000},null,{"$f":"SUMPRODUCT($B$6:$B$7,E6:E7)","v":874500},null,{"$f":"SUMPRODUCT($B$6:$B$7,G6:G7)","v":519785.49583994038},null,{"$f":"SUMPRODUCT($B$6:$B$7,I6:I7)","v":327444.34335324424},null,{"$f":"SUMPRODUCT($B$6:$B$7,K6:K7)","v":514502.95616471441},null,{"$f":"SUMPRODUCT($B$6:$B$7,M6:M7)","v":514502.95616471441},null,{"$f":"SUMPRODUCT($B$6:$B$7,O6:O7)","v":440699.00012075831}]
["Truss Structure",1,159000,5.5,{"$f":"C6*D6","v":874500},{"$f":"'Scaling Factors'!$K$5","v":0.59438021250993756},{"$f":"$E6*F6","v":519785.49583994038},{"$f":"'Scaling Factors'!$L$5","v":0.37443607015808372},{"$f":"$E6*H6","v":327444.34335324424},{"$f":"'Scaling Factors'!$M$5","v":0.5883395725153967},{"$f":"$E6*J6","v":514502.95616471441},{"$f":"'Scaling Factors'!$N$5","v":0.5883395725153967},{"$f":"E6*L6","v":514502.95616471441},{"$f":"'Scaling Factors'!$O$5","v":0.50394396811979225},{"$f":"E6*N6","v":440699.00012075831},{"$f":"'Scaling Factors'!$B$5","v":"Rotor Area"}]
["Fairing Assembly"]
["Nacelle Structure",2,{"$f":"SUMPRODUCT($B$9:$B$17,C9:C17)","v":74971.280086323124},null,{"$f":"SUMPRODUCT($B$9:$B$17,E9:E17)","v":314178.27381899511},null,{"$f":"SUMPRODUCT($B$9:$B$17,G9:G17)","v":314178.27381899511},null,{"$f":"SUMPRODUCT($B$9:$B$17,I9:I17)","v":205747.58612001312},null,{"$f":"SUMPRODUCT($B$9:$B$17,K9:K17)","v":205747.58612001312},null,{"$f":"SUMPRODUCT($B$9:$B$17,M9:M17)","v":205747.58612001312},null,{"$f":"SUMPRODUCT($B$9:$B$17,O9:O17)","v":205747.58612001312}]
["Nacelle Upstream Bulkhead",1,15572.34071912724,5.82,{"$f":"C9*D9","v":90631.022985320538},{"$f":"'Scaling Factors'!$K$23","v":1},{"$f":"$E9*F9","v":90631.022985320538},{"$f":"'Scaling Factors'!$L$23","v":0.65487528344671198},{"$f":"$E9*H9","v":59352.016866577258},{"$f":"'Scaling Factors'!$M$23","v":0.65487528344671198},{"$f":"$E9*J9","v":59352.016866577258},{"$f":"'Scaling Factors'!$N$23","v":0.65487528344671198},{"$f":"$E9*L9","v":59352.016866577258},{"$f":"'Scaling Factors'!$O$23","v":0.65487528344671198},{"$f":"$E9*N9","v":59352.016866577258},{"$f":"'Scaling Factors'!$B$23","v":"Nacelle Volume"}]
["Nacelle Center Body",1,52546.636388323488,3.82,200728.1510033957,{"$f":"'Scaling Factors'!$K$23","v":1},200728.1510033957,{"$f":"'Scaling Factors'!$L$23","v":0.65487528344671198},131451.90478408316,{"$f":"'Scaling Factors'!$M$23","v":0.65487528344671198},131451.90478408316,{"$f":"'Scaling Factors'!$N$23","v":0.65487528344671198},131451.90478408316,{"$f":"'Scaling Factors'!$O$23","v":0.65487528344671198},131451.90478408316,{"$f":"'Scaling Factors'!$B$23","v":"Nacelle Volume"}]
["Blind Flange",1,1381.3029788723879,3.3,4558.2998302788801,{"$f":"'Scaling Factors'!$K$23","v":1},4558.2998302788801,{"$f":"'Scaling Factors'!$L$23","v":0.65487528344671198},2985.1178933889805,{"$f":"'Scaling Factors'!$M$23","v":0.65487528344671198},2985.1178933889805,{"$f":"'Scaling Factors'!$N$23","v":0.65487528344671198},2985.1178933889805,{"$f":"'Scaling Factors'!$O$23","v":0.65487528344671198},2985.1178933889805,{"$f":"'Scaling Factors'!$B$23","v":"Nacelle Volume"}]
["Deck Beams",15,93,3.3,306.89999999999998,{"$f":"'Scaling Factors'!$K$23","v":1},306.89999999999998,{"$f":"'Scaling Factors'!$L$23","v":0.65487528344671198},200.98122448979589,{"$f":"'Scaling Factors'!$M$23","v":0.65487528344671198},200.98122448979589,{"$f":"'Scaling Factors'!$N$23","v":0.65487528344671198},200.98122448979589,{"$f":"'Scaling Factors'!$O$23","v":0.65487528344671198},200.98122448979589,{"$f":"'Scaling Factors'!$B$23","v":"Nacelle Volume"}]
["Deck Plates",8,134,3.3,442.2,{"$f":"'Scaling Factors'!$K$23","v":1},442.2,{"$f":"'Scaling Factors'!$L$23","v":0.65487528344671198},289.58585034013601,{"$f":"'Scaling Factors'!$M$23","v":0.65487528344671198},289.58585034013601,{"$f":"'Scaling Factors'!$N$23","v":0.65487528344671198},289.58585034013601,{"$f":"'Scaling Factors'!$O$23","v":0.65487528344671198},289.58585034013601,{"$f":"'Scaling Factors'!$B$23","v":"Nacelle Volume"}]
["Rail Joist",9,36,3.3,118.8,{"$f":"'Scaling Factors'!$K$23","v":1},118.8,{"$f":"'Scaling Factors'!$L$23","v":0.65487528344671198},77.799183673469386,{"$f":"'Scaling Factors'!$M$23","v":0.65487528344671198},77.799183673469386,{"$f":"'Scaling Factors'!$N$23","v":0.65487528344671198},77.799183673469386,{"$f":"'Scaling Factors'!$O$23","v":0.65487528344671198},77.799183673469386,{"$f":"'Scaling Factors'!$B$23","v":"Nacelle Volume"}]
["Hoist Rail",9,181,3.3,597.29999999999995,{"$f":"'Scaling Factors'!$K$23","v":1},597.29999999999995,{"$f":"'Scaling Factors'!$L$23","v":0.65487528344671198},391.15700680272101,{"$f":"'Scaling Factors'!$M$23","v":0.65487528344671198},391.15700680272101,{"$f":"'Scaling Factors'!$N$23","v":0.65487528344671198},391.15700680272101,{"$f":"'Scaling Factors'!$O$23","v":0.65487528344671198},391.15700680272101,{"$f":"'Scaling Factors'!$B$23","v":"Nacelle Volume"}]
["Hoist",1,695,3.3,2500,{"$f":"'Scaling Factors'!$K$23","v":1},2500,{"$f":"'Scaling Factors'!$L$23","v":0.65487528344671198},1637.18820861678,{"$f":"'Scaling Factors'!$M$23","v":0.65487528344671198},1637.18820861678,{"$f":"'Scaling Factors'!$N$23","v":0.65487528344671198},1637.18820861678,{"$f":"'Scaling Factors'!$O$23","v":0.65487528344671198},1637.18820861678,{"$f":"'Scaling Factors'!$B$23","v":"Nacelle Volume"}]
["Transformer Base",1,356,3.3,{"$f":"C17*D17","v":1174.8},{"$f":"'Scaling Factors'!$K$23","v":1},1174.8,{"$f":"'Scaling Factors'!$L$23","v":0.65487528344671198},769.34748299319722,{"$f":"'Scaling Factors'!$M$23","v":0.65487528344671198},769.34748299319722,{"$f":"'Scaling Factors'!$N$23","v":0.65487528344671198},769.34748299319722,{"$f":"'Scaling Factors'!$O$23","v":0.65487528344671198},769.34748299319722,{"$f":"'Scaling Factors'!$B$23","v":"Nacelle Volume"}]
["Rotor",2,{"$f":"SUMPRODUCT($B$19:$B$21,C19:C21)","v":72144},null,{"$f":"SUMPRODUCT($B$19:$B$21,E19:E21)","v":783592},null,{"$f":"SUMPRODUCT($B$19:$B$21,G19:G21)","v":442882.28},null,{"$f":"SUMPRODUCT($B$19:$B$21,I19:I21)","v":229876.36},null,{"$f":"SUMPRODUCT($B$19:$B$21,K19:K21)","v":415103.96},null,{"$f":"SUMPRODUCT($B$19:$B$21,M19:M21)","v":415103.96},null,{"$f":"SUMPRODUCT($B$19:$B$21,O19:O21)","v":708231.12000000011}]
["Blade ",2,15472,18,{"$f":"C19*D19","v":278496},{"$f":"'Scaling Factors'!K$19","v":0.52139219234746648},{"$f":"$E19*F19","v":145205.64000000001},{"$f":"'Scaling Factors'!$L$19","v":0.25560754912099276},{"$f":"$E19*H19","v":71185.679999999993},{"$f":"'Scaling Factors'!$M$19","v":0.47152016546018616},{"$f":"$E19*J19","v":131316.48000000001},{"$f":"'Scaling Factors'!$N$19","v":0.47152016546018616},{"$f":"$E19*L19","v":131316.48000000001},{"$f":"'Scaling Factors'!$O$19","v":0.94304033092037232},{"$f":"$E19*N19","v":262632.96000000002},{"$f":"'Scaling Factors'!$B$19","v":"Blade Weight"}]
["Rotor Hub",1,41200,{"$f":"2.2*2.5","v":5.5},{"$f":"C20*D20","v":226600},{"$f":"'Scaling Factors'!$K$20","v":0.67286407766990286},{"$f":"$E20*F20","v":152471},{"$f":"'Scaling Factors'!$L$20","v":0.38616504854368933},{"$f":"$E20*H20","v":87505},{"$f":"'Scaling Factors'!$M$20","v":0.67286407766990286},{"$f":"$E20*J20","v":152471},{"$f":"'Scaling Factors'!$N$20","v":0.67286407766990286},{"$f":"$E20*L20","v":152471},{"$f":"'Scaling Factors'!$O$20","v":0.80743689320388357},{"$f":"$E20*N20","v":182965.2},{"$f":"'Scaling Factors'!$B$20","v":"Hub Weight"}]
["Blade / Hub Foam"]
["Tail Cone",2,{"$f":"SUMPRODUCT($B$23:$B$24,C23:C24)","v":19311},null,{"$f":"SUMPRODUCT($B$23:$B$24,E23:E24)","v":135177},null,{"$f":"SUMPRODUCT($B$23:$B$24,G23:G24)","v":135177},null,{"$f":"SUMPRODUCT($B$23:$B$24,I23:I24)","v":88524.076190476189},null,{"$f":"SUMPRODUCT($B$23:$B$24,K23:K24)","v":88524.076190476189},null,{"$f":"SUMPRODUCT($B$23:$B$24,M23:M24)","v":88524.076190476189},null,{"$f":"SUMPRODUCT($B$23:$B$24,O23:O24)","v":88524.076190476189}]
["Tail Cone",1,19311,7,{"$f":"C23*D23","v":135177},{"$f":"'Scaling Factors'!$K$23","v":1},{"$f":"$E23*F23","v":135177},{"$f":"'Scaling Factors'!$L$23","v":0.65487528344671198},{"$f":"$E23*H23","v":88524.076190476189},{"$f":"'Scaling Factors'!$M$23","v":0.65487528344671198},{"$f":"$E23*J23","v":88524.076190476189},{"$f":"'Scaling Factors'!$N$23","v":0.65487528344671198},{"$f":"$E23*L23","v":88524.076190476189},{"$f":"'Scaling Factors'!$O$23","v":0.65487528344671198},{"$f":"$E23*N23","v":88524.076190476189},{"$f":"'Scaling Factors'!$B$23","v":"Nacelle Volume"}]
["Fairing"]
["Drive Train (Internals)",2,{"$f":"$B$26*C26+$B$37*C37+$B$56*C56+$B$66*C66","v":93696.147619047624},null,{"$f":"$B$26*E26+$B$37*E37+$B$56*E56+$B$66*E66","v":1717520.9240374858},null,{"$f":"$B$26*G26+$B$37*G37+$B$56*G56+$B$66*G66","v":1278185.773878441},null,{"$f":"$B$26*I26+$B$37*I37+$B$56*I56+$B$66*I66","v":738626.61613107694},null,{"$f":"$B$26*K26+$B$37*K37+$B$56*K56+$B$66*K66","v":947070.51984889968},null,{"$f":"$B$26*M26+$B$37*M37+$B$56*M56+$B$66*M66","v":947070.51984889968},null,{"$f":"$B$26*O26+$B$37*O37+$B$56*O56+$B$66*O66","v":1021687.9557463356}]
["Hydraulics Package",1,{"$f":"SUMPRODUCT($B$27:$B$36,C27:C36)","v":27145.1},null,{"$f":"SUMPRODUCT($B$27:$B$36,E27:E36)","v":1014525.5415384615},null,{"$f":"SUMPRODUCT($B$27:$B$36,G27:G36)","v":864556.31076923071},null,{"$f":"SUMPRODUCT($B$27:$B$36,I27:I36)","v":471806.46307692304},null,{"$f":"SUMPRODUCT($B$27:$B$36,K27:K36)","v":518298.77076923073},null,{"$f":"SUMPRODUCT($B$27:$B$36,M27:M36)","v":518298.77076923073},null,{"$f":"SUMPRODUCT($B$27:$B$36,O27:O36)","v":569249.54}]
["Low Speed Pump - CBM 6000",2,7500,41.25333333333333,{"$f":"C27*D27","v":309400},{"$f":"'Scaling Factors'!$K$12","v":1},{"$f":"$E27*F27","v":309400},{"$f":"'Scaling Factors'!$L$12","v":0.5},{"$f":"$E27*H27","v":154700},{"$f":"'Scaling Factors'!$M$12","v":0.5},{"$f":"$E27*J27","v":154700},{"$f":"'Scaling Factors'!$N$12","v":0.5},{"$f":"$E27*L27","v":154700},{"$f":"'Scaling Factors'!$O$12","v":0.5},{"$f":"$E27*N27","v":154700},{"$f":"'Scaling Factors'!$B$12","v":"VF Pump Weight"}]
["Torque Arm ",2,893.8,{"$f":"3.3","v":3.3},2949.5399999999995,1,2949.5399999999995,0.5,1474.7699999999998,0.5,1474.7699999999998,0.5,1474.7699999999998,0.5,1474.7699999999998,"Approx"]
["Hagglund Torque Cylinder",2,41,6,246,1,246,0.5,123,0.5,123,0.5,123,0.5,123,"Approx"]
["Hagglund Torque Rod Assembly",2,27,6,162,1,162,0.5,81,0.5,81,0.5,81,0.5,81,"Approx"]
["High Speed Variable Pump - A4VS 1000",2,1210,80,96800,{"$f":"'Scaling Factors'!$K$15","v":0.52892561983471076},51200,{"$f":"'Scaling Factors'!$L$15","v":0.38016528925619836},36800,{"$f":"'Scaling Factors'!$M$15","v":0.52892561983471076},51200,{"$f":"'Scaling Factors'!$N$15","v":0.52892561983471076},51200,{"$f":"'Scaling Factors'!$O$15","v":0.68760330578512396},66560,{"$f":"'Scaling Factors'!$B$15","v":"HS Var Pump Weight"}]
["High Speed Fixed Pump - A4FM 1000",2,880,57.692307692307693,50769.230769230773,{"$f":"'Scaling Factors'!$K$16","v":0.5},25384.615384615387,{"$f":"'Scaling Factors'!$L$16","v":0.375},19038.461538461539,{"$f":"'Scaling Factors'!$M$16","v":0.5},25384.615384615387,{"$f":"'Scaling Factors'!$N$16","v":0.5},25384.615384615387,{"$f":"'Scaling Factors'!$O$16","v":0.65},33000.000000000007,{"$f":"'Scaling Factors'!$B$16","v":"HS Fixed Pump Weight"}]
["Charge Pump - A11/190",1,95,null,2650,{"$f":"'Scaling Factors'!$K$13","v":1},2650,{"$f":"'Scaling Factors'!$L$13","v":1},2650,{"$f":"'Scaling Factors'!$M$13","v":1},2650,{"$f":"'Scaling Factors'!$N$13","v":1},2650,{"$f":"'Scaling Factors'!$O$13","v":1},2650,{"$f":"'Scaling Factors'!$B$13","v":"Pressure"}]
["Charge Pump Motor (W/ Adapter, Cplg)",1,100.5,null,2222,{"$f":"'Scaling Factors'!$K$13","v":1},2222,{"$f":"'Scaling Factors'!$M$13","v":1},2222,{"$f":"'Scaling Factors'!$M$13","v":1},2222,{"$f":"'Scaling Factors'!$N$13","v":1},2222,{"$f":"'Scaling Factors'!$O$13","v":1},2222,{"$f":"'Scaling Factors'!$B$13","v":"Pressure"}]
["Hex - Heat Exchanger",1,1790,null,24000,{"$f":"'Scaling Factors'!$K$3","v":0.66666666666666663},16000,{"$f":"'Scaling Factors'!$L$3","v":0.41666666666666669},10000,{"$f":"'Scaling Factors'!$M$3","v":0.625},15000,{"$f":"'Scaling Factors'!$N$3","v":0.625},15000,{"$f":"'Scaling Factors'!$O$3","v":0.83333333333333337},20000,{"$f":"'Scaling Factors'!$B$3","v":"MW Rating"}]
["Balance of Hydraulic System",1,4056,null,65000,{"$f":"'Scaling Factors'!$K$10","v":1},65000,{"$f":"'Scaling Factors'!$L$10","v":0.5},32500,{"$f":"'Scaling Factors'!$M$10","v":0.5},32500,{"$f":"'Scaling Factors'!$N$10","v":0.5},32500,{"$f":"'Scaling Factors'!$O$10","v":0.5},32500,{"$f":"'Scaling Factors'!$B$10","v":"VF Pump Volume"}]
["Bearings & Seals Package",1,{"$f":"SUMPRODUCT($B$38:$B$55,C38:C55)","v":55135.294784580503},null,{"$f":"SUMPRODUCT($B$38:$B$55,E38:E55)","v":589395.38249902427},null,{"$f":"SUMPRODUCT($B$38:$B$55,G38:G55)","v":337896.12977587694},null,{"$f":"SUMPRODUCT($B$38:$B$55,I38:I55)","v":219486.81972082052},null,{"$f":"SUMPRODUCT($B$38:$B$55,K38:K55)","v":357771.74907966889},null,{"$f":"SUMPRODUCT($B$38:$B$55,M38:M55)","v":357771.74907966889},null,{"$f":"SUMPRODUCT($B$38:$B$55,O38:O55)","v":357771.74907966889}]
["Mainshaft",1,18000,12,{"$f":"C38*D38","v":216000},{"$f":"'Scaling Factors'!$K$17","v":0.57329280107897063},{"$f":"$E38*F38","v":123831.24503305765},{"$f":"'Scaling Factors'!$L$17","v":0.372393178226475},{"$f":"$E38*H38","v":80436.926496918604},{"$f":"'Scaling Factors'!$M$17","v":0.60701484895033286},{"$f":"$E38*J38","v":131115.2073732719},{"$f":"'Scaling Factors'!$N$17","v":0.60701484895033286},{"$f":"$E38*L38","v":131115.2073732719},{"$f":"'Scaling Factors'!$O$17","v":0.60701484895033286},{"$f":"$E38*N38","v":131115.2073732719},{"$f":"'Scaling Factors'!$B$17","v":"TRB Design Weight"}]
["Bearing, CARB",1,516,37.59108527131783,19397,{"$f":"'Scaling Factors'!$K$17","v":0.57329280107897063},11120.160462528793,{"$f":"'Scaling Factors'!$L$17","v":0.372393178226475},7223.3104780589356,{"$f":"'Scaling Factors'!$M$17","v":0.60701484895033286},11774.267025089606,{"$f":"'Scaling Factors'!$N$17","v":0.60701484895033286},11774.267025089606,{"$f":"'Scaling Factors'!$O$17","v":0.60701484895033286},11774.267025089606,{"$f":"'Scaling Factors'!$B$17","v":"TRB Design Weight"}]
["TRB,Aft",1,461.67800453514735,54.466157804766524,25145.827050001051,{"$f":"'Scaling Factors'!$K$17","v":0.57329280107897063},14415.921624942452,{"$f":"'Scaling Factors'!$L$17","v":0.372393178226475},9364.1344542831575,{"$f":"'Scaling Factors'!$M$17","v":0.60701484895033286},15263.890408487583,{"$f":"'Scaling Factors'!$N$17","v":0.60701484895033286},15263.890408487583,{"$f":"'Scaling Factors'!$O$17","v":0.60701484895033286},15263.890408487583,{"$f":"'Scaling Factors'!$B$17","v":"TRB Design Weight"}]
["TRB, Fwd",1,301.58730158730157,62.127584664167088,18736.890613002772,{"$f":"'Scaling Factors'!$K$17","v":0.57329280107897063},10741.724503038629,{"$f":"'Scaling Factors'!$L$17","v":0.372393178226475},6977.4902454579078,{"$f":"'Scaling Factors'!$M$17","v":0.60701484895033286},11373.570825250787,{"$f":"'Scaling Factors'!$N$17","v":0.60701484895033286},11373.570825250787,{"$f":"'Scaling Factors'!$O$17","v":0.60701484895033286},11373.570825250787,{"$f":"'Scaling Factors'!$B$17","v":"TRB Design Weight"}]
["Nacelle Aft Bulkhead - Housing, Bearing",1,26000,6.8,176800,{"$f":"'Scaling Factors'!$K$17","v":0.57329280107897063},101358.167230762,{"$f":"'Scaling Factors'!$L$17","v":0.372393178226475},65839.113910440778,{"$f":"'Scaling Factors'!$M$17","v":0.60701484895033286},107320.22529441885,{"$f":"'Scaling Factors'!$N$17","v":0.60701484895033286},107320.22529441885,{"$f":"'Scaling Factors'!$O$17","v":0.60701484895033286},107320.22529441885,{"$f":"'Scaling Factors'!$B$17","v":"TRB Design Weight"}]
["Bearing Retainer",1,549,7.5628415300546434,4151.9999999999991,{"$f":"'Scaling Factors'!$K$17","v":0.57329280107897063},2380.3117100798854,{"$f":"'Scaling Factors'!$L$17","v":0.372393178226475},1546.1764759963239,{"$f":"'Scaling Factors'!$M$17","v":0.60701484895033286},2520.3256528417814,{"$f":"'Scaling Factors'!$N$17","v":0.60701484895033286},2520.3256528417814,{"$f":"'Scaling Factors'!$O$17","v":0.60701484895033286},2520.3256528417814,{"$f":"'Scaling Factors'!$B$17","v":"TRB Design Weight"}]
["Oil Dam",1,15.419501133786847,16.440000000000001,253.49659863945578,{"$f":"'Scaling Factors'!$K$17","v":0.57329280107897063},145.32777509800519,{"$f":"'Scaling Factors'!$L$17","v":0.372393178226475},94.400404036948061,{"$f":"'Scaling Factors'!$M$17","v":0.60701484895033286},153.87619953255242,{"$f":"'Scaling Factors'!$N$17","v":0.60701484895033286},153.87619953255242,{"$f":"'Scaling Factors'!$O$17","v":0.60701484895033286},153.87619953255242,{"$f":"'Scaling Factors'!$B$17","v":"TRB Design Weight"}]
["Hub For Seal",1,513.8321995464853,5.34,2743.8639455782313,{"$f":"'Scaling Factors'!$K$17","v":0.57329280107897063},1573.0374471401406,{"$f":"'Scaling Factors'!$L$17","v":0.372393178226475},1021.7962153149132,{"$f":"'Scaling Factors'!$M$17","v":0.60701484895033286},1665.5661584654345,{"$f":"'Scaling Factors'!$N$17","v":0.60701484895033286},1665.5661584654345,{"$f":"'Scaling Factors'!$O$17","v":0.60701484895033286},1665.5661584654345,{"$f":"'Scaling Factors'!$B$17","v":"TRB Design Weight"}]
["Main Seal",1,878.91156462585036,54.177348278341135,47617.097942596425,{"$f":"'Scaling Factors'!$K$17","v":0.57329280107897063},27298.539458762792,{"$f":"'Scaling Factors'!$L$17","v":0.372393178226475},17732.282440764826,{"$f":"'Scaling Factors'!$M$17","v":0.60701484895033286},28904.285515078376,{"$f":"'Scaling Factors'!$N$17","v":0.60701484895033286},28904.285515078376,{"$f":"'Scaling Factors'!$O$17","v":0.60701484895033286},28904.285515078376,{"$f":"'Scaling Factors'!$B$17","v":"TRB Design Weight"}]
["Hub, Brake",1,769.6145124716553,7.6499999999999995,5887.5510204081629,{"$f":"'Scaling Factors'!$K$17","v":0.57329280107897063},3375.2906159851473,{"$f":"'Scaling Factors'!$L$17","v":0.372393178226475},2192.4838364603215,{"$f":"'Scaling Factors'!$M$17","v":0.60701484895033286},3573.8308933404392,{"$f":"'Scaling Factors'!$N$17","v":0.60701484895033286},3573.8308933404392,{"$f":"'Scaling Factors'!$O$17","v":0.60701484895033286},3573.8308933404392,{"$f":"'Scaling Factors'!$B$17","v":"TRB Design Weight"}]
["Spacer, Bearing",1,34.920634920634917,13.5,471.42857142857139,{"$f":"'Scaling Factors'!$K$17","v":0.57329280107897063},270.26660622294327,{"$f":"'Scaling Factors'!$L$17","v":0.372393178226475},175.55678402105249,{"$f":"'Scaling Factors'!$M$17","v":0.60701484895033286},286.16414307658545,{"$f":"'Scaling Factors'!$N$17","v":0.60701484895033286},286.16414307658545,{"$f":"'Scaling Factors'!$O$17","v":0.60701484895033286},286.16414307658545,{"$f":"'Scaling Factors'!$B$17","v":"TRB Design Weight"}]
["Plate, Brake Disc",6,176.87074829931973,9,1591.8367346938776,{"$f":"'Scaling Factors'!$K$17","v":0.57329280107897063},912.58854049305535,{"$f":"'Scaling Factors'!$L$17","v":0.372393178226475},592.78914085030715,{"$f":"'Scaling Factors'!$M$17","v":0.60701484895033286},966.26853506379518,{"$f":"'Scaling Factors'!$N$17","v":0.60701484895033286},966.26853506379518,{"$f":"'Scaling Factors'!$O$17","v":0.60701484895033286},966.26853506379518,{"$f":"'Scaling Factors'!$B$17","v":"TRB Design Weight"}]
["Bracket, Brake",6,292.97052154195012,9,2636.7346938775509,{"$f":"'Scaling Factors'!$K$17","v":0.57329280107897063},1511.6210183551632,{"$f":"'Scaling Factors'!$L$17","v":0.372393178226475},981.9020127930728,{"$f":"'Scaling Factors'!$M$17","v":0.60701484895033286},1600.5371119261838,{"$f":"'Scaling Factors'!$N$17","v":0.60701484895033286},1600.5371119261838,{"$f":"'Scaling Factors'!$O$17","v":0.60701484895033286},1600.5371119261838,{"$f":"'Scaling Factors'!$B$17","v":"TRB Design Weight"}]
["Labryinth Seal",1,37.188208616780045,13.33,495.71882086167801,{"$f":"'Scaling Factors'!$K$17","v":0.57329280107897063},284.19203135935584,{"$f":"'Scaling Factors'!$L$17","v":0.372393178226475},184.60230720736089,{"$f":"'Scaling Factors'!$M$17","v":0.60701484895033286},300.90868516718859,{"$f":"'Scaling Factors'!$N$17","v":0.60701484895033286},300.90868516718859,{"$f":"'Scaling Factors'!$O$17","v":0.60701484895033286},300.90868516718859,{"$f":"'Scaling Factors'!$B$17","v":"TRB Design Weight"}]
["Labryinth Seal",1,213.15192743764172,9.1199999999999992,1943.9455782312923,{"$f":"'Scaling Factors'!$K$17","v":0.57329280107897063},1114.4500056892969,{"$f":"'Scaling Factors'!$L$17","v":0.372393178226475},723.9120721768536,{"$f":"'Scaling Factors'!$M$17","v":0.60701484895033286},1180.0038315377353,{"$f":"'Scaling Factors'!$N$17","v":0.60701484895033286},1180.0038315377353,{"$f":"'Scaling Factors'!$O$17","v":0.60701484895033286},1180.0038315377353,{"$f":"'Scaling Factors'!$B$17","v":"TRB Design Weight"}]
["Lip Seal",1,3.6281179138321993,22.64,82.140589569160994,{"$f":"'Scaling Factors'!$K$17","v":0.57329280107897063},47.090608676382381,{"$f":"'Scaling Factors'!$L$17","v":0.372393178226475},30.588595211056305,{"$f":"'Scaling Factors'!$M$17","v":0.60701484895033286},49.860557570015551,{"$f":"'Scaling Factors'!$N$17","v":0.60701484895033286},49.860557570015551,{"$f":"'Scaling Factors'!$O$17","v":0.60701484895033286},49.860557570015551,{"$f":"'Scaling Factors'!$B$17","v":"TRB Design Weight"}]
["Seal Retainer",1,7.7097505668934234,19.11,147.33333333333331,{"$f":"'Scaling Factors'!$K$17","v":0.57329280107897063},84.465139358968329,{"$f":"'Scaling Factors'!$L$17","v":0.372393178226475},54.865928258700642,{"$f":"'Scaling Factors'!$M$17","v":0.60701484895033286},89.433521078682361,{"$f":"'Scaling Factors'!$N$17","v":0.60701484895033286},89.433521078682361,{"$f":"'Scaling Factors'!$O$17","v":0.60701484895033286},89.433521078682361,{"$f":"'Scaling Factors'!$B$17","v":"TRB Design Weight"}]
["Brake Caliper",6,668.93424036281181,11,7358.2766439909301,{"$f":"'Scaling Factors'!$K$17","v":0.57329280107897063},4218.4470283475275,{"$f":"'Scaling Factors'!$L$17","v":0.372393178226475},2740.1720257254228,{"$f":"'Scaling Factors'!$M$17","v":0.60701484895033286},4466.5831855869164,{"$f":"'Scaling Factors'!$N$17","v":0.60701484895033286},4466.5831855869164,{"$f":"'Scaling Factors'!$O$17","v":0.60701484895033286},4466.5831855869164,{"$f":"'Scaling Factors'!$B$17","v":"TRB Design Weight"}]
["Electrical System",1,{"$f":"SUMPRODUCT($B$57:$B$65,C57:C65)","v":11415.752834467119},null,{"$f":"SUMPRODUCT($B$57:$B$65,E57:E65)","v":113600},null,{"$f":"SUMPRODUCT($B$57:$B$65,G57:G65)","v":75733.333333333328},null,{"$f":"SUMPRODUCT($B$57:$B$65,I57:I65)","v":47333.333333333328},null,{"$f":"SUMPRODUCT($B$57:$B$65,K57:K65)","v":71000},null,{"$f":"SUMPRODUCT($B$57:$B$65,M57:M65)","v":71000},null,{"$f":"SUMPRODUCT($B$57:$B$65,O57:O65)","v":94666.666666666657}]
["Generator",1,6100,null,72000,{"$f":"'Scaling Factors'!$K$3","v":0.66666666666666663},{"$f":"$E57*F57","v":48000},{"$f":"'Scaling Factors'!$L$3","v":0.41666666666666669},{"$f":"$E57*H57","v":30000},{"$f":"'Scaling Factors'!$M$3","v":0.625},{"$f":"$E57*J57","v":45000},{"$f":"'Scaling Factors'!$N$3","v":0.625},{"$f":"$E57*L57","v":45000},{"$f":"'Scaling Factors'!$O$3","v":0.83333333333333337},{"$f":"$E57*N57","v":60000},{"$f":"'Scaling Factors'!$B$3","v":"MW Rating"}]
["Contactor",1,181.40589569160997,null,2600,{"$f":"'Scaling Factors'!$K$3","v":0.66666666666666663},1733.3333333333333,{"$f":"'Scaling Factors'!$L$3","v":0.41666666666666669},1083.3333333333335,{"$f":"'Scaling Factors'!$M$3","v":0.625},1625,{"$f":"'Scaling Factors'!$N$3","v":0.625},1625,{"$f":"'Scaling Factors'!$O$3","v":0.83333333333333337},2166.666666666667,{"$f":"'Scaling Factors'!$B$3","v":"MW Rating"}]
["Circuit Breaker",1,362.81179138321994,null,6000,{"$f":"'Scaling Factors'!$K$3","v":0.66666666666666663},4000,{"$f":"'Scaling Factors'!$L$3","v":0.41666666666666669},2500,{"$f":"'Scaling Factors'!$M$3","v":0.625},3750,{"$f":"'Scaling Factors'!$N$3","v":0.625},3750,{"$f":"'Scaling Factors'!$O$3","v":0.83333333333333337},5000,{"$f":"'Scaling Factors'!$B$3","v":"MW Rating"}]
["Controller Card",1,4.5351473922902494,null,1500,{"$f":"'Scaling Factors'!$K$3","v":0.66666666666666663},1000,{"$f":"'Scaling Factors'!$L$3","v":0.41666666666666669},625,{"$f":"'Scaling Factors'!$M$3","v":0.625},937.5,{"$f":"'Scaling Factors'!$N$3","v":0.625},937.5,{"$f":"'Scaling Factors'!$O$3","v":0.83333333333333337},1250,{"$f":"'Scaling Factors'!$B$3","v":"MW Rating"}]
["Conductors",1,0,null,4500,{"$f":"'Scaling Factors'!$K$3","v":0.66666666666666663},3000,{"$f":"'Scaling Factors'!$L$3","v":0.41666666666666669},1875,{"$f":"'Scaling Factors'!$M$3","v":0.625},2812.5,{"$f":"'Scaling Factors'!$N$3","v":0.625},2812.5,{"$f":"'Scaling Factors'!$O$3","v":0.83333333333333337},3750,{"$f":"'Scaling Factors'!$B$3","v":"MW Rating"}]
["Cabinet",1,0,null,2500,{"$f":"'Scaling Factors'!$K$3","v":0.66666666666666663},1666.6666666666665,{"$f":"'Scaling Factors'!$L$3","v":0.41666666666666669},1041.6666666666667,{"$f":"'Scaling Factors'!$M$3","v":0.625},1562.5,{"$f":"'Scaling Factors'!$N$3","v":0.625},1562.5,{"$f":"'Scaling Factors'!$O$3","v":0.83333333333333337},2083.3333333333335,{"$f":"'Scaling Factors'!$B$3","v":"MW Rating"}]
["Solid State Relays",1,0,null,1500,{"$f":"'Scaling Factors'!$K$3","v":0.66666666666666663},1000,{"$f":"'Scaling Factors'!$L$3","v":0.41666666666666669},625,{"$f":"'Scaling Factors'!$M$3","v":0.625},937.5,{"$f":"'Scaling Factors'!$N$3","v":0.625},937.5,{"$f":"'Scaling Factors'!$O$3","v":0.83333333333333337},1250,{"$f":"'Scaling Factors'!$B$3","v":"MW Rating"}]
["PLC - Not Sure About The Cost",1,0,null,3000,{"$f":"'Scaling Factors'!$K$3","v":0.66666666666666663},2000,{"$f":"'Scaling Factors'!$L$3","v":0.41666666666666669},1250,{"$f":"'Scaling Factors'!$M$3","v":0.625},1875,{"$f":"'Scaling Factors'!$N$3","v":0.625},1875,{"$f":"'Scaling Factors'!$O$3","v":0.83333333333333337},2500,{"$f":"'Scaling Factors'!$B$3","v":"MW Rating"}]
["Transformer",1,4767,null,20000,{"$f":"'Scaling Factors'!$K$3","v":0.66666666666666663},13333.333333333332,{"$f":"'Scaling Factors'!$L$3","v":0.41666666666666669},8333.3333333333339,{"$f":"'Scaling Factors'!$M$3","v":0.625},12500,{"$f":"'Scaling Factors'!$N$3","v":0.625},12500,{"$f":"'Scaling Factors'!$O$3","v":0.83333333333333337},16666.666666666668,{"$f":"'Scaling Factors'!$B$3","v":"MW Rating"}]
["Monitoring/Controls",1,{"$f":"SUMPRODUCT($B$67:$B$77,C67:C77)","v":0},null,0,null,{"$f":"SUMPRODUCT($B$67:$B$77,G67:G77)","v":0},null,{"$f":"SUMPRODUCT($B$67:$B$77,I67:I77)","v":0},null,{"$f":"SUMPRODUCT($B$67:$B$77,K67:K77)","v":0},null,{"$f":"SUMPRODUCT($B$67:$B$77,M67:M77)","v":0},null,{"$f":"SUMPRODUCT($B$67:$B$77,O67:O77)","v":0}]
["Pressure Sensors",1]
["Brake Release",1]
["Accumulator Precharge",1]
["System Pressure",1]
["Charge Pump Pressure",1]
["Filter Pressure Differential",1]
[]
["Temperature",1]
["Hydraulic Oil Reservoir",1]
["Hydraulic Oil Return",1]
[null,1]

{"sheet":"Mooring Cost","index":5,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
["System Rating","kW",2400,1770,1114,1500,1500,2000]
["Rotor Diameter","m",{"$f":"'Scaling Factors'!D4","v":45.5},{"$f":"'Scaling Factors'!E4","v":35.078706289552613},{"$f":"'Scaling Factors'!F4","v":27.841987613041795},{"$f":"'Scaling Factors'!G4","v":34.9},{"$f":"'Scaling Factors'!H4","v":34.9},{"$f":"'Scaling Factors'!I4","v":32.299999999999997}]
["Mooring Cost","$",750600,{"$f":"1.15*$C$4*D3/$C$3","v":665485.46114459157},{"$f":"1.15*$C$4*E3/$C$3","v":528196.16016926465},{"$f":"1.15*$C$4*F3/$C$3","v":662095.18681318674},{"$f":"1.15*$C$4*G3/$C$3","v":662095.18681318674},{"$f":"G4","v":662095.18681318674}]

{"sheet":"Grid Connection - MW Scale","index":6,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
["System Rating","kW",2350,1600,1000,750,500,350]
["Low Grid Connect Cost","$",{"$f":"E37","v":1177505.5813953488},{"$f":"F37","v":872231.67173252278},628498.72340425535,832065.99555414414,832065.99555414414,1037817.4468085107]
[]
["Scaled Costs, Inter array cables scale on MW Rating"]
["Electrical Collection and Transmission Systems for Offshore Wind Power - NREL 2007"]
["T&D Costs"]
["Designation",null,"500 MW (3 MW)","Per 3MW ",{"$f":"$C$2","v":2350},{"$f":"$D$2","v":1600},{"$f":"$E$2","v":1000},1500,1500,2000,"Comments"]
["Number of Turbines",null,167,{"$f":"500/3","v":166.66666666666666},43,63,100,67,67,50,"Assume Max 50"]
["Total Site Rating",null,500,500,100,100,100,100,100,{"$f":"J8*J9/1000","v":100}]
["Inter-array cable cost:                                                    ",null,103000000,{"$f":"C11/$D$9","v":618000},{"$f":"$D11*E$9","v":26574000},{"$f":"$D11*F$9*F$8/$E$8","v":26508255.319148935},{"$f":"$D11*G$9*G$8/$E$8","v":26297872.340425532},{"$f":"$D11*H$9*H$8/$E$8","v":26429361.702127658},{"$f":"$D11*I$9*I$8/$E$8","v":26429361.702127658},{"$f":"$D11*J$9*J$8/$E$8","v":26297872.340425532},"Scales on MW Rating"]
["Inter-array cable shipping and installation:           ",null,36530000,219180,{"$f":"$D12*E$9","v":9424740},{"$f":"$D12*F$9","v":13808340},{"$f":"$D12*G$9","v":21918000},{"$f":"$D12*H$9","v":14685060},{"$f":"$D12*I$9","v":14685060},{"$f":"$D12*J$9","v":10959000}]
["Transmission cable cost:                                               ",null,36340000,218040,{"$f":"$C13*E$10/500","v":7268000},7268000,7268000,7268000,7268000,7268000,"Scales on Farm Size"]
["Transmission cable shipping and installation:       ",null,6830000,40980,1366000,{"$f":"E14","v":1366000},{"$f":"F14","v":1366000},1366000,1366000,1366000]
[null,null,null,0]
["Turbine transformer",null,8430000,50580]
["Offshore Substation w/Transformer",null,40520000,243120,{"$f":"10000000/10","v":1000000},{"$f":"$E17*F$10/$E$10","v":1000000},{"$f":"$E17*G$10/$E$10","v":1000000},{"$f":"$E17*H$10/$E$10","v":1000000},1000000,1000000,"No OS Sub Station estimated JB and other "]
["Onshore Transmission & Substation",null,29370000,176220,5000000,{"$f":"E18","v":5000000},{"$f":"F18","v":5000000},{"$f":"G18*0.9","v":4500000},4000000,3750000,"estimated"]
["Cost Per Farm",null,null,null,{"$f":"SUM(E11:E18)","v":50632740},54950595.319148935,62849872.340425536,55248421.702127658,54748421.702127658,50640872.340425536]
["Cost Per C-Plane",null,null,null,{"$f":"E19/E9","v":1177505.5813953488},872231.67173252278,628498.72340425535,824603.30898698,817140.62241981574,1012817.4468085107]
["(These values were based on a 500MW farm 15km from shore)"]
[]
["High Costs, Inter array cables do not scale on MW Rating"]
["T&D Costs"]
["Designation",null,"500 MW (3 MW)","Per 3MW ",{"$f":"$C$2","v":2350},{"$f":"$D$2","v":1600},{"$f":"$E$2","v":1000},1500,1500,2000]
["Number of Turbines",null,167,{"$f":"500/3","v":166.66666666666666},43,63,100,67,67,50]
["Total Site Rating",null,500,500,100,100,{"$f":"G25*G26/1000","v":100},100,100,{"$f":"J25*J26/1000","v":100}]
["Inter-array cable cost:                                                    ",null,103000000,{"$f":"C28/$D$9","v":618000},{"$f":"$D28*E$26*E$25/$E$8","v":26574000},26508255.319148935,26297872.340425532,26429361.702127658,26429361.702127658,{"$f":"$D28*J$26*J$25/$E$8","v":26297872.340425532},"Scales on MW Rating"]
["Inter-array cable shipping and installation:           ",null,36530000,219180,{"$f":"$D29*E$26","v":9424740},{"$f":"$D29*F$26","v":13808340},21918000,14685060,14685060,10959000]
["Transmission cable cost:                                               ",null,36340000,218040,{"$f":"$C30*E$27/500","v":7268000},7268000,7268000,7268000,7268000,{"$f":"$C30*J$27/500","v":7268000},"Scales on Farm Size"]
["Transmission cable shipping and installation:       ",null,6830000,40980,{"$f":"$C31*E$10/500","v":1366000},{"$f":"E31","v":1366000},{"$f":"F31","v":1366000},{"$f":"G31","v":1366000},{"$f":"H31","v":1366000},{"$f":"I31","v":1366000}]
[null,null,null,0]
["Turbine transformer",null,8430000,50580]
["Offshore Substation w/Transformer",null,40520000,243120,{"$f":"10000000/10","v":1000000},{"$f":"$E34*F$27/$E$27","v":1000000},{"$f":"$E34*G$27/$E$27","v":1000000},1000000,1000000,1000000,"No OS Sub Station estimated JB and other "]
["Onshore Transmission & Substation",null,29370000,176220,5000000,{"$f":"E35","v":5000000},{"$f":"F35","v":5000000},{"$f":"G35","v":5000000},5000000,5000000,"estimated"]
["Cost Per Farm",null,{"$f":"SUM(C28:C35)","v":261020000},{"$f":"SUM(D28:D35)","v":1566120},{"$f":"SUM(E28:E35)","v":50632740},54950595.319148935,62849872.340425536,55748421.702127658,55748421.702127658,51890872.340425536]
["Cost Per C-Plane",null,null,null,{"$f":"E36/E26","v":1177505.5813953488},872231.67173252278,628498.72340425535,832065.99555414414,832065.99555414414,1037817.4468085107]
["(These values were based on a 500MW farm 15km from shore)"]

{"sheet":"Failure Costs","index":7,"n_rows":43,"n_cols":25,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,2,0,4]]}
["Component",null,"Failure Rate (months per failure)",null,null,null,null,2400,"Component Cost","Total Repair Cost",1600,null,null,1000,null,null,750,null,null,500,null,null,350]
[null,"Ship Cost","Min","Mean","Max","Years to Min Failure","% Fail by Min",43,null,null,67,null,null,100,null,null,134,null,null,200,null,null,267]
["Blades",{"$f":"950000","v":950000},120,240,480,{"$f":"C3/12","v":10},0.05,{"$f":"$G3*H$2/$F3","v":0.215},{"$f":"B20","v":783592},{"$f":"I3+$B3","v":1733592},{"$f":"$G3*K$2/$F3","v":0.33500000000000002},{"$f":"C20","v":442882.28},{"$f":"L3+$B3","v":1392882.28},{"$f":"$G3*N$2/$F3","v":0.5},{"$f":"D20","v":229876.36},{"$f":"O3+$B3","v":1179876.3599999999},{"$f":"$G3*Q$2/$F3","v":0.67},{"$f":"E20","v":415103.96},{"$f":"R3+$B3","v":1365103.96},{"$f":"$G3*T$2/$F3","v":1},{"$f":"F20","v":415103.96},{"$f":"U3+$B3","v":1365103.96},{"$f":"$G3*W$2/$F3","v":1.3350000000000002},{"$f":"G20","v":708231.12000000011},{"$f":"X3+$B3","v":1658231.12}]
["Rotor Hubs",{"$f":"950000","v":950000},240,480,960,{"$f":"C4/12","v":20},0.05,0.1075,{"$f":"B20","v":783592},{"$f":"I4+$B4","v":1733592},0.16750000000000001,{"$f":"C20","v":442882.28},{"$f":"L4+$B4","v":1392882.28},0.25,{"$f":"D20","v":229876.36},{"$f":"O4+$B4","v":1179876.3599999999},0.33500000000000002,{"$f":"E20","v":415103.96},{"$f":"R4+$B4","v":1365103.96},0.5,{"$f":"F20","v":415103.96},{"$f":"U4+$B4","v":1365103.96},0.66750000000000009,{"$f":"G20","v":708231.12000000011},{"$f":"X4+$B4","v":1658231.12}]
["Nacelle",950000,240,480,960,20,0.05,0.1075,{"$f":"B21","v":2950468.1978564812},3900468.1978564812,0.16750000000000001,{"$f":"C21","v":2170423.3276974363},3120423.3276974363,0.25,{"$f":"D21","v":1262774.6384415664},2212774.6384415664,0.33500000000000002,{"$f":"E21","v":1656446.1421593891},2606446.1421593893,0.5,{"$f":"F21","v":1656446.1421593891},2606446.1421593893,0.66750000000000009,{"$f":"G21","v":2024190.738056825},2974190.738056825]
["Main Wing and Faring",950000,240,480,960,20,0.05,0.1075,{"$f":"B22","v":874500},1824500,0.16750000000000001,{"$f":"C22","v":519785.49583994038},1469785.4958399404,0.25,{"$f":"D22","v":327444.34335324424},1277444.3433532442,0.33500000000000002,{"$f":"E22","v":514502.95616471441},1464502.9561647144,0.5,{"$f":"F22","v":514502.95616471441},1464502.9561647144,0.66750000000000009,{"$f":"G22","v":440699.00012075831},1390699.0001207583]
["Pump",950000,60,120,240,5,0.05,0.43,{"$f":"B23","v":1014525.5415384615},1964525.5415384616,0.67,{"$f":"C23","v":864556.31076923071},1814556.3107692306,1,{"$f":"D23","v":471806.46307692304},1421806.463076923,1.34,{"$f":"E23","v":518298.77076923073},1468298.7707692308,2,{"$f":"F23","v":518298.77076923073},1468298.7707692308,2.6700000000000004,{"$f":"G23","v":569249.54},1519249.54]
["Electrical",950000,60,120,240,5,0.05,0.43,{"$f":"B24","v":113600},1063600,0.67,{"$f":"C24","v":75733.333333333328},1025733.3333333334,1,{"$f":"D24","v":47333.333333333328},997333.33333333337,1.34,{"$f":"E24","v":71000},1021000,2,{"$f":"F24","v":71000},1021000,2.6700000000000004,{"$f":"G24","v":94666.666666666657},1044666.6666666666]
["Seals",950000,60,120,240,5,0.05,0.43,{"$f":"B21","v":2950468.1978564812},3900468.1978564812,0.67,{"$f":"C21","v":2170423.3276974363},3120423.3276974363,1,{"$f":"D21","v":1262774.6384415664},2212774.6384415664,1.34,{"$f":"E21","v":1656446.1421593891},2606446.1421593893,2,{"$f":"F21","v":1656446.1421593891},2606446.1421593893,2.6700000000000004,{"$f":"G21","v":2024190.738056825},2974190.738056825]
["Generator",950000,60,120,240,5,0.05,0.43,{"$f":"B24","v":113600},1063600,0.67,{"$f":"C24","v":75733.333333333328},1025733.3333333334,1,{"$f":"D24","v":47333.333333333328},997333.33333333337,1.34,{"$f":"E24","v":71000},1021000,2,{"$f":"F24","v":71000},1021000,2.6700000000000004,{"$f":"G24","v":94666.666666666657},1044666.6666666666]
["Hydraulic System",950000,60,120,240,5,0.05,0.43,{"$f":"B23","v":1014525.5415384615},1964525.5415384616,0.67,{"$f":"C23","v":864556.31076923071},1814556.3107692306,1,{"$f":"D23","v":471806.46307692304},1421806.463076923,1.34,{"$f":"E23","v":518298.77076923073},1468298.7707692308,2,{"$f":"F23","v":518298.77076923073},1468298.7707692308,2.6700000000000004,{"$f":"G23","v":569249.54},1519249.54]
["Bearings",950000,60,120,240,5,0.05,0.43,{"$f":"B25","v":589395.38249902427},1539395.3824990243,0.67,{"$f":"C25","v":337896.12977587694},1287896.1297758769,1,{"$f":"D25","v":219486.81972082052},1169486.8197208205,1.34,{"$f":"E25","v":357771.74907966889},1307771.7490796689,2,{"$f":"F25","v":357771.74907966889},1307771.7490796689,2.6700000000000004,{"$f":"G25","v":357771.74907966889},1307771.7490796689]
["Mooring Lines & Attachments",950000,240,480,960,20,0.05,0.1075,{"$f":"B43","v":750600},1700600,0.16750000000000001,{"$f":"C43","v":665485.46114459157},1615485.4611445917,0.25,{"$f":"D43","v":528196.16016926465},1478196.1601692648,0.33500000000000002,{"$f":"E43","v":662095.18681318674},1612095.1868131869,0.5,{"$f":"F43","v":662095.18681318674},1612095.1868131869,0.66750000000000009,{"$f":"G43","v":662095.18681318674},1612095.1868131869]
["Grid Connect",950000,240,480,960,20,0.05,0.1075,{"$f":"B42","v":1177505.5813953488},2127505.5813953485,0.16750000000000001,{"$f":"C42","v":872231.67173252278},1822231.6717325228,0.25,{"$f":"D42","v":628498.72340425535},1578498.7234042552,0.33500000000000002,{"$f":"E42","v":832065.99555414414},1782065.995554144,0.5,{"$f":"F42","v":832065.99555414414},1782065.995554144,0.66750000000000009,{"$f":"G42","v":1037817.4468085107},1987817.4468085107]
[null,null,null,null,null,null,null,{"$f":"SUM(H3:H14)","v":3.3325},null,null,{"$f":"SUM(K3:K14)","v":5.1925000000000008},null,null,{"$f":"SUM(N3:N14)","v":7.75},null,null,{"$f":"SUM(Q3:Q14)","v":10.385000000000002},null,null,{"$f":"SUM(T3:T14)","v":15.5},null,null,{"$f":"SUM(W3:W14)","v":20.692500000000003}]
[null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(J3:J14,H3:H14)/H$2","v":151845.77108245384},null,null,{"$f":"SUMPRODUCT(M3:M14,K3:K14)/K$2","v":131405.41944782063},null,null,{"$f":"SUMPRODUCT(P3:P14,N3:N14)/N$2","v":107421.76787324982},null,null,{"$f":"SUMPRODUCT(S3:S14,Q3:Q14)/Q$2","v":117829.20972950378},null,null,{"$f":"SUMPRODUCT(V3:V14,T3:T14)/T$2","v":117829.20972950378},null,null,{"$f":"SUMPRODUCT(Y3:Y14,W3:W14)/W$2","v":126446.68833419647}]
[]
[{"$f":"'Scaling Summary'!A1","v":"C-Plane - 2400 kW"},{"$f":"'Scaling Summary'!C1","v":"2400 Cost"},{"$f":"'Scaling Summary'!D1","v":"1600 Cost"},{"$f":"'Scaling Summary'!E1","v":"1000 Cost"},{"$f":"'Scaling Summary'!F1","v":"1500 PPDC"},{"$f":"'Scaling Summary'!G1","v":"1500 APDC"},{"$f":"'Scaling Summary'!H1","v":"2000 APDC"}]
[{"$f":"'Scaling Summary'!A7","v":"Blade "},{"$f":"'Scaling Summary'!C7","v":278496},{"$f":"'Scaling Summary'!D7","v":145205.64000000001},{"$f":"'Scaling Summary'!E7","v":71185.679999999993},{"$f":"'Scaling Summary'!F7","v":131316.48000000001},{"$f":"'Scaling Summary'!G7","v":131316.48000000001},{"$f":"'Scaling Summary'!H7","v":262632.96000000002}]
[{"$f":"'Scaling Summary'!A6","v":"Rotor"},{"$f":"'Scaling Summary'!C6","v":783592},{"$f":"'Scaling Summary'!D6","v":442882.28},{"$f":"'Scaling Summary'!E6","v":229876.36},{"$f":"'Scaling Summary'!F6","v":415103.96},{"$f":"'Scaling Summary'!G6","v":415103.96},{"$f":"'Scaling Summary'!H6","v":708231.12000000011}]
["Pod Total",{"$f":"(B27-B22)/2","v":2950468.1978564812},{"$f":"(C27-C22)/2","v":2170423.3276974363},1262774.6384415664,1656446.1421593891,1656446.1421593891,2024190.738056825]
[{"$f":"'Scaling Summary'!A4","v":"Truss"},{"$f":"'Scaling Summary'!C4","v":874500},{"$f":"'Scaling Summary'!D4","v":519785.49583994038},{"$f":"'Scaling Summary'!E4","v":327444.34335324424},{"$f":"'Scaling Summary'!F4","v":514502.95616471441},{"$f":"'Scaling Summary'!G4","v":514502.95616471441},{"$f":"'Scaling Summary'!H4","v":440699.00012075831}]
[{"$f":"'Scaling Summary'!A11","v":"Hydraulics Package"},{"$f":"'Scaling Summary'!C11","v":1014525.5415384615},{"$f":"'Scaling Summary'!D11","v":864556.31076923071},{"$f":"'Scaling Summary'!E11","v":471806.46307692304},{"$f":"'Scaling Summary'!F11","v":518298.77076923073},{"$f":"'Scaling Summary'!G11","v":518298.77076923073},{"$f":"'Scaling Summary'!H11","v":569249.54}]
[{"$f":"'Scaling Summary'!A19","v":"Electrical System"},{"$f":"'Scaling Summary'!C19","v":113600},{"$f":"'Scaling Summary'!D19","v":75733.333333333328},{"$f":"'Scaling Summary'!E19","v":47333.333333333328},{"$f":"'Scaling Summary'!F19","v":71000},{"$f":"'Scaling Summary'!G19","v":71000},{"$f":"'Scaling Summary'!H19","v":94666.666666666657}]
[{"$f":"'Scaling Summary'!A18","v":"Bearings & Seals Package"},{"$f":"'Scaling Summary'!C18","v":589395.38249902427},{"$f":"'Scaling Summary'!D18","v":337896.12977587694},{"$f":"'Scaling Summary'!E18","v":219486.81972082052},{"$f":"'Scaling Summary'!F18","v":357771.74907966889},{"$f":"'Scaling Summary'!G18","v":357771.74907966889},{"$f":"'Scaling Summary'!H18","v":357771.74907966889}]
[]
[{"$f":"'Scaling Summary'!A3","v":"System Total"},{"$f":"'Scaling Summary'!C3","v":6775436.3957129624},{"$f":"'Scaling Summary'!D3","v":4860632.151234813},{"$f":"'Scaling Summary'!E3","v":2852993.6202363768},{"$f":"'Scaling Summary'!F3","v":3827395.2404834926},{"$f":"'Scaling Summary'!G3","v":3827395.2404834926},{"$f":"'Scaling Summary'!H3","v":4489080.4762344081}]
[{"$f":"'Scaling Summary'!A5","v":"Nacelle Structure"},{"$f":"'Scaling Summary'!C5","v":314178.27381899511},{"$f":"'Scaling Summary'!D5","v":314178.27381899511},{"$f":"'Scaling Summary'!E5","v":205747.58612001312},{"$f":"'Scaling Summary'!F5","v":205747.58612001312},{"$f":"'Scaling Summary'!G5","v":205747.58612001312},{"$f":"'Scaling Summary'!H5","v":205747.58612001312}]
[{"$f":"'Scaling Summary'!A8","v":"Rotor Hub"},{"$f":"'Scaling Summary'!C8","v":226600},{"$f":"'Scaling Summary'!D8","v":152471},{"$f":"'Scaling Summary'!E8","v":87505},{"$f":"'Scaling Summary'!F8","v":152471},{"$f":"'Scaling Summary'!G8","v":152471},{"$f":"'Scaling Summary'!H8","v":182965.2}]
[{"$f":"'Scaling Summary'!A9","v":"Tail Cone"},{"$f":"'Scaling Summary'!C9","v":135177},{"$f":"'Scaling Summary'!D9","v":135177},{"$f":"'Scaling Summary'!E9","v":88524.076190476189},{"$f":"'Scaling Summary'!F9","v":88524.076190476189},{"$f":"'Scaling Summary'!G9","v":88524.076190476189},{"$f":"'Scaling Summary'!H9","v":88524.076190476189}]
[{"$f":"'Scaling Summary'!A10","v":"Drive Train (Internals)"},{"$f":"'Scaling Summary'!C10","v":1717520.9240374858},{"$f":"'Scaling Summary'!D10","v":1278185.773878441},{"$f":"'Scaling Summary'!E10","v":738626.61613107694},{"$f":"'Scaling Summary'!F10","v":947070.51984889968},{"$f":"'Scaling Summary'!G10","v":947070.51984889968},{"$f":"'Scaling Summary'!H10","v":1021687.9557463356}]
[{"$f":"'Scaling Summary'!A12","v":"Low Speed Pump - CBM 6000"},{"$f":"'Scaling Summary'!C12","v":309400},{"$f":"'Scaling Summary'!D12","v":309400},{"$f":"'Scaling Summary'!E12","v":154700},{"$f":"'Scaling Summary'!F12","v":154700},{"$f":"'Scaling Summary'!G12","v":154700},{"$f":"'Scaling Summary'!H12","v":154700}]
[{"$f":"'Scaling Summary'!A13","v":"High Speed Variable Pump - A4VS 1000"},{"$f":"'Scaling Summary'!C13","v":96800},{"$f":"'Scaling Summary'!D13","v":51200},{"$f":"'Scaling Summary'!E13","v":36800},{"$f":"'Scaling Summary'!F13","v":51200},{"$f":"'Scaling Summary'!G13","v":51200},{"$f":"'Scaling Summary'!H13","v":66560}]
[{"$f":"'Scaling Summary'!A14","v":"High Speed Fixed Pump - A4FM 1000"},{"$f":"'Scaling Summary'!C14","v":50769.230769230773},{"$f":"'Scaling Summary'!D14","v":25384.615384615387},{"$f":"'Scaling Summary'!E14","v":19038.461538461539},{"$f":"'Scaling Summary'!F14","v":25384.615384615387},{"$f":"'Scaling Summary'!G14","v":25384.615384615387},{"$f":"'Scaling Summary'!H14","v":33000.000000000007}]
[{"$f":"'Scaling Summary'!A15","v":"Charge Pump - A11/190"},{"$f":"'Scaling Summary'!C15","v":2650},{"$f":"'Scaling Summary'!D15","v":2650},{"$f":"'Scaling Summary'!E15","v":2650},{"$f":"'Scaling Summary'!F15","v":2650},{"$f":"'Scaling Summary'!G15","v":2650},{"$f":"'Scaling Summary'!H15","v":2650}]
[{"$f":"'Scaling Summary'!A16","v":"Hex - Heat Exchanger"},{"$f":"'Scaling Summary'!C16","v":24000},{"$f":"'Scaling Summary'!D16","v":16000},{"$f":"'Scaling Summary'!E16","v":10000},{"$f":"'Scaling Summary'!F16","v":15000},{"$f":"'Scaling Summary'!G16","v":15000},{"$f":"'Scaling Summary'!H16","v":20000}]
[{"$f":"'Scaling Summary'!A17","v":"Balance of Hydraulic System"},{"$f":"'Scaling Summary'!C17","v":65000},{"$f":"'Scaling Summary'!D17","v":65000},{"$f":"'Scaling Summary'!E17","v":32500},{"$f":"'Scaling Summary'!F17","v":32500},{"$f":"'Scaling Summary'!G17","v":32500},{"$f":"'Scaling Summary'!H17","v":32500}]
[{"$f":"'Scaling Summary'!A20","v":"Monitoring/Controls"},{"$f":"'Scaling Summary'!C20","v":0},{"$f":"'Scaling Summary'!D20","v":0},{"$f":"'Scaling Summary'!E20","v":0},{"$f":"'Scaling Summary'!F20","v":0},{"$f":"'Scaling Summary'!G20","v":0},{"$f":"'Scaling Summary'!H20","v":0}]
[{"$f":"'Scaling Summary'!A21","v":0},{"$f":"'Scaling Summary'!C21","v":0},{"$f":"'Scaling Summary'!D21","v":0},{"$f":"'Scaling Summary'!E21","v":0},{"$f":"'Scaling Summary'!F21","v":0},{"$f":"'Scaling Summary'!G21","v":0},{"$f":"'Scaling Summary'!H21","v":0}]
[{"$f":"'Scaling Summary'!A22","v":"Additional CAPEX"},{"$f":"'Scaling Summary'!C22","v":0},{"$f":"'Scaling Summary'!D22","v":0},{"$f":"'Scaling Summary'!E22","v":0},{"$f":"'Scaling Summary'!F22","v":0},{"$f":"'Scaling Summary'!G22","v":0},{"$f":"'Scaling Summary'!H22","v":0}]
[{"$f":"'Scaling Summary'!A23","v":"Installation"},{"$f":"'Scaling Summary'!C23","v":1325516.0058321599},{"$f":"'Scaling Summary'!D23","v":1218110.9726411058},{"$f":"'Scaling Summary'!E23","v":888449.68101181882},{"$f":"'Scaling Summary'!F23","v":1164951.8515764135},{"$f":"'Scaling Summary'!G23","v":1164951.8515764135},{"$f":"'Scaling Summary'!H23","v":1206054.0238117203}]
[{"$f":"'Scaling Summary'!A24","v":"Grid Connection"},{"$f":"'Scaling Summary'!C24","v":1177505.5813953488},{"$f":"'Scaling Summary'!D24","v":872231.67173252278},{"$f":"'Scaling Summary'!E24","v":628498.72340425535},{"$f":"'Scaling Summary'!F24","v":832065.99555414414},{"$f":"'Scaling Summary'!G24","v":832065.99555414414},{"$f":"'Scaling Summary'!H24","v":1037817.4468085107}]
[{"$f":"'Scaling Summary'!A25","v":"Mooring"},{"$f":"'Scaling Summary'!C25","v":750600},{"$f":"'Scaling Summary'!D25","v":665485.46114459157},{"$f":"'Scaling Summary'!E25","v":528196.16016926465},{"$f":"'Scaling Summary'!F25","v":662095.18681318674},{"$f":"'Scaling Summary'!G25","v":662095.18681318674},{"$f":"'Scaling Summary'!H25","v":662095.18681318674}]

{"sheet":"Install, Asm, O&M","index":8,"n_rows":48,"n_cols":10,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Installation cost"]
["The current estimation of installation cost is a fixed percentage of the CAPEX for the drivetrain and platform."]
[null,null,2350,1600,1000,1500,1500,2000]
["Mob & Demob [$]",null,1580000,1580000,1580000,1580000,1580000,1580000]
["Number of C-Planes, #",null,{"$f":"ROUND(100/(C3/1000), 0)","v":43},63,100,67,67,50]
["Installation of C-Planes and anchors [$]",null,950000,950000,730000,950000,950000,950000]
["Total Installation cost ($/farm)",null,{"$f":"C4+C6*C5","v":42430000},61430000,74580000,65230000,65230000,49080000]
[]
["Installation cost ($/C-Plane):",null,{"$f":"C7/C5","v":986744.18604651163},975079.36507936509,745800,973582.08955223882,973582.08955223882,981600]
[]
["Assembly cost"]
["The current estimation of installation cost is a fixed percentage of the CAPEX for the drivetrain and platform."]
[null,null,{"$f":"C$3","v":2350},{"$f":"D$3","v":1600},1000,1500,1500,2000]
["Cost of Platform and Drivetrain",null,{"$f":"'BOM Cost'!E3","v":6775436.3957129624},{"$f":"'BOM Cost'!G3","v":4860632.151234813},{"$f":"'BOM Cost'!I3","v":2852993.6202363768},{"$f":"'BOM Cost'!K3","v":3827395.2404834926},{"$f":"'BOM Cost'!M3","v":3827395.2404834926},{"$f":"'BOM Cost'!O3","v":4489080.4762344081}]
["Assembly % of Cost",null,0.05,0.05,0.05,0.05,0.05,0.05]
["Assembly cost ($/C-Plane):",null,{"$f":"C14*C15","v":338771.81978564814},243031.60756174068,142649.68101181884,191369.76202417465,191369.76202417465,224454.02381172043]
[]
["5 year Maintenance"]
["The current estimation of installation cost is a fixed percentage of the CAPEX for the drivetrain and platform."]
[null,null,{"$f":"C$3","v":2350},{"$f":"D$3","v":1600},1000,1500,1500,2000,"Comments"]
["Number of C-Planes, #",null,{"$f":"C5","v":43},63,100,67,67,50]
["Installation cost ($/C-Plane):",null,950000,950000,730000,950000,950000,950000,"From Install Cost"]
["Mooring Refurbisment",null,{"$f":"'Mooring Cost'!C4*0.2","v":150120},{"$f":"'Mooring Cost'!D4*0.2","v":133097.09222891831},{"$f":"'Mooring Cost'!E4*0.2","v":105639.23203385294},{"$f":"'Mooring Cost'!F4*0.2","v":132419.03736263735},{"$f":"'Mooring Cost'!G4*0.2","v":132419.03736263735},{"$f":"'Mooring Cost'!H4*0.2","v":132419.03736263735},"20% Mooring Cost"]
["Parts Refurbisment"]
["Hydraulic System Overhaul (seals, etc.)",null,{"$f":"0.2*2*SUM('BOM Cost'!E27,'BOM Cost'!E31,'BOM Cost'!E32)","v":182787.69230769231},{"$f":"0.2*(2*SUM('BOM Cost'!G27,'BOM Cost'!G31,'BOM Cost'!G32))","v":154393.84615384616},{"$f":"0.2*(2*SUM('BOM Cost'!I27,'BOM Cost'!I31,'BOM Cost'!I32))","v":84215.384615384624},{"$f":"0.2*(2*SUM('BOM Cost'!K27,'BOM Cost'!K31,'BOM Cost'!K32))","v":92513.846153846156},{"$f":"0.2*(2*SUM('BOM Cost'!M27,'BOM Cost'!M31,'BOM Cost'!M32))","v":92513.846153846156},{"$f":"0.2*(2*SUM('BOM Cost'!O27,'BOM Cost'!O31,'BOM Cost'!O32))","v":101704},"20% Pump Cost"]
["Hydraulic Oil and Filters",null,{"$f":"0.2*SUM('BOM Cost'!E36)","v":13000},{"$f":"0.2*SUM('BOM Cost'!G36)","v":13000},{"$f":"0.2*SUM('BOM Cost'!I36)","v":6500},{"$f":"0.2*SUM('BOM Cost'!K36)","v":6500},{"$f":"0.2*SUM('BOM Cost'!M36)","v":6500},{"$f":"0.2*SUM('BOM Cost'!O36)","v":6500},"BOM Cost"]
["Cleaning and Painting",null,{"$f":"10000+(5*3*8*80)","v":19600},{"$f":"C27*'Scaling Factors'!K22","v":19600},{"$f":"D27*'Scaling Factors'!L22","v":15680},{"$f":"D27*'Scaling Factors'!M22","v":15680},{"$f":"F27*'Scaling Factors'!N22","v":12544},{"$f":"G27*'Scaling Factors'!O22","v":10035.200000000001},"Estimated and Scaled on Nacelle Volume"]
["Dissassebly and Reassembly",null,{"$f":"C16","v":338771.81978564814},243031.60756174068,142649.68101181884,191369.76202417465,191369.76202417465,224454.02381172043,"Assembly Cost"]
["Misc Parts Replacement (5%)",null,{"$f":"C14*0.05","v":338771.81978564814},243031.60756174068,142649.68101181884,191369.76202417465,191369.76202417465,224454.02381172043,"Misc 5% of BOM Parts Replacement"]
[]
["5yr Overhaul Total Cost",null,{"$f":"SUM(C22:C29)","v":1993051.3318789885},1756154.1535062459,1227333.9786728753,1579852.4075648331,1576716.4075648331,1649566.2849860783,"Occurs every 5 years"]
["Yearly Cost",null,{"$f":"C31/5","v":398610.26637579768},351230.83070124919,245466.79573457508,315970.48151296662,315343.28151296661,329913.25699721568,"Divide by 5"]
["Tax Adjusted Cost",null,{"$f":"C32*$J$33","v":239166.15982547859},{"$f":"D32*$J$33","v":210738.4984207495},147280.07744074505,189582.28890777996,189205.96890777996,197947.95419832939,"40% Tax Rate",0.6]
[]
["Failure cost"]
["The current estimation of installation cost is a fixed percentage of the CAPEX for the drivetrain and platform."]
[null,null,{"$f":"C$3","v":2350},{"$f":"D$3","v":1600},1000,1500,1500,2000]
["Remove and Replace [$]",null,950000,950000,950000,950000,950000,950000,"2 days all ships to remove and install"]
["Yearly Failure Rate",null,5.8552457658470662E-2,{"$f":"$C$39","v":5.8552457658470662E-2},{"$f":"$C$39","v":5.8552457658470662E-2},5.8552457658470662E-2,5.8552457658470662E-2,5.8552457658470662E-2,"Constant failure rate"]
["Number of Failures per year, #/yr",null,{"$f":"C39*C21","v":2.5177556793142384},3.6888048324836515,5.8552457658470658,3.9230146631175344,3.9230146631175344,2.9276228829235329,"Failure rate * units per farm"]
["Average Cost of Failure",null,{"$f":"J41*('BOM Cost'!E8+'BOM Cost'!E18+'BOM Cost'!E22+'BOM Cost'!E25)","v":1475234.0989282406},{"$f":"J41*('BOM Cost'!G8+'BOM Cost'!G18+'BOM Cost'!G22+'BOM Cost'!G25)","v":1085211.6638487182},{"$f":"J41*('BOM Cost'!I8+'BOM Cost'!I18+'BOM Cost'!I22+'BOM Cost'!I25)","v":631387.31922078319},{"$f":"J41*('BOM Cost'!K8+'BOM Cost'!K18+'BOM Cost'!K22+'BOM Cost'!K25)","v":828223.07107969443},{"$f":"J41*('BOM Cost'!M8+'BOM Cost'!M18+'BOM Cost'!M22+'BOM Cost'!M25)","v":828223.07107969443},{"$f":"J41*('BOM Cost'!O8+'BOM Cost'!O18+'BOM Cost'!O22+'BOM Cost'!O25)","v":1012095.3690284125},"1/2 BOM cost of single power pod",0.5]
["Number of days OOS",null,7,7,7,7,7,7]
["Liquidated Damages",null,{"$f":"C42*C37*0.9*24*0.12","v":42638.400000000001},{"$f":"D42*D37*0.9*24*0.12","v":29030.399999999998},18144,27216,27216,36288]
["Total LRC cost ($/farm)",null,{"$f":"C40*(C38+C41+C43)","v":6213499.9999999991},{"$f":"D40*(D38+D41+D43)","v":7614586.1005411772},9365648.9842072614,7082763.9492109418,7082763.9492109418,5850512.8800214035]
[]
["LRC Cost ($/C-Plane/yr):",null,{"$f":"C44/C5","v":144499.99999999997},120866.44604033614,93656.489842072609,105712.89476434242,105712.89476434242,117010.25760042807,"Asssumed 144k baseline to determine failure rate"]
[]
["Total OPEX",null,{"$f":"C33+C46","v":383666.15982547856},331604.94446108566,240936.56728281768,295295.18367212237,294918.86367212236,314958.21179875743]

{"sheet":"7.2 Mooring Installation costs","index":9,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,1,3,1],[0,0,0,5],[1,0,1,5],[2,2,2,5],[22,0,22,1],[9,0,9,1],[11,0,11,1],[4,0,4,1],[17,0,17,1]]}
["AQUANTIS - PRELIMINARY INSTALLATION ESTIMATE - June 22, 2011"]
["The following estimate is for the installation of one C-Plane.  For multiple C-Plane arrays, efficiencies can be expected.  Mobilization of AHTS and Ocean Tugs is assumed from Port Fourchon, LA.  Assumes simultaneous installation of C-Plane and rear Anchors.  Assumes the C-Plane is transported via submersible barge fom Ft. Lauderdale. (Questionable, this assumption may be invalid, as the port facilities in the area typically do not handle operations such as this.)  This is a preliminary estimate and may not reflect all costs associated with the installation of the C-Plane and Anchoring system.  This estimate includes the connection of the powercable to the C-Plane but does not include installation of the power cable and junction box at the sea floor.  ",null,null,null,null,null,"Installation Cost"]
["EQUIPMENT LIST","Quantity or Days","Rent Equipment"]
[null,null,"Cost  (USD)","Unit","Estimated Cost","Estimated Cost"]
["Mobilization ",null,null,null,null,"Utilizing Local Assets, No Mob/Demob"]
["Anchor Handling Tug #1 mobilized from Port Fourchon, LA",3,150000,"day",{"$f":"B6*C6","v":450000}]
["Ocean going tug #1, mobilized from Port Fourchon, LA",3,20000,"day",{"$f":"B7*C7","v":60000}]
["Ocean going tug #2, mobilized at port Fourchon, LA for towing transport Barge (assuming 5 knts speed, 800 nm)",8,20000,"day",{"$f":"B8*C8","v":160000}]
["Semi-Submersible 350 ft Transport/deployment Barge for loadout and installation of C-Plane towed from Port Fourchon, LA (Availabillity and daily rate currently unkown, likely will need delivered from GOM)",8,15000,"day",{"$f":"B9*C9","v":120000}]
["Loadout of Anchors & Travel to site"]
["Anchor Handling Tug arrives at Local Port, Anchors and mooring lines are loaded on to vessel and lashed down for deployement to site",1,150000,"day",{"$f":"B11*C11","v":150000},{"$f":"E11","v":150000}]
["Offshore Installation"]
["AHT #1 travels to site, installs two FWD anchors, conducts pull tests and returns to port for rear anchor",1,150000,"day",{"$f":"B13*C13","v":150000},{"$f":"E13","v":150000}]
["Semi-Submersible Installation of Cplane",2,15000,"day",{"$f":"B14*C14","v":30000},{"$f":"B14*C14","v":30000}]
["Ocean going tug #1 assists in tow out of C-Plane, Ocean going tug #1 assists with lowering of C-Plane / station keeping for transport barge",2,20000,"day",{"$f":"B15*C15","v":40000},{"$f":"E15","v":40000}]
["Ocean going tug #2 assists in tow out of C-Plane ( est. 9 hrs), Ocean going tug #2 assists with lowering of C-Plane / station keeping for transport barge during installation",2,20000,"day",{"$f":"B16*C16","v":40000},{"$f":"E16","v":40000}]
["AHT #1 loads rear anchor, returns to site, deploys anchor and assists in lowering C-Plane",2,150000,"day",{"$f":"B17*C17","v":300000},{"$f":"E17","v":300000}]
["Demobilization "]
["Anchor Handling Tug #1 returns to Port Fourchon, LA",3,150000,"day",{"$f":"B19*C19","v":450000}]
["Ocean going tug #1,returns to Port Fourchon",3,20000,"day",{"$f":"B20*C20","v":60000}]
["Ocean going tug #1, tows submersible barge to Port Fourchon",8,20000,"day",{"$f":"B21*C21","v":160000}]
["Submersible Transport Barge towed to Port Fourchon, LA (Availabillity and daily rate currently unkown)",8,15000,"day",{"$f":"B22*C22","v":120000}]
["Miscellaneous "]
["Fuel and Lube for AHTs & Tugs (estimated based on June 16, 2011 ave cost per MT of marine grade fuel $1060) www.bunkerindex.com",1,170000,"LS",{"$f":"B24*C24","v":170000},{"$f":"E24","v":170000}]
["Port equipment staging, assembly, and loadout lease","?",null,"day",null,{"$f":"E25","v":0}]
["Loadout of C-plane onto barge",1,null,"LS",20000,{"$f":"E26","v":20000}]
["Preparation of barge for towing (guess)",1,50000,"LS",{"$f":"B27*C27","v":50000},{"$f":"E27","v":50000}]
["Total Estimate",null,null,null,2480000,{"$f":"SUM(F11:F27)","v":950000}]
[]
["Subtotals"]
["Total Mob & Demob",null,null,null,{"$f":"SUM(E19:E22,E6:E9)","v":1580000},{"$f":"SUM(F19:F22,F6:F9)","v":0}]
["Total Installation and anchor loadout",null,null,null,{"$f":"SUM(E11:E17)","v":710000},{"$f":"SUM(F11:F17)","v":710000}]
["Vessel Fuel, C-plane Loadout",null,null,null,{"$f":"SUM(E24:E27)","v":240000},{"$f":"SUM(F24:F27)","v":240000}]

{"sheet":" Mooring Installation Scaling","index":10,"n_rows":20,"n_cols":37,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,0,4],[1,15,1,16],[1,17,1,18],[0,7,0,8],[1,7,1,8],[1,19,1,20],[0,9,0,10],[0,11,0,12],[0,13,0,14],[0,15,0,16],[0,17,0,18],[0,19,0,20],[1,9,1,10],[1,11,1,12],[1,13,1,14],[0,33,0,34],[0,35,0,36],[1,23,1,24],[1,25,1,26],[1,27,1,28],[1,29,1,30],[1,31,1,32],[1,33,1,34],[1,35,1,36],[0,23,0,24],[0,25,0,26],[0,27,0,28],[0,29,0,30],[0,31,0,32]]}
["EQUIPMENT LIST","Quantity or Days","Rent Equipment",null,null,null,"Turbine Rating",null,null,2400,null,1600,null,1000,null,750,null,500,null,350,null,null,"Turbine Rating",null,null,2400,null,1600,null,1000,null,750,null,500,null,350]
[null,null,"Cost  (USD)","Unit","Estimated Cost",null,"Total Install Days",null,null,{"$f":"J4+J6+J7","v":4},null,4,null,3,null,3,null,2,null,2,null,null,"Total Install Days",null,null,{"$f":"Z4+Z6+Z7","v":2},null,4,null,3,null,3,null,2,null,2]
["Loadout of Anchors & Travel to site",null,null,null,null,null,"Loadout of Anchors & Travel to site","Cost  (USD)","Unit","Days","Cost","Days","Cost","Days","Cost","Days","Cost","Days","Cost","Days","Cost",null,"Loadout of Anchors & Travel to site","Cost  (USD)","Unit","Days","Cost","Days","Cost","Days","Cost","Days","Cost","Days","Cost","Days","Cost"]
["Anchor Handling Tug arrives at Local Port, Anchors and mooring lines are loaded on to vessel and lashed down for deployement to site",1,150000,"day",{"$f":"B4*C4","v":150000},null,"Anchor Handling Tug arrives at Local Port, Anchors and mooring lines are loaded on to vessel and lashed down for deployement to site",150000,"day",1,{"$f":"J4*$C4","v":150000},{"$f":"$J4*L$2/$J$2","v":1},{"$f":"L4*$C4","v":150000},{"$f":"$J4*N$2/$J$2","v":0.75},{"$f":"N4*$C4","v":112500},{"$f":"$J4*P$2/$J$2","v":0.75},{"$f":"P4*$C4","v":112500},{"$f":"$J4*R$2/$J$2","v":0.5},{"$f":"R4*$C4","v":75000},{"$f":"$J4*T$2/$J$2","v":0.5},{"$f":"T4*$C4","v":75000}]
["Offshore Installation",null,null,null,null,null,"Offshore Installation",null,null,"Days","Cost","Days","Cost","Days","Cost","Days","Cost","Days","Cost","Days","Cost",null,"Offshore Installation",null,null,"Days","Cost","Days","Cost","Days","Cost","Days","Cost","Days","Cost","Days","Cost"]
["AHT #1 travels to site, installs two FWD anchors, conducts pull tests and returns to port for rear anchor",1,150000,"day",{"$f":"B6*C6","v":150000},null,"AHT #1 travels to site, installs two FWD anchors, conducts pull tests and returns to port for rear anchor",150000,"day",1,{"$f":"J6*$C6","v":150000},{"$f":"$J6*L$2/$J$2","v":1},{"$f":"L6*$C6","v":150000},{"$f":"$J6*N$2/$J$2","v":0.75},{"$f":"N6*$C6","v":112500},{"$f":"$J6*P$2/$J$2","v":0.75},{"$f":"P6*$C6","v":112500},{"$f":"$J6*R$2/$J$2","v":0.5},{"$f":"R6*$C6","v":75000},{"$f":"$J6*T$2/$J$2","v":0.5},{"$f":"T6*$C6","v":75000},null,"AHT #1 travels to site, installs two FWD anchors, conducts pull tests and returns to port for rear anchor",150000,"day",1,{"$f":"Z6*$C6","v":150000},1,{"$f":"AB6*$C6","v":150000},1,{"$f":"AD6*$C6","v":150000},1,{"$f":"AF6*$C6","v":150000},1,{"$f":"AH6*$C6","v":150000},1,{"$f":"AJ6*$C6","v":150000}]
["Semi-Submersible Installation of Cplane",2,15000,"day",{"$f":"B7*C7","v":30000},null,"Semi-Submersible Installation of Cplane",15000,"day",2,{"$f":"J7*$C7","v":30000},{"$f":"$J7*L$2/$J$2","v":2},30000,1.5,{"$f":"N7*$C7","v":22500},1.5,{"$f":"P7*$C7","v":22500},1,{"$f":"R7*$C7","v":15000},1,15000,null,"Semi-Submersible Installation of Cplane",15000,"day",1,{"$f":"Z7*$C7","v":15000},1,{"$f":"AB7*$C7","v":15000},1,{"$f":"AD7*$C7","v":15000},1,{"$f":"AF7*$C7","v":15000},1,{"$f":"AH7*$C7","v":15000},1,{"$f":"AJ7*$C7","v":15000}]
["Ocean going tug #1 assists in tow out of C-Plane, Ocean going tug #1 assists with lowering of C-Plane / station keeping for transport barge",2,20000,"day",{"$f":"B8*C8","v":40000},null,"Ocean going tug #1 assists in tow out of C-Plane, Ocean going tug #1 assists with lowering of C-Plane / station keeping for transport barge",20000,"day",{"$f":"J7","v":2},40000,2,40000,1.5,30000,1.5,30000,1,20000,1,20000,null,"Ocean going tug #1 assists in tow out of C-Plane, Ocean going tug #1 assists with lowering of C-Plane / station keeping for transport barge",20000,"day",{"$f":"Z7","v":1},20000,{"$f":"AB7","v":1},20000,{"$f":"AD7","v":1},20000,{"$f":"AF7","v":1},20000,{"$f":"AH7","v":1},20000,{"$f":"AJ7","v":1},20000]
["Ocean going tug #2 assists in tow out of C-Plane ( est. 9 hrs), Ocean going tug #2 assists with lowering of C-Plane / station keeping for transport barge during installation",2,20000,"day",{"$f":"B9*C9","v":40000},null,"Ocean going tug #2 assists in tow out of C-Plane ( est. 9 hrs), Ocean going tug #2 assists with lowering of C-Plane / station keeping for transport barge during installation",20000,"day",{"$f":"J8","v":2},40000,2,40000,1.5,30000,1.5,30000,1,20000,1,20000,null,"Ocean going tug #2 assists in tow out of C-Plane ( est. 9 hrs), Ocean going tug #2 assists with lowering of C-Plane / station keeping for transport barge during installation",20000,"day",{"$f":"Z8","v":1},20000,1,20000,{"$f":"AD8","v":1},20000,{"$f":"AF8","v":1},20000,{"$f":"AH8","v":1},20000,{"$f":"AJ8","v":1},20000]
["AHT #1 loads rear anchor, returns to site, deploys anchor and assists in lowering C-Plane",2,150000,"day",{"$f":"B10*C10","v":300000},null,"AHT #1 loads rear anchor, returns to site, deploys anchor and assists in lowering C-Plane",150000,"day",2,300000,2,300000,1.5,225000,1.5,225000,1,150000,1,150000,null,"AHT #1 loads rear anchor, returns to site, deploys anchor and assists in lowering C-Plane",150000,"day",1,150000,1,150000,{"$f":"AD9","v":1},150000,{"$f":"AF9","v":1},150000,{"$f":"AH9","v":1},150000,{"$f":"AJ9","v":1},150000]
["Miscellaneous ",null,null,null,null,null,"Miscellaneous ",null,null,"QTY","Cost","QTY","Cost","QTY","Cost","QTY","Cost","QTY","Cost","QTY","Cost",null,"Miscellaneous ",null,null,"QTY","Cost","QTY","Cost","QTY","Cost","QTY","Cost","QTY","Cost","QTY","Cost"]
["Fuel and Lube for AHTs & Tugs (estimated based on June 16, 2011 ave cost per MT of marine grade fuel $1060) www.bunkerindex.com",1,170000,"LS",{"$f":"B12*C12","v":170000},null,"Fuel and Lube for AHTs & Tugs (estimated based on June 16, 2011 ave cost per MT of marine grade fuel $1060) www.bunkerindex.com",170000,"Ea",1,{"$f":"$E$12*(J4+J6+J7)/($J$4+$J$6+$J$7)","v":170000},1,{"$f":"$E$12*(L4+L6+L7)/($J$4+$J$6+$J$7)","v":170000},1,{"$f":"$E$12*(N4+N6+N7)/($J$4+$J$6+$J$7)","v":127500},1,{"$f":"$E$12*(P4+P6+P7)/($J$4+$J$6+$J$7)","v":127500},1,{"$f":"$E$12*(R4+R6+R7)/($J$4+$J$6+$J$7)","v":85000},1,{"$f":"$E$12*(T4+T6+T7)/($J$4+$J$6+$J$7)","v":85000},null,"Fuel and Lube for AHTs & Tugs (estimated based on June 16, 2011 ave cost per MT of marine grade fuel $1060) www.bunkerindex.com",170000,"Ea",1,{"$f":"$E$12*(Z4+Z6+Z7)/($J$4+$J$6+$J$7)","v":85000},1,{"$f":"$E$12*(AB4+AB6+AB7)/($J$4+$J$6+$J$7)","v":85000},1,{"$f":"$E$12*(AD4+AD6+AD7)/($J$4+$J$6+$J$7)","v":85000},1,{"$f":"$E$12*(AF4+AF6+AF7)/($J$4+$J$6+$J$7)","v":85000},1,{"$f":"$E$12*(AH4+AH6+AH7)/($J$4+$J$6+$J$7)","v":85000},1,{"$f":"$E$12*(AJ4+AJ6+AJ7)/($J$4+$J$6+$J$7)","v":85000}]
["Port equipment staging, assembly, and loadout lease","?",null,"day",null,null,"Port equipment staging, assembly, and loadout lease",null,"day",null,null,null,null,null,null,null,null,null,null,null,null,null,"Port equipment staging, assembly, and loadout lease",null,"day"]
["Loadout of C-plane onto barge",1,null,"LS",20000,null,"Loadout of C-plane onto barge",null,"Ea",1,{"$f":"E14","v":20000},1,{"$f":"$K14*1/1","v":20000},1,{"$f":"$K14*1/1","v":20000},null,{"$f":"$K14*1/1","v":20000},null,{"$f":"$K14*1/1","v":20000},null,{"$f":"$K14*1/1","v":20000},null,"Loadout of C-plane onto barge",null,"Ea",1,{"$f":"U14","v":20000},1,{"$f":"$K14*1/1","v":20000},1,{"$f":"$K14*1/1","v":20000},null,{"$f":"$K14*1/1","v":20000},null,{"$f":"$K14*1/1","v":20000},null,{"$f":"$K14*1/1","v":20000}]
["Preparation of barge for towing (guess)",1,50000,"LS",{"$f":"B15*C15","v":50000},null,"Preparation of barge for towing (guess)",50000,"Ea",1,{"$f":"E15","v":50000},1,{"$f":"$K15*1/1","v":50000},1,{"$f":"$K15*1/1","v":50000},null,{"$f":"$K15*1/1","v":50000},null,{"$f":"$K15*1/1","v":50000},null,{"$f":"$K15*1/1","v":50000},null,"Preparation of barge for towing (guess)",50000,"Ea",1,{"$f":"U15","v":50000},1,{"$f":"$K15*1/1","v":50000},1,{"$f":"$K15*1/1","v":50000},null,{"$f":"$K15*1/1","v":50000},null,{"$f":"$K15*1/1","v":50000},null,{"$f":"$K15*1/1","v":50000}]
["Total Estimate",{"$f":"B4+B6+B7","v":4},null,null,2480000,null,"Total Estimate",null,null,null,{"$f":"SUM(K4:K15)","v":950000},null,{"$f":"SUM(M4:M15)","v":950000},null,{"$f":"SUM(O4:O15)","v":730000},null,{"$f":"SUM(Q4:Q15)","v":730000},null,{"$f":"SUM(S4:S15)","v":510000},null,{"$f":"SUM(U4:U15)","v":510000},null,"Total Estimate",null,null,null,{"$f":"SUM(AA4:AA15)","v":510000},null,{"$f":"SUM(AC4:AC15)","v":510000},null,{"$f":"SUM(AE4:AE15)","v":510000},null,{"$f":"SUM(AG4:AG15)","v":510000},null,{"$f":"SUM(AI4:AI15)","v":510000},null,{"$f":"SUM(AK4:AK15)","v":510000}]
[]
["Subtotals"]
["Total Installation and anchor loadout",null,null,null,{"$f":"SUM(E4:E10)","v":710000}]
["Vessel Fuel, C-plane Loadout",null,null,null,{"$f":"SUM(E12:E15)","v":240000}]

{"sheet":"Torque Calcs","index":11,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Mechanical Calculations","Units","Value","Value","Value","Value","Value","Value"]
["Rotor Diameter","m",45.5,35.078706289552613,27.841987613041795,24.322216495495827,34.9,32.299999999999997]
["TSR","-",8,8,8,8,8,8]
["Rated Speed","m/s",1.6,1.6,1.6,1.6,1.6,1.8]
["Tip Speed","m/s",{"$f":"C3*C4","v":12.8},12.8,12.8,12.8,12.8,14.4]
["RPM","-",{"$f":"60/((PI()*C2)/C5)","v":5.3727910459154131},6.968956909963314,8.7803355129229317,10.050975108885433,7.0046416214656526,8.514543085535454]
["Angular Velocity","rad/s",{"$f":"C6*2*PI()/60","v":0.56263736263736275},0.72978746105081904,0.91947458478174171,1.0525356521162783,0.73352435530085969,0.89164086687306499]
["Power Rating (Nameplate)","kW",1200,793.94196365900632,500.15209549241212,381.68748531207405,750,1000]
["System Efficenecy","-",0.85,0.85,0.85,0.85,0.85,0.85]
["Input Power","kW",{"$f":"C8/C9","v":1411.7647058823529},934.04936901059568,588.41422999107306,449.04410036714597,882.35294117647061,1176.4705882352941]
["Input Torque","kNm",{"$f":"C10/((2*PI()*C6/60))","v":2509.1911764705878},1279.8923232603372,639.94616026363212,426.63077442011252,1202.8952205882351,1319.4444444444446]
["Gen RPM",null,1200,1200,1200,1200,1200,1200]
["Gen torque","Nm",{"$f":"1000*(C8/0.98)/((2*PI()*C12/60))","v":9744.1801892997173},6446.9279614498373,4061.310117111585,3099.3596940679486,{"$f":"1000*(G8/0.98)/((2*PI()*G12/60))","v":6090.1126183123224},{"$f":"1000*(H8/0.98)/((2*PI()*H12/60))","v":8120.1501577497629}]

{"sheet":"Shaft Scaling","index":12,"n_rows":65,"n_cols":20,"rows_kept":65,"cut":false,"hidden":false,"merged":[[0,7,0,8],[9,7,9,8]]}
["1200 kW PDC",null,null,null,null,null,null,"Shaft Scaling Factors ",null,"TRB Weight","TRB Dia.",null,null,null,"1200 kW PDC"]
["N","Factor of Safety",2,null,"Inputs",null,null,{"$f":"A1","v":"1200 kW PDC"},{"$f":"C8/$C$8","v":1},{"$f":" 102162*I2^2 - 57571*I2 + 10173","v":54764},{"$f":" 4.1097*I2+ 0.1294","v":4.2391000000000005},null,null,null,"N","Factor of Safety",2,null,"Inputs"]
["Sf","shear yelid",{"$f":"0.58*E3*1000000","v":406000000},"N/m^2",700,"Mpa",null,{"$f":"A12","v":"800 kW"},{"$f":"C19/$C$8","v":0.81718686384177519},{"$f":" 102162*I3^2 - 57571*I3 + 10173","v":31349.94353420243},{"$f":" 4.1097*I3+ 0.1294","v":3.4877928543305434},null,null,null,"Sf","shear yelid",{"$f":"0.58*S3*1000000","v":406000000},"N/m^2",700,"Mpa"]
["Sut","Shear ultimate",{"$f":"0.75*E4*1000000","v":750000000},"N/m^2",1000,"Mpa",null,{"$f":"A23","v":"500 kW"},{"$f":"C30/$C$8","v":0.70501659947748863},{"$f":" 102162*I4^2 - 57571*I4 + 10173","v":20363.948558136559},{"$f":" 4.1097*I4+ 0.1294","v":3.0268067188726349},null,null,null,"Sut","Shear ultimate",{"$f":"0.75*S4*1000000","v":750000000},"N/m^2",1000,"Mpa"]
["Torque",null,{"$f":"E5*1000","v":5000000},"Nm",5000,"kNm",null,{"$f":"A34","v":"375 kW"},{"$f":"C41/$C$8","v":0.64130812296990192},15269.039857983138,2.7649839929694058,null,null,null,"Torque",null,{"$f":"S5*1000","v":2520000},"Nm",2520,"kNm"]
["Moment",null,{"$f":"E6*1000","v":5000000},"Nm",5000,"kNm",null,{"$f":"A45","v":"750 kW"},{"$f":"C52/$C$8","v":0.83378182658771782},33193.565290773877,3.5559931727275438,null,null,null,"Moment",null,{"$f":"S6*1000","v":0},"Nm",0,"kNm"]
[null,null,null,null,null,null,null,{"$f":"A56","v":"1000 kW"},{"$f":"C63/$C$8","v":0.7958114415792783},29058.153420574105,3.3999462814583601]
["D","T @ ultimate",{"$f":"((32*C2/PI())*((C6/C3)^2+(C5/C4)^2)^0.5)^(1/3)","v":0.65830443890288537},"m",null,null,null,null,null,null,null,null,null,null,"D","Dia @ ultimate",{"$f":"((32*Q2/PI())*((Q6/Q3)^2+(Q5/Q4)^2)^0.5)^(1/3)","v":0.40906261741963507},"m"]
["D","T @ Yeild",{"$f":"((C2*(32/PI())/C3)*((C5^2+C6^2)^0.5))^(1/3)","v":0.70793984532677834},"m",null,null,null,null,null,null,null,null,null,null,"D","Dia @ Yeild",{"$f":"((Q2*(32/PI())/Q3)*((Q5^2+Q6^2)^0.5))^(1/3)","v":0.50192042546959614},"m"]
["D","Torque Only",{"$f":"((16/PI())*(C5/C3))^(1/3)","v":0.39731780443265813},"m",null,null,null,"Shaft Scaling Factors ",null,null,null,null,null,null,"D","Dia Torque Only",{"$f":"(Q2*(16/PI())*(Q2*Q5/Q3))^(1/3)","v":0.50192042546959614},"m"]
[null,null,null,null,null,null,null,1200,1]
["800 kW",null,null,null,null,null,null,600,0.87625127102392431]
["N","Factor of Safety",2,null,null,null,null,375,0.69261698165764884]
["Sf","shear yelid",{"$f":"0.58*E14*1000000","v":406000000},"N/m^2",700,"Mpa",null,250,0.55178483527622413]
["Sut","Shear ultimate",{"$f":"0.75*E15*1000000","v":750000000},"N/m^2",1000,"Mpa",null,125,0.43088693800637679]
["Torque",null,{"$f":"E16*1000","v":2500000},"Nm",2500,"kNm",null,50,0.34199518933533946]
["Moment",null,{"$f":"E17*1000","v":2792000},"Nm",2792,"kNm"]
[]
["D","T @ ultimate",{"$f":"((32*C13/PI())*((C17/C14)^2+(C16/C15)^2)^0.5)^(1/3)","v":0.53795773988016837},"m"]
["D","T @ Yeild",{"$f":"((C13*(32/PI())/C14)*((C16^2+C17^2)^0.5))^(1/3)","v":0.57291431488043443},"m"]
["D","Torque Only",{"$f":"((16/PI())*(C16/C14))^(1/3)","v":0.31535135036104844},"m"]
[]
["500 kW"]
["N","Factor of Safety",2]
["Sf","shear yelid",{"$f":"0.58*E25*1000000","v":406000000},"N/m^2",700,"Mpa"]
["Sut","Shear ultimate",{"$f":"0.75*E26*1000000","v":750000000},"N/m^2",1000,"Mpa"]
["Torque",null,{"$f":"E27*1000","v":1260000},"Nm",1260,"kNm"]
["Moment",null,{"$f":"E28*1000","v":1872000},"Nm",1872,"kNm"]
[]
["D","T @ ultimate",{"$f":"((32*C24/PI())*((C28/C25)^2+(C27/C26)^2)^0.5)^(1/3)","v":0.46411555693624845},"m"]
["D","T @ Yeild",{"$f":"((C24*(32/PI())/C25)*((C27^2+C28^2)^0.5))^(1/3)","v":0.48378143043204591},"m"]
["D","Torque Only",{"$f":"((16/PI())*(C27/C25))^(1/3)","v":0.25096021273479807},"m"]
[]
["375 kW"]
["N","Factor of Safety",2]
["Sf","shear yelid",{"$f":"0.58*E36*1000000","v":406000000},"N/m^2",700,"Mpa"]
["Sut","Shear ultimate",{"$f":"0.75*E37*1000000","v":750000000},"N/m^2",1000,"Mpa"]
["Torque",null,{"$f":"E38*1000","v":840000},"Nm",840,"kNm"]
["Moment",null,{"$f":"E39*1000","v":1429000},"Nm",1429,"kNm"]
[]
["D","T @ ultimate",{"$f":"((32*C35/PI())*((C39/C36)^2+(C38/C37)^2)^0.5)^(1/3)","v":0.42217598405556389},"m"]
["D","T @ Yeild",{"$f":"((C35*(32/PI())/C36)*((C38^2+C39^2)^0.5))^(1/3)","v":0.4365104923778757},"m"]
["D","Torque Only",{"$f":"((16/PI())*(C38/C36))^(1/3)","v":0.21923393927118531},"m"]
[]
["750 kW"]
["N","Factor of Safety",2]
["Sf","shear yelid",{"$f":"0.58*E47*1000000","v":406000000},"N/m^2",700,"Mpa"]
["Sut","Shear ultimate",{"$f":"0.75*E48*1000000","v":750000000},"N/m^2",1000,"Mpa"]
["Torque",null,{"$f":"E49*1000","v":2520000},"Nm",2520,"kNm"]
["Moment",null,{"$f":"E50*1000","v":3000000},"Nm",3000,"kNm"]
[]
["D","T @ ultimate",{"$f":"((32*C46/PI())*((C50/C47)^2+(C49/C48)^2)^0.5)^(1/3)","v":0.54888227751925045},"m"]
["D","T @ Yeild",{"$f":"((C46*(32/PI())/C47)*((C49^2+C50^2)^0.5))^(1/3)","v":0.58146195663445255},"m"]
["D","Torque Only",{"$f":"((16/PI())*(C49/C47))^(1/3)","v":0.31619005471066752},"m"]
[]
["1000 kW"]
["N","Factor of Safety",2]
["Sf","shear yelid",{"$f":"0.58*E58*1000000","v":406000000},"N/m^2",700,"Mpa"]
["Sut","Shear ultimate",{"$f":"0.75*E59*1000000","v":750000000},"N/m^2",1000,"Mpa"]
["Torque",null,{"$f":"E60*1000","v":2520000},"Nm",2520,"kNm"]
["Moment",null,{"$f":"E61*1000","v":2520000},"Nm",2520,"kNm"]
[]
["D","T @ ultimate",{"$f":"((32*C57/PI())*((C61/C58)^2+(C60/C59)^2)^0.5)^(1/3)","v":0.52388620452134316},"m"]
["D","T @ Yeild",{"$f":"((C57*(32/PI())/C58)*((C60^2+C61^2)^0.5))^(1/3)","v":0.56338662886091484},"m"]
["D","Torque Only",{"$f":"((16/PI())*(C60/C58))^(1/3)","v":0.31619005471066752},"m"]

{"sheet":"Rotor Sizing Output","index":13,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,"2X CBM 6000","CBM 6000","CBM 4000","CBM 2000","CBM 1200"]
["Rated Power Electrical (kW)",793.94196365900632,500.15209549241212,381.68748531207405,240.44804850230722,171.04997697687165]
["Diameter (m)",35.078706289552613,27.841987613041795,24.322216495495827,19.304556021128203,16.282110567364324]
["Rated Rotor Speed (RPM)",6.968956909963314,8.7803355129229317,10.050975108885433,12.663435114570655,15.014146450961221]
["AEP",9031.642311611371,5689.5781236605226,4341.9607476972369,2735.2638706606122,1945.8125154951176]
["Torque",2520.0000022897684,1259.999998454289,840.00000076325648,420.00000009144088,252.00080935449841]

{"sheet":"2.4 2400 FC Quick COE Baseline","index":14,"n_rows":30,"n_cols":27,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,21,5,26],[7,15,7,19],[7,21,7,25]]}
[]
[null,null,"Quick COE calculation sheet"]
[null,null,"This sheet can be used to make quick calculations of how a change will impact the COE."]
[]
[]
[null,null,"Assumed values:","Value","Unit","Comments",null,null,"Effect of changes",null,null,null,null,null,"Finding COE Targets","Updated:","2011-10-12",null,null,null,null,"Alternative 1"]
[]
[null,null,"Energy Production",null,null,null,null,null,"CAPEX increase or decrease",null,null,null,null,null,null,"Current breakdown",null,null,null,null,null,"Target breakdown",null,null,null,null,"Decrease % Required"]
[null,null,"NET Capacity Factor",0.56000000000000005,"percent","Assumed after all losses are included",null,null,"Change in CAPEX",1000,"k$",null,null,null,null,"Value","Unit","COE\n(cents/kWh)","COE %","% of \nCAPEX",null,"Value","Unit","COE\n(cents/kWh)","COE %","% of \nCAPEX","As a percentage based on current breakdown"]
[null,null,"AEP_net (per rotor)",{"$f":"800*8760*D9/1000","v":3924.4800000000005},"MWh / yr","This corresponds to approximately 65% net Capacity Factor at 800 kW",null,null,"Equals change in COE",{"$f":"J9*0.08/D12*100","v":0.50962165688193084},"cents/kWh",null,null,null,"Total",null,null,{"$f":"R12+R19+R21","v":10.462349085469317},{"$f":"R10/$R$10","v":1},null,null,null,null,8,{"$f":"Y12+Y19+Y21","v":1}]
[null,null,"Number of rotors",4,"#"]
[null,null,"AEP_net (C-Plane)",{"$f":"D10*D11","v":15697.920000000002},"MWh / yr",null,null,null,null,null,null,null,null,null,"CAPEX (without margin)",{"$f":"SUM(P13:P17)","v":10559.51600583216},"k$",{"$f":"CRF*P12/$P$24*100","v":6.9129401020177808},{"$f":"R12/$R$10","v":0.66074454652051806},{"$f":"R12/$R$12","v":1},null,{"$f":"X12*$V$24/CRF/100","v":7038.7199999999984},"k$",{"$f":"Y12*$X$10","v":4.6079999999999997},0.57599999999999996,{"$f":"SUM(Z13:Z17)","v":1},{"$f":"(V12-P12)/P12","v":-0.33342399442243181}]
[null,null,null,null,null,null,null,null,"Change in CAPEX",0.1,"(in precent)",null,null,null,"Platform",4604,"k$",3.0140752864157117,0.28808781486767865,0.43600483179883903,null,2815.4879999999998,"k$",1.8431999999999999,{"$f":"Z13*$Y$12","v":0.23039999999999999},0.4,{"$f":"(V13-P13)/P13","v":-0.38846915725456127}]
[null,null,"Capital Recovery Factor",0.08,null,"Corresponds to a 20 year secured loan at around 4% interest rate.",null,null,"Equals change in COE",{"$f":"J13*D17*0.08/D12*100","v":1.5573018590998042},"cents/kWh",null,null,null,"Drivetrain",2608,"k$",1.7073649754500819,0.16319135994242095,0.2469810167965622,null,2111.616,"k$",1.3823999999999999,{"$f":"Z14*$Y$12","v":0.17279999999999998},0.3,-0.19033128834355828]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mooring lines & attachments",751,"k$",0.49165302782324055,4.6992604032499281E-2,7.1120683901157278E-2,null,703.87199999999996,"k$",0.46079999999999999,{"$f":"Z15*$Y$12","v":5.7599999999999998E-2},0.1,-6.2753661784287679E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grid connect",1271,"k$",0.83207855973813427,7.953075862224579E-2,0.12036536516427553,null,985.42079999999999,"k$",0.64512000000000003,{"$f":"Z16*$Y$12","v":8.0640000000000003E-2},0.14000000000000001,-0.22468859166011015]
[null,null,"CAPEX:",30558,"k$","Based on current CAPEX",null,null,"OPEX increase or decrease",null,null,null,null,null,"Misc (assembly & installation)",{"$f":"('Install, Asm, O&M'!C9+'Install, Asm, O&M'!C16)/1000","v":1325.5160058321599},"k$",0.86776825259061197,8.2942009055673366E-2,0.12552810233916589,null,422.32319999999993,"k$",0.27647999999999995,{"$f":"Z17*$Y$12","v":3.4559999999999994E-2},0.06,-0.68138958855131659]
[null,null,null,null,null,null,null,null,"Change in OPEX",200,"k$ / yr"]
[null,null,"O&M:",775,"k$ / yr","Based on current OPEX (witout tax deduction)",null,null,"Equals change in COE",{"$f":"J18/D12*100","v":1.274054142204827},"cents/kWh",null,null,null,"Gross margin (28%)",{"$f":"(P13+P14+P15)/(1-T19)-(P13+P14+P15)","v":3096.7222222222226},"k$",{"$f":"CRF*P19/$P$24*100","v":2.0273140571012913},{"$f":"R19/$R$10","v":0.19377235843878848},0.28000000000000003,null,{"$f":"X19*$V$24/CRF/100","v":2737.28},"k$",{"$f":"Y19*$X$10","v":1.792},{"$f":"Y12*Z19/(1-Z19)","v":0.224},0.28000000000000003,{"$f":"(T19-Z19)/T19","v":0}]
[]
[null,null,"COE:",{"$f":"(0.08*D17+D19)/D12*100","v":20.509978392041745},"cents/kWh",null,null,null,"Change in OPEX",0.1,"(in precent)",null,null,null,"O&M",186,"k$ / yr",{"$f":"P21/P24*100","v":1.5220949263502455},{"$f":"R21/$R$10","v":0.14548309504069351},null,null,{"$f":"X21*$V$24/100","v":195.52},"k$ / yr",{"$f":"Y21*$X$10","v":1.6},0.2,null,5.1182795698924789E-2]
[null,null,null,null,null,null,null,null,"Equals change in COE",{"$f":"J21*D19/D12*100","v":0.49369598010437049},"cents/kWh"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T19*(S12+S21)","v":0.22574373963713926},null,null,null,null,null,{"$f":"100-20-16.128","v":63.872}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AEP_net",12220,"MWh / yr",null,null,null,null,{"$f":"P24","v":12220},"MWh / yr",null,null,null,{"$f":"(V24-P24)/P24","v":0}]
[null,null,null,null,null,null,null,null,"AEP increase or decrease"]
[null,null,null,null,null,null,null,null,"Change in AEP",100,"MWh/yr",null,null,null,"How to use this tool:",null,null,null,null,null,null,null,null,null,"Tips:"]
[null,null,null,null,null,null,null,null,"Equals change in COE",{"$f":"((0.08*D17+D19)/(D12+J26)*100)-((0.08*D17+D19)/D12*100)","v":-0.12982708098307683},"cents/kWh",null,null,null,"1) Set the yellow cells for the Target Breakdown",null,null,null,null,null,null,null,null,null,"After setting the OPEX percentage or profit margin, "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2) Column R gives the \"target\" costs for each sub-element",null,null,null,null,null,null,null,null,null,"click here to adjust CAPEX percentage to get 100%"]
[null,null,null,null,null,null,null,null,"Change in AEP",0.1,"(in precent)",null,null,null,"3) If you want to see the \"Decrease required\" you need to update the yellow cells under \"Current Breakdown\""]
[null,null,null,null,null,null,null,null,"Equals change in COE",{"$f":"((0.08*D17+D19)/(D12*(1+J29))*100)-((0.08*D17+D19)/D12*100)","v":-1.8645434901856142},"cents/kWh"]

{"sheet":"2.4 2400 FC Quick COE","index":15,"n_rows":33,"n_cols":27,"rows_kept":33,"cut":false,"hidden":false,"merged":[[5,21,5,26],[7,15,7,19],[7,21,7,25]]}
[]
[null,null,"Quick COE calculation sheet"]
[null,null,"This sheet can be used to make quick calculations of how a change will impact the COE."]
[]
[]
[null,null,"Assumed values:","Value","Unit","Comments",null,null,"Effect of changes",null,null,null,null,null,"Finding COE Targets","Updated:","2011-10-12",null,null,null,null,"Alternative 1"]
[]
[null,null,"Energy Production",null,null,null,null,null,"CAPEX increase or decrease",null,null,null,null,null,null,"Current breakdown",null,null,null,null,null,"Target breakdown",null,null,null,null,"Decrease % Required"]
[null,null,"NET Capacity Factor",0.56000000000000005,"percent","Assumed after all losses are included",null,null,"Change in CAPEX",1000,"k$",null,null,null,null,"Value","Unit","COE\n(cents/kWh)","COE %","% of \nCAPEX",null,"Value","Unit","COE\n(cents/kWh)","COE %","% of \nCAPEX","As a percentage based on current breakdown"]
[null,null,"AEP_net (per rotor)",{"$f":"800*8760*D9/1000","v":3924.4800000000005},"MWh / yr","This corresponds to approximately 65% net Capacity Factor at 800 kW",null,null,"Equals change in COE",{"$f":"J9*0.08/D12*100","v":0.50962165688193084},"cents/kWh",null,null,null,"Total",null,null,{"$f":"R12+R19+R21","v":10.403276790513571},{"$f":"R10/$R$10","v":1},null,null,null,null,8,{"$f":"Y12+Y19+Y21","v":1}]
[null,null,"Number of rotors",4,"#"]
[null,null,"AEP_net (C-Plane)",{"$f":"D10*D11","v":15697.920000000002},"MWh / yr",null,null,null,null,null,null,null,null,null,"CAPEX (without margin)",{"$f":"SUM(P13:P17)","v":10029.057982940472},"k$",{"$f":"CRF*P12/$P$24*100","v":5.8774766271017009},{"$f":"R12/$R$10","v":0.56496397677904631},{"$f":"R12/$R$12","v":1},null,{"$f":"X12*$V$24/CRF/100","v":7862.8809806392492},"k$",{"$f":"Y12*$X$10","v":4.6079999999999997},0.57599999999999996,{"$f":"SUM(Z13:Z17)","v":1},{"$f":"(V12-P12)/P12","v":-0.21599007663390837}]
[null,null,null,null,null,null,null,null,"Change in CAPEX",0.1,"(in precent)",null,null,null,"Platform",{"$f":"'BOM Cost'!E4/1000","v":3340.3945476379904},"k$",1.9576206371960687,0.18817346463194778,0.33307161583072253,null,3145.1523922556999,"k$",1.8431999999999999,{"$f":"Z13*$Y$12","v":0.23039999999999999},0.4,{"$f":"(V13-P13)/P13","v":-5.8448830698860782E-2}]
[null,null,"Capital Recovery Factor",0.08,null,"Corresponds to a 20 year secured loan at around 4% interest rate.",null,null,"Equals change in COE",{"$f":"J13*D17*0.08/D12*100","v":1.5573018590998042},"cents/kWh",null,null,null,"Drivetrain",{"$f":"2*'BOM Cost'!E25/1000","v":3435.0418480749718},"k$",2.0130881892914778,0.19350520319974099,0.34250892296345398,null,2358.8642941917747,"k$",1.3823999999999999,{"$f":"Z14*$Y$12","v":0.17279999999999998},0.3,-0.313293869909124]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mooring lines & attachments",{"$f":"'Mooring Cost'!C4/1000","v":750.6},"k$",0.43988517803035643,4.2283329270972989E-2,7.4842522725143093E-2,null,786.28809806392496,"k$",0.46079999999999999,{"$f":"Z15*$Y$12","v":5.7599999999999998E-2},0.1,4.7546093876798479E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grid connect",{"$f":"'Grid Connection - MW Scale'!C3/1000","v":1177.5055813953488},"k$",0.69007094631472343,6.6332075961294992E-2,0.11740939013397846,null,1100.8033372894949,"k$",0.64512000000000003,{"$f":"Z16*$Y$12","v":8.0640000000000003E-2},0.14000000000000001,-6.513960130444682E-2]
[null,null,"CAPEX:",30558,"k$","Based on current CAPEX",null,null,"OPEX increase or decrease",null,null,null,null,null,"Misc (assembly & installation)",{"$f":"('Install, Asm, O&M'!C9+'Install, Asm, O&M'!C16)/1000","v":1325.5160058321599},"k$",0.77681167626907355,7.4669903715089483E-2,0.13216754834670175,null,471.77285883835486,"k$",0.27647999999999995,{"$f":"Z17*$Y$12","v":3.4559999999999994E-2},0.06,-0.64408361969029904]
[null,null,null,null,null,null,null,null,"Change in OPEX",200,"k$ / yr"]
[null,null,"O&M:",775,"k$ / yr","Based on current OPEX (witout tax deduction)",null,null,"Equals change in COE",{"$f":"J18/D12*100","v":1.274054142204827},"cents/kWh",null,null,null,"Gross margin (28%)",{"$f":"(P13+P14+P15)/(1-T19)-(P13+P14+P15)","v":2926.7919316661519},"k$",{"$f":"CRF*P19/$P$24*100","v":1.7152310017569623},{"$f":"R19/$R$10","v":0.16487410998436847},0.28000000000000003,null,{"$f":"X19*$V$24/CRF/100","v":3057.787048026375},"k$",{"$f":"Y19*$X$10","v":1.792},{"$f":"Y12*Z19/(1-Z19)","v":0.224},0.28000000000000003,{"$f":"(T19-Z19)/T19","v":0}]
[]
[null,null,"COE:",{"$f":"(0.08*D17+D19)/D12*100","v":20.509978392041745},"cents/kWh",null,null,null,"Change in OPEX",0.1,"(in precent)",null,null,null,"O&M",{"$f":"'Install, Asm, O&M'!C48/1000","v":383.66615982547859},"k$ / yr",{"$f":"P21/P24*100","v":2.8105691616549069},{"$f":"R21/$R$10","v":0.27016191323658512},null,null,{"$f":"X21*$V$24/100","v":218.41336057331253},"k$ / yr",{"$f":"Y21*$X$10","v":1.6},0.2,null,-0.43072028903288206]
[null,null,null,null,null,null,null,null,"Equals change in COE",{"$f":"J21*D19/D12*100","v":0.49369598010437049},"cents/kWh"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T19*(S12+S21)","v":0.23383524920437682},null,null,null,null,null,{"$f":"100-20-16.128","v":63.872}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AEP_net",{"$f":"AEP!$C$3","v":13650.835035832031},"MWh / yr",null,null,null,null,{"$f":"P24","v":13650.835035832031},"MWh / yr",null,null,null,{"$f":"(V24-P24)/P24","v":0}]
[null,null,null,null,null,null,null,null,"AEP increase or decrease"]
[null,null,null,null,null,null,null,null,"Change in AEP",100,"MWh/yr",null,null,null,"How to use this tool:",null,null,null,null,null,null,null,null,null,"Tips:"]
[null,null,null,null,null,null,null,null,"Equals change in COE",{"$f":"((0.08*D17+D19)/(D12+J26)*100)-((0.08*D17+D19)/D12*100)","v":-0.12982708098307683},"cents/kWh",null,null,null,"1) Set the yellow cells for the Target Breakdown",null,null,null,null,null,null,null,null,null,"After setting the OPEX percentage or profit margin, "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2) Column R gives the \"target\" costs for each sub-element",null,null,null,null,null,null,null,null,null,"click here to adjust CAPEX percentage to get 100%"]
[null,null,null,null,null,null,null,null,"Change in AEP",0.1,"(in precent)",null,null,null,"3) If you want to see the \"Decrease required\" you need to update the yellow cells under \"Current Breakdown\""]
[null,null,null,null,null,null,null,null,"Equals change in COE",{"$f":"((0.08*D17+D19)/(D12*(1+J29))*100)-((0.08*D17+D19)/D12*100)","v":-1.8645434901856142},"cents/kWh"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P12/2.4","v":4178.7741595585303}]

{"sheet":"2.4 1600 FC Quick COE","index":16,"n_rows":30,"n_cols":27,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,21,5,26],[7,15,7,19],[7,21,7,25]]}
[]
[null,null,"Quick COE calculation sheet"]
[null,null,"This sheet can be used to make quick calculations of how a change will impact the COE."]
[]
[]
[null,null,"Assumed values:","Value","Unit","Comments",null,null,"Effect of changes",null,null,null,null,null,"Finding COE Targets","Updated:","2011-10-12",null,null,null,null,"Alternative 1"]
[]
[null,null,"Energy Production",null,null,null,null,null,"CAPEX increase or decrease",null,null,null,null,null,null,"Current breakdown",null,null,null,null,null,"Target breakdown",null,null,null,null,"Decrease % Required"]
[null,null,"NET Capacity Factor",0.56000000000000005,"percent","Assumed after all losses are included",null,null,"Change in CAPEX",1000,"k$",null,null,null,null,"Value","Unit","COE\n(cents/kWh)","COE %","% of \nCAPEX",null,"Value","Unit","COE\n(cents/kWh)","COE %","% of \nCAPEX","As a percentage based on current breakdown"]
[null,null,"AEP_net (per rotor)",{"$f":"800*8760*D9/1000","v":3924.4800000000005},"MWh / yr","This corresponds to approximately 65% net Capacity Factor at 800 kW",null,null,"Equals change in COE",{"$f":"J9*0.08/D12*100","v":0.50962165688193084},"cents/kWh",null,null,null,"Total",null,null,{"$f":"R12+R19+R21","v":12.321628621434908},{"$f":"R10/$R$10","v":1},null,null,null,null,8,{"$f":"Y12+Y19+Y21","v":1}]
[null,null,"Number of rotors",4,"#"]
[null,null,"AEP_net (C-Plane)",{"$f":"D10*D11","v":15697.920000000002},"MWh / yr",null,null,null,null,null,null,null,null,null,"CAPEX (without margin)",{"$f":"SUM(P13:P17)","v":7616.4602567530337},"k$",{"$f":"CRF*P12/$P$24*100","v":6.746467580507316},{"$f":"R12/$R$10","v":0.54753050816440374},{"$f":"R12/$R$12","v":1},null,{"$f":"X12*$V$24/CRF/100","v":5202.2259714881493},"k$",{"$f":"Y12*$X$10","v":4.6079999999999997},0.57599999999999996,{"$f":"SUM(Z13:Z17)","v":1},{"$f":"(V12-P12)/P12","v":-0.31697589219668487}]
[null,null,null,null,null,null,null,null,"Change in CAPEX",0.1,"(in precent)",null,null,null,"Platform",{"$f":"'BOM Cost'!$G$4/1000","v":2304.2606034779305},"k$",2.041055678669204,0.16564820620535098,0.302536943120643,null,2080.89038859526,"k$",1.8431999999999999,{"$f":"Z13*$Y$12","v":0.23039999999999999},0.4,{"$f":"(V13-P13)/P13","v":-9.6937913422434602E-2}]
[null,null,"Capital Recovery Factor",0.08,null,"Corresponds to a 20 year secured loan at around 4% interest rate.",null,null,"Equals change in COE",{"$f":"J13*D17*0.08/D12*100","v":1.5573018590998042},"cents/kWh",null,null,null,"Drivetrain",{"$f":"(2*'BOM Cost'!$G$25/1000)","v":2556.3715477568821},"k$",2.2643691674727449,0.18377190524421513,0.33563774530173768,null,1560.6677914464447,"k$",1.3823999999999999,{"$f":"Z14*$Y$12","v":0.17279999999999998},0.3,-0.38949884150609065]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mooring lines & attachments",{"$f":"'Mooring Cost'!$D$4/1000","v":665.48546114459157},"k$",0.58947016561009902,4.7840280187040132E-2,8.737463844238505E-2,null,520.222597148815,"k$",0.46079999999999999,{"$f":"Z15*$Y$12","v":5.7599999999999998E-2},0.1,-0.2182810481628463]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grid connect",{"$f":"'Grid Connection - MW Scale'!$D$3/1000","v":872.23167173252273},"k$",0.77260072233919497,6.2702808701372972E-2,0.11451929667185883,null,728.311636008341,"k$",0.64512000000000003,{"$f":"Z16*$Y$12","v":8.0640000000000003E-2},0.14000000000000001,-0.16500207500870942]
[null,null,"CAPEX:",30558,"k$","Based on current CAPEX",null,null,"OPEX increase or decrease",null,null,null,null,null,"Misc (assembly & installation)",{"$f":"('Install, Asm, O&M'!$D$9+'Install, Asm, O&M'!$D$16)/1000","v":1218.1109726411057},"k$",1.0789718464160725,8.7567307826424454E-2,0.15993137646337532,null,312.13355828928894,"k$",0.27647999999999995,{"$f":"Z17*$Y$12","v":3.4559999999999994E-2},0.06,-0.74375605728883509]
[null,null,null,null,null,null,null,null,"Change in OPEX",200,"k$ / yr"]
[null,null,"O&M:",775,"k$ / yr","Based on current OPEX (witout tax deduction)",null,null,"Equals change in COE",{"$f":"J18/D12*100","v":1.274054142204827},"cents/kWh",null,null,null,"Gross margin (28%)",{"$f":"(P13+P14+P15)/(1-T19)-(P13+P14+P15)","v":2149.0457381475462},"k$",{"$f":"CRF*P19/$P$24*100","v":1.9035702823480189},{"$f":"R19/$R$10","v":0.15449015230312468},0.28000000000000003,null,{"$f":"X19*$V$24/CRF/100","v":2023.0878778009471},"k$",{"$f":"Y19*$X$10","v":1.792},{"$f":"Y12*Z19/(1-Z19)","v":0.224},0.28000000000000003,{"$f":"(T19-Z19)/T19","v":0}]
[]
[null,null,"COE:",{"$f":"(0.08*D17+D19)/D12*100","v":20.509978392041745},"cents/kWh",null,null,null,"Change in OPEX",0.1,"(in precent)",null,null,null,"O&M",{"$f":"'Install, Asm, O&M'!$D$48/1000","v":331.60494446108567},"k$ / yr",{"$f":"P21/P24*100","v":3.6715907585795735},{"$f":"R21/$R$10","v":0.29797933953247169},null,null,{"$f":"X21*$V$24/100","v":144.50627698578194},"k$ / yr",{"$f":"Y21*$X$10","v":1.6},0.2,null,-0.56422158535473843]
[null,null,null,null,null,null,null,null,"Equals change in COE",{"$f":"J21*D19/D12*100","v":0.49369598010437049},"cents/kWh"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T19*(S12+S21)","v":0.23674275735512515},null,null,null,null,null,{"$f":"100-20-16.128","v":63.872}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AEP_net",{"$f":"AEP!$D$3","v":9031.642311611371},"MWh / yr",null,null,null,null,{"$f":"P24","v":9031.642311611371},"MWh / yr",null,null,null,{"$f":"(V24-P24)/P24","v":0}]
[null,null,null,null,null,null,null,null,"AEP increase or decrease"]
[null,null,null,null,null,null,null,null,"Change in AEP",100,"MWh/yr",null,null,null,"How to use this tool:",null,null,null,null,null,null,null,null,null,"Tips:"]
[null,null,null,null,null,null,null,null,"Equals change in COE",{"$f":"((0.08*D17+D19)/(D12+J26)*100)-((0.08*D17+D19)/D12*100)","v":-0.12982708098307683},"cents/kWh",null,null,null,"1) Set the yellow cells for the Target Breakdown",null,null,null,null,null,null,null,null,null,"After setting the OPEX percentage or profit margin, "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2) Column R gives the \"target\" costs for each sub-element",null,null,null,null,null,null,null,null,null,"click here to adjust CAPEX percentage to get 100%"]
[null,null,null,null,null,null,null,null,"Change in AEP",0.1,"(in precent)",null,null,null,"3) If you want to see the \"Decrease required\" you need to update the yellow cells under \"Current Breakdown\""]
[null,null,null,null,null,null,null,null,"Equals change in COE",{"$f":"((0.08*D17+D19)/(D12*(1+J29))*100)-((0.08*D17+D19)/D12*100)","v":-1.8645434901856142},"cents/kWh"]

{"sheet":"2.4 1000 FC Quick COE","index":17,"n_rows":30,"n_cols":27,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,21,5,26],[7,15,7,19],[7,21,7,25]]}
[]
[null,null,"Quick COE calculation sheet"]
[null,null,"This sheet can be used to make quick calculations of how a change will impact the COE."]
[]
[]
[null,null,"Assumed values:","Value","Unit","Comments",null,null,"Effect of changes",null,null,null,null,null,"Finding COE Targets","Updated:","2011-10-12",null,null,null,null,"Alternative 1"]
[]
[null,null,"Energy Production",null,null,null,null,null,"CAPEX increase or decrease",null,null,null,null,null,null,"Current breakdown",null,null,null,null,null,"Target breakdown",null,null,null,null,"Decrease % Required"]
[null,null,"NET Capacity Factor",0.56000000000000005,"percent","Assumed after all losses are included",null,null,"Change in CAPEX",1000,"k$",null,null,null,null,"Value","Unit","COE\n(cents/kWh)","COE %","% of \nCAPEX",null,"Value","Unit","COE\n(cents/kWh)","COE %","% of \nCAPEX","As a percentage based on current breakdown"]
[null,null,"AEP_net (per rotor)",{"$f":"800*8760*D9/1000","v":3924.4800000000005},"MWh / yr","This corresponds to approximately 65% net Capacity Factor at 800 kW",null,null,"Equals change in COE",{"$f":"J9*0.08/D12*100","v":0.50962165688193084},"cents/kWh",null,null,null,"Total",null,null,{"$f":"R12+R19+R21","v":12.970736616579078},{"$f":"R10/$R$10","v":1},null,null,null,null,8,{"$f":"Y12+Y19+Y21","v":1}]
[null,null,"Number of rotors",4,"#"]
[null,null,"AEP_net (C-Plane)",{"$f":"D10*D11","v":15697.920000000002},"MWh / yr",null,null,null,null,null,null,null,null,null,"CAPEX (without margin)",{"$f":"SUM(P13:P17)","v":4898.1381848217161},"k$",{"$f":"CRF*P12/$P$24*100","v":6.8871724101334744},{"$f":"R12/$R$10","v":0.53097773963973283},{"$f":"R12/$R$12","v":1},null,{"$f":"X12*$V$24/CRF/100","v":3277.1969992284603},"k$",{"$f":"Y12*$X$10","v":4.6079999999999997},0.57599999999999996,{"$f":"SUM(Z13:Z17)","v":1},{"$f":"(V12-P12)/P12","v":-0.33093006453272517}]
[null,null,null,null,null,null,null,null,"Change in CAPEX",0.1,"(in precent)",null,null,null,"Platform",{"$f":"'BOM Cost'!$I$4/1000","v":1375.7403879742228},"k$",1.9344005591600637,0.14913575198863652,0.28087006451499225,null,1310.8787996913843,"k$",1.8431999999999999,{"$f":"Z13*$Y$12","v":0.23039999999999999},0.4,{"$f":"(V13-P13)/P13","v":-4.714667741807535E-2}]
[null,null,"Capital Recovery Factor",0.08,null,"Corresponds to a 20 year secured loan at around 4% interest rate.",null,null,"Equals change in COE",{"$f":"J13*D17*0.08/D12*100","v":1.5573018590998042},"cents/kWh",null,null,null,"Drivetrain",{"$f":"(2*'BOM Cost'!$I$25/1000)","v":1477.2532322621539},"k$",2.077135703427837,0.16014014969457177,0.3015948461478376,null,983.15909976853811,"k$",1.3823999999999999,{"$f":"Z14*$Y$12","v":0.17279999999999998},0.3,-0.33446813430693761]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mooring lines & attachments",{"$f":"'Mooring Cost'!$E$4/1000","v":528.19616016926466},"k$",0.74268587046582268,5.7258573080308205E-2,0.10783610838216685,null,327.71969992284608,"k$",0.46079999999999999,{"$f":"Z15*$Y$12","v":5.7599999999999998E-2},0.1,-0.37954925719674731]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grid connect",{"$f":"'Grid Connection - MW Scale'!$E$3/1000","v":628.49872340425532},"k$",0.88371926317784144,6.8131771486923842E-2,0.12831379999687198,null,458.80757989198457,"k$",0.64512000000000003,{"$f":"Z16*$Y$12","v":8.0640000000000003E-2},0.14000000000000001,-0.26999441238820793]
[null,null,"CAPEX:",30558,"k$","Based on current CAPEX",null,null,"OPEX increase or decrease",null,null,null,null,null,"Misc (assembly & installation)",{"$f":"('Install, Asm, O&M'!$E$9+'Install, Asm, O&M'!$E$16)/1000","v":888.44968101181883},"k$",1.249231013901908,9.6311493389292346E-2,0.18138518095813108,null,196.63181995370763,"k$",0.27647999999999995,{"$f":"Z17*$Y$12","v":3.4559999999999994E-2},0.06,-0.77867984630286358]
[null,null,null,null,null,null,null,null,"Change in OPEX",200,"k$ / yr"]
[null,null,"O&M:",775,"k$ / yr","Based on current OPEX (witout tax deduction)",null,null,"Equals change in COE",{"$f":"J18/D12*100","v":1.274054142204827},"cents/kWh",null,null,null,"Gross margin (28%)",{"$f":"(P13+P14+P15)/(1-T19)-(P13+P14+P15)","v":1314.9071368244167},"k$",{"$f":"CRF*P19/$P$24*100","v":1.8488641628542266},{"$f":"R19/$R$10","v":0.14254118463025647},0.28000000000000003,null,{"$f":"X19*$V$24/CRF/100","v":1274.465499699957},"k$",{"$f":"Y19*$X$10","v":1.792},{"$f":"Y12*Z19/(1-Z19)","v":0.224},0.28000000000000003,{"$f":"(T19-Z19)/T19","v":0}]
[]
[null,null,"COE:",{"$f":"(0.08*D17+D19)/D12*100","v":20.509978392041745},"cents/kWh",null,null,null,"Change in OPEX",0.1,"(in precent)",null,null,null,"O&M",{"$f":"'Install, Asm, O&M'!$E$48/1000","v":240.93656728281766},"k$ / yr",{"$f":"P21/P24*100","v":4.2347000435913777},{"$f":"R21/$R$10","v":0.32648107573001078},null,null,{"$f":"X21*$V$24/100","v":91.033249978568364},"k$ / yr",{"$f":"Y21*$X$10","v":1.6},0.2,null,-0.62216922484949677]
[null,null,null,null,null,null,null,null,"Equals change in COE",{"$f":"J21*D19/D12*100","v":0.49369598010437049},"cents/kWh"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T19*(S12+S21)","v":0.24008846830352823},null,null,null,null,null,{"$f":"100-20-16.128","v":63.872}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AEP_net",{"$f":"AEP!$E$3","v":5689.5781236605226},"MWh / yr",null,null,null,null,{"$f":"P24","v":5689.5781236605226},"MWh / yr",null,null,null,{"$f":"(V24-P24)/P24","v":0}]
[null,null,null,null,null,null,null,null,"AEP increase or decrease"]
[null,null,null,null,null,null,null,null,"Change in AEP",100,"MWh/yr",null,null,null,"How to use this tool:",null,null,null,null,null,null,null,null,null,"Tips:"]
[null,null,null,null,null,null,null,null,"Equals change in COE",{"$f":"((0.08*D17+D19)/(D12+J26)*100)-((0.08*D17+D19)/D12*100)","v":-0.12982708098307683},"cents/kWh",null,null,null,"1) Set the yellow cells for the Target Breakdown",null,null,null,null,null,null,null,null,null,"After setting the OPEX percentage or profit margin, "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2) Column R gives the \"target\" costs for each sub-element",null,null,null,null,null,null,null,null,null,"click here to adjust CAPEX percentage to get 100%"]
[null,null,null,null,null,null,null,null,"Change in AEP",0.1,"(in precent)",null,null,null,"3) If you want to see the \"Decrease required\" you need to update the yellow cells under \"Current Breakdown\""]
[null,null,null,null,null,null,null,null,"Equals change in COE",{"$f":"((0.08*D17+D19)/(D12*(1+J29))*100)-((0.08*D17+D19)/D12*100)","v":-1.8645434901856142},"cents/kWh"]

{"sheet":"2.4 750 FC Quick COE","index":18,"n_rows":30,"n_cols":27,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,21,5,26],[7,15,7,19],[7,21,7,25]]}
[]
[null,null,"Quick COE calculation sheet"]
[null,null,"This sheet can be used to make quick calculations of how a change will impact the COE."]
[]
[]
[null,null,"Assumed values:","Value","Unit","Comments",null,null,"Effect of changes",null,null,null,null,null,"Finding COE Targets","Updated:","2011-10-12",null,null,null,null,"Alternative 1"]
[]
[null,null,"Energy Production",null,null,null,null,null,"CAPEX increase or decrease",null,null,null,null,null,null,"Current breakdown",null,null,null,null,null,"Target breakdown",null,null,null,null,"Decrease % Required"]
[null,null,"NET Capacity Factor",0.56000000000000005,"percent","Assumed after all losses are included",null,null,"Change in CAPEX",1000,"k$",null,null,null,null,"Value","Unit","COE\n(cents/kWh)","COE %","% of \nCAPEX",null,"Value","Unit","COE\n(cents/kWh)","COE %","% of \nCAPEX","As a percentage based on current breakdown"]
[null,null,"AEP_net (per rotor)",{"$f":"800*8760*D9/1000","v":3924.4800000000005},"MWh / yr","This corresponds to approximately 65% net Capacity Factor at 800 kW",null,null,"Equals change in COE",{"$f":"J9*0.08/D12*100","v":0.50962165688193084},"cents/kWh",null,null,null,"Total",null,null,{"$f":"R12+R19+R21","v":10.672404940111191},{"$f":"R10/$R$10","v":1},null,null,null,null,8,{"$f":"Y12+Y19+Y21","v":1}]
[null,null,"Number of rotors",4,"#"]
[null,null,"AEP_net (C-Plane)",{"$f":"D10*D11","v":15697.920000000002},"MWh / yr",null,null,null,null,null,null,null,null,null,"CAPEX (without margin)",{"$f":"SUM(P13:P17)","v":6486.5082744272368},"k$",{"$f":"CRF*P12/$P$24*100","v":5.8058454665433601},{"$f":"R12/$R$10","v":0.54400535766054536},{"$f":"R12/$R$12","v":1},null,{"$f":"X12*$V$24/CRF/100","v":5148.2303999999995},"k$",{"$f":"Y12*$X$10","v":4.6079999999999997},0.57599999999999996,{"$f":"SUM(Z13:Z17)","v":1},{"$f":"(V12-P12)/P12","v":-0.20631714596022899}]
[null,null,null,null,null,null,null,null,"Change in CAPEX",0.1,"(in precent)",null,null,null,"Platform",{"$f":"'BOM Cost'!$K$4/1000","v":1933.254200785693},"k$",1.7303878546734182,0.16213663784157256,0.29804235483788089,null,2059.29216,"k$",1.8431999999999999,{"$f":"Z13*$Y$12","v":0.23039999999999999},0.4,{"$f":"(V13-P13)/P13","v":6.5194716330156652E-2}]
[null,null,"Capital Recovery Factor",0.08,null,"Corresponds to a 20 year secured loan at around 4% interest rate.",null,null,"Equals change in COE",{"$f":"J13*D17*0.08/D12*100","v":1.5573018590998042},"cents/kWh",null,null,null,"Drivetrain",{"$f":"(2*'BOM Cost'!$K$25/1000)","v":1894.1410396977994},"k$",1.6953790395487081,0.15885632611041506,0.29201242942452788,null,1544.4691199999997,"k$",1.3823999999999999,{"$f":"Z14*$Y$12","v":0.17279999999999998},0.3,-0.18460711867242371]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mooring lines & attachments",{"$f":"'Mooring Cost'!$F$4/1000","v":662.09518681318673},"k$",0.59261811997286773,5.5528076689216548E-2,0.10207266510758443,null,514.82303999999999,"k$",0.46079999999999999,{"$f":"Z15*$Y$12","v":5.7599999999999998E-2},0.1,-0.22243349558549241]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grid connect",{"$f":"'Grid Connection - MW Scale'!$F$3/1000","v":832.06599555414414},"k$",0.74475301406741545,6.9783054358098243E-2,0.12827641010411198,null,720.75225599999987,"k$",0.64512000000000003,{"$f":"Z16*$Y$12","v":8.0640000000000003E-2},0.14000000000000001,-0.13377994071252833]
[null,null,"CAPEX:",30558,"k$","Based on current CAPEX",null,null,"OPEX increase or decrease",null,null,null,null,null,"Misc (assembly & installation)",{"$f":"('Install, Asm, O&M'!$F$9+'Install, Asm, O&M'!$F$16)/1000","v":1164.9518515764134},"k$",1.0427074382809507,9.7701262661242988E-2,0.17959614052589482,null,308.89382399999994,"k$",0.27647999999999995,{"$f":"Z17*$Y$12","v":3.4559999999999994E-2},0.06,-0.73484412803670407]
[null,null,null,null,null,null,null,null,"Change in OPEX",200,"k$ / yr"]
[null,null,"O&M:",775,"k$ / yr","Based on current OPEX (witout tax deduction)",null,null,"Equals change in COE",{"$f":"J18/D12*100","v":1.274054142204827},"cents/kWh",null,null,null,"Gross margin (28%)",{"$f":"(P13+P14+P15)/(1-T19)-(P13+P14+P15)","v":1745.9129439487087},"k$",{"$f":"CRF*P19/$P$24*100","v":1.5627052832980535},{"$f":"R19/$R$10","v":0.1464248491382461},0.28000000000000003,null,{"$f":"X19*$V$24/CRF/100","v":2002.0896},"k$",{"$f":"Y19*$X$10","v":1.792},{"$f":"Y12*Z19/(1-Z19)","v":0.224},0.28000000000000003,{"$f":"(T19-Z19)/T19","v":0}]
[]
[null,null,"COE:",{"$f":"(0.08*D17+D19)/D12*100","v":20.509978392041745},"cents/kWh",null,null,null,"Change in OPEX",0.1,"(in precent)",null,null,null,"O&M",{"$f":"'Install, Asm, O&M'!$F$48/1000","v":295.29518367212239},"k$ / yr",{"$f":"P21/P24*100","v":3.3038541902697767},{"$f":"R21/$R$10","v":0.30956979320120842},null,null,{"$f":"X21*$V$24/100","v":143.00639999999999},"k$ / yr",{"$f":"Y21*$X$10","v":1.6},0.2,null,-0.51571712676903836]
[null,null,null,null,null,null,null,null,"Equals change in COE",{"$f":"J21*D19/D12*100","v":0.49369598010437049},"cents/kWh"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T19*(S12+S21)","v":0.23900104224129107},null,null,null,null,null,{"$f":"100-20-16.128","v":63.872}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AEP_net",{"$f":"AEP!$F$3","v":8937.9},"MWh / yr",null,null,null,null,{"$f":"P24","v":8937.9},"MWh / yr",null,null,null,{"$f":"(V24-P24)/P24","v":0}]
[null,null,null,null,null,null,null,null,"AEP increase or decrease"]
[null,null,null,null,null,null,null,null,"Change in AEP",100,"MWh/yr",null,null,null,"How to use this tool:",null,null,null,null,null,null,null,null,null,"Tips:"]
[null,null,null,null,null,null,null,null,"Equals change in COE",{"$f":"((0.08*D17+D19)/(D12+J26)*100)-((0.08*D17+D19)/D12*100)","v":-0.12982708098307683},"cents/kWh",null,null,null,"1) Set the yellow cells for the Target Breakdown",null,null,null,null,null,null,null,null,null,"After setting the OPEX percentage or profit margin, "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2) Column R gives the \"target\" costs for each sub-element",null,null,null,null,null,null,null,null,null,"click here to adjust CAPEX percentage to get 100%"]
[null,null,null,null,null,null,null,null,"Change in AEP",0.1,"(in precent)",null,null,null,"3) If you want to see the \"Decrease required\" you need to update the yellow cells under \"Current Breakdown\""]
[null,null,null,null,null,null,null,null,"Equals change in COE",{"$f":"((0.08*D17+D19)/(D12*(1+J29))*100)-((0.08*D17+D19)/D12*100)","v":-1.8645434901856142},"cents/kWh"]

{"sheet":"2.4 500 FC Quick COE","index":19,"n_rows":33,"n_cols":27,"rows_kept":33,"cut":false,"hidden":false,"merged":[[5,21,5,26],[7,15,7,19],[7,21,7,25]]}
[]
[null,null,"Quick COE calculation sheet"]
[null,null,"This sheet can be used to make quick calculations of how a change will impact the COE."]
[]
[]
[null,null,"Assumed values:","Value","Unit","Comments",null,null,"Effect of changes",null,null,null,null,null,"Finding COE Targets","Updated:","2011-10-12",null,null,null,null,"Alternative 1"]
[]
[null,null,"Energy Production",null,null,null,null,null,"CAPEX increase or decrease",null,null,null,null,null,null,"Current breakdown",null,null,null,null,null,"Target breakdown",null,null,null,null,"Decrease % Required"]
[null,null,"NET Capacity Factor",0.56000000000000005,"percent","Assumed after all losses are included",null,null,"Change in CAPEX",1000,"k$",null,null,null,null,"Value","Unit","COE\n(cents/kWh)","COE %","% of \nCAPEX",null,"Value","Unit","COE\n(cents/kWh)","COE %","% of \nCAPEX","As a percentage based on current breakdown"]
[null,null,"AEP_net (per rotor)",{"$f":"800*8760*D9/1000","v":3924.4800000000005},"MWh / yr","This corresponds to approximately 65% net Capacity Factor at 800 kW",null,null,"Equals change in COE",{"$f":"J9*0.08/D12*100","v":0.50962165688193084},"cents/kWh",null,null,null,"Total",null,null,{"$f":"R12+R19+R21","v":14.87000900052084},{"$f":"R10/$R$10","v":1},null,null,null,null,8,{"$f":"Y12+Y19+Y21","v":1}]
[null,null,"Number of rotors",4,"#"]
[null,null,"AEP_net (C-Plane)",{"$f":"D10*D11","v":15697.920000000002},"MWh / yr",null,null,null,null,null,null,null,null,null,"CAPEX (without margin)",{"$f":"SUM(P13:P17)","v":6486.5082744272368},"k$",{"$f":"CRF*P12/$P$24*100","v":8.0925571704808696},{"$f":"R12/$R$10","v":0.54422005865614598},{"$f":"R12/$R$12","v":1},null,{"$f":"X12*$V$24/CRF/100","v":3693.4963199999997},"k$",{"$f":"Y12*$X$10","v":4.6079999999999997},0.57599999999999996,{"$f":"SUM(Z13:Z17)","v":1},{"$f":"(V12-P12)/P12","v":-0.43058789664056385}]
[null,null,null,null,null,null,null,null,"Change in CAPEX",0.1,"(in precent)",null,null,null,"Platform",{"$f":"'BOM Cost'!$M$4/1000","v":1933.254200785693},"k$",2.4119247957502967,0.16220062783188741,0.29804235483788089,null,1477.3985280000002,"k$",1.8431999999999999,{"$f":"Z13*$Y$12","v":0.23039999999999999},0.4,{"$f":"(V13-P13)/P13","v":-0.23579706828022343}]
[null,null,"Capital Recovery Factor",0.08,null,"Corresponds to a 20 year secured loan at around 4% interest rate.",null,null,"Equals change in COE",{"$f":"J13*D17*0.08/D12*100","v":1.5573018590998042},"cents/kWh",null,null,null,"Drivetrain",{"$f":"(2*'BOM Cost'!$M$25/1000)","v":1894.1410396977994},"k$",2.3631272796090017,0.15891902146974021,0.29201242942452782,null,1108.048896,"k$",1.3823999999999999,{"$f":"Z14*$Y$12","v":0.17279999999999998},0.3,-0.41501246592662205]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mooring lines & attachments",{"$f":"'Mooring Cost'!$G$4/1000","v":662.09518681318673},"k$",0.82602887792647495,5.5549991792038747E-2,0.10207266510758445,null,369.34963200000004,"k$",0.46079999999999999,{"$f":"Z15*$Y$12","v":5.7599999999999998E-2},0.1,-0.4421502536851793]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grid connect",{"$f":"'Grid Connection - MW Scale'!$G$3/1000","v":832.06599555414414},"k$",1.0380841823915763,6.9810595431059663E-2,0.128276410104112,null,517.08948480000004,"k$",0.64512000000000003,{"$f":"Z16*$Y$12","v":8.0640000000000003E-2},0.14000000000000001,-0.3785475099777082]
[null,null,"CAPEX:",30558,"k$","Based on current CAPEX",null,null,"OPEX increase or decrease",null,null,null,null,null,"Misc (assembly & installation)",{"$f":"('Install, Asm, O&M'!$G$9+'Install, Asm, O&M'!$G$16)/1000","v":1164.9518515764134},"k$",1.4533920348035199,9.7739822131419893E-2,0.17959614052589479,null,221.60977919999996,"k$",0.27647999999999995,{"$f":"Z17*$Y$12","v":3.4559999999999994E-2},0.06,-0.80976915148886419]
[null,null,null,null,null,null,null,null,"Change in OPEX",200,"k$ / yr"]
[null,null,"O&M:",775,"k$ / yr","Based on current OPEX (witout tax deduction)",null,null,"Equals change in COE",{"$f":"J18/D12*100","v":1.274054142204827},"cents/kWh",null,null,null,"Gross margin (28%)",{"$f":"(P13+P14+P15)/(1-T19)-(P13+P14+P15)","v":1745.9129439487087},"k$",{"$f":"CRF*P19/$P$24*100","v":2.1781981485000235},{"$f":"R19/$R$10","v":0.14648263820309251},0.28000000000000003,null,{"$f":"X19*$V$24/CRF/100","v":1436.3596800000003},"k$",{"$f":"Y19*$X$10","v":1.792},{"$f":"Y12*Z19/(1-Z19)","v":0.224},0.28000000000000003,{"$f":"(T19-Z19)/T19","v":0}]
[]
[null,null,"COE:",{"$f":"(0.08*D17+D19)/D12*100","v":20.509978392041745},"cents/kWh",null,null,null,"Change in OPEX",0.1,"(in precent)",null,null,null,"O&M",{"$f":"'Install, Asm, O&M'!$G$48/1000","v":294.91886367212237},"k$ / yr",{"$f":"P21/P24*100","v":4.5992536815399472},{"$f":"R21/$R$10","v":0.30929730314076159},null,null,{"$f":"X21*$V$24/100","v":102.59712000000002},"k$ / yr",{"$f":"Y21*$X$10","v":1.6},0.2,null,-0.65211747148848742]
[null,null,null,null,null,null,null,null,"Equals change in COE",{"$f":"J21*D19/D12*100","v":0.49369598010437049},"cents/kWh"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T19*(S12+S21)","v":0.23898486130313415},null,null,null,null,null,{"$f":"100-20-16.128","v":63.872}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AEP_net",{"$f":"AEP!$G$3","v":6412.3200000000006},"MWh / yr",null,null,null,null,{"$f":"P24","v":6412.3200000000006},"MWh / yr",null,null,null,{"$f":"(V24-P24)/P24","v":0}]
[null,null,null,null,null,null,null,null,"AEP increase or decrease"]
[null,null,null,null,null,null,null,null,"Change in AEP",100,"MWh/yr",null,null,null,"How to use this tool:",null,null,null,null,null,null,null,null,null,"Tips:"]
[null,null,null,null,null,null,null,null,"Equals change in COE",{"$f":"((0.08*D17+D19)/(D12+J26)*100)-((0.08*D17+D19)/D12*100)","v":-0.12982708098307683},"cents/kWh",null,null,null,"1) Set the yellow cells for the Target Breakdown",null,null,null,null,null,null,null,null,null,"After setting the OPEX percentage or profit margin, "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2) Column R gives the \"target\" costs for each sub-element",null,null,null,null,null,null,null,null,null,"click here to adjust CAPEX percentage to get 100%"]
[null,null,null,null,null,null,null,null,"Change in AEP",0.1,"(in precent)",null,null,null,"3) If you want to see the \"Decrease required\" you need to update the yellow cells under \"Current Breakdown\""]
[null,null,null,null,null,null,null,null,"Equals change in COE",{"$f":"((0.08*D17+D19)/(D12*(1+J29))*100)-((0.08*D17+D19)/D12*100)","v":-1.8645434901856142},"cents/kWh"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P11/350","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P12/350","v":18.532880784077818}]

{"sheet":"2.4 350 FC Quick COE","index":20,"n_rows":33,"n_cols":27,"rows_kept":33,"cut":false,"hidden":false,"merged":[[5,21,5,26],[7,15,7,19],[7,21,7,25]]}
[]
[null,null,"Quick COE calculation sheet"]
[null,null,"This sheet can be used to make quick calculations of how a change will impact the COE."]
[]
[]
[null,null,"Assumed values:","Value","Unit","Comments",null,null,"Effect of changes",null,null,null,null,null,"Finding COE Targets","Updated:","2011-10-12",null,null,null,null,"Alternative 1"]
[]
[null,null,"Energy Production",null,null,null,null,null,"CAPEX increase or decrease",null,null,null,null,null,null,"Current breakdown",null,null,null,null,null,"Target breakdown",null,null,null,null,"Decrease % Required"]
[null,null,"NET Capacity Factor",0.56000000000000005,"percent","Assumed after all losses are included",null,null,"Change in CAPEX",1000,"k$",null,null,null,null,"Value","Unit","COE\n(cents/kWh)","COE %","% of \nCAPEX",null,"Value","Unit","COE\n(cents/kWh)","COE %","% of \nCAPEX","As a percentage based on current breakdown"]
[null,null,"AEP_net (per rotor)",{"$f":"800*8760*D9/1000","v":3924.4800000000005},"MWh / yr","This corresponds to approximately 65% net Capacity Factor at 800 kW",null,null,"Equals change in COE",{"$f":"J9*0.08/D12*100","v":0.50962165688193084},"cents/kWh",null,null,null,"Total",null,null,{"$f":"R12+R19+R21","v":13.389924126472684},{"$f":"R10/$R$10","v":1},null,null,null,null,8,{"$f":"Y12+Y19+Y21","v":1}]
[null,null,"Number of rotors",4,"#"]
[null,null,"AEP_net (C-Plane)",{"$f":"D10*D11","v":15697.920000000002},"MWh / yr",null,null,null,null,null,null,null,null,null,"CAPEX (without margin)",{"$f":"SUM(P13:P17)","v":7395.0471336678265},"k$",{"$f":"CRF*P12/$P$24*100","v":7.4253611706469922},{"$f":"R12/$R$10","v":0.55454841271031607},{"$f":"R12/$R$12","v":1},null,{"$f":"X12*$V$24/CRF/100","v":4589.1878399999996},"k$",{"$f":"Y12*$X$10","v":4.6079999999999997},0.57599999999999996,{"$f":"SUM(Z13:Z17)","v":1},{"$f":"(V12-P12)/P12","v":-0.37942412576296386}]
[null,null,null,null,null,null,null,null,"Change in CAPEX",0.1,"(in precent)",null,null,null,"Platform",{"$f":"'BOM Cost'!$O$4/1000","v":2445.7045647417372},"k$",2.4557300828047879,0.18340134414575673,0.33072197114296237,null,1835.6751360000001,"k$",1.8431999999999999,{"$f":"Z13*$Y$12","v":0.23039999999999999},0.4,{"$f":"(V13-P13)/P13","v":-0.24942891203466161}]
[null,null,"Capital Recovery Factor",0.08,null,"Corresponds to a 20 year secured loan at around 4% interest rate.",null,null,"Equals change in COE",{"$f":"J13*D17*0.08/D12*100","v":1.5573018590998042},"cents/kWh",null,null,null,"Drivetrain",{"$f":"(2*'BOM Cost'!$O$25/1000)","v":2043.3759114926711},"k$",2.0517521898075604,0.15323105421868097,0.27631682050945755,null,1376.7563519999999,"k$",1.3823999999999999,{"$f":"Z14*$Y$12","v":0.17279999999999998},0.3,-0.32623442203823894]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mooring lines & attachments",{"$f":"'Mooring Cost'!$H$4/1000","v":662.09518681318673},"k$",0.66480927066065887,4.9649965480109859E-2,8.9532247035834386E-2,null,458.91878400000002,"k$",0.46079999999999999,{"$f":"Z15*$Y$12","v":5.7599999999999998E-2},0.1,-0.30686887151546971]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grid connect",{"$f":"'Grid Connection - MW Scale'!$H$3/1000","v":1037.8174468085108},"k$",1.0420717045423047,7.7825064182556969E-2,0.14033953104687918,null,642.48629760000006,"k$",0.64512000000000003,{"$f":"Z16*$Y$12","v":8.0640000000000003E-2},0.14000000000000001,-0.38092551866826907]
[null,null,"CAPEX:",30558,"k$","Based on current CAPEX",null,null,"OPEX increase or decrease",null,null,null,null,null,"Misc (assembly & installation)",{"$f":"('Install, Asm, O&M'!$H$9+'Install, Asm, O&M'!$H$16)/1000","v":1206.0540238117203},"k$",1.2109979228316807,9.0440984683211545E-2,0.16308943026486658,null,275.35127039999998,"k$",0.27647999999999995,{"$f":"Z17*$Y$12","v":3.4559999999999994E-2},0.06,-0.77169242424998896]
[null,null,null,null,null,null,null,null,"Change in OPEX",200,"k$ / yr"]
[null,null,"O&M:",775,"k$ / yr","Based on current OPEX (witout tax deduction)",null,null,"Equals change in COE",{"$f":"J18/D12*100","v":1.274054142204827},"cents/kWh",null,null,null,"Gross margin (28%)",{"$f":"(P13+P14+P15)/(1-T19)-(P13+P14+P15)","v":2003.2349800740649},"k$",{"$f":"CRF*P19/$P$24*100","v":2.0114467112728365},{"$f":"R19/$R$10","v":0.15022091927287964},0.28000000000000003,null,{"$f":"X19*$V$24/CRF/100","v":1784.68416},"k$",{"$f":"Y19*$X$10","v":1.792},{"$f":"Y12*Z19/(1-Z19)","v":0.224},0.28000000000000003,{"$f":"(T19-Z19)/T19","v":0}]
[]
[null,null,"COE:",{"$f":"(0.08*D17+D19)/D12*100","v":20.509978392041745},"cents/kWh",null,null,null,"Change in OPEX",0.1,"(in precent)",null,null,null,"O&M",{"$f":"'Install, Asm, O&M'!$H$48/1000","v":314.95821179875742},"k$ / yr",{"$f":"P21/P24*100","v":3.9531162445528545},{"$f":"R21/$R$10","v":0.29523066801680425},null,null,{"$f":"X21*$V$24/100","v":127.47744},"k$ / yr",{"$f":"Y21*$X$10","v":1.6},0.2,null,-0.59525602056233506]
[null,null,null,null,null,null,null,null,"Equals change in COE",{"$f":"J21*D19/D12*100","v":0.49369598010437049},"cents/kWh"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T19*(S12+S21)","v":0.23793814260359372},null,null,null,null,null,{"$f":"100-20-16.128","v":63.872}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AEP_net",{"$f":"AEP!$H$3","v":7967.34},"MWh / yr",null,null,null,null,{"$f":"P24","v":7967.34},"MWh / yr",null,null,null,{"$f":"(V24-P24)/P24","v":0}]
[null,null,null,null,null,null,null,null,"AEP increase or decrease"]
[null,null,null,null,null,null,null,null,"Change in AEP",100,"MWh/yr",null,null,null,"How to use this tool:",null,null,null,null,null,null,null,null,null,"Tips:"]
[null,null,null,null,null,null,null,null,"Equals change in COE",{"$f":"((0.08*D17+D19)/(D12+J26)*100)-((0.08*D17+D19)/D12*100)","v":-0.12982708098307683},"cents/kWh",null,null,null,"1) Set the yellow cells for the Target Breakdown",null,null,null,null,null,null,null,null,null,"After setting the OPEX percentage or profit margin, "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2) Column R gives the \"target\" costs for each sub-element",null,null,null,null,null,null,null,null,null,"click here to adjust CAPEX percentage to get 100%"]
[null,null,null,null,null,null,null,null,"Change in AEP",0.1,"(in precent)",null,null,null,"3) If you want to see the \"Decrease required\" you need to update the yellow cells under \"Current Breakdown\""]
[null,null,null,null,null,null,null,null,"Equals change in COE",{"$f":"((0.08*D17+D19)/(D12*(1+J29))*100)-((0.08*D17+D19)/D12*100)","v":-1.8645434901856142},"cents/kWh"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P12/350","v":21.128706096193792}]

{"sheet":"Pie Chart","index":21,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}