Spreadsheet Help Topic

colonels19
Posts: 4399 (0)
Hall of Famer
78 90 3 1 168 2 1 11
Prospect
To those that do spreadsheets. What exactly do you compile?

I currently have my preseason player ratings and information (I forgot to include IQ) but I'm also going to gather player ratings at the end of the season, along with stats, and results as well....just curious what others do...do you guys do pre and postseason inputs as well or?
12/29/2009 8:48 PM
sideburn
Posts: 2 (0)
Hall of Famer
4 87 1
Prospect
I dump their stats into a pre-formated spreadsheet with EFG% and Winscore formulas. I used to track / record recruits potentials. But stopped doing that recently.
12/30/2009 1:32 AM
schroedess26
Posts: 54 (0)
All Star
29 1 1
Prospect
Its nice to keep a baseline where you have their initial Freshman year before any games. That way you can see their overall increase so when going into the Junior Year you know if a guy was Average and he has improved 19 already you can truly get a fell of whether you need to get someone else to fill his shoes at this point.
12/30/2009 1:41 AM
laststand
Posts: 0 (0)
Prospect
4
Prospect
I think bermanap has the best spreadsheet, if you ask him he used to send it to you, not sure if he still does though.
12/30/2009 11:03 PM
coach_billyg
Posts: 2072 (0)
Hall of Famer
92
Pro
Quote: Originally posted by laststand on 12/31/2009I think bermanap has the best spreadsheet, if you ask him he used to send it to you, not sure if he still does though.

what does it do?
12/31/2009 12:58 AM
brianp87
Posts: 1340 (0)
Hall of Famer
1 46 89
Prospect
It was a spreadsheet that would let you compare players on both teams I believe I never used it but say it. It was way over my head but it had formulas to show off effieciency I think
12/31/2009 7:33 AM
worthy14sure
Posts: 24 (0)
Hall of Famer
197 1
Prospect
I have this spreadsheet and can send it to anyone interested....I am not sure how to use it 100% but I am learning a little each year. Had it a few seasons.

Site mail me an e-mail address.
12/31/2009 10:00 AM
metsmax
Posts: 1598 (0)
Hall of Famer
5 2 836 2
Pro
keep in mind, it depends on what you want to accomplish

if all you are doing is tracking development and potential it is easy - really just record keeping - I do it without even a spreadsheet, just copy the ratings, color code them for potential and adjust the colors as I get messages when kids max out

if you want to evaluate players its a bunch harder - some spreadsheets purport to do that
12/31/2009 11:41 AM
coach_billyg
Posts: 2072 (0)
Hall of Famer
92
Pro
Quote: Originally posted by metsmax on 12/31/2009keep in mind, it depends on what you want to accomplishif all you are doing is tracking development and potential it is easy - really just record keeping - I do it without even a spreadsheet, just copy the ratings, color code them for potential and adjust the colors as I get messages when kids max outif you want to evaluate players its a bunch harder - some spreadsheets purport to do that

i used to keep this info, i think you could get off easier using print screens. during recruiting if you put everybody on your compare list it will give you everything, potential, gpa, etc.

then if you print screen on your team start and end of the season, i think you can track just about anything from that
12/31/2009 12:58 PM
pgafitch11
Posts: 0 (0)
Pro
16 1
Prospect
Would anyone be willing to send me a blank spreadsheet so i could put my information in? Just wondering?
1/1/2010 3:31 PM
cornfused
Posts: 1492 (0)
Hall of Famer
2 235 11
Prospect
Quote: Originally posted by pgafitch11 on 1/01/2010Would anyone be willing to send me a blank spreadsheet so i could put my information in? Just wondering?
Get Microsoft Excel, click "open new."
1/1/2010 6:17 PM
krw14
Posts: 2 (0)
Hall of Famer
18 27
Prospect
If anyone has a helpful spreadsheet, would you mind sharing it with me? I'm a new coach and would really appreciate the help.

Thanks.
1/16/2010 5:01 PM
bfiorina
Posts: 2 (0)
Hall of Famer
10 59 1
Prospect
Hi all,

New coach here and was curious is a helpful spreadsheet exists for game planning and following player progress? If so, can I get a copy?
5/27/2010 10:34 AM
oldave
Posts: 1162 (0)
Hall of Famer
3 302 12
Pro
Quote: Originally Posted By worthy14sure on 12/31/2009
I have this spreadsheet and can send it to anyone interested....I am not sure how to use it 100% but I am learning a little each year. Had it a few seasons.

Site mail me an e-mail address.

5/27/2010 11:36 AM
hughesjr
Posts: 3175 (0)
Hall of Famer
492 154 8 2
Prospect
I have 3 spreadsheets you can use if you like.  One is for Recruiting and two are team worksheets.The recruiting worksheet and one of the team worksheets are for OpenOffice.org's spreadsheet called Calc.  These files are named stillman.ods and RecruitHD_Allen_S42.ods.  There are also Docs to explain usage of these 2 sheets named RecruitingSheet and TeamWorksheetDirections.The other worksheet (one version for Excel 2007 and another version for Excel 2003 and earlier) is based on an orginal spreadsheet by Andy Berman (bermanap).  Andy has given permission for me to redistribute this modified worksheet, so thanks go to him.  Files are named HD-TeamMatchup-2007xlsm.zip and HD-TeamMatchup-2003xls.zip and the documentation is named TeamMatchup.doc.All files are available here 
5/27/2010 11:36 AM
12 Next ▸
Spreadsheet Help 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.