Spreadsheet Tool for Exacta players.

[Ray2000]

I'm not sure, mike, never had to deal with them in Harness.
The T-bred forums have posted on this topic in the past.

http://www.paceadvantage.com/forum/s...ad.php?t=13104

There's a couple references to free utilities that might work, in that thread

[netbet]

Ray,

How do I get the spreadsheet to show Gulfstream and Tampa Bay? I tried using the spreadsheet this afternoon and these tracks are not available in the dropdown.

Thanks.

Patrick

[mabred]

how does one get it to work is the ???

brisnet tote ??could someone give a short

tutorial

mabred

[Ray2000]

The Spreadsheet was designed for Harness tracks, where 7 to 10 program entries are common. I could redo it for T-Breds (if there's enough interest), to handle those larger fields.

The attached updated version has Gulfstream and Tampa but I had to remove (over write) Turf Paradise and Golden Gate to fit those 2 tracks in.

IT only works with eBet tracks. I did this to get away from using TwinSpires where one has to log in to get to the tote.


mabred,

I never wrote a tutorial other than what is contained in this thread. Guess I should add a Help Page. If you have any specific problem, let me know.

[netbet]

Ray,

Thank you for the update.

Patrick

[u2popmart]

ray,
is there a way of recording the history of the win odds,alt odds and dr z place everytime you update. with the conditional colors at that recorded time.

thanks.


Win Odds1382417/2617142112Alt Win Odds by Ex Pool18/17/22/145/17/245/14/119/120/19/1Morning Line Odds1045207/2156121212DrZ Place% Expectancy89%87%89%77%79%90%121%82%83%92%

[Ray2000]

u2popmart


Not automatically, sorry.

You could copy cells A8 thru L11 then

go down to about cell A50 and Paste Special Values.... ( Home>Paste>PasteValues in Excel 2007-10 )

Go back and select the same range for copying format and 'paint' the copied data below to make reading easier. Formatting that range only needs to be done once. Then repeat pasting below that for the next update.

BTW

The Dr Z method says..quote

"Bets are made when the estimated expected return on a dollar place or show
wager is greater than 1.14 for major racetracks and 1.18 for minor racetracks and when the
odds are less than or equal to 8-1."

On this sheet, the values (in row 11) for Place % Expectancy turn Green if > 1.15 but do not take into account the 8-1 odds criteria.

[u2popmart]

i been using your spreadsheet. i use for tb. i keep getting beat by the horsses outside the 10 post.
is there a way to expand it 5 more to include horses up to the 15 post. if is too much work. just let me know what area of the spreadsheet can i modify to include o make the change.
thanks again.

[Ray2000]

It's not just a range of cells that needs expanded, the macro does a 'sort' on 10 to find the crowd's top 3. It will need changed also.

I've been meaning to redo it anyway to add some other features, so I'll put up an expanded version in a few days.

[u2popmart]

thanks ray .

[u2popmart]

Ray,
if i may . May i make a suggetion.
There was a spreadsheet that i once downloaded. It had a automatic refresh option. i have the spreadshhet and the code for it i just dont know how to apply it to yours. is this something you think you can do. i could forward you the spreadsheet.
thanks

[beaucap]

Originally Posted by u2popmart

Ray,
if i may . May i make a suggetion.
There was a spreadsheet that i once downloaded. It had a automatic refresh option. i have the spreadshhet and the code for it i just dont know how to apply it to yours. is this something you think you can do. i could forward you the spreadsheet.
thanks

Look what you got us into now Ollie...........

[Ray2000]

Funny one, Bo



u2
I have that feature on the version I use, so I can put it in there fairly easy. Though it might get a little cluttered .
.

[MightBeSosa]

Only a madman could create something like this

[JJMartin]

Originally Posted by Ray2000

It's not just a range of cells that needs expanded, the macro does a 'sort' on 10 to find the crowd's top 3. It will need changed also.

I've been meaning to redo it anyway to add some other features, so I'll put up an expanded version in a few days.

I have some formulas that can address the sorting part which would eliminate the need to sort if you want, I already tried it on your imports sheet.