Master Data Center

Internal Company Sites

Production workflow for the Overberg Agri Site List. BOS reads the real regional matrix workbook, prepares a Google Sheets Working Paper and imports only approved rows.

Sprint 04 · Production validation

Profile rules

Overberg Agri Site List

  • CompanyOverberg Agri
  • Trading NameSite Name
  • Company RoleInternal
  • Company AccountSite Code
  • Closed SitesInactive companies
1. Select source fileUse the original Overberg Agri Site List workbook. No reformatting required.
2. Create Working PaperBOS archives the original file, extracts the sites and creates the Google Sheets review workbook.
3. Review and approveOpen the Working Paper, check New, Changed, Unchanged, Conflicts and Errors, then approve only the rows to import.
4. Import approved rowsOnly approved Site List rows are imported. Conflicts, errors and unchanged rows are blocked by policy.

Create Working Paper

Site List source file

After processing, BOS opens the Google Sheets Working Paper. Keep the source file unchanged.

Artifacts

What BOS stores

  • Original uploadArchived to Google Drive.
  • Working PaperDashboard and BOS Approval tabs.
  • Approved copyGenerated after import.
  • Audit reportGenerated after import.