Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #21  
Old 22nd February 2012, 10:11 PM
Puntz Puntz is offline
Member
 
Join Date: Jan 2012
Posts: 292
Default

Ok, this workbook has a trial auto-race list.
It's web query is from www.tab.com.au

It's on test for now and hopefully Shaun may trim it up a bit or anyone else.
Just press the blue STAR Macro Enabler
in BUTTON SHEET

Or you can check out the process using the F8 key.

I'll still post the daily race sheet till and including this Saturday.
Attached Files
File Type: xlsm NEW-AUTO-DAILY RACE LIST-20120222.xlsm (76.3 KB, 559 views)
Reply With Quote
  #22  
Old 23rd February 2012, 12:24 AM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,457
Default

Made a couple adjustments to import and auto start.

For auto start to work workbook needs to be open.
Attached Files
File Type: xlsm NEW-AUTO-DAILY RACE LIST-20120222.xlsm (79.6 KB, 517 views)
Reply With Quote
  #23  
Old 24th February 2012, 12:07 AM
Puntz Puntz is offline
Member
 
Join Date: Jan 2012
Posts: 292
Default

Ok,

So we have a BASIC Auto-Race List, there will be more ongoing developments as time permits.
Ideas welcomed.

Shaun, noticed the added code, it's much quicker and cleaner. Thanks.

The Timer is ok, seen it before ages and ages ago, forgot.

This version had to have a tweak, cos it missed a row in Sheet 2.

That's it from me, I won't be posting a daily race list from now on except updated Auto versions on this thread.
Attached Files
File Type: xlsm xml RACE-LIST-A1-20120223 ws.xlsm (61.1 KB, 496 views)
Reply With Quote
  #24  
Old 24th February 2012, 08:13 AM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,457
Default

There is extra you can add to the time code so that if the worksheet is closed it will open run the macro save the sheet and close again.
Reply With Quote
  #25  
Old 26th February 2012, 09:59 AM
Puntz Puntz is offline
Member
 
Join Date: Jan 2012
Posts: 292
Default Minor Fixes

Some minor fixes noted today,
Deletes rows with Abandoned races in Sheet 2
Attached Files
File Type: xlsm xml RACE-LIST-A1-20120226 ws.xlsm (67.0 KB, 538 views)
Reply With Quote
  #26  
Old 28th February 2012, 08:39 AM
Puntz Puntz is offline
Member
 
Join Date: Jan 2012
Posts: 292
Default Update-Seperated Lists

It may seem trivial, but to the eye and making decisions with money, less clutter can be an advantage.
Therefore I thought, ( that's a problem, "I thought"!) separating the list so harness,grey and races have their own list.

All worked well and on time.
Attached Files
File Type: xlsm xml RACE-LIST-A1-20120228 ws.xlsm (78.7 KB, 513 views)
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 04:27 PM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655