beautypg.com

2 manual analysis – SMA Sunny Data Control V.4.2 User Manual

Page 125

background image

SMA

Technologie AG

Managing Data and Saving Data Locally

User Manual

SDC-TEN080642

Page 125

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 Con-
trol\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 (see figure be-
low).

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 Ex-
cel is opened via Sunny Data Control.

4.

Click on .