Home

Creating a tournament table with an automatic points system

%3CLINGO-SUB%20id%3D%22lingo-sub-570343%22%20slang%3D%22en-US%22%3ECreating%20a%20tournament%20table%20with%20an%20automatic%20points%20system%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-570343%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20I%20am%26nbsp%3Bcreating%26nbsp%3Ba%26nbsp%3Btournament%26nbsp%3Btable%26nbsp%3Bfor%20a%20small%26nbsp%3Btournament%26nbsp%3Bthat%26nbsp%3Bsome%26nbsp%3Bfriends%2C%20and%20I%26nbsp%3Bare%26nbsp%3Bhosting.%26nbsp%3B%3C%2FP%3E%3CP%3EWe%26nbsp%3Bhave%208%20teams%2C%26nbsp%3Bspread%26nbsp%3Bout%20over%204%20matches%2C%20a%26nbsp%3Bsemifinal%2C%20and%20a%20final.%20The%26nbsp%3Bpointsystem%26nbsp%3Bis%20not%26nbsp%3Btoo%26nbsp%3Bimportant%26nbsp%3Bat%26nbsp%3Bthis%26nbsp%3Btime%2C%20it%20is%20more%20the%26nbsp%3Bfunctionality%26nbsp%3Bof%20it%2C%20so%20it%26nbsp%3Bcan%26nbsp%3Bbe%26nbsp%3Bused%26nbsp%3Bfor%20future%26nbsp%3Btournaments%2C%20and%26nbsp%3Bwe%26nbsp%3Bcan%26nbsp%3Bbuild%26nbsp%3Bupon%20it.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%3CU%3EThe%20setup%20is%20something%20like%20this%3A%3C%2FU%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMatch%201%3A%20Team%201%20Vs.%20Team%202%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMatch%202%3A%20Team%203%20Vs.%20Team%204%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMatch%203%3A%20Team%205%20Vs.%20Team%206%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMatch%204%3A%20Team%207%20Vs.%20Team%208%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20the%26nbsp%3Binevitable%26nbsp%3Bwinner%2C%20and%26nbsp%3Bloser%26nbsp%3Bvalues%26nbsp%3Bneeded%2C%20I%20have%20a%26nbsp%3Bsecond%26nbsp%3Bsheet%2C%20in%26nbsp%3Bthis%26nbsp%3Bwinning%26nbsp%3Bis%26nbsp%3Bsupposed%26nbsp%3Bto%26nbsp%3Bequal%26nbsp%3B2%2C%26nbsp%3Blosing%26nbsp%3Bto%26nbsp%3Bequal%26nbsp%3B1%2C%20and%20an%26nbsp%3Bunfinished%26nbsp%3Bgame%20is%20a%26nbsp%3Bnull%26nbsp%3Bvalue%26nbsp%3Bfor%26nbsp%3Bboth%26nbsp%3Bteams.%26nbsp%3BWhat%26nbsp%3BI%20am%26nbsp%3Blooking%26nbsp%3Bto%20do%2C%20is%26nbsp%3Blinking%26nbsp%3Bthe%26nbsp%3Bvarious%26nbsp%3Bteams%20in%20the%20''Team''-section%2C%20to%20the%26nbsp%3Brespective%26nbsp%3Bteams%20in%20the%26nbsp%3Bvarious%26nbsp%3Bmatches%2C%20in%26nbsp%3Bsuch%26nbsp%3Ba%26nbsp%3Bway%26nbsp%3Bthat%26nbsp%3Bwhen%26nbsp%3Ba%20team%26nbsp%3Bwins%2C%26nbsp%3Btwo%26nbsp%3Bpoints%20is%26nbsp%3Badded%26nbsp%3Bto%26nbsp%3Btheir%26nbsp%3Btotal%20score%2C%20and%20the%20team%20is%26nbsp%3Bmoved%26nbsp%3Bup%20to%20the%26nbsp%3Bappropriate%26nbsp%3Bposition.%20For%26nbsp%3BExample%2C%20Match%201%20is%20over%2C%20Team%202%26nbsp%3Bwon%2C%26nbsp%3Bwhen%26nbsp%3Bsetting%26nbsp%3Bthem%26nbsp%3Bas%20the%26nbsp%3Bwinner%26nbsp%3Bof%20the%20match%2C%20I%20imagine%26nbsp%3Busing%26nbsp%3Ba%20drop-down%26nbsp%3Bmenu%2C%26nbsp%3Bwhere%26nbsp%3Byou%26nbsp%3Bcan%26nbsp%3Bchoose%26nbsp%3B''Winner''%2C%20''Loser''%20or%20''Unfinished''%2C%20with%20the%26nbsp%3Brespective%26nbsp%3Bvalues%26nbsp%3Bunderlying%26nbsp%3Bthe%26nbsp%3Btext%2C%20the%26nbsp%3Btwo%26nbsp%3Bpoints%26nbsp%3Bare%26nbsp%3Badded%2C%20and%26nbsp%3Btheir%26nbsp%3Bposition%26nbsp%3Bchanges.%20Is%26nbsp%3Bthere%26nbsp%3Bany%26nbsp%3Bway%26nbsp%3Bto%26nbsp%3Bachieve%26nbsp%3Bthis%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20currently%20have%20a%20patch-work%20solution%20using%20a%20LOOKUP-formula%2C%20currently%20just%20for%20Team%201%2C%20where%20it%20is%20referencing%20the%20specific%20cell%20of%20the%20drop-down%20menu%2C%20and%20the%20data%20sheet%2C%20but%20this%20would%20be%20a%20rather%20tedious%20solution%20for%20each%20team.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20is%26nbsp%3Bthere%26nbsp%3Ba%26nbsp%3Bway%26nbsp%3Bfor%20teams%26nbsp%3Bdesignated%26nbsp%3Bas%20'Winners'%2C%20to%20automatically%20be%26nbsp%3Bmoved%26nbsp%3Bon%20to%20the%26nbsp%3Bsemifinals%26nbsp%3Bfor%26nbsp%3Bexample%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-570343%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
-S0me0ne_S0mewhere-
Occasional Visitor

Hi 

  

So, I am creating a tournament table for a small tournament that some friends, and I are hosting. 

We have 8 teams, spread out over 4 matches, a semifinal, and a final. The pointsystem is not too important at this time, it is more the functionality of it, so it can be used for future tournaments, and we can build upon it.  

  

The setup is something like this:

 

Match 1: Team 1 Vs. Team 2

 

Match 2: Team 3 Vs. Team 4

 

Match 3: Team 5 Vs. Team 6

 

Match 4: Team 7 Vs. Team 8

 

For the inevitable winner, and loser values needed, I have a second sheet, in this winning is supposed to equal 2, losing to equal 1, and an unfinished game is a null value for both teams. What I am looking to do, is linking the various teams in the ''Team''-section, to the respective teams in the various matches, in such a way that when a team wins, two points is added to their total score, and the team is moved up to the appropriate position. For Example, Match 1 is over, Team 2 won, when setting them as the winner of the match, I imagine using a drop-down menu, where you can choose ''Winner'', ''Loser'' or ''Unfinished'', with the respective values underlying the text, the two points are added, and their position changes. Is there any way to achieve this? 

 

I currently have a patch-work solution using a LOOKUP-formula, currently just for Team 1, where it is referencing the specific cell of the drop-down menu, and the data sheet, but this would be a rather tedious solution for each team. 

  

Also, is there a way for teams designated as 'Winners', to automatically be moved on to the semifinals for example? 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies