{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Overview","graphic","Input","Well P&A Cost Estimate","Rollup_Master","Multiplier Calc_Master","Multi_Well_Estimation","Fac. Dec. & Site Rem. Estimate","Fac. Dec. & Site Rem. Batch","Well Site Rem. Estimate","Well Site Rem. Batch","Contingency Calculation","Cost Summary"],"not_rendered":{"charts":3,"images":12,"macros":1,"external_links":0,"defined_names":6,"comments":6,"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":"Overview","index":0,"n_rows":30,"n_cols":28,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CalGEM Contact Information"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"costestimation@conservation.ca.gov"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Calgem"]

{"sheet":"graphic","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Input","index":2,"n_rows":57,"n_cols":4,"rows_kept":57,"cut":false,"hidden":true,"merged":[[1,3,5,5]]}
[]
[]
[]
[]
[]
[]
[]
[null,"Select Location \nType"]
[]
[null,"Operator Name:",null,"C Case Company"]
[]
[null,"Operator Code:",null,"X1234"]
[]
[null,"Region",null,"Inland"]
[]
[]
[null,"Facility Location :",null,"Section-Township-Range"]
[]
[null,"Facility ID :",null,"12345678"]
[]
[null,"Facility Status :",null,"Deserted"]
["W"]
[null,"Well Name :",null,"Cabrillo 1"]
[]
[null,"Well ID :",null,"2017-1234"]
[]
[null,"Well Depth (ft) :",null,3000]
[]
[null,"Number of Casing Strings :",null,2]
[]
[null,"Well Status :",null,"Idle"]
["F"]
[null,"Lease Name :",null,"Section-Township-Range "]
[]
[null,"Lease ID :",null,"X1234"]
[]
[null,"Lease Status :",null,"Deserted"]
["L"]
[]
[]
[]
[]
[null,"CalGEM Contact Information"]
[]
[null,"Contact Name:",null,"Ibukun Ajayi / Michael Takamori "]
[]
[null,"Contact Email Address:",null,"costestimation@conservation.ca.gov"]
[]
[null,"Contact Phone Number:",null,"123-456-7890"]
[]
[null,"Date:",null,{"$f":"TODAY()","v":"2022-04-01"}]
[]
[]
[]
[null,"Well"]
[null,"Facility"]
[null,"Lease"]

{"sheet":"Well P&A Cost Estimate","index":3,"n_rows":53,"n_cols":25,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,"Well Plug and Abandonment Cost Estimate",null,null,null,null,null,null,null,null,null,null,null,"References"]
[]
[null,null,null,null,null,null,null,null,"Well Depth (ft)",null,null,null,null,3000,{"$f":"IF(N4<1001,X22,IF(AND(N4>1000, N4<3001), X23, IF(AND(N4>3000, N4<5001), X24,X25)))","v":4},null,null,null,{"$f":"X25","v":10}]
[]
[null,null,null,null,null,null,null,null,"Number of Casing Strings",null,null,null,null,2,{"$f":"IF(N6<3,X28,IF(AND(N6>2, N6<5), X29, X30))","v":0},null,null,null,{"$f":"X30","v":8}]
[]
[null,null,null,null,null,null,null,null,"Risk Factors",null,null,null,null,null,"Weight",null,null,null,null,null,null,null,"Selection"]
[]
[null,null,null,null,null,null,null,null,"Well Location",null,null,null,null,null,null,null,null,null,{"$f":"SUM(S11:S14)","v":27},null,null,null,null,"N"]
[null,null,null,null,null,null,null,null,"Critical well as defined by Section 1720, within city limit or urban area as defined by Section 1760 ",null,null,null,null,"Y",{"$f":"IF(N11=\"Y\",S11,0)","v":10},null,null,null,10,{"$f":"S11/$S$10","v":0.37037037037037035},null,null,null,"Y"]
[null,null,null,null,null,null,null,null,"Environmentally sensitive wellhead as defined in Section 1760 ",null,null,null,null,"N",{"$f":"IF(N12=\"Y\",S12,0)","v":0},null,null,null,7,{"$f":"S12/$S$10","v":0.25925925925925924}]
[null,null,null,null,null,null,null,null,"Located in an area of known geologic hazard including subsidence, landslide, or history of damage to the well from seismicity ",null,null,null,null,"N",0,null,null,null,5,0.18518518518518517]
[null,null,null,null,null,null,null,null,"Surface obstacles preventing access such as buildings, structures, surface-use, roads, irrigation systems, and terrain ",null,null,null,null,"Y",5,null,null,null,5,0.18518518518518517]
[]
[null,null,null,null,null,null,null,null,"Well Condition",null,null,null,null,null,null,null,null,null,{"$f":"SUM(S17:S22)-S17","v":30},null,null,null,"Well Age"]
[null,null,null,null,null,null,null,null,"Unknown well condition",null,null,null,null,"N",{"$f":"IF(N17=\"Y\",S17,0)","v":0},null,null,null,25,{"$f":"S17/$S$16","v":0.83333333333333337},null,null,"0-25",0]
[null,null,null,null,null,null,null,null,"Well has pressure in the casing or tubing at the surface, or well is open to the atmosphere",null,null,null,null,"N",{"$f":"IF($N$17=\"Y\",\"\",IF(N18=\"Y\",S18,0))","v":0},null,null,null,5,{"$f":"S18/$S$16","v":0.16666666666666666},null,null,"25-50",3]
[null,null,null,null,null,null,null,null,"Well has inadequate casing or inadequate tubing intergrity ",null,null,null,null,"Y",{"$f":"IF($N$17=\"Y\",\"\",IF(N19=\"Y\",S19,0))","v":6},null,null,null,6,0.2,null,null,"50 +",5]
[null,null,null,null,null,null,null,null,"Well contains junk or other downhole issues such as stuck rods, packer, scales in casing, or fish that require special tools for intervention. ",null,null,null,null,"N",0,null,null,null,9,0.3]
[null,null,null,null,null,null,null,null,"Well fluid level is above the base of freshwater or USDW",null,null,null,null,"Y",5,null,null,null,5,0.16666666666666666,null,null,"Well Depth factor"]
[null,null,null,null,null,null,null,null,"Age of Well",null,null,null,null,"50 +",{"$f":"VLOOKUP(N22,W17:X19,2)","v":5},null,null,null,5,0.16666666666666666,null,null,0,0,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,4,1.2]
[null,null,null,null,null,null,null,null,"Other Enviromental or Safety Concerns",null,null,null,null,null,null,null,null,null,{"$f":"SUM(S25:S27)","v":10},null,null,null,3000,7,1.3]
[null,null,null,null,null,null,null,null,"History of environmental spill / leaks",null,null,null,null,"Y",{"$f":"IF(N25=\"Y\",S25,0)","v":5},null,null,null,5,{"$f":"S25/$S$24","v":0.5},null,null,5000,10,1.4]
[]
[null,null,null,null,null,null,null,null,"Presence of H2S or CO2 production",null,null,null,null,"Y",5,null,null,null,5,{"$f":"S27/$S$24","v":0.5},null,null,"Casing String"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0,1]
[null,null,null,null,null,null,null,null,"Aggregated Well Score",null,null,null,null,{"$f":"SUM(O11:O27)+O6+O4","v":45},null,null,null,null,{"$f":"SUM(S25:S27,S17:S22,S11:S14)+S6+S4-S17","v":85},null,null,null,3,4,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,8,1.3]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aggregrated Risk Category"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"White (Total Weight 0 - 10)",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yellow (Total Weight 11 - 40)",1.3]
[null,null,null,null,null,null,null,null,"Well Plug and Abandonment Cost Estimate",null,null,null,null,null,null,null,null,null,null,null,null,null,"Orange (Total Weight 41 - 60)",1.6,{"$f":"1.2+((15/20)*0.4)","v":1.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Red (Total Weight > 60)",2]
[null,null,null,null,null,null,null,null,"Base Case",null,null,null,null,null,null,null,null,"Benchmark"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regional Benchmark","PA Days"]
[null,null,null,null,null,null,null,null,"Region Name",null,{"$f":"Input!D14","v":"Inland"},null,null,null,"Base P&A Well Days",null,null,{"$f":"Rollup_Master!F6","v":14.2},null,null,null,null,"Coastal",13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inland",14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base Well Cost ($/day)",null,null,{"$f":"Rollup_Master!F8","v":4000},null,null,null,null,"Northern",9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Southern",20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base Well Cost per Feet ($/ft)",null,null,{"$f":"Rollup_Master!F10","v":14}]
[]
[null,null,null,null,null,null,null,null,"Candidate Well"]
[]
[null,null,null,null,null,null,null,null,"Well Name",null,"Cabrillo 1",null,null,null,"Well Depth (ft)",null,null,{"$f":"N4","v":3000}]
[null,"Coastal","Inland","Northern","Southern"]
["Median",28.08487963466554,14.38510101010101,25.535879223751078,21.688053497198627,null,null,null,"Well Score Multiplier (WSM)",null,null,null,null,"----------------------------->",null,null,null,{"$f":"Rollup_Master!F16","v":1.4375}]
["Mean",82.618814366927012,21.13577342300729,39.764754995579416,102.11337273652993]
[null,null,null,null,null,null,null,null,"Total Estimated Well Days (EWD)",null,null,null,null,"----------------------------->",null,null,null,{"$f":"R39*R49","v":20.412499999999998}]
[]
[null,null,null,null,null,null,null,null,"Total Estimated Well Cost  (EWC)",null,null,null,null,"----------------------------->",null,null,null,{"$f":"R51*R41","v":81649.999999999985}]

{"sheet":"Rollup_Master","index":4,"n_rows":76,"n_cols":8,"rows_kept":76,"cut":false,"hidden":true,"merged":[[0,3,0,5],[20,1,20,5],[32,1,32,5],[13,2,13,3],[5,2,5,3]]}
[null,null,null,"Well Plug and Abandonment Cost Estimate"]
[null,"Well Plug and Abandonment Cost Estimate"]
[]
[null,"Base Case",null,null,null,"Benchmark"]
[]
[null,"Region Name",{"$f":"Input!D14","v":"Inland"},null,"P&A Time (days)",{"$f":"VLOOKUP(C6,B49:C52,2,)","v":14.2}]
[]
[null,null,null,null,"Cost ($/day)",{"$f":"VLOOKUP(C6,B49:E52,4,)","v":4000}]
[]
[null,null,null,null,"Cost ($/ft)",{"$f":"VLOOKUP(C6,B49:F52,5,)","v":14}]
[]
[null,"Candidate Well"]
[]
[null,"Well Name",{"$f":"Input!D23","v":"Cabrillo 1"},null,"Well Depth (ft)",{"$f":"'Well P&A Cost Estimate'!N4","v":3000}]
[]
[null,"Weighted Factor (WF) Calculations",null,null,{"$f":"'Well P&A Cost Estimate'!N29","v":45},{"$f":"'Multiplier Calc_Master'!H12","v":1.4375},null,{"$f":"E16/86","v":0.52325581395348841}]
[]
[null,"Total P&A Days",null,null,"-------------->",{"$f":"F6*F16","v":20.412499999999998}]
["X"]
[]
[null,"Cost Factor (Fixed & Variable)"]
[null,"Well specific cost WF",null,null,null,1.2]
[null,"Non-Well specific cost WF",null,null,null,1.1000000000000001]
[]
[]
[null,"Well Cost Rate ($/day)                 -------->",null,null,null,{"$f":"F8*F22","v":4800}]
[]
[null,"Total Well Cost  ",null,null,"-------------->",{"$f":"F18*F8","v":81649.999999999985}]
[]
[null,null,null,null,null,{"$f":"F10*F14*F16","v":60375}]
[]
[null,"Base Case Well Description"]
[null,"Basic onshore well, simple wellbore configurations, no downhole issues, no health, safety & environmental risk,  Plug & Abandonment work can be executed with no known well or site complications / risk"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Reference Data"]
[null,"Regional Benchmark","PA Days",null,"Cost/Day","Cost/Ft"]
[null,"Coastal",13.1,null,7553,13]
[null,"Inland",14.2,null,4000,14]
[null,"Northern",9.3000000000000007,null,7900,9]
[null,"Southern",25.5,null,6000,20]
[]
[]
[null,"Aggregrated Risk Category",null,null,"Well Depth factor"]
[null,"White (Total Weight 0 - 10)",1,null,0,1]
[null,"Yellow (Total Weight 11 - 39)",1.2,null,1000,1.1000000000000001]
[null,"Orange (Total Weight 40 - 60)",1.6,null,3000,1.2]
[null,"Red (Total Weight > 60)",2,null,5000,1.3]
[]
[]
[null,"Well Age"]
[null,"0-25",0]
[null,"25-50",3]
[null,"50 +",5]
[]
[null,"Well Depth factor"]
[null,0,0]
[null,1000,4]
[null,3000,7]
[null,5000,10]
[]
[null,"Casing String"]
[null,2,0]
[null,3,4]
[null,5,8]

{"sheet":"Multiplier Calc_Master","index":5,"n_rows":58,"n_cols":9,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Range","x","y"]
[null,"Low","High","Max Multiplier","Slope","Intercept","Lower Bound"]
[null,null,0,1]
[null,0,10,1,null,null,0,null,{"$f":"C6-B6","v":39}]
[null,11,50,1.5,{"$f":"(D6-D5)/(C6-C5)","v":1.2500000000000001E-2},{"$f":"D5","v":1},{"$f":"C5","v":10},null,{"$f":"C7-B7","v":19}]
[null,51,70,2,{"$f":"(D7-D6)/(C7-C6)","v":2.5000000000000001E-2},{"$f":"D6","v":1.5},{"$f":"C6","v":50}]
[null,null,85,{"$f":"D7","v":2}]
[]
[null,"Adjusted Rating calculation"]
[null,"Rating","Maltiplier Max","Slope","Intercept","Lower Bound","Delta","Adjusted Rating"]
[null,{"$f":"'Well P&A Cost Estimate'!N29","v":45},{"$f":"IF($B12>=$B$7, $D$7, IF( $B12 >=$B$6, $D$6, $D$5) )","v":1.5},{"$f":"IF($B12>=$B$7, $E$7, IF( $B12 >=$B$6, $E$6, $E$5) )","v":1.2500000000000001E-2},{"$f":"IF($B12>=$B$7,$F$7,IF($B12>=$B$6,$F$6,$F$5))","v":1},{"$f":"IF($B12>=$B$7, $G$7, IF( $B12 >=$B$6, $G$6, $G$5) )","v":10},{"$f":"B12-F12","v":35},{"$f":"IF($B12<B$6,  $D$5,  IF($B12 >= $C$7, $D$7,  $G12*$D12+$E12))","v":1.4375}]
[]
[null,"Well Score","Multiplier",null,"Slope","Intercepth","LB","Delta"]
[null,0,{"$f":"IF(B15<$B$6,  $D$5,  IF(B15 >= $C$7, $D$7,  H15*E15+F15))","v":1},null,{"$f":"IF($B15>=$B$7,$E$7,IF($B15>=$B$6,$E$6,$E$5))","v":0},{"$f":"IF($B15>=$B$7,$F$7,IF($B15>=$B$6,$F$6,$F$5))","v":0},{"$f":"IF($B15>=$B$7,$G$7,IF($B15>=$B$6,$G$6,$G$5))","v":0},{"$f":"B15-G15","v":0}]
[null,{"$f":"B15+2","v":2},1,null,{"$f":"IF($B16>=$B$7,$E$7,IF($B16>=$B$6,$E$6,$E$5))","v":0},{"$f":"IF($B16>=$B$7,$F$7,IF($B16>=$B$6,$F$6,$F$5))","v":0},{"$f":"IF($B16>=$B$7,$G$7,IF($B16>=$B$6,$G$6,$G$5))","v":0},{"$f":"B16-G16","v":2}]
[null,{"$f":"B16+2","v":4},1,null,0,0,0,4]
[null,6,1,null,0,0,0,6]
[null,8,1,null,0,0,0,8]
[null,10,1,null,0,0,0,10]
[null,12,1.0249999999999999,null,1.2500000000000001E-2,1,10,2]
[null,14,1.05,null,1.2500000000000001E-2,1,10,4]
[null,16,1.075,null,1.2500000000000001E-2,1,10,6]
[null,18,1.1000000000000001,null,1.2500000000000001E-2,1,10,8]
[null,20,1.125,null,1.2500000000000001E-2,1,10,10]
[null,22,1.1499999999999999,null,1.2500000000000001E-2,1,10,12]
[null,24,1.175,null,1.2500000000000001E-2,1,10,14]
[null,26,1.2,null,1.2500000000000001E-2,1,10,16]
[null,28,1.2250000000000001,null,1.2500000000000001E-2,1,10,18]
[null,30,1.25,null,1.2500000000000001E-2,1,10,20]
[null,32,1.2749999999999999,null,1.2500000000000001E-2,1,10,22]
[null,34,1.3,null,1.2500000000000001E-2,1,10,24]
[null,36,1.325,null,1.2500000000000001E-2,1,10,26]
[null,38,1.35,null,1.2500000000000001E-2,1,10,28]
[null,40,1.375,null,1.2500000000000001E-2,1,10,30]
[null,42,1.4,null,1.2500000000000001E-2,1,10,32]
[null,44,1.425,null,1.2500000000000001E-2,1,10,34]
[null,46,1.45,null,1.2500000000000001E-2,1,10,36]
[null,48,1.4750000000000001,null,1.2500000000000001E-2,1,10,38]
[null,50,1.5,null,1.2500000000000001E-2,1,10,40]
[null,52,1.55,null,2.5000000000000001E-2,1.5,50,2]
[null,54,1.6,null,2.5000000000000001E-2,1.5,50,4]
[null,56,1.65,null,2.5000000000000001E-2,1.5,50,6]
[null,58,1.7,null,2.5000000000000001E-2,1.5,50,8]
[null,60,1.75,null,2.5000000000000001E-2,1.5,50,10]
[null,62,1.8,null,2.5000000000000001E-2,1.5,50,12]
[null,64,1.85,null,2.5000000000000001E-2,1.5,50,14]
[null,66,1.9,null,2.5000000000000001E-2,1.5,50,16]
[null,68,1.95,null,2.5000000000000001E-2,1.5,50,18]
[null,70,2,null,2.5000000000000001E-2,1.5,50,20]
[null,72,2,null,2.5000000000000001E-2,1.5,50,22]
[null,74,2,null,2.5000000000000001E-2,1.5,50,24]
[null,76,2,null,2.5000000000000001E-2,1.5,50,26]
[null,78,2,null,2.5000000000000001E-2,1.5,50,28]
[null,80,2,null,2.5000000000000001E-2,1.5,50,30]
[null,82,2,null,2.5000000000000001E-2,1.5,50,32]
[null,84,2,null,2.5000000000000001E-2,1.5,50,34]
[null,86,2,null,2.5000000000000001E-2,1.5,50,36]

{"sheet":"Multi_Well_Estimation","index":6,"n_rows":27,"n_cols":60,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Well Plug and Abandonment Cost Estimation"]
["`",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Batch Template"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Well Factors",null,null,null,null,null,null,null,null,"Risk Factors"]
[]
[null,null,null,null,null,null,null,null,null,"Do not fill",null,null,null,"Computed Fields - DO NOT FILL OUT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Computed Fields - DO NOT FILL OUT",null,null,null,null,null,null,null,null,"Well Location",null,null,null,null,"Well Conditions",null,null,null,null,null,"Other Enviromental / Safety Concerns"]
["S/N","Region","Operator / Company","Field","Lease","Well Name","API #","Spud Date","P&A Start Date","P&A Year","P&A End Date","total depth",null,"Base Daily Well Cost","Well Abandonment Cost","Facilities Removal Cost","T&M Cost","Total Cost","Base Well Days","P&A Days","P&A Days/1000 ft","$/ft (original)","$/ft ™","Total Cost per foot","Total Cost / Day","CalEPA EnviroScreen Score","Other relevant information - Comment","API - old","Lat, Long","LAT","Long","Well Age","Age Range","Well File","Wellbore Info","# of Csg",null,"Age Factor","Well Depth Factor","Casing Factor",null,"Critical well - located within city limit or near an urban area","Well has an environmentally sensitive wellhead","Located in an area of known geologic hazard, such as subsidence, landslides, or a history of damage to wells in the area from seismicity","Well has surface obstacles preventing access e.g. buildings or structures, surface-use activities, irrigation systems, roads, terrain",null,"Unknown - no public records available","Well has pressure in the casing or tubing at the surface","Well has inadequate casing / tubing intergrity ","Well contains junk or other downhole issues such as stuck rods, packer, scales in casing, or fish that require special tools for intervention. ","Well fluid level is above the base of freshwater or USDW",null,"Risk of Spill","Risk to marine or agriculture","Presence of H2S or CO2 production or any envromental conditions that potentially poses a threat to life, health, or property",null,"Simulated Score","Simulated Score Multiplier factor","Simulated Well Days","Simulated Well Cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,10,8,null,10,7,7,5,null,25,4,6,9,4,null,5,null,5]
[1,"Inland","ABC-XYZ","Santa Maria Valley","Acquistapace","\"Ophelia\" 1","011-20148","1980-05-03","2018-07-23",{"$f":"YEAR(K12)","v":2018},"2018-08-04",1000,null,{"$f":"VLOOKUP(B12,Rollup_Master!$B$49:$E$52,4)","v":4000},null,null,57434.61,{"$f":"SUM(N12:Q12)","v":61434.61},{"$f":"VLOOKUP(B12,Rollup_Master!$B$49:$C$52,2)","v":14.2},{"$f":"K12-I12","v":12},{"$f":"(T12/L12)*1000","v":12},{"$f":"IFERROR(N12/L12,\"\")","v":4},{"$f":"IFERROR(Q12/L12,\"\")","v":57.434609999999999},{"$f":"IFERROR(R12/L12,\"\")","v":61.434609999999999},{"$f":"R12/T12","v":5119.5508333333337},null,"Parted tubing, recovered tubing fish and packer",{"$f":"_xlfn.CONCAT(LEFT(G12,3),RIGHT(G12,5))","v":"01120148"},"(39.06291580, -121.89774323)",34.871967320000003,-120.35132599000001,{"$f":"IFERROR((I12-H12)/365,\"\")","v":38.246575342465754},{"$f":"IF(AF12>50,\"50+\",IF(AND(AF12<50, AF12>25),\"25-50\",IF(AF12<25,\"0-25\")))","v":"25-50"},{"$f":"HYPERLINK((_xlfn.CONCAT(\"ftp://ftp.consrv.ca.gov/pub/oil/WellRecord/\",LEFT(G12,3),\"/\",AB12)),\"Well File\")","v":"Well File"},null,2,null,{"$f":"VLOOKUP(AG12,Rollup_Master!$B$63:$C$65,2)","v":3},{"$f":"IF(L12<1001,Rollup_Master!$C$68,IF(AND(L12>1000, L12<3001),Rollup_Master!$C$69, IF(AND(L12>3000, L12<5001),Rollup_Master!$C$70,Rollup_Master!$C$71)))","v":0},{"$f":"IF(AJ12<3,Rollup_Master!$C$74,IF(AND(AJ12>2, AJ12<5),Rollup_Master!$C$75,Rollup_Master!$C$76))","v":0},null,"N","N","N","N",null,"Y","Y","Y","N","N",null,"N",null,"N",null,{"$f":"SUMIF(AP12:BC12,\"Y\",$AP$11:$BC$11)+SUM(AL12:AN12)","v":38},1.2250000000000001,{"$f":"BF12*S12-1","v":16.395},{"$f":"BG12*N12","v":65580}]
[2,"Inland","ABC-XYZ","Santa Maria Valley","Acquistapace","\"Yellow Rose\" 1","011-20710","2004-12-04","2015-02-10",2015,"2015-02-18",7322,null,{"$f":"VLOOKUP(B13,Rollup_Master!$B$49:$E$52,4)","v":4000},null,null,57435.61,61435.61,{"$f":"VLOOKUP(B13,Rollup_Master!$B$49:$C$52,2)","v":14.2},8,1.0925976509150503,0.54629882545752528,7.8442515706091234,8.390550396066649,7679.4512500000001,null,"Parted tubing, recovered tubing fish and packer","01120710","(39.16454315, -122.00582123)",34.87102127,-120.34874725,{"$f":"IFERROR((I13-H13)/365,\"\")","v":10.191780821917808},{"$f":"IF(AF13>50,\"50+\",IF(AND(AF13<50, AF13>25),\"25-50\",IF(AF13<25,\"0-25\")))","v":"0-25"},"Well File",null,5,null,{"$f":"VLOOKUP(AG13,Rollup_Master!$B$63:$C$65,2)","v":0},{"$f":"IF(L13<1001,Rollup_Master!$C$68,IF(AND(L13>1000, L13<3001),Rollup_Master!$C$69, IF(AND(L13>3000, L13<5001),Rollup_Master!$C$70,Rollup_Master!$C$71)))","v":10},{"$f":"IF(AJ13<3,Rollup_Master!$C$74,IF(AND(AJ13>2, AJ13<5),Rollup_Master!$C$75,Rollup_Master!$C$76))","v":8},null,"Y","Y","N","N",null,"Y","N","N","Y","Y",null,"N","N","Y",null,{"$f":"SUMIF(AP13:BC13,\"Y\",$AP$11:$BC$11)+SUM(AL13:AN13)","v":78},1.9750000000000001,{"$f":"BF13*S13","v":28.044999999999998},112179.99999999999]
[3,"Inland","ABC-XYZ","Santa Maria Valley","Bettiga","\"Transcmerica-Maggiora\" 2","013-20020","1968-03-20","2013-07-09",2013,"2013-07-26",3911,null,{"$f":"VLOOKUP(B14,Rollup_Master!$B$49:$E$52,4)","v":4000},null,null,57436.61,61436.61,{"$f":"VLOOKUP(B14,Rollup_Master!$B$49:$C$52,2)","v":14.2},17,4.3467143952953204,1.0227563283047814,14.685914088468422,15.708670416773204,3613.9182352941175,null,"This whole contract was squirlley.  The WA Hamell was done out of hand without a bid so I cannont atest to the efficacy of the numbers, but they're close.  ","01320020","(37.94747162, -121.73941803)",34.93188095,-120.40383147999999,45.334246575342469,"25-50","Well File",null,4,null,{"$f":"VLOOKUP(AG14,Rollup_Master!$B$63:$C$65,2)","v":3},{"$f":"IF(L14<1001,Rollup_Master!$C$68,IF(AND(L14>1000, L14<3001),Rollup_Master!$C$69, IF(AND(L14>3000, L14<5001),Rollup_Master!$C$70,Rollup_Master!$C$71)))","v":7},{"$f":"IF(AJ14<3,Rollup_Master!$C$74,IF(AND(AJ14>2, AJ14<5),Rollup_Master!$C$75,Rollup_Master!$C$76))","v":4},null,"Y",{"$f":"AP14","v":"Y"},"N","N",null,"N","N","Y","N","N",null,"N","N","N",null,37,1.3374999999999999,17.992499999999996,71969.999999999985]
[4,"Inland","ABC-XYZ","Santa Maria Valley","Bettiga","\"Transcmerica-Maggiora\" 3","013-20021","1948-03-20","2013-07-09",{"$f":"YEAR(K15)","v":2017},"2017-08-29",4500,null,{"$f":"VLOOKUP(B15,Rollup_Master!$B$49:$E$52,4)","v":4000},null,null,57437.61,{"$f":"SUM(N15:Q15)","v":61437.61},{"$f":"VLOOKUP(B15,Rollup_Master!$B$49:$C$52,2)","v":14.2},{"$f":"K15-I15","v":1512},{"$f":"(T15/L15)*1000","v":336},{"$f":"IFERROR(N15/L15,\"\")","v":0.88888888888888884},{"$f":"IFERROR(Q15/L15,\"\")","v":12.763913333333333},{"$f":"IFERROR(R15/L15,\"\")","v":13.652802222222222},{"$f":"R15/T15","v":40.633339947089951},null,"This whole contract was squirlley.  The WA Hamell was done out of hand without a bid so I cannont atest to the efficacy of the numbers, but they're close.  ",{"$f":"_xlfn.CONCAT(LEFT(G15,3),RIGHT(G15,5))","v":"01320021"},"(37.94747162, -121.73941803)",34.93188095,-120.40383147999999,{"$f":"IFERROR((I15-H15)/365,\"\")","v":65.347945205479448},{"$f":"IF(AF15>50,\"50+\",IF(AND(AF15<50, AF15>25),\"25-50\",IF(AF15<25,\"0-25\")))","v":"50+"},{"$f":"HYPERLINK((_xlfn.CONCAT(\"ftp://ftp.consrv.ca.gov/pub/oil/WellRecord/\",LEFT(G15,3),\"/\",AB15)),\"Well File\")","v":"Well File"},null,5,null,{"$f":"VLOOKUP(AG15,Rollup_Master!$B$63:$C$65,2)","v":5},{"$f":"IF(L15<1001,Rollup_Master!$C$68,IF(AND(L15>1000, L15<3001),Rollup_Master!$C$69, IF(AND(L15>3000, L15<5001),Rollup_Master!$C$70,Rollup_Master!$C$71)))","v":7},{"$f":"IF(AJ15<3,Rollup_Master!$C$74,IF(AND(AJ15>2, AJ15<5),Rollup_Master!$C$75,Rollup_Master!$C$76))","v":8},null,"Y",{"$f":"AP15","v":"Y"},"N","N",null,"N","N","Y","N","N",null,"N","N","N",null,{"$f":"SUMIF(AP15:BC15,\"Y\",$AP$11:$BC$11)+SUM(AL15:AN15)","v":43},1.4125000000000001,{"$f":"BF15*S15-1","v":19.057500000000001},{"$f":"BG15*N15","v":76230}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B16,Rollup_Master!$B$49:$E$52,4)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B17,Rollup_Master!$B$49:$E$52,4)","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["End of data - Insert new row above to add new well"]

{"sheet":"Fac. Dec. & Site Rem. Estimate","index":7,"n_rows":82,"n_cols":17,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,"Production Facility Decommissioning & Site Remediation Cost Estimation"]
[]
[]
[]
[null,"Operator Name:",null,"Generic Oil Company"]
[null,"Operator Code:",null,"X1234"]
[null,"Lease Name:",null,"Lease Name"]
[null,"Facility Type:",null,"Setting, Sump, Pipeline, etc"]
[null,"Facility Location:",null,"Coordinates"]
[null,"Subject ID:",null,"12345678"]
[null,"Contact Name:",null,"Operator Contact"]
[null,"Contact Email Address:",null,"Operator Contact Email"]
[null,"Contact Phone Number:",null,"123-456-7890"]
[null,"Date:",null,{"$f":"TODAY()","v":"2022-04-01"}]
[]
[null,"Cost Element",null,"Total Cost \n($)","Quantity","Unit","Unit Cost \n($)","% of Total Cost","Description"]
[null,"Production Facility Decommissioning"]
[null,null,"Tank (>10,001 bbl)",{"$f":"IFERROR((E21*G21),\"\")","v":159803.76909032167},1,"EA",159803.76909032167,{"$f":"IFERROR((D21/$D$50),\"\")","v":0.18711058516902246},"Remove and dispose of tanks: wash, produced water, storage."]
[null,null,"Tank (5,001 - 10,000 bbl) or Urban",{"$f":"IFERROR((E22*G22),\"\")","v":104563.87990686214},1,"EA",104563.87990686214,0.12243145996048536,"Remove and dispose of tanks: wash, produced water, storage."]
[null,null,"Tank (2,500 - 5,000 bbl)",65311.563872681858,1,"EA",65311.563872681858,7.6471819182277398E-2,"Remove and dispose of tanks: wash, produced water, storage."]
[null,null,"Tank (<2,499 bbl)",{"$f":"IFERROR((E24*G24),\"\")","v":19148.514757018511},1,"EA",19148.514757018511,2.2420558799700983E-2,"Remove and dispose of tanks: wash, produced water, storage."]
[null,null,"Vessel",{"$f":"IFERROR((E25*G25),\"\")","v":12620.916000000001},1,"EA",12620.916000000001,1.4777542429517706E-2,"Remove and dispose of vessels: separators, free-water knockout, heater-treaters."]
[null,null,"Above-Ground Pipelines",{"$f":"IFERROR((E26*G26),\"\")","v":22284.076873898022},750,"LF",29.712102498530697,2.6091916902597424E-2,"Remove and dispose of pipelines: transmission, flowline, injection, gathering lines, vent, process piping."]
[null,null,"Buried Pipelines",6028.7999414784026,500,"LF",12.057599882956806,7.0589842238289952E-3,"Any remaining buried pipelines must be purged, capped, and filled with an inert fluid."]
[null,null,"Electrical Vaults & Equipment",3896.1212121212116,10,"TON",389.61212121212117,4.5618793851940021E-3,"Remove and dispose of electrical equipment: poles, transformers, switchgear, cables, wires, conduit, switches, monitoring equipment."]
[null,null,"Asphalt & Concrete",9720.6713367065495,1000,"CF",9.72067133670655,1.1381712161112363E-2,"Remove and dispose of concrete pads and asphalt."]
[null,null,"Pumps & Compressors",4385.7895977011494,1,"EA",4385.7895977011494,5.1352209195407146E-3,"Remove and dispose of pumps and compressors."]
[null,null,"Buildings",30445.924999999999,1000,"SF",30.445924999999999,3.5648438551798757E-2,"Remove and dispose of buildings, walls, and supporting equipment."]
[null,null,"Subtotal",{"$f":"SUM(D21:D31)","v":438210.02758878964},null,null,null,{"$f":"SUM(H21:H31)","v":0.51309011768507629}]
[]
[null,"Site Remediation"]
[null,null,"Tank (>10,001 bbl)",{"$f":"IFERROR((E35*G35),\"\")","v":120308.94304559106},{"$f":"IF(E21<=0,\"\",E21)","v":1},"EA",120308.94304559106,{"$f":"IFERROR((D35/$D$50),\"\")","v":0.14086699495556826},"Site remediation for a tank including contaminated soil excavation & disposal, refuse removal, secondary containment removal, and site restoration."]
[null,null,"Tank (5,001 - 10,000 bbl) or Urban",{"$f":"IFERROR((E36*G36),\"\")","v":54344.752830883597},{"$f":"IF(E22<=0,\"\",E22)","v":1},"EA",54344.752830883597,6.363103048780569E-2,"Site remediation for a tank including contaminated soil excavation & disposal, refuse removal, secondary containment removal, and site restoration."]
[null,null,"Tank (2,500 - 5,000 bbl)",21450.376061581355,{"$f":"IF(E23<=0,\"\",E23)","v":1},"EA",21450.376061581355,2.5115755653482626E-2,"Site remediation for a tank including contaminated soil excavation & disposal, refuse removal, secondary containment removal, and site restoration."]
[null,null,"Tank (<2,499 bbl)",6549.2233850874309,{"$f":"IF(E24<=0,\"\",E24)","v":1},"EA",6549.2233850874309,7.6683361535342656E-3,"Site remediation for a tank including contaminated soil excavation & disposal, refuse removal, secondary containment removal, and site restoration."]
[null,null,"Vessel",{"$f":"IFERROR((E39*G39),\"\")","v":6549.2233850874309},{"$f":"IF(E25<=0,\"\",E25)","v":1},"EA",6549.2233850874309,7.6683361535342656E-3,"Site remediation for a vessel including contaminated soil excavation & disposal, refuse removal, secondary containment removal, and site restoration."]
[null,null,"Sumps & Auxiliary Holes",{"$f":"IFERROR((E40*G40),\"\")","v":3864.6610872651931},1000,"CF",3.8646610872651932,4.5250434431833167E-3,"Site remediation for sumps and auxiliary holes including contaminated soil excavation & disposal, backfilling, compaction, slope collapse mitigation, and site restoration."]
[null,null,"Refuse Removal",13710,100,"CY",137.1,1.6052726023110187E-2,"Remove and dispose of all refuse, trash, debris, construction materials, production pads, piers, fencing."]
[null,null,"Access Road Removal & Restoration",2247.5965100858061,1000,"CF",2.2475965100858062,2.6316594447050369E-3,"Access roads that create a hazard to public safety, property or causes interference with natural drainage shall be restored to as near a natural state as practicable."]
[null,null,"Subtotal",{"$f":"SUM(D35:D42)","v":229024.77630558185},null,null,null,{"$f":"SUM(H35:H42)","v":0.26815988231492366}]
[]
[null,"Contingency",null,{"$f":"SUM(D32,D43)*E45","v":66723.480389437158},{"$f":"'Contingency Calculation'!F20","v":"10%"},null,null,{"$f":"IFERROR((D45/$D$50),\"\")","v":7.8125E-2},"Contingency calculated from the Contingency tab."]
[null,"Permitting & Regulatory Compliance",null,{"$f":"SUM(D32,D43)*E46","v":33361.740194718579},0.05,null,null,{"$f":"IFERROR((D46/$D$50),\"\")","v":3.90625E-2},"Costs to develop and obtain permits to perform the decommissioning and site remediation scope of work."]
[null,"Mobilization & Demobilization",null,{"$f":"SUM(D32,D43)*E47","v":33361.740194718579},0.05,null,null,3.90625E-2,"Mobilization and Demobilization of equipment and crews to start and finish the project."]
[null,"Project Management & Engineering",null,{"$f":"SUM(D32,D43)*E48","v":53378.784311549723},0.08,null,null,6.25E-2,"Costs for Project Management & Engineering"]
[]
[null,"TOTAL COST ESTIMATE",null,{"$f":"D32+D43+D45+D46+D47+D48","v":854060.54898479558},null,null,null,{"$f":"IFERROR((H32+H43+H45+H46+H47+H48),\"\")","v":1}]
[]
[null,"Comments",null,null,null,null,null,null,null,"Acronym","Unit of Measure",null,null,"      WellSTAR Input"]
[null,"Please provide additional scope of work information here.\n",null,null,null,null,null,null,null,"CF","Cubic Foot",null,"Facilities Decommissioning",null,null,{"$f":"D32+(D32*E45)+(D32*E46)+(D32*E47)+(D32*E48)","v":560908.83531365078},{"$f":"P53","v":560908.83531365078}]
[null,null,null,null,null,null,null,null,null,"EA","Each",null,"Site Remediation",null,null,{"$f":"D43+(D43*E45)+(D43*E46)+(D43*E47)+(D43*E48)","v":293151.7136711448},{"$f":"P54","v":293151.7136711448}]
[null,null,null,null,null,null,null,null,null,"LF","Linear Foot",null,"Total",null,null,{"$f":"P53+P54","v":854060.54898479558},{"$f":"Q53+Q54","v":854060.54898479558}]
[null,null,null,null,null,null,null,null,null,"LS","Lump Sum"]
[null,null,null,null,null,null,null,null,null,"TON","Ton"]
[null,null,null,null,null,null,null,null,null,"CY","Cubic Yard"]
[null,null,null,null,null,null,null,null,null,"SF","Square Foot"]
[]
[null,null,"Default Assumptions Per Equipment"]
[null,"Facilities Decommissioning",null,null,"Unit","Tank","Well","Vessel","Comments"]
[null,null,"Above-Ground Pipelines",null,"LF",150,100,{"$f":"F63","v":150},"150 feet per tank & vessel, 100 feet per well"]
[null,null,"Buried Pipelines",null,"LF",100,50,{"$f":"F64","v":100},"100 feet per tank & vessel, 50 feet per well"]
[null,null,"Electrical Vaults & Equipment",null,"TON",2,{"$f":"F65","v":2},{"$f":"F65","v":2},"2 tons of electrical equipment per tank, well, vessel"]
[null,null,"Asphalt & Concrete Per Pump",null,"CF",null,{"$f":"20*5*3","v":300},null,"20 x 5 x 3 ft concrete pad per pumping unit"]
[]
[null,"Site Remediation"]
[null,null,"Contaminated Soil Excavation Per Well",null,"CF",null,{"$f":"8*8*6","v":384},null,"8 x 8 x 6 ft of contaminated soil per well"]
[null,null,"Contaminated Soil Excavation Per Vessel",null,"CF",null,null,{"$f":"F71","v":441},"21 x 21 x 1 ft of contaminated soil per vessel"]
[null,null,"Contaminated Soil Excavation Per Tank (<2.5k bbl)",null,"CF",{"$f":"21*21*1","v":441},null,null,"21 x 21 x 1 ft of contaminated soil per tank"]
[null,null,"Contaminated Soil Excavation Per Tank (2.5k-5k bbl)",null,"CF",{"$f":"30*30*2","v":1800},null,null,"30 x 30 x 2 ft of contaminated soil per tank"]
[null,null,"Contaminated Soil Excavation Per Tank (5k-10k bbl)",null,"CF",{"$f":"40*40*3","v":4800},null,null,"40 x 40 x 3 ft of contaminated soil per tank"]
[null,null,"Contaminated Soil Excavation Per Tank (>10k bbl)",null,"CF",{"$f":"52*52*4","v":10816},null,null,"52 x 52 x 4 ft of contaminated soil per tank"]
[null,null,"Site Restoration Per Well",null,"CF",null,{"$f":"G82+G69","v":2384},null,"Sum of access road & contaminated soil volumes"]
[null,null,"Site Restoration Per Vessel",null,"CF",null,null,441,"Contaminated soil volume"]
[null,null,"Site Restoration Per Tank (<2.5k bbl)",null,"CF",{"$f":"F71","v":441},null,null,"Contaminated soil volume"]
[null,null,"Site Restoration Per Tank (2.5k-5k bbl)",null,"CF",{"$f":"F72","v":1800},null,null,"Contaminated soil volume"]
[null,null,"Site Restoration Per Tank (5k-10k bbl)",null,"CF",{"$f":"F73","v":4800},null,null,"Contaminated soil volume"]
[null,null,"Site Restoration Per Tank (>10k bbl)",null,"CF",{"$f":"F74","v":10816},null,null,"Contaminated soil volume"]
[null,null,"Waste Removal",null,"CY",10,{"$f":"F81","v":10},{"$f":"F81","v":10},"10 cubic yards of waste per tank, well, vessel"]
[null,null,"Access Road",null,"CF",null,{"$f":"100*20*1","v":2000},null,"100 x 20 x 1 ft or 200 x 10 x 1 ft of access road per well"]

{"sheet":"Fac. Dec. & Site Rem. Batch","index":8,"n_rows":66,"n_cols":37,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Production Facility Decommissioning & Site Remediation Cost Estimation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Batch Template"]
[]
[]
[null,"Operator Name:",null,"Generic Oil Company",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact Email Address:",null,null,null,"Operator Contact Email"]
[null,"Operator Code:",null,"X1234",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact Phone Number:",null,null,null,"Operator Contact Phone"]
[null,"Contact Name:",null,"Operator Contact Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:",null,null,null,"Date"]
[]
[null,null,"Production Facility Information",null,null,null,null,null,null,null,null,"Production Facility Decommissioning",null,null,null,null,null,null,null,null,null,"               Production Facility Site Remediation",null,null,null,null,null,null,"                  Other Project Components",null,null,null,null,null,"     WellSTAR Input"]
[null,"Field","Lease","Facility Type","Subject ID",null,"Tanks (>10,001 bbl)","Tanks (5,001 - 10,000 bbl)\n or Urban","Tanks (2,500 - 5,000 bbl)","Tanks (<2,499 bbl)","Vessels","Above-Ground Pipelines","Buried Pipelines","Electrical Vaults & \nEquipment","Asphalt & Concrete","Pumps & Compressors","Buildings",null,"Tanks (>10,001 bbl)","Tanks (5,001 - 10,000 bbl)\n or Urban","Tanks (2,500 - 5,000 bbl)","Tanks (<2,499 bbl)","Vessels","Sumps & Auxiliary Holes","Refuse Removal","Access Roads \nRemoval & Restoration",null,"Contingency","Permitting & Regulatory \nCompliance","Mobilization & \nDemobilization","Project Management & Engineering",null,"Facilities Decommissioning \nTotal Cost","Site Remediation \nTotal Cost","Facilities Decommissioning \nTotal Cost","Site Remediation \nTotal Cost","Total Cost"]
[null,null,null,null,"Unit Cost",null,159803.76909032167,104563.87990686214,65311.563872681858,19148.514757018511,12620.916000000001,29.712102498530697,12.057599882956806,389.61212121212117,9.72067133670655,4385.7895977011494,30.445924999999999,null,120308.94304559106,54344.752830883597,21450.376061581355,6549.2233850874309,6549.2233850874309,3.8646610872651932,137.1,2.2475965100858062]
[null,null,null,null,"Unit",null,"EA","EA","EA","EA","EA","LF","LF","TON","CF","EA","SF",null,"EA","EA","EA","EA","EA","CF","CY","CF"]
[null,"Field Name","Lease Name","Setting",12345678,null,1,1,1,1,1,750,500,10,1000,1,1000,null,{"$f":"G15","v":1},{"$f":"H15","v":1},{"$f":"I15","v":1},{"$f":"J15","v":1},{"$f":"K15","v":1},1000,100,1000,null,0.1,0.05,0.05,0.08,null,{"$f":"((G15*$G$13)+(H15*$H$13)+(I15*$I$13)+(J15*$J$13)+(K15*$K$13)+(L15*$L$13)+(M15*$M$13)+(N15*$N$13)+(O15*$O$13)+(P15*$P$13)+(Q15*$Q$13))+(((G15*$G$13)+(H15*$H$13)+(I15*$I$13)+(J15*$J$13)+(K15*$K$13)+(L15*$L$13)+(M15*$M$13)+(N15*$N$13)+(O15*$O$13)+(P15*$P$13)+(Q15*$Q$13))*AB15)+(((G15*$G$13)+(H15*$H$13)+(I15*$I$13)+(J15*$J$13)+(K15*$K$13)+(L15*$L$13)+(M15*$M$13)+(N15*$N$13)+(O15*$O$13)+(P15*$P$13)+(Q15*$Q$13))*AC15)+(((G15*$G$13)+(H15*$H$13)+(I15*$I$13)+(J15*$J$13)+(K15*$K$13)+(L15*$L$13)+(M15*$M$13)+(N15*$N$13)+(O15*$O$13)+(P15*$P$13)+(Q15*$Q$13))*AD15)+(((G15*$G$13)+(H15*$H$13)+(I15*$I$13)+(J15*$J$13)+(K15*$K$13)+(L15*$L$13)+(M15*$M$13)+(N15*$N$13)+(O15*$O$13)+(P15*$P$13)+(Q15*$Q$13))*AE15)","v":560908.83531365078},{"$f":"((S15*$S$13)+(T15*$T$13)+(U15*$U$13)+(V15*$V$13)+(W15*$W$13)+(X15*$X$13)+(Y15*$Y$13)+(Z15*$Z$13))+(((S15*$S$13)+(T15*$T$13)+(U15*$U$13)+(V15*$V$13)+(W15*$W$13)+(X15*$X$13)+(Y15*$Y$13)+(Z15*$Z$13))*AB15)+(((S15*$S$13)+(T15*$T$13)+(U15*$U$13)+(V15*$V$13)+(W15*$W$13)+(X15*$X$13)+(Y15*$Y$13)+(Z15*$Z$13))*AC15)+(((S15*$S$13)+(T15*$T$13)+(U15*$U$13)+(V15*$V$13)+(W15*$W$13)+(X15*$X$13)+(Y15*$Y$13)+(Z15*$Z$13))*AD15)+(((S15*$S$13)+(T15*$T$13)+(U15*$U$13)+(V15*$V$13)+(W15*$W$13)+(X15*$X$13)+(Y15*$Y$13)+(Z15*$Z$13))*AE15)","v":293151.7136711448},{"$f":"ROUND(AG15,0)","v":560909},{"$f":"ROUND(AH15,0)","v":293152},{"$f":"ROUND(SUM(AI15:AJ15),0)","v":854061}]
[null,"Field Name","Lease Name","Setting",12345678,null,1,1,1,1,1,750,500,10,1000,1,1000,null,1,1,1,1,1,1000,100,1000,null,0.2,0.05,0.05,0.08,null,{"$f":"((G16*$G$13)+(H16*$H$13)+(I16*$I$13)+(J16*$J$13)+(K16*$K$13)+(L16*$L$13)+(M16*$M$13)+(N16*$N$13)+(O16*$O$13)+(P16*$P$13)+(Q16*$Q$13))+(((G16*$G$13)+(H16*$H$13)+(I16*$I$13)+(J16*$J$13)+(K16*$K$13)+(L16*$L$13)+(M16*$M$13)+(N16*$N$13)+(O16*$O$13)+(P16*$P$13)+(Q16*$Q$13))*AB16)+(((G16*$G$13)+(H16*$H$13)+(I16*$I$13)+(J16*$J$13)+(K16*$K$13)+(L16*$L$13)+(M16*$M$13)+(N16*$N$13)+(O16*$O$13)+(P16*$P$13)+(Q16*$Q$13))*AC16)+(((G16*$G$13)+(H16*$H$13)+(I16*$I$13)+(J16*$J$13)+(K16*$K$13)+(L16*$L$13)+(M16*$M$13)+(N16*$N$13)+(O16*$O$13)+(P16*$P$13)+(Q16*$Q$13))*AD16)+(((G16*$G$13)+(H16*$H$13)+(I16*$I$13)+(J16*$J$13)+(K16*$K$13)+(L16*$L$13)+(M16*$M$13)+(N16*$N$13)+(O16*$O$13)+(P16*$P$13)+(Q16*$Q$13))*AE16)","v":604729.83807252976},{"$f":"((S16*$S$13)+(T16*$T$13)+(U16*$U$13)+(V16*$V$13)+(W16*$W$13)+(X16*$X$13)+(Y16*$Y$13)+(Z16*$Z$13))+(((S16*$S$13)+(T16*$T$13)+(U16*$U$13)+(V16*$V$13)+(W16*$W$13)+(X16*$X$13)+(Y16*$Y$13)+(Z16*$Z$13))*AB16)+(((S16*$S$13)+(T16*$T$13)+(U16*$U$13)+(V16*$V$13)+(W16*$W$13)+(X16*$X$13)+(Y16*$Y$13)+(Z16*$Z$13))*AC16)+(((S16*$S$13)+(T16*$T$13)+(U16*$U$13)+(V16*$V$13)+(W16*$W$13)+(X16*$X$13)+(Y16*$Y$13)+(Z16*$Z$13))*AD16)+(((S16*$S$13)+(T16*$T$13)+(U16*$U$13)+(V16*$V$13)+(W16*$W$13)+(X16*$X$13)+(Y16*$Y$13)+(Z16*$Z$13))*AE16)","v":316054.19130170299},{"$f":"ROUND(AG16,0)","v":604730},316054,{"$f":"ROUND(SUM(AI16:AJ16),0)","v":920784}]
[null,"Field Name","Lease Name","Setting",12345678,null,1,1,1,1,1,750,500,10,1000,1,1000,null,1,1,1,1,1,1000,100,1000,null,0.3,0.05,0.05,0.08,null,648550.84083140874,338956.66893226118,648551,338957,987508]
[null,"Field Name","Lease Name","Setting",12345678,null,1,1,1,1,1,750,500,10,null,null,null,null,1,1,1,1,1,null,null,null,null,0.1,0.05,0.05,0.08,null,503881.7813176089,267779.22394653549,503882,267779,771661]
[null,"Field Name","Lease Name","Setting",12345678,null,1,1,1,1,1,750,500,10,null,null,null,null,1,1,1,1,1,null,null,null,null,0.2,0.05,0.05,0.08,null,543247.54548304714,288699.47581735859,543248,288699,{"$f":"ROUND(SUM(AI19:AJ19),0)","v":831947}]
[null,"Field Name","Lease Name","Setting",12345678,null,1,1,1,1,1,750,500,10,null,null,null,null,1,1,1,1,1,null,null,null,null,0.3,0.05,0.05,0.08,null,582613.30964848527,309619.72768818168,582613,309620,892233]
[null,"Field Name","Lease Name","Setting",12345678,null,1,1,1,1,1,750,500,10,null,null,null,null,1,1,1,1,1,null,null,null,null,0.1,0.05,0.05,0.08,null,503881.7813176089,267779.22394653549,503882,267779,771661]
[null,"Field Name","Lease Name","Setting",12345678,null,1,1,1,1,1,750,500,10,null,null,null,null,1,1,1,1,1,null,null,null,null,0.2,0.05,0.05,0.08,null,543247.54548304714,288699.47581735859,543248,288699,831947]
[null,"Field Name","Lease Name","Setting",12345678,null,1,1,1,1,1,750,500,10,null,null,null,null,1,1,1,1,1,null,null,null,null,0.3,0.05,0.05,0.08,null,582613.30964848527,309619.72768818168,582613,309620,892233]
[null,"Field Name","Lease Name","Setting",12345678,null,1,1,1,1,1,750,500,10,null,null,null,null,1,1,1,1,1,null,null,null,null,0.1,0.05,0.05,0.08,null,503881.7813176089,267779.22394653549,503882,267779,771661]
[null,"Field Name","Lease Name","Setting",12345678,null,1,1,1,1,1,750,500,10,null,null,null,null,1,1,1,1,1,null,null,null,null,0.2,0.05,0.05,0.08,null,543247.54548304714,288699.47581735859,543248,288699,831947]
[null,"Field Name","Lease Name","Setting",12345678,null,1,1,1,1,1,750,500,10,null,null,null,null,1,1,1,1,1,null,null,null,null,0.3,0.05,0.05,0.08,null,582613.30964848527,309619.72768818168,582613,309620,892233]
[null,"Field Name","Lease Name","Setting",12345678,null,1,1,1,1,1,750,500,10,null,null,null,null,1,1,1,1,1,null,null,null,null,0.1,0.05,0.05,0.08,null,503881.7813176089,267779.22394653549,503882,267779,771661]
[null,"Field Name","Lease Name","Setting",12345678,null,1,1,1,1,1,750,500,10,null,null,null,null,1,1,1,1,1,null,null,null,null,0.2,0.05,0.05,0.08,null,543247.54548304714,288699.47581735859,543248,288699,831947]
[null,"Field Name","Lease Name","Setting",12345678,null,1,1,1,1,1,750,500,10,null,null,null,null,1,1,1,1,1,null,null,null,null,0.3,0.05,0.05,0.08,null,582613.30964848527,309619.72768818168,582613,309620,892233]
[null,"Field Name","Lease Name","Setting",12345678,null,1,1,1,1,1,750,500,10,null,null,null,null,1,1,1,1,1,null,null,null,null,0.1,0.05,0.05,0.08,null,503881.7813176089,267779.22394653549,503882,267779,771661]
[null,"Field Name","Lease Name","Sump",12345678,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,{"$f":"100*50*15","v":75000},null,null,null,0.2,0.05,0.05,0.08,null,0,399992.42253194744,0,399992,399992]
[null,"Field Name","Lease Name","Pipeline",12345678,null,null,null,null,null,null,10000,5000,{"$f":"(SUM(G32:J32)*$H$49)+(SUM(K32*$J$49))","v":0},null,null,null,null,0,0,0,0,0,null,null,null,null,0.3,0.05,0.05,0.08,null,528965.35611213464,0,528965,0,528965]
[null,null,"Leave this row blank. Insert additonal rows above.",null,null,null,null,null,null,null,"Leave this row blank. Insert additonal rows above.",null,null,null,null,null,null,null,null,null,null,"Leave this row blank. Insert additonal rows above.",null,null,null,null,null,"    Leave this row blank. Insert additonal rows above."]
[null,null,null,null,"Total",null,{"$f":"IF(SUM(G15:G33)=0,\"\",SUM(G15:G33))","v":16},16,16,16,16,22000,13000,160,3000,3,3000,null,{"$f":"IF(SUM(S15:S33)=0,\"\",SUM(S15:S33))","v":16},16,16,16,16,78000,300,3000,null,null,null,null,null,null,{"$f":"IF(SUM(AG15:AG33)=0,\"\",SUM(AG15:AG33))","v":9366007.1974438988},{"$f":"IF(SUM(AH15:AH33)=0,\"\",SUM(AH15:AH33))","v":5080327.930191895},{"$f":"ROUND(AG34,0)","v":9366007},{"$f":"ROUND(AH34,0)","v":5080328},{"$f":"ROUND(SUM(AI34:AJ34),0)","v":14446335}]
[]
[null,"Comments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acronym","      Unit of Measure"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CF","          Cubic Foot"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EA","                Each"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LF","         Linear Foot"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LS","          Lump Sum"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TON","               Ton"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CY","          Cubic Yard"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SF","        Square Foot"]
[]
[null,null,"Default Assumptions Per Equipment"]
[null,"Facilities Decommissioning",null,null,null,null,"Unit","Tank","Well","Vessel","Comments"]
[null,"        Above-Ground Pipelines",null,null,null,null,"LF",150,100,{"$f":"H47","v":150},"150 feet per tank & vessel, 100 feet per well"]
[null,"        Buried Pipelines",null,null,null,null,"LF",100,50,{"$f":"H48","v":100},"100 feet per tank & vessel, 50 feet per well"]
[null,"        Electrical Vaults & Equipment",null,null,null,null,"TON",2,{"$f":"H49","v":2},{"$f":"H49","v":2},"2 tons of electrical equipment per tank, well, vessel"]
[null,"        Asphalt & Concrete Per Pump",null,null,null,null,"CF",null,{"$f":"20*5*3","v":300},null,"20 x 5 x 3 ft concrete pad per pumping unit"]
[]
[null,"Site Remediation"]
[null,"        Contaminated Soil Excavation Per Well",null,null,null,null,"CF",null,{"$f":"8*8*6","v":384},null,"8 x 8 x 6 ft of contaminated soil per well"]
[null,"        Contaminated Soil Excavation Per Vessel",null,null,null,null,"CF",null,null,{"$f":"H55","v":441},"21 x 21 x 1 ft of contaminated soil per vessel"]
[null,"        Contaminated Soil Excavation Per Tank (<2.5k bbl)",null,null,null,null,"CF",{"$f":"21*21*1","v":441},null,null,"21 x 21 x 1 ft of contaminated soil per tank"]
[null,"        Contaminated Soil Excavation Per Tank (2.5k-5k bbl)",null,null,null,null,"CF",{"$f":"30*30*2","v":1800},null,null,"30 x 30 x 2 ft of contaminated soil per tank"]
[null,"        Contaminated Soil Excavation Per Tank (5k-10k bbl)",null,null,null,null,"CF",{"$f":"40*40*3","v":4800},null,null,"40 x 40 x 3 ft of contaminated soil per tank"]
[null,"        Contaminated Soil Excavation Per Tank (>10k bbl)",null,null,null,null,"CF",{"$f":"52*52*4","v":10816},null,null,"52 x 52 x 4 ft of contaminated soil per tank"]
[null,"        Site Restoration Per Well",null,null,null,null,"CF",null,{"$f":"I66+I53","v":2384},null,"Sum of access road & contaminated soil volumes"]
[null,"        Site Restoration Per Tank Vessel",null,null,null,null,"CF",null,null,441,"Contaminated soil volume"]
[null,"        Site Restoration Per Tank (<2.5k bbl)",null,null,null,null,"CF",{"$f":"H55","v":441},null,null,"Contaminated soil volume"]
[null,"        Site Restoration Per Tank (2.5k-5k bbl)",null,null,null,null,"CF",{"$f":"H56","v":1800},null,null,"Contaminated soil volume"]
[null,"        Site Restoration Per Tank (5k-10k bbl)",null,null,null,null,"CF",{"$f":"H57","v":4800},null,null,"Contaminated soil volume"]
[null,"        Site Restoration Per Tank (>10k bbl)",null,null,null,null,"CF",{"$f":"H58","v":10816},null,null,"Contaminated soil volume"]
[null,"        Waste Removal",null,null,null,null,"CY",10,{"$f":"H65","v":10},{"$f":"H65","v":10},"10 cubic yards of waste per tank, well, vessel"]
[null,"        Access Road",null,null,null,null,"CF",null,{"$f":"100*20*1","v":2000},null,"100 x 20 x 1 ft or 200 x 10 x 1 ft of access road per well"]

{"sheet":"Well Site Rem. Estimate","index":9,"n_rows":71,"n_cols":16,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Well Site Remediation Cost Estimation"]
[]
[]
[]
[null,"Operator Name:",null,"Generic Oil Company"]
[null,"Operator Code:",null,"X1234"]
[null,"Lease Name:",null,"Lease Name"]
[null,"Field Name:",null,"Field Name"]
[null,"Well Type:",null,"Oil & Gas, Multi-Purpose, Water Disposal, etc."]
[null,"Subject ID:",null,"12345678"]
[null,"Contact Name:",null,"Operator Contact"]
[null,"Contact Email Address:",null,"Operator Contact Email",null,null,null,null,null,null,null,null," "]
[null,"Contact Phone Number:",null,"123-456-7890"]
[null,"Date:",null,{"$f":"TODAY()","v":"2022-04-01"}]
[]
[null,"Cost Element",null,"Total Cost \n($)","Quantity","Unit","Unit Cost \n($)","% of Total Cost","Description"]
[null,"Well Site Equipment Removal"]
[null,null,"Above-Ground Pipelines",{"$f":"IFERROR((E21*G21),\"\")","v":2971.2102498530699},100,"LF",29.712102498530697,{"$f":"IFERROR((D21/$D$39),\"\")","v":7.316912689747597E-2},"Remove and dispose of pipelines: transmission, flowline, injection, gathering lines, vent, process piping."]
[null,null,"Buried Pipelines",602.87999414784031,50,"LF",12.057599882956806,{"$f":"IFERROR((D22/$D$39),\"\")","v":1.4846543693073993E-2},"Any remaining buried pipelines must be purged, capped, and filled with an inert fluid."]
[null,null,"Electrical Vaults & Equipment",779.22424242424233,2,"TON",389.61212121212117,{"$f":"IFERROR((D23/$D$39),\"\")","v":1.9189203281170842E-2},"Remove and dispose of electrical equipment: poles, transformers, switchgear, cables, wires, conduit, switches, monitoring equipment."]
[null,null,"Asphalt & Concrete",2916.2014010119651,300,"CF",9.72067133670655,{"$f":"IFERROR((D24/$D$39),\"\")","v":7.1814477073708735E-2},"Remove and dispose of concrete pads and asphalt."]
[null,null,"Pumps",4385.7895977011494,1,"EA",4385.7895977011494,{"$f":"IFERROR((D25/$D$39),\"\")","v":0.10800460709089658},"Remove and dispose of pumps."]
[null,null,"Subtotal",{"$f":"SUM(D21:D25)","v":11655.305485138266},null,null,null,{"$f":"SUM(H21:H25)","v":0.28702395803632613}]
[]
[null,"Site Remediation"]
[null,null,"Wellhead",{"$f":"IFERROR((E29*G29),\"\")","v":10158.034921482978},1,"EA",10158.034921482978,{"$f":"IFERROR((D29/$D$39),\"\")","v":0.25015212108794227},"Site remediation for the area around a wellhead including contaminated soil excavation & disposal, waste removal, site restoration, and access road removal."]
[null,null,"Well Cellars",{"$f":"IFERROR((E30*G30),\"\")","v":8540.2148275862055},1,"EA",8540.2148275862055,{"$f":"IFERROR((D30/$D$39),\"\")","v":0.21031162721731389},"Remove and dispose of well cellars."]
[null,null,"Refuse Removal",1371,10,"CY",137.1,{"$f":"IFERROR((D31/$D$39),\"\")","v":3.3762293658417555E-2},"Remove and dispose of all refuse, trash, debris, construction materials, production pads, piers, fencing outside the area of a wellhead but within a well site."]
[null,null,"Subtotal",{"$f":"SUM(D29:D31)","v":20069.249749069182},null,null,null,{"$f":"SUM(H29:H31)","v":0.4942260419636737}]
[]
[null,"Contingency",null,{"$f":"SUM(D26,D32)*E34","v":3172.4555234207451},{"$f":"'Contingency Calculation'!F20","v":"10%"},null,null,{"$f":"IFERROR((D34/$D$39),\"\")","v":7.8124999999999986E-2},"Contingency calculated from the Contingency tab."]
[null,"Permitting & Regulatory Compliance",null,{"$f":"SUM(D26,D32)*E35","v":1586.2277617103725},0.05,null,null,{"$f":"IFERROR((D35/$D$39),\"\")","v":3.9062499999999993E-2},"Costs to develop and obtain permits to perform the decommissioning and site remediation scope of work."]
[null,"Mobilization & Demobilization",null,{"$f":"SUM(D26,D32)*E36","v":1586.2277617103725},0.05,null,null,3.9062499999999993E-2,"Mobilization and Demobilization of equipment and crews to start and finish the project."]
[null,"Project Management & Engineering",null,{"$f":"SUM(D26,D32)*E37","v":2537.9644187365957},0.08,null,null,6.2499999999999979E-2,"Costs for Project Management & Engineering"]
[]
[null,"TOTAL COST ESTIMATE",null,{"$f":"D26+D32+D34+D35+D36+D37","v":40607.430699785546},null,null,null,{"$f":"IFERROR((H26+H32+H34+H35+H36+H37),\"\")","v":0.99999999999999978}]
[]
[null,"Comments",null,null,null,null,null,null,null,"Acronym","Unit of Measure",null,null,"     WellSTAR Input"]
[null,"Please provide additional scope of work information here.\n",null,null,null,null,null,null,null,"CF","Cubic Foot",null,"Site Remediation",null,null,{"$f":"D39","v":40607.430699785546}]
[null,null,null,null,null,null,null,null,null,"EA","Each"]
[null,null,null,null,null,null,null,null,null,"LF","Linear Foot"]
[null,null,null,null,null,null,null,null,null,"LS","Lump Sum"]
[null,null,null,null,null,null,null,null,null,"TON","Ton"]
[null,null,null,null,null,null,null,null,null,"CY","Cubic Yard"]
[null,null,null,null,null,null,null,null,null,"SF","Square Foot"]
[]
[null,null,"Default Assumptions Per Equipment"]
[null,"Facilities Decommissioning",null,null,"Unit","Tank","Well","Vessel","Comments"]
[null,null,"Above-Ground Pipelines",null,"LF",150,100,{"$f":"F52","v":150},"150 feet per tank & vessel, 100 feet per well"]
[null,null,"Buried Pipelines",null,"LF",100,50,{"$f":"F53","v":100},"100 feet per tank & vessel, 50 feet per well"]
[null,null,"Electrical Vaults & Equipment",null,"TON",2,{"$f":"F54","v":2},{"$f":"F54","v":2},"2 tons of electrical equipment per tank, well, vessel"]
[null,null,"Asphalt & Concrete Per Pump",null,"CF",null,{"$f":"20*5*3","v":300},null,"20 x 5 x 3 ft concrete pad per pumping unit"]
[]
[null,"Site Remediation"]
[null,null,"Contaminated Soil Excavation Per Well",null,"CF",null,{"$f":"8*8*6","v":384},null,"8 x 8 x 6 ft of contaminated soil per well"]
[null,null,"Contaminated Soil Excavation Per Vessel",null,"CF",null,null,{"$f":"F60","v":441},"21 x 21 x 1 ft of contaminated soil per vessel"]
[null,null,"Contaminated Soil Excavation Per Tank (<2.5k bbl)",null,"CF",{"$f":"21*21*1","v":441},null,null,"21 x 21 x 1 ft of contaminated soil per tank"]
[null,null,"Contaminated Soil Excavation Per Tank (2.5k-5k bbl)",null,"CF",{"$f":"30*30*2","v":1800},null,null,"30 x 30 x 2 ft of contaminated soil per tank"]
[null,null,"Contaminated Soil Excavation Per Tank (5k-10k bbl)",null,"CF",{"$f":"40*40*3","v":4800},null,null,"40 x 40 x 3 ft of contaminated soil per tank"]
[null,null,"Contaminated Soil Excavation Per Tank (>10k bbl)",null,"CF",{"$f":"52*52*4","v":10816},null,null,"52 x 52 x 4 ft of contaminated soil per tank"]
[null,null,"Site Restoration Per Well",null,"CF",null,{"$f":"G71+G58","v":2384},null,"Sum of access road & contaminated soil volumes"]
[null,null,"Site Restoration Per Vessel",null,"CF",null,null,441,"Contaminated soil volume"]
[null,null,"Site Restoration Per Tank (<2.5k bbl)",null,"CF",{"$f":"F60","v":441},null,null,"Contaminated soil volume"]
[null,null,"Site Restoration Per Tank (2.5k-5k bbl)",null,"CF",{"$f":"F61","v":1800},null,null,"Contaminated soil volume"]
[null,null,"Site Restoration Per Tank (5k-10k bbl)",null,"CF",{"$f":"F62","v":4800},null,null,"Contaminated soil volume"]
[null,null,"Site Restoration Per Tank (>10k bbl)",null,"CF",{"$f":"F63","v":10816},null,null,"Contaminated soil volume"]
[null,null,"Waste Removal",null,"CY",10,{"$f":"F70","v":10},{"$f":"F70","v":10},"10 cubic yards of waste per tank, well, vessel"]
[null,null,"Access Road",null,"CF",null,{"$f":"100*20*1","v":2000},null,"100 x 20 x 1 ft or 200 x 10 x 1 ft of access road per well"]

{"sheet":"Well Site Rem. Batch","index":10,"n_rows":66,"n_cols":23,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,"Well Site Remediation Cost Estimation"]
[null,null,null,null,null,null,null,null,null,null,"Batch Template"]
[]
[]
[null,"Operator Name:",null,{"$f":"'Fac. Dec. & Site Rem. Batch'!D7","v":"Generic Oil Company"},null,null,null,null,null,null,null,null,"Contact Email Address:",null,{"$f":"'Fac. Dec. & Site Rem. Batch'!W7","v":"Operator Contact Email"}]
[null,"Operator Code:",null,{"$f":"'Fac. Dec. & Site Rem. Batch'!D8","v":"X1234"},null,null,null,null,null,null,null,null,"Contact Phone Number:",null,{"$f":"'Fac. Dec. & Site Rem. Batch'!W8","v":"Operator Contact Phone"}]
[null,"Contact Name:",null,{"$f":"'Fac. Dec. & Site Rem. Batch'!D9","v":"Operator Contact Name"},null,null,null,null,null,null,null,null,"Date:",null,"Date"]
[]
[null,null,"           Well Information",null,null,null,null,"Well Site Equipment Removal",null,null,null,null,null,"Well Site Remediation",null,null,"       Other Project Components",null,null,null,null,null,"WellSTAR Input"]
[null,"Field","Lease","Well Type","Subject ID",null,"Above-Ground Pipelines","Buried Pipelines","Electrical Vaults & \nEquipment","Asphalt & Concrete","Pumps",null,"Wellhead","Well Cellars","Refuse Removal",null,"Contingency","Permitting & Regulatory \nCompliance","Mobilization & \nDemobilization","Project Management & Engineering",null,"Site Remediation \nTotal Cost","Site Remediation \nTotal Cost"]
[null,null,null,null,"Unit Cost",null,29.712102498530697,12.057599882956806,389.61212121212117,9.72067133670655,4385.7895977011494,null,10158.034921482978,8540.2148275862055,137.1]
[null,null,null,null,"Unit",null,"LF","LF","TON","CF","EA",null,"EA","EA","CY"]
[null,"Field Name","Lease Name","Oil & Gas",12345678,null,100,50,2,300,1,null,1,1,10,null,0.1,0.05,0.05,0.08,null,{"$f":"((G15*$G$13)+(H15*$H$13)+(I15*$I$13)+(J15*$J$13)+(N15*$N$13)+(K15*$K$13)+(M15*$M$13)+(O15*$O$13))+(((G15*$G$13)+(H15*$H$13)+(I15*$I$13)+(J15*$J$13)+(N15*$N$13)+(K15*$K$13)+(M15*$M$13)+(O15*$O$13))*Q15)+(((G15*$G$13)+(H15*$H$13)+(I15*$I$13)+(J15*$J$13)+(N15*$N$13)+(K15*$K$13)+(M15*$M$13)+(O15*$O$13))*R15)+(((G15*$G$13)+(H15*$H$13)+(I15*$I$13)+(J15*$J$13)+(N15*$N$13)+(K15*$K$13)+(M15*$M$13)+(O15*$O$13))*S15)+(((G15*$G$13)+(H15*$H$13)+(I15*$I$13)+(J15*$J$13)+(N15*$N$13)+(K15*$K$13)+(M15*$M$13)+(O15*$O$13))*T15)","v":40607.430699785546},{"$f":"ROUND(V15,0)","v":40607}]
[null,"Field Name","Lease Name","Oil & Gas",12345678,null,100,50,2,300,1,null,1,1,10,null,0.2,0.05,0.05,0.08,null,43779.886223206289,43780]
[null,"Field Name","Lease Name","Oil & Gas",12345678,null,100,50,2,300,1,null,1,1,10,null,0.3,0.05,0.05,0.08,null,46952.34174662704,46952]
[null,"Field Name","Lease Name","Oil & Gas",12345678,null,100,50,2,0,null,null,1,1,null,null,0.1,0.05,0.05,0.08,null,29506.002221432747,29506]
[null,"Field Name","Lease Name","Oil & Gas",12345678,null,100,50,2,0,null,null,1,1,null,null,0.2,0.05,0.05,0.08,null,31811.158644982177,31811]
[null,"Field Name","Lease Name","Oil & Gas",12345678,null,100,50,2,0,null,null,1,1,null,null,0.3,0.05,0.05,0.08,null,34116.315068531614,34116]
[null,"Field Name","Lease Name","Oil & Gas",12345678,null,100,50,2,300,1,null,1,null,null,null,0.1,0.05,0.05,0.08,null,27921.075720475194,27921]
[null,"Field Name","Lease Name","Oil & Gas",12345678,null,100,50,2,300,1,null,1,null,null,null,0.2,0.05,0.05,0.08,null,30102.409761137322,30102]
[null,"Field Name","Lease Name","Oil & Gas",12345678,null,100,50,2,300,1,null,1,null,null,null,0.3,0.05,0.05,0.08,null,32283.743801799443,32284]
[null,"Field Name","Lease Name","Oil & Gas",12345678,null,100,50,2,0,null,null,1,null,null,null,0.1,0.05,0.05,0.08,null,18574.527242122407,18575]
[null,"Field Name","Lease Name","Oil & Gas",12345678,null,100,50,2,0,null,null,1,null,null,null,0.2,0.05,0.05,0.08,null,20025.66218291322,20026]
[null,"Field Name","Lease Name","Oil & Gas",12345678,null,100,50,2,0,null,null,1,null,null,null,0.3,0.05,0.05,0.08,null,21476.797123704033,21477]
[null,"Field Name","Lease Name","Oil & Gas",12345678,null,null,null,null,0,null,null,1,null,null,null,0.1,0.05,0.05,0.08,null,13002.284699498212,13002]
[null,"Field Name","Lease Name","Oil & Gas",12345678,null,null,null,null,0,null,null,1,null,null,null,0.2,0.05,0.05,0.08,null,14018.08819164651,14018]
[null,"Field Name","Lease Name","Oil & Gas",12345678,null,null,null,null,0,null,null,1,null,null,null,0.3,0.05,0.05,0.08,null,15033.891683794807,15034]
[null,"Field Name","Lease Name","Oil & Gas",12345678,null,null,null,null,0,null,null,1,null,null,null,0.1,0.05,0.05,0.08,null,13002.284699498212,13002]
[null,"Field Name","Lease Name","Multi-Purpose",12345678,null,null,null,null,0,null,null,1,null,null,null,0.2,0.05,0.05,0.08,null,14018.08819164651,14018]
[null,"Field Name","Lease Name","Water Disposal",12345678,null,null,null,null,0,null,null,1,null,null,null,0.3,0.05,0.05,0.08,null,15033.891683794807,15034]
[null,null,"Leave this row blank. Insert additonal rows above.",null,null,null,"                  Leave this row blank. Insert additonal rows above.",null,null,null,null,null,"Leave this row blank. Insert additonal rows above.",null,null,null,"   Leave this row blank. Insert additonal rows above."]
[null,null,null,null,"Total",null,{"$f":"IF(SUM(G15:G33)=0,\"\",SUM(G15:G33))","v":1200},600,24,1800,6,null,{"$f":"IF(SUM(M15:M33)=0,\"\",SUM(M15:M33))","v":18},{"$f":"IF(SUM(N15:N33)=0,\"\",SUM(N15:N33))","v":6},{"$f":"IF(SUM(O15:O33)=0,\"\",SUM(O15:O33))","v":30},null,null,null,null,null,null,{"$f":"IF(SUM(V15:V33)=0,\"\",SUM(V15:V33))","v":461265.87958659598},{"$f":"ROUND(V34,0)","v":461266}]
[]
[null,"Comments",null,null,null,null,null,null,null,null,null,null,"Acronym","            Unit of Measure"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CF","                Cubic Foot"]
[null,null,null,null,null,null,null,null,null,null,null,null,"EA","                    Each"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LF","              Linear Foot"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LS","               Lump Sum"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TON","                     Ton"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CY","               Cubic Yard"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SF","             Square Foot"]
[]
[null,null,"Default Assumptions Per Equipment"]
[null,"Facilities Decommissioning",null,null,null,null,"Unit","Tank","Well","Vessel",null,null,null,"Comments"]
[null,"        Above-Ground Pipelines",null,null,null,null,"LF",150,100,{"$f":"H47","v":150},null,null,null,"150 feet per tank & vessel, 100 feet per well"]
[null,"        Buried Pipelines",null,null,null,null,"LF",100,50,{"$f":"H48","v":100},null,null,null,"100 feet per tank & vessel, 50 feet per well"]
[null,"        Electrical Vaults & Equipment",null,null,null,null,"TON",2,{"$f":"H49","v":2},{"$f":"H49","v":2},null,null,null,"2 tons of electrical equipment per tank, well, vessel"]
[null,"        Asphalt & Concrete Per Pump",null,null,null,null,"CF",null,{"$f":"20*5*3","v":300},null,null,null,null,"20 x 5 x 3 ft concrete pad per pumping unit"]
[]
[null,"Site Remediation"]
[null,"        Contaminated Soil Excavation Per Well",null,null,null,null,"CF",null,{"$f":"8*8*6","v":384},null,null,null,null,"8 x 8 x 6 ft of contaminated soil per well"]
[null,"        Contaminated Soil Excavation Per Vessel",null,null,null,null,null,null,null,{"$f":"H55","v":441},null,null,null,"21 x 21 x 1 ft of contaminated soil per vessel"]
[null,"        Contaminated Soil Excavation Per Tank (<2.5k bbl)",null,null,null,null,"CF",{"$f":"21*21*1","v":441},null,null,null,null,null,"21 x 21 x 1 ft of contaminated soil per tank"]
[null,"        Contaminated Soil Excavation Per Tank (2.5k-5k bbl)",null,null,null,null,"CF",{"$f":"30*30*2","v":1800},null,null,null,null,null,"30 x 30 x 2 ft of contaminated soil per tank"]
[null,"        Contaminated Soil Excavation Per Tank (5k-10k bbl)",null,null,null,null,"CF",{"$f":"40*40*3","v":4800},null,null,null,null,null,"40 x 40 x 3 ft of contaminated soil per tank"]
[null,"        Contaminated Soil Excavation Per Tank (>10k bbl)",null,null,null,null,"CF",{"$f":"52*52*4","v":10816},null,null,null,null,null,"52 x 52 x 4 ft of contaminated soil per tank"]
[null,"        Site Restoration Per Well",null,null,null,null,"CF",null,{"$f":"I66+I53","v":2384},null,null,null,null,"Sum of access road & contaminated soil volumes"]
[null,"        Site Restoration Per Tank Vessel",null,null,null,null,null,null,null,441,null,null,null,"Contaminated soil volume"]
[null,"        Site Restoration Per Tank (<2.5k bbl)",null,null,null,null,"CF",{"$f":"H55","v":441},null,null,null,null,null,"Contaminated soil volume"]
[null,"        Site Restoration Per Tank (2.5k-5k bbl)",null,null,null,null,"CF",{"$f":"H56","v":1800},null,null,null,null,null,"Contaminated soil volume"]
[null,"        Site Restoration Per Tank (5k-10k bbl)",null,null,null,null,"CF",{"$f":"H57","v":4800},null,null,null,null,null,"Contaminated soil volume"]
[null,"        Site Restoration Per Tank (>10k bbl)",null,null,null,null,"CF",{"$f":"H58","v":10816},null,null,null,null,null,"Contaminated soil volume"]
[null,"        Waste Removal",null,null,null,null,"CY",10,{"$f":"H65","v":10},{"$f":"H65","v":10},null,null,null,"10 cubic yards of waste per tank, well, vessel"]
[null,"        Access Road",null,null,null,null,"CF",null,{"$f":"100*20*1","v":2000},null,null,null,null,"100 x 20 x 1 ft or 200 x 10 x 1 ft of access road per well"]

{"sheet":"Contingency Calculation","index":11,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"                               Production Facility Decommissioning & Site Remediation Contingency Calculation"]
[]
[]
[]
[null,"Production Facility and Site Location Characteristics",null,null,"Yes/No","Score",null,"Weight","Description"]
[]
[null,null,"Production facility is located in an environmentally sensitive, as defined in sensitive, or urban area, as defined in Section 1760 ",null,"No",{"$f":"IF(E10=\"Yes\",\"10\",\"0\")","v":"0"},null,10,"As defined in § 1760 of the Statues & Regulations"]
[null,null,"Any other conditions that potentially pose a threat to life, health, property, or natural resources ",null,"No",{"$f":"IF(E11=\"Yes\",\"10\",\"0\")","v":"0"},null,10,"Any other conditions that pose a threat to life, health, property, or natural resources "]
[null,null,"History of spills and/or leaks; unlined sumps",null,"No",{"$f":"IF(E12=\"Yes\",\"10\",\"0\")","v":"0"},null,10,"Risk of increased soil contamination."]
[null,null,"Original land type has freshwater aquifer underneath",null,"No",{"$f":"IF(E13=\"Yes\",\"5\",\"0\")","v":"0"},null,5,"Contamination concern into freshwater aquifer"]
[null,null,"Production facility location is in an area of known geologic hazards including subsidence, landslides, or seismicity ",null,"No",{"$f":"IF(E14=\"Yes\",\"5\",\"0\")","v":"0"},null,5,"Facility is located in an area of known geologic hazards, such as subsidence, landslides, or a history of \ndamage to wells and facilities in the area from seismicity."]
[null,null,"Surface obstacles preventing access such as buildings, structures, surface-use, roads, irrigation systems, terrain ",null,"No",{"$f":"IF(E15=\"Yes\",\"5\",\"0\")","v":"0"},null,5,"Facility location has surface obstacles or other impediments preventing access to the location, including but not limited to surface-use activities, irrigation systems, roads, terrain, or restricted access."]
[null,null,"Age of facility is greater than 50 years",null,"No",{"$f":"IF(E16=\"Yes\",\"5\",\"0\")","v":"0"},null,5,"Older facilities may contain more hazardous building materials such as asbestos, and may have more widespread soil and/or groundwater impacts given the longer operating lifespan of the facility, and historical operational practices. Many older faciltiies may also have a larger footprint compared to newer facilities."]
[null,null,"Notices of violation that are unresolved exist for the production facility",null,"No",{"$f":"IF(E17=\"Yes\",\"5\",\"0\")","v":"0"},null,5," Facility, equipment, pipelines not in use and cannot be put back In-Service until all repairs are completed and the facility is in compliance with all applicable testing and inspection requirements."]
[]
[null,"Total Score",null,null,null,{"$f":"F10+F14+F15+F13+F11+F16+F17+F12","v":0}]
[null,"Contingency %",null,null,null,{"$f":"IF(F19>19, \"30%\", IF(F19>9,\"20%\", \"10%\"))","v":"10%"}]
[]
[null,null,null,null,"                 Contingency Score"]
[null,null,null,null,"<10 Points",0.1]
[null,null,null,null,"10 - 19 Points",0.2]
[null,null,null,null,">20 Points",0.3]

{"sheet":"Cost Summary","index":12,"n_rows":16,"n_cols":30,"rows_kept":16,"cut":false,"hidden":true,"merged":[[3,3,3,5],[1,3,1,5]]}
[]
[null,null,null,"Cost Estimate Summary\n- Operator Liability Report - ",null,null,null,null,null,"References"]
[]
[null,null,null,"Cost"]
[]
[null,"S/N","Type","P&A/Decommissioning","Site Remmediation","Total"]
[null,1,"Well",{"$f":"'Well P&A Cost Estimate'!R53","v":81649.999999999985},17512,{"$f":"D7+E7","v":99161.999999999985}]
[null,2,"Facility",87114,25000,{"$f":"D8+E8","v":112114}]
[null,3,"Lease",null,null,0]
[]
[]
[null,null,"Total",null,null,{"$f":"SUM(F7:F10)","v":211276}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Existing","Facility","90299477","Temescal","Setting","Active","10","Coastal","Temescal","Temescal","03, 04N, 18W, SB",null,"N",null,null,{"$f":"IF(OR(AB14<>\"\",AC14<>\"\"),TEXT(SUM(VALUE(AB14),VALUE(AC14)),\"$#,##0.00\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Existing","Facility","90319516","OOS Tank Facility","Setting","Idle","2","Coastal","Temescal","Temescal","10, 04N, 18W, SB",null,"N",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Existing","Facility","90321134","Temescal 9 Tank","Setting","Idle","1","Coastal","Temescal","Temescal","09, 04N, 18W, SB",null,"N",null,null,""]