{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Employee View","Data","Notes"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Employee View","index":0,"n_rows":56,"n_cols":14,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[null,null,1,0,5.5555555555555552E-2]
[null,"Employee","Rank","Sat/Sun","Friday","M-Th","Days","Points","Done"]
[null,"Kali Zirkle",1,{"$f":"IF(C3>Data!$J$28,\"-\",IF(SUM(Data!E38:F38)=0,\"-\",SUM(Data!E38:F38)))","v":1},{"$f":"IF(C3>Data!$J$28,\"-\",IF(SUM(Data!G38:H38)=0,\"-\",SUM(Data!G38:H38)))","v":1},{"$f":"IF(C3>Data!$J$28,\"-\",IF(SUM(Data!I38:J38)=0,\"-\",SUM(Data!I38:J38)))","v":5},{"$f":"IF(SUM(D3:F3)=0,\"-\",SUM(D3:F3))","v":7},{"$f":"IF(SUM(D3:E3)=0,\"-\",SUM(D3:E3))","v":2},null,null,"Total Staff:",22]
[null,"Parker Conrad",2,{"$f":"IF(C4>Data!$J$28,\"-\",IF(SUM(Data!E39:F39)=0,\"-\",SUM(Data!E39:F39)))","v":1},{"$f":"IF(C4>Data!$J$28,\"-\",IF(SUM(Data!G39:H39)=0,\"-\",SUM(Data!G39:H39)))","v":1},{"$f":"IF(C4>Data!$J$28,\"-\",IF(SUM(Data!I39:J39)=0,\"-\",SUM(Data!I39:J39)))","v":5},7,2]
[null,"Dwayne Desmarais",3,{"$f":"IF(C5>Data!$J$28,\"-\",IF(SUM(Data!E40:F40)=0,\"-\",SUM(Data!E40:F40)))","v":1},{"$f":"IF(C5>Data!$J$28,\"-\",IF(SUM(Data!G40:H40)=0,\"-\",SUM(Data!G40:H40)))","v":1},{"$f":"IF(C5>Data!$J$28,\"-\",IF(SUM(Data!I40:J40)=0,\"-\",SUM(Data!I40:J40)))","v":5},7,2,null,null,"Start","2017-04-01"]
[null,"Ryan Cheek",4,{"$f":"IF(C6>Data!$J$28,\"-\",IF(SUM(Data!E41:F41)=0,\"-\",SUM(Data!E41:F41)))","v":1},{"$f":"IF(C6>Data!$J$28,\"-\",IF(SUM(Data!G41:H41)=0,\"-\",SUM(Data!G41:H41)))","v":1},{"$f":"IF(C6>Data!$J$28,\"-\",IF(SUM(Data!I41:J41)=0,\"-\",SUM(Data!I41:J41)))","v":5},7,2]
[null,"Daniel DeMarco",5,{"$f":"IF(C7>Data!$J$28,\"-\",IF(SUM(Data!E42:F42)=0,\"-\",SUM(Data!E42:F42)))","v":1},{"$f":"IF(C7>Data!$J$28,\"-\",IF(SUM(Data!G42:H42)=0,\"-\",SUM(Data!G42:H42)))","v":1},{"$f":"IF(C7>Data!$J$28,\"-\",IF(SUM(Data!I42:J42)=0,\"-\",SUM(Data!I42:J42)))","v":5},7,2,null,null,"End","2017-06-30"]
[null,"Matt Lacorazza",6,{"$f":"IF(C8>Data!$J$28,\"-\",IF(SUM(Data!E43:F43)=0,\"-\",SUM(Data!E43:F43)))","v":1},{"$f":"IF(C8>Data!$J$28,\"-\",IF(SUM(Data!G43:H43)=0,\"-\",SUM(Data!G43:H43)))","v":1},{"$f":"IF(C8>Data!$J$28,\"-\",IF(SUM(Data!I43:J43)=0,\"-\",SUM(Data!I43:J43)))","v":5},7,2]
[null,"Greg Rasmussen",7,{"$f":"IF(C9>Data!$J$28,\"-\",IF(SUM(Data!E44:F44)=0,\"-\",SUM(Data!E44:F44)))","v":1},{"$f":"IF(C9>Data!$J$28,\"-\",IF(SUM(Data!G44:H44)=0,\"-\",SUM(Data!G44:H44)))","v":1},{"$f":"IF(C9>Data!$J$28,\"-\",IF(SUM(Data!I44:J44)=0,\"-\",SUM(Data!I44:J44)))","v":5},7,2,null,null,"Bonus for working extra point shifts:",null,null,7]
[null,"Tim Ringwood",8,{"$f":"IF(C10>Data!$J$28,\"-\",IF(SUM(Data!E45:F45)=0,\"-\",SUM(Data!E45:F45)))","v":1},{"$f":"IF(C10>Data!$J$28,\"-\",IF(SUM(Data!G45:H45)=0,\"-\",SUM(Data!G45:H45)))","v":1},{"$f":"IF(C10>Data!$J$28,\"-\",IF(SUM(Data!I45:J45)=0,\"-\",SUM(Data!I45:J45)))","v":5},7,2]
[null,"Allison Barclay",9,{"$f":"IF(C11>Data!$J$28,\"-\",IF(SUM(Data!E46:F46)=0,\"-\",SUM(Data!E46:F46)))","v":1},{"$f":"IF(C11>Data!$J$28,\"-\",IF(SUM(Data!G46:H46)=0,\"-\",SUM(Data!G46:H46)))","v":1},{"$f":"IF(C11>Data!$J$28,\"-\",IF(SUM(Data!I46:J46)=0,\"-\",SUM(Data!I46:J46)))","v":5},7,2]
[null,"Stephen Bedsole",10,{"$f":"IF(C12>Data!$J$28,\"-\",IF(SUM(Data!E47:F47)=0,\"-\",SUM(Data!E47:F47)))","v":1},{"$f":"IF(C12>Data!$J$28,\"-\",IF(SUM(Data!G47:H47)=0,\"-\",SUM(Data!G47:H47)))","v":1},{"$f":"IF(C12>Data!$J$28,\"-\",IF(SUM(Data!I47:J47)=0,\"-\",SUM(Data!I47:J47)))","v":5},7,2]
[null,"Scott Bears",11,{"$f":"IF(C13>Data!$J$28,\"-\",IF(SUM(Data!E48:F48)=0,\"-\",SUM(Data!E48:F48)))","v":1},{"$f":"IF(C13>Data!$J$28,\"-\",IF(SUM(Data!G48:H48)=0,\"-\",SUM(Data!G48:H48)))","v":1},{"$f":"IF(C13>Data!$J$28,\"-\",IF(SUM(Data!I48:J48)=0,\"-\",SUM(Data!I48:J48)))","v":5},7,2]
[null,"Robert Patridge",12,{"$f":"IF(C14>Data!$J$28,\"-\",IF(SUM(Data!E49:F49)=0,\"-\",SUM(Data!E49:F49)))","v":1},{"$f":"IF(C14>Data!$J$28,\"-\",IF(SUM(Data!G49:H49)=0,\"-\",SUM(Data!G49:H49)))","v":1},{"$f":"IF(C14>Data!$J$28,\"-\",IF(SUM(Data!I49:J49)=0,\"-\",SUM(Data!I49:J49)))","v":5},7,2]
[null,"Dan Hamilton",13,{"$f":"IF(C15>Data!$J$28,\"-\",IF(SUM(Data!E50:F50)=0,\"-\",SUM(Data!E50:F50)))","v":1},{"$f":"IF(C15>Data!$J$28,\"-\",IF(SUM(Data!G50:H50)=0,\"-\",SUM(Data!G50:H50)))","v":1},{"$f":"IF(C15>Data!$J$28,\"-\",IF(SUM(Data!I50:J50)=0,\"-\",SUM(Data!I50:J50)))","v":5},7,2]
[null,"Sarah Katz",14,{"$f":"IF(C16>Data!$J$28,\"-\",IF(SUM(Data!E51:F51)=0,\"-\",SUM(Data!E51:F51)))","v":1},{"$f":"IF(C16>Data!$J$28,\"-\",IF(SUM(Data!G51:H51)=0,\"-\",SUM(Data!G51:H51)))","v":1},{"$f":"IF(C16>Data!$J$28,\"-\",IF(SUM(Data!I51:J51)=0,\"-\",SUM(Data!I51:J51)))","v":5},7,2]
[null,"Susan Pawlisheck",15,{"$f":"IF(C17>Data!$J$28,\"-\",IF(SUM(Data!E52:F52)=0,\"-\",SUM(Data!E52:F52)))","v":1},{"$f":"IF(C17>Data!$J$28,\"-\",IF(SUM(Data!G52:H52)=0,\"-\",SUM(Data!G52:H52)))","v":2},{"$f":"IF(C17>Data!$J$28,\"-\",IF(SUM(Data!I52:J52)=0,\"-\",SUM(Data!I52:J52)))","v":4},7,3,null,null,"Cameron Viveiros","Susan Pawlisheck"]
[null,"Nicholas Manos",16,{"$f":"IF(C18>Data!$J$28,\"-\",IF(SUM(Data!E53:F53)=0,\"-\",SUM(Data!E53:F53)))","v":1},{"$f":"IF(C18>Data!$J$28,\"-\",IF(SUM(Data!G53:H53)=0,\"-\",SUM(Data!G53:H53)))","v":2},{"$f":"IF(C18>Data!$J$28,\"-\",IF(SUM(Data!I53:J53)=0,\"-\",SUM(Data!I53:J53)))","v":4},7,3,null,null,"Sarah Katz","Nicholas Manos"]
[null,"Cameron Viveiros",17,{"$f":"IF(C19>Data!$J$28,\"-\",IF(SUM(Data!E54:F54)=0,\"-\",SUM(Data!E54:F54)))","v":1},{"$f":"IF(C19>Data!$J$28,\"-\",IF(SUM(Data!G54:H54)=0,\"-\",SUM(Data!G54:H54)))","v":2},{"$f":"IF(C19>Data!$J$28,\"-\",IF(SUM(Data!I54:J54)=0,\"-\",SUM(Data!I54:J54)))","v":4},7,3,null,null,"Tim Ringwood","Cameron Viveiros"]
[null,"Todd Graham",18,{"$f":"IF(C20>Data!$J$28,\"-\",IF(SUM(Data!E55:F55)=0,\"-\",SUM(Data!E55:F55)))","v":1},{"$f":"IF(C20>Data!$J$28,\"-\",IF(SUM(Data!G55:H55)=0,\"-\",SUM(Data!G55:H55)))","v":2},{"$f":"IF(C20>Data!$J$28,\"-\",IF(SUM(Data!I55:J55)=0,\"-\",SUM(Data!I55:J55)))","v":4},7,3,null,null,"Scott Bears","Todd Graham"]
[null,"Colin O'kane",19,{"$f":"IF(C21>Data!$J$28,\"-\",IF(SUM(Data!E56:F56)=0,\"-\",SUM(Data!E56:F56)))","v":2},{"$f":"IF(C21>Data!$J$28,\"-\",IF(SUM(Data!G56:H56)=0,\"-\",SUM(Data!G56:H56)))","v":1},{"$f":"IF(C21>Data!$J$28,\"-\",IF(SUM(Data!I56:J56)=0,\"-\",SUM(Data!I56:J56)))","v":4},7,3,null,null,"Greg Rasmussen","Colin O'kane"]
[null,"Kristi McDowell",20,{"$f":"IF(C22>Data!$J$28,\"-\",IF(SUM(Data!E57:F57)=0,\"-\",SUM(Data!E57:F57)))","v":2},{"$f":"IF(C22>Data!$J$28,\"-\",IF(SUM(Data!G57:H57)=0,\"-\",SUM(Data!G57:H57)))","v":1},{"$f":"IF(C22>Data!$J$28,\"-\",IF(SUM(Data!I57:J57)=0,\"-\",SUM(Data!I57:J57)))","v":4},7,3,null,null,"Matt Lacorazza","Kristi McDowell"]
[null,"Dieter Erkstrom",21,{"$f":"IF(C23>Data!$J$28,\"-\",IF(SUM(Data!E58:F58)=0,\"-\",SUM(Data!E58:F58)))","v":2},{"$f":"IF(C23>Data!$J$28,\"-\",IF(SUM(Data!G58:H58)=0,\"-\",SUM(Data!G58:H58)))","v":1},{"$f":"IF(C23>Data!$J$28,\"-\",IF(SUM(Data!I58:J58)=0,\"-\",SUM(Data!I58:J58)))","v":5},8,3,null,null,"Parker Conrad","Dieter Erkstrom"]
[null,"Peter Brefini",22,{"$f":"IF(C24>Data!$J$28,\"-\",IF(SUM(Data!E59:F59)=0,\"-\",SUM(Data!E59:F59)))","v":2},{"$f":"IF(C24>Data!$J$28,\"-\",IF(SUM(Data!G59:H59)=0,\"-\",SUM(Data!G59:H59)))","v":1},{"$f":"IF(C24>Data!$J$28,\"-\",IF(SUM(Data!I59:J59)=0,\"-\",SUM(Data!I59:J59)))","v":5},8,3,null,null,"Dan Hamilton","Peter Brefini"]
[null,null,23,{"$f":"IF(C25>Data!$J$28,\"-\",IF(SUM(Data!E60:F60)=0,\"-\",SUM(Data!E60:F60)))","v":"-"},{"$f":"IF(C25>Data!$J$28,\"-\",IF(SUM(Data!G60:H60)=0,\"-\",SUM(Data!G60:H60)))","v":"-"},{"$f":"IF(C25>Data!$J$28,\"-\",IF(SUM(Data!I60:J60)=0,\"-\",SUM(Data!I60:J60)))","v":"-"},{"$f":"IF(SUM(D25:F25)=0,\"-\",SUM(D25:F25))","v":"-"},{"$f":"IF(SUM(D25:E25)=0,\"-\",SUM(D25:E25))","v":"-"}]
[null,null,24,{"$f":"IF(C26>Data!$J$28,\"-\",IF(SUM(Data!E61:F61)=0,\"-\",SUM(Data!E61:F61)))","v":"-"},{"$f":"IF(C26>Data!$J$28,\"-\",IF(SUM(Data!G61:H61)=0,\"-\",SUM(Data!G61:H61)))","v":"-"},{"$f":"IF(C26>Data!$J$28,\"-\",IF(SUM(Data!I61:J61)=0,\"-\",SUM(Data!I61:J61)))","v":"-"},"-","-"]
[null,null,25,{"$f":"IF(C27>Data!$J$28,\"-\",IF(SUM(Data!E62:F62)=0,\"-\",SUM(Data!E62:F62)))","v":"-"},{"$f":"IF(C27>Data!$J$28,\"-\",IF(SUM(Data!G62:H62)=0,\"-\",SUM(Data!G62:H62)))","v":"-"},{"$f":"IF(C27>Data!$J$28,\"-\",IF(SUM(Data!I62:J62)=0,\"-\",SUM(Data!I62:J62)))","v":"-"},"-","-"]
[null,null,26,{"$f":"IF(C28>Data!$J$28,\"-\",IF(SUM(Data!E63:F63)=0,\"-\",SUM(Data!E63:F63)))","v":"-"},{"$f":"IF(C28>Data!$J$28,\"-\",IF(SUM(Data!G63:H63)=0,\"-\",SUM(Data!G63:H63)))","v":"-"},{"$f":"IF(C28>Data!$J$28,\"-\",IF(SUM(Data!I63:J63)=0,\"-\",SUM(Data!I63:J63)))","v":"-"},"-","-"]
[null,null,27,{"$f":"IF(C29>Data!$J$28,\"-\",IF(SUM(Data!E64:F64)=0,\"-\",SUM(Data!E64:F64)))","v":"-"},{"$f":"IF(C29>Data!$J$28,\"-\",IF(SUM(Data!G64:H64)=0,\"-\",SUM(Data!G64:H64)))","v":"-"},{"$f":"IF(C29>Data!$J$28,\"-\",IF(SUM(Data!I64:J64)=0,\"-\",SUM(Data!I64:J64)))","v":"-"},"-","-"]
[null,null,28,{"$f":"IF(C30>Data!$J$28,\"-\",IF(SUM(Data!E65:F65)=0,\"-\",SUM(Data!E65:F65)))","v":"-"},{"$f":"IF(C30>Data!$J$28,\"-\",IF(SUM(Data!G65:H65)=0,\"-\",SUM(Data!G65:H65)))","v":"-"},{"$f":"IF(C30>Data!$J$28,\"-\",IF(SUM(Data!I65:J65)=0,\"-\",SUM(Data!I65:J65)))","v":"-"},"-","-"]
[null,null,29,{"$f":"IF(C31>Data!$J$28,\"-\",IF(SUM(Data!E66:F66)=0,\"-\",SUM(Data!E66:F66)))","v":"-"},{"$f":"IF(C31>Data!$J$28,\"-\",IF(SUM(Data!G66:H66)=0,\"-\",SUM(Data!G66:H66)))","v":"-"},{"$f":"IF(C31>Data!$J$28,\"-\",IF(SUM(Data!I66:J66)=0,\"-\",SUM(Data!I66:J66)))","v":"-"},"-","-"]
[null,null,30,{"$f":"IF(C32>Data!$J$28,\"-\",IF(SUM(Data!E67:F67)=0,\"-\",SUM(Data!E67:F67)))","v":"-"},{"$f":"IF(C32>Data!$J$28,\"-\",IF(SUM(Data!G67:H67)=0,\"-\",SUM(Data!G67:H67)))","v":"-"},{"$f":"IF(C32>Data!$J$28,\"-\",IF(SUM(Data!I67:J67)=0,\"-\",SUM(Data!I67:J67)))","v":"-"},{"$f":"IF(SUM(D32:F32)=0,\"-\",SUM(D32:F32))","v":"-"},{"$f":"IF(SUM(D32:E32)=0,\"-\",SUM(D32:E32))","v":"-"}]
[]
[null,null,"Tenure/Bonus",null,null,null,null,"Rank"]
[0,"Kali Zirkle",11,true,0.35849056603773582,0.42767295597484273,6.9182389937106917E-2,1]
[0,"Parker Conrad",11,true,0.31081081081081086,0.3851351351351352,7.4324324324324328E-2,2]
[0,"Dwayne Desmarais",5,true,0.18248175182481752,0.21897810218978103,3.6496350364963501E-2,3]
[0,"Ryan Cheek",8,true,0.8181818181818179,0.87878787878787845,6.0606060606060608E-2,4]
[0,"Daniel DeMarco",6,true,0.10483870967741934,0.15322580645161288,4.8387096774193547E-2,5]
[0,"Matt Lacorazza",10,true,0.3559322033898305,0.44067796610169491,8.4745762711864403E-2,6]
[0,"Greg Rasmussen",9,true,0.52777777777777779,0.61111111111111116,8.3333333333333329E-2,7]
[0,"Tim Ringwood",10,true,0.45454545454545447,0.55555555555555547,0.10101010101010101,8]
[0,"Allison Barclay",9,true,0.6292134831460674,0.7303370786516854,0.10112359550561797,9]
[0,"Stephen Bedsole",6,true,8.7499999999999994E-2,0.16249999999999998,7.4999999999999997E-2,10]
[3,"Scott Bears",11,true,0.24324324324324326,0.39189189189189189,0.14864864864864866,11]
[3,"Robert Patridge",7,true,0,0.1111111111111111,0.1111111111111111,12]
[3,"Dan Hamilton",8,true,0.71428571428571419,0.85714285714285698,0.14285714285714285,13]
[3,"Sarah Katz",8,true,0.83333333333333337,1,0.16666666666666666,14]
[3,"Susan Pawlisheck",4,true,0.27500000000000002,0.375,0.1,15]
[3,"Nicholas Manos",5,true,0.16666666666666666,0.30555555555555558,0.1388888888888889,16]
[3,"Cameron Viveiros",8,true,0.74193548387096775,1,0.25806451612903225,17]
[3,"Todd Graham",6,true,0,0.2608695652173913,0.2608695652173913,18]
[3,"Colin O'kane",2,true,0.35294117647058826,0.47058823529411764,0.11764705882352941,19]
[3,"Kristi McDowell",3,true,0.2,0.4,0.2,20]
[3,"Dieter Erkstrom",9,true,0.25,1,0.75,21]
[3,"Peter Brefini",3,true,0,1,1,22]

{"sheet":"Data","index":1,"n_rows":68,"n_cols":15,"rows_kept":68,"cut":false,"hidden":false,"merged":[[35,8,35,12],[35,6,35,7],[35,4,35,5]]}
[]
[null,"#","Employee Name:","Tenure:","Last Rank:","Weight:",null,null,"Calculations:",null,null,null,"To Generate List Enter \"1\" ->"]
[null,1,"Robert Patridge",7,{"$f":"IFERROR(IF(VLOOKUP(C3,'Employee View'!B3:H32,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C3:H32,6,FALSE),0,'Employee View'!$N$9),0)","v":0},{"$f":"SUM(D3:E3)","v":7},null,"Days/People left:"]
[null,2,"Stephen Bedsole",6,{"$f":"IFERROR(IF(VLOOKUP(C4,'Employee View'!B4:H33,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C4:H33,6,FALSE),0,'Employee View'!$N$9),0)","v":0},{"$f":"SUM(D4:E4)","v":6},null,"Sat/Sun","Friday","M-Th",null,"Values:","Blank = Reset"]
[null,3,"Daniel DeMarco",6,{"$f":"IFERROR(IF(VLOOKUP(C5,'Employee View'!B5:H34,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C5:H34,6,FALSE),0,'Employee View'!$N$9),0)","v":0},6,null,{"$f":"MOD(L30,J28)","v":4},{"$f":"MOD(M30,J28)","v":4},{"$f":"MOD(N30,J28)","v":16},null,null,"0 = Update table with current ranks"]
[null,4,"Todd Graham",6,{"$f":"IFERROR(IF(VLOOKUP(C6,'Employee View'!B6:H35,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C6:H35,6,FALSE),0,'Employee View'!$N$9),0)","v":7},13,null,null,null,null,null,null,"1 = Generate new random list"]
[null,5,"Dwayne Desmarais",5,{"$f":"IFERROR(IF(VLOOKUP(C7,'Employee View'!B7:H36,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C7:H36,6,FALSE),0,'Employee View'!$N$9),0)","v":0},5,null,"People - Sdays",null,{"$f":"J28-L30","v":-4}]
[null,6,"Nicholas Manos",5,{"$f":"IFERROR(IF(VLOOKUP(C8,'Employee View'!B8:H37,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C8:H37,6,FALSE),0,'Employee View'!$N$9),0)","v":7},12,null,"People - Fdays",null,{"$f":"J28-M30","v":-4}]
[null,7,"Scott Bears",4,{"$f":"IFERROR(IF(VLOOKUP(C9,'Employee View'!B9:H38,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C9:H38,6,FALSE),0,'Employee View'!$N$9),0)","v":0},4,null,"INT(Fdays/People)",null,{"$f":"INT(M30/J28)","v":1}]
[null,8,"Parker Conrad",4,{"$f":"IFERROR(IF(VLOOKUP(C10,'Employee View'!B10:H39,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C10:H39,6,FALSE),0,'Employee View'!$N$9),0)","v":0},4,null,"INT(Sdays/People)",null,{"$f":"INT(L30/J28)","v":1}]
[null,9,"Kali Zirkle",4,{"$f":"IFERROR(IF(VLOOKUP(C11,'Employee View'!B11:H40,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C11:H40,6,FALSE),0,'Employee View'!$N$9),0)","v":0},4,null,"People - Sdays Left",null,{"$f":"J28-H5","v":18}]
[null,10,"Susan Pawlisheck",4,{"$f":"IFERROR(IF(VLOOKUP(C12,'Employee View'!B12:H41,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C12:H41,6,FALSE),0,'Employee View'!$N$9),0)","v":7},11,null,"PPL - S/S & F Ds Lft",null,{"$f":"$J$28-$H$5-$I$5","v":14}]
[null,11,"Peter Brefini",3,{"$f":"IFERROR(IF(VLOOKUP(C13,'Employee View'!B13:H42,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C13:H42,6,FALSE),0,'Employee View'!$N$9),0)","v":7},10,null,"More PPL - S/F shft",null,{"$f":"J28-L30+J28-M30","v":-8}]
[null,12,"Matt Lacorazza",3,{"$f":"IFERROR(IF(VLOOKUP(C14,'Employee View'!B14:H43,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C14:H43,6,FALSE),0,'Employee View'!$N$9),0)","v":7},10,null,"F lft - (ppl - S lft)",null,{"$f":"I5-(J28-H5)","v":-14}]
[null,13,"Kristi McDowell",3,{"$f":"IFERROR(IF(VLOOKUP(C15,'Employee View'!B15:H44,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C15:H44,6,FALSE),0,'Employee View'!$N$9),0)","v":7},10,null,"PPl - S/S Days left",null,{"$f":"J28-H5","v":18}]
[null,14,"Tim Ringwood",3,{"$f":"IFERROR(IF(VLOOKUP(C16,'Employee View'!B16:H45,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C16:H45,6,FALSE),0,'Employee View'!$N$9),0)","v":7},10,null,"PPL - Fri Days Left",null,{"$f":"J28-I5","v":18}]
[null,15,"Colin O'kane",2,{"$f":"IFERROR(IF(VLOOKUP(C17,'Employee View'!B17:H46,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C17:H46,6,FALSE),0,'Employee View'!$N$9),0)","v":7},9,null,"ppl - (ppl - s/f ds l)",null,{"$f":"J28-(J28-J16-J15)","v":36}]
[null,16,"Greg Rasmussen",2,{"$f":"IFERROR(IF(VLOOKUP(C18,'Employee View'!B18:H47,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C18:H47,6,FALSE),0,'Employee View'!$N$9),0)","v":7},9]
[null,17,"Dieter Erkstrom",2,{"$f":"IFERROR(IF(VLOOKUP(C19,'Employee View'!B19:H48,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C19:H48,6,FALSE),0,'Employee View'!$N$9),0)","v":7},9]
[null,18,"Allison Barclay",2,{"$f":"IFERROR(IF(VLOOKUP(C20,'Employee View'!B20:H49,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C20:H49,6,FALSE),0,'Employee View'!$N$9),0)","v":7},9]
[null,19,"Cameron Viveiros",1,{"$f":"IFERROR(IF(VLOOKUP(C21,'Employee View'!B21:H50,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C21:H50,6,FALSE),0,'Employee View'!$N$9),0)","v":0},1]
[null,20,"Ryan Cheek",1,{"$f":"IFERROR(IF(VLOOKUP(C22,'Employee View'!B22:H51,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C22:H51,6,FALSE),0,'Employee View'!$N$9),0)","v":7},8]
[null,21,"Dan Hamilton",1,{"$f":"IFERROR(IF(VLOOKUP(C23,'Employee View'!B23:H52,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C23:H52,6,FALSE),0,'Employee View'!$N$9),0)","v":7},8]
[null,22,"Sarah Katz",1,{"$f":"IFERROR(IF(VLOOKUP(C24,'Employee View'!B24:H53,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C24:H53,6,FALSE),0,'Employee View'!$N$9),0)","v":7},8,null,"Start Date:",null,{"$f":"'Employee View'!L5","v":"2017-04-01"},null,"Late Shift Staffing:"]
[null,23,null,0,{"$f":"IFERROR(IF(VLOOKUP(C25,'Employee View'!B25:H54,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C25:H54,6,FALSE),0,'Employee View'!$N$9),0)","v":0},0,null,null,null,null,null,"Sat/Sun",null,1]
[null,24,null,0,{"$f":"IFERROR(IF(VLOOKUP(C26,'Employee View'!B26:H55,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C26:H55,6,FALSE),0,'Employee View'!$N$9),0)","v":0},0,null,"End Date:",null,{"$f":"'Employee View'!L7","v":"2017-06-30"},null,"M-F",null,2]
[null,25,null,0,{"$f":"IFERROR(IF(VLOOKUP(C27,'Employee View'!B27:H56,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C27:H56,6,FALSE),0,'Employee View'!$N$9),0)","v":0},0]
[null,26,null,0,{"$f":"IFERROR(IF(VLOOKUP(C28,'Employee View'!B28:H57,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C28:H57,6,FALSE),0,'Employee View'!$N$9),0)","v":0},0,null,"Total Employees:",null,{"$f":"'Employee View'!L3","v":22},null,"Late Shifts:"]
[null,27,null,0,{"$f":"IFERROR(IF(VLOOKUP(C29,'Employee View'!B29:H58,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C29:H58,6,FALSE),0,'Employee View'!$N$9),0)","v":0},0,null,null,null,null,null,"Sat/Sun","Fri","M-Th"]
[null,28,null,0,{"$f":"IFERROR(IF(VLOOKUP(C30,'Employee View'!B30:H59,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C30:H59,6,FALSE),0,'Employee View'!$N$9),0)","v":0},0,null,null,null,null,null,{"$f":"N25*(L33+M33)","v":26},{"$f":"K33*N26","v":26},{"$f":"SUM(G33:J33)*N26","v":104}]
[null,29,null,0,{"$f":"IFERROR(IF(VLOOKUP(C31,'Employee View'!B31:H60,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C31:H60,6,FALSE),0,'Employee View'!$N$9),0)","v":0},0,null,"Break down of days:"]
[null,30,null,0,{"$f":"IFERROR(IF(VLOOKUP(C32,'Employee View'!B32:H61,7,FALSE)<VLOOKUP('Employee View'!$L$3,'Employee View'!C32:H61,6,FALSE),0,'Employee View'!$N$9),0)","v":0},0,null,"Mon","Tues","Wed","Thurs","Fri","Sat","Sun"]
[null,null,null,null,null,null,{"$f":"SUMPRODUCT(N(TEXT(ROW(INDIRECT(J24&\":\"&EOMONTH(J26,0))),\"ddd\")=\"Mon\"))","v":13},{"$f":"SUMPRODUCT(N(TEXT(ROW(INDIRECT(J24&\":\"&EOMONTH(J26,0))),\"ddd\")=\"Tue\"))","v":13},{"$f":"SUMPRODUCT(N(TEXT(ROW(INDIRECT(J24&\":\"&EOMONTH(J26,0))),\"ddd\")=\"Wed\"))","v":13},{"$f":"SUMPRODUCT(N(TEXT(ROW(INDIRECT(J24&\":\"&EOMONTH(J26,0))),\"ddd\")=\"Thu\"))","v":13},{"$f":"SUMPRODUCT(N(TEXT(ROW(INDIRECT(J24&\":\"&EOMONTH(J26,0))),\"ddd\")=\"Fri\"))","v":13},{"$f":"SUMPRODUCT(N(TEXT(ROW(INDIRECT(J24&\":\"&EOMONTH(J26,0))),\"ddd\")=\"Sat\"))","v":13},{"$f":"SUMPRODUCT(N(TEXT(ROW(INDIRECT(J24&\":\"&EOMONTH(J26,0))),\"ddd\")=\"Sun\"))","v":13}]
[]
[]
[null,null,null,"Draft","Sat/Sun",null,"Friday",null,"M-Th",null,null,null,null,"Days","Points"]
[null,null,null,"Position","Round 1","Round 2","Round 1","Round 2","Round 1","Round 2","Round 3","Round 4","Round 5"]
[null,null,null,1,{"$f":"IF($J$28>$L$30,IF(D38<= ($J$28-$L$30),\"-\",IF(D38>$J$28,\"-\",INT($J$28/$L$30))),IF(D38>$J$28,\"-\",$J$10))","v":1},{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D38<=($J$28-$H$5),\"-\",IF(D38>$J$28,\"-\",1)))","v":"-"},{"$f":"IF($J$28>$M$30,IF(D38<=($J$7),IF(D38>$J$28,\"-\",1),IF(D38>($J$7+$J$8),IF(D38>$J$28,\"-\",1),\"-\")),IF(D38>$J$28,\"-\",$J$9))","v":1},{"$f":"IF($J$28>$L$30,\"-\",IF(D38<=($J$11-$I$5),\"-\",IF(D38>($J$11),IF(D38<=($J$11*2),\"-\",IF(D38>$J$28,\"-\",IF($I$5=0,\"-\",1))),1)))","v":"-"},{"$f":"IF($J$28>$N$30,IF(D38<= ($J$28-$N$30),0,IF(D38>$J$28,\"-\",INT($J$28/$N$30))),IF(D38>$J$28,\"-\",INT($N$30/$J$28)))","v":4},{"$f":"IF($J$5<=$J$12,IF(D38<=$J$5,1,\"-\"),IF($J$5<=$J$13,1,IF(D38<=($J$28-($J$28-$J$12)),1,IF(D38<=($J$28-$J$5+$J$12),\"-\",IF(D38>$J$28,\"-\",IF(D38>$J$28-$J$14,IF(D38>$J$17,IF(D38<=($J$28-($J$5-($J$28-$J$14))),\"-\",IF(D38>$J$28,\"-\",1))),IF(D38>$J$28,\"-\",1)))))))","v":1},null,null,null,{"$f":"IF(D38>$J$28,\"-\",SUM(E38:M38))","v":7},{"$f":"IF(D38>$J$28,\"-\",SUM(E38:H38))","v":2}]
[null,null,null,2,1,{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D39<=($J$28-$H$5),\"-\",IF(D39>$J$28,\"-\",1)))","v":"-"},1,"-",4,1,null,null,null,7,2]
[null,null,null,3,1,{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D40<=($J$28-$H$5),\"-\",IF(D40>$J$28,\"-\",1)))","v":"-"},1,"-",4,1,null,null,null,7,2]
[null,null,null,4,1,{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D41<=($J$28-$H$5),\"-\",IF(D41>$J$28,\"-\",1)))","v":"-"},1,"-",4,1,null,null,null,7,2]
[null,null,null,5,1,{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D42<=($J$28-$H$5),\"-\",IF(D42>$J$28,\"-\",1)))","v":"-"},1,"-",4,1,null,null,null,7,2]
[null,null,null,6,1,{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D43<=($J$28-$H$5),\"-\",IF(D43>$J$28,\"-\",1)))","v":"-"},1,"-",4,1,null,null,null,7,2]
[null,null,null,7,1,{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D44<=($J$28-$H$5),\"-\",IF(D44>$J$28,\"-\",1)))","v":"-"},1,"-",4,1,null,null,null,7,2]
[null,null,null,8,1,{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D45<=($J$28-$H$5),\"-\",IF(D45>$J$28,\"-\",1)))","v":"-"},1,"-",4,1,null,null,null,7,2]
[null,null,null,9,1,{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D46<=($J$28-$H$5),\"-\",IF(D46>$J$28,\"-\",1)))","v":"-"},1,"-",4,1,null,null,null,7,2]
[null,null,null,10,1,{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D47<=($J$28-$H$5),\"-\",IF(D47>$J$28,\"-\",1)))","v":"-"},1,"-",4,1,null,null,null,7,2]
[null,null,null,11,1,{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D48<=($J$28-$H$5),\"-\",IF(D48>$J$28,\"-\",1)))","v":"-"},1,"-",4,1,null,null,null,7,2]
[null,null,null,12,1,{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D49<=($J$28-$H$5),\"-\",IF(D49>$J$28,\"-\",1)))","v":"-"},1,"-",4,1,null,null,null,7,2]
[null,null,null,13,1,{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D50<=($J$28-$H$5),\"-\",IF(D50>$J$28,\"-\",1)))","v":"-"},1,"-",4,1,null,null,null,7,2]
[null,null,null,14,1,{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D51<=($J$28-$H$5),\"-\",IF(D51>$J$28,\"-\",1)))","v":"-"},1,"-",4,1,null,null,null,7,2]
[null,null,null,15,1,{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D52<=($J$28-$H$5),\"-\",IF(D52>$J$28,\"-\",1)))","v":"-"},1,1,4,"-",null,null,null,7,3]
[null,null,null,16,1,{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D53<=($J$28-$H$5),\"-\",IF(D53>$J$28,\"-\",1)))","v":"-"},1,1,4,"-",null,null,null,7,3]
[null,null,null,17,1,{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D54<=($J$28-$H$5),\"-\",IF(D54>$J$28,\"-\",1)))","v":"-"},1,1,4,"-",null,null,null,7,3]
[null,null,null,18,1,{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D55<=($J$28-$H$5),\"-\",IF(D55>$J$28,\"-\",1)))","v":"-"},1,1,4,"-",null,null,null,7,3]
[null,null,null,19,1,{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D56<=($J$28-$H$5),\"-\",IF(D56>$J$28,\"-\",1)))","v":1},1,"-",4,"-",null,null,null,7,3]
[null,null,null,20,1,{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D57<=($J$28-$H$5),\"-\",IF(D57>$J$28,\"-\",1)))","v":1},1,"-",4,"-",null,null,null,7,3]
[null,null,null,21,1,{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D58<=($J$28-$H$5),\"-\",IF(D58>$J$28,\"-\",1)))","v":1},1,"-",4,1,null,null,null,8,3]
[null,null,null,22,1,{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D59<=($J$28-$H$5),\"-\",IF(D59>$J$28,\"-\",1)))","v":1},1,"-",4,1,null,null,null,8,3]
[null,null,null,23,"-",{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D60<=($J$28-$H$5),\"-\",IF(D60>$J$28,\"-\",1)))","v":"-"},"-","-","-","-",null,null,null,"-","-"]
[null,null,null,24,"-",{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D61<=($J$28-$H$5),\"-\",IF(D61>$J$28,\"-\",1)))","v":"-"},"-","-","-","-",null,null,null,"-","-"]
[null,null,null,25,"-",{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D62<=($J$28-$H$5),\"-\",IF(D62>$J$28,\"-\",1)))","v":"-"},"-","-","-","-",null,null,null,"-","-"]
[null,null,null,26,"-",{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D63<=($J$28-$H$5),\"-\",IF(D63>$J$28,\"-\",1)))","v":"-"},"-","-","-","-",null,null,null,"-","-"]
[null,null,null,27,"-",{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D64<=($J$28-$H$5),\"-\",IF(D64>$J$28,\"-\",1)))","v":"-"},"-","-","-","-",null,null,null,"-","-"]
[null,null,null,28,"-",{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D65<=($J$28-$H$5),\"-\",IF(D65>$J$28,\"-\",1)))","v":"-"},"-","-","-","-",null,null,null,"-","-"]
[null,null,null,29,"-",{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D66<=($J$28-$H$5),\"-\",IF(D66>$J$28,\"-\",1)))","v":"-"},"-","-","-","-",null,null,null,"-","-"]
[null,null,null,30,"-",{"$f":"IF($J$28>Data!$L$30,\"-\",IF(D67<=($J$28-$H$5),\"-\",IF(D67>$J$28,\"-\",1)))","v":"-"},"-","-","-","-",null,null,null,"-","-"]
[null,null,null,"Totals:",null,{"$f":"SUM(E38:E67)+SUM(F38:F67)","v":26},null,{"$f":"SUM(G38:G67)+SUM(H38:H67)","v":26},null,null,{"$f":"SUM(J38:J67)+SUM(K38:K67)+SUM(I38:I67)","v":104}]

{"sheet":"Notes","index":2,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Calculations:"]
[]
["Start Date:"]
["End Date:"]
[null,"How it works:"]
["Total Staff:"]
[null,null,"Sat/Sun",null,"Fridays",null,"M-Th"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Concept:","Designed to assign shifts out evenly then split remainder of shifts from bottom up based on lowest pick/point value"]
[null,null,null,"ratios.  The lowest rank receives the least options to pick from, and the least desireable shifts to pick from, as a result"]
[null,null,null,"they receive the most points possible.  Points are distributed as evenly as possible resulting in first group receiving"]
[null,null,null,"the least points but the best shift pick options.  If no point shifts are available (middle of list generally), your 'reward' "]
[null,null,null,"for picking lower with fewer options is to pick 1 less day if possible."]
[]
[]
[null,null,null," Evenly distributed Sat/Sun shifts"]
[null,null,null,"Distributes remaining Sat/Sun shifts bottom up"]
[null,null,null,"Evenly distributes Friday shifts"]
[null,null,null,"Distributes remaining Friday shifts from bottom up, starting AFTER remaining Sat/Sun are assigned"]
[null,null,null,"Evenly distributes M-Th shifts"]
[null,null,null,"Distributes remaining M-Th shifts from top down"]
[null,null,null,"Possible 1 less day for picking in the middle, with less options"]
[null,null,null,"Possible overflow of remaining Fridays assigned from bottom up only if",null,null,null,null,null,null,null,"and"]
[null,null,null,"are more than total number of current staff"]
[null,null,null,null,"Example:","Total Staff:",null,null,17]
[null,null,null,null,null,"Remaining Sat/Sun shifts:",null,null,10,"assign to",null,"like normal"]
[null,null,null,null,null,"Remaining Friday shifts:",null,null,10,"assign 7 first to the"]
[null,null,null,null,null,null,null,null,null,"then remaining 3 to",null,null,"based on bottom up ranking"]
[]
[null,null,null,"Same concept as in",null,null,"scenario, fill M-Th top down then bottom up if necessary for the extra remaining days"]