Find Jobs
Hire Freelancers

Basic Excel dashboard creation from two spreadsheets (daily)

$250-750 NZD

Selesai
Disiarkan lebih dari 2 tahun yang lalu

$250-750 NZD

Dibayar semasa penghantaran
The project relates to the daily sending of the two attached CSV files. I can automate both of these files to be sent daily in CSV form, and ideally would like to have them sent to a Onedrive folder that I can share with you to extract the data from. I'd then like the data to be displayed in an Excel spreadsheet with the outputs as below. What I'm ultimately attempting to do is generate the following outputs: Total revenue per day DIVIDED by the total number of hours that our trucks were operating for = Total fleet revenue per hour Revenue per day by fleet number DIVIDED by the total number of hours that an individual fleet number was operating for = Individual fleet revenue per hour Total revenue per day DIVIDED by the total number of kilometers that our trucks travelled = Total fleet revenue per KM Revenue per day by fleet number DIVIDED by the total number of kilometers than an individual fleet number travelled = Individual fleet revenue per KM I'll start with the revenue extraction - this will come from the example CSV file "Transcon Deliveries..." and in particular column D (for vehicle/fleet number), and column S "JobRevenue" which identifies the revenue on a per job basis. The hours will come from the other example CSV file "Trip Investigator..." and the calculation for this is slightly more complicated, as I want to capture the sum of the total elapsed time (without breaks) between the first "Depart time" and last "Arrive time" by "Display name" (which is the fleet/truck number for cross-referencing purposes. To give an example in the attached for DisplayName "75" I'd want to use the following values: Use the value in cell D6 as the "Start time" Use the value in cell F19 as the "Finish time" Calculate the total time between the two values above The kilometers (KM's) will also come from the "Trip Investigator..." CSV file and are located in column H. If you'd like to have a review of the above and the attached CSV files and then we can discuss a plan further from there. I'm aware that this is a relatively large project, so am happy to pay however works best for you, whether by the hour with set milestones, or as an overall project.
ID Projek: 32303469

Tentang projek

22 cadangan
Projek jarak jauh
Aktif 2 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
"Sir, I am Excel Dashboard Advance Level Expert. This is a basic work for me. i can complete this project with added quality. About me I am Chartered Accountant with more than 4 years of experience from worlds leading Accountancy and auditing firm """"PWC"""". I can handle this task very efficiently and you can expects 100% accuracy from me. I am Microsoft Excel, accounting, auditing, Financial statements, Form Creation in Excel through VBA and in Google Sheet and QuickBooks expert. It is my 4th month month here and i have 83 5 stars reviews here here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, excel, QuickBooks and auditing related work with quality, efficiency and on reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar"""
$250 NZD dalam 1 hari
4.9 (146 ulasan)
6.3
6.3
22 pekerja bebas membida secara purata $519 NZD untuk pekerjaan ini
Avatar Pengguna
Hi I have checked your project description. I have excellent programming and development skills. Contact me with all the details and requirements for your project for further discussion. I will provide you with dedicated support and follow-up. Regards Farah Khan
$750 NZD dalam 7 hari
5.0 (530 ulasan)
7.5
7.5
Avatar Pengguna
Hello Sir/Madam I have development experience in various Programming Languages, OOP, Data Structures, Database Driven applications, APIs, Files handling and Data Transformation, ETL and various frameworks. I assure you an excellent solution of your project within the time frame and exactly according to the requirements. Thanks @CodingHelpLine
$630 NZD dalam 7 hari
5.0 (55 ulasan)
5.3
5.3
Avatar Pengguna
I can automate both of these files to be sent daily in CSV form, and ideally would like to have them sent to a Onedrive folder that I can share with you to extract the data from. I'd then like the data to be displayed in an Excel spreadsheet with the outputs as below. I have been working here since the last year ,Thanks for posting and sharing your project.I have experience in this work ,let be handle this task to me ,i am willing to start Now Just contact/Text☎ You will get project: within time within Desire within Solution Thanks Muzammal Hussain
$290 NZD dalam 4 hari
4.7 (20 ulasan)
5.3
5.3
Avatar Pengguna
"Sir, I am ready to start this project right now. I am an advance level EXCEL dashboard EXPERT and all Excel related work. This task is very easy ,I will complete this task with 100 % Accuracy , I have over 6 years of experience in management Accounting, Accounting, Audit, Balance sheet, Income statement, Cashflows and all other accountancy and Excel related work .I have completed similar projects with five stars from client. About me I am Chartered Accountant with more than 4 years of experience from worlds leading Accountancy and auditing firm ""PWC"". I can handle this task very efficiently and you can expects 100% accuracy from me. I am Microsoft Excel, accounting, auditing, Form Creation in Excel through VBA and in Google Sheet and QuickBooks expert. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. Please be my Client and get any type of 'Accountancy', 'Excel', 'QuickBooks', Balance Sheet', 'Income Statement', 'Cashflows' and auditing related work with quality, efficiency and on reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Spogmai Kakar "
$250 NZD dalam 1 hari
5.0 (20 ulasan)
3.9
3.9
Avatar Pengguna
How are you? I am interesting your project. My skill is excel vba and macro if you hire me , I will do my best. also I want to work with you for a long time. thanks. please give me this job. we can know more about project via chat. I will wait for your happing message.
$630 NZD dalam 7 hari
5.0 (1 ulasan)
1.7
1.7
Avatar Pengguna
Hello, I am really happy to read your job description which is 100% fit for my skills and experience. I am a fresh graduate with skills in data entry and Excel related works. Besides my typing speed is 30 wpm. So if you hire me you will get many services at a single place. I am very much confident to deliver quality work. So, all i want you to give me the opportunity to prove that i have calmed above. I look forward to hearing from you soon. Thank you.
$630 NZD dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hi, I saw that you need help with Excel, Microsoft Access, Microsoft Office, Microsoft and Visual Basic. I have 3 years of experience working on these frameworks. I believe I can help you with it. I would request you to have a look at my portfolio, customer feedbacks from my profile. If you find me worthy of doing your job. Please start the chat and lets discuss it. Regards Muhammad Numan
$250 NZD dalam 1 hari
0.0 (1 ulasan)
0.0
0.0
Avatar Pengguna
Hello Sir, I am an expert in data entry,I saw the details and I understood well how to execute this task within the mentioned timeline . Please contact me to discuss more ,looking forward to work with you. Thanks.
$630 NZD dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hi my name is Ankit.i am working data entry operator,PDF convert to word.I am working freelancer sites. I am experienced one year .
$630 NZD dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Dear Sir I can do it perfectly. I read your job post carefully and if you hire me, I will start immediately and provide your perfectly results. Thank you very much for your job post.
$630 NZD dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hello there, i would like the opportunity to handle this project for you. I am a data entry specialist and a microsoft office expert and can complete this job with 100% accuracy. Also pretty good with excel. Kindly chat me up so we can begin.
$700 NZD dalam 7 hari
0.0 (0 ulasan)
0.0
0.0

Tentang klien

Bendera NEW ZEALAND
Wellsford, New Zealand
4.8
22
Kaedah pembayaran disahkan
Ahli sejak Apr 4, 2015

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.