Commercial Pool Daily Log Sheet for Public Pool Operators

A public pool is a page-a-day document. The residential route log gets a row a week per pool; the commercial venue gets a whole sheet per day, with several reading rounds on it, a bather count that moves through the afternoon, a note of everything that went in the water, and somebody’s initials against every line. This is that sheet as one Excel workbook: seven tabs, blank, no signup, no email wall. Download it, keep one workbook per aquatic venue, and fill it in Excel, Google Sheets, or LibreOffice, or print the Daily log tab and clip it inside the pump room door.

The field set an inspector opens the binder to find

Free chlorine and combined chlorine as separate columns, not one “chlorine” box. pH. Water temperature. A flow meter reading or the filter pressures in and out. Whether the main drain or the reference tile was visible from the deck. The bather count at the time of the reading. Whatever was added to the water since the last reading. The time a backwash started and finished. Any incident, any interruption. Operator initials on every row.

That set is not invented here. MAHC 6.4.1.6A lists pH, disinfectant residuals, combined chlorine concentrations, recirculation pump and filter pressures or the corresponding flow meter reading, CYA where used, equipment maintenance and malfunction, water temperature where the venue is heated, the time of filter backwash or cleaning, calcium hardness, total alkalinity, the saturation index, microbiological testing where applicable, any interruption of circulation, filtration, or disinfection lasting more than an hour, and the daily attendance at the facility. The workbook gives each of those a column and the Read me tab prints the list in the code’s own order so you can walk down it.

Several readings a day, and which cadence yours is on

The number of rows a day is not a style choice, it follows the feed system. MAHC 5.7.5.1A puts free chlorine, combined available chlorine or total bromine, and pH before opening every day. MAHC 5.7.5.2 then takes a venue on a manual feed with no automated controller to a reading every 2 hours while open to the public, and MAHC 5.7.5.3 takes a venue on an automated feed system to every 4 hours. The Daily log tab ships fourteen reading rows, which covers a long day on the 2-hour cadence with room for the pre-opening round and a late check.

The readings that are not daily get their own tab rather than cluttering the day sheet: total alkalinity weekly (5.7.5.5), salt at least weekly where an in-line electrolytic chlorinator is fitted (5.7.5.11), calcium hardness (5.7.5.6), cyanuric acid (5.7.5.7, weekly where stabilized chlorine is the primary disinfectant per 5.7.5.7.2) and the saturation index (5.7.5.8) monthly, and total dissolved solids quarterly (5.7.5.9).

Every one of those figures comes from the CDC Model Aquatic Health Code, quoted by section, accessed 12 September 2026. The MAHC is a model code, not law in itself: states and counties adopt it in whole, in part, or not at all, and some adopted codes differ. Read yours. Where the two disagree, the adopted code wins, and this sheet has enough rows either way.

It records readings. It does not tell you what to add

There is no dosing math on this page and none in the workbook. The Chemicals added tab has a column for the product, a column for the amount, and a column for the reading that prompted it, and that is the whole of it: a record of what was fed, never a recommendation of what to feed. The product label and your operator training govern the rate, the handling, and the order of addition. The figures printed on the Read me tab, minimum free chlorine of 1.0 ppm without cyanuric acid and 2.0 ppm with it (5.7.3.1.1.2.1 and 5.7.3.1.1.2.2), 3.0 ppm in spas (5.7.3.1.1.2.3), pH held at 7.0 to 7.8 (5.7.3.4.1), and action to reduce combined chlorine once it passes 0.4 ppm (5.7.4.4.2A), are there so the reading and its reference sit on the same page, not as a target to chase.

Water clarity is a reading too, and it is the one operators most often leave off the sheet. MAHC 5.7.6.1 wants the bottom visible while the water is static at all times the venue is open, read off the reference tile or main drain, and 5.7.6.2 wants that reference point visible from any point on the deck up to 30 feet away in a direct line of sight. The same check sits in the pre-opening inspection at 6.4.1.3.1 item 21. One Y/N column per reading round, and a closure has a timestamped record behind it.

Where it sits next to the other commercial pool pages

The flow figure this sheet records only means something against a required turnover, and that is a different job done once: commercial pool turnover rate and bather load calculator takes the venue volume and the turnover its code requires and returns the GPM the recirculation has to deliver, plus the maximum bather load the same code implies. The commercial pool service pricing calculator is where the testing and log time on this sheet turns into a monthly contract figure, and the pool service agreement template is what puts that figure on paper. Winning the account in the first place is a separate exercise, and a record like this one is part of the pitch: how to get commercial pool contracts covers what each kind of venue is really buying, which is a documented pool its inspector will accept rather than a monthly price. For a residential route, the sheet you want is the weekly pool water chemistry log instead: one sheet per pool, one row per visit, and none of the bather counts, closures, or per-round initials a public venue needs.

How long the binder stays in the pump room is a question the model code answers and your regulator decides. MAHC 6.4.1.2.1 keeps aquatic facility records a minimum of 3 years and available on request by the authority having jurisdiction, and 6.4.1.2.2 adds that local, state, territorial, federal, or tribal law may require further records, documentation, and forms. Check the retention clause in your adopted code before you file anything away. Nothing you do on this page is saved to Fieldwynn: the workbook is a static file, and the only copy is the one you download.