MaddiesTmMgmtWorkbook Topic

npknight
Posts: 45 (0)
Veteran
25
Prospect
[email protected]
12/2/2008 9:05 AM
skeeziks
Posts: 7 (0)
Hall of Famer
13 39
Prospect
[email protected].
12/2/2008 9:17 AM
mossyoaksoon
Posts: 0 (0)
All Star
41
Prospect
12/2/2008 9:26 AM
goodtymes31
Posts: 115 (0)
Hall of Famer
1 739 73 322
Prospect
Hi Again, If you sent it, I did not receive it for wahtever reason.



Thanks!
12/2/2008 9:35 AM
goutvols22
Posts: 0 (0)
All Star
1 34
Prospect
I'd be curious to see the new version. Used it awhile ago and never picked up a new copy after the update.

[email protected]

Thanks in advance.
12/2/2008 10:01 AM
Roto_Rob
Posts: 1 (0)
Rookie
1 1 6
Prospect
I'd like to take a look at it.

[email protected]

Thanks!
12/2/2008 12:28 PM
zuno
Posts: 0 (0)
All Star
7 1 22 2
Prospect
I'd like a copy as well, please.
[email protected]
Thanks!
12/2/2008 12:59 PM
hughesjr
Posts: 3175 (0)
Hall of Famer
494 154 8 2
Prospect
You are probably going to have to change a bunch of VLOOKUP column numbers ... I did for several sheets as they have added a STARTING column
12/2/2008 8:08 PM
hughesjr
Posts: 3175 (0)
Hall of Famer
494 154 8 2
Prospect
For the record, the latest changes seem to have royally broken my maddiesdad spreadsheet ... For those of you that are good at excel, I will post what I am doing to fix my sheet right now and you can fix yours as well (or you can wait for Todd to get it fixed if you have no excel skills :D).

First, do not open your current maddiesdad sheet, copy the current one to a backup and open the backup ... then do the normal refreshes. Now we can start fixing problems.

==================================

Due to a couple new items on the Roster, the following needs to be changed in the "WorkSheet" worksheet.

cell E4 needs to change from:

=Roster!C31

to

=Roster!C33

and cell F4 needs to change from:

=Roster!A31

to

=Roster!A33

Then you need to copy the range E4:F4 and paste it range E5:E72

You will need to make the same changes in the OppWorkSheet and OppWorkSheet (2) through OppWorkSheet (16).

==================================

Another problem is the new "Starters" column on the Roster and the affect that has on the "Players Table" worksheet.

You guys can fix this one by changing the VLOOKUP formulas so that the Attributes are shifted one to the Right .. so in Athleticism ("cell E4" on the "PlayersTable" worksheet, it would go from this:

=IF(ISNA( VLOOKUP($B4,table3,4,FALSE)),0,VLOOKUP($B4,table3,4,FALSE))

to this:

=IF(ISNA( VLOOKUP($B4,table3,5,FALSE)),0,VLOOKUP($B4,table3,5,FALSE))

You would then change all the other attributes (cells F4 to Q4) in the same way (shift the number after table3 one higher than it currently is). Once this is done, the first QB should now look correct again.

Highlight the range E4:Q4 and press Ctrl-C to copy that range, then hightlight the range E5:E8 and use the menu item EDIT->Paste Special (and pick only Formulas) to paste the info into that range. Your QBs should now look correct again. IF THEY ARE ... then paste the data into the following ranges (one at a time):

E14:E23

E29:E37

The first range was your RB, the second your WR. You should be able to get the other postitions from that (TE is E43:E48). Paste the original range into all the other postions.

In the "TEAM AVERAGES" column, you will also have to shift the VLOOKUP on column to the right (increase the number in position 3 by 1) for each attribute. So, in cell E138, change:

=VLOOKUP($B$138,roster,4,FALSE)

to

=VLOOKUP($B$138,roster,5,FALSE)

Now your PlayerTable should be correct.

You will need to make similar changes to each of the Opp1, Opp2, Opp3 (all the way to Opp16) worksheets.

===========================

I have not completely looked at everything else, I did noticed that the Career Stats are broken, but that is a macro that does a webquery and I have not figured out the issue there yet.
12/3/2008 5:27 AM
hughesjr
Posts: 3175 (0)
Hall of Famer
494 154 8 2
Prospect
OH ... and I should say that the latest GD updates (are they calling this GD 3.0) is what caused all these issues.
12/3/2008 5:34 AM
hughesjr
Posts: 3175 (0)
Hall of Famer
494 154 8 2
Prospect
While fixing the Opp, Opp1, PostSeasonOpp sheets I noticed a bug, in that the TEAM AVERAGES: line (at least on my version, I have one that is modified) ... calls the range named roster .

This is a bug, because that range will get the team averages for YOUR team and not the opponent for that row.

If you have that on your sheets, you can instead use this forumla to get the averages for the team in question and not your team:

=(SUMIF(D2:D5,">0")+SUMIF(D10:D16,">0")+SUMIF(D24:D32,">0")+SUMIF(D37:D42,">0")+SUMIF(D47:D59,">0")+SUMIF(D64:D75,">0")+SUMIF(D79:D88,">0")+SUMIF(D92:D103,">0")+SUMIF(D107:D109,">0")+SUMIF(D113:D115,">0"))/(COUNTIF(D2:D5,">0")+COUNTIF(D10:D16,">0")+COUNTIF(D24:D32,">0")+COUNTIF(D37:D42,">0")+COUNTIF(D47:D59,">0")+COUNTIF(D64:D75,">0")+COUNTIF(D79:D88,">0")+COUNTIF(D92:D103,">0")+COUNTIF(D107:D109,">0")+COUNTIF(D113:D115,">0"))

That formula would go into the Team Averages: line in cell D118 ... and then you would copy that cell and paste into cells E118:P118

This would be applicable to all the Opp# and PostSeasonOpp sheet. The reason I did an average and not a lookup is that there is not a NAME (named range) defined on each OppRoster(#) sheet (welll, not one that starts on the correct column for this lookup) and the formula was easier to do than to define 20 new names and then do the lookups. You might also want to select the range D118:P118 and set the format to Number and 0 decimal places before you copy it to the other sheets.

BTW ... I am not recommending anyone change their sheets :D ... just if you are as addicted to it as I am and can't wait for Todd to get it going, you can give this a shot :D
12/3/2008 6:56 AM
pcf2007
Posts: 15 (0)
Hall of Famer
6 205
Prospect
UGH...YEAH RIGHT............
12/3/2008 5:18 PM
hughesjr
Posts: 3175 (0)
Hall of Famer
494 154 8 2
Prospect
just trying to help :D
12/3/2008 6:19 PM
columbusbuck
Posts: 1033 (0)
Hall of Famer
1 177
Prospect
Yeah, I guess Todd is busy making the changes and will send out the updated workbook when he's done.

Until then, no workbooks for me. Depth charts will be figured the old fashioned way (with pencil and paper).
12/4/2008 5:07 AM
hughesjr
Posts: 3175 (0)
Hall of Famer
494 154 8 2
Prospect
I am currently stuck at trying to figure out why the career stats web queries are busted ... and I still have to make my groundzero updates between seasons work on my sheet (which started out as a maddiesdad sheet, but is now highly modified).
12/4/2008 5:34 AM
◂ Prev 1...68|69|70|71|72...76 Next ▸
MaddiesTmMgmtWorkbook Topic
△Top△Bottom

Search Criteria

Terms of Use Customer Support Privacy Statement

© 1999-2026 WhatIfSports.com, Inc. All rights reserved. WhatIfSports is a trademark of WhatIfSports.com, Inc. SimLeague, SimMatchup and iSimNow are trademarks or registered trademarks of Electronic Arts, Inc. Used under license. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.