All Project Managers Worksheet (PMW) line items from all cost centres can be downloaded, changed, and then uploaded from the Cost Centre Cost Reconciliation screen.
Download will display a spreadsheet with all PMW entries for all cost centres. These lines can be updated, or new lines can be added using a line no not already used for that cost centre. The spreadsheet is then saved to the desktop.
Selecting Upload will request a spreadsheet, and then upload to the PMW. There is an option in the upload to delete all existing PMW line items and replace them with the Line items in the Upload Spreadsheet.
The line number is used to match spreadsheet entries with those in the PMW. If a line no does not exist, then a new line will be created. To Add entries, insert a line, use a line number not already used for that cost centre, and enter the data.
Any entry in the spreadsheet without a line no is ignored. i.e. Summary Lines.
For Schedule of Rates projects, the line number may not be unique, so the schedule sequence no is used with the line number to match existing PMW entries.