All articles with 'planning' Tag

Formula Forensics No. 031 – Production Scheduling using Excel

Published on Oct 11, 2012 in Excel Howtos, Formula Forensics, Posts by Sajan
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

Continue »

A Gantt Chart Alternative – Gantt Box Chart

Published on Jul 9, 2010 in Charts and Graphs
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.

Continue »

Automatic Rolling Months in Excel [Formulas]

Published on Apr 6, 2010 in Excel Howtos, Learn Excel
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 […]

Continue »

Use burn down Charts in your project management reports [bonus post]

Published on Jul 21, 2009 in Charts and Graphs
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.

Continue »

Hong Kong – Made for tourists

Published on Jul 27, 2007 in Hong Kong, personal, travels

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 […]

Continue »

Start Early

Published on Apr 4, 2007 in Charts and Graphs, Learn Excel, personal finance

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 […]

Continue »

Making sense out of NEWsense

Published on Mar 30, 2007 in media, wonder why

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 […]

Continue »

Fresh MBAs and IT Companies

Published on Mar 30, 2007 in b-school

The combination sounds as inseparable as ctrl+c and ctrl+v. But when it comes to making a career choice there is a fair bit of confusion as to what an MBA will do in an IT company, especially in the first few years. Marketing companies have it easy, in the first 18 months, you would be […]

Continue »

Are fund managers poor marketers?

Published on Feb 20, 2007 in media, personal finance, wonder why

Come Ferbruary, every fund house worth its NAV comes up with a hoard of ELSS / Tax planning mutual fund offerings and promotions. These days you open any (business) magazine and you see atleast a dozen ads on how MFs can save you Rs. 33,360* or something on taxes. First up the claim that they […]

Continue »

Musings of a Married Manager

Published on Feb 5, 2007 in personal

“One Kg tamarind is Rs. 69? What the heck…! Has it always been this costly?” raced my mind through the grocery stand in the neighbourhood supermarket. “Lets buy this 2kg surf excel no? we get a bucket free” urged my wife. I mused for a while trying to keep me afloat in the fmcg quicksand […]

Continue »

10 good things about Seoul

Published on Jan 5, 2007 in Seoul

My stay here is coming to an end in the weekend. I would be back in Chennai to read Metroplus with a sip of strong decoction coffee on Monday morning. Aah, the joys of coffee and news. Even though I am not here as a tourist I could see quite a few places and interact […]

Continue »

Birds of different feather flock together

Published on Dec 31, 2006 in personal

Hello everyone, I am getting married to my engineering classmate, my colleague, the love of my life, Jyosthna on Sunday, January 21 @ Vizag. Do come if you are around at that time. Drop me a mail or ping me on mobile if you are planning to come. I shall guide you on how to […]

Continue »

Good news for Indian Movie lovers

Published on Dec 22, 2006 in Random

In a really interesting and smart move MoserBaer announced that it would soon enter VCD/DVD based movie segment by offering them at the price range of Rs. 28-35. I think its really good for everyone who likes movies. In the day and age of rampant piracy not many people are finding it easy to shell […]

Continue »

Google Life!

Published on Sep 13, 2006 in Random

Birth and Early Stages:> Look up for cool names in google> Post the newborn pics in orkut. Format them in Picasa. Share them with friends using Blogger School & College:> Use Gtalk to chat with friends. Bye bye bfone!> Goodbye to combined studies, welcome google groups.> Doubts about what is the latest ninth planet? may […]

Continue »

Orbit Musings and other things

Published on Aug 3, 2006 in Random

>>> How come chennai doesnt have any English / Hindi FM channels? I think (correct me) all other metros have them. The only FM channel where you can hear something in Hindi is All India Radio’s FM Channel. >>> I am planning to buy a TV. My budget is 10k. The TV must be flat […]

Continue »