Excel Spreadsheet that pulls player info

ddcunderground · Excel Spreadsheet that pulls player info

Ok so last season I posted a spreadsheet that I used at the beginning of the season to set goals for my players attributes. I did this because I have WAY too many players and often I forget what direction I am taking these players in. So on this spreadsheet I have a row for each players stats and the row below is his goal for the season. Well now that I have even more players it was becoming EXTREMELY tedious to copy and paste each players info throughout the season. So I have now modified the spreadsheet to where it will auto update the player info and highlight attributes according to the goals you set. For instance, if you set a goal of 25 for a players speed and they are currently 15 their stat of 15 will change to red on the spreadsheet. Once they are within 1.5 points of their goal it will change to yellow, and once they reach or exceed their goal it will then change to green.

Ok so here is how to set it up for your players. 1. DON'T DELETE EITHER of the 2 sheet you can rename them if you choose but we need both sheets. 2. Open up IE or Firefox and login to GLB and go to your home page. 3. Copy the player link from your homepage for each of the players and paste them into the spreadsheet. 4. The players must start on row 2 and must only be on even rows. (the macro will adjust for your amount of players as long as you follow the previously mentioned step). 5. Run the Macro named "Sheet2.BuildStats". 6. Once it completes it will tell you Import completed. 7. Set your players goals on the odd numbered rows directly below where the macro pulled in their data.

Anytime you wish to import there stats again just follow the steps above it will not overwrite your goals so feel free to use it however often you see fit.

****NOTE***** This will work with any player that you can see there stats (great way for gms and owners to keep an eye on their teams' builds)*******

Attached is the Excel 2007 version the Excel 2003 version has not been tested.

Click to download file

numb

Hi man looks very good your work but i'm using 2003 and only works if i open IE. If i got open firefox doesn't work whY?

And colors doesn't work too.

Catullus 16

this is awesome.

although, i tried importing it into zoho and i couldn't get the macros to fly.

ddcunderground

my guess is that the macros are making calls to excel specific variables that may not be available with zoho

Catullus 16

ddcunderground

SabreEleven

Where do i paste my players page link?

SabreEleven

Never Mind, figured it out by myself Smile

SabreEleven

The only thing I don't like is the yellow font on the white background.

ddcunderground

you can chose whatever font color you want by editing the vb just search for the yellow code yellow is the value .ColorIndex = 6 you can change that to meet your needs the link for the colorindex guide is http://msdn.microsoft.com/en-us/library/cc296089.aspx

SabreEleven

Thanks.

Now the problem I'm having is that it work the first day I downloaded and I went to update it the next day and all the information blocks that I pull from GLB are blank....I keep trying it but it won't work....:scratch:

eazye187

I am having the same problem. I replace the player's name and link with my own, and it runs the macro and nothing shows up in the stats cells.

E

ddcunderground

The steps I take to build the sheet are as follows open up IE login to GLB at the homepage copy the Player name paste into excel on even rows. Set my goals on odd rows then run the macro. The one gotcha is you must be actively logged into GLB WITH INTERNET EXPLORER you cannot use firefox it must be internet explorer. I have seen where it won't pull back anything if you are not logged in to internet explorer.

SabreEleven

Yes, I 'm logged into IE when I do this and it still doesnt' work...

ddcunderground

can you take a screen shot of it for me The first pageof the spreadsheet and how you have it setup

The Angry Beavers · Same Deal

I can't get it to work either....same problem.

When i go to run the macro, It pops up the message saying I need to be logged in to GLB with IE , and I am. (If I click a player's link, it goes to his page).

It then flashes thru each stat, as if updating, but displays nothing.

I tried both the 2003 and 2007 version, though the 2007 version is a compressed file and I can't seem to find the basic excel file to double click....

Please help...would love to use this program!!!!

The Angry Beavers · Follow up

As a quick follow up, I'm also getting an error message when trying to run the macro.

"400" comes up. I've done some research and found it to mean:

That error referes to "Form already displayed; can't show modally (version 97)"

Any thoughts? If that's what it mean, I'm assuming its in the code????

SabreEleven

Here is proof I was doing it right

and this is right after running the macro. Notice that the blocks are blank.

ddcunderground

ok at the top of your screen it show data connection disabled click on the options button and select Enable Data Connections and it will work like a charm. I didn't doubt you at all but was trying to see a screen shot so we could resolve your issue. Thank you for your patience.

ddcunderground

Angry Beaver:

Check the same issue above

The 400 error message that you are seeing will happen if GLB doesn't return the page or returns and incorrect page. I was seeing this if I was not logged in which I believe you are or if my link was incorrect.

The 400 itself is getting passed from Internet Explorer and it is a page cannot be found error.

Let me know if the previous post helped.

The Angry Beavers · ok...

I tried that, but it didn't work.

Also, as a side note....I'm using excel 2002....any thoughts if that's the issue?

Right now, 2002 is not doing the flashing thing, where as in 2007, it would, but just not update anything...even with the data enabled.

PC is 2002
Laptop is 2007, to clarify.

Also....for the 2007....its a zip file. After unzipping, how do I access the main file? What should I be clicking on?

SabreEleven

I tried it to and it still didn't work....

ckshowtime

Is there a limit on how many players you can have on the sheet when running the macro? I keep getting a "subscript out of range" message, and then this last time I got "out of memory".

I just tried running it with only 6 players, same as there are listed when you download it. I am now getting the 400 error and the numbers are all screwy.

eazye187

ddcunderground

I am running out of ideas is Vista the common link on everyones' issue?

ck showtime yours is that those players don't have their builds open. this spreadsheet assumes that the players have open builds

eazye187

SabreEleven

I'm running Vista and still can't get it to work.

ddcunderground

I don't think it will function with Vista

The problem is with normal GLB scripts there is nothing to troubleshoot outside the script and the page. We have to worry about OS, Excel, IE and GLB that is why it gets tricky. The only common denominator seems to be Vista.

ken-in-rockwall

It works with Vista. Interesting is that it won't work with just Firefox and signed on to GLB, but if you log on to GLB via IE it works. Still give an error, but populates the info.

Catullus 16

donroger · "400" Errors in 2003

From MSFT VB Help:
"Remarks
You cannot define more than three conditional formats for a range. Use the Modify method to modify an existing conditional format, or use the Delete method to delete an existing format before adding a new one."

The code attempts to add four conditional formats. I just went in and commented out one that I considered less useful and it worked without the error.

You can also add a button to make it easier to run the script.

Gazeruth

Are the conditional formats only a problem on Office 2003? I've not seen that error and I'm running 2007..

I've also added a button to run the update (get new attributes), and made an extra sheet with previous and current attributes, and the difference between them. I've also got another macro on that sheet to update the values..

If anyone knows where I can upload it, I can distribute it.. although I may tweak it a little more first Smile

kfd277

I don't know where you can upload it but does it work with Bort's changes to the UI? My sheet does not work anymore.

Excel Spreadsheet that pulls player info

Same Deal

Follow up

ok...

"400" Errors in 2003