| Author |
Message |
Tojurub |
|
Post subject: Series Score-Keeping with Excel
 Posted: Sep 15, 2015 - 03:34 AM
|
|
Joined: Aug 18, 2003
Germany
Posts: 1520
Location: Germany
Status: Offline
|
|
Since I now have 3 Tournament Series equipped with an Excel Sheet, which helps keep track with the correct ranking, I think I might offer it to others as well.
It's an Excel sheet with Macros (.xlsm), and therefore it only works with MS Office 2007 and later, sorry, no Open Office or similar.
One can upload the final ranking files from Score (.htm) or any other .txt or .csv automatically. So far it is set up for a Structured Series, but I believe I can modify it to the Open Series as well, as long as the scoring is not to extraordinary.
It can also create a simple webpage with the rankings.
So, whoever is interested, send me a PM with your e-mail address  |
_________________
Dwarves rule!!! Especially when they pass!
3rd place Underworld Cup 2003
Swiss Champion 2004
2nd place Royal RumBBL 2015 and White Star Cup 2016
.....and now Ex-Vize-Prez
|
| |
|
|
|
 |
|
Gaixo |
|
|
Post subject: RE: Series Score-Keeping with Excel
Posted: Sep 15, 2015 - 05:57 AM
|
|
Former President
Joined: May 08, 2009
United States of America
Posts: 811
Location: United States of America
Status: Offline
|
|
I'm interested! I think it's too late for 2015, but maybe I can give it to the sucker who takes over ECTS tracking next year.  |
_________________
National Tournament Organizer, USA
(NAF Tournament Director, 2014-2018; NAF President, 2018-2024)
|
| |
|
|
|
|
|
Tojurub |
|
|
Post subject: RE: Series Score-Keeping with Excel
Posted: Sep 15, 2015 - 09:04 AM
|
|
Joined: Aug 18, 2003
Germany
Posts: 1520
Location: Germany
Status: Offline
|
|
| I'll give it a try....just one question about the Stunty scores. So the best Stunty team will get 10 points, regardless were it will end up in the main ranking, right?...and there is no minimum limit of Stunty teams, e.g. at least 2 teams, right? (ok, 2 questions ) |
_________________
Dwarves rule!!! Especially when they pass!
3rd place Underworld Cup 2003
Swiss Champion 2004
2nd place Royal RumBBL 2015 and White Star Cup 2016
.....and now Ex-Vize-Prez
|
| |
|
|
|
|
|
Gaixo |
|
|
Post subject: RE: Series Score-Keeping with Excel
Posted: Sep 15, 2015 - 10:32 AM
|
|
Former President
Joined: May 08, 2009
United States of America
Posts: 811
Location: United States of America
Status: Offline
|
|
| In an Open Series, you just earn points in the same way as usual, but those earned using stunty teams also count toward the stunty standings. So if you came in third place with halflings in a two day tournament, you would get 8 points (placement - 3rd place) plus 2 (participation - 2 day) toward both your overall and stunty scores. |
_________________
National Tournament Organizer, USA
(NAF Tournament Director, 2014-2018; NAF President, 2018-2024)
|
| |
|
|
|
|
|
Tojurub |
|
|
Post subject: RE: Series Score-Keeping with Excel
Posted: Sep 15, 2015 - 02:43 PM
|
|
Joined: Aug 18, 2003
Germany
Posts: 1520
Location: Germany
Status: Offline
|
|
| ok. Sounds a bit odd to me, but I'll set it up that way. |
_________________
Dwarves rule!!! Especially when they pass!
3rd place Underworld Cup 2003
Swiss Champion 2004
2nd place Royal RumBBL 2015 and White Star Cup 2016
.....and now Ex-Vize-Prez
|
| |
|
|
|
|
|
Tojurub |
|
|
Post subject: RE: Series Score-Keeping with Excel
Posted: Oct 04, 2015 - 04:29 PM
|
|
Joined: Aug 18, 2003
Germany
Posts: 1520
Location: Germany
Status: Offline
|
|
| So, SWTC, SBBM and ECTS are served, anybody else who wants to join the Excel sheet club? |
_________________
Dwarves rule!!! Especially when they pass!
3rd place Underworld Cup 2003
Swiss Champion 2004
2nd place Royal RumBBL 2015 and White Star Cup 2016
.....and now Ex-Vize-Prez
|
| |
|
|
|
|
|
|
