Craps

Creative way of logging my last 5K throws (Update 2/17/2017)

Spread the love


Hi Everyone,

2/17/2017 Update: I noticed the range colors were off and modified the ranges to align with smart craps calculations for 5K rolls, I also put in the running total counts of the main throw log and what was the min and max time stamp with with 5K being analysed. I believe a control shooter should keep the results of last 5K with in 60-90 days of practice. This will be a useful tool for those considering forming a team and measuring their throwing metrics. Also if you are fixing your throw, like I am you will see progress as you age out the older results. I also update the pictures of the gauges and the my dashboard panel. If anyone wants to talk more about my throw in person. I will be taking the refresher class on April 2017 in AC.

Here is my SRR Gauge with some notes.

Notes:
Red = Expected Range 0.00 – 6.22
Yellow = Players Edge Range 6.23 – 6.49
Green = Controller’s Range 6.50 – 12 (I picked 12 as a the super case)

=================================

Here are the three ProTest gauges that measure against the Sigma 3 SD tests for On-Axis, Primary Hits and avoidance of a double Pitch (D-Pitch)

Notes:
Axis – Red =Expected (0%-44.44%) Yellow=Standard Deviation Range (44.45%-46.09%) Green – Controller’s Range (46.10%-100%)
Primary -Red = Expected (0%-25.02%) Yellow=Standard Deviation Range (23.03%-27.14%) Green – Controller’s Range (27.15%-100%)
D-Pitch -Red = Expected (100%-25.02%) Yellow=Standard Deviation Range (25.01%-22.87%) Green – Controller’s Range (22.86%-0%)

===========================

Here is a snap shot of the control panel I usually have it attached to my big screen TV as I long my throws via my iPad.

Todo: 1) Make an automated clean-up script to delete older throws from the log.
2) Include an instruction doc to explain the metrics that may not be clear.
3) Make the ipad entry interface nicer. (It looks so plain but very functional)

2/15/2017 Update: I updated my google sheet throw log so that it does metrics on only the last 5000 throws recorded. The motivation was I read a post from Dom stating how only the last 5K throws are relevant to your current skills, this made a lot of sense to me. I did notice as I tried to fix my on axis throws my SRR suffered. I added 4 gauges one for the SRR and 3 that represents the controllers standard deviation test. I divided the the colors of the range into three sections. Red represents the expected. Yellow = I am in with-in the Standard Deviation Range and Green = I am in the controller’s range.

=== End of 2/15/2017 update ===

Just wanted to share how I log my throws. I wanted to log my throws using my ipad and the golden touch pen with the ipad touch tip and see my SRR and some other stats on my big screen TV with the laptop attached to the HDMI cable.

here is the live log:

https://docs.google.com/spreadsheets/d/1Q35uJPmgutkKb0sGleoAn55siE2f4Qzn6AHtutUzuuA/edit?usp=sharing

And attached is a pic of the form that I use to click the results of each throw.

Eventually I will feed these results into SMART craps to do further analysis. Notice I had a great 32 roll run before hitting the 7. Each throw is time stamped also so I can do future re reporting. Just thought I would share.

Can anyone calculate my players edge?

-Mr PiP.

Attached files


Replies:

Posted by: Skinny on November 22, 2016, 4:05 am

An SRR of 6.30 for 860 rolls gives you a positive house advantage of 0.4511% on the Pass Line. You need a 6.23 SRR to give you a positive HA of 0.0239% on the PL.

But 860 rolls are not enough rolls to consider this a valid statistic.

Posted by: Mr.PiP on November 22, 2016, 4:34 am

Thanks Skinny, I figured that I need about 5K throws.

-Mr. PiP

Posted by: Dr Crapology on November 22, 2016, 12:20 pm

Mr. PIP—what a great way to follow your progress. You will do great this thing we call GTC Advantage Play. Look forward to future reports to see your improvements.

Rose and Doc

Posted by: JawBones on November 22, 2016, 2:49 pm

Mr PiP I love this spreadsheet. Looks like it gives lots of ways to massage the data and get a great picture of your progress. Being spreadsheet challenged I am indeed envious.

Posted by: Dominator on November 22, 2016, 3:20 pm

Nice job on designing that spread sheet!

Keep up the practicing!

Dom