{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"Sheet1","index":0,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[null,"Public Counsel Proposed REC Revenue Rebate Allocation",null,null,null,null,null,null,null,"Dockets UE-140188 & UG-140189"]
[null,null,null,null,null,null,null,null,null,"Exhibit No. LF-4"]
[null,"Inputs"]
[null,null,null,"TOTAL","SCHEDULE 1","SCH. 11,12","SCH. 21,22","SCHEDULE 25","SCH. 30, 31, 32","SCH. 41-48","Source"]
[null,"Total REC Revenue Rebate Amount",null,8788031,null,null,null,null,null,null,"PC_DR_210 Attachment A"]
[null,"Total Generation Percentage",null,{"$f":"SUM(E6:J6)","v":1},0.44446396478431566,9.5442847719569415E-2,0.25279700034154334,0.18076629396312272,2.2501877881945472E-2,4.028015309503352E-3,"S01 Allocator (Production Plant)"]
[null,"Annual Load",null,{"$f":"SUM(E7:J7)","v":5571472367.333333},2352011939,557353354,1424373231.0000002,1080448696.3333333,131638818,25646329,"Ehrbar Workpapers"]
[null,"Total Bills",null,{"$f":"SUM(E8:J8)","v":2843796.9999999963},2437080.9999999963,351974.99999999994,25427,252,29061.999999999996,null,"Ehrbar Workpapers"]
[null,"Annual Revenue",null,{"$f":"SUM(E9:J9)","v":480926000},{"$f":"207184000","v":207184000},{"$f":"66064000","v":66064000},{"$f":"127734000","v":127734000},{"$f":"62262000","v":62262000},{"$f":"10811000","v":10811000},{"$f":"6871000","v":6871000},"Ehrbar Exhibit No. PDE-4"]
[]
[null,"Overall Annual Rebate Reduction",null,{"$f":"D30/D9","v":1.2164129171015914E-2}]
[]
[null,null,null," ","RESIDENTIAL","GENERAL SVC. ","LG. GEN. SVC.","EX LG GEN SVC","PUMPING","ST & AREA LTG"]
[null,null,null,"TOTAL","SCHEDULE 1","SCH. 11,12","SCH. 21,22","SCHEDULE 25","SCH. 30, 31, 32","SCH. 41-48"]
[null,"Generation Allocated"]
[null,"Annual REC Revenue Rebate Amount",null,{"$f":"SUM(E16:J16)","v":5864762.6479766667},{"$f":"E7*E17","v":2587213.1329000001},557353.35400000005,1495591.8925500002,1058839.7224066665,142169.92344000001,23594.62268]
[null,"Cents Per kWh Rate",null,null,{"$f":"ROUND(E39,5)","v":1.1000000000000001E-3},{"$f":"ROUND(F39,5)","v":1E-3},1.0499999999999999E-3,9.7999999999999997E-4,1.08E-3,9.2000000000000003E-4]
[null,"Avg Monthly Credit Per Customer",null,null,{"$f":"(E7/E8)*E17","v":1.0616032593500193},{"$f":"(F7/F8)*F17","v":1.5835026749058885},{"$f":"(G7/G8)*G17","v":58.819046389664535},{"$f":"(H7/H8)*H17","v":4201.7449301851848},{"$f":"(I7/I8)*I17","v":4.8919524960429435}]
[null,"Avg Annual Credit Per Customer",null,null,{"$f":"(E7/(E8/12))*E17","v":12.739239112200231},{"$f":"(F7/(F8/12))*F17","v":19.002032098870664},{"$f":"(G7/(G8/12))*G17","v":705.82855667597448},{"$f":"(H7/(H8/12))*H17","v":50420.939162222217},{"$f":"(I7/(I8/12))*I17","v":58.703429952515314}]
[null,"Avg Total Credit Per Customer (18 Months)",null,null,{"$f":"18*E18","v":19.108858668300346},{"$f":"18*F18","v":28.503048148305993},{"$f":"18*G18","v":1058.7428350139617},75631.408743333333,88.055144928772989]
[]
[null,"Uniform Percentage"]
[null,"Annual REC Revenue Rebate Amount",null,{"$f":"SUM(E23:J23)","v":5850045.9857000001},{"$f":"E9*$D$11","v":2520212.9381677611},803611.02955399535,1553772.8755305468,757363.01044579281,131506.40046785306,83579.731534050341]
[null,"Cents Per kWh Rate",null,null,{"$f":"ROUND(E23/E7,5)","v":1.07E-3},{"$f":"ROUND(F23/F7,5)","v":1.4400000000000001E-3},1.09E-3,{"$f":"ROUND(H23/H7,5)","v":6.9999999999999999E-4},{"$f":"ROUND(I23/I7,5)","v":1E-3},{"$f":"ROUND(J23/J7,5)","v":3.2599999999999999E-3}]
[null,"Avg Monthly Credit Per Customer",null,null,{"$f":"(E7/E8)*E24","v":1.0326504431859278},{"$f":"(F7/F8)*F24","v":2.2802438518644794},{"$f":"(G7/G8)*G24","v":61.05977196641367},{"$f":"(H7/H8)*H24","v":3001.2463787037036},{"$f":"(I7/I8)*I24","v":4.5295856444842064}]
[null,"Avg Annual Credit Per Customer",null,null,{"$f":"(E7/(E8/12))*E24","v":12.391805318231134},{"$f":"(F7/(F8/12))*F24","v":27.362926222373755},{"$f":"(G7/(G8/12))*G24","v":732.71726359696402},{"$f":"(H7/(H8/12))*H24","v":36014.956544444445},{"$f":"(I7/(I8/12))*I24","v":54.355027733810481}]
[null,"Avg Total Credit Per Customer (18 Months)",null,null,{"$f":"E25*18","v":18.5877079773467},{"$f":"F25*18","v":41.04438933356063},1099.075895395446,54022.434816666668,81.532541600715717,0]
[]
[null,"Company Proposed"]
[null,"Annual REC Revenue Rebate Amount",null,{"$f":"SUM(E30:J30)","v":5850045.9856999991},{"$f":"E7*E31","v":2469612.5359499999},585221.02169999992,1495591.8925500002,1134471.1311499998,138220.75889999999,26928.64545]
[null,"Cents Per kWh Rate",null,null,{"$f":"ROUND($D$37/$D$38,5)","v":1.0499999999999999E-3},{"$f":"ROUND($D$37/$D$38,5)","v":1.0499999999999999E-3},1.0499999999999999E-3,1.0499999999999999E-3,1.0499999999999999E-3,1.0499999999999999E-3]
[null,"Avg Monthly Credit Per Customer",null,null,{"$f":"(E7/E8)*E31","v":1.0133485657432},{"$f":"(F7/F8)*F31","v":1.6626778086511826},{"$f":"(G7/G8)*G31","v":58.819046389664535},{"$f":"(H7/H8)*H31","v":4501.8695680555547},{"$f":"(I7/I8)*I31","v":4.756064926708417}]
[null,"Avg Annual Credit Per Customer",null,null,{"$f":"(E7/(E8/12))*E31","v":12.160182788918402},{"$f":"(F7/(F8/12))*F31","v":19.952133703814194},{"$f":"(G7/(G8/12))*G31","v":705.82855667597448},{"$f":"(H7/(H8/12))*H31","v":54022.43481666666},{"$f":"(I7/(I8/12))*I31","v":57.072779120500996}]
[null,"Avg Total Credit Per Customer (18 Months)",null,null,{"$f":"E32*18","v":18.240274183377601},{"$f":"F32*18","v":29.928200555721286},1058.7428350139617,81033.652224999983,85.609168680751509,0]
[]
[null,"Generation Allocated Rate Calculation"]
[null,"REC Revenue Available for Refund",null,{"$f":"SUM(E37:J37)","v":8788030.9999999981},{"$f":"E6*$D$5","v":3905963.1009074743},838754.70448785531,2221587.8757084934,1588579.7951030352,197747.20038475114,35398.323408390053]
[null,"Load Forecast (18 Months)",null,{"$f":"SUM(E38:J38)","v":8347293890},3563388464,836891898,2109870302,1615235839,183456283,38451104]
[null,"Cents Per kWh Rate",null,null,{"$f":"E37/E38","v":1.096137325573234E-3},{"$f":"F37/F38","v":1.0022258627336541E-3},1.052949972139327E-3,9.834971195825696E-4,1.0778982172267772E-3,9.2060616538838661E-4]
[]
[]
[null,"Source: Avista's Response to Public Counsel Data Request  219, Attachment A."]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}