The idea behind the design of this spreadsheet is that it logs how many darts you throw for each target, and how many are successful hits you get from those throws. I was also hoping it would add your percentage for each target and display them on a graphic representation of a dartboard.
An example of the input columns for one target would be:
Treble 20 - Throws - Hits - 3 - 2 - 1 - 1 - 2 - 3
Treble 19 - Throws - Hits - 3 - 2 - 1 - 1 - 2 - 3
Treble 18 - Throws - Hits - 3 - 2 - 1 - 1 - 2 - 3
the first 3 - 2 - 1 would be red buttons (which count as a miss) that adds to the amount of throws for the target, but does not add anything to the 'hit' column. The 1 - 2 - 3 buttons would be green, and add the relevant amount to the 'hit' column as well as the 'throws' column.
So lets say I aim at Treble 20, miss with 2 darts and hit with 1 dart, I would click the red button labelled '2' and click the green button labelled '1'. Pressing these buttons would update the columns for darts 'thrown' and 'hit' showing that I've thrown three darts and had one dart on target.
I've got the layout for the above, but I am new at this and don't know what code to add for the buttons. So if you guys could supply me with the code then that is the main purpose of this spreadsheet.
Now for the graphic representation of the board... Excel doesn't seem to have a lot of capabilities with combining data with graphics, but I was basically hoping that my above example which would give a percentage of '33.33%' would be added at the Treble 20 on a graphic of a dart board. Are there any ways of doing this?
Bookmarks