In short
Use one row per stop visit. Mark whether it was held or canceled. On a held visit, enter zero when you counted none and leave a missing tally blank.
For each count, show the sum beside the number of held visits with an entry. That makes a partial subtotal easy to spot.
Download the blank statistics sheet (HTML) or download the completed example (HTML). Open either file in a browser. The completed sheet shows the four visits after the missing tally arrived.
What goes in one row?
At fictional North Green and Maple Square, we started with four visit records. Each row has a visit ID, stop ID, date, service status, person-visits and checkouts. North Green uses the same stop ID on both dates and a different visit ID each time.
Count one person-visit for each visit a person makes to the bookmobile. Count one checkout for each item checked out. Someone who visits and borrows three items adds one person-visit and three checkouts. A return visit on another date counts again in the person-visit column.
When does a blank mean you need to follow up?
- V01, North Green, Nov 3: Held. 8 person-visits and 14 checkouts.
- V02, North Green, Nov 10: Held. 5 person-visits. The checkout count is initially blank, so this row needs a follow-up.
- V03, Maple Square, Nov 4: Canceled. Both counts are blank because the visit did not take place.
- V04, Maple Square, Nov 11: Held. 0 person-visits and 0 checkouts. Both tallies were recorded.
Three of the four visits were held and one was canceled. Use the three held visits as the denominator for count coverage. Before the follow-up, the recorded checkout counts are 14 and 0. Their observed subtotal is 14 + 0 = 14 checkouts, with 2 of 3 held visits recorded. For the percentage, 2 ÷ 3 × 100 is about 67% when rounded to a whole percent.

What changes when the 9 checkouts arrive?
We entered 9 checkouts for V02 on the same sheet. The checkout sum became 14 + 9 + 0 = 23 checkouts, with 3 of 3 held visits recorded (100%). The person-visit count still reads 8 + 5 + 0 = 13 person-visits, with all three held visits recorded. Of that completed total, North Green accounts for 13 person-visits and 23 checkouts. Maple Square has one held visit with 0 of each, plus the canceled visit.



How do you check your own entries?
Fill in the visit ID, stop ID, date and status. Add rows for more visits. The blank sheet shows a subtotal and coverage for each count, both across the sheet and by stop. It lists held visits with missing counts. If a visit ID appears twice, the sheet pauses the totals until you fix the duplicate. Counts stay in the open tab, so print or save a PDF before closing or reloading it.
When not to do this
Use this sheet for aggregate counts with a recorded service status. Keep names and individual borrowing records out of the sheet.
How did we share the checked sheet in NOS?
In NOS we used Code to update the HTML, checked the row and totals in View, and opened Share to find the reader link. A signed-out browser could read the example at that address before and after the correction.

