Automated Masonry Estimating Workbook Revamp

Заказчик: AI | Опубликовано: 26.04.2026
Бюджет: 750 $

I have an Excel-based estimator that already ties quantities, cost analysis, and profit analysis together for masonry work. What I don’t have yet is the speed and flexibility that real-world bids demand. Here is the outcome I’m after: • One central dashboard where I can change project variables once—things like rebar spacing, block or brick size, labor productivity, waste factors—and have every linked sheet refresh instantly. • Automated material cost calculations that pull unit prices from a dedicated table and multiply them by the live quantities generated from those variables. • Built-in profit analysis that adjusts automatically as those quantities and costs move, so margin checks happen in real time. • Simple drop-downs or input cells that let me switch among CMU, brick, or stone assemblies. Each material family should already know its standard accessories (ties, mortar, grout, rebar) yet stay open for regional tweaks in mix designs or code requirements. • An easy way for me to add new material types or regional standards later without editing a maze of formulas—ideally through a “Factors” sheet or a well-commented VBA module. The workbook currently has the basic sheets and formulas; the job here is to restructure it with clear data tables, dynamic named ranges, and, where it makes sense, VBA macros or Power Query so every calculation reacts immediately to changes. Clean, documented code and intelligible cell naming are essential so I can maintain it after delivery. Acceptance criteria: • I change a spacing value or switch from CMU to brick and see every cost, quantity, and profit line update correctly. • No broken links, circular references, or hidden errors (tested with sample data I’ll supply). • All formulas and macros are commented so I can extend them for future regional factors. If you live and breathe Excel automation—advanced formulas, structured tables, VBA, maybe a sprinkle of Power Query—this will feel right up your alley. Let’s turn this workbook into the fast, modular estimating tool my masonry team needs.