曝光台 注意防骗
网曝天猫店富美金盛家居专营店坑蒙拐骗欺诈消费者
respect the author's copyright and quote the source...)
Exporting slide graphs
The slides can be exported:
- either to the clipboard, or
- to the RTF file c:\db_circs\pic_temp\db_slide.rtf, which contains a link to the *.wmf file.
(Hint: if you want to edit the picture in WinWord, make sure that your normal style in the picture
editor is set to NO space, i.e. 0 pts, before & after!)
Developer’s Corner
If you have some experience with spreadsheets, you can develop your own Dashboard in ten
minutes – there is a reasonably user-friendly interface to Excel. Here are the necessary steps:
Launch the Dashboard, and press F4. You will probably
see the Tutorial box – click “Do that” (you may exit the
tutor now, but then you have to press F4 again).
My1stDb.xls is the template that contains the necessary
structures for creating a Dashboard.
This box appears next. Since you are indeed doing this for
the first time, you must hold the Shift key while clicking
“Yes” – this tells the software to install the Excel Add-In
“CreateDB.xla”. This Add-In has its own “Dashboard”
toolbar and contains the Visual Basic macros for translating
an Excel spreadsheet to the Dashboard format.
A box might appear telling you how dangerous macros
are: click “Enable Macros”. Note that some system
administrators set high security standards – you may have
to ask them for permission to install the macros.
Afterwards, you should have a new Dashboard toolbar in Excel (if not, please
inform me). The colourful icon does the conversion, but try the others, too.
This is an excerpt of the template My1stDb.xls. Several
cells have a red triangle in the upper right corner; when
you move the mouse cursor over the cell, you will see a
help text telling you what these cells mean. Read in
particular the comment of cell D1 on the PARAS cell.
You may test the Dashboard creation now – just click into the icon .
After a while (i.e., half a second on a 700 Mhz Pentium), a new
Dashboard and this box will appear. Check your harddisk (e.g. with
Windows Explorer, although I prefer 2x): there will be a new folder
C:\db_circs\db_resrc\My1st_db (if C: was your installation drive).
Now, if you are ready for more ambitious exercises, I suggest the following steps:
Save the template under a different name (otherwise, installing a new version may overwrite
your work, and we want to avoid that, right?)
Rename the first sheet from db_My1st_db to db_YourName – your name must have three to
eight characters, and the “db_” must be in lowercase:
Enter your data: replace Austria and Zimbabwe with your countries or cities or whatever, put the
right indicator names etc.; you may have to adjust Codes=<NESI> in the PARAS cell, see the
comment of cell D1. For example, if you use a three cluster model with Nature, Economy,
Society, you need Codes=<NES>, and you need to adjust the IND_NO codes accordingly.
Fine tuning: Once you have created your Dashboard, you can adjust the position of indicator
legends, e.g. if they overlap too much. Hold control and right-click into an indicator to adjust the
position of the legend. Control Numpad +/- will increase/decrease the font size of this indicator,
pressing “M” toggles multi- and single-line display of legends (note: don’t use this for modified
sets, i.e. sets whose order of indicators differs from your Excel original; see also TxtW= below).
The rest should be straightforward, but do not hesitate to ask me for help; preferably by sending
me the spreadsheet, so that I can see what is the problem – confidentiality is guaranteed.
Edit Parameters
Apart from the spreadsheet, a developer can edit certain parameters for modifying the Dashboard
appearance. Normally, you do not need this, but playing with them is not harmful.
Move the mouse cursor into the upper right corner of the Dashboard; a
menu will appear. Click into “Export” to see a pop-up menu, inter alia
with “Edit parameters”. This will open the red dialog shown below,
which allows you to modify the parameters.
You may edit everything you find here, and test it by clicking on the
Test button. Make sure you like the result before clicking “Save”…
Introduce a new line, if necessary, by pressing Control Enter.
These parameter options yield useful results (note that all parameters are CASE-sensitive!):
TxtW=m 'Text weight: tiny, small, medium, large, xtra
FR: 'for the French version, find paras below this line
TxtW=s 'smaller text for FR (analogously: DE, IT, …)
中国航空网 www.aero.cn
航空翻译 www.aviation.cn
本文链接地址：
航空资料8(103)
