Notes on using Excel macros to view tobacco and lumber kiln logging data. 041111
 
Print out these notes.

Click on applicable *_Setup_... file to install macros.

The DCS Explorer can now be actively logging and there is no need to disconnect from the kilns.

Select any closed #########.log file in DCS_Logs and drag it OVER the "Log to CSV" icon on the desktop and drop it.
There will now exist files with CSV extensions, one for each kiln.
To view a single kiln: 
Double-click on the desired kiln_###.CSV file to start Excel.
Press Control-h to open HELP notes Tobacco_Excel_Notes.txt
Press Control-r to create one REPORT CHART -- scroll down to view.
Press Control-p to PRINT the first report CHART page.
Press Control-q to QUIT Excel back to Viewing.

To view ALL kilns: 

Double-click on ANY kiln_###.CSV file to start Excel.
Press Control-o to OPEN ALL CSV files in the current folder and to create ALL CHARTS -- this takes TWO full minutes for one hundred kilns.
Control-Shift-Tab to view the NEXT chart.
Press Control-Tab to view the PREVIOUS chart.
Press Control-p to PRINT the first report CHART page.
Press Control-q to QUIT Excel.

Any kiln_###.csv files in DCS_Logs can now be deleted as they will be recreated as needed by "Log to CSV".

Press Control-h to open HELP notes Tobacco_Excel_Notes.txt


Macro control summary:

Control-h opens these HELP notes Tobacco_Excel_Notes.txt
Control-o OPENS ALL CSV files in the current folder and creates ALL CHARTS
Control-p PRINTS the first report CHART page
Control-q QUITS Excel to Windows
Control-r creates one REPORT CHART
Control-Shift-Tab views NEXT chart created by Control-o
Control-Tab views PREVIOUS chart created by Control-o