Hello Guys,
Your assistance in helping me solve the below problem would be greatly appreciated.
I would like to calculate parking revenues for clients who use "domestic" or "international" parking facilities.
The value for such parking will be determined also by the type of vehicle parked "car" or "truck".
The rates associated with parking are dependant upon the type of facility used "domestic" or "international". I would like to have the revenue field populated with values, regardless of the filters used (e.g. Domestic, Truck, days in parking 15 days). There is a cumulative scale of parking in use as indicated on pictures below.
I want to compare the values of parking currently against the alternative rates that are listed in the parking rates screen shot (grey and blue picture).
Your excel guru skills are very much needed asap!!
I look forward to hearing from you.
Thanks,
Your assistance in helping me solve the below problem would be greatly appreciated.
I would like to calculate parking revenues for clients who use "domestic" or "international" parking facilities.
The value for such parking will be determined also by the type of vehicle parked "car" or "truck".
The rates associated with parking are dependant upon the type of facility used "domestic" or "international". I would like to have the revenue field populated with values, regardless of the filters used (e.g. Domestic, Truck, days in parking 15 days). There is a cumulative scale of parking in use as indicated on pictures below.
I want to compare the values of parking currently against the alternative rates that are listed in the parking rates screen shot (grey and blue picture).
Your excel guru skills are very much needed asap!!
I look forward to hearing from you.
Thanks,