Excel advise please

  tnelis 10:58 10 Aug 2005

Can anyone advise me please?

I am trying to write a spreadsheet to show something about roulette...ie:

Does any SECTOR of a particular wheel produce more hits that the others?

I have thousands of actual spins of the wheel, also of course the sequence of the numbers round the French wheel (with one zero).

Example...when say 12 comes up....I will award 12 with the score of 5, also the surrounding numbers a lesser score of 4,3,2,1 on either side of the 12....

This will apply to every spin of the wheel, until every SECTOR (around every number is given a score) thus saying that one sector is stronger that the rest.

Question is how to lay this out and make it work, on a spreadsheet.

Many thanks.

  VoG II 16:34 10 Aug 2005
  tnelis 17:05 10 Aug 2005

Thanks Vog, Mr Excel also provides interesting reading of excel problems in general.

  tnelis 21:30 10 Aug 2005

Thanks VOG....ICE223 from Mr Excel did a marvelous job for me, in the blick of an eye.
Good one!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

Artist Pete Oswald on creating relatable characters & his new book

New iMac Pro release date, UK price & specs rumours

Idées cadeaux pour geeks et tech addicts