{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["Splash","Analyse","Worksheet","CurrentRoster","ICUextraDays","PubHol","Backup","Requests","Generator","Sheet1"],"not_rendered":{"images":13,"macros":1,"external_links":2,"defined_names":48,"comments":5},"read":"whole","date_system":"1900"}

{"sheet":"Splash","index":0,"n_rows":7,"n_cols":2,"rows_kept":7,"hidden":true,"merged":[[2,1,2,8],[4,1,4,8],[6,1,6,8]]}
[]
[]
[null,"THIS EXCEL WORKBOOK WILL ONLY FUNCTION IF MACROS ARE ENABLED"]
[]
[null,"YOU MAY NEED TO LOWER YOUR MACRO SECURITY SETTING"]
[]
[null,"[TOOLS]-[OPTIONS]-[SECURITY]-MACRO SECURITY]"]

{"sheet":"Analyse","index":1,"n_rows":65,"n_cols":23,"rows_kept":65,"hidden":true,"merged":[[4,1,4,3],[4,5,4,7],[4,9,4,11],[4,13,4,15],[4,18,4,20],[37,9,37,10],[37,13,37,14],[38,0,38,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[51,2,51,3],[52,2,52,3],[53,2,53,3],[54,2,54,3],[55,2,55,3],[56,2,56,3],[57,2,57,3],[58,2,58,3],[59,2,59,3],[60,2,60,3],[61,2,61,3],[62,2,62,3],[63,2,63,3],[64,2,64,3]]}
[]
["Number of nights done by each anaesthetist"]
[]
[]
[null,{"$f":"Worksheet!L3","v":"ALL NIGHTS"},{"$nulls":3},{"$f":"Worksheet!P3","v":"ICU"},{"$nulls":3},{"$f":"Worksheet!T3","v":"AGB"},{"$nulls":3},{"$f":"Worksheet!X3","v":"BHS"},{"$nulls":3},"AGB",{"$f":"Worksheet!AB3","v":"BACKUP"},{"$nulls":3},"ELECTIVE"]
[null,{"$f":"Worksheet!L4","v":"Mon-Thu"},{"$f":"Worksheet!M4","v":"Fri"},{"$f":"Worksheet!N4","v":"Sat+Sun"},null,{"$f":"Worksheet!P4","v":"Mon-Thu"},{"$f":"Worksheet!Q4","v":"Fri"},{"$f":"Worksheet!R4","v":"Sat+Sun"},null,{"$f":"Worksheet!T4","v":"Mon-Thu"},{"$f":"Worksheet!U4","v":"Fri"},{"$f":"Worksheet!V4","v":"Sat+Sun"},null,{"$f":"Worksheet!X4","v":"Mon-Thu"},{"$f":"Worksheet!Y4","v":"Fri"},{"$f":"Worksheet!Z4","v":"Sat OR Sun"},null,"Thurs",{"$f":"Worksheet!AB4","v":"Mon-Thu"},{"$f":"Worksheet!AC4","v":"Fri"},{"$f":"Worksheet!AD4","v":"Sat+Sun"},null,"SATURDAY"]
[{"$f":"Worksheet!K5","v":"PJC"},{"$f":"Worksheet!L5","v":16},{"$f":"Worksheet!M5","v":5},{"$f":"Worksheet!N5","v":5},null,{"$f":"Worksheet!P5","v":0},{"$f":"Worksheet!Q5","v":0},{"$f":"Worksheet!R5","v":0},null,{"$f":"Worksheet!T5","v":11},{"$f":"Worksheet!U5","v":4},{"$f":"Worksheet!V5","v":4},null,{"$f":"Worksheet!X5","v":5},{"$f":"Worksheet!Y5","v":1},{"$f":"Worksheet!Z5","v":3},{"$f":"A7","v":"PJC"},{"$f":"Worksheet!W5","v":3},{"$f":"Worksheet!AB5","v":10},{"$f":"Worksheet!AC5","v":4},{"$f":"Worksheet!AD5","v":4},null,{"$f":"Worksheet!AG5","v":0}]
[{"$f":"Worksheet!K6","v":"RAC"},{"$f":"Worksheet!L6","v":17},{"$f":"Worksheet!M6","v":4},{"$f":"Worksheet!N6","v":4.5},null,{"$f":"Worksheet!P6","v":0},{"$f":"Worksheet!Q6","v":0},{"$f":"Worksheet!R6","v":0},null,{"$f":"Worksheet!T6","v":13},{"$f":"Worksheet!U6","v":3},{"$f":"Worksheet!V6","v":3},null,{"$f":"Worksheet!X6","v":4},{"$f":"Worksheet!Y6","v":1},{"$f":"Worksheet!Z6","v":3},{"$f":"A8","v":"RAC"},{"$f":"Worksheet!W6","v":3},{"$f":"Worksheet!AB6","v":12},{"$f":"Worksheet!AC6","v":4},{"$f":"Worksheet!AD6","v":4},null,{"$f":"Worksheet!AG6","v":0}]
[{"$f":"Worksheet!K7","v":"REC"},{"$f":"Worksheet!L7","v":12},{"$f":"Worksheet!M7","v":3},{"$f":"Worksheet!N7","v":3.5},null,{"$f":"Worksheet!P7","v":0},{"$f":"Worksheet!Q7","v":0},{"$f":"Worksheet!R7","v":0},null,{"$f":"Worksheet!T7","v":10},{"$f":"Worksheet!U7","v":3},{"$f":"Worksheet!V7","v":3},null,{"$f":"Worksheet!X7","v":2},{"$f":"Worksheet!Y7","v":0},{"$f":"Worksheet!Z7","v":1},"REC",{"$f":"Worksheet!W7","v":4},{"$f":"Worksheet!AB7","v":10},{"$f":"Worksheet!AC7","v":2},{"$f":"Worksheet!AD7","v":2},null,{"$f":"Worksheet!AG7","v":0}]
[{"$f":"Worksheet!K8","v":"JGE"},{"$f":"Worksheet!L8","v":19},{"$f":"Worksheet!M8","v":5},{"$f":"Worksheet!N8","v":4.5},null,{"$f":"Worksheet!P8","v":0},{"$f":"Worksheet!Q8","v":0},{"$f":"Worksheet!R8","v":0},null,{"$f":"Worksheet!T8","v":14},{"$f":"Worksheet!U8","v":3},{"$f":"Worksheet!V8","v":3},null,{"$f":"Worksheet!X8","v":5},{"$f":"Worksheet!Y8","v":2},{"$f":"Worksheet!Z8","v":3},"JGE",{"$f":"Worksheet!W8","v":5},{"$f":"Worksheet!AB8","v":13},{"$f":"Worksheet!AC8","v":3},{"$f":"Worksheet!AD8","v":2.5},null,{"$f":"Worksheet!AG8","v":0}]
[{"$f":"Worksheet!K9","v":"SPF"},{"$f":"Worksheet!L9","v":13},{"$f":"Worksheet!M9","v":3},{"$f":"Worksheet!N9","v":4},null,{"$f":"Worksheet!P9","v":0},{"$f":"Worksheet!Q9","v":0},{"$f":"Worksheet!R9","v":0},null,{"$f":"Worksheet!T9","v":13},{"$f":"Worksheet!U9","v":3},{"$f":"Worksheet!V9","v":4},null,{"$f":"Worksheet!X9","v":0},{"$f":"Worksheet!Y9","v":0},{"$f":"Worksheet!Z9","v":0},"SPF",{"$f":"Worksheet!W9","v":4},{"$f":"Worksheet!AB9","v":13},{"$f":"Worksheet!AC9","v":2},{"$f":"Worksheet!AD9","v":4.5},null,{"$f":"Worksheet!AG9","v":0}]
[{"$f":"Worksheet!K10","v":"GAH"},{"$f":"Worksheet!L10","v":13},{"$f":"Worksheet!M10","v":3},{"$f":"Worksheet!N10","v":3},null,{"$f":"Worksheet!P10","v":0},{"$f":"Worksheet!Q10","v":0},{"$f":"Worksheet!R10","v":0},null,{"$f":"Worksheet!T10","v":13},{"$f":"Worksheet!U10","v":3},{"$f":"Worksheet!V10","v":3},null,{"$f":"Worksheet!X10","v":0},{"$f":"Worksheet!Y10","v":0},{"$f":"Worksheet!Z10","v":0},"GAH",{"$f":"Worksheet!W10","v":0},{"$f":"Worksheet!AB10","v":14},{"$f":"Worksheet!AC10","v":5},{"$f":"Worksheet!AD10","v":4},null,{"$f":"Worksheet!AG10","v":0}]
[{"$f":"Worksheet!K11","v":"DJM"},{"$f":"Worksheet!L11","v":20},{"$f":"Worksheet!M11","v":5},{"$f":"Worksheet!N11","v":4},null,{"$f":"Worksheet!P11","v":0},{"$f":"Worksheet!Q11","v":0},{"$f":"Worksheet!R11","v":0},null,{"$f":"Worksheet!T11","v":17},{"$f":"Worksheet!U11","v":3},{"$f":"Worksheet!V11","v":3},null,{"$f":"Worksheet!X11","v":4},{"$f":"Worksheet!Y11","v":2},{"$f":"Worksheet!Z11","v":2},"DJM",{"$f":"Worksheet!W11","v":3},{"$f":"Worksheet!AB11","v":16},{"$f":"Worksheet!AC11","v":1},{"$f":"Worksheet!AD11","v":3},null,{"$f":"Worksheet!AG11","v":0}]
[{"$f":"Worksheet!K12","v":"CJM"},{"$f":"Worksheet!L12","v":17},{"$f":"Worksheet!M12","v":5},{"$f":"Worksheet!N12","v":4.5},null,{"$f":"Worksheet!P12","v":0},{"$f":"Worksheet!Q12","v":0},{"$f":"Worksheet!R12","v":0},null,{"$f":"Worksheet!T12","v":14},{"$f":"Worksheet!U12","v":3},{"$f":"Worksheet!V12","v":3.5},null,{"$f":"Worksheet!X12","v":4},{"$f":"Worksheet!Y12","v":2},{"$f":"Worksheet!Z12","v":2},"CJM",{"$f":"Worksheet!W12","v":3},{"$f":"Worksheet!AB12","v":10},{"$f":"Worksheet!AC12","v":4},{"$f":"Worksheet!AD12","v":4},null,{"$f":"Worksheet!AG12","v":0}]
[{"$f":"Worksheet!K13","v":"MFS"},{"$f":"Worksheet!L13","v":21},{"$f":"Worksheet!M13","v":5},{"$f":"Worksheet!N13","v":4},null,{"$f":"Worksheet!P13","v":0},{"$f":"Worksheet!Q13","v":0},{"$f":"Worksheet!R13","v":0},null,{"$f":"Worksheet!T13","v":14},{"$f":"Worksheet!U13","v":3},{"$f":"Worksheet!V13","v":3},null,{"$f":"Worksheet!X13","v":7},{"$f":"Worksheet!Y13","v":2},{"$f":"Worksheet!Z13","v":2},"MFS",{"$f":"Worksheet!W13","v":4},{"$f":"Worksheet!AB13","v":10},{"$f":"Worksheet!AC13","v":2},{"$f":"Worksheet!AD13","v":4},null,{"$f":"Worksheet!AG13","v":0}]
[{"$f":"Worksheet!K14","v":"PRS"},{"$f":"Worksheet!L14","v":21},{"$f":"Worksheet!M14","v":3},{"$f":"Worksheet!N14","v":6},null,{"$f":"Worksheet!P14","v":0},{"$f":"Worksheet!Q14","v":0},{"$f":"Worksheet!R14","v":0},null,{"$f":"Worksheet!T14","v":15},{"$f":"Worksheet!U14","v":3},{"$f":"Worksheet!V14","v":4.5},null,{"$f":"Worksheet!X14","v":6},{"$f":"Worksheet!Y14","v":0},{"$f":"Worksheet!Z14","v":3},"PRS",{"$f":"Worksheet!W14","v":6},{"$f":"Worksheet!AB14","v":14},{"$f":"Worksheet!AC14","v":3},{"$f":"Worksheet!AD14","v":3},null,{"$f":"Worksheet!AG14","v":0}]
[{"$f":"Worksheet!K15","v":"HLT"},{"$f":"Worksheet!L15","v":15},{"$f":"Worksheet!M15","v":5},{"$f":"Worksheet!N15","v":5.5},null,{"$f":"Worksheet!P15","v":0},{"$f":"Worksheet!Q15","v":0},{"$f":"Worksheet!R15","v":0},null,{"$f":"Worksheet!T15","v":12},{"$f":"Worksheet!U15","v":4},{"$f":"Worksheet!V15","v":4},null,{"$f":"Worksheet!X15","v":3},{"$f":"Worksheet!Y15","v":1},{"$f":"Worksheet!Z15","v":3},"HLT",{"$f":"Worksheet!W15","v":2},{"$f":"Worksheet!AB15","v":12},{"$f":"Worksheet!AC15","v":5},{"$f":"Worksheet!AD15","v":3},null,{"$f":"Worksheet!AG15","v":0}]
[{"$f":"Worksheet!K16","v":"DRP"},{"$f":"Worksheet!L16","v":0},{"$f":"Worksheet!M16","v":0},{"$f":"Worksheet!N16","v":0},null,{"$f":"Worksheet!P16","v":0},{"$f":"Worksheet!Q16","v":0},{"$f":"Worksheet!R16","v":0},null,{"$f":"Worksheet!T16","v":0},{"$f":"Worksheet!U16","v":0},{"$f":"Worksheet!V16","v":0},null,{"$f":"Worksheet!X16","v":0},{"$f":"Worksheet!Y16","v":0},{"$f":"Worksheet!Z16","v":0},"DRP",{"$f":"Worksheet!W16","v":0},{"$f":"Worksheet!AB16","v":11},{"$f":"Worksheet!AC16","v":0},{"$f":"Worksheet!AD16","v":0},null,{"$f":"Worksheet!AG16","v":0}]
[{"$f":"Worksheet!K17","v":"MBW"},{"$f":"Worksheet!L17","v":0},{"$f":"Worksheet!M17","v":0},{"$f":"Worksheet!N17","v":0},null,{"$f":"Worksheet!P17","v":0},{"$f":"Worksheet!Q17","v":0},{"$f":"Worksheet!R17","v":0},null,{"$f":"Worksheet!T17","v":0},{"$f":"Worksheet!U17","v":0},{"$f":"Worksheet!V17","v":0},null,{"$f":"Worksheet!X17","v":0},{"$f":"Worksheet!Y17","v":0},{"$f":"Worksheet!Z17","v":0},"MBW",{"$f":"Worksheet!W17","v":0},{"$f":"Worksheet!AB17","v":12},{"$f":"Worksheet!AC17","v":0},{"$f":"Worksheet!AD17","v":0},null,{"$f":"Worksheet!AG17","v":0}]
[{"$f":"Worksheet!K18","v":"RCG"},{"$f":"Worksheet!L18","v":34},{"$f":"Worksheet!M18","v":6},{"$f":"Worksheet!N18","v":5},null,{"$f":"Worksheet!P18","v":17},{"$f":"Worksheet!Q18","v":6},{"$f":"Worksheet!R18","v":5},null,{"$f":"Worksheet!T18","v":0},{"$f":"Worksheet!U18","v":0},{"$f":"Worksheet!V18","v":0},null,{"$f":"Worksheet!X18","v":0},{"$f":"Worksheet!Y18","v":0},{"$f":"Worksheet!Z18","v":0},"RCG",{"$f":"Worksheet!W18","v":0},{"$f":"Worksheet!AB18","v":0},{"$f":"Worksheet!AC18","v":0},{"$f":"Worksheet!AD18","v":0},null,{"$f":"Worksheet!AG18","v":0}]
[{"$f":"Worksheet!K19","v":"DBC"},{"$f":"Worksheet!L19","v":28},{"$f":"Worksheet!M19","v":8},{"$f":"Worksheet!N19","v":8},null,{"$f":"Worksheet!P19","v":7},{"$f":"Worksheet!Q19","v":5},{"$f":"Worksheet!R19","v":5},null,{"$f":"Worksheet!T19","v":14},{"$f":"Worksheet!U19","v":3},{"$f":"Worksheet!V19","v":3},null,{"$f":"Worksheet!X19","v":0},{"$f":"Worksheet!Y19","v":0},{"$f":"Worksheet!Z19","v":0},"DBC",{"$f":"Worksheet!W19","v":3},{"$f":"Worksheet!AB19","v":13},{"$f":"Worksheet!AC19","v":5},{"$f":"Worksheet!AD19","v":2.5},null,{"$f":"Worksheet!AG19","v":0}]
[{"$f":"Worksheet!K20","v":"GBH"},{"$f":"Worksheet!L20","v":9},{"$f":"Worksheet!M20","v":7},{"$f":"Worksheet!N20","v":8},null,{"$f":"Worksheet!P20","v":0},{"$f":"Worksheet!Q20","v":5},{"$f":"Worksheet!R20","v":5},null,{"$f":"Worksheet!T20","v":9},{"$f":"Worksheet!U20","v":2},{"$f":"Worksheet!V20","v":3},null,{"$f":"Worksheet!X20","v":0},{"$f":"Worksheet!Y20","v":0},{"$f":"Worksheet!Z20","v":0},"GBH",{"$f":"Worksheet!W20","v":3},{"$f":"Worksheet!AB20","v":7},{"$f":"Worksheet!AC20","v":2},{"$f":"Worksheet!AD20","v":2},null,{"$f":"Worksheet!AG20","v":0}]
[{"$f":"Worksheet!K21","v":"WRA"},{"$f":"Worksheet!L21","v":50},{"$f":"Worksheet!M21","v":5},{"$f":"Worksheet!N21","v":6},null,{"$f":"Worksheet!P21","v":25},{"$f":"Worksheet!Q21","v":5},{"$f":"Worksheet!R21","v":6},null,{"$f":"Worksheet!T21","v":0},{"$f":"Worksheet!U21","v":0},{"$f":"Worksheet!V21","v":0},null,{"$f":"Worksheet!X21","v":0},{"$f":"Worksheet!Y21","v":0},{"$f":"Worksheet!Z21","v":0},"WRA",{"$f":"Worksheet!W21","v":0},{"$f":"Worksheet!AB21","v":0},{"$f":"Worksheet!AC21","v":0},{"$f":"Worksheet!AD21","v":0},null,{"$f":"Worksheet!AG21","v":0}]
[{"$f":"Worksheet!K22","v":"LDP"},{"$f":"Worksheet!L22","v":30},{"$f":"Worksheet!M22","v":8},{"$f":"Worksheet!N22","v":9},null,{"$f":"Worksheet!P22","v":8},{"$f":"Worksheet!Q22","v":6},{"$f":"Worksheet!R22","v":6},null,{"$f":"Worksheet!T22","v":14},{"$f":"Worksheet!U22","v":2},{"$f":"Worksheet!V22","v":3},null,{"$f":"Worksheet!X22","v":0},{"$f":"Worksheet!Y22","v":0},{"$f":"Worksheet!Z22","v":0},"LDP",{"$f":"Worksheet!W22","v":4},{"$f":"Worksheet!AB22","v":12},{"$f":"Worksheet!AC22","v":3},{"$f":"Worksheet!AD22","v":3},null,{"$f":"Worksheet!AG22","v":0}]
[{"$f":"Worksheet!K23","v":"RJR"},{"$f":"Worksheet!L23","v":29},{"$f":"Worksheet!M23","v":11},{"$f":"Worksheet!N23","v":8},null,{"$f":"Worksheet!P23","v":8},{"$f":"Worksheet!Q23","v":5},{"$f":"Worksheet!R23","v":5},null,{"$f":"Worksheet!T23","v":13},{"$f":"Worksheet!U23","v":6},{"$f":"Worksheet!V23","v":3},null,{"$f":"Worksheet!X23","v":0},{"$f":"Worksheet!Y23","v":0},{"$f":"Worksheet!Z23","v":0},"RJR",{"$f":"Worksheet!W23","v":3},{"$f":"Worksheet!AB23","v":10},{"$f":"Worksheet!AC23","v":3},{"$f":"Worksheet!AD23","v":3},null,{"$f":"Worksheet!AG23","v":0}]
[{"$f":"Worksheet!K24","v":"AJR"},{"$f":"Worksheet!L24","v":46},{"$f":"Worksheet!M24","v":12},{"$f":"Worksheet!N24","v":7},null,{"$f":"Worksheet!P24","v":17},{"$f":"Worksheet!Q24","v":8},{"$f":"Worksheet!R24","v":5},null,{"$f":"Worksheet!T24","v":12},{"$f":"Worksheet!U24","v":4},{"$f":"Worksheet!V24","v":2},null,{"$f":"Worksheet!X24","v":0},{"$f":"Worksheet!Y24","v":0},{"$f":"Worksheet!Z24","v":0},"AJR",{"$f":"Worksheet!W24","v":3},{"$f":"Worksheet!AB24","v":10},{"$f":"Worksheet!AC24","v":4},{"$f":"Worksheet!AD24","v":3},null,{"$f":"Worksheet!AG24","v":0}]
[{"$f":"Worksheet!K25","v":"DK"},{"$f":"Worksheet!L25","v":0},{"$f":"Worksheet!M25","v":0},{"$f":"Worksheet!N25","v":4},null,{"$f":"Worksheet!P25","v":0},{"$f":"Worksheet!Q25","v":0},{"$f":"Worksheet!R25","v":4},null,{"$f":"Worksheet!T25","v":0},{"$f":"Worksheet!U25","v":0},{"$f":"Worksheet!V25","v":0},null,{"$f":"Worksheet!X25","v":0},{"$f":"Worksheet!Y25","v":0},{"$f":"Worksheet!Z25","v":0},"DK",{"$f":"Worksheet!W25","v":0},{"$f":"Worksheet!AB25","v":0},{"$f":"Worksheet!AC25","v":0},{"$f":"Worksheet!AD25","v":0},null,{"$f":"Worksheet!AG25","v":0}]
[{"$f":"Worksheet!K26","v":"WS"},{"$f":"Worksheet!L26","v":0},{"$f":"Worksheet!M26","v":6},{"$f":"Worksheet!N26","v":6},null,{"$f":"Worksheet!P26","v":0},{"$f":"Worksheet!Q26","v":6},{"$f":"Worksheet!R26","v":6},null,{"$f":"Worksheet!T26","v":0},{"$f":"Worksheet!U26","v":0},{"$f":"Worksheet!V26","v":0},null,{"$f":"Worksheet!X26","v":0},{"$f":"Worksheet!Y26","v":0},{"$f":"Worksheet!Z26","v":0},"WS",{"$f":"Worksheet!W26","v":0},{"$f":"Worksheet!AB26","v":0},{"$f":"Worksheet!AC26","v":0},{"$f":"Worksheet!AD26","v":0},null,{"$f":"Worksheet!AG26","v":0}]
[{"$f":"Worksheet!K27","v":"MAK"},{"$f":"Worksheet!L27","v":45},{"$f":"Worksheet!M27","v":6},{"$f":"Worksheet!N27","v":5},null,{"$f":"Worksheet!P27","v":22.5},{"$f":"Worksheet!Q27","v":6},{"$f":"Worksheet!R27","v":5},null,{"$f":"Worksheet!T27","v":0},{"$f":"Worksheet!U27","v":0},{"$f":"Worksheet!V27","v":0},null,{"$f":"Worksheet!X27","v":0},{"$f":"Worksheet!Y27","v":0},{"$f":"Worksheet!Z27","v":0},"MAK",{"$f":"Worksheet!W27","v":0},{"$f":"Worksheet!AB27","v":0},{"$f":"Worksheet!AC27","v":0},{"$f":"Worksheet!AD27","v":0},null,{"$f":"Worksheet!AG27","v":0}]
[{"$f":"Worksheet!K28","v":"LOC"},{"$f":"Worksheet!L28","v":0},{"$f":"Worksheet!M28","v":0},{"$f":"Worksheet!N28","v":0},null,{"$f":"Worksheet!P28","v":0},{"$f":"Worksheet!Q28","v":0},{"$f":"Worksheet!R28","v":0},null,{"$f":"Worksheet!T28","v":0},{"$f":"Worksheet!U28","v":0},{"$f":"Worksheet!V28","v":0},null,{"$f":"Worksheet!X28","v":0},{"$f":"Worksheet!Y28","v":0},{"$f":"Worksheet!Z28","v":0},"LOC",{"$f":"Worksheet!W28","v":0},{"$f":"Worksheet!AB28","v":0},{"$f":"Worksheet!AC28","v":0},{"$f":"Worksheet!AD28","v":0},null,{"$f":"Worksheet!AG28","v":0}]
[{"$f":"Worksheet!K29","v":"BHS"},{"$f":"Worksheet!L29","v":0},{"$f":"Worksheet!M29","v":0},{"$f":"Worksheet!N29","v":0},null,{"$f":"Worksheet!P29","v":0},{"$f":"Worksheet!Q29","v":0},{"$f":"Worksheet!R29","v":0},null,{"$f":"Worksheet!T29","v":0},{"$f":"Worksheet!U29","v":0},{"$f":"Worksheet!V29","v":0},null,{"$f":"Worksheet!X29","v":0},{"$f":"Worksheet!Y29","v":0},{"$f":"Worksheet!Z29","v":0},"BHS",{"$f":"Worksheet!W29","v":0},{"$f":"Worksheet!AB29","v":0},{"$f":"Worksheet!AC29","v":0},{"$f":"Worksheet!AD29","v":0},null,{"$f":"Worksheet!AG29","v":0}]
["OTHER",{"$f":"Worksheet!L35","v":169},{"$f":"Worksheet!M35","v":41},{"$f":"Worksheet!N35","v":41.5},null,{"$f":"Worksheet!P35","v":103.5},{"$f":"Worksheet!Q35","v":0},{"$f":"Worksheet!R35","v":0},null,{"$f":"Worksheet!T35","v":0},{"$f":"Worksheet!U35","v":0},{"$f":"Worksheet!V35","v":0},null,{"$f":"Worksheet!X35","v":168},{"$f":"Worksheet!Y35","v":41},{"$f":"Worksheet!Z35","v":82},{"$f":"A32","v":"OTHER"},null,{"$f":"Worksheet!AB35","v":-1},{"$f":"Worksheet!AC35","v":0},{"$f":"Worksheet!AD35","v":2.5},null,{"$f":"Worksheet!AG35","v":0}]
[]
[]
[]
["Shifts worked on public holidays"]
["This includes official public holidays and the holiday day where it falls on a weekend"]
["Only change red squares",{"$nulls":8},"TOTALS(days)"]
["PUBLIC HOLIDAYS",{"$nulls":3},"POINTS","ICU","AGB","BHS",null,{"$f":"Worksheet!K5","v":"PJC"},{"$f":"COUNTIF(PubHolWorkers,J39)","v":3}]
["Australia Day",null,"2019-01-28",null,null,"MAK","GBH",null,null,{"$f":"Worksheet!K6","v":"RAC"},0]
["Labour Day-Sat",null,{"$f":"C43-2","v":"2018-03-10"},null,null,"LDP","DJM",null,null,{"$f":"Worksheet!K8","v":"JGE"},2]
["Labour Day-Sun",null,{"$f":"C43-1","v":"2018-03-11"},null,null,"LDP","DJM","JGE",null,{"$f":"Worksheet!K9","v":"SPF"},3]
["Labour Day",null,"2018-03-12",null,null,"WRA","RJR",null,null,{"$f":"Worksheet!K10","v":"GAH"},0]
["Good Friday",null,"2018-03-30",null,null,"WRA","PRS",null,null,{"$f":"Worksheet!K11","v":"DJM"},3]
["Easter Saturday",null,{"$f":"$C$44+1","v":"2018-03-31"},null,null,"WRA","PRS",null,null,{"$f":"Worksheet!K12","v":"CJM"},2]
["Easter Sunday",null,{"$f":"$C$44+2","v":"2018-04-01"},null,null,"WRA","CJM",null,null,{"$f":"Worksheet!K13","v":"MFS"},2]
["Easter Monday",null,{"$f":"$C$44+3","v":"2018-04-02"},null,null,"MAK","CJM","PRS",null,{"$f":"Worksheet!K14","v":"PRS"},4]
["ANZAC Day",null,"2018-04-25",null,null,"WRA","SPF",null,null,{"$f":"Worksheet!K15","v":"HLT"},0]
["Queen's Birthday-Sat",null,{"$f":"$C$51-2","v":"2018-06-09"},null,null,"MAK","SPF",null,null,{"$f":"Worksheet!K16","v":"DRP"},0]
["Queen's Birthday-Sun",null,{"$f":"$C$51-1","v":"2018-06-10"},null,null,"MAK","SPF",null,null,{"$f":"Worksheet!K17","v":"MBW"},0]
["Queen's Birthday",null,"2018-06-11",null,null,"RCG","DJM",null,null,{"$f":"Worksheet!K18","v":"RCG"},2]
["AFL Final",null,"2018-09-28",null,null,"GBH","AJR","PJC",null,{"$f":"Worksheet!K19","v":"DBC"},2]
["AFL Final-Sat",null,{"$f":"C52+1","v":"2018-09-29"},null,null,"GBH","PJC",null,null,{"$f":"Worksheet!K20","v":"GBH"},4]
["AFL Final-Sun",null,{"$f":"C52+2","v":"2018-09-30"},null,null,"GBH","PJC",null,null,{"$f":"Worksheet!K21","v":"WRA"},7]
["Ballarat Show Day",null,"2018-11-09",null,null,"RCG","MFS",null,null,{"$f":"Worksheet!K22","v":"LDP"},3]
["Ballarat Show Day",null,{"$f":"C55+1","v":"2018-11-10"},null,null,"WRA","DBC","PRS",null,{"$f":"Worksheet!K23","v":"RJR"},2]
["Ballarat Show Day",null,{"$f":"C55+2","v":"2018-11-11"},null,null,"WRA","DBC",null,null,{"$f":"Worksheet!K24","v":"AJR"},2]
["Christmas Day Hol",null,"2018-12-25",null,null,"RJR","JGE",null,null,{"$f":"Worksheet!K25","v":"DK"},0]
["Christmas Day-Sat",{"$nulls":8},{"$f":"Worksheet!K26","v":"WS"},0]
["Christmas Day-Sun",{"$nulls":8},{"$f":"Worksheet!K27","v":"MAK"},5]
["Boxing Day",null,"2018-12-26",null,null,"LDP","AJR","REC",null,{"$f":"Worksheet!K28","v":"LOC"},0]
["Bonus Day Holiday",{"$nulls":8},{"$f":"Worksheet!K29","v":"BHS"},0]
["New Years Day Hol",null,"2019-01-01",null,null,"MAK","REC","MFS",null,{"$f":"Worksheet!K30","v":"##"},0]
["New Years Day-Sat",{"$nulls":8},{"$f":"Worksheet!K31","v":"##"},0]
["New Years Day-Sun",{"$nulls":8},{"$f":"Worksheet!K32","v":"##"},0]

{"sheet":"Worksheet","index":2,"n_rows":407,"n_cols":34,"rows_kept":407,"hidden":true,"merged":[[0,11,0,12],[2,11,2,13],[2,15,2,17],[2,19,2,21],[2,23,2,25],[2,27,2,30]]}
["This worksheet remains hidden and transposes roster into type of call groups",{"$nulls":10},"CURRENT YEAR",null,2018]
["ICU"]
["week","mon","tue","wed","thu","fri","sat","sun",{"$nulls":3},"ALL NIGHTS",{"$nulls":3},"ICU",{"$nulls":3},"AGB",null,null,"AGB","BHS",{"$nulls":3},"BACKUP",{"$nulls":4},"SATURDAY"]
[-2,{"$f":"IF(CurrentRoster!B10<FirstRosterDay,\"\",CurrentRoster!B11)","v":""},{"$f":"IF(CurrentRoster!C10<FirstRosterDay,\"\",CurrentRoster!C11)","v":""},{"$f":"IF(CurrentRoster!D10<FirstRosterDay,\"\",CurrentRoster!D11)","v":""},{"$f":"IF(CurrentRoster!E10<FirstRosterDay,\"\",CurrentRoster!E11)","v":""},{"$f":"IF(CurrentRoster!F10<FirstRosterDay,\"\",CurrentRoster!F11)","v":""},{"$f":"IF(CurrentRoster!G10<FirstRosterDay,\"\",CurrentRoster!G11)","v":""},{"$f":"IF(CurrentRoster!H10<FirstRosterDay,\"\",CurrentRoster!H11)","v":""},{"$nulls":3},"Mon-Thu","Fri","Sat+Sun",null,"Mon-Thu","Fri","Sat+Sun",null,"Mon-Thu","Fri","Sat+Sun","Thur","Mon-Thu","Fri","Sat OR Sun",null,"Mon-Thu","Fri","Sat+Sun","TOTAL"]
[-1,{"$f":"IF(CurrentRoster!B16<FirstRosterDay,\"\",CurrentRoster!B17)","v":""},{"$f":"IF(CurrentRoster!C16<FirstRosterDay,\"\",CurrentRoster!C17)","v":""},{"$f":"IF(CurrentRoster!D16<FirstRosterDay,\"\",CurrentRoster!D17)","v":""},{"$f":"IF(CurrentRoster!E16<FirstRosterDay,\"\",CurrentRoster!E17)","v":""},{"$f":"IF(CurrentRoster!F16<FirstRosterDay,\"\",CurrentRoster!F17)","v":""},{"$f":"IF(CurrentRoster!G16<FirstRosterDay,\"\",CurrentRoster!G17)","v":""},{"$f":"IF(CurrentRoster!H16<FirstRosterDay,\"\",CurrentRoster!H17)","v":""},null,1,"PJC",{"$f":"COUNTIF($B$4:$E$170,$K5)","v":16},{"$f":"COUNTIF($F$4:$F$170,$K5)","v":5},{"$f":"COUNTIF($G$4:$H$170,$K5)/2","v":5},null,{"$f":"COUNTIF(ICU_MonThu,$K5)/2","v":0},{"$f":"COUNTIF(ICU_Fri,$K5)","v":0},{"$f":"COUNTIF(ICU_SatSun,$K5)/2","v":0},null,{"$f":"COUNTIF(AGB_MonThu,$K5)","v":11},{"$f":"COUNTIF(AGB_Fri,$K5)","v":4},{"$f":"COUNTIF(AGB_SaSu,$K5)/2","v":4},{"$f":"COUNTIF(AGB_Th,$K5)","v":3},{"$f":"COUNTIF(BHS_MoTh,$K5)","v":5},{"$f":"COUNTIF(BHS_Fr,$K5)","v":1},{"$f":"COUNTIF(BHS_SaSu,$K5)","v":3},{"$f":"K5","v":"PJC"},{"$f":"COUNTIF(BackupMoTh,$K5)","v":10},{"$f":"COUNTIF(BackupFr,$K5)","v":4},{"$f":"COUNTIF(BackupSaSu,$K5)/2","v":4},{"$f":"2*AD5+AC5+AB5","v":22},null,{"$f":"COUNTIF($G$356:$G$407,$K5)","v":0},{"$f":"K5","v":"PJC"}]
[0,{"$f":"IF(CurrentRoster!B22<FirstRosterDay,\"\",CurrentRoster!B23)","v":""},{"$f":"IF(CurrentRoster!C22<FirstRosterDay,\"\",CurrentRoster!C23)","v":""},{"$f":"IF(CurrentRoster!D22<FirstRosterDay,\"\",CurrentRoster!D23)","v":""},{"$f":"IF(CurrentRoster!E22<FirstRosterDay,\"\",CurrentRoster!E23)","v":"WRA"},{"$f":"IF(CurrentRoster!F22<FirstRosterDay,\"\",CurrentRoster!F23)","v":"AJR"},{"$f":"IF(CurrentRoster!G22<FirstRosterDay,\"\",CurrentRoster!G23)","v":"DK"},{"$f":"IF(CurrentRoster!H22<FirstRosterDay,\"\",CurrentRoster!H23)","v":"DK"},null,1,"RAC",17,4,4.5,null,0,0,0,null,13,3,3,3,4,1,3,{"$f":"K6","v":"RAC"},12,4,4,{"$f":"2*AD6+AC6+AB6","v":24},null,0,{"$f":"K6","v":"RAC"}]
[1,{"$f":"IF(CurrentRoster!B28<FirstRosterDay,\"\",CurrentRoster!B29)","v":"RCG"},{"$f":"IF(CurrentRoster!C28<FirstRosterDay,\"\",CurrentRoster!C29)","v":"RCG"},{"$f":"IF(CurrentRoster!D28<FirstRosterDay,\"\",CurrentRoster!D29)","v":"LDP"},{"$f":"IF(CurrentRoster!E28<FirstRosterDay,\"\",CurrentRoster!E29)","v":"LDP"},{"$f":"IF(CurrentRoster!F28<FirstRosterDay,\"\",CurrentRoster!F29)","v":"DBC"},{"$f":"IF(CurrentRoster!G28<FirstRosterDay,\"\",CurrentRoster!G29)","v":"DBC"},{"$f":"IF(CurrentRoster!H28<FirstRosterDay,\"\",CurrentRoster!H29)","v":"DBC"},null,null,"REC",12,3,3.5,null,0,0,0,null,10,3,3,4,2,0,1,{"$f":"K7","v":"REC"},10,2,2,{"$f":"2*AD7+AC7+AB7","v":16},null,0,{"$f":"K7","v":"REC"}]
[2,{"$f":"INDIRECT(\"CurrentRoster!B\"&(6*$A8+23))","v":"MAK"},{"$f":"INDIRECT(\"CurrentRoster!C\"&(6*$A8+23))","v":"MAK"},{"$f":"INDIRECT(\"CurrentRoster!D\"&(6*$A8+23))","v":"AJR"},{"$f":"INDIRECT(\"CurrentRoster!E\"&(6*$A8+23))","v":"AJR"},{"$f":"INDIRECT(\"CurrentRoster!F\"&(6*$A8+23))","v":"MAK"},{"$f":"INDIRECT(\"CurrentRoster!G\"&(6*$A8+23))","v":"MAK"},{"$f":"INDIRECT(\"CurrentRoster!H\"&(6*$A8+23))","v":"MAK"},null,1,"JGE",19,5,4.5,null,0,0,0,null,14,3,3,5,5,2,3,{"$f":"K8","v":"JGE"},13,3,2.5,{"$f":"2*AD8+AC8+AB8","v":21},null,0,{"$f":"K8","v":"JGE"}]
[3,{"$f":"INDIRECT(\"CurrentRoster!B\"&(6*$A9+23))","v":"AJR"},{"$f":"INDIRECT(\"CurrentRoster!C\"&(6*$A9+23))","v":"AJR"},{"$f":"INDIRECT(\"CurrentRoster!D\"&(6*$A9+23))","v":"WRA"},{"$f":"INDIRECT(\"CurrentRoster!E\"&(6*$A9+23))","v":"WRA"},{"$f":"INDIRECT(\"CurrentRoster!F\"&(6*$A9+23))","v":"DBC"},{"$f":"INDIRECT(\"CurrentRoster!G\"&(6*$A9+23))","v":"DBC"},{"$f":"INDIRECT(\"CurrentRoster!H\"&(6*$A9+23))","v":"DBC"},null,1,"SPF",13,3,4,null,0,0,0,null,13,3,4,4,0,0,0,"SPF",13,2,4.5,24,null,0,"SPF"]
[4,"MAK","MAK","WRA","WRA","WS","WS","WS",null,1,"GAH",13,3,3,null,0,0,0,null,13,3,3,0,0,0,0,"GAH",14,5,4,27,null,0,"GAH"]
[5,"RCG","RCG","AJR","AJR","LDP","LDP","LDP",null,1,"DJM",20,5,4,null,0,0,0,null,17,3,3,3,4,2,2,"DJM",16,1,3,23,null,0,"DJM"]
[6,"WRA","WRA","DBC","DBC","AJR","AJR","AJR",null,1,"CJM",17,5,4.5,null,0,0,0,null,14,3,3.5,3,4,2,2,"CJM",10,4,4,22,null,0,"CJM"]
[7,"MAK","MAK","AJR","AJR","RJR","RJR","RJR",null,1,"MFS",21,5,4,null,0,0,0,null,14,3,3,4,7,2,2,"MFS",10,2,4,20,null,0,"MFS"]
[8,"AJR","AJR","LDP","LDP","WRA","WRA","WRA",null,1,"PRS",21,3,6,null,0,0,0,null,15,3,4.5,6,6,0,3,"PRS",14,3,3,23,null,0,"PRS"]
[9,"MAK","MAK","RJR","RJR","GBH","GBH","GBH",null,1,"HLT",15,5,5.5,null,0,0,0,null,12,4,4,2,3,1,3,"HLT",12,5,3,23,null,0,"HLT"]
[10,"RJR","RJR","WRA","WRA","GBH","GBH","GBH",null,1,"DRP",0,0,0,null,0,0,0,null,0,0,0,0,0,0,0,"DRP",11,0,0,11,null,0,"DRP"]
[11,"LDP","LDP","AJR","AJR","MAK","MAK","MAK",null,2,"MBW",0,0,0,null,0,0,0,null,0,0,0,0,0,0,0,"MBW",12,0,0,12,null,0,"MBW"]
[12,"AJR","AJR","WRA","WRA","AJR","DK","DK",null,2,"RCG",34,6,5,null,17,6,5,null,0,0,0,0,0,0,0,"RCG",0,0,0,0,null,0,"RCG"]
[13,"MAK","MAK","AJR","AJR","WRA","WRA","WRA",null,2,"DBC",28,8,8,null,7,5,5,null,14,3,3,3,0,0,0,"DBC",13,5,2.5,23,null,0,"DBC"]
[14,"MAK","MAK","WRA","WRA","WS","WS","WS",null,2,"GBH",9,7,8,null,0,5,5,null,9,2,3,3,0,0,0,"GBH",7,2,2,13,null,0,"GBH"]
[15,"RCG","RCG","AJR","AJR","WRA","RCG","RCG",null,2,"WRA",50,5,6,null,25,5,6,null,0,0,0,0,0,0,0,"WRA",0,0,0,0,null,0,"WRA"]
[16,"WRA","WRA","DBC","DBC","RJR","RJR","RJR",null,2,"LDP",30,8,9,null,8,6,6,null,14,2,3,4,0,0,0,"LDP",12,3,3,21,null,0,"LDP"]
[17,"RCG","RCG","WRA","WRA","DBC","DBC","DBC",null,3,"RJR",29,11,8,null,8,5,5,null,13,6,3,3,0,0,0,"RJR",10,3,3,19,null,0,"RJR"]
[18,"MAK","MAK","WRA","WRA","MAK","MAK","MAK",null,3,"AJR",46,12,7,null,17,8,5,null,12,4,2,3,0,0,0,"AJR",10,4,3,20,null,0,"AJR"]
[19,"RCG","RCG","AJR","AJR","RCG","DK","DK",null,3,"DK",0,0,4,null,0,0,4,null,0,0,0,0,0,0,0,"DK",0,0,0,0,null,0,"DK"]
[20,"MAK","MAK","WRA","WRA","LDP","LDP","LDP",null,3,"WS",0,6,6,null,0,6,6,null,0,0,0,0,0,0,0,"WS",0,0,0,0,null,0,"WS"]
[21,"RCG","RCG","DBC","DBC","MAK","RCG","RCG",null,3,"MAK",45,6,5,null,22.5,6,5,null,0,0,0,0,0,0,0,"MAK",0,0,0,0,null,0,"MAK"]
[22,"MAK","MAK","DBC","DBC","RCG","MAK","MAK",null,3,"LOC",0,0,0,null,0,0,0,null,0,0,0,0,0,0,0,"LOC",0,0,0,0,null,0,"LOC"]
[23,"RCG","RCG","MAK","MAK","GBH","GBH","GBH",null,3,"BHS",0,0,0,null,0,0,0,null,0,0,0,0,0,0,0,"BHS",0,0,0,0,null,0,"BHS"]
[24,"MAK","MAK","AJR","AJR","WS","WS","WS",null,null,"##",0,0,0,null,0,0,0,null,0,0,0,0,0,0,0,"##",0,0,0,0,null,0,"##"]
[25,"RCG","RCG","AJR","AJR","WRA","WRA","WRA",null,null,"##",0,0,0,null,0,0,0,null,0,0,0,0,0,0,0,"##",0,0,0,0,null,0,"##"]
[26,"MAK","MAK","WRA","WRA","AJR","AJR","AJR",null,null,"##",0,0,0,null,0,0,0,null,0,0,0,0,0,0,0,"##",0,0,0,0,null,0,"##"]
[27,"RCG","RCG","LDP","LDP","AJR","DK","DK",null,null,"##",0,0,0,null,0,0,0,null,0,0,0,0,0,0,0,"##",0,0,0,0,null,0,"##"]
[28,"RJR","RJR","WRA","WRA","LDP","LDP","LDP",null,null,"##",0,0,0,null,0,0,0,null,0,0,0,0,0,0,0,"##",0,0,0,0,null,0,"##"]
[29,"MAK","MAK","AJR","AJR","LDP","RCG","RCG",null,null,"OTHER",{"$f":"3*4*52-SUM(L5:L34)","v":169},{"$f":"3*52-SUM(M5:M34)","v":41},{"$f":"3*52-SUM(N5:N34)","v":41.5},null,{"$f":"4*52-SUM(P5:P34)","v":103.5},{"$f":"52-SUM(Q5:Q34)","v":0},{"$f":"52-SUM(R5:R34)","v":0},null,{"$f":"4*52-SUM(T5:T34)","v":0},{"$f":"52-SUM(U5:U34)","v":0},{"$f":"52-SUM(V5:V34)","v":0},{"$f":"52-SUM(W5:W34)","v":-1},{"$f":"4*52-SUM(X5:X34)","v":168},{"$f":"52-SUM(Y5:Y34)","v":41},{"$f":"104-SUM(Z5:Z34)","v":82},{"$f":"K35","v":"OTHER"},{"$f":"4*52-SUM(AB5:AB34)","v":-1},{"$f":"52-SUM(AC5:AC34)","v":0},{"$f":"54-SUM(AD5:AD34)","v":2.5},{"$f":"SUM(AE5:AE34)","v":364},null,{"$f":"SUM(AG5:AG34)","v":0}]
[30,"LDP","LDP","WRA","WRA","WS","WS","WS"]
[31,"RCG","RCG","AJR","AJR","DBC","DBC","DBC"]
[32,"MAK","MAK","WRA","WRA","AJR","AJR","AJR",{"$nulls":7},"NOTE; Special resolution 2005. ",null,"18 or more sessions/4w",null,null,"Full oncall responsibility",{"$nulls":4},"drp"]
[33,"DBC","DBC","WRA","WRA","WS","WS","WS",{"$nulls":3},"ANAESTHETISTS",null,"3-day w/e",{"$nulls":3},"9-17 sessions/4w",null,null,"75% oncall responsibility",{"$nulls":4},"mbw"]
[34,"MAK","MAK","RJR","RJR","GBH","GBH","GBH",{"$nulls":3},"Christie","DBC",true,{"$nulls":11},"SPF"]
[35,"DBC","DBC","WRA","WRA","AJR","AJR","AJR",{"$nulls":3},"Commons","PJC",false,{"$nulls":11},"AJR"]
[36,"MAK","MAK","AJR","AJR","RCG","LDP","LDP",{"$nulls":3},"Connell","RAC",false,{"$nulls":11},"LDP"]
[37,"RCG","RCG","MAK","MAK","MAK","RCG","RCG",{"$nulls":3},"Cowell","REC",false,{"$nulls":11},"DJM"]
[38,"MAK","MAK","WRA","WRA","AJR","AJR","AJR",{"$nulls":3},"Evans","JGE",false,{"$nulls":11},"CJM"]
[39,"RCG","RCG","AJR","AJR","DBC","DBC","DBC",{"$nulls":3},"Frost","SPF",false,{"$nulls":11},"RAC"]
[40,"WRA","MAK","LDP","LDP","RCG","WRA","WRA",{"$nulls":3},"Gazzard","RCG",false,{"$nulls":11},"DBC"]
[41,"RCG","RCG","WRA","WRA","GBH","GBH","GBH",{"$nulls":3},"Henderson","GBH",true,{"$nulls":11},"GBH"]
[42,"RJR","RJR","DBC","DBC","WS","WS","WS",{"$nulls":3},"Hughes","GAH",false,{"$nulls":11},"GAH"]
[43,"RCG","RCG","WRA","WRA","RJR","RJR","RJR",{"$nulls":3},"McIntyre","DJM",true,{"$nulls":11},"RJR"]
[44,"WRA","WRA","RJR","RJR","LDP","LDP","LDP",{"$nulls":3},"Mitchell","CJM",true,{"$nulls":11},"JGE"]
[45,"RCG","RCG","WRA","WRA","LDP","RCG","RCG",{"$nulls":3},"Paxton","LDP",false,{"$nulls":11},"MFS"]
[46,"MAK","MAK","RJR","RJR","RCG","LDP","LDP",{"$nulls":3},"Phillips","DRP",false,{"$nulls":11},"PRS"]
[47,"RJR","RJR","LDP","LDP","RJR","RJR","RJR",{"$nulls":3},"Ray","RJR",false,{"$nulls":11},"HLT"]
[48,"MAK","MAK","AJR","AJR","RCG","WRA","WRA",{"$nulls":3},"Richardson","AJR",true]
[49,"RCG","RCG","WRA","WRA","RJR","RJR","RJR",{"$nulls":3},"Shaw","MFS",false]
[50,"MAK","MAK","WRA","WRA","MAK","MAK","MAK",{"$nulls":3},"Shea","PRS",true]
[51,"RCG","RCG","LDP","LDP","WRA","WRA","WRA",{"$nulls":3},"Tan","HLT",false]
[52,{"$f":"IF(CurrentRoster!B334>(FirstRosterDay+364),\"\",CurrentRoster!B335)","v":"MAK"},{"$f":"IF(CurrentRoster!C334>(FirstRosterDay+364),\"\",CurrentRoster!C335)","v":"MAK"},{"$f":"IF(CurrentRoster!D334>(FirstRosterDay+364),\"\",CurrentRoster!D335)","v":"WRA"},{"$f":"IF(CurrentRoster!E334>(FirstRosterDay+364),\"\",CurrentRoster!E335)","v":"WRA"},{"$f":"IF(CurrentRoster!F334>(FirstRosterDay+364),\"\",CurrentRoster!F335)","v":""},{"$f":"IF(CurrentRoster!G334>(FirstRosterDay+364),\"\",CurrentRoster!G335)","v":""},{"$f":"IF(CurrentRoster!H334>(FirstRosterDay+364),\"\",CurrentRoster!H335)","v":""},{"$nulls":3},"Whitehead","MBW",false]
[{"$nulls":11},"BHS","BHS",false]
[{"$nulls":11},"Ainslie","WRA",{"$nulls":12},1]
["AGB",{"$nulls":10},"Sylvester","WS",{"$nulls":11},35,2,{"$f":"CurrentRoster!B35","v":"MAK"},"`"]
[-2,{"$f":"IF(CurrentRoster!B10<FirstRosterDay,\"\",CurrentRoster!B12)","v":""},{"$f":"IF(CurrentRoster!C10<FirstRosterDay,\"\",CurrentRoster!C12)","v":""},{"$f":"IF(CurrentRoster!D10<FirstRosterDay,\"\",CurrentRoster!D12)","v":""},{"$f":"IF(CurrentRoster!E10<FirstRosterDay,\"\",CurrentRoster!E12)","v":""},{"$f":"IF(CurrentRoster!F10<FirstRosterDay,\"\",CurrentRoster!F12)","v":""},{"$f":"IF(CurrentRoster!G10<FirstRosterDay,\"\",CurrentRoster!G12)","v":""},{"$f":"IF(CurrentRoster!H10<FirstRosterDay,\"\",CurrentRoster!H12)","v":""},{"$nulls":3},"Dharshi","DK",{"$nulls":6},"CurrentYear",{"$f":"CurrentYear","v":2018},{"$nulls":3},41,3,{"$f":"CurrentRoster!B41","v":"AJR"}]
[-1,{"$f":"IF(CurrentRoster!B16<FirstRosterDay,\"\",CurrentRoster!B18)","v":""},{"$f":"IF(CurrentRoster!C16<FirstRosterDay,\"\",CurrentRoster!C18)","v":""},{"$f":"IF(CurrentRoster!D16<FirstRosterDay,\"\",CurrentRoster!D18)","v":""},{"$f":"IF(CurrentRoster!E16<FirstRosterDay,\"\",CurrentRoster!E18)","v":""},{"$f":"IF(CurrentRoster!F16<FirstRosterDay,\"\",CurrentRoster!F18)","v":""},{"$f":"IF(CurrentRoster!G16<FirstRosterDay,\"\",CurrentRoster!G18)","v":""},{"$f":"IF(CurrentRoster!H16<FirstRosterDay,\"\",CurrentRoster!H18)","v":""},{"$nulls":3},"Kubicki","MAK",{"$nulls":6},"CalenderStart",{"$f":"\"1/2/\"&CurrentYear","v":"1/2/2018"},{"$nulls":3},47,4]
[0,{"$f":"IF(CurrentRoster!B22<FirstRosterDay,\"\",CurrentRoster!B24)","v":""},{"$f":"IF(CurrentRoster!C22<FirstRosterDay,\"\",CurrentRoster!C24)","v":""},{"$f":"IF(CurrentRoster!D22<FirstRosterDay,\"\",CurrentRoster!D24)","v":""},{"$f":"IF(CurrentRoster!E22<FirstRosterDay,\"\",CurrentRoster!E24)","v":"PRS"},{"$f":"IF(CurrentRoster!F22<FirstRosterDay,\"\",CurrentRoster!F24)","v":"GBH"},{"$f":"IF(CurrentRoster!G22<FirstRosterDay,\"\",CurrentRoster!G24)","v":"GBH"},{"$f":"IF(CurrentRoster!H22<FirstRosterDay,\"\",CurrentRoster!H24)","v":"GBH"},{"$nulls":12},{"$f":"DATEVALUE(U63)","v":43132},{"$nulls":4},5]
[1,{"$f":"INDIRECT(\"CurrentRoster!B\"&(6*$A65+24))","v":"DJM"},{"$f":"INDIRECT(\"CurrentRoster!C\"&(6*$A65+24))","v":"CJM"},{"$f":"INDIRECT(\"CurrentRoster!D\"&(6*$A65+24))","v":"DJM"},{"$f":"INDIRECT(\"CurrentRoster!E\"&(6*$A65+24))","v":"PRS"},{"$f":"INDIRECT(\"CurrentRoster!F\"&(6*$A65+24))","v":"AJR"},{"$f":"INDIRECT(\"CurrentRoster!G\"&(6*$A65+24))","v":"GAH"},{"$f":"INDIRECT(\"CurrentRoster!H\"&(6*$A65+24))","v":"GAH"},{"$nulls":11},"Weekday",{"$f":"WEEKDAY(U63,2)","v":4},{"$nulls":4},6]
[2,{"$f":"INDIRECT(\"CurrentRoster!B\"&(6*$A66+24))","v":"LDP"},{"$f":"INDIRECT(\"CurrentRoster!C\"&(6*$A66+24))","v":"PRS"},{"$f":"INDIRECT(\"CurrentRoster!D\"&(6*$A66+24))","v":"DBC"},{"$f":"INDIRECT(\"CurrentRoster!E\"&(6*$A66+24))","v":"HLT"},{"$f":"INDIRECT(\"CurrentRoster!F\"&(6*$A66+24))","v":"DJM"},{"$f":"INDIRECT(\"CurrentRoster!G\"&(6*$A66+24))","v":"RAC"},{"$f":"INDIRECT(\"CurrentRoster!H\"&(6*$A66+24))","v":"RAC"},{"$nulls":5},{"$f":"COUNTIF(ThreeD_WE,\"TRUE\")","v":0},{"$nulls":5},"WorksheetStart",{"$f":"U64-13-U65","v":"2018-01-15"},{"$nulls":4},7]
[3,{"$f":"INDIRECT(\"CurrentRoster!B\"&(6*$A67+24))","v":"HLT"},{"$f":"INDIRECT(\"CurrentRoster!C\"&(6*$A67+24))","v":"MFS"},{"$f":"INDIRECT(\"CurrentRoster!D\"&(6*$A67+24))","v":"JGE"},{"$f":"INDIRECT(\"CurrentRoster!E\"&(6*$A67+24))","v":"SPF"},{"$f":"INDIRECT(\"CurrentRoster!F\"&(6*$A67+24))","v":"REC"},{"$f":"INDIRECT(\"CurrentRoster!G\"&(6*$A67+24))","v":"JGE"},{"$f":"INDIRECT(\"CurrentRoster!H\"&(6*$A67+24))","v":"JGE"},{"$nulls":17},8]
[4,"AJR","RJR","JGE","RAC","HLT","REC","REC",{"$nulls":17},9]
[5,"LDP","PRS","CJM","SPF","GAH","DJM","DJM"]
[6,"RJR","AJR","DJM","MFS","PJC","PRS","PRS"]
[7,"REC","RAC","GAH","LDP","DBC","PJC","PJC"]
[8,"HLT","MFS","RJR","AJR","PRS","PRS","CJM"]
[9,"CJM","DBC","GAH","REC","PJC","MFS","MFS"]
[10,"HLT","DBC","RAC","CJM","PRS","PRS","PRS"]
[11,"DJM",0,"MFS","JGE","RJR","HLT","HLT"]
[12,"DJM","DBC","SPF","RAC","GAH","RJR","RJR"]
[13,"PJC","PRS","LDP","REC","JGE","DBC","DBC"]
[14,"AJR","JGE","DBC","LDP","RAC","GAH","GAH"]
[15,"CJM","PRS","PJC","DBC","REC","LDP","LDP"]
[16,"RJR","HLT","MFS","LDP","GBH","GBH","GBH"]
[17,"GAH","PJC","SPF","DJM","JGE","JGE","JGE"]
[18,"RAC","GAH","SPF","GBH","DBC","SPF","SPF"]
[19,"DJM","LDP","GBH","DJM","SPF","DJM","DJM"]
[20,"RJR","HLT","GAH","JGE","CJM","CJM","CJM"]
[21,"PJC","AJR","GAH","AJR","SPF","GAH","GAH"]
[22,"CJM","RAC","GAH","SPF","MFS","REC","REC"]
[23,"LDP","PRS","HLT","PJC","DJM","MFS","MFS"]
[24,"DJM","CJM","REC","RAC","SPF","SPF","SPF"]
[25,"MFS","PRS","PJC","RJR","HLT","HLT","HLT"]
[26,"DBC","AJR","REC","RJR","LDP","DBC","DBC"]
[27,"DJM","JGE","HLT","PJC","HLT","PRS","PRS"]
[28,"AJR","SPF","GAH","JGE","PJC","AJR","AJR"]
[29,"DJM","PRS","HLT","REC","RJR","RAC","RAC"]
[30,"DBC","MFS","CJM","PRS","JGE","LDP","LDP"]
[31,"AJR","LDP","DJM","MFS","RAC","JGE","JGE"]
[32,"RJR","JGE","GBH","HLT","CJM","CJM","CJM"]
[33,"RAC","SPF","MFS","CJM","AJR","AJR","AJR"]
[34,"RAC","JGE","REC","PRS","AJR","PJC","PJC"]
[35,"RAC","GBH","LDP","DBC","RAC","SPF","SPF"]
[36,"GAH","SPF","RAC","PRS","PJC","REC","REC"]
[37,"CJM","PRS","RAC","LDP","HLT","MFS","MFS"]
[38,"PJC","GAH","LDP","GBH","DBC","GBH","GBH"]
[39,"DJM","CJM","SPF","RJR","DJM","DJM","DJM"]
[40,"CJM","DBC","GBH","JGE","MFS","DBC","DBC"]
[41,"DJM","RJR","GAH","JGE","MFS","HLT","HLT"]
[42,"JGE","PJC","CJM","REC","RJR","RJR","RJR"]
[43,"MFS","SPF","DBC","GBH","REC","RAC","RAC"]
[44,"DJM","AJR","PJC","MFS","PRS","PRS","PRS"]
[45,"RJR","PRS","LDP","MFS","RJR","SPF","SPF"]
[46,"JGE","SPF","LDP","CJM","AJR","HLT","HLT"]
[47,"DJM","JGE","AJR","DBC","CJM","CJM","CJM"]
[48,"HLT","REC","RJR","PJC","GAH","LDP","LDP"]
[49,"REC","GAH","MFS","DJM","LDP","PJC","PJC"]
[50,"GBH","RJR","DBC","PRS","RJR","RJR","RJR"]
[51,"GAH","HLT","RAC","AJR","RJR","PJC","PJC"]
[52,{"$f":"IF(CurrentRoster!B334>(FirstRosterDay+365),\"\",CurrentRoster!B336)","v":"GBH"},{"$f":"IF(CurrentRoster!C334>(FirstRosterDay+365),\"\",CurrentRoster!C336)","v":"DBC"},{"$f":"IF(CurrentRoster!D334>(FirstRosterDay+365),\"\",CurrentRoster!D336)","v":"MFS"},{"$f":"IF(CurrentRoster!E334>(FirstRosterDay+365),\"\",CurrentRoster!E336)","v":"SPF"},{"$f":"IF(CurrentRoster!F334>(FirstRosterDay+364),\"\",CurrentRoster!F336)","v":""},{"$f":"IF(CurrentRoster!G334>(FirstRosterDay+365),\"\",CurrentRoster!G336)","v":""},{"$f":"IF(CurrentRoster!H334>(FirstRosterDay+365),\"\",CurrentRoster!H336)","v":""}]
[]
["BHS"]
[-2,{"$f":"IF(CurrentRoster!B10<FirstRosterDay,\"\",CurrentRoster!B13)","v":""},{"$f":"IF(CurrentRoster!C10<FirstRosterDay,\"\",CurrentRoster!C13)","v":""},{"$f":"IF(CurrentRoster!D10<FirstRosterDay,\"\",CurrentRoster!D13)","v":""},{"$f":"IF(CurrentRoster!E10<FirstRosterDay,\"\",CurrentRoster!E13)","v":""},{"$f":"IF(CurrentRoster!F10<FirstRosterDay,\"\",CurrentRoster!F13)","v":""},{"$f":"IF(CurrentRoster!G10<FirstRosterDay,\"\",CurrentRoster!G13)","v":""},{"$f":"IF(CurrentRoster!H10<FirstRosterDay,\"\",CurrentRoster!H13)","v":""}]
[-1,{"$f":"IF(CurrentRoster!B16<FirstRosterDay,\"\",CurrentRoster!B19)","v":""},{"$f":"IF(CurrentRoster!C16<FirstRosterDay,\"\",CurrentRoster!C19)","v":""},{"$f":"IF(CurrentRoster!D16<FirstRosterDay,\"\",CurrentRoster!D19)","v":""},{"$f":"IF(CurrentRoster!E16<FirstRosterDay,\"\",CurrentRoster!E19)","v":""},{"$f":"IF(CurrentRoster!F16<FirstRosterDay,\"\",CurrentRoster!F19)","v":""},{"$f":"IF(CurrentRoster!G16<FirstRosterDay,\"\",CurrentRoster!G19)","v":""},{"$f":"IF(CurrentRoster!H16<FirstRosterDay,\"\",CurrentRoster!H19)","v":""}]
[0,{"$f":"IF(CurrentRoster!B22<FirstRosterDay,\"\",CurrentRoster!B25)","v":""},{"$f":"IF(CurrentRoster!C22<FirstRosterDay,\"\",CurrentRoster!C25)","v":""},{"$f":"IF(CurrentRoster!D22<FirstRosterDay,\"\",CurrentRoster!D25)","v":""},{"$f":"IF(CurrentRoster!E22<FirstRosterDay,\"\",CurrentRoster!E25)","v":"MFS"},{"$f":"IF(CurrentRoster!F22<FirstRosterDay,\"\",CurrentRoster!F25)","v":0},{"$f":"IF(CurrentRoster!G22<FirstRosterDay,\"\",CurrentRoster!G25)","v":0},{"$f":"IF(CurrentRoster!H22<FirstRosterDay,\"\",CurrentRoster!H25)","v":0}]
[1,{"$f":"INDIRECT(\"CurrentRoster!B\"&(6*$A122+25))","v":0},{"$f":"INDIRECT(\"CurrentRoster!c\"&(6*$A122+25))","v":"PRS"},{"$f":"INDIRECT(\"CurrentRoster!D\"&(6*$A122+25))","v":0},{"$f":"INDIRECT(\"CurrentRoster!E\"&(6*$A122+25))","v":0},{"$f":"INDIRECT(\"CurrentRoster!F\"&(6*$A122+25))","v":"CJM"},{"$f":"INDIRECT(\"CurrentRoster!G\"&(6*$A122+25))","v":"HLT"},{"$f":"INDIRECT(\"CurrentRoster!H\"&(6*$A122+25))","v":0}]
[2,{"$f":"INDIRECT(\"CurrentRoster!B\"&(6*$A123+25))","v":0},{"$f":"INDIRECT(\"CurrentRoster!c\"&(6*$A123+25))","v":0},{"$f":"INDIRECT(\"CurrentRoster!D\"&(6*$A123+25))","v":0},{"$f":"INDIRECT(\"CurrentRoster!E\"&(6*$A123+25))","v":0},{"$f":"INDIRECT(\"CurrentRoster!F\"&(6*$A123+25))","v":0},{"$f":"INDIRECT(\"CurrentRoster!G\"&(6*$A123+25))","v":"MFS"},{"$f":"INDIRECT(\"CurrentRoster!H\"&(6*$A123+25))","v":"JGE"}]
[3,0,0,0,0,"RAC",0,0]
[4,0,0,0,"PJC",0,0,0]
[5,0,0,0,0,"DJM",0,"JGE"]
[6,0,0,0,0,0,0,"JGE"]
[7,0,0,0,0,"JGE",0,0]
[8,0,0,0,"MFS",0,0,0]
[9,"PRS",0,0,0,0,0,"RAC"]
[10,0,0,0,0,0,0,0]
[11,"PJC",0,0,0,0,0,0]
[12,"MFS",0,0,0,0,"HLT","PJC"]
[13,0,0,0,0,0,"RAC",0]
[14,"JGE",0,0,0,0,0,0]
[15,"DJM",0,0,0,0,0,0]
[16,0,0,0,0,"JGE",0,0]
[17,0,0,0,"PJC",0,0,"DJM"]
[18,"PJC",0,0,0,"HLT",0,0]
[19,0,0,0,"HLT",0,"MFS",0]
[20,"CJM",0,0,0,"MFS",0,0]
[21,0,"PRS",0,0,0,0,0]
[22,"PRS","HLT",0,0,"CJM",0,0]
[23,"RAC",0,0,"RAC",0,"BBH",0]
[24,0,0,0,"MFS",0,0,0]
[25,0,0,0,0,0,0,"BBH"]
[26,0,0,0,0,"BBH",0,0]
[27,"PJC","PRS",0,"DJM",0,0,0]
[28,"CJM",0,0,0,0,0,"PJC"]
[29,0,0,0,0,0,"DJM",0]
[30,"DJM",0,0,0,0,0,0]
[31,0,"PRS",0,"JGE",0,"PRS",0]
[32,0,0,0,0,"MFS",0,0]
[33,0,0,0,0,0,"CJM",0]
[34,"MFS",0,0,0,"PJC",0,0]
[35,0,0,0,0,0,0,0]
[36,0,0,0,0,0,0,"HLT"]
[37,"HLT",0,0,0,0,0,"PRS"]
[38,0,0,"REC",0,0,0,0]
[39,0,0,0,"RAC",0,"REC",0]
[40,"JGE",0,0,0,0,"PRS",0]
[41,"RAC",0,0,0,0,0,0]
[42,"CJM",0,0,0,0,0,0]
[43,0,0,0,0,0,0,0]
[44,0,0,0,0,0,0,0]
[45,"MFS","JGE",0,0,0,0,"CJM"]
[46,0,0,0,0,0,0,0]
[47,0,0,"REC","JGE","DJM",0,0]
[48,0,"MFS",0,0,0,0,0]
[49,0,0,0,0,0,0,"RAC"]
[50,"DJM",0,0,"CJM",0,"PJC",0]
[51,0,0,0,0,0,0,0]
[52,{"$f":"IF(CurrentRoster!B334>(FirstRosterDay+364),\"\",CurrentRoster!B337)","v":0},{"$f":"IF(CurrentRoster!C334>(FirstRosterDay+364),\"\",CurrentRoster!C337)","v":0},{"$f":"IF(CurrentRoster!D334>(FirstRosterDay+364),\"\",CurrentRoster!D337)","v":0},{"$f":"IF(CurrentRoster!E334>(FirstRosterDay+364),\"\",CurrentRoster!E337)","v":0},{"$f":"IF(CurrentRoster!F334>(FirstRosterDay+364),\"\",CurrentRoster!F337)","v":""},{"$f":"IF(CurrentRoster!G334>(FirstRosterDay+364),\"\",CurrentRoster!G337)","v":""},{"$f":"IF(CurrentRoster!H334>(FirstRosterDay+364),\"\",CurrentRoster!H337)","v":""}]
[]
[]
["AREA FOR STORAGE OF ACTIVE TOOLBAR NAMES"]
["Standard"]
["Formatting"]
["Status Bar"]
["Ribbon"]
{"$rows_empty":117}
["SECOND ON"]
[-2,{"$f":"IF(CurrentRoster!B10<FirstRosterDay,\"\",CurrentRoster!B14)","v":""},{"$f":"IF(CurrentRoster!C10<FirstRosterDay,\"\",CurrentRoster!C14)","v":""},{"$f":"IF(CurrentRoster!D10<FirstRosterDay,\"\",CurrentRoster!D14)","v":""},{"$f":"IF(CurrentRoster!E10<FirstRosterDay,\"\",CurrentRoster!E14)","v":""},{"$f":"IF(CurrentRoster!F10<FirstRosterDay,\"\",CurrentRoster!F14)","v":""},{"$f":"IF(CurrentRoster!G10<FirstRosterDay,\"\",CurrentRoster!G14)","v":""},{"$f":"IF(CurrentRoster!H10<FirstRosterDay,\"\",CurrentRoster!H14)","v":""}]
[-1,{"$f":"IF(CurrentRoster!B16<FirstRosterDay,\"\",CurrentRoster!B20)","v":""},{"$f":"IF(CurrentRoster!C16<FirstRosterDay,\"\",CurrentRoster!C20)","v":""},{"$f":"IF(CurrentRoster!D16<FirstRosterDay,\"\",CurrentRoster!D20)","v":""},{"$f":"IF(CurrentRoster!E16<FirstRosterDay,\"\",CurrentRoster!E20)","v":""},{"$f":"IF(CurrentRoster!F16<FirstRosterDay,\"\",CurrentRoster!F20)","v":""},{"$f":"IF(CurrentRoster!G16<FirstRosterDay,\"\",CurrentRoster!G20)","v":""},{"$f":"IF(CurrentRoster!H16<FirstRosterDay,\"\",CurrentRoster!H20)","v":""}]
[0,{"$f":"IF(CurrentRoster!B22<FirstRosterDay,\"\",CurrentRoster!B26)","v":""},{"$f":"IF(CurrentRoster!C22<FirstRosterDay,\"\",CurrentRoster!C26)","v":""},{"$f":"IF(CurrentRoster!D22<FirstRosterDay,\"\",CurrentRoster!D26)","v":""},{"$f":"IF(CurrentRoster!E22<FirstRosterDay,\"\",CurrentRoster!E26)","v":"DBC"},{"$f":"IF(CurrentRoster!F22<FirstRosterDay,\"\",CurrentRoster!F26)","v":"HLT"},{"$f":"IF(CurrentRoster!G22<FirstRosterDay,\"\",CurrentRoster!G26)","v":"HLT"},{"$f":"IF(CurrentRoster!H22<FirstRosterDay,\"\",CurrentRoster!H26)","v":"HLT"}]
[1,{"$f":"INDIRECT(\"CurrentRoster!B\"&(6*$A302+26))","v":"GAH"},{"$f":"INDIRECT(\"CurrentRoster!C\"&(6*$A302+26))","v":"MBW"},{"$f":"INDIRECT(\"CurrentRoster!D\"&(6*$A302+26))","v":"JGE"},{"$f":"INDIRECT(\"CurrentRoster!E\"&(6*$A302+26))","v":"CJM"},{"$f":"INDIRECT(\"CurrentRoster!F\"&(6*$A302+26))","v":"RAC"},{"$f":"INDIRECT(\"CurrentRoster!G\"&(6*$A302+26))","v":"RAC"},{"$f":"INDIRECT(\"CurrentRoster!H\"&(6*$A302+26))","v":"RAC"}]
[2,{"$f":"INDIRECT(\"CurrentRoster!B\"&(6*$A303+26))","v":"SPF"},{"$f":"INDIRECT(\"CurrentRoster!C\"&(6*$A303+26))","v":"RAC"},{"$f":"INDIRECT(\"CurrentRoster!D\"&(6*$A303+26))","v":"DRP"},{"$f":"INDIRECT(\"CurrentRoster!E\"&(6*$A303+26))","v":"REC"},{"$f":"INDIRECT(\"CurrentRoster!F\"&(6*$A303+26))","v":"PRS"},{"$f":"INDIRECT(\"CurrentRoster!G\"&(6*$A303+26))","v":"PRS"},{"$f":"INDIRECT(\"CurrentRoster!H\"&(6*$A303+26))","v":"PRS"}]
[3,"RJR","RAC","LDP","AJR","DJM","DJM","DJM"]
[4,"MFS","DJM","HLT","PRS","GBH","GBH","GBH"]
[5,"RAC","JGE","MFS","CJM","JGE","JGE","SPF"]
[6,"DBC","DRP","GAH","MBW","RJR","SPF","SPF"]
[7,"SPF","SPF","DJM","REC","HLT","HLT","JGE"]
[8,"LDP","JGE","GAH","PJC","DBC","DBC","MFS"]
[9,"MFS","RAC","RAC","DBC","GAH","GAH","GAH"]
[10,"GBH","DRP","GAH","DBC","GAH","GAH","GAH"]
[11,"AJR","MBW","DJM","SPF","PJC","PJC","PJC"]
[12,"RJR","MFS","HLT","REC","CJM","CJM","CJM"]
[13,"LDP","HLT","PJC","PRS","DBC","LDP","LDP"]
[14,"GAH","DBC","DRP","MBW","AJR","AJR","AJR"]
[15,"LDP","SPF","JGE","CJM","PRS","PRS","PRS"]
[16,"AJR","GBH","DJM","CJM","HLT","RJR","RJR"]
[17,"DJM","PRS","RJR","HLT","RJR","RJR","RJR"]
[18,"PRS","DBC","RAC","REC","RAC","RAC","RAC"]
[19,"MFS","SPF","DBC","JGE","AJR","AJR","AJR"]
[20,"GBH","MBW","DJM","RJR","PJC","PJC","PJC"]
[21,"HLT","DJM","DJM","PRS","GAH","SPF","SPF"]
[22,"REC","JGE","CJM","GAH","LDP","DJM","DJM"]
[23,"HLT","RAC","DRP","DJM","CJM","CJM","CJM"]
[24,"AJR","PJC","GBH","SPF","GAH","GAH","GAH"]
[25,"PJC","RJR","MBW","MFS","REC","REC","REC"]
[26,"LDP","REC","GAH","PRS","GBH","GBH","GBH"]
[27,"GAH","SPF","DBC","GAH","JGE","JGE","JGE"]
[28,"PRS","JGE","DJM","MBW","DBC","DBC","DBC"]
[29,"REC","RAC","DRP","LDP","CJM","CJM","CJM"]
[30,"PJC","JGE","HLT","RAC","MFS","MFS","MFS"]
[31,"PRS","DBC","CJM","LDP","SPF","SPF","SPF"]
[32,"MFS","AJR","SPF","DJM","RJR","RJR","RJR"]
[33,"DRP","JGE","MBW","RJR","REC","REC","REC"]
[34,"GAH","PRS","PJC","DBC","PRS","PRS","PRS"]
[35,"LDP","CJM","GAH","PRS","PJC","MFS","MFS"]
[36,"DJM","DRP","HLT","GBH","HLT","HLT","DJM/MBW"]
[37,"AJR","JGE","MBW","REC","MFS","AJR","AJR"]
[38,"JGE","SPF","PJC","DJM","LDP","LDP","LDP"]
[39,"RAC","PRS","CJM","LDP","AJR","PJC","PJC"]
[40,"MFS","SPF","GAH","HLT","DBC","MFS","MFS"]
[41,"AJR","DRP","DBC","RJR","AJR","DJM","DJM"]
[42,"DJM","MBW","GBH","LDP","HLT","HLT","HLT"]
[43,"AJR","RJR","REC","PRS","DBC","DBC","DBC"]
[44,"HLT","MFS","REC","RAC","SPF","SPF","SPF"]
[45,"DBC","CJM","JGE","SPF","RAC","RAC","RAC"]
[46,"PJC","AJR","DJM","GAH","JGE","JGE","MFS"]
[47,"DRP","DBC","MBW","MFS","PJC","PJC","PJC"]
[48,"AJR","PRS","HLT","LDP","CJM","CJM","CJM"]
[49,"RJR","PJC","RAC","GAH","RAC","LDP","LDP"]
[50,"JGE","DJM","CJM","PJC","LDP","RAC","RAC"]
[51,"PRS","SPF","GBH","DRP","GAH","GAH","GAH"]
[52,{"$f":"IF(CurrentRoster!B334>(FirstRosterDay+365),\"\",CurrentRoster!B338)","v":"MBW"},{"$f":"IF(CurrentRoster!C334>(FirstRosterDay+365),\"\",CurrentRoster!C338)","v":"HLT"},{"$f":"IF(CurrentRoster!D334>(FirstRosterDay+365),\"\",CurrentRoster!D338)","v":"LDP"},{"$f":"IF(CurrentRoster!E334>(FirstRosterDay+365),\"\",CurrentRoster!E338)","v":"RJR"},{"$f":"IF(CurrentRoster!F334>(FirstRosterDay+365),\"\",CurrentRoster!F338)","v":0},{"$f":"IF(CurrentRoster!G334>(FirstRosterDay+365),\"\",CurrentRoster!G338)","v":""},{"$f":"IF(CurrentRoster!H334>(FirstRosterDay+365),\"\",CurrentRoster!H338)","v":""}]
[]
["SATURDAY LIST"]
[1,{"$nulls":5},{"$f":"CurrentRoster!G15","v":0}]
[2,{"$nulls":5},{"$f":"CurrentRoster!G21","v":0}]
[3,{"$nulls":5},{"$f":"CurrentRoster!G27","v":0}]
[4,{"$nulls":5},{"$f":"CurrentRoster!G33","v":0}]
[5,{"$nulls":5},{"$f":"CurrentRoster!G39","v":0}]
[6,{"$nulls":5},{"$f":"CurrentRoster!G45","v":0}]
[7,{"$nulls":5},{"$f":"CurrentRoster!G51","v":0}]
[8,{"$nulls":5},{"$f":"CurrentRoster!G57","v":0}]
[9,{"$nulls":5},{"$f":"CurrentRoster!G63","v":0}]
[10,{"$nulls":5},{"$f":"CurrentRoster!G69","v":0}]
[11,{"$nulls":5},{"$f":"CurrentRoster!G75","v":0}]
[12,{"$nulls":5},{"$f":"CurrentRoster!G81","v":0}]
[13,{"$nulls":5},{"$f":"CurrentRoster!G87","v":0}]
[14,{"$nulls":5},{"$f":"CurrentRoster!G93","v":0}]
[15,{"$nulls":5},{"$f":"CurrentRoster!G99","v":0}]
[16,{"$nulls":5},{"$f":"CurrentRoster!G105","v":0}]
[17,{"$nulls":5},{"$f":"CurrentRoster!G111","v":0}]
[18,{"$nulls":5},{"$f":"CurrentRoster!G117","v":0}]
[19,{"$nulls":5},{"$f":"CurrentRoster!G123","v":0}]
[20,{"$nulls":5},{"$f":"CurrentRoster!G129","v":0}]
[21,{"$nulls":5},{"$f":"CurrentRoster!G135","v":0}]
[22,{"$nulls":5},{"$f":"CurrentRoster!G141","v":0}]
[23,{"$nulls":5},{"$f":"CurrentRoster!G147","v":0}]
[24,{"$nulls":5},{"$f":"CurrentRoster!G153","v":0}]
[25,{"$nulls":5},{"$f":"CurrentRoster!G159","v":0}]
[26,{"$nulls":5},{"$f":"CurrentRoster!G165","v":0}]
[27,{"$nulls":5},{"$f":"CurrentRoster!G171","v":0}]
[28,{"$nulls":5},{"$f":"CurrentRoster!G177","v":0}]
[29,{"$nulls":5},{"$f":"CurrentRoster!G183","v":0}]
[30,{"$nulls":5},{"$f":"CurrentRoster!G189","v":0}]
[31,{"$nulls":5},{"$f":"CurrentRoster!G195","v":0}]
[32,{"$nulls":5},{"$f":"CurrentRoster!G201","v":0}]
[33,{"$nulls":5},{"$f":"CurrentRoster!G207","v":0}]
[34,{"$nulls":5},{"$f":"CurrentRoster!G213","v":0}]
[35,{"$nulls":5},{"$f":"CurrentRoster!G219","v":0}]
[36,{"$nulls":5},{"$f":"CurrentRoster!G225","v":0}]
[37,{"$nulls":5},{"$f":"CurrentRoster!G231","v":0}]
[38,{"$nulls":5},{"$f":"CurrentRoster!G237","v":0}]
[39,{"$nulls":5},{"$f":"CurrentRoster!G243","v":0}]
[40,{"$nulls":5},{"$f":"CurrentRoster!G249","v":0}]
[41,{"$nulls":5},{"$f":"CurrentRoster!G255","v":0}]
[42,{"$nulls":5},{"$f":"CurrentRoster!G261","v":0}]
[43,{"$nulls":5},{"$f":"CurrentRoster!G267","v":0}]
[44,{"$nulls":5},{"$f":"CurrentRoster!G273","v":0}]
[45,{"$nulls":5},{"$f":"CurrentRoster!G279","v":0}]
[46,{"$nulls":5},{"$f":"CurrentRoster!G285","v":0}]
[47,{"$nulls":5},{"$f":"CurrentRoster!G291","v":0}]
[48,{"$nulls":5},{"$f":"CurrentRoster!G297","v":0}]
[49,{"$nulls":5},{"$f":"CurrentRoster!G303","v":0}]
[50,{"$nulls":5},{"$f":"CurrentRoster!G309","v":0}]
[51,{"$nulls":5},{"$f":"CurrentRoster!G315","v":0}]
[52,{"$nulls":5},{"$f":"CurrentRoster!G321","v":0}]

{"sheet":"CurrentRoster","index":3,"n_rows":345,"n_cols":9,"rows_kept":345,"merged":[[0,3,0,5],[1,0,1,7],[3,0,3,7],[4,0,4,7],[5,0,5,7],[6,0,6,7],[7,4,7,6],[14,1,14,5],[20,1,20,5],[26,1,26,5],[32,1,32,5],[38,1,38,5],[44,1,44,5],[50,1,50,5],[56,1,56,5],[62,1,62,5],[68,1,68,5],[74,1,74,5],[80,1,80,5],[86,1,86,5],[92,1,92,5],[98,1,98,5],[104,1,104,5],[110,1,110,5],[116,1,116,5],[122,1,122,5],[128,1,128,5],[134,1,134,5],[140,1,140,5],[146,1,146,5],[152,1,152,5],[158,1,158,5],[164,1,164,5],[170,1,170,5],[176,1,176,5],[182,1,182,5],[188,1,188,5],[194,1,194,5],[200,1,200,5],[206,1,206,5],[212,1,212,5],[218,1,218,5],[224,1,224,5],[230,1,230,5],[236,1,236,5],[242,1,242,5],[248,1,248,5],[254,1,254,5],[260,1,260,5],[266,1,266,5],[272,1,272,5],[278,1,278,5],[284,1,284,5],[290,1,290,5],[296,1,296,5],[302,1,302,5],[308,1,308,5],[314,1,314,5],[320,1,320,5],[326,1,326,5],[332,1,332,5],[338,1,338,5],[344,1,344,5]]}
[{"$nulls":3},{"$f":"CurrentYear","v":2018}]
["Roster for Anaesthesia and Intensive Care"]
[]
["THIS VERSION IS THE CURRENT ACTIVE ROSTER"]
["The file is held on the AGB server and is regularly updated"]
["THIS VERSION IS A DUPLICATE FOR OFFSITE VIEWING"]
["It is only updated weekly and may not contain changes made within the last few days."]
[null,null,"This copy is current as of;",null,{"$f":"NOW()-NOW()+getproperty(\"Last Save Time\")","v":"2018-12-21T16:16:51"}]
[]
[-2,{"$f":"CurrentRosterStart","v":"2018-01-15"},{"$f":"$B10+1","v":"2018-01-16"},{"$f":"$B10+2","v":"2018-01-17"},{"$f":"$B10+3","v":"2018-01-18"},{"$f":"$B10+4","v":"2018-01-19"},{"$f":"$B10+5","v":"2018-01-20"},{"$f":"$B10+6","v":"2018-01-21"}]
["ICU","RJR","RJR","WRA","WRA","RJR","RJR","RJR"]
["AGB","AJR","RAC","LDP","PRS","MFS","JGE","JGE"]
["BHS",{"$nulls":3},"JGE",null,"MFS"]
["BACKUP","PRS","JGE","JGE","GAH","AJR","AJR","AJR"]
["Leave","DBC SPF GBH DJM HLT"]
[-1,{"$f":"CurrentRosterStart+7*(A16+2)","v":"2018-01-22"},{"$f":"$B16+1","v":"2018-01-23"},{"$f":"$B16+2","v":"2018-01-24"},{"$f":"$B16+3","v":"2018-01-25"},{"$f":"$B16+4","v":"2018-01-26"},{"$f":"$B16+5","v":"2018-01-27"},{"$f":"$B16+6","v":"2018-01-28"}]
["ICU","RCG","RCG","AJR","AJR","WRA","WRA","WRA"]
["AGB","GAH","SPF","DBC","GBH","JGE","AJR","AJR"]
["BHS"]
["BACKUP","DBC","GBH","RJR","LDP","RAC","RAC","RAC"]
["Leave","DJM LDP"]
[0,{"$f":"CurrentRosterStart+7*(A22+2)","v":"2018-01-29"},{"$f":"$B22+1","v":"2018-01-30"},{"$f":"$B22+2","v":"2018-01-31"},{"$f":"$B22+3","v":"2018-02-01"},{"$f":"$B22+4","v":"2018-02-02"},{"$f":"$B22+5","v":"2018-02-03"},{"$f":"$B22+6","v":"2018-02-04"}]
["ICU","AJR","AJR","WRA","WRA","AJR","DK","DK"]
["AGB","DBC","RJR","AJR","PRS","GBH","GBH","GBH"]
["BHS","JGE",null,null,"MFS"]
["BACKUP","GBH","SPF","MFS","DBC","HLT","HLT","HLT"]
["Leave","LDP JGE(W-F)"]
[{"$f":"A22+1","v":1},{"$f":"CurrentRosterStart+7*(A28+2)","v":"2018-02-05"},{"$f":"$B28+1","v":"2018-02-06"},{"$f":"$B28+2","v":"2018-02-07"},{"$f":"$B28+3","v":"2018-02-08"},{"$f":"$B28+4","v":"2018-02-09"},{"$f":"$B28+5","v":"2018-02-10"},{"$f":"$B28+6","v":"2018-02-11"}]
["ICU","RCG","RCG","LDP","LDP","DBC","DBC","DBC"]
["AGB","DJM","CJM","DJM","PRS","AJR","GAH","GAH"]
["BHS",null,"PRS",null,null,"CJM","HLT"]
["BACKUP","GAH","MBW","JGE","CJM","RAC","RAC","RAC"]
["Leave","MFS"]
[{"$f":"A28+1","v":2},{"$f":"CurrentRosterStart+7*(A34+2)","v":"2018-02-12"},{"$f":"$B34+1","v":"2018-02-13"},{"$f":"$B34+2","v":"2018-02-14"},{"$f":"$B34+3","v":"2018-02-15"},{"$f":"$B34+4","v":"2018-02-16"},{"$f":"$B34+5","v":"2018-02-17"},{"$f":"$B34+6","v":"2018-02-18"}]
["ICU","MAK","MAK","AJR","AJR","MAK","MAK","MAK"]
["AGB","LDP","PRS","DBC","HLT","DJM","RAC","RAC"]
["BHS",{"$nulls":5},"MFS","JGE"]
["BACKUP","SPF","RAC","DRP","REC","PRS","PRS","PRS"]
["Leave","CJM  RCG"]
[{"$f":"A34+1","v":3},{"$f":"CurrentRosterStart+7*(A40+2)","v":"2018-02-19"},{"$f":"$B40+1","v":"2018-02-20"},{"$f":"$B40+2","v":"2018-02-21"},{"$f":"$B40+3","v":"2018-02-22"},{"$f":"$B40+4","v":"2018-02-23"},{"$f":"$B40+5","v":"2018-02-24"},{"$f":"$B40+6","v":"2018-02-25"}]
["ICU","AJR","AJR","WRA","WRA","DBC","DBC","DBC"]
["AGB","HLT","MFS","JGE","SPF","REC","JGE","JGE"]
["BHS",{"$nulls":4},"RAC"]
["BACKUP","RJR","RAC","LDP","AJR","DJM","DJM","DJM"]
["Leave","GAH CJM MBW RCG"]
[{"$f":"A40+1","v":4},{"$f":"CurrentRosterStart+7*(A46+2)","v":"2018-02-26"},{"$f":"$B46+1","v":"2018-02-27"},{"$f":"$B46+2","v":"2018-02-28"},{"$f":"$B46+3","v":"2018-03-01"},{"$f":"$B46+4","v":"2018-03-02"},{"$f":"$B46+5","v":"2018-03-03"},{"$f":"$B46+6","v":"2018-03-04"}]
["ICU","MAK","MAK","WRA","WRA","WS","WS","WS"]
["AGB","AJR","RJR","JGE","RAC","HLT","REC","REC"]
["BHS",{"$nulls":3},"PJC"]
["BACKUP","MFS","DJM","HLT","PRS","GBH","GBH","GBH"]
["Leave","PJC GAH CJM DRP"]
[{"$f":"A46+1","v":5},{"$f":"CurrentRosterStart+7*(A52+2)","v":"2018-03-05"},{"$f":"$B52+1","v":"2018-03-06"},{"$f":"$B52+2","v":"2018-03-07"},{"$f":"$B52+3","v":"2018-03-08"},{"$f":"$B52+4","v":"2018-03-09"},{"$f":"$B52+5","v":"2018-03-10"},{"$f":"$B52+6","v":"2018-03-11"}]
["ICU","RCG","RCG","AJR","AJR","LDP","LDP","LDP"]
["AGB","LDP","PRS","CJM","SPF","GAH","DJM","DJM"]
["BHS",{"$nulls":4},"DJM",null,"JGE"]
["BACKUP","RAC","JGE","MFS","CJM","JGE","JGE","SPF"]
["Leave","PJC DRP(M)"]
[{"$f":"A52+1","v":6},{"$f":"CurrentRosterStart+7*(A58+2)","v":"2018-03-12"},{"$f":"$B58+1","v":"2018-03-13"},{"$f":"$B58+2","v":"2018-03-14"},{"$f":"$B58+3","v":"2018-03-15"},{"$f":"$B58+4","v":"2018-03-16"},{"$f":"$B58+5","v":"2018-03-17"},{"$f":"$B58+6","v":"2018-03-18"}]
["ICU","WRA","WRA","DBC","DBC","AJR","AJR","AJR"]
["AGB","RJR","AJR","DJM","MFS","PJC","PRS","PRS"]
["BHS",{"$nulls":6},"JGE"]
["BACKUP","DBC","DRP","GAH","MBW","RJR","SPF","SPF"]
["Leave","DRP(TH-F) WRA(TH-F)"]
[{"$f":"A58+1","v":7},{"$f":"CurrentRosterStart+7*(A64+2)","v":"2018-03-19"},{"$f":"$B64+1","v":"2018-03-20"},{"$f":"$B64+2","v":"2018-03-21"},{"$f":"$B64+3","v":"2018-03-22"},{"$f":"$B64+4","v":"2018-03-23"},{"$f":"$B64+5","v":"2018-03-24"},{"$f":"$B64+6","v":"2018-03-25"}]
["ICU","MAK","MAK","AJR","AJR","RJR","RJR","RJR"]
["AGB","REC","RAC","GAH","LDP","DBC","PJC","PJC"]
["BHS",{"$nulls":4},"JGE"]
["BACKUP","SPF","SPF","DJM","REC","HLT","HLT","JGE"]
["Leave","DRP(TH-F) RCG WRA"]
[{"$f":"A64+1","v":8},{"$f":"CurrentRosterStart+7*(A70+2)","v":"2018-03-26"},{"$f":"$B70+1","v":"2018-03-27"},{"$f":"$B70+2","v":"2018-03-28"},{"$f":"$B70+3","v":"2018-03-29"},{"$f":"$B70+4","v":"2018-03-30"},{"$f":"$B70+5","v":"2018-03-31"},{"$f":"$B70+6","v":"2018-04-01"}]
["ICU","AJR","AJR","LDP","LDP","WRA","WRA","WRA"]
["AGB","HLT","MFS","RJR","AJR","PRS","PRS","CJM"]
["BHS",{"$nulls":3},"MFS"]
["BACKUP","LDP","JGE","GAH","PJC","DBC","DBC","MFS"]
["Leave","RCG WRA(M-TH) REC GAH"]
[{"$f":"A70+1","v":9},{"$f":"CurrentRosterStart+7*(A76+2)","v":"2018-04-02"},{"$f":"$B76+1","v":"2018-04-03"},{"$f":"$B76+2","v":"2018-04-04"},{"$f":"$B76+3","v":"2018-04-05"},{"$f":"$B76+4","v":"2018-04-06"},{"$f":"$B76+5","v":"2018-04-07"},{"$f":"$B76+6","v":"2018-04-08"}]
["ICU","MAK","MAK","RJR","RJR","GBH","GBH","GBH"]
["AGB","CJM","DBC","GAH","REC","PJC","MFS","MFS"]
["BHS","PRS",{"$nulls":5},"RAC"]
["BACKUP","MFS","RAC","RAC","DBC","GAH","GAH","GAH"]
["Leave","JGE DJM(M-TU) AJR RCG WRA GAH"]
[{"$f":"A76+1","v":10},{"$f":"CurrentRosterStart+7*(A82+2)","v":"2018-04-09"},{"$f":"$B82+1","v":"2018-04-10"},{"$f":"$B82+2","v":"2018-04-11"},{"$f":"$B82+3","v":"2018-04-12"},{"$f":"$B82+4","v":"2018-04-13"},{"$f":"$B82+5","v":"2018-04-14"},{"$f":"$B82+6","v":"2018-04-15"}]
["ICU","RJR","RJR","WRA","WRA","GBH","GBH","GBH"]
["AGB","HLT","DBC","RAC","CJM","PRS","PRS","PRS"]
["BHS"]
["BACKUP","GBH","DRP","GAH","DBC","GAH","GAH","GAH"]
["Leave","JGE DJM(M-W) AJR SPF"]
[{"$f":"A82+1","v":11},{"$f":"CurrentRosterStart+7*(A88+2)","v":"2018-04-16"},{"$f":"$B88+1","v":"2018-04-17"},{"$f":"$B88+2","v":"2018-04-18"},{"$f":"$B88+3","v":"2018-04-19"},{"$f":"$B88+4","v":"2018-04-20"},{"$f":"$B88+5","v":"2018-04-21"},{"$f":"$B88+6","v":"2018-04-22"}]
["ICU","LDP","LDP","AJR","AJR","MAK","MAK","MAK"]
["AGB","DJM",null,"MFS","JGE","RJR","HLT","HLT"]
["BHS","PJC"]
["BACKUP","AJR","MBW","DJM","SPF","PJC","PJC","PJC"]
["Leave","DBC  RCG/WRA"]
[{"$f":"A88+1","v":12},{"$f":"CurrentRosterStart+7*(A94+2)","v":"2018-04-23"},{"$f":"$B94+1","v":"2018-04-24"},{"$f":"$B94+2","v":"2018-04-25"},{"$f":"$B94+3","v":"2018-04-26"},{"$f":"$B94+4","v":"2018-04-27"},{"$f":"$B94+5","v":"2018-04-28"},{"$f":"$B94+6","v":"2018-04-29"}]
["ICU","AJR","AJR","WRA","WRA","AJR","DK","DK"]
["AGB","DJM","DBC","SPF","RAC","GAH","RJR","RJR"]
["BHS","MFS",{"$nulls":4},"HLT","PJC"]
["BACKUP","RJR","MFS","HLT","REC","CJM","CJM","CJM"]
["Leave","LDP"]
[{"$f":"A94+1","v":13},{"$f":"CurrentRosterStart+7*(A100+2)","v":"2018-04-30"},{"$f":"$B100+1","v":"2018-05-01"},{"$f":"$B100+2","v":"2018-05-02"},{"$f":"$B100+3","v":"2018-05-03"},{"$f":"$B100+4","v":"2018-05-04"},{"$f":"$B100+5","v":"2018-05-05"},{"$f":"$B100+6","v":"2018-05-06"}]
["ICU","MAK","MAK","AJR","AJR","WRA","WRA","WRA"]
["AGB","PJC","PRS","LDP","REC","JGE","DBC","DBC"]
["BHS",{"$nulls":5},"RAC"]
["BACKUP","LDP","HLT","PJC","PRS","DBC","LDP","LDP"]
["Leave","RCG"]
[{"$f":"A100+1","v":14},{"$f":"CurrentRosterStart+7*(A106+2)","v":"2018-05-07"},{"$f":"$B106+1","v":"2018-05-08"},{"$f":"$B106+2","v":"2018-05-09"},{"$f":"$B106+3","v":"2018-05-10"},{"$f":"$B106+4","v":"2018-05-11"},{"$f":"$B106+5","v":"2018-05-12"},{"$f":"$B106+6","v":"2018-05-13"}]
["ICU","MAK","MAK","WRA","WRA","WS","WS","WS"]
["AGB","AJR","JGE","DBC","LDP","RAC","GAH","GAH"]
["BHS","JGE"]
["BACKUP","GAH","DBC","DRP","MBW","AJR","AJR","AJR"]
["Leave","SPF ?GBH DJM CJM"]
[{"$f":"A106+1","v":15},{"$f":"CurrentRosterStart+7*(A112+2)","v":"2018-05-14"},{"$f":"$B112+1","v":"2018-05-15"},{"$f":"$B112+2","v":"2018-05-16"},{"$f":"$B112+3","v":"2018-05-17"},{"$f":"$B112+4","v":"2018-05-18"},{"$f":"$B112+5","v":"2018-05-19"},{"$f":"$B112+6","v":"2018-05-20"}]
["ICU","RCG","RCG","AJR","AJR","WRA","RCG","RCG"]
["AGB","CJM","PRS","PJC","DBC","REC","LDP","LDP"]
["BHS","DJM"]
["BACKUP","LDP","SPF","JGE","CJM","PRS","PRS","PRS"]
["Leave","RAC"]
[{"$f":"A112+1","v":16},{"$f":"CurrentRosterStart+7*(A118+2)","v":"2018-05-21"},{"$f":"$B118+1","v":"2018-05-22"},{"$f":"$B118+2","v":"2018-05-23"},{"$f":"$B118+3","v":"2018-05-24"},{"$f":"$B118+4","v":"2018-05-25"},{"$f":"$B118+5","v":"2018-05-26"},{"$f":"$B118+6","v":"2018-05-27"}]
["ICU","WRA","WRA","DBC","DBC","RJR","RJR","RJR"]
["AGB","RJR","HLT","MFS","LDP","GBH","GBH","GBH"]
["BHS",{"$nulls":4},"JGE"]
["BACKUP","AJR","GBH","DJM","CJM","HLT","RJR","RJR"]
["Leave","RAC AJR(TH-F)"]
[{"$f":"A118+1","v":17},{"$f":"CurrentRosterStart+7*(A124+2)","v":"2018-05-28"},{"$f":"$B124+1","v":"2018-05-29"},{"$f":"$B124+2","v":"2018-05-30"},{"$f":"$B124+3","v":"2018-05-31"},{"$f":"$B124+4","v":"2018-06-01"},{"$f":"$B124+5","v":"2018-06-02"},{"$f":"$B124+6","v":"2018-06-03"}]
["ICU","RCG","RCG","WRA","WRA","DBC","DBC","DBC"]
["AGB","GAH","PJC","SPF","DJM","JGE","JGE","JGE"]
["BHS",{"$nulls":3},"PJC",null,null,"DJM"]
["BACKUP","DJM","PRS","RJR","HLT","RJR","RJR","RJR"]
["Leave","LDP     CJM/DRP/AJR(TH-F)"]
[{"$f":"A124+1","v":18},{"$f":"CurrentRosterStart+7*(A130+2)","v":"2018-06-04"},{"$f":"$B130+1","v":"2018-06-05"},{"$f":"$B130+2","v":"2018-06-06"},{"$f":"$B130+3","v":"2018-06-07"},{"$f":"$B130+4","v":"2018-06-08"},{"$f":"$B130+5","v":"2018-06-09"},{"$f":"$B130+6","v":"2018-06-10"}]
["ICU","MAK","MAK","WRA","WRA","MAK","MAK","MAK"]
["AGB","RAC","GAH","SPF","GBH","DBC","SPF","SPF"]
["BHS","PJC",{"$nulls":3},"HLT"]
["BACKUP","PRS","DBC","RAC","REC","RAC","RAC","RAC"]
["Leave","CJM LDP DRP MFS AJR(M-W)"]
[{"$f":"A130+1","v":19},{"$f":"CurrentRosterStart+7*(A136+2)","v":"2018-06-11"},{"$f":"$B136+1","v":"2018-06-12"},{"$f":"$B136+2","v":"2018-06-13"},{"$f":"$B136+3","v":"2018-06-14"},{"$f":"$B136+4","v":"2018-06-15"},{"$f":"$B136+5","v":"2018-06-16"},{"$f":"$B136+6","v":"2018-06-17"}]
["ICU","RCG","RCG","AJR","AJR","RCG","DK","DK"]
["AGB","DJM","LDP","GBH","DJM","SPF","DJM","DJM"]
["BHS",{"$nulls":3},"HLT",null,"MFS"]
["BACKUP","MFS","SPF","DBC","JGE","AJR","AJR","AJR"]
["Leave","DRP"]
[{"$f":"A136+1","v":20},{"$f":"CurrentRosterStart+7*(A142+2)","v":"2018-06-18"},{"$f":"$B142+1","v":"2018-06-19"},{"$f":"$B142+2","v":"2018-06-20"},{"$f":"$B142+3","v":"2018-06-21"},{"$f":"$B142+4","v":"2018-06-22"},{"$f":"$B142+5","v":"2018-06-23"},{"$f":"$B142+6","v":"2018-06-24"}]
["ICU","MAK","MAK","WRA","WRA","LDP","LDP","LDP"]
["AGB","RJR","HLT","GAH","JGE","CJM","CJM","CJM"]
["BHS","CJM",{"$nulls":3},"MFS"]
["BACKUP","GBH","MBW","DJM","RJR","PJC","PJC","PJC"]
["Leave","DRP PRS HLT"]
[{"$f":"A142+1","v":21},{"$f":"CurrentRosterStart+7*(A148+2)","v":"2018-06-25"},{"$f":"$B148+1","v":"2018-06-26"},{"$f":"$B148+2","v":"2018-06-27"},{"$f":"$B148+3","v":"2018-06-28"},{"$f":"$B148+4","v":"2018-06-29"},{"$f":"$B148+5","v":"2018-06-30"},{"$f":"$B148+6","v":"2018-07-01"}]
["ICU","RCG","RCG","DBC","DBC","MAK","RCG","RCG"]
["AGB","PJC","AJR","GAH","AJR","SPF","GAH","GAH"]
["BHS",null,"PRS"]
["BACKUP","HLT","DJM","DJM","PRS","GAH","SPF","SPF"]
["Leave","JGE WRA"]
[{"$f":"A148+1","v":22},{"$f":"CurrentRosterStart+7*(A154+2)","v":"2018-07-02"},{"$f":"$B154+1","v":"2018-07-03"},{"$f":"$B154+2","v":"2018-07-04"},{"$f":"$B154+3","v":"2018-07-05"},{"$f":"$B154+4","v":"2018-07-06"},{"$f":"$B154+5","v":"2018-07-07"},{"$f":"$B154+6","v":"2018-07-08"}]
["ICU","MAK","MAK","DBC","DBC","RCG","MAK","MAK"]
["AGB","CJM","RAC","GAH","SPF","MFS","REC","REC"]
["BHS","PRS","HLT",null,null,"CJM"]
["BACKUP","REC","JGE","CJM","GAH","LDP","DJM","DJM"]
["Leave","JGE RJR AJR HLT WRA"]
[{"$f":"A154+1","v":23},{"$f":"CurrentRosterStart+7*(A160+2)","v":"2018-07-09"},{"$f":"$B160+1","v":"2018-07-10"},{"$f":"$B160+2","v":"2018-07-11"},{"$f":"$B160+3","v":"2018-07-12"},{"$f":"$B160+4","v":"2018-07-13"},{"$f":"$B160+5","v":"2018-07-14"},{"$f":"$B160+6","v":"2018-07-15"}]
["ICU","RCG","RCG","MAK","MAK","GBH","GBH","GBH"]
["AGB","LDP","PRS","HLT","PJC","DJM","MFS","MFS"]
["BHS","RAC",null,null,"RAC",null,"BBH"]
["BACKUP","HLT","RAC","DRP","DJM","CJM","CJM","CJM"]
["Leave","JGE SPF HLT WRA"]
[{"$f":"A160+1","v":24},{"$f":"CurrentRosterStart+7*(A166+2)","v":"2018-07-16"},{"$f":"$B166+1","v":"2018-07-17"},{"$f":"$B166+2","v":"2018-07-18"},{"$f":"$B166+3","v":"2018-07-19"},{"$f":"$B166+4","v":"2018-07-20"},{"$f":"$B166+5","v":"2018-07-21"},{"$f":"$B166+6","v":"2018-07-22"}]
["ICU","MAK","MAK","AJR","AJR","WS","WS","WS"]
["AGB","DJM","CJM","REC","RAC","SPF","SPF","SPF"]
["BHS",{"$nulls":3},"MFS"]
["BACKUP","AJR","PJC","GBH","SPF","GAH","GAH","GAH"]
["Leave","DBC WRA"]
[{"$f":"A166+1","v":25},{"$f":"CurrentRosterStart+7*(A172+2)","v":"2018-07-23"},{"$f":"$B172+1","v":"2018-07-24"},{"$f":"$B172+2","v":"2018-07-25"},{"$f":"$B172+3","v":"2018-07-26"},{"$f":"$B172+4","v":"2018-07-27"},{"$f":"$B172+5","v":"2018-07-28"},{"$f":"$B172+6","v":"2018-07-29"}]
["ICU","RCG","RCG","AJR","AJR","WRA","WRA","WRA"]
["AGB","MFS","PRS","PJC","RJR","HLT","HLT","HLT"]
["BHS",{"$nulls":6},"BBH"]
["BACKUP","PJC","RJR","MBW","MFS","REC","REC","REC"]
["Leave","DBC RAC"]
[{"$f":"A172+1","v":26},{"$f":"CurrentRosterStart+7*(A178+2)","v":"2018-07-30"},{"$f":"$B178+1","v":"2018-07-31"},{"$f":"$B178+2","v":"2018-08-01"},{"$f":"$B178+3","v":"2018-08-02"},{"$f":"$B178+4","v":"2018-08-03"},{"$f":"$B178+5","v":"2018-08-04"},{"$f":"$B178+6","v":"2018-08-05"}]
["ICU","MAK","MAK","WRA","WRA","AJR","AJR","AJR"]
["AGB","DBC","AJR","REC","RJR","LDP","DBC","DBC"]
["BHS",{"$nulls":4},"BBH"]
["BACKUP","LDP","REC","GAH","PRS","GBH","GBH","GBH"]
["Leave","RAC MFS"]
[{"$f":"A178+1","v":27},{"$f":"CurrentRosterStart+7*(A184+2)","v":"2018-08-06"},{"$f":"$B184+1","v":"2018-08-07"},{"$f":"$B184+2","v":"2018-08-08"},{"$f":"$B184+3","v":"2018-08-09"},{"$f":"$B184+4","v":"2018-08-10"},{"$f":"$B184+5","v":"2018-08-11"},{"$f":"$B184+6","v":"2018-08-12"}]
["ICU","RCG","RCG","LDP","LDP","AJR","DK","DK"]
["AGB","DJM","JGE","HLT","PJC","HLT","PRS","PRS"]
["BHS","PJC","PRS",null,"DJM"]
["BACKUP","GAH","SPF","DBC","GAH","JGE","JGE","JGE"]
["Leave","RAC MFS REC"]
[{"$f":"A184+1","v":28},{"$f":"CurrentRosterStart+7*(A190+2)","v":"2018-08-13"},{"$f":"$B190+1","v":"2018-08-14"},{"$f":"$B190+2","v":"2018-08-15"},{"$f":"$B190+3","v":"2018-08-16"},{"$f":"$B190+4","v":"2018-08-17"},{"$f":"$B190+5","v":"2018-08-18"},{"$f":"$B190+6","v":"2018-08-19"}]
["ICU","RJR","RJR","WRA","WRA","LDP","LDP","LDP"]
["AGB","AJR","SPF","GAH","JGE","PJC","AJR","AJR"]
["BHS","CJM",{"$nulls":5},"PJC"]
["BACKUP","PRS","JGE","DJM","MBW","DBC","DBC","DBC"]
["Leave","REC RAC MFS RCG"]
[{"$f":"A190+1","v":29},{"$f":"CurrentRosterStart+7*(A196+2)","v":"2018-08-20"},{"$f":"$B196+1","v":"2018-08-21"},{"$f":"$B196+2","v":"2018-08-22"},{"$f":"$B196+3","v":"2018-08-23"},{"$f":"$B196+4","v":"2018-08-24"},{"$f":"$B196+5","v":"2018-08-25"},{"$f":"$B196+6","v":"2018-08-26"}]
["ICU","MAK","MAK","AJR","AJR","LDP","RCG","RCG"]
["AGB","DJM","PRS","HLT","REC","RJR","RAC","RAC"]
["BHS",{"$nulls":5},"DJM"]
["BACKUP","REC","RAC","DRP","LDP","CJM","CJM","CJM"]
["Leave","MFS"]
[{"$f":"A196+1","v":30},{"$f":"CurrentRosterStart+7*(A202+2)","v":"2018-08-27"},{"$f":"$B202+1","v":"2018-08-28"},{"$f":"$B202+2","v":"2018-08-29"},{"$f":"$B202+3","v":"2018-08-30"},{"$f":"$B202+4","v":"2018-08-31"},{"$f":"$B202+5","v":"2018-09-01"},{"$f":"$B202+6","v":"2018-09-02"}]
["ICU","LDP","LDP","WRA","WRA","WS","WS","WS"]
["AGB","DBC","MFS","CJM","PRS","JGE","LDP","LDP"]
["BHS","DJM"]
["BACKUP","PJC","JGE","HLT","RAC","MFS","MFS","MFS"]
["Leave","GAH DRP"]
[{"$f":"A202+1","v":31},{"$f":"CurrentRosterStart+7*(A208+2)","v":"2018-09-03"},{"$f":"$B208+1","v":"2018-09-04"},{"$f":"$B208+2","v":"2018-09-05"},{"$f":"$B208+3","v":"2018-09-06"},{"$f":"$B208+4","v":"2018-09-07"},{"$f":"$B208+5","v":"2018-09-08"},{"$f":"$B208+6","v":"2018-09-09"}]
["ICU","RCG","RCG","AJR","AJR","DBC","DBC","DBC"]
["AGB","AJR","LDP","DJM","MFS","RAC","JGE","JGE"]
["BHS",null,"PRS",null,"JGE",null,"PRS"]
["BACKUP","PRS","DBC","CJM","LDP","SPF","SPF","SPF"]
["Leave","GAH DRP WRA LDP(TH-F)"]
[{"$f":"A208+1","v":32},{"$f":"CurrentRosterStart+7*(A214+2)","v":"2018-09-10"},{"$f":"$B214+1","v":"2018-09-11"},{"$f":"$B214+2","v":"2018-09-12"},{"$f":"$B214+3","v":"2018-09-13"},{"$f":"$B214+4","v":"2018-09-14"},{"$f":"$B214+5","v":"2018-09-15"},{"$f":"$B214+6","v":"2018-09-16"}]
["ICU","MAK","MAK","WRA","WRA","AJR","AJR","AJR"]
["AGB","RJR","JGE","GBH","HLT","CJM","CJM","CJM"]
["BHS",{"$nulls":4},"MFS"]
["BACKUP","MFS","AJR","SPF","DJM","RJR","RJR","RJR"]
["Leave","GAH LDP DRP"]
[{"$f":"A214+1","v":33},{"$f":"CurrentRosterStart+7*(A220+2)","v":"2018-09-17"},{"$f":"$B220+1","v":"2018-09-18"},{"$f":"$B220+2","v":"2018-09-19"},{"$f":"$B220+3","v":"2018-09-20"},{"$f":"$B220+4","v":"2018-09-21"},{"$f":"$B220+5","v":"2018-09-22"},{"$f":"$B220+6","v":"2018-09-23"}]
["ICU","DBC","DBC","WRA","WRA","WS","WS","WS"]
["AGB","RAC","SPF","MFS","CJM","AJR","AJR","AJR"]
["BHS",{"$nulls":5},"CJM"]
["BACKUP","DRP","JGE","MBW","RJR","REC","REC","REC"]
["Leave","GAH DJM LDP HLT RCG"]
[{"$f":"A220+1","v":34},{"$f":"CurrentRosterStart+7*(A226+2)","v":"2018-09-24"},{"$f":"$B226+1","v":"2018-09-25"},{"$f":"$B226+2","v":"2018-09-26"},{"$f":"$B226+3","v":"2018-09-27"},{"$f":"$B226+4","v":"2018-09-28"},{"$f":"$B226+5","v":"2018-09-29"},{"$f":"$B226+6","v":"2018-09-30"}]
["ICU","MAK","MAK","RJR","RJR","GBH","GBH","GBH"]
["AGB","RAC","JGE","REC","PRS","AJR","PJC","PJC"]
["BHS","MFS",{"$nulls":3},"PJC"]
["BACKUP","GAH","PRS","PJC","DBC","PRS","PRS","PRS"]
["Leave","SPF DJM HLT RCG"]
[{"$f":"A226+1","v":35},{"$f":"CurrentRosterStart+7*(A232+2)","v":"2018-10-01"},{"$f":"$B232+1","v":"2018-10-02"},{"$f":"$B232+2","v":"2018-10-03"},{"$f":"$B232+3","v":"2018-10-04"},{"$f":"$B232+4","v":"2018-10-05"},{"$f":"$B232+5","v":"2018-10-06"},{"$f":"$B232+6","v":"2018-10-07"}]
["ICU","DBC","DBC","WRA","WRA","AJR","AJR","AJR"]
["AGB","RAC","GBH","LDP","DBC","RAC","SPF","SPF"]
["BHS"]
["BACKUP","LDP","CJM","GAH","PRS","PJC","MFS","MFS"]
["Leave","JGE DJM HLT RCG"]
[{"$f":"A232+1","v":36},{"$f":"CurrentRosterStart+7*(A238+2)","v":"2018-10-08"},{"$f":"$B238+1","v":"2018-10-09"},{"$f":"$B238+2","v":"2018-10-10"},{"$f":"$B238+3","v":"2018-10-11"},{"$f":"$B238+4","v":"2018-10-12"},{"$f":"$B238+5","v":"2018-10-13"},{"$f":"$B238+6","v":"2018-10-14"}]
["ICU","MAK","MAK","AJR","AJR","RCG","LDP","LDP"]
["AGB","GAH","SPF","RAC","PRS","PJC","REC","REC"]
["BHS",{"$nulls":6},"HLT"]
["BACKUP","DJM","DRP","HLT","GBH","HLT","HLT","DJM/MBW"]
["Leave","DBC"]
[{"$f":"A238+1","v":37},{"$f":"CurrentRosterStart+7*(A244+2)","v":"2018-10-15"},{"$f":"$B244+1","v":"2018-10-16"},{"$f":"$B244+2","v":"2018-10-17"},{"$f":"$B244+3","v":"2018-10-18"},{"$f":"$B244+4","v":"2018-10-19"},{"$f":"$B244+5","v":"2018-10-20"},{"$f":"$B244+6","v":"2018-10-21"}]
["ICU","RCG","RCG","MAK","MAK","MAK","RCG","RCG"]
["AGB","CJM","PRS","RAC","LDP","HLT","MFS","MFS"]
["BHS","HLT",{"$nulls":5},"PRS"]
["BACKUP","AJR","JGE","MBW","REC","MFS","AJR","AJR"]
["Leave","DBC SPF GBH DJM"]
[{"$f":"A244+1","v":38},{"$f":"CurrentRosterStart+7*(A250+2)","v":"2018-10-22"},{"$f":"$B250+1","v":"2018-10-23"},{"$f":"$B250+2","v":"2018-10-24"},{"$f":"$B250+3","v":"2018-10-25"},{"$f":"$B250+4","v":"2018-10-26"},{"$f":"$B250+5","v":"2018-10-27"},{"$f":"$B250+6","v":"2018-10-28"}]
["ICU","MAK","MAK","WRA","WRA","AJR","AJR","AJR"]
["AGB","PJC","GAH","LDP","GBH","DBC","GBH","GBH"]
["BHS",null,null,"REC"]
["BACKUP","JGE","SPF","PJC","DJM","LDP","LDP","LDP"]
["Leave"]
[{"$f":"A250+1","v":39},{"$f":"CurrentRosterStart+7*(A256+2)","v":"2018-10-29"},{"$f":"$B256+1","v":"2018-10-30"},{"$f":"$B256+2","v":"2018-10-31"},{"$f":"$B256+3","v":"2018-11-01"},{"$f":"$B256+4","v":"2018-11-02"},{"$f":"$B256+5","v":"2018-11-03"},{"$f":"$B256+6","v":"2018-11-04"}]
["ICU","RCG","RCG","AJR","AJR","DBC","DBC","DBC"]
["AGB","DJM","CJM","SPF","RJR","DJM","DJM","DJM"]
["BHS",{"$nulls":3},"RAC",null,"REC"]
["BACKUP","RAC","PRS","CJM","LDP","AJR","PJC","PJC"]
["Leave"]
[{"$f":"A256+1","v":40},{"$f":"CurrentRosterStart+7*(A262+2)","v":"2018-11-05"},{"$f":"$B262+1","v":"2018-11-06"},{"$f":"$B262+2","v":"2018-11-07"},{"$f":"$B262+3","v":"2018-11-08"},{"$f":"$B262+4","v":"2018-11-09"},{"$f":"$B262+5","v":"2018-11-10"},{"$f":"$B262+6","v":"2018-11-11"}]
["ICU","WRA","MAK","LDP","LDP","RCG","WRA","WRA"]
["AGB","CJM","DBC","GBH","JGE","MFS","DBC","DBC"]
["BHS","JGE",{"$nulls":4},"PRS"]
["BACKUP","MFS","SPF","GAH","HLT","DBC","MFS","MFS"]
["Leave","AJR"]
[{"$f":"A262+1","v":41},{"$f":"CurrentRosterStart+7*(A268+2)","v":"2018-11-12"},{"$f":"$B268+1","v":"2018-11-13"},{"$f":"$B268+2","v":"2018-11-14"},{"$f":"$B268+3","v":"2018-11-15"},{"$f":"$B268+4","v":"2018-11-16"},{"$f":"$B268+5","v":"2018-11-17"},{"$f":"$B268+6","v":"2018-11-18"}]
["ICU","RCG","RCG","WRA","WRA","GBH","GBH","GBH"]
["AGB","DJM","RJR","GAH","JGE","MFS","HLT","HLT"]
["BHS","RAC"]
["BACKUP","AJR","DRP","DBC","RJR","AJR","DJM","DJM"]
["Leave"]
[{"$f":"A268+1","v":42},{"$f":"CurrentRosterStart+7*(A274+2)","v":"2018-11-19"},{"$f":"$B274+1","v":"2018-11-20"},{"$f":"$B274+2","v":"2018-11-21"},{"$f":"$B274+3","v":"2018-11-22"},{"$f":"$B274+4","v":"2018-11-23"},{"$f":"$B274+5","v":"2018-11-24"},{"$f":"$B274+6","v":"2018-11-25"}]
["ICU","RJR","RJR","DBC","DBC","WS","WS","WS"]
["AGB","JGE","PJC","CJM","REC","RJR","RJR","RJR"]
["BHS","CJM"]
["BACKUP","DJM","MBW","GBH","LDP","HLT","HLT","HLT"]
["Leave"]
[{"$f":"A274+1","v":43},{"$f":"CurrentRosterStart+7*(A280+2)","v":"2018-11-26"},{"$f":"$B280+1","v":"2018-11-27"},{"$f":"$B280+2","v":"2018-11-28"},{"$f":"$B280+3","v":"2018-11-29"},{"$f":"$B280+4","v":"2018-11-30"},{"$f":"$B280+5","v":"2018-12-01"},{"$f":"$B280+6","v":"2018-12-02"}]
["ICU","RCG","RCG","WRA","WRA","RJR","RJR","RJR"]
["AGB","MFS","SPF","DBC","GBH","REC","RAC","RAC"]
["BHS"]
["BACKUP","AJR","RJR","REC","PRS","DBC","DBC","DBC"]
["Leave","GAH"]
[{"$f":"A280+1","v":44},{"$f":"CurrentRosterStart+7*(A286+2)","v":"2018-12-03"},{"$f":"$B286+1","v":"2018-12-04"},{"$f":"$B286+2","v":"2018-12-05"},{"$f":"$B286+3","v":"2018-12-06"},{"$f":"$B286+4","v":"2018-12-07"},{"$f":"$B286+5","v":"2018-12-08"},{"$f":"$B286+6","v":"2018-12-09"}]
["ICU","WRA","WRA","RJR","RJR","LDP","LDP","LDP"]
["AGB","DJM","AJR","PJC","MFS","PRS","PRS","PRS"]
["BHS"]
["BACKUP","HLT","MFS","REC","RAC","SPF","SPF","SPF"]
["Leave","DBC GAH"]
[{"$f":"A286+1","v":45},{"$f":"CurrentRosterStart+7*(A292+2)","v":"2018-12-10"},{"$f":"$B292+1","v":"2018-12-11"},{"$f":"$B292+2","v":"2018-12-12"},{"$f":"$B292+3","v":"2018-12-13"},{"$f":"$B292+4","v":"2018-12-14"},{"$f":"$B292+5","v":"2018-12-15"},{"$f":"$B292+6","v":"2018-12-16"}]
["ICU","RCG","RCG","WRA","WRA","LDP","RCG","RCG"]
["AGB","RJR","PRS","LDP","MFS","RJR","SPF","SPF"]
["BHS","MFS","JGE",{"$nulls":4},"CJM"]
["BACKUP","DBC","CJM","JGE","SPF","RAC","RAC","RAC"]
["Leave","GAH"]
[{"$f":"A292+1","v":46},{"$f":"CurrentRosterStart+7*(A298+2)","v":"2018-12-17"},{"$f":"$B298+1","v":"2018-12-18"},{"$f":"$B298+2","v":"2018-12-19"},{"$f":"$B298+3","v":"2018-12-20"},{"$f":"$B298+4","v":"2018-12-21"},{"$f":"$B298+5","v":"2018-12-22"},{"$f":"$B298+6","v":"2018-12-23"}]
["ICU","MAK","MAK","RJR","RJR","RCG","LDP","LDP"]
["AGB","JGE","SPF","LDP","CJM","AJR","HLT","HLT"]
["BHS"]
["BACKUP","PJC","AJR","DJM","GAH","JGE","JGE","MFS"]
["Leave","GAH"]
[{"$f":"A298+1","v":47},{"$f":"CurrentRosterStart+7*(A304+2)","v":"2018-12-24"},{"$f":"$B304+1","v":"2018-12-25"},{"$f":"$B304+2","v":"2018-12-26"},{"$f":"$B304+3","v":"2018-12-27"},{"$f":"$B304+4","v":"2018-12-28"},{"$f":"$B304+5","v":"2018-12-29"},{"$f":"$B304+6","v":"2018-12-30"}]
["ICU","RJR","RJR","LDP","LDP","RJR","RJR","RJR"]
["AGB","DJM","JGE","AJR","DBC","CJM","CJM","CJM"]
["BHS",null,null,"REC","JGE","DJM"]
["BACKUP","DRP","DBC","MBW","MFS","PJC","PJC","PJC"]
["Leave","RAC SPF"]
[{"$f":"A304+1","v":48},{"$f":"CurrentRosterStart+7*(A310+2)","v":"2018-12-31"},{"$f":"$B310+1","v":"2019-01-01"},{"$f":"$B310+2","v":"2019-01-02"},{"$f":"$B310+3","v":"2019-01-03"},{"$f":"$B310+4","v":"2019-01-04"},{"$f":"$B310+5","v":"2019-01-05"},{"$f":"$B310+6","v":"2019-01-06"}]
["ICU","MAK","MAK","AJR","AJR","RCG","WRA","WRA"]
["AGB","HLT","REC","RJR","PJC","GAH","LDP","LDP"]
["BHS",null,"MFS"]
["BACKUP","AJR","PRS","HLT","LDP","CJM","CJM","CJM"]
["Leave","RAC JGE SPF"]
[{"$f":"A310+1","v":49},{"$f":"CurrentRosterStart+7*(A316+2)","v":"2019-01-07"},{"$f":"$B316+1","v":"2019-01-08"},{"$f":"$B316+2","v":"2019-01-09"},{"$f":"$B316+3","v":"2019-01-10"},{"$f":"$B316+4","v":"2019-01-11"},{"$f":"$B316+5","v":"2019-01-12"},{"$f":"$B316+6","v":"2019-01-13"}]
["ICU","RCG","RCG","WRA","WRA","RJR","RJR","RJR",1]
["AGB","REC","GAH","MFS","DJM","LDP","PJC","PJC"]
["BHS",{"$nulls":6},"RAC"]
["BACKUP","RJR","PJC","RAC","GAH","RAC","LDP","LDP"]
["Leave","JGE SPF"]
[{"$f":"A316+1","v":50},{"$f":"CurrentRosterStart+7*(A322+2)","v":"2019-01-14"},{"$f":"$B322+1","v":"2019-01-15"},{"$f":"$B322+2","v":"2019-01-16"},{"$f":"$B322+3","v":"2019-01-17"},{"$f":"$B322+4","v":"2019-01-18"},{"$f":"$B322+5","v":"2019-01-19"},{"$f":"$B322+6","v":"2019-01-20"}]
["ICU","MAK","MAK","WRA","WRA","MAK","MAK","MAK"]
["AGB","GBH","RJR","DBC","PRS","RJR","RJR","RJR"]
["BHS","DJM",null,null,"CJM",null,"PJC"]
["BACKUP","JGE","DJM","CJM","PJC","LDP","RAC","RAC"]
["Leave","SPF"]
[{"$f":"A322+1","v":51},{"$f":"CurrentRosterStart+7*(A328+2)","v":"2019-01-21"},{"$f":"$B328+1","v":"2019-01-22"},{"$f":"$B328+2","v":"2019-01-23"},{"$f":"$B328+3","v":"2019-01-24"},{"$f":"$B328+4","v":"2019-01-25"},{"$f":"$B328+5","v":"2019-01-26"},{"$f":"$B328+6","v":"2019-01-27"}]
["ICU","RCG","RCG","LDP","LDP","WRA","WRA","WRA"]
["AGB","GAH","HLT","RAC","AJR","RJR","PJC","PJC"]
["BHS"]
["BACKUP","PRS","SPF","GBH","DRP","GAH","GAH","GAH"]
["Leave","DBC"]
[{"$f":"A328+1","v":52},{"$f":"CurrentRosterStart+7*(A334+2)","v":"2019-01-28"},{"$f":"$B334+1","v":"2019-01-29"},{"$f":"$B334+2","v":"2019-01-30"},{"$f":"$B334+3","v":"2019-01-31"},{"$f":"$B334+4","v":"2019-02-01"},{"$f":"$B334+5","v":"2019-02-02"},{"$f":"$B334+6","v":"2019-02-03"}]
["ICU","MAK","MAK","WRA","WRA"]
["AGB","GBH","DBC","MFS","SPF"]
["BHS"]
["BACKUP","MBW","HLT","LDP","RJR"]
["Leave"]
[56,{"$f":"$B$10+7*(A340-1)","v":"2019-02-04"},{"$f":"$B340+1","v":"2019-02-05"},{"$f":"$B340+2","v":"2019-02-06"},{"$f":"$B340+3","v":"2019-02-07"},{"$f":"$B340+4","v":"2019-02-08"},{"$f":"$B340+5","v":"2019-02-09"},{"$f":"$B340+6","v":"2019-02-10"}]
["ICU"]
["AGB"]
["BHS"]
["BACKUP"]
["Leave"]

{"sheet":"ICUextraDays","index":4,"n_rows":60,"n_cols":12,"rows_kept":60,"merged":[[0,0,0,11],[2,1,2,2],[2,3,2,4],[2,6,3,11],[18,1,18,2],[18,3,18,4],[26,1,26,4],[28,1,28,2],[28,3,28,4],[28,7,28,11],[43,1,43,4],[45,1,45,2],[45,3,45,4],[45,7,45,11]]}
[{"$f":"CurrentYear","v":2018}]
[]
[null,"WEEKDAY SHIFTS",null,"WEEKEND SHIFTS",null,null,"WEEKDAY SHIFTS EXPECTED TO DO AS LEAVE COVER FOR ADS/RCG"]
[null,"BUDGETED","ALLOCATED","BUDGETED","ALLOCATED"]
[{"$f":"Worksheet!K18","v":"RCG"},20,{"$f":"Worksheet!P18/2","v":8.5},5,{"$f":"Worksheet!R18","v":5},null,{"$f":"C5-B5","v":-11.5}]
[{"$f":"Worksheet!K19","v":"DBC"},9,{"$f":"Worksheet!P19/2","v":3.5},5,{"$f":"Worksheet!R19","v":5},null,{"$f":"C6-B6","v":-5.5}]
[{"$f":"Worksheet!K20","v":"GBH"},9,{"$f":"Worksheet!P20/2","v":0},5,{"$f":"Worksheet!R20","v":5},null,-9]
[{"$f":"Worksheet!K21","v":"WRA"},29,{"$f":"Worksheet!P21/2","v":12.5},10,{"$f":"Worksheet!R21","v":6},null,-16.5]
[{"$f":"Worksheet!K22","v":"LDP"},10,{"$f":"Worksheet!P22/2","v":4},5,{"$f":"Worksheet!R22","v":6},null,-6]
[{"$f":"Worksheet!K23","v":"RJR"},8,{"$f":"Worksheet!P23/2","v":4},5,{"$f":"Worksheet!R23","v":5},null,-4]
[{"$f":"Worksheet!K24","v":"AJR"},19,{"$f":"Worksheet!P24/2","v":8.5},5,{"$f":"Worksheet!R24","v":5},null,-10.5]
[{"$f":"Worksheet!K25","v":"DK"},0,{"$f":"Worksheet!P25/2","v":0},5,{"$f":"Worksheet!R25","v":4},null,0]
[{"$f":"Worksheet!K26","v":"WS"},0,{"$f":"Worksheet!P26/2","v":0},6,{"$f":"Worksheet!R26","v":6},null,0]
[{"$f":"Worksheet!K27","v":"MAK"},0,{"$f":"Worksheet!P27/2","v":11.25},null,{"$f":"Worksheet!R27","v":5}]
[{"$f":"Worksheet!K28","v":"LOC"},11,{"$f":"Worksheet!P28/2","v":0},5,{"$f":"Worksheet!R28","v":0}]
[{"$f":"Worksheet!K29","v":"BHS"},null,{"$f":"Worksheet!P29/2","v":0},null,{"$f":"Worksheet!R29","v":0}]
[]
["TOTAL",{"$f":"SUM(B5:B15)","v":115},{"$f":"SUM(C5:C15)","v":52.25},{"$f":"SUM(D5:D15)","v":56},{"$f":"SUM(E5:E13)","v":47}]
[null,104,null,52]
[]
["nb 54 WEEK YEAR TO ADJUST TO FEB 1 START"]
[]
[]
[]
[]
["PLANNING"]
[null,{"$f":"CurrentYear-1","v":2017}]
[]
[null,"WEEKDAY SHIFTS",null,"WEEKEND SHIFTS",{"$nulls":3},"HOURS/WEEK"]
[null,"BUDGETED","ALLOCATED","BUDGETED","ALLOCATED",null,null,"TOTAL",null,"CLIN",null,"NONCLIN"]
[{"$f":"Worksheet!K18","v":"RCG"}]
[{"$f":"Worksheet!K19","v":"DBC"}]
[{"$f":"Worksheet!K20","v":"GBH"}]
[{"$f":"Worksheet!K21","v":"WRA"}]
[{"$f":"Worksheet!K22","v":"LDP"}]
[{"$f":"Worksheet!K23","v":"RJR"}]
[{"$f":"Worksheet!K24","v":"AJR"}]
[{"$f":"Worksheet!K25","v":"DK"}]
[{"$f":"Worksheet!K26","v":"WS"}]
[{"$f":"Worksheet!K27","v":"MAK"}]
[{"$f":"Worksheet!K28","v":"LOC"}]
[{"$f":"Worksheet!K29","v":"BHS"}]
[]
[null,{"$f":"CurrentYear","v":2018}]
[]
[null,"WEEKDAY SHIFTS",null,"WEEKEND SHIFTS",{"$nulls":3},"HOURS/WEEK"]
[null,"BUDGETED","ALLOCATED","BUDGETED","ALLOCATED",null,null,"TOTAL",null,"CLIN",null,"NONCLIN"]
[{"$f":"Worksheet!K18","v":"RCG"},17,null,5]
[{"$f":"Worksheet!K19","v":"DBC"},8,null,5]
[{"$f":"Worksheet!K20","v":"GBH"},0,null,5]
[{"$f":"Worksheet!K21","v":"WRA"},31,null,6]
[{"$f":"Worksheet!K22","v":"LDP"},8,null,5]
[{"$f":"Worksheet!K23","v":"RJR"},8,null,5]
[{"$f":"Worksheet!K24","v":"AJR"},10,null,5]
[{"$f":"Worksheet!K25","v":"DK"},null,null,5]
[{"$f":"Worksheet!K26","v":"WS"},null,null,5]
[{"$f":"Worksheet!K27","v":"MAK"},22,null,6]
[{"$f":"Worksheet!K28","v":"LOC"},null,null,0]
[{"$f":"Worksheet!K29","v":"BHS"}]
["TOTAL",{"$f":"SUM(B48:B59)","v":104},null,{"$f":"SUM(D48:D59)","v":52}]

{"sheet":"PubHol","index":5,"n_rows":46,"n_cols":44,"rows_kept":46,"merged":[[2,1,2,6],[2,7,2,10],[2,12,2,36],[19,4,19,6]]}
["PUBLIC HOLIDAYS WORKED"]
[]
[null,"EASTER",{"$nulls":5},"CHRISTMAS",{"$nulls":4},"TOTAL PUBLIC HOLIDAYS (incl associated weekends from 2009)"]
[null,"ICU-F/S/S","ICU-M","AGB-F","AGB-S","AGB-Su","AGB-M","ICU-25","ICU-26","AGB-25","AGB-26",null,"RDA","DBC","PJC","GLTC","RAC","REC","JGE","SPF","RCG","GBH","GAH","DJM","CJM","LDP","RJR","AJR","MFS","PRS","NMS","ADS","HLT","PNT","MVT","WRA",{"$nulls":4},"MLB","CVDH","MBW","DRP"]
[2005,"MVT","ADS","RDA","DRP","DRP","DBC","MVT","RCG","MFS","DBC",null,1,4,null,3,{"$nulls":4},3,3,1,null,null,1,0,null,4,null,1,4,null,4,5,{"$nulls":7},0,3]
[2006,"RJR","RCG","MBW","PNT","PNT","MBW","CJM","CJM","DBC","LDP",null,null,1,{"$nulls":6},2,1,1,null,2,3,4,null,1,null,3,4,null,5,0,{"$nulls":7},3,1]
[2007,"CJM","ADS","MFS","GAH","GAH","LDP","RCG","DBC","GBH","LDP",null,null,1,{"$nulls":6},2,2,3,null,3,2,1,2,2,null,0,3,null,1,1,{"$nulls":7},0,1]
[2008,"CJM","ADS","DJM","AJR","AJR","NMS","RJR","RCG","NMS","DRP",null,null,2,{"$nulls":6},2,0,2,1,4,1,1,5,1,null,2,2,2,2,2,{"$nulls":7},2,2]
[2009,"AJR","RCG","NMS","HLT","HLT","CJM","LDP","LDP","MFS","DJM",null,null,1,{"$nulls":6},2,3,2,6,4,3,3,8,2,null,2,3,4,2,1,{"$nulls":7},1,1]
[2010,"DBC","ADS","DJM","GBH","GBH","RAC","AJR","AJR","GAH","GAH",null,null,3,null,null,1,{"$nulls":3},2,2,3,3,0,3,0,6,2,null,null,6,3,{"$nulls":9},2,3]
[2011,"AJR","RCG","MFS","RAC","RAC","DRP","DBC","ADS","MBW","GBH",null,null,3,null,null,2,{"$nulls":3},5,2,3,4,0,3,2,9,3,null,null,2,4,{"$nulls":9},2,1]
[2012,"LDP","RCG","HLT","HLT","HLT","HLT","ADS","RJR","RAC","GBH",null,null,2,null,null,1,{"$nulls":3},2,3,2,2,3,6,3,1,1,null,null,1,4,{"$nulls":8},1,1,1]
[2013,"CJM","AWC","RJR","RJR","HLT","HLT","DBC","DBC","DRP","GAH",null,null,3,null,null,1,{"$nulls":3},1,2,1,2,3,1,2,1,2,0,null,2,3,{"$nulls":7},0,2,1,1]
[2014,"ADS","DBC","MLB","MLB","MBW","MBW","LDP","RJR","MFS","HLT",null,null,2,null,null,2,null,null,1,3,0,1,0,0,0,5,4,2,0,null,3,3,{"$nulls":7},3,1,2,1]
[2015,"DBC","RCG","SPF","SPF","GAH","GAH","CJM","CJM","DJM","HLT",null,null,7,null,null,1,null,2,4,4,3,4,1,3,2,4,3,2,3,null,1,3,{"$nulls":7},1,0,1,2]
[2016,"RCG","LDP","DRP","DRP","RAC","RAC","GBH","RCG","MLB","LDP",null,null,0,null,null,3,null,0,3,7,2,4,3,3,7,4,3,2,5,null,0,2,{"$nulls":7},2,1,1,2]
[2017,"GBH","RCG","DBC","DBC","JGE","JGE","RCG","RCG","HLT","MFS",null,null,7,null,null,3,null,4,2,4,3,2,1,3,2,3,4,2,5,null,null,2,null,null,2]
[2018]
[2019]
[{"$nulls":4},"PER YEAR ON CALL"]
[null,"StartYear","YearsOnCall",null,"Easter days","Xmas days","2025-12-01"]
[{"$f":"Worksheet!K5","v":"PJC"},{"$f":"HLOOKUP(A22,$N$4:$AQ$26,23,FALSE)","v":2018},{"$f":"CurrentYear-B22","v":0},null,{"$f":"COUNTIF($B$5:$G$19,A22)/C22","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF($H$5:$K$19,A22)/C22","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIF($H$5:$H$19,A22)+COUNTIF($J$5:$J$19,A22))/C22","v":{"$error":"#DIV/0!"}},{"$nulls":4},"AVG(nonICU)",null,{"$f":"IF(N25=\"Y\",\"NA\",AVERAGE(N5:N19))","v":"NA"},null,{"$f":"IF(P25=\"Y\",\"NA\",AVERAGE(P5:P19))","v":{"v":3,"d":"3.0"}},{"v":1.75,"d":"1.8"},null,{"v":2,"d":"2.0"},2.5,"NA","NA",{"v":2.230769230769231,"d":"2.2"},2.3,"NA","NA","NA","NA",{"v":2,"d":"2.0"},2.6,1.6,"NA",{"v":3,"d":"3.0"},{"$f":"IF(AH25=\"Y\",\"NA\",AVERAGE(AH5:AH19))","v":2.8},{"$f":"IF(AI25=\"Y\",\"NA\",AVERAGE(AI5:AI19))","v":1.8},{"$f":"IF(AJ25=\"Y\",\"NA\",AVERAGE(AJ5:AJ19))","v":"NA"},null,null,{"$f":"AVERAGE(N22:AJ22)","v":{"v":2.2983974358974364,"d":"2.3"}},null,{"$f":"IF(AO25=\"Y\",\"NA\",AVERAGE(AO5:AO19))","v":1.5},{"$f":"IF(AP25=\"Y\",\"NA\",AVERAGE(AP5:AP19))","v":{"v":1,"d":"1.0"}},{"$f":"IF(AQ25=\"Y\",\"NA\",AVERAGE(AQ5:AQ19))","v":{"v":1.3333333333333333,"d":"1.3"}},{"$f":"IF(AR25=\"Y\",\"NA\",AVERAGE(AR5:AR19))","v":{"v":1.5833333333333333,"d":"1.6"}}]
[{"$f":"Worksheet!K6","v":"RAC"},2010,8,null,{"$f":"COUNTIF($B$5:$G$19,A23)/C23","v":{"v":0.625,"d":"0.6"}},{"$f":"COUNTIF($H$5:$K$19,A23)/C23","v":{"v":0.125,"d":"0.1"}},{"$f":"(COUNTIF($H$5:$H$19,A23)+COUNTIF($J$5:$J$19,A23))/C23","v":{"v":0.125,"d":"0.1"}},{"$nulls":4},"AVG(ICU)",null,{"$f":"IF(N25=\"Y\",AVERAGE(N5:N19),\"NA\")","v":{"v":2.769230769230769,"d":"2.8"}},null,null,{"$f":"IF(Q25=\"Y\",AVERAGE(Q5:Q19),\"NA\")","v":"NA"},{"$nulls":3},{"v":3,"d":"3.0"},{"v":2,"d":"2.0"},"NA","NA",{"v":2.3333333333333335,"d":"2.3"},{"v":2.6153846153846154,"d":"2.6"},{"v":2.4615384615384617,"d":"2.5"},{"v":4.181818181818182,"d":"4.2"},"NA","NA",null,{"v":2.5833333333333335,"d":"2.6"},"NA",{"$f":"IF(AH25=\"Y\",AVERAGE(AH5:AH19),\"NA\")","v":"NA"},{"$f":"IF(AI25=\"Y\",AVERAGE(AI5:AI19),\"NA\")","v":"NA"},{"$f":"IF(AJ25=\"Y\",AVERAGE(AJ5:AJ19),\"NA\")","v":{"v":2,"d":"2.0"}},null,null,{"$f":"AVERAGE(N23:AJ23)","v":{"v":2.6605154105154103,"d":"2.7"}},null,null,{"$f":"IF(AP25=\"Y\",AVERAGE(AP5:AP19),\"NA\")","v":"NA"},{"$f":"IF(AQ25=\"Y\",AVERAGE(AQ5:AQ19),\"NA\")","v":"NA"},{"$f":"IF(AR25=\"Y\",AVERAGE(AR5:AR19),\"NA\")","v":"NA"}]
[{"$f":"Worksheet!K7","v":"REC"},2018,0,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"Worksheet!K8","v":"JGE"},2015,3,null,{"v":0.6666666666666666,"d":"0.7"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"$nulls":4},"ICU",null,"Y",null,null,"N",null,"N","N","Y","Y","N","N","Y","Y","Y","Y","N","N",null,"Y","N",null,null,"Y",{"$nulls":5},"N","N","N"]
[{"$f":"Worksheet!K9","v":"SPF"},2014,4,null,0.5,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"$nulls":4},"START YEAR",null,2005,2018,null,2010,2018,2015,2014,2005,2005,2005,2008,2005,2005,2005,2007,2005,2013,null,2005,2008,null,null,2017,{"$nulls":4},2013,2012,2005,2005]
[{"$f":"Worksheet!K10","v":"GAH"},2005,13,null,{"v":0.3076923076923077,"d":"0.3"},{"v":0.23076923076923078,"d":"0.2"},{"v":0.07692307692307693,"d":"0.1"}]
[{"$f":"Worksheet!K11","v":"DJM"},2008,10,null,0.2,0.2,0.1]
[{"$f":"Worksheet!K12","v":"CJM"},2005,13,null,{"v":0.3076923076923077,"d":"0.3"},{"v":0.3076923076923077,"d":"0.3"},{"v":0.15384615384615385,"d":"0.2"}]
[{"$f":"Worksheet!K13","v":"MFS"},2005,13,null,{"v":0.15384615384615385,"d":"0.2"},{"v":0.3076923076923077,"d":"0.3"},{"v":0.23076923076923078,"d":"0.2"}]
[{"$f":"Worksheet!K14","v":"PRS"},2013,5,null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[{"$f":"Worksheet!K15","v":"HLT"},2008,10,null,0.8,0.3,0.1]
[{"$f":"Worksheet!K16","v":"DRP"}]
[{"$f":"Worksheet!K17","v":"MBW"}]
[{"$f":"Worksheet!K18","v":"RCG"},{"$f":"HLOOKUP(A35,$N$4:$AQ$26,23,FALSE)","v":2005},13,null,{"v":0.5384615384615384,"d":"0.5"},{"v":0.46153846153846156,"d":"0.5"},{"v":0.15384615384615385,"d":"0.2"}]
[{"$f":"Worksheet!K19","v":"DBC"},2005,13,null,{"v":0.46153846153846156,"d":"0.5"},{"v":0.46153846153846156,"d":"0.5"},{"v":0.23076923076923078,"d":"0.2"}]
[{"$f":"Worksheet!K20","v":"GBH"},2005,13,null,{"v":0.23076923076923078,"d":"0.2"},{"v":0.3076923076923077,"d":"0.3"},{"v":0.15384615384615385,"d":"0.2"}]
[{"$f":"Worksheet!K21","v":"WRA"},2017,1,null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[{"$f":"Worksheet!K22","v":"LDP"},2005,13,null,{"v":0.23076923076923078,"d":"0.2"},{"v":0.46153846153846156,"d":"0.5"},{"v":0.15384615384615385,"d":"0.2"}]
[{"$f":"Worksheet!K23","v":"RJR"},2005,13,null,{"v":0.23076923076923078,"d":"0.2"},{"v":0.23076923076923078,"d":"0.2"},{"v":0.07692307692307693,"d":"0.1"}]
[{"$f":"Worksheet!K24","v":"AJR"},2007,11,null,{"v":0.36363636363636365,"d":"0.4"},{"v":0.18181818181818182,"d":"0.2"},{"v":0.09090909090909091,"d":"0.1"}]
[{"$f":"Worksheet!K25","v":"DK"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Worksheet!K26","v":"WS"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Worksheet!K27","v":"MAK"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Worksheet!K28","v":"LOC"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Worksheet!K29","v":"BHS"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"Backup","index":6,"n_rows":23,"n_cols":14,"rows_kept":23,"hidden":true}
["BACKUP ROSTER PLANNER"]
["Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10","Column11","Column12","Column13","Column14"]
[null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","JAN"]
[{"$f":"Worksheet!K5","v":"PJC"}]
[{"$f":"Worksheet!K6","v":"RAC"}]
[{"$f":"Worksheet!K8","v":"JGE"}]
[{"$f":"Worksheet!K9","v":"SPF"}]
[{"$f":"Worksheet!K10","v":"GAH"}]
[{"$f":"Worksheet!K11","v":"DJM"}]
[{"$f":"Worksheet!K12","v":"CJM"}]
[{"$f":"Worksheet!K13","v":"MFS"}]
[{"$f":"Worksheet!K14","v":"PRS"}]
[{"$f":"Worksheet!K15","v":"HLT"}]
[{"$f":"Worksheet!K16","v":"DRP"}]
[{"$f":"Worksheet!K17","v":"MBW"}]
[{"$f":"Worksheet!K18","v":"RCG"}]
[{"$f":"Worksheet!K19","v":"DBC"}]
[{"$f":"Worksheet!K20","v":"GBH"}]
[{"$f":"Worksheet!K21","v":"WRA"}]
[{"$f":"Worksheet!K22","v":"LDP"}]
[{"$f":"Worksheet!K23","v":"RJR"}]
[{"$f":"Worksheet!K24","v":"AJR"}]
[{"$f":"Worksheet!K25","v":"DK"}]

{"sheet":"Requests","index":7,"n_rows":26,"n_cols":7,"rows_kept":26}
[{"$f":"CurrentYear","v":2018},"Requests and planning"]
[]
[]
[null,"BHS","ICU","AGB","NOT ONCALLS","LEAVE","PUBHOL"]
[{"$f":"Worksheet!L40","v":"Christie"}]
[{"$f":"Worksheet!L41","v":"Commons"}]
[{"$f":"Worksheet!L42","v":"Connell"}]
[{"$f":"Worksheet!L43","v":"Cowell"}]
[{"$f":"Worksheet!L44","v":"Evans"}]
[{"$f":"Worksheet!L45","v":"Frost"}]
[{"$f":"Worksheet!L46","v":"Gazzard"}]
[{"$f":"Worksheet!L47","v":"Henderson"}]
[{"$f":"Worksheet!L48","v":"Hughes"}]
[{"$f":"Worksheet!L49","v":"McIntyre"}]
[{"$f":"Worksheet!L50","v":"Mitchell"}]
[{"$f":"Worksheet!L51","v":"Paxton"}]
[{"$f":"Worksheet!L52","v":"Phillips"}]
[{"$f":"Worksheet!L53","v":"Ray"}]
[{"$f":"Worksheet!L54","v":"Richardson"}]
[{"$f":"Worksheet!L55","v":"Shaw"}]
[{"$f":"Worksheet!L56","v":"Shea"}]
[{"$f":"Worksheet!L57","v":"Tan"}]
[{"$f":"Worksheet!L59","v":"BHS"}]
[{"$f":"Worksheet!L60","v":"Ainslie"}]
[{"$f":"Worksheet!L61","v":"Sylvester"}]
[{"$f":"Worksheet!L62","v":"Dharshi"}]

{"sheet":"Generator","index":8,"n_rows":428,"n_cols":36,"rows_kept":428,"hidden":true,"merged":[[1,32,3,32],[1,33,3,33],[1,35,3,35],[2,3,2,4],[2,5,2,6],[3,9,3,10],[3,11,3,12],[3,13,3,14],[3,15,3,16],[3,17,3,18],[3,19,3,20]]}
["PARTNERS SHARING AGB ROSTER"]
[{"$nulls":32},"Avg number of each night","Avg number of all M-F",null,"avg of each night by EFT"]
[null,"SEQUENCE",null,"All days",{"$nulls":5},"RANDOMISED LISTS FOR SEQUENCING",{"$nulls":13},1,2,3,4,5,6,7]
[null," POSITION",null,"total","off mean",null,null,"3day w/e","FRACTION","SAT",null,"M_Th",{"$nulls":11},"Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon-Thu"]
[null,1,"DBC",{"$f":"COUNTIF(OnCallList,C5)","v":23},{"$f":"D5-$D$26","v":0.125},{"$nulls":3},1,11,{"$f":"VLOOKUP(J5,PartnerLookup,2)","v":"LDP"},12,{"$f":"VLOOKUP(L5,PartnerLookup,2)","v":"RJR"},{"$nulls":9},{"$f":"C5","v":"DBC"},{"$f":"COUNTIF(X$37:X$402,$C5)","v":3},3,5,3,3,3,3,{"$f":"SUM(X5:AA5)","v":14},null,{"$f":"52/$W$26*$I5","v":{"v":3.3548387096774195,"d":"3.4"}},{"$f":"(5*52)/$W$26*$I5","v":{"v":16.774193548387096,"d":"16.8"}},null,{"$f":"$W$27*I5","v":{"v":3.3548387096774195,"d":"3.4"}}]
[null,2,"PJC",25,2.125,{"$nulls":3},1,13,"AJR",7,"GBH",{"$nulls":9},"PJC",3,4,4,3,3,4,4,{"$f":"SUM(X6:AA6)","v":14},null,{"$f":"52/$W$26*I6","v":{"v":3.3548387096774195,"d":"3.4"}},{"$f":"(5*52)/$W$26*$I6","v":{"v":16.774193548387096,"d":"16.8"}},null,{"$f":"$W$27*I6","v":{"v":3.3548387096774195,"d":"3.4"}}]
[null,3,"RAC",23,0.125,{"$nulls":3},1,9,"DJM",1,"DBC",{"$nulls":9},"RAC",4,5,2,3,3,3,3,14,null,{"v":3.3548387096774195,"d":"3.4"},{"v":16.774193548387096,"d":"16.8"},null,{"v":3.3548387096774195,"d":"3.4"}]
[null,4,"REC",19,-3.875,{"$nulls":3},0.75,2,"PJC",14,"MFS",{"$nulls":9},"REC",3,2,2,3,3,3,3,10,null,{"v":2.5161290322580645,"d":"2.5"},{"v":12.580645161290322,"d":"12.6"},null,{"v":2.5161290322580645,"d":"2.5"}]
[null,5,"JGE",23,0.125,{"$nulls":3},1,7,"GBH",13,"AJR",{"$nulls":9},"JGE",4,4,3,3,3,3,3,14,null,{"v":3.3548387096774195,"d":"3.4"},{"v":16.774193548387096,"d":"16.8"},null,{"v":3.3548387096774195,"d":"3.4"}]
[null,6,"SPF",23,0.125,{"$nulls":3},1,8,"GAH",8,"GAH",{"$nulls":9},"SPF",2,5,4,3,3,3,3,14,null,{"v":3.3548387096774195,"d":"3.4"},{"v":16.774193548387096,"d":"16.8"},null,{"v":3.3548387096774195,"d":"3.4"}]
[null,7,"GBH",19,-3.875,null,null,"Y",0.75,4,"REC",9,"DJM",{"$nulls":9},"GBH",3,1,2,4,3,3,3,10,null,{"v":2.5161290322580645,"d":"2.5"},{"v":12.580645161290322,"d":"12.6"},null,{"v":2.5161290322580645,"d":"2.5"}]
[null,8,"GAH",24,1.125,{"$nulls":3},1,5,"JGE",5,"JGE",{"$nulls":9},"GAH",2,3,5,4,4,3,3,14,null,{"v":3.3548387096774195,"d":"3.4"},{"v":16.774193548387096,"d":"16.8"},null,{"v":3.3548387096774195,"d":"3.4"}]
[null,9,"DJM",23,0.125,{"$nulls":3},1,6,"SPF",6,"SPF",{"$nulls":9},"DJM",8,0,0,4,3,4,4,12,null,{"v":3.3548387096774195,"d":"3.4"},{"v":16.774193548387096,"d":"16.8"},null,{"v":3.3548387096774195,"d":"3.4"}]
[null,10,"CJM",24,1.125,null,null,"Y",1,14,"MFS",2,"PJC",{"$nulls":9},"CJM",2,4,4,4,4,3,3,14,null,{"v":3.3548387096774195,"d":"3.4"},{"v":16.774193548387096,"d":"16.8"},null,{"v":3.3548387096774195,"d":"3.4"}]
[null,11,"LDP",23,0.125,{"$nulls":3},1,15,"PRS",4,"REC",{"$nulls":9},"LDP",{"$f":"COUNTIF(X$37:X$402,$C15)","v":3},2,4,3,3,4,4,12,null,{"v":3.3548387096774195,"d":"3.4"},{"v":16.774193548387096,"d":"16.8"},null,{"v":3.3548387096774195,"d":"3.4"}]
[null,12,"RJR",24,1.125,{"$nulls":3},1,3,"RAC",15,"PRS",{"$nulls":9},"RJR",4,4,3,3,4,3,3,14,null,{"v":3.3548387096774195,"d":"3.4"},{"v":16.774193548387096,"d":"16.8"},null,{"v":3.3548387096774195,"d":"3.4"}]
[null,13,"AJR",23,0.125,null,null,"Y",1,12,"RJR",3,"RAC",{"$nulls":9},"AJR",1,6,3,3,4,3,3,13,null,{"v":3.3548387096774195,"d":"3.4"},{"v":16.774193548387096,"d":"16.8"},null,{"v":3.3548387096774195,"d":"3.4"}]
[null,14,"MFS",23,0.125,{"$nulls":3},1,1,"DBC",11,"LDP",{"$nulls":9},"MFS",3,4,4,3,3,3,3,14,null,{"v":3.3548387096774195,"d":"3.4"},{"v":16.774193548387096,"d":"16.8"},null,{"v":3.3548387096774195,"d":"3.4"}]
[null,15,"PRS",23,0.125,null,null,"Y",1,16,"HLT",10,"CJM",{"$nulls":9},"PRS",4,3,4,3,3,3,3,14,null,{"v":3.3548387096774195,"d":"3.4"},{"v":16.774193548387096,"d":"16.8"},null,{"v":3.3548387096774195,"d":"3.4"}]
[null,16,"HLT",24,1.125,{"$nulls":3},1,10,"CJM",16,"HLT",{"$nulls":9},"HLT",3,2,3,4,4,4,4,12,null,{"v":3.3548387096774195,"d":"3.4"},{"v":16.774193548387096,"d":"16.8"},null,{"v":3.3548387096774195,"d":"3.4"}]
[null,17,null,0,{"$nulls":6},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$nulls":9},0,0,0,0,0,0,0,0,0,null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"}]
[null,18,null,0,{"$nulls":6},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$nulls":9},0,0,0,0,0,0,0,0,0,null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"}]
[null,19,null,0,-22.875,{"$nulls":5},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$nulls":9},0,0,0,0,0,0,0,0,0,null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"}]
[null,20,null,0,-22.875,{"$nulls":5},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$nulls":9},0,0,0,0,0,0,0,0,0,null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"}]
[null,"TOTAL",{"$f":"20-COUNTBLANK(C5:C24)","v":16},{"$f":"SUM(D5:D24)","v":366},{"$nulls":3},{"$f":"20-COUNTBLANK(H5:H24)","v":4},{"$f":"SUM(I5:I24)","v":15.5}]
[null,"AVG",null,{"$f":"D25/C25","v":{"v":22.875,"d":"22.9"}},{"$nulls":18},{"$f":"I25","v":15.5},"Effective number of fullshare partners"]
["This spreadsheet generates a random roster for on-call nights for a new year",{"$nulls":21},{"$f":"52/W26","v":{"v":3.3548387096774195,"d":"3.4"}},"Average number of each night that should be done per EFT"]
["Monday to Saturday oncalls are random although on partner can't work two nights less than 7 days apart"]
[null,"DAY","ON",{"$nulls":19},"DayOfWeek"]
[{"$f":"A31-1","v":"2018-01-25"},{"$f":"A30","v":"2018-01-25"},{"$f":"VLOOKUP(A30,PreYear,2)","v":"GBH"}]
["2018-01-26","2018-01-26","JGE"]
["2018-01-27","2018-01-27","AJR"]
["2018-01-28","2018-01-28","AJR"]
["2018-01-29","2018-01-29","DBC"]
["2018-01-30","2018-01-30","RJR"]
[{"$f":"A37-1","v":"2018-01-31"},"2018-01-31","AJR"]
[{"$f":"DATEVALUE(\"1/2/\"&CurrentYear)","v":"2018-02-01"},{"$f":"A37","v":"2018-02-01"},"GAH",{"$nulls":19},{"$f":"WEEKDAY(A37,2)","v":4},{"$f":"IF($W37=X$3,$C37,\"\")","v":""},{"$f":"IF($W37=Y$3,$C37,\"\")","v":""},"","GAH","","",""]
[{"$f":"A37+1","v":"2018-02-02"},{"$f":"A38","v":"2018-02-02"},"HLT",{"$nulls":19},{"$f":"WEEKDAY(A38,2)","v":5},{"$f":"IF($W38=X$3,$C38,\"\")","v":""},"","","","HLT","",""]
[{"$f":"A38+1","v":"2018-02-03"},"2018-02-03","LDP",{"$nulls":19},6,"","","","","","LDP",""]
["2018-02-04","2018-02-04","LDP",{"$nulls":19},7,"","","","","","","LDP"]
["2018-02-05","2018-02-05","DJM",{"$nulls":19},1,"DJM","","","","","",""]
["2018-02-06","2018-02-06","CJM",{"$nulls":19},2,"","CJM","","","","",""]
["2018-02-07","2018-02-07","RJR",{"$nulls":19},3,"","","RJR","","","",""]
["2018-02-08","2018-02-08","MFS",{"$nulls":19},4,"","","","MFS","","",""]
["2018-02-09","2018-02-09","AJR",{"$nulls":19},5,"","","","","AJR","",""]
["2018-02-10","2018-02-10","AJR",{"$nulls":19},6,"","","","","","AJR",""]
["2018-02-11","2018-02-11","AJR",{"$nulls":19},7,"","","","","","","AJR"]
["2018-02-12","2018-02-12","LDP",{"$nulls":7},"Proximity Score",{"$nulls":3},14,{"$nulls":7},1,"LDP","","","","","",""]
["2018-02-13","2018-02-13","MFS",{"$nulls":7},"Score represents number of proximity conflicts",{"$nulls":11},2,"","MFS","","","","",""]
["2018-02-14","2018-02-14","PRS",{"$nulls":7},"35 or under is a good score",{"$nulls":11},3,"","","PRS","","","",""]
["2018-02-15","2018-02-15","HLT",{"$nulls":19},4,"","","","HLT","","",""]
["2018-02-16","2018-02-16","CJM",{"$nulls":19},5,"","","","","CJM","",""]
["2018-02-17","2018-02-17","DJM",{"$nulls":19},6,"","","","","","DJM",""]
["2018-02-18","2018-02-18","DJM",{"$nulls":19},7,"","","","","","","DJM"]
["2018-02-19","2018-02-19","SPF",null,null,"Do manual correction of proximity errors on this part of output",{"$nulls":16},1,"SPF","","","","","",""]
["2018-02-20","2018-02-20","AJR",null,null,"Repeatedly push Proximity Check until no or acceptable errors",{"$nulls":16},2,"","AJR","","","","",""]
["2018-02-21","2018-02-21","DBC",{"$nulls":19},3,"","","DBC","","","",""]
["2018-02-22","2018-02-22","GBH",null,null,"Warning; checks for 3day weekends but not 75% oncall",{"$nulls":16},4,"","","","GBH","","",""]
["2018-02-23","2018-02-23","GAH",null,null,"Proximity check gap is different for different days",{"$nulls":16},5,"","","","","GAH","",""]
["2018-02-24","2018-02-24","JGE",{"$nulls":19},6,"","","","","","JGE",""]
["2018-02-25","2018-02-25","JGE",{"$nulls":19},7,"","","","","","","JGE"]
["2018-02-26","2018-02-26","HLT",{"$nulls":19},1,"HLT","","","","","",""]
["2018-02-27","2018-02-27","RJR",{"$nulls":19},2,"","RJR","","","","",""]
["2018-02-28","2018-02-28","CJM",{"$nulls":19},3,"","","CJM","","","",""]
["2018-03-01","2018-03-01","SPF",{"$nulls":19},4,"","","","SPF","","",""]
["2018-03-02","2018-03-02","GBH",{"$nulls":19},5,"","","","","GBH","",""]
["2018-03-03","2018-03-03","GBH",{"$nulls":19},6,"","","","","","GBH",""]
["2018-03-04","2018-03-04","GBH",{"$nulls":19},7,"","","","","","","GBH"]
["2018-03-05","2018-03-05","PRS",{"$nulls":19},1,"PRS","","","","","",""]
["2018-03-06","2018-03-06","CJM",{"$nulls":19},2,"","CJM","","","","",""]
["2018-03-07","2018-03-07","AJR",{"$nulls":19},3,"","","AJR","","","",""]
["2018-03-08","2018-03-08","RAC",{"$nulls":19},4,"","","","RAC","","",""]
["2018-03-09","2018-03-09","DBC",{"$nulls":19},5,"","","","","DBC","",""]
["2018-03-10","2018-03-10","GAH",{"$nulls":19},6,"","","","","","GAH",""]
["2018-03-11","2018-03-11","GAH",{"$nulls":19},7,"","","","","","","GAH"]
["2018-03-12","2018-03-12","RJR",{"$nulls":19},1,"RJR","","","","","",""]
["2018-03-13","2018-03-13","SPF",{"$nulls":19},2,"","SPF","","","","",""]
["2018-03-14","2018-03-14","JGE",{"$nulls":19},3,"","","JGE","","","",""]
["2018-03-15","2018-03-15","MFS",{"$nulls":19},4,"","","","MFS","","",""]
["2018-03-16","2018-03-16","PJC",{"$nulls":19},5,"","","","","PJC","",""]
["2018-03-17","2018-03-17","REC",{"$nulls":19},6,"","","","","","REC",""]
["2018-03-18","2018-03-18","REC",{"$nulls":19},7,"","","","","","","REC"]
["2018-03-19","2018-03-19","AJR",{"$nulls":19},1,"AJR","","","","","",""]
["2018-03-20","2018-03-20","RAC",{"$nulls":19},2,"","RAC","","","","",""]
["2018-03-21","2018-03-21","JGE",{"$nulls":19},3,"","","JGE","","","",""]
["2018-03-22","2018-03-22","CJM",{"$nulls":19},4,"","","","CJM","","",""]
["2018-03-23","2018-03-23","RJR",{"$nulls":19},5,"","",{"$f":"IF($W87=Z$3,$C87,\"\")","v":""},"","RJR","",""]
["2018-03-24","2018-03-24","PJC",{"$nulls":19},6,{"$f":"IF($W88=X$3,$C88,\"\")","v":""},"","","","","PJC",""]
["2018-03-25","2018-03-25","PJC",{"$nulls":19},7,"","","","","","","PJC"]
["2018-03-26","2018-03-26","DBC",{"$nulls":19},1,"DBC","","","","","",""]
["2018-03-27","2018-03-27","RAC",{"$nulls":19},2,"","RAC","","","","",""]
["2018-03-28","2018-03-28","LDP",{"$nulls":19},3,"","","LDP","","","",""]
["2018-03-29","2018-03-29","AJR",{"$nulls":19},4,"","","","AJR","","",""]
["2018-03-30","2018-03-30","PRS",{"$nulls":19},5,"","","","","PRS","",""]
["2018-03-31","2018-03-31","SPF",{"$nulls":19},6,"","","","","","SPF",""]
["2018-04-01","2018-04-01","SPF",{"$nulls":19},7,"","","","","","","SPF"]
["2018-04-02","2018-04-02","HLT",{"$nulls":19},1,"HLT","","","","","",""]
["2018-04-03","2018-04-03","REC",{"$nulls":19},2,"","REC","","","","",""]
["2018-04-04","2018-04-04","GAH",{"$nulls":19},3,"","","GAH","","","",""]
["2018-04-05","2018-04-05","DJM",{"$nulls":19},4,"","","","DJM","","",""]
["2018-04-06","2018-04-06","PJC",null,"Y",{"$nulls":17},5,"","","","","PJC","",""]
["2018-04-07",{"$f":"A102","v":"2018-04-07"},"MFS",{"$nulls":19},{"$f":"WEEKDAY(A102,2)","v":6},"","","","","","MFS",""]
[{"$f":"A102+1","v":"2018-04-08"},"2018-04-08","MFS",{"$nulls":19},7,"","","","","","","MFS"]
["2018-04-09","2018-04-09","RAC",{"$nulls":19},1,"RAC","","","","","",""]
["2018-04-10","2018-04-10","SPF",{"$nulls":19},2,"","SPF","","","","",""]
["2018-04-11","2018-04-11","PJC",{"$nulls":19},3,"","","PJC","","","",""]
["2018-04-12","2018-04-12","JGE",{"$nulls":19},4,"","","","JGE","","",""]
["2018-04-13","2018-04-13","PRS",{"$nulls":19},5,"","","","","PRS","",""]
["2018-04-14","2018-04-14","PRS",{"$nulls":19},6,"","","","","","PRS",""]
["2018-04-15","2018-04-15","PRS",{"$nulls":19},7,"","","","","","","PRS"]
["2018-04-16","2018-04-16","REC",{"$nulls":19},1,"REC","","","","","",""]
["2018-04-17","2018-04-17","MFS",{"$nulls":19},2,"","MFS","","","","",""]
["2018-04-18","2018-04-18","DBC",{"$nulls":19},3,"","","DBC","","","",""]
["2018-04-19","2018-04-19","LDP",{"$nulls":19},4,"","","","LDP","","",""]
["2018-04-20","2018-04-20","GAH",{"$nulls":19},5,"","","","","GAH","",""]
["2018-04-21","2018-04-21","RAC",{"$nulls":19},6,"","","","","","RAC",""]
["2018-04-22","2018-04-22","RAC",{"$nulls":19},7,"","","","","","","RAC"]
["2018-04-23","2018-04-23","PRS",{"$nulls":19},1,"PRS","","","","","",""]
["2018-04-24","2018-04-24","PJC",{"$nulls":19},2,"","PJC","","","","",""]
["2018-04-25","2018-04-25","REC",{"$nulls":19},3,"","","REC","","","",""]
["2018-04-26","2018-04-26","RAC",{"$nulls":19},4,"","","","RAC","","",""]
["2018-04-27","2018-04-27","DJM",{"$nulls":19},5,"","","","","DJM","",""]
["2018-04-28","2018-04-28","RJR",{"$nulls":19},6,"","","","","","RJR",""]
["2018-04-29","2018-04-29","RJR",{"$nulls":19},7,"","","","","","","RJR"]
["2018-04-30","2018-04-30","DBC",{"$nulls":19},1,"DBC","","","","","",""]
["2018-05-01","2018-05-01","GAH",{"$nulls":19},2,"","GAH","","","","",""]
["2018-05-02","2018-05-02","LDP",{"$nulls":19},3,"","","LDP","","","",""]
["2018-05-03","2018-05-03","REC",{"$nulls":19},4,"","","","REC","","",""]
["2018-05-04","2018-05-04","SPF",{"$nulls":19},5,"","","","","SPF",{"$f":"IF($W129=AC$3,$C129,\"\")","v":""},""]
["2018-05-05","2018-05-05","DBC",null,"Y",{"$nulls":17},6,"","","","","","DBC",""]
["2018-05-06","2018-05-06","DBC",null,"Y",{"$nulls":17},7,"","","","","","","DBC"]
["2018-05-07","2018-05-07","DJM",{"$nulls":19},1,"DJM","","","","","",""]
["2018-05-08","2018-05-08","JGE",{"$nulls":19},2,"","JGE","","","","",""]
["2018-05-09","2018-05-09","PJC",{"$nulls":19},3,"","","PJC","","","",""]
["2018-05-10","2018-05-10","GAH",{"$nulls":19},4,"","","","GAH","","",""]
["2018-05-11","2018-05-11","RAC",{"$nulls":19},5,"","","","","RAC","",""]
["2018-05-12","2018-05-12","HLT",{"$nulls":19},6,"","","","","","HLT",""]
["2018-05-13","2018-05-13","HLT",{"$nulls":19},7,"","","","","","","HLT"]
["2018-05-14","2018-05-14","PRS",{"$nulls":19},1,"PRS","","","","","",""]
["2018-05-15","2018-05-15","SPF",{"$nulls":19},2,"","SPF","","","","",""]
["2018-05-16","2018-05-16","MFS",{"$nulls":19},3,"","","MFS","","","",""]
["2018-05-17","2018-05-17","LDP",{"$nulls":19},4,"","","","LDP","","",""]
["2018-05-18","2018-05-18","CJM",{"$nulls":19},5,"","","","","CJM","",""]
["2018-05-19","2018-05-19","CJM",{"$nulls":19},6,"","","","","","CJM",""]
["2018-05-20","2018-05-20","CJM",{"$nulls":19},7,"","","","","","","CJM"]
["2018-05-21","2018-05-21","RJR",{"$nulls":19},1,"RJR","","","","","",""]
["2018-05-22","2018-05-22","HLT",{"$nulls":19},2,"","HLT","","","","",""]
["2018-05-23","2018-05-23","DBC",{"$nulls":19},3,"","","DBC","","","",""]
["2018-05-24","2018-05-24","GBH",{"$nulls":19},4,"","","","GBH","","",""]
["2018-05-25","2018-05-25","REC",{"$nulls":19},5,"","","","","REC","",""]
["2018-05-26","2018-05-26","LDP",{"$nulls":19},6,"","","","","","LDP",""]
["2018-05-27","2018-05-27","LDP",{"$nulls":19},7,{"$f":"IF($W152=X$3,$C152,\"\")","v":""},"","","","","","LDP"]
["2018-05-28","2018-05-28","GAH",{"$nulls":19},1,"GAH","","","","","",""]
["2018-05-29","2018-05-29","PJC",{"$nulls":19},2,"","PJC","","","","",""]
["2018-05-30","2018-05-30","CJM",{"$nulls":19},3,"","","CJM","","","",""]
["2018-05-31","2018-05-31","DJM",{"$nulls":19},4,"","","","DJM","","",""]
["2018-06-01","2018-06-01","JGE",{"$nulls":19},5,"","","","","JGE","",""]
["2018-06-02","2018-06-02","HLT",{"$nulls":19},6,"","","","","","HLT",""]
["2018-06-03","2018-06-03","HLT",{"$nulls":19},7,"","","","","","","HLT"]
["2018-06-04","2018-06-04","RAC",{"$nulls":19},1,"RAC","","","","","",""]
["2018-06-05","2018-06-05","PRS",{"$nulls":19},2,"","PRS","","","","",""]
["2018-06-06","2018-06-06","SPF",{"$nulls":19},3,"","","SPF","","","",""]
["2018-06-07","2018-06-07","MFS",{"$nulls":19},4,"","","","MFS","","",""]
["2018-06-08","2018-06-08","DBC",{"$nulls":19},5,"","","","","DBC","",""]
["2018-06-09","2018-06-09","DJM",{"$nulls":19},6,"","","","","","DJM",""]
["2018-06-10",{"$f":"A166","v":"2018-06-10"},"DJM",{"$nulls":19},{"$f":"WEEKDAY(A166,2)","v":7},"","","","","","","DJM"]
[{"$f":"A166+1","v":"2018-06-11"},"2018-06-11","JGE",{"$nulls":19},1,"JGE","","","","","",""]
["2018-06-12","2018-06-12","RJR",{"$nulls":19},2,"","RJR","","","","",""]
["2018-06-13","2018-06-13","HLT",{"$nulls":19},3,"","","HLT","","","",""]
["2018-06-14","2018-06-14","DBC",{"$nulls":19},4,"","","","DBC","","",""]
["2018-06-15","2018-06-15","LDP",{"$nulls":19},5,"","","","","LDP","",""]
["2018-06-16","2018-06-16","PJC",{"$nulls":19},6,"","",{"$f":"IF($W172=Z$3,$C172,\"\")","v":""},"","","PJC",""]
["2018-06-17","2018-06-17","PJC",{"$nulls":19},7,"","","","","","","PJC"]
["2018-06-18","2018-06-18","RJR",{"$nulls":19},1,"RJR","","","","","",""]
["2018-06-19","2018-06-19","AJR",{"$nulls":19},2,"","AJR","","","","",""]
["2018-06-20","2018-06-20","GAH",{"$nulls":19},3,"","","GAH","","","",""]
["2018-06-21","2018-06-21","CJM",{"$nulls":19},4,"","","","CJM","","",""]
["2018-06-22","2018-06-22","GBH",{"$nulls":19},5,"","","","","GBH","",""]
["2018-06-23","2018-06-23","GBH",{"$nulls":19},6,"","","","","","GBH",""]
["2018-06-24","2018-06-24","GBH",{"$nulls":19},7,"","","","","","","GBH"]
["2018-06-25","2018-06-25","PJC",{"$nulls":19},1,"PJC","","","","","",""]
["2018-06-26","2018-06-26","RAC",{"$nulls":19},2,"","RAC","","","","",""]
["2018-06-27","2018-06-27","PRS",{"$nulls":19},3,"","","PRS","","","",""]
["2018-06-28","2018-06-28","SPF",{"$nulls":19},4,"","","","SPF","","",""]
["2018-06-29","2018-06-29","MFS",{"$nulls":19},5,"","","","","MFS","",""]
["2018-06-30","2018-06-30","GAH",{"$nulls":19},6,"","","","","","GAH",""]
["2018-07-01","2018-07-01","GAH",{"$nulls":19},7,"","","","","","","GAH"]
["2018-07-02","2018-07-02","CJM",{"$nulls":19},1,"CJM","","","","","",""]
["2018-07-03","2018-07-03","JGE",{"$nulls":19},2,"","JGE","","","","",""]
["2018-07-04","2018-07-04","RJR",{"$nulls":19},3,"","","RJR","","","",""]
["2018-07-05","2018-07-05","HLT",{"$nulls":19},4,"","","","HLT","","",""]
["2018-07-06","2018-07-06","DJM",{"$nulls":19},5,"","","","","DJM","",""]
["2018-07-07","2018-07-07","REC",{"$nulls":19},6,"","","","","","REC",""]
["2018-07-08","2018-07-08","REC",{"$nulls":19},7,"","","","","","","REC"]
["2018-07-09","2018-07-09","LDP",{"$nulls":19},1,"LDP","","","","","",""]
["2018-07-10","2018-07-10","GAH",{"$nulls":19},2,"","GAH","","","","",""]
["2018-07-11","2018-07-11","AJR",{"$nulls":19},3,"","","AJR","","","",""]
["2018-07-12","2018-07-12","PJC",{"$nulls":19},4,"","","","PJC","","",""]
["2018-07-13","2018-07-13","SPF",{"$nulls":19},5,"","","","","SPF","",""]
["2018-07-14","2018-07-14","JGE",{"$nulls":19},6,"","","","","","JGE",""]
["2018-07-15","2018-07-15","JGE",{"$nulls":19},7,"","","","","","","JGE"]
["2018-07-16","2018-07-16","DJM",{"$nulls":19},1,"DJM","","","","","",""]
["2018-07-17","2018-07-17","REC",{"$nulls":19},2,"","REC","","","","",""]
["2018-07-18","2018-07-18","PRS",{"$nulls":19},3,"","","PRS","","","",""]
["2018-07-19","2018-07-19","RAC",{"$nulls":19},4,"","","","RAC","","",""]
["2018-07-20","2018-07-20","JGE",{"$nulls":19},5,"","","","","JGE","",""]
["2018-07-21","2018-07-21","SPF",{"$nulls":19},6,"","","","","","SPF",""]
["2018-07-22","2018-07-22","SPF",{"$nulls":19},7,"","","","","","","SPF"]
["2018-07-23","2018-07-23","MFS",{"$nulls":19},1,"MFS","","","","","",""]
["2018-07-24","2018-07-24","AJR",{"$nulls":19},2,"","AJR","","","","",""]
["2018-07-25","2018-07-25","REC",{"$nulls":19},3,"","","REC","","","",""]
["2018-07-26","2018-07-26","RJR",{"$nulls":19},4,"","","","RJR","","",""]
["2018-07-27","2018-07-27","HLT",{"$nulls":19},5,"","","","","HLT","",""]
["2018-07-28","2018-07-28","MFS",null,"Y",{"$nulls":17},6,"","","","","",{"$f":"IF($W214=AC$3,$C214,\"\")","v":"MFS"},""]
["2018-07-29","2018-07-29","MFS",null,"Y",{"$nulls":17},7,"","","","","","","MFS"]
["2018-07-30","2018-07-30","DBC",{"$nulls":19},1,{"$f":"IF($W216=X$3,$C216,\"\")","v":"DBC"},"","","","","",""]
["2018-07-31","2018-07-31","PRS",null,"Y",{"$nulls":17},2,"","PRS","","","","",""]
["2018-08-01","2018-08-01","JGE",{"$nulls":19},3,"","","JGE","","","",""]
["2018-08-02","2018-08-02","RJR",{"$nulls":19},4,"","","","RJR","","",""]
["2018-08-03","2018-08-03","SPF",{"$nulls":19},5,"","","","","SPF","",""]
["2018-08-04","2018-08-04","PRS",null,"Y",{"$nulls":17},6,"","","","","","PRS",""]
["2018-08-05","2018-08-05","PRS",null,"Y",{"$nulls":17},7,"","","","","","","PRS"]
["2018-08-06","2018-08-06","MFS",{"$nulls":19},1,"MFS","","","","","",""]
["2018-08-07","2018-08-07","CJM",{"$nulls":19},2,"","CJM","","","","",""]
["2018-08-08","2018-08-08","HLT",{"$nulls":19},3,"","","HLT","","","",""]
["2018-08-09","2018-08-09","PJC",{"$nulls":19},4,"","","","PJC","","",""]
["2018-08-10","2018-08-10","LDP",{"$nulls":19},5,"","","","","LDP","",""]
["2018-08-11","2018-08-11","RAC",null,"Y",{"$nulls":17},6,"","","","","","RAC",""]
["2018-08-12","2018-08-12","RAC",null,"Y",{"$nulls":17},7,"","","","","","","RAC"]
["2018-08-13",{"$f":"A230","v":"2018-08-13"},"DJM",{"$nulls":19},{"$f":"WEEKDAY(A230,2)","v":1},"DJM","","","","","",""]
[{"$f":"A230+1","v":"2018-08-14"},"2018-08-14","AJR",{"$nulls":19},2,"","AJR","","","","",""]
["2018-08-15","2018-08-15","GAH",{"$nulls":19},3,"","","GAH","","","",""]
["2018-08-16","2018-08-16","JGE",{"$nulls":19},4,"","","","JGE","","",""]
["2018-08-17","2018-08-17","RAC",null,"Y",{"$nulls":17},5,"","","","","RAC","",""]
["2018-08-18","2018-08-18","RJR",null,"Y",{"$nulls":17},6,"","","","","","RJR",""]
["2018-08-19","2018-08-19","RJR",null,"Y",{"$nulls":17},7,"","","","","","","RJR"]
["2018-08-20","2018-08-20","GBH",{"$nulls":19},1,"GBH","","","","","",""]
["2018-08-21","2018-08-21","DBC",null,"Y",{"$nulls":17},2,"","DBC","","","","",""]
["2018-08-22","2018-08-22","HLT",{"$nulls":19},3,"","","HLT","","","",""]
["2018-08-23","2018-08-23","REC",{"$nulls":19},4,"","","","REC","","",""]
["2018-08-24","2018-08-24","RJR",null,"Y",{"$nulls":17},5,"","","","","RJR","",""]
["2018-08-25","2018-08-25","DBC",null,"Y",{"$nulls":17},6,"","","","","","DBC",""]
["2018-08-26","2018-08-26","DBC",null,"Y",{"$nulls":17},7,"","","","","","","DBC"]
["2018-08-27","2018-08-27","SPF",{"$nulls":19},1,"SPF","","","","","",""]
["2018-08-28","2018-08-28","MFS",{"$nulls":19},2,"","MFS","","","","",""]
["2018-08-29","2018-08-29","CJM",{"$nulls":19},3,"","","CJM","","","",""]
["2018-08-30","2018-08-30","PRS",{"$nulls":19},4,"","","","PRS","","",""]
["2018-08-31","2018-08-31","PJC",{"$nulls":19},5,"","","","","PJC","",""]
["2018-09-01","2018-09-01","HLT",{"$nulls":19},6,"","","","","","HLT",""]
["2018-09-02","2018-09-02","HLT",{"$nulls":19},7,"","","","","","","HLT"]
["2018-09-03","2018-09-03","RAC",{"$nulls":19},1,"RAC","","","","","",""]
["2018-09-04","2018-09-04","GAH",{"$nulls":19},2,"","GAH","","","","",""]
["2018-09-05","2018-09-05","AJR",{"$nulls":19},3,"","","AJR","","","",""]
["2018-09-06","2018-09-06","DJM",{"$nulls":19},4,"","","","DJM","","",""]
["2018-09-07","2018-09-07","JGE",{"$nulls":19},5,"","","","","JGE","",""]
["2018-09-08","2018-09-08","CJM",{"$nulls":19},6,"","","","","","CJM",""]
["2018-09-09","2018-09-09","CJM",{"$nulls":19},7,"","",{"$f":"IF($W257=Z$3,$C257,\"\")","v":""},"","","","CJM"]
["2018-09-10","2018-09-10","LDP",{"$nulls":19},1,"LDP","","","","","",""]
["2018-09-11","2018-09-11","GBH",{"$nulls":19},2,"","GBH","","","","",""]
["2018-09-12","2018-09-12","PJC",{"$nulls":19},3,"","","PJC","","","",""]
["2018-09-13","2018-09-13","HLT",{"$nulls":19},4,"","","","HLT","","",""]
["2018-09-14","2018-09-14","REC",{"$nulls":19},5,"","","","","REC","",""]
["2018-09-15","2018-09-15","LDP",null,"Y",{"$nulls":17},6,"","","","","","LDP",""]
["2018-09-16","2018-09-16","LDP",null,"Y",{"$nulls":17},7,"","","","","","","LDP"]
["2018-09-17","2018-09-17","RJR",{"$nulls":19},1,"RJR","","","","","",""]
["2018-09-18","2018-09-18","SPF",{"$nulls":19},2,"","SPF","","","","",""]
["2018-09-19","2018-09-19","MFS",{"$nulls":19},3,"","","MFS","","","",""]
["2018-09-20","2018-09-20","CJM",{"$nulls":19},4,"","","","CJM","","",""]
["2018-09-21","2018-09-21","AJR",{"$nulls":19},5,"","","","","AJR","",""]
["2018-09-22","2018-09-22","AJR",{"$nulls":19},6,"","","","","","AJR",""]
["2018-09-23","2018-09-23","AJR",{"$nulls":19},7,"","","","","","","AJR"]
["2018-09-24","2018-09-24","PJC",{"$nulls":19},1,"PJC","","","","","",""]
["2018-09-25","2018-09-25","RAC",{"$nulls":19},2,"","RAC","","","","",""]
["2018-09-26","2018-09-26","GAH",{"$nulls":19},3,"","","GAH","","","",""]
["2018-09-27","2018-09-27","PRS",{"$nulls":19},4,"","","","PRS","","",""]
["2018-09-28","2018-09-28","HLT",{"$nulls":19},5,"","","","","HLT","",""]
["2018-09-29","2018-09-29","DJM",null,"Y",{"$nulls":17},6,"","","","","","DJM",""]
["2018-09-30","2018-09-30","DJM",null,"Y",{"$nulls":17},7,"","","","","","","DJM"]
["2018-10-01","2018-10-01","JGE",{"$nulls":19},1,"JGE","","","","","",""]
["2018-10-02","2018-10-02","LDP",{"$nulls":19},2,{"$f":"IF($W280=X$3,$C280,\"\")","v":""},"LDP","","","","",""]
["2018-10-03","2018-10-03","GBH",{"$nulls":19},3,"","","GBH","","","",""]
["2018-10-04","2018-10-04","DBC",{"$nulls":19},4,"","","","DBC","","",""]
["2018-10-05","2018-10-05","DJM",null,"Y",{"$nulls":17},5,"","","","","DJM","",""]
["2018-10-06","2018-10-06","PJC",{"$nulls":19},6,"","","","","","PJC",""]
["2018-10-07","2018-10-07","PJC",{"$nulls":19},7,"","","","","","","PJC"]
["2018-10-08","2018-10-08","REC",{"$nulls":19},1,"REC","","","","","",""]
["2018-10-09","2018-10-09","RJR",{"$nulls":19},2,"","RJR","","","","",""]
["2018-10-10","2018-10-10","SPF",{"$nulls":19},3,"","","SPF","","","",""]
["2018-10-11","2018-10-11","GAH",{"$nulls":19},4,"","","","GAH","","",""]
["2018-10-12","2018-10-12","CJM",{"$nulls":19},5,"","","","","CJM","",""]
["2018-10-13","2018-10-13","GBH",{"$nulls":19},6,"","","","","","GBH",""]
["2018-10-14","2018-10-14","GBH",{"$nulls":19},7,"","","","","","","GBH"]
["2018-10-15","2018-10-15","PRS",{"$nulls":19},1,"PRS","","","","","",""]
["2018-10-16",{"$f":"A294","v":"2018-10-16"},"PJC",{"$nulls":19},{"$f":"WEEKDAY(A294,2)","v":2},"","PJC","","","","",""]
[{"$f":"A294+1","v":"2018-10-17"},"2018-10-17","RAC",{"$nulls":19},3,"","","RAC","","","",""]
["2018-10-18","2018-10-18","AJR",{"$nulls":19},4,"","","","AJR","","",""]
["2018-10-19","2018-10-19","MFS",{"$nulls":19},5,"","","","","MFS","",""]
["2018-10-20","2018-10-20","GAH",{"$nulls":19},6,"","","","","","GAH",""]
["2018-10-21","2018-10-21","GAH",{"$nulls":19},7,"","","","","",{"$f":"IF($W299=AC$3,$C299,\"\")","v":""},"GAH"]
["2018-10-22","2018-10-22","DJM",{"$nulls":19},1,"DJM","","","","","",""]
["2018-10-23","2018-10-23","JGE",{"$nulls":19},2,"","JGE","","","","",""]
["2018-10-24","2018-10-24","LDP",{"$nulls":19},3,"","","LDP","","","",""]
["2018-10-25","2018-10-25","GBH",{"$nulls":19},4,"","","","GBH","","",""]
["2018-10-26","2018-10-26","DBC",{"$nulls":19},5,"","","","","DBC","",""]
["2018-10-27","2018-10-27","REC",{"$nulls":19},6,"","","","","","REC",""]
["2018-10-28","2018-10-28","REC",{"$nulls":19},7,"","","","","","","REC"]
["2018-10-29","2018-10-29","PJC",{"$nulls":19},1,"PJC","","","","","",""]
["2018-10-30","2018-10-30","CJM",{"$nulls":19},2,"","CJM","","","","",""]
["2018-10-31","2018-10-31","SPF",{"$nulls":19},3,"","","SPF","","","",""]
["2018-11-01","2018-11-01","RJR",{"$nulls":19},4,"","","","RJR","","",""]
["2018-11-02","2018-11-02","MFS",{"$nulls":19},5,"","","","","MFS","",""]
["2018-11-03","2018-11-03","JGE",null,"Y",{"$nulls":17},6,"","","","","","JGE",""]
["2018-11-04","2018-11-04","JGE",null,"Y",{"$nulls":17},7,"","","","","","","JGE"]
["2018-11-05","2018-11-05","CJM",{"$nulls":19},1,"CJM","","","","","",""]
["2018-11-06","2018-11-06","DBC",{"$nulls":19},2,"","DBC","","","","",""]
["2018-11-07","2018-11-07","GBH",{"$nulls":19},3,"","","GBH","","","",""]
["2018-11-08","2018-11-08","JGE",null,"Y",{"$nulls":17},4,"","","","JGE","","",""]
["2018-11-09","2018-11-09","AJR",{"$nulls":19},5,"","","","","AJR","",""]
["2018-11-10","2018-11-10","SPF",{"$nulls":19},6,"","","","","","SPF",""]
["2018-11-11","2018-11-11","SPF",{"$nulls":19},7,"","","","","","","SPF"]
["2018-11-12","2018-11-12","DJM",{"$nulls":19},1,"DJM","","","","","",""]
["2018-11-13","2018-11-13","LDP",{"$nulls":19},2,"","LDP","","","","",""]
["2018-11-14","2018-11-14","GAH",{"$nulls":19},3,"","","GAH","","","",""]
["2018-11-15","2018-11-15","HLT",{"$nulls":19},4,"","","","HLT","","",""]
["2018-11-16","2018-11-16","RAC",{"$nulls":19},5,"","","","","RAC","",""]
["2018-11-17","2018-11-17","MFS",{"$nulls":19},6,"","","","","","MFS",""]
["2018-11-18","2018-11-18","MFS",{"$nulls":19},7,"","","","","","","MFS"]
["2018-11-19","2018-11-19","JGE",{"$nulls":19},1,"JGE","","","","","",""]
["2018-11-20","2018-11-20","PJC",{"$nulls":19},2,"","PJC","","","","",""]
["2018-11-21","2018-11-21","CJM",{"$nulls":19},3,"","","CJM","","","",""]
["2018-11-22","2018-11-22","REC",{"$nulls":19},4,"","","","REC","","",""]
["2018-11-23","2018-11-23","PRS",{"$nulls":19},5,"","","","","PRS","",""]
["2018-11-24","2018-11-24","PRS",{"$nulls":19},6,"","","","","","PRS",""]
["2018-11-25","2018-11-25","PRS",{"$nulls":19},7,"","","","","","","PRS"]
["2018-11-26","2018-11-26","MFS",{"$nulls":19},1,"MFS","","","","","",""]
["2018-11-27","2018-11-27","SPF",{"$nulls":19},2,"","SPF","","","","",""]
["2018-11-28","2018-11-28","DBC",{"$nulls":19},3,"","","DBC","","","",""]
["2018-11-29","2018-11-29","GBH",{"$nulls":19},4,"","","","GBH","","",""]
["2018-11-30","2018-11-30","RJR",{"$nulls":19},5,"","","","","RJR","",""]
["2018-12-01","2018-12-01","RAC",{"$nulls":19},6,"","","","","","RAC",""]
["2018-12-02","2018-12-02","RAC",{"$nulls":19},7,"","","","","","","RAC"]
["2018-12-03","2018-12-03","DJM",{"$nulls":19},1,"DJM","",{"$f":"IF($W342=Z$3,$C342,\"\")","v":""},"","","",""]
["2018-12-04","2018-12-04","AJR",{"$nulls":19},2,"","AJR","","","","",""]
["2018-12-05","2018-12-05","LDP",{"$nulls":19},3,{"$f":"IF($W344=X$3,$C344,\"\")","v":""},"","LDP","","","",""]
["2018-12-06","2018-12-06","GAH",{"$nulls":19},4,"","","","GAH","","",""]
["2018-12-07","2018-12-07","HLT",{"$nulls":19},5,"","","","","HLT","",""]
["2018-12-08","2018-12-08","RJR",{"$nulls":19},6,"","","","","","RJR",""]
["2018-12-09","2018-12-09","RJR",{"$nulls":19},7,"","","","","","","RJR"]
["2018-12-10","2018-12-10","RAC",{"$nulls":19},1,"RAC","","","","","",""]
["2018-12-11","2018-12-11","PRS",{"$nulls":19},2,"","PRS","","","","",""]
["2018-12-12","2018-12-12","PJC",{"$nulls":19},3,"","","PJC","","","",""]
["2018-12-13","2018-12-13","CJM",{"$nulls":19},4,"","","","CJM","","",""]
["2018-12-14","2018-12-14","REC",{"$nulls":19},5,"","","","","REC","",""]
["2018-12-15","2018-12-15","DBC",null,"Y",{"$nulls":17},6,"","","","","","DBC",""]
["2018-12-16","2018-12-16","DBC",null,"Y",{"$nulls":17},7,"","","","","","","DBC"]
["2018-12-17","2018-12-17","JGE",{"$nulls":19},1,"JGE","","","","","",""]
["2018-12-18","2018-12-18","MFS",{"$nulls":19},2,"","MFS","","","","",""]
["2018-12-19",{"$f":"A358","v":"2018-12-19"},"SPF",{"$nulls":19},{"$f":"WEEKDAY(A358,2)","v":3},"","","SPF","","","",""]
[{"$f":"A358+1","v":"2018-12-20"},"2018-12-20","DBC",null,"Y",{"$nulls":17},4,"","","","DBC","","",""]
["2018-12-21","2018-12-21","GBH",{"$nulls":19},5,"","","","","GBH","",""]
["2018-12-22","2018-12-22","HLT",{"$nulls":19},6,"","","","","","HLT",""]
["2018-12-23","2018-12-23","HLT",{"$nulls":19},7,"","","","","","","HLT"]
["2018-12-24","2018-12-24","DJM",{"$nulls":19},1,"DJM","","","","","",""]
["2018-12-25","2018-12-25","AJR",{"$nulls":19},2,"","AJR","","","","",""]
["2018-12-26","2018-12-26","RJR",{"$nulls":19},3,"","","RJR","","","",""]
["2018-12-27","2018-12-27","LDP",{"$nulls":19},4,"","","","LDP","","",""]
["2018-12-28","2018-12-28","CJM",{"$nulls":19},5,"","","","","CJM","",""]
["2018-12-29","2018-12-29","CJM",{"$nulls":19},6,"","","","","","CJM",""]
["2018-12-30","2018-12-30","CJM",{"$nulls":19},7,"","","","","","","CJM"]
["2018-12-31","2018-12-31","HLT",{"$nulls":19},1,"HLT","","","","","",""]
["2019-01-01","2019-01-01","RAC",{"$nulls":19},2,"","RAC","","","","",""]
["2019-01-02","2019-01-02","PRS",{"$nulls":19},3,"","","PRS","","","",""]
["2019-01-03","2019-01-03","PJC",{"$nulls":19},4,"","","","PJC","","",""]
["2019-01-04","2019-01-04","GAH",{"$nulls":19},5,"","","","","GAH","",""]
["2019-01-05","2019-01-05","LDP",{"$nulls":19},6,"","","","","","LDP",""]
["2019-01-06","2019-01-06","LDP",{"$nulls":19},7,"","","","","","","LDP"]
["2019-01-07","2019-01-07","REC",{"$nulls":19},1,"REC","","","","","",""]
["2019-01-08","2019-01-08","JGE",{"$nulls":19},2,"","JGE","","","","",""]
["2019-01-09","2019-01-09","MFS",{"$nulls":19},3,"","","MFS","","","",""]
["2019-01-10","2019-01-10","DJM",{"$nulls":19},4,"","","","DJM","","",""]
["2019-01-11","2019-01-11","AJR",{"$nulls":19},5,"","","","","AJR","",""]
["2019-01-12","2019-01-12","AJR",{"$nulls":19},6,"","","","","","AJR",""]
["2019-01-13","2019-01-13","AJR",{"$nulls":19},7,"","","","","","","AJR"]
["2019-01-14","2019-01-14","GBH",{"$nulls":19},1,"GBH","","","","",{"$f":"IF($W384=AC$3,$C384,\"\")","v":""},""]
["2019-01-15","2019-01-15","RJR",{"$nulls":19},2,"","RJR","","","","",""]
["2019-01-16","2019-01-16","DBC",{"$nulls":19},3,"","","DBC","","","",""]
["2019-01-17","2019-01-17","SPF",{"$nulls":19},4,"","","","SPF","","",""]
["2019-01-18","2019-01-18","LDP",{"$nulls":19},5,"","","","","LDP","",""]
["2019-01-19","2019-01-19","DJM",{"$nulls":19},6,"","","","","","DJM",""]
["2019-01-20","2019-01-20","DJM",{"$nulls":19},7,"","","","","","","DJM"]
["2019-01-21","2019-01-21","GAH",{"$nulls":19},1,"GAH","","","","","",""]
["2019-01-22","2019-01-22","HLT",{"$nulls":19},2,"","HLT","","","","",""]
["2019-01-23","2019-01-23","RAC",{"$nulls":19},3,"","","RAC","","","",""]
["2019-01-24","2019-01-24","PRS",{"$nulls":19},4,"","","","PRS","","",""]
["2019-01-25","2019-01-25","RJR",{"$nulls":19},5,"","","","","RJR","",""]
["2019-01-26","2019-01-26","PJC",{"$nulls":19},6,"","","","","","PJC",""]
["2019-01-27","2019-01-27","PJC",{"$nulls":19},7,"","","","","","","PJC"]
["2019-01-28","2019-01-28","GBH",{"$nulls":19},1,"GBH","","","","","",""]
["2019-01-29","2019-01-29","DBC",{"$nulls":19},2,"","DBC","","","","",""]
["2019-01-30","2019-01-30","MFS",{"$nulls":19},3,"","","MFS","","","",""]
["2019-01-31","2019-01-31","AJR",{"$nulls":19},4,"","","","AJR","","",""]
["2019-02-01","2019-02-01","GAH",{"$nulls":19},5,"","","","","GAH","",""]
[]
[]
[]
[]
["Section used to load days in Jan before Feb1"]
[{"$f":"FirstDayOfYear","v":"2018-01-15"},{"$f":"OFFSET(FirstDayOfYear,2,0)","v":"AJR"}]
[{"$f":"CurrentRoster!C10","v":"2018-01-16"},{"$f":"OFFSET(CurrentRoster!C10,2,0)","v":"RAC"}]
[{"$f":"CurrentRoster!D10","v":"2018-01-17"},{"$f":"OFFSET(CurrentRoster!D10,2,0)","v":"LDP"}]
[{"$f":"CurrentRoster!E10","v":"2018-01-18"},{"$f":"OFFSET(CurrentRoster!E10,2,0)","v":"PRS"}]
[{"$f":"CurrentRoster!F10","v":"2018-01-19"},{"$f":"OFFSET(CurrentRoster!F10,2,0)","v":"MFS"}]
[{"$f":"CurrentRoster!G10","v":"2018-01-20"},{"$f":"OFFSET(CurrentRoster!G10,2,0)","v":"JGE"}]
[{"$f":"CurrentRoster!H10","v":"2018-01-21"},{"$f":"OFFSET(CurrentRoster!H10,2,0)","v":"JGE"}]
[{"$f":"CurrentRoster!B16","v":"2018-01-22"},{"$f":"OFFSET(CurrentRoster!B16,2,0)","v":"GAH"}]
[{"$f":"CurrentRoster!C16","v":"2018-01-23"},{"$f":"OFFSET(CurrentRoster!C16,2,0)","v":"SPF"}]
[{"$f":"CurrentRoster!D16","v":"2018-01-24"},{"$f":"OFFSET(CurrentRoster!D16,2,0)","v":"DBC"}]
[{"$f":"CurrentRoster!E16","v":"2018-01-25"},{"$f":"OFFSET(CurrentRoster!E16,2,0)","v":"GBH"}]
[{"$f":"CurrentRoster!F16","v":"2018-01-26"},{"$f":"OFFSET(CurrentRoster!F16,2,0)","v":"JGE"}]
[{"$f":"CurrentRoster!G16","v":"2018-01-27"},{"$f":"OFFSET(CurrentRoster!G16,2,0)","v":"AJR"}]
[{"$f":"CurrentRoster!H16","v":"2018-01-28"},{"$f":"OFFSET(CurrentRoster!H16,2,0)","v":"AJR"}]
[{"$f":"CurrentRoster!B22","v":"2018-01-29"},{"$f":"OFFSET(CurrentRoster!B22,2,0)","v":"DBC"}]
[{"$f":"CurrentRoster!C22","v":"2018-01-30"},{"$f":"OFFSET(CurrentRoster!C22,2,0)","v":"RJR"}]
[{"$f":"CurrentRoster!D22","v":"2018-01-31"},{"$f":"OFFSET(CurrentRoster!D22,2,0)","v":"AJR"}]
[{"$f":"CurrentRoster!E22","v":"2018-02-01"},{"$f":"OFFSET(CurrentRoster!E22,2,0)","v":"PRS"}]
[{"$f":"CurrentRoster!F22","v":"2018-02-02"},{"$f":"OFFSET(CurrentRoster!F22,2,0)","v":"GBH"}]
[{"$f":"CurrentRoster!G22","v":"2018-02-03"},{"$f":"OFFSET(CurrentRoster!G22,2,0)","v":"GBH"}]
[{"$f":"CurrentRoster!H22","v":"2018-02-04"},{"$f":"OFFSET(CurrentRoster!H22,2,0)","v":"GBH"}]

{"sheet":"Sheet1","index":9,"n_rows":33,"n_cols":18,"rows_kept":33,"hidden":true}
["TUE",null,"FRI",null,"SAT",null,"SUN",null,null,"2018-05-01","2017-08-01","2018-09-01","2018-02-01"]
["WED",null,"SAT",null,"SUN",null,"MON"]
["THU",null,"SUN",null,"MON",null,"TUE"]
["FRI",null,"MON",null,"TUE",null,"WED",{"$nulls":3},"2018-05-01","2018-05-01","2018-05-01"]
["SAT",null,"TUE",null,"WED",null,"THU",null,"font","bold",false]
["SUN",null,"WED",null,"THU",null,"FRI",null,null,"colorindex",2]
["MON",null,"THU",null,"FRI",null,"SAT"]
["TUE",null,"FRI",null,"SAT",null,"SUN"]
["WED",null,"SAT",null,"SUN",null,"MON"]
["THU",null,"SUN",null,"MON",null,"TUE",null,"interior","ColorIndex",5,5,16]
["FRI",null,"MON",null,"TUE",null,"WED",null,null,"pattern","xlPatternUp","xlPatternSolid",1]
["SAT",null,"TUE",null,"WED",null,"THU",null,null,"patternColor",255,0,{"$nulls":3},"pattern"]
["SUN",null,"WED",null,"THU",null,"FRI",null,null,"PatternColorIndex",3,-4105,-4105,null,null,"Name","Value","Description"]
["MON",null,"THU",null,"FRI",null,"SAT",{"$nulls":8},"xlPatternAutomatic",-4105,"Excel controls the pattern."]
["TUE",null,"FRI",null,"SAT",null,"SUN",{"$nulls":8},"xlPatternChecker",9,"Checkerboard."]
[{"$nulls":9},"normal","pre/post","p/hol","today",null,null,"xlPatternCrissCross",16,"Criss-cross lines."]
[{"$nulls":9},"2018-10-01",{"$f":"J17+1","v":"2018-10-02"},{"$f":"K17+1","v":"2018-10-03"},{"$f":"L17+1","v":"2018-10-04"},null,null,"xlPatternDown",-4121,"Dark diagonal lines running from the upper left to the lower right."]
[{"$nulls":15},"xlPatternGray16",17,"16% gray."]
[{"$nulls":15},"xlPatternGray25",-4124,"25% gray."]
[{"$nulls":15},"xlPatternGray50",-4125,"50% gray."]
[{"$nulls":15},"xlPatternGray75",-4126,"75% gray."]
[1,{"$f":"INDEX(\"MainRoster\",3,1)","v":{"$error":"#VALUE!"}},{"$nulls":13},"xlPatternGray8",18,"8% gray."]
[2,{"$nulls":14},"xlPatternGrid",15,"Grid."]
[3,{"$nulls":14},"xlPatternHorizontal",-4128,"Dark horizontal lines."]
[4,{"$nulls":14},"xlPatternLightDown",13,"Light diagonal lines running from the upper left to the lower right."]
[{"$nulls":15},"xlPatternLightHorizontal",11,"Light horizontal lines."]
[{"$nulls":15},"xlPatternLightUp",14,"Light diagonal lines running from the lower left to the upper right."]
[{"$nulls":15},"xlPatternLightVertical",12,"Light vertical bars."]
[{"$nulls":15},"xlPatternNone",-4142,"No pattern."]
[{"$nulls":15},"xlPatternSemiGray75",10,"75% dark moir?."]
[{"$nulls":15},"xlPatternSolid",1,"Solid color."]
[{"$nulls":15},"xlPatternUp",-4162,"Dark diagonal lines running from the lower left to the upper right."]
[{"$nulls":15},"xlPatternVertical",-4166,"Dark vertical bars."]