{"text_format":"1","workbook":"xlsx","n_sheets":29,"sheets":["Cover","Credits-Deficits -->","Cred-Def Summary","Credits Generated","Fuel Energy Consumption","CI Targets and Inputs ","Availability + Consumption -->","Summary Table ","Gasoline + Alts Forecast","Petroleum Availability","Ethanol Availability","Diesel + Alts Cons Forecast","Biodiesel Availability","Renewable Diesel Availability","Electricity Cons Forecast","Electricity Availability","Natural Gas + RNG Forecast","Natural Gas Availability","Renew Natural Gas Availability","Propane Consumption Forecast","Propane Availability","Data Sources-->","Gas & Diesel Forecast Data","Vehicle Stock Forecast","CNG Vehicle Registrations","Washington EV Data","Propane EIA Data","Sheet1","Conversions"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":27,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,"Draft Clean Fuel Supply Forecast"]
[null,null,null,"BRG Work Product for the Washington State Department of Commerce"]
[null,null,null,"2022-09-23"]

{"sheet":"Credits-Deficits -->","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Cred-Def Summary","index":2,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Credits/Deficits/Bank Balance Summary Table"]
[]
[null,"Year","Fueling Related Credit Generation","Fueling Related Deficit Generation","Non-Fueling Capacity and Infrastructure Credits","Net Credit Generation","Bank Beginning Balance","Bank Ending Balance"]
[null,2023,{"$f":"SUMIF('Credits Generated'!$C6:$K6,\">0\")","v":1017225.3787015554},{"$f":"SUMIF('Credits Generated'!$C6:$K6,\"<0\")","v":-754573.79610776238},{"$f":"-D5*(1/20)","v":37728.689805388123},{"$f":"SUM(C5:E5)","v":300380.27239918115},0,{"$f":"G5+F5","v":300380.27239918115}]
[null,2024,{"$f":"SUMIF('Credits Generated'!$C7:$K7,\">0\")","v":1157563.6207770281},{"$f":"SUMIF('Credits Generated'!$C7:$K7,\"<0\")","v":-961036.46369768225},{"$f":"-D6*(1/20)","v":48051.823184884117},{"$f":"SUM(C6:E6)","v":244578.98026423002},{"$f":"H5","v":300380.27239918115},{"$f":"G6+F6","v":544959.2526634112}]

{"sheet":"Credits Generated","index":3,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Credits Generation"]
[]
[null,"Credits Generated by Fuel Type"]
[null,"Year","Gasoline","Ethanol","Electricity","Diesel","Biodiesel","Renewable Diesel","Natural Gas","RNG","Propane","Total"]
[null,2023,{"$f":"(C11*'Fuel Energy Consumption'!C5)/(10^6)","v":-604112.26525800163},{"$f":"(D11*'Fuel Energy Consumption'!D5)/(10^6)","v":544750.40537774994},{"$f":"(E11*'Fuel Energy Consumption'!G5)/(10^6)","v":61011.088150684547},{"$f":"(F11*'Fuel Energy Consumption'!H5)/(10^6)","v":-150461.53084976072},{"$f":"(G11*'Fuel Energy Consumption'!I5)/(10^6)","v":223161.41749247999},{"$f":"(H11*'Fuel Energy Consumption'!J5)/(10^6)","v":184168.21395},{"$f":"(I11*'Fuel Energy Consumption'!K5)/(10^6)","v":59.293918359581127},{"$f":"(J11*'Fuel Energy Consumption'!L5)/(10^6)","v":359.53381228138255},{"$f":"(K11*'Fuel Energy Consumption'!M5)/(10^6)","v":3715.4259999999945},{"$f":"SUM(C6:K6)","v":262651.58259379311}]
[null,2024,{"$f":"(C12*'Fuel Energy Consumption'!C6)/(10^6)","v":-766319.33608400158},{"$f":"(D12*'Fuel Energy Consumption'!D6)/(10^6)","v":542390.31796949985},{"$f":"(E12*'Fuel Energy Consumption'!G6)/(10^6)","v":76059.958133169464},{"$f":"(F12*'Fuel Energy Consumption'!H6)/(10^6)","v":-194717.1276136807},{"$f":"(G12*'Fuel Energy Consumption'!I6)/(10^6)","v":264585.24108989001},{"$f":"(H12*'Fuel Energy Consumption'!J6)/(10^6)","v":270401.89060500002},{"$f":"(I12*'Fuel Energy Consumption'!K6)/(10^6)","v":34.256091732991372},{"$f":"(J12*'Fuel Energy Consumption'!L6)/(10^6)","v":393.19610995805249},{"$f":"(K12*'Fuel Energy Consumption'!M6)/(10^6)","v":3698.7607777777716},{"$f":"SUM(C7:K7)","v":196527.1570793459}]
[]
[null,"Fuel Substitute CI Differentials"]
[null,"Year","Gasoline","Ethanol","Electricity","Diesel","Biodiesel","Renewable Diesel","Natural Gas","RNG","Propane"]
[null,2023,{"$f":"'CI Targets and Inputs '!C7-'CI Targets and Inputs '!$C$13","v":-2.0100000000000051},{"$f":"'CI Targets and Inputs '!C7-'CI Targets and Inputs '!$C$14","v":25.209999999999994},{"$f":"'CI Targets and Inputs '!C7-'CI Targets and Inputs '!$C$21","v":79.680588235294124},{"$f":"'CI Targets and Inputs '!D7-'CI Targets and Inputs '!$C$15","v":-1.5700000000000074},{"$f":"'CI Targets and Inputs '!D7-'CI Targets and Inputs '!$C$16","v":44.19},{"$f":"'CI Targets and Inputs '!D7-'CI Targets and Inputs '!$C$17","v":48.44},{"$f":"'CI Targets and Inputs '!D7-'CI Targets and Inputs '!$C$18","v":21.539999999999992},{"$f":"'CI Targets and Inputs '!D7-'CI Targets and Inputs '!$C$19","v":35},{"$f":"'CI Targets and Inputs '!D7-'CI Targets and Inputs '!$C$20","v":16.379999999999995}]
[null,2024,{"$f":"'CI Targets and Inputs '!C8-'CI Targets and Inputs '!$C$13","v":-2.5100000000000051},{"$f":"'CI Targets and Inputs '!C8-'CI Targets and Inputs '!$C$14","v":24.709999999999994},{"$f":"'CI Targets and Inputs '!C8-'CI Targets and Inputs '!$C$21","v":79.180588235294124},{"$f":"'CI Targets and Inputs '!D8-'CI Targets and Inputs '!$C$15","v":-2.0700000000000074},{"$f":"'CI Targets and Inputs '!D8-'CI Targets and Inputs '!$C$16","v":43.69},{"$f":"'CI Targets and Inputs '!D8-'CI Targets and Inputs '!$C$17","v":47.94},{"$f":"'CI Targets and Inputs '!D8-'CI Targets and Inputs '!$C$18","v":21.039999999999992},{"$f":"'CI Targets and Inputs '!D8-'CI Targets and Inputs '!$C$19","v":34.5},{"$f":"'CI Targets and Inputs '!D8-'CI Targets and Inputs '!$C$20","v":15.879999999999995}]

{"sheet":"Fuel Energy Consumption","index":4,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Energy Consumption per Fuel (MJ)"]
[]
[null,"Year","Gasoline","Ethanol","Electricity (BEV)","Electricity (PHEV)","Total Electricity","Diesel","Biodiesel","Renewable Diesel","Natural Gas","Renewable Natural Gas (Landfill)","Propane"]
[null,2023,{"$f":"(('Summary Table '!H$5*(10^6))*E10)","v":300553365800},{"$f":"(('Summary Table '!H6*(10^6))*$E$11)","v":21608504775.000004},{"$f":"('Summary Table '!H15*(10^6)*E18)","v":666819718.84799993},{"$f":"('Summary Table '!H16*(10^6)*E18)","v":98876035.938860282},{"$f":"SUM(Table812[[#This Row],[Electricity (BEV)]:[Electricity (PHEV)]])","v":765695754.78686023},{"$f":"('Summary Table '!H9*(10^6))*$E$12","v":95835369968},{"$f":"(('Summary Table '!H$10*(10^6))*E13)","v":5050043392},{"$f":"(('Summary Table '!H12*(10^6))*'Fuel Energy Consumption'!$E$14)","v":3801986250},{"$f":"('Summary Table '!H18*(10^6))*'Fuel Energy Consumption'!$E$12","v":2752735.2998877042},{"$f":"('Summary Table '!H19*(10^6))*'Fuel Energy Consumption'!$E$12","v":10272394.636610931},{"$f":"('Summary Table '!H22*(10^6)*'Fuel Energy Consumption'!$E$17)","v":226826984.12698385}]
[null,2024,{"$f":"(('Summary Table '!I$5*(10^6))*$E$10)","v":305306508400},{"$f":"(('Summary Table '!I6*(10^6))*$E$11)","v":21950235450},{"$f":"('Summary Table '!I15*(10^6)*E18)","v":848430980.78400004},{"$f":"('Summary Table '!I16*(10^6)*E18)","v":112157464.29231907},{"$f":"SUM(Table812[[#This Row],[Electricity (BEV)]:[Electricity (PHEV)]])","v":960588445.0763191},{"$f":"('Summary Table '!I9*(10^6))*$E$12","v":94066245224},{"$f":"(('Summary Table '!I$10*(10^6)*E13))","v":6055967981},{"$f":"(('Summary Table '!I12*(10^6))*'Fuel Energy Consumption'!$E$14)","v":5640423250},{"$f":"('Summary Table '!I18*(10^6))*'Fuel Energy Consumption'!$E$12","v":1628141.2420623284},{"$f":"('Summary Table '!I19*(10^6))*'Fuel Energy Consumption'!$E$12","v":11396988.694436304},{"$f":"('Summary Table '!I22*(10^6)*'Fuel Energy Consumption'!$E$17)","v":232919444.44444412}]
[]
[null,null,"Energy Densities"]
[null,null,"Fuel","Units >>","Energy Density"]
[null,null,"Gasoline","MJ/Gallon",122.48]
[null,null,"Ethanol","MJ/Gallon",81.510000000000005]
[null,null,"Diesel","MJ/Gallon",134.47999999999999]
[null,null,"Biodiesel (Soybean)","MJ/Gallon",126.13]
[null,null,"Renewable Diesel (Soybean)","MJ/Gallon",129.65]
[null,null,"Natural Gas","MJ/DGE",{"$f":"E12","v":134.47999999999999}]
[null,null,"Renewable Natural Gas (Landfill)","MJ/DGE",{"$f":"E12","v":134.47999999999999}]
[null,null,"Propane","MJ/Gallon",89.63]
[null,null,"Electricity","MJ/kWh",3.6]
[]
[null,"Sources and Notes:"]
[null,"Conversions: Washington Clean Fuels Progam Rule Part 9 Tables, https://app.leg.wa.gov/RCW/default.aspx?cite=70A.535.025"]

{"sheet":"CI Targets and Inputs ","index":5,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"CI Targets, Factor Inputs, and Conversions"]
[]
[null,"CI Targets"]
[null,"Year","Gasoline","Diesel"]
[null,null,"[1]","[2]"]
[null,2023,98.36,99.52]
[null,2024,97.86,99.02]
[]
[null,"CI Factor Inputs"]
[null,"Fuel","CI Input for Credit Calculations"]
[null,null,"[3]"]
[null,"Gasoline",100.37]
[null,"Ethanol",73.150000000000006]
[null,"Diesel",101.09]
[null,"Biodiesel",55.33]
[null,"Renewable Diesel",51.08]
[null,"Natural Gas",77.98]
[null,"Renewable Natural Gas",64.52]
[null,"Propane",83.14]
[null,"Electricity (Post-EER Adjustment)",{"$f":"63.51/D23","v":18.679411764705883}]
[]
[null,"Washington EER Adjustment","[4]",3.4]
[]
[null,"Sources and Notes:"]
[null,"[1]-[4]: Washington Clean Fuels Progam Rule Part 9 Tables, https://app.leg.wa.gov/RCW/default.aspx?cite=70A.535.025; Ethanol, Biodiesel, Renewable Diesel, and Renewable Natural Gas are sourced from the Washington-GREET model, from Department of Ecology, as created by Life Cycle Associates on July 15, 2022."]

{"sheet":"Availability + Consumption -->","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Summary Table ","index":7,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Summary Table of Fuel Consumption Forecasts"]
[]
[null,null,"Fuel Type","Unit","Citation Reference","2021","2022","2023","2024","CAGR % vs 2021"]
[null,null,"Fossil Gasoline","MM Gallons","[1]",{"$f":"'Gas & Diesel Forecast Data'!K$6-F$6","v":2250.835},{"$f":"'Gas & Diesel Forecast Data'!L$6-G$6","v":2399.7474999999999},{"$f":"'Gas & Diesel Forecast Data'!M$6-H$6","v":2453.8975},{"$f":"'Gas & Diesel Forecast Data'!N$6-I$6","v":2492.7049999999999},{"$f":"((Table2[[#This Row],[2024]]/Table2[[#This Row],[2021]])^(1/(Table2[[#Headers],[2024]]-Table2[[#Headers],[2021]])))-1","v":3.4607784348449799E-2}]
[null,null,"Ethanol","MM Gallons","[2]",{"$f":"'Gas & Diesel Forecast Data'!K$6*'Summary Table '!F$7","v":243.16500000000002},{"$f":"'Gas & Diesel Forecast Data'!L$6*'Summary Table '!G$7","v":259.2525},{"$f":"'Gas & Diesel Forecast Data'!M$6*'Summary Table '!H$7","v":265.10250000000002},{"$f":"'Gas & Diesel Forecast Data'!N$6*'Summary Table '!I$7","v":269.29500000000002},{"$f":"((Table2[[#This Row],[2024]]/Table2[[#This Row],[2021]])^(1/(Table2[[#Headers],[2024]]-Table2[[#Headers],[2021]])))-1","v":3.4607784348449799E-2}]
[null,null,"Ethanol Blend Rate","%","[3]",9.7500000000000003E-2,9.7500000000000003E-2,9.7500000000000003E-2,9.7500000000000003E-2]
[null,null,"Total Gasoline","MM Gallons","[4]",{"$f":"SUM(F5:F6)","v":2494},{"$f":"SUM(G5:G6)","v":2659},{"$f":"SUM(H5:H6)","v":2719},2762,{"$f":"((Table2[[#This Row],[2024]]/Table2[[#This Row],[2021]])^(1/(Table2[[#Headers],[2024]]-Table2[[#Headers],[2021]])))-1","v":3.4607784348449799E-2}]
[null,null,"Fossil Diesel","MM Gallons","[5]",{"$f":"'Gas & Diesel Forecast Data'!K$10-SUM(F$10,F$12)","v":707.85},{"$f":"'Gas & Diesel Forecast Data'!L$10-SUM(G$10,G$12)","v":757.57500000000005},{"$f":"'Gas & Diesel Forecast Data'!M$10-SUM(H$10,H$12)","v":712.63660000000004},{"$f":"'Gas & Diesel Forecast Data'!N$10-SUM(I$10,I$12)","v":699.48130000000003},{"$f":"((Table2[[#This Row],[2024]]/Table2[[#This Row],[2021]])^(1/(Table2[[#Headers],[2024]]-Table2[[#Headers],[2021]])))-1","v":-3.9565343687902876E-3}]
[null,null,"Biodiesel","MM Gallons","[6]",{"$f":"'Gas & Diesel Forecast Data'!K$10*'Summary Table '!F$11","v":18.150000000000002},{"$f":"'Gas & Diesel Forecast Data'!L$10*'Summary Table '!G$11","v":19.425000000000001},{"$f":"'Gas & Diesel Forecast Data'!M$10*'Summary Table '!H$11","v":40.038400000000003},{"$f":"'Gas & Diesel Forecast Data'!N$10*'Summary Table '!I$11","v":48.0137},{"$f":"((Table2[[#This Row],[2024]]/Table2[[#This Row],[2021]])^(1/(Table2[[#Headers],[2024]]-Table2[[#Headers],[2021]])))-1","v":0.38302335818777733}]
[null,null,"Biodiesel Blend Rate","%","[7]",2.5000000000000001E-2,2.5000000000000001E-2,5.1200000000000002E-2,6.0700000000000004E-2]
[null,null,"Renewable Diesel","MM Gallons","[8]",{"$f":"'Gas & Diesel Forecast Data'!K$10*'Summary Table '!F$13","v":0},{"$f":"'Gas & Diesel Forecast Data'!L$10*'Summary Table '!G$13","v":0},{"$f":"'Gas & Diesel Forecast Data'!M$10*'Summary Table '!H$13","v":29.324999999999999},{"$f":"'Gas & Diesel Forecast Data'!N$10*'Summary Table '!I$13","v":43.505000000000003}]
[null,null,"Renewable Diesel Blend Rate","%","[9]",0,0,3.7499999999999999E-2,5.5E-2]
[null,null,"Total Diesel","MM Gallons","[10]",{"$f":"SUM(F9:F10,F12)","v":726},{"$f":"SUM(G9:G10,G12)","v":777},782.00000000000011,{"$f":"SUM(I9:I10,I12)","v":791},{"$f":"((Table2[[#This Row],[2024]]/Table2[[#This Row],[2021]])^(1/(Table2[[#Headers],[2024]]-Table2[[#Headers],[2021]])))-1","v":2.8995054770665218E-2}]
[null,null,"Electricity (BEVs)","GWh","[11]",{"$f":"('Vehicle Stock Forecast'!K$39*'Washington EV Data'!$F$7)/1000000","v":109.63538},{"$f":"('Vehicle Stock Forecast'!L$39*'Washington EV Data'!$F$7)/1000000","v":138.88252985999998},{"$f":"('Vehicle Stock Forecast'!M$39*'Washington EV Data'!$F$7)/1000000","v":185.22769967999997},{"$f":"('Vehicle Stock Forecast'!N$39*'Washington EV Data'!$F$7)/1000000","v":235.67527243999999},{"$f":"((Table2[[#This Row],[2024]]/Table2[[#This Row],[2021]])^(1/(Table2[[#Headers],[2024]]-Table2[[#Headers],[2021]])))-1","v":0.29058841953282166}]
[null,null,"Electricity (PHEVs)","GWh","[12]",{"$f":"('Vehicle Stock Forecast'!K$40*'Washington EV Data'!$F$15)/1000000","v":21.202791113439968},{"$f":"('Vehicle Stock Forecast'!L$40*'Washington EV Data'!$F$15)/1000000","v":23.651713487042286},{"$f":"('Vehicle Stock Forecast'!M$40*'Washington EV Data'!$F$15)/1000000","v":27.465565538572299},{"$f":"('Vehicle Stock Forecast'!N$40*'Washington EV Data'!$F$15)/1000000","v":31.154851192310854},{"$f":"((Table2[[#This Row],[2024]]/Table2[[#This Row],[2021]])^(1/(Table2[[#Headers],[2024]]-Table2[[#Headers],[2021]])))-1","v":0.13687019839638848}]
[null,null,"Electricity","GWh","[13]",{"$f":"SUM(F15:F16)","v":130.83817111343996},{"$f":"SUM(G15:G16)","v":162.53424334704226},212.69326521857226,266.83012363231086,{"$f":"((Table2[[#This Row],[2024]]/Table2[[#This Row],[2021]])^(1/(Table2[[#Headers],[2024]]-Table2[[#Headers],[2021]])))-1","v":0.26813882073888862}]
[null,null,"Natural Gas","MM Diesel Gallons Equivalent","[14]",{"$f":"F21-F19","v":9.6855517076878603E-2},{"$f":"G21-G19","v":9.6855517076878603E-2},{"$f":"H21-H19","v":2.0469477244852055E-2},{"$f":"I21-I19","v":1.210693963460982E-2},{"$f":"((Table2[[#This Row],[2024]]/Table2[[#This Row],[2021]])^(1/(Table2[[#Headers],[2024]]-Table2[[#Headers],[2021]])))-1","v":-0.5}]
[null,null,"Renewable Natural Gas","MM Diesel Gallons Equivalent","[15]",{"$f":"F21*F20","v":0},{"$f":"G21*G20","v":0},{"$f":"H21*H20","v":7.6386039832026548E-2},{"$f":"I21*I20","v":8.4748577442268783E-2}]
[null,null,"Renewable Natural Gas Blend Rate","%","[16]",0,0,0.78865966686642641,0.875]
[null,null,"Total Natural Gas","MM Diesel Gallons Equivalent","[17]",{"$f":"((('CNG Vehicle Registrations'!$F$7*'CNG Vehicle Registrations'!$F$8)*'Fuel Energy Consumption'!$E$10)/'Fuel Energy Consumption'!$E$15)/(10^6)","v":9.6855517076878603E-2},{"$f":"((('CNG Vehicle Registrations'!$F$7*'CNG Vehicle Registrations'!$F$8)*'Fuel Energy Consumption'!$E$10)/'Fuel Energy Consumption'!$E$15)/(10^6)","v":9.6855517076878603E-2},{"$f":"((('CNG Vehicle Registrations'!$F$7*'CNG Vehicle Registrations'!$F$8)*'Fuel Energy Consumption'!$E$10)/'Fuel Energy Consumption'!$E$15)/(10^6)","v":9.6855517076878603E-2},{"$f":"((('CNG Vehicle Registrations'!$F$7*'CNG Vehicle Registrations'!$F$8)*'Fuel Energy Consumption'!$E$10)/'Fuel Energy Consumption'!$E$15)/(10^6)","v":9.6855517076878603E-2},{"$f":"((Table2[[#This Row],[2024]]/Table2[[#This Row],[2021]])^(1/(Table2[[#Headers],[2024]]-Table2[[#Headers],[2021]])))-1","v":0}]
[null,null,"Propane","MM Gallons","[18]",{"$f":"'Propane EIA Data'!F$5*'Propane EIA Data'!$F$9","v":2.0130598633889916},{"$f":"'Propane EIA Data'!G$5*'Propane EIA Data'!$F$9","v":2.3442125681889121},{"$f":"'Propane EIA Data'!H$5*'Propane EIA Data'!$F$9","v":2.5307038282604468},{"$f":"'Propane EIA Data'!I$5*'Propane EIA Data'!$F$9","v":2.5986772781930618},{"$f":"((Table2[[#This Row],[2024]]/Table2[[#This Row],[2021]])^(1/(Table2[[#Headers],[2024]]-Table2[[#Headers],[2021]])))-1","v":8.884289039832427E-2}]
[]
[]
[null,null,"Sources and Notes:"]
[null,null,"[1]: 'Gas & Diesel Forecast Data' less ethanol blend volume"]
[null,null,"[2]: 'Gas & Diesel Forecast Data' multiplied by Ethanol Blend Rate."]
[null,null,"[3]: BRG analysis based on historical experience in Oregon and California and other market trends"]
[null,null,"[5]: 'Gas & Diesel Forecast Data' less Biodiesel and Renewable Diesel blend volumes."]
[null,null,"[6]: 'Gas & Diesel Forecast Data' multiplied by Biodiesel Blend Rate."]
[null,null,"[7]: BRG analysis based on historical experience in Oregon and California and other market trends."]
[null,null,"[8]: 'Gas & Diesel Forecast Data' multiplied by Renewable Diesel Blend Rate."]
[null,null,"[9]: BRG analysis based on historical experience in Oregon and California and other market trends."]
[null,null,"[11]: 'Vehicle Stock Forecast' for BEVs times the average annual electricity consumption for BEVs in Washington."]
[null,null,"[12]: 'Vehicle Stock Forecast' for PHEVs times the average annual electricity consumption for PHEVs in Washington. 10% of PHEV vehicle miles traveled is assumed to be gasoline powered."]
[null,null,"[14]: Natural gas consumption less volume of Renewable Natural Gas consumption."]
[null,null,"[15]: Total Natural Gas consumption multiplied by the renewable natural gas blend rate."]
[null,null,"[16]: Renewable natural gas produced in Washington is typically exported to California or Oregon to take advantage of multiple incentive structures. With the implementation of a CFS the blendrate of RNG is assumed to the same rates projected in Oregon."]
[null,null,"[17]: 'CNG Vehicles Registrations' times average annual CNG consumption per vehicle. Converted into MM Diesel Gallons Equivalent."]
[null,null,"[18]: Using Washington's historical consumption BRG has allocated the projected propane consumption using the U.S. EIA AEO Pacific Consumption Forecast. Due to an identified data limitation BRG relied upon the average allocation to Washington from 2014 through 2019."]

{"sheet":"Gasoline + Alts Forecast","index":8,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Gasoline and Gasoline Alternatives Consumption Forecast"]
[]
[null,"Fuel Type","Unit","Citation Reference","2021","2022","2023","2024"]
[null,"Fossil Gasoline","MM Gallons","[1]",{"$f":"'Gas & Diesel Forecast Data'!K$6-E6","v":2250.835},{"$f":"'Gas & Diesel Forecast Data'!L$6-F6","v":2399.7474999999999},{"$f":"'Gas & Diesel Forecast Data'!M$6-G6","v":2453.8975},{"$f":"'Gas & Diesel Forecast Data'!N$6-H6","v":2492.7049999999999}]
[null,"Ethanol","MM Gallons","[2]",{"$f":"'Gas & Diesel Forecast Data'!K$6*E$7","v":243.16500000000002},{"$f":"'Gas & Diesel Forecast Data'!L$6*'Summary Table '!G$7","v":259.2525},{"$f":"'Gas & Diesel Forecast Data'!M$6*'Summary Table '!H$7","v":265.10250000000002},{"$f":"'Gas & Diesel Forecast Data'!N$6*'Summary Table '!I$7","v":269.29500000000002}]
[null,"Ethanol Blend Rate","%","[3]",9.7500000000000003E-2,9.7500000000000003E-2,9.7500000000000003E-2,9.7500000000000003E-2]
[null,"Total Gasoline","MM Gallons","[4]",{"$f":"SUM(E5:E6)","v":2494},{"$f":"SUM(F5:F6)","v":2659},{"$f":"SUM(G5:G6)","v":2719},{"$f":"SUM(H5:H6)","v":2762}]
[]
[null,"Sources & Notes:"]
[null,"[1]: 'Gas & Diesel Forecast Data' less Ethanol blend volume."]
[null,"[2]: 'Gas & Diesel Forecast Data' times Ethanol blend percentage."]
[null,"[3]: BRG analysis based on historical experience in Oregon and California and other market trends."]

{"sheet":"Petroleum Availability","index":9,"n_rows":63,"n_cols":5,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Petroleum Production and Available Capacity (2022)"]
[]
[null,"Product",null,"Gallons (EIA)","% of barrel"]
[null,"Finished motor gasoline","[1]",19.399999999999999,{"$f":"D5/Conversions!D5","v":0.46190476190476187}]
[null,"Distillate fuel oil","[1]",13.44,{"$f":"D6/Conversions!D5","v":0.32}]
[]
[null,null,"Crude Oil Distillation Operable Capacity ","Gasoline","Diesel"]
[null,"State","(MM Barrels per Calendar Day)","(MM gal/ year)","(MM gal/year)"]
[null,null,"[2]"]
[null,"East Coast (PADD 1)"]
[null,"Delaware",0.17100000000000001,{"$f":"(C12*365)*Conversions!$D$5*$E$5","v":1210.8510000000001},{"$f":"(C12*365)*Conversions!$D$5*$E$6","v":838.85760000000016}]
[null,"Florida",0,{"$f":"(C13*365)*Conversions!$D$5*$E$5","v":0},{"$f":"(C13*365)*Conversions!$D$5*$E$6","v":0}]
[null,"Georgia",0,{"$f":"(C14*365)*Conversions!$D$5*$E$5","v":0},{"$f":"(C14*365)*Conversions!$D$5*$E$6","v":0}]
[null,"Maryland",0,{"$f":"(C15*365)*Conversions!$D$5*$E$5","v":0},{"$f":"(C15*365)*Conversions!$D$5*$E$6","v":0}]
[null,"New Jersey",0.35849999999999999,{"$f":"(C16*365)*Conversions!$D$5*$E$5","v":2538.5384999999997},{"$f":"(C16*365)*Conversions!$D$5*$E$6","v":1758.6575999999998}]
[null,"New York",0,{"$f":"(C17*365)*Conversions!$D$5*$E$5","v":0},{"$f":"(C17*365)*Conversions!$D$5*$E$6","v":0}]
[null,"North Carolina",0,{"$f":"(C18*365)*Conversions!$D$5*$E$5","v":0},{"$f":"(C18*365)*Conversions!$D$5*$E$6","v":0}]
[null,"Pennsylvania",0.26600000000000001,{"$f":"(C19*365)*Conversions!$D$5*$E$5","v":1883.546},{"$f":"(C19*365)*Conversions!$D$5*$E$6","v":1304.8896000000002}]
[null,"Virginia",0,{"$f":"(C20*365)*Conversions!$D$5*$E$5","v":0},{"$f":"(C20*365)*Conversions!$D$5*$E$6","v":0}]
[null,"West Virginia",2.23E-2,{"$f":"(C21*365)*Conversions!$D$5*$E$5","v":157.90629999999999},{"$f":"(C21*365)*Conversions!$D$5*$E$6","v":109.39488}]
[null,"Midwest (PADD 2)"]
[null,"Illinois",1.040065,{"$f":"(C23*365)*Conversions!$D$5*$E$5","v":7364.7002649999995},{"$f":"(C23*365)*Conversions!$D$5*$E$6","v":5102.1428640000004}]
[null,"Indiana",0.46729999999999999,{"$f":"(C24*365)*Conversions!$D$5*$E$5","v":3308.9513000000002},{"$f":"(C24*365)*Conversions!$D$5*$E$6","v":2292.3868800000005}]
[null,"Kansas",0.4042,{"$f":"(C25*365)*Conversions!$D$5*$E$5","v":2862.1401999999998},{"$f":"(C25*365)*Conversions!$D$5*$E$6","v":1982.8435200000001}]
[null,"Kentucky",0.29099999999999998,{"$f":"(C26*365)*Conversions!$D$5*$E$5","v":2060.5709999999999},{"$f":"(C26*365)*Conversions!$D$5*$E$6","v":1427.5295999999998}]
[null,"Michigan",0.14000000000000001,{"$f":"(C27*365)*Conversions!$D$5*$E$5","v":991.34},{"$f":"(C27*365)*Conversions!$D$5*$E$6","v":686.78400000000011}]
[null,"Minnesota",0.439,{"$f":"(C28*365)*Conversions!$D$5*$E$5","v":3108.5590000000002},{"$f":"(C28*365)*Conversions!$D$5*$E$6","v":2153.5584000000003}]
[null,"Missouri ",0,{"$f":"(C29*365)*Conversions!$D$5*$E$5","v":0},{"$f":"(C29*365)*Conversions!$D$5*$E$6","v":0}]
[null,"Nebraska",0,{"$f":"(C30*365)*Conversions!$D$5*$E$5","v":0},{"$f":"(C30*365)*Conversions!$D$5*$E$6","v":0}]
[null,"North Dakota",7.0999999999999994E-2,{"$f":"(C31*365)*Conversions!$D$5*$E$5","v":502.75099999999998},{"$f":"(C31*365)*Conversions!$D$5*$E$6","v":348.29760000000005}]
[null,"Ohio",0.60260000000000002,{"$f":"(C32*365)*Conversions!$D$5*$E$5","v":4267.0105999999996},{"$f":"(C32*365)*Conversions!$D$5*$E$6","v":2956.11456}]
[null,"Oklahoma",0.52380000000000004,{"$f":"(C33*365)*Conversions!$D$5*$E$5","v":3709.0277999999998},{"$f":"(C33*365)*Conversions!$D$5*$E$6","v":2569.5532800000001}]
[null,"Tennessee",0.18,{"$f":"(C34*365)*Conversions!$D$5*$E$5","v":1274.58},{"$f":"(C34*365)*Conversions!$D$5*$E$6","v":883.00800000000004}]
[null,"Wisconsin",3.7999999999999999E-2,{"$f":"(C35*365)*Conversions!$D$5*$E$5","v":269.07799999999997},{"$f":"(C35*365)*Conversions!$D$5*$E$6","v":186.4128}]
[null,"Gulf Coast (PADD 3)"]
[null,"Alabama",0.1411,{"$f":"(C37*365)*Conversions!$D$5*$E$5","v":999.12909999999999},{"$f":"(C37*365)*Conversions!$D$5*$E$6","v":692.18016}]
[null,"Arkansas",9.0499999999999997E-2,{"$f":"(C38*365)*Conversions!$D$5*$E$5","v":640.83049999999992},{"$f":"(C38*365)*Conversions!$D$5*$E$6","v":443.95679999999999}]
[null,"Louisiana",2.9225409999999998,{"$f":"(C39*365)*Conversions!$D$5*$E$5","v":20694.512820999997},{"$f":"(C39*365)*Conversions!$D$5*$E$6","v":14336.8171296}]
[null,"Mississippi",0.39394000000000001,{"$f":"(C40*365)*Conversions!$D$5*$E$5","v":2789.4891400000001},{"$f":"(C40*365)*Conversions!$D$5*$E$6","v":1932.5120640000002}]
[null,"New Mexico",0.11,{"$f":"(C41*365)*Conversions!$D$5*$E$5","v":778.91},{"$f":"(C41*365)*Conversions!$D$5*$E$6","v":539.61599999999999}]
[null,"Texas",5.9485289999999997,{"$f":"(C42*365)*Conversions!$D$5*$E$5","v":42121.533848999992},{"$f":"(C42*365)*Conversions!$D$5*$E$6","v":29181.103862399999}]
[null,"Rocky Mountain (PADD 4)"]
[null,"Colorado",0.10299999999999999,{"$f":"(C44*365)*Conversions!$D$5*$E$5","v":729.34299999999996},{"$f":"(C44*365)*Conversions!$D$5*$E$6","v":505.27680000000004}]
[null,"Montana",0.2276,{"$f":"(C45*365)*Conversions!$D$5*$E$5","v":1611.6355999999998},{"$f":"(C45*365)*Conversions!$D$5*$E$6","v":1116.5145599999998}]
[null,"Utah",0.20671400000000001,{"$f":"(C46*365)*Conversions!$D$5*$E$5","v":1463.7418339999999},{"$f":"(C46*365)*Conversions!$D$5*$E$6","v":1014.0561984}]
[null,"Wyoming",0.12584999999999999,{"$f":"(C47*365)*Conversions!$D$5*$E$5","v":891.14384999999982},{"$f":"(C47*365)*Conversions!$D$5*$E$6","v":617.36975999999993}]
[null,"West Coast (PADD 5)"]
[null,"Alaska",0.16420000000000001,{"$f":"(C49*365)*Conversions!$D$5*$E$5","v":1162.7002},{"$f":"(C49*365)*Conversions!$D$5*$E$6","v":805.49952000000008}]
[null,"California",1.749871,{"$f":"(C50*365)*Conversions!$D$5*$E$5","v":12390.836550999999},{"$f":"(C50*365)*Conversions!$D$5*$E$6","v":8584.1671775999985}]
[null,"Hawaii",9.35E-2,{"$f":"(C51*365)*Conversions!$D$5*$E$5","v":662.07349999999997},{"$f":"(C51*365)*Conversions!$D$5*$E$6","v":458.67360000000002}]
[null,"Nevada",2E-3,{"$f":"(C52*365)*Conversions!$D$5*$E$5","v":14.161999999999999},{"$f":"(C52*365)*Conversions!$D$5*$E$6","v":9.8111999999999995}]
[null,"Washington",0.64970000000000006,{"$f":"(C53*365)*Conversions!$D$5*$E$5","v":4600.5257000000001},{"$f":"(C53*365)*Conversions!$D$5*$E$6","v":3187.1683200000007}]
[null,"PADD 1",{"$f":"SUM(C12:C21)","v":0.81779999999999997},{"$f":"SUM(D12:D21)","v":5790.8417999999992},{"$f":"SUM(E12:E21)","v":4011.7996800000001}]
[null,"PADD 2",{"$f":"SUM(C23:C35)","v":4.1969650000000005},{"$f":"SUM(D23:D35)","v":29718.709165},{"$f":"SUM(E23:E35)","v":20588.631504000001}]
[null,"PADD 3",{"$f":"SUM(C37:C42)","v":9.6066099999999999},{"$f":"SUM(D37:D42)","v":68024.405409999992},{"$f":"SUM(E37:E42)","v":47126.186016}]
[null,"PADD 4",{"$f":"SUM(C44:C47)","v":0.66316400000000009},{"$f":"SUM(D44:D47)","v":4695.8642839999993},{"$f":"SUM(E44:E47)","v":3253.2173183999998}]
[null,"PADD 5",{"$f":"SUM(C49:C53)","v":2.6592709999999999},{"$f":"SUM(D49:D53)","v":18830.297951},{"$f":"SUM(E49:E53)","v":13045.319817599999}]
[null,"U.S.",{"$f":"SUM(C54:C58)","v":17.943809999999999},{"$f":"SUM(D54:D58)","v":127060.11860999999},{"$f":"SUM(E54:E58)","v":88025.154336000007}]
[]
[null,"Sources:"]
[null,"[1] Petroleum products produced from one 42-gallon barrel of oil input at U.S. refineries, 2020, https://www.eia.gov/energyexplained/oil-and-petroleum-products/refining-crude-oil-inputs-and-outputs.php"]
[null,"[2] U.S. Energy Information Administration, Number and Capacity of Petroleum Refineries, accessed as of Sept. 2, 2022. https://www.eia.gov/dnav/pet/pet_pnp_cap1_dcu_nus_a.htm"]

{"sheet":"Ethanol Availability","index":10,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Ethanol Production (2022)"]
[]
[null,"State","Number of Producers","Production Capacity","Production Capacity"]
[null,null,null," (MM gal/year)"," (Thousand Barrels/day)"]
[null,null,"[1]","[2]","[2] "]
[null,"East Coast (PADD 1)"]
[null,"New York",2,62,4.0443574690149999]
[null,"North Carolina",1,57,3.7181996086105675]
[null,"Pennsylvania",1,128,8.3496412263535547]
[null,"Midwest (PADD 2)"]
[null,"Illinois",13,1743,113.69863013698631]
[null,"Indiana",14,1315,85.779517286366612]
[null,"Iowa",41,4694,306.19699934768437]
[null,"Kansas",12,601,38.81278538812785]
[null,"Kentucky",2,53,3.131115459882583]
[null,"Michigan",5,387,25.244618395303323]
[null,"Minnesota",19,1424,92.889758643183299]
[null,"Missouri",6,331,21.591650358773645]
[null,"Nebraska",24,2244,146.37964774951075]
[null,"North Dakota",5,547,35.68166992824527]
[null,"Ohio",7,722,47.097195042400521]
[null,"South Dakota",16,1444,94.194390084801057]
[null,"Tennessee",3,236,15.329419439008479]
[null,"Wisconsin",9,587,38.290932811480751]
[null,"Gulf Coast (PADD 3)"]
[null,"Texas",3,380,24.787997390737118]
[null,"Rocky Mountains (PADD 4)"]
[null,"Colorado",3,140,9.1324200913242013]
[null,"Idaho",1,60,3.9138943248532287]
[null,"West Coast (PADD 5)"]
[null,"California",4,188,12.0678408349641]
[null,"Oregon",1,40,2.6092628832354858]
[null,"PADD 1",{"$f":"SUM(C8:C10)","v":4},{"$f":"SUM(D8:D10)","v":247},{"$f":"SUM(E8:E10)","v":16.11219830397912}]
[null,"PADD 2",{"$f":"SUM(C12:C25)","v":176},{"$f":"SUM(D12:D25)","v":16328},{"$f":"SUM(E12:E25)","v":1064.3183300717549}]
[null,"PADD 3",{"$f":"C27","v":3},{"$f":"D27","v":380},{"$f":"E27","v":24.787997390737118}]
[null,"PADD 4",{"$f":"SUM(C29:C30)","v":4},{"$f":"SUM(D29:D30)","v":200},{"$f":"SUM(E29:E30)","v":13.046314416177431}]
[null,"PADD 5",{"$f":"SUM(C32:C33)","v":5},{"$f":"SUM(D32:D33)","v":228},{"$f":"SUM(E32:E33)","v":14.677103718199586}]
[null,"US Total",{"$f":"SUM(C34:C38)","v":192},{"$f":"SUM(D34:D38)","v":17383},{"$f":"SUM(E34:E38)","v":1132.9419439008479}]
[]
[null,"Sources and Notes:"]
[null,"[1]-[2]: U.S. Energy Information Administration, U.S. Fuel Ethanol Plant Production Capacity, accessed as of Sept. 2, 2022. https://www.eia.gov/petroleum/ethanolcapacity/"]

{"sheet":"Diesel + Alts Cons Forecast","index":11,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Diesel and Diesel Alternatives Volume Consumption Forecast"]
[]
[null,"Fuel Type","Unit","Citation Reference","2021","2022","2023","2024"]
[null,"Fossil Diesel","MM Gallons","[1]",{"$f":"'Gas & Diesel Forecast Data'!K$10-SUM(E$6,E$8)","v":707.85},{"$f":"'Gas & Diesel Forecast Data'!L$10-SUM(F$6,F$8)","v":757.57500000000005},{"$f":"'Gas & Diesel Forecast Data'!M$10-SUM(G$6,G$8)","v":712.63660000000004},{"$f":"'Gas & Diesel Forecast Data'!N$10-SUM(H$6,H$8)","v":699.48130000000003}]
[null,"Biodiesel","MM Gallons","[2]",{"$f":"'Gas & Diesel Forecast Data'!K$10*E$7","v":18.150000000000002},{"$f":"'Gas & Diesel Forecast Data'!L$10*F$7","v":19.425000000000001},{"$f":"'Gas & Diesel Forecast Data'!M$10*G$7","v":40.038400000000003},{"$f":"'Gas & Diesel Forecast Data'!N$10*H$7","v":48.0137}]
[null,"Biodiesel Blend Rate","%","[3]",2.5000000000000001E-2,2.5000000000000001E-2,5.1200000000000002E-2,6.0700000000000004E-2]
[null,"Renewable Diesel","MM Gallons","[4]",{"$f":"'Gas & Diesel Forecast Data'!K$10*E$9","v":0},{"$f":"'Gas & Diesel Forecast Data'!L$10*F$9","v":0},{"$f":"'Gas & Diesel Forecast Data'!M$10*G$9","v":29.324999999999999},{"$f":"'Gas & Diesel Forecast Data'!N$10*H$9","v":43.505000000000003}]
[null,"Renewable Diesel Blend Rate","%","[5]",0,0,3.7499999999999999E-2,5.5E-2]
[null,"Total Diesel","MM Gallons","[6]",{"$f":"SUM(E5:E6,E8)","v":726},{"$f":"SUM(F5:F6,F8)","v":777},782.00000000000011,791]
[]
[null,"Sources and Notes:"]
[null,"[1]: 'Gas & Diesel Forecast Data' less Biodiesel and Renewable Diesel blend volumes."]
[null,"[2]: 'Gas & Diesel Forecast Data' times Biodiesel blend percentage."]
[null,"[3]: BRG analysis based on historical experience in Oregon and California and other market trends."]
[null,"[4]: 'Gas & Diesel Forecast Data' times Renewable Diesel blend percentage."]
[null,"[5]: BRG analysis based on historical experience in Oregon and California and other market trends."]

{"sheet":"Biodiesel Availability","index":12,"n_rows":50,"n_cols":5,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Biodiesel Production (2022)"]
[]
[null,"State","Number of Producers","Production Capacity","Production Capacity"]
[null,null,null," (MM gal/year)"," (Thousand Barrels/day)"]
[null,null,"[1]","[2]","[2]"]
[null,"East Coast PADD 1"]
[null,"Connecticut",1,35,2.2831050228310503]
[null,"Georgia",2,22,1.30463144161774]
[null,"Massachusetts",1,1,0]
[null,"Maine",1,1,0]
[null,"North Carolina",1,2,0]
[null,"New Hampshire",1,8,0.52185257664709717]
[null,"Pennsylvania",2,64,4.1748206131767773]
[null,"Rhode Island",1,8,0.5]
[null,"South Carolina",1,5,0]
[null,"Virginia",3,11,0]
[null,"Midwest (PADD 2)"]
[null,"Iowa",11,470,30.658838878016958]
[null,"Illinois",4,192,12.263535551206784]
[null,"Indiana",3,107,6.4579256360078281]
[null,"Kansas",1,90,5.8708414872798436]
[null,"Kentucky",2,56,3.5225048923679063]
[null,"Michigan",2,15,0.97847358121330719]
[null,"Minnesota",3,85,5.3489889106327464]
[null,"Missouri",6,238,15.198956294846704]
[null,"North Dakota",1,85,5.5446836268754076]
[null,"Oklahoma",1,38,2.478799739073712]
[null,"Tennessee",1,36,2.3483365949119372]
[null,"Wisconsin",2,33,1.8264840182648401]
[null,"Gulf Coast (PADD 3)"]
[null,"Alabama",1,20,1.3046314416177429]
[null,"Arkansas",3,115,7.5016307893020215]
[null,"Mississippi",2,29,1.8917155903457274]
[null,"Texas",6,291,18.982387475538161]
[null,"West Coast (PADD 5)"]
[null,"Arizona",1,2,0]
[null,"California",4,72,4.6966731898238745]
[null,"Oregon",1,12,0.78277886497064575]
[null,"Washington",1,107,6.9797782126549244]
[null,"PADD 1",{"$f":"SUM(C8:C17)","v":14},{"$f":"SUM(D8:D17)","v":157},{"$f":"SUM(E8:E17)","v":8.7844096542726646}]
[null,"PADD 2",{"$f":"SUM(C19:C30)","v":37},{"$f":"SUM(D19:D30)","v":1445},{"$f":"SUM(E19:E30)","v":92.498369210697973}]
[null,"PADD 3",{"$f":"SUM(C32:C35)","v":12},{"$f":"SUM(D32:D35)","v":455},{"$f":"SUM(E32:E35)","v":29.68036529680365}]
[null,"PADD 4"]
[null,"PADD 5",{"$f":"SUM(C37:C40)","v":7},{"$f":"SUM(D37:D40)","v":193},{"$f":"SUM(E37:E40)","v":12.459230267449446}]
[null,"US Total",{"$f":"SUM(C41:C45)","v":70},{"$f":"SUM(D41:D45)","v":2250},{"$f":"SUM(E41:E45)","v":143.42237442922374}]
[]
[null,"Sources and Notes: "]
[null,"[1]: U.S. Energy Information Administration, U.S. Biodiesel Plant Production Capacity, accessed as of Sept. 2, 2022. https://www.eia.gov/biofuels/biodiesel/capacity/"]
[null,"[2]: U.S. Energy Information Administration, U.S. Biodiesel Plant Production Capacity, accessed as of Sept. 2, 2022. https://www.eia.gov/biofuels/biodiesel/capacity/"]

{"sheet":"Renewable Diesel Availability","index":13,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Renewable Diesel Availability (2023)"]
[]
[null,"State","Number of Producers","Production Capacity","Production Capacity"]
[null,null,null," (MM gal/year)"," (Thousand Barrels/day)"]
[null,null,null,"[1]","[1]"]
[null,"Midwest (PADD 2)"]
[null,"Kansas",1,3,0]
[null,"North Dakota",1,192,12.524461839530332]
[null,"Gulf Coast (PADD 3)"]
[null,"Louisiana",2,1082,70.580560991519903]
[null,"Rocky Mountains (PADD 4)"]
[null,"Wyoming",2,209,13.6333985649054]
[null,"West Coast (PADD 5)"]
[null,"California",4,199,12.589693411611218]
[null,"Washington*",1,109,4.0071232876712326]
[null,"PADD 1"]
[null,"PADD 2",{"$f":"SUM(C8:C9)","v":2},{"$f":"SUM(D8:D9)","v":195},{"$f":"SUM(E8:E9)","v":12.524461839530332}]
[null,"PADD 3",{"$f":"C11","v":2},{"$f":"D11","v":1082},{"$f":"E11","v":70.580560991519903}]
[null,"PADD 4",{"$f":"C13","v":2},{"$f":"D13","v":209},{"$f":"E13","v":13.6333985649054}]
[null,"PADD 5",{"$f":"SUM(C15:C16)","v":5},{"$f":"SUM(D15:D16)","v":308},{"$f":"SUM(E15:E16)","v":16.596816699282449}]
[null,"US Total",{"$f":"SUM(C17:C21)","v":11},{"$f":"SUM(D17:D21)","v":1794},{"$f":"SUM(E17:E21)","v":113.33523809523808}]
[]
[null,"Sources and Notes:"]
[null,"[1]: U.S. Energy Information Administration, U.S. Renewable Diesel Fuel and Other Biofuels Plant Production Capacity, accessed as of Sept. 2, 2022. https://www.eia.gov/biofuels/renewable/capacity/"]
[null,"* Cherry Point Refinery is expected to be operational by 2023. BP, BP investing almost $270 million to improve efficiency, reduce emissions and grow renewable diesel production at Cherry Point Refinery, https://www.bp.com/en/global/corporate/news-and-insights/press-releases/bp-investing-almost-270m-to-improve-efficiency-reduce-emissions-and-grow-renewable-diesel-production-at-cherry-point-refinery.html"]

{"sheet":"Electricity Cons Forecast","index":14,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Electricity Consumption Forecast"]
[]
[null,"Fuel Type","Unit","Citation Reference","2021","2022","2023","2024"]
[null,"Electricity (BEVs)","GWh","[1]",{"$f":"('Vehicle Stock Forecast'!K$39*'Washington EV Data'!$F$7)/1000000","v":109.63538},{"$f":"('Vehicle Stock Forecast'!L$39*'Washington EV Data'!$F$7)/1000000","v":138.88252985999998},{"$f":"('Vehicle Stock Forecast'!M$39*'Washington EV Data'!$F$7)/1000000","v":185.22769967999997},{"$f":"('Vehicle Stock Forecast'!N$39*'Washington EV Data'!$F$7)/1000000","v":235.67527243999999}]
[null,"Electricity (PHEVs)","GWh","[2]",{"$f":"('Vehicle Stock Forecast'!K$40*'Washington EV Data'!$F$15)/1000000","v":21.202791113439968},{"$f":"('Vehicle Stock Forecast'!L$40*'Washington EV Data'!$F$15)/1000000","v":23.651713487042286},{"$f":"('Vehicle Stock Forecast'!M$40*'Washington EV Data'!$F$15)/1000000","v":27.465565538572299},{"$f":"('Vehicle Stock Forecast'!N$40*'Washington EV Data'!$F$15)/1000000","v":31.154851192310854}]
[null,"Electricity","GWh","[3]",{"$f":"SUM(E5:E6)","v":130.83817111343996},{"$f":"SUM(F5:F6)","v":162.53424334704226},212.69326521857226,266.83012363231086]
[]
[null,"Sources and Notes:"]
[null,"[1]: 'Vehicle Stock Forecast' for BEVs times the average annual electricity consumption for BEVs in Washington."]
[null,"[2]: 'Vehicle Stock Forecast' for PHEVs times the average annual electricity consumption for PHEVs in Washington. 10% of PHEV vehicle miles traveled is assumed to be gasoline powered."]

{"sheet":"Electricity Availability","index":15,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Electricity Generation Availability (2020)"]
[]
[null,"Interconnection","State","Generation Available"]
[null,null,null,"(GWh/year)"]
[null,null,null,"[1]"]
[null,"WECC","AZ",109305.057]
[null,"WECC","CA",193074.93]
[null,"WECC","CO",54115.010999999999]
[null,"WECC","ID",17686.134999999998]
[null,"WECC","NV",40424.745000000003]
[null,"WECC","OR",63624.781999999999]
[null,"WECC","UT",37087.309000000001]
[null,"WECC","WA",116114.46799999999]
[null,"Rest of WECC*",null,32407.458999999999]
[null,"Total WECC",null,{"$f":"SUM(D7:D15)","v":663839.89599999995}]
[]
[null,"Sources and Notes:"]
[null,"[1]: U.S. Energy Information Administration, Generation Tables, accessed as of Sept. 2, 2022. https://www.eia.gov/electricity/annual/html/epa_03_07.html"]
[null,"* Rest of WECC: Balance of WECC generation not accounted for by state in the above. https://www.eia.gov/electricity/gridmonitor/dashboard/"]

{"sheet":"Natural Gas + RNG Forecast","index":16,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Natural Gas and Renewable Natural Gas Consumption Forecast"]
[]
[null,"Fuel Type","Unit","Citation Reference","2021","2022","2023","2024"]
[null,"Natural Gas","MM Diesel Gallons Equivalent","[1]",{"$f":"E8-E6","v":9.6855517076878603E-2},{"$f":"F8-F6","v":9.6855517076878603E-2},{"$f":"G8-G6","v":2.0469477244852055E-2},{"$f":"H8-H6","v":1.210693963460982E-2}]
[null,"Renewable Natural Gas","MM Diesel Gallons Equivalent","[2]",{"$f":"E8*E7","v":0},{"$f":"F8*F7","v":0},{"$f":"G8*G7","v":7.6386039832026548E-2},{"$f":"H8*H7","v":8.4748577442268783E-2}]
[null,"Renewable Natural Gas Blend Rate","%","[3]",0,0,0.78865966686642641,0.875]
[null,"Total Natural Gas","MM Diesel Gallons Equivalent","[4]",{"$f":"((('CNG Vehicle Registrations'!$F$7*'CNG Vehicle Registrations'!$F$8)*'Fuel Energy Consumption'!$E$10)/'Fuel Energy Consumption'!$E$15)/(10^6)","v":9.6855517076878603E-2},{"$f":"((('CNG Vehicle Registrations'!$F$7*'CNG Vehicle Registrations'!$F$8)*'Fuel Energy Consumption'!$E$10)/'Fuel Energy Consumption'!$E$15)/(10^6)","v":9.6855517076878603E-2},{"$f":"((('CNG Vehicle Registrations'!$F$7*'CNG Vehicle Registrations'!$F$8)*'Fuel Energy Consumption'!$E$10)/'Fuel Energy Consumption'!$E$15)/(10^6)","v":9.6855517076878603E-2},{"$f":"((('CNG Vehicle Registrations'!$F$7*'CNG Vehicle Registrations'!$F$8)*'Fuel Energy Consumption'!$E$10)/'Fuel Energy Consumption'!$E$15)/(10^6)","v":9.6855517076878603E-2}]
[]
[null,"Sources and Notes:"]
[null,"[1]: 'CNG Vehicle Registrations' times average annual CNG consumption per vehicle. Converted into MM Diesel Gallons Equivalent."]
[null,"[2]: Renewable natural gas produced in Washington is typically exported to California or Oregon to take advantage of multiple incentive structures. With the implementation of a CFS the blendrate of RNG is assumed to increase year over year."]
[null,"[3]: BRG analysis based on historical experience in Oregon and California and other market trends."]

{"sheet":"Natural Gas Availability","index":17,"n_rows":56,"n_cols":4,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Natural Gas Production (2022)"]
[]
[null,"State","Production Capacity","Production Capacity"]
[null,null,"(Million cu ft)","(Million DGE)"]
[null,null,"[1]"]
[null,"East Coast (PADD 1)"]
[null,"Florida",698,{"$f":"(C8/Conversions!$D$6)","v":5.0107681263460151}]
[null,"Maryland",10,{"$f":"(C9/Conversions!$D$6)","v":7.1787508973438621E-2}]
[null,"New York",9692,{"$f":"(C10/Conversions!$D$6)","v":69.576453697056706}]
[null,"Pennsylvania",7148295,{"$f":"(C11/Conversions!$D$6)","v":51315.82914572864}]
[null,"Virginia",102824,{"$f":"(C12/Conversions!$D$6)","v":738.1478822684852}]
[null,"West Virginia",2592319,{"$f":"(C13/Conversions!$D$6)","v":18609.612347451541}]
[null,"Midwest (PADD 2)"]
[null,"Illinois",1843,{"$f":"(C15/Conversions!$D$6)","v":13.230437903804736}]
[null,"Indiana",4197,{"$f":"(C16/Conversions!$D$6)","v":30.129217516152188}]
[null,"Kansas",163356,{"$f":"(C17/Conversions!$D$6)","v":1172.6920315865038}]
[null,"Kentucky",71018,{"$f":"(C18/Conversions!$D$6)","v":509.82053122756633}]
[null,"Michigan",64911,{"$f":"(C19/Conversions!$D$6)","v":465.97989949748739}]
[null,"Missouri",1,{"$f":"(C20/Conversions!$D$6)","v":7.1787508973438618E-3}]
[null,"Nebraska",351,{"$f":"(C21/Conversions!$D$6)","v":2.5197415649676955}]
[null,"North Dakota",882443,{"$f":"(C22/Conversions!$D$6)","v":6334.8384781048089}]
[null,"Ohio",2378902,{"$f":"(C23/Conversions!$D$6)","v":17077.544867193108}]
[null,"Oklahoma",2786366,{"$f":"(C24/Conversions!$D$6)","v":20002.627422828427}]
[null,"South Dakota",407,{"$f":"(C25/Conversions!$D$6)","v":2.9217516152189518}]
[null,"Tennessee",2770,{"$f":"(C26/Conversions!$D$6)","v":19.885139985642496}]
[null,"Gulf Coast (PADD 3)"]
[null,"Alabama",117028,{"$f":"(C28/Conversions!$D$6)","v":840.11486001435742}]
[null,"Arkansas",480982,{"$f":"(C29/Conversions!$D$6)","v":3452.8499641062454}]
[null,"Louisiana",3206163,{"$f":"(C30/Conversions!$D$6)","v":23016.245513280686}]
[null,"Mississippi",28134,{"$f":"(C31/Conversions!$D$6)","v":201.96697774587221}]
[null,"New Mexico",1948168,{"$f":"(C32/Conversions!$D$6)","v":13985.412778176596}]
[null,"Texas",9336110,{"$f":"(C33/Conversions!$D$6)","v":67021.608040200997}]
[null,"Rocky Mountains (PADD 4)"]
[null,"Colorado",1990462,{"$f":"(C35/Conversions!$D$6)","v":14289.030868628857}]
[null,"Montana",37963,{"$f":"(C36/Conversions!$D$6)","v":272.52692031586503}]
[null,"Utah",241989,{"$f":"(C37/Conversions!$D$6)","v":1737.1787508973437}]
[null,"Wyoming",1306368,{"$f":"(C38/Conversions!$D$6)","v":9378.0904522613055}]
[null,"West Coast (PADD 5)"]
[null,"Arizona",66,{"$f":"(C40/Conversions!$D$6)","v":0.47379755922469485}]
[null,"California",170579,{"$f":"(C41/Conversions!$D$6)","v":1224.5441493180185}]
[null,"Nevada",12,{"$f":"(C42/Conversions!$D$6)","v":8.6145010768126334E-2}]
[null,"Oregon",320,{"$f":"(C43/Conversions!$D$6)","v":2.2972002871500359}]
[null,"PADD 1",{"$f":"SUM(C8:C13)","v":9853838},{"$f":"SUM(D8:D13)","v":70738.248384781036}]
[null,"PADD 2",{"$f":"SUM(C15:C26)","v":6356565},{"$f":"SUM(D15:D26)","v":45632.196697774591}]
[null,"PADD 3",{"$f":"SUM(C28:C33)","v":15116585},{"$f":"SUM(D28:D33)","v":108518.19813352475}]
[null,"PADD 4",{"$f":"SUM(C35:C38)","v":3576782},{"$f":"SUM(D35:D38)","v":25676.826992103372}]
[null,"PADD 5",{"$f":"SUM(C40:C43)","v":170977},{"$f":"SUM(D40:D43)","v":1227.4012921751614}]
[null,"US Total",{"$f":"SUM(C44:C48)","v":35074747},{"$f":"SUM(D44:D48)","v":251792.87150035892}]
[null,"Alberta, CA2",{"$f":"104.009*Conversions!$D$4*1000","v":3675262.0239999997},{"$f":"(C50/Conversions!$D$6)","v":26383.790552763814}]
[null,"British Columbia, CA3",{"$f":"52.82*Conversions!$D$4*1000","v":1866447.52},{"$f":"(C51/Conversions!$D$6)","v":13398.761809045225}]
[]
[null,"Sources and Notes:"]
[null,"[1]: U.S. Energy Information Administration, Natural Gas Plant Field Production, accessed as of Sept. 2, 2022. https://www.eia.gov/state/rankings/?sid=MI#series/47"]
[null,"[2]: 104.009 bcm is the sum of 2021 Natural Gas Production numbers from Alberta, Economic Dashboard, https://economicdashboard.alberta.ca/NaturalGasProduction"]
[null,"[3]: 52.82 bcm is the sum of 2021 Natural Gas Production numbers from British Columbia, Natural Gas and Oil Statistics, https://www2.gov.bc.ca/gov/content/industry/natural-gas-oil/statistics"]

{"sheet":"Renew Natural Gas Availability","index":18,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Renewable Natural Gas Production Availability (2022)"]
[]
[null,"State","Total Number of Producers","Production Volume (2021)"]
[null,null,null,"Food Waste","Landfills","Livestock","Water Treatment Facility","Total","Food Waste","Landfills","Livestock","Water Treatment Facility","Total"]
[null,null,null,"MMBtu/year","Mmbtu/year","MMBtu/year","MMBtu/year","MMBtu/year","MM DGE","MM DGE","MM DGE","MM DGE","MM DGE"]
[null,null,null,"[1]"]
[null,"East Coast (PADD 1)"]
[null,"Georgia",1,"-",430006.5,"-","-",{"$f":"IF(SUM(D9:G9),SUM(D9:G9),\"-\")","v":430006.5},{"$f":"IFERROR((D9/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((E9/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":2.9710390257350272},{"$f":"IFERROR((F9/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((G9/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IF(SUM(I9:L9),SUM(I9:L9),\"-\")","v":2.9710390257350272}]
[null,"New York",12,"-",1254635,448146.48879999999,591300,{"$f":"IF(SUM(D10:G10),SUM(D10:G10),\"-\")","v":2294081.4887999999},{"$f":"IFERROR((D10/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((E10/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":8.668635353309929},{"$f":"IFERROR((F10/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":3.0963734442872961},{"$f":"IFERROR((G10/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":4.0854623730504578},{"$f":"IF(SUM(I10:L10),SUM(I10:L10),\"-\")","v":15.850471170647683}]
[null,"North Carolina",2,"-","-",220000,"-",{"$f":"IF(SUM(D11:G11),SUM(D11:G11),\"-\")","v":220000},{"$f":"IFERROR((D11/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((E11/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((F11/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":1.5200435008812798},{"$f":"IFERROR((G11/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IF(SUM(I11:L11),SUM(I11:L11),\"-\")","v":1.5200435008812798}]
[null,"Pennsylvania",9,"-",4047101.75,"-","-",{"$f":"IF(SUM(D12:G12),SUM(D12:G12),\"-\")","v":4047101.75},{"$f":"IFERROR((D12/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((E12/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":27.962594147694336},{"$f":"IFERROR((F12/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((G12/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IF(SUM(I12:L12),SUM(I12:L12),\"-\")","v":27.962594147694336}]
[null,"West Virginia",1,"-",145000,"-","-",{"$f":"IF(SUM(D13:G13),SUM(D13:G13),\"-\")","v":145000},{"$f":"IFERROR((D13/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((E13/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":1.0018468528535707},{"$f":"IFERROR((F13/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((G13/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IF(SUM(I13:L13),SUM(I13:L13),\"-\")","v":1.0018468528535707}]
[null,"Midwest (PADD 2)"]
[null,"Illinois",1,"-",576000,"-","-",{"$f":"IF(SUM(D15:G15),SUM(D15:G15),\"-\")","v":576000},{"$f":"IFERROR((D15/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((E15/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":3.9797502568528045},{"$f":"IFERROR((F15/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((G15/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IF(SUM(I15:L15),SUM(I15:L15),\"-\")","v":3.9797502568528045}]
[null,"Indiana",1,"-",897552,"-","-",897552,{"$f":"IFERROR((D16/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((E16/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":6.2014458377408834},{"$f":"IFERROR((F16/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((G16/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},6.2014458377408834]
[null,"Kansas",2,"-",1540000,"-","-",1540000,{"$f":"IFERROR((D17/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((E17/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":10.640304506168958},{"$f":"IFERROR((F17/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((G17/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},10.640304506168958]
[null,"Kentucky",2,"-",1382572.5,"-","-",1382572.5,{"$f":"IFERROR((D18/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((E18/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":9.5525924687371955},{"$f":"IFERROR((F18/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((G18/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},9.5525924687371955]
[null,"Michigan",6,"-",2442478.68481,"-",141912,2584390.68481,{"$f":"IFERROR((D19/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((E19/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":16.875790231302254},{"$f":"IFERROR((F19/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((G19/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":0.9805109695321097},17.856301200834363]
[null,"Minnesota",1,"-","-",430000,"-",430000,{"$f":"IFERROR((D20/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((E20/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((F20/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":2.9709941153588648},{"$f":"IFERROR((G20/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},2.9709941153588648]
[null,"Missouri",4,"-","-",195000,"-",195000,{"$f":"IFERROR((D21/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((E21/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((F21/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":1.3473112848720432},{"$f":"IFERROR((G21/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},1.3473112848720432]
[null,"Nebraska",6,190000,542577,"-",174990.258,907567.25800000003,{"$f":"IFERROR((D22/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":1.312764841670196},{"$f":"IFERROR((E22/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":3.7488211026257368},{"$f":"IFERROR((F22/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((G22/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":1.2090582017747198},6.2706441460706532]
[null,"Ohio",9,213762.916,6215511.0999999996,"-","-",6429274.0159999998,{"$f":"IFERROR((D23/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":1.4769496872510495},{"$f":"IFERROR((E23/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":42.944760237320239},{"$f":"IFERROR((F23/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((G23/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},44.421709924571289]
[null,"Oklahoma",5,219000,2108766.3300000005,"-","-",2327766.3300000005,{"$f":"IFERROR((D24/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":1.5131342122409102},{"$f":"IFERROR((E24/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":14.570075249062585},{"$f":"IFERROR((F24/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((G24/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},16.083209461303497]
[null,"Tennessee",4,"-",2021314.15,"-","-",2021314.15,{"$f":"IFERROR((D25/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((E25/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":13.965842895213036},{"$f":"IFERROR((F25/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((G25/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},13.965842895213036]
[null,"Wisconsin",16,1332249,632707.42500000005,1920391.4,264.441258,3885612.2662580004,{"$f":"IFERROR((D26/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":9.2048928818435645},{"$f":"IFERROR((E26/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":4.3715582242299087},{"$f":"IFERROR((F26/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":13.268538485083191},{"$f":"IFERROR((G26/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":1.8271009799444076E-3},26.84681669213661]
[null,"Gulf Coast (PADD 3)"]
[null,"Arkansas",1,"-",534600,"-","-",{"$f":"IF(SUM(D28:G28),SUM(D28:G28),\"-\")","v":534600},{"$f":"IFERROR((D28/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((E28/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":3.6937057071415094},{"$f":"IFERROR((F28/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((G28/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IF(SUM(I28:L28),SUM(I28:L28),\"-\")","v":3.6937057071415094}]
[null,"Louisiana",5,"-",3514659,"-","-",{"$f":"IF(SUM(D29:G29),SUM(D29:G29),\"-\")","v":3514659},{"$f":"IFERROR((D29/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((E29/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":24.283793503472261},{"$f":"IFERROR((F29/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((G29/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IF(SUM(I29:L29),SUM(I29:L29),\"-\")","v":24.283793503472261}]
[null,"Mississippi",1,"-",497355,"-","-",{"$f":"IF(SUM(D30:G30),SUM(D30:G30),\"-\")","v":497355},{"$f":"IFERROR((D30/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((E30/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":3.4363692517309494},{"$f":"IFERROR((F30/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((G30/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IF(SUM(I30:L30),SUM(I30:L30),\"-\")","v":3.4363692517309494}]
[null,"New Mexico",1,"-","-",18067.5,"-",{"$f":"IF(SUM(D31:G31),SUM(D31:G31),\"-\")","v":18067.5},{"$f":"IFERROR((D31/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((E31/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((F31/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":0.12483357250987509},{"$f":"IFERROR((G31/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IF(SUM(I31:L31),SUM(I31:L31),\"-\")","v":0.12483357250987509}]
[null,"Texas",21,"-",19687812.175000001,478145,260829,{"$f":"IF(SUM(D32:G32),SUM(D32:G32),\"-\")","v":20426786.175000001},{"$f":"IFERROR((D32/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((E32/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":136.02877701445493},{"$f":"IFERROR((F32/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":3.3036418169494519},{"$f":"IFERROR((G32/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":1.802142846778924},{"$f":"IF(SUM(I32:L32),SUM(I32:L32),\"-\")","v":141.13456167818333}]
[null,"Rocky Mountains (PADD 4)"]
[null,"Idaho",3,"-","-",576545,"-",{"$f":"IF(SUM(D34:G34),SUM(D34:G34),\"-\")","v":576545},{"$f":"IFERROR((D34/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((E34/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((F34/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":3.9835158191618061},{"$f":"IFERROR((G34/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IF(SUM(I34:L34),SUM(I34:L34),\"-\")","v":3.9835158191618061}]
[null,"Montana",1,"-",161704.12500000003,"-","-",{"$f":"IF(SUM(D35:G35),SUM(D35:G35),\"-\")","v":161704.12500000003},{"$f":"IFERROR((D35/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((E35/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":1.1172604739633822},{"$f":"IFERROR((F35/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((G35/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IF(SUM(I35:L35),SUM(I35:L35),\"-\")","v":1.1172604739633822}]
[null,"Utah",2,985500,"-",236000,"-",{"$f":"IF(SUM(D36:G36),SUM(D36:G36),\"-\")","v":1221500},{"$f":"IFERROR((D36/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":6.8091039550840957},{"$f":"IFERROR((E36/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((F36/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":1.6305921191271908},{"$f":"IFERROR((G36/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IF(SUM(I36:L36),SUM(I36:L36),\"-\")","v":8.4396960742112874}]
[null,"West Coast (PADD 5)"]
[null,"Arizona",4,"-","-",1362110.4,752424,{"$f":"IF(SUM(D38:G38),SUM(D38:G38),\"-\")","v":2114534.3999999999},{"$f":"IFERROR((D38/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((E38/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((F38/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":9.4112139136490907},{"$f":"IFERROR((G38/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":5.198714595941345},{"$f":"IF(SUM(I38:L38),SUM(I38:L38),\"-\")","v":14.609928509590436}]
[null,"California",72,927641.42999999993,200715.06599999999,3724829.0584327797,559184.77099999995,{"$f":"IF(SUM(D39:G39),SUM(D39:G39),\"-\")","v":5412370.3254327793},{"$f":"IFERROR((D39/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":6.4093423946350745},{"$f":"IFERROR((E39/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":1.3867983254648049},{"$f":"IFERROR((F39/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":25.735919100747651},{"$f":"IFERROR((G39/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":3.863568986137893},{"$f":"IF(SUM(I39:L39),SUM(I39:L39),\"-\")","v":37.395628806985421}]
[null,"Oregon",3,"-","-",1587472,100000,{"$f":"IF(SUM(D40:G40),SUM(D40:G40),\"-\")","v":1687472},{"$f":"IFERROR((D40/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((E40/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":"-"},{"$f":"IFERROR((F40/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":10.968302256504575},{"$f":"IFERROR((G40/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":0.69092886403694531},{"$f":"IF(SUM(I40:L40),SUM(I40:L40),\"-\")","v":11.65923112054152}]
[null,"Washington",6,4237.6500000000005,3458831,160000,332304,{"$f":"IF(SUM(D41:G41),SUM(D41:G41),\"-\")","v":3955372.65},{"$f":"IFERROR((D41/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":2.9279147006861617E-2},{"$f":"IFERROR((E41/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":23.898061737257716},{"$f":"IFERROR((F41/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":1.1054861824591125},{"$f":"IFERROR((G41/Conversions!$D$3)/Conversions!$D$6,\"-\")","v":2.2959842523493306},{"$f":"IF(SUM(I41:L41),SUM(I41:L41),\"-\")","v":27.328811319073022}]
[null,"PADD 1",{"$f":"SUM(C9:C13)","v":25},{"$f":"SUM(D9:D13)","v":0},5876743.25,668146.48879999993,591300,7136189.7388000004,0,40.604115379592862,4.6164169451685755,4.0854623730504578,49.30599469781189]
[null,"PADD 2",{"$f":"SUM(C15:C26)","v":57},{"$f":"SUM(D15:D26)","v":1955011.916},18359479.18981,2545391.4,317166.69925800001,23177049.205068,13.507741623005721,126.8509410092536,17.586843885314099,2.1913962722867741,160.13692278986019]
[null,"PADD 3",{"$f":"SUM(C28:C32)","v":29},{"$f":"SUM(D28:D32)","v":0},24234426.175000001,496212.5,260829,24991467.675000001,0,167.44264547679964,3.4284753894593272,1.802142846778924,172.67326371303793]
[null,"PADD 4",{"$f":"SUM(C34:C36)","v":6},{"$f":"SUM(D34:D36)","v":985500},161704.12500000003,812545,0,1959749.125,6.8091039550840957,1.1172604739633822,5.6141079382889973,0,{"$f":"SUM(M34:M36)","v":13.540472367336475}]
[null,"PADD 5",{"$f":"SUM(C38:C41)","v":85},{"$f":"SUM(D38:D41)","v":931879.08},3659546.0660000001,6834411.4584327796,1743912.7709999999,13169749.37543278,6.4386215416419361,25.284860062722522,47.220921453360425,12.049196698465515,{"$f":"SUM(M38:M41)","v":90.993599756190406}]
[null,"US Total",{"$f":"SUM(C42:C46)","v":202},3872390.9960000003,52291898.805810004,11356706.847232779,2913208.4702580003,70434205.119300783,{"$f":"SUM(I42:I46)","v":26.755467119731755},361.29982240233204,78.466765611591427,20.128198190581671,486.65025332423687]
[]
[null,"Sources and Notes:"]
[null,"[1]: Summation by state of the facilities' capacities listed in the Energy Vision Renewable Natural Gas Project Database, https://energy-vision.org/rng-project-database/. This represents a conservative estimate, as there are facilities listed without publicly available capacities."]

{"sheet":"Propane Consumption Forecast","index":19,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Propane Consumption Forecast"]
[]
[null,"Fuel Type","Unit","Citation Reference","2021","2022","2023","2024"]
[null,"Propane","MM Gallons","[1]",{"$f":"'Propane EIA Data'!F$5*'Propane EIA Data'!$F$9","v":2.0130598633889916},{"$f":"'Propane EIA Data'!G$5*'Propane EIA Data'!$F$9","v":2.3442125681889121},{"$f":"'Propane EIA Data'!H$5*'Propane EIA Data'!$F$9","v":2.5307038282604468},{"$f":"'Propane EIA Data'!I$5*'Propane EIA Data'!$F$9","v":2.5986772781930618}]
[]
[null,"Sources and Notes:"]
[null,"[1]: 'Propane Consumption Forecast.' Using Washington's historical consumption BRG has allocated the projected propane consumption using the U.S. EIA AEO Pacific Consumption Forecast. Due to an identified data limitation BRG relied upon the average allocation to Washington from 2014 through 2019."]

{"sheet":"Propane Availability","index":20,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Propane Production Availability (2022)"]
[]
[null,"PADD","Production Volume"]
[null,null,"Natural Gas Field Plant Production","Refinery Production","Total "]
[null,null,"Thousand barrels/year","Thousand barrels/year","MM gal/year"]
[null,null,"[1]","[2]"]
[null,"East Coast (PADD 1)"]
[null,"East Coast",47,4667,{"$f":"(SUM(C9:D9)*Conversions!$D$5)/1000","v":197.988}]
[null,"Appalachia",82504,294,{"$f":"(SUM(C10:D10)*Conversions!$D$5)/1000","v":3477.5160000000001}]
[null,"Midwest (PADD 2)"]
[null,"IN, IL, and KY",24124,17488,{"$f":"(SUM(C12:D12)*Conversions!$D$5)/1000","v":1747.704}]
[null,"MN, WI, ND, SD",50862,3328,{"$f":"(SUM(C13:D13)*Conversions!$D$5)/1000","v":2275.98}]
[null,"OK, KS, MO",58178,5429,{"$f":"(SUM(C14:D14)*Conversions!$D$5)/1000","v":2671.4940000000001}]
[null,"Gulf Coast (PADD 3)"]
[null,"TX Inland",277527,3231,{"$f":"(SUM(C16:D16)*Conversions!$D$5)/1000","v":11791.835999999999}]
[null,"TX Gulf Coast",14152,27825,{"$f":"(SUM(C17:D17)*Conversions!$D$5)/1000","v":1763.0340000000001}]
[null,"LA Gulf Coast",20583,24032,{"$f":"(SUM(C18:D18)*Conversions!$D$5)/1000","v":1873.83}]
[null,"N. LA, AK",1708,142,{"$f":"(SUM(C19:D19)*Conversions!$D$5)/1000","v":77.7}]
[null,"NM",36093,358,{"$f":"(SUM(C20:D20)*Conversions!$D$5)/1000","v":1530.942}]
[null,"Rocky Mountains (PADD 4)",67943,2839,{"$f":"(SUM(C21:D21)*Conversions!$D$5)/1000","v":2972.8440000000001}]
[null,"West Coast (PADD 5)",2993,11692,{"$f":"(SUM(C22:D22)*Conversions!$D$5)/1000","v":616.77}]
[null,"PADD 1",{"$f":"SUM(C9:C10)","v":82551},{"$f":"SUM(D9:D10)","v":4961},{"$f":"SUM(E9:E10)","v":3675.5039999999999}]
[null,"PADD 2",{"$f":"SUM(C12:C14)","v":133164},{"$f":"SUM(D12:D14)","v":26245},{"$f":"SUM(E12:E14)","v":6695.1779999999999}]
[null,"PADD 3",{"$f":"SUM(C16:C20)","v":350063},{"$f":"SUM(D16:D20)","v":55588},{"$f":"SUM(E16:E20)","v":17037.342000000001}]
[null,"PADD 4",{"$f":"C21","v":67943},{"$f":"D21","v":2839},2972.8440000000001]
[null,"PADD 5",{"$f":"C22","v":2993},11692,616.77]
[null,"US",{"$f":"SUM(C8:C22)","v":636714},{"$f":"SUM(D8:D22)","v":101325},{"$f":"SUM(E8:E22)","v":30997.637999999999}]
[]
[null,"Sources and Notes"]
[null,"[1]: U.S. Energy Information Administration, Natural Gas Plant Field Production, accessed as of Sept. 2, 2022. https://www.eia.gov/dnav/pet/pet_pnp_gp_a_EPLLPA_FPF_mbbl_a.htm"]
[null,"[2]: U.S. Energy Information Administration, Refinery Net Production, accessed as of Sept. 2, 2022. https://www.eia.gov/dnav/pet/pet_pnp_refp2_a_EPLLPA_YPY_mbbl_a.htm"]

{"sheet":"Data Sources-->","index":21,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Gas & Diesel Forecast Data","index":22,"n_rows":22,"n_cols":21,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Transportation Revenue Forecast Council\nTable A. 1. Washington Motor Fuel Consumption Fiscal Year Forecast June 2022"]
[null,null,null,null,null,null,null,null,null,null,null,"Current\nBiennia"]
[null,null,null,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031]
[null,null,"Million Gallons"]
[null,null,"Gasoline (June 2022 Forecast)",2716,2757,2844,2887,2966,2905,2734,2494,2659,2719,2762,2795,2815,2834,2853,2871,2890,2909]
[null,null,"Annual Percentage Change",1.4999999999999999E-2,1.4999999999999999E-2,3.1E-2,1.4999999999999999E-2,2.8000000000000001E-2,-2.1000000000000001E-2,-5.8999999999999997E-2,-8.7999999999999995E-2,6.6000000000000003E-2,2.3E-2,1.6E-2,1.2E-2,7.0000000000000001E-3,7.0000000000000001E-3,7.0000000000000001E-3,6.0000000000000001E-3,7.0000000000000001E-3,6.0000000000000001E-3]
[null,null,"Gasoline (Feb. 2022 Forecast)",2716,2757,2844,2887,2966,2905,2734,2494,2659,2719,2762,2795,2815,2834,2853,2871,2890,2909]
[null,null,"Percentage Change,  June 2022  vs Feb. 2022",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Diesel (June 2022 Forecast)",656,663,676.2,675,678,689,710,726,777,782,791,803,816,829,841,854,860,866]
[null,null,"Annual Percentage Change",0.03,0.01,0.02,-2E-3,5.0000000000000001E-3,1.4999999999999999E-2,3.1E-2,2.1999999999999999E-2,7.0000000000000007E-2,7.0000000000000001E-3,1.0999999999999999E-2,1.6E-2,1.6E-2,1.6E-2,1.4999999999999999E-2,1.4999999999999999E-2,7.0000000000000001E-3,7.0000000000000001E-3]
[null,null,"Diesel (Feb. 2022 Forecast)",656,663,676.2,675,678,689,710,726,754,772,783,793,803,813,823,832,842,852]
[null,null,"Percentage Change,  June 2022  vs Feb. 2022",0,0,0,0,0,0,0,0,0.03,1.4E-2,0.01,1.2999999999999999E-2,1.6E-2,1.9E-2,2.1999999999999999E-2,2.5999999999999999E-2,2.1000000000000001E-2,1.6E-2]
[null,null,"Total Motor Fuel (June 2022 Forecast)",3373,3420,3520,3562,3645,3593,3444,3220,3435,3501,3552,3599,3631,3662,3694,3725,3750,3774]
[null,null,"Annual Percentage Change",1.7999999999999999E-2,1.4E-2,2.9000000000000001E-2,1.2E-2,2.3E-2,-1.4E-2,-4.2000000000000003E-2,-6.5000000000000002E-2,6.7000000000000004E-2,1.9E-2,1.4999999999999999E-2,1.2999999999999999E-2,8.9999999999999993E-3,8.9999999999999993E-3,8.9999999999999993E-3,8.0000000000000002E-3,7.0000000000000001E-3,6.0000000000000001E-3]
[null,null,"Total Motor Fuel (Feb. 2022 Forecast)",3373,3420,3520,3562,3645,3593,3444,3220,3413,3491,3545,3588,3618,3647,3676,3703,3732,3761]
[null,null,"Percentage Change,  June 2022  vs Feb. 2022",0,0,0,0,0,0,0,0,7.0000000000000001E-3,3.0000000000000001E-3,2E-3,3.0000000000000001E-3,4.0000000000000001E-3,4.0000000000000001E-3,5.0000000000000001E-3,6.0000000000000001E-3,5.0000000000000001E-3,4.0000000000000001E-3]
[]
[]
[]
[null,null,"Source:"]
[null,null,"Washington Office of Financial Management, June 2022 Transportation Revenue Forecasts, https://ofm.wa.gov/budget/budget-related-information/transportation-revenue-information"]

{"sheet":"Vehicle Stock Forecast","index":23,"n_rows":48,"n_cols":21,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Washington Vehicle Stock Forecast"]
[null,null,null,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031]
[null,"Vehicles paying Basic License Fee ($30)"]
[null,null,"Passenger Car and Cabs",4529669,4707553,4908456,5060804,5187649,5204763,5102400,5519519,5400000,5433159,5548000,5662873,5777753,5891612,5968428,6044049,6120658,6196997]
[null,null,"Motorhomes",65975,66913,68720,69000,68917,67618,64100,74078,71000,71160,71320,71486,71651,71812,71970,72124,72278,72430]
[null,null,"Travel Trailers",126313,132569,142484,149700,159651,162387,160400,194295,190000,190222,190999,192917,194895,196852,198869,200866,202923,204960]
[null,null,"Motorcycles",229822,236384,236134,231400,235531,232369,221400,245409,225000,226125,227256,228392,229534,230682,231835,232994,234159,235330]
[null,null,"Other Trailers",107205,102538,115059,129900,120791,122369,128000,137650,150000,150175,150244,150991,151763,152518,153297,154059,154846,155617]
[null,null,"Tow Trucks",1390,1351,1389,1400,1359,1330,1300,1385,1400,1393,1386,1379,1372,1365,1359,1352,1345,1338]
[null,null,null,5060374,5247308,5472242,5642204,5773898,5790836,5677600,6172336,6037400,6072234,6189204,6308038,6426968,6544841,6625757,6705444,6786210,6866673]
[null,"Vehicles paying Weight-based Registration Fee (Trucks)"]
[null,null,"Trucks",1459229,1489331,1539232,1578707,1599439,1605565,1605500,1753701,1733000,1784145,1828749,1865324,1893303,1911925,1931657,1948349,1964983,1981700]
[null,null,"For Hire, Buses, Stages",3225,3591,3760,4100,4434,4148,3500,3484,3800,4249,4673,5047,5350,5561,5790,5990,6195,6406]
[null,null,"Comb. Lic. Fee Trailers",67337,70728,76964,84300,94277,97838,95000,106411,110000,114328,118139,121290,123716,125338,127063,128527,129990,131464]
[null,null,"Prorate Motor Vehicles",27662,28233,29179,28600,30801,25347,25300,25659,29000,29856,30602,31214,31683,31994,32324,32604,32882,33162]
[null,null,null,1557453,1591883,1649135,1695707,1728951,1732898,1729300,1889255,1875800,1932578,1982164,2022875,2054052,2074818,2096834,2115469,2134050,2152732]
[null,"Vehicles paying varying fees"]
[null,null,"Restored and Antiques",9631,10771,10769,20700,29089,26524,25700,32776,34000,34170,34341,34513,34685,34859,35033,35208,35384,35561]
[null,null,"Campers",24177,23513,23358,22600,22118,20783,19100,21293,19200,18816,18440,18071,17709,17355,17008,16668,16335,16008]
[null,null,"Mopeds",9040,8978,8671,7800,7391,6818,6200,6637,5850,5792,5734,5676,5619,5563,5508,5453,5398,5344]
[null,null,"Exempt",6404,8258,8542,9000,8334,9104,7700,7040,7200,7500,7500,7500,7500,7500,7500,7500,7500,7500]
[null,null,null,49252,51520,51340,60100,66932,63200,58700,67746,66250,66278,66014,65760,65514,65277,65049,64829,64617,64413]
[]
[null,"Personal Trailers",null,440741,454511,449369,439300,458925,449177,432400,490483,432000,435055,438125,442355,453880,465631,477778,490118,502878,515836]
[null,"Intermittent-Use Trailers",null,"      -","-","-",100,575,1788,2300,2943,3600,4200,4890,5680,6470,7110,7700,8130,8410,8550]
[]
[null,"Total Highway Vehicles",null,6667081,6890713,7622088,7837500,8029283,8037930,7900400,8812236,8415050,8510345,8680396,8844707,9006884,9157678,9273118,9383990,9496164,9608204]
[]
[null,"Off Road Vehicles",null,82244,83606,84783,91400,97909,95935,102300,115900,114100,115660,115420,115420,115420,115420,115420,115420,115420,115420]
[null,null,"Wheeled All Tertain Vehicles",906,3875,21327,37400,51048,49647,55400,66430,68800,70490,70750,70750,70750,70750,70750,70750,70750,70750]
[]
[null,"Snowmobiles",null,24688,20201,25148,25200,23268,22753,22500,25100,23190,23420,23420,23490,23490,23490,23490,23490,23490,23490]
[null,null,"Vintage Snowmobiles",286,266,373,300,219,220,200,220,211,200,210,210,210,210,210,210,210,210]
[null,null,"Regular Snowmobiles",24402,19935,24775,24900,23049,22533,22400,24880,22979,23220,23210,23280,23280,23280,23280,23280,23280,23280]
[null,"Total Registrations",null,6774013,6994520,7732019,7954100,8150460,8156618,8025300,8953000,8552340,8649425,8819236,8983617,9145794,9296588,9412028,9522900,9635074,9747114]
[]
[null,"Vehicles subject to additional renewal fees"]
[null,null,"BEV ( Battery Electric Vehicles)",4976,8047,11737,14500,20867,22700,30500,43000,54471,72648,92434,114623,138103,161456,184549,207273,229872,252866]
[null,null,"PHEV (Plug-in Hybrid Vehciles)",1055,1647,2130,2300,3051,5000,6500,8000,8924,10363,11755,13063,14341,15550,16684,17744,18745,19712]
[null,null,"HV (Hybrid or Alt. Fuel Vehicles)",0,0,0,0,0,0,85200,141000,158526,161700,164930,168230,171590,175020,178520,182090,185730,189440]
[null,null,"EM (Electric Motorcycles)","-","-","-","-","-","-","-","-","-",153,344,516,619,743,892,1070,1284,1541]
[null,"Private Motorized Vehicles",null,6335643,6553105,6806310,7002600,7164610,7174482,7055500,7852000,7503050,7590048,7752060,7905903,8050951,8185373,8283903,8378122,8473283,8568269]
[]
[]
[]
[null,"Source:"]
[null,"Washington Office of Financial Management, June 2022 Transportation Revenue Forecasts, https://ofm.wa.gov/budget/budget-related-information/transportation-revenue-information"]

{"sheet":"CNG Vehicle Registrations","index":24,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Washington CNG Vehicle Use Analysis"]
[]
[null,null,"CNG Vehicles"]
[null,null,null,"Weighted Average Fuel Economy (MPGe)","[1]",22.869565217391305]
[null,null,null,"Average VMT per Vehicle in Washington (2019)","[2]",8811.82]
[null,null,null,"Washington Avg. Annual CNG Consumption/Vehicle (GGE)","[3]",385.30780347748686]
[null,null,null,"Total Number of CNG Vehicles","[4]",276]
[]
[null,null,"Sources:"]
[null,null,"[1]: BRG Calculation"]
[null,null,"[2] BRG analysis using Federal Highway Administration Data and Washington State Department of Licensing data. "]
[null,null,"[3]: BRG Calculation"]
[null,null,"[4] Washington Department of Licensing, Vehicle Registration Transactions Data, https://data.wa.gov/Transportation/Vehicle-Registration-Transactions-by-Department-of/brw6-jymh/data"]

{"sheet":"Washington EV Data","index":25,"n_rows":22,"n_cols":32,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Washington Electric Vehicle Use Analysis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weighted Average Fuel Economy (Kwh/100 miles)","Average Per Capita VMT in Washington (2017)","Washington Avg. Annual Electricity Consumption/BEV (Kwh)",null,"Weighted Average Fuel Economy (kWh/100 miles)","Weighted Average Fuel Economy (kWh/mile)","Weighted Average Electric Range (Miles)","Weighted Average Electric Range Used (Miles)","Estimated Electricity Use/Year/PHEV"]
[]
[null,null,"Battery Electric Vehicles (BEV)"]
[null,null,null,"Weighted Average Fuel Economy (Kwh/100 miles)","[1]",28.934527561812704]
[null,null,null,"Average VMT per Vehicle in Washington (2019)","[2]",8811.82]
[null,null,null,"Washington Avg. Annual Electricity Consumption (kWh/BEV)","[3]",2549.66]
[]
[]
[null,null,"Plug-in Hybrid Electric Vehicles (PHEV)"]
[null,null,null,"Weighted Average Fuel Economy (kWh/100 miles)","[4]",33.41911318080583]
[null,null,null,"Weighted Average Fuel Economy (kWh/mile)","[5]",0.33419113180805832]
[null,null,null,"Weighted Average Electric Range (Miles)","[6]",30.815043531079166]
[null,null,null,"Estimated VMT Using Electricity","[7]",{"$f":"MIN($F$6*0.9,F13*365)","v":7930.6379999999999}]
[null,null,null,"Estimated Electricity Use/Year/PHEV (kWh/PHEV)","[8]",{"$f":"(F14/100)*F11","v":2650.3488891799961}]
[]
[]
[null,null,"Sources and Notes:"]
[null,null,"[1]: BRG analysis based on Washington Electric Vehicle Population Data, https://data.wa.gov/Transportation/Electric-Vehicle-Population-Data/f6w7-q2d2"]
[null,null,"[2] BRG analysis using Federal Highway Administration Data and Washington State Department of Licensing data. "]
[null,null,"[3]-[6]: BRG analysis based on Washington Electric Vehicle Population Data, https://data.wa.gov/Transportation/Electric-Vehicle-Population-Data/f6w7-q2d2"]
[null,null,"[8]: BRG analysis based on Washington Electric Vehicle Population Data, https://data.wa.gov/Transportation/Electric-Vehicle-Population-Data/f6w7-q2d2"]

{"sheet":"Propane EIA Data","index":26,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Pacific Transportation Sector Propane Consumption Forecast"]
[null,null,"Fuel Type","Units","Source",2021,2022,2023,2024]
[null,null,"Propane","Quads","[1]",1.155E-3,1.3450000000000001E-3,1.4519999999999999E-3,1.4909999999999999E-3]
[null,null,"Propane","MM Gallons",null,{"$f":"((F4*(10^12))/'Fuel Energy Consumption'!$E$17)/1000000","v":12.886310387147162},{"$f":"((G4*(10^12)/'Fuel Energy Consumption'!$E$17)/1000000)","v":15.006136338279594},{"$f":"((H4*(10^12)/'Fuel Energy Consumption'!$E$17)/1000000)","v":16.199933058127861},{"$f":"((I4*(10^12)/'Fuel Energy Consumption'!$E$17)/1000000)","v":16.635055227044518}]
[]
[null,null,"Washington Allocation of Transportation Sector Propane Consumption in the Pacific Region"]
[null,null,"Fuel Type","Units","Source","2014-2019 Consumption Average"]
[null,null,"Propane","%","[2]",0.156216931216931]
[]
[]
[null,null,"Source: "]
[null,null,"[1]: U.S. Energy Information Administration, AEO 2022, https://www.eia.gov/outlooks/aeo/data/browser/#/?id=2-AEO2022&region=1-9&cases=ref2022&start=2020&end=2050&f=A&linechart=ref2022-d011222a.3-2-AEO2022.1-9&map=ref2022-d011222a.4-2-AEO2022.1-9&sourcekey=0https://www.eia.gov/outlooks/aeo/data/browser/#/?id=2-AEO2022&region=1-9&cases=ref2022&start=2020&end=2050&f=A&linechart=ref2022-d011222a.3-2-AEO2022.1-9&map=ref2022-d011222a.4-2-AEO2022.1-9&sourcekey=0"]
[null,null,"[3]: Washington consumption as a percentage of the Pacific Region's Propane Consumption, U.S. Energy Information Administration, Table CT7, Transportation Sector Energy Consumption Estimates, 1960-2020, Washington; https://www.eia.gov/state/seds/data.php?incfile=/state/seds/sep_use/tra/use_tra_WA.html&sid=WA "]

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

{"sheet":"Conversions","index":28,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Conversion","Source"]
[null,"Btu per 1 Scf of Natural Gas","[1]",1039]
[null,"Scf per 1 Cubic Meter of Natural Gas","[2]",35.335999999999999]
[null,"Gallons per Barrel","[3]",42]
[null,"Diesel Gallons Equivalent per 1 Scf of Natural Gas","[4]",139.30000000000001]
[]
[null,"Sources and Notes"]
[null,"[1]-[3]: U.S. EIA Energy Conversion Calculator, https://www.eia.gov/energyexplained/units-and-calculators/energy-conversion-calculators.php"]
[null,"[4]: Alternative Fuels Data Center, https://afdc.energy.gov/fuels/equivalency_methodology.html"]