Archive for October, 2007

Template: Problem Solving Using the Toyota A3 Method

Wednesday, October 24th, 2007

Forum member Steve has shared a cool Numbers spreadsheet template on the forums, that allows a user to use the A3 problem solving methodology to work through business process problems. Steve describes the template: This is another tool that I have found very useful in small (30 people) and large (40,000 people) ...

Mac OS X 10.5 - Leopard

Saturday, October 20th, 2007

Mac OS X 10.5 (Leopard), will be released on October 26. Amazon is making Leopard available for pre-order with free shipping. You can also get $20 off the retail price of the single-user license, and $10 off the retail cost of the family pack (which allows you to upgrade up to five ...

Template: Scuba Dive Log for Apple iWork Numbers

Saturday, October 20th, 2007

Forum member, Bjoern, has shared another of his Numbers Templates. This is a scuba diving log. I am not a diver myself, but those of you who are, may find this interesting. Bjoern used this while on a trip to Egypt to dive in the Red Sea. It ...

Measurement Conversion Sheet for Apple iWork Numbers

Friday, October 12th, 2007

Forum maestro, JaxJason, posted this cool little converter spreadsheet back in September. At first blush, there isn’t a lot going on with this. The first sheet presents just one table, with two drop down boxes: one for choosing the unit measurement you would like to convert to, the ...

iWork Numbers Contest

Tuesday, October 9th, 2007

I received a message through the contact form yesterday from "Puhala" directing me to a contest that he is sponsoring on his blog.   He is offering $100 to the best Numbers Spreadsheet Apple's Numbers application (included in iWork) changes the spreadsheet paradigm. Rather than rave about the feature set, ...

Template: Project Template With Gantt Chart for Apple iWork Numbers

Saturday, October 6th, 2007

Forum member Bjoern has been kind enough to share his Project Template with Gantt chart. The template includes: a project description area, a fuel-gauge style chart, and columns for WBS (Work Breakdown Statements), Tasks, Task Leads, Start Time, End Time, Duration (in days), and a neat in-cell chart. You can view the ...

Conditional Formatting Hack

Friday, October 5th, 2007

I would like to share a very interesting tip that forum member 5|=vv posted on the Apple boards. The question posed was: I was wondering if two columns have the same value can I establish a condition that would underline one column? Example: Orig. Price Current Price $200,000 ...

Templates: Football Squares Betting Pool Template

Thursday, October 4th, 2007

Update: I published a post on my personal finance blog detailing the best squares to have in a football pool. Football Squares Betting Pool Template for Apple iWork Numbers: I stumbled upon this fun little Excel spreadsheet for making square sheets for ...

Template: Creating a “Fuel Gauge” Chart

Monday, October 1st, 2007

JaxJason has shared another cool technique on the forums. This time he shows us how to create a "fuel gauge" style chart. It works by using three pie slices. The middle one is our 'needle'. By changing the size of the first pie slice and adjusting the third ...