Page 1 of 1

Spreadsheet Masters, Help

Posted: Sat Jul 22, 2006 2:03 am
by AYHJA
Hello...

While I am having lots of fun in Excel, I'm not too very good at it...

As you may or may not know, we have a tournament going on the site...I've set up an Excel sheet with the brackets...Its supposed to be a march madness, elimination kinda thing, we hope to tally the points to see the next round...So, I would need something that can do the job, and looks pretty and all that...

If someone is up for it, here is the raw book, with the seeds, the girls name, etc...The rest, I leave up to you side any questions you may have...

Oh, and if you can, vote plz... /smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" />

AF Gostosa League, Best ass tournament

Posted: Sat Jul 22, 2006 2:26 am
by jonasgrim
ayhja, i am not an expert about excel but i'm gonna try and see if i can help. but first i need a file that can be openned with office 2003. this xlsx format is for office 2007 only...

Posted: Sat Jul 22, 2006 3:00 am
by AYHJA
Thanks for teh reply M8...Ironic you would reply to this thread, I think you're my first round opponent..! LoL...Good luck to you..!

Here's the sheet in the 2003 format:

AFGL 2003

Posted: Sat Jul 22, 2006 4:35 am
by raum
What exactly do you hope to view analyze or record by this spread sheet.

I cleaned your data up, and acould format or formulate it anyway ya wanna try.

I see 18 rows of data, I parsed the data to three columns, #, First Name, Last Name. What else do you need.

If you are more specific, I can show you how to do it. Anyway, here is your data in a spreadsheet format.

ID F.Name L.Name
1 Juliana Paes
18 Aida Yespica
3 Ariah
16 Selena Spice
5 emanon's unk
14 Jana Cat
7 Silvia Saint
12 Divini Rae
9 Keyra
10 Vida Guerra
8 Shannon Stewart
11 Lyna
6 Natasha Yi
13 Ana Lima
4 Courtney R. Culkin
15 Karen McDougal
2 Stacy Keibler
17 Sung Hi Lee

Posted: Sat Jul 22, 2006 9:14 am
by AYHJA
Ideallly its supposed ot be brackets...

But I innted to post points (from the final vote tally) also as in the mix, etc,

1 Juliana Paes (10)
18 Aida Yespica (2)

And so forth...I was wonering maybe if there was a way I could have the sheet tally the votes per row to determine a points winner as well as a torney winner...

Posted: Sat Jul 22, 2006 11:52 am
by WAY
Also, since you're using Office 07, could you save it in OpenOffice format too..? lol

Posted: Sat Jul 22, 2006 1:06 pm
by AYHJA
You want a crack at it..? LoL...

Posted: Sat Jul 22, 2006 6:30 pm
by jonasgrim
QUOTE(AYHJA)1 Juliana Paes (10)
18 Aida Yespica (2)
hey admin man. are you trying to effect voters decissions by giving this unreal results of our match /:D" style="vertical-align:middle" emoid=":D" border="0" alt=":D" />
***aida rocks***

btw the things you've asked for exceeds my excel capabilities. sorry /sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" />

Posted: Sat Jul 22, 2006 6:38 pm
by WAY
I'll try..! lol
And I think MySQL might fit this well - votes can be updated in real-time and anyone can look at it without waiting for you to update the spreadsheet..

Posted: Sat Jul 22, 2006 8:05 pm
by AYHJA
In that case: http://deus.ayhja.us/rar/AFGLRRT_BestAss-OO.rar

QUOTE(jonasgrim)hey admin man. are you trying to effect voters decissions by giving this unreal results of our match

LoL...Nah, not really..! I didn't know that it'd be so close, really...Aida is sexy...But...I didn't think she had an ass until now, LOL...We'll see how goes it though, right now, I think I'm barely winning...