by MRGARGSIR

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 Engineer 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.

1. 📊 Preparation of Estimates/Bills - Create professional Estimates/Bills with HSR 2023 rates and latest amendments
2. 🧱 Preparation of Material Consumption - Generate accurate material quantity tables with District wise Material Rates instantly
3. 🔄 Do the Variation with Portal Data - Compare and highlight differences between your data and HEWP portal data
4. 📤 Upload Estimate/Bill to HEWP Portal - One-click upload to HEWP portal with auto-login

For complete tutorials on all features and methods, watch our full playlist:
🎥 Complete Tutorial Playlist on @HEWPTools

• ✅ 90% Time Saved on estimation and billing tasks
• ✅ 0% Alignment Errors with intelligent data arrangement
• ✅ 30+ Professional Tools in one comprehensive package
• ✅ 3-in-1 Solution: Offline Excel + Online Web + Chrome Tools (Portal Error Fixer)
• ✅ HSR 2023 with latest amendments fully integrated
• ✅ Available for both Contractor & Employee logins
• ✅ One-click installer with zero technical skills required
• ✅ Free Chrome/Edge Extension included (No Extra Charges)

• 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.

📦 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

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.
20. Bill Compare - Generate a comparison of Portal Bill Data with your Excel Bill and get to know final verdict of comparison.
21. Bill Variation - Generate a Variation of Portal Bill Data and Previously Executed Qty if any, with your Excel Bill or Final Bill and get status of data. also it will be used to upload Variation on HEW Portal via Web Tools.

• Web 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

📤 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.
12. Auto Upload Variation - Automatically upload Full Variation (Add item, add Quantity, Remove item, remove quantity) to HEW 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)
📌 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

1. ❌ Close all Microsoft Excel windows

1. 📂 Extract all files to a folder (if downloaded as zip)
2. 🖱️ Double-click Installer.exe
3. ⚠️ If Windows shows security warning, click "More info" → "Run anyway"
4. ➡️ Click Next → Next → Install
5. ⏳ Wait for completion (1-2 minutes)
6. 📊 Open Microsoft Excel after installation
7. 🔑 Insert your unique activation key
8. ✅ Activate the software
9. 🔄 Restart Excel to complete setup

[Unique key provided to each licensed user]

Complete step-by-step video tutorials available on our YouTube channel:

1. Complete Installation Walkthrough @HEWPTools – Full installation guide (5 min)
2. E. Tools Tab Features Part 1 – Auto Multiply, Sum, HSR Rate, Amount Calculator
3. E. Tools Tab Features Part 2 – Insert Row, Copy Sheet, Round Off, Metric Units
4. E. Tools Tab Features Part 3 – Steel Functions, Custom Functions, Steel Summary
5. Web Tools Tab Features – Portal integration and complete automation guide

🎬 Watch Full Playlist Here @HEWPTools

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

• 📘 Facebook: https://facebook.com/HEWPTools
• 📸 Instagram: https://instagram.com/HEWPTools
• 🐦 X (Twitter): https://x.com/HEWPTools
• 💬 WhatsApp Group: Join Community
• 📢 WhatsApp Channel: Follow Updates

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