{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["0000","00000044"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"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":"1904"}

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

{"sheet":"00000044","index":1,"n_rows":81,"n_cols":14,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
[null,"2012 GAS UNIT COSTS"]
[null,"AVISTA UTILITIES"]
[]
[]
[null,null,"HANDY-WHITMAN INDEX"]
[10,10,11,11,12,12,13]
["Jan'10","Jul'10","Jan'11","Jul'11","Jan'12","Jul'12","Jan'13"]
[]
[682,711,757,774,870,863,862,{"$f":"((E9+F9+F9+G9)/4)/((C9+D9+D9+E9)/4)","v":1.0891338582677166},"MAINS STEEL"]
[491,491,499,506,524,531,532,{"$f":"((E10+F10+F10+G10)/4)/((C10+D10+D10+E10)/4)","v":1.0407862407862407},"MAINS PLASTIC"]
[573,583,608,616,662,661,665,{"$f":"((E11+F11+F11+G11)/4)/((C11+D11+D11+E11)/4)","v":1.0587529976019185},"SVS STEEL"]
[529,529,544,547,565,569,575,{"$f":"((E12+F12+F12+G12)/4)/((C12+D12+D12+E12)/4)","v":1.0340444847934636},"SVS PLASTIC"]
[null,null,null,null,null,null,null,null,null,null,null,null,"yellow is input area"]
[]
[null,null,null,null,null,null,null,2011,null,2012,2012]
[null,null,null,"Ret.",null,null,2012,"EST","ADJ.","EST","EST",null,2012,2012]
[null,null,"TYPE","Code","SIZE","TYPE","FEET","COST/FT","FACTOR","COST/FT","COST","%","ADDITIONS","COST/FT"]
[]
["Wash. & Idaho",null,"MAIN"]
[null,null," ",17004,"3/4\"","PE",null,14.231917180626544,{"$f":"H10","v":1.0407862407862407},{"$f":"H20*I20","v":14.812383581605415},{"$f":"G20*J20","v":0},{"$f":"K20/$K$33","v":0},{"$f":"L20*$M$33","v":0},{"$f":"IF(M20=0,0,M20/G20)","v":0}]
[null,null,null,17006,"3/4\"","STL",null,20.800549649800711,{"$f":"H9","v":1.0891338582677166},22.654582894176649,0,0,0,0]
[null,null,null,17016,"1 1/4\"","PE",null,14.231917180626544,{"$f":"H10","v":1.0407862407862407},14.812383581605415,0,0,0,0]
[null,null,null,17017,"1 1/4\"","STL",null,14.708807586645218,{"$f":"H9","v":1.0891338582677166},16.019860357360368,0,0,0,0]
[null,null,null,17020,"2\"","PE",{"$f":"'[1]Mains & Services installed'!$I$9","v":37453},24.074153123488397,{"$f":"H10","v":1.0407862407862407},25.056047329507823,938424.14063205651,0.27637225677373539,2029770.45779839,54.195136779387234]
[null,null,null,17025,"2\"","STL",{"$f":"'[1]Mains & Services installed'!$I$10","v":0},19.005197988169034,{"$f":"H9","v":1.0891338582677166},20.699204611996386,0,0,0,0]
[null,null,null,17030,"3\"","PE",{"$f":"'[1]Mains & Services installed'!$I$11","v":0},17.74556633682425,{"$f":"H10","v":1.0407862407862407},18.469341278326173,0,0,0,0]
[null,null,null,17040,"4\"","PE",{"$f":"'[1]Mains & Services installed'!$I$13","v":0},28.463834361253088,{"$f":"H10","v":1.0407862407862407},29.62476716321083,0,0,0,0]
[null,null,null,17045,"4\"","STL",{"$f":"'[1]Mains & Services installed'!$I$14","v":0},33.952355029489276,{"$f":"H9","v":1.0891338582677166},{"$f":"H28*I28","v":36.978659430542969},{"$f":"G28*J28","v":0},0,0,{"$f":"IF(M28=0,0,M28/G28)","v":0}]
[null,null,null,17060,"6\"","PE",{"$f":"'[1]Mains & Services installed'!$I$15","v":42436},43.122981022194601,{"$f":"H10","v":1.0407862407862407},44.881805309586319,1904604.2901176051,0.56091884589222984,4119575.9513102295,97.077385976770415]
[null,null,null,17065,"6\"","STL",{"$f":"'[1]Mains & Services installed'!$I$16","v":15576},32.567080715814946,{"$f":"H9","v":1.0891338582677166},35.469910272531678,552479.32240495342,0.16270889733403479,1194988.6608913813,76.719867802476969]
[null,null,null,17085,"8\"","STL",{"$f":"'[1]Mains & Services installed'!$I$17","v":0},55.032773191194714,{"$f":"H9","v":1.0891338582677166},59.938056596898058,0,0,0,0]
[null,null,null,17125,"12\"","STL",{"$f":"'[1]Mains & Services installed'!$I$18","v":0},1087.2417069394319,{"$f":"H9","v":1.0891338582677166},1184.1517551485215,0,0,0,0]
[null,null,null,null,null,null,{"$f":"SUM(G20:G32)","v":95465},null,null,null,{"$f":"SUM(K20:K32)","v":3395507.7531546149},{"$f":"SUM(L20:L32)","v":1},7344335.0700000003]
[]
[]
["Wash. & Idaho",null,"SERVICE",18000,"1/2\"","PE",null,11.524853761293322,{"$f":"H12","v":1.0340444847934636},{"$f":"H36*I36","v":11.917211469916564},{"$f":"G36*J36","v":0},{"$f":"K36/$K$49","v":0},{"$f":"L36*$M$49","v":0},{"$f":"IF(M36=0,0,M36/G36)","v":0}]
[null,null,null,18004,"3/4\"","PE",{"$f":"'[1]Mains & Services installed'!$J$46","v":215615},11.639771684693336,{"$f":"H12","v":1.0340444847934636},12.036041714812267,2595151.1343392469,0.99510691369606219,5532251.5695244083,25.658008809797131]
[null,null,null,18006,"3/4\"","STL",{"$f":" '[1]Mains & Services installed'!$J$47","v":0},15.955278296094706,{"$f":"H11","v":1.0587529976019185},16.8926987235631,0,0,0,0]
[null,null,null,18016,"1 1/4\"","PE",null,12.181546123837453,{"$f":"H12","v":1.0340444847934636},12.596260585611311,0,0,0,0]
[null,null,null,18017,"1 1/4: ","STL(1)",null,17.913854340053902,{"$f":"H11","v":1.0587529976019185},{"$f":"H40*I40","v":18.966346981136208},0,0,0,0]
[null,null,"                         ",18020,"2\"","PE",{"$f":"'[1]Mains & Services installed'!$J$51","v":82},12.739728151909551,{"$f":"H12","v":1.0340444847934636},13.173445633250095,1080.2225419265078,4.142097566410492E-4,2302.7802789335956,28.082686328458482]
[null,null,null,18025,"2\"","STL",{"$f":"'[1]Mains & Services installed'!$J$52","v":548},19.20365801107436,{"$f":"H11","v":1.0587529976019185},20.331930484147076,11141.897905312597,4.2723444852837836E-3,23751.904603367337,43.342891611984193]
[null,null,null,18030,"3\"","PE",0,19.815533277554067,{"$f":"H12","v":1.0340444847934636},20.490142898896128,0,0,0,0]
[null,null,null,18040,"4\"","PE",{"$f":"'[1]Mains & Services installed'!$J$54","v":24},21.703507619642412,{"$f":"H12","v":1.0340444847934636},22.442392354764149,538.61741651433954,2.0653206201302706E-4,1148.2055932913199,47.841899720471666]
[null,null,null,18045,"4\"","STL",{"$f":"'[1]Mains & Services installed'!$J$55","v":377},33.744918926689635,{"$f":"H11","v":1.0587529976019185},{"$f":"H45*I45","v":35.727534067466365},{"$f":"G45*J45","v":13469.280343434819},5.1647758833417998E-3,28713.336319545007,{"$f":"IF(M45=0,0,M45/G45)","v":76.162695807811687}]
[null,null,null,18060,"6\"","PE",0,17.782313108913598,{"$f":"H12","v":1.0340444847934636},18.387702797142616,0,0,0,0]
[null,null,null,18065,"6\"","STL",{"$f":"'[1]Mains & Services installed'!$J$57","v":85},26.42449147575358,{"$f":"H11","v":1.0587529976019185},27.977009560060448,2378.0458126051381,9.1185819503797653E-4,5069.4341092914283,59.640401285781508]
[null,null,null,18085,"8\"","STL",0,1258.1759849529458,{"$f":"H11","v":1.0587529976019185},1332.0975955796778,0,0,0,0]
[null,null,null,null,null,null,{"$f":"SUM(G36:G48)","v":216731},null,null,null,{"$f":"SUM(K36:K44)","v":2607911.8722030004},{"$f":"SUM(L36:L44)","v":1},5559454.46]
[]
[]
["Oregon",null,"MAIN"]
[null,null,"by footage",27004,"3/4\"","PE",null,14.441443752108409,{"$f":"H10","v":1.0407862407862407},{"$f":"H53*I53","v":15.030455954282854},{"$f":"G53*J53","v":0},{"$f":"K53/$K$65","v":0},{"$f":"L53*$M$65","v":0},{"$f":"IF(M53=0,0,M53/G53)","v":0}]
[null,null,null,27006,"3/4\"","STL",null,21.078231497008776,{"$f":"H9","v":1.0891338582677166},{"$f":"H54*I54","v":22.957015595797277},0,0,0,0]
[null,null,null,27016,"1 1/4\"","PE",null,14.441443752108409,{"$f":"H10","v":1.0407862407862407},{"$f":"H55*I55","v":15.030455954282854},0,0,0,0]
[null,null,null,27017,"1 1/4\"","STL",null,28.657616728484534,{"$f":"H9","v":1.0891338582677166},{"$f":"H56*I56","v":31.211980676251819},0,0,0,0]
[null,null,null,27020,"2\"","PE",{"$f":"'[1]Mains & Services installed'!$I$31","v":31763},24.416185401986795,{"$f":"H10","v":1.0407862407862407},{"$f":"H57*I57","v":25.412029818873723},807162.3031368861,0.40848887077103163,1663934.6896393364,52.385942437406307]
[null,null,null,27025,"2\"","STL",{"$f":"'[1]Mains & Services installed'!$I$32","v":6128},19.283543698286437,{"$f":"H9","v":1.0891338582677166},{"$f":"H58*I58","v":21.00236034918882},128702.46421982908,6.5133770581566885E-2,265315.28296747169,43.295574896780629]
[null,null,null,27030,"3\"","PE",{"$f":"'[1]Mains & Services installed'!$I$33","v":9123},18.003447183102004,{"$f":"H10","v":1.0407862407862407},18.737740114894368,170944.40306818133,8.6511580016277387E-2,352395.44904340996,38.627145570909782]
[null,null,null,27040,"4\"","PE",{"$f":"'[1]Mains & Services installed'!$I$34","v":0},28.882887504216818,{"$f":"H10","v":1.0407862407862407},30.060911908565707,0,0,0,0]
[null,null,null,27045,"4\"","STL",{"$f":"'[1]Mains & Services installed'!$I$35","v":513},34.4067267549664,{"$f":"H9","v":1.0891338582677166},{"$f":"H61*I61","v":37.473531060999626},{"$f":"G61*J61","v":19223.92143429281},9.7288462654499825E-3,39629.390050932896,{"$f":"IF(M61=0,0,M61/G61)","v":77.25027300376783}]
[null,null,null,27060,"6\"","PE",{"$f":"'[1]Mains & Services installed'!$I$36","v":10775},43.701809802716326,{"$f":"H10","v":1.0407862407862407},{"$f":"H62*I62","v":45.48424234012441},490092.71121484053,0.24802622396912433,1010307.6669469655,93.764052616887753]
[null,null,null,27065,"6\"","STL",{"$f":"'[1]Mains & Services installed'!$I$37","v":9826},33.030998502377649,{"$f":"H9","v":1.0891338582677166},35.975178841329736,353492.10729490599,0.17889536116118671,728710.6664370005,74.161476331874667]
[null,null,null,27085,"8\"","STL",{"$f":"'[1]Mains & Services installed'!$I$38","v":106},55.032773191194714,{"$f":"H9","v":1.0891338582677166},{"$f":"H64*I64","v":59.938056596898058},6353.4339992711939,3.2153472353631872E-3,13097.364914883143,123.56004636682211]
[null,null,null,null,null,null,{"$f":"SUM(G53:G64)","v":68234},null,null,null,{"$f":"SUM(K53:K64)","v":1975971.3443682068},{"$f":"SUM(L53:L64)","v":1},4073390.51]
[]
["Oregon",null,"SERVICE *",null,null,null,null,null,null,null,null,null,null,"COST/EACH"]
[null,null,"by quantity",28000,"1/2\"","PE",null,0,{"$f":"H12","v":1.0340444847934636},{"$f":"H68*I68","v":0},{"$f":"G68*J68","v":0},{"$f":"K68/$K$77","v":0},{"$f":"L68*$M$77","v":0},{"$f":"IF(M68=0,0,M68/G68)","v":0}]
[null,null,null,28004,"3/4\"","PE",{"$f":"'[1]Mains & Services installed'!$H$66","v":1335},702.51956195119897,{"$f":"H12","v":1.0340444847934636},726.43647849515719,969792.69879103487,{"$f":"K69/$K$77","v":0.97475504305697436},{"$f":"L69*$M$77","v":1049567.921503816},786.19319962832662]
[null,null,null,28006,"3/4\"","STL",{"$f":"'[1]Mains & Services installed'!$H$67","v":0},0,{"$f":"H11","v":1.0587529976019185},0,0,0,0,0]
[null,null,null,28015,"1\" ","STL",{"$f":"-'[1]Mains & Services installed'!$H$68","v":0},735.33473980716406,{"$f":"H12","v":1.0340444847934636},760.36883217463458,0,0,0,0]
[null,null,"                         ",28020,"2\"","PE",{"$f":"'[1]Mains & Services installed'!$H$69+'[1]Mains & Services installed'!$H$71","v":19},768.14991766312892,{"$f":"H12","v":1.0340444847934636},794.30118585411162,15091.722531228121,1.5168945553075314E-2,16333.168798609888,859.64046308473098]
[null,null,null,28025,"2\"","STL",{"$f":"'[1]Mains & Services installed'!$H$70+'[1]Mains & Services installed'!$H$72","v":2},1125.0777006705846,{"$f":"H11","v":1.0587529976019185},1191.1793881200554,2382.3587762401107,2.3945490973545339E-3,2578.331794178097,1289.1658970890485]
[null,null,null,28035,"3\"","STL",{"$f":"'[1]Mains & Services installed'!$H$73","v":0},0,{"$f":"H12","v":1.0340444847934636},0,{"$f":"G74*J74","v":0},0,0,{"$f":"IF(M74=0,0,M74/G74)","v":0}]
[null,null,null,28040,"4\"","PE",{"$f":"'[1]Mains & Services installed'!$H$74","v":2},1309.6651531906894,{"$f":"H12","v":1.0340444847934636},1354.252028583019,2708.5040571660379,2.7223632351059284E-3,2931.3058112401318,1465.6529056200659]
[null,null,null,28045,"4\"","STL",{"$f":"'[1]Mains & Services installed'!$H$75","v":1},4771.4126778255395,{"$f":"H12","v":1.0340444847934636},4933.8529641791101,{"$f":"G76*J76","v":4933.8529641791101},4.9590990574898807E-3,5339.7120921558144,{"$f":"IF(M76=0,0,M76/G76)","v":5339.7120921558144}]
[null,null,null,null,null,null,{"$f":"SUM(G68:G76)","v":1359},null,null,null,{"$f":"SUM(K68:K76)","v":994909.13711984828},{"$f":"SUM(L68:L75)","v":0.99504090094251008},1076750.44]
[]
[null,null,"* 76FT AVG IS  FROM DOT ANNUAL REPORT FOR OR "]
[]
[null,null,"feet and services entered from Main and Services Installed report should be entered as absolute values, not negative."]