[Solved] How to create a Music Trivia Scoreboard

Discuss the spreadsheet application

[Solved] How to create a Music Trivia Scoreboard

Postby TamzBiz » Tue Aug 02, 2016 12:05 am

Good Day

I would like to organize a Music Trivia Evening for our church. I however would like to create a scoreboard for this activity to help keep teams motivated and enthusiastic to play by seeing their progress after each round of questions.

I am planning at least 20 rounds of questions and after each round i want to input the teams scores, and I need the leader board to re-arrange according to who is leading etc.
So if a team moved up from the last position your score turns green, if a team moved down it turns red and if a team stayed in that position it stays blue.

If anyone can assist me with an idea as to how I can create this Scoreboard I would appreciate it greatly.

Thank you

Paul
Last edited by TamzBiz on Tue Aug 02, 2016 9:24 pm, edited 1 time in total.
Apache Open Office 4.1.2 on Windows 8.1
TamzBiz
 
Posts: 4
Joined: Mon Aug 01, 2016 11:53 pm

Re: How to create a Music Trivia Scoreboard

Postby Alex1 » Tue Aug 02, 2016 1:51 am

Here's an example. The requirement to show movements with colours made it quite complicated, because it requires calculation of both the current and the previous scores. The old scores table and the Order and Row columns on the Score sheet can be hidden if necessary. Scores should be integer numbers, otherwise a different way of ordening is necessary.
Attachments
Scoreboard84452.ods
(11.15 KiB) Downloaded 49 times
AOO 4.1.7 & LO 5.0.6 on Windows XP & 7
Alex1
Volunteer
 
Posts: 608
Joined: Fri Feb 26, 2010 1:00 pm
Location: Netherlands

Re: How to create a Music Trivia Scoreboard

Postby TamzBiz » Tue Aug 02, 2016 2:16 am

@Alex1
Thank you for trying to help me, I tried opening your example and it is read only so I can't enter any data to see how it works.

I have an example so long but I find that I manually have to sort it after each round to get the order right according to rank
Attachments
Scorecard.ods
(9.96 KiB) Downloaded 48 times
Apache Open Office 4.1.2 on Windows 8.1
TamzBiz
 
Posts: 4
Joined: Mon Aug 01, 2016 11:53 pm

Re: How to create a Music Trivia Scoreboard

Postby ken johnson » Tue Aug 02, 2016 2:48 am

Use "Save As" to save an editable copy of Alex's doc in your Documents.

Ken Johnson
AOO 4.1.3 on Ms Windows 10
Help improve this forum by clicking the EDIT button on your first post then adding "[Solved]" to its heading once a solution to your problem has been provided.
ken johnson
Volunteer
 
Posts: 918
Joined: Sun May 31, 2009 1:35 am
Location: Sydney, Australia

Re: How to create a Music Trivia Scoreboard

Postby TamzBiz » Tue Aug 02, 2016 3:14 am

@Alex1 @Ken Johnson

Is there a way I can sort out the scorecard according to the rank after each round automatically and not manually as In my example after each round according to the rank in column X
Apache Open Office 4.1.2 on Windows 8.1
TamzBiz
 
Posts: 4
Joined: Mon Aug 01, 2016 11:53 pm

Re: How to create a Music Trivia Scoreboard

Postby MrProgrammer » Tue Aug 02, 2016 4:34 am

TamzBiz wrote:s there a way I can sort out the scorecard according to the rank after each round automatically and not manually as In my example after each round according to the rank in column X
[Tutorial] Sorting and Filtering data with formulas

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3966
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: How to create a Music Trivia Scoreboard

Postby Alex1 » Tue Aug 02, 2016 8:25 am

TamzBiz wrote:@Alex1 @Ken Johnson

Is there a way I can sort out the scorecard according to the rank after each round automatically and not manually as In my example after each round according to the rank in column X

That's what my example does, but if you don't know how to save and open a file I can't help you.
AOO 4.1.7 & LO 5.0.6 on Windows XP & 7
Alex1
Volunteer
 
Posts: 608
Joined: Fri Feb 26, 2010 1:00 pm
Location: Netherlands

Re: How to create a Music Trivia Scoreboard

Postby ken johnson » Tue Aug 02, 2016 5:18 pm

In the attached doc column Z shows the teams in rank order.
Columns Y, AB and AC can be hidden.

Ken Johnson
Attachments
Scorecard with column showing teams in rank order.ods
(11.8 KiB) Downloaded 44 times
AOO 4.1.3 on Ms Windows 10
Help improve this forum by clicking the EDIT button on your first post then adding "[Solved]" to its heading once a solution to your problem has been provided.
ken johnson
Volunteer
 
Posts: 918
Joined: Sun May 31, 2009 1:35 am
Location: Sydney, Australia

Re: How to create a Music Trivia Scoreboard

Postby TamzBiz » Tue Aug 02, 2016 9:23 pm

Thank you to @Alex1 @Ken Johnson @MrProgrammer
Ken Johnson took my idea and vastly improved my effort, Thank you so much Ken.
I am so greatful to all 3 of you for assisting me, I am self taught and I try learn every day so I hope to learn what each formulae does but I will take a look at Ken's functions and try figure out how it works but all I know is it does just that it works the way I expected it to.

This question is Solved thank you.
Apache Open Office 4.1.2 on Windows 8.1
TamzBiz
 
Posts: 4
Joined: Mon Aug 01, 2016 11:53 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 13 guests