00000000: 00 40 03 01 09 01 0A 03 03 02 1E 0D 00 18 04 01 |.@..............|
00000010: 01 01 25 01 2A 01 01 43 72 65 61 74 69 6E 67 20 |..%.*..Creating |
00000020: 66 6F 72 6D 75 6C 61 73 2E 00 18 05 01 19 03 20 |formulas....... |
00000030: 03 01 01 03 46 6F 72 6D 75 6C 61 73 20 63 6F 6D |....Formulas com|
00000040: 6D 75 6E 69 63 61 74 65 20 74 6F 20 4A 61 6E 65 |municate to Jane|
00000050: 43 61 6C 63 00 01 01 04 68 6F 77 20 74 68 65 20 |Calc....how the |
00000060: 6E 75 6D 62 65 72 73 20 69 6E 20 79 6F 75 72 20 |numbers in your |
00000070: 77 6F 72 6B 73 68 65 65 74 20 00 01 01 05 73 68 |worksheet ....sh|
00000080: 6F 75 6C 64 20 62 65 20 63 6F 6D 62 69 6E 65 64 |ould be combined|
00000090: 20 69 6E 20 6F 72 64 65 72 20 74 6F 20 67 65 74 | in order to get|
000000A0: 00 01 01 06 6D 65 61 6E 69 6E 67 66 75 6C 20 72 |....meaningful r|
000000B0: 65 73 75 6C 74 73 2E 20 00 01 01 08 41 20 66 6F |esults. ....A fo|
000000C0: 72 6D 75 6C 61 20 69 73 20 6D 61 64 65 20 75 70 |rmula is made up|
000000D0: 20 6F 66 20 6E 75 6D 62 65 72 73 20 00 01 01 09 | of numbers ....|
000000E0: 73 65 70 61 72 61 74 65 64 20 62 79 20 61 72 69 |separated by ari|
000000F0: 74 68 6D 65 74 69 63 20 73 79 6D 62 6F 6C 73 2E |thmetic symbols.|
00000100: 20 41 00 01 01 0A 73 79 6D 62 6F 6C 20 74 65 6C | A....symbol tel|
00000110: 6C 73 20 68 6F 77 20 74 68 65 20 6E 75 6D 62 65 |ls how the numbe|
00000120: 72 73 20 6F 6E 20 00 01 01 0B 65 69 74 68 65 72 |rs on ....either|
00000130: 20 73 69 64 65 20 6F 66 20 69 74 20 73 68 6F 75 | side of it shou|
00000140: 6C 64 20 62 65 20 00 01 01 0C 65 76 61 6C 75 61 |ld be ....evalua|
00000150: 74 65 64 2E 00 18 02 01 00 16 25 16 17 08 09 01 |ted.......%.....|
00000160: 02 0F 06 00 01 01 01 42 65 6C 6F 77 20 69 73 20 |.......Below is |
00000170: 61 6E 20 65 78 61 6D 70 6C 65 20 6F 66 20 61 20 |an example of a |
00000180: 66 6F 72 6D 75 6C 61 20 00 01 01 02 77 68 69 63 |formula ....whic|
00000190: 68 20 6D 69 67 68 74 20 62 65 20 75 73 65 64 20 |h might be used |
000001A0: 69 6E 20 66 69 67 75 72 69 6E 67 20 6F 75 74 00 |in figuring out.|
000001B0: 01 01 03 61 20 6D 6F 6E 74 68 6C 79 20 62 75 64 |...a monthly bud|
000001C0: 67 65 74 3A 00 18 01 0F 00 07 25 07 18 01 0F 00 |get:......%.....|
000001D0: 08 01 0C 01 00 07 20 20 20 20 41 20 20 20 20 20 |...... A |
000001E0: 20 20 20 20 42 20 20 20 20 20 20 20 20 20 43 20 | B C |
000001F0: 20 20 20 20 20 20 20 20 44 00 01 00 08 31 00 01 | D....1..|
00000200: 00 09 32 00 01 00 0A 33 00 01 00 0B 34 00 01 00 |..2....3....4...|
00000210: 0C 35 00 01 00 06 3E 42 31 2D 73 75 6D 28 42 32 |.5....>B1-sum(B2|
00000220: 3A 42 35 29 20 20 20 20 00 01 02 08 4E 65 74 20 |:B5) ....Net |
00000230: 50 61 79 20 20 20 20 39 30 30 2E 30 30 00 01 02 |Pay 900.00...|
00000240: 09 52 65 6E 74 20 20 20 20 20 20 20 31 39 35 2E |.Rent 195.|
00000250: 30 30 00 01 02 0A 46 6F 6F 64 20 20 20 20 20 20 |00....Food |
00000260: 20 20 39 35 2E 30 30 00 01 02 0B 47 61 73 20 20 | 95.00....Gas |
00000270: 20 20 20 20 20 20 20 33 35 2E 30 30 00 01 02 0C | 35.00....|
00000280: 50 68 6F 6E 65 20 20 20 20 20 20 20 33 30 2E 30 |Phone 30.0|
00000290: 30 00 01 01 0E 54 68 65 20 61 62 6F 76 65 20 66 |0....The above f|
000002A0: 6F 72 6D 75 6C 61 20 6D 65 61 6E 73 20 74 68 61 |ormula means tha|
000002B0: 74 2C 20 61 66 74 65 72 20 00 18 05 01 0B 0F 0B |t, after .......|
000002C0: 0F 01 01 0F 73 65 6C 65 63 74 69 6E 67 20 3D 2C |....selecting =,|
000002D0: 20 74 68 65 20 69 6E 64 69 76 69 64 75 61 6C 20 | the individual |
000002E0: 61 6D 6F 75 6E 74 73 20 00 01 01 10 66 6F 72 20 |amounts ....for |
000002F0: 52 65 6E 74 2C 20 66 6F 75 6E 64 20 69 6E 20 74 |Rent, found in t|
00000300: 68 65 20 63 65 6C 6C 20 6E 61 6D 65 64 20 42 32 |he cell named B2|
00000310: 00 01 01 11 28 63 6F 6C 75 6D 6E 20 42 2C 20 72 |....(column B, r|
00000320: 6F 77 20 32 29 2C 20 46 6F 6F 64 20 28 42 33 29 |ow 2), Food (B3)|
00000330: 2C 20 47 61 73 20 00 01 01 12 28 42 34 29 2C 20 |, Gas ....(B4), |
00000340: 61 6E 64 20 50 68 6F 6E 65 20 28 42 35 29 20 77 |and Phone (B5) w|
00000350: 69 6C 6C 20 62 65 20 00 01 01 13 74 6F 74 61 6C |ill be ....total|
00000360: 6C 65 64 20 61 6E 64 20 74 68 61 74 20 74 6F 74 |led and that tot|
00000370: 61 6C 20 61 6D 6F 75 6E 74 20 77 69 6C 6C 20 00 |al amount will .|
00000380: 01 01 14 62 65 20 73 75 62 74 72 61 63 74 65 64 |...be subtracted|
00000390: 20 66 72 6F 6D 20 4E 65 74 20 50 61 79 20 28 42 | from Net Pay (B|
000003A0: 31 29 2E 20 00 18 02 01 00 16 25 16 17 08 09 01 |1). ......%.....|
000003B0: 02 11 0F 00 01 01 01 54 6F 20 63 72 65 61 74 65 |.......To create|
000003C0: 20 61 20 66 6F 72 6D 75 6C 61 20 75 73 69 6E 67 | a formula using|
000003D0: 20 6E 75 6D 62 65 72 73 00 01 01 02 77 68 69 63 | numbers....whic|
000003E0: 68 20 61 72 65 20 61 6C 72 65 61 64 79 20 69 6E |h are already in|
000003F0: 20 79 6F 75 72 20 77 6F 72 6B 73 68 65 65 74 3A | your worksheet:|
00000400: 00 18 05 01 01 04 25 08 01 01 04 31 29 20 50 6F |......%....1) Po|
00000410: 73 69 74 69 6F 6E 20 74 68 65 20 48 61 6E 64 20 |sition the Hand |
00000420: 6F 6E 20 74 68 65 20 66 69 72 73 74 20 00 01 04 |on the first ...|
00000430: 05 6E 75 6D 62 65 72 20 74 6F 20 62 65 20 75 73 |.number to be us|
00000440: 65 64 20 69 6E 20 74 68 65 20 66 6F 72 6D 75 6C |ed in the formul|
00000450: 61 00 01 04 06 61 6E 64 20 63 6C 69 63 6B 20 74 |a....and click t|
00000460: 68 65 20 6A 6F 79 73 74 69 63 6B 20 62 75 74 74 |he joystick butt|
00000470: 6F 6E 2E 20 00 01 04 07 54 68 65 20 63 65 6C 6C |on. ....The cell|
00000480: 20 6E 61 6D 65 20 77 69 6C 6C 20 61 70 70 65 61 | name will appea|
00000490: 72 20 6F 6E 20 74 68 65 20 00 01 04 08 44 69 73 |r on the ....Dis|
000004A0: 70 6C 61 79 20 42 61 72 20 61 62 6F 76 65 20 74 |play Bar above t|
000004B0: 68 65 20 77 6F 72 6B 73 68 65 65 74 2E 00 18 01 |he worksheet....|
000004C0: 0F 00 0B 25 0B 18 01 0F 00 0C 01 13 01 00 0B 20 |...%........... |
000004D0: 20 20 20 41 20 20 20 20 20 20 20 20 42 20 20 20 | A B |
000004E0: 20 20 20 20 20 20 43 20 20 20 20 20 20 20 20 20 | C |
000004F0: 44 20 20 20 20 20 00 01 00 0C 31 00 01 00 0D 32 |D ....1....2|
00000500: 00 01 00 0E 33 00 01 00 0F 34 00 01 00 10 35 00 |....3....4....5.|
00000510: 01 00 11 36 00 01 00 12 37 00 01 00 13 38 00 01 |...6....7....8..|
00000520: 00 0A 3E 42 34 00 01 02 0D 53 74 75 64 65 6E 74 |..>B4....Student|
00000530: 20 42 75 64 67 65 74 00 01 02 0F 42 72 65 61 64 | Budget....Bread|
00000540: 20 20 20 20 20 31 30 30 2E 30 30 20 20 20 20 20 | 100.00 |
00000550: 20 00 01 02 10 57 61 74 65 72 20 20 20 20 20 20 | ....Water |
00000560: 20 35 2E 30 30 00 01 02 11 42 6F 6F 6B 73 20 20 | 5.00....Books |
00000570: 20 20 20 33 35 30 2E 30 30 00 01 02 13 54 6F 74 | 350.00....Tot|
00000580: 61 6C 00 18 02 01 00 16 25 16 17 08 02 0A 14 00 |al......%.......|
00000590: 09 01 18 05 01 01 01 25 02 18 0C 01 01 04 25 08 |.......%......%.|
000005A0: 01 01 01 32 29 20 53 65 6C 65 63 74 20 6F 6E 65 |...2) Select one|
000005B0: 20 6F 66 20 74 68 65 20 73 79 6D 62 6F 6C 73 20 | of the symbols |
000005C0: 61 6C 6F 6E 67 20 00 01 04 02 74 68 65 20 62 6F |along ....the bo|
000005D0: 74 74 6F 6D 20 6F 66 20 74 68 65 20 73 63 72 65 |ttom of the scre|
000005E0: 65 6E 2E 00 18 01 0F 00 06 25 06 18 01 0F 00 07 |en.......%......|
000005F0: 01 10 01 00 06 20 20 20 20 41 20 20 20 20 20 20 |..... A |
00000600: 20 20 42 20 20 20 20 20 20 20 20 20 43 20 20 20 | B C |
00000610: 20 20 20 20 20 20 44 20 20 20 20 20 00 01 00 07 | D ....|
00000620: 31 00 01 00 08 32 00 01 00 09 33 00 01 00 0A 34 |1....2....3....4|
00000630: 00 01 00 0B 35 00 01 00 0C 36 00 01 00 0D 37 00 |....5....6....7.|
00000640: 01 00 0E 38 00 01 00 0F 39 00 01 00 10 31 30 00 |...8....9....10.|
00000650: 01 00 05 3E 42 34 00 01 02 08 53 74 75 64 65 6E |...>B4....Studen|
00000660: 74 20 42 75 64 67 65 74 00 01 02 0A 42 72 65 61 |t Budget....Brea|
00000670: 64 20 20 20 20 20 31 30 30 2E 30 30 20 20 20 20 |d 100.00 |
00000680: 20 20 00 01 02 0B 57 61 74 65 72 20 20 20 20 20 | ....Water |
00000690: 20 20 35 2E 30 30 00 01 02 0C 42 6F 6F 6B 73 20 | 5.00....Books |
000006A0: 20 20 20 20 33 35 30 2E 30 30 00 01 02 0E 54 6F | 350.00....To|
000006B0: 74 61 6C 00 18 05 01 00 14 25 15 05 00 14 3E 0C |tal......%....>.|
000006C0: 05 03 14 05 0D 05 09 14 3E 00 05 0C 14 3E 01 05 |........>....>..|
000006D0: 0F 14 3E 02 05 12 14 3E 03 05 15 14 3E 04 05 18 |..>....>....>...|
000006E0: 14 0D 0A 05 19 14 0D 0B 05 1B 14 02 05 05 1F 14 |................|
000006F0: 02 06 05 23 14 02 07 18 02 01 00 16 25 16 17 08 |...#........%...|
00000700: 02 11 10 00 09 01 18 05 01 01 01 25 06 01 01 01 |...........%....|
00000710: 33 29 20 53 65 6C 65 63 74 20 74 68 65 20 6E 65 |3) Select the ne|
00000720: 78 74 20 6E 75 6D 62 65 72 20 74 6F 20 62 65 20 |xt number to be |
00000730: 75 73 65 64 00 01 04 02 69 6E 20 74 68 65 20 66 |used....in the f|
00000740: 6F 72 6D 75 6C 61 2E 20 20 54 68 65 20 73 65 6C |ormula. The sel|
00000750: 65 63 74 65 64 20 00 01 04 03 73 79 6D 62 6F 6C |ected ....symbol|
00000760: 2C 20 66 6F 6C 6C 6F 77 65 64 20 62 79 20 74 68 |, followed by th|
00000770: 65 20 63 65 6C 6C 20 6E 61 6D 65 2C 20 00 01 04 |e cell name, ...|
00000780: 04 77 69 6C 6C 20 61 70 70 65 61 72 20 6F 6E 20 |.will appear on |
00000790: 74 68 65 20 44 69 73 70 6C 61 79 20 42 61 72 20 |the Display Bar |
000007A0: 00 01 04 05 74 6F 20 74 68 65 20 72 69 67 68 74 |....to the right|
000007B0: 20 6F 66 20 74 68 65 20 6E 61 6D 65 20 6F 66 20 | of the name of |
000007C0: 74 68 65 20 00 01 04 06 70 72 65 76 69 6F 75 73 |the ....previous|
000007D0: 6C 79 20 73 65 6C 65 63 74 65 64 20 63 65 6C 6C |ly selected cell|
000007E0: 2E 00 18 01 0F 00 0B 25 0B 18 01 0F 00 0C 01 13 |.......%........|
000007F0: 01 00 0B 20 20 20 20 41 20 20 20 20 20 20 20 20 |... A |
00000800: 42 20 20 20 20 20 20 20 20 20 43 20 20 20 20 20 |B C |
00000810: 20 20 20 20 44 20 20 20 20 20 20 20 20 20 45 20 | D E |
00000820: 20 20 20 20 20 20 20 20 46 20 20 20 20 20 00 01 | F ..|
00000830: 00 0C 31 00 01 00 0D 32 00 01 00 0E 33 00 01 00 |..1....2....3...|
00000840: 0F 34 00 01 00 10 35 00 01 00 11 36 00 01 00 12 |.4....5....6....|
00000850: 37 00 01 00 13 38 00 01 00 0A 3E 42 34 2B 42 35 |7....8....>B4+B5|
00000860: 00 01 02 0D 53 74 75 64 65 6E 74 20 42 75 64 67 |....Student Budg|
00000870: 65 74 00 01 02 0F 42 72 65 61 64 20 20 20 20 20 |et....Bread |
00000880: 31 30 30 2E 30 30 20 20 20 20 20 20 00 01 02 10 |100.00 ....|
00000890: 57 61 74 65 72 20 20 20 20 20 20 20 35 2E 30 30 |Water 5.00|
000008A0: 00 01 02 11 42 6F 6F 6B 73 20 20 20 20 20 33 35 |....Books 35|
000008B0: 30 2E 30 30 00 01 02 13 54 6F 74 61 6C 00 18 02 |0.00....Total...|
000008C0: 01 00 16 25 16 17 08 03 02 02 0D 13 00 09 01 18 |...%............|
000008D0: 05 01 01 01 25 08 01 01 01 34 29 20 52 65 70 65 |....%....4) Repe|
000008E0: 61 74 20 73 74 65 70 73 20 31 29 20 2D 20 33 29 |at steps 1) - 3)|
000008F0: 20 74 6F 20 63 6F 6D 70 6C 65 74 65 00 01 04 02 | to complete....|
00000900: 74 68 65 20 66 6F 72 6D 75 6C 61 2E 00 01 01 04 |the formula.....|
00000910: 35 29 20 53 65 6C 65 63 74 20 3D 20 74 6F 20 67 |5) Select = to g|
00000920: 65 74 20 74 68 65 20 72 65 73 75 6C 74 20 6F 66 |et the result of|
00000930: 20 74 68 65 20 00 01 04 05 66 6F 72 6D 75 6C 61 | the ....formula|
00000940: 2E 20 20 54 68 65 20 48 61 6E 64 20 63 68 61 6E |. The Hand chan|
00000950: 67 65 73 20 69 6E 74 6F 20 00 01 04 06 74 68 65 |ges into ....the|
00000960: 20 49 6E 73 65 72 74 20 41 72 72 6F 77 2C 20 61 | Insert Arrow, a|
00000970: 6C 6C 6F 77 69 6E 67 20 79 6F 75 20 74 6F 20 20 |llowing you to |
00000980: 00 01 04 07 22 69 6E 73 65 72 74 22 20 74 68 65 |...."insert" the|
00000990: 20 72 65 73 75 6C 74 20 61 6E 79 77 68 65 72 65 | result anywhere|
000009A0: 20 6F 6E 20 00 01 04 08 74 68 65 20 77 6F 72 6B | on ....the work|
000009B0: 73 68 65 65 74 2C 20 69 66 20 64 65 73 69 72 65 |sheet, if desire|
000009C0: 64 2E 00 18 01 0F 00 0B 25 0B 18 01 0F 00 0C 01 |d.......%.......|
000009D0: 13 01 00 0B 20 20 20 20 41 20 20 20 20 20 20 20 |.... A |
000009E0: 20 42 20 20 20 20 20 20 20 20 20 43 20 20 20 20 | B C |
000009F0: 20 20 20 20 20 44 00 01 00 0C 31 00 01 00 0D 32 | D....1....2|
00000A00: 00 01 00 0E 33 00 01 00 0F 34 00 01 00 10 35 00 |....3....4....5.|
00000A10: 01 00 11 36 00 01 00 12 37 00 01 00 13 38 00 01 |...6....7....8..|
00000A20: 00 0A 3E 42 34 2B 42 35 2B 42 36 20 3D 20 34 35 |..>B4+B5+B6 = 45|
00000A30: 35 2E 30 30 00 01 02 0D 53 74 75 64 65 6E 74 20 |5.00....Student |
00000A40: 42 75 64 67 65 74 00 01 02 0F 42 72 65 61 64 20 |Budget....Bread |
00000A50: 20 20 20 20 31 30 30 2E 30 30 20 20 20 20 20 20 | 100.00 |
00000A60: 00 01 02 10 57 61 74 65 72 20 20 20 20 20 20 20 |....Water |
00000A70: 35 2E 30 30 00 01 02 11 42 6F 6F 6B 73 20 20 20 |5.00....Books |
00000A80: 20 20 33 35 30 2E 30 30 00 01 02 13 54 6F 74 61 | 350.00....Tota|
00000A90: 6C 20 20 20 20 20 20 20 20 20 20 00 18 02 01 00 |l .....|
00000AA0: 16 25 16 17 00 00 00 00 00 00 00 00 00 00 00 00 |.%..............|
00000AB0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
00000AC0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
00000AD0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
00000AE0: 00 00 00 00 00 00 00 00 00 00 00 00 1A 00 00 00 |................|
00000AF0: 95 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
00000B00: 00 |. |
.@................%.*..CREATING FORMULAS
....... ....FORMULAS COMMUNICATE TO JANE
CALC....HOW THE NUMBERS IN YOUR WORKSHEE
T ....SHOULD BE COMBINED IN ORDER TO GET
....MEANINGFUL RESULTS. ....A FORMULA IS
MADE UP OF NUMBERS ....SEPARATED BY ARI
THMETIC SYMBOLS. A....SYMBOL TELLS HOW T
HE NUMBERS ON ....EITHER SIDE OF IT SHOU
LD BE ....EVALUATED.......%............B
ELOW IS AN EXAMPLE OF A FORMULA ....WHIC
H MIGHT BE USED IN FIGURING OUT....A MON
THLY BUDGET:......%........... A
B C D....1....2....3
....4....5....>B1-SUM(B2:B5) ....NET
PAY 900.00....RENT 195.00....FO
OD 95.00....GAS 35.00....
PHONE 30.00....THE ABOVE FORMULA M
EANS THAT, AFTER ...........SELECTING =,
THE INDIVIDUAL AMOUNTS ....FOR RENT, FO
UND IN THE CELL NAMED B2....(COLUMN B, R
OW 2), FOOD (B3), GAS ....(B4), AND PHON
E (B5) WILL BE ....TOTALLED AND THAT TOT
AL AMOUNT WILL ....BE SUBTRACTED FROM NE
T PAY (B1). ......%............TO CREATE
A FORMULA USING NUMBERS....WHICH ARE AL
READY IN YOUR WORKSHEET:......%....1) PO
SITION THE HAND ON THE FIRST ....NUMBER
TO BE USED IN THE FORMULA....AND CLICK T
HE JOYSTICK BUTTON. ....THE CELL NAME WI
LL APPEAR ON THE ....DISPLAY BAR ABOVE T
HE WORKSHEET.......%........... A
B C D ....1....2
....3....4....5....6....7....8....>B4...
.STUDENT BUDGET....BREAD 100.00
....WATER 5.00....BOOKS 350.0
0....TOTAL......%..............%......%.
...2) SELECT ONE OF THE SYMBOLS ALONG ..
..THE BOTTOM OF THE SCREEN.......%......
..... A B C D
....1....2....3....4....5....6....7.
...8....9....10....>B4....STUDENT BUDGET
....BREAD 100.00 ....WATER
5.00....BOOKS 350.00....TOTAL.....
.%....>.........>....>....>....>....>...
...................#........%...........
...%....3) SELECT THE NEXT NUMBER TO BE
USED....IN THE FORMULA. THE SELECTED ..
..SYMBOL, FOLLOWED BY THE CELL NAME, ...
.WILL APPEAR ON THE DISPLAY BAR ....TO T
HE RIGHT OF THE NAME OF THE ....PREVIOUS
LY SELECTED CELL.......%........... A
B C D E
F ....1....2....3....4....5.
...6....7....8....>B4+B5....STUDENT BUDG
ET....BREAD 100.00 ....WATER
5.00....BOOKS 350.00....TOTAL...
...%................%....4) REPEAT STEPS
1) - 3) TO COMPLETE....THE FORMULA.....
5) SELECT = TO GET THE RESULT OF THE ...
.FORMULA. THE HAND CHANGES INTO ....THE
INSERT ARROW, ALLOWING YOU TO ...."INS
ERT" THE RESULT ANYWHERE ON ....THE WORK
SHEET, IF DESIRED.......%...........
A B C D....1....2
....3....4....5....6....7....8....>B4+B5
+B6 = 455.00....STUDENT BUDGET....BREAD
100.00 ....WATER 5.00....
BOOKS 350.00....TOTAL .....
.%......................................
........................................
.................
×
C64 Image
> CLICK IMAGE PREVIEW FOR FULL MODAL