Google sheet automation for mechanical BOQ

I am a freelance mechanical Estimator, I need to automate my BOQ.

Automation Procedure

1. Using a client-oriented Pricing software which is cloud-based for the pricing. after the pricing, I can get the output as an . XLS file. there will be 2 files which are detailed below.

Output 1: Material Price

Output 2: Labour Price.

(Both files are having the material described as common.)

2. Now, I have the Custom made BOQ file which has the data linking formulas, graphs, summary tabs etc. I'll call it as the "Std. Mechanical BOQ".

3. I need to copy-paste the material's unit cost value and the labour hour from the both files to the Std.BOQ.

4. The Std. Mechanical BOQ has the necessary formulas and linking to the summary to carry over the data that I entered manually.

5. The summary will call the necessary values and it'll further process the Totals.

Reference Links

- Std. Mechanical BOQ: [login to view URL]

- Input 1: Unit Materials price (for the Std. BOQ the Output file will be the Input): [login to view URL]

- Input 2 : Unit Labour Hour : [login to view URL]

Skills: Google Sheets, Google Apps Scripts, Bill of Materials (BOM) Analysis

About the Client:
( 0 reviews ) Trivandrum, India

Project ID: #33714047

5 freelancers are bidding on average ₹7600 for this job


Hi, I don't clearly really know what your project is about in details but if it makes sense, if respect for diversity is one of your values, we can probably build together. And if in addition to that, the development o More

₹10000 INR in 3 days
(1 Review)

GOOGLE SHEETS EXPERT SOFTWARE DEVELOPER DEAR EMPLOYER, I can assure you 100% that we are fully capable of executing any level of task/project based on the skill required. I am fully confident about our skills and my un More

₹7000 INR in 7 days
(0 Reviews)

I am a Billing engineer in construction company and these days I am free at home and I want to do some work.

₹7000 INR in 7 days
(0 Reviews)

Hi this is namrata. I am good learner and quick also. I will always try to complete assigned work in given time. As I also having an experience in cost estimation and I think that it will give me chance to show you tha More

₹7000 INR in 7 days
(0 Reviews)

Hi, Currently I am working as a design engineer and do costing of fabricated parts like front axle beam and brackets of tractors. I want to work with you to gain new things.

₹7000 INR in 7 days
(0 Reviews)