Basic Tracking with Excel

[mattymattz]

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

[Twisteruk]

Thanx !

Really appreciate it 

[MAX]

Thanks


Regards
Max

[ADulay]

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

[ADulay]

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

[vundarosa]

Hi matty

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

Vundarosa

[ADulay]

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

[Normy2000]

An other similar tracker with import function and input number with the mouse...

Enjoy 

[marivo]

Import function somehow doesn't work!? How exactly you can import numbers? Any help? Thanks.

[Normy2000]

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

[marivo]

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.

[Normy2000]

 
You have to click "Step" button on the tracker page for each number to show up in history...

normy

[marivo]

Got it!    Super! Thanks