![]() |
|
![]() |
How to export Temprecord data to a Spreadsheet |
How to edit Temprecord
data files for use in Seafood Spoilage predictor software (SSP). Go to the Options / Export menu
and select the following settings from the Options form. Open the File menu and click on Export. A dialog box will appear asking you where to store the ASCII TXT file you have created from your Temprecord data. Select the folder you want to store the ASCII file to. You can either accept the file name generated by Temprecord for Windows or type in your own at this point then click on the OK button to save the file. Open Excel then click on File / Open. From the open dialog select the folder your ASCII file is stored in and then from the File as type drop down list at the bottom of the dialog choose Text files. From the list of files select your ASCII file and click on the Open button. The Text Import Wizard will now appear on screen click on Next. Make sure the Tab checkbox is checked and click on Next. Make sure the General radio button is selected then click on Finish. All your temperature data will now be in column A starting from cell A1. The first thing to do is select and cut all of your data and paste it into the 6th row or cell A6 of the spreadsheet. From row 1 to row 5 enter the following text. The information you need from the logger can be found on the Summary page from Temprecord for Windows when your data file is the active file. In row 1 type - ASCII From row 6 and below is where your temperature data is placed in a single column. Click on File / Save As. Then from the Save as type box check that the file extension TEXT (Tab delimited)(*.txt) is selected. Select the folder named Program Files\Dfu\Seafood Spoilage Predictor and then click on Save. The file is now ready to be opened in SSP software. |
© 2010 Temprecord International Ltd |