Re: Microsoft Excel

On 28 Jul 2005 01:33:54 -0700, "Frances" <fhinden@xxxxxxxxxx> wrote:

>
>
>David Stevenson wrote:
>> I like to score on my PDA which uses a version of Excel. Actually, I
>> think the 'version' does not matter, since if something works on my
>> desktop it gets converted to something that works on my PDA.
>>
>> The score-*** looks something like this:
>>
>> Brd Vul Dir Contract By Lead Tricks Score
>> 1 w 0 3d d hq 2 +150
>> 2 r 0 2h l s2 -2 +100
>> 3 g 0 4sr p c6 -3 -1000
>> 4 a 0 ap 0
>> 5 r 0 3nd r da 0 -550
>>
>> The vulnerability is based on w=white [nv v nv] r=red [v v nv]
>> g=green [nv v v] a=amber [v v v] and refers to North/South's
>> vulnerability.
>>
>> The direction is 0 for me sitting North/South, 1 for East/West.
>>
>> The contract seems obvious from the examples: note that n=no-trumps.
>>
>> Declarer is shown as d=david p=david's partner l=david's LHO
>> r=david's RHO.
>>
>> Tricks are 0 for making, 1, 2 etc for overtricks, -1, -2 etc for
>> undertricks.
>>
>> I thought it would be nice for it to work out the score until I tried
>> to do it. It is way beyond my competence: can anyone help?
>>
>
>I have a spread*** which does this if you (or anyone else) wants it.
>We use it for the Tolle. The contract, result and declarer is entered
>in one cell as, say, 3nx+2w or 4h-1e as I found this the fastest way to
>enter them, but I could change it to exactly your method if necessary.
>
>It also works out the imps.
>
>It is possible to write a formula which works out the score, but it's
>very long. I wrote the formula, and then used it to create a large
>look-up table, which works much faster and is more reassuringly
>obviously correct.
>
>I could copy my score-calculating formula here if anyone would find it
>useful.

I would.

mike
.

Loading