B514_Att_06_Schedule_of_Values.xlsx

This is a Schedule of Values (SOV) template used for tracking subcontract invoicing and performance on the Building 514 Subfloor Removal & Epoxy Floor project at NUWC Keyport, Washington. The document is designed as a blank template with multiple identical tabs (SOV, MU, and Final) that subcontractors populate to submit monthly invoices and track earned value against budgeted costs.

The SOV template contains 75 activity line items organized by cost categories: Labor (column a), Materials (column b), Equipment (column c), and Bond/Insurance (column d). For each activity, the subcontractor must enter a percent complete (column e), which is multiplied against the total budgeted value (column f) to calculate the earned value to date (column g). The template automatically calculates the previous payments (column h), current billing amount (column i), and amount remaining (column j). The first two rows are fixed entries for Bond and Special Insurance. Instructions embedded in the template direct users to copy column g values to column h using the "Paste Special - Value" feature when updating for subsequent invoices, then update the percent complete percentages for each activity. All values currently display as $0.00, indicating this is a blank template awaiting population with actual project costs and progress data. The template requires completion with invoice number, subcontractor name, address, location, and invoice date information at the top.