Category: PPTtopics

This PPT presentation provides background and an example for calculating the power required (and cost per hour) for operating an air compressor. This can be a huge cost for industrial situations. Enables you to determine cost-savings for a proposed reduction in compressed air usage.

This is a commonly-asked question in industry and manufacturing.

This PPT presentation gives background on d’Arcy’s equation for pressure loss in piping. Reviews how “Reynolds Number” is used in determining the friction factor “f” in the head loss equation. Gives an example for situation where flow is known (find pressure loss — easy) and situation where pressure loss is known (find flow — harder).

This PPT presentation introduces the ideas behind the macro-enabled (xlsm) Excel file. Thermodynamic properties of water and steam (steam tables) are tabulated. Excel custom formulas have been created so you can call a custom formula (like h(P,T) for enthalpy of a superheated vapor for automated double-interpolation within the superheated table. Basic linear interpolation schemes are used to create the custom formulas. Use Save As… to start with this basic package, and then use the custom formulas as you develop your own thermal systems model. Can be simple or complex.

The Regression and Correlation PPT file gives you a review of what’s behind linear regression and how to interpret the results. Provides an overview of how to use the Excel regression tool. Reviews how “correlation” does not necessarily mean that x “causes” y to happen, just that they are correlated numerically.

This PPT file is valuable for people associated with web-type products like paperboard, where the product is rolled onto a core.  “Exact” and “approximate” solutions are presented for determining the lineal footage of material wound onto a cylindrical core.

The Power from Steam PPT presentation gives the thermodynamic background and examples on the way steam is used to produce power, throughout manufacturing and industry. Gives worked-out examples of “how much steam do I need (lbm/hr) to produce a certain amount of power (hp or MW)?

The Hypothesis Testing Roadmap is a handy one-page “roadmap” when you are faced with a statistical analysis. There are lots of ways to get off-track when applying statistical analysis tools to a real-world analysis problem. You need to have some familiarity with statistical analysis tools, but the roadmap helps to keep things straight and will help you to explain to others how you selected the analysis tools for the job.

This PPT file Compare Two Data Sets is a classical summary of a simple statistical analysis.  It sounds easy, but it can be very subtle and tricky. This is also a classical industrial request, “Is there a statistical difference between Situation A and Situation B?” This presentation provides you with ideas on how to get started, how to perform the analysis, and how to explain your conclusion to others.

The Digitize Graphic Curves PPT file outlines a method for digitizing a curve that you see on a paper or electronic graph. This presentation shows you how to use a freeware program to digitize any curve from a scanned-in image of your graph. You won’t believe how easy it is, and how this can reduce your manual labor of looking up values from a graph.

The Using Excel Goal Seek PPT presentation describes a very handy built-in Excel tool when you have a “formula” but you cannot solve it explicitly into a y=f(x) “formula”. Many engineering problems involve “guessing” a value for the solution, and you have to keep guessing over-and-over. If you can write an equation where the left hand side is: 0=(your formula that depends on x), then you can use Goal Seek to keep automatically guessing x until the left-hand-side equals zero.