This is an owners or GMs best friend to track player training and if they are training or spending skill points and it will help you get a quick guide on all your teams players builds in a matter of a few minutes. It will also show you where players are spending their points by checking the day tabs once a player has an increase in attribute score. Example is if on day 5 a player has 185 points total and on day 6 he has 190 points, you can look at day 5 tab compared to day 6 tab and see where those 5 points went.
* Must have Excel
* Must use mozilla firefox
* Must download and install this greasemonkey script http://userscripts.org/scripts/show/50520
* Once installed test it by going to your team ROSTER page and you should have a button that looks like so:
http://www.nflfever2.com/scouting/public/buildsbutton.jpg
After you click that button, wait a few seconds and you will see the words finished, then scroll to the bottom of the page and you should see something like this:
http://www.nflfever2.com/scouting/public/buildsbuttonshow.jpg
* You need to highlight all and select copy
* Download this excel macro workbook (ALLOW MACROS) Save the book in your own documents on your computer so you can use it whenever you like, you can also rename it
http://www.nflfever2.com/scouting/TeamTraining3.0.xlsm (newest version) Days 45-Day 40
http://www.nflfever2.com/scouting/public/publicBuilds2.0.xlsm (Old version) Days -2 through 40
* Open the book and in the MAIN tab at the bottom (Red tab) make sure your on this page. In cell A4 paste the contents from your roster page you just copied. As shown here
http://www.nflfever2.com/scouting/public/builds1.jpg
* After you paste in A4 it will look like so:
http://www.nflfever2.com/scouting/public/builds2.jpg
Click on the ORGANIZE button and it will look like this (Unorganized):
http://www.nflfever2.com/scouting/public/builds3.jpg
* Now paste once again in cell A4 and it should look perfect. This will allow you took compare your players by position with what points they have in each attribute. It's a quick way to look at your entire team in a few minutes.
http://www.nflfever2.com/scouting/public/builds5.jpg
Forgot this step
Click on MIAN tab. Highlight cells A4 through I 58 and copy them, go to Track players points tab and paste in A4 You should then see your players show up in this area.
* Now you will want to track their total attribute points each day to make sure they are training or spending their level up points or to even see if they are spending their 15 skill points. The way to do this is simple. At the bottom of the page , each tab is marked dayn2 to day 40. Dayn2 is day negative 2 and dayn1 is day negative 1 and so on. On the main tab, click on the HIGHLIGHT TAB. Then right click and select copy, click on the tab at the bottom for whatever day it is. Then paste the contents in cell A1
http://www.nflfever2.com/scouting/public/builds6.jpg
* Once done click on the tab that says Track player skill points. This will show you a daily total of how many points they have spent on their player.
http://www.nflfever2.com/scouting/public/builds7.jpg
If you run into any problems please feel free to post or pm me.
Couple of minor bugs
On the main tab far right in blue you should see a number, if you see a VALUE$! that means either a build is closed or mostly on kickers in the special attributes, make sure you put 0's in the last 5 or 6 spots. Kickers only have 3 special attributes and the rest have 10 I think it is so they are 7 short as wont give you a propper value.
* Must have Excel
* Must use mozilla firefox
* Must download and install this greasemonkey script http://userscripts.org/scripts/show/50520
* Once installed test it by going to your team ROSTER page and you should have a button that looks like so:
http://www.nflfever2.com/scouting/public/buildsbutton.jpg
After you click that button, wait a few seconds and you will see the words finished, then scroll to the bottom of the page and you should see something like this:
http://www.nflfever2.com/scouting/public/buildsbuttonshow.jpg
* You need to highlight all and select copy
* Download this excel macro workbook (ALLOW MACROS) Save the book in your own documents on your computer so you can use it whenever you like, you can also rename it
http://www.nflfever2.com/scouting/TeamTraining3.0.xlsm (newest version) Days 45-Day 40
http://www.nflfever2.com/scouting/public/publicBuilds2.0.xlsm (Old version) Days -2 through 40
* Open the book and in the MAIN tab at the bottom (Red tab) make sure your on this page. In cell A4 paste the contents from your roster page you just copied. As shown here
http://www.nflfever2.com/scouting/public/builds1.jpg
* After you paste in A4 it will look like so:
http://www.nflfever2.com/scouting/public/builds2.jpg
Click on the ORGANIZE button and it will look like this (Unorganized):
http://www.nflfever2.com/scouting/public/builds3.jpg
* Now paste once again in cell A4 and it should look perfect. This will allow you took compare your players by position with what points they have in each attribute. It's a quick way to look at your entire team in a few minutes.
http://www.nflfever2.com/scouting/public/builds5.jpg
Forgot this step
Click on MIAN tab. Highlight cells A4 through I 58 and copy them, go to Track players points tab and paste in A4 You should then see your players show up in this area.
* Now you will want to track their total attribute points each day to make sure they are training or spending their level up points or to even see if they are spending their 15 skill points. The way to do this is simple. At the bottom of the page , each tab is marked dayn2 to day 40. Dayn2 is day negative 2 and dayn1 is day negative 1 and so on. On the main tab, click on the HIGHLIGHT TAB. Then right click and select copy, click on the tab at the bottom for whatever day it is. Then paste the contents in cell A1
http://www.nflfever2.com/scouting/public/builds6.jpg
* Once done click on the tab that says Track player skill points. This will show you a daily total of how many points they have spent on their player.
http://www.nflfever2.com/scouting/public/builds7.jpg
If you run into any problems please feel free to post or pm me.
Couple of minor bugs
On the main tab far right in blue you should see a number, if you see a VALUE$! that means either a build is closed or mostly on kickers in the special attributes, make sure you put 0's in the last 5 or 6 spots. Kickers only have 3 special attributes and the rest have 10 I think it is so they are 7 short as wont give you a propper value.
Edited by LordEvil on Nov 28, 2009 17:09:21
Edited by LordEvil on Oct 11, 2009 16:20:39
Edited by LordEvil on Oct 11, 2009 13:53:46
Edited by LordEvil on Oct 11, 2009 12:29:06
Edited by LordEvil on Oct 11, 2009 10:56:44