Bowlers & Rink Usage — the monthly figures

Under Reports → Attendance → Bowlers & Rink Usage. The monthly return most clubs have always compiled by hand from the daily rink booking sheets and the sign-in book, worked out from the bookings themselves. Step back and forward a month at a time; there is a Print button for the committee pack.

How much of the green got used

Rinks Available is the number that matters, and the one that is easy to get wrong. It is not rinks multiplied by days. Each rink is counted once for every day a session actually ran — so a day the club is closed does not count, a session that only runs on Wednesdays only counts on Wednesdays, and a rink under a blackout is left out rather than counted as space nobody used. Any other way of counting it flatters the percentage, which is the figure a committee will actually argue about.

The columns are your own sessions, in your own order, shown as S1, S2 and so on with the names listed underneath the table. A session that did not run at all that month is left out rather than shown as four zeroes.

Who bowled

Total individual bowlers counts distinct people; Total number of visits counts attendances, so somebody who played eight times is one bowler and eight visits.

Advance and On-the-Day are split by when the booking was made against the day it was for — the one thing here that is genuinely recorded rather than inferred.

Common questions

Where do Coaching and Introductory Sessions come from?

There is no field on a booking that says what it was for, so these are matched on wording — the booking note and the session name. The words are yours to set under Settings → Booking Rules → Statistics wording, because one club’s “taster” is another’s “open day”. If these two lines read zero every month, it is almost certainly that nobody writes those words on the bookings rather than that the sessions are not happening.

Individual bowlers looks low against visits.

A booking where the players were never named is a headcount rather than a list of people. Those visits are counted, because somebody came; the heads cannot be, because we do not know whose they were. The note under the table says how many visits that affected. If the gap is large, it is worth asking members to name their players when booking — it also makes the steward’s sheet far more useful.

Why does the forward arrow stop at this month?

Beyond it the bookings have not happened yet, so the sheet would only ever be a table of future intentions. Use the availability diary for looking forward.

Our total days does not match the club's old spreadsheet.

Pavilion counts the actual days in the calendar month, then takes off the closed days and whole-green blackouts to get days open. A hand-kept sheet often counts only the days inside the playing season, which is why a March or an October can differ. The days open figure is the one to compare.

What counts as Sat / Sun PM?

A weekend booking starting at or after the time set for the weekend steward requirement, under Settings → Booking Rules. Changing that time changes what this line counts.

Are cancelled bookings included?

No. Only confirmed bookings count, in every figure on the page.

What does the printout look like?

Landscape, with both panels side by side exactly as they sit on screen — green headings, shading and all — under your club name and the month, with the session key and the note about how the figures are counted underneath. It prints only the report: none of the admin screen around it comes with it. Browsers normally drop background colours from a printout, so the sheet asks for them explicitly; if yours still comes out plain, look for a “background graphics” tick box in the print dialog.

Can I get it out as a spreadsheet?

Yes — Excel and CSV buttons sit beside Print, and both export whichever month is on screen. The Excel file is a real workbook with three tabs: the bowlers figures, the rink usage table, and a key saying which session S1 and S2 actually are. Numbers arrive as numbers and the percentages as plain numbers rather than as text, so a committee can total, average or chart a column without retyping it. The CSV has only one sheet to work with, so the three blocks run one after another with a heading and a blank line between.

There is no Excel button, only CSV.

Writing an .xlsx needs the ZipArchive extension, which almost every host has but not quite all. Where it is missing the button is left off rather than offering a download that would fail. CSV opens in Excel perfectly well; it just arrives as one sheet instead of three.

The pound signs look wrong when I open the CSV.

The file is written as UTF-8 with the marker Excel looks for, so it should open correctly by double-clicking. If you are importing it through Excel’s own text-import wizard instead, choose UTF-8 as the file origin.