Hello, I've an Excel-related question with regards to one of my courseworks, which disallows the use of VBA in order to find a solution.
The aim of the coursework is to provide a working model for a fictional online bookshop that can receive different staff scheduling information as input; I have been given inter-ordering times and the different lengths of time it can take for one order to be complete, but none of that data is important right now.
My main problem is that I would love to be able to create a matrix detailing how many people are "on shift," based upon a table of values.
The sheet currently contains a table and an empty matrix.
The table has the headings, {Employee ID, Starting Day [Day of the week], Paid Working Hours, Shift Start Time [hh:mm:ss], Break Start, Break Finish, Shift Finish Time} with "Break Start," "Break Finish" and "Shift Finish Time" being worked out from the values of the other cells.
The Matrix has the days of the week as the columns and all possible shift starting times, {00:00:00,01:00:00, ... ,23:00:00}, as the rows.
There's no need to be worrying about factoring in the break times; I believe I can work out that part myself. I'm just hoping that one of the fine people on here would be able to offer a hint with regards to if/how it might be possible to go about tackling this problem. Thank you very much in advance ^^
The aim of the coursework is to provide a working model for a fictional online bookshop that can receive different staff scheduling information as input; I have been given inter-ordering times and the different lengths of time it can take for one order to be complete, but none of that data is important right now.
My main problem is that I would love to be able to create a matrix detailing how many people are "on shift," based upon a table of values.
The sheet currently contains a table and an empty matrix.
The table has the headings, {Employee ID, Starting Day [Day of the week], Paid Working Hours, Shift Start Time [hh:mm:ss], Break Start, Break Finish, Shift Finish Time} with "Break Start," "Break Finish" and "Shift Finish Time" being worked out from the values of the other cells.
The Matrix has the days of the week as the columns and all possible shift starting times, {00:00:00,01:00:00, ... ,23:00:00}, as the rows.
There's no need to be worrying about factoring in the break times; I believe I can work out that part myself. I'm just hoping that one of the fine people on here would be able to offer a hint with regards to if/how it might be possible to go about tackling this problem. Thank you very much in advance ^^