+ Reply to Thread
Results 1 to 3 of 3

Help with functions in Darts statistics spreadsheet

  1. #1
    Registered User
    Join Date
    01-20-2007
    Posts
    15

    Help with functions in Darts statistics spreadsheet

    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?
    Last edited by KJC; 01-20-2007 at 01:42 AM.

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    Yes, it is feasible ... you can have labels added to your chart ...
    For some inspiration, take a look at Jon's site, and more specifically to
    http://peltiertech.com/Excel/Charts/tornadochart.html
    HTH
    Carim


    Top Excel Links

  3. #3
    Registered User
    Join Date
    01-20-2007
    Posts
    15
    What about the code for a button that adds to a value in xx cell?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1