Archive for glbscripts.myfreeforum.org Forum dedicated to Greasemonkey Scripts made for Goal Line Blitz online game.
 



       glbscripts.myfreeforum.org Forum Index -> Original Scripts
victoruno

Excel Roster and Team Tracker

First Post for me.

I use this to track my team, and then to track other teams in my League.

If you have any questions, please email me or PM me.


First Worksheet in there has Instructions on how to use it.

http://www.victoruno.com   and follow GLB Tracker links.

Just give me recommendations on how to improve and I will implement them.
ken-in-rockwall

Great looking sheet, but getting run-time error '1004': cannot insert colums because the last column (column IV) contains data.

Also, as it populates the sheet nothing is changing but the position,contract with incorrect data.

Team tracker didn't work either. Let me know if I can help troubleshoot as it is a great idea.

Using IE 7.0, Excel 2007.
victoruno

Send me your excel sheet with your info in it.... I will try to duplicate. Leave whatever error data is inside of it.
ken-in-rockwall

Email, with attachments sent.

thanks
reficuul

you have to be using IE or can you use Mozilla for this?  i downloaded IE, and I am trying to follow the instructions.  Whenever i hit the track roster button i get a runtime error.  No idea what that is or if i am even doing this right!

I love this idea though because i normally write all this crap down  =/
victoruno

Link Updated with New File that has Flushed out Roster Tracker Capabilities.

Keep emailing me at Hotmail or posting here. I respond within 24 hours and usually have a fix or update out in less than 12 hours.
King of life

If i press "Track roster" in the new file it says:
"Add to tracker?

There are AS players on roster, and only 0 players are in the Tracker.
Do you want to add the remaining to the Tracker?

Yes/No"

If i press yes it says: "run time error 13"

And if i press no it says "done", but nothing happened
glenn222

How can you make the team tracker update the other fields, like conference, league, etc.?
victoruno

I am working on that now. Just got busy at work, I expect something by the end of the week. When I upload it I will PM you here, or  you can subscribe to that project at savefile.com and it will email you when I upload it.
victoruno

Updated:

http://www.victoruno.com   and follow GLB Tracker links.


Now includes filling in League info for all 32 teams if there not in your team tracker, very quick way to analyze an entire league. to see who has the biggest stadium, largest roster, biggest salary, highest avg level.
arman8489

It keeps telling me that i dont have IE open. I dont know what im doing wrong.
victoruno

Do you have Internet Explorer oPen and are you logged into GLB?

I just uploaded a new copy I have, Scouting Numbers Reflect better.

http://www.victoruno.com   and follow GLB Tracker links.
arman8489

Yeah am logged into GLB on internet explorer, but keeps saying FAULT.
raiderSGA

Same here
victoruno

I am going out of town for a bit, away from internet, but once I get back i will contact you again.
deez11010

All links are dead, any updates or anywhere else its saved?
victoruno

Dead Links

Just checked them the other day.... but checked right now and it seems Savefile.com is having a bit of down time. I will post here in a few days when it is all better.  Or please keep checking and post back when it is up and running.
deez11010

Will do
Coach79

Try another File Storage site.
Coach79

ok, so I finally got it downloaded and now I am having issues....

It is saying that I dont' have access to players builds....
On a few of my players (I am the team owner) where it should have the player number it ways 1E+06....


That's it so far.....

Help?
victoruno

FIX and update to v.12

Alright, with the recent site changes in Season 7, the Stats were not updating properly. I have changed the script and it reflects the way the site is.


Let me know if there are further problems with the new site. Thanks again for the interest.  

The Columns displaying 1E+06, is a column width issue, I widened the column to accomodate the new 7 digit player ID's.

The Update is posted to
http://www.victoruno.com   and follow GLB Tracker links.

Any recommended suggestions or problems please contact me.
deez11010

Coach79 wrote:
ok, so I finally got it downloaded and now I am having issues....

It is saying that I dont' have access to players builds....
On a few of my players (I am the team owner) where it should have the player number it ways 1E+06....


That's it so far.....

Help?


I believe those are the inactive people. You have to manually put in their player ID numbers.
deez11010

Ok, so I'm having an issue with the team tracker tab. I put in my leagues url and hit track, it starts to do its thing, then it gives me an error.



Heres the description of the error...


http://i270.photobucket.com/album...apshots%20of%20errors/error13.jpg


And when I hit the debug button this is what it shows me....



http://i270.photobucket.com/album...Snapshots%20of%20errors/debug.jpg
victoruno

Outstanding Find....

Great job posting those screen shots....

I have uploaded the update to Savefile.com....


The Season 7 changes altered the information being taken into the Excel Document... so with those changes come changes in the Tracker.... There ya go. Give me a shout if there are more troubles.
deez11010

Ok, so its finding the league and teams, but when I click ok it instantly does the error 13 thing again....



League ID number in C1


http://i270.photobucket.com/album...ots%20of%20errors/Teamtracker.jpg



Then click track, it does its thing and finds the league...


http://i270.photobucket.com/album...ots%20of%20errors/Leaguefound.jpg


Click yes to add the teams....



http://i270.photobucket.com/album...shots%20of%20errors/sameerror.jpg



And instant error window, click on debug....



http://i270.photobucket.com/album...apshots%20of%20errors/debug-1.jpg




I'm sure I'm doing something to it, but thats what I get. It finds the players on my team just fine for the roster tracker.
deez11010

Jeez those take up a lot of room...

I'll crop out the unneeded background stuff next time I post a error pic in a forum I think.
Coach79

I keep getting the same error in the team tracker.
victoruno

alright, i have updated the file on savefile.com....


good catch, never tested that way before but once i did it was an easy fix....

also anyone looking for me ingame username: victoruno
deez11010

Ok, so I dont know what I did but I broke it. I cant do anything anymore. I cant track or anything. And when I try to re download it, when I click on the download button...nothing happens. Like I'm not clicking anything at all. I've checked my mouse click a bazillion times cus every time I try to hit the track button in the spread sheet, and when I try to click download from save file...nothing happens at all like the button isnt being pressed.


What did I do?

How do I fix that?
victoruno

send excel document

Alright, send me your excel document via email :    victoruno@hotmail.com

and I will take a look at it.

as far as not being able to download it from savefile.com..... that is your local settings so... unsure of how to proceed with that fault. ...  

-edit. Checked it out and Savefile had some trouble over the last few weeks.... New File is now at :  HERE... yippeee..

http://www.victoruno.com   and follow GLB Tracker links.
deez11010

Ok, fixed the posts, just left the links in instead of the entire pic.


As for the excel issue. I figured it out. I'm all good. It had nothing to do with this spreadsheet, it was all my excel files. I kinda ran a cleanup program that changed some registry keys and locked up excel....heh.

I'm all squared away now. Thanks  Razz
victoruno

http://www.victoruno.com   and follow GLB Tracker links.


Contains "Roster Tracker" for multiple Players. Ability to import entire team roster and display Str, Agi, Spd and the like.

"Team Tracker" for many teams. Ability to import entire League and display Roster Count - CPU's, Stadium Size, Salary Size and Avg Level.

"Scout" Looks back over last 4 games and displays Off and Def stats, also shows how Ranks stacks against each other such as Rank in League of Pass Off vs Rank in League of Pass Def.


This is to update to v.15 with changes for this season and updating Scout code.
kfd277

Tracker

My tracker doesn't work.  Is this happening for anyone else?
victoruno

Not Working since Season 7

You are right, GLB Tracker has not been working since the changes made to the site in Season 7.

I could not find code the worked around the problem, interest was diminishing for me in the game so I stopped updating or trying to find the fix.

GLB Tracker is defunct as of Season 7.
kfd277

I used it last season...a lot.
victoruno

Wow. That is great to hear. I know that when I left off there was a recurring problem that happened only on some computers, that I couldn't replicate here. I tried many different ways around it but could not get it right.

I am sorry it no longer works. Since My interest and time has wained for GLB i will not be renovating it unless I pick the game back up.

Thanks for using my program I urge you to try and revampt it.

       glbscripts.myfreeforum.org Forum Index -> Original Scripts
Page 1 of 1
Create your own free forum | Buy a domain to use with your forum