CALC05
FILE INFORMATION
FILENAME(S): CALC05
FILE TYPE(S): PRG
FILE SIZE: 2.5K
FIRST SEEN: 2025-11-30 21:12:46
APPEARS ON: 1 disk(s)
FILE HASH
49234defbef01a07a17b3b007ca5d066fb3b02d3e1ccb1cf6db3e04ac42eabc8
FOUND ON DISKS (1 DISKS)
| DISK TITLE | FILENAME | FILE TYPE | COLLECTION | TRACK | SECTOR | ACTIONS |
|---|---|---|---|---|---|---|
| HELP | CALC05 | PRG | DuncanTwain | 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 6F 6F 1C BE 9E 17 1E BE 9E 10 B9 1E B1 |...oo...........|
00000210: BC 6E 61 6C 2C 20 62 75 74 20 72 65 6C 61 74 6F |.nal, but relato|
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 6F 10 B5 8E 1E B5 8E |new locato......|
00000240: 17 1E BE FE EE FE E7 BB B0 B9 1C B9 BE BE BE B7 |................|
00000250: 85 EE EE F8 EE FE EB 8E FB EB FE FE FE F8 8E FF |................|
00000260: EE EE FE FE FE FE 9E F0 FE FE FE 99 8C 20 41 6E |............. An|
00000270: 6F 74 68 6E 5E EF 4D 53 4F EE EF C6 E4 80 EE 9E |othn^.MSO.......|
00000280: BD 7E 2F BF 2C 1E 2F ED 3D FB 0B 99 EE EE EF EE |.~/.,./.=.......|
00000290: 81 71 EB EB 78 E1 EB 91 52 07 26 56 66 57 26 56 |.q..x...R.&VfW&V|
000002A0: E6 36 56 DE FE 75 EC E8 0B AA 6D A8 09 49 69 F8 |.6V..u....m..Ii.|
000002B0: 88 C8 90 4A 6B A8 0D A9 E9 E8 0E 49 4B 69 E8 0E |...Jk......IKi..|
000002C0: 0A 6E E8 0A 6E 08 0A 4A 69 6D EB 6B A8 09 4B A9 |.n..n..Jim.k..K.|
000002D0: A8 88 88 C8 98 AA 6B A9 6E E8 0D A9 E9 E8 0A AA |......k.n.......|
000002E0: 6E 0B 6D E9 69 48 0A 49 EF 10 A2 06 F7 32 06 36 |n.m.iH.I.....2.6|
000002F0: F7 06 96 56 42 E0 00 10 40 60 49 6E 20 74 68 69 |...VB...@`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 F5 73 20 72 6E 5E 4E C6 DA E4 |produc.s rn^N...|
00000520: 80 E4 BE B6 A6 F1 01 72 20 74 6F 20 00 01 04 0B |.......r to ....|
00000530: 4D E3 EE EF CC C3 5E 5E 4D EF 4D 53 4F EE EF C1 |M.....^^M.MSO...|
00000540: CC EF CC C1 5E CB 4E EB E7 EE EE E6 EE FF CA DE |....^.N.........|
00000550: D0 BC FC ED 2D BF 6C FC 7E 2F F0 BA 80 DA 9E 94 |....-.l.~/......|
00000560: DA 80 DA 9E FE 80 A4 A6 D0 BC 3D 78 EE EE EF EE |..........=x....|
00000570: CB 11 0B 91 4B 7B EB E9 E1 C7 32 06 A7 57 37 42 |....K{....2..W7B|
00000580: 06 EA 6B 49 E8 0D A9 EB E2 22 22 A3 23 CF CE FF |..kI....."".#...|
00000590: CF D6 B5 1E BC 8E 9E 18 17 B7 8E 19 1E BC 61 74 |..............at|
000005A0: 69 76 65 20 74 6F 20 74 68 65 20 00 01 04 0D 6E |ive to the ....n|
000005B0: 6E 55 EF EB C1 CE E7 4D C0 6F 6E 20 69 6E 20 74 |nU.....M.on in t|
000005C0: 68 FE 9E 1B B0 B9 1C B9 BE A3 D3 DB E7 22 2A 03 |h............"*.|
000005D0: 02 A2 AA E3 AA AA 03 A2 A2 0F 03 0A 22 A2 AA 3E |............"..>|
000005E0: D3 D0 6E EC E4 DE FE FE FE FE FE FC EE EC 1C 15 |..n.............|
000005F0: 5E F4 DC 1E 20 73 65 65 20 61 6E 20 61 6E 69 6D |^... 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 6F |eet:....o Posito|
00000800: 10 B5 8E 17 1E BE 9E E8 BE B4 BE B9 1E 9E 10 B5 |................|
00000810: 8E 17 1E BE FE EE F8 FE B1 10 B9 14 B7 BE BE 9E |................|
00000820: 1E B5 1E 8E 18 BC 6F 63 6B 20 74 68 65 20 62 75 |......ock 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 FE |......o Move th.|
00000880: 9E EF 1E B9 B7 1E 9E EC 1E B9 8E 17 10 9E 17 1E |................|
00000890: BE 9E 18 BE BE BC 20 00 01 03 05 77 68 6E 5E EE |...... ....whn^.|
000008A0: EF 53 C1 4E EF 55 E7 CD 4D EF 4D E3 EE EF CE C1 |.S.N.U..M.M.....|
000008B0: 4F C1 05 64 20 66 6F 72 6D 75 6B 01 20 20 00 01 |O..d formuk. ..|
000008C0: 03 06 74 6F 20 61 70 70 65 61 72 20 61 6E 64 20 |..to appear and |
000008D0: 63 6B C0 63 6B 20 74 68 65 20 62 75 74 74 6F 6E |ck.ck 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 6B EE ED EF CC C1 5E CB 4E C6 E7 |e copk.....^.N..|
00000930: EF 55 C1 0B CF EF E7 4F 4F CE 94 E0 80 BE BA 80 |.U.....OO.......|
00000940: 88 88 8C 8C 00 DA 9E 9E 80 E4 9E 96 9E A4 DA 9E |................|
00000950: 9A 80 A4 9E 96 96 80 94 BA 9A 80 BC BE FD EE 2F |.............../|
00000960: EF 3D ED BD 1C BE 2E 22 22 2A 2A ED DD FC 1C 10 |.=.....""**.....|
00000970: 80 A0 9E 80 E0 9E 94 9A B0 DE E4 DA 9E 9A 80 DA |................|
00000980: A6 80 E0 9E AA BC 8E A4 DA 80 DA 9E EE EF EE EE |................|
00000990: E6 E6 ED 5C E7 EB 4E EE 5E EF C1 CC EF 4D E3 EE |...\..N.^....M..|
000009A0: EF CD EE 55 C6 EE 80 A4 A6 E0 E0 9E E4 D0 A6 BA |...U............|
000009B0: 9A BE BA AE 88 88 8C 8C 8E A4 9E 96 96 E4 1A 88 |................|
000009C0: 88 CE 08 8C 88 4A 8D 49 4D 88 88 88 88 88 88 88 |.....J.IM.......|
000009D0: 88 88 88 88 88 88 88 88 88 88 88 88 88 88 88 88 |................|
000009E0: 88 88 88 88 88 88 88 88 88 88 88 80 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 ....OO...
.........NAL, BUT RELATOVE ....TO IT'S
NEW LOCATO..............................
..................... ANOTHN^.MSO..F....
.~/.,./.=........Q..X...R.&VFW&V.6V..U..
..M..II..H.JK......IKI...N..N..JIM.K..K.
...H..K.N.......N.M.IH.I.....2.6...VB...
@`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 PRODUC.S RN^NFZ........R
TO ....M...LC^^M.MSO..AL.LA^KN.......J.
P...-.L.~/...Z..Z.Z.....P.=X....K...K{..
.G2..W7B..KI....."".#ON.OV............AT
IVE TO THE ....NNU..AN.M.ON IN TH.......
..S.."*............."..>SPN.............
^... 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 POSITO................................
......OCK THE BUTTON....................
.... ............ 577.50......)..%
......O MOVE TH....................... .
...WHN^..SAN.U.MM.M...NAOA.D FORMUK. ..
..TO APPEAR AND CK.CK THE BUTTON........
................577.50..!.......746.00..
....)..%......THE COPK...LA^KNF..UA.O..O
ON...........Z........Z................/
.=.....""**...... .........Z...Z........
Z.Z........\..N.^.AL.M...M.UF........P..
.................N...J.IM...............
....................... D....1....2
.
> CLICK IMAGE PREVIEW FOR FULL MODAL