Variance Report - Data Fields

In Projector a data field represents the information that you are interested in. For Excel Pivot Tables this information can be cross-referenced by the row and column fields to compile the data. In this image you see project profit organized by project name and month. Project Profit is the data field. Project Name is the row field. Month is the column field. If this sounds confusing, read our introductory article on pivot tables.

Data Fields

Field	Field Category	Description
Billing Adjusted Revenue Booked	Revenue Fields	Billing Adjusted Revenue
Billing Adjusted Revenue Reported	Revenue Fields	Reported Billing Adjusted Revenue
Billing Adjusted Revenue Variance	Revenue Fields	Reported - Booked Billing Adjusted Revenue
Billing Days	Hours Fields	Number of billable days. Useful when you use daily billing.
Contract Revenue Booked	Revenue Fields	Booked Contract Revenue
Contract Revenue Reported	Revenue Fields	Reported Contract Revenue
Contract Revenue Variance	Revenue Fields	Reported - Booked Contract Revenue
Net Available Hours Booked	Utilization Fields	= Booked Working Hours - Booked Utilized Hours (can be positive or negative)
Net Available Hours Reported	Utilization Fields	= Reported Working Hours - Reported Utilized Hours (can be positive or negative)
Net Available Hours Variance	Utilization Fields	= Net Available Hours Reported - Net Available Hours Booked (can be positive or negative)
Normal Working Hours	Hours Fields	Expected working hours without holiday or other timeoff hours being deducted.
ODC Client Planned	Cost Fields	Planned ODC paid by client
ODC Client Reported	Cost Fields	Reported ODC paid by client
ODC Client Variance	Cost Fields	Reported - Planned ODC paid by client
ODC Expense Planned	Cost Fields	Planned ODC absorbed by company
ODC Expense Reported	Cost Fields	Reported ODC absorbed by company
ODC Expense Variance	Cost Fields	Reported - Planned ODC absorbed by company
ODC Planned	Cost Fields	Planned Disbursed ODC
ODC Reported	Cost Fields	Reported Disbursed ODC
ODC Variance	Cost Fields	Reported - Booked Disbursed ODC
Person Hours Booked	Hours Fields	Booked work hours.
Person Hours Reported	Hours Fields	Reported work hours.
Person Hours Variance	Hours Fields	Reported - Booked work hours
Resource Direct Cost Booked	Cost Fields	Booked Resource Direct Cost
Resource Direct Cost Reported	Cost Fields	Reported Resource Direct Cost
Resource Direct Cost Variance	Cost Fields	Reported - Booked Resource Direct Cost
Resource Equivalents Booked	Utilization Fields
Resource Equivalents Reported	Utilization Fields
Resource Equivalents Variance	Utilization Fields
Standard Revenue Booked	Revenue Fields	Booked Standard Revenue
Standard Revenue Reported	Revenue Fields	Reported Standard Revenue
Standard Revenue Variance	Revenue Fields	Reported - Booked Standard Revenue
System Revenue Booked	Revenue Fields	Booked System Revenue
System Revenue Reported	Revenue Fields	Reported System Revenue
System Revenue Variance	Revenue Fields	Reported - Booked System Revenue
Utilization Basis Hours Booked	Utilization Fields	In capacity mode it is Normal Working Hours - Holiday Hours - Scheduled Timeoff Hours. In yield mode it is the same as RDC Basis Hours. See on-line help for more information about RDC basis hours.
Utilization Basis Hours Reported	Utilization Fields	In capacity mode it is Normal Working Hours - Holiday Hours - Actual Timeoff Hours. In yield mode it is the same as RDC Basis Hours. See on-line help for more information about RDC basis hours.
Utilization Basis Hours Variance	Utilization Fields	Reported - Booked utilization basis hours
Utilization Booked	Utilization Fields	= Booked Utilized Hours / Booked Utilization Basis Hours
Utilization Reported	Utilization Fields	= Reported Utilized Hours / Reported Utilization Basis Hours
Utilization Variance	Utilization Fields	Reported - Booked utilization
Utilized Hours Booked	Utilization Fields	Booked hours spent working, e.g., project hours
Utilized Hours Reported	Utilization Fields	Reported hours spent working, e.g., project hours
Utilized Hours Variance	Utilization Fields	Reported - Booked utilized hours
Working Hours Booked	Utilization Fields	= Normal Working Hours - Booked Holiday Hours - Booked Timeoff Hours
Working Hours Reported	Utilization Fields	= Normal Working Hours - Reported Holiday Hours - Reported Timeoff Hours
Working Hours Variance	Utilization Fields	Reported - Booked working hours