
In Progress
Posted
I need an experienced Excel freelancer to upgrade my existing spreadsheet for costing steelwork and cladding. This will help streamline my workflow and integrate with a Word document via mail merge. Atn the moment I input a lot of information manually but someone with advanced knowledge could create a formula to do the same thing automatically. Most of the criteria is either a maths formula with a what if behind it. There is another spreadsheet that possibly could be added in or connected to it. Requirements: - Calculate costs: materials, labour, and plant hire. - Enter quantities using formulas after inputting criteria. - Enable mail merge with a linked Word document. Ideal Skills: - Advanced Excel skills - Experience with mail merge - Strong attention to detail Please provide a sample of similar work done. I look forward to your proposals!
Project ID: 40801053
55 proposals
Remote project
Active 6 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
55 freelancers are bidding on average £41 GBP/hour for this job

Replacing manual costing work with a spreadsheet that calculates, connects, and runs reliably is exactly the kind of Excel automation I specialise in. I build custom Excel systems with formulas, VBA, macros, and Power Query, including financial models and operational spreadsheets designed for live business use rather than simple templates. My recent work includes an AI-integrated commission automation system built in Excel and Gemini, a VBA-driven investment forecasting model described by the client as “masterfully executed,” and inventory, headcount, and project management systems. That experience directly supports your requirements for material, labour, and plant-hire costing, criteria-based quantity calculations, what-if logic, and integration with a linked Word mail-merge document. I can also audit and connect the additional spreadsheet where appropriate, while keeping the workbook accurate and practical to use. I would be pleased to upgrade your steelwork and cladding costing system and provide a relevant sample of my spreadsheet automation work. Choose me for a precise, business-focused Excel solution that reduces repetitive data entry.
£18 GBP in 40 days
8.3
8.3

Your estimator should turn a few job inputs into reliable steelwork and cladding quantities, costs, and a Word-ready quotation—without repeated manual entry. I’ll review your existing formulas and the second spreadsheet, then build clear input fields, rate lookups, and conditional calculations for quantities, waste, materials, labour, and plant hire. I’ll keep assumptions visible so you can update rates without breaking the calculations. For Word, I’ll create a consistent, one-row-per-quote mail-merge source with stable field names, then test it against your document. As a sample, I can build a small demo using dummy job data showing automatic quantity and cost calculations flowing into a Word merge. I won’t share another client’s workbook. Could you send both spreadsheets and the Word document so I can check how the current fields and pricing rules fit together?
£25 GBP in 40 days
5.8
5.8

I can upgrade your steelwork and cladding costing workbook into a more automated, reliable estimating tool. I’ll map the existing inputs and costing logic, then build formulas and what-if calculations for materials, labour, plant hire, and quantity generation. Where appropriate, I can connect the additional spreadsheet while preserving clear data flow and avoiding duplicated manual entry. I’ll also structure the workbook so its outputs integrate cleanly with your Word document through mail merge, with consistent field names and dependable formatting. I’ll test representative scenarios, including changes to key criteria, to ensure calculations update accurately and edge cases are handled. I have experience creating formula-driven Excel workbooks, conditional costing models, linked data structures, and Word mail-merge workflows. I can review your current files first, identify the highest-impact automation opportunities, and provide a practical upgrade that remains easy to maintain.
£18 GBP in 20 days
5.4
5.4

Hi there, I can help upgrade your steelwork and cladding costing spreadsheet into a more automated, reliable tool. I’d review your existing workbook, identify the repeated manual calculations, and build formula-driven inputs for materials, labour, and plant hire, including the “what-if” criteria you use to adjust costs and quantities. I can also connect the relevant fields to your Word document through mail merge, so quotes or costing documents can be generated from the spreadsheet without repeatedly entering the same information. If the second workbook contains useful data, I can assess whether it should be integrated directly or linked. I’ll pay close attention to formula accuracy, input validation, clear input areas, and testing against your current calculations. Could you share the existing Excel and Word files, along with a completed example, so I can assess the formulas and integration requirements? Best regards, Mobasher Reza
£27 GBP in 40 days
4.4
4.4

Hi, I am Adeel. I would start by moving every rate, quantity and factor into one clearly labelled input sheet. The costing then runs on formulas: enter the steelwork and cladding criteria and the materials, labour and plant hire totals update on their own, and a what-if change is just an edited input. The first decision is whether the second spreadsheet is a rate list you already maintain. If it is, I would link it with lookups so prices are updated in one place. For the Word mail merge, I would build a clean output sheet that the merge reads directly, so each quote fills itself in. Over 10 years I have completed 161 projects here and I am in the top 3% of freelancers, as a Microsoft Certified Solution Developer. I am just a message away whenever you want to talk through the rate list and the merge fields.
£18 GBP in 2 days
4.1
4.1

⚠️ If you're not happy, you don’t pay. ⚠️ Hi Client, Thank you for checking my proposal and sharing the detailed project brief. I can build your advanced Excel costing spreadsheet using Excel’s powerful formulas and features with a user-friendly design. I will deliver: • Cost calculations for materials, labor, and plant hire using dynamic formulas • Automated data entry for quantities based on criteria inputs • Seamless integration with a linked Word document for efficient mail merge • Optimization for speed and accuracy, reducing manual input errors • Potential connection to an additional spreadsheet for enhanced functionality You will also receive comprehensive documentation and a quick training session to ensure you can maximize the spreadsheet's capabilities. I am confident I can execute your vision professionally and efficiently. Looking forward to discussing the timeline and next steps. Best regards, Chirag Pipal
£18 GBP in 14 days
3.8
3.8

Lancaster, United Kingdom
Payment method verified
Member since Nov 3, 2026
$10 USD
$30-250 AUD
$15-25 USD / hour
$30-250 USD
€30-250 EUR
€30-250 EUR
₹1500-12500 INR
$30-250 USD
$8-15 USD / hour
min ₹2500 INR / hour
€30-250 EUR
$1500-3000 USD
$30-250 USD
$250-750 USD
$10 USD
₹100-400 INR / hour
$250-750 USD
$200-250 USD
₹75000-150000 INR
₹600-1500 INR