Excel advise please

  tnelis 10:58 10 Aug 05

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 05
  tnelis 17:05 10 Aug 05

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

  tnelis 21:30 10 Aug 05

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.

Nintendo Switch (Nintendo NX) release date, price, specs and preview trailer: Codename NX console…

1995-2015: How technology has changed the world in 20 years

8 things designers (and brands) need to know about the modern woman

How to speed up a slow Mac: 19 great tips to make an iMac, MacBook or Mac mini run faster | Speed…