Sample Worksheet for Microsoft Dynamics 365 Business Central
Ten samples measured on four fields is forty values. Typing them into separate lines, then calculating averages in a spreadsheet, separates the numbers from the decision they support.
Quality Inspector's sample worksheet is a grid for entering every sample against every field of a test. Statistics roll up to the test result, so the grade reflects all the samples.
How Sample worksheet works in Quality Inspector
- A test with a sample size is created, often through AQL sampling.
- The inspector opens the Sampling Worksheet from the test.
- Values are entered for each sample and field, with failures shown in red.
- Quality Inspector calculates statistics for each field.
- The test lines are graded from the summaries, and the test is finished.

Key capabilities
Grid entry
Each row is a sample and each column is a field from the template, so inspectors enter a full set of measurements in one place.
Failures stand out
Values outside the pass condition are shown in red, so the inspector sees a failing sample immediately.
Sample statistics
The test shows minimum, maximum, average, sum, variance, standard deviation, mode, the largest variance from the limit, and the first failed value.
Roll-up to the result
Each field's summary feeds its grade on the test, and the line grades decide the test result.
Consistent rounding
Set how individual samples roll up into sample summaries, so rounding is the same across reports.
See Sample worksheet on screen
Real screens from Quality Inspector, shown with demo data.
Details that matter on the floor
Voice-friendly
With hands-free value entry, an inspector can dictate several sample values for one field.
Statistics stay with the lot
The statistics are stored on the test, not in a separate spreadsheet, so they stay attached to the lot and document.
Who uses Sample worksheet
Quality control inspectors
Enter a full set of sample measurements quickly and see failures as they happen.
Quality assurance managers
Review sample statistics on each test before release.
Process improvement specialists
Use sample variance to spot unstable processes.
Questions about Sample worksheet
How do I enter multiple samples for one quality test in Business Central?
With Quality Inspector, open the Sampling Worksheet on the test and enter a value for each sample and field in one grid. Statistics roll up to the test result.
What statistics does the sample worksheet calculate?
Minimum, maximum, average, sum, variance, standard deviation, mode, the largest variance from the limit, and the first failed value.
Does the sample worksheet work with AQL sampling?
Yes. The sample size from AQL sampling sets how many samples the worksheet expects.
Related Quality Inspector features
All Quality Inspector features →Part of Quality Inspector
Streamline your quality control process to reduce rework and maximize customer satisfaction.
Have a question about Sample worksheet?
Send us a note and the Quality Inspector team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.
