{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["System","Module","Inverter","ESS","SBOS","EBOS","Fieldwork","Officework","Other","O_M","Factors","Guide"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":98,"comments":10,"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":"System","index":0,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,3,1,5],[4,0,6,5],[1,0,1,1]]}
["System"]
["System Size",null,"Filename:","UPV Q12023",null,null,null,null,"Input Value"]
[100000,"kWdc",null,null,null,null,null,null,"Model Definition"]
[null,null,null,null,null,null,null,null,"Formula"]
["Single Axis Tracking, c-Si modules, central inverter",null,null,null,null,null,null,null,"Calculated"]
[null,null,null,null,null,null,"Include ESS:",true]
[null,null,null,null,null,null,"Include Indirect:",true]
[]
["Component","Description","Intrinsic Unit","Cost per  Intrinsic Unit",{"$f":"CONCATENATE(\"Intrinsic Units per \",B3)","v":"Intrinsic Units per kWdc"},{"$f":"CONCATENATE(\"Cost Element per \",$B$3)","v":"Cost Element per kWdc"},"Distorted per\nUnit Cost",{"$f":"CONCATENATE(\"Price Element per \",$B$3)","v":"Price Element per kWdc"}]
["Module","Avg. Sales Price",{"$f":"ModuleUnit","v":"kWdc"},{"$f":"ModuleMSP","v":253.13610505700856},1,{"$f":"E10*D10","v":253.13610505700856},{"$f":"ModuleMMP","v":372.25612350272144},{"$f":"IF(G10<>\"\",G10*E10,D10*E10)","v":372.25612350272144}]
["Inverter","Avg. Sales Price",{"$f":"InverterUnit","v":"kWac"},{"$f":"InverterMSP","v":46.899723866117633},{"$f":"1/ILR","v":0.74626865671641784},{"$f":"E11*D11","v":34.999793929938527},{"$f":"InverterMMP","v":64.919111694571427},{"$f":"IF(G11<>\"\",G11*E11,D11*E11)","v":48.447098279530913}]
["ESS","Energy Storage",{"$f":"ESSUnit","v":"kWh-cap"},{"$f":"ESSMSP","v":218.77230446152939},{"$f":"IncludeESS*StorageDuration","v":2.4},525.05353070767046,{"$f":"ESSMMP-4.8495","v":318.32858738973329},763.98860973535989]
["SBOS","Structural BOS",{"$f":"SBOSUnit","v":"m2"},{"$f":"SBOSMSP","v":28.251570086333295},{"$f":"1/ModuleEfficiency","v":4.8780487804878048},137.81253700650387,{"$f":"SBOSMMP","v":28.032113993032059},136.74201947820515]
["EBOS","Electrical BOS",{"$f":"EBOSUnit","v":"kWac"},{"$f":"EBOSMSP","v":196.02961572950002},{"$f":"1/ILR","v":0.74626865671641784},146.29075800708955,{"$f":"EBOSMMP","v":235.53989409950003},175.7760403727612]
["Fieldwork","Labor&Related",{"$f":"FieldworkUnit","v":"m2"},{"$f":"FieldworkMSP","v":60.555988952000007},{"$f":"1/ModuleEfficiency","v":4.8780487804878048},295.39506805853659,{"$f":"FieldworkMMP","v":60.555988952000007},295.39506805853659]
["Officework","Labor&Related",{"$f":"OfficeworkUnit","v":"kWdc"},{"$f":"OfficeworkMSP","v":62.778714662954854},{"$f":"IncludeIndirect*1","v":1},62.778714662954854,{"$f":"OfficeworkMMP","v":66.094812223930461},66.094812223930461]
["Other","Financial, etc.",{"$f":"OtherUnit","v":"kWdc"},{"$f":"OtherMSP","v":190.64352926422225},{"$f":"IncludeIndirect*1","v":1},190.64352926422225,{"$f":"OtherMMP","v":247.20420756115669},247.20420756115669]
[null,null,null,null,null,0,null,{"$f":"IF(G18<>\"\",G18*E18,D18*E18)","v":0}]
[null,null,null,null,null,0,null,0]
[null,null,null,null,"MSP:",{"$f":"SUM(F10:F19)","v":1646.1100366939245},"MMP:",{"$f":"SUM(H10:H19)","v":2105.9039792122021}]

{"sheet":"Module","index":1,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,0,1,1],[4,0,6,5]]}
["Module"]
["Annual Production",null,null,null,null,null,null,null,"Input Value"]
[1500000,"kWdc",null,null,null,null,null,null,"Model Definition"]
[null,null,null,null,null,null,null,null,"Formula"]
["530 Wdc bifacial c-Si PERC module assembled in SE Asia using cells from SE Asia",null,null,null,null,null,null,null,"Calculated"]
[]
[]
[]
["Cost Element","Fixed Cost\nper Year","Intrinsic Unit","Cost per  Intrinsic Unit",{"$f":"CONCATENATE(\"Intrinsic Units per \",B3)","v":"Intrinsic Units per kWdc"},{"$f":"CONCATENATE(\"Cost Element per \",$B$3)","v":"Cost Element per kWdc"},"Distorted per\nUnit Cost",{"$f":"CONCATENATE(\"Price Element per \",$B$3)","v":"Price Element per kWdc"}]
["Cells",null,"kWdc",121.57769999999999,{"$f":"1/CellToModule","v":1.0204081632653061},{"$f":"B10/$A$3+E10*D10","v":124.0588775510204},172.55,{"$f":"IF(G10<>\"\",B10/$A$3+G10*E10,B10/$A$3+D10*E10)","v":176.07142857142858}]
["Frame",null,"m",1.6023000000000001,{"$f":"2*(ModuleWidth+ModuleHeight)/(ModuleWidth*ModuleHeight*ModuleEfficiency)","v":12.931554990962178},20.720230562018699,null,{"$f":"IF(G11<>\"\",B11/$A$3+G11*E11,B11/$A$3+D11*E11)","v":20.720230562018699}]
["Junction Box",null,"module",3.3986999999999998,{"$f":"1/(ModuleEfficiency*ModuleHeight*ModuleWidth)","v":1.9016992633767904},6.4633052864386968,null,6.4633052864386968]
["Other Material",null,"m2",9.0503999999999998,{"$f":"1/ModuleEfficiency","v":4.8780487804878048},44.148292682926829,null,44.148292682926829]
["Labor",951646.41940000001,"hour",2.5247999999999999,{"$f":"ModuleLabor/ModuleEfficiency","v":0.53170731707317076},1.9768855804130081,null,1.9768855804130081]
["Electricity",null,"kWh",7.2800000000000004E-2,{"$f":"IncludeIndirect*ModuleElectricity/ModuleEfficiency","v":28.243902439024392},2.0561560975609758,null,2.0561560975609758]
["Depreciation",null,"kWdc",5.6418999999999997,{"$f":"IncludeIndirect*1","v":1},5.6418999999999997,null,5.6418999999999997]
["Maintenance",null,"kWdc",0.87780000000000002,{"$f":"IncludeIndirect*1","v":1},0.87780000000000002,null,0.87780000000000002]
["Profit",null,"kWdc",{"$f":"0.15/(1-0.15)*SUM(F11:F17)","v":14.450218272239681},{"$f":"IncludeIndirect*1","v":1},14.450218272239681,{"$f":"0.499/(1-0.499)*SUM(H11:H17)","v":81.557685697544386},81.557685697544386]
["Shipping",null,"kg",0.62150000000000005,{"$f":"IncludeIndirect*ModuleWeight/ModuleEfficiency","v":52.682926829268297},32.742439024390251,null,32.742439024390251]
[null,null,null,null,"MSP:",{"$f":"SUM(F10:F19)","v":253.13610505700856},"MMP:",{"$f":"SUM(H10:H19)","v":372.25612350272144}]

{"sheet":"Inverter","index":2,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,0,1,1],[4,0,6,5]]}
["Inverter"]
["Annual Production",null,null,null,null,null,null,null,"Input Value"]
[1000000,"kWac",null,null,null,null,null,null,"Model Definition"]
[null,null,null,null,null,null,null,null,"Formula"]
["4 MWac utility-scale three-phase central inverter",null,null,null,null,null,null,null,"Calculated"]
[]
[]
[]
["Cost Element","Fixed Cost\nper Year","Intrinsic Unit","Cost per  Intrinsic Unit",{"$f":"CONCATENATE(\"Intrinsic Units per \",B3)","v":"Intrinsic Units per kWac"},{"$f":"CONCATENATE(\"Cost Element per \",$B$3)","v":"Cost Element per kWac"},"Distorted per\nUnit Cost",{"$f":"CONCATENATE(\"Price Element per \",$B$3)","v":"Price Element per kWac"}]
["Power Devices",null,"kWac",19.421399999999998,1,{"$f":"B10/$A$3+E10*D10","v":19.421399999999998},21.363499999999998,{"$f":"IF(G10<>\"\",B10/$A$3+G10*E10,B10/$A$3+D10*E10)","v":21.363499999999998}]
["Rest of Inverter",null,"kWac",9.7106999999999992,1,9.7106999999999992,11.652799999999999,{"$f":"IF(G11<>\"\",B11/$A$3+G11*E11,B11/$A$3+D11*E11)","v":11.652799999999999}]
["Packaging",null,"kWac",4.8552999999999997,1,4.8552999999999997,6.7975000000000003,6.7975000000000003]
["Labor",922514.38619999995,"hour",38.677599999999998,{"$f":"InverterLabor","v":5.5E-2},3.0497823862,null,3.0497823862]
["Electricity",null,"kWh",7.6799999999999993E-2,{"$f":"IncludeIndirect*InverterElectricity","v":8.42},0.6466559999999999,null,0.6466559999999999]
["Depreciation",null,"kWac",0.67969999999999997,{"$f":"IncludeIndirect*1","v":1},0.67969999999999997,null,0.67969999999999997]
["Maintenance",null,"kWac",9.7100000000000006E-2,{"$f":"IncludeIndirect*1","v":1},9.7100000000000006E-2,null,9.7100000000000006E-2]
["Profit",null,"kWac",{"$f":"0.15/(1-0.15)*SUM(F10:F16)","v":6.7871714799176459},{"$f":"IncludeIndirect*1","v":1},6.7871714799176459,{"$f":"0.3/(1-0.3)*SUM(H10:H16)","v":18.980159308371427},18.980159308371427]
["Shipping",null,"kg",0.33989999999999998,{"$f":"IncludeIndirect* InverterWeight","v":4.8600000000000003},1.6519140000000001,null,1.6519140000000001]
[null,null,null,null,null,0,null,0]
[null,null,null,null,"MSP:",{"$f":"SUM(F10:F19)","v":46.899723866117633},"MMP:",{"$f":"SUM(H10:H19)","v":64.919111694571427}]

{"sheet":"ESS","index":3,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,0,1,1],[4,0,6,5]]}
["ESS"]
["Annual Production",null,null,null,null,null,null,null,"Input Value"]
[1000000,"kWh-cap",null,null,null,null,null,null,"Model Definition"]
[null,null,null,null,null,null,null,null,"Formula"]
["3 MWhac, 750 kWac, ac-coupled pad-mounted battery cabinets",null,null,null,null,null,null,null,"Calculated"]
[]
[]
[]
["Cost Element","Fixed Cost\nper Year","Intrinsic Unit","Cost per  Intrinsic Unit",{"$f":"CONCATENATE(\"Intrinsic Units per \",B3)","v":"Intrinsic Units per kWh-cap"},{"$f":"CONCATENATE(\"Cost Element per \",$B$3)","v":"Cost Element per kWh-cap"},"Distorted per\nUnit Cost",{"$f":"CONCATENATE(\"Price Element per \",$B$3)","v":"Price Element per kWh-cap"}]
["Li-Ion Cells",null,"kWh-cap",87.396100000000004,1,{"$f":"B10/$A$3+E10*D10","v":87.396100000000004},116.52809999999999,{"$f":"IF(G10<>\"\",B10/$A$3+G10*E10,B10/$A$3+D10*E10)","v":116.52809999999999}]
["Racks with BMS",null,"kWh-cap",29.132000000000001,1,29.132000000000001,48.553400000000003,{"$f":"IF(G11<>\"\",B11/$A$3+G11*E11,B11/$A$3+D11*E11)","v":48.553400000000003}]
["Rest of Container",null,"kWh-cap",36.900599999999997,1,36.900599999999997,40.784799999999997,40.784799999999997]
["Bi- Inverter",null,"kWac",67.974699999999999,{"$f":"1/( BatteryDuration* ESS_ILR)","v":0.25},16.993675,{"$f":"D13*(1+Tariff301)","v":84.968374999999995},21.242093749999999]
["Labor",2621882.9923,"hour",38.677599999999998,{"$f":" ESSLabor","v":0.188},9.8932717923000002,null,9.8932717923000002]
["Electricity",null,"kWh",7.6799999999999993E-2,{"$f":"IncludeIndirect*ESSElectricity","v":36.700000000000003},2.8185600000000002,null,2.8185600000000002]
["Depreciation",null,"kWh-cap",0.54379999999999995,{"$f":"IncludeIndirect*1","v":1},0.54379999999999995,null,0.54379999999999995]
["Maintenance",null,"kWh-cap",7.7700000000000005E-2,{"$f":"IncludeIndirect*1","v":1},7.7700000000000005E-2,null,7.7700000000000005E-2]
["Profit",null,"kWh-cap",{"$f":"0.15/(1-0.15)*SUM(F10:F17)","v":32.427477669229411},{"$f":"IncludeIndirect*1","v":1},32.427477669229411,{"$f":"0.25/(1-0.25)*SUM(H10:H17)","v":80.147241847433321},80.147241847433321]
["Shipping",null,"kg",0.41760000000000003,{"$f":"IncludeIndirect*ESSWeight","v":6.2},2.5891200000000003,null,2.5891200000000003]
[null,null,null,null,"MSP:",{"$f":"SUM(F10:F19)","v":218.77230446152939},"MMP:",{"$f":"SUM(H10:H19)","v":323.17808738973326}]

{"sheet":"SBOS","index":4,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,0,1,1],[4,0,6,5]]}
["SBOS"]
[{"$f":"System!A2","v":"System Size"},null,null,null,null,null,null,null,"Input Value"]
[{"$f":"SystemSize/ModuleEfficiency","v":487804.87804878049},"m2",null,null,null,null,null,null,"Model Definition"]
[null,null,null,null,null,null,null,null,"Formula"]
["Single-axis tracking installed in-the-field",null,null,null,null,null,null,null,"Calculated"]
[]
[]
[]
["Cost Element","Fixed Cost\nper System","Intrinsic Unit","Cost per  Intrinsic Unit",{"$f":"CONCATENATE(\"Intrinsic Units per \",B3)","v":"Intrinsic Units per m2"},{"$f":"CONCATENATE(\"Cost Element per \",$B$3)","v":"Cost Element per m2"},"Distorted per\nUnit Cost",{"$f":"CONCATENATE(\"Price Element per \",$B$3)","v":"Price Element per m2"}]
["Torque Tubes",null,"kg",{"$f":"2.1725+0.87/2","v":2.6074999999999999},{"$f":"TorqueTubeWeight","v":4.8},{"$f":"B10/$A$3+E10*D10","v":12.516},2.1848999999999998,{"$f":"IF(G10<>\"\",B10/$A$3+G10*E10,B10/$A$3+D10*E10)","v":10.487519999999998}]
["Driven Piers",null,"pier",58.264099999999999,{"$f":"PiersPerRow/(RowLength*ModuleHeight)","v":5.615081086875514E-2},3.2715764595382364,null,{"$f":"IF(G11<>\"\",B11/$A$3+G11*E11,B11/$A$3+D11*E11)","v":3.2715764595382364}]
["Module Rails",null,"m",1.9420999999999999,{"$f":"1/ModuleWidth","v":0.88495575221238942},1.7186725663716815,{"$f":"D12*(1+Tariff301)","v":2.4276249999999999},2.1483407079646017]
["Fasteners",null,"kg",{"$f":"0.92*2.18 + 0.08*(2.18 + 2.28/2)","v":2.2712000000000003},{"$f":"FastenerWeight","v":0.2},0.45424000000000009,2.1848999999999998,0.43697999999999998]
["Slew Drive",null,"row",339.87369999999999,{"$f":"1/(ModuleHeight*RowLength)","v":5.1046191698868306E-3},1.7349258043603657,{"$f":"D14*(1+Tariff301)","v":424.84212500000001},2.1686572554504573]
["Dampers",null,"pier",6.7975000000000003,{"$f":"PiersPerRow/(RowLength*ModuleHeight)","v":5.615081086875514E-2},0.3816851368803631,{"$f":"D15*(1+Tariff301)","v":8.4968750000000011},0.47710642110045387]
["Motor",null,"row",534.08730000000003,{"$f":"1/(ModuleHeight*RowLength)","v":5.1046191698868306E-3},2.7263122699730986,{"$f":"D16*(1+Tariff301)","v":667.60912500000006},3.4078903374663736]
["Control Electronics",null,"row",145.6602,{"$f":"1/(ModuleHeight*RowLength)","v":5.1046191698868306E-3},0.74353984920954974,{"$f":"D17*(1+Tariff301)","v":182.07525000000001},0.92942481151193723]
["Shipping",null,"kg",0.2913,{"$f":"IncludeIndirect*SBOSshippingWeight","v":10},2.9130000000000003,null,2.9130000000000003]
["ESS Pad",null,"kWh-cap",3.6415000000000002,{"$f":"IncludeESS*StorageDuration*ModuleEfficiency","v":0.49199999999999994},{"$f":"B19/$A$3+E19*D19","v":1.7916179999999999},null,1.7916179999999999]
[null,null,null,null,"MSP:",{"$f":"SUM(F10:F19)","v":28.251570086333295},"MMP:",{"$f":"SUM(H10:H19)","v":28.032113993032059}]

{"sheet":"EBOS","index":5,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,0,1,1],[4,0,6,5]]}
["EBOS"]
[{"$f":"System!A2","v":"System Size"},null,null,null,null,null,null,null,"Input Value"]
[{"$f":"SystemSize/ILR","v":74626.86567164179},"kWac",null,null,null,null,null,null,"Model Definition"]
[null,null,null,null,null,null,null,null,"Formula"]
[null,null,null,null,null,null,null,null,"Calculated"]
[]
[]
[]
["Cost Element","Fixed Cost\nper System","Intrinsic Unit","Cost per  Intrinsic Unit",{"$f":"CONCATENATE(\"Intrinsic Units per \",B3)","v":"Intrinsic Units per kWac"},{"$f":"CONCATENATE(\"Cost Element per \",$B$3)","v":"Cost Element per kWac"},"Distorted per\nUnit Cost",{"$f":"CONCATENATE(\"Price Element per \",$B$3)","v":"Price Element per kWac"}]
["Transformers",null,"kWac",35.638199999999998,1,{"$f":"B10/$A$3+E10*D10","v":35.638199999999998},{"$f":"D10*(1+8.99%)","v":38.842074179999997},{"$f":"IF(G10<>\"\",B10/$A$3+G10*E10,B10/$A$3+D10*E10)","v":38.842074179999997}]
["Switches",null,"kWac",8.3512000000000004,1,8.3512000000000004,{"$f":"D11*(1+Tariff301+20.32%)","v":12.135963840000001},{"$f":"IF(G11<>\"\",B11/$A$3+G11*E11,B11/$A$3+D11*E11)","v":12.135963840000001}]
["Breakers",null,"kWac",16.702400000000001,1,16.702400000000001,{"$f":"D12*(1+Tariff301+20.32%)","v":24.271927680000001},24.271927680000001]
["Conductors",null,"kWac",14.2456,1,14.2456,{"$f":"D13*(1+8.99%)","v":15.526279440000001},15.526279440000001]
["Combiner Boxes",null,"kWac",8.3512000000000004,1,8.3512000000000004,{"$f":"D14*(1+Tariff301+20.32%)","v":12.135963840000001},12.135963840000001]
["Grounding",null,"kWac",10.6915,1,10.6915,{"$f":"D15*(1+8.99%)","v":11.65266585},11.65266585]
["Substation",null,"kWac",29.238900000000001,1,29.238900000000001,{"$f":"D16*(1+Tariff301+20.32%)","v":42.489969480000006},42.489969480000006]
["Transmission",679747.4425,"kWac",9.7106999999999992,{"$f":"IncludeIndirect*1","v":1},18.819315729499998,{"$f":"D17*(1+8.99%)","v":10.583691930000001},19.692307659500003]
["Network Upgrade",null,"kWac",53.408700000000003,{"$f":"IncludeIndirect*1","v":1},53.408700000000003,{"$f":"D18*(1+8.99%)","v":58.210142130000008},58.210142130000008]
["Shipping",null,"kg",0.2913,{"$f":"IncludeIndirect*EBOSweight","v":2},0.58260000000000001,null,0.58260000000000001]
[null,null,null,null,"MSP:",{"$f":"SUM(F10:F19)","v":196.02961572950002},"MMP:",{"$f":"SUM(H10:H19)","v":235.53989409950003}]

{"sheet":"Fieldwork","index":6,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,0,1,1],[4,0,6,5]]}
["Fieldwork"]
[{"$f":"System!A2","v":"System Size"},null,null,null,null,null,null,null,"Input Value"]
[{"$f":"SystemSize/ModuleEfficiency","v":487804.87804878049},"m2",null,null,null,null,null,null,"Model Definition"]
[null,null,null,null,null,null,null,null,"Formula"]
[null,null,null,null,null,null,null,null,"Calculated"]
[]
[]
[]
["Cost Element","Fixed Cost\nper System","Intrinsic Unit","Cost per  Intrinsic Unit",{"$f":"CONCATENATE(\"Intrinsic Units per \",B3)","v":"Intrinsic Units per m2"},{"$f":"CONCATENATE(\"Cost Element per \",$B$3)","v":"Cost Element per m2"},"Distorted per\nUnit Cost",{"$f":"CONCATENATE(\"Price Element per \",$B$3)","v":"Price Element per m2"}]
["EBOS Labor",null,"hour",28.034700000000001,{"$f":"PVElectricalLabor","v":0.35},{"$f":"B10/$A$3+E10*D10","v":9.8121449999999992},null,{"$f":"IF(G10<>\"\",B10/$A$3+G10*E10,B10/$A$3+D10*E10)","v":9.8121449999999992}]
["SBOS Labor",null,"hour",17.634599999999999,{"$f":"PVConstructionLabor","v":0.75},13.225949999999999,null,{"$f":"IF(G11<>\"\",B11/$A$3+G11*E11,B11/$A$3+D11*E11)","v":13.225949999999999}]
["ESS Labor",null,"hour",22.839500000000001,{"$f":"IncludeESS*ESSInstallLabor*StorageDuration*ModuleEfficiency","v":0.34439999999999998},7.8659238,null,7.8659238]
["Labor Burden",null,"m2",{"$f":"SUM(F10:F12)*LaborBurdenRate","v":16.688170152000001},1,16.688170152000001,{"$f":"SUM(H10:H12)*LaborBurdenRate","v":16.688170152000001},16.688170152000001]
["Site Prep",null,"m2",0.24279999999999999,{"$f":"IncludeIndirect*1","v":1},0.24279999999999999,null,0.24279999999999999]
["Eqpmt Rental",null,"m2",10.7789,{"$f":"IncludeIndirect*1","v":1},10.7789,null,10.7789]
["Inspection",null,"m2",1.9420999999999999,{"$f":"IncludeIndirect*1","v":1},1.9420999999999999,null,1.9420999999999999]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,"MSP:",{"$f":"SUM(F10:F19)","v":60.555988952000007},"MMP:",{"$f":"SUM(H10:H19)","v":60.555988952000007}]

{"sheet":"Officework","index":7,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,0,1,1],[4,0,6,5]]}
["Officework"]
[{"$f":"System!A2","v":"System Size"},null,null,null,null,null,null,null,"Input Value"]
[{"$f":"SystemSize","v":100000},"kWdc",null,null,null,null,null,null,"Model Definition"]
[null,null,null,null,null,null,null,null,"Formula"]
["All costs on this sheet are Indirect costs",null,null,null,null,null,null,null,"Calculated"]
[]
[]
[]
["Cost Element","Fixed Cost\nper System","Intrinsic Unit","Cost per  Intrinsic Unit",{"$f":"CONCATENATE(\"Intrinsic Units per \",B3)","v":"Intrinsic Units per kWdc"},{"$f":"CONCATENATE(\"Cost Element per \",$B$3)","v":"Cost Element per kWdc"},"Distorted per\nUnit Cost",{"$f":"CONCATENATE(\"Price Element per \",$B$3)","v":"Price Element per kWdc"}]
["Warehousing",null,"m2",0.67969999999999997,{"$f":"1/ModuleEfficiency","v":4.8780487804878048},{"$f":"B10/$A$3+E10*D10","v":3.3156097560975608},1.3594999999999999,{"$f":"IF(G10<>\"\",B10/$A$3+G10*E10,B10/$A$3+D10*E10)","v":6.63170731707317}]
["Logistics",null,"kg",9.7100000000000006E-2,{"$f":"ModuleWeight/ModuleEfficiency","v":52.682926829268297},{"$f":"B11/$A$3+E11*D11","v":5.1155121951219522},null,{"$f":"IF(G11<>\"\",B11/$A$3+G11*E11,B11/$A$3+D11*E11)","v":5.1155121951219522}]
["Engineering",121383.4719,"m2",2.9131999999999998,{"$f":"1/ModuleEfficiency","v":4.8780487804878048},15.424566426317071,null,15.424566426317071]
["Permits",203924.23269999999,"kWac",null,{"$f":"1/ILR","v":0.74626865671641784},2.0392423269999997,null,2.0392423269999997]
["Interconnect",97106.777499999997,"kWac",39.172899999999998,{"$f":"1/ILR","v":0.74626865671641784},30.204575237686566,null,30.204575237686566]
["Outreach",194213.55499999999,"m2",0.97109999999999996,{"$f":"1/ModuleEfficiency","v":4.8780487804878048},6.6792087207317064,null,6.6792087207317064]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,"MSP:",{"$f":"SUM(F10:F19)","v":62.778714662954854},"MMP:",{"$f":"SUM(H10:H19)","v":66.094812223930461}]

{"sheet":"Other","index":8,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,0,1,1],[4,0,6,5]]}
["Other"]
["Annual Installations",null,null,null,null,null,null,null,"Input Value"]
[100000,"kWdc",null,null,null,null,null,null,"Model Definition"]
[null,null,null,null,null,null,null,null,"Formula"]
["All costs on this sheet are Indirect costs",null,null,null,null,null,null,null,"Calculated"]
[]
[]
[]
["Cost Element","Fixed Cost\nper Year","Intrinsic Unit","Cost per  Intrinsic Unit",{"$f":"CONCATENATE(\"Intrinsic Units per \",B3)","v":"Intrinsic Units per kWdc"},{"$f":"CONCATENATE(\"Cost Element per \",$B$3)","v":"Cost Element per kWdc"},"Distorted per\nUnit Cost",{"$f":"CONCATENATE(\"Price Element per \",$B$3)","v":"Price Element per kWdc"}]
["Sales Tax",null,"kWdc",{"$f":"(SysModuleMSP+SysInverterMSP+SysESSMSP+SysSBOSMSP+SysEBOSMSP)*SalesTaxRate","v":63.64297803307624},1,{"$f":"B10/$A$3+E10*D10","v":63.64297803307624},{"$f":"(SysModuleMMP+SysInverterMMP+SysESSMMP+SysSBOSMMP+SysEBOSMMP)*SalesTaxRate","v":86.838173699377549},{"$f":"IF(G10<>\"\",B10/$A$3+G10*E10,B10/$A$3+D10*E10)","v":86.838173699377549}]
["Contingency",null,"kWdc",{"$f":"(SysModuleMSP+SysInverterMSP+SysESSMSP+SysSBOSMSP+SysEBOSMSP+SysFieldworkMSP+SysOfficeworkMSP)*ContingencyRate","v":21.831997611445534},1,21.831997611445534,{"$f":"(SysModuleMMP+SysInverterMMP+SysESSMMP+SysSBOSMMP+SysEBOSMMP+SysFieldworkMMP+SysOfficeworkMMP)*ContingencyRate","v":27.880496574765676},{"$f":"IF(G11<>\"\",B11/$A$3+G11*E11,B11/$A$3+D11*E11)","v":27.880496574765676}]
["Management",534087,"kWdc",{"$f":"(SysModuleMSP+SysInverterMSP+SysESSMSP+SysSBOSMSP+SysEBOSMSP+SysFieldworkMSP+SysOfficeworkMSP)*OverheadRate","v":21.831997611445534},1,27.172867611445533,{"$f":"(SysModuleMMP+SysInverterMMP+SysESSMMP+SysSBOSMMP+SysEBOSMMP+SysFieldworkMMP+SysOfficeworkMMP)*OverheadRate","v":27.880496574765676},33.221366574765675]
["Profit",194214,"kWdc",{"$f":"( SysModuleMSP+ SysInverterMSP+ SysESSMSP+ SysSBOSMSP+ SysEBOSMSP+ SysFieldworkMSP+ SysOfficeworkMSP+SUM(F10:F12))* ProfitRate","v":76.053546008254969},1,77.995686008254964,{"$f":"(SysModuleMMP+SysInverterMMP+SysESSMMP+SysSBOSMMP+SysEBOSMMP+SysFieldworkMMP+SysOfficeworkMMP+SUM(H10:H12))*ProfitRate","v":97.322030712247781},99.264170712247775]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,{"$f":"B19/$A$3+E19*D19","v":0},null,0]
[null,null,null,null,"MSP:",{"$f":"SUM(F10:F19)","v":190.64352926422225},"MMP:",{"$f":"SUM(H10:H19)","v":247.20420756115669}]

{"sheet":"O_M","index":9,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,0,1,1],[4,0,6,5]]}
["O_M","Operation and Maintenance"]
["System Size",null,null,null,null,null,null,null,"Input Value"]
[100000,"kWdc",null,null,null,null,null,null,"Model Definition"]
[null,null,null,null,null,null,null,null,"Formula"]
[null,null,null,null,null,null,null,null,"Calculated"]
[]
[]
[]
["Cost Element","Fixed Cost\nper Year","Intrinsic Unit","Cost per  Intrinsic Unit",{"$f":"CONCATENATE(\"Intrinsic Units per \",B3,\"-yr\")","v":"Intrinsic Units per kWdc-yr"},{"$f":"CONCATENATE(\"Cost Element per \",$B$3,\"-yr\")","v":"Cost Element per kWdc-yr"},"Distorted per\nUnit Cost",{"$f":"CONCATENATE(\"Price Element per \",$B$3,\"-yr\")","v":"Price Element per kWdc-yr"}]
["Cleaning",null,"m2-yr",0.51,{"$f":"IncludeIndirect/ModuleEfficiency","v":4.8780487804878048},{"$f":"B10/$A$3+E10*D10","v":2.4878048780487805},null,{"$f":"IF(G10<>\"\",B10/$A$3+G10*E10,B10/$A$3+D10*E10)","v":2.4878048780487805}]
["Inspection",null,"m2-yr",0.31,{"$f":"IncludeIndirect/ModuleEfficiency","v":4.8780487804878048},1.5121951219512195,null,{"$f":"IF(G11<>\"\",B11/$A$3+G11*E11,B11/$A$3+D11*E11)","v":1.5121951219512195}]
["New BOS",null,"m2-yr",{"$f":"SysSBOSMSP*PartsLossRate","v":0.27562507401300773},{"$f":"1/ModuleEfficiency","v":4.8780487804878048},1.3445125561610134,null,1.3445125561610134]
["New Modules",null,"kWdc-yr",{"$f":"SysModuleMSP*ModuleLossRate","v":0.25313610505700856},1,0.25313610505700856,null,0.25313610505700856]
["New Inverters",null,"kWac-yr",{"$f":"SysInverterMSP*InverterLossRate","v":3.1499814536944672},{"$f":"1/ILR","v":0.74626865671641784},2.3507324281301991,null,2.3507324281301991]
["ESS",null,"kWh-cap-yr",{"$f":"SysESSMSP*ESSLossRate","v":13.126338267691763},{"$f":"IncludeESS*StorageDuration","v":2.4},31.503211842460228,null,31.503211842460228]
["Land Lease",null,"ha-yr",1287.6400000000001,{"$f":"IncludeIndirect/(ModuleEfficiency*LandArea)","v":1.6260162601626016E-3},2.0937235772357727,null,2.0937235772357727]
["Property Tax",null,"kWdc-yr",{"$f":"SystemMSP*PropertyTaxRate","v":3.2922200733878491},{"$f":"IncludeIndirect*1","v":1},3.2922200733878491,null,3.2922200733878491]
["Insurance",null,"kWdc-yr",{"$f":"SystemMSP* InsuranceRate","v":4.1152750917348113},{"$f":"IncludeIndirect*1","v":1},4.1152750917348113,{"$f":"SystemMMP*InsuranceRate","v":5.2647599480305054},5.2647599480305054]
["Management",177617,"kWdc-yr",null,{"$f":"IncludeIndirect*1","v":1},1.77617,null,1.77617]
[null,null,null,null,"MSP:",{"$f":"SUM(F10:F19)","v":50.728981674166874},"MMP:",{"$f":"SUM(H10:H19)","v":51.878466530462568}]

{"sheet":"Factors","index":10,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Factors","Names must not contain spaces or special characters",null,null,null,null,"Maximum 100 factors"]
["Save the txt parameter file to activate any change to the orange fields"]
["Component","Name","From","To","Multiply By",null,"Comments"]
["System","ILR","kWac","kWdc",1.34,null,"Typical Inverter Load Ratio for tracking utility-scale system"]
["System","StorageDuration","kWdc","kWh-cap",2.4,null,"Ratio of battery dc kWh capacity to PV dc rating"]
["System","Tariff201","any","any",0.13]
["System","Tariff301","any","any",0.25]
["Module","ModuleEfficiency","m2","kWdc",0.20499999999999999,null,"Average Q1 2023 module efficiency from the CA NEM database"]
["Module","ModuleHeight","module","m",2.27]
["Module","ModuleWidth","module","m",1.1299999999999999]
["Module","ModuleWeight","m2","kg",10.8]
["Module","CellToModule","kWdc(cells)","kWdc",0.98]
["Module","ModuleLabor","m2","hour",0.109]
["Module","ModuleElectricity","m2","kWh",5.79]
["Inverter","InverterWeight","kWac","kg",4.8600000000000003]
["Inverter","InverterLabor","kWac","hour",5.5E-2]
["Inverter","InverterElectricity","kWac","kWh",8.42]
["SBOS","FastenerWeight","m2","kg",0.2]
["SBOS","TorqueTubeWeight","m2","kg",4.8]
["SBOS","SBOSshippingWeight","m2","kg",10]
["SBOS","PiersPerRow","row","piers",11]
["SBOS","RowLength","row","m(width)",86.3]
["EBOS","EBOSweight","kWac","kg",2]
["ESS","BatteryDuration","kWdc(battery)","kWh(battery)",4,null,"Ratio of battery dc kWh capacity to battery rated dc charge rate"]
["ESS","ESS_ILR","kWdc(battery)","kWac(ESS)",1,null,"Ratio of ESS ac inverter capacity to battery rated dc charge rate"]
["ESS","ESSWeight","kWh-cap","kg",6.2]
["ESS","ESSLabor","kWh-cap","hour",0.188]
["ESS","ESSElectricity","kWh-cap","kWh",36.700000000000003]
["Fieldwork","PVElectricalLabor","m2","hour",0.35]
["Fieldwork","PVConstructionLabor","m2","hour",0.75]
["Fieldwork","ESSInstallLabor","kWh-cap","hour",0.7,null,"Additional labor when installed with a PV system"]
["Fieldwork","LaborBurdenRate","any","any",0.54,null,"42% worker's comp, insurance, liability + 12% labor overhead"]
["Other","SalesTaxRate","any","any",5.8000000000000003E-2]
["Other","ContingencyRate","any","any",1.4999999999999999E-2]
["Other","OverheadRate","any","any",1.4999999999999999E-2,null,"Costs of business management that are proportional to expenses"]
["Other","ProfitRate","any","any",4.8500000000000001E-2]
["O_M","PartsLossRate","any","any/yr",2E-3]
["O_M","InverterLossRate","any","any/yr",0.09]
["O_M","ModuleLossRate","any","any/yr",1E-3]
["O_M","ESSLossRate","any","any/yr",2.5000000000000001E-2]
["O_M","LandArea","ha","m2",3000]
["O_M","PropertyTaxRate","any","any/yr",2E-3]
["O_M","InsuranceRate","any","any/yr",2.5000000000000001E-3]

{"sheet":"Guide","index":11,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["GUIDE",null,"Photovoltaic System Cost Model (PVSCM)\nMarch 2023: compatible with Excel 2019+ and Office 365"]
[]
["Load/Save",null,"You can save your Excel file under a new name in the conventional manner, creating a copy of PVSCM. However, a much more efficient approach is to use the Save button in cell E3 on the System sheet to save the data fields in a text file (suffix txt). You can then Load any previouslly saved txt file using the Load button in cell E2. \nYou can load just one sheet from a previously saved txt file using the Copy button in cell D3 on that sheet (for example, to use the same type of module in a different type of system). \nThe spreadsheet should be loaded with input values from a txt file (i.e., not empty) before copying values from a txt file into any single sheet."]
["Color Code",null,"The color code shown on most of the sheets is a legend that identifies which cells are user-input fields (yellow), model-definition parameters (orange), input values calculated by a user-supplied formula (gray), or values calculated via a fixed formula (blue). The orange and blue cells are password-protected. The yellow, gray, and orange cells are stored in the txt files that are created using the Save button (see above)."]
["Fixed Cost",null,"The Fixed Cost parameter on any sheet represents a cost that is nearly the same in dollars regardless of the size (of the system, factory, or integrator) given in cell A3 on that sheet. If the cost data in dollars (y) versus the quantity of any cost element (x) is plotted, the Fixed Cost for that cost element is the y-axis intercept of a linear fit to that data. "]
["Intrinsic Unit",null,"The Intrinsic Unit for any cost element is the quantity most directly related to that cost element, meaning that it is the quantity most unaffected by system parameters other than that quantity. For example, the cost of mechanically mounting a module depends on its size but not its efficiency, so m2 is a more appropriate intrinsic unit than Wdc for that cost. If the cost data in dollars (y) versus the quantity of any cost element (x) is plotted, and the quantity (x) is expressed in the intrinsic units for that cost element, Cost per Intrinsic Unit in column D is the slope of a linear fit to that data."]
["Factors",null,"Values entered on the Factors sheet are used in formulas on the other sheets to convert cost per intrinsic unit into cost per unit based on the system size, factory size, or integrator size. To the extent possible, these factors should be independent of the size of the system, factory, or integrator across a range of at least a factor of two of the nominal size for the type of system described on the System sheet. The values are expressed as unit conversion factors. For example, inverter loading ratio (ILR) is described as a factor that converts a value measured in ac kilowatts into a value measured in dc kilowatts, e.g., ILR = 1.3 kWdc/kWac. The Name given to each factor can be used in formulas on the other sheets. If changes are made to the list of names in orange cells (password protected), the txt file must be saved and reloaded for the modified name list to be properly recognized."]
["System Size",null,"The System Size input parameter in cell A3 on the System sheet defines the size of the system in the units shown. The cost model is designed to allow the same cost parameters to apply across a range of system size, at least within a factor of two of the nominal value provided. The system size input on the System sheet also applies on the SBOS, EBOS, Fieldwork,and Officework sheets. The system size only changes MSP and MMP (see below) if there is at least one non-zero Fixed Cost parameter (see below) on any of these sheets. System size may also affect the annual operation and maintenance (O&M) cost on the O_M sheet if there is a non-zero fixed cost on that sheet. "]
["Annual Production",null,"The Annual Production input parameter in cell A3 on the Module, Inverter, and ESS sheets defines the size of the factories used to produce these components. The cost model is designed to allow the same cost parameters to apply across a range of factory size, at least within a factor of two of the nominal value provided. The annual production rate only changes MSP and MMP (see below) if there is at least one non-zero Fixed Cost parameter (see below) on any of these sheets. The resulting change in MSP for modules, inverters, or ESS will affect the annual operation and maintenance (O&M) cost on the O_M sheet if it affects the replacement cost of these components."]
["Annual Installations",null,"The Annual Installations input parameter in cell A3 on the Other sheet defines the size of the system integrator that is the entity selling the complete system to a customer. The cost model is designed to allow the same cost parameters to apply across a range of system integrator size, at least within a factor of two of the nominal value provided. The annual installations parameter only changes MSP and MMP (see below) if there is at least one non-zero Fixed Cost parameter (see below) on the Other sheet. "]
["Include\nESS",null,"This TRUE/FALSE selection on the System sheet allows the MSP and MMP to be calculated either with or without an associated energy storage system (ESS). The cost elements that are affected are those that have formulas that include a reference to the IncludeESS parameter."]
["Include Indirect",null,"This TRUE/FALSE selection on the System sheet allows the MSP and MMP to be calculated either with or without indirect cost factors. The cost elements that are affected are those that have formulas that include a reference to the IncludeIndirect parameter. "]
["MSP",null,"Minimum Sutainable Price. MSP is the minimum price in a balanced, competitive market that a company can charge for its product or service and remain financially solvent for the long term, based on input costs that represent the minimum price that each input supplier can charge and remain financially solvent for the long term. MSP cannot be directly observed; instead, it must be deduced from observable factors and feedback from industry stakeholders. "]
["MMP",null,"Modeled Market Price. MMP is the actual price in the current market for the representative system being modeled. It differs from MSP due to short-term market distortions including supply-chain constraints, global financial distburbances, and limited-term tariffs or subsidies. If MMP differs from MSP for a cost item, the distorted (MMP) value should be entered in column G and documented in the Comments column for that cost item."]
[]
[null,null,"Sheets"]
["System",null,"This is a summary sheet that pulls numbers from the subsequent sheets and generates a column chart display of those values. The only input values are the system size and any market distortions that affect MMP at the component level (e.g., import tariffs on the hardware components)."]
["Module",null,"This sheet reflects the cost to manufacture modules and ship them overseas (when that is necessary). It does not include import duties. Fixed costs are annual cost per factory, not cost per module. Changes in factory uptime can be represented by changing the Annual Production value while keeping fixed costs unchanged."]
["Inverter",null,"This sheet reflects the cost to manufacture inverters and ship them overseas (when that is necessary). It does not include import duties. Fixed costs are annual cost per factory, not cost per inverter. Changes in factory uptime can be represented by changing the Annual Production value while keeping fixed costs unchanged."]
["ESS",null,"This sheet reflects the cost to manufacture energy storage systems (ESS) and ship them overseas (when that is necessary). It does not include import duties. Fixed costs are annual cost per factory, not cost per ESS. Changes in factory uptime can be represented by changing the Annual Production value while keeping fixed costs unchanged."]
["SBOS",null,"This sheet reflects the cost of structural balance-of-system (BOS) components. Only hardware costs are included on this sheet. The cost of storing, transporting, and installing these hardware components are included on subsequent sheets. "]
["EBOS",null,"This sheet reflects the cost of electrical balance-of-system (BOS) components. Only hardware costs are included on this sheet. The cost of storing, transporting, and installing these hardware components are included on subsequent sheets. "]
["Fieldwork",null,"This sheet reflects the labor and related costs to install the system that are primarily conducted in the field, rather than in an office environment. Related costs include equipment rental, site preparation, and onsite inspection. Fieldwork performed after the system is commissioned should be entered on the operation and maintenance (O_M) sheet."]
["Officework",null,"This sheet reflects the labor and related costs to install the system that are primarily conducted in an office environment. Related costs include warehousing and jurisdictional permit fees. Officework performed after system commissioning should be entered on the operation and maintenance (O_M) sheet. Salaries of management staff should be included on the Other sheet."]
["Other",null,"This sheet captures all system capital costs not included elsewhere, but most commonly it includes management salaries and financial costs associated with the business that is responsible for delivering the completed system to the customer."]
["O_M",null,"This sheet does not affect the system capital cost. Rather, it calculates the annualized cost to for systen operation and maintenance (O&M). This sheet may reference hardware cost component costs to estimate the cost to repair or replace those components. All future costs should be translated into an equivalent annualized net present value."]
["Factors",null,"This sheet provides the unit conversion factors that are used on all other sheets. For example, to convert a value having units in kWac to the corresponding value having units in kWdc, the multiplier used is that shown in the table for the inverter loading ratio (ILR). The name assigned to each factor can be used on any of the other sheets. Note that factor names cannot have spaces or special characters. If any names are changed or moved within the table, the txt file must be saved for the revision to take effect. In addition to the factors listed, the name IncludeESS is assigned to the boolean tick-box on the System sheet, a name is assigned to the size value on each sheet in the form ModuleSize, names are assigned to the MSP and MMP value on each sheet in the form ModuleMSP, and for every component MSP and MMP value on the System sheet, a name is assigned in the form SysModuleMSP. See Excel's Name Manager tab for the complete list of defined cell names."]