![]() |
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 |
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 |
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