I gang

VBA Sequencing Problem -- 2

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.

To clarify the above, the sequencing rules above is in a top-to-bottom priority list.

So the priority sequence is:
SHS > SDS > SS > DD > DH > HH

Also in regards to the window, by +12 I mean 12 hour lead time, so the part should be 12 hours earlier than the given date/time and -2 means the part could be delayed by 2 hours from the given date / time. If the best move requires a delay of 4 hours, it will be no good, as it breaks the time constraints.

An additional request is to reassign new date/times after the resequence. Ideally I would like a variable time difference between each part, so the part should be resequenced with the new time assignment in mind.

E.g. If each row movement represents an hour change, if one part requires a 1 hour lead time before the next part, you can move that part around 12 rows above, or 2 rows below its original position. If another part requires a 2 hour lead time before the next part, you can only move that row 6 rows above or 1 row below. Or something to that effect.

Færdigheder: Excel, Software Arkitektur, Visual Basic for Apps

Se mere: technical report writing report writing if any insert row if necessary, how to know if two lines are parallel, how do you know if two line segments are perpendicular, determine if two lines intersect, consider the following linear programming problem, check if two line segments intersect, in book binding in graphic design if they say write the problem you encounted or chalenges you face when doing the book binding, two excel vba, problem solving vba, vba web query refresh problem, vba excel problem solution, problem solution vba excel, pdfcreator access vba problem, knapsack problem vba, vba problem english french

Om arbejdsgiveren:
( 1 bedømmelse ) scarborough, Canada

Projekt-ID: #12523557

Tildelt til:


Hello, Sir. I am very interested in your project because I have experiences in solving a problem like yours using decision tree/network and rule applying your project is rather a algorithm problem(network graph). Mere

$100 USD in 3 dage
(0 bedømmelser)

2 freelancere byder i gennemsnit $128 for dette job


Dear Employer, I am an expert and will automate the process for you using VBAs and MAcros. Please find attached my previous work samples. Please let me know if we can discuss further on this. You can add me on Mere

$155 USD in 3 dage
(1 bedømmelse)

Hi Mark here, I hope you will consider me for your project. I will assure you a quality end product at a competitive price. I know you will be swamped with bids so thank you for the time. Hoping to hear from you soon a Mere

$155 USD in 3 dage
(0 bedømmelser)

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

$50 USD på 1 dag
(0 bedømmelser)