I would like to distribute the difference between the weekly labor target G2 and the weekly hours of operation I2 in even 0.25 chunks. The difference between G2 and I2 is in J2. If you multiply J2 by four you can see that I have 82 0.25 hour chunks of time available to distribute. How can I distribute those 82 chunks based on the needs represented by the ticket counts (workload) represented in column F. It's okay for some rows to be blank as long as I don't exceed the 82 chunks of time available and distribute the 0.25 hours to the intervals where the needs are highest.
I have tried distributing the labor based on a ratio defined by F/G but that often results in uneven labor or labor that is blowing the budget available.