Report pane

Top  Previous  Next

The stats_16Report pane shows reports of your plan. It is not possible to make changes to the plan from this pane.

Type is the type of report:

Report type

Description

Example usages

Editions available

Summary

An overall summary of the current plan

how many guests have accepted their invitation

how many males vs females

how many of each meal have been ordered by guests

all

Troubleshooting

Identifies issues that may need attention in the current plan

guests with 'Not near to proximity' that have been placed on a table together

tables with duplicate names

groups with no guests

all

Multi-plan

Shows where guests were seated across multiple plans

which events Mr John Smith attended and who he sat next to at each event

any guests without 'near to' or 'next to' proximity who have sat next to each other at 2 or more events

Advanced (up to 3 plans) and Professional (up to 50 plans)

Detailed (summary)

A detailed summary of a particular aspect of the current plan

how many guests ordered each meal by table

total of 'amount owing' custom field by group

Professional

Detailed (guests)

Similar to a Detailed (summary) report, but also lists guest names

which guests ordered each meal by table

the names of guests listed by special requirement and table

Professional

Click the Terms... button to change the words used in the report (e.g. to another language). Note that not all text can be replaced in all reports.

You can copy the contents of the whole pane to the clipboard as plain text and HTML using Edit>paste_16Copy. Use right click and Copy to copy selected text to the clipboard.

When you are happy with the layout you can print this page with File>print_16Print.

You can export the pane as an Excel CSV, plain text or HTML file using File>exp_16Export... and selecting report to text/CSV/HTML file. Select Excel CSV file, Text file or HTML file from the Save as type drop-down in the exp_16Export window. Plain text may be useful for emailing to your caterer. HTML preserves the layout and is useful for web pages and other HTML-aware applications, such as Microsoft Word. CSV files can be opened as Excel spreadsheets.

Click the msword_16 or msexcel_16 buttons to paste the report into Microsoft Word or Excel. You must have Microsoft Word or Excel installed.

Summary report

The summary report gives overall statistics for your plan.

Troubleshooting report

The trouble shooting report checks for the following 40 potential issues in your plan. If there are more than 100 results for any one issue, only the first 100 will be displayed for brevity.

For the purposes of the report seated 'next to' means the seat to the immediate left or right and seated 'near to' means on same table, table section (for E-shaped tables) or row of seats.

Issue

Notes

Reported

Empty guest Ids


Professional edition only

Duplicate guest Ids

case insensitive

the number of duplicates is shown in brackets

Professional edition only

Duplicate guest Title+First+Last names

case insensitive

the number of duplicates is shown in brackets

always

Duplicate guest display names

case insensitive

the number of duplicates is shown in brackets

always

Guests without titles


if ≥75% of guests have titles

Guests with gender different to title default

The default gender for a title is set in 'Titles' tab of the 'Preferences' window

always

Guests with age different to title default

The default age for a title is set in 'Titles' tab of the 'Preferences' window

always

Guests with undefined gender


if ≥75% of guests have defined genders

Guests with unset RSVP


if ≥75% of guests have RSVP set

RSVP Declined/Cancelled guests assigned to seats


always

RSVP Accepted/Arrived guests not assigned to seats


always

Assigned VIP guests not at VIP tables


if 1 or more VIP tables

Assigned guests without meals


if ≥75% of assigned guests have meals set

Proximity 'Next to' guests not seated near to each other

unassigned guests are ignored

always

Proximity 'Next to' guests seated near but not next to each other

unassigned guests are ignored

always

Proximity 'Near to' guests not seated near to each other

unassigned guests are ignored

always

Proximity 'Not near to' guests seated next to each other

unassigned guests are ignored

always

Proximity 'Not near to' guests seated near but not next to each other

unassigned guests are ignored

always

Proximity 'Not next to' guests seated next to each other

unassigned guests are ignored

always

Proximity 'Not next to' guests seated near but not next to each other

unassigned guests are ignored

always

Guests with all 'Next to' and 'Near to' proximities unfulfilled

guest has at least 1 'Next to' or 'Near to' proximity set but none of these proximities are satisfied

the number of 'next to' and 'near to' proximities unfulfilled is shown in brackets

unassigned guests are ignored

always

Guests with all 'Next to' proximities unfulfilled

guest has at least 1 'Next to' proximity set but none of these proximities are satisfied

the number of 'next to' proximities unfulfilled is shown in brackets

not shown if displayed in "All 'Next to' and 'Near to' Proximities unfulfilled"

unassigned guests are ignored

always

Guests with no proximity

unassigned guests are ignored

if ≥75% of assigned guests have proximities set

Guests with >2 'Next to' proximities

a guest can only sit next to a maximum of 2 other guests

unassigned guests are ignored

always

Guests with >n 'Next to' and 'Near to' proximities

if the biggest table is 10 seats then a guest can only sit next to or near to a maximum of 9 other guests

unassigned guests are ignored

if there is at least 1 table

Duplicate group names

case insensitive

the number of duplicates is shown in brackets

always

Groups with no members


always

Groups with anonymous members

the number of anonymous members is shown in brackets

always

Groups with incomplete contact details

groups with the 'Address 1' or 'City' contact fields not set

if ≥75% of groups have contact details set

Duplicate table names

case insensitive

the number of duplicates is shown in brackets

always

Tables with empty seats

the number of empty seats is shown in brackets

if ≥75% of tables have no empty seats

videoVideo with audio (1:10 minutes)

Advanced and Professional editions only

Multi-plan report

Click the Choose plans... button to select which plans to include in your report. The Choose plans window will appear. The maximum number of plans depends on which Edition of PerfectTablePlan you have.

In the Professional edition you can select from the Match by drop-down list depending on whether you want to match guests between plans by their ID or name (Title+First name+Last name, case is ignored). In the Advanced edition guests are always matched between plans by name.

Note Guests will only have the same ID if:

1.You copied a plan (e.g. using File>Save As); or

2.You imported the same ID for the same guest to multiple plans.

Check the detailed check box if you want to include a detailed report on each guest (this can make the report very long).

Click Go to create the report.

Professional edition only

Detailed (summary) and Detailed (guests) reports

Display is the guest property you wish to display, e.g. the meal choice.

By is how you want to group the results, e.g. by table. Choose N/A if you don't want to group the results.

For allows you to specify which guests you wish to include in your report.

For example, if you have a custom field 'amount owing' and you want a total of how much money is owed by each group for all the people that have accepted their invitations set Type to 'Detailed summary', Display to 'amount owing', By to 'Group' and For to 'RSVP accepted'.

videoVideo with audio (0:40 minutes)