![]() Worksheet 03h contains an example using the exponential function. The LOG function assumes base ten unless you specify the base in a second argument, i.e. In the large cell next to “Sound Pressure,” enter =10*LOG(SUM(F4:F11)). Next, we’ll calculate L using the SUM function to get the sum of the values in column F. Select the first cell and double-click the fill handle. Enter =10^(E4/10) in the first cell of column F. ![]() In Worksheet 03g, the A-weighted sound pressure level can be calculated from measured sound levels using the equation:įirst, you’ll have to calculate from the corrected sound value, L i, in column E. ![]() For instance, a logarithm is used to calculate the overall sound pressure from sound measurements at individual frequencies. Logarithms come up often when dealing with sound measurements. This will allow you to see how the true stress and strain compare to the engineering stress and strain. Press Enter, select that cellĪnd double-click the fill handle to apply the formula to the rest of the column. Select the first cell in the true strain column and enter the formula =LN(1+B5). Where is the engineering strain found in column B. Worksheet 03f is set up to calculate true strain from engineering strain data collected on a tensile test machine. This section covers three example problems that use these functions. ![]() Excel features many of the common mathematical functions that you’ll encounter in engineering: logarithms, exponentials, square roots and factorials.
0 Comments
Leave a Reply. |