Spreadsheets

[poobear]

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.

[Priyanka]

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.

[poobear]

Here is another for anyone who likes a w/L registry.

[poobear]

Not a problem Priyanka. Ohh, and another one I did for Cracking Pi, this one is useless though.

[DoctorSudoku]

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.

[poobear]

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.

[3Nine]

Thank you for sharing!  I love spreadsheets - must be my thing for numbers.  Who knows.

[poobear]

1 more. This was when I went through a "matrix" stage.

Have fun.

[Still]

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.   

[3Nine]

Thanks both.

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

[Still]

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.

[3Nine]

No worries - impressive work.

[Still]

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. 

[cht]

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.

[3Nine]

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.