PDA

View Full Version : getting racetime list format


makadollar
11th June 2005, 09:32 PM
Hi all, Im not sure If I am saying this properly but I am after a link or something to a list of raceday times in order down the sheet.So each race is listed in order of start time regardless of track so bets can be sorted and placed in order. on any given raceday
The big Q is of course is there such a link or place???

Thanks

enjay
11th June 2005, 09:56 PM
For what it is worth, have a look at this site. I have this program and I do not know how I have lived without it.
Try the free version and you will see what I mean.

http://www.stebbo.id.au/bettracker/index.htm


Enjay.

As a disclaimer, I have nothing whatsoeverto do with this site, even though after getting the program I have had regular assistance from to author.

anchor
12th June 2005, 12:05 AM
http://old.racetab.com.au/today/schedule.htm
http://old.racetab.com.au/tomorrow/schedule.htm

makadollar
13th June 2005, 12:29 AM
http://old.racetab.com.au/today/schedule.htm
http://old.racetab.com.au/tomorrow/schedule.htm
Gee we are poor cousins down here in Melbourne, Supertab is very basic now that I have had a good look around.Thanks for the links,but I still could not paste them into excel in turned out goobly dook.!!! lol

Thanks

Shaun
13th June 2005, 01:35 AM
They have one on the WA tab site but the times will be different they are in WA time

SeeDee
13th June 2005, 01:57 PM
Makadollar - When pasting, righ-mouse on excel cell and select Special paste, then text. You may then need to split out over cells using Data, Text to columns, with space as a separator. Not as complex as it sounds.

All the best

makadollar
13th June 2005, 02:30 PM
<TABLE style="WIDTH: 803pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=1071 border=0 x:str><COLGROUP><COL style="WIDTH: 36pt; mso-width-source: userset; mso-width-alt: 1755" width=48><COL style="WIDTH: 84pt; mso-width-source: userset; mso-width-alt: 4096" width=112><COL style="WIDTH: 162pt; mso-width-source: userset; mso-width-alt: 7899" width=216><COL style="WIDTH: 222pt; mso-width-source: userset; mso-width-alt: 10825" width=296><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><COL style="WIDTH: 48pt" span=5 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 36pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=48 height=17>Race #</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 84pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=112>Start Date & Time</TD><TD class=xl23 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 162pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #ffcc00" width=216>Venue</TD><TD class=xl23 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 222pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #ffcc00" width=296>Race Name</TD><TD class=xl23 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 59pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #ffcc00" width=79>SELECTION</TD><TD class=xl23 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #ffcc00" width=64>BET</TD><TD class=xl23 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #ffcc00" width=64>OUTLAY</TD><TD class=xl23 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #ffcc00" width=64>RESULT</TD><TD class=xl23 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #ffcc00" width=64>RETURN</TD><TD class=xl23 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #ffcc00" width=64>BANK</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>[ 5 ]</TD><TD class=xl22 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right x:num="38516.619444444441">13/06/2005 14:52</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent">TOWNSVILLE RACES</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent">NISSAN MAXIMA CL3 HCP 1000m</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent"></TD></TR></TBODY></TABLE>



Call me crazy guys but this is what I want to do.I have worked out a way to download racelist I want into excel.I then added the tabs above, outlay,bet etc(suggest better way is fine) so the end result is all my bets recorded and shows if the won, what they paid, profit loss and bak plus or minus.

The thing is I cannot work out those damn formulas, could someone be so kind as to help me out? I would be wrapped...

davez
14th June 2005, 11:26 AM
this what your after?

makadollar
17th June 2005, 07:29 PM
this what your after?
Gidday Davez Thanks mate this is exactly what I was after good man.

Well done

Cheers

maka

davez
18th June 2005, 11:23 AM
no worries, it is a fairly basic setup tho so let me know if there are any extras you would like to add

Hydrogen
21st June 2005, 08:19 AM
Anchor,

Thanks (belatedly - I've only just read your post). The daily schedule disappeared when they revamped the site and I didn't realise they had reinstated it. It really keeps you focussed to have it.