Hi there, first time user post, however I have always admired from affar.
I have come under a bit of stress at work and need to plan a months worth of work by the end of next week. I have a list of data which looks something like:
Visit A B C Visit 1 5 10 3 Visit 2 9 17 4 Visit 3 2 6 4 Visit 4 6 10 11 Visit 5 5 12 7 Visit 6 7 6 2
I have only shown 6 visits, but I have to plan over 300 visits that need to be performed during July. I need to work out what days we can perform each of the 300 visits, where the total of constraint A, B and C cannot be more than, A <40, B <80 and C< 50. Is anyone able to help me produce a formula via VBA or solver that would perform a first fit decreasing algorithm, and sort the list into groups (effectively days) i.e day one perform visits 1,3,4... day two perform (2,5,7...)
Bookmarks