NZP&M Production Data Reporting Template

Overview

The NZP&M production data reporting template (PDRT) is a standardized Excelbased tool created to capture, validate, and share productionrelated information for the NZP&M project. It is intended for use by all subcontractors, plant operators and reporting engineers who need to submit daily, weekly, and monthly production metrics.

By consolidating data into a single, welldefined format, the template helps stakeholders compare performance across sites, spot trends early, and support decisionmaking for resource allocation and process optimisation.

Template Structure

The template consists of four main worksheets:

• Cover Sheet Project title, reporting period, contact details and a quick summary of key figures.
• Production Data Detailed linebyline production numbers, including raw material input, conversion rates, and product output.
• Quality & Safety Records of product quality tests, deviations, and any safety incidents that occurred during the reporting period.
• Signoff & Notes Space for reviewer signatures, comments, and an audit trail of changes.

Each worksheet follows a set of naming conventions and data validation rules to minimise entry errors.

Key Columns in the Production Data Sheet

How to Use the Template

1. Download the latest version from the project portal. Ensure you have the macroenabled (.xlsm) file if you need the automatic calculations.
2. Populate the Cover Sheet with the reporting period, your contact details and a short narrative summarising the overall performance.
3. Enter daily data in the Production Data sheet. Use the dropdowns for shift and plant ID to keep entries consistent.
4. Run the builtin validation macro (Data Validate). The macro checks for missing dates, outofrange values, and mismatched totals.
5. Complete the Quality & Safety worksheet by copying the results of any lab tests or incident logs that took place during the period.
6. Review and sign off on the Signoff sheet. The designated reviewer adds their name, date and any comments.
7. Submit the file via the secure upload link before the deadline.

If you encounter an error message from the macro, the workbook will highlight the offending cell in red and provide a brief description in a popup window. Correct the data and rerun the validation until the workbook reports No errors found.

Example Entry

Below is a sample row that illustrates a correctly completed entry for Plant01 on 15April2026, ShiftB:

The Yield column is automatically calculated by the macro, so you do not need to type a value manually. If the calculated figure falls outside the 0100% range, the macro flags the row for review.

Frequently Asked Questions

• Can I add additional columns? Custom columns are allowed only on a separate Extras sheet. Adding or removing columns on the core worksheets will break the validation macro.
• What file format should I use? The project requires the macroenabled .xlsm format. PDFs or CSVs are only accepted for archival purposes after approval.
• Who validates the data? The regional data manager runs a secondary audit after submission. Any discrepancies are sent back to the reporting team for correction.
• Is there a limit to the amount of data? The template supports up to 31days of daily entries per sheet. For longer periods, create additional worksheets labelled Week2, Week3 etc.