Log in

View Full Version : How does a party simulation begin?



psionic
10-11-2007, 09:25 PM
G'Day,

Just thought I might ask this group if they might remember what might the problem domain is. :dunno

Many years ago when I was learning C programming at TAFE or specially about arrays. An :motz2: engineering teacher gave us a programming homework to work on and hand in within two weeks to re-enforce programming concepts.

The program was along several lines like "Party Simulation" or "Cockatail Party Simulation".

The problem was given something like....

You are required to simulate a party where some members do not like one another. There is a say 30x 30 room where a 6x4 table in the middle of the room of finger foods and drinks left for anyone who want to eat/drink. There is about 6-10 people named A, B, C, D, E, F and P, Q, R, S, T, U (I'll stick to 6 for now) people who will meet other members who showed up.

I was then given a drawn configuration which all starts out.

Unfortunately I threw out my notes when cleaning out my house thinking I didn't needed it but oops so I cannot remember much.

There are constraints which you are not to have a certain person in the personal space of another person (you know a extravert in the way of an introvert, etc) so some people are more interested in one person while the other is trying to repel and so on.....

This was created to simulate a good party and to apply the maths formula of calculating the distance between two points and translating that back into an array.

I was interested to see if I could simiate this as an VBA programming excerise.

I tried finding under different on the web but not much like.

Thanks,
Psionic.

malik641
10-14-2007, 10:05 AM
Did you have to make it into a graphical representation?

This "could" be fun with Excel VBA...having people as Cells and one a persion would be considered not next to another if there is a single padding of cells surrounding the two...hmm.....

I have a feeling mvidas (Matt) will be taking a liking to this one (you should have seen his Christmas tree in Excel VBA :) Wow).

It's something to consider for sure. Just not too sure who would be up for the challenge.

psionic
10-14-2007, 06:04 PM
Yes malik641.

Although we used a old VAX machine back them so we had to represent them as ASCII emulating them on the VAX graphical driver.

It was awkward doing all that in my opinion. I guess it would be fun where each cell can be represented in any ASCII format.

Another thing about the problem, make the table in the centre of the room as # hashes so we can know what it is.

malik641
10-14-2007, 10:41 PM
Psionic,

Your idea inspired me to create a thread about having a VBA Challenges thread added to the site (http://vbaexpress.com/forum/showthread.php?t=15539). We'll see where that gets this site and I'd like to suggest your challenge as the first.

Let me know what you think.

Joseph

psionic
10-15-2007, 12:27 AM
Hi again, malik641. :hi:

I'm flabbgasted! :jawdown:

Sure! Go for it!

You have my permission if that is what you feel you seek from me.

Let me know how I can contribute in some way and possily with some more of my own later down the track.

Thanks and warm regards,
Psionic.