Jump to content

Learn Excel Expert Skills 2016 Project Mgmt

1 reply to this topic

#1 Guest_Nat_*

  • Guests

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!

#2 Mike


    Advanced Member

  • Administrators
  • 190 posts

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.

Mike Smart is the author of ten world best-selling Excel books. The books are available in printed form for for Excel 2007, Excel 2010, Excel 2013, Excel 2016 for Windows and Excel 2016 for Apple Mac. Mike has also recorded over 850 video lessons (that you can watch online) for Excel 2007, Excel 2010 and Excel 2013.
Mike Smart is also part of the team that answers questions posted on the ExcelCentral.com forums.

Reply to this topic


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users