Home » Archimedes archive » Zipped Apps » Fireworkz » PipeDream/Readme
PipeDream/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: | PipeDream/Readme |
| Read OK: | ✔ |
| File size: | 5039 bytes |
| Load address: | 0000 |
| Exec address: | 0000 |
File contents
{Version:1.05/01;18 Oct 1993;Fireworkz;Colton Software;4000 2029 4983 8986}
{Block:0;0;;32;1;85;;32;1;85}
{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}}
{StyleBase:BaseLetter}
{Style:BaseHeadFoot}
{StyleHeaderFooter:BaseHeadFoot}
{Style:Heading;{Justify:1}{Typeface:Times}{Fonty:480}{Bold:1}}
{Style:MainHeading;{MarginLeft:1190}{MarginRight:1032}{MarginPara:-623}{Justify:0}{Fonty:360}{Bold:1}}
{Style:Indent;{MarginLeft:1814}{MarginRight:845}{MarginPara:-567}{Tablist:L1}}
{Paper:Default A4;0;16840;11900;460;460;360;360;0;0;0;0;32;;0}
{PrintQuality:0}
{StartOfData}
{S:X;X;0;1;Fireworkz for PipeDream Users}
{S:X;X;0;2;This document is to help PipeDream users get the most out of Fireworkz. It's divided into two sections accoring to whether it's a text type file loaded from PipeDream, or a spreadsheet type file.}
{S:X;X;0;3;When you load a PipeDream file, you have to decide whether to convert it as a text type file, or a spreadsheet type file. If you choose a letter type template, Fireworkz will load the PipeDream file as a text type file, ignoring formulas and inserting tabs for columns in the PipeDream file. If you choose a sheet type template, Fireworkz will load the file as a spreadsheet\\\; your formulas will be converted, and PipeDream columns will be converted to Fireworkz columns.}
{S:X;X;0;4;The two sections of this document describe the two different types of document created.}
{S:X;X;0;5;To make Fireworkz load a PipeDream file, all you have to do is drop the PipeDream file on the Fireworkz icon, then choose the letter or spreadsheet template as required.}
{S:X;X;0;6;Text files - letter template}
{S:X;X;0;7;If you use the letter template, PipeDream files are loaded into one column, no matter how many columns are in the original. Text in different columns in the PipeDream file is separated by tabs when it arrives in the Fireworkz file. Blank columns at the start of the PipeDream file are stripped out, and Fireworkz does its best to recognise paragraphs in the PipeDream file.}
{S:X;X;0;8;Underline, bold, italic, superscript and subscript highlights are converted by Fireworkz into corresponding text effect regions. The @D@ field is converted into a Fireworkz live date insert\\\; other @ fields are stripped out.}
{S:X;X;0;9;Other PipeDream options, page sizes, fonts and headers and footers are not converted.}
{S:X;X;0;10;PipeDream text files such as letters and reports convert quite successfully. Once you have the data in Fireworkz you can quickly improve the layout by adjusting tabstops and applying styles or altering the Base style.}
{S:X;X;0;11;If you have tabular data in PipeDream - such as a spreadsheet or database that you want in tabular form in Fireworkz - load it using the sheet template, or export it as a CSV file and load it into a Fireworkz table.}
{S:X;X;0;12;Editing in Fireworkz}
{S:X;X;0;13;If you use PipeDream a lot and as your main application, you may well find editing text in Fireworkz a little weird to begin with. This is not because Fireworkz is difficult, but because PipeDream is very unusual. Skills that you learn in Fireworkz will be applicable to lots of other programs, whereas your hard-won PipeDream skills really apply only to PipeDream.}
{S:X;X;0;14;First of all, the Return key in Fireworkz splits a paragraph. In PipeDream it just moves the caret (unless you have Insert on Return switched on). Pressing Delete (or backspace) at the start of a paragraph joins two paragraphs together. There's no Insert line (Ctrl-N/F7) or Delete line (Ctrl-Y/F8) in Fireworkz. Use Return and Delete to do this. Split and Join lines (Ctrl-ESL/Shift F7 and Ctrl-EJL/Shift F8) are also replaced by Return and Delete. To split a paragraph, position the caret where you want the split, and press Return. To join together two paragraphs, put the caret at the start of the second paragraph and press Delete.}
{S:X;X;0;15;To become slick with Fireworkz you will need to get used to making selections of pieces of text. Of course, you can select text in PipeDream, but never less than a single line, whereas in Fireworkz you can select a word, a single character or any part of a paragraph. Select text either by dragging over it with the left mouse button held down, or by positioning the caret at one end of the text to be selected and clicking the right button at the other end.}
{S:X;X;0;16;Once you have some text selected you can do various things: }
{S:X;X;0;17;Apply an effect like Bold (by clicking on the Bold button), or a style (by choosing a style from the style list box - click on the Style button first).}
{S:X;X;0;18;Cut the text - click on the Cut icon (the scissors). This stores the text temporarily so that you can move the caret somewhere else and re-insert the text by clicking on the Paste icon (glue pot and brush). Note that it only remembers the last piece of text that has been cut.}
{S:X;X;0;19;Delete the text - press the Delete key.}
{S:X;X;0;20;Type over the text - this cuts the selected text to the clipboard and starts inserting the new text in the place of the original.}
{S:X;X;0;21;There are some useful shortcuts to making selections: double-click with the mouse, or Ctrl-W from the keyboard selects a word\\\; triple click, or Ctrl-P selects a whole paragraph.}
{S:X;X;0;22;Spreadsheet files - sheet template}
{S:X;X;0;23;Fireworkz is not PipeDream. Fireworkz has been designed from scratch to be the most advanced integrated program available for RISC OS. Many Fireworkz users will have used PipeDream. This document introduces the features of the Fireworkz speadsheet which will be new to PipeDream users.}
{S:X;X;0;24;Page layout. Fireworkz' page layout facilities go far beyond any other spreadsheet program available on the Archimedes, or Windows or Macintosh. }
{S:X;X;0;25;The spreadsheet window is page-based and completely WYSIWYG. Just like a DTP system you see the pages exactly as they will print. You can have multiple views and scaled views. Columns are split across pages so that you can see exactly what will appear on each page. The Paper dialogue box enables you to match your paper size on screen to the printer driver settings with a single click, or you can specify your own paper sizes. You can work in either portrait or landscape on screen\\\; landscape probably enables that last column to fit!}
{S:X;X;0;26;We believe that Fireworkz (and Resultz) are unique in enabling you to change column widths at any point down the spreadsheet. Usually spreadsheets constrain you to using the same set of column widths at the bottom of the document as you used at the top. There is no such constraint in Fireworkz. Plenty of examples using this are provided in the spreadsheets on this disc.}
{S:X;X;0;27;User interface. The user interface has been designed to be as simple and direct as possible. The button bar at the top of the window gives access to the most frequently used commands. }
{S:X;X;0;28;The status line provides interactive help about Fireworkz and your spreadsheets. Descriptions of all Fireworkz' functions and their parameters are provided.}
{S:X;X;0;29;Formula line. Function entry is much slicker than PipeDream: if you enter the function from the function selector you get automatic parameter help and pasting. When entering cell references and ranges in the formula line, they are given a soft selection so that clicking several times overrides the previous references, but typing will insert after the references. Try it, it's easier to use than to describe!}
{S:X;X;0;30;Auto sum enables you to create totals with just a click on the button. Other RISC OS spreadsheet programs merely use the auto sum button to insert an empty sum() on the formula line. Fireworkz will do that if you wish, but if you make a selection of cells with blank cells in the last row or column, then a click on the auto sum button will create the complete sum() formula, including cell references, and insert it into the cell.}
{S:X;X;0;31;The style editor enables you to make styles which can be applied at any level from a single character up to the whole document. Unlike in other spreadsheet programs, they can also be layered, just like in Wordz and Impression. Styles can contain a wide range of attributes, from font sizes and colours to grid styles, horizontal and vertical justification. Styles can be used to predefine areas of the sheet. You can specify that cells should become either text cells or number cells when you type data into them, or that a column should be left-aligned or in a different font.}
{S:X;X;0;32;Styles are a very important and powerful feature of Fireworkz. Using them will enable you to build better looking documents more quickly.}
{S:X;X;0;33;Protection is provided as a style attribute. It is probably best used by setting up a style containing just protection and applying it to cells. You may want to add a background colour to the style in order to see the protected areas.}
{S:X;X;0;34;Number/date formats can be specified as part of a style. You can provide styles specifying different numbers of decimal places, or a percentage style, or even roman numerals.}
{S:X;X;0;35;Gridlines of different thicknesses, line styles and colours can be drawn around cells using the Box command.}
{S:X;X;0;36;Templates are files from which you can start new documents. The Save Template command will place your document in the templates directory (!Fireworkz.User.Templates). When you click on the Fireworkz icon a menu of templates appears for you to select. You can also use Save Template to save out styles to copy into other documents.}
{S:X;X;0;37;When creating a chart, it is automatically placed inside your spreadsheet document. So saving and printing the spreadsheet saves and prints the chart too, with no extra work. This makes it much easier to manage charts in Fireworkz than in any other RISC OS spreadsheet program. Examples of charts are provided in the charts directory.}
{S:X;X;0;38;New functions}
{S:X;X;0;39;age subtracts one date from another and returns the result as a date. This is useful for calculating someone's age in terms of years and months.}
{S:X;X;0;40;bin counts the frequencies of classes of data. The output can be used as the input to a histogram and an example of this is given in the Charts directory of the examples disc.}
{S:X;X;0;41;counta counts the number of elements in an array or range}
{S:X;X;0;42;dayname returns a string of the dayname, the day being given as a number. eg dayname(weekday(today))}
{S:X;X;0;43;flip turns an array upside down}
{S:X;X;0;44;formula_text returns as a string the formula in another cell. This can be used to annotate spreadsheets, to show what formulas were used to produce the results. It is a way of printing both the results and the formula at the same time.}
{S:X;X;0;45;listcount takes an array or range of data and produces a list of all the unique elements plus their frequencies. An extension takes values for each element and adds the values together. }
{S:X;X;0;46;median returns the median value of a range or array}
{S:X;X;0;47;monthname: as dayname. eg monthname(month(today))}
{S:X;X;0;48;page returns the page number (x or y) of a cell}
{S:X;X;0;49;pages returns the number of pages (x or y) in the document}
{S:X;X;0;50;rank returns an array of rankings from an input array}
{S:X;X;0;51;sort sorts an array on a given column}
{S:X;X;0;52;spearman calculates the Spearman correlation co-efficient from two ranked arrays. The arrays can be ranked using the rank function.}
{S:X;X;0;53;text takes a number and a number format (identical to those in style editor) and returns a string of the formatted number}
{S:X;X;0;54;Function enhancements}
{S:X;X;0;55;lookup has been extended. An optional fourth parameter set to 1 provides two extra types of information to be returned: (i) all occurrences which match the key are returned, rather than simply the first, (ii) for each match a whole record can be returned, rather than just a simple value.}
{S:X;X;0;56;set_value has been extended. Optional third and fourth parameters specify an offset in an array. This enables you to write to a single element in an array.}
{S:X;X;0;57;After you've loaded the file}
{S:X;X;0;58;When the PipeDream file has been loaded, it will probably look quite different to how it looked in PipeDream. The rows may look quite deep and headings and text may have "wrapped" to take up several lines within each cell.}
{S:X;X;0;59;Column widths}
{S:X;X;0;60;Most of the problem is solved by changing the column widths to match the data better. You can try double-clicking with the Select button on the column borders. If the data in the columns is quite short, Fireworkz will auto-width the columns and so make the columns the widths of the longest cell. If there are cell-entries which are very long, Fireworkz will not apply the auto-width.}
{S:X;X;0;61;The Heading}
{S:X;X;0;62;A particular problem may be the heading at the top of the document. PipeDream uses overlap to display headings. Fireworkz doesn't have overlap: instead, it enables you to change the widths of any cells at any point. In the case of a heading, you probably have a single cell which you want to expand over the whole page width. }
{S:X;X;0;63;The best way to tackle this is to use Fireworkz' straddling command. Select the cell containing the heading, and the cells to the right of it which you want the heading to straddle. Point at the column border between the column letters. When the pointer changes shape to become two vertical lines with arrows pointing left and right, double-click with the Adjust button on the mouse. The leftmost cell will expand to the right over the other cells and these other cells will be shrunk down to nothing.}
{S:X;X;0;64;Landscape}
{S:X;X;0;65;You will notice that after a few columns, you get a page-break and the new columns appear on a new page to the right. If you decide you would like more columns to the page you can either shrink the column widths to fit, or you can use the Paper dialogue box to set the paper orientation to landscape. This gives you a wider page (more columns) which is less deep (fewer rows). Whilst in the Paper dialogue box, click on the Read printer button.}
{S:X;X;0;66;If you're not going to print out the spreadsheet, you can choose the None button in the paper dialog box which will give you infinite paper.}
{S:X;X;0;67;Formulas}
{S:X;X;0;68;Almost without exception, Fireworkz will understand and evaluate PipeDream formulas identically to PipeDream. The differences are:}
{S:X;X;0;69;hlookup, vlookup. The target range is now two-dimensional and includes all of the rows and columns which can be used as the offset. An example of this will clarify:}
{S:X;X;0;70;Suppose you want to look for the value 42 in cells A1 to A100 and return the corresponding element from column C. }
{S:X;X;0;71;{ITT-X}In PipeDream the syntax would be vlookup(42, A1A100, 2)}
{S:X;X;0;72;{ITT-X}In Fireworkz the syntax would be vlookup(42, A1C100, 3)}
{S:X;X;0;73;In Fireworkz we include all of the possible offset ranges in the target range (even though the key is only looked for in the first column/row). The offset number given is the column (or row) within the target range.}
{S:X;X;0;74;choose has changed so that any range parameters are treated as single elements. So choose(3, 1, A1A3, 6) will return 6 rather than A2. choose(2, 1, A1A3, 6) will return the contents of A1A3 as an array.}
{S:X;X;0;75;The trig functions acs, asn, atn have been renamed as acos, asin and atan in keeping with standard spreadsheet terminology.}
{S:X;X;0;76;External references}
{S:X;X;0;77;Fireworkz has similar external references to PipeDream. It also keeps track of which files are grouped together and if you attempt to close one file in a group, Fireworkz will prompt you to close all the files in the group. This makes loading and saving linked spreadsheets rather easier.}
{S:X;X;0;78;If you load a PipeDream file containing external references, Fireworkz will not immediately be able to find the supporting files. This is because Fireworkz will not use the PipeDream file's path, but create a new filename of the form Sheet1. the best approach to getting the linked spreadsheets working with Fireworkz is:}
{S:X;X;0;79;(i){ITT-X}copy all of the linked spreadsheets into a new directory, retaining the old directory containing the PipeDream set if you need to refer back to them.}
{S:X;X;0;80;(ii) {ITT-X}load each file in the new directory individually and save it back into the new directory using the existing PipeDream name.}
{S:X;X;0;81;(iii) {ITT-X}when all of the files have been loaded and saved you will find that loading the dependent document will automatically load the supporters.}
{S:X;X;0;82;Custom function sheets, being supporting documents, work in exactly the same way.}
{S:X;X;0;83;Loading large files}
{S:X;X;0;84;Please make sure you have read the information in the main Readmemore file about loading and converting of PipeDream files.}
{BR:;;;;;;;;1;1;{StyleHandle:BaseLetter}}
{BR:;;;;;;;;1;1;{ColWidth:0}}
{BR:0;;;;1;;;;1;0;{StyleHandle:BaseLetter}}
{R:0;12;;32;1;13;;32;0;0;{Bold:1}}
{R:0;14;18;3;1;15;;32;0;0;{Bold:1}}
{R:0;14;24;3;1;15;;32;0;0;{Bold:0}}
{R:0;14;156;3;1;15;;32;0;0;{Bold:1}}
{R:0;14;163;3;1;15;;32;0;0;{Bold:0}}
{R:0;17;;32;1;21;;32;0;0;{MarginLeft:1587}}
{R:0;6;;32;1;7;;32;0;0;{StyleHandle:MainHeading}}
{R:0;38;;32;1;39;;32;0;0;{Bold:1}}
{R:0;39;;32;1;40;3;3;0;0;{Italic:1}}
{R:0;42;;32;1;43;7;3;0;0;{Italic:1}}
{R:0;47;;32;1;48;9;3;0;0;{Italic:1}}
{R:0;48;;32;1;49;4;3;0;0;{Italic:1}}
{R:0;43;;32;1;44;4;3;0;0;{Italic:1}}
{R:0;49;;32;1;50;5;3;0;0;{Italic:1}}
{R:0;51;;32;1;52;4;3;0;0;{Italic:1}}
{R:0;40;;32;1;41;3;3;0;0;{Italic:1}}
{R:0;41;;32;1;42;6;3;0;0;{Italic:1}}
{R:0;45;;32;1;46;9;3;0;0;{Italic:1}}
{R:0;46;;32;1;47;6;3;0;0;{Italic:1}}
{R:0;52;;32;1;53;8;3;0;0;{Italic:1}}
{R:0;50;;32;1;51;4;3;0;0;{Italic:1}}
{R:0;44;;32;1;45;12;3;0;0;{Italic:1}}
{R:0;53;;32;1;54;4;3;0;0;{Italic:1}}
{R:0;27;;32;1;28;14;3;0;0;{Bold:1}}
{R:0;24;;32;1;25;11;3;0;0;{Bold:1}}
{R:0;29;;32;1;30;12;3;0;0;{Bold:1}}
{R:0;28;4;3;1;29;15;3;0;0;{Bold:1}}
{R:0;31;4;3;1;32;16;3;0;0;{Bold:1}}
{R:0;33;;32;1;34;10;3;0;0;{Bold:1}}
{R:0;34;;32;1;35;19;3;0;0;{Bold:1}}
{R:0;35;;32;1;36;9;3;0;0;{Bold:1}}
{R:0;37;16;3;1;38;21;3;0;0;{Bold:1}}
{R:0;36;;32;1;37;9;3;0;0;{Bold:1}}
{R:0;30;;32;1;31;8;3;0;0;{Bold:1}}
{R:0;55;;32;1;56;6;3;0;0;{Italic:1}}
{R:0;54;;32;1;55;;32;0;0;{Bold:1}}
{R:0;56;;32;1;57;9;3;0;0;{Italic:1}}
{R:0;22;;32;1;23;;32;0;0;{StyleHandle:MainHeading}}
{R:0;1;;32;1;2;;32;0;0;{StyleHandle:Heading}}
{R:0;83;;32;1;84;;32;0;0;{Bold:1}}
{R:0;67;;32;1;68;;32;0;0;{Bold:1}}
{R:0;75;19;3;1;76;22;3;0;0;{Italic:1}}
{R:0;75;24;3;1;76;27;3;0;0;{Italic:1}}
{R:0;75;29;3;1;76;32;3;0;0;{Italic:1}}
{R:0;75;54;3;1;76;58;3;0;0;{Italic:1}}
{R:0;75;60;3;1;76;64;3;0;0;{Italic:1}}
{R:0;75;69;3;1;76;73;3;0;0;{Italic:1}}
{R:0;69;9;3;1;70;16;3;0;0;{Italic:1}}
{R:0;69;;32;1;70;7;3;0;0;{Italic:1}}
{R:0;74;;32;1;75;6;3;0;0;{Italic:1}}
{R:0;59;;32;1;60;;32;0;0;{Bold:1}}
{R:0;61;;32;1;62;;32;0;0;{Bold:1}}
{R:0;63;49;3;1;64;59;3;0;0;{Italic:1}}
{R:0;65;424;3;1;66;436;3;0;0;{Bold:0}{Italic:1}}
{R:0;64;;32;1;65;;32;0;0;{Bold:1}}
{R:0;76;;32;1;77;;32;0;0;{Bold:1}}
{R:0;79;;32;1;82;;32;0;0;{StyleHandle:Indent}}
{R:0;71;;32;1;73;;32;0;0;{StyleHandle:Indent}}
{R:0;66;69;3;1;67;;32;0;0;{Italic:1}}
{R:0;66;73;3;1;67;;32;0;0;{Italic:0}}
{R:0;57;;32;1;58;;32;0;0;{StyleHandle:Indent}}
{R:0;57;;32;1;58;;32;0;0;{StyleHandle:MainHeading}}
{R:0;84;59;3;1;85;69;3;0;0;{Bold:1}}
{PageHefoBreakValues-H:0;0;0;;1;0;68;0;;;0;;;1;0;0;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;13472;13120;13440}
{ViewControl:100;0;1;1;0;0;0;2048;0;2048}
{CurrentPosition:0;1;0;3}
}
00000000 7b 56 65 72 73 69 6f 6e 3a 31 2e 30 35 2f 30 31 |{Version:1.05/01|
00000010 3b 31 38 20 4f 63 74 20 31 39 39 33 3b 46 69 72 |;18 Oct 1993;Fir|
00000020 65 77 6f 72 6b 7a 3b 43 6f 6c 74 6f 6e 20 53 6f |eworkz;Colton So|
00000030 66 74 77 61 72 65 3b 34 30 30 30 20 32 30 32 39 |ftware;4000 2029|
00000040 20 34 39 38 33 20 38 39 38 36 7d 0a 7b 42 6c 6f | 4983 8986}.{Blo|
00000050 63 6b 3a 30 3b 30 3b 3b 33 32 3b 31 3b 38 35 3b |ck:0;0;;32;1;85;|
00000060 3b 33 32 3b 31 3b 38 35 7d 0a 7b 53 74 79 6c 65 |;32;1;85}.{Style|
00000070 3a 42 61 73 65 4c 65 74 74 65 72 3b 7b 43 6f 6c |:BaseLetter;{Col|
00000080 57 69 64 74 68 3a 31 31 31 38 30 7d 7b 43 6f 6c |Width:11180}{Col|
00000090 4e 61 6d 65 3a 23 7d 7b 52 6f 77 48 65 69 67 68 |Name:#}{RowHeigh|
000000a0 74 3a 30 7d 7b 52 6f 77 48 65 69 67 68 74 46 69 |t:0}{RowHeightFi|
000000b0 78 3a 30 7d 7b 52 6f 77 55 6e 62 72 65 61 6b 61 |x:0}{RowUnbreaka|
000000c0 62 6c 65 3a 30 7d 7b 52 6f 77 4e 61 6d 65 3a 23 |ble:0}{RowName:#|
000000d0 7d 7b 4d 61 72 67 69 6e 4c 65 66 74 3a 31 31 39 |}{MarginLeft:119|
000000e0 30 7d 7b 4d 61 72 67 69 6e 52 69 67 68 74 3a 31 |0}{MarginRight:1|
000000f0 30 33 32 7d 7b 4d 61 72 67 69 6e 50 61 72 61 3a |032}{MarginPara:|
00000100 30 7d 7b 54 61 62 6c 69 73 74 3a 52 37 39 33 20 |0}{Tablist:R793 |
00000110 4c 31 31 33 35 20 4c 32 32 36 39 20 4c 33 34 30 |L1135 L2269 L340|
00000120 33 20 4c 34 35 33 37 20 4c 35 36 37 31 20 4c 36 |3 L4537 L5671 L6|
00000130 38 30 35 20 4c 37 39 33 39 20 4c 39 30 37 33 7d |805 L7939 L9073}|
00000140 7b 42 61 63 6b 67 72 6f 75 6e 64 3a 32 35 35 3b |{Background:255;|
00000150 32 35 35 3b 32 35 35 7d 7b 50 61 72 61 53 74 61 |255;255}{ParaSta|
00000160 72 74 3a 36 38 7d 7b 50 61 72 61 45 6e 64 3a 34 |rt:68}{ParaEnd:4|
00000170 35 7d 7b 4c 69 6e 65 53 70 61 63 65 3a 30 3b 37 |5}{LineSpace:0;7|
00000180 32 7d 7b 4a 75 73 74 69 66 79 3a 30 7d 7b 4e 65 |2}{Justify:0}{Ne|
00000190 77 4f 62 6a 65 63 74 3a 33 7d 7b 4e 75 6d 66 6f |wObject:3}{Numfo|
000001a0 72 6d 3a 23 2c 23 23 30 2e 30 30 7d 7b 4e 75 6d |rm:#,##0.00}{Num|
000001b0 66 6f 72 6d 44 54 3a 64 64 2e 6d 6d 2e 79 79 7d |formDT:dd.mm.yy}|
000001c0 7b 4e 75 6d 66 6f 72 6d 53 45 3a 40 7d 7b 42 6f |{NumformSE:@}{Bo|
000001d0 72 64 65 72 43 6f 6c 6f 75 72 3a 30 3b 31 38 37 |rderColour:0;187|
000001e0 3b 32 35 35 7d 7b 42 6f 72 64 65 72 3a 30 7d 7b |;255}{Border:0}{|
000001f0 47 72 69 64 4c 65 66 74 43 6f 6c 6f 75 72 3a 30 |GridLeftColour:0|
00000200 3b 31 38 37 3b 32 35 35 7d 7b 47 72 69 64 54 6f |;187;255}{GridTo|
00000210 70 43 6f 6c 6f 75 72 3a 30 3b 31 38 37 3b 32 35 |pColour:0;187;25|
00000220 35 7d 7b 47 72 69 64 52 69 67 68 74 43 6f 6c 6f |5}{GridRightColo|
00000230 75 72 3a 30 3b 31 38 37 3b 32 35 35 7d 7b 47 72 |ur:0;187;255}{Gr|
00000240 69 64 42 6f 74 74 6f 6d 43 6f 6c 6f 75 72 3a 30 |idBottomColour:0|
00000250 3b 31 38 37 3b 32 35 35 7d 7b 47 72 69 64 4c 65 |;187;255}{GridLe|
00000260 66 74 3a 30 7d 7b 47 72 69 64 54 6f 70 3a 30 7d |ft:0}{GridTop:0}|
00000270 7b 47 72 69 64 52 69 67 68 74 3a 30 7d 7b 47 72 |{GridRight:0}{Gr|
00000280 69 64 42 6f 74 74 6f 6d 3a 30 7d 7b 54 79 70 65 |idBottom:0}{Type|
00000290 66 61 63 65 3a 54 69 6d 65 73 7d 7b 46 6f 6e 74 |face:Times}{Font|
000002a0 78 3a 30 7d 7b 46 6f 6e 74 79 3a 32 38 30 7d 7b |x:0}{Fonty:280}{|
000002b0 55 6e 64 65 72 6c 69 6e 65 3a 30 7d 7b 42 6f 6c |Underline:0}{Bol|
000002c0 64 3a 30 7d 7b 49 74 61 6c 69 63 3a 30 7d 7b 53 |d:0}{Italic:0}{S|
000002d0 75 70 65 72 73 63 72 69 70 74 3a 30 7d 7b 53 75 |uperscript:0}{Su|
000002e0 62 73 63 72 69 70 74 3a 30 7d 7b 46 6f 72 65 67 |bscript:0}{Foreg|
000002f0 72 6f 75 6e 64 3a 30 3b 30 3b 30 7d 7d 0a 7b 53 |round:0;0;0}}.{S|
00000300 74 79 6c 65 42 61 73 65 3a 42 61 73 65 4c 65 74 |tyleBase:BaseLet|
00000310 74 65 72 7d 0a 7b 53 74 79 6c 65 3a 42 61 73 65 |ter}.{Style:Base|
00000320 48 65 61 64 46 6f 6f 74 7d 0a 7b 53 74 79 6c 65 |HeadFoot}.{Style|
00000330 48 65 61 64 65 72 46 6f 6f 74 65 72 3a 42 61 73 |HeaderFooter:Bas|
00000340 65 48 65 61 64 46 6f 6f 74 7d 0a 7b 53 74 79 6c |eHeadFoot}.{Styl|
00000350 65 3a 48 65 61 64 69 6e 67 3b 7b 4a 75 73 74 69 |e:Heading;{Justi|
00000360 66 79 3a 31 7d 7b 54 79 70 65 66 61 63 65 3a 54 |fy:1}{Typeface:T|
00000370 69 6d 65 73 7d 7b 46 6f 6e 74 79 3a 34 38 30 7d |imes}{Fonty:480}|
00000380 7b 42 6f 6c 64 3a 31 7d 7d 0a 7b 53 74 79 6c 65 |{Bold:1}}.{Style|
00000390 3a 4d 61 69 6e 48 65 61 64 69 6e 67 3b 7b 4d 61 |:MainHeading;{Ma|
000003a0 72 67 69 6e 4c 65 66 74 3a 31 31 39 30 7d 7b 4d |rginLeft:1190}{M|
000003b0 61 72 67 69 6e 52 69 67 68 74 3a 31 30 33 32 7d |arginRight:1032}|
000003c0 7b 4d 61 72 67 69 6e 50 61 72 61 3a 2d 36 32 33 |{MarginPara:-623|
000003d0 7d 7b 4a 75 73 74 69 66 79 3a 30 7d 7b 46 6f 6e |}{Justify:0}{Fon|
000003e0 74 79 3a 33 36 30 7d 7b 42 6f 6c 64 3a 31 7d 7d |ty:360}{Bold:1}}|
000003f0 0a 7b 53 74 79 6c 65 3a 49 6e 64 65 6e 74 3b 7b |.{Style:Indent;{|
00000400 4d 61 72 67 69 6e 4c 65 66 74 3a 31 38 31 34 7d |MarginLeft:1814}|
00000410 7b 4d 61 72 67 69 6e 52 69 67 68 74 3a 38 34 35 |{MarginRight:845|
00000420 7d 7b 4d 61 72 67 69 6e 50 61 72 61 3a 2d 35 36 |}{MarginPara:-56|
00000430 37 7d 7b 54 61 62 6c 69 73 74 3a 4c 31 7d 7d 0a |7}{Tablist:L1}}.|
00000440 7b 50 61 70 65 72 3a 44 65 66 61 75 6c 74 20 41 |{Paper:Default A|
00000450 34 3b 30 3b 31 36 38 34 30 3b 31 31 39 30 30 3b |4;0;16840;11900;|
00000460 34 36 30 3b 34 36 30 3b 33 36 30 3b 33 36 30 3b |460;460;360;360;|
00000470 30 3b 30 3b 30 3b 30 3b 33 32 3b 3b 30 7d 0a 7b |0;0;0;0;32;;0}.{|
00000480 50 72 69 6e 74 51 75 61 6c 69 74 79 3a 30 7d 0a |PrintQuality:0}.|
00000490 7b 53 74 61 72 74 4f 66 44 61 74 61 7d 0a 7b 53 |{StartOfData}.{S|
000004a0 3a 58 3b 58 3b 30 3b 31 3b 46 69 72 65 77 6f 72 |:X;X;0;1;Firewor|
000004b0 6b 7a 20 66 6f 72 20 50 69 70 65 44 72 65 61 6d |kz for PipeDream|
000004c0 20 55 73 65 72 73 7d 0a 7b 53 3a 58 3b 58 3b 30 | Users}.{S:X;X;0|
000004d0 3b 32 3b 54 68 69 73 20 64 6f 63 75 6d 65 6e 74 |;2;This document|
000004e0 20 69 73 20 74 6f 20 68 65 6c 70 20 50 69 70 65 | is to help Pipe|
000004f0 44 72 65 61 6d 20 75 73 65 72 73 20 67 65 74 20 |Dream users get |
00000500 74 68 65 20 6d 6f 73 74 20 6f 75 74 20 6f 66 20 |the most out of |
00000510 46 69 72 65 77 6f 72 6b 7a 2e 20 49 74 27 73 20 |Fireworkz. It's |
00000520 64 69 76 69 64 65 64 20 69 6e 74 6f 20 74 77 6f |divided into two|
00000530 20 73 65 63 74 69 6f 6e 73 20 61 63 63 6f 72 69 | sections accori|
00000540 6e 67 20 74 6f 20 77 68 65 74 68 65 72 20 69 74 |ng to whether it|
00000550 27 73 20 61 20 74 65 78 74 20 74 79 70 65 20 66 |'s a text type f|
00000560 69 6c 65 20 6c 6f 61 64 65 64 20 66 72 6f 6d 20 |ile loaded from |
00000570 50 69 70 65 44 72 65 61 6d 2c 20 6f 72 20 61 20 |PipeDream, or a |
00000580 73 70 72 65 61 64 73 68 65 65 74 20 74 79 70 65 |spreadsheet type|
00000590 20 66 69 6c 65 2e 7d 0a 7b 53 3a 58 3b 58 3b 30 | file.}.{S:X;X;0|
000005a0 3b 33 3b 57 68 65 6e 20 79 6f 75 20 6c 6f 61 64 |;3;When you load|
000005b0 20 61 20 50 69 70 65 44 72 65 61 6d 20 66 69 6c | a PipeDream fil|
000005c0 65 2c 20 79 6f 75 20 68 61 76 65 20 74 6f 20 64 |e, you have to d|
000005d0 65 63 69 64 65 20 77 68 65 74 68 65 72 20 74 6f |ecide whether to|
000005e0 20 63 6f 6e 76 65 72 74 20 69 74 20 61 73 20 61 | convert it as a|
000005f0 20 74 65 78 74 20 74 79 70 65 20 66 69 6c 65 2c | text type file,|
00000600 20 6f 72 20 61 20 73 70 72 65 61 64 73 68 65 65 | or a spreadshee|
00000610 74 20 74 79 70 65 20 66 69 6c 65 2e 20 49 66 20 |t type file. If |
00000620 79 6f 75 20 63 68 6f 6f 73 65 20 61 20 6c 65 74 |you choose a let|
00000630 74 65 72 20 74 79 70 65 20 74 65 6d 70 6c 61 74 |ter type templat|
00000640 65 2c 20 46 69 72 65 77 6f 72 6b 7a 20 77 69 6c |e, Fireworkz wil|
00000650 6c 20 6c 6f 61 64 20 74 68 65 20 50 69 70 65 44 |l load the PipeD|
00000660 72 65 61 6d 20 66 69 6c 65 20 61 73 20 61 20 74 |ream file as a t|
00000670 65 78 74 20 74 79 70 65 20 66 69 6c 65 2c 20 69 |ext type file, i|
00000680 67 6e 6f 72 69 6e 67 20 66 6f 72 6d 75 6c 61 73 |gnoring formulas|
00000690 20 61 6e 64 20 69 6e 73 65 72 74 69 6e 67 20 74 | and inserting t|
000006a0 61 62 73 20 66 6f 72 20 63 6f 6c 75 6d 6e 73 20 |abs for columns |
000006b0 69 6e 20 74 68 65 20 50 69 70 65 44 72 65 61 6d |in the PipeDream|
000006c0 20 66 69 6c 65 2e 20 49 66 20 79 6f 75 20 63 68 | file. If you ch|
000006d0 6f 6f 73 65 20 61 20 73 68 65 65 74 20 74 79 70 |oose a sheet typ|
000006e0 65 20 74 65 6d 70 6c 61 74 65 2c 20 46 69 72 65 |e template, Fire|
000006f0 77 6f 72 6b 7a 20 77 69 6c 6c 20 6c 6f 61 64 20 |workz will load |
00000700 74 68 65 20 66 69 6c 65 20 61 73 20 61 20 73 70 |the file as a sp|
00000710 72 65 61 64 73 68 65 65 74 5c 5c 5c 3b 20 79 6f |readsheet\\\; yo|
00000720 75 72 20 66 6f 72 6d 75 6c 61 73 20 77 69 6c 6c |ur formulas will|
00000730 20 62 65 20 63 6f 6e 76 65 72 74 65 64 2c 20 61 | be converted, a|
00000740 6e 64 20 50 69 70 65 44 72 65 61 6d 20 63 6f 6c |nd PipeDream col|
00000750 75 6d 6e 73 20 77 69 6c 6c 20 62 65 20 63 6f 6e |umns will be con|
00000760 76 65 72 74 65 64 20 74 6f 20 46 69 72 65 77 6f |verted to Firewo|
00000770 72 6b 7a 20 63 6f 6c 75 6d 6e 73 2e 7d 0a 7b 53 |rkz columns.}.{S|
00000780 3a 58 3b 58 3b 30 3b 34 3b 54 68 65 20 74 77 6f |:X;X;0;4;The two|
00000790 20 73 65 63 74 69 6f 6e 73 20 6f 66 20 74 68 69 | sections of thi|
000007a0 73 20 64 6f 63 75 6d 65 6e 74 20 64 65 73 63 72 |s document descr|
000007b0 69 62 65 20 74 68 65 20 74 77 6f 20 64 69 66 66 |ibe the two diff|
000007c0 65 72 65 6e 74 20 74 79 70 65 73 20 6f 66 20 64 |erent types of d|
000007d0 6f 63 75 6d 65 6e 74 20 63 72 65 61 74 65 64 2e |ocument created.|
000007e0 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 35 3b 54 6f 20 |}.{S:X;X;0;5;To |
000007f0 6d 61 6b 65 20 46 69 72 65 77 6f 72 6b 7a 20 6c |make Fireworkz l|
00000800 6f 61 64 20 61 20 50 69 70 65 44 72 65 61 6d 20 |oad a PipeDream |
00000810 66 69 6c 65 2c 20 61 6c 6c 20 79 6f 75 20 68 61 |file, all you ha|
00000820 76 65 20 74 6f 20 64 6f 20 69 73 20 64 72 6f 70 |ve to do is drop|
00000830 20 74 68 65 20 50 69 70 65 44 72 65 61 6d 20 66 | the PipeDream f|
00000840 69 6c 65 20 6f 6e 20 74 68 65 20 46 69 72 65 77 |ile on the Firew|
00000850 6f 72 6b 7a 20 69 63 6f 6e 2c 20 74 68 65 6e 20 |orkz icon, then |
00000860 63 68 6f 6f 73 65 20 74 68 65 20 6c 65 74 74 65 |choose the lette|
00000870 72 20 6f 72 20 73 70 72 65 61 64 73 68 65 65 74 |r or spreadsheet|
00000880 20 74 65 6d 70 6c 61 74 65 20 61 73 20 72 65 71 | template as req|
00000890 75 69 72 65 64 2e 7d 0a 7b 53 3a 58 3b 58 3b 30 |uired.}.{S:X;X;0|
000008a0 3b 36 3b 54 65 78 74 20 66 69 6c 65 73 20 2d 20 |;6;Text files - |
000008b0 6c 65 74 74 65 72 20 74 65 6d 70 6c 61 74 65 7d |letter template}|
000008c0 0a 7b 53 3a 58 3b 58 3b 30 3b 37 3b 49 66 20 79 |.{S:X;X;0;7;If y|
000008d0 6f 75 20 75 73 65 20 74 68 65 20 6c 65 74 74 65 |ou use the lette|
000008e0 72 20 74 65 6d 70 6c 61 74 65 2c 20 50 69 70 65 |r template, Pipe|
000008f0 44 72 65 61 6d 20 66 69 6c 65 73 20 61 72 65 20 |Dream files are |
00000900 6c 6f 61 64 65 64 20 69 6e 74 6f 20 6f 6e 65 20 |loaded into one |
00000910 63 6f 6c 75 6d 6e 2c 20 6e 6f 20 6d 61 74 74 65 |column, no matte|
00000920 72 20 68 6f 77 20 6d 61 6e 79 20 63 6f 6c 75 6d |r how many colum|
00000930 6e 73 20 61 72 65 20 69 6e 20 74 68 65 20 6f 72 |ns are in the or|
00000940 69 67 69 6e 61 6c 2e 20 54 65 78 74 20 69 6e 20 |iginal. Text in |
00000950 64 69 66 66 65 72 65 6e 74 20 63 6f 6c 75 6d 6e |different column|
00000960 73 20 69 6e 20 74 68 65 20 50 69 70 65 44 72 65 |s in the PipeDre|
00000970 61 6d 20 66 69 6c 65 20 69 73 20 73 65 70 61 72 |am file is separ|
00000980 61 74 65 64 20 62 79 20 74 61 62 73 20 77 68 65 |ated by tabs whe|
00000990 6e 20 69 74 20 61 72 72 69 76 65 73 20 69 6e 20 |n it arrives in |
000009a0 74 68 65 20 46 69 72 65 77 6f 72 6b 7a 20 66 69 |the Fireworkz fi|
000009b0 6c 65 2e 20 42 6c 61 6e 6b 20 63 6f 6c 75 6d 6e |le. Blank column|
000009c0 73 20 61 74 20 74 68 65 20 73 74 61 72 74 20 6f |s at the start o|
000009d0 66 20 74 68 65 20 50 69 70 65 44 72 65 61 6d 20 |f the PipeDream |
000009e0 66 69 6c 65 20 61 72 65 20 73 74 72 69 70 70 65 |file are strippe|
000009f0 64 20 6f 75 74 2c 20 61 6e 64 20 46 69 72 65 77 |d out, and Firew|
00000a00 6f 72 6b 7a 20 64 6f 65 73 20 69 74 73 20 62 65 |orkz does its be|
00000a10 73 74 20 74 6f 20 72 65 63 6f 67 6e 69 73 65 20 |st to recognise |
00000a20 70 61 72 61 67 72 61 70 68 73 20 69 6e 20 74 68 |paragraphs in th|
00000a30 65 20 50 69 70 65 44 72 65 61 6d 20 66 69 6c 65 |e PipeDream file|
00000a40 2e 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 38 3b 55 6e |.}.{S:X;X;0;8;Un|
00000a50 64 65 72 6c 69 6e 65 2c 20 62 6f 6c 64 2c 20 69 |derline, bold, i|
00000a60 74 61 6c 69 63 2c 20 73 75 70 65 72 73 63 72 69 |talic, superscri|
00000a70 70 74 20 61 6e 64 20 73 75 62 73 63 72 69 70 74 |pt and subscript|
00000a80 20 68 69 67 68 6c 69 67 68 74 73 20 61 72 65 20 | highlights are |
00000a90 63 6f 6e 76 65 72 74 65 64 20 62 79 20 46 69 72 |converted by Fir|
00000aa0 65 77 6f 72 6b 7a 20 69 6e 74 6f 20 63 6f 72 72 |eworkz into corr|
00000ab0 65 73 70 6f 6e 64 69 6e 67 20 74 65 78 74 20 65 |esponding text e|
00000ac0 66 66 65 63 74 20 72 65 67 69 6f 6e 73 2e 20 54 |ffect regions. T|
00000ad0 68 65 20 40 44 40 20 66 69 65 6c 64 20 69 73 20 |he @D@ field is |
00000ae0 63 6f 6e 76 65 72 74 65 64 20 69 6e 74 6f 20 61 |converted into a|
00000af0 20 46 69 72 65 77 6f 72 6b 7a 20 6c 69 76 65 20 | Fireworkz live |
00000b00 64 61 74 65 20 69 6e 73 65 72 74 5c 5c 5c 3b 20 |date insert\\\; |
00000b10 6f 74 68 65 72 20 40 20 66 69 65 6c 64 73 20 61 |other @ fields a|
00000b20 72 65 20 73 74 72 69 70 70 65 64 20 6f 75 74 2e |re stripped out.|
00000b30 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 39 3b 4f 74 68 |}.{S:X;X;0;9;Oth|
00000b40 65 72 20 50 69 70 65 44 72 65 61 6d 20 6f 70 74 |er PipeDream opt|
00000b50 69 6f 6e 73 2c 20 70 61 67 65 20 73 69 7a 65 73 |ions, page sizes|
00000b60 2c 20 66 6f 6e 74 73 20 61 6e 64 20 68 65 61 64 |, fonts and head|
00000b70 65 72 73 20 61 6e 64 20 66 6f 6f 74 65 72 73 20 |ers and footers |
00000b80 61 72 65 20 6e 6f 74 20 63 6f 6e 76 65 72 74 65 |are not converte|
00000b90 64 2e 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 31 30 3b |d.}.{S:X;X;0;10;|
00000ba0 50 69 70 65 44 72 65 61 6d 20 74 65 78 74 20 66 |PipeDream text f|
00000bb0 69 6c 65 73 20 73 75 63 68 20 61 73 20 6c 65 74 |iles such as let|
00000bc0 74 65 72 73 20 61 6e 64 20 72 65 70 6f 72 74 73 |ters and reports|
00000bd0 20 63 6f 6e 76 65 72 74 20 71 75 69 74 65 20 73 | convert quite s|
00000be0 75 63 63 65 73 73 66 75 6c 6c 79 2e 20 4f 6e 63 |uccessfully. Onc|
00000bf0 65 20 79 6f 75 20 68 61 76 65 20 74 68 65 20 64 |e you have the d|
00000c00 61 74 61 20 69 6e 20 46 69 72 65 77 6f 72 6b 7a |ata in Fireworkz|
00000c10 20 79 6f 75 20 63 61 6e 20 71 75 69 63 6b 6c 79 | you can quickly|
00000c20 20 69 6d 70 72 6f 76 65 20 74 68 65 20 6c 61 79 | improve the lay|
00000c30 6f 75 74 20 62 79 20 61 64 6a 75 73 74 69 6e 67 |out by adjusting|
00000c40 20 74 61 62 73 74 6f 70 73 20 61 6e 64 20 61 70 | tabstops and ap|
00000c50 70 6c 79 69 6e 67 20 73 74 79 6c 65 73 20 6f 72 |plying styles or|
00000c60 20 61 6c 74 65 72 69 6e 67 20 74 68 65 20 42 61 | altering the Ba|
00000c70 73 65 20 73 74 79 6c 65 2e 7d 0a 7b 53 3a 58 3b |se style.}.{S:X;|
00000c80 58 3b 30 3b 31 31 3b 49 66 20 79 6f 75 20 68 61 |X;0;11;If you ha|
00000c90 76 65 20 74 61 62 75 6c 61 72 20 64 61 74 61 20 |ve tabular data |
00000ca0 69 6e 20 50 69 70 65 44 72 65 61 6d 20 2d 20 73 |in PipeDream - s|
00000cb0 75 63 68 20 61 73 20 61 20 73 70 72 65 61 64 73 |uch as a spreads|
00000cc0 68 65 65 74 20 6f 72 20 64 61 74 61 62 61 73 65 |heet or database|
00000cd0 20 74 68 61 74 20 79 6f 75 20 77 61 6e 74 20 69 | that you want i|
00000ce0 6e 20 74 61 62 75 6c 61 72 20 66 6f 72 6d 20 69 |n tabular form i|
00000cf0 6e 20 46 69 72 65 77 6f 72 6b 7a 20 2d 20 6c 6f |n Fireworkz - lo|
00000d00 61 64 20 69 74 20 75 73 69 6e 67 20 74 68 65 20 |ad it using the |
00000d10 73 68 65 65 74 20 74 65 6d 70 6c 61 74 65 2c 20 |sheet template, |
00000d20 6f 72 20 65 78 70 6f 72 74 20 69 74 20 61 73 20 |or export it as |
00000d30 61 20 43 53 56 20 66 69 6c 65 20 61 6e 64 20 6c |a CSV file and l|
00000d40 6f 61 64 20 69 74 20 69 6e 74 6f 20 61 20 46 69 |oad it into a Fi|
00000d50 72 65 77 6f 72 6b 7a 20 74 61 62 6c 65 2e 7d 0a |reworkz table.}.|
00000d60 7b 53 3a 58 3b 58 3b 30 3b 31 32 3b 45 64 69 74 |{S:X;X;0;12;Edit|
00000d70 69 6e 67 20 69 6e 20 46 69 72 65 77 6f 72 6b 7a |ing in Fireworkz|
00000d80 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 31 33 3b 49 66 |}.{S:X;X;0;13;If|
00000d90 20 79 6f 75 20 75 73 65 20 50 69 70 65 44 72 65 | you use PipeDre|
00000da0 61 6d 20 61 20 6c 6f 74 20 61 6e 64 20 61 73 20 |am a lot and as |
00000db0 79 6f 75 72 20 6d 61 69 6e 20 61 70 70 6c 69 63 |your main applic|
00000dc0 61 74 69 6f 6e 2c 20 79 6f 75 20 6d 61 79 20 77 |ation, you may w|
00000dd0 65 6c 6c 20 66 69 6e 64 20 65 64 69 74 69 6e 67 |ell find editing|
00000de0 20 74 65 78 74 20 69 6e 20 46 69 72 65 77 6f 72 | text in Firewor|
00000df0 6b 7a 20 61 20 6c 69 74 74 6c 65 20 77 65 69 72 |kz a little weir|
00000e00 64 20 74 6f 20 62 65 67 69 6e 20 77 69 74 68 2e |d to begin with.|
00000e10 20 54 68 69 73 20 69 73 20 6e 6f 74 20 62 65 63 | This is not bec|
00000e20 61 75 73 65 20 46 69 72 65 77 6f 72 6b 7a 20 69 |ause Fireworkz i|
00000e30 73 20 64 69 66 66 69 63 75 6c 74 2c 20 62 75 74 |s difficult, but|
00000e40 20 62 65 63 61 75 73 65 20 50 69 70 65 44 72 65 | because PipeDre|
00000e50 61 6d 20 69 73 20 76 65 72 79 20 75 6e 75 73 75 |am is very unusu|
00000e60 61 6c 2e 20 53 6b 69 6c 6c 73 20 74 68 61 74 20 |al. Skills that |
00000e70 79 6f 75 20 6c 65 61 72 6e 20 69 6e 20 46 69 72 |you learn in Fir|
00000e80 65 77 6f 72 6b 7a 20 77 69 6c 6c 20 62 65 20 61 |eworkz will be a|
00000e90 70 70 6c 69 63 61 62 6c 65 20 74 6f 20 6c 6f 74 |pplicable to lot|
00000ea0 73 20 6f 66 20 6f 74 68 65 72 20 70 72 6f 67 72 |s of other progr|
00000eb0 61 6d 73 2c 20 77 68 65 72 65 61 73 20 79 6f 75 |ams, whereas you|
00000ec0 72 20 68 61 72 64 2d 77 6f 6e 20 50 69 70 65 44 |r hard-won PipeD|
00000ed0 72 65 61 6d 20 73 6b 69 6c 6c 73 20 72 65 61 6c |ream skills real|
00000ee0 6c 79 20 61 70 70 6c 79 20 6f 6e 6c 79 20 74 6f |ly apply only to|
00000ef0 20 50 69 70 65 44 72 65 61 6d 2e 7d 0a 7b 53 3a | PipeDream.}.{S:|
00000f00 58 3b 58 3b 30 3b 31 34 3b 46 69 72 73 74 20 6f |X;X;0;14;First o|
00000f10 66 20 61 6c 6c 2c 20 74 68 65 20 52 65 74 75 72 |f all, the Retur|
00000f20 6e 20 6b 65 79 20 69 6e 20 46 69 72 65 77 6f 72 |n key in Firewor|
00000f30 6b 7a 20 73 70 6c 69 74 73 20 61 20 70 61 72 61 |kz splits a para|
00000f40 67 72 61 70 68 2e 20 49 6e 20 50 69 70 65 44 72 |graph. In PipeDr|
00000f50 65 61 6d 20 69 74 20 6a 75 73 74 20 6d 6f 76 65 |eam it just move|
00000f60 73 20 74 68 65 20 63 61 72 65 74 20 28 75 6e 6c |s the caret (unl|
00000f70 65 73 73 20 79 6f 75 20 68 61 76 65 20 49 6e 73 |ess you have Ins|
00000f80 65 72 74 20 6f 6e 20 52 65 74 75 72 6e 20 73 77 |ert on Return sw|
00000f90 69 74 63 68 65 64 20 6f 6e 29 2e 20 50 72 65 73 |itched on). Pres|
00000fa0 73 69 6e 67 20 44 65 6c 65 74 65 20 28 6f 72 20 |sing Delete (or |
00000fb0 62 61 63 6b 73 70 61 63 65 29 20 61 74 20 74 68 |backspace) at th|
00000fc0 65 20 73 74 61 72 74 20 6f 66 20 61 20 70 61 72 |e start of a par|
00000fd0 61 67 72 61 70 68 20 6a 6f 69 6e 73 20 74 77 6f |agraph joins two|
00000fe0 20 70 61 72 61 67 72 61 70 68 73 20 74 6f 67 65 | paragraphs toge|
00000ff0 74 68 65 72 2e 20 54 68 65 72 65 27 73 20 6e 6f |ther. There's no|
00001000 20 49 6e 73 65 72 74 20 6c 69 6e 65 20 28 43 74 | Insert line (Ct|
00001010 72 6c 2d 4e 2f 46 37 29 20 6f 72 20 44 65 6c 65 |rl-N/F7) or Dele|
00001020 74 65 20 6c 69 6e 65 20 28 43 74 72 6c 2d 59 2f |te line (Ctrl-Y/|
00001030 46 38 29 20 69 6e 20 46 69 72 65 77 6f 72 6b 7a |F8) in Fireworkz|
00001040 2e 20 55 73 65 20 52 65 74 75 72 6e 20 61 6e 64 |. Use Return and|
00001050 20 44 65 6c 65 74 65 20 74 6f 20 64 6f 20 74 68 | Delete to do th|
00001060 69 73 2e 20 53 70 6c 69 74 20 61 6e 64 20 4a 6f |is. Split and Jo|
00001070 69 6e 20 6c 69 6e 65 73 20 28 43 74 72 6c 2d 45 |in lines (Ctrl-E|
00001080 53 4c 2f 53 68 69 66 74 20 46 37 20 61 6e 64 20 |SL/Shift F7 and |
00001090 43 74 72 6c 2d 45 4a 4c 2f 53 68 69 66 74 20 46 |Ctrl-EJL/Shift F|
000010a0 38 29 20 61 72 65 20 61 6c 73 6f 20 72 65 70 6c |8) are also repl|
000010b0 61 63 65 64 20 62 79 20 52 65 74 75 72 6e 20 61 |aced by Return a|
000010c0 6e 64 20 44 65 6c 65 74 65 2e 20 54 6f 20 73 70 |nd Delete. To sp|
000010d0 6c 69 74 20 61 20 70 61 72 61 67 72 61 70 68 2c |lit a paragraph,|
000010e0 20 70 6f 73 69 74 69 6f 6e 20 74 68 65 20 63 61 | position the ca|
000010f0 72 65 74 20 77 68 65 72 65 20 79 6f 75 20 77 61 |ret where you wa|
00001100 6e 74 20 74 68 65 20 73 70 6c 69 74 2c 20 61 6e |nt the split, an|
00001110 64 20 70 72 65 73 73 20 52 65 74 75 72 6e 2e 20 |d press Return. |
00001120 54 6f 20 6a 6f 69 6e 20 74 6f 67 65 74 68 65 72 |To join together|
00001130 20 74 77 6f 20 70 61 72 61 67 72 61 70 68 73 2c | two paragraphs,|
00001140 20 70 75 74 20 74 68 65 20 63 61 72 65 74 20 61 | put the caret a|
00001150 74 20 74 68 65 20 73 74 61 72 74 20 6f 66 20 74 |t the start of t|
00001160 68 65 20 73 65 63 6f 6e 64 20 70 61 72 61 67 72 |he second paragr|
00001170 61 70 68 20 61 6e 64 20 70 72 65 73 73 20 44 65 |aph and press De|
00001180 6c 65 74 65 2e 7d 0a 7b 53 3a 58 3b 58 3b 30 3b |lete.}.{S:X;X;0;|
00001190 31 35 3b 54 6f 20 62 65 63 6f 6d 65 20 73 6c 69 |15;To become sli|
000011a0 63 6b 20 77 69 74 68 20 46 69 72 65 77 6f 72 6b |ck with Firework|
000011b0 7a 20 79 6f 75 20 77 69 6c 6c 20 6e 65 65 64 20 |z you will need |
000011c0 74 6f 20 67 65 74 20 75 73 65 64 20 74 6f 20 6d |to get used to m|
000011d0 61 6b 69 6e 67 20 73 65 6c 65 63 74 69 6f 6e 73 |aking selections|
000011e0 20 6f 66 20 70 69 65 63 65 73 20 6f 66 20 74 65 | of pieces of te|
000011f0 78 74 2e 20 4f 66 20 63 6f 75 72 73 65 2c 20 79 |xt. Of course, y|
00001200 6f 75 20 63 61 6e 20 73 65 6c 65 63 74 20 74 65 |ou can select te|
00001210 78 74 20 69 6e 20 50 69 70 65 44 72 65 61 6d 2c |xt in PipeDream,|
00001220 20 62 75 74 20 6e 65 76 65 72 20 6c 65 73 73 20 | but never less |
00001230 74 68 61 6e 20 61 20 73 69 6e 67 6c 65 20 6c 69 |than a single li|
00001240 6e 65 2c 20 77 68 65 72 65 61 73 20 69 6e 20 46 |ne, whereas in F|
00001250 69 72 65 77 6f 72 6b 7a 20 79 6f 75 20 63 61 6e |ireworkz you can|
00001260 20 73 65 6c 65 63 74 20 61 20 77 6f 72 64 2c 20 | select a word, |
00001270 61 20 73 69 6e 67 6c 65 20 63 68 61 72 61 63 74 |a single charact|
00001280 65 72 20 6f 72 20 61 6e 79 20 70 61 72 74 20 6f |er or any part o|
00001290 66 20 61 20 70 61 72 61 67 72 61 70 68 2e 20 53 |f a paragraph. S|
000012a0 65 6c 65 63 74 20 74 65 78 74 20 65 69 74 68 65 |elect text eithe|
000012b0 72 20 62 79 20 64 72 61 67 67 69 6e 67 20 6f 76 |r by dragging ov|
000012c0 65 72 20 69 74 20 77 69 74 68 20 74 68 65 20 6c |er it with the l|
000012d0 65 66 74 20 6d 6f 75 73 65 20 62 75 74 74 6f 6e |eft mouse button|
000012e0 20 68 65 6c 64 20 64 6f 77 6e 2c 20 6f 72 20 62 | held down, or b|
000012f0 79 20 70 6f 73 69 74 69 6f 6e 69 6e 67 20 74 68 |y positioning th|
00001300 65 20 63 61 72 65 74 20 61 74 20 6f 6e 65 20 65 |e caret at one e|
00001310 6e 64 20 6f 66 20 74 68 65 20 74 65 78 74 20 74 |nd of the text t|
00001320 6f 20 62 65 20 73 65 6c 65 63 74 65 64 20 61 6e |o be selected an|
00001330 64 20 63 6c 69 63 6b 69 6e 67 20 74 68 65 20 72 |d clicking the r|
00001340 69 67 68 74 20 62 75 74 74 6f 6e 20 61 74 20 74 |ight button at t|
00001350 68 65 20 6f 74 68 65 72 20 65 6e 64 2e 7d 0a 7b |he other end.}.{|
00001360 53 3a 58 3b 58 3b 30 3b 31 36 3b 4f 6e 63 65 20 |S:X;X;0;16;Once |
00001370 79 6f 75 20 68 61 76 65 20 73 6f 6d 65 20 74 65 |you have some te|
00001380 78 74 20 73 65 6c 65 63 74 65 64 20 79 6f 75 20 |xt selected you |
00001390 63 61 6e 20 64 6f 20 76 61 72 69 6f 75 73 20 74 |can do various t|
000013a0 68 69 6e 67 73 3a 20 7d 0a 7b 53 3a 58 3b 58 3b |hings: }.{S:X;X;|
000013b0 30 3b 31 37 3b 41 70 70 6c 79 20 61 6e 20 65 66 |0;17;Apply an ef|
000013c0 66 65 63 74 20 6c 69 6b 65 20 42 6f 6c 64 20 28 |fect like Bold (|
000013d0 62 79 20 63 6c 69 63 6b 69 6e 67 20 6f 6e 20 74 |by clicking on t|
000013e0 68 65 20 42 6f 6c 64 20 62 75 74 74 6f 6e 29 2c |he Bold button),|
000013f0 20 6f 72 20 61 20 73 74 79 6c 65 20 28 62 79 20 | or a style (by |
00001400 63 68 6f 6f 73 69 6e 67 20 61 20 73 74 79 6c 65 |choosing a style|
00001410 20 66 72 6f 6d 20 74 68 65 20 73 74 79 6c 65 20 | from the style |
00001420 6c 69 73 74 20 62 6f 78 20 2d 20 63 6c 69 63 6b |list box - click|
00001430 20 6f 6e 20 74 68 65 20 53 74 79 6c 65 20 62 75 | on the Style bu|
00001440 74 74 6f 6e 20 66 69 72 73 74 29 2e 7d 0a 7b 53 |tton first).}.{S|
00001450 3a 58 3b 58 3b 30 3b 31 38 3b 43 75 74 20 74 68 |:X;X;0;18;Cut th|
00001460 65 20 74 65 78 74 20 2d 20 63 6c 69 63 6b 20 6f |e text - click o|
00001470 6e 20 74 68 65 20 43 75 74 20 69 63 6f 6e 20 28 |n the Cut icon (|
00001480 74 68 65 20 73 63 69 73 73 6f 72 73 29 2e 20 54 |the scissors). T|
00001490 68 69 73 20 73 74 6f 72 65 73 20 74 68 65 20 74 |his stores the t|
000014a0 65 78 74 20 74 65 6d 70 6f 72 61 72 69 6c 79 20 |ext temporarily |
000014b0 73 6f 20 74 68 61 74 20 79 6f 75 20 63 61 6e 20 |so that you can |
000014c0 6d 6f 76 65 20 74 68 65 20 63 61 72 65 74 20 73 |move the caret s|
000014d0 6f 6d 65 77 68 65 72 65 20 65 6c 73 65 20 61 6e |omewhere else an|
000014e0 64 20 72 65 2d 69 6e 73 65 72 74 20 74 68 65 20 |d re-insert the |
000014f0 74 65 78 74 20 62 79 20 63 6c 69 63 6b 69 6e 67 |text by clicking|
00001500 20 6f 6e 20 74 68 65 20 50 61 73 74 65 20 69 63 | on the Paste ic|
00001510 6f 6e 20 28 67 6c 75 65 20 70 6f 74 20 61 6e 64 |on (glue pot and|
00001520 20 62 72 75 73 68 29 2e 20 4e 6f 74 65 20 74 68 | brush). Note th|
00001530 61 74 20 69 74 20 6f 6e 6c 79 20 72 65 6d 65 6d |at it only remem|
00001540 62 65 72 73 20 74 68 65 20 6c 61 73 74 20 70 69 |bers the last pi|
00001550 65 63 65 20 6f 66 20 74 65 78 74 20 74 68 61 74 |ece of text that|
00001560 20 68 61 73 20 62 65 65 6e 20 63 75 74 2e 7d 0a | has been cut.}.|
00001570 7b 53 3a 58 3b 58 3b 30 3b 31 39 3b 44 65 6c 65 |{S:X;X;0;19;Dele|
00001580 74 65 20 74 68 65 20 74 65 78 74 20 2d 20 70 72 |te the text - pr|
00001590 65 73 73 20 74 68 65 20 44 65 6c 65 74 65 20 6b |ess the Delete k|
000015a0 65 79 2e 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 32 30 |ey.}.{S:X;X;0;20|
000015b0 3b 54 79 70 65 20 6f 76 65 72 20 74 68 65 20 74 |;Type over the t|
000015c0 65 78 74 20 2d 20 74 68 69 73 20 63 75 74 73 20 |ext - this cuts |
000015d0 74 68 65 20 73 65 6c 65 63 74 65 64 20 74 65 78 |the selected tex|
000015e0 74 20 74 6f 20 74 68 65 20 63 6c 69 70 62 6f 61 |t to the clipboa|
000015f0 72 64 20 61 6e 64 20 73 74 61 72 74 73 20 69 6e |rd and starts in|
00001600 73 65 72 74 69 6e 67 20 74 68 65 20 6e 65 77 20 |serting the new |
00001610 74 65 78 74 20 69 6e 20 74 68 65 20 70 6c 61 63 |text in the plac|
00001620 65 20 6f 66 20 74 68 65 20 6f 72 69 67 69 6e 61 |e of the origina|
00001630 6c 2e 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 32 31 3b |l.}.{S:X;X;0;21;|
00001640 54 68 65 72 65 20 61 72 65 20 73 6f 6d 65 20 75 |There are some u|
00001650 73 65 66 75 6c 20 73 68 6f 72 74 63 75 74 73 20 |seful shortcuts |
00001660 74 6f 20 6d 61 6b 69 6e 67 20 73 65 6c 65 63 74 |to making select|
00001670 69 6f 6e 73 3a 20 64 6f 75 62 6c 65 2d 63 6c 69 |ions: double-cli|
00001680 63 6b 20 77 69 74 68 20 74 68 65 20 6d 6f 75 73 |ck with the mous|
00001690 65 2c 20 6f 72 20 43 74 72 6c 2d 57 20 66 72 6f |e, or Ctrl-W fro|
000016a0 6d 20 74 68 65 20 6b 65 79 62 6f 61 72 64 20 73 |m the keyboard s|
000016b0 65 6c 65 63 74 73 20 61 20 77 6f 72 64 5c 5c 5c |elects a word\\\|
000016c0 3b 20 74 72 69 70 6c 65 20 63 6c 69 63 6b 2c 20 |; triple click, |
000016d0 6f 72 20 43 74 72 6c 2d 50 20 73 65 6c 65 63 74 |or Ctrl-P select|
000016e0 73 20 61 20 77 68 6f 6c 65 20 70 61 72 61 67 72 |s a whole paragr|
000016f0 61 70 68 2e 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 32 |aph.}.{S:X;X;0;2|
00001700 32 3b 53 70 72 65 61 64 73 68 65 65 74 20 66 69 |2;Spreadsheet fi|
00001710 6c 65 73 20 2d 20 73 68 65 65 74 20 74 65 6d 70 |les - sheet temp|
00001720 6c 61 74 65 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 32 |late}.{S:X;X;0;2|
00001730 33 3b 46 69 72 65 77 6f 72 6b 7a 20 69 73 20 6e |3;Fireworkz is n|
00001740 6f 74 20 50 69 70 65 44 72 65 61 6d 2e 20 46 69 |ot PipeDream. Fi|
00001750 72 65 77 6f 72 6b 7a 20 68 61 73 20 62 65 65 6e |reworkz has been|
00001760 20 64 65 73 69 67 6e 65 64 20 66 72 6f 6d 20 73 | designed from s|
00001770 63 72 61 74 63 68 20 74 6f 20 62 65 20 74 68 65 |cratch to be the|
00001780 20 6d 6f 73 74 20 61 64 76 61 6e 63 65 64 20 69 | most advanced i|
00001790 6e 74 65 67 72 61 74 65 64 20 70 72 6f 67 72 61 |ntegrated progra|
000017a0 6d 20 61 76 61 69 6c 61 62 6c 65 20 66 6f 72 20 |m available for |
000017b0 52 49 53 43 20 4f 53 2e 20 4d 61 6e 79 20 46 69 |RISC OS. Many Fi|
000017c0 72 65 77 6f 72 6b 7a 20 75 73 65 72 73 20 77 69 |reworkz users wi|
000017d0 6c 6c 20 68 61 76 65 20 75 73 65 64 20 50 69 70 |ll have used Pip|
000017e0 65 44 72 65 61 6d 2e 20 54 68 69 73 20 64 6f 63 |eDream. This doc|
000017f0 75 6d 65 6e 74 20 69 6e 74 72 6f 64 75 63 65 73 |ument introduces|
00001800 20 74 68 65 20 66 65 61 74 75 72 65 73 20 6f 66 | the features of|
00001810 20 74 68 65 20 46 69 72 65 77 6f 72 6b 7a 20 73 | the Fireworkz s|
00001820 70 65 61 64 73 68 65 65 74 20 77 68 69 63 68 20 |peadsheet which |
00001830 77 69 6c 6c 20 62 65 20 6e 65 77 20 74 6f 20 50 |will be new to P|
00001840 69 70 65 44 72 65 61 6d 20 75 73 65 72 73 2e 7d |ipeDream users.}|
00001850 0a 7b 53 3a 58 3b 58 3b 30 3b 32 34 3b 50 61 67 |.{S:X;X;0;24;Pag|
00001860 65 20 6c 61 79 6f 75 74 2e 20 46 69 72 65 77 6f |e layout. Firewo|
00001870 72 6b 7a 27 20 70 61 67 65 20 6c 61 79 6f 75 74 |rkz' page layout|
00001880 20 66 61 63 69 6c 69 74 69 65 73 20 67 6f 20 66 | facilities go f|
00001890 61 72 20 62 65 79 6f 6e 64 20 61 6e 79 20 6f 74 |ar beyond any ot|
000018a0 68 65 72 20 73 70 72 65 61 64 73 68 65 65 74 20 |her spreadsheet |
000018b0 70 72 6f 67 72 61 6d 20 61 76 61 69 6c 61 62 6c |program availabl|
000018c0 65 20 6f 6e 20 74 68 65 20 41 72 63 68 69 6d 65 |e on the Archime|
000018d0 64 65 73 2c 20 6f 72 20 57 69 6e 64 6f 77 73 20 |des, or Windows |
000018e0 6f 72 20 4d 61 63 69 6e 74 6f 73 68 2e 20 7d 0a |or Macintosh. }.|
000018f0 7b 53 3a 58 3b 58 3b 30 3b 32 35 3b 54 68 65 20 |{S:X;X;0;25;The |
00001900 73 70 72 65 61 64 73 68 65 65 74 20 77 69 6e 64 |spreadsheet wind|
00001910 6f 77 20 69 73 20 70 61 67 65 2d 62 61 73 65 64 |ow is page-based|
00001920 20 61 6e 64 20 63 6f 6d 70 6c 65 74 65 6c 79 20 | and completely |
00001930 57 59 53 49 57 59 47 2e 20 4a 75 73 74 20 6c 69 |WYSIWYG. Just li|
00001940 6b 65 20 61 20 44 54 50 20 73 79 73 74 65 6d 20 |ke a DTP system |
00001950 79 6f 75 20 73 65 65 20 74 68 65 20 70 61 67 65 |you see the page|
00001960 73 20 65 78 61 63 74 6c 79 20 61 73 20 74 68 65 |s exactly as the|
00001970 79 20 77 69 6c 6c 20 70 72 69 6e 74 2e 20 59 6f |y will print. Yo|
00001980 75 20 63 61 6e 20 68 61 76 65 20 6d 75 6c 74 69 |u can have multi|
00001990 70 6c 65 20 76 69 65 77 73 20 61 6e 64 20 73 63 |ple views and sc|
000019a0 61 6c 65 64 20 76 69 65 77 73 2e 20 43 6f 6c 75 |aled views. Colu|
000019b0 6d 6e 73 20 61 72 65 20 73 70 6c 69 74 20 61 63 |mns are split ac|
000019c0 72 6f 73 73 20 70 61 67 65 73 20 73 6f 20 74 68 |ross pages so th|
000019d0 61 74 20 79 6f 75 20 63 61 6e 20 73 65 65 20 65 |at you can see e|
000019e0 78 61 63 74 6c 79 20 77 68 61 74 20 77 69 6c 6c |xactly what will|
000019f0 20 61 70 70 65 61 72 20 6f 6e 20 65 61 63 68 20 | appear on each |
00001a00 70 61 67 65 2e 20 54 68 65 20 50 61 70 65 72 20 |page. The Paper |
00001a10 64 69 61 6c 6f 67 75 65 20 62 6f 78 20 65 6e 61 |dialogue box ena|
00001a20 62 6c 65 73 20 79 6f 75 20 74 6f 20 6d 61 74 63 |bles you to matc|
00001a30 68 20 79 6f 75 72 20 70 61 70 65 72 20 73 69 7a |h your paper siz|
00001a40 65 20 6f 6e 20 73 63 72 65 65 6e 20 74 6f 20 74 |e on screen to t|
00001a50 68 65 20 70 72 69 6e 74 65 72 20 64 72 69 76 65 |he printer drive|
00001a60 72 20 73 65 74 74 69 6e 67 73 20 77 69 74 68 20 |r settings with |
00001a70 61 20 73 69 6e 67 6c 65 20 63 6c 69 63 6b 2c 20 |a single click, |
00001a80 6f 72 20 79 6f 75 20 63 61 6e 20 73 70 65 63 69 |or you can speci|
00001a90 66 79 20 79 6f 75 72 20 6f 77 6e 20 70 61 70 65 |fy your own pape|
00001aa0 72 20 73 69 7a 65 73 2e 20 59 6f 75 20 63 61 6e |r sizes. You can|
00001ab0 20 77 6f 72 6b 20 69 6e 20 65 69 74 68 65 72 20 | work in either |
00001ac0 70 6f 72 74 72 61 69 74 20 6f 72 20 6c 61 6e 64 |portrait or land|
00001ad0 73 63 61 70 65 20 6f 6e 20 73 63 72 65 65 6e 5c |scape on screen\|
00001ae0 5c 5c 3b 20 6c 61 6e 64 73 63 61 70 65 20 70 72 |\\; landscape pr|
00001af0 6f 62 61 62 6c 79 20 65 6e 61 62 6c 65 73 20 74 |obably enables t|
00001b00 68 61 74 20 6c 61 73 74 20 63 6f 6c 75 6d 6e 20 |hat last column |
00001b10 74 6f 20 66 69 74 21 7d 0a 7b 53 3a 58 3b 58 3b |to fit!}.{S:X;X;|
00001b20 30 3b 32 36 3b 57 65 20 62 65 6c 69 65 76 65 20 |0;26;We believe |
00001b30 74 68 61 74 20 46 69 72 65 77 6f 72 6b 7a 20 28 |that Fireworkz (|
00001b40 61 6e 64 20 52 65 73 75 6c 74 7a 29 20 61 72 65 |and Resultz) are|
00001b50 20 75 6e 69 71 75 65 20 69 6e 20 65 6e 61 62 6c | unique in enabl|
00001b60 69 6e 67 20 79 6f 75 20 74 6f 20 63 68 61 6e 67 |ing you to chang|
00001b70 65 20 63 6f 6c 75 6d 6e 20 77 69 64 74 68 73 20 |e column widths |
00001b80 61 74 20 61 6e 79 20 70 6f 69 6e 74 20 64 6f 77 |at any point dow|
00001b90 6e 20 74 68 65 20 73 70 72 65 61 64 73 68 65 65 |n the spreadshee|
00001ba0 74 2e 20 55 73 75 61 6c 6c 79 20 73 70 72 65 61 |t. Usually sprea|
00001bb0 64 73 68 65 65 74 73 20 63 6f 6e 73 74 72 61 69 |dsheets constrai|
00001bc0 6e 20 79 6f 75 20 74 6f 20 75 73 69 6e 67 20 74 |n you to using t|
00001bd0 68 65 20 73 61 6d 65 20 73 65 74 20 6f 66 20 63 |he same set of c|
00001be0 6f 6c 75 6d 6e 20 77 69 64 74 68 73 20 61 74 20 |olumn widths at |
00001bf0 74 68 65 20 62 6f 74 74 6f 6d 20 6f 66 20 74 68 |the bottom of th|
00001c00 65 20 64 6f 63 75 6d 65 6e 74 20 61 73 20 79 6f |e document as yo|
00001c10 75 20 75 73 65 64 20 61 74 20 74 68 65 20 74 6f |u used at the to|
00001c20 70 2e 20 54 68 65 72 65 20 69 73 20 6e 6f 20 73 |p. There is no s|
00001c30 75 63 68 20 63 6f 6e 73 74 72 61 69 6e 74 20 69 |uch constraint i|
00001c40 6e 20 46 69 72 65 77 6f 72 6b 7a 2e 20 50 6c 65 |n Fireworkz. Ple|
00001c50 6e 74 79 20 6f 66 20 65 78 61 6d 70 6c 65 73 20 |nty of examples |
00001c60 75 73 69 6e 67 20 74 68 69 73 20 61 72 65 20 70 |using this are p|
00001c70 72 6f 76 69 64 65 64 20 69 6e 20 74 68 65 20 73 |rovided in the s|
00001c80 70 72 65 61 64 73 68 65 65 74 73 20 6f 6e 20 74 |preadsheets on t|
00001c90 68 69 73 20 64 69 73 63 2e 7d 0a 7b 53 3a 58 3b |his disc.}.{S:X;|
00001ca0 58 3b 30 3b 32 37 3b 55 73 65 72 20 69 6e 74 65 |X;0;27;User inte|
00001cb0 72 66 61 63 65 2e 20 54 68 65 20 75 73 65 72 20 |rface. The user |
00001cc0 69 6e 74 65 72 66 61 63 65 20 68 61 73 20 62 65 |interface has be|
00001cd0 65 6e 20 64 65 73 69 67 6e 65 64 20 74 6f 20 62 |en designed to b|
00001ce0 65 20 61 73 20 73 69 6d 70 6c 65 20 61 6e 64 20 |e as simple and |
00001cf0 64 69 72 65 63 74 20 61 73 20 70 6f 73 73 69 62 |direct as possib|
00001d00 6c 65 2e 20 54 68 65 20 62 75 74 74 6f 6e 20 62 |le. The button b|
00001d10 61 72 20 61 74 20 74 68 65 20 74 6f 70 20 6f 66 |ar at the top of|
00001d20 20 74 68 65 20 77 69 6e 64 6f 77 20 67 69 76 65 | the window give|
00001d30 73 20 61 63 63 65 73 73 20 74 6f 20 74 68 65 20 |s access to the |
00001d40 6d 6f 73 74 20 66 72 65 71 75 65 6e 74 6c 79 20 |most frequently |
00001d50 75 73 65 64 20 63 6f 6d 6d 61 6e 64 73 2e 20 7d |used commands. }|
00001d60 0a 7b 53 3a 58 3b 58 3b 30 3b 32 38 3b 54 68 65 |.{S:X;X;0;28;The|
00001d70 20 73 74 61 74 75 73 20 6c 69 6e 65 20 70 72 6f | status line pro|
00001d80 76 69 64 65 73 20 69 6e 74 65 72 61 63 74 69 76 |vides interactiv|
00001d90 65 20 68 65 6c 70 20 61 62 6f 75 74 20 46 69 72 |e help about Fir|
00001da0 65 77 6f 72 6b 7a 20 61 6e 64 20 79 6f 75 72 20 |eworkz and your |
00001db0 73 70 72 65 61 64 73 68 65 65 74 73 2e 20 44 65 |spreadsheets. De|
00001dc0 73 63 72 69 70 74 69 6f 6e 73 20 6f 66 20 61 6c |scriptions of al|
00001dd0 6c 20 46 69 72 65 77 6f 72 6b 7a 27 20 66 75 6e |l Fireworkz' fun|
00001de0 63 74 69 6f 6e 73 20 61 6e 64 20 74 68 65 69 72 |ctions and their|
00001df0 20 70 61 72 61 6d 65 74 65 72 73 20 61 72 65 20 | parameters are |
00001e00 70 72 6f 76 69 64 65 64 2e 7d 0a 7b 53 3a 58 3b |provided.}.{S:X;|
00001e10 58 3b 30 3b 32 39 3b 46 6f 72 6d 75 6c 61 20 6c |X;0;29;Formula l|
00001e20 69 6e 65 2e 20 46 75 6e 63 74 69 6f 6e 20 65 6e |ine. Function en|
00001e30 74 72 79 20 69 73 20 6d 75 63 68 20 73 6c 69 63 |try is much slic|
00001e40 6b 65 72 20 74 68 61 6e 20 50 69 70 65 44 72 65 |ker than PipeDre|
00001e50 61 6d 3a 20 69 66 20 79 6f 75 20 65 6e 74 65 72 |am: if you enter|
00001e60 20 74 68 65 20 66 75 6e 63 74 69 6f 6e 20 66 72 | the function fr|
00001e70 6f 6d 20 74 68 65 20 66 75 6e 63 74 69 6f 6e 20 |om the function |
00001e80 73 65 6c 65 63 74 6f 72 20 79 6f 75 20 67 65 74 |selector you get|
00001e90 20 61 75 74 6f 6d 61 74 69 63 20 70 61 72 61 6d | automatic param|
00001ea0 65 74 65 72 20 68 65 6c 70 20 61 6e 64 20 70 61 |eter help and pa|
00001eb0 73 74 69 6e 67 2e 20 57 68 65 6e 20 65 6e 74 65 |sting. When ente|
00001ec0 72 69 6e 67 20 63 65 6c 6c 20 72 65 66 65 72 65 |ring cell refere|
00001ed0 6e 63 65 73 20 61 6e 64 20 72 61 6e 67 65 73 20 |nces and ranges |
00001ee0 69 6e 20 74 68 65 20 66 6f 72 6d 75 6c 61 20 6c |in the formula l|
00001ef0 69 6e 65 2c 20 74 68 65 79 20 61 72 65 20 67 69 |ine, they are gi|
00001f00 76 65 6e 20 61 20 73 6f 66 74 20 73 65 6c 65 63 |ven a soft selec|
00001f10 74 69 6f 6e 20 73 6f 20 74 68 61 74 20 63 6c 69 |tion so that cli|
00001f20 63 6b 69 6e 67 20 73 65 76 65 72 61 6c 20 74 69 |cking several ti|
00001f30 6d 65 73 20 6f 76 65 72 72 69 64 65 73 20 74 68 |mes overrides th|
00001f40 65 20 70 72 65 76 69 6f 75 73 20 72 65 66 65 72 |e previous refer|
00001f50 65 6e 63 65 73 2c 20 62 75 74 20 74 79 70 69 6e |ences, but typin|
00001f60 67 20 77 69 6c 6c 20 69 6e 73 65 72 74 20 61 66 |g will insert af|
00001f70 74 65 72 20 74 68 65 20 72 65 66 65 72 65 6e 63 |ter the referenc|
00001f80 65 73 2e 20 54 72 79 20 69 74 2c 20 69 74 27 73 |es. Try it, it's|
00001f90 20 65 61 73 69 65 72 20 74 6f 20 75 73 65 20 74 | easier to use t|
00001fa0 68 61 6e 20 74 6f 20 64 65 73 63 72 69 62 65 21 |han to describe!|
00001fb0 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 33 30 3b 41 75 |}.{S:X;X;0;30;Au|
00001fc0 74 6f 20 73 75 6d 20 65 6e 61 62 6c 65 73 20 79 |to sum enables y|
00001fd0 6f 75 20 74 6f 20 63 72 65 61 74 65 20 74 6f 74 |ou to create tot|
00001fe0 61 6c 73 20 77 69 74 68 20 6a 75 73 74 20 61 20 |als with just a |
00001ff0 63 6c 69 63 6b 20 6f 6e 20 74 68 65 20 62 75 74 |click on the but|
00002000 74 6f 6e 2e 20 4f 74 68 65 72 20 52 49 53 43 20 |ton. Other RISC |
00002010 4f 53 20 73 70 72 65 61 64 73 68 65 65 74 20 70 |OS spreadsheet p|
00002020 72 6f 67 72 61 6d 73 20 6d 65 72 65 6c 79 20 75 |rograms merely u|
00002030 73 65 20 74 68 65 20 61 75 74 6f 20 73 75 6d 20 |se the auto sum |
00002040 62 75 74 74 6f 6e 20 74 6f 20 69 6e 73 65 72 74 |button to insert|
00002050 20 61 6e 20 65 6d 70 74 79 20 73 75 6d 28 29 20 | an empty sum() |
00002060 6f 6e 20 74 68 65 20 66 6f 72 6d 75 6c 61 20 6c |on the formula l|
00002070 69 6e 65 2e 20 46 69 72 65 77 6f 72 6b 7a 20 77 |ine. Fireworkz w|
00002080 69 6c 6c 20 64 6f 20 74 68 61 74 20 69 66 20 79 |ill do that if y|
00002090 6f 75 20 77 69 73 68 2c 20 62 75 74 20 69 66 20 |ou wish, but if |
000020a0 79 6f 75 20 6d 61 6b 65 20 61 20 73 65 6c 65 63 |you make a selec|
000020b0 74 69 6f 6e 20 6f 66 20 63 65 6c 6c 73 20 77 69 |tion of cells wi|
000020c0 74 68 20 62 6c 61 6e 6b 20 63 65 6c 6c 73 20 69 |th blank cells i|
000020d0 6e 20 74 68 65 20 6c 61 73 74 20 72 6f 77 20 6f |n the last row o|
000020e0 72 20 63 6f 6c 75 6d 6e 2c 20 74 68 65 6e 20 61 |r column, then a|
000020f0 20 63 6c 69 63 6b 20 6f 6e 20 74 68 65 20 61 75 | click on the au|
00002100 74 6f 20 73 75 6d 20 62 75 74 74 6f 6e 20 77 69 |to sum button wi|
00002110 6c 6c 20 63 72 65 61 74 65 20 74 68 65 20 63 6f |ll create the co|
00002120 6d 70 6c 65 74 65 20 73 75 6d 28 29 20 66 6f 72 |mplete sum() for|
00002130 6d 75 6c 61 2c 20 69 6e 63 6c 75 64 69 6e 67 20 |mula, including |
00002140 63 65 6c 6c 20 72 65 66 65 72 65 6e 63 65 73 2c |cell references,|
00002150 20 61 6e 64 20 69 6e 73 65 72 74 20 69 74 20 69 | and insert it i|
00002160 6e 74 6f 20 74 68 65 20 63 65 6c 6c 2e 7d 0a 7b |nto the cell.}.{|
00002170 53 3a 58 3b 58 3b 30 3b 33 31 3b 54 68 65 20 73 |S:X;X;0;31;The s|
00002180 74 79 6c 65 20 65 64 69 74 6f 72 20 65 6e 61 62 |tyle editor enab|
00002190 6c 65 73 20 79 6f 75 20 74 6f 20 6d 61 6b 65 20 |les you to make |
000021a0 73 74 79 6c 65 73 20 77 68 69 63 68 20 63 61 6e |styles which can|
000021b0 20 62 65 20 61 70 70 6c 69 65 64 20 61 74 20 61 | be applied at a|
000021c0 6e 79 20 6c 65 76 65 6c 20 66 72 6f 6d 20 61 20 |ny level from a |
000021d0 73 69 6e 67 6c 65 20 63 68 61 72 61 63 74 65 72 |single character|
000021e0 20 75 70 20 74 6f 20 74 68 65 20 77 68 6f 6c 65 | up to the whole|
000021f0 20 64 6f 63 75 6d 65 6e 74 2e 20 55 6e 6c 69 6b | document. Unlik|
00002200 65 20 69 6e 20 6f 74 68 65 72 20 73 70 72 65 61 |e in other sprea|
00002210 64 73 68 65 65 74 20 70 72 6f 67 72 61 6d 73 2c |dsheet programs,|
00002220 20 74 68 65 79 20 63 61 6e 20 61 6c 73 6f 20 62 | they can also b|
00002230 65 20 6c 61 79 65 72 65 64 2c 20 6a 75 73 74 20 |e layered, just |
00002240 6c 69 6b 65 20 69 6e 20 57 6f 72 64 7a 20 61 6e |like in Wordz an|
00002250 64 20 49 6d 70 72 65 73 73 69 6f 6e 2e 20 53 74 |d Impression. St|
00002260 79 6c 65 73 20 63 61 6e 20 63 6f 6e 74 61 69 6e |yles can contain|
00002270 20 61 20 77 69 64 65 20 72 61 6e 67 65 20 6f 66 | a wide range of|
00002280 20 61 74 74 72 69 62 75 74 65 73 2c 20 66 72 6f | attributes, fro|
00002290 6d 20 66 6f 6e 74 20 73 69 7a 65 73 20 61 6e 64 |m font sizes and|
000022a0 20 63 6f 6c 6f 75 72 73 20 74 6f 20 67 72 69 64 | colours to grid|
000022b0 20 73 74 79 6c 65 73 2c 20 68 6f 72 69 7a 6f 6e | styles, horizon|
000022c0 74 61 6c 20 61 6e 64 20 76 65 72 74 69 63 61 6c |tal and vertical|
000022d0 20 6a 75 73 74 69 66 69 63 61 74 69 6f 6e 2e 20 | justification. |
000022e0 53 74 79 6c 65 73 20 63 61 6e 20 62 65 20 75 73 |Styles can be us|
000022f0 65 64 20 74 6f 20 70 72 65 64 65 66 69 6e 65 20 |ed to predefine |
00002300 61 72 65 61 73 20 6f 66 20 74 68 65 20 73 68 65 |areas of the she|
00002310 65 74 2e 20 59 6f 75 20 63 61 6e 20 73 70 65 63 |et. You can spec|
00002320 69 66 79 20 74 68 61 74 20 63 65 6c 6c 73 20 73 |ify that cells s|
00002330 68 6f 75 6c 64 20 62 65 63 6f 6d 65 20 65 69 74 |hould become eit|
00002340 68 65 72 20 74 65 78 74 20 63 65 6c 6c 73 20 6f |her text cells o|
00002350 72 20 6e 75 6d 62 65 72 20 63 65 6c 6c 73 20 77 |r number cells w|
00002360 68 65 6e 20 79 6f 75 20 74 79 70 65 20 64 61 74 |hen you type dat|
00002370 61 20 69 6e 74 6f 20 74 68 65 6d 2c 20 6f 72 20 |a into them, or |
00002380 74 68 61 74 20 61 20 63 6f 6c 75 6d 6e 20 73 68 |that a column sh|
00002390 6f 75 6c 64 20 62 65 20 6c 65 66 74 2d 61 6c 69 |ould be left-ali|
000023a0 67 6e 65 64 20 6f 72 20 69 6e 20 61 20 64 69 66 |gned or in a dif|
000023b0 66 65 72 65 6e 74 20 66 6f 6e 74 2e 7d 0a 7b 53 |ferent font.}.{S|
000023c0 3a 58 3b 58 3b 30 3b 33 32 3b 53 74 79 6c 65 73 |:X;X;0;32;Styles|
000023d0 20 61 72 65 20 61 20 76 65 72 79 20 69 6d 70 6f | are a very impo|
000023e0 72 74 61 6e 74 20 61 6e 64 20 70 6f 77 65 72 66 |rtant and powerf|
000023f0 75 6c 20 66 65 61 74 75 72 65 20 6f 66 20 46 69 |ul feature of Fi|
00002400 72 65 77 6f 72 6b 7a 2e 20 55 73 69 6e 67 20 74 |reworkz. Using t|
00002410 68 65 6d 20 77 69 6c 6c 20 65 6e 61 62 6c 65 20 |hem will enable |
00002420 79 6f 75 20 74 6f 20 62 75 69 6c 64 20 62 65 74 |you to build bet|
00002430 74 65 72 20 6c 6f 6f 6b 69 6e 67 20 64 6f 63 75 |ter looking docu|
00002440 6d 65 6e 74 73 20 6d 6f 72 65 20 71 75 69 63 6b |ments more quick|
00002450 6c 79 2e 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 33 33 |ly.}.{S:X;X;0;33|
00002460 3b 50 72 6f 74 65 63 74 69 6f 6e 20 69 73 20 70 |;Protection is p|
00002470 72 6f 76 69 64 65 64 20 61 73 20 61 20 73 74 79 |rovided as a sty|
00002480 6c 65 20 61 74 74 72 69 62 75 74 65 2e 20 49 74 |le attribute. It|
00002490 20 69 73 20 70 72 6f 62 61 62 6c 79 20 62 65 73 | is probably bes|
000024a0 74 20 75 73 65 64 20 62 79 20 73 65 74 74 69 6e |t used by settin|
000024b0 67 20 75 70 20 61 20 73 74 79 6c 65 20 63 6f 6e |g up a style con|
000024c0 74 61 69 6e 69 6e 67 20 6a 75 73 74 20 70 72 6f |taining just pro|
000024d0 74 65 63 74 69 6f 6e 20 61 6e 64 20 61 70 70 6c |tection and appl|
000024e0 79 69 6e 67 20 69 74 20 74 6f 20 63 65 6c 6c 73 |ying it to cells|
000024f0 2e 20 59 6f 75 20 6d 61 79 20 77 61 6e 74 20 74 |. You may want t|
00002500 6f 20 61 64 64 20 61 20 62 61 63 6b 67 72 6f 75 |o add a backgrou|
00002510 6e 64 20 63 6f 6c 6f 75 72 20 74 6f 20 74 68 65 |nd colour to the|
00002520 20 73 74 79 6c 65 20 69 6e 20 6f 72 64 65 72 20 | style in order |
00002530 74 6f 20 73 65 65 20 74 68 65 20 70 72 6f 74 65 |to see the prote|
00002540 63 74 65 64 20 61 72 65 61 73 2e 7d 0a 7b 53 3a |cted areas.}.{S:|
00002550 58 3b 58 3b 30 3b 33 34 3b 4e 75 6d 62 65 72 2f |X;X;0;34;Number/|
00002560 64 61 74 65 20 66 6f 72 6d 61 74 73 20 63 61 6e |date formats can|
00002570 20 62 65 20 73 70 65 63 69 66 69 65 64 20 61 73 | be specified as|
00002580 20 70 61 72 74 20 6f 66 20 61 20 73 74 79 6c 65 | part of a style|
00002590 2e 20 59 6f 75 20 63 61 6e 20 70 72 6f 76 69 64 |. You can provid|
000025a0 65 20 73 74 79 6c 65 73 20 73 70 65 63 69 66 79 |e styles specify|
000025b0 69 6e 67 20 64 69 66 66 65 72 65 6e 74 20 6e 75 |ing different nu|
000025c0 6d 62 65 72 73 20 6f 66 20 64 65 63 69 6d 61 6c |mbers of decimal|
000025d0 20 70 6c 61 63 65 73 2c 20 6f 72 20 61 20 70 65 | places, or a pe|
000025e0 72 63 65 6e 74 61 67 65 20 73 74 79 6c 65 2c 20 |rcentage style, |
000025f0 6f 72 20 65 76 65 6e 20 72 6f 6d 61 6e 20 6e 75 |or even roman nu|
00002600 6d 65 72 61 6c 73 2e 7d 0a 7b 53 3a 58 3b 58 3b |merals.}.{S:X;X;|
00002610 30 3b 33 35 3b 47 72 69 64 6c 69 6e 65 73 20 6f |0;35;Gridlines o|
00002620 66 20 64 69 66 66 65 72 65 6e 74 20 74 68 69 63 |f different thic|
00002630 6b 6e 65 73 73 65 73 2c 20 6c 69 6e 65 20 73 74 |knesses, line st|
00002640 79 6c 65 73 20 61 6e 64 20 63 6f 6c 6f 75 72 73 |yles and colours|
00002650 20 63 61 6e 20 62 65 20 64 72 61 77 6e 20 61 72 | can be drawn ar|
00002660 6f 75 6e 64 20 63 65 6c 6c 73 20 75 73 69 6e 67 |ound cells using|
00002670 20 74 68 65 20 42 6f 78 20 63 6f 6d 6d 61 6e 64 | the Box command|
00002680 2e 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 33 36 3b 54 |.}.{S:X;X;0;36;T|
00002690 65 6d 70 6c 61 74 65 73 20 61 72 65 20 66 69 6c |emplates are fil|
000026a0 65 73 20 66 72 6f 6d 20 77 68 69 63 68 20 79 6f |es from which yo|
000026b0 75 20 63 61 6e 20 73 74 61 72 74 20 6e 65 77 20 |u can start new |
000026c0 64 6f 63 75 6d 65 6e 74 73 2e 20 54 68 65 20 53 |documents. The S|
000026d0 61 76 65 20 54 65 6d 70 6c 61 74 65 20 63 6f 6d |ave Template com|
000026e0 6d 61 6e 64 20 77 69 6c 6c 20 70 6c 61 63 65 20 |mand will place |
000026f0 79 6f 75 72 20 64 6f 63 75 6d 65 6e 74 20 69 6e |your document in|
00002700 20 74 68 65 20 74 65 6d 70 6c 61 74 65 73 20 64 | the templates d|
00002710 69 72 65 63 74 6f 72 79 20 28 21 46 69 72 65 77 |irectory (!Firew|
00002720 6f 72 6b 7a 2e 55 73 65 72 2e 54 65 6d 70 6c 61 |orkz.User.Templa|
00002730 74 65 73 29 2e 20 57 68 65 6e 20 79 6f 75 20 63 |tes). When you c|
00002740 6c 69 63 6b 20 6f 6e 20 74 68 65 20 46 69 72 65 |lick on the Fire|
00002750 77 6f 72 6b 7a 20 69 63 6f 6e 20 61 20 6d 65 6e |workz icon a men|
00002760 75 20 6f 66 20 74 65 6d 70 6c 61 74 65 73 20 61 |u of templates a|
00002770 70 70 65 61 72 73 20 66 6f 72 20 79 6f 75 20 74 |ppears for you t|
00002780 6f 20 73 65 6c 65 63 74 2e 20 59 6f 75 20 63 61 |o select. You ca|
00002790 6e 20 61 6c 73 6f 20 75 73 65 20 53 61 76 65 20 |n also use Save |
000027a0 54 65 6d 70 6c 61 74 65 20 74 6f 20 73 61 76 65 |Template to save|
000027b0 20 6f 75 74 20 73 74 79 6c 65 73 20 74 6f 20 63 | out styles to c|
000027c0 6f 70 79 20 69 6e 74 6f 20 6f 74 68 65 72 20 64 |opy into other d|
000027d0 6f 63 75 6d 65 6e 74 73 2e 7d 0a 7b 53 3a 58 3b |ocuments.}.{S:X;|
000027e0 58 3b 30 3b 33 37 3b 57 68 65 6e 20 63 72 65 61 |X;0;37;When crea|
000027f0 74 69 6e 67 20 61 20 63 68 61 72 74 2c 20 69 74 |ting a chart, it|
00002800 20 69 73 20 61 75 74 6f 6d 61 74 69 63 61 6c 6c | is automaticall|
00002810 79 20 70 6c 61 63 65 64 20 69 6e 73 69 64 65 20 |y placed inside |
00002820 79 6f 75 72 20 73 70 72 65 61 64 73 68 65 65 74 |your spreadsheet|
00002830 20 64 6f 63 75 6d 65 6e 74 2e 20 53 6f 20 73 61 | document. So sa|
00002840 76 69 6e 67 20 61 6e 64 20 70 72 69 6e 74 69 6e |ving and printin|
00002850 67 20 74 68 65 20 73 70 72 65 61 64 73 68 65 65 |g the spreadshee|
00002860 74 20 73 61 76 65 73 20 61 6e 64 20 70 72 69 6e |t saves and prin|
00002870 74 73 20 74 68 65 20 63 68 61 72 74 20 74 6f 6f |ts the chart too|
00002880 2c 20 77 69 74 68 20 6e 6f 20 65 78 74 72 61 20 |, with no extra |
00002890 77 6f 72 6b 2e 20 54 68 69 73 20 6d 61 6b 65 73 |work. This makes|
000028a0 20 69 74 20 6d 75 63 68 20 65 61 73 69 65 72 20 | it much easier |
000028b0 74 6f 20 6d 61 6e 61 67 65 20 63 68 61 72 74 73 |to manage charts|
000028c0 20 69 6e 20 46 69 72 65 77 6f 72 6b 7a 20 74 68 | in Fireworkz th|
000028d0 61 6e 20 69 6e 20 61 6e 79 20 6f 74 68 65 72 20 |an in any other |
000028e0 52 49 53 43 20 4f 53 20 73 70 72 65 61 64 73 68 |RISC OS spreadsh|
000028f0 65 65 74 20 70 72 6f 67 72 61 6d 2e 20 45 78 61 |eet program. Exa|
00002900 6d 70 6c 65 73 20 6f 66 20 63 68 61 72 74 73 20 |mples of charts |
00002910 61 72 65 20 70 72 6f 76 69 64 65 64 20 69 6e 20 |are provided in |
00002920 74 68 65 20 63 68 61 72 74 73 20 64 69 72 65 63 |the charts direc|
00002930 74 6f 72 79 2e 7d 0a 7b 53 3a 58 3b 58 3b 30 3b |tory.}.{S:X;X;0;|
00002940 33 38 3b 4e 65 77 20 66 75 6e 63 74 69 6f 6e 73 |38;New functions|
00002950 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 33 39 3b 61 67 |}.{S:X;X;0;39;ag|
00002960 65 20 73 75 62 74 72 61 63 74 73 20 6f 6e 65 20 |e subtracts one |
00002970 64 61 74 65 20 66 72 6f 6d 20 61 6e 6f 74 68 65 |date from anothe|
00002980 72 20 61 6e 64 20 72 65 74 75 72 6e 73 20 74 68 |r and returns th|
00002990 65 20 72 65 73 75 6c 74 20 61 73 20 61 20 64 61 |e result as a da|
000029a0 74 65 2e 20 54 68 69 73 20 69 73 20 75 73 65 66 |te. This is usef|
000029b0 75 6c 20 66 6f 72 20 63 61 6c 63 75 6c 61 74 69 |ul for calculati|
000029c0 6e 67 20 73 6f 6d 65 6f 6e 65 27 73 20 61 67 65 |ng someone's age|
000029d0 20 69 6e 20 74 65 72 6d 73 20 6f 66 20 79 65 61 | in terms of yea|
000029e0 72 73 20 61 6e 64 20 6d 6f 6e 74 68 73 2e 7d 0a |rs and months.}.|
000029f0 7b 53 3a 58 3b 58 3b 30 3b 34 30 3b 62 69 6e 20 |{S:X;X;0;40;bin |
00002a00 63 6f 75 6e 74 73 20 74 68 65 20 66 72 65 71 75 |counts the frequ|
00002a10 65 6e 63 69 65 73 20 6f 66 20 63 6c 61 73 73 65 |encies of classe|
00002a20 73 20 6f 66 20 64 61 74 61 2e 20 54 68 65 20 6f |s of data. The o|
00002a30 75 74 70 75 74 20 63 61 6e 20 62 65 20 75 73 65 |utput can be use|
00002a40 64 20 61 73 20 74 68 65 20 69 6e 70 75 74 20 74 |d as the input t|
00002a50 6f 20 61 20 68 69 73 74 6f 67 72 61 6d 20 61 6e |o a histogram an|
00002a60 64 20 61 6e 20 65 78 61 6d 70 6c 65 20 6f 66 20 |d an example of |
00002a70 74 68 69 73 20 69 73 20 67 69 76 65 6e 20 69 6e |this is given in|
00002a80 20 74 68 65 20 43 68 61 72 74 73 20 64 69 72 65 | the Charts dire|
00002a90 63 74 6f 72 79 20 6f 66 20 74 68 65 20 65 78 61 |ctory of the exa|
00002aa0 6d 70 6c 65 73 20 64 69 73 63 2e 7d 0a 7b 53 3a |mples disc.}.{S:|
00002ab0 58 3b 58 3b 30 3b 34 31 3b 63 6f 75 6e 74 61 20 |X;X;0;41;counta |
00002ac0 63 6f 75 6e 74 73 20 74 68 65 20 6e 75 6d 62 65 |counts the numbe|
00002ad0 72 20 6f 66 20 65 6c 65 6d 65 6e 74 73 20 69 6e |r of elements in|
00002ae0 20 61 6e 20 61 72 72 61 79 20 6f 72 20 72 61 6e | an array or ran|
00002af0 67 65 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 34 32 3b |ge}.{S:X;X;0;42;|
00002b00 64 61 79 6e 61 6d 65 20 72 65 74 75 72 6e 73 20 |dayname returns |
00002b10 61 20 73 74 72 69 6e 67 20 6f 66 20 74 68 65 20 |a string of the |
00002b20 64 61 79 6e 61 6d 65 2c 20 74 68 65 20 64 61 79 |dayname, the day|
00002b30 20 62 65 69 6e 67 20 67 69 76 65 6e 20 61 73 20 | being given as |
00002b40 61 20 6e 75 6d 62 65 72 2e 20 65 67 20 64 61 79 |a number. eg day|
00002b50 6e 61 6d 65 28 77 65 65 6b 64 61 79 28 74 6f 64 |name(weekday(tod|
00002b60 61 79 29 29 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 34 |ay))}.{S:X;X;0;4|
00002b70 33 3b 66 6c 69 70 20 74 75 72 6e 73 20 61 6e 20 |3;flip turns an |
00002b80 61 72 72 61 79 20 75 70 73 69 64 65 20 64 6f 77 |array upside dow|
00002b90 6e 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 34 34 3b 66 |n}.{S:X;X;0;44;f|
00002ba0 6f 72 6d 75 6c 61 5f 74 65 78 74 20 72 65 74 75 |ormula_text retu|
00002bb0 72 6e 73 20 61 73 20 61 20 73 74 72 69 6e 67 20 |rns as a string |
00002bc0 74 68 65 20 66 6f 72 6d 75 6c 61 20 69 6e 20 61 |the formula in a|
00002bd0 6e 6f 74 68 65 72 20 63 65 6c 6c 2e 20 54 68 69 |nother cell. Thi|
00002be0 73 20 63 61 6e 20 62 65 20 75 73 65 64 20 74 6f |s can be used to|
00002bf0 20 61 6e 6e 6f 74 61 74 65 20 73 70 72 65 61 64 | annotate spread|
00002c00 73 68 65 65 74 73 2c 20 74 6f 20 73 68 6f 77 20 |sheets, to show |
00002c10 77 68 61 74 20 66 6f 72 6d 75 6c 61 73 20 77 65 |what formulas we|
00002c20 72 65 20 75 73 65 64 20 74 6f 20 70 72 6f 64 75 |re used to produ|
00002c30 63 65 20 74 68 65 20 72 65 73 75 6c 74 73 2e 20 |ce the results. |
00002c40 49 74 20 69 73 20 61 20 77 61 79 20 6f 66 20 70 |It is a way of p|
00002c50 72 69 6e 74 69 6e 67 20 62 6f 74 68 20 74 68 65 |rinting both the|
00002c60 20 72 65 73 75 6c 74 73 20 61 6e 64 20 74 68 65 | results and the|
00002c70 20 66 6f 72 6d 75 6c 61 20 61 74 20 74 68 65 20 | formula at the |
00002c80 73 61 6d 65 20 74 69 6d 65 2e 7d 0a 7b 53 3a 58 |same time.}.{S:X|
00002c90 3b 58 3b 30 3b 34 35 3b 6c 69 73 74 63 6f 75 6e |;X;0;45;listcoun|
00002ca0 74 20 74 61 6b 65 73 20 61 6e 20 61 72 72 61 79 |t takes an array|
00002cb0 20 6f 72 20 72 61 6e 67 65 20 6f 66 20 64 61 74 | or range of dat|
00002cc0 61 20 61 6e 64 20 70 72 6f 64 75 63 65 73 20 61 |a and produces a|
00002cd0 20 6c 69 73 74 20 6f 66 20 61 6c 6c 20 74 68 65 | list of all the|
00002ce0 20 75 6e 69 71 75 65 20 65 6c 65 6d 65 6e 74 73 | unique elements|
00002cf0 20 70 6c 75 73 20 74 68 65 69 72 20 66 72 65 71 | plus their freq|
00002d00 75 65 6e 63 69 65 73 2e 20 41 6e 20 65 78 74 65 |uencies. An exte|
00002d10 6e 73 69 6f 6e 20 74 61 6b 65 73 20 76 61 6c 75 |nsion takes valu|
00002d20 65 73 20 66 6f 72 20 65 61 63 68 20 65 6c 65 6d |es for each elem|
00002d30 65 6e 74 20 61 6e 64 20 61 64 64 73 20 74 68 65 |ent and adds the|
00002d40 20 76 61 6c 75 65 73 20 74 6f 67 65 74 68 65 72 | values together|
00002d50 2e 20 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 34 36 3b |. }.{S:X;X;0;46;|
00002d60 6d 65 64 69 61 6e 20 72 65 74 75 72 6e 73 20 74 |median returns t|
00002d70 68 65 20 6d 65 64 69 61 6e 20 76 61 6c 75 65 20 |he median value |
00002d80 6f 66 20 61 20 72 61 6e 67 65 20 6f 72 20 61 72 |of a range or ar|
00002d90 72 61 79 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 34 37 |ray}.{S:X;X;0;47|
00002da0 3b 6d 6f 6e 74 68 6e 61 6d 65 3a 20 61 73 20 64 |;monthname: as d|
00002db0 61 79 6e 61 6d 65 2e 20 65 67 20 6d 6f 6e 74 68 |ayname. eg month|
00002dc0 6e 61 6d 65 28 6d 6f 6e 74 68 28 74 6f 64 61 79 |name(month(today|
00002dd0 29 29 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 34 38 3b |))}.{S:X;X;0;48;|
00002de0 70 61 67 65 20 72 65 74 75 72 6e 73 20 74 68 65 |page returns the|
00002df0 20 70 61 67 65 20 6e 75 6d 62 65 72 20 28 78 20 | page number (x |
00002e00 6f 72 20 79 29 20 6f 66 20 61 20 63 65 6c 6c 7d |or y) of a cell}|
00002e10 0a 7b 53 3a 58 3b 58 3b 30 3b 34 39 3b 70 61 67 |.{S:X;X;0;49;pag|
00002e20 65 73 20 72 65 74 75 72 6e 73 20 74 68 65 20 6e |es returns the n|
00002e30 75 6d 62 65 72 20 6f 66 20 70 61 67 65 73 20 28 |umber of pages (|
00002e40 78 20 6f 72 20 79 29 20 69 6e 20 74 68 65 20 64 |x or y) in the d|
00002e50 6f 63 75 6d 65 6e 74 7d 0a 7b 53 3a 58 3b 58 3b |ocument}.{S:X;X;|
00002e60 30 3b 35 30 3b 72 61 6e 6b 20 72 65 74 75 72 6e |0;50;rank return|
00002e70 73 20 61 6e 20 61 72 72 61 79 20 6f 66 20 72 61 |s an array of ra|
00002e80 6e 6b 69 6e 67 73 20 66 72 6f 6d 20 61 6e 20 69 |nkings from an i|
00002e90 6e 70 75 74 20 61 72 72 61 79 7d 0a 7b 53 3a 58 |nput array}.{S:X|
00002ea0 3b 58 3b 30 3b 35 31 3b 73 6f 72 74 20 73 6f 72 |;X;0;51;sort sor|
00002eb0 74 73 20 61 6e 20 61 72 72 61 79 20 6f 6e 20 61 |ts an array on a|
00002ec0 20 67 69 76 65 6e 20 63 6f 6c 75 6d 6e 7d 0a 7b | given column}.{|
00002ed0 53 3a 58 3b 58 3b 30 3b 35 32 3b 73 70 65 61 72 |S:X;X;0;52;spear|
00002ee0 6d 61 6e 20 63 61 6c 63 75 6c 61 74 65 73 20 74 |man calculates t|
00002ef0 68 65 20 53 70 65 61 72 6d 61 6e 20 63 6f 72 72 |he Spearman corr|
00002f00 65 6c 61 74 69 6f 6e 20 63 6f 2d 65 66 66 69 63 |elation co-effic|
00002f10 69 65 6e 74 20 66 72 6f 6d 20 74 77 6f 20 72 61 |ient from two ra|
00002f20 6e 6b 65 64 20 61 72 72 61 79 73 2e 20 54 68 65 |nked arrays. The|
00002f30 20 61 72 72 61 79 73 20 63 61 6e 20 62 65 20 72 | arrays can be r|
00002f40 61 6e 6b 65 64 20 75 73 69 6e 67 20 74 68 65 20 |anked using the |
00002f50 72 61 6e 6b 20 66 75 6e 63 74 69 6f 6e 2e 7d 0a |rank function.}.|
00002f60 7b 53 3a 58 3b 58 3b 30 3b 35 33 3b 74 65 78 74 |{S:X;X;0;53;text|
00002f70 20 74 61 6b 65 73 20 61 20 6e 75 6d 62 65 72 20 | takes a number |
00002f80 61 6e 64 20 61 20 6e 75 6d 62 65 72 20 66 6f 72 |and a number for|
00002f90 6d 61 74 20 28 69 64 65 6e 74 69 63 61 6c 20 74 |mat (identical t|
00002fa0 6f 20 74 68 6f 73 65 20 69 6e 20 73 74 79 6c 65 |o those in style|
00002fb0 20 65 64 69 74 6f 72 29 20 61 6e 64 20 72 65 74 | editor) and ret|
00002fc0 75 72 6e 73 20 61 20 73 74 72 69 6e 67 20 6f 66 |urns a string of|
00002fd0 20 74 68 65 20 66 6f 72 6d 61 74 74 65 64 20 6e | the formatted n|
00002fe0 75 6d 62 65 72 7d 0a 7b 53 3a 58 3b 58 3b 30 3b |umber}.{S:X;X;0;|
00002ff0 35 34 3b 46 75 6e 63 74 69 6f 6e 20 65 6e 68 61 |54;Function enha|
00003000 6e 63 65 6d 65 6e 74 73 7d 0a 7b 53 3a 58 3b 58 |ncements}.{S:X;X|
00003010 3b 30 3b 35 35 3b 6c 6f 6f 6b 75 70 20 68 61 73 |;0;55;lookup has|
00003020 20 62 65 65 6e 20 65 78 74 65 6e 64 65 64 2e 20 | been extended. |
00003030 41 6e 20 6f 70 74 69 6f 6e 61 6c 20 66 6f 75 72 |An optional four|
00003040 74 68 20 70 61 72 61 6d 65 74 65 72 20 73 65 74 |th parameter set|
00003050 20 74 6f 20 31 20 70 72 6f 76 69 64 65 73 20 74 | to 1 provides t|
00003060 77 6f 20 65 78 74 72 61 20 74 79 70 65 73 20 6f |wo extra types o|
00003070 66 20 69 6e 66 6f 72 6d 61 74 69 6f 6e 20 74 6f |f information to|
00003080 20 62 65 20 72 65 74 75 72 6e 65 64 3a 20 28 69 | be returned: (i|
00003090 29 20 61 6c 6c 20 6f 63 63 75 72 72 65 6e 63 65 |) all occurrence|
000030a0 73 20 77 68 69 63 68 20 6d 61 74 63 68 20 74 68 |s which match th|
000030b0 65 20 6b 65 79 20 61 72 65 20 72 65 74 75 72 6e |e key are return|
000030c0 65 64 2c 20 72 61 74 68 65 72 20 74 68 61 6e 20 |ed, rather than |
000030d0 73 69 6d 70 6c 79 20 74 68 65 20 66 69 72 73 74 |simply the first|
000030e0 2c 20 28 69 69 29 20 66 6f 72 20 65 61 63 68 20 |, (ii) for each |
000030f0 6d 61 74 63 68 20 61 20 77 68 6f 6c 65 20 72 65 |match a whole re|
00003100 63 6f 72 64 20 63 61 6e 20 62 65 20 72 65 74 75 |cord can be retu|
00003110 72 6e 65 64 2c 20 72 61 74 68 65 72 20 74 68 61 |rned, rather tha|
00003120 6e 20 6a 75 73 74 20 61 20 73 69 6d 70 6c 65 20 |n just a simple |
00003130 76 61 6c 75 65 2e 7d 0a 7b 53 3a 58 3b 58 3b 30 |value.}.{S:X;X;0|
00003140 3b 35 36 3b 73 65 74 5f 76 61 6c 75 65 20 68 61 |;56;set_value ha|
00003150 73 20 62 65 65 6e 20 65 78 74 65 6e 64 65 64 2e |s been extended.|
00003160 20 4f 70 74 69 6f 6e 61 6c 20 74 68 69 72 64 20 | Optional third |
00003170 61 6e 64 20 66 6f 75 72 74 68 20 70 61 72 61 6d |and fourth param|
00003180 65 74 65 72 73 20 73 70 65 63 69 66 79 20 61 6e |eters specify an|
00003190 20 6f 66 66 73 65 74 20 69 6e 20 61 6e 20 61 72 | offset in an ar|
000031a0 72 61 79 2e 20 54 68 69 73 20 65 6e 61 62 6c 65 |ray. This enable|
000031b0 73 20 79 6f 75 20 74 6f 20 77 72 69 74 65 20 74 |s you to write t|
000031c0 6f 20 61 20 73 69 6e 67 6c 65 20 65 6c 65 6d 65 |o a single eleme|
000031d0 6e 74 20 69 6e 20 61 6e 20 61 72 72 61 79 2e 7d |nt in an array.}|
000031e0 0a 7b 53 3a 58 3b 58 3b 30 3b 35 37 3b 41 66 74 |.{S:X;X;0;57;Aft|
000031f0 65 72 20 79 6f 75 27 76 65 20 6c 6f 61 64 65 64 |er you've loaded|
00003200 20 74 68 65 20 66 69 6c 65 7d 0a 7b 53 3a 58 3b | the file}.{S:X;|
00003210 58 3b 30 3b 35 38 3b 57 68 65 6e 20 74 68 65 20 |X;0;58;When the |
00003220 50 69 70 65 44 72 65 61 6d 20 66 69 6c 65 20 68 |PipeDream file h|
00003230 61 73 20 62 65 65 6e 20 6c 6f 61 64 65 64 2c 20 |as been loaded, |
00003240 69 74 20 77 69 6c 6c 20 70 72 6f 62 61 62 6c 79 |it will probably|
00003250 20 6c 6f 6f 6b 20 71 75 69 74 65 20 64 69 66 66 | look quite diff|
00003260 65 72 65 6e 74 20 74 6f 20 68 6f 77 20 69 74 20 |erent to how it |
00003270 6c 6f 6f 6b 65 64 20 69 6e 20 50 69 70 65 44 72 |looked in PipeDr|
00003280 65 61 6d 2e 20 54 68 65 20 72 6f 77 73 20 6d 61 |eam. The rows ma|
00003290 79 20 6c 6f 6f 6b 20 71 75 69 74 65 20 64 65 65 |y look quite dee|
000032a0 70 20 61 6e 64 20 68 65 61 64 69 6e 67 73 20 61 |p and headings a|
000032b0 6e 64 20 74 65 78 74 20 6d 61 79 20 68 61 76 65 |nd text may have|
000032c0 20 22 77 72 61 70 70 65 64 22 20 74 6f 20 74 61 | "wrapped" to ta|
000032d0 6b 65 20 75 70 20 73 65 76 65 72 61 6c 20 6c 69 |ke up several li|
000032e0 6e 65 73 20 77 69 74 68 69 6e 20 65 61 63 68 20 |nes within each |
000032f0 63 65 6c 6c 2e 7d 0a 7b 53 3a 58 3b 58 3b 30 3b |cell.}.{S:X;X;0;|
00003300 35 39 3b 43 6f 6c 75 6d 6e 20 77 69 64 74 68 73 |59;Column widths|
00003310 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 36 30 3b 4d 6f |}.{S:X;X;0;60;Mo|
00003320 73 74 20 6f 66 20 74 68 65 20 70 72 6f 62 6c 65 |st of the proble|
00003330 6d 20 69 73 20 73 6f 6c 76 65 64 20 62 79 20 63 |m is solved by c|
00003340 68 61 6e 67 69 6e 67 20 74 68 65 20 63 6f 6c 75 |hanging the colu|
00003350 6d 6e 20 77 69 64 74 68 73 20 74 6f 20 6d 61 74 |mn widths to mat|
00003360 63 68 20 74 68 65 20 64 61 74 61 20 62 65 74 74 |ch the data bett|
00003370 65 72 2e 20 59 6f 75 20 63 61 6e 20 74 72 79 20 |er. You can try |
00003380 64 6f 75 62 6c 65 2d 63 6c 69 63 6b 69 6e 67 20 |double-clicking |
00003390 77 69 74 68 20 74 68 65 20 53 65 6c 65 63 74 20 |with the Select |
000033a0 62 75 74 74 6f 6e 20 6f 6e 20 74 68 65 20 63 6f |button on the co|
000033b0 6c 75 6d 6e 20 62 6f 72 64 65 72 73 2e 20 49 66 |lumn borders. If|
000033c0 20 74 68 65 20 64 61 74 61 20 69 6e 20 74 68 65 | the data in the|
000033d0 20 63 6f 6c 75 6d 6e 73 20 69 73 20 71 75 69 74 | columns is quit|
000033e0 65 20 73 68 6f 72 74 2c 20 46 69 72 65 77 6f 72 |e short, Firewor|
000033f0 6b 7a 20 77 69 6c 6c 20 61 75 74 6f 2d 77 69 64 |kz will auto-wid|
00003400 74 68 20 74 68 65 20 63 6f 6c 75 6d 6e 73 20 61 |th the columns a|
00003410 6e 64 20 73 6f 20 6d 61 6b 65 20 74 68 65 20 63 |nd so make the c|
00003420 6f 6c 75 6d 6e 73 20 74 68 65 20 77 69 64 74 68 |olumns the width|
00003430 73 20 6f 66 20 74 68 65 20 6c 6f 6e 67 65 73 74 |s of the longest|
00003440 20 63 65 6c 6c 2e 20 49 66 20 74 68 65 72 65 20 | cell. If there |
00003450 61 72 65 20 63 65 6c 6c 2d 65 6e 74 72 69 65 73 |are cell-entries|
00003460 20 77 68 69 63 68 20 61 72 65 20 76 65 72 79 20 | which are very |
00003470 6c 6f 6e 67 2c 20 46 69 72 65 77 6f 72 6b 7a 20 |long, Fireworkz |
00003480 77 69 6c 6c 20 6e 6f 74 20 61 70 70 6c 79 20 74 |will not apply t|
00003490 68 65 20 61 75 74 6f 2d 77 69 64 74 68 2e 7d 0a |he auto-width.}.|
000034a0 7b 53 3a 58 3b 58 3b 30 3b 36 31 3b 54 68 65 20 |{S:X;X;0;61;The |
000034b0 48 65 61 64 69 6e 67 7d 0a 7b 53 3a 58 3b 58 3b |Heading}.{S:X;X;|
000034c0 30 3b 36 32 3b 41 20 70 61 72 74 69 63 75 6c 61 |0;62;A particula|
000034d0 72 20 70 72 6f 62 6c 65 6d 20 6d 61 79 20 62 65 |r problem may be|
000034e0 20 74 68 65 20 68 65 61 64 69 6e 67 20 61 74 20 | the heading at |
000034f0 74 68 65 20 74 6f 70 20 6f 66 20 74 68 65 20 64 |the top of the d|
00003500 6f 63 75 6d 65 6e 74 2e 20 50 69 70 65 44 72 65 |ocument. PipeDre|
00003510 61 6d 20 75 73 65 73 20 6f 76 65 72 6c 61 70 20 |am uses overlap |
00003520 74 6f 20 64 69 73 70 6c 61 79 20 68 65 61 64 69 |to display headi|
00003530 6e 67 73 2e 20 46 69 72 65 77 6f 72 6b 7a 20 64 |ngs. Fireworkz d|
00003540 6f 65 73 6e 27 74 20 68 61 76 65 20 6f 76 65 72 |oesn't have over|
00003550 6c 61 70 3a 20 69 6e 73 74 65 61 64 2c 20 69 74 |lap: instead, it|
00003560 20 65 6e 61 62 6c 65 73 20 79 6f 75 20 74 6f 20 | enables you to |
00003570 63 68 61 6e 67 65 20 74 68 65 20 77 69 64 74 68 |change the width|
00003580 73 20 6f 66 20 61 6e 79 20 63 65 6c 6c 73 20 61 |s of any cells a|
00003590 74 20 61 6e 79 20 70 6f 69 6e 74 2e 20 49 6e 20 |t any point. In |
000035a0 74 68 65 20 63 61 73 65 20 6f 66 20 61 20 68 65 |the case of a he|
000035b0 61 64 69 6e 67 2c 20 79 6f 75 20 70 72 6f 62 61 |ading, you proba|
000035c0 62 6c 79 20 68 61 76 65 20 61 20 73 69 6e 67 6c |bly have a singl|
000035d0 65 20 63 65 6c 6c 20 77 68 69 63 68 20 79 6f 75 |e cell which you|
000035e0 20 77 61 6e 74 20 74 6f 20 65 78 70 61 6e 64 20 | want to expand |
000035f0 6f 76 65 72 20 74 68 65 20 77 68 6f 6c 65 20 70 |over the whole p|
00003600 61 67 65 20 77 69 64 74 68 2e 20 7d 0a 7b 53 3a |age width. }.{S:|
00003610 58 3b 58 3b 30 3b 36 33 3b 54 68 65 20 62 65 73 |X;X;0;63;The bes|
00003620 74 20 77 61 79 20 74 6f 20 74 61 63 6b 6c 65 20 |t way to tackle |
00003630 74 68 69 73 20 69 73 20 74 6f 20 75 73 65 20 46 |this is to use F|
00003640 69 72 65 77 6f 72 6b 7a 27 20 73 74 72 61 64 64 |ireworkz' stradd|
00003650 6c 69 6e 67 20 63 6f 6d 6d 61 6e 64 2e 20 53 65 |ling command. Se|
00003660 6c 65 63 74 20 74 68 65 20 63 65 6c 6c 20 63 6f |lect the cell co|
00003670 6e 74 61 69 6e 69 6e 67 20 74 68 65 20 68 65 61 |ntaining the hea|
00003680 64 69 6e 67 2c 20 61 6e 64 20 74 68 65 20 63 65 |ding, and the ce|
00003690 6c 6c 73 20 74 6f 20 74 68 65 20 72 69 67 68 74 |lls to the right|
000036a0 20 6f 66 20 69 74 20 77 68 69 63 68 20 79 6f 75 | of it which you|
000036b0 20 77 61 6e 74 20 74 68 65 20 68 65 61 64 69 6e | want the headin|
000036c0 67 20 74 6f 20 73 74 72 61 64 64 6c 65 2e 20 50 |g to straddle. P|
000036d0 6f 69 6e 74 20 61 74 20 74 68 65 20 63 6f 6c 75 |oint at the colu|
000036e0 6d 6e 20 62 6f 72 64 65 72 20 62 65 74 77 65 65 |mn border betwee|
000036f0 6e 20 74 68 65 20 63 6f 6c 75 6d 6e 20 6c 65 74 |n the column let|
00003700 74 65 72 73 2e 20 57 68 65 6e 20 74 68 65 20 70 |ters. When the p|
00003710 6f 69 6e 74 65 72 20 63 68 61 6e 67 65 73 20 73 |ointer changes s|
00003720 68 61 70 65 20 74 6f 20 62 65 63 6f 6d 65 20 74 |hape to become t|
00003730 77 6f 20 76 65 72 74 69 63 61 6c 20 6c 69 6e 65 |wo vertical line|
00003740 73 20 77 69 74 68 20 61 72 72 6f 77 73 20 70 6f |s with arrows po|
00003750 69 6e 74 69 6e 67 20 6c 65 66 74 20 61 6e 64 20 |inting left and |
00003760 72 69 67 68 74 2c 20 64 6f 75 62 6c 65 2d 63 6c |right, double-cl|
00003770 69 63 6b 20 77 69 74 68 20 74 68 65 20 41 64 6a |ick with the Adj|
00003780 75 73 74 20 62 75 74 74 6f 6e 20 6f 6e 20 74 68 |ust button on th|
00003790 65 20 6d 6f 75 73 65 2e 20 54 68 65 20 6c 65 66 |e mouse. The lef|
000037a0 74 6d 6f 73 74 20 63 65 6c 6c 20 77 69 6c 6c 20 |tmost cell will |
000037b0 65 78 70 61 6e 64 20 74 6f 20 74 68 65 20 72 69 |expand to the ri|
000037c0 67 68 74 20 6f 76 65 72 20 74 68 65 20 6f 74 68 |ght over the oth|
000037d0 65 72 20 63 65 6c 6c 73 20 61 6e 64 20 74 68 65 |er cells and the|
000037e0 73 65 20 6f 74 68 65 72 20 63 65 6c 6c 73 20 77 |se other cells w|
000037f0 69 6c 6c 20 62 65 20 73 68 72 75 6e 6b 20 64 6f |ill be shrunk do|
00003800 77 6e 20 74 6f 20 6e 6f 74 68 69 6e 67 2e 7d 0a |wn to nothing.}.|
00003810 7b 53 3a 58 3b 58 3b 30 3b 36 34 3b 4c 61 6e 64 |{S:X;X;0;64;Land|
00003820 73 63 61 70 65 7d 0a 7b 53 3a 58 3b 58 3b 30 3b |scape}.{S:X;X;0;|
00003830 36 35 3b 59 6f 75 20 77 69 6c 6c 20 6e 6f 74 69 |65;You will noti|
00003840 63 65 20 74 68 61 74 20 61 66 74 65 72 20 61 20 |ce that after a |
00003850 66 65 77 20 63 6f 6c 75 6d 6e 73 2c 20 79 6f 75 |few columns, you|
00003860 20 67 65 74 20 61 20 70 61 67 65 2d 62 72 65 61 | get a page-brea|
00003870 6b 20 61 6e 64 20 74 68 65 20 6e 65 77 20 63 6f |k and the new co|
00003880 6c 75 6d 6e 73 20 61 70 70 65 61 72 20 6f 6e 20 |lumns appear on |
00003890 61 20 6e 65 77 20 70 61 67 65 20 74 6f 20 74 68 |a new page to th|
000038a0 65 20 72 69 67 68 74 2e 20 49 66 20 79 6f 75 20 |e right. If you |
000038b0 64 65 63 69 64 65 20 79 6f 75 20 77 6f 75 6c 64 |decide you would|
000038c0 20 6c 69 6b 65 20 6d 6f 72 65 20 63 6f 6c 75 6d | like more colum|
000038d0 6e 73 20 74 6f 20 74 68 65 20 70 61 67 65 20 79 |ns to the page y|
000038e0 6f 75 20 63 61 6e 20 65 69 74 68 65 72 20 73 68 |ou can either sh|
000038f0 72 69 6e 6b 20 74 68 65 20 63 6f 6c 75 6d 6e 20 |rink the column |
00003900 77 69 64 74 68 73 20 74 6f 20 66 69 74 2c 20 6f |widths to fit, o|
00003910 72 20 79 6f 75 20 63 61 6e 20 75 73 65 20 74 68 |r you can use th|
00003920 65 20 50 61 70 65 72 20 64 69 61 6c 6f 67 75 65 |e Paper dialogue|
00003930 20 62 6f 78 20 74 6f 20 73 65 74 20 74 68 65 20 | box to set the |
00003940 70 61 70 65 72 20 6f 72 69 65 6e 74 61 74 69 6f |paper orientatio|
00003950 6e 20 74 6f 20 6c 61 6e 64 73 63 61 70 65 2e 20 |n to landscape. |
00003960 54 68 69 73 20 67 69 76 65 73 20 79 6f 75 20 61 |This gives you a|
00003970 20 77 69 64 65 72 20 70 61 67 65 20 28 6d 6f 72 | wider page (mor|
00003980 65 20 63 6f 6c 75 6d 6e 73 29 20 77 68 69 63 68 |e columns) which|
00003990 20 69 73 20 6c 65 73 73 20 64 65 65 70 20 28 66 | is less deep (f|
000039a0 65 77 65 72 20 72 6f 77 73 29 2e 20 57 68 69 6c |ewer rows). Whil|
000039b0 73 74 20 69 6e 20 74 68 65 20 50 61 70 65 72 20 |st in the Paper |
000039c0 64 69 61 6c 6f 67 75 65 20 62 6f 78 2c 20 63 6c |dialogue box, cl|
000039d0 69 63 6b 20 6f 6e 20 74 68 65 20 52 65 61 64 20 |ick on the Read |
000039e0 70 72 69 6e 74 65 72 20 62 75 74 74 6f 6e 2e 7d |printer button.}|
000039f0 0a 7b 53 3a 58 3b 58 3b 30 3b 36 36 3b 49 66 20 |.{S:X;X;0;66;If |
00003a00 79 6f 75 27 72 65 20 6e 6f 74 20 67 6f 69 6e 67 |you're not going|
00003a10 20 74 6f 20 70 72 69 6e 74 20 6f 75 74 20 74 68 | to print out th|
00003a20 65 20 73 70 72 65 61 64 73 68 65 65 74 2c 20 79 |e spreadsheet, y|
00003a30 6f 75 20 63 61 6e 20 63 68 6f 6f 73 65 20 74 68 |ou can choose th|
00003a40 65 20 4e 6f 6e 65 20 62 75 74 74 6f 6e 20 69 6e |e None button in|
00003a50 20 74 68 65 20 70 61 70 65 72 20 64 69 61 6c 6f | the paper dialo|
00003a60 67 20 62 6f 78 20 77 68 69 63 68 20 77 69 6c 6c |g box which will|
00003a70 20 67 69 76 65 20 79 6f 75 20 69 6e 66 69 6e 69 | give you infini|
00003a80 74 65 20 70 61 70 65 72 2e 7d 0a 7b 53 3a 58 3b |te paper.}.{S:X;|
00003a90 58 3b 30 3b 36 37 3b 46 6f 72 6d 75 6c 61 73 7d |X;0;67;Formulas}|
00003aa0 0a 7b 53 3a 58 3b 58 3b 30 3b 36 38 3b 41 6c 6d |.{S:X;X;0;68;Alm|
00003ab0 6f 73 74 20 77 69 74 68 6f 75 74 20 65 78 63 65 |ost without exce|
00003ac0 70 74 69 6f 6e 2c 20 46 69 72 65 77 6f 72 6b 7a |ption, Fireworkz|
00003ad0 20 77 69 6c 6c 20 75 6e 64 65 72 73 74 61 6e 64 | will understand|
00003ae0 20 61 6e 64 20 65 76 61 6c 75 61 74 65 20 50 69 | and evaluate Pi|
00003af0 70 65 44 72 65 61 6d 20 66 6f 72 6d 75 6c 61 73 |peDream formulas|
00003b00 20 69 64 65 6e 74 69 63 61 6c 6c 79 20 74 6f 20 | identically to |
00003b10 50 69 70 65 44 72 65 61 6d 2e 20 54 68 65 20 64 |PipeDream. The d|
00003b20 69 66 66 65 72 65 6e 63 65 73 20 61 72 65 3a 7d |ifferences are:}|
00003b30 0a 7b 53 3a 58 3b 58 3b 30 3b 36 39 3b 68 6c 6f |.{S:X;X;0;69;hlo|
00003b40 6f 6b 75 70 2c 20 76 6c 6f 6f 6b 75 70 2e 20 54 |okup, vlookup. T|
00003b50 68 65 20 74 61 72 67 65 74 20 72 61 6e 67 65 20 |he target range |
00003b60 69 73 20 6e 6f 77 20 74 77 6f 2d 64 69 6d 65 6e |is now two-dimen|
00003b70 73 69 6f 6e 61 6c 20 61 6e 64 20 69 6e 63 6c 75 |sional and inclu|
00003b80 64 65 73 20 61 6c 6c 20 6f 66 20 74 68 65 20 72 |des all of the r|
00003b90 6f 77 73 20 61 6e 64 20 63 6f 6c 75 6d 6e 73 20 |ows and columns |
00003ba0 77 68 69 63 68 20 63 61 6e 20 62 65 20 75 73 65 |which can be use|
00003bb0 64 20 61 73 20 74 68 65 20 6f 66 66 73 65 74 2e |d as the offset.|
00003bc0 20 41 6e 20 65 78 61 6d 70 6c 65 20 6f 66 20 74 | An example of t|
00003bd0 68 69 73 20 77 69 6c 6c 20 63 6c 61 72 69 66 79 |his will clarify|
00003be0 3a 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 37 30 3b 53 |:}.{S:X;X;0;70;S|
00003bf0 75 70 70 6f 73 65 20 79 6f 75 20 77 61 6e 74 20 |uppose you want |
00003c00 74 6f 20 6c 6f 6f 6b 20 66 6f 72 20 74 68 65 20 |to look for the |
00003c10 76 61 6c 75 65 20 34 32 20 69 6e 20 63 65 6c 6c |value 42 in cell|
00003c20 73 20 41 31 20 74 6f 20 41 31 30 30 20 61 6e 64 |s A1 to A100 and|
00003c30 20 72 65 74 75 72 6e 20 74 68 65 20 63 6f 72 72 | return the corr|
00003c40 65 73 70 6f 6e 64 69 6e 67 20 65 6c 65 6d 65 6e |esponding elemen|
00003c50 74 20 66 72 6f 6d 20 63 6f 6c 75 6d 6e 20 43 2e |t from column C.|
00003c60 20 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 37 31 3b 7b | }.{S:X;X;0;71;{|
00003c70 49 54 54 2d 58 7d 49 6e 20 50 69 70 65 44 72 65 |ITT-X}In PipeDre|
00003c80 61 6d 20 74 68 65 20 73 79 6e 74 61 78 20 77 6f |am the syntax wo|
00003c90 75 6c 64 20 62 65 20 76 6c 6f 6f 6b 75 70 28 34 |uld be vlookup(4|
00003ca0 32 2c 20 41 31 41 31 30 30 2c 20 32 29 7d 0a 7b |2, A1A100, 2)}.{|
00003cb0 53 3a 58 3b 58 3b 30 3b 37 32 3b 7b 49 54 54 2d |S:X;X;0;72;{ITT-|
00003cc0 58 7d 49 6e 20 46 69 72 65 77 6f 72 6b 7a 20 74 |X}In Fireworkz t|
00003cd0 68 65 20 73 79 6e 74 61 78 20 77 6f 75 6c 64 20 |he syntax would |
00003ce0 62 65 20 76 6c 6f 6f 6b 75 70 28 34 32 2c 20 41 |be vlookup(42, A|
00003cf0 31 43 31 30 30 2c 20 33 29 7d 0a 7b 53 3a 58 3b |1C100, 3)}.{S:X;|
00003d00 58 3b 30 3b 37 33 3b 49 6e 20 46 69 72 65 77 6f |X;0;73;In Firewo|
00003d10 72 6b 7a 20 77 65 20 69 6e 63 6c 75 64 65 20 61 |rkz we include a|
00003d20 6c 6c 20 6f 66 20 74 68 65 20 70 6f 73 73 69 62 |ll of the possib|
00003d30 6c 65 20 6f 66 66 73 65 74 20 72 61 6e 67 65 73 |le offset ranges|
00003d40 20 69 6e 20 74 68 65 20 74 61 72 67 65 74 20 72 | in the target r|
00003d50 61 6e 67 65 20 28 65 76 65 6e 20 74 68 6f 75 67 |ange (even thoug|
00003d60 68 20 74 68 65 20 6b 65 79 20 69 73 20 6f 6e 6c |h the key is onl|
00003d70 79 20 6c 6f 6f 6b 65 64 20 66 6f 72 20 69 6e 20 |y looked for in |
00003d80 74 68 65 20 66 69 72 73 74 20 63 6f 6c 75 6d 6e |the first column|
00003d90 2f 72 6f 77 29 2e 20 54 68 65 20 6f 66 66 73 65 |/row). The offse|
00003da0 74 20 6e 75 6d 62 65 72 20 67 69 76 65 6e 20 69 |t number given i|
00003db0 73 20 74 68 65 20 63 6f 6c 75 6d 6e 20 28 6f 72 |s the column (or|
00003dc0 20 72 6f 77 29 20 77 69 74 68 69 6e 20 74 68 65 | row) within the|
00003dd0 20 74 61 72 67 65 74 20 72 61 6e 67 65 2e 7d 0a | target range.}.|
00003de0 7b 53 3a 58 3b 58 3b 30 3b 37 34 3b 63 68 6f 6f |{S:X;X;0;74;choo|
00003df0 73 65 20 68 61 73 20 63 68 61 6e 67 65 64 20 73 |se has changed s|
00003e00 6f 20 74 68 61 74 20 61 6e 79 20 72 61 6e 67 65 |o that any range|
00003e10 20 70 61 72 61 6d 65 74 65 72 73 20 61 72 65 20 | parameters are |
00003e20 74 72 65 61 74 65 64 20 61 73 20 73 69 6e 67 6c |treated as singl|
00003e30 65 20 65 6c 65 6d 65 6e 74 73 2e 20 53 6f 20 63 |e elements. So c|
00003e40 68 6f 6f 73 65 28 33 2c 20 31 2c 20 41 31 41 33 |hoose(3, 1, A1A3|
00003e50 2c 20 36 29 20 77 69 6c 6c 20 72 65 74 75 72 6e |, 6) will return|
00003e60 20 36 20 72 61 74 68 65 72 20 74 68 61 6e 20 41 | 6 rather than A|
00003e70 32 2e 20 63 68 6f 6f 73 65 28 32 2c 20 31 2c 20 |2. choose(2, 1, |
00003e80 41 31 41 33 2c 20 36 29 20 77 69 6c 6c 20 72 65 |A1A3, 6) will re|
00003e90 74 75 72 6e 20 74 68 65 20 63 6f 6e 74 65 6e 74 |turn the content|
00003ea0 73 20 6f 66 20 41 31 41 33 20 61 73 20 61 6e 20 |s of A1A3 as an |
00003eb0 61 72 72 61 79 2e 7d 0a 7b 53 3a 58 3b 58 3b 30 |array.}.{S:X;X;0|
00003ec0 3b 37 35 3b 54 68 65 20 74 72 69 67 20 66 75 6e |;75;The trig fun|
00003ed0 63 74 69 6f 6e 73 20 61 63 73 2c 20 61 73 6e 2c |ctions acs, asn,|
00003ee0 20 61 74 6e 20 68 61 76 65 20 62 65 65 6e 20 72 | atn have been r|
00003ef0 65 6e 61 6d 65 64 20 61 73 20 61 63 6f 73 2c 20 |enamed as acos, |
00003f00 61 73 69 6e 20 61 6e 64 20 61 74 61 6e 20 69 6e |asin and atan in|
00003f10 20 6b 65 65 70 69 6e 67 20 77 69 74 68 20 73 74 | keeping with st|
00003f20 61 6e 64 61 72 64 20 73 70 72 65 61 64 73 68 65 |andard spreadshe|
00003f30 65 74 20 74 65 72 6d 69 6e 6f 6c 6f 67 79 2e 7d |et terminology.}|
00003f40 0a 7b 53 3a 58 3b 58 3b 30 3b 37 36 3b 45 78 74 |.{S:X;X;0;76;Ext|
00003f50 65 72 6e 61 6c 20 72 65 66 65 72 65 6e 63 65 73 |ernal references|
00003f60 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 37 37 3b 46 69 |}.{S:X;X;0;77;Fi|
00003f70 72 65 77 6f 72 6b 7a 20 68 61 73 20 73 69 6d 69 |reworkz has simi|
00003f80 6c 61 72 20 65 78 74 65 72 6e 61 6c 20 72 65 66 |lar external ref|
00003f90 65 72 65 6e 63 65 73 20 74 6f 20 50 69 70 65 44 |erences to PipeD|
00003fa0 72 65 61 6d 2e 20 49 74 20 61 6c 73 6f 20 6b 65 |ream. It also ke|
00003fb0 65 70 73 20 74 72 61 63 6b 20 6f 66 20 77 68 69 |eps track of whi|
00003fc0 63 68 20 66 69 6c 65 73 20 61 72 65 20 67 72 6f |ch files are gro|
00003fd0 75 70 65 64 20 74 6f 67 65 74 68 65 72 20 61 6e |uped together an|
00003fe0 64 20 69 66 20 79 6f 75 20 61 74 74 65 6d 70 74 |d if you attempt|
00003ff0 20 74 6f 20 63 6c 6f 73 65 20 6f 6e 65 20 66 69 | to close one fi|
00004000 6c 65 20 69 6e 20 61 20 67 72 6f 75 70 2c 20 46 |le in a group, F|
00004010 69 72 65 77 6f 72 6b 7a 20 77 69 6c 6c 20 70 72 |ireworkz will pr|
00004020 6f 6d 70 74 20 79 6f 75 20 74 6f 20 63 6c 6f 73 |ompt you to clos|
00004030 65 20 61 6c 6c 20 74 68 65 20 66 69 6c 65 73 20 |e all the files |
00004040 69 6e 20 74 68 65 20 67 72 6f 75 70 2e 20 54 68 |in the group. Th|
00004050 69 73 20 6d 61 6b 65 73 20 6c 6f 61 64 69 6e 67 |is makes loading|
00004060 20 61 6e 64 20 73 61 76 69 6e 67 20 6c 69 6e 6b | and saving link|
00004070 65 64 20 73 70 72 65 61 64 73 68 65 65 74 73 20 |ed spreadsheets |
00004080 72 61 74 68 65 72 20 65 61 73 69 65 72 2e 7d 0a |rather easier.}.|
00004090 7b 53 3a 58 3b 58 3b 30 3b 37 38 3b 49 66 20 79 |{S:X;X;0;78;If y|
000040a0 6f 75 20 6c 6f 61 64 20 61 20 50 69 70 65 44 72 |ou load a PipeDr|
000040b0 65 61 6d 20 66 69 6c 65 20 63 6f 6e 74 61 69 6e |eam file contain|
000040c0 69 6e 67 20 65 78 74 65 72 6e 61 6c 20 72 65 66 |ing external ref|
000040d0 65 72 65 6e 63 65 73 2c 20 46 69 72 65 77 6f 72 |erences, Firewor|
000040e0 6b 7a 20 77 69 6c 6c 20 6e 6f 74 20 69 6d 6d 65 |kz will not imme|
000040f0 64 69 61 74 65 6c 79 20 62 65 20 61 62 6c 65 20 |diately be able |
00004100 74 6f 20 66 69 6e 64 20 74 68 65 20 73 75 70 70 |to find the supp|
00004110 6f 72 74 69 6e 67 20 66 69 6c 65 73 2e 20 54 68 |orting files. Th|
00004120 69 73 20 69 73 20 62 65 63 61 75 73 65 20 46 69 |is is because Fi|
00004130 72 65 77 6f 72 6b 7a 20 77 69 6c 6c 20 6e 6f 74 |reworkz will not|
00004140 20 75 73 65 20 74 68 65 20 50 69 70 65 44 72 65 | use the PipeDre|
00004150 61 6d 20 66 69 6c 65 27 73 20 70 61 74 68 2c 20 |am file's path, |
00004160 62 75 74 20 63 72 65 61 74 65 20 61 20 6e 65 77 |but create a new|
00004170 20 66 69 6c 65 6e 61 6d 65 20 6f 66 20 74 68 65 | filename of the|
00004180 20 66 6f 72 6d 20 53 68 65 65 74 31 2e 20 74 68 | form Sheet1. th|
00004190 65 20 62 65 73 74 20 61 70 70 72 6f 61 63 68 20 |e best approach |
000041a0 74 6f 20 67 65 74 74 69 6e 67 20 74 68 65 20 6c |to getting the l|
000041b0 69 6e 6b 65 64 20 73 70 72 65 61 64 73 68 65 65 |inked spreadshee|
000041c0 74 73 20 77 6f 72 6b 69 6e 67 20 77 69 74 68 20 |ts working with |
000041d0 46 69 72 65 77 6f 72 6b 7a 20 69 73 3a 7d 0a 7b |Fireworkz is:}.{|
000041e0 53 3a 58 3b 58 3b 30 3b 37 39 3b 28 69 29 7b 49 |S:X;X;0;79;(i){I|
000041f0 54 54 2d 58 7d 63 6f 70 79 20 61 6c 6c 20 6f 66 |TT-X}copy all of|
00004200 20 74 68 65 20 6c 69 6e 6b 65 64 20 73 70 72 65 | the linked spre|
00004210 61 64 73 68 65 65 74 73 20 69 6e 74 6f 20 61 20 |adsheets into a |
00004220 6e 65 77 20 64 69 72 65 63 74 6f 72 79 2c 20 72 |new directory, r|
00004230 65 74 61 69 6e 69 6e 67 20 74 68 65 20 6f 6c 64 |etaining the old|
00004240 20 64 69 72 65 63 74 6f 72 79 20 63 6f 6e 74 61 | directory conta|
00004250 69 6e 69 6e 67 20 74 68 65 20 50 69 70 65 44 72 |ining the PipeDr|
00004260 65 61 6d 20 73 65 74 20 69 66 20 79 6f 75 20 6e |eam set if you n|
00004270 65 65 64 20 74 6f 20 72 65 66 65 72 20 62 61 63 |eed to refer bac|
00004280 6b 20 74 6f 20 74 68 65 6d 2e 7d 0a 7b 53 3a 58 |k to them.}.{S:X|
00004290 3b 58 3b 30 3b 38 30 3b 28 69 69 29 20 7b 49 54 |;X;0;80;(ii) {IT|
000042a0 54 2d 58 7d 6c 6f 61 64 20 65 61 63 68 20 66 69 |T-X}load each fi|
000042b0 6c 65 20 69 6e 20 74 68 65 20 6e 65 77 20 64 69 |le in the new di|
000042c0 72 65 63 74 6f 72 79 20 69 6e 64 69 76 69 64 75 |rectory individu|
000042d0 61 6c 6c 79 20 61 6e 64 20 73 61 76 65 20 69 74 |ally and save it|
000042e0 20 62 61 63 6b 20 69 6e 74 6f 20 74 68 65 20 6e | back into the n|
000042f0 65 77 20 64 69 72 65 63 74 6f 72 79 20 75 73 69 |ew directory usi|
00004300 6e 67 20 74 68 65 20 65 78 69 73 74 69 6e 67 20 |ng the existing |
00004310 50 69 70 65 44 72 65 61 6d 20 6e 61 6d 65 2e 7d |PipeDream name.}|
00004320 0a 7b 53 3a 58 3b 58 3b 30 3b 38 31 3b 28 69 69 |.{S:X;X;0;81;(ii|
00004330 69 29 20 7b 49 54 54 2d 58 7d 77 68 65 6e 20 61 |i) {ITT-X}when a|
00004340 6c 6c 20 6f 66 20 74 68 65 20 66 69 6c 65 73 20 |ll of the files |
00004350 68 61 76 65 20 62 65 65 6e 20 6c 6f 61 64 65 64 |have been loaded|
00004360 20 61 6e 64 20 73 61 76 65 64 20 79 6f 75 20 77 | and saved you w|
00004370 69 6c 6c 20 66 69 6e 64 20 74 68 61 74 20 6c 6f |ill find that lo|
00004380 61 64 69 6e 67 20 74 68 65 20 64 65 70 65 6e 64 |ading the depend|
00004390 65 6e 74 20 64 6f 63 75 6d 65 6e 74 20 77 69 6c |ent document wil|
000043a0 6c 20 61 75 74 6f 6d 61 74 69 63 61 6c 6c 79 20 |l automatically |
000043b0 6c 6f 61 64 20 74 68 65 20 73 75 70 70 6f 72 74 |load the support|
000043c0 65 72 73 2e 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 38 |ers.}.{S:X;X;0;8|
000043d0 32 3b 43 75 73 74 6f 6d 20 66 75 6e 63 74 69 6f |2;Custom functio|
000043e0 6e 20 73 68 65 65 74 73 2c 20 62 65 69 6e 67 20 |n sheets, being |
000043f0 73 75 70 70 6f 72 74 69 6e 67 20 64 6f 63 75 6d |supporting docum|
00004400 65 6e 74 73 2c 20 77 6f 72 6b 20 69 6e 20 65 78 |ents, work in ex|
00004410 61 63 74 6c 79 20 74 68 65 20 73 61 6d 65 20 77 |actly the same w|
00004420 61 79 2e 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 38 33 |ay.}.{S:X;X;0;83|
00004430 3b 4c 6f 61 64 69 6e 67 20 6c 61 72 67 65 20 66 |;Loading large f|
00004440 69 6c 65 73 7d 0a 7b 53 3a 58 3b 58 3b 30 3b 38 |iles}.{S:X;X;0;8|
00004450 34 3b 50 6c 65 61 73 65 20 6d 61 6b 65 20 73 75 |4;Please make su|
00004460 72 65 20 79 6f 75 20 68 61 76 65 20 72 65 61 64 |re you have read|
00004470 20 74 68 65 20 69 6e 66 6f 72 6d 61 74 69 6f 6e | the information|
00004480 20 69 6e 20 74 68 65 20 6d 61 69 6e 20 52 65 61 | in the main Rea|
00004490 64 6d 65 6d 6f 72 65 20 66 69 6c 65 20 61 62 6f |dmemore file abo|
000044a0 75 74 20 6c 6f 61 64 69 6e 67 20 61 6e 64 20 63 |ut loading and c|
000044b0 6f 6e 76 65 72 74 69 6e 67 20 6f 66 20 50 69 70 |onverting of Pip|
000044c0 65 44 72 65 61 6d 20 66 69 6c 65 73 2e 7d 0a 7b |eDream files.}.{|
000044d0 42 52 3a 3b 3b 3b 3b 3b 3b 3b 3b 31 3b 31 3b 7b |BR:;;;;;;;;1;1;{|
000044e0 53 74 79 6c 65 48 61 6e 64 6c 65 3a 42 61 73 65 |StyleHandle:Base|
000044f0 4c 65 74 74 65 72 7d 7d 0a 7b 42 52 3a 3b 3b 3b |Letter}}.{BR:;;;|
00004500 3b 3b 3b 3b 3b 31 3b 31 3b 7b 43 6f 6c 57 69 64 |;;;;;1;1;{ColWid|
00004510 74 68 3a 30 7d 7d 0a 7b 42 52 3a 30 3b 3b 3b 3b |th:0}}.{BR:0;;;;|
00004520 31 3b 3b 3b 3b 31 3b 30 3b 7b 53 74 79 6c 65 48 |1;;;;1;0;{StyleH|
00004530 61 6e 64 6c 65 3a 42 61 73 65 4c 65 74 74 65 72 |andle:BaseLetter|
00004540 7d 7d 0a 7b 52 3a 30 3b 31 32 3b 3b 33 32 3b 31 |}}.{R:0;12;;32;1|
00004550 3b 31 33 3b 3b 33 32 3b 30 3b 30 3b 7b 42 6f 6c |;13;;32;0;0;{Bol|
00004560 64 3a 31 7d 7d 0a 7b 52 3a 30 3b 31 34 3b 31 38 |d:1}}.{R:0;14;18|
00004570 3b 33 3b 31 3b 31 35 3b 3b 33 32 3b 30 3b 30 3b |;3;1;15;;32;0;0;|
00004580 7b 42 6f 6c 64 3a 31 7d 7d 0a 7b 52 3a 30 3b 31 |{Bold:1}}.{R:0;1|
00004590 34 3b 32 34 3b 33 3b 31 3b 31 35 3b 3b 33 32 3b |4;24;3;1;15;;32;|
000045a0 30 3b 30 3b 7b 42 6f 6c 64 3a 30 7d 7d 0a 7b 52 |0;0;{Bold:0}}.{R|
000045b0 3a 30 3b 31 34 3b 31 35 36 3b 33 3b 31 3b 31 35 |:0;14;156;3;1;15|
000045c0 3b 3b 33 32 3b 30 3b 30 3b 7b 42 6f 6c 64 3a 31 |;;32;0;0;{Bold:1|
000045d0 7d 7d 0a 7b 52 3a 30 3b 31 34 3b 31 36 33 3b 33 |}}.{R:0;14;163;3|
000045e0 3b 31 3b 31 35 3b 3b 33 32 3b 30 3b 30 3b 7b 42 |;1;15;;32;0;0;{B|
000045f0 6f 6c 64 3a 30 7d 7d 0a 7b 52 3a 30 3b 31 37 3b |old:0}}.{R:0;17;|
00004600 3b 33 32 3b 31 3b 32 31 3b 3b 33 32 3b 30 3b 30 |;32;1;21;;32;0;0|
00004610 3b 7b 4d 61 72 67 69 6e 4c 65 66 74 3a 31 35 38 |;{MarginLeft:158|
00004620 37 7d 7d 0a 7b 52 3a 30 3b 36 3b 3b 33 32 3b 31 |7}}.{R:0;6;;32;1|
00004630 3b 37 3b 3b 33 32 3b 30 3b 30 3b 7b 53 74 79 6c |;7;;32;0;0;{Styl|
00004640 65 48 61 6e 64 6c 65 3a 4d 61 69 6e 48 65 61 64 |eHandle:MainHead|
00004650 69 6e 67 7d 7d 0a 7b 52 3a 30 3b 33 38 3b 3b 33 |ing}}.{R:0;38;;3|
00004660 32 3b 31 3b 33 39 3b 3b 33 32 3b 30 3b 30 3b 7b |2;1;39;;32;0;0;{|
00004670 42 6f 6c 64 3a 31 7d 7d 0a 7b 52 3a 30 3b 33 39 |Bold:1}}.{R:0;39|
00004680 3b 3b 33 32 3b 31 3b 34 30 3b 33 3b 33 3b 30 3b |;;32;1;40;3;3;0;|
00004690 30 3b 7b 49 74 61 6c 69 63 3a 31 7d 7d 0a 7b 52 |0;{Italic:1}}.{R|
000046a0 3a 30 3b 34 32 3b 3b 33 32 3b 31 3b 34 33 3b 37 |:0;42;;32;1;43;7|
000046b0 3b 33 3b 30 3b 30 3b 7b 49 74 61 6c 69 63 3a 31 |;3;0;0;{Italic:1|
000046c0 7d 7d 0a 7b 52 3a 30 3b 34 37 3b 3b 33 32 3b 31 |}}.{R:0;47;;32;1|
000046d0 3b 34 38 3b 39 3b 33 3b 30 3b 30 3b 7b 49 74 61 |;48;9;3;0;0;{Ita|
000046e0 6c 69 63 3a 31 7d 7d 0a 7b 52 3a 30 3b 34 38 3b |lic:1}}.{R:0;48;|
000046f0 3b 33 32 3b 31 3b 34 39 3b 34 3b 33 3b 30 3b 30 |;32;1;49;4;3;0;0|
00004700 3b 7b 49 74 61 6c 69 63 3a 31 7d 7d 0a 7b 52 3a |;{Italic:1}}.{R:|
00004710 30 3b 34 33 3b 3b 33 32 3b 31 3b 34 34 3b 34 3b |0;43;;32;1;44;4;|
00004720 33 3b 30 3b 30 3b 7b 49 74 61 6c 69 63 3a 31 7d |3;0;0;{Italic:1}|
00004730 7d 0a 7b 52 3a 30 3b 34 39 3b 3b 33 32 3b 31 3b |}.{R:0;49;;32;1;|
00004740 35 30 3b 35 3b 33 3b 30 3b 30 3b 7b 49 74 61 6c |50;5;3;0;0;{Ital|
00004750 69 63 3a 31 7d 7d 0a 7b 52 3a 30 3b 35 31 3b 3b |ic:1}}.{R:0;51;;|
00004760 33 32 3b 31 3b 35 32 3b 34 3b 33 3b 30 3b 30 3b |32;1;52;4;3;0;0;|
00004770 7b 49 74 61 6c 69 63 3a 31 7d 7d 0a 7b 52 3a 30 |{Italic:1}}.{R:0|
00004780 3b 34 30 3b 3b 33 32 3b 31 3b 34 31 3b 33 3b 33 |;40;;32;1;41;3;3|
00004790 3b 30 3b 30 3b 7b 49 74 61 6c 69 63 3a 31 7d 7d |;0;0;{Italic:1}}|
000047a0 0a 7b 52 3a 30 3b 34 31 3b 3b 33 32 3b 31 3b 34 |.{R:0;41;;32;1;4|
000047b0 32 3b 36 3b 33 3b 30 3b 30 3b 7b 49 74 61 6c 69 |2;6;3;0;0;{Itali|
000047c0 63 3a 31 7d 7d 0a 7b 52 3a 30 3b 34 35 3b 3b 33 |c:1}}.{R:0;45;;3|
000047d0 32 3b 31 3b 34 36 3b 39 3b 33 3b 30 3b 30 3b 7b |2;1;46;9;3;0;0;{|
000047e0 49 74 61 6c 69 63 3a 31 7d 7d 0a 7b 52 3a 30 3b |Italic:1}}.{R:0;|
000047f0 34 36 3b 3b 33 32 3b 31 3b 34 37 3b 36 3b 33 3b |46;;32;1;47;6;3;|
00004800 30 3b 30 3b 7b 49 74 61 6c 69 63 3a 31 7d 7d 0a |0;0;{Italic:1}}.|
00004810 7b 52 3a 30 3b 35 32 3b 3b 33 32 3b 31 3b 35 33 |{R:0;52;;32;1;53|
00004820 3b 38 3b 33 3b 30 3b 30 3b 7b 49 74 61 6c 69 63 |;8;3;0;0;{Italic|
00004830 3a 31 7d 7d 0a 7b 52 3a 30 3b 35 30 3b 3b 33 32 |:1}}.{R:0;50;;32|
00004840 3b 31 3b 35 31 3b 34 3b 33 3b 30 3b 30 3b 7b 49 |;1;51;4;3;0;0;{I|
00004850 74 61 6c 69 63 3a 31 7d 7d 0a 7b 52 3a 30 3b 34 |talic:1}}.{R:0;4|
00004860 34 3b 3b 33 32 3b 31 3b 34 35 3b 31 32 3b 33 3b |4;;32;1;45;12;3;|
00004870 30 3b 30 3b 7b 49 74 61 6c 69 63 3a 31 7d 7d 0a |0;0;{Italic:1}}.|
00004880 7b 52 3a 30 3b 35 33 3b 3b 33 32 3b 31 3b 35 34 |{R:0;53;;32;1;54|
00004890 3b 34 3b 33 3b 30 3b 30 3b 7b 49 74 61 6c 69 63 |;4;3;0;0;{Italic|
000048a0 3a 31 7d 7d 0a 7b 52 3a 30 3b 32 37 3b 3b 33 32 |:1}}.{R:0;27;;32|
000048b0 3b 31 3b 32 38 3b 31 34 3b 33 3b 30 3b 30 3b 7b |;1;28;14;3;0;0;{|
000048c0 42 6f 6c 64 3a 31 7d 7d 0a 7b 52 3a 30 3b 32 34 |Bold:1}}.{R:0;24|
000048d0 3b 3b 33 32 3b 31 3b 32 35 3b 31 31 3b 33 3b 30 |;;32;1;25;11;3;0|
000048e0 3b 30 3b 7b 42 6f 6c 64 3a 31 7d 7d 0a 7b 52 3a |;0;{Bold:1}}.{R:|
000048f0 30 3b 32 39 3b 3b 33 32 3b 31 3b 33 30 3b 31 32 |0;29;;32;1;30;12|
00004900 3b 33 3b 30 3b 30 3b 7b 42 6f 6c 64 3a 31 7d 7d |;3;0;0;{Bold:1}}|
00004910 0a 7b 52 3a 30 3b 32 38 3b 34 3b 33 3b 31 3b 32 |.{R:0;28;4;3;1;2|
00004920 39 3b 31 35 3b 33 3b 30 3b 30 3b 7b 42 6f 6c 64 |9;15;3;0;0;{Bold|
00004930 3a 31 7d 7d 0a 7b 52 3a 30 3b 33 31 3b 34 3b 33 |:1}}.{R:0;31;4;3|
00004940 3b 31 3b 33 32 3b 31 36 3b 33 3b 30 3b 30 3b 7b |;1;32;16;3;0;0;{|
00004950 42 6f 6c 64 3a 31 7d 7d 0a 7b 52 3a 30 3b 33 33 |Bold:1}}.{R:0;33|
00004960 3b 3b 33 32 3b 31 3b 33 34 3b 31 30 3b 33 3b 30 |;;32;1;34;10;3;0|
00004970 3b 30 3b 7b 42 6f 6c 64 3a 31 7d 7d 0a 7b 52 3a |;0;{Bold:1}}.{R:|
00004980 30 3b 33 34 3b 3b 33 32 3b 31 3b 33 35 3b 31 39 |0;34;;32;1;35;19|
00004990 3b 33 3b 30 3b 30 3b 7b 42 6f 6c 64 3a 31 7d 7d |;3;0;0;{Bold:1}}|
000049a0 0a 7b 52 3a 30 3b 33 35 3b 3b 33 32 3b 31 3b 33 |.{R:0;35;;32;1;3|
000049b0 36 3b 39 3b 33 3b 30 3b 30 3b 7b 42 6f 6c 64 3a |6;9;3;0;0;{Bold:|
000049c0 31 7d 7d 0a 7b 52 3a 30 3b 33 37 3b 31 36 3b 33 |1}}.{R:0;37;16;3|
000049d0 3b 31 3b 33 38 3b 32 31 3b 33 3b 30 3b 30 3b 7b |;1;38;21;3;0;0;{|
000049e0 42 6f 6c 64 3a 31 7d 7d 0a 7b 52 3a 30 3b 33 36 |Bold:1}}.{R:0;36|
000049f0 3b 3b 33 32 3b 31 3b 33 37 3b 39 3b 33 3b 30 3b |;;32;1;37;9;3;0;|
00004a00 30 3b 7b 42 6f 6c 64 3a 31 7d 7d 0a 7b 52 3a 30 |0;{Bold:1}}.{R:0|
00004a10 3b 33 30 3b 3b 33 32 3b 31 3b 33 31 3b 38 3b 33 |;30;;32;1;31;8;3|
00004a20 3b 30 3b 30 3b 7b 42 6f 6c 64 3a 31 7d 7d 0a 7b |;0;0;{Bold:1}}.{|
00004a30 52 3a 30 3b 35 35 3b 3b 33 32 3b 31 3b 35 36 3b |R:0;55;;32;1;56;|
00004a40 36 3b 33 3b 30 3b 30 3b 7b 49 74 61 6c 69 63 3a |6;3;0;0;{Italic:|
00004a50 31 7d 7d 0a 7b 52 3a 30 3b 35 34 3b 3b 33 32 3b |1}}.{R:0;54;;32;|
00004a60 31 3b 35 35 3b 3b 33 32 3b 30 3b 30 3b 7b 42 6f |1;55;;32;0;0;{Bo|
00004a70 6c 64 3a 31 7d 7d 0a 7b 52 3a 30 3b 35 36 3b 3b |ld:1}}.{R:0;56;;|
00004a80 33 32 3b 31 3b 35 37 3b 39 3b 33 3b 30 3b 30 3b |32;1;57;9;3;0;0;|
00004a90 7b 49 74 61 6c 69 63 3a 31 7d 7d 0a 7b 52 3a 30 |{Italic:1}}.{R:0|
00004aa0 3b 32 32 3b 3b 33 32 3b 31 3b 32 33 3b 3b 33 32 |;22;;32;1;23;;32|
00004ab0 3b 30 3b 30 3b 7b 53 74 79 6c 65 48 61 6e 64 6c |;0;0;{StyleHandl|
00004ac0 65 3a 4d 61 69 6e 48 65 61 64 69 6e 67 7d 7d 0a |e:MainHeading}}.|
00004ad0 7b 52 3a 30 3b 31 3b 3b 33 32 3b 31 3b 32 3b 3b |{R:0;1;;32;1;2;;|
00004ae0 33 32 3b 30 3b 30 3b 7b 53 74 79 6c 65 48 61 6e |32;0;0;{StyleHan|
00004af0 64 6c 65 3a 48 65 61 64 69 6e 67 7d 7d 0a 7b 52 |dle:Heading}}.{R|
00004b00 3a 30 3b 38 33 3b 3b 33 32 3b 31 3b 38 34 3b 3b |:0;83;;32;1;84;;|
00004b10 33 32 3b 30 3b 30 3b 7b 42 6f 6c 64 3a 31 7d 7d |32;0;0;{Bold:1}}|
00004b20 0a 7b 52 3a 30 3b 36 37 3b 3b 33 32 3b 31 3b 36 |.{R:0;67;;32;1;6|
00004b30 38 3b 3b 33 32 3b 30 3b 30 3b 7b 42 6f 6c 64 3a |8;;32;0;0;{Bold:|
00004b40 31 7d 7d 0a 7b 52 3a 30 3b 37 35 3b 31 39 3b 33 |1}}.{R:0;75;19;3|
00004b50 3b 31 3b 37 36 3b 32 32 3b 33 3b 30 3b 30 3b 7b |;1;76;22;3;0;0;{|
00004b60 49 74 61 6c 69 63 3a 31 7d 7d 0a 7b 52 3a 30 3b |Italic:1}}.{R:0;|
00004b70 37 35 3b 32 34 3b 33 3b 31 3b 37 36 3b 32 37 3b |75;24;3;1;76;27;|
00004b80 33 3b 30 3b 30 3b 7b 49 74 61 6c 69 63 3a 31 7d |3;0;0;{Italic:1}|
00004b90 7d 0a 7b 52 3a 30 3b 37 35 3b 32 39 3b 33 3b 31 |}.{R:0;75;29;3;1|
00004ba0 3b 37 36 3b 33 32 3b 33 3b 30 3b 30 3b 7b 49 74 |;76;32;3;0;0;{It|
00004bb0 61 6c 69 63 3a 31 7d 7d 0a 7b 52 3a 30 3b 37 35 |alic:1}}.{R:0;75|
00004bc0 3b 35 34 3b 33 3b 31 3b 37 36 3b 35 38 3b 33 3b |;54;3;1;76;58;3;|
00004bd0 30 3b 30 3b 7b 49 74 61 6c 69 63 3a 31 7d 7d 0a |0;0;{Italic:1}}.|
00004be0 7b 52 3a 30 3b 37 35 3b 36 30 3b 33 3b 31 3b 37 |{R:0;75;60;3;1;7|
00004bf0 36 3b 36 34 3b 33 3b 30 3b 30 3b 7b 49 74 61 6c |6;64;3;0;0;{Ital|
00004c00 69 63 3a 31 7d 7d 0a 7b 52 3a 30 3b 37 35 3b 36 |ic:1}}.{R:0;75;6|
00004c10 39 3b 33 3b 31 3b 37 36 3b 37 33 3b 33 3b 30 3b |9;3;1;76;73;3;0;|
00004c20 30 3b 7b 49 74 61 6c 69 63 3a 31 7d 7d 0a 7b 52 |0;{Italic:1}}.{R|
00004c30 3a 30 3b 36 39 3b 39 3b 33 3b 31 3b 37 30 3b 31 |:0;69;9;3;1;70;1|
00004c40 36 3b 33 3b 30 3b 30 3b 7b 49 74 61 6c 69 63 3a |6;3;0;0;{Italic:|
00004c50 31 7d 7d 0a 7b 52 3a 30 3b 36 39 3b 3b 33 32 3b |1}}.{R:0;69;;32;|
00004c60 31 3b 37 30 3b 37 3b 33 3b 30 3b 30 3b 7b 49 74 |1;70;7;3;0;0;{It|
00004c70 61 6c 69 63 3a 31 7d 7d 0a 7b 52 3a 30 3b 37 34 |alic:1}}.{R:0;74|
00004c80 3b 3b 33 32 3b 31 3b 37 35 3b 36 3b 33 3b 30 3b |;;32;1;75;6;3;0;|
00004c90 30 3b 7b 49 74 61 6c 69 63 3a 31 7d 7d 0a 7b 52 |0;{Italic:1}}.{R|
00004ca0 3a 30 3b 35 39 3b 3b 33 32 3b 31 3b 36 30 3b 3b |:0;59;;32;1;60;;|
00004cb0 33 32 3b 30 3b 30 3b 7b 42 6f 6c 64 3a 31 7d 7d |32;0;0;{Bold:1}}|
00004cc0 0a 7b 52 3a 30 3b 36 31 3b 3b 33 32 3b 31 3b 36 |.{R:0;61;;32;1;6|
00004cd0 32 3b 3b 33 32 3b 30 3b 30 3b 7b 42 6f 6c 64 3a |2;;32;0;0;{Bold:|
00004ce0 31 7d 7d 0a 7b 52 3a 30 3b 36 33 3b 34 39 3b 33 |1}}.{R:0;63;49;3|
00004cf0 3b 31 3b 36 34 3b 35 39 3b 33 3b 30 3b 30 3b 7b |;1;64;59;3;0;0;{|
00004d00 49 74 61 6c 69 63 3a 31 7d 7d 0a 7b 52 3a 30 3b |Italic:1}}.{R:0;|
00004d10 36 35 3b 34 32 34 3b 33 3b 31 3b 36 36 3b 34 33 |65;424;3;1;66;43|
00004d20 36 3b 33 3b 30 3b 30 3b 7b 42 6f 6c 64 3a 30 7d |6;3;0;0;{Bold:0}|
00004d30 7b 49 74 61 6c 69 63 3a 31 7d 7d 0a 7b 52 3a 30 |{Italic:1}}.{R:0|
00004d40 3b 36 34 3b 3b 33 32 3b 31 3b 36 35 3b 3b 33 32 |;64;;32;1;65;;32|
00004d50 3b 30 3b 30 3b 7b 42 6f 6c 64 3a 31 7d 7d 0a 7b |;0;0;{Bold:1}}.{|
00004d60 52 3a 30 3b 37 36 3b 3b 33 32 3b 31 3b 37 37 3b |R:0;76;;32;1;77;|
00004d70 3b 33 32 3b 30 3b 30 3b 7b 42 6f 6c 64 3a 31 7d |;32;0;0;{Bold:1}|
00004d80 7d 0a 7b 52 3a 30 3b 37 39 3b 3b 33 32 3b 31 3b |}.{R:0;79;;32;1;|
00004d90 38 32 3b 3b 33 32 3b 30 3b 30 3b 7b 53 74 79 6c |82;;32;0;0;{Styl|
00004da0 65 48 61 6e 64 6c 65 3a 49 6e 64 65 6e 74 7d 7d |eHandle:Indent}}|
00004db0 0a 7b 52 3a 30 3b 37 31 3b 3b 33 32 3b 31 3b 37 |.{R:0;71;;32;1;7|
00004dc0 33 3b 3b 33 32 3b 30 3b 30 3b 7b 53 74 79 6c 65 |3;;32;0;0;{Style|
00004dd0 48 61 6e 64 6c 65 3a 49 6e 64 65 6e 74 7d 7d 0a |Handle:Indent}}.|
00004de0 7b 52 3a 30 3b 36 36 3b 36 39 3b 33 3b 31 3b 36 |{R:0;66;69;3;1;6|
00004df0 37 3b 3b 33 32 3b 30 3b 30 3b 7b 49 74 61 6c 69 |7;;32;0;0;{Itali|
00004e00 63 3a 31 7d 7d 0a 7b 52 3a 30 3b 36 36 3b 37 33 |c:1}}.{R:0;66;73|
00004e10 3b 33 3b 31 3b 36 37 3b 3b 33 32 3b 30 3b 30 3b |;3;1;67;;32;0;0;|
00004e20 7b 49 74 61 6c 69 63 3a 30 7d 7d 0a 7b 52 3a 30 |{Italic:0}}.{R:0|
00004e30 3b 35 37 3b 3b 33 32 3b 31 3b 35 38 3b 3b 33 32 |;57;;32;1;58;;32|
00004e40 3b 30 3b 30 3b 7b 53 74 79 6c 65 48 61 6e 64 6c |;0;0;{StyleHandl|
00004e50 65 3a 49 6e 64 65 6e 74 7d 7d 0a 7b 52 3a 30 3b |e:Indent}}.{R:0;|
00004e60 35 37 3b 3b 33 32 3b 31 3b 35 38 3b 3b 33 32 3b |57;;32;1;58;;32;|
00004e70 30 3b 30 3b 7b 53 74 79 6c 65 48 61 6e 64 6c 65 |0;0;{StyleHandle|
00004e80 3a 4d 61 69 6e 48 65 61 64 69 6e 67 7d 7d 0a 7b |:MainHeading}}.{|
00004e90 52 3a 30 3b 38 34 3b 35 39 3b 33 3b 31 3b 38 35 |R:0;84;59;3;1;85|
00004ea0 3b 36 39 3b 33 3b 30 3b 30 3b 7b 42 6f 6c 64 3a |;69;3;0;0;{Bold:|
00004eb0 31 7d 7d 0a 7b 50 61 67 65 48 65 66 6f 42 72 65 |1}}.{PageHefoBre|
00004ec0 61 6b 56 61 6c 75 65 73 2d 48 3a 30 3b 30 3b 30 |akValues-H:0;0;0|
00004ed0 3b 3b 31 3b 30 3b 36 38 3b 30 3b 3b 3b 30 3b 3b |;;1;0;68;0;;;0;;|
00004ee0 3b 31 3b 30 3b 30 3b 30 3b 3b 3b 30 7d 0a 7b 48 |;1;0;0;0;;;0}.{H|
00004ef0 44 2d 48 3a 30 3b 32 7d 0a 7b 48 42 52 2d 48 3a |D-H:0;2}.{HBR-H:|
00004f00 30 3b 32 3b 3b 33 32 3b 3b 33 32 3b 7b 53 74 79 |0;2;;32;;32;{Sty|
00004f10 6c 65 48 61 6e 64 6c 65 3a 42 61 73 65 4c 65 74 |leHandle:BaseLet|
00004f20 74 65 72 7d 7d 0a 7b 48 42 52 2d 48 3a 30 3b 32 |ter}}.{HBR-H:0;2|
00004f30 3b 3b 33 32 3b 3b 33 32 3b 7b 53 74 79 6c 65 48 |;;32;;32;{StyleH|
00004f40 61 6e 64 6c 65 3a 42 61 73 65 48 65 61 64 46 6f |andle:BaseHeadFo|
00004f50 6f 74 7d 7d 0a 7b 48 44 2d 48 3a 30 3b 33 7d 0a |ot}}.{HD-H:0;3}.|
00004f60 7b 48 42 52 2d 48 3a 30 3b 33 3b 3b 33 32 3b 3b |{HBR-H:0;3;;32;;|
00004f70 33 32 3b 7b 53 74 79 6c 65 48 61 6e 64 6c 65 3a |32;{StyleHandle:|
00004f80 42 61 73 65 4c 65 74 74 65 72 7d 7d 0a 7b 48 42 |BaseLetter}}.{HB|
00004f90 52 2d 48 3a 30 3b 33 3b 3b 33 32 3b 3b 33 32 3b |R-H:0;3;;32;;32;|
00004fa0 7b 53 74 79 6c 65 48 61 6e 64 6c 65 3a 42 61 73 |{StyleHandle:Bas|
00004fb0 65 48 65 61 64 46 6f 6f 74 7d 7d 0a 7b 45 6e 64 |eHeadFoot}}.{End|
00004fc0 4f 66 44 61 74 61 7d 0a 7b 43 6d 64 47 72 6f 75 |OfData}.{CmdGrou|
00004fd0 70 3a 7b 56 69 65 77 43 72 65 61 74 65 3a 30 3b |p:{ViewCreate:0;|
00004fe0 31 33 34 37 32 3b 31 33 31 32 30 3b 31 33 34 34 |13472;13120;1344|
00004ff0 30 7d 0a 7b 56 69 65 77 43 6f 6e 74 72 6f 6c 3a |0}.{ViewControl:|
00005000 31 30 30 3b 30 3b 31 3b 31 3b 30 3b 30 3b 30 3b |100;0;1;1;0;0;0;|
00005010 32 30 34 38 3b 30 3b 32 30 34 38 7d 0a 7b 43 75 |2048;0;2048}.{Cu|
00005020 72 72 65 6e 74 50 6f 73 69 74 69 6f 6e 3a 30 3b |rrentPosition:0;|
00005030 31 3b 30 3b 33 7d 0a 7d 0a |1;0;3}.}.|
00005039 
.