Disclaimer: 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.

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.

📦 Official Website: https://mrgargsir.github.io/HEWP-Excel-Addins/

🎥 YouTube Channel: https://www.youtube.com/@HEWPTools

📞 Support: WhatsApp: +91 97285 32828 | Email: help@mrgargsir.store

🌐 Social Media:

• Facebook: https://facebook.com/HEWPTools
• Instagram: https://instagram.com/HEWPTools
• X (Twitter): https://x.com/HEWPTools
• WhatsApp Group: https://chat.whatsapp.com/DEXKInfvpBd9cLwyaoq0sd
• WhatsApp Channel: https://whatsapp.com/channel/0029VbBYrvx47XeIXLM2PU3u

Estimation & Billing Tool is a comprehensive automation toolkit designed specifically for the Haryana Engineering Works Portal (HEWP). It combines Excel Addins, Chrome/Edge Extension, and web automation to streamline Estimate Preparation, Material Quantity (Consumption) Preparation, BOQ Preparation, and online HEWP work.

Speed up Estimate Preparation by 90% with built-in Templates, real-time HSR search, intelligent copy-paste to templates, one-click uploader, and free Chrome/Edge extension – designed for both Contractors and Employees.

• 90% Time Saved on estimation and billing tasks
• 0% Alignment Errors with intelligent data arrangement
• 30+ Tools Included in one comprehensive package
• 3-in-1 Solution: Offline Excel + Online Web + Chrome Tools (Portal Error Fixer)

• Estimate & Measurement Book templates ready with HSR 2023 structure and latest amendments
• Preloaded MB Templates with HSR Rate fetcher
• Material Quantity Finder with accurate calculations

• Search by HSR item number and auto-fetch Unit, Rate, Rate Type and Description
• HSR 2023 with latest amendments fully integrated

• Upload templates or input data directly to HEWP portal
• Saved credentials & one-click login flows
• Auto-uploader to HEWP and downloader from HEWP

• 🧱 Auto Material Quantity Generator - Instantly Get Consumption Details Table.
• 📌 Smart Copy-Paste – Automatically copy Excel data into the correct template.

• Download prefilled bill data from HEWP Portal
• Create comparison summary with your Excel Bill (BOQ) instantly

• ❌ Empty Bill on Portal - If you need to remove Bill data, Remove with it, it will automatically Remove all items data for a tender.
• 🧠 Intelligent Data Arrangement – Minimizes user input errors, ensuring 0% chance of misalignment.
• 👍 Special Log Window For Excel Error to fix - Your Data will be With 0% Error.

📤 One-Click TOOLS – A comprehensive Excel utility tab for generating bills, estimates, and engineering documents.

1. Jump to any Sheet – Quickly navigate between All worksheets in a workbook with many sheets. So Useful When you have lots of worksheets.
2. Refresh Sheet – Instantly refresh the Excel in case Excel becomes unresponsive sometimes.
3. Insert Row – Insert any number of Entire rows at the selected cell with ease.
4. Copy Current Worksheet – Create duplicates of the active worksheet next to the Original Worksheet and Auto Select the Duplicate sheet quickly.
5. Feet ⇄ Meter Converter – Convert imperial to metric unit in all Selected Cells with one click.
6. Meter ⇄ Feet Converter – Convert metric to imperial unit in all selected cells with one click.
7. Meter ⇄ Kg Converter – Convert Meter to Kilogram unit for all selected cells with One click. It's for Manual Comparison if you want sometimes.
8. Toggle Sign – Instantly switch selected values between positive and negative. Useable When You want Deduction Data.
9. Formulas To Constant – Convert formulas to static values in all selected cells.
10. Multiply and Get Quantity – Multiply dimensions (Nos. x length × breadth × depth) with advance formula.
11. 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.
12. 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.
13. 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.
14. Steel Weight Calculator – Manually Convert running meters Rebar Length to kilograms based on entered diameter and put this value below of selected total row cell.
15. Auto Round Off – Dynamically apply round-off formula to each selected cell. Existing Round off auto-update on apply.
16. Steel Summary Generator – Create a Dia Wise Steel Consumption summary in Kg. at the bottom of the Bill/Estimate.
17. Abstract Bill Summary - Generate a complete abstract Bill or estimate summary in a new worksheet, next to the active sheet.
18. Bill Summary – Generate a detailed summary in a new worksheet and if a portal-downloaded summary is opened, it will auto fetch, compare and highlight differences. It also works for Variation with DNIT QTY.
19. Quantity of Materials Summary – Generate a complete Material Consumption Summary at the bottom of the Bill/Estimate. A Detailed Material Quantity Table.

• Web Templates
• My Templates
• Add Template
• Edit Template
• Delete Templates

📤 One-Click Uploader – Interact directly with the HEWP Portal from Excel.

1. 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.
2. Close Chrome & Clean Resources – Closes browser sessions and frees memory.
3. Copy Data to HEWP Templates – Automatically convert unit to Meter if required and transfer data into the HEWP Excel template.
4. HSR Item Number Selector – Select HSR item numbers on the HEWP Portal for filling and uploading bills or estimates data.
5. PDF – it will Make PDF of selected cells, attach and Upload With Manual Entry.
6. Upload Template to Portal – Upload your pre-filled template directly to the HEWP Portal.
7. Direct Data Entry – Skip the template; Enter data directly into the hewp portal Table.
8. Emp Item Number Selector – Select item numbers and Rate Type for Employee ID on HEWP Portal for filling and uploading estimates and variations.
9. Website Data Scraper – Download completed bill data from the HEWP portal in Excel Format from contractor ID, including a summary sheet.
10. Delete Bill Data – Remove all previously filled bill data items in one click on the HEWP portal in Contractor Login.
11. Auto Upload Full Bill/Template – Automatically upload The Whole Bill for all Users at one click in the HEWP Portal.

• Available for both Contractor & Employee
• One-click installer
• Simple setup with zero technical skills required

🚀 A productivity extension for HEWP (Haryana Engineering Works Portal) automation.
📌 Developer: MRGARGSIR

🔗 Add Important Bookmarks – Add Advanced Bookmarks which will make easy use of the HEWP Portal.

🔍 Smart Tender Search – Enhanced dropdown search for tenders.

☑️ Toggle All Checkbox.

🎯 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)

MRGARGSIR SUITE - INSTALLATION GUIDE

• Windows 7 / 8 / 10 / 11
• Microsoft Excel 2016 or later
• Google Chrome browser OR Edge
• 4GB RAM
• 500MB free disk space

• Windows 10 / 11
• Microsoft Excel 2019 / 365
• Latest Chrome/Edge browser
• 8GB RAM
• 1GB free disk space

1. Close all Microsoft Excel windows

1. Extract all files to a folder (if zip.)
2. Double-click "Installer.exe"
3. If Windows shows a security warning, click "More info" → "Run anyway"
4. Click Next → Next → Install
5. Wait for completion (1-2 minutes)
6. After Installation, Open Excel.
7. Insert Key and Do activate
8. After Activation , Restart Excel.

🔑 YOUR INSTALL KEY: [PROVIDED UNIQUE KEY TO EACH USER]

Complete video tutorials available on our YouTube channel:

1. Complete Installation Walkthrough – Step-by-step installation guide (5 min)
2. E. Tools Tab Features Part 1 – Auto Multiply, Sum, HSR Rate, Amount
3. E. Tools Tab Features Part 2 – Insert Row, Copy Sheet, Round Off, Metric Unit
4. E. Tools Tab Features Part 3 – Steel Function, Custom Function, Steel Summary
5. Web Tools Tab Features – Portal integration and automation

• "Invalid install key" → Check you entered the key correctly
• Excel add-in not loading → Restart Excel after installation
• Chrome extension not working → Restart Chrome
• Expired Installer → Contact MRGARGSIR for updated version

Email: help@mrgargsir.store
WhatsApp: +91 97285 32828
Website: https://mrgargsir.github.io/HEWP-Excel-Addins/

© MRGARGSIR 2026 – All rights reserved

Thank you for using MRGARGSIR Tools! 🚀

HEWP Excel Addins, HEWP tools, Excel addins, HEWP tutorials, HEWP WhatsApp, HEWP YouTube, Estimate, Estimation, billing, bill, boq, tools, 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, construction reporting tools.