Spreadsheets

Figure Out How Much Money You Need to Retire [Personal Finance]

What better way to wile away your workday than by calculating exactly how long you'll have to work at all? Tutorial site wikiHow puts together a step-by-step on how to calculate exactly how much...
Source:

Creating your own order to sort with: leaving alphanumeric in the dust

I've been blogging about sorting for a while: There's just one more thing to mention: creating your own custom sort order. Existing sort orders are things like Monday Tuesday Wednesday (the right order, which is not alphabetical). But let's say you've got things you want in a certain logical but non-alphabetical order that aren't already set up in OpenOffice.org: titles of books or people, procedures done in a certain order, or your own abbreviations for the days of the week. You can create sort orders for those very easily so you can sort by them.
Source:

Tablefy Makes Comparison Charts Easy [Charts]

Want to create a chart or graph comparing two or more options, but not so keen on digging that far into Excel or another standard spreadsheet? Tablefy offers a pretty slick interface for creating...
Source:

Chart Your Investments with Google Spreadsheet [Google Spreadsheets]

Techie Leonard Lin publishes his investment asset allocation in a Google Spreadsheet which employs the super-useful GoogleFinance formula for live-updating stock prices in-sheet. [via]
Source:

Download Google Trends to a Spreadsheet [Google]

One of our favorite Google products you forgot all about—Google Trends—now offers comparison data as a CSV spreadsheet-friendly file. You've got to be signed into your Google Account to...
Source:

TechTarget Article: Using Master Documents in OpenOffice Writer

I've written an article for TechTarget.com about using master documents in OpenOffice.org Writer. http://searchopensource.techtarget.com/tip/0,289483,sid39_gci1230368,00.html Master documents are used to combine lots of other Writer documents. They're similar to Word master files or Frame book files in that they organize your subdocuments, let you create a unified table of contents, etc.  They're a bit picky but once you've got them set up, they work quite reliably.
Source:

Creating Web Input Forms with Google Spreadsheets [Video Demonstration]

Lynette Chandler of Tech Based Marketing has put together a short-and-sweet guide to setting up a data-gathering web form using Google Docs' spreadsheets tool. Follow the easy-to-grasp instructions,...
Source:

Track Time Between Haircuts with Google Calendar and Spreadsheet [Calendar]

Googler Matt Cutts uses Google Calendar and Google Spreadsheets to keep track of how long he's gone between haircuts—a good way to make sure he doesn't get too overgrown. First he copies his...
Source:

[How-To] Embed Google Docs Forms in your Blog

Sometime back Google Docs added Forms feature to spreadsheet. Starting yesterday, Google Docs has integrated the embedding feature with the Google Spreadsheet. Google Docs Logo Now you can embed the same form into your website or blog. This answers the most important question ” How do i embed my form into my blog or website? ” The form inputs leads to the updation of the spreadsheet. To create a Google Docs form to embed in your website or blog follow the steps mentioned below
Source:

[How-To] Embed Google Docs Forms in your Blog

Sometime back Google Docs added Forms feature to spreadsheet. Starting yesterday, Google Docs has integrated the embedding feature with the Google Spreadsheet. Google Docs Logo Now you can embed the same form into your website or blog. This answers the most important question ” How do i embed my form into my blog or website? ” The form inputs leads to the updation of the spreadsheet. To create a Google Docs form to embed in your website or blog follow the steps mentioned below
Source:

Creating your own order to sort with: leaving alphanumeric in the dust

I've been blogging about sorting for a while: There's just one more thing to mention: creating your own custom sort order. Existing sort orders are things like Monday Tuesday Wednesday (the right order, which is not alphabetical). But let's say you've got things you want in a certain logical but non-alphabetical order that aren't already set up in OpenOffice.org: titles of books or people, procedures done in a certain order, or your own abbreviations for the days of the week. You can create sort orders for those very easily so you can sort by them.
Source:

TechTarget Article: Using Master Documents in OpenOffice Writer

I've written an article for TechTarget.com about using master documents in OpenOffice.org Writer. http://searchopensource.techtarget.com/tip/0,289483,sid39_gci1230368,00.html Master documents are used to combine lots of other Writer documents. They're similar to Word master files or Frame book files in that they organize your subdocuments, let you create a unified table of contents, etc.  They're a bit picky but once you've got them set up, they work quite reliably.
Source:

Convert a Spreadsheet to an HTML Table [Spreadsheets]

When you want to turn that giant spreadsheet into an HTML table without wrangling too many TD's and TR's by hand, you can use a formula to generate the HTML tags for you. The Design Intellection...
Source:

Zoho Sheet Adds Macros and Pivot Tables [Spreadsheets]

Today web-based office suite maker Zoho adds pivot tables and VB macros to their online spreadsheet product. You may not use Zoho's online office suite because you're lazy and already have a Google...
Source:

View Google Spreadsheets and Presentations Offline [Google Gears]

If you've stored your slide deck online in Google Docs, you don't have to worry about the internet connection going out when it's time to get onstage. The big G completed its rollout of offline...
Source:

Valid XHTML 1.0 Strict

Syndicate content