Part 2. Use of Excel Functions

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