VOST Workbook Template Quickfix for Total Effort Hours

NOTE: This post is now obsolete, as I have released Version 4.0 of the Workbook and the formula has been corrected in that version.

Jeff Phillips noticed on a recent deployment that, somehow, the hours were not calculating properly in the total FTE box. I’m not sure why it doesn’t work that way anymore but I managed to fix it on the fly.

I will be releasing a new version this week, as I have added a staff availability calendar to the template. In the meantime, though, Caz Milligan used the workbook template for EQNZ last night and had the same problem, so here is the updated formula for the Check In/Out sheet, cell H3. Copy this formula, paste into cell H3, and hit Enter/Return on your keyboard and that should fix it. If not, please leave a comment and I’ll see what’s going on:

=(sum(E6:E199))*24

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s