| Author |
Message |
|
micbrook
|
 Posted: Wed Jul 13, 2016 4:55 pm |
|
Joined: Fri Jun 17, 2016 1:15 pm
Posts: 40
Location: Berkshire
|
|
Hi
I have a little spreadsheet I've managed to host using one drive. However, I only know basics and would like to tweak it a little... Anyone handy with excel?!
Cheers
_________________
A big white one
|
|
  |
|
 |
|
jcturner
|
Posted: Wed Jul 13, 2016 5:43 pm |
|
 |
| Site Admin |
 |
Joined: Wed Oct 06, 2010 2:17 pm
Posts: 3367
Location: North Hertfordshire, UK
|
|
What do you need to do?
I'm not an expert, but I do spend a lot of time in Excel sheets...
_________________
James
Mac4Mac Founder
(use mac4mac as PW)
12.9" iPad Pro, Magic Keyboard, Pencil 2
21.5" iMac Quad Core i5 8GB RAM (Plex Server) ~ iPhone 15 Pro
AirPods Pro ~ Apple TV 4 (64GB) ~ Linksys Velop Mesh Wi-Fi
|
|
| |
|
|
|
micbrook
|
Posted: Wed Jul 13, 2016 6:12 pm |
|
Joined: Fri Jun 17, 2016 1:15 pm
Posts: 40
Location: Berkshire
|
|
_________________
A big white one
|
|
| |
|
|
|
Leewave
|
Posted: Wed Jul 13, 2016 6:21 pm |
|
Joined: Wed Oct 06, 2010 8:27 pm
Posts: 6173
|
Do they actually pay out if you win? If it's online roulette I've heard stories that are not encouraging about winning big online. And roulette is surely a game of chance. I don't see how you can predict what the outcome of the next roll of the ball will be on the basis of previous history - unless the table is rigged. And I just looked at your spreadsheet and I have absolutely no idea what it all means!  
|
|
| |
|
|
|
micbrook
|
Posted: Wed Jul 13, 2016 6:37 pm |
|
Joined: Fri Jun 17, 2016 1:15 pm
Posts: 40
Location: Berkshire
|
Reputable online casinos pay out no problems, specially if you chip away small amounts rather than huge ones. It's all best guess by all means, there is no real way of predicting the outcome, just try even the odds a little. 37 numbers. If the ball lands in the same area of the wheel for 70% of the spins, would it make sense you have a 70% chance of winning if you put money on that section of the wheel, going by previous history? As for the pattern thing, there won't be a definate thing going on but again look for averages. If every 4th colour is blue according to the chart, would it be safe to bet on all of the blue numbers in that group on the 4th spin? It's about looking for ways to improve your odds that's all 
_________________
A big white one
|
|
| |
|
|
|
jcturner
|
Posted: Wed Jul 13, 2016 6:40 pm |
|
|
| Site Admin |
|
Joined: Wed Oct 06, 2010 2:17 pm
Posts: 3367
Location: North Hertfordshire, UK
|
|
What you need is conditional formatting...
Take a look yourself if that's all you need to help, otherwise, let me know.
_________________
James
Mac4Mac Founder
(use mac4mac as PW)
12.9" iPad Pro, Magic Keyboard, Pencil 2
21.5" iMac Quad Core i5 8GB RAM (Plex Server) ~ iPhone 15 Pro
AirPods Pro ~ Apple TV 4 (64GB) ~ Linksys Velop Mesh Wi-Fi
|
|
| |
|
|
|
micbrook
|
Posted: Wed Jul 13, 2016 6:43 pm |
|
Joined: Fri Jun 17, 2016 1:15 pm
Posts: 40
Location: Berkshire
|
|
_________________
A big white one
|
|
| |
|
|
|
micbrook
|
Posted: Wed Jul 13, 2016 6:45 pm |
|
Joined: Fri Jun 17, 2016 1:15 pm
Posts: 40
Location: Berkshire
|
|
_________________
A big white one
|
|
| |
|
|
|
jcturner
|
Posted: Wed Jul 13, 2016 6:51 pm |
|
|
| Site Admin |
|
Joined: Wed Oct 06, 2010 2:17 pm
Posts: 3367
Location: North Hertfordshire, UK
|
|
_________________
James
Mac4Mac Founder
(use mac4mac as PW)
12.9" iPad Pro, Magic Keyboard, Pencil 2
21.5" iMac Quad Core i5 8GB RAM (Plex Server) ~ iPhone 15 Pro
AirPods Pro ~ Apple TV 4 (64GB) ~ Linksys Velop Mesh Wi-Fi
|
|
| |
|
|
|
Mike Smith
|
Posted: Wed Jul 13, 2016 7:00 pm |
|
Joined: Wed Oct 06, 2010 10:18 pm
Posts: 1436
Location: Middle Earth
|
|
What you need is premonition, works every time
_________________
I don't mean to sound bitter, cold, or cruel, but I am, so that's how it comes out.
Bill Hicks
'If we can find the money to kill people, we can find the money to help people'
Tony Benn
l l
|
|
| |
|
|
|
micbrook
|
Posted: Wed Jul 13, 2016 7:06 pm |
|
Joined: Fri Jun 17, 2016 1:15 pm
Posts: 40
Location: Berkshire
|
|
If I bought a book with all of the winning lottery numbers and went back in time id still get it wrong
_________________
A big white one
|
|
| |
|
|
|
jcturner
|
Posted: Wed Jul 13, 2016 7:09 pm |
|
|
| Site Admin |
|
Joined: Wed Oct 06, 2010 2:17 pm
Posts: 3367
Location: North Hertfordshire, UK
|
|
Hmm, right. I'm not exactly sure what you need.
Can you explain some more?
_________________
James
Mac4Mac Founder
(use mac4mac as PW)
12.9" iPad Pro, Magic Keyboard, Pencil 2
21.5" iMac Quad Core i5 8GB RAM (Plex Server) ~ iPhone 15 Pro
AirPods Pro ~ Apple TV 4 (64GB) ~ Linksys Velop Mesh Wi-Fi
|
|
| |
|
|
|
Leewave
|
Posted: Wed Jul 13, 2016 7:12 pm |
|
Joined: Wed Oct 06, 2010 8:27 pm
Posts: 6173
|
|
I don't really know anything about roulette but if you do detect any kind of pattern after a large number of samples, and it's a repeatable pattern, then I really doubt that the table is free of defects. It must be rigged somehow because it is supposed to be entirely random, by definition. But I have no idea really.
|
|
| |
|
|
|
micbrook
|
Posted: Wed Jul 13, 2016 7:14 pm |
|
Joined: Fri Jun 17, 2016 1:15 pm
Posts: 40
Location: Berkshire
|
|
Ok. Clear the B row. Let's say the first number out to win is 32. We put 1 next to 32 (won 1 time) and all of the colours should say 100% opposite 32.
In L column id like L1 to turn green, 32 is in the green colour group in I column. Next number out let's say is 26 - put 1 next to it in B rack, the percentages change accordingly and in L column it makes L2 orange, as that's the colour for 26 in the I column
_________________
A big white one
|
|
| |
|
|
|
micbrook
|
Posted: Wed Jul 13, 2016 7:16 pm |
|
Joined: Fri Jun 17, 2016 1:15 pm
Posts: 40
Location: Berkshire
|
|
_________________
A big white one
|
|
| |
|
|
|
