1 / 31

Part 2. Use of Excel Functions

Part 2. Use of Excel Functions. Part 2. Use of Excel Functions. The use of Excel Functions will be explained for the type of functions that read information and then deliver an answer. Part 2. Use of Excel Functions.

devlin
Download Presentation

Part 2. Use of Excel Functions

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. Part 2. Use of Excel Functions

  2. Part 2. Use of Excel Functions The use of Excel Functions will be explained for the type of functions that read information and then deliver an answer.

  3. Part 2. Use of Excel Functions The use of Excel Functions will be explained for the type of functions that read information and then deliver an answer. An examples of such a function is presented here, where a function receives as inputs the nominal diameter (in inches) and the shedule for a carbon steel pipe.

  4. Part 2. Use of Excel Functions The use of Excel Functions will be explained for the type of functions that read information and then deliver an answer. An examples of such a function is presented here, where a function receives as inputs the nominal diameter (in inches) and the shedule for a carbon steel pipe. As a result it will be delivered the inside diameter.

  5. Defining the name of the function

  6. Defining the name of the function In our case, all functions start with the word "Pipe"

  7. Defining the name of the function In our case, all functions start with the word "Pipe" Pipe

  8. Defining the name of the function In our case, all functions start with the word "Pipe" Pipe Next, consider the case of the unit to be used for the nominal diameter, which may be in Imperial units or the International System.

  9. Defining the name of the function In our case, all functions start with the word "Pipe" Pipe Next, consider the case of the unit to be used for the nominal diameter, which may be in Imperial units or the International System. In the case of this example, to indicate that the function receives nominal diameters in inches, one adds "Imp". Thus the name is

  10. Defining the name of the function In our case, all functions start with the word "Pipe" Pipe Next, consider the case of the unit to be used for the nominal diameter, which may be in Imperial units or the International System. In the case of this example, to indicate that the function receives nominal diameters in inches, one adds "Imp". Thus the name is Pipe_Imp

  11. Defining the name of the function In our case, all functions start with the word "Pipe" Pipe Next, consider the case of the unit to be used for the nominal diameter, which may be in Imperial units or the International System. In the case of this example, to indicate that the function receives nominal diameters in inches, one adds "Imp". Thus the name is Pipe_Imp Third, one indicates the type of pipe material. In our example it is carbon steel, and this is indicated as "CS". So, the code is

  12. Defining the name of the function In our case, all functions start with the word "Pipe" Pipe Next, consider the case of the unit to be used for the nominal diameter, which may be in Imperial units or the International System. In the case of this example, to indicate that the function receives nominal diameters in inches, one adds "Imp". Thus the name is Pipe_Imp Third, one indicates the type of pipe material. In our example it is carbon steel, and this is indicated as "CS". So, the code is Pipe_Imp_CS

  13. Next, we indicate which parameter is to be calculated. We begin by calculating the inner diameter, so we added “Dint"

  14. Next, we indicate which parameter is to be calculated. We begin by calculating the inner diameter, so we added “Dint" Pipe_Imp_CS_Dint

  15. Next, we indicate which parameter is to be calculated. We begin by calculating the inner diameter, so we added “Dint" Pipe_Imp_CS_Dint Finally, we indicate which are the parameters to be delivered. In this case they are the nominal diameter "dn" and the shedule "sch". Thus, the name of the function is as follows

  16. Next, we indicate which parameter is to be calculated. We begin by calculating the inner diameter, so we added “Dint" Pipe_Imp_CS_Dint Finally, we indicate which are the parameters to be delivered. In this case they are the nominal diameter "dn" and the shedule "sch". Thus, the name of the function is as follows Pipe_Imp_CS_Dint_dn_sch

  17. Next, we indicate which parameter is to be calculated. We begin by calculating the inner diameter, so we added “Dint" Pipe_Imp_CS_Dint Finally, we indicate which are the parameters to be delivered. In this case they are the nominal diameter "dn" and the shedule "sch". Thus, the name of the function is as follows Pipe_Imp_CS_Dint_dn_sch The function ends with a parenthesis in which you enter the values ​​of the input parameters. With this object you can, for example, insert the values ​​as

  18. Next, we indicate which parameter is to be calculated. We begin by calculating the inner diameter, so we added “Dint" Pipe_Imp_CS_Dint Finally, we indicate which are the parameters to be delivered. In this case they are the nominal diameter "dn" and the shedule "sch". Thus, the name of the function is as follows Pipe_Imp_CS_Dint_dn_sch The function ends with a parenthesis in which you enter the values ​​of the input parameters. With this object you can, for example, insert the values ​​as Pipe_Imp_CS_Dint_dn_sch(4, STD)

  19. Next, we indicate which parameter is to be calculated. We begin by calculating the inner diameter, so we added “Dint" Pipe_Imp_CS_Dint Finally, we indicate which are the parameters to be delivered. In this case they are the nominal diameter "dn" and the shedule "sch". Thus, the name of the function is as follows Pipe_Imp_CS_Dint_dn_sch The function ends with a parenthesis in which you enter the values ​​of the input parameters. With this object you can, for example, insert the values ​​as Pipe_Imp_CS_Dint_dn_sch(4, STD) or you can enter the cell addresses where these values ​​are. For example

  20. Next, we indicate which parameter is to be calculated. We begin by calculating the inner diameter, so we added “Dint" Pipe_Imp_CS_Dint Finally, we indicate which are the parameters to be delivered. In this case they are the nominal diameter "dn" and the shedule "sch". Thus, the name of the function is as follows Pipe_Imp_CS_Dint_dn_sch The function ends with a parenthesis in which you enter the values ​​of the input parameters. With this object you can, for example, insert the values ​​as Pipe_Imp_CS_Dint_dn_sch(4, STD) or you can enter the cell addresses where these values ​​are. For example Pipe_Imp_CS_Dint_dn_sch(C2, C3)

  21. Application of the function in an Excel spreadsheet

  22. Application of the function in an Excel spreadsheet Enter the nominal diameter and pipe shedule

  23. Application of the function in an Excel spreadsheet Enter the nominal diameter and pipe shedule dn = 4 in

  24. Application of the function in an Excel spreadsheet Enter the nominal diameter and pipe shedule dn = 4 in sch = STD

  25. Application of the function in an Excel spreadsheet Enter the nominal diameter and pipe shedule dn = 4 in sch = STD Call the function and enter the input variables

  26. Application of the function in an Excel spreadsheet Enter the nominal diameter and pipe shedule dn = 4 in sch = STD Call the function and enter the input variables dn = 4 in sch = STD

  27. Application of the function in an Excel spreadsheet Enter the nominal diameter and pipe shedule dn = 4 in sch = STD Call the function and enter the input variables dn = 4 in sch = STD di = Pipe_Imp_CS_Dint_dn_sch(F4,F5)

  28. Application of the function in an Excel spreadsheet Enter the nominal diameter and pipe shedule dn = 4 in sch = STD Call the function and enter the input variables dn = 4 in sch = STD di = Pipe_Imp_CS_Dint_dn_sch(F4,F5) Press Enter

  29. Application of the function in an Excel spreadsheet Enter the nominal diameter and pipe shedule dn = 4 in sch = STD Call the function and enter the input variables dn = 4 in sch = STD di = Pipe_Imp_CS_Dint_dn_sch(F4,F5) Press Enter dn = 4 in sch = STD

  30. Application of the function in an Excel spreadsheet Ingresar el diámetro nominal y la cédula de la cañería dn = 4 in sch = STD Call the function and enter the input variables dn = 4 in sch = STD di = Pipe_Imp_CS_Dint_dn_sch(F4,F5) Press Enter dn = 4 in sch = STD di = 102.26 mm

  31. End of Part 2

More Related