Spreadsheet: 734394d1622137561-need-to-sum-values-whose-date-range-covers-a-specific-date-book1
Sheet: Qorvo

 | Contract Terms |  |  |  |  | Fixed Price Block Transactions
 | Start Date | 2019-01-01 00:00:00 |  |  |  | Date | Block Size | Market Price | Target Fixed Price | Locked Fixed Price | Start Date | End Date
 | End Date | 2023-12-31 00:00:00 |  |  |  | 2016-11-28 00:00:00 | 5.5 |  |  | 26.5 | 2018-06-01 00:00:00 | 2019-12-31 00:00:00
 | REP | Calpine |  |  |  | 2017-12-19 00:00:00 | 3.5 |  |  | 28.83 | 2018-06-01 00:00:00 | 2018-12-31 00:00:00
 |  |  |  |  |  | 2018-05-30 00:00:00 | 2 |  |  | 45.76 | 2018-06-01 00:00:00 | 2019-12-31 00:00:00
 | Contact Info |  |  |  |  | 2019-04-16 00:00:00 | 3.5 |  |  | 34.94 | 2019-05-01 00:00:00 | 2020-12-31 00:00:00
 | EE Contact |  |  |  |  | 2020-03-06 00:00:00 | 5 |  |  | 34.49 | 2020-04-01 00:00:00 | 2021-09-30 00:00:00
 | Customer |  |  |  |  | 2020-03-06 00:00:00 | 1.5 |  |  | 34.49 | 2021-10-01 00:00:00 | 2022-03-31 00:00:00
 | Customer ph # |  |  |  |  | 2020-05-28 00:00:00 | 2 |  |  | 34.46 | 2020-07-01 00:00:00 | 2020-09-30 00:00:00
 | Customer email |  |  |  |  | 2020-05-28 00:00:00 | 1 |  |  | 34.46 | 2020-10-01 00:00:00 | 2020-12-31 00:00:00
 |  |  |  |  |  | 2020-05-28 00:00:00 | 2.5 |  |  | 34.46 | 2021-01-01 00:00:00 | 2021-12-01 00:00:00
 |  |  |  |  |  | 2020-05-28 00:00:00 | 1 |  |  | 34.46 | 2022-01-01 00:00:00 | 2022-06-30 00:00:00
 |  |  |  |  |  | 2020-09-03 00:00:00 | 1.5 |  |  | 32.02 | 2020-10-01 00:00:00 | 2022-09-30 00:00:00
 |  |  |  |  |  | 2020-11-17 00:00:00 | 1.5 |  |  | 30.53 | 2021-01-01 00:00:00 | 2022-12-31 00:00:00
 |  |  |  |  |  | 2021-03-29 00:00:00 | 2.5 |  |  | 34.13 | 2021-04-01 00:00:00 | 2021-09-30 00:00:00
 |  |  |  |  |  | 2021-03-29 00:00:00 | 1.5 |  |  | 34.13 | 2021-10-01 00:00:00 | 2023-03-31 00:00:00
 |  |  |  |  |  | 2021-05-18 00:00:00 | 2.5 |  |  | 35.78 | 2021-07-01 00:00:00 | 2021-09-30 00:00:00
 |  |  |  |  |  | 2021-05-18 00:00:00 | 1.5 |  |  | 35.78 | 2021-10-01 00:00:00 | 2023-06-30 00:00:00
 | Pricing Structure
 | 2019 Adder | 4.97 | $/MWh |  |  |  |  |  | CAL |  | Equivalent Fixed Price
 | 2020 Adder | 4.41 | $/MWh |  |  |  |  | 43831 | 2020
 | Est. TDSP | 10.33 | $/MWh |  |  |  |  | 44197 | 2021
 |  |  |  |  |  |  |  | 44562 | 2022
 |  |  |  |  |  |  |  | 44927 | 2023
 |  |  |  |  |  |  |  | 45292 | 2024
False |  | GRT Exempt |  | 0.017 |  |  |  | 45658 | 2025
False |  | Sales Tax Exempt |  | 0.0825
 |  |  |  |  |  |  |  |  | 8 | Avg. Equivalent Fixed Price ($/MWh) = |  |  |  |  |  |  | 0.1542108541654185 | 0.8149043458711179 | 0.0308847999634636
 | Status | Month | Projected Usage (MWh) | Locked Fixed Price Block (MWs) | Locked Fixed Price Block (MWh) | Locked Fixed Price Block Price |  | LMP North Zone | FLOOR Target Fixed Price | CEILING TARGET Fixed Price | Monthly Fixed Price ($/MWh) | Equivalent Fixed Price ($/MWh) | Monthly Energy Cost (including TDSP & Taxes) | Total Cost ($/MWh) |  |  | Farmers Branch Total | Richardson - Renner  Total | Richardson - Campbell  Total |  |  |  | Settled | Locked | Open | Average |  |  | Year |  |  |  |  | Projected Usage (MWh)
 |  |  | 8184 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8184
 |  |  | 7394 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7394
 |  |  | 8173 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8173
 |  |  | 7920 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7920
 |  |  | 8184 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8184
 |  |  | 7920 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7920
 |  |  | 8184 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8184
 |  |  | 8184 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8184
 |  |  | 7920 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7920
 |  |  | 8184 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8184
 |  |  | 7931 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7931
 |  |  | 8184 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8184
 |  |  | 9420 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9420
 |  |  | 8912 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8912
 |  |  | 8878 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8878
 |  |  | 9062 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9062
 |  |  | 10180 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10180
 |  |  | 10281 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10281
 |  |  | 10611 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10611
 |  |  | 10718 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10718
 |  |  | 10242 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10242
 |  |  | 9884 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9884
 |  |  | 9203 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9203
 |  |  | 9552 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9204
 |  |  | 9887 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9205
 |  |  | 8995 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9206
 |  |  | 10191 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9207
 |  |  | 10302 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9208
 |  |  | 11261 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9209
 |  |  | 11301 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9210
 |  |  | 12005 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9211
 |  |  | 12098 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9212
 |  |  | 11109 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9213
 |  |  | 10390 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9214
 |  |  | 9952 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9215
 |  |  | 10282 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9216
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9217
 |  |  | 8967 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9218
 |  |  | 10169 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9219
 |  |  | 10124 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9220
 |  |  | 11168 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9221
 |  |  | 11237 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9222
 |  |  | 11951 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9223
 |  |  | 12208 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9224
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9225
 |  |  | 10662 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9226
 |  |  | 9911 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9227
 |  |  | 10263 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9228
 |  |  | 9918 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9229
 |  |  | 8978 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9230
 |  |  | 10181 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9231
 |  |  | 10135 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9232
 |  |  | 11195 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9233
 |  |  | 11253 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9234
 |  |  | 11954 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9235
 |  |  | 12193 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9236
 |  |  | 11108 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9237
 |  |  | 10610 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9238
 |  |  | 9922 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9239
 |  |  | 10241 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9240
 | Annual Comparison of Monthly Costs (Including Projections*)
 | *Based on Current Market |  |  |  |  |  |  | Farmers Branch |  |  |  |  |  | Richardson - Renner |  |  |  |  |  | Richardson - Campbell
 |  | 2019 | 2020 | 2021 | 2022 | 2023
 | JAN |  |  |  |  |  |  | JAN |  |  |  |  |  | JAN |  |  |  |  |  | JAN
 | FEB |  |  |  |  |  |  | FEB |  |  |  |  |  | FEB |  |  |  |  |  | FEB
 | MAR |  |  |  |  |  |  | MAR |  |  |  |  |  | MAR |  |  |  |  |  | MAR
 | APR |  |  |  |  |  |  | APR |  |  |  |  |  | APR |  |  |  |  |  | APR
 | MAY |  |  |  |  |  |  | MAY |  |  |  |  |  | MAY |  |  |  |  |  | MAY
 | JUN |  |  |  |  |  |  | JUN |  |  |  |  |  | JUN |  |  |  |  |  | JUN
 | JUL |  |  |  |  |  |  | JUL |  |  |  |  |  | JUL |  |  |  |  |  | JUL
 | AUG |  |  |  |  |  |  | AUG |  |  |  |  |  | AUG |  |  |  |  |  | AUG
 | SEP |  |  |  |  |  |  | SEP |  |  |  |  |  | SEP |  |  |  |  |  | SEP
 | OCT |  |  |  |  |  |  | OCT |  |  |  |  |  | OCT |  |  |  |  |  | OCT
 | NOV |  |  |  |  |  |  | NOV |  |  |  |  |  | NOV |  |  |  |  |  | NOV
 | DEC |  |  |  |  |  |  | DEC |  |  |  |  |  | DEC |  |  |  |  |  | DEC