Computer Programming (TKK-2144)

1. 13/14 Semester 1 Computer Programming(TKK-2144) Instructor: Rama Oktavian Email: rama.oktavian@ub.ac.id • Office Hr.: M.13-15, W. 13-15 Th. 13-15, F. 13-15

2. Outlines 1. Introduction to Microsoft Excel 2. Introduction to Spreadsheet

3. Microsoft Excel Microsoft Excel 2007 • Lesson 1: What’s changed, and why • Lesson 2: Get to work in Excel

4. What’s changed, and why Yes, there’s a lot of change in Excel 2007. It’s most noticeable at the top of the window. But it’s good change. The commands you need are now more clearly visible and more readily available in one control center called the Ribbon.

5. What’s on the Ribbon? The three parts of the Ribbon are tabs, groups, and commands. Tabs: Tabs represent core tasks you do in Excel. There are seven tabs across the top of the Excel window. Groups: Groups are sets of related commands, displayed on tabs. Commands: A command is a button, a menu, or a box where you enter information.

6. A new view To see the new view, click Page Layout View on the View toolbar . Here’s what you’ll see in the worksheet: Column headings. Row headings. Margin rulers.

7. Microsoft Excel The Basics – Cell editing A1 Columns Rows

8. Introduction to Excel In each cell there may be the following types of data • text (labels) • number data (constants) • formulas (mathematical equations that do all the work)

9. Introduction to Excel Text Formulas Data Formulas

10. Introduction to Excel Working with formula Formulas ALWAYS begin with an = sign. This “tells” Excel that a calculation will need to be performed.

11. Introduction to Excel Working with formula The symbols for the operations are not all the same. So to calculate 3x4 You would enter =3*4 And the spreadsheet would show “12”. (That’s the answer!)

12. Introduction to Excel Working with formula Using Built-in Functions • While editing a cell, choose • Insert→Function, or click • the function button

13. Introduction to Excel Formatting cells Fixed format 0.1  10% 0.13  1.3e-01 Useful for large text

14. Introduction to Spreadsheet What is a Spreadsheet? A program that allows you to use data to forecast, manage, predict, and present information.

15. Introduction to Spreadsheet Spreadsheet uses School: Student grades, payroll Sports: individual and team statistics Personal: checkbook, household expenses Business: payroll, investments

16. Introduction to Spreadsheet Spreadsheet uses Fact: the spreadsheet program, and primarily Microsoft Excel, is the most common computing tool used by the practicing chemical engineer.

17. Introduction to Spreadsheet Types of ChE calculations carried out using Excel • General, small-scale, day-to-day calculations • formula-based calculations • data manipulation, graphics & statistics • what-if scenarios and case studies • Flowsheet calculations • material & energy balances • vapor-liquid equilibrium • chemical equilibrium & reaction kinetics • detailed design of process equipment • Financial calculations • project economics • profit/cost optimization

18. Introduction to Spreadsheet Problem-solving capabilities of Excel • Evaluation of engineering formulas • Data handling and graphics • Solution of algebraic equations • Solution of differential equations • Optimization calculations • Applied statistics • Advanced techniques • use of Visual Basic for Applications [VBA] • use of add-in products [Solver, . . .] • communication with other programs [HYSYS, LabView, . . .]

19. Product Sep- ara- tor Feed Reactor Recycle Introduction to Spreadsheet Example Problem: Felder & Rousseau, 4.6-5 Dehydrogenation of Propane 95% overall conversion of propane Separator produces 2 streams: Product: H2, C3H6, 0.555% of C3H8 leaving reactor Recycle: balance of unreacted C3H8 5% of C3H6 in Product stream

20. Thank You !