{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Summary","Purchased Power Model ","Rate Class Energy Model","Rate Class Customer Model","Rate Class Load Model"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":12,"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":53,"n_cols":14,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["PUC Distribution Weather Normal Load Forecast for 2013 Rate Application"]
[]
[null,"2003 Actual ","2004 Actual ","2005 Actual ","2006 Actual ","2007 Actual ","2008 Actual ","2009 Actual","2010 Actual ","2011 Actual ","2012 Weather Normal","2013 Weather Normal (including CDM Adjustment)"]
["Actual kWh Purchases",{"$f":"'Purchased Power Model '!B138","v":755126020},{"$f":"'Purchased Power Model '!B139","v":757685752},{"$f":"'Purchased Power Model '!B140","v":749219032},{"$f":"'Purchased Power Model '!B141","v":728093333},{"$f":"'Purchased Power Model '!B142","v":738093576},{"$f":"'Purchased Power Model '!B143","v":740966486},{"$f":"'Purchased Power Model '!B144","v":732869984},{"$f":"'Purchased Power Model '!B145","v":714199062},{"$f":"'Purchased Power Model '!B146","v":745049194}]
["Predicted kWh Purchases",{"$f":"'Purchased Power Model '!J138","v":752186605.21913576},{"$f":"'Purchased Power Model '!J139","v":747941288.96245909},{"$f":"'Purchased Power Model '!J140","v":742744459.91069782},{"$f":"'Purchased Power Model '!J141","v":722674602.90568328},{"$f":"'Purchased Power Model '!J142","v":739500414.14077866},{"$f":"'Purchased Power Model '!J143","v":748042539.6468122},{"$f":"'Purchased Power Model '!J144","v":745709117.88939667},{"$f":"'Purchased Power Model '!J145","v":726958623.63219404},{"$f":"'Purchased Power Model '!J146","v":735544786.69284248},{"$f":"'Purchased Power Model '!J147","v":741365476.65368259},{"$f":"'Purchased Power Model '!J148-'Rate Class Energy Model'!G71","v":734385156.65368259}]
["% Difference",{"$f":"(B5-B4)/B4","v":-3.8926148788572252E-3},-1.2860823912577563E-2,-8.6417613711956293E-3,-7.4423564242645261E-3,1.9060430635405785E-3,9.5497620749505803E-3,1.7518979040894472E-2,1.786555361255017E-2,-1.2756751344338098E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K5-L8","v":38574293.802925348}]
["Billed kWh",{"$f":"'Rate Class Energy Model'!G8","v":719286098},{"$f":"'Rate Class Energy Model'!G9","v":727308120},{"$f":"'Rate Class Energy Model'!G10","v":717783995},{"$f":"'Rate Class Energy Model'!G11","v":697140805},{"$f":"'Rate Class Energy Model'!G12","v":701800772},{"$f":"'Rate Class Energy Model'!G13","v":710698626},{"$f":"'Rate Class Energy Model'!G14","v":707756700},{"$f":"'Rate Class Energy Model'!G15","v":683757862},{"$f":"'Rate Class Energy Model'!G16","v":711929017},{"$f":"'Rate Class Energy Model'!G17","v":709771502.85075724},{"$f":"'Rate Class Energy Model'!G18-'Rate Class Energy Model'!G71","v":702791182.85075724},null,-6980320]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N7:N8)","v":31593973.802925348}]
["By Class"]
[{"$f":"'Rate Class Energy Model'!H2","v":"Residential"}]
["  Customers",{"$f":"'Rate Class Customer Model'!B3","v":28544},{"$f":"'Rate Class Customer Model'!B4","v":28560},{"$f":"'Rate Class Customer Model'!B5","v":28576},{"$f":"'Rate Class Customer Model'!B6","v":28596},{"$f":"'Rate Class Customer Model'!B7","v":28630},{"$f":"'Rate Class Customer Model'!B8","v":28780},{"$f":"'Rate Class Customer Model'!B9","v":28971},{"$f":"'Rate Class Customer Model'!B10","v":29057},{"$f":"'Rate Class Customer Model'!B11","v":29124},{"$f":"'Rate Class Customer Model'!B12","v":29197.323790078721},{"$f":"'Rate Class Customer Model'!B13","v":29270.832183171846}]
["  kWh",{"$f":"'Rate Class Energy Model'!H8","v":351037890},{"$f":"'Rate Class Energy Model'!H9","v":356490492},{"$f":"'Rate Class Energy Model'!H10","v":347274259},{"$f":"'Rate Class Energy Model'!H11","v":335395539},{"$f":"'Rate Class Energy Model'!H12","v":338874337},{"$f":"'Rate Class Energy Model'!H13","v":347363230},{"$f":"'Rate Class Energy Model'!H14","v":348619359},{"$f":"'Rate Class Energy Model'!H15","v":326493714},{"$f":"'Rate Class Energy Model'!H16","v":345282279},{"$f":"'Rate Class Energy Model'!H60","v":343919087.115538},{"$f":"'Rate Class Energy Model'!H61","v":340262683.67096764}]
[]
[{"$f":"'Rate Class Energy Model'!I2","v":"General Service < 50"}]
["  Customers",{"$f":"'Rate Class Customer Model'!C3","v":3230},{"$f":"'Rate Class Customer Model'!C4","v":3247},{"$f":"'Rate Class Customer Model'!C5","v":3274},{"$f":"'Rate Class Customer Model'!C6","v":3301},{"$f":"'Rate Class Customer Model'!C7","v":3302},{"$f":"'Rate Class Customer Model'!C8","v":3325},{"$f":"'Rate Class Customer Model'!C9","v":3352},{"$f":"'Rate Class Customer Model'!C10","v":3345},{"$f":"'Rate Class Customer Model'!C11","v":3366},{"$f":"'Rate Class Customer Model'!C12","v":3383.3977822710644},{"$f":"'Rate Class Customer Model'!C13","v":3400.8854881392622}]
["  kWh",{"$f":"'Rate Class Energy Model'!I8","v":96164282},{"$f":"'Rate Class Energy Model'!I9","v":95721847},{"$f":"'Rate Class Energy Model'!I10","v":95591622},{"$f":"'Rate Class Energy Model'!I11","v":86770873},{"$f":"'Rate Class Energy Model'!I12","v":94225468},{"$f":"'Rate Class Energy Model'!I13","v":93474158},{"$f":"'Rate Class Energy Model'!I14","v":91450221},{"$f":"'Rate Class Energy Model'!I15","v":91377364},{"$f":"'Rate Class Energy Model'!I16","v":101728299},{"$f":"'Rate Class Energy Model'!I60","v":102252688.22505838},{"$f":"'Rate Class Energy Model'!I61","v":102090126.04258485}]
[]
[{"$f":"'Rate Class Energy Model'!J2","v":"General Service  >50"}]
["  Customers",{"$f":"'Rate Class Customer Model'!D3","v":419},{"$f":"'Rate Class Customer Model'!D4","v":424},{"$f":"'Rate Class Customer Model'!D5","v":431},{"$f":"'Rate Class Customer Model'!D6","v":432},{"$f":"'Rate Class Customer Model'!D7","v":429},{"$f":"'Rate Class Customer Model'!D8","v":426},{"$f":"'Rate Class Customer Model'!D9","v":433},{"$f":"'Rate Class Customer Model'!D10","v":435},{"$f":"'Rate Class Customer Model'!D11","v":403},{"$f":"'Rate Class Customer Model'!D12","v":401.04344665062621},{"$f":"'Rate Class Customer Model'!D13","v":399.09639231120019}]
["  kWh",{"$f":"'Rate Class Energy Model'!J8","v":263763186},{"$f":"'Rate Class Energy Model'!J9","v":266586772},{"$f":"'Rate Class Energy Model'!J10","v":266071754},{"$f":"'Rate Class Energy Model'!J11","v":266238407},{"$f":"'Rate Class Energy Model'!J12","v":259930403},{"$f":"'Rate Class Energy Model'!J13","v":261123945},{"$f":"'Rate Class Energy Model'!J14","v":258998141},{"$f":"'Rate Class Energy Model'!J15","v":257036820},{"$f":"'Rate Class Energy Model'!J16","v":255968368},{"$f":"'Rate Class Energy Model'!J60","v":254567184.18349275},{"$f":"'Rate Class Energy Model'!J61","v":251412080.47687784}]
["  kW",{"$f":"'Rate Class Load Model'!B2","v":659827},{"$f":"'Rate Class Load Model'!B3","v":673069},{"$f":"'Rate Class Load Model'!B4","v":682195},{"$f":"'Rate Class Load Model'!B5","v":657827},{"$f":"'Rate Class Load Model'!B6","v":657184},{"$f":"'Rate Class Load Model'!B7","v":650699},{"$f":"'Rate Class Load Model'!B8","v":637622},{"$f":"'Rate Class Load Model'!B9","v":635103.80000000005},{"$f":"'Rate Class Load Model'!B10","v":629024},{"$f":"'Rate Class Load Model'!B11","v":635612.46844419092},{"$f":"'Rate Class Load Model'!B12","v":627734.69243943528}]
[]
[{"$f":"'Rate Class Energy Model'!K2","v":"USL"}]
["  Customers",{"$f":"'Rate Class Customer Model'!E3","v":12},{"$f":"'Rate Class Customer Model'!E4","v":19},{"$f":"'Rate Class Customer Model'!E5","v":27},{"$f":"'Rate Class Customer Model'!E6","v":28},{"$f":"'Rate Class Customer Model'!E7","v":27},{"$f":"'Rate Class Customer Model'!E8","v":22},{"$f":"'Rate Class Customer Model'!E9","v":17},{"$f":"'Rate Class Customer Model'!E10","v":16},{"$f":"'Rate Class Customer Model'!E11","v":19},{"$f":"'Rate Class Customer Model'!E12","v":20.123343720970908},{"$f":"'Rate Class Customer Model'!E13","v":21.313103290123117}]
["  kWh",{"$f":"'Rate Class Energy Model'!K8","v":851637},{"$f":"'Rate Class Energy Model'!K9","v":842654},{"$f":"'Rate Class Energy Model'!K10","v":845827},{"$f":"'Rate Class Energy Model'!K11","v":856153},{"$f":"'Rate Class Energy Model'!K12","v":863982},{"$f":"'Rate Class Energy Model'!K13","v":848325},{"$f":"'Rate Class Energy Model'!K14","v":823448},{"$f":"'Rate Class Energy Model'!K15","v":837229},{"$f":"'Rate Class Energy Model'!K16","v":874873},{"$f":"'Rate Class Energy Model'!K60","v":877821.72570468241},{"$f":"'Rate Class Energy Model'!K61","v":872123.47846807283}]
[]
[]
[{"$f":"'Rate Class Energy Model'!L2","v":"Sentinel Lights"}]
["  Connections",{"$f":"'Rate Class Customer Model'!F3","v":466},{"$f":"'Rate Class Customer Model'!F4","v":466},{"$f":"'Rate Class Customer Model'!F5","v":459},{"$f":"'Rate Class Customer Model'!F6","v":449},{"$f":"'Rate Class Customer Model'!F7","v":443},{"$f":"'Rate Class Customer Model'!F8","v":435},{"$f":"'Rate Class Customer Model'!F9","v":423},{"$f":"'Rate Class Customer Model'!F10","v":411},{"$f":"'Rate Class Customer Model'!F11","v":402},{"$f":"'Rate Class Customer Model'!F12","v":394.64451411751349},{"$f":"'Rate Class Customer Model'!F13","v":387.4236132414137}]
["  kWh",{"$f":"'Rate Class Energy Model'!L8","v":276562},{"$f":"'Rate Class Energy Model'!L9","v":291228},{"$f":"'Rate Class Energy Model'!L10","v":281406},{"$f":"'Rate Class Energy Model'!L11","v":274009},{"$f":"'Rate Class Energy Model'!L12","v":269054},{"$f":"'Rate Class Energy Model'!L13","v":268763},{"$f":"'Rate Class Energy Model'!L14","v":262522},{"$f":"'Rate Class Energy Model'!L15","v":258147},{"$f":"'Rate Class Energy Model'!L16","v":260362},{"$f":"'Rate Class Energy Model'!L60","v":258404.89448335613},{"$f":"'Rate Class Energy Model'!L61","v":253941.81156829742}]
["  kW",{"$f":"'Rate Class Load Model'!C2","v":768},{"$f":"'Rate Class Load Model'!C3","v":873},{"$f":"'Rate Class Load Model'!C4","v":784},{"$f":"'Rate Class Load Model'!C5","v":766},{"$f":"'Rate Class Load Model'!C6","v":747},{"$f":"'Rate Class Load Model'!C7","v":744},{"$f":"'Rate Class Load Model'!C8","v":730},{"$f":"'Rate Class Load Model'!C9","v":714},{"$f":"'Rate Class Load Model'!C10","v":703},{"$f":"'Rate Class Load Model'!C11","v":722.02487751704996},{"$f":"'Rate Class Load Model'!C12","v":709.55430531083641}]
[]
[{"$f":"'Rate Class Energy Model'!M2","v":"Street Lights"}]
["  Connections",{"$f":"'Rate Class Customer Model'!G3","v":8619},{"$f":"'Rate Class Customer Model'!G4","v":8635},{"$f":"'Rate Class Customer Model'!G5","v":8642},{"$f":"'Rate Class Customer Model'!G6","v":8663},{"$f":"'Rate Class Customer Model'!G7","v":8707},{"$f":"'Rate Class Customer Model'!G8","v":8741},{"$f":"'Rate Class Customer Model'!G9","v":8799},{"$f":"'Rate Class Customer Model'!G10","v":8846},{"$f":"'Rate Class Customer Model'!G11","v":8846},{"$f":"'Rate Class Customer Model'!G12","v":8874.7921759571745},{"$f":"'Rate Class Customer Model'!G13","v":8903.6780653889527}]
["  kWh",{"$f":"'Rate Class Energy Model'!M8","v":7192541},{"$f":"'Rate Class Energy Model'!M9","v":7375127},{"$f":"'Rate Class Energy Model'!M10","v":7719127},{"$f":"'Rate Class Energy Model'!M11","v":7605824},{"$f":"'Rate Class Energy Model'!M12","v":7637528},{"$f":"'Rate Class Energy Model'!M13","v":7620205},{"$f":"'Rate Class Energy Model'!M14","v":7603009},{"$f":"'Rate Class Energy Model'!M15","v":7754588},{"$f":"'Rate Class Energy Model'!M16","v":7814836},{"$f":"'Rate Class Energy Model'!M60","v":7896316.7064801157},{"$f":"'Rate Class Energy Model'!M61","v":7900227.3702905914}]
["  kW",{"$f":"'Rate Class Load Model'!D2","v":21295},{"$f":"'Rate Class Load Model'!D3","v":21340},{"$f":"'Rate Class Load Model'!D4","v":21295},{"$f":"'Rate Class Load Model'!D5","v":23029},{"$f":"'Rate Class Load Model'!D6","v":21406},{"$f":"'Rate Class Load Model'!D7","v":21317},{"$f":"'Rate Class Load Model'!D8","v":21346},{"$f":"'Rate Class Load Model'!D9","v":23263.8},{"$f":"'Rate Class Load Model'!D10","v":21619},{"$f":"'Rate Class Load Model'!D11","v":22649.190582967494},{"$f":"'Rate Class Load Model'!D12","v":22660.407631781745}]
[]
[]
["Total of Above"]
["  Customer/Connections",{"$f":"B12+B16+B20+B25+B30+B35","v":41290},{"$f":"C12+C16+C20+C25+C30+C35","v":41351},{"$f":"D12+D16+D20+D25+D30+D35","v":41409},41469,41538,41729,41995,42110,42160,{"$f":"K12+K16+K20+K25+K30+K35-0.56","v":42270.76505279608},{"$f":"L12+L16+L20+L25+L30+L35-0.5","v":42382.728845542799}]
["  kWh",{"$f":"B13+B17+B21+B26+B31+B36","v":719286098},{"$f":"C13+C17+C21+C26+C31+C36","v":727308120},{"$f":"D13+D17+D21+D26+D31+D36","v":717783995},697140805,701800772,710698626,707756700,683757862,711929017,709771502.85075724,{"$f":"L13+L17+L21+L26+L31+L36-2","v":702791180.85075724}]
["  kW from applicable classes",{"$f":"B22+B27+B32+B37","v":681890},{"$f":"C22+C27+C32+C37","v":695282},{"$f":"D22+D27+D32+D37","v":704274},681622,679337,672760,659698,659081.60000000009,651346,658983.68390467542,651104.65437652788]
[]
["Total from Model"]
["  Customer/Connections",{"$f":"'Rate Class Customer Model'!I3","v":41290},{"$f":"'Rate Class Customer Model'!I4","v":41351},{"$f":"'Rate Class Customer Model'!I5","v":41409},{"$f":"'Rate Class Customer Model'!I6","v":41469},{"$f":"'Rate Class Customer Model'!I7","v":41538},{"$f":"'Rate Class Customer Model'!I8","v":41729},{"$f":"'Rate Class Customer Model'!I9","v":41995},{"$f":"'Rate Class Customer Model'!I10","v":42110},{"$f":"'Rate Class Customer Model'!I11","v":42159.5},{"$f":"'Rate Class Customer Model'!I12","v":42270.825052796077},{"$f":"'Rate Class Customer Model'!I13","v":42382.728845542799}]
["  kWh",{"$f":"'Rate Class Energy Model'!G8","v":719286098},{"$f":"'Rate Class Energy Model'!G9","v":727308120},{"$f":"'Rate Class Energy Model'!G10","v":717783995},{"$f":"'Rate Class Energy Model'!G11","v":697140805},{"$f":"'Rate Class Energy Model'!G12","v":701800772},{"$f":"'Rate Class Energy Model'!G13","v":710698626},{"$f":"'Rate Class Energy Model'!G14","v":707756700},{"$f":"'Rate Class Energy Model'!G15","v":683757862},{"$f":"'Rate Class Energy Model'!G16","v":711929017},{"$f":"'Rate Class Energy Model'!O60","v":709771502.85075724},{"$f":"'Rate Class Energy Model'!O61","v":702791180.85075724}]
["  kW from applicable classes",{"$f":"'Rate Class Load Model'!E2","v":681890},{"$f":"'Rate Class Load Model'!E3","v":695282},{"$f":"'Rate Class Load Model'!E4","v":704274},{"$f":"'Rate Class Load Model'!E5","v":681622},{"$f":"'Rate Class Load Model'!E6","v":679337},{"$f":"'Rate Class Load Model'!E7","v":672760},{"$f":"'Rate Class Load Model'!E8","v":659698},{"$f":"'Rate Class Load Model'!E9","v":659081.60000000009},{"$f":"'Rate Class Load Model'!E10","v":651346},{"$f":"'Rate Class Load Model'!E11","v":658983.68390467542},{"$f":"'Rate Class Load Model'!E12","v":651104.65437652788}]
[]
["Check should all be zero"]
["  Customer/Connections",{"$f":"B41-B46","v":0},{"$f":"C41-C46","v":0},{"$f":"D41-D46","v":0},0,0,0,0,0,0.5,-5.9999999997671694E-2,0]
["  kWh",{"$f":"B42-B47","v":0},{"$f":"C42-C47","v":0},0,0,0,0,0,0,0,0,0]
["  kW from applicable classes",{"$f":"B43-B48","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"Purchased Power Model ","index":1,"n_rows":187,"n_cols":21,"rows_kept":187,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"Not Used","Not Used","Not Used"]
[null,"Purchased","Heating Degree Days","Cooling Degree Days","Number of Days in Month","Spring Fall Flag","Ontario Real GDP Monthly %","Number of Peak Hours","Number of Customers","Predicted Purchases ","Variances (kWh)","% Variance","SUMMARY OUTPUT"]
["2003-01-01",85049952,920.6,0,31,0,125.66024937363977,351.91199999999998,32198,{"$f":"$N$18+C3*$N$19+D3*$N$20+E3*$N$21+F3*$N$22","v":85045187.467457548}]
["2003-02-01",76788076,902.6,0,28,0,125.80592062045517,319.87200000000001,32198,79018736.819811106,null,null,"Regression Statistics"]
["2003-03-01",75545096,745.5,0,31,1,125.9517607362029,336.28800000000001,32199,75115843.373464778,null,null,"Multiple R",0.99028403553410027]
["2003-04-01",63274204,497.2,0,30,1,126.09776991664374,336.24,32198,62911565.030374132,null,null,"R Square",0.98066247103370319]
["2003-05-01",52784032,236.5,0,31,1,126.2439483577654,336.28800000000001,32136,53698221.07294561,null,null,"Adjusted R Square",0.97991149903501207]
["2003-06-01",49325848,112.8,11.9,30,0,126.3902962557828,336.24,32119,50408822.433454387,null,null,"Standard Error",1655092.2940260363]
["2003-07-01",51148508,28,27.9,31,0,126.5368138071383,351.91199999999998,32132,50090035.607181981,null,null,"Observations",108]
["2003-08-01",50113412,32.200000000000003,48.6,31,0,126.68350120850199,319.92,32143,52198414.712352127]
["2003-09-01",49728476,123.1,14.2,30,1,126.83035865677196,336.24,32159,48495338.527524412,null,null,"ANOVA"]
["2003-10-01",58883124,348.5,0,31,1,126.97738634907456,351.91199999999998,32189,58410939.53592822,null,null,null,"df","SS","MS","F","Significance F"]
["2003-11-01",66040876,494.7,0,30,1,127.12458448276465,319.68,32230,62806370.421825409,null,null,"Regression",4,1.4308701914322542E+16,3577175478580635.5,1305.857572243561,2.8939583506465314E-87]
["2003-12-01",76444416,657.8,0,31,0,127.27195325542573,336.28800000000001,32256,73987130.216816217,null,null,"Residual",103,282151041679669.87,2739330501744.3677]
["2004-01-01",89226740,1006,0,31,0,127.53411264087498,336.28800000000001,32257,88638635.295481771,null,null,"Total",107,1.4590852956002212E+16]
["2004-02-01",73066340,707,0,29,0,127.79681203173486,320.16000000000003,32250,72544660.468991235]
["2004-03-01",71196888,652.70000000000005,0,31,1,128.06005254032812,368.28,32199,71211019.504136339,null,null,null,"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%","Lower 95.0%","Upper 95.0%"]
["2004-04-01",61357220,457.4,0,30,1,128.32383528126866,336.24,32154,61236866.862278529,null,null,"Intercept",-8138519.6675112741,6107269.4366711918,-1.3325954834485294,0.18560514347709553,-20250848.163732059,3973808.8287095102,-20250848.163732059,3973808.8287095102]
["2004-05-01",55571152,297.89999999999998,0.2,31,1,128.58816137146633,319.92,32212,56300463.964823,null,null,"X Variable 1",42077.843419487544,749.78173815462651,56.120123068147983,4.8246358844922002E-79,40590.828181799552,43564.858657175537,40590.828181799552,43564.858657175537]
["2004-06-01",49366380,151.4,2.2000000000000002,30,0,128.85303193013166,352.08,32194,51127856.852285229,null,null,"X Variable 2",93316.529604265714,13170.721307242447,7.08514950908208,1.7742659886679873E-10,67195.510274807923,119437.5489337235,67195.510274807923,119437.5489337235]
["2004-07-01",51210208,54.7,15.4,31,0,129.11844807878055,336.28800000000001,32195,50047057.406428978,null,null,"X Variable 3",1756349.82203189,201542.22930305082,8.714549938767119,5.2650112983104468E-14,1356638.3449974384,2156061.2990663419,1356638.3449974384,2156061.2990663419]
["2004-08-01",50192756,83,13.5,31,0,129.38441094123903,336.28800000000001,32205,51060558.968952365,null,null,"X Variable 4",-2561513.7112405053,377217.65873638849,-6.7905455959329073,7.3419118648111479E-10,-3309635.9685877757,-1813391.4538932347,-3309635.9685877757,-1813391.4538932347]
["2004-09-01",50272804,84.1,24.3,30,1,129.65092164364802,336.24,32206,47796799.583167478]
["2004-10-01",57641764,307.3,0,31,1,129.91798131446814,319.92,32231,56677332.387045331]
["2004-11-01",64887008,462.7,0,30,1,130.18559108448443,352.08,32250,61459879.432401814]
["2004-12-01",83696492,796.9,0,31,0,130.45375208681136,336.28800000000001,32296,79840158.236466944]
["2005-01-01",88287600,925.1,0,31,0,130.74370215685079,319.92,32294,85234537.762845248]
["2005-02-01",71065788,693.6,0,28,0,131.0342966778299,319.87200000000001,32296,70224467.54513821]
["2005-03-01",73186104,744.9,0,31,1,131.32553708212293,351.91199999999998,32283,75090596.667413086,null,null,null,"Column 1","Column 2","Column 3","Column 4"]
["2005-04-01",56446820,369.1,0,30,1,131.61742480528775,336.24,32297,57521393.288337775,null,null,{"$f":"C2","v":"Heating Degree Days"},1]
["2005-05-01",53664344,259,0,31,1,131.90996128607298,336.28800000000001,32300,54644972.549884081,null,null,{"$f":"D2","v":"Cooling Degree Days"},-0.63339388372068672,1]
["2005-06-01",51111168,31.7,41.8,30,0,132.20314796642501,352.08,32310,49786473.567301489,null,null,{"$f":"E2","v":"Number of Days in Month"},-0.18201558110720184,0.20533844775872256,1]
["2005-07-01",53387012,34.9,78.8,31,0,132.49698629149512,319.92,32356,55130184.083633572,null,null,{"$f":"F2","v":"Spring Fall Flag"},-7.6014083187370823E-2,-0.34195360899141158,6.7026321206541339E-2,1]
["2005-08-01",52102684,23.7,40.6,31,0,132.79147770964664,351.91199999999998,32376,51094220.806452356]
["2005-09-01",49504120,82.6,22.3,30,1,133.08662367246211,336.24,32360,{"$f":"$N$18+C35*$N$19+D35*$N$20+E35*$N$21+F35*$N$22","v":47547049.75882972}]
["2005-10-01",55381484,273.60000000000002,9.6,31,1,133.38242563475035,319.92,32400,56155147.748009555]
["2005-11-01",65851664,497.6,0,30,1,133.67888505455369,352.08,32410,62928396.167741925]
["2005-12-01",79230244,738.6,0,31,0,133.97600339315525,319.92,32415,77387019.965110809]
["2006-01-01",76234176,689.8,0,31,0,134.25197202423305,336.28800000000001,32395,75333621.20623982]
["2006-02-01",71202696,734.6,0,28,0,134.52850910550649,319.87200000000001,32399,71949659.125337198]
["2006-03-01",70367240,635.4,0,31,1,134.80561580788986,368.28,32453,70483072.812979192]
["2006-04-01",56652640,360,0,30,1,135.08329330470943,303.83999999999997,32445,57138484.913220435]
["2006-05-01",52446572,185.1,8.4,31,1,135.36154277170829,351.91199999999998,32425,52319278.769859783]
["2006-06-01",49917449,81.2,12.9,30,0,135.64036538705133,352.08,32422,49172479.111002848]
["2006-07-01",53606640,8.4,78.2,31,0,135.9197623313303,319.92,32399,53959131.315254591]
["2006-08-01",51038392,35,20.100000000000001,31,0,136.19973478756879,351.91199999999998,32410,49656711.58020512]
["2006-09-01",49455772,151.9,5.2,30,1,136.48028394122719,319.68,32415,48867331.651567258]
["2006-10-01",58920568,375.3,0,31,1,136.76141098020776,336.28800000000001,32423,59538625.739570484]
["2006-11-01",63979576,467.9,0,30,1,137.04311709485967,352.08,32436,61678684.218183145]
["2006-12-01",74271612,624.29999999999995,0,31,0,137.32540347798411,304.29599999999999,32453,72577522.46226339]
["2007-01-01",78292016,776.9,0,31,0,137.55000000000001,351.91199999999998,32399,78998601.368077189]
["2007-02-01",75583244,843.5,0,28,0,137.78,319.87200000000001,32404,76531936.2737194]
["2007-03-01",71668468,654.6,0,31,1,138.01,351.91199999999998,32410,71290967.406633362]
["2007-04-01",60506916,459.1,0,30,1,138.22999999999999,319.68,32393,61308399.196091659]
["2007-05-01",51273936,204.6,12.5,31,1,138.46,351.91199999999998,32375,53522394.487917282]
["2007-06-01",50644216,67.8,35.9,30,0,138.69,336.24,32366,50754916.190079823]
["2007-07-01",51622068,38,41.7,31,0,138.91999999999999,336.28800000000001,32389,51798582.149915725]
["2007-08-01",51764316,33.799999999999997,42.5,31,0,139.15,351.91199999999998,32395,51696508.431237288]
["2007-09-01",48836864,127.6,17,30,1,139.38,303.83999999999997,32450,48945975.105804048]
["2007-10-01",54192940,233.5,0.8,31,1,139.61000000000001,351.91199999999998,32485,53646640.766370565]
["2007-11-01",65729492,541,0,30,1,139.84,352.08,32507,64754574.57214769]
["2007-12-01",77979100,711.6,0,31,0,140.07,304.29599999999999,32536,76250918.192784652]
["2008-01-01",79006867,761.9,0,31,0,139.97,352,32538,78367433.71678488]
["2008-02-01",75126905,831.3,0,29,0,139.86000000000001,320,32549,77774936.406033531]
["2008-03-01",74573962,795.5,0,31,1,139.76,304,32544,77219735.544439152]
["2008-04-01",58751936,391.8,0,30,1,139.65,352,32526,58476560.333960138]
["2008-05-01",53931566,320,0,31,1,139.55000000000001,336,32565,{"$f":"$N$18+C67*$N$19+D67*$N$20+E67*$N$21+F67*$N$22","v":57211720.998472817}]
["2008-06-01",48466638,99.8,7.8,30,0,139.44,336,32555,49479212.697623558]
["2008-07-01",50725082,34.799999999999997,18.7,31,0,139.34,352,32552,49517652.870075248]
["2008-08-01",50225177,29,24,31,0,139.22999999999999,320,32581,49768178.985144831]
["2008-09-01",48690797,140.1,9.8000000000000007,30,1,139.13,336,32677,48800069.135396928]
["2008-10-01",56073867,334.5,1.3,31,1,139.02000000000001,352,32716,57943161.21654094]
["2008-11-01",63785625,496.8,0,30,1,138.91999999999999,304,32770,62894733.893006332]
["2008-12-01",81608064,814.7,0,31,0,138.81,336,32782,80589143.849333823]
["2009-01-01",85774977,970.4,0,31,0,138.38999999999999,336,32783,87140664.069748029]
["2009-02-01",71566146,747.8,0,28,0,137.97,304,32787,72505086.65847443]
["2009-03-01",72767317,680.7,0,31,1,137.54,352,32784,72389199.119881988]
["2009-04-01",59966273,425.5,0,30,1,137.13,320,32749,59894583.657196872]
["2009-05-01",52676063,298.89999999999998,0,31,1,136.71,320,32756,56323878.502321631]
["2009-06-01",49196438,126.1,19.2,30,0,136.29,352,32739,51649668.417044707]
["2009-07-01",48238905,87.7,8,31,0,135.87,352,32752,50745083.920200497]
["2009-08-01",49652791,69.3,25.2,31,0,135.46,320,32766,51575895.910475299]
["2009-09-01",48812970,93.1,5,30,1,135.05000000000001,336,32815,46374491.152580537]
["2009-10-01",57724020,381.1,0,31,1,134.63,336,32815,59782677.231403507]
["2009-11-01",59532749,416.7,0,30,1,134.22,320,32883,59524298.635105379]
["2009-12-01",76961335,748.5,0,31,0,133.81,352,32923,77803590.61496374]
["2010-01-01",79854695,810.7,0,31,0,134.16999999999999,320,32936,80420832.475655869]
["2010-02-01",68437902,691.1,0,28,0,134.52000000000001,304,32950,70119272.936589494]
["2010-03-01",63113132,510.8,0,31,1,134.87,368,32936,65240173.522911049]
["2010-04-01",53091250,327.8,0.2,30,1,135.22999999999999,320,32921,55802241.661033794]
["2010-05-01",51133107,168,19,31,1,135.58000000000001,320,32906,52588902.861191764]
["2010-06-01",47900766,87.8,5.3,30,0,135.94,352,32935,48740987.252579041]
["2010-07-01",53067071,6.7,58.5,31,0,135.30000000000001,336,32948,52049263.348237425]
["2010-08-01",53169361,32.700000000000003,78.599999999999994,31,0,136.65,336,32962,55018949.522189841]
["2010-09-01",48479950,171.8,0,30,1,137.01,336,32989,49219434.78167288]
["2010-10-01",54414298,315.5,0,31,1,137.37,320,33019,57022370.703085124]
["2010-11-01",63109939,476,0,30,1,137.72999999999999,336,33077,62019514.749880992]
["2010-12-01",78427591,770.2,0,31,0,138.1,368,33118,78716679.817166626]
["2011-01-01",83643833,935,0,31,0,138.35,336,33040,{"$f":"$N$18+C99*$N$19+D99*$N$20+E99*$N$21+F99*$N$22","v":85651108.412698165}]
["2011-02-01",72687185,732.3,0,28,0,138.6,304,33045,71852880.085472375]
["2011-03-01",72688244,699.2,0,31,1,138.85,368,33047,73167639.223142505]
["2011-04-01",60902854,444.6,0,30,1,139.1,320,33047,60698270.466509081]
["2011-05-01",52597908,221.9,3.2,31,1,139.35,336,33046,53382497.453754745]
["2011-06-01",48777799,99.4,2.7,30,0,139.61000000000001,352,33056,48986467.259274006]
["2011-07-01",54638457,14,73.599999999999994,31,0,139.86000000000001,320,33071,53765511.202224098]
["2011-08-01",54146196,24.2,35.4,31,0,140.11000000000001,352,33098,50630013.774219915]
["2011-09-01",52585712,129.6,11,30,1,140.37,336,33126,48470231.615017429]
["2011-10-01",56921149,269.5,1.5,31,1,140.62,320,33143,55226764.700195096]
["2011-11-01",61640573,428.9,0,30,1,140.88,352,33199,60037648.324823134]
["2011-12-01",73819284,650.4,0,31,0,141.13,336,33248,73675754.175512016]
["2012-01-01",null,{"$f":"(C3+C15+C27+C39+C51+C63+C75+C87+C99)/9","v":866.26666666666654},{"$f":"(D3+D15+D27+D39+D51+D63+D75+D87+D99)/9","v":0},31,0,141.41999999999999,336,33248,82758957.974998727]
["2012-02-01",null,{"$f":"(C4+C16+C28+C40+C52+C64+C76+C88+C100)/9","v":764.86666666666667},{"$f":"(D4+D16+D28+D40+D52+D64+D76+D88)/8","v":0},29,0,141.72,320,33250,74979565.008198917]
["2012-03-01",null,679.92222222222222,0,31,1,142.01,352,33250,72356471.908333495]
["2012-04-01",null,414.72222222222223,2.5000000000000001E-2,30,1,142.30000000000001,320,33250,59443410.924693614]
["2012-05-01",null,243.54444444444445,5.0125000000000002,31,1,142.589,352,33250,54462385.207897604]
["2012-06-01",null,95.333333333333314,17.125,30,0,142.88999999999999,336,33250,50161441.635576293]
["2012-07-01",null,34.133333333333333,40.9,31,0,143.18,336,33250,51561227.931676954]
["2012-08-01",null,40.322222222222223,36.637500000000003,31,0,143.47999999999999,352,33250,51423881.321846046]
["2012-09-01",null,122.65555555555554,12.225,30,1,143.77000000000001,304,33250,48292337.11781399]
["2012-10-01",null,315.42222222222222,1.4625000000000001,31,1,144.07,352,33250,57155573.40647652]
["2012-11-01",null,475.81111111111113,0,30,1,144.37,352,33250,62011566.712790646]
["2012-12-01",null,723.66666666666652,0,31,0,144.66,304,33250,76758657.503379792]
["2013-01-01",null,866.26666666666654,0,31,0,141.41999999999999,336,33250,82758957.974998727]
["2013-02-01",null,764.86666666666667,0,29,0,141.72,320,33250,74979565.008198917]
["2013-03-01",null,679.92222222222222,0,31,1,142.01,352,33250,72356471.908333495]
["2013-04-01",null,414.72222222222223,2.5000000000000001E-2,30,1,142.30000000000001,320,33250,59443410.924693614]
["2013-05-01",null,243.54444444444445,5.0125000000000002,31,1,142.589,352,33250,54462385.207897604]
["2013-06-01",null,95.333333333333314,17.125,30,0,142.88999999999999,336,33250,50161441.635576293]
["2013-07-01",null,34.133333333333333,40.9,31,0,143.18,336,33250,51561227.931676954]
["2013-08-01",null,40.322222222222223,36.637500000000003,31,0,143.47999999999999,352,33250,51423881.321846046]
["2013-09-01",null,122.65555555555554,12.225,30,1,143.77000000000001,304,33250,48292337.11781399]
["2013-10-01",null,315.42222222222222,1.4624999999999999,31,1,144.07,352,33250,57155573.40647652]
["2013-11-01",null,475.81111111111113,0,30,1,144.37,352,33250,62011566.712790646]
["2013-12-01",null,723.66666666666652,0,31,0,144.66,304,33250,76758657.503379792]
[null,null,null,0]
[null,null,null,0,null,null,null,null,null,{"$f":"SUM(J3:J134)","v":8144033392.3073616}]
[]
[2003,{"$f":"SUM(B3:B14)","v":755126020},null,null,null,null,null,null,null,{"$f":"SUM(J3:J14)","v":752186605.21913576},{"$f":"J138-B138","v":-2939414.7808642387},{"$f":"K138/B138","v":-3.8926148788572252E-3}]
[2004,{"$f":"SUM(B15:B26)","v":757685752},null,null,null,null,null,null,null,{"$f":"SUM(J15:J26)","v":747941288.96245909},-9744463.0375409126,-1.2860823912577563E-2]
[2005,{"$f":"SUM(B27:B38)","v":749219032},null,null,null,null,null,null,null,{"$f":"SUM(J27:J38)","v":742744459.91069782},-6474572.0893021822,-8.6417613711956293E-3]
[2006,{"$f":"SUM(B39:B50)","v":728093333},null,null,null,null,null,null,null,{"$f":"SUM(J39:J50)","v":722674602.90568328},-5418730.094316721,-7.4423564242645261E-3]
[2007,{"$f":"SUM(B51:B62)","v":738093576},null,null,null,null,null,null,null,{"$f":"SUM(J51:J62)","v":739500414.14077866},1406838.1407786608,1.9060430635405785E-3]
[2008,{"$f":"SUM(B63:B74)","v":740966486},null,null,null,null,null,null,null,{"$f":"SUM(J63:J74)","v":748042539.6468122},7076053.6468122005,9.5497620749505803E-3]
[2009,{"$f":"SUM(B75:B86)","v":732869984},null,null,null,null,null,null,null,{"$f":"SUM(J75:J86)","v":745709117.88939667},12839133.889396667,1.7518979040894472E-2]
[2010,{"$f":"SUM(B87:B98)","v":714199062},null,null,null,null,null,null,null,{"$f":"SUM(J87:J98)","v":726958623.63219404},12759561.632194042,1.786555361255017E-2]
[2011,{"$f":"SUM(B99:B110)","v":745049194},null,null,null,null,null,null,null,{"$f":"SUM(J99:J110)","v":735544786.69284248},-9504407.3071575165,-1.2756751344338098E-2]
[2012,null,null,null,null,null,null,null,null,{"$f":"SUM(J111:J122)","v":741365476.65368259}]
[2013,null,null,null,null,null,null,null,null,{"$f":"SUM(J123:J134)","v":741365476.65368259}]
[]
["Total to 2011",{"$f":"SUM(B138:B147)","v":6661302439},null,null,null,null,null,null,null,{"$f":"SUM(J138:J146)","v":6661302439},{"$f":"J150-B150","v":0}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J138:J148)","v":8144033392.3073654},{"$f":"J136-J152","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Check totals above sould be zero"]
["10 Year Average"]
["Forecast"]
[]
["2013-01-01",null,850.3,0,31,0,null,336,33250,82087115.075067565]
["2013-02-01",null,753.11,0,29,0,null,320,33250,74484869.829063803]
["2013-03-01",null,684.1,0,31,1,null,352,33250,72532263.787508249]
["2013-04-01",null,416.98,0.25,30,1,null,320,33250,59559409.563663915]
["2013-05-01",null,240.59,4.33,31,1,null,352,33250,54274380.02571781]
["2013-06-01",null,92.57,17.329999999999998,30,0,null,336,33250,50064296.416829325]
["2013-07-01",null,31.44,50.34,31,0,null,336,33250,52328806.312864758]
["2013-08-01",null,38.130000000000003,37.68,31,0,null,352,33250,51428919.820551127]
["2013-09-01",null,119.38,14.48,30,1,null,304,33250,48364937.57829313]
["2013-10-01",null,324.86,1.4,31,1,null,352,33250,57546862.458937526]
["2013-11-01",null,485.67,0,30,1,null,352,33250,62426407.495747447]
["2013-12-01",null,719.95,0,31,0,null,304,33250,76602268.185337365]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J157:J169)","v":741700536.549582}]
["20 Year Trend "]
["Forecast"]
[]
["2013-01-01",null,845.92714285714283,0,31,0,null,336,33250,81903114.676914632]
["2013-02-01",null,734.42142857142835,0,29,0,null,320,33250,73698495.046758458]
["2013-03-01",null,657.74714285714253,0,31,1,null,352,33250,71423392.390994966]
["2013-04-01",null,406.82857142857154,0.16571428571428548,30,1,null,320,33250,59124394.091398872]
["2013-05-01",null,241.79571428571398,5.908571428571463,31,1,null,352,33250,54472420.690087453]
["2013-06-01",null,94.508571428571486,15.349999999999909,30,0,null,336,33250,49961100.593241796]
["2013-07-01",null,24.521428571428714,55.734285714285761,31,0,null,336,33250,52541063.770157807]
["2013-08-01",null,33.771428571428601,40.234285714285718,31,0,null,352,33250,51483877.612921938]
["2013-09-01",null,114.70330857142835,14.177142857142826,30,1,null,304,33250,48139890.911103137]
["2013-10-01",null,301.35714285714312,1.551428571428545,31,1,null,352,33250,56572043.704938449]
["2013-11-01",null,445.25428571428529,0,30,1,null,352,33250,60725801.398346394]
["2013-12-01",null,721.22142857142865,0,31,0,null,304,33250,76655767.157685012]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J174:J186)","v":736701362.04454899}]

{"sheet":"Rate Class Energy Model","index":2,"n_rows":71,"n_cols":15,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Purchases","Modeled Purchases","Difference","% Difference","Loss Factor","Total Billed","Residential","General Service < 50","General Service  >50","USL","Sentinel Lights","Street Lights","total"]
[]
[null,"Weatther Normal Projection"]
[]
[]
[]
[{"$f":"'Purchased Power Model '!A138","v":2003},{"$f":"'Purchased Power Model '!B138","v":755126020},{"$f":"'Purchased Power Model '!J138","v":752186605.21913576},{"$f":"C8-B8","v":-2939414.7808642387},{"$f":"D8/B8","v":-3.8926148788572252E-3},{"$f":"1 +(B8-G8)/G8","v":1.0498270745113163},{"$f":"SUM(H8:M8)","v":719286098},351037890,{"$f":"99097471-2081552-851637","v":96164282},263763186,851637,276562,7192541,{"$f":"SUM(H8:M8)","v":719286098}]
[{"$f":"'Purchased Power Model '!A139","v":2004},{"$f":"'Purchased Power Model '!B139","v":757685752},{"$f":"'Purchased Power Model '!J139","v":747941288.96245909},-9744463.0375409126,-1.2860823912577563E-2,1.0417672113986574,727308120,356490492,95721847,266586772,842654,291228,7375127,{"$f":"SUM(H9:M9)","v":727308120}]
[{"$f":"'Purchased Power Model '!A140","v":2005},{"$f":"'Purchased Power Model '!B140","v":749219032},{"$f":"'Purchased Power Model '!J140","v":742744459.91069782},-6474572.0893021822,-8.6417613711956293E-3,1.043794563850647,717783995,347274259,{"$f":"96437449-845827","v":95591622},{"$f":"265671754+400000","v":266071754},845827,281406,{"$f":"8119127-400000","v":7719127},717783995]
[{"$f":"'Purchased Power Model '!A141","v":2006},{"$f":"'Purchased Power Model '!B141","v":728093333},{"$f":"'Purchased Power Model '!J141","v":722674602.90568328},-5418730.094316721,-7.4423564242645261E-3,1.0443992487285263,697140805,335395539,{"$f":"87627026-856153","v":86770873},266238407,856153,274009,7605824,697140805]
[{"$f":"'Purchased Power Model '!A142","v":2007},{"$f":"'Purchased Power Model '!B142","v":738093576},{"$f":"'Purchased Power Model '!J142","v":739500414.14077866},1406838.1407786608,1.9060430635405785E-3,1.0517138274108369,701800772,338874337,{"$f":"95089450-863982","v":94225468},259930403,863982,269054,7637528,701800772]
[{"$f":"'Purchased Power Model '!A143","v":2008},{"$f":"'Purchased Power Model '!B143","v":740966486},{"$f":"'Purchased Power Model '!J143","v":748042539.6468122},7076053.6468122005,9.5497620749505803E-3,1.0425888821121767,710698626,347363230,{"$f":"94322483-848325","v":93474158},261123945,848325,268763,7620205,710698626]
[{"$f":"'Purchased Power Model '!A144","v":2009},{"$f":"'Purchased Power Model '!B144","v":732869984},{"$f":"'Purchased Power Model '!J144","v":745709117.88939667},12839133.889396667,1.7518979040894472E-2,1.0354829336126383,707756700,348619359,91450221,258998141,823448,262522,7603009,707756700]
[{"$f":"'Purchased Power Model '!A145","v":2010},{"$f":"'Purchased Power Model '!B145","v":714199062},{"$f":"'Purchased Power Model '!J145","v":726958623.63219404},{"$f":"C15-B15","v":12759561.632194042},{"$f":"D15/B15","v":1.786555361255017E-2},1.0445204387280596,683757862,326493714,91377364,257036820,837229,258147,7754588,683757862]
[{"$f":"'Purchased Power Model '!A146","v":2011},{"$f":"'Purchased Power Model '!B146","v":745049194},{"$f":"'Purchased Power Model '!J146","v":735544786.69284248},{"$f":"C16-B16","v":-9504407.3071575165},{"$f":"D16/B16","v":-1.2756751344338098E-2},1.0465217405234657,711929017,345282279,101728299,255968368,874873,260362,7814836,711929017]
[{"$f":"'Purchased Power Model '!A147","v":2012},null,{"$f":"'Purchased Power Model '!J147","v":741365476.65368259},null,null,null,{"$f":"C17/$F$19","v":709771502.85075724}]
[2013,null,{"$f":"'Purchased Power Model '!J148","v":741365476.65368259},null,null,null,{"$f":"C18/$F$19","v":709771502.85075724}]
["Average",null,null,null,null,{"$f":"(F8+F9+F10+F11+F12+F13+F14+F15+F16)/9","v":1.0445128800973693}]
[]
[]
["Usage Per Customer"]
[]
[]
[{"$f":"A8","v":2003},null,null,null,null,null,null,{"$f":"H8/'Rate Class Customer Model'!B3","v":12298.132357062781},{"$f":"I8/'Rate Class Customer Model'!C3","v":29772.223529411764},{"$f":"J8/'Rate Class Customer Model'!D3","v":629506.41050119337},{"$f":"K8/'Rate Class Customer Model'!E3","v":70969.75},{"$f":"L8/'Rate Class Customer Model'!F3","v":593.48068669527902},{"$f":"M8/'Rate Class Customer Model'!G3","v":834.49831767026342}]
[2004,null,null,null,null,null,null,{"$f":"H9/'Rate Class Customer Model'!B4","v":12482.160084033614},{"$f":"I9/'Rate Class Customer Model'!C4","v":29480.088389282413},{"$f":"J9/'Rate Class Customer Model'!D4","v":628742.38679245277},{"$f":"K9/'Rate Class Customer Model'!E4","v":44350.210526315786},{"$f":"L9/'Rate Class Customer Model'!F4","v":624.95278969957087},{"$f":"M9/'Rate Class Customer Model'!G4","v":854.09693109438331}]
[2005,null,null,null,null,null,null,{"$f":"H10/'Rate Class Customer Model'!B5","v":12152.654640257559},{"$f":"I10/'Rate Class Customer Model'!C5","v":29197.196701282835},{"$f":"J10/'Rate Class Customer Model'!D5","v":617335.85614849185},{"$f":"K10/'Rate Class Customer Model'!E5","v":31326.925925925927},{"$f":"L10/'Rate Class Customer Model'!F5","v":613.0849673202614},{"$f":"M10/'Rate Class Customer Model'!G5","v":893.2107151122425}]
[2006,null,null,null,null,null,null,{"$f":"H11/'Rate Class Customer Model'!B6","v":11728.757133864876},{"$f":"I11/'Rate Class Customer Model'!C6","v":26286.238412602241},{"$f":"J11/'Rate Class Customer Model'!D6","v":616292.60879629629},{"$f":"K11/'Rate Class Customer Model'!E6","v":30576.892857142859},{"$f":"L11/'Rate Class Customer Model'!F6","v":610.26503340757233},{"$f":"M11/'Rate Class Customer Model'!G6","v":877.96652429874177}]
[2007,null,null,null,null,null,null,{"$f":"H12/'Rate Class Customer Model'!B7","v":11836.337303527767},{"$f":"I12/'Rate Class Customer Model'!C7","v":28535.877649909147},{"$f":"J12/'Rate Class Customer Model'!D7","v":605898.37529137533},{"$f":"K12/'Rate Class Customer Model'!E7","v":31999.333333333332},{"$f":"L12/'Rate Class Customer Model'!F7","v":607.34537246049661},{"$f":"M12/'Rate Class Customer Model'!G7","v":877.17101182956242}]
[2008,null,null,null,null,null,null,{"$f":"H13/'Rate Class Customer Model'!B8","v":12069.604933981931},{"$f":"I13/'Rate Class Customer Model'!C8","v":28112.528721804512},{"$f":"J13/'Rate Class Customer Model'!D8","v":612967.00704225351},{"$f":"K13/'Rate Class Customer Model'!E8","v":38560.227272727272},{"$f":"L13/'Rate Class Customer Model'!F8","v":617.84597701149426},{"$f":"M13/'Rate Class Customer Model'!G8","v":871.77725660679562}]
[2009,null,null,null,null,null,null,{"$f":"H14/'Rate Class Customer Model'!B9","v":12033.390597494046},{"$f":"I14/'Rate Class Customer Model'!C9","v":27282.285501193317},{"$f":"J14/'Rate Class Customer Model'!D9","v":598148.13163972285},{"$f":"K14/'Rate Class Customer Model'!E9","v":48438.117647058825},{"$f":"L14/'Rate Class Customer Model'!F9","v":620.61938534278954},{"$f":"M14/'Rate Class Customer Model'!G9","v":864.07648596431409}]
[2010,null,null,null,null,null,null,{"$f":"H15/'Rate Class Customer Model'!B10","v":11236.318752796227},{"$f":"I15/'Rate Class Customer Model'!C10","v":27317.597608370703},{"$f":"J15/'Rate Class Customer Model'!D10","v":590889.24137931038},{"$f":"K15/'Rate Class Customer Model'!E10","v":52326.8125},{"$f":"L15/'Rate Class Customer Model'!F10","v":628.09489051094886},{"$f":"M15/'Rate Class Customer Model'!G10","v":876.62084557992318}]
[{"$f":"A16","v":2011},null,null,null,null,null,null,{"$f":"H16/'Rate Class Customer Model'!B11","v":11855.592604037907},{"$f":"I16/'Rate Class Customer Model'!C11","v":30222.311051693403},{"$f":"J16/'Rate Class Customer Model'!D11","v":635157.2406947891},{"$f":"K16/'Rate Class Customer Model'!E11","v":46045.947368421053},{"$f":"L16/'Rate Class Customer Model'!F11","v":647.66666666666663},{"$f":"M16/'Rate Class Customer Model'!G11","v":883.43160750621746}]
[2012,null,null,null,null,null,null,{"$f":"H33*H51","v":11801.406779356614},30279.048323746065,635867.15179049969,43622.060919721218,654.77888388031863,889.74666109614816]
[2013,null,null,null,null,null,null,{"$f":"H34*H53","v":11747.468610249736},30335.892110420802,636577.85634920106,41325.769315996164,661.96920243266459,896.1068567225476]
[]
[]
[]
[]
[]
[2003]
[2004,null,null,null,null,null,null,{"$f":"H26/H25","v":1.0149638759469966},0.99018766133336489,0.99878631306052579,{"$f":"K26/K25","v":0.62491710237553022},1.0530297003926787,1.0234855038160351]
[2005,null,null,null,null,null,null,0.97360188929177904,0.99040397422612803,0.98185818089638954,0.70635348861168723,0.98101004975909523,1.0457954859616945]
[2006,null,null,null,null,null,null,0.96511893747161581,0.9003000761181742,0.99831008138956279,0.97605787843478298,0.99540041908870358,0.98293326473184428]
[2007,null,null,null,null,null,null,{"$f":"H29/H28","v":1.0091723418291501},1.0855823949397179,0.98313425577953573,1.0465201118647407,0.99521574924459777,0.99909391480522025]
[2008,null,null,null,null,null,null,1.0197077545588904,0.9851643277526464,1.0116663652505733,1.2050322071103754,1.0172893464363733,0.9938509650341536]
[2009,null,null,null,null,null,null,{"$f":"H31/H30","v":0.99699954251311707},0.9704671454913536,0.97582435068726436,1.2561678463269315,1.0044888344902887,0.99116658460160445]
[2010,null,null,null,null,null,null,{"$f":"H32/H31","v":0.93376165776054765},1.001294323643664,0.98786439365694678,1.0802817087417784,1.012045233108583,1.0145176495592396]
[2011,null,null,null,null,null,null,1.0551135887888166,1.1063312186146499,1.0749175923598544,0.87996851267065146,1.0311605403123028,1.0077693360369371]
[]
["Used ",null,null,null,null,null,null,{"$f":"H53","v":0.99542951360669751},1.0018773306897548,1.0011176934626991,0.94735939670638269,1.0109812926613257,1.0071483219937727]
[]
["Geomean ",null,null,null,null,null,null,{"$f":"GEOMEAN(H42:H49)","v":0.99542951360669751},1.0018773306897548,1.0011176934626991,0.94735939670638269,1.0109812926613257,1.0071483219937727]
[]
["Non Weather Corrected Forecast"]
[2012,null,null,null,null,null,{"$f":"SUM(H56:N56)","v":711058457.355793},{"$f":"H34*'Rate Class Customer Model'!B12","v":344569494.91530514},{"$f":"I34*'Rate Class Customer Model'!C12","v":102446064.94784082},{"$f":"J34*'Rate Class Customer Model'!D12","v":255010354.16597891},{"$f":"K34*'Rate Class Customer Model'!E12","v":877821.72570468241},{"$f":"L34*'Rate Class Customer Model'!F12","v":258404.89448335613},{"$f":"M34*'Rate Class Customer Model'!G12","v":7896316.7064801157}]
[2013,null,null,null,null,null,{"$f":"SUM(H57:N57)","v":710198893.26463282},{"$f":"H35*'Rate Class Customer Model'!B13","v":343858182.267699},{"$f":"I35*'Rate Class Customer Model'!C13","v":103168895.24808843},{"$f":"J35*'Rate Class Customer Model'!D13","v":254055925.89416358},{"$f":"K35*'Rate Class Customer Model'!E13","v":880780.38997562672},{"$f":"L35*'Rate Class Customer Model'!F13","v":256462.50026099975},{"$f":"M35*'Rate Class Customer Model'!G13","v":7978646.9644451877}]
[]
["Weather Corrected Forecast",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total "]
[2012,null,null,null,null,null,{"$f":"G17","v":709771502.85075724},{"$f":"H56+H68","v":343919087.115538},{"$f":"I56+I68","v":102252688.22505838},{"$f":"J56+J68","v":254567184.18349275},877821.72570468241,258404.89448335613,7896316.7064801157,null,{"$f":"SUM(H60:N60)","v":709771502.85075724}]
[2013,null,null,null,null,null,{"$f":"G18","v":709771502.85075724},{"$f":"H57+H69-H71","v":340262683.67096764},{"$f":"I57+I69-I71","v":102090126.04258485},{"$f":"J57+J69-J71","v":251412080.47687784},872123.47846807283,253941.81156829742,7900227.3702905914,null,{"$f":"SUM(H61:N61)-2","v":702791180.85075724}]
[]
["% Weather Sensitive",null,null,null,null,null,null,{"$f":"(100%+J63)/2","v":0.92649999999999999},{"$f":"H63","v":0.92649999999999999},0.85299999999999998,null,null,null,null,"Total "]
[2012,null,null,null,null,null,{"$f":"G60-G56","v":-1286954.505035758},{"$f":"H56*H63","v":319243637.03903019},94916279.174174517,217523832.10358,0,0,0,0,{"$f":"SUM(H64:N64)","v":631683748.31678474}]
[2013,null,null,null,null,null,{"$f":"G61-G57","v":-427390.41387557983},{"$f":"H57*H63","v":318584605.87102312},95585981.447353929,216709704.78772151,0,0,0,0,{"$f":"SUM(H65:N65)","v":630880292.10609853}]
[]
["Allocation of Weather Sensitive Amount"]
[2012,null,null,null,null,null,null,{"$f":"H64/$O$64*$G$64","v":-650407.79976714076},-193376.72278245285,-443169.98248616431,0,0,0,0,{"$f":"SUM(H68:N68)","v":-1286954.505035758}]
[2013,null,null,null,null,null,null,{"$f":"H65/$O$65*$G$65","v":-215825.42403259329},{"$f":"I65/$O$65*$G$65","v":-64754.807976499127},-146810.1818664874,0,0,0,0,{"$f":"SUM(H69:N69)","v":-427390.41387557983}]
[]
[null,null,null,null,null,"CDM Target",6980320,{"$f":"(H57/$G$57)*$G$71","v":3379673.1726988093},1014014.3975270814,2497035.2354192566,8656.9115075539321,2520.6886927023202,78419.594154596401,{"$f":"(N57/M57)*$G$71","v":0},{"$f":"SUM(H71:N71)","v":6980320}]

{"sheet":"Rate Class Customer Model","index":3,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
["Year",{"$f":"'Rate Class Energy Model'!H2","v":"Residential"},{"$f":"'Rate Class Energy Model'!I2","v":"General Service < 50"},{"$f":"'Rate Class Energy Model'!J2","v":"General Service  >50"},{"$f":"'Rate Class Energy Model'!K2","v":"USL"},{"$f":"'Rate Class Energy Model'!L2","v":"Sentinel Lights"},{"$f":"'Rate Class Energy Model'!M2","v":"Street Lights"},null,"Total"]
[2003,28544,3230,419,12,466,8619,null,{"$f":"SUM(B3:G3)","v":41290}]
[2004,28560,3247,424,19,466,8635,null,{"$f":"SUM(B4:G4)","v":41351}]
[2005,28576,3274,431,27,459,8642,null,41409]
[2006,28596,3301,432,28,449,8663,null,41469]
[2007,28630,3302,429,27,443,8707,null,41538]
[2008,28780,3325,426,22,435,8741,null,41729]
[2009,28971,3352,433,17,423,8799,null,41995]
[2010,29057,3345,435,16,411,8846,null,42110]
[2011,29124,3366,403,19,402,8846,null,{"$f":"SUM(B11:H11)-0.5","v":42159.5}]
[2012,{"$f":"B11*B29","v":29197.323790078721},{"$f":"C11*C29","v":3383.3977822710644},{"$f":"D11*D29","v":401.04344665062621},{"$f":"E11*E31","v":20.123343720970908},{"$f":"F11*F31","v":394.64451411751349},{"$f":"G11*G31","v":8874.7921759571745},null,{"$f":"SUM(B12:H12)-0.5","v":42270.825052796077}]
[2013,{"$f":"B12*B29","v":29270.832183171846},3400.8854881392622,399.09639231120019,21.313103290123117,387.4236132414137,8903.6780653889527,null,{"$f":"SUM(B13:H13)-0.5","v":42382.728845542799}]
[]
[]
["Year","Residential","General Service < 50","General Service  >50","USL","Sentinel Lights","Street Lights"]
[]
[]
["Growth Rate in Customer Numbers "]
[2004,{"$f":"B4/B3","v":1.0005605381165918},1.0052631578947369,1.0119331742243436,{"$f":"E4/E3","v":1.5833333333333333},1,{"$f":"G4/G3","v":1.0018563638473141}]
[2005,1.0005602240896359,1.0083153680320296,1.0165094339622642,1.4210526315789473,0.98497854077253222,1.0008106543138391]
[2006,1.0006998880179172,1.0082467929138668,1.0023201856148491,1.037037037037037,0.97821350762527237,1.0024299930571627]
[2007,1.0011889774793676,1.0003029385034838,0.99305555555555558,0.9642857142857143,0.98663697104677062,1.0050790719150411]
[2008,1.0052392595179882,1.0069654754694124,0.99300699300699302,0.81481481481481477,0.98194130925507905,1.0039049041001493]
[2009,1.0066365531619179,1.0081203007518797,1.016431924882629,0.77272727272727271,0.97241379310344822,1.0066353964077337]
[2010,1.0029684857271064,0.99791169451073991,1.0046189376443417,0.94117647058823528,0.97163120567375882,1.0053415160813728]
[2011,1.0023058127129436,1.0062780269058296,0.9264367816091954,1.1875,0.97810218978102192,1]
[]
["Geomean",{"$f":"B31","v":1.0025176414667876},1.0051686816016234,0.99514502890974244,1.0591233537353109,0.98170277143660067,1.0032548243225383]
[]
["Used",{"$f":"GEOMEAN(B20:B27)","v":1.0025176414667876},1.0051686816016234,0.99514502890974244,1.0591233537353109,0.98170277143660067,1.0032548243225383]

{"sheet":"Rate Class Load Model","index":4,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Year",{"$f":"'Rate Class Customer Model'!D2","v":"General Service  >50"},{"$f":"'Rate Class Customer Model'!F2","v":"Sentinel Lights"},{"$f":"'Rate Class Customer Model'!G2","v":"Street Lights"},"Total"]
[2003,659827,768,21295,{"$f":"SUM(B2:D2)","v":681890}]
[2004,673069,873,21340,695282]
[2005,682195,784,21295,704274]
[2006,657827,766,23029,681622]
[2007,657184,747,21406,679337]
[2008,650699,744,21317,672760]
[2009,637622,730,21346,659698]
[2010,635103.80000000005,714,23263.8,659081.60000000009]
[2011,629024,703,21619,651346]
[2012,{"$f":"B29*'Rate Class Energy Model'!J60","v":635612.46844419092},{"$f":"C29*'Rate Class Energy Model'!L60","v":722.02487751704996},{"$f":"D29*'Rate Class Energy Model'!M60","v":22649.190582967494},658983.68390467542]
[2013,{"$f":"B29*'Rate Class Energy Model'!J61","v":627734.69243943528},{"$f":"C29*'Rate Class Energy Model'!L61","v":709.55430531083641},{"$f":"D29*'Rate Class Energy Model'!M61","v":22660.407631781745},{"$f":"SUM(B12:D12)","v":651104.65437652788}]
[]
["kW/kWh"]
[1999]
[2000]
[2001]
[2002]
[2003,{"$f":"B2/'Rate Class Energy Model'!J8","v":2.5015886788689306E-3},{"$f":"C2/'Rate Class Energy Model'!L8","v":2.7769541730244935E-3},{"$f":"D2/'Rate Class Energy Model'!M8","v":2.9607060981647515E-3}]
[2004,{"$f":"B3/'Rate Class Energy Model'!J9","v":2.5247651822724346E-3},{"$f":"C3/'Rate Class Energy Model'!L9","v":2.9976513247352591E-3},{"$f":"D3/'Rate Class Energy Model'!M9","v":2.8935094948195467E-3}]
[2005,{"$f":"B4/'Rate Class Energy Model'!J10","v":2.563951226480057E-3},{"$f":"C4/'Rate Class Energy Model'!L10","v":2.7860102485377002E-3},{"$f":"D4/'Rate Class Energy Model'!M10","v":2.7587316544992716E-3}]
[2006,{"$f":"B5/'Rate Class Energy Model'!J11","v":2.4708193209704715E-3},{"$f":"C5/'Rate Class Energy Model'!L11","v":2.7955286140236269E-3},{"$f":"D5/'Rate Class Energy Model'!M11","v":3.0278113193258219E-3}]
[2007,{"$f":"B6/'Rate Class Energy Model'!J12","v":2.5283075485402146E-3},{"$f":"C6/'Rate Class Energy Model'!L12","v":2.7763943297627984E-3},{"$f":"D6/'Rate Class Energy Model'!M12","v":2.8027393156529181E-3}]
[2008,{"$f":"B7/'Rate Class Energy Model'!J13","v":2.4919162430699338E-3},{"$f":"C7/'Rate Class Energy Model'!L13","v":2.7682381875481373E-3},{"$f":"D7/'Rate Class Energy Model'!M13","v":2.797431302701174E-3}]
[2009,{"$f":"B8/'Rate Class Energy Model'!J14","v":2.4618786742565848E-3},{"$f":"C8/'Rate Class Energy Model'!L14","v":2.78071933018947E-3},{"$f":"D8/'Rate Class Energy Model'!M14","v":2.8075726334139549E-3}]
[2010,{"$f":"B9/'Rate Class Energy Model'!J15","v":2.470867014305577E-3},{"$f":"C9/'Rate Class Energy Model'!L15","v":2.7658659600925052E-3},{"$f":"D9/'Rate Class Energy Model'!M15","v":3.0000046424129819E-3}]
[2011,{"$f":"B10/'Rate Class Energy Model'!J16","v":2.4574286460270749E-3},{"$f":"C10/'Rate Class Energy Model'!L16","v":2.7000868022215223E-3},{"$f":"D10/'Rate Class Energy Model'!M16","v":2.7664048228267361E-3}]
[]
["Average",{"$f":"AVERAGE(B19:B27)","v":2.4968358371990304E-3},{"$f":"AVERAGE(C19:C27)","v":2.7941609966817237E-3},{"$f":"AVERAGE(D19:D27)","v":2.8683234759796839E-3}]