Improve watch shift assignment workflow

[merichar]

Or just something to make the excel import less painful.

[ChaseBro]

Btw, I have a c# script which will auto-assign watch shifts based on preferences if you want it.

[pkoenig10]

That would be really helpful. Could you send it to me?

[ChaseBro]

It's already checked in as shift_picker.rb

On Sat, Jan 30, 2016 at 5:58 PM Patrick Koenig notifications@github.com wrote:

That would be really helpful. Could you send it to me?

— Reply to this email directly or view it on GitHub https://github.com/sc0v/binder-app/issues/87#issuecomment-177357561.

[RONNCC]

if you are a booth chair for an org - there will be some way for you to select 1-5 or yes/no/maybe.

[ChaseBro]

We did this via Google Form previously, @rjc210 can share it with you. I then manually created the arrays. It would also be great for all this functionality to be in the app.

[pkoenig10]

That is how we will be doing it this year. My goal is to move this painful workflow into Binder in the least messy way possible.

[arakla]

Patrick can correct me, but ideally this could be applied to any shift type then, coordinator, watch, security, or anything else that comes up in the future.

On Thu, Mar 3, 2016 at 7:55 PM, Patrick Koenig notifications@github.com wrote:

That is how we will be doing it this year. My goal is to move this painful workflow into Binder in the least messy way possible.

— Reply to this email directly or view it on GitHub https://github.com/sc0v/binder-app/issues/87#issuecomment-192041149.

[ChaseBro]

Security is usually a little different, mainly because we pay them so we don't care as much about their preferences, but I totally agree. Also please feel free to build upon my algorithm. I had grand plans for simulated annealing originally, but usually enough people don't submit prefs that you don't actually need anything nearly that complex to get an optimal result.

[pkoenig10]

After meeting with the team today this task has two main components: 1) Allow bulk creation of shifts (ie, create X hours shifts from START to END) 2) Watch shift assignment. This could later be extended to coordinator shift assignment if we think it is necessary. I'm not entirely convince that whatever method we come up with is better than handling preferences off Binder and adding them later but we will see where the task progresses.

As for security shifts, there are few enough of those they can just be manually created.

Regarding the algorithm, I think the current basic one works fine. I don't really see a strong need for something more complex, but its definitely something that could be improved if there is the time/desire.

[RONNCC]

Have a bulk add button under the watch shifts to create it

[sclark]

Since we collect the information with Google Forms, there is potential for making a Google Sheets script to make these assignments too. I will investigate both options as we get closer to Carnival this year.

[ChaseBro]

We should really just build this into the app, would make it much simpler if it was all self-serve for the Midway Chair right within Binder (and would make sure it doesn't get lost like Google docs tend to). Not to mention would allow for stuff like user auth and such

[sclark]

@ChaseBro we definitely do not have time to integrate this into Binder this year, but will consider it in the future. It sort of goes with #92.