Excel Gurus... Help me out

[bassoprofundo]

Ok, my Excel skills have atrophied greatly over time, and I need some assistance. Here's what I want to do:

I have x number of test cases to run over y number of days, and I output a daily status report with percent executed, passed, blocked, etc. On the report, I need a cell with a function to tell me what percentage I'm ahead or behind schedule based on the current date.

Anyone have suggestions for how best to accomplish this? TIA!

 

[Binky]

Here's one way to do it on a single sheet that is updated daily.

List all of the dates from beginning to end in colum A.

Use column B to enter test cases run on each day. Enter these daily as you progress. Leave all future days blank (not zero, blank).

Cell A31 formula to show percent of scheduled work
=SUM(B1:B30)/100/(COUNT(B1:B30)/COUNT(A1:A30))

This assumes a hard-coded 100 test cases needed to be completed in 10 days. The 10 days comes from the counted date cells. If you want, you can type in more dats and it will automatically update (e.g. you decide to work a weekend).