| |
A |
B |
C |
D |
E |
F |
G |
H |
|
|
| 1 |
AFinScript -
why it works? Main rules. |
|
AFinScript © AFIN 2016 |
|
| 2 |
|
Start: [F5] or [Ctrl+Q] |
|
| 3 |
<<< Parameters |
|
Info: 5 columns (A:E = 'COCPI..T') from the #11 row
are reserved for the AFinScript's program. |
|
|
|
|
|
| 4 |
|
Here are lines (1-9) used by user to say titles, global parameters,
global comments, info or whatever you want. |
|
|
| 5 |
|
|
|
|
|
|
| 6 |
|
|
|
|
|
|
| 7 |
|
AFinScript starts at line 11. |
|
|
| 8 |
|
The 10. row is commonly used as a title row. |
|
|
| 9 |
|
|
|
|
|
|
| 10 |
Class (Vendor) |
Object |
Command |
Parameters |
Info |
The rest: Comments,
calculations, row parameters |
| 11 |
# |
This is an AFinSript program. |
. |
|
|
|
|
|
| 12 |
. |
|
|
|
. |
|
|
|
|
|
| 13 |
# |
It STARTS at 11. row of ANY WORKSHEET (in 10. row you can say titles
like here) |
. |
|
|
|
|
|
| 14 |
# |
...and goes to the FIRST EMPTY
ROW (in the first column - 'A') |
. |
|
|
|
|
|
| |
. |
|
|
|
|
|
|
|
|
|
| 13 |
# |
Some remarks about colours: |
. |
|
|
|
|
|
| 14 |
# |
This is a comment. The line marked (beginning)
with "#" or '@' or the text beginning with "COMMENT:" in
the first column IS A COMMENT and a font is automatically coloured to GREEN. |
. |
|
|
|
|
|
| 14 |
#This is a comment, too. |
|
. |
|
|
|
|
|
| 14 |
@This is a comment, too. |
|
. |
|
|
|
|
|
| 14 |
COMMENT: |
This is a comment, too. |
. |
|
|
|
|
|
| 16 |
ABCDEF |
This is a line with the font formatted as ITALIC. Italic formatted
lines (only 'A' column is tested) are inactive - NOT EXECUTED (not
interpreted). |
. |
|
|
|
|
|
| 17 |
ABCDEF |
The same(!) with the crossed lines - as you wish. |
. |
|
|
|
|
|
| 17 |
ABCDEF |
In inactive lines a font is automatically coloured to GREY. |
. |
|
|
|
|
|
| 15 |
. |
<<<<< This is A POINT (as an example of
non-interpretable 'object'). This is used NOT TO STOP THE PROGRAM and it is
not a comment. |
. |
|
|
|
|
|
| 15 |
. |
<<<<< If the line is not-italic, not-crossed,
not-a-comment - it is 'NORMAL'. In the normal line font is formatted to
BLACK. |
. |
|
|
|
|
|
| 18 |
. |
|
|
|
. |
|
|
|
|
|
| 19 |
# |
Those lines are still "executed"… because there are not empty
in 'A' column. |
. |
|
|
|
|
|
| 20 |
. |
|
|
|
. |
|
|
|
|
|
| 21 |
Any Library |
Any object |
Any command |
Any parameters |
. |
|
|
|
|
|
| 22 |
# |
The above command is a sample command of AFinScript |
. |
|
|
|
|
|
| 23 |
. |
|
|
|
. |
|
|
|
|
|
| 24 |
XXX |
This line is also not executed because it is NOT RECOGNIZED (no known
class). But it does not stop the program - it is not empty |
. |
|
|
|
|
|
| 25 |
# |
<<<<< This is "THE LAST not empty" row. It
ends the program. |
. |
|
|
|
|
|
| 26 |
|
<<<<< This line is already NOT EXECUTED (is empty). The
first not executed line is used to say info about the process here in
'E" column >>>>> |
00:00,5 |
|
|
|
|
|
| 27 |
|
|
|
|
|
|
|
|
|
|
| 28 |
|
|
|
|
|
|
|
|
|
|
| 29 |
|
|
|
|
|
|
|
|
|
|
| 30 |
|
<<<<<The rest of the worksheet is ignored by the
program. |
|
|
|
|
|
|
| 31 |
|
|
|
|
|
|
|
|
|
|
| 32 |
|
|
|
|
|
|
|
|
|
|
| 33 |
|
|
|
|
|
|
|
|
|
|
| 34 |
|
|
|
|
|
|
|
|
|
|
| 35 |
|
|
|
|
|
|
|
|
|
|
| 36 |
|
|
|
|
|
|
|
|
|
|
| 37 |
|
|
|
| 38 |
|
|
|
| 39 |
|
|
|
| 40 |
|
|
|
| 41 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|