| FGTP | title | status | original author | created |
|---|---|---|---|---|
0008 |
REC Purchase Order |
Proposed |
redransil |
2022-07-26 |
REC Purchase Order
Tool for determining how many new RECs to purchase in aggregate
redransil
Proposed
In order to buy RECs in aggregate from brokers, we need to determine how many to buy by geography and time period.
- Filecoin dashboard energy use API
- Renewables purchases repo to track RECs already under contract
- Synthetic location data from provider.quest (examples)
A csv order form with:
columns corresponding to quarters (ie. 2021-Q1) rows corresponding to regions. Generally these are country codes (ie. CN), for the US they are NERC regions (ie. US-MISO) values corresponding to amount of RECs to purchase, in MWh, rounded up to the nearest integer.
- Using the location file, find all the regions (ie countries and NERC regions) represented
- For every completed quarter in time since the network launched in Q2 2000:
- Step through regions
- For each region, step through all of the corresponding minerIDs
- For each minerID, find the upper bound of the energy used during this time period from the API.
- API with one-day resolution should be sufficient
- Multiply by 1.5 so that we over-buy RECs
- If the minerID has multiple locations, multiply by the fraction of those locations in this region. Example: if a minerID lists {CN, CN, JP} and we are calculating RECs for China, multiply by 2/3.
- Find all previous REC purchases for this minerID, region and quarter. Subtract them.
- If a REC purchase does not match with the quarter boundary, subtract only the fraction which is within this quarter.
- Sum over all minerIDs for this region and quarter. Round up to the nearest integer. This result is the number of RECs to buy for the corresesponding region and quarter.
- For the current quarter, calculate REC purchases for each region as the following:
- Find the energy use (MWh) for a given minerID in the region so far this quarter
- Determine the average power use (MW) over the quarter to date (ie. the 90 days ending at the current date). Multiply by the time remaining in the quarter (ie. if we are 2 months into the quarter, multiply by 1 additional month)
- Add the two numbers above; ie the sum of actual power use so far plus extrapolated power use
- Multiply by 1.5 and the fraction of minerID locations in this region, then subtract previous purchases. (All as above)
- Sum over all minerIDs in the region and round up
- Extrapolate for the upcoming quarter
- Calculate power (MW) as above, and multiply by the length of the upcoming quarter (approximately 90 days).
- Multiply by 1.5 and the fraction of minerID locations in this region, then subtract previous purchases. (All as above)