{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["data","For approval only","Input","Splitting feeder calculation","Unused ASC Allowance","R Form","Before Drwg","After Drwg","Study request guidance notes","G&P application","Cable ratings","ASL calculation","Splitting feeder calculatio (3)","Splitting feeder calculatio (2)","CAF calculator","CAF calculator instructions","Sheet1"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":15,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"data","index":0,"n_rows":377,"n_cols":20,"rows_kept":377,"cut":false,"hidden":true,"merged":[]}
["Primary s/s","£ per kVA","G&P STUDY REQUIRED","Hv diagram area","VOLTAGE",null,"11kV",11000,null,"Size","Continuous","Cyclic","Distribution",null,"Planner","Tel (Internal)","Fax","Area"]
["ALBION ST",0,null,"BLACKBURN","6.6kV",null,"6.6kV",6600,null,"95 XXX",245,277,277,null,"Alan Bradley",81868,81732,"Planning Preston"]
["ALDERLEY",0,null,"PEAK SOUTH","11kV",null,null,null,null,"95 PICAS",185,210,245,null,"Alan Kemp",81834,81841,"Statutory Preston"]
["ALSTON",0,null,"PENRITH","11kV",null,null,null,null,"95 Cu PILC",245,275,330,null,"Alek Hyzniak",22961,22314,"Manchester",null,"OK WITH DIVERSITY"]
["AMBLESIDE",0,null,"KENDAL","11kV",null,null,null,null,"95 Al PILC",190,215,260,null,"Allen Rawcliffe",81468,81503,"Statutory Preston",null,"ALTERNTIVE AVAILABLE"]
["ANCOATS NORTH",0,null,"MANCHESTER NORTH","6.6kV",null,null,null,null,"300 XXX",461,521,521,null,"Andrew Twyford","01524 701423",null,"Planning Kendal",null,"NOT DUE TO NEW LOAD"]
["ANNIE PIT",0,null,"WORKINGTON","11kV",null,null,null,null,"300 PICAS",355,400,490,null,"Andy Lees",22930,22314,"Manchester",null,"RESTORE SUPPLIES BY SPLITTING"]
["ANSDELL",0,null,"BLACKPOOL","6.6kV",null,null,null,null,"300 Cu PILC",460,520,665,null,"Anne Thomson",22139,22314,"Manchester",null,"FEEDER SPLIT TO RESTORE SUPPLIES"]
["ARDWICK",224.7,"LV charges are £153.31. All charges apply until 29/6/2014. Proj ref d.80010717.799","MANCHESTER SOUTH","6.6kV",null,null,null,null,"300 Al PILC",365,410,525,null,"Bill Halliwell",81610,81503,"Statutory Preston",null,"SEE BELOW FOR REDUCED SECTION"]
["ARNSIDE",0,null,"LANCASTER","11kV",null,null,null,null,"240 Cu PILC",410,460,460,null,"Bryan Jenkinson",86128,86009,"Planning Kendal",null,"TO CHECK REDUCED SECTION IN FEEDER"]
["ASHTON ON MERSEY",0,null,"MANCHESTER SOUTH","6.6kV",null,null,null,null,"240 Al PILC",325,365,460,null,"Chris Cliff",26706,26699,"Stockport Planning",null,"EXISTING ARRANGEMENT"]
["ASHTON UNDER LYNE",0,null,"PEAK NORTH","6.6kV",null,null,null,null,"185 XXX",353,399,399,null,"Chris Reilly",86415,null,"Planning Carlisle",null,"PROPOSED ARRANGEMENT"]
["ASHTON-Golborne",0,"Firm Capacity limited by transformer tails. 12.5MVA until replaced","SOUTH LANCS","6.6kV",null,null,null,null,"185 PICAS",270,305,370,null,"Chris Thompson",6557,6442,"Statutory Carlisle",null,"OK IF NO ASC'S EXCEEDED"]
["ASHTON-Ribble",0,null,"PRESTON","6.6kV",null,null,null,null,"185 Cu PILC",355,400,500,null,"Clive Mellor",26695,26699,"Stockport Planning",null,"SCENARIO FOR NO ASC'S EXCEEDED"]
["ASHWOOD DALE",0,null,"PEAK SOUTH","6.6kV",null,null,null,null,"185 Al PILC",280,315,390,null,"Dan Garner",26694,26699,"Stockport Planning",null,"WON'T WORK EVEN WITH SPLITTING"]
["ASKAM",0,null,"BARROW","11kV",null,null,null,null,"120 Cu PILC",280,315,380,null,"Dan Harber",26694,26699,"Stockport Planning",null,"WON'T WORK CAN'T SPLIT"]
["ASKERTON CASTLE",0,null,"CARLISLE","11kV",null,null,null,null,"120 Al PILC",220,245,300,null,"Darren Mycock",22568,22314,"Manchester",null,"SEE NOTE IN FREE FORMAT SECTION"]
["ASPATRIA",0,null,"WORKINGTON","11kV",null,null,null,null,"0.5 Cu",530,600,670,null,"Dave Barlow",81846,81841,"Statutory Preston",null,"FOR EXAMPLE ONLY"]
["ATHERTON TOWN CENTRE",0,null,"SOUTH LANCS","11kV",null,null,null,null,"0.5 Al PILC",420,475,530,null,"Dave Crowdy",86242,86009,"Planning Kendal",null,"NOT CRITICAL"]
["ATHLETIC ST",0,null,"BURNLEY & NELSON","6.6kV",null,null,null,null,"0.4 Cu",475,535,595,null,"Dave Garrett",26696,26699,"Stockport Planning"]
["AVENHAM",0,null,"PRESTON","6.6kV",null,null,null,null,"0.4 Al PILC",375,420,470,null,"David Schofield",81843,81841,"Statutory Preston"]
["BACUP",47.63,"No charge for LV connections. Proj ref d.80014565.799","RAWTENSTALL & ACCRINGTON","6.6kV",null,null,null,null,"0.3 Cu",410,460,500,null,"David Woodworth",75465,75412,"Hill Top"]
["BAGULEY",0,null,"MANCHESTER SOUTH","11kV",null,null,null,null,"0.3 Al PILC",325,365,390,null,"Eric Coope",81813,81841,"Statutory Preston"]
["BAMBER BRIDGE",0,null,"CHORLEY","11kV",null,null,null,null,"0.25 Cu",370,415,440,null,"Eric Rennie",26704,26699,"Stockport Planning"]
["BARBARA ST",0,null,"SOUTH LANCS","6.6kV",null,null,null,null,"0.25 Al",290,325,345,null,"Gary Davies",22849,22314,"Manchester"]
["BARROW",0,null,"BARROW","11kV",null,null,null,null,"0.2 Cu",320,360,385,null,"Gavin Anderson",26692,26699,"Stockport Planning"]
["BARTON DOCK RD",0,null,"MANCHESTER NORTH","6.6kV",null,null,null,null,"0.2 Al",250,280,300,null,"Ged Horton",22049,22314,"Manchester"]
["BEDFORD",0,null,"SOUTH LANCS","11kV",null,null,null,null,"0.15 Cu",270,305,320,null,"Geoff Gill",26703,26699,"Stockport Planning"]
["BELGRAVE",0,null,"PEAK NORTH","6.6kV",null,null,null,null,"0.15 Al",210,235,250,null,"Ian Bradley",26695,26699,"Stockport Planning"]
["BENCHILL",0,null,"MANCHESTER SOUTH","11kV",null,null,null,null,"0.1 Cu",220,245,255,null,"Ian Diffenthal",81857,81732,"Planning Preston"]
["BENTHAM",0,null,"SETTLE","11kV",null,null,null,null,"0.1 Al",170,190,195,null,"Ian McCormack",81760,81732,"Planning Preston"]
["BISPHAM",0,null,"BLACKPOOL","6.6kV",null,null,null,null,"0.06 Cu",160,175,185,null,"Ian Walker",22931,22314,"Manchester"]
["BLACKBULL",195.07,"LV charges are £189.94. All charges apply until 12/10/2014. Proj ref d.80009716.799","PRESTON","6.6kV",null,null,null,null,"0.06 Al",125,135,145,null,"James Johannessen ",26692,26699,"Stockport Planning"]
["BLACKBURN",0,null,"BLACKBURN","6.6kV",null,null,null,null,"0.04 Cu",130,140,145,null,"Jane Newton",22153,22314,"Manchester"]
["BLACKBURN RD CLAYTON",0,null,"RAWTENSTALL & ACCRINGTON","6.6kV",null,null,null,null,"0.04 Al",100,110,110,null,"Jim Butler",22216,22314,"Manchester"]
["BLACKFRIARS",0,null,"MANCHESTER NORTH","6.6kV",null,null,null,null,"0.025 Cu",92,100,100,null,"Jim Henderson",22264,22771,"System Devlopment"]
["BLACKLEY",0,null,"MANCHESTER NORTH","6.6kV",null,null,null,null,"0.025 Al",72,78,78,null,"Joe Davis",81273,81503,"Statutory Preston"]
["BLACKPOOL",0,null,"BLACKPOOL","6.6kV",null,null,null,null,null,null,null,null,null,"John Coulthard",6451,6442,"Statutory Carlisle"]
["BOLLINGTON",0,null,"PEAK SOUTH","11kV",null,null,null,null,null,null,null,null,null,"John Whiting",26703,26699,"Stockport Planning"]
["BOLTON BY BOWLAND",0,null,"11KV","11kV",null,null,null,null,null,null,null,null,null,"John Wilkinson",86028,86009,"Planning Kendal"]
["BOLTON LE SANDS",0,null,"LANCASTER","11kV",null,null,null,null,null,null,null,null,null,"Julian Shepherd",26698,26699,"Stockport Planning"]
["BOTANY BAY",0,null,"CHORLEY","11kV",null,null,null,null,null,null,null,null,null,"Karen McFadden",22111,22314,"Manchester"]
["BOW LANE",0,null,"CHORLEY","11kV",null,null,null,null,null,null,null,null,null,"Keith Nicholls",81110,81503,"Statutory Preston"]
["BOWATERS",0,null,"BARROW","11kV",null,null,null,null,null,null,null,null,null,"Keith Shepherd",88821]
["BOWDON",0,null,"MANCHESTER SOUTH","11kV",null,null,null,null,null,null,null,null,null,"Ken Harper",6440,6442,"Statutory Carlisle"]
["BRADFORD",0,null,"MANCHESTER SOUTH","6.6kV",null,null,null,null,null,null,null,null,null,"Kevin Bullock",86067,86009,"Planning Kendal"]
["BRADSHAWGATE",0,null,"SOUTH LANCS","6.6kV",null,null,null,null,null,null,null,null,null,"Kianoush Naraghipour",26711,26699,"Stockport Planning"]
["BRAMHALL",0,null,"PEAK SOUTH","11kV",null,null,null,null,null,null,null,null,null,"Laura Stelfox",86047,86009,"Planning Kendal"]
["BRIDGEWATER",0,null,"MANCHESTER SOUTH","6.6kV",null,null,null,null,null,null,null,null,null,"Lorraine Lowdon",6210,6146,"Planning Kendal"]
["BRINKSWAY",0,null,"PEAK SOUTH","6.6kV",null,null,null,null,null,null,null,null,null,"Mark Knowles ",81263,81503,"Statutory Preston"]
["BROADHEATH",0,null,"MANCHESTER SOUTH","11kV",null,null,null,null,null,null,null,null,null,"Martin Lord",81854,81732,"Planning Preston"]
["BROADWAY",0,null,"LANCASTER","6.6kV",null,null,null,null,null,null,null,null,null,"Matt Savka",22781,22314,"Manchester"]
["BUCKSHAW",0,null,"CHORLEY","11kV",null,null,null,null,null,null,null,null,null,"Matthew Rigby",26707,26699,"Stockport Planning"]
["BURNLEY CENTRE",0,null,"BURNLEY & NELSON","6.6kV",null,null,null,null,null,null,null,null,null,"Michelle Range",22561,22314,"Manchester"]
["BURNLEY GSP",0,null,"BURNLEY & NELSON","6.6kV",null,null,null,null,null,null,null,null,null,"Mike Henderson",81813,81503,"Statutory Preston"]
["BURNLEY NORTH",0,null,"BURNLEY & NELSON","6.6kV",null,null,null,null,null,null,null,null,null,"Mike Jackson",81839,81503,"Statutory Preston"]
["BURROW BECK",0,"Load transfers to Spring Garden Street chargeable as per Spring Garden Street","LANCASTER","11kV",null,null,null,null,null,null,null,null,null,"Mike Wharton",86196,86009,"Planning Kendal"]
["BURSCOUGH BRIDGE",65.760000000000005,"No charge for LV conenctions. Proj ref d.80014674.799","CHORLEY","11kV",null,null,null,null,null,null,null,null,null,"Neville Hartley",81799,81503,"Statutory Preston"]
["BURY TOWN CTR",0,null,"SOUTH LANCS","6.6kV",null,null,null,null,null,null,null,null,null,"Paul Boyer",22033,22314,"Manchester"]
["BUSHELL ST",195.07,"LV charges are £189.94. All charges apply until 12/10/2014. Proj ref d.80009716.799","PRESTON","6.6kV",null,null,null,null,null,null,null,null,null,"Paul Griffiths",75410,75412,"Hill Top"]
["CAMPBELL ST",0,null,"SOUTH LANCS","11kV",null,null,null,null,null,null,null,null,null,"Paul Robinson",26696,26699,"Stockport Planning"]
["CANNON ST",0,null,"MANCHESTER NORTH","6.6kV",null,null,null,null,null,null,null,null,null,"Paul Thompson",26705,26699,"Stockport Planning"]
["CAPONTREE",0,null,"CARLISLE","11kV",null,null,null,null,null,null,null,null,null,"Peter Range",22018,22314,"Manchester"]
["CARLETON",0,null,"WORKINGTON","11kV",null,null,null,null,null,null,null,null,null,"Dave Ashton",88950]
["CARLISLE (KINGMOOR PK)",193.23,"LV charges are £108.97/kVA. All charges apply until 13/5/2014. Proj ref d.90015308.799","CARLISLE","11kV",null,null,null,null,null,null,null,null,null,"Phil Snape",22287,22771,"System Devlopment"]
["CARR ST",0,null,"SOUTH LANCS","11kV",null,null,null,null,null,null,null,null,null,"Phil Taylor",81771,81841,"Statutory Preston"]
["CASTLETON",0,null,"PEAK NORTH","6.6kV",null,null,null,null,null,null,null,null,null,"Phil Walker",26697,26699,"Stockport Planning"]
["CATTERALL WATERWORKS",0,null,"LANCASTER","6.6kV",null,null,null,null,null,null,null,null,null,"Ray Cramer",22043,22314,"Manchester"]
["CECIL ST",0,null,"BLACKPOOL","6.6kV",null,null,null,null,null,null,null,null,null,"Rachel Rayton",85279,85392,"Manchester"]
["CENTRAL MANCHESTER",188.13,"LV charges are £153.31. HV charges for network connected load £224.70. Sole use of spare CB add £28,865 All charges apply until 29/6/2014. Proj ref d.80010717.799","MANCHESTER NORTH","6.6kV",null,null,null,null,null,null,null,null,null,"Richard Warren",26707,26699,"Stockport Planning"]
["CHADDERTON",0,null,"PEAK NORTH","6.6kV",null,null,null,null,null,null,null,null,null,"Ryan Austin",81861,81732,"Planning Preston"]
["CHAMBERHALL",0,null,"SOUTH LANCS","6.6kV",null,null,null,null,null,null,null,null,null,"Sarah Seabrook",81537,81503,"Planning Preston"]
["CHASSEN RD",0,null,"MANCHESTER NORTH","6.6kV",null,null,null,null,null,null,null,null,null,"Simon Little",86017,86009,"Planning Kendal"]
["CHATSWORTH ST",0,null,"BARROW","11kV",null,null,null,null,null,null,null,null,null,"Steve Hanson",81813,81841,"Statutory Preston"]
["CHEADLE HEATH",0,null,"PEAK SOUTH","6.6kV",null,null,null,null,null,null,null,null,null,"Steve Hitchmough",null,null,"Stockport Planning"]
["CHEADLE HULME",0,null,"MANCHESTER SOUTH","11kV",null,null,null,null,null,null,null,null,null,"Stewart Riley",81847,81732,"Planning Preston"]
["CHEETHAM HILL",0,null,"MANCHESTER NORTH","6.6kV",null,null,null,null,null,null,null,null,null,"Lukasz Bochinski",26708,26699,"Stockport Planning"]
["CHELFORD",0,null,"PEAK SOUTH","11kV",null,null,null,null,null,null,null,null,null,"Stuart Smith",81794,81732,"Planning Preston"]
["CHESTER RD",65.09,"LV connections requiring 3rd Tx £29.29 Charges apply until Sep 2016. Proj ref d.80013710.799","MANCHESTER NORTH","6.6kV",null,null,null,null,null,null,null,null,null,"Stuart Telford",6414,6442,"Statutory Carlisle"]
["CHORLEY SOUTH",65.760000000000005,"No charge for LV connectionsProj ref d.80014674.799","CHORLEY","11kV",null,null,null,null,null,null,null,null,null,"Tony Coughlan",26695,26699,"Stockport Planning"]
["CHORLTON",0,null,"MANCHESTER SOUTH","6.6kV",null,null,null,null,null,null,null,null,null,"Trevor Bloor",26694,26699,"Stockport Planning"]
["CHURCH",0,null,"RAWTENSTALL & ACCRINGTON","6.6kV",null,null,null,null,null,null,null,null,null,"Val Egerton",22075,22314,"Manchester"]
["CLARENDON RD",0,null,"BLACKBURN","6.6kV",null,null,null,null,null,null,null,null,null,"Walter Harris",26697,26699,"Stockport Planning"]
["CLAUGHTON",0,null,"LANCASTER","11kV",null,null,null,null,null,null,null,null,null,"Claire Knight",85313,null,"Manchester"]
["CLEVELEYS",0,null,"BLACKPOOL","6.6kV",null,null,null,null,null,null,null,null,null,"Glenn Hill",86165]
["CLIFTON JUNCTION",0,null,"SOUTH LANCS","11kV",null,null,null,null,null,null,null,null,null,"John Hannah","ENS"]
["CLOVER HILL",0,null,"BURNLEY & NELSON","6.6kV",null,null,null,null,null,null,null,null,null,"Mark Griffiths","ENS"]
["COG LANE",0,null,"BURNLEY & NELSON","6.6kV",null,null,null,null,null,null,null,null,null,"Marius Greef","ENS"]
["CONISTON",0,null,"BARROW","11kV",null,null,null,null,null,null,null,null,null,"Sarah Morris",null,null,"Preston"]
["COPSE RD",0,null,"BLACKPOOL","6.6kV",null,null,null,null,null,null,null,null,null,"Jon Nickson",24896,null,"Hilltop"]
["COX GREEN",0,null,"SOUTH LANCS","11kV",null,null,null,null,null,null,null,null,null,"Spare 8"]
["CRAGGS ROW",195.07,"LV charges are £189.94. All charges apply until 12/10/2014. Proj ref d.80009716.799","PRESTON","6.6kV",null,null,null,null,null,null,null,null,null,"Spare 9"]
["CROWN LANE",0,null,"SOUTH LANCS","11kV",null,null,null,null,null,null,null,null,null,"Spare 10"]
["CULCHETH",0,null,"SOUTH LANCS","11kV",null,null,null,null,null,null,null,null,null,"Spare 11"]
["DALTON",0,null,"BARROW","11kV",null,null,null,null,null,null,null,null,null,"Spare 12"]
["DEANSGATE",0,null,"MANCHESTER NORTH","6.6kV",null,null,null,null,null,null,null,null,null,"Spare 13"]
["DENTON EAST",0,null,"MANCHESTER SOUTH","6.6kV",null,null,null,null,null,null,null,null,null,"Spare 14"]
["DENTON WEST",0,null,"MANCHESTER SOUTH","6.6kV",null,null,null,null,null,null,null,null,null,"Spare 15"]
["DICKINSON ST",224.7,"LV charges are £153.31. All charges apply until 29/6/2014. Proj ref d.80010717.799","MANCHESTER NORTH","6.6kV",null,null,null,null,null,null,null,null,null,"Spare 16"]
["DIDSBURY",0,null,"MANCHESTER SOUTH","6.6kV",null,null,null,null,null,null,null,null,null,"Spare 17"]
["DISLEY",0,null,"PEAK SOUTH","11kV",null,null,null,null,null,null,null,null,null,"Spare 18"]
["DODGSON RD",83.99,"LV charges are £78.86. All charges apply until 12/10/2014. Proj ref d.80009716.799","PRESTON","6.6kV",null,null,null,null,null,null,null,null,null,"Spare 19"]
["DOUGLAS ST",0,null,"PRESTON","6.6kV",null,null,null,null,null,null,null,null,null,"Spare 20"]
["DROYLSDEN EAST",0,null,"MANCHESTER SOUTH","6.6kV",null,null,null,null,null,null,null,null,null,"Spare 21"]
["DUKINFIELD",0,null,"PEAK NORTH","6.6kV",null,null,null,null,null,null,null,null,null,"Spare 22"]
["DUMERS LANE",0,null,"SOUTH LANCS","11kV",null,null,null,null,null,null,null,null,null,"Spare 23"]
["DUMPLINGTON",0,null,"MANCHESTER NORTH","11kV",null,null,null,null,null,null,null,null,null,"Spare 24"]
["EASTLANDS",0,null,"MANCHESTER NORTH","6.6kV",null,null,null,null,null,null,null,null,null,"Spare 25"]
["EASTON",0,null,"CARLISLE","11kV",null,null,null,null,null,null,null,null,null,"Spare 26"]
["EGREMONT",0,null,"WORKINGTON","11kV",null,null,null,null,null,null,null,null,null,"Spare 27"]
["EMBLETON",0,null,"WORKINGTON","11kV",null,null,null,null,null,null,null,null,null,"Spare 28"]
["EXCHANGE ST",0,null,"BLACKBURN","6.6kV"]
["FAILSWORTH",0,null,"MANCHESTER NORTH","6.6kV"]
["FALLOWFIELD",0,null,"MANCHESTER SOUTH","6.6kV"]
["FARNWORTH",0,null,"SOUTH LANCS","11kV"]
["FENISCOWLES",0,null,"BLACKBURN","6.6kV"]
["FERODO",0,null,"PEAK SOUTH","11kV"]
["FLAT LANE",0,null,"SETTLE","11kV"]
["FREDERICK RD",0,null,"MANCHESTER NORTH","6.6kV"]
["FUSE HILL",0,null,"CARLISLE","11kV"]
["GALE",0,null,"PEAK NORTH","6.6kV"]
["GARSTANG",0,null,"LANCASTER","6.6kV"]
["GAS COUNCIL",0,null,"MANCHESTER SOUTH","6.6kV"]
["GATLEY",0,null,"MANCHESTER SOUTH","6.6kV"]
["GIDLOW",0,null,"SOUTH LANCS","6.6kV"]
["GILLSROW",0,null,"PENRITH","11kV"]
["GLAXO",0,null,"BARROW","11kV"]
["GLOSSOP",0,null,"PEAK NORTH","11kV"]
["GOLBORNE",0,null,"SOUTH LANCS","11kV"]
["GOWHOLE",0,null,"PEAK SOUTH","11kV"]
["GRANE RD",47.63,"No charge for LV connections. Proj ref d.80014565.799","RAWTENSTALL & ACCRINGTON","6.6kV"]
["GRANGE",0,null,"BARROW","11kV"]
["GREAT HARWOOD",0,null,"BLACKBURN","6.6kV"]
["GREEN LANE-Altrincham",0,null,"MANCHESTER SOUTH","11kV"]
["GREEN LANE-Hazel Grove",0,null,"PEAK SOUTH","11kV"]
["GREEN ST",0,null,"SOUTH LANCS","6.6kV"]
["GREENFIELD",0,null,"PEAK NORTH","11kV"]
["GREENHILL",0,null,"PEAK NORTH","6.6kV"]
["GRIFFIN",0,null,"BLACKBURN","6.6kV"]
["HADFIELD",0,null,"PEAK NORTH","11kV"]
["HALL CROSS",0,null,"PRESTON","6.6kV"]
["HANDFORTH",0,null,"PEAK SOUTH","11kV"]
["HANGING BRIDGE",65.760000000000005,"No charge for LV connections. Proj ref d.80014674.799","CHORLEY","11kV"]
["HAREHOLME",47.63,"No charge for LV connections. Proj ref d.80014565.799","RAWTENSTALL & ACCRINGTON","6.6kV"]
["HARPURHEY",0,null,"MANCHESTER NORTH","6.6kV"]
["HARWOOD",0,null,"SOUTH LANCS","11kV"]
["HATTERSLEY",0,null,"PEAK NORTH","11kV"]
["HAVERTHWAITE",0,null,"BARROW","11kV"]
["HAWK GREEN",0,null,"PEAK SOUTH","11kV"]
["HAYDOCK",48.15,"No charge for LV connections. Charges applicable until Nov 2013 . Proj ref d.80010901.799","SOUTH LANCS","11kV"]
["HDA NO1",0,null,"WORKINGTON","11kV"]
["HDA NO2",0,null,"WORKINGTON","11kV"]
["HEADY HILL",0,null,"SOUTH LANCS","6.6kV"]
["HEAP BRIDGE",0,null,"SOUTH LANCS","6.6kV"]
["HEASANDFORD",0,null,"BURNLEY & NELSON","6.6kV"]
["HEATON MOOR",0,null,"PEAK SOUTH","6.6kV"]
["HEATON NORRIS",0,null,"PEAK SOUTH","6.6kV"]
["HELWITH BRIDGE",0,null,"SETTLE","11kV"]
["HENSINGHAM",0,null,"WORKINGTON","11kV"]
["HEYROD",0,null,"PEAK NORTH","6.6kV"]
["HEYSIDE",0,null,"PEAK NORTH","6.6kV"]
["HEYWOOD",53.25,"No charge for LV connections. Charges applicable until June 2015 . Proj ref d.80011904.799","SOUTH LANCS","6.6kV"]
["HIGHER MILL",0,null,"MANCHESTER SOUTH","6.6kV"]
["HIGHER WALTON",0,null,"CHORLEY","11kV"]
["HILL TOP",0,null,"SOUTH LANCS","11kV"]
["HINDLEY GREEN",0,null,"SOUTH LANCS","11kV"]
["HOLLINWOOD",0,null,"PEAK NORTH","6.6kV"]
["HOLME RD",0,null,"CHORLEY","11kV"]
["HOLT ST",0,null,"SOUTH LANCS","11kV"]
["HURST",0,null,"PEAK NORTH","6.6kV"]
["HUTTON END",0,null,"PENRITH","11kV"]
["HYDE",0,null,"PEAK NORTH","6.6kV"]
["HYNDBURN RD",0,null,"RAWTENSTALL & ACCRINGTON","6.6kV"]
["INDIA ST",0,null,"BLACKBURN","6.6kV"]
["INGLETON",0,null,"SETTLE","11kV"]
["IRLAM",172.04,"No charge for LV connections. Proj ref d.80016673.799","MANCHESTER NORTH","6.6kV"]
["JAMES ST",0,null,"CARLISLE","11kV"]
["KAY ST",0,null,"RAWTENSTALL & ACCRINGTON","6.6kV"]
["KENDAL (PARKSIDE ROAD)",0,null,"KENDAL","11kV"]
["KESWICK",0,null,"PENRITH","11kV"]
["KINGSWAY",0,null,"PEAK NORTH","11kV"]
["KINKRY HILL",0,null,"CARLISLE","11kV"]
["KIRKBY LONSDALE",0,null,"KENDAL","11kV"]
["KIRKBY MOOR",0,null,"BARROW","11kV"]
["KIRKBY STEPHEN",0,null,"PENRITH","11kV"]
["KIRKBY THORE",0,null,"PENRITH","11kV"]
["KIRKHALL LANE",0,null,"SOUTH LANCS","11kV"]
["KITT GREEN",0,null,"SOUTH LANCS","6.6kV"]
["KNOTT MILL",0,null,"MANCHESTER NORTH","6.6kV"]
["LAMBERHEAD",0,null,"SOUTH LANCS","6.6kV"]
["LANCASTER",0,null,"LANCASTER","11kV"]
["LANGLEY",0,null,"PEAK NORTH","11kV"]
["LANGROYD RD",0,null,"BURNLEY & NELSON","6.6kV"]
["LEIGH",0,null,"SOUTH LANCS","11kV"]
["LEVENSHULME",0,null,"MANCHESTER SOUTH","6.6kV"]
["LEYLAND NATIONAL",0,null,"WORKINGTON","11kV"]
["LITTLE HULTON",0,null,"SOUTH LANCS","11kV"]
["LITTLE SALKELD",0,null,"PENRITH","11kV"]
["LITTLEBOROUGH",0,null,"PEAK NORTH","6.6kV"]
["LONGFORD BRIDGE",0,null,"MANCHESTER NORTH","6.6kV"]
["LONGRIDGE",59.57,"No charge for LV connections. Charges applicable until Sep 2015 Proj ref d.80020410.799","PRESTON","6.6kV"]
["LONGRIDGE VIA AUTO TFR.",59.57,"No charge for LV connections. Charges applicable until Sep 2015 Proj ref d.80020410.799","11kV (FROM PRESTON)","11kV"]
["LONGSIGHT",0,null,"MANCHESTER SOUTH","6.6kV"]
["LOSTOCK",0,null,"SOUTH LANCS","11kV"]
["LOWER DARWEN",0,null,"BLACKBURN","6.6kV"]
["LYONS RD",0,null,"MANCHESTER NORTH","6.6kV"]
["MANCHESTER AIRPORT PLC",0,null,"MANCHESTER SOUTH","11kV"]
["MANCHESTER UNIVERSITY",0,null,"MANCHESTER SOUTH","6.6kV"]
["MARPLE",0,null,"PEAK SOUTH","11kV"]
["MARTON",0,null,"BLACKPOOL","6.6kV"]
["MARYPORT",0,null,"WORKINGTON","11kV"]
["MEDIA CITY",0,null,"MANCHESTER NORTH","6.6kV"]
["MELLING",0,null,"LANCASTER","11kV"]
["MERESIDE",0,null,"BLACKPOOL","6.6kV"]
["MIDDLETON JUNCTION",0,null,"PEAK NORTH","11kV"]
["MIDWAY",0,null,"WORKINGTON","11kV"]
["MILNROW",0,null,"PEAK NORTH","6.6kV"]
["MINTSFEET",0,null,"KENDAL","11kV"]
["MONSALL",0,null,"MANCHESTER NORTH","6.6kV"]
["MONTON",0,null,"MANCHESTER NORTH","6.6kV"]
["MOORSIDE",0,null,"PRESTON","6.6kV"]
["MORTON PK",0,null,"CARLISLE","11kV"]
["MOSLEY RD",0,null,"MANCHESTER NORTH","6.6kV"]
["MOSS LN",0,null,"SOUTH LANCS","11kV"]
["MOSS NOOK",0,null,"MANCHESTER SOUTH","11kV"]
["MOSS SIDE (Leyland)",0,null,"CHORLEY","11kV"]
["MOSS SIDE (Longsight)",0,null,"MANCHESTER SOUTH","6.6kV"]
["MOSSLEY",0,null,"PEAK NORTH","11kV"]
["MOUNT ST",0,null,"MANCHESTER NORTH","6.6kV"]
["MUSGRAVE RD",0,null,"SOUTH LANCS","6.6kV"]
["NELSON",10.32,"LV charges are £10.32. All charges apply until 14/10/2015. Proj ref d.80007588.799","BURNLEY & NELSON","6.6kV"]
["NEW MOSTON",0,null,"MANCHESTER NORTH","6.6kV"]
["NEWBIGGIN ON LUNE",0,null,"PENRITH","11kV"]
["NEWBY",0,null,"PENRITH","11kV"]
["NEWTONGATE",0,null,"PENRITH","11kV"]
["NEWTON HEATH",0,null,"MANCHESTER NORTH","6.6kV"]
["NEWTON LE WILLOWS",0,null,"SOUTH LANCS","11kV"]
["NORBRECK",0,null,"BLACKPOOL","6.6kV"]
["NORBURY",0,null,"PEAK SOUTH","11kV"]
["NORTHENDEN",0,null,"MANCHESTER SOUTH","6.6kV"]
["NWGB PARTINGTON",0,null,"MANCHESTER SOUTH","6.6kV"]
["OFFERTON",0,null,"PEAK SOUTH","6.6kV"]
["OPENSHAW",0,null,"MANCHESTER SOUTH","6.6kV"]
["ORMSKIRK",0,null,"CHORLEY","11kV"]
["PADIHAM",0,null,"11KV","11kV"]
["PEEL ST",0,"BEWARE 33kV ISSUES, PLEASE SEEK NETWORK STRATEGY ADVICE","11KV","11kV"]
["PENDLETON",0,null,"MANCHESTER NORTH","6.6kV"]
["PENRITH",0,null,"PENRITH","11kV"]
["PETTERIL BANK",0,null,"CARLISLE","11kV"]
["PHILLIPS LANE",0,null,"BURNLEY & NELSON","6.6kV"]
["PICCADILLY",224.7,"Please refer to SOEDC data, contributions apply","MANCHESTER NORTH","6.6kV"]
["PIMBO",0,null,"SOUTH LANCS","11kV"]
["PIRELLI",0,null,"CARLISLE","11kV"]
["PORTWOOD",0,null,"PEAK SOUTH","6.6kV"]
["POULTON",0,null,"BLACKPOOL","6.6kV"]
["POYNTON",0,null,"PEAK SOUTH","11kV"]
["PREESALL",0,null,"LANCASTER","11kV"]
["PRESTON OLD RD",0,null,"BLACKPOOL","6.6kV"]
["PRESTON EAST",65.819999999999993,"LV charges are £60.69. Add £13.01 for use of spare breaker. All charges apply until 12/10/2014. Proj ref d.80009716.799","PRESTON","6.6kV"]
["PRESTWICH",0,null,"MANCHESTER NORTH","6.6kV"]
["PRINGLE ST",0,null,"BLACKBURN","6.6kV"]
["PRINNY HILL",47.63,"No charge for LV connections. Proj ref d.80014565.799","RAWTENSTALL & ACCRINGTON","6.6kV"]
["QUAYSIDE",0,null,"MANCHESTER NORTH","11kV"]
["QUEENS PARK",0,null,"MANCHESTER NORTH","6.6kV"]
["RADCLIFFE",0,null,"SOUTH LANCS","11kV"]
["RADCLIFFE VIA LOMAX ST.",0,"VOLTAGE CHANGE AT AUTO-TRANSFORMER","SOUTH LANCS","6.6kV"]
["RANDAL ST",0,null,"BLACKBURN","6.6kV"]
["RAWTENSTALL RD",187.42,"LV charges are £107.76. Proj ref d.80014565","RAWTENSTALL & ACCRINGTON","6.6kV"]
["REDDISH VALE",0,null,"PEAK SOUTH","6.6kV"]
["RIBBLESDALE T13",0,"BEWARE 33kV ISSUES, PLEASE SEEK NETWORK STRATEGY ADVICE","11KV","11kV"]
["RIBBLESDALE T14",0,"BEWARE 33kV ISSUES, PLEASE SEEK NETWORK STRATEGY ADVICE","11KV","11kV"]
["RIBBLETON",195.07,"LV charges are £189.94. All charges apply until 12/10/2014. Proj ref d.80009716.799","PRESTON","6.6kV"]
["RINGLEY",0,null,"SOUTH LANCS","11kV"]
["RISLEY",0,null,"SOUTH LANCS","11kV"]
["ROAN EDGE",0,null,"MANCHESTER NORTH","11kV"]
["ROBERT HALL ST",0,null,"MANCHESTER NORTH","6.6kV"]
["ROCHDALE CENTRAL",0,null,"PEAK NORTH","6.6kV"]
["ROMAN RD",0,null,"BLACKBURN","6.6kV"]
["ROMILEY",0,null,"PEAK SOUTH","11kV"]
["ROSSALL",0,null,"BLACKPOOL","6.6kV"]
["ROYTON",0,null,"PEAK NORTH","6.6kV"]
["S.E. MACCLESFIELD",0,null,"PEAK SOUTH","11kV"]
["S.W. MACCLESFIELD",0,null,"PEAK SOUTH","11kV"]
["SALE",0,null,"MANCHESTER SOUTH","6.6kV"]
["SALE MOOR",0,null,"MANCHESTER SOUTH","6.6kV"]
["SALFORD CENTRAL",199.13,"LV charges are £66.78. All charges apply until 10/09/2016. Proj ref d.90021258.799","MANCHESTER NORTH","6.6kV"]
["SALFORD QUAYS",0,null,"MANCHESTER NORTH","6.6kV"]
["SAMLESBURY",0,null,"PRESTON","6.6kV"]
["SANDGATE",0,null,"BARROW","11kV"]
["SCARISBRICK",0,null,"CHORLEY","11kV"]
["SEBERGHAM",0,null,"CARLISLE","11kV"]
["SEDBERGH",0,null,"KENDAL","11kV"]
["SELSMIRE",0,null,"PENRITH","11kV"]
["SETTLE",0,null,"SETTLE","11kV"]
["SEVEN STARS",0,null,"CHORLEY","11kV"]
["SHANNON ST",0,null,"BLACKPOOL","6.6kV"]
["SHAP",0,null,"PENRITH","11kV"]
["SHAW",0,null,"PEAK NORTH","6.6kV"]
["SIDDICK",0,null,"WORKINGTON","11kV"]
["SILLOTH",0,null,"CARLISLE","11kV"]
["SKELMERSDALE",0,null,"SOUTH LANCS","11kV"]
["SKELTON C",0,null,"PENRITH","11kV"]
["SLIPWAY",0,null,"WORKINGTON","11kV"]
["SNIPE",0,null,"PEAK NORTH","6.6kV"]
["SOUTH PARK",0,null,"BLACKPOOL","11kV"]
["SPA RD",0,null,"SOUTH LANCS","6.6kV"]
["SPOTLAND",0,null,"PEAK NORTH","6.6kV"]
["SPRING COTTAGE",0,null,"BURNLEY & NELSON","6.6kV"]
["SPRING GARDEN ST",0,null,"LANCASTER","6.6kV"]
["SPRING GARDEN ST (PHASE 2(11kV))",57.36,"LV charges are £44.51/kVA. All charges apply until 25/10/2016 . Proj ref d.80012767.799","LANCASTER","11kV"]
["SQUIRES GATE",36,"No charge for LV connections. All charges apply until 01/05/2012. Proj ref d.80010055.799","BLACKPOOL","6.6kV"]
["ST ANNES",0,null,"BLACKPOOL","6.6kV"]
["ST MARYS",0,null,"PEAK NORTH","6.6kV"]
["ST MARYS ST",0,null,"PRESTON","6.6kV"]
["ST THOMAS RD",0,null,"BLACKPOOL","6.6kV"]
["STAINBURN",0,null,"WORKINGTON","11kV"]
["STANDISH",0,null,"SOUTH LANCS","11kV"]
["STRANGEWAYS",0,null,"MANCHESTER NORTH","6.6kV"]
["STRAWBERRY BANK",0,null,"RAWTENSTALL & ACCRINGTON","6.6kV"]
["STUART ST",0,null,"MANCHESTER NORTH","6.6kV"]
["STUBBINS",47.63,"No charge for LV connections. Proj ref d.80014565.799","SOUTH LANCS","11kV"]
["SWINTON",0,null,"SOUTH LANCS","11kV"]
["TAME VALLEY",0,null,"PEAK NORTH","6.6kV"]
["TARDY GATE",0,null,"CHORLEY","11kV"]
["TARLETON",128.9,"No charge for LV connections. Proj ref d.80015235.799","CHORLEY","11kV"]
["THE HEIGHT",0,null,"MANCHESTER NORTH","6.6kV"]
["THORNTON",0,null,"BLACKPOOL","11kV"]
["TOWNLEY ST",0,null,"PEAK NORTH","11kV"]
["TRAFFORD",0,null,"MANCHESTER NORTH","6.6kV"]
["TRAFFORD PARK NORTH",0,null,"MANCHESTER NORTH","6.6kV"]
["TRAVIS STREET",0,null,"MANCHESTER NORTH","6.6kV"]
["TRIMPELL",0,null,"LANCASTER","11kV"]
["TRINITY",0,null,"MANCHESTER NORTH","6.6kV"]
["TULKETH",0,null,"PRESTON","6.6kV"]
["ULVERSTON",0,null,"BARROW","11kV"]
["UNION RD",0,null,"SOUTH LANCS","6.6kV"]
["UPHOLLAND",0,null,"SOUTH LANCS","11kV"]
["URMSTON",0,null,"MANCHESTER NORTH","6.6kV"]
["VICKERS CENTRAL",0,null,"BARROW","11kV"]
["VICTORIA PARK",0,null,"MANCHESTER SOUTH","6.6kV"]
["WARBRECK",0,null,"BLACKPOOL","6.6kV"]
["WARDLEWORTH",0,null,"PEAK NORTH","6.6kV"]
["WARTON",0,"LV/HV Interactivity applies, refer to G&P","PRESTON","6.6kV"]
["WATERHEAD",0,null,"PEAK NORTH","6.6kV"]
["WATERSWALLOWS",0,null,"PEAK SOUTH","11kV"]
["WEASTE",0,null,"MANCHESTER NORTH","6.6kV"]
["WERNETH",0,null,"PEAK NORTH","6.6kV"]
["WESLEY PLACE BACUP",47.63,"No charge for LV connections. Proj ref d.80014565.799","RAWTENSTALL & ACCRINGTON","6.6kV"]
["WEST DIDSBURY",0,null,"MANCHESTER SOUTH","6.6kV"]
["WESTGATE",0,null,"LANCASTER","6.6kV"]
["WESTHOUGHTON",0,null,"SOUTH LANCS","11kV"]
["WESTLINTON",0,null,"CARLISLE","11kV"]
["WHALLEY",0,"BEWARE 33kV ISSUES, PLEASE SEEK NETWORK STRATEGY ADVICE","11KV","11kV"]
["WHALLEY RANGE",0,null,"MANCHESTER SOUTH","6.6kV"]
["WHASSET",0,null,"KENDAL","11kV"]
["WHINFELL",0,null,"PENRITH","11kV"]
["WHITTLE LE WOODS",0,null,"CHORLEY","11kV"]
["WHITWORTH",0,null,"PEAK NORTH","6.6kV"]
["WIGTON",0,null,"CARLISLE","11kV"]
["WILLOW HEY",0,null,"SOUTH LANCS","11kV"]
["WILLOWBANK",0,null,"PEAK NORTH","6.6kV"]
["WILLOWHOLME",0,null,"CARLISLE","11kV"]
["WILMSLOW",0,null,"PEAK SOUTH","11kV"]
["WINDERMERE",0,null,"KENDAL","11kV"]
["WINIFRED RD",0,null,"PEAK SOUTH","6.6kV"]
["WITHINGTON",0,null,"MANCHESTER SOUTH","6.6kV"]
["WITHYFOLD DRIVE",0,null,"PEAK SOUTH","11kV"]
["WOODBINE ST",0,null,"PEAK NORTH","6.6kV"]
["WOODFIELD RD",65.760000000000005,"No charge for LV connections. Proj ref d.80014674.799","CHORLEY","11kV"]
["WOODHILL LANE",0,null,"LANCASTER","6.6kV"]
["WOODHOUSE PARK",0,null,"MANCHESTER SOUTH","11kV"]
["WOODLEY",0,null,"PEAK SOUTH","11kV"]
["WOOLFOLD",0,null,"SOUTH LANCS","11kV"]
["WORDSWORTH ST",0,null,"SOUTH LANCS","6.6kV"]
["WORSLEY MESNES",0,null,"SOUTH LANCS","6.6kV"]
["WRIGHTINGTON",65.760000000000005,"No charge for LV connections. Proj ref d.80014674.799","CHORLEY","11kV"]
["YEALAND",0,null,"LANCASTER","11kV"]

{"sheet":"For approval only","index":1,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":true,"merged":[[10,0,11,5]]}
["NC"]
[{"$f":"Input!L9","v":0},"kVA"]
[]
["R11/11/11"]
[]
[{"$f":"Input!L4","v":0}]
[{"$f":"Input!G1","v":""}]
[{"$f":"Input!E6","v":0}]
[{"$f":"'R Form'!E55","v":{"$error":"#N/A"}}]
[{"$f":"Input!E3","v":0}]
[]
[]
[]
[]
[]
[]
[]
["HV DIAG.  ",{"$f":"Input!E14","v":{"$error":"#N/A"}}]
["PROJ. NO.",{"$f":"A6","v":0}]
["PRIMARY",{"$f":"Input!E12","v":0}]
["FEEDER",{"$f":"'R Form'!F10","v":{"$error":"#N/A"}}]
["G.REF.",{"$f":"'R Form'!#REF!&+'R Form'!#REF!&\".\"&+'R Form'!#REF!","v":{"$error":"#REF!"}}]
["REQ. REASON",{"$f":"A1","v":"NC"}]
["REQ. DESC.",{"$f":"Input!E3","v":0}]
["ADD LOAD",{"$f":"A2","v":0}]
["REQUESTED BY",{"$f":"A8","v":0}]

{"sheet":"Input","index":2,"n_rows":94,"n_cols":54,"rows_kept":94,"cut":false,"hidden":false,"merged":[[67,10,67,13],[63,3,63,6],[62,10,62,13],[63,10,63,13],[69,10,69,13],[90,3,90,6],[90,10,90,13],[83,10,83,13],[67,3,67,6],[74,3,74,6],[71,5,72,6],[87,5,88,6],[87,12,88,13],[80,12,81,13],[83,3,83,6],[79,3,79,6],[79,10,79,13],[85,3,85,6],[86,3,86,6],[86,10,86,13],[80,5,81,6],[55,3,55,6],[56,3,56,6],[62,3,62,6],[71,12,72,13],[78,3,78,6],[69,3,69,6],[70,3,70,6],[70,10,70,13],[64,12,65,13],[60,10,60,13],[64,5,65,6],[60,3,60,6],[57,5,58,6],[78,10,78,13],[57,12,58,13],[74,10,74,13],[3,11,3,12],[2,4,3,8],[22,1,22,4],[23,1,23,4],[2,11,2,12],[20,1,20,4],[21,1,21,4],[8,8,9,10],[7,4,7,5],[11,4,12,5],[11,1,12,3],[18,1,18,4],[8,4,8,5],[9,4,9,5],[8,6,8,7],[9,6,9,7],[53,3,53,6],[46,3,46,6],[43,5,44,6],[50,5,51,6],[13,4,13,5],[41,3,41,6],[30,1,30,4],[24,1,24,4],[25,1,25,4],[28,1,28,4],[27,1,27,4],[85,10,85,13],[5,4,5,5],[50,12,51,13],[43,12,44,13],[26,1,26,4],[49,3,49,6],[19,1,19,4],[17,1,17,4],[48,3,48,6],[29,1,29,4],[42,10,42,13],[41,10,41,13],[42,3,42,6],[31,1,31,4],[38,1,38,4],[37,1,37,7],[48,10,48,13],[49,10,49,13],[55,10,55,13],[56,10,56,13],[46,10,46,13],[53,10,53,13]]}
[null,"LOADCHECK - R form calculation sheet -",null,null,null,null,{"$f":"IF('R Form'!O15=\"\",\"\",'R Form'!O15)","v":""},null,null,null,null,null,{"$f":"'R Form'!E66","v":"Version3 (11/02/2014)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please Select From List...","Please Select From List..."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,"SOEDC RELATED",null,{"$f":"VLOOKUP(T11,U2:V3,2,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed","Automation"]
[null,null,null,"Scheme Name and address:",null,null,null,null,null,null,"Date:",null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Committed","Diversion"]
[null,null,null,null,null,null,null,null,null,null,"Scheme number:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cancelled","Sw Gr Change"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((L6-L8)>999,\"G&P STUDY REQUIRED\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Completed","ESQCR"]
[null,null,null,"Planner:",null,null,"Tel:",{"$f":"VLOOKUP(E6,data!O2:R83,2,0)","v":{"$error":"#N/A"}},null,null,"Proposed MIC:",null,null,"Proposed MEC:",null,"kVA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Generation"]
[null,null,null,null,null,null,"Fax:",{"$f":"VLOOKUP(E6,data!O2:R83,3,0)","v":{"$error":"#N/A"}},null,null,"Existing MIC:",null,null,"Existing MEC:",null,"kVA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reinforcement"]
[null,null,null,"Voltage:",null,null,null,null,null,null,"Existing demand of customer:",null,"kVA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C2C"]
[null,null,null,"Status:",null,null,{"$f":"IF(E9=\"Please Select From List...\",\"REQUIRED FIELD\",\"\")","v":""},null,"Additional load on network:",null,null,{"$f":"L6-L8","v":0},"kVA",null,null,null,null,null,null,null,{"$f":"VLOOKUP(E8,data!G1:H2,2,0)","v":{"$error":"#N/A"}},{"$f":"IF(U9=6600,6.6,11)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOP move"]
[null,null,null,"Type:",null,null,{"$f":"IF(E10=\"Please Select From List...\",\"REQUIRED FIELD\",\"\")","v":""},null,null,null,null,{"$f":"IF(L6=\"\",\"\",SUM((L6-L8)*1000)/(U9*SQRT(3)))","v":""},"Amps",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asset Removal"]
[null,null,null,null,{"$f":"IF(Y12=0,\"\",Y12)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add Load"]
[null,"Primary Substation the load will be connected on:",null,null,null,null,null,null,null,null,"Number of customers accociated with this connection:",null,"Consumers",null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(E12,data!A2:C377,3,0)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Connection IDNO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Connection Stat"]
[null,null,null,"HV diagram area:",{"$f":"VLOOKUP(E12,data!A2:E377,4,0)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Connection ICP"]
[null,null,null,"Reinforcement charge:",{"$f":"VLOOKUP(E12,data!A2:C377,2,0)","v":{"$error":"#N/A"}},"per kVA",null,null,null,null,null,null,null,null,null,null,null,null,null,"YES",{"$f":"L10","v":""},{"$f":"L12","v":0}]
[null,null,null,"Customer charge:",{"$f":"SUM(E15*(L6-L7))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO",0,0]
[]
[null,"Feeder name:",null,null,null,"Cable type (1st section):","Primary CB / CT rating          or other restriction * :","Normal peak load (FLA):","Customer numbers on feeder:","New load to be connected to this feeder:","Unused ASC on this feeder:","Proposed Customers on feeder:","Total feeder load:","Spare amps (Distribution):","Spare amps (Cyclic):","Spare amps (Continuous):",null,null,null,"Load","Customers","Cable Dist","Cable Cyc","Cable Cont","CB","Rating Dist:","Rating cyc","Rating cont"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'Unused ASC Allowance'!G12","v":{"$error":"#N/A"}},{"$f":"IF(J19=\"\",\"\",SUM(I19+U19))","v":""},{"$f":"IF(J19=\"\",\"\",SUM(H19+K19+T19))","v":""},{"$f":"IF(J19=\"\",\"\",Z19-M19)","v":""},{"$f":"IF(J19=\"\",\"\",AA19-M19)","v":""},{"$f":"IF(J19=\"\",\"\",AB19-M19)","v":""},null,null,null,{"$f":"VLOOKUP(J19,$T$15:$V$16,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(J19,$T$15:$V$16,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F19,data!$J$2:$M$37,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F19,data!$J$2:$M$37,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F19,data!$J$2:$M$37,2,0)","v":{"$error":"#N/A"}},{"$f":"G19","v":0},{"$f":"MIN(V19,Y19)","v":{"$error":"#N/A"}},{"$f":"MIN(W19,Y19)","v":{"$error":"#N/A"}},{"$f":"MIN(X19,Y19)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'Unused ASC Allowance'!G23","v":{"$error":"#N/A"}},{"$f":"IF(J20=\"\",\"\",SUM(I20+U20))","v":""},{"$f":"IF(J20=\"\",\"\",SUM(H20+K20+T20))","v":""},{"$f":"IF(J20=\"\",\"\",Z20-M20)","v":""},{"$f":"IF(J20=\"\",\"\",AA20-M20)","v":""},{"$f":"IF(J20=\"\",\"\",AB20-M20)","v":""},null,null,null,{"$f":"VLOOKUP(J20,$T$15:$V$16,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(J20,$T$15:$V$16,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F20,data!$J$2:$M$37,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F20,data!$J$2:$M$37,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F20,data!$J$2:$M$37,2,0)","v":{"$error":"#N/A"}},0,{"$f":"MIN(V20,Y20)","v":{"$error":"#N/A"}},{"$f":"MIN(W20,Y20)","v":{"$error":"#N/A"}},{"$f":"MIN(X20,Y20)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'Unused ASC Allowance'!G34","v":{"$error":"#N/A"}},{"$f":"IF(J21=\"\",\"\",SUM(I21+U21))","v":""},{"$f":"IF(J21=\"\",\"\",SUM(H21+K21+T21))","v":""},"","","",null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"VLOOKUP(F21,data!$J$2:$M$37,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F21,data!$J$2:$M$37,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F21,data!$J$2:$M$37,2,0)","v":{"$error":"#N/A"}},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'Unused ASC Allowance'!G45","v":{"$error":"#N/A"}},{"$f":"IF(J22=\"\",\"\",SUM(I22+U22))","v":""},"","","","",null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"VLOOKUP(F22,data!$J$2:$M$37,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F22,data!$J$2:$M$37,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F22,data!$J$2:$M$37,2,0)","v":{"$error":"#N/A"}},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,".",null,null,null,null,null,null,null,null,{"$f":"'Unused ASC Allowance'!G56","v":{"$error":"#N/A"}},"","","","","",null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"VLOOKUP(F23,data!$J$2:$M$37,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F23,data!$J$2:$M$37,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F23,data!$J$2:$M$37,2,0)","v":{"$error":"#N/A"}},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,".",null,null,null,null,null,null,null,null,{"$f":"'Unused ASC Allowance'!G67","v":{"$error":"#N/A"}},"","","","","",null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"VLOOKUP(F24,data!$J$2:$M$37,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F24,data!$J$2:$M$37,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F24,data!$J$2:$M$37,2,0)","v":{"$error":"#N/A"}},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,".",null,null,null,null,null,null,null,null,{"$f":"'Unused ASC Allowance'!G78","v":{"$error":"#N/A"}},"","","","","",null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"VLOOKUP(F25,data!$J$2:$M$37,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F25,data!$J$2:$M$37,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F25,data!$J$2:$M$37,2,0)","v":{"$error":"#N/A"}},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,".",null,null,null,null,null,null,null,null,{"$f":"'Unused ASC Allowance'!G89","v":{"$error":"#N/A"}},"","","","","",null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"VLOOKUP(F26,data!$J$2:$M$37,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F26,data!$J$2:$M$37,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F26,data!$J$2:$M$37,2,0)","v":{"$error":"#N/A"}},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,".",null,null,null,null,null,null,null,null,{"$f":"'Unused ASC Allowance'!G100","v":{"$error":"#N/A"}},"","","","","",null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"VLOOKUP(F27,data!$J$2:$M$37,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F27,data!$J$2:$M$37,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F27,data!$J$2:$M$37,2,0)","v":{"$error":"#N/A"}},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,".",null,null,null,null,null,null,null,null,{"$f":"'Unused ASC Allowance'!G111","v":{"$error":"#N/A"}},"","","","","",null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"VLOOKUP(F28,data!$J$2:$M$37,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F28,data!$J$2:$M$37,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F28,data!$J$2:$M$37,2,0)","v":{"$error":"#N/A"}},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,".",null,null,null,null,null,null,null,null,{"$f":"'Unused ASC Allowance'!G122","v":{"$error":"#N/A"}},"","","","","",null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"VLOOKUP(F29,data!$J$2:$M$37,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F29,data!$J$2:$M$37,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F29,data!$J$2:$M$37,2,0)","v":{"$error":"#N/A"}},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,".",null,null,null,null,null,null,null,null,{"$f":"'Unused ASC Allowance'!G133","v":{"$error":"#N/A"}},"","","","","",null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"VLOOKUP(F30,data!$J$2:$M$37,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F30,data!$J$2:$M$37,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F30,data!$J$2:$M$37,2,0)","v":{"$error":"#N/A"}},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,".",null,null,null,null,null,null,null,null,{"$f":"'Unused ASC Allowance'!G144","v":{"$error":"#N/A"}},"","","","","",null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"VLOOKUP(F31,data!$J$2:$M$37,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F31,data!$J$2:$M$37,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F31,data!$J$2:$M$37,2,0)","v":{"$error":"#N/A"}},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,".",null,null,null,null,null,null,null,null,{"$f":"'Unused ASC Allowance'!G155","v":{"$error":"#N/A"}},"","","","","",null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"VLOOKUP(F32,data!$J$2:$M$37,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F32,data!$J$2:$M$37,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F32,data!$J$2:$M$37,2,0)","v":{"$error":"#N/A"}},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"* NOTE:   An overhead conductor rating can be entered here if network is overhead. "]
[]
[]
[]
[]
[null,"Outage scenarios",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G1=\"\",\"\",G1)","v":""}]
[]
[]
[]
[null,1,"Outage on:",null,null,null,null,null,2,"Outage on:",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D42,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K42,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}}]
[null,null,"Pick up on:",null,null,null,null,null,null,"Pick up on:",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D43,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K43,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}},null,"Using Distribution rating","Using Cyclic rating","Using Continuous Rating"]
[null,null,"Rating of feeder:",{"$f":"IF(Z44=0,\"\",Z44)","v":""},"Amps","Using Distribution rating",null,null,null,"Rating of feeder:",{"$f":"IF(Z45=0,\"\",Z45)","v":""},"Amps","Using Distribution rating",null,null,null,null,null,null,null,null,null,{"$f":"IF(($F$44=$W$43),IF(D43=\"\",\"\",VLOOKUP(D43,$B$19:$AB$32,25,0)))","v":""},{"$f":"IF(($F$44=$X$43),IF(D43=\"\",\"\",VLOOKUP(D43,$B$19:$AB$32,26,0)))","v":false},{"$f":"IF(($F$44=$Y$43),IF(D43=\"\",\"\",VLOOKUP(D43,$B$19:$AB$32,27,0)))","v":false},{"$f":"MAX(W44:Y44)","v":0}]
[null,null,"Total load on feeder:",{"$f":"IF(D44=\"\",\"\",SUM(T42:T43))","v":""},"Amps",null,null,null,null,"Total load on feeder:",{"$f":"IF(K44=\"\",\"\",SUM(U42:U43))","v":""},"Amps",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($M$44=W43),IF(K43=\"\",\"\",VLOOKUP($K$43,$B$19:AB33,25,0)))","v":""},{"$f":"IF(($M$44=X43),IF(K43=\"\",\"\",VLOOKUP($K$43,$B$19:AC33,26,0)))","v":false},{"$f":"IF(($M$44=Y43),IF(K43=\"\",\"\",VLOOKUP($K$43,$B$19:AD33,27,0)))","v":false},0]
[null,null,"Acceptable:",{"$f":"IF(AND(D45=\"\",D44=\"\"),\"\",IF(D45>D44,\"NO\",\"YES\"))","v":""},null,"Spare amps:",{"$f":"IF(D44=\"\",\"\",SUM(D44-D45))","v":""},null,null,"Acceptable:",{"$f":"IF(AND(K45=\"\",K44=\"\"),\"\",IF(K45>K44,\"NO\",\"YES\"))","v":""},null,"Spare amps:",{"$f":"IF(K44=\"\",\"\",SUM(K44-K45))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(($F$51=W43),IF(D50=\"\",\"\",VLOOKUP($D$50,$B$19:$AB$32,25,0)))","v":""},{"$f":"IF(($F$51=X43),IF(D50=\"\",\"\",VLOOKUP($D$50,$B$19:$AB$32,26,0)))","v":false},{"$f":"IF(($F$51=Y43),IF(D50=\"\",\"\",VLOOKUP($D$50,$B$19:$AB$32,27,0)))","v":false},0]
[null,null,"Comments:",null,null,null,null,null,null,"Comments:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($M$51=W43),IF(K50=\"\",\"\",VLOOKUP($K$50,$B$19:$AB$32,25,0)))","v":""},{"$f":"IF(($M$51=X43),IF(K50=\"\",\"\",VLOOKUP($K$50,$B$19:$AB$32,26,0)))","v":false},{"$f":"IF(($M$51=Y43),IF(K50=\"\",\"\",VLOOKUP($K$50,$B$19:$AB$32,27,0)))","v":false},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D49,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K49,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}},null,{"$f":"IF(($F$58=W43),IF(D57=\"\",\"\",VLOOKUP($D$57,$B$19:$AB$32,25,0)))","v":""},{"$f":"IF(($F$58=X43),IF(D57=\"\",\"\",VLOOKUP($D$57,$B$19:$AB$32,26,0)))","v":false},{"$f":"IF(($F$58=Y43),IF(D57=\"\",\"\",VLOOKUP($D$57,$B$19:$AB$32,27,0)))","v":false},0]
[null,3,"Outage on:",null,null,null,null,null,4,"Outage on:",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D50,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K50,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}},null,{"$f":"IF(($M$58=W43),IF(K57=\"\",\"\",VLOOKUP($K$57,$B$19:$AB$32,25,0)))","v":""},{"$f":"IF(($M$58=X43),IF(K57=\"\",\"\",VLOOKUP($K$57,$B$19:$AB$32,26,0)))","v":false},{"$f":"IF(($M$58=Y43),IF(K57=\"\",\"\",VLOOKUP($K$57,$B$19:$AB$32,27,0)))","v":false},0]
[null,null,"Pick up on:",null,null,null,null,null,null,"Pick up on:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($F$65=W43),IF(D64=\"\",\"\",VLOOKUP($D$64,$B$19:$AB$32,25,0)))","v":""},{"$f":"IF(($F$65=X43),IF(D64=\"\",\"\",VLOOKUP($D$64,$B$19:$AB$32,26,0)))","v":false},{"$f":"IF(($F$65=Y43),IF(D64=\"\",\"\",VLOOKUP($D$64,$B$19:$AB$32,27,0)))","v":false},0]
[null,null,"Rating of feeder:",{"$f":"IF(Z46=0,\"\",Z46)","v":""},"Amps","Using Distribution rating",null,null,null,"Rating of feeder:",{"$f":"IF(Z47=0,\"\",Z47)","v":""},"Amps","Using Distribution rating",null,null,null,null,null,null,null,null,null,{"$f":"IF(($M$65=W43),IF(K64=\"\",\"\",VLOOKUP($K$64,$B$19:$AB$32,25,0)))","v":""},{"$f":"IF(($M$65=X43),IF(K64=\"\",\"\",VLOOKUP($K$64,$B$19:$AB$32,26,0)))","v":false},{"$f":"IF(($M$65=Y43),IF(K64=\"\",\"\",VLOOKUP($K$64,$B$19:$AB$32,27,0)))","v":false},0]
[null,null,"Total load on feeder:",{"$f":"IF(D51=\"\",\"\",SUM(T48:T49))","v":""},"Amps",null,null,null,null,"Total load on feeder:",{"$f":"IF(K51=\"\",\"\",SUM(U48:U49))","v":""},"Amps",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($F$72=W43),IF(D71=\"\",\"\",VLOOKUP($D$71,$B$19:$AB$32,25,0)))","v":""},{"$f":"IF(($F$72=X43),IF(D71=\"\",\"\",VLOOKUP($D$71,$B$19:$AB$32,26,0)))","v":false},{"$f":"IF(($F$72=Y43),IF(D71=\"\",\"\",VLOOKUP($D$71,$B$19:$AB$32,27,0)))","v":false},0]
[null,null,"Acceptable:",{"$f":"IF(AND(D52=\"\",D51=\"\"),\"\",IF(D52>D51,\"NO\",\"YES\"))","v":""},null,"Spare amps:",{"$f":"IF(D51=\"\",\"\",SUM(D51-D52))","v":""},null,null,"Acceptable:",{"$f":"IF(AND(K52=\"\",K51=\"\"),\"\",IF(K52>K51,\"NO\",\"YES\"))","v":""},null,"Spare amps:",{"$f":"IF(K51=\"\",\"\",SUM(K51-K52))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(($M$72=W43),IF(K71=\"\",\"\",VLOOKUP($K$71,$B$19:$AB$32,25,0)))","v":""},{"$f":"IF(($M$72=X43),IF(K71=\"\",\"\",VLOOKUP($K$71,$B$19:$AB$32,26,0)))","v":false},{"$f":"IF(($M$72=Y43),IF(K71=\"\",\"\",VLOOKUP($K$71,$B$19:$AB$32,27,0)))","v":false},0]
[null,null,"Comments:",null,null,null,null,null,null,"Comments:",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D56,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K56,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}},null,{"$f":"IF(($F$81=W43),IF(D80=\"\",\"\",VLOOKUP($D$80,$B$19:$AB$32,25,0)))","v":""},{"$f":"IF(($F$81=X43),IF(D80=\"\",\"\",VLOOKUP($D$80,$B$19:$AB$32,26,0)))","v":false},{"$f":"IF(($F$81=Y43),IF(D80=\"\",\"\",VLOOKUP($D$80,$B$19:$AB$32,27,0)))","v":false},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D57,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K57,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}},null,{"$f":"IF(($M$81=W43),IF(K80=\"\",\"\",VLOOKUP($K$80,$B$19:$AB$32,25,0)))","v":""},{"$f":"IF(($M$81=X43),IF(K80=\"\",\"\",VLOOKUP($K$80,$B$19:$AB$32,26,0)))","v":false},{"$f":"IF(($M$81=Y43),IF(K80=\"\",\"\",VLOOKUP($K$80,$B$19:$AB$32,27,0)))","v":false},0]
[null,5,"Outage on:",null,null,null,null,null,6,"Outage on:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($F$88=W43),IF(D87=\"\",\"\",VLOOKUP($D$87,$B$19:$AB$32,25,0)))","v":""},{"$f":"IF(($F$88=X43),IF(D87=\"\",\"\",VLOOKUP($D$87,$B$19:$AB$32,26,0)))","v":false},{"$f":"IF(($F$88=Y43),IF(D87=\"\",\"\",VLOOKUP($D$87,$B$19:$AB$32,27,0)))","v":false},0]
[null,null,"Pick up on:",null,null,null,null,null,null,"Pick up on:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($M$88=W43),IF(K87=\"\",\"\",VLOOKUP($K$87,$B$19:$AB$32,25,0)))","v":""},{"$f":"IF(($M$88=X43),IF(K87=\"\",\"\",VLOOKUP($K$87,$B$19:$AB$32,26,0)))","v":false},{"$f":"IF(($M$88=Y43),IF(K87=\"\",\"\",VLOOKUP($K$87,$B$19:$AB$32,27,0)))","v":false},0]
[null,null,"Rating of feeder:",{"$f":"IF(Z48=0,\"\",Z48)","v":""},"Amps","Using Distribution rating",null,null,null,"Rating of feeder:",{"$f":"IF(Z49=0,\"\",Z49)","v":""},"Amps","Using Distribution rating"]
[null,null,"Total load on feeder:",{"$f":"IF(D58=\"\",\"\",SUM(T54:T55))","v":""},"Amps",null,null,null,null,"Total load on feeder:",{"$f":"IF(K58=\"\",\"\",SUM(U54:U55))","v":""},"Amps"]
[null,null,"Acceptable:",{"$f":"IF(AND(D59=\"\",D58=\"\"),\"\",IF(D59>D58,\"NO\",\"YES\"))","v":""},null,"Spare amps:",{"$f":"IF(D58=\"\",\"\",SUM(D58-D59))","v":""},null,null,"Acceptable:",{"$f":"IF(AND(K59=\"\",K58=\"\"),\"\",IF(K59>K58,\"NO\",\"YES\"))","v":""},null,"Spare amps:",{"$f":"IF(K58=\"\",\"\",SUM(K58-K59))","v":""},null,null,null,null,null,{"$f":"VLOOKUP(D63,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K63,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}}]
[null,null,"Comments:",null,null,null,null,null,null,"Comments:",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D64,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K64,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}}]
[]
[null,7,"Outage on:",null,null,null,null,null,8,"Outage on:"]
[null,null,"Pick up on:",null,null,null,null,null,null,"Pick up on:"]
[null,null,"Rating of feeder:",{"$f":"IF(Z50=0,\"\",Z50)","v":""},"Amps","Using Distribution rating",null,null,null,"Rating of feeder:",{"$f":"IF(Z51=0,\"\",Z51)","v":""},"Amps","Using Distribution rating"]
[null,null,"Total load on feeder:",{"$f":"IF(D65=\"\",\"\",SUM(T60:T61))","v":""},"Amps",null,null,null,null,"Total load on feeder:",{"$f":"IF(K65=\"\",\"\",SUM(U60:U61))","v":""},"Amps",null,null,null,null,null,null,null,{"$f":"VLOOKUP(D70,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K70,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}}]
[null,null,"Acceptable:",{"$f":"IF(AND(D66=\"\",D65=\"\"),\"\",IF(D66>D65,\"NO\",\"YES\"))","v":""},null,"Spare amps:",{"$f":"IF(D65=\"\",\"\",SUM(D65-D66))","v":""},null,null,"Acceptable:",{"$f":"IF(AND(K66=\"\",K65=\"\"),\"\",IF(K66>K65,\"NO\",\"YES\"))","v":""},null,"Spare amps:",{"$f":"IF(K65=\"\",\"\",SUM(K65-K66))","v":""},null,null,null,null,null,{"$f":"VLOOKUP(D71,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K71,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}}]
[null,null,"omments:",null,null,null,null,null,null,"Comments:"]
[]
[null,9,"Outage on:",null,null,null,null,null,10,"Outage on:"]
[null,null,"Pick up on:",null,null,null,null,null,null,"Pick up on:"]
[null,null,"Rating of feeder:",{"$f":"IF(Z52=0,\"\",Z52)","v":""},"Amps","Using Distribution rating",null,null,null,"Rating of feeder:",{"$f":"IF(Z53=0,\"\",Z53)","v":""},"Amps","Using Distribution rating",null,null,null,null,null,null,{"$f":"VLOOKUP(D79,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K79,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}}]
[null,null,"Total load on feeder:",{"$f":"IF(D72=\"\",\"\",SUM(T66:T67))","v":""},"Amps",null,null,null,null,"Total load on feeder:",{"$f":"IF(K72=\"\",\"\",SUM(U66:U67))","v":""},"Amps",null,null,null,null,null,null,null,{"$f":"VLOOKUP(D80,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K80,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}}]
[null,null,"Acceptable:",{"$f":"IF(AND(D73=\"\",D72=\"\"),\"\",IF(D73>D72,\"NO\",\"YES\"))","v":""},null,"Spare amps:",{"$f":"IF(D72=\"\",\"\",SUM(D72-D73))","v":""},null,null,"Acceptable:",{"$f":"IF(AND(K73=\"\",K72=\"\"),\"\",IF(K73>K72,\"NO\",\"YES\"))","v":""},null,"Spare amps:",{"$f":"IF(K72=\"\",\"\",SUM(K72-K73))","v":""}]
[null,null,"Comments:",null,null,null,null,null,null,"Comments:"]
[]
[]
[]
[null,11,"Outage on:",null,null,null,null,null,12,"Outage on:",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D86,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K86,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}}]
[null,null,"Pick up on:",null,null,null,null,null,null,"Pick up on:",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D87,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K87,$B$19:$N$32,12,0)","v":{"$error":"#N/A"}}]
[null,null,"Rating of feeder:",{"$f":"IF(Z54=0,\"\",Z54)","v":""},"Amps","Using Distribution rating",null,null,null,"Rating of feeder:",{"$f":"IF(Z55=0,\"\",Z55)","v":""},"Amps","Using Distribution rating"]
[null,null,"Total load on feeder:",{"$f":"IF(D81=\"\",\"\",SUM(T72:T73))","v":""},"Amps",null,null,null,null,"Total load on feeder:",{"$f":"IF(K81=\"\",\"\",SUM(U72:U73))","v":""},"Amps"]
[null,null,"Acceptable:",{"$f":"IF(AND(D82=\"\",D81=\"\"),\"\",IF(D82>D81,\"NO\",\"YES\"))","v":""},null,"Spare amps:",{"$f":"IF(D81=\"\",\"\",SUM(D81-D82))","v":""},null,null,"Acceptable:",{"$f":"IF(AND(K82=\"\",K81=\"\"),\"\",IF(K82>K81,\"NO\",\"YES\"))","v":""},null,"Spare amps:",{"$f":"IF(K81=\"\",\"\",SUM(K81-K82))","v":""}]
[null,null,"Comments:",null,null,null,null,null,null,"Comments:"]
[]
[null,13,"Outage on:",null,null,null,null,null,14,"Outage on:"]
[null,null,"Pick up on:",null,null,null,null,null,null,"Pick up on:"]
[null,null,"Rating of feeder:",{"$f":"IF(Z56=0,\"\",Z56)","v":""},"Amps","Using Distribution rating",null,null,null,"Rating of feeder:",{"$f":"IF(Z57=0,\"\",Z57)","v":""},"Amps","Using Distribution rating"]
[null,null,"Total load on feeder:",{"$f":"IF(D88=\"\",\"\",SUM(T79:T80))","v":""},"Amps",null,null,null,null,"Total load on feeder:",{"$f":"IF(K88=\"\",\"\",SUM(U79:U80))","v":""},"Amps"]
[null,null,"Acceptable:",{"$f":"IF(AND(D89=\"\",D88=\"\"),\"\",IF(D89>D88,\"NO\",\"YES\"))","v":""},null,"Spare amps:",{"$f":"IF(D88=\"\",\"\",SUM(D88-D89))","v":""},null,null,"Acceptable:",{"$f":"IF(AND(K89=\"\",K88=\"\"),\"\",IF(K89>K88,\"NO\",\"YES\"))","v":""},null,"Spare amps:",{"$f":"IF(K88=\"\",\"\",SUM(K88-K89))","v":""}]
[null,null,"Comments:",null,null,null,null,null,null,"Comments:"]
[]
[null,{"$f":"IF(G1=\"\",\"\",G1)","v":""}]
[null,"Free format notes:"]

{"sheet":"Splitting feeder calculation","index":3,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":true,"merged":[[2,2,2,3],[2,5,2,6],[0,1,0,6]]}
["Feeder Name:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!U9","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Diversity"]
["Substation name","Substation number","MD of Tx",null,null,"Diversified load (Amps)",null,null,null,null,null,null,null,{"$f":"C28/C27","v":{"$error":"#N/A"}}]
["Duddon Road",616064,500,"kVA",{"$f":"SUM(C4*1000)/($N$1*SQRT(3))","v":{"$error":"#N/A"}},{"$f":"SUM((C4*1000)/($N$1*SQRT(3)))*$C$30","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,false,{"$f":"IF(N4=TRUE,F4,0)","v":0},{"$f":"IF(N4=FALSE,F4,0)","v":{"$error":"#N/A"}}]
["St Georges Square",618006,400,"kVA",{"$f":"SUM(C5*1000)/($N$1*SQRT(3))","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,null,null,null,null,null,false,{"$f":"IF(N5=TRUE,F5,0)","v":0},{"$f":"IF(N5=FALSE,F5,0)","v":{"$error":"#N/A"}}]
["Haverigg Windfarm 'D'",619460,40,"kVA",{"$f":"SUM(C6*1000)/($N$1*SQRT(3))","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Back Duke St.",616006,360,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Kings Quarry",616009,415,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Lowther Rd",616007,325,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Moor End",610087,15,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Oxenbows",610078,200,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Moor Cotts",610087,500,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Back Albert St.",616012,800,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Queens Street",616015,600,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Effluent Pump",616222,200,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Wellington Street",616016,100,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Furness Street",616019,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Argyle Street",616014,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Hearfields",616232,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
[null,null,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
[null,null,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
[null,null,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
[null,null,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
[null,null,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
[null,null,null,"kVA",{"$f":"SUM(C25*1000)/($N$1*SQRT(3))","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
[null,"Total load (MD):",{"$f":"SUM(C4:C25)","v":4455},"kVA",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O4:O25)","v":0},{"$f":"SUM(P4:P25)","v":{"$error":"#N/A"}}]
[null,"Total load (MD):",{"$f":"SUM(C26*1000)/($N$1*SQRT(3))","v":{"$error":"#N/A"}},"Amps"]
[null,"FLA load on feeder:",200,"Amps"]
[null,"Calculated Diversity:",{"$f":"N3","v":{"$error":"#N/A"}},null,null,{"$f":"IF(C29<0.5,\"VERY LOW DIVERSITY\",IF(C29>0.71,\"\",\"LOW DIVERSITY\"))","v":{"$error":"#N/A"}}]
[null,"User Input Diversity:",{"$f":"C29","v":{"$error":"#N/A"}}]
[null,"Checked boxes:",{"$f":"O26","v":0},"Amps"]
[null,"Un checked boxes:",{"$f":"P26","v":{"$error":"#N/A"}},"Amps"]

{"sheet":"Unused ASC Allowance","index":4,"n_rows":155,"n_cols":10,"rows_kept":155,"cut":false,"hidden":false,"merged":[[154,0,154,5],[47,0,47,7],[124,0,124,7],[132,0,132,5],[135,0,135,7],[143,0,143,5],[146,0,146,7],[102,0,102,7],[110,0,110,5],[113,0,113,7],[58,0,58,7],[66,0,66,5],[69,0,69,7],[77,0,77,5],[121,0,121,5],[80,0,80,7],[88,0,88,5],[91,0,91,7],[99,0,99,5],[11,0,11,5],[11,18,11,23],[55,0,55,5],[36,0,36,7],[44,0,44,5],[3,0,3,7],[14,0,14,7],[22,0,22,5],[25,0,25,7],[33,0,33,5]]}
["Unused ASC (existing and future customers)"]
[]
[]
[{"$f":"Input!B19","v":0}]
["Customer","MPAN","ASC","MD","Unused","Factor","Results"]
[null,null,null,null,{"$f":"IF(C6=\"\",\"\",SUM(C6-D6))","v":""},0,{"$f":"IF(F6=0,\"\",SUM(F6*E6))","v":""},null,null,{"$f":"Input!U9","v":{"$error":"#N/A"}}]
[null,null,null,null,"",0,"",null,null,{"$f":"SUM(G6:G11)","v":0}]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
["Total",null,null,null,null,null,{"$f":"SUM(((J7)*1000)/(J6*SQRT(3)))","v":{"$error":"#N/A"}},"Amps"]
[]
[]
[{"$f":"Input!B20","v":0}]
["Customer","MPAN","ASC","MD","Unused","Factor","Results"]
[null,null,null,null,{"$f":"IF(C17=\"\",\"\",SUM(C17-D17))","v":""},0,{"$f":"IF(F17=0,\"\",SUM(F17*E17))","v":""},null,null,{"$f":"Input!U9","v":{"$error":"#N/A"}}]
[null,null,null,null,"",0,"",null,null,{"$f":"SUM(G17:G22)","v":0}]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
["Total",null,null,null,null,null,{"$f":"SUM(((J18)*1000)/(J17*SQRT(3)))","v":{"$error":"#N/A"}},"Amps"]
[]
[]
[{"$f":"Input!B21","v":0}]
["Customer","MPAN","ASC","MD","Unused","Factor","Results"]
[null,null,null,null,{"$f":"IF(C28=\"\",\"\",SUM(C28-D28))","v":""},0,{"$f":"IF(F28=0,\"\",SUM(F28*E28))","v":""},null,null,{"$f":"Input!U9","v":{"$error":"#N/A"}}]
[null,null,null,null,"",0,"",null,null,{"$f":"SUM(G28:G33)","v":0}]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
["Total",null,null,null,null,null,{"$f":"SUM(((J29)*1000)/(J28*SQRT(3)))","v":{"$error":"#N/A"}},"Amps"]
[]
[]
[{"$f":"Input!B22","v":0}]
["Customer","MPAN","ASC","MD","Unused","Factor","Results"]
[null,null,null,null,{"$f":"IF(C39=\"\",\"\",SUM(C39-D39))","v":""},0,{"$f":"IF(F39=0,\"\",SUM(F39*E39))","v":""},null,null,{"$f":"Input!U9","v":{"$error":"#N/A"}}]
[null,null,null,null,"",0,"",null,null,{"$f":"SUM(G39:G44)","v":0}]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
["Total",null,null,null,null,null,{"$f":"SUM(((J40)*1000)/(J39*SQRT(3)))","v":{"$error":"#N/A"}},"Amps"]
[]
[]
[{"$f":"Input!B23","v":"."}]
["Customer","MPAN","ASC","MD","Unused","Factor","Results"]
[null,null,null,null,{"$f":"IF(C50=\"\",\"\",SUM(C50-D50))","v":""},0,{"$f":"IF(F50=0,\"\",SUM(F50*E50))","v":""},null,null,{"$f":"Input!U9","v":{"$error":"#N/A"}}]
[null,null,null,null,"",0,"",null,null,{"$f":"SUM(G50:G55)","v":0}]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
["Total",null,null,null,null,null,{"$f":"SUM(((J51)*1000)/(J50*SQRT(3)))","v":{"$error":"#N/A"}},"Amps"]
[]
[]
[{"$f":"Input!B24","v":"."}]
["Customer","MPAN","ASC","MD","Unused","Factor","Results"]
[null,null,null,null,{"$f":"IF(C61=\"\",\"\",SUM(C61-D61))","v":""},0,{"$f":"IF(F61=0,\"\",SUM(F61*E61))","v":""},null,null,{"$f":"Input!U9","v":{"$error":"#N/A"}}]
[null,null,null,null,"",0,"",null,null,{"$f":"SUM(G61:G66)","v":0}]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
["Total",null,null,null,null,null,{"$f":"SUM(((J62)*1000)/(J61*SQRT(3)))","v":{"$error":"#N/A"}},"Amps"]
[]
[]
[{"$f":"Input!B25","v":"."}]
["Customer","MPAN","ASC","MD","Unused","Factor","Results"]
[null,null,null,null,{"$f":"IF(C72=\"\",\"\",SUM(C72-D72))","v":""},0,{"$f":"IF(F72=0,\"\",SUM(F72*E72))","v":""},null,null,{"$f":"Input!U9","v":{"$error":"#N/A"}}]
[null,null,null,null,"",0,"",null,null,{"$f":"SUM(G72:G77)","v":0}]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
["Total",null,null,null,null,null,{"$f":"SUM(((J73)*1000)/(J72*SQRT(3)))","v":{"$error":"#N/A"}},"Amps"]
[]
[]
[{"$f":"Input!B26","v":"."}]
["Customer","MPAN","ASC","MD","Unused","Factor","Results"]
[null,null,null,null,{"$f":"IF(C83=\"\",\"\",SUM(C83-D83))","v":""},0,{"$f":"IF(F83=0,\"\",SUM(F83*E83))","v":""},null,null,{"$f":"Input!U9","v":{"$error":"#N/A"}}]
[null,null,null,null,"",0,"",null,null,{"$f":"SUM(G83:G88)","v":0}]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
["Total",null,null,null,null,null,{"$f":"SUM(((J84)*1000)/(J83*SQRT(3)))","v":{"$error":"#N/A"}},"Amps"]
[]
[]
[{"$f":"Input!B27","v":"."}]
["Customer","MPAN","ASC","MD","Unused","Factor","Results"]
[null,null,null,null,{"$f":"IF(C94=\"\",\"\",SUM(C94-D94))","v":""},0,{"$f":"IF(F94=0,\"\",SUM(F94*E94))","v":""},null,null,{"$f":"Input!U9","v":{"$error":"#N/A"}}]
[null,null,null,null,"",0,"",null,null,{"$f":"SUM(G94:G99)","v":0}]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
["Total",null,null,null,null,null,{"$f":"SUM(((J95)*1000)/(J94*SQRT(3)))","v":{"$error":"#N/A"}},"Amps"]
[]
[]
[{"$f":"Input!B28","v":"."}]
["Customer","MPAN","ASC","MD","Unused","Factor","Results"]
[null,null,null,null,{"$f":"IF(C105=\"\",\"\",SUM(C105-D105))","v":""},0,{"$f":"IF(F105=0,\"\",SUM(F105*E105))","v":""},null,null,{"$f":"Input!U9","v":{"$error":"#N/A"}}]
[null,null,null,null,"",0,"",null,null,{"$f":"SUM(G105:G110)","v":0}]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
["Total",null,null,null,null,null,{"$f":"SUM(((J106)*1000)/(J105*SQRT(3)))","v":{"$error":"#N/A"}},"Amps"]
[]
[]
[{"$f":"Input!B29","v":"."}]
["Customer","MPAN","ASC","MD","Unused","Factor","Results"]
[null,null,null,null,{"$f":"IF(C116=\"\",\"\",SUM(C116-D116))","v":""},0,{"$f":"IF(F116=0,\"\",SUM(F116*E116))","v":""},null,null,{"$f":"Input!U9","v":{"$error":"#N/A"}}]
[null,null,null,null,"",0,"",null,null,{"$f":"SUM(G116:G121)","v":0}]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
["Total",null,null,null,null,null,{"$f":"SUM(((J117)*1000)/(J116*SQRT(3)))","v":{"$error":"#N/A"}},"Amps"]
[]
[]
[{"$f":"Input!B30","v":"."}]
["Customer","MPAN","ASC","MD","Unused","Factor","Results"]
[null,null,null,null,{"$f":"IF(C127=\"\",\"\",SUM(C127-D127))","v":""},0,{"$f":"IF(F127=0,\"\",SUM(F127*E127))","v":""},null,null,{"$f":"Input!U9","v":{"$error":"#N/A"}}]
[null,null,null,null,"",0,"",null,null,{"$f":"SUM(G127:G132)","v":0}]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
["Total",null,null,null,null,null,{"$f":"SUM(((J128)*1000)/(J127*SQRT(3)))","v":{"$error":"#N/A"}},"Amps"]
[]
[]
[{"$f":"Input!B31","v":"."}]
["Customer","MPAN","ASC","MD","Unused","Factor","Results"]
[null,null,null,null,{"$f":"IF(C138=\"\",\"\",SUM(C138-D138))","v":""},0,{"$f":"IF(F138=0,\"\",SUM(F138*E138))","v":""},null,null,{"$f":"Input!U9","v":{"$error":"#N/A"}}]
[null,null,null,null,"",0,"",null,null,{"$f":"SUM(G138:G143)","v":0}]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
["Total",null,null,null,null,null,{"$f":"SUM(((J139)*1000)/(J138*SQRT(3)))","v":{"$error":"#N/A"}},"Amps"]
[]
[]
[{"$f":"Input!B32","v":"."}]
["Customer","MPAN","ASC","MD","Unused","Factor","Results"]
[null,null,null,null,{"$f":"IF(C149=\"\",\"\",SUM(C149-D149))","v":""},0,{"$f":"IF(F149=0,\"\",SUM(F149*E149))","v":""},null,null,{"$f":"Input!U9","v":{"$error":"#N/A"}}]
[null,null,null,null,"",0,"",null,null,{"$f":"SUM(G149:G154)","v":0}]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
[null,null,null,null,"",0,""]
["Total",null,null,null,null,null,{"$f":"SUM(((J150)*1000)/(J149*SQRT(3)))","v":{"$error":"#N/A"}},"Amps"]

{"sheet":"R Form","index":5,"n_rows":67,"n_cols":28,"rows_kept":67,"cut":false,"hidden":false,"merged":[[7,4,7,10],[7,14,7,20],[7,1,7,3],[7,11,7,13],[65,8,65,10],[65,18,65,20],[64,14,64,17],[65,14,65,17],[64,1,64,3],[65,1,65,3],[64,4,64,7],[65,4,65,7],[64,11,64,13],[65,11,65,13],[64,8,64,10],[64,18,64,20],[14,1,15,7],[11,9,11,10],[11,5,11,6],[14,14,15,20],[11,1,11,4],[12,1,13,6],[11,7,11,8],[9,11,10,15],[8,5,8,10],[9,5,9,10],[10,5,10,8],[10,9,10,10],[5,18,6,19],[5,11,6,17],[6,4,6,5],[6,8,6,10],[3,4,5,10],[16,11,16,20],[50,14,51,15],[52,14,53,15],[48,1,49,3],[48,4,49,10],[50,1,51,3],[50,4,51,10],[52,1,53,3],[52,4,53,10],[44,1,45,12],[46,3,47,15],[16,1,16,10],[56,1,57,3],[56,4,57,10],[62,1,62,20],[50,16,51,20],[52,16,53,20],[54,11,59,13],[54,14,55,15],[54,16,55,20],[56,14,57,15],[56,16,57,20],[58,14,59,15],[58,16,59,20],[58,1,59,3],[58,4,59,10],[54,1,55,3],[54,4,55,10],[1,1,1,13],[66,3,66,18],[3,1,4,3],[42,1,43,20],[9,16,10,20],[11,14,11,20],[17,1,41,10],[17,11,41,20],[5,20,6,20],[46,16,47,20],[2,1,2,10],[48,16,49,20],[60,1,61,6],[60,8,61,20],[48,11,53,13],[48,14,49,15]]}
[null,"REQUEST FOR ALTERATION TO HV SYSTEM 'R' FORM"]
[null,"Approval of this form must not be taken as an endorsement of the Health & Safety, technical or economic merits of the proposed alteration (see EDP 282, 4.1)."]
[]
[null,{"$f":"Input!D3","v":"Scheme Name and address:"},null,null,{"$f":"Input!E3","v":0},null,null,null,null,null,null,null,null,"Existing MIC:",{"$f":"Input!L7","v":0},"kVA",null,null,"Proposed MIC:",{"$f":"Input!L6","v":0},"kVA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Existing MEC:",{"$f":"Input!O7","v":0},"kVA",null,null,"Proposed MEC:",{"$f":"Input!O6","v":0},"kVA"]
[null,null,null,null,null,null,null,null,null,null,null,"Estimated increase in demand on the                        network to be seen above the existing levels:",null,null,null,null,null,null,{"$f":"Input!L9","v":0},null,"kVA"]
[null,null,null,"Post code:",null,null,null,"Project No.",{"$f":"Input!L4","v":0}]
[null,"Status:",null,null,{"$f":"Input!E9","v":0},null,null,null,null,null,null,"Type:",null,null,{"$f":"Input!E10","v":0}]
[null,null,null,null,"Primary Substation:",{"$f":"Input!E12","v":0},null,null,null,null,null,"Approval use only"]
[null,null,null,null,"Primary feeder name:",{"$f":"Z10","v":{"$error":"#N/A"}},null,null,null,null,null,"RELEASED:",null,null,null,null,null,null,null,null,null,null,null,null,"YES",{"$f":"VLOOKUP(Y10,AA10:AB22,2,0)","v":{"$error":"#N/A"}},{"$f":"Input!J19","v":0},{"$f":"Input!B19","v":0}]
[null,null,null,null,"HV diagram reference:",{"$f":"VLOOKUP(F9,data!A2:D377,4,0)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J20","v":0},{"$f":"Input!B20","v":0}]
[null,"Grid Ref:",null,null,null,null,null,null,null,null,null,"Release Valid to:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J22","v":0},{"$f":"Input!B22","v":0}]
[null,"Are there legal consents required with parties other than the applicant?",null,null,null,null,null,null,null,null,null,"(Expiry date of approval to undertake work)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J23","v":0},{"$f":"Input!B23","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,"WORK CANNOT PROCEED WITHOUT A SIGNATURE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J24","v":0},{"$f":"Input!B24","v":"."}]
[null,"Design includes network performance optimisation as per EPD 282, 4.2?",null,null,null,null,null,null,null,null,null,"Registration No:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J25","v":0},{"$f":"Input!B25","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J26","v":0},{"$f":"Input!B26","v":"."}]
[null,"System before",null,null,null,null,null,null,null,null,null,"System after",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J27","v":0},{"$f":"Input!B27","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J28","v":0},{"$f":"Input!B28","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J29","v":0},{"$f":"Input!B29","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J30","v":0},{"$f":"Input!B30","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J31","v":0},{"$f":"Input!B31","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J32","v":0},{"$f":"Input!B32","v":"."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Are there any 33kv / 132kV reinforcement costs associated with this project?"]
[]
[null,"Are there any abnormal loads, eg large motors, welders, thyristor control, arc furnace etc?  If yes, provide brief summary and attach details."]
[]
[null,"Other notes:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!X2","v":0}]
[]
[null,"Requested by (signed):",null,null,null,null,null,null,null,null,null,"Alteration registered by:",null,null,"Signed:"]
[]
[null,"Print:",null,null,{"$f":"Input!E6","v":0},null,null,null,null,null,null,null,null,null,"Print:"]
[]
[null,"Date:",null,null,{"$f":"IF(Input!L3=\"\",\"\",Input!L3)","v":""},null,null,null,null,null,null,null,null,null,"Date:"]
[]
[null,"Office & Dept:",null,null,{"$f":"VLOOKUP(Input!E6,data!O2:R83,4,0)","v":{"$error":"#N/A"}},null,null,null,null,null,null,"Additional approval if appropriate.",null,null,"Signed:"]
[]
[null,"Tel:",null,null,{"$f":"Input!H6","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"Print:"]
[]
[null,"Fax:",null,null,{"$f":"Input!H7","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"Date:"]
[]
[null,"R  FORM EXPIRY DATE:"]
[]
[null,"An approved copy of this form, with RELEASE VALIDATION, must accompany the associated HV switching programme:"]
[]
[null,"Document No",null,null,"Loadcheck Version",null,null,null,"R form Version",null,null,"Issue date",null,null,"Template Prepared by",null,null,null,"Approved by"]
[null,"GB 01",null,null,"Version3 (11/02/2014)",null,null,null,"Version 3.0",null,null,"2014-03-03",null,null,"Glenys  Byrne",null,null,null,"Ian Povey"]
[null,null,null,"RETURN THIS FORM TO STATUTORY CONNECTIONS"]

{"sheet":"Before Drwg","index":6,"n_rows":22,"n_cols":28,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YES",{"$f":"VLOOKUP(Y10,AA10:AB22,2,0)","v":{"$error":"#N/A"}},{"$f":"Input!J19","v":0},{"$f":"Input!B19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J20","v":0},{"$f":"Input!B20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J22","v":0},{"$f":"Input!B22","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J23","v":0},{"$f":"Input!B23","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J24","v":0},{"$f":"Input!B24","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J25","v":0},{"$f":"Input!B25","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J26","v":0},{"$f":"Input!B26","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J27","v":0},{"$f":"Input!B27","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J28","v":0},{"$f":"Input!B28","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J29","v":0},{"$f":"Input!B29","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J30","v":0},{"$f":"Input!B30","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J31","v":0},{"$f":"Input!B31","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J32","v":0},{"$f":"Input!B32","v":"."}]

{"sheet":"After Drwg","index":7,"n_rows":22,"n_cols":28,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YES",{"$f":"VLOOKUP(Y10,AA10:AB22,2,0)","v":{"$error":"#N/A"}},{"$f":"Input!J19","v":0},{"$f":"Input!B19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J20","v":0},{"$f":"Input!B20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J22","v":0},{"$f":"Input!B22","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J23","v":0},{"$f":"Input!B23","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J24","v":0},{"$f":"Input!B24","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J25","v":0},{"$f":"Input!B25","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J26","v":0},{"$f":"Input!B26","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J27","v":0},{"$f":"Input!B27","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J28","v":0},{"$f":"Input!B28","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J29","v":0},{"$f":"Input!B29","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J30","v":0},{"$f":"Input!B30","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J31","v":0},{"$f":"Input!B31","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!J32","v":0},{"$f":"Input!B32","v":"."}]

{"sheet":"Study request guidance notes","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"G&P application","index":9,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":true,"merged":[[43,4,43,5],[1,1,2,3],[11,3,11,5],[13,3,13,4],[21,3,21,5],[25,2,25,3],[25,4,25,5],[30,1,40,5],[43,1,43,3]]}
[null,null,null,null,null,null,null,null,null,null,"Regulatory Classification:"]
[null,null,null,null,null,null,null,null,null,null,"Customer funded feasibility study"]
[null,null,null,null,null,null,null,null,null,null,"Budget Quote<1MVA (10 Working Days)"]
[null,null,null,null,null,null,null,null,null,null,"Budget Quote>1MVA (20 Working Days)"]
[null,"REQUEST FOR G&P WORK",null,null,null,null,null,null,null,null,"Statutory Provision of HV Demand Quote (35 Working Days)"]
[null,null,null,null,null,null,null,null,null,null,"Statutory Provision of HV Generation Quote (65 Working Days)"]
[null,null,null,null,null,null,null,null,null,null,"Statutory Provision of EHV Demand/Generation Quote (65 Working Days)"]
[null,"Requested by: ",null,{"$f":"Input!E6","v":0},"Date:",{"$f":"IF(Input!L3=\"\",\"\",Input!L3)","v":""},null,null,null,null,"Competitive Provision of HV Demand Quote (20 Working Days)"]
[null,null,null,null,null,null,null,null,null,null,"Competitive Provision of HV Generation Quote (50 Working Days)"]
[null,"Contact Phone Number:",null,{"$f":"Input!H6","v":{"$error":"#N/A"}},"Request Type:",null,null,null,null,null,"Competitive Provision of EHV (33kV) Demand Quote (50 Working Days)"]
[null,null,null,null,null,null,null,null,null,null,"Competitive Provision of EHV (33kV) Generation Quote (62 Working Days)"]
[null,"Scheme Title:",null,{"$f":"IF(Input!E3=\"\",\"\",Input!E3)","v":""},null,null,null,null,null,null,"Competitive Provision of 132kV Demand/Generation (62 Working Days)"]
[null,null,null,null,null,null,null,null,null,null,"Request Type:"]
[null,"D&C WFM Ref:",null,{"$f":"IF(Input!L4=\"\",\"\",Input!L4)","v":""},null,null,null,null,null,null,"Study Only"]
[null,null,null,null,null,null,null,null,null,null,"Extension Only"]
[null,"New Load:",null,{"$f":"Input!L6","v":0},"New Generation:",{"$f":"Input!O6","v":0},null,null,null,null,"Study and Extension"]
[null,null,null,null,null,null,null,null,null,null,"Indicative Quote"]
[null,"Grid Ref:"," Eastings",null,"Primary:",{"$f":"Input!E12","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Voltage:"]
[null,null,"              Northings",null,"Voltage:",null,null,null,null,null,"LV"]
[null,null,null,null,null,null,null,null,null,null,"6.6kV"]
[null,"Regulatory Classification:",null,null,null,null,null,null,null,null,"11kV"]
[null,null,null,null,null,null,null,null,null,null,"33kV"]
[null,"Is Study Fee Applicable?",null,null,null,null,null,null,null,null,"132kV"]
[]
[null,null,"If 'Yes' which cost is applicable?",null,null,null,null,null,null,null,"Is Study Fee Applicable?"]
[null,null,null,null,null,null,null,null,null,null,"Yes "]
[null,"Application Received:",null,null,"Target Quote Date:",null,null,null,null,null,"No"]
[]
[null,"Supporting Info/Comments",null,null,null,null,null,null,null,null,"If 'Yes' which cost is applicable?"]
[null,null,null,null,null,null,null,null,null,null,"LV Demand upto1MVA "]
[null,null,null,null,null,null,null,null,null,null,"HV Demand up to & including MVA "]
[null,null,null,null,null,null,null,null,null,null,"HV Demand over 2MVA"]
[null,null,null,null,null,null,null,null,null,null,"33kV Demand up to & including 10MVA "]
[null,null,null,null,null,null,null,null,null,null,"33kV Demand >10MVA"]
[null,null,null,null,null,null,null,null,null,null,"132kV Demand "]
[null,null,null,null,null,null,null,null,null,null,"Generation up to & including 1MW "]
[null,null,null,null,null,null,null,null,null,null,"Generation >1MW up to & including 4MW "]
[null,null,null,null,null,null,null,null,null,null,"Generation >4MW up to & including 10MW "]
[null,null,null,null,null,null,null,null,null,null,"Generation >10MW up to & including 40MW"]
[null,null,null,null,null,null,null,null,null,null,"Generation >40MW up to & including 100MW "]
[null,null,null,null,null,null,null,null,null,null,"Generation >100MW  "]
[]
[null,"The WFM SAP number for this work is:    ",null,null,56]
[null,null,null,null,null,null,null,null,null,null,"10 working days"]
[null,"Time Available for Study:",null,null,"Target Completion Date:",null,null,null,null,null,"16 working days"]
[null,null,null,null,null,null,null,null,null,null,"20 working days"]
[null,"Time Available for Quote:",null,null,"Target Completion Date:"]
[]
[]
[]
[null,"version 5 Mar 2012"]

{"sheet":"Cable ratings","index":10,"n_rows":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":true,"merged":[]}
[null,"RATINGS USED"]
[]
[null,"BELOW ARE THE RATINGS USED FOR THE CALCULATIONS UNDERTAKEN BY 'LOADCHECK' . "]
[null,"Subject to the parameters used being applicable (see below), this table may be used as a crib-sheet for general use."]
[]
[]
[null,"(The information in this table has been taken from the 'Summary of Cable Ratings' on Page 37 "]
[null,"of CP203 ISSUE 4 (12/01/09). Please refer to CP203 for the parameters used)."]
[]
[null,"Size","Continuous","Cyclic","Distribution","Comment"]
[null,"95 XXX",245,277,277,"TRIPLEX"]
[null,"95 PICAS",185,210,245,"ACCAS"]
[null,"95 Cu",245,275,330,"PILC"]
[null,"95 Al",190,215,260,"PILC"]
[null,"300 XXX",461,521,521,"TRIPLEX"]
[null,"300 PICAS",355,400,490,"ACCAS"]
[null,"300 Cu",460,520,665,"PILC"]
[null,"300 Al",365,410,525,"PILC"]
[null,"240 Cu",410,460,460,"PILC"]
[null,"240 Al",325,365,460,"PILC"]
[null,"185 XXX",353,399,399,"TRIPLEX"]
[null,"185 PICAS",270,305,370,"ACCAS"]
[null,"185 Cu",355,400,500,"PILC"]
[null,"185 Al",280,315,390,"PILC"]
[null,"120 Cu",280,315,380,"PILC"]
[null,"120 Al",220,245,300,"PILC"]
[null,"0.5 Cu",530,600,670,"PILC"]
[null,"0.5 Al",420,475,530,"PILC"]
[null,"0.4 Cu",475,535,595,"PILC"]
[null,"0.4 Al",375,420,470,"PILC"]
[null,"0.3 Cu",410,460,500,"PILC"]
[null,"0.3 Al",325,365,390,"PILC"]
[null,"0.25 Cu",370,415,440,"PILC"]
[null,"0.25 Al",290,325,345,"PILC"]
[null,"0.2 Cu",320,360,385,"PILC"]
[null,"0.2 Al",250,280,300,"PILC"]
[null,"0.15 Cu",270,305,320,"PILC"]
[null,"0.15 Al",210,235,250,"PILC"]
[null,"0.1 Cu",220,245,255,"PILC"]
[null,"0.1 Al",170,190,195,"PILC"]
[null,"0.06 Cu",160,175,185,"PILC"]
[null,"0.06 Al",125,135,145,"PILC"]
[null,"0.04 Cu",130,140,145,"PILC"]
[null,"0.04 Al",100,110,110,"PILC"]
[null,"0.025 Cu",92,100,100,"PILC"]
[null,"0.025 Al",72,78,78,"PILC"]
[]
[]
[null,"COLOUR CODE USED IN THIS TABLE:"]
[]
[null,null,null,"  - TRIPLEX"]
[]
[null,null,null,"  - ACCAS"]
[]
[null,null,null,"  - ALUMINIUM CONDUCTOR"]
[]
[null,null,null,"  - COPPER CONDUCTOR"]

{"sheet":"ASL calculation","index":11,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
[null,null,"Calculation of Ratings of Auto Sectionalising Links"]
[]
["Job Ref:",{"$f":"Input!L4","v":0}," "]
[]
[]
[]
[null,null,"EXISTING",null,null,null,null,"PROPOSED"]
[null,{"$f":"Input!V9","v":{"$error":"#N/A"}},"kV select O/H line Voltage ",null,null,null,{"$f":"B8","v":{"$error":"#N/A"}},"kV select O/H line Voltage "]
[]
[null,"T/F  kVA Nameplate rating *",null,null,null,null,"T/F  kVA Nameplate rating"]
[null,"1ph T/Fs",null,"3ph T/Fs",null,null,"1ph T/Fs",null,"3ph T/Fs"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Totals",{"$f":"SUM(B12:B29)","v":0},"kVA",{"$f":"SUM(D12:D29)","v":0},"kVA","Totals",{"$f":"SUM(G12:G29)","v":0},"kVA",{"$f":"SUM(I12:I29)","v":0},"kVA"]
["FLC",{"$f":"B30/B8","v":{"$error":"#N/A"}},"Amps",{"$f":"D30/B8/SQRT(3)","v":{"$error":"#N/A"}},"Amps","FLC",{"$f":"G30/G8","v":{"$error":"#N/A"}},"Amps",{"$f":"I30/G8/SQRT(3)","v":{"$error":"#N/A"}},"Amps"]
[]
[null,null,"Total Max Ph Current",{"$f":"B31+D31","v":{"$error":"#N/A"}},"Amps",null,null,"Total Max Ph Current",{"$f":"G31+I31","v":{"$error":"#N/A"}},"Amps"]
[null,null,"Mag inrush Current",{"$f":"D33*2.5","v":{"$error":"#N/A"}},"Amps",null,null,"Mag inrush Current",{"$f":"I33*2.5","v":{"$error":"#N/A"}},"Amps"]
[]
[null,{"$f":"IF(D34>200,\"** NOT SUITABLE for ASLs**\",\"Rating of ASLs Req    | MIN Fault Level MVA\")","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"IF(I34>200,\"** NOT SUITABLE for ASLs**\",\"Rating of ASLs Req  | MIN Fault Level MVA\")","v":{"$error":"#N/A"}}]
[null,"(Pick-up Current)",null,"1ph","3ph",null,"(Pick-up Current)",null,"1ph","3ph"]
[null,{"$f":"IF(D34>0,LOOKUP(D34,C54:C59,D54:D59),\"\")","v":{"$error":"#N/A"}},"AMPS",{"$f":"IF(D34>0,B38*B8*2/1000,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(D34>0,B38*B8*2*SQRT(3)/1000,\"\")","v":{"$error":"#N/A"}},null,{"$f":"IF(I34>0,LOOKUP(I34,C54:C59,D54:D59),\"\")","v":{"$error":"#N/A"}},"AMPS",{"$f":"IF(I34>0,G38*G8*2/1000,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(I34>0,G38*G8*2*SQRT(3)/1000,\"\")","v":{"$error":"#N/A"}}]
[]
[]
[null,"* Enter the namplate rating of all transformers protected by the ASLs "]
[null,"Ensuring that the correct column is used for either single or three phase."]
[]
[null,"The Minimum Fault level is to ensure correct operation of links under fault conditions."]
[null,"This must be measured at the extreme end of the circuits controlled by the ASLs"]
[]
[null,"NB. Before ordering ASL links the type of mounting must be confirmed."]
[]
[null,"For help using this sheet please contact Neville Hartley 81263"]
[]
[null,"N. Hartley int 81263",null,"26/11/2009",null,"Calculations based on EPD321 Para 4.6"]
[]
[]
[null,null,1,25]
[null,null,25,40]
[null,null,40,63]
[null,null,63,100]
[null,null,100,200]
[null,null,200]

{"sheet":"Splitting feeder calculatio (3)","index":12,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":true,"merged":[[2,2,2,3],[2,5,2,6],[0,1,0,6]]}
["Feeder Name:","Askam - Duddon Road",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!U9","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Diversity"]
["Substation name","Substation number","MD of Tx",null,null,"Diversified load (Amps)",null,null,null,null,null,null,null,{"$f":"C28/C27","v":{"$error":"#N/A"}}]
["Duddon Road",616064,500,"kVA",{"$f":"SUM(C4*1000)/($N$1*SQRT(3))","v":{"$error":"#N/A"}},{"$f":"SUM((C4*1000)/($N$1*SQRT(3)))*$C$30","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,false,{"$f":"IF(N4=TRUE,F4,0)","v":0},{"$f":"IF(N4=FALSE,F4,0)","v":{"$error":"#N/A"}}]
["St Georges Square",618006,400,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Haverigg Windfarm 'D'",619460,40,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Back Duke St.",616006,360,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Kings Quarry",616009,415,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Lowther Rd",616007,325,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Moor End",610087,15,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Oxenbows",610078,200,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Moor Cotts",610087,500,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Back Albert St.",616012,800,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Queens Street",616015,600,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Effluent Pump",616222,200,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Wellington Street",616016,100,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Furness Street",616019,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Argyle Street",616014,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Hearfields",616232,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
[null,null,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
[null,null,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
[null,null,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
[null,null,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
[null,null,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
[null,null,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
[null,"Total load (MD):",{"$f":"SUM(C4:C25)","v":4455},"kVA",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O4:O25)","v":0},{"$f":"SUM(P4:P25)","v":{"$error":"#N/A"}}]
[null,"Total load (MD):",{"$f":"SUM(C26*1000)/($N$1*SQRT(3))","v":{"$error":"#N/A"}},"Amps"]
[null,"FLA load on feeder:",200,"Amps"]
[null,"Calculated Diversity:",{"$f":"N3","v":{"$error":"#N/A"}},null,null,{"$f":"IF(C29<0.5,\"VERY LOW DIVERSITY\",IF(C29>0.71,\"\",\"LOW DIVERSITY\"))","v":{"$error":"#N/A"}}]
[null,"User Input Diversity:",{"$f":"C29","v":{"$error":"#N/A"}}]
[null,"Checked boxes:",{"$f":"O26","v":0},"Amps"]
[null,"Un checked boxes:",{"$f":"P26","v":{"$error":"#N/A"}},"Amps"]

{"sheet":"Splitting feeder calculatio (2)","index":13,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":true,"merged":[[2,2,2,3],[2,5,2,6],[0,1,0,6]]}
["Feeder Name:","Askam - Duddon Road",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!U9","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Diversity"]
["Substation name","Substation number","MD of Tx",null,null,"Diversified load (Amps)",null,null,null,null,null,null,null,{"$f":"C28/C27","v":{"$error":"#N/A"}}]
["Duddon Road",616064,500,"kVA",{"$f":"SUM(C4*1000)/($N$1*SQRT(3))","v":{"$error":"#N/A"}},{"$f":"SUM((C4*1000)/($N$1*SQRT(3)))*$C$30","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,false,{"$f":"IF(N4=TRUE,F4,0)","v":0},{"$f":"IF(N4=FALSE,F4,0)","v":{"$error":"#N/A"}}]
["St Georges Square",618006,400,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Haverigg Windfarm 'D'",619460,40,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Back Duke St.",616006,360,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Kings Quarry",616009,415,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Lowther Rd",616007,325,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Moor End",610087,15,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Oxenbows",610078,200,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Moor Cotts",610087,500,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Back Albert St.",616012,800,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Queens Street",616015,600,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Effluent Pump",616222,200,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Wellington Street",616016,100,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Furness Street",616019,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Argyle Street",616014,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
["Hearfields",616232,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
[null,null,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
[null,null,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
[null,null,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
[null,null,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
[null,null,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
[null,null,null,"kVA",{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,false,0,{"$error":"#N/A"}]
[null,"Total load (MD):",{"$f":"SUM(C4:C25)","v":4455},"kVA",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O4:O25)","v":0},{"$f":"SUM(P4:P25)","v":{"$error":"#N/A"}}]
[null,"Total load (MD):",{"$f":"SUM(C26*1000)/($N$1*SQRT(3))","v":{"$error":"#N/A"}},"Amps"]
[null,"FLA load on feeder:",200,"Amps"]
[null,"Calculated Diversity:",{"$f":"N3","v":{"$error":"#N/A"}},null,null,{"$f":"IF(C29<0.5,\"VERY LOW DIVERSITY\",IF(C29>0.71,\"\",\"LOW DIVERSITY\"))","v":{"$error":"#N/A"}}]
[null,"User Input Diversity:",{"$f":"C29","v":{"$error":"#N/A"}}]
[null,"Checked boxes:",{"$f":"O26","v":0},"Amps"]
[null,"Un checked boxes:",{"$f":"P26","v":{"$error":"#N/A"}},"Amps"]

{"sheet":"CAF calculator","index":14,"n_rows":55,"n_cols":8,"rows_kept":55,"cut":false,"hidden":true,"merged":[[0,4,1,6]]}
[null,{"$f":"IF(Input!L4=\"\",\"\",Input!L4)","v":""},"Apportionment for: ",null,{"$f":"IF(Input!E3=\"\",\"\",Input!E3)","v":""},null,null,{"$f":"IF(Input!L3=\"\",\"\",Input!L3)","v":""}]
[]
[null,null,"100% to ","VARIABLE","CAF","GROUPS","100% TO"]
[null,"Line No:","CUST","A: T/F","B: HV","C: LV","ENW"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24,null,null,null,null,null,"GRAND"]
[null,25,null,null,null,null,null,"TOTALS"]
[null,"TOTALS",{"$f":"SUM(C5:C29)","v":0},{"$f":"SUM(D5:D29)","v":0},{"$f":"SUM(E5:E29)","v":0},{"$f":"SUM(F5:F29)","v":0},{"$f":"SUM(G5:G29)","v":0},{"$f":"SUM(C30:G30)","v":0}]
["ENTER","CAF P.U. >",1,1,1,1,0]
["Normal","Cust Charge",{"$f":"C30*C31","v":0},{"$f":"D30*D31","v":0},{"$f":"E30*E31","v":0},{"$f":"F30*F31","v":0},{"$f":"G30*G31","v":0},{"$f":"SUM(C32:G32)","v":0}]
["Values","ENW Chg",{"$f":"C30-C32","v":0},{"$f":"D30-D32","v":0},{"$f":"E30-E32","v":0},{"$f":"F30-F32","v":0},{"$f":"G30-G32","v":0},{"$f":"SUM(C33:G33)","v":0}]
[]
[null,null,"\"Variable CAF\" total £",{"$f":"SUM(D30:F30)","v":0},null,null,"Variable CAF \"Cust Charge\" £",{"$f":"SUM(D32:F32)","v":0}]
[]
[]
[null,null,null,null,"Total generation capacity in kW: ",null,"CAP £:",{"$f":"200*F38","v":0}]
[]
[null,null,{"$f":"IF(AND(H38>0,H38<D35),\" GEN CAP applies. - CAF to be \",\"Only used if Generator   >\")","v":"Only used if Generator   >"},null,null,{"$f":"IF(AND(H38>0,H38<D35),H35,\" \")","v":" "},"Customer"]
[null,null,{"$f":"IF(AND(H38>0,H38<D35),\"  based on values shown:\",\"                 CAP Applies  >\")","v":"                 CAP Applies  >"},null,null,{"$f":"IF(AND(H38>0,H38<D35),D35,\" \")","v":" "},"Total"]
[]
[null,null,null,null," Average CAF PU. is therefore: CUSTOMER:",{"$f":"IF(AND(H38>0,H38<D35),F40/F41,\" \")","v":" "},"ENW:",{"$f":"IF(AND(H38>0,H38<D35),1-F43,\" \")","v":" "}]
[]
[null,null,null,null,"Amount Chargable to ENW £:",{"$f":"IF(AND(H38>0,H38<D35),H38*H43,\" \")","v":" "}]
[]
[]
[null,null,null,null,null,"ENW",null,"CUSTOMER"]
[null,null,null,null,"Cost Chargeable in Full To Customer:",{"$f":"C33","v":0},null,{"$f":"C32","v":0}]
[null,null,null,null,"Cost Chargeable in Full To ENW:",{"$f":"G33","v":0},null,{"$f":"G32","v":0}]
[null,null,null,null,"Cost Apportioned:",{"$f":"IF(AND(H38>0,H38<D35),F45,SUM(D33:F33))","v":0},null,{"$f":"D35-F51","v":0}]
[null,null,null,null,"TOTALS:",{"$f":"SUM(F49:F51)","v":0},null,{"$f":"SUM(H49:H51)","v":0}]
[]
[null,null,null,null,null,null,"TOTAL COST OF REINFORCEMENT:",{"$f":"SUM(C30:G30)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(AND(H38>0,H38<D35),\" Value to use in WFM Apportionment>\",\"Only used if Generator CAP Applies >\")","v":"Only used if Generator CAP Applies >"},{"$f":"IF(AND(H38>0,H38<D35),H51/D35,\" \")","v":" "}]

{"sheet":"CAF calculator instructions","index":15,"n_rows":55,"n_cols":8,"rows_kept":55,"cut":false,"hidden":true,"merged":[]}
[null,"Y******","Apportionment for: ",null,null,null,null,{"$f":"TODAY()","v":"2015-09-22"}]
[]
[null,null,"100% to ","VARIABLE","CAF","GROUPS","100% TO"]
[null,"Line No:","CUST","A: T/F","B: HV","C: LV","ENW"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24,null,null,null,null,null,"GRAND"]
[null,25,null,null,null,null,null,"TOTALS"]
[null,"TOTALS",{"$f":"SUM(C5:C29)","v":0},{"$f":"SUM(D5:D29)","v":0},{"$f":"SUM(E5:E29)","v":0},{"$f":"SUM(F5:F29)","v":0},{"$f":"SUM(G5:G29)","v":0},{"$f":"SUM(C30:G30)","v":0}]
["ENTER","CAF P.U. >",1,1,1,1,0]
["Normal","Cust Charge",{"$f":"C30*C31","v":0},{"$f":"D30*D31","v":0},{"$f":"E30*E31","v":0},{"$f":"F30*F31","v":0},{"$f":"G30*G31","v":0},{"$f":"SUM(C32:G32)","v":0}]
["Values","ENW Chg",{"$f":"C30-C32","v":0},{"$f":"D30-D32","v":0},{"$f":"E30-E32","v":0},{"$f":"F30-F32","v":0},{"$f":"G30-G32","v":0},{"$f":"SUM(C33:G33)","v":0}]
[]
[null,null,"\"Variable CAF\" total £",{"$f":"SUM(D30:F30)","v":0},null,null,"Variable CAF \"Cust Charge\" £",{"$f":"SUM(D32:F32)","v":0}]
[]
[]
[null,null,null,null,"Total generation capacity in kW: ",null,"CAP £:",{"$f":"200*F38","v":0}]
[]
[null,null,{"$f":"IF(AND(H38>0,H38<D35),\" GEN CAP applies. - CAF to be \",\"Only used if Generator   >\")","v":"Only used if Generator   >"},null,null,{"$f":"IF(AND(H38>0,H38<D35),H35,\" \")","v":" "},"Customer"]
[null,null,{"$f":"IF(AND(H38>0,H38<D35),\"  based on values shown:\",\"                 CAP Applies  >\")","v":"                 CAP Applies  >"},null,null,{"$f":"IF(AND(H38>0,H38<D35),D35,\" \")","v":" "},"Total"]
[]
[null,null,null,null," Average CAF PU. is therefore: CUSTOMER:",{"$f":"IF(AND(H38>0,H38<D35),F40/F41,\" \")","v":" "},"ENW:",{"$f":"IF(AND(H38>0,H38<D35),1-F43,\" \")","v":" "}]
[]
[null,null,null,null,"Amount Chargable to ENW £:",{"$f":"IF(AND(H38>0,H38<D35),H38*H43,\" \")","v":" "}]
[]
[]
[null,null,null,null,null,"ENW",null,"CUSTOMER"]
[null,null,null,null,"Cost Chargeable in Full To Customer:",{"$f":"C33","v":0},null,{"$f":"C32","v":0}]
[null,null,null,null,"Cost Chargeable in Full To ENW:",{"$f":"G33","v":0},null,{"$f":"G32","v":0}]
[null,null,null,null,"Cost Apportioned:",{"$f":"IF(AND(H38>0,H38<D35),F45,SUM(D33:F33))","v":0},null,{"$f":"D35-F51","v":0}]
[null,null,null,null,"TOTALS:",{"$f":"SUM(F49:F51)","v":0},null,{"$f":"SUM(H49:H51)","v":0}]
[]
[null,null,null,null,null,null,"TOTAL COST OF REINFORCEMENT:",{"$f":"SUM(C30:G30)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(H38>0,H38<D35),H51/D35,\" \")","v":" "}]

{"sheet":"Sheet1","index":16,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}