Excel Spreadsheet for Running Tournaments (ExScore)
Moderators: lunchmoney, TFF Mods
- sann0638
- Kommissar Enthusiasmoff
- Posts: 6610
- Joined: Mon May 08, 2006 10:24 am
- Location: Swindon, England
Excel Spreadsheet for Running Tournaments (ExScore)
Evening all - I've produced an Excel file that runs a Swiss system for BB tournaments, like Score but with increased flexibiliity. Have a look, and let me know if you find any mistakes. Long way to go, but quite pleased with it. http://www.sann0638.co.uk/exscore/
Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
- sann0638
- Kommissar Enthusiasmoff
- Posts: 6610
- Joined: Mon May 08, 2006 10:24 am
- Location: Swindon, England
Re: Excel Spreadsheet for Running Tournaments (ExScore)
V2 now available, not that anyone noticed V1...
It's quite snazzy, do have a look.
It's quite snazzy, do have a look.
Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
- Dark Duke
- Veteran
- Posts: 201
- Joined: Wed Jan 26, 2005 7:57 am
- Location: Valencia
Re: Excel Spreadsheet for Running Tournaments (ExScore)
It didn't go unnoticed, I guess nobody has had the chance to try it yet. I've downloaded it (no chance to play with it yet) and I guess I'm not the only one, hehehe.
Thanks for the tool!
Thanks for the tool!
Reason: ''
Life is short, block fast.
- lunchmoney
- Legend
- Posts: 8898
- Joined: Wed Dec 10, 2008 2:59 pm
- Location: The Dark Future
Re: Excel Spreadsheet for Running Tournaments (ExScore)
Snap.Dark Duke wrote:I've downloaded it (no chance to play with it yet)
Reason: ''
Hired Goon for the NAF (rep for South West England)
lunchmoneybb@gmail.com
TOs! You do not need multiple copies of rosters. It's a waste of paper.
Bribe level: good coffee.
#FlingNation find me on page 95
lunchmoneybb@gmail.com
TOs! You do not need multiple copies of rosters. It's a waste of paper.
Bribe level: good coffee.
#FlingNation find me on page 95
- sann0638
- Kommissar Enthusiasmoff
- Posts: 6610
- Joined: Mon May 08, 2006 10:24 am
- Location: Swindon, England
Re: Excel Spreadsheet for Running Tournaments (ExScore)
Sure, just being silly. Should have mentioned clawpomb to get a response...
Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
-
- Super Star
- Posts: 779
- Joined: Tue Feb 12, 2013 4:05 pm
Re: Excel Spreadsheet for Running Tournaments (ExScore)
Your file is brokensann0638 wrote:Sure, just being silly. Should have mentioned clawpomb to get a response...
I had no opportuinity to try it actually
and when i want to look at it, i have the following:
Your request was denied because of its content categorization: "Suspicious"
More information: Access Denied - Blocked by content filter
If you have any questions or concerns, don't hesitate to contact Helpdesk - #3333
Reason: ''
- sann0638
- Kommissar Enthusiasmoff
- Posts: 6610
- Joined: Mon May 08, 2006 10:24 am
- Location: Swindon, England
Re: Excel Spreadsheet for Running Tournaments (ExScore)
Good to know. It's an excel sheet with macros in. If your work doesn't like them, it won't like this!
Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
- sann0638
- Kommissar Enthusiasmoff
- Posts: 6610
- Joined: Mon May 08, 2006 10:24 am
- Location: Swindon, England
Re: Excel Spreadsheet for Running Tournaments (ExScore)
Which tiebreaker do you use?
Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
- lunchmoney
- Legend
- Posts: 8898
- Joined: Wed Dec 10, 2008 2:59 pm
- Location: The Dark Future
Re: Excel Spreadsheet for Running Tournaments (ExScore)
Needs to be prettier.
And more cow bell.
And more cow bell.
Reason: ''
Hired Goon for the NAF (rep for South West England)
lunchmoneybb@gmail.com
TOs! You do not need multiple copies of rosters. It's a waste of paper.
Bribe level: good coffee.
#FlingNation find me on page 95
lunchmoneybb@gmail.com
TOs! You do not need multiple copies of rosters. It's a waste of paper.
Bribe level: good coffee.
#FlingNation find me on page 95
- sann0638
- Kommissar Enthusiasmoff
- Posts: 6610
- Joined: Mon May 08, 2006 10:24 am
- Location: Swindon, England
Re:
Cool. Will add that functionality this evening, and then comes the big one - group Swisssphinx wrote:In order Net TD, Net Cas, TD f, Cas f
Enviado desde mi Nexus 5 mediante Tapatalk
Will see what I can do.lunchmoney wrote: And more cow bell.
Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
- JaM
- Legend
- Posts: 2580
- Joined: Sun Oct 31, 2004 7:38 pm
- Location: The Netherlands.
Re: Excel Spreadsheet for Running Tournaments (ExScore)
If I fill in the names and after that, want to see the round I cant find the names anymore.... So I cant see who's playing who.
And I have a feeling that all the 40 players are rostered..?
You should indeed be able to define tiebrakers, and perhaps a method to make sure people of the same league dont play each other the first round.
Will give the next one a spin, too. Because I might have missed some stuff.
But I've used score before, that did work for me.
And I have a feeling that all the 40 players are rostered..?
You should indeed be able to define tiebrakers, and perhaps a method to make sure people of the same league dont play each other the first round.
Will give the next one a spin, too. Because I might have missed some stuff.
But I've used score before, that did work for me.
Reason: ''
- sann0638
- Kommissar Enthusiasmoff
- Posts: 6610
- Joined: Mon May 08, 2006 10:24 am
- Location: Swindon, England
Re: Excel Spreadsheet for Running Tournaments (ExScore)
Not sure what you are describing, if you can be more specific that would be helpful.
And to be clear, I love Score, it's brilliant and does the job for 99% of tournaments. But there are some gaps, and I'm trying to fill those
And to be clear, I love Score, it's brilliant and does the job for 99% of tournaments. But there are some gaps, and I'm trying to fill those
Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
- sann0638
- Kommissar Enthusiasmoff
- Posts: 6610
- Joined: Mon May 08, 2006 10:24 am
- Location: Swindon, England
Re: Excel Spreadsheet for Running Tournaments (ExScore)
Tiebreakers fully implemented, and NAF upload file: http://www.sann0638.co.uk/exscore/
Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler