CALC04

FILE INFORMATION

FILENAME(S): CALC04

FILE TYPE(S): PRG

FILE SIZE: 1.8K

FIRST SEEN: 2025-10-19 22:48:34

APPEARS ON: 5 disk(s)

FILE HASH

e4e2dc88f47f347122bd7134bdf2480fdb313377cce4b36477308fb05177be68

FOUND ON DISKS (5 DISKS)

DISK TITLE	FILENAME	FILE TYPE	COLLECTION	TRACK	SECTOR	ACTIONS
HELP	CALC04	PRG	Radd Maxx, Shocktrooper, Treasure Chest - Klaus Der Suhler	22	2	DOWNLOAD FILE
HELP GEEL	CALC04	PRG	DuncanTwain	22	2	DOWNLOAD FILE
HELP	CALC04	PRG	DuncanTwain	22	2	DOWNLOAD FILE
HELP	CALC04	PRG	DuncanTwain	22	2	DOWNLOAD FILE
HELP	CALC04	PRG	swasti, flohmarkt	22	2	DOWNLOAD FILE

FILE CONTENT & ANALYSIS

00000000: 00 40 03 02 09 01 0A 03  03 02 0F 14 00 18 04 01  |.@..............|
00000010: 01 01 25 01 2A 01 01 45  78 61 6D 69 6E 69 6E 67  |..%.*..Examining|
00000020: 20 61 20 66 6F 72 6D 75  6C 61 2E 00 01 01 03 54  | a formula.....T|
00000030: 68 65 20 72 65 73 75 6C  74 73 20 6F 66 20 66 6F  |he results of fo|
00000040: 72 6D 75 6C 61 73 20 61  70 70 65 61 72 20 69 6E  |rmulas appear in|
00000050: 20 00 01 01 04 74 68 65  20 77 6F 72 6B 73 68 65  | ....the workshe|
00000060: 65 74 20 61 73 00 0A 06  03 01 12 04 62 6F 6C 64  |et as.......bold|
00000070: 66 61 63 65 64 20 00 0A  03 03 01 1C 04 6E 75 6D  |faced .......num|
00000080: 62 65 72 73 2E 00 01 01  05 54 6F 20 76 69 65 77  |bers.....To view|
00000090: 20 74 68 65 20 61 63 74  75 61 6C 20 73 74 72 69  | the actual stri|
000000A0: 6E 67 20 6F 66 20 63 65  6C 6C 73 00 01 01 06 61  |ng of cells....a|
000000B0: 6E 64 20 73 79 6D 62 6F  6C 73 20 77 68 69 63 68  |nd symbols which|
000000C0: 20 6D 61 6B 65 20 75 70  20 74 68 65 20 00 01 01  | make up the ...|
000000D0: 07 66 6F 72 6D 75 6C 61  3A 00 18 05 01 01 09 25  |.formula:......%|
000000E0: 0B 01 01 09 31 29 20 50  6F 73 69 74 69 6F 6E 20  |....1) Position |
000000F0: 74 68 65 20 49 6E 73 65  72 74 20 41 72 72 6F 77  |the Insert Arrow|
00000100: 20 6F 6E 00 01 04 0A 74  68 65 20 62 6F 6C 64 66  | on....the boldf|
00000110: 61 63 65 64 20 6E 75 6D  62 65 72 20 69 6E 20 20  |aced number in  |
00000120: 00 01 04 0B 71 75 65 73  74 69 6F 6E 20 61 6E 64  |....question and|
00000130: 20 63 6C 69 63 6B 20 74  68 65 20 62 75 74 74 6F  | click the butto|
00000140: 6E 2E 20 00 18 01 0F 00  0E 25 0E 18 01 0F 00 0F  |n. ......%......|
00000150: 01 15 01 00 0D 3E 00 01  00 0E 20 20 20 20 20 20  |.....>....      |
00000160: 20 41 20 20 20 20 20 20  20 20 20 42 20 20 20 20  | A         B    |
00000170: 20 20 20 20 20 43 20 20  20 20 20 20 20 20 20 44  |     C         D|
00000180: 00 01 00 0F 31 00 01 00  10 32 00 01 00 11 33 00  |....1....2....3.|
00000190: 01 00 12 34 00 01 00 13  35 00 01 00 14 36 00 01  |...4....5....6..|
000001A0: 00 15 37 00 01 02 0F 52  65 6E 74 20 20 20 20 20  |..7....Rent     |
000001B0: 20 20 20 20 20 32 38 35  2E 30 30 00 01 02 10 46  |     285.00....F|
000001C0: 6F 6F 64 20 20 20 20 20  20 20 20 20 20 31 30 35  |ood          105|
000001D0: 2E 30 30 00 01 02 11 55  74 69 6C 69 74 69 65 73  |.00....Utilities|
000001E0: 20 20 20 20 20 20 36 35  2E 30 30 00 01 02 12 4D  |      65.00....M|
000001F0: 69 73 63 2E 20 20 20 20  20 20 20 20 20 20 33 35  |isc.          35|
00000200: 2E 30 30 00 01 02 14 59  65 61 72 20 54 6F 74 61  |.00....Year Tota|
00000210: 6C 20 20 20 20 20 00 0A  06 03 01 0E 14 35 2C 38  |l     .......5,8|
00000220: 38 30 2E 30 30 00 0A 03  03 18 02 01 00 16 25 16  |80.00.........%.|
00000230: 17 29 01 01 25 0B 02 0E  0D 00 01 01 0D 73 75 6D  |.)..%........sum|
00000240: 28 42 31 3A 42 34 29 2A  31 32 00 01 0C 14 A0 A0  |(B1:B4)*12......|
00000250: B5 AC B8 B8 B0 AE B0 B0  00 09 01 18 05 01 01 03  |................|
00000260: 25 06 01 01 03 32 29 20  54 68 65 20 73 74 72 69  |%....2) The stri|
00000270: 6E 67 20 6F 66 20 63 65  6C 6C 73 20 61 6E 64 20  |ng of cells and |
00000280: 73 79 6D 62 6F 6C 73 00  01 04 04 77 68 69 63 68  |symbols....which|
00000290: 20 6D 61 6B 65 20 75 70  20 74 68 65 20 66 6F 72  | make up the for|
000002A0: 6D 75 6C 61 20 77 69 6C  6C 20 00 01 04 05 61 70  |mula will ....ap|
000002B0: 70 65 61 72 20 6F 6E 20  74 68 65 20 44 69 73 70  |pear on the Disp|
000002C0: 6C 61 79 20 42 61 72 20  61 62 6F 76 65 00 01 04  |lay Bar above...|
000002D0: 06 74 68 65 20 77 6F 72  6B 73 68 65 65 74 20 66  |.the worksheet f|
000002E0: 6F 72 20 79 6F 75 20 74  6F 20 76 69 65 77 2E 00  |or you to view..|
000002F0: 18 02 01 00 16 25 16 17  29 01 03 25 06 09 01 18  |.....%..)..%....|
00000300: 05 01 01 02 25 02 18 05  01 01 07 25 08 01 01 02  |....%......%....|
00000310: 33 29 20 49 66 20 61 20  6E 75 6D 62 65 72 20 69  |3) If a number i|
00000320: 6E 20 74 68 65 20 66 6F  72 6D 75 6C 61 20 00 01  |n the formula ..|
00000330: 04 03 6F 72 69 67 69 6E  61 74 65 64 20 66 72 6F  |..originated fro|
00000340: 6D 20 74 68 65 20 77 6F  72 6B 73 68 65 65 74 2C  |m the worksheet,|
00000350: 20 00 01 04 04 69 74 20  77 69 6C 6C 20 62 65 20  | ....it will be |
00000360: 72 65 70 72 65 73 65 6E  74 65 64 20 62 79 20 74  |represented by t|
00000370: 68 65 20 20 00 01 04 05  6E 61 6D 65 20 6F 66 20  |he  ....name of |
00000380: 74 68 65 20 63 65 6C 6C  20 69 74 20 69 73 00 01  |the cell it is..|
00000390: 04 06 63 6F 6E 74 61 69  6E 65 64 20 69 6E 2E 20  |..contained in. |
000003A0: 20 49 66 20 74 68 65 20  6E 75 6D 62 65 72 00 01  | If the number..|
000003B0: 04 07 77 61 73 20 74 79  70 65 64 20 6F 6E 74 6F  |..was typed onto|
000003C0: 20 74 68 65 20 44 69 73  70 6C 61 79 20 42 61 72  | the Display Bar|
000003D0: 00 01 04 08 75 73 69 6E  67 20 74 68 65 20 6B 65  |....using the ke|
000003E0: 79 62 6F 61 72 64 2C 20  74 68 65 20 6E 75 6D 62  |yboard, the numb|
000003F0: 65 72 00 01 1C 08 6E 75  6D 62 65 72 00 01 04 09  |er....number....|
00000400: 69 74 73 65 6C 66 20 77  69 6C 6C 20 62 65 20 64  |itself will be d|
00000410: 69 73 70 6C 61 79 65 64  2E 00 18 02 01 00 16 25  |isplayed.......%|
00000420: 16 17 09 01 03 01 02 00  0D 00 29 01 02 25 09 29  |..........)..%.)|
00000430: 02 0F 25 14 18 05 01 01  01 25 0B 01 01 01 49 66  |..%......%....If|
00000440: 20 61 20 66 6F 72 6D 75  6C 61 20 69 73 20 74 6F  | a formula is to|
00000450: 6F 20 6C 6F 6E 67 20 74  6F 20 62 65 00 01 01 02  |o long to be....|
00000460: 76 69 73 69 62 6C 65 20  6F 6E 20 74 68 65 20 44  |visible on the D|
00000470: 69 73 70 6C 61 79 20 42  61 72 20 61 6C 6C 20 61  |isplay Bar all a|
00000480: 74 20 00 01 01 03 6F 6E  63 65 2C 20 73 65 6C 65  |t ....once, sele|
00000490: 63 74 20 74 68 65 20 3E  20 6F 72 20 3C 20 73 79  |ct the > or < sy|
000004A0: 6D 62 6F 6C 20 61 74 00  01 01 04 74 68 65 20 6C  |mbol at....the l|
000004B0: 65 66 74 20 65 6E 64 20  6F 66 20 74 68 65 20 44  |eft end of the D|
000004C0: 69 73 70 6C 61 79 20 42  61 72 20 74 6F 00 01 01  |isplay Bar to...|
000004D0: 05 73 65 65 20 74 68 65  20 68 69 64 64 65 6E 20  |.see the hidden |
000004E0: 70 61 72 74 73 20 6F 66  20 74 68 65 20 66 6F 72  |parts of the for|
000004F0: 6D 75 6C 61 2E 20 00 01  01 05 73 65 65 20 74 68  |mula. ....see th|
00000500: 65 20 68 69 64 64 65 6E  20 70 61 72 74 73 20 6F  |e hidden parts o|
00000510: 66 20 74 68 65 20 66 6F  72 6D 75 6C 61 2E 00 01  |f the formula...|
00000520: 00 0D 3E 73 75 6D 28 43  31 3A 43 32 32 29 2B 61  |..>sum(C1:C22)+a|
00000530: 76 67 28 44 31 3A 44 32  32 29 2F 45 36 2B 33 36  |vg(D1:D22)/E6+36|
00000540: 35 2A 46 31 31 2B 73 75  00 01 00 0F 36 20 59 65  |5*F11+su....6 Ye|
00000550: 61 72 20 54 6F 74 61 6C  00 01 00 10 37 00 0A 06  |ar Total....7...|
00000560: 03 01 16 0F 35 2C 38 38  30 2E 30 30 00 0A 03 03  |....5,880.00....|
00000570: 01 00 11 38 20 48 6F 75  73 65 20 52 65 70 61 69  |...8 House Repai|
00000580: 72 73 00 01 00 12 39 00  01 00 13 31 30 00 01 00  |rs....9....10...|
00000590: 14 31 31 00 01 00 15 31  32 20 20 20 20 20 20 00  |.11....12      .|
000005A0: 0A 06 03 01 14 11 A0 B1  B0 B1 AC B3 B2 B9 AE 3E  |...............>|
000005B0: 00 0A 03 03 18 02 01 00  16 25 16 17 09 02 04 01  |.........%......|
000005C0: 29 1D 0D 25 0D 01 00 0D  3C 45 36 2B 33 36 35 2A  |)..%....<E6+365*|
000005D0: 46 31 31 2B 73 75 6D 28  47 31 3A 47 33 35 29 2B  |F11+sum(G1:G35)+|
000005E0: 32 35 25 48 33 00 04 03  17 02 1E 11 00 29 01 01  |25%H3........)..|
000005F0: 25 05 09 01 01 01 01 54  68 65 20 73 79 6D 62 6F  |%......The symbo|
00000600: 6C 20 27 3E 27 2C 20 77  68 65 6E 20 64 69 73 70  |l '>', when disp|
00000610: 6C 61 79 65 64 20 69 6E  20 61 20 00 01 01 02 63  |layed in a ....c|
00000620: 65 6C 6C 20 69 6E 20 74  68 65 20 77 6F 72 6B 73  |ell in the works|
00000630: 68 65 65 74 2C 20 69 73  20 61 6E 20 20 00 01 01  |heet, is an  ...|
00000640: 03 69 6E 64 69 63 61 74  69 6F 6E 20 74 68 61 74  |.indication that|
00000650: 20 74 68 65 20 6E 75 6D  62 65 72 20 63 6F 6E 74  | the number cont|
00000660: 61 69 6E 65 64 00 01 01  04 69 6E 20 74 68 61 74  |ained....in that|
00000670: 20 63 65 6C 6C 20 69 73  20 6C 6F 6E 67 65 72 20  | cell is longer |
00000680: 74 68 61 6E 20 63 61 6E  20 62 65 00 01 01 05 64  |than can be....d|
00000690: 69 73 70 6C 61 79 65 64  2E 00 18 02 01 00 16 25  |isplayed.......%|
000006A0: 16 17 00 00 00 00 00 00  00 00 00 00 00 00 00 00  |................|
000006B0: 00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00  |................|
000006C0: 00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00  |................|
000006D0: 00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00  |................|
000006E0: 00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00  |................|
000006F0: 00 00 00 00 1A 02 07 18  02 01 00 16 25 16 17 08  |............%...|
00000700: 02                                                |.               |

.@................%.*..EXAMINING A FORMU
LA.....THE RESULTS OF FORMULAS APPEAR IN
 ....THE WORKSHEET AS.......BOLDFACED ..
.....NUMBERS.....TO VIEW THE ACTUAL STRI
NG OF CELLS....AND SYMBOLS WHICH MAKE UP
 THE ....FORMULA:......%....1) POSITION 
THE INSERT ARROW ON....THE BOLDFACED NUM
BER IN  ....QUESTION AND CLICK THE BUTTO
N. ......%...........>....       A      
   B         C         D....1....2....3.
...4....5....6....7....RENT          285
.00....FOOD          105.00....UTILITIES
      65.00....MISC.          35.00....Y
EAR TOTAL     .......5,880.00.........%.
.)..%........SUM(B1:B4)*12....  ........
........%....2) THE STRING OF CELLS AND 
SYMBOLS....WHICH MAKE UP THE FORMULA WIL
L ....APPEAR ON THE DISPLAY BAR ABOVE...
.THE WORKSHEET FOR YOU TO VIEW.......%..
)..%........%......%....3) IF A NUMBER I
N THE FORMULA ....ORIGINATED FROM THE WO
RKSHEET, ....IT WILL BE REPRESENTED BY T
HE  ....NAME OF THE CELL IT IS....CONTAI
NED IN.  IF THE NUMBER....WAS TYPED ONTO
 THE DISPLAY BAR....USING THE KEYBOARD, 
THE NUMBER....NUMBER....ITSELF WILL BE D
ISPLAYED.......%..........)..%.)..%.....
.%....IF A FORMULA IS TOO LONG TO BE....
VISIBLE ON THE DISPLAY BAR ALL AT ....ON
CE, SELECT THE > OR < SYMBOL AT....THE L
EFT END OF THE DISPLAY BAR TO....SEE THE
 HIDDEN PARTS OF THE FORMULA. ....SEE TH
E HIDDEN PARTS OF THE FORMULA.....>SUM(C
1:C22)+AVG(D1:D22)/E6+365*F11+SU....6 YE
AR TOTAL....7.......5,880.00.......8 HOU
SE REPAIRS....9....10....11....12      .
...... ........>.........%......)..%....
<E6+365*F11+SUM(G1:G35)+25%H3........)..
%......THE SYMBOL '>', WHEN DISPLAYED IN
 A ....CELL IN THE WORKSHEET, IS AN  ...
.INDICATION THAT THE NUMBER CONTAINED...
.IN THAT CELL IS LONGER THAN CAN BE....D
ISPLAYED.......%........................
........................................
............................%....

Visualization:

Width: Skip load address (+2) Invert

> CLICK IMAGE PREVIEW FOR FULL MODAL