Google sheet automation for mechanical BOQ
₹1500-12500 INR
Maksettu toimituksen yhteydessä
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]
Projektin tunnus: #33714047
Tietoa projektista
5 freelanceria on tarjonnut keskimäärin ₹7600 tähän työhön
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 Lisää
I am a Billing engineer in construction company and these days I am free at home and I want to do some work.
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 Lisää
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.
