excel functions. part 2 (eng)
Post on 13-Jul-2016
230 Views
Preview:
DESCRIPTION
TRANSCRIPT
Part 2. Use of Excel Functions
1
Part 2. Use of Excel Functions
2
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
3
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.
Part 2. Use of Excel Functions
4
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.
Defining the name of the function
5
Defining the name of the function In our case, all functions start with the word "Pipe"
6
Defining the name of the function
Pipe
In our case, all functions start with the word "Pipe"
7
Defining the name of the function
Next, consider the case of the unit to be used for the nominal diameter, which may be in Imperial units or the International System.
Pipe
In our case, all functions start with the word "Pipe"
8
Defining the name of the function
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
In our case, all functions start with the word "Pipe"
9
Defining the name of the function
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
In our case, all functions start with the word "Pipe"
Pipe_Imp
10
Defining the name of the function
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
In our case, all functions start with the word "Pipe"
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
11
Defining the name of the function
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
In our case, all functions start with the word "Pipe"
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
Pipe_Imp_CS
Next, we indicate which parameter is to be calculated. We begin by calculating the inner diameter, so we added “Dint"
13
Next, we indicate which parameter is to be calculated. We begin by calculating the inner diameter, so we added “Dint"
Pipe_Imp_CS_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
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
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
Pipe_Imp_CS_Dint_dn_sch
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
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
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
Pipe_Imp_CS_Dint_dn_sch(4, STD)
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)
or you can enter the cell addresses where these values are. For example
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(C2, C3)
Pipe_Imp_CS_Dint_dn_sch(4, STD)
or you can enter the cell addresses where these values are. For example
20
21
Application of the function in an Excel spreadsheet
Enter the nominal diameter and pipe shedule
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
dn = 4 in
Enter the nominal diameter and pipe shedule
24
Application of the function in an Excel spreadsheet
dn = 4 in
sch = STD
Enter the nominal diameter and pipe shedule
25
Application of the function in an Excel spreadsheet
Call the function and enter the input variables
dn = 4 in
sch = STD
Enter the nominal diameter and pipe shedule
26
Application of the function in an Excel spreadsheet
Call the function and enter the input variablesdn = 4 insch = STD
dn = 4 in
sch = STD
Enter the nominal diameter and pipe shedule
27
Application of the function in an Excel spreadsheet
Call the function and enter the input variablesdn = 4 insch = STD
dn = 4 in
sch = STD
di = Pipe_Imp_CS_Dint_dn_sch(F4,F5)
Enter the nominal diameter and pipe shedule
28
Application of the function in an Excel spreadsheet
Call the function and enter the input variables
Press Enter
dn = 4 insch = STD
dn = 4 in
sch = STD
di = Pipe_Imp_CS_Dint_dn_sch(F4,F5)
Enter the nominal diameter and pipe shedule
29
Application of the function in an Excel spreadsheet
Call the function and enter the input variables
Press Enterdn = 4 insch = STD
dn = 4 insch = STD
dn = 4 in
sch = STD
di = Pipe_Imp_CS_Dint_dn_sch(F4,F5)
Ingresar el diámetro nominal y la cédula de la cañería
30
Application of the function in an Excel spreadsheet
Call the function and enter the input variables
Press Enterdn = 4 insch = STD
dn = 4 insch = STD
dn = 4 in
sch = STD
di = Pipe_Imp_CS_Dint_dn_sch(F4,F5)
di = 102.26 mm
31
End of Part 2
top related