{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Rate Design"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":11,"defined_names":146,"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":"Rate Design","index":0,"n_rows":37,"n_cols":32,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,28,1,31],[15,26,15,27],[15,28,15,29],[27,2,27,3],[27,4,27,5],[27,6,27,7],[27,9,27,10],[27,11,28,11],[27,18,28,18],[1,9,1,10],[1,12,1,13],[1,15,1,16],[1,23,1,24],[15,2,15,10],[15,11,15,16],[15,18,15,24]]}
[]
[null,null,"Rev @ Existing","Misc Rev","Rev. Status Quo","Total Rev Status Quo","Rev Req","R/E",null,"1st Est",null,"Surplus/ Shortfall","After 1st Est",null,"Surplus/ Shortfall","2nd Est",null,null,null,null,null,null,null,"Range",null,null,null,null,"2024 (No Change)"]
[null,"CA 'O1' Row Reference:",18,19,23,25,40,47,null,"Adj. %","Adj. RevReq",null,"Adj. %","Adj. RevReq",null,"Adj. %","Adj. RevReq",null,"Share %","RevReq - Misc","Share %",null,null,"Min","Max",null,"Avg. Rate Increase",null,"RevReq - Misc","With Misc.","R/E","2024 Impact"]
[null,"Residential",14373803.879999992,1606237.9946579733,16024850.778474385,{"$f":"D4+E4","v":17631088.773132358},17410755.463755529,{"$f":"F4/G4","v":1.0126550114287403},null,{"$f":"IF(H4>Y4,Y4,IF(H4<X4,X4,H4))","v":1.0126550114287403},{"$f":"G4*J4","v":17631088.773132358},null,{"$f":"IF((IF(L$12>0,IF(J4=K$13,L$13,J4),IF(J4=K$14,L$14,J4))*G4-K4)>L10,(K4+$L$12)/G4,IF(L$12>0,IF(J4=K$13,L$13,J4),IF(J4=K$14,L$14,J4)))","v":1.0126550114287403},{"$f":"G4*M4","v":17631088.773132358},null,{"$f":"IF(ROUND($O$12,0)=0,M4,IF(O$12>0,IF(M4=N$13,O$13,M4),IF(M4=N$14,O$14,M4)))","v":1.0126550114287403},{"$f":"G4*P4","v":17631088.773132358},{"$f":"Q4/G4","v":1.0126550114287403},{"$f":"Q4/$Q$12","v":0.70076865625350215},{"$f":"Q4-D4","v":16024850.778474385},{"$f":"T4/$T$12","v":0.69857965957660417},null,null,0.85,1.1499999999999999,null,{"$f":"T4/C4-1","v":0.11486499414199569},null,{"$f":"Q4-D4","v":16024850.778474385},{"$f":"AC4+D4","v":17631088.773132358},{"$f":"AD4/G4","v":1.0126550114287403},{"$f":"AC4/T4-1","v":0}]
[null,"GS <50",2399831.891760136,234573.31440213893,2675488.5679489383,2910061.8823510772,2988198.5840503885,0.97385156993368227,null,0.97385156993368227,2910061.8823510772,null,{"$f":"IF((IF(L$12>0,IF(J5=K$13,L$13,J5),IF(J5=K$14,L$14,J5))*G5-K5)>L11,(K5+$L$12)/G5,IF(L$12>0,IF(J5=K$13,L$13,J5),IF(J5=K$14,L$14,J5)))","v":0.97385156993368227},2910061.8823510772,null,0.97385156993368227,{"$f":"G5*P5","v":2910061.8823510772},0.97385156993368227,0.11566388106543467,2675488.5679489383,0.11663396550996179,null,null,0.8,1.2,null,0.11486499414199569,null,{"$f":"Q5-D5","v":2675488.5679489383},2910061.8823510772,0.97385156993368227,0]
[null,"GS 50 to 999 kW",2376296.2133624507,235716.73768442232,2649249.4639899749,2884966.2016743971,3114134.3482802594,0.92641032114352506,null,0.92641032114352506,2884966.2016743971,null,{"$f":"J6","v":0.92641032114352506},2884966.2016743971,null,0.92641032114352506,{"$f":"G6*P6","v":2884966.2016743971},0.92641032114352506,0.11466642329910752,2649249.4639899749,0.11549011059582617,null,null,0.8,1.2,null,0.11486499414199569,null,{"$f":"Q6-D6","v":2649249.4639899749},2884966.2016743971,0.92641032114352506,0]
[null,"GS 1,000 to 4,999 kW",555080.97615262668,46002.331960696451,618840.34922673134,664842.68118742784,564486.79086462944,1.1777825308703547,null,1.1777825308703547,664842.68118742784,null,{"$f":"IF((IF(L$12>0,IF(J7=K$13,L$13,J7),IF(J7=K$14,L$14,J7))*G7-K7)>L13,(K7+$L$12)/G7,IF(L$12>0,IF(J7=K$13,L$13,J7),IF(J7=K$14,L$14,J7)))","v":1.1760178267182413},663846.52900377591,null,1.1760178267182413,{"$f":"G7*P7","v":663846.52900377591},1.1760178267182413,2.6385372229390639E-2,617844.19704307942,2.6934003617775076E-2,null,null,0.8,1.2,null,0.11307038718112206,null,{"$f":"Q7-D7-Q15","v":617844.19704307942},663846.52900377591,1.1760178267182413,0]
[null,"Large Use >5MW",535442.96157833107,58046.300294473149,596946.61422339885,654992.91451787204,675063.94540621771,0.97026795605819538,null,0.97026795605819538,654992.91451787204,null,{"$f":"IF((IF(L$12>0,IF(J8=K$13,L$13,J8),IF(J8=K$14,L$14,J8))*G8-K8)>L14,(K8+$L$12)/G8,IF(L$12>0,IF(J8=K$13,L$13,J8),IF(J8=K$14,L$14,J8)))","v":0.97026795605819538},654992.91451787204,null,0.97026795605819538,654992.91451787204,0.97026795605819538,2.6033474759750076E-2,596946.61422339885,2.6023004414477895E-2,null,null,0.85,1.1499999999999999,null,0.11486499414199569,null,{"$f":"Q8-D8","v":596946.61422339885},654992.91451787204,0.97026795605819538,0]
[null,"Street Light",260279.00092866857,29507.239936365142,290175.9468456246,319683.18678198976,302290.62877688924,1.0575358821921581,null,1.0575358821921581,319683.18678198976,null,1.0575358821921581,319683.18678198976,null,1.0575358821921581,{"$f":"G9*P9","v":319683.18678198976},1.0575358821921581,1.2706189623946405E-2,290175.9468456246,1.2649791063079962E-2,null,null,0.8,1.2,null,0.11486499414199569,null,{"$f":"Q9-D9","v":290175.9468456246},319683.18678198976,1.0575358821921581,0]
[null,"Sentinel",31731.553669601504,5287.8113485905051,35376.398395976699,40664.209744567204,52075.452410276208,0.78087098359116347,null,0.8,41660.361928220969,null,{"$f":"IF((IF(L$12>0,IF(J10=K$13,L$13,J10),IF(J10=K$14,L$14,J10))*G10-K10)>L16,(K10+$L$12)/G10,IF(L$12>0,IF(J10=K$13,L$13,J10),IF(J10=K$14,L$14,J10)))","v":0.8},41660.361928220969,null,0.8,{"$f":"G10*P10","v":41660.361928220969},0.8,1.6558407834666744E-3,36372.550579630464,1.5856075262792617E-3,null,null,0.8,1.2,null,0.14625810505065151,null,{"$f":"N10-D10","v":36372.550579630464},41660.361928220969,0.8,0]
[null,"Unmetered Scattered Load",43288.460376868898,5081.7281877116684,48260.789124473959,53342.517312185628,52637.153157692497,1.0134004996884989,null,1.0134004996884989,53342.517312185621,null,{"$f":"IF((IF(L$12>0,IF(J11=K$13,L$13,J11),IF(J11=K$14,L$14,J11))*G11-K11)>L17,(K11+$L$12)/G11,IF(L$12>0,IF(J11=K$13,L$13,J11),IF(J11=K$14,L$14,J11)))","v":1.0134004996884989},53342.517312185621,null,1.0134004996884989,{"$f":"G11*P11","v":53342.517312185621},1.0134004996884989,2.120161985401789E-3,48260.789124473951,2.1038576959955301E-3,null,null,0.8,1.2,null,0.11486499414199547,null,{"$f":"Q11-D11","v":48260.789124473951},53342.517312185621,1.0134004996884989,0]
[null,"Total",{"$f":"SUM(C4:C11)","v":20575754.937828679},{"$f":"SUM(D4:D11)","v":2220453.4584723716},{"$f":"SUM(E4:E11)","v":22939188.908229508},{"$f":"SUM(F4:F11)","v":25159642.366701879},{"$f":"SUM(G4:G11)","v":25159642.366701879},1,null,null,{"$f":"SUM(K4:K11)","v":25160638.518885531},{"$f":"G12-K12","v":-996.15218365192413},null,{"$f":"SUM(N4:N11)","v":25159642.366701879},{"$f":"G12-N12","v":0},null,{"$f":"SUM(Q4:Q11)","v":25159642.366701879},{"$f":"G12-Q12","v":0},{"$f":"SUM(S4:S11)","v":0.99999999999999989},{"$f":"SUM(T4:T11)","v":22939188.908229508},1,null,null,null,null,null,null,null,{"$f":"SUM(AC4:AC11)","v":22939188.908229508}]
[null,null,null,null,null,null,null,null,null,"Min",{"$f":"MIN(J4:J11)","v":0.8},{"$f":"LARGE(J4:J11,COUNT(J4:J11)-1)","v":0.92641032114352506},"Min",{"$f":"MIN(M4:M11)","v":0.8},0.8,"Min",{"$f":"MIN(P4:P11)","v":0.8}]
[null,null,null,null,null,null,null,null,null,"Max",{"$f":"MAX(J4:J11)","v":1.1777825308703547},1.2,"Max",{"$f":"MAX(M4:M11)","v":1.1760178267182413},1.2,"Max",{"$f":"MAX(P4:P11)","v":1.1760178267182413}]
[]
[null,null,"Status Quo Rates",null,null,null,null,null,null,null,null,"Proposed Rates (1st Est)",null,null,null,null,null,null,"Adjusted Fixed/Var. and Rates",null,null,null,null,null,null,null,"RRWF Calc.",null,"Check"]
[null,null,"LF Customers","LF Load","Fixed","Var Rate","Fix Rev","Var Rev","Total Rev","Fixed %","Var %","Fixed","Variable","TOA","1st Est. Fixed","1st Est. Var.","Maximum",null,"Fixed Rev. w/ Max","Var. Rev. w/ Max Fixed","Fixed %","Var %",null,"Fixed Rate","Var Rate",null,"Fixed","Var","Fixed","Var"]
[null,"Residential",40087.583333333314,354110615.30394888,29.88,null,{"$f":"C18*E18*12","v":14373803.879999992},{"$f":"+D18*F18-N18","v":0},{"$f":"G18+H18","v":14373803.879999992},{"$f":"G18/($I18)","v":1},{"$f":"H18/$I18","v":0},{"$f":"J18*T4","v":16024850.778474385},{"$f":"K18*T4","v":0},null,{"$f":"L18/C18/12","v":33.312166024962828},{"$f":"M18/D18","v":0},29.88,null,{"$f":"IF(R18=\"Over\",Q18*12*C18,L18)","v":16024850.778474385},null,{"$f":"(X18*C18*12)/((X18*C18*12)+T18-N18)","v":1},null,null,{"$f":"ROUND(S18/C18/12,2)","v":33.31},null,null,33.31,0,{"$f":"X18-AA18","v":0},0]
[null,"GS <50",2989.9091003503345,89710182.50447765,18.38,1.9400000000000001E-2,659454.3511732698,1740377.5405868664,2399831.891760136,0.27479189414788496,0.72520810585211515,735202.57135770097,{"$f":"K19*T5","v":1940285.9965912376},null,20.491218592329883,2.1628380886354714E-2,42.440911181339509,{"$f":"IF(O19>Q19,\"Over\",\"\")","v":""},735202.57135770097,{"$f":"T5-X19*C19*12+N19","v":1940329.7183547982},0.27477555254804237,{"$f":"T19/((X19*C19*12)+T19)","v":0.72522444745195758},null,20.49,{"$f":"ROUND(T19/D19,4)","v":2.1600000000000001E-2},null,20.49,2.1600000000000001E-2,0,0]
[null,"GS 50 to 999 kW",343.80146517608017,614051.23088848544,86.74,3.3567999999999998,357856.06907247833,2018440.1442899723,2376296.2133624507,0.15059404928567943,0.84940595071432046,398961.20435016608,{"$f":"K20*T6","v":2250288.2596398084},42807.027556495435,96.7033895918767,3.6646588207042798,86.74,"Over",357856.06907247828,2334200.4224739918,0.1350782830898527,0.86706962866633397,null,86.74,3.8012999999999999,null,86.74,3.8012999999999999,0,0]
[null,"GS 1,000 to 4,999 kW",12,244528.16159202738,682.42,2.3534000000000002,98268.479999999981,456812.49615262676,555080.9761526268,0.17703449446442526,0.82296550553557468,109379.73508130031,{"$f":"K21*T7","v":508464.46196177904},118660.07933805052,759.58149362014103,2.0793697488721361,682.42,"Over",98268.479999999981,638235.79638113,{"$f":"(X21*C21*12)/((X21*C21*12)+T21-N21)","v":0.15905058341617503},{"$f":"T21/((X21*C21*12)+T21)","v":0.86657446107054581},null,682.42,2.6101000000000001,null,682.42,2.6101000000000001,0,0]
[null,"Large Use >5MW",3,268059.23480130621,2725.12,1.6315,98104.319999999992,437338.64157833107,535442.96157833107,0.1832208601842796,0.81677913981572037,109373.07214210446,{"$f":"K22*T8+N22","v":487573.54208129441},null,3038.1408928362348,1.8189022379426658,2725.12,"Over",98104.319999999992,498842.29422339884,0.16434354038112667,0.83565645961887336,null,2725.12,1.8609,null,2725.12,1.8609,0,0]
[null,"Street Light",2919.41159236661,14179.063705514967,2.6780000000000004,11.7399,93818.210932293383,166460.78999637518,260279.00092866857,0.36045247829272625,0.63954752170727369,104594.63918144378,{"$f":"K23*T9+N23","v":185581.30766418079},null,2.9856084543122647,13.088403544727615,2.6780000000000004,"Over",93818.210932293383,196287.6700351144,0.32355637271499738,0.67644362728500251,null,2.68,13.843500000000001,null,2.68,13.843500000000001,0,0]
[null,"Sentinel",231.19110332107795,377.84475452316417,5.63,42.642600000000002,15619.270940372026,16112.282729229481,31731.553669601504,0.49223152143776444,0.50776847856223561,17903.715910383544,{"$f":"K24*T10+N24","v":18468.83466924692},null,6.4534331314351663,48.879425870432904,20.49765899927813,"",17903.715910383544,18478.359182579028,0.49196966151371935,0.50803033848628065,null,6.45,48.904600000000002,null,6.45,48.904600000000002,0,0]
[null,"Unmetered Scattered Load",222.86475388975543,1067791.2606439681,8.76,1.8599999999999998E-2,23427.542928891093,19860.917447977805,43288.460376868898,0.54119603064953437,0.45880396935046563,26118.54751017952,{"$f":"K25*T11+N25","v":22142.241614294431},null,9.7662173486838828,2.0736488891041113E-2,16.358426041394384,"",26118.54751017952,22132.125378439025,0.54140564669682512,0.45859435330317483,null,9.77,2.07E-2,null,9.77,2.07E-2,0,0]
[null,null,{"$f":"SUM(C18:C25)","v":46809.761348437176},{"$f":"SUM(D18:D25)","v":446029784.60481226},null,null,{"$f":"SUM(G18:G25)","v":15720352.125047298},{"$f":"SUM(H18:H25)","v":4855402.8127813786},{"$f":"SUM(I18:I25)","v":20575754.937828679},{"$f":"G26/$I26","v":0.76402310255675299},0.23597689744324687]
[]
[null,null,"Current Charges",null,"Proposed Charges",null,"Dx Bill Impact",null,null,"Variable with TOA",null,"Variable Change",null,null,null,null,null,null,"Weighted Var. Rate Change"]
[null,null,"Fixed Charge","Variable Charge","Fixed Charge","Variable Charge","Fixed Charge","Variable Charge",null,"Current","Proposed",null,null,null,null,"Volumes","Share","Rate Change"]
[null,{"$f":"B18","v":"Residential"},{"$f":"E18","v":29.88},0,{"$f":"X18","v":33.31},0,{"$f":"E30/C30-1","v":0.11479250334672031},null,null,null,null,null,null,"GS 50-999","With TOA",{"$f":"N20/0.6","v":71345.045927492392},{"$f":"P30/D20","v":0.11618744876426929},{"$f":"L32","v":0.16123766686012764},{"$f":"Q30*R30","v":1.8733793157181398E-2}]
[null,"GS <50",18.38,1.9400000000000001E-2,20.49,2.1600000000000001E-2,0.11479869423286182,{"$f":"F31/D31-1","v":0.11340206185567014},null,null,null,null,null,null,"Without TOA",{"$f":"D20-P30","v":542706.18496099301},{"$f":"P31/D20","v":0.88381255123573066},{"$f":"H32","v":0.13241777883698758},{"$f":"Q31*R31","v":0.11703249494288673}]
[null,"GS 50 to 999 kW",86.74,3.3567999999999998,86.74,3.8012999999999999,0,0.13241777883698758,null,{"$f":"D32-0.6","v":2.7567999999999997},{"$f":"F32-0.6","v":3.2012999999999998},{"$f":"K32/J32-1","v":0.16123766686012764},null,null,null,null,null,null,{"$f":"S30+S31","v":0.13576628810006813}]
[null,"GS 1,000 to 4,999 kW",682.42,2.3534000000000002,682.42,2.6101000000000001,0,0.10907623013512358,null,{"$f":"D33-0.6","v":1.7534000000000001},{"$f":"F33-0.6","v":2.0101},{"$f":"K33/J33-1","v":0.14640127751796506}]
[null,"Large Use >5MW",2725.12,1.6315,2725.12,1.8609,0,0.14060680355501076,null,null,null,null,null,"GS 1,000-4,999","With TOA",{"$f":"N21/0.6","v":197766.79889675087},{"$f":"P34/D21","v":0.80876900889111691},{"$f":"L33","v":0.14640127751796506},{"$f":"Q34*R34","v":0.11840481611859796}]
[null,"Street Light",2.6780000000000004,11.7399,2.68,13.843500000000001,7.468259895444529E-4,0.17918380906140596,null,null,null,null,null,null,"Without TOA",{"$f":"D21-P34","v":46761.362695276504},{"$f":"P35/D21","v":0.19123099110888306},{"$f":"H33","v":0.10907623013512358},{"$f":"Q35*R35","v":2.0858755595160299E-2}]
[null,"Sentinel",5.63,42.642600000000002,6.45,48.904600000000002,0.14564831261101241,0.1468484567076116,null,null,null,null,null,null,null,null,null,null,{"$f":"S34+S35","v":0.13926357171375825}]
[null,"Unmetered Scattered Load",8.76,1.8599999999999998E-2,9.77,2.07E-2,0.11529680365296802,0.11290322580645173]