how many people are coming?

Will you be attending the AGM this year? n
No, I can’t make it this year :( 3
Wouldn’t miss it; see you there! 24

how many meals are required each day?

day date meal total
Day 1 May 15 Lunch 17
Day 1 May 15 Dinner 16
Day 2 May 16 Breakfast 15
Day 2 May 16 Lunch 19
Day 2 May 16 Dinner 15
Day 3 May 17 Breakfast 13
Day 3 May 17 Lunch 17

how many people are staying at the YMCA?

date sleepers
May 15 12
May 16 10

other things we might need

How many people want a single or a double room each night?

How many people have dietary restrictions, and which meals will they be eating?

More simply: what dietary restrictions are present, and how many of each?

Dietary restrictions n
Dairy Allergy, allergic to red peppers 1
Gluten Allergy, Vegan Only 1
Nut Allergy 1
Nut Allergy, Gluten Allergy, Dairy Allergy 1
Vegan Only 1
Vegan Only, allergic to pineapple 1

warn if somebody isn’t eating?

lists of people

$absent

Name off_on_abs representing
Person C absent none
Person K absent none
Person Q absent none

$offsite

Name off_on_abs representing
Person D offsite Barrie
Person E offsite Bedford
Person F offsite Bloor West
Person G offsite Brampton
Person J offsite Burlington
Person L offsite Burnaby
Person M offsite Burnaby
Person O offsite Cambridge
Person P offsite Charlottetown
Person Q offsite Clifton, Northern Kentucky; Cincinnati
Person R offsite Columbus
Person T offsite Danforth

$onsite

Name off_on_abs representing
Person A onsite Aurora
Person B onsite Austin
Person H onsite Brantford
Person I onsite Brooklin
Person N onsite Calgary North
Person S onsite Columbus
Person U onsite East Vancouver
Person W onsite Etobicoke
Person V onsite Edmonton South; Edmonton
Person Z onsite Fredericton
Person Y onsite Griffintown
Person X onsite Guelph