Lets take a break from all the Excel trickery. Today I want to share a joyous news with you all.
Today I want to take you back in time, all the way to 1987. I want to share a story with you. So, sit back, sip some coffee and enjoy.
Year 1987 and aftermath
My dad is working as a sales manager back then. He is a quintessential salesman. Busy, flamboyant, confident, tall & fun. I remember him very vaguely now. But I remember having lots of good time at family dinners (we are a family of 5 – my younger brother, mom, dad, dad’s mom & myself). I remember riding his scooter on trips to my school, family clinic or just around the corner.
Then, as if someone shook us from a dream and took everything away, my dad suddenly passed away in the summer of that year. He had a fatal liver failure.
It was a big shock for all of us, especially my mom, who had been married to him for 7 years. My mother studied only up to Class 12. She did not have any job skills back then. On top, she is burdened with 2 little kids (my brother is 5 and I was 6 at that time). We did not have money, house or any other type of assets.
So we moved to my mother’s mother house. My grand parents were kind enough to support us in those dark years.
With in a few years we started getting regular pension, thanks to my dad’s life insurance. This gave a sense of financial security and freedom to us. But, we still felt one gnawing pain. We did not have a home to live.
Between 1990 and 2006, we stayed in 8 different houses. This constant shifting & lack of security bothered my brother and me very much.We decided that, we would get a house as soon as we can.
In fact, I even said to myself that I would not get married before owning a house.
Fast forward to 2000s
So I wanted to own a house, before building a family. But then, I met Jo, we dated for a few years, realized that we are perfect for each other. We could not imagine living without each other. So we got married in year 2007. There was still no house.
Meanwhile, housing prices kept on raising and made my dream almost impossible to achieve without a back breaking mortgage loan. So I kept saying myself, “let me work hard for a few years, save money and then, we will get a house.”
In year 2009, we became parents to a set of lovely, naughty and adorable twins. Nakshatra (girl) & Nishanth (boy) transformed our lives in ways we could not imagine. While the joys of parenting are overwhelming, I was worried all the time about the house. “What if something bad happens and we end up without a home.”
Still we kept saving and living frugally.
Enter 2011 – In search of a house
Since we are against loans (see note 1), we waited until we have enough funds to purchase the house we want. Finally, by March 2011, we reached that stage. So we started looking for a suitable house.
We went to property fairs, told everyone in our immediate social circles, approached agents, pored thru classifieds and online ads. Very soon, we are very tired and felt hopeless.
Good houses almost always have exorbitant prices
Bad or poor houses are over priced too.
We almost gave up and decided to live in a rented house for few more years. But then, a neighbor told us about a house that is up for sale, in the locality where we live. I went and checked it out on the same day. I liked it. It seemed like a house we could call home.
Few days later, we visited the house again. This time with Jo & kids. We liked the space and calm neighborhood. We discussed with a few relatives & friends and made an offer to the owners. After some negotiations, we purchased the house on 26th July, this year.
Then we started renovating the house. It took 2 and half months to get everything done. We have remodeled the kitchen, done wood-work (cupboards), changed flooring, added a car park, store room, upgraded some of the electrical & plumbing fixtures.
Finally, we moved in to the house last Saturday (15th October) and loving it ever since.
Details & Photos of our home
- Total land area: 350 Sq. Yards (292 sq. mts)
- House carpet area: 1000 Sft (92 sq. mts)
- Rooms: 2 bedrooms, living, kitchen, storage, 2 bath & toilets
- Purchase price: ~ $100k
- Location: Vizag
These photos were taken on October 3rd, when we had the traditional Gruha Pravesham (it is like house warming celebration). So you so almost no furniture. The photo of my office room is taken today (October 20th).
Our Living Room
This is our Kitchen
My Office Room (doubles up as guest bedroom too)
Our Living room from Kitchen
Entering our House (Gruha Pravesham) with a Ribbon Cut
Jo and I in our Kitchen
For more pics, checkout New Home Set on my Flickr page.
Thank you & Thanks to Excel
As we live, breathe, enjoy and sleep in this home, I could not thank enough for your support in making this happen. I am so glad you identify with the mission of Chandoo.org and spread a good word about it. I am so humbled that you support us by joining our training programs, purchasing our e-books & products. I am so thankful to you for spending time with us everyday, learning & sharing new things.
Thank you.
I am also thankful to MS Excel, the powerful, awesome tool that transformed my life. It gave me the courage to quit a comfortable job and embark on an exciting journey of running a small business. Thank you so much Microsoft & Excel for being awesome.
One last thing
There is a reason why I am writing this today instead of last Saturday, when we moved in to the new home. Today (Oct 20) is also my birthday. As I celebrate my 29th birthday, I feel immensely grateful, content and happy for the journey so far. The fact that I can share my life, knowledge and mistakes with you all makes me very lucky. I hope the coming years are just as wonderful for you and me.
PS: because of the house renovation work during last 8 weeks, I could not reply to as many emails as I want to. So if you are one of those who mailed me and never heard back, please resend and I will get back to you at the earliest.
More Personal Stories
If you would like to learn more about the personal side of Chandoo.org, have a read thru these,
- Story of Chandoo.org Start-up
- Thank you Excel, We have a car
- How Excel Transformed my life (story of 1 year of running Chandoo.org)
- Christmas & New Year Wishes – 2011
- Meet Nakshatra & Nishanth – our kids
- I am Dad!!!
Added later:
Note 1: As some of you pointed, I did have a mortgage loan (which has 2 more months on it). I borrowed this year 2007 for an apartment (condo) I purchased for my brother. Even though that house is not for me, I still pay the loan as I love my brother and want to support him.
Note2: Our new home is in Vizag, the same place where we have been living for last 2 years.
15 Responses to “A Gantt Chart Alternative – Gantt Box Chart”
That's a great idea.
Maybe the planned End Date should be highlight more.
I don't know how it would look like (nor how to do it yet), but what if instead of finishing the bold line to the best case End Date, it finishes to the realistic End Date?
The idea is ok, I think other project management tools have this, already? Maybe not.
Gantt charts in my view are about the signal most unless thing in the world, theres no way you can look at one thats more that a little complex and understand what it's telling you. I'm going to write a diatribe on project management at some point, its one of my pet areas I think!! 😉
The issue I have with this chart Chandoo, is that Tasks need to be linked to each other, so they should inherit the uncertainty, which would mean the as you moved down chart the lines would be miles apart for later tasks, and you might have to add lots of lines for subsequent tasks to cover the various outcome of it's parents.
Having said that, for the high level board summary, it's a nice way to go, it it appeals to the management 😉
thanks Chandoo, great post.
Ross
Whoooa !!! That's a very clever idea Chandoo. I really love it.
I think i'll update my gantt project sheet with that idea soon (remember my template ?)
@ross : you can link start date to the end date of the previous task in your data. The only problem I still se is to which end date (real ? planned ? best ?) in order to have average amount of information.
If best end date, you'll tend to increase uncertainty at the end of chain, although if you link to real end date, uncertainty will be decreased too much, leading in both cases to wrong management direction.
Maybe planned till the task is finished then real will do the job ?
Hey chandoo, this looks good and this would definite add value in production planning / scheduling. Uncertainity in finishing a task is very high in production scheduling and this could give an insight or a bird eye view of possible shipments we can have....
I've always been frustrated by the limitations of gantt charts. Will definitely use this, I've always struggled with how to succinctly communicate the uncertainty of certain tasks without confusing stakeholders.
I like this, I think it's a very effective way of showing how a timeline can change and which parts of a project need close attention.
@Cyril / @Ross: I would intially link the the start date to the planned end date of the previous task, with the chart updating when a task has been completed to reflect the true end date.
Or what about giving a drop-down selection box to allow the user to see the chart based on planned/best-case/worst-case end dates?
Like the idea. Have found that Excel is more flexible than MS Project for graphical solutions. The "Best Case"\"Worst Case" metrics are theoretically appealing but once the project and\or phase commences their reliability diminishes. A chart like the above that showed Planned Start, Planned End, Replan End Start, Replan End Date, Number of Replans the Start and End Dates, and Actual would provide an active, actionable view of each task\phase. It would also highlight the areas which are riskiest.
It is always amazing how flexible excel can be.
My question is how would the chart show a scenario where the date moved up? If a task is dropped or the duration of the task is significantly reduced by applying more people or machinery to the task, the dates will move up.
The gantt chart has been around for a long time, but it is still quite useful to show progress.
Cheers,
B
I like the idea but seems bit complicated in case of long projects involving numerous activity.
Also, reading and explaining is required hence not feasible where plans are just send to audience for approval.
Cheers
SY
Great idea Chandoo,
When I was reading this idea regarding delivery dates, another thought popped into my mind, how can you show the uncertainty with MONEY!!
In this case, applies to cost management or even a normal budget, you think?
Would Box Chart and Gannt Chart help to understand the best case, middle case and worst case when money is spend or planned with these three risks are involved?
I imagine that this chart could help people who write their budgets get a better understanding of risks affecting their spending.
Peter
Chandoo,
I like it. How would you display an entry once it has been completed (actual)?
Thank you,
Matt
From what you have shown so far I think that this box Gantt chart is awesome! I think that this could be an extremely useful tool.
I can't wait to learn how to make my own charts in Excel.
Will the methods that you are going to teach us work in 2003 as well?
[...] Firday, we proposed a new chart for showing project plans. I chose an ugly name for it and called it Gantt Box [...]
You need to read Eli Goldratt's Critical Chain. The uncertainty you are looking for should be accounted for in a project buffer. Not at each task level.
Further you should spend time understanding Agile Development. This would have you plan only in 1-3week iterations. This allows you to embrace changes to work not yet started, and for your customer to re-direct your course at regular intervals (after each iteration) throughout your project. keyword search: Agile Scrum
These items will show you that you are solving a tracking problem for something that you can entirely avoid!
[…] Chandoo.org’s Gantt Box Chart. […]