{"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":21,"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,5]
[null,null,null,null,null,null,null,null,null,"Start date",null,"2018-01-01",{"$f":"IF(M6=\"months\",\"please select date before 28th\")","v":false}]
[null,null,"Organisation name",null,null,"Wellington trust",null,null,null,"Planned duration",null,30,"days"]
[null,null,"Team/unit name",null,null,"Boot ward",null,null,null,"(days, weeks, months)"]
[null,null,"Your measure",null,null,"Why I am late?",null,null,null,{"$f":"IF(M6=\"days\",\"Include weekends?\",\"\")","v":"Include weekends?"},null,"No",{"$f":"IF(M6=\"days\",\"This option cannot be chosen retrospectively. Weekend data should not be entered when chosen.\",\"\")","v":"This option cannot be chosen retrospectively. Weekend data should not be entered when chosen."}]
[]
[]
[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,{"$f":"F8","v":"Why I am late?"},null,"Date",{"$f":"IF($D$32=\"\",99,$D$32)","v":"Lost dog"},{"$f":"IF($D$33=\"\",99,$D$33)","v":"Lost homework"},{"$f":"IF($D$34=\"\",99,$D$34)","v":"Dog ate homework"},{"$f":"IF($D$35=\"\",99,$D$35)","v":"Lost gloves"},{"$f":"IF($D$36=\"\",99,$D$36)","v":"Dog ate gloves"},{"$f":"IF($D$37=\"\",99,$D$37)","v":99},{"$f":"IF($D$38=\"\",99,$D$38)","v":99},{"$f":"IF($D$39=\"\",99,$D$39)","v":99},{"$f":"IF($D$40=\"\",99,$D$40)","v":99},{"$f":"IF($D$41=\"\",99,$D$41)","v":99},{"$f":"IF($D$42=\"\",99,$D$42)","v":99},{"$f":"IF($D$43=\"\",99,$D$43)","v":99},{"$f":"IF($D$44=\"\",99,$D$44)","v":99},{"$f":"IF($D$45=\"\",99,$D$45)","v":99},{"$f":"IF($D$46=\"\",99,$D$46)","v":99}]
[null,1,1,"Lost dog",null,{"$f":"IF(R4=\"No\",IF(WEEKDAY(L5)=1,L5+1,IF(WEEKDAY(L5)=7,L5+2,L5)),L5)","v":"2018-01-01"},1,null,1,null,1]
[null,2,2,"Lost homework",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":"2018-01-02"},1]
[null,3,3,"Dog ate homework",null,"2018-01-03",null,null,1,4]
[null,4,4,"Lost gloves",null,"2018-01-04"]
[null,5,5,"Dog ate gloves",null,"2018-01-05",1,null,1]
[null,6,6,null,null,"2018-01-08",1]
[null,7,7,null,null,"2018-01-09",null,null,null,1]
[null,8,8,null,null,"2018-01-10"]
[null,9,9,null,null,"2018-01-11",1,1,null,1]
[null,10,10,null,null,"2018-01-12",1,1,null,1,1]
[null,11,11,null,null,"2018-01-15",1,1,null,null,1]
[null,12,12,null,null,"2018-01-16"]
[null,13,13,null,null,"2018-01-17"]
[null,14,14,null,null,"2018-01-18",null,1]
[null,15,15,null,null,"2018-01-19",null,1]
[null,22,null,null,null,"2018-01-22",null,1]
[null,23,null,null,null,"2018-01-23"]
[null,24,null,null,null,"2018-01-24"]
[null,25,null,null,null,"2018-01-25"]
[null,26,null,null,null,"2018-01-26"]
[null,27,null,null,null,"2018-01-29"]
[null,28,null,null,null,"2018-01-30"]
[null,29,null,null,null,"2018-01-31"]
[null,30,null,null,null,"2018-02-01"]
[null,null,null,null,null,"2018-02-02"]
[null,null,null,null,null,"2018-02-05"]
[null,null,null,null,null,"2018-02-06"]
[null,null,null,null,null,"2018-02-07"]
[null,null,null,null,null,"2018-02-08"]
[null,null,null,null,null,"2018-02-09"]

{"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":30},null,{"$f":"'Front sheet'!F6 & \" - \"&'Front sheet'!F7 & \" - \" &'Front sheet'!F8","v":"Wellington trust - Boot ward - Why I am late?"},null,null,null,null,null,null,null,"days",null,"Yes"]
[null,"Categories",{"$f":"IF(MAX(A6:A20)=0,1,MAX(A6:A20))","v":5},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":1},{"$f":"IF('Front sheet'!D32= \"\",\"\",'Front sheet'!D32)","v":"Lost dog"},{"$f":"IF(B6=\"\",\"\",SUM(OFFSET('Front sheet'!$F$32,0,'Worksheet 1'!$A6,'Worksheet 1'!$C$2,1)))","v":7},null,{"$f":"IF(B6=\"\",\"\",RANK(C6,$C$6:$C$20,0))","v":1},{"$f":"IF(B6=\"\",\"\",E6-IF(COUNTIF($E$6:$E$20,E6)>1,ROW()/100,0))","v":0.94},{"$f":"IF(B6=\"\",\"\",RANK(F6,$F$6:$F$20,1))","v":2},{"$f":"INDEX($B$6:$B$20,MATCH($A6,$G$6:$G$20,0))","v":"Lost gloves"},{"$f":"INDEX($C$6:$C$20,MATCH($A6,$G$6:$G$20,0))","v":7},{"$f":"IF(H6=\"\",\"\",I6/$I$21)","v":0.26923076923076922}]
[{"$f":"IF(B7=\"\",\"\",A6+1)","v":2},{"$f":"IF('Front sheet'!D33= \"\",\"\",'Front sheet'!D33)","v":"Lost homework"},{"$f":"IF(B7=\"\",\"\",SUM(OFFSET('Front sheet'!$F$32,0,'Worksheet 1'!$A7,'Worksheet 1'!$C$2,1)))","v":6},null,3,3,3,"Lost dog",{"$f":"INDEX($C$6:$C$20,MATCH($A7,$G$6:$G$20,0),1)","v":7},{"$f":"IF(H7=\"\",\"\",I7/$I$21+J6)","v":0.53846153846153844}]
[3,{"$f":"IF('Front sheet'!D34= \"\",\"\",'Front sheet'!D34)","v":"Dog ate homework"},{"$f":"IF(B8=\"\",\"\",SUM(OFFSET('Front sheet'!$F$32,0,'Worksheet 1'!$A8,'Worksheet 1'!$C$2,1)))","v":3},null,4,3.92,5,"Lost homework",6,0.76923076923076916]
[4,{"$f":"IF('Front sheet'!D35= \"\",\"\",'Front sheet'!D35)","v":"Lost gloves"},{"$f":"IF(B9=\"\",\"\",SUM(OFFSET('Front sheet'!$F$32,0,'Worksheet 1'!$A9,'Worksheet 1'!$C$2,1)))","v":7},null,1,0.91,1,"Dog ate gloves",3,0.88461538461538458]
[5,{"$f":"IF('Front sheet'!D36= \"\",\"\",'Front sheet'!D36)","v":"Dog ate gloves"},{"$f":"IF(B10=\"\",\"\",SUM(OFFSET('Front sheet'!$F$32,0,'Worksheet 1'!$A10,'Worksheet 1'!$C$2,1)))","v":3},null,4,3.9,4,"Dog ate homework",3,1]
["",{"$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":26}]