Find Jobs
Hire Freelancers

Create reports from Excel Spreadsheet

$30-250 AUD

Selesai
Dibuat lebih dari 9 tahun yang lalu

$30-250 AUD

Dibayar ketika dikirim
I want to measure timeframes between milestones in each of our construction projects so that I can monitor the performance of our contractors, suppliers & employees responsible for each task. I created a spreadsheet (attached) to enter the date each project stage is submitted/completed as we progress through each project. What I want created is reports or tables for each milestone/stage, eg. A report/table called Certified Plans as at (today's date) would contain the details of only the projects which have a date entered in the Request Engineering row. (If there was text in the field, eg. N/A it would not select the project). It would then tell me the date engineering was requested, and the number of business days (must exclude weekends) it had been in engineering/waiting for certified plans as at today's date. The report would be sorted by number of days in engineering with the longest number of days at the top of the report. I would also like a report that gave me monthly stats eg. average & median number of business days that projects are in engineering. So for each stage in the project lifecycle I am looking for a report telling me the outstanding projects that are at each point, and a report on the monthly performance stats for each stage. To summarise it is really just 2 groups of reports - those highlighting outstanding items at each stage & those providing monthly statistics on the performance at each stage.
ID Proyek: 6228151

Tentang proyek

5 proposal
Proyek remot
Aktif 10 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
Diberikan kepada:
Avatar Pengguna
Hi, I'll be happy to help you with this project. Please feel free to message me if you need to discuss any questions
$120 AUD dalam 1 hari
4,9 (89 ulasan)
6,3
6,3
5 freelancers are bidding on average $128 AUD for this job
Avatar Pengguna
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 210 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$200 AUD dalam 7 hari
5,0 (36 ulasan)
5,2
5,2
Avatar Pengguna
Hello tvlbusiness, I'm interested in your project and would appreciate the opportunity. I can create report to your satisfaction. I don't take any job I cannot do and have absolute confidence in my ability. If I run into any problem or have a need to confirm things, I will contact you ASAP. Looking forward to working with you. Do not hesitate to contact me. Regards, Aparna Tankha
$111 AUD dalam 3 hari
5,0 (3 ulasan)
3,8
3,8
Avatar Pengguna
Hi, I am a professional engineer with excellent educational background (Masters' degree from one of the top institutes in India). I have been making excel report templates in past for engineering report requirements. Kindly visit my portfolio for more information. I can assure you that you will get the perfect work from me without any mistakes. Quality of deliverable within a given time frame is my aim for any project. Kindly have a look on my portfolio and CV for more information about me and my work. Also, please feel free to text me if you have anything to ask. Thank you.
$100 AUD dalam 5 hari
5,0 (2 ulasan)
2,7
2,7
Avatar Pengguna
Hi, I am working as software professional in IT industry from last 4 years. I work on VB scripting along with VBA for MS office applications. Also developed various Desktop based application using Visual Studio in VB and C#. I have done these type of similar projects before. Have plenty of experience in excel hence would be looking forward to work on this opportunity and deliver the best. Thanks
$111 AUD dalam 2 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera AUSTRALIA
Townsville, Australia
5,0
1
Memverifikasi Metode pembayaran
Anggota sejak Jul 24, 2014

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.