Quiz League Table

[Melton Fox]

Is it possible for me to insert an excel sheet with a league table of the ungoogleable music quiz?.

If not, is there a format I can use where I simply enter the results into a file on my PC, sort the data into league postions and then upload to the site?. Is it possible to produce the table in excel and then convert to another file type to upload?.

Word is the obvious one to use to copy and paste, but it doesn't allow me to "sort" the table.

Any advise please

 

[Han]

you could create the spreadsheet, zip it up and then upload onto the site as an attachment

 

[webmaster]

Why don't you just copy and paste from Excel into a post?

If you use the

 function it will format the table correctly.

 

[Melton Fox]

I have tried that, but all i get is this

[B][FONT=Arial]Pos.[/FONT][/B][B][FONT=Arial]User[/FONT][/B][B][FONT=Arial]R.1[/FONT][/B][B][FONT=Arial]R.2[/FONT][/B][B][FONT=Arial]R.3[/FONT][/B][B][FONT=Arial]R.4[/FONT][/B][B][FONT=Arial]Total Points[/FONT][/B][B][FONT=Arial]Games Won[/FONT][/B][FONT=Arial]1[/FONT][FONT=Arial]Fox From The Hudd[/FONT][FONT=Arial]50[/FONT][FONT=Arial]70[/FONT][FONT=Arial]30[/FONT][B][FONT=Arial]150[/FONT][/B][B][FONT=Arial]1[/FONT][/B][FONT=Arial]2[/FONT][FONT=Arial]muzzysgal[/FONT][FONT=Arial]70[/FONT][FONT=Arial]10[/FONT][FONT=Arial]50[/FONT][B][FONT=Arial]130[/FONT][/B][B][FONT=Arial]2[/FONT][/B][FONT=Arial]3[/FONT][FONT=Arial]Webbo[/FONT][FONT=Arial]30[/FONT][FONT=Arial]50[/FONT][B][FONT=Arial]80[/FONT][/B][B][FONT=Arial]1[/FONT][/B][FONT=Arial]4[/FONT][FONT=Arial]Lazzer[/FONT][FONT=Arial]30[/FONT][FONT=Arial]30[/FONT][B][FONT=Arial]60[/FONT][/B][B][FONT=Arial]1[/FONT][/B][FONT=Arial]5[/FONT][FONT=Arial]Mike Hunt Smells[/FONT][FONT=Arial]10[/FONT][FONT=Arial]50[/FONT][B][FONT=Arial]60[/FONT][/B][B][FONT=Arial]1[/FONT][/B][FONT=Arial]6[/FONT][FONT=Arial]Yorkshire Vixen[/FONT][FONT=Arial]10[/FONT][FONT=Arial]40[/FONT][B][FONT=Arial]50[/FONT][/B][FONT=Arial]7[/FONT][FONT=Arial]Highland[/FONT][FONT=Arial]30[/FONT][B][FONT=Arial]30[/FONT][/B][FONT=Arial]8[/FONT][FONT=Arial]Lesta-Jesta[/FONT][FONT=Arial]20[/FONT][B][FONT=Arial]20[/FONT][/B][FONT=Arial]9[/FONT][FONT=Arial]MK Fox[/FONT][FONT=Arial]20[/FONT][B][FONT=Arial]20[/FONT][/B][FONT=Arial]10[/FONT][FONT=Arial]fcukcov[/FONT][FONT=Arial]20[/FONT][B][FONT=Arial]20[/FONT][/B][FONT=Arial]11[/FONT][FONT=Arial]Ruth11[/FONT][FONT=Arial]10[/FONT][B][FONT=Arial]10[/FONT][/B][FONT=Arial]12[/FONT][FONT=Arial]Rayvon[/FONT][FONT=Arial]10[/FONT][B][FONT=Arial]10[/FONT][/B][FONT=Arial]13[/FONT][FONT=Arial]LeeH[/FONT][FONT=Arial]10[/FONT][B][FONT=Arial]10[/FONT][/B][FONT=Arial]14[/FONT][FONT=Arial]Nelly Furtardo[/FONT][FONT=Arial]10[/FONT][B][FONT=Arial]10[/FONT][/B][FONT=Arial]15[/FONT][FONT=Arial]City Fan[/FONT][FONT=Arial]10[/FONT][B][FONT=Arial]10[/FONT][/B]

 

[webmaster]

I have tried that, but all i get is this

Odd, it works fine for me - see below, pasted from Excel.
Which version of Excel are you using?

1	Douglas
1653	Stearman
3	McCarthy
16234	Kisnorbo
5	Johansson
132	Hughes
18	Joey
8	Hume
25	Fryatt
0	Smith
242	Wesolowski

 

[Melton Fox]

2003

 

[webmaster]

2003

Same as mine :icon_conf

Can you email me a copy of the spreadsheet - anything @ talkingballs.co.uk will get to me.

 

[Melton Fox]

Cheers Webbo,

You should now have it

 

[webmaster]

Pos.	R.1	R.2	R.3	R.4	Total 	Games Won	User
1		50	70	30	150	1	Fox From The Hudd
2		70	10	50	130	2	muzzysgal
3		30		50	80	1	Webbo
4	30		30		60	1	Lazzer
5			10	50	60	1	Mike Hunt Smells
6	10		40		50		Yorkshire Vixen
7	30				30		Highland
8	20				20		Lesta-Jesta
9		20			20		MK Fox
10		20			20		fcukcov
11	10				10		Ruth11
12		10			10		Rayvon
13				10	10		LeeH
14				10	10		Nelly Furtardo
15		10			10		City Fan

 

[Melton Fox]

Thanks Webbo,

I have also got that far, but you can't see the results from round 1 if the name is too long, is there anyway round this?

 

[Melton Fox]

It has also moved the columns out of line.

It has given you a total of 1 points, surely you don't find that acceptable :icon_razz

 

[webmaster]

I have also got that far, but you can't see the results from round 1 if the name is too long, is there anyway round this?

Yes - put the name at the end, like I've just done above!

 

[MKFox]

top stuff Melton, but I reckon you should do a PM quiz. Most people will miss one or two or more. that way everyone stands a fair chance....they can do it when they're back.

 

[Melton Fox]

Thank You

 

[Melton Fox]

top stuff Melton, but I reckon you should do a PM quiz. Most people will miss one or two or more. that way everyone stands a fair chance....they can do it when they're back.

I am trying to vary the times of day & night when I do this so everybody gets a chance.

If it were a PM how would I know who got which question right first?

 

[MKFox]

If it were a PM how would I know who got which question right first?

That's the point, more than 1 poster could get it right.

 

[webmaster]

That's the point, more than 1 poster could get it right.

And I could look at all the PMs to get the answers :icon_eek:

 

[Melton Fox]

Webbo,

I still can't upload this I still get all the gobbledegook. Please can you let me know how you did it, so I can be independant again.

Thanks in anticipation

 

[webmaster]

Webbo,

I still can't upload this I still get all the gobbledegook. Please can you let me know how you did it, so I can be independant again.

Thanks in anticipation

I just highlighighted the cells I wanted to copy in excel, pressed ctrl-c to copy, then pasted it into the forum by pressing ctrl-v and added the code tags.

 

[Melton Fox]

[B][FONT=Arial]Pos.[/FONT][/B][B][FONT=Arial]R.1[/FONT][/B][B][FONT=Arial]R.2[/FONT][/B][B][FONT=Arial]R.3[/FONT][/B][B][FONT=Arial]R.4[/FONT][/B][B][FONT=Arial]Total Points[/FONT][/B][B][FONT=Arial]Games Won[/FONT][/B][B][FONT=Arial]User[/FONT][/B][B][FONT=Arial]Pos.[/FONT][/B][FONT=Arial]1[/FONT][FONT=Arial]50[/FONT][FONT=Arial]70[/FONT][FONT=Arial]30[/FONT][B][FONT=Arial]150[/FONT][/B][B][FONT=Arial]1[/FONT][/B][FONT=Arial]Fox From The Hudd[/FONT][FONT=Arial]1[/FONT][FONT=Arial]2[/FONT][FONT=Arial]70[/FONT][FONT=Arial]10[/FONT][FONT=Arial]50[/FONT][B][FONT=Arial]130[/FONT][/B][B][FONT=Arial]2[/FONT][/B][FONT=Arial]muzzysgal[/FONT][FONT=Arial]2[/FONT][FONT=Arial]3[/FONT][FONT=Arial]30[/FONT][FONT=Arial]50[/FONT][B][FONT=Arial]80[/FONT][/B][B][FONT=Arial]1[/FONT][/B][FONT=Arial]Webbo[/FONT][FONT=Arial]3[/FONT][FONT=Arial]4[/FONT][FONT=Arial]30[/FONT][FONT=Arial]30[/FONT][B][FONT=Arial]60[/FONT][/B][B][FONT=Arial]1[/FONT][/B][FONT=Arial]Lazzer[/FONT][FONT=Arial]4[/FONT][FONT=Arial]5[/FONT][FONT=Arial]10[/FONT][FONT=Arial]50[/FONT][B][FONT=Arial]60[/FONT][/B][B][FONT=Arial]1[/FONT][/B][FONT=Arial]Mike Hunt Smells[/FONT][FONT=Arial]5[/FONT][FONT=Arial]6[/FONT][FONT=Arial]10[/FONT][FONT=Arial]40[/FONT][B][FONT=Arial]50[/FONT][/B][FONT=Arial]Yorkshire Vixen[/FONT][FONT=Arial]6[/FONT][FONT=Arial]7[/FONT][FONT=Arial]30[/FONT][B][FONT=Arial]30[/FONT][/B][FONT=Arial]Highland[/FONT][FONT=Arial]7[/FONT][FONT=Arial]8[/FONT][FONT=Arial]20[/FONT][B][FONT=Arial]20[/FONT][/B][FONT=Arial]Lesta-Jesta[/FONT][FONT=Arial]8[/FONT][FONT=Arial]9[/FONT][FONT=Arial]20[/FONT][B][FONT=Arial]20[/FONT][/B][FONT=Arial]MK Fox[/FONT][FONT=Arial]9[/FONT][FONT=Arial]10[/FONT][FONT=Arial]20[/FONT][B][FONT=Arial]20[/FONT][/B][FONT=Arial]fcukcov[/FONT][FONT=Arial]10[/FONT][FONT=Arial]11[/FONT][FONT=Arial]10[/FONT][B][FONT=Arial]10[/FONT][/B][FONT=Arial]Ruth11[/FONT][FONT=Arial]11[/FONT][FONT=Arial]12[/FONT][FONT=Arial]10[/FONT][B][FONT=Arial]10[/FONT][/B][FONT=Arial]Rayvon[/FONT][FONT=Arial]12[/FONT][FONT=Arial]13[/FONT][FONT=Arial]10[/FONT][B][FONT=Arial]10[/FONT][/B][FONT=Arial]LeeH[/FONT][FONT=Arial]13[/FONT][FONT=Arial]14[/FONT][FONT=Arial]10[/FONT][B][FONT=Arial]10[/FONT][/B][FONT=Arial]Nelly Furtardo[/FONT][FONT=Arial]14[/FONT][FONT=Arial]15[/FONT][FONT=Arial]10[/FONT][B][FONT=Arial]10[/FONT][/B][FONT=Arial]City Fan[/FONT][FONT=Arial]15[/FONT]

What am I doing wrong then?. I copied your instructions to the letter