Jump to content


Start a free course now!

Replying to Learn Excel Expert Skills 2016 Project Mgmt


Post Options

    • Can't make it out? Click here to generate a new image

  or Cancel


Topic Summary

Mike

Posted 25 June 2018 - 09:56 AM

Hi Nat,

 

We're currently in the process of reviewing the Expert Skills book for the next edition and you're absolutely correct that the existing formula can result in tasks finishing before they begin. An IF function like the one you suggest would prevent this from happening, and we'll revise the lesson to note this.

 

This change still isn't completely ideal, as the workbook is only set up to track full days. If you did have a situation where tasks were regularly finished in shorter times, you would probably want to set up a workbook that tracked tasks by hour instead of by day, so that multiple tasks could be assigned to the same day.

 

Excel isn't really designed for complex project management tasks, so you would probably turn to Microsoft Project for a full-featured project management tool instead of trying to create Excel formulas to do the same task.


Posted 10 June 2018 - 06:36 PM

Great books, my third one!

 

On page 123 the formula for End Date does not appear to be correct if the Units exceed the Work.  For example, if 16 workers are set to Dig Foundations (Work = 8) they finish before they begin.  Perhaps =IF(B4>(B4+C4/D4-1),B4,B4+C4/D4-1)?

 

Thank you!


Review the complete topic (launches new window)