Eugene Community Theatre
Author: Ellen Jefferson
Date: 7/15/2013
Purpose: Prepare invoices for theatre patrons
Defined Names
Address =Invoice!$B$5
City_State_Zip =Invoice!$B$6
Decals =Invoice!$B$11
Donation =Invoice!$B$12
HandlingCost =Invoice!$B$24
Invoice_Date =Invoice!$B$3
Location =Invoice!$B$10
ParkingFee =Invoice!$B$25
Phone =Invoice!$B$7
Series =Invoice!$B$9
Subscriber =Invoice!$B$4
Ticket_Quantity =Invoice!$B$8
TicketCost =Invoice!$J$18
TicketPrices =Invoice!$A$16:$C$21
TotalInvoice =Invoice!$J$22
Invoice Data
Invoice Date 7/15/2013 Eugene Community Theatre
Subscriber Michael Keller 777 Monroe Street
Address 4321 Main Street Eugene, OR 70777
City State Zip Eugene, OR 70777
Phone (806)555-1111 Date:
Ticket Quantity 4
Series C Subscriber Michael Keller
Location Balcony Address 4321 Main Street
No. Parking Decals 2 City State Zip Eugene, OR 70777
Donation 50 Phone (806)555-1111
Ticket Price Table Ticket Quantity 4
Series Orchestra Balcony Series C
A 225 175 Location Balcony
B 200 165
C 175 150 Ticket Cost
D 150 125 Handling
E 125 100 Parking Decals 2
F 100 75 Donation
Total
Invoice Constants
Handling Cost 10 Transfer Area
Parking Fee 15 Michael Keller 7/15/2013 4 600
Theatre
reet
777
7/15/2013
$ 600
$ 10
$ 30
$ 50
$ 690
a
$ 690
Cell: A2
Comment: Ellen Jefferson:
Enter all data from the order form into cells B3 through B12
Customer Name Date Nbr Tickets Ticket Amount Total Amount
Ellen Felton 6/25/2013 1 240 240
Mark Johnson 6/25/2013 3 600 663
Emily Rosen 6/26/2013 1 200 225
Michael Fee 7/1/2013 3 600 600