{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Use Agreement","Repurposing"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":3,"defined_names":39,"comments":1,"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":"Use Agreement","index":0,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["SOFTWARE USE AGREEMENT"]
[]
["Access to the Repurposing Cost Calculator (“Software”) is provided by the National Renewable Energy Laboratory (“NREL”), which is operated by Alliance for Sustainable Energy, LLC (“ALLIANCE”), for the U.S. Department of Energy (“DOE”)."]
["Access to and use of this Software shall impose the following obligations on the user, and use of the Software constitutes user’s agreement to these terms. The Software is being provided, without any fee or cost, for internal purposes only and shall not be re-distributed."]
["The user agrees to credit DOE/NREL/ALLIANCE in any publication that results from the use of this Software.  The names DOE/NREL/ALLIANCE, however, may not be used in any advertising or publicity to endorse or promote any products or commercial entities unless specific written permission is obtained from DOE/NREL/ ALLIANCE.  The user also understands that DOE/NREL/ALLIANCE is not obligated to provide the user with any support, consulting, training or assistance of any kind with regard to the use of the Software or to provide the user with any updates, revisions or new versions of the Software."]
["USER AGREES TO INDEMNIFY DOE/NREL/ALLIANCE AND ITS SUBSIDIARIES, AFFILIATES, OFFICERS, AGENTS, AND EMPLOYEES AGAINST ANY CLAIM OR DEMAND, INCLUDING REASONABLE ATTORNEYS' FEES, RELATED TO USER’S USE OF THE SOFTWARE.  THE SOFTWARE IS PROVIDED BY DOE/NREL/ALLIANCE \"AS IS,\" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.  IN NO EVENT SHALL DOE/NREL/ALLIANCE BE LIABLE FOR ANY SPECIAL, INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER, INCLUDING BUT NOT LIMITED TO CLAIMS ASSOCIATED WITH THE LOSS OF DATA OR PROFITS, THAT MAY RESULT FROM AN ACTION IN CONTRACT, NEGLIGENCE OR OTHER TORTIOUS CLAIM THAT ARISES OUT OF OR IN CONNECTION WITH THE ACCESS, USE OR PERFORMANCE OF THE SOFTWARE."]
["Results generated by use of this Software are dependent on many variables, including the quality of the data entered by the user and any assumptions made by the user in relation to data inputs.  Accordingly, DOE, NREL, and ALLIANCE cannot guarantee any results generated by use of the Software and user is entirely responsible for the results and any reliance on the results.  User shall not claim that DOE/NREL/ALLIANCE authenticate or otherwise agree with the results generated by the Software.   "]
[]
["DISCLAIMER"]
[]
["The National Renewable Energy Laboratory (NREL) is operated for the U.S. Department of Energy (DOE) by Alliance for Sustainable Energy, LLC (\"Alliance\")."]
["Access to or use of any data or software made available on this server (\"Data\") shall impose the following obligations on the user, and use of the Data constitutes user's agreement to these terms. The user is granted the right, without any fee or cost, to use or copy the Data, provided that this entire notice appears in all copies of the Data. Further, the user agrees to credit DOE/NREL/ALLIANCE in any publication that results from the use of the Data. The names DOE/NREL/ALLIANCE, however, may not be used in any advertising or publicity to endorse or promote any products or commercial entities unless specific written permission is obtained from DOE/NREL/ ALLIANCE. The user also understands that DOE/NREL/ALLIANCE are not obligated to provide the user with any support, consulting, training or assistance of any kind with regard to the use of the Data or to provide the user with any updates, revisions or new versions thereof. DOE, NREL, and ALLIANCE do not guarantee or endorse any results generated by use of the Data, and user is entirely responsible for the results and any reliance on the results or the Data in general."]
["USER AGREES TO INDEMNIFY DOE/NREL/ALLIANCE AND ITS SUBSIDIARIES, AFFILIATES, OFFICERS, AGENTS, AND EMPLOYEES AGAINST ANY CLAIM OR DEMAND, INCLUDING REASONABLE ATTORNEYS' FEES, RELATED TO USER'S USE OF THE DATA. THE DATA ARE PROVIDED BY DOE/NREL/ALLIANCE \"AS IS,\" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. DOE/NREL/ALLIANCE ASSUME NO LEGAL LIABILITY OR RESPONSIBILITY FOR THE ACCURACY, COMPLETENESS, OR USEFULNESS OF THE DATA, OR REPRESENT THAT ITS USE WOULD NOT INFRINGE PRIVATELY OWNED RIGHTS. IN NO EVENT SHALL DOE/NREL/ALLIANCE BE LIABLE FOR ANY SPECIAL, INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER, INCLUDING BUT NOT LIMITED TO CLAIMS ASSOCIATED WITH THE LOSS OF DATA OR PROFITS, THAT MAY RESULT FROM AN ACTION IN CONTRACT, NEGLIGENCE OR OTHER TORTIOUS CLAIM THAT ARISES OUT OF OR IN CONNECTION WITH THE ACCESS, USE OR PERFORMANCE OF THE DATA."]

{"sheet":"Repurposing","index":1,"n_rows":171,"n_cols":11,"rows_kept":171,"cut":false,"hidden":false,"merged":[]}
["Module Properties"]
[null,"Module Nameplate Energy",5,"kWh"]
[null,"Module Nameplate Energy Density",150,"Wh/L"]
[null,"Module Nameplate Specific Energy",115,"Wh/kg"]
[null,"Percent Remaining Energy @ time of repurposing",0.7]
[null,"Module Mass",{"$f":"C2/C4*1000","v":43.478260869565219},"kg"]
[null,"Module Volume",{"$f":"C2/C3*1000*1000","v":33333.333333333336},"cm^3"]
[null,"  Module X",{"$f":"C7/C9/C10","v":51.087295492903536},"cm",{"$f":"C8/2.54/12","v":1.6760923718144205},"ft"]
[null,"  Module Y",{"$f":"C10","v":25.543647746451771},"cm",{"$f":"C9/2.54/12","v":0.83804618590721036},"ft"]
[null,"  Module Z",{"$f":"(C7/2)^(1/3)","v":25.543647746451771},"cm",{"$f":"C10/2.54/12","v":0.83804618590721036},"ft"]
[null,"  Module Footprint",{"$f":"C9*C8","v":1304.9558803896211},"cm^2",{"$f":"C11/2.54/2.54/144","v":1.4046428194272449},"ft^2"]
[null,"Approx Remaining Energy @ time of repurposing",{"$f":"C5*C2","v":3.5},"kWh"]
[null,"Number of Cells in Module",{"$f":"CEILING(C2/0.074,1)","v":68}]
[null,"Cell Fault Rate",1.0000000000000001E-5]
[null,"Comp. Tech. Forced Selling Price ($/kWh)",44]
[]
["Facility Throughput"]
[null,"Facility nameplate annual throughput ",1000000,"kWh/year"]
[null,"Modules per year throughput",{"$f":"FLOOR(C18/C2,1)","v":200000}]
[null,"Modules per day throughput",{"$f":"FLOOR(C19/365,1)","v":547}]
[]
["Transportation",null,2,null,1,2,3]
[null,"Collection Scale",{"$f":"LOOKUP(C$22,E$22:G$22,E23:G23)","v":"Regional"},null,"Local","Regional","National"]
[null,"Typical Round Trip Collection Distance",{"$f":"LOOKUP(C$22,E$22:G$22,E24:G24)","v":320},"mi",30,320,2400]
[null,"Typical Round Trip Collection Time",8,"hrs",2,8,44]
[null,"Truck Type","Class 8 with 48' trailer",null,"24' Box Truck","Class 8 with 48' trailer","Class 8 with 48' trailer"]
[null,"Truck Purchase Cost",141000,"$",62000,141000,{"$f":"F27","v":141000}]
[null,"Truck Operational Cost",0.5,"$/mi",{"$f":"4/10","v":0.4},{"$f":"4/8","v":0.5},0.5]
[null,"Truck Cargo Volume",108733440,"cm^3",{"$f":"10*10*24*28316","v":67958400},{"$f":"0.8*10*48*10*28316","v":108733440},{"$f":"F29","v":108733440}]
[null,"Truck Cargo Mass",22727.272727272724,"kg",{"$f":"6500/2.2","v":2954.5454545454545},{"$f":"50000/2.2","v":22727.272727272724},{"$f":"50000/2.2","v":22727.272727272724}]
[null,"Truck Module Capacity",{"$f":"FLOOR(MIN(C30/C6,C29/C7),1)","v":522}]
[null,"Trips per Year",{"$f":"CEILING(C19/C31,1)","v":384}]
[null,"Total Collection Time",{"$f":"C32*C25","v":3072},"hrs"]
[null,"Number of Trucks & Drivers",{"$f":"CEILING(C33/(252*8),1)","v":2}]
[null,"Total Miles Travelled per Year",{"$f":"C24*C32","v":122880},"mi"]
[null,"Shipping Containers",{"$f":"CEILING(C34*C31*C2/10,1)","v":522}]
[null,"Shipping Container Cost",500,"$"]
[]
["Module Handling & Testing Time"]
[null,"Receiving Inspection & Handling",60,"minutes"]
[null,"Connection to & Initiation of Electrical Test Equipment",10,"minutes"]
[null,"Electrical Testing",75,"minutes"]
[null,"  Time Spent Charging",45,"minutes"]
[null,"  Average C-Rate for Charging",1]
[null,"  Annual Electricity for Testing",{"$f":"C43/60*C44*C12/0.85*C19","v":617647.0588235294},"kWh"]
[null,"Disconnection from Electrical Test Equipment",5,"minutes"]
[null,"Final Inspection and Packaging",45,"minutes"]
[null,"Total Technician Handling Time",{"$f":"C40+C41+C46+C47","v":120},"minutes"]
[null,"Modules per Technician per Year",{"$f":"252*8/(C48/60)","v":1008}]
[null,"Receiving Pallets Moved per Day",{"$f":"CEILING(C20/C89,1)","v":79}]
[null,"Time to Load and Move 1 Pallet",15,"minutes"]
[null,"Fork Lift Operator Time per Day",{"$f":"C51*C50*2/60","v":39.5},"hours"]
[]
["Staff"]
[null,"Number of Technicians",{"$f":"MAX(1,CEILING(C19/C49,1))","v":199}]
[null,"Number of Forklift Operators",{"$f":"MAX(1,CEILING((C52*365)/(8*252),1))","v":8}]
[null,"Number of Truck Drivers",{"$f":"C34","v":2}]
[null,"Number of Supervisors",{"$f":"MAX(1,CEILING(SUM(C55:C57)/10,1))","v":21}]
[null,"Number of Sales Managers",{"$f":"MAX(1,CEILING(C18/100000,1))","v":10}]
[null,"Number of Electrical Engineers",{"$f":"MAX(1,CEILING(C18/100000,1))","v":10}]
[null,"Number of Operations Managers",{"$f":"IF(SUM(C55:C60)>20,1,0)","v":1}]
[null,"Number of Chief Executives",1]
[null,"Number of Administrative Assistants",{"$f":"MAX(1,CEILING(SUM(C55:C62)/30,1))","v":9}]
[null,"Number of Human Resources Personnel",{"$f":"FLOOR(SUM(C55:C62)/30,1)","v":8}]
[null,"Number of Security Guards",0]
[null,"Number of Janitors",0]
[null,"Number of Employees Onsite",{"$f":"CEILING((C59+C62+C63+C64)+0.23*(C60+C61+C55+C56+C58),1)","v":83}]
[]
["Facility Size",null,null,null,null,null,null,{"$f":"C108+C97+C82","v":15019.034120734908},"ft^2"]
["Inspection, Test, and Packing","Width+ Depth for Employee",3,"ft"]
[null,"Width of Forklift",{"$f":"2500/25.4/12","v":8.2020997375328086},"ft"]
[null,"Width of Hallway",5,"ft"]
[null,"Number of Inspection Stations",{"$f":"CEILING(C20*C40/60/24,1)","v":23},"No."]
[null,"Number of Electrical Test Stations, Test Channels, CAN cards",{"$f":"CEILING(C20*SUM(C41,C42,C46)/60/24,1)","v":35},"No."]
[null,"Number of Packing Stations",{"$f":"CEILING(C20*C47/60/24,1)","v":18},"No."]
[null,"Station Width",{"$f":"MAX(2,E9+1)","v":2},"ft"]
[null,"Station Length",{"$f":"MAX(C70,E8+1)","v":3},"ft"]
[null,"Station Footprint",{"$f":"C77*C76","v":6},"ft^2"]
[null,"Conveyer Width",{"$f":"C77","v":3},"ft"]
[null,"Conveyer Length",{"$f":"CEILING((C73+C74+C75)/2,1)*(C76+C70)","v":190},"ft"]
[null,"Total Floor Width",{"$f":"C79+2*C77+2*C72+C71","v":27.202099737532809},"ft"]
[null,"Total Floor Space",{"$f":"C81*C80","v":5168.3989501312335},"ft^2"]
["Docks and Storage","Floor Length for Forklift Maneuvering",{"$f":"C71*3*2","v":49.212598425196852},"ft"]
[null,"Incoming (Outgoing) Modules to Store",{"$f":"C20","v":547}]
[null,"Stack Height of Storage Rack",10,"ft"]
[null,"Pallet Width",{"$f":"40/12","v":3.3333333333333335},"ft"]
[null,"Pallet Length",4,"ft"]
[null,"Pallet Height",0.5,"ft"]
[null,"Modules per Pallet",{"$f":"FLOOR(C86*C87/(1.2*E11),1)","v":7}]
[null,"Pallets per Rack",{"$f":"FLOOR(C85/(C88+E10+0.5),1)","v":5}]
[null,"Modules per Rack",{"$f":"C90*C89","v":35}]
[null,"Number of Racks that can fit in width of facility",{"$f":" FLOOR((C81-C71-C72-C72)/(C86+1),1)","v":2}]
[null,"Number of Recieving (Shipping) Racks Required",{"$f":"CEILING(C84/C91,1)","v":16}]
[null,"Rows of Receiving (Shipping) Racks",{"$f":"CEILING(C93/C92,1)","v":8}]
[null,"Total Number of Racks Required",{"$f":"C93*2","v":32}]
[null,"Total Floor Length for Racks",{"$f":"C94*2*(C87+3)","v":112},"ft"]
[null,"Total Surface Area of Docks and Storage",{"$f":"C96*C81","v":3046.6351706036744},"ft^2"]
["Offices, Etc.","Width of Hallway",5,"ft"]
[null,"Total Length of Hallway",{"$f":"C105+C103","v":324},"ft"]
[null,"Length of Offices, Restrooms",13,"ft"]
[null,"No. of Offices",{"$f":"C59+C60+C61+C62+C63+C64","v":39}]
[null,"Width of Office",8,"ft"]
[null,"Total Width of Offices",{"$f":"C102*C101","v":312},"ft"]
[null,"Surface Area of Restrooms",{"$f":"MAX(C100*6*2,0.5*C67)","v":156},"ft^2"]
[null,"Total Width of Restrooms",{"$f":"C104/C100","v":12},"ft"]
[null,"Surface Area of Breakroom",{"$f":"C67*4","v":332},"ft^2"]
[null,"Surface Area of Workshop",{"$f":"64*C60","v":640},"ft^2"]
[null,"Total Surface Area of Offices, Etc.",{"$f":"C107+C106+C104+C103*C100+C98*C99","v":6804},"ft^2"]
[]
["Capital Costs",null,null,null,null,null,null,{"$f":"G112+G116+G124","v":3094280.4399524145}]
[null,"Category","Description","Qty","Unit Cost","Item Cost","Total Cost"]
[null,"Test Equipment",null,null,null,null,{"$f":"SUM(F113:F115)","v":732600},null,null,{"$f":"C118","v":"Upfront Battery Purchases"},{"$f":"F118","v":1634980.4399524143}]
[null,null,"Battery Test Channels",{"$f":"C74","v":35},{"$f":"2*C2*2000","v":20000},{"$f":"E113*D114","v":700000},null,null,null,{"$f":"C113","v":"Battery Test Channels"},{"$f":"F113","v":700000}]
[null,null,"CAN hardware",{"$f":"D113","v":35},160,{"$f":"E114*D114","v":5600},null,null,null,{"$f":"C121","v":"MD Truck"},{"$f":"F121","v":282000}]
[null,null,"Computers",{"$f":"CEILING(D113/4,1)","v":9},3000,{"$f":"E115*D115","v":27000},null,null,null,{"$f":"C122","v":"Shipping Containers"},{"$f":"F122","v":261000}]
[null,"Materials Handling",null,null,null,null,{"$f":"SUM(F117:F123)","v":2261680.4399524145},null,null,{"$f":"C117","v":"Conveyors"},{"$f":"F117","v":28500}]
[null,null,"Conveyors",{"$f":"C79*C80","v":570},50,{"$f":"E117*D117","v":28500},null,null,null,{"$f":"C119","v":"Storage Racks"},{"$f":"F119","v":3200}]
[null,null,"Upfront Battery Purchases",{"$f":"C19/12","v":16666.666666666668},{"$f":"Batt_Buy_Cost","v":98.098826397144848},{"$f":"E118*D118","v":1634980.4399524143},null,null,null,{"$f":"C115","v":"Computers"},{"$f":"F115","v":27000}]
[null,null,"Storage Racks",{"$f":"C95","v":32},100,3200,null,null,null,{"$f":"C120","v":"Forklift"},{"$f":"F120","v":14000}]
[null,null,"Forklift",{"$f":"MAX(1,CEILING((C52/24),1))","v":2},7000,14000,null,null,null,{"$f":"C123","v":"Work Stations"},{"$f":"F123","v":38000}]
[null,null,"MD Truck",{"$f":"C34","v":2},{"$f":"C27","v":141000},282000,null,null,null,{"$f":"C114","v":"CAN hardware"},{"$f":"F114","v":5600}]
[null,null,"Shipping Containers",{"$f":"C36","v":522},{"$f":"C37","v":500},261000]
[null,null,"Work Stations",{"$f":"C73+C74+C75","v":76},500,38000,null,null,null,{"$f":"J112","v":"Upfront Battery Purchases"},{"$f":"K112","v":1634980.4399524143}]
[null,"Office & Other",null,null,null,null,100000,null,null,{"$f":"J113","v":"Battery Test Channels"},{"$f":"K113","v":700000}]
[null,null,null,null,null,null,null,null,null,"Other",{"$f":"H110-SUM(K123:K124)","v":759300}]
["Employment Costs",null,null,null,null,null,null,{"$f":"G128+G141","v":15989002.68}]
[null,"Category","Description","Qty","Unit Cost","Item Cost","Total Cost",{"$f":"G128+G141","v":15989002.68}]
[null,"Wages",null,null,null,null,{"$f":"SUM(F129:F140)","v":12280340}]
[null,null,"Test Technicians",{"$f":"C55","v":199},37860,{"$f":"E129*D129","v":7534140},null,null,null,{"$f":"C129","v":"Test Technicians"},{"$f":"F129","v":7534140}]
[null,null,"Forklift Drivers",{"$f":"C56","v":8},32660,{"$f":"E130*D130","v":261280},null,null,null,{"$f":"C134","v":"Electrical Engineers"},{"$f":"F134","v":933800}]
[null,null,"Truck Drivers",{"$f":"C57","v":2},33490,66980,null,null,null,{"$f":"C135","v":"Sales/Logistics Reps"},{"$f":"F135","v":856100}]
[null,null,"Technician Supervisors",{"$f":"C58","v":21},58150,1221150,null,null,null,{"$f":"C132","v":"Technician Supervisors"},{"$f":"F132","v":1221150}]
[null,null,"Chief Executive",{"$f":"C62","v":1},178400,178400,null,null,null,{"$f":"C133","v":"Chief Executive"},{"$f":"F133","v":178400}]
[null,null,"Electrical Engineers",{"$f":"C60","v":10},93380,933800,null,null,null,{"$f":"C130","v":"Forklift Drivers"},{"$f":"F130","v":261280}]
[null,null,"Sales/Logistics Reps",{"$f":"C59","v":10},85610,856100,null,null,null,{"$f":"C139","v":"Operations Manager"},{"$f":"F139","v":116090}]
[null,null,"Administrative Assistants",{"$f":"C63","v":9},34000,306000,null,null,null,{"$f":"C136","v":"Administrative Assistants"},{"$f":"F136","v":306000}]
[null,null,"Security Guards",{"$f":"C65","v":0},27550,0,null,null,null,{"$f":"C138","v":"Human Resources Manager"},{"$f":"F138","v":806400}]
[null,null,"Human Resources Manager",{"$f":"C64","v":8},100800,806400,null,null,null,{"$f":"C131","v":"Truck Drivers"},{"$f":"F131","v":66980}]
[null,null,"Operations Manager",{"$f":"C61","v":1},116090,116090]
[null,null,"Janitors",{"$f":"C66","v":0},25140,0]
[null,"Non-Wage Compensation",null,0.30199999999999999,{"$f":"G128","v":12280340},null,{"$f":"D141*E141","v":3708662.6799999997}]
[]
["Total Annual Expenses",null,null,null,null,null,null,{"$f":"G145+G154","v":42329941.62441621}]
[null,"Category","Description","Qty","Unit Cost","Item Cost","Total Cost"]
[null,"Direct Costs",null,null,null,null,{"$f":"SUM(F146:F153)","v":36159827.891971804}]
[null,null,"Battery Modules",{"$f":"C19","v":200000},98.098826397144848,{"$f":"E146*D146","v":19619765.27942897},null,{"$f":"F146/H143","v":0.46349615724752502}]
[null,null,"Pack Materials",0,250,{"$f":"E147*D147","v":0},null,{"$f":"Batt_Buy_Cost/24","v":4.0874510998810356},null,"Battery Purchases",{"$f":"F146","v":19619765.27942897}]
[null,null,"Labor",null,null,{"$f":"H126","v":15989002.68},null,{"$f":"(F148+F146)/H143","v":0.84121939678956648},null,"Labor",{"$f":"F148","v":15989002.68}]
[null,null,"Rent",{"$f":"H69","v":15019.034120734908},9.6999999999999993,{"$f":"E149*D149","v":145684.63097112859},null,null,null,"Electricity",{"$f":"SUM(F150:F151)","v":98328.5015717153}]
[null,null,"Electricity: Testing (kWh)",{"$f":"C45","v":617647.0588235294},0.104,{"$f":"E150*D150","v":64235.294117647056},null,null,null,"Warranty",{"$f":"F157","v":2192532.6643275088}]
[null,null,"Electricity: HVAC & Lighting (kWh)",{"$f":"H69","v":15019.034120734908},2.27,{"$f":"E151*D151","v":34093.207454068244},null,null,null,"G&A",{"$f":"F156","v":1807991.3945985902}]
[null,null,"Transportation",{"$f":"C35","v":122880},{"$f":"C28","v":0.5},{"$f":"E152*D152","v":61440},null,null,null,"R&D",{"$f":"F158","v":1084794.836759154}]
[null,null,"Other Direct Costs",0.02,{"$f":"G128","v":12280340},{"$f":"E153*D153","v":245606.80000000002},null,null,null,"Insurance",{"$f":"F155","v":1084794.836759154}]
[null,"Indirect Costs",null,null,null,null,{"$f":"SUM(F155:F158)","v":6170113.7324444065},null,null,"Other",{"$f":"H143-SUM(K147:K153)","v":452731.43097111583}]
[null,null,"Insurance",0.03,{"$f":"G145","v":36159827.891971804},{"$f":"E155*D155","v":1084794.836759154}]
[null,null,"G&A",0.05,{"$f":"G145","v":36159827.891971804},{"$f":"E156*D156","v":1807991.3945985902},null,null,null,"Direct Costs",{"$f":"SUM(F146:F153)","v":36159827.891971804}]
[null,null,"Warranty",0.05,{"$f":"C167*C18*C15","v":43850653.286550172},{"$f":"E157*D157","v":2192532.6643275088},null,null,null,"Indirect Costs",{"$f":"H143-K156","v":6170113.7324444056}]
[null,null,"R&D",0.03,{"$f":"G145","v":36159827.891971804},{"$f":"E158*D158","v":1084794.836759154}]
[]
[]
["Required Revenue"]
[null,"CT-Forced Battery Selling Price",{"$f":"C15*C2","v":220},"per module","Year","Expenses","Taxes","Revenue","Annual Profit","Annual NPV","Total NPV"]
[null,"Discount Rate",0.15,null,0,{"$f":"H110","v":3094280.4399524145},0,0,null,{"$f":"-F163","v":-3094280.4399524145},{"$f":"SUM(J163:J168)","v":2.0605511963367462E-8}]
[null,"Federal Tax Rate",0.39300000000000002,null,1,{"$f":"H$143","v":42329941.62441621},{"$f":"MAX(0,(H164-F164)*(C$164+C$165))","v":597639.68321864703},{"$f":"C$166","v":43850653.286550172},{"$f":"H164-G164-F164","v":923071.9789153114},{"$f":"(H164-G164-F164)*(1+C$163)^-E164","v":802671.28601331438}]
[null,"State Tax Rate",0,null,2,{"$f":"H$143","v":42329941.62441621},{"$f":"MAX(0,(H165-F165)*(C$164+C$165))","v":597639.68321864703},{"$f":"C$166","v":43850653.286550172},{"$f":"H165-G165-F165","v":923071.9789153114},{"$f":"(H165-G165-F165)*(1+C$163)^-E165","v":697975.03131592553}]
[null,"Annual Revenue",{"$f":"C162*D146*C167","v":43850653.286550172},null,3,{"$f":"H$143","v":42329941.62441621},{"$f":"MAX(0,(H166-F166)*(C$164+C$165))","v":597639.68321864703},{"$f":"C$166","v":43850653.286550172},{"$f":"H166-G166-F166","v":923071.9789153114},{"$f":"(H166-G166-F166)*(1+C$163)^-E166","v":606934.80983993527}]
[null,"Yield (on modules)",{"$f":"(1-C14)^(C2*C13)","v":0.99660575651250383},null,4,{"$f":"H$143","v":42329941.62441621},{"$f":"MAX(0,(H167-F167)*(C$164+C$165))","v":597639.68321864703},{"$f":"C$166","v":43850653.286550172},{"$f":"H167-G167-F167","v":923071.9789153114},{"$f":"(H167-G167-F167)*(1+C$163)^-E167","v":527769.3998608134}]
[null,null,null,null,5,{"$f":"H$143","v":42329941.62441621},{"$f":"MAX(0,(H168-F168)*(C$164+C$165))","v":597639.68321864703},{"$f":"C$166","v":43850653.286550172},{"$f":"H168-G168-F168","v":923071.9789153114},{"$f":"(H168-G168-F168)*(1+C$163)^-E168","v":458929.91292244638}]
["Buying Price and Repurposing Cost"]
[null,"Module Buying Price ($/kWh-nameplate)",{"$f":"Batt_Buy_Cost/C2","v":19.619765279428968}]
[null,"Effective Repurposing Cost ($/kWh-nameplate)",{"$f":"(C162-E146)/C2","v":24.380234720571032}]