#1 Roulette Forum & Message Board | www.RouletteForum.cc

IT & Software => Roulette Software => Topic started by: poobear on Apr 29, 04:48 AM 2017

Title: Spreadsheets
Post by: poobear on Apr 29, 04:48 AM 2017
I wasn't sure where to post this but I'm gonna share some spreadsheets I have used over the years. I have limited excel ability but hopefully somebody finds them useful.
Title: Re: Spreadsheets
Post by: Priyanka on Apr 29, 06:40 PM 2017
Quote from: poobear on Apr 29, 04:48 AM 2017
I wasn't sure where to post this but I'm gonna share some spreadsheets I have used over the years. I have limited excel ability but hopefully somebody finds them useful.
Very useful poobear. Thanks for sharing.
Title: Re: Spreadsheets
Post by: poobear on Apr 29, 06:42 PM 2017
Here is another for anyone who likes a w/L registry.
Title: Re: Spreadsheets
Post by: poobear on Apr 29, 06:48 PM 2017
Not a problem Priyanka. Ohh, and another one I did for Cracking Pi, this one is useless though.
Title: Re: Spreadsheets
Post by: DoctorSudoku on Apr 29, 09:56 PM 2017
Quote from: poobear on Apr 29, 04:48 AM 2017
I wasn't sure where to post this but I'm gonna share some spreadsheets I have used over the years. I have limited excel ability but hopefully somebody finds them useful.

Poobear,
They should be useful for at-home testing of methods.   Thank you.
Title: Re: Spreadsheets
Post by: poobear on Apr 30, 02:54 AM 2017
No worries Doctor. Here is another fun spreadsheet. Not sure what I was trying to prove at the time but hope somebody finds it useful.

Title: Re: Spreadsheets
Post by: 3Nine on Apr 30, 09:25 AM 2017
Thank you for sharing!  I love spreadsheets - must be my thing for numbers.  Who knows.
Title: Re: Spreadsheets
Post by: poobear on May 01, 06:25 AM 2017
1 more. This was when I went through a "matrix" stage.

Have fun.
Title: Re: Spreadsheets
Post by: Still on May 09, 06:34 AM 2017
Here's something i built from scratch a few weeks ago. 

This is an .xlsm (Excel with macros) file.  The macros are for managing data generation with a click of a button.

Let's call this version 1.0 because there is a lot of room for improvement.   

The idea here is to have a universal workbook where any number of different roulette games can be inserted, coordinating all the games with the same source of spins, and an amalgamated output page.

Included is one test game page, flat bet, which is then processed through a money management engine, and displayed on a dashboard page where several input variables can be changed to see charts of different MM schemes. 

Mostly demonstrates how to combine several games, manage them together, and display results with charts.   



Title: Re: Spreadsheets
Post by: 3Nine on May 09, 08:52 AM 2017
Thanks both.

Still, that sheet is looking for an updated Link to cycles.xslx.

Title: Re: Spreadsheets
Post by: Still on May 09, 12:39 PM 2017
Quote from: 3Nine on May 09, 08:52 AM 2017
Thanks both.

Still, that sheet is looking for an updated Link to cycles.xslx.

Apologies.  I was originally working with a sheet called cycles.xslx but since divorced from it and this sheet has no working reference to it...no dependancy. So that can be ignored till the link "update" can be dissolved.
Title: Re: Spreadsheets
Post by: 3Nine on May 09, 12:47 PM 2017
No worries - impressive work.
Title: Re: Spreadsheets
Post by: Still on May 09, 01:15 PM 2017
Quote from: 3Nine on May 09, 12:47 PM 2017
No worries - impressive work.

Partly I wanted to test four combinations of R/B to see if possible to bet on repeats, or not.  Didn't find anything, even with money management.

Other reason was to brush off Excel skills long unused. 

The money management engine ought  to exploit anything with a positive flatbet. There's a lookup table, actually two, that is used by the MM engines. One of the lookup tables is controlled by the dashboard.  I had never done a dynamic table like that before so it was interesting to me.

The data source is simple but could be expanded to pull from Wiesbaden files or other spins.  Data is pasted (by a macro) to one spot so further work is not bothered by auto-recalc functionality. 



Title: Re: Spreadsheets
Post by: cht on May 20, 10:31 PM 2017
I don't know if there's a VdW tracker or not posted on this board earlier. Here I share a multiple tracker I made to test out the concept.
Title: Re: Spreadsheets
Post by: 3Nine on May 21, 06:48 AM 2017
Quote from: cht on May 20, 10:31 PM 2017
I don't know if there's a VdW tracker or not posted on this board earlier. Here I share a multiple tracker I made to test out the concept.

thanks, cht.  I was unable to put any spins in the column.
Title: Re: Spreadsheets
Post by: cht on May 21, 10:35 AM 2017
The spreadsheets have been unprotected so, please do not change the formula
Title: Re: Spreadsheets
Post by: 3Nine on May 21, 12:01 PM 2017
Quote from: cht on May 21, 10:35 AM 2017
The spreadsheets have been unprotected so, please do not change the formula

I'd probably screw it up if I tried - no worries there.  But, I am interested in Craps with Pass/Don't Pass.  Thanks for unprotecting!  :thumbsup: