ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to CreateTournament Worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/35526-how-createtournament-worksheet.html)

Jarvis

How to CreateTournament Worksheet
 

I'm not an experienced user of excel but want to create a worksheet
sheet to work in a tournament format with picture, have two picture
next to each other click on one and it moves it to the next round. I
have around 20 pictures of teams and which need to gradually reduce to
a winner in the final. Can anyone help? Is there a template to get hold
of. Thought someone will have already done some thing like this for
football teams?


--
Jarvis
------------------------------------------------------------------------
Jarvis's Profile: http://www.excelforum.com/member.php...o&userid=25258
View this thread: http://www.excelforum.com/showthread...hreadid=387503


Michael

Hi Jarvis. If you're not real experienced with Excel you might want to
consider another method. You could build your own "Tournament Tree" in Excel
by using Format - Borders, and typing into the cells the name of each team.
This will show the progression thru the tournament. I built a tree for a
20-team, single elimination tournament. It looks to me like one team will
have to get a by. HTH
--
Sincerely, Michael Colvin


"Jarvis" wrote:


I'm not an experienced user of excel but want to create a worksheet
sheet to work in a tournament format with picture, have two picture
next to each other click on one and it moves it to the next round. I
have around 20 pictures of teams and which need to gradually reduce to
a winner in the final. Can anyone help? Is there a template to get hold
of. Thought someone will have already done some thing like this for
football teams?


--
Jarvis
------------------------------------------------------------------------
Jarvis's Profile: http://www.excelforum.com/member.php...o&userid=25258
View this thread: http://www.excelforum.com/showthread...hreadid=387503



Rafael

Hello Jarvis. Just divided the 20 teams on group of 5. Given the to team a
bye. The winner of 19 and 20 play 1 the winner of 17 and 18 play 2, winner of
14 and 16 play 3 and winner of 12 and 13 play 4.

"Michael" wrote:

Hi Jarvis. If you're not real experienced with Excel you might want to
consider another method. You could build your own "Tournament Tree" in Excel
by using Format - Borders, and typing into the cells the name of each team.
This will show the progression thru the tournament. I built a tree for a
20-team, single elimination tournament. It looks to me like one team will
have to get a by. HTH
--
Sincerely, Michael Colvin


"Jarvis" wrote:


I'm not an experienced user of excel but want to create a worksheet
sheet to work in a tournament format with picture, have two picture
next to each other click on one and it moves it to the next round. I
have around 20 pictures of teams and which need to gradually reduce to
a winner in the final. Can anyone help? Is there a template to get hold
of. Thought someone will have already done some thing like this for
football teams?


--
Jarvis
------------------------------------------------------------------------
Jarvis's Profile: http://www.excelforum.com/member.php...o&userid=25258
View this thread: http://www.excelforum.com/showthread...hreadid=387503




All times are GMT +1. The time now is 10:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com