Create Excel document to calculate how to price services to be Cheapest at All Times (2nd freelancer)

Анульовано Опубліковано %project.relative_time Оплачується при отриманні
Анульовано Оплачується при отриманні

We are TaxiService and want to adjust our taximeter prices to be CHEAPEST of all taxi companies in our area. We need an Excel-based Calculation Sheet which can open/read several Excel Documents, each containing competitors prices, and calculate what-if for all possible TimeOfDay/time/distance combinations and suggest how we should price our services so we are just a fraction below our competitors.

The Excel documents containing competitors prices, have identical layout and data, and serves as input for calculation. One excel input document per competitor. Taximeter prices depend on DayOfWeek and TimeOfDay. FareCalculation depend on TypeOfBooking, DistanceTravelled and DurationOfTrip. MinimumFare is applied.

The resulting Excel Document should open each of the InputDocuments and find the lowest fare for every combination 1-100km and 1-100minutes throughout the day and week, for 3 different types of bookings (Hailed Taxi, PhoneOrdered Taxi, PreBooked Taxi).

The calculation Excel Document should then suggest how we should set our fares to ensure that we are "just a tiny bit" cheaper than the next one.

Enclosed is a sample ExcelDocument containing fares for one taxi service. There will be 8-10 such documents being read. The end result should be a similar document for our fares...

Please contact me on Chat if you have questions or need clarification.

Обробка даних Excel

ID Проекту: #9697587

Про проект

5 заявок(-ки) Дистанційний проект Остання активність Feb 18, 2016

5 фрілансерів(-и) готові виконати цю роботу у середньому за $142

elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega Більше

$150 USD за 3 дні(-в)
(171 відгуків(и))
6.7
DMcCarthy89

Hi, I am a scientist by profession with extensive experience in creating Excel templates to import, reformat and apply calculations to complex datasets. I would be very interested in seeing the data you are working Більше

$160 USD за 5 дні(-в)
(28 відгуків(и))
4.5
renandocarmoreis

Hello, I can write a script that will calculate the lowest fare according the input files. It will generate all possible combinations of fares. Please send me the input files for me to check. Thanks

$90 USD за 1 день
(0 відгуків(и))
0.0
atsiaya

Hi there i have gone through your job requirements and i would like to work for you. Am skilled in data processing and ms excel and am confident that i will deliver quality work. I am also detail and quality oriented Більше

$155 USD за 3 дні(-в)
(0 відгуків(и))
0.0