!PipeDream/!Help

Home » Archimedes archive » Apps » PipeDream 3 ()(Colton Software).adf » !PipeDream/!Help

!PipeDream/!Help

This website contains an archive of files for the Acorn Electron, BBC Micro, Acorn Archimedes, Commodore 16 and Commodore 64 computers, which Dominic Ford has rescued from his private collection of floppy disks and cassettes.

Some of these files were originally commercial releases in the 1980s and 1990s, but they are now widely available online. I assume that copyright over them is no longer being asserted. If you own the copyright and would like files to be removed, please contact me.

Tape/disk:	Home » Archimedes archive » Apps » PipeDream 3 ()(Colton Software).adf
Filename:	!PipeDream/!Help
Read OK:	✔
File size:	1B8B bytes
Load address:	FFFDDE41
Exec address:	CC1025DB

%CO:A,24,72%
%C%%H2%PipeDream 3 Help file

 
This file gives a summary of the mouse operations available in 
PipeDream 3.  It also gives a list of the expression operators and 
spreadsheet functions.  It is intended as a reminder rather than an 
exhaustive reference.  For more information refer to the PipeDream 3 
User Guide.

%C%%H2%Mouse operations

Many of these mouse operations are described interactively in the RISC 
OS !Help application when used in conjunction with PipeDream 3.

%H2%Opening a Pipedream window

To open a new PipeDream window, click Select on the PipeDream icon on 
the icon bar.

%H2%Bringing up menus and choosing commands

With the pointer in a PipeDream window, click Menu to bring up the top 
level menu.

To bring up a sub-menu, drag the pointer over the arrow to the right of 
the menu name.

To choose a command, click Select on the command name.  this carries 
out the command and removes the menu from the screen.  If you click 
Adjust, the menu remains on the screen.


%H2%Loading documents

To load a PipeDream document, either double-click on its icon, or drag 
its icon onto the Pipedream icon on the icon bar.

To insert a file at the caret position, drag the file's icon into the 
window.


%H2%Positioning the caret

Click Select to position the caret in the first slot to the left which 
can overlap the slot underneath the pointer.  

Click Adjust to position the caret in the slot underneath the pointer.


%H2%Marking blocks

To mark a block within one column, drag select down the column.

To mark multiple columns of text, drag Adjust across them.

To mark all the rows in a range of columns, drag Select across the 
column borders.

To mark all the columns in a range of rows, drag Select down the row 
borders.

To mark all the columns in a single row, double-click Select in the row 
border.

To mark all the rows in a column, double-click Select in the column 
border.

To mark a single slot, double-click Select in the slot.

To mark the whole document, double-click Select in the top left-hand 
corner of the border.

To clear any marked block, double-click Adjust in the top left-hand 
corner of the border.

To adjust a marked block after marking it, move the pointer to the 
point at which you now want the block to end and hold down Shift whilst 
clicking Select.  The marked block will now end where you clicked 
Select.  The starting point will remain the same.

%H2%Entering slot references into the editing line

To enter a slot reference into the editing line whilst you are editing 
an expression, click Select or Adjust in the slot.  The slot can be in 
the current window or in another, in which case you will insert an 
external reference.

%H2%Scrolling the window

Position the pointer on the scroll arrow and click Select to scroll one 
line in the direction of the arrow.  Hold down Select to continue 
scrolling.  Click Adjust to scroll in the other direction.  The caret 
always remains within the PipeDream window, staying as near as possible 
to its original position.

Position the pointer on the darker part of the scroll bar (above the 
slider to scroll up, below the slider to scroll down) and click Select.  
The next windowful of the document will appear.  Click Adjust to scroll 
back the other way.  The caret always remains within the PipeDream 
window, moving, if necessary, to the point nearest to its position 
before scrolling.

%P0%
%C%%H2%Expression operators

%L%Condition operators

%L%!
%L%&
%L%|
%L%<
%L%<=
%L%<>
%L%=
%L%>
%L%>=

%C%%H2%Arithmetic operators

%L%^
%L%*
%L%+
%L%-
%L%/

%C%%H2%Spreadsheet functions

%L%abs(n)
%L%acs(n)
%L%asn(n)
%L%atn(n)
%L%atn2(x,y) 
%L%avg(list)
%L%choose(n, list)
%L%col
%L%col(ref)
%L%cos(n)
%L%count(list) 
%L%cterm(int, fv, pv)
%L%date
%L%davg(range, cond)
%L%day(date)
%L%dcount(range, cond)
%L%dcounta(range, cond)
%L%ddb(c,s,l,p)
%L%deg(n)
%L%dmax(range, cond)
%L%dmin(range, cond)
%L%dstd(range, cond)
%L%dsum(range, cond)
%L%dvar(range, cond)
%L%exp(n)
%L%fv(pmt, int, term)
%L%hlookup(key,range,off)
%L%if(cond, e1, e2)
%L%index(c, r)
%L%int(n)
%L%irr(guess, range)
%L%ln(n)
%L%log(n)
%L%lookup(key,r1,r2)
%L%loopc
%L%max(list)
%L%min(list)
%L%mod(x,y)
%L%month(date)
%L%monthdays(date)
%L%npv(interest, range)
%L%pi
%L%pmt(pcpl,int,term)
%L%pv(pmt,int,term)
%L%rad(n)
%L%rand
%L%rate(fv,pf,term)
%L%read(file,col,row)
%L%round(n,p)
%L%row
%L%sgn(n)
%L%sin(n)
%L%sln(cost,salv,life)
%L%sqr(n)
%L%std(list)
%L%sum(list)
%L%syd(c,s,l,p)
%L%tan(n)
%L%term(pmt,int,fv)
%L%var(list)  
%L%vlookup(key,range,off)
%L%write(file,col,row,exp)
%L%year(date) 
%CO:B,12,48%











































































































%L%not
%L%binary and 
%L%binary or
%L%less than
%L%less than or equal
%L%not equal
%L%equal
%L%greater than
%L%greater than or equal



%L%to the power of
%L%multiply
%L%plus
%L%minus
%L%divide



%L%Absolute value of n
%L%Arc cosine of n
%L%Arc sine of n
%L%Arc tangent of n
%L%Arc tangent of x and y
%L%average of values in list
%L%nth value in list
%L%number of column containing expression
%L%number of column containing slot reference
%L%cosine of n
%L%number of numeric slots in list
%L%number of compounding periods for investment
%L%return the current date
%L%average of slots in range which satisfy condition
%L%day number of date
%L%count of numeric slots in range which satisfy condition
%L%count of all slots in range which satisfy condition
%L%depreciation allowance of asset
%L%number of degrees in n radians
%L%maximum of slots in range which satisfy condition
%L%minimum of slots in range which satisfy condition
%L%standard deviation of slots in range which satisfy condition
%L%sum of slots in range which satisfy condition
%L%variance of slots in range which satisfy condition
%L%e to the power of n
%L%future value of investment
%L%horizontal lookup of key in range with offset
%L%if cond is true return e1 else return e2
%L%value of slot in column c and row r
%L%integer part of n
%L%internal rate of return
%L%natural log of n
%L%base 10 log of n
%L%lookup key in range 1; return corresponding value in range 2
%L%current loop number in iterative process
%L%maximum value of list
%L%minimum value of list
%L%x modulo y
%L%month number of date
%L%number of days in the month of date
%L%net present value of future cash flow
%L%3.1415926535898
%L%payment on a loan
%L%present value of series of payments
%L%number of radians in n degrees
%L%random number between 0 and 1
%L%periodic interest for investment
%L%read entry from linking file
%L%round n to p places
%L%number of row containing expression
%L%sign of n
%L%sine of n
%L%straight line depreciation
%L%square root of n
%L%standard deviation of values in list
%L%sum of values in list
%L%sum of year's digits depreciation
%L%tangent of n
%L%number of payment periods of investment
%L%variance of values in list
%L%vertical lookup of key in range with offset
%L%write expression to linking file
%L%year part of date
%CO:C,12,36%%CO:D,12,24%%CO:E,12,12%%CO:F,12,0%

00000000  25 43 4f 3a 41 2c 32 34  2c 37 32 25 0a 25 43 25  |%CO:A,24,72%.%C%|
00000010  25 48 32 25 50 69 70 65  44 72 65 61 6d 20 33 20  |%H2%PipeDream 3 |
00000020  48 65 6c 70 20 66 69 6c  65 0a 0a 20 0a 54 68 69  |Help file.. .Thi|
00000030  73 20 66 69 6c 65 20 67  69 76 65 73 20 61 20 73  |s file gives a s|
00000040  75 6d 6d 61 72 79 20 6f  66 20 74 68 65 20 6d 6f  |ummary of the mo|
00000050  75 73 65 20 6f 70 65 72  61 74 69 6f 6e 73 20 61  |use operations a|
00000060  76 61 69 6c 61 62 6c 65  20 69 6e 20 0a 50 69 70  |vailable in .Pip|
00000070  65 44 72 65 61 6d 20 33  2e 20 20 49 74 20 61 6c  |eDream 3.  It al|
00000080  73 6f 20 67 69 76 65 73  20 61 20 6c 69 73 74 20  |so gives a list |
00000090  6f 66 20 74 68 65 20 65  78 70 72 65 73 73 69 6f  |of the expressio|
000000a0  6e 20 6f 70 65 72 61 74  6f 72 73 20 61 6e 64 20  |n operators and |
000000b0  0a 73 70 72 65 61 64 73  68 65 65 74 20 66 75 6e  |.spreadsheet fun|
000000c0  63 74 69 6f 6e 73 2e 20  20 49 74 20 69 73 20 69  |ctions.  It is i|
000000d0  6e 74 65 6e 64 65 64 20  61 73 20 61 20 72 65 6d  |ntended as a rem|
000000e0  69 6e 64 65 72 20 72 61  74 68 65 72 20 74 68 61  |inder rather tha|
000000f0  6e 20 61 6e 20 0a 65 78  68 61 75 73 74 69 76 65  |n an .exhaustive|
00000100  20 72 65 66 65 72 65 6e  63 65 2e 20 20 46 6f 72  | reference.  For|
00000110  20 6d 6f 72 65 20 69 6e  66 6f 72 6d 61 74 69 6f  | more informatio|
00000120  6e 20 72 65 66 65 72 20  74 6f 20 74 68 65 20 50  |n refer to the P|
00000130  69 70 65 44 72 65 61 6d  20 33 20 0a 55 73 65 72  |ipeDream 3 .User|
00000140  20 47 75 69 64 65 2e 0a  0a 25 43 25 25 48 32 25  | Guide...%C%%H2%|
00000150  4d 6f 75 73 65 20 6f 70  65 72 61 74 69 6f 6e 73  |Mouse operations|
00000160  0a 0a 4d 61 6e 79 20 6f  66 20 74 68 65 73 65 20  |..Many of these |
00000170  6d 6f 75 73 65 20 6f 70  65 72 61 74 69 6f 6e 73  |mouse operations|
00000180  20 61 72 65 20 64 65 73  63 72 69 62 65 64 20 69  | are described i|
00000190  6e 74 65 72 61 63 74 69  76 65 6c 79 20 69 6e 20  |nteractively in |
000001a0  74 68 65 20 52 49 53 43  20 0a 4f 53 20 21 48 65  |the RISC .OS !He|
000001b0  6c 70 20 61 70 70 6c 69  63 61 74 69 6f 6e 20 77  |lp application w|
000001c0  68 65 6e 20 75 73 65 64  20 69 6e 20 63 6f 6e 6a  |hen used in conj|
000001d0  75 6e 63 74 69 6f 6e 20  77 69 74 68 20 50 69 70  |unction with Pip|
000001e0  65 44 72 65 61 6d 20 33  2e 0a 0a 25 48 32 25 4f  |eDream 3...%H2%O|
000001f0  70 65 6e 69 6e 67 20 61  20 50 69 70 65 64 72 65  |pening a Pipedre|
00000200  61 6d 20 77 69 6e 64 6f  77 0a 0a 54 6f 20 6f 70  |am window..To op|
00000210  65 6e 20 61 20 6e 65 77  20 50 69 70 65 44 72 65  |en a new PipeDre|
00000220  61 6d 20 77 69 6e 64 6f  77 2c 20 63 6c 69 63 6b  |am window, click|
00000230  20 53 65 6c 65 63 74 20  6f 6e 20 74 68 65 20 50  | Select on the P|
00000240  69 70 65 44 72 65 61 6d  20 69 63 6f 6e 20 6f 6e  |ipeDream icon on|
00000250  20 0a 74 68 65 20 69 63  6f 6e 20 62 61 72 2e 0a  | .the icon bar..|
00000260  0a 25 48 32 25 42 72 69  6e 67 69 6e 67 20 75 70  |.%H2%Bringing up|
00000270  20 6d 65 6e 75 73 20 61  6e 64 20 63 68 6f 6f 73  | menus and choos|
00000280  69 6e 67 20 63 6f 6d 6d  61 6e 64 73 0a 0a 57 69  |ing commands..Wi|
00000290  74 68 20 74 68 65 20 70  6f 69 6e 74 65 72 20 69  |th the pointer i|
000002a0  6e 20 61 20 50 69 70 65  44 72 65 61 6d 20 77 69  |n a PipeDream wi|
000002b0  6e 64 6f 77 2c 20 63 6c  69 63 6b 20 4d 65 6e 75  |ndow, click Menu|
000002c0  20 74 6f 20 62 72 69 6e  67 20 75 70 20 74 68 65  | to bring up the|
000002d0  20 74 6f 70 20 0a 6c 65  76 65 6c 20 6d 65 6e 75  | top .level menu|
000002e0  2e 0a 0a 54 6f 20 62 72  69 6e 67 20 75 70 20 61  |...To bring up a|
000002f0  20 73 75 62 2d 6d 65 6e  75 2c 20 64 72 61 67 20  | sub-menu, drag |
00000300  74 68 65 20 70 6f 69 6e  74 65 72 20 6f 76 65 72  |the pointer over|
00000310  20 74 68 65 20 61 72 72  6f 77 20 74 6f 20 74 68  | the arrow to th|
00000320  65 20 72 69 67 68 74 20  6f 66 20 0a 74 68 65 20  |e right of .the |
00000330  6d 65 6e 75 20 6e 61 6d  65 2e 0a 0a 54 6f 20 63  |menu name...To c|
00000340  68 6f 6f 73 65 20 61 20  63 6f 6d 6d 61 6e 64 2c  |hoose a command,|
00000350  20 63 6c 69 63 6b 20 53  65 6c 65 63 74 20 6f 6e  | click Select on|
00000360  20 74 68 65 20 63 6f 6d  6d 61 6e 64 20 6e 61 6d  | the command nam|
00000370  65 2e 20 20 74 68 69 73  20 63 61 72 72 69 65 73  |e.  this carries|
00000380  20 0a 6f 75 74 20 74 68  65 20 63 6f 6d 6d 61 6e  | .out the comman|
00000390  64 20 61 6e 64 20 72 65  6d 6f 76 65 73 20 74 68  |d and removes th|
000003a0  65 20 6d 65 6e 75 20 66  72 6f 6d 20 74 68 65 20  |e menu from the |
000003b0  73 63 72 65 65 6e 2e 20  20 49 66 20 79 6f 75 20  |screen.  If you |
000003c0  63 6c 69 63 6b 20 0a 41  64 6a 75 73 74 2c 20 74  |click .Adjust, t|
000003d0  68 65 20 6d 65 6e 75 20  72 65 6d 61 69 6e 73 20  |he menu remains |
000003e0  6f 6e 20 74 68 65 20 73  63 72 65 65 6e 2e 0a 0a  |on the screen...|
000003f0  0a 25 48 32 25 4c 6f 61  64 69 6e 67 20 64 6f 63  |.%H2%Loading doc|
00000400  75 6d 65 6e 74 73 0a 0a  54 6f 20 6c 6f 61 64 20  |uments..To load |
00000410  61 20 50 69 70 65 44 72  65 61 6d 20 64 6f 63 75  |a PipeDream docu|
00000420  6d 65 6e 74 2c 20 65 69  74 68 65 72 20 64 6f 75  |ment, either dou|
00000430  62 6c 65 2d 63 6c 69 63  6b 20 6f 6e 20 69 74 73  |ble-click on its|
00000440  20 69 63 6f 6e 2c 20 6f  72 20 64 72 61 67 20 0a  | icon, or drag .|
00000450  69 74 73 20 69 63 6f 6e  20 6f 6e 74 6f 20 74 68  |its icon onto th|
00000460  65 20 50 69 70 65 64 72  65 61 6d 20 69 63 6f 6e  |e Pipedream icon|
00000470  20 6f 6e 20 74 68 65 20  69 63 6f 6e 20 62 61 72  | on the icon bar|
00000480  2e 0a 0a 54 6f 20 69 6e  73 65 72 74 20 61 20 66  |...To insert a f|
00000490  69 6c 65 20 61 74 20 74  68 65 20 63 61 72 65 74  |ile at the caret|
000004a0  20 70 6f 73 69 74 69 6f  6e 2c 20 64 72 61 67 20  | position, drag |
000004b0  74 68 65 20 66 69 6c 65  27 73 20 69 63 6f 6e 20  |the file's icon |
000004c0  69 6e 74 6f 20 74 68 65  20 0a 77 69 6e 64 6f 77  |into the .window|
000004d0  2e 0a 0a 0a 25 48 32 25  50 6f 73 69 74 69 6f 6e  |....%H2%Position|
000004e0  69 6e 67 20 74 68 65 20  63 61 72 65 74 0a 0a 43  |ing the caret..C|
000004f0  6c 69 63 6b 20 53 65 6c  65 63 74 20 74 6f 20 70  |lick Select to p|
00000500  6f 73 69 74 69 6f 6e 20  74 68 65 20 63 61 72 65  |osition the care|
00000510  74 20 69 6e 20 74 68 65  20 66 69 72 73 74 20 73  |t in the first s|
00000520  6c 6f 74 20 74 6f 20 74  68 65 20 6c 65 66 74 20  |lot to the left |
00000530  77 68 69 63 68 20 0a 63  61 6e 20 6f 76 65 72 6c  |which .can overl|
00000540  61 70 20 74 68 65 20 73  6c 6f 74 20 75 6e 64 65  |ap the slot unde|
00000550  72 6e 65 61 74 68 20 74  68 65 20 70 6f 69 6e 74  |rneath the point|
00000560  65 72 2e 20 20 0a 0a 43  6c 69 63 6b 20 41 64 6a  |er.  ..Click Adj|
00000570  75 73 74 20 74 6f 20 70  6f 73 69 74 69 6f 6e 20  |ust to position |
00000580  74 68 65 20 63 61 72 65  74 20 69 6e 20 74 68 65  |the caret in the|
00000590  20 73 6c 6f 74 20 75 6e  64 65 72 6e 65 61 74 68  | slot underneath|
000005a0  20 74 68 65 20 70 6f 69  6e 74 65 72 2e 0a 0a 0a  | the pointer....|
000005b0  25 48 32 25 4d 61 72 6b  69 6e 67 20 62 6c 6f 63  |%H2%Marking bloc|
000005c0  6b 73 0a 0a 54 6f 20 6d  61 72 6b 20 61 20 62 6c  |ks..To mark a bl|
000005d0  6f 63 6b 20 77 69 74 68  69 6e 20 6f 6e 65 20 63  |ock within one c|
000005e0  6f 6c 75 6d 6e 2c 20 64  72 61 67 20 73 65 6c 65  |olumn, drag sele|
000005f0  63 74 20 64 6f 77 6e 20  74 68 65 20 63 6f 6c 75  |ct down the colu|
00000600  6d 6e 2e 0a 0a 54 6f 20  6d 61 72 6b 20 6d 75 6c  |mn...To mark mul|
00000610  74 69 70 6c 65 20 63 6f  6c 75 6d 6e 73 20 6f 66  |tiple columns of|
00000620  20 74 65 78 74 2c 20 64  72 61 67 20 41 64 6a 75  | text, drag Adju|
00000630  73 74 20 61 63 72 6f 73  73 20 74 68 65 6d 2e 0a  |st across them..|
00000640  0a 54 6f 20 6d 61 72 6b  20 61 6c 6c 20 74 68 65  |.To mark all the|
00000650  20 72 6f 77 73 20 69 6e  20 61 20 72 61 6e 67 65  | rows in a range|
00000660  20 6f 66 20 63 6f 6c 75  6d 6e 73 2c 20 64 72 61  | of columns, dra|
00000670  67 20 53 65 6c 65 63 74  20 61 63 72 6f 73 73 20  |g Select across |
00000680  74 68 65 20 0a 63 6f 6c  75 6d 6e 20 62 6f 72 64  |the .column bord|
00000690  65 72 73 2e 0a 0a 54 6f  20 6d 61 72 6b 20 61 6c  |ers...To mark al|
000006a0  6c 20 74 68 65 20 63 6f  6c 75 6d 6e 73 20 69 6e  |l the columns in|
000006b0  20 61 20 72 61 6e 67 65  20 6f 66 20 72 6f 77 73  | a range of rows|
000006c0  2c 20 64 72 61 67 20 53  65 6c 65 63 74 20 64 6f  |, drag Select do|
000006d0  77 6e 20 74 68 65 20 72  6f 77 20 0a 62 6f 72 64  |wn the row .bord|
000006e0  65 72 73 2e 0a 0a 54 6f  20 6d 61 72 6b 20 61 6c  |ers...To mark al|
000006f0  6c 20 74 68 65 20 63 6f  6c 75 6d 6e 73 20 69 6e  |l the columns in|
00000700  20 61 20 73 69 6e 67 6c  65 20 72 6f 77 2c 20 64  | a single row, d|
00000710  6f 75 62 6c 65 2d 63 6c  69 63 6b 20 53 65 6c 65  |ouble-click Sele|
00000720  63 74 20 69 6e 20 74 68  65 20 72 6f 77 20 0a 62  |ct in the row .b|
00000730  6f 72 64 65 72 2e 0a 0a  54 6f 20 6d 61 72 6b 20  |order...To mark |
00000740  61 6c 6c 20 74 68 65 20  72 6f 77 73 20 69 6e 20  |all the rows in |
00000750  61 20 63 6f 6c 75 6d 6e  2c 20 64 6f 75 62 6c 65  |a column, double|
00000760  2d 63 6c 69 63 6b 20 53  65 6c 65 63 74 20 69 6e  |-click Select in|
00000770  20 74 68 65 20 63 6f 6c  75 6d 6e 20 0a 62 6f 72  | the column .bor|
00000780  64 65 72 2e 0a 0a 54 6f  20 6d 61 72 6b 20 61 20  |der...To mark a |
00000790  73 69 6e 67 6c 65 20 73  6c 6f 74 2c 20 64 6f 75  |single slot, dou|
000007a0  62 6c 65 2d 63 6c 69 63  6b 20 53 65 6c 65 63 74  |ble-click Select|
000007b0  20 69 6e 20 74 68 65 20  73 6c 6f 74 2e 0a 0a 54  | in the slot...T|
000007c0  6f 20 6d 61 72 6b 20 74  68 65 20 77 68 6f 6c 65  |o mark the whole|
000007d0  20 64 6f 63 75 6d 65 6e  74 2c 20 64 6f 75 62 6c  | document, doubl|
000007e0  65 2d 63 6c 69 63 6b 20  53 65 6c 65 63 74 20 69  |e-click Select i|
000007f0  6e 20 74 68 65 20 74 6f  70 20 6c 65 66 74 2d 68  |n the top left-h|
00000800  61 6e 64 20 0a 63 6f 72  6e 65 72 20 6f 66 20 74  |and .corner of t|
00000810  68 65 20 62 6f 72 64 65  72 2e 0a 0a 54 6f 20 63  |he border...To c|
00000820  6c 65 61 72 20 61 6e 79  20 6d 61 72 6b 65 64 20  |lear any marked |
00000830  62 6c 6f 63 6b 2c 20 64  6f 75 62 6c 65 2d 63 6c  |block, double-cl|
00000840  69 63 6b 20 41 64 6a 75  73 74 20 69 6e 20 74 68  |ick Adjust in th|
00000850  65 20 74 6f 70 20 6c 65  66 74 2d 68 61 6e 64 20  |e top left-hand |
00000860  0a 63 6f 72 6e 65 72 20  6f 66 20 74 68 65 20 62  |.corner of the b|
00000870  6f 72 64 65 72 2e 0a 0a  54 6f 20 61 64 6a 75 73  |order...To adjus|
00000880  74 20 61 20 6d 61 72 6b  65 64 20 62 6c 6f 63 6b  |t a marked block|
00000890  20 61 66 74 65 72 20 6d  61 72 6b 69 6e 67 20 69  | after marking i|
000008a0  74 2c 20 6d 6f 76 65 20  74 68 65 20 70 6f 69 6e  |t, move the poin|
000008b0  74 65 72 20 74 6f 20 74  68 65 20 0a 70 6f 69 6e  |ter to the .poin|
000008c0  74 20 61 74 20 77 68 69  63 68 20 79 6f 75 20 6e  |t at which you n|
000008d0  6f 77 20 77 61 6e 74 20  74 68 65 20 62 6c 6f 63  |ow want the bloc|
000008e0  6b 20 74 6f 20 65 6e 64  20 61 6e 64 20 68 6f 6c  |k to end and hol|
000008f0  64 20 64 6f 77 6e 20 53  68 69 66 74 20 77 68 69  |d down Shift whi|
00000900  6c 73 74 20 0a 63 6c 69  63 6b 69 6e 67 20 53 65  |lst .clicking Se|
00000910  6c 65 63 74 2e 20 20 54  68 65 20 6d 61 72 6b 65  |lect.  The marke|
00000920  64 20 62 6c 6f 63 6b 20  77 69 6c 6c 20 6e 6f 77  |d block will now|
00000930  20 65 6e 64 20 77 68 65  72 65 20 79 6f 75 20 63  | end where you c|
00000940  6c 69 63 6b 65 64 20 0a  53 65 6c 65 63 74 2e 20  |licked .Select. |
00000950  20 54 68 65 20 73 74 61  72 74 69 6e 67 20 70 6f  | The starting po|
00000960  69 6e 74 20 77 69 6c 6c  20 72 65 6d 61 69 6e 20  |int will remain |
00000970  74 68 65 20 73 61 6d 65  2e 0a 0a 25 48 32 25 45  |the same...%H2%E|
00000980  6e 74 65 72 69 6e 67 20  73 6c 6f 74 20 72 65 66  |ntering slot ref|
00000990  65 72 65 6e 63 65 73 20  69 6e 74 6f 20 74 68 65  |erences into the|
000009a0  20 65 64 69 74 69 6e 67  20 6c 69 6e 65 0a 0a 54  | editing line..T|
000009b0  6f 20 65 6e 74 65 72 20  61 20 73 6c 6f 74 20 72  |o enter a slot r|
000009c0  65 66 65 72 65 6e 63 65  20 69 6e 74 6f 20 74 68  |eference into th|
000009d0  65 20 65 64 69 74 69 6e  67 20 6c 69 6e 65 20 77  |e editing line w|
000009e0  68 69 6c 73 74 20 79 6f  75 20 61 72 65 20 65 64  |hilst you are ed|
000009f0  69 74 69 6e 67 20 0a 61  6e 20 65 78 70 72 65 73  |iting .an expres|
00000a00  73 69 6f 6e 2c 20 63 6c  69 63 6b 20 53 65 6c 65  |sion, click Sele|
00000a10  63 74 20 6f 72 20 41 64  6a 75 73 74 20 69 6e 20  |ct or Adjust in |
00000a20  74 68 65 20 73 6c 6f 74  2e 20 20 54 68 65 20 73  |the slot.  The s|
00000a30  6c 6f 74 20 63 61 6e 20  62 65 20 69 6e 20 0a 74  |lot can be in .t|
00000a40  68 65 20 63 75 72 72 65  6e 74 20 77 69 6e 64 6f  |he current windo|
00000a50  77 20 6f 72 20 69 6e 20  61 6e 6f 74 68 65 72 2c  |w or in another,|
00000a60  20 69 6e 20 77 68 69 63  68 20 63 61 73 65 20 79  | in which case y|
00000a70  6f 75 20 77 69 6c 6c 20  69 6e 73 65 72 74 20 61  |ou will insert a|
00000a80  6e 20 0a 65 78 74 65 72  6e 61 6c 20 72 65 66 65  |n .external refe|
00000a90  72 65 6e 63 65 2e 0a 0a  25 48 32 25 53 63 72 6f  |rence...%H2%Scro|
00000aa0  6c 6c 69 6e 67 20 74 68  65 20 77 69 6e 64 6f 77  |lling the window|
00000ab0  0a 0a 50 6f 73 69 74 69  6f 6e 20 74 68 65 20 70  |..Position the p|
00000ac0  6f 69 6e 74 65 72 20 6f  6e 20 74 68 65 20 73 63  |ointer on the sc|
00000ad0  72 6f 6c 6c 20 61 72 72  6f 77 20 61 6e 64 20 63  |roll arrow and c|
00000ae0  6c 69 63 6b 20 53 65 6c  65 63 74 20 74 6f 20 73  |lick Select to s|
00000af0  63 72 6f 6c 6c 20 6f 6e  65 20 0a 6c 69 6e 65 20  |croll one .line |
00000b00  69 6e 20 74 68 65 20 64  69 72 65 63 74 69 6f 6e  |in the direction|
00000b10  20 6f 66 20 74 68 65 20  61 72 72 6f 77 2e 20 20  | of the arrow.  |
00000b20  48 6f 6c 64 20 64 6f 77  6e 20 53 65 6c 65 63 74  |Hold down Select|
00000b30  20 74 6f 20 63 6f 6e 74  69 6e 75 65 20 0a 73 63  | to continue .sc|
00000b40  72 6f 6c 6c 69 6e 67 2e  20 20 43 6c 69 63 6b 20  |rolling.  Click |
00000b50  41 64 6a 75 73 74 20 74  6f 20 73 63 72 6f 6c 6c  |Adjust to scroll|
00000b60  20 69 6e 20 74 68 65 20  6f 74 68 65 72 20 64 69  | in the other di|
00000b70  72 65 63 74 69 6f 6e 2e  20 20 54 68 65 20 63 61  |rection.  The ca|
00000b80  72 65 74 20 0a 61 6c 77  61 79 73 20 72 65 6d 61  |ret .always rema|
00000b90  69 6e 73 20 77 69 74 68  69 6e 20 74 68 65 20 50  |ins within the P|
00000ba0  69 70 65 44 72 65 61 6d  20 77 69 6e 64 6f 77 2c  |ipeDream window,|
00000bb0  20 73 74 61 79 69 6e 67  20 61 73 20 6e 65 61 72  | staying as near|
00000bc0  20 61 73 20 70 6f 73 73  69 62 6c 65 20 0a 74 6f  | as possible .to|
00000bd0  20 69 74 73 20 6f 72 69  67 69 6e 61 6c 20 70 6f  | its original po|
00000be0  73 69 74 69 6f 6e 2e 0a  0a 50 6f 73 69 74 69 6f  |sition...Positio|
00000bf0  6e 20 74 68 65 20 70 6f  69 6e 74 65 72 20 6f 6e  |n the pointer on|
00000c00  20 74 68 65 20 64 61 72  6b 65 72 20 70 61 72 74  | the darker part|
00000c10  20 6f 66 20 74 68 65 20  73 63 72 6f 6c 6c 20 62  | of the scroll b|
00000c20  61 72 20 28 61 62 6f 76  65 20 74 68 65 20 0a 73  |ar (above the .s|
00000c30  6c 69 64 65 72 20 74 6f  20 73 63 72 6f 6c 6c 20  |lider to scroll |
00000c40  75 70 2c 20 62 65 6c 6f  77 20 74 68 65 20 73 6c  |up, below the sl|
00000c50  69 64 65 72 20 74 6f 20  73 63 72 6f 6c 6c 20 64  |ider to scroll d|
00000c60  6f 77 6e 29 20 61 6e 64  20 63 6c 69 63 6b 20 53  |own) and click S|
00000c70  65 6c 65 63 74 2e 20 20  0a 54 68 65 20 6e 65 78  |elect.  .The nex|
00000c80  74 20 77 69 6e 64 6f 77  66 75 6c 20 6f 66 20 74  |t windowful of t|
00000c90  68 65 20 64 6f 63 75 6d  65 6e 74 20 77 69 6c 6c  |he document will|
00000ca0  20 61 70 70 65 61 72 2e  20 20 43 6c 69 63 6b 20  | appear.  Click |
00000cb0  41 64 6a 75 73 74 20 74  6f 20 73 63 72 6f 6c 6c  |Adjust to scroll|
00000cc0  20 0a 62 61 63 6b 20 74  68 65 20 6f 74 68 65 72  | .back the other|
00000cd0  20 77 61 79 2e 20 20 54  68 65 20 63 61 72 65 74  | way.  The caret|
00000ce0  20 61 6c 77 61 79 73 20  72 65 6d 61 69 6e 73 20  | always remains |
00000cf0  77 69 74 68 69 6e 20 74  68 65 20 50 69 70 65 44  |within the PipeD|
00000d00  72 65 61 6d 20 0a 77 69  6e 64 6f 77 2c 20 6d 6f  |ream .window, mo|
00000d10  76 69 6e 67 2c 20 69 66  20 6e 65 63 65 73 73 61  |ving, if necessa|
00000d20  72 79 2c 20 74 6f 20 74  68 65 20 70 6f 69 6e 74  |ry, to the point|
00000d30  20 6e 65 61 72 65 73 74  20 74 6f 20 69 74 73 20  | nearest to its |
00000d40  70 6f 73 69 74 69 6f 6e  20 0a 62 65 66 6f 72 65  |position .before|
00000d50  20 73 63 72 6f 6c 6c 69  6e 67 2e 0a 0a 25 50 30  | scrolling...%P0|
00000d60  25 0a 25 43 25 25 48 32  25 45 78 70 72 65 73 73  |%.%C%%H2%Express|
00000d70  69 6f 6e 20 6f 70 65 72  61 74 6f 72 73 0a 0a 25  |ion operators..%|
00000d80  4c 25 43 6f 6e 64 69 74  69 6f 6e 20 6f 70 65 72  |L%Condition oper|
00000d90  61 74 6f 72 73 0a 0a 25  4c 25 21 0a 25 4c 25 26  |ators..%L%!.%L%&|
00000da0  0a 25 4c 25 7c 0a 25 4c  25 3c 0a 25 4c 25 3c 3d  |.%L%|.%L%<.%L%<=|
00000db0  0a 25 4c 25 3c 3e 0a 25  4c 25 3d 0a 25 4c 25 3e  |.%L%<>.%L%=.%L%>|
00000dc0  0a 25 4c 25 3e 3d 0a 0a  25 43 25 25 48 32 25 41  |.%L%>=..%C%%H2%A|
00000dd0  72 69 74 68 6d 65 74 69  63 20 6f 70 65 72 61 74  |rithmetic operat|
00000de0  6f 72 73 0a 0a 25 4c 25  5e 0a 25 4c 25 2a 0a 25  |ors..%L%^.%L%*.%|
00000df0  4c 25 2b 0a 25 4c 25 2d  0a 25 4c 25 2f 0a 0a 25  |L%+.%L%-.%L%/..%|
00000e00  43 25 25 48 32 25 53 70  72 65 61 64 73 68 65 65  |C%%H2%Spreadshee|
00000e10  74 20 66 75 6e 63 74 69  6f 6e 73 0a 0a 25 4c 25  |t functions..%L%|
00000e20  61 62 73 28 6e 29 0a 25  4c 25 61 63 73 28 6e 29  |abs(n).%L%acs(n)|
00000e30  0a 25 4c 25 61 73 6e 28  6e 29 0a 25 4c 25 61 74  |.%L%asn(n).%L%at|
00000e40  6e 28 6e 29 0a 25 4c 25  61 74 6e 32 28 78 2c 79  |n(n).%L%atn2(x,y|
00000e50  29 20 0a 25 4c 25 61 76  67 28 6c 69 73 74 29 0a  |) .%L%avg(list).|
00000e60  25 4c 25 63 68 6f 6f 73  65 28 6e 2c 20 6c 69 73  |%L%choose(n, lis|
00000e70  74 29 0a 25 4c 25 63 6f  6c 0a 25 4c 25 63 6f 6c  |t).%L%col.%L%col|
00000e80  28 72 65 66 29 0a 25 4c  25 63 6f 73 28 6e 29 0a  |(ref).%L%cos(n).|
00000e90  25 4c 25 63 6f 75 6e 74  28 6c 69 73 74 29 20 0a  |%L%count(list) .|
00000ea0  25 4c 25 63 74 65 72 6d  28 69 6e 74 2c 20 66 76  |%L%cterm(int, fv|
00000eb0  2c 20 70 76 29 0a 25 4c  25 64 61 74 65 0a 25 4c  |, pv).%L%date.%L|
00000ec0  25 64 61 76 67 28 72 61  6e 67 65 2c 20 63 6f 6e  |%davg(range, con|
00000ed0  64 29 0a 25 4c 25 64 61  79 28 64 61 74 65 29 0a  |d).%L%day(date).|
00000ee0  25 4c 25 64 63 6f 75 6e  74 28 72 61 6e 67 65 2c  |%L%dcount(range,|
00000ef0  20 63 6f 6e 64 29 0a 25  4c 25 64 63 6f 75 6e 74  | cond).%L%dcount|
00000f00  61 28 72 61 6e 67 65 2c  20 63 6f 6e 64 29 0a 25  |a(range, cond).%|
00000f10  4c 25 64 64 62 28 63 2c  73 2c 6c 2c 70 29 0a 25  |L%ddb(c,s,l,p).%|
00000f20  4c 25 64 65 67 28 6e 29  0a 25 4c 25 64 6d 61 78  |L%deg(n).%L%dmax|
00000f30  28 72 61 6e 67 65 2c 20  63 6f 6e 64 29 0a 25 4c  |(range, cond).%L|
00000f40  25 64 6d 69 6e 28 72 61  6e 67 65 2c 20 63 6f 6e  |%dmin(range, con|
00000f50  64 29 0a 25 4c 25 64 73  74 64 28 72 61 6e 67 65  |d).%L%dstd(range|
00000f60  2c 20 63 6f 6e 64 29 0a  25 4c 25 64 73 75 6d 28  |, cond).%L%dsum(|
00000f70  72 61 6e 67 65 2c 20 63  6f 6e 64 29 0a 25 4c 25  |range, cond).%L%|
00000f80  64 76 61 72 28 72 61 6e  67 65 2c 20 63 6f 6e 64  |dvar(range, cond|
00000f90  29 0a 25 4c 25 65 78 70  28 6e 29 0a 25 4c 25 66  |).%L%exp(n).%L%f|
00000fa0  76 28 70 6d 74 2c 20 69  6e 74 2c 20 74 65 72 6d  |v(pmt, int, term|
00000fb0  29 0a 25 4c 25 68 6c 6f  6f 6b 75 70 28 6b 65 79  |).%L%hlookup(key|
00000fc0  2c 72 61 6e 67 65 2c 6f  66 66 29 0a 25 4c 25 69  |,range,off).%L%i|
00000fd0  66 28 63 6f 6e 64 2c 20  65 31 2c 20 65 32 29 0a  |f(cond, e1, e2).|
00000fe0  25 4c 25 69 6e 64 65 78  28 63 2c 20 72 29 0a 25  |%L%index(c, r).%|
00000ff0  4c 25 69 6e 74 28 6e 29  0a 25 4c 25 69 72 72 28  |L%int(n).%L%irr(|
00001000  67 75 65 73 73 2c 20 72  61 6e 67 65 29 0a 25 4c  |guess, range).%L|
00001010  25 6c 6e 28 6e 29 0a 25  4c 25 6c 6f 67 28 6e 29  |%ln(n).%L%log(n)|
00001020  0a 25 4c 25 6c 6f 6f 6b  75 70 28 6b 65 79 2c 72  |.%L%lookup(key,r|
00001030  31 2c 72 32 29 0a 25 4c  25 6c 6f 6f 70 63 0a 25  |1,r2).%L%loopc.%|
00001040  4c 25 6d 61 78 28 6c 69  73 74 29 0a 25 4c 25 6d  |L%max(list).%L%m|
00001050  69 6e 28 6c 69 73 74 29  0a 25 4c 25 6d 6f 64 28  |in(list).%L%mod(|
00001060  78 2c 79 29 0a 25 4c 25  6d 6f 6e 74 68 28 64 61  |x,y).%L%month(da|
00001070  74 65 29 0a 25 4c 25 6d  6f 6e 74 68 64 61 79 73  |te).%L%monthdays|
00001080  28 64 61 74 65 29 0a 25  4c 25 6e 70 76 28 69 6e  |(date).%L%npv(in|
00001090  74 65 72 65 73 74 2c 20  72 61 6e 67 65 29 0a 25  |terest, range).%|
000010a0  4c 25 70 69 0a 25 4c 25  70 6d 74 28 70 63 70 6c  |L%pi.%L%pmt(pcpl|
000010b0  2c 69 6e 74 2c 74 65 72  6d 29 0a 25 4c 25 70 76  |,int,term).%L%pv|
000010c0  28 70 6d 74 2c 69 6e 74  2c 74 65 72 6d 29 0a 25  |(pmt,int,term).%|
000010d0  4c 25 72 61 64 28 6e 29  0a 25 4c 25 72 61 6e 64  |L%rad(n).%L%rand|
000010e0  0a 25 4c 25 72 61 74 65  28 66 76 2c 70 66 2c 74  |.%L%rate(fv,pf,t|
000010f0  65 72 6d 29 0a 25 4c 25  72 65 61 64 28 66 69 6c  |erm).%L%read(fil|
00001100  65 2c 63 6f 6c 2c 72 6f  77 29 0a 25 4c 25 72 6f  |e,col,row).%L%ro|
00001110  75 6e 64 28 6e 2c 70 29  0a 25 4c 25 72 6f 77 0a  |und(n,p).%L%row.|
00001120  25 4c 25 73 67 6e 28 6e  29 0a 25 4c 25 73 69 6e  |%L%sgn(n).%L%sin|
00001130  28 6e 29 0a 25 4c 25 73  6c 6e 28 63 6f 73 74 2c  |(n).%L%sln(cost,|
00001140  73 61 6c 76 2c 6c 69 66  65 29 0a 25 4c 25 73 71  |salv,life).%L%sq|
00001150  72 28 6e 29 0a 25 4c 25  73 74 64 28 6c 69 73 74  |r(n).%L%std(list|
00001160  29 0a 25 4c 25 73 75 6d  28 6c 69 73 74 29 0a 25  |).%L%sum(list).%|
00001170  4c 25 73 79 64 28 63 2c  73 2c 6c 2c 70 29 0a 25  |L%syd(c,s,l,p).%|
00001180  4c 25 74 61 6e 28 6e 29  0a 25 4c 25 74 65 72 6d  |L%tan(n).%L%term|
00001190  28 70 6d 74 2c 69 6e 74  2c 66 76 29 0a 25 4c 25  |(pmt,int,fv).%L%|
000011a0  76 61 72 28 6c 69 73 74  29 20 20 0a 25 4c 25 76  |var(list)  .%L%v|
000011b0  6c 6f 6f 6b 75 70 28 6b  65 79 2c 72 61 6e 67 65  |lookup(key,range|
000011c0  2c 6f 66 66 29 0a 25 4c  25 77 72 69 74 65 28 66  |,off).%L%write(f|
000011d0  69 6c 65 2c 63 6f 6c 2c  72 6f 77 2c 65 78 70 29  |ile,col,row,exp)|
000011e0  0a 25 4c 25 79 65 61 72  28 64 61 74 65 29 20 0a  |.%L%year(date) .|
000011f0  25 43 4f 3a 42 2c 31 32  2c 34 38 25 0a 0a 0a 0a  |%CO:B,12,48%....|
00001200  0a 0a 0a 0a 0a 0a 0a 0a  0a 0a 0a 0a 0a 0a 0a 0a  |................|
*
00001260  0a 0a 0a 0a 0a 0a 0a 0a  25 4c 25 6e 6f 74 0a 25  |........%L%not.%|
00001270  4c 25 62 69 6e 61 72 79  20 61 6e 64 20 0a 25 4c  |L%binary and .%L|
00001280  25 62 69 6e 61 72 79 20  6f 72 0a 25 4c 25 6c 65  |%binary or.%L%le|
00001290  73 73 20 74 68 61 6e 0a  25 4c 25 6c 65 73 73 20  |ss than.%L%less |
000012a0  74 68 61 6e 20 6f 72 20  65 71 75 61 6c 0a 25 4c  |than or equal.%L|
000012b0  25 6e 6f 74 20 65 71 75  61 6c 0a 25 4c 25 65 71  |%not equal.%L%eq|
000012c0  75 61 6c 0a 25 4c 25 67  72 65 61 74 65 72 20 74  |ual.%L%greater t|
000012d0  68 61 6e 0a 25 4c 25 67  72 65 61 74 65 72 20 74  |han.%L%greater t|
000012e0  68 61 6e 20 6f 72 20 65  71 75 61 6c 0a 0a 0a 0a  |han or equal....|
000012f0  25 4c 25 74 6f 20 74 68  65 20 70 6f 77 65 72 20  |%L%to the power |
00001300  6f 66 0a 25 4c 25 6d 75  6c 74 69 70 6c 79 0a 25  |of.%L%multiply.%|
00001310  4c 25 70 6c 75 73 0a 25  4c 25 6d 69 6e 75 73 0a  |L%plus.%L%minus.|
00001320  25 4c 25 64 69 76 69 64  65 0a 0a 0a 0a 25 4c 25  |%L%divide....%L%|
00001330  41 62 73 6f 6c 75 74 65  20 76 61 6c 75 65 20 6f  |Absolute value o|
00001340  66 20 6e 0a 25 4c 25 41  72 63 20 63 6f 73 69 6e  |f n.%L%Arc cosin|
00001350  65 20 6f 66 20 6e 0a 25  4c 25 41 72 63 20 73 69  |e of n.%L%Arc si|
00001360  6e 65 20 6f 66 20 6e 0a  25 4c 25 41 72 63 20 74  |ne of n.%L%Arc t|
00001370  61 6e 67 65 6e 74 20 6f  66 20 6e 0a 25 4c 25 41  |angent of n.%L%A|
00001380  72 63 20 74 61 6e 67 65  6e 74 20 6f 66 20 78 20  |rc tangent of x |
00001390  61 6e 64 20 79 0a 25 4c  25 61 76 65 72 61 67 65  |and y.%L%average|
000013a0  20 6f 66 20 76 61 6c 75  65 73 20 69 6e 20 6c 69  | of values in li|
000013b0  73 74 0a 25 4c 25 6e 74  68 20 76 61 6c 75 65 20  |st.%L%nth value |
000013c0  69 6e 20 6c 69 73 74 0a  25 4c 25 6e 75 6d 62 65  |in list.%L%numbe|
000013d0  72 20 6f 66 20 63 6f 6c  75 6d 6e 20 63 6f 6e 74  |r of column cont|
000013e0  61 69 6e 69 6e 67 20 65  78 70 72 65 73 73 69 6f  |aining expressio|
000013f0  6e 0a 25 4c 25 6e 75 6d  62 65 72 20 6f 66 20 63  |n.%L%number of c|
00001400  6f 6c 75 6d 6e 20 63 6f  6e 74 61 69 6e 69 6e 67  |olumn containing|
00001410  20 73 6c 6f 74 20 72 65  66 65 72 65 6e 63 65 0a  | slot reference.|
00001420  25 4c 25 63 6f 73 69 6e  65 20 6f 66 20 6e 0a 25  |%L%cosine of n.%|
00001430  4c 25 6e 75 6d 62 65 72  20 6f 66 20 6e 75 6d 65  |L%number of nume|
00001440  72 69 63 20 73 6c 6f 74  73 20 69 6e 20 6c 69 73  |ric slots in lis|
00001450  74 0a 25 4c 25 6e 75 6d  62 65 72 20 6f 66 20 63  |t.%L%number of c|
00001460  6f 6d 70 6f 75 6e 64 69  6e 67 20 70 65 72 69 6f  |ompounding perio|
00001470  64 73 20 66 6f 72 20 69  6e 76 65 73 74 6d 65 6e  |ds for investmen|
00001480  74 0a 25 4c 25 72 65 74  75 72 6e 20 74 68 65 20  |t.%L%return the |
00001490  63 75 72 72 65 6e 74 20  64 61 74 65 0a 25 4c 25  |current date.%L%|
000014a0  61 76 65 72 61 67 65 20  6f 66 20 73 6c 6f 74 73  |average of slots|
000014b0  20 69 6e 20 72 61 6e 67  65 20 77 68 69 63 68 20  | in range which |
000014c0  73 61 74 69 73 66 79 20  63 6f 6e 64 69 74 69 6f  |satisfy conditio|
000014d0  6e 0a 25 4c 25 64 61 79  20 6e 75 6d 62 65 72 20  |n.%L%day number |
000014e0  6f 66 20 64 61 74 65 0a  25 4c 25 63 6f 75 6e 74  |of date.%L%count|
000014f0  20 6f 66 20 6e 75 6d 65  72 69 63 20 73 6c 6f 74  | of numeric slot|
00001500  73 20 69 6e 20 72 61 6e  67 65 20 77 68 69 63 68  |s in range which|
00001510  20 73 61 74 69 73 66 79  20 63 6f 6e 64 69 74 69  | satisfy conditi|
00001520  6f 6e 0a 25 4c 25 63 6f  75 6e 74 20 6f 66 20 61  |on.%L%count of a|
00001530  6c 6c 20 73 6c 6f 74 73  20 69 6e 20 72 61 6e 67  |ll slots in rang|
00001540  65 20 77 68 69 63 68 20  73 61 74 69 73 66 79 20  |e which satisfy |
00001550  63 6f 6e 64 69 74 69 6f  6e 0a 25 4c 25 64 65 70  |condition.%L%dep|
00001560  72 65 63 69 61 74 69 6f  6e 20 61 6c 6c 6f 77 61  |reciation allowa|
00001570  6e 63 65 20 6f 66 20 61  73 73 65 74 0a 25 4c 25  |nce of asset.%L%|
00001580  6e 75 6d 62 65 72 20 6f  66 20 64 65 67 72 65 65  |number of degree|
00001590  73 20 69 6e 20 6e 20 72  61 64 69 61 6e 73 0a 25  |s in n radians.%|
000015a0  4c 25 6d 61 78 69 6d 75  6d 20 6f 66 20 73 6c 6f  |L%maximum of slo|
000015b0  74 73 20 69 6e 20 72 61  6e 67 65 20 77 68 69 63  |ts in range whic|
000015c0  68 20 73 61 74 69 73 66  79 20 63 6f 6e 64 69 74  |h satisfy condit|
000015d0  69 6f 6e 0a 25 4c 25 6d  69 6e 69 6d 75 6d 20 6f  |ion.%L%minimum o|
000015e0  66 20 73 6c 6f 74 73 20  69 6e 20 72 61 6e 67 65  |f slots in range|
000015f0  20 77 68 69 63 68 20 73  61 74 69 73 66 79 20 63  | which satisfy c|
00001600  6f 6e 64 69 74 69 6f 6e  0a 25 4c 25 73 74 61 6e  |ondition.%L%stan|
00001610  64 61 72 64 20 64 65 76  69 61 74 69 6f 6e 20 6f  |dard deviation o|
00001620  66 20 73 6c 6f 74 73 20  69 6e 20 72 61 6e 67 65  |f slots in range|
00001630  20 77 68 69 63 68 20 73  61 74 69 73 66 79 20 63  | which satisfy c|
00001640  6f 6e 64 69 74 69 6f 6e  0a 25 4c 25 73 75 6d 20  |ondition.%L%sum |
00001650  6f 66 20 73 6c 6f 74 73  20 69 6e 20 72 61 6e 67  |of slots in rang|
00001660  65 20 77 68 69 63 68 20  73 61 74 69 73 66 79 20  |e which satisfy |
00001670  63 6f 6e 64 69 74 69 6f  6e 0a 25 4c 25 76 61 72  |condition.%L%var|
00001680  69 61 6e 63 65 20 6f 66  20 73 6c 6f 74 73 20 69  |iance of slots i|
00001690  6e 20 72 61 6e 67 65 20  77 68 69 63 68 20 73 61  |n range which sa|
000016a0  74 69 73 66 79 20 63 6f  6e 64 69 74 69 6f 6e 0a  |tisfy condition.|
000016b0  25 4c 25 65 20 74 6f 20  74 68 65 20 70 6f 77 65  |%L%e to the powe|
000016c0  72 20 6f 66 20 6e 0a 25  4c 25 66 75 74 75 72 65  |r of n.%L%future|
000016d0  20 76 61 6c 75 65 20 6f  66 20 69 6e 76 65 73 74  | value of invest|
000016e0  6d 65 6e 74 0a 25 4c 25  68 6f 72 69 7a 6f 6e 74  |ment.%L%horizont|
000016f0  61 6c 20 6c 6f 6f 6b 75  70 20 6f 66 20 6b 65 79  |al lookup of key|
00001700  20 69 6e 20 72 61 6e 67  65 20 77 69 74 68 20 6f  | in range with o|
00001710  66 66 73 65 74 0a 25 4c  25 69 66 20 63 6f 6e 64  |ffset.%L%if cond|
00001720  20 69 73 20 74 72 75 65  20 72 65 74 75 72 6e 20  | is true return |
00001730  65 31 20 65 6c 73 65 20  72 65 74 75 72 6e 20 65  |e1 else return e|
00001740  32 0a 25 4c 25 76 61 6c  75 65 20 6f 66 20 73 6c  |2.%L%value of sl|
00001750  6f 74 20 69 6e 20 63 6f  6c 75 6d 6e 20 63 20 61  |ot in column c a|
00001760  6e 64 20 72 6f 77 20 72  0a 25 4c 25 69 6e 74 65  |nd row r.%L%inte|
00001770  67 65 72 20 70 61 72 74  20 6f 66 20 6e 0a 25 4c  |ger part of n.%L|
00001780  25 69 6e 74 65 72 6e 61  6c 20 72 61 74 65 20 6f  |%internal rate o|
00001790  66 20 72 65 74 75 72 6e  0a 25 4c 25 6e 61 74 75  |f return.%L%natu|
000017a0  72 61 6c 20 6c 6f 67 20  6f 66 20 6e 0a 25 4c 25  |ral log of n.%L%|
000017b0  62 61 73 65 20 31 30 20  6c 6f 67 20 6f 66 20 6e  |base 10 log of n|
000017c0  0a 25 4c 25 6c 6f 6f 6b  75 70 20 6b 65 79 20 69  |.%L%lookup key i|
000017d0  6e 20 72 61 6e 67 65 20  31 3b 20 72 65 74 75 72  |n range 1; retur|
000017e0  6e 20 63 6f 72 72 65 73  70 6f 6e 64 69 6e 67 20  |n corresponding |
000017f0  76 61 6c 75 65 20 69 6e  20 72 61 6e 67 65 20 32  |value in range 2|
00001800  0a 25 4c 25 63 75 72 72  65 6e 74 20 6c 6f 6f 70  |.%L%current loop|
00001810  20 6e 75 6d 62 65 72 20  69 6e 20 69 74 65 72 61  | number in itera|
00001820  74 69 76 65 20 70 72 6f  63 65 73 73 0a 25 4c 25  |tive process.%L%|
00001830  6d 61 78 69 6d 75 6d 20  76 61 6c 75 65 20 6f 66  |maximum value of|
00001840  20 6c 69 73 74 0a 25 4c  25 6d 69 6e 69 6d 75 6d  | list.%L%minimum|
00001850  20 76 61 6c 75 65 20 6f  66 20 6c 69 73 74 0a 25  | value of list.%|
00001860  4c 25 78 20 6d 6f 64 75  6c 6f 20 79 0a 25 4c 25  |L%x modulo y.%L%|
00001870  6d 6f 6e 74 68 20 6e 75  6d 62 65 72 20 6f 66 20  |month number of |
00001880  64 61 74 65 0a 25 4c 25  6e 75 6d 62 65 72 20 6f  |date.%L%number o|
00001890  66 20 64 61 79 73 20 69  6e 20 74 68 65 20 6d 6f  |f days in the mo|
000018a0  6e 74 68 20 6f 66 20 64  61 74 65 0a 25 4c 25 6e  |nth of date.%L%n|
000018b0  65 74 20 70 72 65 73 65  6e 74 20 76 61 6c 75 65  |et present value|
000018c0  20 6f 66 20 66 75 74 75  72 65 20 63 61 73 68 20  | of future cash |
000018d0  66 6c 6f 77 0a 25 4c 25  33 2e 31 34 31 35 39 32  |flow.%L%3.141592|
000018e0  36 35 33 35 38 39 38 0a  25 4c 25 70 61 79 6d 65  |6535898.%L%payme|
000018f0  6e 74 20 6f 6e 20 61 20  6c 6f 61 6e 0a 25 4c 25  |nt on a loan.%L%|
00001900  70 72 65 73 65 6e 74 20  76 61 6c 75 65 20 6f 66  |present value of|
00001910  20 73 65 72 69 65 73 20  6f 66 20 70 61 79 6d 65  | series of payme|
00001920  6e 74 73 0a 25 4c 25 6e  75 6d 62 65 72 20 6f 66  |nts.%L%number of|
00001930  20 72 61 64 69 61 6e 73  20 69 6e 20 6e 20 64 65  | radians in n de|
00001940  67 72 65 65 73 0a 25 4c  25 72 61 6e 64 6f 6d 20  |grees.%L%random |
00001950  6e 75 6d 62 65 72 20 62  65 74 77 65 65 6e 20 30  |number between 0|
00001960  20 61 6e 64 20 31 0a 25  4c 25 70 65 72 69 6f 64  | and 1.%L%period|
00001970  69 63 20 69 6e 74 65 72  65 73 74 20 66 6f 72 20  |ic interest for |
00001980  69 6e 76 65 73 74 6d 65  6e 74 0a 25 4c 25 72 65  |investment.%L%re|
00001990  61 64 20 65 6e 74 72 79  20 66 72 6f 6d 20 6c 69  |ad entry from li|
000019a0  6e 6b 69 6e 67 20 66 69  6c 65 0a 25 4c 25 72 6f  |nking file.%L%ro|
000019b0  75 6e 64 20 6e 20 74 6f  20 70 20 70 6c 61 63 65  |und n to p place|
000019c0  73 0a 25 4c 25 6e 75 6d  62 65 72 20 6f 66 20 72  |s.%L%number of r|
000019d0  6f 77 20 63 6f 6e 74 61  69 6e 69 6e 67 20 65 78  |ow containing ex|
000019e0  70 72 65 73 73 69 6f 6e  0a 25 4c 25 73 69 67 6e  |pression.%L%sign|
000019f0  20 6f 66 20 6e 0a 25 4c  25 73 69 6e 65 20 6f 66  | of n.%L%sine of|
00001a00  20 6e 0a 25 4c 25 73 74  72 61 69 67 68 74 20 6c  | n.%L%straight l|
00001a10  69 6e 65 20 64 65 70 72  65 63 69 61 74 69 6f 6e  |ine depreciation|
00001a20  0a 25 4c 25 73 71 75 61  72 65 20 72 6f 6f 74 20  |.%L%square root |
00001a30  6f 66 20 6e 0a 25 4c 25  73 74 61 6e 64 61 72 64  |of n.%L%standard|
00001a40  20 64 65 76 69 61 74 69  6f 6e 20 6f 66 20 76 61  | deviation of va|
00001a50  6c 75 65 73 20 69 6e 20  6c 69 73 74 0a 25 4c 25  |lues in list.%L%|
00001a60  73 75 6d 20 6f 66 20 76  61 6c 75 65 73 20 69 6e  |sum of values in|
00001a70  20 6c 69 73 74 0a 25 4c  25 73 75 6d 20 6f 66 20  | list.%L%sum of |
00001a80  79 65 61 72 27 73 20 64  69 67 69 74 73 20 64 65  |year's digits de|
00001a90  70 72 65 63 69 61 74 69  6f 6e 0a 25 4c 25 74 61  |preciation.%L%ta|
00001aa0  6e 67 65 6e 74 20 6f 66  20 6e 0a 25 4c 25 6e 75  |ngent of n.%L%nu|
00001ab0  6d 62 65 72 20 6f 66 20  70 61 79 6d 65 6e 74 20  |mber of payment |
00001ac0  70 65 72 69 6f 64 73 20  6f 66 20 69 6e 76 65 73  |periods of inves|
00001ad0  74 6d 65 6e 74 0a 25 4c  25 76 61 72 69 61 6e 63  |tment.%L%varianc|
00001ae0  65 20 6f 66 20 76 61 6c  75 65 73 20 69 6e 20 6c  |e of values in l|
00001af0  69 73 74 0a 25 4c 25 76  65 72 74 69 63 61 6c 20  |ist.%L%vertical |
00001b00  6c 6f 6f 6b 75 70 20 6f  66 20 6b 65 79 20 69 6e  |lookup of key in|
00001b10  20 72 61 6e 67 65 20 77  69 74 68 20 6f 66 66 73  | range with offs|
00001b20  65 74 0a 25 4c 25 77 72  69 74 65 20 65 78 70 72  |et.%L%write expr|
00001b30  65 73 73 69 6f 6e 20 74  6f 20 6c 69 6e 6b 69 6e  |ession to linkin|
00001b40  67 20 66 69 6c 65 0a 25  4c 25 79 65 61 72 20 70  |g file.%L%year p|
00001b50  61 72 74 20 6f 66 20 64  61 74 65 0a 25 43 4f 3a  |art of date.%CO:|
00001b60  43 2c 31 32 2c 33 36 25  25 43 4f 3a 44 2c 31 32  |C,12,36%%CO:D,12|
00001b70  2c 32 34 25 25 43 4f 3a  45 2c 31 32 2c 31 32 25  |,24%%CO:E,12,12%|
00001b80  25 43 4f 3a 46 2c 31 32  2c 30 25                 |%CO:F,12,0%|
00001b8b

Our privacy policy is here.
Last updated: 01 May 2025, 21:49 UTC
Website designed by .