Archive for December, 2008

UARC Finishes 6th in FSAE

Thursday, December 11th, 2008

Dear UARC Supporters,

Last week we left for Melbourne, to compete in the 9th Australasian Formula SAE Competition. A few extra days before the competition allowed us to prepare for our static events. The competition is split into four days, each with a specific set of events run that day. Meaning that if your vehicle is out of [...]

Export MS Project Tasks to Excel and Keep Indentation

Wednesday, December 10th, 2008

Ever wondered how to export the tasks from MS Project to Excel and not have to spend hours indenting the text in the cells just for neatness?
The attached document shows you how to achieve this!
Attachment: exporting-ms-project-tasks-and-keeping-indentation

Hide Series in Excel Charts with a Cell Click

Wednesday, December 3rd, 2008

When you need to plot several series on a chart (like 3 or 4 different forecasts in an S-curve) you can sometimes want to hide different series temporarily. This little trick helps do just that!

Step one is to (somewhere in the workbook) define a Yes, No list. Type in “Yes” and “No” in two cells
Go [...]

Ignoring #N/A in Excel Sums

Wednesday, December 3rd, 2008

A quick way of ignoring the infamous #N/A in an excel sum