Archive for September, 2007

New Look

Tuesday, September 18th, 2007

Returning visitors may notice that we now have a new theme. This theme is much cleaner than the old one, and is more easily edited. I would also like to acknowledge MyMac.com for giving us a mention in a post yesterday. For first time readers, please check back soon.  I hope to announce ...

Template: Net Worth Calculator for Apple iWork Numbers

Wednesday, September 12th, 2007

This is a simple net worth calculator template. Usage: Enter the estimated value of your assets in the left table. Enter the estimated value of your liabilities in the right table. The sheet will then subtract your total liabilities from your assets, and display your estimated net worth in the upper right ...

Template: One Page Per Day Calendar Planner for Apple iWork Numbers

Monday, September 10th, 2007

This template absolutely rocks! It is a one page per day calendar, with automatic day updating, plus a daily task list, and notes page. The design is fantastic and functional, probably the best that I have seen for Numbers so far. Here is a detail of one of the pages: The template ...

Template: Mortgage Refinance Calculator for Apple iWork Numbers

Saturday, September 8th, 2007

Mortgage Refinance Calculator: Should you refinance your mortgage? The mortgage refinance calculator template lets you compare your current mortgage loan to a new one. It then displays the difference in payments, and the number of months it will take to recoup any closing costs. Usage: The template requires eight inputs: The original loan amount ...

Quick Note

Saturday, September 8th, 2007

More templates coming this weekend. I've noticed something working with Numbers.  It takes me a lot longer to create things in Numbers than Excel.  It's not because Numbers is missing a lot of features; it has 99% of what I need.   It's that I want to make them look good! Unless ...

Functions: Text Related Functions in Apple iWork Numbers

Tuesday, September 4th, 2007

Text in a spreadsheet is not very useful unless you can do something with it. Fortunately, Numbers provides several functions for working with text. Here is a quick look at some of the most useful text functions: CONCATENATE(string1, string2, [string3,…]) Joins strings. Note: You can also use & (Ampersand) to join ...

Tips: How to Show Formulas in Apple iWork Numbers

Tuesday, September 4th, 2007

This tip allows you to show formulas in Numbers just as you would in Excel. The secret is to place an apostrophe in front of your formula. For instance, if you type =SUM(10,20), Numbers would normally display 30. If you type '=SUM(10,20), Numbers displays =SUM(10,20). That's correct, it ...

Template: Weekly Blood Sugar Tracker for Apple iWork Numbers

Sunday, September 2nd, 2007

This template was adapted from the Excel file found here. Description: Tracks and charts weekly blood sugar levels, based on three measurements per day. Download Weekly Blood Sugar Tracker Template for Numbers