[leecher]

E r g e b n i s / R e s u l t

The routine returns true if s contains only alphabetic characters.
This is similar to the function OISALPHA, but for a multiple character string.

B e s c h r e i b u n g / D e s c r i p t i o n

ALPHABET returns a TRUE if s is a string that consists of characters within the ranges A – Z or a – z.
The routine returns FALSE if s does not satisfy the test condition.

S y n t a x

value = call ('ALPHABET' , s)

P a r a m e t e r

s - String to test

R e t u r n s

TRUE, if the string consits of alphabetic characters, FALSE otherwise

B e i s p i e l / E x a m p l e

attach 'STRFUNC'
put call ('ALPHABET' , 'ABCDE') ! returns true, as it's alphabetic
put call ('ALPHABET' , 'ABCD9') ! returns false, as it's not alphabetic
detach 'STRFUNC'

[leecher]

E r g e b n i s / R e s u l t

The routine returns true if s is numeric.
This is similar to OISDIGIT, but for a multiple character string

B e s c h r e i b u n g / D e s c r i p t i o n

NUMERIC returns a TRUE if s is a string that consists of decimal digits (0 – 9).
The routine returns FALSE if s does not satisfy the test condition.

S y n t a x

value = call ('NUMERIC' , s)

P a r a m e t e r

s - String to test

R e t u r n s

TRUE, if the string consists of decimal digits, FALSE otherwise

B e i s p i e l / E x a m p l e

attach 'STRFUNC'
put call ('NUMERIC' , '12345') ! returns true, as it's numeric
put call ('NUMERIC' , '1234A') ! returns false, as it's not entirely numeric
detach 'STRFUNC'

[leecher]

E r g e b n i s / R e s u l t

The routine returns true if s is alphanumeric.
This is similar to OISALNUM, but for a multiple character string

B e s c h r e i b u n g / D e s c r i p t i o n

ALPHNUM returns a TRUE if either ALPHABET or NUMERIC is true for s, that is, if the characters of s are within the ranges A – Z, a – z, or 0 – 9.
The routine returns FALSE if s does not satisfy the test condition.

S y n t a x

value = call ('ALPHNUM' , s)

P a r a m e t e r

s - String to test

R e t u r n s

TRUE, if the string only consists of alphanumeric characters, FALSE otherwise

B e i s p i e l / E x a m p l e

attach 'STRFUNC'
put call ('ALPHNUM' , 'ABC12') ! returns true, as it's an alphanumeric string
put call ('ALPHNUM' , 'ABC1?') ! returns false, as it's not an alphanumeric string
detach 'STRFUNC'

[leecher]

E r g e b n i s / R e s u l t

Displays a dialog that prompts the user for a password and returns it.

B e s c h r e i b u n g / D e s c r i p t i o n

The routine displays a dialog which shows "Bitte geben Sie ihr Passwort ein" and asks the user for the password. When the user is typing, the typed characters are hidden by * characters. After the user has entered the password, it gets returned by the function.

S y n t a x

value = call ('PASSWORT')

P a r a m e t e r

R e t u r n s

The password the user entered or @, if the user cancelled.

B e i s p i e l / E x a m p l e

attach 'PASSWORT'
put call ('PASSWORT' ) ! returns the password the user entered
detach 'PASSWORT'

[leecher]

E r g e b n i s / R e s u l t

Reads a password from the user at the current cursor position and returns it.

B e s c h r e i b u n g / D e s c r i p t i o n

The routine reads character input from the keyboard at the current cursor position. When the user is typing, the typed characters are hidden by ↔ characters. After the user has entered the password, it gets returned by the function. The password can have a maximum length of 20 characters.

S y n t a x

value = call ('PASS')

P a r a m e t e r

R e t u r n s

The password the user entered or an empty string, if the user cancelled.

B e i s p i e l / E x a m p l e

attach 'PASS'
put call ('PASS' ) ! returns the password the user entered
detach 'PASS'

[leecher]

E r g e b n i s / R e s u l t

Annuity Compound Amount Factor.

B e s c h r e i b u n g / D e s c r i p t i o n

   This routine computes the Annuity Compound Amount Factor defined by
   the following expression :


                             (1 + x)**y - 1
           AnCoAmFa(x,y) = -------------------
                                    x

   where x is the rate
     and y is the term.

S y n t a x

ANNCOM can be called from a Spreadsheet cell by inputting

+call("anncom",x,y)

P a r a m e t e r

x and y are either constants or cell references.
Both the parameters and result are AP_BIGs.

R e t u r n s

The Annuity Compound Amount Factor

B e i s p i e l / E x a m p l e

+call("anncom",x,y)

[leecher]

E r g e b n i s / R e s u l t

Annuity Present Value Factor.

B e s c h r e i b u n g / D e s c r i p t i o n

   This routine computes the Annuity Present Value Factor defined by the
   following expression :


                             1 - (1 + x)**(-y)
            AnnPres(x,y) = ---------------------
                                     x


   where x is the rate
     and y is the term.

S y n t a x

ANNPRES can be called from a Spreadsheet cell by inputting

<call,"annpres",x,y>

P a r a m e t e r

x and y are either constants or cell references.
Both the parameters and result are AP_BIGs.

R e t u r n s

The Annuity Present Value Factor

B e i s p i e l / E x a m p l e

<call,"annpres",x,y>

[leecher]

E r g e b n i s / R e s u l t

Capital Recovery Factor.

B e s c h r e i b u n g / D e s c r i p t i o n

   This routine computes the Capital Recovery Factor defined
   by the following expression :


                                     x
            CapRecFa(x,y) = -------------------
                              1 - (1+x)**(-y)


   where x is the rate
     and y is the term.

S y n t a x

CAPREC can be called from Spreadsheet by inputting

+call("caprec",x,y)

P a r a m e t e r

x and y are either constants or cell references.
Both the parameters and result are AP_BIGs.

R e t u r n s

The Capital Recovery Factor

B e i s p i e l / E x a m p l e

+call("caprec",x,y)

[leecher]

E r g e b n i s / R e s u l t

Compound Amount Factor.

B e s c h r e i b u n g / D e s c r i p t i o n

   This routine computes the Compound Amount Factor defined
   by the following expression :


                ComAmFac(x,y) = (1 + x)**y


   where x is the rate
     and y is the term.

S y n t a x

COMAM can be called from Spreadsheet by inputting

+call("comam",x,y)

P a r a m e t e r

x and y are either constants or cell references.
Both the parameters and result are AP_BIGs.

R e t u r n s

The Compound Amount Factor

B e i s p i e l / E x a m p l e

+call("comam",x,y)

[leecher]

E r g e b n i s / R e s u l t

Present Value Factor.

B e s c h r e i b u n g / D e s c r i p t i o n

   This program computes the Present Value Factor which is defined by
   the following equation:


                                     1
                  preval(x,y)= ------------
                                (1 + x)**y


   where x is the rate
     and y is the term.

S y n t a x

PREVAL can be called from Spreadsheet by inputting

+call("preval",x,y)

P a r a m e t e r

x and y are either constants or cell references.
Both the parameters and result are AP_BIGs.

R e t u r n s

The Present Value Factor

B e i s p i e l / E x a m p l e

+call("preval",x,y)