tag:blogger.com,1999:blog-73862828755215671592024-03-13T15:40:21.608-04:00Sharing DocsCategorized PUBLIC examples, spreadsheets, templates and stories of collaboration and sharing using Google Docs.JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.comBlogger121125tag:blogger.com,1999:blog-7386282875521567159.post-2305622206390193442010-02-22T16:30:00.000-05:002010-02-22T16:30:52.284-05:00Create an Olympics Medal Map using Google Spreadsheets<div class="separator" style="clear: both; text-align: center;"><a href="http://1.bp.blogspot.com/_fpqzaiBmDkw/S4L3Tt-OXJI/AAAAAAAAInU/8mWUmum3G9E/s1600-h/Picture+44.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="http://1.bp.blogspot.com/_fpqzaiBmDkw/S4L3Tt-OXJI/AAAAAAAAInU/8mWUmum3G9E/s320/Picture+44.png" /></a></div>This is a very detailed "How-to" blog post which takes the reader step-by-step through the creation of a "HeatMap". This is the sort of visual presentation that shows "heat" (color intesity) using some data points connected to physical locations - like countries, in this case - as the source. The post describes taking data from the web, putting the data into a useful form and then creating the map using spreadsheet gadgets. Very well done - except that the author did not provide a link to the underlying spreadsheet example for readers to use as a starting point.<br />
<br />
<table><tbody>
<tr><td><span style="font-weight: bold;">Site:</span></td><td name="sitelink"><a href="http://ouseful.wordpress.com/">OUseful.Info, the blog...</a></td></tr>
<tr><td><span style="font-weight: bold;">Page/Post:</span></td><td name="pagelink"><a href="http://ouseful.wordpress.com/2010/02/15/creating-a-winter-olympics-2010-medal-map-in-google-spreadsheets/">Create an olympics medal map using a spreadsheet</a></td></tr>
<tr><td><span style="font-weight: bold;">Spreadsheet:</span></td><td name="doclink">spreadsheet link not provided</td></tr>
</tbody></table>JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.com0tag:blogger.com,1999:blog-7386282875521567159.post-48469139272936811542010-02-21T23:50:00.000-05:002010-02-21T23:50:33.418-05:00A spreadsheet list of Google Products<div class="separator" style="clear: both; text-align: center;"><a href="http://3.bp.blogspot.com/_fpqzaiBmDkw/S4IMbowITqI/AAAAAAAAInM/TznEm6H8jfg/s1600-h/Picture+43.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="77" src="http://3.bp.blogspot.com/_fpqzaiBmDkw/S4IMbowITqI/AAAAAAAAInM/TznEm6H8jfg/s200/Picture+43.png" width="200" /></a></div>Here's a spreadsheet listing a compiled list of "all" google products (maybe not all - not guarantees - but the list is really pretty comprehensive). It's got some interesting attributes about each product listed, like whether it's new or not, and links to related videos and twitter accounts. Quite interesting - maybe even useful. (this, of course, is not sponsored by, recommended by or supported in any way by Google).<br />
<br />
<table><tbody>
<tr><td><span style="font-weight: bold;">Page/Post:</span></td><td name="pagelink"><a href="http://u.go2.me/3WT">Go2me page with spreadsheet embedded</a></td></tr>
<tr><td><span style="font-weight: bold;">Spreadsheet:</span></td><td name="doclink"><a href="http://spreadsheets.google.com/pub?key=ty_BGDs9hnuBMRvj3AFeB2g&output=html">Google Products List</a></td></tr>
<tr><td><span style="font-weight: bold;">Spreadsheet:</span></td><td name="doclink"><a href="http://spreadsheets.google.com/ccc?key=ty_BGDs9hnuBMRvj3AFeB2g">version you can copy</a></td></tr>
</tbody></table>JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.com1tag:blogger.com,1999:blog-7386282875521567159.post-59697862578709608252009-09-22T14:10:00.006-04:002009-09-22T14:42:28.646-04:00Online Seating Charts - for teachers, by a teacher<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://drezac.blogspot.com/2009/09/google-apps-in-class-creating-online.html"><img style="float:right; margin:0 0 10px 10px;cursor:pointer; cursor:hand;width: 241px; height: 133px;" src="http://4.bp.blogspot.com/_fpqzaiBmDkw/SrkZ_AboBaI/AAAAAAAAH8s/rBZdCh0mmYM/s320/Picture+2.png" border="0" alt=""id="BLOGGER_PHOTO_ID_5384363399736460706" /></a><a href="http://twitter.com/drezac">Daniel Rezac</a> - a <a href="http://www.google.com/educators/gta.html">Google Certified Teacher</a> - posted an example of a seating chart he did for his school on his "<a href="http://drezac.blogspot.com">Adventures in Ed Tech</a>" blog - along with <a href="http://drezac.blogspot.com/2009/09/google-apps-in-class-creating-online.html">a video</a> which explains the process of creating one for yourself. Seems like an innovative way to keep yet another one of those many (many!) pieces of information that a teacher needs in an easy to manage - and more fun - form.<br /><table><tr><td><span style="font-weight:bold;">Site:</span></td><td name="sitelink"><a href="http://drezac.blogspot.com">drezac - Adventures in Ed Tech</a></td></tr><tr><td><span style="font-weight:bold;">Page/Post:</span></td><td name="pagelink"><a href="http://drezac.blogspot.com/2009/09/google-apps-in-class-creating-online.html">Google Apps in the Class: Creating Online Seating Charts</a></td></tr><tr><td><span style="font-weight:bold;">Spreadsheet:</span></td><td name="doclink"><a href="http://spreadsheets.google.com/pub?key=tx8p65M_2w5zcKjM4Fp3S-g&output=html">Seating Chart Spreadsheet</a></td></tr></table>JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.com1tag:blogger.com,1999:blog-7386282875521567159.post-84000708420471766132009-09-15T09:27:00.003-04:002009-09-15T09:37:51.491-04:00Farm Town is the original Farming game? and spreadsheet?<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_fpqzaiBmDkw/Sq-WxxUKPlI/AAAAAAAAH8c/bbmkXvRgBK4/s1600-h/Picture+25.png"><img style="float:right; margin:0 0 10px 10px;cursor:pointer; cursor:hand;width: 230px; height: 113px;" src="http://3.bp.blogspot.com/_fpqzaiBmDkw/Sq-WxxUKPlI/AAAAAAAAH8c/bbmkXvRgBK4/s320/Picture+25.png" border="0" alt=""id="BLOGGER_PHOTO_ID_5381685861526683218" /></a><br />Looks like I should give fair time to what appears to be the original farming simulation game - <a href="http://www.facebook.com/apps/application.php?id=56748925791">Farm Town</a> (also on <a href="http://www.facebook.com/apps/application.php?id=56748925791">Facebook</a>). Lots of resources and blogs focused on this game - including this blog I found which linked to another really detailed data spreadsheet... so here's that one. You make the choice on which one you like best!<br /><table><tr><td><span style="font-weight:bold;">Site:</span></td><td name="sitelink"><a href="http://www.farmtownhero.com/">Farm Town Here Blog</a></td></tr><tr><td><span style="font-weight:bold;">Page/Post:</span></td><td name="pagelink"><a href="http://www.farmtownhero.com/?p=11">What is best to plant?</a></td></tr><tr><td><span style="font-weight:bold;">Spreadsheet:</span></td><td name="doclink"><a href="http://spreadsheets.google.com/pub?key=py5j2VIEMoooUzJ2u5ih7GA&gid=0">Farm Town data sheet</a></td></tr></table>JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.com0tag:blogger.com,1999:blog-7386282875521567159.post-8107688950963613692009-09-15T08:51:00.003-04:002009-09-15T09:06:27.770-04:00Farmville is apparently a game of data analysis<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_fpqzaiBmDkw/Sq-OBnqT-_I/AAAAAAAAH8U/YMmfdFc7BG0/s1600-h/Picture+24.png"><img style="float:right; margin:0 0 10px 10px;cursor:pointer; cursor:hand;width: 320px; height: 170px;" src="http://3.bp.blogspot.com/_fpqzaiBmDkw/Sq-OBnqT-_I/AAAAAAAAH8U/YMmfdFc7BG0/s320/Picture+24.png" border="0" alt=""id="BLOGGER_PHOTO_ID_5381676238208498674" /></a>If you play <a href="http://www.zynga.com/games/index.php?game=farmville">FarmVille</a> on <a href="http://www.facebook.com/apps/application.php?id=102452128776">Facebook</a>, you've probably already seen this - but apparently it offers tremendous value to those playing the game who want to optimize their farming results. I'm not familiar enough with the details of the game to tell more here - except that this spreadsheet has information on Seeds, Trees, Animals, Buildings, Decorations, Ribbons, Expansion, Vehicles and Crop Images. Wow. <br /><table><tr><td><span style="font-weight:bold;">Site:</span></td><td name="sitelink"><a href="http://www.stevenloi.com">Steven Loi's Blog</a></td></tr><tr><td><span style="font-weight:bold;">Page/Post:</span></td><td name="pagelink"><a href="http://www.stevenloi.com/2009/08/13/best-roi-on-farmville-spreadsheet-included-developing/">ROI analysis on Framville</a></td></tr><tr><td><span style="font-weight:bold;">Spreadsheet:</span></td><td name="doclink"><a href="http://spreadsheets.google.com/pub?key=rrFQP5AOGa4yUZCL-1VLUyg&gid=1">Farmville Data</a></td></tr></table>JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.com0tag:blogger.com,1999:blog-7386282875521567159.post-49184107889989012402009-04-30T06:13:00.004-04:002009-04-30T06:28:33.438-04:00Videos from TED conference all listed in a spreadsheet<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_fpqzaiBmDkw/Sfl8h9i3NFI/AAAAAAAAGjg/vMmNgbUW4yU/s1600-h/Picture+5.png"><img style="float:right; margin:0 0 10px 10px;cursor:pointer; cursor:hand;width: 149px; height: 68px;" src="http://2.bp.blogspot.com/_fpqzaiBmDkw/Sfl8h9i3NFI/AAAAAAAAGjg/vMmNgbUW4yU/s320/Picture+5.png" border="0" alt=""id="BLOGGER_PHOTO_ID_5330428556868006994" /></a>The official (I think) <a href="http://www.facebook.com/note.php?note_id=62505278738">TED group on facebook</a> has a link to a <a href="http://spreadsheets.google.com/pub?key=pjGlYH-8AK8ffDa6o2bYlXg">published spreadsheet</a> listing all the TED talk videos. This makes it quite easy to quickly find and watch the ones which seem interesting from their name or the speaker name. There are even separate sheets sorting the list by conference and by speaker. It even lists the duration, which is useful.<br /><table><tr><td><span style="font-weight:bold;">Site:</span></td><td name="sitelink"><a href="http://www.facebook.com/note.php?note_id=62505278738">Facebook Ted Page</a></td></tr><tr><td><span style="font-weight:bold;">Spreadsheet:</span></td><td name="doclink"><a href="http://spreadsheets.google.com/pub?key=pjGlYH-8AK8ffDa6o2bYlXg">List of all Ted Talks</a></td></tr></table>JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.com0tag:blogger.com,1999:blog-7386282875521567159.post-14396983858274896902009-02-26T09:27:00.004-05:002009-02-26T09:42:11.520-05:00Newspaper Website Visitor Trends<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://www.niemanlab.org/2009/02/top-15-of-2008-the-leading-regional-newspaper-sites-shuffle-their-ranks/"><img style="float:right; margin:0 0 10px 10px;cursor:pointer; cursor:hand;width: 181px; height: 160px;" src="http://4.bp.blogspot.com/_fpqzaiBmDkw/SaaqDY8OXKI/AAAAAAAAFc0/1QkYyRfq3rc/s320/Picture+8.png" border="0" alt=""id="BLOGGER_PHOTO_ID_5307116186114088098" /></a>The <a href="http://www.niemanlab.org/">Nieman Journalism Lab</a> at Harvard University posted <a href="http://www.niemanlab.org/2009/02/top-15-of-2008-the-leading-regional-newspaper-sites-shuffle-their-ranks/">an analysis</a> of the top 15 newspaper websites. While they have many really interesting charts, they also posted the underlying data in a <a href="http://spreadsheets.google.com/ccc?key=pwHusjn4prESKiSd9w9o6CQ">spreadsheet</a>, which includes, for each of the top 30 sites, for 2007 and 2008, the monthly unique visitors and time spent per visit. Wow - great data (if it's right - which, of course, this blog cannot confirm).<br /><table><tr><td><span style="font-weight:bold;">Site:</span></td><td name="sitelink"><a href="http://www.niemanlab.org/">Nieman Journalism Lab</a></td></tr><tr><td><span style="font-weight:bold;">Page/Post:</span></td><td name="pagelink"><a href="http://www.niemanlab.org/2009/02/top-15-of-2008-the-leading-regional-newspaper-sites-shuffle-their-ranks/">Top 15 Newspaper Sites</a></td></tr><tr><td><span style="font-weight:bold;">Spreadsheet:</span></td><td name="doclink"><a href="http://spreadsheets.google.com/ccc?key=pwHusjn4prESKiSd9w9o6CQ">Newspaper Site Stats '07-'08</a></td></tr></table>JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.com0tag:blogger.com,1999:blog-7386282875521567159.post-55219871734232376162009-02-26T08:00:00.007-05:002009-02-26T09:13:27.216-05:00Tracking, Charting (then twittering) a Hamster's Stamina<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://spreadsheets.google.com/pub?key=pGq98_NzjAnyUHUC0RJozFw"><img style="float:right; margin:0 0 10px 10px;cursor:pointer; cursor:hand;width: 50%; height: 50%;" src="http://1.bp.blogspot.com/_fpqzaiBmDkw/SaaYEVlP2xI/AAAAAAAAFcs/BP9QDq6R2y4/s320/Picture+7.png" border="0" alt=""id="BLOGGER_PHOTO_ID_5307096411182979858" /></a><a href="http://identi.ca/spookypeanut">SpookyPeanut</a> (aka <a href="http://hjsb.livejournal.com/">Henry</a>) posted a link on twitter which caught my eye (well, my search, anyway)... He's apparently found a way to monitor his hamster's wheel - and has charted it using a Google spreadsheet. As he described it: "showing off my geeky side again". Nothing useful here, actually, but interesting that the <a href="http://www.imdb.com/name/nm3062801/">Technical Director</a> of this <a href="http://www.imdb.com/title/tt0420238/">animated rodent film</a> would post a <a href="http://spreadsheets.google.com/pub?key=pGq98_NzjAnyUHUC0RJozFw">spreadsheet</a> about a pet rodent. ;)<br /><table><tr><td><span style="font-weight:bold;">Site:</span></td><td name="sitelink"><a href="http://identi.ca/spookypeanut">SpookyPeanut</a></td></tr><tr><td><span style="font-weight:bold;">Spreadsheet Chart:</span></td><td name="doclink"><a href="http://spreadsheets.google.com/pub?key=pGq98_NzjAnyUHUC0RJozFw">Stamina of a Hamster</a></td></tr></table>JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.com0tag:blogger.com,1999:blog-7386282875521567159.post-7830820776218369472009-02-24T08:41:00.004-05:002009-02-24T08:50:52.617-05:00Home Prices by US Metro area<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_fpqzaiBmDkw/SaP6_OCkv2I/AAAAAAAAFcQ/WsX2mSVAVMA/s1600-h/Picture+6.png"><img style="float:right; margin:0 0 10px 10px;cursor:pointer; cursor:hand;width: 225px; height: 154px;" src="http://2.bp.blogspot.com/_fpqzaiBmDkw/SaP6_OCkv2I/AAAAAAAAFcQ/WsX2mSVAVMA/s400/Picture+6.png" border="0" alt=""id="BLOGGER_PHOTO_ID_5306360749980172130" /></a><br /><a href="http://healthcare-economist.com">Healthcare Economist</a> published a very useful <a href="http://spreadsheets.google.com/pub?key=pqVgDLeO6WJ2LqGAwfrHeRA">spreadsheet of home prices</a> and rankings by metropolitan area. It includes multi-year trends, by US region and broken into Single-family homes and Condominiums. I guess I should go searching to see if this "Healthcare Economist" ever actually talks about Healthcare ;)<br />(of course, as with every post here, we can't guarantee the information is right)...<br /><table><tr><td><span style="font-weight:bold;">Site:</span></td><td name="sitelink"><a href="http://healthcare-economist.com">Healthcare Economist</a></td></tr><tr><td><span style="font-weight:bold;">Page/Post:</span></td><td name="pagelink"><a href="http://healthcare-economist.com/2009/02/13/cost-of-living-ii-home-prices/">Cost of Living II: Home Prices</a></td></tr><tr><td><span style="font-weight:bold;">Spreadsheet:</span></td><td name="doclink"><a href="http://spreadsheets.google.com/pub?key=pqVgDLeO6WJ2LqGAwfrHeRA">Home Prices by metro area</a></td></tr></table>JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.com1tag:blogger.com,1999:blog-7386282875521567159.post-67038359713485030942009-02-24T08:28:00.004-05:002009-02-24T08:41:03.253-05:00Picking a US State of residence using the tax rates as criteria<a href="http://jasonshafrin.com/">Jason Shafrin</a>, author of the <a href="http://healthcare-economist.com/">Healthcare Economist</a> blog, provides some really interesting information to help you pick which State you might want to live in using the Tax burden as criteria. He published a <a href="http://spreadsheets.google.com/pub?key=pqVgDLeO6WJ1vx12gZYfcaQ">State-by-State Tax Burden spreadsheet</a> to help guide you understand all the tax rates which might impact you as a resident - not just income tax rates.<br /><table><tr><td><span style="font-weight:bold;">Site:</span></td><td name="sitelink"><a href="http://healthcare-economist.com">Healthcare Economist</a></td></tr><tr><td><span style="font-weight:bold;">Page/Post:</span></td><td name="pagelink"><a href="http://healthcare-economist.com/2009/02/12/cost-of-living-i-state-taxes/">Cost of Living I: State Taxes</a></td></tr><tr><td><span style="font-weight:bold;">Spreadsheet:</span></td><td name="doclink"><a href="http://spreadsheets.google.com/pub?key=pqVgDLeO6WJ1vx12gZYfcaQ">State Tax Rates & Rankings</a></td></tr></table>JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.com0tag:blogger.com,1999:blog-7386282875521567159.post-41674773039478549982009-02-24T07:11:00.004-05:002009-02-24T08:05:04.377-05:00Travelling adoptive parents need to be prepared<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_fpqzaiBmDkw/SaPwak-XG4I/AAAAAAAAFcI/LHxjk-_k3nI/s1600-h/Picture+5.png"><img style="float:right; margin:0 0 10px 10px;cursor:pointer; cursor:hand;width: 203px; height: 168px;" src="http://3.bp.blogspot.com/_fpqzaiBmDkw/SaPwak-XG4I/AAAAAAAAFcI/LHxjk-_k3nI/s400/Picture+5.png" border="0" alt=""id="BLOGGER_PHOTO_ID_5306349125365078914" /></a><a href="http://5byfaith.blogspot.com">5 by Faith</a> is a blog covering a "journey of adopting a baby girl from Ethiopia". As you can imagine (or maybe as you've experienced), new babies require planning - and when you add in the legal and logistical steps of adoption - well, let's just say it's lucky that the end reward is so huge. Thanks to 5byFaith for keeping all the planning they went through in <a href="http://spreadsheets.google.com/pub?key=ppHBvDAxQ8m5iyTtOudXnYw">spreadsheets</a> loaded with information. (You might get some other ideas by visiting 5byFaith's other <a href="http://www.ekinspired.com/">Blog</a> or her <a href="http://www.etsy.com/shop.php?user_id=5840352">Etsy Store</a>)<br /><table><tr><td><span style="font-weight:bold;">Site:</span></td><td name="sitelink"><a href="http://5byfaith.blogspot.com">5 by Faith (blog)</a></td></tr><tr><td><span style="font-weight:bold;">Spreadsheet:</span></td><td name="doclink"><a href="http://spreadsheets.google.com/pub?key=ppHBvDAxQ8m5iyTtOudXnYw">Travel Tips, Hints (9 tabs!)</a></td></tr><tr><td><span style="font-weight:bold;">Spreadsheet:</span></td><td name="doclink"><a href="http://spreadsheets.google.com/pub?key=ppHBvDAxQ8m73rfObCrbLLw">Packing List (12 tab sample)</a></td></tr></table>JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.com0tag:blogger.com,1999:blog-7386282875521567159.post-91791133834641663712009-02-24T06:31:00.006-05:002009-02-24T06:54:35.141-05:00Watching stocks on a Spreadsheet<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://spreadsheets.google.com/pub?key=pO3Ze62OAU2Fau5mTjmcQTQ"><img style="float:right; margin:0 0 10px 10px;cursor:pointer; cursor:hand;width: 50%; height: 50%;" src="http://3.bp.blogspot.com/_fpqzaiBmDkw/SaPdmFu9sWI/AAAAAAAAFcA/FKTJbErrk3s/s320/Picture+4.png" border="0" alt=""id="BLOGGER_PHOTO_ID_5306328432416502114" /></a>Here's <a href="http://spreadsheets.google.com/pub?key=pO3Ze62OAU2Fau5mTjmcQTQ">a spreadsheet</a> which follows selected stocks from a given point in time, up to the current, updated price - to give an "unrealized gain or loss" calculation based on some theoretical number of shares purchased. <a href="http://jrsays.com/2009/02/stock-screening-and-watching-for-now.html">It's very simple</a>. The way this <a href="http://spreadsheets.google.com/pub?key=pO3Ze62OAU2Fau5mTjmcQTQ">spreadsheet</a> was populated as you see it, was from using the Google Finance <a href="http://www.google.com/finance/stockscreener">stock screener</a> - a very useful tool which lets you identify stocks which meet certain criteria which you can easily set. Oh - I almost forgot to mention - the stock prices in this spreadsheet update automatically using the <a href="http://docs.google.com/support/bin/answer.py?answer=54198">GoogleFinance function</a> of Google spreadsheets... sweet.<br /><table><tr><td><span style="font-weight:bold;">Site:</span></td><td name="sitelink"><a href="http://jrsays.com">JRsays (my blog)</a></td></tr><tr><td><span style="font-weight:bold;">Page/Post:</span></td><td name="pagelink"><a href="http://jrsays.com/2009/02/stock-screening-and-watching-for-now.html">Stock Screening</a></td></tr><tr><td><span style="font-weight:bold;">Spreadsheet:</span></td><td name="doclink"><a href="http://spreadsheets.google.com/pub?key=pO3Ze62OAU2Fau5mTjmcQTQ">Stock Screen Spreadsheet</a> (preview)</td></tr></tr><tr><td><span style="font-weight:bold;">Spreadsheet:</span></td><td name="doclink"><a href="http://spreadsheets.google.com/ccc?key=pO3Ze62OAU2Fau5mTjmcQTQ&newcopy=true">get your own copy</a><br/>(on click, you'll get a copy put in your Docs list)</td></tr></table>JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.com1tag:blogger.com,1999:blog-7386282875521567159.post-770621713911919782009-02-23T22:02:00.005-05:002009-02-23T22:27:10.312-05:00Canadian Women's Hockey League knows spreadsheets<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://www.oakvillehornets.on.ca/images/logo_100.gif"><img style="float:left; margin:0 0 10px 10px;cursor:pointer; cursor:hand;width: 100px; height: 100px;" src="http://www.oakvillehornets.on.ca/images/logo_100.gif" border="0" alt="" /></a><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_fpqzaiBmDkw/SaNojObsw3I/AAAAAAAAFb4/83BOnsIXjzk/s1600-h/Picture+3.png"><img style="float:right; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 175px; height: 159px;" src="http://2.bp.blogspot.com/_fpqzaiBmDkw/SaNojObsw3I/AAAAAAAAFb4/83BOnsIXjzk/s320/Picture+3.png" border="0" alt=""id="BLOGGER_PHOTO_ID_5306199740351562610" /></a><br />The <a href="http://www.oakvillehornets.on.ca/index.html">Oakville Hornets women's hockey league</a> of Ontario, Canada probably have quite an online audience, given the number of teams and players they support. It looks like (at a quick glance) around 8 leagues with as many as 16 or 24 teams in some of those. They use spreadsheets extensively in their <a href="http://www.oakvillehornets.on.ca/tournament/index.html">Tournament Standings pages</a> - publishing <a href="http://www.oakvillehornets.on.ca/tournament/standings/midget.html">updated standings</a> with embedded published spreadsheets in web pages. If you're wondering why they'd do this - imagine the difference between updating HTML versus a spreadsheet each time a game is played... then imagine you need to add up total wins, or calculate win pctg. Much easier in a spreadsheet than an HTML page. Opens up the task to practically anyone in the organizations instead of just a webmaster. Nice job, Hornets!<br /><table><tr><td><span style="font-weight:bold;">Site:</span></td><td name="sitelink"><a href="http://www.oakvillehornets.on.ca/">Oakville Hornets Hockey</a></td></tr><tr><td><span style="font-weight:bold;">Sample Page:</span></td><td name="pagelink"><a href="http://www.oakvillehornets.on.ca/tournament/standings/intermediate.html">Tournament Standings (sample)</a></td></tr><tr><td><span style="font-weight:bold;">Spreadsheet:</span></td><td name="doclink"><a href="http://spreadsheets.google.com/pub?key=pk__C9joMIxvBvdfw35DvVQ">Schedule of games & standings</a></td></tr></table>JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.com0tag:blogger.com,1999:blog-7386282875521567159.post-91669897523372934742009-02-22T16:25:00.002-05:002009-02-22T16:33:04.312-05:00Easy sharing of expenses for a group outingThis is the classic example of using a shared spreadsheet to make it easy to share expenses for a group event. This group uses <a href="http://ajc0907.blogspot.com/">a blog</a> to communicate, they have a shared calender, shared photos online, and a couple of spreadsheets where they've tracked expenses (linked on the right side of the blog). Everyone enters their out of pocket expenses, and the spreadsheet calculates the net due to/from each person.<br /><table><tr><td><span style="font-weight:bold;">Site:</span></td><td name="sitelink"><a href="http://ajc0907.blogspot.com/">Shared blog AJC 09/07</a></td></tr><tr><td><span style="font-weight:bold;">Spreadsheet:</span></td><td name="doclink"><a href="http://spreadsheets.google.com/ccc?key=pznQJVQgYIgSNqODv2gZUTQ">Shared expenses accounting</a></td></tr></table>JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.com1tag:blogger.com,1999:blog-7386282875521567159.post-55329576961531232922009-02-22T09:15:00.006-05:002009-02-22T11:14:30.941-05:00Hockey Stats in spreadsheets - prospective Buffalo Sabres<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://spreadsheets.google.com/pub?key=pQgoMpzYNlh5tCGuMYtw7bA"><img style="float:right; margin:0 0 10px 10px;cursor:pointer; cursor:hand;width: 50%; height: 50%;" src="http://4.bp.blogspot.com/_fpqzaiBmDkw/SaF5P09JqzI/AAAAAAAAFbs/4pqj5Ji3fQA/s320/Picture+2.png" border="0" alt=""id="BLOGGER_PHOTO_ID_5305655148839283506" /></a>The <a href="http://www.sabresprospects.com/">Sabres Prospects</a> blog uses spreadsheets effectively to publish statistics on prospective hockey players. In the right pane of their blog, you'll find a few links to a spreadsheet in the "Statistics" section. Notice that the links are to different individual sheets within the same spreadsheet file (workbook). You can build individual links like that using the "More Publishing Options" link on the publishing dialog within the spreadsheets editor on Google Docs...<br /><table><tr><td><span style="font-weight:bold;">Site:</span></td><td name="sitelink"><a href="http://www.sabresprospects.com/">Sabres Prospects</a></td></tr><tr><td><span style="font-weight:bold;">Main Spreadsheet:</span></td><td name="pagelink"><a href="http://spreadsheets.google.com/pub?key=pQgoMpzYNlh5tCGuMYtw7bA">Sabres Prospects Stats</a></td></tr><tr><td><span style="font-weight:bold;">Detail sheet:</span></td><td name="doclink"><a href="http://spreadsheets.google.com/pub?key=pQgoMpzYNlh5tCGuMYtw7bA&gid=4">Shooting MPH sheet</a></td></tr></table>JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.com1tag:blogger.com,1999:blog-7386282875521567159.post-39514863098666590562009-02-21T10:25:00.004-05:002009-02-21T21:19:56.085-05:00Spreadsheet of Twittering Musicians ++If you're into Twitter, you can thank Gabriel N. for starting this huge list of twittering musicians. It's got hundreds of 'em - Coldplay, Beastie Boys, Pearl Jam, ... the list goes on and on.<br /><table><tr><td><span style="font-weight:bold;">Site:</span></td><td name="sitelink"><a href="http://twitter.com/gcn1">Follow Gabriel on Twitter</a></td><tr><td><span style="font-weight:bold;">Spreadsheet:</span></td><td name="doclink"><a href="http://spreadsheets.google.com/pub?key=phtgMLGe8aahYaH0pRs7VHg&gid=0">List of Twittering Musicians and others</a></td></tr></table>JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.com0tag:blogger.com,1999:blog-7386282875521567159.post-7217826060155338892009-02-07T09:50:00.003-05:002009-02-07T10:07:18.705-05:00Collecting data using a Google Docs FormIf you want to quickly collect information from people, a Google Docs <span style="font-weight:bold;">Form</span> is a great option. This <a href="http://spreadsheets.google.com/viewform?key=pO3Ze62OAU2Hfi0PpbDIEHA">sample survey about blogging</a> will give you an idea of what the simplest form looks like, It literally takes just a few minutes to set one up (<a href="http://jrsays.com/2009/02/small-business-web-tip-collect-data.html">see my instructions</a>) and get it out to people in an email or embedded in a web page, or as a standalone page.<br /><table><tr><td><span style="font-weight:bold;">Page/Post:</span></td><td name="pagelink"><a href="http://jrsays.com/2009/02/small-business-web-tip-collect-data.html">Collect data using a web form</a></td></tr><tr><td><span style="font-weight:bold;">Spreadsheet:</span></td><td name="doclink"><a href="http://spreadsheets.google.com/ccc?key=pO3Ze62OAU2FTiDsb1mDIAw">Blank Example spreadsheet with a Form</a></td></tr><tr><td><span style="font-weight:bold;">Form:</span></td><td name="pagelink"><a href="http://spreadsheets.google.com/viewform?key=pO3Ze62OAU2Hfi0PpbDIEHA">Sample Live Form - Blogging Survey</a></td></tr></table>JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.com0tag:blogger.com,1999:blog-7386282875521567159.post-20835013836024498712009-02-06T10:32:00.003-05:002009-02-06T10:45:08.534-05:00Recipes are tastier when the calculations are correct<a href="http://www.jeff-barr.com/">Jeff Barr</a> (Web Services evangelist at Amazon.com) has clearly allowed his technical and web services DNA to rub off on his daughter ;) . He posted a great story about how she created a spreadsheet to calculate the cost of a cookie recipe. We don't have the sample spreadsheet, but check out <a href="http://www.jeff-barr.com/?p=1389">his post</a> - it's a great example of the power of spreadsheets for things as important as, well, cookies.<br /><table><tr><td><span style="font-weight:bold;">Site:</span></td><td name="sitelink"><a href="http://www.jeff-barr.com">Jeff Barr's Blog</a></td></tr><tr><td><span style="font-weight:bold;">Page/Post:</span></td><td name="pagelink"><a href="http://www.jeff-barr.com/?p=1389">Using a Google Spreadsheet to calculate recipe costs</a></td></tr></table>JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.com0tag:blogger.com,1999:blog-7386282875521567159.post-17488045702475287252009-01-31T11:33:00.004-05:002009-01-31T11:41:08.394-05:00Superbowl Box Pool - almost automated<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://spreadsheets.google.com/pub?key=pO3Ze62OAU2Fo0AHq8aOKew"><img style="float:right; margin:0 0 10px 10px;cursor:pointer; cursor:hand;width: 320px; height: 195px;" src="http://1.bp.blogspot.com/_fpqzaiBmDkw/SYR95i7ASZI/AAAAAAAAFPM/GOoFFZC1VjQ/s320/superbowl+pool.png" border="0" alt=""id="BLOGGER_PHOTO_ID_5297497489274849682" /></a><br />Here's a fun online Superbowl Box Pool on a spreadsheet - which lets you collect player's names using an online FORM. The spreadsheet randomizes the assignment of boxes and scores...<br /><table><tr><td><span style="font-weight:bold;">Site:</span></td><td name="sitelink"><a href="http://jrsays.com">My Personal Blog (JRsays)</a></td></tr><tr><td><span style="font-weight:bold;">Page/Post:</span></td><td name="pagelink"><a href="http://jrsays.com/2009/01/last-minute-automated-ish-superbowl.html">Last-Minute Superbowl Pool</a></td></tr><tr><td><span style="font-weight:bold;">Spreadsheet:</span></td><td name="doclink"><a href="http://spreadsheets.google.com/ccc?key=pO3Ze62OAU2G7wrlrLEnhNA&hl=en">Box Pool Spreadsheet</a></td></tr></table>JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.com0tag:blogger.com,1999:blog-7386282875521567159.post-88154664485507231222009-01-07T08:30:00.003-05:002009-01-07T09:00:28.813-05:00Rating Superheroes<iframe style="float:right; padding:3px;" width='320' height='180' frameborder='0' src='http://spreadsheets.google.com/pub?key=pLCzqfAl00kLbKlGNq6QYFg&output=html&gid=0&single=true&range=b2:g10'></iframe><a href="http://mattmitchellfiction.com">Matt Mitchell</a> must be a comic book enthusiast, as he created a superhero rating system on a <a href="http://spreadsheets.google.com/pub?key=pLCzqfAl00kLbKlGNq6QYFg">spreadsheet</a> which only a Marvel fan could understand. You might want to ask him how he derived all this data - or you might want to help him out, as he needs a collaborator to "put those numbers together and make the scores make sense".<br /><table><tr><td><span style="font-weight:bold;">Site:</span></td><td name="sitelink"><a href="http://mattmitchellfiction.com">Unabashed</a></td></tr><tr><td><span style="font-weight:bold;">Page/Post:</span></td><td name="pagelink"><a href="put those numbers together and make the scores make sense">Superhero Rating System</a></td></tr><tr><td><span style="font-weight:bold;">Spreadsheet:</span></td><td name="doclink"><a href="http://spreadsheets.google.com/pub?key=pLCzqfAl00kLbKlGNq6QYFg">Superhero Rating spreadsheet</a></td></tr></table>JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.com0tag:blogger.com,1999:blog-7386282875521567159.post-7053423578556796512008-12-03T23:02:00.002-05:002008-12-03T23:30:03.872-05:00Reduce those long URLs in batchesKortina from <a href="http://bit.ly">bit.ly</a> posted <a href="http://bit.ly/spreadsheet">this spreadsheet</a> which is actually a tool tied back to his URL shortening service. This is a good use of the <a href="http://documents.google.com/support/bin/answer.py?hl=en&answer=75507">ImportData() function</a> within Google spreadsheets... it allows entry of lots of original (long) URLs, then creates a call to the <a href="http://bit.ly">bit.ly</a> service (which, itself is a simple URL), then uses the importdata() function to get back the answer (the shortened URL)... Try this to learn a few new tricks.<br /><br /><table><tr><td><span style="font-weight:bold;">Site:</span></td><td name="sitelink"><a href="http://blog.bit.ly">bit.ly blog</a></td></tr><tr><td><span style="font-weight:bold;">Page/Post:</span></td><td name="pagelink"><a href="http://blog.bit.ly/post/62001761/bit-ly-meets-google-spreadsheets-using-the-new">bit.ly meets Google spreadsheets</a></td></tr><tr><td><span style="font-weight:bold;">Spreadsheet:</span></td><td name="doclink"><a href="http://bit.ly/spreadsheet">bit.ly shortener spreadsheet</a></td></tr><tr><td><span style="font-weight:bold;"></span></td><td name="doclink"><a href="http://spreadsheets.google.com/ccc?key=pO3Ze62OAU2HkjfQTzMvRbg&newcopy">Get Your Own Copy</a></td></tr></table>JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.com0tag:blogger.com,1999:blog-7386282875521567159.post-87172254514592562432008-09-22T06:41:00.003-04:002008-09-22T06:50:26.904-04:00Song lists for the sharingHere's a really well constructed <a href="http://spreadsheets.google.com/pub?key=pAFSBiLbNq4HnkjJlUVJtbg">music list spreadsheet</a> which contains song ratings with links back to the source of each rating, as well as Times (and totalled), Artist, song title and Album (is that still a term?). For those of you who love to make and share song lists - here's a good model...<br /><table><tr><td><span style="font-weight:bold;">Site:</span></td><td name="sitelink"><a href="http://macheide.wordpress.com/">Aftermath (blog)</a></td></tr><tr><td><span style="font-weight:bold;">Page/Post:</span></td><td name="pagelink"><a href="http://macheide.wordpress.com/2008/09/21/zen-tracks-23-leonard-cohen-you-know-who-i-am/">Leonard Cohen: You Know Who I Am</a></td></tr><tr><td><span style="font-weight:bold;">Spreadsheet:</span></td><td name="doclink"><a href="http://spreadsheets.google.com/pub?key=pAFSBiLbNq4HnkjJlUVJtbg">Zen Vision M Tracks (Song List and Ratings)</a></td></tr></table>JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.com0tag:blogger.com,1999:blog-7386282875521567159.post-70869676439911307022008-09-22T06:25:00.003-04:002008-09-22T06:34:28.780-04:00Spreadsheets as a craft templating toolTeresa Payne-Neal came up with a novel use of spreadsheets as a way to share a craft template with the readers of her scrapbooking and card-making blog called <a href="http://www.mylifesart.com/">My Life's Art</a>. You may scroll up and down <a href="http://www.mylifesart.com/2008/09/3x3-treat-box.html">this post</a> a few times before recognizing the spreadsheet. <br /><br /><table><tr><td><span style="font-weight:bold;">Site:</span></td><td name="sitelink"><a href="http://www.mylifesart.com/">My Life's Art Blog</a></td></tr><tr><td><span style="font-weight:bold;">Page/Post:</span></td><td name="pagelink"><a href="http://www.mylifesart.com/2008/09/3x3-treat-box.html">3 x 3 Treat Box</a></td></tr><tr><td><span style="font-weight:bold;">Spreadsheet:</span></td><td name="doclink"><a href="http://spreadsheets.google.com/pub?key=p74GkawM73aeWz7DM_QA3CQ">Treat Box Template (3x3)</a></td></tr></table>JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.com0tag:blogger.com,1999:blog-7386282875521567159.post-21194481693779984632008-08-28T17:09:00.003-04:002008-08-28T17:52:42.251-04:00Shared listing of coffee shops (or anything) in Denver (or anywhere)An interesting idea here from <a href="http://denvercoffee.blogspot.com">Mile High Buzz</a> for the use of Forms and Spreadsheets in Google Docs - gathering key information about local shops... Coffee shops in the Denver area in this case... A form is used to allow people to put data into this spreadsheet and then the spreadsheet is published so anyone can see it. This is a great sample that can be created from scratch in about 5 minutes. (<a href="http://spreadsheets.google.com/newform">Click here to create your own form now</a>)<br /><br /><table><tr><td><span style="font-weight:bold;">Site:</span></td><td name="sitelink"><a href="http://denvercoffee.blogspot.com">Mile High Buzz</a></td></tr><tr><td><span style="font-weight:bold;">Page/Post:</span></td><td name="pagelink"><a href="http://denvercoffee.blogspot.com/2008/08/hours-spreadsheet-please-update-repost.html">Coffee House Hours survey</a></td></tr><tr><td><span style="font-weight:bold;">Spreadsheet:</span></td><td name="doclink"><a href="http://spreadsheets.google.com/pub?key=psEB2l1bJCz03arrWWbM7OA">Denver's Coffee House Hours</a></td></tr></table>JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.com1tag:blogger.com,1999:blog-7386282875521567159.post-31154605483468587742008-07-21T18:01:00.002-04:002008-07-21T18:07:05.855-04:00Sharing Savings, Sharing Coupons<a href="http://savvydollar.org">SavvyDollar.Org</a> is self billed as "North Carolina's source for savings... and members, (one in particular) are very helpful to each-other (and dedicated to the cause of saving money) it seems by sharing coupons using a list of available coupons on an <a href="http://spreadsheets.google.com/pub?key=pelABfZ6-drTmrQKLfcYEeA">online spreadsheet</a>. <table><tr><td><span style="font-weight:bold;">Site:</span></td><td name="sitelink"><a href="http://savvydollar.org">SavvyDollar.Org</a></td></tr><tr><td><span style="font-weight:bold;">Page/Post:</span></td><td name="pagelink"><a href="http://savvydollar.org/forums/viewtopic.php?t=4010">Available Coupons Spreadsheet posted</a></td></tr><tr><td><span style="font-weight:bold;">Spreadsheet:</span></td><td name="doclink"><a href="http://spreadsheets.google.com/pub?key=pelABfZ6-drTmrQKLfcYEeA">JustBAMom's Coupon Treasures</a></td></tr></table>JRhttp://www.blogger.com/profile/03007138367944227896noreply@blogger.com0