I need to randomize a seating chart.
- or -
Post a project like this$$
- Posted:
- Proposals: 15
- Remote
- #694651
- Expired
Very experienced Excel user (including VBA), data analyst, and report writer. Currently working in a full time position but available on evenings and weekends.
Llanelli
5066672286114612177369351470399221416590652992698473745272849746876498
Description
Experience Level: Intermediate
Hi,
I've got a problem which I initially thought would be very straightforward and that most likely I would be able to easily find a ready made template.
My conundrum is that I have a list of 150 names, and 12 times a year around a 100 of them get together on different tables, around 15 on each table.
Like I said around 100 of the 150 attend each event, which can be marked in a number of ways, for example by marking "x" in a column. When it comes to each event I want the excel sheet to randomize the persons through to each table as to not always having the same seating arrangement event after event.
It would obviously be optimal if I could each time, depending on how many attendees figure out how many tables I need and only randomize through to those tables, but that is something that would be possible to manually do each time.
Any changes/modifications to the draft above are very welcome. Open to both easy excel fixes and more complex VBA work. Also if you have a ready made template that would up fill the standards above that would work as well.
Regards,
Gulli
I've got a problem which I initially thought would be very straightforward and that most likely I would be able to easily find a ready made template.
My conundrum is that I have a list of 150 names, and 12 times a year around a 100 of them get together on different tables, around 15 on each table.
Like I said around 100 of the 150 attend each event, which can be marked in a number of ways, for example by marking "x" in a column. When it comes to each event I want the excel sheet to randomize the persons through to each table as to not always having the same seating arrangement event after event.
It would obviously be optimal if I could each time, depending on how many attendees figure out how many tables I need and only randomize through to those tables, but that is something that would be possible to manually do each time.
Any changes/modifications to the draft above are very welcome. Open to both easy excel fixes and more complex VBA work. Also if you have a ready made template that would up fill the standards above that would work as well.
Regards,
Gulli
Gulli G.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
20 Apr 2024
Iceland
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies