{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["LABOR","MATERIALS","EQUIPMENT","Lost Gas Calculator","OUTSIDE SERVICES","BILLING SUMMARY","Workcenter Dropdown List","Lost Gas Calculation","Data Sheet"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":19,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"LABOR","index":0,"n_rows":59,"n_cols":23,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,1,2,22]]}
[]
[null,"LABOR CALCULATION"]
[]
[null,null,null,null,null,null,null,null,null,null,"NORMAL",null,null,null,"CALL OUT",null,"CALL OUT"]
[null,null,null,null,null,null,"BENEFITS RATE2",null,"TOTAL ",null,"HOURS ",null,"OT HRS",null,"DURING WEEK",null,"WEEKEND",null,"TOTAL","STATE OH5","BU OH6","SSU OH7","TOTAL"]
[null,"POSITION TITLE","FY19 PAY RANGE1",null,"HOURLY RATE",null,{"$f":"0.2874+0.0189+0.08","v":0.38630000000000003},null,"RATE",null,"WORKED",null,"WORKED",null,"HOURS3",null,"HOURS4",null,"HRS WORKED",7.6200000000000004E-2,9.8599999999999993E-2,4.8399999999999999E-2,"LABOR"]
[null,"ADMINISTRATION FEE8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98.3]
[]
[1,"CONSTRUCTION OPERATOR 1",38300,null,{"$f":"ROUND(C9/2080, 2)","v":18.41},null,{"$f":"ROUND(E9*$G$6, 2)","v":7.11},null,{"$f":"E9+G9","v":25.52},null,0,null,0,null,0,null,0,null,{"$f":"ROUND(I9*K9, 2) + ROUND(M9*(I9*1.5), 2) + ROUND(O9*(I9*1.5), 2) + ROUND(Q9*(I9*1.5), 2)","v":0},{"$f":"ROUND(S9*$T$6, 2)","v":0},{"$f":"ROUND(S9*$U$6, 2)","v":0},{"$f":"ROUND(S9*$V$6, 2)","v":0},{"$f":"SUM(S9:V9)","v":0}]
[]
[2,"CONSTRUCTION OPERATOR 2",47500,null,{"$f":"ROUND(C11/2080, 2)","v":22.84},null,{"$f":"ROUND(E11*$G$6, 2)","v":8.82},null,{"$f":"E11+G11","v":31.66},null,0,null,0,null,0,null,0,null,{"$f":"ROUND(I11*K11, 2) + ROUND(M11*(I11*1.5), 2) + ROUND(O11*(I11*1.5), 2) + ROUND(Q11*(I11*1.5), 2)","v":0},{"$f":"ROUND(S11*$T$6, 2)","v":0},{"$f":"ROUND(S11*$U$6, 2)","v":0},{"$f":"ROUND(S11*$V$6, 2)","v":0},{"$f":"SUM(S11:V11)","v":0}]
[]
[3,"SR. CONSTRUCTION OPERATOR",59200,null,{"$f":"ROUND(C13/2080, 2)","v":28.46},null,{"$f":"ROUND(E13*$G$6, 2)","v":10.99},null,{"$f":"E13+G13","v":39.450000000000003},null,0,null,0,null,0,null,0,null,{"$f":"ROUND(I13*K13, 2) + ROUND(M13*(I13*1.5), 2) + ROUND(O13*(I13*1.5), 2) + ROUND(Q13*(I13*1.5), 2)","v":0},0,0,0,0]
[]
[1,"SERVICE TECHNICIAN 1",38300,null,{"$f":"ROUND(C15/2080, 2)","v":18.41},null,{"$f":"ROUND(E15*$G$6, 2)","v":7.11},null,{"$f":"E15+G15","v":25.52},null,0,null,0,null,0,null,0,null,{"$f":"ROUND(I15*K15, 2) + ROUND(M15*(I15*1.5), 2) + ROUND(O15*(I15*1.5), 2) + ROUND(Q15*(I15*1.5), 2)","v":0},0,0,0,0]
[]
[2,"SERVICE TECHNICIAN 2",47500,null,{"$f":"ROUND(C17/2080, 2)","v":22.84},null,{"$f":"ROUND(E17*$G$6, 2)","v":8.82},null,{"$f":"E17+G17","v":31.66},null,0,null,0,null,0,null,0,null,{"$f":"ROUND(I17*K17, 2) + ROUND(M17*(I17*1.5), 2) + ROUND(O17*(I17*1.5), 2) + ROUND(Q17*(I17*1.5), 2)","v":0},{"$f":"ROUND(S17*$T$6, 2)","v":0},{"$f":"ROUND(S17*$U$6, 2)","v":0},{"$f":"ROUND(S17*$V$6, 2)","v":0},{"$f":"SUM(S17:V17)","v":0}]
[]
[3,"SR. SERVICE TECHNICIAN",59200,null,28.46,null,{"$f":"ROUND(E19*$G$6, 2)","v":10.99},null,{"$f":"E19+G19","v":39.450000000000003},null,0,null,0,null,0,null,0,null,{"$f":"ROUND(I19*K19, 2) + ROUND(M19*(I19*1.5), 2) + ROUND(O19*(I19*1.5), 2) + ROUND(Q19*(I19*1.5), 2)","v":0},0,0,0,0]
[]
[2,"OPERATIONS ASSISTANT",47500,null,22.84,null,{"$f":"ROUND(E21*$G$6, 2)","v":8.82},null,{"$f":"E21+G21","v":31.66},null,0,null,0,null,0,null,0,null,{"$f":"ROUND(I21*K21, 2) + ROUND(M21*(I21*1.5), 2) + ROUND(O21*(I21*1.5), 2) + ROUND(Q21*(I21*1.5), 2)","v":0},0,0,0,0]
[]
[4,"PROJECT SPECIALIST",73100,null,35.14,null,{"$f":"ROUND(E23*$G$6, 2)","v":13.57},null,{"$f":"E23+G23","v":48.71},null,0,null,0,null,0,null,0,null,{"$f":"ROUND(I23*K23, 2) + ROUND(M23*(I23*1.5), 2) + ROUND(O23*(I23*1.5), 2) + ROUND(Q23*(I23*1.5), 2)","v":0},{"$f":"ROUND(S23*$T$6, 2)","v":0},{"$f":"ROUND(S23*$U$6, 2)","v":0},{"$f":"ROUND(S23*$V$6, 2)","v":0},{"$f":"SUM(S23:V23)","v":0}]
[]
[5,"SR. PROJECT SPECIALIST",91700,null,44.09,null,{"$f":"ROUND(E25*$G$6, 2)","v":17.03},null,{"$f":"E25+G25","v":61.120000000000005},null,0,null,0,null,0,null,0,null,{"$f":"ROUND(I25*K25, 2) + ROUND(M25*(I25*1.5), 2) + ROUND(O25*(I25*1.5), 2) + ROUND(Q25*(I25*1.5), 2)","v":0},0,0,0,0]
[]
[4,"ENGINEER 1",73100,null,{"$f":"ROUND(C27/2080, 2)","v":35.14},null,{"$f":"ROUND(E27*$G$6, 2)","v":13.57},null,{"$f":"E27+G27","v":48.71},null,0,null,0,null,0,null,0,null,{"$f":"ROUND(I27*K27, 2) + ROUND(M27*(I27*1.5), 2) + ROUND(O27*(I27*1.5), 2) + ROUND(Q27*(I27*1.5), 2)","v":0},{"$f":"ROUND(S27*$T$6, 2)","v":0},{"$f":"ROUND(S27*$U$6, 2)","v":0},{"$f":"ROUND(S27*$V$6, 2)","v":0},{"$f":"SUM(S27:V27)","v":0}]
[]
[4,"ENGINEER 2",73100,null,{"$f":"ROUND(C29/2080, 2)","v":35.14},null,{"$f":"ROUND(E29*$G$6, 2)","v":13.57},null,{"$f":"E29+G29","v":48.71},null,0,null,0,null,0,null,0,null,{"$f":"ROUND(I29*K29, 2) + ROUND(M29*(I29*1.5), 2) + ROUND(O29*(I29*1.5), 2) + ROUND(Q29*(I29*1.5), 2)","v":0},{"$f":"ROUND(S29*$T$6, 2)","v":0},{"$f":"ROUND(S29*$U$6, 2)","v":0},{"$f":"ROUND(S29*$V$6, 2)","v":0},{"$f":"SUM(S29:V29)","v":0}]
[]
[5,"ENGINEER 3",91700,null,44.09,null,{"$f":"ROUND(E31*$G$6, 2)","v":17.03},null,{"$f":"E31+G31","v":61.120000000000005},null,0,null,0,null,0,null,0,null,{"$f":"ROUND(I31*K31, 2) + ROUND(M31*(I31*1.5), 2) + ROUND(O31*(I31*1.5), 2) + ROUND(Q31*(I31*1.5), 2)","v":0},0,0,0,0]
[]
[6,"SR. ENGINEER",114900,null,55.24,null,{"$f":"ROUND(E33*$G$6, 2)","v":21.34},null,{"$f":"E33+G33","v":76.58},null,0,null,0,null,0,null,0,null,{"$f":"ROUND(I33*K33, 2) + ROUND(M33*(I33*1.5), 2) + ROUND(O33*(I33*1.5), 2) + ROUND(Q33*(I33*1.5), 2)","v":0},0,0,0,0]
[]
[1,"METER READER 1 & 2",38300,null,18.41,null,{"$f":"ROUND(E35*$G$6, 2)","v":7.11},null,{"$f":"E35+G35","v":25.52},null,0,null,0,null,0,null,0,null,{"$f":"ROUND(I35*K35, 2) + ROUND(M35*(I35*1.5), 2) + ROUND(O35*(I35*1.5), 2) + ROUND(Q35*(I35*1.5), 2)","v":0},0,0,0,0]
[]
[3,"WELDER 1",59200,null,28.46,null,{"$f":"ROUND(E37*$G$6, 2)","v":10.99},null,{"$f":"E37+G37","v":39.450000000000003},null,0,null,0,null,0,null,0,null,{"$f":"ROUND(I37*K37, 2) + ROUND(M37*(I37*1.5), 2) + ROUND(O37*(I37*1.5), 2) + ROUND(Q37*(I37*1.5), 2)","v":0},0,0,0,0]
[]
[4,"WELDER 2",73100,null,{"$f":"ROUND(C39/2080, 2)","v":35.14},null,{"$f":"ROUND(E39*$G$6, 2)","v":13.57},null,{"$f":"E39+G39","v":48.71},null,0,null,0,null,0,null,0,null,{"$f":"ROUND(I39*K39, 2) + ROUND(M39*(I39*1.5), 2) + ROUND(O39*(I39*1.5), 2) + ROUND(Q39*(I39*1.5), 2)","v":0},{"$f":"ROUND(S39*$T$6, 2)","v":0},{"$f":"ROUND(S39*$U$6, 2)","v":0},{"$f":"ROUND(S39*$V$6, 2)","v":0},{"$f":"SUM(S39:V39)","v":0}]
[]
[4,"CREW LEADER",73100,null,35.14,null,{"$f":"ROUND(E41*$G$6, 2)","v":13.57},null,{"$f":"E41+G41","v":48.71},null,0,null,0,null,0,null,0,null,{"$f":"ROUND(I41*K41, 2) + ROUND(M41*(I41*1.5), 2) + ROUND(O41*(I41*1.5), 2) + ROUND(Q41*(I41*1.5), 2)","v":0},0,0,0,0]
[]
[4,"TOWN OPERATOR",73100,null,{"$f":"ROUND(C43/2080, 2)","v":35.14},null,{"$f":"ROUND(E43*$G$6, 2)","v":13.57},null,{"$f":"E43+G43","v":48.71},null,0,null,0,null,0,null,0,null,{"$f":"ROUND(I43*K43, 2) + ROUND(M43*(I43*1.5), 2) + ROUND(O43*(I43*1.5), 2) + ROUND(Q43*(I43*1.5), 2)","v":0},{"$f":"ROUND(S43*$T$6, 2)","v":0},{"$f":"ROUND(S43*$U$6, 2)","v":0},{"$f":"ROUND(S43*$V$6, 2)","v":0},{"$f":"SUM(S43:V43)","v":0}]
[]
[4,"DISTRIBUTION OPERATOR",73100,null,35.14,null,{"$f":"ROUND(E45*$G$6, 2)","v":13.57},null,{"$f":"E45+G45","v":48.71},null,0,null,0,null,0,null,0,null,{"$f":"ROUND(I45*K45, 2) + ROUND(M45*(I45*1.5), 2) + ROUND(O45*(I45*1.5), 2) + ROUND(Q45*(I45*1.5), 2)","v":0},0,0,0,0]
[]
[5,"OPERATIONS SUPERVISOR",91700,null,44.09,null,{"$f":"ROUND(E47*$G$6, 2)","v":17.03},null,{"$f":"E47+G47","v":61.120000000000005},null,0,null,0,null,0,null,0,null,{"$f":"ROUND(I47*K47, 2) + ROUND(M47*(I47*1.5), 2) + ROUND(O47*(I47*1.5), 2) + ROUND(Q47*(I47*1.5), 2)","v":0},0,0,0,0]
[null,"TOTAL",null,null,null,null,null,null,null,null,{"$f":"SUM(K11:K47)","v":0},null,{"$f":"SUM(M11:M47)","v":0},null,{"$f":"SUM(O11:O47)","v":0},null,{"$f":"SUM(Q11:Q47)","v":0},null,null,null,null,null,{"$f":"SUM(W7:W47)","v":98.3}]
[]
[null,"NOTES:"]
[null,"1Pay range information is taken from the corporate broad pay grades (Target Pay Mid Point) available on Atmosphere.  "]
[null,"2Benefits rate percentage will update each October.  See Josh Densman for annual update."]
[null,"3Minmum of 2 hours are to be used for call out during the week after normal business hours"]
[null,"4Minmum of 3 hours are to be used for call out during the weekend"]
[null,"5State overhead rate will update each October.  See Josh Densman for annual update.  Also, state overhead rate is different for each KMD jurisdiction."]
[null,"6Business unit overhead rate will update each October.  See Josh Densman for annual update."]
[null,"7Shared services overhead rate will update each October.  See Josh Densman for annual update."]
[null,"8Administration fee consists of one hour of time for the Operations Assistant and Project Specialist role. Fee is state specific. See Josh Densman for update."]
[null,"Cells containing bolded blue text or number may be updated by user depending on the need and situation."]

{"sheet":"MATERIALS","index":1,"n_rows":136,"n_cols":15,"rows_kept":136,"cut":false,"hidden":false,"merged":[[0,0,0,14],[1,0,1,1],[1,3,1,6],[1,7,1,8],[2,0,2,1],[2,3,2,6],[2,7,2,8],[5,0,5,1],[5,3,5,6],[5,7,5,8],[6,0,6,1],[6,3,6,6],[6,7,6,8],[3,0,3,1],[3,3,3,6],[3,7,3,8],[4,0,4,1],[4,3,4,6],[4,7,4,8],[9,0,9,1],[9,3,9,6],[9,7,9,8],[10,0,10,1],[10,3,10,6],[10,7,10,8],[7,0,7,1],[7,3,7,6],[7,7,7,8],[8,0,8,1],[8,3,8,6],[8,7,8,8],[13,0,13,1],[13,3,13,6],[13,7,13,8],[14,0,14,1],[14,3,14,6],[14,7,14,8],[11,0,11,1],[11,3,11,6],[11,7,11,8],[12,0,12,1],[12,3,12,6],[12,7,12,8],[17,0,17,1],[17,3,17,6],[17,7,17,8],[18,0,18,1],[18,3,18,6],[18,7,18,8],[15,0,15,1],[15,3,15,6],[15,7,15,8],[16,0,16,1],[16,3,16,6],[16,7,16,8],[21,0,21,1],[21,3,21,6],[21,7,21,8],[22,0,22,1],[22,3,22,6],[22,7,22,8],[19,0,19,1],[19,3,19,6],[19,7,19,8],[20,0,20,1],[20,3,20,6],[20,7,20,8],[25,0,25,1],[25,3,25,6],[25,7,25,8],[26,0,26,1],[26,3,26,6],[26,7,26,8],[23,0,23,1],[23,3,23,6],[23,7,23,8],[24,0,24,1],[24,3,24,6],[24,7,24,8],[29,0,29,1],[29,3,29,6],[29,7,29,8],[30,0,30,1],[30,3,30,6],[30,7,30,8],[27,0,27,1],[27,3,27,6],[27,7,27,8],[28,0,28,1],[28,3,28,6],[28,7,28,8],[33,0,33,1],[33,3,33,6],[33,7,33,8],[34,0,34,1],[34,3,34,6],[34,7,34,8],[31,0,31,1],[31,3,31,6],[31,7,31,8],[32,0,32,1],[32,3,32,6],[32,7,32,8],[37,0,37,1],[37,3,37,6],[37,7,37,8],[38,0,38,1],[38,3,38,6],[38,7,38,8],[35,0,35,1],[35,3,35,6],[35,7,35,8],[36,0,36,1],[36,3,36,6],[36,7,36,8],[41,0,41,1],[41,3,41,6],[41,7,41,8],[42,0,42,1],[42,3,42,6],[42,7,42,8],[39,0,39,1],[39,3,39,6],[39,7,39,8],[40,0,40,1],[40,3,40,6],[40,7,40,8],[45,0,45,1],[45,3,45,6],[45,7,45,8],[46,0,46,1],[46,3,46,6],[46,7,46,8],[43,0,43,1],[43,3,43,6],[43,7,43,8],[44,0,44,1],[44,3,44,6],[44,7,44,8],[49,0,49,1],[49,3,49,6],[49,7,49,8],[50,0,50,1],[50,3,50,6],[50,7,50,8],[47,0,47,1],[47,3,47,6],[47,7,47,8],[48,0,48,1],[48,3,48,6],[48,7,48,8],[53,0,53,1],[53,3,53,6],[53,7,53,8],[54,0,54,1],[54,3,54,6],[54,7,54,8],[51,0,51,1],[51,3,51,6],[51,7,51,8],[52,0,52,1],[52,3,52,6],[52,7,52,8],[57,0,57,1],[57,3,57,6],[57,7,57,8],[58,0,58,1],[58,3,58,6],[58,7,58,8],[55,0,55,1],[55,3,55,6],[55,7,55,8],[56,0,56,1],[56,3,56,6],[56,7,56,8],[61,0,61,1],[61,3,61,6],[61,7,61,8],[62,0,62,1],[62,3,62,6],[62,7,62,8],[59,0,59,1],[59,3,59,6],[59,7,59,8],[60,0,60,1],[60,3,60,6],[60,7,60,8],[65,0,65,1],[65,3,65,6],[65,7,65,8],[66,0,66,1],[66,3,66,6],[66,7,66,8],[63,0,63,1],[63,3,63,6],[63,7,63,8],[64,0,64,1],[64,3,64,6],[64,7,64,8],[69,0,69,1],[69,3,69,6],[69,7,69,8],[70,0,70,1],[70,3,70,6],[70,7,70,8],[67,0,67,1],[67,3,67,6],[67,7,67,8],[68,0,68,1],[68,3,68,6],[68,7,68,8],[73,0,73,1],[73,3,73,6],[73,7,73,8],[74,0,74,1],[74,3,74,6],[74,7,74,8],[71,0,71,1],[71,3,71,6],[71,7,71,8],[72,0,72,1],[72,3,72,6],[72,7,72,8],[77,0,77,1],[77,7,77,8],[78,0,78,1],[78,3,78,6],[78,7,78,8],[79,0,79,1],[79,3,79,6],[79,7,79,8],[75,0,75,1],[75,3,75,6],[75,7,75,8],[76,0,76,1],[76,3,76,6],[76,7,76,8],[82,0,82,1],[82,3,82,6],[82,7,82,8],[83,0,83,1],[83,3,83,6],[83,7,83,8],[80,0,80,1],[80,3,80,6],[80,7,80,8],[81,0,81,1],[81,3,81,6],[81,7,81,8],[86,0,86,1],[86,3,86,6],[86,7,86,8],[87,0,87,1],[87,3,87,6],[87,7,87,8],[84,0,84,1],[84,3,84,6],[84,7,84,8],[85,0,85,1],[85,3,85,6],[85,7,85,8],[90,0,90,1],[90,3,90,6],[90,7,90,8],[91,0,91,1],[91,3,91,6],[91,7,91,8],[88,0,88,1],[88,3,88,6],[88,7,88,8],[89,0,89,1],[89,3,89,6],[89,7,89,8],[94,0,94,1],[94,3,94,6],[94,7,94,8],[95,0,95,1],[95,3,95,6],[95,7,95,8],[92,0,92,1],[92,3,92,6],[92,7,92,8],[93,0,93,1],[93,3,93,6],[93,7,93,8],[98,0,98,1],[98,3,98,6],[98,7,98,8],[99,0,99,1],[99,3,99,6],[99,7,99,8],[96,0,96,1],[96,3,96,6],[96,7,96,8],[97,0,97,1],[97,3,97,6],[97,7,97,8],[102,0,102,1],[102,3,102,6],[102,7,102,8],[103,0,103,1],[103,3,103,6],[103,7,103,8],[100,0,100,1],[100,3,100,6],[100,7,100,8],[101,0,101,1],[101,3,101,6],[101,7,101,8],[106,0,106,1],[106,3,106,6],[106,7,106,8],[107,0,107,1],[107,3,107,6],[107,7,107,8],[104,0,104,1],[104,3,104,6],[104,7,104,8],[105,0,105,1],[105,3,105,6],[105,7,105,8],[113,0,113,1],[113,3,113,6],[113,7,113,8],[114,0,114,1],[114,3,114,6],[114,7,114,8],[108,0,108,1],[108,3,108,6],[108,7,108,8],[109,0,109,1],[109,3,109,13],[112,0,112,14],[117,0,117,1],[117,3,117,6],[117,7,117,8],[118,0,118,1],[118,3,118,6],[118,7,118,8],[115,0,115,1],[115,3,115,6],[115,7,115,8],[116,0,116,1],[116,3,116,6],[116,7,116,8],[121,0,121,1],[121,3,121,6],[121,7,121,8],[122,0,122,1],[122,3,122,6],[122,7,122,8],[119,0,119,1],[119,3,119,6],[119,7,119,8],[120,0,120,1],[120,3,120,6],[120,7,120,8],[127,0,127,13],[125,0,125,1],[125,3,125,6],[125,7,125,8],[126,0,126,1],[126,3,126,6],[126,7,126,8],[123,0,123,1],[123,3,123,6],[123,7,123,8],[124,0,124,1],[124,3,124,6],[124,7,124,8]]}
["WAREHOUSE MATERIALS"]
[null,null,null,null,null,null,null,null,null,null,"Stores OH2","State OH3","BU OH4","Corp.OH5"]
["Quantity",null,"UOM","Description",null,null,null,"Unit Cost1",null,"Total w/o OH",0.1,{"$f":"LABOR!T6","v":7.6200000000000004E-2},{"$f":"LABOR!U6","v":9.8599999999999993E-2},{"$f":"LABOR!V6","v":4.8399999999999999E-2}]
[0,null,"Feet","1/2\" PE Pipe",null,null,null,0.14000000000000001,null,{"$f":"ROUND(A4*H4,2)","v":0},{"$f":"ROUND(J4*K3, 2)","v":0},{"$f":"ROUND(J4*L3, 2)","v":0},{"$f":"ROUND(J4*M3, 2)","v":0},{"$f":"ROUND(J4*N3, 2)","v":0},{"$f":"J4+K4+L4+M4+N4","v":0}]
[0,null,"Feet","3/4\" PE Pipe",null,null,null,0.25,null,0,{"$f":"ROUND(J5*$K$3, 2)","v":0},{"$f":"ROUND(J5*$L$3, 2)","v":0},{"$f":"ROUND(J5*$M$3, 2)","v":0},{"$f":"ROUND(J5*$N$3, 2)","v":0},0]
[0,null,"Feet","1-1/4\" PE Pipe",null,null,null,0.57999999999999996,null,{"$f":"ROUND(A6*H6,2)","v":0},0,0,0,{"$f":"ROUND(J6*$N$3, 2)","v":0},0]
[0,null,"Feet","2\" PE Pipe",null,null,null,1.1599999999999999,null,0,0,0,0,0,0]
[0,null,"Feet","3\" PE Pipe",null,null,null,1.98,null,0,0,0,0,0,0]
[0,null,"Feet","4\" PE Pipe",null,null,null,3.27,null,0,0,0,0,0,0]
[0,null,"Feet","6\" PE Pipe",null,null,null,7.07,null,0,0,0,0,0,0]
[0,null,"Each","1-1/4\" Poly Valve",null,null,null,29.57,null,0,0,0,0,0,0]
[0,null,"Each","2\" Poly Valve",null,null,null,63.55,null,0,0,0,0,0,0]
[0,null,"Each","3\" Poly Valve",null,null,null,134.63999999999999,null,0,0,0,0,0,0]
[0,null,"Each","4\" Poly Valve",null,null,null,215.8,null,0,0,0,0,0,0]
[0,null,"Each","6\" Poly Valve",null,null,null,549.24,null,0,0,0,0,0,0]
[0,null,"Each","1-1/4\" Butt Fuse Tee",null,null,null,3.5,null,0,0,0,0,0,0]
[0,null,"Each","2\" Butt Fuse Tee",null,null,null,5.0199999999999996,null,0,0,0,0,0,0]
[0,null,"Each","3\" Butt Fuse Tee",null,null,null,10.69,null,0,0,0,0,0,0]
[0,null,"Each","4\" Butt Fuse Tee",null,null,null,16.350000000000001,null,0,0,0,0,0,0]
[0,null,"Each","6\" Butt Fuse Tee",null,null,null,31.04,null,0,0,0,0,0,0]
[0,null,"Each","1\" Butt Fuse End Cap",null,null,null,2.5499999999999998,null,0,0,0,0,0,0]
[0,null,"Each","1-1/4\" Butt Fuse End Cap",null,null,null,2.5499999999999998,null,0,0,0,0,0,0]
[0,null,"Each","2\" Butt Fuse End Cap",null,null,null,1.51,null,0,0,0,0,0,0]
[0,null,"Each","3\" Butt Fuse End Cap",null,null,null,4.9000000000000004,null,0,0,0,0,0,0]
[0,null,"Each","4\" Butt Fuse End Cap",null,null,null,7.01,null,0,0,0,0,0,0]
[0,null,"Each","6\" Butt Fuse End Cap",null,null,null,18.489999999999998,null,0,0,0,0,0,0]
[0,null,"Each","1-1/4\" Support Clamp",null,null,null,14.87,null,0,0,0,0,0,0]
[0,null,"Each","2\" Support Clamp",null,null,null,12.27,null,0,0,0,0,0,0]
[0,null,"Each","3\" Support Clamp",null,null,null,12.04,null,0,0,0,0,0,0]
[0,null,"Each","4\" Support Clamp",null,null,null,16.21,null,0,0,0,0,0,0]
[0,null,"Each","6\" Support Clamp",null,null,null,27.08,null,0,0,0,0,0,0]
[0,null,"Each","2 x 2\" EF HV Tap Tee",null,null,null,49.47,null,0,0,0,0,0,0]
[0,null,"Each","4 x 2\" EF HV Tap Tee",null,null,null,67.63,null,0,0,0,0,0,0]
[0,null,"Each","6 x 2\" EF HV Tap Tee",null,null,null,66.36,null,0,0,0,0,0,0]
[0,null,"Each","3/4 ElectroFuse Coupling",null,null,null,7.17,null,0,0,0,0,0,0]
[0,null,"Each","1\" ElectroFuse Coupling",null,null,null,5.33,null,{"$f":"ROUND(A36*H36,2)","v":0},0,{"$f":"ROUND(J36*$L$3, 2)","v":0},{"$f":"ROUND(J36*$M$3, 2)","v":0},{"$f":"ROUND(J36*$N$3, 2)","v":0},0]
[0,null,"Each","1-1/4\" ElectroFuse Coupling",null,null,null,8.8800000000000008,null,0,0,0,0,0,0]
[0,null,"Each","2\" ElectroFuse Coupling",null,null,null,4.37,null,0,0,0,0,0,0]
[0,null,"Each","3\" ElectroFuse Coupling",null,null,null,11.3,null,0,0,0,0,0,0]
[0,null,"Each","4\" ElectroFuse Coupling",null,null,null,25.74,null,0,0,0,0,0,0]
[0,null,"Each","6\" ElectroFuse Coupling",null,null,null,31.72,null,0,0,0,0,0,0]
[0,null,"Each","1/2\" Expansion Stopper",null,null,null,2.64,null,0,0,0,0,0,0]
[0,null,"Each","3/4\" Expansion Stopper",null,null,null,2.82,null,0,0,0,0,0,0]
[0,null,"Each","1-1/4\" Expansion Stopper",null,null,null,2.99,null,0,0,0,0,0,0]
[0,null,"Each","2\" Expansion Stopper",null,null,null,3.86,null,0,0,0,0,0,0]
[0,null,"Each","3/4 X 1/2\" Dresser Coupling",null,null,null,30.85,null,0,0,0,0,0,0]
[0,null,"Each","3/4 X 3/4\" Dresser Coupling",null,null,null,27.31,null,0,0,0,0,0,0]
[0,null,"Each","2 X 1-1/4\" Dresser Coupling",null,null,null,36.29,null,0,0,0,0,0,0]
[0,null,"Each","2 X 2\" Dresser Coupling",null,null,null,45.67,null,0,0,0,0,0,0]
[0,null,"Each","3 X 3\" Dresser Coupling",null,null,null,143.38999999999999,null,0,0,0,0,0,0]
[0,null,"Each","4 X 4\" Dresser Coupling",null,null,null,47.03,null,0,0,0,0,0,0]
[0,null,"Each","1/2\" Constab Coupling",null,null,null,3.8,null,0,0,0,0,0,0]
[0,null,"Each","3/4\" Constab Coupling",null,null,null,5.1100000000000003,null,0,0,0,0,0,0]
[0,null,"Each","1\" Constab Coupling",null,null,null,8.3699999999999992,null,0,0,0,0,0,0]
[0,null,"Each","1-1/4\" Constab Coupling",null,null,null,21.6,null,0,0,0,0,0,0]
[0,null,"Each","2\" Constab Coupling",null,null,null,21.99,null,0,0,0,0,0,0]
[0,null,"Each","2 x 3/4\" EF Tapping Tee",null,null,null,36.76,null,0,0,0,0,0,0]
[0,null,"Each","2 x 1-1/4\" EF Tapping Tee",null,null,null,58.75,null,0,0,0,0,0,0]
[0,null,"Each","2 X 2\" EF Tapping Tee",null,null,null,49.47,null,0,0,0,0,0,0]
[0,null,"Each","1/2\" Constab End Cap",null,null,null,3.54,null,0,0,0,0,0,0]
[0,null,"Each","3/4\" Constab End Cap",null,null,null,5.0599999999999996,null,0,0,0,0,0,0]
[0,null,"Each","1\" Constab End Cap",null,null,null,7.39,null,0,0,0,0,0,0]
[0,null,"Each","1-1/4\" Constab End Cap",null,null,null,18.510000000000002,null,0,0,0,0,0,0]
[0,null,"Each","2\" Constab End Cap",null,null,null,16.48,null,0,0,0,0,0,0]
[0,null,"Each","3/4\" Riser",null,null,null,52.52,null,0,0,0,0,0,0]
[0,null,"Each","1-1/4\" Riser",null,null,null,62.98,null,0,0,0,0,0,0]
[0,null,"Each","2\" Riser",null,null,null,121.14,null,0,0,0,0,0,0]
[0,null,"Each","3/4\" Valve - Stop Cock",null,null,null,22.67,null,{"$f":"ROUND(A68*H68,2)","v":0},0,0,0,0,{"$f":"J68+K68+L68+M68+N68","v":0}]
[0,null,"Each","1\" Valve - Stop Cock",null,null,null,23.33,null,0,{"$f":"ROUND(J69*$K$3, 2)","v":0},{"$f":"ROUND(J69*$L$3, 2)","v":0},{"$f":"ROUND(J69*$M$3, 2)","v":0},{"$f":"ROUND(J69*$N$3, 2)","v":0},0]
[0,null,"Each","1-1/4\" Valve - Stop Cock",null,null,null,41.13,null,0,0,0,0,0,0]
[0,null,"Each","2\" Valve - Stop Cock",null,null,null,66.37,null,0,0,0,0,0,0]
[0,null,"Each","Splice Kit",null,null,null,4.54,null,0,0,0,0,0,0]
[0,null,"Roll","Marking Tape",null,null,null,12.49,null,{"$f":"ROUND(A73*H73,2)","v":0},0,0,0,0,0]
[0,null,"Feet","#12 Wire",null,null,null,0.12,null,{"$f":"ROUND(A74*H74,2)","v":0},0,0,0,0,0]
[0,null,"Each","Protective Sleeve 1-1/2 X 18 ",null,null,null,2.72,null,{"$f":"ROUND(A75*H75,2)","v":0},0,0,0,0,0]
[0,null,"Each","Protective Sleeve  2-1/2 X 30",null,null,null,2.72,null,0,0,0,0,0,0]
[0,null,"Each","5# Anode",null,null,null,18.39,null,0,0,0,0,0,0]
[0,null,"Each","9# Anode",null,null,null,33.93,null,0,0,0,0,0,0]
[0,null,"Each","17# Anode",null,null,null,71.349999999999994,null,0,0,0,0,0,0]
[0,null,"Each","Valve Box",null,null,null,92.11,null,0,0,0,0,0,0]
[0,null,"Each","Line Markers - ATMOS 3 SIDED",null,null,null,13.86,null,0,0,0,0,0,0]
[0,null,"Each","Residential Meter 250",null,null,null,65.42,null,0,0,0,0,0,0]
[0,null,"Each","Residential Meter 250 with AMR",null,null,null,144.4,null,0,0,0,0,0,0]
[0,null,"Each","Residential Meter Loop",null,null,null,87.69,null,0,0,0,0,0,0]
[0,null,"Each","1-1/4\" Transition Fitting",null,null,null,16.34,null,0,0,0,0,0,0]
[0,null,"Each","2\" Transition Fitting",null,null,null,26.93,null,0,0,0,0,0,0]
[0,null,"Each","3\" Transition Fitting",null,null,null,42.53,null,0,0,0,0,0,0]
[0,null,"Each","4\" Transition Fitting",null,null,null,66.53,null,0,0,0,0,0,0]
[0,null,"Each","6\" Transition Fitting",null,null,null,182.52,null,0,0,0,0,0,0]
[0,null,"Each","2\" Line Stopper Standard",null,null,null,131.13,null,0,0,0,0,0,0]
[0,null,"Each","2\" Line Stopper Bottom Out",null,null,null,141.35,null,0,0,0,0,0,0]
[0,null,"Each","3\" Line Stopper Standard",null,null,null,621.39,null,0,0,0,0,0,0]
[0,null,"Each","3\" Line Stopper Bottom Out",null,null,null,653.95000000000005,null,0,0,0,0,0,0]
[0,null,"Each","4\" Line Stopper Standard",null,null,null,821.12,null,0,0,0,0,0,0]
[0,null,"Each","6\" Line Stopper Standard",null,null,null,1177.7,null,{"$f":"ROUND(A95*H95,2)","v":0},0,0,0,0,0]
[0,null,"Each","1-1/4 x 3/4 Lycofit Tap Tee",null,null,null,38.75,null,{"$f":"ROUND(A96*H96,2)","v":0},0,0,0,0,0]
[0,null,"Each","2 x 3/4 Lycofit Tap Tee",null,null,null,45.86,null,0,0,0,0,0,0]
[0,null,"Each","4 x 3/4 Lycofit Tap Tee",null,null,null,74.790000000000006,null,0,0,0,0,0,0]
[0,null,"Each","6 x 3/4 Lycofit Tap Tee",null,null,null,104.18,null,0,0,0,0,0,0]
[0,null,"Each","3/4 Lycofit coupling",null,null,null,17.07,null,0,0,0,0,0,0]
[0,null,"Each","3/4 Lycofit cap",null,null,null,16.91,null,0,0,0,0,0,0]
[0,null,"Each","3/4 x 1/2 Lycofit coupling",null,null,null,27.29,null,0,0,0,0,0,0]
[0,null,null,"Miscellaneous",null,null,null,0,null,0,0,0,0,0,0]
[0,null,null,"Miscellaneous",null,null,null,0,null,0,0,0,0,0,0]
[0,null,null,"Miscellaneous",null,null,null,0,null,0,{"$f":"ROUND(J105*$K$3, 2)","v":0},0,0,0,0]
[0,null,null,"Miscellaneous",null,null,null,4,null,0,{"$f":"ROUND(J106*$K$3, 2)","v":0},0,0,0,0]
[0,null,null,"Miscellaneous",null,null,null,0,null,0,{"$f":"ROUND(J107*$K$3, 2)","v":0},0,0,0,0]
[0,null,null,"Miscellaneous",null,null,null,0,null,0,{"$f":"ROUND(J108*$K$3, 2)","v":0},0,0,0,0]
[0,null,null,"Miscellaneous",null,null,null,0,null,{"$f":"ROUND(A109*H109, 2)","v":0},{"$f":"ROUND(J109*$K$3, 2)","v":0},0,0,0,0]
[null,null,null,"Total Warehouse Materials with Overheads",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O4:O109)","v":0}]
[]
[]
["OTHER MATERIALS (WITHOUT STORES)"]
[null,null,null,null,null,null,null,null,null,null,"Stores OH2","State OH3","BU OH4","Corp.OH5"]
["Quantity",null,"UOM","Description",null,null,null,"Unit Cost1",null,"Total w/o OH",null,{"$f":"L3","v":7.6200000000000004E-2},{"$f":"M3","v":9.8599999999999993E-2},{"$f":"N3","v":4.8399999999999999E-2}]
[0,null,null,"Miscellaneous",null,null,null,0,null,{"$f":"ROUND(A116*H116,2)","v":0},null,{"$f":"ROUND(J116*$L$115, 2)","v":0},{"$f":"ROUND(J116*$M$115, 2)","v":0},{"$f":"ROUND(J116*$N$115, 2)","v":0},{"$f":"J116+L116+M116+N116","v":0}]
[0,null,null,"Miscellaneous",null,null,null,0,null,0,null,0,0,{"$f":"ROUND(J117*$N$115, 2)","v":0},0]
[0,null,null,"Miscellaneous",null,null,null,0,null,0,null,0,0,0,0]
[0,null,null,"Miscellaneous",null,null,null,0,null,0,null,0,0,0,0]
[0,null,null,"Miscellaneous",null,null,null,0,null,0,null,0,0,0,0]
[0,null,null,"Miscellaneous",null,null,null,0,null,0,null,0,{"$f":"ROUND(J121*$M$115, 2)","v":0},0,0]
[0,null,null,"Miscellaneous",null,null,null,0,null,0,null,0,0,0,0]
[0,null,null,"Miscellaneous",null,null,null,0,null,0,null,0,0,0,0]
[0,null,null,"Miscellaneous",null,null,null,0,null,0,null,{"$f":"ROUND(J124*$L$115, 2)","v":0},0,0,0]
[0,null,null,"Miscellaneous",null,null,null,0,null,0,null,0,0,0,0]
[0,null,null,"Miscellaneous",null,null,null,0,null,0,null,0,0,0,0]
[0,null,null,"Miscellaneous",null,null,null,0,null,0,null,0,0,0,0]
["Total Other Materials with Overheads",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O116:O127)","v":0}]
[]
["NOTES:"]
["1Unit cost rate comes from McJunkin material listing provided by Connie Fennell.  "]
["2Stores overhead rate will update each October.  See Josh Densman for annual update.  "]
["3State overhead rate will update each October.  See Josh Densman for annual update.  Also, state overhead rate is different for each KMD jurisdiction."]
["4Business unit overhead rate will update each October.  See Josh Densman for annual update."]
["5Shared services overhead rate will update each October.  See Josh Densman for annual update."]
["Cells containing bolded blue text or number may be updated by user depending on the need and situation."]

{"sheet":"EQUIPMENT","index":2,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,0,2,7]]}
[]
["EQUIPMENT CALCULATION"]
[]
[]
["EQUIPMENT TYPE",null,"RATE",null,"HOURS "]
[null,null,"PER HR1",null,"USED",null,null,"TOTAL"]
["PASSENGER CARS",null,15,null,0,null,null,{"$f":"ROUND(C7*E7, 2)","v":0}]
["1/2 TON PICKUP (F-150)",null,19,null,0,null,null,{"$f":"ROUND(C8*E8, 2)","v":0}]
["VANS",null,19,null,0,null,null,0]
["3/4 TON PICKUP (F-250)",null,20,null,0,null,null,0]
["1 TON TRUCKS (F-350)",null,24,null,0,null,null,0]
["1.5 TON TRUCKS (F-450 & F-550)",null,24,null,0,null,null,0]
["2 TON TRUCKS (MAINLINE F-650 OR GREATER)",null,30,null,0,null,null,0]
["UTILITY TRAILER",null,8,null,0,null,null,0]
["BACKHOE TRAILER",null,8,null,0,null,null,0]
["BACKHOE",null,32,null,0,null,null,0]
["SMALL TRENCHER",null,20,null,0,null,null,0]
["LARGE TRENCHER",null,30,null,0,null,null,0]
["MUELLER TAPPING TRUCK",null,220,null,0,null,null,0]
["BORING MACHINE",null,100,null,0,null,null,0]
["MISCELLANEOUS",null,0,null,0,null,null,0]
["MISCELLANEOUS",null,0,null,0,null,null,0]
["MISCELLANEOUS",null,0,null,0,null,null,0]
["TOTAL",null,null,null,null,null,null,{"$f":"SUM(H7:H23)","v":0}]
[]
["NOTES:"]
[]
["1Equipment rates per hour provided by Fleet Department.  Rates will be updated each October"]
["Cells containing bolded blue text or number may be updated by user depending on the need and situation."]

{"sheet":"Lost Gas Calculator","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[6,0,6,2],[10,3,10,8],[0,3,5,10]]}
["Pipe Size",null,null,"1) Fill out all Information in Rows 1-6\n2) Click Rectangular Hole if damage is given as length and width. Enter dimensions\n3) Click Circular Hole if damage is circular. Enter dimensions\n4) Click Calculate Gas Loss"]
["Material Type"]
["Pressure (PSIG)"]
["Duration (Minutes)"," "]
["Distance to Feeder Main or Regulator Station (Feet)"," "]
["Main or Service"]
[null,null,null,"Calculator uses IGT Flow Formula"]
["Gas Loss Flow Rate",{"$f":"'Lost Gas Calculation'!B13","v":0},"Cubic Feet/Min."]
["Gas Loss in Cubic Feet",{"$f":"'Lost Gas Calculation'!B14","v":0},"Cubic Feet"]
["Gas Loss in Pounds",{"$f":"'Lost Gas Calculation'!B15","v":0},"Pounds"]
["Gas Loss in CCF",{"$f":"'Lost Gas Calculation'!B16","v":0},"CCF","IF LARGER THAN 1,000 CCF CONTACT TECH. SERVICES"]
["Gas Loss in MCF",{"$f":"'Lost Gas Calculation'!B17","v":0},"MCF"]

{"sheet":"OUTSIDE SERVICES","index":4,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,0,2,7]]}
[]
["OUTSIDE SERVICES CALCULATION"]
[]
[]
[null,null,"RATE",null,"HOURS "]
["VENDOR NAME:",null,"PER HR",null,"USED",null,null,"TOTAL"]
[null,null,0,null,0,null,null,{"$f":"ROUND(C7*E7, 2)","v":0}]
[null,null,0,null,0,null,null,{"$f":"ROUND(C8*E8, 2)","v":0}]
[null,null,0,null,0,null,null,{"$f":"ROUND(C9*E9, 2)","v":0}]
[null,null,0,null,0,null,null,{"$f":"ROUND(C10*E10, 2)","v":0}]
[null,null,0,null,0,null,null,0]
[null,null,0,null,0,null,null,0]
[null,null,0,null,0,null,null,0]
[null,null,0,null,0,null,null,0]
["TOTAL",null,null,null,null,null,null,{"$f":"SUM(H7:H14)","v":0}]
[]
["NOTES:"]

{"sheet":"BILLING SUMMARY","index":5,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[[10,2,10,13],[16,2,16,13],[13,2,13,13],[33,12,33,13],[12,2,12,13],[26,6,26,8],[27,6,27,8],[7,2,7,13],[8,2,8,13],[9,2,9,13],[11,2,11,13],[31,12,31,13],[29,12,29,13],[27,12,27,13],[25,12,25,13],[23,12,23,13],[21,12,21,13],[14,2,14,13],[15,2,15,13]]}
[]
[null,"ATMOS ENERGY CORPORATION"]
[null,"KENTUCKY / MID-STATES DIVISION"]
[null,"KENTUCKY OPERATIONS"]
[null,"3RD PARTY DAMAGE BILLING"]
[]
[]
[null,"CUSTOMER NAME:"]
[null,"BILLING ADDRESS:"]
[null,"CITY, STATE, & ZIP CODE:"]
[null,"PHONE #:"]
[null,"ATMOS WORK CENTER:"]
[null,"DATE OF DAMAGE:"]
[null,"DAMAGE LOCATION:"]
[null,"ASSET #:"]
[null,"eAM #:"]
[null,"SAP INVOICE #:"]
[]
[]
[null,null,"LINE NO.","CHARGE TYPE:"]
[]
[null,null,1,"LABOR",null,null,null,null,null,null,null,null,{"$f":"LABOR!W48","v":98.3}]
[]
[null,null,2,"MATERIALS",null,null,null,null,null,null,null,null,{"$f":"MATERIALS!O128+MATERIALS!O110","v":0}]
[]
[null,null,3,"EQUIPMENT",null,null,null,null,null,null,null,null,{"$f":"EQUIPMENT!H24","v":0}]
[null,null,null,null,null,null,"Enter PGA Rate (per MCF)",null,null,null,"Volume (MCF)"]
[null,null,4,"GAS LOSS COSTS",null,null,0,null,null,null,0,null,{"$f":"G28*'Lost Gas Calculator'!B12","v":0}]
[]
[null,null,5,"OUTSIDE SERVICES",null,null,null,null,null,null,null,null,{"$f":"'OUTSIDE SERVICES'!H15","v":0}]
[]
[null,null,6,"MISCELLANEOUS COSTS",null,null,null,null,null,null,null,null,0]
[]
[null,null,7,"TOTAL 3RD PARTY DAMAGE BILLING",null,null,null,null,null,null,null,null,{"$f":"M22+M24+M26+M28+M30+M32","v":98.3}]

{"sheet":"Workcenter Dropdown List","index":6,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["TN Work Centers"]
["2609 - KY Storage"]
["2634 - Madisonville"]
["2635 - Princeton"]
["2636 - Owensboro"]
["2637 - Paducah"]
["2638 - Mayfield"]
["2734 - Bowling Green"]
["2735 - Glasgow"]
["2736 - Hopkinsville"]
["2737 - Danville"]
["2738 - Campbellsville"]
["2739 - Shelbyville, KY"]

{"sheet":"Lost Gas Calculation","index":7,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Hydraulic Hole Size",{"$f":"'Data Sheet'!H5","v":0}]
["Pipe Size",{"$f":"'Lost Gas Calculator'!B1","v":0}]
["Material Type",{"$f":"'Lost Gas Calculator'!B2","v":0}]
["Pipe ID",{"$f":"IF(B3=\"Steel\",VLOOKUP(B2,'Data Sheet'!A4:C14,2,FALSE),IF(B3=\"PE\",VLOOKUP(B2,'Data Sheet'!A4:C114,3,FALSE),\"N/A\"))","v":"N/A"}]
["Type of Break",{"$f":"IF(B1>=B2,\"Complete Break\",\"Hole in Pipe\")","v":"Complete Break"}]
["Main or Service",{"$f":"'Lost Gas Calculator'!B6","v":0}]
["Service Size and Type",{"$f":"IF(B6=\"Service\",B2&B3,\"N/A\")","v":"N/A"}]
["Main Size and Type",{"$f":"IF(B6=\"Main\",B2&B3,\" \")","v":" "}]
["Pressure",{"$f":"'Lost Gas Calculator'!B3","v":0}]
["Duration",{"$f":"'Lost Gas Calculator'!B4","v":" "}]
["Distance",{"$f":"'Lost Gas Calculator'!B5","v":" "}]
[]
["Gas Loss Flow Rate",null,"Cubic Feet/Min."]
["Gas Loss in Cubic Feet",null,"Cubic Feet"]
["Gas Loss in Pounds",null,"Pounds"]
["Gas Loss in CCF",null,"CCF"]
["Gas Loss in MCF",null,"MCF"]

{"sheet":"Data Sheet","index":8,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Pipe Size",null,null,null,"Material Type",null,null,"Rectangular Hole",null,null,"Round Hole"]
[null,null,null,null,null,null,"Length",null,null,"Diameter"]
[null,"Steel","PE",null,"PE",null,"Width"]
[0.5,0.622,0.44500000000000001,null,"Steel",null,"Area ",{"$f":"H3*H2","v":0}]
[0.75,0.82399999999999995,0.86,null,null,null,"Hydraulic Diamter",{"$f":"IF(H4>0,H4*4/(H3*2+H2*2),K2)","v":0}]
[1,1.0489999999999999,1.075]
[1.25,1.38,1.34]
[2,2.0670000000000002,1.917,null,null,null,"Main"]
[3,3.0680000000000001,2.8260000000000001,null,null,null,"Service"]
[4,4.0259999999999998,3.633]
[6,6.0650000000000004,5.3490000000000002]
[8,7.9809999999999999,8.6790000000000003]
[10,10.02,null,null,null,null,"Tennessee",8.9599999999999999E-2]
[12,12,null,null,null,null,"Kentucky",8.5500000000000007E-2]
[null,null,null,null,null,null,"Virginia",0.12859999999999999]