{"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":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Department Family","Entity","Date","Expense Type","Expense Area","Supplier","Transaction Number","Amount","Description"]
["Department of Health","National Institute For Health And Care Excellence","2021-05-31","Contr Other External","DIT non pay","SAVILLE GROUP LTD (THE)",38144982,125219.6,"Purchase of AV equipment"]
["Department of Health","National Institute For Health And Care Excellence","2021-05-31","Contr Other External","Evidence Services - NP","CLARITY INFORMATICS LTD",38144984,44100,"NICE Clinical Knowledge Summaries (CKS) Contract - April 2021"]
["Department of Health","National Institute For Health And Care Excellence","2021-05-31","Legal / Prof Fees","Corporate Office - NP","DAC BEACHCROFT LLP",38162274,26381.759999999998,"Legal and professional charges period to 27 April 2021"]
["Department of Health","National Institute For Health And Care Excellence","2021-05-31","Computer Software/License","DIT non pay","PHOENIX SOFTWARE LTD",38186339,41512.26,"VMWare 1 year licence subscription and support"]
["Department of Health","National Institute For Health And Care Excellence","2021-05-31","Computer Software/License","Evidence Services - NP","JISC",38186345,82500,"OpenAthens license fee - 01/02/2021 - 30/04/2021"]
["Department of Health","National Institute For Health And Care Excellence","2021-05-31","Contr Other External","Medical Technologies Evaluation Programme - NP","KINGS COLLEGE LONDON",38186357,46626,"NICE Medical Technology External Assessment Centre contract with KITEC"]
["Department of Health","National Institute For Health And Care Excellence","2021-05-31","Contr Other External","Commissioning Team - NP","ROYAL COLLEGE OF PHYSICIANS",38186393,636120,"National Guideline Centre Q1 funding 2021-22"]
["Department of Health","National Institute For Health And Care Excellence","2021-05-31","Contr Other External","BNF - NP","ROYAL PHARMACEUTICAL SOCIETY",38235426,947500,"BNF Knowledge creation costs, Q1 2021-22"]
["Department of Health","National Institute For Health And Care Excellence","2021-05-31","Contr Other External","Medical Technologies Evaluation Programme - NP","KINGS COLLEGE LONDON",38271849,118201.13,"NICE Medical Technology External Assessment Centre contract with KITEC - CTE Project"]
["Department of Health","National Institute For Health And Care Excellence","2021-05-31","Books, Journals & Subscr","Evidence Services - NP","JOHN WILEY & SONS LTD",38271889,78000,"Cochrane Enhanced Access Library License - Q1 01/05/21 - 31/07/21"]
["Department of Health","National Institute For Health And Care Excellence","2021-05-31","Contr Other External","DIT non pay","INSPIRED NETWORKS",38343983,40590.6,"IT Support and Management contract for April 2021"]
["Department of Health","National Institute For Health And Care Excellence","2021-05-31","Contr Other External","Evidence Services - NP","CLARITY INFORMATICS LTD",38343985,44100,"NICE Clinical Knowledge Summaries (CKS) Contract - May 2021"]

{"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}]