FOF Extractor (Updated to Version 4.3.0, 6/18/2006: Draft History Screen)

[fantastic flying froggies]

Playing around further, found another error.

Starting at RG and further down the list, the stats are not imported.

Can't figure out why.

[fantastic flying froggies]

One other suggestion : do positionnal groupings if possible, eg group tackles, ILB, etc...
Do-able ?

Hey, you did ask for suggestions and comments !

[gottimd]

Do you mean on the RG, there are all Zero's? I noticed if you use extractor and use another window or program, the extractor gives you all zeros when the FOF screen is not active. So when you extract, stay on the extract screen and FOF screen until it is complete.

As for the groupings, that may take some time.

I want to start working on the draft file, but I am at work, and only have access to the Demo version here. At home, the fiance is not too happy about me ignoring her to work on the excel file, so I have limited time at home.

[fantastic flying froggies]

OK, you're right. The '0' problem is with the extractor file proper, not with your excel file.

As I am at work too, I probably did what you 're saying and jumped to another window.

Re upgrades or other versions, don't sweat it. Right now, it 's a great add-on as is. Anything extra will be a bonus. And don't lose a girlfriend over it !

[gottimd]

If you could send me, or anyone else who happens to be viewing this conversation between us, can send me the Draft File export, I can start working on that when I get a chance. It would also help to have the column headers in there because I am not sure what they are.

[fantastic flying froggies]

Draft file sent.

[gstelmack]

Originally Posted by gottimd

If you could send me, or anyone else who happens to be viewing this conversation between us, can send me the Draft File export, I can start working on that when I get a chance. It would also help to have the column headers in there because I am not sure what they are.

If you need sample files at any time, just let me know. I've got test cases ready to run.

The columns are documented in the readme that comes with Extractor, and as of 1.2 can vary depending on the type of export done (although all draft exports should have the same columns). The biggest issue with differing columns are reports run on rosters/free agents after the draft and before training camp, or with unsigned draft picks on them after training camp.

[gottimd]

Thanks, I am going to use Froggies for now, I'll see what I can come up with, and post updates when I have them. Meanwhile, can anyone host a file? It looks like others can't access my file when I host it on my own site (see previous notes within thread), so to get this utility out there, it needs to be hosted. Right now, it is just the Roster Utility, and I am working on the draft utility now.

[sovereignstar]

Yeah. Sent the file to this address:

sovstar AT juno.com

[gottimd]

Just sent it to you.

[gottimd]

Thanks Sovereign.

File is now hosted here

[fantastic flying froggies]

Originally Posted by gottimd

Thanks Sovereign.

File is now hosted here

Just to confirm that new link is now working fine.

[Sweed]

Just d'loaded these two mods and they are great. Thanks guys for making my game experience better. Thought I'd also add for the computer challenged like myself that this was all very easy to do. And for those that don't have excel like me the xl sheet worked fine in open office. I did have to manually move the roster data into it though.

[gottimd]

Can someone send me a draft export (.txt) file. I have started working on the Draft Export Mod and need to test it out. Thanks.

[gottimd]

Anyone, draft file export? Anyone......Bueller......Bueller.............

[fantastic flying froggies]

Testing draft extractor mod.

Starting the file up, I get the main screen, with the comment 'cells calculating' at the bottom then I get a RTE 1004 - select method of range class failed

[gottimd]

I fixed that. I will send you the new file. I had a Worksheet Calculate event which the range/sheet was not activated. I removed that and replaced with a button on the "Main" sheet.

[fantastic flying froggies]

When debugging, the following line is highlighted :
Rows("36:111").Select

[fantastic flying froggies]

Strangely enough, the file seems to be working fine anyway, even with the RTE.

[gottimd]

I fixed it and sent you another version. Do you have a Draft Text file? I would like to test it out myself.

[fantastic flying froggies]

Hold on a sec, I need to fire my laptop up, I'm sure I've got a draft file on that one.
Didn't I send it to you already yesterday ?

[gottimd]

You did, but I can't find it. Actually, I think that is what I am working with now.

[fantastic flying froggies]

bug - on main screen, filtering by 'all positions' results in nobody shown at all.

[gottimd]

I need to get rid of the "All". It was just too complex to do on that page.

[fantastic flying froggies]

New draft file just emailed.

[fantastic flying froggies]

When importing new draft text file, RTE 1004 - application defined or object defined error.

Methinks one needs to delete the previous data, otherwise your macro cannot parse.
Lemme try it.

[gottimd]

Already on it.....I am adding more VBA codes to do that, and fixing some formula's.

[fantastic flying froggies]

OK, I'll let you handle it then as you obviously are much more qualified for the task than I am...

[gottimd]

Okay Froggies and Sovereign, check your emails!!! New version of the mod.

[fantastic flying froggies]

And at the same time, I was sending you another draft text file that I just ran...

[sovereignstar]

***Updated links for both of gottimd's Mods***

Extractor Mod

Draft Mod

[fantastic flying froggies]

I get an RTE 1004 when pressing the sort button of the main page.

[gottimd]

Sovereign, I am sending the most recent version, just a few touch ups, you should probably host the one I am going to send to you.

Any problems/suggestions?

[sovereignstar]

Go ahead and create the account I made for you. I've got to jet!

[gottimd]

What does it say or debug at? I am not getting it, I wonder if it is a version problem, I am using XP.

[fantastic flying froggies]

Originally Posted by gottimd

What does it say or debug at? I am not getting it, I wonder if it is a version problem, I am using XP.

I am running Me on my desktop, i'll try it on the laptop where I have XP and see if that causes the problem.

Otherwise, the error is application-defined or object defined. Debug stops at
Selection.Sort Key1:=Range("J3"), Order1:=xlAscending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

Lemme run on my laptop first.

[gottimd]

It can be manually sorted as well. I just threw the button in there to automate the process. Sort by position range I3 to AZ1500.

[fantastic flying froggies]

dola - getting the same error on my laptop.

It's be good if somebody else could try it, see if I'm in the only one with the problem.

[fantastic flying froggies]

Grrr, you ruined my dola.
Will do the hand sorting...

[gottimd]

My bad, I'll let you reply a few times to my post before I post again.....HAHAHA!

[fantastic flying froggies]

OK, works fine with the hand sorting. I'll try and sort the macro out myself.
In the meantime, I'm happy with you delivered !
Good job !

You know the next step now is to be able to do the position groupings... I might have a go at it myself...

[fantastic flying froggies]

dola - you can reply now...

[fantastic flying froggies]

In your latest version, the one with the minor fixes, the clear data macro now clears in the main page instead of the draft date export sheet.

[gottimd]

Okay, but it works though, right? I don't think anybody knows of these Mods besides you, sovereign and I.

The groupings would take a bit of work, do you mean group all Offense together and Defense Together, and/or RT and LT all together as Tackles? The problem with making the Offense and Defense grouped into one is that some positions have different Characteristics, so it would be hard to compare.

[gottimd]

Well thats not good, minor fix, I will patch and send to you two again.

[fantastic flying froggies]

Originally Posted by gottimd

The groupings would take a bit of work, do you mean group all Offense together and Defense Together, and/or RT and LT all together as Tackles? The problem with making the Offense and Defense grouped into one is that some positions have different Characteristics, so it would be hard to compare.

I am indeed only talking about the 'simpler' groupings, e.g.
LT and RT -> OT
SLB & WLB -> OLB
I think that is how they are shown on the main draft screen in the game itself. It's just each draftee's individual screen where the position is differenciated.

Re the fact that only sov and I know about those, I disagree with you. You'd be surprised at the amount of people reading those threads and downloading stuff without necessaraly replying. I should know, I was like that before...
Now, I'm a FOFC addict...

[Sweed]

Well, I think I'm the only one that responded in the thread after d'loading. I hope you'll post a link to the final draft mod. The roster one is great as I said above. Thanks again for your efforts.

[gottimd]

***Updated links for both of gottimd's Mods***


Roster Extractor Mod

Draft Extractor Mod


Sovereign is hosting, not sure if he caught my last update, but I will FTP up there in a second so you can have the most recent version.

[gottimd]

Dola-

If the Sort Button doesn't work for some reason (maybe an excel version issue), go to the "Draft Data Export Page", highlight I3 to AZ1500, and sort by column J (position) with no header row in ascending order.

[gstelmack]

Unfortunately, I'm getting ready to go on vacation for a week, so it's going to be a bit longer than I intended before Extractor 2.0 will be released. But meantime here are a couple of teasers.

Sample Scout Data

Completely new feature: