
Closed
Posted
Paid on delivery
I’m coordinating several parallel projects and need a single, easy-to-maintain timeline that shows every task, its owner and all task-to-task dependencies. The entire schedule must live in Microsoft Excel so I can share it freely inside the company without additional software. I’ll supply the raw task lists, dates and responsible people; you transform that into a master worksheet that rolls up each project while still letting me drill down to individual tasks. Dependencies should automatically shift dates when predecessors move, and colour-coding by owner or project will make the chart instantly readable. Wherever practical, please rely on formulas and simple conditional formatting rather than heavy macros so the file remains lightweight and future-proof. Deliverables • One Excel workbook containing – A consolidated Gantt view spanning all projects – Separate detail sheets (or filtered views) where I can focus on each project individually – Clear visual indicators of task status, owners and dependencies • A short “How-to” tab explaining any formulas, named ranges or update steps Acceptance criteria: the Gantt adjusts correctly when I change a predecessor’s date, no broken links or #REF errors appear, and the file opens cleanly in current desktop versions of Excel without security warnings. If this sounds like something you’ve done before, let’s get started—I’m ready to send the task lists right away. See attached documents
Project ID: 40790157
113 proposals
Remote project
Active 8 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
113 freelancers are bidding on average $110 USD for this job

Hi there, I have carefully reviewed your project and understand that you need a centralized Excel-based Gantt planner that consolidates multiple projects while keeping task ownership, dependencies, and scheduling updates accurate. I’m confident I can build a maintainable workbook using formulas and conditional formatting rather than relying on heavy macros. First, I’ll review your task lists and map project tasks, owners, statuses, dates, and predecessor relationships into a structured master table. Then, I’ll build a consolidated Gantt chart with project-specific detail sheets, clear status indicators, and colour-coding by project or owner. Next, I’ll implement dependency-driven date calculations so schedule changes flow through dependent tasks, with safeguards against circular references and broken formulas. Finally, I’ll test the workbook using realistic schedule changes and add a How-to tab covering formulas, dependencies, and routine updates. Could you confirm whether task durations should remain fixed when a predecessor moves, or should dependent tasks also recalculate their durations? I also have ideas for adding overdue-task indicators and project-level progress summaries. Please initiate a chat so we can discuss the technical requirements and next steps. Cheers, Aneesa
$75 USD in 1 day
7.8
7.8

Hello, I will build a consolidated Excel Gantt schedule that brings all projects into one clear timeline while keeping individual tasks, owners, statuses and dependencies easy to track. I have checked the attached requirements sheet and your task lists, then I am going to structure the workbook around a consistent task table with formulas to calculate dependent dates and conditional formatting to highlight project ownership and progress. The workbook will include a master Gantt view, project-specific filtered views and a How-to tab explaining how to update tasks and maintain dependencies. I will also test date recalculation when predecessor tasks move, check for broken references and verify compatibility with current desktop Excel, keeping VBA to a minimum or avoiding it where practical.
$76.11 USD in 2 days
7.3
7.3

Multi-level dependency chains in pure formulas tend to break on inserted rows or throw circular references. Ours stay intact when you reorder, add or delete tasks. Day 1: a working draft loaded with one of your projects so you can test shifting a predecessor yourself. Day 3: the complete workbook with all projects and the how-to tab, checked for errors and warnings. 1. Should shifted dates skip weekends and company holidays, or count calendar days? 2. Can a single task have more than one predecessor? Send the task lists over and we can start today.
$75 USD in 3 days
6.5
6.5

I have 14 years of experience in technical development, data processing, automation, and structured reporting. I can turn your task lists, dates, owners, and dependencies into a clean, easy-to-maintain Excel master schedule covering all projects in one workbook. I would build a consolidated Gantt chart with separate project-level views, clear owner and status indicators, and dependency tracking. Where practical, I would use Excel formulas, tables, data validation, and conditional formatting instead of macros, keeping the workbook lightweight and easy to share across your company. The key is making the schedule genuinely dynamic: task dates should recalculate when predecessor dates change, while dependency relationships, project roll-ups, and visual indicators remain consistent. I would also test the formulas and references to avoid broken links and #REF! errors, and include a How-to tab explaining how to update tasks, manage dependencies, and maintain the workbook. I can review your supplied PDF and Excel files, organize the relevant project information, and structure the workbook around your actual requirements rather than using a generic template. I work efficiently and can deliver an initial working version quickly, followed by revisions based on your feedback. My pricing is flexible and open to discussion based on the scope. I’m ready to review the task lists and confirm the dependency rules before building the master workbook.
$30 USD in 1 day
6.0
6.0

Hi there, I went through your project description and understand you need a consolidated Excel Gantt chart that brings multiple projects into one master timeline while keeping individual tasks, owners, statuses, and dependencies easy to manage. I will organise your supplied task lists into a structured Excel workbook with a master Gantt view, separate project-level detail sheets or filtered views, and clear colour-coding for ownership and project status. I will use Excel formulas, dependency logic, named ranges where appropriate, and conditional formatting to keep the workbook lightweight and maintainable without relying on unnecessary macros. When a predecessor's schedule changes, dependent task dates will recalculate according to the agreed scheduling rules. I will also include validation checks to help prevent broken references, inconsistent dates, and formula errors. A dedicated How-to tab will explain the workbook structure, key formulas, dependency updates, and steps for adding new projects or tasks. I will test the workbook in desktop Excel before delivery. I will provide an initial workbook structure and implementation plan within 24 to 48 hours of award. To scope your project clearly, could you share the attached task lists and confirm whether dependencies should automatically calculate start dates, finish dates, or both? I look forward to building a clear, reliable master schedule for your team. Kind Regards, Imran Ali
$75 USD in 1 day
6.2
6.2

Hello, Thank you for sharing the project requirements. I’d be happy to help create a consolidated, easy-to-maintain Excel Gantt chart covering all your projects, with clear task ownership, dependencies, status indicators, and automatic date adjustments. My approach will be to use Excel formulas, structured tables, and conditional formatting wherever possible, keeping the workbook lightweight and compatible with current desktop versions of Excel. I’ll include a master Gantt view, separate project-level detail sheets or filtered views, and a How-to tab explaining the formulas and update process. To ensure the timeline works as expected, could you please clarify a few details? 1. Approximately how many projects and individual tasks will the workbook contain? 2. Would you prefer a daily or weekly timeline? 3. Can tasks have multiple predecessors, including dependencies across different projects? 4. Should the schedule account for weekends and public holidays when calculating task dates? Once you share the task lists and attached documents, I’ll review the data structure and confirm the best setup and estimated turnaround time. I’ll also test the dependency formulas and date adjustments to minimize errors and ensure the workbook is straightforward to maintain. I look forward to working with you.
$180 USD in 1 day
6.1
6.1

Coordinating technical projects and organizing complex workflows is a core part of my experience, making me well suited to build a clear Excel-based Gantt system for your parallel projects. I can turn your task lists, dates, owners and dependencies into a consolidated schedule that remains practical to maintain and easy to share internally. My skills in Excel, data processing and data visualization support the specific needs of this workbook: readable project and owner colour-coding, status indicators, dependency tracking, project-level detail views and a concise How-to tab. My background in project coordination and workflow documentation also helps ensure the workbook is structured clearly, avoids unnecessary complexity and remains useful for ongoing updates. I’m ready to create an organized, formula-focused Excel workbook that meets your acceptance criteria and gives you reliable visibility across every project. Choose me to turn the supplied documents into a professional master schedule.
$140 USD in 2 days
5.5
5.5

Hi, this is a clear spreadsheet build, and the dependency logic is the part that decides whether the file works. I'd start with your task lists to check how the dates, owners, and predecessors are structured, since missing or inconsistent predecessor IDs are what usually break a Gantt. Then I'd build one master sheet with a row per task, start and end dates calculated from duration and predecessors using formulas, and conditional formatting for owner, project, and status. Each project would get a filtered detail view, and a roll-up at the top would show each project's start, finish, and progress. To keep the file lightweight and free of macros, dependencies would use formulas that shift dates when a predecessor moves. I'd test that by changing a few predecessor dates and confirming the downstream tasks update with no #REF! errors. A short How-to tab would explain the formulas, named ranges, and the steps to add a new task. I can send a fixed price and timeline once I've reviewed the task lists. Let me know if you'd like me to take it from here. Juan Pablo
$140 USD in 7 days
4.4
4.4

Your TASAC sheet already has the lead times that will set the ECD dates: NEMC certificate 6 months (maybe 1 year), OSHA inspection 3 months, regulator preliminary approval 1 month after the contract. I would enter those as linked tasks, so if the Maersk lease or the NEMC date slips, everything after it moves by itself. Before writing this I made a small test workbook with your lease and TASAC items. Start = finish of the predecessor + lag, in working days, using plain formulas (WORKDAY + INDEX/MATCH). Changing one date moved the whole chain, with no #REF errors and no macros. What you would get, in one .xlsx file: - Tasks sheet: ID, project, task, owner, predecessor, lag, duration, start, finish, status, % done. This is the only sheet you type in, so updating is one place, not three. - Master Gantt across all projects (lease, land purchase, TASAC licence and any others you send), coloured by project, with owner and status shown on each row. One view for management. - One detail sheet per project with the same bars, so each team sees only its own tasks. - Status marks (not started / in progress / done / late), plus a red flag when a task ends after its target date. - A short "How-to" tab: how to add a task, link it, change a date and add a new project. What I need from you: the task lists, dates and responsible people you mentioned. I start as soon as they arrive. Three questions so it fits on the first try: 1. Which Excel version do you use (365 or an older one like 2016)? It decides which formulas I can use. 2. Is the working week Monday to Friday, or Monday to Saturday? Should Tanzanian public holidays be skipped? 3. Can a task wait for more than one other task (for example, the licence needing both the lease and NEMC)? I can allow up to 3 predecessors per task. Suggested milestone breakdown (total USD 110, 3 days): - M1 USD 22 (20%): Tasks sheet + master Gantt with your real data, for your check - M2 USD 44 (40%): project detail sheets, status marks, owner colours - M3 USD 44 (40%): How-to tab + changes after your review Fund M1 to start, release when happy, then fund the next. Standard Freelancer escrow protects both of us. Why me: I am an engineer and I work on projects where permits and approvals drive the schedule, so I build plans from the lead times outward. I keep files formula-based so they still work when someone else opens them a year later. Ready to begin the moment you award and fund M1. Amr
$110 USD in 3 days
4.2
4.2

Hello, I can build the Excel master Gantt from the task lists, dates and responsible people you supply. My background includes Excel/VBA, Office automation and software development. The workbook would include a consolidated timeline, project-level views, owner/status colours, predecessor-driven date updates and a short How-to tab. I would use formulas and conditional formatting rather than heavy macros, and test date changes through the dependency chain, broken references and clean opening in desktop Excel. I can see the two attachment names, but their download buttons are not opening for me. Please resend them in chat along with the task lists. Before accepting an award, I would confirm the task count, multiple or cross-project predecessors, working-day/holiday rules and alignment with those documents. My proposed $250 and 7 days cover the workbook described above once the final task data and dependency rules are agreed; any additional scope would be discussed first. Regards, Mohamed Amr
$250 USD in 7 days
4.2
4.2

A consolidated Excel Gantt chart that remains accurate as dependencies and dates change requires careful data processing and a clean, maintainable structure. My background in software engineering, combined with skills in data analysis and data processing, fits the need for a reliable workbook that turns raw task lists into a clear multi-project schedule. I can create a lightweight Excel solution with a consolidated timeline, project-specific detail views, task owners, statuses, dependency relationships, and practical conditional formatting. I will keep the workbook organized and easy to update, with formulas, named ranges where appropriate, and a clear How-to tab explaining the update process. I will also focus on avoiding broken references and unnecessary macros so the file remains easy to share within your company. I’m ready to turn your project data into a dependable Excel planning tool and would be glad to take this on.
$70 USD in 1 day
3.9
3.9

Tracking task dependencies across multiple projects in Excel gets messy fast and eats up your time. You’ll have a single timeline where every owner and dependency is crystal clear, and shifting dates for one task instantly updates the rest. No more broken charts or scrambling to explain changes. First I’ll confirm how you want dependencies displayed and which owner colours matter most. Then I’ll build a master Gantt with drilldown sheets and formulas that keep everything in sync, using only what Excel does best. You get a quick “How-to” tab so anyone in your company can update or review it without me. You’ll always get a clean file that opens up in Excel with zero warnings or broken links. How do you want tasks grouped in the main Gantt view, by project or by owner?
$80 USD in 7 days
3.7
3.7

I can build a formula-driven Excel schedule with a consolidated Gantt view, project-level detail, owner/status colours and a clear How-to tab. I would use task IDs and predecessor links so date changes flow through the schedule, with working-day rules agreed before setup. I will test single and multiple predecessor changes, missing IDs and circular dependencies, and keep the workbook free of macros and external links. My $220 quote covers up to 5 projects and 200 tasks, with delivery in 6 days. Please confirm the Excel version, task count, dependency types and holiday calendar, and whether the attached documents are the final task list or reference material.
$220 USD in 6 days
3.7
3.7

You get one Excel workbook with a master Gantt for all projects, a sheet per project, owner colours, and dates that shift when a predecessor moves, with no macros. The risky part is the date chain. Each start date will be a formula reading its predecessors, so one slip carries down the chain, and loops between tasks are where sheets like this break. I'll flag any loop as a visible warning. I'd work in this order: 1. Turn your task lists into one table with task, project, owner, predecessor ID and duration. 2. Write the start-date formulas and test a moved predecessor on your first project. 3. Build the master Gantt and per-project views with conditional formatting by owner and status. 4. Add the How-to tab covering named ranges and update steps. Move one predecessor date on that first sheet and check the chain shifts before you pay the rest. - 50 USD for steps 1 and 2, the working sheet for your first project, sent tonight. - 50 USD for steps 3 and 4, once every project view and the How-to tab are done. I'm available now.
$100 USD in 3 days
3.4
3.4

Hi, My approach would use structured tables for the master task list, with columns for project, task, owner, start, duration, predecessor and a calculated end date. The dependency shift would be handled by a formula that looks up the predecessor's end date and sets the successor's start from it, with a working-days option using WORKDAY. For the Gantt view, conditional formatting fills the cells between start and end date, and the whole chart is driven by the task table, so changing one date ripples through the chain. The project detail sheets would be filtered views over the same table, not separate copies, which is what keeps the file lightweight and prevents the broken links you want to avoid. The honest limitation: formulas handle single predecessors cleanly, and multiple predecessors with complex logic get fragile. If your dependencies are mostly finish-to-start chains, this works well. If they involve lag times, resource constraints or branching logic, the realistic choice is a small VBA routine or accepting manual adjustment on those specific tasks. The How-to tab would document the named ranges, how to add a task, how to set a predecessor, and what to do when a date change does not propagate. One question before quoting: are the dependencies mostly one predecessor per task, or do tasks commonly have several predecessors that all must finish first?
$100 USD in 7 days
3.4
3.4

Your brief mentions several parallel projects with task-to-task dependencies, and I've dealt with exactly that kind of chain. In the Maersk ECD land project, lease signing, site clearing, title and construction all had to follow a strict order for a Q1 2027 handover. The TASAC licence checklist was similar: OSHA 3 months, NEMC up to 6, site readiness gating the ERB statement. I'd build one task table with owner, predecessor and lag, where start equals latest predecessor finish plus lag, so a moved date flows through everything. A consolidated Gantt on conditional formatting, colour-coded by owner, plus a filtered sheet per project and a How-to tab. No macros, no #REF errors. Which Excel version does your team use, and how many tasks per project?
$220 USD in 5 days
3.5
3.5

Hi, I can turn your task lists into a centralized Excel project schedule where all projects share one consolidated Gantt chart, with clear task ownership, status indicators, and dependencies that automatically recalculate dates when predecessor tasks change. I would structure the workbook around a master task table with unique task IDs, project names, owners, start dates, durations, predecessor IDs, and status. Formula-driven scheduling will calculate dependent task dates, while conditional formatting will distinguish projects, owners, overdue tasks, and progress. Each project can have its own filtered view, with a How-to tab explaining how to update tasks and maintain dependencies. I’ll prioritize standard Excel formulas and conditional formatting over VBA to keep the workbook easy to share and maintain. Please send the attached documents and task lists, and I’ll use them to establish the workbook structure and dependency logic. Best Muhammad Saad
$140 USD in 7 days
3.4
3.4

Hi, We would build one formula driven workbook around a Tasks table holding project, task, owner, start, duration, predecessor and status. The difficult part is dependency logic: each start is calculated from its predecessor finish with XLOOKUP plus an optional lag, so moving one date shifts every downstream task without macros. The Gantt grid uses conditional formatting against a date header to draw bars coloured by owner or project, with clear markers for status. A master sheet rolls each project up to a summary bar from earliest start to latest finish, while per project views let you drill into any single project. Data validation on owners and predecessors plus IFERROR guards will prevent #REF errors. We will save it as a plain .xlsx with no macros or external links and add a How To tab covering formulas, named ranges and update steps. Which Excel version does your team use, since dynamic arrays need Microsoft 365 or 2021? Can one task have several predecessors? We suggest building one project from your task list as the first milestone. Can we hold a 10-minute call on Freelancer to review our plan and proposed timeline so you can decide how to proceed? Regards, Bits Collision
$115 USD in 2 days
2.8
2.8

Coordinating parallel projects from one Excel file means the Gantt must do real work: when a predecessor slips, every downstream task shifts automatically so you always see a realistic schedule without manual row-by-row fixes. Color-coding by owner and project, combined with a master rollup that still lets you drill into individual timelines, is exactly the kind of structural Excel design this job calls for. I build multi-project trackers and dynamic dashboards in Excel using structured tables, named ranges, conditional formatting, and formula-driven dependency chains, not clunky manual links. Give me your raw task lists and responsible-person data and I will deliver a clean, documented workbook the team can maintain confidently. Happy to share a sample structure before we start.
$69 USD in 5 days
2.9
2.9

Hello, I can build this Excel-based master project timeline with a clean, reliable, and easy-to-maintain Gantt structure. I’ll consolidate all projects, tasks, owners, dates, statuses, and dependencies, with formulas and conditional formatting that automatically adjust dates when predecessors change. I’ll also create project-specific views, clear visual indicators, and a simple How-to tab explaining the workbook. I’ll test the file thoroughly for broken formulas, #REF errors, and compatibility so it opens cleanly in current Excel versions. I’m ready to review the supplied task lists and get started. Regards, Muzafar
$50 USD in 1 day
2.8
2.8

Dar Es Salaam, Tanzania, United Republic of
Payment method verified
Member since Jan 25, 2018
$30-250 USD
$10-30 USD
$30-250 USD
$30-250 USD
$10-30 USD
$250-750 USD
$2000-3000 AUD
₹12500-37500 INR
$10-30 CAD
$250-750 USD
₹12500-37500 INR
$15-25 USD / hour
$30-250 USD
₹12500-37500 INR
₹750-1250 INR / hour
₹750-1250 INR / hour
₹12500-37500 INR
$25-50 USD / hour
₹12500-37500 INR
₹1500-12500 INR
₹750-1250 INR / hour
₹500000-1000000 INR
₹12500-37500 INR
£18-36 GBP / hour
$10-30 USD