# This script calculates SPD charges. 

# First run 'load_SPD_lookups.sql'. 

# Note that subsequent scripts adjust amounts to recover downwards, for investments whose costs are partly or wholly recovered through a different charge (such as the deeper connection charge).

# Hard-coded assumptions include that:
# - IR (dis)benefits are only modelled for Pole 2 and Pole 3, and not for grid-connected generation nodes
# - LCE allows for a 4.85% derating of the amounts to be recovered
# - Load and generation at the KIN pooled node is paid for by CHH 
# - Load and generation at the KAW pooled node is paid for by Norske Skog 
# - Load and generation at the GLN pooled node is paid for by NZ Steel.

# The script uses a dataset 'reconciliation_allocations_for_spd_method_3yr_long' that has not been published because it is commercially sensitive.
# Therefore, you will not be able to run this code.
# However, so that you can reproduce the remainder of the analysis, the key outputs of this script have been provided in .csv form and can be loaded by running the commented-out code below.

USE tpm2;

CREATE TABLE spd_raw_allocations_working AS
SELECT a.investment, b.record_date, b.tp, d.pooled AS pooled_node, YEAR(b.record_date) AS record_year, MONTH(b.record_date) AS record_month,
 ROUND(SUM(b.net_benefit-c.net_benefit),3) AS difference_in_net_benefit, 
 ROUND(SUM(b.net_benefit_IR-c.net_benefit_IR),3) AS difference_in_net_benefit_IR,
 SUM(b.net_demand) AS net_demand, SUM(b.generation) AS generation
FROM spd_table_of_runs AS a
INNER JOIN o_raw_node_ir AS b
ON a.factual_runtype=b.runtype
INNER JOIN spd_node_pooling AS d
ON b.node=d.node
LEFT JOIN o_raw_node_ir AS c
ON a.counterfactual_runtype=c.runtype AND b.record_date=c.record_date AND b.tp=c.tp AND b.node=c.node
WHERE (b.net_benefit<>c.net_benefit OR b.net_benefit_IR<>c.net_benefit_IR) AND a.investment<>'NAaN' AND a.investment<>'NIGU'
GROUP BY a.investment, b.record_date, b.tp, d.pooled
HAVING ROUND(SUM(b.net_benefit-c.net_benefit),3)<>0 OR ROUND(SUM(b.net_benefit_IR-c.net_benefit_IR),3)<>0;

CREATE INDEX idx ON spd_raw_allocations_working (investment, record_date, tp, pooled_node);
CREATE INDEX idx2 ON spd_raw_allocations_working (investment, record_year, record_month);

# Hard-coded - IR (dis)benefits are only modelled for Pole 2 and Pole 3, and not for grid-connected generation nodes
UPDATE spd_raw_allocations_working SET difference_in_net_benefit_IR=0 WHERE (investment<>'Pole 2' AND investment<>'Pole 3') OR pooled_node IN (SELECT offer_code FROM offer_node_to_participant);

CREATE TABLE spd_working_1_yearly AS
SELECT investment, record_year, 
SUM(CASE WHEN difference_in_net_benefit+difference_in_net_benefit_IR>0 THEN difference_in_net_benefit+difference_in_net_benefit_IR ELSE 0 END) AS gross_benefit
FROM spd_raw_allocations_working
GROUP BY investment, record_year;

CREATE INDEX idx ON spd_working_1_yearly (investment, record_year);

CREATE TABLE spd_working_1_monthly AS
SELECT investment, record_year, record_month,
SUM(CASE WHEN difference_in_net_benefit+difference_in_net_benefit_IR>0 THEN difference_in_net_benefit+difference_in_net_benefit_IR ELSE 0 END) AS gross_benefit
FROM spd_raw_allocations_working
GROUP BY investment, record_year, record_month;

CREATE INDEX idx ON spd_working_1_monthly (investment, record_year, record_month);

CREATE TABLE spd_working_1_daily AS
SELECT investment, record_date,
SUM(CASE WHEN difference_in_net_benefit+difference_in_net_benefit_IR>0 THEN difference_in_net_benefit+difference_in_net_benefit_IR ELSE 0 END) AS gross_benefit
FROM spd_raw_allocations_working
GROUP BY investment, record_date;

CREATE INDEX idx ON spd_working_1_daily (investment, record_date);

# HARD-CODED - LCE derating is 4.85%
CREATE TABLE spd_working_2 AS
SELECT a.*, b.gross_benefit AS gross_benefit_yearly, c.gross_benefit AS gross_benefit_monthly, d.gross_benefit AS gross_benefit_daily, 1e6*e.amount_m_per_year*(1-0.0485) AS amount_per_year_post_LCE
FROM spd_raw_allocations_working AS a
INNER JOIN spd_working_1_yearly AS b
ON a.investment=b.investment AND a.record_year=b.record_year
INNER JOIN spd_working_1_monthly AS c
ON a.investment=c.investment AND a.record_year=c.record_year AND a.record_month=c.record_month
INNER JOIN spd_working_1_daily AS d
ON a.investment=d.investment AND a.record_date=d.record_date
INNER JOIN spd_amounts_to_recover_pre_lce AS e
ON a.investment=e.investment;

DELETE FROM spd_working_2 WHERE difference_in_net_benefit=0 AND difference_in_net_benefit_IR=0;
 
CREATE TABLE spd_working_3a AS
SELECT a.investment, YEAR(a.record_date) AS record_year, a.pooled_node, b.generator,
 SUM((difference_in_net_benefit+difference_in_net_benefit_IR)*(CASE WHEN gross_benefit_yearly>amount_per_year_post_LCE THEN amount_per_year_post_LCE/gross_benefit_yearly ELSE 1 END)) AS net_charge_with_yearly_capping,
 SUM((difference_in_net_benefit+difference_in_net_benefit_IR)*(CASE WHEN (12*gross_benefit_monthly)>amount_per_year_post_LCE THEN amount_per_year_post_LCE/(12*gross_benefit_monthly) ELSE 1 END)) AS net_charge_with_monthly_capping,
 SUM((difference_in_net_benefit+difference_in_net_benefit_IR)*(CASE WHEN (365*gross_benefit_daily)>amount_per_year_post_LCE THEN amount_per_year_post_LCE/(365*gross_benefit_daily) ELSE 1 END)) AS net_charge_with_daily_capping,
 SUM(difference_in_net_benefit+difference_in_net_benefit_IR) AS net_charge_uncapped
FROM spd_working_2 AS a
INNER JOIN injecting_load_node_to_participant AS b
ON a.pooled_node=b.injecting_load_node
WHERE a.net_demand<0 
GROUP BY a.investment, YEAR(a.record_date), a.pooled_node, b.generator;

CREATE TABLE spd_working_3b AS
SELECT a.investment, YEAR(a.record_date) AS record_year, a.pooled_node, b.generator,
 SUM((difference_in_net_benefit+difference_in_net_benefit_IR)*(CASE WHEN gross_benefit_yearly>amount_per_year_post_LCE THEN amount_per_year_post_LCE/gross_benefit_yearly ELSE 1 END)) AS net_charge_with_yearly_capping,
 SUM((difference_in_net_benefit+difference_in_net_benefit_IR)*(CASE WHEN (12*gross_benefit_monthly)>amount_per_year_post_LCE THEN amount_per_year_post_LCE/(12*gross_benefit_monthly) ELSE 1 END)) AS net_charge_with_monthly_capping,
 SUM((difference_in_net_benefit+difference_in_net_benefit_IR)*(CASE WHEN (365*gross_benefit_daily)>amount_per_year_post_LCE THEN amount_per_year_post_LCE/(365*gross_benefit_daily) ELSE 1 END)) AS net_charge_with_daily_capping,
 SUM(difference_in_net_benefit+difference_in_net_benefit_IR) AS net_charge_uncapped
FROM spd_working_2 AS a
INNER JOIN offer_node_to_participant AS b
ON a.pooled_node=b.offer_code
WHERE a.generation>0
GROUP BY a.investment, YEAR(a.record_date), a.pooled_node, b.generator;

CREATE TABLE spd_working_3c AS
SELECT a.investment, YEAR(a.record_date) AS record_year, a.pooled_node, b.purchaser AS customer,
 SUM((difference_in_net_benefit+difference_in_net_benefit_IR)*proportion*(CASE WHEN gross_benefit_yearly>amount_per_year_post_LCE THEN amount_per_year_post_LCE/gross_benefit_yearly ELSE 1 END)) AS net_charge_with_yearly_capping,
 SUM((difference_in_net_benefit+difference_in_net_benefit_IR)*proportion*(CASE WHEN (12*gross_benefit_monthly)>amount_per_year_post_LCE THEN amount_per_year_post_LCE/(12*gross_benefit_monthly) ELSE 1 END)) AS net_charge_with_monthly_capping,
 SUM((difference_in_net_benefit+difference_in_net_benefit_IR)*proportion*(CASE WHEN (365*gross_benefit_daily)>amount_per_year_post_LCE THEN amount_per_year_post_LCE/(365*gross_benefit_daily) ELSE 1 END)) AS net_charge_with_daily_capping,
 SUM(difference_in_net_benefit+difference_in_net_benefit_IR) AS net_charge_uncapped
FROM spd_working_2 AS a
INNER JOIN reconciliation_allocations_by_network_3yr_long AS b
ON a.pooled_node=b.poc AND a.record_date=b.trading_date AND a.tp=b.trading_period
WHERE a.net_demand>0  
GROUP BY a.investment, YEAR(a.record_date), a.pooled_node, b.purchaser;

# Hard-coded assumptions that:
# - Load and generation at the KIN pooled node is paid for by CHH 
# - Load and generation at the KAW pooled node is paid for by Norske Skog
# - Load and generation at the GLN pooled node is paid for by NZ Steel 
CREATE TABLE spd_working_3e AS
SELECT a.investment, YEAR(a.record_date) AS record_year, a.pooled_node, 
 (CASE WHEN pooled_node='KIN' THEN 'CHH' WHEN pooled_node='KAW' THEN 'Norske Skog' WHEN pooled_node='GLN' THEN 'NZ Steel' ELSE '' END) AS DC,
 SUM((difference_in_net_benefit+difference_in_net_benefit_IR)*(CASE WHEN gross_benefit_yearly>amount_per_year_post_LCE THEN amount_per_year_post_LCE/gross_benefit_yearly ELSE 1 END)) AS net_charge_with_yearly_capping,
 SUM((difference_in_net_benefit+difference_in_net_benefit_IR)*(CASE WHEN (12*gross_benefit_monthly)>amount_per_year_post_LCE THEN amount_per_year_post_LCE/(12*gross_benefit_monthly) ELSE 1 END)) AS net_charge_with_monthly_capping,
 SUM((difference_in_net_benefit+difference_in_net_benefit_IR)*(CASE WHEN (365*gross_benefit_daily)>amount_per_year_post_LCE THEN amount_per_year_post_LCE/(365*gross_benefit_daily) ELSE 1 END)) AS net_charge_with_daily_capping,
 SUM(difference_in_net_benefit) AS net_charge_uncapped 
FROM spd_working_2 AS a
WHERE (a.pooled_node='KIN' OR a.pooled_node='KAW' OR a.pooled_node='GLN')
GROUP BY a.investment, YEAR(a.record_date), a.pooled_node;

CREATE TABLE spd_working_4 AS
SELECT investment, record_year, pooled_node, customer, category,
 (CASE WHEN SUM(net_charge_with_yearly_capping)>0 THEN SUM(net_charge_with_yearly_capping) ELSE 0 END) AS net_charge_with_yearly_capping,
 (CASE WHEN SUM(net_charge_with_monthly_capping)>0 THEN SUM(net_charge_with_monthly_capping) ELSE 0 END) AS net_charge_with_monthly_capping,
 (CASE WHEN SUM(net_charge_with_daily_capping)>0 THEN SUM(net_charge_with_daily_capping) ELSE 0 END) AS net_charge_with_daily_capping,
 (CASE WHEN SUM(net_charge_uncapped)>0 THEN SUM(net_charge_uncapped) ELSE 0 END) AS net_charge_uncapped 
FROM (
  SELECT investment, record_year, pooled_node, generator AS customer, 'load_injection' AS category, net_charge_with_yearly_capping, net_charge_with_monthly_capping, net_charge_with_daily_capping, net_charge_uncapped FROM spd_working_3a
UNION ALL
  SELECT investment, record_year, pooled_node, generator AS customer, 'generation    ' AS category, net_charge_with_yearly_capping, net_charge_with_monthly_capping, net_charge_with_daily_capping, net_charge_uncapped FROM spd_working_3b
UNION ALL
  SELECT investment, record_year, pooled_node, customer, 'load_offtake  ' AS category, net_charge_with_yearly_capping, net_charge_with_monthly_capping, net_charge_with_daily_capping, net_charge_uncapped FROM spd_working_3c
UNION ALL
  SELECT investment, record_year, pooled_node, DC AS customer, 'DC            ' AS category, net_charge_with_yearly_capping, net_charge_with_monthly_capping, net_charge_with_daily_capping, net_charge_uncapped FROM spd_working_3e) AS a
GROUP BY investment, record_year, pooled_node, customer, category;

CREATE TABLE spd_charges_by_customer AS
SELECT investment, customer, category, island,
SUM(net_charge_with_yearly_capping)/1e6 AS charge_with_yearly_capping_m,
SUM(net_charge_with_monthly_capping)/1e6 AS charge_with_monthly_capping_m,
SUM(net_charge_with_daily_capping)/1e6 AS charge_with_daily_capping_m,
SUM(net_charge_uncapped)/1e6 AS charge_uncapped
FROM spd_working_4 AS a
LEFT JOIN prefix_to_region AS b
ON SUBSTRING(a.pooled_node,1,3)=b.prefix
GROUP BY investment, customer, category, island;

# As you do not have the 'reconciliation_allocations_by_network_3yr_long' table and hence cannot run the code above, 
#  use this commented-out code instead to have the same effect:
#
# DROP TABLE IF EXISTS spd_charges_by_customer;
# 
# CREATE TABLE spd_charges_by_customer (
#  `investment` varchar(30) DEFAULT NULL,
#  `customer` varchar(22) CHARACTER SET utf8 DEFAULT NULL,
#  `category` varchar(14) CHARACTER SET utf8 NOT NULL DEFAULT '',
#  `island` varchar(1) DEFAULT NULL,
#  `charge_with_yearly_capping_m` double DEFAULT NULL,
#  `charge_with_monthly_capping_m` double DEFAULT NULL,
#  `charge_with_daily_capping_m` double DEFAULT NULL,
#  `charge_uncapped` double DEFAULT NULL
# ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# insert into spd_charges_by_customer(`investment`,`customer`,`category`,`island`,`charge_with_yearly_capping_m`,`charge_with_monthly_capping_m`,`charge_with_daily_capping_m`,`charge_uncapped`) values ('BPE-HAY','Alpine Energy','load_offtake  ','S',0.4223268353292322,0.24980451316848723,0.20528702880592845,0.6559480000000002),('BPE-HAY','Aurora Energy','load_offtake  ','S',0.7550327301870859,0.44499016848438133,0.36573125830731157,1.1818290299999998),('BPE-HAY','Buller Electricity','load_offtake  ','S',0.07062278706803547,0.04142859135556521,0.03494249725851147,0.10986561199999997),('BPE-HAY','CHH','DC            ','N',0.012121051822861975,0.01118242461647764,0.005354615164319652,0.020971781999999998),('BPE-HAY','Contact','generation    ','N',0.0866240396438801,0.021327959684221052,0.06246773671457153,0.08681688500000001),('BPE-HAY','Contact','generation    ','S',0,0,0,0),('BPE-HAY','Contact','load_offtake  ','N',0.0011030060795565485,0.0008792091190105592,0.0005477228706756493,0.045069226000000004),('BPE-HAY','Contact','load_offtake  ','S',0.00039764132680719807,0.00016388205247624407,0.00013860831354591015,0.001433907),('BPE-HAY','Counties Power','load_offtake  ','N',0.010397090248123195,0.009180063085053047,0.004523551071228345,0.017908461),('BPE-HAY','Daiken MDF','load_offtake  ','S',0.041508675107595656,0.024905188201342018,0.021124932796681983,0.065089707),('BPE-HAY','Eastland Network','load_offtake  ','N',0.009353473500771925,0.007785568042532582,0.0036054749023580806,0.016304517),('BPE-HAY','Electra','load_offtake  ','N',0.16747780295361162,0.10047977092873603,0.08158735897485472,0.26422979700000004),('BPE-HAY','Electricity Ashburton','load_offtake  ','S',0.27858981131607274,0.17045373046910828,0.1359217130946974,0.42453424700000003),('BPE-HAY','Fonterra','generation    ','N',0.0013028899999999912,0,0.0001650919536280561,0.00130289),('BPE-HAY','Fonterra','load_offtake  ','N',0.0010915170000000063,0.0015199053451654535,0.0009586686443061849,0.001091517),('BPE-HAY','Genesis','generation    ','N',0.032151107814104796,0.0012826833603722476,0.036747136612428705,0.03249155),('BPE-HAY','Genesis','generation    ','S',0,0,0,0),('BPE-HAY','Genesis','load_injection','N',0.000006355045771418513,0.0000019099163515268725,0.0000010960248670514554,0.000006405999999999999),('BPE-HAY','Genesis','load_offtake  ','N',0.00012636431390292577,0.00008283726515350859,0.00004089667993367557,0.0025211030000000002),('BPE-HAY','Horizon','load_offtake  ','N',0.015413760765823514,0.013034419917043736,0.006117821504116277,0.027738634),('BPE-HAY','Kiwirail','load_offtake  ','N',0.0012463266564231512,0.0010941214398841907,0.00046583146462184576,0.00216724),('BPE-HAY','Mainpower','load_offtake  ','S',0.3044445066972971,0.18078426643041084,0.14770616366084077,0.4703377629999999),('BPE-HAY','Marlborough Lines','load_offtake  ','S',0.2526094395819545,0.14662165982512984,0.12082757901784344,0.39335867700000005),('BPE-HAY','Meridian','generation    ','S',0,0,0,0),('BPE-HAY','Meridian','load_injection','N',0.0005039069999999993,0.00016655087826138997,0.00016510338119644956,0.0005039069999999999),('BPE-HAY','Meridian','load_injection','S',0,0,0,0),('BPE-HAY','Meridian','load_offtake  ','N',0.000323969077315849,0.00018267688455830009,0.00015313827817991404,0.000585588),('BPE-HAY','Meridian','load_offtake  ','S',0.0034473985898593774,0.0020900067818184877,0.0017424555749291626,0.023748362),('BPE-HAY','Methanex','load_offtake  ','N',0.0013561052463598893,0.0012729523156058086,0.0005691046018273905,0.002487654),('BPE-HAY','Mokai JV','generation    ','N',0.00242584899999997,0,0,0.0024258490000000003),('BPE-HAY','MRP','generation    ','N',0.009808979000000047,0.02624133032473622,0.051606178460881266,0.009808978999999999),('BPE-HAY','MRP','load_offtake  ','N',0.000316737882966883,0.00035466396585712937,0.0002759107111476608,0.000459562),('BPE-HAY','NAP JV','generation    ','N',0.007900962000000206,0,0,0.007900962000000001),('BPE-HAY','Network Tasman','load_offtake  ','S',0.5074075735142892,0.2987234908995012,0.2454986083466566,0.7921927389999999),('BPE-HAY','Network Waitaki','load_offtake  ','S',0.14512684608709508,0.08448883131296343,0.06807655521226386,0.23205072699999998),('BPE-HAY','Ngatamariki','generation    ','N',0.00146236900000013,0,0,0.0014623689999999998),('BPE-HAY','Norske Skog','DC            ','N',0.0025544689999999507,0,0.0018796924317430362,0.002554469),('BPE-HAY','Northpower','load_offtake  ','N',0.031721039982407065,0.028112190192633488,0.01446485022931508,0.052499388999999994),('BPE-HAY','NZ Steel','DC            ','N',0.026397986124071467,0.0234866789557989,0.011360473105267638,0.043366973),('BPE-HAY','Orion','load_offtake  ','S',1.9883204123983909,1.1756186083513953,0.961136075900844,3.090001566),('BPE-HAY','Other','load_offtake  ','N',0.003549833787925336,0.003178176715592925,0.0017000606626318118,0.08050912799999999),('BPE-HAY','Other','load_offtake  ','S',0.0001880105090822766,0.00008199495300757341,0.00006712851565082355,0.014738164000000002),('BPE-HAY','Pacific Aluminium','load_offtake  ','S',2.6951167485598475,1.6249490059065177,1.3637634949828121,4.165505047),('BPE-HAY','Pacific Steel','load_offtake  ','N',0.007363276037775944,0.0061997660533303425,0.002411706109570386,0.013230437),('BPE-HAY','PanPac','load_offtake  ','N',0.015001258249001625,0.014898070576352883,0.008044910615198483,0.023840764),('BPE-HAY','Pioneer','load_injection','S',0,0,0,0),('BPE-HAY','Powerco','load_offtake  ','N',0.26056897332937434,0.18631653254396713,0.12073159945357675,0.42448517799999996),('BPE-HAY','PowerNet','load_offtake  ','S',0.7651340833566197,0.45199127989122134,0.37220031890015265,1.3764188800000001),('BPE-HAY','Rayonier','load_offtake  ','S',0.03156862368359887,0.018916797872549438,0.015979494728382053,0.048791263),('BPE-HAY','Scanpower','load_offtake  ','N',0.009485184364767592,0.006312191839514753,0.004244520590409787,0.015359811),('BPE-HAY','The Lines Company','load_offtake  ','N',0.00705256295550399,0.006239754350042502,0.003150590264489368,0.013047762),('BPE-HAY','Todd','generation    ','N',0.00830043200000005,0.004098817182913665,0.008816429674932926,0.008300432),('BPE-HAY','Todd','load_injection','N',0.00000041970536145925014,0.0000010130000000000003,0.0000010130000000000003,0.0000010129999999999999),('BPE-HAY','Todd','load_offtake  ','N',0.000017748220381406714,0.000029757891846785082,0.00002252523788605693,0.000022101),('BPE-HAY','Top Energy','load_injection','N',0.000000034414319211707056,0.00000002164181430713128,0.000000035154332642871906,0.000000035),('BPE-HAY','Top Energy','load_offtake  ','N',0.004476932707774495,0.004724500524638237,0.00252874274778079,0.006587679999999999),('BPE-HAY','Trustpower','generation    ','N',0,0.0015527161940863835,0.00461036028447632,0),('BPE-HAY','Trustpower','generation    ','S',0,0,0,0),('BPE-HAY','Trustpower','load_injection','N',0.00001946999999999974,0,0,0.000019469999999999998),('BPE-HAY','Trustpower','load_injection','S',0,0,0,0),('BPE-HAY','TrustPower','load_offtake  ','N',0.00032579073600676656,0.00022859259505662296,0.00012267963157597573,0.000361389),('BPE-HAY','TrustPower','load_offtake  ','S',0.0001164525944049802,0.00008178288215163753,0.00007783596793256159,0.000201029),('BPE-HAY','Unison','load_offtake  ','N',0.06380638330047998,0.04894843523757272,0.02429977027229885,0.10975888399999997),('BPE-HAY','Vector','load_offtake  ','N',0.25538671469364077,0.21600626938478035,0.1081245023835246,0.43625319099999993),('BPE-HAY','Waipa Power','load_offtake  ','N',0.011775484774071919,0.010722878499127515,0.005730925021534647,0.01900706),('BPE-HAY','WEL','load_offtake  ','N',0.034785348991122525,0.031620897026886016,0.016609481022016627,0.057648485),('BPE-HAY','Wellington Electricity','load_offtake  ','N',1.4582348398184706,0.8656419329587397,0.713035875947674,2.2750182800000003),('BPE-HAY','Westpower','load_offtake  ','S',0.1506285878636835,0.08841245617390628,0.07235435671704181,0.229300804),('BPE-HAY','Winstones','load_offtake  ','N',0.008807359495966019,0.007831894250637324,0.0036578291077018514,0.015867034),('BRK-SFD','Alpine Energy','load_offtake  ','S',0.4347966204931645,0.23179813063215307,0.17914589670963832,7.096604234),('BRK-SFD','Aurora Energy','load_offtake  ','S',0.7857896594729799,0.41314328168925896,0.3311082727426838,12.930022805999998),('BRK-SFD','Buller Electricity','load_offtake  ','S',0.07165900239952006,0.037239890837721966,0.030346310854178847,1.1874155040000003),('BRK-SFD','CHH','DC            ','N',0.04636649156265055,0.02652078116305054,0.018702018522291117,0.6814160969999999),('BRK-SFD','Contact','generation    ','N',2.13857551867877,1.0119995109257809,0.722674734760744,39.403275188),('BRK-SFD','Contact','generation    ','S',0,0,0,0),('BRK-SFD','Contact','load_offtake  ','N',0.0014991030634515295,0.0013403441565062743,0.000916675660253329,1.086406956),('BRK-SFD','Contact','load_offtake  ','S',0.00006819717780740683,0.0000500699938978908,0.00005707273926087563,0.017557063999999997),('BRK-SFD','Counties Power','load_offtake  ','N',0.026524296241117042,0.018245925054619833,0.00923173032007498,0.281757668),('BRK-SFD','Daiken MDF','load_offtake  ','S',0.039589534770548725,0.02139974372722855,0.01799544809214987,0.665370329),('BRK-SFD','Eastland Network','load_offtake  ','N',0.05284838949773062,0.03218671047521787,0.019707609226486143,0.772378503),('BRK-SFD','Electra','load_offtake  ','N',0.28137081040630685,0.15995744191556896,0.12461814116302837,4.650144793),('BRK-SFD','Electricity Ashburton','load_offtake  ','S',0.2669002019355394,0.1706723439643914,0.12039361393981662,4.394176267),('BRK-SFD','Fonterra','generation    ','N',0.0701718651160298,0.03044125764367609,0.024798253076451705,1.6308776619999998),('BRK-SFD','Fonterra','load_offtake  ','N',0.005119041068070503,0.0030910729097372897,0.0017579024635391671,0.04813396400000001),('BRK-SFD','Genesis','generation    ','N',0.09575410974187869,0.02765881839849387,0.02533316554756415,1.1447235860000002),('BRK-SFD','Genesis','generation    ','S',0,0,0,0),('BRK-SFD','Genesis','load_injection','N',0.0000012462918952157583,0.00000020018413057290583,0.00000017699999999999998,0.000014475999999999998),('BRK-SFD','Genesis','load_offtake  ','N',0.0004952252208211803,0.00018998754665421698,0.00016508226823084093,0.123461893),('BRK-SFD','Horizon','load_offtake  ','N',0.06976064998362261,0.04187099914031984,0.026972656225643845,1.052023146),('BRK-SFD','Kiwirail','load_offtake  ','N',0.008839383052332069,0.005004880446025953,0.0037623760232259984,0.157601663),('BRK-SFD','Mainpower','load_offtake  ','S',0.3113690996533911,0.17369736016308004,0.134283082677593,5.047933789999999),('BRK-SFD','Marlborough Lines','load_offtake  ','S',0.27133361987843796,0.14096651825194098,0.10927555607201397,4.501255551),('BRK-SFD','Meridian','generation    ','S',0,0,0,0),('BRK-SFD','Meridian','load_injection','N',0.0000621432164539731,0.00003287663146186832,0.00014666947113953455,0.000716037),('BRK-SFD','Meridian','load_injection','S',0,0,0,0),('BRK-SFD','Meridian','load_offtake  ','N',0.0007074069368144003,0.000582948381932584,0.00042503896754694895,0.012939684000000002),('BRK-SFD','Meridian','load_offtake  ','S',0.003494369779501662,0.0018771785163891233,0.0015141037190053112,0.246011875),('BRK-SFD','Methanex','load_offtake  ','N',0,0,0,0),('BRK-SFD','Mokai JV','generation    ','N',0,0,0,0),('BRK-SFD','MRP','generation    ','N',0.0048267842751320315,0.0025014044894258033,0.003006962482299793,0.05561598399999999),('BRK-SFD','MRP','load_offtake  ','N',0.00009667815419695159,0.00012036792707265727,0.00013635196106221621,0.0008747290000000001),('BRK-SFD','NAP JV','generation    ','N',0,0,0,0),('BRK-SFD','Network Tasman','load_offtake  ','S',0.539553604434099,0.2866144374826309,0.22370347892465003,8.85520887),('BRK-SFD','Network Waitaki','load_offtake  ','S',0.15296821775115949,0.08019540731461704,0.05955179987712468,2.480611345),('BRK-SFD','Ngatamariki','generation    ','N',0,0,0,0),('BRK-SFD','Norske Skog','DC            ','N',0,0,0,0),('BRK-SFD','Northpower','load_offtake  ','N',0.07176833088238284,0.051370226126850584,0.027169806673222004,0.664783079),('BRK-SFD','NZ Steel','DC            ','N',0.04673627341546487,0.0317440167463412,0.018592890899973527,0.333780607),('BRK-SFD','Orion','load_offtake  ','S',2.049110645377884,1.1000553087543001,0.8617813315788003,33.51014228399999),('BRK-SFD','Other','load_offtake  ','N',0.005340544879371432,0.0036521966000722774,0.0021964625877065116,1.032504176),('BRK-SFD','Other','load_offtake  ','S',0.00022613969265068638,0.00009517970394615997,0.00007025387318973506,0.12477445300000001),('BRK-SFD','Pacific Aluminium','load_offtake  ','S',2.5734114222739906,1.3813505605171608,1.1363885016578414,41.274491795),('BRK-SFD','Pacific Steel','load_offtake  ','N',0.015051275637586781,0.010930418960562918,0.004717424473103559,0.16746439500000002),('BRK-SFD','PanPac','load_offtake  ','N',0.060520101467341283,0.03350838291701501,0.02620190472320743,0.856132648),('BRK-SFD','Pioneer','load_injection','S',0,0,0,0),('BRK-SFD','Powerco','load_offtake  ','N',1.0623772609662263,0.604626866074626,0.42096301935375935,16.704967302000007),('BRK-SFD','PowerNet','load_offtake  ','S',0.7946175864525826,0.41393867056961603,0.3250864165196236,14.773119211000001),('BRK-SFD','Rayonier','load_offtake  ','S',0.02949607332502068,0.01554340390649676,0.013171717618619893,0.47527735600000004),('BRK-SFD','Scanpower','load_offtake  ','N',0.05145558709865032,0.02970922543951357,0.022781770856965693,0.823517154),('BRK-SFD','The Lines Company','load_offtake  ','N',0.04357106223165463,0.027068704607735642,0.019091759889568252,0.7010372380000001),('BRK-SFD','Todd','generation    ','N',0.32759469663395546,0.15279870706423432,0.11258116364752613,5.99509965),('BRK-SFD','Todd','load_injection','N',0.00000000035928368064710813,0.000000001,0.00000000040845080277184777,0.000000001),('BRK-SFD','Todd','load_offtake  ','N',0,0,0,0),('BRK-SFD','Top Energy','load_injection','N',0.000000012527455704721001,0.00000000495355091815078,0.00000003593185693612423,0.000000145),('BRK-SFD','Top Energy','load_offtake  ','N',0.013090135271420507,0.00931359664081565,0.004635726391593149,0.102012383),('BRK-SFD','Trustpower','generation    ','N',0.046285948147861244,0.03585035577720236,0.02259710487475805,0.895123102),('BRK-SFD','Trustpower','generation    ','S',0,0,0,0),('BRK-SFD','Trustpower','load_injection','N',0,0,0,0),('BRK-SFD','Trustpower','load_injection','S',0,0,0,0),('BRK-SFD','TrustPower','load_offtake  ','N',0.002755513285223383,0.0010288603018831833,0.0006717713714780624,0.01762679),('BRK-SFD','TrustPower','load_offtake  ','S',0.0000652698158640649,0.00004274307836755357,0.00005135672652612358,0.0012753960000000003),('BRK-SFD','Unison','load_offtake  ','N',0.35182449383703573,0.2073707014264494,0.13568750610886932,5.288532280999998),('BRK-SFD','Vector','load_offtake  ','N',0.6272399646457604,0.44732938313174414,0.2346200146826131,5.832966935000001),('BRK-SFD','Waipa Power','load_offtake  ','N',0.03252800765971623,0.02018215788604134,0.01017986899294191,0.354159326),('BRK-SFD','WEL','load_offtake  ','N',0.07631524948315319,0.04304646620510326,0.02051554231706571,0.741578912),('BRK-SFD','Wellington Electricity','load_offtake  ','N',1.740611107122497,0.9573368593174958,0.7257403547366902,28.511144083999998),('BRK-SFD','Westpower','load_offtake  ','S',0.15834178945111396,0.08021026143386169,0.06298496564277327,2.520678674999999),('BRK-SFD','Winstones','load_offtake  ','N',0.08641666287831225,0.04980758772958654,0.04037074661549927,1.434699211),('LSI Renewables','Alpine Energy','load_offtake  ','S',0.4993542996110148,0.39318747230531553,0.34925194065213333,0.5357775579999999),('LSI Renewables','Aurora Energy','load_offtake  ','S',1.1842880806372453,0.8259126785078859,0.7282881052968546,1.1873159739999999),('LSI Renewables','Buller Electricity','load_offtake  ','S',0.1156189282407256,0.09240523961023275,0.08379260410260508,0.121932672),('LSI Renewables','CHH','DC            ','N',0.11406940137584377,0.09202292330114413,0.07835395993406488,0.123281079),('LSI Renewables','Contact','generation    ','N',0,0,0,0),('LSI Renewables','Contact','generation    ','S',1.3252865337883937,1.7597169541442128,1.6500711093220697,1.491782007),('LSI Renewables','Contact','load_offtake  ','N',0.008835176772952558,0.007406485891670706,0.006424694838989643,0.310124553),('LSI Renewables','Contact','load_offtake  ','S',0.0017476846562227537,0.0005586813548795082,0.0005992204524018583,0.003095488),('LSI Renewables','Counties Power','load_offtake  ','N',0.12241649513221449,0.10186685774370711,0.0852247275097803,0.132439429),('LSI Renewables','Daiken MDF','load_offtake  ','S',0.06735319060321927,0.053691683332961655,0.049189334395276514,0.07091361),('LSI Renewables','Eastland Network','load_offtake  ','N',0.10304850406227672,0.0837548642627671,0.07002888207184707,0.11126662799999999),('LSI Renewables','Electra','load_offtake  ','N',0.16513236821172012,0.13685306794361665,0.11457643166512574,0.17818222700000003),('LSI Renewables','Electricity Ashburton','load_offtake  ','S',0.4977019012320242,0.38362674457899365,0.34294925194223913,0.528417422),('LSI Renewables','Fonterra','generation    ','N',0,0,0,0),('LSI Renewables','Fonterra','load_offtake  ','N',0.013372389502407045,0.011155620689453022,0.01014466955135694,0.014389513999999999),('LSI Renewables','Genesis','generation    ','N',0,0,0.0013190250528016785,0),('LSI Renewables','Genesis','generation    ','S',0,0,0,0),('LSI Renewables','Genesis','load_injection','N',0.0000023025548285833717,0.0000016154962920633559,0.000001079161986586753,0.000002577),('LSI Renewables','Genesis','load_offtake  ','N',0.0004764156148006698,0.00036758232881120703,0.00029963061315146786,0.0073489689999999995),('LSI Renewables','Horizon','load_offtake  ','N',0.14886549852165787,0.12267704602258468,0.10465054929577375,0.16034767500000002),('LSI Renewables','Kiwirail','load_offtake  ','N',0.012824525717032817,0.010148358244742917,0.008864712013411795,0.013824047999999999),('LSI Renewables','Mainpower','load_offtake  ','S',0.5511336874883254,0.44507221321385626,0.40114484110376836,0.5821477940000002),('LSI Renewables','Marlborough Lines','load_offtake  ','S',0.4262935819932748,0.3409851484706382,0.3061821649543522,0.449703455),('LSI Renewables','Meridian','generation    ','S',1.8046124038431546,2.197601999126858,2.0104589027795967,2.031325487),('LSI Renewables','Meridian','load_injection','N',0,0,0,0),('LSI Renewables','Meridian','load_injection','S',0,0.007798433602966545,0.0077037221906951486,0),('LSI Renewables','Meridian','load_offtake  ','N',0.0006193045871375913,0.0004959608050625159,0.00027776305824229964,0.000660365),('LSI Renewables','Meridian','load_offtake  ','S',0.0027902860165072334,0.002158848258945244,0.0018185949855435875,0.012624406999999999),('LSI Renewables','Methanex','load_offtake  ','N',0.015535932746362495,0.012420923623342453,0.0107710646701473,0.016829778000000004),('LSI Renewables','Mokai JV','generation    ','N',0,0,0,0),('LSI Renewables','MRP','generation    ','N',0,0,0,0),('LSI Renewables','MRP','load_offtake  ','N',0.0016774293239022874,0.0015604470229832106,0.0014863699710537831,0.0017933530000000001),('LSI Renewables','NAP JV','generation    ','N',0,0,0,0),('LSI Renewables','Network Tasman','load_offtake  ','S',0.8576261185758755,0.6924860849259873,0.6238247147193418,0.904255231),('LSI Renewables','Network Waitaki','load_offtake  ','S',0.18265629333901323,0.15453867294051263,0.13923917469542835,0.202011345),('LSI Renewables','Ngatamariki','generation    ','N',0,0,0,0),('LSI Renewables','Norske Skog','DC            ','N',0,0,0,0),('LSI Renewables','Northpower','load_offtake  ','N',0.3449306363989475,0.28547055973959146,0.2438566911081453,0.37189262),('LSI Renewables','NZ Steel','DC            ','N',0.22823704475395598,0.18545158796829592,0.1586470342520959,0.245668471),('LSI Renewables','Orion','load_offtake  ','S',3.3989595243876414,2.7515693616586687,2.4711650885770777,3.5838738239999994),('LSI Renewables','Other','load_offtake  ','N',0.03477346129100663,0.028596088627210917,0.024668363311758326,0.5420996479999999),('LSI Renewables','Other','load_offtake  ','S',0.000169362328775357,0,0,0.014609200999999999),('LSI Renewables','Pacific Aluminium','load_offtake  ','S',6.953120218353264,4.198819752454635,3.7830599414847144,7.067706419),('LSI Renewables','Pacific Steel','load_offtake  ','N',0.06927239500290525,0.05604568726445502,0.04628149457353241,0.075041094),('LSI Renewables','PanPac','load_offtake  ','N',0.1519690177002844,0.12463054492451212,0.11017890116594013,0.16435566899999998),('LSI Renewables','Pioneer','load_injection','S',0.0035143401709769252,0.00895624904747483,0.007865572739502585,0.003955846),('LSI Renewables','Powerco','load_offtake  ','N',1.392081716397581,1.1566321590926463,0.9728947479480266,1.5105585300000002),('LSI Renewables','PowerNet','load_offtake  ','S',2.0024150069433495,1.2757217336263642,1.1565197290337896,2.114057722),('LSI Renewables','Rayonier','load_offtake  ','S',0.08220683108051133,0.04846241490426003,0.04374491573121404,0.08396826999999998),('LSI Renewables','Scanpower','load_offtake  ','N',0.03139003897487506,0.026018294650918865,0.022107351888106704,0.033853571),('LSI Renewables','The Lines Company','load_offtake  ','N',0.07715026746615399,0.06244714964391665,0.052763217559075065,0.087599072),('LSI Renewables','Todd','generation    ','N',0,0,0,0),('LSI Renewables','Todd','load_injection','N',0.000000001,0.000000001,0.000000001,0.000000001),('LSI Renewables','Todd','load_offtake  ','N',0.0002456198442801833,0.00021886167064717686,0.00019864449775594786,0.000269642),('LSI Renewables','Top Energy','load_injection','N',0.000000048,0.000000048,0.000000048,0.000000048),('LSI Renewables','Top Energy','load_offtake  ','N',0.061140994033685885,0.05273329895484053,0.04347896052132179,0.065927931),('LSI Renewables','Trustpower','generation    ','N',0,0,0,0),('LSI Renewables','Trustpower','generation    ','S',0,0.0823104717763273,0.07507379663987895,0),('LSI Renewables','Trustpower','load_injection','N',0,0,0,0),('LSI Renewables','Trustpower','load_injection','S',0,0,0,0),('LSI Renewables','TrustPower','load_offtake  ','N',0.0014772064260719173,0.0011196939696817064,0.0009506095342356432,0.0015828589999999998),('LSI Renewables','TrustPower','load_offtake  ','S',0.00020483867999845825,0.00013654996743682176,0.00012921693383116602,0.00021159300000000002),('LSI Renewables','Unison','load_offtake  ','N',0.5916221708245769,0.48457104314388666,0.4057855929441389,0.638694501),('LSI Renewables','Vector','load_offtake  ','N',2.914738608651424,2.431457555279347,2.032482978100384,3.147989572),('LSI Renewables','Waipa Power','load_offtake  ','N',0.12630113604772344,0.10624189729948921,0.09044581623581696,0.13623464799999999),('LSI Renewables','WEL','load_offtake  ','N',0.3863476632857073,0.3235419886408302,0.27309022834850055,0.41735465899999996),('LSI Renewables','Wellington Electricity','load_offtake  ','N',0.9427341640209822,0.7826003945856033,0.6541821292042865,1.017845969),('LSI Renewables','Westpower','load_offtake  ','S',0.24135465921370225,0.19086142412545457,0.1720997079967644,0.25413303700000006),('LSI Renewables','Winstones','load_offtake  ','N',0.08539247341405934,0.06968916115600421,0.05995114600452328,0.092029676),('OTB-HAY','Alpine Energy','load_offtake  ','S',0.15702493367622747,0.1582498160211453,0.1585474129699491,4721.438139048),('OTB-HAY','Aurora Energy','load_offtake  ','S',0.26319287062852664,0.26132967255986955,0.261970520309186,7830.105504439998),('OTB-HAY','Buller Electricity','load_offtake  ','S',0.02395317363854676,0.023984323648032418,0.02411410769847806,707.406863431),('OTB-HAY','CHH','DC            ','N',0.1303180179193236,0.13081671069715456,0.13162174435999252,3848.8572986450004),('OTB-HAY','Contact','generation    ','N',0.0018621821561029931,0.0018517130830007537,0.0018955230859104713,54.856746022),('OTB-HAY','Contact','generation    ','S',0.004395722050445512,0.004196222924029443,0.003969658006569553,131.08962165600002),('OTB-HAY','Contact','load_offtake  ','N',0.006006402687469284,0.006036608032272178,0.006079817052847867,5799.847627210999),('OTB-HAY','Contact','load_offtake  ','S',0.00005475107227742822,0.00005603017702724897,0.00005599242591673394,21.345766416),('OTB-HAY','Counties Power','load_offtake  ','N',0.07647492755613894,0.0763713435328686,0.07626969562522307,2259.935429929),('OTB-HAY','Daiken MDF','load_offtake  ','S',0.015202361321091358,0.015234400904789723,0.01537001856576348,448.83187676000006),('OTB-HAY','Eastland Network','load_offtake  ','N',0.06427043181169696,0.06432916629250061,0.06430174401516808,1898.11061975),('OTB-HAY','Electra','load_offtake  ','N',0.09834055488723743,0.09794764366589914,0.09812053081583497,2904.3656653489998),('OTB-HAY','Electricity Ashburton','load_offtake  ','S',0.11625809548586001,0.11846947674835945,0.11822544401029346,3437.6160526090002),('OTB-HAY','Fonterra','generation    ','N',0.00009592777763450507,0.000094328410601971,0.000098429700592883,2.825870561),('OTB-HAY','Fonterra','load_offtake  ','N',0.00921875472012944,0.009457126948437583,0.009498921323353227,272.36282609899996),('OTB-HAY','Genesis','generation    ','N',0.0011765954770373423,0.0012313923940670735,0.0012537098117767454,34.660518597999996),('OTB-HAY','Genesis','generation    ','S',0.001165817273125666,0.0011053736368992536,0.0010600395853367823,34.867788205),('OTB-HAY','Genesis','load_injection','N',0.000000010154681386192657,0.000000012181077014407701,0.000000011365762228908218,0.000305646),('OTB-HAY','Genesis','load_offtake  ','N',0.0003220273726748243,0.00032206815145332043,0.00032457974245115586,130.25243287),('OTB-HAY','Horizon','load_offtake  ','N',0.10062500813572939,0.10071634240264957,0.10094092633503053,2971.774270825),('OTB-HAY','Kiwirail','load_offtake  ','N',0.008161937127729734,0.008209358621197475,0.008129196300442064,241.039573652),('OTB-HAY','Mainpower','load_offtake  ','S',0.10822240387596888,0.10860145666845639,0.10891359018230644,3197.4450656669997),('OTB-HAY','Marlborough Lines','load_offtake  ','S',0.08127642749041779,0.08148481893745521,0.0815318843801861,2400.085180917),('OTB-HAY','Meridian','generation    ','S',0.0074980643721749675,0.007033550771807671,0.006333107590267338,223.717407257),('OTB-HAY','Meridian','load_injection','N',0.0002563424525867023,0.0002504180467695645,0.0002577034466455036,7.5519954039999995),('OTB-HAY','Meridian','load_injection','S',0,0,0,0),('OTB-HAY','Meridian','load_offtake  ','N',0.0003191754780252063,0.0003146343576405235,0.0003130532003087172,9.429143316),('OTB-HAY','Meridian','load_offtake  ','S',0.0013353908046007507,0.001331517348720064,0.0013377451672965267,162.80711812699997),('OTB-HAY','Methanex','load_offtake  ','N',0.009555249095028768,0.00959203655902727,0.009634076960694219,282.781684946),('OTB-HAY','Mokai JV','generation    ','N',0,0,0.000018347291212540426,0),('OTB-HAY','MRP','generation    ','N',0.00000874360922651727,0.000009716009596392228,0.00001668826035816855,0.257571983),('OTB-HAY','MRP','load_offtake  ','N',0.001430357256605765,0.0014491805189105276,0.0014805989518434858,42.289725786),('OTB-HAY','NAP JV','generation    ','N',0,0,0,0),('OTB-HAY','Network Tasman','load_offtake  ','S',0.16888759994461278,0.16863922543729787,0.16879944297379101,4987.091251358999),('OTB-HAY','Network Waitaki','load_offtake  ','S',0.05084477122852362,0.05134347207195897,0.051312738242625666,1605.8863901210002),('OTB-HAY','Ngatamariki','generation    ','N',0,0,0.0000024680688017236625,0),('OTB-HAY','Norske Skog','DC            ','N',0.10420476253910213,0.10449743399061168,0.1059729739063121,3075.956382763),('OTB-HAY','Northpower','load_offtake  ','N',0.21881928262301517,0.2192353944111339,0.21976393665519875,6462.804671901),('OTB-HAY','NZ Steel','DC            ','N',0.23581380941729696,0.2363059943277661,0.23762527092920116,6964.539633003999),('OTB-HAY','Orion','load_offtake  ','S',0.6820708515831657,0.6796873598145414,0.6800357858306117,20145.968506344994),('OTB-HAY','Other','load_offtake  ','N',0.022437464421954254,0.022510166494667763,0.022597146341017754,9446.135111209998),('OTB-HAY','Other','load_offtake  ','S',0.00007060927750496253,0.00007162680672644748,0.00007097578548826962,171.131978766),('OTB-HAY','Pacific Aluminium','load_offtake  ','S',1.0467432203411187,1.051099372676599,1.0578707138016665,30889.414045483),('OTB-HAY','Pacific Steel','load_offtake  ','N',0.04207660216670226,0.04200102665537583,0.04102586129214777,1243.2354964879999),('OTB-HAY','PanPac','load_offtake  ','N',0.10753541805077986,0.10794972702602035,0.10884175747767372,3179.745205257),('OTB-HAY','Pioneer','load_injection','S',0,0,0,0),('OTB-HAY','Powerco','load_offtake  ','N',0.8762218184056414,0.8758637592873136,0.875897380961301,26015.380116830987),('OTB-HAY','PowerNet','load_offtake  ','S',0.2775906759504066,0.27866237830342105,0.27898409441718836,9525.42396297),('OTB-HAY','Rayonier','load_offtake  ','S',0.011777297897959687,0.011818409167765956,0.011904184960275198,349.75991074800004),('OTB-HAY','Scanpower','load_offtake  ','N',0.01917232254293686,0.019200277643907575,0.01920182301173144,566.13203722),('OTB-HAY','The Lines Company','load_offtake  ','N',0.04749288187057616,0.04751313215404079,0.04754887117553538,1475.0435686070002),('OTB-HAY','Todd','generation    ','N',0.000000381212894079754,0.0000007243312255869654,0.000004913104759160999,0.011229889),('OTB-HAY','Todd','load_injection','N',0,0,0,0),('OTB-HAY','Todd','load_offtake  ','N',0.00010798854522597998,0.00010806052786184614,0.00010916804174530507,3.2302169210000002),('OTB-HAY','Top Energy','load_injection','N',0,0,0,0),('OTB-HAY','Top Energy','load_offtake  ','N',0.036929525786979465,0.03684248099444444,0.03680310998558682,1090.414893717),('OTB-HAY','Trustpower','generation    ','N',0,0,0,0),('OTB-HAY','Trustpower','generation    ','S',0.00048345527181520444,0.0004266409027042803,0.00038753517081148203,14.461088322),('OTB-HAY','Trustpower','load_injection','N',0.0001082900639374201,0.00010933560207565242,0.0001138223232209969,3.190351993),('OTB-HAY','Trustpower','load_injection','S',0.00001791912941776002,0.000017367611421219967,0.000016656894904806625,0.533602116),('OTB-HAY','TrustPower','load_offtake  ','N',0.0020442425309417133,0.002076431950772721,0.002071974237042095,59.844586899),('OTB-HAY','TrustPower','load_offtake  ','S',0.00009601021886579132,0.00009805785010504086,0.00010027325683509531,2.8249252940000003),('OTB-HAY','Unison','load_offtake  ','N',0.3843391148831657,0.38400593375344305,0.3837182622198196,11351.165166775998),('OTB-HAY','Vector','load_offtake  ','N',1.8656317170926364,1.8616070111876877,1.8585991840367047,55127.06770839599),('OTB-HAY','Waipa Power','load_offtake  ','N',0.082605089879082,0.08274009730669162,0.08292094082831052,2440.0458845639996),('OTB-HAY','WEL','load_offtake  ','N',0.2535008687995606,0.25333221602144634,0.25258425835892495,7487.468670221999),('OTB-HAY','Wellington Electricity','load_offtake  ','N',0.5618070946050765,0.559163208624774,0.5584178617761364,16590.00001752),('OTB-HAY','Westpower','load_offtake  ','S',0.04857189946745931,0.048866612045731686,0.04896344804857869,1432.7954866660002),('OTB-HAY','Winstones','load_offtake  ','N',0.057592892387496646,0.05777840688327179,0.05811231140298712,1701.4028217299997),('Pole 2','Alpine Energy','load_offtake  ','S',0.877619584832801,0.623297322534495,0.6221205267003003,50.719162256),('Pole 2','Aurora Energy','load_offtake  ','S',1.4712434207124938,0.9835146840520405,0.9634993154966516,83.616921544),('Pole 2','Buller Electricity','load_offtake  ','S',0.15378423139503336,0.10615502423113062,0.1126638035376167,8.625950918999997),('Pole 2','CHH','DC            ','N',0.7936105978532009,0.804942906804625,0.6834810027394879,39.98178110799999),('Pole 2','Contact','generation    ','N',0.8464059681806474,0.4988768229821673,0.5060293843663679,47.750194560999994),('Pole 2','Contact','generation    ','S',1.6777897944532558,1.8353569431594567,1.8644151155927018,87.46781581200001),('Pole 2','Contact','load_offtake  ','N',0.06583019475712246,0.06940704332345979,0.06124587979087419,91.259245753),('Pole 2','Contact','load_offtake  ','S',0.002298414302260401,0.001961435643581162,0.001998081766940534,0.185056377),('Pole 2','Counties Power','load_offtake  ','N',1.0012934442036505,1.0176589618227485,0.8404217073616768,52.18609919399999),('Pole 2','Daiken MDF','load_offtake  ','S',0.09850123136896319,0.07149904756462748,0.08003278076327723,5.560876529),('Pole 2','Eastland Network','load_offtake  ','N',0.802307332982267,0.8200594492384737,0.6787157048850881,41.076217318000005),('Pole 2','Electra','load_offtake  ','N',1.241803373377625,1.2876620695532541,1.0969899954032474,63.621471097000004),('Pole 2','Electricity Ashburton','load_offtake  ','S',0.592085432029789,0.4442661126333646,0.4131859272777528,33.602065488),('Pole 2','Fonterra','generation    ','N',0.03973714057916208,0.007528486124782243,0.025752225593503507,2.2417802630000003),('Pole 2','Fonterra','load_offtake  ','N',0.0925112731142488,0.10067383072702983,0.0903923852958883,4.819725150999999),('Pole 2','Genesis','generation    ','N',0.48940062345039725,0,0.03794802847684074,27.609652893000003),('Pole 2','Genesis','generation    ','S',0.4144358796878735,0.33315877029136115,0.36476649041333375,23.157924042999998),('Pole 2','Genesis','load_injection','N',0.000004496503040344092,0.000007412506963956794,0.000004094792115342173,0.000289149),('Pole 2','Genesis','load_offtake  ','N',0.003402613420929493,0.003181118531444233,0.0030131972791026806,2.43016121),('Pole 2','Horizon','load_offtake  ','N',1.1230010933769254,1.154796457838045,0.9818680632003476,57.84767473099999),('Pole 2','Kiwirail','load_offtake  ','N',0.07541463603540474,0.08050800364807267,0.06380897248404017,3.863679702),('Pole 2','Mainpower','load_offtake  ','S',0.592487376400197,0.4091484301473037,0.3861509797919065,33.441431802),('Pole 2','Marlborough Lines','load_offtake  ','S',0.5072484339677046,0.3573419875363766,0.34059623211313805,28.616541379999997),('Pole 2','Meridian','generation    ','S',2.740316967516533,3.2237716783409818,2.5828784454905427,141.056753771),('Pole 2','Meridian','load_injection','N',0.08986774364860188,0.005381659318067119,0.005730683033714333,5.071880015),('Pole 2','Meridian','load_injection','S',0,0,0,0),('Pole 2','Meridian','load_offtake  ','N',0.0051141579552676794,0.004668942526633992,0.0037558180944417007,0.26545877500000004),('Pole 2','Meridian','load_offtake  ','S',0.008030251968173387,0.005706783514886718,0.00632337231329803,1.9632529410000001),('Pole 2','Methanex','load_offtake  ','N',0.09711982039538712,0.10117153005922579,0.08687545885659366,5.156159145999999),('Pole 2','Mokai JV','generation    ','N',0,0,0,0),('Pole 2','MRP','generation    ','N',0,0,0,0),('Pole 2','MRP','load_offtake  ','N',0.014924806537396897,0.015429197361343173,0.01706888230485349,0.7669379210000001),('Pole 2','NAP JV','generation    ','N',0,0,0,0),('Pole 2','Network Tasman','load_offtake  ','S',1.0167560937296005,0.697696247339627,0.665855592441876,57.360537522),('Pole 2','Network Waitaki','load_offtake  ','S',0.28002200998113974,0.20171757339495058,0.20550679467262642,17.351292015000002),('Pole 2','Ngatamariki','generation    ','N',0,0,0,0),('Pole 2','Norske Skog','DC            ','N',0,0,0,0),('Pole 2','Northpower','load_offtake  ','N',2.6306322747369304,2.712201927882062,2.2890564184066036,135.697365652),('Pole 2','NZ Steel','DC            ','N',1.5071467264135359,1.5521595435574758,1.336237377527685,80.276204153),('Pole 2','Orion','load_offtake  ','S',4.054224194880267,2.722460667007052,2.754141345565956,229.01602943),('Pole 2','Other','load_offtake  ','N',0.24420075753055814,0.24632935611313866,0.2139463481722303,205.32203651499998),('Pole 2','Other','load_offtake  ','S',0.00004708230637890815,0,0.00000936390122787824,0.268323172),('Pole 2','Pacific Aluminium','load_offtake  ','S',6.496366994837567,4.835956272804337,5.556777764605416,367.97729540200004),('Pole 2','Pacific Steel','load_offtake  ','N',0.5100570858732909,0.5176148316850482,0.36477513359663505,26.659401751),('Pole 2','PanPac','load_offtake  ','N',0.7141124673192611,0.7437302187938917,0.7869863414035384,36.040647254999996),('Pole 2','Pioneer','load_injection','S',0,0,0,0),('Pole 2','Powerco','load_offtake  ','N',11.105514845607596,11.387484019519915,9.425798550528667,574.4295504030001),('Pole 2','PowerNet','load_offtake  ','S',1.5905636921594297,1.1393613432484,1.1531958247457836,103.89974531500002),('Pole 2','Rayonier','load_offtake  ','S',0.07669114893882119,0.05595740438493768,0.06413112748115962,4.347822634),('Pole 2','Scanpower','load_offtake  ','N',0.2524919372993557,0.2623521828666645,0.21665737255719675,12.960487259),('Pole 2','The Lines Company','load_offtake  ','N',0.5615014596641951,0.5741787431067963,0.47961289391520107,30.449691287),('Pole 2','Todd','generation    ','N',0,0,0,0),('Pole 2','Todd','load_injection','N',0,0,0,0),('Pole 2','Todd','load_offtake  ','N',0.001382561452483964,0.0014585998134792708,0.0014614560933826756,0.085698679),('Pole 2','Top Energy','load_injection','N',0,0,0,0),('Pole 2','Top Energy','load_offtake  ','N',0.6089954166904037,0.6180403227799159,0.5157730082477444,31.502521306000002),('Pole 2','Trustpower','generation    ','N',0,0,0,0),('Pole 2','Trustpower','generation    ','S',0.12733254999759427,0.11788825032318391,0.12088467690222868,6.954813987),('Pole 2','Trustpower','load_injection','N',0.03385978465692137,0.0012793435278326247,0.0007848785786364917,1.910414515),('Pole 2','Trustpower','load_injection','S',0.007940095665031609,0.00871657566762705,0.008767304950706522,0.414016605),('Pole 2','TrustPower','load_offtake  ','N',0.01691987774443425,0.017739511754871408,0.014349225152838143,0.734525351),('Pole 2','TrustPower','load_offtake  ','S',0.0005684184111752821,0.0004509540533471584,0.0005154057408687223,0.031741818000000005),('Pole 2','Unison','load_offtake  ','N',4.682282071823718,4.773480353423801,3.9246511846091012,240.56725215300003),('Pole 2','Vector','load_offtake  ','N',24.12662094145546,24.56903433419118,20.000121791947524,1250.894460406),('Pole 2','Waipa Power','load_offtake  ','N',1.0192843393154047,1.0526902449158486,0.8886731916639691,52.998483713),('Pole 2','WEL','load_offtake  ','N',3.3042532858333282,3.366401514728936,2.740772189456945,171.26777499000002),('Pole 2','Wellington Electricity','load_offtake  ','N',7.655539276199268,7.835761546643492,6.33930440833891,394.77367357200006),('Pole 2','Westpower','load_offtake  ','S',0.31887331090055127,0.22556311553709027,0.22325092413881523,18.159040394),('Pole 2','Winstones','load_offtake  ','N',0.4930479869409328,0.514630131825926,0.4670019990742104,24.523363475),('Pole 3','Alpine Energy','load_offtake  ','S',1.3609767976133964,0.6711161635648981,0.8272314546461521,4.340715701),('Pole 3','Aurora Energy','load_offtake  ','S',2.3923326726581133,1.1329623092654542,1.332402542658103,7.530282429),('Pole 3','Buller Electricity','load_offtake  ','S',0.26515632938843836,0.1424432121618328,0.16154900111652515,0.808499837),('Pole 3','CHH','DC            ','N',0.7612741109831874,0.6639713486148904,0.49050063111442677,3.8087667909999996),('Pole 3','Contact','generation    ','N',4.257432168431757,2.1056339193722255,2.493831453531581,14.553757683000002),('Pole 3','Contact','generation    ','S',5.765499296381883,5.8576391561021515,5.181514947804096,42.513250987999996),('Pole 3','Contact','load_offtake  ','N',0.07694116681168768,0.07071915910978681,0.04548382382546182,7.934001935999998),('Pole 3','Contact','load_offtake  ','S',0.003589020821544449,0.008772253464240418,0.0050065831116134435,0.034607477),('Pole 3','Counties Power','load_offtake  ','N',1.228183654497867,1.0570339415723837,0.6313383618371117,7.696161087999999),('Pole 3','Daiken MDF','load_offtake  ','S',0.18050295511015416,0.11197278292071552,0.11654510828765671,0.5431482630000001),('Pole 3','Eastland Network','load_offtake  ','N',1.0193647906972294,0.8642669994737315,0.5259651364691882,6.157154863000001),('Pole 3','Electra','load_offtake  ','N',1.070665695745894,0.8973293074744843,0.5693423409670283,6.424154550999999),('Pole 3','Electricity Ashburton','load_offtake  ','S',0.7649385037844391,0.40897755933011254,0.49812347023078635,2.5874917419999997),('Pole 3','Fonterra','generation    ','N',0.15900538018904883,0.07770309739791179,0.07868769176601112,0.543549652),('Pole 3','Fonterra','load_offtake  ','N',0.10961500415091639,0.0891396847685243,0.06058229469827471,0.65991628),('Pole 3','Genesis','generation    ','N',3.560452593328128,1.2263612979196958,2.009748770978198,12.171177892000001),('Pole 3','Genesis','generation    ','S',1.6312905871760548,1.1972182717064572,1.187309101156147,11.427411493),('Pole 3','Genesis','load_injection','N',0.0000018625509745512107,0.000008680850158612127,0.000007104288840148986,0.000016493),('Pole 3','Genesis','load_offtake  ','N',0.0049804696039850585,0.003492083464490134,0.0023388716999960305,0.393589327),('Pole 3','Horizon','load_offtake  ','N',1.304884197107244,1.1340058325661422,0.7262506826607243,7.758588980000001),('Pole 3','Kiwirail','load_offtake  ','N',0.09501236854166988,0.07681441411772874,0.0452996118054133,0.592420403),('Pole 3','Mainpower','load_offtake  ','S',0.8625493983337851,0.40529841352737844,0.49084620477748664,2.7879070409999995),('Pole 3','Marlborough Lines','load_offtake  ','S',0.6935117633208918,0.35205089382028765,0.41306545617586193,2.317086988),('Pole 3','Meridian','generation    ','S',13.127379173966451,11.02389160964016,10.558369917968019,107.12579205299998),('Pole 3','Meridian','load_injection','N',0.69804809004767,0.528324534656993,0.3931299569828921,2.387693461999999),('Pole 3','Meridian','load_injection','S',0.02696386090660442,0,0.01873789286225783,0.238766597),('Pole 3','Meridian','load_offtake  ','N',0.0057449683677270715,0.004917403791361408,0.0028968267929267645,0.032422309999999996),('Pole 3','Meridian','load_offtake  ','S',0.014423245121116292,0.00837063409872072,0.009056926964492616,0.18084522400000003),('Pole 3','Methanex','load_offtake  ','N',0.12565611045696579,0.09389101981146791,0.061430866240365284,0.821155958),('Pole 3','Mokai JV','generation    ','N',0.39397636058123103,0.14958132493230772,0.2506837683928652,1.3467828160000002),('Pole 3','MRP','generation    ','N',0.7589375380061884,0.05876061701633757,0.4260580913818392,2.5943790969999996),('Pole 3','MRP','load_offtake  ','N',0.012979553586332772,0.013219915550897127,0.01205578422643551,0.061600574),('Pole 3','NAP JV','generation    ','N',0.3690836927082513,0.08491827978523503,0.23446577209914438,1.261688834),('Pole 3','Network Tasman','load_offtake  ','S',1.4568395392892137,0.6752875704655086,0.8033926680528288,4.725899029999999),('Pole 3','Network Waitaki','load_offtake  ','S',0.45871415551281636,0.2199827821481016,0.2657708185965042,1.504940763),('Pole 3','Ngatamariki','generation    ','N',0.2524377371230256,0.09210337716536303,0.15978035807109878,0.862942147),('Pole 3','Norske Skog','DC            ','N',0,0,0,0.6542251600000001),('Pole 3','Northpower','load_offtake  ','N',3.1931671715314596,2.723708719064541,1.6886745200222535,19.59530743),('Pole 3','NZ Steel','DC            ','N',1.1281402590056968,0.6573880870056776,0.5564143616635474,10.981446438),('Pole 3','Orion','load_offtake  ','S',7.065527688622572,3.577975860498247,3.988592111141162,21.807704648999998),('Pole 3','Other','load_offtake  ','N',0.29526163265024474,0.24912805766081147,0.16072798872649832,30.064137884),('Pole 3','Other','load_offtake  ','S',0,0,0,0),('Pole 3','Pacific Aluminium','load_offtake  ','S',9.646000337872058,5.914412130056488,6.636407239063526,28.348101055),('Pole 3','Pacific Steel','load_offtake  ','N',0.6726382892096777,0.5286705107014072,0.2920980384215484,4.311732875),('Pole 3','PanPac','load_offtake  ','N',0.05276522321081441,0.0772725404187042,0.10072524211389182,0.087734044),('Pole 3','Pioneer','load_injection','S',0.013071116902682187,0,0.008072770030198032,0.11574552),('Pole 3','Powerco','load_offtake  ','N',13.31698914585743,11.565923379918338,6.97414527346223,82.41235485100002),('Pole 3','PowerNet','load_offtake  ','S',2.484198796687929,1.2913169099338497,1.5511172538192646,9.122660630999999),('Pole 3','Rayonier','load_offtake  ','S',0.13806991403083316,0.08851855878062032,0.09155132079724429,0.412123907),('Pole 3','Scanpower','load_offtake  ','N',0.28966297230547255,0.2502320661072379,0.15517561762942594,1.7510864879999999),('Pole 3','The Lines Company','load_offtake  ','N',0.6840982456010787,0.5797543524738311,0.3650084399144457,4.368249456),('Pole 3','Todd','generation    ','N',0.1274960529267374,0.02776752858182094,0.05931614535081164,0.435837046),('Pole 3','Todd','load_injection','N',0,0,0,0),('Pole 3','Todd','load_offtake  ','N',0.0016273313630894282,0.0013584951137956692,0.0011213590031943106,0.012181728000000001),('Pole 3','Top Energy','load_injection','N',0.000002460831069555426,0.000005498993907837552,0.000009446361082911008,0.000013958),('Pole 3','Top Energy','load_offtake  ','N',0.7546051612098484,0.7329724365829546,0.4226884251423515,4.584849729),('Pole 3','Trustpower','generation    ','N',0.16674573809170556,0,0.07449414450550922,0.570009567),('Pole 3','Trustpower','generation    ','S',1.0930857928602047,0.8844878061360277,0.9228403238256204,8.844049546),('Pole 3','Trustpower','load_injection','N',0.3679359677628202,0.29221828940830635,0.21525491223200044,1.2630234809999998),('Pole 3','Trustpower','load_injection','S',0.017421151472247605,0.021824768197882836,0.016434888563332847,0.115338021),('Pole 3','TrustPower','load_offtake  ','N',0.013165251258410128,0.017287115863985653,0.010540770043264777,0.045830288000000004),('Pole 3','TrustPower','load_offtake  ','S',0.0005674053914464717,0.0005452913680541871,0.0006905689096959935,0.0017087079999999998),('Pole 3','Unison','load_offtake  ','N',5.720776503931122,4.896343267600618,2.9814534626846156,34.935262348),('Pole 3','Vector','load_offtake  ','N',29.946215407589797,26.238592243918085,15.280828142240779,186.44221698199993),('Pole 3','Waipa Power','load_offtake  ','N',1.2308586255722607,1.0943975463375315,0.6648791730805016,7.610106789),('Pole 3','WEL','load_offtake  ','N',3.942976043959803,3.3818252684466916,1.9926142394215784,24.084268632),('Pole 3','Wellington Electricity','load_offtake  ','N',8.848803067010024,7.492386801588941,4.595039110053593,55.601677408),('Pole 3','Westpower','load_offtake  ','S',0.48060904461097587,0.23891669264393045,0.27983673159522693,1.4851960110000002),('Pole 3','Winstones','load_offtake  ','N',0.30424090632758766,0.22790682780586694,0.18071394151687034,2.024045719),('Wairakei Ring','Alpine Energy','load_offtake  ','S',0.14747402204229385,0.11684604054458449,0.10336623673087703,5.955538738999999),('Wairakei Ring','Aurora Energy','load_offtake  ','S',0.3496280344287972,0.21945199613007627,0.1598886503627963,14.440473174),('Wairakei Ring','Buller Electricity','load_offtake  ','S',0.02549184400127354,0.018850582275291985,0.01643777680119627,1.007541302),('Wairakei Ring','CHH','DC            ','N',0.14143980532753683,0.16170918893617778,0.12400894872496315,3.1597149629999994),('Wairakei Ring','Contact','generation    ','N',4.905220309191869,5.582928848160197,5.441383340842863,118.826406145),('Wairakei Ring','Contact','generation    ','S',0,0,0,0),('Wairakei Ring','Contact','load_offtake  ','N',0.017043420199538344,0.016655026093557682,0.015498201409805522,11.006147634),('Wairakei Ring','Contact','load_offtake  ','S',0.000004991853894624782,0.000013064027500763093,0.000018047728508761602,0.007369008),('Wairakei Ring','Counties Power','load_offtake  ','N',0.3649781544011524,0.32001138552751673,0.2825222171630908,11.170558344999998),('Wairakei Ring','Daiken MDF','load_offtake  ','S',0.012808042965340377,0.010715983746400756,0.01027371804429818,0.484095105),('Wairakei Ring','Eastland Network','load_offtake  ','N',0,0,0,0),('Wairakei Ring','Electra','load_offtake  ','N',0.16655134973194544,0.10158400411487001,0.06931307933667816,6.317653803),('Wairakei Ring','Electricity Ashburton','load_offtake  ','S',0.09429651750564165,0.08039212909201916,0.08089649628878588,3.7892864000000004),('Wairakei Ring','Fonterra','generation    ','N',0,0,0,0),('Wairakei Ring','Fonterra','load_offtake  ','N',0.01754879195754507,0.020253703272219946,0.013976911310629798,0.462200384),('Wairakei Ring','Genesis','generation    ','N',1.5823672535524484,1.6689776343060108,1.5307214439138974,34.787099704999996),('Wairakei Ring','Genesis','generation    ','S',0,0,0,0),('Wairakei Ring','Genesis','load_injection','N',0,0,0,0),('Wairakei Ring','Genesis','load_offtake  ','N',0.000775041391204147,0.0008074300879951492,0.0008414170699543092,0.296107799),('Wairakei Ring','Horizon','load_offtake  ','N',0.06649821151118825,0.021140481590049876,0.004883453555859935,2.953612192),('Wairakei Ring','Kiwirail','load_offtake  ','N',0.014179088727244946,0.012587815772078044,0.010905250645969786,0.444220739),('Wairakei Ring','Mainpower','load_offtake  ','S',0.1397915472841155,0.09368848236561728,0.07476351526946,5.74657918),('Wairakei Ring','Marlborough Lines','load_offtake  ','S',0.10785360187876325,0.07335113859044973,0.056776257945588486,4.409257286),('Wairakei Ring','Meridian','generation    ','S',0,0,0,0),('Wairakei Ring','Meridian','load_injection','N',0,0,0,0),('Wairakei Ring','Meridian','load_injection','S',0,0,0,0),('Wairakei Ring','Meridian','load_offtake  ','N',0.0006450025059535339,0.00028017791600671,0.00023670652035775964,0.025828427000000004),('Wairakei Ring','Meridian','load_offtake  ','S',0.001280427839998757,0.000914772669975623,0.0007895804782195966,0.188553002),('Wairakei Ring','Methanex','load_offtake  ','N',0.016146305473844127,0.013584568613694762,0.01228963106692956,0.5473095900000001),('Wairakei Ring','Mokai JV','generation    ','N',0,0,0,0),('Wairakei Ring','MRP','generation    ','N',2.1647186647212915,2.185686609698416,1.9643504523891353,49.893793747000004),('Wairakei Ring','MRP','load_offtake  ','N',0.002412757842832385,0.0035573746305217384,0.004151324640573108,0.061004739),('Wairakei Ring','NAP JV','generation    ','N',1.7857078823231738,2.019283771727441,1.9205582947167492,41.691062207),('Wairakei Ring','Network Tasman','load_offtake  ','S',0.22685009997340425,0.1490795608677878,0.1112680604997766,9.31654651),('Wairakei Ring','Network Waitaki','load_offtake  ','S',0.046732488820950345,0.03916762347778174,0.03402610734021483,1.8851376289999997),('Wairakei Ring','Ngatamariki','generation    ','N',0.9618021598318219,1.0955369699965056,1.071287199360875,22.587018762000003),('Wairakei Ring','Norske Skog','DC            ','N',0.09421214183218096,0.12795477703942404,0.1352405109232606,1.598015653),('Wairakei Ring','Northpower','load_offtake  ','N',0.9359955798108034,0.8675214586257126,0.7962824307857395,27.386556758999998),('Wairakei Ring','NZ Steel','DC            ','N',0.540104735086153,0.5221883247417352,0.5044346845913816,15.258414414),('Wairakei Ring','Orion','load_offtake  ','S',0.9199527489833927,0.591931588028554,0.4397809750900383,37.945864418000006),('Wairakei Ring','Other','load_offtake  ','N',0.05652152818574488,0.05445296948062429,0.05029121085894496,43.36091910900001),('Wairakei Ring','Other','load_offtake  ','S',0.00007870343334209011,0.00005010566498148436,0.000029330327153167382,0.33392149200000004),('Wairakei Ring','Pacific Aluminium','load_offtake  ','S',0.8426174048555315,0.695792809202373,0.676231899597327,32.7143071),('Wairakei Ring','Pacific Steel','load_offtake  ','N',0.18827829079085837,0.16949026214960194,0.13637442294855467,5.678124082),('Wairakei Ring','PanPac','load_offtake  ','N',0,0,0,0),('Wairakei Ring','Pioneer','load_injection','S',0,0,0,0),('Wairakei Ring','Powerco','load_offtake  ','N',2.578870830892056,2.0486489893962303,1.5907126221169954,82.81322580700001),('Wairakei Ring','PowerNet','load_offtake  ','S',0.2827853587745288,0.20797622284473566,0.177800669962681,14.011772185999998),('Wairakei Ring','Rayonier','load_offtake  ','S',0.009337625057299325,0.0077606716756159905,0.0073767496653542475,0.368778166),('Wairakei Ring','Scanpower','load_offtake  ','N',0.028047747739647824,0.018882674856453577,0.014110034745362281,1.0195251),('Wairakei Ring','The Lines Company','load_offtake  ','N',0.16561165327781951,0.1500503709731069,0.1333727637339873,5.223730340999999),('Wairakei Ring','Todd','generation    ','N',0.037312704851720994,0.04464428869325285,0.04114031861572878,0.655503052),('Wairakei Ring','Todd','load_injection','N',0.00002470110923386175,0.00004038465504750891,0.000016348624155089202,0.0005503420000000001),('Wairakei Ring','Todd','load_offtake  ','N',0.00012536633267905706,0.00010021607480691964,0.00012231234892893963,0.0045530200000000005),('Wairakei Ring','Top Energy','load_injection','N',0,0,0,0),('Wairakei Ring','Top Energy','load_offtake  ','N',0.22281829762697633,0.1905316945778138,0.1594636384767295,6.811871709999999),('Wairakei Ring','Trustpower','generation    ','N',0.11392094431521163,0.11359057233034024,0.09613352842358029,1.9220222109999998),('Wairakei Ring','Trustpower','generation    ','S',0,0,0,0),('Wairakei Ring','Trustpower','load_injection','N',0,0,0,0),('Wairakei Ring','Trustpower','load_injection','S',0,0,0,0),('Wairakei Ring','TrustPower','load_offtake  ','N',0.00010448745623736496,0.00008407173232359298,0.00007362075451400744,0.002668229),('Wairakei Ring','TrustPower','load_offtake  ','S',0.000027306314116659688,0.0000523351261300787,0.0000756846522969009,0.000531548),('Wairakei Ring','Unison','load_offtake  ','N',0.40981409512719186,0.3076248774468887,0.1933898633836262,12.817853801000004),('Wairakei Ring','Vector','load_offtake  ','N',8.9881206142275,7.839217302923474,6.857312744666366,269.25775625600005),('Wairakei Ring','Waipa Power','load_offtake  ','N',0.3472261343530079,0.3231227590061052,0.2942776887544098,10.158342494),('Wairakei Ring','WEL','load_offtake  ','N',1.1621452975282107,1.020663038144218,0.889145066797691,34.783137736),('Wairakei Ring','Wellington Electricity','load_offtake  ','N',0.925508451606522,0.5557383307151827,0.36641835568054903,35.310532298),('Wairakei Ring','Westpower','load_offtake  ','S',0.04749269181324419,0.03910490655631237,0.034329823766098215,1.836942817),('Wairakei Ring','Winstones','load_offtake  ','N',0,0,0,0);
