Spreadsheet: 149165d1333727458-conditional-formula-for-remainders-test2
Sheet: Step-By-Step

Monday
Staffing
Interval | Primary Group Original | Primary Group Original | Primary Group + Secondary Group Net | Secondary Group Net After Primary Group Needs | Primary Group | Secondary Group
5:00 AM | 3.888571428571428
5:30 AM | 4.574285714285715
6:00 AM | 12.81428571428571 | 1.022 | If B6=Positive# then D6=B6 | If B6=Positive# then E6=C6
6:30 AM | 14.83285714285714 | 1.35
7:00 AM | -3.504857142857141 | -2.7 | If B8=Negative#:  Check if C8=Positive# or Negative# (is there secondary staff available or are they also understaffed)  If C8=Negative# then D8=[NAME] (this indicates the secondary group is also understaffed and i will need to secure the original# to meet the clients' requirements)  In this case: D8=-3.50 | If B8=Negative#:  Check if C8=Positive# or Negative# (is there secondary staff available or are they also understaffed)  If C8=Negative# then E8=C8 (this indicates the secondary group is also understaffed and i will need to secure the original# to meet the clients' requirements)  In this case: D8=-2.70
7:30 AM | 9.784285714285716 | 1.888
8:00 AM | -2.233714285714285 | 5 | If B10=Negative#:  Check if C10=Positive# or Negative# (is there secondary staff available or are they also understaffed)  If C10=Negative# then D10=B10 (this indicates the secondary group is also understaffed and i will need to secure the original# to meet the clients' requirements)  If C10=Positive# then add to B10 where:  If B10+C10=Positive# then D10=0 (I won't need to know how much of the secondary staff I used since they're already scheduled-show positive# result in E10)  In this case: D10=0 | If B10=Negative#:  Check if C10=Positive# or Negative# (is there secondary staff available or are they also understaffed)  If C10=Negative# then E10=[NAME] (this indicates the secondary group is also understaffed and i will need to secure the original# to meet the clients' requirements)  If C10=Positive# then add to B10 where:  If B10+C10=Positive# then E10=B10+C10 (to show how many secondary group staff there are after fulfilling the primary group requirements)  In this case: E10=2.77
8:30 AM | 17.03714285714284 | 7.490000000000002
9:00 AM | -3.584142857142854 | 2.45 | If B12=Negative#:  Check if C12=Positive# or Negative# (is there secondary staff available or are they also understaffed)  If C12=Negative# then D12=[NAME] (this indicates the secondary group is also understaffed and i will need to secure the original# to meet the clients' requirements)  If C12=Positive# then add to B12 where:  If B12+C12=Positive# then D12=0 (I won't need to know how much of the secondary staff I used since they're already scheduled-show positive# result in E12)  If B12+C12=Negative# then D12=B12+C12 (There is some but not enough secondary group staffing to cover all of the primary group staff requirement so I need to show the negative# result in D12 to show me what additional primary group staff is still left to secure).  In this case: D12=-1.13 | If B12=Negative#:  Check if C12=Positive# or Negative# (is there secondary staff available or are they also understaffed)  If C12=Negative# then E12=C12 (this indicates the secondary group is also understaffed and i will need to secure the original# to meet the clients' requirements)  If C12=Positive# then add to B12 where:  If B12+C12=Positive# then E12=B12+C12 (to show how many secondary group staff there are after fulfilling the primary group requirements)  If B12+C12=Negative# then E12=0 (All secondary staff has been used to staff the primary group).  In this case: E12=0 | F12=D12 | G12=E12
9:30 AM | -3.584142857142854 | 2.45
10:00 AM | -4.906285714285712 | 8.945999999999998