Find Jobs
Hire Freelancers

Project - Home timeline tracker

$30-250 AUD

Completed
Posted over 1 year ago

$30-250 AUD

Paid on delivery
Hi there, I am a project manager and would like to create a template to assist with tracking multiple homes being constructed against forecast program dates. We build groups of 10-50 homes per stage and need to track their progress throughout (using the actual ‘completion date’ data set). I need formulas to quickly display in the ‘lot tracker’ section the status of each stage. There is more detail in the spread sheet attached. Please quote the following; - ‘Lot tracker’ Data table to act similar to example below. (more detail in attachment) - Gantt chart for forecast dates (second tab of attached template) - Additional gantt chart for actual completed dates (where job is ongoing apply nominal day range to forecast completion) - Auto populating Gantt chart based off information input on first tab
Project ID: 35422378

About the project

17 proposals
Remote project
Active 1 yr 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 can perfectly build all these tracking tools and Gantt Chart using Excel. I am an experienced Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel (including VBA & Macro) to perform Automation, Data Analytics, Data Visualization and various types of Calculations and Analysis. I will be happy to discuss further in detail.
$90 AUD in 1 day
4.8 (189 reviews)
7.1
7.1
17 freelancers are bidding on average $146 AUD for this job
User Avatar
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. I am available almost 24-7 and am very responsive. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 Kindly contact me via chat for further details and discussion.. Thank you Sandeep
$220 AUD in 5 days
4.9 (508 reviews)
8.4
8.4
User Avatar
I am working as a Developer, Programming Expert, Data Scientist and expert in ->Python, Tensor Flow Framework, C, C++, C#, VB, Visual Studio, Online Scrapping, ->Analysis and Modeling MATLAB, Predictive Modelling, Statistical Modeling using Machine Learning, Java SE, EE, JavaScript, JSP, PHP, HTML, Deep Learning Algorithms, SAS Designer and Developer, Jamovi -> STATA Visualizer and Developer, -> SPSS Designer, Developer and Modular, SPSS AMOS -> R Programming Language analysis and Modeling -> Power BI REST API Integration, Visualization Dashboard, Query Designer -> KNIME Analysis and Visualization -> Tableau Analysis and Visualization Dashboard -> Rapid Miner Analysis and Visualization Dashboard -> Minitab Analysis and Visualization Dashboard
$30 AUD in 7 days
5.0 (125 reviews)
6.9
6.9
User Avatar
Hi there! I have more than 10 years of experience as a Data Base Administrator and Analytics Engineer. I'd love to work together on your project. I'm so responsible and kind, I'll always send you the files on time and with the best quality. Send me a message and I'll start working on your project. Appreciatively, Giovanni. ´"°°""°°""
$30 AUD in 1 day
4.9 (46 reviews)
6.7
6.7
User Avatar
Hello there Iam excel EXPERT level with top rating done projects before I can done this within short time also i can provide previous samples for make you understanding better about me and my skills. When do you need this finished? I understand how annoying it is and can get this fixed for you quickly! Please see the sample I fixed. I look forward to working on this project with you. Regards
$175 AUD in 2 days
4.9 (182 reviews)
6.1
6.1
User Avatar
Hey, I'm an Advanced Level Excel Expert and will do it. Please send me a message so we can discuss further. Thanking You
$150 AUD in 2 days
4.8 (46 reviews)
4.7
4.7
User Avatar
Hey sir, it seems that you want to create an automated sheet to track the construction of homes by comparing the actual completion date with the forecast date, you also want to add a GANTT chart for the actual completion date. We can do this easily with Excel built-in functions and then create a macro for GANTT chart I have worked on a similar project using VBA in Excel with forms, please check this project https://www.freelancer.com/u/nadershehata/portfolio/fully-automated-managers-bonus-sheet-in-vba-10339509?w=f&ngsw-bypass= I am an Excel expert and VBA developer who has 2 certificates in VBA from NASBA and worked on similar projects in VBA such as creating full user-form data entry sheets for many firms, and integrated invoice creation between excel and word in VBA. I will be very happy if you contact me to work together, waiting for you, thank you.
$100 AUD in 1 day
5.0 (3 reviews)
3.0
3.0
User Avatar
Hi, I have gone through the Job details and am interested in taking it up. I will check the file you attached and analyze your requirements, and I will deliver the required tasks fast and accurately. We will negotiate my fees depending on how many hours it will take to fulfill the work. I’m Ahmed Hassanein. I’ve been working with MS Office since the 90’s as a user, developer, and trainer. I've been using formulas, VBA, and macros in Excel since 2004. I completed Excel VBA and Google Sheets Apps Script jobs for happy customers (check my job reviews). I would be happy if we connect to talk more about your Job and discuss how I can help you accomplish it. Thank you and kind regards, Ahmed Hassanein
$180 AUD in 7 days
5.0 (1 review)
2.6
2.6
User Avatar
Hey there, My name is Akibul and I was glad to see you are looking for an excel developer. I am planning to write vba code to combine the excel file you mentioned. Let's discuss to move forward. Thanks!!!!!
$150 AUD in 2 days
5.0 (3 reviews)
2.2
2.2
User Avatar
HELLO, I’M A PROFESSIONAL DATA ENTRY EXPERT. I COLLECT DATA FROM PDF/WEBSITE AND FILL IN THE SPREADSHEET WITH DATA IN THEIR RESPECTIVE FIELDS. I WILL PROVIDE YOU WITH HIGH-QUALITY SERVICES AT A REASONABLE DELIVERY TIME. FEEL FREE TO CONTACT ME AT ANY TIME. LOOKING FORWARD TO YOUR RESPONSE.
$70 AUD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I can meet your requirement using vba macros. This can t be done in emergency right now. Thanks, Jpa
$250 AUD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi Clients, I am good fit for this project i can do work early for your project please give me opportunity.
$140 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Give me the project I will give it to you on time . I glade to work with you sir/mam . Be safe always.
$150 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hallo , i will finish this project for 7 days I hope can join in your project Thankyou ………………………….
$240 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hy I am Shravan Meena I have experience of doing data entry from last many years, last days I have done a data entry work and I took $50 for that and they are very satisfied with my work. you can trust me
$140 AUD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Brisbane, Australia
0.0
0
Payment method verified
Member since Dec 5, 2022

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.