Consolidated budget for houses

Technical Task for the Estimator

Goal:

Develop a structure of variable data for house projects that will allow for the automation of approximate cost calculations for houses. The main data should be integrated into Google Sheets and, through the Google Cloud Platform API, used to create PDF proposals.

The accuracy and structure of the data are important

Types of Houses:

1. Timber Frame House: 4 houses with column sections of 250x250mm, roof beams of 140x300mm, wall beams of 100x250
   • Columns, beams, rafters.
   • Filling frames with glass, walls, or roof.
2. Glue-laminated Timber House: 4 houses with external wall thickness of 200mm and internal of 80mm
   • Walls and openings are formed by assembling logs in a lock.
3. Sauna, garden house - 2 pcs

Thus, 10 structures.

Approximate Calculation:

The calculation provides the client with the total cost of the house, considering:

1. Main materials.
2. Structures.
3. Areas and volumes.

Tasks for the Estimator:

1. Volume of Glue-laminated Timber:

• Determine the norm m³ of glue-laminated timber per 1 m² of the covered contour.
  • The covered contour is understood as:
    • The area of the warm contour.
    • The area of verandas and canopies if they are under a common roof.

Formula:
Volume of wood = Total area of the covered contour × Norm m³ per 1 m².

It is known about 23m3 /100m2 for timber frame, so it is necessary to calculate 2 different projects to derive the average value. The same needs to be done for the glue-laminated timber house (or maybe you know 

2. Wall Filling:

• Calculate the area of external and internal walls that are not occupied:
  • With glass
  • With window or door constructions.

Result: total area of external walls in m².

                    withtotal area of internal walls in m².

3. Glazing Units:

• Calculate the area of glazing units, considering:
  • The geometry of the facades.
  • The area of the gables:
    • Calculate as the area of an isosceles triangle (base and angle at the base — 25°).
    • Subtract the area occupied by beams (frames).
  • Other rectangular areas calculate using the formula: length × width of the timber frame cell

4. Doors and Windows:

• Balcony doors and windows:
  • Calculate the area of rectangular constructions.
• Sliding constructions:
  • Determine the area, considering the size of the cell.

Formula:
Area of sliding construction = Length of cell × Width of cell.

5. Roof:

• Determine the area of the gable roof:
  • Consider the projection on the ground (in m²).
  • Angle of inclination (for example, 25°).

Results:

• Total area of the roof (for roofing material).
• Insulation area (without overhangs).

6. Volume of the Structure:

• Calculate the volume of the house (in m³), considering:
  • The height of the floor to the ceiling.
  • The height from the ceiling to the roof line.

7. Interior Doors:

• Specify the number of interior doors (in pcs).

8. Entrance Doors:

• Calculate the area of the entrance doors (in m²):
  • For example, standard doors 1000 × 2100 mm.
  • For larger projects, for example, 1400 × 2400 mm.

9. Bathrooms:

• Specify the number of bathrooms (in pcs).

Fill in the data in this table

https://docs.google.com/spreadsheets/d/1cqje3ke-fRi12s8vtPNEzVApaQYuJP5BLFPMt2gya7k/edit?gid=0#gid=0

Notes and Recommendations:

1. It is recommended to use chatGPT to create template tasks that it will understand well. For example: give the area of the roof if the area of the roof projection, gable roof, angle 25 degrees or task: It is necessary to calculate the area of glass for the timber frame gable, where: Beam spacing — 2200 mm (2.2 meters). Base length of the triangle — 12 meters. Angle at the base of the isosceles triangle on both sides — 25 degrees. Width of the frames — 240 mm. Glazing units are embedded in the frame by 50 mm. The task is to determine the area of glass for the timber frame gable, considering the angle at the base of 25 degrees and the embedding of glazing units by 50 mm in the frame. 
2. Consider that the accuracy of calculations is important, but the final result is only an approximate calculation for the client.
3. If you plan to perform this task for more than 2 days, this task is not for you.