View Single Post
Old 11-23-2016, 05:02 PM   #20
RW99
First Line Centre
 
RW99's Avatar
 
Join Date: Oct 2005
Location: 103 104END 106 109 111 117 122 202 203 207 208 216 217 219 221 222 224 225 313 317 HC G
Exp:
Default

So I'm back with another question for the CP braintrust, any help would be appreciated. I have this spreadsheet:



The green section is fairly straight forward, I have to distribute files every day to a group of six staff. Today I am distributing 1000 files (D2). Of these six staff, Shannon and Greg are slackers, so they only get 10.6% of the files, everyone else is even at 19.7% (A5:A10).

The yellow section is where it gets tricky. Some staff are here a full day and some are half days and some call in sick to play Battlefield 1 (come on Terry...). So the question is what would my formula look like in the red section (H5:H10) so that regardless of who shows up to work all 1000 files get assigned?

I think I'm asking for a lot here, I'm assuming the formula might be fairly long
RW99 is offline   Reply With Quote