{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["2024A","Error_Report","Valid_Values"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":0,"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":"2024A","index":0,"n_rows":82,"n_cols":22,"rows_kept":82,"cut":false,"hidden":false,"merged":[[2,0,2,5],[1,0,1,5]]}
["SVDLS-A  ",2024,400,"West Lothian"]
["Once updates have been made, click on the button below to run a basic error check. \nAny errors found will be reported on the Error_Report Sheet and the corresponding cell will be highlighted."]
["Lists of valid codes can be found on the Valid_Values worksheet"]
[]
[]
["COUNCODE","SITECODE","PREVCODE","DBHIST","NAME","ADDRESS1","ADDRESS2","ADDRESS3","SITESIZE","SITETYPE","OWNER1","OWNER2","INSPYY","TIMEVD","PREVUSE","DERCHAR","INTRLOCN2","DEVPOT","EAST","NORTH","OSGRID","COMMENT"]
[400,"AM2201"," ",2,"LOWER BATHVILLE","ARMADALE","NIL","NIL",25.7,11,999,998,2022,9,80,6,1,3,294443,667900]
[400,"AM401"," ",2,"EX GASHOLDER","ARMADALE","NIL","NIL",1.6,11,402,998,2004,6,140,99,1,2,293817,668948,"NS93836897"]
[400,"AM801"," ",2,"EX NURSERY SCHOOL","ACADEMY STREET","ARMADALE","NIL",0.18,11,420,998,2008,8,50,1,1,1,293566,668377,"NS93556837"]
[400,"AM802"," ",2,"FORMER ARNOLD CLARK DEPOT SITE","NORTH STREET","ARMADALE","NIL",0.69,11,420,998,2018,19,150,1,1,1,293787,668891]
[400,"AM803"," ",2,"FORMER ARNOLD CLARK FORECOURT SITE","NORTH STREET","ARMADALE","NIL",0.1,21,420,998,2018,19,130,99,1,1,293824,668705]
[400,"AM804"," ",2,"FORMER ARNOLD CLARK SHOWROOM SITE","NORTH STREET","ARMADALE","NIL",0.13,21,420,998,2018,19,130,99,1,1,293786,668651]
[400,"AM805"," ",2,"NORTH STREET","REAR OF CORRIE PUB","ARMADALE","NIL",0.33,11,420,998,2018,9,80,2,1,3,293876,668956]
[400,"BA042"," ",2,"VACANT LAND","DEANS","LIVINGSTON","NIL",13.41,21,310,998,1988,3,10,99,1,4,300590,668113,"NT00626813"]
[400,"BA201"," ",2,"RIDDOCHHILL","BATHGATE","NIL","NIL",35.82,21,106,420,2002,9,100,99,1,2,297596,666486,"NS97556655"]
[400,"BA2201"," ",2,"GUILDIEHAUGH DEPOT","BLACKBURN ROAD","BATHGATE","NIL",3.4,11,106,998,2022,9,90,7,1,1,298452,667950]
[400,"BA2202"," ",2,"FORMER FOUNDRY","LINKSTON WAY","BATHGATE","NIL",3.8,11,999,998,2022,9,80,99,1,1,297383,668083]
[400,"BA2203"," ",2,"FORMER CREAMERY GARAGE","HARDHILL ROAD","BATHGATE","NIL",0.12,21,400,998,2022,9,130,99,1,2,296490,668673]
[400,"BA2204"," ",2,"VACANT LAND TO THE SOUTH OF STANDHILL INDUSTRIAL ESTATE","BATHGATE","NIL","NIL",2.6,21,999,998,2022,9,999,99,1,2,296260,666749]
[400,"BA701"," ",2,"BLOOMFIELD PLACE","BATHGATE","NIL","NIL",0.12,11,420,998,2007,6,130,99,1,9,297539,668774,"NS97536877"]
[400,"BA702"," ",2,"EX ABBATOIR","BATHGATE","NIL","NIL",1.39,21,420,998,2007,8,10,99,1,9,296373,667373,"NS96376736"]
[400,"BA704"," ",2,"NORTH EAST MORRISONS","NIL","BATHGATE","NIL",0.88,21,420,998,2018,6,80,99,1,1,297336,668445]
[400,"BA705"," ",2,"EX-DREADNOUGHT HOTEL","WHITBURN ROAD","BATHGATE","NIL",0.14000000000000001,11,420,998,2018,6,125,1,1,2,297378,668722]
[400,"BA706"," ",2,"RETAIL PARK SE CAR PARK","NIL","BATHGATE","NIL",0.31,21,420,998,2018,11,130,99,1,1,297551,668497]
[400,"BA707"," ",2,"EX-COMMUNITY CENTRE","MARJORIEBANK STREET","BATHGATE","NIL",0.27,21,106,998,2018,11,50,99,1,1,297726,668887]
[400,"BA708"," ",2,"TEMPORARY CAR PARK SITE","HIGH STREET","BATHGATE","NIL",0.13,21,420,998,2018,6,120,99,1,2,297486,669140]
[400,"BB2201"," ",2,"FORMER COMMUNITY CENTRE","ASH GROVE","BLACKBURN","NIL",0.15,22,106,998,2022,9,30,99,1,2,298730,665796]
[400,"BB2202"," ",2,"ASH GROVE","BLACKBURN","NIL","NIL",0.26,21,999,998,2022,9,999,99,1,1,298668,665740]
[400,"BB2203"," ",2,"FORMER ADULT TRAINING CENTRE","OFF EAST MAIN STREET","BLACKBURN","NIL",0.42,21,400,998,2022,9,50,99,1,1,298867,665492]
[400,"BG001"," ",2,"BRIDGEND BING","BRIDGEND","NIL","NIL",9.9,11,999,998,1988,1,100,99,3,9,303756,675840,"NT03757585"]
[400,"BU004"," ",2,"WASTEGROUND","ALBYN","BROXBURN","NIL",0.52,21,999,998,1988,1,10,99,1,3,308270,672786,"NT08477308"]
[400,"BU006"," ",2,"ALBYN BING","GREENDYKES ROAD","BROXBURN","NIL",5.9,11,999,998,1988,1,100,99,1,3,308456,672911,"NT08457280"]
[400,"BU008"," ",2,"CANDLEWORKS","PORT BUCHAN","BROXBURN","NIL",2.02,11,106,998,1988,1,80,99,1,9,308062,672606,"NT07887262"]
[400,"BU019"," ",2,"WIMPEY DEPOT","UPHALL","NIL","NIL",6.9,11,999,998,1988,9,999,99,3,1,306718,670985]
[400,"BU2201"," ",2,"FORMER BROXBURN PRIMARY SCHOOL","BROXBURN","NIL","NIL",2.1,21,106,998,2022,9,50,99,1,3,307976,672483]
[400,"BU2202"," ",2,"E-BU 1  YOUNGS ROAD SOUTH","EAST MAINS INDUTRIAL ESTATE","BROXBURN","NIL",1.19,21,999,998,2022,9,999,99,1,2,308999,672809]
[400,"BU2203"," ",2,"E-BU 3 CLIFTON VIEW 2","EAST MAINS INDUTRIAL ESTATE","BROXBURN","NIL",0.56000000000000005,21,999,998,2022,9,999,99,1,2,309109,673087]
[400,"DC001"," ",2,"BANGOUR GENERAL","HOSPITAL SITE","DECHMONT","NIL",26.76,11,420,998,1993,4,30,99,3,3,302229,670962,"NT03007050"]
[400,"EC2201"," ",2,"MILLBANK DEPOT","EAST CALDER","NIL","NIL",0.27,21,106,998,2022,9,999,99,1,3,308441,668106]
[400,"EC2202"," ",2,"BROOMPARK FARM","MAIN STREET","EAST CALDER","NIL",1.1000000000000001,21,400,998,2022,9,10,99,1,1,308058,667814]
[400,"EW2201"," ",2,"E-EW 1, WHITRIGG NORTH EAST","OFF MAIN STREET","EAST WHITBURN","NIL",2.5,21,999,998,2022,9,999,99,1,2,296751,665178]
[400,"EW2202"," ",2,"E-EW 2, WHITRIGG SOUTH WEST","OFF MAIN STREET","EAST WHITBURN","NIL",0.57999999999999996,21,999,998,2022,9,999,99,1,2,296687,664758]
[400,"FA001"," ",2,"DERELICT LAND","BENHAR","FAULDHOUSE","NIL",13.78,11,310,998,1988,1,100,99,3,9,291400,662642,"NS91406273"]
[400,"FA003"," ",2,"COAL BING","EAST BENHAR","FAULDHOUSE","NIL",0.78,11,310,998,1988,1,100,99,3,9,291580,661970,"NS91586197"]
[400,"FA007"," ",2,"FALLAHILL QUARRY","FAULDHOUSE","NIL","NIL",1.3,11,106,998,1988,3,100,99,3,9,292136,660871,"NS92136085"]
[400,"FA013"," ",2,"NORTHFIELD BINGS","NORTHFIELD FARM","FAULDHOUSE","NIL",25.94,11,999,998,1988,1,100,99,3,9,294243,661559,"NS94326153"]
[400,"FA014"," ",2,"VACANT LAND","SHEEPHOUSEHILL","FAULDHOUSE","NIL",0.33,11,999,998,1988,1,999,99,3,9,294023,660955,"NS94046103"]
[400,"FA017"," ",2,"VICTORIA COTTAGE BING","NIL","FAULDHOUSE","NIL",1.73,11,999,998,2018,1,100,3,3,9,293374,661567]
[400,"FA2201"," ",2,"STONEHOUSE FARMHOUSE","LANGRIGG ROAD","FAULDHOUSE","NIL",1.35,11,400,998,2022,9,10,99,3,1,294176,662088]
[400,"LL2201"," ",2,"FORMER BSW TIMBER","FALKIRK ROAD","LINLITHGOW","NIL",0.55000000000000004,21,420,998,2022,9,170,99,1,3,299067,676903]
[400,"LL2202"," ",2,"FORMER VICTORIA HALLS","88 - 94 HIGH STREET","LINLITHGOW","NIL",0.13,21,400,998,2022,9,70,99,1,1,300303,677178]
[400,"LL2203"," ",2,"LAND AT EDINBURGH ROAD","LINLITHGOW","NIL","NIL",0.78,21,400,998,2022,9,999,99,1,1,300965,677156]
[400,"LR2201"," ",2,"LAND OFF B7010","NORTH OF H-LR2","LONGRIDGE","NIL",0.27,11,999,998,2022,9,999,99,3,3,294625,662634]
[400,"LV2201"," ",2,"NELLBURN","DEANS SOUTH ROAD","LIVINGSTON","NIL",0.19,21,106,998,2022,9,999,99,1,1,302709,668614]
[400,"LV2202"," ",2,"LAND AT CHARLESFIELD ROAD","LIVINGSTON","NIL","NIL",0.63,11,400,998,2022,9,110,99,1,1,304262,665982]
[400,"LV2203"," ",2,"LAND AT GARBETT ROAD","LIVINGSTON","NIL","NIL",0.78,11,400,998,2022,9,110,99,1,1,304354,666148]
[400,"LV2204"," ",2,"LAND AT FORESTBANK","LADYWELL","LIVINGSTON","NIL",0.11,21,999,998,2022,9,999,99,1,1,305450,668267]
[400,"LV2206"," ",2,"LAND AT BAIRD WAY / SIMPSON PARKWAY","LIVINGSTON","NIL","NIL",4.7,21,400,998,2022,9,90,99,1,2,303041,666342]
[400,"LV2207"," ",2,"FORMER ETHICON PLANT","SIMPSON PARKWAY","LIVINGSTON","NIL",3.35,21,400,998,2022,9,90,99,1,2,303411,666684]
[400,"LV2208"," ",2,"WILLIAMSTON NORTH","OAKBANK INDUSTRIAL ESTATE","LIVINGSTON","NIL",0.46,21,400,998,2022,9,999,99,1,2,306608,665501]
[400,"LV2209"," ",2,"LAND AT ELIBURN INDUSTRIAL PARK","APPLETON DRIVE","LIVINGSTON","NIL",0.38,21,400,998,2022,9,999,99,1,2,303022,667366]
[400,"LV2210"," ",2,"VACANT LAND AT BRUCEFIELD PARK SOUTH","LIVINGSTON","NIL","NIL",1.9,21,999,998,2022,9,999,99,1,2,304400,664429]
[400,"LV2211"," ",2,"LAND AT ALBA CAMPUS","SIMPSON PARKWAY / B7015","LIVINGSTON","NIL",3.3,21,999,998,2022,9,999,99,1,2,303506,665807]
[400,"LV2212"," ",2,"LAND AT ALMONDVALE STADIUM ROAD","LIVINGSTON","NIL","NIL",0.4,21,999,998,2022,9,999,99,1,2,304978,667043]
[400,"PB2201"," ",2,"THE FIRS, LANGSIDE GARDENS","POLBETH","NIL","NIL",0.7,21,999,998,2022,9,70,99,1,1,303352,664437]
[400,"PB2202"," ",2,"FORMER WEST CALDER HIGH SCHOOL","OLD SCHOOL AVENUE","POLBETH","NIL",3,21,106,998,2022,9,50,99,1,1,303697,664195]
[400,"PB2203"," ",2,"LIMEFIELD HOUSE BUSINESS CENTRE","POLBETH","NIL","NIL",1.1000000000000001,11,400,998,2022,9,110,99,1,1,303489,664052]
[400,"PT002"," ",2,"PHILPSTOUN SOUTH & NORTH BINGS","PHILPSTOUN","NIL","NIL",24.57,11,999,998,1988,1,100,99,3,9,305655,676615,"NT05657658"]
[400,"PT003"," ",2,"CRAIGTON QUARRY","CRAIGTON","PHILPSTOUN","NIL",11.18,11,999,998,1988,1,100,99,3,9,307557,676807,"NT07557685"]
[400,"SF003"," ",2,"DERELICT FARM STEADING","BY REDHOUSE","SEAFIELD","NIL",0.18,11,420,998,2014,9,10,1,3,9,299719,665618,"NS99726561"]
[400,"SF2201"," ",2,"LAND AT REDHOUSE ROAD","SEAFIELD","NIL","NIL",0.9,22,400,998,2022,9,90,99,1,1,300485,666159]
[400,"UH2201"," ",2,"LAND TO THE NORTH OF UPHALL INDUSTRIAL ESTATE","A89","UPHALL","NIL",0.8,21,999,998,2022,9,999,99,1,2,306525,671339]
[400,"UH2202"," ",2,"LAND WITHIN UPHALL INDUSTRIAL ESTATE","UPHALL","NIL","NIL",0.56000000000000005,21,999,998,2022,9,999,99,1,2,306549,671182]
[400,"US007"," ",2,"EX - KIRKFORFAR BRICK WORKS ","UPHALL STATION","NIL","NIL",1.63,11,999,998,2001,9,999,99,1,9,307278,669719,"NT06927006"]
[400,"WC015"," ",2,"WEST CALDER","STATION GOODS YARD","WEST CALDER","NIL",1.3,11,999,998,1988,1,150,99,1,9,301889,663307,"NT01726326"]
[400,"WC018"," ",2,"COAL BING","COBBINSHAW","WEST CALDER","NIL",0.8,11,999,998,1988,1,100,99,3,9,302914,656801,"NT02935680"]
[400,"WF007"," ",2,"EX- BRICKWORKS","CRAIGRIGG","WESTFIELD","NIL",1.2,11,999,998,1988,1,80,99,3,9,293360,670860,"NS93147080"]
[400,"WF008"," ",2,"COAL BING","BRIDGECASTLE","WESTFIELD","NIL",0.72,11,999,998,1988,1,100,99,3,9,293777,670390,"NS93777045"]
[400,"WF309"," ",2,"FORMER PAPER MILL","WESTFIELD","NIL","NIL",8.77,11,420,998,2003,6,80,99,2,2,294168,672133,"NS94337215"]
[400,"WH2201"," ",2,"LAND TO THE EAST OF E-WH 1","COWHILLS, HEARTLAND BUSINESS PARK","WHITBURN","NIL",2.1,21,999,998,2022,9,999,99,1,2,294155,665343]
[400,"WH803"," ",2,"EX-MINERS CLUB SITE","WEST MAIN STREET (SOUTH SIDE)","WHITBURN","NIL",0.19,21,999,998,2018,6,30,99,1,2,294311,664881]
[400,"WH804"," ",2,"N.E. KING GEORGE V PARK","NIL","WHITBURN","NIL",0.53,21,999,998,2018,6,70,99,1,2,294480,665334]

{"sheet":"Error_Report","index":1,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["If any errors are listed below please check and revise the data and re-run the error check"]
["\r\nCell $N$7 requires a numerical value from 1-25\r\nAll Checks Complete"]

{"sheet":"Valid_Values","index":2,"n_rows":35,"n_cols":24,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Council Codes",null,null,"Site Type",null,null,"Site Owner",null,null,null,"TIMEVD",null,null,"Previous Use"," ",null,"DERCHAR",null,null,"INTRLOCN2",null,null,"DEVPOT"]
["Council","Code",null,"Type","Code",null,"Type","Site Owner","Code",null,"Year","TimeVD",null,"Description","PREVUSE",null,"Categories","DERCHAR",null,"Location","Intrlocn2",null,"Development potential","DEVPOT"]
["Aberdeen City",100,null,"Derelict",11,null,"Public","Scottish Government",102,null,"1980 or earlier",1,null,"Agriculture",10,null,"Category 1 Only",1,null,"Site in settlement with population equal to or over 2,000",1,null,"Developable - Short Term",1]
["Aberdeenshire",110,null,"Vacant Land",21,null,null,"Property Services Agency",103,null,"1981-1985",2,null,"Forestry/Woodland",20,null,"Category 2 Only",2,null,"Site in settlement with population under 2,000",2,null,"Developable - Medium Term",2]
["Angus",120,null,"Vacant Land and Buildings",22,null,null,"Defence",104,null,"1986-1990",3,null,"Community & Health",30,null,"Category 3 Only",3,null,"Site in countryside",3,null,"Developable - Undetermined",3]
["Argyll & Bute",130,null,null,null,null,null,"Health Boards",105,null,"1991-1995",4,null,"Defence",40,null,"Categories 1 and 2",4,null,null,null,null,"Uneconomic to Develop/Soft End Use",4]
["Clackmannanshire",150,null,null,null,null,null,"Local Authority",106,null,"1996-2000",5,null,"Education",50,null,"Categories 1 and 3",5,null,null,null,null,"Unknown (uncertain/insufficient information)",9]
["Dumfries & Galloway",170,null,null,null,null,null,"Other National/Local Government",110,null,"2001-2004",6,null,"Passive Open Space",60,null,"Categories 2 and 3",6]
["Dundee City",180,null,null,null,null,null,"Royal Mail/Post Office",203,null,2005,7,null,"Recreation & leisure (excluding passive open space)",70,null,"All 3 Categories",7]
["East Ayrshire",190,null,null,null,null,null,"Public Port Authority",204,null,2006,8,null,"Manufacturing",80,null,"Unknown/Not Applicable",99]
["East Dunbartonshire",200,null,null,null,null,null,"British Waterways",205,null,2007,10,null,"Other General Industrial",90]
["East Lothian",210,null,null,null,null,null,"Water Authority",206,null,2008,11,null,"Mineral Activity",100]
["East Renfrewshire",220,null,null,null,null,null,"Coal Authority",207,null,2009,12,null,"Offices",110]
["Edinburgh, City of",230,null,null,null,null,null,"Other Nationalised Industry or Statutory undertakers",220,null,2010,13,null,"Residential - Housing",120]
["Na h-Eileanan Siar",235,null,null,null,null,null,"Scottish Enterprise",301,null,2011,14,null,"Residential - Hotels, Hostels etc",125]
["Falkirk",240,null,null,null,null,null,"Highlands and Islands Enterprise",302,null,2012,15,null,"Retailing",130]
["Fife",250,null,null,null,null,null,"Housing Association",303,null,2013,16,null,"Storage",140]
["Glasgow City",260,null,null,null,null,null,"Urban Regeneration Company",304,null,2014,17,null,"Transport",150]
["Highland",270,null,null,null,null,null,"Other non-Crown",310,null,2015,18,null,"Utility Services",160]
["Inverclyde",280,null,null,null,null,"Private","Private Steel",401,null,2016,19,null,"Wholsesale distribution",170]
["Loch Lomond & The Trossachs",15,null,null,null,null,null,"Private Gas",402,null,2017,20,null,"Business Class",180]
["Midlothian",290,null,null,null,null,null,"Private Telecommunications",403,null,2018,21,null,"Nature Conservation",190]
["Moray",300,null,null,null,null,null,"Scottish Power",404,null,2019,22,null,"Green/Environmental",230]
["North Ayrshire",310,null,null,null,null,null,"Hydro Electric",405,null,2020,23,null,"Prepared Ground",240]
["North Lanarkshire",320,null,null,null,null,null,"Harbour Trust",407,null,2021,24,null,"Other  ",888]
["Orkney Islands",330,null,null,null,null,null,"Network Rail/ Rail Franchise Holder",409,null,2022,25,null,"Unknown",999]
["Perth & Kinross",340,null,null,null,null,null,"Private Coal Company",410,null,2023,26]
["Renfrewshire",350,null,null,null,null,null,"Private Port Company",411,null,"Unknown",9]
["Scottish Borders",355,null,null,null,null,null,"Other Private",420]
["Shetland Islands",360,null,null,null,null,"Unknown/Not Applicable","Unknown Public",100]
["South Ayrshire",370,null,null,null,null,null,"Unknown Private",400]
["South Lanarkshire",380,null,null,null,null,null,"Not applicable  (i.e. only one owner)",998]
["Stirling",390,null,null,null,null,null,"Ownership unknown",999]
["West Dunbartonshire",395]
["West Lothian",400]