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.
2 freelancere byder i gennemsnit $128 for dette job
Hello, Client! I have read your description carefully I have interest in your job I have many experience in EXCEL/VBA If I award me, then I can finish it in 2 days I hope you send me message thanks Best regards