{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Input sheet","Shift Pattern","Team Planner","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":11,"defined_names":277,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input sheet","index":0,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Parameters","Maintenance Manager","Shift supervisor","Other roles"]
[null,null,"Weekend days /year",{"$f":"IF(D10>=5,52*(7-D10),52*(7-5))","v":104},{"$f":"IF(E10>=5,52*(7-E10),52*(7-5))","v":104},{"$f":"IF(F10>=5,52*(7-F10),52*(7-5))","v":104}]
[null,null,"Holidays pr. year"]
[null,null,"Public holidays/year",null,{"$f":"D5","v":0},{"$f":"D5","v":0}]
[null,null,"Sick Leave (estimate)"]
[null,null,"Days off pr. year",{"$f":"SUM(D3:D6)","v":104},{"$f":"SUM(E3:E6)","v":104},{"$f":"SUM(F3:F6)","v":104}]
[null,null,"Working days pr. year",{"$f":"365-D7","v":261},{"$f":"365-E7","v":261},{"$f":"365-F7","v":261}]
[null,null,"Work hours per day"]
[null,null,"Work days per week"]
[null,null,"Work hours per year",{"$f":"D8*(D9*D10/5)","v":0},{"$f":"E8*(E9*E10/5)","v":0},{"$f":"F8*(F9*F10/5)","v":0}]
[null,null,"Estimate PM % during production"]
[null,null,"Estimated PM hours required on site"]
[null,null,"Site shut down x weeks per year"]
[null,null,"Will the Shift supervisor participate in PM?"]
[null,null,"If \"Yes\", How much of the time will the SS spend on PM? "]
[null,null,"Will the Maintenance manager participate in PM?"]
[null,null,"If \"Yes\", How much of the time will the MM spend on PM? "]
[]
[null,"No","Roles"]
[null,1,"Maintenance manager",null,null,{"$f":"CONCATENATE(B21,\" - \",C21)","v":"1 - Maintenance manager"},{"$f":"F21","v":"1 - Maintenance manager"},{"$f":"D11","v":0}]
[null,2,"Shift supervisor 1",null,null,"2 - Shift supervisor 1",{"$f":"F22","v":"2 - Shift supervisor 1"},{"$f":"E11","v":0}]
[null,3,"Shift supervisor 2",null,null,{"$f":"CONCATENATE(B23,\" - \",C23)","v":"3 - Shift supervisor 2"},{"$f":"F23","v":"3 - Shift supervisor 2"},{"$f":"E11","v":0}]
[null,4,"Shift supervisor 3",null,null,"4 - Shift supervisor 3","4 - Shift supervisor 3",{"$f":"E11","v":0}]
[null,5,"Electrical technician 1",null,null,"5 - Electrical technician 1","5 - Electrical technician 1",{"$f":"$F$11","v":0}]
[null,6,"Electrical technician 2",null,null,"6 - Electrical technician 2","6 - Electrical technician 2",{"$f":"$F$11","v":0}]
[null,7,"Electrical technician 3",null,null,"7 - Electrical technician 3","7 - Electrical technician 3",0]
[null,8,"Mechanical technician 1",null,null,"8 - Mechanical technician 1","8 - Mechanical technician 1",0]
[null,9,"Mechanical technician 2",null,null,"9 - Mechanical technician 2","9 - Mechanical technician 2",0]
[null,10,"Mechanical technician 3",null,null,"10 - Mechanical technician 3","10 - Mechanical technician 3",0]
[null,11,"Elektro-Mechanical technician 1",null,null,"11 - Elektro-Mechanical technician 1","11 - Elektro-Mechanical technician 1",0]
[null,12,"Elektro-Mechanical technician 2",null,null,"12 - Elektro-Mechanical technician 2","12 - Elektro-Mechanical technician 2",0]
[null,13,"Elektro-Mechanical technician 3",null,null,"13 - Elektro-Mechanical technician 3","13 - Elektro-Mechanical technician 3",0]
[null,14,"\"Role\"",null,null,"14 - \"Role\"","14 - \"Role\"",0]
[null,15,"\"Role\"",null,null,"15 - \"Role\"","15 - \"Role\"",0]
[null,16,"\"Role\"",null,null,"16 - \"Role\"","16 - \"Role\"",0]
[null,17,"\"Role\"",null,null,"17 - \"Role\"","17 - \"Role\"",0]
[null,18,"\"Role\"",null,null,"18 - \"Role\"","18 - \"Role\"",0]
[null,19,"\"Role\"",null,null,"19 - \"Role\"","19 - \"Role\"",0]
[null,20,"\"Role\"",null,null,"20 - \"Role\"","20 - \"Role\"",0]
[null,21,"\"Role\"",null,null,"21 - \"Role\"","21 - \"Role\"",0]
[null,22,"\"Role\"",null,null,"22 - \"Role\"","22 - \"Role\"",0]
[null,23,"\"Role\"",null,null,"23 - \"Role\"","23 - \"Role\"",0]
[null,24,"\"Role\"",null,null,"24 - \"Role\"","24 - \"Role\"",{"$f":"$F$11","v":0}]
[]
[null,0]
[null,0.1]
[null,0.2]
[null,0.3]
[null,0.4]
[null,0.5]
[null,0.6]
[null,0.7]
[null,0.8]
[null,0.9]
[null,1]

{"sheet":"Shift Pattern","index":1,"n_rows":157,"n_cols":58,"rows_kept":157,"cut":false,"hidden":false,"merged":[[144,17,144,19],[145,17,145,19],[134,17,134,19],[135,17,135,19],[136,17,136,19],[137,17,137,19],[138,17,138,19],[141,17,141,19],[142,17,142,19],[143,17,143,19],[139,17,139,19],[140,17,140,19],[139,8,139,10],[140,8,140,10],[141,8,141,10],[142,8,142,10],[138,11,138,13],[139,11,139,13],[140,11,140,13],[141,11,141,13],[142,11,142,13],[130,5,130,13],[130,14,130,19],[131,5,132,7],[131,8,132,10],[131,11,132,13],[131,17,132,19],[134,5,134,7],[135,5,135,7],[136,5,136,7],[145,14,145,16],[144,5,144,7],[145,5,145,7],[144,8,144,10],[145,8,145,10],[144,11,144,13],[145,11,145,13],[138,5,138,7],[139,5,139,7],[140,5,140,7],[141,5,141,7],[142,5,142,7],[138,8,138,10],[139,14,139,16],[140,14,140,16],[137,14,137,16],[134,14,134,16],[138,14,138,16],[135,14,135,16],[136,14,136,16],[143,14,143,16],[144,14,144,16],[141,14,141,16],[142,14,142,16],[143,5,143,7],[143,8,143,10],[143,11,143,13],[0,17,0,28],[137,5,137,7],[131,14,132,16],[133,14,133,16],[133,5,133,7],[133,8,133,10],[133,11,133,13],[134,8,134,10],[135,8,135,10],[136,8,136,10],[137,8,137,10],[134,11,134,13],[135,11,135,13],[136,11,136,13],[137,11,137,13],[133,17,133,19],[2,17,2,19],[2,26,2,28],[1,17,1,19],[1,26,1,28],[1,20,1,22],[1,23,1,25],[2,20,2,22],[2,23,2,25]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colors to be used"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maintenance manager on-site:",null,null,"Shift supervisor on-site:",null,null,"Production hours:",null,null,"Non-production hours:"]
[]
[null,null,"Monday:"]
[null,null,"Corrective Maintenance & Production Surveillance",null,"Monday"]
[null,null,"SHIFT PATTERN","Team","00:00 - 00:30","00:30 - 01:00","01:00 - 01:30","01:30 - 02:00","02:00 - 02:30","02:30 - 03:00","03:00 - 03:30","03:30 - 04:00","04:00 - 04:30","04:30 - 05:00","05:00 - 05:30","05:30 - 06:00","06:00 - 06:30","06:30 - 07:00","07:00 - 07:30","07:30 - 08:00","08:00 - 08:30","08:30 - 09:00","09:00 - 09:30","09:30 - 10:00","10:00 - 10:30","10:30 - 11:00","11:00 - 11:30","11:30 - 12:00","12:00 - 12:30","12:30 - 13:00","13:00 - 13:30","13:30 - 14:00","14:00 - 14:30","14:30 - 15:00","15:00 - 15:30","15:30 - 16:00","16:00 - 16:30","16:30 - 17:00","17:00 - 17:30","17:30 - 18:00","18:00 - 18:30","18:30 - 19:00","19:00 - 19:30","19:30 - 20:00","20:00 - 20:30","20:30 - 21:00","21:00 - 21:30","21:30 - 22:00","22:00 - 22:30","22:30 - 23:00","23:00 - 23:30","23:30 - 00:00","Hours/\nday"]
[null,null,"1 - Maintenance manager",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E7:AZ7)/2","v":8},null,{"$f":"(colorfunction(BC6,$E$7:$AZ$19,TRUE)/2)","v":8},{"$f":"(colorfunction(BD6,$E$7:$AZ$19,TRUE)/2)","v":24},{"$f":"(colorfunction(BE6,$E$7:$AZ$19,TRUE)/2)","v":40},{"$f":"(colorfunction(BF6,$E$7:$AZ$19,TRUE)/2)","v":8}]
[null,null,"2 - Shift supervisor 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E8:AZ8)/2","v":8}]
[null,null,"3 - Shift supervisor 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,{"$f":"SUM(E9:AZ9)/2","v":8}]
[null,null,"4 - Shift supervisor 3",null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,"5 - Electrical technician 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,"6 - Electrical technician 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,{"$f":"SUM(E12:AZ12)/2","v":8}]
[null,null,"7 - Electrical technician 3",null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,"8 - Mechanical technician 1"," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"9 - Mechanical technician 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,"10 - Mechanical technician 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,8]
[null,null,"14 - \"Role\"",null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,"15 - \"Role\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"16 - \"Role\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Techs on-site",null,{"$f":"SUM(E8:E19)","v":3},{"$f":"SUM(F8:F19)","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,{"$f":"SUM(BA7:BA19)","v":80}]
[]
[null,null,"Tuesday:"]
[null,null,"Corrective Maintenance & Production Surveillance",null,"Tuesday"]
[null,null,"SHIFT PATTERN","Team","00:00 - 00:30","00:30 - 01:00","01:00 - 01:30","01:30 - 02:00","02:00 - 02:30","02:30 - 03:00","03:00 - 03:30","03:30 - 04:00","04:00 - 04:30","04:30 - 05:00","05:00 - 05:30","05:30 - 06:00","06:00 - 06:30","06:30 - 07:00","07:00 - 07:30","07:30 - 08:00","08:00 - 08:30","08:30 - 09:00","09:00 - 09:30","09:30 - 10:00","10:00 - 10:30","10:30 - 11:00","11:00 - 11:30","11:30 - 12:00","12:00 - 12:30","12:30 - 13:00","13:00 - 13:30","13:30 - 14:00","14:00 - 14:30","14:30 - 15:00","15:00 - 15:30","15:30 - 16:00","16:00 - 16:30","16:30 - 17:00","17:00 - 17:30","17:30 - 18:00","18:00 - 18:30","18:30 - 19:00","19:00 - 19:30","19:30 - 20:00","20:00 - 20:30","20:30 - 21:00","21:00 - 21:30","21:30 - 22:00","22:00 - 22:30","22:30 - 23:00","23:00 - 23:30","23:30 - 00:00","Hours/\nday"]
[null,null,{"$f":"IF($C$7=\"\",\"\",$C$7)","v":"1 - Maintenance manager"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E25:AZ25)/2","v":8},null,{"$f":"(colorfunction(BC24,$E$25:$AZ$37,TRUE)/2)","v":8},{"$f":"(colorfunction(BD24,$E$25:$AZ$37,TRUE)/2)","v":24},{"$f":"(colorfunction(BE24,$E$25:$AZ$37,TRUE)/2)","v":40},{"$f":"(colorfunction(BF24,$E$25:$AZ$37,TRUE)/2)","v":8}]
[null,null,{"$f":"IF($C$8=\"\",\"\",$C$8)","v":"2 - Shift supervisor 1"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E26:AZ26)/2","v":8}]
[null,null,{"$f":"IF($C$9=\"\",\"\",$C$9)","v":"3 - Shift supervisor 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,{"$f":"SUM(E27:AZ27)/2","v":8}]
[null,null,{"$f":"IF($C$10=\"\",\"\",$C$10)","v":"4 - Shift supervisor 3"},null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$11=\"\",\"\",$C$11)","v":"5 - Electrical technician 1"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$12=\"\",\"\",$C$12)","v":"6 - Electrical technician 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,8]
[null,null,{"$f":"IF($C$13=\"\",\"\",$C$13)","v":"7 - Electrical technician 3"},null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$14=\"\",\"\",$C$14)","v":"8 - Mechanical technician 1"}," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF($C$15=\"\",\"\",$C$15)","v":"9 - Mechanical technician 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$16=\"\",\"\",$C$16)","v":"10 - Mechanical technician 3"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,8]
[null,null,{"$f":"IF($C$17=\"\",\"\",$C$17)","v":"14 - \"Role\""},null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$18=\"\",\"\",$C$18)","v":"15 - \"Role\""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF($C$19=\"\",\"\",$C$19)","v":"16 - \"Role\""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Techs on-site",null,{"$f":"SUM(E26:E37)","v":3},{"$f":"SUM(F26:F37)","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,{"$f":"SUM(BA25:BA37)","v":80}]
[]
[null,null,"Wednesday:"]
[null,null,"Corrective Maintenance & Production Surveillance",null,"Wednesday"]
[null,null,"SHIFT PATTERN","Team","00:00 - 00:30","00:30 - 01:00","01:00 - 01:30","01:30 - 02:00","02:00 - 02:30","02:30 - 03:00","03:00 - 03:30","03:30 - 04:00","04:00 - 04:30","04:30 - 05:00","05:00 - 05:30","05:30 - 06:00","06:00 - 06:30","06:30 - 07:00","07:00 - 07:30","07:30 - 08:00","08:00 - 08:30","08:30 - 09:00","09:00 - 09:30","09:30 - 10:00","10:00 - 10:30","10:30 - 11:00","11:00 - 11:30","11:30 - 12:00","12:00 - 12:30","12:30 - 13:00","13:00 - 13:30","13:30 - 14:00","14:00 - 14:30","14:30 - 15:00","15:00 - 15:30","15:30 - 16:00","16:00 - 16:30","16:30 - 17:00","17:00 - 17:30","17:30 - 18:00","18:00 - 18:30","18:30 - 19:00","19:00 - 19:30","19:30 - 20:00","20:00 - 20:30","20:30 - 21:00","21:00 - 21:30","21:30 - 22:00","22:00 - 22:30","22:30 - 23:00","23:00 - 23:30","23:30 - 00:00","Hours/\nday"]
[null,null,{"$f":"IF($C$7=\"\",\"\",$C$7)","v":"1 - Maintenance manager"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E43:AZ43)/2","v":8},null,{"$f":"(colorfunction(BC42,$E$43:$AZ$55,TRUE)/2)","v":8},{"$f":"(colorfunction(BD42,$E$43:$AZ$55,TRUE)/2)","v":24},{"$f":"(colorfunction(BE42,$E$43:$AZ$55,TRUE)/2)","v":40},{"$f":"(colorfunction(BF42,$E$43:$AZ$55,TRUE)/2)","v":8}]
[null,null,{"$f":"IF($C$8=\"\",\"\",$C$8)","v":"2 - Shift supervisor 1"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E44:AZ44)/2","v":8}]
[null,null,{"$f":"IF($C$9=\"\",\"\",$C$9)","v":"3 - Shift supervisor 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,8]
[null,null,{"$f":"IF($C$10=\"\",\"\",$C$10)","v":"4 - Shift supervisor 3"},null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$11=\"\",\"\",$C$11)","v":"5 - Electrical technician 1"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$12=\"\",\"\",$C$12)","v":"6 - Electrical technician 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,8]
[null,null,{"$f":"IF($C$13=\"\",\"\",$C$13)","v":"7 - Electrical technician 3"},null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$14=\"\",\"\",$C$14)","v":"8 - Mechanical technician 1"}," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF($C$15=\"\",\"\",$C$15)","v":"9 - Mechanical technician 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$16=\"\",\"\",$C$16)","v":"10 - Mechanical technician 3"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,8]
[null,null,{"$f":"IF($C$17=\"\",\"\",$C$17)","v":"14 - \"Role\""},null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$18=\"\",\"\",$C$18)","v":"15 - \"Role\""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF($C$19=\"\",\"\",$C$19)","v":"16 - \"Role\""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Techs on-site",null,{"$f":"SUM(E44:E55)","v":3},{"$f":"SUM(F44:F55)","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,{"$f":"SUM(BA43:BA55)","v":80}]
[]
[null,null,"Thursday:"]
[null,null,"Corrective Maintenance & Production Surveillance",null,"Thursday"]
[null,null,"SHIFT PATTERN","Team","00:00 - 00:30","00:30 - 01:00","01:00 - 01:30","01:30 - 02:00","02:00 - 02:30","02:30 - 03:00","03:00 - 03:30","03:30 - 04:00","04:00 - 04:30","04:30 - 05:00","05:00 - 05:30","05:30 - 06:00","06:00 - 06:30","06:30 - 07:00","07:00 - 07:30","07:30 - 08:00","08:00 - 08:30","08:30 - 09:00","09:00 - 09:30","09:30 - 10:00","10:00 - 10:30","10:30 - 11:00","11:00 - 11:30","11:30 - 12:00","12:00 - 12:30","12:30 - 13:00","13:00 - 13:30","13:30 - 14:00","14:00 - 14:30","14:30 - 15:00","15:00 - 15:30","15:30 - 16:00","16:00 - 16:30","16:30 - 17:00","17:00 - 17:30","17:30 - 18:00","18:00 - 18:30","18:30 - 19:00","19:00 - 19:30","19:30 - 20:00","20:00 - 20:30","20:30 - 21:00","21:00 - 21:30","21:30 - 22:00","22:00 - 22:30","22:30 - 23:00","23:00 - 23:30","23:30 - 00:00","Hours/\nday"]
[null,null,{"$f":"IF($C$7=\"\",\"\",$C$7)","v":"1 - Maintenance manager"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E61:AZ61)/2","v":8},null,{"$f":"(colorfunction(BC60,$E$61:$AZ$73,TRUE)/2)","v":8},{"$f":"(colorfunction(BD60,$E$61:$AZ$73,TRUE)/2)","v":24},{"$f":"(colorfunction(BE60,$E$61:$AZ$73,TRUE)/2)","v":40},{"$f":"(colorfunction(BF60,$E$61:$AZ$73,TRUE)/2)","v":8}]
[null,null,{"$f":"IF($C$8=\"\",\"\",$C$8)","v":"2 - Shift supervisor 1"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E62:AZ62)/2","v":8}]
[null,null,{"$f":"IF($C$9=\"\",\"\",$C$9)","v":"3 - Shift supervisor 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,8]
[null,null,{"$f":"IF($C$10=\"\",\"\",$C$10)","v":"4 - Shift supervisor 3"},null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$11=\"\",\"\",$C$11)","v":"5 - Electrical technician 1"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$12=\"\",\"\",$C$12)","v":"6 - Electrical technician 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,8]
[null,null,{"$f":"IF($C$13=\"\",\"\",$C$13)","v":"7 - Electrical technician 3"},null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$14=\"\",\"\",$C$14)","v":"8 - Mechanical technician 1"}," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF($C$15=\"\",\"\",$C$15)","v":"9 - Mechanical technician 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$16=\"\",\"\",$C$16)","v":"10 - Mechanical technician 3"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,8]
[null,null,{"$f":"IF($C$17=\"\",\"\",$C$17)","v":"14 - \"Role\""},null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$18=\"\",\"\",$C$18)","v":"15 - \"Role\""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF($C$19=\"\",\"\",$C$19)","v":"16 - \"Role\""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Techs on-site",null,{"$f":"SUM(E62:E73)","v":3},{"$f":"SUM(F62:F73)","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,{"$f":"SUM(BA61:BA73)","v":80}]
[]
[null,null,"Friday:"]
[null,null,"Corrective Maintenance & Production Surveillance",null,"Friday"]
[null,null,"SHIFT PATTERN","Team","00:00 - 00:30","00:30 - 01:00","01:00 - 01:30","01:30 - 02:00","02:00 - 02:30","02:30 - 03:00","03:00 - 03:30","03:30 - 04:00","04:00 - 04:30","04:30 - 05:00","05:00 - 05:30","05:30 - 06:00","06:00 - 06:30","06:30 - 07:00","07:00 - 07:30","07:30 - 08:00","08:00 - 08:30","08:30 - 09:00","09:00 - 09:30","09:30 - 10:00","10:00 - 10:30","10:30 - 11:00","11:00 - 11:30","11:30 - 12:00","12:00 - 12:30","12:30 - 13:00","13:00 - 13:30","13:30 - 14:00","14:00 - 14:30","14:30 - 15:00","15:00 - 15:30","15:30 - 16:00","16:00 - 16:30","16:30 - 17:00","17:00 - 17:30","17:30 - 18:00","18:00 - 18:30","18:30 - 19:00","19:00 - 19:30","19:30 - 20:00","20:00 - 20:30","20:30 - 21:00","21:00 - 21:30","21:30 - 22:00","22:00 - 22:30","22:30 - 23:00","23:00 - 23:30","23:30 - 00:00","Hours/\nday"]
[null,null,{"$f":"IF($C$7=\"\",\"\",$C$7)","v":"1 - Maintenance manager"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E79:AZ79)/2","v":8},null,{"$f":"(colorfunction(BC78,$E$79:$AZ$91,TRUE)/2)","v":8},{"$f":"(colorfunction(BD78,$E$79:$AZ$91,TRUE)/2)","v":24},{"$f":"(colorfunction(BE78,$E$79:$AZ$91,TRUE)/2)","v":40},{"$f":"(colorfunction(BF78,$E$79:$AZ$91,TRUE)/2)","v":8}]
[null,null,{"$f":"IF($C$8=\"\",\"\",$C$8)","v":"2 - Shift supervisor 1"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E80:AZ80)/2","v":8}]
[null,null,{"$f":"IF($C$9=\"\",\"\",$C$9)","v":"3 - Shift supervisor 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,8]
[null,null,{"$f":"IF($C$10=\"\",\"\",$C$10)","v":"4 - Shift supervisor 3"},null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$11=\"\",\"\",$C$11)","v":"5 - Electrical technician 1"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$12=\"\",\"\",$C$12)","v":"6 - Electrical technician 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,8]
[null,null,{"$f":"IF($C$13=\"\",\"\",$C$13)","v":"7 - Electrical technician 3"},null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$14=\"\",\"\",$C$14)","v":"8 - Mechanical technician 1"}," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF($C$15=\"\",\"\",$C$15)","v":"9 - Mechanical technician 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$16=\"\",\"\",$C$16)","v":"10 - Mechanical technician 3"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,8]
[null,null,{"$f":"IF($C$17=\"\",\"\",$C$17)","v":"14 - \"Role\""},null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$18=\"\",\"\",$C$18)","v":"15 - \"Role\""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF($C$19=\"\",\"\",$C$19)","v":"16 - \"Role\""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Techs on-site",null,{"$f":"SUM(E80:E91)","v":3},{"$f":"SUM(F80:F91)","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,{"$f":"SUM(BA79:BA91)","v":80}]
[]
[null,null,"Saturday:"]
[null,null,"Corrective Maintenance & Production Surveillance",null,"Saturday"]
[null,null,"SHIFT PATTERN","Team","00:00 - 00:30","00:30 - 01:00","01:00 - 01:30","01:30 - 02:00","02:00 - 02:30","02:30 - 03:00","03:00 - 03:30","03:30 - 04:00","04:00 - 04:30","04:30 - 05:00","05:00 - 05:30","05:30 - 06:00","06:00 - 06:30","06:30 - 07:00","07:00 - 07:30","07:30 - 08:00","08:00 - 08:30","08:30 - 09:00","09:00 - 09:30","09:30 - 10:00","10:00 - 10:30","10:30 - 11:00","11:00 - 11:30","11:30 - 12:00","12:00 - 12:30","12:30 - 13:00","13:00 - 13:30","13:30 - 14:00","14:00 - 14:30","14:30 - 15:00","15:00 - 15:30","15:30 - 16:00","16:00 - 16:30","16:30 - 17:00","17:00 - 17:30","17:30 - 18:00","18:00 - 18:30","18:30 - 19:00","19:00 - 19:30","19:30 - 20:00","20:00 - 20:30","20:30 - 21:00","21:00 - 21:30","21:30 - 22:00","22:00 - 22:30","22:30 - 23:00","23:00 - 23:30","23:30 - 00:00","Hours/\nday"]
[null,null,{"$f":"IF($C$7=\"\",\"\",$C$7)","v":"1 - Maintenance manager"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E97:AZ97)/2","v":0},null,{"$f":"(colorfunction(BC96,$E$97:$AZ$109,TRUE)/2)","v":0},{"$f":"(colorfunction(BD96,$E$97:$AZ$109,TRUE)/2)","v":24},{"$f":"(colorfunction(BE96,$E$97:$AZ$109,TRUE)/2)","v":40},{"$f":"(colorfunction(BF96,$E$97:$AZ$109,TRUE)/2)","v":8}]
[null,null,{"$f":"IF($C$8=\"\",\"\",$C$8)","v":"2 - Shift supervisor 1"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E98:AZ98)/2","v":8}]
[null,null,{"$f":"IF($C$9=\"\",\"\",$C$9)","v":"3 - Shift supervisor 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,8]
[null,null,{"$f":"IF($C$10=\"\",\"\",$C$10)","v":"4 - Shift supervisor 3"},null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$11=\"\",\"\",$C$11)","v":"5 - Electrical technician 1"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$12=\"\",\"\",$C$12)","v":"6 - Electrical technician 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,8]
[null,null,{"$f":"IF($C$13=\"\",\"\",$C$13)","v":"7 - Electrical technician 3"},null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$14=\"\",\"\",$C$14)","v":"8 - Mechanical technician 1"}," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF($C$15=\"\",\"\",$C$15)","v":"9 - Mechanical technician 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$16=\"\",\"\",$C$16)","v":"10 - Mechanical technician 3"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,8]
[null,null,{"$f":"IF($C$17=\"\",\"\",$C$17)","v":"14 - \"Role\""},null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$18=\"\",\"\",$C$18)","v":"15 - \"Role\""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF($C$19=\"\",\"\",$C$19)","v":"16 - \"Role\""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Techs on-site",null,{"$f":"SUM(E98:E109)","v":3},{"$f":"SUM(F98:F109)","v":3},3,3,3,3,3,3,3,3,3,3,{"$f":"SUM(Q98:Q109)","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,{"$f":"SUM(BA97:BA109)","v":72}]
[]
[null,null,"Sunday:"]
[null,null,null,null,"Sunday"]
[null,null,"SHIFT PATTERN","Team","00:00 - 00:30","00:30 - 01:00","01:00 - 01:30","01:30 - 02:00","02:00 - 02:30","02:30 - 03:00","03:00 - 03:30","03:30 - 04:00","04:00 - 04:30","04:30 - 05:00","05:00 - 05:30","05:30 - 06:00","06:00 - 06:30","06:30 - 07:00","07:00 - 07:30","07:30 - 08:00","08:00 - 08:30","08:30 - 09:00","09:00 - 09:30","09:30 - 10:00","10:00 - 10:30","10:30 - 11:00","11:00 - 11:30","11:30 - 12:00","12:00 - 12:30","12:30 - 13:00","13:00 - 13:30","13:30 - 14:00","14:00 - 14:30","14:30 - 15:00","15:00 - 15:30","15:30 - 16:00","16:00 - 16:30","16:30 - 17:00","17:00 - 17:30","17:30 - 18:00","18:00 - 18:30","18:30 - 19:00","19:00 - 19:30","19:30 - 20:00","20:00 - 20:30","20:30 - 21:00","21:00 - 21:30","21:30 - 22:00","22:00 - 22:30","22:30 - 23:00","23:00 - 23:30","23:30 - 00:00","Hours/\nday"]
[null,null,{"$f":"IF($C$7=\"\",\"\",$C$7)","v":"1 - Maintenance manager"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E115:AZ115)/2","v":0},null,{"$f":"(colorfunction(BC114,$E$115:$AZ$127,TRUE)/2)","v":0},{"$f":"(colorfunction(BD114,$E$115:$AZ$127,TRUE)/2)","v":24},{"$f":"(colorfunction(BE114,$E$115:$AZ$127,TRUE)/2)","v":40},{"$f":"(colorfunction(BF114,$E$115:$AZ$127,TRUE)/2)","v":8}]
[null,null,{"$f":"IF($C$8=\"\",\"\",$C$8)","v":"2 - Shift supervisor 1"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E116:AZ116)/2","v":8}]
[null,null,{"$f":"IF($C$9=\"\",\"\",$C$9)","v":"3 - Shift supervisor 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,8]
[null,null,{"$f":"IF($C$10=\"\",\"\",$C$10)","v":"4 - Shift supervisor 3"},null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$11=\"\",\"\",$C$11)","v":"5 - Electrical technician 1"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$12=\"\",\"\",$C$12)","v":"6 - Electrical technician 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,8]
[null,null,{"$f":"IF($C$13=\"\",\"\",$C$13)","v":"7 - Electrical technician 3"},null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$14=\"\",\"\",$C$14)","v":"8 - Mechanical technician 1"}," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF($C$15=\"\",\"\",$C$15)","v":"9 - Mechanical technician 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$16=\"\",\"\",$C$16)","v":"10 - Mechanical technician 3"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,8]
[null,null,{"$f":"IF($C$17=\"\",\"\",$C$17)","v":"14 - \"Role\""},null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,{"$f":"IF($C$18=\"\",\"\",$C$18)","v":"15 - \"Role\""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF($C$19=\"\",\"\",$C$19)","v":"16 - \"Role\""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Techs on-site",null,{"$f":"SUM(E116:E127)","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,{"$f":"SUM(BA115:BA127)","v":72},null,"Sum - Coloured fields:"]
[]
[]
[null,null,null,null,null,"Hours per:",null,null,null,null,null,null,null,null,"Coverage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC7+BC25+BC43+BC61+BC79+BC97+BC115","v":40},{"$f":"BD7+BD25+BD43+BD61+BD79+BD97+BD115","v":168},{"$f":"BE7+BE25+BE43+BE61+BE79+BE97+BE115","v":280},{"$f":"BF7+BF25+BF43+BF61+BF79+BF97+BF115","v":56}]
[null,null,null,null,null,"Week",null,null,"Month",null,null,"Year",null,null,"Theoretical HC",null,null,"Suggested HC\n(Manual input)"]
[null,null,"Totals"]
[null,null,{"$f":"IF($C$7=\"\",\"\",$C$7)","v":"1 - Maintenance manager"},{"$f":"VLOOKUP(C134,'Input sheet'!$G$21:$H$44,2,FALSE)","v":0},null,{"$f":"BA7+BA25+BA43+BA61+BA79+BA97+BA115","v":40},null,null,{"$f":"F134*(52/12)","v":173.33333333333331},null,null,{"$f":"F134*(52-'Input sheet'!$F$14)","v":2080},null,null,{"$f":"IFERROR(L134/(D134),\"Check input sheet\")","v":"Check input sheet"}]
[null,null,{"$f":"IF($C$8=\"\",\"\",$C$8)","v":"2 - Shift supervisor 1"},{"$f":"VLOOKUP(C135,'Input sheet'!$G$21:$H$44,2,FALSE)","v":0},null,{"$f":"BA8+BA26+BA44+BA62+BA80+BA98+BA116","v":56},null,null,{"$f":"F135*(52/12)","v":242.66666666666666},null,null,{"$f":"F135*(52-'Input sheet'!$F$14)","v":2912},null,null,{"$f":"IFERROR(L135/(D135),\"Check input sheet\")","v":"Check input sheet"}]
[null,null,{"$f":"IF($C$9=\"\",\"\",$C$9)","v":"3 - Shift supervisor 2"},{"$f":"VLOOKUP(C136,'Input sheet'!$G$21:$H$44,2,FALSE)","v":0},null,{"$f":"BA9+BA27+BA45+BA63+BA81+BA99+BA117","v":56},null,null,242.66666666666666,null,null,{"$f":"F136*(52-'Input sheet'!$F$14)","v":2912},null,null,"Check input sheet"]
[null,null,{"$f":"IF($C$10=\"\",\"\",$C$10)","v":"4 - Shift supervisor 3"},{"$f":"VLOOKUP(C137,'Input sheet'!$G$21:$H$44,2,FALSE)","v":0},null,{"$f":"BA10+BA28+BA46+BA64+BA82+BA100+BA118","v":56},null,null,242.66666666666666,null,null,{"$f":"F137*(52-'Input sheet'!$F$14)","v":2912},null,null,"Check input sheet"]
[null,null,{"$f":"IF($C$11=\"\",\"\",$C$11)","v":"5 - Electrical technician 1"},{"$f":"VLOOKUP(C138,'Input sheet'!$G$21:$H$44,2,FALSE)","v":0},null,56,null,null,242.66666666666666,null,null,{"$f":"F138*(52-'Input sheet'!$F$14)","v":2912},null,null,"Check input sheet"]
[null,null,{"$f":"IF($C$12=\"\",\"\",$C$12)","v":"6 - Electrical technician 2"},{"$f":"VLOOKUP(C139,'Input sheet'!$G$21:$H$44,2,FALSE)","v":0},null,56,null,null,242.66666666666666,null,null,{"$f":"F139*(52-'Input sheet'!$F$14)","v":2912},null,null,"Check input sheet"]
[null,null,{"$f":"IF($C$13=\"\",\"\",$C$13)","v":"7 - Electrical technician 3"},{"$f":"VLOOKUP(C140,'Input sheet'!$G$21:$H$44,2,FALSE)","v":0},null,56,null,null,242.66666666666666,null,null,{"$f":"F140*(52-'Input sheet'!$F$14)","v":2912},null,null,"Check input sheet"]
[null,null,{"$f":"IF($C$14=\"\",\"\",$C$14)","v":"8 - Mechanical technician 1"},{"$f":"VLOOKUP(C141,'Input sheet'!$G$21:$H$44,2,FALSE)","v":0},null,0,null,null,0,null,null,{"$f":"F141*(52-'Input sheet'!$F$14)","v":0},null,null,"Check input sheet"]
[null,null,{"$f":"IF($C$15=\"\",\"\",$C$15)","v":"9 - Mechanical technician 2"},{"$f":"VLOOKUP(C142,'Input sheet'!$G$21:$H$44,2,FALSE)","v":0},null,56,null,null,242.66666666666666,null,null,{"$f":"F142*(52-'Input sheet'!$F$14)","v":2912},null,null,"Check input sheet"]
[null,null,{"$f":"IF($C$16=\"\",\"\",$C$16)","v":"10 - Mechanical technician 3"},{"$f":"VLOOKUP(C143,'Input sheet'!$G$21:$H$44,2,FALSE)","v":0},null,56,null,null,242.66666666666666,null,null,{"$f":"F143*(52-'Input sheet'!$F$14)","v":2912},null,null,"Check input sheet"]
[null,null,{"$f":"IF($C$17=\"\",\"\",$C$17)","v":"14 - \"Role\""},{"$f":"VLOOKUP(C144,'Input sheet'!$G$21:$H$44,2,FALSE)","v":0},null,56,null,null,242.66666666666666,null,null,{"$f":"F144*(52-'Input sheet'!$F$14)","v":2912},null,null,"Check input sheet"]
[null,null,{"$f":"IF($C$18=\"\",\"\",$C$18)","v":"15 - \"Role\""},{"$f":"VLOOKUP(C145,'Input sheet'!$G$21:$H$44,2,FALSE)","v":0},null,0,null,null,0,null,null,{"$f":"F145*(52-'Input sheet'!$F$14)","v":0},null,null,"Check input sheet"]
[null,null,{"$f":"IF($C$19=\"\",\"\",$C$19)","v":"16 - \"Role\""},{"$f":"VLOOKUP(C146,'Input sheet'!$G$21:$H$44,2,FALSE)","v":0},null,0,null,null,0,null,null,{"$f":"F146*(52-'Input sheet'!$F$14)","v":0},null,null,"Check input sheet"]
[null,null,null,null,null,"Total:",null,null,null,null,null,null,null,null,{"$f":"SUM(O134:Q146)","v":0},null,null,{"$f":"SUM(R134:T146)","v":0}]
[]
[null,null,"Maintenance per year"]
[null,null,"Corrective / Production Surveillance",{"$f":"BE131*52","v":14560}]
[null,null,"Preventive Hours: ",{"$f":"SUM(D152:D154)","v":2912}]
[null,null,"Maintenance manager",{"$f":"IF('Input sheet'!D17=\"Yes\",('Input sheet'!D18*BC131)*(52-'Input sheet'!F14)*('Input sheet'!D8/365),0)","v":0}]
[null,null,"Shift Supervisor",{"$f":"IF('Input sheet'!E15=\"Yes\",('Input sheet'!E16*BD131)*(52-'Input sheet'!F14)*('Input sheet'!E8/365),0)","v":0}]
[null,null,"Technicians",{"$f":"(BF131+(BE131*'Input sheet'!F12))*(52-'Input sheet'!F14)","v":2912}]
[]
[null,null,"Needed PM to be done",{"$f":"'Input sheet'!F13","v":0}]
[null,null,"Coverage of needed PM hours",{"$f":"IFERROR((D151)/D156,\"-\")","v":"-"}]

{"sheet":"Team Planner","index":2,"n_rows":367,"n_cols":18,"rows_kept":367,"cut":false,"hidden":false,"merged":[[336,0,366,0],[2,0,32,0],[33,0,60,0],[61,0,91,0],[92,0,121,0],[122,0,152,0],[153,0,182,0],[183,0,213,0],[214,0,244,0],[245,0,274,0],[275,0,305,0],[306,0,335,0]]}
["MONTH","DATE","DAY","A","B","C","D","E","F","G","H","I","J","REMARKS",null,"Days working","Total with holidays and days off","Days left for extra shifts"]
[null,null,null,"1000-1830","05:00-22:00",null,null,null,null,null,null,null,null,null,null,"Days for \"1\"","Days for \"1\"","Days for \"1\""]
["January - 2020","2020-01-01","WED",1,2,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D3:M367,1)","v":208},{"$f":"P3+'Input sheet'!$F$7","v":312},{"$f":"IF(365-Q3=365,\"-\",365-Q3)","v":53}]
[null,"2020-01-02","THU",1,2,null,null,null,null,null,null,null,null,null,null,"Days for \"2\"","Days for \"2\"","Days for \"2\""]
[null,"2020-01-03","FRI",1,2,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D3:M367,2)","v":210},{"$f":"P5+'Input sheet'!$F$7","v":314},{"$f":"IF(365-Q5=365,\"-\",365-Q5)","v":51}]
[null,"2020-01-04","SAT",null,null,null,null,null,null,null,null,null,null,null,null,"Days for \"3\"","Days for \"3\"","Days for \"3\""]
[null,"2020-01-05","SUN",2,3,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D3:M367,3)","v":208},{"$f":"P7+'Input sheet'!$F$7","v":312},{"$f":"IF(365-Q7=365,\"-\",365-Q7)","v":53}]
[null,"2020-01-06","MON",2,3,null,null,null,null,null,null,null,null,null,null,"Days for \"4\"","Days for \"4\"","Days for \"4\""]
[null,"2020-01-07","TUE",3,1,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D3:M367,4)","v":0},{"$f":"P9+'Input sheet'!$F$7","v":104},{"$f":"IF(365-Q9=365,\"-\",365-Q9)","v":261}]
[null,"2020-01-08","WED",3,1,null,null,null,null,null,null,null,null,null,null,"Days for \"5\"","Days for \"5\"","Days for \"5\""]
[null,"2020-01-09","THU",3,1,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D3:M367,5)","v":0},{"$f":"P11+'Input sheet'!$F$7","v":104},{"$f":"IF(365-Q11=365,\"-\",365-Q11)","v":261}]
[null,"2020-01-10","FRI",1,2,null,null,null,null,null,null,null,null,null,null,"Days for \"6\"","Days for \"6\"","Days for \"6\""]
[null,"2020-01-11","SAT",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D3:M367,6)","v":0},{"$f":"P13+'Input sheet'!$F$7","v":104},{"$f":"IF(365-Q13=365,\"-\",365-Q13)","v":261}]
[null,"2020-01-12","SUN",1,2,null,null,null,null,null,null,null,null,null,null,"Days for \"7\"","Days for \"7\"","Days for \"7\""]
[null,"2020-01-13","MON",2,3,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D3:M367,7)","v":0},{"$f":"P15+'Input sheet'!$F$7","v":104},{"$f":"IF(365-Q15=365,\"-\",365-Q15)","v":261}]
[null,"2020-01-14","TUE",2,3]
[null,"2020-01-15","WED",2,3]
[null,"2020-01-16","THU",3,1]
[null,"2020-01-17","FRI",3,1]
[null,"2020-01-18","SAT"]
[null,"2020-01-19","SUN",1,2]
[null,"2020-01-20","MON",1,2]
[null,"2020-01-21","TUE",1,2]
[null,"2020-01-22","WED",2,3]
[null,"2020-01-23","THU",2,3]
[null,"2020-01-24","FRI",2,3]
[null,"2020-01-25","SAT"]
[null,"2020-01-26","SUN",3,1]
[null,"2020-01-27","MON",3,1]
[null,"2020-01-28","TUE",1,2]
[null,"2020-01-29","WED",1,2]
[null,"2020-01-30","THU",1,2]
[null,"2020-01-31","FRI",2,3]
["FEBRUARY-2020","2020-02-01","SAT"]
[null,"2020-02-02","SUN",2,3]
[null,"2020-02-03","MON",3,1]
[null,"2020-02-04","TUE",3,1]
[null,"2020-02-05","WED",3,1]
[null,"2020-02-06","THU",1,2]
[null,"2020-02-07","FRI",1,2]
[null,"2020-02-08","SAT"]
[null,"2020-02-09","SUN",2,3]
[null,"2020-02-10","MON",2,3]
[null,"2020-02-11","TUE",2,3]
[null,"2020-02-12","WED",3,1]
[null,"2020-02-13","THU",3,1]
[null,"2020-02-14","FRI",3,1]
[null,"2020-02-15","SAT"]
[null,"2020-02-16","SUN",1,2]
[null,"2020-02-17","MON",1,2]
[null,"2020-02-18","TUE",2,3]
[null,"2020-02-19","WED",2,3]
[null,"2020-02-20","THU",2,3]
[null,"2020-02-21","FRI",3,1]
[null,"2020-02-22","SAT"]
[null,"2020-02-23","SUN",3,1]
[null,"2020-02-24","MON",1,2]
[null,"2020-02-25","TUE",1,2]
[null,"2020-02-26","WED",1,2]
[null,"2020-02-27","THU",2,3]
[null,"2020-02-28","FRI",2,3]
["MARCH-2020","2020-02-29","SAT"]
[null,"2020-03-01","SUN",3,1]
[null,"2020-03-02","MON",3,1]
[null,"2020-03-03","TUE",3,1]
[null,"2020-03-04","WED",1,2]
[null,"2020-03-05","THU",1,2]
[null,"2020-03-06","FRI",1,2]
[null,"2020-03-07","SAT"]
[null,"2020-03-08","SUN",2,3]
[null,"2020-03-09","MON",2,3]
[null,"2020-03-10","TUE",3,1]
[null,"2020-03-11","WED",3,1]
[null,"2020-03-12","THU",3,1]
[null,"2020-03-13","FRI",1,2]
[null,"2020-03-14","SAT"]
[null,"2020-03-15","SUN",1,2]
[null,"2020-03-16","MON",2,3]
[null,"2020-03-17","TUE",2,3]
[null,"2020-03-18","WED",2,3]
[null,"2020-03-19","THU",3,1]
[null,"2020-03-20","FRI",3,1]
[null,"2020-03-21","SAT"]
[null,"2020-03-22","SUN",1,2]
[null,"2020-03-23","MON",1,2]
[null,"2020-03-24","TUE",1,2]
[null,"2020-03-25","WED",2,3]
[null,"2020-03-26","THU",2,3]
[null,"2020-03-27","FRI",2,3]
[null,"2020-03-28","SAT"]
[null,"2020-03-29","SUN",3,1]
[null,"2020-03-30","MON",3,1]
["APRIL-2020","2020-03-31","TUE",1,2]
[null,"2020-04-01","WED",1,2]
[null,"2020-04-02","THU",1,2]
[null,"2020-04-03","FRI",2,3]
[null,"2020-04-04","SAT"]
[null,"2020-04-05","SUN",2,3]
[null,"2020-04-06","MON",3,1]
[null,"2020-04-07","TUE",3,1]
[null,"2020-04-08","WED",3,1]
[null,"2020-04-09","THU",1,2]
[null,"2020-04-10","FRI",1,2]
[null,"2020-04-11","SAT"]
[null,"2020-04-12","SUN",2,3]
[null,"2020-04-13","MON",2,3]
[null,"2020-04-14","TUE",2,3]
[null,"2020-04-15","WED",3,1]
[null,"2020-04-16","THU",3,1]
[null,"2020-04-17","FRI",3,1]
[null,"2020-04-18","SAT"]
[null,"2020-04-19","SUN",1,2]
[null,"2020-04-20","MON",1,2]
[null,"2020-04-21","TUE",2,3]
[null,"2020-04-22","WED",2,3]
[null,"2020-04-23","THU",2,3]
[null,"2020-04-24","FRI",3,1]
[null,"2020-04-25","SAT"]
[null,"2020-04-26","SUN",3,1]
[null,"2020-04-27","MON",1,2]
[null,"2020-04-28","TUE",1,2]
[null,"2020-04-29","WED",1,2]
["MAY-2020","2020-04-30","THU",2,3]
[null,"2020-05-01","FRI",2,3]
[null,"2020-05-02","SAT"]
[null,"2020-05-03","SUN",3,1]
[null,"2020-05-04","MON",3,1]
[null,"2020-05-05","TUE",3,1]
[null,"2020-05-06","WED",1,2]
[null,"2020-05-07","THU",1,2]
[null,"2020-05-08","FRI",1,2]
[null,"2020-05-09","SAT"]
[null,"2020-05-10","SUN",2,3]
[null,"2020-05-11","MON",2,3]
[null,"2020-05-12","TUE",3,1]
[null,"2020-05-13","WED",3,1]
[null,"2020-05-14","THU",3,1]
[null,"2020-05-15","FRI",1,2]
[null,"2020-05-16","SAT"]
[null,"2020-05-17","SUN",1,2]
[null,"2020-05-18","MON",2,3]
[null,"2020-05-19","TUE",2,3]
[null,"2020-05-20","WED",2,3]
[null,"2020-05-21","THU",3,1]
[null,"2020-05-22","FRI",3,1]
[null,"2020-05-23","SAT"]
[null,"2020-05-24","SUN",1,2]
[null,"2020-05-25","MON",1,2]
[null,"2020-05-26","TUE",1,2]
[null,"2020-05-27","WED",2,3]
[null,"2020-05-28","THU",2,3]
[null,"2020-05-29","FRI",2,3]
[null,"2020-05-30","SAT"]
["JUNE-2020","2020-05-31","SUN",3,1]
[null,"2020-06-01","MON",3,1]
[null,"2020-06-02","TUE",1,2]
[null,"2020-06-03","WED",1,2]
[null,"2020-06-04","THU",1,2]
[null,"2020-06-05","FRI",2,3]
[null,"2020-06-06","SAT"]
[null,"2020-06-07","SUN",2,3]
[null,"2020-06-08","MON",3,1]
[null,"2020-06-09","TUE",3,1]
[null,"2020-06-10","WED",3,1]
[null,"2020-06-11","THU",1,2]
[null,"2020-06-12","FRI",1,2]
[null,"2020-06-13","SAT"]
[null,"2020-06-14","SUN",2,3]
[null,"2020-06-15","MON",2,3]
[null,"2020-06-16","TUE",2,3]
[null,"2020-06-17","WED",3,1]
[null,"2020-06-18","THU",3,1]
[null,"2020-06-19","FRI",3,1]
[null,"2020-06-20","SAT"]
[null,"2020-06-21","SUN",1,2]
[null,"2020-06-22","MON",1,2]
[null,"2020-06-23","TUE",2,3]
[null,"2020-06-24","WED",2,3]
[null,"2020-06-25","THU",2,3]
[null,"2020-06-26","FRI",3,1]
[null,"2020-06-27","SAT"]
[null,"2020-06-28","SUN",3,1]
[null,"2020-06-29","MON",1,2]
["JULY-2020","2020-06-30","TUE",1,2]
[null,"2020-07-01","WED",1,2]
[null,"2020-07-02","THU",2,3]
[null,"2020-07-03","FRI",2,3]
[null,"2020-07-04","SAT"]
[null,"2020-07-05","SUN",3,1]
[null,"2020-07-06","MON",3,1]
[null,"2020-07-07","TUE",3,1]
[null,"2020-07-08","WED",1,2]
[null,"2020-07-09","THU",1,2]
[null,"2020-07-10","FRI",1,2]
[null,"2020-07-11","SAT"]
[null,"2020-07-12","SUN",2,3]
[null,"2020-07-13","MON",2,3]
[null,"2020-07-14","TUE",3,1]
[null,"2020-07-15","WED",3,1]
[null,"2020-07-16","THU",3,1]
[null,"2020-07-17","FRI",1,2]
[null,"2020-07-18","SAT"]
[null,"2020-07-19","SUN",1,2]
[null,"2020-07-20","MON",2,3]
[null,"2020-07-21","TUE",2,3]
[null,"2020-07-22","WED",2,3]
[null,"2020-07-23","THU",3,1]
[null,"2020-07-24","FRI",3,1]
[null,"2020-07-25","SAT"]
[null,"2020-07-26","SUN",1,2]
[null,"2020-07-27","MON",1,2]
[null,"2020-07-28","TUE",1,2]
[null,"2020-07-29","WED",2,3]
[null,"2020-07-30","THU",2,3]
["AUGUST-2020","2020-07-31","FRI",2,3]
[null,"2020-08-01","SAT"]
[null,"2020-08-02","SUN",3,1]
[null,"2020-08-03","MON",3,1]
[null,"2020-08-04","TUE",1,2]
[null,"2020-08-05","WED",1,2]
[null,"2020-08-06","THU",1,2]
[null,"2020-08-07","FRI",2,3]
[null,"2020-08-08","SAT"]
[null,"2020-08-09","SUN",2,3]
[null,"2020-08-10","MON",3,1]
[null,"2020-08-11","TUE",3,1]
[null,"2020-08-12","WED",3,1]
[null,"2020-08-13","THU",1,2]
[null,"2020-08-14","FRI",1,2]
[null,"2020-08-15","SAT"]
[null,"2020-08-16","SUN",2,3]
[null,"2020-08-17","MON",2,3]
[null,"2020-08-18","TUE",2,3]
[null,"2020-08-19","WED",3,1]
[null,"2020-08-20","THU",3,1]
[null,"2020-08-21","FRI",3,1]
[null,"2020-08-22","SAT"]
[null,"2020-08-23","SUN",1,2]
[null,"2020-08-24","MON",1,2]
[null,"2020-08-25","TUE",2,3]
[null,"2020-08-26","WED",2,3]
[null,"2020-08-27","THU",2,3]
[null,"2020-08-28","FRI",3,1]
[null,"2020-08-29","SAT"]
[null,"2020-08-30","SUN",3,1]
["SEPTEMBER-2020","2020-08-31","MON",1,2]
[null,"2020-09-01","TUE",1,2]
[null,"2020-09-02","WED",1,2]
[null,"2020-09-03","THU",2,3]
[null,"2020-09-04","FRI",2,3]
[null,"2020-09-05","SAT"]
[null,"2020-09-06","SUN",3,1]
[null,"2020-09-07","MON",3,1]
[null,"2020-09-08","TUE",3,1]
[null,"2020-09-09","WED",1,2]
[null,"2020-09-10","THU",1,2]
[null,"2020-09-11","FRI",1,2]
[null,"2020-09-12","SAT"]
[null,"2020-09-13","SUN",2,3]
[null,"2020-09-14","MON",2,3]
[null,"2020-09-15","TUE",3,1]
[null,"2020-09-16","WED",3,1]
[null,"2020-09-17","THU",3,1]
[null,"2020-09-18","FRI",1,2]
[null,"2020-09-19","SAT"]
[null,"2020-09-20","SUN",1,2]
[null,"2020-09-21","MON",2,3]
[null,"2020-09-22","TUE",2,3]
[null,"2020-09-23","WED",2,3]
[null,"2020-09-24","THU",3,1]
[null,"2020-09-25","FRI",3,1]
[null,"2020-09-26","SAT"]
[null,"2020-09-27","SUN",1,2]
[null,"2020-09-28","MON",1,2]
[null,"2020-09-29","TUE",1,2]
["OCTOBER-2020","2020-09-30","WED",2,3]
[null,"2020-10-01","THU",2,3]
[null,"2020-10-02","FRI",2,3]
[null,"2020-10-03","SAT"]
[null,"2020-10-04","SUN",3,1]
[null,"2020-10-05","MON",3,1]
[null,"2020-10-06","TUE",1,2]
[null,"2020-10-07","WED",1,2]
[null,"2020-10-08","THU",1,2]
[null,"2020-10-09","FRI",2,3]
[null,"2020-10-10","SAT"]
[null,"2020-10-11","SUN",2,3]
[null,"2020-10-12","MON",3,1]
[null,"2020-10-13","TUE",3,1]
[null,"2020-10-14","WED",3,1]
[null,"2020-10-15","THU",1,2]
[null,"2020-10-16","FRI",1,2]
[null,"2020-10-17","SAT"]
[null,"2020-10-18","SUN",2,3]
[null,"2020-10-19","MON",2,3]
[null,"2020-10-20","TUE",2,3]
[null,"2020-10-21","WED",3,1]
[null,"2020-10-22","THU",3,1]
[null,"2020-10-23","FRI",3,1]
[null,"2020-10-24","SAT"]
[null,"2020-10-25","SUN",1,2]
[null,"2020-10-26","MON",1,2]
[null,"2020-10-27","TUE",2,3]
[null,"2020-10-28","WED",2,3]
[null,"2020-10-29","THU",2,3]
[null,"2020-10-30","FRI",3,1]
["NOVEMBER-2020","2020-10-31","SAT"]
[null,"2020-11-01","SUN",3,1]
[null,"2020-11-02","MON",1,2]
[null,"2020-11-03","TUE",1,2]
[null,"2020-11-04","WED",1,2]
[null,"2020-11-05","THU",2,3]
[null,"2020-11-06","FRI",2,3]
[null,"2020-11-07","SAT"]
[null,"2020-11-08","SUN",3,1]
[null,"2020-11-09","MON",3,1]
[null,"2020-11-10","TUE",3,1]
[null,"2020-11-11","WED",1,2]
[null,"2020-11-12","THU",1,2]
[null,"2020-11-13","FRI",1,2]
[null,"2020-11-14","SAT"]
[null,"2020-11-15","SUN",2,3]
[null,"2020-11-16","MON",2,3]
[null,"2020-11-17","TUE",3,1]
[null,"2020-11-18","WED",3,1]
[null,"2020-11-19","THU",3,1]
[null,"2020-11-20","FRI",1,2]
[null,"2020-11-21","SAT"]
[null,"2020-11-22","SUN",1,2]
[null,"2020-11-23","MON",2,3]
[null,"2020-11-24","TUE",2,3]
[null,"2020-11-25","WED",2,3]
[null,"2020-11-26","THU",3,1]
[null,"2020-11-27","FRI",3,1]
[null,"2020-11-28","SAT"]
[null,"2020-11-29","SUN",1,2]
["DECEMBER-2020","2020-11-30","MON",1,2]
[null,"2020-12-01","TUE",1,2]
[null,"2020-12-02","WED",2,3]
[null,"2020-12-03","THU",2,3]
[null,"2020-12-04","FRI",2,3]
[null,"2020-12-05","SAT"]
[null,"2020-12-06","SUN",3,1]
[null,"2020-12-07","MON",3,1]
[null,"2020-12-08","TUE",1,2]
[null,"2020-12-09","WED",1,2]
[null,"2020-12-10","THU",1,2]
[null,"2020-12-11","FRI",2,3]
[null,"2020-12-12","SAT"]
[null,"2020-12-13","SUN",2,3]
[null,"2020-12-14","MON",3,1]
[null,"2020-12-15","TUE",3,1]
[null,"2020-12-16","WED",3,1]
[null,"2020-12-17","THU",1,2]
[null,"2020-12-18","FRI",1,2]
[null,"2020-12-19","SAT"]
[null,"2020-12-20","SUN",2,3]
[null,"2020-12-21","MON",2,3]
[null,"2020-12-22","TUE",2,3]
[null,"2020-12-23","WED",3,1]
[null,"2020-12-24","THU",3,1]
[null,"2020-12-25","FRI",3,1]
[null,"2020-12-26","SAT"]
[null,"2020-12-27","SUN",1,2]
[null,"2020-12-28","MON",1,2]
[null,"2020-12-29","TUE",2,3]
[null,"2020-12-30","WED",2,3]

{"sheet":"Data","index":3,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Roles"]
[null,"Residential Service Maintenance Manager"]
[null,"Residential Service Supervisor 1"]
[null,"Residential Service Supervisor 2"]
[null,"Residential Service Supervisor 3"]
[null,"Maintenance technician - Electrical 1"]
[null,"Maintenance technician - Electrical 2"]
[null,"Maintenance technician - Electrical 3"]
[null,"Maintenance technician - Mechanical 1"]
[null,"Maintenance technician - Mechanical 2"]
[null,"Maintenance technician - Mechanical 3"]
[null,"Maintenance technician - General 1"]
[null,"Maintenance technician - General 2"]
[null,"Maintenance technician - General 3"]