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

{"sheet":"Summary","index":0,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[[9,1,9,2]]}
[]
[]
["ORLANDO/ST. CLOUD REGIONAL RESILIENCY CONNECTION"]
["         St. Cloud Central - Magnolia Ranch 230kV Line Option"]
[null,"Customer: ","OUC"]
[null,"Project No: "]
[null,"Description: "]
[null,"Location: ","FL"]
[]
["NO.","DESCRIPTION",null,"Total"]
[]
[1,"St. Cloud Central - Magnolia Ranch 230kV Line (2017 Estimate)",null,57346045.583120406]
[null,"Overhead line"]
[null,"Overhead cost - $37,155,726"]
[null,"Conductor adder - $92,883"]
[null,"Structure adder - $2,672,437"]
[null,"Underground line"]
[null,"Underground cost - $14,300,000"]
[null,"813 MVA, 1272 ACSS/TW"]
[null,"Move spare 230/69kV transformer from South to Central"]
[null,"Leave existing 69kV line in place (no demo work)"]
[null,"No transformer needed at Magnolia Ranch"]
[null,"No transformer or tie into St. Cloud North"]
[2,"Added Specific Cost Components - 2020 Estimates:",null,{"$f":"(D12*2.45)-D12","v":83151766.095524609}]
[null,"Land & Land Rights"]
[null,"Additional Equipment & Installation Costs (e.g., double circuited poles,"]
[null,"     incremental substation infrastructure)"]
[null,"Escalation in labor and steel costs"]
[null,"Land Clearing & Preparation"]
[null,"Contingency"]
[3,"Carl Wall - Dom Toro 69 kV Upgrade - deleted",null,0]
[null,null,"Total Direct Installation ",{"$f":"SUM(D11:D31)","v":140497811.67864501}]

{"sheet":"KQ","index":1,"n_rows":30,"n_cols":16,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[null,"Customer: ",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,null,null,"Key Quantity Summary"]
[null,"Project No: ",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,"Estimator:",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"Description: ",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,"Date:",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"Location: ",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,"Rev:",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[]
["NO.","ACCOUNT",null,"Key Qty","Unit","Unit MH","MH\nLabor","Wage Rate","Labor","Unit","Construction Equipment","Unit Matl","Equipment / Materials","Unit Total","Total"]
[]
[1,"Equipment",null,{"$f":"SUMIFS(#REF!,#REF!,$B8,#REF!,$E8)","v":{"$error":"#REF!"}},"PCS-",{"$f":"IF($D8=0,\"--\",G8/$D8)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B8)","v":{"$error":"#REF!"}},{"$f":"+IF(G8=0,\"--\",I8/G8)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B8)","v":{"$error":"#REF!"}},{"$f":"IF($D8=0,\"--\",K8/$D8)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B8)","v":{"$error":"#REF!"}},{"$f":"IF($D8=0,\"--\",M8/$D8)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B8)","v":{"$error":"#REF!"}},{"$f":"IF($D8=0,\"--\",O8/$D8)","v":{"$error":"#REF!"}},{"$f":"SUM(I8,K8,M8)","v":{"$error":"#REF!"}}]
[2,"Civil",null,{"$f":"SUMIFS(#REF!,#REF!,$B9,#REF!,$E9)","v":{"$error":"#REF!"}},null,{"$f":"IF($D9=0,\"--\",G9/$D9)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B9)","v":{"$error":"#REF!"}},{"$f":"+IF(G9=0,\"--\",I9/G9)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B9)","v":{"$error":"#REF!"}},{"$f":"IF($D9=0,\"--\",K9/$D9)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B9)","v":{"$error":"#REF!"}},{"$f":"IF($D9=0,\"--\",M9/$D9)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B9)","v":{"$error":"#REF!"}},{"$f":"IF($D9=0,\"--\",O9/$D9)","v":{"$error":"#REF!"}},{"$f":"SUM(I9,K9,M9)","v":{"$error":"#REF!"}}]
[3,"Deep Foundations",null,{"$f":"SUMIFS(#REF!,#REF!,$B10,#REF!,$E10)","v":{"$error":"#REF!"}},"Piles-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B10)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B10)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B10)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B10)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[4,"Concrete",null,{"$f":"SUMIFS(#REF!,#REF!,$B11,#REF!,$E11)","v":{"$error":"#REF!"}},"CY-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B11)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B11)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B11)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B11)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Cementitious Grout",null,{"$f":"SUMIFS(#REF!,#REF!,$B12,#REF!,$E12)","v":{"$error":"#REF!"}},"SF-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B12)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B12)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B12)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B12)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Epoxy Grout",null,{"$f":"SUMIFS(#REF!,#REF!,$B13,#REF!,$E13)","v":{"$error":"#REF!"}},"CF-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B13)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B13)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B13)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B13)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[5,"Steel",null,{"$f":"SUMIFS(#REF!,#REF!,$B14,#REF!,$E14)","v":{"$error":"#REF!"}},"TON-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B14)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B14)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B14)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B14)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[6,"Buildings",null,{"$f":"SUMIFS(#REF!,#REF!,$B15,#REF!,$E15)","v":{"$error":"#REF!"}},"SF-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B15)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B15)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B15)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B15)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[7,"Pipe",null,{"$f":"SUMIFS(#REF!,#REF!,$B16,#REF!,$E16)","v":{"$error":"#REF!"}},"LF-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B16)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B16)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B16)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B16)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[8,"Electrical",null,{"$f":"SUMIFS(#REF!,#REF!,$B17,#REF!,$E17)","v":{"$error":"#REF!"}},"LF-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B17)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B17)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B17)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B17)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[9,"Instrument & Control",null,{"$f":"SUMIFS(#REF!,#REF!,$B18,#REF!,$E18)","v":{"$error":"#REF!"}},"EA-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B18)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B18)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B18)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B18)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[10,"Piping Insulation",null,{"$f":"SUMIFS(#REF!,#REF!,$B19,#REF!,$E19)","v":{"$error":"#REF!"}},"LF-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B19)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B19)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B19)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B19)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Equipment Insulation",null,{"$f":"SUMIFS(#REF!,#REF!,$B20,#REF!,$E20)","v":{"$error":"#REF!"}},"SF-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B20)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B20)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B20)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B20)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Fireproofing",null,{"$f":"SUMIFS(#REF!,#REF!,$B21,#REF!,$E21)","v":{"$error":"#REF!"}},"SF-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B21)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B21)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B21)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B21)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[11,"Coatings",null,{"$f":"SUMIFS(#REF!,#REF!,$B22,#REF!,$E22)","v":{"$error":"#REF!"}},"SF-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B22)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B22)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B22)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B22)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[12,"Special",null,{"$f":"SUMIFS(#REF!,#REF!,$B23,#REF!,$E23)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B23)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B23)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B23)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B23)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[13,"Demolition",null,{"$f":"SUMIFS(#REF!,#REF!,$B24,#REF!,$E24)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B24)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B24)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B24)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B24)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[14,"Miscellaneous Directs",null,{"$f":"SUMIFS(#REF!,#REF!,$B25,#REF!,$E25)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B25)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B25)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B25)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B25)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,"Freight",null,null,null,null,null,{"$f":"+IF(G27=0,\"--\",I27/G27)","v":"--"},{"$f":"SUMIFS(#REF!,#REF!,$B27)","v":{"$error":"#REF!"}},"--",{"$f":"SUMIFS(#REF!,#REF!,$B27)","v":{"$error":"#REF!"}},"--",{"$f":"SUMIFS(#REF!,#REF!,$B27)","v":{"$error":"#REF!"}},"--",{"$f":"SUM(I27,K27,M27)","v":{"$error":"#REF!"}}]
[]
[null,null,"Total Direct Cost (TDC)",null,null,null,{"$f":"SUM(G8:G28)","v":{"$error":"#REF!"}},{"$f":"+IF(G29=0,\"--\",I29/G29)","v":{"$error":"#REF!"}},{"$f":"SUM(I8:I28)","v":{"$error":"#REF!"}},null,{"$f":"SUM(K8:K28)","v":{"$error":"#REF!"}},null,{"$f":"SUM(M8:M28)","v":{"$error":"#REF!"}},null,{"$f":"SUM(O8:O28)","v":{"$error":"#REF!"}},{"$f":"ROUND(+O29-M29-K29-I29, 0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(+O29-#REF!, 0)","v":{"$error":"#REF!"}}]

{"sheet":"Area","index":2,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[null,"Customer: ",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,"Area 1 Summary"]
[null,"Project No: ",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,null,null,"Estimator:",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"Description: ",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,null,null,"Date:",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"Location: ",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,null,null,"Rev:",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[]
["NO.","ACCOUNT",null,"MH\nLabor","Wage Rate","Labor","Construction Equipment","Equipment / Materials","Total"]
[]
[null,"Area 1",null,{"$f":"SUMIFS(#REF!,#REF!,$B8)","v":{"$error":"#REF!"}},{"$f":"+IF(D8=0,\"--\",F8/D8)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B8)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B8)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B8)","v":{"$error":"#REF!"}},{"$f":"SUM(F8,G8,H8)","v":{"$error":"#REF!"}},{"$f":"ROUND(SUMIFS(#REF!,#REF!,$B8)-I8, 0)","v":{"$error":"#REF!"}}]
[null,"Area 2",null,{"$f":"SUMIFS(#REF!,#REF!,$B9)","v":{"$error":"#REF!"}},{"$f":"+IF(D9=0,\"--\",F9/D9)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B9)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B9)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B9)","v":{"$error":"#REF!"}},{"$f":"SUM(F9,G9,H9)","v":{"$error":"#REF!"}},{"$f":"ROUND(SUMIFS(#REF!,#REF!,$B9)-I9, 0)","v":{"$error":"#REF!"}}]
[null,"Area 3",null,{"$f":"SUMIFS(#REF!,#REF!,$B10)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B10)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B10)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B10)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"ROUND(SUMIFS(#REF!,#REF!,$B10)-I10, 0)","v":{"$error":"#REF!"}}]
[null,"Area 4",null,{"$f":"SUMIFS(#REF!,#REF!,$B11)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B11)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B11)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B11)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"ROUND(SUMIFS(#REF!,#REF!,$B11)-I11, 0)","v":{"$error":"#REF!"}}]
[null,"Area 5",null,{"$f":"SUMIFS(#REF!,#REF!,$B12)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B12)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B12)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B12)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"ROUND(SUMIFS(#REF!,#REF!,$B12)-I12, 0)","v":{"$error":"#REF!"}}]
[null,"Area 6",null,{"$f":"SUMIFS(#REF!,#REF!,$B13)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B13)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B13)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B13)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"ROUND(SUMIFS(#REF!,#REF!,$B13)-I13, 0)","v":{"$error":"#REF!"}}]
[null,"Area 7",null,{"$f":"SUMIFS(#REF!,#REF!,$B14)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B14)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B14)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B14)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"ROUND(SUMIFS(#REF!,#REF!,$B14)-I14, 0)","v":{"$error":"#REF!"}}]
[null,"Area 8",null,{"$f":"SUMIFS(#REF!,#REF!,$B15)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B15)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B15)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B15)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"ROUND(SUMIFS(#REF!,#REF!,$B15)-I15, 0)","v":{"$error":"#REF!"}}]
[null,"Area 9",null,{"$f":"SUMIFS(#REF!,#REF!,$B16)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B16)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B16)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B16)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"ROUND(SUMIFS(#REF!,#REF!,$B16)-I16, 0)","v":{"$error":"#REF!"}}]
[null,"Area 10",null,{"$f":"SUMIFS(#REF!,#REF!,$B17)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B17)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B17)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B17)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"ROUND(SUMIFS(#REF!,#REF!,$B17)-I17, 0)","v":{"$error":"#REF!"}}]
[null,"Area 11",null,{"$f":"SUMIFS(#REF!,#REF!,$B18)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B18)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B18)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B18)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"ROUND(SUMIFS(#REF!,#REF!,$B18)-I18, 0)","v":{"$error":"#REF!"}}]
[null,"Area 12",null,{"$f":"SUMIFS(#REF!,#REF!,$B19)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B19)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B19)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B19)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"ROUND(SUMIFS(#REF!,#REF!,$B19)-I19, 0)","v":{"$error":"#REF!"}}]
[null,"Area 13",null,{"$f":"SUMIFS(#REF!,#REF!,$B20)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B20)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B20)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B20)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"ROUND(SUMIFS(#REF!,#REF!,$B20)-I20, 0)","v":{"$error":"#REF!"}}]
[null,"Area 14",null,{"$f":"SUMIFS(#REF!,#REF!,$B21)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B21)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B21)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B21)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"ROUND(SUMIFS(#REF!,#REF!,$B21)-I21, 0)","v":{"$error":"#REF!"}}]
[]
[]
[null,null,"Total Direct Cost (TDC)",{"$f":"SUM(D8:D23)","v":{"$error":"#REF!"}},{"$f":"+IF(D24=0,\"--\",F24/D24)","v":{"$error":"#REF!"}},{"$f":"SUM(F8:F23)","v":{"$error":"#REF!"}},{"$f":"SUM(G8:G23)","v":{"$error":"#REF!"}},{"$f":"SUM(H8:H23)","v":{"$error":"#REF!"}},{"$f":"SUM(I8:I23)","v":{"$error":"#REF!"}},{"$f":"ROUND(+I24-H24-G24-F24, 0)","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"+D24-#REF!","v":{"$error":"#REF!"}},null,{"$f":"+F24-#REF!","v":{"$error":"#REF!"}},{"$f":"+G24-#REF!","v":{"$error":"#REF!"}},{"$f":"+H24-#REF!","v":{"$error":"#REF!"}},{"$f":"+I24-#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Area & KQ","index":3,"n_rows":30,"n_cols":17,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[null,"Customer: ",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"+Q1&\" Key Quantity Summary\"","v":"Area 1 Key Quantity Summary"},null,null,null,null,null,null,null,null,"Area 1"]
[null,"Project No: ",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,"Estimator:",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"Description: ",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,"Date:",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"Location: ",{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,"Rev:",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[]
["NO.","ACCOUNT",null,"Key Qty","Unit","Unit MH","MH\nLabor","Wage Rate","Labor","Unit","Construction Equipment","Unit Matl","Equipment / Materials","Unit Total","Total"]
[]
[1,"Equipment",null,{"$f":"SUMIFS(#REF!,#REF!,$B8,#REF!,$E8,#REF!,$Q$1)","v":{"$error":"#REF!"}},"PCS-",{"$f":"IF($D8=0,\"--\",G8/$D8)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B8,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$f":"+IF(G8=0,\"--\",I8/G8)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B8,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$f":"IF($D8=0,\"--\",K8/$D8)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B8,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$f":"IF($D8=0,\"--\",M8/$D8)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B8,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$f":"IF($D8=0,\"--\",O8/$D8)","v":{"$error":"#REF!"}},{"$f":"SUM(I8,K8,M8)","v":{"$error":"#REF!"}}]
[2,"Civil",null,{"$f":"SUMIFS(#REF!,#REF!,$B9,#REF!,$E9)","v":{"$error":"#REF!"}},null,{"$f":"IF($D9=0,\"--\",G9/$D9)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B9,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$f":"+IF(G9=0,\"--\",I9/G9)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B9,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$f":"IF($D9=0,\"--\",K9/$D9)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B9,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$f":"IF($D9=0,\"--\",M9/$D9)","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$B9,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$f":"IF($D9=0,\"--\",O9/$D9)","v":{"$error":"#REF!"}},{"$f":"SUM(I9,K9,M9)","v":{"$error":"#REF!"}}]
[3,"Deep Foundations",null,{"$f":"SUMIFS(#REF!,#REF!,$B10,#REF!,$E10)","v":{"$error":"#REF!"}},"Piles-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B10,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B10,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B10,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B10,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[4,"Concrete",null,{"$f":"SUMIFS(#REF!,#REF!,$B11,#REF!,$E11)","v":{"$error":"#REF!"}},"CY-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B11,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B11,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B11,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B11,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Cementitious Grout",null,{"$f":"SUMIFS(#REF!,#REF!,$B12,#REF!,$E12)","v":{"$error":"#REF!"}},"SF-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B12,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B12,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B12,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B12,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Epoxy Grout",null,{"$f":"SUMIFS(#REF!,#REF!,$B13,#REF!,$E13)","v":{"$error":"#REF!"}},"CF-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B13,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B13,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B13,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B13,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[5,"Steel",null,{"$f":"SUMIFS(#REF!,#REF!,$B14,#REF!,$E14)","v":{"$error":"#REF!"}},"TON-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B14,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B14,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B14,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B14,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[6,"Buildings",null,{"$f":"SUMIFS(#REF!,#REF!,$B15,#REF!,$E15)","v":{"$error":"#REF!"}},"SF-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B15,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B15,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B15,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B15,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[7,"Pipe",null,{"$f":"SUMIFS(#REF!,#REF!,$B16,#REF!,$E16)","v":{"$error":"#REF!"}},"LF-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B16,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B16,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B16,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B16,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[8,"Electrical",null,{"$f":"SUMIFS(#REF!,#REF!,$B17,#REF!,$E17)","v":{"$error":"#REF!"}},"LF-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B17,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B17,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B17,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B17,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[9,"Instrument & Control",null,{"$f":"SUMIFS(#REF!,#REF!,$B18,#REF!,$E18)","v":{"$error":"#REF!"}},"EA-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B18,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B18,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B18,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B18,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[10,"Piping Insulation",null,{"$f":"SUMIFS(#REF!,#REF!,$B19,#REF!,$E19)","v":{"$error":"#REF!"}},"LF-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B19,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B19,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B19,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B19,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Equipment Insulation",null,{"$f":"SUMIFS(#REF!,#REF!,$B20,#REF!,$E20)","v":{"$error":"#REF!"}},"SF-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B20,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B20,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B20,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B20,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Fireproofing",null,{"$f":"SUMIFS(#REF!,#REF!,$B21,#REF!,$E21)","v":{"$error":"#REF!"}},"SF-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B21,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B21,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B21,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B21,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[11,"Coatings",null,{"$f":"SUMIFS(#REF!,#REF!,$B22,#REF!,$E22)","v":{"$error":"#REF!"}},"SF-",{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B22,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B22,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B22,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B22,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[12,"Special",null,{"$f":"SUMIFS(#REF!,#REF!,$B23,#REF!,$E23)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B23,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B23,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B23,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B23,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[13,"Demolition",null,{"$f":"SUMIFS(#REF!,#REF!,$B24,#REF!,$E24)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B24,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B24,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B24,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B24,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[14,"Miscellaneous Directs",null,{"$f":"SUMIFS(#REF!,#REF!,$B25,#REF!,$E25)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B25,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B25,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B25,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B25,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,"Freight",null,null,null,"--",{"$f":"SUMIFS(#REF!,#REF!,$B27,#REF!,$Q$1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUMIFS(#REF!,#REF!,$B27,#REF!,$Q$1)","v":{"$error":"#REF!"}},"--",{"$f":"SUMIFS(#REF!,#REF!,$B27,#REF!,$Q$1)","v":{"$error":"#REF!"}},"--",{"$f":"SUMIFS(#REF!,#REF!,$B27,#REF!,$Q$1)","v":{"$error":"#REF!"}},"--",{"$error":"#REF!"}]
[]
[null,null,"Total Direct Cost (TDC)",null,null,null,{"$f":"SUM(G8:G28)","v":{"$error":"#REF!"}},{"$f":"+IF(G29=0,\"--\",I29/G29)","v":{"$error":"#REF!"}},{"$f":"SUM(I8:I28)","v":{"$error":"#REF!"}},null,{"$f":"SUM(K8:K28)","v":{"$error":"#REF!"}},null,{"$f":"SUM(M8:M28)","v":{"$error":"#REF!"}},null,{"$f":"SUM(O8:O28)","v":{"$error":"#REF!"}},{"$f":"ROUND(+O29-M29-K29-I29, 0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,{"$f":"ROUND(SUMIFS(#REF!,#REF!,$Q$1)-G29, 0)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(SUMIFS(#REF!,#REF!,$Q$1)-I29, 0)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(SUMIFS(#REF!,#REF!,$Q$1)-K29, 0)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(SUMIFS(#REF!,#REF!,$Q$1)-M29, 0)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(SUMIFS(#REF!,#REF!,$Q$1)-O29, 0)","v":{"$error":"#REF!"}}]

{"sheet":"Scenario Options","index":4,"n_rows":296,"n_cols":29,"rows_kept":296,"cut":false,"hidden":true,"merged":[[0,25,0,28],[0,5,0,8],[0,9,0,12],[0,13,0,16],[0,17,0,20],[0,21,0,24]]}
[null,null,null,null,null,"Scenario 1",null,null,null,"Scenario 2",null,null,null,"Scenario 3",null,null,null,"Scenario 4",null,null,null,"Scenario 5",null,null,null,"Scenario 6"]
[null,null,null,null,null,"T1","T4","T5","Total","T1","T4","T5","Total","T1","T4","T5","Total","T1","T4","T5","Total","T1","T4","T5","Total","T1","T4","T5","Total"]
["69kV Conductor & Hardware Only",null,null,null,null,null,1.17,null,{"$f":"SUM(F3:H3)","v":1.17}]
["69kV S/C",null,null,null,null,null,1.92,1.1399999999999999,3.0599999999999996,null,null,null,null,null,2.27,0.65]
["230kV S/C",null,null,null,null,2.6,null,0.33,2.93,null,null,null,null,2.6]
["230kV/69 DC (69kV Vacant)",null,null,null,null,null,null,1.17,1.17]
["230/69kV DC",null,null,null,null,null,null,null,null,2.6,null,1.6,null,null,null,0.65,null,null,2.0499999999999998,{"$f":"1.38+1.16","v":2.54},null,0,2.0499999999999998,{"$f":"0.73+0.71+(2*(0.44))","v":2.3199999999999998},null,1,2.3199999999999998,{"$f":"(2*1.15)+(2*1.15)","v":4.5999999999999996}]
[]
["DESCRIPTION",null,"QTY","UNIT","UM"]
[]
["Site Work"]
[" ",null,null," ",null,null,null,null,{"$f":"SUM(F12:H12)","v":0},null,null,null,{"$f":"SUM(J12:L12)","v":0},null,null,null,{"$f":"SUM(N12:P12)","v":0},null,null,null,{"$f":"SUM(R12:T12)","v":0},null,null,null,{"$f":"SUM(V12:X12)","v":0},null,null,null,{"$f":"SUM(Z12:AB12)","v":0}]
["ROW Clearing & Grubbing",null,{"$f":"(1)*5280*100/43560","v":12.121212121212121},"acre",null,{"$f":"SUM(F4:F7)*5280*30/43560*0.1","v":0.94545454545454555},{"$f":"SUM(G4:G7)*5280*30/43560*0.1","v":0.69818181818181824},0.95999999999999985,{"$f":"SUM(F13:H13)","v":2.6036363636363635},{"$f":"SUM(J4:J7)*5280*30/43560*0.1","v":0.94545454545454555},{"$f":"SUM(K4:K7)*5280*30/43560*0.1","v":0},0.5818181818181819,{"$f":"SUM(J13:L13)","v":1.5272727272727273},{"$f":"SUM(N4:N7)*5280*30/43560*0.1","v":0.94545454545454555},{"$f":"SUM(O4:O7)*5280*30/43560*0.1","v":0.82545454545454544},0.47272727272727277,{"$f":"SUM(N13:P13)","v":2.2436363636363637},{"$f":"SUM(R4:R7)*5280*30/43560*0.1","v":0},{"$f":"SUM(S4:S7)*5280*30/43560*0.1","v":0.74545454545454537},0.9236363636363637,{"$f":"SUM(R13:T13)","v":1.669090909090909},{"$f":"SUM(V4:V7)*5280*30/43560*0.1","v":0},{"$f":"SUM(W4:W7)*5280*30/43560*0.1","v":0.74545454545454537},0.84363636363636363,{"$f":"SUM(V13:X13)","v":1.5890909090909089},{"$f":"SUM(Z4:Z7)*5280*30/43560*0.1","v":0.36363636363636365},{"$f":"SUM(AA4:AA7)*5280*30/43560*0.1","v":0.84363636363636363},1.6727272727272724,{"$f":"SUM(Z13:AB13)","v":2.88}]
["Cut/Fill new yard addition (92,408SF/27+3423CY)",null,null,"CY",0.2,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Silt Fence (Install , Maintain, and Remove)",null,{"$f":"SUM(C67:C101)*100","v":9800},"LF",0.15,{"$f":"200*SUM(F67:F101)","v":4200},{"$f":"200*SUM(G67:G101)","v":3200},4600,12000,{"$f":"200*SUM(J67:J101)","v":4400},{"$f":"200*SUM(K67:K101)","v":0},2800,7200,{"$f":"200*SUM(N67:N101)","v":4200},{"$f":"200*SUM(O67:O101)","v":3800},2200,10200,{"$f":"200*SUM(R67:R101)","v":0},{"$f":"200*SUM(S67:S101)","v":3600},4400,8000,{"$f":"200*SUM(V67:V101)","v":0},{"$f":"200*SUM(W67:W101)","v":3600},4000,7600,{"$f":"200*SUM(Z67:Z101)","v":1800},{"$f":"200*SUM(AA67:AA101)","v":4000},7800,13600]
[" "," ",null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[" "," ",null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[" "," ",null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[" "," ",null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[" "," ",null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[" "," ",null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[" "," ",null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Temporary Access roads",null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Access Roads",null,{"$f":"5*5280*16*0.5/27*0.5","v":3911.1111111111113},"cy",0.09,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Resurface Roadway 3'' Thick",null,null,"sy",0.02,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Temporay Concrete Pole",null,null,"ea",240,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Temporary Steel Pole",null,null,"ea",240,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null," ",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Matting",null,null," ",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null," ",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Wood Timber Matting (8' x 14')",null,{"$f":"5*5280*14*0.25","v":92400},"sf",1.7857142857142856E-2,{"$f":"625*SUM(F67:F101)","v":13125},{"$f":"625*SUM(G67:G101)","v":10000},14375,37500,{"$f":"625*SUM(J67:J101)","v":13750},{"$f":"625*SUM(K67:K101)","v":0},8750,22500,{"$f":"625*SUM(N67:N101)","v":13125},{"$f":"625*SUM(O67:O101)","v":11875},6875,31875,{"$f":"625*SUM(R67:R101)","v":0},{"$f":"625*SUM(S67:S101)","v":11250},13750,25000,{"$f":"625*SUM(V67:V101)","v":0},{"$f":"625*SUM(W67:W101)","v":11250},12500,23750,{"$f":"625*SUM(Z67:Z101)","v":5625},{"$f":"625*SUM(AA67:AA101)","v":12500},24375,42500]
[null,null,null," ",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null," ",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Foundations",null,null," ",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[" ",null,null," ",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Total foundations--New",null,3650,"cy",8,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Receive & Set Cassion",null,{"$f":"SUM(C84:C101)+SUM(C67:C82)*2","v":98},"Ea",16,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Excavation & Concrete Backfill",null,{"$f":"C44*18.2*0.2","v":356.72},"cy",16,{"$f":"SUM(F89,F96,F97)*20","v":80},{"$f":"SUM(G89,G96,G97)*20","v":60},260,400,{"$f":"SUM(J89,J96,J97)*20","v":440},{"$f":"SUM(K89,K96,K97)*20","v":0},280,720,{"$f":"SUM(N89,N96,N97)*20","v":80},{"$f":"SUM(O89,O96,O97)*20","v":80},140,300,{"$f":"SUM(R89,R96,R97)*20","v":0},{"$f":"SUM(S89,S96,S97)*20","v":360},440,800,{"$f":"SUM(V89,V96,V97)*20","v":0},{"$f":"SUM(W89,W96,W97)*20","v":360},400,760,{"$f":"SUM(Z89,Z96,Z97)*20","v":180},{"$f":"SUM(AA89,AA96,AA97)*20","v":400},780,1360]
["Excavation & Rock Backfill",null,{"$f":"C44*18.2*0.8","v":1426.88},"cy",16,{"$f":"SUM(F87,F95)*20","v":340},{"$f":"SUM(G87,G95)*20","v":260},200,800,{"$f":"SUM(J87,J95)*20","v":0},{"$f":"SUM(K87,K95)*20","v":0},0,0,{"$f":"SUM(N87,N95)*20","v":340},{"$f":"SUM(O87,O95)*20","v":300},80,720,{"$f":"SUM(R87,R95)*20","v":0},{"$f":"SUM(S87,S95)*20","v":0},0,0,{"$f":"SUM(V87,V95)*20","v":0},{"$f":"SUM(W87,W95)*20","v":0},0,0,{"$f":"SUM(Z87,Z95)*20","v":0},{"$f":"SUM(AA87,AA95)*20","v":0},0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Grounding",null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Machine Trenching",null,{"$f":"SUM(C67:C101)*(20)","v":1960},"ft",0.02,{"$f":"SUM(F67:F101)*(20)","v":420},{"$f":"SUM(G67:G101)*(20)","v":320},460,1200,{"$f":"SUM(J67:J101)*(20)","v":440},{"$f":"SUM(K67:K101)*(20)","v":0},280,720,{"$f":"SUM(N67:N101)*(20)","v":420},{"$f":"SUM(O67:O101)*(20)","v":380},220,1020,{"$f":"SUM(R67:R101)*(20)","v":0},{"$f":"SUM(S67:S101)*(20)","v":360},440,800,{"$f":"SUM(V67:V101)*(20)","v":0},{"$f":"SUM(W67:W101)*(20)","v":360},400,760,{"$f":"SUM(Z67:Z101)*(20)","v":180},{"$f":"SUM(AA67:AA101)*(20)","v":400},780,1360]
["Hand Trenching",null,null,"ft",0.05,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Main Grd Grid, 500MCM Cu",null,null,"ft",7.0000000000000007E-2,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Main Grd Grid 300 MCM Cu",null,null,"ft",0.05,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Main Grd Grid 4/0 Str bare copper",null,{"$f":"SUM(C67:C101)*(100+20)","v":11760},"ft",0.04,{"$f":"SUM(F67:F101)*(100+20)","v":2520},{"$f":"SUM(G67:G101)*(100+20)","v":1920},2760,7200,{"$f":"SUM(J67:J101)*(100+20)","v":2640},{"$f":"SUM(K67:K101)*(100+20)","v":0},1680,4320,{"$f":"SUM(N67:N101)*(100+20)","v":2520},{"$f":"SUM(O67:O101)*(100+20)","v":2280},1320,6120,{"$f":"SUM(R67:R101)*(100+20)","v":0},{"$f":"SUM(S67:S101)*(100+20)","v":2160},2640,4800,{"$f":"SUM(V67:V101)*(100+20)","v":0},{"$f":"SUM(W67:W101)*(100+20)","v":2160},2400,4560,{"$f":"SUM(Z67:Z101)*(100+20)","v":1080},{"$f":"SUM(AA67:AA101)*(100+20)","v":2400},4680,8160]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Cadweld Shot",null,{"$f":"C59*2","v":196},"ea",0.35,{"$f":"F59*2","v":42},{"$f":"G59*2","v":32},46,120,{"$f":"J59*2","v":44},{"$f":"K59*2","v":0},28,72,{"$f":"N59*2","v":42},{"$f":"O59*2","v":38},22,102,{"$f":"R59*2","v":0},{"$f":"S59*2","v":36},44,80,{"$f":"V59*2","v":0},{"$f":"W59*2","v":36},40,76,{"$f":"Z59*2","v":18},{"$f":"AA59*2","v":40},78,136]
["Mold (1 mold for every sixty shots)",null,{"$f":"ROUNDUP(C57/60,0)","v":4},"ea",0,{"$f":"ROUNDUP(F57/60,0)","v":1},{"$f":"ROUNDUP(G57/60,0)","v":1},1,3,{"$f":"ROUNDUP(J57/60,0)","v":1},{"$f":"ROUNDUP(K57/60,0)","v":0},{"$f":"ROUNDUP(L57/60,0)","v":1},2,{"$f":"ROUNDUP(N57/60,0)","v":1},{"$f":"ROUNDUP(O57/60,0)","v":1},{"$f":"ROUNDUP(P57/60,0)","v":1},3,{"$f":"ROUNDUP(R57/60,0)","v":0},{"$f":"ROUNDUP(S57/60,0)","v":1},{"$f":"ROUNDUP(T57/60,0)","v":1},2,{"$f":"ROUNDUP(V57/60,0)","v":0},{"$f":"ROUNDUP(W57/60,0)","v":1},{"$f":"ROUNDUP(X57/60,0)","v":1},2,{"$f":"ROUNDUP(Z57/60,0)","v":1},{"$f":"ROUNDUP(AA57/60,0)","v":1},{"$f":"ROUNDUP(AB57/60,0)","v":2},4]
["3/4\" X 10' copperweld ground rod ",null,{"$f":"C95+C96+C97","v":98},"ea",1,{"$f":"SUM(F67:F101)","v":21},{"$f":"SUM(G67:G101)","v":16},23,60,{"$f":"SUM(J67:J101)","v":22},{"$f":"SUM(K67:K101)","v":0},14,36,{"$f":"SUM(N67:N101)","v":21},{"$f":"SUM(O67:O101)","v":19},11,51,{"$f":"SUM(R67:R101)","v":0},{"$f":"SUM(S67:S101)","v":18},22,40,{"$f":"SUM(V67:V101)","v":0},{"$f":"SUM(W67:W101)","v":18},20,38,{"$f":"SUM(Z67:Z101)","v":9},{"$f":"SUM(AA67:AA101)","v":20},39,68]
["3/4\" X 20' copperweld ground rod w/coupling ",null,null,"ea",2,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["2 hole ground lug for 4/0 ground wire","Burndy",null,"ea",0.35,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["2 hole ground lug for 300MCM ground wire","Burndy",null,"ea",0.35,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["2 hole ground lug for 500MCM ground wire","Burndy",null,"ea",0.5,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Structures & Poles",null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["15kV H-FRAME SINGLE CIRCUIT ",null,null,"ea",130,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["15kV H-FRAME DOUBLE CIRCUIT",null,null,"ea",130,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["34.5kV H-FRAME SINGLE CIRCUIT ",null,null,"ea",130,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["34.5kV H-FRAME DOUBLE CIRCUIT",null,null,"ea",130,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["69kV H-FRAME SINGLE CIRCUIT ",null,null,"ea",130,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["69kV H-FRAME DOUBLE CIRCUIT",null,null,"ea",130,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["115kV H-FRAME SINGLE CIRCUIT ",null,null,"ea",180,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["115kV H-FRAME DOUBLE CIRCUIT",null,null,"ea",180,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["138kV H-FRAME SINGLE CIRCUIT ",null,null,"ea",180,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["138kV H-FRAME DOUBLE CIRCUIT",null,null,"ea",180,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["230kV H-FRAME SINGLE CIRCUIT",null,null,"ea",200,null,null,null,{"$f":"SUM(F77:H77)","v":0},null,null,null,{"$f":"SUM(J77:L77)","v":0},null,null,null,{"$f":"SUM(N77:P77)","v":0},null,null,null,{"$f":"SUM(R77:T77)","v":0},null,null,null,{"$f":"SUM(V77:X77)","v":0},null,null,null,{"$f":"SUM(Z77:AB77)","v":0}]
["230kV H-FRAME DOUBLE CIRCUIT",null,null,"ea",220,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["345kV H-FRAME SINGLE CIRCUIT ",null,null,"ea",260,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["345kV H-FRAME DOUBLE CIRCUIT",null,null,"ea",260,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["500kV H-FRAME SINGLE CIRCUIT ",null,null,"ea",300,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["500kV H-FRAME DOUBLE CIRCUIT",null,null,"ea",300,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["15kV MONOPOLE SINGLE CIRCUIT ",null,null,"ea",80,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["15kV MONOPOLE DOUBLE CIRCUIT",null,null,"ea",80,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["69kV 3-POLE CONCRETE DE SINGLE CIRCUIT",null,null,"ea",97,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["69kV LD-10 STEEL TAN SINGLE CIRCUIT",null,null,"ea",97,{"$f":"ROUND(F$4*5280/630*0.8, 0)","v":0},{"$f":"ROUND(G$4*5280/630*0.8, 0)","v":13},{"$f":"ROUND(H$4*5280/630*0.8, 0)","v":8},21,0,{"$f":"ROUND(K$4*5280/630*0.8, 0)","v":0},{"$f":"ROUND(L$4*5280/630*0.8, 0)","v":0},0,{"$f":"ROUND(N$4*5280/630*0.8, 0)","v":0},{"$f":"ROUND(O$4*5280/630*0.8, 0)","v":15},{"$f":"ROUND(P$4*5280/630*0.8, 0)","v":4},19,{"$f":"ROUND(R$4*5280/630*0.8, 0)","v":0},{"$f":"ROUND(S$4*5280/630*0.8, 0)","v":0},{"$f":"ROUND(T$4*5280/630*0.8, 0)","v":0},0,{"$f":"ROUND(V$4*5280/630*0.8, 0)","v":0},{"$f":"ROUND(W$4*5280/630*0.8, 0)","v":0},{"$f":"ROUND(X$4*5280/630*0.8, 0)","v":0},0,{"$f":"ROUND(Z$4*5280/630*0.8, 0)","v":0},{"$f":"ROUND(AA$4*5280/630*0.8, 0)","v":0},{"$f":"ROUND(AB$4*5280/630*0.8, 0)","v":0},0]
["69kV TEMPORARY STRUCTURES",null,null,"ea",97,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["69kV LD-10 STEEL DE SINGLE CIRCUIT",null,null,"ea",97,{"$f":"ROUND(F$4*5280/630*0.2, 0)","v":0},{"$f":"ROUND(G$4*5280/630*0.2, 0)","v":3},{"$f":"ROUND(H$4*5280/630*0.2, 0)","v":2},5,0,{"$f":"ROUND(K$4*5280/630*0.2, 0)","v":0},{"$f":"ROUND(L$4*5280/630*0.2, 0)","v":0},0,{"$f":"ROUND(N$4*5280/630*0.2, 0)","v":0},{"$f":"ROUND(O$4*5280/630*0.2, 0)","v":4},{"$f":"ROUND(P$4*5280/630*0.2, 0)","v":1},5,{"$f":"ROUND(R$4*5280/630*0.2, 0)","v":0},{"$f":"ROUND(S$4*5280/630*0.2, 0)","v":0},{"$f":"ROUND(T$4*5280/630*0.2, 0)","v":0},0,{"$f":"ROUND(V$4*5280/630*0.2, 0)","v":0},{"$f":"ROUND(W$4*5280/630*0.2, 0)","v":0},{"$f":"ROUND(X$4*5280/630*0.2, 0)","v":0},0,{"$f":"ROUND(Z$4*5280/630*0.2, 0)","v":0},{"$f":"ROUND(AA$4*5280/630*0.2, 0)","v":0},{"$f":"ROUND(AB$4*5280/630*0.2, 0)","v":0},0]
["115kV 3-POLE CONCRETE DE SINGLE CIRCUIT",null,null,"ea",97,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["115kV STEEL SINGLE CIRCUIT DE",null,null,"ea",97,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["115kV CONCRETE TAN DOUBLE CIRCUIT",null,null,"ea",97,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["138kV MONOPOLE SINGLE CIRCUIT ",null,null,"ea",120,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["138kV MONOPOLE DOUBLE CIRCUIT",null,null,"ea",120,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["230kV CONCRETE TAN SINGLE CIRCUIT",null,0,"ea",120,{"$f":"ROUND(F$5*5280/630*0.8, 0)","v":17},{"$f":"ROUND(G$5*5280/630*0.8, 0)","v":0},2,19,{"$f":"ROUND(J$5*5280/630*0.8, 0)","v":0},{"$f":"ROUND(K$5*5280/630*0.8, 0)","v":0},0,0,{"$f":"ROUND(N$5*5280/630*0.8, 0)","v":17},{"$f":"ROUND(O$5*5280/630*0.8, 0)","v":0},0,17,{"$f":"ROUND(R$5*5280/630*0.8, 0)","v":0},{"$f":"ROUND(S$5*5280/630*0.8, 0)","v":0},0,0,{"$f":"ROUND(V$5*5280/630*0.8, 0)","v":0},{"$f":"ROUND(W$5*5280/630*0.8, 0)","v":0},0,0,{"$f":"ROUND(Z$5*5280/630*0.8, 0)","v":0},{"$f":"ROUND(AA$5*5280/630*0.8, 0)","v":0},0,0]
["230kV MONOPOLE SINGLE CIRCUIT DE",null,0,"ea",120,{"$f":"ROUND(F$5*5280/630*0.2, 0)","v":4},{"$f":"ROUND(G$5*5280/630*0.2, 0)","v":0},1,5,{"$f":"ROUND(J$5*5280/630*0.2, 0)","v":0},{"$f":"ROUND(K$5*5280/630*0.2, 0)","v":0},0,0,{"$f":"ROUND(N$5*5280/630*0.2, 0)","v":4},{"$f":"ROUND(O$5*5280/630*0.2, 0)","v":0},0,4,{"$f":"ROUND(R$5*5280/630*0.2, 0)","v":0},{"$f":"ROUND(S$5*5280/630*0.2, 0)","v":0},0,0,{"$f":"ROUND(V$5*5280/630*0.2, 0)","v":0},{"$f":"ROUND(W$5*5280/630*0.2, 0)","v":0},0,0,{"$f":"ROUND(Z$5*5280/630*0.2, 0)","v":0},{"$f":"ROUND(AA$5*5280/630*0.2, 0)","v":0},0,0]
["230/69kV MONOPOLE DOUBLE CIRCUIT",null,98,"ea",130,{"$f":"ROUNDUP(SUM(F$6,F$7)*5280/630,0)","v":0},{"$f":"ROUNDUP(SUM(G$6,G$7)*5280/630,0)","v":0},10,10,{"$f":"ROUNDUP(SUM(J$6,J$7)*5280/630,0)","v":22},{"$f":"ROUNDUP(SUM(K$6,K$7)*5280/630,0)","v":0},14,36,{"$f":"ROUNDUP(SUM(N$6,N$7)*5280/630,0)","v":0},{"$f":"ROUNDUP(SUM(O$6,O$7)*5280/630,0)","v":0},6,6,{"$f":"ROUNDUP(SUM(R$6,R$7)*5280/630,0)","v":0},{"$f":"ROUNDUP(SUM(S$6,S$7)*5280/630,0)","v":18},22,40,{"$f":"ROUNDUP(SUM(V$6,V$7)*5280/630,0)","v":0},{"$f":"ROUNDUP(SUM(W$6,W$7)*5280/630,0)","v":18},20,38,{"$f":"ROUNDUP(SUM(Z$6,Z$7)*5280/630,0)","v":9},{"$f":"ROUNDUP(SUM(AA$6,AA$7)*5280/630,0)","v":20},39,68]
["345kV MONOPOLE SINGLE CIRCUIT ",null,null,"ea",150,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["345kV MONOPOLE DOUBLE CIRCUIT",null,null,"ea",160,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["500kV MONOPOLE SINGLE CIRCUIT ",null,null,"ea",150,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["500kV MONOPOLE DOUBLE CIRCUIT",null,null,"ea",160,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["LATTICE STRUCTURES (BY LB)",null,null,"LBS",1.4375000000000001E-2,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Pole Assemblies",null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["69kV Polymer Strain String Assembly",null,null,"ea",2.7564705882352944,{"$f":"F110","v":0},{"$f":"G110","v":39},24,63,{"$f":"J110","v":0},{"$f":"K110","v":0},0,0,{"$f":"N110","v":0},{"$f":"O110","v":45},12,57,{"$f":"R110","v":0},{"$f":"S110","v":0},0,0,{"$f":"V110","v":0},{"$f":"W110","v":0},0,0,{"$f":"Z110","v":0},{"$f":"AA110","v":0},0,0]
["69kV Porcelain V-String Suspension Assembly",null,null,"ea",3.9017647058823526,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["69kV Porcelain Braced Post Assembly",null,0,"ea",7.4347058823529402,{"$f":"F87*3","v":0},{"$f":"G87*3","v":39},24,63,{"$f":"J87*3","v":0},{"$f":"K87*3","v":0},0,0,{"$f":"N87*3","v":0},{"$f":"O87*3","v":45},12,57,{"$f":"R87*3","v":0},{"$f":"S87*3","v":0},0,0,{"$f":"V87*3","v":0},{"$f":"W87*3","v":0},0,0,{"$f":"Z87*3","v":0},{"$f":"AA87*3","v":0},0,0]
["69kV Porcelain Dual I-String Assembly",null,null,"ea",4.5229411764705878,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["69kV Porcelain Deadend Assembly",null,null,"ea",8,{"$f":"F89*6","v":0},{"$f":"G89*6","v":18},12,30,{"$f":"J89*6","v":0},{"$f":"K89*6","v":0},0,0,{"$f":"N89*6","v":0},{"$f":"O89*6","v":24},6,30,{"$f":"R89*6","v":0},{"$f":"S89*6","v":0},0,0,{"$f":"V89*6","v":0},{"$f":"W89*6","v":0},0,0,{"$f":"Z89*6","v":0},{"$f":"AA89*6","v":0},0,0]
["69kV Polymer Post Assembly",null,null,"ea",4.95,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["69kV Swinging Angle Bracket",null,null,"ea",3.3970588235294117,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["69kV Wood Tangent Crossarm w/ 2 X-Brace Assy",null,null,"ea",15.315882352941177,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["69kV Wood Small Angle Crossarm w/ 1 X-Brace Assy",null,null,"ea",26.555294117647062,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["69kV 45° Wood Deadend Crossarm Assembly",null,null,"ea",80.811176470588251,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["69kV 90° Wood Deadend Crossarm Assembly",null,null,"ea",81.548823529411777,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["69kV 31' Wood Deadend X-Brace Assembly",null,null,"ea",6.7941176470588234,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["69kV Steel Tangent Crossarm & X-Brace Assembly",null,null,"ea",14.558823529411764,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["69kV 45° Steel Deadend Crossarm Assembly",null,null,"ea",40.764705882352949,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["69kV 90° Steel Deadend Crossarm Assembly",null,null,"ea",48.529411764705884,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["69kV 31' Steel Deadend X-Brace Assembly",null,null,"ea",4.8529411764705879,{"$f":"F112","v":0},{"$f":"G112","v":18},12,30,{"$f":"J112","v":0},{"$f":"K112","v":0},0,0,{"$f":"N112","v":0},{"$f":"O112","v":24},6,30,{"$f":"R112","v":0},{"$f":"S112","v":0},0,0,{"$f":"V112","v":0},{"$f":"W112","v":0},0,0,{"$f":"Z112","v":0},{"$f":"AA112","v":0},0,0]
["69kV Steel Jumper Arm Assembly",null,null,"ea",2.9117647058823533,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["138kV Porcelain I-String Suspension Assembly",null,null,"ea",3.2158823529411769,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["138kV Porcelain V-String Suspension Assembly",null,null,"ea",4.5520588235294115,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["138kV Porcelain Braced Post Assembly",null,null,"ea",8.6738235294117629,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["138kV Porcelain Dual I-String Assembly",null,null,"ea",5.2767647058823526,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["138kV Porcelain Deadend Assembly",null,null,"ea",8,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["138kV Porcelain Jumper Post Assembly",null,null,"ea",5.7749999999999995,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["138kV Swinging Angle Bracket",null,null,"ea",3.9632352941176472,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["138kV Wood Tangent Crossarm w/ 2 X-Brace Assy",null,null,"ea",17.868529411764705,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["138kV Wood Small Angle Crossarm w/ 1 X-Brace Assy",null,null,"ea",30.981176470588238,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["138kV 45° Wood Deadend Crossarm Assembly",null,null,"ea",94.279705882352957,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["138kV 90° Wood Deadend Crossarm Assembly",null,null,"ea",95.140294117647073,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["138kV 31' Wood Deadend X-Brace Assembly",null,null,"ea",7.9264705882352944,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["138kV Steel Tangent Crossarm & X-Brace Assembly",null,null,"ea",16.985294117647058,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["138kV 45° Steel Deadend Crossarm Assembly",null,null,"ea",47.558823529411768,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["138kV 90° Steel Deadend Crossarm Assembly",null,null,"ea",56.617647058823529,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["138kV 31' Steel Deadend X-Brace Assembly",null,null,"ea",5.6617647058823524,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["138kV Steel Jumper Arm Assembly",null,null,"ea",3.3970588235294121,null,null,null,{"$f":"SUM(F141:H141)","v":0},null,null,null,{"$f":"SUM(J141:L141)","v":0},null,null,null,{"$f":"SUM(N141:P141)","v":0},null,null,null,{"$f":"SUM(R141:T141)","v":0},null,null,null,{"$f":"SUM(V141:X141)","v":0},null,null,null,{"$f":"SUM(Z141:AB141)","v":0}]
["230kV Porcelain I-String Suspension Assembly",null,null,"ea",4.1347058823529421,{"$f":"F144","v":51},{"$f":"G144","v":0},36,87,{"$f":"J144","v":66},{"$f":"K144","v":0},42,108,{"$f":"N144","v":51},{"$f":"O144","v":0},18,69,{"$f":"R144","v":0},{"$f":"S144","v":54},66,120,{"$f":"V144","v":0},{"$f":"W144","v":54},60,114,{"$f":"Z144","v":27},{"$f":"AA144","v":60},117,204]
["230kV Porcelain V-String Suspension Assembly",null,null,"ea",5.8526470588235293,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["230kV Porcelain Braced Post Assembly",null,246,"ea",11.152058823529412,{"$f":"SUM(F95,F97)*3","v":51},{"$f":"SUM(G95,G97)*3","v":0},36,87,{"$f":"SUM(J95,J97)*3","v":66},{"$f":"SUM(K95,K97)*3","v":0},42,108,{"$f":"SUM(N95,N97)*3","v":51},{"$f":"SUM(O95,O97)*3","v":0},18,69,{"$f":"SUM(R95,R97)*3","v":0},{"$f":"SUM(S95,S97)*3","v":54},66,120,{"$f":"SUM(V95,V97)*3","v":0},{"$f":"SUM(W95,W97)*3","v":54},60,114,{"$f":"SUM(Z95,Z97)*3","v":27},{"$f":"SUM(AA95,AA97)*3","v":60},117,204]
["230kV Porcelain Dual I-String Assembly",null,null,"ea",6.7844117647058821,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["230kV Porcelain Deadend Assembly",null,96,"ea",8,{"$f":"F96*6","v":24},{"$f":"G96*6","v":0},6,30,{"$f":"J96*6","v":0},{"$f":"K96*6","v":0},0,0,{"$f":"N96*6","v":24},{"$f":"O96*6","v":0},0,24,{"$f":"R96*6","v":0},{"$f":"S96*6","v":0},0,0,{"$f":"V96*6","v":0},{"$f":"W96*6","v":0},0,0,{"$f":"Z96*6","v":0},{"$f":"AA96*6","v":0},0,0]
["230kV Porcelain Jumper Post Assembly",null,24,"ea",7.4249999999999998,{"$f":"F146","v":24},{"$f":"G146","v":0},6,30,{"$f":"J146","v":0},{"$f":"K146","v":0},{"$f":"L146","v":0},0,{"$f":"N146","v":24},{"$f":"O146","v":0},{"$f":"P146","v":0},24,{"$f":"R146","v":0},{"$f":"S146","v":0},{"$f":"T146","v":0},0,{"$f":"V146","v":0},{"$f":"W146","v":0},{"$f":"X146","v":0},0,{"$f":"Z146","v":0},{"$f":"AA146","v":0},{"$f":"AB146","v":0},0]
["230kV Swinging Angle Bracket",null,null,"ea",5.0955882352941178,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["230kV Wood Tangent Crossarm w/ 2 X-Brace Assy",null,null,"ea",22.973823529411767,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["230kV Wood Small Angle Crossarm w/ 1 X-Brace Assy",null,null,"ea",39.832941176470598,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["230kV 45° Wood Deadend Crossarm Assembly",null,null,"ea",121.21676470588238,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["230kV 90° Wood Deadend Crossarm Assembly",null,null,"ea",122.32323529411767,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["230kV 31' Wood Deadend X-Brace Assembly",null,null,"ea",10.191176470588236,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["230kV Steel Tangent Crossarm & X-Brace Assembly",null,null,"ea",21.838235294117649,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["230kV 45° Steel Deadend Crossarm Assembly",null,null,"ea",61.14705882352942,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["230kV 90° Steel Deadend Crossarm Assembly",null,null,"ea",72.794117647058826,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["230kV 31' Steel Deadend X-Brace Assembly",null,null,"ea",7.2794117647058822,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["230kV Steel Jumper Arm Assembly",null,null,"ea",4.3676470588235299,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["345kV Porcelain I-String Suspension Assembly",null,null,"ea",4.5941176470588241,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["345kV Porcelain V-String Suspension Assembly",null,null,"ea",6.5029411764705882,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["345kV Porcelain Braced Post Assembly",null,null,"ea",12.391176470588235,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["345kV Porcelain Dual I-String Assembly",null,null,"ea",7.5382352941176469,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["345kV Porcelain Deadend Assembly",null,null,"ea",10,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["345kV Porcelain Jumper Post Assembly",null,null,"ea",8.25,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["345kV Swinging Angle Bracket",null,null,"ea",5.6617647058823533,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["345kV Wood Tangent Crossarm w/ 2 X-Brace Assy",null,null,"ea",25.526470588235295,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["345kV Wood Small Angle Crossarm w/ 1 X-Brace Assy",null,null,"ea",44.258823529411771,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["345kV 45° Wood Deadend Crossarm Assembly",null,null,"ea",134.68529411764709,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["345kV 90° Wood Deadend Crossarm Assembly",null,null,"ea",135.91470588235296,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["345kV 31' Wood Deadend X-Brace Assembly",null,null,"ea",11.323529411764707,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["345kV Steel Tangent Crossarm & X-Brace Assembly",null,null,"ea",24.264705882352942,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["345kV 45° Steel Deadend Crossarm Assembly",null,null,"ea",67.941176470588246,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["345kV 90° Steel Deadend Crossarm Assembly",null,null,"ea",80.882352941176478,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["345kV 31' Steel Deadend X-Brace Assembly",null,null,"ea",8.0882352941176467,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["345kV Steel Jumper Arm Assembly",null,null,"ea",4.8529411764705888,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["500kV Porcelain I-String Suspension Assembly",null,null,"ea",38.4,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["500kV Porcelain V-String Suspension Assembly",null,null,"ea",57.6,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["500kV Porcelain Braced Post Assembly",null,null,"ea",13.630294117647059,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["500kV Porcelain Dual I-String Assembly",null,null,"ea",8.2920588235294126,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["500kV Porcelain Deadend Assembly",null,null,"ea",26.9,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["500kV Porcelain Jumper Post Assembly",null,null,"ea",16.3,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["500kV Swinging Angle Bracket",null,null,"ea",6.2279411764705888,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["500kV Wood Tangent Crossarm w/ 2 X-Brace Assy",null,null,"ea",28.079117647058826,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["500kV Wood Small Angle Crossarm w/ 1 X-Brace Assy",null,null,"ea",48.684705882352951,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["500kV 45° Wood Deadend Crossarm Assembly",null,null,"ea",148.15382352941182,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["500kV 90° Wood Deadend Crossarm Assembly",null,null,"ea",149.50617647058826,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["500kV 31' Wood Deadend X-Brace Assembly",null,null,"ea",12.455882352941178,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["500kV Steel Tangent Crossarm & X-Brace Assembly",null,null,"ea",26.691176470588239,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["500kV 45° Steel Deadend Crossarm Assembly",null,null,"ea",74.735294117647072,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["500kV 90° Steel Deadend Crossarm Assembly",null,null,"ea",88.97058823529413,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["500kV 31' Steel Deadend X-Brace Assembly",null,null,"ea",8.897058823529413,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["500kV Steel Jumper Arm Assembly",null,null,"ea",5.3382352941176476,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["  ",null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["OHGW Support Assembly",null,null,"ea",0.80882352941176472,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["OHGW Suspension Assembly",null,0,"ea",2.2000000000000002,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["OHGW Running Angle Suspension Assembly",null,null,"ea",1.6176470588235294,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["OHGW Deadend Assembly",null,null,"ea",4.5,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["OHGW Damper, Spiral",null,null,"ea",0.6470588235294118,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["OPGW Suspension Assembly",null,164,"ea",1.8764705882352941,{"$f":"0.8*SUM(F67:F101)","v":16.8},{"$f":"0.8*SUM(G67:G101)","v":12.8},18.400000000000002,48,{"$f":"0.8*SUM(J67:J101)","v":17.600000000000001},{"$f":"0.8*SUM(K67:K101)","v":0},11.200000000000001,28.800000000000004,{"$f":"0.8*SUM(N67:N101)","v":16.8},{"$f":"0.8*SUM(O67:O101)","v":15.200000000000001},8.8000000000000007,40.799999999999997,{"$f":"0.8*SUM(R67:R101)","v":0},{"$f":"0.8*SUM(S67:S101)","v":14.4},17.600000000000001,32,{"$f":"0.8*SUM(V67:V101)","v":0},{"$f":"0.8*SUM(W67:W101)","v":14.4},16,30.4,{"$f":"0.8*SUM(Z67:Z101)","v":7.2},{"$f":"0.8*SUM(AA67:AA101)","v":16},31.200000000000003,54.400000000000006]
["OPGW Running Angle Suspension Assembly",null,null,"ea",2.2000000000000002,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["OPGW Deadend Assembly",null,64,"ea",4.4647058823529422,{"$f":"0.2*SUM(F67:F101)","v":4.2},{"$f":"0.2*SUM(G67:G101)","v":3.2},4.6000000000000005,12,{"$f":"0.2*SUM(J67:J101)","v":4.4000000000000004},{"$f":"0.2*SUM(K67:K101)","v":0},2.8000000000000003,7.2000000000000011,{"$f":"0.2*SUM(N67:N101)","v":4.2},{"$f":"0.2*SUM(O67:O101)","v":3.8000000000000003},2.2000000000000002,10.199999999999999,{"$f":"0.2*SUM(R67:R101)","v":0},{"$f":"0.2*SUM(S67:S101)","v":3.6},4.4000000000000004,8,{"$f":"0.2*SUM(V67:V101)","v":0},{"$f":"0.2*SUM(W67:W101)","v":3.6},4,7.6,{"$f":"0.2*SUM(Z67:Z101)","v":1.8},{"$f":"0.2*SUM(AA67:AA101)","v":4},7.8000000000000007,13.600000000000001]
["OPGW Damper, Spiral",null,null,"ea",0.6470588235294118,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["OPGW Splice Enclosure",null,null,"ea",15.270588235294118,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["  ",null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Conductors / OPGW",null,null,null,null,null,null,null,{"$f":"SUM(F205:H205)","v":0},null,null,null,{"$f":"SUM(J205:L205)","v":0},null,null,null,{"$f":"SUM(N205:P205)","v":0},null,null,null,{"$f":"SUM(R205:T205)","v":0},null,null,null,{"$f":"SUM(V205:X205)","v":0},null,null,null,{"$f":"SUM(Z205:AB205)","v":0}]
["  ",null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["4/0 Penguin",null,null,"ft",0.02,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["266.8 kcmil \"Waxwing\"",null,null,"ft",0.02,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["266.8 kcmil \"Partridge\"",null,null,"ft",0.02,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["397.5 kcmil (LINNET)",null,null,"ft",0.02,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["397.5 kcmil \"Ibis\"",null,null,"ft",0.02,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["477 kcmil \"Pelican\"",null,null,"ft",0.02,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["477 kcmil \"Hawk\"",null,null,"ft",0.02,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["795 kcmil (ARBUTUS)",null,null,"ft",2.5999999999999999E-2,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["1033.5 kcmil \"Curlew\"",null,null,"ft",0.03,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["1272 kcmil ACSS/TW",null,null,"ft",0.03,{"$f":"1.02*(SUM(F3,F4,F7)*3)*5280","v":0},{"$f":"1.02*(SUM(G3,G4,G7)*3)*5280","v":49924.511999999995},18418.752,68343.263999999996,{"$f":"1.02*(SUM(J3,J4,J7)*3)*5280","v":42007.680000000008},{"$f":"1.02*(SUM(K3,K4,K7)*3)*5280","v":0},25850.880000000005,67858.560000000012,{"$f":"1.02*(SUM(N3,N4,N7)*3)*5280","v":0},{"$f":"1.02*(SUM(O3,O4,O7)*3)*5280","v":36675.936000000009},21003.840000000004,57679.776000000013,{"$f":"1.02*(SUM(R3,R4,R7)*3)*5280","v":0},{"$f":"1.02*(SUM(S3,S4,S7)*3)*5280","v":33121.439999999995},41038.272000000004,74159.712,{"$f":"1.02*(SUM(V3,V4,V7)*3)*5280","v":0},{"$f":"1.02*(SUM(W3,W4,W7)*3)*5280","v":33121.439999999995},37483.775999999991,70605.215999999986,{"$f":"1.02*(SUM(Z3,Z4,Z7)*3)*5280","v":16156.800000000001},{"$f":"1.02*(SUM(AA3,AA4,AA7)*3)*5280","v":37483.775999999991},74321.279999999999,127961.856]
["1590 kcmil \"Hornbill\"",null,null,"ft",0.03,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["1590 kcmil \"Falcon\"",null,null,"ft",0.03,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["1622 kcmil \"PECOS\"",null,{"$f":"1.02*(12.8*3)*5280","v":206807.04000000004},"ft",0.03,{"$f":"1.02*(SUM(F5:F7)*3)*5280","v":42007.680000000008},{"$f":"1.02*(SUM(G5:G7)*3)*5280","v":0},24235.200000000001,66242.880000000005,{"$f":"1.02*(SUM(J5:J7)*3)*5280","v":42007.680000000008},{"$f":"1.02*(SUM(K5:K7)*3)*5280","v":0},25850.880000000005,67858.560000000012,{"$f":"1.02*(SUM(N5:N7)*3)*5280","v":42007.680000000008},{"$f":"1.02*(SUM(O5:O7)*3)*5280","v":0},10501.920000000002,52509.600000000006,{"$f":"1.02*(SUM(R5:R7)*3)*5280","v":0},{"$f":"1.02*(SUM(S5:S7)*3)*5280","v":33121.439999999995},41038.272000000004,74159.712,{"$f":"1.02*(SUM(V5:V7)*3)*5280","v":0},{"$f":"1.02*(SUM(W5:W7)*3)*5280","v":33121.439999999995},37483.775999999991,70605.215999999986,{"$f":"1.02*(SUM(Z5:Z7)*3)*5280","v":16156.800000000001},{"$f":"1.02*(SUM(AA5:AA7)*3)*5280","v":37483.775999999991},74321.279999999999,127961.856]
["2627 kcmil ACSS/TW/HS \"Santee\"",null,null,"ft",0.03,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Pull Ropes",null,{"$f":"C225*3","v":27},"ea",10,{"$f":"F225*3","v":6},{"$f":"G225*3","v":9},6,21,{"$f":"J225*3","v":12},{"$f":"K225*3","v":0},9,21,{"$f":"N225*3","v":6},{"$f":"O225*3","v":6},6,18,{"$f":"R225*3","v":0},{"$f":"S225*3","v":9},12,21,{"$f":"V225*3","v":0},{"$f":"W225*3","v":9},12,21,{"$f":"Z225*3","v":6},{"$f":"AA225*3","v":12},21,39]
["Pull Back Ropes",null,0,"ea",10,0,1,2,3,0,1,2,3,0,1,2,3,0,1,2,3,0,1,2,3,0,1,2,3]
["Pull Hardlines",null,{"$f":"C225*3","v":27},"ea",5,{"$f":"F225*3","v":6},{"$f":"G225*3","v":9},6,21,{"$f":"J225*3","v":12},{"$f":"K225*3","v":0},9,21,{"$f":"N225*3","v":6},{"$f":"O225*3","v":6},6,18,{"$f":"R225*3","v":0},{"$f":"S225*3","v":9},12,21,{"$f":"V225*3","v":0},{"$f":"W225*3","v":9},12,21,{"$f":"Z225*3","v":6},{"$f":"AA225*3","v":12},21,39]
["Sag Conductor",null,{"$f":"C225*3","v":27},"ea",5,{"$f":"F225*3","v":6},{"$f":"G225*3","v":9},6,21,{"$f":"J225*3","v":12},{"$f":"K225*3","v":0},{"$f":"L225*3","v":9},21,{"$f":"N225*3","v":6},{"$f":"O225*3","v":6},{"$f":"P225*3","v":6},18,{"$f":"R225*3","v":0},{"$f":"S225*3","v":9},{"$f":"T225*3","v":12},21,{"$f":"V225*3","v":0},{"$f":"W225*3","v":9},{"$f":"X225*3","v":12},21,{"$f":"Z225*3","v":6},{"$f":"AA225*3","v":12},{"$f":"AB225*3","v":21},39]
["Wire Set Up",null,{"$f":"ROUNDUP((12.8)*5280/8000,0)","v":9},"ea",50,{"$f":"ROUNDUP(SUM(F207:F219)/3/8000,0)","v":2},{"$f":"ROUNDUP(SUM(G207:G219)/3/8000,0)","v":3},2,7,{"$f":"ROUNDUP(SUM(J207:J219)/3/8000,0)","v":4},{"$f":"ROUNDUP(SUM(K207:K219)/3/8000,0)","v":0},3,7,{"$f":"ROUNDUP(SUM(N207:N219)/3/8000,0)","v":2},{"$f":"ROUNDUP(SUM(O207:O219)/3/8000,0)","v":2},2,6,{"$f":"ROUNDUP(SUM(R207:R219)/3/8000,0)","v":0},{"$f":"ROUNDUP(SUM(S207:S219)/3/8000,0)","v":3},4,7,{"$f":"ROUNDUP(SUM(V207:V219)/3/8000,0)","v":0},{"$f":"ROUNDUP(SUM(W207:W219)/3/8000,0)","v":3},4,7,{"$f":"ROUNDUP(SUM(Z207:Z219)/3/8000,0)","v":2},{"$f":"ROUNDUP(SUM(AA207:AA219)/3/8000,0)","v":4},7,13]
["OPGW Type A",null,null,"ft",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["ADSS ",null,null,"ft",0.02,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["OPGW 48 Strand",null,{"$f":"1.02*12.8*5280","v":68935.680000000008},"ft",0.02,{"$f":"SUM(F207:F220)/3","v":14002.560000000003},{"$f":"SUM(G207:G220)/3","v":16641.503999999997},14217.984000000002,44862.048000000003,{"$f":"SUM(J207:J220)/3","v":28005.120000000006},{"$f":"SUM(K207:K220)/3","v":0},17233.920000000002,45239.040000000008,{"$f":"SUM(N207:N220)/3","v":14002.560000000003},{"$f":"SUM(O207:O220)/3","v":12225.312000000004},10501.920000000002,36729.792000000009,{"$f":"SUM(R207:R220)/3","v":0},{"$f":"SUM(S207:S220)/3","v":22080.959999999995},27358.848000000002,49439.807999999997,{"$f":"SUM(V207:V220)/3","v":0},{"$f":"SUM(W207:W220)/3","v":22080.959999999995},24989.183999999994,47070.143999999986,{"$f":"SUM(Z207:Z220)/3","v":10771.2},{"$f":"SUM(AA207:AA220)/3","v":24989.183999999994},49547.519999999997,85307.90399999998]
["OPGW 96 Strand",null,null,"ft",3.5000000000000003E-2,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["5/16\" Overhead Shield Wire",null,null,"ft",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["3/8\" Overhead Shield Wire",null,0,"ft",0.02,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["1/2\" Overhead Shield Wire",null,null,"ft",0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["OHGW/OPGW Wire Set Up",null,{"$f":"ROUNDUP((12.8)*5280/10000,0)","v":7},"ea",36,{"$f":"ROUNDUP(F228/10000,0)","v":2},{"$f":"ROUNDUP(G228/10000,0)","v":2},2,6,{"$f":"ROUNDUP(J228/10000,0)","v":3},{"$f":"ROUNDUP(K228/10000,0)","v":0},2,5,{"$f":"ROUNDUP(N228/10000,0)","v":2},{"$f":"ROUNDUP(O228/10000,0)","v":2},2,6,{"$f":"ROUNDUP(R228/10000,0)","v":0},{"$f":"ROUNDUP(S228/10000,0)","v":3},3,6,{"$f":"ROUNDUP(V228/10000,0)","v":0},{"$f":"ROUNDUP(W228/10000,0)","v":3},3,6,{"$f":"ROUNDUP(Z228/10000,0)","v":2},{"$f":"ROUNDUP(AA228/10000,0)","v":3},5,10]
["Pull OHGW/OPGW",null,{"$f":"C233","v":7},"ea",30,{"$f":"F233","v":2},{"$f":"G233","v":2},2,6,{"$f":"J233","v":3},{"$f":"K233","v":0},{"$f":"L233","v":2},5,{"$f":"N233","v":2},{"$f":"O233","v":2},{"$f":"P233","v":2},6,{"$f":"R233","v":0},{"$f":"S233","v":3},{"$f":"T233","v":3},6,{"$f":"V233","v":0},{"$f":"W233","v":3},{"$f":"X233","v":3},6,{"$f":"Z233","v":2},{"$f":"AA233","v":3},{"$f":"AB233","v":5},10]
["Sag OHGW/OPGW",null,{"$f":"C234","v":7},"ea",5,{"$f":"F234","v":2},2,2,6,{"$f":"J234","v":3},0,2,5,{"$f":"N234","v":2},2,2,6,{"$f":"R234","v":0},3,3,6,{"$f":"V234","v":0},3,3,6,{"$f":"Z234","v":2},3,5,10]
["Clipping Conductor",null,{"$f":"C224","v":27},"ea",8,{"$f":"SUM(F84:F101)","v":21},{"$f":"SUM(G84:G101)","v":16},23,60,{"$f":"SUM(J84:J101)","v":22},{"$f":"SUM(K84:K101)","v":0},14,36,{"$f":"SUM(N84:N101)","v":21},{"$f":"SUM(O84:O101)","v":19},11,51,{"$f":"SUM(R84:R101)","v":0},{"$f":"SUM(S84:S101)","v":18},22,40,{"$f":"SUM(V84:V101)","v":0},{"$f":"SUM(W84:W101)","v":18},20,38,{"$f":"SUM(Z84:Z101)","v":9},{"$f":"SUM(AA84:AA101)","v":20},39,68]
["Clipping OHGW/OPGW",null,{"$f":"C234","v":7},"ea",4,{"$f":"F236","v":21},{"$f":"G236","v":16},23,60,{"$f":"J236","v":22},{"$f":"K236","v":0},{"$f":"L236","v":14},36,{"$f":"N236","v":21},{"$f":"O236","v":19},{"$f":"P236","v":11},51,{"$f":"R236","v":0},{"$f":"S236","v":18},{"$f":"T236","v":22},40,{"$f":"V236","v":0},{"$f":"W236","v":18},{"$f":"X236","v":20},38,{"$f":"Z236","v":9},{"$f":"AA236","v":20},{"$f":"AB236","v":39},68]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Road Crossing",null,38,"ea",40,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["HWY Crossing",null,3,"ea",60,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Rail Crossing",null,0,"ea",120,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Water Crossing",null,1,"ea",120,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Arial Marker Balls",null,null,"ea",16,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Relocate all transmission lines to new termination structures",null,null,"ea",32,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Fiber Optic Splice",null,{"$f":"C249*48","v":336},"ea",0.5,{"$f":"F234*48","v":96},{"$f":"G234*48","v":96},96,288,{"$f":"J234*48","v":144},{"$f":"K234*48","v":0},96,240,{"$f":"N234*48","v":96},{"$f":"O234*48","v":96},96,288,{"$f":"R234*48","v":0},{"$f":"S234*48","v":144},144,288,{"$f":"V234*48","v":0},{"$f":"W234*48","v":144},144,288,{"$f":"Z234*48","v":96},{"$f":"AA234*48","v":144},240,480]
["Fiber Optic Splice Box",null,{"$f":"C233","v":7},"ea",6,{"$f":"F248/48","v":2},{"$f":"G248/48","v":2},2,6,{"$f":"J248/48","v":3},{"$f":"K248/48","v":0},{"$f":"L248/48","v":2},5,{"$f":"N248/48","v":2},{"$f":"O248/48","v":2},{"$f":"P248/48","v":2},6,{"$f":"R248/48","v":0},{"$f":"S248/48","v":3},{"$f":"T248/48","v":3},6,{"$f":"V248/48","v":0},{"$f":"W248/48","v":3},{"$f":"X248/48","v":3},6,{"$f":"Z248/48","v":2},{"$f":"AA248/48","v":3},{"$f":"AB248/48","v":5},10]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null," ",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Interruptions",null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null," ",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Interference",null,null,"ea",80,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Mob",null,null,"ea",60,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["De-Mob",null,null,"ea",60,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["45% premium for hot crew",null,null,"ls",500,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Some night work needs to be done",null,4,"ls",200,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Public Outreach",null,4,"ls",80,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null," ",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Underbuild",null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null," ",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Distribution Works"," ",null,"ls",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null," ",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Removal",null,null," ",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null," ",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Conductor Removal",null,{"$f":"1.02*(0*3)*5280","v":0},"ft",0.03,null,null,null,{"$f":"SUM(F269:H269)","v":0},null,null,null,{"$f":"SUM(J269:L269)","v":0},null,null,null,{"$f":"SUM(N269:P269)","v":0},null,null,null,{"$f":"SUM(R269:T269)","v":0},null,null,null,{"$f":"SUM(V269:X269)","v":0},null,null,null,{"$f":"SUM(Z269:AB269)","v":0}]
["Shield Wire Removal",null,{"$f":"1.02*(0)*5280","v":0},"ft",0.03,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Wood Pole Removal",null,0,"ea",12,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Insulator",null,{"$f":"C271*3","v":0},"ea",2,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Remove direct buried steel pole",null,null,"ea",16,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Demo concrete foundation",null,null,"cy",8,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Remove direct buried concrete pole",null,null,"ea",16,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Goab Switch Removal",null,null,"ea",24,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Existing Conductor",null,null,"ft",0.03,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null," ",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Material Freight",null,null," ",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null," ",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Material Freight (4%)",null,0.04,"Percent",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null," ",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Design Allowance",null,null,null,".",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"Total Direct Cost (TDC)",null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null," ",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Easements",null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null," ",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Rural Easements - New","100ft ROW",3,"Acre",15,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Urban Easements - New","50ft Private-50ft Public",1.75,"Acre",15,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Rural Easements - Existing but Needs Supplemental",null,4.5,"Acre",15,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Urban Easements - Existing but Needs Supplemental",null,3.5,"Acre",15,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Rural Severance Damage Parcels",null,null,"Acre",15,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Urban Severance Damage Parcels",null,null,"Acre",15,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]