Litter audit data sheet with a worked tally

Use the blank sheet to copy an existing survey record. The worked example shows how to keep a measured 0 g distinct from a missing weight.

In short

Give each survey area and date its own tally. Copy the count and weight for each category into separate columns. If a weight was omitted, leave the weight cell empty and mark it Missing. Add the supplied weights and show how many category rows that subtotal covers.

Download the blank litter audit data sheet (CSV) or download the completed Saltglass Beach example (HTML). Open the CSV in a spreadsheet to copy your own records. Open the HTML in a browser to compare the completed tally with the walkthrough.

What goes on a litter audit data sheet?

Start with the area and survey date on the record you received. We used Saltglass Beach, Area A, Nov 18, 2026, for this fictional tally. Repeat the area and date on each CSV row so the row stays tied to its survey if someone sorts the sheet. For another area or date, calculate a separate subtotal.

Copy each category name and its code, then add the count, the recorded weight in grams, and the weight status. The example uses local codes PF for plastic fragments, PA for paper, and MT for metal. Use the note column to identify the record you copied or explain why a weight is missing.

NOS View of the three Saltglass Beach category rows and initial totals
The original Area A tally shows 8 plastic fragments at 24 g, paper at a measured 0 g, and 2 metal items whose weight is missing.

How do you record zero and missing weights?

For paper, the source explicitly gives 0 items and 0 g. Enter both zeros and mark the weight Measured. The metal record gives 2 items and no weight. Enter 2 under Count, leave the numeric weight cell blank in the CSV, and write Missing under Weight status. The dash in the worked HTML marks that empty weight cell.

Add the counts first. The three rows give 8 + 0 + 2 = 10 items. The measured subtotal is 24 + 0 = 24 g. Two of three category rows have weights, including the measured zero. The one missing row accounts for 2 of the 10 counted items. Keep that gap beside the subtotal so a reader can tell how much of the tally it covers.

Reader view with 24 g measured across two category rows, with metal missing
The initial reader page reports 24 g across 2 of 3 category rows and identifies the missing weight for 2 metal items.

What do you update when a weight arrives later?

Match the new record to the original area, survey date, category, and count. In our fictional follow-up A-02, an entry dated Nov 19 supplies 11 g for the two metal items already counted in Area A. We used the document’s Code view to update the metal weight, its status, the measured subtotal, and the coverage line. The dated correction note keeps the missing weight traceable to the initial record A-01.

NOS Edit on the initial Saltglass Beach tally with the metal weight still missing
Edit opens the same Area A tally before the correction, with the metal count of 2 and a blank weight marked Missing.
NOS Code shows the audit HTML beside the initial worked tally
In Code, the tally’s HTML and preview are side by side. Check the Area A title and the metal row before changing the weight.

Reopen the tally and add the measured rows again. The subtotal becomes 24 + 0 + 11 = 35 g, and coverage becomes 3 of 3 category rows. The counts still add up to 10. Compare the plastic and paper rows with the original tally to check that their weights stayed at 24 g and 0 g.

NOS View after the metal weight is entered with a dated correction note
The corrected tally shows 11 g for metal and a measured subtotal of 35 g. The correction note identifies the Nov 19 follow-up.

When not to do this

Use this sheet to transcribe a tally you already have. For a program that requires its own categories or records, use the program’s materials. Litter Intelligence’s Beach Monitoring page lists its audit sheet among the resources for beach, freshwater, and stormwater monitoring. Its v3.2 audit sheet records counts and weights by category in grams and has a high or low confidence field for each weight. This example uses Measured and Missing to record whether a weight was supplied.

How did we check the correction in NOS?

In Share, we took the reader address for the Saltglass Beach tally. The panel said anyone with the link could read this page without signing in. We reopened the same address after saving and checked for the 35 g subtotal, all three weights, and the count of 10.

NOS Share panel with the reader link for the Saltglass Beach tally
The Share panel gives the reader address and displays the page’s link access setting.
The same reader URL after correction, showing 35 g and full row coverage
At the same reader address, the updated tally shows 35 g across 3 of 3 category rows and 10 items counted.

Questions people ask

Does measured zero count toward weight coverage?

Yes. The paper row has a recorded 0 g, so it counts as a row with weight. It adds zero grams to the subtotal.

What if none of the category weights are available?

Keep the item counts. For a three-row tally, report 0 of 3 rows with weight. Write “No measured weights” in place of a subtotal.

What if a supplied weight covers only part of a category?

Record which items the weight covers. Keep the covered items and the remaining items on separate rows with distinct notes, and make sure the two counts add up to the original category count.

Keep reading