Akram

This post details a procedure for creating a Hammock Task in Microsoft Project. A Hammock Task is a Task parallel to another set of Tasks but one that is constrained to have their same total Duration, no matter how that changes. It will have an “elastic” Duration.

We have an engineer working for 8 days starting on Monday. He/she will be staying in a hotel during the weekend. If the engineer starts work on Thursday, we will have 2 weekends. Also, if the duration of his/her work might change, so the number of weekends cannot be known in advance. We need a solution that allows us to charge hotel nights for all calendar days no matter what the duration or the start date of the engineer’s task is. Solution: Hammock Task.

At the heart of planning a project using Microsoft Project is the daunting responsibility of assigning Resources to Tasks. Worse still, try adjusting those assignments (both during planning and monitoring) and see what happens.
A confusing facility in Microsoft Project is the way Duration, Units of Resources and Work Loads per Task are interact with one [...]

Sensitivity Analysis is a term that conveys so much meaning it can easily be misunderstood. Most formulations in Excel are in the form of a computational flow from one input cell (or range) to another till we reach one (or more) result or output cells. If we have a portfolio model showing all our investments [...]

Excel 2003 does not use the overcharged term: “sensitivity.” Having avoided this trap, Excel falls into another. It has so many features that fall under Sensitivity Analysis that one remains ignorant of how much Excel can do in this area and where these facilities are.
For example, there is an entry on the Data menu called [...]

This post shows an example of NPV and IRR formulations using sensitivity analysis in Excel. Graphic representation show the cross over of NPV and hence give IRR directly.