I have a data set similar to the sample workbook attached. Also, we are on version 9.2 so if it's a feature of 10 I won't be able to use it.
In this data I have sub Project ID's, and dates for scheduled action and drop dead. Some of the projects need to be scheduled and I can't exceed our weekly capacity (for this example 5 sub projects a week). Is there a way I can get the projects that are in the Pending Design and Pending Schedule columns assigned where they would fit in the Scheduled columns without going over capacity?
I have been trying solutions like an Axis2 calculation that contains an if sum(Count Projects) < 5 but nothing I am putting together is working. Any ideas from the community?