{"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":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[4,4,5,4],[25,0,25,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 1555"]
[]
[" Please indicate the Rate Rider Recovery Period (in years)",null,2]
[]
["Rate Class","Units","kW / kWh / # of Customers","Balance of Account 1555","Rate Rider for Account 1555"]
[]
["RESIDENTIAL","# of Customers",325344.75,434724.46463066817,{"$f":"IF(ISERROR(D7/C7), 0, IF(B7=\"# of Customers\", D7/C7/12/$C$3, D7/C7/$C$3))","v":5.5674847556664658E-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,166303.53536933177,{"$f":"IF(ISERROR(D8/C8), 0, IF(B8=\"# of Customers\", D8/C8/12/$C$3, D8/C8/$C$3))","v":0.2138556143548099},"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,""]
["Total",null,null,{"$f":"SUM(D7:D15)","v":601028}]
["Notes:"]
[]
["1)  Total Claim Allocation Table by Class"]
[]
["Class","2016 forecast annual kwh","%","Claim"]
["Residential",2714896669.8675518,{"$f":"+B22/B24","v":0.72330151778397711},{"$f":"+D16*C22","v":434724.46463066817}]
["General Service less than 50 kw",1038581793.976055,{"$f":"+B23/B24","v":0.27669848221602283},{"$f":"+D16*C23","v":166303.53536933177}]
["Totals",{"$f":"SUM(B22:B23)","v":3753478463.8436069},{"$f":"SUM(C22:C23)","v":1},{"$f":"SUM(D22:D23)","v":601028}]
[]
["2)  The General Service less than 50kW rate ride is based on  \"# of customers\" since a volumetric basis creates a rate that is zero when rounded to 4 digits."]