by MRGARGSIR
Speed up Estimate Preparation by 90% with built-in templates, automation, and portal-compatible workflows.
Designed for Engineers, Contractors and Department Employees.
This is an independent third-party tool NOT affiliated with, endorsed by, or connected to the HEWP portal or any government department. We are not an official HEWP and are not authorized by the Government in any way.
Estimation & Billing Tool is a comprehensive automation Excel toolkit designed specifically for engineers and Contractor works for Offline Tender and Online Haryana Engineering Works Portal (HEWP). It combines Excel Tool, Chrome/Edge Extension, and web automation to streamline Estimate Preparation, Material Quantity (Consumption) Preparation, BOQ Preparation, and online HEWP work.
- 📊 Preparation of Estimates/Bills - Create new professional Estimates/Bills or Import Pdf Estimates from the Portal to Excel with HSR 2023 rates and latest amendments.
- 🧱 Preparation of Material Consumption - Generate accurate material quantity tables with District wise Material Rates instantly
- 🔄 Do the Variation with Portal Data - Compare and highlight differences between your data and HEWP portal data
- 📤 Upload Estimate/Bill to HEWP Portal - One-click upload to HEWP portal with auto-login
- Civil Engineers
- Contractors
- Estimation & Billing Professionals
- Department Employees
📦 Download from Official Website: https://mrgargsir.github.io/HEWP-Excel-Addins/
- Metal Weight Calculator – Calculate Weight for any shape and any metal.
- Find HSR Item – Search for any Keyword in HSR and find the details.
- Multiply and Get Quantity – Multiply dimensions (Nos. x length × breadth × depth) with advance formula.
- Total Quantity with intelligent Unit Converter – It will do auto Total of one item number's quantities and put in row below, then auto convert to metric units where required and put in row below of total. Also, auto convert to steel kg if required.
- Auto Rate & Description Fetcher – Automatically pull Unit, Rates, Rate Type, and Descriptions from Latest HSR 2023 (Haryana Schedule of Rates) and Amendments and insert for each item.
- Amount Calculator – Compute amounts by multiplying rate × quantity. Also auto-calculates GST, contingency, and grand total with full sheet formatting. Apply the SR number to each item. Prepare Bill or Estimate in Good Format.
- Steel Summary Generator – Create a Dia Wise Steel Consumption summary in Kg at the bottom of the Bill/Estimate.
- Abstract Bill Summary - Generate a complete abstract Bill or estimate summary in a new worksheet, next to the active sheet.
- Quantity of Materials Summary – Generate a complete Material Consumption Summary at the bottom of the Bill/Estimate. A Detailed Material Quantity Table.
- Bill Compare - Generate a comparison of Portal Bill Data with your Excel Bill and get to know the final verdict of the comparison.
- Bill Variation - Generate a Variation of the Portal Bill Data and previously executed quantity, if any, with your Excel Bill or Final Bill and get the status of the data. also it will be used to upload Variation on the HEW Portal via Web Auto Tools.
- Blank Format – Generate Blank Format for manual entry.
- Import Bill/Estimates – Import Downloaded Detailed Estimates, Rough Estimates or Bill Pdf to Excel.
- Server Templates – Access pre-built templates
- My Templates – Manage your custom templates
- Add Template – Create new templates
- Edit Template – Modify existing templates
- Delete Templates – Remove unwanted templates
- Server Drawings – Access pre-built Drawings
- My Drawings – Manage your custom Drawings
- Add Drawings – Add new Drawings
- Delete Drawings – Remove unwanted Drawings
📤 With One-Click ease
- Auto Login to HEWP Portal – Securely log in with saved credentials and Keep Login details for future fast login. Login data is completely saved in your hard drive Excel file. You can verify it anytime.
- Close Chrome & Clean Resources – Closes browser sessions and frees memory.
- Copy Data to HEWP Templates – Automatically convert unit to Meter if required and transfer data into the HEWP Excel template.
- HSR Item Number Selector – Select HSR item numbers on the HEWP Portal for filling and uploading bills or estimates data.
- PDF – it will make a PDF of selected cells, attach and Upload With Manual Entry.
- Upload Template to Portal – Upload your pre-filled template directly to the HEWP Portal.
- Direct Data Entry – Skip the template; Enter data directly into the hewp portal Table.
- Emp Item Number Selector – Select item numbers and Rate Type for Employee ID on HEWP Portal for filling and uploading estimates and variations.
- Download e-MB Bill Data – Download completed bill data from the HEWP portal in Excel Format from HEWP, including a summary sheet.
- Delete e-Mb Bill Data – Remove all previously filled bill data items in one click on the HEWP portal.
- Download Detailed Estimate – Download Detailed Estimate Pdf in two clicks from the HEWP portal in Employee Login.
- Auto Upload Full Bill/Template – Automatically upload The Whole Bill for all Users at one click in the HEWP Portal.
- Auto Upload Variation - Automatically upload Full Variation (Add item, Increase Quantity, Remove item, Decrease quantity) to HEW Portal.
- Jump to any Sheet – Quickly navigate between all worksheets in a workbook with many sheets. So Useful When you have lots of worksheets.
- Refresh Sheet – Instantly refresh the Excel in case Excel becomes unresponsive sometimes.
- Feet ⇄ Meter Converter – Convert imperial to metric units in all Selected Cells with one click.
- Meter ⇄ Feet Converter – Convert metric to imperial units in all selected cells with one click.
- Meter ⇄ Kg Converter – Convert meters to kilograms for all selected cells with one click. It's for Manual Comparison if you want sometimes.
- Toggle Sign – Instantly switch selected values between positive and negative. Useable When You want Deduction Data.
- Formulas To Constant – Convert formulas to static values in all selected cells.
- Insert Row – Insert any number of Entire rows at the selected cell with ease.
- Copy Current Worksheet – Create duplicates of the active worksheet next to the Original Worksheet and Auto Select the Duplicate sheet quickly.
- Steel Weight Calculator – Manually convert running meters, Rebar Length to kilograms based on entered diameter and put this value below the selected total row cell.
- Auto Round Off – Dynamically apply the round-off formula to each selected cell. Existing Round off auto-update on apply.
- HSR 2023/2021 - Open the HSR 2023 and 2021 PDF in your system.
- Unit Adjust - Set and Convert whole bill/Estimate's unit system.
- Create Portal Summary - Create Portal Summary, which will be used for Bill Compare/ Variations.
- Feedback – Quickly provide feedback, suggestions, bug reports, feature requests, enquiries, all in one under a single function.
- Check for Updates - Check for installer updates from this.
- Request - Ask for new features.
- Install RustDesk - for Remote Support, install open source Rust Desk.
- Install Metal Weight Calculator - from Microsoft Store, install app.
- Join WhatsApp Group - Join the MRGARGSIR Tools community for all official updates on WhatsApp.
- YouTube Videos - Watch Tutorial Videos on Official YouTube Channel @HEWPTools
- Get License - Raise a request to get a License.
- Share Referral Code - Share this tool with your friends and coworkers and get Benefits.
- Update Material Rate/Gst - Update Material Rates and Gst from your Consumption table.
- Material Rate Editor - Update Material Rates from all Material Tables.
- Unit System – Set your unit system, you are working in (Imperial or metric).
- Browser - Choose your browser for Web Automation (Chrome or Microsoft Edge).
- Details - See your Filed Detail as Name, District, Mobile Number.
- Reset Templates - If Web Auto uploading Templates have any error then reset them with one click. But it will never happen.
- Reset Rates - Reset Rates if you have done something wrong.
- Activate Licence - New users can activate their licence from this.
- License info - Check your active Licence Info.
- Reverify Licence - if the licence does not sync with the server Auto then use this feature to sync in real time.
- Change Licence Key - Use this to Change your Licence Key.
- Uninstaller - Delete Licence and Disable Tool from Excel.
- Tool Information - Check Tool Info like Internal installed Version, Installer installed version, Tool name, visit website.
- 👍 Special Log Window For Excel Error to fix - Your Data will be With 0% Error.
🚀 A productivity extension for HEWP (Haryana Engineering Works Portal)
📌 Developer: MRGARGSIR
🔗 Added Important Bookmarks – Added Advanced Bookmarks, which will make easy use of the HEWP Portal.
🔍 Smart Tender Search – Enhanced dropdown search for tenders.
☑️ Toggle All Checkbox. – Select/deselect all items at once
🎯 Enter Button Fixes (Pressing the Enter button will not clear the form on the HEWP portal anymore)
🆕 Volume Increase (Volume increase features when low volume media is a problem)
✅ Dark Mode (Enable Dark mode on all websites)
- 🖥️ Windows 7 / 8 / 10 / 11
- 📊 Microsoft Excel 2016 or later
- 🌐 Google Chrome browser OR Microsoft Edge
- 💾 4GB RAM
- 📁 500MB free disk space
- 🖥️ Windows 10 / 11
- 📊 Microsoft Excel 2019 / 365
- 🌐 Latest Chrome/Edge browser
- 💾 8GB RAM
- 📁 1GB free disk space
- ❌ Close all Microsoft Excel windows
- 📂 Extract all files to a folder (if downloaded as zip)
- 🖱️ Double-click
Online Installer.exe ⚠️ If Windows shows security warning, click "More info" → "Run anyway"- ➡️ Click Next → Next → Auto Download → Next → Next → Install
- ⏳ Wait for completion (1-2 minutes)
- 📊 Open Microsoft Excel after installation
- 🔑 Insert your unique activation key if ask
- ✅ Activate the software if ask
- 🔄 Restart Excel to complete setup
[Unique key provided to each licensed user]
Complete step-by-step video tutorials available on our YouTube channel:
Complete Installation Walkthrough @HEWPTools – Full installation guide (5 min)
🎬 Watch Full Playlist Here @HEWPTools
- 📧 Email: help@mrgargsir.store
- 📱 WhatsApp: +91 97285 32828
- 🌐 Website: https://mrgargsir.github.io/HEWP-Excel-Addins/
- 📘 Facebook: https://facebook.com/HEWPTool
- 📸 Instagram: https://instagram.com/HEWPTools
- 🐦 X (Twitter): https://x.com/HEWPTools
- 💬 WhatsApp Group: Join Community
- 📢 WhatsApp Channel: Follow Updates
| Issue | Solution |
|---|---|
| ❌ "Invalid install key" | Check you entered the key correctly (no spaces) |
| ❌ Excel add-in not loading | Restart Excel after installation |
| ❌ Chrome extension not working | Restart Chrome browser |
| ❌ Expired Installer | Contact MRGARGSIR for updated version |
| ❌ Installation blocked | Click "More info" → "Run anyway" on Windows security warning |
Still having issues? Contact us via WhatsApp: +91 97285 32828
- ⚡ Prepare estimates 90% faster
- ✅ Zero alignment errors in templates
- 📊 Professional HSR-compliant documents
- 🔄 Easy variation management
- 📤 Direct portal upload capability
- 💰 Accurate material quantity calculations
- 📋 Professional BOQ preparation
- 🚀 Quick tender document creation
- 🔍 Real-time HSR rate verification
- ⚙️ Complete automation workflow
- HEWP – Haryana Engineering Works Portal
- BOQ – Bill of Quantities
- HSR – Haryana Schedule of Rates (2023 with amendments)
- MB – Measurement Book
- SR – Schedule Rate
HEWP Excel Addins, HEWP tools, Excel addins, HEWP tutorials, HEWP WhatsApp, HEWP YouTube, Estimate, Estimation, billing, bill, boq, tools, boq tool, boq tools, boq mrgargsir, mrgargsir, tool by mrgargsir, tools by mrgargsir, estimates, excel addins, Add-ins, construction estimation software, building cost estimator, quantity surveyor tools, construction billing software, BOQ preparation tool, material estimation, construction project management, Excel automation tools, estimating software India, construction calculator Excel, rate analysis tool, construction costing software, building estimation tool, contractor billing software, civil engineering Excel tools, construction takeoff software, budget estimation tool, construction management Excel, project costing software, residential estimation, commercial estimation, construction quote generator, measurement sheet tool, cost analysis Excel addin, construction database tools, HSR database, QTY tracking, Excel VSTO addins, third party Excel tools, construction industry software, estimator tools, building quantity surveyor, construction documentation tools, Excel plugins for construction, automated estimation software, mrgargsir tools, hewp tool, hewp tools, hewptools, hewptool, mrgargsir store, billing tools, construction reporting tools.
Haryana Engineering Works Portal HEWP ESTIMATE, BOQ, MEASUREMENT BOOK TEMPLATE, HSR 2023 WITH LATEST AMENDMENTS, REAL TIME SEARCH ITEM NO., AUTO UNIT CONVERTER, RATE, RATE TYPE, UNIT FETCHER, AUTO DATA COPY PASTE TO TEMPLATE, AUTO INTELLIGENT DATA ARRANGED IN TEMPLATES WITH 0% ERROR CHANCE, TEMPLATE EXCEL UPLOADER TO PORTAL, CHROME BOOKMARKS LINK FOR SHORTCUTS ON WEBSITE - SAVE LOTS OF TIME, SEARCH BAR FOR HSR ITEM NUMBER AND SEARCH BAR FOR TENDER And All DropDown ON HEWP PORTAL via Chrome Extension, ONE CLICK INSTALLER. Available for Both CONTRACTOR AND EMPLOYEE LOGINS.
© MRGARGSIR 2026 – All rights reserved
This software is proprietary and licensed for use only by authorized customers with valid license keys.
Thank you for choosing MRGARGSIR HEWP Tools! 🚀
We're committed to making your engineering work faster, easier, and error-free.
For the latest updates, tutorials, and support:
- 🌐 Visit: mrgargsir.github.io/HEWP-Excel-Addins
- 📺 Subscribe: YouTube Channel @HEWPTools
- 💬 Join: WhatsApp Community
Made with ❤️ for Engineers and Contractors
