Lot Quality Assurance Sampling Excel Spreadsheets

In by Marc Pitre

The LQAS Excel Spreadsheets are designed to provide all of the calculations needed to determine if each Supervision Area (SA) has met the Decision Rule (DR) for every indicator entered, as well as calculating the average coverage for the entire project area (all Supervision Areas combined). Simply list each indicator collected in the data entry tabs, and then enter the responses for each indicator. The spreadsheet then automatically calculates the Decision Rules, whether each SA has met the Decision Rule, and the average coverage for each indicator, and the results are displayed in the LQAS summary tabs.

LQAS Excel Spreadsheets