Register    Login    Forum    FAQ

Board index » Community Discussion » Tournament Discussions




Post new topic Reply to topic  [ 30 posts ]  Go to page Previous  1, 2
Author Message
 Post subject:
 Post Posted: Sat Jun 25, 2016 7:37 pm 
Rookie
Rookie

Joined: Tue Dec 22, 2009 6:41 pm
Posts: 52
Thanks!!! I'll try it asap :)

Enviado desde mi Nexus 5 mediante Tapatalk


Top 
 Profile  
 
 Post subject: Re: Excel Spreadsheet for Running Tournaments (ExScore)
 Post Posted: Sun Jun 26, 2016 8:44 pm 
Kommissar Enthusiasmoff
User avatar

Joined: Mon May 08, 2006 11:24 am
Posts: 5379
Location: Swindon, England
Getting very close to the group implementation being completed, so simulated a quick 4 nations. Well done Wales! Shame that in coding this, I realised lots of the earlier coding could have been done a lot more efficiently. Summer holidays project to change it...

I'm hoping that once I've implemented the code in Excel, it might well be able to be ported to a stand along programme, though that would require a bit of learning on my part!


You do not have the required permissions to view the files attached to this post.

_________________
NAF President
Founder of SAWBBL, Swindon and Wiltshire's BB League @ sawbbl.uk
Image


Top 
 Profile  
 
 Post subject:
 Post Posted: Mon Jun 27, 2016 7:58 am 
Rookie
Rookie

Joined: Tue Dec 22, 2009 6:41 pm
Posts: 52
Hi, I've made some different trys with the sheet it seems that work fine, the Naf result sheet looks great too. But I have a problem, I have not been able to set right tge tiebreakers, how do I mark them so the sheet takes them in care when ordering the table?

Enviado desde mi Nexus 5 mediante Tapatalk


Top 
 Profile  
 
 Post subject: Re: Excel Spreadsheet for Running Tournaments (ExScore)
 Post Posted: Mon Jun 27, 2016 8:04 am 
Kommissar Enthusiasmoff
User avatar

Joined: Mon May 08, 2006 11:24 am
Posts: 5379
Location: Swindon, England
Put a 1 next to the first one, 2 next to the second one and so on. So if you want Opponent Score as first tiebreaker, put a 1 next to it.

Let me know if it doesn't work, thanks for trying it out.

_________________
NAF President
Founder of SAWBBL, Swindon and Wiltshire's BB League @ sawbbl.uk
Image


Top 
 Profile  
 
 Post subject: Re: Excel Spreadsheet for Running Tournaments (ExScore)
 Post Posted: Mon Jun 27, 2016 10:04 am 
Rookie
Rookie

Joined: Tue Dec 22, 2009 6:41 pm
Posts: 52
Hi, that's what I thought about how it works. But when I setup that way, the Net Casualty table shows me some strange results. For a clearer show of what I'm talking about, here's the setup and table that I'm trying. Thanks for your time and patience :)

Image
Image


Top 
 Profile  
 
 Post subject: Re: Excel Spreadsheet for Running Tournaments (ExScore)
 Post Posted: Mon Jun 27, 2016 10:12 am 
Kommissar Enthusiasmoff
User avatar

Joined: Mon May 08, 2006 11:24 am
Posts: 5379
Location: Swindon, England
Good to know, thanks. Will have a look later this week, no time for a while!

_________________
NAF President
Founder of SAWBBL, Swindon and Wiltshire's BB League @ sawbbl.uk
Image


Top 
 Profile  
 
 Post subject: Re: Excel Spreadsheet for Running Tournaments (ExScore)
 Post Posted: Tue Jun 28, 2016 10:03 pm 
Kommissar Enthusiasmoff
User avatar

Joined: Mon May 08, 2006 11:24 am
Posts: 5379
Location: Swindon, England
Just had a play, net cas wasn't working properly, you're right, thanks.

Edit - net casualties now fixed. Group results also now implemented, but not group Swiss draw yet.

_________________
NAF President
Founder of SAWBBL, Swindon and Wiltshire's BB League @ sawbbl.uk
Image


Top 
 Profile  
 
 Post subject:
 Post Posted: Wed Jun 29, 2016 7:50 am 
Rookie
Rookie

Joined: Tue Dec 22, 2009 6:41 pm
Posts: 52
Thanks for your work. I will try it again then :)

Enviado desde mi Nexus 5 mediante Tapatalk


Top 
 Profile  
 
 Post subject: Re: Excel Spreadsheet for Running Tournaments (ExScore)
 Post Posted: Thu Jun 30, 2016 8:37 am 
Rookie
Rookie

Joined: Tue Dec 22, 2009 6:41 pm
Posts: 52
Hi, I have made some checks with the sheet, all the columns are well calculated, but when the sheet orders the table, some of them doesn't work right, after checking most of the tiebreakers I realized that TD For and Opponent Score worked fine, but when you use as tiebreaker TD against, Cas For, Cas Against, Td Net and Cas Net the sheet do not order the table correctly. If you want or need some image captures or some aditional info ask for it. And thanks for everything once again


Top 
 Profile  
 
 Post subject: Re: Excel Spreadsheet for Running Tournaments (ExScore)
 Post Posted: Thu Jun 30, 2016 12:05 pm 
Kommissar Enthusiasmoff
User avatar

Joined: Mon May 08, 2006 11:24 am
Posts: 5379
Location: Swindon, England
OK, will look into that.

_________________
NAF President
Founder of SAWBBL, Swindon and Wiltshire's BB League @ sawbbl.uk
Image


Top 
 Profile  
 
 Post subject: Re: Excel Spreadsheet for Running Tournaments (ExScore)
 Post Posted: Thu Jun 30, 2016 12:18 pm 
Veteran
Veteran

Joined: Fri Mar 28, 2014 10:21 am
Posts: 229
The macros are disabled on my work PC so can`t test it properly here, but will give it a swirl at home.

One note: When you do publish this on the NAF site I would urge you to leave as many fields blank as possible (just put in 2-1-0 for w/d/l). The points and bonus points that are left in the sheet would otherwise be seen as many as some sort of NAF-template.

Also: Nice work!


Top 
 Profile  
 
 Post subject: Re: Excel Spreadsheet for Running Tournaments (ExScore)
 Post Posted: Thu Jun 30, 2016 12:21 pm 
Veteran
Veteran

Joined: Fri Mar 28, 2014 10:21 am
Posts: 229
Also an idea to simplify the UI (I don`t know if this is possible in Excel): First get the option of "group tournament" or "single tournament" and then after that choice you give the options needed for each afterwards. Would make the "single tournament" a bit easer to navigate in.


Top 
 Profile  
 
 Post subject: Re: Excel Spreadsheet for Running Tournaments (ExScore)
 Post Posted: Thu Jun 30, 2016 2:14 pm 
Kommissar Enthusiasmoff
User avatar

Joined: Mon May 08, 2006 11:24 am
Posts: 5379
Location: Swindon, England
straume wrote:
Also an idea to simplify the UI (I don`t know if this is possible in Excel): First get the option of "group tournament" or "single tournament" and then after that choice you give the options needed for each afterwards. Would make the "single tournament" a bit easer to navigate in.


Yep, definitely. This is getting the functionality to work, then the UI should be simple after that and can be iterated a lot.

_________________
NAF President
Founder of SAWBBL, Swindon and Wiltshire's BB League @ sawbbl.uk
Image


Top 
 Profile  
 
 Post subject: Re: Excel Spreadsheet for Running Tournaments (ExScore)
 Post Posted: Wed Sep 21, 2016 11:31 pm 
Kommissar Enthusiasmoff
User avatar

Joined: Mon May 08, 2006 11:24 am
Posts: 5379
Location: Swindon, England
Pretty sure it's ready for Eurobowl now, which I'm inordinately pleased about. http://www.sann0638.co.uk/exscore-ready-for-eurobowl/

_________________
NAF President
Founder of SAWBBL, Swindon and Wiltshire's BB League @ sawbbl.uk
Image


Top 
 Profile  
 
 Post subject: Re: Excel Spreadsheet for Running Tournaments (ExScore)
 Post Posted: Sun Sep 25, 2016 9:59 pm 
Kommissar Enthusiasmoff
User avatar

Joined: Mon May 08, 2006 11:24 am
Posts: 5379
Location: Swindon, England
Anyone able to have a play, or use it in a tournament? http://www.sann0638.co.uk/exscore/

_________________
NAF President
Founder of SAWBBL, Swindon and Wiltshire's BB League @ sawbbl.uk
Image


Top 
 Profile  
 
Display posts from previous:  Sort by  
 
Post new topic Reply to topic  [ 30 posts ]  Go to page Previous  1, 2

Board index » Community Discussion » Tournament Discussions


Who is online

Users browsing this forum: Bing [Bot]

 
 

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to: