Скачать или смотреть How To Build Your Own Roulette Probability Tracker Part 2

In today's video, we continue our journey with the spreadsheet we started in our previous video, "Build Your Own Roulette Probability Distribution Tracker - Part 1." If you haven't watched that video yet, we strongly recommend doing so before diving into this one.

This video is divided into two parts:

Part 1: Enhancing the Tracker
In the first part, we'll be updating our spreadsheet to make it even more powerful. We'll add expected values to our graph, making it easier to identify outliers in the data. Additionally, we'll duplicate the worksheet, creating separate pages for different bet sizes.

Part 2: Custom Roulette Functions
In the second part, we'll introduce custom roulette functions in Excel. These functions will streamline the process of entering spin data and updating multiple graphs simultaneously. By monitoring dozens, columns, and even-money bets simultaneously, we increase our chances of identifying outliers in live game data.


Build Your Own Roulette Probability Distribution Tracker - Part 1
   • How To Build Your Own Roulette Probability...  


This will help you get started on the code:-
----------------------------------------------------------------------------------------------------------------------------------
Public Function GetDozen(pocket)

Select Case pocket

' First Dozen
Case 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12: GetDozen = 1

' Second Dozen
Case 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24: GetDozen = 2

' Third Dozen
Case 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36: GetDozen = 3

' Catch all other values and return Zero
Case Else: GetDozen = 0

End Select

End Function
----------------------------------------------------------------------------------------------------------------------------------