{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["PRACTICE","WEST","MACRO"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":"PRACTICE","index":0,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["LIST OF UNIQUE PRACTICES"]
[]
["PRACTICE ID","PRACTICE NAME"]
[1,{"$f":"\"PRACTICE\"&A4","v":"PRACTICE1"}]
[2,{"$f":"\"PRACTICE\"&A5","v":"PRACTICE2"}]
[3,"PRACTICE3"]
[4,"PRACTICE4"]
[5,"PRACTICE5"]
[6,"PRACTICE6"]
[7,"PRACTICE7"]

{"sheet":"WEST","index":1,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[6,6,6,11],[2,9,3,11]]}
[]
[]
[null,null,null,null,null,null,null,null,null,"<--save workbook in a folder, then press the macro button to save a pdf copy of the report for each practice"]
[]
[]
[]
[null,null,null,null,null,null,"YTD PERFORMANCE\nUNDER/(OVER)"]
["TYPE (PRACTICE / FED)","AREA","ID NUMBER","PRACTICE CODE","PRACTICE NAME","SERVICE","YTD PLAN ACTIVITY","YTD ACTUAL ACTIVITY","YTD VARIANCE ACTIVITY","YTD PLAN £","YTD ACTUAL £","YTD VARIANCE £"]
["PRACTICE","West",{"$f":"\"A\"&D9","v":"A1"},1,{"$f":"\"PRACTICE\"&D9","v":"PRACTICE1"},"SERVICE 1",35.185312713033383,0,35.185312713033383,516.87224375446044,0,516.87224375446044]
["PRACTICE","West",{"$f":"\"A\"&D10","v":"A1"},1,{"$f":"\"PRACTICE\"&D10","v":"PRACTICE1"},"SERVICE 2",79.54827337842768,0,79.54827337842768,3170.7941768641272,0,3170.7941768641272]
["PRACTICE","West","A2",2,"PRACTICE2","SERVICE 1",48.472795669249209,1,47.472795669249209,712.0653683812709,14.69,697.37536838127085]
["PRACTICE","West","A2",2,"PRACTICE2","SERVICE 2",67.789264975762009,0,67.789264975762009,2702.0801019338737,0,2702.0801019338737]
["PRACTICE","West","A3",3,"PRACTICE3","SERVICE 1",50.246814068255588,6,44.246814068255588,738.12569866267461,88.14,649.98569866267462]
["PRACTICE","West","A3",3,"PRACTICE3","SERVICE 2",0,0,0,0,0,0]
["PRACTICE","West","A4",4,"PRACTICE4","SERVICE 1",22.904176093261313,0,22.904176093261313,336.46234681000868,0,336.46234681000868]
["PRACTICE","West","A4",4,"PRACTICE4","SERVICE 2",0,0,0,0,0,0]
["PRACTICE","West","A5",5,"PRACTICE5","SERVICE 1",73.784368111512777,20,53.784368111512777,1083.8923675581227,293.8,790.09236755812276]
["PRACTICE","West","A5",5,"PRACTICE5","SERVICE 2",125.1108481000157,27,98.110848100015701,4986.918405266626,1076.22,3910.6984052666257]
["PRACTICE","West","A6",6,"PRACTICE6","SERVICE 1",72.45654763284638,0,72.45654763284638,1064.3866847265133,0,1064.3866847265133]
["PRACTICE","West","A6",6,"PRACTICE6","SERVICE 2",122.85935838122525,0,122.85935838122525,4897.1740250756384,0,4897.1740250756384]
["PRACTICE","West","A7",7,"PRACTICE7","SERVICE 1",25.194755082944148,0,25.194755082944148,370.11095216844956,0,370.11095216844956]
["PRACTICE","West","A7",7,"PRACTICE7","SERVICE 2",0,0,0,0,0,0]
[]
[null,null,null,null,null,null,{"$f":"SUBTOTAL(9,G9:G22)","v":723.55251420653349},{"$f":"SUBTOTAL(9,H9:H22)","v":54},669.55251420653349,20578.882371201766,1472.85,19106.032371201763]

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