{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet 1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Sheet 1","index":0,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,1,2,2],[4,5,5,5],[39,1,39,5],[40,1,40,5],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4]]}
[null,"Rate Rider Calculation for Account 1536"]
[]
[null,"Please indicate the Rate Rider Recovery Period (in years)",null,1]
[]
[null,"Rate Class","Units","# of Customers","Balance of Account 15361","Rate Rider for Account 15362"]
[]
[null,"RESIDENTIAL","# of Customers",325344.75,{"$f":"E32","v":-169933.57404878436},{"$f":"IF(ISERROR(E7/D7), 0, IF(C7=\"# of Customers\", E7/D7/12/$D$3, E7/D7/$D$3))","v":-4.3526539680545116E-2},{"$f":"IF(C7=\"\", \"\", IF(C7=\"# of Customers\", \"per customer per month\", \"$/\"&C7))","v":"per customer per month"}]
[null,"GENERAL SERVICE LESS THAN 50 KW","# of Customers",32401.833333333332,-65007.968130499568,{"$f":"IF(ISERROR(E8/D8), 0, IF(C8=\"# of Customers\", E8/D8/12/$D$3, E8/D8/$D$3))","v":-0.16719210366311466},"per customer per month"]
[null,"GENERAL SERVICE 50 TO 4,999 KW","# of Customers",4964.666666666667,-286476.11234616302,{"$f":"IF(ISERROR(E9/D9), 0, IF(C9=\"# of Customers\", E9/D9/12/$D$3, E9/D9/$D$3))","v":-4.8085825222600205},"per customer per month"]
[null,"LARGE USER","# of Customers",2,-4790.6812765347086,-199.61171985561285,"per customer per month"]
[null,"UNMETERED SCATTERED LOAD","# of Customers",2976.25,-886.9272516449181,-2.4833466376730173E-2,"per customer per month"]
[null,"SENTINEL LIGHTING","# of Customers",208.5,-23.666116413875063,-9.4588794619804416E-3,"per customer per month"]
[null,"STREET LIGHTING","# of Connections",88126.083333333328,{"$f":"E38","v":-2983.5602929734659},{"$f":"+E13/D13/12","v":-2.8212989277422271E-3},"per connection per month"]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,"Total",null,{"$f":"SUM(D7:D25)","v":454024.08333333331},{"$f":"SUM(E7:E25)","v":-530102.48946301383}]
[]
["NOTES:"]
["1.","Allocation to Classes","Amount to be allocated:",null,-530102.48946301395]
[]
[null,"Rate Class","2016 Kwh forecast by Class","% by Class","Total Claim by Class"]
[null,"RESIDENTIAL",2714896669.8675518,{"$f":"+C32/$C$39","v":0.32056739484646557},{"$f":"+D32*$E$29","v":-169933.57404878436}]
[null,"GENERAL SERVICE LESS THAN 50 KW",1038581793.976055,{"$f":"+C33/$C$39","v":0.12263282935409658},{"$f":"+D33*$E$29","v":-65007.968130499568}]
[null,"GENERAL SERVICE 50 TO 4,999 KW",4576806247.7278576,0.54041646293032719,{"$f":"+D34*$E$29","v":-286476.11234616302}]
[null,"LARGE USER",76536992.273975864,9.0372736815244881E-3,{"$f":"+D35*$E$29","v":-4790.6812765347086}]
[null,"UNMETERED SCATTERED LOAD",14169747.534494311,1.6731241019889613E-3,{"$f":"+D36*$E$29","v":-886.9272516449181}]
[null,"SENTINEL LIGHTING",378095.15276999999,4.4644416663367289E-5,{"$f":"+D37*$E$29","v":-23.666116413875063}]
[null,"STREET LIGHTING",47666024.498592407,5.6282706689337924E-3,{"$f":"+D38*$E$29","v":-2983.5602929734659}]
[null,null,{"$f":"SUM(C32:C38)","v":8469035571.0312977},{"$f":"SUM(D32:D38)","v":1},{"$f":"SUM(E32:E38)","v":-530102.48946301383}]
[]
["2.","Billing determinant for all classes is based on \"# of customers\" to mitigate classes that would have a $0.0000 rate rider based on volumetric determinants.   "]