Archive for September, 2007
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 ...
Posted in Uncategorized | No Comments »
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 ...
Posted in Personal Finance, Templates | 2 Comments »
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 ...
Posted in Home, Templates | 3 Comments »
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 ...
Posted in Personal Finance | No Comments »
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 ...
Posted in Uncategorized | No Comments »
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 ...
Posted in Functions | No Comments »
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 ...
Posted in Tips | 3 Comments »
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
Posted in Templates | 5 Comments »