Construction Estimate By Max Fajardo Excel Jun 2026

Create a table in the sheet:

Go to to create a dropdown (Class A, B, C) so you don’t have to type every time. Use VLOOKUP or INDEX-MATCH to retrieve Fajardo’s constants.

Store current material prices in a separate sheet. Use VLOOKUP in your calculation cells so updating the price of cement in one place updates all estimates instantly. construction estimate by max fajardo excel

The power of these spreadsheets lies in the "input-output" design. You typically enter the project dimensions in designated "yellow cells," and the sheet automatically generates the material list. Example: Concrete Slab Estimation

. Instead of guessing how much cement you need for a slab, you can program Excel to use Fajardo’s standard mix classes: Slideshare Class AA (1:1.5:3): Used for underwater or high-strength structures. Class A (1:2:4): Standard for slabs, beams, and columns. Class B (1:2.5:5): Common for wall footings and floorings. Class C (1:3:6): Used for plant boxes or non-structural fill. Excel Tip: Create a table in the sheet: Go to

Automate concrete material quantities (cement, sand, and gravel) by applying Fajardo’s multipliers for different mixtures (e.g., Class A, B, or C). : Length ( ), Width ( ), and Thickness (

1. Solve for the volume of concrete pavement, convert 6 SOLUTION. ... V = . 15 x 6.00 x 1,000 m. ... Sand: 900 x . 50 = 450 cu. m. ESTIMATE by Max Fajardo PDF | PDF | Foot (Unit) | Concrete Use VLOOKUP in your calculation cells so updating

| Component | Total Cost | | --- | --- | | Masonry | ₱200,000.00 | | Painting | ₱160,000.00 | | Electrical | ₱200,000.00 | | | ₱560,000.00 |

To create an Excel template for construction estimating using the Max Fajardo method, follow these steps: