{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Non-Confidential","Sheet1"],"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":"Non-Confidential","index":0,"n_rows":500,"n_cols":7,"rows_kept":500,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9]]}
["Avista – GRC Filing - April 30, 2019"]
["Index of Files on CD"]
[]
[]
["I. UE__AVA Dir Evidence-(Apr19)"]
[]
[null,"1. UE__AVA Initial Filing (Apr19)"]
[null,null,"A.  UE__AVA Cover Letter (Apr19)"]
[null,null,null,"NEW-AVA-CLtr-4-29-19.pdf"]
[]
[null,null,"B.  UE__AVA Summary Electric (Apr19)"]
[null,null,null,"NEW-AVA-Electric-Summary-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Electric-Summary-4-29-19.xls"]
[]
[null,null,"C.  UE__AVA Summary Natural Gas (Apr19)"]
[null,null,null,"NEW-AVA-Natural-Gas-Summary-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Natural-Gas-Summary-4-29-19.xls"]
[]
[null,null,"D.  UE__AVA Certificate of Service (Apr19)"]
[null,null,null,"NEW-AVA-CoS-4-29-19.doc"]
[]
[null,null,"E.  UE__AVA Claim of Confidentiality (Apr19)"]
[null,null,null,"NEW-AVA-Claim-of-Confidentiality-4-29-19.pdf"]
[]
[null,null,"F.  UE__AVA Electric Tariffs (Apr19)"]
[null,null,null,"Proposed"]
[null,null,null,null,"WA_001.rtf"]
[null,null,null,null,"WA_011.rtf"]
[null,null,null,null,"WA_021.rtf"]
[null,null,null,null,"WA_025.rtf"]
[null,null,null,null,"WA_031.rtf"]
[null,null,null,null,"WA_041.rtf"]
[null,null,null,null,"WA_042.rtf"]
[null,null,null,null,"WA_044.rtf"]
[null,null,null,null,"WA_045.rtf"]
[null,null,null,null,"WA_046.rtf"]
[null,null,null,null,"WA_047.rtf"]
[null,null,null,null,"WA_075.docx"]
[null,null,null,null,"WA_096.docx"]
[null,null,null,"Strikethrough"]
[null,null,null,null,"WA_001.rtf"]
[null,null,null,null,"WA_011.rtf"]
[null,null,null,null,"WA_021.rtf"]
[null,null,null,null,"WA_025.rtf"]
[null,null,null,null,"WA_031.rtf"]
[null,null,null,null,"WA_041.rtf"]
[null,null,null,null,"WA_042.rtf"]
[null,null,null,null,"WA_044.rtf"]
[null,null,null,null,"WA_045.rtf"]
[null,null,null,null,"WA_046.rtf"]
[null,null,null,null,"WA_047.rtf"]
[null,null,null,null,"WA-075.docx"]
[null,null,null,"Underline"]
[null,null,null,null,"WA_001.rtf"]
[null,null,null,null,"WA_011.rtf"]
[null,null,null,null,"WA_021.rtf"]
[null,null,null,null,"WA_025.rtf"]
[null,null,null,null,"WA_031.rtf"]
[null,null,null,null,"WA_041.rtf"]
[null,null,null,null,"WA_042.rtf"]
[null,null,null,null,"WA_044.rtf"]
[null,null,null,null,"WA_045.rtf"]
[null,null,null,null,"WA_046.rtf"]
[null,null,null,null,"WA_047.rtf"]
[null,null,null,null,"WA_075.docx"]
[null,null,null,"NEW-AVA-Electric-Tariffs-Legislative-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Proposed-Electric-Tariffs-4-29-19.pdf"]
[null,null,"G.  UE__AVA Natural Gas Tariffs (Apr19)"]
[null,null,null,"Proposed"]
[null,null,null,null,"WA_101.rtf"]
[null,null,null,null,"WA_111.rtf"]
[null,null,null,null,"WA_112.rtf"]
[null,null,null,null,"WA_116.docx"]
[null,null,null,null,"WA_131.rtf"]
[null,null,null,null,"WA_132.rtf"]
[null,null,null,null,"WA_146.docx"]
[null,null,null,null,"WA_175.docx"]
[null,null,null,null,"WA_196.docx"]
[null,null,null,"Strikethrough"]
[null,null,null,null,"WA_101.rtf"]
[null,null,null,null,"WA_111.rtf"]
[null,null,null,null,"WA_112.rtf"]
[null,null,null,null,"WA_116.docx"]
[null,null,null,null,"WA_131.rtf"]
[null,null,null,null,"WA_132.rtf"]
[null,null,null,null,"WA_146.docx"]
[null,null,null,null,"WA_175.docx"]
[null,null,null,"Underline"]
[null,null,null,null,"WA_101.rtf"]
[null,null,null,null,"WA_111.rtf"]
[null,null,null,null,"WA_112.rtf"]
[null,null,null,null,"WA_116.docx"]
[null,null,null,null,"WA_131.rtf"]
[null,null,null,null,"WA_132.rtf"]
[null,null,null,null,"WA_146.docx"]
[null,null,null,null,"WA_175.docx"]
[null,null,null,"NEW-AVA-Natural-Gas-Tariffs-Legislative-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Proposed-Natural-Gas-Tariffs-4-29-19.pdf"]
[]
[null,null,"H.  UE__Motion for Protective Order (Apr19)"]
[null,null,null,"NEW-AVA-Mot-PO-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Mot-PO-COS-4-29-19.doc"]
[]
[null,"2.  UE___ AVA Testimony (Apr19)"]
[]
[null,null,"1)  UE__Vermillion Direct (AVA-Apr19)"]
[null,null,null,"NEW-AVA-Exh-DPV-1T-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-DPV-2-4-29-19.pdf"]
[]
[null,null,"2) UE__Thies Direct (AVA-Apr19)"]
[null,null,null,"Native Format"]
[null,null,null,null,"NEW-AVA-Exh-MTT-2-4-29-19 - Redacted.xlsx"]
[null,null,null,"NEW-AVA-Exh-MTT-1T-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-MTT-2-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-MTT-3-4-29-19 (R).pdf"]
[null,null,null,"NEW-AVA-Exh-MTT-4-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-MTT-5-4-29-19 (R).pdf"]
[]
[null,null,"3) UE__McKenzie Direct (AVA-Apr19)"]
[null,null,null,"Native Format"]
[null,null,null,null,"NEW-AVA-Exh-AMM-4-14-4-29-19.docx"]
[null,null,null,"NEW-AVA-Exh-AMM-1T-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-AMM-2-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-AMM-3-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-AMM-4-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-AMM-5-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-AMM-6-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-AMM-7-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-AMM-8-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-AMM-9-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-AMM-10-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-AMM-11-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-AMM-12-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-AMM-13-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-AMM-14-4-29-19.pdf"]
[]
[null,null,"4) UE__Andrews Direct (AVA-Apr19)"]
[null,null,null,"Native Format"]
[null,null,null,null,"NEW-AVA-Exh-EMA-2-4-29-19.xlsx"]
[null,null,null,null,"NEW-AVA-Exh-EMA-3-4-29-19.xlsx"]
[null,null,null,null,"NEW-AVA-Exh-EMA-4-4-29-19.xlsx"]
[null,null,null,null,"NEW-AVA-Exh-EMA-5-4-29-19.xlsx"]
[null,null,null,"NEW-AVA-Exh-EMA-1T-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-EMA-2-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-EMA-3-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-EMA-4-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-EMA-5-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-EMA-6-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-EMA-7-4-29-19.pdf"]
[]
[null,null,"5) UE__Thackston Direct (AVA-Apr19)"]
[null,null,null,"NEW-AVA-Exh-JRT-1T-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-JRT-2-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-JRT-3-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-JRT-4-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-JRT-5-4-29-19.pdf"]
[]
[null,null,"6) UE__Kalich Direct (AVA-Apr19)"]
[null,null,null,"NEW-AVA-Exh-CGK-1T-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-CGK-2-4-29-19.pdf"]
[]
[null,null,"7) UE__Rosentrater Direct (AVA-Apr19)"]
[null,null,null,"NEW-AVA-Exh-HLR-1T-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-HLR-2-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-HLR-3-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-HLR-4-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-HLR-5-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-HLR-6-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-HLR-7-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-HLR-8-4-29-19.pdf"]
[]
[null,null,"8) UG__Morehouse Direct (AVA-Apr19)"]
[null,null,null,"NEW-AVA-Exh-JM-1T-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-JM-2-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-JM-2a-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-JM-3-4-29-19.pdf"]
[]
[null,null,"9) UE__Kensok Direct (AVA-Apr19)"]
[null,null,null,"NEW-AVA-Exh-JMK-1T-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-JMK-2-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-JMK-3-4-29-19.pdf"]
[]
[null,null,"10) UE__Schuh Direct (AVA-Apr19)"]
[null,null,null,"NEW-AVA-Exh-KKS-1T-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-KKS-2-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-KKS-3-4-29-19.pdf"]
[]
[null,null,"11) UE__Knox Direct (AVA-Apr19)"]
[null,null,null,"Native Format"]
[null,null,null,null,"NEW-AVA-Exh-TLK-2A-4-29-19.xlsx"]
[null,null,null,null,"NEW-AVA-Exh-TLK-3-4-29-19.xlsx"]
[null,null,null,"NEW-AVA-Exh-TLK-1T-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-TLK-2-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-TLK-3-4-29-19.pdf"]
[]
[null,null,"12) UE__Miller Direct (AVA-Apr19)"]
[null,null,null,"Native Format"]
[null,null,null,null,"NEW-AVA-Exh-JDM-2-4-29-19"]
[null,null,null,null,null,null,"WA_001.rtf"]
[null,null,null,null,null,null,"WA_011.rtf"]
[null,null,null,null,null,null,"WA_021.rtf"]
[null,null,null,null,null,null,"WA_025.rtf"]
[null,null,null,null,null,null,"WA_031.rtf"]
[null,null,null,null,null,null,"WA_041.rtf"]
[null,null,null,null,null,null,"WA_042.rtf"]
[null,null,null,null,null,null,"WA_044.rtf"]
[null,null,null,null,null,null,"WA_045.rtf"]
[null,null,null,null,null,null,"WA_046.rtf"]
[null,null,null,null,null,null,"WA_047.rtf"]
[null,null,null,null,null,null,"WA_048.rtf"]
[null,null,null,null,null,null,"WA_075.docx"]
[null,null,null,null,"NEW-AVA-Exh-JDM-3-4-29-19"]
[null,null,null,null,null,null,"WA_001.rtf"]
[null,null,null,null,null,null,"WA_011.rtf"]
[null,null,null,null,null,null,"WA_021.rtf"]
[null,null,null,null,null,null,"WA_025.rtf"]
[null,null,null,null,null,null,"WA_031.rtf"]
[null,null,null,null,null,null,"WA_041.rtf"]
[null,null,null,null,null,null,"WA_042.rtf"]
[null,null,null,null,null,null,"WA_044.rtf"]
[null,null,null,null,null,null,"WA_045.rtf"]
[null,null,null,null,null,null,"WA_046.rtf"]
[null,null,null,null,null,null,"WA_047.rtf"]
[null,null,null,null,null,null,"WA_075.docx"]
[null,null,null,null,null,null,"WA_096.docx"]
[null,null,null,null,"NEW-AVA-Exh-JDM-5-4-29-19"]
[null,null,null,null,null,null,"WA_101.rtf"]
[null,null,null,null,null,null,"WA_111.rtf"]
[null,null,null,null,null,null,"WA_112.rtf"]
[null,null,null,null,null,null,"WA_116.docx"]
[null,null,null,null,null,null,"WA_121.rtf"]
[null,null,null,null,null,null,"WA_122.rtf"]
[null,null,null,null,null,null,"WA_126.docx"]
[null,null,null,null,null,null,"WA_131.rtf"]
[null,null,null,null,null,null,"WA_132.rtf"]
[null,null,null,null,null,null,"WA_146.docx"]
[null,null,null,null,null,null,"WA_175.docx"]
[null,null,null,null,"NEW-AVA-Exh-JDM-6-4-29-19"]
[null,null,null,null,null,null,"WA_101.rtf"]
[null,null,null,null,null,null,"WA_111.rtf"]
[null,null,null,null,null,null,"WA_112.rtf"]
[null,null,null,null,null,null,"WA_116.docx"]
[null,null,null,null,null,null,"WA_131.rtf"]
[null,null,null,null,null,null,"WA_132.rtf"]
[null,null,null,null,null,null,"WA_146.docx"]
[null,null,null,null,null,null,"WA_175.docx"]
[null,null,null,null,null,null,"WA_196.docx"]
[null,null,null,null,"NEW-AVA-Exh-JDM-8-4-29-19.docx"]
[null,null,null,null,"NEW-AVA-Exh-JDM-8a-4-29-19.xlsm"]
[null,null,null,null,"NEW-AVA-Exh-JDM-9-4-29-19.xlsm"]
[null,null,null,"NEW-AVA-Exh-JDM-1T-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-JDM-2-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-JDM-3-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-JDM-4-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-JDM-5-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-JDM-6-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-JDM-7-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-JDM-8-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-JDM-9-4-29-19.pdf"]
[]
[null,null,"13) UE__Ehrbar Direct (AVA-Apr19)"]
[null,null,null,"NEW-AVA-Exh-PDE-1T-4-29-19.pdf"]
[null,null,null,"NEW-AVA-Exh-PDE-2-4-29-19.pdf"]
[]
[null,"3. UE__AVA WP's (Apr19)"]
[]
[null,null,"3. UE__McKenzie WP (AVA-Apr19)"]
[null,null,null,"McKenzie Workpapers.pdf"]
[null,null,null,"WP-50.xlsm"]
[]
[null,null,"4. UE__Andrews Electric WP's -4-29-19"]
[null,null,null,"0.0 Tables and Illustrations"]
[null,null,null,null,"2-Year Plan Table.xlsx"]
[null,null,null,null,"AFUDC Reg Amort for Deferred Tax 4-4-2019.xlsx"]
[null,null,null,null,"Colstrip Tables.xlsx"]
[null,null,null,null,"Illustration 3-4.xlsx"]
[null,null,null,null,"ROR Charts for 2018.xlsx"]
[null,null,null,"0.1 Cost of Capital"]
[null,null,null,null,"Exh-MTT-2.xlsx"]
[null,null,null,"1.00 Results of Operations"]
[null,null,null,null,"12A-2018.12_Avista Electric Pull.xlsm"]
[null,null,null,null,"12A-2018.12_Avista Gas North Pull.xlsm"]
[null,null,null,null,"12A-2018.12_Avista Gas South Pull.xlsm"]
[null,null,null,null,"12E-2018.12_Avista Electric Pull.xlsm"]
[null,null,null,null,"12E-2018.12_Avista Gas North Pull.xlsm"]
[null,null,null,null,"12E-2018.12_Avista Gas South Pull.xlsm"]
[null,null,null,null,"1.01 ADFIT"]
[null,null,null,"1.001 Allocation Factors"]
[null,null,null,null,"5 Day Peak (3 year average 2016-2018).xlsx"]
[null,null,null,null,"2018-Allocation Factors- 4 (E&G),7,8,9-2017 Data.xlsx"]
[null,null,null,null,"2019 PTRatio-2018 Data.xlsx"]
[null,null,null,null,"2019-Allocation Factors- 4 (E&G),7,8,9-2018.xlsx"]
[null,null,null,null,"Gas - Note 10 - 2018 Data.xlsx"]
[null,null,null,null,"Jackson Prairie Allocation.doc"]
[null,null,null,"1.01 ADFIT"]
[null,null,null,null,"1)ADFIT-12.2018 AMA-WA CBR.xlsx"]
[null,null,null,null,"2)CDA Legal Costs Amort.xlsx"]
[null,null,null,null,"3)E Plant.pdf"]
[null,null,null,null,"3)G Plant.dpf"]
[null,null,null,null,"4)ADFIT-12.2018 EOP-WA CBR.xlsx"]
[null,null,null,"1.02 Deferred Debits&Credits"]
[null,null,null,null,"1) CB - 2018.12 WA Regulatory Debits and Credits"]
[null,null,null,null,"2) CB - 2018.12 ColstripAdjs"]
[null,null,null,null,"3) CB - 2018.12 WA KettleFalls"]
[null,null,null,null,"4) CB - 2018.12 Settlement Exch-WNP3 Adj"]
[null,null,null,null,"5) CB - 2018.12 CDA Settle-Past Stor Defs"]
[null,null,null,null,"6) CB - 2018.12 CDA Settle-CDR Fund Defs"]
[null,null,null,null,"7) CB - 2018.12 Spok Relicense Deferral"]
[null,null,null,null,"8) CB - 2018.12 Spok Relicense PME Defer"]
[null,null,null,null,"9) CB - 2018.12 Non-Plt Excess Tax Liab"]
[null,null,null,null,"10) CB - 2018.12 MT Trust Fund Settlement"]
[null,null,null,null,"11) CB - 2018.12 Customer Advances"]
[null,null,null,null,"11.1)2018 Customer Deposit Interest Rates"]
[null,null,null,null,"12) CB - 2018.12 Customer Deposits"]
[null,null,null,null,"2018 FERC ACCT 252000"]
[null,null,null,"1.03 Working Capital"]
[null,null,null,null,"1) 12A-2018 12_Working Capital_PULL.xlsm"]
[null,null,null,null,"2)E-ROO - Other Rate Base"]
[null,null,null,null,"2)G-ROO - Other Rate Base"]
[null,null,null,null,"3)Working Capital by GL account"]
[null,null,null,"1.04 AMI Rate Base"]
[null,null,null,null,"1) AMI Net Rate Base"]
[null,null,null,null,"2) AMI DFIT"]
[null,null,null,null,"170327-170328-AVA-Pet-Acct-AttchB-9-7-17"]
[null,null,null,null,"UE-170327 and UG-170328 - Order 01"]
[null,null,null,"2.01 B&O TAXES"]
[null,null,null,null,"2018 - Eliminate B&O Tax.xlsx"]
[null,null,null,"2.02 Restate Property Tax"]
[null,null,null,null,"1) 12.2018 Property Tax"]
[null,null,null,null,"2)ROO OTX 2018-E"]
[null,null,null,null,"2)ROO OTX 2018-G"]
[null,null,null,null,"3)property taxes - GL download-2018"]
[null,null,null,null,"4)copy of FERC 236100-payment details"]
[null,null,null,"2.03 UNCOLLECTIBLE EXPENSE"]
[null,null,null,null,"12.2018 Uncollectible Exp Adj"]
[null,null,null,null,"2018 Uncollectibles transactions FERC_GL_Detail"]
[null,null,null,"2.04 Regulatory Expense"]
[null,null,null,null,"Regulatory Fees FERC 928-2018.xls"]
[null,null,null,"2.05 INJURIES & DAMAGES"]
[null,null,null,null,"1) 12.2018 inj & dam adj.xls"]
[null,null,null,"2.06 FIT_DFIT Expense"]
[null,null,null,null,"1) E-FIT 2018 Electric Adj.xls"]
[null,null,null,null,"2) G-FIT 2018 Gas Adj.xlsx"]
[null,null,null,null,"3)Reconcile SCH Ms to DFIT Exp-2018.xlsx"]
[null,null,null,null,"4)2018 ITC AMORT.xlsx"]
[null,null,null,"2.07 Sub Space"]
[null,null,null,null,"1)12.2018 WA GRC - Office Space Charged to Non-Utility.xls"]
[null,null,null,"2.08 Restate Excise -WA"]
[null,null,null,null,"1) 2018 - WA - Excise Tax.xlsx"]
[null,null,null,"2.09 Net Gains and Losses"]
[null,null,null,null,"1)2018 WA CBR - NET GAINS AND LOSSES.xlsx"]
[null,null,null,"2.10 Weather Normalization"]
[null,null,null,null,"12.2018 WAID Elec Weather Adj Calc.xlsx"]
[null,null,null,null,"12.2018 WAID Nat Gas Weather Adj Calc.xlsx"]
[null,null,null,"2.11 Eliminate Adder Schedules"]
[null,null,null,null,"1)WA Eliminate Adder Schedule 2018"]
[null,null,null,null,"2) Reconcile SCH Ms to DFIT Exp-2018"]
[null,null,null,"2.12 Misc Restating"]
[null,null,null,null,"1) 12.2018 Misc Restate-WA"]
[null,null,null,null,"2) 12.2018 WA GRC - Misc Restating - BOD"]
[null,null,null,null,"3) 12.2018 WA GRC - Misc Restating - Non-Utility Removals"]
[null,null,null,null,"4) 12.2018 WA GRC - Misc Restating - Reclass"]
[null,null,null,null,"5) 12.2018 WA GRC - Misc Restating - LTIP"]
[null,null,null,null,"6) 12.2018 WA GRC - Misc Restating - Plane Reclass"]
[null,null,null,null,"7) 12.2018 WA GRC - Misc Restating - D&O Insurance"]
[null,null,null,null,"8) 12.2018 WA Earnings Sharing Prior Period Adj"]
[null,null,null,null,"2018 Director Comp Data"]
[null,null,null,null,"2018 Q4 550 aircraft Expenditure Type"]
[null,null,null,null,"2018 Q4 Reclass data"]
[null,null,null,null,"Director Comp 2018"]
[null,null,null,null,"FTACRouting_AllAC"]
[null,null,null,"2.13 Incentives"]
[null,null,null,null,"(WA2019) Incentive Adjustment"]
[null,null,null,"2.14 Debt Interest"]
[null,null,null,null,"Average Debt % and Debt Cost for ROO-12.31.2018"]
[null,null,null,"2.15E ERM Elim"]
[null,null,null,null,"(WA 2019) ERM Elimination 12.31.18 - Final"]
[null,null,null,"2.16E NEZ PERCE SETTLEMENT"]
[null,null,null,null,"FERC 557 ROO"]
[null,null,null,null,"Nez Perce Settlement-2018.xlsx"]
[null,null,null,"2.17E Rest CS2-Colstrip Normal Maint"]
[null,null,null,null,"1) CS2&Colstrip Major Maintenance ADJ"]
[null,null,null,"2.18E Authorized Power Supply"]
[null,null,null,null,"12.2018 Power Supply WA Adj Workbook"]
[null,null,null,null,"2018 WA & ID Actual Deferrals"]
[null,null,null,"2.19E-2.15G Restate 2018 Rate Base AMA to EOP"]
[null,null,null,null,"ADFIT"]
[null,null,null,null,null,"2)CDA Legal Costs Amort"]
[null,null,null,null,null,"3)ADFIT-12.2018 AMA-WA CBR"]
[null,null,null,null,null,"4)ADFIT-12.2018 EOP-WA CBR"]
[null,null,null,null,"Results of Operations"]
[null,null,null,null,null,"ROO Electric AMA 2018"]
[null,null,null,null,null,"ROO Electric EOP 2018"]
[null,null,null,null,null,"ROO Gas AMA 2018"]
[null,null,null,null,null,"ROO Gas EOP 2018"]
[null,null,null,null,"1) 2.19 Restate 2018 RB AMA to EOP Rate Base Adj"]
[null,null,null,null,"2) Adjust Deprec Exp from AMA to EOP - 12.2018"]
[null,null,null,null,"12A-2018.12 AMI"]
[null,null,null,null,"12E-2018.12 AMI"]
[null,null,null,"3.01 PF Revenue Normalization"]
[null,null,null,null,"Decoupling Base at Present Rates"]
[null,null,null,null,null,"Electric Decoupling Base at Present Rates"]
[null,null,null,null,null,"Natural Gas Decoupling Base at Present Rates"]
[null,null,null,null,"Electric Revenue Model"]
[null,null,null,null,"Natural Gas Revenue Model"]
[null,null,null,null,"WA Elec Rev Norm Adj"]
[null,null,null,null,"WA Gas Rev Norm Adj"]
[null,null,null,"3.02E PF Deferred Debits & Credits"]
[null,null,null,null,"1) PF - 2018 WA Regulatory Debits and Credits"]
[null,null,null,null,"2) PF - 2018.12 WA KettleFalls"]
[null,null,null,null,"3) PF - 2018.12 Settlement Exch-WNP3 Adj"]
[null,null,null,null,"4) PF - 2018.12 CDA Settle-Past Stor Defs"]
[null,null,null,null,"5) PF - 2018.12 CDA Settle-CDR Fund Defs"]
[null,null,null,null,"6) PF - 2018.12 Spok Relicense Deferral"]
[null,null,null,null,"7) PF - 2018.12 Spok Relicense PME Defer"]
[null,null,null,null,"8) PF - 2018.12 Non-Plt Excess Tax Liab"]
[null,null,null,null,"9) PF - 2018.12 MT Trust Fund Settlement"]
[null,null,null,"3.02G PF LEAP Amortization"]
[null,null,null,null,"LEAP Deferral and Amort"]
[null,null,null,"3.03-3.05 PF - Labor and Benefits"]
[null,null,null,null,"(WA 2019) FLB Forecast Labor Executive"]
[null,null,null,null,"(WA 2019) FLB Forecast Labor Non-Executive "]
[null,null,null,null,"(WA 2019) FLB Retirement and Medical"]
[null,null,null,null,"Hdyro One Restate"]
[null,null,null,"3.06 PF Insurance Expense"]
[null,null,null,null,"12.2019 Pro Forma adjustment"]
[null,null,null,"3.07 PF IS_IT"]
[null,null,null,null,"3.07 PF - IS IT Adjustment"]
[null,null,null,null,"WA GRC 2019 filing - ET data-Final"]
[null,null,null,"3.08 PF Property Tax"]
[null,null,null,null,"1) 12.2018 Property Tax-PF"]
[null,null,null,null,"2)Copy of 2019_01_10 - FINAL 2018_REVISED 2019 values and rollforward to 2023 forecast"]
[null,null,null,"3.09 PF Depreciation Study"]
[null,null,null,null,"1) 2018 Update Workpapers - Depreciation Study Summary - Attachments A, B1-2, and Summary WPs"]
[null,null,null,"3.10 PF 2019 Capital Adds"]
[null,null,null,null,"1) PF CAP SUMMARY-ADJ Final"]
[null,null,null,"3.11 PF Offsets"]
[null,null,null,null,"1) 2019 O&M Offsets-E-OFF"]
[null,null,null,"3.12 PF Fee Free Amortization"]
[null,null,null,null,"2017 FISERV deferral calc"]
[null,null,null,null,"2018 FISERV deferral calc"]
[null,null,null,null,"182314 Transactions"]
[null,null,null,null,"407414 Transactions 2017-2018"]
[null,null,null,null,"407414 Transactions"]
[null,null,null,null,"903314 Transactions"]
[null,null,null,null,"Avisa WA Payment Fees Petition (Jan 2016)"]
[null,null,null,null,"Fee Free Deferral and Amort"]
[null,null,null,null,"UE-160071 Order 01"]
[null,null,null,null,"UG-160072 Order 01"]
[null,null,null,"3.13 PF Colstrip Reg Asset Amortization"]
[null,null,null,null,"1) Colstrip Amortization"]
[null,null,null,null,"2)Revised Colstrip Amortization due to Depreciation Study Order 04"]
[null,null,null,null,"3)Interest on Temp. Tax Reform Credit"]
[null,null,null,null,"3.1)RE  Question"]
[null,null,null,null,"5) Proposed Accounting for Colstrip v1.7.01.29.2019"]
[null,null,null,null,"What if 2025 Estimate for Colstrip"]
[null,null,null,"3.14 PF CS2-Colstrip Normal Maint"]
[null,null,null,null,"1) CS2&Colstrip Major Maintenance ADJ-PF"]
[null,null,null,"ConvFactor-12.31.2018"]
[null,null,null,"Exh EMA 2 -2018 WA Electric RR Model AMA 2020"]
[null,null,null,"EXh EMA 3 -2018 WA Natural Gas RR Model AMA 2020"]
[null,null,null,"Exh EMA 4 -WA Electric Revenue Growth Model - 04.15.2019"]
[null,null,null,"Exh EMA 5 -WA Gas Revenue Growth Model"]
[null,null,null,"Section 1"]
[null,null,null,"Section 2"]
[null,null,null,"Section 3"]
[null,null,null,"Section 4"]
[]
[null,null,"10. UE__Schuh WP -4-29-19"]
[null,null,null,"Schuh Workpapers.pdf"]
[]
[null,null,"11. UE__Knox WP (AVA Apr19)"]
[null,null,null,"Knox ECOS WorkPapers Native"]
[null,null,null,null,"12.2018 AG Study.xlsm"]
[null,null,null,null,"Demand 12CP 12.2018.xlsm"]
[null,null,null,null,"Functionalization WA - 2018.xlsm"]
[null,null,null,null,"Meter cost WA - 2018.xlsx"]
[null,null,null,null,"Misc Assign WA - 2018.xlsx"]
[null,null,null,null,"WAElec COS Base Case UE-19__.xlsm"]
[null,null,null,"Knox Revenue Norm Work Papers Native"]
[null,null,null,null,"12.2018 WAID Elec Weather Adj Calc"]
[null,null,null,null,"2016 Electric Regressions"]
[null,null,null,null,"2018 Normalized Usage by Month"]
[null,null,null,"Knox ECOS workpapers UE-19____"]
[null,null,null,"Knox Rev Norm workpapers UE-19____"]
[]
[null,null,"12. UE__Miller WP(AVA-Apr19)"]
[null,null,null,"Electronic"]
[null,null,null,null,"COS"]
[null,null,null,null,null,"Avista - WA Cost of Service (NG) - Base Case.xlsm"]
[null,null,null,null,null,"Mains Flow Diagram.docx"]
[null,null,null,null,"Rev Norm"]
[null,null,null,null,null,"2016 Gas Regressions.xlsx"]
[null,null,null,null,"RS-RD"]
[null,null,null,null,null,"Miller Electric RS-RD Workpapers.xlsm"]
[null,null,null,null,null,"Miller Natural Gas RS-RD Workpapers.xlsm"]
[null,null,null,"Miller Electric RS-RD Workpapers.pdf"]
[null,null,null,"Miller Natural Gas Cost of Service Workpapers.pdf"]
[null,null,null,"Miller Natural Gas Rev Norm Workpapers.pdf"]
[null,null,null,"Miller Natural Gas RS-RD Workpapers.pdf"]

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