{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["RR formatted ws"],"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":"RR formatted ws","index":0,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[[4,4,5,4],[40,0,40,4],[41,0,41,4],[2,0,2,1],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3]]}
["Rate Rider Calculation for Account 1536"]
[]
[" Please indicate the Rate Rider Recovery Period (in years)",null,1]
[]
["Rate Class","Units","# of Customers","Balance of Account 1536","Rate Rider for Account 15362"]
[]
["RESIDENTIAL","# of Customers",325344.75,{"$f":"D33","v":-169933.57404878424},{"$f":"IF(ISERROR(D7/C7), 0, IF(B7=\"# of Customers\", D7/C7/12/$C$3, D7/C7/$C$3))","v":-4.3526539680545089E-2},{"$f":"IF(B7=\"\", \"\", IF(B7=\"# of Customers\", \"per customer per month\", \"$/\"&B7))","v":"per customer per month"}]
["GENERAL SERVICE LESS THAN 50 KW","# of Customers",32401.833333333332,-65007.968130499539,{"$f":"IF(ISERROR(D8/C8), 0, IF(B8=\"# of Customers\", D8/C8/12/$C$3, D8/C8/$C$3))","v":-0.16719210366311457},"per customer per month"]
["GENERAL SERVICE 50 TO 4,999 KW","# of Customers",4964.666666666667,-286476.1123461629,{"$f":"IF(ISERROR(D9/C9), 0, IF(B9=\"# of Customers\", D9/C9/12/$C$3, D9/C9/$C$3))","v":-4.8085825222600187},"per customer per month"]
["LARGE USER","# of Customers",2,-4790.6812765347058,-199.61171985561273,"per customer per month"]
["UNMETERED SCATTERED LOAD","# of Customers",2976.25,-886.92725164491765,-2.4833466376730159E-2,"per customer per month"]
["SENTINEL LIGHTING","# of Customers",208.5,-2983.560292973465,-1.1924701410765248,"per customer per month"]
["STREET LIGHTING","# of Customers",88126.083333333328,-23.666116413875049,-2.2379031192879003E-5,"per customer 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,""]
["Total",null,{"$f":"SUM(C7:C25)","v":454024.08333333331},{"$f":"SUM(D7:D25)","v":-530102.4894630136}]
[]
["Notes:"]
[]
["1)  Allocation to Classes"]
[]
["Rate Class","2016 Kwh forecast by Class","% by Class","Total Claim by Class"]
["RESIDENTIAL",2714896669.8675518,0.32056739484646557,-169933.57404878424]
["GENERAL SERVICE LESS THAN 50 KW",1038581793.976055,0.12263282935409658,-65007.968130499539]
["GENERAL SERVICE 50 TO 4,999 KW",4576806247.7278576,0.54041646293032719,-286476.1123461629]
["LARGE USER",76536992.273975864,9.0372736815244881E-3,-4790.6812765347058]
["UNMETERED SCATTERED LOAD",14169747.534494311,1.6731241019889613E-3,-886.92725164491765]
["SENTINEL LIGHTING",47666024.498592407,5.6282706689337924E-3,-2983.560292973465]
["STREET LIGHTING",378095.15276999999,4.4644416663367289E-5,-23.666116413875049]
[null,{"$f":"SUM(B33:B39)","v":8469035571.0312977},{"$f":"SUM(C33:C39)","v":1},{"$f":"SUM(D33:D39)","v":-530102.4894630136}]
[]
["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.   "]