|
|
10-29-2013, 11:13 PM
|
#1
|
douglasw32
Join Date: Dec 2003
Location: Horseheads, NY
Posts: 1,630
|
My newest homemade sheet for Breeders Cup
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
|
|
|
10-30-2013, 04:58 AM
|
#2
|
Registered User
Join Date: Sep 2011
Posts: 56
|
Doug:
Even a newbie like me could figure out the 2003 BC races 10 years down the track!
Krudler
|
|
|
10-30-2013, 11:56 AM
|
#3
|
douglasw32
Join Date: Dec 2003
Location: Horseheads, NY
Posts: 1,630
|
LOL...Sleep Deprivation.
Thanks
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.
|
|
|
10-30-2013, 11:57 AM
|
#4
|
douglasw32
Join Date: Dec 2003
Location: Horseheads, NY
Posts: 1,630
|
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.
|
|
|
11-01-2013, 12:50 AM
|
#5
|
EXCEL with SUPERFECTAS
Join Date: Mar 2004
Posts: 10,206
|
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.
|
|
|
11-01-2013, 11:16 AM
|
#6
|
douglasw32
Join Date: Dec 2003
Location: Horseheads, NY
Posts: 1,630
|
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.
|
|
|
11-01-2013, 11:38 AM
|
#7
|
douglasw32
Join Date: Dec 2003
Location: Horseheads, NY
Posts: 1,630
|
Friday
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.
|
|
|
11-01-2013, 12:06 PM
|
#8
|
EXCEL with SUPERFECTAS
Join Date: Mar 2004
Posts: 10,206
|
Quote:
Originally Posted by 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.
|
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.
|
|
|
11-01-2013, 12:22 PM
|
#9
|
EXCEL with SUPERFECTAS
Join Date: Mar 2004
Posts: 10,206
|
Quote:
Originally Posted by 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.
|
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.
|
|
|
11-01-2013, 02:46 PM
|
#11
|
douglasw32
Join Date: Dec 2003
Location: Horseheads, NY
Posts: 1,630
|
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.
|
|
|
11-01-2013, 02:52 PM
|
#12
|
EXCEL with SUPERFECTAS
Join Date: Mar 2004
Posts: 10,206
|
Whewww! I was wondering where the heck to start looking! Like I eluded to, I'm no programmer.
|
|
|
11-01-2013, 03:06 PM
|
#13
|
Registered user
Join Date: Oct 2008
Location: FALIRIKON DELTA
Posts: 4,439
|
Quote:
Originally Posted by 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.
|
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.
__________________
whereof one cannot speak thereof one must be silent
Ludwig Wittgenstein
|
|
|
11-01-2013, 07:50 PM
|
#14
|
douglasw32
Join Date: Dec 2003
Location: Horseheads, NY
Posts: 1,630
|
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.
|
|
|
11-01-2013, 08:23 PM
|
#15
|
douglasw32
Join Date: Dec 2003
Location: Horseheads, NY
Posts: 1,630
|
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.
|
|
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|