http://www.thecfl.us/forum/ |
|
| Ping: 3ric http://www.thecfl.us/forum/viewtopic.php?t=3611 |
Page 1 of 1 |
| Author: | TurfToe [ Tue Jun 26, 2007 10:41 pm ] |
| Post subject: | Ping: 3ric |
Do you have the AAA macro for FOF2007? I found a thread where you processed one for FOF2004 and I also found the macro in an old spreadsheet I had but I can only get it to go partway through before erroring out. This is even after I delete the unnecesary columns. If you have it cool, otherwise I will keep looking I guess. TIA! |
|
| Author: | Fastcat [ Wed Jun 27, 2007 8:42 am ] |
| Post subject: | |
I would be interested in this as well, I found my 2013 draft report with the AAA ratings, but no macro in it, so I am very much confused. Did 3ric post last years draft class spread sheet by chance? Maybe that is where I got it from. |
|
| Author: | Raven Hawk [ Wed Jun 27, 2007 8:56 am ] |
| Post subject: | |
I found the macro on my computer late last night (along with instructions on how to use it). I ran it and it seemed to work fine, with a couple of exceptions. Since it was from the FOF2004 days, it didn't account for players that didn't go to the combine. Otherwise, it seems to work relatively well. Don't worry, TT. Hutchison studs it up on the Triple-A scale.  I'll post the files later tonight if somebody else doesn't post it before me. |
|
| Author: | Cheesehead Craig [ Wed Jun 27, 2007 9:25 am ] |
| Post subject: | |
[quote0f48dd1="Raven Hawk"]I found the macro on my computer late last night (along with instructions on how to use it). I ran it and it seemed to work fine, with a couple of exceptions. Since it was from the FOF2004 days, it didn't account for players that didn't go to the combine. Otherwise, it seems to work relatively well. Don't worry, TT. Hutchison studs it up on the Triple-A scale. I'll post the files later tonight if somebody else doesn't post it before me.[/quote0f48dd1] I don't remember this. Was this up last season? |
|
| Author: | TurfToe [ Wed Jun 27, 2007 9:39 am ] |
| Post subject: | |
Yes, 3ric did post one for 2013 but that link no longer works. I found an even older one with the macro embedded but I couldn't get it to work all the way with the current extraction even when deleting columns. I don't need it for Hutchinson, it's for everyone else.
|
|
| Author: | Raven Hawk [ Wed Jun 27, 2007 10:54 am ] |
| Post subject: | |
So, do you want the Excel file that the Macro kicks out, or do you want the Macro itself with the instructions? |
|
| Author: | 3ric [ Wed Jun 27, 2007 10:57 am ] |
| Post subject: | |
I can post the Excel sheet for the draft... wait a minute. (edit) Here it is: http://www.hfl-football.net/draft_files ... ft2014.xls |
|
| Author: | 3ric [ Wed Jun 27, 2007 11:01 am ] |
| Post subject: | |
I can post the macro as well, but the latest version is at work, I wanted to include automatic formatting of broad jump values. Those figures has been converted manually until now. |
|
| Author: | Fonzie [ Wed Jun 27, 2007 11:12 am ] |
| Post subject: | |
Cool. Many thanks, 3ric! |
|
| Author: | timmynausea [ Wed Jun 27, 2007 11:25 am ] |
| Post subject: | |
Wicked. Thanks! |
|
| Author: | fantastic flying froggies [ Wed Jun 27, 2007 11:40 am ] |
| Post subject: | |
[quoteead820e="3ric"]I can post the macro as well, but the latest version is at work, I wanted to include automatic formatting of broad jump values. Those figures has been converted manually until now.[/quoteead820e] Can you post it when you have a chance? TIA. |
|
| Author: | 3ric [ Wed Jun 27, 2007 12:05 pm ] |
| Post subject: | |
[quote827a0f6="fantastic flying froggies"][quote827a0f6="3ric"]I can post the macro as well, but the latest version is at work, I wanted to include automatic formatting of broad jump values. Those figures has been converted manually until now.[/quote827a0f6] Can you post it when you have a chance? TIA.[/quote827a0f6] Tomorrow morning if I remember it, otherwise shoot me a PM. |
|
| Author: | 3ric [ Thu Jun 28, 2007 2:00 am ] |
| Post subject: | |
http://www.hfl-football.net/draft_files ... FOF2k7.bas Copy the draft preview off the league html and paste into the Excel sheet. Run the "formatHTMLlist" macro, convert the broad jump values to inches and run the "FOF_draft" macro. I thought I had a working macro for the broad jump values, but I couldn't get it to work this morning - Excel persist in reading them as dates. Add in the different date formats between US and Europe and you've got a headache. |
|
| Author: | Victorious [ Thu Jun 28, 2007 5:09 am ] |
| Post subject: | Thanks so much! |
Thank, 3ric! Your work is greatly appreciated. |
|
| Author: | fantastic flying froggies [ Fri Jun 29, 2007 1:52 pm ] |
| Post subject: | |
Thanks! |
|
| Page 1 of 1 | All times are UTC-07:00 |
| Powered by phpBB® Forum Software © phpBB Limited https://www.phpbb.com/ |
|