My newest homemade sheet for Breeders Cup

[douglasw32]

http://lcrhelp.com/wizard/

I think this will work for everyone.

Has the output fromHANDIFAST and some tricks I learned watching RAYBO and ALLDATA (not nearly as sophisticated) but shows the factors I use in an easy to read format.

-Doug

[Krudler]

Doug:

Even a newbie like me could figure out the 2003 BC races 10 years down the track! :)

Krudler

[douglasw32]

LOL...Sleep Deprivation.
Thanks :bang:
I will fix the title. And I made some printable PDF's for myself and through them into the post, who knows this may help someone hit a few.

[douglasw32]

P.S. the site is just a placeholder for me to post the daily sheet I make for a buddy of mine, it is all just for fun.

[raybo]

Quite impressive Doug! Unfortunately I can't get it to open in Excel 2002 or 2010. And there appears to be no way to download it first and then open locally.

[douglasw32]

Not sure, i am new with the microsoft cloud stuff, I made it "public" lets me download it but I am signed in. I will try just uploading it, and it forced me to save it as a macro enabled workbook and it is in 2010 for the formatting ?

I don't use excel much but I saw what you did with making 20 pp's lines and filling form there. So I wrote a simple little program that processes the drf single, crunches some numbers then kicks out a csv file that the macro imports to the spreadsheet, then I open all the races in Handifast and let that make a csv at the end and pull that into the other tab.

[douglasw32]

http://lcrhelp.com/wizard/uploads/

I saved them as .xls and uploaded them above.

Friday (today) and Sat.

If anyone is interested in the program/code that talks to the macro enabled sheet I can upload those too ? Maybe someoe can doll it up even more than what I have. I am a rookie.

[raybo]

http://lcrhelp.com/wizard/uploads/

I saved them as .xls and uploaded them above.

Friday (today) and Sat.

If anyone is interested in the program/code that talks to the macro enabled sheet I can upload those too ? Maybe someoe can doll it up even more than what I have. I am a rookie.

Cool! Yeah, I was going to suggest that you save it as a '97-2003 workbook (.xls) so it can be opened in any version of Excel. Uploading the code is not a bad idea, I may not be able to make heads or tails out of it (I know a bit of VBA coding but that's about it) but someone else might be able to "enhance" it.

[raybo]

Not sure, i am new with the microsoft cloud stuff, I made it "public" lets me download it but I am signed in. I will try just uploading it, and it forced me to save it as a macro enabled workbook and it is in 2010 for the formatting ?

I don't use excel much but I saw what you did with making 20 pp's lines and filling form there. So I wrote a simple little program that processes the drf single, crunches some numbers then kicks out a csv file that the macro imports to the spreadsheet, then I open all the races in Handifast and let that make a csv at the end and pull that into the other tab.

I'd really like to see that code, on second thought, as I've always wanted to create a "front end" for my Excel workbooks, not that it's really needed but might make things a bit more user friendly since yours is Windows based coding, while mine is all Excel VBA coding, and must be run from within Excel.

[douglasw32]

Uploaded my mess, it is in VB dot Net
I use the free visual studio, it was 2012 but should open in 2013, I just have not upgraded.

http://www.microsoft.com/visualstudio/eng/downloads#d-2013-express

A bunch of the folders in the "CODE" directory are not needed probably, I upgraded it from vb6 to 2010, then again to 2012 to avoid having to rewrite everything.

http://lcrhelp.com/wizard/uploads/software/

[douglasw32]

I am uploading a zip file of my whole working directory, it would take forever to leaf through all the code in the folders and download each part.

in the software folder linked to earlier in the posts.

[raybo]

Whewww! I was wondering where the heck to start looking! Like I eluded to, I'm no programmer.

[DeltaLover]

I am uploading a zip file of my whole working directory, it would take forever to leaf through all the code in the folders and download each part.

in the software folder linked to earlier in the posts.

Douglas,

you might want to take a look onto a source control system like perforce, cvs or git.

In my opinion git is the best among them and you can very easily open a free account with github to keep and share your code. It is a much better approach that using tarballs.

[douglasw32]

I will look into that, but I am no programmer either, just pulled it off using google ;)

I should mention the files I ran for BC have the settings in them I used for MNR, lol, didn't pan out to well, so my handifast stuff should be replaced with yours.

[douglasw32]

weights.cfg file for handifast that worked for fridays sa races very well was.

0,0,0,0,0,54,0,9,0,9,0,0,0,24 0 0 0 9 0 0

I am going to redo just the one I posted on the website, so my buddy has the corrected one. If anyone is following along and wants the most up to date one, it will be there. But not for a few hours.

[douglasw32]

Okay closing this up, hope I made sense, links should stay active, do whatever you want with the code if you improve upon it please send me a copy.

I use this thing.

The one I settled on for tomorrow (Breeders Cup) is posted at.

http://lcrhelp.com/wizard/

I made it in PDF format so I could get it on my Iphone.

Thanks everyone on PA for all the motivation to learn.