In order for you to create your project’s Schedule of Values (SOV) and track SOV billing, the Spitfire Project Management System (sfPMS) provides a Pay Application Doc Type. Pay Application documents open the SOV workbook – a workbook combining the project-specific data stored in sfPMS with the user interface, data manipulation, and data presentation strengths of Microsoft Excel.
The SOV workbook has several worksheets. These worksheets are password protected to safeguard calculations and prevent unintentional deletions. The SOV workbook is loaded via the web connection from the server. There is no local copy of the SOV workbook. Project-related data is retrieved from and saved to the SQL database. No data is saved with the SOV workbook. For this reason, you should never use Excel’s AutoRecovery feature for the SOV workbook.