Using some of Microsoft Office Excel Functions to Compute Soil Engineering Parameters Based on Raw Results of Laboratory Tests

2020 ◽  
Vol 857 ◽  
pp. 273-282
Author(s):  
Azhar Sadiq Yasun ◽  
Sultan A. Daud
Keyword(s):  
Soil Classification ◽  
Engineering Properties ◽  
Soil Parameters ◽  
Algebraic Equations ◽  
Microsoft Excel ◽  
Unconfined Compression Test ◽  
Engineering Parameters ◽  
Parameter Test ◽  
Microsoft Office ◽  
Engineering Soil

The main aim of this research can be represented as a trail to computerize the most soil engineering properties to compute them automatically using many simple Microsoft Excel functions based on raw soil test experimental data. This work will be shortening the time and effort of the geotechnical engineers calculating different soil parameters with acceptable accurate values. Nine different Microsoft Excel formulas, some of the techniques by certain Excel expressions and normal designed algebraic equations were used to present the final spreadsheet. The main computed soil parameters were (ω, LL, PL, PI, ρd,max, ωopt, k) soil classification AASHTO, (qu and cu) for unconfined compression test, (ø and c') for the direct shear test finally (Cc and Cs) for consolidation tests. To get a better understanding on how most of the programmed tools and to Microsoft Excel sheets work, the user should have knowledge about basic concepts of the certain soil parameter test and experimental steps and also the guidelines of the theory that depends to compute the parameter. Also, the user should have enough background about engineering soil properties laboratory experiments computation.

scholarly journals The Improvement of Engineering Properties of Expansive Soil using Waste Glass Powder (WGP) and Quick Lime

2021 ◽  
Vol 9 (VI) ◽  
pp. 3598-3604
Author(s):  
Bhagwan Singh Lodha
Keyword(s):  
Glass Powder ◽  
Clayey Soil ◽  
Expansive Soil ◽  
Waste Glass ◽  
Engineering Properties ◽  
Binding Property ◽  
Unconfined Compression Test ◽  
Quick Lime ◽  
Waste Glass Powder ◽  
Consolidation Settlement

This study was carried out with an intention to observe any sign of improvement of expansive clayey soil due to the addition of Waste Glass Powder (WGP) with it. In this laboratory work clayey (BC) type soil has been chosen. The reason behind choosing clay is that it has many problems. The main problem is that it undergoes consolidation settlement due to the application of long-term loading. Another problem is it shrinks significantly if it is dried and expands significantly, if it absorbs moisture than exerts much pressure on the substructure. Quick Lime and Waste Glass powder is chosen to check the improvement because waste glass powder is cohesionless material and also contains silica, lime etc. Addition of cohesionless material to the cohesive soil means it will lesser the consolidation settlement and expansive nature of soil and Lime provides binding property. To investigate the traditional methods of analysing, the effect of additives on soil has been adopted i.e., conducting several tests of untreated soil and soil treated with waste glass and lime with varying percentage and then comparing the results obtained. The tests that were carried out in this study are Compaction test (Proctor test), Consolidation test (unconfined compression test). MDD and Unconfined compressive strength increases with the addition of glass powder and lime with oven dried expansive soil.

scholarly journals Waste Plastic as soil bearing Capacity Enhancer

10.17158/516 ◽  
2016 ◽  
Vol 19 (2) ◽  
Author(s):  
Ruben M. Ruiz ◽  
Renan P. Limjuco ◽  
Ebony Joseph B. Dolino ◽  
Michelle T. Llaban ◽  
Jeric N. Maratas ◽  
...  
Keyword(s):  
Bearing Capacity ◽  
Primary Objective ◽  
California Bearing Ratio ◽  
Engineering Properties ◽  
P Value ◽  
Waste Plastic ◽  
Soil P ◽  
Significant Difference ◽  
Engineering Soil ◽  
Recycled Waste

<p>The necessity of improving the engineering properties of soil has been recognized; therefore, it is very important to find ways to enhance the weak soil, and using plastic waste is one promising way of doing it. The primary objective of this study is to compare the bearing capacity of the two types of soil (Clay and Item-201) in different concentrations of plastics, namely, at 0%, 0.5%, and 1%. Primarily, this investigation aimed to compare the California bearing ratio (CBR) of the two types of soil each with three concentrations of plastic. This study made use of the experimental design, specifically posttest design only to determine the effectiveness of using recycled waste plastic as soil bearing capacity enhancer. Findings revealed that in terms of the type of soil, there is a significant difference in California bearing ratio between clay and Item 201 (p-value &lt; 0.05). On the other hand, the California bearing ratio of the soil samples in various concentrations are not the same. As with the interaction between the type of soil and the waste plastic, a two-way ANOVA reveals that there is significant interaction between them that might have influenced California bearing ratio in the soil (p-value &lt; 0.05).</p><p> </p><p><strong>Keywords:</strong> Engineering, soil, waste plastic, soil bearing capacity enhancer, California bearing ratio, experimental, ANOVA, Davao City, Philippines.</p>

The Red Sea Metalliferous Sediments

2021 ◽  
Author(s):  
M. Clara Modenesi ◽  
J. Carlos Santamarina
Keyword(s):  
Red Sea ◽  
Environmental Conditions ◽  
Raw Materials ◽  
Soil Classification ◽  
Complete Characterization ◽  
Liquid Limit ◽  
Engineering Properties ◽  
Soil Behavior ◽  
Sediment Formation ◽  
Brine Pools

&lt;p&gt;The demand for metals and raw materials continues to increase as onshore deposits become more depleted. Our oceans contain large unexplored areas that may contain new resources in the form of Mn-nodules, Co-rich crusts, and massive sulfides. A complete characterization and assessment of these deposits are fundamental for the evaluation of resource extraction, separation, and disposal processes.&lt;/p&gt;&lt;p&gt;The Red Sea holds unique examples of sediment accumulations formed under distinctive environmental conditions. The Atlantis II deep is located in the central part of the Red Sea at 2 km depth and on top of the spreading axis. This deep accumulates sediments that result predominantly from the discharge of hydrothermal fluids into hot and stratified brine pools. The changes in environmental conditions and the hydro-chemical conditions in the brine pool control sediment formation. The accumulations are enriched with metals, such as Ag, Au, Cu, Co, and Zn. The sediments in this deep hold a record of the formation history and their brine pools tell a story about on-going processes.&lt;/p&gt;&lt;p&gt;On-going research at the Energy Geo-Engineering Laboratory EGEL, KAUST includes (1) Geotechnical index properties (liquid limit, grain size distribution, and specific surface) and consolidation tests to infer engineering properties, (2) Sediment classification based on the Revised Soil Classification System, (3) Geochemistry and mineralogy using XRD, ICP-OES and (4) Microstructure and texture with SEM imaging. An advanced sediment characterization of these fine-grained metalliferous deposits gives a comprehensive understanding of the soil behavior.&lt;/p&gt;

Pelatihan Pemanfaatan Microsoft Office bagi Kepala Lingkungan di Kelurahan Abianbase

2020 ◽  
Vol 3 (1) ◽  
pp. 55-61
Author(s):  
Ida Ayu Made Wedasuwari ◽  
Dewa Gede Bambang Erawan ◽  
Embun Hayati
Keyword(s):  
Microsoft Excel ◽  
Microsoft Word ◽  
Microsoft Office

Pemahaman microsoft office sangat penting untuk dipelajari dan diimplementasikan, namun ironisnya masih banyak yang belum memahami bagaimana cara menggunakannya terutama dalam memasukkan data administrasi. Metode yang digunakan pada pengabdian kepada masyarakat ini dengan mengadakan pelatihan yang meliputi teori dan praktik yang berkaitan dengan penggunaan fitur-fitur pada microsoft word dan microsoft excel. Untuk dapat melaksanakan kegiatan pelatihan pemanfaatan microsoft office kepada kepala lingkungan di Kelurahan Abianbase dengan baik dan terstruktur maka pelaksanaan kegiatan dirancang dalam beberapa tahapan seperti tahap persiapan, tahap implementasi, tahap monitoring, dan tahap evaluasi. Materi yang disampaikan ada 2, yakni mengenai microsoft word sebagai alat pembuatan surat-menyurat, dan microsoft excel sebagai alat penginputan data warga. Para peserta mengikuti kegiatan dengan sangat antusias. Setelah diadakannya pelatihan mengenai microsoft office, pemahaman kepala lingkungan terhadap materi tersebut semakin meningkat serta peserta lebih bisa menggunakan microsoft office lebih optimal dalam menginput data administratif.

Instability and stabilization of an embankment on the Irbid–Amman Highway in Jordan

1994 ◽  
Vol 31 (6) ◽  
pp. 1015-1021 ◽  
Author(s):  
Azm S. Al-Homoud ◽  
Ahmad B. Tal ◽  
Abdallah I. Husein (Malkawi)
Keyword(s):  
Stability Analysis ◽  
Slope Stability ◽  
Engineering Properties ◽  
Soil Parameters ◽  
Remedial Measures ◽  
Geotechnical Investigation ◽  
The Road ◽  
Landslide Zone ◽  
Time Of Failure

This paper includes a summary of a geotechnical investigation of an embankment site at station 47 + 300 along the Irbid–Amman Highway in Jordan. The embankment suffered instability problems. This study includes geological and geotechnical mapping of the study area as well as determination of the engineering properties of the various materials encountered at the site.Stability analysis is carried out for the original embankment to explain the failure mechanism, assess the condition at the time of failure, and evaluate the soil parameters for use in stability analysis of remedial measures. Stability analysis is carried out for remedial works. Recommendations are suggested to stabilize the sliding area and to repair the road traversing this landslide zone. Key words : slope stability, embankment, remediation.

Assessing the Effectiveness of Soil Parameters for Ground Response Characterization and Soil Classification

2008 ◽  
Vol 24 (3) ◽  
pp. 565-597 ◽  
Author(s):  
Simone Barani ◽  
Roberto De Ferrari ◽  
Gabriele Ferretti ◽  
Claudio Eva
Keyword(s):  
Response Spectrum ◽  
Soil Column ◽  
Soil Classification ◽  
Building Code ◽  
Soil Parameters ◽  
Ground Response ◽  
Velocity Response ◽  
Spectrum Intensity ◽  
Velocity Response Spectrum ◽  
Over The Top

The average shear wave velocity over the top 30 m of a soil profile ( VS,30) represents an usual parameter for soil classification in a modern building code for seismic design. In this work the ground response of about 100 soil profiles in Tuscany and Molise (Italy) is studied through 1-D numerical simulations in order to evaluate the reliability of European and Italian soil classifications based on the VS,30 criterion. The amplification factor, Fa, defined here as the ratio of the pseudo-velocity response spectrum intensity (Housner 1952) at the surface, S Is, to the pseudo-velocity response spectrum intensity at the rock outcrop, S Ir, is related to some soil parameters, such as VS,30, the fundamental frequency of vibration of the soil column, F0, and seismic impedance contrast, Iw. Analyzing the standard deviation of the residual obtained from regression analyses of Fa versus VS,30, F0, and Iw shows that F0 is the most helpful parameter for the prediction of Fa. Hence F0 appears to be more appropriate than VS,30 and Iw for the characterization of the seismic response of a site and, therefore, should not be disregarded in building code soil classifications.

Evaluation of liquefaction potential of foundation soils at Duncan Dam

1994 ◽  
Vol 31 (6) ◽  
pp. 951-966 ◽  
Author(s):  
V.S. Pillai ◽  
R.A. Stewart
Keyword(s):  
Engineering Properties ◽  
Soil Parameters ◽  
Confining Stress ◽  
Undisturbed Soil ◽  
Liquefaction Potential ◽  
Sand Liquefaction ◽  
Cyclic Resistance ◽  
And Performance ◽  
Design Earthquake ◽  
The Right

A comprehensive program of field, laboratory, and analytical investigations was carried out to evaluate the potential of liquefaction for the foundation soils at Duncan Dam. Duncan Dam was completed in 1967 under the Columbia River Treaty in southeastern British Columbia. The 39 m high zoned embankment dam is founded on a sequence of sands, silts, and gravels. Some of the foundation soils may liquefy during earthquake loading and this would affect the stability and performance of the dam. The liquefaction studies were carried out in two phases to characterize the engineering properties of the foundation soils and to assess its potential for triggering liquefaction using the total stress approach. This paper describes methods of assessment of liquefaction potential using soil parameters based on field penetration data (Seed's method) and laboratory testing of undisturbed soil samples obtained in situ after freezing the ground (Lab method) and presents the results of triggering analysis. Influence of confining stress (Kσ) and initial static shear stress (Kα) on liquefaction were investigated and site-specific Kσ and Kα curves were developed.For the design earthquake (M 6.5, PGA = 0.12g) both the Lab method and Seed's method predict a significant extent of liquefaction of the foundation soils under the downstream slope in the right half of the dam. Key words : sand, liquefaction, confining stress, density, cyclic resistance ratio.

scholarly journals Effect of Saturation Levels on Shear Strength and Bearing Capacity Properties of Soil Types

2019 ◽  
Vol 54 (6) ◽  
Author(s):  
Mahmood D. Ahmed ◽  
Alaa D. Almurshedi ◽  
Hayder H. Alwan
Keyword(s):  
Bearing Capacity ◽  
Unsaturated Soils ◽  
Soil Classification ◽  
Soil Samples ◽  
Engineering Properties ◽  
Test Results ◽  
Soil Layers ◽  
Angle Of Internal Friction ◽  
Noticeable Reduction ◽  
Properties Of Soil

This study presents a comprehensive set of laboratory works for the examined soil layers extracted from Baghdad city (specifically from Alkadhimya, Alaitaifiya, and Alhurriya) to illustrate their engineering properties. The researchers have adopted the unified soil classification system for soil classification purposes. Also, the direct shear test was performed for soil samples with various degrees of saturation (0%, 25%, 50%, 75%, and 100%). The test results have shown a significant reduction in cohesion property with higher moisture content within soil samples. Also, a noticeable reduction in angle of internal friction value has occurred with such changes. Furthermore, it has been found that the bearing capacity of unsaturated soils ranged between 2000 and 3000 KPa, and about 500-700 KPa for the soaked soil samples.

scholarly journals Knowledge, attitude and practice towards adverse drug reactions reporting in post graduate students of a tertiary care hospital

2019 ◽  
Vol 8 (6) ◽  
pp. 1320
Author(s):  
Aparna S. Chincholkar ◽  
Alisha Naik
Keyword(s):  
Adverse Drug Reactions ◽  
Health Care Professionals ◽  
Tertiary Care ◽  
Care Hospital ◽  
Drug Reactions ◽  
Microsoft Excel ◽  
Cross Sectional ◽  
Adr Reporting ◽  
Microsoft Office ◽  
Knowledge Attitude And Practice

Background: Adverse Drug Reactions (ADRs) are a major cause of morbidity and mortality. Under reporting of ADRs by health care professionals is a very common problem worldwide. So, the present study was planned to assess the knowledge, attitude and practices of postgraduate (PG) students towards ADR reporting and suggest possible ways for improvement.Methods: It was a cross sectional questionnaire-based study conducted among 44 PG students using a questionnaire with questions on knowledge (21), attitude (13) and practices (15) of ADR reporting. The questionnaire was analyzed question wise and the percentage was calculated using Microsoft Excel spreadsheet in Microsoft Office 2010 software.Results: Most of them were aware of the term pharmacovigilance (PV) (95.45%). 54.55% agreed to be trained on how to report an ADR. 88.63% knew about the existence of pharmacovigilance committee in the institute.93% of participants knew that Central Drug Standard Control Organization (CDSCO) is responsible for monitoring of ADRs. 56.82% were aware about VIGIBASE an online software to report ADR. 81.82% of participants had agreed to witness ADRs in patients but only 38.64% reported them. The main reason behind it was non – availability of ADR forms. 42.55% opine that mobile based app would be the most preferred method to send ADR information to an ADR reporting center.Conclusions: There exists a huge gap between ADR experienced and ADR reported by PG students. Participants agreed upon necessity of reporting ADR and periodic briefing about PV.

scholarly journals Persamaan dan Perbedaan Microsoft Excel 2007, 2010, 2013 dan 2016

2019 ◽  
Author(s):  
Khoirul Ngibad
Keyword(s):  
Microsoft Excel ◽  
Microsoft Office

Microsoft Excel adalah sebuah program aplikasi lembar kerja yang merupakan bagian dari paket software Microsoft Office Program ini berfungsi sebagai aplikasi untuk mengolah data secara otomatis yang berupa perhitungan dasar, rumus, pemakaian fungsi maupun table. Pembuatan grafik dan manajemen data juga bisa dikerjakan dengan software ini. Pada tampilan Microsoft excel tahun 2007 fitur-fitur yang digunakan masih terbilang cukup sederhana namun seiring berjalannya waktu maka kebutuhan akan software pengolah data yang lebih canggih memang dibutuhkan. Untuk memenuhi kebutuhan tersebut maka microsoft melakukan improvement dengan meluncurkan software microsoft excel yang lebih canggih dengan fitur-fitur terbaru. Contohnya microsoft excel 2016 yang sudah bisa terhubung dengan berbagai platform yaitu Windows, android, dsb. Tujuan artikel ini adalah untuk mengetahui persamaan dan perbedaan yang ada pada microsoft excel tahun 2007, 2010, 2013 dan 2016. Semoga artikel ini bisa menambah pengetahuan juga bisa bermanfaat bagi para pembaca dan pencari informasi terkait.

Sign in / Sign up

Export Citation Format

Share Document