Systems and methods for supply chain data processing and flow modeling
View Patent ↗Implementations of a method of calculating a county-level consumption of natural gas may include providing county-level natural gas production data for a plurality of counties to a database from a data repository; removing from an analysis, using a processor, all areas of a first county of the plurality of counties that do not include a natural gas utility; and using the processor, the database, and the county-level natural gas production data, executing a regression with at least two geographical characteristics of the first county to determine a natural gas consumption within the first county. The method may also include using the processor, repeating for each county of the plurality of counties to determine the natural gas consumption for each of the plurality of counties.
1. A method of calculating flows of electricity into and out of a geographic area, the method comprising:
for a first time-step:
using a processor, attributing each node in a power transform distribution factor (PTDF) to a county of a plurality of counties;
using the processor, summing an electrical load and an electrical generation capacity for each node within each county of the plurality of counties (node-level electrical load and node-level electrical generation capacity) to form a county-level electrical load and county-level electrical generation for each county;
using the processor, for each county, dividing each county-level electrical load and county-level electrical generation by a corresponding node-level electrical load and node-level electrical generation capacity for each county to generate a load node-level distribution factor and a generation node-level distribution factor for each county;
using the processor, for each node, generating a node-level electrical injection value and a node-level electrical withdrawal value by multiplying the load node-level distribution factor by the county-level electrical load and by multiplying the generation node-level distribution factor by the county-level electrical generation, respectively;
using the processor, summing the node-level electrical injection value and the node-level electrical withdrawal value for each node to generate a total injection value and a total withdrawal value for each node;
using the processor, generate a vector of line flows by multiplying the total injection value and total withdrawal value for each node by a transpose of the PTDF; and
using the processor, summing the vector of line flows into each county of the plurality of counties and summing the vector of line flows out of each county of the plurality of counties to generate a county-to-county data set of electrical flows; and
repeating for a second time-step.
2. The method of claim 1 , wherein the first time-step and the second time-step are one month.
3. The method of claim 1 , further comprising, using the processor, downscaling the county-to-county data set of electrical flows to a substation-to-substation data set for a plurality of electrical substations comprised in each county of the plurality of counties.
4. The method of claim 3 , further comprising, using the processor, downscaling the substation-to-substation data set to a facility-level data set for a plurality of facilities comprised in each county of the plurality of counties.
5. The method of claim 1 , further comprising, using the processor, one of upscaling or downscaling the county-to-county dataset of electrical flows to calculate electrical flows associated with a selected geographic area within the plurality of counties.
6. A system for calculating flows of electricity into and out of a geographic area, the system comprising:
a processor configured to:
for a first time-step:
attribute each node in a power transform distribution factor (PTDF) to a county of a plurality of counties;
sum an electrical load and an electrical generation capacity for each node within each county of the plurality of counties (node-level electrical load and node-level electrical generation capacity) to form a county-level electrical load and county-level electrical generation for each county;
for each county, divide each county-level electrical load and county-level electrical generation by a corresponding node-level electrical load and node-level electrical generation capacity for each county to generate a load node-level distribution factor and a generation node-level distribution factor for each county;
for each node, generate a node-level electrical injection value and a node-level electrical withdrawal value by multiplying the load node-level distribution factor by the county-level electrical load and by multiplying the generation node-level distribution factor by the county-level electrical generation, respectively;
sum the node-level electrical injection value and the node-level electrical withdrawal value for each node to generate a total injection value and a total withdrawal value for each node;
generate a vector of line flows by multiplying the total injection value and total withdrawal value for each node by a transpose of the PTDF; and
sum the vector of line flows into each county of the plurality of counties and sum the vector of line flows out of each county of the plurality of counties to generate a county-to-county data set of electrical flows; and
repeat for a second time-step.
7. The system of claim 6 , wherein the first time-step and the second time-step are one month.
8. The system of claim 6 , further comprising wherein the processor is further configured to downscale the county-to-county data set of electrical flows to a substation-to-substation data set for a plurality of electrical substations comprised in each county of the plurality of counties.
9. The system of claim 8 , further comprising wherein the processor is further configured to downscale the substation-to-substation data set to a facility-level data set for a plurality of facilities comprised in each county of the plurality of counties.
10. The system of claim 6 , further comprising wherein the processor is configured to one of upscale or downscale the county-to-county dataset of electrical flows to calculate electrical flows associated with a selected geographic area within the plurality of counties.
11. A system for calculating flows of electricity into and out of a geographic area, the system comprising:
memory including machine-readable instructions; and
one or more processors configured, in response to executing the machine-readable instructions to perform operations comprising:
for a first time-step:
attribute each node in a power transform distribution factor (PTDF) to a county of a plurality of counties;
sum an electrical load and an electrical generation capacity for each node within each county of the plurality of counties (node-level electrical load and node-level electrical generation capacity) to form a county-level electrical load and county-level electrical generation for each county;
for each county, divide each county-level electrical load and county-level electrical generation by a corresponding node-level electrical load and node-level electrical generation capacity for each county to generate a load node-level distribution factor and a generation node-level distribution factor for each county;
for each node, generate a node-level electrical injection value and a node-level electrical withdrawal value by multiplying the load node-level distribution factor by the county-level electrical load and by multiplying the generation node-level distribution factor by the county-level electrical generation, respectively;
sum the node-level electrical injection value and the node-level electrical withdrawal value for each node to generate a total injection value and a total withdrawal value for each node;
generate a vector of line flows by multiplying the total injection value and total withdrawal value for each node by a transpose of the PTDF; and
sum the vector of line flows into each county of the plurality of counties and sum the vector of line flows out of each county of the plurality of counties to generate a county-to-county data set of electrical flows; and
repeat for a second time-step.
12. The system of claim 11 , wherein the first time-step and the second time-step are one month.
13. The system of claim 11 , further comprising wherein the one or more processors are further configured in response to executing the machine-readable instructions to downscale the county-to-county data set of electrical flows to a substation-to-substation data set for a plurality of electrical substations comprised in each county of the plurality of counties.
14. The system of claim 13 , further comprising wherein the one or more processors are further configured in response to executing the machine-readable instructions to downscale the substation-to-substation data set to a facility-level data set for a plurality of facilities comprised in each county of the plurality of counties.
15. The system of claim 11 , further comprising wherein the one or more processors are further configured in response to executing the machine-readable instructions to one of upscale or downscale the county-to-county dataset of electrical flows to calculate electrical flows associated with a selected geographic area within the plurality of counties.