% Total regional electricity demand as indicated by supply measured as exiting the national grid at various supply points.
% This does NOT include consumption supplied by generation stations attached to the local grid within regions.
% Regional definitions are consistent with those used in the Electricity Commission 2010 Statement of Opportunities.
% The following calculations of regional totals have been checked only for data from October 1996 in the Centralised Data Set.

Calculate reg.NI.NorthIsthmusPost96      = NI.Albany + zpad(NI.Breambay) + zpad(NI.Dargaville) + NI.Henderson + NI.Hepburn.Auckland + zpad(NI.Hepburn.Waitemata) + zpad(NI.Kensington) + zpad(pos(NI.Kaikohe)) + zpad(pos(NI.Kaitaia)) + zpad(pos(NI.KaikoheKaitaia)) + zpad(pos(NI.Marsden)) + NI.Maungatapere + NI.Maungaturoto + zpad(NI.Silverdale.Export) + NI.Wellsford %Sum of nett demands on the grid for North Isthmus.
Calculate reg.NI.AucklandPost96          = NI.Bombay + NI.Glenbrook + NI.Meremere + NI.Mangere.City + NI.Mangere.SteelMill + NI.Otahuhu + NI.Pakuranga + NI.Penrose + zpad(pos(NI.Penrose.NZR)) + NI.MountRoskill + zpad(pos(NI.Southdown.NZR)) + NI.Takanini + NI.Wiri + zpad(NI.WairauRoad.33kv) %Sum of nett demands on the grid for Auckland.
Calculate reg.NI.WaikatoPost96           = zpad(pos(NI.AROHENA)) + zpad(pos(NI.Atiamuri)) + pos(NI.CAMBRIDGE) + pos(NI.HAMILTON) + zpad(pos(NI.Huntly.33KV)) + pos(NI.HINUERA) + pos(NI.HANGATIKI) + NI.KINLEITH + pos(NI.KOPU) + pos(NI.Lichfield.T1.Export) + zpad(pos(NI.Lichfield.T2.Export)) + zpad(NI.Maraetai) + zpad(pos(NI.MAROTIRI)) + zpad(pos(NI.MORRINSVILLE)) + zpad(pos(NI.Ngatamariki.PowerStation)) + zpad(pos(NI.OHAAKI)) + zpad(pos(NI.POIHIPI.PowerStation)) + pos(NI.TEAWAMUTU) + zpad(pos(NI.TEKOWHAI.Export)) + zpad(pos(NI.TeMihi.PowerStation)) + pos(NI.WAIHOU) + pos(NI.WAIKINO) + pos(NI.WAIRAKEI.Export) + zpad(pos(NI.WESTERNROAD)) + zpad(pos(NI.WHAKAMARU.33KV)) %Sum of Waikato GXPs - offtake only
Calculate reg.NI.BayOfPlentyPost96       = pos(NI.EDGECUMBE) + zpad(pos(NI.KAITEMAKO)) + NI.Kawerau.Tasman + pos(NI.KAWERAU.TOWN.Export) + pos(NI.Matahina.Export) + NI.MOUNTMAUNGANUI + pos(NI.OWHATA) + NI.ROTORUA + NI.TAURANGA.11KV + NI.Tauranga.33KV.Export + NI.TeMatai + zpad(pos(NI.TARUKENGA)) + zpad(pos(NI.TEKAHA)) + pos(NI.WAIOTAHI) %Sum of Bay of Plenty GXPs - offtake only
Calculate reg.NI.CentralPost96           = pos(NI.BUNNYTHORPE.Export) + pos(NI.BRUNSWICK) + pos(NI.DANNEVIRKE) + pos(NI.LINTON.Export) + pos(NI.MANGAMAIRE) + pos(NI.MANGAHAO) + pos(NI.MARTON) + pos(NI.MATAROA) + pos(NI.NATIONALPARK) + pos(NI.OHAKUNE.A) + pos(NI.OHAKUNE.B) + pos(NI.ONGARUE.Export) + pos(NI.TOKAANU) + pos(NI.Tangiwai.NZR.P1P2Nett.Active.Export) + NI.Tangiwai.Karioi + pos(NI.WOODVILLE) + pos(NI.WANGANUI) + pos(NI.Waipawa) %Sum of Central GXPs - offtake only
Calculate reg.NI.HawkesBayPost96         = pos(NI.FERNHILL) + zpad(pos(NI.GISBORNE.11KV)) + pos(NI.GISBORNE.50KV) + pos(NI.REDCLYFFE) + zpad(pos(NI.TOKOMARUBAY)) + pos(NI.TUAI) + pos(NI.Whirinaki) + pos(NI.WAIROA.11KV.Export) + zpad(pos(NI.WAIROA.50KV)) + pos(NI.WHAKATU) %Sum of Hawke's Bay GXPs - offtake only
Calculate reg.NI.TaranakiPost96          = zpad(pos(NI.CARRINGTON.11KV)) + pos(NI.CARRINGTON.33KV) + pos(NI.Huirangi.Export) + NI.Hawera.110KV.Export + zpad(pos(NI.Hawera.110KV.Whareroa.Export)) + zpad(pos(NI.Hawera.33kv.Export)) + zpad(pos(NI.Hawera.33kv.Kupe)) + zpad(pos(NI.Kaponga.Export)) + zpad(pos(NI.MOTUNUI)) + zpad(pos(NI.MOTUROA)) + zpad(pos(NI.NewPlymouth)) + pos(NI.OPUNAKE) + zpad(pos(NI.Stratford.B.PowerStation)) + pos(NI.STRATFORD) + pos(NI.Taumarunui.NZR.P1P2Nett.Active.Export) + pos(NI.WAVERLEY.11KV) + zpad(pos(NI.Mangahewa.PowerStation)) %Sum of Taranaki GXPs - offtake only
Calculate reg.NI.WellingtonPost96        = pos(NI.CENTRALPARK.11KV) + pos(NI.CENTRALPARK.33KV) + pos(NI.GRACEFIELD) + pos(NI.GREYTOWN.33KV.Export) + pos(NI.HAYWARDS.11KV) + pos(NI.HAYWARDS.33KV) + pos(NI.KAIWHARAWHARA) + pos(NI.MELLING.11KV) + pos(NI.MELLING.33KV) + pos(NI.MASTERTON) + pos(NI.PAUATAHANUI) + pos(NI.PARAPARAUMU) + pos(NI.TAKAPUROAD) + pos(NI.UPPERHUTT) + pos(NI.WILTON) + zpad(pos(NI.Makara.PowerStation.Line2)) + zpad(pos(NI.Makara.PowerStation.Line3)) %Sum of Wellington GXPs - offtake only

Calculate reg.SI.NelsonMarlboroughPost96 = pos(SI.ARGYLE.Export) + pos(SI.BLENHEIM) + pos(SI.Kikiwa) + pos(SI.MOTUEKA) + zpad(pos(SI.MOTUPIPI.33KV)) + zpad(pos(SI.MOTUPIPI.66KV)) + pos(SI.STOKE) %Sum of Nelson Marlborough GXPs - offtake only
Calculate reg.SI.WestCoastPost96         = zpad(pos(SI.ATARAU)) + zpad(pos(SI.Arahura.Export)) + pos(SI.ARTHURSPASS) + pos(SI.CASTLEHILL) + pos(SI.Dobson.Export) + pos(SI.GREYMOUTH.Export) + zpad(pos(SI.Hokitika.Export)) + zpad(pos(SI.KUMARA.Export)) + pos(SI.MURCHISON) + zpad(pos(SI.WESTPORT.OROWAITI.Code1)) + zpad(pos(SI.WESTPORT.OROWAITI.Code2))  + zpad(pos(SI.REEFTON.Export)) + zpad(pos(SI.REEFTON.110KV.Code1))+ zpad(pos(SI.REEFTON.110KV.Code2)) + zpad(pos(SI.Westport.Robertson.Export)) + pos(SI.WESTPORT) + pos(SI.OTIRA.NZR) + zpad(pos(SI.WAIMANGAROA)) %Sum of West Coast GXPs - offtake only
Calculate reg.SI.CanterburyPost96        = SI.Addington + pos(SI.ASHBURTON) + pos(SI.ASHLEY) + pos(SI.BROMLEY.11KV) + pos(SI.BROMLEY.66KV) + zpad(pos(SI.CAIRNBRAE)) + pos(SI.COLERIDGE) + zpad(pos(SI.CULVERDEN.66KV)) + zpad(pos(SI.CULVERDEN.33KV)) + pos(SI.HORORATA.33KV) + zpad(pos(SI.HORORATA.66KV)) + zpad(pos(SI.ISLINGTON.33KV)) + zpad(pos(SI.ISLINGTON.66KV)) + pos(SI.KAIAPOI) + zpad(pos(SI.KAIKOURA)) + zpad(pos(SI.KIMBERLEY.66KV.1.Export)) + zpad (pos(SI.KIMBERLEY.66KV.2.Export)) + zpad(pos(SI.MIDDLETON)) + zpad(pos(SI.PAPANUI.11KV)) + zpad(pos(SI.PAPANUI.66KV)) + pos(SI.SOUTHBROOK.33KV) + pos(SI.SPRINGSTON.33kv) + zpad(pos(SI.SPRINGSTON.66KV.Export)) + pos(SI.WAIPARA) + zpad(pos(SI.WAIPARA.66KV)) %Sum of Canterbury GXPs - offtake only
Calculate reg.SI.SouthCanterburyPost96   = pos(SI.Albury.Export) + pos(SI.TIMARU) + pos(SI.TEKAPO) + zpad(pos(SI.TEMUKA.11KV)) + zpad(pos(SI.TEMUKA.33KV)) + pos(SI.TWIZEL.Canterbury) + zpad(pos(SI.Twizel.mm)) + pos(SI.TWIZEL.WAITAKI) %Sum of South Canterbury GXPs - offtake only
Calculate reg.SI.OtagoSouthlandPost96    = zpad(pos(SI.BellsPond)) + zpad(pos(SI.BLACKPOINT)) + pos(SI.BALCLUTHA) + pos(SI.BERWICK.Export) + pos(SI.BRYDONE) + pos(SI.Cromwell.Export) + pos(SI.Clyde.Export) + pos(SI.EDENDALE.33KV) + pos(SI.FRANKTON) + pos(SI.GORE) + zpad(pos(SI.DUNEDIN.HALFWAYBUSH.Export)) + pos(SI.INVERCARGILL) + pos(SI.NORTHMAKAREWA.Export) + pos(SI.NASEBY.Export) + pos(SI.OAMARU) + pos(SI.PALMERSTON) + pos(SI.DUNEDIN.SOUTH) + pos(SI.STUDHOLME) + pos(TY) + pos(SI.WAITAKI.33KV) + zpad(pos(SI.WINTON.11KV)) + zpad(pos(SI.Winton.66KV.Export)) %Sum of Otago Southland GXPs - offtake only

Calculate reg.NI.TotalPost96             = reg.NI.NorthIsthmusPost96 + reg.NI.AucklandPost96 + reg.NI.WaikatoPost96 + reg.NI.BayOfPlentyPost96 + reg.NI.CentralPost96 + reg.NI.HawkesBayPost96 + reg.NI.TaranakiPost96 + reg.NI.WellingtonPost96 %Sum of all North Island GXPs - offtake only
Calculate reg.SI.TotalPost96             = reg.SI.NelsonMarlboroughPost96 + reg.SI.WestCoastPost96 + reg.SI.CanterburyPost96 + reg.SI.SouthCanterburyPost96 + reg.SI.OtagoSouthlandPost96 %Sum of all South Island GXPs - offtake only

Calculate reg.NZ.TotalPost96             = reg.NI.TotalPost96 + reg.SI.TotalPost96 %Sum of all New Zealand GXPs - offtake only

set fieldwidth = 10 % to avoid numbers running into each other when displaying the various totals series on-screen