Find Jobs
Hire Freelancers

Create reports from Excel Spreadsheet

$30-250 AUD

Completed
Posted almost 10 years ago

$30-250 AUD

Paid on delivery
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.
Project ID: 6228151

About the project

5 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 1 day
4.9 (89 reviews)
6.3
6.3
5 freelancers are bidding on average $128 AUD for this job
User Avatar
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 in 7 days
5.0 (36 reviews)
5.2
5.2
User Avatar
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 in 3 days
5.0 (3 reviews)
3.8
3.8
User Avatar
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 in 5 days
5.0 (2 reviews)
2.7
2.7
User Avatar
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 in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Townsville, Australia
5.0
1
Payment method verified
Member since Jul 24, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.