Setting Up Excel to Automatically Load Real-Time Radiation Data


At the bottom of this page is a snapshot of an automatically updated real time radiation data graph generated by Excel 2007. The data flow in the example was as follows: An RM-60 plugged into an LCD-90 with a Bluetooth adapter located in a remote location, wirelessly connected to a PC running Aw-Radw and Excel. Alternatively, the RM or PMI-30 can be directly plugged into the PC.

Aw-Radw setup as follows:

Step 1. Click menu item “Output Options’ – ‘ASCII Text File Options’ – ‘Select ASCII Filename’ and create ‘my-ascii.txt’ filename in a folder of your choice.

Step 2. Click menu item “Output Options’ – ‘ASCII Text File Options’ and then click to uncheck ‘Truncate ASCII File’. Next click to uncheck ‘Add ASCII Message Header’. Next click to uncheck ‘Add Settings Header’.

Step 3. Click menu item “Output Options’ – ‘ASCII Text File Options’ - ‘ASCII File Time Code’ and click ‘Excel – Lotus 123 Time Code’ then ‘OK’

Step 4. Click menu item “Output Options’ – ‘ASCII Text File Options’ - ‘ASCII Time and Value Order’ and click to check ‘Time then Value’.

Step 5. Click menu item “Output Options’ – ‘ASCII Text File Options’ - ‘ASCII Value Average’ and click to check ‘Write Every Point’.

Step 6. Click menu item “Output Options’ – ‘ASCII Text File Options’ - ‘ASCII Delimiter and Endline Character(s)’ and click to check ‘Tab Delimiter’ and ‘Carriage Return – Linefeed’.

Step 7. Begin collection of rad. data saving to the ASCII file my-ascii.txt.

Aw-Radw will remember all the above so next time you load it, settings will remain.

Excel setup as follows:

Step 1. Start Excel then click the top tab 'Data' then 'Get External Data' then 'From Text' and browse to select the file my-ascii.txt.

Step 2. Excel ‘Text Import Window’ pops up. Click ‘Next’ – ‘Next’ – ‘Finish’.

Step 3. Excel ‘Import Data’ box pops up and click ‘Properties’. ‘External Data Range Properties’ pops up. Click ‘Refresh Every’ then change ‘minutes’ to 2. Click ‘Prompt for file name on refresh’ to uncheck it. Click ‘OK’. ‘Import Data reappears and click ‘OK’.

Step 4. The data in the file my-ascii.txt appears in column A and B. Right click ‘A’. ‘Format Cells’ pops up and click ‘Date’ and choose one of the ‘Types’ then click ‘OK’.

At this point, every two minutes Excel will check the file my-ascii.txt and add any new data to column A and column B. Meanwhile Aw-Radw is adding new real-time data to the same file. If you save your new BOOK.xlsx it will include all the above so next time you load it into Excel all the Excel steps above are completed for you.

Now your task is to chart the data in column A and B (my-ascii.txt). Excel is somewhat non-intuitive as regards creating graphs, but once you create the graph as we did in the below example, the graph will automatically update as new data is automatically added to the spreadsheet. Once you create the graph to your liking, save the BOOK.xlsx and next time you load it, the real-time graph is recreated.


Auto Excel Graph

To return to previous page, use your browser's BACK button or click this button.

Return Index page?