darts scoreboard, cricket game

[al_too]

Hello all, new guy here

I wish to make a scoreboard for the game of cricket. For those who may be unfamiliar with the game - player one aims at certain numbers (20, 19, 18, 17, 16, 15, bullseye) until he hits 3 of them, at which point, that number becomes 'open,' and any additional hit on that number results in points being scored. Once the second player hits 3 of that number, it is then considered to be 'closed' and no other points can be scored on it. The object being to close all numbers and have the highest total points.

Each dart for each round is being entered in, and I need two things: counting the number of marks for each player (easy), and using some kinda of if statement to determine if those marks should count for points if the other player hasn't closed that particular number (hard).

So my problem is one of timing. It doesn't just matter what number is hit, but when. So my question is, can this be done with a string of formulas, or would I be better solving this problem using VBA? I am fairly new to VBA by the way, but know some basics.



Thanks in advance for any help.

[dredwolf]

Are you limiting it to just 2 players? or do you want it open ended number of players?
If open ended, would it close after a second player hit 3, or when last player hit 3?
And are you only playing down to 15, or whole board?

[Marcol]

Gee, it's donkeys' years since I last heard of that game!

Is it not on iplayer, for oldies? ...

What do you have so far?

[dredwolf]

@ Marcol,
Me too

[al_too]

dredwolf - for now, I am just worried about 2 players. The game only goes from 20 down to 15, plus bullseye. I should also add that if a player hits the outer or inner rings (doubles or triples), they count as double/triple marks or points. Example, I currently have two 20's marked and hit a triple 20. One mark closes the 20's, and the other two go for points. I know have 3 marks for 20 and 40 points.

To give you an idea of my individual dart input, here's what I am using.

[al_too]

To expand a little bit about my project, my friends and I invented a little game that incorporates 5 games in one. Every round a player throws will count towards every game, so each game will be connected to the single dart input. The games are 501, 301, cricket, high dart, and halvers; best out 3 of 5. The first 4 are pretty common to any dart player. The last one is a little unique but that is the last hurdle and I will attempt later.

[dredwolf]

yes, figured that, has not been THAT long
as to the 15, that's fine, we always played to the end tho :D
One last Question...Do you count Double Bulls as separate or not? (sometimes we did, sometimes just as 2 Bulls...depended on when the bar was closing )

[dredwolf]

Hate to mention this, BUT, your workbook seems to be missing player 1 data...would need that to determine whether the Target is closed or not...
I'll assume Closest To Bulls for first shot is Player 1
Pretty sure this can be done with formulas, but VBA is always an option...will probably depend on you and what you prefer

[al_too]

I apologize dredwolf, that was just a sample of how I'm inputing each dart. I do have another player and some work towards the other games.

I'm just having a little problem mapping this thing out and figuring out the best way

[dredwolf]

Is not a problem, I just copied the data, then changed it a bit, was more interested in how your input scheme worked anyways

[al_too]

I think I'm close


edit: numbers on the left will be hidden. looking to count, then if statement them to score. i think that may be best way

[dredwolf]

Try this one :cricketsol1.xlsx

It's a little rough, but seems to get the job done..

Hope this helps

[al_too]

dredwolf - that is wonderful. Thank you so much.

I only see one thing. In this one that I am attaching with an example, there is an error in the scoring. Player 1 should have 134 points and player 2 should have 144. It's adding up the first darts that should not count as points. The first 3 marks should only go towards closing out the number, and not towards the point total. I haven't yet dug into what you've done, but I think it'll be an easy fix. I will try before I head out of town.

Thank you again though, you've been a major help in assisting me with this project.

[dredwolf]

Sorry about that, I guess I uploaded wrong version this morning
Here:cricketsol2.xlsx

Hope this helps

[al_too]

that is awesome dredwolf. thanks!

[dredwolf]

You are welcome

[brandonJ]

I noticed there was some issue with the formulas when major points are scored. I changed some stuff and added O1 games as well. Hope someone else can enjoy this too.