Using Google Spreadsheets for Stats

[The Mule]

Here is a link to a Google spreadsheet I created for keeping the East FB stats : FSL S3 FB

Updating the statistics is quite easy. For example, to add the week 3 stats for Tom Rayder, you would simply click on the T_Rayder worksheet, add a row (at row 4) and enter his week 3 stats in that row. The totals row at the top of the Tom Rayder worksheet should update automatically as you enter the new stats. Additionally, the stats in the Totals worksheet will update automatically. Then to post the stats, you can simply select all the cells in the Totals worksheet, copy them with Ctrl-C, paste them into the post editor with Ctrl-V, and wrap them with the pre /pre tags, for the following result:

Player		Team	Games	Att	Yards	RuYPG	Rec	Yards	ReYPG	YAC	TD	Fumb	Drop	Panc
J. Brunxa	CHI	2	3	11	5.5	2	6	3.0	2	0	0	0	2
T. Rayder	OHT	2	4	9	4.5	1	1	0.5	2	0	0	0	2
R. Sanders	LOU	1	1	0	0.0	0	0	0.0	0	0	0	0	1
W. Smith	ORL	2	3	6	3.0	0	0	0.0	0	0	0	0	3

I think the FB spreadsheet could be copied and changed to easily accommodate the stats of other positions as well. Also, if you provide a link to the Google spreadsheet, the stats can easily be checked by others.

-mule

[Peyton Carter]

I have an excel spreadsheet that's virtually the same thing.

I just put in the stats each week, run a macro, and it spits out a pre-formatted table.

[captobvious]

I'm using excel as well, but I'm not as advanced as Peyton. I just type the values at the bottom of my spreadsheet into the spaces between the [td] tags.

[Peyton Carter]

captobvious said:

I'm not as advanced as Peyton.

Very few are. ;D

[The Mule]

Peyton can you get us that macro somehow?

[watchthis]

bump

[Peyton Carter]

As of right now, the macro only works for my FB spreadsheet.

I can modifiy it for other positions, but it'll take some time to re-write it.

[The Mule]

It would be great if it could take a generic totals table (like the one in my spreadsheet) and just spit it out in the board table format.

[captobvious]

Peyton: If you could just email me what you have, then I can play with it and figure out what I need to do with it for my own stats from there. I just need to see an idea of how it's done.

[Peyton Carter]

themule said:

It would be great if it could take a generic totals table (like the one in my spreadsheet) and just spit it out in the board table format.

That shouldn't be too hard.
I'll work on it.

[Peyton Carter]

OK.
Here's a spreadsheet converter type thing.
Basically, you enter the data into the Spreadsheet part. Then press the button in the "Tools" part, and it will convert your spreadsheet into board format. Then, select the rows (you only need to select them in column A), copy, and paste into the board.

Some things to remember:
1. Don't delete or add any rows or it probably won't work. (actually, you can, but you have to make sure there are still numbers in A300 and A301)
2. Make sure there are no blank rows or columns in between non-blank rows and columns.
3. The chart has to start at A1. Don't add a title or anything, or you'll just get one column.


OK, I think that's it. Sorry about all the rules. They're kind of necessary for it to work correctly.

Here's the link.

webpages.charter.net/igwebuike/generic%20chart%20macro.xls