victoruno
|
Excel Roster and Team TrackerFirst 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 LinksJust 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.12Alright, 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 documentAlright, 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
|
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
|
TrackerMy tracker doesn't work. Is this happening for anyone else?
|
victoruno
|
Not Working since Season 7You 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.
|
|
|