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

IT & Software => Other software => Topic started by: mattymattz on Apr 28, 12:15 PM 2011

Title: Basic Tracking with Excel
Post by: mattymattz on Apr 28, 12:15 PM 2011
Hey gang,

as I mentioned in my welcome post, I like spreadsheets.    Since I've gotten a few questions already, thought it might help if I posted a basic tracker spreadsheet.   

I built it in Open Office (Free version on excel) but it should work in either.    It tracks all the basics (H/L, E/O, R/B, Streets, Dozens, Columns).    Only set up to track about 1000 spins, but if need be, I can increase it no problem. 

Just enter your spins in Column A, under Number/Spins.

Enjoy,
MM

Title: Re: Basic Tracking with Excel
Post by: Twisteruk on Apr 28, 12:22 PM 2011
Thanx !

Really appreciate it  :thumbsup:
Title: Re: Basic Tracking with Excel
Post by: MAX on Apr 28, 01:12 PM 2011
Thanks

:)
Regards
Max
Title: Re: Basic Tracking with Excel
Post by: ADulay on Apr 28, 02:34 PM 2011
Well, as long as we're doing Excel spreadsheets, you may want to try this one.

You can manually enter numbers into it or, using the second sheet, let the computer generate numbers.  Obviously you can expand this above the current 1000 spins by doing a simple "copy and paste" for as large as you need be.

This spreadsheet shows graphically (and in color) what each number represents.  Makes it very easy to "see" the runs and chops at will and to test ideas of things like how long things will go.

It tracks OE/RB/HL/ABC/123.

The "random" sheet is for a "00" wheel but can be edited to make it a single zero wheel.

AD
Title: Re: Basic Tracking with Excel
Post by: ADulay on Apr 28, 07:55 PM 2011
Hmm, it never dawned on me to add Streets and Double Streets to that collection.

I'll add it the next time I get around to updating it.

AD
Title: Re: Basic Tracking with Excel
Post by: vundarosa on Apr 29, 12:28 AM 2011
Hi matty

Thx for the tracker. This is exactly what i was looking for  :thumbsup:

Vundarosa
Title: Re: Basic Tracking with Excel
Post by: ADulay on Apr 30, 06:32 PM 2011
Quote from: ADulay on Apr 28, 07:55 PM 2011
Hmm, it never dawned on me to add Streets to that collection.

I'll add it the next time I get around to updating it.

AD

Well, today was the day as it was bugging me a lot.  This Excel spreadsheet is identical to the previously posted one by me but now includes the Streets identification too.

My thanks to MattyMattz for saving me some reference work using the VLookUp command in Excel and to giving me the direction to add the Streets to the spreadsheet.

AD
Title: Re: Basic Tracking with Excel
Post by: Normy2000 on May 02, 10:22 AM 2011
An other similar tracker with import function and input number with the mouse...

Enjoy  :)
Title: Re: Basic Tracking with Excel
Post by: marivo on Jun 30, 04:21 AM 2011
Import function somehow doesn't work!? How exactly you can import numbers? Any help? Thanks.
Title: Re: Basic Tracking with Excel
Post by: Normy2000 on Jun 30, 07:32 AM 2011
Humm, it's working here!

Things you can verify:

1- Be sure the name of the excel file as not change. It have to be: Tracker1.xls (that name is used in some macro)

2- Format of the file to import is the same as Rx. 1 number per line in a .txt file.

3- Import no more than 800-900 numbers per files.

Hope this help...

nOrMy2o0o
Title: Re: Basic Tracking with Excel
Post by: marivo on Jun 30, 12:58 PM 2011
When I import the numbers the program only creates an additional sheet with those numbers in Tracker1.xls file. That's all. I can not track any patterns of dozens, columns, etc.. .. which these numbers form.
Title: Re: Basic Tracking with Excel
Post by: Normy2000 on Jun 30, 03:05 PM 2011
 
You have to click "Step" button on the tracker page for each number to show up in history...

normy
Title: Re: Basic Tracking with Excel
Post by: marivo on Jul 01, 03:54 AM 2011
Got it!  :thumbsup:  Super! Thanks