Home » Archimedes archive » Zipped Apps » Fireworkz » Charts/Histogram/Readme
Charts/Histogram/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: | Charts/Histogram/Readme |
Read OK: | ✔ |
File size: | 09E6 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;6;;32;1;6} {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;Histograms} {S:X;X;0;3;This example creates a histogram of the results in the exams tutorial. The key cells are in row 20 onwards. In B20 the bin() function is used to count the averages in column G into five "bins". The bin values are those given in cells D20 to D23 (the last entry being all values over D23). In B21 the set_value function writes out the results from the bin function into the cells E20 to E24.} {S:X;X;0;4;Try changing exam values further up the sheet and watch how they affect the averages and then the bin entries. You can also try changing the bin values in cells D20 to D23. For example if the bin values determine the grades given how many extra students would achieve the top grade if it was given for marks of 75% or higher, rather than 80%?} {S:X;X;0;5;The histogram is plotted from the values in D20 through to E24, using the values in column D as the axis labels.} {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;8448} {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 36 3b 3b 33 32 |:0;0;;32;1;6;;32| 00000060 3b 31 3b 36 7d 0a 7b 53 74 79 6c 65 3a 42 61 73 |;1;6}.{Style:Bas| 00000070 65 4c 65 74 74 65 72 3b 7b 43 6f 6c 57 69 64 74 |eLetter;{ColWidt| 00000080 68 3a 31 31 31 38 30 7d 7b 43 6f 6c 4e 61 6d 65 |h:11180}{ColName| 00000090 3a 23 7d 7b 52 6f 77 48 65 69 67 68 74 3a 30 7d |:#}{RowHeight:0}| 000000a0 7b 52 6f 77 48 65 69 67 68 74 46 69 78 3a 30 7d |{RowHeightFix:0}| 000000b0 7b 52 6f 77 55 6e 62 72 65 61 6b 61 62 6c 65 3a |{RowUnbreakable:| 000000c0 30 7d 7b 52 6f 77 4e 61 6d 65 3a 23 7d 7b 4d 61 |0}{RowName:#}{Ma| 000000d0 72 67 69 6e 4c 65 66 74 3a 31 31 39 30 7d 7b 4d |rginLeft:1190}{M| 000000e0 61 72 67 69 6e 52 69 67 68 74 3a 31 30 33 32 7d |arginRight:1032}| 000000f0 7b 4d 61 72 67 69 6e 50 61 72 61 3a 30 7d 7b 54 |{MarginPara:0}{T| 00000100 61 62 6c 69 73 74 3a 52 37 39 33 20 4c 31 31 33 |ablist:R793 L113| 00000110 35 20 4c 32 32 36 39 20 4c 33 34 30 33 20 4c 34 |5 L2269 L3403 L4| 00000120 35 33 37 20 4c 35 36 37 31 20 4c 36 38 30 35 20 |537 L5671 L6805 | 00000130 4c 37 39 33 39 20 4c 39 30 37 33 7d 7b 42 61 63 |L7939 L9073}{Bac| 00000140 6b 67 72 6f 75 6e 64 3a 32 35 35 3b 32 35 35 3b |kground:255;255;| 00000150 32 35 35 7d 7b 50 61 72 61 53 74 61 72 74 3a 36 |255}{ParaStart:6| 00000160 38 7d 7b 50 61 72 61 45 6e 64 3a 34 35 7d 7b 4c |8}{ParaEnd:45}{L| 00000170 69 6e 65 53 70 61 63 65 3a 30 3b 37 32 7d 7b 4a |ineSpace:0;72}{J| 00000180 75 73 74 69 66 79 3a 30 7d 7b 4e 65 77 4f 62 6a |ustify:0}{NewObj| 00000190 65 63 74 3a 33 7d 7b 4e 75 6d 66 6f 72 6d 3a 23 |ect:3}{Numform:#| 000001a0 2c 23 23 30 2e 30 30 7d 7b 4e 75 6d 66 6f 72 6d |,##0.00}{Numform| 000001b0 44 54 3a 64 64 2e 6d 6d 2e 79 79 7d 7b 4e 75 6d |DT:dd.mm.yy}{Num| 000001c0 66 6f 72 6d 53 45 3a 40 7d 7b 42 6f 72 64 65 72 |formSE:@}{Border| 000001d0 43 6f 6c 6f 75 72 3a 30 3b 31 38 37 3b 32 35 35 |Colour:0;187;255| 000001e0 7d 7b 42 6f 72 64 65 72 3a 30 7d 7b 47 72 69 64 |}{Border:0}{Grid| 000001f0 4c 65 66 74 43 6f 6c 6f 75 72 3a 30 3b 31 38 37 |LeftColour:0;187| 00000200 3b 32 35 35 7d 7b 47 72 69 64 54 6f 70 43 6f 6c |;255}{GridTopCol| 00000210 6f 75 72 3a 30 3b 31 38 37 3b 32 35 35 7d 7b 47 |our:0;187;255}{G| 00000220 72 69 64 52 69 67 68 74 43 6f 6c 6f 75 72 3a 30 |ridRightColour:0| 00000230 3b 31 38 37 3b 32 35 35 7d 7b 47 72 69 64 42 6f |;187;255}{GridBo| 00000240 74 74 6f 6d 43 6f 6c 6f 75 72 3a 30 3b 31 38 37 |ttomColour:0;187| 00000250 3b 32 35 35 7d 7b 47 72 69 64 4c 65 66 74 3a 30 |;255}{GridLeft:0| 00000260 7d 7b 47 72 69 64 54 6f 70 3a 30 7d 7b 47 72 69 |}{GridTop:0}{Gri| 00000270 64 52 69 67 68 74 3a 30 7d 7b 47 72 69 64 42 6f |dRight:0}{GridBo| 00000280 74 74 6f 6d 3a 30 7d 7b 54 79 70 65 66 61 63 65 |ttom:0}{Typeface| 00000290 3a 54 69 6d 65 73 7d 7b 46 6f 6e 74 78 3a 30 7d |:Times}{Fontx:0}| 000002a0 7b 46 6f 6e 74 79 3a 32 38 30 7d 7b 55 6e 64 65 |{Fonty:280}{Unde| 000002b0 72 6c 69 6e 65 3a 30 7d 7b 42 6f 6c 64 3a 30 7d |rline:0}{Bold:0}| 000002c0 7b 49 74 61 6c 69 63 3a 30 7d 7b 53 75 70 65 72 |{Italic:0}{Super| 000002d0 73 63 72 69 70 74 3a 30 7d 7b 53 75 62 73 63 72 |script:0}{Subscr| 000002e0 69 70 74 3a 30 7d 7b 46 6f 72 65 67 72 6f 75 6e |ipt:0}{Foregroun| 000002f0 64 3a 30 3b 30 3b 30 7d 7d 0a 7b 53 74 79 6c 65 |d:0;0;0}}.{Style| 00000300 3a 42 61 73 65 48 65 61 64 46 6f 6f 74 7d 0a 7b |:BaseHeadFoot}.{| 00000310 53 74 79 6c 65 3a 48 65 61 64 69 6e 67 3b 7b 4a |Style:Heading;{J| 00000320 75 73 74 69 66 79 3a 31 7d 7b 54 79 70 65 66 61 |ustify:1}{Typefa| 00000330 63 65 3a 54 69 6d 65 73 7d 7b 46 6f 6e 74 79 3a |ce:Times}{Fonty:| 00000340 34 38 30 7d 7b 42 6f 6c 64 3a 31 7d 7d 0a 7b 53 |480}{Bold:1}}.{S| 00000350 74 79 6c 65 3a 49 6e 64 65 6e 74 3b 7b 4d 61 72 |tyle:Indent;{Mar| 00000360 67 69 6e 4c 65 66 74 3a 31 38 31 34 7d 7b 4d 61 |ginLeft:1814}{Ma| 00000370 72 67 69 6e 52 69 67 68 74 3a 38 34 35 7d 7b 4d |rginRight:845}{M| 00000380 61 72 67 69 6e 50 61 72 61 3a 2d 35 36 37 7d 7b |arginPara:-567}{| 00000390 54 61 62 6c 69 73 74 3a 4c 31 7d 7d 0a 7b 53 74 |Tablist:L1}}.{St| 000003a0 79 6c 65 42 61 73 65 3a 42 61 73 65 4c 65 74 74 |yleBase:BaseLett| 000003b0 65 72 7d 0a 7b 53 74 79 6c 65 48 65 61 64 65 72 |er}.{StyleHeader| 000003c0 46 6f 6f 74 65 72 3a 42 61 73 65 48 65 61 64 46 |Footer:BaseHeadF| 000003d0 6f 6f 74 7d 0a 7b 50 61 70 65 72 3a 44 65 66 61 |oot}.{Paper:Defa| 000003e0 75 6c 74 20 41 34 3b 30 3b 31 36 38 34 30 3b 31 |ult A4;0;16840;1| 000003f0 31 39 30 30 3b 34 36 30 3b 34 36 30 3b 33 36 30 |1900;460;460;360| 00000400 3b 33 36 30 3b 30 3b 30 3b 30 3b 30 3b 33 32 3b |;360;0;0;0;0;32;| 00000410 3b 30 7d 0a 7b 50 72 69 6e 74 51 75 61 6c 69 74 |;0}.{PrintQualit| 00000420 79 3a 30 7d 0a 7b 53 74 61 72 74 4f 66 44 61 74 |y:0}.{StartOfDat| 00000430 61 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 31 3b 48 69 |a}.{S:X;X;0;1;Hi| 00000440 73 74 6f 67 72 61 6d 73 7d 0a 7b 53 3a 58 3b 58 |stograms}.{S:X;X| 00000450 3b 30 3b 33 3b 54 68 69 73 20 65 78 61 6d 70 6c |;0;3;This exampl| 00000460 65 20 63 72 65 61 74 65 73 20 61 20 68 69 73 74 |e creates a hist| 00000470 6f 67 72 61 6d 20 6f 66 20 74 68 65 20 72 65 73 |ogram of the res| 00000480 75 6c 74 73 20 69 6e 20 74 68 65 20 65 78 61 6d |ults in the exam| 00000490 73 20 74 75 74 6f 72 69 61 6c 2e 20 54 68 65 20 |s tutorial. The | 000004a0 6b 65 79 20 63 65 6c 6c 73 20 61 72 65 20 69 6e |key cells are in| 000004b0 20 72 6f 77 20 32 30 20 6f 6e 77 61 72 64 73 2e | row 20 onwards.| 000004c0 20 49 6e 20 42 32 30 20 74 68 65 20 62 69 6e 28 | In B20 the bin(| 000004d0 29 20 66 75 6e 63 74 69 6f 6e 20 69 73 20 75 73 |) function is us| 000004e0 65 64 20 74 6f 20 63 6f 75 6e 74 20 74 68 65 20 |ed to count the | 000004f0 61 76 65 72 61 67 65 73 20 69 6e 20 63 6f 6c 75 |averages in colu| 00000500 6d 6e 20 47 20 69 6e 74 6f 20 66 69 76 65 20 22 |mn G into five "| 00000510 62 69 6e 73 22 2e 20 54 68 65 20 62 69 6e 20 76 |bins". The bin v| 00000520 61 6c 75 65 73 20 61 72 65 20 74 68 6f 73 65 20 |alues are those | 00000530 67 69 76 65 6e 20 69 6e 20 63 65 6c 6c 73 20 44 |given in cells D| 00000540 32 30 20 74 6f 20 44 32 33 20 28 74 68 65 20 6c |20 to D23 (the l| 00000550 61 73 74 20 65 6e 74 72 79 20 62 65 69 6e 67 20 |ast entry being | 00000560 61 6c 6c 20 76 61 6c 75 65 73 20 6f 76 65 72 20 |all values over | 00000570 44 32 33 29 2e 20 49 6e 20 42 32 31 20 74 68 65 |D23). In B21 the| 00000580 20 73 65 74 5f 76 61 6c 75 65 20 66 75 6e 63 74 | set_value funct| 00000590 69 6f 6e 20 77 72 69 74 65 73 20 6f 75 74 20 74 |ion writes out t| 000005a0 68 65 20 72 65 73 75 6c 74 73 20 66 72 6f 6d 20 |he results from | 000005b0 74 68 65 20 62 69 6e 20 66 75 6e 63 74 69 6f 6e |the bin function| 000005c0 20 69 6e 74 6f 20 74 68 65 20 63 65 6c 6c 73 20 | into the cells | 000005d0 45 32 30 20 74 6f 20 45 32 34 2e 7d 0a 7b 53 3a |E20 to E24.}.{S:| 000005e0 58 3b 58 3b 30 3b 34 3b 54 72 79 20 63 68 61 6e |X;X;0;4;Try chan| 000005f0 67 69 6e 67 20 65 78 61 6d 20 76 61 6c 75 65 73 |ging exam values| 00000600 20 66 75 72 74 68 65 72 20 75 70 20 74 68 65 20 | further up the | 00000610 73 68 65 65 74 20 61 6e 64 20 77 61 74 63 68 20 |sheet and watch | 00000620 68 6f 77 20 74 68 65 79 20 61 66 66 65 63 74 20 |how they affect | 00000630 74 68 65 20 61 76 65 72 61 67 65 73 20 61 6e 64 |the averages and| 00000640 20 74 68 65 6e 20 74 68 65 20 62 69 6e 20 65 6e | then the bin en| 00000650 74 72 69 65 73 2e 20 59 6f 75 20 63 61 6e 20 61 |tries. You can a| 00000660 6c 73 6f 20 74 72 79 20 63 68 61 6e 67 69 6e 67 |lso try changing| 00000670 20 74 68 65 20 62 69 6e 20 76 61 6c 75 65 73 20 | the bin values | 00000680 69 6e 20 63 65 6c 6c 73 20 44 32 30 20 74 6f 20 |in cells D20 to | 00000690 44 32 33 2e 20 46 6f 72 20 65 78 61 6d 70 6c 65 |D23. For example| 000006a0 20 69 66 20 74 68 65 20 62 69 6e 20 76 61 6c 75 | if the bin valu| 000006b0 65 73 20 64 65 74 65 72 6d 69 6e 65 20 74 68 65 |es determine the| 000006c0 20 67 72 61 64 65 73 20 67 69 76 65 6e 20 68 6f | grades given ho| 000006d0 77 20 6d 61 6e 79 20 65 78 74 72 61 20 73 74 75 |w many extra stu| 000006e0 64 65 6e 74 73 20 77 6f 75 6c 64 20 61 63 68 69 |dents would achi| 000006f0 65 76 65 20 74 68 65 20 74 6f 70 20 67 72 61 64 |eve the top grad| 00000700 65 20 69 66 20 69 74 20 77 61 73 20 67 69 76 65 |e if it was give| 00000710 6e 20 66 6f 72 20 6d 61 72 6b 73 20 6f 66 20 37 |n for marks of 7| 00000720 35 25 20 6f 72 20 68 69 67 68 65 72 2c 20 72 61 |5% or higher, ra| 00000730 74 68 65 72 20 74 68 61 6e 20 38 30 25 3f 7d 0a |ther than 80%?}.| 00000740 7b 53 3a 58 3b 58 3b 30 3b 35 3b 54 68 65 20 68 |{S:X;X;0;5;The h| 00000750 69 73 74 6f 67 72 61 6d 20 69 73 20 70 6c 6f 74 |istogram is plot| 00000760 74 65 64 20 66 72 6f 6d 20 74 68 65 20 76 61 6c |ted from the val| 00000770 75 65 73 20 69 6e 20 44 32 30 20 74 68 72 6f 75 |ues in D20 throu| 00000780 67 68 20 74 6f 20 45 32 34 2c 20 75 73 69 6e 67 |gh to E24, using| 00000790 20 74 68 65 20 76 61 6c 75 65 73 20 69 6e 20 63 | the values in c| 000007a0 6f 6c 75 6d 6e 20 44 20 61 73 20 74 68 65 20 61 |olumn D as the a| 000007b0 78 69 73 20 6c 61 62 65 6c 73 2e 7d 0a 7b 42 52 |xis labels.}.{BR| 000007c0 3a 3b 3b 3b 3b 3b 3b 3b 3b 31 3b 31 3b 7b 53 74 |:;;;;;;;;1;1;{St| 000007d0 79 6c 65 48 61 6e 64 6c 65 3a 42 61 73 65 4c 65 |yleHandle:BaseLe| 000007e0 74 74 65 72 7d 7d 0a 7b 42 52 3a 3b 3b 3b 3b 3b |tter}}.{BR:;;;;;| 000007f0 3b 3b 3b 31 3b 31 3b 7b 43 6f 6c 57 69 64 74 68 |;;;1;1;{ColWidth| 00000800 3a 30 7d 7d 0a 7b 42 52 3a 30 3b 3b 3b 3b 31 3b |:0}}.{BR:0;;;;1;| 00000810 3b 3b 3b 31 3b 30 3b 7b 53 74 79 6c 65 48 61 6e |;;;1;0;{StyleHan| 00000820 64 6c 65 3a 42 61 73 65 4c 65 74 74 65 72 7d 7d |dle:BaseLetter}}| 00000830 0a 7b 52 3a 30 3b 31 3b 3b 33 32 3b 31 3b 32 3b |.{R:0;1;;32;1;2;| 00000840 3b 33 32 3b 30 3b 30 3b 7b 53 74 79 6c 65 48 61 |;32;0;0;{StyleHa| 00000850 6e 64 6c 65 3a 48 65 61 64 69 6e 67 7d 7d 0a 7b |ndle:Heading}}.{| 00000860 50 61 67 65 48 65 66 6f 42 72 65 61 6b 56 61 6c |PageHefoBreakVal| 00000870 75 65 73 2d 48 3a 30 3b 30 3b 30 3b 3b 31 3b 33 |ues-H:0;0;0;;1;3| 00000880 39 36 3b 30 3b 30 3b 3b 3b 30 3b 3b 3b 31 3b 30 |96;0;0;;;0;;;1;0| 00000890 3b 32 32 38 3b 30 3b 3b 3b 30 7d 0a 7b 48 44 2d |;228;0;;;0}.{HD-| 000008a0 48 3a 30 3b 32 7d 0a 7b 48 42 52 2d 48 3a 30 3b |H:0;2}.{HBR-H:0;| 000008b0 32 3b 3b 33 32 3b 3b 33 32 3b 7b 53 74 79 6c 65 |2;;32;;32;{Style| 000008c0 48 61 6e 64 6c 65 3a 42 61 73 65 4c 65 74 74 65 |Handle:BaseLette| 000008d0 72 7d 7d 0a 7b 48 42 52 2d 48 3a 30 3b 32 3b 3b |r}}.{HBR-H:0;2;;| 000008e0 33 32 3b 3b 33 32 3b 7b 53 74 79 6c 65 48 61 6e |32;;32;{StyleHan| 000008f0 64 6c 65 3a 42 61 73 65 48 65 61 64 46 6f 6f 74 |dle:BaseHeadFoot| 00000900 7d 7d 0a 7b 48 44 2d 48 3a 30 3b 33 7d 0a 7b 48 |}}.{HD-H:0;3}.{H| 00000910 42 52 2d 48 3a 30 3b 33 3b 3b 33 32 3b 3b 33 32 |BR-H:0;3;;32;;32| 00000920 3b 7b 53 74 79 6c 65 48 61 6e 64 6c 65 3a 42 61 |;{StyleHandle:Ba| 00000930 73 65 4c 65 74 74 65 72 7d 7d 0a 7b 48 42 52 2d |seLetter}}.{HBR-| 00000940 48 3a 30 3b 33 3b 3b 33 32 3b 3b 33 32 3b 7b 53 |H:0;3;;32;;32;{S| 00000950 74 79 6c 65 48 61 6e 64 6c 65 3a 42 61 73 65 48 |tyleHandle:BaseH| 00000960 65 61 64 46 6f 6f 74 7d 7d 0a 7b 45 6e 64 4f 66 |eadFoot}}.{EndOf| 00000970 44 61 74 61 7d 0a 7b 43 6d 64 47 72 6f 75 70 3a |Data}.{CmdGroup:| 00000980 7b 56 69 65 77 43 72 65 61 74 65 3a 30 3b 31 30 |{ViewCreate:0;10| 00000990 39 31 32 3b 31 31 37 36 30 3b 38 34 34 38 7d 0a |912;11760;8448}.| 000009a0 7b 56 69 65 77 43 6f 6e 74 72 6f 6c 3a 31 30 30 |{ViewControl:100| 000009b0 3b 32 3b 30 3b 30 3b 30 3b 30 3b 30 3b 32 30 34 |;2;0;0;0;0;0;204| 000009c0 38 3b 30 3b 32 30 34 38 7d 0a 7b 43 75 72 72 65 |8;0;2048}.{Curre| 000009d0 6e 74 50 6f 73 69 74 69 6f 6e 3a 30 3b 33 3b 30 |ntPosition:0;3;0| 000009e0 3b 33 7d 0a 7d 0a |;3}.}.| 000009e6