0 Members and 1 Guest are viewing this topic.

*

nottophammer

  • 3000+ Posts Member !!!
  • *****
  • 5559
  • How do you win at roulette, simple, right decision
  • Rated: +283
Badger and BBB
A mighty big thank you from Notto.

But had a problem deleting blank cells, in column H, the cells looked blank but the info bar showed data is there. So with help from overflow block, found the answer.
Had to use the find box, sorted.
Again thanks :thumbsup:

How do you win at roulette, simple, make the right decision

*

nottophammer

  • 3000+ Posts Member !!!
  • *****
  • 5559
  • How do you win at roulette, simple, right decision
  • Rated: +283
Forgot Badger
I like Rik 3 :thumbsup:
How do you win at roulette, simple, make the right decision

*

Bigbroben

  • 500+ posts Member
  • *****
  • 599
  • Member
  • Rated: +46
So we all get a thumb up... where?
Is this why the half-closed eye?

 O0
Life is hard, and then you die.

*

Bigbroben

  • 500+ posts Member
  • *****
  • 599
  • Member
  • Rated: +46
So,

I thought I'd share some Excel features I learned a few months ago, for those who do not know yet.

Will start with macros.  This is a great tools that will let you run thousands of trials overnight as you sleep.  And it's easy.

First, decide of which informations are to be extracted or memorized.  In this example here, KTF, we will want to save :
1) Score ( or goal);
2) At which spin the goal was attained;
3) What maximal progression was needed;
4) What minimum br was reached before goal.


I like to put these infos all aligned on one row.  You'll see later why.
So, all nrs are entered, the game is played, you're ready to save the infos.  Ok.

The macro functions is in the View section:


We will record a new macro:


It is a first of three macros.  Let's call it ktfone (only letters are accepted to the macro's name), and choose the key K:


Now , it starts recording everything you will be doing.
So, KTF-one:
1) We will first select the cells containing the datas we want to keep, then right-click -> Copy (or just ctrl+c):


2) We then paste the value of the cells ( the 123 icon) in the row just below, so one right click in the leftmost cell below:


3)Ctrl+c (or right click -> Copy) again the newly ceated cells.
4) Insert copied cells a few rows below:

Slide them down:


We have now created the basics of our data extractor.  We now stop the recording:


From now on, anytime you press ctrl+k, these 4 operations will run automatically.
After 2:

See, the new datas are pushing the older ones lower.

Let's create a second macro called ktftwo, with key t:

This one also records everything you'll be doing ( only on your Excel file, though!).
So if you press ctrl+k 10 times then stop the recording, this new macros will run the first macro 10 times.


Let's create a third macro, ktfthree, key f:

Press ctrl+t then stop recording.
So by pressing ctrl+f, macro ktftwo will run.

Let's dive into the macro text itself.  Go to View Macro:


Choose ktftwo and edit:


Gets you here.  You see: ktftwo runs ktfone ten times.


You can simply select these 10 steps, copy them:

Click at the end of the 10th step, press enter.  Paste the copied steps on the line below:


Or, easier: ctrl+v, enter, ctrl+v, enter, ctrl+v, enter,...  I know you can enter at least 300 times the previous macro in this one.

Same for ktfthree:

We see it produces ''ktftwo'' once.
Same as above: copy this step as many times as you want, up to 300 times ( could be 400, not sure).

So, what do we have here?  A simple ctrl+f will run 300x300, 90k trials of whichever sim you want and whichever datas you want to save for further analysis.

I normally use Excel's random function, although some do not like it.

It simply creates a new set of nrs on any movement.  This ensures the nrs are changed from one data recording to another.

You can also record the first macro as such, if, say, you want to use nrs from random.org or whatever.  Make sure the nrs you want to use are available in another sheet (or same sheet, but specific column).


The macro would select the amount of nrs you want, copy paste them in your Nrs column, continue to record the operations as described in the first macro, delete (then shift-cell up) how many nrs you want, then stop the recording.
So, example, you have a 100k spins to source nrs from. 
Start recording, select a hundred, paste them in your nrs column, run your operations, go back to nr source, delete 25, stop recording.  A 100k nrs, if deleting 25 each time, will let you have 4000 runs ( actually, 3997).

********************
Now I did mentionned earlier that I insert the copied cells a few rows below.  Why is that?
It leaves room to add some other measurements that will automatically calculate what you want as the trils go by.

You can add the sum of your game score:


You see I selected not only the cells with a value in them, but also the one above.  This one is fixed, as opposed to the other ones that are moving.  Doing so will let the first measured cell remain the same (here, AA9), and the last measured cell to remain the last non-blank cell.  Otherwise, only 2 cells will be measured.  So as goes the macro, you can just observe how your score evolves, or how the average rises...




If you want to apply these calculations to the neighbouring columns, select the cells to be copied:


See that small square black spot on the lower right side of the selected cells?  Click on it, hold the button, drag:


Good enough for now.

************************

I might soon explain other little tricks for Excel, basics that are so helpful to know.

Stay tuned!





Life is hard, and then you die.

Still

  • 500+ posts Member
  • *****
  • 541
  • Roulette Forum .cc | Member
  • Rated: +17
That's perfect.  That's exactly what we need to gather empirical evidence whether or not there is a reason to have faith in such systems as Keep The Faith.  This should let people know exactly what they are getting into before they start. 

 

Visit GamblersForum.com - For discussions about other casino games.

Blackjack Forum: Card counting and professional strategies

Poker Forum: learn from the best poker players

Video Poker Forum: maximize chances of winning

Baccarat Forum: the popular and simple card game

Craps Forum: strategies and the viability of dice control

Slots Forum: Learn the legitimate ways of beating slots

Sports Betting Forum: the most widespread gambling

Horse & Dog Racing Forum: the thrill of racing

Keno & Lottery Forum: discuss potentially new strategies