Broken Silence
Specific instructions for Broken Silence Statements
Broken Silence
To correctly process the sales data, follow these steps:
- Open the CSV file in spreadsheet software such as Excel, LibreOffice, Numbers, etc.
- Locate the “summary physical sales” block by finding the exact row that contains the following label: "summary physical sales"
- 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.
- Delete all unrelated rows
- Remove all rows above the "summary physical sales" block, including all previous sections such as national, international, and digital statements.
- 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).
- 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.
Updated about 6 hours ago