Track number of hours per developer per date
This is important to be able to calculate the amount of resources that are being utilized for a particular case and across cases and per customer. Also useful for Invoicing Customers.
Sounds like you need a pivot table:
I expect all the developers to use FogBUGZ every day and update the number of hours they have devoted to each case.
You link the data in FB to the excel spreadsheet like the article suggests. Then the data is only in FogBUGZ and the pivot table pulls it from there. They don't need to log it in two places...
Michael H. Pryor
I don't know the Database Structure of FogBUGZ but from the appearance it does not seem as if the number of hours elapsed is saved per developer per date.
You're right, we don't save the number of hours per day per person, only the total number of hours.
Fog Creek Home