
Closed
Posted
Paid on delivery
I already track my software development schedule in Excel, complete with current %-completion figures. Now I need the whole plan rebuilt in Microsoft Project so I can see—at a glance—planned versus actual progress, slippage, and upcoming workload. Here’s what matters to me: • The task hierarchy, durations, dependencies, milestones, and resources must migrate accurately from the spreadsheet. • Baselines should be set so Microsoft Project’s built-in “% Complete” and variance fields display meaningful comparisons without manual tweaking. • Actual % values I already have need to feed in automatically (a one-click refresh or a simple macro is fine) so the chart stays live as my Excel table updates. • Any custom fields, formulas, or views you add should stay native to MS Project—no third-party add-ins—so I can share the file freely. • A concise hand-off note or short video showing how to update the link and read the variance dashboard will wrap it up. Once finished I expect a single .mpp file, linked (or easily relinked) to my Excel source, displaying clear planned-vs-actual bars and percentage variances that match the figures in the spreadsheet. Accuracy and repeatability are the key success metrics.
Project ID: 40338187
15 proposals
Remote project
Active 21 secs ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
15 freelancers are bidding on average $66 USD for this job

Hi! I am an excel and MS Project expert.. I have read jour job description and understand your requirements. I also have experience of setting up Detail scheduling of project in Primavera so i understand the logics, flow and everything that require for this project, I can start working immediately and complete you work in 48 Hrs. Text me to discuss more...
$100 USD in 1 day
5.7
5.7

Hello, This is exactly the kind of structured migration and automation work I do. You already have the hard part done (a detailed Excel schedule). My role will be to rebuild it in Microsoft Project so it becomes a live, reliable progress dashboard instead of a static spreadsheet. How I will approach your project 1) Accurate rebuild of the schedule Recreate the full WBS hierarchy from Excel Import durations, dependencies, milestones, and resources correctly 2) Proper baselining for real variance tracking Set and lock baselines the right way Configure % Complete, Work, and Schedule Variance fields so planned vs actual works natively (no manual adjustments) 3) Live link with Excel (auto-refresh) Build a clean Excel ↔ MS Project link using native tools only Map your existing Actual % Complete to the correct Project fields Provide a one-click refresh (or simple macro) so updates flow instantly 4) Clear variance dashboard Configure views showing: Planned vs Actual Gantt bars Slippage & upcoming workload Variance and progress indicators Everything remains fully native to MS Project (no add-ins) 5) Smooth handoff Deliver the final .MPP file ready to use Provide a short guide/video showing: How to refresh the Excel link How to read the dashboard and variance views I can start immediately and complete this efficiently. Looking forward to working with you. Best regards, Faizan.
$20 USD in 7 days
5.3
5.3

Hi, I have reviewed your request to automate the sync between Excel and MS Project. I understand that you need a 'Live' connection where your Excel data entry drives professional MS Project variance reporting without the headache of manual re-typing. My Execution Plan: - The Sync Engine (VBA): I will build a lightweight, native VBA macro within your .mpp file. This will allow you to refresh your %-completion and actual dates from your Excel source with a single click, preserving your task hierarchy and dependencies. - Variance & Slippage Views: I will configure the 'Tracking Gantt' and 'Work Variance' views. By setting a formal Baseline, MS Project will automatically visualize the gap between your 'Planned' schedule and your 'Actual' Excel progress. - Native Integration: No third-party tools or add-ins. I will use standard MS Project fields so you can share the file with any stakeholder who has Project installed. - Educational Hand-off: I will provide a short video demonstrating how to map new tasks and interpret the 'Slippage' bars, ensuring you are 100% self-sufficient. Milestones: 1. Data Mapping: Aligning your Excel columns with MS Project's internal fields. 2. Macro Development: Building the one-click refresh logic. 3. Reporting Setup: Configuring the Baseline and Variance dashboards. I focus on making your tools work for you, not the other way around. Regards,
$200 USD in 2 days
5.2
5.2

With my proven track record of providing accurate and efficient data management and automation services, I am the ideal freelancer to automate your Excel plan in Microsoft Project. I possess expert-level skills in Excel and Project Management which will ensure that the migration of task hierarchy, durations, dependencies, milestones, and resources is flawless. I understand the importance of having baselines properly set to display meaningful comparisons, and I will make sure that your "percent complete" and variance fields are configured appropriately for accurate tracking without manual tweaks. Having worked extensively with both Excel and Microsoft Project, I am confident in creating a seamless link between the two where your actual % values can be easily refreshed or updated with just one click. This would enable your chart to stay live as your Excel table updates. My specialized Excel skills also empower me in creating innovative custom fields and formulas or views that will remain native to MS Project, alleviating any dependency on third-party add-ins while sharing the file freely. What distinguishes me from others is my commitment to delivering fast, accurate, and on-time service without sacrificing quality - is evident with my ⭐⭐⭐⭐⭐ rating. You can rely on my efficiency for handling large data sets and proficiency in resolving complex intricacies. Upon project completion, you can
$50 USD in 1 day
4.0
4.0

As a seasoned Zapier Expert with extensive experience in Excel, Google Sheets, and various frontend and backend technologies such as App Script, Java Script, React js, Node js, HTML, and CSS, I have a firm understanding of your project requirements. I possess the skills to accurately migrate the important aspects of your software development schedule from Excel to Microsoft Project without any loss or misalignment of data. Furthermore, my proficiency in creating custom fields, formulas, and views within the native environment of MS Project ensures that the file remains easily shareable without relying on any third-party add-ins. I understand the significance of accuracy and repeatability in software schedules, and guarantee you a meticulously created .mpp file that accurately showcases planned versus actual progress while maintaining the %-completion figures from Excel. I will also provide you with a concise hand-off note or video tutorial guiding you on how to update the link and interpret the variance dashboard seamlessly. Choose me for your project and let's automate your workflow efficiently!
$20 USD in 7 days
3.3
3.3

Hi! I can automate your workflow with Python. Save hours of manual work with custom scripts. Clean code, fast delivery. Available to start now!
$10 USD in 5 days
0.0
0.0

I can convert your Excel schedule into a fully structured MS Project file with correct hierarchy, dependencies, baselines, and live % completion tracking linked to your spreadsheet. You’ll get an automated refresh setup (no add-ins) plus clear variance views for planned vs actual progress. Let’s connect and make your project tracking accurate and effortless ?
$20 USD in 2 days
0.0
0.0

Hi, I can easily DO your work IN 24 HOURS, DM me now to get started, PRICE NEGOTIABLE 100% Work satisfaction is provided
$20 USD in 1 day
0.9
0.9

Hello there, I read the full project description and I can do this. I have experience working with Microsoft Project and Excel integrations, creating structured project plans with accurate tracking of progress, baselines, and variances. I can rebuild your Excel schedule into Microsoft Project with full alignment of tasks, dependencies, and resources while ensuring your actual progress updates seamlessly. My approach: • Import and structure your task hierarchy, durations, dependencies, and milestones accurately • Set baselines to enable clear planned vs actual comparisons • Map your existing % completion data into MS Project fields • Create a dynamic link (or simple macro) for one-click updates from Excel • Configure custom views to highlight slippage, workload, and variance Deliverables: • Fully structured .mpp file with accurate project data • Linked (or easily relinkable) Excel integration • Clear planned vs actual tracking with variance indicators • Native MS Project setup (no external add-ins) • Short hand-off guide or video explaining updates and dashboard usage I focus on accuracy, automation, and making your tracking system easy to maintain and reliable over time. I’m ready to start and ensure everything reflects your current data perfectly. Regards, Raakesh
$100 USD in 7 days
0.0
0.0

Doha, Qatar
Member since Mar 31, 2026
₹200-450 INR / hour
₹600-1500 INR / hour
€30-250 EUR
₹75000-150000 INR
$15-25 USD / hour
₹750-1250 INR / hour
₹12500-37500 INR
$250-750 USD
$750-1500 SGD
$250-750 AUD
$30-250 CAD
$750-1500 USD
$250-750 USD
₹600-1500 INR
$3000-5000 USD
€8-30 EUR
$30-250 USD
$250-750 USD
₹750-1250 INR / hour
£5-10 GBP / hour