{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,2],[4,0,4,2],[1,5,4,14],[1,4,4,4]]}
["PRELIMINARY ECONOMIC MODEL"]
["Summary",null,null,null,"INSTRUCTIONS:","This worksheet is intended to provide guidance on the $0.5-1 Million per mile cost metric.  The input values are for example only.  This example assumes no disruption of gas service; however, be sure to account for if the proposed technology requires.   - Green cells inputs made by Applicants."]
["Total cost ","($/km)",{"$f":"C10+C38+D38+E38","v":448983.65794600069}]
["Total cost ","($/mile)",{"$f":"C3/0.621","v":723001.05949436501}]
["Coating Material Costs"]
["Material Cost ","($/kg)",20]
["Pipe inner diameter","(in)",12]
["Coating thickness","(cm)",0.75]
["Coating density","(g/cm3)",2]
["Coating cost","($/km)",{"$f":"3.14*C7*2.54*C8*C9*C6*100","v":287121.59999999998}]
["Tools Cost"]
[null,"Units","Deposition Tool","Integrity/Inspection Tool","Mapping Tools","Notes by ARPA-E; Applicant may provide additional notes"]
["CAPEX ","($)",1500000,1000000,250000,"Assume mapping tools mounted on coating and integrity/inspection tool"]
["Annual return on CAPEX ","(%)",0.2,0.2,0.2]
["Useful life ","(yrs)",5,5,5]
["Annual amortized cost recovery for tool CAPEX, including Annual return on CAPEX","($)",{"$f":"-PMT(C14,C15,C13)","v":501569.55493442272},{"$f":"-PMT(D14,D15,D13)","v":334379.70328961516},{"$f":"-PMT(E14,E15,E13)","v":83594.925822403791}]
["OPEX"]
["Crew (assume 24x7 operation)","people",7,7,7,"24x7 may not be required"]
["Fully burdended labor rate (including alocation for trucks and tools)","$/year",125000,125000,125000]
["Back office support ","$/year",250000,250000,250000,"Data Analyis/Overhead"]
["Annual labor costs",null,{"$f":"C19*C18+C20","v":1125000},{"$f":"D19*D18+D20","v":1125000},1125000]
["T&L","$/-person-day",200,200,200]
["T&L","$/yr",{"$f":"C22*365*C18*$C$26","v":204400},{"$f":"D22*365*D18*$C$26","v":204400},204400,"On road during utilization"]
["Maintenance","% of CAPEX",0.06,0.06,0.06]
["Mobilization/demobilizaton time ","weeks",2,1,1,"Not used in calc since utilization is low"]
["Utilization","% of year",0.4,0.4,0.4]
["Speed","m/hr",20,50,50]
["Number passes/segment",null,1,2,3,"Assume 1 pass for coating, 2 passes for pre- and post coating for integrity tool, multiple passes for mapping tool"]
["km/yr",null,{"$f":"MIN(24*365*C26*C27/1000/C28,24*365*D26*D27/1000/D28,24*365*E26*E27/1000/E28)","v":58.4},{"$f":"C29","v":58.4},{"$f":"C29","v":58.4},"Distance set by slowest tool; likely integrity tool and mapping tools will be used on more pipes than deposition tool"]
["Bi-directional operating range","(m)",1000,1000,1000]
["Number access points per year",null,{"$f":"C29*1000/C30","v":58.4},{"$f":"D29*1000/D30","v":58.4},{"$f":"E29*1000/E30","v":58.4}]
["Cost per access point (assumes tools can share access points)","($)",75000,0,0,"Assume tools share common access point"]
["Number disruptions to gas serivce per segment"]
["Duration disruption per segment","(hr)"]
["Cost of disruption per segment","($)",null,null,null,"TSSP"]
[]
["Total annual cost ","($/yr)",{"$f":"C16+C21+C23+C24*C13+C31*C32","v":6300969.5549344225},{"$f":"D16+D21+D23+D24*D13+D31*D32","v":1723779.7032896152},{"$f":"E16+E21+E23+E24*E13+E31*E32","v":1427994.9258224037}]
["Total Annual Costs ","($/km)",{"$f":"C37/$C$29","v":107893.31429682231},{"$f":"D37/$C$29","v":29516.775741260535},24451.967907917871]
[]
["Hours gas service disruption","(hr)",0,0,0,"By Applicant"]
["Cost gas disruption ","($/yr)",null,null,null,"By utility"]