Good Luck!

Attached Files

DAILY RACE LIST-20120215.xlsx (29.9 KB, 425 views)

What been missed is those Jackpot Trifecta, ain't seen one for a while.
I remember being at work in the late 80's listening to the TAB, and when the race caller said "Trifecta was jackpot", it would be noted into a black book type of thing, so it seemed it did to many others.
When the jackpot race came on the next time round, nice payouts cos many would plunge for the jackpot.
On some occasions it become a triple or quad jackpot, it would go off, but the race was too easy the payouts were emm, well I guess a car wash AND full detail would be the order of the day at least.

Godd Luck Today

Attached Files

DAILY RACE LIST-20120216.xlsx (30.2 KB, 406 views)

Two of the sheets have time order a bit messed up, try to fix, but the horse and trotts only sheet is good to go.

Attached Files

DAILY RACE LIST-20120217.xlsx (39.9 KB, 393 views)

Ok,
can do this for another week, so next Saturday will probably be the last day I'm posting these lists.
Still haven't had much time to fix the Workbook that makes the list, cos there still needs some macro to be sorted and waiting for a few replies to sot it out.
Unless Shaun's Excel thread picks up pace and more members show interest and feedback, what's the point.
If you still need the lists, consider asking Neil to pass on your email address to me
( cos there is no PMs)
and I'll send the list via email, cos that can eventually be on a auto-send.

Got a week to sort this out.

Good Luck Today !

Attached Files

DAILY RACE LIST-20120218.zip (32.7 KB, 388 views)

Hoping Shaun continues with the thread, Ive picked up plenty so far & successfully automated a few tasks

Hope everyone had a OK weekend.

Good Luck Today!

Attached Files

DAILY RACE LIST-20120220.xlsx (26.0 KB, 486 views)

A slight tweak,
the Greyhound Sheet has only Greyhounds.

Working from a TAB web page that already has a time-order-race-list, which makes the macro easier to code, except separating each detail into it's own column. Some use long winded formula, I use macro. Each to their own architecture I guess.

And,
Why on turf do they put "AR Morphetville" in the same column?
It ought to be "AR" "1" "Morphetville "12:00:00 PM" in four separate columns.
So when it Imports it's simply there!

We, the "customer", that being the Punter, is always right, right?

Good Luck Today

Attached Files

DAILY RACE LIST-20120221.xlsx (27.1 KB, 482 views)

If you get stuck on any separation formulas let me know i have used a lot of different ones in the past to pull out info.

Only formula not macros.

Thanks Shaun,


Yeah, I got a new import I'm trialing, so what I'll do next few days is get the Import macro working and makes sure it DATES correctly, then I'll "seperate" the data into a test sheet and you may see how the format can be.
Then, I'll macro the formula, so it becomes auto, and voila!
Race list # 2

Working on that macro'd race list.

Good Luck Today

Attached Files

DAILY RACE LIST-20120222.xlsx (30.7 KB, 371 views)