{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Front sheet","Worksheet 1"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":6,"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":"Front sheet","index":0,"n_rows":61,"n_cols":19,"rows_kept":61,"cut":false,"hidden":false,"merged":[[10,18,10,20],[7,9,7,10],[7,12,8,15],[3,9,3,10],[2,2,3,7],[5,5,5,7],[6,5,6,7],[7,5,7,7]]}
[]
[]
[null,null,"Pareto chart"]
[null,null,null,null,null,null,null,null,null,"Maximum number"]
[null,null,null,null,null,null,null,null,null,"Start date",null,null,{"$f":"IF(M6=\"months\",\"please select date before 28th\")","v":false}]
[null,null,"Organisation name",null,null,null,null,null,null,"Planned duration"]
[null,null,"Team/unit name",null,null,null,null,null,null,"(days, weeks, months)"]
[null,null,"Your measure",null,null,null,null,null,null,{"$f":"IF(M6=\"days\",\"Include weekends?\",\"\")","v":""},null,"No",{"$f":"IF(M6=\"days\",\"This option cannot be chosen retrospectively. Weekend data should not be entered when chosen.\",\"\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions\n\nPlease enter your \n\n1)  Organisation name\n2)  Team or unit \n3)  What you are measuring\n4)  Maximum possible entry\n5)  Start date\n6)  Planned duration in \n     days, weeks or months\n7)  If days selected indicate if \n     weekends should be included\n8)  Enter the categories for your \n     measures below\n9)  Enter the data in the yellow \n     and green cells in the table\n"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Date"]
[null,1,1,null,null,{"$f":"IF(R4=\"No\",IF(WEEKDAY(L5)=1,L5+1,IF(WEEKDAY(L5)=7,L5+2,L5)),L5)","v":"00:00:00"}]
[null,2,2,null,null,{"$f":"IF(OR(F32=\"\",B33>$L$6),\"\",IF($M$6=\"Days\",IF($L$8=\"No\",IF(WEEKDAY(F32)=6,F32+3,F32+1),F32+1),IF($M$6=\"Months\",VALUE(DAY($F32) & \"/\" & MONTH(F32+31) & \"/\"& YEAR(F32+31)),F32+7)))","v":""}]
[null,3,3,null,null,""]
[null,4,4,null,null,""]
[null,5,5,null,null,""]
[null,6,6,null,null,""]
[null,7,7,null,null,""]
[null,8,8,null,null,""]
[null,9,9,null,null,""]
[null,10,10,null,null,""]
[null,11,11,null,null,""]
[null,12,12,null,null,""]
[null,13,13,null,null,""]
[null,14,14,null,null,""]
[null,15,15,null,null,""]
[null,22,null,null,null,""]
[null,23,null,null,null,""]
[null,24,null,null,null,""]
[null,25,null,null,null,""]
[null,26,null,null,null,""]
[null,27,null,null,null,""]
[null,28,null,null,null,""]
[null,29,null,null,null,""]
[null,30,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]

{"sheet":"Worksheet 1","index":1,"n_rows":21,"n_cols":15,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Woeksheet 1"]
[null,"Rows of data ",{"$f":"IF('Front sheet'!L6=0,1,'Front sheet'!L6)","v":1},null,{"$f":"'Front sheet'!F6 & \" - \"&'Front sheet'!F7 & \" - \" &'Front sheet'!F8","v":" -  - "},null,null,null,null,null,null,null,"days",null,"Yes"]
[null,"Categories",{"$f":"IF(MAX(A6:A20)=0,1,MAX(A6:A20))","v":1},null,null,null,null,null,null,null,null,null,"weeks",null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,"months"]
[null,"Categories","Score",null,"Rank","Adj rank","Final  rank","Category","Score","%"]
[{"$f":"IF(B6=\"\",\"\",A5+1)","v":""},{"$f":"IF('Front sheet'!D32= \"\",\"\",'Front sheet'!D32)","v":""},{"$f":"IF(B6=\"\",\"\",SUM(OFFSET('Front sheet'!$F$32,0,'Worksheet 1'!$A6,'Worksheet 1'!$C$2,1)))","v":""},null,{"$f":"IF(B6=\"\",\"\",RANK(C6,$C$6:$C$20,0))","v":""},{"$f":"IF(B6=\"\",\"\",E6-IF(COUNTIF($E$6:$E$20,E6)>1,ROW()/100,0))","v":""},{"$f":"IF(B6=\"\",\"\",RANK(F6,$F$6:$F$20,1))","v":""},{"$f":"INDEX($B$6:$B$20,MATCH($A6,$G$6:$G$20,0))","v":""},{"$f":"INDEX($C$6:$C$20,MATCH($A6,$G$6:$G$20,0))","v":""},{"$f":"IF(H6=\"\",\"\",I6/$I$21)","v":""}]
[{"$f":"IF(B7=\"\",\"\",A6+1)","v":""},{"$f":"IF('Front sheet'!D33= \"\",\"\",'Front sheet'!D33)","v":""},{"$f":"IF(B7=\"\",\"\",SUM(OFFSET('Front sheet'!$F$32,0,'Worksheet 1'!$A7,'Worksheet 1'!$C$2,1)))","v":""},null,"","","","",{"$f":"INDEX($C$6:$C$20,MATCH($A7,$G$6:$G$20,0),1)","v":""},{"$f":"IF(H7=\"\",\"\",I7/$I$21+J6)","v":""}]
["",{"$f":"IF('Front sheet'!D34= \"\",\"\",'Front sheet'!D34)","v":""},{"$f":"IF(B8=\"\",\"\",SUM(OFFSET('Front sheet'!$F$32,0,'Worksheet 1'!$A8,'Worksheet 1'!$C$2,1)))","v":""},null,"","","","","",""]
["",{"$f":"IF('Front sheet'!D35= \"\",\"\",'Front sheet'!D35)","v":""},{"$f":"IF(B9=\"\",\"\",SUM(OFFSET('Front sheet'!$F$32,0,'Worksheet 1'!$A9,'Worksheet 1'!$C$2,1)))","v":""},null,"","","","","",""]
["",{"$f":"IF('Front sheet'!D36= \"\",\"\",'Front sheet'!D36)","v":""},{"$f":"IF(B10=\"\",\"\",SUM(OFFSET('Front sheet'!$F$32,0,'Worksheet 1'!$A10,'Worksheet 1'!$C$2,1)))","v":""},null,"","","","","",""]
["",{"$f":"IF('Front sheet'!D37= \"\",\"\",'Front sheet'!D37)","v":""},{"$f":"IF(B11=\"\",\"\",SUM(OFFSET('Front sheet'!$F$32,0,'Worksheet 1'!$A11,'Worksheet 1'!$C$2,1)))","v":""},null,"","","","","",""]
["",{"$f":"IF('Front sheet'!D38= \"\",\"\",'Front sheet'!D38)","v":""},{"$f":"IF(B12=\"\",\"\",SUM(OFFSET('Front sheet'!$F$32,0,'Worksheet 1'!$A12,'Worksheet 1'!$C$2,1)))","v":""},null,"","","","","",""]
["",{"$f":"IF('Front sheet'!D39= \"\",\"\",'Front sheet'!D39)","v":""},{"$f":"IF(B13=\"\",\"\",SUM(OFFSET('Front sheet'!$F$32,0,'Worksheet 1'!$A13,'Worksheet 1'!$C$2,1)))","v":""},null,"","","","","",""]
["",{"$f":"IF('Front sheet'!D40= \"\",\"\",'Front sheet'!D40)","v":""},{"$f":"IF(B14=\"\",\"\",SUM(OFFSET('Front sheet'!$F$32,0,'Worksheet 1'!$A14,'Worksheet 1'!$C$2,1)))","v":""},null,"","","","","",""]
["",{"$f":"IF('Front sheet'!D41= \"\",\"\",'Front sheet'!D41)","v":""},{"$f":"IF(B15=\"\",\"\",SUM(OFFSET('Front sheet'!$F$32,0,'Worksheet 1'!$A15,'Worksheet 1'!$C$2,1)))","v":""},null,"","","","","",""]
["",{"$f":"IF('Front sheet'!D42= \"\",\"\",'Front sheet'!D42)","v":""},{"$f":"IF(B16=\"\",\"\",SUM(OFFSET('Front sheet'!$F$32,0,'Worksheet 1'!$A16,'Worksheet 1'!$C$2,1)))","v":""},null,"","","","","",""]
["",{"$f":"IF('Front sheet'!D43= \"\",\"\",'Front sheet'!D43)","v":""},{"$f":"IF(B17=\"\",\"\",SUM(OFFSET('Front sheet'!$F$32,0,'Worksheet 1'!$A17,'Worksheet 1'!$C$2,1)))","v":""},null,"","","","","",""]
["",{"$f":"IF('Front sheet'!D44= \"\",\"\",'Front sheet'!D44)","v":""},{"$f":"IF(B18=\"\",\"\",SUM(OFFSET('Front sheet'!$F$32,0,'Worksheet 1'!$A18,'Worksheet 1'!$C$2,1)))","v":""},null,"","","","","",""]
["",{"$f":"IF('Front sheet'!D45= \"\",\"\",'Front sheet'!D45)","v":""},{"$f":"IF(B19=\"\",\"\",SUM(OFFSET('Front sheet'!$F$32,0,'Worksheet 1'!$A19,'Worksheet 1'!$C$2,1)))","v":""},null,"","","","","",""]
["",{"$f":"IF('Front sheet'!D46= \"\",\"\",'Front sheet'!D46)","v":""},{"$f":"IF(B20=\"\",\"\",SUM(OFFSET('Front sheet'!$F$32,0,'Worksheet 1'!$A20,'Worksheet 1'!$C$2,1)))","v":""},null,"","","","","",""]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I6:I20)","v":0}]