MS Access as Handicapping Database

[BroadwayJoe]

Originally Posted by MJC922

Joe are you planning to provide a file for me to work with as an example?

I would say something like this would be sufficient just for kicks:
date,track,racenum,horse, then whatever ratings you have that represent your paceline for each horse for showing the F1,F2,F3, FinishPosition,Odds to $1

A decent number of races 200, 500? Doesn't matter much it's just an example.

I could probably throw something together with that data this weekend. No real plans except to take my son to do some driving, he finally got his permit.

Email it?

or

you can do it?

no rush...

[MJC922]

Email it if it's allowed. I don't know what restrictions are in play tbh. What I outlined in the handful of 'fields' for a csv doesn't seem as if it goes beyond the realm of basic historical info; however if the moderators see it differently we'll have to do things some other way.

I would actually like to post said spreadsheet somewhere afterward so the board members who may be interested in playing around with solver can explore it on their own with more relevant data they may have at hand.

[BroadwayJoe]

Originally Posted by MJC922

Email it if it's allowed. I don't know what restrictions are in play tbh. What I outlined in the handful of 'fields' for a csv doesn't seem as if it goes beyond the realm of basic historical info; however if the moderators see it differently we'll have to do things some other way.

I would actually like to post said spreadsheet somewhere afterward so the board members who may be interested in playing around with solver can explore it on their own with more relevant data they may have at hand.

PM your email please

[classhandicapper]

Originally Posted by MJC922

I would actually like to post said spreadsheet somewhere afterward so the board members who may be interested in playing around with solver can explore it on their own with more relevant data they may have at hand.

Please do.

That might motivate me to revisit some of the things I was testing a few years back and try to improve on it.

[BroadwayJoe]

Originally Posted by classhandicapper

Please do.

That might motivate me to revisit some of the things I was testing a few years back and try to improve on it.

Agree!!!

[Tom]

Originally Posted by classhandicapper

Please do.

That might motivate me to revisit some of the things I was testing a few years back and try to improve on it.

+1

[BroadwayJoe]

This is the file I supplied to MJC..

its derived from my HTR

hope I'm ok putting this up

if not , please take off

[MJC922]

I have an example all set to upload based upon your data. Are the moderators ok with it? Mike, CJ? Let me know, I don't want to violate any rules by doing it.

[BroadwayJoe]

Originally Posted by MJC922

I have an example all set to upload based upon your data. Are the moderators ok with it? Mike, CJ? Let me know, I don't want to violate any rules by doing it.

Send it back to me and I'll put it up...

Since mine is still up...if not

I have a new name all set up


"IDONTGIVEUP"

[Tom]

LOL..remember DEREK2U?
His retred name was PLAN B!

[BroadwayJoe]

Gonna put this up now since Mods have no comment...

It took me some time to grasp it ......

Its more complicated to set up than regression


The key here starts with Solvers "Target"

Once you understand this it's ....Ahhhhhhhh. I get it

The one thing I need to dwell more on is the "constraints" decisions

Once you D/L this ...Go to Solver and let it rip...



Just save a copy of the original if you try things with it


Any comments , please do....maybe some "constraints" talk

Thxs again MJC

[BroadwayJoe]

There's one thing I see as an issue using this as a template....


Starting with V17 and down....

If you input your own data and the race has a different amount of entries than inputted here

this wont work...I believe

[formula_2002]

Originally Posted by BroadwayJoe

There's one thing I see as an issue using this as a template....


Starting with V17 and down....

If you input your own data and the race has a different amount of entries than inputted here

this wont work...I believe

thanks for the file. I was curious how close Solver was to what I have been doing for years. Pretty, pretty, pretty close..I find a few 0f the formula constructs interesting and will try them out.
I use many formula's and macros. Given all of that I still stumble along looking for the ultimate "What IF"

Good Luck

most interesting

v17 =RANK(U17,$U$17:$U$22,0) v17 formula
t17 =IF($P17=1,$J$2,IF($P17=2,$J$3,IF($P17=3,$J$4,IF($ P17=4,$J$5,$J$6))))

thats it.

[BroadwayJoe]

Originally Posted by formula_2002

thanks for the file. I was curious how close Solver was to what I have been doing for years. Pretty, pretty, pretty close..I find a few 0f the formula constructs interesting and will try them out.
I use many formula's and macros. Given all of that I still stumble along looking for the ultimate "What IF"

Good Luck

most interesting

v17 =RANK(U17,$U$17:$U$22,0) v17 formula
t17 =IF($P17=1,$J$2,IF($P17=2,$J$3,IF($P17=3,$J$4,IF($ P17=4,$J$5,$J$6))))

thats it.

MJ did add rMLO to this sheet ....

Along with this and V column I mentioned looks like he did stuff outside of this

sheet making it not quite a template but its seems doable to fix ..

Just need time and quiet thoughts to write all the formulas

I plan on adding something like 20 factors to make a template that I can go

forward with...

Mike

[MJC922]

Correct, this is not a template that you can just import your data into. This is only a simple demonstration of how solver can be setup to do some things with handicapping data.