+ Reply to Thread
Results 1 to 2 of 2

Darts Data Entry Tool

  1. #1
    Registered User
    Join Date
    07-27-2011
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    12

    Darts Data Entry Tool

    Hi guys,

    I am looking to create an interactive data entry tool for darts matches. The idea is to have a picture of a dart board embedded into Excel, enabling the user to point and click on an actual place on the board where each dart landed. The idea is to make this as accurate as possible so that the user can identify the level of accuracy of the player (i.e. differentiate between a near miss and a far miss when aiming for particular scores as well as recording the actual score).

    I'm just starting out on this and realise it's going to be quite a tough task but would appreciate anyone who can point me in the right direction to start with. Has anyone created something similar in the past? I'm not really sure how to create a visual dart board as the starting point so that different points can be clicked on for example. If anyone is interested in contributing to this I do have a small budget available so please feel free to get in touch. Otherwise, any thoughts/advice/questions would be much appreciated.

    Kind regards

    HA

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Darts Data Entry Tool

    It would be a fair amount of work for what is a dubious ROI but I think the best technique would be to :-

    a) Use a standard jpg image of a dartboard..
    b) Surround it with an ActiveX Label with the backstyle set to transparent : This allows you to get the X,Y co-ordinates of the cursor
    c) Convert the X,Y co-ords to polar co-ords
    d) The angle combined with a lookup table will return the number hit
    e) The distance from centre will tell you whether it's a bull,25,treble,double or single score...
    Elegant Simplicity............. Not Always

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data Entry tool
    By patil.rupesh1986 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-30-2013, 03:14 AM
  2. Replies: 6
    Last Post: 04-07-2013, 01:35 AM
  3. Darts Scoreboard
    By gallen6945 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2013, 02:30 AM
  4. Darts Scorebaord
    By gallen6945 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2013, 08:50 AM
  5. Time entry tool
    By Arnzod in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-15-2008, 07:23 AM

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