Find Jobs
Hire Freelancers

Advanced Scheduler

$40-70 SGD

Closed
Posted almost 5 years ago

$40-70 SGD

Paid on delivery
I'm in the project management line and I need a scheduler, programmed in MS Excel, that can organise and change project timeline vs tasks based on the desired time horizon. i.e. a scheduler that can switch the level of resolution of the tasks. For e.g., in the main Timeline sheet, the time horizon can be selected (through macro buttons) to choose the resolution of the timeline. view 1: Year on Year timeline. Show tasks and time bars in exact dates with comments field on the bar. view 2: 5-year time line. Show tasks and time bars based on MM-YY with comments field on the bar. Some other requirements: - The time bars in the timeline should be color coded based on the type of tasks - the shading of the color should be based Status of the tasks - the activity name should be shown right beside each time bar. - the Timeline should be able to sort the time bar by (a) Tasks, (b) Responsibility, and (c) Status - each time bar should have the comments pop up when mouse over an individual time bar. In the second sheet, the input field should be a date table with - Tasks: Broad categories - Activities: Sub set of Tasks - Start Date: DD-MM-YY - End Date: DD-MM-YY - Status: "Projected", "Confirmed", "Completed" - Comments: Text - Responsibility: Preset selection of agency's names. - Payment Value: $NN, NNN In the last sheet should be another temporal-fiscal graph that shows the payment milestones and payment amount of the tasks. If this graph can be integrated with Sheet 1: Timeline (maybe show it as a top row), it would be preferred.
Project ID: 19302813

About the project

11 proposals
Remote project
Active 5 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
11 freelancers are bidding on average $88 SGD for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$140 SGD in 3 days
4.9 (376 reviews)
8.1
8.1
User Avatar
Hello, I am independent, experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards Rina B.
$66 SGD in 10 days
5.0 (113 reviews)
6.4
6.4
User Avatar
I am postgraduate (MBA) in finance with more than 5 years of experience in advanced excel, VBA automation and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed couple of automation tools for Ernst and Young also. You can get your work done here with highest quality at lowest price. Looking forward to work with you
$250 SGD in 5 days
4.9 (42 reviews)
5.7
5.7
User Avatar
Hello, i am expert in this kind of jobs samples of my excel VBA jobs https://www.freelancer.com/projects/excel/Create-Excel-Spreadsheet-Macro-that/ https://www.freelancer.com/projects/excel/Make-VBA-code-run-itself/ https://www.freelancer.com/projects/visual-basic/Retrieving-data-from-other-different/ https://www.freelancer.com/projects/Excel/Multiple-Entry-Excel-Macro/ https://www.freelancer.com/projects/Excel/VBA-loop-code-sum/ https://www.freelancer.com/projects/Excel/Complete-Some-Advanced-VBA-Microsoft/ https://www.freelancer.com/projects/Data-Entry/Capture-data-from-website-website-12641885/ https://www.freelancer.com/projects/php/Write-some-Software-12250366/ waiting your answer Regards
$60 SGD in 1 day
4.9 (63 reviews)
4.7
4.7
User Avatar
Industrial Engineer with 7 years of experience in Project Management/ Engineering for major Oil&Gas Projects. Advanced skills in Excel, VBA,MS Project Dashboards, etc. Experience in Project Cost Estimation /Project Finance / Públic and Corporate Bidding / Risk Management/ etc. Formed in PMBOK 6 edition and AACE standards For more details please visit my profile. Best Regards
$46 SGD in 4 days
0.0 (1 review)
0.0
0.0
User Avatar
Hi, I'm expert in project scheduling and I'm located in Johor Bahru. I understand your requirement and would like to make some proposal. Regards, maylynn
$50 SGD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, You can trust my skills and ill provide the macro which will perform as per requirement. Please consider.
$61 SGD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have sound knowledge of Excel and VB also i'm working as the same project in my organization and i can finish this project within days.
$61 SGD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I’m a Planner with great Excel skills and field experience in oil n gas construction. Regards Ainura
$46 SGD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SINGAPORE
Singapore, Singapore
0.0
0
Payment method verified
Member since Apr 21, 2019

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.