SMA Sunny Data Control V.5.0 - Manual (Page 91)

Managing Data and Saving Data Locally SMA Technologie AG
Technical Description SDC-TEN081450 93
11.8. 1 Automatic Analysis
The automatic analysis is started in Sunny Data Control. Excel opens automatically with the macro
which has been specially written for the analysis.
1. Click on the "Show" icon.
The submenu opens.
2. Select "Excel files", or the CSV type which you have created for saving CSV files (see section
11. 3 "Saving Data in CSV Format" (Page 71)).
The window for choosing the data opens.
3. Select the desired plant. By default, the current plant is always displayed.
4. Open the directory of the chosen device.
5. Open the Excel file which contains the data that you wish to analyze.
Excel launches automatically, and a confirmation prompt opens.
The data analysis macro is situated in the file "Excel97\sdcmac.xls" in the Sunny Data Control
directory on your PC. Only if you activate the macro, data analysis can be performed.
6. Add a check mark to the left of "Always trust macros from this source". This check mark causes
the data analysis macro to be activated automatically every time Excel is opened via Sunny
Data Control.
7. Click on .