CALC05
FILE INFORMATION
FILENAME(S): CALC05
FILE TYPE(S): PRG
FILE SIZE: 2.5K
FIRST SEEN: 2025-10-19 22:48:34
APPEARS ON: 5 disk(s)
FILE HASH
5a1c48f4bdd51d6f0abd3a85b56f7024eff0637e4354bf98304abd5b4898e687
FOUND ON DISKS (5 DISKS)
| DISK TITLE | FILENAME | FILE TYPE | COLLECTION | TRACK | SECTOR | ACTIONS |
|---|---|---|---|---|---|---|
| HELP | CALC05 | PRG | Radd Maxx, Shocktrooper, Treasure Chest - Klaus Der Suhler | 22 | 16 | DOWNLOAD FILE |
| HELP GEEL | CALC05 | PRG | DuncanTwain | 22 | 16 | DOWNLOAD FILE |
| HELP | CALC05 | PRG | DuncanTwain | 22 | 16 | DOWNLOAD FILE |
| HELP | CALC05 | PRG | DuncanTwain | 22 | 16 | DOWNLOAD FILE |
| HELP | CALC05 | PRG | swasti, flohmarkt | 22 | 16 | DOWNLOAD FILE |
FILE CONTENT & ANALYSIS
00000000: 00 40 03 01 09 01 0A 03 03 02 22 14 00 18 04 01 |.@........".....| 00000010: 01 01 25 01 2A 01 01 43 6F 70 79 69 6E 67 20 61 |..%.*..Copying a| 00000020: 20 66 6F 72 6D 75 6C 61 2E 00 01 01 03 41 20 6C | formula.....A l| 00000030: 65 6E 67 74 68 79 20 66 6F 72 6D 75 6C 61 20 63 |engthy formula c| 00000040: 61 6E 20 62 65 20 64 75 70 6C 69 63 61 74 65 64 |an be duplicated| 00000050: 20 00 01 01 04 74 68 72 6F 75 67 68 6F 75 74 20 | ....throughout | 00000060: 61 20 77 6F 72 6B 73 68 65 65 74 20 62 79 20 75 |a worksheet by u| 00000070: 73 69 6E 67 20 74 68 65 00 01 01 05 43 61 6D 65 |sing the....Came| 00000080: 72 61 20 74 6F 20 63 6F 70 79 20 69 74 20 61 6E |ra to copy it an| 00000090: 64 20 74 68 65 20 50 61 73 74 65 20 4A 61 72 00 |d the Paste Jar.| 000000A0: 01 01 06 74 6F 20 70 61 73 74 65 20 69 74 20 69 |...to paste it i| 000000B0: 6E 74 6F 20 6F 74 68 65 72 20 63 65 6C 6C 73 2E |nto other cells.| 000000C0: 00 01 01 07 54 68 65 72 65 20 61 72 65 20 33 20 |....There are 3 | 000000D0: 74 79 70 65 73 20 6F 66 20 66 6F 72 6D 75 6C 61 |types of formula| 000000E0: 20 00 01 01 08 64 75 70 6C 69 63 61 74 69 6F 6E | ....duplication| 000000F0: 3A 00 18 05 01 01 0A 25 15 01 01 0A 31 29 20 4F |:......%....1) O| 00000100: 6E 65 20 74 79 70 65 20 69 73 20 77 68 65 6E 20 |ne type is when | 00000110: 74 68 65 20 63 65 6C 6C 73 00 01 04 0B 72 65 66 |the cells....ref| 00000120: 65 72 65 6E 63 65 64 20 69 6E 20 74 68 65 20 66 |erenced in the f| 00000130: 6F 72 6D 75 6C 61 20 61 72 65 20 00 01 04 0C 61 |ormula are ....a| 00000140: 6C 6C 20 66 6F 75 6E 64 20 69 6E 20 74 68 65 20 |ll found in the | 00000150: 73 61 6D 65 20 72 6F 77 20 6F 72 20 00 01 04 0D |same row or ....| 00000160: 63 6F 6C 75 6D 6E 20 61 73 20 74 68 65 20 66 6F |column as the fo| 00000170: 72 6D 75 6C 61 2C 20 61 73 20 69 6E 20 00 18 0C |rmula, as in ...| 00000180: 01 07 0E 25 0E 01 07 0E 73 75 6D 28 42 33 3A 42 |...%....sum(B3:B| 00000190: 31 30 29 2B 61 76 67 28 42 31 32 3A 42 31 35 29 |10)+avg(B12:B15)| 000001A0: 00 01 04 0F 77 68 65 72 65 20 74 68 65 20 66 6F |....where the fo| 000001B0: 72 6D 75 6C 61 20 63 65 6C 6C 20 69 73 20 61 6C |rmula cell is al| 000001C0: 73 6F 20 00 01 04 10 6C 6F 63 61 74 65 64 20 69 |so ....located i| 000001D0: 6E 20 63 6F 6C 75 6D 6E 20 42 2E 00 01 04 12 54 |n column B.....T| 000001E0: 68 65 20 63 6F 70 69 65 64 20 66 6F 72 6D 75 6C |he copied formul| 000001F0: 61 20 77 69 6C 6C 20 62 65 20 6A 75 73 74 20 00 |a will be just .| 00000200: 01 04 13 6C 69 6B 65 20 74 68 65 20 6F 72 69 67 |...like the orig| 00000210: 69 6E 61 6C 2C 20 62 75 74 20 72 65 6C 61 74 69 |inal, but relati| 00000220: 76 65 20 20 00 01 04 14 74 6F 20 69 74 27 73 20 |ve ....to it's | 00000230: 6E 65 77 20 6C 6F 63 61 74 69 6F 6E 20 69 6E 20 |new location in | 00000240: 74 68 65 00 01 04 15 77 6F 72 6B 73 68 65 65 74 |the....worksheet| 00000250: 2E 00 18 02 01 00 16 25 16 17 08 09 01 02 21 10 |.......%......!.| 00000260: 00 18 05 01 01 01 25 0F 01 01 01 32 29 20 41 6E |......%....2) An| 00000270: 6F 74 68 65 72 20 74 79 70 65 20 69 73 20 77 68 |other type is wh| 00000280: 65 6E 20 74 68 65 20 63 65 6C 6C 73 20 00 01 04 |en the cells ...| 00000290: 02 74 68 61 74 20 61 72 65 20 72 65 66 65 72 65 |.that are refere| 000002A0: 6E 63 65 64 20 61 72 65 20 6E 6F 74 20 61 6C 6C |nced are not all| 000002B0: 00 01 04 03 69 6E 20 74 68 65 20 73 61 6D 65 20 |....in the same | 000002C0: 72 6F 77 20 6F 72 20 63 6F 6C 75 6D 6E 20 61 6E |row or column an| 000002D0: 64 20 00 01 04 04 6F 6E 6C 79 20 74 68 65 20 66 |d ....only the f| 000002E0: 6F 72 6D 75 6C 61 20 63 65 6C 6C 20 69 73 20 63 |ormula cell is c| 000002F0: 6F 70 69 65 64 2E 00 01 04 06 49 6E 20 74 68 69 |opied.....In thi| 00000300: 73 20 63 61 73 65 2C 20 74 68 65 20 72 65 66 65 |s case, the refe| 00000310: 72 65 6E 63 65 64 00 01 04 07 63 65 6C 6C 73 20 |renced....cells | 00000320: 74 68 61 74 20 61 72 65 20 6E 6F 74 20 69 6E 20 |that are not in | 00000330: 74 68 65 20 73 61 6D 65 00 01 04 08 72 6F 77 20 |the same....row | 00000340: 6F 72 20 63 6F 6C 75 6D 6E 20 61 73 20 74 68 65 |or column as the| 00000350: 20 66 6F 72 6D 75 6C 61 20 20 00 01 04 09 77 69 | formula ....wi| 00000360: 6C 6C 20 72 65 6D 61 69 6E 20 74 68 65 20 73 61 |ll remain the sa| 00000370: 6D 65 2C 20 72 65 67 61 72 64 2D 00 01 04 0A 6C |me, regard-....l| 00000380: 65 73 73 20 6F 66 20 74 68 65 20 63 6F 70 69 65 |ess of the copie| 00000390: 64 20 66 6F 72 6D 75 6C 61 27 73 00 01 04 0B 6C |d formula's....l| 000003A0: 6F 63 61 74 69 6F 6E 20 69 6E 20 74 68 65 20 77 |ocation in the w| 000003B0: 6F 72 6B 73 68 65 65 74 2E 00 01 04 0C 4F 6E 6C |orksheet.....Onl| 000003C0: 79 20 74 68 6F 73 65 20 63 65 6C 6C 73 20 74 68 |y those cells th| 000003D0: 61 74 20 61 72 65 20 69 6E 00 01 04 0D 74 68 65 |at are in....the| 000003E0: 20 73 61 6D 65 20 72 6F 77 20 6F 72 20 63 6F 6C | same row or col| 000003F0: 75 6D 6E 20 61 73 20 74 68 65 00 01 04 0E 66 6F |umn as the....fo| 00000400: 72 6D 75 6C 61 20 63 65 6C 6C 20 77 69 6C 6C 20 |rmula cell will | 00000410: 62 65 63 6F 6D 65 20 00 01 04 0F 72 65 6C 61 74 |become ....relat| 00000420: 69 76 65 20 74 6F 20 74 68 65 20 6E 65 77 20 6C |ive to the new l| 00000430: 6F 63 61 74 69 6F 6E 2E 00 18 02 01 00 16 25 16 |ocation.......%.| 00000440: 17 08 02 11 13 00 09 01 18 05 01 01 01 25 0D 01 |.............%..| 00000450: 01 01 33 29 20 54 68 65 20 6C 61 73 74 20 74 79 |..3) The last ty| 00000460: 70 65 20 69 73 20 77 68 65 6E 20 74 68 65 20 63 |pe is when the c| 00000470: 65 6C 6C 73 00 01 04 02 72 65 66 65 72 65 6E 63 |ells....referenc| 00000480: 65 64 20 61 72 65 20 6E 6F 74 20 61 6C 6C 20 69 |ed are not all i| 00000490: 6E 20 74 68 65 20 00 01 04 03 73 61 6D 65 20 72 |n the ....same r| 000004A0: 6F 77 20 6F 72 20 63 6F 6C 75 6D 6E 2C 20 62 75 |ow or column, bu| 000004B0: 74 20 74 68 65 00 01 04 04 65 6E 74 69 72 65 20 |t the....entire | 000004C0: 62 6C 6F 63 6B 20 6F 66 20 72 65 66 65 72 65 6E |block of referen| 000004D0: 63 65 64 20 63 65 6C 6C 73 20 00 01 04 05 69 73 |ced cells ....is| 000004E0: 20 63 6F 70 69 65 64 20 61 6C 6F 6E 67 20 77 69 | copied along wi| 000004F0: 74 68 20 74 68 65 20 66 6F 72 6D 75 6C 61 00 01 |th the formula..| 00000500: 04 06 63 65 6C 6C 2E 00 01 04 08 54 68 69 73 20 |..cell.....This | 00000510: 70 72 6F 64 75 63 65 73 20 72 65 73 75 6C 74 73 |produces results| 00000520: 20 73 69 6D 69 6C 61 72 20 74 6F 20 00 01 04 09 | similar to ....| 00000530: 74 68 65 20 66 69 72 73 74 20 74 79 70 65 20 6F |the first type o| 00000540: 66 20 66 6F 72 6D 75 6C 61 20 00 01 04 0A 64 75 |f formula ....du| 00000550: 70 6C 69 63 61 74 69 6F 6E 20 69 6E 20 74 68 61 |plication in tha| 00000560: 74 20 74 68 65 20 63 6F 70 69 65 64 20 00 01 04 |t the copied ...| 00000570: 0B 66 6F 72 6D 75 6C 61 20 69 73 20 6A 75 73 74 |.formula is just| 00000580: 20 6C 69 6B 65 20 74 68 65 20 00 01 04 0C 6F 72 | like the ....or| 00000590: 69 67 69 6E 61 6C 2C 20 62 75 74 20 72 65 6C 61 |iginal, but rela| 000005A0: 74 69 76 65 20 74 6F 20 74 68 65 20 00 01 04 0D |tive to the ....| 000005B0: 6E 65 77 20 6C 6F 63 61 74 69 6F 6E 20 69 6E 20 |new location in | 000005C0: 74 68 65 20 77 6F 72 6B 73 68 65 65 74 2E 00 18 |the worksheet...| 000005D0: 0C 01 01 10 25 11 18 05 01 08 0F 0C 10 01 01 10 |....%...........| 000005E0: 53 65 6C 65 63 74 20 20 20 20 20 20 62 65 6C 6F |Select belo| 000005F0: 77 20 74 6F 20 73 65 65 20 61 6E 20 61 6E 69 6D |w to see an anim| 00000600: 61 74 65 64 00 05 08 0F 05 0E 01 01 11 65 78 61 |ated.........exa| 00000610: 6D 70 6C 65 2E 00 18 05 01 0E 13 12 14 05 0E 13 |mple............| 00000620: 05 0E 18 02 01 00 16 25 16 28 08 02 0E 06 00 18 |.......%.(......| 00000630: 07 07 00 08 25 08 18 01 0F 00 0A 25 0A 18 01 0F |....%......%....| 00000640: 00 0B 01 15 01 00 09 3E 00 01 00 0A 20 20 20 20 |.......>.... | 00000650: 20 20 20 20 20 41 20 20 20 20 20 20 20 20 20 42 | A B| 00000660: 20 20 20 20 20 20 20 20 20 43 20 20 20 20 20 20 | C | 00000670: 20 20 20 20 20 20 20 20 00 01 00 0B 31 00 01 00 | ....1...| 00000680: 0C 32 00 01 00 0D 33 00 01 00 0E 34 00 01 00 0F |.2....3....4....| 00000690: 35 00 01 00 10 36 00 01 00 11 37 00 01 00 12 38 |5....6....7....8| 000006A0: 00 01 00 13 39 00 01 00 14 31 30 00 01 00 15 31 |....9....10....1| 000006B0: 31 00 01 10 0B 4A 61 6E 75 61 72 79 20 20 46 65 |1....January Fe| 000006C0: 62 72 75 61 72 79 00 01 02 0D 52 65 6E 74 20 20 |bruary....Rent | 000006D0: 20 20 20 20 20 20 20 20 20 32 38 35 2E 30 30 20 | 285.00 | 000006E0: 20 20 20 32 38 35 2E 30 30 00 01 02 0E 46 6F 6F | 285.00....Foo| 000006F0: 64 20 20 20 20 20 20 20 20 20 20 20 31 30 35 2E |d 105.| 00000700: 30 30 20 20 20 20 31 33 38 2E 30 30 00 01 02 0F |00 138.00....| 00000710: 55 74 69 6C 69 74 69 65 73 20 20 20 20 20 20 20 |Utilities | 00000720: 36 35 2E 30 30 20 20 20 20 20 38 37 2E 30 30 00 |65.00 87.00.| 00000730: 01 02 10 50 68 6F 6E 65 20 20 20 20 20 20 20 20 |...Phone | 00000740: 20 20 20 33 35 2E 30 30 20 20 20 20 31 32 39 2E | 35.00 129.| 00000750: 30 30 00 01 02 11 50 61 72 6B 69 6E 67 20 20 20 |00....Parking | 00000760: 20 20 20 20 20 20 33 37 2E 35 30 20 20 20 20 20 | 37.50 | 00000770: 33 35 2E 30 30 00 01 02 12 4D 69 73 63 2E 20 20 |35.00....Misc. | 00000780: 20 20 20 20 20 20 20 20 20 35 30 2E 30 30 20 20 | 50.00 | 00000790: 20 20 20 37 32 2E 30 30 00 01 02 14 54 6F 74 61 | 72.00....Tota| 000007A0: 6C 00 0A 06 03 01 11 14 35 37 37 2E 35 30 00 0A |l.......577.50..| 000007B0: 03 03 09 01 01 01 01 54 6F 20 64 75 70 6C 69 63 |.......To duplic| 000007C0: 61 74 65 20 61 20 66 6F 72 6D 75 6C 61 20 74 6F |ate a formula to| 000007D0: 20 61 6E 6F 74 68 65 72 20 00 01 01 02 70 61 72 | another ....par| 000007E0: 74 20 6F 66 20 79 6F 75 72 20 77 6F 72 6B 73 68 |t of your worksh| 000007F0: 65 65 74 3A 00 01 01 04 6F 20 50 6F 73 69 74 69 |eet:....o Positi| 00000800: 6F 6E 20 74 68 65 20 43 61 6D 65 72 61 20 6F 6E |on the Camera on| 00000810: 20 74 68 65 00 01 03 05 66 6F 72 6D 75 6C 61 20 | the....formula | 00000820: 61 6E 64 20 63 6C 69 63 6B 20 74 68 65 20 62 75 |and click the bu| 00000830: 74 74 6F 6E 2E 00 04 08 09 01 03 04 04 01 02 13 |tton............| 00000840: 14 01 04 02 09 02 0A 06 03 01 0D 14 A0 A0 A0 A0 |................| 00000850: B5 B7 B7 AE B5 B0 00 04 02 01 0D 14 20 20 20 20 |............ | 00000860: 35 37 37 2E 35 30 00 0A 03 03 04 04 29 01 04 25 |577.50......)..%| 00000870: 05 09 01 01 01 04 6F 20 4D 6F 76 65 20 74 68 65 |......o Move the| 00000880: 20 50 61 73 74 65 20 4A 61 72 20 74 6F 20 74 68 | Paste Jar to th| 00000890: 65 20 63 65 6C 6C 20 00 01 03 05 77 68 65 72 65 |e cell ....where| 000008A0: 20 79 6F 75 20 77 61 6E 74 20 74 68 65 20 63 6F | you want the co| 000008B0: 70 69 65 64 20 66 6F 72 6D 75 6C 61 20 20 00 01 |pied formula ..| 000008C0: 03 06 74 6F 20 61 70 70 65 61 72 20 61 6E 64 20 |..to appear and | 000008D0: 63 6C 69 63 6B 20 74 68 65 20 62 75 74 74 6F 6E |click the button| 000008E0: 2E 00 04 08 03 05 09 01 04 02 02 1E 14 01 04 02 |................| 000008F0: 09 02 0A 06 03 01 1B 14 35 37 37 2E 35 30 00 02 |........577.50..| 00000900: 21 14 00 04 04 01 1B 14 37 34 36 2E 30 30 00 0A |!.......746.00..| 00000910: 03 03 04 03 29 01 01 25 06 09 01 01 01 01 54 68 |....)..%......Th| 00000920: 65 20 63 6F 70 69 65 64 20 66 6F 72 6D 75 6C 61 |e copied formula| 00000930: 20 77 69 6C 6C 20 61 70 70 65 61 72 20 69 6E 20 | will appear in | 00000940: 20 00 01 01 02 74 68 65 20 73 65 6C 65 63 74 65 | ....the selecte| 00000950: 64 20 63 65 6C 6C 20 61 6E 64 20 69 74 27 73 20 |d cell and it's | 00000960: 72 65 73 75 6C 74 20 20 00 01 01 03 77 69 6C 6C |result ....will| 00000970: 20 62 65 20 72 65 61 64 6A 75 73 74 65 64 20 74 | be readjusted t| 00000980: 6F 20 72 65 66 6C 65 63 74 20 74 68 65 20 20 00 |o reflect the .| 00000990: 01 01 04 76 61 6C 75 65 73 20 6F 66 20 74 68 65 |...values of the| 000009A0: 20 6E 65 77 6C 79 20 63 6F 72 72 65 73 70 6F 6E | newly correspon| 000009B0: 64 69 6E 67 20 00 01 01 05 63 65 6C 6C 73 2E 20 |ding ....cells. | 000009C0: 00 18 02 01 00 16 25 16 17 00 00 00 00 00 00 00 |......%.........| 000009D0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................| 000009E0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 1A 20 |............... | 000009F0: 20 20 20 20 20 44 00 01 00 0C 31 00 01 00 0D 32 | D....1....2| 00000A00: 00 |. |
.@........".......%.*..COPYING A FORMULA
.....A LENGTHY FORMULA CAN BE DUPLICATED
....THROUGHOUT A WORKSHEET BY USING THE
....CAMERA TO COPY IT AND THE PASTE JAR.
...TO PASTE IT INTO OTHER CELLS.....THER
E ARE 3 TYPES OF FORMULA ....DUPLICATION
:......%....1) ONE TYPE IS WHEN THE CELL
S....REFERENCED IN THE FORMULA ARE ....A
LL FOUND IN THE SAME ROW OR ....COLUMN A
S THE FORMULA, AS IN ......%....SUM(B3:B
10)+AVG(B12:B15)....WHERE THE FORMULA CE
LL IS ALSO ....LOCATED IN COLUMN B.....T
HE COPIED FORMULA WILL BE JUST ....LIKE
THE ORIGINAL, BUT RELATIVE ....TO IT'S
NEW LOCATION IN THE....WORKSHEET.......%
......!.......%....2) ANOTHER TYPE IS WH
EN THE CELLS ....THAT ARE REFERENCED ARE
NOT ALL....IN THE SAME ROW OR COLUMN AN
D ....ONLY THE FORMULA CELL IS COPIED...
..IN THIS CASE, THE REFERENCED....CELLS
THAT ARE NOT IN THE SAME....ROW OR COLUM
N AS THE FORMULA ....WILL REMAIN THE SA
ME, REGARD-....LESS OF THE COPIED FORMUL
A'S....LOCATION IN THE WORKSHEET.....ONL
Y THOSE CELLS THAT ARE IN....THE SAME RO
W OR COLUMN AS THE....FORMULA CELL WILL
BECOME ....RELATIVE TO THE NEW LOCATION.
......%..............%....3) THE LAST TY
PE IS WHEN THE CELLS....REFERENCED ARE N
OT ALL IN THE ....SAME ROW OR COLUMN, BU
T THE....ENTIRE BLOCK OF REFERENCED CELL
S ....IS COPIED ALONG WITH THE FORMULA..
..CELL.....THIS PRODUCES RESULTS SIMILAR
TO ....THE FIRST TYPE OF FORMULA ....DU
PLICATION IN THAT THE COPIED ....FORMULA
IS JUST LIKE THE ....ORIGINAL, BUT RELA
TIVE TO THE ....NEW LOCATION IN THE WORK
SHEET.......%...........SELECT BELO
W TO SEE AN ANIMATED.........EXAMPLE....
...............%.(..........%......%....
.......>.... A B
C ....1....2....3....4....
5....6....7....8....9....10....11....JAN
UARY FEBRUARY....RENT 285.00
285.00....FOOD 105.00 13
8.00....UTILITIES 65.00 87.00.
...PHONE 35.00 129.00....PA
RKING 37.50 35.00....MISC.
50.00 72.00....TOTAL.......
577.50.........TO DUPLICATE A FORMULA TO
ANOTHER ....PART OF YOUR WORKSHEET:....
O POSITION THE CAMERA ON THE....FORMULA
AND CLICK THE BUTTON....................
.... ............ 577.50......)..%
......O MOVE THE PASTE JAR TO THE CELL .
...WHERE YOU WANT THE COPIED FORMULA ..
..TO APPEAR AND CLICK THE BUTTON........
................577.50..!.......746.00..
....)..%......THE COPIED FORMULA WILL AP
PEAR IN ....THE SELECTED CELL AND IT'S
RESULT ....WILL BE READJUSTED TO REFLEC
T THE ....VALUES OF THE NEWLY CORRESPON
DING ....CELLS. ......%.................
....................... D....1....2
.
> CLICK IMAGE PREVIEW FOR FULL MODAL