This spreadsheet uses Excel PowerPivot and the Comsense Data Warehouse to show financial information for completed projects or sales orders as well as fully billed projects and sales orders that are not yet marked as completed.
See the article Setting the Data Source for Excel PowerPivot Files to connect this file to your data.
Only certain editions of Excel include the PowerPivot feature see this article on PowerPivotPro for more info.
To enable the Excel PowerPivot feature see Microsoft's instructions here.
Dec 6, 2017 - Updated attached spreadsheet to correct Margin percentage calculations.
Nov. 15, 2021 - Updated attached spreadsheet to include sales orders information.