Closed

Billing Sheet on Excel with calculation for logistic and transportation

I am looking for a freelancer who can create for me an interactive excel sheet where I can fill in several informations and the sheets calculates distances and fares for each tour.

- Where do the information come from?

From one pdf and one excell-sheet where all tours has been summed up in single positions. The tours and routes are fix. Our client has 28 adresses in germany and about 20 delivery/producer adresses which are getting approached mixed. We have flatrate per day and a fare per kilometer which gets added up on top of the daily fix flatrate.

- What do I need?

Since I have two soureces, I need a single main excel sheet where I can write in which tour, which vehicle and from where to where it drove - so these information calculate in the background automaticly and appears on the fron billing sheet which needs to be programmed

As a sample I attached a excel-sheet. As soon you get the job, you get further instructions.

Skills: Excel, Data Entry, Data Processing, Visual Basic, PHP

See more: shift roster sheet excel, assumption sheet excel, excel calculation services vba 2008, buyers net sheet excel, format salary sheet excel, code update sheet excel, seller net sheet excel, excel calculation template, sellers net sheet excel free, hsbc mortgage excel calculation sheet, heat load calculation sheet excel, club excel calculation sheet, excel sheet earthwork calculation, have uploaded sample excel sheet template as well as instructions for the scope within, best excel calculation and conversation sheet, how to use excel sheet for calculation, billing in excel sheet, manpower calculation sheet excel format

About the Employer:
( 0 reviews ) Düsseldorf, Germany

Project ID: #29790264

43 freelancers are bidding on average €131 for this job

(698 Reviews)
8.8
(344 Reviews)
8.2
schoudhary1553

Hi, Greetings! ✅ I have checked and gone through the project details and I am very skilled in it. ✅Completed Time: In project deadline We have worked on 660 + Projects. I have 6 + years of the experience in sam More

€180 EUR in 3 days
(494 Reviews)
8.4
P0L

(481 Reviews)
8.0
(310 Reviews)
7.3
(163 Reviews)
6.8
maxpl

Hi, I hope all is well there. I am an experienced web and mobile app developer. I have 8+ years of experience in webdesign/develop More

€200 EUR in 7 days
(31 Reviews)
6.7
SShtv

Hello, I am interested in your project. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These More

€150 EUR in 3 days
(114 Reviews)
6.4
(39 Reviews)
6.0
zeeshan411

Hi! I have read the job details of Billing Sheet on Excel with calculation for logistic and transportation very carefully and I am absolutely sure that I can do the project very well. I have already successfully delive More

€200 EUR in 7 days
(50 Reviews)
5.8
(117 Reviews)
6.0
Akib2020

✅ Expert on Advanced Excel ✅ Hi there! Checked: Tourplan Übersicht Flaschenpost [login to view URL] I can create an interative excel template as on your requirements. I'm expert on vba, macro, nested formula & fuction, po More

€150 EUR in 7 days
(70 Reviews)
5.6
arnoldb

Hello, Hope you are fine. I am full stack developer from Poland with more than 8 years of experience. I have seen the project description and I More

€200 EUR in 7 days
(13 Reviews)
5.6
merinsinha

High Quality work. I can complete your project. Senior Excel VBA programmer. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide More

€86 EUR in 2 days
(96 Reviews)
5.1
mowachira77

Hi, I have fully read and understood your project requirements and read to fulfill them. I possess skills that are relevant to completing your work i.e., VBA, data processing, data entry and excel. I am ready to start More

€70 EUR in 1 day
(39 Reviews)
4.8
MonisZafar

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. I will start immediately and complete it within a few hours. I More

€80 EUR in 1 day
(24 Reviews)
4.9
zaahidali61

Hi, Thanks for reading my response to your project. I gone through your attachment as well you requirement. I can create a excel automated calculation sheets for you. Let us discuss on chat in detail. Thanks

€60 EUR in 2 days
(20 Reviews)
4.6
hamidr2020

Hi, I have read your project description and checked the attached spreadsheet. I am an Excel expert. You can check my recent reviews in Excel projects. https://www.freelancer.com/contest/REPAIR-MY-EXCEL-SPREADSHEET-18 More

€45 EUR in 2 days
(18 Reviews)
4.4
oldaccountant

Dear Employer, Already do many similar project and completed it within your budget, time My Qualifications as under-: #Chartered Accountant(ACCA/CPA) #Lawyer/advocate #Masters in commerce #Certified Auditor #Certifie More

€30 EUR in 1 day
(12 Reviews)
3.8
NIKITALILA

Hi there, I can definitely help you get this done and automate the process using VLookup and Macros. We are a team of trained professionals with years of experience in Microsoft Excel and VBA programming Hit us up a More

€99 EUR in 2 days
(15 Reviews)
3.8