Formula Forensics No. 031 – Production Scheduling using Excel
Your the production manager and have a need to schedule uneven resource across uneven requirements, how can you do that?
Well today we’ll look at Resource Allocation and Scheduling using Excel to do the hard work
A Gantt Chart Alternative – Gantt Box Chart
Traditional project plans use Gantt Charts to depict the plan. While gantt charts work great and provide instant picture of overall plan, they fail to communicate the uncertainty in the plan. In most real world projects, the plans always change. Most of the management energy is spent on controlling and communicating about this plan uncertainty. This is where a project plan like gantt box chart can help. This chart (as shown above) clearly shows the variance in end dates of project tasks thus giving a clear picture of uncertainty in the plan. Read more to find out how this chart can be used in project management.
Automatic Rolling Months in Excel [Formulas]
Often when we are making spreadsheets for forecasting or planning we would like to keep the starting month dynamic so that rest of the months in the plan can automatically rolled. Don’t understand? See this example: This type of setup is quite useful as it lets us change the starting month very easily. We can […]
Use burn down Charts in your project management reports [bonus post]
A burn down chart is a good way to understand the progress of a project. It is like a run chart that describes work left to do versus time. In this tutorial we will learn how to make a burn down chart using excel. This is a bonus installment to the project management using excel series.
Hong Kong – Made for tourists
I couldnt really get enough time to sit and write a lengthy post on HK till now. The visit has been completely hectic whether its the meetings with the client or roaming the bustling Hong Kong streets. Finally I am coming back to India today. Fortunately I came a little early to the airport (well […]
Start Early
Financial freedom, or not having to work for someone is the ultimate dream for anyone wearing an access card and refreshing his/her mailbox every five minutes. Just incase you are one of those who never realized the importance of planning early for the freedom, here is a chart to help you appreciate that need. Download […]
Making sense out of NEWsense
Imagine a kid having this conversation with his mom,“Mummy, mummy, tell me when will some one run a marathon in space?”“It will happen when Mumbai university lists in BSE”“Mummy, mummy, tell me when will the university list in BSE?”“They will list when Rakhi Sawant looks like this”“Mummy, mummy, tell me when will Rakhi Sawant dresses […]