This spreadsheet uses Excel PowerPivot and the Comsense Data Warehouse to show financial information for completed projects as well as fully billed projects 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.