Random picture

Random Function

This post will be a short one since I’m working on a project for a friend. The random function in Excel is kind of a neat function. There are two: 1) rand() and randbetween(a,b). Some uses for it are: 1) Randomize your numbers in Monte Carlo simulation; 2) Randomly organize your numbers if you want to…

Copout picture

Using Excel

(Okay, this picture has nothing to do with today’s topic – it’s a copout picture. I’m still trying to set up this website and I am encountering a few problems due to learning to use this tool. And maybe I am being a little too ambitious on what I want to accomplish. Besides, sourcing pictures for…

Stack of books - so much to do, so little time

Managing 100+ Projects

 [divider]I once had 150+ projects…[/divider] When I joined this team, they had a lot of project work. At the time, they were mostly in the $10K range, with very few in the $1 million range. All project reporting and analysis were done by spreadsheets. So if you had 150 projects, you had 150 spreadsheets. One…