Rookie Training Camp Spread Sheet (535 views)

[eric]

I have devised another Microsoft Excel sheet that I think will help more with the rookie TC post each year. The stumbling block every year is getting the pre-TC grades in, so I figured why not remove that part of the sheet entirely, let the GM do that and the names manually since they pretty much have to anyway, and go from there.

1. Where it says "year" in Sheet2 cell A1, put the current (sim) year.
2. Enter the name and pre-TC grades of every player in the draft.
3. Activate macro "Step1". This pulls the post-TC team, age, weight, height, and grades of every player.
4. Wait about five minutes.
5. Activate macro "Step2". This sorts all the data from the previous macro.
6. Wait about three minutes.
7. Copy Sheet2 column U to a post on the page.

As before, all the colors and +/- are done! All you need do is add commentary. When in doubt, do not type anything unless it's within a black border.

I am leaving the old sheet and instructions also in this post in case anyone in the future decides to take a crack at automating the pre-TC, but it's really a hassle so I encourage people to just use V2 of the sheet instead.

.

I have devised a Microsoft Excel sheet that I think will help with the rookie TC post each year. Here's how it works.

1. Where it says "year", put the current (sim) year.
2. In column A of Sheet2, paste from the draft thread that gbg makes.
3. Activate macro "Step1"
4. Wait about five minutes, more or less depending on the power of your machine.
5. Activate macro "Step2"
6. Wait about three minutes.
7. If any name has "FIX THIS NAME" pointing to it, fix that name. This is usually because the relevant name is three words long.
8. Activate macro "Step3"
9. Copy the AW column into a post on these boards.
10. If a team name exists next to any entry in AW, it means you need to change the team name in that entry. Do not try and do this in Excel.
11. That's it!

All the grades and +/- and colors are done. With so much time and energy saved on getting/typing that, you can spend plenty of time making hilarious comments! The sheet works in Excel 2007 through 2013. I don't have any other versions of Excel and so can't test them there. For those of you who haven't used macros before, you won't be able to use Excel (for this or any other sheet) while the macro is running, and for Step1 especially it will look like nothing is happening at first except for a faint flickering. This is normal.

Let me know if you run across any issues!

Attachments:

RookieTC.xlsm (594.96 KB)

RookieTC V2.xlsm (108.51 KB)

[Bankz]

what?

[Souper Troopers]

Jun 24, 2016 19:09:09 GMT -6 Bankz said:

what?

it's a macro you run that automatically does the rookie TC summary (minus the commentary) for you.

[20s Navidad]

Thanks eric

[MistleTacoe]

Thanks for the work Eric

[Deleted]

Lets see if this macro actually works

[eric]

There's something very important I forgot to tell you. On Sheet2 in column A you need to paste in the draft post that gbg makes, and before that you need to delete everything from columns B through L. Don't delete the columns themselves, just the contents.

[Lazy Pete]

Now that we've got robots that can do the job of a human, it's about time we start cutting wages

[FectaDEEZ]

eric

I dont know how I keep screwing this up, but I dont do anything with sheet 1 correct ?

[eric]

Nov 28, 2016 16:25:58 GMT -6 FectaDEEZ said:

eric

I dont know how I keep screwing this up, but I dont do anything with sheet 1 correct ?

the macro "step1" will move to sheet1 and do stuff, then you activate macro "step2" while in sheet1, but you never need to type anything manually in sheet1

usually the problem is that the formatting in the draft post has changed, and that is the problem this year. use this instead, and yes i know it looks exactly the same but just trust me:

1. Denver Nuggets - Connie Hawkins SF 6'8'' 210 20 B B- C B- B- A
2. Philadelphia 76ers - John Havlicek SG 6'5'' 203 22 B- B C+ B C+ B
3. Golden State Warriors - Jerry Lucas PF 6'8'' 230 22 B C C- B A- A
4. Minnesota Timberwolves - Walt Bellamy C 6'11'' 225 22 B+ C- D+ B A- B
5. Orlando Magic - Willis Reed C 6'9'' 235 21 B C D+ B- B+ B
6. Milwaukee Bucks - Zelmo Beatty C 6'10'' 225 23 B C B B- B B
7. Charlotte Hornets - Andy Phillip PG 6'2'' 195 23 C+ B- B B- C B
8. Atlanta Hawks - Biff Bridges PF 6'8'' 238 22 B- D+ D+ B- B A
9. Chicago Bulls (from Pacers) - Kevin Loughery PG 6'3'' 190 22 B- C+ B- C+ C- B
10. Kansas City Kings - Terry Dischenger SG 6'7'' 189 22 B B- C C+ C+ B
11. Los Angeles Clippers - Chet Walker SF 6'6'' 212 22 B C+ C- B- C+ A
12. Utah Jazz - Tom Meschery SF 23 6'7'' 215 B- B- C C+ B- B
13. Miami Heat - Dave DeBusschere PF 22 6'7'' 220 B C C- B- B B
14. Chicago Bulls - Don Nelson SF 23 6'6'' 210 B- B- C C+ C A
15. Golden State Warriors - Dick McGuire PG 6'0'' 180 22 C+ B- B C+ C- A
16. Vancouver Grizzlies - Paul Hogue C 6'10'' 240 22 B- D- D- B- B- A
17. Philadelphia 76ers (from Suns) - Norman Majors SF 6'6'' 190 20 B- B- B- B- B- D
18. Chicago Bulls (from Bullets) - Reggie Harding C 7'0'' 249 20 C+ C+ B C+ C+ A
19. New Jersey Nets (from Lakers) - Ron Horn SF 6'7'' 220 23 C+ C+ C+ B+ C+ B
20. Oklahoma City Thunder - Thor Likens C 7'0'' 277 22 B+ D+ C- C+ B- B
21. Chicago Bulls (from Raptors) - Rex Tippitt PG 6'6'' 207 21 C+ C+ C+ B- C A
22. Indiana Pacers (from Rockets) - Larry Siegfried SG 6'3'' 190 22 C+ B- C B- C B
23. Atlanta Hawks (from Bobcats) - Bill McGill C 6'9'' 225 23 C+ C C- B- B- A
24. Miami Heat (from Spurs) - Dylan Wooden C 6'11'' 296 20 B+ C- D+ C+ C+ B
25. New Jersey Nets (from Cavs) - Wayne Hightower PF 6'8'' 233 22 C+ D+ F+ B B A
26. Miami Heat (from Knicks) - Tony Sidoti PG 6'2'' 185 22 C+ B- B C+ C- B
27. Indiana Pacers (from Nets) - Mel Nowell PG 6'2'' 170 23 B C C C+ C A
28. Portland Trailblazers - Cleveland Buckner PF 6'9'' 225 23 B- D+ D B+ B D
29. Los Angeles Clippers (from Celtics) - Cornell Green PG 6'4'' 205 21 B- C+ A- B- D+ C

Round 2

1. Toronto Raptors (from 76ers) - Bevo Nordmann C 6'10'' 225 22 B+ F+ C- B- B- C
2. Minnesota Timberwolves - Al Butler PG 6'2" 175 23 B- B- B- B- D+ C
3. Cleveland Cavaliers (from Warriors) - Ted Luckenbill PF 6'10 220 22 B- C+ D+ C+ B- B
4. Cleveland Cavaliers (from Magic) - Doug Moe SG 6'5 215 23 B- B C C- C B
5. Milwaukee Bucks - Johnny Egan PG 5'11'' 180 22 C+ C+ A- A- D C
6. Charlotte Hornets - Wally Roundsville SG 6'4'' 180 21 C- A- C- A- C- C
7. Atlanta Hawks - Chico Vaughn PG 6'2'' 190 22 C+ C- B+ B+ C+ B
8. Denver Nuggets - Josue Huh PG 6'4'' 206 20 C B C- C C- C
9. Indiana Pacers - Don Kojis SF 6'6'' 215 22 B- C C- B- B- B
10. Kansas City Kings - Alexis McCracken PG 6'1'' 174 22 C C+ C+ C+ C B
11. Utah Jazz - Ben Warley SF 6'6'' 200 24 C+ C+ C+ C+ C+ A
12. Los Angeles Clippers - Rocky Radejevic C 6'10'' 279 20 C D C C+ C+ C
13. Miami Heat - Conner Benshoof SG 6'8'' 223 23 C C C C C A
14. Chicago Bulls - Ray Scott PF 6'9'' 215 23 C B- D B C B
15. Seattle SuperSonics - Hubie White SF 6'9'' 225 22 C+ C- B C B+ B
16. Vancouver Grizzlies - Russell Panariello SG 6'5'' 201 18 C C+ C C+ C B
17. Phoenix Suns - Charlie Hardnett C 7'0'' 225 24 B C+ D+ C+ C+ B
18. Washington Bullets - Frank Fulks PG 6'0' 180 22 C B+ B B C- C
19. Toronto Raptors - Lindbergh Moody SG 6'6'' 213 22 C+ B+ C B C F
20. Los Angeles Lakers - Ivan Biasone SF 6'8'' 223 18 C+ C C+ C C- B
21. Oklahoma City Thunder - Jonah Lue SG 6'4'' 214 20 C B- C B- D+ B
22. Houston Rockets - Gary Phillips PG 6'3'' 189 22 C+ B B+ C- D+ B
23. San Antonio Spurs (from Bobcats) - Damon Yong PF 6'7'' 217 21 C C- C- C B- A
24. New York Knicks - Dan Woolpert SF 6'7'' 226 22 B+ B C C+ C- D
25. Cleveland Cavaliers - Gene Wiley C 6'10'' 227 22 B D D B- B C
26. San Antonio Spurs - Donnie Butcher PG 6'2'' 200 23 C- B+ B+ A- D C
27. New Jersey Nets - Damian Lewis SF 6'7'' 214 22 C C+ C C+ C- D
28. Portland Trailblazers - Cris Schayes SG 6'7'' 211 20 C+ B+ C+ C+ D+ C
29. Boston Celtics - Tanner Crotty SG 6'6'' 184 20 C+ B C C+ C- C

[eric]

edited the OP, reproducing the instructions here too though. V2 is the new sheet.

I have devised another Microsoft Excel sheet that I think will help more with the rookie TC post each year. The stumbling block every year is getting the pre-TC grades in, so I figured why not remove that part of the sheet entirely, let the GM do that and the names manually since they pretty much have to anyway, and go from there.

1. Where it says "year" in Sheet2 cell A1, put the current (sim) year.
2. Enter the name and pre-TC grades of every player in the draft.
3. Activate macro "Step1". This pulls the post-TC team, age, weight, height, and grades of every player.
4. Wait about five minutes.
5. Activate macro "Step2". This sorts all the data from the previous macro.
6. Wait about three minutes.
7. Copy Sheet2 column U to a post on the page.

As before, all the colors and +/- are done! All you need do is add commentary. When in doubt, do not type anything unless it's within a black border.

I am leaving the old sheet and instructions also in this post in case anyone in the future decides to take a crack at automating the pre-TC, but it's really a hassle so I encourage people to just use V2 of the sheet instead.

[SPL]

Thanks Eric, if I would have waited I could have saved myself some time. Thanks for doing this work for the future bud.

[eric]

Dec 20, 2016 15:01:03 GMT -6 SPL said:

Thanks Eric, if I would have waited I could have saved myself some time. Thanks for doing this work for the future bud.

yeah i felt bad when you posted you were done like five minutes before i finished. next year hopefully it'll work out though

[SPL]

Eric, The new spreedsheet, either I did something wrong or does not work. I will just do TC the way I did it last season.

[20s Navidad]

eric no longer supports this product.

[Lazy Pete]

Rookie TC was meant to be done analog

[eric]

Jan 19, 2017 10:07:04 GMT -6 SPL said:

Eric, The new spreedsheet, either I did something wrong or does not work. I will just do TC the way I did it last season.

to be clear, if you just run the macros first it would appear that nothing has happened. you have to type in the names and starting grades in the outlined sections, and the sheet will automatically pull the current grades and format it. so when i type markelle fultz and his grades, the sheet spits out:

1. Raptors - Markelle Fultz PG 6'5'' 190 19 B C+ B- B- C A
1. Raptors - Markelle Fultz PG 6'5'' 190 19 B- B- B- B C A +1

[SPL]

Jan 19, 2017 11:45:19 GMT -6 eric said:

Jan 19, 2017 10:07:04 GMT -6 SPL said:

Eric, The new spreedsheet, either I did something wrong or does not work. I will just do TC the way I did it last season.

to be clear, if you just run the macros first it would appear that nothing has happened. you have to type in the names and starting grades in the outlined sections, and the sheet will automatically pull the current grades and format it. so when i type markelle fultz and his grades, the sheet spits out:

1. Raptors - Markelle Fultz PG 6'5'' 190 19 B C+ B- B- C A
1. Raptors - Markelle Fultz PG 6'5'' 190 19 B- B- B- B C A +1

I did that Eric and I got some sort of error that popped up when I ran macro one. I copied and pasted the individual names, entered all the grades into the grade section and after that I ran marco 1 and it ran than after some time it gave me an error of some kind. I will just do it the old fashion way like I did last time when I get free time today.