Generated: 2026-07-30 10:27:48.431886, sddp2tpm version: 2.0.0, User: moorea
Output file: allocations.csv
| Allocation (%) | |
|---|---|
| Vector Ltd | 25.09% |
| Meridian Energy Ltd | 24.49% |
| Contact Energy Ltd | 11.90% |
| Mercury NZ Ltd | 8.16% |
| Genesis Energy Ltd | 7.22% |
| WEL Networks Ltd | 3.53% |
| Powerco Ltd | 2.58% |
| Manawa Energy Ltd | 2.26% |
| Northpower Ltd | 1.98% |
| Counties Power Ltd | 1.64% |
| Nga Awa Purua Joint Venture | 1.61% |
| MEL (West Wind) Ltd | 1.21% |
| Kawerau Geothermal Ltd | 1.16% |
| Waipa Networks Ltd | 1.08% |
| Ngatamariki Geothermal Ltd | 1.01% |
| Tararua Wind Power | 0.98% |
| MEL (Te Apiti) Ltd | 0.61% |
| Waverly Wind Farm Ltd | 0.57% |
| Mercury SPV Ltd | 0.42% |
| New Zealand Steel Ltd | 0.40% |
| The Lines Company Ltd | 0.32% |
| Oji Fibre Solutions (NZ) Ltd | 0.29% |
| Southern Generation Ltd | 0.29% |
| Unison Networks Ltd | 0.26% |
| Nova Energy Ltd | 0.21% |
| Top Energy Ltd | 0.19% |
| KiwiRail Holdings Ltd | 0.17% |
| Horizon Energy Distribution Ltd | 0.11% |
| Aurora Energy Ltd | 0.09% |
| Whareroa Cogeneration Ltd | 0.07% |
| Westpower Ltd | 0.07% |
| Alpine Energy Ltd | 0.03% |
| Southpark Utilities Ltd | 0.00% |
Output file: final_group_alloc.csv
| Allocation (%) | |
|---|---|
| WUNI_load_with_gen_Non-industrial | 36.81% |
| SI_run of river_storage_wind | 33.49% |
| RNI_run of river_storage | 13.44% |
| RNI_geo | 10.37% |
| RNI_wind | 5.09% |
| RNI_peaker | 0.51% |
| WUNI_Industrial | 0.18% |
| RNI_cogen | 0.11% |
Output file: region_supply_demand_alloc.csv
| Allocation (%) | ||
|---|---|---|
| WUNI | demand | 36.98% |
| SI | supply | 33.49% |
| RNI | supply | 29.53% |
According to the TPM1, benefits due to large steps in future generation
should not be included when determining starting allocations. Plants not already
committed are already excluded in the input plants.csv. However,
several existing wind farms are assumed to undergo repowering at set times
in the future. While it is reasonable to include future benefits due to the current
capacity of these plants, we should not include future increases to capacity of
these wind farms.
In SDDP wind farm repowering is handled by replacing the existing wind farm with a new plant with increased capacity. To exclude benefits do to increases in capacity, generator PVEMBD for repowered plants is multiplied by the ratio of the original capacity to the repowered capacity.
Output file: repower_adj.csv
| Capacity_MW | Replaces | orig_cap | adj_factor | |
|---|---|---|---|---|
| plant | ||||
| MillCree_Rpr | 88.0 | 100.0 | 60.00 | 0.681818 |
| TaraW1_Rpr | 70.0 | 101.0 | 34.32 | 0.490286 |
| TaraW2_Rpr | 70.0 | 102.0 | 33.66 | 0.480857 |
| TaraW3_Rpr | 104.0 | 103.0 | 93.00 | 0.894231 |
| TeApiti_Rpr | 185.0 | 104.0 | 90.80 | 0.490811 |
| TeReHau_Rpr | 170.0 | 105.0 | 46.00 | 0.270588 |
| TeUku_Rpr | 94.0 | 106.0 | 67.00 | 0.712766 |
| WestWind_Rpr | 208.0 | 107.0 | 142.60 | 0.685577 |
| Mahiner__Rpr | 40.0 | 108.0 | 36.00 | 0.900000 |
| WhiteHil_Rpr | 97.0 | 109.0 | 58.00 | 0.597938 |
| Waipipi_Rpr | 133.0 | 110.0 | 130.00 | 0.977444 |
| Turitea_Rpr | 222.0 | 111.0 | 221.40 | 0.997297 |
| Harapaki_Rpr | 176.0 | 112.0 | 176.30 | 1.001705 |
| KaiwDwns_Rpr | 43.0 | 113.0 | 43.00 | 1.000000 |
The table below indicates the AC and DC binding conditions for which load customer groups benefit from the investment via alleviated prices. The rules for these periods are described in paras. 353 - 356 of the Assumptions Book4.
| AC • DC ↑ | AC • DC ↓ | AC ↑ DC • | AC ↑ DC ↑ | AC ↑ DC ↓ | AC ↓ DC • | AC ↓ DC ↑ | AC ↓ DC ↓ | |
|---|---|---|---|---|---|---|---|---|
| Region | ||||||||
| WUNI | • | • | + | + | + | - | - | - |
| RNI | • | • | - | - | - | + | + | + |
| SI | • | • | - | • | - | + | + | • |
The following table shows the actual difference in the present value of time weighted average price between the factual and counterfactual during the periods of benefit defined above. Ideally the lowest values (the largest price decreases) should broadly correspond with green "+" cells in the table above. Similarly the largest price increases should correspond to red "-" cells above. The signs of the smaller values in the table below may not correspond to the load benefit periods above due to different hydro generation time series in the factual and counterfactual.
| AC•DC↑ | AC•DC↓ | AC↑DC• | AC↑DC↑ | AC↑DC↓ | AC↓DC• | AC↓DC↑ | AC↓DC↓ | |
|---|---|---|---|---|---|---|---|---|
| Region | ||||||||
| WUNI | 1.3 | 0.8 | -11.5 | -23.1 | -1.4 | 1.5 | 1.0 | 0.0 |
| RNI | 0.5 | -1.5 | 2.4 | 7.3 | 1.0 | 0.8 | 0.7 | 0.0 |
| SI | 0.5 | 2.7 | 1.6 | 0.7 | 0.8 | 0.7 | -0.1 | 0.3 |
According to the TPM1, benefits due to large steps in future demand should not be included when determining allocations.
At each bus with identified step loads we multiply load benefits by:
,
where PV indicates the present value of these loads summed over the BBI investment period.
Step loads for each market scenario are provided in the input file
../../sddp2tpm_data/data/BHL_PAK/step_loads.csv, and the total load
comes from the demxba SDDP output.
The step load adjustments below are applied to the bus_constraint_pv.csv and
bus_delta_pv.csv outputs from clause51 postprocessing.
Output file: step_load_adj.csv
| bus | ASB066 | BPE220 | BRB220 | BRY066 | CML110A | CPK110 | EDG220 | EDN110 | GLN220 | HAM220 | HKK066 | HLY220 | HOR066 | HWA110 | INV220 | ISL066 | KAW110 | KMO110 | KWA110 | MTM110 | MTN110A | NWD066 | OAM110A | TAB220 | TAK220A | TGA110 | TMI110 | TMK110 | TWH220 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| edgs_name | |||||||||||||||||||||||||||||
| constraint | 1.000000 | 1.158695 | 1.000000 | 0.828255 | 1.000000 | 1.0000 | 0.786636 | 1.000000 | 1.000000 | 1.128158 | 1.000000 | 0.626330 | 1.332097 | 0.518898 | 1.000000 | 1.077254 | 1.000000 | 1.230188 | 1.000000 | 1.306778 | 0.483891 | 0.608205 | 1.000000 | 0.725881 | 1.000000 | 0.912772 | 0.720837 | 1.000000 | 0.845974 |
| environmental | 1.000000 | 1.144733 | 1.000000 | 0.832693 | 0.804381 | 1.0000 | 0.801090 | 1.011502 | 1.151533 | 1.116641 | 1.000000 | 0.774229 | 1.296483 | 0.512857 | 1.000000 | 1.069556 | 1.000000 | 1.210870 | 1.000000 | 1.279549 | 0.580139 | 0.641210 | 0.896179 | 0.739570 | 0.699174 | 0.919269 | 0.803653 | 1.000000 | 0.909812 |
| growth | 1.000000 | 1.144159 | 1.000000 | 0.832940 | 0.806119 | 1.0000 | 0.801364 | 1.011242 | 1.143599 | 1.115912 | 1.000000 | 0.770984 | 1.287890 | 0.512489 | 1.000000 | 1.068874 | 1.000000 | 1.207460 | 1.000000 | 1.274398 | 0.573185 | 0.633527 | 0.897645 | 0.733037 | 0.695975 | 0.918899 | 0.799617 | 1.000000 | 0.918729 |
| innovation | 0.910702 | 1.146508 | 0.434219 | 0.859679 | 0.805627 | 0.9529 | 0.800502 | 1.011640 | 1.141498 | 1.098943 | 0.794075 | 0.770424 | 1.272947 | 0.514175 | 0.887269 | 1.059946 | 0.808155 | 1.215850 | 0.670748 | 1.260144 | 0.619533 | 0.634436 | 0.893700 | 0.737900 | 0.694263 | 0.932841 | 0.831223 | 0.853573 | 0.918972 |
| reference | 1.000000 | 1.151809 | 1.000000 | 0.824263 | 0.773799 | 1.0000 | 0.793522 | 1.011680 | 1.145337 | 1.122318 | 1.000000 | 0.763095 | 1.310465 | 0.508736 | 1.000000 | 1.073078 | 1.000000 | 1.217807 | 1.000000 | 1.291486 | 0.561795 | 0.621634 | 0.891046 | 0.729022 | 0.684737 | 0.915628 | 0.793559 | 1.000000 | 0.905053 |
Where there is more than one customer at a node, we attribute the load portion
of PVEMBD to each customer based on their offtake intra-regional allocator (IRA) as
a proportion of the total of all customers' offtake IRAs at that connection location.
Where some customers are non-distribution customer and others are electricity
distribution businesses (EDB), we assume that the load growth at that connection location is
wholly attributable to distributor customers, consistent with our demand forecasts
for non-distributor customers, which generally assume no load growth.
The following table shows the nodes with multiple customers that include both EDB and non EDB customers, and the reallocation of load growth to EDBs at these nodes.
For non-EDB customers:
For EDBs:
, where (ira_weight) is the customer's IRA offtake divided by the total offtake at that location,
and (edb_weight) is the EDB's offtake divided by the total EDB offtake at that location.
Nodes affected by this calculation are identified in the input ../../sddp2tpm_data/data/BHL_PAK/multi_cust_nodes.csv.
The IRA offtakes for each customer/location are from the input ../../sddp2tpm_data/data/BHL_PAK/ira.csv,
and the demand and its growth are determined from the annual demand (averaged over hydro scenarios and weighted over
market scenarios), which is in the clause51 output bus_annual.pv.
Because demand growth depends on the market scenario, load reallocation is also EDGS dependant.
The alloc column below scales the
bus_constraint_pv.csv and bus_annual_delta_pv.csv load_supplied data, after summing over the buses for each location.
Output file: load_reallocation.csv
| injection | offtake | load_type | offtake_loc | ira_weight | edb_offtake_loc | edb_weight | demand_growth_pv | demand_pv | alloc | |||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| edgs_name | cust_code | location | ||||||||||
| constraint | POCO | ARI | 0.000000e+00 | 7.537800e+03 | EDB | 7.537800e+03 | 1.000000 | 7.537800e+03 | 1.0 | 44.020812 | 2344.316949 | 1.000000 |
| environmental | POCO | ARI | 0.000000e+00 | 7.537800e+03 | EDB | 7.537800e+03 | 1.000000 | 7.537800e+03 | 1.0 | 278.271420 | 2589.263682 | 1.000000 |
| growth | POCO | ARI | 0.000000e+00 | 7.537800e+03 | EDB | 7.537800e+03 | 1.000000 | 7.537800e+03 | 1.0 | 291.639247 | 2609.300517 | 1.000000 |
| innovation | POCO | ARI | 0.000000e+00 | 7.537800e+03 | EDB | 7.537800e+03 | 1.000000 | 7.537800e+03 | 1.0 | 210.941436 | 2523.621496 | 1.000000 |
| reference | POCO | ARI | 0.000000e+00 | 7.537800e+03 | EDB | 7.537800e+03 | 1.000000 | 7.537800e+03 | 1.0 | 146.931141 | 2464.887608 | 1.000000 |
| constraint | MRPL | ARI | 5.688912e+08 | 0.000000e+00 | Generator | 7.537800e+03 | 0.000000 | 7.537800e+03 | 0.0 | 44.020812 | 2344.316949 | 0.000000 |
| environmental | MRPL | ARI | 5.688912e+08 | 0.000000e+00 | Generator | 7.537800e+03 | 0.000000 | 7.537800e+03 | 0.0 | 278.271420 | 2589.263682 | 0.000000 |
| growth | MRPL | ARI | 5.688912e+08 | 0.000000e+00 | Generator | 7.537800e+03 | 0.000000 | 7.537800e+03 | 0.0 | 291.639247 | 2609.300517 | 0.000000 |
| innovation | MRPL | ARI | 5.688912e+08 | 0.000000e+00 | Generator | 7.537800e+03 | 0.000000 | 7.537800e+03 | 0.0 | 210.941436 | 2523.621496 | 0.000000 |
| reference | MRPL | ARI | 5.688912e+08 | 0.000000e+00 | Generator | 7.537800e+03 | 0.000000 | 7.537800e+03 | 0.0 | 146.931141 | 2464.887608 | 0.000000 |
| constraint | POCO | BPE | 1.553954e+03 | 3.594438e+08 | EDB | 3.612948e+08 | 0.994877 | 3.594438e+08 | 1.0 | -820.605939 | 10591.195016 | 0.994480 |
| environmental | POCO | BPE | 1.553954e+03 | 3.594438e+08 | EDB | 3.612948e+08 | 0.994877 | 3.594438e+08 | 1.0 | 152.397369 | 11612.880184 | 0.994944 |
| growth | POCO | BPE | 1.553954e+03 | 3.594438e+08 | EDB | 3.612948e+08 | 0.994877 | 3.594438e+08 | 1.0 | 171.011919 | 11659.078515 | 0.994952 |
| innovation | POCO | BPE | 1.553954e+03 | 3.594438e+08 | EDB | 3.612948e+08 | 0.994877 | 3.594438e+08 | 1.0 | -100.733553 | 11472.120368 | 0.994832 |
| reference | POCO | BPE | 1.553954e+03 | 3.594438e+08 | EDB | 3.612948e+08 | 0.994877 | 3.594438e+08 | 1.0 | -409.907595 | 11071.524839 | 0.994687 |
| constraint | TRNZ | BPE | 9.792720e+02 | 1.850996e+06 | Industrial | 3.612948e+08 | 0.005123 | 3.594438e+08 | 0.0 | -820.605939 | 10591.195016 | 0.005520 |
| environmental | TRNZ | BPE | 9.792720e+02 | 1.850996e+06 | Industrial | 3.612948e+08 | 0.005123 | 3.594438e+08 | 0.0 | 152.397369 | 11612.880184 | 0.005056 |
| growth | TRNZ | BPE | 9.792720e+02 | 1.850996e+06 | Industrial | 3.612948e+08 | 0.005123 | 3.594438e+08 | 0.0 | 171.011919 | 11659.078515 | 0.005048 |
| innovation | TRNZ | BPE | 9.792720e+02 | 1.850996e+06 | Industrial | 3.612948e+08 | 0.005123 | 3.594438e+08 | 0.0 | -100.733553 | 11472.120368 | 0.005168 |
| reference | TRNZ | BPE | 9.792720e+02 | 1.850996e+06 | Industrial | 3.612948e+08 | 0.005123 | 3.594438e+08 | 0.0 | -409.907595 | 11071.524839 | 0.005313 |
| constraint | ORON | COL | 0.000000e+00 | 1.148770e+06 | EDB | 1.163134e+06 | 0.987650 | 1.148770e+06 | 1.0 | 10.374787 | 46.179556 | 0.990425 |
| environmental | ORON | COL | 0.000000e+00 | 1.148770e+06 | EDB | 1.163134e+06 | 0.987650 | 1.148770e+06 | 1.0 | 14.960485 | 50.678562 | 0.991296 |
| growth | ORON | COL | 0.000000e+00 | 1.148770e+06 | EDB | 1.163134e+06 | 0.987650 | 1.148770e+06 | 1.0 | 14.529391 | 50.714485 | 0.991189 |
| innovation | ORON | COL | 0.000000e+00 | 1.148770e+06 | EDB | 1.163134e+06 | 0.987650 | 1.148770e+06 | 1.0 | 13.872916 | 50.097340 | 0.991070 |
| reference | ORON | COL | 0.000000e+00 | 1.148770e+06 | EDB | 1.163134e+06 | 0.987650 | 1.148770e+06 | 1.0 | 12.727319 | 48.858351 | 0.990867 |
| constraint | TRUG | COL | 2.551766e+08 | 1.436420e+04 | Generator | 1.163134e+06 | 0.012350 | 1.148770e+06 | 0.0 | 10.374787 | 46.179556 | 0.009575 |
| environmental | TRUG | COL | 2.551766e+08 | 1.436420e+04 | Generator | 1.163134e+06 | 0.012350 | 1.148770e+06 | 0.0 | 14.960485 | 50.678562 | 0.008704 |
| growth | TRUG | COL | 2.551766e+08 | 1.436420e+04 | Generator | 1.163134e+06 | 0.012350 | 1.148770e+06 | 0.0 | 14.529391 | 50.714485 | 0.008811 |
| innovation | TRUG | COL | 2.551766e+08 | 1.436420e+04 | Generator | 1.163134e+06 | 0.012350 | 1.148770e+06 | 0.0 | 13.872916 | 50.097340 | 0.008930 |
| reference | TRUG | COL | 2.551766e+08 | 1.436420e+04 | Generator | 1.163134e+06 | 0.012350 | 1.148770e+06 | 0.0 | 12.727319 | 48.858351 | 0.009133 |
| constraint | COUP | GLN | 0.000000e+00 | 1.433014e+04 | EDB | 2.739075e+04 | 0.523174 | 1.433014e+04 | 1.0 | 463.198708 | 28454.959795 | 0.530936 |
| environmental | COUP | GLN | 0.000000e+00 | 1.433014e+04 | EDB | 2.739075e+04 | 0.523174 | 1.433014e+04 | 1.0 | -5353.168278 | 24783.022867 | 0.420179 |
| growth | COUP | GLN | 0.000000e+00 | 1.433014e+04 | EDB | 2.739075e+04 | 0.523174 | 1.433014e+04 | 1.0 | -5495.518058 | 26152.362801 | 0.422977 |
| innovation | COUP | GLN | 0.000000e+00 | 1.433014e+04 | EDB | 2.739075e+04 | 0.523174 | 1.433014e+04 | 1.0 | -5236.759951 | 26540.524543 | 0.429091 |
| reference | COUP | GLN | 0.000000e+00 | 1.433014e+04 | EDB | 2.739075e+04 | 0.523174 | 1.433014e+04 | 1.0 | -5800.092517 | 25839.593308 | 0.416144 |
| constraint | NZST | GLN | 9.569880e+04 | 1.306061e+04 | Industrial | 2.739075e+04 | 0.476826 | 1.433014e+04 | 0.0 | 463.198708 | 28454.959795 | 0.469064 |
| environmental | NZST | GLN | 9.569880e+04 | 1.306061e+04 | Industrial | 2.739075e+04 | 0.476826 | 1.433014e+04 | 0.0 | -5353.168278 | 24783.022867 | 0.579821 |
| growth | NZST | GLN | 9.569880e+04 | 1.306061e+04 | Industrial | 2.739075e+04 | 0.476826 | 1.433014e+04 | 0.0 | -5495.518058 | 26152.362801 | 0.577023 |
| innovation | NZST | GLN | 9.569880e+04 | 1.306061e+04 | Industrial | 2.739075e+04 | 0.476826 | 1.433014e+04 | 0.0 | -5236.759951 | 26540.524543 | 0.570909 |
| reference | NZST | GLN | 9.569880e+04 | 1.306061e+04 | Industrial | 2.739075e+04 | 0.476826 | 1.433014e+04 | 0.0 | -5800.092517 | 25839.593308 | 0.583856 |
| constraint | WELE | HAM | 0.000000e+00 | 7.422681e+04 | EDB | 7.433669e+04 | 0.998522 | 7.422681e+04 | 1.0 | 1295.340227 | 28928.486344 | 0.998588 |
| environmental | WELE | HAM | 0.000000e+00 | 7.422681e+04 | EDB | 7.433669e+04 | 0.998522 | 7.422681e+04 | 1.0 | 4556.975781 | 32004.888325 | 0.998732 |
| growth | WELE | HAM | 0.000000e+00 | 7.422681e+04 | EDB | 7.433669e+04 | 0.998522 | 7.422681e+04 | 1.0 | 4648.665692 | 32199.359640 | 0.998735 |
| innovation | WELE | HAM | 0.000000e+00 | 7.422681e+04 | EDB | 7.433669e+04 | 0.998522 | 7.422681e+04 | 1.0 | 6127.891635 | 36674.243119 | 0.998769 |
| reference | WELE | HAM | 0.000000e+00 | 7.422681e+04 | EDB | 7.433669e+04 | 0.998522 | 7.422681e+04 | 1.0 | 3059.497619 | 30566.754255 | 0.998670 |
| constraint | TRNZ | HAM | 1.668360e+04 | 1.098791e+02 | Industrial | 7.433669e+04 | 0.001478 | 7.422681e+04 | 0.0 | 1295.340227 | 28928.486344 | 0.001412 |
| environmental | TRNZ | HAM | 1.668360e+04 | 1.098791e+02 | Industrial | 7.433669e+04 | 0.001478 | 7.422681e+04 | 0.0 | 4556.975781 | 32004.888325 | 0.001268 |
| growth | TRNZ | HAM | 1.668360e+04 | 1.098791e+02 | Industrial | 7.433669e+04 | 0.001478 | 7.422681e+04 | 0.0 | 4648.665692 | 32199.359640 | 0.001265 |
| innovation | TRNZ | HAM | 1.668360e+04 | 1.098791e+02 | Industrial | 7.433669e+04 | 0.001478 | 7.422681e+04 | 0.0 | 6127.891635 | 36674.243119 | 0.001231 |
| reference | TRNZ | HAM | 1.668360e+04 | 1.098791e+02 | Industrial | 7.433669e+04 | 0.001478 | 7.422681e+04 | 0.0 | 3059.497619 | 30566.754255 | 0.001330 |
| constraint | POCO | HWA | 0.000000e+00 | 1.559637e+08 | EDB | 2.327066e+08 | 0.670216 | 1.559637e+08 | 1.0 | 2987.228107 | 22380.579756 | 0.714234 |
| environmental | POCO | HWA | 0.000000e+00 | 1.559637e+08 | EDB | 2.327066e+08 | 0.670216 | 1.559637e+08 | 1.0 | 2828.633266 | 22103.044368 | 0.712420 |
| growth | POCO | HWA | 0.000000e+00 | 1.559637e+08 | EDB | 2.327066e+08 | 0.670216 | 1.559637e+08 | 1.0 | 2801.847243 | 22086.368871 | 0.712052 |
| innovation | POCO | HWA | 0.000000e+00 | 1.559637e+08 | EDB | 2.327066e+08 | 0.670216 | 1.559637e+08 | 1.0 | 2881.416637 | 22162.997712 | 0.713091 |
| reference | POCO | HWA | 0.000000e+00 | 1.559637e+08 | EDB | 2.327066e+08 | 0.670216 | 1.559637e+08 | 1.0 | 2637.463188 | 21917.619606 | 0.709901 |
| constraint | TRUG | HWA | 1.044820e+08 | 6.537400e+03 | Generator | 2.327066e+08 | 0.000028 | 1.559637e+08 | 0.0 | 2987.228107 | 22380.579756 | 0.000024 |
| environmental | TRUG | HWA | 1.044820e+08 | 6.537400e+03 | Generator | 2.327066e+08 | 0.000028 | 1.559637e+08 | 0.0 | 2828.633266 | 22103.044368 | 0.000024 |
| growth | TRUG | HWA | 1.044820e+08 | 6.537400e+03 | Generator | 2.327066e+08 | 0.000028 | 1.559637e+08 | 0.0 | 2801.847243 | 22086.368871 | 0.000025 |
| innovation | TRUG | HWA | 1.044820e+08 | 6.537400e+03 | Generator | 2.327066e+08 | 0.000028 | 1.559637e+08 | 0.0 | 2881.416637 | 22162.997712 | 0.000024 |
| reference | TRUG | HWA | 1.044820e+08 | 6.537400e+03 | Generator | 2.327066e+08 | 0.000028 | 1.559637e+08 | 0.0 | 2637.463188 | 21917.619606 | 0.000025 |
| constraint | KIWI | HWA | 1.510132e+08 | 0.000000e+00 | Industrial | 2.327066e+08 | 0.000000 | 1.559637e+08 | 0.0 | 2987.228107 | 22380.579756 | 0.000000 |
| environmental | KIWI | HWA | 1.510132e+08 | 0.000000e+00 | Industrial | 2.327066e+08 | 0.000000 | 1.559637e+08 | 0.0 | 2828.633266 | 22103.044368 | 0.000000 |
| growth | KIWI | HWA | 1.510132e+08 | 0.000000e+00 | Industrial | 2.327066e+08 | 0.000000 | 1.559637e+08 | 0.0 | 2801.847243 | 22086.368871 | 0.000000 |
| innovation | KIWI | HWA | 1.510132e+08 | 0.000000e+00 | Industrial | 2.327066e+08 | 0.000000 | 1.559637e+08 | 0.0 | 2881.416637 | 22162.997712 | 0.000000 |
| reference | KIWI | HWA | 1.510132e+08 | 0.000000e+00 | Industrial | 2.327066e+08 | 0.000000 | 1.559637e+08 | 0.0 | 2637.463188 | 21917.619606 | 0.000000 |
| constraint | KUPE | HWA | 0.000000e+00 | 7.673639e+07 | Industrial | 2.327066e+08 | 0.329756 | 1.559637e+08 | 0.0 | 2987.228107 | 22380.579756 | 0.285742 |
| environmental | KUPE | HWA | 0.000000e+00 | 7.673639e+07 | Industrial | 2.327066e+08 | 0.329756 | 1.559637e+08 | 0.0 | 2828.633266 | 22103.044368 | 0.287555 |
| growth | KUPE | HWA | 0.000000e+00 | 7.673639e+07 | Industrial | 2.327066e+08 | 0.329756 | 1.559637e+08 | 0.0 | 2801.847243 | 22086.368871 | 0.287924 |
| innovation | KUPE | HWA | 0.000000e+00 | 7.673639e+07 | Industrial | 2.327066e+08 | 0.329756 | 1.559637e+08 | 0.0 | 2881.416637 | 22162.997712 | 0.286884 |
| reference | KUPE | HWA | 0.000000e+00 | 7.673639e+07 | Industrial | 2.327066e+08 | 0.329756 | 1.559637e+08 | 0.0 | 2637.463188 | 21917.619606 | 0.290075 |
| constraint | POCO | LTN | 3.497390e+06 | 1.612535e+08 | EDB | 1.617480e+08 | 0.996942 | 1.612535e+08 | 1.0 | 985.873239 | 10544.166208 | 0.997228 |
| environmental | POCO | LTN | 3.497390e+06 | 1.612535e+08 | EDB | 1.617480e+08 | 0.996942 | 1.612535e+08 | 1.0 | 1869.305845 | 11462.776207 | 0.997441 |
| growth | POCO | LTN | 3.497390e+06 | 1.612535e+08 | EDB | 1.617480e+08 | 0.996942 | 1.612535e+08 | 1.0 | 1814.680064 | 11430.747829 | 0.997428 |
| innovation | POCO | LTN | 3.497390e+06 | 1.612535e+08 | EDB | 1.617480e+08 | 0.996942 | 1.612535e+08 | 1.0 | 2067.344834 | 11659.013865 | 0.997485 |
| reference | POCO | LTN | 3.497390e+06 | 1.612535e+08 | EDB | 1.617480e+08 | 0.996942 | 1.612535e+08 | 1.0 | 1334.191498 | 10944.534564 | 0.997315 |
| constraint | MSVP | LTN | 1.761378e+08 | 4.945487e+05 | Generator | 1.617480e+08 | 0.003058 | 1.612535e+08 | 0.0 | 985.873239 | 10544.166208 | 0.002772 |
| environmental | MSVP | LTN | 1.761378e+08 | 4.945487e+05 | Generator | 1.617480e+08 | 0.003058 | 1.612535e+08 | 0.0 | 1869.305845 | 11462.776207 | 0.002559 |
| growth | MSVP | LTN | 1.761378e+08 | 4.945487e+05 | Generator | 1.617480e+08 | 0.003058 | 1.612535e+08 | 0.0 | 1814.680064 | 11430.747829 | 0.002572 |
| innovation | MSVP | LTN | 1.761378e+08 | 4.945487e+05 | Generator | 1.617480e+08 | 0.003058 | 1.612535e+08 | 0.0 | 2067.344834 | 11659.013865 | 0.002515 |
| reference | MSVP | LTN | 1.761378e+08 | 4.945487e+05 | Generator | 1.617480e+08 | 0.003058 | 1.612535e+08 | 0.0 | 1334.191498 | 10944.534564 | 0.002685 |
| constraint | VECT | PEN | 0.000000e+00 | 1.856115e+05 | EDB | 1.878533e+05 | 0.988066 | 1.856115e+05 | 1.0 | 1715.504150 | 51906.550448 | 0.988461 |
| environmental | VECT | PEN | 0.000000e+00 | 1.856115e+05 | EDB | 1.878533e+05 | 0.988066 | 1.856115e+05 | 1.0 | 13750.667163 | 66849.490363 | 0.990521 |
| growth | VECT | PEN | 0.000000e+00 | 1.856115e+05 | EDB | 1.878533e+05 | 0.988066 | 1.856115e+05 | 1.0 | 13475.051863 | 66713.965195 | 0.990477 |
| innovation | VECT | PEN | 0.000000e+00 | 1.856115e+05 | EDB | 1.878533e+05 | 0.988066 | 1.856115e+05 | 1.0 | 13522.962842 | 66635.517648 | 0.990488 |
| reference | VECT | PEN | 0.000000e+00 | 1.856115e+05 | EDB | 1.878533e+05 | 0.988066 | 1.856115e+05 | 1.0 | 10311.014147 | 63544.924489 | 0.990003 |
| constraint | SHPK | PEN | 0.000000e+00 | 3.422233e+01 | Industrial | 1.878533e+05 | 0.000182 | 1.856115e+05 | 0.0 | 1715.504150 | 51906.550448 | 0.000176 |
| environmental | SHPK | PEN | 0.000000e+00 | 3.422233e+01 | Industrial | 1.878533e+05 | 0.000182 | 1.856115e+05 | 0.0 | 13750.667163 | 66849.490363 | 0.000145 |
| growth | SHPK | PEN | 0.000000e+00 | 3.422233e+01 | Industrial | 1.878533e+05 | 0.000182 | 1.856115e+05 | 0.0 | 13475.051863 | 66713.965195 | 0.000145 |
| innovation | SHPK | PEN | 0.000000e+00 | 3.422233e+01 | Industrial | 1.878533e+05 | 0.000182 | 1.856115e+05 | 0.0 | 13522.962842 | 66635.517648 | 0.000145 |
| reference | SHPK | PEN | 0.000000e+00 | 3.422233e+01 | Industrial | 1.878533e+05 | 0.000182 | 1.856115e+05 | 0.0 | 10311.014147 | 63544.924489 | 0.000153 |
| constraint | TRNZ | PEN | 8.825460e+02 | 2.207589e+03 | Industrial | 1.878533e+05 | 0.011752 | 1.856115e+05 | 0.0 | 1715.504150 | 51906.550448 | 0.011363 |
| environmental | TRNZ | PEN | 8.825460e+02 | 2.207589e+03 | Industrial | 1.878533e+05 | 0.011752 | 1.856115e+05 | 0.0 | 13750.667163 | 66849.490363 | 0.009334 |
| growth | TRNZ | PEN | 8.825460e+02 | 2.207589e+03 | Industrial | 1.878533e+05 | 0.011752 | 1.856115e+05 | 0.0 | 13475.051863 | 66713.965195 | 0.009378 |
| innovation | TRNZ | PEN | 8.825460e+02 | 2.207589e+03 | Industrial | 1.878533e+05 | 0.011752 | 1.856115e+05 | 0.0 | 13522.962842 | 66635.517648 | 0.009367 |
| reference | TRNZ | PEN | 8.825460e+02 | 2.207589e+03 | Industrial | 1.878533e+05 | 0.011752 | 1.856115e+05 | 0.0 | 10311.014147 | 63544.924489 | 0.009845 |
| constraint | POCO | SFD | 0.000000e+00 | 1.284703e+08 | EDB | 1.321674e+08 | 0.972027 | 1.284703e+08 | 1.0 | 152.084099 | 3718.018410 | 0.973171 |
| environmental | POCO | SFD | 0.000000e+00 | 1.284703e+08 | EDB | 1.321674e+08 | 0.972027 | 1.284703e+08 | 1.0 | 473.667616 | 4055.921532 | 0.975294 |
| growth | POCO | SFD | 0.000000e+00 | 1.284703e+08 | EDB | 1.321674e+08 | 0.972027 | 1.284703e+08 | 1.0 | 443.649822 | 4033.063020 | 0.975104 |
| innovation | POCO | SFD | 0.000000e+00 | 1.284703e+08 | EDB | 1.321674e+08 | 0.972027 | 1.284703e+08 | 1.0 | 788.328818 | 4368.903098 | 0.977074 |
| reference | POCO | SFD | 0.000000e+00 | 1.284703e+08 | EDB | 1.321674e+08 | 0.972027 | 1.284703e+08 | 1.0 | 273.347973 | 3860.427258 | 0.974008 |
| constraint | CTCT | SFD | 9.982725e+08 | 3.697118e+06 | Generator | 1.321674e+08 | 0.027973 | 1.284703e+08 | 0.0 | 152.084099 | 3718.018410 | 0.026829 |
| environmental | CTCT | SFD | 9.982725e+08 | 3.697118e+06 | Generator | 1.321674e+08 | 0.027973 | 1.284703e+08 | 0.0 | 473.667616 | 4055.921532 | 0.024706 |
| growth | CTCT | SFD | 9.982725e+08 | 3.697118e+06 | Generator | 1.321674e+08 | 0.027973 | 1.284703e+08 | 0.0 | 443.649822 | 4033.063020 | 0.024896 |
| innovation | CTCT | SFD | 9.982725e+08 | 3.697118e+06 | Generator | 1.321674e+08 | 0.027973 | 1.284703e+08 | 0.0 | 788.328818 | 4368.903098 | 0.022926 |
| reference | CTCT | SFD | 9.982725e+08 | 3.697118e+06 | Generator | 1.321674e+08 | 0.027973 | 1.284703e+08 | 0.0 | 273.347973 | 3860.427258 | 0.025992 |
| constraint | ALPE | TKA | 0.000000e+00 | 2.009443e+07 | EDB | 2.019261e+07 | 0.995138 | 2.009443e+07 | 1.0 | 175.534916 | 870.878330 | 0.996118 |
| environmental | ALPE | TKA | 0.000000e+00 | 2.009443e+07 | EDB | 2.019261e+07 | 0.995138 | 2.009443e+07 | 1.0 | 272.131109 | 971.149718 | 0.996500 |
| growth | ALPE | TKA | 0.000000e+00 | 2.009443e+07 | EDB | 2.019261e+07 | 0.995138 | 2.009443e+07 | 1.0 | 271.456700 | 972.177946 | 0.996496 |
| innovation | ALPE | TKA | 0.000000e+00 | 2.009443e+07 | EDB | 2.019261e+07 | 0.995138 | 2.009443e+07 | 1.0 | 1369.148993 | 2092.809300 | 0.998319 |
| reference | ALPE | TKA | 0.000000e+00 | 2.009443e+07 | EDB | 2.019261e+07 | 0.995138 | 2.009443e+07 | 1.0 | 217.654530 | 917.854855 | 0.996291 |
| constraint | GENE | TKA | 1.439613e+08 | 9.817760e+04 | Generator | 2.019261e+07 | 0.004862 | 2.009443e+07 | 0.0 | 175.534916 | 870.878330 | 0.003882 |
| environmental | GENE | TKA | 1.439613e+08 | 9.817760e+04 | Generator | 2.019261e+07 | 0.004862 | 2.009443e+07 | 0.0 | 272.131109 | 971.149718 | 0.003500 |
| growth | GENE | TKA | 1.439613e+08 | 9.817760e+04 | Generator | 2.019261e+07 | 0.004862 | 2.009443e+07 | 0.0 | 271.456700 | 972.177946 | 0.003504 |
| innovation | GENE | TKA | 1.439613e+08 | 9.817760e+04 | Generator | 2.019261e+07 | 0.004862 | 2.009443e+07 | 0.0 | 1369.148993 | 2092.809300 | 0.001681 |
| reference | GENE | TKA | 1.439613e+08 | 9.817760e+04 | Generator | 2.019261e+07 | 0.004862 | 2.009443e+07 | 0.0 | 217.654530 | 917.854855 | 0.003709 |
| constraint | WTOM | TKU | 6.296116e+04 | 3.543444e+07 | EDB | 3.808261e+07 | 0.930462 | 3.543444e+07 | 1.0 | 133.766332 | 802.528283 | 0.942053 |
| environmental | WTOM | TKU | 6.296116e+04 | 3.543444e+07 | EDB | 3.808261e+07 | 0.930462 | 3.543444e+07 | 1.0 | 320.409617 | 1188.775450 | 0.949205 |
| growth | WTOM | TKU | 6.296116e+04 | 3.543444e+07 | EDB | 3.808261e+07 | 0.930462 | 3.543444e+07 | 1.0 | 312.463185 | 1181.964025 | 0.948845 |
| innovation | WTOM | TKU | 6.296116e+04 | 3.543444e+07 | EDB | 3.808261e+07 | 0.930462 | 3.543444e+07 | 1.0 | 297.262117 | 1164.745473 | 0.948210 |
| reference | WTOM | TKU | 6.296116e+04 | 3.543444e+07 | EDB | 3.808261e+07 | 0.930462 | 3.543444e+07 | 1.0 | 251.637860 | 1119.923612 | 0.946087 |
| constraint | GENE | TKU | 6.998804e+08 | 2.648171e+06 | Generator | 3.808261e+07 | 0.069538 | 3.543444e+07 | 0.0 | 133.766332 | 802.528283 | 0.057947 |
| environmental | GENE | TKU | 6.998804e+08 | 2.648171e+06 | Generator | 3.808261e+07 | 0.069538 | 3.543444e+07 | 0.0 | 320.409617 | 1188.775450 | 0.050795 |
| growth | GENE | TKU | 6.998804e+08 | 2.648171e+06 | Generator | 3.808261e+07 | 0.069538 | 3.543444e+07 | 0.0 | 312.463185 | 1181.964025 | 0.051155 |
| innovation | GENE | TKU | 6.998804e+08 | 2.648171e+06 | Generator | 3.808261e+07 | 0.069538 | 3.543444e+07 | 0.0 | 297.262117 | 1164.745473 | 0.051790 |
| reference | GENE | TKU | 6.998804e+08 | 2.648171e+06 | Generator | 3.808261e+07 | 0.069538 | 3.543444e+07 | 0.0 | 251.637860 | 1119.923612 | 0.053913 |
| constraint | EAST | TUI | 0.000000e+00 | 2.963624e+08 | EDB | 2.963631e+08 | 0.999998 | 2.963624e+08 | 1.0 | 790.404281 | 8286.140355 | 0.999998 |
| environmental | EAST | TUI | 0.000000e+00 | 2.963624e+08 | EDB | 2.963631e+08 | 0.999998 | 2.963624e+08 | 1.0 | 1589.466932 | 9262.723112 | 0.999998 |
| growth | EAST | TUI | 0.000000e+00 | 2.963624e+08 | EDB | 2.963631e+08 | 0.999998 | 2.963624e+08 | 1.0 | 1572.528379 | 9265.819594 | 0.999998 |
| innovation | EAST | TUI | 0.000000e+00 | 2.963624e+08 | EDB | 2.963631e+08 | 0.999998 | 2.963624e+08 | 1.0 | 1663.231104 | 10076.192780 | 0.999998 |
| reference | EAST | TUI | 0.000000e+00 | 2.963624e+08 | EDB | 2.963631e+08 | 0.999998 | 2.963624e+08 | 1.0 | 1120.907074 | 8809.101282 | 0.999998 |
| constraint | GENE | TUI | 4.614465e+08 | 7.160000e+02 | Generator | 2.963631e+08 | 0.000002 | 2.963624e+08 | 0.0 | 790.404281 | 8286.140355 | 0.000002 |
| environmental | GENE | TUI | 4.614465e+08 | 7.160000e+02 | Generator | 2.963631e+08 | 0.000002 | 2.963624e+08 | 0.0 | 1589.466932 | 9262.723112 | 0.000002 |
| growth | GENE | TUI | 4.614465e+08 | 7.160000e+02 | Generator | 2.963631e+08 | 0.000002 | 2.963624e+08 | 0.0 | 1572.528379 | 9265.819594 | 0.000002 |
| innovation | GENE | TUI | 4.614465e+08 | 7.160000e+02 | Generator | 2.963631e+08 | 0.000002 | 2.963624e+08 | 0.0 | 1663.231104 | 10076.192780 | 0.000002 |
| reference | GENE | TUI | 4.614465e+08 | 7.160000e+02 | Generator | 2.963631e+08 | 0.000002 | 2.963624e+08 | 0.0 | 1120.907074 | 8809.101282 | 0.000002 |
| constraint | SCAN | WDV | 0.000000e+00 | 1.317270e+07 | EDB | 1.383992e+07 | 0.951790 | 1.317270e+07 | 1.0 | 16.479383 | 402.934786 | 0.953762 |
| environmental | SCAN | WDV | 0.000000e+00 | 1.317270e+07 | EDB | 1.383992e+07 | 0.951790 | 1.317270e+07 | 1.0 | 52.202612 | 439.940496 | 0.957511 |
| growth | SCAN | WDV | 0.000000e+00 | 1.317270e+07 | EDB | 1.383992e+07 | 0.951790 | 1.317270e+07 | 1.0 | 50.322900 | 438.715437 | 0.957320 |
| innovation | SCAN | WDV | 0.000000e+00 | 1.317270e+07 | EDB | 1.383992e+07 | 0.951790 | 1.317270e+07 | 1.0 | 62.090563 | 458.128887 | 0.958324 |
| reference | SCAN | WDV | 0.000000e+00 | 1.317270e+07 | EDB | 1.383992e+07 | 0.951790 | 1.317270e+07 | 1.0 | 30.074699 | 419.475962 | 0.955247 |
| constraint | MELT | WDV | 2.520301e+08 | 6.672206e+05 | Generator | 1.383992e+07 | 0.048210 | 1.317270e+07 | 0.0 | 16.479383 | 402.934786 | 0.046238 |
| environmental | MELT | WDV | 2.520301e+08 | 6.672206e+05 | Generator | 1.383992e+07 | 0.048210 | 1.317270e+07 | 0.0 | 52.202612 | 439.940496 | 0.042489 |
| growth | MELT | WDV | 2.520301e+08 | 6.672206e+05 | Generator | 1.383992e+07 | 0.048210 | 1.317270e+07 | 0.0 | 50.322900 | 438.715437 | 0.042680 |
| innovation | MELT | WDV | 2.520301e+08 | 6.672206e+05 | Generator | 1.383992e+07 | 0.048210 | 1.317270e+07 | 0.0 | 62.090563 | 458.128887 | 0.041676 |
| reference | MELT | WDV | 2.520301e+08 | 6.672206e+05 | Generator | 1.383992e+07 | 0.048210 | 1.317270e+07 | 0.0 | 30.074699 | 419.475962 | 0.044753 |
| constraint | POCO | WVY | 0.000000e+00 | 2.235968e+07 | EDB | 2.280212e+07 | 0.980596 | 2.235968e+07 | 1.0 | 111.696567 | 840.411338 | 0.983175 |
| environmental | POCO | WVY | 0.000000e+00 | 2.235968e+07 | EDB | 2.280212e+07 | 0.980596 | 2.235968e+07 | 1.0 | 178.932238 | 910.052097 | 0.984411 |
| growth | POCO | WVY | 0.000000e+00 | 2.235968e+07 | EDB | 2.280212e+07 | 0.980596 | 2.235968e+07 | 1.0 | 169.697847 | 901.918724 | 0.984247 |
| innovation | POCO | WVY | 0.000000e+00 | 2.235968e+07 | EDB | 2.280212e+07 | 0.980596 | 2.235968e+07 | 1.0 | 161.811803 | 893.565565 | 0.984110 |
| reference | POCO | WVY | 0.000000e+00 | 2.235968e+07 | EDB | 2.280212e+07 | 0.980596 | 2.235968e+07 | 1.0 | 136.564457 | 868.413804 | 0.983648 |
| constraint | WAV1 | WVY | 2.356570e+08 | 4.424450e+05 | Generator | 2.280212e+07 | 0.019404 | 2.235968e+07 | 0.0 | 111.696567 | 840.411338 | 0.016825 |
| environmental | WAV1 | WVY | 2.356570e+08 | 4.424450e+05 | Generator | 2.280212e+07 | 0.019404 | 2.235968e+07 | 0.0 | 178.932238 | 910.052097 | 0.015589 |
| growth | WAV1 | WVY | 2.356570e+08 | 4.424450e+05 | Generator | 2.280212e+07 | 0.019404 | 2.235968e+07 | 0.0 | 169.697847 | 901.918724 | 0.015753 |
| innovation | WAV1 | WVY | 2.356570e+08 | 4.424450e+05 | Generator | 2.280212e+07 | 0.019404 | 2.235968e+07 | 0.0 | 161.811803 | 893.565565 | 0.015890 |
| reference | WAV1 | WVY | 2.356570e+08 | 4.424450e+05 | Generator | 2.280212e+07 | 0.019404 | 2.235968e+07 | 0.0 | 136.564457 | 868.413804 | 0.016352 |
This topic is covered by Clause 50 of the TPM.
Regional customer groups (RCG) are obtained by:
seperating the customer connections into the modelled regions. The modelled regions are groups of substations that are seperated by transmission constraints being alleviated by the grid investment and the HVDC link.
classifying the customer connections in these regions as "supply" or "demand" depending on the absolute value of the generation and load PVEMBDs for that customer connection
Separating the demand and supply customer connections into the regional customer groups based on the type of load or generation. This supports the goal of providing customer allocations that are broadly proportionate to positive net private benefit (NPB)3. With this in mind we create "load_with_gen" and "gen_with_load" RCGs for customer connections that have comparable load and generation benefits2.
Output file: all_groups.csv
| prov_group | npb |
|---|---|
| WUNI_Non-industrial | 7030.5448 |
| SI_storage | 6489.4251 |
| RNI_geo | 2013.7543 |
| RNI_storage | 1503.6977 |
| RNI_run of river | 1107.9542 |
| RNI_wind | 989.3634 |
| WUNI_load_with_gen | 118.9362 |
| RNI_peaker | 99.3858 |
| SI_wind | 47.4330 |
| WUNI_Industrial | 34.2080 |
| RNI_cogen | 21.5762 |
| SI_run of river | 16.1019 |
| SI_solar | 13.6642 |
| RNI_solar | 8.3478 |
| RNI_battery | 0.0324 |
| SI_battery | 0.0173 |
| SI_peaker | 0.0043 |
| WUNI_peaker | -0.0088 |
| WUNI_battery | -0.1517 |
| RNI_load_with_gen | -34.6832 |
| SI_load_with_gen | -54.2592 |
| RNI_Industrial | -181.4484 |
| WUNI_commit | -306.6582 |
| WUNI_storage | -658.0908 |
| SI_Industrial | -1416.6882 |
| SI_Non-industrial | -4107.2319 |
| RNI_Non-industrial | -4323.3675 |
Clause 47 of the TPM states that to be considered a beneficiary (and hence have a cost allocation) for a BBI, they must belong to a RCG that has positive PVEMBD (NPB).
The following table shows the customers and locations that belong to the benefitting RCGs abvove.
The output file customers.csv shows the corresponding table for all
customer locations before filtering to beneficiaries.
The load_benefit column is obtained from the step-load adjusted consumer PVEMBD by
applying the load reallocations above
where applicable, and the IRA offtake ratio elsewhere to
the PV of load supplied for the different periods of binding
constraints and the change in load supplied (F - CF), all combined using the input
load_benefit_periods.csv, as per the
"Calculate EMBD for each market scenario - clause 51" section of the Assumptions
Book4.
taking the weighted sum of EDGS scenarios.
See the output file: big_load_table.csv for these intermediate values.
The gen_benefit column is obtained by
applying the wind repowering adjustments
to the
the PV of generated energy for the different periods of binding
constraints and the change in energy generated (F - CF), all combined using the input
load_benefit_periods.csv, as per the
"Calculate EMBD for each market scenario - clause 51" section of the Assumptions
Book4.
taking the weighted sum of EDGS scenarios.
See the output file: custloc_gen.csv for these intermediate values.
Output file: bens.csv
| load_benefit | gen_benefit | pvembd | prov_group | ira | final_group | npb | ||
|---|---|---|---|---|---|---|---|---|
| COUP | BOB | 249 | 0 | 249 | WUNI_Non-industrial | 39443 | WUNI_load_with_gen_Non-industrial | 233 |
| GLN | 154 | 0 | 154 | WUNI_Non-industrial | 14330 | WUNI_load_with_gen_Non-industrial | 85 | |
| NPOW | BRB | 47 | 0 | 47 | WUNI_Non-industrial | 6077 | WUNI_load_with_gen_Non-industrial | 36 |
| MPE | 274 | 0 | 274 | WUNI_Non-industrial | 49715 | WUNI_load_with_gen_Non-industrial | 294 | |
| MTO | 43 | 0 | 43 | WUNI_Non-industrial | 9031 | WUNI_load_with_gen_Non-industrial | 53 | |
| POCO | ARI | 35 | 0 | 35 | WUNI_Non-industrial | 7538 | WUNI_load_with_gen_Non-industrial | 45 |
| HIN | 58 | 0 | 58 | WUNI_Non-industrial | 15638 | WUNI_load_with_gen_Non-industrial | 93 | |
| KPU | 110 | 0 | 110 | WUNI_Non-industrial | 20572 | WUNI_load_with_gen_Non-industrial | 122 | |
| PAO | 100 | 0 | 100 | WUNI_Non-industrial | 14815 | WUNI_load_with_gen_Non-industrial | 88 | |
| WHU | 87 | 0 | 87 | WUNI_Non-industrial | 10073 | WUNI_load_with_gen_Non-industrial | 60 | |
| WKO | 104 | 0 | 104 | WUNI_Non-industrial | 15897 | WUNI_load_with_gen_Non-industrial | 94 | |
| VECT | ALB | 521 | 0 | 521 | WUNI_Non-industrial | 99173 | WUNI_load_with_gen_Non-industrial | 587 |
| HEN | 420 | 0 | 420 | WUNI_Non-industrial | 55603 | WUNI_load_with_gen_Non-industrial | 329 | |
| HEP | 312 | 0 | 312 | WUNI_Non-industrial | 63046 | WUNI_load_with_gen_Non-industrial | 373 | |
| HOB | 231 | 0 | 231 | WUNI_Non-industrial | 18843 | WUNI_load_with_gen_Non-industrial | 112 | |
| MNG | 280 | 0 | 280 | WUNI_Non-industrial | 52140 | WUNI_load_with_gen_Non-industrial | 309 | |
| OTA | 146 | 0 | 146 | WUNI_Non-industrial | 26033 | WUNI_load_with_gen_Non-industrial | 154 | |
| PAK | 313 | 0 | 313 | WUNI_Non-industrial | 64582 | WUNI_load_with_gen_Non-industrial | 382 | |
| PEN | 910 | 0 | 910 | WUNI_Non-industrial | 185611 | WUNI_load_with_gen_Non-industrial | 1099 | |
| ROS | 371 | 0 | 371 | WUNI_Non-industrial | 72912 | WUNI_load_with_gen_Non-industrial | 432 | |
| SVL | 259 | 0 | 259 | WUNI_Non-industrial | 42382 | WUNI_load_with_gen_Non-industrial | 251 | |
| TAK | 319 | 0 | 319 | WUNI_Non-industrial | 54348 | WUNI_load_with_gen_Non-industrial | 322 | |
| WEL | 85 | 0 | 85 | WUNI_Non-industrial | 16946 | WUNI_load_with_gen_Non-industrial | 100 | |
| WIR | 210 | 0 | 210 | WUNI_Non-industrial | 39723 | WUNI_load_with_gen_Non-industrial | 235 | |
| WRD | 154 | 0 | 154 | WUNI_Non-industrial | 31992 | WUNI_load_with_gen_Non-industrial | 189 | |
| WAIP | CBG | 89 | 0 | 89 | WUNI_Non-industrial | 18991 | WUNI_load_with_gen_Non-industrial | 112 |
| TMU | 133 | 0 | 133 | WUNI_Non-industrial | 16459 | WUNI_load_with_gen_Non-industrial | 97 | |
| WELE | HAM | 510 | 0 | 510 | WUNI_Non-industrial | 74227 | WUNI_load_with_gen_Non-industrial | 439 |
| HLY | 101 | 0 | 101 | WUNI_Non-industrial | 11768 | WUNI_load_with_gen_Non-industrial | 70 | |
| TWH | 382 | -56 | 329 | WUNI_Non-industrial | 29962 | WUNI_load_with_gen_Non-industrial | 177 | |
| WTOM | HTI | 78 | 0 | 78 | WUNI_Non-industrial | 10580 | WUNI_load_with_gen_Non-industrial | 63 |
| ALPE | ABY | -7 | 0 | -7 | SI_storage | 16306434 | SI_run of river_storage_wind | 6 |
| CTCT | CYD | -0 | 791 | 791 | SI_storage | 2149593028 | SI_run of river_storage_wind | 788 |
| ROX | 0 | 547 | 547 | SI_storage | 1739041822 | SI_run of river_storage_wind | 637 | |
| DUNE | CYD | -11 | 0 | -11 | SI_storage | 48805482 | SI_run of river_storage_wind | 18 |
| GENE | TKA | -0 | 56 | 56 | SI_storage | 143961298 | SI_run of river_storage_wind | 53 |
| TKB | 0 | 313 | 313 | SI_storage | 926286862 | SI_run of river_storage_wind | 339 | |
| MERI | AVI | 0 | 407 | 407 | SI_storage | 1043973136 | SI_run of river_storage_wind | 383 |
| BEN | 0 | 1040 | 1040 | SI_storage | 2575992260 | SI_run of river_storage_wind | 944 | |
| MAN | 0 | 1694 | 1694 | SI_storage | 4777265055 | SI_run of river_storage_wind | 1751 | |
| OHA | 0 | 497 | 497 | SI_storage | 1247320925 | SI_run of river_storage_wind | 457 | |
| OHB | 0 | 429 | 429 | SI_storage | 1054260616 | SI_run of river_storage_wind | 386 | |
| OHC | 0 | 429 | 429 | SI_storage | 1046933462 | SI_run of river_storage_wind | 384 | |
| WTK | 0 | 186 | 186 | SI_storage | 540768368 | SI_run of river_storage_wind | 198 | |
| TRUG | BWK | 0 | 41 | 41 | SI_storage | 111405494 | SI_run of river_storage_wind | 41 |
| COL | -0 | 78 | 78 | SI_storage | 255176551 | SI_run of river_storage_wind | 94 | |
| WPOW | KUM | -1 | 0 | -1 | SI_storage | 35087441 | SI_run of river_storage_wind | 13 |
| CHHE | KAW | -81 | 130 | 49 | RNI_geo | 209222988 | RNI_geo | 56 |
| CTCT | OKI | 0 | 93 | 93 | RNI_geo | 321084023 | RNI_geo | 86 |
| PPI | 0 | 74 | 74 | RNI_geo | 336920837 | RNI_geo | 90 | |
| THI | 0 | 386 | 386 | RNI_geo | 1362230465 | RNI_geo | 365 | |
| WRK | -0 | 43 | 43 | RNI_geo | 1036158582 | RNI_geo | 278 | |
| HRZE | KAW | -9 | 63 | 53 | RNI_geo | 81101539 | RNI_geo | 22 |
| KWGL | KAW | -0 | 253 | 253 | RNI_geo | 838855981 | RNI_geo | 225 |
| MRPL | WKM | -20 | 508 | 488 | RNI_geo | 1233069896 | RNI_geo | 331 |
| NAPA | NAP | 0 | 314 | 314 | RNI_geo | 1169573949 | RNI_geo | 314 |
| NTRG | NAP | 0 | 200 | 200 | RNI_geo | 730422645 | RNI_geo | 196 |
| UNIS | WRK | -64 | 127 | 63 | RNI_geo | 190498948 | RNI_geo | 51 |
| GENE | TUI | -0 | 238 | 238 | RNI_storage | 461446547 | RNI_run of river_storage | 271 |
| MRPL | ARA | 0 | 211 | 211 | RNI_storage | 343492299 | RNI_run of river_storage | 202 |
| ATI | 0 | 185 | 185 | RNI_storage | 280243248 | RNI_run of river_storage | 165 | |
| MTI | 0 | 512 | 512 | RNI_storage | 880621954 | RNI_run of river_storage | 517 | |
| OHK | 0 | 250 | 250 | RNI_storage | 401851179 | RNI_run of river_storage | 236 | |
| WPA | 0 | 108 | 108 | RNI_storage | 231587144 | RNI_run of river_storage | 136 | |
| GENE | RPO | 0 | 266 | 266 | RNI_run of river | 560741283 | RNI_run of river_storage | 329 |
| TKU | -1 | 494 | 493 | RNI_run of river | 699880380 | RNI_run of river_storage | 411 | |
| SOU2 | MAT | -6 | 59 | 52 | RNI_run of river | 94556377 | RNI_run of river_storage | 56 |
| TRUG | HWA | -0 | 68 | 68 | RNI_run of river | 104481989 | RNI_run of river_storage | 61 |
| MAT | 0 | 172 | 172 | RNI_run of river | 285273036 | RNI_run of river_storage | 167 | |
| ROT | 0 | 57 | 57 | RNI_run of river | 104657799 | RNI_run of river_storage | 61 | |
| MELT | WDV | -0 | 92 | 92 | RNI_wind | 252030144 | RNI_wind | 118 |
| MELW | WWD | 0 | 196 | 196 | RNI_wind | 499573780 | RNI_wind | 234 |
| MERI | HRP | 0 | 185 | 185 | RNI_wind | 542000000 | RNI_wind | 254 |
| MSVP | LTN | -0 | 223 | 223 | RNI_wind | 176137813 | RNI_wind | 83 |
| TARW | TWC | 0 | 140 | 140 | RNI_wind | 405468001 | RNI_wind | 190 |
| WAV1 | WVY | -0 | 153 | 153 | RNI_wind | 235657024 | RNI_wind | 110 |
| NZST | GLN | 204 | -105 | 99 | WUNI_load_with_gen | 13061 | WUNI_load_with_gen_Non-industrial | 77 |
| TOPE | KOE | 152 | -132 | 20 | WUNI_load_with_gen | 6222 | WUNI_load_with_gen_Non-industrial | 37 |
| CTCT | SFD | -1 | 76 | 74 | RNI_peaker | 998272522 | RNI_peaker | 67 |
| WHI | -0 | 1 | 1 | RNI_peaker | 6716385 | RNI_peaker | 0 | |
| TBOP | JRD | 0 | 14 | 14 | RNI_peaker | 191436260 | RNI_peaker | 13 |
| MKE | 0 | 10 | 10 | RNI_peaker | 292787134 | RNI_peaker | 20 | |
| SHPK | PEN | 0 | 0 | 0 | WUNI_Industrial | 34 | WUNI_Industrial | 0 |
| TRNZ | HAM | 1 | 0 | 1 | WUNI_Industrial | 110 | WUNI_Industrial | 1 |
| PEN | 9 | 0 | 9 | WUNI_Industrial | 2208 | WUNI_Industrial | 18 | |
| SWN | 25 | 0 | 25 | WUNI_Industrial | 1856 | WUNI_Industrial | 15 | |
| KIWI | HWA | 0 | 0 | 0 | RNI_cogen | 151013236 | RNI_cogen | 13 |
| TBOP | KPA | -13 | 35 | 22 | RNI_cogen | 99281724 | RNI_cogen | 9 |
| TRUG | ARG | 0 | 16 | 16 | SI_run of river | 41155189 | SI_run of river_storage_wind | 15 |
For each Regional supply/demand group (e.g. (NI, supply), (SI, demand)):
Output file: ben_groups.csv
| prov_group | npb | ira | future | ratio | final_group | ||
|---|---|---|---|---|---|---|---|
| region | demand_supply | ||||||
| RNI | supply | RNI_run of river | 1107.9542 | 1849590863.76 | False | 0.5990 | RNI_run of river_storage |
| supply | RNI_storage | 1503.6977 | 2599242371.60 | False | 0.5785 | RNI_run of river_storage | |
| supply | RNI_wind | 989.3634 | 2110866761.80 | False | 0.4687 | RNI_wind | |
| supply | RNI_battery | 0.0324 | 95771.94 | True | 0.3382 | RNI_battery | |
| supply | RNI_geo | 2013.7543 | 7509139851.74 | False | 0.2682 | RNI_geo | |
| supply | RNI_solar | 8.3478 | 67897689.17 | True | 0.1229 | RNI_solar | |
| supply | RNI_cogen | 21.5762 | 250294960.65 | False | 0.0862 | RNI_cogen | |
| supply | RNI_peaker | 99.3858 | 1489212301.04 | False | 0.0667 | RNI_peaker | |
| SI | supply | SI_battery | 0.0173 | 35503.27 | True | 0.4873 | SI_battery |
| supply | SI_run of river | 16.1019 | 41155189.07 | False | 0.3912 | SI_run of river_storage_wind | |
| supply | SI_storage | 6489.4251 | 17712178233.83 | False | 0.3664 | SI_run of river_storage_wind | |
| supply | SI_wind | 47.4330 | 157679571.68 | True | 0.3008 | SI_run of river_storage_wind | |
| supply | SI_peaker | 0.0043 | 22099.08 | True | 0.1963 | SI_peaker | |
| supply | SI_solar | 13.6642 | 95786593.38 | True | 0.1427 | SI_solar | |
| WUNI | demand | WUNI_Industrial | 34.2080 | 4208.02 | False | 8129.2486 | WUNI_Industrial |
| demand | WUNI_load_with_gen | 118.9362 | 19282.81 | False | 6167.9928 | WUNI_load_with_gen_Non-industrial | |
| demand | WUNI_Non-industrial | 7030.5448 | 1188450.17 | False | 5915.7254 | WUNI_load_with_gen_Non-industrial |
Regions: ../../BBI_calcs/BHL_PAK/configs/region_buses.yaml
clause51 output directory: ../../BBI_calcs/BHL_PAK/outputs/clause51
sddp2tpm_data directory: ../../sddp2tpm_data/data/BHL_PAK
Renewable projects (for wind repowering adjustments): ../master_model_inputs/CreateInputs_SDDP/PlantData/exchange_files/renewProjects.csv
Weights: {'constraint': 0.2, 'innovation': 0.2, 'reference': 0.2, 'growth': 0.2, 'environmental': 0.2}
Output directory: ../../BBI_calcs/BHL_PAK/outputs/alloc51