Home » Archimedes archive » Zipped Apps » Fireworkz » Custom/Fri13/Readme
Custom/Fri13/Readme
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 » Fireworkz |
Filename: | Custom/Fri13/Readme |
Read OK: | ✔ |
File size: | 0DDF bytes |
Load address: | 0000 |
Exec address: | 0000 |
File contents
{Version:1.03/58;17 Aug 1993;Resultz;Colton Software;6000 1072 7816 4111} {Block:0;0;;32;1;19;;32;1;19} {Style:BaseLetter;{ColWidth:11180}{ColName:#}{RowHeight:0}{RowHeightFix:0}{RowUnbreakable:0}{RowName:#}{MarginLeft:1190}{MarginRight:1032}{MarginPara:0}{Tablist:R793 L1135 L2269 L3403 L4537 L5671 L6805 L7939 L9073}{Background:255;255;255}{ParaStart:68}{ParaEnd:45}{LineSpace:0;72}{Justify:0}{NewObject:3}{Numform:#,##0.00}{NumformDT:dd.mm.yy}{NumformSE:@}{BorderColour:0;187;255}{Border:0}{GridLeftColour:0;187;255}{GridTopColour:0;187;255}{GridRightColour:0;187;255}{GridBottomColour:0;187;255}{GridLeft:0}{GridTop:0}{GridRight:0}{GridBottom:0}{Typeface:Times}{Fontx:0}{Fonty:280}{Underline:0}{Bold:0}{Italic:0}{Superscript:0}{Subscript:0}{Foreground:0;0;0}} {Style:BaseHeadFoot} {Style:Heading;{Justify:1}{Typeface:Times}{Fonty:480}{Bold:1}} {Style:Indent;{MarginLeft:1814}{MarginRight:845}{MarginPara:-567}{Tablist:L1}} {StyleBase:BaseLetter} {StyleHeaderFooter:BaseHeadFoot} {Paper:Default A4;0;16840;11900;460;460;360;360;0;0;0;0;32;;0} {PrintQuality:0} {StartOfData} {S:X;X;0;1;Friday 13th} {S:X;X;0;3;The files in this directory give a solution to the Friday 13th problem as posed in PipeLine many moons ago.} {S:X;X;0;4;The problem is to "prove" that the 13th of a month is more likely to be a Friday than any other particular day. } {S:X;X;0;5;This curious fact relies on (i) the modern calendar working in a 400-year cycle and (ii) the number of days in 400 years happens to be exactly divisible by 7. This implies that if 13th August 1993 is a Friday then 13th August 2393 will also be a Friday. Further, the pattern of Friday 13ths in the 400 years from 13th August 1993 to 12th August 2393 will be exactly the same as the pattern of Friday 13ths in the following 400 years. (This ignores any changes to the calendar in the next 400 years....)} {S:X;X;0;6;So the task is to count the number of Friday 13ths in a 400 year period and show that there are more Friday 13ths than Thursday 13ths or Wednesday 13ths and so on.} {S:X;X;0;7;Cell A5 in the worksheet Fri13 invokes the custom function and displays the results in column C. c_Fri13 contains the custom function itself. While it is calculating you will see a date updating in cell D2 and the intermediate values in column E. When the function finishes its calculation the totals are returned to the calling sheet which displays them in column C. (These will be the same as the previous values in column C as the custom function gives the same answer every time it recalculates and the values are saved with the worksheet.)} {S:X;X;0;8;The custom function works by finding the day of the week (weekday) of each 13th for 4800 consecutive months. The set_value in cell A9 uses the weekday as in index into the table and increments the value it finds there.} {S:X;X;0;11;Colton Software} {S:X;X;0;12;Friday 13th August 1993} {S:X;X;0;15;(By the way, if you're reading this Gerald, I still claim my mug for the "best" solution...)} {BR:;;;;;;;;1;1;{StyleHandle:BaseLetter}} {BR:;;;;;;;;1;1;{ColWidth:0}} {BR:0;;;;1;;;;1;0;{StyleHandle:BaseLetter}} {R:0;1;;32;1;2;;32;0;0;{StyleHandle:Heading}} {PageHefoBreakValues-H:0;0;0;;1;396;0;0;;;0;;;1;0;228;0;;;0} {HD-H:0;2} {HBR-H:0;2;;32;;32;{StyleHandle:BaseLetter}} {HBR-H:0;2;;32;;32;{StyleHandle:BaseHeadFoot}} {HD-H:0;3} {HBR-H:0;3;;32;;32;{StyleHandle:BaseLetter}} {HBR-H:0;3;;32;;32;{StyleHandle:BaseHeadFoot}} {EndOfData} {CmdGroup:{ViewCreate:0;10912;11760;9920} {ViewControl:100;2;0;0;0;0;0;2048;0;2048} {CurrentPosition:0;3;0;3} }
00000000 7b 56 65 72 73 69 6f 6e 3a 31 2e 30 33 2f 35 38 |{Version:1.03/58| 00000010 3b 31 37 20 41 75 67 20 31 39 39 33 3b 52 65 73 |;17 Aug 1993;Res| 00000020 75 6c 74 7a 3b 43 6f 6c 74 6f 6e 20 53 6f 66 74 |ultz;Colton Soft| 00000030 77 61 72 65 3b 36 30 30 30 20 31 30 37 32 20 37 |ware;6000 1072 7| 00000040 38 31 36 20 34 31 31 31 7d 0a 7b 42 6c 6f 63 6b |816 4111}.{Block| 00000050 3a 30 3b 30 3b 3b 33 32 3b 31 3b 31 39 3b 3b 33 |:0;0;;32;1;19;;3| 00000060 32 3b 31 3b 31 39 7d 0a 7b 53 74 79 6c 65 3a 42 |2;1;19}.{Style:B| 00000070 61 73 65 4c 65 74 74 65 72 3b 7b 43 6f 6c 57 69 |aseLetter;{ColWi| 00000080 64 74 68 3a 31 31 31 38 30 7d 7b 43 6f 6c 4e 61 |dth:11180}{ColNa| 00000090 6d 65 3a 23 7d 7b 52 6f 77 48 65 69 67 68 74 3a |me:#}{RowHeight:| 000000a0 30 7d 7b 52 6f 77 48 65 69 67 68 74 46 69 78 3a |0}{RowHeightFix:| 000000b0 30 7d 7b 52 6f 77 55 6e 62 72 65 61 6b 61 62 6c |0}{RowUnbreakabl| 000000c0 65 3a 30 7d 7b 52 6f 77 4e 61 6d 65 3a 23 7d 7b |e:0}{RowName:#}{| 000000d0 4d 61 72 67 69 6e 4c 65 66 74 3a 31 31 39 30 7d |MarginLeft:1190}| 000000e0 7b 4d 61 72 67 69 6e 52 69 67 68 74 3a 31 30 33 |{MarginRight:103| 000000f0 32 7d 7b 4d 61 72 67 69 6e 50 61 72 61 3a 30 7d |2}{MarginPara:0}| 00000100 7b 54 61 62 6c 69 73 74 3a 52 37 39 33 20 4c 31 |{Tablist:R793 L1| 00000110 31 33 35 20 4c 32 32 36 39 20 4c 33 34 30 33 20 |135 L2269 L3403 | 00000120 4c 34 35 33 37 20 4c 35 36 37 31 20 4c 36 38 30 |L4537 L5671 L680| 00000130 35 20 4c 37 39 33 39 20 4c 39 30 37 33 7d 7b 42 |5 L7939 L9073}{B| 00000140 61 63 6b 67 72 6f 75 6e 64 3a 32 35 35 3b 32 35 |ackground:255;25| 00000150 35 3b 32 35 35 7d 7b 50 61 72 61 53 74 61 72 74 |5;255}{ParaStart| 00000160 3a 36 38 7d 7b 50 61 72 61 45 6e 64 3a 34 35 7d |:68}{ParaEnd:45}| 00000170 7b 4c 69 6e 65 53 70 61 63 65 3a 30 3b 37 32 7d |{LineSpace:0;72}| 00000180 7b 4a 75 73 74 69 66 79 3a 30 7d 7b 4e 65 77 4f |{Justify:0}{NewO| 00000190 62 6a 65 63 74 3a 33 7d 7b 4e 75 6d 66 6f 72 6d |bject:3}{Numform| 000001a0 3a 23 2c 23 23 30 2e 30 30 7d 7b 4e 75 6d 66 6f |:#,##0.00}{Numfo| 000001b0 72 6d 44 54 3a 64 64 2e 6d 6d 2e 79 79 7d 7b 4e |rmDT:dd.mm.yy}{N| 000001c0 75 6d 66 6f 72 6d 53 45 3a 40 7d 7b 42 6f 72 64 |umformSE:@}{Bord| 000001d0 65 72 43 6f 6c 6f 75 72 3a 30 3b 31 38 37 3b 32 |erColour:0;187;2| 000001e0 35 35 7d 7b 42 6f 72 64 65 72 3a 30 7d 7b 47 72 |55}{Border:0}{Gr| 000001f0 69 64 4c 65 66 74 43 6f 6c 6f 75 72 3a 30 3b 31 |idLeftColour:0;1| 00000200 38 37 3b 32 35 35 7d 7b 47 72 69 64 54 6f 70 43 |87;255}{GridTopC| 00000210 6f 6c 6f 75 72 3a 30 3b 31 38 37 3b 32 35 35 7d |olour:0;187;255}| 00000220 7b 47 72 69 64 52 69 67 68 74 43 6f 6c 6f 75 72 |{GridRightColour| 00000230 3a 30 3b 31 38 37 3b 32 35 35 7d 7b 47 72 69 64 |:0;187;255}{Grid| 00000240 42 6f 74 74 6f 6d 43 6f 6c 6f 75 72 3a 30 3b 31 |BottomColour:0;1| 00000250 38 37 3b 32 35 35 7d 7b 47 72 69 64 4c 65 66 74 |87;255}{GridLeft| 00000260 3a 30 7d 7b 47 72 69 64 54 6f 70 3a 30 7d 7b 47 |:0}{GridTop:0}{G| 00000270 72 69 64 52 69 67 68 74 3a 30 7d 7b 47 72 69 64 |ridRight:0}{Grid| 00000280 42 6f 74 74 6f 6d 3a 30 7d 7b 54 79 70 65 66 61 |Bottom:0}{Typefa| 00000290 63 65 3a 54 69 6d 65 73 7d 7b 46 6f 6e 74 78 3a |ce:Times}{Fontx:| 000002a0 30 7d 7b 46 6f 6e 74 79 3a 32 38 30 7d 7b 55 6e |0}{Fonty:280}{Un| 000002b0 64 65 72 6c 69 6e 65 3a 30 7d 7b 42 6f 6c 64 3a |derline:0}{Bold:| 000002c0 30 7d 7b 49 74 61 6c 69 63 3a 30 7d 7b 53 75 70 |0}{Italic:0}{Sup| 000002d0 65 72 73 63 72 69 70 74 3a 30 7d 7b 53 75 62 73 |erscript:0}{Subs| 000002e0 63 72 69 70 74 3a 30 7d 7b 46 6f 72 65 67 72 6f |cript:0}{Foregro| 000002f0 75 6e 64 3a 30 3b 30 3b 30 7d 7d 0a 7b 53 74 79 |und:0;0;0}}.{Sty| 00000300 6c 65 3a 42 61 73 65 48 65 61 64 46 6f 6f 74 7d |le:BaseHeadFoot}| 00000310 0a 7b 53 74 79 6c 65 3a 48 65 61 64 69 6e 67 3b |.{Style:Heading;| 00000320 7b 4a 75 73 74 69 66 79 3a 31 7d 7b 54 79 70 65 |{Justify:1}{Type| 00000330 66 61 63 65 3a 54 69 6d 65 73 7d 7b 46 6f 6e 74 |face:Times}{Font| 00000340 79 3a 34 38 30 7d 7b 42 6f 6c 64 3a 31 7d 7d 0a |y:480}{Bold:1}}.| 00000350 7b 53 74 79 6c 65 3a 49 6e 64 65 6e 74 3b 7b 4d |{Style:Indent;{M| 00000360 61 72 67 69 6e 4c 65 66 74 3a 31 38 31 34 7d 7b |arginLeft:1814}{| 00000370 4d 61 72 67 69 6e 52 69 67 68 74 3a 38 34 35 7d |MarginRight:845}| 00000380 7b 4d 61 72 67 69 6e 50 61 72 61 3a 2d 35 36 37 |{MarginPara:-567| 00000390 7d 7b 54 61 62 6c 69 73 74 3a 4c 31 7d 7d 0a 7b |}{Tablist:L1}}.{| 000003a0 53 74 79 6c 65 42 61 73 65 3a 42 61 73 65 4c 65 |StyleBase:BaseLe| 000003b0 74 74 65 72 7d 0a 7b 53 74 79 6c 65 48 65 61 64 |tter}.{StyleHead| 000003c0 65 72 46 6f 6f 74 65 72 3a 42 61 73 65 48 65 61 |erFooter:BaseHea| 000003d0 64 46 6f 6f 74 7d 0a 7b 50 61 70 65 72 3a 44 65 |dFoot}.{Paper:De| 000003e0 66 61 75 6c 74 20 41 34 3b 30 3b 31 36 38 34 30 |fault A4;0;16840| 000003f0 3b 31 31 39 30 30 3b 34 36 30 3b 34 36 30 3b 33 |;11900;460;460;3| 00000400 36 30 3b 33 36 30 3b 30 3b 30 3b 30 3b 30 3b 33 |60;360;0;0;0;0;3| 00000410 32 3b 3b 30 7d 0a 7b 50 72 69 6e 74 51 75 61 6c |2;;0}.{PrintQual| 00000420 69 74 79 3a 30 7d 0a 7b 53 74 61 72 74 4f 66 44 |ity:0}.{StartOfD| 00000430 61 74 61 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 31 3b |ata}.{S:X;X;0;1;| 00000440 46 72 69 64 61 79 20 31 33 74 68 7d 0a 7b 53 3a |Friday 13th}.{S:| 00000450 58 3b 58 3b 30 3b 33 3b 54 68 65 20 66 69 6c 65 |X;X;0;3;The file| 00000460 73 20 69 6e 20 74 68 69 73 20 64 69 72 65 63 74 |s in this direct| 00000470 6f 72 79 20 67 69 76 65 20 61 20 73 6f 6c 75 74 |ory give a solut| 00000480 69 6f 6e 20 74 6f 20 74 68 65 20 46 72 69 64 61 |ion to the Frida| 00000490 79 20 31 33 74 68 20 70 72 6f 62 6c 65 6d 20 61 |y 13th problem a| 000004a0 73 20 70 6f 73 65 64 20 69 6e 20 50 69 70 65 4c |s posed in PipeL| 000004b0 69 6e 65 20 6d 61 6e 79 20 6d 6f 6f 6e 73 20 61 |ine many moons a| 000004c0 67 6f 2e 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 34 3b |go.}.{S:X;X;0;4;| 000004d0 54 68 65 20 70 72 6f 62 6c 65 6d 20 69 73 20 74 |The problem is t| 000004e0 6f 20 22 70 72 6f 76 65 22 20 74 68 61 74 20 74 |o "prove" that t| 000004f0 68 65 20 31 33 74 68 20 6f 66 20 61 20 6d 6f 6e |he 13th of a mon| 00000500 74 68 20 69 73 20 6d 6f 72 65 20 6c 69 6b 65 6c |th is more likel| 00000510 79 20 74 6f 20 62 65 20 61 20 46 72 69 64 61 79 |y to be a Friday| 00000520 20 74 68 61 6e 20 61 6e 79 20 6f 74 68 65 72 20 | than any other | 00000530 70 61 72 74 69 63 75 6c 61 72 20 64 61 79 2e 20 |particular day. | 00000540 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 35 3b 54 68 69 |}.{S:X;X;0;5;Thi| 00000550 73 20 63 75 72 69 6f 75 73 20 66 61 63 74 20 72 |s curious fact r| 00000560 65 6c 69 65 73 20 6f 6e 20 28 69 29 20 74 68 65 |elies on (i) the| 00000570 20 6d 6f 64 65 72 6e 20 63 61 6c 65 6e 64 61 72 | modern calendar| 00000580 20 77 6f 72 6b 69 6e 67 20 69 6e 20 61 20 34 30 | working in a 40| 00000590 30 2d 79 65 61 72 20 63 79 63 6c 65 20 61 6e 64 |0-year cycle and| 000005a0 20 28 69 69 29 20 74 68 65 20 6e 75 6d 62 65 72 | (ii) the number| 000005b0 20 6f 66 20 64 61 79 73 20 69 6e 20 34 30 30 20 | of days in 400 | 000005c0 79 65 61 72 73 20 68 61 70 70 65 6e 73 20 74 6f |years happens to| 000005d0 20 62 65 20 65 78 61 63 74 6c 79 20 64 69 76 69 | be exactly divi| 000005e0 73 69 62 6c 65 20 62 79 20 37 2e 20 54 68 69 73 |sible by 7. This| 000005f0 20 69 6d 70 6c 69 65 73 20 74 68 61 74 20 69 66 | implies that if| 00000600 20 31 33 74 68 20 41 75 67 75 73 74 20 31 39 39 | 13th August 199| 00000610 33 20 69 73 20 61 20 46 72 69 64 61 79 20 74 68 |3 is a Friday th| 00000620 65 6e 20 31 33 74 68 20 41 75 67 75 73 74 20 32 |en 13th August 2| 00000630 33 39 33 20 77 69 6c 6c 20 61 6c 73 6f 20 62 65 |393 will also be| 00000640 20 61 20 46 72 69 64 61 79 2e 20 46 75 72 74 68 | a Friday. Furth| 00000650 65 72 2c 20 74 68 65 20 70 61 74 74 65 72 6e 20 |er, the pattern | 00000660 6f 66 20 46 72 69 64 61 79 20 31 33 74 68 73 20 |of Friday 13ths | 00000670 69 6e 20 74 68 65 20 34 30 30 20 79 65 61 72 73 |in the 400 years| 00000680 20 66 72 6f 6d 20 31 33 74 68 20 41 75 67 75 73 | from 13th Augus| 00000690 74 20 31 39 39 33 20 74 6f 20 31 32 74 68 20 41 |t 1993 to 12th A| 000006a0 75 67 75 73 74 20 32 33 39 33 20 77 69 6c 6c 20 |ugust 2393 will | 000006b0 62 65 20 65 78 61 63 74 6c 79 20 74 68 65 20 73 |be exactly the s| 000006c0 61 6d 65 20 61 73 20 74 68 65 20 70 61 74 74 65 |ame as the patte| 000006d0 72 6e 20 6f 66 20 46 72 69 64 61 79 20 31 33 74 |rn of Friday 13t| 000006e0 68 73 20 69 6e 20 74 68 65 20 66 6f 6c 6c 6f 77 |hs in the follow| 000006f0 69 6e 67 20 34 30 30 20 79 65 61 72 73 2e 20 28 |ing 400 years. (| 00000700 54 68 69 73 20 69 67 6e 6f 72 65 73 20 61 6e 79 |This ignores any| 00000710 20 63 68 61 6e 67 65 73 20 74 6f 20 74 68 65 20 | changes to the | 00000720 63 61 6c 65 6e 64 61 72 20 69 6e 20 74 68 65 20 |calendar in the | 00000730 6e 65 78 74 20 34 30 30 20 79 65 61 72 73 2e 2e |next 400 years..| 00000740 2e 2e 29 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 36 3b |..)}.{S:X;X;0;6;| 00000750 53 6f 20 74 68 65 20 74 61 73 6b 20 69 73 20 74 |So the task is t| 00000760 6f 20 63 6f 75 6e 74 20 74 68 65 20 6e 75 6d 62 |o count the numb| 00000770 65 72 20 6f 66 20 46 72 69 64 61 79 20 31 33 74 |er of Friday 13t| 00000780 68 73 20 69 6e 20 61 20 34 30 30 20 79 65 61 72 |hs in a 400 year| 00000790 20 70 65 72 69 6f 64 20 61 6e 64 20 73 68 6f 77 | period and show| 000007a0 20 74 68 61 74 20 74 68 65 72 65 20 61 72 65 20 | that there are | 000007b0 6d 6f 72 65 20 46 72 69 64 61 79 20 31 33 74 68 |more Friday 13th| 000007c0 73 20 74 68 61 6e 20 54 68 75 72 73 64 61 79 20 |s than Thursday | 000007d0 31 33 74 68 73 20 6f 72 20 57 65 64 6e 65 73 64 |13ths or Wednesd| 000007e0 61 79 20 31 33 74 68 73 20 61 6e 64 20 73 6f 20 |ay 13ths and so | 000007f0 6f 6e 2e 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 37 3b |on.}.{S:X;X;0;7;| 00000800 43 65 6c 6c 20 20 41 35 20 69 6e 20 74 68 65 20 |Cell A5 in the | 00000810 77 6f 72 6b 73 68 65 65 74 20 46 72 69 31 33 20 |worksheet Fri13 | 00000820 69 6e 76 6f 6b 65 73 20 74 68 65 20 63 75 73 74 |invokes the cust| 00000830 6f 6d 20 66 75 6e 63 74 69 6f 6e 20 61 6e 64 20 |om function and | 00000840 64 69 73 70 6c 61 79 73 20 74 68 65 20 72 65 73 |displays the res| 00000850 75 6c 74 73 20 69 6e 20 63 6f 6c 75 6d 6e 20 43 |ults in column C| 00000860 2e 20 63 5f 46 72 69 31 33 20 63 6f 6e 74 61 69 |. c_Fri13 contai| 00000870 6e 73 20 74 68 65 20 63 75 73 74 6f 6d 20 66 75 |ns the custom fu| 00000880 6e 63 74 69 6f 6e 20 69 74 73 65 6c 66 2e 20 57 |nction itself. W| 00000890 68 69 6c 65 20 69 74 20 69 73 20 63 61 6c 63 75 |hile it is calcu| 000008a0 6c 61 74 69 6e 67 20 79 6f 75 20 77 69 6c 6c 20 |lating you will | 000008b0 73 65 65 20 61 20 64 61 74 65 20 75 70 64 61 74 |see a date updat| 000008c0 69 6e 67 20 69 6e 20 63 65 6c 6c 20 44 32 20 61 |ing in cell D2 a| 000008d0 6e 64 20 74 68 65 20 69 6e 74 65 72 6d 65 64 69 |nd the intermedi| 000008e0 61 74 65 20 76 61 6c 75 65 73 20 69 6e 20 63 6f |ate values in co| 000008f0 6c 75 6d 6e 20 45 2e 20 57 68 65 6e 20 74 68 65 |lumn E. When the| 00000900 20 66 75 6e 63 74 69 6f 6e 20 66 69 6e 69 73 68 | function finish| 00000910 65 73 20 69 74 73 20 63 61 6c 63 75 6c 61 74 69 |es its calculati| 00000920 6f 6e 20 74 68 65 20 74 6f 74 61 6c 73 20 61 72 |on the totals ar| 00000930 65 20 72 65 74 75 72 6e 65 64 20 74 6f 20 74 68 |e returned to th| 00000940 65 20 63 61 6c 6c 69 6e 67 20 73 68 65 65 74 20 |e calling sheet | 00000950 77 68 69 63 68 20 64 69 73 70 6c 61 79 73 20 74 |which displays t| 00000960 68 65 6d 20 69 6e 20 63 6f 6c 75 6d 6e 20 43 2e |hem in column C.| 00000970 20 28 54 68 65 73 65 20 77 69 6c 6c 20 62 65 20 | (These will be | 00000980 74 68 65 20 73 61 6d 65 20 61 73 20 74 68 65 20 |the same as the | 00000990 70 72 65 76 69 6f 75 73 20 76 61 6c 75 65 73 20 |previous values | 000009a0 69 6e 20 63 6f 6c 75 6d 6e 20 43 20 61 73 20 74 |in column C as t| 000009b0 68 65 20 63 75 73 74 6f 6d 20 66 75 6e 63 74 69 |he custom functi| 000009c0 6f 6e 20 67 69 76 65 73 20 74 68 65 20 73 61 6d |on gives the sam| 000009d0 65 20 61 6e 73 77 65 72 20 65 76 65 72 79 20 74 |e answer every t| 000009e0 69 6d 65 20 69 74 20 72 65 63 61 6c 63 75 6c 61 |ime it recalcula| 000009f0 74 65 73 20 61 6e 64 20 74 68 65 20 76 61 6c 75 |tes and the valu| 00000a00 65 73 20 61 72 65 20 73 61 76 65 64 20 77 69 74 |es are saved wit| 00000a10 68 20 74 68 65 20 77 6f 72 6b 73 68 65 65 74 2e |h the worksheet.| 00000a20 29 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 38 3b 54 68 |)}.{S:X;X;0;8;Th| 00000a30 65 20 63 75 73 74 6f 6d 20 66 75 6e 63 74 69 6f |e custom functio| 00000a40 6e 20 77 6f 72 6b 73 20 62 79 20 66 69 6e 64 69 |n works by findi| 00000a50 6e 67 20 74 68 65 20 64 61 79 20 6f 66 20 74 68 |ng the day of th| 00000a60 65 20 77 65 65 6b 20 28 77 65 65 6b 64 61 79 29 |e week (weekday)| 00000a70 20 6f 66 20 65 61 63 68 20 31 33 74 68 20 66 6f | of each 13th fo| 00000a80 72 20 34 38 30 30 20 63 6f 6e 73 65 63 75 74 69 |r 4800 consecuti| 00000a90 76 65 20 6d 6f 6e 74 68 73 2e 20 54 68 65 20 73 |ve months. The s| 00000aa0 65 74 5f 76 61 6c 75 65 20 69 6e 20 63 65 6c 6c |et_value in cell| 00000ab0 20 41 39 20 75 73 65 73 20 74 68 65 20 77 65 65 | A9 uses the wee| 00000ac0 6b 64 61 79 20 61 73 20 69 6e 20 69 6e 64 65 78 |kday as in index| 00000ad0 20 69 6e 74 6f 20 74 68 65 20 74 61 62 6c 65 20 | into the table | 00000ae0 61 6e 64 20 69 6e 63 72 65 6d 65 6e 74 73 20 74 |and increments t| 00000af0 68 65 20 76 61 6c 75 65 20 69 74 20 66 69 6e 64 |he value it find| 00000b00 73 20 74 68 65 72 65 2e 7d 0a 7b 53 3a 58 3b 58 |s there.}.{S:X;X| 00000b10 3b 30 3b 31 31 3b 43 6f 6c 74 6f 6e 20 53 6f 66 |;0;11;Colton Sof| 00000b20 74 77 61 72 65 7d 0a 7b 53 3a 58 3b 58 3b 30 3b |tware}.{S:X;X;0;| 00000b30 31 32 3b 46 72 69 64 61 79 20 31 33 74 68 20 41 |12;Friday 13th A| 00000b40 75 67 75 73 74 20 31 39 39 33 7d 0a 7b 53 3a 58 |ugust 1993}.{S:X| 00000b50 3b 58 3b 30 3b 31 35 3b 28 42 79 20 74 68 65 20 |;X;0;15;(By the | 00000b60 77 61 79 2c 20 69 66 20 79 6f 75 27 72 65 20 72 |way, if you're r| 00000b70 65 61 64 69 6e 67 20 74 68 69 73 20 47 65 72 61 |eading this Gera| 00000b80 6c 64 2c 20 49 20 73 74 69 6c 6c 20 63 6c 61 69 |ld, I still clai| 00000b90 6d 20 6d 79 20 6d 75 67 20 66 6f 72 20 74 68 65 |m my mug for the| 00000ba0 20 22 62 65 73 74 22 20 73 6f 6c 75 74 69 6f 6e | "best" solution| 00000bb0 2e 2e 2e 29 7d 0a 7b 42 52 3a 3b 3b 3b 3b 3b 3b |...)}.{BR:;;;;;;| 00000bc0 3b 3b 31 3b 31 3b 7b 53 74 79 6c 65 48 61 6e 64 |;;1;1;{StyleHand| 00000bd0 6c 65 3a 42 61 73 65 4c 65 74 74 65 72 7d 7d 0a |le:BaseLetter}}.| 00000be0 7b 42 52 3a 3b 3b 3b 3b 3b 3b 3b 3b 31 3b 31 3b |{BR:;;;;;;;;1;1;| 00000bf0 7b 43 6f 6c 57 69 64 74 68 3a 30 7d 7d 0a 7b 42 |{ColWidth:0}}.{B| 00000c00 52 3a 30 3b 3b 3b 3b 31 3b 3b 3b 3b 31 3b 30 3b |R:0;;;;1;;;;1;0;| 00000c10 7b 53 74 79 6c 65 48 61 6e 64 6c 65 3a 42 61 73 |{StyleHandle:Bas| 00000c20 65 4c 65 74 74 65 72 7d 7d 0a 7b 52 3a 30 3b 31 |eLetter}}.{R:0;1| 00000c30 3b 3b 33 32 3b 31 3b 32 3b 3b 33 32 3b 30 3b 30 |;;32;1;2;;32;0;0| 00000c40 3b 7b 53 74 79 6c 65 48 61 6e 64 6c 65 3a 48 65 |;{StyleHandle:He| 00000c50 61 64 69 6e 67 7d 7d 0a 7b 50 61 67 65 48 65 66 |ading}}.{PageHef| 00000c60 6f 42 72 65 61 6b 56 61 6c 75 65 73 2d 48 3a 30 |oBreakValues-H:0| 00000c70 3b 30 3b 30 3b 3b 31 3b 33 39 36 3b 30 3b 30 3b |;0;0;;1;396;0;0;| 00000c80 3b 3b 30 3b 3b 3b 31 3b 30 3b 32 32 38 3b 30 3b |;;0;;;1;0;228;0;| 00000c90 3b 3b 30 7d 0a 7b 48 44 2d 48 3a 30 3b 32 7d 0a |;;0}.{HD-H:0;2}.| 00000ca0 7b 48 42 52 2d 48 3a 30 3b 32 3b 3b 33 32 3b 3b |{HBR-H:0;2;;32;;| 00000cb0 33 32 3b 7b 53 74 79 6c 65 48 61 6e 64 6c 65 3a |32;{StyleHandle:| 00000cc0 42 61 73 65 4c 65 74 74 65 72 7d 7d 0a 7b 48 42 |BaseLetter}}.{HB| 00000cd0 52 2d 48 3a 30 3b 32 3b 3b 33 32 3b 3b 33 32 3b |R-H:0;2;;32;;32;| 00000ce0 7b 53 74 79 6c 65 48 61 6e 64 6c 65 3a 42 61 73 |{StyleHandle:Bas| 00000cf0 65 48 65 61 64 46 6f 6f 74 7d 7d 0a 7b 48 44 2d |eHeadFoot}}.{HD-| 00000d00 48 3a 30 3b 33 7d 0a 7b 48 42 52 2d 48 3a 30 3b |H:0;3}.{HBR-H:0;| 00000d10 33 3b 3b 33 32 3b 3b 33 32 3b 7b 53 74 79 6c 65 |3;;32;;32;{Style| 00000d20 48 61 6e 64 6c 65 3a 42 61 73 65 4c 65 74 74 65 |Handle:BaseLette| 00000d30 72 7d 7d 0a 7b 48 42 52 2d 48 3a 30 3b 33 3b 3b |r}}.{HBR-H:0;3;;| 00000d40 33 32 3b 3b 33 32 3b 7b 53 74 79 6c 65 48 61 6e |32;;32;{StyleHan| 00000d50 64 6c 65 3a 42 61 73 65 48 65 61 64 46 6f 6f 74 |dle:BaseHeadFoot| 00000d60 7d 7d 0a 7b 45 6e 64 4f 66 44 61 74 61 7d 0a 7b |}}.{EndOfData}.{| 00000d70 43 6d 64 47 72 6f 75 70 3a 7b 56 69 65 77 43 72 |CmdGroup:{ViewCr| 00000d80 65 61 74 65 3a 30 3b 31 30 39 31 32 3b 31 31 37 |eate:0;10912;117| 00000d90 36 30 3b 39 39 32 30 7d 0a 7b 56 69 65 77 43 6f |60;9920}.{ViewCo| 00000da0 6e 74 72 6f 6c 3a 31 30 30 3b 32 3b 30 3b 30 3b |ntrol:100;2;0;0;| 00000db0 30 3b 30 3b 30 3b 32 30 34 38 3b 30 3b 32 30 34 |0;0;0;2048;0;204| 00000dc0 38 7d 0a 7b 43 75 72 72 65 6e 74 50 6f 73 69 74 |8}.{CurrentPosit| 00000dd0 69 6f 6e 3a 30 3b 33 3b 30 3b 33 7d 0a 7d 0a |ion:0;3;0;3}.}.| 00000ddf