A B C D E F H K L M
1
CFPE2021 Scenario Tool              
2   Instructions for use: Blue cells below are drop down menus. Select an electricity CI (Cell D6) and a EV growth rate (Cell D7) from those drop downs, and then in the Yellow Cell (Cell B11) input an initial population of EVs for 2019. You can also specify a rate of improvement for the CI of electricity from the dropdown in cell H6.
3   Electricity CI Options: The CI of the options here are defined below in the table with the green cells (Cells C20-D30).          
4   EV Growth Rate: The first four options are for a flat percent growth in the EV population from 2020 onward. The DAS Baseline option uses the growth rate that the DAS Office of Economic Analysis estimated in their most recent Fuel Supply Forecast.
5   The password for this sheet is CFP, we protected it to protect the formulas.            
6     Pick an Electricity CI: Single year statewide mix with Boardman and specified utility adjustment Annual electricity CI improvement rate: 0%      
7     Pick a EV Growth Rate: DAS Baseline       LDV EER 3.4  
8               Energy Density 3.6 kWh/MJ
9   Insert initial EV population in yellow cell              
10 Year Total EVs (BEVs + PHEVs) Electricity CI (gCO2e/MJ) Total Electricity (kWh) Total Credits Credits/EV     CFP Gasoline pool targets
11 2019 29,000 130.59 89,972,500 64,073 2.21   2019 96.59 gCO2e/MJ
12 2020 38,215 130.59 118,563,474 83,011 2.17   2020 95.61 2.50%
13 2021 46,960 130.59 145,694,562 100,259 2.13   2021 94.63 3.50%
14 2022 62,643 130.59 194,348,808 130,220 2.08   2022 93.15 5%
15 2023 80,457 130.59 249,617,508 162,760 2.02   2023 91.68 6.50%
16 2024 101,823 130.59 315,904,612 200,298 1.97   2024 90.21 8%
17 2025 126,963 130.59 393,903,344 240,303 1.89   2025 88.25 10%
18                    
19                    
20 Growth Rate Options 10% Electricity CI Description Electricity CI (gCO2e/MJ)   CI improvement rates        
21   15% Natural gas mix at 0.428mt per mwh 169.49   0%        
22   20% 2020 Electricity CI under current rules 107.92   0.50%        
23   25% Renewable power 0.00   1%        
24   DAS Baseline Single year (2018) Statewide mix with specified utility adjustment 135.77   1.50%        
25 2019 31.8% Single year (2018) statewide mix, Boardman at 0.428 104.02   2%        
26 2020 22.9% Single year statewide mix with Boardman and specified utility adjustment 130.59   2.50%        
27 2021 33.4% Single year (2018) BPA CI 3.54            
28 2022 28.4% Single year (2018) PGE CI 122.65            
29 2023 26.6% Single year (2018) PGE CI with Boardman adjustment 112.74            
30 2024 24.7% Single year (2018) PacifiCorp CI 207.63            
31 2025 22.8%                
32 2026 21.0%                
33 2027 19.2%                
34   See excel model posted here: https://www.oregon.gov/das/oea/pages/forecastcleanfuels.aspx          
35                    
36                    
37 Date published:                  
38 Date revised:                  

Utility credit calculator

  A B C D E F H I J
1 Year Total EVs = BEVs + PHEVs BPA CI in gCO2e/MJ Total Electricity Total Credits Credits per Car 2019 gasoline target 96.59 gCO2e/MJ
2 2002 1,000 10.23 3,102,500 3,554 3.55 LDV EER 3.4  
3 2003 1,000 12.64 3,102,500 3,527 3.53 Energy Density 3.6 kWh/MJ
4 2004 1,000 12.95 3,102,500 3,523 3.52      
5 2005 1,000 14.19 3,102,500 3,509 3.51      
6 2006 1,000 5.78 3,102,500 3,603 3.60      
7 2007 1,000 5.30 3,102,500 3,609 3.61      
8 2008 1,000 8.48 3,102,500 3,573 3.57      
9 2009 1,000 10.31 3,102,500 3,553 3.55      
10 2010 1,000 12.75 3,102,500 3,526 3.53      
11 2011 1,000 4.75 3,102,500 3,615 3.62      
12 2012 1,000 4.73 3,102,500 3,615 3.62      
13 2013 1,000 5.48 3,102,500 3,607 3.61      
14 2014 1,000 5.38 3,102,500 3,608 3.61      
15 2015 1,000 4.74 3,102,500 3,615 3.62      
16 2016 1,000 3.90 3,102,500 3,624 3.62      
17 2017 1,000 3.15 3,102,500 3,633 3.63      
18 2018 1,000 3.33 3,102,500 3,631 3.63      
19 2019 1,000 5.67 3,102,500 3,605 3.61      

BPA