Frontier School’s Out Event
Author Lourdes Dreyer
Date 12/1/2017
Purpose To record reservations for the Schools Out Event
Defined Names
Amount_to_Pay =’Reservation Input’!$B$11
City__State__Zip =’Reservation Input’!$B$7
Confirmation =’Reservation Input’!$B$10
Date_Paid =’Reservation Input’!$B$2
e_mail_address =’Reservation Input’!$B$9
Event =’Reservation Input’!$B$3
Guests =’Reservation Input’!$B$4
Name =’Reservation Input’!$B$5
Street_Address =’Reservation Input’!$B$6
Telephone =’Reservation Input’!$B$8
Date Paid Walking Tour of School 0.00
Event Silent Auction of Furniture 0.00
Guests Breakfast with the Principal 10.00
Name Lunch with the Teachers and Staff 15.00
Reservation Input
Events
E-mail address snail mail
Row Labels Sum of Guests
Breakfast with the Principal 11
Lunch with the Teachers and Staff 10
Silent Auction of Furniture 4
Walking Tour of School 6
Grand Total 31
Date Paid Event Guests Name Street Address City, State, Zip Telephone E-mail addres Confirmation Amount to Pay
11/27/2017 Walking Tour of School 1 Danielle Burt 1992 Smith Road Anderson, MO 64856 417-555-2111 dburt@example.com e-mail
11/27/2017 Silent Auction of Furniture 1 Tony Nagle 4764 Reel Avenue Pineville, MO 64831 417-555-0123 tony4764@example.com e-mail
11/27/2017 Breakfast with the Principal 2 Tony Nagle 4764 Reel Avenue Pineville, MO 64831 417-555-0123 tony4764@example.com e-mail 20
11/27/2017 Walking Tour of School 1 George Burpo 1590 Glendale Ave Anderson, MO 64856 417-555-1111 None none required
11/27/2017 Lunch with the Teachers and Staff 2 George Burpo 1590 Glendale Ave Anderson, MO 64856 417-555-1111 None none required 30
11/27/2017 Walking Tour of School 1 Frank Mastrangelo 4471 Robinson Court Anderson, MO 64856 417-555-9998 None snail mail
11/27/2017 Lunch with the Teachers and Staff 1 Frank Mastrangelo 4471 Robinson Court Anderson, MO 64856 417-555-9998 None snail mail 15
11/27/2017 Walking Tour of School 1 James Snell 4587 Lunette Street Pineville, MO 64831 417-555-5555 None telephone
11/27/2017 Silent Auction of Furniture 1 James Snell 4587 Lunette Street Pineville, MO 64831 417-555-5555 None telephone
11/27/2017 Breakfast with the Principal 1 James Snell 4587 Lunette Street Pineville, MO 64831 417-555-5555 None telephone 10
11/27/2017 Lunch with the Teachers and Staff 3 James Snell 4587 Lunette Street Pineville, MO 64831 417-555-5555 None telephone 45
11/30/2017 Breakfast with the Principal 2 Jackie Remington 2770 Boone Rd Pineville, MO 64831 417-555-2077 None snail mail 20
11/30/2017 Breakfast with the Principal 3 Daniel Scott 392 Sunny Day Drive Pineville, MO 64831 417-555-0158 dscott@example.com e-mail 30
11/27/2017 Walking Tour of School 1 Ryan Herman 4353 Tanglewood Road Pineville, MO 64831 417-555-1335 None snail mail
11/27/2017 Silent Auction of Furniture 1 Ryan Herman 4353 Tanglewood Road Pineville, MO 64831 417-555-1335 None snail mail
11/27/2017 Breakfast with the Principal 1 Ryan Herman 4353 Tanglewood Road Pineville, MO 64831 417-555-1335 None snail mail 10
11/27/2017 Walking Tour of School 1 Tony Nagle 4764 Reel Avenue Pineville, MO 64831 417-555-0123 tony4764@example.com e-mail
Frontier School’s Out Event
Author Lourdes Dreyer
Date 12/1/2017
Purpose To record reservations for the School’s Out Event
Defined Names
Amount_to_Pay =’Reservation Input’!$B$11
City__State__Zip =’Reservation Input’!$B$7
Confirmation =’Reservation Input’!$B$10
Date_Paid =’Reservation Input’!$B$2
E_mail_address =’Reservation Input’!$B$9
Event =’Reservation Input’!$B$3
Guests =’Reservation Input’!$B$4
Name =’Reservation Input’!$B$5
Street_Address =’Reservation Input’!$B$6
Telephone =’Reservation Input’!$B$8
Date Paid 11/30/2017 Walking Tour of School 0.00
Event Breakfast with the Principal Silent Auction of Furniture 0.00
Guests 3Breakfast with the Principal 10.00
Name Daniel Scott Lunch with the Teachers and Staff 15.00
Reservation Input
Events
Street Address 392 Sunny Day Drive
City, State Zip Pineville, MO 64831 Confirmation
E-mail address dscott@example.com snail mail
Amount to Pay 30 none required
Row Labels Sum of Guests
Breakfast with the Principal 5
Lunch with the Teachers and Staff 6
Silent Auction of Furniture 3
Walking Tour of School 4
Grand Total 18
Date Paid Event Guests Name Street Address City, State, Zip Telephone E-mail addres Confirmation Amount to Pay
11/27/2017 Walking Tour of School 1 Danielle Burt 1992 Smith Road Anderson, MO 64856 417-555-2111 dburt@example.com e-mail
11/27/2017 Silent Auction of Furniture 1 Danielle Burt 1992 Smith Road Anderson, MO 64856 417-555-2111 dburt@example.com e-mail
11/27/2017 Lunch with the Teachers and Staff 2 George Burpo 1590 Glendale Ave Anderson, MO 64856 417-555-1111 None none required 30
11/27/2017 Walking Tour of School 1 Frank Mastrangelo 4471 Robinson Court Anderson, MO 64856 417-555-9998 None snail mail
11/27/2017 Lunch with the Teachers and Staff 1 Frank Mastrangelo 4471 Robinson Court Anderson, MO 64856 417-555-9998 None snail mail 15
11/27/2017 Walking Tour of School 1 James Snell 4587 Lunette Street Pineville, MO 64831 417-555-5555 None telephone
11/27/2017 Silent Auction of Furniture 1 James Snell 4587 Lunette Street Pineville, MO 64831 417-555-5555 None telephone
11/27/2017 Breakfast with the Principal 1 James Snell 4587 Lunette Street Pineville, MO 64831 417-555-5555 None telephone 10
11/27/2017 Lunch with the Teachers and Staff 3 James Snell 4587 Lunette Street Pineville, MO 64831 417-555-5555 None telephone 45
11/30/2017 Breakfast with the Principal 2 Jackie Remington 2770 Boone Rd Pineville, MO 64831 417-555-2077 None snail mail 20
11/30/2017 Breakfast with the Principal 3 Daniel Scott 392 Sunny Day Drive Pineville, MO 64831 417-555-0158 dscott@example.com e-mail 30
11/27/2017 Walking Tour of School 1 Ryan Herman 4353 Tanglewood Road Pineville, MO 64831 417-555-1335 None snail mail
11/27/2017 Silent Auction of Furniture 1 Ryan Herman 4353 Tanglewood Road Pineville, MO 64831 417-555-1335 None snail mail
11/27/2017 Breakfast with the Principal 1 Ryan Herman 4353 Tanglewood Road Pineville, MO 64831 417-555-1335 None snail mail 10
11/27/2017 Walking Tour of School 1 Tony Nagle 4764 Reel Avenue Pineville, MO 64831 417-555-0123 tony4764@example.com e-mail
11/27/2017 Silent Auction of Furniture 1 Tony Nagle 4764 Reel Avenue Pineville, MO 64831 417-555-0123 tony4764@example.com e-mail
11/27/2017 Breakfast with the Principal 2 Tony Nagle 4764 Reel Avenue Pineville, MO 64831 417-555-0123 tony4764@example.com e-mail 20
11/27/2017 Walking Tour of School 1 George Burpo 1590 Glendale Ave Anderson, MO 64856 417-555-1111 None none required