{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["AP","Macro1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":13,"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":"AP","index":0,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Department Family","Entity","Date","Expense Type","Expense Area","Supplier","Amount","Description"]
["Department of Health","National Institute For Health And Care Excellence","2024-01-01","Travel & Subsistence","Facilities - Manchester - NP","CORPORATE TRAVEL MANAGEMENT NORTH LTD",52184.81,"Travel Expenses"]
["Department of Health","National Institute For Health And Care Excellence","2024-01-01","Electricity","Facilities - London - NP","DEPARTMENT OF HEALTH",251586.35,"2 Redman Place Rent/Rates/Electricity/Gas/Service Charge - Q4- (Oct23-Dec23)"]
["Department of Health","National Institute For Health And Care Excellence","2024-01-01","Computer Software/License","DIT non pay","PHOENIX SOFTWARE LTD",59938.68,"Microsoft Licensing"]
["Department of Health","National Institute For Health And Care Excellence","2024-01-01","Contr Other External","Evidence Services - NP","CLARITY INFORMATICS LTD",36666.67,"NICE Clinical Knowledge Summaries (CKS) Contract - December 2023"]
["Department of Health","National Institute For Health And Care Excellence","2024-01-01","Rent","Facilities - London - NP","DEPARTMENT OF HEALTH",-220984.31,"FULL CREDIT for Invoice FTI003549 (Dec23 Return) - 2 Redman Place Rent/Rates/Electricity/Gas/Service Charge - Q4- (Jan23-Mar23)"]
["Department of Health","National Institute For Health And Care Excellence","2024-01-01","Books, Journals & Subscr","National Core Content HEE Funding","WOLTERS KLUWER HEALTH (MEDICAL RESEARCH) LTD",140569.95000000001,"Licences for access to medical databases (OVID Discovery) Q2 23/24 1st Jul - 30th Sep 2023"]
["Department of Health","National Institute For Health And Care Excellence","2024-01-01","Legal / Prof Fees","Corporate Office - NP","DAC BEACHCROFT LLP",38795.230000000003,"Legal and professional charges period to 30 November 2023"]
["Department of Health","National Institute For Health And Care Excellence","2024-01-01","Books, Journals & Subscr","National Core Content HEE Funding","EBSCO INTERNATIONAL INC",142992.35999999999,"Subscriptions - CINAHL - Psychology & Behavioral Sciences Collection, Q3 2023-24"]
["Department of Health","National Institute For Health And Care Excellence","2024-01-01","Computer Software/License","DIT non pay","CIVICA UK LTD",30544.799999999999,"Subscriptions - MultiVue Core System - Annual Charge Year 2"]
["Department of Health","National Institute For Health And Care Excellence","2024-01-01","Electricity","Facilities - Manchester - NP","MJ MAPP LLP",46383.94,"Manchester Office Electricity Charge 28.08.2023 - 01.10.2023"]
["Department of Health","National Institute For Health And Care Excellence","2024-01-01","Programme Support Costs","Clinical Team","UNIVERSITY HOSPITALS BRISTOL & WESTON NHS FOUNDATION TRUST",37068,"Secondee Recharge Q2 23-24"]
["Department of Health","National Institute For Health And Care Excellence",45292,"Contr Other External","Medical Technologies Evaluation Programme - NP","NEWCASTLE UPON TYNE HOSPITALS NHS FOUNDATION TRUST",36627.300000000003,"External Assessment Centres Framework 23-24- Q3 Oct 2023 - Dec 2023 "]
["Department of Health","National Institute For Health And Care Excellence",45292,"Contr Other External","Quality Standards and Indicators-NP","CUMBRIA NORTHUMBERLAND TYNE AND WEAR NHS FOUNDATION TRUST",46185.75,"NEQOS National Collaborating Centre for Indicator Development - Q3 23-24"]
["Department of Health","National Institute For Health And Care Excellence",45292,"Rent","Facilities - Manchester - NP","MJ MAPP LLP",404737.09,"Manchester Office Rental & Service Charge 25.12.2023 - 24.03.2024"]
["Department of Health","National Institute For Health And Care Excellence",45292,"Programme Support Costs","Clinical Team","UNIVERSITY HOSPITALS BRISTOL & WESTON NHS FOUNDATION TRUST",39292.080000000002,"Secondee Recharge Q3 23-24"]
["Department of Health","National Institute For Health And Care Excellence",45292,"Contr Other External","Medical Technologies Evaluation Programme - NP","UNIVERSITY OF SHEFFIELD",41000,"MedTech External Assessment Centre  - Q3 2023/24"]
["Department of Health","National Institute For Health And Care Excellence",45292,"Computer Software/License","DIT non pay","ULTIMA BUSINESS SOLUTIONS LTD",25801.52,"Premium Collaborative Enterprise Support"]
["Department of Health","National Institute For Health And Care Excellence",45292,"Contr Other External","BNF - NP","ROYAL PHARMACEUTICAL SOCIETY",947500,"BNF Knowledge creation costs, Q4 2023-24"]

{"sheet":"Macro1","index":1,"n_rows":94,"n_cols":2,"rows_kept":94,"cut":false,"hidden":true,"merged":[]}
["Macro1","Auto_Open"]
[{"$f":"ALIGNMENT(2,FALSE,1,0,FALSE)","v":true},{"$f":"ERROR(2,Recover)","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,1,1,1,1)","v":true},{"$f":"WORKBOOK.SELECT(\"AP\")","v":true}]
[{"$f":"PATTERNS(1,0,2,TRUE)","v":true},{"$f":"WINDOW.RESTORE()","v":true}]
[{"$f":"FORMAT.FONT(\"Arial\",10,FALSE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true},{"$f":"WINDOW.SIZE(82.5,42.75)","v":true}]
[{"$f":"RETURN()","v":true},{"$f":"WORKBOOK.HIDE(\"Macro1\",TRUE)","v":true}]
[null,{"$f":"EDIT.COLOR(1,0,0,0)","v":true}]
["Macro10",{"$f":"EDIT.COLOR(3,255,0,0)","v":true}]
[{"$f":"WORKBOOK.SELECT(\"AP\")","v":true},{"$f":"EDIT.COLOR(4,212,212,212)","v":true}]
[{"$f":"SELECT(\"R2C1:R23C7,R2C9:R23C9\")","v":true},{"$f":"EDIT.COLOR(5,247,247,231)","v":true}]
[{"$f":"RUN(\"Macro1\")","v":{"$error":"#N/A"}},{"$f":"EDIT.COLOR(2,255,255,255)","v":true}]
[{"$f":"SELECT(\"R2C8:R23C8\")","v":true},{"$f":"RUN(\"Macro10\")","v":{"$error":"#N/A"}}]
[{"$f":"RUN(\"Macro2\")","v":{"$error":"#N/A"}},{"$f":"DELETE.NAME(\"Auto_Open\")","v":true}]
[{"$f":"SELECT(\"R2C7:R23C7\")","v":true},{"$f":"WORKBOOK.SELECT(\"AP\")","v":true}]
[{"$f":"FORMAT.NUMBER(\"###############0\")","v":true},{"$f":"SELECT(\"R1:R65536\")","v":true}]
[{"$f":"SELECT(\"R2C8:R23C8\")","v":true},{"$f":"COLUMN.WIDTH(,,,3)","v":true}]
[{"$f":"FORMAT.NUMBER(\"#,###,###,##0.00;[Color3]-#,###,###,##0.00\")","v":true},{"$f":"ROW.HEIGHT(,,,3)","v":true}]
[{"$f":"SELECT(\"R2C3:R23C3\")","v":true},{"$f":"SELECT(\"R1C1\")","v":true}]
[{"$f":"FORMAT.NUMBER(\"dd/mm/yyyy\")","v":true},{"$f":"WINDOW.MAXIMIZE()","v":true}]
[{"$f":"SELECT(\"R1C1\")","v":true},{"$f":"RETURN()","v":true}]
[{"$f":"RUN(\"Macro3\")","v":{"$error":"#N/A"}}]
[{"$f":"SELECT(\"R1C2,R1C5\")","v":true}]
[{"$f":"RUN(\"Macro4\")","v":{"$error":"#N/A"}}]
[{"$f":"SELECT(\"R1C3\")","v":true}]
[{"$f":"RUN(\"Macro5\")","v":{"$error":"#N/A"}}]
[{"$f":"SELECT(\"R1C4,R1C9\")","v":true}]
[{"$f":"RUN(\"Macro6\")","v":{"$error":"#N/A"}}]
[{"$f":"SELECT(\"R1C6\")","v":true}]
[{"$f":"RUN(\"Macro7\")","v":{"$error":"#N/A"}}]
[{"$f":"SELECT(\"R1C7\")","v":true}]
[{"$f":"RUN(\"Macro8\")","v":{"$error":"#N/A"}}]
[{"$f":"SELECT(\"R1C8\")","v":true}]
[{"$f":"RUN(\"Macro9\")","v":{"$error":"#N/A"}}]
[{"$f":"RETURN()","v":true}]
[]
["Macro2"]
[{"$f":"ALIGNMENT(4,FALSE,1,0,FALSE)","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,1,1,1,1)","v":true}]
[{"$f":"PATTERNS(1,0,2,TRUE)","v":true}]
[{"$f":"FORMAT.FONT(\"Arial\",10,FALSE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true}]
[{"$f":"RETURN()","v":true}]
[]
["Macro3"]
[{"$f":"ALIGNMENT(2,FALSE,1,0,FALSE)","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,1,1,1,1)","v":true}]
[{"$f":"PATTERNS(1,0,5,TRUE)","v":true}]
[{"$f":"FORMAT.FONT(\"Arial\",11,FALSE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true}]
[{"$f":"RETURN()","v":true}]
[]
["Macro4"]
[{"$f":"ALIGNMENT(2,FALSE,1,0,FALSE)","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,1,1,1,1)","v":true}]
[{"$f":"PATTERNS(1,0,5,TRUE)","v":true}]
[{"$f":"FORMAT.FONT(\"Arial\",11,FALSE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true}]
[{"$f":"RETURN()","v":true}]
[]
["Macro5"]
[{"$f":"ALIGNMENT(2,FALSE,1,0,FALSE)","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,1,1,1,1)","v":true}]
[{"$f":"PATTERNS(1,0,5,TRUE)","v":true}]
[{"$f":"FORMAT.FONT(\"Arial\",11,FALSE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true}]
[{"$f":"RETURN()","v":true}]
[]
["Macro6"]
[{"$f":"ALIGNMENT(2,FALSE,1,0,FALSE)","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,1,1,1,1)","v":true}]
[{"$f":"PATTERNS(1,0,5,TRUE)","v":true}]
[{"$f":"FORMAT.FONT(\"Arial\",11,FALSE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true}]
[{"$f":"RETURN()","v":true}]
[]
["Macro7"]
[{"$f":"ALIGNMENT(2,FALSE,1,0,FALSE)","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,1,1,1,1)","v":true}]
[{"$f":"PATTERNS(1,0,5,TRUE)","v":true}]
[{"$f":"FORMAT.FONT(\"Arial\",11,FALSE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true}]
[{"$f":"RETURN()","v":true}]
[]
["Macro8"]
[{"$f":"ALIGNMENT(2,FALSE,1,0,FALSE)","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,1,1,1,1)","v":true}]
[{"$f":"PATTERNS(1,0,5,TRUE)","v":true}]
[{"$f":"FORMAT.FONT(\"Arial\",11,FALSE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true}]
[{"$f":"RETURN()","v":true}]
[]
["Macro9"]
[{"$f":"ALIGNMENT(2,TRUE,1,0,FALSE)","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,1,1,1,1)","v":true}]
[{"$f":"PATTERNS(1,0,5,TRUE)","v":true}]
[{"$f":"FORMAT.FONT(\"Arial\",11,FALSE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true}]
[{"$f":"RETURN()","v":true}]
[]
["Recover"]
[{"$f":"GOTO(OFFSET(LAST.ERROR(),1,0))","v":false}]
[{"$f":"RETURN()","v":true}]