Posts

Showing posts from 2024

Improving Urban Service Delivery with 3D Maps

Image
The 3D Map feature in Excel allows us to quantify parameters with context to their location. In the figure, below the feature has been used to calculate the volume of water stored in a peri-urban lake.   

PERT Simulations- How New Excel Functions Enable Transparency.

Image
We have been using complex statistical methods to answer questions like — what the probability of is completing a project in a given timeframe?   We employed the critical path method, incorporating weighted average task durations and the standard deviation of each task, utilizing the mathematical formulas presented in our Project Management course materials. The average project duration is the sum of all the average activity times along the critical path.   Knowing the average project duration and the variances of activities along the critical path allowed us to calculate the probability of completing a project using standard statistical tables.  If you are not well-versed in statistical concepts, the methods outlined in textbooks for project management may appear overly abstract and complex .  In many situations, considering the possibility of alternative critical paths becomes crucial. This can lead to additional abstractions, making it challenging to com...