A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | # | Salutation | Name Prefix | Name | Name Suffix | Party Size | Affiliation | Table | Nickname | Remarks | Other Info | User-Defined | User-Defined | QR ID | QR Key |
2 | 0 | e.g. Dr | e.g. Jonathan | e.g. Tan | e.g. Eng Hock | e.g. 1 | e.g. Bride Family | e.g. VIP Table | e.g. Second Uncle | ||||||
3 | 0 | e.g. Mr & Mrs | e.g. Fadhlin | e.g. bin Akmal | e.g. 2 | e.g. Groom NS Friend | e.g. Bridal Table | e.g. Wife - Violet | e.g. 1 baby chair | ||||||
4 | 0 | e.g. Ms | e.g. Maria | e.g. Cosulich | e.g. and Partner | e.g. 1 | e.g. Groom Ex-colleague | e.g. 27 | |||||||
5 | 0 | e.g. 孙 | e.g. 启睿 | e.g. 2 | e.g. Bride Colleague | e.g. 3 | e.g. Sun Qi Rui | e.g. Vegetarian | |||||||
6 | 0 | e.g. Mr | e.g. Ivan | e.g. Fyodorovich | e.g. 1 | e.g. Bride Secondary Classmate | e.g. 55 | ||||||||
7 | 1 | ||||||||||||||
8 | 2 | ||||||||||||||
9 | 3 | ||||||||||||||
10 | 4 | ||||||||||||||
11 | 5 | ||||||||||||||
12 | 6 | ||||||||||||||
13 | 7 | ||||||||||||||
14 | 8 | ||||||||||||||
15 | 9 | ||||||||||||||
16 | 10 | ||||||||||||||
17 | |||||||||||||||
18 | General Notes | ||||||||||||||
19 | Download this file for editing by selecting "Download" from the "File" menu. | ||||||||||||||
20 | Only the column headers in bold (D - name, F - party size, and H - Table, if your event has seating) are required. You can leave the rest blank. | ||||||||||||||
21 | If you have an existing spreadsheet with columns laid out in a different order, simply rename your headers to match ours. | ||||||||||||||
22 | Note on name columns (B, C, D, and E): | ||||||||||||||
23 | We split names into four parts — salutation, prefix, name, and suffix. This is to allow sorting by name parts. | ||||||||||||||
24 | If you want to be able sort by surname on the iPad, put the surname under "Name" (column D) and put the other name parts in the other columns, | ||||||||||||||
25 | depending on whether they appear before or after the surname. The examples from above are repeated below: | ||||||||||||||
26 | |||||||||||||||
27 | Dr | Jonathan | Tan | Eng Hock | |||||||||||
28 | Mr & Mrs | Fadhlin | bin Akmal | ||||||||||||
29 | Ms | Maria | Cosulich | and Partner | |||||||||||
30 | 孙 | 启睿 | |||||||||||||
31 | Mr | Ivan | Fyodorovich | ||||||||||||
32 | |||||||||||||||
33 | If you don't need to sort by parts of a name, you can just enter the whole name into "Name" (column D) and leave the rest of the columns (B, C, E) blank: | ||||||||||||||
34 | Dr Jonathan Tan Eng Hock | ||||||||||||||
35 | 孙启睿 | ||||||||||||||
36 | |||||||||||||||
37 | Note on affiliation (column G): | ||||||||||||||
38 | This column can be displayed under the guest's name, or it can be hidden and just be searchable. | ||||||||||||||
39 | For example, you can enter "Bride's Family", and any search for the word "family" will show these guests. | ||||||||||||||
40 | Note on user-defined columns (columns I to M): | ||||||||||||||
41 | These columns can include any data here that your receptionists might search for. We can optionally display this information under each guest's name as well. | ||||||||||||||
42 | For example, under "nicknames", enter names of guests that they might use which you might not display. E.g. "Ah Ma", or names of spouses, or pinyin translations of Chinese names | ||||||||||||||
43 | You can change the column headers to anything of your choosing, to help in your planning. | ||||||||||||||
44 | Note on QR columns (N and O): | ||||||||||||||
45 | These will be automatically generated. No need to fill anything in here. |