Spreadsheet Masters, Help

Talk about and discuss various advancements and achievents in the arts and sciences of invention and modification; computers, sciences, mathematics, and technology for all.
Post Reply
User avatar
AYHJA
392
Posts: 37990
Joined: Fri Sep 17, 2004 2:25 pm
Location: Washington, D.C.
Contact:

Spreadsheet Masters, Help

#1

Post 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
ImageImage
Image Image

BBcode:
Hide post links
Show post links
jonasgrim
Posts: 126
Joined: Wed Jun 28, 2006 3:34 pm

#2

Post 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...

BBcode:
Hide post links
Show post links
User avatar
AYHJA
392
Posts: 37990
Joined: Fri Sep 17, 2004 2:25 pm
Location: Washington, D.C.
Contact:

#3

Post 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

BBcode:
Hide post links
Show post links
User avatar
raum
Posts: 3944
Joined: Sun Jul 24, 2005 10:51 am

#4

Post 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

BBcode:
Hide post links
Show post links
User avatar
AYHJA
392
Posts: 37990
Joined: Fri Sep 17, 2004 2:25 pm
Location: Washington, D.C.
Contact:

#5

Post 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...

BBcode:
Hide post links
Show post links
WAY
Site Admin
Posts: 2411
Joined: Sat Nov 06, 2004 4:43 am
Location: Sydney, Australia
Contact:

#6

Post by WAY »

Also, since you're using Office 07, could you save it in OpenOffice format too..? lol

BBcode:
Hide post links
Show post links
User avatar
AYHJA
392
Posts: 37990
Joined: Fri Sep 17, 2004 2:25 pm
Location: Washington, D.C.
Contact:

#7

Post by AYHJA »

You want a crack at it..? LoL...

BBcode:
Hide post links
Show post links
jonasgrim
Posts: 126
Joined: Wed Jun 28, 2006 3:34 pm

#8

Post 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" />

BBcode:
Hide post links
Show post links
WAY
Site Admin
Posts: 2411
Joined: Sat Nov 06, 2004 4:43 am
Location: Sydney, Australia
Contact:

#9

Post 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..

BBcode:
Hide post links
Show post links
User avatar
AYHJA
392
Posts: 37990
Joined: Fri Sep 17, 2004 2:25 pm
Location: Washington, D.C.
Contact:

#10

Post 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...

BBcode:
Hide post links
Show post links
Post Reply