Schedule Variance Formula

[JHaugland]

Does anyone have a simple excel tool to calculate schedule performance based on the number of days in a project, hours estimated and actual hours to date to show if a project is tracking to schedule, ahead or behind?

 

[6StringJazzer]

Hi StringJazzer,

I was referring to your example which you have provided on the link above. How is the billed hours formula derived as =ROUND(H2*(0.8+0.4*RAND()),0)

Can you help me understand please?

Thanks,
Mahesh

Just some random numbers to come up with some fake data for demonstration purposes. Nothing at all to do with a solution.