Home

ADP Advanced Data Processing V4.0 User`s manual

1. PdmFinder Demo Project lel Es File Edit View Help Report Series Point Advanced Find Report Name Find Series Find Point 3 PdmExplorer Demo Project File Edit View Tools Help fear rf Te E Repons AXE eK el l E W demo_e TA Resolution 7 Time Span Stop New Search ii mL Gf Configuration AB Air temperature outside i f Design File uality Attribute DataPoints gE Atrium temperature average 1 ank Quality A E DataSeries Filters E Automation E Reports Name In Folder Display Resolution Time Span Desic Transfer FEl Air temperature outside ADP Reports Te Trend 1 Hour 3 Day ADP Reparts PCM SDP Aeports Te Table 10 Min 3Day 2700 I Sidi Consumption FEl Atrium temperature average ADP Reports Te Table 10 Min 3Day xt01 a B arate FEl Atrium temperature 2nd floor ADP Reports Te Table 10 Min 3Day 2700 i Fl Atrium temperature 5th floor ADP Reports Te Trend 10Min 3 Day E ir temperature outside El Atrium temperature averag FEl Atrium temperatures l ADP Reports Te Trend 10Min 3 Day El Atrium temperature averac FE energy consumption of are ADP Reports Ene Table 1 Day 1Week 4C00 JE Atrium temperature 2nd floc FEEL energy consumption of are ADP Reports Ene Table 1 Day 1 Month CO1 M 9 Atrium temperature 5th floor 19 objec
2. SR ee A OR FS ee a ee OT ha Temperature values from 18 10 96 00 00 until 20 10 96 23 50 Atrium temperature Sth floor nN i Temperature Deg C g Date and Time Ready Sum 0 NUM 8701028 Presentation tab of the Excel design file For internal use only Advanced Data Processing V4 0 CM2B8705en_01 Excel display V7 0E 8 0E 01 09 2006 97 104 Siemens Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation Excel display V7 0E 8 0E 01 09 2006 ADP Advanced Data Processing ADP report ADP report template Resolution Auto Task Report data series 98 104 Building Technologies Building Automation 11 Glossary PROGRAM TO EDIT AND PRESENT ANY PROCESS DATA ADP as a program primarily focuses on displaying process data in meaningful presentations Use ADP for the following e Define ADP reports e Display ADP reports e Quickly and easily analyze data REPORT BASED ON REFERENCES TO THE DATA SERIES The ADP report It does not contain current data lists or graphics e Assign the data series to the ADP report in the order in which you want to display them on screen e The same data series can appear several times in an ADP report e g with different date ranges e A report may also contain data series used for internal calculations in reports only and not displayed in ADP reports The data series values are retrieved
3. 20 104 For internal use only Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation Basics you should know 01 09 2006 3 3 ADP objects ADP uses the following objects For better recognition they are always displayed together with a symbol Referenced data series ito mini31 i mini33 i mini32 at mini34 ADP reports ic_beri mini35 min40 b Recorded report data series Data series referenced in an ADP report Calculated report data series Data series referenced in an ADP report Constant report data series Data series referenced in an ADP report Invisible report data series This data series is used only for internal calculations in reports and is not visible ADP report ADP report Open Link to ADP report shortcut PDM allows you to create shortcuts to reports and data points and data series These shortcuts are marked by a small arrow similar to Windows ADP report write protected Access level 5 allows you to save and write protect ADP reports However as soon as you copy a write protected report write protection no longer applies and the standard symbols for ADP reports are again displayed ADP report template ADP reports with at least one local filter ic_beriVor ia ADP report template ic_beriVoro Open i a Local filter as Contains preset search criteria for data series A local filter as opposed to a global filter
4. 8 OK The design file is saved and is now available to other reports 75 104 Siemens Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation Table display 01 09 2006 76 104 For internal use only Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation Table display 01 09 2006 Siemens Building Technologies Building Automation 9 Trend display 9 1 The most important features at a glance Fil Diagram Series l 17 um seed 16 18 Mikel E3 es oe A eC a oe 9 e Atrium temperature 6th floor ee as a ee eT sy oe a rl a lt Atrium temperature 2nd floo a i ea a O S ee 2 ee 00 00 00 12 00 00 00 00 00 12 00 00 00 00 00 12 00 00 00 00 00 8 10 96 19 10 96 20 10 96 21 10 96 00 00 00 DA 00 00 00 18 10 96 8 3 Days 00 00 00 Tois LULLUN 9 8 21 10 96 lt Atrium rempe 10 2 nd floor lt a Atrium temperature 5th floor gt Outside teri lire 12 eady com QualAtt 4 Read Zoom Qual A 8701001 The TREND window Trend window mouse button functions No Name Left mouse button Right mouse button 1 Graph drag zoom Q Diagram menu 2 Curves ee Popup time value of the amp Curve menu item last point 3 Primary y axis Diagram menu 4 Secondary y axis XQ Diagram menu 5 Data series name XQ Diagram menu 6 X axis time stamp Time stamp on if active indication of value
5. Method B2 Step by step procedure Note 32 104 Building Technologies Building Automation In the calendar 3 Click OK The desired ADP report is displayed on screen Start several reports at the same time When you open the left part of the PdmExplorer instead of an ADP report in the report folder the right part lists all associated ADP reports This list allows you to select multiple ADP reports and start them via Run Direct start via double click Left part of the PdmExplorer 1 Double click the desired ADP report Direct start with predefined values via the context menu Left part of the PdmExplorer 1 Right click the desired ADP report In the context menu 2 Click RUN The program immediately starts the ADP report and includes all predefined settings for the time span set via e TOOLS OPTIONS RUN DEFAULTS tab Options General Wwamings Defaults Fun Defaults Time Span Shown Used for Aur on Report Only Current or cae Complete de ET Sliding ll ese Direct ae sd Stop z Date dd mm ypyy Time hh mm Use nn for NOW Dialog Run Report Stop Date Favorites Database I 8701043 Options Run Default tab Reports started via the context menu RUN RUN or via double click or via the desktop shortcut are always displayed on screen For internal use only Advanced Data Processing V4 0 CM2B8705en_01 Compose and start ADP reports 01 09 2
6. the font of any one of the captions e Double click amp the corresponding line or select the line then select Font amp the standard Windows dialog box for font types opens _ e Select both font type and size standard Windows functionality Note Use only TrueType font types All other font types may produce unwanted effects in Trend For internal use only 90 104 Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 01 09 2006 Building Automation Trend display Siemens Building Technologies Building Automation maa Me Ff y we E LT f i 9 4 Save Trend design properties 9 4 1 Procedure Newly defining the same design properties multiple use does not make sense You can therefore save the design properties as follows e Select Save Properties As from the Trend File menu e Select a file name in the Save Design File window Important 1 All design files must have a trd extension 2 When naming files please observe the recommendations located in chapter Basics on Reports and Design Store Trend properties Save in E Adp32 Es a o brien trd File name Save az type Trend property files trd Cancel 8701016 The Store Trend Properties window 9 4 2 Assign saved design properties to a report You cannot directly reuse a Trend design from the Trend dialog box The saved design properties must be selected when defining a report by indicating the
7. Caution Loss of dat Users with access level 2 or higher may change or delete data When you see the symbol to the left data may be lost irretrievably Practical hints The symbol to the left denotes information that helps you properly operate and use the programs This information is based on experience we strongly suggest that you observe all hints p L i N Important notes Important information is printed on a gray background 14 104 For internal use only Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation About this document 01 09 2006 Keyboard keys Names for dialog boxes and fields Input in fields Windows buttons Menu names and items Instructions Mouse click Context menus Date and time format Important YE Siemens Building Technologies Building Automation 2 6 2 Typographical conventions For button and field names as well as short descriptions of functions or repetitive processes the following conventions apply throughout this user s guide Keyboard keys are always printed in angle brackets lt gt Example lt Shift gt lt Shift N gt Names of dialog boxes and fields in Windows are italicized Example In the Definitions dialog box When prompted to type in a value in a field the following short description is used Example Type in the name of the data series in the Series field Example Type 13 in the Series field Keyboard entries are al
8. Configuration type Data point configuration type according to the selected system Address Address used to reference the data point Description Data point designation 51 104 Siemens Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation ADP object properties 01 09 2006 Current Complete Sliding Direct Action 52 104 6 6 Job properties 6 6 1 Job tab Note Entries in this tab apply only to jobs and not to manual ADP reports There is no relationship to the values set via Tools Options Run Default tab PDH Property Sheet Job Advanced f Job 3C2 Type Job Created Modified 25 02 99 19 12 55 By used Time Span Shown based on each Report Default Time Span Complete __ a Sliding Direct Shark A a am En Water dd mm syyy Time Ahmm Wee Sar tar tm Actor Print Or kdefaukt printer Description 8701062 Job properties Job tab The ADP report includes the current not yet completed date and time range The ADP report includes the previous completed date and time span The ADP report includes the time span for one day one week etc until the exact current time The ADP report includes all data between both the indicated start date and the stop date Note On entering time information day month year hours and minutes can be replaced by entering nn or nnnn for year In this case the corresponding element is saved wit
9. Menu TASKS ADD AutoTask opens the New Task dialog box 33 104 Advanced Data Processing V4 0 CM2B8705en_01 Compose and start ADP reports 01 09 2006 In the New Task dialog box Command Line field 8 Paste CTRL V Copies the clipboard contents or the Target field content to the Command Line field Important At the end of the Command Line field insert a space followed by ma Example C PDM ADP ADP32 PdmRunnerClient exe S YIZV U dAA P sjv J Hi gt at EUAAUh 70 a0v7 aO_AES 6 ixj0 ZzIQUd2 af QVC Pwi amp y TS 2 ma In the New Task dialog box 9 Schedule AutoTask opens the Task Schedule dialog box In the Task Schedule dialog box 10 Program the task s trigger time Note Execute ADP reports only after data loading has been started ADP report execution is delayed automatically until data loading is complete Delays occur only if ma was added to the Command Line Auto Task All automated processes are started via Auto Task Refer to the PDM user s guide CM28733en for a description of Auto Task 34 104 For internal use only Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation Compose and start ADP reports 01 09 2006 Topics not covered in this chapter Tip AF ye Note AF 5 Compose and start jobs The following structure applies to this chapter e Step by step instructions only e Refer to ADP object properties for detailed information o
10. are displayed in a black outline 87 104 Advanced Data Processing V4 0 Trend display CM2B8705en_01 01 09 2006 Connecting Lines Color Multiple Shapes 3D line thickness Chart properties Scale tab Main and secondary Y axis X axis Minimum Maximum Axis factor Decimals Automatic fixed Show Zero axis Linear logarithmic 88 104 Building Technologies Building Automation a E Use this option to specify if the individual points of a data series are to be connected by lines Note the following Important You must always select this option to display curves If cleared only individual points are visible nothing at all after zooming If in addition Point markers is cleared the Trend display section is blank Select the series color to display the previously selected data series 3D display only Allows you to specify if the 3D line thickness is to apply to all data series or only to the currently selected one 3D display only The slider allows you to change the width of the curve bands in the 3D display Chart properties The Scale tab allows you to make the following settings e Change allocation to either y axis 1 or 2 Main axis Secondary axis e Minimum Manr axis Minimum 75 00 Maximum 35 e Maximum Seale unit 1 0 Decimals f e Scale unit Increment gap e Decimals Fined fo O Automatic e Automatic Fixed y axis calibration T Show Z
11. is valid only within the report template 21 104 Siemens Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation Basics you should know 01 09 2006 3 4 Programs PdmExplorer The PdmExplorer is the main user interface for PDM and ADP PdmFinder The PdmFinder allows you to carry out targeted searches for data points data series and ADP reports You can start the PdmFinder parallel to the PdmExplorer and keep it open in the background to run searches at any time Auto Task The Auto Task program allows you to automate the following e Upload data from the database e Compress PDM data e Archive PDM data e Start ADP jobs i e print and save ADP reports 22 104 For internal use only Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation Basics you should know 01 09 2006 Topics not covered in this chapter Tip Necessary steps When Siemens Building Technologies Building Automation a 4 Compose and start ADP reports The following structure applies to this chapter e Step by step instructions only e Refer to ADP object properties for detailed information on what to enter in the individual text and option fields Use context sensitive online help for your daily tasks right click or press F1 for the desired text or option field The information provided is largely identical to that in ADP object properties 4 1 Howto create an ADP report P
12. 09 2006 ADP stands for ADP strengths Siemens Building Technologies Building Automation 1 What is ADP Advanced Data Processing ADP an data evaluation and reporting program dguarantees gap free processing and presentation of all operating data High availability and optimal use of data from building automation plants is very important To achieve this goal ADP fulfils one basic requirement ADP generates meaningful reports from data which is stored in the PDM database in any combination and in selectable time spans These reports can then be displayed and printed in various forms Example for a comparison of temperature curves J D07 i _ i I I I I I I Temperatr Poy lips ig 10 260 0000 ile Otm und Zet 8704030 Example for an ADP report ADP as a program primarily focuses on displaying any process data in meaningful presentations e ADP allows you to analyze weaknesses in your operation and supervise and evaluate corresponding optimization measures This allows for efficient and transparent building operations e Visualization of process data via graphical illustrations or tables as well as a combination of both ADP provides an integrated spreadsheet program Additionally you can export data to MS Excel for further editing e Proof of adherence to required operating states laws on emissions manufacturing conditions e Long t
13. 4CPwj amp y TS 2 ma In the New Task dialog box 9 Schedule AutoTask opens the Task Schedule dialog box In the Task Schedule dialog box 10 Program the task s trigger time Execute jobs only after data is being loading Job execution is delayed automatically until data loading is finished Delays occur only if ma was added to the Command Line All automated processes are started via Auto Task Refer to the PDM user s guide CM28733en for a description of Auto Task For internal use only Advanced Data Processing V4 0 CM2B8705en_01 Compose and start jobs 01 09 2006 Use online help Refresher Siemens Building Technologies Building Automation 6 ADP object properties For your daily tasks use the context sensitive online help Right click or press F1 on the desired text or option field The online help information largely matches the information provided in this chapter 6 1 How to find the properties The following applies to all ADP objects e Point to the desired object and right click to open the context menu e On the context menu select PROPERTIES PJ PdmE xplorer Winter98 Internal IMA Project File Edit View Tools Help J zl X E E E T demo Report Series Name Series Name Type Offset ji Ti soils bagi o Atrium temperature 2nd floor Atrium temperatu Recorded None K ila ats Bo Atrium temperature 5th floor Atrium temperat
14. Excel display V7 0E 8 0E 01 09 2006 Design file step by step instructions Siemens Building Technologies Building Automation 10 3 Create an Excel design file General procedures to create an Excel design file are similar to the procedures for creating the corresponding files in Formula One 1 Create a new workbook with at least two worksheets the ast worksheet for raw data the first worksheet for graphical implementation 2 Save the new workbook under the name referenced by DefMakro32 or MyMacro e Open the report with real data or at least simulated data e When opening the report the data in the Raw Data worksheet looks as follows X Microsoft Excel XT001 File Edit View Insert Format Tools Data Window Help 5 x Diela alal ees zlo zla gly gjela zgh A 4 Excel 5 0 IAI Sampling A10 67985 GRA 014042 Recorded Visonik Atrium terr Qual Attr 35356 0 M2 35356 01 18 9 5 m3 35356 01 18 85 0 35356 02 18 8 0 m5 35356 03 18 7 0 46 35356 03 18 5 0 35356 04 18 6 0 48 35356 05 18 6 0 9 35356 06 18 5 0 20 35356 06 18 45 0 124 35356 07 18 45 5 22 35356 08 18 3 0 23 35356 08 18 25 0 35356 09 18 3 0 B25 35356 1 18 15 0 26 35356 1 18 15 5 35356 11 18 2 0 28 35356 12 18 2 5 29 35356 13 18 2 5 30 35356 13 18 2 5 31 35356 14 18 1 0 32 35356 15 18 1 0 33 35356 15 18 05 0 af af gt gt i Presentation r Calculated Data Calc
15. Quality attribute The quality attribute provides information on both generation and reliability of the respective value An entry may have several quality attributes PDM sets the following values 0 OK Value inserted via the PDM tool DataEdit Value corrected via the PDM tool DataEdit i The processed interval contained at least one bad value Value imported from the archive n Data gap PDM fills in 0 to eliminate the gap VISONIK and DESIGO INSIGHT set the following values 3 Manual entry Limit under overflow No event Out of service No value available Hardware problem O NOOU A Combined QAs Quality attributes can be combined For example QA 5 no event and QA 8 hardware problem DataEdit displays this entry as QA 58 Note Multi digit QAs always represent combined QAs Unreliable values The PDM database does not use unreliable values for internal calculations e g compress calculated data series unless specified explicitly These values are replaced by the last known good value If no good value is available 0 is used instead The following values are considered unreliable Values with quality attributes 6 7 8 or n But not if they occur in combination with the quality attributes I the processed interval contained at least one bad value I The value was corrected via the PDM tool DataEdit Note MS2000 TS1500 and UNIGYR do not have quality attributes
16. Yes No 49 104 Building Automation ADP object properties 01 09 2006 6 5 3 Series tab PDH Property Sheet Report Entry Report Series Point Hame PO Type fo Function Poo Interval P Parameter o Lirit o Storage D avs HZ coos e 8701060 Local filter properties Series tab Search mask for data series Name Data series name including the wildcards and Type Data series type Recorded Calculated Constant Logical Compression function Type of data compression No compression Mean Minimum Maximum Sampling Difference Sum Interval Interval at which a compressed value has been calculated and saved in the database e g 1 hour Parameters Point parameter whose value is saved in the data series Unit Physical unit of the point parameter Storage time Number of days over which data of a data series is saved in the PDM database 50 104 For internal use only Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation ADP object properties 01 09 2006 6 5 4 Pointtab PDH Property Sheet Report Entry Report Series Point Name PO System Type Po Address PO Descriptio P aa e 8701061 Local filter properties Point tab Search mask for data points Name Data point name including the wildcards and System System responsible for acquiring the data point DESIGO INSIGHT external MS2000 TS1500 UNIGYR VISONIK
17. above created design file Refer to chapter Generate reports templates for more detailed information 91 104 Advanced Data Processing V4 0 CM2B8705en_01 Trend display 01 09 2006 10 Excel display v7 0E s 0E The procedure described in the following sections refers to the external Microsoft Excel spreadsheet program in English versions 7 Office 95 and Excel 8 Office 97 ae However as only experienced Excel users should create macros we have restricted our instructions to just the most important information Please refer to your Excel documentation for further information on Excel Remember to observe all general notes regarding Excel design in the chapter Report and design Basics The DEMO database contains various reports for Excel Use these reports for your work 10 1 Excel macro and Excel design file This version 2 x of ADP uses three different design macros as opposed to the earlier user defined macro RunMacro e ShowMacro e PrintMacro e SaveMacro These macros allow you to create different on screen and print designs for the same report Furthermore you can automatically save the currently generated report The table below shows the relationship between the three Excel design macros and the program processes Display Display amp Print Display amp Save E Start open Microsoft Excel Start open Microsoft Excel Start open Microsoft Excel Indicate file xls Use ShowMacro Use ShowMacr
18. display is better suited for 2D black amp white printing Only effective in 3D displays if 3D Cluster is selected This slider allows you to specify the width for the curve bands This has no influence on the z axis depth The Series tab allows for the following settings e Multiple Types Seres meu emp Type aD Line s Shape Multiple Types Seres Color m Point markers I Multiple Shapes 30 Line thick 3 e Point markers e Show Values e Borders T Show Values Connecting Lines T Borders e Multiple Shapes e 3D Line thick i Connecting Lines Click Diagram Chart Properties and then Series to open this tab Cancel Apply 8701011 Chart properties Series tab Select the data series to which you want to apply the data series specific settings Allows you to specify if the type properties should apply to just the currently selected data series or to all data series in the current report Allows you to specify if the individual data points should have the point types and sizes as set in the General tab Meaningful only if Point markers is selected Allows you to specify if you want to display the value for each point that you display Do not use this setting for larger sections e g full view as individual values may overlap 3D display only If you select this option e the data series bands and e the acquisition times of the data
19. filter entry Use Report templates are a comfortable means to quickly create new ADP reports with similar designs As the report template specifies the design you only need to assign the respective data series 3 2 Report properties e Type of display e Time resolution used to display data in a report e Time span in days weeks etc for which you intend to display data in a report We provide four basic types of display to create reports each offering specific advantages and disadvantages with regard to design List The data is listed in a table display Design efforts are minimal Trend Allows you to display curves without spending much time on design You can easily adjust the design to special information needs even after retrieving the report Hint To quickly and easily analyze a data series drag and drop it in the Trend window Table Do not use this display for new projects as it will not be supported in the future Use Excel rather than Table Table allows for arranging values in tables and display them as desired Use Formula One the program supplied with ADP that resembles Excel to create the reports 17 104 Advanced Data Processing V4 0 CM2B8705en_01 Basics you should know 01 09 2006 Resolution Time Span Shown Example 18 104 Excel Linking a report to Microsoft Excel 7 0 or later is intended primarily for experts Excel provides interesting statistical functions that can also be used
20. for other purposes Metafile fields appears These three fields allow you to copy session or screen data to eT 7 the clipboard 8701003a Function Format Data Copies all data series of a session to the RTF compatible clipboard with Microsoft Excel Bitmap Copies the Trend screen contents to the bmp Windows clipboard bitmap format Meta File Copies the window contents to the clipboard bmp Windows metafile format 84 104 For internal use only Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation Trend display 01 09 2006 Normal H 30 Data Autoscale a Quality Attribute Steplines Zoom 8701003b What is normal Everything is two dimensional What about 3D Show numbers only How to adjust the scales to the y axis X axis labeling Quality attributes Active or inactive Step or ramp How to view the entire report time span Where to assign colors Palette Bar Pattern Bar 8701003c Where to assign patterns How to assign both color and or pattern 9 8701009 Is there a detailed legend on curves Siemens Building Technologies Building Automation The options as shown to the left represent the basic set of options to design a Trend window They allow you to easily and quickly change the basic display properties Please note the following Note e Click to switch on the desired option Important Certain options are on off only e Active options a
21. for the selected data series are displayed in the report according to the individual time stamp Faulty values marked by an associated quality attribute in the data series to be displayed can be hidden The corresponding curve then has gap The following applies to the evaluation types List and Table All values for the selected data series are displayed in one report row each according to their time stamps one row per different time stamp For internal use only Advanced Data Processing V4 0 CM2B8705en_01 Mapping data series to the time period of report 01 09 2006 Siemens Building Technologies Building Automation Note When displaying multiple data series per report row a value is displayed for each data series even if a data series does not have time stamp data for the row Remember this when interpreting a report 7 2 2 Report with predefined resolution lf data series values whose compression interval does not match the predefined report interval resolution are displayed in a report the values are mapped as per the following rules to the report resolution This time adjustment only applies to report display The real values and time stamps are not changed in the database For compatibility reasons e g to VISONIK determination of the values to be displayed depends on the respective type of compression for the data series The following applies to all types of compression e Ifa value of the data series to be di
22. new Recorded Data Series Planea araor Cats fox tvs PON F Baoke Function None v Display Trend X Interval None Resolution Noe H Parameter Reading o Unit Oo Storage Days 939 Description Po Lime Span as Week Design File m Quality Attribute I Description cee 8734092en 8734093en lt Back Cancel _ Report display The time stamps for the values are displayed in the report as saved in the database There is no shift Mio Mis MOE MOS 8734j94 Display without report resolution For internal use only Advanced Data Processing V4 0 CM2B8705en_01 Mapping data series to the time period of report 01 09 2006 Siemens Building Technologies Building Automation 7 3 1 2 With predefined report resolution A data series without function and interval is displayed in a report with predefined resolution The data series and the report are defined as follows Data series definition Report definition Please enter data for the new Report Function None 2 Display Trend Ne Interval None 7 Resolution y Paramete Reading o f Unit PO Storage Days 939 Description Po a Time Sparc 1 Week x Z Eel E Quality Attribute T Description cosi E A 8734088en 8734096en In the example several spontaneous values are available within the resolution interval Even though the report was defined by using a predefined resolution onl
23. points to an unreliable value You can locate this value including QA by activating the time stamp 6 e Trend does not allow you to display more than 10 data series and not more than 10 000 values per data series 80 104 For internal use only Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation Trend display 01 09 2006 Save Properties As Load Properties Save Properties Default Properties Print Important information for the following sections Atrium temperature Sth floor Time 22 20 00 Date 18 10 96 8701005 Siemens Building Technologies Building Automation 9 2 Standard operating functions 9 2 1 File menu When you open the Trend window for the first time the Save Properties and Save Properties As buttons have no meaning They become important only after you change the window settings e g when you change the background color or the font You can save these changes for later use This button allows you to save settings under a new name and retrieve them later via Load Properties Allows you to retrieve earlier saved settings at any time The window settings are then adjusted to the loaded properties Use to save a previously loaded Trend design file changed during the active session Drop down list box with Load from tab file and Save to tab file Use this drop down list box if e Other default settings are active and you want to load the settings from
24. so helps us further optimize our products Our address Siemens Switzerland Ltd Building Technologies Group International Headquarters Building Automation Common Support Entry 5500 Gubelstrasse 22 CH 6301 Zug Phone 41 41 724 5500 Fax 41 41 724 5501 E mail fieldsupport zug ch sbt siemens com web www sbt siemens com 11 104 Siemens Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation About this document 01 09 2006 2 4 Document structure This user s guide combines both instructions and reference material The structure is oriented to typical workflows for initial setup of ADP The document structure thus is as follows Introduction Chapter 1 What is ADP Chapter 2 About this document Basics Chapter3 Basics you should know Operation Chapter 4 Compose and start ADP reports Chapter5 Compose and start jobs Chapter6 ADP object properties Display reports Chapter 7 Mapping data series to the time period of report Chapter8 Table display Chapter9 Trend display Chapter 10 Excel display V 7 0E 8 0E Terms Chapter 11 Glossary Referenced documents To easily locate specific information the following are available at the end of this document e Summary of all terms and definitions e Index 12 104 For internal use only Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation About this document 01 09 2006 Context sensitive help Step by step procedure Help on individual
25. starts the job and includes all predefined settings with regard to display time span and output medium under e Context menu PROPERTIES JOB and ADVANCED tabs 41 104 Advanced Data Processing V4 0 CM2B8705en_01 Compose and start jobs 01 09 2006 Method C Step by step procedure Note Auto Task 42 104 Building Technologies Building Automation Automatic start via Auto Task For this type of start add the corresponding job to the Auto Task list Left part of the PdmExplorer 1 Right click the desired job In the context menu 2 Click CREATE SHORTCUT ON DESKTOP Windows now creates a shortcut on the desktop for the associated job On the desktop 3 Right click the shortcut Windows opens the shortcut s context menu In the context menu 4 Click PROPERTIES SHORTCUT tab In the Properties dialog box Shortcut tab 5 Copy CTRL C To do this select the whole contents of the Target field In the PdmExplorer 6 Menu Tools AUTOTASK PDM starts AutoTask In Auto Task 7 Menu TASKS ADD AutoTask opens the New Task dialog box In the New Task dialog box Command Line field 8 Paste CTRL V Copies the clipboard contents or the Target field content to the Command Line field Important At the end of the Command Line field insert a space followed by ma Example C PDM ADP ADP32 PdmRunnerClient exe S YIZV U dAA P sjv J Hi gt at EUAAUh 70 a0v AO_AES 6 ixjU ZziIQUd2 af QV
26. the tab file to the current session e You have changed the settings and want to save the new settings as the default settings to the tab file Print Print Preview Printer Setup and Exit Windows functionality Remember the basic functions of the mouse buttons e Q right clicking an element object opens the menu items for the associated object context menu e left clicking opens a standard menu featuring Windows functionality as well as various functions not available from the menus 9 2 2 Retrieve detailed information on any point of a curve If you require more information on any point on the curve do the following e Curve at any point amp amp A window appears with the present value time and value When between two points the data from the prior point is displayed e Curve Z The Curve context menu opens e Within a graph amp The Diagram context menu opens 81 104 CM2B8705en_01 01 09 2006 Advanced Data Processing V4 0 Trend display 07 41 53 on nei 8701006 Primary Axis Secondary Asis 8701004b Alternative procedure Visible Curve Mame 8701004c Alternative procedure 82 104 Building Technologies Building Automation a x 9 2 3 Display detailed information for a specific point in time If you want to display an exact point in time for a specific event on a curve e Move the mouse pointer below the diagram to the point in time you want to display e A
27. to enlarge You can assign colors to the following elements e x y axes caption e Graphics background e Each curve data series in 2D or 3D mode You can assign patterns to the following elements e Each curve data series in 2D or 3D mode You can assign both color and pattern to the following elements as follows e Move the mouse pointer to a color or pattern field e Permanently click the field to the left e Move the mouse pointer a tilted color bucket to the desired element and release the left mouse button Yes by amp on Legends The bar at the lower bottom of the graphic indicates the following parameters e Name of the curve name of the report data series e Assignment of colors to the associated curves e Allocation of the y axis e Additional indication of the exact curve value for function Vertical with time stamp 85 104 Advanced Data Processing V4 0 Trend display CM2B8705en_01 01 09 2006 Introduction Chart Properties Font Properties 8701003d Impact of the changes Make changes or not Chart properties General tab Grid Lines Color Scheme Sy L LZ a E Color without pattern Black white pattern Color pattern 86 104 9 3 2 Enhanced design properties Use Chart Properties and Font Properties to design the Trend window s graphic display You can save and load the properties In order to open the associated menus click Diagram then click Chart
28. value included in the definition of the date range applied to report data display This corrective value can be e Relative to the start time e g Offset 2 years e Absolute for a specific year e g Offset 1996 In this case select Reference year as the unit Validity The offset entered for a data series only applies to the local report Application example Assumption A data series contains monthly values for multiple years The time span is 1 year and the resolution in the report is 1 month Offset If the data series is added three times to a report but each time with a different offset e g offset 2 years 1 year and 0 years the data of this data series can be displayed in neighboring columns shifted by one year SSA Sale 2Years 1 Year 199 31 30 2g April 240 280 8701033 Offset Example for a data series EE ES EEA A Po mo oo 5 You can suppress the report data series when you output the ADP report This may be meaningful for example when a data series is referenced only by a formula Validity Suppression of the data series applies only to the associated report 6 4 2 Series and Point tabs The information on the Series and Point tabs are for information only and cannot be changed 47 104 Advanced Data Processing V4 0 CM2B8705en_01 ADP object properties 01 09 2006 6 5 Local filter properties Refresher A filter comprises preset search criteria to fin
29. 006 Note Method C Step by step procedure Siemens Building Technologies Building Automation Method B3 Step by step procedure Direct start with predefined values via the desktop shortcut Left part of the PdmExplorer 1 Right click the desired ADP report In the context menu 2 Click CREATE SHORTCUT ON DESKTOP in the context menu Windows now creates a shortcut on the desktop pointing to the ADP report On the desktop 3 Double click the shortcut nH El energy consumpti The program immediately starts the ADP report and includes all predefined settings for the time span set via e TOOLS OPTIONS RUN DEFAULTS tab Reports started via the context menu RUN RUN or via double click or via the desktop shortcut are always displayed on screen Automatic start via Auto Task For this type of start add the corresponding ADP report to the Auto Task list Left part of the PdmExplorer 1 Right click the desired ADP report In the context menu 2 Click CREATE SHORTCUT ON DESKTOP Windows now creates a shortcut on the desktop pointing to the ADP report On the desktop 3 Right click the shortcut Windows opens the shortcut s context menu In the context menu 4 Click PROPERTIES SHORTCUT tab In the Properties dialog box Shortcut tab 5 Copy CTRL C To do this select the whole contents of the Target field In the PdmExplorer 6 Menu Tools AUTOTASK PDM starts AutoTask In Auto Task 7
30. 72 104 For internal use only Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation Table display 01 09 2006 Show title Siemens Building Technologies Building Automation In the Options dialog box 8 Enter the data you want to insert in the graphic Syntax Name of the series containing the raw data Calc for our example Exclamation mark First cell of the range to be graphically displayed A1 for our example Colon Last cell of the range to be graphically displayed D32 for our example 9 OK The data is graphically displayed within the set range Graphic outline F Formula One Workbook Designer File Edit View Data Sheet Format Object Help Diek tee e 2 a J NOLO Olele A B c D E F G H I J K Lal o 2 3 O4 5 6 25 7 20 9 15 10 11 10 12 13 5 14 15 OTe lel lel lel el lel lel la lel lel lel lal lal lal al Io 16 2 lS Ie S Ie e IS IS IS e 1 9 9 12 17 Ol G G G G GO GO GO GO 6O 6O 5 5 S9 Ga oe O W iw iw ie b a a Kaj 18 D I Il eA lel e lel lee lee A A a al D al A 19 b t uouo noala alob 20 o o 9 QO Q 89 Q QO Q QO 8 380 090 42 0 9 21 5 2 S amp S 2 FE f kRkAT NBS F 22 7 Y 4 4 gt Graph Cale A Data For Help press F1 NUM 8673084 Graphic outline 8 2 4 Step 4 Optimize the graphic Sh
31. 87340A2 87340A3 Report display In the report the values to be displayed are moved to the start point of the current resolution interval i e to the left Among multiple values the value closest to the interval limit is displayed If values are missing the first known good value after the start time of the resolution interval is used Misi pt MS f es TA MIs 4 ild p ele Interval ele Interval el Interval el Interval n t 8734jA4 For internal use only Advanced Data Processing V4 0 CM2B8705en_01 Mapping data series to the time period of report 01 09 2006 7 4 Capture range Values whose time stamp deviates less than 10 seconds capture range from the start point of a resolution interval are corrected with regard to time Depending on the compression type see previous section they are assigned either to the preceding or the succeeding resolution interval This function cannot be disabled or changed as it is a canned program function This logic ensures that values which are recorded at very small time delays for reasons of transmission are not assigned to the wrong resolution interval Example In the example spontaneous i e uncompressed data is displayed in a report with resolution 1 hour The example shows that the values are moved within the capture range to the next interval limit left The data series and the Trend report list are defined
32. A Data A o Oa For Help press F1 NUM 8673087 Completed graphic 74 104 For internal use only Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation Table display 01 09 2006 8 2 5 Step 5 Save a design file In the Formula One Workbook Designer on the Data worksheet 1 Select all cells 2 Click Edit Clear Formula One opens the Clear dialog box In the Clear dialog box 3 Select Values If you forget to select the values you will loose important formatting information In the Clear dialog box 4 OK The Data tab is emptied and ready for the entry of new values when you retrieve a report Important Before proceeding to the next step make sure that cells are only selected on the tab containing the graphic to be displayed If other cells on other tabs are selected the report may be opened on a wrong worksheet 5 Select File Write The Write File dialog box opens Write File EES File name Folders demoF 1 c pdm adp visual k Cancel O100_vts york ADU vts 7 4cO0_vts a pdm adp BOO vts H visual Help atrium ts c U vts c i vts c93 wte Hetwork Heit Save file as type Drives Formula One ts ES c chzugw2817 8673088 Save design file In the Write File dialog box 6 Type inthe name of the design file In the Write File dialog box 7 Select the Visual folder in pdm adp In the Write File dialog box
33. ADP CC Excel List Table Trend Meter report Node report Archive WANEH z 8704z01 8704z01 Principle of operation for ADP PDM CC 8 104 For internal use only Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation What is ADP 01 09 2006 ADP is merely one building block of an entire concept Comparing ADP and CC Siemens Building Technologies Building Automation CAFM Computer aided facility management The term CAFM includes the following three components e Technical building management e Administrative building management not part of this document e Infrastructural building management not part of this document For technical building management Siemens Building Technologies provides the following three software packages e PDM Includes all administrative functions for the PDM database e ADP CC Application programs that process and prepare saved building data according to various aspects CC ADP on UNIGYR INTEGRAL GA x DESIGO VISONIK SICLIMAT X 8732211 ADP differs from CC Consumption Control designed especially for energy data e Because of its high flexibility in terms of data selection and display and e because of its capability for substantially smaller resolutions for data acquisition CC on the other hand e Focuses on cost models unit conversion and distribution of energy on various structures as its pri
34. Automation Step 3 Link data series to the ADP report Refresher Assign the data series to the ADP report you want to display on screen e The order of the individual entries determines the order of the columns when a report is printed e The same data series may appear several times e g with different date ranges e A report may also contain data series used for internal calculations in reports only and not displayed in ADP reports A With the aid of the PdmExplorer FJ PdmE xplorer Winter98 Internal IMA Project File Edit View Tools Help E Calculated z 3 JX E A a a pdm_demo Description E A Configuration Fe Atrium temperature average 1 step 1 2 _ atemp2 atemp5 2 No Lg DataPoints J Atrium temperature average 2 step 14 2 1 2 2 No E DataSeries Logical Recorded 1 Constant Filters Automation Reports Transfer K ADP Reports Energy Consumption Measured Values 2 A El energy consumption of area 1 JE El energy consumptionwobe Laerry consumption of area 1 Drag and drop F El energy consumption of area z al El energy consumptions daily v J Temperatures oils gt 6 objects Ready user 5 7 8701038 Link a data series to an ADP report with PdmFinder Left part of the PdmExplorer 1 Open the desired data series Recorded Calculated Constant Logical Right part of the PdmExplorer 2 Selec
35. DH Property Sheet x Shortcut Report Shortcut Report me El energy consumption of area 1 monthly values RY El energy consumption of area 1 monthly values Type Shortcut to Report Type Report Location Configuration 4utomationsAeports Mew Job Location ADF Reports E nergy Consumption Created Modified 25 02 99 08 09 47 By userS Created Modified 27 11 98 16 28 40 By pdm Target Location ADP Reports Energy Consumption Display fT able Target EL energy consumption of area 1 monthly va Fesolution i Month Description Test Report on Application Area T23 98 Time Span i Year z Design File coo E Quality Attribute M Description Standard Report P Wisible on User Level 5 only Carcel em 8701050 PDM Report properties mee e _ In the Shortcut tab 4 Change the following as needed Shortcut to the ADP report In the Report tab 5 Change the following as needed Display type List Table Excel Trend Time span range for which you want to display data Resolution Template assignment 5 3 How to start a job Method A e Free selection of the display type and the time span This overrides default values Method B e Direct start using predefined values Method B1 Double click a job Method B2 Use the context menu Method B3 Double click the desktop shortcut 39 104 Advanced Data Processing V4 0 CM2B8705en_01 Compose and start jobs 01 09 2006 Method C e Automa
36. E TARGETED SEARCH FOR DATA POINTS DATA SERIES AND ADP REPORTS You can start the PdmFinder parallel to the PdmExplorer and keep it open in the background to run searches at any time The quality attribute provides information on both generation and reliability of the respective value An entry may have several quality attributes For internal use only Advanced Data Processing V4 0 CM2B8705en_01 Glossary 01 09 2006 Quality attribute cont PDM sets the following values O OK Value inserted via the PDM tool DataEdit Value corrected via the PDM tool DataEdit i The processed interval contained at least one bad value Value imported from the archive n Data gap PDM fills in 0 to eliminate the gap VISONIK and DESIGO INSIGHT set the following values 3 Manual entry Limit under overflow No event Out of service No value available Hardware problem CON O1 Bf Shirted time See Offset Period also report time span Time span in days weeks etc for which you intend to display data in a report The report period thus only indicates if the report is a daily weekly monthly or yearly report Report time span CONCRETE TIME SPAN FOR WHICH YOU TO DISPLAY DATA IN THE REPORT Derived from the concrete time span for which the report displays data results from the time span report time span the offset the present report start date and the set job properties e g first weekday Monday Time stamp ATTRIB
37. FIND REPORT The PdmFinder finds all data series that match the search criteria of the local filter In the PdmFinder 5 Drag and drop the desired data series from the PdmFinder to the report template Right part of the PdmExplorer 6 Manually delete the local filter Delete all local filters after all data series have been found This converts a report template to an ADP report For internal use only Advanced Data Processing V4 0 CM2B8705en_01 Compose and start ADP reports 01 09 2006 There are three methods Method A Step by step procedure Siemens Building Technologies Building Automation 4 4 Howto start an ADP report Method A e Free selection of the display type and the time span This overrides default values Method B e Direct start using predefined values Method B1 Double click the ADP report Method B2 Use the context menu Method B3 Double click the desktop shortcut Method C e Automatic start via Auto Task Free selection of the display type and the time span This overrides default values Left part of the PdmExplorer 1 Right click the desired ADP report In the context menu 2 Click RUN The program opens the calendar J PdmExplorer Winter98 Internal IMA Project OF x File Edit View Tools Help gay RR gt fp on9008 od to a Ss sE D D t a a ue Dr or El BW demo Report Series Name SeriesName Type Offset A Configuration F Atrium te
38. Friday February 19 1999 15 59 4 Freely selectable time range The report includes all data between both the indicated start date and the stop date Offset shifted time span The offset represents the corrective value included in the definition of the date range applied to report data display This corrective value can be e Relative to the start time e g Offset 2 years e Absolute for a specific year e g Offset 1996 In this case select Reference year as the unit Application example Assumption A data series contains monthly values for multiple years The time span is 1 year and the resolution in the report is 1 month Offset If the data series is added three times to a report but each time with a different offset e g offset 2 years 1 year and 0 years the data of this data series can be displayed in neighboring columns shifted by one year 2 Years 1 Year 1999 PAB lanvary 203 20 EE March 250 265 295 April 240 8701033 Data series with offset table display Note e The offset entered for a data series only applies to the local report Unsupported offset e ADP does not support combinations containing an offset of months and a time function span of years Example Offset 1 month Report Table Resolution 1 week Period 1 year 19 104 Siemens Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation Basics you should know 01 09 2006
39. One onie on ara E ead 66 8 2 How to generate a design fil cee ccccceeecceccseeeeceeeeeeeeceeeceeaeeeeesseaeeeeessaaees 66 8 2 1 Step 1 Create an outline display 0 0 cceccccccccecceesseeeeeeeeesseeeeeeeeeeeeessaeeeees 66 8 2 2 Step 2 Prepare raw data reia aa e i aa a i Ti 68 8 2 3 Step 3 Generate a graphics OUTIING ccccccccesseeeeceeeeeeeeeeeseeeeseeaaeeeees 71 8 2 4 Step 4 Optimize the Qraphic ccccccseesesccceeeeceeeseeeeeeeeeeeseeseeeeeeeeesaaeaeees 73 8 2 5 Step o Save a design Tle resonar nE N 75 9 Trend display ccenn E EEE A EA 77 9 1 The most important features at a QIANCE ccccecccecseeeeeeseeeeeeeeeeeeaeeeeeenees 77 9 2 Slandard operating TUNCUONS essnee n eea aaa 81 9 2 1 Fle menu sesane a E EN NEE 81 9 2 2 Retrieve detailed information on any point Of a Curve ccccseeeeeeseeeeeeeees 81 9 2 3 Display detailed information for a specific point in time eceeeeseeeeeee ees 82 9 2 4 Assign a data series to the primary or secondary Y AXIS ccecceeeeeeeeeees 82 9 2 5 Show data series NAMES ccceccceccceeeececccaeeeeeeceeueeceeseuaeeeeesesaaeeeesssaaeeeess 82 For internal use only Advanced Data Processing V4 0 CM2B8705en_01 Table of contents 01 09 2006 For internal use only Building Technologies Building Automation 9 2 6 Change line thickneSs cccccsssecccecceeeeceeeceeeeeeeeseeeeseeeseeeaeeeeessaaeeeesssaaeees 83 9 2 7 Copy data series to
40. Properties or Font Properties The window provides several tabs to set specific properties The tabs are briefly described below You can familiarize yourself with the window by trying out the various functions lt Hint To check the changes e Click amp Apply in the respective tab Depending on whether you want to execute not yet accepted changes e Click amp OK or Cancel The General tab provides the following General Series Scale 3D View Titles general settings e Grid Lines Appearance Grid Lines Point Type e Color Scheme oE on e 3D Cluster Color Scheme Point Size Ee A e Color Lines Marker Yolume e Point Type T 30 Clustes W Color Lines Fon oot int od tf Point Size e 3D Line thick Click Diagram Chart Properties and then General to open this tab Cancel Apply 8701010 Chart properties General tab Grid Lines provides the following variants to display gridlines e No lines e Horizontal lines only e Vertical lines only e Horizontal and vertical lines 3D display only Color Scheme allows you to assign color and or texture to the curves Note Both color and pattern type must be assigned to the curves similar to the graphics range via the color and pattern bars Refer to the sections above for procedures Select this field three colored squares if you only want to assign colors to the 3D curves This is especially useful for sc
41. SIEMENS oO O oO C i re E 2000 T z 2 E S ANR 1999 1000000 v gt 1998 v E 500000 1997 ire 180 D C 50 00 00 00 08 00 00 16 00 00 00 00 00 08 00 00 16 00 00 00 00 00 06 03 00 07 03 00 08 03 00 00 00 00 ene 00 00 00 06 03 00 ISES 08 03 00 Vietelstundenmaximum gt E Max Lastabschaltung ADP Advanced Data Processing V4 0 User s manual CM2B8705en_01 Building Technologies 01 09 2006 For internal use only Building Automation Siemens Switzerland Ltd Building Technologies Group International Headquarters Building Automation Gubelstrasse 22 CH 6301 Zug Tel 41 41 724 24 24 Fax 41 41 724 35 22 www sbt siemens com 2 104 Building Technologies Advanced Data Processing V4 0 Building Automation 2006 Siemens Switzerland Ltc Subject to change For internal use only CM2B8705en_01 01 09 2006 For internal use only Building Technologies Building Automation Table of contents 1 Whats ADP T onesgi coen nei aa a O E S 7 2 About this doc ment serren See 10 2 1 ReVision MISIONY siaviweniticeweliatineeistiaeeviiatineenstaeweenet O nee 10 2 2 Referenced COCUMENIS cccccssseeececseeeeceeseaeeceeseueeeeeeesaeaeeeeeseuaeeeessaaaes 10 2 3 CLOVIS Fal aa a A A 11 2 4 Document stucen a eE 12 2 5 OAMENI anaa eet iia aneaue sateen atieeenten 13 2 6 DOCUMENT CONVERNONS snai E 14 2 6 1 OY MOOS US Ol si ee5 ard A E E T senha
42. UTE TIME FOR AN ENTRY IN A DATA SERIES Each entry of a data series has a time stamp showing the time when the value was valid The time stamp supplies the date and depending on the interval the exact hour for each value 101 104 Siemens Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation Glossary 01 09 2006 102 104 For internal use only Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation Glossary 01 09 2006 BID EEAS TEIT AEAT TETT A T TAT 89 SD Vania belh rena aa AA 89 AchsemtaklO innen naan a ee 88 Automa CMEC eienen da a E EE 88 CAFM aeaa a toed lath eet 9 Connecting Lines sc cess sss itd piccahs oxedepecaanlonnecaeneal 88 Context Sensitive Nel p cccccececceeseseseseeeeeeeeeeeneeas 13 Create Excel design file ccccccccceesessseeeeeeeeeeeeaes 95 Greate macro lls reo ected ico ets en aedinweunnaen 94 Database documentation uu cece ccc eeee esse een eeeee ees 10 DO CIM al S cca die sitocieceiactoaeoaiceancaae N 88 Document SCT Soca ots sas a emda Ahan acetate Sodas 12 Documentation Access and target readerS ccccscecsseeeeeneeeees 11 Engineering MANUal cccseeeeecseeeeeeeeeeeeeeeeeees 10 Relevant CAFM documents ccccsceeeeseeseeees 10 Relevante VISONIK document 2 ceeeeee 10 EXC6l CeSIGNininntaste ile er oe n oat 92 FADE aa a cee eee ee 88 GCOS aanere e e e a E NA 86 IS O90 00 e a cee t
43. User Level 5 only cores e 8701056 ADP report template for a table Name path creation date and author of most recent change Graphical display of the report List Table Excel Trend Time resolution used to display the data in a report e g one value per hour Time span number and unit used to display data in a report e g 3 weeks Predefined design settings for an ADP report Specify whether a quality attribute is to be displayed in the report Yes No This text field allows you to document the ADP report template that your are editing 6 4 Report data series properties A report data series is a data series that is linked to an ADP report Report data series differ from normal data series through the additional Offset and Show in Report features 6 4 1 Report tab You can individually adjust each report data series in an ADP report All adjustments are valid only for the associated report For internal use only Advanced Data Processing V4 0 CM2B8705en_01 ADP object properties 01 09 2006 Header data Offset Report display Siemens Building Technologies Building Automation PDH Property Sheet Report Entyy Series Point El energy consumption of area 1 per day offset 3 Type Report Data Series Offset Fix Year 3 Week Showin Report M cancel j _ 8701057 PDM properties Report Entry tab Name of the report data series The offset represents the corrective
44. a caption in the report e The entry applies only to this ADP report For internal use only Advanced Data Processing V4 0 CM2B8705en_01 Compose and start ADP reports 01 09 2006 Step by step procedure Siemens Building Technologies Building Automation In the context menu 5 Click PROPERTIES In the context menu The following dialog box opens PDH Property Sheet Atrium temperature Sth floor Type Report Data Series Offset Fix Year jo None Showin Report M Cancel Apply 8701041 PDM properties Report Entry tab In the Report tab 6 Change the following as needed e Offset the corrective value included when defining the date range for the ADP report data display e Show in Report checkbox data series The information on the Series and Point tabs are for information only and cannot be changed 4 2 Howto create an ADP report template An ADP report template corresponds to an ADP report whose definition is yet incomplete Contrary to the ADP report it contains at least one local filter entry allowing you to easily locate a specific data series Procedures for generating and ADP report and an ADP report template are largely the same However instead of data series you must link at least one filter to the ADP report The following applies to linking a filter to an ADP report Left part of the PdmExplorer 1 Open the Filter folder Right part of the PdmExplorer 2 Select the desired
45. a chart diagram using five tabs Font Properties Define font types for diagram chart labeling 79 104 Siemens Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation Trend display 01 09 2006 Curve menu Menu item Function Primary Y Axis Assign y axis of a amp curve to the left primary or right Primary Ass Se Secondary Y Axis secondary y axis The place where the curve name is Visible displayed depends on the status of the associated y axis Curve Name Fall Peat primary secondary axes Visible Show hide the activated curve Click Z the curve directly or amp amp the curve legend Copy To Clipboard Renove Curve Name Toggle item show hide the curve name 8701004 2D Line Thickness Change the curve s line thickness 4 XQ Copy to Clipboard Save the table values for a amp curve to the clipboard Format Clipboard format for Excel and Formula 1 Remove Windows functionality e The curve legends 10 11 indicate which curve represents which report data series e The time resolution on the x axis 6 changes in accordance with the currently displayed report time span Important e If the quality attributes QA are active in the report unreliable values with QAs 6 7 8 and n are not displayed in curves The curve is interrupted at these locations e Definition for unreliable Unreliable 6 7 8 4n i e In other words A gap in a curve
46. and QA in legend 7 Hotspot Time stamp from 8 Start time end time Slider Setting of the display s start and end time 9 Display Slider Data selection Data selection display with defined time span Left click Left double click Right click Right double click Fortsetzung n chste Seite The most important features at a glance continued 77 104 Advanced Data Processing V4 0 CM2B8705en_01 Trend display 01 09 2006 78 104 Fil Diagram Series eje 30 0 l 17 um on sered 16 PdmRunner 18 a fal Ea ms st omae mee E a 7 en A O ce Vie n LL 49 9 c Aui Temperature NA OS TAS O E hee aa Oe as Ya a Pe 17 0 lt Atrium temperature 2nd floo SS Sr a A S A 15 0 40 00 00 00 12 00 00 00 00 00 12 00 00 00 00 00 12 00 00 00 00 00 6 10 96 19 10 96 20 10 96 Ajon 00 00 00 00 00 00 18 10 96 8 3 Days 00 00 00 Eee LELLO 9 O 21 10 96 lt J Atrium remne 10 2 nd floor lt a Atrium temperature 5th floor cS Outside teri 11 lure 12 Ready Zoom QualAtt 8701001 Trend window repeat display Trend window mouse button functions No Name Left mouse button Right mouse button 10 Curve defining Selection of Curve from the Z gt Curve menu primary y axis name main menu item of report data series 11 Curve defining Selection of Curve fromthe Z Curve menu secondary y axis main menu item name of report data series 12 Statusl
47. as follows Data series definition Report definition Add Recorded Data Series Wizard 2 2 E x Please enter data for the new Recorded Data Series Please enter data for the new Report Function None v Display Trend v me a ick a Parameter Reading v Time Span a Week x Unit Storage Days 999 Description Design Eie fo Quality Attribute Description cmos cci 8734088en 8734089en Data series values Values visible in list or Trend DataEdit Data Editor Cow ajoj x hb Covi PdmRunmer E 5 xj WIR Ele Edt Qntions Window Help l x Datei Bearbeiten Hire B X20 Bw 62 HoE a amp zatsten ETE CEL Time Stamp Valle l 2 08 2000 07 00 00 27 06 2003 06 00 05 27 05 2003 06 00 00 27 08 2003 09 00 00 27 08 2003 06 09 04 27 08 2009 10 00 00 f 27 06 2003 07 33 02 27 06 2003 07 59 59 27 00 2007 11 00 00 27 06 2003 08 00 09 7 08 2000 09 02 23 F 27 08 2003 10 00 10 127 08 2000 10 45 03 27 08 2003 11 00 00 27 08 2003 11 00 04 f00 00 0000 00 00 00 CO 88608 6 2 8 6 66 8734090en 65 104 Siemens Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation Mapping data series to the time period of report 01 09 2006 Tip Important Outline display of an ADP report 66 104 Building Technologies Building Automation aw ITAN SL a 8 Table display Do not
48. ated accent bhosin kaueeumoukinr 7 AG E E A E A AE 15 Siemens Building Technologies Building Automation Index Advanced Data Processing V4 0 Lneatloga NAMIC ssie 88 Logical data Senes sciccnatac canna mud aed 16 Marker VOIUMG 32 2c0ertst nendise eee ieee ee 87 Marker VOlUME lt 2 35ic2206 tacenvidasaaesi eia eei eai 87 Mu l ple TYPES iin at ie tintomeladbenimeunetuadbantuaanaatia 87 Shadow sw ievicaucnsava dso inane E A 89 Short description ceeeeecccceesceeeeeeeeeeeeseseeeeeeeeeeeeeas 15 SNOW ETO AN S iaa a a aa a tals 88 small CAS aroa AA 15 Trend Display exact point in time ceceeeeeeeeeeeeeeeees 82 Graphic SClSCtION sasse T 83 Move start or end time cccccceseseeeeeeeeeeeeeeees 83 Move the SeIlOCtION ccccccseseecceeeecseneeesseaees 84 Register 3D ANSICN1 cccccsssseesssseeeeeeseeeneees 89 Register Allgemeines ccccseececeseeeeeeeeeeeeeaees 86 EDOM a a E O 90 Retrieve curve point details ccccccsseeeeeeeees 81 Specify design properties ceeeeeeeeeeeeeeeeeees 86 Tab SCal nsira ies 88 TAD SENES ron 87 Tape TUES nia dite Mand ydsin dh acdue castes 89 TIME span FeStriCtiONS cccseeeeeeeeeeeeaeeeeeenees 83 103 104 CM2B8705en_01 01 09 2006 Siemens Switzerland Ltd Building Technologies Group International Headquarters Building Automation Gubelstrasse 22 CH 6301 Zug Phone 41 41 724 24 24 Fax 41 41 724 35 22 www sbt s
49. ays or weeks etc 1 Current time span The report includes the current not yet completed date and time range 1 day report From Friday February 19 00 00 through Friday February 19 23 59 1 week report From Monday February 15 00 00 through Sunday February 21 23 59 1 month report From Monday February 1 00 00 through Sunday February 28 23 59 1 year report From Friday January 1 00 00 through From Friday December 31 23 59 but always without data after Fr 19 02 1600 hours 2 Completed time span The report includes the previous completed date and time span 1 day report From Thursday February 18 00 00 through Thursday February 18 23 59 1 week report From Monday February 8 00 00 through Sunday February 14 23 59 For internal use only Advanced Data Processing V4 0 CM2B8705en_01 Building Technologies Building Automation Basics you should know 01 09 2006 1 month report From Friday January 1 00 00 through Sunday January 31 23 59 1 year report From Thursday January 1 1998 00 00through Thursday December 31 1998 23 59 3 Sliding time span The report includes the time span for one day one week etc until the exact current time 1 day report from Thur 18 02 16 00 through Fr 19 02 15 59 1 week report From Friday February 12 16 00 through Friday February 19 15 59 1 month report from Thur 19 01 16 00 through Fr 19 02 15 59 1 year report From Friday February 19 1998 16 00 through
50. consumption of area Report data series have two additional report specific features e An offset i e a corrective value that allows for shifting the defined time span refer to offset e An option to display the data series in a report or not Job FUNCTIONALITY CONTAINING ONE OR MORE ADP REPORTS AND CAN BE STARTED AUTOMATICALLY OR MANUALLY VIA THE AUTO TASK Logical data series DATA SERIES THAT MERGERS OLD AND NEW RECORDED DATA SERIES AS PER THE MODEL BELOW Logical Data Series Old Data 4 NewData Recorded Derived gt A Recorded Derived Data Series Old Data Series New Recorded Base i o Recorded Base Data Series Old Data Series New The primary purpose of logical data series is the application of ADP reports This makes it possible to retain data depiction when migrating to DESIGO ADP objects ADP uses the following objects For better recognition they are always displayed together with a symbol Referenced data series lo Recorded report data series e Calculated report data series Data series referenced in an ADP Constant report data series report Br ie Report data series bin Invisible report data series This data series is used only for internal calculations in reports and is not visible 99 104 Siemens Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation Glossary 01 09 2006 Offset PDM database PdmExplorer Pd
51. d data series data points or ADP reports Local filters Filter entries in an ADP report template are local filters Local filters are created by copying global filters to a report template Local filters are valid only within the corresponding report template When you modify a local filter global filters are not impacted 6 5 1 Report Entry tab PDH Property Sheet Analog Input Type Filter Local cancel w 8701058 Local filter properties Report Entry tab Header data Name and type of the local filter 48 104 For internal use only Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation ADP object properties 01 09 2006 6 5 2 Report tab PDH Property Sheet Report Entry Report Series Point Name PO Display oo H Type ooo H Resolution poo H Time Spar O H Design File P Quality Attribute H cas eo 8701059 Local filter properties Report tab Search mask for ADP reports Name ADP report name including the wildcards and Layout Graphical display of the report List Table Excel Trend Type ADP report or ADP report template Resolution Time resolution used to display the data in a report e g one value per hour Period Time span number and unit used to display data in a report e g 3 weeks Design file Predefined design settings for an ADP report Quality attribute Specify whether a quality attribute is to be set in the report
52. data series to the time period Of report ccceeeceeeeeeeeeeeeeeeeees 58 7 1 WNT IS IE icssacersanen nan Gian ntieer ani aeaaeael 58 7 2 Determine values to be displayed ccccccseeeeeeecceeeeceeeeeeaeeeeeeeeeeeeeessaaees 58 7 2 1 Report with resolution no interval ccccsssceccseeeeeseeseeeeeeeeeseeeeesaaeeeesnees 58 7 2 2 Report with predefined resolution ccccccccsseeeceeeseeeeeeeeaeeeeeeesaeeeeeeeeaaeees 59 13 Examples Values to be displayed cccccseeeceecceseeeeescueeeeeeeseeeeeessaaeees 60 7 3 1 Data series display with spontaneous data COV cccccseeceeesseeeeeeeaeees 60 7 3 1 1 WIT TESOIMMONSNO interval susse a Alu e a mutes 60 7 3 1 2 With predefined report resolution cccceeccceceseeeeeeeeaeeeeeeseaeeeeeeeeseeeeeeeeeas 61 17 3 2 Data series display with sampling VAlUCS cccccseeceeeeeeeeeeeeseeesaeeeessaees 62 7 3 2 1 With resolution no interval cccccccssseecceeeeeeceeeeeccseeesseaseeesseeeesseeeeeaees 62 Fee With predefined report resolution ccceecceccssseeceeseeeeeeeeeseeeeeeeeseeeeeeeseas 63 7 3 3 Data series display with mean minimum maximum difference or sum VAINe Sa nati aihanhadha tas ohidaia Maa atianaiam aa madiaiatinamatiadieeds 64 7 3 0 1 With predefined report resolution ccceecceeeeeeeeeeeeeeaeeeeeeeeaeeeeeesaeeeeeeeeeas 64 7 4 capture range seee a 65 8 TADIS dS HAV E A AA 66 8 1 What is Formula
53. directly from the PDM database each time you retrieve an ADP report ADP REPORT WHOSE DEFINITION IS NOT YET COMPLETE The ADP report template contains contrary to the ADP report at least one local filter entry allowing you to easily locate a specific data series When you replace all filter entries of the report template by the desired data series entries an ADP report template becomes an ADP report Report Sere Name Atrium temperature Sth floor aim Room temperature set point Ek Atrium temperature average s i energy consumption of area 1 fpi This means F Local filter Use Report templates are a comfortable means to quickly create new ADP reports with similar designs As the report template specifies the design you only need to assign the respective data series TIME RESOLUTION USED TO DISPLAY DATA IN AN ADP REPORT Example You want a row by row display of hourly mean values in an ADP report In this case set the Resolution to one hour PROGRAM TO AUTOMATE THE FOLLOWING TASKS e Upload data from the database e Compress PDM data e Archive PDM data e Start ADP jobs i e print and save ADP reports DATA SERIES BELONGING TO ADP REPORT DISPLAYED WHEN THIS ADP REPORT IS OPENED For internal use only Advanced Data Processing V4 0 CM2B8705en_01 Glossary 01 09 2006 Report Sere Mame Atrium temperature Sth floor iN Room temperature set point Er Atrium temperature average 1 RE energy
54. down the left mouse button e Move the mouse pointer over the desired point and release the mouse button 9 2 9 Change the displayed report time span After retrieving a Trend report the displayed width corresponds to the requested time span The report time span as well as the start and end times time and date are displayed below the graphic by the three windows connected via a bar The windows to the left and right serve as the operating elements to restrict the report time span to the desired range Use the center window to move the defined time span to any other data within the current report e To restrict the report time span left click the start time window or the right end time window hold down the button and move the window Both time indication and display change according to the movement Vertical time lines are rescaled automatically for unchanged time spans e Note If you want to redisplay the entire time selection pull both windows left and right to the outer edges 16 0 a SN a E E las 15 0 4 0 12 00 00 16 00 00 gt Ca ai NO 00 00 04 00 00 08 00 00 12 00 00 18 10 96 1210 0 10 4 lt lt Atrium temperature Zno nub L Atejo ty aaae Sth floor Outside temperature i 7 Ready 8701007 Zooming a time span window 83 104 Advanced Data Processing V4 0 CM2B8705en_01 Trend display 01 09 2006 If the displayed selection was reduced as described above you can move it within the Moving the re
55. duced defined report time span as follows selection e Click the centre time box containing the reduced report time span hold down the mouse button and move it to the right or left The start and end time indications change accordingly Alternative procedure You can also drag the report left of the left or to the right of the right time stamp The range moves together with the effective time period The smaller the reporting period the smaller the steps when moving In the above example the report time span is moved via clicking by 12 hours 9 2 10 Zoom a desired area e Click the corner of the desired selection and hold down the mouse button The pointer turns into a magnifying glass e Move the magnifying glass to the opposite corner of the desired selection and release the mouse button At the same time the y axes are re scaled e Repeat this procedure as needed To display the original selection een e Click again Zoom in the View menu the checkmark disappears 9 3 Design properties Introduction Trend provides a number of options to individually adjust the diagram display and to save the adjustments for later use These options are primarily available in the Diagram menu Open this menu as follows e Q right click the diagram background or e left click the menu bar 9 3 1 Basic design options How to use Trend data Yes When you click this menu item a drop down list box with the Data Bitmap and
56. e report as saved in the database There is no shift 8734z02 Display without report resolution 62 104 For internal use only Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation Mapping data series to the time period of report 01 09 2006 Siemens Building Technologies Building Automation 7 3 2 2 With predefined report resolution A data series with compression function sampling value is displayed in a report with predefined resolution The report resolution selected is greater than the compression interval for the data series The data series and the report are defined as follows Data series definition Report definition Add Recorded Data Series Wizard 2 2 2 x Add Report Wizard 2 2 Please enter data for the new Recorded Data Series Please enter data for the new Report Function Sampling z Display Trend z Interval 1 Hour z Resolution Z Parameter al x Unit Es Storage Days 500 Description fC O TimeSpax 1 Week x Eel E Quality Attribute T Description cms cme 87340A0 87340A1 As the resolution defined in the report is greater than the compression interval of the data series several values are available for the resolution interval Even though the report was defined by using a predefined resolution only one value per interval is to be displayed in the report Report display In the report the spo
57. eaders as used for the individual data series in the report e From row 11 leftmost column This column contains the time stamp corresponding to the resolution defined for the report 1 day for our example e From row 11 columns to the right These columns contain the data series values e The left to right order corresponds to the order in which data series are listed in the ADP report e Each data series with quality attributes requires two columns without quality attribute each data series takes up just one column 67 104 Advanced Data Processing V4 0 CM2B8705en_01 Table display 01 09 2006 Preparations 68 104 Building Technologies Building Automation 8 2 2 Step 2 Prepare raw data For Formula One to use the date and time indications from column A for x axis labeling of the graphic to be created follow the step by step model instructions below The main task consist of preparing the raw data so that the contents of column A are no longer formatted in date form but instead as plain text In the outline display 1 Right double click The Formula One Workbook Designer dialog box opens E Formula One Workbook Designer File Edit View Data Sheet Format Object Help PAI frium temperatures O O OO AB D J 1 Atrium temperatura Al A al 2 sampling sampling Sampling 3 ATO bf oe ATO 67985 A10 63390 4 GRA 014055 GRA d01 4042 GRA 01 S050 4 G Recorded Recorded Recorded f Visonik
58. ear in Start Week on Default Job Properties Save Restore Use settings of this Job as Default Restore settings of this Job from Default Time span for which you to display data in the report Initial conditions for the start time of day month year and week Click OK to save the values of both tabs as default settings Note The default settings apply only to jobs and not to manual ADP reports There is no relationship to the values set via Tools Options Run Default tab Step 4 Report specific adjustments You can adjust each individual report within a job The job only contains shortcuts to ADP reports The actual ADP reports are saved in the ADP report folder Changes to report shortcuts are not saved to a local copy but directly to the original ADP report This is meaningful but at the same time differs from Windows conventions A specific message on changes reminds you of this difference Advanced Data Processing V4 0 Compose and start jobs For internal use only CM2B8705en_01 01 09 2006 Step by step procedure There are three methods Siemens Building Technologies Building Automation In the PdmExplorer 1 Open the desired job All associated ADP reports are displayed to the right Right part of the PdmExplorer 2 Right click the desired ADP report In the context menu 3 Click PROPERTIES The PdmExplorer opens the following dialog box PDM Property Sheet x P
59. ed as follows to show the name e Point the mouse pointer to the desired curve e Right click to open the Series menu and select Visible or Curve Name Note A curve name is shown only if the respective curve touches the left or right diagram border in the currently displayed area Hide a curve or a data series name e Apply the above procedure e click the legend of the desired data series selects the curve e Inthe Series menu click amp Curve Name or Visible checkmark disappears For internal use only Advanced Data Processing V4 0 CM2B8705en_01 Trend display 01 09 2006 Copy To Clipboard 8701004d Moving the start and end times Siemens Building Technologies Building Automation 9 2 6 Change line thickness This menu allows you to change the line thickness of the selected curve Any values between 1 and 10 are available The selected line thickness particularly impacts the curve display printed curves are not impacted as much 9 2 7 Copy data series to the clipboard This menu item allows you to copy data series to the clipboard and then paste them in the respective application e g Excel Refer to the chapter on lists for more detailed information 9 2 8 Change window size and graphic selection Proceed as follows to change the window size and the graphic selection standard Windows functionality e Move the mouse pointer to a line until the pointer becomes a double arrow e Press and hold
60. ed copy the columns that you want to display in the proper order to a new worksheet Formula One Workbook Designer E i e E a TT CE aa DatalA1 0 dd mmm Ha wig Temperature 2nd floor Temperature Sth floor Outside temperature 1 Oct Sb 19 6 21 a 0 5 02 Oct 19 J3 Oct 36 18 1 17 0E 8701076 Formula One Workbook Designer To the right of the toolbar 2 Click the graphic symbol In the Formula One Workbook Designer 3 Select the Graph worksheet Change to the Graph worksheet In the Graph worksheet 4 Draw afield for the future graphic using the left mouse button After releasing the mouse button the Chart Wizard dialog box opens 71 104 Siemens Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation Table display 01 09 2006 Chart Wizard Chart Wizard E Select a chart type 2D C 3D IA E Pie Horz Bar Hi Lo Gantt Bubble A Ea pel Contour Polar Help Cancel 2 Back Next gt Finish 8673082 Chart Wizard In the Chart Wizard 5 Select the settings and confirm with Finish The first parts of the graphic are displayed but without values Assign data to the 6 Double click the graphic frame prepared graphic In the Formula One Object menu 7 Click the Options menu item Formula One opens the following dialog box Options M Allow User Changes Cancel Formula CalclA1 D32 8673083 Object Options
61. eek C04 Ye El energy consumption of area 1 Vi J energy consumption of area 1 ea Eh energy consumption of area 1 Find al El nergy consumption of area 2 Refresh El e ergy consumptions daily v Temperatukes Paste Paste Shortcut A ra Properties sees Eee Point Folder H Right click blank space w o e o ri gt 4 object s Ready user5 5 7 8701035 Create ADP report Left part of the PdmExplorer 1 Select the desired report folder Right part of the PdmExplorer For internal use only Advanced Data Processing V4 0 CM2B8705en_01 Compose and start ADP reports 01 09 2006 Siemens Building Technologies Building Automation 2 Right click a blank area not a report In the context menu 3 Click NEW REPORT The Wizard starts In the Report Wizard 1 2 4 Specify the name of the new ADP report Add Report Wizard 172 8701036 PDM report wizard 1 2 In the Report Wizard 2 2 Define the following Display type List Table Excel Trend Resolution Time span range for which to display data Optional Assign the template and the quality attribute eeeg Add Report Wizard 2 2 8701037 PDM report wizard 2 2 In the Report Wizard 6 Click Finish The program generates a new report 25 104 Advanced Data Processing V4 0 CM2B8705en_01 Compose and start ADP reports 01 09 2006 ADP report contents Step by step procedure 26 104 Building Technologies Building
62. eiste Bottom left Program status Bottom right Number of values for the selected data series magnifying glass and quality attribute status 13 Diagram border drag Maximize minimize diagram 14 Palette Bar Color selection for diagram elements click and drag 15 Pattern Bar Pattern selection for diagram elements click and drag 16 Menu bar Menu for File Diagram and Curve 17 Name of the displayed report 18 Name of the active design file Left click Left double click Right click Right double click For internal use only ildi i Advanced Data Processing V4 0 CM2B8705en_01 Building Technologies Building Automation Trend display 01 09 2006 Trend displays the data series as curves The menus File Diagram and Curve help you design the Trend window File menu Menu item Function Load Properties Load Properties Load individually created design properties for a Trend Save Properties window Save Properties As Default Properties gt Save Properties Save design properties for a Trend window Prerequisite o The design properties must already be saved under any En PELEA name see title bar ee Save Properties As Save design properties of a Trend window under a Ea specific name O OTOVARN Default Properties Drop down list box allows for loading standard settings from a tab file as well as saving standard settings in a tab file Note The standard settings are used aut
63. em as desired Use Formula One the program supplied with ADP that resembles Excel to create the reports Excel Linking a report to Microsoft Excel 7 0 or later is intended primarily for experts Excel provides interesting revision functions such as statistical functions that can also be used for example to calculate correlations Resolution is the time frame used to display data in an ADP report Example You want a row by row display of hourly mean values in an ADP report In this case set the Resolution to one hour Time span or report time span stands for a period of time in days weeks etc for which you want to display data in a report The report period thus only indicates if the report is a daily weekly monthly or yearly report e g 3 weeks Predefined design settings for an ADP report Trend properties F1 template or Excel macro For internal use only Advanced Data Processing V4 0 CM2B8705en_01 ADP object properties 01 09 2006 Quality attributeSelection to indicate whether the calculated values are to be displayed with or without the resulting quality attribute a Checkbox not selected The ADP report displays only data series values x Checkbox selected The ADP report displays both data series values and quality attributes The quality attribute provides information on both generation and reliability of the respective value An entry may have several quality attributes PDM sets the followin
64. emperature nights only Filter Local Room temperature set paint Room temperatu Constant Nore Bo Atrium temperature Atrium temperatu Aecorded Nore Atrium temperature average 1 Atrium temperatu Calculated Nore 8701031 ADP reports Report series name Assign the data series to the ADP report you want to display on screen e The order of the individual entries determines the order of the columns when a report is printed e The same data series may appear several times e g with different date ranges e A report may also contain data series used for internal calculations in reports only and not displayed in ADP reports e f an ADP report contains data series with multiple intervals or if the intervals do not match the resolution of the ADP report the following applies The data series values are set to the time defined in the ADP report resolution If there are no values for the predefined time the most recent valid value of the respective data series is displayed The following applies to Trend displays with Resolution None All values of all data series are displayed Symbols Sho B Sr Recorded calculated or constant report data series a Report data series that do not appear in the ADP report For internal use only Advanced Data Processing V4 0 CM2B8705en_01 Basics you should know 01 09 2006 Report data series ADP report template Report design Types of display Siemens Building Tec
65. erm data evaluation Within the framework of the ISO9000 documentation requirement long term archived operating data can be retrieved at any time and processed in the form of ADP reports e In order to efficiently generate ADP reports the program provides report templates 7 104 Advanced Data Processing V4 0 CM2B8705en_01 What is ADP 01 09 2006 Operating principle ADP main functions As shown in the illustration below all building data required by ADP are available in the PDM database ADP serves to visualize this data individually or in any combination ADP provides two main functions e Define reports To define the data series whose data are summarized and presented in a report for comparative purposes Definition of report displays List Table Excel Trend Definition of a report s time resolution e Display reports Reports can be viewed on screen or printed manually via the corresponding command in ADP or automatically at predefined times The time span i e the time and date range that a report is supposed to cover as well as the report s start time and date are freely selectable PDM database Base data series A Calculations amp as functions cyclically automated Raw data Value Time Logged data Constants DESIGO INSIGHT MS2000 TS1500 VISONIK UNIGYR SICLIMAT X Formula for Other Calculated data islee hagas Derived data series
66. ero axis Y amis scale e Show Zero axis aie e Linear logarithmic y axes Logarithmic fioo Cancel Apply Click Diagram Chart Properties and then Scale to open this tab 8701012 Chart properties Scale tab Allows you to define the y axis to which the new changed settings in this tab are to be applied Y axes only Enter the smallest value to be displayed in Trend Y axes only Enter the greatest value to be displayed in Trend lt may sometimes be necessary to multiply data series values with a factor to properly display them on the selected y axis This field enables you to enter the factor to be used and indicated in the display Enter the desired number of decimals 0 8 These two fields allow you to specify if the Y axis division should appear automatically or should be fixed by applying the scale units to the right Note e This function only changes the display not the range e We recommend a fixed y axis setting for printing Allows you to specially highlight the zero axis or the zero axis for 3D displays These fields allow you to specify e If the subdivision of the y axes is to be linear or logarithmic in form e The basis of the logarithm For internal use only Advanced Data Processing V4 0 Trend display CM2B8705en_01 01 09 2006 Chart properties 3D View tab Z axis depth 3D 3D Variable we Shadows Chart properties Titles tab a ff nN kS Sieme
67. eve an ADP report 43 104 Advanced Data Processing V4 0 CM2B8705en_01 ADP object properties 01 09 2006 Header data Types of display Resolution Period Design file 44 104 Building Technologies Building Automation 6 2 1 ADP report tab The text fields correspond to those of the Report Wizard 2 2 PDH Property Sheet Shortcut Report 37 El energy consumption of area 1 monthly values Type Report Location ADP ReportssE nergy Consumption Created Modited 27 17 98 16 29 40 By pdm Display Table Resolution i Month Time Spar i Year Design File coo E Quality Attribute Description Test Report El Energy Consumption Area 7 standard Report fyisible on User Level 5 only cot e 8701055 ADP object properties Name path creation date and ADP report creator We provide four basic types of display to create reports each offering specific design properties List The data is listed in a table display Design efforts are minimal Trend Allows for quick and simple display of curves as y t display Zooming and x axis settings using the mouse scaling and excerpt are ideal for quick analysis Hint To quickly and easily analyze a data series drag and drop it in the Trend window Table Do not use this display for new projects as it will not be supported in the future Use Excel rather than Table Table allows for arranging values in tables and display th
68. filter and drag and drop it in the respective ADP report left part of PdmExplorer 29 104 Advanced Data Processing V4 0 CM2B8705en_01 Compose and start ADP reports 01 09 2006 Filter Step by step procedure 30 104 Building Technologies Building Automation Refresher A filter comprises preset search criteria to find data series data points or ADP reports Global filters Global filters are created with the help of PdmFinder and saved automatically in the PdmExplorer Filter folder Refer to the PDM user s guide for detailed instructions on creating global filters Local filters Filter entries in an ADP report template are local filters Local filters are created by copying global filters to a report template Local filters are valid only within the corresponding report template Modifying a local filter does not influence global filters 4 3 Howto create an ADP report from a report template To do this replace all local filters by the respective data series in the report template Left part of the PdmExplorer 1 Open the desired report template All associated data series and local filters are displayed to the right Right part of the PdmExplorer 2 Right click Local Filter The PdmExplorer opens the context menu for the local filter In the context menu 3 Click ASSIGN The PdmExplorer starts the PdmFinder The local filter settings are automatically transferred to the PdmFinder In the PdmFinder 4
69. for example to calculate correlations Resolution is the time frame used to display data in an ADP report Example You want a row by row display of hourly mean values in an ADP report In this case set the Resolution to one hour Application note We recommend to select a resolution that matches the data series intervals However this is not mandatory Data of data series that do not match this interval are standardized accordingly e The data series values are set to the time defined in the ADP report resolution If there are no values for the predefined time the most recent valid value of the respective data series is displayed e The following applies to Trend displays with Resolution None All values of all data series are displayed The concrete time span for which the report displays data results from the time span or report time span the offset the present report start date and the set job properties e g first weekday Monday The following four options are available Time Span Shown Used for Aun on Report Orly Curent Complete a ne C Sliding D a ele T 12 02 1983 ooon o fis 021999 foo 00 Date dd mm yuyu Time hh mm Use nn for MO 8701032e Time span It is Friday February 1999 1600 hours when you start a report If the Number field defines a period that extends over several days weeks etc the date range is expanded by the corresponding previous d
70. g Technologies Building Automation Compose and start jobs 01 09 2006 5 2 How to compose a job Step 1 Create a blank job When This step is optional You can create any number of jobs as needed in the PdmExplorer folder CONFIGURATION AUTOMATION REPORTS Standard Windows NT 2000 functionality applies to creating and deleting jobs File Edit View Tools Help Reports x feo Ed EE H EW demo Name Te Description E aq Configuration Job Points Job H Series i Gy Filters Units Automation g Reports View fi New Job Find Transfer ADP Ra ports Refresh Properties 2 object s user5 5 h 8701046 Create a new job Step by step procedure Left part of the PdmExplorer 1 Select the CONFIGURATION AUTOMATION REPORTS folder Right part of the PdmExplorer 2 Right click a blank area not the job In the context menu 3 Click NEw JOB The program creates a new job and allows you to assign a new name as per standard Windows procedures Step 2 Link ADP reports to a job Refresher Job e A job contains one or several ADP reports executed either by manual selection or automatically via Auto Task e The job properties dialog box allows you to specify if the associated ADP reports are to be displayed on screen printed or saved to file e The job only contains shortcuts to ADP reports The actual ADP report
71. g values o OK Value inserted via the PDM tool DataEdit a Value corrected via the PDM tool DataEdit i The processed interval contained at least one bad value Value imported from the archive n Data gap PDM fills in 0 to eliminate the gap VISONIK and DESIGO INSIGHT set the following values Manual entry Limit under overflow 5 Noevent S 6 Out of service No value available Hardware problem Description This text field allows you to individually document the ADP report that your are editing 45 104 Siemens Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation ADP object properties 01 09 2006 Refresher Header data Layout Resolution Period Design file Quality attribute Description Refresher 46 104 Building Technologies Building Automation 6 3 ADP report template properties A report template corresponds to an ADP report whose definition is not yet complete Contrary to the ADP report it contains at least one local filter entry allowing you to easily locate a specific data series PDH Property Sheet Report ag Air temperature outside Type Template Location ADF Reports Temperatures Created bloditied 24 02 99 10 29 37 Bp user5 Display Table Resolution i Hour Time Spar 3 Dap ki Design File coo E Quality Attribute D Description Demo Template Air Temperature Outside standard Report Wisible on
72. geeessaeeessegeeessageeessaes 43 6 2 1 ADP TCDOM taD s taiumenaastned Montmasdualtaenitetase 44 6 3 ADP report template properties ccceccccseeeeeceeeeeceeeeeesseeeeesseneeessaneeeees 46 6 4 Report data series properties ccccccccccseeceecceeeeeeeeaeeeeeeeseeeeeeeseeeeeeenseas 46 6 4 1 PRODOT TAD artoetnarentantesarutoonuaumoneda O asus huwonrammananaeninans 46 6 4 2 Senes ANG FON taD Sap 47 6 5 Local filter propertieS nnneennnenneeenneoennenrnnnnsrnnrsrnrrrrnrrrsnrrrsnrrrsrreesrneernnees 48 6 5 1 PROPO E MIYA Aen E E tasted Spanasedeeneseediss 48 6 5 2 PIC DOM TAD nanira a a a a E ee ae 49 6 5 3 ETETEA 0 EAEE EE E N EE ee ee N E ees 50 3 104 Advanced Data Processing V4 0 CM2B8705en_01 Table of contents 01 09 2006 4 104 Building Technologies Building Automation 6 5 4 FO ta eh rao a anh ee aan a So a 51 6 6 ODI DKODEMICS rsa taster ta hae rhachis Sarl ta anc dante dates Jed 52 6 6 1 JOD TAD aie paestitcanrnioanses hiner ieee ese ie 52 6 6 2 Aavanced taD tauriin anchcseeseuabbadandaasaaanussaacanciagadenncenscensnattaenatbedsuanetae 53 6 7 Slat GialOG Proper ES ancurna E 54 6 7 1 Start dialog box for ADP reports ccccceccecccceeeeeseeeeeeeeeeeeeeeeeeeeeeeeseeaaeesees 54 6 7 2 Slat dialog DOX TON JONSi4 eka eRe oie Nate eet deed edad 56 6 8 Shortcut DYODEMICS oa a EE tare eee eae toe awa eee eee 57 6 8 1 SOMCE Ma canna rcotagaae auatennca assoc auseasen andrea ataee ee ae onan ae mao 57 7 Mapping
73. h the values that are currently valid e g the current month Selection to display the ADP reports for this job on screen print them or save them to file For internal use only Advanced Data Processing V4 0 CM2B8705en_01 Building Technologies Building Automation ADP object properties 01 09 2006 6 6 2 Advanced tab PDH Property Sheet Job Advanced Time Span Start Start Day on Start Month on Start Year ir January Start Week on Monday Default Job Properties Use settings of this Job as Default Save Restore settings of this Job from Default Restore 8701063 Job properties Advanced tab Start Day On The time when a day begins 0 24 Start Month On Day of a month that marks the beginning of a month 1 31 Start Year In Month that marks the beginning of a year January December Start Week On Weekday that marks the beginning of a week Monday Sunday Save Saves all values of both tabs as a default setting Note The default settings apply only to jobs and not to manual ADP reports There is no relationship to the values set via Tools Options Run Default tab Restore Restores the default values in the current job 53 104 Siemens Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation ADP object properties 01 09 2006 6 7 Start dialog properties 6 7 1 Start dialog box for ADP reports Run Report Atrium Temperatures T
74. he compression interval specifies the time periods at which a compressed value is to be calculated and saved in the data series Report resolution short form resolution The report resolution indicates the time resolution e g 1 value per day applied to displaying data series values in a report In this context the terms report time span and resolution interval are used 7 1 What is it Normally you select the report resolution to match either the compression intervals for the data series to be displayed or the recording interval for uncompressed data series However this is not mandatory This chapter describes how data series values whose compression or recording intervals do not match the selected report resolution are displayed in a report Example Display of spontaneous data in a report featuring daily values PDM preps the data series values as follows to map them to the selected report resolution 1 Determine the data series values suitable for report display and if necessary shift the values to the report resolution 2 Consider the capture range for values with min time deviation from the interval limit PDM preps the data series values and passes them on to ADP They are then available in ADP for all types of display List Trend Table Excel 7 2 Determine values to be displayed 7 2 1 Report with resolution no interval The following applies to the evaluation types Trend and Excel All values
75. he graphic In the Calc worksheet Select cell B1 Enter the following formula in B1 Data B10 Data B10 refers to our example and references the first data series in the Data worksheet In the Calc worksheet cell B1 Click the small square at the lower right corner of the cell and drag the selected cell by pressing the left mouse button to cell B32 The raw data of the first data series is now referenced in the Calc worksheet In the Calc worksheet Repeat steps 7 and 8 for the second Data C10 and third Data D10 data series Following this process all data in the Calc worksheet are compatible to graphic processing For internal use only Advanced Data Processing V4 0 CM2B8705en_01 Building Technologies Building Automation Table display 01 09 2006 8 2 3 Step 3 Generate a graphics outline The graphic is to be generated on the Graph worksheet In the Calc worksheet 1 Select the data to be displayed cells A1 to D32 for our example The following generally applies In order to graphically display the values select the range so that the column with the time span is located to the very left with one blank field at the top this is the only way for the time span to be interpreted as X axis information The columns to the right containing the data series values must have a title data series name in the header row Columns with quality attributes may not be selected lf requir
76. hnologies Building Automation When you open an ADP report all associated data series are displayed Bo Outside temperature Outside tempera Recorded Nore R Outside temperature nights only Filter Local ar Room temperature set paint Room temperatu Constant Nore Bo Atrium temperature Atrium temperatu Aecorded Nore Atrium temperature average 1 Atrium temperatu Calculated Nore 8701031 ADP reports Report series name Data series referenced in a report are called report data series Report data series have two additional report specific features e An offset i e a corrective value allowing for shifting the defined time span To for example compare the current month to the previous month of a data series e An option to display the data series in a report or not A report template corresponds to an ADP report whose definition is not yet complete Contrary to the ADP report it contains at least one local filter entry allowing you to easily locate a specific data series Report Series Name SeriesName Type Offset fo Outside temperature Outside tempera Recorded None rd Outside temperature nights only Filter Local 8701031a ADP reports Filter entry When you replace all filter entries of the report template by the desired data series entries an ADP report template becomes an ADP report Symbol For greater clarity the following symbol appears when a report template is created ad Local
77. iemens com 104 104 Building Technologies Advanced Data Processing V4 0 Building Automation Index 2006 Siemens Switzerland Ltd Subject to change For internal use only CM2B8705en_01 01 09 2006
78. ime Span i Dap Display Trend M Start Stop Synchronization M Align to Time Span Start Start Periode Stop Februar 1999 Mo Di Mi Do Fr Sa 5o 4 25 26 27 28 29 30 31 cli 2 3 48 6 Fz 6 8 9 10 11 12 13 14 15 16 17 18 19 20 21 5 23 24 25 26 27 28 gli 2 3 4 5 6 F C Today 01 03 99 Time 00 00 00 00 8701064 ADP reports start dialog box Layout The display as set during report creation can be changed at this point and easily adjusted to current needs The following display types are available e List The data are displayed as number values in tables e Table Worksheets similar to Excel with tables and graphics e Excel Evaluation occurs in Excel only e Trend Display of curves and flows Period Time span or report time span stands for a period of time in days weeks etc for which you want to display data in a report The report period thus only indicates if the report is a daily weekly monthly or yearly report e g 3 weeks 54 104 For internal use only Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation ADP object properties 01 09 2006 Start Stop Synchronization Align to Time Span Start Start Period Stop OK Siemens Building Technologies Building Automation Both the start and the end date are synchronized i e If you change the start date in the calendar the program determines the associated end date and vice versa add
79. invalid dates The symbol to the left denotes important information in addition the text is printed ona gray background 15 104 Advanced Data Processing V4 0 CM2B8705en_01 About this document 01 09 2006 PDM basics Data series ADP report 16 104 Building Technologies Building Automation 3 Basics you should know Extensive information on the topics below are available in the PDM User s Guide CM2B8733en under the same chapter heading or in the online help glossary e PDM database Interval storage time formula time stamp quality attribute e Compression types Sampling difference mean maximum minimum sum e Data series Data point Recorded calculated constant and logical data series Refresher ADP and CC can only access data for which a data series was created When creating a data series the data structure required to save the data is created in the PDM database A data series contains values that relate to a specific data point AND a defined interval e g the hourly mean value of the outside temperature Thus For values based on a specific data point and recorded for various time intervals e g hourly and daily mean values of the outside temperature various data series must be generated accordingly 3 1 ADP report An ADP report only comprises references to data series but not current lists or graphics Bo Outside temperature Outside tempera Recorded Nore R Outside t
80. ir Temperature a graphic in these four fields El The allocation of titles is different depending Bottom on the curve display Interval Click Diagram Chart Properties and then Titles to open this tab OF Cancel 8701014 Chart properties Titles tab If the y axis description and the title caption overlap select one of the following options depending on the display e For 2D and standard 3D displays adjust the graphics selection refer to Change the window size and the graphics selection e For full 3D displays adjust the observation angle refer to Full 3D view suitable values are x 30 y 300 89 104 Advanced Data Processing V4 0 CM2B8705en_01 Trend display 01 09 2006 9 3 3 Define the font types rS Note This version of Trend no longer has font restrictions You can now allocate any font to a Trend report Save the settings with the report name refer to Save a Trend a i display Select Font Properties from the Diagram menu to open the Font Properties window Font Properties window Font Properties Top title ajug YE Left title 10 11 98 23 11 95 06 12 95 20 12 90 Bottom title Font FepotDataSerie 8701015 Font Properties window Change fonts The Font Properties window allows you to use any font available on your computer or server for Trend The field to the right contains all captions whose font types you can change To change
81. isanik Wisonik g 4 10 Atrium temperature 2nd floor Atrium temperature Sth foor Outside temperature 11 1 10 96 0 00 19 6 21 55 10 9 12 2 10 96 0 00 195 20 95 12 1 13 3 10 96 0 00 18 1 19 95 6 35 14 4 10 96 0 00 17 95 20 5 2 15 5 10 96 0 00 18 75 20 75 11 55 16 6 10 96 0 00 17 15 19 05 7 36 17 7 10 96 0 00 16 15 20 15 10 25 18 5 10 96 0 00 18 1 20 05 10 75 19 9 10 96 0 00 17 55 15 55 11 45 R a Sheet2 A Data fT For Help press F 8701071 Formula One Workbook Designer In the Formula One Workbook Designer 2 Menu Sheet Insert Sheet Insert a new sheet in the workbook This creates additional space for subsequent reformatting of column A or of further conversions of other columns For internal use only Advanced Data Processing V4 0 CM2B8705en_01 Table display 01 09 2006 In the Formula One Workbook Designer 3 Double click the worksheet name Name the worksheets as follows from left to right Before After 19 19 4 H Sheet A Sheets A Data a Graph A Cale A Data For Help press Fl For Help press F 8701072 8701073 Using the three Graph This worksheet will later contain the graphic worksheets Calc This worksheet contains references to all raw data to be displayed in the Data worksheet This is where column A is converted from date format to text format Data Contains the raw data Preparing the raw data Worksheet Calc is used to create the references to all raw data of the Data sheet The individ
82. itionally different numbers of days in a month are included The calculated values are based on the current date and the selected time span Both the start and the end date are not synchronized i e The start and end date in the calendar can be set independent of each other to exact days and hours When you set synchronization the start date is moved automatically in accordance with the default settings for the beginning of a day month and year See context menu Job Advanced tab Start date and time for an ADP report Hint If the start and stop date are both within the same month 1 week into another month you can directly mark the time span in the calendar Stop date and time for an ADP report Start of an ADP report 55 104 Advanced Data Processing V4 0 CM2B8705en_01 ADP object properties 01 09 2006 Layout Time Span Shown Action OK 56 104 Building Technologies Building Automation 6 7 2 Start dialog box for jobs Run Job Job 3C2 Time Span shown As defined in Job Direct Start Stop Oa wooo rea Display As defined in each Report c 8701065 Start job Specify if the same display is to be used for all ADP reports of the job List Table Excel Trend Specify if the time span for which you want to display data in the ADP report e Derived from the job properties e Entered at this location Selection to display the ADP reports fo
83. mFinder Quality attribute 100 104 Building Technologies Building Automation ADP objects cont ADP reports F ADP report ADP report Open Link to ADP report shortcut Short cuts to reports data points and data series can be created in PDM These shortcuts are marked by a small arrow similar to Windows FH ADP report write protected Access level 5 allows you to save and write protect ADP reports However as soon as you copy a write protected report write protection no longer applies and the standard symbols for ADP reports are again displayed a ADP report template ADP reports with at least one local filter ia ADP report template Open R Local filter Contains preset search criteria for data series A local filter as opposed to a global filter is valid only within the report template A CORRECTIVE VALUE IS INCLUDED ON DEFINING THE DATE RANGE FOR REPORT DATA DISPLAY This corrective value can be e Relative to the start time e g Offset 2 years e Absolute for a specific year e g Offset 1996 In this case select Reference year as the unit A DATABASE BASED ON A STANDARD RELATIONAL DATABASE SYSTEM For small projects we recommend an MSDE database and for large projects an MS SQL server database The PDM database is a common database and is used by the following programs e ADP Advanced Data Processing and e CC Consumption Control CENTRAL INTERFACE FOR PDM AND ADP PROGRAM FOR TH
84. maar ae eata eae 14 2 6 2 Typographical CONVENTIONS cccscsceccseeeeceeseeeceeseeeceeeeeessaeeessaseesssaneeeees 15 3 Basics VOUSU KNOW srian A EEN 16 3 1 PAD TEDO ooien ace erin aes case a a oa anes econ adeawetines 16 3 2 Repor proper ES ensue a e ENE 17 3 3 PDP ODJECE iiss tise eedeced Sante tise bnedencd destedienduetaaee det hateecucduads dectetansnelenes idetemeeadesuts 21 3 4 POOR ANAS eriin a tite ss nance thai ead uacaietd ect ose aueamino aeratnen 22 4 Compose and start ADP reports ccccceececcceeeeeeeeeeeeeeeessaeaeeeeeeeeessaaeeeees 23 4 1 How to create an ADP report ccccccseececceeseeeceeseecceeeeeeseeeeessseeesseseeesaaes 23 4 2 How to create an ADP report template cccceeceeeeeeeeeeeeeeeeeeeeeeeeeeeeeas 29 4 3 How to create an ADP report from a report template c ccecceeseeeeeeees 30 4 4 How to start an ADP report ssi fia sito eae a aiid ce rac neaedteadaweladeanetne 31 5 Compose and Start JODS s scicenct ne nciteedctiieenine tiene 35 5 1 Whats GMO 2 sich cot iodatiat a sil baoal N cacuiacitoee 35 5 2 HOWTO COMPOSE AJOD eirinen a a ideseeascteeiasaneanaaeoue 36 5 3 FONTO SaN a ODi acct satelondeauticioid dl sattlencianshtsdsl sat addnats uel tou 39 6 ADP ODICCl DIOD EMIS aitetcocastcnrteeuouien a E AEN 43 6 1 FIOW 10 TMG UNG DIO DOMMES cirri Say inaies develan io acd intl ead aden Need acetaie 43 6 2 ADP reports properties cccccccsseecceseeecceseeecseeeeecse
85. mary features and e works with daily values 9 104 Advanced Data Processing V4 0 CM2B8705en_01 What is ADP 01 09 2006 CAFM documentation VISONIK documentation Database documentation Engineering manual 10 104 Building Technologies Building Automation 2 About this document 2 1 Revision history This document contains the following changes as compared to version ADP 3 0 dated June 2003 CM2B8703en oe New text Logical data series 3 11 Glossary Index 2 2 Referenced documents a EL rs Lae User s guide for version 3 1 1 CM2B8736en_01 vs S guide March 2004 This document CM2B8705en_01 w s guide User s guide for version 3 1 1 May 2004 CC User s guide for version 2 2 x CM2B8716en_01 User s guide February 2000 User level 4 and higher require substantial knowledge of VISONIK data processing DP The ADP engineering manual references all relevant documents The table below contains the most important documents Document Contes J Order number VISONIK DCS User s guide Version 20 CM2U8568E Functions A Z VISONIK Point types Documentation on basics for CM2Z8568E and parameters VISONIK point types and parameters version 20 VISONIK DCS Loader Loading the VISONIK DCS CM2U8373E Operator handbook configurations PDM uses one of several available standard databases Refer to the supplied documentation for detailed information on this topic In this document we will limit oursel
86. mperature average 1 Atrium temperatu Calculated None E K ADP Reports Energy Consumption E Temperatures Templates Da Air temperature outside Q Nr Atrium temperature average 1 A Atrium temperature average 2 al Atrium temperature 2nd floor E Atrium temperature 5th floor 9 Atrium Temperatures ae Excel 5 0 E Atrium temperatu a JE Excel 5 0 E Atrium temperatu ee Run Report Atrium temperature average 1 x E Excel 5 0 E Atrium temperatu Cut Time Span Copy Paste 3 Day Bloat sles M Start Stop Synchronization Create Shorter Delete IV Align to Time Span Start Rename Properties Start Periode Stop ae January 2006 A 4 January 2006 A 4 gt Mo Tu We Th Fr Sa Su Mo Tu We Th Fr Sa Su 40 30 1 2 3 4 5 6 4030 1 2 3 4 5 6 1 object s Ready 41 7 8 9 10 11 12 13 41 7 8 9 10 11 12 13 42114 15 16 17 4 19 20 42 14 15 16 17 18 19 20 43 21 22 23 24 25 26 27 43 22 23 24 25 26 27 44 28 29 30 31 1 2 3 44 28 29 30 31 1 4514 5 6 7 8 9 10 4514 5 6 7 8 9 10 Today 22 10 2006 Time 00 00 00 00 Cancel 8701042 Start ADP report In the calendar 3 Change the preset values If needed change the values for the display type and the time span These changes only apply to an immediate report display and do not impact predefined values 31 104 Advanced Data Processing V4 0 CM2B8705en_01 Compose and start ADP reports 01 09 2006 Tip 35 a Method B1 Step by step procedure
87. n what to enter in the individual text and option fields Use context sensitive online help for your daily tasks right click or press F1 for the desired text or option field The information provided is largely identical to that in ADP object properties 5 1 What is a job A job contains one or several ADP reports and can be started as follows e Manually e Automatically via Auto Task PJ PdmE xplorer Winter98 Internal IMA Project File Edit View Tools Help m Reports So pai E W demo ae Configuration 3B Atrium Temperatures Shortcut Atrium Temperatures Overview Statis Points ga El energy consumption of area 1 Shortcut Test Report on Application Area T23 98 Series 3B Measured values el energy consu Shortcut Control Values 1 Area T23 98 Filters Automation Reports Transfer E L ADP Reports E Energy Consumption F El energy consumption of area 1 F El energy consumption of area 1 F El energy consumption of area 1 F El energy consumption of area 2 al El energy consumptions daily v J Temperatures 3 objects Ready user5 5 A 8701045 PdmExplorer Overview The job only contains shortcuts to ADP reports The actual ADP reports are saved in the ADP report folder Jobs are always saved in the PDM folder CONFIGURATION AUTOMATION REPORTS 35 104 Advanced Data Processing V4 0 CM2B8705en_01 Siemens Buildin
88. nd 10Min 3 Day a El energy consumption of area 4 a Aeon ceReee ADP AReports E Table 1 Day 1 Week ial El energy consumptions daily v BIE energy consumption of area 1 ADP Reports E Table 1 Day 1 Month Temperatures Ma 19 object s found demo user5 5 2 1 object s Ready pdm 4 h 8701039 Link a data series to an ADP report with PdmFinder In the PdmExplorer 1 Open the new or the ADP report you want to change All corresponding report data is displayed to the right In the PdmFinder 2 Find the new data series and drag and drop it in the right part of the PdmExplorer Advanced Data Processing V4 0 Compose and start ADP reports 27 104 CM2B8705en_01 01 09 2006 Step by step procedure Change order Change label Note 28 104 Building Technologies Building Automation Step 4 Report specific adjustments You can individually adjust each report data series in an ADP report This allows you to influence the way data series are displayed in a report Note All adjustments apply only to the respective report If you use the same data series ina different report the adjustments have no influence File Edit View Tools Help A ADP Reports x a x Ea ee Ea W demo Report Series Name Series Name Type Offset aq Configuration o Atrium temperature 2nd floor Atrium temperatu Recorded None K ADP Reports Atrium
89. ns Building Technologies Building Automation Ctar proprie xl The 3D View tab allows you to make the following settings T n z _ s Angle fo M 3D Full 3D View T Angle o MW Shadows e z axis depth e 3D e Full 3D View e Shadows These settings substantially influence the overall display of a diagram chart Click Diagram Chart Properties and then 3D View to open this tab Cancel Apply 8701013 Chart properties 3D View tab 3D view only Adjust the depth of the z axis by means of the slider not labeled When you do this the width of the curve bands is adjusted in proportion to the z axis depth This setting displays the data series in standard 3D view Allows you to display the curve bands in adjustable 3D views An interactive graphic blue and red balls and two fields for manual entry of the x and y angles support you in this process Important When selected the Show more details on a specific point in time vertical line with time stamp function is not available 3D view only Option to shade the lower side of the curve bands General Series Scale 3D View Titles e Top The Titles tab comprises the following fields Jee e Left Atrium General Overview Room Temperatures e Right Left e Bottom Enter the texts that are displayed on top to the left and right and at the bottom of the Room Temperatures a El Right Outside A
90. ntaneous values are moved to the start point of the next resolution interval i e to the right Among multiple values the value closest to the interval limit is displayed If values are missing the last known good value of this data series is used t Interval 1 Interval Interval 3 8704z03 Display with report resolution 63 104 Advanced Data Processing V4 0 CM2B8705en_01 Mapping data series to the time period of report 01 09 2006 64 104 Building Technologies Building Automation 7 3 3 Data series display with mean minimum maximum difference or sum values 7 3 3 1 With predefined report resolution A data series with one of the above compression functions is displayed in a report with predefined resolution The report resolution selected is greater than the compression interval for the data series The data series and the report are defined as follows Data series definition Report definition Series Point Report JUP 010VIP50 VP MIN ISOM 802 _MIN s Minimum Type Series Recorded Type Report Created Modified 27 08 2003 13 20 35 By Location ADP Reports Data from to 20 08 2003 27 08 2003 13 00 00 Created Modified 27 08 2003 13 29 47 By pdm Function Miri Display z Intervak 1 Hour z Resolution fi Day Ne Parameter P T Time Span 1 Week x Unit f Design File c Storage Days 365 Quality Attribute Base Data Senes 7 Description Description
91. o Use ShowMacro of the indicated file of the indicated file of the indicated file If not possible If not possible If not possible Use RunMacro on the Use RunMacro on the Use RunMacro on the indicated file indicated file indicated file Not indicated file If not possible If not possible If not possible Use ShowMacro Use ShowMacro Use ShowMacro of the DefMacro32 xIs of the DefMacro32 xIs of the DefMacro32 xIs standard macro file standard macro file standard macro file Use PrintMacro Use SaveMacro of the indicated file of the indicated file Not indicated file If not possible If not possible Use PrintMacro Use SaveMacro of the DefMacro32 xIs of the DefMacro32 xIs standard macro file standard macro file Keep MS Excel open Close Microsoft Excel Close Microsoft Excel allows the user to view the when it was not open when it was not open report prior to starting your work prior to starting your work Corresponds to the design file from the report properties Macros from ADP version 1 x These macros will run smoothly provided they were created on the English version 5 0 If this is not possible also an error message appears 92 104 For internal use only Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation Excel display V7 0E 8 0E 01 09 2006 Siemens Building Technologies Building Automation Start Report Startlactiv ate MS Excel Run SHa acr if n
92. ologies Building Automation Left part of the PdmExplorer 1 Select the higher ADP report folder Right part of the PdmExplorer 2 Right click a blank area not a report In the context menu 3 Click NEW FOLDER You can now name the newly created folder Create a shortcut to an ADP report You can save the same report to several folders to for example best structure your report storage structure To this end we recommend to not copy the associated report but merely save a shortcut in the new folder Left part of the PdmExplorer 1 Open the ADP report folder The right portion of the Explorer displays all associated ADP reports Right part of the PdmExplorer 2 Select the desired report press CTRL SHIFT and drag and drop the report to the desired ADP report folder left portion of the PdmExplorer Step 2 Create an empty ADP report FJ PdmE xplorer Winter98 Internal IMA Project File Edit View Tools Help vi T lt iep or a A ADP Reports ae x Eo Ee E H demo Display Resolution Time Span Design File use Q Configuration JE Measured values el energy consu Table 1 Hour 1week C04 Ye Yj ADP Reports l fE Measured values el energy consu Table 1 Hour 1week CO4 Ye E Energy Consumption 2 Measured values el energy consu Table 1 Hour 1Week CO4 Ye a Measured Values fEl Measured values el energy consu Table 1 Hour 1W
93. omatically if no design file is specified for the report oe Print Windows functionality Print Preview Windows functionality Print Setup Windows functionality Beenden Windows functionality Diagram menu Menu item Function Copy i Copy Submenu Data bitmap meta file copy window contents Normal to different file formats A Normal 2D display of the Trend window Autoscale b 3D 3D display of the Trend window Quality Attribute Sheplines Data Data table display oor Autoscale Submenu First y axis second y axis Palette Bar i i i seas Activation deactivation of automatic adjustment for Legend curves in the display field Chart Properties X Axis Division Number of visible vertical lines incl chart border This ERE aes allows for labeling the x axis at full hour ticks one or 8701003 several hours Quality attribute Active Inactive If active values with bad QAs are displayed differently Steplines Switches between step and continuous curve characteristics Zoom Reset the zoomed window to standard size the function is activated automatically on left click and drag Palette Bar Show hide the color bar assign colors to diagram background and curves by color drag to the selected object Pattern Bar Show hide the pattern bar to assign patterns to curves by clicking a pattern and dragging it to the selected curve Legend Show hide curve legends 10 11 Chart Properties Display properties setting for
94. ot specified Run Aun acra if not specified Run DeM acros Display Display and Print End Run Arini acro if not specified Run DeM acro3z Close WS Excel iTit was not active at Start of work on report End 8701022 Excel macro functions of a step 2 design file Run Sareh acro if not specified Run Dem acrosz Note Principally there are two ways to create your own design file 1 Use the default DefMacro32 In this context use only a copy of DefMacro32 xls 2 Use the standard macro DefMacro32 as the basis use only a copy of DefMacro32 xls In this case supplement the parts of the and Print renamed copy Close MS Excel fF s if it was not active at MyMacro as start of work on report desired The program then runs the macros Eng as per the above listing The following graphics illustrate the difference between ADP version 1 x with ADPView and version 2 x design file structures Stent DefMacro xls hy Macro xls Pastel Runblacrot PrintselSheetst 8701020 Version 1 x Macro structure Step2 DefMacros2 xls MMyMacroxls Showhlacrat Printhiacrat Savellacraly ShowMacrol Printhiacrat avellacroc 8701021 Version 2 x Macro structure Advanced Data Processing V4 0 Excel display V7 0E 8 0E In version 1 x the basic macro DefMacro xls contained all steps necessary to generate an Excel worksheet repor
95. owing the title in this example helps us explain the process for all other options In the graphic 1 Double click the graphic The graphic is now selected 2 Right click the selected graphic A context menu with various options to edit the graphic s design opens In the context menu 3 Click the Tithe menu item The following dialog box opens 73 104 Advanced Data Processing V4 0 Table display CM2B8705en_01 01 09 2006 Format Title Horizontal I Onentatron Left Horizontal Right Bottom Vertical Cancel amp Center f Center Up Apply Down Help F Word Wrap Temperatures 8673085 Optimize the graphic Select axes In the Format Title Text field 4 Enter the title 5 OK The graphic is labeled as desired Optimized graphic F Formula One Workbook Designer File Edit View Data Sheet Format Object Help SLL AON eee 1 2 i oo Temperatures 4 EST 2 oe i 20 8 9 15 10 11 10 C 12 13 5 14 15 vo lel lel lel jel el el e el la a lel lel lel e le 16 S S S S S S S 1S S S Ie 9 19 9 S 17 oS oo oS SS SS S S S G G G S 9 9 W Kaj je 18 al lal el e e e e e e ea ea al al lal lel le 19 d o t o d d d o 0 D 20 oOo Q Q Q QQARUQOAQAQaQGQQGQ 21 s 8 BB SBFEekekX kre RBR BS 22 4 gt Graph Calce
96. r this job on screen print them or save them to file Start the job Advanced Data Processing V4 0 ADP object properties For internal use only CM2B8705en_01 01 09 2006 6 8 Shortcut properties 6 8 1 Shortcut tab PdmExplorer handles shortcuts to ADP reports data series and data points as objects The example below shows the shortcut to an ADP report PDH Property Sheet Shortcut Report El energy consumption of area 1 monthly values Type Shortcut to Report Location Configuration Automation A eportslob 302 Created Modified 26 02 99 06 54 47 Bp user Target Location ADP Reports Enengy Consumption Target JEL energy consumption of area 1 monthly va Description 8701066 PDM properties Shortcut tab Header data Name type path generation date and creator of the shortcut Path for the referenced ADP report Target Name of the referenced ADP report Description This text field allows you to document the shortcut that your are editing Report tab The Report tab displays all properties of the original report Note This type of original object display does not correspond to Windows standard functionality 57 104 Siemens Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation ADP object properties 01 09 2006 Terms 58 104 Building Technologies Building Automation 7 Mapping data series to the time period of report Compression interval T
97. re marked with a dot e Simply put You want to view the default display as set by the system or the default as defined by you To do this click amp Normal and the normal view appears Toggle only between 3D and Data 3D of course is possible Click 3D All curves as well as the graphics background are displayed in the standard 3D display To return to 2D click Normal You can do this as well Click to f Values The data series is listed in rows of numbers only If you prefer a graphical display click amp Normal or 3D Using Autoscale and click Primary Y Axis Secondary Y Axis to turn the function on or off The scale of the corresponding axis automatically adapts to changes e g window size according to the criteria to make it easier to read Number of visible vertical lines incl chart border This allows for labeling the x axis at full hour ticks one or several hours You decide Click to turn on or off the attribute When active values with bad QAs are displayed differently Linking individual points not directly but via step lines horizontal continuance starting from the old value vertical jump to the new value Click amp Zoom to reduce the enlarged data series selection to the standard selection the entire data series is displayed Note e This option is available only to reset the standard selection To enlarge the selection left click and specify the selection you want
98. reen display and quality color prints If you want to assign a black amp white pattern to 3D curves select this field black amp white pattern This is especially suited for software printing This field allows you to select a combination of patterns and colors for each curve i e you can color the curves using colored patterns This is especially suited for color printing For internal use only Advanced Data Processing V4 0 CM2B8705en_01 Building Technologies Building Automation Trend display 01 09 2006 3D Cluster Color Lines Point type point size a i Marker Volume Chart properties Series tab Data series Multiple Types Point markers Show Values Borders Siemens Building Technologies Building Automation gt a E 77 TWN 3D display only Select if you want to display the curves data series as clusters on the z axis 3rd dimension 2D display only Allows you to specify if the curves are to be displayed by means of the colors defined for the data series or black amp white 2D and 3D display Use to assign a point to the data acquisition points The following point types are possible e Square e Circle e Marble e Triangle e Cube e Variable other form per series The slider allows you to adjust the point size over 11 sizes Note 1 This option is effective only when Point markers is selected in the Series tab 2 Point displays are not well suited to 3D displays Point
99. roceed as follows to compose a report 1 Step Optional Create a new folder If needed create a new folder for storing ADP reports in the PdmExplorer 2 Step Create a new blank ADP report in the respective folder 3 Step Assign the desired data series to the blank ADP report 4 Step Make all necessary adjustments in each report data series The ADP report is now defined and ready to be started either individually or as a reference in a job Step 1 Create a new folder This step is optional In the PdmExplorer you can create any number of subfolders in the ADP report folder to save your ADP reports Standard Windows NT 2000 functionality applies to creating copying and deleting folders and ADP reports energy consumption of area 1 compare weekdays energy consumption of area 1 daily values energy consumption of area 1 monthly values energy consumption of area 2 daily values energy consumptions daily values Templates ee i Air temperature outside bese b Air temperature outside E Atrium temperature average 72 Atrium temperature average 2 8701034 Pam Explorer excerpt ADP reports comprising at least one filter entry are called ADP report templates ADP report templates are best saved to a special folder 23 104 Advanced Data Processing V4 0 CM2B8705en_01 Compose and start ADP reports 01 09 2006 Step by step procedure Tip Step by step procedure 24 104 Building Techn
100. rred to the last sheet of a workbook Formula One file Without a design file the new vts workbook is used After step 3 the ADP report is displayed in its basic form as shown below For our example we will use a report with three temperatures The associated day values of October 1996 are displayed For internal use only Advanced Data Processing V4 0 CM2B8705en_01 Table display 01 09 2006 Explanation Beachte Siemens Building Technologies Building Automation Mil Atrium temperatures C APDH ADPYvizuahNew vts File View Help Al Al sampling sampling A10 67 902 A10 67 905 ATO 63 990 GRA 1014033 GRA 1014042 GRA 013030 Recorded Recorded Recorded isorik isonik isanik Atrium temperature 2nd floor Atrium temperature Sth floor Outside temperature 1 10 96 0 00 15 6 21 55 10 9 2 10 96 0 00 14 20 95 2 1 3 10 96 0 00 16 1 13 95 p 35 4 10 96 0 00 17 95 20 5 2 5 10 96 0 00 16 75 20 75 LSS 6 10 96 0 00 17 15 19 05 foo 7 10 96 0 00 18 15 20 15 10 25 5 10 96 0 00 15 1 20 05 10 75 5 10 96 0 00 17 55 15 55 11 45 10 10 96 0 00 17 65 15 5 11 2 11 10 56 0 00 17 75 15 75 10 05 12 10 96 0 00 16 75 16 65 13 10 96 0 00 l 19 45 14 10 96 0 00 20 25 15 10 96 0 00 l 21 15 16 10 96 0 00 l 19 45 8701067 ADP report outline display e Rows 1 to 9 The name defined for the report is displayed at the top left Columns B C and D contain general information on each data series e Row 10 Columns B C and D contain the h
101. s are saved in the ADP report folder 36 104 For internal use only Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation Compose and start jobs 01 09 2006 Step by step procedure Step by step procedure Siemens Building Technologies Building Automation A With the aid of the PdmExplorer KJ PdmExplorer Winter98 Internal IMA Project File Edit View Tools Help gt om or Cr AN fel ee fe eee 2 Er E W demo Description 5 A Configuration dE Atrium Temperatures Shortcut Atrium Temperatures Overview Statis E Points g El energy consumption of area 1 Shortcut Test Report on Application Area T23 98 co Series ia Measured values el energy consu Shortcut Control Values 1 Area 723 98 Filters Units E Automation EA 1 Sy Reports FEN Transfer ee ADP Reports xA 2 A Energy Consumption Measured Values E El energy consumption of area 1 i E El energy consumption of area 1 fW ET energy consumption of area 1 E El energy consumption of area 2 ely JO oa 9 El energy consumptions daily v H E Temperatures atk gt 3 abject s Ready user5 5 Vi 8701047 Link ADP reports to jobs PdmExplorer Left part of the PdmExplorer 1 Open the CONFIGURATION AUTOMATION REPORTS folder Left part of the PdmExplorer 2 Select the desired ADP report and drag and drop it on the respective job B With the aid of the PdmFinder
102. splayed matches the start time of the resolution interval then this value is used e Faulty values with a quality attribute in the data series to be displayed are not considered for display The following applies to recorded data series with spontaneous data and to recorded and derived data series with sample values e lf the data series does not supply a value whose time stamp matches that of the resolution interval s start time the last good known value of this data series is used The following applies to all other data series i e for difference mean minimum maximum and sum values e lf the data series to be displayed does not supply a value whose time stamp matches that of the resolution interval s start time the last good known value after the start time of the resolution interval is used 59 104 Advanced Data Processing V4 0 CM2B8705en_01 Mapping data series to the time period of report 01 09 2006 60 104 Building Technologies Building Automation 7 3 Examples Values to be displayed The following examples do not consider the capture range 7 3 1 Data series display with spontaneous data COV 7 3 1 1 With resolution no interval A data series without function and interval is displayed in a report without resolution indication The data series and the report are defined as follows Data series definition Report definition Add Recorded Data Series Wizard 2 2 a xi Please enter data for the
103. t With the aid of your own design file MyMacro any name for the macro the design processes were controlled by you rather than DefMacro The program attempted to call up the macro named RunMacro in your file From version 2 x the basic macro DefMacro32 xls contains all steps necessary to generate an Excel worksheet report in three sub macros Your own design file MyMacro allows you to freely edit the sub macros To do this you can also use specific parts of the DefMacro32 xls as well as change other parts in your own design file 93 104 CM2B8705en_01 01 09 2006 MyMacro step by step instructions 94 104 Building Technologies Building Automation 10 2 Create a macro file Below is a step by step description on how to create your own macro MyMacro 1 Open a workbook in Excel amp Click the menu and menu items as shown below INSERT MACRO VISUAL BASIC MODULE w Microsoft Excel Eile Edit View IEEE Format Tools Data Window Help Delala elel ol al sal us alal fox ale Rows Jarial Columne Worksheet Chart A Dialog F G H I Bage Braak MS Excel 4 0 Macro Function Hame Note Picture Map Object me A 5 E E EJ an 8701024 Insert Macro Module dialog box 2 Specify the macros you want to overwrite write your own macro for those areas where standard functionality does not cover your requirements Hint Adopt the struc
104. t of the PdmExplorer 1 Double click the desired job 40 104 For internal use only Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation Compose and start jobs 01 09 2006 Method B2 Step by step procedure Method B3 Step by step procedure Siemens Building Technologies Building Automation Direct start with predefined values via the context menu Left part of the PdmExplorer 1 Right click the desired job In the context menu 2 Click RUN The program immediately starts the job and includes all predefined settings with regard to display time span and output medium under e Context menu PROPERTIES JOB and ADVANCED tabs PDH Property Sheet Job Advanced it Job 302 Type Job Created bloditied 25 02 99 19 1455 Bp user Time Span Shown based on each Report Default Time Span i Curent ety Sliding ia ae Direct R Tr E m Safiy Ag Stop E Water ddimmayry Tine Khmm Wee trine for tam Action Print On lt default printer El Descriptio me e _ 8701052 Start job Method B2 Direct start with predefined values via the desktop shortcut Left part of the PdmExplorer 1 Right click the desired job In the context menu 2 Click CREATE SHORTCUT ON DESKTOP Windows now creates a shortcut on the desktop for the associated job On the desktop 3 Double click the shortcut A Neuer Job 8701053en The program immediately
105. t s found demo_e pdm 4 Z Atrium temperatures J Excel 5 0 E Atrium tempere gt pdm 4 Z 2 object s 8701048 Link ADP reports to jobs PdmFinder Left part of the PdmExplorer 1 Open the CONFIGURATION AUTOMATION REPORTS folder In the PdmFinder 2 Find the desired ADP report and drag and drop it in the respective job left part of the PdmExplorer 37 104 Advanced Data Processing V4 0 CM2B8705en_01 Compose and start jobs 01 09 2006 Step by step procedure Default settings Caution 38 104 Building Technologies Building Automation Step 3 Job specific adjustments You can adjust each individual job 1 Right click the desired job In the context menu 2 Click PROPERTIES The program opens the following dialog box PDM Property Sheet x Job Advanced New Job Type Job Created Modified 26 01 99 75 36 25 By pdm Time Span Shown based on each Report Default Time Span Complete Sliding Direct Stani ae a Stop fa ee ates ddim pen Wines Abe We Ar hor tim Acton Pi n default printe w Description Doo O 8701049 PDM Job properties In the Job tab 3 Change the following as needed Output medium Printer Screen File In the Advanced tab 4 Change the following as needed PDM Property Sheet Job Advanced Time Span Start Start Day on Start Month on January bd Sunday Zz Start
106. t the desired data series and drag and drop it in the respective ADP report left part of PdmExplorer For internal use only Advanced Data Processing V4 0 CM2B8705en_01 Compose and start ADP reports 01 09 2006 Step by step procedure Siemens Building Technologies Building Automation B With the aid of the PdmFinder PdmFinder Winter98 Internal IMA Project File Edit View Help Report Series Point Advanced Name PC E 7 D PdmExplorer Winter98 Internal IMA Project File Edit View Tools Help Display f v Type zl i q xX Resolution 7 Time Span EW demo Report Series Name Find Report Find Serie Find Point Stop New Search S Configuration El energy consumption of a Design File Quality Attribute 7 Points Series Filters Units Automation 5 ADP Reports Name In Folder Display Resolution Time Span Energy Consumption FEl Atrium temperature average 1 ADP Reports T Table 10 Min 3 Day Measured Values FEl Atrium temperature average 2 ADP Reports T Table 10 Min 3 Day Sl El energy consumption of area 1 FEl Atrium temperature 2nd floor ADP Reports T Table 10 Min 3 Day Sl El energy consumption of area 1 Bl Atrium temperature 5th floor ADP Reports T Trend 10 Min 3 Day F El energy consumption of area 1 FEl Atrium Temperatures ADP Reports T Tre
107. temperature 5th floor Atrium temperatu Recorded None H Energy Consumption Bo Outside temperature Outside tempera Recorded None E Temperatures Templates Find gt Air temperature outside a al Atrium temperature average 1 sol Copy al Atrium temperature average 2 9 Atrium temperature 2nd floor Moveup Alt Up E Atrium temperature 5th floor QO Atrium Temperatures Move down Alt Down A Excel 5 0 E Atrium temperature Remove F Excel 5 0 E Atrium temperature Rename F Excel 5 0 E Atrium temperatures z Properties 2 1 object s selected Ready pdm 4 YW 8701040 Display report data series open properties In the PdmExplorer 1 Open the desired ADP report All corresponding report data is displayed to the right Right part of the PdmExplorer 2 Right click the report data series The order of the individual entries determines the order of the columns when a report is printed In the context menu 3 Click MOVE UP or MOVE DWON The active report data series is moved up or down within the list The name of the data series is used as the caption for report data series e g column headings to be printed or displayed on screen To create short and meaningful captions redefine the suggested data series name in the Report Series Name column In the context menu 4 Click RENAME You can now rename the report series e The name of the data series remains as is and the new name is used only as
108. the Cl DOAIC cc ccccccceeecceceeeececeeeeeesseeceseeeeeesaneeeeas 83 9 2 8 Change window size and graphic selection cccccceeeseeeeeeeeaeeeeeeeeeaaees 83 9 2 9 Change the displayed report time Span cccccceceeeeeeeeeeeeeeeeesaeeeeeeeesaeees 83 9 2 10 ZOOM a destred ANOS issnin a E E 84 9 3 Design Drope ES cesen a a a 84 9 3 1 Basic AEsSIgMmODUONS siarce a a a 84 9 3 2 Enhanced design properties cccecccecceeeeeeeeeeseeeeeseeeeeeeeesseeseeeeeeeeeeneaas 86 9 3 3 Define the font TY DCS acasicesneseacd ty nnnentagnssoniaunsien lage cure awacsinngessanatenmmnnegn ain 90 9 4 Save Trend design PrOPertieS cccccccseeeeeccceeeeeseeeeeceeeeeseeeeeeeeeeeeesaaeeeees 91 9 4 1 ROCOCO ane nee rn a ene rt A eee oe 91 9 4 2 Assign saved design properties to a report ccccccceeceeseeceeseeeeeeseeeeeeees 91 10 Exceldisplay V7 0E 8 0E cnnan e a anand 92 10 1 Excel macro and Excel design file ccccceccseeeeeeeeeeeeeeeeeeaeeeeeeeeaeeeeeeeeas 92 10 2 Greale a macio Mecania a a acatieuieneoauie 94 10 3 Create an Excel design file cccccccseeecceeceeseeeeeeceeeeceeeeaeeeeeeeseaeeeeeessaaess 95 11 GIOS S Aor a N abate 98 MOS a a a a Aan eaatenectuateiasetanietes 103 5 104 Advanced Data Processing V4 0 CM2B8705en_01 Table of contents 01 09 2006 6 104 For internal use only Building Technologies Advanced Data Processing V4 0 CM2B8705en_01 Building Automation Table of contents 01
109. tic start via Auto Task Method A Free selection of the display type the time span and the output medium This Step by step procedure overrides default values Left part of the PdmExplorer 1 Right click the desired job In the context menu 3 Click RUN The program opens the Run Job window KJ PdmExplorer Winter98 Internal IMA Project File Edit View Tools Help E W demo E eel Eel fl 2 Q X E Description f Configuration dE Atrium Temperatures Shortcut Points SPIEL energy consumption of area 1 Shortcut Series Filters Units Ney 8 Automation S 1 E Reports Job 3C2 Run 8 Non ob Transfer Explore E L ADP Reports Erd Energy Consumption Temperatures out Copy Paste Run Job Job 3C2 x Create Shorter M Display Time Span shown Delete C As defined in each Report C As defined in Job Rename me l errs f era e G Action 4 On E 2 object s Ready as cuca 8701051 Start job Method A In the Run Job dialog box 3 Change the following as needed Display type List Table Excel Trend Time span range for which you want to display data Output medium Printer Screen File Changed information applies to all reports of this job In the Run Job dialog box 4 OK All ADP reports specified in the job are either saved printed or displayed on screen Method B1 Direct start via double click Step by step procedure Left par
110. topics Glossary Exit online help Print Quick information Siemens Building Technologies Building Automation 2 5 Online help You can open online help at any time and for all programs Both PdmExplorer and PdmFinder support context sensitive help i e each text or field offers the corresponding help text Context sensitive help is available in two ways whereby both methods are equally valid Method 1 Click the desired text or field Press lt F1 gt on the keyboard or Right click Right click the desired text or option field or right click the name of the associated field in some cases PDM uses a right click for other purposes The online help offers step by step instructions for certain tasks Help menu Start Help via the Help menu The startup page contains all topics with step by step instructions For topical searches the left part of the help program contains three tabs Contents table of contents Index search by keywords and Search full text search Shows all definitions of terms in alphabetical order Closes Help You can print the active help topic by clicking Print in the Help toolbar As soon as you click a menu or a corresponding symbol on the toolbar the status bar at the bottom of the window provides a brief description of the associated function 13 104 Advanced Data Processing V4 0 CM2B8705en_01 About this document 01 09 2006 2 6 Document conventions 2 6 1 Symbols used
111. ture of the following example copy DefMacro32 as MyMacro This way you only need to add your changes DetWacrose compatible with Excel ss and Excel97 Default Makros for PDM abDP Standard functionality WO 1L 25 11 98 mU Initial creation WARNING You must not edit here Sub ShowMacral Excel Workbooks add Excel ActivesSheet Paste Excel Columns A 4 Select Excel Selection NumberFormat m d yy hirm Excel Range 41 Select End Sub Sub PrintMacroti If Excel Workbooks Count 1 Then There isn t another workbook MsgBox Fatal Error in DetMacros2 xls PrintMacrotfi No workbook for printing Exit sub End If Excel Workbooks Excel Workbooks Count 1 PrintOut From 1 To 1 Copies 1 Excel Workbooks Excel Workbooks count 1 Close False End Sub Sub SaveMacrolfsetrFilePathandWame If Excel Workhbooks Coaunt 1 Then There isn t another workbook MsgBox Fatal Error in DetMacros2 xls SaveMacro No workbook for saving Exit Sub End If Excel Workbooks Excel Workbooks count 1 Saveais FileName strFilePathand ame Excel Workbooks Excel Workbooks Count 1 Close False End Sub 8701025 Design macros for file DefMacro32 xls The shown macro already contains the design properties 3 Save the workbook containing the macro under the name that was used in the Edit Report Template window in the Design File field For internal use only Advanced Data Processing V4 0 CM2B8705en_01
112. u Recorded None M Energy Consumption Bo Outside temperature Outside tempera Recorded None Measured Values A El energy consumption of area 1 F El energy consumption of area 1 F El energy consumption of area 1 1 Find A El energy consumption of area z A El energy consumptions daily v Kiji C Temperatures Copy Templates Pa Air temperature outside 9 Atrium temperature average 1 9 Atrium temperature average 2 Ane al Atrium temperature 2nd floor Baan E Atrium temperature 5th floor QO Atrium Temperatures 2 Properties S Excel 5 0 E Atrium temperature J Excel 5 0 E Atrium temperature A Excel 5 0 E Atrium temperatures gt 3 object s Ready user5 5 7 Moveup Alt Up Move down Alt Down 8701054 ADP object properties Remarks Access to context menu functions depends on the PDM user permissions 6 2 ADP reports properties An ADP report only contains data series references It does not contain current data lists or graphics e Assign the data series to the ADP report in the order in which you want to display them on screen e The same data series can appear several times in an ADP report e g with different date ranges e A report may also contain data series used for internal calculations in reports only and not displayed in ADP reports The data series values are retrieved directly from the PDM database each time you retri
113. ual cells contain the formulas for further calculation and reformatting In the Formula One Workbook Designer 4 Select the Calc worksheet Change to the Calc worksheet In the Calc worksheet 5 Select cell A1 Enter the following formula in this cell TEXT VALUE Data A10 dd mmm yy Comment Data A10 refers to our example and references the first date value in the Data worksheet dd mmm yy or dd mmm yy h mm with time of day refers to the desired formatting for x axis labeling Formula One Workbook Designer File Edit View Data Sheet Format Object Help Al TEXT VALUE DatalAt 0 dd mmm 8701074 Formula One Workbook Designer 69 104 CM2B8705en_01 Siemens Building Technologies Advanced Data Processing V4 0 01 09 2006 Building Automation Table display Comment 70 104 6 In the Calc worksheet cell A1 Click the small square at the lower right corner of the cell and drag the selected cell by pressing the left mouse button to cell A32 F Formula One Workbook Designer File Edit View Data Sheet Format Object Help Al TEXT MVALUE DatelAl 0 dd mmm y O A C 01 Oct 96 J2 Oct ab J3 Oret G6 05 Oct 96 Oh Oct 96 OF Oct 96 ne Oct 96 an do iet DE 8701075 Formula One Workbook Designer 1 2 3 4 5 ERGI ees 6 T B The date for range A1 to A32 is now saved in the new text format and can be used by Formula One for x axis labeling of t
114. ulations Raw Data la Ra Ready Sum 0 NUM 8701026 Raw Data tab of the Excel design file 3 Reorganize the data in the new worksheet if necessary 4 Display them in graphic form on the first worksheet by using the Chart Wizard The fields to be evaluated are transferred similar to the procedure in Formula One Charizard Step 1 of 5 EAE IF the selected cells do not contain the data you wish to chart select a new range now Include the cells containing row and column labels if you want those labels to appear on the chart Range F awD ata 41 10 6 1 78 Cancel Back Next gt Einizh 8701027 Excerpt of the sequence ChartWizard for the Excel design file 95 104 Advanced Data Processing V4 0 CM2B8705en_01 Excel display V7 0E 8 0E 01 09 2006 96 104 Building Technologies Building Automation 5 Define the design details such as graphic type labeling scale and other general layout characteristics 6 Select all entries but not the formats in the cells of the worksheet containing the raw data and delete them via lt Delete gt 7 Save the workbook under the design file name used in the RunMacro Select the Excel folder under PDM ADP You can now open the report which should appear in Excel as follows X Microsoft Excel Fie Edit View Insert Format Tools Data Window Help ollella alris Xale ajaj A zl Li 20 roo z On a ap d Bl ll SSS Bll l a wa es
115. use this display for new projects as it will not be supported in the future Use Excel rather than Table This part of the program is supported by two special help files VCF1 hlp and VCFI hlp 8 1 What is Formula One Formula One is a spreadsheet program integrated in ADP When you create an ADP report in Table display the report is then displayed in Formula One With Formula One you can change an ADP report s design This design can then be saved in the form of a design file and reused for other reports If an existing design can be used for the planned ADP report simply select the design file s name extension vts in the Design File field when designing the report Normally Siemens Building Technologies creates Formula One reports As a result the sections below only briefly discuss Formula One Formula One is documented in a separate English language manual 8 2 How to generate a design file 8 2 1 Step 1 Create an outline display 1 Create a new blank ADP report in the Table display as needed Link the data series to this ADP report Enter any report specific adjustments See also How to create an ADP report in the program s online help In the PdmExplorer 2 Right click the associated ADP report The PdmExplorer opens the context menu In the context menu 3 RUNor RUN The ADP report appears in outline display If no special design is assigned to a report the data series are always transfe
116. vertical line with the exact time stamp appears The exact value of the data series for this point in time is displayed in the curve legend e To remove the vertical line click amp the hotspots 7 to the left or to the right outer border next to the time stamps of the x axis Additionally all quality attributes other than O 0 is not displayed for OK are displayed This proves especially helpful for values with quality attributes 7 6 8 8 which are not displayed in the curve Note QAs are displayed only if activated in the report 9 2 4 Assign a data series to the primary or secondary y axis It may sometimes prove useful to assign one of the displayed data series to a secondary y axis located to the right of the graphic Proceed as follows e Click amp the desired data series on the curve e Click amp Secondary Y Axis in the open menu amp Note When Autoscale is active the partition of the secondary y axis is oriented to the bandwidth of the existing values e f you want to reassign the values to the left axis Repeat the above procedure and select Primary Y axis Note You cannot hide the left y axis e click the legend of the desired data series selects the curve e Inthe Series menu click amp the desired axis 9 2 5 Show data series names You can show or hide the curves and the names of the data series for each curve The names are shown to the left or the right in dependence of the assigned y axis Proce
117. ves to a few general comments on using the database Available in English only This user s guide is intended for Siemens Building Technologies technical personnel or authorized contractors only It contains extensive information on the PDM and ADP engineering process and installation and PDM program group setup For internal use only Advanced Data Processing V4 0 CM2B8705en_01 About this document 01 09 2006 2 3 General Validity This document is valid for ADP version 4 0 Contents and This document contains all information to enable you to quickly use the fully installed target audience ADP program Note ADP is not available as an independent program on your installation All ADP functions are available in the PdmExplorer When installing ADP the PdmExplorer is expanded by the corresponding ADP objects As only Siemens Building Technologies specialists are authorized to install and configure ADP detailed information on planning installation setup etc is available in the engineering manual only Caution All users with access level 2 or higher can irretrievably change or delete certain data For this reason we recommend that even professionals read all chapters relevant to their work prior to carrying out any operations Product errors If you find errors or discover inadequate product or documentation information please Missing text notify the Common Support of Siemens Building Technologies Building Automation Doing
118. ways set in quotation marks Buttons are always printed in brackets Example When you click Cancel the Example Save This is a prompt to click Save Names of menus and menu items are printed in SMALL CAPS Example Select NEW METER from the DIMENSIONS menu to Individual steps of instructions to be performed in a specific order are separated by a slash Example SYSTEM METER Right click NEW METER This tells you to right click the METER menu item in the SYSTEM menu A submenu opens Select the NEW METER menu item In the instructions right click and double click amp are specially noted Otherwise left click amp is assumed _ Right click in most cases opens the context menu The date and time settings depend on the settings of your Windows installation Windows NT 2000 Start gt Settings gt Control Panel gt Regional Settings Year 2000 compliance If year numbers are entered with just two digits the following assignments apply 50 99 1950 1999 00 49 2000 2049 In CC as well as in PDM DataComm and DataEdit the following applies to the leap day February 29 for the years 2000 2004 2008 and future leap years First set the day to 1 then select the month and year and then set the day to 29 The system accepts this procedure but you cannot save this date This procedure is required as the date is checked for plausibility when entered The program prevents entry of
119. y one value per interval is to be displayed in the report Report display In the report the spontaneous values are moved to the start point of the next resolution interval i e to the right Among multiple values the value closest to the interval limit is displayed If values are missing the last known good value of this data series is used e oe Interval 1 Interval 2 Interval 3 Interval n 8734j97 Display with report resolution t 61 104 Advanced Data Processing V4 0 CM2B8705en_01 Mapping data series to the time period of report 01 09 2006 7 3 2 Data series display with sampling values 7 3 2 1 With resolution no interval A data series with compression function sampling value is displayed in a report without predefined resolution The data series and the report are defined as follows Data series definition Report definition Add Recorded Data Series Wizard 2 2 a xi Add Report Wizard 2 2 a x Please enter data for the new Recorded Data Series Piana araar cate for thet boat Function Sampling Display Trend Interval Hor Resolution Noe H Bam aooo Unit aes Storage Days sod Description R Time Spari 1 Week v ea i Quality Attribute T Description lt Back Conce 8734098en 8734099en lt Back Corcel Report display The time stamps for the values are displayed in th

ADP Advanced Data Processing V4.0 User`s manual

Contents

Download Pdf Manuals

Related Search

Related Contents