glbscripts.myfreeforum.org

ddcunderground · Developer Joined: 25 Jun 2008 Posts: 205

This spreadsheet will now pull a team's entire roster and then pull player stats. Note if you can not see player builds due to them being closed to your account it will fill with zeros. So this is a good tool to check for opponents open builds quickly as well as track your own teams builds. quickly. Also for tracking your team. I am currently adding a function to copy to both current row and goal row whereas the first time you run it on your team (Gm'd or Owned) then you can run in the future and see where players are putting their SP's. Instructions are on the spreadsheet itself.

I will come back and post the spreadsheet once I add the add to goals functionality.

micha47 · Joined: 27 Jul 2008 Posts: 3

This sounds very interesting ... I'm looking forward for the spreadsheet Smile

ddcunderground · Developer Joined: 25 Jun 2008 Posts: 205

ok so attached is the spreadsheet. both 2007 and 2003. 2003 is not tested.
Open workbook after you have logged into GLB paste link to desired teams roster page into cell A1 run macro BuildStats to import information

Click to download file

sbuck143 · Joined: 28 Jun 2008 Posts: 17

2003 version seems to work for me, fwiw.

cheech1223 · Joined: 09 Jul 2008 Posts: 22

not sure why, i have the 2007 version and its not working. the macros runs, but both sheets remain completely blank.

I have tried keeping the hyperlink's display name as the url and as the team name, still nothing.

ddcunderground · Developer Joined: 25 Jun 2008 Posts: 205

make sure you are linking to the roster page if it is looking anywhere else it won't work.

Cohen Domination · Joined: 01 Aug 2008 Posts: 13

How do you run a macro in excel 2007?

ddcunderground · Developer Joined: 25 Jun 2008 Posts: 205

it is under the developer tab

Cohen Domination · Joined: 01 Aug 2008 Posts: 13

Says no link in cell a1, even though it is there, I am looged in and everything.

ddcunderground · Developer Joined: 25 Jun 2008 Posts: 205

make sure link is in cell a1 on the first sheet of the workbook. and make sure that if you right click on the cell and click edit hyprlink that the hyperlink is correct if it says add hyperlink then select that and add the link to the resulting window for the roster page you are looking for.