User Pass
Home Sign Up Contact Log In
Forum > Pee Wee Leagues > GM's and Owners, See all your team builds on one page
LordEvil
offline
Link
 
Been asked for this instead of the full day by day feature so this one is pretty simple

1) Download one of the programs (Must have Excel installed)

Excel Program (2007 +) http://www.nflfever2.com/PeeWeePro/AllTeamBuilds.xlsm
Older Excel versions (2003 or lower) http://www.nflfever2.com/PeeWeePro/AllTeamBuilds.xls
Download it and save it to your hard drive. Then close it. Open it up from your hard drive and accept its a macro enabled workbook

2) Must use Firefox, Install this script
http://userscripts.org/scripts/show/50520

3) Step 3
Go to rosters (Your roster) and click the button that says "EXPORT ROSTER"
Wait a few seconds , about 10-20 seconds
Scroll to bottom of page and you will see a text box full of text, starts with QB with his name etc, HIGHLIGHT the entire area either by right clicking and selecting all and then select COPY

Step 4
Go to your New workbook and in the Main Section at the very top you will see the default QB Mozz Arella, in cell A4 Right click and select PASTE
It will look weird at first so next step

Step 5
Click ORGANIZE
Then go back to Cell A4 and right click and paste again. It will all look nice and neat

Step 6
At the bottom click the tab that says GMs (Its red)
Top right corner you will see a button that says "Copy from Main"

Click that and your entire builds will be shows in a nice neat table with the attributes so you can see who is stronger, faster, has more catching, has low vision etc.

* Notes: If a player has his build closed you wont see his attributes
* The numbers on the FAR right in blue, show you how many attribute points total each player has. This will show you who has spent sps in the early season and who is the strongest best trained player later in the season.
* IF you do NOT see a (+4) or a (+10) or late season (+8) or (+14) this means they do not have EQ on
(+4) is basic EQ
(+10) means they have 4 Basic and 6 Custon EQ
(+8) or (+14) means after level 8 they have basic both sets or custom and both sets
Also its helpful for when players reach level 8 they tend to forget to add the 2nd set, thsi will help you find them much quicker
* It will also show you very quickly, who has custom and who doesn't
* Total time to do this after initial set up is about 20-30 seconds tops.
Edited by LordEvil on Feb 5, 2010 16:42:56
Edited by LordEvil on Feb 5, 2010 16:38:05
Edited by LordEvil on Feb 5, 2010 16:37:51
 
Gerr
offline
Link
 
I got an error message giving me the option to let it upload to the web or not. Are there macros in this set to upload the info into a website?
 
LordEvil
offline
Link
 
Its has macros, it copies the selected area on the main page and puts them on teh GM page. You have to download the program to your computer so you can allow macros enabled. I'm not sure if or how I can add it as a web page for people without excel. Is that even possible to do it from the web? I have seen pages like that before that were calculated on the web.

* Edit, I think I understand your question better, no there is no uploading, only downloadinging. I'll try it from my laptop.
Edited by LordEvil on Feb 5, 2010 16:58:04
 
Kaerey
offline
Link
 
In case anyone was wondering the script in Step 2 does not work with Google Chrome Extensions
Edited by Kaerey on Feb 5, 2010 17:41:04
 
LordEvil
offline
Link
 
Does it work nicely for you?
 
lilpro
offline
Link
 
LE, I have used this since you posted it. I added it to a couple of sheets I was using and it is perfect. I went from setting up ST in close to 2 hours to being able to put it all together in just under an hour. Since I do over a dozen ST and 3 D's, you have been a lifesaver!

Thanks!
 
stwcjj
offline
Link
 
Nice job mate
 


You are not logged in. Please log in if you want to post a reply.