Re: Microsoft Excel



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.

> --
> David Stevenson Bridge RTFLB Cats Railways /\ /\
> Liverpool, England, UK Fax: +44 870 055 7697 @ @
> <bridge2@xxxxxxxxxxx> ICQ 20039682 bluejak on OKB =( + )=
> Bridgepage: http://blakjak.com/brg_menu.htm ~

.

Loading