Spreadsheet: ad308f4c-d2f7-437a-b61d-4652e52725b8
Sheet: Positive Benefit by region

 |  |  | Retail positive benefit by region (excluding 5 major direct connect customers)
TX region | Region |  | TX region | Pole 2 | Pole3 | NIGUP | NAaN | WRK Ring | WDV_MST | ISL_KIK2
Auckland | UNI |  | Auckland | 0.2319312346801164 | 0.1599883462910892 | 0.2577466010684362 | 0.2308933788077513 | 0.1397082104929276 | 0.08141958469671964 | 0.009942786339093332
Bay of Plenty | CNI |  | Bay of Plenty | 0.06281840482442405 | 0.03505538289706839 | 0.02101637178213258 | 0.03985576477607942 | 0.03099401949964756 | 0.02161973766979289 | 0.002709196139974851
Canterbury | USI |  | Canterbury | 0.01519185809192491 | 0.05525643329628964 | 0.03282095052547844 | 0.04618419391275492 | 0.03577209901643712 | 0.04270682560002973 | 0.06401506384918022
Central | LNI |  | Central | 0.05415438496465652 | 0.03258754842610549 | 0.02487750550597496 | 0.0342968893223295 | 0.02399792300509748 | 0.02243887039799059 | 0.002637645712785976
Hawkes Bay | CNI |  | Hawkes Bay | 0.04211091315426833 | 0.02380058750192358 | 0.01410460152551566 | 0.02648793263013076 | 0.01467171762097291 | 0.01542915095196776 | 0.001847774131019373
Nelson/Marlborough | USI |  | Nelson/Marlborough | 0.004282576274630433 | 0.01566511542887789 | 0.009282960313578205 | 0.01311904768250843 | 0.009866760027738371 | 0.01157710437952416 | 0.5978243520365188
North Isthmus | UNI |  | North Isthmus | 0.1440537284844099 | 0.1020005378340811 | 0.1546386453924155 | 0.2607990289387839 | 0.08710953019299122 | 0.04780443627158878 | 0.00626766328861065
Otago/Southland | LSI |  | Otago/Southland | 0.009845020795127071 | 0.03679051657465546 | 0.02066581926665935 | 0.02971663888054047 | 0.02320549377690007 | 0.027150071952408 | 0.007178645399828276
South Canterbury | LSI |  | South Canterbury | 0.002275571219270108 | 0.00820172410891766 | 0.004709325865962934 | 0.006481311250401528 | 0.005314657627170438 | 0.005837713628629057 | 0.001645072666796551
Taranaki | LNI |  | Taranaki | 0.02860306445086891 | 0.0179437978407129 | 0.01584081771644678 | 0.01857745713004564 | 0.01323527713723859 | 0.01093437513639107 | 0.001205841114425156
Waikato | CNI |  | Waikato | 0.1192867082548441 | 0.08428463261853132 | 0.1052916696523686 | 0.08958997144511527 | 0.0809723147573355 | 0.04404302527907004 | 0.004913447498367481
Wellington | LNI |  | Wellington | 0.1174266732696466 | 0.064908889365434 | 0.04934774710534592 | 0.07107817760850507 | 0.04858969823716788 | 0.07953557925793323 | 0.005934223437367871
West Coast | USI |  | West Coast | 0.001339469907966147 | 0.004901155388701981 | 0.002777996495756441 | 0.003930971202036246 | 0.003142247473695123 | 0.003614411366929451 | 0.1658982989498833
 |  |  | Total | 0.8333196083721536 | 0.6413846675723888 | 0.7131210122160716 | 0.8710107635869825 | 0.5165799488653198 | 0.4141108865889744 | 0.8720200105638518
 |  |  | Retail positive benefit by larger region (excluding 5 major direct connect customers)
 |  |  | Region | Pole 2 | Pole3 | NIGUP | NAaN | WRK Ring | WDV_MST | ISL_KIK2
 |  |  | UNI | 0.3759849631645262 | 0.2619888841251704 | 0.4123852464608516 | 0.4916924077465352 | 0.2268177406859188 | 0.1292240209683084 | 0.01621044962770398
 |  |  | CNI | 0.2242160262335365 | 0.1431406030175233 | 0.1404126429600168 | 0.1559336688513255 | 0.126638051877956 | 0.0810919139008307 | 0.009470417769361705
 |  |  | LNI | 0.2001841226851721 | 0.1154402356322524 | 0.09006607032776766 | 0.1239525240608802 | 0.08582289837950395 | 0.1129088247923149 | 0.009777710264579003
 |  |  | USI | 0.02081390427452149 | 0.0758227041138695 | 0.04488190733481309 | 0.06323421279729959 | 0.04878110651787061 | 0.05789834134648334 | 0.8277377148355823
 |  |  | LSI | 0.01212059201439718 | 0.04499224068357312 | 0.02537514513262229 | 0.03619795013094199 | 0.0285201514040705 | 0.03298778558103706 | 0.008823718066624827
 |  |  | Grand Total | 0.8333196083721534 | 0.6413846675723887 | 0.7131210122160716 | 0.8710107635869824 | 0.5165799488653199 | 0.4141108865889744 | 0.8720200105638519
 |  |  | Positive benefit of major generators and 5 major direct connect cumstomers
 |  |  | Company | Pole 2 | Pole3 | NIGUP | NAaN | WRK Ring | WDV_MST | ISL_KIK2
 |  |  | Contact Energy | 0.01824878773387476 | 0.06212698251632166 | 0.03713794639943547 | 0.005252294149115187 | 0.1230459748616912 | 0.1289005746890072 | 0.02431390477076018
 |  |  | Genesis | 0.01226905782246764 | 0.04190762132599689 | 0.03525490905546282 | 0.01000884074099023 | 0.08832365017239496 | 0.110176981114349 | 0.02275053616397288
 |  |  | Meridian | 0.02839374516265651 | 0.09376881805483418 | 0.01892721131064748 | 0.002447008208367012 | 0.04079000149833598 | 0.144195378800485 | 0.03747665444597684
 |  |  | Mighty River Power | 0.007397839535794881 | 0.02702881154998198 | 0.06471597171250468 | 0.008280077293097078 | 0.1099970981588821 | 0.07868117952101043 | 0.01216203538832674
 |  |  | TrustPower | 0.00363413114737558 | 0.01327719298003438 | 0.01722921690819288 | 0.001747106186343028 | 0.01859777752501657 | 0.0278878235843097 | 0.01318828094862775
 |  |  | Todd Energy | 0.0006219120002423595 | 0.001894674666517664 | 0.004009390084583432 | 0.0004146026219203437 | 0.004050806742335507 | 0.00662353272937969 | 0.0008747897483099776
 |  |  | Other Generators | 0.002352810652624122 | 0.008027574919700695 | 0.02774318642864186 | 0.001462817331827165 | 0.01540594938714985 | 0.02239416175042161 | 0.003116783879913887
 |  |  | New Zealand Steel | 0.03239824536704906 | 0.02384227650371361 | 0.03452089210814011 | 0.02594925213898016 | 0.02094597719337754 | 0.01133924349488052 | 0.001334475436303774
 |  |  | [NAME] | 0.02347782738879079 | 0.01084149707974122 | 0.007209546124387498 | 0.01348915749590403 | 0.01213846242907436 | 0.005557446925164807 | 0.0009195291728387712
 |  |  | Winstone Pulp | 0.007621338158081403 | 0.004647483222000747 | 0.002900941000357127 | 0.004688326710927257 | 0.003736521266120566 | 0.003154228671269853 | 0.0003400911010006871
 |  |  | New Zealand Aluminium Smelters | 0.01811107283868971 | 0.06507897758214816 | 0.03348265213095545 | 0.04810469327552242 | 0.04182751553109294 | 0.04467077008372501 | 0.01107210594345108
 |  |  | [NAME] | 0.01215362382019991 | 0.006173422026619932 | 0.003747124520619908 | 0.007145060260023739 | 0.004560316369208678 | 0.002307792047022902 | 0.0004308024366654336
 |  |  | Total | 0.1666803916278467 | 0.3586153324276111 | 0.2868789877839287 | 0.1289892364130176 | 0.4834200511346802 | 0.5858891134110256 | 0.127979989436148