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.

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

Se mere: know two lines parallel, determine two lines intersect, two excel vba, problem solving vba, 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)