{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Model 1 Week 1","Model 1 Week 2","Model 1 Week 3","Model 1 Week 4","Model 2","Welcome!","Specialist Schedules","Provider Preferences","Room Requirements","Nurse Use of Rooms","Time Away","Number of Rooms","Inputs","Outputs","Outputs 2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":318,"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":"Model 1 Week 1","index":0,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["Decision Variables","Monday AM","Monday PM","Tuesday AM","Tuesday PM","Wednesday AM","Wednesday PM","Thursday AM","Thursday PM","Friday AM","Friday PM"]
["Provider 1",0.99999999999999978,0,0.99999999999999978,0.99999999999999956,0,0.99999999999999722,0.99999999999999722,0.99999999999999722,0.99999999999999989,0]
["Provider 2",0,0.99999971258965836,0,0,0.99999999999999978,0.99999971258965825,0.99999971258965836,0.99999971258965836,0.99999971258965836,0.99999971258965836]
["Provider 3",1,1,0,1,0.99999999999999978,0,0,0.99999999999999967,0.99999999999999967,0.99999999999999967]
["Provider 4",0,0,0.99999999999999989,0,0.99999999999999989,0.99999999999999989,0.99999999999999989,0.99999999999999989,0.99999999999999989,0.99999999999999989]
["Provider 5",0,0,0.99999999999999989,0.99999999999999978,1,1,1,0.99999999999999989,0.99999999999999989,0.99999999999999989]
["Provider 6",0,0.99999999999999978,1,0.99999999999999989,0,1,1,1,1,1]
["Provider 7",1,1,0.99999999999999989,0,0,0.99999999999999989,0.99999999999999989,0.99999999999999989,0.99999999999999989,0.99999999999999989]
["Provider 8",1,0,0.99999999999999967,0.99999999999999967,0,0.99999999999999956,0.99999999999999956,0.99999999999999956,0.99999999999999956,0.99999999999999956]
[]
["Objective Function","Max",{"$f":"SUMPRODUCT(DecisionVar1, Preference1)","v":59.999998275537948}]
[]
["Constraints"]
["Administrative & Triage Requirement"]
["Provider 1",{"$f":"SUM(B2:K2)","v":6.9999999999999911},"=",7]
["Provider 2",6.9999982755379495,"=",7]
["Provider 3",7,"=",7]
["Provider 4",6.9999999999999991,"=",7]
["Provider 5",8,"=",8]
["Provider 6",8,"=",8]
["Provider 7",8,"=",8]
["Provider 8",7.9999999999999982,"=",8]
[]
["Room Utilization","Monday AM","Monday PM","Tuesday AM","Tuesday PM","Wednesday AM","Wednesday PM","Thursday AM","Thursday PM","Friday AM","Friday PM"]
["Total Rooms Used",{"$f":"SUM(SUMPRODUCT(ProvSchedW1P1, RoomProv1), SUMPRODUCT(SpecSchedW1P1, RoomSpec1))","v":17},{"$f":"SUM(SUMPRODUCT(ProvSchedW1P2, RoomProv2), SUMPRODUCT(SpecSchedW1P2, RoomSpec2))","v":14.999999425179317},{"$f":"SUM(SUMPRODUCT(ProvSchedW1P3, RoomProv3), SUMPRODUCT(SpecSchedW1P3, RoomSpec3))","v":10.999999999999998},{"$f":"SUM(SUMPRODUCT(ProvSchedW1P4, RoomProv4), SUMPRODUCT(SpecSchedW1P4, RoomSpec4))","v":8.9999999999999982},{"$f":"SUM(SUMPRODUCT(ProvSchedW1P5, RoomProv5), SUMPRODUCT(SpecSchedW1P5, RoomSpec5))","v":12},{"$f":"SUM(SUMPRODUCT(ProvSchedW1P6, RoomProv6), SUMPRODUCT(SpecSchedW1P6, RoomSpec6))","v":12.999999425179315},{"$f":"SUM(SUMPRODUCT(ProvSchedW1P7, RoomProv7), SUMPRODUCT(SpecSchedW1P7, RoomSpec7))","v":13.999999425179315},{"$f":"SUM(SUMPRODUCT(ProvSchedW1P8, RoomProv8), SUMPRODUCT(SpecSchedW1P8, RoomSpec8))","v":14.999999425179311},{"$f":"SUM(SUMPRODUCT(ProvSchedW1P9, RoomProv9), SUMPRODUCT(SpecSchedW1P9, RoomSpec9))","v":15.999999425179315},{"$f":"SUM(SUMPRODUCT(ProvSchedW1P10, RoomProv10), SUMPRODUCT(SpecSchedW1P10, RoomSpec10))","v":14.999999425179315}]
[null,"<=","<=","<=","<=","<=","<=","<=","<=","<=","<="]
["Rooms Available",20,20,20,20,20,20,20,20,20,20]
[]
["Minimum Provider Requirements in Clinic"]
["Monday AM",{"$f":"COUNTIF(ProvSchedW1P1,\">=0.5\")","v":4},">=",4]
["Monday PM",{"$f":"COUNTIF(ProvSchedW1P2,\">=0.5\")","v":4},">=",4]
["Tuesday AM",{"$f":"COUNTIF(ProvSchedW1P3,\">=0.5\")","v":6},">=",4]
["Tuesday PM",{"$f":"COUNTIF(ProvSchedW1P4,\">=0.5\")","v":5},">=",4]
["Wednesday AM",{"$f":"COUNTIF(ProvSchedW1P5,\">=0.5\")","v":4},">=",4]
["Wednesday PM",{"$f":"COUNTIF(ProvSchedW1P6,\">=0.5\")","v":7},">=",4]
["Thursday AM",{"$f":"COUNTIF(ProvSchedW1P7,\">=0.5\")","v":7},">=",4]
["Thursday PM",{"$f":"COUNTIF(ProvSchedW1P8,\">=0.5\")","v":8},">=",4]
["Friday AM",{"$f":"COUNTIF(ProvSchedW1P9,\">=0.5\")","v":8},">=",4]
["Friday PM",{"$f":"COUNTIF(ProvSchedW1P10,\">=0.5\")","v":7},">=",4]

{"sheet":"Model 1 Week 2","index":1,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["Decision Variables","Monday AM","Monday PM","Tuesday AM","Tuesday PM","Wednesday AM","Wednesday PM","Thursday AM","Thursday PM","Friday AM","Friday PM"]
["Provider 1",0.99999995859280433,0,0.99999999999999956,0.99999999999999978,1,1,1,1,1,0]
["Provider 2",1,0.99999999999999967,0,0.99999999999999989,0,0.99999999999999967,0.99999999999999978,0.99999999999999967,0.99999999999999967,1]
["Provider 3",1,0.99999999999999967,1,0.99999999999999978,1,0,0,0.99999999684138208,1,0.99999999684138208]
["Provider 4",0.99999999999999933,0,1,0.99999999999999978,0,0.99999999999999989,0.99999999999999989,0.99999999999999989,0.99999999999999989,0.99999999999999989]
["Provider 5",0,0,0.99999995386418372,0.99999999999999978,0,0.99999999999999967,0.99999999999999967,0.99999999999999967,0.99999999999999967,0.99999999999999967]
["Provider 6",0,0,0.99999999355786917,0,1,0.99999999500843717,0.99999999500843717,0.99999999500843717,0.99999999500843717,0.99999999500843717]
["Provider 7",0,0.99999999999999967,0.99999999999999978,0,0,0.99999999999999978,0.99999999999999978,0.99999999999999978,0.99999999999999978,0.99999999999999978]
["Provider 8",0,0.99999999999999989,0,0,1,0.99999999999999989,1,0.99999999999999978,0.99999999999999978,0.99999999999999978]
[]
["Objective Function","Max",{"$f":"SUMPRODUCT(DecisionVar2, Preference2)","v":59.999999874739807}]
[]
["Constraints"]
["Administrative & Triage Requirement"]
["Provider 1",{"$f":"SUM(B2:K2)","v":7.9999999585928041},"=",8]
["Provider 2",7.9999999999999991,"=",8]
["Provider 3",7.9999999936827626,"=",8]
["Provider 4",7.9999999999999991,"=",8]
["Provider 5",6.9999999538641822,"=",7]
["Provider 6",6.9999999686000551,"=",7]
["Provider 7",6.9999999999999991,"=",7]
["Provider 8",7,"=",7]
[]
["Room Utilization","Monday AM","Monday PM","Tuesday AM","Tuesday PM","Wednesday AM","Wednesday PM","Thursday AM","Thursday PM","Friday AM","Friday PM"]
["Total Rooms Used",{"$f":"SUM(SUMPRODUCT(ProvSchedW2P1, RoomProv1), SUMPRODUCT(SpecSchedW2P1, RoomSpec1))","v":16.999999958592802},{"$f":"SUM(SUMPRODUCT(ProvSchedW2P2, RoomProv2), SUMPRODUCT(SpecSchedW2P2, RoomSpec2))","v":14.999999999999998},{"$f":"SUM(SUMPRODUCT(ProvSchedW2P3, RoomProv3), SUMPRODUCT(SpecSchedW2P3, RoomSpec3))","v":10.999999894844105},{"$f":"SUM(SUMPRODUCT(ProvSchedW2P4, RoomProv4), SUMPRODUCT(SpecSchedW2P4, RoomSpec4))","v":8.9999999999999982},{"$f":"SUM(SUMPRODUCT(ProvSchedW2P5, RoomProv5), SUMPRODUCT(SpecSchedW2P5, RoomSpec5))","v":11},{"$f":"SUM(SUMPRODUCT(ProvSchedW2P6, RoomProv6), SUMPRODUCT(SpecSchedW2P6, RoomSpec6))","v":12.999999990016873},{"$f":"SUM(SUMPRODUCT(ProvSchedW2P7, RoomProv7), SUMPRODUCT(SpecSchedW2P7, RoomSpec7))","v":13.999999990016873},{"$f":"SUM(SUMPRODUCT(ProvSchedW2P8, RoomProv8), SUMPRODUCT(SpecSchedW2P8, RoomSpec8))","v":14.999999983699638},{"$f":"SUM(SUMPRODUCT(ProvSchedW2P9, RoomProv9), SUMPRODUCT(SpecSchedW2P9, RoomSpec9))","v":15.999999990016873},{"$f":"SUM(SUMPRODUCT(ProvSchedW2P10, RoomProv10), SUMPRODUCT(SpecSchedW2P10, RoomSpec10))","v":14.999999983699638}]
[null,"<=","<=","<=","<=","<=","<=","<=","<=","<=","<="]
["Rooms Available",20,20,20,20,20,20,20,20,20,20]
[]
["Minimum Provider Requirements in Clinic"]
["Monday AM",{"$f":"COUNTIF(ProvSchedW2P1,\">=0.5\")","v":4},">=",4]
["Monday PM",{"$f":"COUNTIF(ProvSchedW2P2,\">=0.5\")","v":4},">=",4]
["Tuesday AM",{"$f":"COUNTIF(ProvSchedW2P3,\">=0.5\")","v":6},">=",4]
["Tuesday PM",{"$f":"COUNTIF(ProvSchedW2P4,\">=0.5\")","v":5},">=",4]
["Wednesday AM",{"$f":"COUNTIF(ProvSchedW2P5,\">=0.5\")","v":4},">=",4]
["Wednesday PM",{"$f":"COUNTIF(ProvSchedW2P6,\">=0.5\")","v":7},">=",4]
["Thursday AM",{"$f":"COUNTIF(ProvSchedW2P7,\">=0.5\")","v":7},">=",4]
["Thursday PM",{"$f":"COUNTIF(ProvSchedW2P8,\">=0.5\")","v":8},">=",4]
["Friday AM",{"$f":"COUNTIF(ProvSchedW2P9,\">=0.5\")","v":8},">=",4]
["Friday PM",{"$f":"COUNTIF(ProvSchedW2P10,\">=0.5\")","v":7},">=",4]

{"sheet":"Model 1 Week 3","index":2,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["Decision Variables","Monday AM","Monday PM","Tuesday AM","Tuesday PM","Wednesday AM","Wednesday PM","Thursday AM","Thursday PM","Friday AM","Friday PM"]
["Provider 1",0.99999999999999978,0,0.99999999999999978,0.99999999999999956,0,0.99999999999999722,0.99999999999999722,0.99999999999999722,0.99999999999999989,0]
["Provider 2",0,0.99999971258965836,0,0,0.99999999999999978,0.99999971258965825,0.99999971258965836,0.99999971258965836,0.99999971258965836,0.99999971258965836]
["Provider 3",1,1,0,1,0.99999999999999978,0,0,0.99999999999999967,0.99999999999999967,0.99999999999999967]
["Provider 4",0,0,0.99999999999999989,0,0.99999999999999989,0.99999999999999989,0.99999999999999989,0.99999999999999989,0.99999999999999989,0.99999999999999989]
["Provider 5",0,0,0.99999999999999989,0.99999999999999978,1,1,1,0.99999999999999989,0.99999999999999989,0.99999999999999989]
["Provider 6",0,0.99999999999999978,1,0.99999999999999989,0,1,1,1,1,1]
["Provider 7",1,1,0.99999999999999989,0,0,0.99999999999999989,0.99999999999999989,0.99999999999999989,0.99999999999999989,0.99999999999999989]
["Provider 8",1,0,0.99999999999999967,0.99999999999999967,0,0.99999999999999956,0.99999999999999956,0.99999999999999956,0.99999999999999956,0.99999999999999956]
[]
["Objective Function","Max",{"$f":"SUMPRODUCT(DecisionVar3, Preference3)","v":59.999998275537948}]
[]
["Constraints"]
["Administrative & Triage Requirement"]
["Provider 1",{"$f":"SUM(B2:K2)","v":6.9999999999999911},"=",7]
["Provider 2",6.9999982755379495,"=",7]
["Provider 3",7,"=",7]
["Provider 4",6.9999999999999991,"=",7]
["Provider 5",8,"=",8]
["Provider 6",8,"=",8]
["Provider 7",8,"=",8]
["Provider 8",7.9999999999999982,"=",8]
[]
["Room Utilization","Monday AM","Monday PM","Tuesday AM","Tuesday PM","Wednesday AM","Wednesday PM","Thursday AM","Thursday PM","Friday AM","Friday PM"]
["Total Rooms Used",{"$f":"SUM(SUMPRODUCT(ProvSchedW3P1, RoomProv1), SUMPRODUCT(SpecSchedW3P1, RoomSpec1))","v":17},{"$f":"SUM(SUMPRODUCT(ProvSchedW3P2, RoomProv2), SUMPRODUCT(SpecSchedW3P2, RoomSpec2))","v":14.999999425179317},{"$f":"SUM(SUMPRODUCT(ProvSchedW3P3, RoomProv3), SUMPRODUCT(SpecSchedW3P3, RoomSpec3))","v":10.999999999999998},{"$f":"SUM(SUMPRODUCT(ProvSchedW3P4, RoomProv4), SUMPRODUCT(SpecSchedW3P4, RoomSpec4))","v":8.9999999999999982},{"$f":"SUM(SUMPRODUCT(ProvSchedW3P5, RoomProv5), SUMPRODUCT(SpecSchedW3P5, RoomSpec5))","v":12},{"$f":"SUM(SUMPRODUCT(ProvSchedW3P6, RoomProv6), SUMPRODUCT(SpecSchedW3P6, RoomSpec6))","v":12.999999425179315},{"$f":"SUM(SUMPRODUCT(ProvSchedW3P7, RoomProv7), SUMPRODUCT(SpecSchedW3P7, RoomSpec7))","v":13.999999425179315},{"$f":"SUM(SUMPRODUCT(ProvSchedW3P8, RoomProv8), SUMPRODUCT(SpecSchedW3P8, RoomSpec8))","v":14.999999425179311},{"$f":"SUM(SUMPRODUCT(ProvSchedW3P9, RoomProv9), SUMPRODUCT(SpecSchedW3P9, RoomSpec9))","v":15.999999425179315},{"$f":"SUM(SUMPRODUCT(ProvSchedW3P10, RoomProv10), SUMPRODUCT(SpecSchedW3P10, RoomSpec10))","v":14.999999425179315}]
[null,"<=","<=","<=","<=","<=","<=","<=","<=","<=","<="]
["Rooms Available",20,20,20,20,20,20,20,20,20,20]
[]
["Minimum Provider Requirements in Clinic"]
["Monday AM",{"$f":"COUNTIF(ProvSchedW3P1,\">=0.5\")","v":4},">=",4]
["Monday PM",{"$f":"COUNTIF(ProvSchedW3P2,\">=0.5\")","v":4},">=",4]
["Tuesday AM",{"$f":"COUNTIF(ProvSchedW3P3,\">=0.5\")","v":6},">=",4]
["Tuesday PM",{"$f":"COUNTIF(ProvSchedW3P4,\">=0.5\")","v":5},">=",4]
["Wednesday AM",{"$f":"COUNTIF(ProvSchedW3P5,\">=0.5\")","v":4},">=",4]
["Wednesday PM",{"$f":"COUNTIF(ProvSchedW3P6,\">=0.5\")","v":7},">=",4]
["Thursday AM",{"$f":"COUNTIF(ProvSchedW3P7,\">=0.5\")","v":7},">=",4]
["Thursday PM",{"$f":"COUNTIF(ProvSchedW3P8,\">=0.5\")","v":8},">=",4]
["Friday AM",{"$f":"COUNTIF(ProvSchedW3P9,\">=0.5\")","v":8},">=",4]
["Friday PM",{"$f":"COUNTIF(ProvSchedW3P10,\">=0.5\")","v":7},">=",4]

{"sheet":"Model 1 Week 4","index":3,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["Decision Variables","Monday AM","Monday PM","Tuesday AM","Tuesday PM","Wednesday AM","Wednesday PM","Thursday AM","Thursday PM","Friday AM","Friday PM"]
["Provider 1",0.99999995859280433,0,0.99999999999999956,0.99999999999999978,1,1,1,1,1,0]
["Provider 2",1,0.99999999999999967,0,0.99999999999999989,0,0.99999999999999967,0.99999999999999978,0.99999999999999967,0.99999999999999967,1]
["Provider 3",1,0.99999999999999967,1,0.99999999999999978,1,0,0,0.99999999684138208,1,0.99999999684138208]
["Provider 4",0.99999999999999933,0,1,0.99999999999999978,0,0.99999999999999989,0.99999999999999989,0.99999999999999989,0.99999999999999989,0.99999999999999989]
["Provider 5",0,0,0.99999995386418372,0.99999999999999978,0,0.99999999999999967,0.99999999999999967,0.99999999999999967,0.99999999999999967,0.99999999999999967]
["Provider 6",0,0,0.99999999355786917,0,1,0.99999999500843717,0.99999999500843717,0.99999999500843717,0.99999999500843717,0.99999999500843717]
["Provider 7",0,0.99999999999999967,0.99999999999999978,0,0,0.99999999999999978,0.99999999999999978,0.99999999999999978,0.99999999999999978,0.99999999999999978]
["Provider 8",0,0.99999999999999989,0,0,1,0.99999999999999989,1,0.99999999999999978,0.99999999999999978,0.99999999999999978]
[]
["Objective Function","Max",{"$f":"SUMPRODUCT(DecisionVar4, Preference4)","v":59.999999874739807}]
[]
["Constraints"]
["Administrative & Triage Requirement"]
["Provider 1",{"$f":"SUM(B2:K2)","v":7.9999999585928041},"=",8]
["Provider 2",7.9999999999999991,"=",8]
["Provider 3",7.9999999936827626,"=",8]
["Provider 4",7.9999999999999991,"=",8]
["Provider 5",6.9999999538641822,"=",7]
["Provider 6",6.9999999686000551,"=",7]
["Provider 7",6.9999999999999991,"=",7]
["Provider 8",7,"=",7]
[]
["Room Utilization","Monday AM","Monday PM","Tuesday AM","Tuesday PM","Wednesday AM","Wednesday PM","Thursday AM","Thursday PM","Friday AM","Friday PM"]
["Total Rooms Used",{"$f":"SUM(SUMPRODUCT(ProvSchedW4P1, RoomProv1), SUMPRODUCT(SpecSchedW4P1, RoomSpec1))","v":16.999999958592802},{"$f":"SUM(SUMPRODUCT(ProvSchedW4P2, RoomProv2), SUMPRODUCT(SpecSchedW4P2, RoomSpec2))","v":14.999999999999998},{"$f":"SUM(SUMPRODUCT(ProvSchedW4P3, RoomProv3), SUMPRODUCT(SpecSchedW4P3, RoomSpec3))","v":10.999999894844105},{"$f":"SUM(SUMPRODUCT(ProvSchedW4P4, RoomProv4), SUMPRODUCT(SpecSchedW4P4, RoomSpec4))","v":8.9999999999999982},{"$f":"SUM(SUMPRODUCT(ProvSchedW4P5, RoomProv5), SUMPRODUCT(SpecSchedW4P5, RoomSpec5))","v":11},{"$f":"SUM(SUMPRODUCT(ProvSchedW4P6, RoomProv6), SUMPRODUCT(SpecSchedW4P6, RoomSpec6))","v":12.999999990016873},{"$f":"SUM(SUMPRODUCT(ProvSchedW4P7, RoomProv7), SUMPRODUCT(SpecSchedW4P7, RoomSpec7))","v":13.999999990016873},{"$f":"SUM(SUMPRODUCT(ProvSchedW4P8, RoomProv8), SUMPRODUCT(SpecSchedW4P8, RoomSpec8))","v":14.999999983699638},{"$f":"SUM(SUMPRODUCT(ProvSchedW4P9, RoomProv9), SUMPRODUCT(SpecSchedW4P9, RoomSpec9))","v":15.999999990016873},{"$f":"SUM(SUMPRODUCT(ProvSchedW4P10, RoomProv10), SUMPRODUCT(SpecSchedW4P10, RoomSpec10))","v":14.999999983699638}]
[null,"<=","<=","<=","<=","<=","<=","<=","<=","<=","<="]
["Rooms Available",20,20,20,20,20,20,20,20,20,20]
[]
["Minimum Provider Requirements in Clinic"]
["Monday AM",{"$f":"COUNTIF(ProvSchedW4P1,\">=0.5\")","v":4},">=",4]
["Monday PM",{"$f":"COUNTIF(ProvSchedW4P2,\">=0.5\")","v":4},">=",4]
["Tuesday AM",{"$f":"COUNTIF(ProvSchedW4P3,\">=0.5\")","v":6},">=",4]
["Tuesday PM",{"$f":"COUNTIF(ProvSchedW4P4,\">=0.5\")","v":5},">=",4]
["Wednesday AM",{"$f":"COUNTIF(ProvSchedW4P5,\">=0.5\")","v":4},">=",4]
["Wednesday PM",{"$f":"COUNTIF(ProvSchedW4P6,\">=0.5\")","v":7},">=",4]
["Thursday AM",{"$f":"COUNTIF(ProvSchedW4P7,\">=0.5\")","v":7},">=",4]
["Thursday PM",{"$f":"COUNTIF(ProvSchedW4P8,\">=0.5\")","v":8},">=",4]
["Friday AM",{"$f":"COUNTIF(ProvSchedW4P9,\">=0.5\")","v":8},">=",4]
["Friday PM",{"$f":"COUNTIF(ProvSchedW4P10,\">=0.5\")","v":7},">=",4]

{"sheet":"Model 2","index":4,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
["Patient Type","New","Established","Phone"]
["Appointment Length",{"$f":"newLength","v":60},{"$f":"estLength","v":30},{"$f":"phoneLength","v":10}]
["Patient mix",{"$f":"newPercent","v":0.35},{"$f":"estPercent","v":0.6},{"$f":"phonePercent","v":0.05}]
["Decision variables",111.1139240506329,190.48101265822785,15.873417721518988]
[]
["Objective Function","Max",1]
[]
["Available Time"]
["Week 1",{"$f":"SUMPRODUCT($B$2:$D$2, $B$4:$D$4)","v":12540},"=",{"$f":"SUM(C20:L27)","v":12540}]
["Week 2",{"$f":"SUMPRODUCT($B$2:$D$2, $B$4:$D$4)","v":12540},"=",{"$f":"SUM(C28:L35)","v":12540}]
["Week 3",{"$f":"SUMPRODUCT($B$2:$D$2, $B$4:$D$4)","v":12540},"=",{"$f":"SUM(C36:L43)","v":12540}]
["Week 4",{"$f":"SUMPRODUCT($B$2:$D$2, $B$4:$D$4)","v":12540},"=",{"$f":"SUM(C44:L51)","v":12540}]
[]
[]
["Set Percentages",{"$f":"B3/D3*D4","v":111.1139240506329},"=",{"$f":"B4","v":111.1139240506329}]
["Set Percentages",{"$f":"C3/D3*D4","v":190.48101265822783},"=",{"$f":"C4","v":190.48101265822785}]
[]
["Available Time Determination"]
[null,null,"Monday AM","Monday PM","Tuesday AM","Tuesday PM","Wednesday AM","Wednesday PM","Thursday AM","Thursday PM","Friday AM","Friday PM"]
["Week 1","Provider 1",240,0,240,180,0,180,240,180,240,0]
[null,"Provider 2",0,180,0,0,240,180,240,180,240,180]
[null,"Provider 3",240,180,0,180,240,0,0,180,240,180]
[null,"Provider 4",0,0,240,0,240,180,240,180,240,180]
[null,"Provider 5",0,0,240,180,240,180,240,180,240,180]
[null,"Provider 6",0,180,240,180,0,180,240,180,240,180]
[null,"Provider 7",240,180,240,0,0,180,240,180,240,180]
[null,"Provider 9",240,0,240,180,0,180,240,180,240,180]
["Week 2","Provider 1",240,0,240,180,240,180,240,180,240,0]
[null,"Provider 2",240,180,0,180,0,180,240,180,240,180]
[null,"Provider 3",240,180,240,180,240,0,0,180,240,180]
[null,"Provider 4",240,0,240,180,0,180,240,180,240,180]
[null,"Provider 5",0,0,240,180,0,180,240,180,240,180]
[null,"Provider 6",0,0,240,0,240,180,240,180,240,180]
[null,"Provider 7",0,180,240,0,0,180,240,180,240,180]
[null,"Provider 9",0,180,0,0,240,180,240,180,240,180]
["Week 3","Provider 1",240,0,240,180,0,180,240,180,240,0]
[null,"Provider 2",0,180,0,0,240,180,240,180,240,180]
[null,"Provider 3",240,180,0,180,240,0,0,180,240,180]
[null,"Provider 4",0,0,240,0,240,180,240,180,240,180]
[null,"Provider 5",0,0,240,180,240,180,240,180,240,180]
[null,"Provider 6",0,180,240,180,0,180,240,180,240,180]
[null,"Provider 7",240,180,240,0,0,180,240,180,240,180]
[null,"Provider 9",240,0,240,180,0,180,240,180,240,180]
["Week 4","Provider 1",240,0,240,180,240,180,240,180,240,0]
[null,"Provider 2",240,180,0,180,0,180,240,180,240,180]
[null,"Provider 3",240,180,240,180,240,0,0,180,240,180]
[null,"Provider 4",240,0,240,180,0,180,240,180,240,180]
[null,"Provider 5",0,0,240,180,0,180,240,180,240,180]
[null,"Provider 6",0,0,240,0,240,180,240,180,240,180]
[null,"Provider 7",0,180,240,0,0,180,240,180,240,180]
[null,"Provider 9",0,180,0,0,240,180,240,180,240,180]

{"sheet":"Welcome!","index":5,"n_rows":29,"n_cols":1,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,5,14],[6,0,8,14],[27,0,27,14],[28,0,28,14]]}
["ProSkedge"]
[]
[]
[]
[]
[]
["A Linear Programming Based Provider Schedule Planning Tool"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["This tool was developed as part of a Major Qualifying Project at Worcester Polytechnic Institute."]
["The accompanying report will be available on WPI's Gordon Library website."]

{"sheet":"Specialist Schedules","index":6,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":true,"merged":[[25,0,29,0],[0,0,0,11],[1,0,2,11],[4,0,8,0],[11,0,15,0],[18,0,22,0]]}
["Specialist Schedules"]
["Set to 0 or 1: {0 = Is not scheduled, 1 = Is scheduled}"]
[]
[null,null,"Monday AM","Monday PM","Tuesday AM","Tuesday PM","Wednesday AM","Wednesday PM","Thursday AM","Thursday PM","Friday AM","Friday PM"]
["Week 1","Specialist 1",1,1,0,0,0,0,0,0,0,0,null,"Options"]
[null,"Specialist 2",1,1,0,0,1,0,0,0,0,0,null,0,"Prefers NOT to be scheduled"]
[null,"Specialist 3",1,0,0,0,0,0,0,0,0,0,null,1,"Strongly prefers to be scheduled"]
[null,"Specialist 4",1,1,0,0,0,0,0,0,0,0]
[null,"Specialist 5",0,0,0,0,0,0,0,0,1,1]
[null,"Specialist 6",0,0,0,0,0,0,1,0,0,0]
[null,"Specialist 7",0,0,0,0,1,0,0,0,0,0]
["Week 2","Specialist 1",1,1,0,0,0,0,0,0,0,0]
[null,"Specialist 2",1,1,0,0,1,0,0,0,0,0]
[null,"Specialist 3",1,0,0,0,0,0,0,0,0,0]
[null,"Specialist 4",1,1,0,0,0,0,0,0,0,0]
[null,"Specialist 5",0,0,0,0,0,0,0,0,1,1]
[null,"Specialist 6",0,0,0,0,0,0,1,0,0,0]
[null,"Specialist 7",0,0,0,0,1,0,0,0,0,0]
["Week 3","Specialist 1",1,1,0,0,0,0,0,0,0,0]
[null,"Specialist 2",1,1,0,0,1,0,0,0,0,0]
[null,"Specialist 3",1,0,0,0,0,0,0,0,0,0]
[null,"Specialist 4",1,1,0,0,0,0,0,0,0,0]
[null,"Specialist 5",0,0,0,0,0,0,0,0,1,1]
[null,"Specialist 6",0,0,0,0,0,0,1,0,0,0]
[null,"Specialist 7",0,0,0,0,1,0,0,0,0,0]
["Week 4","Specialist 1",1,1,0,0,0,0,0,0,0,0]
[null,"Specialist 2",1,1,0,0,1,0,0,0,0,0]
[null,"Specialist 3",1,0,0,0,0,0,0,0,0,0]
[null,"Specialist 4",1,1,0,0,0,0,0,0,0,0]
[null,"Specialist 5",0,0,0,0,0,0,0,0,1,1]
[null,"Specialist 6",0,0,0,0,0,0,1,0,0,0]
[null,"Specialist 7",0,0,0,0,1,0,0,0,0,0]

{"sheet":"Provider Preferences","index":7,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":true,"merged":[[28,0,35,0],[0,0,0,11],[1,0,2,11],[4,0,11,0],[12,0,19,0],[20,0,27,0]]}
["Provider Preferences"]
["{0 = Prefers to be in administrative or triage in this period, 1 = No preference, 2 = Strongly prefers to be scheduled with own patients in this period}"]
[]
[null,null,"Monday AM","Monday PM","Tuesday AM","Tuesday PM","Wednesday AM","Wednesday PM","Thursday AM","Thursday PM","Friday AM","Friday PM"]
["Week 1","Provider 1",1,1,1,1,1,1,1,1,1,1,null,"Options"]
[null,"Provider 2",1,1,1,1,1,1,1,1,1,1,null,0,"Prefers to be scheduled for administrative time or triage work"]
[null,"Provider 3",1,1,1,1,1,1,1,1,1,1,null,1,"No preference"]
[null,"Provider 4",1,1,1,1,1,1,1,1,1,1,null,2,"Strongly prefers to be scheduled with own patients in this period"]
[null,"Provider 5",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 6",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 7",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 8",1,1,1,1,1,1,1,1,1,1]
["Week 2","Provider 1",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 2",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 3",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 4",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 5",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 6",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 7",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 8",1,1,1,1,1,1,1,1,1,1]
["Week 3","Provider 1",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 2",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 3",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 4",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 5",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 6",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 7",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 8",1,1,1,1,1,1,1,1,1,1]
["Week 4","Provider 1",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 2",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 3",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 4",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 5",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 6",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 7",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 8",1,1,1,1,1,1,1,1,1,1]

{"sheet":"Room Requirements","index":8,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":true,"merged":[[0,0,0,11],[1,0,2,11],[4,0,16,0]]}
["Room Requirements"]
["How many rooms does a provider or specialist require? It does not matter if the provider/specialist is scheduled. The number will most likely be the same for all cells in a row."]
[]
[null,null,"Monday AM","Monday PM","Tuesday AM","Tuesday PM","Wednesday AM","Wednesday PM","Thursday AM","Thursday PM","Friday AM","Friday PM"]
["All Weeks","Provider 1",1,1,1,1,1,1,1,1,1,1,null,"Options"]
[null,"Provider 2",2,2,2,2,2,2,2,2,2,2,null,0,"rooms required"]
[null,"Provider 3",2,2,2,2,2,2,2,2,2,2,null,1,"rooms required"]
[null,"Provider 4",2,2,2,2,2,2,2,2,2,2,null,2,"rooms required"]
[null,"Provider 5",2,2,2,2,2,2,2,2,2,2,null,3,"rooms required"]
[null,"Provider 6",2,2,2,2,2,2,2,2,2,2,null,4,"rooms required"]
[null,"Provider 7",2,2,2,2,2,2,2,2,2,2,null,5,"rooms required"]
[null,"Provider 8",2,2,2,2,2,2,2,2,2,2,null,6,"rooms required"]
[null,"Specialist 1",3,3,3,3,3,3,3,3,3,3]
[null,"Specialist 2",3,3,3,3,3,3,3,3,3,3]
[null,"Specialist 3",3,3,3,3,3,3,3,3,3,3]
[null,"Specialist 4",1,1,1,1,1,1,1,1,1,1]
[null,"Specialiat 5",1,1,1,1,1,1,1,1,1,1]
[null,"Specialist 6",1,1,1,1,1,1,1,1,1,1]
[null,"Specialist 7",1,1,1,1,1,1,1,1,1,1]

{"sheet":"Nurse Use of Rooms","index":9,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":true,"merged":[[0,0,0,11],[1,0,2,11]]}
["Utilization of Rooms by Nurses & Health Techs"]
["How many EXAM ROOMS that could be used for patient appointments are expected to be utilized by nurses or health techs for other purposes?"]
[]
[null,null,"Monday AM","Monday PM","Tuesday AM","Tuesday PM","Wednesday AM","Wednesday PM","Thursday AM","Thursday PM","Friday AM","Friday PM"]
["Week 1","Number of Rooms",0,0,0,0,0,0,0,0,0,0]
["Week 2","Number of Rooms",0,0,0,0,0,0,0,0,0,0]
["Week 3","Number of Rooms",0,0,0,0,0,0,0,0,0,0]
["Week 4","Number of Rooms",0,0,0,0,0,0,0,0,0,0]

{"sheet":"Time Away","index":10,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":true,"merged":[[28,0,35,0],[0,0,0,11],[1,0,2,11],[4,0,11,0],[12,0,19,0],[20,0,27,0]]}
["Time Away"]
["Set to 0 for any time in which the provider has approved vacation time or is scheduled for routine time away from this facility."]
[]
[null,null,"Monday AM","Monday PM","Tuesday AM","Tuesday PM","Wednesday AM","Wednesday PM","Thursday AM","Thursday PM","Friday AM","Friday PM"]
["Week 1","Provider 1",1,1,1,1,1,1,1,1,1,0,null,"Options"]
[null,"Provider 2",1,1,1,1,1,1,1,1,1,1,null,0,"Time away approved"]
[null,"Provider 3",1,1,1,1,1,1,1,1,1,1,null,1,"No time away"]
[null,"Provider 4",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 5",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 6",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 7",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 8",1,1,1,1,1,1,1,1,1,1]
["Week 2","Provider 1",1,1,1,1,1,1,1,1,1,0]
[null,"Provider 2",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 3",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 4",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 5",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 6",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 7",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 8",1,1,1,1,1,1,1,1,1,1]
["Week 3","Provider 1",1,1,1,1,1,1,1,1,1,0]
[null,"Provider 2",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 3",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 4",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 5",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 6",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 7",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 8",1,1,1,1,1,1,1,1,1,1]
["Week 4","Provider 1",1,1,1,1,1,1,1,1,1,0]
[null,"Provider 2",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 3",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 4",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 5",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 6",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 7",1,1,1,1,1,1,1,1,1,1]
[null,"Provider 8",1,1,1,1,1,1,1,1,1,1]

{"sheet":"Number of Rooms","index":11,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":true,"merged":[[0,0,0,11],[1,0,2,11]]}
["Number of Rooms"]
["How many rooms are available for exams?"]
[]
[null,null,"Monday AM","Monday PM","Tuesday AM","Tuesday PM","Wednesday AM","Wednesday PM","Thursday AM","Thursday PM","Friday AM","Friday PM"]
["Week 1","Number of Rooms",20,20,20,20,20,20,20,20,20,20]
["Week 2","Number of Rooms",20,20,20,20,20,20,20,20,20,20]
["Week 3","Number of Rooms",20,20,20,20,20,20,20,20,20,20]
["Week 4","Number of Rooms",20,20,20,20,20,20,20,20,20,20]

{"sheet":"Inputs","index":12,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Main Input Menu"]
[]
["Step 1:","How many providers are to be scheduled? (15 provider maximum)",8]
[null,"How many specialists do you expect this month? (15 specialist maximum)",7]
[]
["Step 2:","Edit provider preferences ……………….……………………………………………………."]
[]
["Step 3:","Edit specialist schedules ……………….………………………………………………………"]
[]
["Step 4:","Edit provider and specialist room requirements ……………….……………………."]
[]
["Step 5:","Edit nurse and health tech utilization of examination rooms ……………….…."]
[]
["Step 6:","Edit approved provider time away ……………….……………………………………….."]
[]
["Step 7:","Edit the number of exam rooms ……………….……………………………………………"]
[]
["Step 8:","Determine the following:"]
[null,"Minimum Number of Providers to be Assigned to Clinic Duty per Day:",4]
[null,"Number of Administrative Periods to Allow Each Provider:",2,"in a given week"]
[null,"Number of Triage Periods to Require of Each Provider:",1,"in a given week",null,null,null,"every other week"]
[null,"Require Triage Assignment for Provider:","every other week",null,null,null,null,"every week"]
[null,"How many providers should start with Triage in Week 1?",4]
[]
["Step 9:","Enter the following information."]
[null,"Length of Morning Period: (i.e. 8am - 12pm = 4)",4,"hours"]
[null,"Length of Afternoon Period: (i.e. 1pm - 4pm = 3)",3,"hours"]
[]
["Step 10:","Modify scheduled appointment lengths if necessary."]
[null,"New patient appointment length:",60,"minutes"]
[null,"Established patient appointment length:",30,"minutes"]
[null,"Phone visit patient appointment length:",10,"minutes"]
[]
["Step 11:","Modify PACT percentange requirements for various patient types."]
[null,"New patients:",0.35]
[null,"Established patients:",0.6]
[null,"Phone visit patients:",0.05]
[null,"Total must equal 100%",{"$f":"SUM(C35:C37)","v":1}]

{"sheet":"Outputs","index":13,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":false,"merged":[[3,0,10,0],[11,0,18,0],[19,0,26,0],[27,0,34,0],[0,0,0,11]]}
["Optimal Provider Schedule"]
[]
[null,null,"Monday AM","Monday PM","Tuesday AM","Tuesday PM","Wednesday AM","Wednesday PM","Thursday AM","Thursday PM","Friday AM","Friday PM"]
["Week 1","Provider 1",1,0,1,1,0,1,1,1,1,0]
[null,"Provider 2",0,1,0,0,1,1,1,1,1,1]
[null,"Provider 3",1,1,0,1,1,0,0,1,1,1]
[null,"Provider 4",0,0,1,0,1,1,1,1,1,1]
[null,"Provider 5",0,0,1,1,1,1,1,1,1,1]
[null,"Provider 6",0,1,1,1,0,1,1,1,1,1]
[null,"Provider 7",1,1,1,0,0,1,1,1,1,1]
[null,"Provider 8",1,0,1,1,0,1,1,1,1,1]
["Week 2","Provider 1",1,0,1,1,1,1,1,1,1,0]
[null,"Provider 2",1,1,0,1,0,1,1,1,1,1]
[null,"Provider 3",1,1,1,1,1,0,0,1,1,1]
[null,"Provider 4",1,0,1,1,0,1,1,1,1,1]
[null,"Provider 5",0,0,1,1,0,1,1,1,1,1]
[null,"Provider 6",0,0,1,0,1,1,1,1,1,1]
[null,"Provider 7",0,1,1,0,0,1,1,1,1,1]
[null,"Provider 8",0,1,0,0,1,1,1,1,1,1]
["Week 3","Provider 1",1,0,1,1,0,1,1,1,1,0]
[null,"Provider 2",0,1,0,0,1,1,1,1,1,1]
[null,"Provider 3",1,1,0,1,1,0,0,1,1,1]
[null,"Provider 4",0,0,1,0,1,1,1,1,1,1]
[null,"Provider 5",0,0,1,1,1,1,1,1,1,1]
[null,"Provider 6",0,1,1,1,0,1,1,1,1,1]
[null,"Provider 7",1,1,1,0,0,1,1,1,1,1]
[null,"Provider 8",1,0,1,1,0,1,1,1,1,1]
["Week 4","Provider 1",1,0,1,1,1,1,1,1,1,0]
[null,"Provider 2",1,1,0,1,0,1,1,1,1,1]
[null,"Provider 3",1,1,1,1,1,0,0,1,1,1]
[null,"Provider 4",1,0,1,1,0,1,1,1,1,1]
[null,"Provider 5",0,0,1,1,0,1,1,1,1,1]
[null,"Provider 6",0,0,1,0,1,1,1,1,1,1]
[null,"Provider 7",0,1,1,0,0,1,1,1,1,1]
[null,"Provider 8",0,1,0,0,1,1,1,1,1,1]

{"sheet":"Outputs 2","index":14,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[5,0,5,2],[0,0,0,6],[2,0,3,7]]}
["Patient Throughput Guidelines"]
[]
["If any schedule solutions were infeasible (represented by grayed-out weeks), this value is skewed.\nYou should modify your inputs to obtain a feasible schedule and then view Patient Throughput. "]
[]
[]
["With the patient mix requirement of:",null,null,{"$f":"newPercent","v":0.35},"new patients",null,{"$f":"\"approximately 444 new patients can be seen in a month,\"","v":"approximately 444 new patients can be seen in a month,"}]
[null,null,null,{"$f":"estPercent","v":0.6},"established patients",null,{"$f":"\"approximately 760 established patients can be seen in a month, and\"","v":"approximately 760 established patients can be seen in a month, and"}]
[null,null,null,{"$f":"phonePercent","v":0.05},"phone visits",null,{"$f":"\"approximately 64 phone visit patients can be seen in a month,\"","v":"approximately 64 phone visit patients can be seen in a month,"}]
[]
[null,null,null,null,null,null,{"$f":"\"for an ideal approximate patient throughput value of 1,268 patients per month.\"","v":"for an ideal approximate patient throughput value of 1,268 patients per month."}]