👉Types of Foundations Used in Buildings

💫Foundations are the structural elements that transfer building loads safely to the supporting soil.

🌟The selection of foundation depends mainly on soil bearing capacity, structural loads, groundwater conditions, column spacing, settlement requirements, and site constraints.

☄A. Shallow Foundations

Generally used when suitable bearing soil is available at a relatively shallow depth.

1. Isolated (Pad) Footing

Supports a single column.

Suitable where soil has adequate bearing capacity.

Common for individual RCC columns.

☄2. Strip (Wall) Footing

A continuous footing provided below a load-bearing wall.

Suitable for uniform soil and moderate wall loads.

Distributes the wall load over a wider soil area.

☄3. Combined Footing

Supports two or more columns on one footing.

Useful when columns are close together or a column is near a property boundary.

Can help reduce eccentric loading.

☄4. Raft (Mat) Foundation

A large reinforced-concrete slab supporting several or all columns/walls.

Useful where soil has low bearing capacity or columns are closely spaced.

Can reduce differential settlement when properly designed.

B. Deep Foundations

Used when adequate bearing strata are not available near the ground surface or when loads/ground conditions require deeper support.

🚧1. Pile Foundation

Consists of piles extending into deeper soil or rock.

Transfers structural loads through end bearing, skin friction, or both.

Suitable for weak surface soils and heavy loads.

🚧2. Well/Caisson Foundation

A large hollow foundation sunk into the ground.

Commonly used for heavy structures and foundations subjected to scour or water-related conditions, particularly bridge works.

🚥Important Note

The foundation type should not be selected from soil type alone.

A geotechnical investigation and structural design are normally required to determine the appropriate foundation size, depth, reinforcement, allowable bearing pressure, and settlement criteria.

Local building codes and site conditions must also be considered.

#CivilEngineering #Foundation #TypesOfFoundation #ShallowFoundation #DeepFoundation #IsolatedFooting #StripFooting #CombinedFooting #RaftFoundation #PileFoundation #WellFoundation #RCC #StructuralEngineering #Construction #BuildingConstruction #GeotechnicalEngineering #SoilMechanics #CivilTechTime #ConstructionKnowledge #EngineeringEducation

@etconp

#ADVERTISEMENT

👉ምርጥ የ ሳይኮሎጂ መፅሐፍ ከፈለጉ ከታች ባለዉ ሊንክ በመንካት አውርደው በማንበብ አእምሮዎን ተጠቅመው ስኬታማ ይሁኑ👇

https://ye-buna.com/matoro27?ref=product_detail&product=6a7c75d0cc8f4_matoro27

👉የኮንስትራክሽን ሳይት የደህንነት ትኩረት!

🌟​በሳይት ላይ ሊተገበሩ የሚገባቸውን ወርቃማ የደህንነት ነጥቦች ከዚህ በታች አቅርበናቸዋል፦

​📦 የቁሳቁስ አያያዝ እና አቀማመጥ (Material Stacking): ለሳይት ደህንነት እና ቅልጥፍና የሚሰጥ ጥብቅ ትኩረት
​በኮንስትራክሽን ሳይት ላይ ቁሳቁሶች ሲገቡ እና ሲከመሩ የዘፈቀደ አሰራር መከተል እጅግ አደገኛ ስህተት ነው።

ብረቶች፣ ቱቦዎች፣ ሲሚንቶዎች እና ሌሎች የግንባታ ማቴሪያዎች በአግባቡ አለመያዛቸው እና አለመደረደራቸው ለብዙ ዓይነት የሳይት አደጋዎች ይዳርጋል።

🗂​ይህንን ጉዳይ በስራ ላይ ስንተገብረው የሚከተሉትን ጥብቅ ነጥቦች ልብ ልንል ይገባል፦

• ​የመንገዶች ክፍት መሆን (Clear Pathways): የግንባታ እቃዎች ማለፊያ መንገዶችን፣ የእግረኛ አቅጣጫዎችን እና የአደጋ ጊዜ መውጫዎችን (Emergency Exits) በፍጹም መያዝ ወይም ማጥበብ የለባቸውም፤ ሰራተኞች እና ማሽኖች በነፃነት መንቀሳቀስ መቻል አለባቸው።
• ​የመደራረብ ጽኑነት (Stability and Height Limits): ብረቶች እና ቱቦዎች ተቆልለው ሲቀመጡ ሊንሸራተቱ ወይም ሊፈርሱ በማይችሉበት አስተማማኝ ቁመት እና አቀማመጥ መደረደር አለባቸው። ያልተረጋጋ አቀማመጥ በድንገት ፈርሶ ከፍተኛ የሰው አካል ጉዳት ሊያስከትል ይችላል።
• ​ከእርጥበት እና ከአደጋ መጠበቅ (Protection and Organization): ማቴሪያዎች ከዝናብ ወይም ከእርጥበት ሊጠበቁ በሚችሉበት፣ እንዲሁም የተለያየ ዓይነት እቃዎች ተቀላቅሎ ስራ እንዳያስተጓጉሉ በምድብ ተለይተው መቀመጥ አለባቸው።

🚥መልእክታችን

​"እያንዳንዱ ቁሳቁስ ትክክለኛ ቦታው ላይ ሲቀመጥ ሳይቱ ንጹህ፣ ደህንነቱ የተጠበቀ እና ለስራ ምቹ ይሆናል!"

@etconp

🏗️ Cost Breakdown Analysis & BOQ for Building

🌟አሁን ባለው የገበያ ዋጋ የተሰራ

💻 Professional Excel Template በመጠቀም የሕንፃ ወጪ ግምትና BOQ ሥራዎን በፍጥነት ያዘጋጁ!

✅ Material, Labor & Equipment Cost
✅ Detailed Cost Breakdown
✅ Professional BOQ Format
✅ Easy-to-Edit Excel Formulas
✅ Reusable for Multiple Projects

👷 ለ Contractors • Engineers • Quantity Surveyors • Estimators እና Construction Professionals

📁 Microsoft Excel (.xlsx)

🚀 ጊዜዎን ይቆጥቡ — የህንፃ ግምት ሥራዎን ያቀላጥፉ👇

https://ye-buna.com/etconp?ref=product_detail&product=6a7d4cdc7b3de_etconp

🚜TYPES OF EXCAVATOR BUCKETS — CHOOSE THE RIGHT BUCKET FOR THE RIGHT JOB

🌟Excavator buckets are selected according to the material, digging conditions, required productivity, machine capacity, and type of work. Using the correct bucket can improve digging efficiency, reduce wear, and lower operating costs.

🔧 12 Common Excavator Bucket Types

1️⃣ Standard Bucket – General-purpose excavation in loose soil, sand and gravel.
2️⃣ Rock Bucket – Heavy-duty bucket for tough and abrasive materials.
3️⃣ Quarry Bucket – Reinforced bucket designed for quarrying, mining and heavy rock.
4️⃣ Tilt Bucket – Hydraulic tilting bucket for grading, leveling and precise finishing.
5️⃣ Skeleton Bucket – Used for screening and separating soil, rocks and demolition debris.
6️⃣ Clamshell Bucket – Opens and closes like a shell; useful for deep excavation, dredging and material handling.
7️⃣ Crusher Bucket – Crushes concrete, rocks and demolition waste directly on site.
8️⃣ Screening Bucket – Separates and screens materials using a rotating drum.
9️⃣ Ditch Bucket – Narrow bucket designed for ditching, trenching and drainage work.
🔟 Cleaning Bucket – Wide bucket for cleaning, finishing slopes, ditches and canals.
1️⃣1️⃣ Grab Bucket – Hydraulic grab for handling scrap, logs, rocks and bulk materials.
1️⃣2️⃣ Trapezoidal Bucket – Designed for efficient drainage channels, grading and backfilling.

📐 Key Bucket Dimensions

W = Width
H = Height
D = Depth

🏗️ How to Select the Right Bucket

Consider:

• Material type and ground conditions
• Excavation requirements
• Excavator size and lifting capacity
• Bucket size and weight
• Wear resistance and expected operating conditions
• Required digging, grading, screening or material-handling performance

☄Remember: The right bucket improves productivity, machine safety, component life and overall project efficiency.

📌 Save this guide for your next excavation project and share it with fellow civil engineers and construction professionals.

#CivilEngineering #Excavator #ExcavatorBucket #ConstructionEquipment #HeavyEquipment #Earthmoving #Construction #CivilConstruction #Mining #Quarrying #Dredging #Demolition #SiteEngineering #ConstructionTechnology #HeavyMachinery #EngineeringKnowledge #CivilEngineer #Earthwork #EquipmentSelection

@etconp

. የቻናል ጥቆማ

የህይወት እይታዎን ማሻሻል ከፈለጉ ይህ ቦታ ለእርስዎ ነዉ፤ ይቀላቀሉ !

@Seidendre

የሚያጋጥሙንን ክስተቶች መወሰን እና መቆጣጠር ባንችልም ስሜታችንን እና አፀፋችንን መቆጣጠር ግን በእጃችን ነዉ።

Rise Daily — Where great minds are built through daily discipline !

📌 Join: @SeidEndre
🚀Share: @SeidEndre

📐How to Mark an Offset Using a Total Station

🌟Angle & Distance Method

Offset marking with a Total Station is a precise surveying technique used to locate points away from a known reference or control line. It is based on simple right-angle triangle geometry and allows surveyors to accurately transfer design coordinates to the ground.

🔹 Key Components

Base distance (a): Distance measured along the reference line.

Offset distance (b): Perpendicular distance from the reference line to the required point.

Slope distance (c): Distance measured from the Total Station to the offset point.

Horizontal angle (θ): Angle turned from the established reference direction.

🔹 Required Data

✅ Known control/reference point or line
✅ Total Station properly set, centered and levelled
✅ Reference direction/back sight
✅ Required horizontal angle
✅ Required offset or measured distance

🔹 Basic Procedure

1. Set up the Total Station over a known control point and carefully center and level it.

2. Backsight a reference point and establish the correct orientation.

3. Turn the required horizontal angle from the reference line.

4. Enter or measure the required distance using EDM or stake-out mode.

5. Mark the calculated point accurately on the ground.

6. Recheck the angle and distance before fixing the final survey point.

🔹 Right-Angle Offset

For a perpendicular offset, the offset direction is set at 90° to the reference line. This method is commonly used for establishing building corners, road offsets and setting-out points.

🔹 Common Applications

🏗️ Building and structural setting-out
🛣️ Road centerline and edge offsets
📍 Column and footing positioning
🚰 Boundary and utility layouts
📐 Construction alignment and control points

Important: Always verify the Total Station's centering, levelling, orientation, prism/target setup and measurements before marking permanent points. Actual site setting-out should follow the approved survey drawings and project specifications.

#TotalStation #Surveying #LandSurveying #CivilEngineering #Construction #SettingOut #SurveyingEngineering #CivilConstruction #Engineering #ConstructionSurveying #SiteSurvey #BuildingConstruction #RoadConstruction #SurveyEngineer #TotalStationSurvey #EngineeringTips #CivilTech #ConstructionTechnology #Surveyor #SiteEngineering

@etconp

👉PART 4

1. Which of the following is NOT a safety device used in construction?

A. Hard hat
B. Safety goggles
C. Wrench
D. Fall harness

2. Which of the following is NOT a key component of a concrete mix?

A. Cement
B. Sand
C. Gravel
D. Mud

3. Which type of soil is best suited for constructing foundations?

A. Clay
B. Silt
C. Sand
D. Rock

4. Which of the following is NOT a part of the structural system of a building?

A. Columns
B. Footings
C. Beams
D. Windows

5. Which of the following is NOT a source of funding for construction projects?

A. Public funding
B. Private financing
C. Government subsidies
D. Charity donations

6. Which of the following is NOT a type of construction waste?

A. Drywall waste
B. Cardboard waste
C. Glass waste
D. Hazardous waste

7. Which of the following is NOT a type of concrete?

A. Normal weight concrete
B. High-density concrete
C. Reinforced concrete
D. Lightweight concrete

8. Which of the following is NOT a primary benefit of using precast concrete in construction?

A. Improved durability
B. Faster construction time
C. Increased flexibility
D. Reduced construction costs

9. Which of the following is NOT a common method of constructing bridges?

A. Arch bridge
B. Suspension bridge
C. Truss bridge
D. Magnetic bridge

10. Which of the following is NOT a common type of construction contract?

A. Lump-sum contract
B. Unit-price contract
C. Fixed-price contract
D. Cost-plus contract

11. Which of the following is NOT a typical construction stakeholder?

A. Owner
B. Architect
C. Contractor
D. Tenant


12. Which of the following is NOT a common construction safety sign?

A. Hazardous Material
B. Hard Hat Area
C. Do Not Enter
D. Trespassing Prohibited

13. Which of the following is NOT a typical type of construction equipment?

A. Excavator
B. Bulldozer
C. Paintbrush
D. Crane

14. Which of the following is NOT a typical method of soil testing?

A. Standard Penetration Test
B. Cone Penetration Test
C) Thermal Conductivity Test
D) Atterberg Limits Test

15. Which of the following is NOT a common type of construction drawing?

A. Architectural drawing
B. Structural drawing
C. Electrical drawing
D. Social drawing

16. Which of the following is NOT a typical site utility?

A. Water
B. Electricity
C. Internet
D. Gas

17. Which of the following is NOT a typical hazard associated with concrete work?

A. Excess heat
B. Silicosis
C. Electrocution
D. Poor drainage

@etconp

🌟PART FOUR ANSWERS

1. C) A wrench is not a safety device used in construction.

2. D) Mud is not a key component of a concrete mix.

3. D) Rock is the best soil for constructing foundations because of its high strength and stability.

4. D) Windows are part of the architectural features of a building, but not part of the structural system.

5. D) Charity donations are not a common source of funding for construction projects.

6. D) Hazardous waste is not a common type of construction waste.

7. D) Lightweight concrete is not a typical type of concrete used in construction.

8. C) Increased flexibility is not a primary benefit of using precast concrete in construction. Precast concrete is generally less flexible than other types of concrete.

9. D) Magnetic bridges are not a common method of constructing bridges.

10. D) Cost-plus contracts are not a common type of construction contract.

11. D) Tenants are not typically involved in the construction process as stakeholders.

12. D) Trespassing Prohibited is not a common construction safety sign. The others are commonly used to warn of potential hazards on construction sites.

13. C) A paintbrush is not a typical piece of construction equipment. Excavators, bulldozers, cranes, and other heavy equipment are more common.

14. C) Thermal Conductivity Test is not a typical method of soil testing. The others are all commonly used methods for determining soil properties and characteristics.

15. D) Social drawings are not a common type of construction drawing.

16. C) Internet is not typically considered a site utility, as it is not necessary for the basic functioning of a building or structure. The other options (water, electricity, and gas) are all common utilities found on most construction sites.

17. D) Poor drainage is not a typical hazard associated with concrete work. Exposure to excess heat, silicosis, and electrocution are all common risks for workers handling concrete.

@etconp

🚗WHY YOU LOSE CONTROL IN CURVES

🌟Taking a curve safely is all about maintaining the right balance between speed, tyre grip, braking, weight transfer, and road geometry.

☄A small mistake can quickly turn into skidding or loss of vehicle control.

🔹 1. Excess Speed

Entering a curve too fast increases the lateral force required to keep the vehicle on its path. If the available tyre grip is insufficient, the vehicle may skid.

Higher speed = Higher risk

🔹 2. Wet or Loose Road Surface

Rain, mud, gravel, sand, and other loose materials reduce tyre–road friction. With less available grip, the vehicle can lose traction more easily.

Less friction = More possibility of sliding

🔹 3. Braking Inside the Curve

Heavy braking while cornering can shift load toward the front axle and reduce available rear-tyre traction. This can contribute to oversteer or instability.

✅ Best practice: Reduce speed and brake smoothly before entering the curve whenever possible.

🔹 4. Incorrect Camber

Proper road camber helps with drainage and can support stable vehicle movement through curves. Poor or inappropriate cross-slope design can negatively affect handling and safety.

🛣️ Safe Driving Tips

• Slow down before entering a curve.
• Steer smoothly and avoid sudden movements.
• Keep tyres properly inflated and in good condition.
• Avoid harsh braking while turning.
• Adjust your driving to weather and road conditions.
• Never assume every curve can be taken at the same speed.

📌 Key Point

Safe cornering depends on SPEED + FRICTION + WEIGHT TRANSFER + ROAD GEOMETRY.

⚠️ Always follow posted speed limits and drive according to actual road conditions.

Drive safe. Arrive safe. 🚘

#CivilEngineering #RoadEngineering #HighwayEngineering #TrafficEngineering #RoadSafety #SafeDriving #CurveSafety #RoadDesign #HighwaySafety #TransportationEngineering

@etconp

👉አዲስ ባሁን የገበያ ዋጋ የተሰራ የህንፃ Cost BreakDown Analysis እና BOQ ከፈለጉ ከታች ባለው ሊን ያውርዱ👇

https://ye-buna.com/etconp?ref=product_detail&product=6a7d4cdc7b3de_etconp

👉Types of Loads on Structures

🌟In civil engineering, loads are forces or other actions that cause stresses, deformations, or displacements in structures. Loads can be classified into:

1️⃣ Dead Load (DL):

Permanent/static load.
Includes weight of structural elements: beams, columns, slabs, walls, etc.
Example: Self-weight of concrete slab.

2️⃣ Live Load (LL):

Temporary or movable load.
Includes people, furniture, vehicles, equipment, snow, etc.
Example: People walking inside a building.

3️⃣ Wind Load (WL):

Horizontal load due to wind pressure.
Important for tall buildings, towers, bridges.

4️⃣ Seismic Load (Earthquake Load):

Due to ground motion during earthquakes.
Horizontal and vertical components.

5️⃣ Snow Load:

Weight of accumulated snow on structures.
Depends on location and climate.

6️⃣ Thermal Load:

Caused by temperature changes leading to expansion or contraction of materials.

​🌐 ለተጨማሪ መረጃ እና ሌሎች የኮንስትራክሽን ዘርፍ ዜናዎች የ YouTube ገፃችን ከታች ባለው ሊንክ በመግባት SubScribe አርገው ቤተሰብ ይሁኑ👇

https://youtube.com/@ethiopianconstruction7?si=ils307xXQQpIdCwG
‎
‎@etconp

ገዳ ባንክ አዲስ የሚያስገነባውን የህንፃ ዲዛይን ይፋ አደረገ፡፡

ባንኩ አስገነባዋለሁ ያለው ዋና መስሪያ ቤት ሜክሲኮ አካባቢ በ6 ሺህ 579 ካሬ ሜትር ላይ እንደሚያርፍም ተናግሯል፡፡

ገዳ ባንኩ ይፋ ያደረገው የህንፃው ዲዛይን የኪነ-ሕንፃ ጥበብን ከዘመናዊ ቴክኖሎጂ ጋር ያቀናጀ መሆኑን የተናገሩት የባንኩ ዋና ስራ አስፈፃሚ አቶ ወልዴ ቡልቶ የዋና መሥሪያ ቤት ግንባታ ለማካሄድ የዲዛይን ውድድር ሲያካሂድ ቆይቷል ብለዋል።

ውድድሩ በዘርፉ በታወቁ ገለልተኛ ዳኞች ጥብቅ ምዘና ሲደረግበት የቆየ መሆኑ የተነገረ ሲሆን መስፈርቱን አሟልተው ለውድድር ከቀረቡ 18 ተወዳዳሪዎች አንድ ድርጅት አሸንፏል ተብሏል።

ወደ ስራ ከገባ ሶስት አመታትን ያስቆጠረው ገዳ ባንክ ከ32 ሺህ በላይ ባለአክሲዮኖች እንዳሉት ያነሳ ሲሆን ጠቅላላ ሀብቴ 12.6 ቢሊየን ብር ማደግ ችሏል ብሏል።

በተጨማሪም እስካሁን ከ110 በላይ ቅርንጫፎችን መክፈቱን የተናገረ ሲሆን በተጠናቀቀው በጀት አመትም ከ1 ቢሊየን ብር በላይ ትርፍ ማግኘቱን ባንኩ አስረድቷል።

@etconp

👉Soil Mechanics -Consolidation

1️⃣ What is Consolidation?

It is the process where saturated soil decreases in volume because water slowly drains out due to an applied load.
Mainly happens in fine-grained soils like clay.

2️⃣ Types of Consolidation

🌟Primary Consolidation:
Water escapes from the soil pores, reducing water pressure and increasing strength.

🌟Secondary Consolidation (Creep):

Long-term adjustment where soil particles slowly rearrange after most water has drained.

3️⃣ Why is Consolidation Important?

Helps predict settlement of buildings, roads, and other structures built on clayey soils.
Prevents unexpected long-term settlements that may damage structures.

4️⃣ Factors Affecting Consolidation

- Type of soil (clay consolidates more than sand).
- Thickness of the compressible soil layer.
- Permeability (how easily water can flow out).
- Magnitude of the applied load.

5️⃣ Common Applications

- Foundation design.
- Road embankment construction.
-Earth dams and retaining walls.

@etconp

👉ሙሉ የኮንስትራክሽን ስራዎች ላይ ቼክ ሊስት ከፈለጉ ከታች ባለው ሊንክ አውርደው ይጠቀሙ

⬇️Construction Work Permit Cheaklist Package

✅ Excavation & Earthwork Checklists
✅ Foundation & Substructure Checklists
✅ Reinforced Concrete (RC) Work Checklists
✅ Formwork & Reinforcement Checklists
✅ Concrete Casting Checklists
✅ Masonry & Block Work Checklists
✅ Structural Steel Checklists
✅ Roofing Checklists እና ሌሎች👇

https://ye-buna.com/etconp?ref=product_detail&product=6a744a079bb13_etconp

👉TYPES OF CEMENT

1. Ordinary Portland Cement (OPC)

OPC is the most widely used cement for general construction. It develops high early and ultimate strength, making it suitable for structural concrete.

Applications: Buildings, bridges, roads, reinforced concrete, foundations, and precast elements.

2. Portland Pozzolana Cement (PPC)

PPC is produced by blending OPC clinker with pozzolanic materials such as fly ash. It generates less heat during hydration, improves long-term strength, and offers excellent durability.

Applications: Mass concrete, masonry, plastering, foundations, dams, and marine structures.

3. Rapid Hardening Cement

Rapid Hardening Cement gains strength much faster than OPC during the early days, allowing earlier removal of formwork and quicker project completion.

Applications: Road repairs, precast concrete, airport pavements, and fast-track construction.

4. Sulphate Resisting Cement (SRC)

SRC contains a low percentage of tricalcium aluminate (C₃A), making it highly resistant to sulphate attack from soil and groundwater.

Applications: Sewage treatment plants, marine structures, foundations in sulphate-rich soils, and underground structures.

5. White Cement

White Cement is manufactured from raw materials with very low iron content, resulting in its white color. It is mainly used for decorative purposes.

Applications: Architectural finishes, terrazzo flooring, tile grouts, decorative concrete, and sculptures.

6. Low Heat Cement

Low Heat Cement produces less heat during hydration, minimizing thermal cracking in large concrete sections.

Applications: Dams, raft foundations, retaining walls, large footings, and thick concrete sections.

7. Quick Setting Cement

Quick Setting Cement sets very rapidly, making it ideal where immediate setting is required. It differs from Rapid Hardening Cement because it sets quickly but does not necessarily gain strength faster.

Applications: Underwater construction, grouting, tunnel lining, emergency repairs, and leak sealing.

8. Blast Furnace Slag Cement (BFSC)

BFSC is produced by blending Portland cement clinker with granulated blast furnace slag. It provides excellent resistance to chemicals and improves durability.

Applications: Marine structures, bridges, wastewater treatment plants, industrial floors, and mass concrete.

9. High Alumina Cement (HAC)

High Alumina Cement contains a high percentage of alumina, giving it rapid strength development and excellent resistance to high temperatures and chemical attack.

Applications: Refractory concrete, furnace linings, chemical plants, industrial floors, and fire-resistant structures.

10. Colored Cement

Colored Cement is made by adding mineral pigments to ordinary or white cement. It is primarily used for aesthetic purposes.

Applications: Decorative flooring, architectural facades, pavements, landscaping, and ornamental structures.

11. Expansive Cement

Expansive Cement expands slightly during the setting process, compensating for shrinkage and reducing cracking.

Applications: Water-retaining structures, grouting, anchor bolts, bridge decks, and crack-resistant concrete.

12. Hydrophobic Cement

Hydrophobic Cement contains water-repellent additives that protect it from moisture during storage and transportation, making it suitable for humid environments.

Applications: Construction in rainy or humid regions, remote project sites, long-distance transportation, and long-term storage.

@etconp

👉ለጠቅላላ እውቀት

🌟15 ዋና ዋና የኤክሴል (Excel) ቀመሮች ፦

▶️ኤክሴል በዋናነት እነዚህ 15 ቀመሮች ናቸው እነዚህን ይማሩ፣ ለመጀመር የሚያስፈልግዎ ያ ብቻ ነው!

1. COUNT (ቆጠራ)

ጥቅሙ፦ በተሰጠው የሴል ክልል (range) ውስጥ ያሉትን የሴሎች ብዛት ይቆጥራል።

ምሳሌ፦ =COUNTA(A1:A100)

2. SUM (ድምር)

ጥቅሙ፦ በተመረጡ የሴል ክልሎች ውስጥ ያሉትን ቁጥሮች በሙሉ ይደምራል።

ምሳሌ፦ =SUM(C5:C50)

3. AVERAGE (አማካኝ)

ጥቅሙ፦ የተመረጡ የሴሎችን የቁጥር አማካኝ ያሰላል።

ምሳሌ፦ =AVERAGE(B2:B10)

4. MAX/MIN (ከፍተኛ/ዝቅተኛ)

ጥቅሙ፦ በአንድ ስብስብ ውስጥ ያለውን ከፍተኛውን ወይም ዝቅተኛውን ቁጥር ያወጣል።

ምሳሌ፦ =MAX(A1:A10) ወይም =MIN(A1:A10)

5. SORT (ደረጃ በደረጃ ማስቀመጥ)

ጥቅሙ፦ መረጃዎችን በፊደል ወይም በቁጥር ቅደም ተከተል (ከትንሽ ወደ ትልቅ ወይም በተቃራኒው) ያስተካክላል።

ምሳሌ፦ =SORT(A2:B10, 2, -1)

6. IF (ከሆነ)

ጥቅሙ፦ አንድ መስፈርት ከተሟላ አንዱን ውጤት፣ ካልተሟላ ደግሞ ሌላ ውጤት እንዲሰጥ ያደርጋል።

ምሳሌ፦ =IF(A2>30, "Pass", "Fail")

7. IFS (ከሆኑ - ለብዙ መስፈርቶች)

ጥቅሙ፦ እንደ "IF" ሆኖ ነገር ግን ብዙ መስፈርቶችን በአንድ ላይ ለመፈተሽ ያገለግላል።

ምሳሌ፦ =IFS(A2>90, "A", A2>80, "B", A2>70, "C", "F")

8. VLOOKUP (መረጃ መፈለጊያ)

ጥቅሙ፦ በአንድ ሰንጠረዥ የመጀመሪያ ረድፍ ላይ መረጃ ፈልጎ በዚያው መስመር ያለን ሌላ መረጃ ያወጣል።

ምሳሌ፦ =VLOOKUP(A2, A1:D10, 3, FALSE)

9. XLOOKUP (ዘመናዊ መረጃ መፈለጊያ)

ጥቅሙ፦ ከ "VLOOKUP" የተሻለና የቀለለ የፍለጋ ዘዴ (አዲስ የኤክሴል ስሪቶች ላይ የሚገኝ)።

ምሳሌ፦ =XLOOKUP(E2, A2:A10, B2:B10, "Not Found")

10. SEARCH (ፍለጋ)

ጥቅሙ፦ በአንድ የጽሁፍ ክፍል ውስጥ የሚፈለገውን ቃል ወይም ፊደል ያለበትን ቦታ ይለያል።

ምሳሌ፦ =SEARCH("gmail", A2)

11. UNIQUE (ልዩ/ያልተደገመ)

ጥቅሙ፦ ከአንድ የዝርዝር መረጃ ውስጥ የተደጋገሙትን በማስቀረት ልዩ የሆኑትን ብቻ ለይቶ ያወጣል።

ምሳሌ፦ =UNIQUE(A2:A50)

12. CONCAT (ማያያዣ)

ጥቅሙ፦ የተለያዩ የጽሁፍ ክፍሎችን ወይም የሴል መረጃዎችን ወደ አንድ ያገናኛል።

ምሳሌ፦ =CONCAT(A2, " ", B2)

13. LET (ስም መስጠት)

ጥቅሙ፦ ለስሌት ውጤቶች ስም በመስጠት ውስብስብ የሆኑ ቀመሮችን ለማቅለል ይረዳል።

ምሳሌ፦ =LET(x, A1*2, y, B1+10, x+y)

14. SUMIFS (በመስፈርት መደመር)

ጥቅሙ፦ ከአንድ በላይ መስፈርቶችን የሚያሟሉ መረጃዎችን ብቻ ለይቶ ይደምራል።

ምሳሌ፦ =SUMIFS(D2:D10, A2:A10, "Sales", B2:B10, ">1000")

15. AVERAGEIF (በመስፈርት አማካኝ ማውጣት)

ጥቅሙ፦ የተወሰነ መስፈርትን የሚያሟሉ የሴሎችን አማካኝ ብቻ ያሰላል።

ምሳሌ፦ =AVERAGEIF(A2:A10, ">50", B2:B10)

@etconp

🏗️ Bid & Contract Document Package

🌟ለኢትዮጵያ የግንባታ Bid, Tender & Contract ዝግጅት የሚያግዝ ፕሮፌሽናል ፓኬጅ።

📦 4 Editable MS Word Documents
📁 One ZIP File

🇪🇹 ለኢትዮጵያ ግንባታ ፕሮጀክቶች

🏛ከታች ባለው ሊንክ ያውርዱት👇

https://ye-buna.com/etconp?ref=product_detail&product=6a7fed4a173ec_etconp

🏗️BASIC IMPORTANT POINTS FOR CIVIL SITE ENGINEERS & SUPERVISORS

Proper site execution requires attention to reinforcement detailing, nominal cover, stirrup spacing, durability, and concrete quality.

🔹 Nominal Cover

Typical values shown in the infographic:

Footing: 50 mm

Column: 40 mm

Slab: 20 mm

Beam: 25 mm

⚠️ Important: Actual nominal cover must be selected according to the applicable design code, exposure condition, fire requirements, and structural drawings. Do not use these values universally.

🔹 Number of Stirrups in a Beam

A commonly used calculation is:

No. of stirrups = Clear span ÷ C/C spacing + 1

The actual spacing must follow the structural design and applicable code, especially near beam-column joints where closer spacing may be required.

🔹 Reinforcement Splicing

Large-diameter bars require special attention to splice detailing.

Do not assume welding is always preferred; lap length, mechanical couplers, or welding should be selected according to the structural drawings and applicable code.

🔹 Durability of Concrete

Water and moisture can contribute to reinforcement corrosion when they penetrate concrete, particularly when concrete quality, cover, compaction, or curing is inadequate.

PCC does not contain reinforcement, but concrete itself can still deteriorate due to water, chemicals, freeze-thaw action, abrasion, etc.

✅Site Takeaways

✔ Maintain specified concrete cover
✔ Check stirrup diameter, spacing and anchorage
✔ Follow approved structural drawings
✔ Ensure proper reinforcement placement and tying
✔ Provide adequate compaction and curing
✔ Select concrete grade and durability requirements according to exposure conditions
✔ Always follow the applicable local structural code

Note: The values in this infographic should be treated as educational examples, not as a substitute for structural design or project specifications.

@etconp