This workbook is designed to track and analyze estimator performance, focusing on how effectively estimators convert estimates into jobs, and the associated revenue metrics like sales and average claim severity.
The severity sheet is made to collect the data. It includes automatic calculations and colors to highlight the highest to the lowest conversions for easy navigation.
That chart sheet breaks down the data into a chart for esay viewing. 
Both options were created for the owner/manager to be able to choose their personal visual option.