I thought I saved the data in the data tab and the names in the formula tab.
then the days with the categoreis of rts, rev-rts, rev-nrts and nrts.
I had to cut out a lot of the days so that I could make the file small enough for it to upload.
This was quite difficult.
the field under OPD is where it should calculate the average after counting the orders and the days.

I believe I left 3 days, 2 where the employee worked and 1 where they didn't.
Since I have chopped that one to bits you can add anything you like or delete or move.. etc.

However notice how the blue line.. that should extend from their name is the total for each column that contains the catagories. I was trying to use these totals to calculate the average.

I wish i could have uploaded the whole thing to give you a better view of what I am talking about...


grrr.. sorry