{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Table 1-Revenue Requirement","Table 2-Residential Avg Usage","Table 3 Inputs","Table 3-Current Bill","Table 4-Impact to Avg Bill","EXAMPLES","Table Ex2-Residential Avg Usa","Table Ex3 Inputs","Table Ex3-Current Bill","Table Ex4-Impact to Avg Bill"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":56,"comments":2,"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":"Table 1-Revenue Requirement","index":0,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[3,4,3,6],[2,8,2,10],[3,8,3,10],[6,7,6,11],[7,12,8,12],[7,10,8,10],[7,11,8,11],[2,7,3,7],[2,11,3,11],[2,4,2,6],[7,0,8,0],[7,4,8,4],[7,7,8,7],[7,8,8,8],[7,9,8,9],[7,5,8,5],[7,6,8,6]]}
[]
[]
["Company: ",null,"Filing Date:",null,"Company-Wide Number of Connections \n(As of 12/31/20XX):",null,null,null,"Number of Connections in Ratemaking Area\n (As of 12/31/20XX):"]
["Ratemaking Area:",null,"Filing Year:",{"$f":"YEAR(TODAY())","v":2021},{"$f":"\"(As of 12/31/\"&D4-1&\")\"","v":"(As of 12/31/2020)"},null,null,null,{"$f":"\"(As of 12/31/\"&D4-1&\")\"","v":"(As of 12/31/2020)"}]
[]
[]
[null,null,null,null,null,null,null,"Annual Revenue Requirements (End of Year)"]
[null,"Latest Adopted Company-Wide Revenue Requirement \n(Adopted on XX/XX/XXX Per Filing #)",null,"Latest Adopted Ratemaking Area Revenue Requirement \n(Adopted on XX/XX/XXX Per Filing #)",null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,"$",null,"$"]
["Status","Proceedings ","Footnote Reference","Description of Filing","Revenue Recovery Mechanism ","Effective Date or Proposed Effective Date","Expiration Date or Proposed Expiration Date",{"$f":"D4","v":2021},{"$f":"H10+1","v":2022},{"$f":"I10+1","v":2023},{"$f":"J10+1","v":2024},{"$f":"K10+1","v":2025}]
["Baseline Revenue Requirement (Ratemaking Area)",null,null,null,null,null,null,{"$f":"D9","v":"$"},{"$f":"D9","v":"$"},{"$f":"D9","v":"$"},{"$f":"D9","v":"$"},{"$f":"D9","v":"$"}]
["Active","A.18-XX-XX; D.19-XX-XXX",null,"(e.g. Bal. Acct., IRMA, WRAM)","(e.g., amortization of balancing account, GRC base rate increase, etc.)"]
["Active","A.18-XX-XXX; D.19-XX-XXX"]
["Active","AL # XXXX"]
["Active","AL # XXXX"]
["Active","AL # XXXX"]
["Active","AL # XXXX"]
[null,"USE THIS BUTTON TO ADD ACTIVE FILINGS"]
["Total Active",null,null,null,null,null,null,{"$f":"SUM(H12:H18)","v":0},{"$f":"SUM(I12:I18)","v":0},{"$f":"SUM(J12:J18)","v":0},{"$f":"SUM(K12:K18)","v":0},{"$f":"SUM(L12:L18)","v":0}]
[]
["Pending - Filed","AL # XXXX"]
["Pending - Filed","AL # XXXX"]
["Pending - Filed","AL # XXXX"]
["Pending - Filed","AL # XXXX"]
["Pending - Filed","A.XX-XX-XXX"]
["Pending - Filed","A.XX-XX-XXX"]
["Pending - New Filing","AL # XXXX"]
[null,"USE THIS BUTTON TO ADD PENDING FILINGS"]
["Total Pending ",null,null,null,null,null,null,{"$f":"SUM(H21:H27)","v":0},{"$f":"SUM(I21:I27)","v":0},{"$f":"SUM(J21:J27)","v":0},{"$f":"SUM(K21:K27)","v":0},{"$f":"SUM(L21:L27)","v":0}]
[]
["Anticipated","Advice Letter",null,"IRMA (as appropriate)","No change to stated rev. req."]
["Anticipated","Advice Letter",null,"20XX Estimated Escalation Year Increase, Pending Earnings Test","Base rate increase (est.)"]
["Anticipated","Advice Letter",null,"20XX Estimated Escalation Year Increase, Pending Earnings Test","Base rate increase (est.)"]
["Anticipated","Advice Letter",null,"20XX WRAM/MCBA","Amort. of balancing acct."]
["Anticipated","Advice Letter",null,"20XX WRAM/MCBA","Amort. of balancing acct."]
["Anticipated","Advice Letter",null,"20XX WRAM/MCBA","Amort. of balancing acct."]
["Anticipated","Advice Letter",null,"Supply Cost Offset","Base rate change"]
["Anticipated","Advice Letter",null,"Supply Cost Offset","Base rate change"]
["Anticipated","Advice Letter",null,"Rate base offsets (ALPs)","Base rate increase"]
["Anticipated","Advice Letter",null,"Cost of capital","Base rate change"]
["Anticipated","Application",null,"20XX GRC","Base rate change"]
[null,"USE THIS BUTTON TO ADD ANTICIPATED FILINGS"]
["Total Anticipated",null,null,null,null,null,null,{"$f":"SUM(H31:H42)","v":0},{"$f":"SUM(I31:I42)","v":0},{"$f":"SUM(J31:J42)","v":0},{"$f":"SUM(K31:K42)","v":0},{"$f":"SUM(L31:L42)","v":0}]
["Total Changes to Ratemaking Area Revenue Requirement, Not Including TBD Amounts",null,null,null,null,null,null,{"$f":"H19+H29+H43","v":0},{"$f":"I19+I29+I43","v":0},{"$f":"J19+J29+J43","v":0},{"$f":"K19+K29+K43","v":0},{"$f":"L19+L29+L43","v":0}]
["Total Estimated Ratemaking Area Revenue Requirement, Not Including TBD Amounts",null,null,null,null,null,null,{"$f":"H11+H44","v":{"$error":"#VALUE!"}},{"$f":"I11+I44","v":{"$error":"#VALUE!"}},{"$f":"J11+J44","v":{"$error":"#VALUE!"}},{"$f":"K11+K44","v":{"$error":"#VALUE!"}},{"$f":"L11+L44","v":{"$error":"#VALUE!"}}]
[]
["Footnotes and Assumptions:"]

{"sheet":"Table 2-Residential Avg Usage","index":1,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[17,10,17,11],[17,12,17,13]]}
[]
[null,"Company: ",{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B3),\"\",'Table 1-Revenue Requirement'!B3)","v":""},null,"Filing Date:",{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D3),\"\",'Table 1-Revenue Requirement'!D3)","v":""}]
[null,"Ratemaking Area:",{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B4),\"\",'Table 1-Revenue Requirement'!B4)","v":""},null,"Filing Year:",{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D4),\"\",'Table 1-Revenue Requirement'!D4)","v":2021}]
[]
[null,null,"All Residential Customers","Non-Customer Assistance Program (CAP) Customers","CAP Customers","Tier 1 Usage (up to XX Units/month) for Non-CAP Customers","Tier 1 Usage (up to XX Units/month) for CAP Customers"]
[null,"Total Residential Usage (in units used by service area) in 12 Months (from last GRC filing)",{"$f":"IF(AND(ISBLANK(D6),ISBLANK(E6)),\"\",D6+E6)","v":18000000},15000000,3000000,"N/A","N/A"]
[null,"Total Number of Residential Connections (from last GRC filing)",{"$f":"IF(AND(ISBLANK(D7),ISBLANK(E7)),\"\",D7+E7)","v":121000},100000,21000,"N/A","N/A"]
[null,"Residential Average Annual Usage (in units used by service area) Per Connection, or Tier 1 Annual Usage Amount",{"$f":"IFERROR(C6/C7,\"-\")","v":148.7603305785124},{"$f":"IFERROR(D6/D7,\"-\")","v":150},{"$f":"IFERROR(E6/E7,\"-\")","v":142.85714285714286},{"$f":"IFERROR('Table 3 Inputs'!I7*bills,\"-\")","v":144},{"$f":"MIN(tier1break*12,LIRA_Avg_Usage)","v":142.85714285714286}]
[null,"Current Residential Average Annual Bill","N/A",{"$f":"IFERROR('Table 3-Current Bill'!C24,\"-\")","v":318.12},{"$f":"IFERROR('Table 3-Current Bill'!D24,\"-\")","v":213.30428571428573},{"$f":"'Table 3-Current Bill'!E24","v":304.42},{"$f":"'Table 3-Current Bill'!F24","v":213.30428571428573}]
[]
[]
[null,"Notes and Assumptions:"]

{"sheet":"Table 3 Inputs","index":2,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,null,"Quantity Basis","CCF"]
[]
[null,null,"Variable Charge Calculation",null,null,null,null,null,"Non-CAP Average Use","CAP Average Use"]
[null,null,"Number of Tiers",2,null,null,null,null,{"$f":"IFERROR(Non_LIRA_Avg_Usage/bills,0)","v":12.5},{"$f":"IFERROR(LIRA_Avg_Usage/bills,0)","v":11.904761904761905}]
[null,null,null,"Tier Start",{"$f":"\"Tier End \n(\"&D1&\")\"","v":"Tier End \n(CCF)"},"Tier Width","Non-CAP Tier Rate","CAP Tier Rate","Non-CAP Average Consumption  In Tier","CAP Avg Consumption  in Tier","Average Monthly Bill in Tier","Average CAP Monthly Bill in Tier"]
[null,null,null,null,null,null,"(A)","(B)","(C)","(D)","(E)  = (A) * (C) ","(F) = (B) * (D)"]
[null,1,"Tier 1",{"$f":"IF(D4=1,\"Uniform Rate\",\"0 \"&D1&\" to\")","v":"0 CCF to"},12,{"$f":"IF(D4=1,\"\",E7)","v":12},1,0.9,{"$f":"IF(B7<=$D$4,MIN($F7,I$4),\"\")","v":12},{"$f":"IF(B7<=$D$4,MIN($F7,J$4),\"\")","v":11.904761904761905},{"$f":"IF($B7<=$D$4,I7*G7,\"\")","v":12},{"$f":"H7*J7","v":10.714285714285715}]
[null,2,{"$f":"IF($B8<=$D$4,\"Tier \"&B8,\"\")","v":"Tier 2"},{"$f":"IF($B8<$D$4,E7&\" \"&$D$1&\" to\",IF($B8=D$4,\"Over \"&E7&\" \"&$D$1,\"\"))","v":"Over 12 CCF"},null,{"$f":"IF($B8<$D$4,E8-E7,\"\")","v":""},2,2,{"$f":"IF(B8<=$D$4,MIN(I$4-SUM(I$7:I7),$F8),\"\")","v":0.5},{"$f":"IF(B8<=$D$4,MIN(J$4-SUM(J$7:J7),$F8),\"\")","v":0},1,{"$f":"H8*J8","v":0}]
[null,3,"","",null,"",null,null,{"$f":"IF(B9<=$D$4,MIN(I$4-SUM(I$7:I8),$F9),\"\")","v":""},{"$f":"IF(B9<=$D$4,MIN(J$4-SUM(J$7:J8),$F9),\"\")","v":""},{"$f":"IF($B9<=$D$4,I9*G9,\"\")","v":""},{"$f":"IF($B9<=$D$4,J9*IF(#REF!=\"percentage\",G9*(1-#REF!),H9),\"\")","v":""}]
[null,4,"","",null,"",null,null,{"$f":"IF(B10<=$D$4,MIN(I$4-SUM(I$7:I9),$F10),\"\")","v":""},{"$f":"IF(B10<=$D$4,MIN(J$4-SUM(J$7:J9),$F10),\"\")","v":""},"",{"$f":"IF($B10<=$D$4,J10*IF(#REF!=\"percentage\",G10*(1-#REF!),H10),\"\")","v":""}]
[null,5,"","",null,"",null,null,{"$f":"IF(B11<=$D$4,MIN(I$4-SUM(I$7:I10),$F11),\"\")","v":""},{"$f":"IF(B11<=$D$4,MIN(J$4-SUM(J$7:J10),$F11),\"\")","v":""},"",{"$f":"IF($B11<=$D$4,J11*IF(#REF!=\"percentage\",G11*(1-#REF!),H11),\"\")","v":""}]
[null,6,"","",null,"",null,null,{"$f":"IF(B12<=$D$4,MIN(I$4-SUM(I$7:I11),$F12),\"\")","v":""},{"$f":"IF(B12<=$D$4,MIN(J$4-SUM(J$7:J11),$F12),\"\")","v":""},"",{"$f":"IF($B12<=$D$4,J12*IF(#REF!=\"percentage\",G12*(1-#REF!),H12),\"\")","v":""}]
[null,7,"","",null,"",null,null,{"$f":"IF(B13<=$D$4,MIN(I$4-SUM(I$7:I12),$F13),\"\")","v":""},{"$f":"IF(B13<=$D$4,MIN(J$4-SUM(J$7:J12),$F13),\"\")","v":""},"",{"$f":"IF($B13<=$D$4,J13*IF(#REF!=\"percentage\",G13*(1-#REF!),H13),\"\")","v":""}]
[null,8,"","",null,"",null,null,{"$f":"IF(B14<=$D$4,MIN(I$4-SUM(I$7:I13),$F14),\"\")","v":""},{"$f":"IF(B14<=$D$4,MIN(J$4-SUM(J$7:J13),$F14),\"\")","v":""},"",{"$f":"IF($B14<=$D$4,J14*IF(#REF!=\"percentage\",G14*(1-#REF!),H14),\"\")","v":""}]
[null,9,"","",null,"",null,null,{"$f":"IF(B15<=$D$4,MIN(I$4-SUM(I$7:I14),$F15),\"\")","v":""},{"$f":"IF(B15<=$D$4,MIN(J$4-SUM(J$7:J14),$F15),\"\")","v":""},"",{"$f":"IF($B15<=$D$4,J15*IF(#REF!=\"percentage\",G15*(1-#REF!),H15),\"\")","v":""}]
[null,10,"","",null,"",null,null,{"$f":"IF(B16<=$D$4,MIN(I$4-SUM(I$7:I15),$F16),\"\")","v":""},{"$f":"IF(B16<=$D$4,MIN(J$4-SUM(J$7:J15),$F16),\"\")","v":""},"",{"$f":"IF($B16<=$D$4,J16*IF(#REF!=\"percentage\",G16*(1-#REF!),H16),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K7:K16)","v":13},{"$f":"SUM(L7:L16)","v":10.714285714285715}]
[]
[null,null,"Monthly Fixed Charge Calculation"]
[null,null,"Most Common Residential Meter","5/8\" x 3/4\""]
[null,null,null,"Non-CAP Fixed Charge","CAP Fixed Charge (prior to credit or discount)"]
[null,null,{"$f":"D20&\" Fixed Charges\"","v":"5/8\" x 3/4\" Fixed Charges"},10,10]
[]
[null,null,"Surcharges, Credits, Fees and Taxes","Type of Charge","Amount of Charge (Non-CAP)","Amount of Charge (CAP)","Number of Months in Effect"]
[null,null,"CAP Credit","Fixed",null,-5,12]
[null,null,"CAP Surcharge","Variable",0.1,null,12]
[null,null,"Temporary Surcharge 1","Variable",0.2,0.2,9]
[null,null,"Temporary Surcharge 2","Variable",0.01,0.01,6]
[null,null,"…","Fixed",null,null,12]
[null,null,"…","Fixed",null,null,12]

{"sheet":"Table 3-Current Bill","index":3,"n_rows":79,"n_cols":7,"rows_kept":79,"cut":false,"hidden":false,"merged":[[4,1,4,6],[26,1,26,6],[64,1,64,6],[65,2,65,3],[65,4,65,5],[49,2,49,3],[49,4,49,5],[56,2,56,3],[56,4,56,5],[5,2,5,3],[5,4,5,5],[27,2,27,3],[27,4,27,5],[48,1,48,6]]}
[]
[null,"Company: ",{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B3),\"\",'Table 1-Revenue Requirement'!B3)","v":""},null,null,"Filing Date:",{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D3),\"\",'Table 1-Revenue Requirement'!D3)","v":""}]
[null,"Ratemaking Area:",null,null,null,"Filing Year:",{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D4),\"\",'Table 1-Revenue Requirement'!D4)","v":2021}]
[]
[null,{"$f":"\"Average Annual Bill Calculation for Residential \"&'Table 3 Inputs'!D20&\" Meter as of the filing date:\"","v":"Average Annual Bill Calculation for Residential 5/8\" x 3/4\" Meter as of the filing date:"}]
[null,null,"Average Usage",null,"Tier 1 Usage",null,"Appropriate Rate"]
[null,null,"Non-CAP","CAP","Non-CAP","CAP"]
[null,"Usage (Ccfs/Year)",{"$f":"Non_LIRA_Avg_Usage","v":150},{"$f":"LIRA_Avg_Usage","v":142.85714285714286},{"$f":"Non_LIRA_Tier_1_Usage","v":144},{"$f":"LIRA_Tier_1_Usage","v":142.85714285714286}," (Incl. Start and Expiration Date as Appropriate)"]
[]
[null,"Service Charge",{"$f":"'Table 3 Inputs'!D22*bills","v":120},{"$f":"'Table 3 Inputs'!E22*bills","v":120},{"$f":"'Table 3 Inputs'!D22*bills","v":120},{"$f":"'Table 3 Inputs'!E22*bills","v":120},"$XX.XX per month or bimonthly"]
[null,"Quantity Charge",{"$f":"IFERROR(SUMPRODUCT('Table 3 Inputs'!G7:G16,'Table 3 Inputs'!I7:I16)*bills,0)","v":156},{"$f":"IFERROR('Table 3 Inputs'!L17*bills,0)","v":128.57142857142858},{"$f":"IFERROR('Table 3 Inputs'!$F$7*'Table 3 Inputs'!G7*bills,0)","v":144},{"$f":"IFERROR('Table 3 Inputs'!L7*bills,0)","v":128.57142857142858},"$XX.XX per CCF"]
[null,"Subtotal:",{"$f":"SUBTOTAL(9,C10:C11)","v":276},{"$f":"SUBTOTAL(9,D10:D11)","v":248.57142857142858},{"$f":"SUBTOTAL(9,E10:E11)","v":264},{"$f":"SUBTOTAL(9,F10:F11)","v":248.57142857142858}]
[null,"Relevant Surcharges, Credits, Fees and Taxes"]
[null,{"$f":"'Table 3 Inputs'!C25","v":"CAP Credit"},{"$f":"IF('Table 3 Inputs'!$D25=\"Fixed\",'Table 3 Inputs'!$E25*bills*('Table 3 Inputs'!$G25/bills),'Table 3 Inputs'!$E25*C$8*('Table 3 Inputs'!$G25/bills))","v":0},{"$f":"IF('Table 3 Inputs'!$D25=\"Fixed\",'Table 3 Inputs'!$F25*bills*('Table 3 Inputs'!$G25/bills),'Table 3 Inputs'!$F25*D$8*('Table 3 Inputs'!$G25/bills))","v":-60},{"$f":"IF('Table 3 Inputs'!$D25=\"Fixed\",'Table 3 Inputs'!$E25*bills*('Table 3 Inputs'!$G25/bills),'Table 3 Inputs'!$E25*E$8*('Table 3 Inputs'!$G25/bills))","v":0},{"$f":"IF('Table 3 Inputs'!$D25=\"Fixed\",'Table 3 Inputs'!$F25*bills*('Table 3 Inputs'!$G25/bills),'Table 3 Inputs'!$F25*F$8*('Table 3 Inputs'!$G25/bills))","v":-60},{"$f":"IF('Table 3 Inputs'!D25=\"Fixed\",\"$\"&'Table 3 Inputs'!E25&\" per month\",\"$\"&'Table 3 Inputs'!E25&\" per \"&'Table 3 Inputs'!$D$1)","v":"$ per month"}]
[null,{"$f":"'Table 3 Inputs'!C26","v":"CAP Surcharge"},{"$f":"IF('Table 3 Inputs'!$D26=\"Fixed\",'Table 3 Inputs'!$E26*bills*('Table 3 Inputs'!$G26/bills),'Table 3 Inputs'!$E26*C$8*('Table 3 Inputs'!$G26/bills))","v":15},{"$f":"IF('Table 3 Inputs'!$D26=\"Fixed\",'Table 3 Inputs'!$F26*bills*('Table 3 Inputs'!$G26/bills),'Table 3 Inputs'!$F26*D$8*('Table 3 Inputs'!$G26/bills))","v":0},{"$f":"IF('Table 3 Inputs'!$D26=\"Fixed\",'Table 3 Inputs'!$E26*bills*('Table 3 Inputs'!$G26/bills),'Table 3 Inputs'!$E26*E$8*('Table 3 Inputs'!$G26/bills))","v":14.4},{"$f":"IF('Table 3 Inputs'!$D26=\"Fixed\",'Table 3 Inputs'!$F26*bills*('Table 3 Inputs'!$G26/bills),'Table 3 Inputs'!$F26*F$8*('Table 3 Inputs'!$G26/bills))","v":0},{"$f":"IF('Table 3 Inputs'!D26=\"Fixed\",\"$\"&'Table 3 Inputs'!E26&\" per month\",\"$\"&'Table 3 Inputs'!E26&\" per \"&'Table 3 Inputs'!$D$1)","v":"$0.1 per CCF"}]
[null,{"$f":"'Table 3 Inputs'!C27","v":"Temporary Surcharge 1"},{"$f":"IF('Table 3 Inputs'!$D27=\"Fixed\",'Table 3 Inputs'!$E27*bills*('Table 3 Inputs'!$G27/bills),'Table 3 Inputs'!$E27*C$8*('Table 3 Inputs'!$G27/bills))","v":22.5},{"$f":"IF('Table 3 Inputs'!$D27=\"Fixed\",'Table 3 Inputs'!$F27*bills*('Table 3 Inputs'!$G27/bills),'Table 3 Inputs'!$F27*D$8*('Table 3 Inputs'!$G27/bills))","v":21.428571428571431},{"$f":"IF('Table 3 Inputs'!$D27=\"Fixed\",'Table 3 Inputs'!$E27*bills*('Table 3 Inputs'!$G27/bills),'Table 3 Inputs'!$E27*E$8*('Table 3 Inputs'!$G27/bills))","v":21.6},{"$f":"IF('Table 3 Inputs'!$D27=\"Fixed\",'Table 3 Inputs'!$F27*bills*('Table 3 Inputs'!$G27/bills),'Table 3 Inputs'!$F27*F$8*('Table 3 Inputs'!$G27/bills))","v":21.428571428571431},{"$f":"IF('Table 3 Inputs'!D27=\"Fixed\",\"$\"&'Table 3 Inputs'!E27&\" per month\",\"$\"&'Table 3 Inputs'!E27&\" per \"&'Table 3 Inputs'!$D$1)","v":"$0.2 per CCF"}]
[null,{"$f":"'Table 3 Inputs'!C28","v":"Temporary Surcharge 2"},{"$f":"IF('Table 3 Inputs'!$D28=\"Fixed\",'Table 3 Inputs'!$E28*bills*('Table 3 Inputs'!$G28/bills),'Table 3 Inputs'!$E28*C$8*('Table 3 Inputs'!$G28/bills))","v":0.75},{"$f":"IF('Table 3 Inputs'!$D28=\"Fixed\",'Table 3 Inputs'!$F28*bills*('Table 3 Inputs'!$G28/bills),'Table 3 Inputs'!$F28*D$8*('Table 3 Inputs'!$G28/bills))","v":0.7142857142857143},{"$f":"IF('Table 3 Inputs'!$D28=\"Fixed\",'Table 3 Inputs'!$E28*bills*('Table 3 Inputs'!$G28/bills),'Table 3 Inputs'!$E28*E$8*('Table 3 Inputs'!$G28/bills))","v":0.72},{"$f":"IF('Table 3 Inputs'!$D28=\"Fixed\",'Table 3 Inputs'!$F28*bills*('Table 3 Inputs'!$G28/bills),'Table 3 Inputs'!$F28*F$8*('Table 3 Inputs'!$G28/bills))","v":0.7142857142857143},{"$f":"IF('Table 3 Inputs'!D28=\"Fixed\",\"$\"&'Table 3 Inputs'!E28&\" per month\",\"$\"&'Table 3 Inputs'!E28&\" per \"&'Table 3 Inputs'!$D$1)","v":"$0.01 per CCF"}]
[null,{"$f":"'Table 3 Inputs'!C29","v":"…"},{"$f":"IF('Table 3 Inputs'!$D29=\"Fixed\",'Table 3 Inputs'!$E29*bills*('Table 3 Inputs'!$G29/bills),'Table 3 Inputs'!$E29*C$8*('Table 3 Inputs'!$G29/bills))","v":0},{"$f":"IF('Table 3 Inputs'!$D29=\"Fixed\",'Table 3 Inputs'!$F29*bills*('Table 3 Inputs'!$G29/bills),'Table 3 Inputs'!$F29*D$8*('Table 3 Inputs'!$G29/bills))","v":0},{"$f":"IF('Table 3 Inputs'!$D29=\"Fixed\",'Table 3 Inputs'!$E29*bills*('Table 3 Inputs'!$G29/bills),'Table 3 Inputs'!$E29*E$8*('Table 3 Inputs'!$G29/bills))","v":0},{"$f":"IF('Table 3 Inputs'!$D29=\"Fixed\",'Table 3 Inputs'!$F29*bills*('Table 3 Inputs'!$G29/bills),'Table 3 Inputs'!$F29*F$8*('Table 3 Inputs'!$G29/bills))","v":0},{"$f":"IF('Table 3 Inputs'!D29=\"Fixed\",\"$\"&'Table 3 Inputs'!E29&\" per month\",\"$\"&'Table 3 Inputs'!E29&\" per \"&'Table 3 Inputs'!$D$1)","v":"$ per month"}]
[null,{"$f":"'Table 3 Inputs'!C30","v":"…"},{"$f":"IF('Table 3 Inputs'!$D30=\"Fixed\",'Table 3 Inputs'!$E30*bills*('Table 3 Inputs'!$G30/bills),'Table 3 Inputs'!$E30*C$8*('Table 3 Inputs'!$G30/bills))","v":0},{"$f":"IF('Table 3 Inputs'!$D30=\"Fixed\",'Table 3 Inputs'!$F30*bills*('Table 3 Inputs'!$G30/bills),'Table 3 Inputs'!$F30*D$8*('Table 3 Inputs'!$G30/bills))","v":0},{"$f":"IF('Table 3 Inputs'!$D30=\"Fixed\",'Table 3 Inputs'!$E30*bills*('Table 3 Inputs'!$G30/bills),'Table 3 Inputs'!$E30*E$8*('Table 3 Inputs'!$G30/bills))","v":0},{"$f":"IF('Table 3 Inputs'!$D30=\"Fixed\",'Table 3 Inputs'!$F30*bills*('Table 3 Inputs'!$G30/bills),'Table 3 Inputs'!$F30*F$8*('Table 3 Inputs'!$G30/bills))","v":0},{"$f":"IF('Table 3 Inputs'!D30=\"Fixed\",\"$\"&'Table 3 Inputs'!E30&\" per month\",\"$\"&'Table 3 Inputs'!E30&\" per \"&'Table 3 Inputs'!$D$1)","v":"$ per month"}]
[]
[null,"Subtotal:",{"$f":"SUBTOTAL(9,C14:C20)","v":38.25},{"$f":"SUBTOTAL(9,D14:D20)","v":-37.857142857142854},{"$f":"SUBTOTAL(9,E14:E20)","v":36.72},{"$f":"SUBTOTAL(9,F14:F20)","v":-37.857142857142854}]
[null,"CPUC Fee",{"$f":"ROUND((SUM(C12,C21)*0.0123),2)","v":3.87},{"$f":"ROUND((SUM(D12,D21)*0.0123),2)","v":2.59},{"$f":"ROUND((SUM(E12,E21)*0.0123),2)","v":3.7},{"$f":"ROUND((SUM(F12,F21)*0.0123),2)","v":2.59},"1.23%"]
[]
[null,{"$f":"\"Total Avg. Annual Bill for \"&G3&\":\"","v":"Total Avg. Annual Bill for 2021:"},{"$f":"SUBTOTAL(9,C10:C22)","v":318.12},{"$f":"SUBTOTAL(9,D10:D22)","v":213.30428571428573},{"$f":"SUBTOTAL(9,E10:E22)","v":304.42},{"$f":"SUBTOTAL(9,F10:F22)","v":213.30428571428573}]
[]
[]
[null,{"$f":"\"Average Monthly Bill Calculation for Residential \"&'Table 3 Inputs'!D20&\" Meter as of the filing date:\"","v":"Average Monthly Bill Calculation for Residential 5/8\" x 3/4\" Meter as of the filing date:"}]
[null,null,"Average Usage",null,"Tier 1 Usage",null,"Appropriate Rate"]
[null,null,"Non-CAP","CAP","Non-CAP","CAP"]
[null,"Usage (Ccfs/Month)",{"$f":"IFERROR(Non_LIRA_Avg_Usage/12,\"-\")","v":12.5},{"$f":"IFERROR(LIRA_Avg_Usage/12,\"-\")","v":11.904761904761905},{"$f":"IFERROR(Non_LIRA_Tier_1_Usage/12,\"-\")","v":12},{"$f":"IFERROR(LIRA_Tier_1_Usage/12,\"-\")","v":11.904761904761905}," (Incl. Start and Expiration Date as Appropriate)"]
[]
[null,"Service Charge",{"$f":"'Table 3 Inputs'!D$22*(bills/12)","v":10},{"$f":"'Table 3 Inputs'!E$22*(bills/12)","v":10},{"$f":"'Table 3 Inputs'!D$22*bills/12","v":10},{"$f":"'Table 3 Inputs'!E$22*bills/12","v":10},"$XX.XX per month"]
[null,"Quantity Charge",{"$f":"C11/12","v":13},{"$f":"D11/12","v":10.714285714285715},{"$f":"'Table 3 Inputs'!$F$7*'Table 3 Inputs'!G7","v":12},{"$f":"'Table 3 Inputs'!$L$7","v":10.714285714285715},"$XX.XX per CCF"]
[null,"Subtotal:",{"$f":"SUBTOTAL(9,C32:C33)","v":23},{"$f":"SUBTOTAL(9,D32:D33)","v":20.714285714285715},{"$f":"SUBTOTAL(9,E32:E33)","v":22},{"$f":"SUBTOTAL(9,F32:F33)","v":20.714285714285715}]
[null,"Relevant Surcharges, Credits, Fees and Taxes"]
[null,{"$f":"'Table 3 Inputs'!C25","v":"CAP Credit"},{"$f":"C14/12","v":0},-5,0,-5,{"$f":"IF('Table 3 Inputs'!D25=\"Fixed\",\"$\"&'Table 3 Inputs'!E25&\" per month\",\"$\"&'Table 3 Inputs'!E25&\" per \"&'Table 3 Inputs'!$D$1)","v":"$ per month"}]
[null,{"$f":"'Table 3 Inputs'!C26","v":"CAP Surcharge"},1.25,0,1.2,0,{"$f":"IF('Table 3 Inputs'!D26=\"Fixed\",\"$\"&'Table 3 Inputs'!E26&\" per month\",\"$\"&'Table 3 Inputs'!E26&\" per \"&'Table 3 Inputs'!$D$1)","v":"$0.1 per CCF"}]
[null,{"$f":"'Table 3 Inputs'!C27","v":"Temporary Surcharge 1"},1.875,1.7857142857142858,1.8,1.7857142857142858,{"$f":"IF('Table 3 Inputs'!D27=\"Fixed\",\"$\"&'Table 3 Inputs'!E27&\" per month\",\"$\"&'Table 3 Inputs'!E27&\" per \"&'Table 3 Inputs'!$D$1)","v":"$0.2 per CCF"}]
[null,{"$f":"'Table 3 Inputs'!C28","v":"Temporary Surcharge 2"},6.25E-2,5.9523809523809527E-2,0.06,5.9523809523809527E-2,{"$f":"IF('Table 3 Inputs'!D28=\"Fixed\",\"$\"&'Table 3 Inputs'!E28&\" per month\",\"$\"&'Table 3 Inputs'!E28&\" per \"&'Table 3 Inputs'!$D$1)","v":"$0.01 per CCF"}]
[null,{"$f":"'Table 3 Inputs'!C29","v":"…"},0,0,0,0,{"$f":"IF('Table 3 Inputs'!D29=\"Fixed\",\"$\"&'Table 3 Inputs'!E29&\" per month\",\"$\"&'Table 3 Inputs'!E29&\" per \"&'Table 3 Inputs'!$D$1)","v":"$ per month"}]
[null,{"$f":"'Table 3 Inputs'!C30","v":"…"},0,0,0,0,{"$f":"IF('Table 3 Inputs'!D30=\"Fixed\",\"$\"&'Table 3 Inputs'!E30&\" per month\",\"$\"&'Table 3 Inputs'!E30&\" per \"&'Table 3 Inputs'!$D$1)","v":"$ per month"}]
[]
[null,"Subtotal:",{"$f":"SUBTOTAL(9,C36:C42)","v":3.1875},{"$f":"SUBTOTAL(9,D36:D42)","v":-3.1547619047619051},{"$f":"SUBTOTAL(9,E36:E42)","v":3.06},{"$f":"SUBTOTAL(9,F36:F42)","v":-3.1547619047619051}]
[null,"CPUC Fee",{"$f":"ROUND((SUM(C34,C43)*0.0123),2)","v":0.32},{"$f":"ROUND((SUM(D34,D43)*0.0123),2)","v":0.22},{"$f":"ROUND((SUM(E34,E43)*0.0123),2)","v":0.31},{"$f":"ROUND((SUM(F34,F43)*0.0123),2)","v":0.22},"1.23%"]
[]
[null,"Total Avg. Monthly Bill for July 2019:",{"$f":"SUBTOTAL(9,C32:C44)","v":26.5075},{"$f":"SUBTOTAL(9,D32:D44)","v":17.779523809523809},{"$f":"SUBTOTAL(9,E32:E44)","v":25.369999999999997},{"$f":"SUBTOTAL(9,F32:F44)","v":17.779523809523809}]
[]
[]
[null,{"$f":"\"Estimated Incremental Annual Bill Impact for Residential \"&'Table 3 Inputs'!D20&\" Meter with \"&B50&\" and \"&B57&\" Rate Escalation related to \"&B50-1&\" GRC:\"","v":"Estimated Incremental Annual Bill Impact for Residential 5/8\" x 3/4\" Meter with 2020 and 2021 Rate Escalation related to 2019 GRC:"}]
[null,2020,"Average Usage",null,"Tier 1 Usage"]
[null,null,"Non-CAP","CAP","Non-CAP","CAP"]
[null,"Service Charge",null,null,null,null,"From $X.XX to $X.XX per month"]
[null,"Quantity Charge",null,null,null,null,"From $X.XXX to $X.XXX per CCF"]
[]
[null,"Increm. Ann. Impact",{"$f":"SUM(C52:C54)","v":0},{"$f":"SUM(D52:D54)","v":0},{"$f":"SUM(E52:E54)","v":0},{"$f":"SUM(F52:F54)","v":0}]
[]
[null,2021,"Average Usage",null,"Tier 1 Usage"]
[null,null,"Non-CAP","CAP","Non-CAP","CAP"]
[null,"Service Charge",null,null,null,null,"From $X.XX to $X.XX per month"]
[null,"Quantity Charge",null,null,null,null,"From $X.XXX to $X.XXX per CCF"]
[]
[null,"Increm. Ann. Impact",{"$f":"SUM(C59:C61)","v":0},{"$f":"SUM(D59:D61)","v":0},{"$f":"SUM(E59:E61)","v":0},{"$f":"SUM(F59:F61)","v":0}]
[]
[]
[null,{"$f":"\"Estimated Incremental Monthly Bill Impact for Residential \"&'Table 3 Inputs'!D20&\" Meter with \"&B50&\" and \"&B57&\" Rate Escalation related to \"&B50-1&\" GRC as of the filing date:\"","v":"Estimated Incremental Monthly Bill Impact for Residential 5/8\" x 3/4\" Meter with 2020 and 2021 Rate Escalation related to 2019 GRC as of the filing date:"}]
[null,"Month/Year","Average Usage",null,"Tier 1 Usage"]
[null,null,"Non-CAP","CAP","Non-CAP","CAP"]
[null,"Service Charge",null,null,null,null,"From $X.XX to $X.XX per month"]
[null,"Quantity Charge",null,null,null,null,"From $X.XXX to $X.XXX per CCF"]
[]
[null,"Increm. Ann. Impact",{"$f":"SUM(C68:C70)","v":0},{"$f":"SUM(D68:D70)","v":0},{"$f":"SUM(E68:E70)","v":0},{"$f":"SUM(F68:F70)","v":0}]
[]
[]
[null,"Notes and Assumptions:"]
[null,"CPUC User Fee of 1.23% corresponds to the most recent resolution setting the User Fee (i.e., Resolution M-4839). Update as necessary."]
[null,{"$f":"\"Current Residential Average Annual Bill based on most common residential meter size for RMA, which is \"&'Table 3 Inputs'!D20&\".\"","v":"Current Residential Average Annual Bill based on most common residential meter size for RMA, which is 5/8\" x 3/4\"."}]
[null,"Average annual bill calculated with all surcharges, fees, etc. active as of form submission date."]
[null,"Average annual bill above does not include any pending or anticipated filings."]
[null,"City tax on water utility services (percentage of bill amount) ranges from __% to __ % within the RMA, no city tax amount included in average bill above since most areas are not assessed a tax on water services."]

{"sheet":"Table 4-Impact to Avg Bill","index":4,"n_rows":155,"n_cols":13,"rows_kept":155,"cut":false,"hidden":false,"merged":[[3,8,3,12],[3,1,3,7],[40,1,40,7],[77,1,77,7],[114,1,114,7]]}
[null,"Company: ",{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B3),\"\",'Table 1-Revenue Requirement'!B3)","v":""},null,null,"Filing Date:",{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D3),\"\",'Table 1-Revenue Requirement'!D3)","v":""}]
[null,"Ratemaking Area:",{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B4),\"\",'Table 1-Revenue Requirement'!B4)","v":""},null,null,"Filing Year:",{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D4),\"\",'Table 1-Revenue Requirement'!D4)","v":2021}]
[]
[null,"Non-CAP Residential Customers - Average Usage",null,null,null,null,null,null,"Annual Bill Impacts \n(For Both Non-CAP and CAP Customers at Average and Tier 1 Usage Amounts)"]
[null,"Status","Proceedings ","Footnote Reference","Description of Filing","Revenue Recovery Mechanism ","Effective Date or Proposed Effective Date","Expiration Date or Proposed Expiration Date",{"$f":"G2","v":2021},{"$f":"I5+1","v":2022},{"$f":"J5+1","v":2023},{"$f":"K5+1","v":2024},{"$f":"L5+1","v":2025}]
[null,"Baseline bill (incl. service & quantity charges)","D.XX-XX-XXX/A. or AL",null,null,null,null,null,{"$f":"Baseline_Bill_Non_LIRA_Avg","v":276},{"$f":"Baseline_Bill_Non_LIRA_Avg","v":276},{"$f":"Baseline_Bill_Non_LIRA_Avg","v":276},{"$f":"Baseline_Bill_Non_LIRA_Avg","v":276},{"$f":"Baseline_Bill_Non_LIRA_Avg","v":276}]
[null,"Active",{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B12),\"\",'Table 1-Revenue Requirement'!B12)","v":"A.18-XX-XX; D.19-XX-XXX"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C12),\"\",'Table 1-Revenue Requirement'!C12)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D12),\"\",'Table 1-Revenue Requirement'!D12)","v":"(e.g. Bal. Acct., IRMA, WRAM)"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E12),\"\",'Table 1-Revenue Requirement'!E12)","v":"(e.g., amortization of balancing account, GRC base rate increase, etc.)"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F12),\"\",'Table 1-Revenue Requirement'!F12)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G12),\"\",'Table 1-Revenue Requirement'!G12)","v":""}]
[null,"Active",{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B13),\"\",'Table 1-Revenue Requirement'!B13)","v":"A.18-XX-XXX; D.19-XX-XXX"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C13),\"\",'Table 1-Revenue Requirement'!C13)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D13),\"\",'Table 1-Revenue Requirement'!D13)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E13),\"\",'Table 1-Revenue Requirement'!E13)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F13),\"\",'Table 1-Revenue Requirement'!F13)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G13),\"\",'Table 1-Revenue Requirement'!G13)","v":""}]
[null,"Active",{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B14),\"\",'Table 1-Revenue Requirement'!B14)","v":"AL # XXXX"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C14),\"\",'Table 1-Revenue Requirement'!C14)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D14),\"\",'Table 1-Revenue Requirement'!D14)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E14),\"\",'Table 1-Revenue Requirement'!E14)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F14),\"\",'Table 1-Revenue Requirement'!F14)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G14),\"\",'Table 1-Revenue Requirement'!G14)","v":""}]
[null,"Active",{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B15),\"\",'Table 1-Revenue Requirement'!B15)","v":"AL # XXXX"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C15),\"\",'Table 1-Revenue Requirement'!C15)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D15),\"\",'Table 1-Revenue Requirement'!D15)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E15),\"\",'Table 1-Revenue Requirement'!E15)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F15),\"\",'Table 1-Revenue Requirement'!F15)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G15),\"\",'Table 1-Revenue Requirement'!G15)","v":""}]
[null,"Active",{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B16),\"\",'Table 1-Revenue Requirement'!B16)","v":"AL # XXXX"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C16),\"\",'Table 1-Revenue Requirement'!C16)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D16),\"\",'Table 1-Revenue Requirement'!D16)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E16),\"\",'Table 1-Revenue Requirement'!E16)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F16),\"\",'Table 1-Revenue Requirement'!F16)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G16),\"\",'Table 1-Revenue Requirement'!G16)","v":""}]
[null,"Active",{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B17),\"\",'Table 1-Revenue Requirement'!B17)","v":"AL # XXXX"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C17),\"\",'Table 1-Revenue Requirement'!C17)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D17),\"\",'Table 1-Revenue Requirement'!D17)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E17),\"\",'Table 1-Revenue Requirement'!E17)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F17),\"\",'Table 1-Revenue Requirement'!F17)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G17),\"\",'Table 1-Revenue Requirement'!G17)","v":""}]
[null,null,null,{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C18),\"\",'Table 1-Revenue Requirement'!C18)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D18),\"\",'Table 1-Revenue Requirement'!D18)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E18),\"\",'Table 1-Revenue Requirement'!E18)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F18),\"\",'Table 1-Revenue Requirement'!F18)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G18),\"\",'Table 1-Revenue Requirement'!G18)","v":""}]
[null,"Total Active",null,null,null,null,null,null,{"$f":"SUM(I7:I13)","v":0},{"$f":"SUM(J7:J13)","v":0},{"$f":"SUM(K7:K13)","v":0},{"$f":"SUM(L7:L13)","v":0},{"$f":"SUM(M7:M13)","v":0}]
[null,{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!A20),\"\",'Table 1-Revenue Requirement'!A20)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B20),\"\",'Table 1-Revenue Requirement'!B20)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C20),\"\",'Table 1-Revenue Requirement'!C20)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D20),\"\",'Table 1-Revenue Requirement'!D20)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E20),\"\",'Table 1-Revenue Requirement'!E20)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F20),\"\",'Table 1-Revenue Requirement'!F20)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G20),\"\",'Table 1-Revenue Requirement'!G20)","v":""}]
[null,{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!A21),\"\",'Table 1-Revenue Requirement'!A21)","v":"Pending - Filed"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B21),\"\",'Table 1-Revenue Requirement'!B21)","v":"AL # XXXX"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C21),\"\",'Table 1-Revenue Requirement'!C21)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D21),\"\",'Table 1-Revenue Requirement'!D21)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E21),\"\",'Table 1-Revenue Requirement'!E21)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F21),\"\",'Table 1-Revenue Requirement'!F21)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G21),\"\",'Table 1-Revenue Requirement'!G21)","v":""}]
[null,{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!A22),\"\",'Table 1-Revenue Requirement'!A22)","v":"Pending - Filed"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B22),\"\",'Table 1-Revenue Requirement'!B22)","v":"AL # XXXX"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C22),\"\",'Table 1-Revenue Requirement'!C22)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D22),\"\",'Table 1-Revenue Requirement'!D22)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E22),\"\",'Table 1-Revenue Requirement'!E22)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F22),\"\",'Table 1-Revenue Requirement'!F22)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G22),\"\",'Table 1-Revenue Requirement'!G22)","v":""}]
[null,{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!A23),\"\",'Table 1-Revenue Requirement'!A23)","v":"Pending - Filed"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B23),\"\",'Table 1-Revenue Requirement'!B23)","v":"AL # XXXX"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C23),\"\",'Table 1-Revenue Requirement'!C23)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D23),\"\",'Table 1-Revenue Requirement'!D23)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E23),\"\",'Table 1-Revenue Requirement'!E23)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F23),\"\",'Table 1-Revenue Requirement'!F23)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G23),\"\",'Table 1-Revenue Requirement'!G23)","v":""}]
[null,{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!A24),\"\",'Table 1-Revenue Requirement'!A24)","v":"Pending - Filed"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B24),\"\",'Table 1-Revenue Requirement'!B24)","v":"AL # XXXX"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C24),\"\",'Table 1-Revenue Requirement'!C24)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D24),\"\",'Table 1-Revenue Requirement'!D24)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E24),\"\",'Table 1-Revenue Requirement'!E24)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F24),\"\",'Table 1-Revenue Requirement'!F24)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G24),\"\",'Table 1-Revenue Requirement'!G24)","v":""}]
[null,{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!A25),\"\",'Table 1-Revenue Requirement'!A25)","v":"Pending - Filed"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B25),\"\",'Table 1-Revenue Requirement'!B25)","v":"A.XX-XX-XXX"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C25),\"\",'Table 1-Revenue Requirement'!C25)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D25),\"\",'Table 1-Revenue Requirement'!D25)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E25),\"\",'Table 1-Revenue Requirement'!E25)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F25),\"\",'Table 1-Revenue Requirement'!F25)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G25),\"\",'Table 1-Revenue Requirement'!G25)","v":""}]
[null,{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!A26),\"\",'Table 1-Revenue Requirement'!A26)","v":"Pending - Filed"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B26),\"\",'Table 1-Revenue Requirement'!B26)","v":"A.XX-XX-XXX"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C26),\"\",'Table 1-Revenue Requirement'!C26)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D26),\"\",'Table 1-Revenue Requirement'!D26)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E26),\"\",'Table 1-Revenue Requirement'!E26)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F26),\"\",'Table 1-Revenue Requirement'!F26)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G26),\"\",'Table 1-Revenue Requirement'!G26)","v":""}]
[null,{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!A27),\"\",'Table 1-Revenue Requirement'!A27)","v":"Pending - New Filing"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B27),\"\",'Table 1-Revenue Requirement'!B27)","v":"AL # XXXX"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C27),\"\",'Table 1-Revenue Requirement'!C27)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D27),\"\",'Table 1-Revenue Requirement'!D27)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E27),\"\",'Table 1-Revenue Requirement'!E27)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F27),\"\",'Table 1-Revenue Requirement'!F27)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G27),\"\",'Table 1-Revenue Requirement'!G27)","v":""}]
[null,"Total Pending ",null,null,null,null,null,null,{"$f":"SUM(I16:I22)","v":0},{"$f":"SUM(J16:J22)","v":0},{"$f":"SUM(K16:K22)","v":0},{"$f":"SUM(L16:L22)","v":0},{"$f":"SUM(M16:M22)","v":0}]
[null,{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!A30),\"\",'Table 1-Revenue Requirement'!A30)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B30),\"\",'Table 1-Revenue Requirement'!B30)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C30),\"\",'Table 1-Revenue Requirement'!C30)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D30),\"\",'Table 1-Revenue Requirement'!D30)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E30),\"\",'Table 1-Revenue Requirement'!E30)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F30),\"\",'Table 1-Revenue Requirement'!F30)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G30),\"\",'Table 1-Revenue Requirement'!G30)","v":""}]
[null,{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!A31),\"\",'Table 1-Revenue Requirement'!A31)","v":"Anticipated"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B31),\"\",'Table 1-Revenue Requirement'!B31)","v":"Advice Letter"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C31),\"\",'Table 1-Revenue Requirement'!C31)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D31),\"\",'Table 1-Revenue Requirement'!D31)","v":"IRMA (as appropriate)"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E31),\"\",'Table 1-Revenue Requirement'!E31)","v":"No change to stated rev. req."},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F31),\"\",'Table 1-Revenue Requirement'!F31)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G31),\"\",'Table 1-Revenue Requirement'!G31)","v":""}]
[null,{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!A32),\"\",'Table 1-Revenue Requirement'!A32)","v":"Anticipated"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B32),\"\",'Table 1-Revenue Requirement'!B32)","v":"Advice Letter"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C32),\"\",'Table 1-Revenue Requirement'!C32)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D32),\"\",'Table 1-Revenue Requirement'!D32)","v":"20XX Estimated Escalation Year Increase, Pending Earnings Test"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E32),\"\",'Table 1-Revenue Requirement'!E32)","v":"Base rate increase (est.)"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F32),\"\",'Table 1-Revenue Requirement'!F32)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G32),\"\",'Table 1-Revenue Requirement'!G32)","v":""}]
[null,{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!A33),\"\",'Table 1-Revenue Requirement'!A33)","v":"Anticipated"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B33),\"\",'Table 1-Revenue Requirement'!B33)","v":"Advice Letter"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C33),\"\",'Table 1-Revenue Requirement'!C33)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D33),\"\",'Table 1-Revenue Requirement'!D33)","v":"20XX Estimated Escalation Year Increase, Pending Earnings Test"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E33),\"\",'Table 1-Revenue Requirement'!E33)","v":"Base rate increase (est.)"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F33),\"\",'Table 1-Revenue Requirement'!F33)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G33),\"\",'Table 1-Revenue Requirement'!G33)","v":""}]
[null,{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!A34),\"\",'Table 1-Revenue Requirement'!A34)","v":"Anticipated"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B34),\"\",'Table 1-Revenue Requirement'!B34)","v":"Advice Letter"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C34),\"\",'Table 1-Revenue Requirement'!C34)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D34),\"\",'Table 1-Revenue Requirement'!D34)","v":"20XX WRAM/MCBA"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E34),\"\",'Table 1-Revenue Requirement'!E34)","v":"Amort. of balancing acct."},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F34),\"\",'Table 1-Revenue Requirement'!F34)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G34),\"\",'Table 1-Revenue Requirement'!G34)","v":""}]
[null,{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!A35),\"\",'Table 1-Revenue Requirement'!A35)","v":"Anticipated"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B35),\"\",'Table 1-Revenue Requirement'!B35)","v":"Advice Letter"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C35),\"\",'Table 1-Revenue Requirement'!C35)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D35),\"\",'Table 1-Revenue Requirement'!D35)","v":"20XX WRAM/MCBA"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E35),\"\",'Table 1-Revenue Requirement'!E35)","v":"Amort. of balancing acct."},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F35),\"\",'Table 1-Revenue Requirement'!F35)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G35),\"\",'Table 1-Revenue Requirement'!G35)","v":""}]
[null,{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!A36),\"\",'Table 1-Revenue Requirement'!A36)","v":"Anticipated"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B36),\"\",'Table 1-Revenue Requirement'!B36)","v":"Advice Letter"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C36),\"\",'Table 1-Revenue Requirement'!C36)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D36),\"\",'Table 1-Revenue Requirement'!D36)","v":"20XX WRAM/MCBA"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E36),\"\",'Table 1-Revenue Requirement'!E36)","v":"Amort. of balancing acct."},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F36),\"\",'Table 1-Revenue Requirement'!F36)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G36),\"\",'Table 1-Revenue Requirement'!G36)","v":""}]
[null,{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!A37),\"\",'Table 1-Revenue Requirement'!A37)","v":"Anticipated"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B37),\"\",'Table 1-Revenue Requirement'!B37)","v":"Advice Letter"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C37),\"\",'Table 1-Revenue Requirement'!C37)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D37),\"\",'Table 1-Revenue Requirement'!D37)","v":"Supply Cost Offset"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E37),\"\",'Table 1-Revenue Requirement'!E37)","v":"Base rate change"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F37),\"\",'Table 1-Revenue Requirement'!F37)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G37),\"\",'Table 1-Revenue Requirement'!G37)","v":""}]
[null,{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!A38),\"\",'Table 1-Revenue Requirement'!A38)","v":"Anticipated"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B38),\"\",'Table 1-Revenue Requirement'!B38)","v":"Advice Letter"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C38),\"\",'Table 1-Revenue Requirement'!C38)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D38),\"\",'Table 1-Revenue Requirement'!D38)","v":"Supply Cost Offset"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E38),\"\",'Table 1-Revenue Requirement'!E38)","v":"Base rate change"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F38),\"\",'Table 1-Revenue Requirement'!F38)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G38),\"\",'Table 1-Revenue Requirement'!G38)","v":""}]
[null,{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!A39),\"\",'Table 1-Revenue Requirement'!A39)","v":"Anticipated"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B39),\"\",'Table 1-Revenue Requirement'!B39)","v":"Advice Letter"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C39),\"\",'Table 1-Revenue Requirement'!C39)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D39),\"\",'Table 1-Revenue Requirement'!D39)","v":"Rate base offsets (ALPs)"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E39),\"\",'Table 1-Revenue Requirement'!E39)","v":"Base rate increase"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F39),\"\",'Table 1-Revenue Requirement'!F39)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G39),\"\",'Table 1-Revenue Requirement'!G39)","v":""}]
[null,{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!A40),\"\",'Table 1-Revenue Requirement'!A40)","v":"Anticipated"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B40),\"\",'Table 1-Revenue Requirement'!B40)","v":"Advice Letter"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C40),\"\",'Table 1-Revenue Requirement'!C40)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D40),\"\",'Table 1-Revenue Requirement'!D40)","v":"Cost of capital"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E40),\"\",'Table 1-Revenue Requirement'!E40)","v":"Base rate change"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F40),\"\",'Table 1-Revenue Requirement'!F40)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G40),\"\",'Table 1-Revenue Requirement'!G40)","v":""}]
[null,{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!A41),\"\",'Table 1-Revenue Requirement'!A41)","v":"Anticipated"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!B41),\"\",'Table 1-Revenue Requirement'!B41)","v":"Application"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C41),\"\",'Table 1-Revenue Requirement'!C41)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D41),\"\",'Table 1-Revenue Requirement'!D41)","v":"20XX GRC"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E41),\"\",'Table 1-Revenue Requirement'!E41)","v":"Base rate change"},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F41),\"\",'Table 1-Revenue Requirement'!F41)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G41),\"\",'Table 1-Revenue Requirement'!G41)","v":""}]
[null,null,null,{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!C42),\"\",'Table 1-Revenue Requirement'!C42)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!D42),\"\",'Table 1-Revenue Requirement'!D42)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!E42),\"\",'Table 1-Revenue Requirement'!E42)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!F42),\"\",'Table 1-Revenue Requirement'!F42)","v":""},{"$f":"IF(ISBLANK('Table 1-Revenue Requirement'!G42),\"\",'Table 1-Revenue Requirement'!G42)","v":""}]
[null,"Total Anticipated",null,null,null,null,null,null,{"$f":"SUM(I25:I36)","v":0},{"$f":"SUM(J25:J36)","v":0},{"$f":"SUM(K25:K36)","v":0},{"$f":"SUM(L25:L36)","v":0},{"$f":"SUM(M25:M36)","v":0}]
[null,"CPUC Fee",null,1,null,null,null,null,{"$f":"SUM(I6+I14+I23+I37)*0.0123","v":3.3948},{"$f":"SUM(J6+J14+J23+J37)*0.0123","v":3.3948},{"$f":"SUM(K6+K14+K23+K37)*0.0123","v":3.3948},{"$f":"SUM(L6+L14+L23+L37)*0.0123","v":3.3948},{"$f":"SUM(M6+M14+M23+M37)*0.0123","v":3.3948}]
[null,"Total Estimated Annual Bill, Not Including TBD Amounts",null,null,null,null,null,null,{"$f":"SUM(I6+I14+I23+I37)*1.0123","v":279.39479999999998},{"$f":"SUM(J6+J14+J23+J37)*1.0123","v":279.39479999999998},{"$f":"SUM(K6+K14+K23+K37)*1.0123","v":279.39479999999998},{"$f":"SUM(L6+L14+L23+L37)*1.0123","v":279.39479999999998},{"$f":"SUM(M6+M14+M23+M37)*1.0123","v":279.39479999999998}]
[null,"Change in Estimated Annual Bill, as Compared to Year 1",null,null,null,null,null,null,"n/a",{"$f":"J39-I39","v":0},{"$f":"K39-I39","v":0},{"$f":"L39-I39","v":0},{"$f":"M39-I39","v":0}]
[null,"CAP Residential Customers - Average Usage"]
[null,"Status","Proceedings ","Footnote Reference","Description of Filing","Revenue Recovery Mechanism ","Effective Date or Proposed Effective Date","Expiration Date or Proposed Expiration Date",2019,2020,2021,2022,2023]
[null,{"$f":"IF(B6=\"\",\"\",B6)","v":"Baseline bill (incl. service & quantity charges)"},"D.XX-XX-XXX/A. or AL","","","","","",{"$f":"Baseline_Bill_LIRA_Avg","v":248.57142857142858},{"$f":"Baseline_Bill_LIRA_Avg","v":248.57142857142858},{"$f":"Baseline_Bill_LIRA_Avg","v":248.57142857142858},{"$f":"Baseline_Bill_LIRA_Avg","v":248.57142857142858},{"$f":"Baseline_Bill_LIRA_Avg","v":248.57142857142858}]
[null,"Active","A.18-XX-XX; D.19-XX-XXX","","(e.g. Bal. Acct., IRMA, WRAM)","(e.g., amortization of balancing account, GRC base rate increase, etc.)","",""]
[null,"Active","A.18-XX-XXX; D.19-XX-XXX","","","","",""]
[null,"Active","AL # XXXX","","","","",""]
[null,"Active","AL # XXXX","","","","",""]
[null,"Active","AL # XXXX","","","","",""]
[null,"Active","AL # XXXX","","","","",""]
[null,"","","","","","",""]
[null,"Total Active",null,null,null,null,null,null,{"$f":"SUM(I44:I50)","v":0},{"$f":"SUM(J44:J50)","v":0},{"$f":"SUM(K44:K50)","v":0},{"$f":"SUM(L44:L50)","v":0},{"$f":"SUM(M44:M50)","v":0}]
[null,{"$f":"IF(B15=\"\",\"\",B15)","v":""},"","","","","",""]
[null,"Pending - Filed","AL # XXXX","","","","",""]
[null,"Pending - Filed","AL # XXXX","","","","",""]
[null,"Pending - Filed","AL # XXXX","","","","",""]
[null,"Pending - Filed","AL # XXXX","","","","",""]
[null,"Pending - Filed","A.XX-XX-XXX","","","","",""]
[null,{"$f":"IF(B21=\"\",\"\",B21)","v":"Pending - Filed"},{"$f":"IF(C21=\"\",\"\",C21)","v":"A.XX-XX-XXX"}]
[null,{"$f":"IF(B22=\"\",\"\",B22)","v":"Pending - New Filing"},"AL # XXXX","","","","",""]
[null,"Total Pending ",null,null,null,null,null,null,{"$f":"SUM(I53:I59)","v":0},{"$f":"SUM(J53:J59)","v":0},{"$f":"SUM(K53:K59)","v":0},{"$f":"SUM(L53:L59)","v":0},{"$f":"SUM(M53:M59)","v":0}]
[null,{"$f":"IF(B24=\"\",\"\",B24)","v":""},"","","","","",""]
[null,"Anticipated","Advice Letter","","IRMA (as appropriate)","No change to stated rev. req.","",""]
[null,"Anticipated","Advice Letter","","20XX Estimated Escalation Year Increase, Pending Earnings Test","Base rate increase (est.)","",""]
[null,"Anticipated","Advice Letter","","20XX Estimated Escalation Year Increase, Pending Earnings Test","Base rate increase (est.)","",""]
[null,"Anticipated","Advice Letter","","20XX WRAM/MCBA","Amort. of balancing acct.","",""]
[null,"Anticipated","Advice Letter","","20XX WRAM/MCBA","Amort. of balancing acct.","",""]
[null,"Anticipated","Advice Letter","","20XX WRAM/MCBA","Amort. of balancing acct.",null,""]
[null,"Anticipated","Advice Letter","","Supply Cost Offset","Base rate change","",""]
[null,"Anticipated","Advice Letter","","Supply Cost Offset","Base rate change","",""]
[null,"Anticipated","Advice Letter","","Rate base offsets (ALPs)","Base rate increase","",""]
[null,"Anticipated","Advice Letter","","Cost of capital","Base rate change","",""]
[null,"Anticipated","Application","","20XX GRC","Base rate change","",""]
[null,null,null,{"$f":"IF(D36=\"\",\"\",D36)","v":""},{"$f":"IF(E36=\"\",\"\",E36)","v":""},{"$f":"IF(F36=\"\",\"\",F36)","v":""},{"$f":"IF(G36=\"\",\"\",G36)","v":""},{"$f":"IF(H36=\"\",\"\",H36)","v":""}]
[null,"Total Anticipated",null,null,null,null,null,null,{"$f":"SUM(I62:I73)","v":0},{"$f":"SUM(J62:J73)","v":0},{"$f":"SUM(K62:K73)","v":0},{"$f":"SUM(L62:L73)","v":0},{"$f":"SUM(M62:M73)","v":0}]
[null,"CPUC Fee",null,1,null,null,null,null,{"$f":"SUM(I43+I51+I60+I74)*0.0123","v":3.0574285714285718},{"$f":"SUM(J43+J51+J60+J74)*0.0123","v":3.0574285714285718},{"$f":"SUM(K43+K51+K60+K74)*0.0123","v":3.0574285714285718},{"$f":"SUM(L43+L51+L60+L74)*0.0123","v":3.0574285714285718},{"$f":"SUM(M43+M51+M60+M74)*0.0123","v":3.0574285714285718}]
[null,"Total Estimated Annual Bill, Not Including TBD Amounts",null,null,null,null,null,null,{"$f":"SUM(I43+I51+I60+I74)*1.0123","v":251.62885714285716},{"$f":"SUM(J43+J51+J60+J74)*1.0123","v":251.62885714285716},{"$f":"SUM(K43+K51+K60+K74)*1.0123","v":251.62885714285716},{"$f":"SUM(L43+L51+L60+L74)*1.0123","v":251.62885714285716},{"$f":"SUM(M43+M51+M60+M74)*1.0123","v":251.62885714285716}]
[null,"Change in Estimated Annual Bill, as Compared to Year 1",null,null,null,null,null,null,"n/a",{"$f":"J76-I76","v":0},{"$f":"K76-I76","v":0},{"$f":"L76-I76","v":0},{"$f":"M76-I76","v":0}]
[null,"Non-CAP Residential Customers - Tier 1 Usage"]
[null,"Status","Proceedings ","Footnote Reference","Description of Filing","Revenue Recovery Mechanism ","Effective Date or Proposed Effective Date","Expiration Date or Proposed Expiration Date",2019,2020,2021,2022,2023]
[null,{"$f":"IF(B6=\"\",\"\",B6)","v":"Baseline bill (incl. service & quantity charges)"},"D.XX-XX-XXX/A. or AL","","","","","",{"$f":"Baseline_Bill_Non_LIRA_Tier_1","v":264},{"$f":"Baseline_Bill_Non_LIRA_Tier_1","v":264},{"$f":"Baseline_Bill_Non_LIRA_Tier_1","v":264},{"$f":"Baseline_Bill_Non_LIRA_Tier_1","v":264},{"$f":"Baseline_Bill_Non_LIRA_Tier_1","v":264}]
[null,"Active","A.18-XX-XX; D.19-XX-XXX","","(e.g. Bal. Acct., IRMA, WRAM)","(e.g., amortization of balancing account, GRC base rate increase, etc.)","",""]
[null,"Active","A.18-XX-XXX; D.19-XX-XXX","","","","",""]
[null,"Active","AL # XXXX","","","","",""]
[null,"Active","AL # XXXX","","","","",""]
[null,"Active","AL # XXXX","","","","",""]
[null,"Active","AL # XXXX","","","","",""]
[null,"","","","","","",""]
[null,"Total Active",null,null,null,null,null,null,{"$f":"SUM(I81:I87)","v":0},{"$f":"SUM(J81:J87)","v":0},{"$f":"SUM(K81:K87)","v":0},{"$f":"SUM(L81:L87)","v":0},{"$f":"SUM(M81:M87)","v":0}]
[null,{"$f":"IF(B15=\"\",\"\",B15)","v":""},"","","","","",""]
[null,"Pending - Filed","AL # XXXX","","","","",""]
[null,"Pending - Filed","AL # XXXX","","","","",""]
[null,"Pending - Filed","AL # XXXX","","","","",""]
[null,"Pending - Filed","AL # XXXX","","","","",""]
[null,"Pending - Filed","A.XX-XX-XXX","","","","",""]
[null,{"$f":"IF(B21=\"\",\"\",B21)","v":"Pending - Filed"},{"$f":"IF(C21=\"\",\"\",C21)","v":"A.XX-XX-XXX"}]
[null,{"$f":"IF(B22=\"\",\"\",B22)","v":"Pending - New Filing"},"AL # XXXX","","","","",""]
[null,"Total Pending ",null,null,null,null,null,null,{"$f":"SUM(I90:I96)","v":0},{"$f":"SUM(J90:J96)","v":0},{"$f":"SUM(K90:K96)","v":0},{"$f":"SUM(L90:L96)","v":0},{"$f":"SUM(M90:M96)","v":0}]
[null,{"$f":"IF(B24=\"\",\"\",B24)","v":""},"","","","","",""]
[null,"Anticipated","Advice Letter","","IRMA (as appropriate)","No change to stated rev. req.","",""]
[null,"Anticipated","Advice Letter","","20XX Estimated Escalation Year Increase, Pending Earnings Test","Base rate increase (est.)","",""]
[null,"Anticipated","Advice Letter","","20XX Estimated Escalation Year Increase, Pending Earnings Test","Base rate increase (est.)","",""]
[null,"Anticipated","Advice Letter","","20XX WRAM/MCBA","Amort. of balancing acct.","",""]
[null,"Anticipated","Advice Letter","","20XX WRAM/MCBA","Amort. of balancing acct.","",""]
[null,"Anticipated","Advice Letter","","20XX WRAM/MCBA","Amort. of balancing acct.","",""]
[null,"Anticipated","Advice Letter","","Supply Cost Offset","Base rate change","",""]
[null,"Anticipated","Advice Letter","","Supply Cost Offset","Base rate change","",""]
[null,"Anticipated","Advice Letter","","Rate base offsets (ALPs)","Base rate increase","",""]
[null,"Anticipated","Advice Letter","","Cost of capital","Base rate change","",""]
[null,"Anticipated","Application","","20XX GRC","Base rate change","",""]
[null,null,null,{"$f":"IF(D36=\"\",\"\",D36)","v":""},{"$f":"IF(E36=\"\",\"\",E36)","v":""},{"$f":"IF(F36=\"\",\"\",F36)","v":""},{"$f":"IF(G36=\"\",\"\",G36)","v":""},{"$f":"IF(H36=\"\",\"\",H36)","v":""}]
[null,"Total Anticipated",null,null,null,null,null,null,{"$f":"SUM(I99:I110)","v":0},{"$f":"SUM(J99:J110)","v":0},{"$f":"SUM(K99:K110)","v":0},{"$f":"SUM(L99:L110)","v":0},{"$f":"SUM(M99:M110)","v":0}]
[null,"CPUC Fee",null,1,null,null,null,null,{"$f":"SUM(I80+I88+I97+I111)*0.0123","v":3.2471999999999999},{"$f":"SUM(J80+J88+J97+J111)*0.0123","v":3.2471999999999999},{"$f":"SUM(K80+K88+K97+K111)*0.0123","v":3.2471999999999999},{"$f":"SUM(L80+L88+L97+L111)*0.0123","v":3.2471999999999999},{"$f":"SUM(M80+M88+M97+M111)*0.0123","v":3.2471999999999999}]
[null,"Total Estimated Annual Bill, Not Including TBD Amounts",null,null,null,null,null,null,{"$f":"SUM(I80+I88+I97+I111)*1.0123","v":267.24720000000002},{"$f":"SUM(J80+J88+J97+J111)*1.0123","v":267.24720000000002},{"$f":"SUM(K80+K88+K97+K111)*1.0123","v":267.24720000000002},{"$f":"SUM(L80+L88+L97+L111)*1.0123","v":267.24720000000002},{"$f":"SUM(M80+M88+M97+M111)*1.0123","v":267.24720000000002}]
[null,"Change in Estimated Annual Bill, as Compared to Year 1",null,null,null,null,null,null,"n/a",{"$f":"J113-I113","v":0},{"$f":"K113-I113","v":0},{"$f":"L113-I113","v":0},{"$f":"M113-I113","v":0}]
[null,"CAP Residential Customers - Tier 1 Usage"]
[null,"Status","Proceedings ","Footnote Reference","Description of Filing","Revenue Recovery Mechanism ","Effective Date or Proposed Effective Date","Expiration Date or Proposed Expiration Date",2019,2020,2021,2022,2023]
[null,{"$f":"IF(B6=\"\",\"\",B6)","v":"Baseline bill (incl. service & quantity charges)"},"D.XX-XX-XXX/A. or AL","","","","","",{"$f":"Baseline_Bill_LIRA_Tier_1","v":248.57142857142858},{"$f":"Baseline_Bill_LIRA_Tier_1","v":248.57142857142858},{"$f":"Baseline_Bill_LIRA_Tier_1","v":248.57142857142858},{"$f":"Baseline_Bill_LIRA_Tier_1","v":248.57142857142858},{"$f":"Baseline_Bill_LIRA_Tier_1","v":248.57142857142858}]
[null,"Active","A.18-XX-XX; D.19-XX-XXX","","(e.g. Bal. Acct., IRMA, WRAM)","(e.g., amortization of balancing account, GRC base rate increase, etc.)","",""]
[null,"Active","A.18-XX-XXX; D.19-XX-XXX","","","","",""]
[null,"Active","AL # XXXX","","","","",""]
[null,"Active","AL # XXXX","","","","",""]
[null,"Active","AL # XXXX","","","","",""]
[null,"Active","AL # XXXX","","","","",""]
[null,"","","","","","",""]
[null,"Total Active",null,null,null,null,null,null,{"$f":"SUM(I118:I124)","v":0},{"$f":"SUM(J118:J124)","v":0},{"$f":"SUM(K118:K124)","v":0},{"$f":"SUM(L118:L124)","v":0},{"$f":"SUM(M118:M124)","v":0}]
[null,{"$f":"IF(B15=\"\",\"\",B15)","v":""},"","","","","",""]
[null,"Pending - Filed","AL # XXXX","","","","",""]
[null,"Pending - Filed","AL # XXXX","","","","",""]
[null,"Pending - Filed","AL # XXXX","","","","",""]
[null,"Pending - Filed","AL # XXXX","","","","",""]
[null,"Pending - Filed","A.XX-XX-XXX","","","","",""]
[null,{"$f":"IF(B21=\"\",\"\",B21)","v":"Pending - Filed"},{"$f":"IF(C21=\"\",\"\",C21)","v":"A.XX-XX-XXX"}]
[null,{"$f":"IF(B22=\"\",\"\",B22)","v":"Pending - New Filing"},"AL # XXXX","","","","",""]
[null,"Total Pending ",null,null,null,null,null,null,{"$f":"SUM(I127:I133)","v":0},{"$f":"SUM(J127:J133)","v":0},{"$f":"SUM(K127:K133)","v":0},{"$f":"SUM(L127:L133)","v":0},{"$f":"SUM(M127:M133)","v":0}]
[null,{"$f":"IF(B24=\"\",\"\",B24)","v":""},"","","","","",""]
[null,"Anticipated","Advice Letter","","IRMA (as appropriate)","No change to stated rev. req.","",""]
[null,"Anticipated","Advice Letter","","20XX Estimated Escalation Year Increase, Pending Earnings Test","Base rate increase (est.)","",""]
[null,"Anticipated","Advice Letter","","20XX Estimated Escalation Year Increase, Pending Earnings Test","Base rate increase (est.)","",""]
[null,"Anticipated","Advice Letter","","20XX WRAM/MCBA","Amort. of balancing acct.","",""]
[null,"Anticipated","Advice Letter","","20XX WRAM/MCBA","Amort. of balancing acct.","",""]
[null,"Anticipated","Advice Letter","","20XX WRAM/MCBA","Amort. of balancing acct.","",""]
[null,"Anticipated","Advice Letter","","Supply Cost Offset","Base rate change","",""]
[null,"Anticipated","Advice Letter","","Supply Cost Offset","Base rate change","",""]
[null,"Anticipated","Advice Letter","","Rate base offsets (ALPs)","Base rate increase","",""]
[null,"Anticipated","Advice Letter","","Cost of capital","Base rate change","",""]
[null,"Anticipated","Application","","20XX GRC","Base rate change","",""]
[null,{"$f":"IF(B36=\"\",\"\",B36)","v":""},"","","","","",""]
[null,"Total Anticipated",null,null,null,null,null,null,{"$f":"SUM(I136:I147)","v":0},{"$f":"SUM(J136:J147)","v":0},{"$f":"SUM(K136:K147)","v":0},{"$f":"SUM(L136:L147)","v":0},{"$f":"SUM(M136:M147)","v":0}]
[null,"CPUC Fee",null,1,null,null,null,null,{"$f":"SUM(I117+I125+I134+I148)*0.0123","v":3.0574285714285718},{"$f":"SUM(J117+J125+J134+J148)*0.0123","v":3.0574285714285718},{"$f":"SUM(K117+K125+K134+K148)*0.0123","v":3.0574285714285718},{"$f":"SUM(L117+L125+L134+L148)*0.0123","v":3.0574285714285718},{"$f":"SUM(M117+M125+M134+M148)*0.0123","v":3.0574285714285718}]
[null,"Total Estimated Annual Bill, Not Including TBD Amounts",null,null,null,null,null,null,{"$f":"SUM(I117+I125+I134+I148)*1.0123","v":251.62885714285716},{"$f":"SUM(J117+J125+J134+J148)*1.0123","v":251.62885714285716},{"$f":"SUM(K117+K125+K134+K148)*1.0123","v":251.62885714285716},{"$f":"SUM(L117+L125+L134+L148)*1.0123","v":251.62885714285716},{"$f":"SUM(M117+M125+M134+M148)*1.0123","v":251.62885714285716}]
[null,"Change in Estimated Annual Bill, as Compared to Year 1",null,null,null,null,null,null,"n/a",{"$f":"J150-I150","v":0},{"$f":"K150-I150","v":0},{"$f":"L150-I150","v":0},{"$f":"M150-I150","v":0}]
[]
[]
[null,"Footnotes and Assumptions:"]
[null,"1. CPUC User Fee of 1.23% corresponds to the most recent resolution setting the User Fee (i.e., Resolution M-4839). Update as necessary."]

{"sheet":"EXAMPLES","index":5,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["The next three sheets present hypothetical examples included to assist you with filling out the template."]
["Tables Ex2 and Ex3 (i.e., example tables 2 and 3) depict how named cells carry through and prepopulate across tables."]
["Tables Ex3 and Ex4 depict how to depict an escalation year request, as well as temporary surcharges (using two hypothetical surcharges)."]

{"sheet":"Table Ex2-Residential Avg Usa","index":6,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[17,10,17,11],[17,12,17,13]]}
[]
[null,"Company: ",null,null,"Filing Date:","2019-09-01"]
[null,"Ratemaking Area:",null,null,"Filing Year:",2019]
[]
[null,null,"All Residential Customers","Non-Customer Assistance Program (CAP) Customers","CAP Customers","Tier 1 Usage (up to 12 CCFs/month) for Non-CAP Customers","Tier 1 Usage (up to 12 CCFs/month) for CAP Customers"]
[null,"Total Residential CCFs Used in 12 Months (for last calendar year)",{"$f":"D6+E6","v":18000000},15000000,3000000,"N/A","N/A"]
[null,"Total Number of Residential Connections (at the end of the last calendar year)",{"$f":"D7+E7","v":121000},100000,21000,"N/A","N/A"]
[null,"Residential Average Annual Usage (CCFs) Per Connection, or Tier 1 Annual Usage Amount",{"$f":"C6/C7","v":148.7603305785124},{"$f":"D6/D7","v":150},{"$f":"E6/E7","v":142.85714285714286},{"$f":"12*12","v":144},{"$f":"MIN(LIRA_Avg_Usage_Exp,'Table Ex3 Inputs'!F7*12)","v":142.85714285714286}]
[null,"Current Residential Average Annual Bill","N/A",{"$f":"'Table Ex3-Current Bill'!C22","v":318.12},{"$f":"'Table Ex3-Current Bill'!D22","v":213.30428571428573},{"$f":"'Table Ex3-Current Bill'!E22","v":304.42},{"$f":"'Table Ex3-Current Bill'!F22","v":213.30428571428573}]
[]
[]
[null,"Notes and Assumptions:"]

{"sheet":"Table Ex3 Inputs","index":7,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,null,"Quantity Basis","CCF"]
[]
[null,null,"Variable Charge Calculation",null,null,null,null,null,"Non-CAP Average Use","CAP Average Use"]
[null,null,"Number of Tiers",2,null,null,null,null,{"$f":"IFERROR(Non_LIRA_Avg_Usage/bills,0)","v":12.5},{"$f":"IFERROR(LIRA_Avg_Usage/bills,0)","v":11.904761904761905}]
[null,null,null,"Tier Start",{"$f":"\"Tier End \n(\"&D1&\")\"","v":"Tier End \n(CCF)"},"Tier Width","Non-CAP Tier Rate","CAP Tier Rate","Non-CAP Average Consumption  In Tier","CAP Avg Consumption  in Tier","Average Monthly Bill in Tier","Average CAP Monthly Bill in Tier"]
[null,1,null,null,null,null,"(A)","(B)","(C)","(D)","(E)  = (A) * (C) ","(F) = (B) * (D)"]
[null,1,"Tier 1",{"$f":"IF(D4=1,\"Uniform Rate\",\"0 \"&D1&\" to\")","v":"0 CCF to"},12,{"$f":"IF(D4=1,\"\",E7)","v":12},1,0.9,{"$f":"IF(B7<=$D$4,MIN($F7,I$4),\"\")","v":12},{"$f":"IF(B7<=$D$4,MIN($F7,J$4),\"\")","v":11.904761904761905},{"$f":"IF($B7<=$D$4,I7*G7,\"\")","v":12},{"$f":"H7*J7","v":10.714285714285715}]
[null,2,{"$f":"IF($B8<=$D$4,\"Tier \"&B8,\"\")","v":"Tier 2"},{"$f":"IF($B8<$D$4,E7&\" \"&$D$1&\" to\",IF($B8=D$4,\"Over \"&E7&\" \"&$D$1,\"\"))","v":"Over 12 CCF"},null,{"$f":"IF($B8<$D$4,E8-E7,\"\")","v":""},2,2,{"$f":"IF(B8<=$D$4,MIN(I$4-SUM(I$7:I7),$F8),\"\")","v":0.5},{"$f":"IF(B8<=$D$4,MIN(J$4-SUM(J$7:J7),$F8),\"\")","v":0},1,{"$f":"H8*J8","v":0}]
[null,3,"","",null,"",null,null,{"$f":"IF(B9<=$D$4,MIN(I$4-SUM(I$7:I8),$F9),\"\")","v":""},{"$f":"IF(B9<=$D$4,MIN(J$4-SUM(J$7:J8),$F9),\"\")","v":""},{"$f":"IF($B9<=$D$4,I9*G9,\"\")","v":""},{"$f":"IF($B9<=$D$4,J9*IF(#REF!=\"percentage\",G9*(1-#REF!),H9),\"\")","v":""}]
[null,4,"","",null,"",null,null,{"$f":"IF(B10<=$D$4,MIN(I$4-SUM(I$7:I9),$F10),\"\")","v":""},{"$f":"IF(B10<=$D$4,MIN(J$4-SUM(J$7:J9),$F10),\"\")","v":""},"",{"$f":"IF($B10<=$D$4,J10*IF(#REF!=\"percentage\",G10*(1-#REF!),H10),\"\")","v":""}]
[null,5,"","",null,"",null,null,{"$f":"IF(B11<=$D$4,MIN(I$4-SUM(I$7:I10),$F11),\"\")","v":""},{"$f":"IF(B11<=$D$4,MIN(J$4-SUM(J$7:J10),$F11),\"\")","v":""},"",{"$f":"IF($B11<=$D$4,J11*IF(#REF!=\"percentage\",G11*(1-#REF!),H11),\"\")","v":""}]
[null,6,"","",null,"",null,null,{"$f":"IF(B12<=$D$4,MIN(I$4-SUM(I$7:I11),$F12),\"\")","v":""},{"$f":"IF(B12<=$D$4,MIN(J$4-SUM(J$7:J11),$F12),\"\")","v":""},"",{"$f":"IF($B12<=$D$4,J12*IF(#REF!=\"percentage\",G12*(1-#REF!),H12),\"\")","v":""}]
[null,7,"","",null,"",null,null,{"$f":"IF(B13<=$D$4,MIN(I$4-SUM(I$7:I12),$F13),\"\")","v":""},{"$f":"IF(B13<=$D$4,MIN(J$4-SUM(J$7:J12),$F13),\"\")","v":""},"",{"$f":"IF($B13<=$D$4,J13*IF(#REF!=\"percentage\",G13*(1-#REF!),H13),\"\")","v":""}]
[null,8,"","",null,"",null,null,{"$f":"IF(B14<=$D$4,MIN(I$4-SUM(I$7:I13),$F14),\"\")","v":""},{"$f":"IF(B14<=$D$4,MIN(J$4-SUM(J$7:J13),$F14),\"\")","v":""},"",{"$f":"IF($B14<=$D$4,J14*IF(#REF!=\"percentage\",G14*(1-#REF!),H14),\"\")","v":""}]
[null,9,"","",null,"",null,null,{"$f":"IF(B15<=$D$4,MIN(I$4-SUM(I$7:I14),$F15),\"\")","v":""},{"$f":"IF(B15<=$D$4,MIN(J$4-SUM(J$7:J14),$F15),\"\")","v":""},"",{"$f":"IF($B15<=$D$4,J15*IF(#REF!=\"percentage\",G15*(1-#REF!),H15),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K7:K15)","v":13},{"$f":"SUM(L7:L15)","v":10.714285714285715}]
[]
[null,null,"Fixed Charge Calculation"]
[null,null,"Most Common Residential Meter","5/8\" x 3/4\""]
[null,null,"Meter Size","Non-CAP Fixed Charge","CAP Fixed Charge (prior to credit or discount)"]
[null,null,{"$f":"D19&\" Fixed Charges\"","v":"5/8\" x 3/4\" Fixed Charges"},10,10]
[]
[null,null,"Surcharges, Credits, Fees and Taxes","Type of Charge","Amount of Charge (Non-CAP)","Amount of Charge (CAP)"]
[null,null,"CAP Credit","Fixed",null,-5]
[null,null,"CAP Surcharge","Variable",0.1]
[null,null,"Temporary Surcharge #1","Variable",0.2,0.2]
[null,null,"Temporary Surcharge #2","Variable",0.01,0.01]
[null,null,"…","Fixed"]
[null,null,"…","Fixed"]

{"sheet":"Table Ex3-Current Bill","index":8,"n_rows":65,"n_cols":7,"rows_kept":65,"cut":false,"hidden":false,"merged":[[52,2,52,3],[52,4,52,5],[5,2,5,3],[5,4,5,5],[25,2,25,3],[25,4,25,5],[45,2,45,3],[45,4,45,5]]}
[]
[null,"Company: ",null,null,null,"Filing Date:","2019-09-01"]
[null,"Ratemaking Area:",null,null,null,"Filing Year:",2019]
[]
[null,{"$f":"\"Average Annual Bill Calculation for Residential \"&'Table Ex3 Inputs'!D19&\" Meter as of the filing date:\"","v":"Average Annual Bill Calculation for Residential 5/8\" x 3/4\" Meter as of the filing date:"}]
[null,null,"Average Usage",null,"Tier 1 Usage",null,"Appropriate Rate"]
[null,null,"Non-CAP","CAP","Non-CAP","CAP"]
[null,"Usage (Ccfs/Year)",{"$f":"Non_LIRA_Avg_Usage_Exp","v":150},{"$f":"LIRA_Avg_Usage_Exp","v":142.85714285714286},{"$f":"Non_LIRA_Tier_1_Usage_Exp","v":144},{"$f":"LIRA_Tier_1_Usage_Exp","v":142.85714285714286}," (Incl. Start and Expiration Date as Appropriate)"]
[]
[null,"Service Charge",{"$f":"'Table Ex3 Inputs'!D21*bills_exp","v":120},{"$f":"'Table Ex3 Inputs'!E21*bills_exp","v":120},{"$f":"'Table Ex3 Inputs'!D21*bills_exp","v":120},{"$f":"'Table Ex3 Inputs'!E21*bills_exp","v":120},"$10.00 per month"]
[null,"Quantity Charge",{"$f":"'Table Ex3 Inputs'!K16*bills","v":156},{"$f":"'Table Ex3 Inputs'!L16*bills","v":128.57142857142858},{"$f":"'Table Ex3 Inputs'!$G$7*'Table Ex3 Inputs'!I$7*bills_exp","v":144},{"$f":"'Table Ex3 Inputs'!L7*bills_exp","v":128.57142857142858},"$1.000 per CCF"]
[null,"Subtotal:",{"$f":"C11+C10","v":276},{"$f":"D11+D10","v":248.57142857142858},{"$f":"E11+E10","v":264},{"$f":"F11+F10","v":248.57142857142858}]
[]
[null,"LIRA Credit",{"$f":"IF('Table Ex3 Inputs'!$D24=\"Fixed\",'Table Ex3 Inputs'!$E24*bills_exp,'Table Ex3 Inputs'!$E24*C$8)","v":0},{"$f":"IF('Table Ex3 Inputs'!$D24=\"Fixed\",'Table Ex3 Inputs'!$F24*bills_exp,'Table Ex3 Inputs'!$F24*D$8)","v":-60},{"$f":"IF('Table Ex3 Inputs'!$D24=\"Fixed\",'Table Ex3 Inputs'!$E24*bills_exp,'Table Ex3 Inputs'!$E24*E$8)","v":0},{"$f":"IF('Table Ex3 Inputs'!$D24=\"Fixed\",'Table Ex3 Inputs'!$F24*bills_exp,'Table Ex3 Inputs'!$F24*F$8)","v":-60},"$5.00 per month"]
[null,"LIRA Surcharge",{"$f":"IF('Table Ex3 Inputs'!$D25=\"Fixed\",'Table Ex3 Inputs'!$E25*bills_exp,'Table Ex3 Inputs'!$E25*C$8)","v":15},null,{"$f":"IF('Table Ex3 Inputs'!$D25=\"Fixed\",'Table Ex3 Inputs'!$E25*bills_exp,'Table Ex3 Inputs'!$E25*E$8)","v":14.4},null,"$0.100 per CCF"]
[null,"Temporary Surcharge #1",{"$f":"IF('Table Ex3 Inputs'!$D26=\"Fixed\",'Table Ex3 Inputs'!$E26*bills_exp,'Table Ex3 Inputs'!$E26*C$8)*(9/12)","v":22.5},{"$f":"IF('Table Ex3 Inputs'!$D26=\"Fixed\",'Table Ex3 Inputs'!$F26*bills_exp,'Table Ex3 Inputs'!$F26*D$8)*(9/12)","v":21.428571428571431},{"$f":"IF('Table Ex3 Inputs'!$D26=\"Fixed\",'Table Ex3 Inputs'!$E26*bills_exp,'Table Ex3 Inputs'!$E26*E$8)*(9/12)","v":21.6},{"$f":"IF('Table Ex3 Inputs'!$D26=\"Fixed\",'Table Ex3 Inputs'!$F26*bills_exp,'Table Ex3 Inputs'!$F26*F$8)*(9/12)","v":21.428571428571431},"$0.200 per CCF (applies 1/1/2018 - 10/1/2019"]
[null,"Temporary Surcharge #2",{"$f":"IF('Table Ex3 Inputs'!$D27=\"Fixed\",'Table Ex3 Inputs'!$E27*bills_exp,'Table Ex3 Inputs'!$E27*C$8)*(6/12)","v":0.75},{"$f":"IF('Table Ex3 Inputs'!$D27=\"Fixed\",'Table Ex3 Inputs'!$F27*bills_exp,'Table Ex3 Inputs'!$F27*D$8)*(6/12)","v":0.7142857142857143},{"$f":"IF('Table Ex3 Inputs'!$D27=\"Fixed\",'Table Ex3 Inputs'!$E27*bills_exp,'Table Ex3 Inputs'!$E27*E$8)*(6/12)","v":0.72},{"$f":"IF('Table Ex3 Inputs'!$D27=\"Fixed\",'Table Ex3 Inputs'!$F27*bills_exp,'Table Ex3 Inputs'!$F27*F$8)*(6/12)","v":0.7142857142857143},"$0.010 per CCF (applies 7/1/2019 - 3/1/2020"]
[null,"Subtotal:",{"$f":"C14+C15+C16+C17","v":38.25},{"$f":"D14+D15+D16+D17","v":-37.857142857142854},{"$f":"E14+E15+E16+E17","v":36.72},{"$f":"F14+F15+F16+F17","v":-37.857142857142854}]
[]
[null,"CPUC Fee",{"$f":"ROUND((SUM(C12,C18)*0.0123),2)","v":3.87},{"$f":"ROUND(((SUM(D12,D18)*0.0123)),2)","v":2.59},{"$f":"ROUND((SUM(E12,E18)*0.0123),2)","v":3.7},{"$f":"ROUND((SUM(F12,F18)*0.0123),2)","v":2.59},"1.23%"]
[]
[null,"Total Avg. Annual Bill for 2019:",{"$f":"SUM(C12,C18,C20)","v":318.12},{"$f":"SUM(D12,D18,D20)","v":213.30428571428573},{"$f":"SUM(E12,E18, E20)","v":304.42},{"$f":"SUM(F12,F18,F20)","v":213.30428571428573}]
[]
[]
[null,{"$f":"\"Average Monthly Bill Calculation for Residential \"&'Table 3 Inputs'!D20&\" Meter as of the filing date:\"","v":"Average Monthly Bill Calculation for Residential 5/8\" x 3/4\" Meter as of the filing date:"}]
[null,null,"Average Usage",null,"Tier 1 Usage",null,"Appropriate Rate"]
[null,null,"Non-CAP","CAP","Non-CAP","CAP"]
[null,"Usage (Ccfs/Month)",{"$f":"Non_LIRA_Avg_Usage_Exp/12","v":12.5},{"$f":"LIRA_Avg_Usage_Exp/12","v":11.904761904761905},{"$f":"Non_LIRA_Tier_1_Usage_Exp/12","v":12},{"$f":"LIRA_Tier_1_Usage_Exp/12","v":11.904761904761905}," (Incl. Start and Expiration Date as Appropriate)"]
[]
[null,"Service Charge",{"$f":"'Table Ex3 Inputs'!D$21*bills_exp/12","v":10},{"$f":"'Table Ex3 Inputs'!E$21*bills_exp/12","v":10},{"$f":"'Table Ex3 Inputs'!D$21*bills_exp/12","v":10},{"$f":"'Table Ex3 Inputs'!E$21*bills_exp/12","v":10},"$10.00 per month"]
[null,"Quantity Charge",{"$f":"IFERROR(SUMPRODUCT('Table Ex3 Inputs'!G6:G15,'Table Ex3 Inputs'!I6:I15),0)","v":13},{"$f":"IFERROR(SUMPRODUCT('Table Ex3 Inputs'!H6:H15,'Table Ex3 Inputs'!J6:J15),0)","v":10.714285714285715},{"$f":"'Table Ex3 Inputs'!$G$7*E28","v":12},{"$f":"'Table Ex3 Inputs'!$H$7*F28","v":10.714285714285715},"$1.000 per CCF"]
[null,"Subtotal:",{"$f":"C31+C30","v":23},{"$f":"D31+D30","v":20.714285714285715},{"$f":"E31+E30","v":22},{"$f":"F31+F30","v":20.714285714285715}]
[]
[null,"LIRA Credit",{"$f":"IF('Table Ex3 Inputs'!$D24=\"Fixed\",'Table Ex3 Inputs'!$E24,'Table Ex3 Inputs'!$E24*C$28)","v":0},{"$f":"IF('Table Ex3 Inputs'!$D24=\"Fixed\",'Table Ex3 Inputs'!$F24,'Table Ex3 Inputs'!$F24*D$28)","v":-5},{"$f":"IF('Table Ex3 Inputs'!$D24=\"Fixed\",'Table Ex3 Inputs'!$E24,'Table Ex3 Inputs'!$E24*E$28)","v":0},{"$f":"IF('Table Ex3 Inputs'!$D24=\"Fixed\",'Table Ex3 Inputs'!$F24,'Table Ex3 Inputs'!$F24*F$28)","v":-5},"$5.00 per month"]
[null,"LIRA Surcharge",{"$f":"IF('Table Ex3 Inputs'!$D25=\"Fixed\",'Table Ex3 Inputs'!$E25,'Table Ex3 Inputs'!$E25*C$28)","v":1.25},{"$f":"IF('Table Ex3 Inputs'!$D25=\"Fixed\",'Table Ex3 Inputs'!$F25,'Table Ex3 Inputs'!$F25*D$28)","v":0},{"$f":"IF('Table Ex3 Inputs'!$D25=\"Fixed\",'Table Ex3 Inputs'!$E25,'Table Ex3 Inputs'!$E25*E$28)","v":1.2000000000000002},{"$f":"IF('Table Ex3 Inputs'!$D25=\"Fixed\",'Table Ex3 Inputs'!$F25,'Table Ex3 Inputs'!$F25*F$28)","v":0},"$0.100 per CCF"]
[null,"Temporary Surcharge #1",{"$f":"IF('Table Ex3 Inputs'!$D26=\"Fixed\",'Table Ex3 Inputs'!$E26,'Table Ex3 Inputs'!$E26*C$28)","v":2.5},{"$f":"IF('Table Ex3 Inputs'!$D26=\"Fixed\",'Table Ex3 Inputs'!$F26,'Table Ex3 Inputs'!$F26*D$28)","v":2.3809523809523809},{"$f":"IF('Table Ex3 Inputs'!$D26=\"Fixed\",'Table Ex3 Inputs'!$E26,'Table Ex3 Inputs'!$E26*E$28)","v":2.4000000000000004},{"$f":"IF('Table Ex3 Inputs'!$D26=\"Fixed\",'Table Ex3 Inputs'!$F26,'Table Ex3 Inputs'!$F26*F$28)","v":2.3809523809523809},"$0.200 per CCF (applies 1/1/2018 - 10/1/2019"]
[null,"Temporary Surcharge #2",{"$f":"IF('Table Ex3 Inputs'!$D27=\"Fixed\",'Table Ex3 Inputs'!$E27,'Table Ex3 Inputs'!$E27*C$28)","v":0.125},{"$f":"IF('Table Ex3 Inputs'!$D27=\"Fixed\",'Table Ex3 Inputs'!$F27,'Table Ex3 Inputs'!$F27*D$28)","v":0.11904761904761905},{"$f":"IF('Table Ex3 Inputs'!$D27=\"Fixed\",'Table Ex3 Inputs'!$E27,'Table Ex3 Inputs'!$E27*E$28)","v":0.12},{"$f":"IF('Table Ex3 Inputs'!$D27=\"Fixed\",'Table Ex3 Inputs'!$F27,'Table Ex3 Inputs'!$F27*F$28)","v":0.11904761904761905},"$0.010 per CCF (applies 7/1/2019 - 3/1/2020"]
[null,"Subtotal:",{"$f":"C34+C35+C36+C37","v":3.875},{"$f":"D34+D35+D36+D37","v":-2.5},{"$f":"E34+E35+E36+E37","v":3.7200000000000006},{"$f":"F34+F35+F36+F37","v":-2.5}]
[]
[null,"CPUC Fee",{"$f":"ROUND((SUM(C32,C38)*0.0123),2)","v":0.33},{"$f":"ROUND((SUM(D32,D38)*0.0123),2)","v":0.22},{"$f":"ROUND((SUM(E32,E38)*0.0123),2)","v":0.32},{"$f":"ROUND((SUM(F32,F38)*0.0123),2)","v":0.22},"1.23%"]
[]
[null,"Total Avg. Monthly Bill for July 2019:",{"$f":"SUM(C32,C38,C40)","v":27.204999999999998},{"$f":"SUM(D32,D38,D40)","v":18.434285714285714},{"$f":"SUM(E32,E38,E40)","v":26.04},{"$f":"SUM(F32,F38,F40)","v":18.434285714285714}]
[]
[]
[null,"Estimated Incremental Annual Bill Impact for Residential ___\" Meter with 2020 and 2021 Rate Escalation related to 2017 GRC:"]
[null,2020,"Average Usage",null,"Tier 1 Usage"]
[null,null,"Non-CAP","CAP","Non-CAP","CAP"]
[null,"Service Charge",{"$f":"(11-10)*12","v":12},{"$f":"(11-10)*12","v":12},{"$f":"(11-10)*12","v":12},{"$f":"(11-10)*12","v":12},"From $10 to $11 per month"]
[null,"Quantity Charge",{"$f":"ROUND((C8*(1.1-1)),2)","v":15},{"$f":"ROUND((D8*(1.1-1)),2)","v":14.29},{"$f":"ROUND((E8*(1.1-1)),2)","v":14.4},{"$f":"ROUND((F8*(1.1-1)),2)","v":14.29},"From $1.000 to $1.100 per CCF"]
[]
[null,"Increm. Ann. Impact",{"$f":"SUM(C48:C50)","v":27},{"$f":"SUM(D48:D50)","v":26.29},{"$f":"SUM(E48:E50)","v":26.4},{"$f":"SUM(F48:F50)","v":26.29}]
[]
[null,2021,"Average Usage",null,"Tier 1 Usage"]
[null,null,"Non-CAP","CAP","Non-CAP","CAP"]
[null,"Service Charge","To be filled out for all relevant escalation years.",null,null,null,"From $X.XX to $X.XX per month"]
[null,"Quantity Charge",null,null,null,null,"From $X.XXX to $X.XXX per CCF"]
[]
[null,"Increm. Ann. Impact",{"$f":"SUM(C55:C57)","v":0},{"$f":"SUM(D55:D57)","v":0},{"$f":"SUM(E55:E57)","v":0},{"$f":"SUM(F55:F57)","v":0}]
[]
[null,"Notes and Assumptions:"]
[null,"CPUC User Fee of 1.23% corresponds to the most recent resolution setting the User Fee (i.e., Resolution M-4839). Update as necessary."]
[null,"Current Residential Average Annual Bill based on most common residential meter size for RMA, which is _____."]
[null,"Average annual bill calculated with all surcharges, fees, etc. active as of form submission date."]
[null,"Average annual bill above does not include any pending or scheduled filings."]
[null,"City tax on water utility services (percentage of bill amount) ranges from __% to __ % within the RMA, no city tax amount included in average bill above since most areas are not assessed a tax on water services."]

{"sheet":"Table Ex4-Impact to Avg Bill","index":9,"n_rows":151,"n_cols":13,"rows_kept":151,"cut":false,"hidden":false,"merged":[[3,8,3,12],[4,0,38,0],[40,0,74,0],[76,0,110,0],[112,0,146,0]]}
[null,"Company: ",null,null,null,"Filing Date:","2019-09-01"]
[null,"Ratemaking Area:",null,null,null,"Filing Year:",2019]
[]
[null,null,null,null,null,null,null,null,"Annual Bill Impacts \n(For Both Non-CAP and CAP Customers at Average and Tier 1 Usage Amounts)"]
["Non-CAP Residential Customers - Average Usage","Status","Proceedings ","Footnote Reference","Description of Filing","Revenue Recovery Mechanism ","Effective Date or Proposed Effective Date","Expiration Date or Proposed Expiration Date",2019,2020,2021,2022,2023]
[null,"Baseline bill (incl. service & quantity charges)","D.XX-XX-XXX/A. or AL",null,null,null,null,null,{"$f":"Baseline_Bill_Non_LIRA_Avg_Exp","v":276},{"$f":"Baseline_Bill_Non_LIRA_Avg_Exp","v":276},{"$f":"Baseline_Bill_Non_LIRA_Avg_Exp","v":276},{"$f":"Baseline_Bill_Non_LIRA_Avg_Exp","v":276},{"$f":"Baseline_Bill_Non_LIRA_Avg_Exp","v":276}]
[null,"CAP Surcharge","A.18-XX-XXX; D.19-XX-XXX",null,"(e.g., Bal. Acct., IRMA, WRAM)","(e.g., amortization of balancing account, GRC base rate increase, etc.)",null,null,{"$f":"'Table Ex3-Current Bill'!C15","v":15},{"$f":"'Table Ex3-Current Bill'!C15","v":15},{"$f":"'Table Ex3-Current Bill'!C15","v":15},"TBD","TBD"]
[null,"Temporary Surcharge #1","A.18-XX-XXX; D.19-XX-XXX",null,null,null,"2018-01-01","2019-10-01",{"$f":"'Table Ex3-Current Bill'!C16","v":22.5},0,0,0,0]
[null,"Temporary Surcharge #2","AL # XXXX",null,null,null,"2019-07-01","2020-03-01",{"$f":"'Table Ex3-Current Bill'!C17","v":0.75},{"$f":"ROUND((Non_LIRA_Avg_Usage_Exp*0.01),2)*(2/12)","v":0.25},0,0,0]
[]
[]
[]
[]
[null,"Total Active",null,null,null,null,null,null,{"$f":"SUM(I7:I13)","v":38.25},{"$f":"SUM(J7:J13)","v":15.25},{"$f":"SUM(K7:K13)","v":15},{"$f":"SUM(L7:L13)","v":0},{"$f":"SUM(M7:M13)","v":0}]
[]
[null,"Pending (New)","AL # XXXX",null,"2019 Estimated Escalation Year Increase, Pending Earnings Test","Base rate increase","2020-01-01",null,0,{"$f":"'Table Ex3-Current Bill'!C51","v":27},{"$f":"J16","v":27},"Not applicable","Not applicable"]
[]
[]
[]
[]
[]
[null,"Total Pending ",null,null,null,null,null,null,{"$f":"SUM(I16:I21)","v":0},{"$f":"SUM(J16:J21)","v":27},{"$f":"SUM(K16:K21)","v":27},{"$f":"SUM(L16:L21)","v":0},{"$f":"SUM(M16:M21)","v":0}]
[]
[null,"Anticipated","Advice Letter",null,"IRMA (as appropriate)","No change to stated rev. req.",null,null,"Fill in these cells according to the instructions."]
[null,"Anticipated","Advice Letter",null,"20XX Estimated Escalation Year Increase, Pending Earnings Test","Base rate increase (est.)",null,null,"As an example for cases where dollar estimates are not available, appropriate cell highlighting is depicted below for a hypothetical 2020 GRC."]
[null,"Anticipated","Advice Letter",null,"20XX WRAM/MCBA","Amort. of balancing acct."]
[null,"Anticipated","Advice Letter",null,"20XX WRAM/MCBA","Amort. of balancing acct."]
[null,"Anticipated","Advice Letter",null,"20XX WRAM/MCBA","Amort. of balancing acct."]
[null,"Anticipated","Advice Letter",null,"Supply Cost Offset","Base rate change"]
[null,"Anticipated","Advice Letter",null,"Supply Cost Offset","Base rate change"]
[null,"Anticipated","Advice Letter",null,"Rate base offsets (ALPs)","Base rate increase"]
[null,"Anticipated","Advice Letter",null,"Cost of capital","Base rate change",null,null,null,"TBD","TBD","TBD"]
[null,"Anticipated","Application",null,"2020 GRC","Base rate change",null,null,"Not applicable","Not applicable","Not applicable","TBD","TBD"]
[]
[]
[null,"Total Anticipated",null,null,null,null,null,null,{"$f":"SUM(I24:I35)","v":0},{"$f":"SUM(J24:J35)","v":0},{"$f":"SUM(K24:K35)","v":0},{"$f":"SUM(L24:L35)","v":0},{"$f":"SUM(M24:M35)","v":0}]
[null,"CPUC Fee",null,1,null,null,null,null,{"$f":"SUM(I6+I14+I22+I36)*0.0123","v":3.865275},{"$f":"SUM(J6+J14+J22+J36)*0.0123","v":3.9144749999999999},{"$f":"SUM(K6+K14+K22+K36)*0.0123","v":3.9114},{"$f":"SUM(L6+L14+L22+L36)*0.0123","v":3.3948},{"$f":"SUM(M6+M14+M22+M36)*0.0123","v":3.3948}]
[null,"Total Estimated Annual Bill, Not Including TBD Amounts",null,null,null,null,null,null,{"$f":"SUM(I6+I14+I22+I36)*1.0123","v":318.115275},{"$f":"SUM(J6+J14+J22+J36)*1.0123","v":322.16447499999998},{"$f":"SUM(K6+K14+K22+K36)*1.0123","v":321.91140000000001},{"$f":"SUM(L6+L14+L22+L36)*1.0123","v":279.39479999999998},{"$f":"SUM(M6+M14+M22+M36)*1.0123","v":279.39479999999998}]
[null,"Change in Estimated Annual Bill, as Compared to Year 1",null,null,null,null,null,null,"n/a",{"$f":"J38-I38","v":4.0491999999999848},{"$f":"K38-I38","v":3.7961250000000177},{"$f":"L38-I38","v":-38.720475000000022},{"$f":"M38-I38","v":-38.720475000000022}]
[]
["CAP Residential Customers - Average Usage","Status","Proceedings ","Footnote Reference","Description of Filing","Revenue Recovery Mechanism ","Effective Date or Proposed Effective Date","Expiration Date or Proposed Expiration Date",2019,2020,2021,2022,2023]
[null,"Baseline bill (incl. service & quantity charges)","D.XX-XX-XXX/A. or AL",null,null,null,null,null,{"$f":"Baseline_Bill_LIRA_Avg_Exp","v":248.57142857142858},{"$f":"Baseline_Bill_LIRA_Avg_Exp","v":248.57142857142858},{"$f":"Baseline_Bill_LIRA_Avg_Exp","v":248.57142857142858},{"$f":"Baseline_Bill_LIRA_Avg_Exp","v":248.57142857142858},{"$f":"Baseline_Bill_LIRA_Avg_Exp","v":248.57142857142858}]
[null,"Active","A.18-XX-XXX; D.19-XX-XXX",null,"(e.g., Bal. Acct., IRMA, WRAM)","(e.g., amortization of balancing account, GRC base rate increase, etc.)",null,null,"Fill out subsequent panels for different customer classes according to the instructions and the example above."]
[null,"Active","A.18-XX-XXX; D.19-XX-XXX"]
[null,"Active","AL # XXXX"]
[null,"Active","AL # XXXX"]
[null,"Active","AL # XXXX"]
[null,"Active","AL # XXXX"]
[null,"Active","Copy-paste this row as necessary to add additional active filings"]
[null,"Total Active",null,null,null,null,null,null,{"$f":"SUM(I43:I49)","v":0},{"$f":"SUM(J43:J49)","v":0},{"$f":"SUM(K43:K49)","v":0},{"$f":"SUM(L43:L49)","v":0},{"$f":"SUM(M43:M49)","v":0}]
[]
[null,"Pending (New)","AL # XXXX"]
[null,"Pending - Filed","AL # XXXX"]
[null,"Pending - Filed","AL # XXXX"]
[null,"Pending - Filed","AL # XXXX"]
[null,"Pending - Filed","AL # XXXX"]
[null,"Pending - Filed","Copy-paste this row as necessary to add additional pending filings"]
[null,"Total Pending ",null,null,null,null,null,null,{"$f":"SUM(I52:I57)","v":0},{"$f":"SUM(J52:J57)","v":0},{"$f":"SUM(K52:K57)","v":0},{"$f":"SUM(L52:L57)","v":0},{"$f":"SUM(M52:M57)","v":0}]
[]
[null,"Anticipated","Advice Letter",null,"IRMA (as appropriate)","No change to stated rev. req."]
[null,"Anticipated","Advice Letter",null,"20XX Estimated Escalation Year Increase, Pending Earnings Test","Base rate increase (est.)"]
[null,"Anticipated","Advice Letter",null,"20XX Estimated Escalation Year Increase, Pending Earnings Test","Base rate increase (est.)"]
[null,"Anticipated","Advice Letter",null,"20XX WRAM/MCBA","Amort. of balancing acct."]
[null,"Anticipated","Advice Letter",null,"20XX WRAM/MCBA","Amort. of balancing acct."]
[null,"Anticipated","Advice Letter",null,"20XX WRAM/MCBA","Amort. of balancing acct."]
[null,"Anticipated","Advice Letter",null,"Supply Cost Offset","Base rate change"]
[null,"Anticipated","Advice Letter",null,"Supply Cost Offset","Base rate change"]
[null,"Anticipated","Advice Letter",null,"Rate base offsets (ALPs)","Base rate increase"]
[null,"Anticipated","Advice Letter",null,"Cost of capital","Base rate change"]
[null,"Anticipated","Application",null,"20XX GRC","Base rate change"]
[null,"Anticipated","Copy-paste this row as necessary to add additional anticipated filings"]
[null,"Total Anticipated",null,null,null,null,null,null,{"$f":"SUM(I60:I71)","v":0},{"$f":"SUM(J60:J71)","v":0},{"$f":"SUM(K60:K71)","v":0},{"$f":"SUM(L60:L71)","v":0},{"$f":"SUM(M60:M71)","v":0}]
[null,"CPUC Fee",null,1,null,null,null,null,{"$f":"SUM(I42+I50+I58+I72)*0.0123","v":3.0574285714285718},{"$f":"SUM(J42+J50+J58+J72)*0.0123","v":3.0574285714285718},{"$f":"SUM(K42+K50+K58+K72)*0.0123","v":3.0574285714285718},{"$f":"SUM(L42+L50+L58+L72)*0.0123","v":3.0574285714285718},{"$f":"SUM(M42+M50+M58+M72)*0.0123","v":3.0574285714285718}]
[null,"Total Estimated Annual Bill, Not Including TBD Amounts",null,null,null,null,null,null,{"$f":"SUM(I42+I50+I58+I72)*1.0123","v":251.62885714285716},{"$f":"SUM(J42+J50+J58+J72)*1.0123","v":251.62885714285716},{"$f":"SUM(K42+K50+K58+K72)*1.0123","v":251.62885714285716},{"$f":"SUM(L42+L50+L58+L72)*1.0123","v":251.62885714285716},{"$f":"SUM(M42+M50+M58+M72)*1.0123","v":251.62885714285716}]
[null,"Change in Estimated Annual Bill, as Compared to Year 1",null,null,null,null,null,null,"n/a",{"$f":"J74-I74","v":0},{"$f":"K74-I74","v":0},{"$f":"L74-I74","v":0},{"$f":"M74-I74","v":0}]
[]
["Non-CAP Residential Customers - Tier 1 Usage","Status","Proceedings ","Footnote Reference","Description of Filing","Revenue Recovery Mechanism ","Effective Date or Proposed Effective Date","Expiration Date or Proposed Expiration Date",2019,2020,2021,2022,2023]
[null,"Baseline bill (incl. service & quantity charges)","D.XX-XX-XXX/A. or AL",null,null,null,null,null,{"$f":"Baseline_Bill_Non_LIRA_Tier_1_Exp","v":264},{"$f":"Baseline_Bill_Non_LIRA_Tier_1_Exp","v":264},{"$f":"Baseline_Bill_Non_LIRA_Tier_1_Exp","v":264},{"$f":"Baseline_Bill_Non_LIRA_Tier_1_Exp","v":264},{"$f":"Baseline_Bill_Non_LIRA_Tier_1_Exp","v":264}]
[null,"Active","A.18-XX-XXX; D.19-XX-XXX",null,"(e.g., Bal. Acct., IRMA, WRAM)","(e.g., amortization of balancing account, GRC base rate increase, etc.)"]
[null,"Active","A.18-XX-XXX; D.19-XX-XXX"]
[null,"Active","AL # XXXX"]
[null,"Active","AL # XXXX"]
[null,"Active","AL # XXXX"]
[null,"Active","AL # XXXX"]
[null,"Active","Copy-paste this row as necessary to add additional active filings"]
[null,"Total Active",null,null,null,null,null,null,{"$f":"SUM(I79:I85)","v":0},{"$f":"SUM(J79:J85)","v":0},{"$f":"SUM(K79:K85)","v":0},{"$f":"SUM(L79:L85)","v":0},{"$f":"SUM(M79:M85)","v":0}]
[]
[null,"Pending (New)","AL # XXXX"]
[null,"Pending - Filed","AL # XXXX"]
[null,"Pending - Filed","AL # XXXX"]
[null,"Pending - Filed","AL # XXXX"]
[null,"Pending - Filed","AL # XXXX"]
[null,"Pending - Filed","Copy-paste this row as necessary to add additional pending filings"]
[null,"Total Pending ",null,null,null,null,null,null,{"$f":"SUM(I88:I93)","v":0},{"$f":"SUM(J88:J93)","v":0},{"$f":"SUM(K88:K93)","v":0},{"$f":"SUM(L88:L93)","v":0},{"$f":"SUM(M88:M93)","v":0}]
[]
[null,"Anticipated","Advice Letter",null,"IRMA (as appropriate)","No change to stated rev. req."]
[null,"Anticipated","Advice Letter",null,"20XX Estimated Escalation Year Increase, Pending Earnings Test","Base rate increase (est.)"]
[null,"Anticipated","Advice Letter",null,"20XX Estimated Escalation Year Increase, Pending Earnings Test","Base rate increase (est.)"]
[null,"Anticipated","Advice Letter",null,"20XX WRAM/MCBA","Amort. of balancing acct."]
[null,"Anticipated","Advice Letter",null,"20XX WRAM/MCBA","Amort. of balancing acct."]
[null,"Anticipated","Advice Letter",null,"20XX WRAM/MCBA","Amort. of balancing acct."]
[null,"Anticipated","Advice Letter",null,"Supply Cost Offset","Base rate change"]
[null,"Anticipated","Advice Letter",null,"Supply Cost Offset","Base rate change"]
[null,"Anticipated","Advice Letter",null,"Rate base offsets (ALPs)","Base rate increase"]
[null,"Anticipated","Advice Letter",null,"Cost of capital","Base rate change"]
[null,"Anticipated","Application",null,"20XX GRC","Base rate change"]
[null,"Anticipated","Copy-paste this row as necessary to add additional anticipated filings"]
[null,"Total Anticipated",null,null,null,null,null,null,{"$f":"SUM(I96:I107)","v":0},{"$f":"SUM(J96:J107)","v":0},{"$f":"SUM(K96:K107)","v":0},{"$f":"SUM(L96:L107)","v":0},{"$f":"SUM(M96:M107)","v":0}]
[null,"CPUC Fee",null,1,null,null,null,null,{"$f":"SUM(I78+I86+I94+I108)*0.0123","v":3.2471999999999999},{"$f":"SUM(J78+J86+J94+J108)*0.0123","v":3.2471999999999999},{"$f":"SUM(K78+K86+K94+K108)*0.0123","v":3.2471999999999999},{"$f":"SUM(L78+L86+L94+L108)*0.0123","v":3.2471999999999999},{"$f":"SUM(M78+M86+M94+M108)*0.0123","v":3.2471999999999999}]
[null,"Total Estimated Annual Bill, Not Including TBD Amounts",null,null,null,null,null,null,{"$f":"SUM(I78+I86+I94+I108)*1.0123","v":267.24720000000002},{"$f":"SUM(J78+J86+J94+J108)*1.0123","v":267.24720000000002},{"$f":"SUM(K78+K86+K94+K108)*1.0123","v":267.24720000000002},{"$f":"SUM(L78+L86+L94+L108)*1.0123","v":267.24720000000002},{"$f":"SUM(M78+M86+M94+M108)*1.0123","v":267.24720000000002}]
[null,"Change in Estimated Annual Bill, as Compared to Year 1",null,null,null,null,null,null,"n/a",{"$f":"J110-I110","v":0},{"$f":"K110-I110","v":0},{"$f":"L110-I110","v":0},{"$f":"M110-I110","v":0}]
[]
["CAP Residential Customers - Tier 1 Usage","Status","Proceedings ","Footnote Reference","Description of Filing","Revenue Recovery Mechanism ","Effective Date or Proposed Effective Date","Expiration Date or Proposed Expiration Date",2019,2020,2021,2022,2023]
[null,"Baseline bill (incl. service & quantity charges)","D.XX-XX-XXX/A. or AL",null,null,null,null,null,{"$f":"Baseline_Bill_LIRA_Tier_1_Exp","v":248.57142857142858},{"$f":"Baseline_Bill_LIRA_Tier_1_Exp","v":248.57142857142858},{"$f":"Baseline_Bill_LIRA_Tier_1_Exp","v":248.57142857142858},{"$f":"Baseline_Bill_LIRA_Tier_1_Exp","v":248.57142857142858},{"$f":"Baseline_Bill_LIRA_Tier_1_Exp","v":248.57142857142858}]
[null,"Active","A.18-XX-XXX; D.19-XX-XXX",null,"(e.g., Bal. Acct., IRMA, WRAM)","(e.g., amortization of balancing account, GRC base rate increase, etc.)"]
[null,"Active","A.18-XX-XXX; D.19-XX-XXX"]
[null,"Active","AL # XXXX"]
[null,"Active","AL # XXXX"]
[null,"Active","AL # XXXX"]
[null,"Active","AL # XXXX"]
[null,"Active","Copy-paste this row as necessary to add additional active filings"]
[null,"Total Active",null,null,null,null,null,null,{"$f":"SUM(I115:I121)","v":0},{"$f":"SUM(J115:J121)","v":0},{"$f":"SUM(K115:K121)","v":0},{"$f":"SUM(L115:L121)","v":0},{"$f":"SUM(M115:M121)","v":0}]
[]
[null,"Pending (New)","AL # XXXX"]
[null,"Pending - Filed","AL # XXXX"]
[null,"Pending - Filed","AL # XXXX"]
[null,"Pending - Filed","AL # XXXX"]
[null,"Pending - Filed","AL # XXXX"]
[null,"Pending - Filed","Copy-paste this row as necessary to add additional pending filings"]
[null,"Total Pending ",null,null,null,null,null,null,{"$f":"SUM(I124:I129)","v":0},{"$f":"SUM(J124:J129)","v":0},{"$f":"SUM(K124:K129)","v":0},{"$f":"SUM(L124:L129)","v":0},{"$f":"SUM(M124:M129)","v":0}]
[]
[null,"Anticipated","Advice Letter",null,"IRMA (as appropriate)","No change to stated rev. req."]
[null,"Anticipated","Advice Letter",null,"20XX Estimated Escalation Year Increase, Pending Earnings Test","Base rate increase (est.)"]
[null,"Anticipated","Advice Letter",null,"20XX Estimated Escalation Year Increase, Pending Earnings Test","Base rate increase (est.)"]
[null,"Anticipated","Advice Letter",null,"20XX WRAM/MCBA","Amort. of balancing acct."]
[null,"Anticipated","Advice Letter",null,"20XX WRAM/MCBA","Amort. of balancing acct."]
[null,"Anticipated","Advice Letter",null,"20XX WRAM/MCBA","Amort. of balancing acct."]
[null,"Anticipated","Advice Letter",null,"Supply Cost Offset","Base rate change"]
[null,"Anticipated","Advice Letter",null,"Supply Cost Offset","Base rate change"]
[null,"Anticipated","Advice Letter",null,"Rate base offsets (ALPs)","Base rate increase"]
[null,"Anticipated","Advice Letter",null,"Cost of capital","Base rate change"]
[null,"Anticipated","Application",null,"20XX GRC","Base rate change"]
[null,"Anticipated","Copy-paste this row as necessary to add additional anticipated filings"]
[null,"Total Anticipated",null,null,null,null,null,null,{"$f":"SUM(I132:I143)","v":0},{"$f":"SUM(J132:J143)","v":0},{"$f":"SUM(K132:K143)","v":0},{"$f":"SUM(L132:L143)","v":0},{"$f":"SUM(M132:M143)","v":0}]
[null,"CPUC Fee",null,1,null,null,null,null,{"$f":"SUM(I114+I122+I130+I144)*0.0123","v":3.0574285714285718},{"$f":"SUM(J114+J122+J130+J144)*0.0123","v":3.0574285714285718},{"$f":"SUM(K114+K122+K130+K144)*0.0123","v":3.0574285714285718},{"$f":"SUM(L114+L122+L130+L144)*0.0123","v":3.0574285714285718},{"$f":"SUM(M114+M122+M130+M144)*0.0123","v":3.0574285714285718}]
[null,"Total Estimated Annual Bill, Not Including TBD Amounts",null,null,null,null,null,null,{"$f":"SUM(I114+I122+I130+I144)*1.0123","v":251.62885714285716},{"$f":"SUM(J114+J122+J130+J144)*1.0123","v":251.62885714285716},{"$f":"SUM(K114+K122+K130+K144)*1.0123","v":251.62885714285716},{"$f":"SUM(L114+L122+L130+L144)*1.0123","v":251.62885714285716},{"$f":"SUM(M114+M122+M130+M144)*1.0123","v":251.62885714285716}]
[null,"Change in Estimated Annual Bill, as Compared to Year 1",null,null,null,null,null,null,"n/a",{"$f":"J146-I146","v":0},{"$f":"K146-I146","v":0},{"$f":"L146-I146","v":0},{"$f":"M146-I146","v":0}]
[]
[]
[null,"Footnotes and Assumptions:"]
[null,"1. CPUC User Fee of 1.23% corresponds to the most recent resolution setting the User Fee (i.e., Resolution M-4839). Update as necessary."]