My excel skills are remarkably average yet I am trying to achieve something that seems nearly impossible.
I was wondering if anybody on here who is very good on Excel would be kind enough to Trust message me and offer their support before I drive myself insane.
Essentially, what I'm trying to do is allocate bits of work across multiple units.
For example - If I had say... a piece of hardware that could do 750 'things' a second, that's 2,700,000 per hour. I have 6 of these pieces of hardware.
Let's sat I receive an order to do 140,000,000 'things' an hour, that equates to about 52 hours of work. I'd like a tool that will allow me to allocate the work to a particular piece(s) of hardware.
Appreciate my explanation isn't great so I have uploaded a very rough example on Excel here.
I was wondering if anybody on here who is very good on Excel would be kind enough to Trust message me and offer their support before I drive myself insane.
Essentially, what I'm trying to do is allocate bits of work across multiple units.
For example - If I had say... a piece of hardware that could do 750 'things' a second, that's 2,700,000 per hour. I have 6 of these pieces of hardware.
Let's sat I receive an order to do 140,000,000 'things' an hour, that equates to about 52 hours of work. I'd like a tool that will allow me to allocate the work to a particular piece(s) of hardware.
Appreciate my explanation isn't great so I have uploaded a very rough example on Excel here.
