Page 1 of 2

Excel Spreadsheet for Running Tournaments (ExScore)

Posted: Sun Jun 19, 2016 10:42 pm
by sann0638
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/

Re: Excel Spreadsheet for Running Tournaments (ExScore)

Posted: Tue Jun 21, 2016 11:20 pm
by sann0638
V2 now available, not that anyone noticed V1...

It's quite snazzy, do have a look.

Re: Excel Spreadsheet for Running Tournaments (ExScore)

Posted: Wed Jun 22, 2016 5:16 am
by Dark Duke
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!

Re: Excel Spreadsheet for Running Tournaments (ExScore)

Posted: Wed Jun 22, 2016 6:23 am
by lunchmoney
Dark Duke wrote:I've downloaded it (no chance to play with it yet)
Snap.

Re: Excel Spreadsheet for Running Tournaments (ExScore)

Posted: Wed Jun 22, 2016 6:26 am
by sann0638
Sure, just being silly. Should have mentioned clawpomb to get a response... :)

Re: Excel Spreadsheet for Running Tournaments (ExScore)

Posted: Wed Jun 22, 2016 6:40 am
by babass
sann0638 wrote:Sure, just being silly. Should have mentioned clawpomb to get a response... :)
Your file is broken :o




;)

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

Re: Excel Spreadsheet for Running Tournaments (ExScore)

Posted: Wed Jun 22, 2016 7:32 am
by sann0638
Good to know. It's an excel sheet with macros in. If your work doesn't like them, it won't like this!

Posted: Wed Jun 22, 2016 9:06 am
by sphinx
Nice job, I just tried it to simulate a tournament like the one i'm running, and seemed to work fine. The only thing I missed on it is the possibility to configure the tiebreakers.

Enviado desde mi Nexus 5 mediante Tapatalk

Re: Excel Spreadsheet for Running Tournaments (ExScore)

Posted: Wed Jun 22, 2016 10:34 am
by sann0638
Which tiebreaker do you use?

Posted: Wed Jun 22, 2016 10:38 am
by sphinx
In order Net TD, Net Cas, TD f, Cas f

Enviado desde mi Nexus 5 mediante Tapatalk

Re: Excel Spreadsheet for Running Tournaments (ExScore)

Posted: Wed Jun 22, 2016 10:56 am
by lunchmoney
Needs to be prettier. ;)



And more cow bell.

Re:

Posted: Wed Jun 22, 2016 11:29 am
by sann0638
sphinx wrote:In order Net TD, Net Cas, TD f, Cas f

Enviado desde mi Nexus 5 mediante Tapatalk
Cool. Will add that functionality this evening, and then comes the big one - group Swiss :)
lunchmoney wrote: And more cow bell.
Will see what I can do.

Re: Excel Spreadsheet for Running Tournaments (ExScore)

Posted: Wed Jun 22, 2016 12:02 pm
by JaM
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.

Re: Excel Spreadsheet for Running Tournaments (ExScore)

Posted: Wed Jun 22, 2016 1:09 pm
by sann0638
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 :)

Re: Excel Spreadsheet for Running Tournaments (ExScore)

Posted: Sat Jun 25, 2016 8:50 am
by sann0638
Tiebreakers fully implemented, and NAF upload file: http://www.sann0638.co.uk/exscore/