Presentaci

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