Functions/DataBase

Home » Archimedes archive » Zipped Apps » PipeDream » Functions/DataBase

Functions/DataBase

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 » Zipped Apps » PipeDream
Filename:	Functions/DataBase
Read OK:	✔
File size:	06DE bytes
Load address:	0000
Exec address:	0000

Duplicates

There is 1 duplicate copy of this file in the archive:

Archimedes archive » Zipped Apps » PipeDream » Functions/DataBase
Archimedes archive » Apps » PipeDream 4 (1991) (Colton Software) (Examples Disc).adf » Functions/DataBase

%OP%LP*
%OP%TM4
%OP%BM4
%OP%LM5
%OP%FX
%OP%FY
%OP%FS
%OP%WC2,1750,360,1252,0,1,0,0
%OP%VS3.40R (11-Oct-90), Mrjc, R9200 7500 3900 8299 
%CO:A,10,88%%C%%H1%Database Functions Examples









%C%Function
Davg
Dcount
Dcounta
Dmax
Dmin
Dstd
Dstdp
Dsum
Dvar
Dvarp
%CO:B,9,16%


%V%%C%8
%V%%C%7
%V%%C%2
%V%%C%11
%V%%C%6


%C%Input 1
%C%b4e8
%C%b4e8
%C%b4e8
%C%b4e8
%C%b4e8
%C%b4e8
%C%b4e8
%C%b4e8
%C%b4e8
%C%b4e8
%CO:C,9,0%


%V%%C%5
%V%%C%12
%V%%C%7
%V%%C%9
%V%%C%17


%C%Input 2
%C%b4e8<11
%C%b4e8<11
%C%b4e8<11
%C%b4e8<16
%C%b4e8>5
%C%b4e8<5
%C%b4e8<5
%C%b4e8<7
%C%b4e8>13
%C%b4e8>13
%CO:D,9,0%


%V%%C%10
%V%%C%14
%V%%C%7
%V%%C%5
%V%%C%17


%C%Input 3
%C%-
%C%-
%C%-
%C%-
%C%-
%C%-
%C%-
%C%-
%C%-
%C% -
%CO:E,8,90%


%V%%C%13
%V%%C%19
%V%%C%1
%V%%C%7
%V%%C%1


%C%Result
%V%%R%davg(b4e8,b4e8<11)
%V%%R%dcount(b4e8,b4e8<11)
%V%%R%dcounta(b4e8,b4e8<11)
%V%%R%dmax(b4e8,b4e8<16)
%V%%R%dmin(b4e8,b4e8>5)
%V%%R%dstd(b4e8,b4e8<5)
%V%%R%dstdp(b4e8,b4e8<5)
%V%%R%dsum(b4e8,b4e8<7)
%V%%R%dvar(b4e8,b4e8>13)
%V%%R%dvarp(b4e8,b4e8>13)
%CO:F,4,0%%CO:G,65,68%









%L%Summary
Returns the average of a list of numbers.
Counts the number of entries in a list satisfying the condition. (Numeric Slots only).
Counts the number of entries in a list satisfying the condition. (All Slots).
Returns the maximum value in a list satisfying a condition.
Returns the minimum value in a list satisfying the condition.
Returns the population standard deviation of a list satisfying the condition.
Returns the modified population standard deviation of a list satisfying the condition.
Sums the values in a list satisfying the condition.
Returns the population variance of a list satisfying the condition.
Returns the modified population variance of a list satisfying the condition.

00000000  25 4f 50 25 4c 50 2a 0a  25 4f 50 25 54 4d 34 0a  |%OP%LP*.%OP%TM4.|
00000010  25 4f 50 25 42 4d 34 0a  25 4f 50 25 4c 4d 35 0a  |%OP%BM4.%OP%LM5.|
00000020  25 4f 50 25 46 58 0a 25  4f 50 25 46 59 0a 25 4f  |%OP%FX.%OP%FY.%O|
00000030  50 25 46 53 0a 25 4f 50  25 57 43 32 2c 31 37 35  |P%FS.%OP%WC2,175|
00000040  30 2c 33 36 30 2c 31 32  35 32 2c 30 2c 31 2c 30  |0,360,1252,0,1,0|
00000050  2c 30 0a 25 4f 50 25 56  53 33 2e 34 30 52 20 28  |,0.%OP%VS3.40R (|
00000060  31 31 2d 4f 63 74 2d 39  30 29 2c 20 4d 72 6a 63  |11-Oct-90), Mrjc|
00000070  2c 20 52 39 32 30 30 20  37 35 30 30 20 33 39 30  |, R9200 7500 390|
00000080  30 20 38 32 39 39 20 0a  25 43 4f 3a 41 2c 31 30  |0 8299 .%CO:A,10|
00000090  2c 38 38 25 25 43 25 25  48 31 25 44 61 74 61 62  |,88%%C%%H1%Datab|
000000a0  61 73 65 20 46 75 6e 63  74 69 6f 6e 73 20 45 78  |ase Functions Ex|
000000b0  61 6d 70 6c 65 73 0a 0a  0a 0a 0a 0a 0a 0a 0a 0a  |amples..........|
000000c0  25 43 25 46 75 6e 63 74  69 6f 6e 0a 44 61 76 67  |%C%Function.Davg|
000000d0  0a 44 63 6f 75 6e 74 0a  44 63 6f 75 6e 74 61 0a  |.Dcount.Dcounta.|
000000e0  44 6d 61 78 0a 44 6d 69  6e 0a 44 73 74 64 0a 44  |Dmax.Dmin.Dstd.D|
000000f0  73 74 64 70 0a 44 73 75  6d 0a 44 76 61 72 0a 44  |stdp.Dsum.Dvar.D|
00000100  76 61 72 70 0a 25 43 4f  3a 42 2c 39 2c 31 36 25  |varp.%CO:B,9,16%|
00000110  0a 0a 0a 25 56 25 25 43  25 38 0a 25 56 25 25 43  |...%V%%C%8.%V%%C|
00000120  25 37 0a 25 56 25 25 43  25 32 0a 25 56 25 25 43  |%7.%V%%C%2.%V%%C|
00000130  25 31 31 0a 25 56 25 25  43 25 36 0a 0a 0a 25 43  |%11.%V%%C%6...%C|
00000140  25 49 6e 70 75 74 20 31  0a 25 43 25 62 34 65 38  |%Input 1.%C%b4e8|
00000150  0a 25 43 25 62 34 65 38  0a 25 43 25 62 34 65 38  |.%C%b4e8.%C%b4e8|
*
00000190  0a 25 43 25 62 34 65 38  0a 25 43 4f 3a 43 2c 39  |.%C%b4e8.%CO:C,9|
000001a0  2c 30 25 0a 0a 0a 25 56  25 25 43 25 35 0a 25 56  |,0%...%V%%C%5.%V|
000001b0  25 25 43 25 31 32 0a 25  56 25 25 43 25 37 0a 25  |%%C%12.%V%%C%7.%|
000001c0  56 25 25 43 25 39 0a 25  56 25 25 43 25 31 37 0a  |V%%C%9.%V%%C%17.|
000001d0  0a 0a 25 43 25 49 6e 70  75 74 20 32 0a 25 43 25  |..%C%Input 2.%C%|
000001e0  62 34 65 38 3c 31 31 0a  25 43 25 62 34 65 38 3c  |b4e8<11.%C%b4e8<|
000001f0  31 31 0a 25 43 25 62 34  65 38 3c 31 31 0a 25 43  |11.%C%b4e8<11.%C|
00000200  25 62 34 65 38 3c 31 36  0a 25 43 25 62 34 65 38  |%b4e8<16.%C%b4e8|
00000210  3e 35 0a 25 43 25 62 34  65 38 3c 35 0a 25 43 25  |>5.%C%b4e8<5.%C%|
00000220  62 34 65 38 3c 35 0a 25  43 25 62 34 65 38 3c 37  |b4e8<5.%C%b4e8<7|
00000230  0a 25 43 25 62 34 65 38  3e 31 33 0a 25 43 25 62  |.%C%b4e8>13.%C%b|
00000240  34 65 38 3e 31 33 0a 25  43 4f 3a 44 2c 39 2c 30  |4e8>13.%CO:D,9,0|
00000250  25 0a 0a 0a 25 56 25 25  43 25 31 30 0a 25 56 25  |%...%V%%C%10.%V%|
00000260  25 43 25 31 34 0a 25 56  25 25 43 25 37 0a 25 56  |%C%14.%V%%C%7.%V|
00000270  25 25 43 25 35 0a 25 56  25 25 43 25 31 37 0a 0a  |%%C%5.%V%%C%17..|
00000280  0a 25 43 25 49 6e 70 75  74 20 33 0a 25 43 25 2d  |.%C%Input 3.%C%-|
00000290  0a 25 43 25 2d 0a 25 43  25 2d 0a 25 43 25 2d 0a  |.%C%-.%C%-.%C%-.|
000002a0  25 43 25 2d 0a 25 43 25  2d 0a 25 43 25 2d 0a 25  |%C%-.%C%-.%C%-.%|
000002b0  43 25 2d 0a 25 43 25 2d  0a 25 43 25 20 2d 0a 25  |C%-.%C%-.%C% -.%|
000002c0  43 4f 3a 45 2c 38 2c 39  30 25 0a 0a 0a 25 56 25  |CO:E,8,90%...%V%|
000002d0  25 43 25 31 33 0a 25 56  25 25 43 25 31 39 0a 25  |%C%13.%V%%C%19.%|
000002e0  56 25 25 43 25 31 0a 25  56 25 25 43 25 37 0a 25  |V%%C%1.%V%%C%7.%|
000002f0  56 25 25 43 25 31 0a 0a  0a 25 43 25 52 65 73 75  |V%%C%1...%C%Resu|
00000300  6c 74 0a 25 56 25 25 52  25 64 61 76 67 28 62 34  |lt.%V%%R%davg(b4|
00000310  65 38 2c 62 34 65 38 3c  31 31 29 0a 25 56 25 25  |e8,b4e8<11).%V%%|
00000320  52 25 64 63 6f 75 6e 74  28 62 34 65 38 2c 62 34  |R%dcount(b4e8,b4|
00000330  65 38 3c 31 31 29 0a 25  56 25 25 52 25 64 63 6f  |e8<11).%V%%R%dco|
00000340  75 6e 74 61 28 62 34 65  38 2c 62 34 65 38 3c 31  |unta(b4e8,b4e8<1|
00000350  31 29 0a 25 56 25 25 52  25 64 6d 61 78 28 62 34  |1).%V%%R%dmax(b4|
00000360  65 38 2c 62 34 65 38 3c  31 36 29 0a 25 56 25 25  |e8,b4e8<16).%V%%|
00000370  52 25 64 6d 69 6e 28 62  34 65 38 2c 62 34 65 38  |R%dmin(b4e8,b4e8|
00000380  3e 35 29 0a 25 56 25 25  52 25 64 73 74 64 28 62  |>5).%V%%R%dstd(b|
00000390  34 65 38 2c 62 34 65 38  3c 35 29 0a 25 56 25 25  |4e8,b4e8<5).%V%%|
000003a0  52 25 64 73 74 64 70 28  62 34 65 38 2c 62 34 65  |R%dstdp(b4e8,b4e|
000003b0  38 3c 35 29 0a 25 56 25  25 52 25 64 73 75 6d 28  |8<5).%V%%R%dsum(|
000003c0  62 34 65 38 2c 62 34 65  38 3c 37 29 0a 25 56 25  |b4e8,b4e8<7).%V%|
000003d0  25 52 25 64 76 61 72 28  62 34 65 38 2c 62 34 65  |%R%dvar(b4e8,b4e|
000003e0  38 3e 31 33 29 0a 25 56  25 25 52 25 64 76 61 72  |8>13).%V%%R%dvar|
000003f0  70 28 62 34 65 38 2c 62  34 65 38 3e 31 33 29 0a  |p(b4e8,b4e8>13).|
00000400  25 43 4f 3a 46 2c 34 2c  30 25 25 43 4f 3a 47 2c  |%CO:F,4,0%%CO:G,|
00000410  36 35 2c 36 38 25 0a 0a  0a 0a 0a 0a 0a 0a 0a 0a  |65,68%..........|
00000420  25 4c 25 53 75 6d 6d 61  72 79 0a 52 65 74 75 72  |%L%Summary.Retur|
00000430  6e 73 20 74 68 65 20 61  76 65 72 61 67 65 20 6f  |ns the average o|
00000440  66 20 61 20 6c 69 73 74  20 6f 66 20 6e 75 6d 62  |f a list of numb|
00000450  65 72 73 2e 0a 43 6f 75  6e 74 73 20 74 68 65 20  |ers..Counts the |
00000460  6e 75 6d 62 65 72 20 6f  66 20 65 6e 74 72 69 65  |number of entrie|
00000470  73 20 69 6e 20 61 20 6c  69 73 74 20 73 61 74 69  |s in a list sati|
00000480  73 66 79 69 6e 67 20 74  68 65 20 63 6f 6e 64 69  |sfying the condi|
00000490  74 69 6f 6e 2e 20 28 4e  75 6d 65 72 69 63 20 53  |tion. (Numeric S|
000004a0  6c 6f 74 73 20 6f 6e 6c  79 29 2e 0a 43 6f 75 6e  |lots only)..Coun|
000004b0  74 73 20 74 68 65 20 6e  75 6d 62 65 72 20 6f 66  |ts the number of|
000004c0  20 65 6e 74 72 69 65 73  20 69 6e 20 61 20 6c 69  | entries in a li|
000004d0  73 74 20 73 61 74 69 73  66 79 69 6e 67 20 74 68  |st satisfying th|
000004e0  65 20 63 6f 6e 64 69 74  69 6f 6e 2e 20 28 41 6c  |e condition. (Al|
000004f0  6c 20 53 6c 6f 74 73 29  2e 0a 52 65 74 75 72 6e  |l Slots)..Return|
00000500  73 20 74 68 65 20 6d 61  78 69 6d 75 6d 20 76 61  |s the maximum va|
00000510  6c 75 65 20 69 6e 20 61  20 6c 69 73 74 20 73 61  |lue in a list sa|
00000520  74 69 73 66 79 69 6e 67  20 61 20 63 6f 6e 64 69  |tisfying a condi|
00000530  74 69 6f 6e 2e 0a 52 65  74 75 72 6e 73 20 74 68  |tion..Returns th|
00000540  65 20 6d 69 6e 69 6d 75  6d 20 76 61 6c 75 65 20  |e minimum value |
00000550  69 6e 20 61 20 6c 69 73  74 20 73 61 74 69 73 66  |in a list satisf|
00000560  79 69 6e 67 20 74 68 65  20 63 6f 6e 64 69 74 69  |ying the conditi|
00000570  6f 6e 2e 0a 52 65 74 75  72 6e 73 20 74 68 65 20  |on..Returns the |
00000580  70 6f 70 75 6c 61 74 69  6f 6e 20 73 74 61 6e 64  |population stand|
00000590  61 72 64 20 64 65 76 69  61 74 69 6f 6e 20 6f 66  |ard deviation of|
000005a0  20 61 20 6c 69 73 74 20  73 61 74 69 73 66 79 69  | a list satisfyi|
000005b0  6e 67 20 74 68 65 20 63  6f 6e 64 69 74 69 6f 6e  |ng the condition|
000005c0  2e 0a 52 65 74 75 72 6e  73 20 74 68 65 20 6d 6f  |..Returns the mo|
000005d0  64 69 66 69 65 64 20 70  6f 70 75 6c 61 74 69 6f  |dified populatio|
000005e0  6e 20 73 74 61 6e 64 61  72 64 20 64 65 76 69 61  |n standard devia|
000005f0  74 69 6f 6e 20 6f 66 20  61 20 6c 69 73 74 20 73  |tion of a list s|
00000600  61 74 69 73 66 79 69 6e  67 20 74 68 65 20 63 6f  |atisfying the co|
00000610  6e 64 69 74 69 6f 6e 2e  0a 53 75 6d 73 20 74 68  |ndition..Sums th|
00000620  65 20 76 61 6c 75 65 73  20 69 6e 20 61 20 6c 69  |e values in a li|
00000630  73 74 20 73 61 74 69 73  66 79 69 6e 67 20 74 68  |st satisfying th|
00000640  65 20 63 6f 6e 64 69 74  69 6f 6e 2e 0a 52 65 74  |e condition..Ret|
00000650  75 72 6e 73 20 74 68 65  20 70 6f 70 75 6c 61 74  |urns the populat|
00000660  69 6f 6e 20 76 61 72 69  61 6e 63 65 20 6f 66 20  |ion variance of |
00000670  61 20 6c 69 73 74 20 73  61 74 69 73 66 79 69 6e  |a list satisfyin|
00000680  67 20 74 68 65 20 63 6f  6e 64 69 74 69 6f 6e 2e  |g the condition.|
00000690  0a 52 65 74 75 72 6e 73  20 74 68 65 20 6d 6f 64  |.Returns the mod|
000006a0  69 66 69 65 64 20 70 6f  70 75 6c 61 74 69 6f 6e  |ified population|
000006b0  20 76 61 72 69 61 6e 63  65 20 6f 66 20 61 20 6c  | variance of a l|
000006c0  69 73 74 20 73 61 74 69  73 66 79 69 6e 67 20 74  |ist satisfying t|
000006d0  68 65 20 63 6f 6e 64 69  74 69 6f 6e 2e 0a        |he condition..|
000006de

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