Team Rosters in Excel Format!

[Sonny]

http://www.collegelax.us/spreadsheet.php?team=5

replace the "5" with whatever team "id" you want and it'll kick out a
spreadsheet for you. The list of teams/team ID numbers is available by clicking TEAMS on the blue menu bar above.

Example:
http://www.collegelax.us/spreadsheet.php?team=5
is the Excel Spreadsheet Roster for Michigan State (team id # 5)

Example 2:
http://www.collegelax.us/spreadsheet.php?team=65
is the Excel Spreadsheet Roster for Florida (team id # 65)

All you do is put the URL (link) in your web broswer and it should begin to dowload that particular roster in Excel Format.

Thanks to Matt Holtz for coming up with this new feature. Very slick.

Will allow all of you producing tournament programs easy and quick access to roster information. (Note: All of the roster information comes from MCLA.us.)

[mholtz]

There is now a link at the bottom of each team's page to the excel version.

[Andy Sharp]

Three comments: 1) awesome! 2)could you add the state abbrev. to the home town? 3) any chance of including the stats?

[Has No Left]

Three comments: 1) awesome! 2)could you add the state abbrev. to the home town? 3) any chance of including the stats?

Crap! I just spent 20 mins. importing Utah's roster into Excel and now it's all here! Nice! - Agree with Andy, need state abbrev. - I've asked Daryll to add it several times.

[mholtz]

collegelax.us gets all it's info from mcla.us. I don't have the info from mcla.us so I can't really add it.

[Sonny]

Three comments: 1) awesome! 2)could you add the state abbrev. to the home town? 3) any chance of including the stats?

If it isn't in the MCLA.us database, we won't be able to add that to the rosters you view/access on CollegeLAX. Everything you see for the most part comes from MCLA.us, including scores, stats, schedules, and rosters.

[Andy Sharp]

The state data must be getting overlooked, because I know we enter that info when we submit our rosters.

Would love to have the stats in the Excel file by default. It's much easier to delete the info they don't need rather than trying to compile data from multiple sources.

When I create our gameday rosters I have been copying the stats from the mcla.us team web page, then copying the hometown/hs data from the printer-friendly link and then having to re-sort the columns because one is alphabetical, the other numeric, then taking to data to notepad to remove the extra spaces before copying it back to Excel for the final formatting.

Thanks for taking the time to save me time!

[Has No Left]

Three comments: 1) awesome! 2)could you add the state abbrev. to the home town? 3) any chance of including the stats?

If it isn't in the MCLA.us database, we won't be able to add that to the rosters you view/access on CollegeLAX. Everything you see for the most part comes from MCLA.us, including scores, stats, schedules, and rosters.

The state abbrev. for every player are in the www.mcla.us database; they just need to be added to the data table. It's a Daryl issue.

[DWF]

Fellas:

If you want something done, complaining about it on a Forum will resolve nothing. I was not aware that this was an issue and just by accident saw this thread.

I've now added the State abbreviation. Simple as that. When you click on the Printer Friendly link the new page will have the State abbreviation.

However, please...next time come to the source, as I can't fix something if I don't know it is broken.

Also the fellow who said he has asked me numerous times to add the State abbreviation--if that is the case then I apologize. However I don't remember getting the email to do this and since it was about a five minute job I don't see why I wouldn't have done it.

If there is anything else I can do to make your lives easier then PLEASE send me an email so I can look at it. If the changes you want are too substantive then it must go through the MCLA Executive but I know, they too, want me to make the site the most practical and easy to use as I can make it.

Thanks all,

Daryl
www.mcla.us web administrator