CARA MEMBUAT RUMUS FAKTOR KONVERSI BETON NILAI DI EXCEL

Building with concrete has been the choice for construction for many decades now. Homes, commercial buildings, bridges, and many other structures have been built using concrete because of its strength, durability, and resistance to fire, moisture, and pests. Concrete is a versatile material that can be used for a wide range of projects; however, proper concrete mixing is crucial to achieving the desired result. One important factor that plays a key role in achieving good quality concrete is the conversion factor.

Faktor Konversi Beton

The conversion factor or faktor konversi beton refers to the ratio of the strength of a 15cm x 15cm x 15cm cube of concrete to the strength of a cylinder 15cm in diameter and 30cm in height. This ratio is essential in concrete design and construction because it helps to determine the actual strength of the mix used for the project. Depending on the factors and conditions involved, the conversion factor can vary.

However, the most widely accepted conversion factor for concrete is 0.80. This means that the strength of a 15cm x 15cm x 15cm cube of concrete is 0.80 times the strength of a cylinder 15cm in diameter and 30cm in height.

Cara Menghitung Konversi Besi Beton

In addition to the conversion factor for concrete, konversi beton, there is also a conversion factor for reinforcing steel bars or rebar. The conversion factor for rebar refers to the weight of the steel bar in kilograms per meter (kg/m) converted to the weight of steel per lineal foot (lb/ft).

Baca Juga :  CARA TRANSFORMASI DATA DENGAN EXCEL

The formula for converting kg/m to lb/ft is:

lb/ft = kg/m x 0.672

For example, if you have a 12mm rebar with a weight of 0.888 kg/m, converting to lb/ft will be:

lb/ft = 0.888 kg/m x 0.672 = 0.597 lb/ft

Therefore, a 12mm rebar weighs 0.597 lb/ft.

Cara Konversi Rentang Nilai Angka ke Karakter

Excel is a popular tool for managing data, and it is often used to convert numerical data into characters. The process of converting numerical data into characters is known as grading, and Excel has a built-in grading formula.

Grading is a technique used to convert numerical data into alphabetic or character data to simplify data analysis and representation. The grading process is used extensively in schools and universities to grade students’ performances.

To convert numerical data into alphabetic or character data, follow these steps:

  1. Select the cell range containing the numerical data that you want to grade.
  2. Click on the Conditional Formatting option in the Home tab of the Excel ribbon.
  3. Select the New Rule option and then click on Format only cells that contain option in the Select a Rule Type box.
  4. Select the Between option from the Format only cells with the drop-down menu and enter the range of values that you want to grade.
  5. Click on the Format button to set the format for the selected cell range.
  6. From the Format Cells dialog box, select the Font tab.
  7. Select the desired font style, color, and size and click on OK.
  8. Click on the OK button to save the grading formula.

After following the above steps, the numerical data in the selected cell range will be converted to alphabetic or character data, depending on the format you chose.

Baca Juga :  CARA MEMBUKA FILE EXCELL YANG CORRUPT

Faktor Konversi uji tekan Kubus 15 cm dan silinder dia 10 cm x 20 cm

In construction and engineering, the strength of concrete is tested using a compression testing machine. The standard method for testing concrete is to cast two types of specimens: cubes and cylinders. The cube and cylinder specimens are made using a mold and cured under standard conditions. After the curing period is complete, the specimens are tested using a compression testing machine to determine their strength.

The standard cube specimen size is 15cm x 15cm x 15cm, while the standard cylinder specimen size is 15cm in diameter and 30cm in height. However, for some projects, the cylinder specimen size may differ, and the conversion factor will be different as well.

To convert the results from cube specimens to cylinder specimens, a conversion factor is used. The conversion factor for 15cm x 15cm x 15cm cubes and cylinders with a diameter of 10cm and a height of 20cm is 0.89.

This means that if the cube specimen’s strength is 50 N/mm2, the cylinder’s expected strength will be:

50 N/mm2 x 0.89 = 44.5 N/mm2

Therefore, the expected strength of the cylinder is 44.5 N/mm2.

Cara Membuat Rumus Faktor Konversi Beton Nilai Di Excel

Excel is an excellent tool for any construction project, and it can be used to calculate the conversion factor for concrete. The formula for finding the conversion factor for concrete is:

Fc = Fcu x 0.8

Where:

Fc = Average compressive strength of the concrete cubes

Fcu = Ultimate compressive strength of the concrete cubes

To calculate the conversion factor for concrete in Excel, use the following steps:

  1. Enter the value of Fcu in cell A1, and the value of Fc in cell B1.
  2. In cell C1, enter the formula =B1/(A1x0.8) and press enter.
  3. Excel will display the conversion factor for concrete in the selected cell.
Baca Juga :  Cara Membuat Sticky Di Excel

After following these steps, you can use the conversion factor to determine the strength of a cylinder specimen from the compressive strength of a cube specimen.

FAQ

What is the formula for calculating the weight of a rebar?

The formula for calculating the weight of a rebar is:

Weight of rebar (kg/m) = (diameter in mm)2/162

Where:

diameter is the diameter of the rebar in millimeters.

Can the conversion factor for concrete vary?

Yes, the conversion factor for concrete can vary depending on the conditions and factors involved. However, the most widely accepted conversion factor for concrete is 0.80, which means that the strength of a 15cm x 15cm x 15cm cube of concrete is 0.80 times the strength of a cylinder 15cm in diameter and 30cm in height.

Include Video:

Concrete mixing and casting can be a complex process, but with proper measurements, calculations, and conversions, it can be made easier. The formula for finding the conversion factor for concrete and rebar weight is relatively simple and can be done using Excel or by hand. By following the techniques outlined in this article, you can achieve higher quality and more robust construction projects.