Title: Presentaci
1Part 2. Use of Excel Functions
2Part 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.
3Part 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.
4Part 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.
5Defining the name of the function
6Defining the name of the function
In our case, all functions start with the word
"Pipe"
7Defining the name of the function
In our case, all functions start with the word
"Pipe"
Pipe
8Defining 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.
9Defining 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
10Defining 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
11Defining 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
12Defining 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
13Next, we indicate which parameter is to be
calculated. We begin by calculating the inner
diameter, so we added Dint"
14Next, we indicate which parameter is to be
calculated. We begin by calculating the inner
diameter, so we added Dint"
Pipe_Imp_CS_Dint
15Next, 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
16Next, 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
17Next, 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
18Next, 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)
19Next, 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
20Next, 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)
21Application of the function in an Excel
spreadsheet
22Application of the function in an Excel
spreadsheet
Enter the nominal diameter and pipe shedule
23Application of the function in an Excel
spreadsheet
Enter the nominal diameter and pipe shedule
dn 4 in
24Application of the function in an Excel
spreadsheet
Enter the nominal diameter and pipe shedule
dn 4 in
sch STD
25Application 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
26Application 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
27Application 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)
28Application 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
29Application 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
30Application 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
31End of Part 2