C
Carlo
I am a limo driver and I have bulit a extensive monthly spread sheet. Each
monthly book has 5 to 6 different spread sheets within it. (useless info, any
ways) Each spread sheet is based on my weekly runs. I will do my best to
explain.
B7 C7 D7 E7 F7
Event From To Car Time
Departure Ancaster Toronto Sedan $20.00
What I need is a Look Up or what ever will work. Below is a table of our
price list according to the event and type of car we use. Based on the
results above and the info I have inputted the function to read the table
below and place the price in the "Time" column
Weddings and Socials are based on a hourly rate which needs to be multipled
using the results in N7
VAN BUS
CAR LIMO SUV
Airport $20 $22 $30
Airport $30 $30 $40
Bar Run $50 $60 $70
Bar Run $50 $60 $70
Add'l $2 $3 $5
Social $10 $10 $12
Wedding $10 $10 $12
Prom $30 $40 $50
Prom $40 $40 $70
Airport $12 $12 $15
Airport $25 $25 $30
Airport $30 $30 $40
Airport $30 $30 $40
Airport $30 $30 $40
Airport $30 $30 $40
Airport $35 $35 $45
Airport $35 $35 $45
Airport $40 $40 $50
Airport $40 $40 $50
Airport $40 $40 $50
Airport $40 $40 $50
Airport $40 $40 $50
Bar Run $30 $40 $50
Bar Run $30 $50 $50
Bar Run $30 $50 $50
Bar Run $40 $50 $50
Bar Run $60 $70 $80
Bar Run $60 $70 $80
monthly book has 5 to 6 different spread sheets within it. (useless info, any
ways) Each spread sheet is based on my weekly runs. I will do my best to
explain.
B7 C7 D7 E7 F7
Event From To Car Time
Departure Ancaster Toronto Sedan $20.00
What I need is a Look Up or what ever will work. Below is a table of our
price list according to the event and type of car we use. Based on the
results above and the info I have inputted the function to read the table
below and place the price in the "Time" column
Weddings and Socials are based on a hourly rate which needs to be multipled
using the results in N7
VAN BUS
CAR LIMO SUV
Airport $20 $22 $30
Airport $30 $30 $40
Bar Run $50 $60 $70
Bar Run $50 $60 $70
Add'l $2 $3 $5
Social $10 $10 $12
Wedding $10 $10 $12
Prom $30 $40 $50
Prom $40 $40 $70
Airport $12 $12 $15
Airport $25 $25 $30
Airport $30 $30 $40
Airport $30 $30 $40
Airport $30 $30 $40
Airport $30 $30 $40
Airport $35 $35 $45
Airport $35 $35 $45
Airport $40 $40 $50
Airport $40 $40 $50
Airport $40 $40 $50
Airport $40 $40 $50
Airport $40 $40 $50
Bar Run $30 $40 $50
Bar Run $30 $50 $50
Bar Run $30 $50 $50
Bar Run $40 $50 $50
Bar Run $60 $70 $80
Bar Run $60 $70 $80