Specific instructions for Broken Silence Statements

Broken Silence

To correctly process the sales data, follow these steps:

1. Open the CSV file in spreadsheet software such as Excel, LibreOffice, Numbers, etc.
2. Locate the “summary physical sales” block by finding the exact row that contains the following label: "summary physical sales"
3. Keep only the relevant block by starting from this row (inclusive), keep all subsequent rows, including the column headers and all data belonging to the "summary physical sales" section.
4. Delete all unrelated rows
   1. Remove all rows above the "summary physical sales" block, including all previous sections such as national, international, and digital statements.
   2. Remove all rows below the last line of data from the "summary physical sales table (usually right before the "statement digital" section or any trailing empty rows).
5. Save the cleaned file in UTF-8 CSV format, using the same delimiter as in the original file (typically a comma or tab).

The saved file is now ready to be uploaded to Reprtoir.

Additional Notes

• Do not modify the column headers in the “summary physical sales” block.
• Ensure that the final file contains no empty rows or unrelated content before or after the table.
• The resulting CSV must be structured as a clean, tabular dataset, ready for import or parsing.