{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["MajorInterDepartmental","Pivot","AEM Report","InfoServices","SourceFund","MajorCurrent","MajorUpdated","MajorArchive","Graph Data"],"not_rendered":{"charts":2,"images":1,"macros":0,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":1},"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":"MajorInterDepartmental","index":0,"n_rows":53,"n_cols":21,"rows_kept":53,"cut":false,"hidden":true,"merged":[[37,9,37,18],[34,9,34,18],[31,9,31,18],[35,9,35,18],[32,9,32,18],[30,0,30,5],[6,20,7,20],[6,17,6,18],[3,14,3,19],[36,9,36,18],[0,0,0,20],[6,0,7,0],[6,1,7,1],[6,2,6,3],[6,4,6,13],[4,14,4,19],[6,19,7,19],[6,14,6,16],[3,0,3,1],[4,0,4,1],[3,2,3,13],[4,2,4,13]]}
["INTERDEPARTMENTAL LIAISON COMMITTEE:  Meeting 2 May 2002"]
["Major Projects Report"]
[]
["Project Status",null,"1.  Inception",null,null,null,null,null,null,null,null,null,null,null,"3.  Scheme Design (Stage C)",null,null,null,null,null,"5.  Tender/Appointment                   7.  Handover/Occupation                           9.  Final Account"]
[null,null,"2.  Feasibility/Brief Appointment",null,null,null,null,null,null,null,null,null,null,null,"4.  Detailed Design (Stage D)",null,null,null,null,null,"6.  Construction                               8.  Defects                                                10.  Archive"]
[]
["Proj. No.","Title","Supervisor",null,"Stage",null,null,null,null,null,null,null,null,null,"Ancillary Services",null,null,"Contract/Status",null,"Handover","Comment/Current Issues"]
[null,null,"A","B","1","2","3","4","5","6","7","8","9","10","Phones","IT","AV","Start Date","Compl."]
["P/00/050","Special Needs (DDA)","TA","JN","O","N","G","O","I","N","G",null,null,null,"A","A","A","-",null,"-"]
["P/00/803","50 Elmwood Avenue (Nursing)","TA","GS","3","3","3","3","3","3","3","3",null,null,"H","H","H","6/8/01","/01/02","21/1/02","Costs to ITV £21k.  Duct problems with EMU.  G. Stevenson to contact M. Harron."]
["P/00/808","Lanyon North East Wing Refurbishment","AB","GS","3","3","3","3","3","3",null,null,null,null,"E","E","E","/06/01","/06/02","/07/02","Completion beginning June '02.  Phone termination by Estates.  Face plates to be same as data.  Cabinets spec. already in contract."]
["P/01/801","6 – 24 College Green Development Plan","-","-","3","3","3",null,null,null,null,null,null,null,null,null,null,"-",null,"-","Lock going on to dr.  Pass key to J Burns. Duct issues to be resolved for future scheme (phones)."]
["P/01/802","ECIT (SPUR)","BM","JN","3","3","3","3",null,null,null,null,null,null,"A","A",null,"/09/02","/11/03","/01/04","NISRC to move in short term. Query Voice Over IP solution."]
["P/01/803","Institute of Governance","GJ","JN","3","3",null,null,null,null,null,null,null,null,"A","A",null,"/01/03","/01/04","/02/04","With planning for de-listing.  Finalising layouts. Copy to be forwarded to IS."]
["P/01/804","Lanyon II","GJ","JN","3","3",null,null,null,null,null,null,null,null,null,null,null,"-"]
["P/01/806","Physics International Research Centre","JN","PE/\nBD","3","3","3","3","3",null,null,null,null,null,"C","C",null,"/07/02","/05/04","/06/04","Decant strategy being considered. Meeting to be arranged to discuss IT/tel implications.  It was reported that the future computer hubroom will move to the location previously indicated."]
["P/01/808","Sonic Arts (including Computer Science)","AB",null,"3","3","3","3","3",null,null,null,null,null,"C","C","C","/07/02","/09/03 /12/03","/09/03 /01/04","Preparing tender documentation. Cat. 6 to Computer Science spec required.  Phones from Ashby switch (expansion required).  Timetable for demolition of houses to issue. Cable spec."]
["P/01/809","Teaching & Learning (Elmwood Centre)","AB","BM","3","3","3","3","3","3",null,null,null,null,"E","E","E","/02/02","/12/02","/01/03","To be handed over no later than 20 January 2003."]
["P/01/815","QEHOR Admin Building","JN","NL","3","3","3",null,null,null,null,null,null,null,"A","A","A","/09/02","/07/03","/09/03","Enabling (P02/804) contract going out. New computer cable required incl in works.  New duct spec. to be used.  Query overall phone system."]
["P/01/810","Ophthalmic & Vision Science",null,"NL","3","3",null,null,null,null,null,null,null,null,"A","A","A","/08/02","/12/02 /03/03","/01/03 /04/03","Brief from N. Livingstone. Query phone incomer. Query capacity of existing hub. RVH node moved to Clinical A. JB to liaise with PE on proposed ducting."]
["P/01/811","Library",null,null,"3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
["P/01/814","QEHOR Ph 2 Student Housing  Elms Village","NL","JN","3","3",null,null,null,null,null,null,null,null,"A","A","A","/09/02","/07/03 /10/03 /02/04","/08/04","There is still some uncertainty regarding the networking   proposals.  Basement of Shaftesbury to be used for telephone switch.  KN to report."]
["P/01/816","QEHOR Ph 4 Social Centre","NL","JN","3","3",null,null,null,null,null,null,null,null,"A","A","A","/09/02","/09/03","/09/03"]
["P/01/817","Biomedical Research Facility","GS","JN","3",null,null,null,null,null,null,null,null,null,null,null,null,"/03/03","/07/04","/09/04","Brief being drawn up. Estates to forward location plan."]
["P/01/819","PEC","CS","JN","3",null,null,null,null,null,null,null,null,null,null,null,null,"-",null,"-","Feasibility programme to produce. Reduced scheme."]
["P/02/803","MBC Teaching Centre","GS","JN","3",null,null,null,null,null,null,null,null,null,"A","A","A","/04/03","/04/04","/06/04"]
["P/02/804","QEHOR Phase I Enabling Contract","NL","GMcC",null,null,null,null,null,null,null,null,null,null,"A","A","A","/06/02","/09/02","/09/02","Road construction only."]
[]
[]
[]
["STAGES FOR ANCILLARY SERVICES LIAISON"]
["Stage","Description",null,null,null,null,null,null,null,"Examples Information"]
["A","Ancillary Services informed of project and initial programme",null,null,null,null,null,null,null,"Project name:  key dates, building type, location"]
["B","Relevant site information provided",null,null,null,null,null,null,null,"Computer network conns., telecom conns, AV requirements etc"]
["C","Extent of work content agreed and appointed",null,null,null,null,null,null,null,"Following user mettings with Ancillary Services"]
["D","Detailed design drawings",null,null,null,null,null,null,null,"Comments from Ancillary Services required prior to tender"]
["E","Construction stage programme",null,null,null,null,null,null,null,"Key dates confirmed"]
["F","Site visited by Ancillary Services",null,null,null,null,null,null,null,"Relevant comments passed to design team"]
["G","Ancillary Services working on site"]
["H","Project handover"]
[]
["Distribution"]
["Director of Estates",null,"Development Division"]
["Deputy Director of Estates",null,"A. Beggs"]
["Head of Estates Services",null,"A. Brown"]
["Head of Estates Development",null,"B. Dale"]
[null,null,"P. Erwin"]
["Information Services",null,"N. Livingstone"]
["J. Burns",null,"G. McCartney"]
["J. Gormley",null,"B. Martin"]
["M. Harron",null,"C. Southern "]
["K. Neeson",null,"G. Stevenson"]
["R. Tomalin"]

{"sheet":"Pivot","index":1,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Faculty","Medicine, Health and Life Sciences"]
[]
["Row Labels","Sum of %"]
["CCRCB Lobby Draught Measures",100]
["CCRCB PIR Lighting Controls",100]
["HSC Borehole",100]
["MBC 05.041 Refurbishment",95]
["MBC 0G.408 decoration and Air Conditioning",90]
["MBC Alterations to Bio Imaging Rooms",90]
["MBC Anatomy Wing Minor Alterations",100]
["MBC Building Replacement of Obsolete Hot Water Generator",0]
["MBC Lecture Theatre Ventilation Systems ",75]
["MBC Nursing Recording Studio",90]
["MBC Nursing Simulation Room",100]
["MBC Reception Hatch",100]
["MBC Roof Repairs",100]
["Pharmacy Security Improvements",50]
["Welcome Centre Reorganisaton",80]
["Whitla Medical Reception Desk",100]
["Grand Total",1370]

{"sheet":"AEM Report","index":2,"n_rows":151,"n_cols":8,"rows_kept":151,"cut":false,"hidden":false,"merged":[]}
[]
[]
["LIST OF MINOR WORKS PROJECTS CURRENT AT SEPTEMBER 2019"]
[]
["Project","For","Cost","Current Stage","Target Date","ES Sign Off","EPD","Asbestos  Surveys Req'd (man/refurb)"]
["Elms Village Boilerhouse","Student Plus",345000,7,"2017-08-30"]
["Data Centre UPS","Info Services",233000,7,"2018-07-31"]
["PEC Window Replacement","Queens Sport",30000,6,"2019-06-03"]
["2-8 Fitzwilliam Street Room Alterations","MHLS",514000,6,"20/0122019"]
["42 University Road Refurbishment","UNI",176000,6,"2018-10-01"]
["SSSGS","UNI",390000,6,"2019-06-29"]
["Admin Building Level 4 and 6","UNI",25000,6,"2018-08-01"]
["Canada Room and Council Chamber","UNI",80000,6,"2018-10-25"]
["Great Hall Refurbishment","UNI",50000,6,"2019-03-29"]
["Admin Building Server Room Improvements","Info Services",75000,6,"2019-07-30"]
["Ashby Lift Controls","EPS",15000,6,"2018-04-30"]
["Electrical Inspections and Repairs","UNI",50000,6,"2019-07-31"]
["Emergency Lighting Repairs","UNI",50000,6,"2018-07-31"]
["Lanyon Great Hall - Replace Luminaire Glassware","UNI",10000,6,"2018-09-30"]
["Lighting Controls","UNI",24000,6,"2018-09-30"]
["Main Site Lighting","UNI",30000,6,"2018-09-30"]
["Main Switchboard Surge Protection","UNI",25000,6,"31/09/2019"]
["MBC 7&8 Lighting","MHLS",50000,6,"2018-10-30"]
["McClay Library Lighting Upgrade","Info Services",150000,6,"2018-10-30"]
["University Square Lighting","AHSS",36000,6,"2018-09-30"]
["Lanyon South Emergency Lighting Replacement","UNI",50000,6,"2018-01-30"]
["Health Science Campus LED Phase 2 ","AHSS",70000,6,"2018-10-31"]
["University Square Lighting Phase 2 ","MHLS",78000,6,"2019-04-30"]
["Malone Playing Fields Replacement Irrigation Pumps ","UNI",48000,6,"2018-12-21"]
["Malone Playing Fields Replacement Irrigation Pumps BMS Controls ","UNI",6000,6,"2019-03-21"]
["SOBS Additional M&E Installations ","MHLS",40000,6,"2019-09-30"]
["SOBS Refurbisment of Room 01064 for New Mass Spec Plant ","MHLS",30000,6,"2019-07-14"]
["DKB Vaccuum pump.","EPS",170000,6,"2018-09-28"]
["92-96 Lisburn Rd Aircon","Student Plus",12000,6,"2019-05-31"]
["I.S. Duct System Improvements and Repairs","UNI",150000,6,"2019-07-31"]
["CCRCB Genomics Core Technology Unit","MHLS",290000,6,"2019-07-30"]
["Riddel Hall Study Garden - Phase 1 PODS","AHSS",70000,6,"2018-09-28"]
["Riddel Hall Study Garden - Phase 2 The Shed","AHSS",70000,6,"2018-09-28"]
["Mourne Cottage","Queens Sport",13000,6,"2019-03-14"]
["SU Data and Telecoms Diversions","Student Plus",50000,6,"2019-02-28"]
["Roofs - 71-75 University Road and 69-71 University Street","UNI",200000,5,"2019-09-01"]
["NBE Workshop","EPS",352000,5,"2019-09-28"]
["Great Hall AV","UNI",100000,5,"2019-03-29"]
["Upper Malone Pitch 7","UNI",1063000,5,"2019-09-20"]
["71-75 University Road Decant","UNI",155000,5,"2019-08-28"]
["ECIT New offices ","EPS",25000,5,"2019-07-29"]
["DKB Pharmacy ","UNI",20000,5,"2019-07-28"]
["WWIEM Write up Space","UNI",25000,5,"2019-09-27"]
[" PEC - Squash Court Lighting ","UNI",10000,5,"2019-05-19"]
["Upper Malone Playing Fields -Flood Lighting ","UNI",125000,5,"2019-09-30"]
["Ashby Air Compressors ","EPS",11000,5,"2019-06-03"]
["University Square Lighting Phase 3 ","AHSS",73000,5,"2019-10-11"]
["DKB - Materials Lab Lighting","EPS",15000,5,"2019-10-28"]
["CCRCB - Extract Fan Installation","MHLS",5000,5,"2019-08-30"]
["SOBS Nitrogen Generator  Installation & Additional Works ","MHLS",80000,5,"2019-05-01"]
["SOBS Exspansion Lab ","MHLS",150000,5,"2019-09-20"]
["SOBS Gas Alarms Rooms  LG020 / 0G041 /0G056 / 0G047 ","MHLS",18000,5,"2019-07-20"]
["SOBS Various Electrical Additional Works Level 1B-LG-0G -01-02 ","MHLS",5000,5,"2019-07-30"]
["Replacement of Old Standby Generator Tanks","UNI",45000,5,"2019-09-30"]
["Lab Gas Detection Systems","UNI",20000,5,"2019-06-30"]
["Ashby Lab Gas Manifold Upgrades","EPS",50000,5,"2019-09-30"]
["Ashby turbo machinery ventilation","UNI",30000,5,"2019-10-31"]
["Various Plantroom Leak Proofing","PM",45000,5,"2019-06-30"]
["Lanyon Canada/Council Chamber  AHU","UNI",110000,5,"2019-10-31"]
["QFT AHU Inverters","Student Plus",8000,5,"2019-10-31"]
["DKB Plate Heat Exchangers","EPS",100000,5,"2019-10-31"]
["Elms Treehouse VSD","Student Plus",6000,5,"2019-10-31"]
["Minor Dissection Unit","MHLS",475000,5,"2019-08-30"]
["12 Malone Road & 19 Stranmillis Road Holding Repairs","UNI",400000,5,"2019-11-29"]
["PEC Life Cycle 2018/2019","Queens Sport",347000,5,"2019-08-30"]
["Upper Malone Life Cycle","Queens Sport",45000,5,"2020-07-31"]
["Data Centre Chiller (Phase A)","Info Services",100000,5,"2018-12-21"]
["Data Centre Close Control Units (Phase A)","Info Services",685000,5,"2019-05-31"]
["Lanyon Scissor Lift","UNI",20000,4,"2018-08-30"]
["Test Traps for Lightning Protection Systems","UNI",20000,4,"2018-09-30"]
["BRU Steam Generator Phase 2","MHLS",250000,4,"2019-01-31"]
["ECIT Data Center Improvements","ECIT",12000,4,"2019-09-30"]
["Portaferry Blocks 2 & 3","EPS",28000,4,"2019-09-30"]
["Level 6 Lektriever Removal","UNI",4000,4,"2019-09-30"]
["5 Lennoxvale Lektriever move plus office refresh","UNI",8000,4,"2018-08-30"]
["PEC CHP & Boiler","Queens Sport",795000,3,"2020-10-31"]
["IRCEP AHU","EPS",85000,3,"2019-11-30"]
["14 Lennoxvale ","UNI",26000,2,"2020-03-27"]
["Special Collection Room","Info Services",50000,2,"2019-12-31"]
["PEC Life Cycle 2019/2020","Queens Sport",99000,2,"2020-07-31"]
["Upper Malone Life Cycle 2019/2020","Queens Sport",60000,2,"2020-07-31"]
["Mourne Cottage 2019/2020","Queens Sport",8000,2,"2020-07-31"]
[]
["81 Projects with a total value of £9.9M"]
[]
["Stage 1 - Inception"]
["Stage 2 - Briefing"]
["Stage 3 - Design"]
["Stage 4 - Procurement"]
["Stage 5 - Construction"]
["Stage 6 - Handover"]
["Stage 7 - Defects Period"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Planned Maintenance","Information Services"]
["Campus Enhancements","Capital Projects"]
["Green Revolving Fund","AHSS Faculty"]
["Student Plus","EPS Faculty"]
["Queen's Sport","MHLS Faculty"]

{"sheet":"InfoServices","index":3,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":true,"merged":[[4,10,5,10],[4,0,5,0],[4,1,5,1],[4,3,4,6],[4,7,4,9],[4,2,5,2]]}
["INTERDEPARTMENTAL LIAISON COMMITTEE:  Meeting 6 June 2002                                       P/02/040"]
["Information Services Projects/Minor Works Report"]
[]
[]
["Project No.","Title","No. of Outlets","Trunking",null,null,null,"Wiring",null,null,"Comments"]
[null,null,null,"Route Agreed","Asbestos Check","Start Date","Compl. Date","Start Date","Compl. Date","Firestop Complete"]
["M/02/700","DKB G27, 1064 & 234",null,"2002-05-13","2002-05-13","2002-06-17","2002-07-01",null,null,null,"Trunking complete."]
["M/02/701","Students' Union",null,"2002-05-13","2002-05-13","2002-06-05","2002-06-28","2002-06-21","2002-07-29",null,"£7,500 + VAT Cost Centre 6559 E1301USU.  Trunking and wiring complete."]
["M/02/702","College Park",null,null,null,null,null,null,null,null,"Details not yet notified to Estates Dept by IS"]
["M/02/703","David Bates 4",null,null,null,null,null,null,null,null,"Details not yet notified to Estates Dept by IS"]
["M/02/704","NITC",null,null,null,null,null,null,null,null,"Details notified to Estates Dept by IS.  Telephone networking to be carried out at the same time.  Kristin Neeson/Tom Edgar to provide details."]
["M/02/705","Geography",null,null,null,null,null,null,null,null,"Details not yet notified to Estates Dept by IS"]
["M/02/706"]
["M/02/707"]
["M/02/708"]
["M/02/709"]
["M/02/710"]
["M/02/711"]
["M/02/712"]
["M/02/713"]
["ED","IS","IS","IS/ED","ED","ED","ED/IS","IS","IS","ED","IS/ED"]
[]
["Distribution"]
["Director of Estates",null,"Development Division"]
["Deputy Director of Estates",null,"A. Beggs"]
["Head of Estates Services",null,"A. Brown"]
["Head of Estates Development",null,"B. Dale"]
[null,null,"P. Erwin"]
["Information Services",null,"N. Livingstone"]
["J. Burns",null,"G. McCartney"]
["J. Gormley",null,"B. Martin"]
["M. Harron",null,"C. Southern "]
["K. Neeson",null,"G. Stevenson"]
["R. Tomalin"]

{"sheet":"SourceFund","index":4,"n_rows":44,"n_cols":11,"rows_kept":44,"cut":false,"hidden":true,"merged":[[41,0,41,4],[42,0,42,4],[43,0,43,4],[0,5,0,10],[0,1,1,1],[0,0,1,0],[0,2,1,2],[0,3,1,3],[0,4,1,4]]}
["Proj No","Title","Start Date","Compl. Date","Est. Cost","Source of Funding"]
[null,null,null,null,null,"01/02","02/03","03/04","DIS","Safety","Client/\nRental"]
["M/00/412","LEVs LAbels","2001-08-01","2002-03-31","(£8k)"]
["M/00/424","Pharmacy Ofice and Lab",null,"2002-01-10","(£40k)"]
["M/00/427","11 University Square Room 107",null,"2001-11-01","(£7k)","£7k"]
["M/00/432","Generator - Electricity Metering","-","2002-01-31","£7k"]
["M/01/100","Minor Pavilion Upper Malone Road (Cricket Pavilion)","-","-","-","-","-","-","-","-","-"]
["M/01/101","PEC Roof","2002-06-03","2002-07-11","£32k",null,"£32k\nP Centre"]
["M/01/102","Administration Roof","2002-06-03","2002-07-11","£30k",null,"£30k\nP Centre"]
["M/01/103","Administration Windows","-","-","£628k"]
["M/01/104","PEC New Emergency Lighting","2002-06-01","2002-07-31","£50k",null,"£20k",null,null,null,"£20k PEC\n£10k Safety"]
["M/01/409","Boathouse New Curtain Wall","2002-05-06","2002-05-24","£10k"]
["M/01/410","PEC Refurb Changing Rooms","-","-","£60k"]
["M/01/412","Lanyon Tower Floodlighting","2001-11-01","2002-01-31","£7k","£7k"]
["M/01/415","Geology Clear Out 1 & 2","-","2002-03-04","-"]
["M/01/416","69 - 71 University St First Floor Lab","-","2002-01-14","£14k","£14k\nC470 3UED"]
["M/01/417","Dub Pavilion Entertainment Licence","2002-05-20","2002-06-28","£15k","£15k\nT9018UES"]
["M/01/419","Crossland Building 2nd Floor Air Conditioning","-","31/4/02","£7k","£7k\nC4701UED"]
["M/01/420","6-8 Lennoxvale - Extern Refurb","2002-06-03","2002-09-06","£150k",null,"£130k\nP Centre"]
["M/01/421","26 Sans Soucie Park SAC","2001-11-01","2002-01-14","£5k","£5k"]
["M/01/424","Univ Square QFT Entrance","2002-06-01","2002-07-26","£75k","£37.5k\nC4703UED",null,null,null,null,"£37.5k\nQFT"]
["M/01/426","Lift Adaptations","-","2002-03-31","£172k","£172k"]
["M/01/430","111 Botanic Avenue LSE","2002-04-08","2002-06-21","£50k","£31k\nC4703UED",null,null,null,null,"£29k\nDept"]
["M/01/433","Library Tower Masonry Repairs","2002-05-01","2002-07-31","£56k",null,"£56k\nP Centre"]
["M/01/435","Rugby Road Bowling Green Car Park","2002-07-01","2002-08-31","£60k","£60k\nT9035 UES"]
["M/01/437","DKB Civil Engineering Post Grad Room G115","2002-01-21","2002-03-01","£30k","£30k\nC4704UED",null,"£30k"]
["M/01/438","Geography Centre for Canadian Studies","2002-12-01","2002-01-18","£5.5k"]
["M/01/439","Geography - Move of Geology Rock Cutting Equipment","2002-01-14","2002-03-01","£7k"]
["M/01/440","Mulhouse - Refurb 1st Floor",null,"2002-01-28","£70k","£30k - P1046\n£40k-C4704UED"]
["M/01/444","Admin Purchasing Refurb","2002-03-04","2002-03-22","£6k","£6k\nC4501UES"]
["M/02/400","DKB School of Chemistry","25/03/02\n15/04/02","2002-05-03","£40k","£40k\nX4002XEP"]
["M/02/401","MBC Road Crossing","-","-","-"]
["M/02/102","Centrally Booked Space Redecoration","2002-06-03","2002-08-31",null,"£40k\nT9034UEJ"]
["M/02/405","Whitla Hall Air Conditioning","-","2002-06-01","£35k","£35k\nC4706UED"]
["M/02/408","46 & 48 Univ Road","-","-"]
["M/02/409","2 & 4 Lennoxvale","-","-","£45k","£10k\nC4706UED","£35k\nC4706UED"]
["M/02/410","Administration Level 2 Admissions","-","-"]
["M/02/411","14 Sans Souci Park","-","-",null,"X4004KEP"]
["M/02/412","MBC Lecture Theatres","-","-"]
["M/02/413","Admin Level 1 Security Accomm","-","-"]
["M/02/414","MBC Mortuary Air Con Units","-","2002-05-01","£10k","£10k\nC4706UED"]
["Total Budget Commitment"]
["Available Budget Commitment"]
["Surplus/(Deficit)"]

{"sheet":"MajorCurrent","index":5,"n_rows":39,"n_cols":21,"rows_kept":39,"cut":false,"hidden":true,"merged":[[32,20,32,21],[38,20,38,21],[33,20,33,21],[34,20,34,21],[35,20,35,21],[36,20,36,21],[37,20,37,21],[25,20,25,21],[26,20,26,21],[19,20,19,21],[30,20,30,21],[31,20,31,21],[27,20,27,21],[28,20,28,21],[29,20,29,21],[23,0,24,0],[23,1,24,1],[23,2,23,3],[23,4,23,13],[23,14,24,14],[23,15,24,15],[23,16,24,16],[23,17,23,19],[23,20,24,21],[9,20,9,21],[10,20,10,21],[16,20,16,21],[18,20,18,21],[17,20,17,21],[11,20,11,21],[12,20,12,21],[13,20,13,21],[14,20,14,21],[21,20,21,21],[22,20,22,21],[8,20,8,21],[0,0,0,21],[1,0,2,0],[1,1,2,1],[1,2,1,3],[1,4,1,13],[1,14,2,14],[1,15,2,15],[1,16,2,16],[1,17,1,19],[1,20,2,21],[5,20,5,21],[6,20,6,21],[7,20,7,21],[3,20,3,21],[4,20,4,21]]}
["MAJOR PROJECTS"]
["Proj. No.","Title","Supervisor",null,"Stage",null,null,null,null,null,null,null,null,null,"Funding\n(£000's)","Current Estimate\n(£000's)","Lead Consultant","Contract",null,null,"Comment"]
[null,null,"A","B","1","2","3","4","5","6","7","8","9","10",null,null,null,"Start Date","Duration (Weeks)","Completion Date"]
[null,"Ashby/DKB/Comp Sci Lab Refurbishment",null,null,"3","3","3","3","3","3","3","3","3",null,null,null,"McGinnity Gantley"]
[null,"Biology & Biochemistry Lab Space Refurbishment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,"12-24 College Green","MU",null,"3","3","3",null,null,null,null,null,null,null,null,null,"MacRae Hanlon",null,null,null,"Relocation Lifelong Learning"]
[null,"Special Needs (DDA)","TA","All","O","N","G","O","I","N","G",null,null,null,null,null,"-",null,null,null,"Audit being progressed"]
[null,"ECIT (SPUR)","HM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02/02",null,"06/03"]
[null,"Energy Conservation 1997/98","CO'R",null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,"50 Elmwood Avenue (Nursing)","TA","GS","3","3","3","3","3",null,null,null,null,null,null,"412054","Andrew Nesbitt","6/8/01",null,"21/1/02","Contractor J&K Campbell.  Access problems with MDA Practice next door.  Theft of fireplaces, proposal to be requested from contractor.  GS cost info."]
[null,"Great Hall","AB","GS","3","3","3","3","3","3","3",null,null,null,null,null,"Consarc",null,null,null,"(BD) Complete.  Proposal to widen the dias - HM"]
[null,"Institute of Governance","GJ","3","3",null,null,null,null,null,null,null,null,null,null,null,"Tate Stevenson"]
[null,"IPLS Extension","AB","GMcC","3","3","3","3","3","3",null,null,null,null,null,null,"Roger McMichael","19/02/01","33","21/09/01","(BD)  Computing Service *"]
[null,"Lanyon - Environment & Landscaping",null,"GS","3","3","3","3","3","3","3","3",null,null,null,null,"Robinson Patterson",null,null,null,"Combine with Lennoxvale Southside Proposed Development?"]
[null,"Lanyon External Fabric","AB","JMcC","3","3","3","3","3","3",null,null,null,null,null,null,null,null,null,null,"Crane 3 September, wedding 8 September"]
[null,"Lanyon II","GJ",null,"3","3",null,null,null,null,null,null,null,null,null,null,"BDP/Dixon Jones",null,null,null,"This afternoon"]
[null,"Lanyon North East Wing Refurbishment","AB","GS","3","3","3","3","3","3",null,null,null,null,null,null,"Hall Black Douglas","04/06/01","52","31/05/02","(BD)  Tom Allen - Lecture Theatre Modernisation - Scope, ?????"]
[null,"Lecture Theatre Modernisation","BD","GMcC","3","3","3","3","3","3",null,null,null,null,null,null,"McGinnity Gantley",null,null,"01/02","(BD) Lights here on Saturday"]
[null,"1-3 Lennoxvale – Student Accommodation","GJ"]
[null,"5 & 5a Lennoxvale"]
[null,"Music","TA","GS","3","3","3","3","3","3","3","3",null,null,null,null,"HMD Architects",null,null,null,"(BD)"]
[null,"New Medical Library","AB","GS","3","3","3","3","3","3",null,null,null,null,null,null,"S. Stevenson & Sons",null,null,"22/08/01","(BD)"]
[null,"New Pharmacy Building (McClay)\n","AB","GMcC","3","3","3","3","3","3","3",null,null,null,null,null,"Todd Architects",null,null,null,"Seperate file for NICPPET"]
["Proj. No.","Title","Supervisor",null,"Stage",null,null,null,null,null,null,null,null,null,"Funding\n(£000's)","Current Estimate\n(£000's)","Lead Consultant","Contract",null,null,"Comment"]
[null,null,"A","B","1","2","3","4","5","6","7","8","9","10",null,null,null,"Start Date","Duration (Weeks)","Completion Date"]
[null,"New Student Accommodation - Queen’s Elms","AB","GMcC","3","3","3","3","3",null,null,null,null,null,null,null,"Roger McMichael",null,null,null,"(BD)"]
[null,"Nursing MBC","TA","GS","3","3","3","3","3","3","3","3","3","*",null,null,"S. Stevenson & Sons",null,null,null,"Complete"]
[null,"Physics International Research Centre","GJ","JN",null,null,null,null,null,null,null,null,null,null,null,null,"Sheppard Robson",null,null,null,"(BD)"]
[null,"Queen’s Elms - Beechlands II",null,"GMcC","3","3","3","3","3","3","3","3",null,null,null,null,"R. McMichael",null,null,null,"Complete"]
[null,"QEHOR Development","JN","GMcC"]
[null,"School of Management 25 & 26 University Square","TA","GMcC","3","3","3","3","3","3","3","3",null,null,null,null,null,null,null,null,"Snagging"]
[null,"School of Pharmacy","GJ"]
[null,"Sinton Hall New Build","AB","GMcC","3","3","3","3","3","3",null,null,null,null,null,null,"Roger McMichael",null,null,null,"(BD)"]
[null,"Sonic Arts","GJ","JN","3","3","3",null,null,null,null,null,null,null,null,null,"Hall Black Douglas",null,null,null,"(BD)"]
[null,"Teaching & Learning (Elmwood Centre)","GJ","JN",null,null,null,null,null,null,null,null,null,null,null,null,"K. Coogan & Company",null,null,null,"(BD)"]
[null,"Upper Crescent 1 - 3 & 28 University Road","GJ",null,"3","3","3","3","3","3","3",null,null,null,null,null,"Robinson Patterson",null,null,null,"(BD) Practically complete"]
[null,"Upper Crescent 14 - 16","GJ"]
[null,"Virtual Engineering","BD","JG","3","3","3","3","3","3",null,null,null,null,null,null,"McGinnity Gantley",null,null,null,"(BD)"]
[null,"Virtual Engineering - Engine Test Facility","PE","PE","3","3","3","3","3",null,null,null,null,null,null,null,"Design & Build"]

{"sheet":"MajorUpdated","index":6,"n_rows":67,"n_cols":21,"rows_kept":67,"cut":false,"hidden":true,"merged":[[47,1,47,16],[3,17,3,19],[2,14,2,16],[3,14,3,16],[4,0,4,1],[5,14,6,14],[3,0,3,1],[3,2,3,13],[5,19,6,19],[2,0,2,1],[5,15,6,15],[5,17,5,18],[2,2,2,13],[5,16,6,16],[2,17,2,19],[46,1,46,16],[5,20,6,20],[0,0,0,20],[5,0,6,0],[5,1,6,1],[5,2,5,3],[5,4,5,13]]}
["MAJOR PROJECT REPORT: Meeting 30 May 2002"]
[]
["Project Status",null,"1.  Inception",null,null,null,null,null,null,null,null,null,null,null,"3.  Scheme Design (Stage C)",null,null,"5.  Tender/Appointment",null,null,"7.  Handover/Occupation                                    9.  Final Account"]
[null,null,"2.  Feasibility/Brief Appointment",null,null,null,null,null,null,null,null,null,null,null,"4.  Detailed Design (Stage D)",null,null,"6.  Construction",null,null,"8.  Defects                                                        10.  Archive"]
[]
["Proj. No.","Title","Supervisor",null,"Stage",null,null,null,null,null,null,null,null,null,"Funding\n(£000's)","Current Estimate\n(£000's)","Lead Consultant","Contract/Status",null,"Handover ","Comment/Current Issues"]
[null,null,"A","B","1","2","3","4","5","6","7","8","9","10",null,null,null,"Start ","Compl. "]
["P/00/050","Special Needs (DDA)","CS","JN","O","N","G","O","I","N","G",null,null,null,"-","-","D&K","/10/01","/03/02"," ","Admissions protocol required.  DDA report from A Beggs."]
["P/00/803","50 Elmwood Avenue (Nursing)","TA","GS","3","3","3","3","3","3","3","3",null,null,"500","(545)","Andrew Nesbitt","6/8/01","/01/02","1/2/02","£22k cost to be split. Retention release 01/03. To investigate ducting for IT."]
["P/00/804","Great Hall","AB","GS","3","3","3","3","3","3","3","3",null,null,"2300","(2300)","Consarc","-","/05/01",null,"Booked 29/7 - 11/8/02."]
["P/00/805","IPLS Extension","AB","GMcC","3","3","3","3","3","3","3","3",null,null,"830","(830)","Roger McMichael","-","/09/01","21/09/01","Further repairs to external doors. Retention release 09/02."]
["P/00/806","Lanyon - Environment & Landscaping","AB","GS","3","3","3","3","3","3","3","3","3",null,"650","(700)","Robinson Patterson","-","/11/00","?","Query on damaged fibre optic cable."]
["P/00/807","Lanyon Tower Stonework","AB","GS","3","3","3","3","3","3","3","3",null,null,"170","(170)","Consarc","-","/01/02",null,"Grant claimed. Retention release 01/03."]
["P/00/808","Lanyon North East Wing Refurbishment","AB","GS","3","3","3","3","3","3","3",null,null,null,"2250","(2250)","Hall Black Douglas","/06/01","/06/02","/08/02","Quotations for moving people pending. Quote required for chimney rebuild.  Approximately 2 weeks late on site. Data terminations to start on Mon 3/06."]
["P/00/809","Lanyon South West","AB",null,"3","3","3","3","3","3","3","3","3","A","1100","(832)","Coogan & Co","/04/98","/04/00","-","F/Ac to agree. Making good defects in Registrar's accommodation."]
["P/00/810","Lecture Theatre Modernisation","AB","GMcC","3","3","3","3","3","3","3","3",null,null,"300","(300)","Estates","-","/01/02","/02/02","Retention release 01/03."]
["P/00/813","Medical Library Mulhouse","AB","GS","3","3","3","3","3","3","3","3",null,null,"2000","(2000)","S. Stevenson & Sons","-","/12/01","14/1/02","Retention release 12/02. Additional directions issued regarding sewers."]
["P/00/816","New Pharmacy Building (McClay)","AB","GMcC","3","3","3","3","3","3","3","3",null,null,"3300","(3300)","Todd Architects","-","/08/01","/08/01","Final account due. Retention release 08/02."]
["P/00/817","NICPPET","AB","GMcC","3","3","3","3","3","3","3","3",null,null,"365","(365)","Todd Architects","-","/10/01","/10/01","Retention release 10/02."]
["P/00/827","Sinton Hall New Build","AB","GMcC","3","3","3","3","3","3","3","3",null,null,"3900","(3900)","Roger McMichael","-","/12/01","/12/01","Defects  to complete blocks E&F week of 17/06/02..  Other defects still due Aug/Sept 02. Retention release 12/02. Curtain wall in one block section suspect to longer term defects."]
["P/00/829","Upper Crescent 1 - 3 & 28 University Road","AB","GS","3","3","3","3","3","3","3","3",null,null,"1740","(1740)","Robinson Patterson","-","/08/01","/09/01","To sign off. Final account to be agreed. Final fees to adjust. Retention release 12/02. Curtain wall in one block suspect to longer term defects."]
["P/00/832","Virtual Engineering","-","PE","3","3","3","3","3","3","3","3",null,null,"200","(170)","McGinnity Gantley","/01/02","/07/02","/08/02","Defects and F/Ac. Due 09/02."]
["P/01/802","ECIT (SPUR)","BM","JN","3","3","3","3",null,null,null,null,null,null,"6300","(6300)","Robinson Patterson","/09/02","/11/03","/01/04","Out to tender after July holidays.  Stage D in. Revised costs due. DDA compliance to be demonstrated. Scheme presentation mid-June 02."]
["P/01/803","Institute of Governance","CS","AB","3","3",null,null,null,null,null,null,null,null,"2687","(2687)","Tate Stevenson","/01/03","/01/04","/02/04","Delisting due - submission to council 8/05/02. Awaiting decision.  Planning to users on Tues 04/06/02.."]
["P/01/804","Lanyon II","GJ","CS","3","3","3",null,null,null,null,null,null,null,"-","-","BDP/Dixon Jones","-","-",null,"Postponed."]
["P/01/806","Physics International Research Centre","JN","BD","3","3","3","3",null,null,null,null,null,null,"9375","(9375)","Sheppard Robson","22/07/02","/05/04","/06/04","Tender return 24/6. Meeting with Planners on 14/06/02."]
["P/01/807","QEHOR Development","JN",null,"3","3",null,null,null,null,null,null,null,null,"-","-","-","-","-","-","Overall services strategy report to be submitted. Consultants input required."]
["P/01/808","Sonic Arts (including Computer Science)","AB","JN","3","3","3","3","3",null,null,null,null,null,"5470","(5500)","Hall Black Douglas","/06/02","/09/03 - /12/03","/10/03 - /01/04","Risk review to close. Tender due 11/06/02.  DDA compliance to be demonstrated."]
["P/01/809","Learning & Teaching (Elmwood Centre)","AB","BM","3","3","3","3","3","3",null,null,null,null,"2400","(2400)","Coogan & Company","/03/02","/12/02","13/02/03","Progress seem slow. Revised foundation design to new entrance. Savings to be made from lighting variations."]
["P/01/810","Ophthalmic & Vision Science",null,"NL","3","3","3","3",null,null,null,null,null,null,"1710","(1960)","Kennedy Fitzgerald","/05/02","/12/02 /03/03","/01/03 or /04/03","Approximately £200k over budget.  Design review progressing to reduce prior to tender. Disabled access strategy under review."]
["P/01/812","Clinical B infill","AB","GS","3","3","3","3","3","3","3","3",null,null,"150","(150)","S. Stevenson & Son",null,"/03/02","/03/02","Retention release 03/03."]
["P/01/814","QEHOR Ph 2 Student Housing  Elms Village","NL","JN","3","3","3",null,null,null,null,null,null,null,"10130","(10130)","Robinson Patterson","/09/02","/07/03 /10/03 /02/04","/09/03\n/12/03\n/04/03","Planning lodged.  Out tender 22/07. Some re-planning of site layout underway."]
["P/01/815","QEHOR Ph 3 Admin Building","NL","JN","3","3","3",null,null,null,null,null,null,null,"810","(810)","Tate Stevenson","/09/02","/07/03","/08/03","Planning lodged. Tender due 22/07. Comments obtained from Student Services.  Detailed design progressing."]
["P/01/816","QEHOR Ph 4 Social Centre","NL","JN","3","3",null,null,null,null,null,null,null,null,"2250","(2055)","RPP  ","/09/02","/09/03","/09/03","New build option proposed to commence on site Sept 03.  Subject to agreement from Registrar."]
["P/01/818","Biomed Research Institute","CS","JN",3,3,null,null,null,null,null,null,null,null,6000,"(4150)","-","/03/03","/07/04","/09/04","OJEC return 23/06/02. Shortlisting 26/06/02. Other consultants to tender."]
["P/01/819","PEC","GJ","CS","3",null,null,null,null,null,null,null,null,null,10000,"(10000)","Faulkner Brown Architects"," ",null,"-","Possible new build option."]
["P/02/800","Signage Audit","CS",null,"3",3,null,null,null,null,null,null,null,null,"-","-","NM Signage (Lisburn)","-",null,"-","Proposals of mock-up to be produced."]
["P/02/801","Lanyon South Common Room",null,"JN","3",null,null,null,null,null,null,null,null,null,"-","(475)",null,null,null,null,"Information required."]
["P/02/803","MBC Teaching Centre","DS","JN","3",null,null,null,null,null,null,null,null,null,1450,"(1450)",null,"/04/03","/04/04","/06/04","Tender for consultants due 11/06/02."]
["P/02/804","QEHOR Phase 1A Enabling Contract","NL","GMcC","3",null,null,null,null,null,null,null,null,null,746,"(746)","Robinson Patterson Partnership","/10/06","/06/09",null,"Bulk earthworks being tendered. Original tender delayed accordingly."]
["P/02/805","Biomed Research Institute - Enabling Works","CS",null,null,null,null,null,null,null,null,null,null,null,400,"(300)","TBA","/08/02","/01/03","/01/03","Interviewing shortlisted tenderers."]
[]
[]
[]
[]
[]
[" Note: ","Figures in brackets are provisional pending agreement of Final Account and other costs."]
[]
[null,"Distribution"]
[null,"Director of Estates"]
[null,"Deputy Director of Estates"]
[null,"Head of Estates Services"]
[null,"Head of Estates Development"]
[]
[null,"Development Division"]
[null,"W. Annesley"]
[null,"A. Beggs"]
[null,"A. Brown"]
[null,"B. Dale"]
[null,"P. Erwin"]
[null,"E. Kennedy"]
[null,"N. Livingstone"]
[null,"G. McCartney"]
[null,"B. Martin"]
[null,"C. Southern "]
[null,"G. Stevenson"]
[null,"W. Walker"]

{"sheet":"MajorArchive","index":7,"n_rows":48,"n_cols":2,"rows_kept":48,"cut":false,"hidden":true,"merged":[[0,0,0,1]]}
["Major Project Files - Master List as of 4 September 2001"]
["Original Name","Action"]
["Altnagelvin - Nursing","Relocate to \"Altnagelvin Western College\" miscellaneous"]
["Archaeology & Palaeoecology Spectrometer","This file can be destroyed.   FIN"]
["Audio Visual Services Ventilation","Archive"]
["College Park East Nos 1, 2 & 3 (Nursing)","Archive"]
["Computer Centre Air Conditioning","Archive"]
["Computer Science - 16 Malone Road","Archive"]
["Computer Science Accommodation (Crossland)","Archive"]
["Edgehill (Student Accommodation)","Relocate to \"Lennoxvale Site\" departmental"]
["Energy Conservation 1997/98","Archive"]
["Fire Precautionary Projects","Archive"]
["Floodlighting - Malone Playing Fields","Archive"]
["Generation Installations","Archive - COR will return info to RET then will archive"]
["Geography Fire Upgrade","Release retention and then archive"]
["Geology Building","Archive"]
["Geology Boilerhouse (Services)","Archive"]
["Institute for Automative Design & Engineering","Archive"]
["Keir/Ashby Extension","Archive"]
["Lanyon Building - Disabled Entrance","Archive"]
["Lennoxvale Southside (Proposed Development)","Archive"]
["Main Site External Work","Archive"]
["Medical Bioscience & Technology Institute","Perhaps same as Bioscience?"]
["5/7/9 Mount Charles","Relocate to \"Mount Charles\" departmental"]
["26 - 50 Mount Charles","Archived"]
["NI Sports Centre","Archive"]
["Nursing College Park","Archive"]
["New Student Accommodation - Queen’s Elms","Retain - not in lektriever"]
["Old Physics - Window Replacement","Archive"]
["Ophthalmology Laboratory RVH","Archive"]
["Pathology Heating","Archive"]
["Pathology Fire Precautionary Work (Services)","Archive"]
["P E C Pools","Archive"]
["Peptide and Protein Research Group","Archive"]
["Psychology Soundproofing","Archive"]
["QuChem Phase II","Archive"]
["QEHOR Fire Alarms","Archive"]
["Queen's Elms HV Conversion (lifts) (Services)","Archive"]
["QEHOR Refurbishment Feasibility","Archive"]
["Riddel Hall - Feasibility","Relocate to \"Riddel Hall\" departmental"]
["Riddel Hall - Fire Alarms","Archive"]
["Sinton Hall Refurbishment - Aborted","Archive"]
["Students' Union - Basement II","Archive"]
["Students' Union - Development Plan","Archive"]
["Students' Union Foyer","Moved to 'Students' Union Entrance' minor projects"]
["University Road Development","Archive"]
["30 University Square Refurbishment","Archive"]
["Upper Crescent - 4-6","Archive"]

{"sheet":"Graph Data","index":8,"n_rows":65,"n_cols":14,"rows_kept":65,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,1,2,3,4,5,6,"6A"]
[null,"Value of Projects","No of Projects","Current Estimate £k",null,null,"Faculty","1. Inception","2.  Project Proposals","3.  Project Design","4.  Production Information % Tender","5.  Construction      ","6. Post Construction Final Account                   ","6A.  Post Construction Final Account                   "]
["AHSS","Arts, Humanities and Social Sciences",{"$f":"COUNTIF('AEM Report'!$B:$B,'Graph Data'!$A3)","v":5},{"$f":"SUMIF('AEM Report'!$B:$B,'Graph Data'!$A3,'AEM Report'!$C:$C)*1000","v":319000000},null,"AHSS","Arts, Humanities and Social Sciences",{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F3,'AEM Report'!$D:$D,'Graph Data'!H$1)","v":0},{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F3,'AEM Report'!$D:$D,'Graph Data'!I$1)","v":0},{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F3,'AEM Report'!$D:$D,'Graph Data'!J$1)","v":0},{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F3,'AEM Report'!$D:$D,'Graph Data'!K$1)","v":0},{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F3,'AEM Report'!$D:$D,'Graph Data'!L$1)","v":1},{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F3,'AEM Report'!$D:$D,'Graph Data'!M$1)","v":4},{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F3,'AEM Report'!$D:$D,'Graph Data'!N$1)","v":0}]
["EPS","Engineering and Physical Sciences",{"$f":"COUNTIF('AEM Report'!$B:$B,'Graph Data'!$A4)","v":10},{"$f":"SUMIF('AEM Report'!$B:$B,'Graph Data'!$A4,'AEM Report'!$C:$C)*1000","v":851000000},null,"EPS","Engineering and Physical Sciences",{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F4,'AEM Report'!$D:$D,'Graph Data'!H$1)","v":0},{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F4,'AEM Report'!$D:$D,'Graph Data'!I$1)","v":0},{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F4,'AEM Report'!$D:$D,'Graph Data'!J$1)","v":1},{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F4,'AEM Report'!$D:$D,'Graph Data'!K$1)","v":1},{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F4,'AEM Report'!$D:$D,'Graph Data'!L$1)","v":6},{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F4,'AEM Report'!$D:$D,'Graph Data'!M$1)","v":2},{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F4,'AEM Report'!$D:$D,'Graph Data'!N$1)","v":0}]
["MHLS","Medicine, Health and Life Sciences",{"$f":"COUNTIF('AEM Report'!$B:$B,'Graph Data'!$A5)","v":13},{"$f":"SUMIF('AEM Report'!$B:$B,'Graph Data'!$A5,'AEM Report'!$C:$C)*1000","v":1985000000},null,"MHLS","Medicine, Health and Life Sciences",{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F5,'AEM Report'!$D:$D,'Graph Data'!H$1)","v":0},{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F5,'AEM Report'!$D:$D,'Graph Data'!I$1)","v":0},{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F5,'AEM Report'!$D:$D,'Graph Data'!J$1)","v":0},{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F5,'AEM Report'!$D:$D,'Graph Data'!K$1)","v":1},{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F5,'AEM Report'!$D:$D,'Graph Data'!L$1)","v":6},{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F5,'AEM Report'!$D:$D,'Graph Data'!M$1)","v":6},{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F5,'AEM Report'!$D:$D,'Graph Data'!N$1)","v":0}]
["O","Other",{"$f":"COUNTIF('AEM Report'!$B:$B,'Graph Data'!$A6)","v":0},{"$f":"SUMIF('AEM Report'!$B:$B,'Graph Data'!$A6,'AEM Report'!$C:$C)*1000","v":0},null,"O","Other",{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F6,'AEM Report'!$D:$D,'Graph Data'!H$1)","v":0},{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F6,'AEM Report'!$D:$D,'Graph Data'!I$1)","v":0},{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F6,'AEM Report'!$D:$D,'Graph Data'!J$1)","v":0},{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F6,'AEM Report'!$D:$D,'Graph Data'!K$1)","v":0},{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F6,'AEM Report'!$D:$D,'Graph Data'!L$1)","v":0},{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F6,'AEM Report'!$D:$D,'Graph Data'!M$1)","v":0},{"$f":"COUNTIFS('AEM Report'!$B:$B,'Graph Data'!$F6,'AEM Report'!$D:$D,'Graph Data'!N$1)","v":0}]
[]
[]
[null,"Arts, Humanities and Social Sciences"]
[]
[null,"Project Name","Project Code","Project","% Progress"]
[null,"School of Music - Repairs to Facades and Windows",{"$f":"VLOOKUP($B12,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"C12&\" - \"&B12","v":{"$error":"#N/A"}},0]
[null,"University Square Oil to Gas Conversion",{"$f":"VLOOKUP($B13,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0]
[null,"46 Sans Souci Damp Penetration Measures",{"$f":"VLOOKUP($B14,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.1]
[null,"71-75 University Road Refurbishment (Faculty)",{"$f":"VLOOKUP($B15,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.1]
[null,"University Square and School of Music Emergency Lighting ",{"$f":"VLOOKUP($B16,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.2]
[null,"Riddell Hall Minor Works",{"$f":"VLOOKUP($B17,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.5]
[null,"Riddell Hall Conversion of Computer Room to Teaching Space",{"$f":"VLOOKUP($B18,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.9]
[null,"25 & 26 University Square Emergency Lighting",{"$f":"VLOOKUP($B19,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.95]
[null,"14, 23 and 28 University Square Fire Alarm Upgrade",{"$f":"VLOOKUP($B20,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},1]
[null,"63 University Road Office Conversion",{"$f":"VLOOKUP($B21,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},1]
[null,"University Square Fire Alarm Networking",{"$f":"VLOOKUP($B22,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},1]
[null,"University Square Heating Control Valves",{"$f":"VLOOKUP($B23,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},1]
[]
[]
[null,"Engineering and Physical Sciences"]
[]
[null,"Project Name","Project Code","Project","% Progress"]
[null,"DKB Roof Repairs",{"$f":"VLOOKUP($B29,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"C29&\" - \"&B29","v":{"$error":"#N/A"}},0]
[null,"DKB Window Replacement Phase 4",{"$f":"VLOOKUP($B30,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0]
[null,"DKB LPG to Natural Gas Conversion",{"$f":"VLOOKUP($B31,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.1]
[null,"Ashby Advanced Materials Lab",{"$f":"VLOOKUP($B32,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.2]
[null,"Ashby Plant Room 0B/005 Heat Reduction",{"$f":"VLOOKUP($B33,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.2]
[null,"DKB 02.012 MOF Lab Refurbishment",{"$f":"VLOOKUP($B34,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.2]
[null,"DKB/Ashby External Lighting",{"$f":"VLOOKUP($B35,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.2]
[null,"ECIT Conversion of Meeting Room to Office",{"$f":"VLOOKUP($B36,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.2]
[null,"P'ferry Marine Biology Lab Sea Water Drainage and Hardstanding",{"$f":"VLOOKUP($B37,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.2]
[null,"Physics Enabling Works",{"$f":"VLOOKUP($B38,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.5]
[null,"Portaferry Generator Controls",{"$f":"VLOOKUP($B39,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.5]
[null,"Taranis Laser Facility Physics",{"$f":"VLOOKUP($B40,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.75]
[null,"Ashby Hub Room Air Conditioning and Disabled Call System",{"$f":"VLOOKUP($B41,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.8]
[null,"Ashby 10th Floor Replacement of Obsolete Air Conditioning Unit",{"$f":"VLOOKUP($B42,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.9]
[null,"SARC Hub Room Air Conditioning",{"$f":"VLOOKUP($B43,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.9]
[null,"6 Malone Road Refurbishment (Faculty)",{"$f":"VLOOKUP($B44,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},1]
[null,"DKB LEV Stack Improvement",{"$f":"VLOOKUP($B45,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},1]
[]
[]
[null,"Medicine, Health and Life Sciences"]
[]
[null,"Project Name","Project Code","Project","% Progress"]
[null,"MBC Building Replacement of Obsolete Hot Water Generator",{"$f":"VLOOKUP($B51,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"C51&\" - \"&B51","v":{"$error":"#N/A"}},0]
[null,"Pharmacy Security Improvements",{"$f":"VLOOKUP($B52,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.5]
[null,"MBC Lecture Theatre Ventilation Systems ",{"$f":"VLOOKUP($B53,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.75]
[null,"Welcome Centre Reorganisaton",{"$f":"VLOOKUP($B54,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.8]
[null,"MBC 0G.408 decoration and Air Conditioning",{"$f":"VLOOKUP($B55,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.9]
[null,"MBC Alterations to Bio Imaging Rooms",{"$f":"VLOOKUP($B56,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.9]
[null,"MBC 05.041 Refurbishment",{"$f":"VLOOKUP($B57,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.95]
[null,"CCRCB Lobby Draught Measures",{"$f":"VLOOKUP($B58,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},1]
[null,"CCRCB PIR Lighting Controls",{"$f":"VLOOKUP($B59,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},1]
[null,"HSC Borehole",{"$f":"VLOOKUP($B60,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},1]
[null,"MBC Anatomy Wing Minor Alterations",{"$f":"VLOOKUP($B61,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},1]
[null,"MBC Nursing Simulation Room",{"$f":"VLOOKUP($B62,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},1]
[null,"MBC Reception Hatch",{"$f":"VLOOKUP($B63,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},1]
[null,"MBC Roof Repairs",{"$f":"VLOOKUP($B64,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},1]
[null,"Whitla Medical Reception Desk",{"$f":"VLOOKUP($B65,'AEM Report'!A:A,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},1]