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!

_________________
ROF Division Champions: 2039 - 2043, 2045, 2047, 2054, 2056 - 2060, 2063, 2066-2067, 2070-2072
WFC Conference Champions: 2018, 2041, 2042, 2057-2058, 2060, 2062-2063
CFL Champions: 2018, 2041, 2057-2058, 2060, 2062

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.

_________________


San Andreas Division Champions: 2005,2007,2015,2017,2018,2019,2020,2021,2028,2032,2035

2032 Western Conference Champions

2032 CFL Champions

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.

_________________

Deep South Division Champions
2006, 2009-10, 2019, 2023-24, 2027, 2031-32, 2034-35, 2040, 2044, 2046-47, 2051-53, 2055-56, 2058-62
Eastern Conference Champions
2009, 2031, 2055
CFL Champions
2031, 2055
Hall of Fame
Joshua Mask, Douglas Hartman, Carl Bradford, Leland Wellins, Wally Wooden (#80), Brantley Gilmore (#9), Mo Kirwan, Josh Stanton, Efrain Tate

[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?

_________________

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.

_________________
ROF Division Champions: 2039 - 2043, 2045, 2047, 2054, 2056 - 2060, 2063, 2066-2067, 2070-2072
WFC Conference Champions: 2018, 2041, 2042, 2057-2058, 2060, 2062-2063
CFL Champions: 2018, 2041, 2057-2058, 2060, 2062

So, do you want the Excel file that the Macro kicks out, or do you want the Macro itself with the instructions?

_________________

Deep South Division Champions
2006, 2009-10, 2019, 2023-24, 2027, 2031-32, 2034-35, 2040, 2044, 2046-47, 2051-53, 2055-56, 2058-62
Eastern Conference Champions
2009, 2031, 2055
CFL Champions
2031, 2055
Hall of Fame
Joshua Mask, Douglas Hartman, Carl Bradford, Leland Wellins, Wally Wooden (#80), Brantley Gilmore (#9), Mo Kirwan, Josh Stanton, Efrain Tate

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

_________________

Division winners in 2003, 2012, 2016, 2019
147-122-3 regular season record
3-5 playoff record

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.

_________________

Division winners in 2003, 2012, 2016, 2019
147-122-3 regular season record
3-5 playoff record

Cool. Many thanks, 3ric!

_________________

Ring of Fire Division Champions - 2009, 2011-2026, 2028-33
Western Conference Champions - 2011-2013, 2016, 2017, 2019-2022, 2024, 2025, 2028, 2033
CFL Champions - 2011, 2013, 2016, 2017, 2019, 2020, 2022, 2025

Wicked. Thanks!

[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.

[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.

_________________

Division winners in 2003, 2012, 2016, 2019
147-122-3 regular season record
3-5 playoff record

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.

_________________

Division winners in 2003, 2012, 2016, 2019
147-122-3 regular season record
3-5 playoff record

Thank, 3ric! Your work is greatly appreciated.

Thanks!