|
Technical Resources
|
These instructions will guide you through the preparation of a theatre test report using the CTT feature of win|RTA and the D2. These
instructions will concentrate on the use of OpenOffice.org, an office suite that is a no-charge download. It can also be ordered on an inexpensive
cdrom. For more information, visit OpenOffice.org.
With the release of win|RTA V1.51, the text export of CTT files produces an output that is easier for spreadsheets to process.
After completing and saving a CTT test, export the data to TXT format by SHIFT-clicking on the disk icon.
Open the OpenDocument Spreadsheet Template CTT.OTS.
From the OpenOffice File Open menu, select "Files of the type:" and choose Text CSV (*.csv, *.txt). Then select the TXT export
file that you created from your CTT test file. Click on *space* delimiter when prompted. You should see the entire data file in an opened
spreadsheet starting at cell A1.
Now select all the data in the CTT data spreadsheet. You can do this by clicking on the square to the left of the "A" column heading and
directly above the "1" row label. The select Edit->Copy.
Switch to the CTT template and click on the Data tab. Click on the A1 cell and paste the contents by electing Edit->Paste. After the data
has processed, switch to the Charts sheet. Here you can make final adjustments to the report.
The Location, Company, Operator, Date, and Comments fields are automatically filled. Using the spreadsheet features, these fields can be
cleaned up. For example, select the operator information, located in cells B3 through D3. If you entered two names, a first and a last, the third
field will have a "0". Delete this. Then select cells B3 & B4. Select Format->Merge Cells. Follow a similar procedure for the other nearby
data fields. Some of the charts may not have data. These can be deleted and the other charts reorganized.
With OpenOffice.org, you can export the data as a PDF file. First, determine which page numbers are to be exported by selecting File->Print Preview.
Note the page numbers at the bottom left of the page. Because of the large amount of data and calculations, there will be many pages. The report will
probably start around page 292 and end around page 297. Now click "Close Preview" and File->Export as PDF. Enter the name for the report, and click Save.
On the next page, PDF OPtions, Click on "Pages" and enter the range, e.g. 292-297. Then click Export, and the file will be created.
You can make changes to this template and save it for your own use. There are certainly things that can be improved and graphics added to show the
company, testing organization, etc. More elaborate macros can also be created to reduce the amount of hand-editing necessary.
|
|
|
