1 / 12

Bruce Mayer, PE Registered Electrical & Mechanical Engineer BMayer@ChabotCollege

Engineering 25. EXCEL Integration. Bruce Mayer, PE Registered Electrical & Mechanical Engineer BMayer@ChabotCollege.edu. Game Plan: Divide Unknown Area into Strips (or boxes), and Add Up. Excel Numerical Integration . Employ Trapezoidal rule with used Slanted-Line tops. Trapezoidal Elements

gavan
Download Presentation

Bruce Mayer, PE Registered Electrical & Mechanical Engineer BMayer@ChabotCollege

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Engineering 25 EXCELIntegration Bruce Mayer, PE Registered Electrical & Mechanical EngineerBMayer@ChabotCollege.edu

  2. Game Plan: Divide Unknown Area into Strips (or boxes), and Add Up Excel Numerical Integration • Employ Trapezoidal rule with used Slanted-Line tops

  3. Trapezoidal Elements • By Trapezoid Geometry • Then the Incremental Area

  4. Trapezoidal Integration by Excel • Integrate over 1.7-4.3 using Excel • That is, Find • Show Game Plan on Next Slides

  5. The Function Plotted

  6. Set Up Integration Strips

  7. Integration Equations • dA = [Avg Strip Hgt]*[Strip Width]

  8. Data Acq integration – NO Fcn

  9. Time in Excel  DAYS • Regardless of how TIME is DISPLAYED in a spreadsheet table, Excel ENCODES as DAYS • Any “time” format can be converted to Fractional Days using either of • reFORMAT the current Cell • Copy-n-Paste VALUES into a number-formatted cell • Excel uses this “Day Code” to Add and/orSubtract Dates & Times

  10. Time↔DayCode Equivalency

  11. Excel HELP on DATE Codes • In Excel the “Date Codes Start at the “zero hour” of the year 1900 • See Excel help for more information • Remember all Times & Dates are internally stored as DAYS

  12. MATLAB Code % Bruce Mayer, PE * 07Dec09 % ENGR36 * EXCEL integration Prob % file = Excel_Integ_Stem_0912.m % % Set up WhtBd Graphic to show % integration Strips % x = [1.7:.05:4.3] y = 8*exp(-0.2*x).*sin(9*x.^0.63) + log(sqrt(7*x)) stem(x,y), grid, axis([1.6 4.4 -3.5 7])

More Related