Tip: How To Use The Index Function To Transpose Data In Numbers

Tuesday, May 6th, 2008

I just found this great Numbers tip on Fury&Frost.com: You can use the INDEX() Function to transpose data to another table. Read the post for a full explanation, but use the following function to get the results shown in the screen shot above: =INDEX(Prefs::$A$1:$E$15,COLUMN(),ROW()) Good one!

Template: Household Monthly Budget

Friday, April 11th, 2008

I found this detailed, single page, household budget template for Numbers on the iwork templates blog. The author states that it was converted from an Excel file, so it doesn't display a lot of the Numbers formating flash. Still, if you are looking for a simple budget, this ...

Template: Family Tree

Friday, April 4th, 2008

The Family Tree Template for Numbers allows you to enter up to five generations of ancestry. From Wikipedia: A family tree is a chart representing family relationships in a conventional tree structure form resembling a tree. As normally presented these trees "grow" down from the top, from the oldest generations at ...

Numbers 1.0.2

Friday, February 1st, 2008

Apple released the latest update to Numbers on January 29, version 1.0.2. Apple describes the update thusly: This update addresses compatibility with Mac OSX. Awesome. Also released on January 29: Keynote Update Version: 4.0.2 Pages Update Version 3.0.2 iWeb Update Version 2.0.3

Template: Graph Paper

Sunday, January 20th, 2008

Here's something fun and useful: Graph Paper Templates. Just print a page out as you need it. The zip contains four files: graph-paper-small-grid.numbers: Graph paper template with grids spaced at .17 inches. graph-paper-small-grid.pdf: PDF version of the small grid graph paper template. graph-paper-large-grid.numbers: Graph paper template with grids spaced at .43 inches. graph-paper-large-grid.pdf: PDF ...

iWork ‘08 Has 16% of the Mac Productivity Market

Wednesday, December 12th, 2007

Macworld reports that iWork now has a 16% share of the office productivity software market on the Mac. The article notes that this big gain may be transitory as Microsoft readies it's new version of Office, which is scheduled for release January 15, 2008. Microsoft last updated Mac Office in 2004. ...

MacWorld UK Review of iWork ‘08

Thursday, December 6th, 2007

Neale Monks, writing for MacWorld UK, has written one of the better reviews of iWork, and Numbers in particular, that I have read. He notes the big improvements to Pages and Keynote since the last release, and goes into some depth on the features in Numbers.Here are some highlights: So ...

Template: David Seah’s Compact Calendar for Numbers

Tuesday, December 4th, 2007

This is a Numbers port of David Seah's Compact Calendar. David has developed a number of great productivity tools over the years including The Printable CEO Series. I highly recommend his site. The Compact Calendar allows you to plan projects quickly, while envisioning time in a different manner than other tools ...

Happy Thanksgiving!

Thursday, November 22nd, 2007

I had a great surprise when I checked the Numbers Templates Forums this afternoon after stuffing myself with entirely too much food.  Forum member 5|=vv had posted a neat Numbers spreadsheet that had graphical breakdown of the days in November on which Thanksgiving fallen since 1939. [Note: This blog has a fair number of international ...

Template: One Month Calendar

Sunday, November 18th, 2007

This is the first version of a simple, one month calendar template for Numbers. Currently, all data must be manually entered. I will add functionality to auto fill dates and days when time allows. Usage: The month banner at the top is a text box, just type in the month you want. The ...