I work in a call center. We create a spreadsheet to assign CSRs' calls to QA people to listen to. Like this:
CSR | 2mins | 4mins | 6mins | 8mins |
---|---|---|---|---|
BOB | JOE | BILL | AMY | ANDY |
JANE | ANDY | JOE | BILL | AMY |
JOSE | ANDY | AMY | JOE | BILL |
KAYLA | BILL | ANDY | AMY | JOE |
VLAD | text | BILL | ANDY | AMY |
but way way bigger. It takes at least a day to create, then it always needs adjustments to even things out before we publish it, and then it needs tweaks throughout the month for people being out sick or whatever. If a reviewer decides to take a week off and didn't tell us at the start of the month, well now we need to reassign 25% of their work to everyone else. If someone quits, we need to remove them from the sheet. Things like that. Some reviewers have other duties and so don't review as many as other people so they'd need to be assigned different numbers. Any way to automate all this? Like at the start of the month "assign Amy, Bill 5 reviews, assign Joe and Andy 6 reviews" "Remove two of Andy's assignments and give them to Bill and Joe."? I chatted with ChatGPT for a bit and it did a pretty good job creating a table, but it wouldn't actually create a whole sheet. I'm just learning how to use Excel and struggling with it TBH, so an automated way to do this instead of complicated commands in the workbook would be best. All the "AI spreadsheet' google hits don't seem to provide what I need. I don't know a tool to do this exists yet.
[link] [comments]