{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Calculator","Rebundled Rates","Rates","Data & Calculations","RC PasteDataHere","RC Calculations","RC Results","Changelog"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Calculator","index":0,"n_rows":46,"n_cols":9,"rows_kept":46,"cut":false,"hidden":false,"merged":[[3,2,3,7],[7,2,7,7],[28,2,28,7],[31,2,31,7],[37,2,37,7]]}
[]
[]
[null,null,"Residential Cost Comparison Calculator",null,null,null,null,null,"Updated 3/5/19"]
[]
[]
[null,null,{"$f":"IF(ISNUMBER(SEARCH(\"-1\",D9)),\"Enter Your Total Monthly Usage (kWh)\",\"\")","v":"Enter Your Total Monthly Usage (kWh)"},null,"Select Your Billing Month","May-Oct"]
[null,null,"                   (usage details can typically be found on the third page of your bill)",null,"           (select which range of months your bill falls in)"]
[null,null,"Additional Rate Options"]
[null,null,"Non-Basic Rate Schedule","Basic Residential (E-1)"]
[null,null,{"$f":"IF(VLOOKUP($D$9,Rates!$A$2:$H$16,3,FALSE)=FALSE,\"\",\"Summer Peak Usage (kWh)\")","v":""},null,null,{"$f":"IF(VLOOKUP($D$9,Rates!$A$2:$H$16,6,FALSE)=FALSE,\"\",\"Winter Peak Usage (kWh)\")","v":""}]
[null,null,{"$f":"IF(VLOOKUP($D$9,Rates!$A$2:$H$16,4,FALSE)=FALSE,\"\",\"Summer Partial Peak Usage (kWh)\")","v":""},null,null,{"$f":"IF(VLOOKUP($D$9,Rates!$A$2:$H$16,7,FALSE)=FALSE,\"\",\"Winter Partial Peak Usage (kWh)\")","v":""}]
[null,null,{"$f":"IF(VLOOKUP($D$9,Rates!$A$2:$H$16,5,FALSE)=FALSE,\"\",\"Summer Off Peak Usage (kWh)\")","v":""},null,null,{"$f":"IF(VLOOKUP($D$9,Rates!$A$2:$H$16,8,FALSE)=FALSE,\"\",\"Winter Off Peak Usage (kWh)\")","v":""}]
[]
[null,null,null,"Optional Information (Default Values Represent a Typical Customer)"]
[null,null,"Days in Billing Cycle",31,null,"Baseline Territory (click for map)","X"]
[null,null,"Primary Heating Source","Gas",null,"PCIA Vintage (from PG&E Delivery bill page)",2014]
[]
[]
[null,null,null,null,"PG&E Service","SCP CleanStart","SCP EverGreen"]
[null,null,null,"PG&E Delivery Costs",{"$f":"IFERROR('Data & Calculations'!B76,0)","v":0},{"$f":"E20","v":0},{"$f":"E20","v":0}]
[null,null,null,"Generation Costs",{"$f":"'Data & Calculations'!B77","v":0},{"$f":"'Data & Calculations'!C77","v":0},{"$f":"F21+'Data & Calculations'!I59*'Data & Calculations'!B71","v":0}]
[null,null,null,"Additional PG&E Fees","--",{"$f":"'Data & Calculations'!C78","v":0},{"$f":"F22","v":0}]
[null,null,null,"Energy Comission Surcharge",{"$f":"'Data & Calculations'!B79","v":0},{"$f":"'Data & Calculations'!C79","v":0},{"$f":"'Data & Calculations'!C79","v":0}]
[null,null,null,"Total Electric Charges",{"$f":"SUM(E20:E23)","v":0},{"$f":"SUM(F20:F23)","v":0},{"$f":"SUM(G20:G23)","v":0}]
[]
[]
[null,null,"Frequently Asked Questions:"]
[null,null,"Q: I have the CARE (California Affordable Rates for Energy) discount. Will I still receive this with SCP?"]
[null,null,"A: CARE is a state-mandated program that all customers pay into. You'll receive your full CARE discount as a customer of PG&E or SCP. You can select CARE rates under Advanced Options above."]
[]
[null,null,"Q: I have medical equipment at home and am granted a special rate by PG&E (Medical Baseline). Will I still receive this with SCP?"]
[null,null,"A: SCP customers remain eligible for medical baseline and will still receive this discount in-full. Additionally, Medical Baseline customers are exempt from additional PG&E fees."]
[]
[null,null,"Q: Does SCP offer special rates for Electric Vehicle owners?"]
[null,null,"A: Yes, select \"Advanced Options\" above and select the Electric Vehicle rate. You will need to enter your time-of-use based usage."]
[]
[null,null,"Q: Are SCP customers exempt from tiered rates, where I pay higher rates as I use more electricity each month?"]
[null,null,"A: No. Tiered rates are part of PG&E's rate structure mandated by the California Public Utilities Commission, and are assessed through only PG&E delivery charges."]
[]
[]
[null,null,"Energy Content Breakdown","Renewable Content","Emissions Factor*","Estimated Emissions","Service Description"]
[null,null,"SCP CleanStart (45%)",0.45,127.98,{"$f":"CONCATENATE(ROUND(SUM(D$10:G$12,D$6)*E42/1000,1),\" lbs.\")","v":"0 lbs."},"Basic SCP service (default)"]
[null,null,"SCP EverGreen (100%)",1,53,{"$f":"CONCATENATE(ROUND(SUM(D$10:G$12,D$6)*E43/1000,1),\" lbs.\")","v":"0 lbs."},"Optional 100% renewable SCP service"]
[null,null,"PG&E Standard",0.33,405,"0 lbs.","Basic PG&E service (opt out)"]
[null,null,"PG&E Solar Choice (100%)",1,0,"0 lbs.","Optional 100% solar PG&E service"]
[null,null,"* Emissions factors as of most currently available calendar year for both PG&E and SCP as reported to The Climate Registry, this may result in different years being presented. "]

{"sheet":"Rebundled Rates","index":1,"n_rows":56,"n_cols":14,"rows_kept":56,"cut":false,"hidden":true,"merged":[[47,0,47,13],[48,3,48,6],[48,10,48,13],[20,10,20,13],[20,3,20,6],[26,3,26,6],[26,10,26,13],[34,3,34,6],[34,10,34,13],[42,3,42,6],[42,10,42,13],[1,3,1,6],[0,1,0,6],[0,8,0,13],[1,10,1,13],[6,3,6,6],[6,10,6,13]]}
[null,"Rates for Usage",null,null,null,null,null,null,"Rates for Surplus Generation (Excess NEM Credits at billing date)"]
[{"$f":"Rates!A3","v":"Basic Residential (E-1)"},"SCP Rebundled","PG&E Bundled","Result",null,null,null,null,"SCP Rebundled","PG&E Bundled","Result"]
["Up to Baseline",{"$f":"C3-VLOOKUP($A$2,Rates!$A$23:$H$38,2,0)+VLOOKUP($A$2,Rates!$A$41:$H$56,2,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.20932999999999999},{"$f":"VLOOKUP(A$2,Rates!$A$2:$AB$20,2,0)","v":0.21775},"SCP's rate is",{"$f":"IF(B3<C3,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C3-B3)","v":8.4200000000000108E-3},"per kWh",null,{"$f":"B3+0.01","v":0.21933},{"$f":"C3","v":0.21775},"SCP's rate is",{"$f":"IF(I3<J3,\"lower by\",\"higher by\")","v":"higher by"},{"$f":"ABS(J3-I3)","v":1.5799999999999981E-3},"per kWh"]
["100%-200% of Baseline",{"$f":"C4-VLOOKUP($A$2,Rates!$A$23:$H$38,2,0)+VLOOKUP($A$2,Rates!$A$41:$H$56,2,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.2656},{"$f":"VLOOKUP(A$2,Rates!$A$2:$AB$20,12,0)","v":0.27401999999999999},"SCP's rate is",{"$f":"IF(B4<C4,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C4-B4)","v":8.4199999999999831E-3},"per kWh",null,{"$f":"B4+0.01","v":0.27560000000000001},{"$f":"C4","v":0.27401999999999999},"SCP's rate is",{"$f":"IF(I4<J4,\"lower by\",\"higher by\")","v":"higher by"},{"$f":"ABS(J4-I4)","v":1.5800000000000258E-3},"per kWh"]
["High Usage (over 400%)",{"$f":"C5-VLOOKUP($A$2,Rates!$A$23:$H$38,2,0)+VLOOKUP($A$2,Rates!$A$41:$H$56,2,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.47167000000000003},{"$f":"VLOOKUP(A$2,Rates!$A$2:$AB$20,21,0)","v":0.48009000000000002},"SCP's rate is","lower by",8.4199999999999831E-3,"per kWh",null,0.48167000000000004,0.48009000000000002,"SCP's rate is","higher by",1.5800000000000258E-3,"per kWh"]
[]
[{"$f":"Rates!A5","v":"E-TOU-A"},"SCP Rebundled","PG&E Bundled","Result",null,null,null,null,"SCP Rebundled","PG&E Bundled","Result"]
["Summer Peak"]
["… up to Baseline",{"$f":"C9-VLOOKUP($A$7,Rates!$A$23:$H$38,3,0)+VLOOKUP($A$7,Rates!$A$41:$H$56,3,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.30684000000000006},{"$f":"VLOOKUP(A$7,Rates!$A$2:$AB$20,3,0)","v":0.31732000000000005},"SCP's rate is",{"$f":"IF(B9<C9,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C9-B9)","v":1.0479999999999989E-2},"per kWh",null,{"$f":"B9+0.01","v":0.31684000000000007},{"$f":"C9","v":0.31732000000000005},"SCP's rate is",{"$f":"IF(I9<J9,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(J9-I9)","v":4.7999999999998044E-4},"per kWh"]
["… above Baseline",{"$f":"C10-VLOOKUP($A$7,Rates!$A$23:$H$38,3,0)+VLOOKUP($A$7,Rates!$A$41:$H$56,3,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.38685000000000008},{"$f":"VLOOKUP(A$7,Rates!$A$2:$AB$20,13,0)","v":0.39733000000000002},"SCP's rate is","lower by",1.0479999999999934E-2,"per kWh",null,{"$f":"B10+0.01","v":0.39685000000000009},{"$f":"C10","v":0.39733000000000002},"SCP's rate is","lower by",4.7999999999992493E-4,"per kWh"]
["Summer Off Peak"]
["… up to Baseline",{"$f":"C12-VLOOKUP($A$7,Rates!$A$23:$H$38,5,0)+VLOOKUP($A$7,Rates!$A$41:$H$56,5,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.23277999999999996},{"$f":"VLOOKUP(A$7,Rates!$A$2:$AB$20,5,0)","v":0.24173999999999998},"SCP's rate is",{"$f":"IF(B12<C12,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C12-B12)","v":8.9600000000000235E-3},"per kWh",null,{"$f":"B12+0.01","v":0.24277999999999997},{"$f":"C12","v":0.24173999999999998},"SCP's rate is","higher by",1.0399999999999854E-3,"per kWh"]
["… above Baseline",{"$f":"C13-VLOOKUP($A$7,Rates!$A$23:$H$38,5,0)+VLOOKUP($A$7,Rates!$A$41:$H$56,5,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.31278999999999996},{"$f":"VLOOKUP(A$7,Rates!$A$2:$AB$20,15,0)","v":0.32174999999999998},"SCP's rate is","lower by",8.9600000000000235E-3,"per kWh",null,{"$f":"B13+0.01","v":0.32278999999999997},{"$f":"C13","v":0.32174999999999998},"SCP's rate is","higher by",1.0399999999999854E-3,"per kWh"]
["Winter Peak"]
["… up to Baseline",{"$f":"C15-VLOOKUP($A$7,Rates!$A$23:$H$38,6,0)+VLOOKUP($A$7,Rates!$A$41:$H$56,6,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.19122999999999998},{"$f":"VLOOKUP(A$7,Rates!$A$2:$AB$20,6,0)","v":0.19933999999999999},"SCP's rate is","lower by",8.1100000000000061E-3,"per kWh",null,{"$f":"B15+0.01","v":0.20122999999999999},{"$f":"C15","v":0.19933999999999999},"SCP's rate is","higher by",1.8900000000000028E-3,"per kWh"]
["… above Baseline",{"$f":"C16-VLOOKUP($A$7,Rates!$A$23:$H$38,6,0)+VLOOKUP($A$7,Rates!$A$41:$H$56,6,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.27123999999999998},{"$f":"VLOOKUP(A$7,Rates!$A$2:$AB$20,16,0)","v":0.27934999999999999},"SCP's rate is","lower by",8.1100000000000061E-3,"per kWh",null,{"$f":"B16+0.01","v":0.28123999999999999},{"$f":"C16","v":0.27934999999999999},"SCP's rate is","higher by",1.8900000000000028E-3,"per kWh"]
["Winter Off Peak"]
["… up to Baseline",{"$f":"C18-VLOOKUP($A$7,Rates!$A$23:$H$38,8,0)+VLOOKUP($A$7,Rates!$A$41:$H$56,8,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.17723000000000003},{"$f":"VLOOKUP(A$7,Rates!$A$2:$AB$20,8,0)","v":0.18505000000000002},"SCP's rate is","lower by",7.8199999999999936E-3,"per kWh",null,{"$f":"B18+0.01","v":0.18723000000000004},{"$f":"C18","v":0.18505000000000002},"SCP's rate is","higher by",2.1800000000000153E-3,"per kWh"]
["… above Baseline",{"$f":"C19-VLOOKUP($A$7,Rates!$A$23:$H$38,8,0)+VLOOKUP($A$7,Rates!$A$41:$H$56,8,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.25724000000000002},{"$f":"VLOOKUP(A$7,Rates!$A$2:$AB$20,18,0)","v":0.26506000000000002},"SCP's rate is","lower by",7.8199999999999936E-3,"per kWh",null,{"$f":"B19+0.01","v":0.26724000000000003},{"$f":"C19","v":0.26506000000000002},"SCP's rate is","higher by",2.1800000000000153E-3,"per kWh"]
[]
[{"$f":"Rates!A6","v":"E-TOU-B"},"SCP Rebundled","PG&E Bundled","Result",null,null,null,null,"SCP Rebundled","PG&E Bundled","Result"]
["Summer Peak",{"$f":"C22-VLOOKUP($A$21,Rates!$A$23:$H$38,3,0)+VLOOKUP($A$21,Rates!$A$41:$H$56,3,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.36361000000000004},{"$f":"VLOOKUP(A$21,Rates!$A$2:$AB$20,3,0)","v":0.37522},"SCP's rate is",{"$f":"IF(B22<C22,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C22-B22)","v":1.1609999999999954E-2},"per kWh",null,{"$f":"B22+0.01","v":0.37361000000000005},{"$f":"C22","v":0.37522},"SCP's rate is",{"$f":"IF(I22<J22,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(J22-I22)","v":1.6099999999999448E-3},"per kWh"]
["Summer Off Peak",{"$f":"C23-VLOOKUP($A$21,Rates!$A$23:$H$38,5,0)+VLOOKUP($A$21,Rates!$A$41:$H$56,5,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.26261000000000001},{"$f":"VLOOKUP(A$21,Rates!$A$2:$AB$20,5,0)","v":0.27216000000000001},"SCP's rate is",{"$f":"IF(B23<C23,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C23-B23)","v":9.5500000000000029E-3},"per kWh",null,{"$f":"B23+0.01","v":0.27261000000000002},{"$f":"C23","v":0.27216000000000001},"SCP's rate is",{"$f":"IF(I23<J23,\"lower by\",\"higher by\")","v":"higher by"},{"$f":"ABS(J23-I23)","v":4.5000000000000595E-4},"per kWh"]
["Winter Peak",{"$f":"C24-VLOOKUP($A$21,Rates!$A$23:$H$38,6,0)+VLOOKUP($A$21,Rates!$A$41:$H$56,6,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.22888},{"$f":"VLOOKUP(A$21,Rates!$A$2:$AB$20,6,0)","v":0.23774000000000001},"SCP's rate is","lower by",8.8600000000000068E-3,"per kWh",null,{"$f":"B24+0.01","v":0.23888000000000001},{"$f":"C24","v":0.23774000000000001},"SCP's rate is","higher by",1.1400000000000021E-3,"per kWh"]
["Winter Off Peak",{"$f":"C25-VLOOKUP($A$21,Rates!$A$23:$H$38,8,0)+VLOOKUP($A$21,Rates!$A$41:$H$56,8,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.21045},{"$f":"VLOOKUP(A$21,Rates!$A$2:$AB$20,8,0)","v":0.21894},"SCP's rate is","lower by",8.4899999999999975E-3,"per kWh",null,{"$f":"B25+0.01","v":0.22045000000000001},{"$f":"C25","v":0.21894},"SCP's rate is","higher by",1.5100000000000113E-3,"per kWh"]
[]
[{"$f":"Rates!A11","v":"EV-A"},"SCP Rebundled","PG&E Bundled","Result",null,null,null,null,"SCP Rebundled","PG&E Bundled","Result"]
["Summer Peak",{"$f":"C28-VLOOKUP($A$27,Rates!$A$23:$H$38,3,0)+VLOOKUP($A$27,Rates!$A$41:$H$56,3,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.46988999999999997},{"$f":"VLOOKUP(A$27,Rates!$A$2:$AB$20,3,0)","v":0.48888999999999999},"SCP's rate is",{"$f":"IF(B28<C28,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C28-B28)","v":1.9000000000000017E-2},"per kWh",null,{"$f":"B28+0.01","v":0.47988999999999998},{"$f":"C28","v":0.48888999999999999},"SCP's rate is",{"$f":"IF(I28<J28,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(J28-I28)","v":9.000000000000008E-3},"per kWh"]
["Summer Partial Peak",{"$f":"C29-VLOOKUP($A$27,Rates!$A$23:$H$38,4,0)+VLOOKUP($A$27,Rates!$A$41:$H$56,4,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.25520999999999999},{"$f":"VLOOKUP(A$27,Rates!$A$2:$AB$20,4,0)","v":0.26502999999999999},"SCP's rate is",{"$f":"IF(B29<C29,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C29-B29)","v":9.8199999999999954E-3},"per kWh",null,{"$f":"B29+0.01","v":0.26521},{"$f":"C29","v":0.26502999999999999},"SCP's rate is",{"$f":"IF(I29<J29,\"lower by\",\"higher by\")","v":"higher by"},{"$f":"ABS(J29-I29)","v":1.8000000000001348E-4},"per kWh"]
["Summer Off Peak",{"$f":"C30-VLOOKUP($A$27,Rates!$A$23:$H$38,5,0)+VLOOKUP($A$27,Rates!$A$41:$H$56,5,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.1207},{"$f":"VLOOKUP(A$27,Rates!$A$2:$AB$20,5,0)","v":0.12559000000000001},"SCP's rate is","lower by",4.8900000000000055E-3,"per kWh",null,{"$f":"B30+0.01","v":0.13070000000000001},{"$f":"C30","v":0.12559000000000001},"SCP's rate is","higher by",5.1100000000000034E-3,"per kWh"]
["Winter Peak",{"$f":"C31-VLOOKUP($A$27,Rates!$A$23:$H$38,6,0)+VLOOKUP($A$27,Rates!$A$41:$H$56,6,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.33001000000000003},{"$f":"VLOOKUP(A$27,Rates!$A$2:$AB$20,6,0)","v":0.34021000000000001},"SCP's rate is","lower by",1.0199999999999987E-2,"per kWh",null,{"$f":"B31+0.01","v":0.34001000000000003},{"$f":"C31","v":0.34021000000000001},"SCP's rate is","lower by",1.9999999999997797E-4,"per kWh"]
["Winter Partial Peak",{"$f":"C32-VLOOKUP($A$27,Rates!$A$23:$H$38,7,0)+VLOOKUP($A$27,Rates!$A$41:$H$56,7,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.20666999999999999},{"$f":"VLOOKUP(A$27,Rates!$A$2:$AB$20,7,0)","v":0.20726},"SCP's rate is",{"$f":"IF(B32<C32,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C32-B32)","v":5.9000000000000719E-4},"per kWh",null,{"$f":"B32+0.01","v":0.21667},{"$f":"C32","v":0.20726},"SCP's rate is",{"$f":"IF(I32<J32,\"lower by\",\"higher by\")","v":"higher by"},{"$f":"ABS(J32-I32)","v":9.4100000000000017E-3},"per kWh"]
["Winter Off Peak",{"$f":"C33-VLOOKUP($A$27,Rates!$A$23:$H$38,8,0)+VLOOKUP($A$27,Rates!$A$41:$H$56,8,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.11787},{"$f":"VLOOKUP(A$27,Rates!$A$2:$AB$20,8,0)","v":0.12866},"SCP's rate is","lower by",1.0789999999999994E-2,"per kWh",null,0.12787000000000001,0.12866,"SCP's rate is","lower by",7.8999999999998516E-4,"per kWh"]
[]
[{"$f":"Rates!A12","v":"EV-B"},"SCP Rebundled","PG&E Bundled","Result",null,null,null,null,"SCP Rebundled","PG&E Bundled","Result"]
["Summer Peak",{"$f":"C36-VLOOKUP($A$35,Rates!$A$23:$H$38,3,0)+VLOOKUP($A$35,Rates!$A$41:$H$56,3,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.4632},{"$f":"VLOOKUP(A$35,Rates!$A$2:$AB$20,3,0)","v":0.48220000000000002},"SCP's rate is",{"$f":"IF(B36<C36,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C36-B36)","v":1.9000000000000017E-2},"per kWh",null,{"$f":"B36+0.01","v":0.47320000000000001},{"$f":"C36","v":0.48220000000000002},"SCP's rate is",{"$f":"IF(I36<J36,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(J36-I36)","v":9.000000000000008E-3},"per kWh"]
["Summer Partial Peak",{"$f":"C37-VLOOKUP($A$35,Rates!$A$23:$H$38,4,0)+VLOOKUP($A$35,Rates!$A$41:$H$56,4,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.25186000000000003},{"$f":"VLOOKUP(A$35,Rates!$A$2:$AB$20,4,0)","v":0.26168000000000002},"SCP's rate is",{"$f":"IF(B37<C37,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C37-B37)","v":9.8199999999999954E-3},"per kWh",null,{"$f":"B37+0.01","v":0.26186000000000004},{"$f":"C37","v":0.26168000000000002},"SCP's rate is",{"$f":"IF(I37<J37,\"lower by\",\"higher by\")","v":"higher by"},{"$f":"ABS(J37-I37)","v":1.8000000000001348E-4},"per kWh"]
["Summer Off Peak",{"$f":"C38-VLOOKUP($A$35,Rates!$A$23:$H$38,5,0)+VLOOKUP($A$35,Rates!$A$41:$H$56,5,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.12021999999999999},{"$f":"VLOOKUP(A$35,Rates!$A$2:$AB$20,5,0)","v":0.12511},"SCP's rate is","lower by",4.8900000000000055E-3,"per kWh",null,{"$f":"B38+0.01","v":0.13022},{"$f":"C38","v":0.12511},"SCP's rate is","higher by",5.1100000000000034E-3,"per kWh"]
["Winter Peak",{"$f":"C39-VLOOKUP($A$35,Rates!$A$23:$H$38,6,0)+VLOOKUP($A$35,Rates!$A$41:$H$56,6,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.32288},{"$f":"VLOOKUP(A$35,Rates!$A$2:$AB$20,6,0)","v":0.33307999999999999},"SCP's rate is","lower by",1.0199999999999987E-2,"per kWh",null,{"$f":"B39+0.01","v":0.33288000000000001},{"$f":"C39","v":0.33307999999999999},"SCP's rate is","lower by",1.9999999999997797E-4,"per kWh"]
["Winter Partial Peak",{"$f":"C40-VLOOKUP($A$35,Rates!$A$23:$H$38,7,0)+VLOOKUP($A$35,Rates!$A$41:$H$56,7,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.20310999999999998},{"$f":"VLOOKUP(A$35,Rates!$A$2:$AB$20,7,0)","v":0.20369999999999999},"SCP's rate is","lower by",5.9000000000000719E-4,"per kWh",null,{"$f":"B40+0.01","v":0.21310999999999999},{"$f":"C40","v":0.20369999999999999},"SCP's rate is","higher by",9.4100000000000017E-3,"per kWh"]
["Winter Off Peak",{"$f":"C41-VLOOKUP($A$35,Rates!$A$23:$H$38,8,0)+VLOOKUP($A$35,Rates!$A$41:$H$56,8,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.11735999999999999},{"$f":"VLOOKUP(A$35,Rates!$A$2:$AB$20,8,0)","v":0.12814999999999999},"SCP's rate is","lower by",1.0789999999999994E-2,"per kWh",null,0.12736,0.12814999999999999,"SCP's rate is","lower by",7.8999999999998516E-4,"per kWh"]
[]
[{"$f":"Rates!A46","v":"E-TOU-C3"},"SCP Rebundled","PG&E Bundled","Result",null,null,null,null,"SCP Rebundled","PG&E Bundled","Result"]
["Summer Peak",{"$f":"C44-VLOOKUP($A$43,Rates!$A$23:$H$38,8,0)+VLOOKUP($A$43,Rates!$A$41:$H$56,8,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.28693000000000007},{"$f":"VLOOKUP(A$43,Rates!$A$2:$AB$20,3,0)","v":0.29483000000000004},"SCP's rate is",{"$f":"IF(B44<C44,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C44-B44)","v":7.8999999999999626E-3},"per kWh",null,{"$f":"B44+0.01","v":0.29693000000000008},{"$f":"C44","v":0.29483000000000004},"SCP's rate is",{"$f":"IF(I44<J44,\"lower by\",\"higher by\")","v":"higher by"},{"$f":"ABS(J44-I44)","v":2.1000000000000463E-3},"per kWh"]
["Summer Off Peak",{"$f":"C45-VLOOKUP($A$43,Rates!$A$23:$H$38,8,0)+VLOOKUP($A$43,Rates!$A$41:$H$56,8,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.22348999999999999},{"$f":"VLOOKUP(A$43,Rates!$A$2:$AB$20,5,0)","v":0.23139000000000001},"SCP's rate is",{"$f":"IF(B45<C45,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C45-B45)","v":7.9000000000000181E-3},"per kWh",null,{"$f":"B45+0.01","v":0.23349},{"$f":"C45","v":0.23139000000000001},"SCP's rate is",{"$f":"IF(I45<J45,\"lower by\",\"higher by\")","v":"higher by"},{"$f":"ABS(J45-I45)","v":2.0999999999999908E-3},"per kWh"]
["Winter Peak",{"$f":"C46-VLOOKUP($A$43,Rates!$A$23:$H$38,8,0)+VLOOKUP($A$43,Rates!$A$41:$H$56,8,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.19983999999999999},{"$f":"VLOOKUP(A$43,Rates!$A$2:$AB$20,6,0)","v":0.20774000000000001},"SCP's rate is","lower by",7.9000000000000181E-3,"per kWh",null,{"$f":"B46+0.01","v":0.20984},{"$f":"C46","v":0.20774000000000001},"SCP's rate is","higher by",2.0999999999999908E-3,"per kWh"]
["Winter Off Peak",{"$f":"C47-VLOOKUP($A$43,Rates!$A$23:$H$38,8,0)+VLOOKUP($A$43,Rates!$A$41:$H$56,8,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.18250999999999998},{"$f":"VLOOKUP(A$43,Rates!$A$2:$AB$20,8,0)","v":0.19041},"SCP's rate is","lower by",7.9000000000000181E-3,"per kWh",null,{"$f":"B47+0.01","v":0.19250999999999999},{"$f":"C47","v":0.19041},"SCP's rate is","higher by",2.0999999999999908E-3,"per kWh"]
[" -----  Closed to New Customers (ignores tiering, which is competitively irrelevant) -----"]
[{"$f":"Rates!A15","v":"E-6 (Time-of-Use)"},"SCP Rebundled","PG&E Bundled","Result",null,null,null,null,"SCP Rebundled","PG&E Bundled","Result"]
["Summer Peak",{"$f":"C50-VLOOKUP($A$49,Rates!$A$23:$H$38,3,0)+VLOOKUP($A$49,Rates!$A$41:$H$56,3,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.36069000000000001},{"$f":"VLOOKUP(A$49,Rates!$A$2:$AB$20,3,0)","v":0.37729000000000001},"SCP's rate is",{"$f":"IF(B50<C50,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C50-B50)","v":1.6600000000000004E-2},"per kWh",null,{"$f":"B50+0.01","v":0.37069000000000002},{"$f":"C50","v":0.37729000000000001},"SCP's rate is",{"$f":"IF(I50<J50,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(J50-I50)","v":6.5999999999999948E-3},"per kWh"]
["Summer Partial Peak",{"$f":"C51-VLOOKUP($A$49,Rates!$A$23:$H$38,4,0)+VLOOKUP($A$49,Rates!$A$41:$H$56,4,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.25205},{"$f":"VLOOKUP(A$49,Rates!$A$2:$AB$20,4,0)","v":0.26201999999999998},"SCP's rate is",{"$f":"IF(B51<C51,\"lower by\",\"higher by\")","v":"lower by"},{"$f":"ABS(C51-B51)","v":9.9699999999999789E-3},"per kWh",null,{"$f":"B51+0.01","v":0.26205000000000001},{"$f":"C51","v":0.26201999999999998},"SCP's rate is",{"$f":"IF(I51<J51,\"lower by\",\"higher by\")","v":"higher by"},{"$f":"ABS(J51-I51)","v":3.0000000000030003E-5},"per kWh"]
["Summer Off Peak",{"$f":"C52-VLOOKUP($A$49,Rates!$A$23:$H$38,5,0)+VLOOKUP($A$49,Rates!$A$41:$H$56,5,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.17858999999999997},{"$f":"VLOOKUP(A$49,Rates!$A$2:$AB$20,5,0)","v":0.18523999999999999},"SCP's rate is","lower by",6.650000000000017E-3,"per kWh",null,{"$f":"B52+0.01","v":0.18858999999999998},{"$f":"C52","v":0.18523999999999999},"SCP's rate is","higher by",3.3499999999999919E-3,"per kWh"]
["Winter Partial Peak",{"$f":"C53-VLOOKUP($A$49,Rates!$A$23:$H$38,7,0)+VLOOKUP($A$49,Rates!$A$41:$H$56,7,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.19833999999999999},{"$f":"VLOOKUP(A$49,Rates!$A$2:$AB$20,7,0)","v":0.20641000000000001},"SCP's rate is","lower by",8.0700000000000216E-3,"per kWh",null,{"$f":"B53+0.01","v":0.20834},{"$f":"C53","v":0.20641000000000001},"SCP's rate is","higher by",1.9299999999999873E-3,"per kWh"]
["Winter Off Peak",{"$f":"C54-VLOOKUP($A$49,Rates!$A$23:$H$38,8,0)+VLOOKUP($A$49,Rates!$A$41:$H$56,8,0)+VLOOKUP(MAX('Data & Calculations'!$A$40:$A$46),'Data & Calculations'!$A$40:$D$46,4,0)","v":0.18232999999999999},{"$f":"VLOOKUP(A$49,Rates!$A$2:$AB$20,8,0)","v":0.18958},"SCP's rate is","lower by",7.2500000000000064E-3,"per kWh",null,0.19233,0.18958,"SCP's rate is","higher by",2.7500000000000024E-3,"per kWh"]
[]
["Note: Rebundled rates assume the most current PCIA vintage. Other vintages may result in small adjustments to the above rates."]

{"sheet":"Rates","index":2,"n_rows":55,"n_cols":29,"rows_kept":55,"cut":false,"hidden":true,"merged":[]}
["Bundled Rate"]
["Tier 1","All Usage","Summer Peak","Summer Partial Peak","Summer Off Peak","Winter Peak","Winter Partial Peak","Winter Off Peak","Meter Charge","Minimum Bill","Tier 2","All Usage","S Pk","S Pt","S Off","W Pk","W Pt","W Off",null,"High Usage","All Usage","S Pk","S Pt","S Off","W Pk","W Pt","W Off",null,"Baseline"]
["Basic Residential (E-1)",0.21775,false,false,false,false,false,false,null,0.32854,{"$f":"A3","v":"Basic Residential (E-1)"},0.27401999999999999,false,false,false,false,false,false,null,{"$f":"K3","v":"Basic Residential (E-1)"},0.48009000000000002,false,false,false,false,false,false,null,"Standard"]
["Basic CARE Res. (EL-1)",0.13947000000000001,false,false,false,false,false,false,null,0.16427,{"$f":"A4","v":"Basic CARE Res. (EL-1)"},0.17527999999999999,false,false,false,false,false,false,null,"Basic CARE Res. (EL-1)",0.30708999999999997,false,false,false,false,false,false,null,"Standard"]
["E-TOU-A",{"$f":"L5","v":false},{"$f":"M5+$D$19","v":0.31732000000000005},{"$f":"N5","v":false},{"$f":"O5+D19","v":0.24173999999999998},{"$f":"P5+D19","v":0.19933999999999999},false,{"$f":"R5+D19","v":0.18505000000000002},null,{"$f":"J3","v":0.32854},{"$f":"A5","v":"E-TOU-A"},false,0.39733000000000002,false,0.32174999999999998,0.27934999999999999,false,0.26506000000000002,null,"E-TOU-A",false,0.39733000000000002,false,0.32174999999999998,0.27934999999999999,false,0.26506000000000002,null,"TOU"]
["E-TOU-B",{"$f":"L6","v":false},{"$f":"M6","v":0.37522},false,0.27216000000000001,0.23774000000000001,false,0.21894,null,{"$f":"J3","v":0.32854},"E-TOU-B",false,0.37522,false,0.27216000000000001,0.23774000000000001,false,0.21894,null,"E-TOU-B",false,0.37522,false,0.27216000000000001,0.23774000000000001,false,0.21894,null,"TOU"]
["E-TOU-C3",false,{"$f":"M7+$D$19","v":0.29483000000000004},false,{"$f":"O7+$D$19","v":0.23139000000000001},{"$f":"P7+$D$19","v":0.20774000000000001},false,{"$f":"R7+$D$19","v":0.19041},null,{"$f":"J3","v":0.32854},"E-TOU-C3",false,0.37484000000000001,false,0.31140000000000001,0.28775000000000001,false,0.27041999999999999,null,"E-TOU-C3",{"$f":"L7","v":false},0.37484000000000001,false,0.31140000000000001,0.28775000000000001,false,0.27041999999999999,null,"TOU"]
["EL-TOU-A (CARE)",{"$f":"L8","v":false},{"$f":"M8+D20","v":0.20371},false,{"$f":"O8+D20","v":0.15609999999999999},{"$f":"P8+D20","v":0.12938},false,{"$f":"R8+D20","v":0.12037999999999999},null,{"$f":"J4","v":0.16427},"EL-TOU-A (CARE)",false,0.24348,false,0.19586999999999999,0.16914999999999999,false,0.16014999999999999,null,"EL-TOU-A (CARE)",false,0.24348,false,0.19586999999999999,0.16914999999999999,false,0.16014999999999999,null,"TOU"]
["EL-TOU-B (CARE)",false,0.23133000000000001,false,0.16641,0.14471999999999999,false,0.13288,null,{"$f":"J4","v":0.16427},"EL-TOU-B (CARE)",false,0.23133000000000001,false,0.16641,0.14471999999999999,false,0.13288,null,"EL-TOU-B (CARE)",false,0.23133000000000001,false,0.16641,0.14471999999999999,false,0.13288,null,"TOU"]
["EL-TOU-C3 (CARE)",false,{"$f":"M10+$D$21","v":0.18664},false,{"$f":"O10+$D$21","v":0.14660999999999999},{"$f":"P10+$D$21","v":0.13169},false,{"$f":"R10+$D$21","v":0.12075},null,{"$f":"J4","v":0.16427},"EL-TOU-C3 (CARE)",false,0.23712,false,0.19708999999999999,0.18217,false,0.17122999999999999,null,"EL-TOU-C3 (CARE)",{"$f":"L10","v":false},0.23712,false,0.19708999999999999,0.18217,false,0.17122999999999999,null,"TOU"]
["EV-A",false,0.48888999999999999,0.26502999999999999,0.12559000000000001,0.34021000000000001,0.20726,0.12866,null,{"$f":"J3","v":0.32854},"EV-A",false,0.48888999999999999,0.26502999999999999,0.12559000000000001,0.34021000000000001,0.20726,0.12866,null,"EV-A",false,0.48888999999999999,0.26502999999999999,0.12559000000000001,0.34021000000000001,0.20726,0.12866,null,"Standard"]
["EV-B",false,0.48220000000000002,0.26168000000000002,0.12511,0.33307999999999999,0.20369999999999999,0.12814999999999999,4.9279999999999997E-2,{"$f":"J3","v":0.32854},"EV-B",false,0.48220000000000002,0.26168000000000002,0.12511,0.33307999999999999,0.20369999999999999,0.12814999999999999,null,"EV-B",false,0.48220000000000002,0.26168000000000002,0.12511,0.33307999999999999,0.20369999999999999,0.12814999999999999,null,"Standard"]
[]
[{"$f":"\"--- Closed Rates ---\"","v":"--- Closed Rates ---"},null,null,null,null,null,null,null,null,null,{"$f":"A14","v":"--- Closed Rates ---"},null,null,null,null,null,null,null,null,{"$f":"K14","v":"--- Closed Rates ---"}]
["E-6 (Time-of-Use)",false,0.37729000000000001,0.26201999999999998,0.18523999999999999,false,0.20641000000000001,0.18958,0.25297999999999998,{"$f":"J3","v":0.32854},"E-6 (Time-of-Use)",false,0.45729999999999998,0.34203,0.26524999999999999,false,0.28642000000000001,0.26959,null,{"$f":"K15","v":"E-6 (Time-of-Use)"},false,{"$f":"M15","v":0.45729999999999998},{"$f":"N15","v":0.34203},0.26524999999999999,false,0.28642000000000001,0.26959,null,"Standard"]
["EL-6 (CARE, Time-of-Use)",false,0.25627,0.17177000000000001,0.11549,false,0.13100999999999999,0.11866,0.20238,{"$f":"J4","v":0.16427},"EL-6 (CARE, Time-of-Use)",false,0.29604000000000003,0.21154000000000001,0.15526000000000001,false,0.17077999999999999,0.15842999999999999,null,{"$f":"K16","v":"EL-6 (CARE, Time-of-Use)"},false,{"$f":"M16","v":0.29604000000000003},0.21154000000000001,0.15526000000000001,false,0.17077999999999999,0.15842999999999999,null,"Standard"]
[]
[]
["Baseline Credit (E-TOU only)",null,null,-8.0009999999999998E-2]
["Baseline Credit (EL-TOU only)",null,null,-3.977E-2]
["Baseline Credit (EL-TOU-C3 only)",null,null,-5.0479999999999997E-2]
[]
["PG&E Generation Rate","All Usage",{"$f":"C2","v":"Summer Peak"},"Summer Partial Peak","Summer Off Peak","Winter Peak","Winter Partial Peak","Winter Off Peak"]
[{"$f":"A3","v":"Basic Residential (E-1)"},0.11194,false,false,false,false,false,false]
[{"$f":"A4","v":"Basic CARE Res. (EL-1)"},{"$f":"B24","v":0.11194},false,false,false,false,false,false]
[{"$f":"A5","v":"E-TOU-A"},false,0.19464999999999999,false,0.11907,0.10730000000000001,false,9.3009999999999995E-2]
[{"$f":"A6","v":"E-TOU-B"},false,0.21651999999999999,false,0.11346000000000001,0.10968,false,9.0880000000000002E-2]
["E-TOU-C3",false,0.17058999999999999,false,0.10715,0.11413,false,9.6799999999999997E-2]
[{"$f":"A8","v":"EL-TOU-A (CARE)"},false,{"$f":"C26","v":0.19464999999999999},false,{"$f":"E26","v":0.11907},0.10730000000000001,false,{"$f":"H26","v":9.3009999999999995E-2}]
[{"$f":"A9","v":"EL-TOU-B (CARE)"},false,{"$f":"C27","v":0.21651999999999999},false,0.11346000000000001,0.10968,false,{"$f":"H27","v":9.0880000000000002E-2}]
["EL-TOU-C3 (CARE)",false,{"$f":"C28","v":0.17058999999999999},false,0.10715,0.11413,false,{"$f":"H28","v":9.6799999999999997E-2}]
[{"$f":"A11","v":"EV-A"},false,0.25622,0.12348000000000001,6.2050000000000001E-2,9.5750000000000002E-2,5.9819999999999998E-2,6.4269999999999994E-2]
[{"$f":"A12","v":"EV-B"},false,{"$f":"C32","v":0.25622},{"$f":"D32","v":0.12348000000000001},6.2050000000000001E-2,9.5750000000000002E-2,5.9819999999999998E-2,6.4269999999999994E-2]
[]
[{"$f":"A14","v":"--- Closed Rates ---"}]
[{"$f":"A15","v":"E-6 (Time-of-Use)"},false,0.24687000000000001,0.12969,8.1850000000000006E-2,false,0.10841000000000001,9.5259999999999997E-2]
[{"$f":"A16","v":"EL-6 (CARE, Time-of-Use)"},false,{"$f":"C36","v":0.24687000000000001},{"$f":"D36","v":0.12969},8.1850000000000006E-2,false,0.10841000000000001,9.5259999999999997E-2]
[]
[]
[]
["SCP Generation Rate","All Usage",{"$f":"C2","v":"Summer Peak"},{"$f":"D2","v":"Summer Partial Peak"},"Summer Off Peak","Winter Peak","Winter Partial Peak","Winter Off Peak"]
[{"$f":"A3","v":"Basic Residential (E-1)"},6.948E-2,false,false,false,false,false,false]
[{"$f":"A4","v":"Basic CARE Res. (EL-1)"},{"$f":"B42","v":6.948E-2},false,false,false,false,false,false]
[{"$f":"A5","v":"E-TOU-A"},false,0.15013000000000001,false,7.6069999999999999E-2,6.515E-2,false,5.1150000000000001E-2]
[{"$f":"A6","v":"E-TOU-B"},false,0.17086999999999999,false,6.9870000000000002E-2,6.6780000000000006E-2,false,4.8349999999999997E-2]
["E-TOU-C3",false,0.12656000000000001,false,6.4390000000000003E-2,7.1840000000000001E-2,false,5.4859999999999999E-2]
[{"$f":"A8","v":"EL-TOU-A (CARE)"},false,{"$f":"C44","v":0.15013000000000001},false,{"$f":"E44","v":7.6069999999999999E-2},{"$f":"F44","v":6.515E-2},false,{"$f":"H44","v":5.1150000000000001E-2}]
[{"$f":"A9","v":"EL-TOU-B (CARE)"},false,{"$f":"C45","v":0.17086999999999999},false,{"$f":"E45","v":6.9870000000000002E-2},{"$f":"F45","v":6.6780000000000006E-2},false,{"$f":"H45","v":4.8349999999999997E-2}]
["EL-TOU-C3 (CARE)",false,0.12656000000000001,false,6.4390000000000003E-2,7.1840000000000001E-2,false,5.4859999999999999E-2]
[{"$f":"A11","v":"EV-A"},false,0.20318,7.9619999999999996E-2,2.3120000000000002E-2,5.151E-2,2.5190000000000001E-2,1.9439999999999999E-2]
[{"$f":"A12","v":"EV-B"},false,{"$f":"C50","v":0.20318},{"$f":"D50","v":7.9619999999999996E-2},{"$f":"E50","v":2.3120000000000002E-2},{"$f":"F50","v":5.151E-2},{"$f":"G50","v":2.5190000000000001E-2},{"$f":"H50","v":1.9439999999999999E-2}]
[]
[{"$f":"A14","v":"--- Closed Rates ---"}]
[{"$f":"A15","v":"E-6 (Time-of-Use)"},false,0.19622999999999999,8.5680000000000006E-2,4.1160000000000002E-2,false,6.6299999999999998E-2,5.3969999999999997E-2]
[{"$f":"A16","v":"EL-6 (CARE, Time-of-Use)"},false,{"$f":"C54","v":0.19622999999999999},{"$f":"D54","v":8.5680000000000006E-2},{"$f":"E54","v":4.1160000000000002E-2},{"$f":"F54","v":false},{"$f":"G54","v":6.6299999999999998E-2},{"$f":"H54","v":5.3969999999999997E-2}]

{"sheet":"Data & Calculations","index":3,"n_rows":80,"n_cols":10,"rows_kept":80,"cut":false,"hidden":true,"merged":[]}
["Determined Bundled Rate (automated)"]
[{"$f":"Calculator!D9","v":"Basic Residential (E-1)"},{"$f":"Rates!B2","v":"All Usage"},{"$f":"Rates!C2","v":"Summer Peak"},{"$f":"Rates!D2","v":"Summer Partial Peak"},{"$f":"Rates!E2","v":"Summer Off Peak"},{"$f":"Rates!F2","v":"Winter Peak"},{"$f":"Rates!G2","v":"Winter Partial Peak"},{"$f":"Rates!H2","v":"Winter Off Peak"},{"$f":"Rates!I2","v":"Meter Charge"},{"$f":"Rates!J2","v":"Minimum Bill"}]
["Tier 1",{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$18,MATCH(B$2,Rates!$A$2:$J$2,0),FALSE)","v":0.21775},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$18,MATCH(C$2,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$18,MATCH(D$2,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$18,MATCH(E$2,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$18,MATCH(F$2,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$18,MATCH(G$2,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$18,MATCH(H$2,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"IFERROR(VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$18,MATCH(I$2,Rates!$A$2:$J$2,0),FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$18,MATCH(J2,Rates!$A$2:$J$2,0),FALSE),0)","v":0.32854}]
["Tier 2",{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$18,MATCH(B$2,Rates!$A$2:$J$2,0)+10,FALSE)","v":0.27401999999999999},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$18,MATCH(C$2,Rates!$A$2:$J$2,0)+10,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$18,MATCH(D$2,Rates!$A$2:$J$2,0)+10,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$18,MATCH(E$2,Rates!$A$2:$J$2,0)+10,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$18,MATCH(F$2,Rates!$A$2:$J$2,0)+10,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$18,MATCH(G$2,Rates!$A$2:$J$2,0)+10,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$18,MATCH(H$2,Rates!$A$2:$J$2,0)+10,FALSE)","v":false}]
["Tier 3",{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$18,MATCH(B$2,Rates!$A$2:$J$2,0)+19,FALSE)","v":0.48009000000000002},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$18,MATCH(C$2,Rates!$A$2:$J$2,0)+19,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$18,MATCH(D$2,Rates!$A$2:$J$2,0)+19,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$18,MATCH(E$2,Rates!$A$2:$J$2,0)+19,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$18,MATCH(F$2,Rates!$A$2:$J$2,0)+19,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$18,MATCH(G$2,Rates!$A$2:$J$2,0)+19,FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$3:$AB$18,MATCH(H$2,Rates!$A$2:$J$2,0)+19,FALSE)","v":false}]
[]
["Determined Bundled Charges (automated)"]
[{"$f":"A2","v":"Basic Residential (E-1)"},"All Usage","Summer Peak","Summer Partial Peak","Summer Off Peak","Winter Peak","Winter Partial Peak","Winter Off Peak","Meter Charge","Total"]
[{"$f":"A3","v":"Tier 1"},{"$f":"B3*C65","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"I3*Calculator!D15","v":0}]
[{"$f":"A4","v":"Tier 2"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"A5","v":"Tier 3"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Total",{"$f":"SUM(B9:B11)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IFERROR(SUM(I9:I11),0)","v":0},{"$f":"SUM(B12:I12)","v":{"$error":"#DIV/0!"}}]
[]
["Determined Generation Rates (automated)"]
[{"$f":"A2","v":"Basic Residential (E-1)"},"All Usage","Summer Peak","Summer Partial Peak","Summer Off Peak","Winter Peak","Winter Partial Peak","Winter Off Peak","NEM Bonus"]
["PGE",{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$24:$H$39,MATCH(B$15,Rates!$A$2:$J$2,0),FALSE)","v":0.11194},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$24:$H$39,MATCH(C$15,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$24:$H$39,MATCH(D$15,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$24:$H$39,MATCH(E$15,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$24:$H$39,MATCH(F$15,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$24:$H$39,MATCH(G$15,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$24:$H$39,MATCH(H$15,Rates!$A$2:$J$2,0),FALSE)","v":false}]
["SCP",{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$42:$H$57,MATCH(B$15,Rates!$A$2:$J$2,0),FALSE)","v":6.948E-2},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$42:$H$57,MATCH(C$15,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$42:$H$57,MATCH(D$15,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$42:$H$57,MATCH(E$15,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$42:$H$57,MATCH(F$15,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$42:$H$57,MATCH(G$15,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"VLOOKUP(Calculator!$D$9,Rates!$A$42:$H$57,MATCH(H$15,Rates!$A$2:$J$2,0),FALSE)","v":false},{"$f":"B70","v":0.01}]
[]
["Determined Generation Charges (automated)"]
[{"$f":"A2","v":"Basic Residential (E-1)"},"All Usage","Summer Peak","Summer Partial Peak","Summer Off Peak","Winter Peak","Winter Partial Peak","Winter Off Peak","NEM Bonus","Total"]
["PGE",{"$f":"B16*B$59","v":0},0,0,0,0,0,0,null,{"$f":"SUM(B21:H21)","v":0}]
["SCP",0,0,0,0,0,0,0,{"$f":"SUMIF(B59:H59,\"<0\")*I17","v":0},{"$f":"SUM(B22:I22)","v":0}]
[]
["Determined Delivery Charges (automated)"]
[{"$f":"A2","v":"Basic Residential (E-1)"},"All Usage","Summer Peak","Summer Partial Peak","Summer Off Peak","Winter Peak","Winter Partial Peak","Winter Off Peak","Meter Charge","Total"]
["PGE",{"$f":"B$12-B21","v":{"$error":"#DIV/0!"}},{"$f":"C$12-C21","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"I9-I21","v":0},{"$f":"SUM(B26:I26)","v":{"$error":"#DIV/0!"}}]
["SCP",{"$error":"#DIV/0!"},{"$f":"C$12-C22","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"I26","v":0},{"$error":"#DIV/0!"}]
[]
["Baseline Quantities  (annual update)"]
["Standard ","Summer","Winter",null,null,"TOUA/C","Summer","Winter"]
["TB",7,8.5,null,null,"PB",15.3,11.9]
["XB",10.1,10.9,null,null,"TB",7,8.1999999999999993]
["PB",13.8,12.3,null,null,"XB",10.5,10.6]
[null,"Summer","Winter",null,null,null,"Summer","Winter"]
["TH",8.3000000000000007,14.9,null,null,"PH",17.399999999999999,27.8]
["XH",9.3000000000000007,16.7,null,null,"TH",8.1999999999999993,14.1]
["PH",16.399999999999999,29.6,null,null,"XH",10.5,16.7]
[]
["Fees (annual update)","PCIA","FF","Total"]
[2013,3.388E-2,5.8E-4,{"$f":"SUM(B40:C40)","v":3.4459999999999998E-2}]
[2014,3.354E-2,5.8E-4,{"$f":"SUM(B41:C41)","v":3.4119999999999998E-2}]
[2015,3.338E-2,5.9000000000000003E-4,3.397E-2]
[2016,3.3450000000000001E-2,5.9000000000000003E-4,3.4040000000000001E-2]
[2017,3.3459999999999997E-2,5.8E-4,3.4039999999999994E-2]
[2018,3.3459999999999997E-2,5.8E-4,{"$f":"SUM(B45:C45)","v":3.4039999999999994E-2}]
[]
[]
["Extra Fee Calculations (automated - DO NOT TOUCH; Vintage calculation needs to be updated periodically though)"]
["Vintage:",{"$f":"Calculator!G16","v":2014}]
["Determined Fees:",{"$f":"VLOOKUP(B49,A40:D44,4)","v":3.4119999999999998E-2},"Franchise Only:",{"$f":"VLOOKUP(B49,A40:D44,3)","v":5.8E-4}]
[]
["Delivery Rates (auto updates - DO NOT TOUCH)"]
[{"$f":"A2","v":"Basic Residential (E-1)"},"All Usage","Summer Peak","Summer Partial Peak","Summer Off Peak","Winter Peak","Winter Partial Peak","Winter Off Peak","Meter Charge"]
["Tier 1",{"$f":"B3-B$16","v":0.10581},0,0,0,0,0,0,0]
["Tier 2",0.16208,0,0,0,0,0,0,0]
["High Usage",0.36815000000000003,0,0,0,0,0,0,0]
[]
["Total kWh (automated)","All Usage","S Pk","S Pt","S Off","W Pk","W Pt","W Off","Total"]
["All Usage",{"$f":"IF(B3=FALSE,0,Calculator!D6)","v":0},{"$f":"IF(C3=FALSE,0,Calculator!D10)","v":0},{"$f":"IF(D3=FALSE,0,Calculator!D11)","v":0},{"$f":"IF(E3=FALSE,0,Calculator!D12)","v":0},{"$f":"IF(F3=FALSE,0,Calculator!G10)","v":0},{"$f":"IF(G3=FALSE,0,Calculator!G11)","v":0},{"$f":"IF(H3=FALSE,0,Calculator!G12)","v":0},{"$f":"SUM(B59:H59)","v":0}]
["Pct of Total",{"$f":"B59/$I$59","v":{"$error":"#DIV/0!"}},{"$f":"C59/$I$59","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Tiering Calculations (auto updates - DO NOT TOUCH)"]
["Calculated Baseline:",{"$f":"CONCATENATE(Calculator!G15,IF(Calculator!D16=\"Gas\",\"B\",\"H\"))","v":"XB"},"Season:",{"$f":"IF(Calculator!F6=\"Nov-Apr\",\"Winter\",\"Summer\")","v":"Summer"},"Baseline Variant:",null,{"$f":"VLOOKUP(A2,Rates!A3:AC17,29,0)","v":"Standard"}]
["Baseline Quantity",{"$f":"IF(G63=\"Standard\",IF(D63=\"Summer\",VLOOKUP(B63,A30:C37,2),VLOOKUP(B63,A30:C37,3)),IF(D63=\"Summer\",VLOOKUP(B63,F30:H37,2),VLOOKUP(B63,F30:H37,3)))","v":8.3000000000000007},{"$f":"B58","v":"All Usage"},"S Pk","S Pt","S Off","W Pk","W Pt","W Off","Total Tier Allocation"]
["Tier 1",{"$f":"B64*Calculator!D15","v":257.3},{"$f":"B$60*$J65","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MIN(B65,I59)","v":0}]
["Tier 2",{"$f":"B65*3","v":771.90000000000009},{"$f":"B$60*$J66","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MIN(B66,I59-J65)","v":0}]
["High Usage Rate","all above",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"MAX(0,I59-J65-J66)","v":0}]
[]
["Misc Rates"]
["NEM Surplus",0.01]
["EverGreen",2.5000000000000001E-2]
["Minimum Bill",{"$f":"J3*Calculator!D15","v":10.18474},"(automated)"]
[]
["Totals (automated)"]
[null,"PG&E","SCP"]
["Delivery",{"$f":"MAX(B72,J26)","v":{"$error":"#DIV/0!"}},{"$f":"B76","v":{"$error":"#DIV/0!"}}]
["Generation",{"$f":"J21","v":0},{"$f":"J22","v":0}]
["PCIA/FF",0,{"$f":"B50*I59","v":0}]
["Energy Comission Tax",{"$f":"0.00029*Calculator!D6","v":0},{"$f":"0.00029*Calculator!D6","v":0}]
["Total",{"$f":"SUM(B76:B79)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C76:C79)","v":{"$error":"#DIV/0!"}}]

{"sheet":"RC PasteDataHere","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"RC Calculations","index":5,"n_rows":66,"n_cols":28,"rows_kept":66,"cut":false,"hidden":true,"merged":[]}
["Total Usage",{"$f":"SUM('RC PasteDataHere'!E:E)","v":0}]
[]
["E1 Usage Breakdown",null,null,null,null,null,null,"E6 Usage Breakdown",null,null,null,null,null,null,null,"ETOUA",null,null,null,null,"ETOUB",null,null,null,"EVA"]
[null,null,null,null,null,null,null,null,"Peak","Partial","Off",null,null,null,null,null,"Peak","Off",null,null,null,"Peak","Off",null,null,"Peak","Partial","Off"]
["January",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=1,'RC PasteDataHere'!$E$7:$E$10000,0))","v":0},null,null,null,null,null,"January",null,{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=1,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>16,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},{"$f":"B5-J5","v":0},null,null,null,null,"January",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=1,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},{"$f":"$B5-Q5","v":0},null,null,"January",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=1,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>15,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},{"$f":"$B5-V5","v":0},null,"January",{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=1,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>12,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=1,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=1,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0))))))","v":0},{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=1,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>6,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<14,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=1,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>20,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<23,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))))","v":0},{"$f":"B5-AA5-Z5","v":0}]
["February",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=2,'RC PasteDataHere'!$E$7:$E$10000,0))","v":0},null,null,null,null,null,"February",null,{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=2,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>16,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},{"$f":"B6-J6","v":0},null,null,null,null,"February",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=2,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},0,null,null,"February",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=2,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>15,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},0,null,"February",{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=2,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>12,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=2,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=2,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0))))))","v":0},{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=2,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>6,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<14,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=2,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>20,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<23,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))))","v":0},0]
["March",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=3,'RC PasteDataHere'!$E$7:$E$10000,0))","v":0},null,null,null,null,null,"March",null,{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=3,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>16,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},{"$f":"B7-J7","v":0},null,null,null,null,"March",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=3,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},0,null,null,"March",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=3,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>15,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},0,null,"March",{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=3,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>12,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=3,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=3,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0))))))","v":0},{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=3,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>6,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<14,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=3,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>20,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<23,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))))","v":0},0]
["April",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=4,'RC PasteDataHere'!$E$7:$E$10000,0))","v":0},null,null,null,null,null,"April",null,{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=4,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>16,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},{"$f":"B8-J8","v":0},null,null,null,null,"April",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=4,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},0,null,null,"April",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=4,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>15,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},0,null,"April",{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=4,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>12,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=4,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=4,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0))))))","v":0},{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=4,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>6,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<14,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=4,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>20,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<23,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))))","v":0},0]
["May",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=5,'RC PasteDataHere'!$E$7:$E$10000,0))","v":0},null,null,null,null,null,"May",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=5,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>12,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=5,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>9,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<13,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=5,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>18,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0))))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=5,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>16,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=5,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>16,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0))))))","v":0},{"$f":"B9-SUM(I9:J9)","v":0},null,null,null,null,"May",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=5,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},0,null,null,"May",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=5,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>15,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},0,null,"May",{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=5,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>12,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=5,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=5,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0))))))","v":0},{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=5,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>6,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<14,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=5,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>20,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<23,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))))","v":0},0]
["June",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=6,'RC PasteDataHere'!$E$7:$E$10000,0))","v":0},null,null,null,null,null,"June",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=6,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>12,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=6,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>9,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<13,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=6,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>18,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0))))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=6,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>16,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=6,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>16,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0))))))","v":0},0,null,null,null,null,"June",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=6,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},0,null,null,"June",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=6,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>15,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},0,null,"June",{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=6,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>12,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=6,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=6,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0))))))","v":0},{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=6,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>6,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<14,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=6,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>20,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<23,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))))","v":0},0]
["July",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=7,'RC PasteDataHere'!$E$7:$E$10000,0))","v":0},null,null,null,null,null,"July",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=7,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>12,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=7,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>9,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<13,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=7,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>18,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0))))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=7,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>16,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=7,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>16,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0))))))","v":0},0,null,null,null,null,"July",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=7,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},0,null,null,"July",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=7,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>15,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},0,null,"July",{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=7,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>12,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=7,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=7,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0))))))","v":0},{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=7,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>6,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<14,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=7,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>20,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<23,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))))","v":0},0]
["August",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=8,'RC PasteDataHere'!$E$7:$E$10000,0))","v":0},null,null,null,null,null,"August",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=8,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>12,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=8,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=8,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>9,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<13,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=8,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=8,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>18,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0))))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=8,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>16,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=8,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=8,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>16,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0))))))","v":0},0,null,null,null,null,"August",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=8,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},0,null,null,"August",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=8,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>15,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},0,null,"August",{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=8,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>12,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=8,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=8,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0))))))","v":0},{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=8,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>6,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<14,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=8,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>20,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<23,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))))","v":0},0]
["September",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=9,'RC PasteDataHere'!$E$7:$E$10000,0))","v":0},null,null,null,null,null,"September",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=9,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>12,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=9,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=9,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>9,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<13,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=9,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=9,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>18,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0))))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=9,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>16,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=9,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=9,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>16,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0))))))","v":0},0,null,null,null,null,"September",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=9,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},0,null,null,"September",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=9,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>15,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},0,null,"September",{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=9,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>12,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=9,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=9,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0))))))","v":0},{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=9,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>6,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<14,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=9,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>20,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<23,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))))","v":0},0]
["October",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=10,'RC PasteDataHere'!$E$7:$E$10000,0))","v":0},null,null,null,null,null,"October",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=10,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>12,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=10,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=10,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>9,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<13,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=10,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=10,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>18,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0))))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=10,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>16,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=10,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=10,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>16,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0))))))","v":0},0,null,null,null,null,"October",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=10,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},0,null,null,"October",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=10,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>15,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},0,null,"October",{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=10,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>12,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=10,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=10,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0))))))","v":0},{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=10,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>6,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<14,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=10,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>20,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<23,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))))","v":0},0]
["November",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=11,'RC PasteDataHere'!$E$7:$E$10000,0))","v":0},null,null,null,null,null,"November",null,{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=11,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>16,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},{"$f":"B15-J15","v":0},null,null,null,null,"November",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=11,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},0,null,null,"November",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=11,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>15,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},0,null,"November",{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=11,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>12,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=11,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=11,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0))))))","v":0},{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=11,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>6,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<14,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=11,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>20,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<23,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))))","v":0},0]
["December",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=12,'RC PasteDataHere'!$E$7:$E$10000,0))","v":0},null,null,null,null,null,"December",null,{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=12,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>16,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},{"$f":"B16-J16","v":0},null,null,null,null,"December",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=12,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<20,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},0,null,null,"December",{"$f":"SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=12,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>15,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))","v":0},0,null,"December",{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=12,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>12,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<21,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=12,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=12,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>14,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<19,'RC PasteDataHere'!$E$7:$E$10000,0),0))))))","v":0},{"$f":"SUM(SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=12,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>6,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<14,'RC PasteDataHere'!$E$7:$E$10000,0),0)))),SUM(IF(MONTH('RC PasteDataHere'!$B$7:$B$10000)=12,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=1,0,IF(WEEKDAY('RC PasteDataHere'!$B$7:$B$10000)=7,0,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)>20,IF(HOUR('RC PasteDataHere'!$C$7:$C$10000)<23,'RC PasteDataHere'!$E$7:$E$10000,0),0)))))))","v":0},0]
[null,{"$f":"SUM(B5:B16)","v":0},null,null,null,null,null,null,{"$f":"SUM(I5:I16)","v":0},{"$f":"SUM(J5:J16)","v":0},{"$f":"SUM(K5:K16)","v":0},null,null,null,null,null,{"$f":"SUM(Q5:Q16)","v":0},{"$f":"SUM(R5:R16)","v":0},null,null,null,{"$f":"SUM(V5:V16)","v":0},{"$f":"SUM(W5:W16)","v":0},null,null,{"$f":"SUM(Z5:Z16)","v":0},{"$f":"SUM(AA5:AA16)","v":0},{"$f":"SUM(AB5:AB16)","v":0}]
[]
["E1 Estimate",null,null,null,null,null,null,"E6 Estimate",null,null,null,null,null,null,null,"ETOUA Estimate",null,null,null,null,"ETOUB Estimate",null,null,null,"EVA Estimate"]
[null,"t1","t2","t3","Total",null,null,null,"t1","t2","t3","Total",null,null,null,null,"t1","t2","Total",null,null,"Total",null,null,null,"Total"]
["January",{"$f":"B55*B$36","v":0},{"$f":"C55*B$37","v":0},{"$f":"D55*B38","v":0},{"$f":"SUM(B21:D21)","v":0},null,null,"January",{"$f":"SUM($J5/SUM($I5:$K5)*B55*J$42,$K5/SUM($I5:$K5)*B55*K$42)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($J5/SUM($I5:$K5)*C55*J$43,$K5/SUM($I5:$K5)*C55*K$43)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($J5/SUM($I5:$K5)*D55*J$44,$K5/SUM($I5:$K5)*D55*K$44)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I21:K21)","v":{"$error":"#DIV/0!"}},null,null,null,"January",{"$f":"SUM(Q5/SUM(Q5:R5)*B55*Q$40,R5/SUM(Q5:R5)*B55*R$40)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(Q5/SUM(Q5:R5)*(B5-B55)*Q$41,R5/SUM(Q5:R5)*(B5-B55)*R$41)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(Q21:R21)","v":{"$error":"#DIV/0!"}},null,"January",{"$f":"SUM(V5*V$37,W5*W$37)","v":0},null,null,"January",{"$f":"SUM(Z5*Z$37,AA5*AA$37,AB5*AB$37)","v":0}]
["February",{"$f":"B56*B$36","v":0},0,{"$f":"D56*B$38","v":0},{"$f":"SUM(B22:D22)","v":0},null,null,"February",{"$f":"SUM($J6/SUM($I6:$K6)*B56*J$42,$K6/SUM($I6:$K6)*B56*K$42)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($J6/SUM($I6:$K6)*C56*J$43,$K6/SUM($I6:$K6)*C56*K$43)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($J6/SUM($I6:$K6)*D56*J$44,$K6/SUM($I6:$K6)*D56*K$44)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I22:K22)","v":{"$error":"#DIV/0!"}},null,null,null,"February",{"$f":"SUM(Q6/SUM(Q6:R6)*B56*Q$40,R6/SUM(Q6:R6)*B56*R$40)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(Q6/SUM(Q6:R6)*(B6-B56)*Q$41,R6/SUM(Q6:R6)*(B6-B56)*R$41)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,"February",{"$f":"SUM(V6*V$37,W6*W$37)","v":0},null,null,"February",{"$f":"SUM(Z6*Z$37,AA6*AA$37,AB6*AB$37)","v":0}]
["March",0,0,0,0,null,null,"March",{"$f":"SUM($J7/SUM($I7:$K7)*B57*J$42,$K7/SUM($I7:$K7)*B57*K$42)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($J7/SUM($I7:$K7)*C57*J$43,$K7/SUM($I7:$K7)*C57*K$43)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($J7/SUM($I7:$K7)*D57*J$44,$K7/SUM($I7:$K7)*D57*K$44)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,"March",{"$f":"SUM(Q7/SUM(Q7:R7)*B57*Q$40,R7/SUM(Q7:R7)*B57*R$40)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(Q7/SUM(Q7:R7)*(B7-B57)*Q$41,R7/SUM(Q7:R7)*(B7-B57)*R$41)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,"March",{"$f":"SUM(V7*V$37,W7*W$37)","v":0},null,null,"March",{"$f":"SUM(Z7*Z$37,AA7*AA$37,AB7*AB$37)","v":0}]
["April",0,0,0,0,null,null,"April",{"$f":"SUM($J8/SUM($I8:$K8)*B58*J$42,$K8/SUM($I8:$K8)*B58*K$42)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($J8/SUM($I8:$K8)*C58*J$43,$K8/SUM($I8:$K8)*C58*K$43)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($J8/SUM($I8:$K8)*D58*J$44,$K8/SUM($I8:$K8)*D58*K$44)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,"April",{"$f":"SUM(Q8/SUM(Q8:R8)*B58*Q$40,R8/SUM(Q8:R8)*B58*R$40)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(Q8/SUM(Q8:R8)*(B8-B58)*Q$41,R8/SUM(Q8:R8)*(B8-B58)*R$41)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,"April",{"$f":"SUM(V8*V$37,W8*W$37)","v":0},null,null,"April",{"$f":"SUM(Z8*Z$37,AA8*AA$37,AB8*AB$37)","v":0}]
["May",0,0,0,0,null,null,"May",{"$f":"SUM($I9/SUM($I9:$K9)*B59*I$37,$J9/SUM($I9:$K9)*B59*J$37,$K9/SUM($I9:$K9)*B59*K$37)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"May",{"$f":"SUM(Q9/SUM(Q9:R9)*B59*Q$40,R9/SUM(Q9:R9)*B59*R$40)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(Q9/SUM(Q9:R9)*(B9-B59)*Q$41,R9/SUM(Q9:R9)*(B9-B59)*R$41)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,"May",{"$f":"SUM(V9*V$36,W9*W$36)","v":0},null,null,"May",{"$f":"SUM(Z9*Z$36,AA9*AA$36,AB9*AB$36)","v":0}]
["June",0,0,0,0,null,null,"June",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"June",{"$f":"SUM(Q10/SUM(Q10:R10)*B60*Q$37,R10/SUM(Q10:R10)*B60*R$37)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(Q10/SUM(Q10:R10)*(B10-B60)*Q$38,R10/SUM(Q10:R10)*(B10-B60)*R$38)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,"June",0,null,null,"June",0]
["July",0,0,0,0,null,null,"July",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"July",{"$f":"SUM(Q11/SUM(Q11:R11)*B61*Q$37,R11/SUM(Q11:R11)*B61*R$37)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(Q11/SUM(Q11:R11)*(B11-B61)*Q$38,R11/SUM(Q11:R11)*(B11-B61)*R$38)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,"July",0,null,null,"July",0]
["August",0,0,0,0,null,null,"August",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"August",{"$f":"SUM(Q12/SUM(Q12:R12)*B62*Q$37,R12/SUM(Q12:R12)*B62*R$37)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(Q12/SUM(Q12:R12)*(B12-B62)*Q$38,R12/SUM(Q12:R12)*(B12-B62)*R$38)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,"August",0,null,null,"August",0]
["September",0,0,0,0,null,null,"September",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"September",{"$f":"SUM(Q13/SUM(Q13:R13)*B63*Q$37,R13/SUM(Q13:R13)*B63*R$37)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(Q13/SUM(Q13:R13)*(B13-B63)*Q$38,R13/SUM(Q13:R13)*(B13-B63)*R$38)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,"September",0,null,null,"September",0]
["October",0,0,0,0,null,null,"October",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"October",{"$f":"SUM(Q14/SUM(Q14:R14)*B64*Q$40,R14/SUM(Q14:R14)*B64*R$40)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(Q14/SUM(Q14:R14)*(B14-B64)*Q$41,R14/SUM(Q14:R14)*(B14-B64)*R$41)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,"October",0,null,null,"October",0]
["November",0,0,0,0,null,null,"November",{"$f":"SUM($J15/SUM($I15:$K15)*B65*J$42,$K15/SUM($I15:$K15)*B65*K$42)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($J15/SUM($I15:$K15)*C65*J$43,$K15/SUM($I15:$K15)*C65*K$43)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($J15/SUM($I15:$K15)*D65*J$44,$K15/SUM($I15:$K15)*D65*K$44)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,"November",{"$f":"SUM(Q15/SUM(Q15:R15)*B65*Q$40,R15/SUM(Q15:R15)*B65*R$40)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(Q15/SUM(Q15:R15)*(B15-B65)*Q$41,R15/SUM(Q15:R15)*(B15-B65)*R$41)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,"November",{"$f":"SUM(V15*V$37,W15*W$37)","v":0},null,null,"November",{"$f":"SUM(Z15*Z$37,AA15*AA$37,AB15*AB$37)","v":0}]
["December",0,0,0,0,null,null,"December",{"$f":"SUM($J16/SUM($I16:$K16)*B66*J$42,$K16/SUM($I16:$K16)*B66*K$42)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($J16/SUM($I16:$K16)*C66*J$43,$K16/SUM($I16:$K16)*C66*K$43)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($J16/SUM($I16:$K16)*D66*J$44,$K16/SUM($I16:$K16)*D66*K$44)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,"December",{"$f":"SUM(Q16/SUM(Q16:R16)*B66*Q$40,R16/SUM(Q16:R16)*B66*R$40)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(Q16/SUM(Q16:R16)*(B16-B66)*Q$41,R16/SUM(Q16:R16)*(B16-B66)*R$41)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,"December",{"$f":"SUM(V16*V$37,W16*W$37)","v":0},null,null,"December",{"$f":"SUM(Z16*Z$37,AA16*AA$37,AB16*AB$37)","v":0}]
[null,null,null,null,{"$f":"SUM(E21:E32)","v":0},null,null,null,null,null,null,{"$f":"SUM(L21:L32)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"SUM(S21:S32)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(V21:V32)","v":0},null,null,null,{"$f":"SUM(Z21:Z32)","v":0}]
[null,null,null,"NEM Bonus",{"$f":"SUMIF(B5:B16,\"<0\")","v":0},null,null,null,null,null,"NEM Bonus",{"$f":"SUMIF(I5:K16,\"<0\")*E51","v":0},null,null,null,null,null,"NEM Bonus",{"$f":"SUMIF(Q5:R16,\"<0\")*E51","v":0},null,"NEM Bonus",{"$f":"SUMIF(V5:W16,\"<0\")*E51","v":0},null,null,"NEM Bonus",{"$f":"SUMIF(Z5:AB16,\"<0\")*E51","v":0}]
["E1 Rates",null,null,null,null,null,null,"E6 Rates","Peak","Partial","Off",null,null,null,null,"ETOUA Rates","Peak","Off",null,null,"ETOUB Rates","Peak","Off",null,"EVA Rate","Peak","Partial","Off"]
["Tier 1",{"$f":"Rates!B3-Rates!B24+Rates!B42+E48","v":0.20932999999999999},null,null,null,null,null,"Summer",null,null,null,null,null,null,null,"Summer",null,null,null,null,"Summer",{"$f":"'Rebundled Rates'!B22","v":0.36361000000000004},{"$f":"'Rebundled Rates'!B23","v":0.26261000000000001},null,"Summer",{"$f":"'Rebundled Rates'!B28","v":0.46988999999999997},{"$f":"'Rebundled Rates'!B29","v":0.25520999999999999},{"$f":"'Rebundled Rates'!B30","v":0.1207}]
["Tier 2",{"$f":"Rates!L3-Rates!B24+Rates!B42+E48","v":0.2656},null,null,null,null,null,"Tier 1",{"$f":"Rates!C15-Rates!C36+Rates!C54+$E$48","v":0.36069000000000001},{"$f":"Rates!D15-Rates!D36+Rates!D54+$E$48","v":0.25205},{"$f":"Rates!E15-Rates!E36+Rates!E54+$E$48","v":0.17858999999999997},null,null,null,null,"Tier 1",{"$f":"Q38+Rates!D19","v":0.30684000000000011},{"$f":"R38+Rates!D19","v":0.23277999999999996},null,null,"Winter",{"$f":"'Rebundled Rates'!B24","v":0.22888},{"$f":"'Rebundled Rates'!B25","v":0.21045},null,"Winter",{"$f":"'Rebundled Rates'!B31","v":0.33001000000000003},{"$f":"'Rebundled Rates'!B32","v":0.20666999999999999},{"$f":"'Rebundled Rates'!B33","v":0.11787}]
["Tier 3",{"$f":"Rates!U3-Rates!B24+Rates!B42+E48","v":0.47167000000000003},"(High Usage)",null,null,null,null,"Tier 2",{"$f":"Rates!M15-Rates!C36+Rates!C54+$E$48","v":0.44069999999999998},{"$f":"Rates!N15-Rates!D36+Rates!D54+$E$48","v":0.33206000000000002},{"$f":"Rates!O15-Rates!E36+Rates!E54+$E$48","v":0.2586},null,null,null,null,"Tier 2",{"$f":"Rates!M5-Rates!C26+Rates!C44+E48","v":0.38685000000000008},{"$f":"Rates!O5-Rates!E26+Rates!E44+E48","v":0.31278999999999996}]
[null,null,null,null,null,null,null,"Tier 3",{"$f":"I38","v":0.44069999999999998},{"$f":"J38","v":0.33206000000000002},0.2586,null,null,null,null,"Winter"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tier 1",{"$f":"Q41+Rates!D19","v":0.19122999999999998},{"$f":"R41+Rates!D19","v":0.17723000000000003}]
["Customer Baseline",null,{"$f":"'RC Results'!B5","v":"XB"},null,null,null,null,"Winter",null,null,null,null,null,null,null,"Tier 2",{"$f":"Rates!P5-Rates!F26+Rates!F44+E48","v":0.27123999999999998},{"$f":"Rates!R5-Rates!H26+Rates!H44+E48","v":0.25724000000000002}]
[null,"Summer Alloc","Winter Alloc",null,null,null,null,"Tier 1",null,{"$f":"Rates!G15-Rates!G36+Rates!G54+$E$48","v":0.19833999999999999},{"$f":"Rates!H15-Rates!H36+Rates!H54+$E$48","v":0.18232999999999999}]
["Tier 1",{"$f":"VLOOKUP(C41,A48:C52,2,0)*31","v":313.09999999999997},{"$f":"VLOOKUP(C41,A48:C52,3,0)*31","v":337.90000000000003},null,null,null,null,"Tier 2",null,{"$f":"Rates!Q15-Rates!G36+Rates!G54+$E$48","v":0.27834999999999999},{"$f":"Rates!R15-Rates!H36+Rates!H54+$E$48","v":0.26233999999999996}]
["Tier 2",{"$f":"B43*3","v":939.3},{"$f":"C43*3","v":1013.7},null,null,null,null,"Tier 3",null,{"$f":"J43","v":0.27834999999999999},{"$f":"K43","v":0.26233999999999996}]
["Tier 3"]
[]
["Baselines",null,null,null,"PCIA/FF"]
[null,"Summer","Winter",null,{"$f":"'Data & Calculations'!D44","v":3.4039999999999994E-2}]
["TB",{"$f":"'Data & Calculations'!B31","v":7},{"$f":"'Data & Calculations'!C31","v":8.5}]
["XB",{"$f":"'Data & Calculations'!B32","v":10.1},{"$f":"'Data & Calculations'!C32","v":10.9},null,"Nem Credit Rate"]
["TH",{"$f":"'Data & Calculations'!G32","v":7},{"$f":"'Data & Calculations'!H32","v":8.1999999999999993},null,0.01]
["XH",{"$f":"'Data & Calculations'!G33","v":10.5},{"$f":"'Data & Calculations'!H33","v":10.6}]
[]
["Usage Tiers","T1","T2","T3"]
["January",{"$f":"IF(MIN(B5,C$43)>=0,MIN(B5,C$43),MAX(B5,-C$43))","v":0},{"$f":"IF(MIN(B5-B55,C$44)>=0,MIN(B5-B55,C$44),MAX(B5-B55,-C$44))","v":0},{"$f":"IF(B5-C55-B55>0,MAX(0,B5-C55-B55),MIN(0,B5-C55-B55))","v":0}]
["February",{"$f":"IF(MIN(B6,C$43)>=0,MIN(B6,C$43),MAX(B6,-C$43))","v":0},{"$f":"IF(MIN(B6-B56,C$44)>=0,MIN(B6-B56,C$44),MAX(B6-B56,-C$44))","v":0},{"$f":"IF(B6-C56-B56>=0,MAX(0,B6-C56-B56),MIN(0,B6-C56-B56))","v":0}]
["March",{"$f":"IF(MIN(B7,C$43)>=0,MIN(B7,C$43),MAX(B7,-C$43))","v":0},{"$f":"IF(MIN(B7-B57,C$44)>=0,MIN(B7-B57,C$44),MAX(B7-B57,-C$44))","v":0},0]
["April",{"$f":"IF(MIN(B8,C$43)>=0,MIN(B8,C$43),MAX(B8,-C$43))","v":0},{"$f":"IF(MIN(B8-B58,C$44)>=0,MIN(B8-B58,C$44),MAX(B8-B58,-C$44))","v":0},0]
["May",{"$f":"IF(MIN(B9,B$43)>=0,MIN(B9,B$43),MAX(B9,-B$43))","v":0},{"$f":"IF(MIN(B9-B59,B$44)>=0,MIN(B9-B59,B$44),MAX(B9-B59,-B$44))","v":0},0]
["June",0,0,0]
["July",0,0,0]
["August",0,0,0]
["September",0,0,0]
["October",0,0,0]
["November",{"$f":"IF(MIN(B15,C$43)>=0,MIN(B15,C$43),MAX(B15,-C$43))","v":0},{"$f":"IF(MIN(B15-B65,C$44)>=0,MIN(B15-B65,C$44),MAX(B15-B65,-C$44))","v":0},0]
["December",{"$f":"IF(MIN(B16,C$43)>=0,MIN(B16,C$43),MAX(B16,-C$43))","v":0},{"$f":"IF(MIN(B16-B66,C$44)>=0,MIN(B16-B66,C$44),MAX(B16-B66,-C$44))","v":0},0]

{"sheet":"RC Results","index":6,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[{"$f":"'RC PasteDataHere'!A1","v":0},{"$f":"'RC PasteDataHere'!B1","v":0},null,"Instructions:",null,"Download Green Button data from PG&E for a 12 month period."]
[{"$f":"'RC PasteDataHere'!A2","v":0},{"$f":"'RC PasteDataHere'!B2","v":0},null,null,null,"Paste into the appropriate tab below."]
[{"$f":"'RC PasteDataHere'!A3","v":0},{"$f":"'RC PasteDataHere'!B3","v":0},null,null,null,"Select the customer's baseline (geography and heating source) in cell B5."]
[{"$f":"'RC PasteDataHere'!A4","v":0},{"$f":"'RC PasteDataHere'!B4","v":0},null,null,null,"Review results."]
["Customer Baseline","XB"]
[null,null,null,"Disclaimers:",null,"These estimates assume a billing period from the first to the last of each calendar month."]
[null,null,null,null,null,"Actual bill cycles may slightly change these results due to tiering."]
[null,null,null,null,null,"Holidays are not identified by this calculator, so their usage is not exempted and treated as off peak."]
[]
[]
["Rate Option","E1","E6","E-TOU-A","E-TOU-B","EV"]
["Description","Non-TOU, basic rate","TOU rate","New TOU, tiered","New TOU, untiered","TOU, EV owners only"]
["Available?","Yes","No","Yes","Yes","Yes"]
["Est. Annual Cost",{"$f":"'RC Calculations'!E33+'RC Calculations'!E34","v":0},{"$f":"'RC Calculations'!L33+'RC Calculations'!L34","v":{"$error":"#DIV/0!"}},{"$f":"'RC Calculations'!S33+'RC Calculations'!S34","v":{"$error":"#DIV/0!"}},{"$f":"'RC Calculations'!V33+'RC Calculations'!V34","v":0},{"$f":"'RC Calculations'!Z33+'RC Calculations'!Z34","v":0}]

{"sheet":"Changelog","index":7,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Date","Change"]
["2016-04-29","Beta version completed, to staff for review."]
["2016-05-04","Cosmetic Changes"]
[null,"Corrected EV rate description"]
[null,"Hid and locked cell editing for public use to restrict potentially breaking calculations"]
["2016-05-23","Replaced IFNA command with IFERROR; IFNA is not well supported in Excel. May need to replace with IF(ISERROR()) later."]
["2016-11-15","Rebundled Rates Added"]
["2017-01-03","Updated for PG&E AET"]
["2017-03-01","Changes for PG&E 3/1 change (tiers, etc)"]
[null,"Updated Local Sol implementation date"]
[null,"Added MCE 4/1 Rates"]
["2017-03-22","Added Local Sol Rates"]
[null,"Fixed EV/E6 rate transposition"]
["2017-03-24","Removed Local Sol outputs (was confusing for customers)"]
["2017-04-18","Updated Emissions Factors for 2015"]