Arranging seats using a macro

[Meghanath]

Hi,

I need to arrange seats based on pitch. This is being done in 2D. I have the seat contours as an instance. This has to start at certain point (say X = 50.0) and be incremented from there onwards. The seat pitch is not constant. I was looking to create a user form which first asks the user to input the number of seats and then displays another user form with columns to the number of seats entered, to enter different pitches between seats. How can I do this using a macro.

Thank you!

 

[ferdo]

Hi,

Just for my curiosity, a fixed number of seats or it can be variable? How many columns? Is it in an aircraft I suppose, yes? How many on left, on right? On center also?

Pitch is same along the column or can be different along the columns starting with a specific point (or in different zones)?

It seems to be a problem of optimization, final goal is to have as much seats is possible or ? In real life in an aircraft you have a lot of restrictions...

Regards
Fernando

https://picasaweb.google.com/102257836106335725208

https://picasaweb.google.com/103462806772634246699/

 

[Meghanath]

Hi ferdo,

It is for the aircraft. Left hand side and right hand side may sometimes be different, but it will mostly be same. Right hand side will start at a different x station. Pitch may vary from one row to another, but the distance column wise will be same. I don't mind entering pitch value for each row separately, but I am looking at something which asks repeatedly for pitch values based on the number of rows I select for each side (LH & RH).

Thank you

 

[Maddy02]

you could have incorporated the pitch same in userform and then read from it as you have created it.

Whats the point in entering each pitch aging and again.
Perhaps a userform with proper description of rows and columns along with pitch will be more than sufficient.
you can have the userform to enter all pitches at one shot.

First Populate a listbox or combobox with some default pitch.
1. User selects a row in a listbox or combobox
2. Below combo box you can insert some textboxes for entering pitch.
3. Once pitch entered, detect the change and update the new pitch.
4. At last click OK to create the arrangement based on the pitch entered and with some default pitch.


Regards,
Maddy