Thread: Darts Scorer
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Chris Chris is offline
external usenet poster
 
Posts: 788
Default Darts Scorer

Hi Andy,

I only need the checkouts to be shown if they are a possiblity during that
throw (for example, 121 left would be treble 20, treble 11, double 14, but if
only a single 20 was hit you can still check out in two darts with treble 17
then bullseye).

I've been trying new ideas for the layout etc of the scorer but can't find a
way of creating one that can do everything i want, do you have any ideas on
this?

Thanks,

Chris

"Andy" wrote:

Hi Chris

Do you need all possible checkouts to be shown? Two dart and three dart?
What if the finish changes after throwing the first dart of your turn - or
the second dart? Questions, questions, questions!!

Andy

"Chris" wrote in message
...
Hi,

I am trying to create a darts scorer in excel for use in practice.

I'm looking for the scorer to return checkouts when i get on 170 or below
(for all valid checkouts - i believe this requires a V-LOOKUP function but
i've never used that function before!), display averages leg-by-leg and
set-by-set and don't know where to start!

Does anyone know of any set templates I can download that are in any way
similar to this?

Thanks in advance,

Chris