05-10-2004, 08:40 AM | #51 | ||
Pro Rookie
Join Date: Nov 2002
Location: Sunny South of France
|
Playing around further, found another error.
Starting at RG and further down the list, the stats are not imported. Can't figure out why.
__________________
Detroit Vampires (CFL) : Ve 're coming for your blood! Camargue Flamingos (WOOF): pretty in Pink |
||
05-10-2004, 08:45 AM | #52 |
Pro Rookie
Join Date: Nov 2002
Location: Sunny South of France
|
One other suggestion : do positionnal groupings if possible, eg group tackles, ILB, etc...
Do-able ? Hey, you did ask for suggestions and comments !
__________________
Detroit Vampires (CFL) : Ve 're coming for your blood! Camargue Flamingos (WOOF): pretty in Pink |
05-10-2004, 09:00 AM | #53 |
Dearly Missed
(9/25/77-12/23/08) Join Date: Nov 2003
Location: DC Suburbs
|
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.
__________________
NAFL New Orleans Saints GM/Co-Commish MP Career Record: 114-85 NAFL Super Bowl XI Champs In memory of Gavin Anthony: 7/22/08-7/26/08 |
05-10-2004, 09:23 AM | #54 |
Pro Rookie
Join Date: Nov 2002
Location: Sunny South of France
|
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 !
__________________
Detroit Vampires (CFL) : Ve 're coming for your blood! Camargue Flamingos (WOOF): pretty in Pink |
05-10-2004, 09:36 AM | #55 |
Dearly Missed
(9/25/77-12/23/08) Join Date: Nov 2003
Location: DC Suburbs
|
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.
__________________
NAFL New Orleans Saints GM/Co-Commish MP Career Record: 114-85 NAFL Super Bowl XI Champs In memory of Gavin Anthony: 7/22/08-7/26/08 |
05-10-2004, 10:16 AM | #57 | |
Pro Starter
Join Date: Oct 2000
Location: Cary, NC
|
Quote:
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.
__________________
-- Greg -- Author of various FOF utilities |
|
05-10-2004, 11:45 AM | #58 |
Dearly Missed
(9/25/77-12/23/08) Join Date: Nov 2003
Location: DC Suburbs
|
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.
__________________
NAFL New Orleans Saints GM/Co-Commish MP Career Record: 114-85 NAFL Super Bowl XI Champs In memory of Gavin Anthony: 7/22/08-7/26/08 |
05-10-2004, 11:51 AM | #59 |
Pro Starter
Join Date: Feb 2004
|
Yeah. Sent the file to this address:
sovstar AT juno.com |
05-10-2004, 12:02 PM | #60 |
Dearly Missed
(9/25/77-12/23/08) Join Date: Nov 2003
Location: DC Suburbs
|
Just sent it to you.
__________________
NAFL New Orleans Saints GM/Co-Commish MP Career Record: 114-85 NAFL Super Bowl XI Champs In memory of Gavin Anthony: 7/22/08-7/26/08 |
05-10-2004, 12:08 PM | #61 |
Dearly Missed
(9/25/77-12/23/08) Join Date: Nov 2003
Location: DC Suburbs
|
__________________
NAFL New Orleans Saints GM/Co-Commish MP Career Record: 114-85 NAFL Super Bowl XI Champs In memory of Gavin Anthony: 7/22/08-7/26/08 |
05-10-2004, 01:17 PM | #63 |
College Benchwarmer
Join Date: Oct 2003
|
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.
|
05-11-2004, 05:50 AM | #64 |
Dearly Missed
(9/25/77-12/23/08) Join Date: Nov 2003
Location: DC Suburbs
|
Need another Draft Export
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.
__________________
NAFL New Orleans Saints GM/Co-Commish MP Career Record: 114-85 NAFL Super Bowl XI Champs In memory of Gavin Anthony: 7/22/08-7/26/08 |
05-11-2004, 09:03 AM | #65 |
Dearly Missed
(9/25/77-12/23/08) Join Date: Nov 2003
Location: DC Suburbs
|
Anyone, draft file export? Anyone......Bueller......Bueller.............
__________________
NAFL New Orleans Saints GM/Co-Commish MP Career Record: 114-85 NAFL Super Bowl XI Champs In memory of Gavin Anthony: 7/22/08-7/26/08 |
05-11-2004, 10:33 AM | #66 |
Pro Rookie
Join Date: Nov 2002
Location: Sunny South of France
|
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
__________________
Detroit Vampires (CFL) : Ve 're coming for your blood! Camargue Flamingos (WOOF): pretty in Pink |
05-11-2004, 10:36 AM | #67 |
Dearly Missed
(9/25/77-12/23/08) Join Date: Nov 2003
Location: DC Suburbs
|
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.
__________________
NAFL New Orleans Saints GM/Co-Commish MP Career Record: 114-85 NAFL Super Bowl XI Champs In memory of Gavin Anthony: 7/22/08-7/26/08 |
05-11-2004, 10:38 AM | #70 |
Dearly Missed
(9/25/77-12/23/08) Join Date: Nov 2003
Location: DC Suburbs
|
I fixed it and sent you another version. Do you have a Draft Text file? I would like to test it out myself.
__________________
NAFL New Orleans Saints GM/Co-Commish MP Career Record: 114-85 NAFL Super Bowl XI Champs In memory of Gavin Anthony: 7/22/08-7/26/08 |
05-11-2004, 10:41 AM | #71 |
Pro Rookie
Join Date: Nov 2002
Location: Sunny South of France
|
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 ?
__________________
Detroit Vampires (CFL) : Ve 're coming for your blood! Camargue Flamingos (WOOF): pretty in Pink |
05-11-2004, 10:42 AM | #72 |
Dearly Missed
(9/25/77-12/23/08) Join Date: Nov 2003
Location: DC Suburbs
|
You did, but I can't find it. Actually, I think that is what I am working with now.
__________________
NAFL New Orleans Saints GM/Co-Commish MP Career Record: 114-85 NAFL Super Bowl XI Champs In memory of Gavin Anthony: 7/22/08-7/26/08 |
05-11-2004, 10:53 AM | #74 |
Dearly Missed
(9/25/77-12/23/08) Join Date: Nov 2003
Location: DC Suburbs
|
I need to get rid of the "All". It was just too complex to do on that page.
__________________
NAFL New Orleans Saints GM/Co-Commish MP Career Record: 114-85 NAFL Super Bowl XI Champs In memory of Gavin Anthony: 7/22/08-7/26/08 |
05-11-2004, 11:01 AM | #76 |
Pro Rookie
Join Date: Nov 2002
Location: Sunny South of France
|
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.
__________________
Detroit Vampires (CFL) : Ve 're coming for your blood! Camargue Flamingos (WOOF): pretty in Pink |
05-11-2004, 11:01 AM | #77 |
Dearly Missed
(9/25/77-12/23/08) Join Date: Nov 2003
Location: DC Suburbs
|
Already on it.....I am adding more VBA codes to do that, and fixing some formula's.
__________________
NAFL New Orleans Saints GM/Co-Commish MP Career Record: 114-85 NAFL Super Bowl XI Champs In memory of Gavin Anthony: 7/22/08-7/26/08 |
05-11-2004, 11:05 AM | #78 |
Pro Rookie
Join Date: Nov 2002
Location: Sunny South of France
|
OK, I'll let you handle it then as you obviously are much more qualified for the task than I am...
__________________
Detroit Vampires (CFL) : Ve 're coming for your blood! Camargue Flamingos (WOOF): pretty in Pink |
05-11-2004, 11:57 AM | #79 |
Dearly Missed
(9/25/77-12/23/08) Join Date: Nov 2003
Location: DC Suburbs
|
Okay Froggies and Sovereign, check your emails!!! New version of the mod.
__________________
NAFL New Orleans Saints GM/Co-Commish MP Career Record: 114-85 NAFL Super Bowl XI Champs In memory of Gavin Anthony: 7/22/08-7/26/08 |
05-11-2004, 12:11 PM | #81 |
Pro Starter
Join Date: Feb 2004
|
|
05-11-2004, 12:28 PM | #83 |
Dearly Missed
(9/25/77-12/23/08) Join Date: Nov 2003
Location: DC Suburbs
|
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?
__________________
NAFL New Orleans Saints GM/Co-Commish MP Career Record: 114-85 NAFL Super Bowl XI Champs In memory of Gavin Anthony: 7/22/08-7/26/08 |
05-11-2004, 12:29 PM | #84 |
Pro Starter
Join Date: Feb 2004
|
Go ahead and create the account I made for you. I've got to jet!
|
05-11-2004, 12:30 PM | #85 |
Dearly Missed
(9/25/77-12/23/08) Join Date: Nov 2003
Location: DC Suburbs
|
What does it say or debug at? I am not getting it, I wonder if it is a version problem, I am using XP.
__________________
NAFL New Orleans Saints GM/Co-Commish MP Career Record: 114-85 NAFL Super Bowl XI Champs In memory of Gavin Anthony: 7/22/08-7/26/08 |
05-11-2004, 12:36 PM | #86 | |
Pro Rookie
Join Date: Nov 2002
Location: Sunny South of France
|
Quote:
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.
__________________
Detroit Vampires (CFL) : Ve 're coming for your blood! Camargue Flamingos (WOOF): pretty in Pink |
|
05-11-2004, 12:42 PM | #87 |
Dearly Missed
(9/25/77-12/23/08) Join Date: Nov 2003
Location: DC Suburbs
|
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.
__________________
NAFL New Orleans Saints GM/Co-Commish MP Career Record: 114-85 NAFL Super Bowl XI Champs In memory of Gavin Anthony: 7/22/08-7/26/08 |
05-11-2004, 12:42 PM | #88 |
Pro Rookie
Join Date: Nov 2002
Location: Sunny South of France
|
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.
__________________
Detroit Vampires (CFL) : Ve 're coming for your blood! Camargue Flamingos (WOOF): pretty in Pink |
05-11-2004, 12:46 PM | #90 |
Dearly Missed
(9/25/77-12/23/08) Join Date: Nov 2003
Location: DC Suburbs
|
My bad, I'll let you reply a few times to my post before I post again.....HAHAHA!
__________________
NAFL New Orleans Saints GM/Co-Commish MP Career Record: 114-85 NAFL Super Bowl XI Champs In memory of Gavin Anthony: 7/22/08-7/26/08 |
05-11-2004, 12:49 PM | #91 |
Pro Rookie
Join Date: Nov 2002
Location: Sunny South of France
|
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...
__________________
Detroit Vampires (CFL) : Ve 're coming for your blood! Camargue Flamingos (WOOF): pretty in Pink |
05-11-2004, 01:04 PM | #93 |
Pro Rookie
Join Date: Nov 2002
Location: Sunny South of France
|
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.
__________________
Detroit Vampires (CFL) : Ve 're coming for your blood! Camargue Flamingos (WOOF): pretty in Pink |
05-11-2004, 01:05 PM | #94 |
Dearly Missed
(9/25/77-12/23/08) Join Date: Nov 2003
Location: DC Suburbs
|
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.
__________________
NAFL New Orleans Saints GM/Co-Commish MP Career Record: 114-85 NAFL Super Bowl XI Champs In memory of Gavin Anthony: 7/22/08-7/26/08 |
05-11-2004, 01:06 PM | #95 |
Dearly Missed
(9/25/77-12/23/08) Join Date: Nov 2003
Location: DC Suburbs
|
Well thats not good, minor fix, I will patch and send to you two again.
__________________
NAFL New Orleans Saints GM/Co-Commish MP Career Record: 114-85 NAFL Super Bowl XI Champs In memory of Gavin Anthony: 7/22/08-7/26/08 |
05-11-2004, 01:11 PM | #96 | |
Pro Rookie
Join Date: Nov 2002
Location: Sunny South of France
|
Quote:
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...
__________________
Detroit Vampires (CFL) : Ve 're coming for your blood! Camargue Flamingos (WOOF): pretty in Pink |
|
05-11-2004, 02:51 PM | #97 |
College Benchwarmer
Join Date: Oct 2003
|
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.
|
05-11-2004, 03:09 PM | #98 |
Dearly Missed
(9/25/77-12/23/08) Join Date: Nov 2003
Location: DC Suburbs
|
***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.
__________________
NAFL New Orleans Saints GM/Co-Commish MP Career Record: 114-85 NAFL Super Bowl XI Champs In memory of Gavin Anthony: 7/22/08-7/26/08 |
05-11-2004, 03:19 PM | #99 |
Dearly Missed
(9/25/77-12/23/08) Join Date: Nov 2003
Location: DC Suburbs
|
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.
__________________
NAFL New Orleans Saints GM/Co-Commish MP Career Record: 114-85 NAFL Super Bowl XI Champs In memory of Gavin Anthony: 7/22/08-7/26/08 |
05-15-2004, 08:58 AM | #100 |
Pro Starter
Join Date: Oct 2000
Location: Cary, NC
|
Extractor 2.0 Teaser
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:
__________________
-- Greg -- Author of various FOF utilities |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
Thread Tools | |
|
|