Skip to content
Quality Inspector app iconQuality InspectorSampling

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

  1. A test with a sample size is created, often through AQL sampling.
  2. The inspector opens the Sampling Worksheet from the test.
  3. Values are entered for each sample and field, with failures shown in red.
  4. Quality Inspector calculates statistics for each field.
  5. The test lines are graded from the summaries, and the test is finished.
Video thumbnail: Collect multiple samples with the sampling worksheet in Quality Inspector
Collect multiple samples with the sampling worksheet in Quality Inspector For quality teams that measure several samples per field and want sample sizes and rejection points to come from their sampling plans. Transcript and details →

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.

Quality Inspector app icon

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.

Ask a product question

Product Questions