{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Employee Hours","Employee Availability","Employee Preference","Assignments"],"not_rendered":{"defined_names":89,"comments":3},"read":"whole","date_system":"1900"}

{"sheet":"Employee Hours","index":0,"n_rows":7,"n_cols":4,"rows_kept":7,"merged":[[0,1,0,2]]}
[null,"Shifts/Week"]
["Employee","Min","Max","Scheduled to work"]
[1,8,12,{"$f":"Assignments!U6","v":12}]
[{"$f":"1+A3","v":2},8,12,{"$f":"Assignments!U7","v":12}]
[{"$f":"1+A4","v":3},8,12,{"$f":"Assignments!U8","v":11}]
[4,4,8,{"$f":"Assignments!U9","v":8}]
["SUM",{"$f":"SUM(B3:B6)","v":28},{"$f":"SUM(C3:C6)","v":44}]

{"sheet":"Employee Availability","index":1,"n_rows":8,"n_cols":21,"rows_kept":8,"merged":[[0,2,0,7],[0,8,0,13],[0,14,0,19],[0,20,0,25],[0,26,0,31],[0,32,0,37],[0,38,0,43]]}
["Day of Week",null,"Sunday",{"$nulls":5},"Monday",{"$nulls":5},"Tuesday"]
["Shift of Day",null,1,{"$f":"MOD(C2,6)+1","v":2},{"$f":"MOD(D2,6)+1","v":3},4,5,6,1,2,3,4,5,6,1,2,3,4,5,6]
["Readable Shift",null,"12AM-4AM","4AM-8AM","8AM-Noon","Noon-4PM","4PM-8PM","8PM-12AM","12AM-4AM","4AM-8AM","8AM-Noon","Noon-4PM","4PM-8PM","8PM-12AM","12AM-4AM","4AM-8AM","8AM-Noon","Noon-4PM","4PM-8PM","8PM-12AM"]
[null,"Employee",{"$nulls":18},"SUM"]
[null,1,1,1,1,1,1,1,0,1,1,1,1,1,1,1,1,1,1,1,{"$f":"SUM(C5:T5)","v":17}]
[null,2,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,1,{"$f":"SUM(C6:T6)","v":17}]
[null,3,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,18]
[null,4,1,0,1,1,1,1,1,1,1,1,1,1,1,1,0,1,1,1,16]

{"sheet":"Employee Preference","index":2,"n_rows":8,"n_cols":24,"rows_kept":8,"merged":[[0,2,0,7],[0,8,0,13],[0,14,0,19],[0,20,0,25],[0,26,0,31],[0,32,0,37],[0,38,0,43],[2,20,2,21],[2,22,2,23],[2,44,2,45],[2,46,2,47]]}
["Day of Week",null,"Sunday",{"$nulls":5},"Monday",{"$nulls":5},"Tuesday"]
["Shift of Day",null,1,{"$f":"MOD(C2,6)+1","v":2},{"$f":"MOD(D2,6)+1","v":3},4,5,6,1,2,3,4,5,6,1,2,3,4,5,6]
["Readable Shift",null,"12AM-4AM","4AM-8AM","8AM-Noon","Noon-4PM","4PM-8PM","8PM-12AM","12AM-4AM","4AM-8AM","8AM-Noon","Noon-4PM","4PM-8PM","8PM-12AM","12AM-4AM","4AM-8AM","8AM-Noon","Noon-4PM","4PM-8PM","8PM-12AM","Count",null,"Prefix"]
[null,"Employee",{"$nulls":18},"Alpha","Beta","Pref","Neg"]
[null,1,0,0,1,1,1,1,0,0,1,1,1,1,0,0,1,1,1,1,{"$f":"SUMPRODUCT(C5:T5,'Employee Availability'!C5:T5)","v":12},{"$f":"'Employee Availability'!U5-'Employee Preference'!U5","v":5},{"$f":"IF(OR(U5=0,V5=0),0,V5/(U5+V5))","v":0.29411764705882354},{"$f":"IF(OR(U5=0,V5=0),0,W5*U5/V5)","v":0.7058823529411764}]
[null,2,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,{"$f":"SUMPRODUCT(C6:T6,'Employee Availability'!C6:T6)","v":16},{"$f":"'Employee Availability'!U6-'Employee Preference'!U6","v":1},{"$f":"IF(OR(U6=0,V6=0),0,V6/(U6+V6))","v":0.058823529411764705},{"$f":"IF(OR(U6=0,V6=0),0,W6*U6/V6)","v":0.9411764705882353}]
[null,3,1,1,0,0,0,1,1,1,1,1,0,0,0,0,1,1,1,1,{"$f":"SUMPRODUCT(C7:T7,'Employee Availability'!C7:T7)","v":11},{"$f":"'Employee Availability'!U7-'Employee Preference'!U7","v":7},0.3888888888888889,0.611111111111111]
[null,4,1,1,1,1,1,0,0,0,0,1,1,1,1,1,1,0,0,0,{"$f":"SUMPRODUCT(C8:T8,'Employee Availability'!C8:T8)","v":9},{"$f":"'Employee Availability'!U8-'Employee Preference'!U8","v":7},0.4375,0.5625]

{"sheet":"Assignments","index":3,"n_rows":26,"n_cols":23,"rows_kept":26,"merged":[[0,2,0,7],[0,8,0,13],[0,14,0,19],[0,20,0,25],[0,26,0,31],[0,32,0,37],[0,38,0,43],[9,2,9,10]]}
["Day of Week",null,"Sunday",{"$nulls":5},"Monday",{"$nulls":5},"Tuesday"]
["Shift of Day",null,1,{"$f":"MOD(C2,6)+1","v":2},{"$f":"MOD(D2,6)+1","v":3},4,5,6,1,2,3,4,5,6,1,2,3,4,5,6]
["Readable Shift",null,"12AM-4AM","4AM-8AM","8AM-Noon","Noon-4PM","4PM-8PM","8PM-12AM","12AM-4AM","4AM-8AM","8AM-Noon","Noon-4PM","4PM-8PM","8PM-12AM","12AM-4AM","4AM-8AM","8AM-Noon","Noon-4PM","4PM-8PM","8PM-12AM"]
["Required Employees",null,2,2,3,2,2,2,2,2,3,2,2,2,2,2,3,2,2,2,{"$f":"SUM(C4:T4)","v":39}]
[null,"Working",{"$f":"SUM(C6:C9)","v":2},{"$f":"SUM(D6:D9)","v":2},{"$f":"SUM(E6:E9)","v":4},{"$f":"SUM(F6:F9)","v":3},{"$f":"SUM(G6:G9)","v":2},{"$f":"SUM(H6:H9)","v":2},{"$f":"SUM(I6:I9)","v":2},{"$f":"SUM(J6:J9)","v":2},{"$f":"SUM(K6:K9)","v":3},{"$f":"SUM(L6:L9)","v":2},{"$f":"SUM(M6:M9)","v":2},{"$f":"SUM(N6:N9)","v":3},{"$f":"SUM(O6:O9)","v":2},{"$f":"SUM(P6:P9)","v":3},{"$f":"SUM(Q6:Q9)","v":3},{"$f":"SUM(R6:R9)","v":2},{"$f":"SUM(S6:S9)","v":2},{"$f":"SUM(T6:T9)","v":2},{"$f":"SUM(C5:T5)","v":43},"LB","UB"]
["Employee Working?",1,0,0,1,1,1,1,0,0,1,1,1,1,0,0,1,1,1,1,{"$f":"SUM(C6:T6)","v":12},{"$f":"'Employee Hours'!B3","v":8},{"$f":"'Employee Hours'!C3","v":12}]
[null,2,1,1,1,1,0,0,1,1,1,1,0,0,1,1,1,1,0,0,12,{"$f":"'Employee Hours'!B4","v":8},{"$f":"'Employee Hours'!C4","v":12}]
[null,3,0,1,1,0,0,1,1,1,1,0,0,1,0,1,1,0,1,1,11,{"$f":"'Employee Hours'!B5","v":8},{"$f":"'Employee Hours'!C5","v":12}]
[null,4,1,0,1,1,1,0,0,0,0,0,1,1,1,1,0,0,0,0,8,{"$f":"'Employee Hours'!B6","v":4},{"$f":"'Employee Hours'!C6","v":8}]
[null,"Objective Function",{"$f":"SUMPRODUCT(C6:T9,C12:T15)","v":52.013071895424815}]
[]
["Weighted Preference",1,{"$f":"'Employee Availability'!C5 * IF('Employee Preference'!C5>0,1+'Employee Preference'!$W5,1-'Employee Preference'!$X5)","v":0.2941176470588236},{"$f":"'Employee Availability'!D5 * IF('Employee Preference'!D5>0,1+'Employee Preference'!$W5,1-'Employee Preference'!$X5)","v":0.2941176470588236},{"$f":"'Employee Availability'!E5 * IF('Employee Preference'!E5>0,1+'Employee Preference'!$W5,1-'Employee Preference'!$X5)","v":1.2941176470588236},{"$f":"'Employee Availability'!F5 * IF('Employee Preference'!F5>0,1+'Employee Preference'!$W5,1-'Employee Preference'!$X5)","v":1.2941176470588236},{"$f":"'Employee Availability'!G5 * IF('Employee Preference'!G5>0,1+'Employee Preference'!$W5,1-'Employee Preference'!$X5)","v":1.2941176470588236},{"$f":"'Employee Availability'!H5 * IF('Employee Preference'!H5>0,1+'Employee Preference'!$W5,1-'Employee Preference'!$X5)","v":1.2941176470588236},{"$f":"'Employee Availability'!I5 * IF('Employee Preference'!I5>0,1+'Employee Preference'!$W5,1-'Employee Preference'!$X5)","v":0},{"$f":"'Employee Availability'!J5 * IF('Employee Preference'!J5>0,1+'Employee Preference'!$W5,1-'Employee Preference'!$X5)","v":0.2941176470588236},{"$f":"'Employee Availability'!K5 * IF('Employee Preference'!K5>0,1+'Employee Preference'!$W5,1-'Employee Preference'!$X5)","v":1.2941176470588236},{"$f":"'Employee Availability'!L5 * IF('Employee Preference'!L5>0,1+'Employee Preference'!$W5,1-'Employee Preference'!$X5)","v":1.2941176470588236},{"$f":"'Employee Availability'!M5 * IF('Employee Preference'!M5>0,1+'Employee Preference'!$W5,1-'Employee Preference'!$X5)","v":1.2941176470588236},{"$f":"'Employee Availability'!N5 * IF('Employee Preference'!N5>0,1+'Employee Preference'!$W5,1-'Employee Preference'!$X5)","v":1.2941176470588236},{"$f":"'Employee Availability'!O5 * IF('Employee Preference'!O5>0,1+'Employee Preference'!$W5,1-'Employee Preference'!$X5)","v":0.2941176470588236},{"$f":"'Employee Availability'!P5 * IF('Employee Preference'!P5>0,1+'Employee Preference'!$W5,1-'Employee Preference'!$X5)","v":0.2941176470588236},{"$f":"'Employee Availability'!Q5 * IF('Employee Preference'!Q5>0,1+'Employee Preference'!$W5,1-'Employee Preference'!$X5)","v":1.2941176470588236},{"$f":"'Employee Availability'!R5 * IF('Employee Preference'!R5>0,1+'Employee Preference'!$W5,1-'Employee Preference'!$X5)","v":1.2941176470588236},{"$f":"'Employee Availability'!S5 * IF('Employee Preference'!S5>0,1+'Employee Preference'!$W5,1-'Employee Preference'!$X5)","v":1.2941176470588236},{"$f":"'Employee Availability'!T5 * IF('Employee Preference'!T5>0,1+'Employee Preference'!$W5,1-'Employee Preference'!$X5)","v":1.2941176470588236}]
[null,2,{"$f":"'Employee Availability'!C6 * IF('Employee Preference'!C6>0,1+'Employee Preference'!$W6,1-'Employee Preference'!$X6)","v":1.0588235294117647},{"$f":"'Employee Availability'!D6 * IF('Employee Preference'!D6>0,1+'Employee Preference'!$W6,1-'Employee Preference'!$X6)","v":1.0588235294117647},{"$f":"'Employee Availability'!E6 * IF('Employee Preference'!E6>0,1+'Employee Preference'!$W6,1-'Employee Preference'!$X6)","v":1.0588235294117647},{"$f":"'Employee Availability'!F6 * IF('Employee Preference'!F6>0,1+'Employee Preference'!$W6,1-'Employee Preference'!$X6)","v":1.0588235294117647},{"$f":"'Employee Availability'!G6 * IF('Employee Preference'!G6>0,1+'Employee Preference'!$W6,1-'Employee Preference'!$X6)","v":1.0588235294117647},{"$f":"'Employee Availability'!H6 * IF('Employee Preference'!H6>0,1+'Employee Preference'!$W6,1-'Employee Preference'!$X6)","v":1.0588235294117647},{"$f":"'Employee Availability'!I6 * IF('Employee Preference'!I6>0,1+'Employee Preference'!$W6,1-'Employee Preference'!$X6)","v":1.0588235294117647},{"$f":"'Employee Availability'!J6 * IF('Employee Preference'!J6>0,1+'Employee Preference'!$W6,1-'Employee Preference'!$X6)","v":1.0588235294117647},{"$f":"'Employee Availability'!K6 * IF('Employee Preference'!K6>0,1+'Employee Preference'!$W6,1-'Employee Preference'!$X6)","v":1.0588235294117647},{"$f":"'Employee Availability'!L6 * IF('Employee Preference'!L6>0,1+'Employee Preference'!$W6,1-'Employee Preference'!$X6)","v":1.0588235294117647},{"$f":"'Employee Availability'!M6 * IF('Employee Preference'!M6>0,1+'Employee Preference'!$W6,1-'Employee Preference'!$X6)","v":1.0588235294117647},{"$f":"'Employee Availability'!N6 * IF('Employee Preference'!N6>0,1+'Employee Preference'!$W6,1-'Employee Preference'!$X6)","v":1.0588235294117647},{"$f":"'Employee Availability'!O6 * IF('Employee Preference'!O6>0,1+'Employee Preference'!$W6,1-'Employee Preference'!$X6)","v":1.0588235294117647},{"$f":"'Employee Availability'!P6 * IF('Employee Preference'!P6>0,1+'Employee Preference'!$W6,1-'Employee Preference'!$X6)","v":1.0588235294117647},{"$f":"'Employee Availability'!Q6 * IF('Employee Preference'!Q6>0,1+'Employee Preference'!$W6,1-'Employee Preference'!$X6)","v":1.0588235294117647},{"$f":"'Employee Availability'!R6 * IF('Employee Preference'!R6>0,1+'Employee Preference'!$W6,1-'Employee Preference'!$X6)","v":1.0588235294117647},{"$f":"'Employee Availability'!S6 * IF('Employee Preference'!S6>0,1+'Employee Preference'!$W6,1-'Employee Preference'!$X6)","v":0},{"$f":"'Employee Availability'!T6 * IF('Employee Preference'!T6>0,1+'Employee Preference'!$W6,1-'Employee Preference'!$X6)","v":0.05882352941176472}]
[null,3,{"$f":"'Employee Availability'!C7 * IF('Employee Preference'!C7>0,1+'Employee Preference'!$W7,1-'Employee Preference'!$X7)","v":1.3888888888888888},{"$f":"'Employee Availability'!D7 * IF('Employee Preference'!D7>0,1+'Employee Preference'!$W7,1-'Employee Preference'!$X7)","v":1.3888888888888888},{"$f":"'Employee Availability'!E7 * IF('Employee Preference'!E7>0,1+'Employee Preference'!$W7,1-'Employee Preference'!$X7)","v":0.38888888888888895},{"$f":"'Employee Availability'!F7 * IF('Employee Preference'!F7>0,1+'Employee Preference'!$W7,1-'Employee Preference'!$X7)","v":0.38888888888888895},{"$f":"'Employee Availability'!G7 * IF('Employee Preference'!G7>0,1+'Employee Preference'!$W7,1-'Employee Preference'!$X7)","v":0.38888888888888895},{"$f":"'Employee Availability'!H7 * IF('Employee Preference'!H7>0,1+'Employee Preference'!$W7,1-'Employee Preference'!$X7)","v":1.3888888888888888},{"$f":"'Employee Availability'!I7 * IF('Employee Preference'!I7>0,1+'Employee Preference'!$W7,1-'Employee Preference'!$X7)","v":1.3888888888888888},{"$f":"'Employee Availability'!J7 * IF('Employee Preference'!J7>0,1+'Employee Preference'!$W7,1-'Employee Preference'!$X7)","v":1.3888888888888888},{"$f":"'Employee Availability'!K7 * IF('Employee Preference'!K7>0,1+'Employee Preference'!$W7,1-'Employee Preference'!$X7)","v":1.3888888888888888},{"$f":"'Employee Availability'!L7 * IF('Employee Preference'!L7>0,1+'Employee Preference'!$W7,1-'Employee Preference'!$X7)","v":1.3888888888888888},{"$f":"'Employee Availability'!M7 * IF('Employee Preference'!M7>0,1+'Employee Preference'!$W7,1-'Employee Preference'!$X7)","v":0.38888888888888895},{"$f":"'Employee Availability'!N7 * IF('Employee Preference'!N7>0,1+'Employee Preference'!$W7,1-'Employee Preference'!$X7)","v":0.38888888888888895},{"$f":"'Employee Availability'!O7 * IF('Employee Preference'!O7>0,1+'Employee Preference'!$W7,1-'Employee Preference'!$X7)","v":0.38888888888888895},{"$f":"'Employee Availability'!P7 * IF('Employee Preference'!P7>0,1+'Employee Preference'!$W7,1-'Employee Preference'!$X7)","v":0.38888888888888895},{"$f":"'Employee Availability'!Q7 * IF('Employee Preference'!Q7>0,1+'Employee Preference'!$W7,1-'Employee Preference'!$X7)","v":1.3888888888888888},{"$f":"'Employee Availability'!R7 * IF('Employee Preference'!R7>0,1+'Employee Preference'!$W7,1-'Employee Preference'!$X7)","v":1.3888888888888888},{"$f":"'Employee Availability'!S7 * IF('Employee Preference'!S7>0,1+'Employee Preference'!$W7,1-'Employee Preference'!$X7)","v":1.3888888888888888},{"$f":"'Employee Availability'!T7 * IF('Employee Preference'!T7>0,1+'Employee Preference'!$W7,1-'Employee Preference'!$X7)","v":1.3888888888888888}]
[null,4,{"$f":"'Employee Availability'!C8 * IF('Employee Preference'!C8>0,1+'Employee Preference'!$W8,1-'Employee Preference'!$X8)","v":1.4375},{"$f":"'Employee Availability'!D8 * IF('Employee Preference'!D8>0,1+'Employee Preference'!$W8,1-'Employee Preference'!$X8)","v":0},{"$f":"'Employee Availability'!E8 * IF('Employee Preference'!E8>0,1+'Employee Preference'!$W8,1-'Employee Preference'!$X8)","v":1.4375},{"$f":"'Employee Availability'!F8 * IF('Employee Preference'!F8>0,1+'Employee Preference'!$W8,1-'Employee Preference'!$X8)","v":1.4375},{"$f":"'Employee Availability'!G8 * IF('Employee Preference'!G8>0,1+'Employee Preference'!$W8,1-'Employee Preference'!$X8)","v":1.4375},{"$f":"'Employee Availability'!H8 * IF('Employee Preference'!H8>0,1+'Employee Preference'!$W8,1-'Employee Preference'!$X8)","v":0.4375},{"$f":"'Employee Availability'!I8 * IF('Employee Preference'!I8>0,1+'Employee Preference'!$W8,1-'Employee Preference'!$X8)","v":0.4375},{"$f":"'Employee Availability'!J8 * IF('Employee Preference'!J8>0,1+'Employee Preference'!$W8,1-'Employee Preference'!$X8)","v":0.4375},{"$f":"'Employee Availability'!K8 * IF('Employee Preference'!K8>0,1+'Employee Preference'!$W8,1-'Employee Preference'!$X8)","v":0.4375},{"$f":"'Employee Availability'!L8 * IF('Employee Preference'!L8>0,1+'Employee Preference'!$W8,1-'Employee Preference'!$X8)","v":1.4375},{"$f":"'Employee Availability'!M8 * IF('Employee Preference'!M8>0,1+'Employee Preference'!$W8,1-'Employee Preference'!$X8)","v":1.4375},{"$f":"'Employee Availability'!N8 * IF('Employee Preference'!N8>0,1+'Employee Preference'!$W8,1-'Employee Preference'!$X8)","v":1.4375},{"$f":"'Employee Availability'!O8 * IF('Employee Preference'!O8>0,1+'Employee Preference'!$W8,1-'Employee Preference'!$X8)","v":1.4375},{"$f":"'Employee Availability'!P8 * IF('Employee Preference'!P8>0,1+'Employee Preference'!$W8,1-'Employee Preference'!$X8)","v":1.4375},{"$f":"'Employee Availability'!Q8 * IF('Employee Preference'!Q8>0,1+'Employee Preference'!$W8,1-'Employee Preference'!$X8)","v":0},{"$f":"'Employee Availability'!R8 * IF('Employee Preference'!R8>0,1+'Employee Preference'!$W8,1-'Employee Preference'!$X8)","v":0.4375},{"$f":"'Employee Availability'!S8 * IF('Employee Preference'!S8>0,1+'Employee Preference'!$W8,1-'Employee Preference'!$X8)","v":0.4375},{"$f":"'Employee Availability'!T8 * IF('Employee Preference'!T8>0,1+'Employee Preference'!$W8,1-'Employee Preference'!$X8)","v":0.4375}]
[]
[]
["Number of shifts working in last day",1,{"$f":"C6+SUM(P6:T6)","v":4},{"$f":"SUM(Q6:T6)+SUM(C6:D6)","v":4},{"$f":"SUM(R6:T6)+SUM(C6:E6)","v":4},{"$f":"SUM(C6:E6)+F6+T6+S6","v":4},{"$f":"SUM(C6:G6)+T6","v":4},{"$f":"SUM(C6:H6)","v":4},{"$f":"SUM(D6:I6)","v":4},4,4,4,4,4,4,4,4,4,4,4]
[null,2,{"$f":"C7+SUM(P7:T7)","v":4},{"$f":"SUM(Q7:T7)+SUM(C7:D7)","v":4},{"$f":"SUM(R7:T7)+SUM(C7:E7)","v":4},{"$f":"SUM(C7:E7)+F7+T7+S7","v":4},{"$f":"SUM(C7:G7)+T7","v":4},{"$f":"SUM(C7:H7)","v":4},{"$f":"SUM(D7:I7)","v":4},{"$f":"SUM(E7:J7)","v":4},{"$f":"SUM(F7:K7)","v":4},{"$f":"SUM(G7:L7)","v":4},{"$f":"SUM(H7:M7)","v":4},{"$f":"SUM(I7:N7)","v":4},{"$f":"SUM(J7:O7)","v":4},{"$f":"SUM(K7:P7)","v":4},{"$f":"SUM(L7:Q7)","v":4},{"$f":"SUM(M7:R7)","v":4},{"$f":"SUM(N7:S7)","v":4},{"$f":"SUM(O7:T7)","v":4}]
[null,3,4,4,4,4,3,3,4,4,4,4,4,4,3,3,3,3,4,4]
[null,4,2,1,2,3,4,4,3,3,2,1,1,2,3,4,4,4,3,2]
[]
["Shift limit per day",1,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4]
[null,2,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4]
[null,3,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4]
[null,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4]