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

Managing Data and Saving Data Locally SMA Technologie AG
Technical Description SDC-TEN081450 95
11. Make the desired settings for the chart display.
• Start and End
the start and end (dates and times) of the interval, from which data is to be displayed. Take
care to choose a display interval which is not too large, as Excel can display a maximum of
4000 data sets in one chart.
• Increment
indicates the increment in rows, from which the measured values are to be taken. For example,
with "10 rows", only every tenth row of the measured values is included.
12. Click on . The chart is displayed.
11.8. 2 Manual Analysis
Manual analysis is only required if you wish to start the analysis on a PC on which Sunny Data
Control is not installed. How to start the analysis directly from Excel and manually execute the
analysis macro is described below.
1. Launch the program "Excel".
2. Open the file "Excel97\sdcmac.xls“.
By default, the file is situated in the directory "Programs\SMA\Sunny Data Control\Excel97“.
The data analysis macro is situated within this file. To guard against unintentional alterations,
this file is write-protected. If you wish to alter the macro, you must first remove the write-
protection (password: SMA).
Excel launches automatically, and a confirmation prompt opens.
3. 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.
4. Click on .