{"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,1599983.9662124442,16017490.8633841,{"$f":"D4+E4","v":17617474.829596546},17396874.689579681,{"$f":"F4/G4","v":1.0126804465717627},null,{"$f":"IF(H4>Y4,Y4,IF(H4<X4,X4,H4))","v":1.0126804465717627},{"$f":"G4*J4","v":17617474.829596546},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.0126804465717627},{"$f":"G4*M4","v":17617474.829596546},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.0126804465717627},{"$f":"G4*P4","v":17617474.829596546},{"$f":"Q4/G4","v":1.0126804465717627},{"$f":"Q4/$Q$12","v":0.70081074310337643},{"$f":"Q4-D4","v":16017490.863384102},{"$f":"T4/$T$12","v":0.69857965957660428},null,null,0.85,1.1499999999999999,null,{"$f":"T4/C4-1","v":0.11435295744303087},null,{"$f":"Q4-D4","v":16017490.863384102},{"$f":"AC4+D4","v":17617474.829596546},{"$f":"AD4/G4","v":1.0126804465717627},{"$f":"AC4/T4-1","v":0}]
[null,"GS <50",2399831.891760136,233494.15566354198,2674259.7659490104,2907753.9216125524,2985770.5380045692,0.97387052507921246,null,0.97387052507921246,2907753.9216125524,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.97387052507921246},2907753.9216125524,null,0.97387052507921246,{"$f":"G5*P5","v":2907753.9216125524},0.97387052507921246,0.11566840346175292,2674259.7659490104,0.11663396550996177,null,null,0.8,1.2,null,0.11435295744303065,null,{"$f":"Q5-D5","v":2674259.7659490104},2907753.9216125524,0.97387052507921246,0]
[null,"GS 50 to 999 kW",2376296.2133624507,234121.34573941634,2648032.7131211217,2882154.0588605381,3111069.9488790482,0.92641891896355755,null,0.92641891896355755,2882154.0588605381,null,{"$f":"J6","v":0.92641891896355755},2882154.0588605381,null,0.92641891896355755,{"$f":"G6*P6","v":2882154.0588605381},0.92641891896355755,0.11465005894801794,2648032.7131211217,0.11549011059582617,null,null,0.8,1.2,null,0.11435295744303065,null,{"$f":"Q6-D6","v":2648032.7131211217},2882154.0588605381,0.92641891896355755,0]
[null,"GS 1,000 to 4,999 kW",555080.97615262668,45443.895042371121,618556.12739604386,664000.02243841498,563924.44670546823,1.1774627369279758,null,1.1774627369279758,664000.02243841498,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.1756793826160301},662994.34534477128,null,1.1756793826160301,{"$f":"MIN(G7*P7+Q15,K7)","v":662994.34534477128},1.1756793826160301,2.6373448200070239E-2,617550.45030240016,2.6933568248808944E-2,null,null,0.8,1.2,null,0.11254119098579363,null,{"$f":"Q7-D7-Q15","v":617550.45030240016},662994.34534477128,1.1756793826160301,0]
[null,"Large Use >5MW",535442.96157833107,57290.695970739842,596672.44777686824,653963.14374760806,674391.79736661876,0.96970803367006986,null,0.96970803367006986,653963.14374760806,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.96970803367006986},653963.14374760806,null,0.96970803367006986,{"$f":"G8*P8","v":653963.14374760806},0.96970803367006986,2.6014193359995677E-2,596672.44777686824,2.6023004414477895E-2,null,null,0.85,1.1499999999999999,null,0.11435295744303065,null,{"$f":"Q8-D8","v":596672.44777686824},653963.14374760806,0.96970803367006986,0]
[null,"Street Light",260279.00092866857,29393.300304489156,290042.67444517912,319435.97474966827,302035.94750878355,1.057609126941351,null,1.057609126941351,319435.97474966827,null,{"$f":"IF((IF(L$12>0,IF(J9=K$13,L$13,J9),IF(J9=K$14,L$14,J9))*G9-K9)>L14,(K9+$L$12)/G9,IF(L$12>0,IF(J9=K$13,L$13,J9),IF(J9=K$14,L$14,J9)))-L15","v":1.057609126941351},319435.97474966827,null,1.057609126941351,{"$f":"G9*P9","v":319435.97474966827},1.057609126941351,1.270693813974889E-2,290042.67444517912,1.2649791063079958E-2,null,null,0.8,1.2,null,0.11435295744303065,null,{"$f":"Q9-D9","v":290042.67444517912},319435.97474966827,1.057609126941351,0]
[null,"Sentinel",31731.553669601504,5266.1854646927131,35360.150675982688,40626.336140675397,52040.016542901365,0.78067492747976697,null,0.8,41632.013234321093,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},41632.013234321093,null,0.8,{"$f":"G10*P10-Q15","v":41632.013234321093},0.8,1.6560921706338732E-3,36365.827769628377,1.5860428952453971E-3,null,null,0.8,1.2,null,0.14604623991249621,null,{"$f":"N10-D10","v":36365.827769628377},41632.013234321086,0.79999999999999993,0]
[null,"Unmetered Scattered Load",43288.460376868898,5058.5140746759362,48238.623844119305,53297.137918795241,52598.040477735267,1.013291321020902,null,1.013291321020902,53297.137918795248,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.013291321020902},53297.137918795248,null,1.013291321020902,{"$f":"G11*P11","v":53297.137918795248},1.013291321020902,2.1201226164038979E-3,48238.623844119313,2.1038576959955305E-3,null,null,0.8,1.2,null,0.11435295744303087,null,{"$f":"Q11-D11","v":48238.623844119313},53297.137918795248,1.013291321020902,0]
[null,"Total",{"$f":"SUM(C4:C11)","v":20575754.937828679},{"$f":"SUM(D4:D11)","v":2210052.0584723712},{"$f":"SUM(E4:E11)","v":22928653.366592426},{"$f":"SUM(F4:F11)","v":25138705.425064798},{"$f":"SUM(G4:G11)","v":25138705.425064802},0.99999999999999989,null,null,{"$f":"SUM(K4:K11)","v":25139711.102158446},{"$f":"G12-K12","v":-1005.6770936436951},null,{"$f":"SUM(N4:N11)","v":25138705.425064802},{"$f":"G12-N12","v":0},null,{"$f":"SUM(Q4:Q11)","v":25138705.425064802},{"$f":"G12-Q12","v":0},{"$f":"SUM(S4:S11)","v":0.99999999999999989},{"$f":"SUM(T4:T11)","v":22928653.36659243},1,null,null,null,null,null,null,null,{"$f":"SUM(AC4:AC11)","v":22928653.36659243}]
[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.92641891896355755},"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.1774627369279758},1.2,"Max",{"$f":"MAX(M4:M11)","v":1.1756793826160301},1.2,"Max",{"$f":"MAX(P4:P11)","v":1.1756793826160301}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sentinel Adj."]
[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":16017490.863384102},{"$f":"K18*T4","v":0},null,{"$f":"L18/C18/12","v":33.296866368397758},{"$f":"M18/D18","v":0},29.88,null,{"$f":"IF(R18=\"Over\",Q18*12*C18,L18)","v":16017490.863384102},null,{"$f":"(X18*C18*12)/((X18*C18*12)+T18-N18)","v":1},null,null,{"$f":"ROUND(S18/C18/12,2)","v":33.299999999999997},null,null,33.299999999999997,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,734864.90652860806,{"$f":"K19*T5","v":1939394.8594204027},null,20.481807357802904,2.1618447374394795E-2,42.440911181339509,{"$f":"IF(O19>Q19,\"Over\",\"\")","v":""},734864.90652860806,{"$f":"T5-X19*C19*12+N19","v":1939459.7054469122},0.2747676459326085,{"$f":"T19/((X19*C19*12)+T19)","v":0.7252323540673915},null,20.48,{"$f":"ROUND(T19/D19,4)","v":2.1600000000000001E-2},null,20.48,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,398777.96890985366,{"$f":"K20*T6","v":2249254.7442112677},42807.027556495435,96.65897552860848,3.6629757112558297,86.74,"Over",357856.06907247828,2332983.6716051386,0.13514035053241047,0.86700951986744412,null,86.74,3.7993000000000001,null,86.74,3.7993000000000001,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,109327.73177556359,{"$f":"K21*T7","v":508222.71852683654},118660.07933805052,759.22035955252488,2.0783811370354925,682.42,"Over",98268.479999999981,637942.04964045074,{"$f":"(X21*C21*12)/((X21*C21*12)+T21-N21)","v":0.15912623811039273},{"$f":"T21/((X21*C21*12)+T21)","v":0.86652122450898361},null,682.42,2.6089000000000002,null,682.42,2.6089000000000002,0,0]
[null,"Large Use >5MW",3,268059.23480130621,2725.12,1.6315,98104.319999999992,437338.64157833107,535442.96157833107,0.1832208601842796,0.81677913981572037,109322.83912993745,{"$f":"K22*T8+N22","v":487349.60864693078},null,3036.745531387151,1.8180668500683044,2725.12,"Over",98104.319999999992,498568.12777686823,0.16441905498657633,0.83558094501342361,null,2725.12,1.8599000000000001,null,2725.12,1.8599000000000001,0,0]
[null,"Street Light",2919.41159236661,14179.063705514967,2.6780000000000004,11.7399,93818.210932293383,166460.78999637518,260279.00092866857,0.36045247829272625,0.63954752170727369,104546.6008144152,{"$f":"K23*T9+N23","v":185496.07363076392},null,2.9842372200324365,13.082392285085435,2.6780000000000004,"Over",93818.210932293383,196154.39763466892,0.32370504440461567,0.67629495559538433,null,2.68,13.834099999999999,null,2.68,13.834099999999999,0,0]
[null,"Sentinel",231.19110332107795,377.84475452316417,5.63,42.642600000000002,15619.270940372026,16112.282729229481,31731.553669601504,0.49223152143776444,0.50776847856223561,17900.40673138788,{"$f":"K24*T10+N24","v":18465.4210382405},null,6.4522403307073546,48.870391390092614,20.49765899927813,"",17900.40673138788,18471.636372576941,0.49206061004325924,0.50793938995674082,null,6.45,48.886800000000001,null,6.45,48.886800000000001,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,26106.551748433354,{"$f":"K25*T11+N25","v":22132.072095685959},null,9.7617319072009519,2.072696500844037E-2,16.358426041394384,"",26106.551748433354,22136.703868551154,0.54110001271833952,0.45889998728166043,null,9.76,2.07E-2,null,9.76,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.299999999999997},0,{"$f":"E30/C30-1","v":0.11445783132530107},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.16051218804410916},{"$f":"Q30*R30","v":1.8649501624415692E-2}]
[null,"GS <50",18.38,1.9400000000000001E-2,20.48,2.1600000000000001E-2,0.1142546245919478,{"$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.13182197330791245},{"$f":"Q31*R31","v":0.11650591453819449}]
[null,"GS 50 to 999 kW",86.74,3.3567999999999998,86.74,3.7993000000000001,0,0.13182197330791245,null,{"$f":"D32-0.6","v":2.7567999999999997},{"$f":"F32-0.6","v":3.1993},{"$f":"K32/J32-1","v":0.16051218804410916},null,null,null,null,null,null,{"$f":"S30+S31","v":0.13515541616261018}]
[null,"GS 1,000 to 4,999 kW",682.42,2.3534000000000002,682.42,2.6089000000000002,0,0.10856632956573464,null,{"$f":"D33-0.6","v":1.7534000000000001},{"$f":"F33-0.6","v":2.0089000000000001},{"$f":"K33/J33-1","v":0.1457168928938064}]
[null,"Large Use >5MW",2725.12,1.6315,2725.12,1.8599000000000001,0,0.13999387067116165,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.1457168928938064},{"$f":"Q34*R34","v":0.11785130704441685}]
[null,"Street Light",2.6780000000000004,11.7399,2.68,13.834099999999999,7.468259895444529E-4,0.17838312081022822,null,null,null,null,null,null,"Without TOA",{"$f":"D21-P34","v":46761.362695276504},{"$f":"P35/D21","v":0.19123099110888306},{"$f":"H33","v":0.10856632956573464},{"$f":"Q35*R35","v":2.0761246803909068E-2}]
[null,"Sentinel",5.63,42.642600000000002,6.45,48.886800000000001,0.14564831261101241,0.14643103375497746,null,null,null,null,null,null,null,null,null,null,{"$f":"S34+S35","v":0.13861255384832591}]
[null,"Unmetered Scattered Load",8.76,1.8599999999999998E-2,9.76,2.07E-2,0.11415525114155245,0.11290322580645173]