1 / 34

EASTERN MEDITERRANEAN UNIVERSITY FACULTY OF ENGINEERNG Department of Industrial Engineering

EASTERN MEDITERRANEAN UNIVERSITY FACULTY OF ENGINEERNG Department of Industrial Engineering. IENG 4 6 1 System Modeling and Simulation Course Fall 2012-2013 Laboratory Session 01. Open Microsoft office> Microsoft Excel File> New> Blank Workbook. IF FUNCTION

audrey-salinas
Download Presentation

EASTERN MEDITERRANEAN UNIVERSITY FACULTY OF ENGINEERNG Department of Industrial Engineering

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. EASTERN MEDITERRANEAN UNIVERSITY FACULTY OF ENGINEERNG Department of Industrial Engineering IENG461System Modeling and Simulation Course Fall 2012-2013 Laboratory Session 01

  2. Open Microsoft office> Microsoft Excel File> New> Blank Workbook

  3. IF FUNCTION Formula: =if(condition,expression1,expression2) TRUE FALSE Example1:

  4. Write the formula in C2

  5. Enter and drag outside selection to extend series.

  6. A NESTED IF FUNCTION Formula: =if(condition1,expression1,IF(condition2,expression2,expression3)) Example2:

  7. Write the formula in C2

  8. Enter and drag outside selection to extend series.

  9. Using an AND condition in an IF function Formula: =if(AND(condition1,condition2),expression1,expression2) Both True Any of them is wrong Example3:

  10. Write the formula in C2

  11. Enter and drag outside selection to extend series.

  12. Using an OR condition in an IF function Formula: =if(OR(condition1,condition2),expression1,expression2) At least one True Both wrong Example4:

  13. Write the formula in D2

  14. Enter and drag outside selection to extend series.

  15. Using LOOKUP Function LOOKP tables are used when you want to compare a particular value to a set of values, and depending on where your value falls, assign a given answer. Formula: =VLOOKUP(lookup value, table_arrey, col_index_num, [range lookup]) Example5:

  16. Write the formula in G3

  17. Enter and drag outside selection to extend series.

  18. Example6: Lets say you want to assign letter grades to students based on a pre-spesified scale, which is shown in the following table.

  19. VLOOKUP Vertical Lookup HLOOKUP Horizontal Lookup HLOOKUP Example Example7: Using HLOOKUP function of excel, find matching departments of the following instructors:

  20. Power Example Example8: Formula: =POWER(number,power)

  21. Mod Example Example9: Formula: =MOD(number,devisor)

  22. Countif Example Example9: Formula: =Countif(range,criteria)

  23. Random Number generation Random number between a and b Formula: =RAND()*(b-a)+a When you use above formula each time that you open excel the generated random numbers will change. To stop this automatic change you should do following adjustment: File>Option>Formulas>Manual> remove Recalculate thick> OK

  24. Lab HOMEWORK#1: A small grocery has only one checkout counter. Customers arrive at this checkout counter at random from 1 to 9. each possible value of inter-arrival time has the different probability of occurrence as shown in table 1 below. The service times vary from 1 to 6 minutes with the probabilities shown in table 2. the problem is to analyze the system by simulating the arrival and service of 20 customers by using simulation table. Table1. Distribution of time between arrivals

  25. Table2. Service Time Distribution The random digits between arrivals (3 digitsis needed) and service times (2 digits is needed) are going to putted in table 3 and 4 respectively. Table3. Random digits for time-between-arrivals determination

  26. Table4. Random digits for service time determination • Conduct a simulation of the above system by using EXCEL and find the following performance measures related with the system: • The average waiting time for a customer and probability that a customer has to wait. • The average service time and average inter-arrival time. • The average time a customer spends in the system . • The average waiting time of those who wait.

  27. The End

More Related