dotnetdiva
Programmer
I need to calculate Total availability by Resource and Project from SQL. I read a post in a newsgroup that said total availability is calculated by Res_Max_Units X the resource calendar. My problem is this, I can find descriptions of the base calendars and manually calculate the number of minutes or hours in them, but I have been unable to find documentation how to calculate it from fields in the database. Does anyone know the field (or combination of fields) this is stored in and if it is necessary to use the MSP_Conversions table to convert it? I can find documentation on how to find & convert scheduled and actuals and the timephased data, but nothing on where the 'time in each Calendar' lives- ie 5 - 8 hour days would be 40 hours or 2400 minutes. I've looked at the db definitions of the fields in the msp_calendars (&data) and the msp_availability, but I have to admit I am stumped. The Resource Usage view in Project shows remaining availability so it must be stored somewhere (or calculated on the fly from some fields in the db) My company wants to calculate a % of scheduled/total availability in a Crystal report to measure how well their project managers are scheduling resources. We are using Project 2002 but not Server and we use the standard MSP tables in SQL2K. Thanks for any help.