Tuesday, February 26, 2008

School Sports Data - Brackets and all

School sports are fun - but they're also serious business for people who track results and keep stats. Using spreadsheets and publishing as part of the official web site is what the Pennsylvania Interscholastic Athletic Association has been doing. The sample below is a direct link to one sheet (one weight class) within one sport (wrestling) in one class (AA). The way they represented each weight class in a bracket style is worth a look... and, by the way, Congrats to Luke Frey - the Champion of the 103 lb. weight class ;)

Site:Pennsylvania Interscholastic Athletic Assoc.
Page/Post:District IV data
Spreadsheet:2008 Class AA Individual Wrestling Tournament
...make sure you click on a few sheets in there to get the full view of how they use this...

Football (NFL) Draft Data

The site called Football's Future is overflowing with data about the American Football draft (or mock draft results)- position-by-position, player-by-player, you name it. The forums are very active as well with users offering all sorts of interesting data if you happen to love American Football. The spreadsheet link below shows position-by-position data on bids and signed status for certain players.... in a mock draft, I assume.

Site:Football's Future - Forums
Page/Post:FFMD08 Scouting Dept Post Prospect Data
Spreadsheet:Position Bids Data (15 sheets)

Wednesday, February 20, 2008

Work Schedule Planning spreadsheet

If you've ever run any retail store, or any business which required full-time and part-time worker scheduling, you'll relate to this problem and solution. Flexibility in work schedules - which is par for the course with part-time workers - makes it very difficult not only to schedule people so that you have full coverage, but also to communicate the plans to everyone so they know when they are working. Well, Bayou Books has created a useful spreadsheet to show each person their hours of coverage.

Site:Bayou Books
Page/Post:Schedule for the week
Spreadsheet:Work Schedule Spreadsheet

Monday, February 18, 2008

Bicycling and spreadsheets meet in Seattle

I've posted a few examples of bicycle riders who have somehow utilized spreadsheets to track and share their rides. Here's another one I cam across that made me want to do the same myself. It's got a nice chart at the top which shows the pattern of ride length over time. This rider's log has become a permanent link on the right pane of his blog, entitled "my cycling log", which has two tabs, one for last year and one for this yar.

Site:Cycling in Seattle
Page/Post:Seattle to North Bend & Back (100 miles)
Spreadsheet:My Cycling Log: Rides 2008
(be sure to click on the "rides2007 tab too!)

Thursday, February 14, 2008

Personal Running Log ++

CDB's personal running log is on a spreadsheet. It really is a great way to track personal progress against goals. The ++ part is how he then used this data to generate cool little graphics called 'sparklines' for his blog using Joe Gregorio's sparkline generator. Nice work.

Site:CDB blog
Page/Post:Running Spark
Spreadsheet:Running Journal

Delegate data tastes good on a spreadsheet

Laurent Kretz posted useful data (which this blog cannot endorse as correct) showing US Delegates (yes, for the presidential election) by State, by Date, and with a summary. This is not the last example of such data presented in a spreadsheet this year, but this might give others some inspiration for more data analysis, maybe adding charts, etc.

Site:Laurent Kretz blog
Page/Post:1,312 Delegates to go
Spreadsheet:Delegates per US State, etc.

Spreadsheet of Memories

Imagine a timeline of your life's experiences in a spreadsheet... for better or worse, I *can* imagine that - as I can relate to almost anything in a spreadsheet, and I can relate to the author of Hyperwest.net in his perception that "the days, weeks and months are just slipping by". Well he decided to start tracking his life in a spreadsheet timeline - in his words: "It's important to keep track of milestones in our lives -- big or small -- and I envision a future when everything you do, or did, will simply be online and interfaced with everyone else's lives. With each other's permission of course.". So he's included Jobs, relationships, residences, Trips, Events and more... Jon: please go check out MIT's Simile Timeline - and hook these two up...

Site:Hyperwest.net Blog
Spreadsheet:My So-called Life V1.0

Friday, February 8, 2008

Presidential Primary Data with some analysis

There's plenty of political chatter, news and data on the web these days... A blogger known as "Indy" created his own "overly detailed spreadsheet of all the democratic party's numbers for the 2008 primary"... The formatting is nice, as he describes it: "I've color-coded some of the cells, so that it's easily visible where some "problem spots" are. What I mean by "problem spots" are places where the people made one choice, but the current political system stacked up against them anyway."

Site:Indy CC Blog
Page/Post:2008 Primaries Current Standings (Democratic)
Spreadsheets:Democratic Primaries 2008 - Totals
By State

Texas Tech Football Rankings

The Unofficial Texas Tech Red Raiders blog published two spreadsheets to show how two different football recruiting sites ranked their team. Another good example of sports data sharing - and maybe they'll take this data and make one comparison sheet with a chart or two...

Site:Double T Nation
Page/Post:Recruiting Throughts
Spreadsheets:Recruiting Rivals Avg. Rank
Recruiting Avg. Rating - Scout

Tuesday, February 5, 2008

Organizing a stage production

Musical Theater is not a job for the dis-organized. Well, Mr. Davis proves that he's the right guy for the job with this incredibly well-conceived spreadsheet for organizing his troupe of players for the 3 months leading up to a High School production. This is a great sample sheet for all you stage managers out there...

Site:West High Choir Guy
Page/Post:Rehearsal Calendar
Spreadsheet:Master Calendar - Scene List

Covered Call Stock Investment Strategy

The Buy (Hold) & Write blog presents deep information and data on a "covered call investment strategy". There are spreadsheets with individual stock data (like the one we link to below), as well as Portfolilo Values and Transactions. The educational links on this site make it a very nice place to start when trying to learn about covered calls and investing in stocks overall.

Site:Buy (Hold) & Write
Page/Post:Pop Goes CYBS
Spreadsheet:Break Even Analysis for CYBS

Local Food Ratings: Fish & Chips

Only the most considerate bloggers will take the time to document and then publish their ratings of their favorite products and foods. Devious Bloggery doesn't sound like such a site by it's name, but his current Fish & Chips ratings spreadsheet includes even such measures as "Lack of Fish Slime" - which sounds like a helpful thing to check before heading out to satisfy your desire for Fish & Chips in Kansas City. Now, if we could only get someone to spread this to all cities, we could avoid ever having a bad Fish & Chips experience.

Site:Devious Bloggery
Page/Post:On a quest for KC's perfect Fish & Chips
Spreadsheet:KC Fish and Chips

Shoppers helping shoppers

The Bargain Shopper Lady helps other shoppers find great deals. She publishes a spreadsheet in her current post to list a large set of Sara Lee products which are included in a "buy 5, get $10 coupon" deal. That's a dedicated shopper's advocate...

Site:Bargain Shopper Lady
Page/Post:Hot SaraLee Safeway Deal!
Spreadsheet:SaraLee UPCs