C7_Att06_Schedule_Of_Values.xlsx

This is a Schedule of Values (SOV) template used for invoicing and contract performance tracking on a subcontract for Building 514 Crane Rail Cross Bracing Installation at Naval Undersea Warfare Center (NUWC) Keyport, located in Building 514, Keyport, Washington. The template is designed to track project activities and associated costs broken down by labor, materials, equipment, and bond/insurance categories. The spreadsheet contains 75 line items for individual activities, with each row capturing the activity description, quantity, cost components, percent completion status, budget value, total earned to date, previous payments, billing amount for the current period, and amount remaining. The template includes specific columns for calculating earned value based on percentage completion (Column G = Percent Complete × Budget Value), tracking cumulative invoicing (Column H = Previous payments), and determining the current billing amount (Column I = Current earned value minus previous payments). The instructions indicate that users should update the percentage complete for each activity in Column E and utilize Excel's "Paste Special" value feature to transfer current earned values to the previous payment column when preparing subsequent monthly invoices. The template includes reserved rows for bond and special insurance costs, both marked "do not delete." All values currently display as $0.00, indicating this is a blank template awaiting project data entry and cost allocation by the subcontractor performing the crane rail installation work.