{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":20,"n_cols":20,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,1,20,12]]}
[null,"name of staff member","name of staff member","name of staff member","name of staff member","name of staff member","name of staff member","name of staff member","name of staff member","name of staff member","name of staff member","name of staff member","name of staff member","name of staff member","name of staff member","name of staff member","name of staff member",null,null,"OUTSTANDING PAPERWORK"]
[null,"JONES","JONES","JONES","JONES","JONES","JONES","JONES","JONES","JONES","JONES","JONES","JONES","JONES","JONES","JONES","JONES",null,"JONES",6]
[null,"SMITH","SMITH","SMITH","SMITH","SMITH","SMITH","SMITH","SMITH","SMITH",null,"SMITH","SMITH","SMITH","SMITH","SMITH","SMITH",null,"SMITH",3]
[null,"BLOGGS","BLOGGS","BLOGGS","BLOGGS","BLOGGS","BLOGGS","BLOGGS","BLOGGS","BLOGGS",null,"BLOGGS","BLOGGS","BLOGGS","BLOGGS","BLOGGS","BLOGGS",null,"BLOGGS",3]
[null,"WALKER","WALKER","WALKER","WALKER","WALKER","WALKER","WALKER","WALKER","WALKER","WALKER","WALKER","WALKER","WALKER","WALKER","WALKER","WALKER",null,"WALKER",4]
[null,"HILL","HILL","HILL","HILL","HILL","HILL","HILL","HILL","HILL","HILL","HILL","HILL","HILL","HILL","HILL","HILL",null,"HILL",7]
[null,"RUDD","RUDD","RUDD","RUDD","RUDD",null,"RUDD","RUDD","RUDD","RUDD","RUDD","RUDD","RUDD","RUDD","RUDD","RUDD",null,"RUDD",5]
[null,"SONNY","SONNY","SONNY","SONNY","SONNY","SONNY","SONNY","SONNY","SONNY","SONNY","SONNY","SONNY","SONNY","SONNY","SONNY","SONNY",null,"SONNY",8]
[null,null,"TENCH","TENCH","TENCH","TENCH","TENCH","TENCH","TENCH","TENCH","TENCH","TENCH",null,null,"TENCH","TENCH","TENCH",null,"TENCH",6]
[null,"SOOTY","SOOTY","SOOTY","SOOTY","SOOTY","SOOTY","SOOTY","SOOTY","SOOTY","SOOTY","SOOTY","SOOTY","SOOTY","SOOTY","SOOTY","SOOTY",null,"SOOTY",11]
[null,"GOFF","GOFF","GOFF","GOFF","GOFF","GOFF","GOFF","GOFF","GOFF","GOFF","GOFF","GOFF","GOFF","GOFF","GOFF","GOFF",null,"GOFF",12]
[null,"WK1","WK2","WK3","WK4","WK5","WK6","WK7","WK8","WK9","WK10","WK11","WK12","WK13","WK14","WK15","WK16"]
[]
["key"]
[null,"GREEN CELL IS PAPERWORK COMPLETE (these cells will be hyperlinked to their papers)"]
[null,"PAPERWORK NOT SUBMITTED (outstanding)"]
[]
[]
[null,"This is a sample doc. The list has 150 names, over 52 weeks."]
[null,"I need to be able to count all missing paperwork (white named cells), but obviously not count green cells. Then have the count tranferred to the name list, against the corresponding person and have this done from a button click."]