How to review answers, payments and ratings in Advanced mode

Once entries arrive, you need the answers in one place: how many dinner tickets to order, who needs the hoist, which boats still owe money, whether every handicap boat has a rating. Advanced mode shows all of it in one spreadsheet, and lets you edit many entries at once.

Boats and Sailors

Switch between two views at the top left:

• Boats: one row per entry, with sail number, boat, skipper and class, then Owed, Paid and Balance, a column for each question answered once per boat, and the class's rating (for example Portsmouth Yardstick number).
• Sailors: one row per person, with their boat and role (skipper or crew), and a column for each question asked of each sailor, follow-ups included.

Committee-only questions are marked in their column heading. A Totals row adds up the columns that have totals, such as the number of dinner tickets and what they are worth, or how many sailors answered Yes.

Find what you need

• Columns chooses which columns to show.
• Each column heading can filter and sort.
• Search entries finds a boat, sailor or answer.
• Unpaid shows only entries with a balance still due.

Edit answers in place

1. Click a cell and change the answer.
2. The change goes through the same checks as the entry form; a quantity can't go over its most per answer, for example.
3. It saves straight away. If you change a quantity, the entry is re-priced: for example, a third dinner ticket turns NZ$210 owed into NZ$260.

To record a payment, open the entry from the Entries tab and use Mark as paid.

Ratings

For classes scored with a rating system, Advanced mode shows each boat's rating in a column named after it, for example Portsmouth Yardstick number or your own rating name. You can:

• Spot boats with no rating yet. A finisher without a rating stops that race's results from being published until one is entered (see scoring warnings).
• Correct a number a sailor entered. Changing a rating recalculates the class's finished and published races.

More on ratings, including how sailors enter them, in Custom handicaps and rating systems.

Export to CSV

Press Export CSV to download exactly what you see (the view, columns and filters you chose), totals included. Handy for the caterer, the safety team or the club office.