SALI Estimates
SALI Estimates
Mod
                    Module of Works            Unit        Unit Cost     Qty          Amount
No.
A BATTERBOARD:
        Measure:
        Total Perimeter                            m             18
        Number of Outer Corner                    units           4
        Number of Inside Corner                   units           0
        Computed Length
        CL = TP + OC*2m - IC*2m                    m             26
B EXCAVATION:
        width                                      m        0.30
        depth                                      m        0.45
        length                                     m       20.00
      volume = w x d x L                              m³       2.70
      width                                           m        1.00
      length                                          m        1.00
      depth                                           m        0.90
      number                                         units     4.00
      volume = w x L x d x n                          m³       3.60
      width                                           m        0.30
      thickness                                       m        0.15
      length                                          m       20.00
      area = w x L                                    m²       6.00
      volume = w x t x L                              m³       0.90
      Materials:
      Gravel bed - 3/4" = [(A1+A2+An)x0.05]+10%       m³       0.66
      Concrete Mixture: Class B - 2000 to 2500 psi
      Portland Cement = Vol x 7 bags/cu.m.           bags        13
      White Sand = Vol x 0.50 cu.m. / cu.m.           m³      0.900
      Gravel bed - 3/4" = Vol x 0.99 cu.m. / cu.m.    m³      1.782
      width                                           m        1.00
      length                                          m        1.00
      thickness                                       m        0.25
      number                                         units        4
      area = w x L x n                                m²       4.00
      volume = w x L x d x n                          m³       1.00
    dim 1                                           m        0.30
    dim 1                                           m        0.30
    length                                          m        3.00
    number                                         units        4
    volume = d1 x d2 x L x n                        m³       3.60
    Materials:
    Concrete Mixture: Class B - 3000 to 3500 psi
    Portland Cement = Vol x 8.5 bags/cu.m.         bags       102
    White Sand = Vol x 0.48 cu.m. / cu.m.           m³      5.760
    Gravel bed - 3/4" = Vol x 0.96 cu.m. / cu.m.    m³     11.520
    dim 1                                           m        0.20
    dim 1                                           m        0.30
    length                                          m       30.00
    volume = d1 x d2 x L x n                        m³       1.80
    Materials:
    Concrete Mixture: Class B - 3000 to 3500 psi
    Portland Cement = Vol x 8.5 bags/cu.m.         bags        34
    White Sand = Vol x 0.48 cu.m. / cu.m.           m³      1.901
    Gravel bed - 3/4" = Vol x 0.96 cu.m. / cu.m.    m³      3.802
    length                                          m        4.00
    width                                               m        3.00
    thickness                                           m        0.10
    volume = L x W x t                                  m³       1.20
    Materials:
    Concrete Mixture: Class B - 3000 to 3500 psi
    Portland Cement = Vol x 8.5 bags/cu.m.              bags       19
    White Sand = Vol x 0.48 cu.m. / cu.m.                m³     1.051
    Gravel bed - 3/4" = Vol x 0.96 cu.m. / cu.m.         m³     2.102
    length                                              m        4.00
    width                                               m        3.00
    thickness                                           m        0.10
    area = L x W                                        m²      12.00
    volume = L x W x t                                  m³       1.20
    Materials:
    Gravel bed - 3/4" = [(A1+A2+An)x0.05]+10%           m³       1.20
    Concrete Mixture: Class B - 2000 to 2500 psi
    Portland Cement = Vol x 7 bags/cu.m.                bags       15
    White Sand = Vol x 0.50 cu.m. / cu.m.                m³     1.095
    Gravel bed - 3/4" = Vol x 0.99 cu.m. / cu.m.         m³     2.168
H FORM WORKS:
    Columns:
    Facing Area (Manually computed)                     m²      25.00
    Facing Member (2"x2") = FA x 10.76BF/m²             BF     269.00
    Support & Brace (2"x2" & 2"x3") = FA x 18.83BF/m²   BF     470.75
    Totals:
    Facing Members (2" x 2" wood)                                 BF     1716.22
    Supports & Braces (2" x 3" & 2" x 4" wood)                    BF     2910.88
    Other Materials:
    Total Facing Area                                              m²     130.00
    Number of Uses                                                uses         3
    Reqd Area = TFA / NU                                           m²      43.33
    Plywood 4' x 8' x 1/4" ordinary = RA / 2.98                   shts        15
    Lumber:
    Facing Members = Total BF / NU                                BF      572.07
    Supports & Braces = Total BF / NU                             BF      970.29
                                                        Total =   BF     1542.37
    Consumables:
    CWN = TBF x 45 / 2500                                         kgs        28
    #16 GI Wires = TBF x 45 / 4000                                kgs        17
I CHB WALLS:
    Materials Required:
    6" CHB = A6 x 12.5                                            pcs        38
    Materials Required:
    4" CHB = A64x 12.5                          pcs         35
J CHB REBARS:
Area (Specify) m² 28
          Transverse Rebars:
          Spacing of Bars                                      m       0.30
          Total length of WF1                                  m      20.00
          Width of Wall Footing                                m       0.30
          Effective Cut Size of Transbars = W-2x0.05           m       0.20
          Number of WF1                                      units        4
          Reqd Number of Cut Size = (L / S) + (1 x units)     pcs        71
          Number of cut size in 1-6m long rebars = 6.0/ECS    pcs        30
          Reqd 6.0m long Rebars = RN / NCS                    pcs         2
          Longitudinal Rebars:
          Number of Logitudinal Bars                         pcs          5
    TNB   Total number of bars                               pcs         20
     CC   Concrete Cover                                      m       0.075
     H    If HookS are required, choose for bar dia:
          for 12 mm (1/2") , add this length                           0.33
          for 16 mm (5/8")                                             0.43
          for 20 mm (3/4")                                             0.51
          for 25mm (1")                                                0.67
    Ø     Bar diameter                                       mm             16
     LB   Length of one bar = L - (CC x 2) + H                  m       1.28
    NCS   No. of cut size in one-6.0m standard length          pcs         5
          Reqd 6.0m long Rebars = TNB / NCS                    pcs         4
          (note: 0.30m for splicing allowance)
          Required: 16mm Ø x 6.0 m Deformed Bars               pcs          20
          Transverse Rebars:
          Number of Transverse Bars                            pcs         5
    TNB   Total number of bars                                 pcs        20
     CC   Concrete Cover                                        m      0.075
     H    If HookS are required, choose for bar dia:
          for 12 mm (1/2") , add this length                            0.33
          for 16 mm (5/8")                                              0.43
          for 20 mm (3/4")                                              0.51
          for 25mm (1")                                                 0.67
     Ø    Bar diameter                                         mm         16
     LB   Length of one bar = L - (CC x 2) + H                  m       1.28
    NCS   No. of cut size in one-6.0m standard length          pcs         5
          Reqd 6.0m long Rebars = TNB / NCS                    pcs         4
          (note: 0.30m for splicing allowance)
          Required: 16mm Ø x 6.0 m Deformed Bars               pcs          14
M COLUMN REBARS:
          Main Bars:
          Number of Bars                                       pcs           8
    TNB   Total number of bars                                 pcs          32
     H    Required L Hook, choose for bar dia:
          for 12 mm (1/2") , add this length                           0.153
          for 16 mm (5/8")                                             0.203
          for 20 mm (3/4")                                             0.254
          for 25mm (1")                                                0.318
 Ø    Bar diameter                                  mm      16
 LB   Length of one bar = L1+L2 - CC + H             m    4.03
NCS   No. of cut size in one-6.0m standard length   pcs   1.49
      Reqd 6.0m long Rebars = TNB / NCS             pcs     21
  0.40
  0.45
 15.00
  2.70     0.00
CF-2 CF-3
  1.00     1.50
  1.20     1.50
  0.90     1.50
  4.00     4.00
  4.32     9.00
WF-2 WF-3
  0.40
  0.15
 15.00
  6.00     0.00
  0.90     0.00
CF2 CF3
  1.00     1.20
  1.20     1.50
  0.25     0.25
     4        4
  4.80     7.20
  1.20     1.50
C2       C3
  0.40     0.25
  0.40     0.30
  3.00     3.00
     4        4
  4.80     3.60
FB-2 FB-3
  0.20     0.20
  0.40     0.40
 12.00    15.00
  0.96     1.20
S-2 S-3
  3.00     2.00
  2.50     1.20
  0.10     0.10
  0.75     0.24
S-2 S-3
  3.00     2.00
  2.50     1.20
  0.10     0.10
  7.50     2.40
  0.75     0.24
WF-2        WF-3
     3           3
 15.00        0.00
     8           0
  0.30        0.30
 15.00        0.00
  0.30        0.30
  0.20        0.20
     4           0
    54           0
    30          30
     2           0
CF-2 CF-3
1.00        1.20
1.20        1.50
0.25        0.25
  4          4
     6           8
    24          32
 0.075       0.075
  0.33        0.33
  0.43        0.43
  0.51        0.51
  0.67        0.67
       16          16
 1.48      1.78
    4         3
    6         9
    5         6
   20        24
0.075     0.075
 0.33      0.33
 0.43      0.43
 0.51      0.51
 0.67      0.67
   16        16
 1.28      1.48
    5         4
    4         6
C2 C3
 0.40      0.25
 0.40      0.30
 3.00      3.00
 0.90      0.90
 0.08      0.08
    4         4
      8         6
     32        24
0.153     0.153
0.203     0.203
0.254     0.254
0.318     0.318
  20     16
4.08   4.03
1.47   1.49
  22     16
BEAM (for 3 m span only)
LENGTH               :    4.00 m      No. of horizontal bar 12mm dia. :          0 units
12 mm dia. X 6 m : 0 pcs
16 mm dia. X 6 m : 17 pcs
CEMENT 12 bags
10 mm dia. X 6 m 33 pcs
CEMENT 2 bags
10 mm dia. X 6 m 8 pcs
FOOTING
CEMENT 4 bags
12 mm dia. X 6 m 5 pcs
COLUMN
LENGTH                3.9 m       No. of VB (12 mm)      :        2 units
NO OF COLUMNS           2 units
VOLUME               0.4 cu.m
10 mm dia. X 6 m 7 pcs
12 mm dia. X 6 m 3 pcs
16 mm dia. X 6 m 5 pcs
EXTERIOR WALLS
WIDTH 1.7 m
CEMENT 3 bags
10 mm dia. X 6 m 4 pcs
THICKNESS 0m
WIDTH 3m
CEMENT 3 bags
10 mm dia. X 6 m 8 pcs
SLAB on fill
CEMENT 18 bags
10 mm dia. X 6 m 30 pcs
WALL FOOTING
CEMENT 1 bags
10 mm dia. X 6 m 1 pcs
STAIRS
RISE                  0.2 m      No. of VB (12 mm and 10 mm) :   4 units
LENGTH 0.8 m
NO OF STEPS 13 units
10 mm dia. X 6 m 7 pcs
12 mm dia. X 6 m 15 pcs
10 13 4 4 4 25
12 0 3 2 0 5
16 24 5 4 3 36
WIDTH : 10.00 m
AREA : 50.00 m
HARDILITE : 17 pcs
HARDINAIL : 3.92 kg
2"X2"X12' : 54 pcs
CNW#3 : 3.70 kg
CN#4 : 0.30 kg
PARTITIONING
LENGTH      :    3.10 m
AREA : 5.58 m
HARDIFLEX: 4 pcs
HARDINAIL : 1 kg
2"X2"X8' : 8 pcs
CNW#3 : 0.41 kg
CN#4        :    0.10 kg
  5     2     1    1    1     10
15 7 4 2 4 32
4 2 2 8
1 1 1 3
8 8 8 24
AREA 4.5 sq m
AREA 5.58 sq m
P. COMPOUND          2 kg
 6.4
6.4
2.2
  4     3    4      2    2     15
                       ***CONCRETING***
                     CONCRETE PROPORTIONING
  Mixture                       Cement in Bags     Sand Cu. Gravel Cu.
                Proportion
   Class                       40 kls     50 kls       M.       M.     Note:
     AA          1 : 1.5 : 3     12        9.5        0.50      1.0    Class A = shall be used for beams, slabs, colum
      A           1:2:4           9         7         0.50      1.0    Class B = shall be used for all members not re
      B          1 : 2.5 : 5    7.5         6         0.50      1.0    Class C = used for footing not under water
      C           1 : 3 :6        6         5         0.50      1.0
 QUANTITY OF CEMENT AND SAND FOR CHB MORTAR PER SQUARE METER
Size of CHB number per                           Bags Cement Mixture
   in cm      Sq.M.               A          B             C       D         sand cu.m.
10 x 20 x 40         13         0.792      0.522         0.394   0.328         0.044
15 x 20 x 40         13         1.526      1.018         0.763   0.633         0.084
20 x 20 x 40         13         2.260      1.500         1.125   0.938         0.125
      Note:    use for Mortar between chb anb its filler
  QUANTITY OF REINFORCING STEEL BARS IN 1-WAY                          QUANTITY OF Tie Wire ON 1-WAY REINFO
          REINFORCED CONCRETE SLAB
                                                                        Bars Spacing
  REBAR         Number of Steel Bars per Square Meter                      in CM                    6m
Spacing CM      6m         7.5 m        9m          12                                     0.30
   10.0        3.764       2.937       2.421      1.769                     10.0          0.474
   12.5        3.062       2.381       1.934      1.427                     12.5          0.316
   15.0        2.584       2.004       1.636      1.197                     15.0          0.228
   17.5        2.232       1.726       1.407      1.033                     17.5          0.168
   20.0        1.980       1.528       1.258      0.914                     20.0          0.132
   22.5        1.786       1.369       1.109       0.81                     22.5          0.110
   25.0        1.627        1.25       1.014      0.736                     25.0          0.089
  QUANTITY OF REINFORCING STEEL BARS IN 2-WAY                          QUANTITY OF Tie Wire ON 2-WAY REINFO
          REINFORCED CONCRETE SLAB
                                                                        Bars Spacing
  REBAR         Number of Steel Bars per Square Meter                      in CM                    6m
Spacing CM      6m         7.5 m        9m          12                                     0.30
   10.0        4.369       3.337       2.772      2.022                     10.0          0.592
   12.5        3.603       2.662       2.245      1.635                     12.5          0.416
   15.0        3.221       2.296       1.921      1.382                     15.0          0.350
   17.5        2.647       2.025       1.650      1.196                     17.5          0.247
   20.0        2.360       1.775       1.461      1.056                     20.0          0.174
   22.5        2.168       1.601       1.312      0.907                     22.5          0.168
   25.0        1.977       1.466       1.217      0.862                     25.0          0.142
                           ***LUMBER***
***TILEWORKS***
*ETO GAMIT KO
5 to 25 kilos with at least 50% of the stones weighing more than 20 kilos
0 to 70 kilos with at least 50% of the stones weighing more than 50 kilos
0 to 100 kilos with at least 50% of the stones weighing more than 80 kilos
00 to 200 kilos with at least 50% of the stones weighing more than 150 kilos
ie Wire ON 2-WAY REINFORCED CONCRETE SLAB IN KILOS PER SQUARE METER                                          chb mortar =
                             Legth Of Steel Bars                                                             rebar =
         6m                          7.5 m                   9m                        12 m                  gi wire # 16 = total kls / 30
                 0.40         0.30            0.40    0.30         0.40         0.30           0.40
                0.896        0.648           0.863   0.648        0.864        0.596          0.794          HOW TO GET KLS OF TIE WIR
                0.554        0.420           0.560   0.431        0.574        0.421          0.561          K=
                0.466        0.307           0.409   0.257        0.343        0.297          0.396          OR
                0.330        0.231           0.308   0.223        0.298        0.206          0.275          K=
                0.232        0.171           0.227   0.173        0.231        0.163          0.217
                0.224        0.150           0.200   0.148        0.198        0.130          0.173
                0.189        0.134           0.178   0.114        0.152        0.116          0.155
                                                 sample
                            Board feet =         (5pcs x 2" x 3" x 10')/12
                                      TYPICAL
                                      note: vert support, length of lumber depends on elevation
                                      COLUMN                 BEAMS                    SLAB
                                      vert       2x3x10      vert            2x3x10   vert        2x3x10
                                      hor        2x3x10      hor             2x2x10
                                      brace      2x2x10
            0.025 ( WT OF RSB)
Project       Two Storey Residential Building
Subject       General Specifications
Location      Town & Country Subdivision, Binan, Laguna
Owner
Area          84 sq.m
GENERAL SPECIFICATIONS
  1 Footings Works
     Column Footing                                  Reinforced Concrete
     Walll Footing                                   Reinforced Concrete
  2 Structural Works
     Column                                          Reinforced Concrete
     Beams                                           Reinforced Concrete
     Slab on Fill                                    Reinforced Concrete
     2F Slab                                         Reinforced Concrete
  3 Walls
     Interior Wall (T & B)                           4" CHB
     Exterior Walls/Common Walls                     5" CHB
     Bedroom Partition                               Hardiflex Board
  4 Framing and Roofing
     (Main Roof) Rib-Type Panels & Accessories       Pre-painted Roof Panels and Accessories
     Framing                                         Steel Framing
  5 Ceiling
     Interior                                        Fiber Cement Board on Metal Furrings
     Eaves                                           Fiber Cement Board on Metal Furrings
  6 Floor Finishes
     Ground Floor                                    Ceramic Tiles
     Second Floor                                    Laminated Vinyl Tiles
  7 Wall Finishes
     Exterior                                        Plastered Rough Troweled Finished
     Interior                                        Plastered Plain Cement Finished
     T&B                                             5 Layers Wall Tiles/Floor Tiles
                                                     Upper wall-Plastered Plain Cement Finished
  8   Doors and Jambs
      Main Door                                      Panel Type Door
      Service Door                                   Flush Door
      Berdroom Doors                                 Flush Door
      T&B                                            PVC Door
                                                     Locksets
  9   Windows                                        Steel Casement Windows
 10   Kitchen Counter                                With Counter/Splashboard Tiles
                                                     With Counter Cabinet Door
 11   Plumbing Works
      Roughing-ins                                   Standard PVC Pipes and Fittings
      Fixtures                                       Flush Type Water Closet, Wall Hang Lavatory
                                                       with Tissue and Soap Holder
                                                     Stainless Kit. Sink, Top Mounted Faucet. Chrome Faucet
                                                       and Hose bib faucet
                                                     Catch Basin
 12   Stairs                                         Reinforced Concrete with Tubular Handrailing
 13   Electrical Works                               Circuit Breaker (Panel Board)
      Roughing-ins                                   Flexible Pipe and Wirings
      Fixtures                                       Circuit Breaker (Panel Board)
                                                     Outlets and Switches
 14   Septic Tank                                    Conventional Type
 15   Painting Works                                 Exterior Walls (2-Coats with Preparation)
                                                     Interior Walls ( 2-Coats with Preparation)
      Prepared by:
Engr. Randy A. Caballes
approximate vol of concrete in bldg                                 useful keys
=Assume 300mm thk all throughout X floor area of bldg               CTRL+1 – Format
                                                                    CTRL+SHIFT+L – Turn on/ o
approximate weight or rebars in a bldg per cu. M concrete           CTRL + SPACE Select the w
footing      50-75 kls/cu.m. of concrete                            SHIFT + SPACE Select the w
slab         125-175 kls/cu.m. of concrete                          CTRL + ' Copy a formula from
column       150-190 kls/cu.m. of concrete                          press Ctrl+` (it is the key nex
walls        100-150 kls/cu.m. of concrete                          Now press Ctrl+H and chang
beams        120-150 kls/cu.m. of concrete                          – to UPPER, lower, Proper C
                                                                    convert
chb mortar =                1:3    0.03 x area=m³
rebar =                     area of chb x 3.6F = kls
gi wire # 16 = total kls / 300 = roll
Press ALT+Enter keys in a cell to make a new line inside the cell
=if(iserror(vlookup(…)),”not found”,vlookup(…)). This will print “not found” whenever the vlookup returns any erro
                     Hi
                          ###
                              2
conditional formating
ased on what you are looking for, MATCH is used to fetch the position of the value you are looking for.