I have a sequecing problem in VBA. I currently have a random data set of S,D, and H, with a date and time attached to each element. The sequencing rules are the following:
H cannot be beside another H
H's should ideally be surrounded with S's
S's have no restrictions, but should be evenly distributed within the data set.
Two D's should ideally not be beside each other but can be if necessary.
D and H should ideally not be beside each other.
If there is absolutely no other way, the first rule can be broken.
As for the dates, there is a starting date and time attached to the data set. The dates for each element has to be in sequence, and there is a window of -2 to 12 hours that you can play with for each part.
11 freelancers are bidding on average $34/hour for this job
Send me your files and I'll do it for you [FREE] as a review. Only after you happy with the result I'll beg you to award me and create a milestone. I am waiting on chat till 04.00 pm Singapore time