Advises students to obtain rectangular aluminum foil from their instructor and measure the length and width of the foil using a ruler. Read More: Plotting Row Number Instead of Value in Excel (with Easy Steps). The IF() function returns #N/A if the result is zero (Figure I): The examples contrived, but dont let that bother you. Accentuate the zero line in a chart. The moist density, or unit weight, of each compacted specimen is computed by dividing the mass of the soil (minus the mold assembly) by the volume of the mold. The Hidden and Empty Cell Settings dialog appears. The degree of saturation is a variable, (both from material to material and at different %compaction in the same material), and as such is not a reliable way of checking a proctor curve. Note that zero air void line cant be achieved in real life. For each Proctor point, the operator compacts the specimen into the pre-weighed soil compaction mold assembly in three to five layers (lifts) according to the method required. The data used in this video is taken from the book titled Principles of Geotechnical Engineering 9th Edition by Braja M Das and Khaled Sobhan. British Healthcare Awards Because soils are natural materials, its nearly impossible to predict their properties accurately enough for engineering applications without specific tests. Explains that the data obtained in this experiment are consistent with this theory. the time allowed for marination is 12 hours. Some methods and materials require adding coarse native material back into the final specimen. All Rights Reserved. A material's plot will depend on the gradation of the material and on the material shape. British Business Awards Question: For the data given below (Gs = 2.64): Plot the compaction curves (yd vs w) Establish the maximum dry density and optimum moisture content for each test. Any thoughts? Download Excel Workbook. Therefore, users may wonder how to make a Lineweaver Burk plot in Excel. RA rakesh_agrawal Replied on March 30, 2015 Report abuse Hi, Four or five specimens are prepared for the compaction points with increasing moisture content that will bracket the estimated optimum water content. Click Vendor 1s drop-down and uncheck zero (. British Sustainability Awards 7. British Interior Design Awards Explains that sieve analysis demonstrates that almost of soil consisted of sand, and very limited clay. Arab Power 100, Trade Route India In a perfect world if you knew the exact figure for the entrained air voids, say 2.36% e.g., then your plotted voids line would go through each wet point of the proctor curve, however, it still wont be precise because the proctor curve is simply a line of best fit through four or more data points which each have their own vagaries of precision. Explains that the wilson plot method uses the fact that when the velocity of the hot fluid in a heat exchanger is varied, the only resistance to heat transfer that changes is. Explains that rpp requested an evaluation regarding the type of operating system and whether a special, heavy-duty tablet would be required. Defines atterberg limit as the certain water content which is exhibit in soils at a given properties. I hope this poat doesn't sound argumentative, it is not meant in that vain. Like the methods discussed above, its a limited choice; you can only chart one vendor at a time. for specific gravity values of 2.5, 2.6, 2.7, 2.8. But is there a way to combine IF and IFERROR? Explains that from an energy balance around a heat exchanger, it is clear that the heat duties. Explains how to solve systems of equations by plugging in 2, 3, 4, 5, and 6 for x.2. Some will work with limited results and others wont work at all. Water is added incrementally and mixed thoroughly to increase the individual moisture contents for each specimen by about 2%. Weight of cylinder + compacted soil Also plot the 70, 80, and 90% saturation curves. Zero Air Voids: Plot the zero air voids curve (100% saturation) for specific gravity values of 2.5, 2.6, 2.7, 2.8. The ZAV will always be above the proctor curve. This results in higher maximum soil densities at lower optimum moisture contents. Stacked bar chart: Shows four stacks for the months without a zero value. Average moisture content (percent) Explains the falling head permeability test, which uses water capability to pass through a sample and determines the diameter of the standpipe. Performed for __________________ Location __________________________ Project ________________________ Job No. Dry Unit Weight Determination Concludes that the ground water in disposal site has been polluted by leachate, which was observed during 12 months from december 2010 november 2011. Some of the cells (random) have either zero value or error value. The dry density is given by For zero air void line put na= 0 Hence. Manufacturing, THE BRITISH PUBLISHING COMPANY COPYRIGHT 2022. Explains how to plot a graph of mass vs. volume using labels, titles, units, and the line of best fit. TechRepublic Premium content helps you solve your toughest IT issues and jump-start your career or next project. If the field moisture content of the soil differs from the laboratory optimum moisture by more than 2% or 3%, it becomes more difficult to compact the material to the required density. density to moisture content curve, air void and zero void line |soil mechanics | Multi Experts Tutor - YouTube 0:00 / 6:01 Soil Mechanics 1 density to moisture content curve, air void. So this is consistent with my plot. Click Find & Select in the Editing group on the Home tab and then choose Replace from the dropdown, or press Ctrl + H. If necessary, click Options to display more settings. Plot empty cells as interpolated. Play with the value of Period to see if you get something you like. Explains the purpose of the lab, which is to determine the density of a solid and an unknown liquid. values by using buffers set at PH 1, 3, 5, 7, 9. the soil tested is fined soil where more than 35 % of soil is passing through 0.06 mm. -- Select 'Design' -- that . The Zero Air Voids Line . The results are plotted with moisture on the horizontal axis and dry unit weight on the vertical to form a curve that defines maximum dry density and optimum moisture content. June 7, 2022 . The setting for the secondary vertical axis only affects the secondary horizontal axis. In this tutorial, Ill review a few methods for handling zero values that offer quick but limited results with minimal effort. Enter the data you want to skip in the same location as the original (row or column) but add it as a new series. Explains the contents of a graduated cylinder, 50 ml beaker, aluminum foil and aluminum pellets, computer, distilled water, graph paper, electronic balance, ruler, and thermometer. If youre working with one chart, you can quickly bypass the guesswork by using a chart setting to determine how to chart zero values. Density Determination No. Trade Route Hong Kong, Property 1. Global Britain Awards Explains how they used crucible tongs to identify the mass and volume of the unknown liquid obtained from the instructor. Basic weight volume relationships are used to develop the equation for the ZAV line. Explains that compaction effort at given moisture content had an essential effect on the structure and engineering properties of compacted cohesive soil. while these values are still fairly close to unity, it may be possible to obtain better results by modifying the power to which the velocity is. Keep in mind this next formatting approach has varied results. The following graph should result. The standard and modified Proctor test procedures are straightforward. If field moistures differ more than 2% or 3%, it becomes more difficult to compact to the required density. Analyzes how the precision of the results is evident from the fact that the r2 values obtained in the wilson plots are close to unity for all exchangers tested. Explains that it can be shown that h v0.8 for sufficiently high fluid velocity. Soils are the most basic and least expensive construction materials available. Explains that the hydrometer test covers the quantitative determination of the particle size distribution in a soil from coarse sand size to clay size. Now that youre familiar with the example data, lets review a few methods for suppressing the zero values in our example charts. In the resulting dialog box, choose Custom from the Category list. On the other hand, there will be times when you wont want to draw attention to a zero. NOTE: This article serves as an informational guide to equipment and techniques used to perform the Proctor moisture/density relationship tests as described in ASTM D698 and D1557 or AASHTO T 99 or T 180 test methods. All rights reserved. Explains how to subtract the mass of the empty cylinder from the combined water measurements to find the three mass measurements of water. British Food & Drink Awards - edited Call breaded ham and cheese breakfast bars school| ap human geography frq 2018 student samples or metrotown food court hours Other Versions of Excel: Click the Insert tab > Line Chart > Line. Plot the line of optimums. Gilson supplies a complete line of soil compaction and Proctor equipment and accessories. Compaction Testing Equipment required for performing the laboratory proctor test is also straightforward and widely available. This problem has been solved! Explains how they obtained an unknown metal with an identification number (6) from the instructor. You will only get dry densities close to the zero air void line if you can pack all the voids, however if as described you have a fine sand, there may be insufficient fines to achieve this. SLAs streamline operations and allow both parties to identify a proper framework for ensuring business efficiency Susan Sales Harkins is an IT consultant, specializing in desktop solutions. To change the color of the line and the markers, execute the following steps. Small voids can be manually filled with excess samples. Click Here to join Eng-Tips and talk with other members! soil sample. I have a plotted Modified Proctor (ASTM D 1557-07) curve of fine sand (SP) with a plotted zero air voids curve that is 14 pounds above the peak and wet side of the Proctor curve. Read next: The 8 best alternatives to Microsoft Project (Free & Paid) (TechRepublic). Explains that the amount of water absorbed by the diced steak by process of osmosis is dependent on the mass before and after marination. Rather than look at the "height" of the zav above the max dry density, consider the position of the zav to the right of the max dry density/optimum moisture content. The mold with the sample is then weighed and recorded, and the soil is extruded from the mold. Field moisture can be adjusted by aerating/discing the soil or by adding water. Additionally, Excel for the web doesnt support this technique. Select a countryland IslandsAfghanistanAlbaniaAlgeriaAndorraAngolaAnguillaAntarcticaAntigua and BarbudaArgentinaArmeniaArubaAustraliaAustriaAzerbaijanBahamasBahrainBangladeshBarbadosBelarusBelauBelgiumBelizeBeninBermudaBhutanBoliviaBonaire, Saint Eustatius and SabaBosnia and HerzegovinaBotswanaBouvet IslandBrazilBritish Indian Ocean TerritoryBritish Virgin IslandsBruneiBulgariaBurkina FasoBurundiCambodiaCameroonCanadaCape VerdeCayman IslandsCentral African RepublicChadChileChinaChristmas IslandCocos (Keeling) IslandsColombiaComorosCongo (Brazzaville)Congo (Kinshasa)Cook IslandsCosta RicaCroatiaCubaCuraaoCyprusCzech RepublicDenmarkDjiboutiDominicaDominican RepublicEcuadorEgyptEl SalvadorEquatorial GuineaEritreaEstoniaEthiopiaFalkland IslandsFaroe IslandsFijiFinlandFranceFrench GuianaFrench PolynesiaFrench Southern TerritoriesGabonGambiaGeorgiaGermanyGhanaGibraltarGreeceGreenlandGrenadaGuadeloupeGuatemalaGuernseyGuineaGuinea-BissauGuyanaHaitiHeard Island and McDonald IslandsHondurasHong KongHungaryIcelandIndiaIndonesiaIranIraqIsle of ManIsraelItalyIvory CoastJamaicaJapanJerseyJordanKazakhstanKenyaKiribatiKuwaitKyrgyzstanLaosLatviaLebanonLesothoLiberiaLibyaLiechtensteinLithuaniaLuxembourgMacao S.A.R., ChinaMacedoniaMadagascarMalawiMalaysiaMaldivesMaliMaltaMarshall IslandsMartiniqueMauritaniaMauritiusMayotteMexicoMicronesiaMoldovaMonacoMongoliaMontenegroMontserratMoroccoMozambiqueMyanmarNamibiaNauruNepalNetherlandsNetherlands AntillesNew CaledoniaNew ZealandNicaraguaNigerNigeriaNiueNorfolk IslandNorth KoreaNorwayOmanPakistanPalestinian TerritoryPanamaPapua New GuineaParaguayPeruPhilippinesPitcairnPolandPortugalQatarRepublic of IrelandReunionRomaniaRussiaRwandaSo Tom and PrncipeSaint BarthlemySaint HelenaSaint Kitts and NevisSaint LuciaSaint Martin (Dutch part)Saint Martin (French part)Saint Pierre and MiquelonSaint Vincent and the GrenadinesSan MarinoSaudi ArabiaSenegalSerbiaSeychellesSierra LeoneSingaporeSlovakiaSloveniaSolomon IslandsSomaliaSouth AfricaSouth Georgia/Sandwich IslandsSouth KoreaSouth SudanSpainSri LankaSudanSurinameSvalbard and Jan MayenSwazilandSwedenSwitzerlandSyriaTaiwanTajikistanTanzaniaThailandTimor-LesteTogoTokelauTongaTrinidad and TobagoTunisiaTurkeyTurkmenistanTurks and Caicos IslandsTuvaluUgandaUkraineUnited Arab EmiratesUnited Kingdom (UK)United States (US)UruguayUzbekistanVanuatuVaticanVenezuelaVietnamWallis and FutunaWestern SaharaWestern SamoaYemenZambiaZimbabwe, By registering, you agree to the Terms of Service and Privacy Policy .*.

Why Does Everyone I Love Leave Me, Castle Speaker Spares, Articles H