Home

AVTrend Manual

1. Client Database Schema Timestamp Client Database Schema Version Id Client Database Schema Version Number Client Build Timestamp Client Build Version Client Product Version 7 23 2010 3 14 16 PM 19d9b0d3 79b3 440 1 ad 5c ed 200207 4058 5 3 2010 10122 PM a6 39 7b90 8al 8 4ea5 Sb0S 9 bcd 4004 6 26 2010 30644 AM 2010 0626 1 2 0 0 Alpha b Server Database Schema Timestamp Simar Database Schema Version Id Server Database Schema Version Number Server Build Timestamp Server Build Version Server Product Version 6 3 2010 10122 PM ab397b90 8al 8 4ea5 Sb05 9S 4004 6 26 2010 30200 AM 2010 06 25 1 2 0 0 Alpha Software Version Report Reports gt Internal Reports 82 Agilaive AV Trend Manval Chapter 5 Reports Log Book Report The LogBook Report generates reports of logbook entries that were made in the LogBook Entries Editor To query a LogBook Report select LogBook Report from the Reports menu Select Start and End Dates and a Site Name from the top section of the screen and click the Generate Report icon in the upper left section of the screen The user may also choose one or all Logbook Categories as a filter for the report The logbook report will be displayed in the lower section of the screen ji BAP SHO we Add eh Pewee O2_zxox 31 Dec 2005 05 00 to 31 Dec 2012 06 00 Logbook Report Event Time 2 15 2006 16 16 LogBook Report 83 Agilaive AV Trend Manval Chapter
2. select a Logger Type from the drop down list e g 8832 and click Enabled optionally you can enter a Description and select Debounce Digital Inputs Click the Save button Du _ ar TT Wesel Logger Configuration from Logger Channels in Configuration Editors 20 Agilaive AV Trend Manval Chapter 2 Configuration Adding an In trument If AV Trend is licensed to poll and instrument directly without using a data logger select Configuration Editors Logger Channels and highlight the site name in the Logger Channels configuration tree diagram Click the Add button and select Instrument The Instrument Type ID field is required and can be selected from the drop down list Enter a Source Name an Instrument Identifier and Instrument Password and click the Enabled box Click the Save icon GD Logger Channels TOERE x aye ANiaion D intrument dam x f Aglare ta BAM Source Communication A a Logged Source information Instrument Deta Average Alarms Channels Sher Agas Inatrumert Type Met One Bam 1020 A OZONE SouceName fam Enabled v AO D escnpion Inatrumert Identifier A N02 A Swe Inatrumert Password A GMA x a NO etry ABenoti 33 A NOx Instrument Configuration from Logger Channels in Configuration Editors 21 Agilaive AV Trend Manval Chapter 2 Configuration Adding Channels to Data Loggers Still in the Configuration Editor Logger Channels select a Logger that has already been added to a Sit
3. Additional Ribbon functions Print or Export the Chart or the Grid HTML CSV XLS BMP JPG etc Select a range of data in the grid and open that data in the Data Editor Adding Annotations To add an annotation to the realitme graph first make sure Show Grid is enabled then right click to select a range of data and add your comment 112 Agilaive AV Trend Manval Chapter 4 Data Editors Average Interval 00im Minute average from instantaneous Y Number of Hours in Lookback POE fe Use Dynamic Scaling Suppress Reading Flag Colors In the graph criteria the user may select several customizations Number of Hours in Lookback This allows the user to dynamically define the width of the graph After changing the user should select Manual Refresh from the ribbon to take effect This preference is stored with any Favorite created Use Dynamic Scaling If selected the data graph min max is set based on the range of data rather than the graph min max configured in the Parameter settings editor Suppress Flag Colors If not selected flagged data will be shown with dots with colors based on the Flag configuration If selected data will just be shown as the trend graph color In both cases hovering the cursor over the point will always show the flag and the flag colors are still represented in the tabular grid display 113 Agilaive AV Trend Manval Chapter 4 Data Editors Right Click Vata Within the Re
4. 5 Ba b Reet I E arise Sorts ee aad p euenien tant a Oe iar ste l toota f mns a ote _ orm Ps imo sn CMO CSE W we SAL Oo ue EARO ms KMEN NAA CA ws ADAD mo Vea eunw may CWA IDW ow xm N ins CRD m0 R28 Otc 00 ime UMOMA ma peona EMA DONO wae PP gt a ff 4 gh gh ge gh OP gf DP Valawienw w E oe PE EE A a E a oreo D 196 ad 5 ai 5 ewmomn Jo Wit Retr Woe rene eT retin THR LOT Vere TOD eine Rte PION TPE ONODI 1738 Realtime Graph in Status Displays gt Real Time Trending Graph showing both Chart and Grid 110 Agilaive AV Trend Manval Chapter 4 Data Editors BEEZz iE cCEREESRRSEERESEE FRESESEREERERRREEL EGS ESSSEREREESEECSCTE PESERELEELE Realtime Graph in Status Displays gt Real Time Trending Graph showing Chart only 111 Agilaive AV Trend Manval Chapter 4 Data Editors Hover the mouse pointer over a data point on the graph to see details of exact time and value logViewer gi im Bend wil Realtime Data Tending x Resttine Criteria O Bowt_S 01_OZONE 00ih 280 Diount 5 1 02_PM25_MC 00Ih Obot 5 00 TEP COIh 2 O BowtS 00 WS 0 ih doot S 10 wO 001h mo Bount S 1J RAINFALL COIh 220 200 P j9 K n a T A s ae a ia Re oP Pd lt lt s 9 Vv E s Coad so s Ko 3 Realtime Graph in Status Displays gt Real Time Trending Graph with mouse hover on data point
5. Channel Configuration Report Reports gt Configuration folder gt Channel Configuration Report 75 Agilaive AV Trend Manval Favameter Configuration Keport To run a Parameter Configuration Report Reports gt Configuration folder gt Parameter Configuration Report select a Site or Sites and a Parameter Name or Parameters Names Click the Generate Report icon on the Ribbon Parameter Configuration Report Agihire Repared Craph Name Dercridon Temele PRM Pedia Unis Mini Maximum WDR Wud WDS_HICH 4 3 DEG e 30 D HghLevel wee Windspeed WSP HICH 4 b KPH o 1 Hagh Level noe Nitric Ozide NO2 o 3 PPM o s0 no Nitrow Oxide BO 4 3 PPM te xD NOX Ords of WOX 4 3 PPM o pati Nitrogen Thrarsday Meech 17 2011 Parameter Configuration Report Reports gt Configuration folder gt Parameter Configuration Report Intrenet Lsede Revert InRever Aistow Fabe Fabre Fabe Fabe Fise Fabe Fade Fabs Fabs Tile Revert in Tre Tre Tree Troe Tre Chapter 4 Reports Enblet POC Method Unis Paramene Tre Tre Tre Tra Tre AQS Coder oor te nm oor 4200 oor t or aD Page l of 1 76 Agilaive AV Trend Manval Chapter 4 Reports Scheduled Tasks Report To run a Scheduled Tasks Report open Reports gt Configuration folder gt Scheduled Tasks Report and the report will be displayed automatically No query is necessary Scheduled Task Report Task Name Description Enabled Sta
6. Enter a Digital Event Program Name a Starting Time Output Durations Repeat Interval and check Enabled 4 If the Digitally Timed Even is for a calibration select a Calibration Name from the drop down list 5 Click the Output Lines button to bring up the Line Status Pattern screen and select a Line Number Click OK 4B Logger Channels p x Se AVTiend r loggertogger 01 El tvent Programe BJevent Program x E Aglare Timed Event Details ji BAM Sm Logger 01 Digital Event Program Name Output Duration S Seconds 28 Average Alarms Starting Time 03 08 2012 14 17 Repeat Interval 3 Day s j A wR Ka WSP Select Calibration Name J Enabled A N02 Calibrations Output lines Digtal Evert Programs a iTO Modbus Instruments lt PEA gt Profile MP_SERVER Version 2 2 2 Build 2011 02 16 3 3 8 2011 1418 Configuring Digitally Timed Events 42 Agilaive AV Trend Manval Chapter 2 Configuration O Line Status Pattern Select LineNumber Name OutPut Line2 OutPut Line3 OutPut Line4 OutPut Lines OutPut Line6 OutPut Line7 OutPut Line OutPut Lined OutPut Line10 OutPut Linel1 OutPut Line12 OutPut Line13 OutPut Line14 2 3 4 5 6 7 8 9 Line Status Pattern for Output Lines Configuring Digital Triggered Events I 2 3 Highlight the Data Logger in Configuration Editors gt Logger Channels tree menu Click the green Add button in the ribbon and select Add
7. Number of days back from current day 65 Agilaive AV Trend Manval Chapter 4 Reports In addition the time criteria e g the star icon button allows you to choose shift forward one day or shift backward one day If you select one of these and hit apply it acts similar to the Data Forward or Data Backward buttons except always shifting by 24 hours rather than the size of the data window This is useful for reviewing calibration minute data for several days where the calibration falls on the same time each day Scroll to select an Average Interval most reports only support one average interval at a time Click to select a site and parameter use standard Windows Shift Click and Control Click conventions to select multiple parameters Filters Filter fields are available in the top row of each AAE P RE column Click in the row to use the filter to list hinaa a single site parameter or parameter template a TE NEPIA ENAERE Click the down arrow to the right of each filter 2 ac e 3 a r Slount_s 11LAMD TEMP AMBTEMP field to select a particular entry in the column Seca ILAND Ee are Choices in the drop down list will be Custom Roane Y 12 AMB TEMP AMBTEMP Blanks Non blanks plus each entry in the Union 11 AMB TEMP AMBTEMP column site name parameter names or parameter templates EE Filter fields in Reports criteria pane To write your own criteria select Custom and configure the screen that
8. Reports Logger Reports The Logger Reports folder in the Reports menu contains the following reports Alarm Journal Input Line Status Report Power Failure Report Alarm Journal The Alarm Journal displays the Site Name Channel Number Channel Name Alarm Program Name Alarm Start End Time Reason Code and Triggering Flag To run an Alarm Journal select Reports gt Logger Reports gt Alarm Journal In the Report Criteria screen select a Start End Date and a Site Source Name Click the Generate Report icon A Logger Alarm Journal Report will be displayed in the bottom section of the screen Logger Alarm Journal Report Sie Name STTEONE Logger Identifier 01 Logger Name Logger 01 Channel Number Channel Name Alarm Program Name Alarm Start Time Alarm End Time Reason Code Flag Triggering 2 test2 TEMPOUT 2 12 2008 60800 AM 2 12 2008 84300 AM k 2 test2 TEMPOUT 2 12 2008 82700 AM 2 12 2008 83500 AM k 2 test2 TEMPOUT 2 12 2008 83700 AM 2 12 2008 84000 AM k 2 test2 TEMPOUT 2 12 2008 84200 AM 2 12 2008 84500 AM k 2 test2 TEMPOUT 2 12 2008 84900 AM 2 13 2008 70500 AM h 2 test2 TEMPOUT 2 12 2008 23700 PM 2 12 2008 4 1200 PM k 2 test2 TEMPOUT 2 12 2008 834 00 PM 2 12 2008 9 5000 PM h Logger Alarm Journal Report 84 Agilaive AV Trend Manval Chapter 4 Reports Input Line Status Report The Input Line Status Report displays Site and Logger Name Logger ID Line Number Line Name Line State Time of Change and Line Description To r
9. gt PC Configuration by highlighting the Server icon and clicking one of the Add buttons w om x Serial Connection Details Route Name Enabled Comm Port oe Baud Rate 3600 r Data Bits a Stop Bits 1 v Parity None v Advanced Read Timeout 7 v as Write Timeout Y Ed Disconnect After z v es Inter byte Delay ms Adding a Serial Route in Configuration Editors gt Logger Channels 29 Agilaive AV Trend Manval Chapter 2 Configuration Configuring Communication Rovtes gt Important Communication routes must be added AFTER TCP or Serial Routes are configured in Configuration Editors gt PC Configuration To add a Communication Route open Configuration Editors Logger Channels double click the Source data logger or instrument in the tree diagram and click the Communication tab Highlight the first empty row Click the arrow in the first column to select a Route If no routes are in the drop down list click the Add Device Route button and the logger should be in the drop down list Assign a Priority number Select Polling and or Emulation if applicable Optionally enter an Initialization Command and and a Final Command Click the Save button wm logge 0Slogger X Source Communication IO labels Math Constants Aj Communication Routes Create New Route A amp a a a K w v Profile HP_SERVER Version 1 0 5 Build 2030 04 25 1 6 22 2010 11 46 Associating Data Logger with TCP IP conn
10. summary of all annotations it finds To see a report of annotations made in the Average Data Editor open the Reports menu and select Annotations Report Make the usual query selections of Start End Date Average Interval and Parameter s Click the Generate Report icon on the ribbon Current Date 9 28 2010 Current Time 9 10 PM Annotation Report O1 Mar 2006 00 00 to 06 Mar 2006 00 00 Site Roane Y Parameter 92 802 Category User Name Annotation Date Date Annotation Instrument Admin 28 Sep 10 21 10 01 Mar 06 20 00 Lightning strike Failure Maintenance New User 25 Sep 10 21 09 01 Mar 06 05 00 Replaced pump seal Maintenance New User 28 Sep 10 21 09 01 Mar 06 06 00 Replaced pump seal Qi Note FredS 28 Sep 10 21 09 01 Mar 06 09 00 Quarterly Audit Qa Note FredS 28 Sep 10 21 09 01 Mar 06 10 00 Quarterly Audit QA Note Freds 28 Sep 10 21 09 01 Mar 06 11 00 Quarterly Audit Annotations Report 69 Agilaive AV Trend Manval Chapter 4 Reports Calibration Results Calibration Results show the calibration event and results for any zero span precision check or other calibration program Current Date 3 9 2009 Current Time 3 47 PH R r Calibration Report Site SITEONE Source Logger 01 Date 02 Jul 2008 Parameter Sequence Phase Start Time End Time Value Expected Error Value testl TESTCAL PHASEL 00 00 00 00 01 00 1 123 1 12 35 Calibration Report 70 Agilaive AV Trend Manval Calibration Trend Caraph C
11. 13 Input Line 13 Off On F 14 Input Line 14 Oof on v O_O e OR AND Configuring Start Pattern Line Status Pattern in Externally Initiated Calibrations in Configuration Editors gt Logger Channels 38 Agilaive AV Trend Manval Chapter 2 Configuration Configuring Instrument Controlled Calibrations If you configure Instrument Controlled Calibrations enabled calibrations will be initiated by the data logger when it detects a specified digital input pattern Each phase will continue until the input line pattern changes The Instrument Controlled Cal screen has the following fields Calibration Type will be already filled in InstrumentControlled_I Calibration Name is required to identify the cal program Check Enabled if the calibration is to run Number of Calibration Records determines how many cals the data logger will store before overwriting Recovery Time specifies the time required to purge cal gas after phases Affected Channels determines which channels will be taken off line during cal Select from a list of previously configured parameters Configuring Instrument Controlled Calibrations from Configuration Editors gt Logger Channels 39 Agilaive AV Trend Manval Chapter 2 Configuration Configuring Interactive Menv Calibrations If you configure Interactive Calibrations enabled cals will be controlled by a user via a menu interface Interactive cals are often used for highly manual
12. 6 2 2010 6 00 PM 6 2 2010 6 10 PM 6 2 2010 6 00 PM 6 2 2010 6 15 PM O 0 94302392 6 2 2010 7 00 PM 6 2 2010 7 05 PM O 1 2476 68 6 2 2010 7 00 PM 6 2 2010 7 10 PM 2 0 099208 6 2 2010 7 00 PM 6 2 2010 7 15 PM O 1 27934455 6 2 2010 8 00 PM 6 2 2010 8 05 PM O 1 15639686 6 2 2010 8 00 PM 6 2 2010 8 10 PM 2 0 040419 6 2 2010 8 00 PM 6 2 2010 8 15 PM O 0 07644 6 2 2010 9 00 PM 6 2 2010 9 05 PM O 1 57154619 1 57154619 6 2 2010 9 00 PM 6 2 2010 9 10 PM 2 1 9 92111 3 9492111 6 2 2010 9 00 PM 6 2 2010 9 15 PM 0 0 600316 6 2 2010 10 0 6 2 2010 10 0 O 1 54926729 6 2 2010 10 0 6 2 2010 10 1 2 0 955369 6 2 2010 10 0 6 2 2010 10 1 EN Historical Calibration Trend Graph T2 Agilaive AV Trend Manval Chapter 3 Reports If you select Response Graph from the Ribbon at the top of the screen you can review fine resolution data during each calibration cycle to see instrument response Each cal can be cycled through using the Forward Back button You can change the color scheme by selecting a Graph Theme from the drop down list at the bottom of the screen gt gt gt id iad S g P oF oF PLLLELAL LLL ELE PLL LLL LL Calibration Trend Response Graph 13 Agilaive AV Trend Manval Chapter 4 Reports Configuration Reports Configuration reports consist of the following Calibration Configuration Report Channel Configuration Report Parameter Configuration
13. Digital Events gt Triggered Event Enter a Triggered Digital Event Program Name an Output Duration and check Enabled After the output duration time period the program will check the digital input pattern to see if it still matches If not the output control lines will be switched off If the pattern still matches the output relays will remain on and the duration time will begin again If the Digitally Triggered Event is for a calibration select a Calibration Name from the drop down list Click the Output Lines button to bring up the output Line Status Pattern screen and select which Output Line or Lines will be switched on when the triggered digital input pattern occurs Click OK 43 Agilaive AV Trend Manval Chapter 2 Configuration 6 Click the Trigger Digital Event Pattern button to bring up the Line Status Pattern screen for Trigger Digital Input Pattern and select which Input Line or Lines turned On or Off will trigger the event and switch on the specified Output Line s 7 In the lower left corner of the screen select And or Or If you select And the default the digital event program will be triggered only if ALL the specified conditions occur If you select Or the digital event program will be triggered if ANY of the specified conditions occur Click OK Line Status Pattern Trigger Digital Input Pattern Name Input Line 1 Input Line 2 Input Line 4 Input Line 5 Input Line 6 Input Line 7 Input Li
14. Reading Updater Tak Scheduler E logbook Report Mp Basic Data fxport Wp Comration Cxpectes Values talor Site New Source tame Prase tiumoer MW Expectes value tam Corman a j al Expected Value Pom Constant BS N OL NOK 0t INOR Site Meme OLOUNT LO items Source tume Prase Numo r wa v bpecsa valve tom Constant 33 SERPREREES SATELEE T amp 888s lololo so 3 Site Name ELOUNTI 11 tems Source Name tapected Value bom Constant 7 n 7 3855 SBlo ooo n v 4 y v xn o Site Name CARRIDGE 25 tems Scarce name 5 cane Expectes value tom Constant ne s EREE T TEIA Prot ZENBOOK Versione 2792 Said IOIDUIGS IVER V22 i When values are saved a pop up window will prompt you to download changes to the data logger 8816 and 8832 only Clicking OK will take you to the Logger Download form where you can select the checkbox to only download the expected values Download Changes Save impacted expected value results for an 8832 or 8816 Data Logger would you like to download them now 34 Agilaive AV Trend Manval Chapter 2 Configuration Configuring Automatic Calibrations If you configure Automatic Calibrations the cal you enable will be automatically initiated by the data logger s internal clock The Automatic Cal Sequence configuration screen has the following fields Calibration Type will be already filled in Automatic_A Calibration Name is r
15. Report e Scheduled Tasks Reports Calibration Report Site Configuration Report Calibration Configuration Report To run a Calibration Configuration Report Reports gt Configuration folder gt Calibration Configuration Report select a site or sites and click the Generate Report icon on the Ribbon Calibration Configuration Report Agilaire Repeat Recovers Phase Response Affected Calibration Name Start Time Interval ime Phase Name Number Duration Time Status Pattern Channel Amo 1 0310110000 01D M Zero 1 OSM 0M 1 No Wednesday March 16 2011 Page l of 1 Calibration Configuration Report Reports gt Configuration folder gt Calibration Configuration Report 74 Agilaive AV Trend Manval Chapter 4 Reports Channel Configuration Report To run a Channel Configuration Report Reports gt Configuration folder gt Channel Configuration Report select a Site or Sites and a Parameter Name or Parameter Names Click the Generate Report icon on the Ribbon Channel Configuration Report Agilaire Anaks Secondary Inout Felling Paces See Lec Chonnal Bord bntervab Storage ieu Imt bout Owtut eteen aput internal intensi Duration Nme Unit Impe Omiin Bae Ext Ext Be Ext Ext Camel Charmel Hid Low Hih Ler Uia Channel Nime Mome Enteral DEO 1 i EDH t t oa Logpe 01 ot wo mu A t tm Olen OO 7D sp 3 Paes Fue Fuse 36D sib in Olen lh 7D Mim Clee Oh 7D Wedreeday Mach 16 2011
16. Windows Savin t mase Legim Re qoeest IVITEM User ClienelPeMm_Server 27 16 2209 09 28 2010 L003 BSR HP_Sere Aa Vision Window Saria r cuaxe LOGIE FOCCESITVL CIVSTEM Ure r AieVision ChienelPP_Jerver AIt 16 1 205 Tee sh oniD Sed 4s aloe dbeT bekF FPeatHORFLOT Vr erT De DOS 40PL 4005 00L1 9be T Hodes consesa 00 28 2010 10 03 4383 HP Sara Ak sva WindowsSarm tomare Tound rect level tasks 0928 2010 1003 DOG HP Seve ASVe ke Widow Sark theme Login Re qeert VIER Urer airvision ChienelPNP_Jerver AT 16 1 208 09 20 2010 1003 SKE HP Sere Am Vision Windows Saree t cetice LOGIE FULCESITVL USER WeetAieVi sion Clienel Pe NP Jerver ATE 16 Jes sh ond D LIDADES 4e7b 408t 9O8F 8 9TH esaSI A Us ee De DOS EAA rth Sai 1b t LITE contesz Journal Message Log Reports gt Internal Reports gt Journal Message Log 81 Agilaive AV Trend Manval Software Version Report Chapter 4 Reports The Software Version Report Reports gt Internal Reports gt Software Version Report displays Timestamps for Database Schema and Software Builds Version IDs and Software Version The Software Version REport is primarily used for troubleshooting in the event of unusual software behavior ciara resents ease esabanas cnapaben imenanen spasasmneaents incrants maubiisaenenanasanas enasanen anananananasanen miasabusancrast Software Version Report Database Schema Timestamp Database Schema Version Id Database Schema Version Number
17. a new screen will pop up for the Sub Task you selected Fields in the pop up screen vary according to which sub task is selected Advanced Options in the pop up screens not required allow configuration of Number of Retries and the Interval between Retries When you configure the Sub Task and click OK in the pop up screen the new Task Name will be added in the Sub Tasks section The Task Name can be modified a3 Agilaive AV Trend Manval Chapter 2 Configuration Select the Fail Group on Error column in the Sub Tasks section if you want the whole Task Group to stop running if an error occurs Task Type in the Sub Tasks section indicates the sub tasks that are part of one group task Click in the Edit Task field to make changes in the same pop up window that came up when the Add Sub Task button was clicked To remove a task from the Task Group select the task in the Sub Task section and click the Delete Selected Sub Task button B Task Scheduler HPSIRVER opger Pon Tosi A Logger Pol Tasi ONO F a Data Logger Poil fal Ri HP SERVER _ Scheduled Report Tait n Report Dsk _oaor01 LLES 30 Generates Report at signed time for output E Ge Pee he Grove m Cuen baana baad Soeneesas toes nananana skalaen ahaa d lyi A Task Group Configuration Editors gt Task Scheduler gt Add gt New Task Group 54 Agilaive AV Trend Manval Chapter 2 Configuration Schedule Task Wizard The Task Wizard can be used to manage dozens
18. filter data from website Select a data type Average Continuous Composite Sample or Particulate Sample for manually entered non continuous data Enter a brief description of the parameter optional Enter an EPA Parameter Occurrence Code if needed POC is used for different monitors measuring the same parameter at one site EPA sampling Method Code 17 Agilaive AV Trend Manval EPA Units EPA Parameter Reported Digits Precision Truncate Round Rule Reported Units Analyzer Units Graph Minimum Graph Maximum Calibration Span Instrument Detection Limit DL Limit of Quantization LOQ Chapter 2 Configuration Select EPA Units including the EPA unit code from the drop down list e g 007 parts per million 015 degrees Fahrenheit Select a parameter including EPA parameter codes from the drop down list e g 44201 Ozone Total number of digits including decimal places that will be reported to the EPA Number of decimal places for reporting precision X s and Y s to the right of the reporting precision field illustrate the format of the digits precision e g XX YY indicates a total of four Reported Digits with a Reporting Precision of two Determines whether data in reports will be rounded or truncated Units that will be used for reports e g PPM If the analyzer units are different from the primary parameter select analyzer units from the drop down
19. list Lower y axis limit for graph display Upper y axis limit to for graph display This field is determined by the instrument Enter the configured calibration span value for the parameter to determine the parameter s calibration error at the data logger Minimum concentration of an analyte that can be measured by an instrument The DL is an estimate of concentrations at where you can be fairly certain that the compound is present Concentrations below this limit may not be detected Used for air toxics measurements only can be blank if not needed A minimum criterion or region for quantization that should be clearly above the detection limit The lowest concentration of an analyte in a sample that can be determined quantitated with acceptable precision and accuracy under the stated operational conditions of the method Traditionally this is approximated as 10 times the signal to noise S N ratio 18 Agilaive AV Trend Manval Minimum Detectable Limit MDL Practical Quantization Limit PQL Parameter Report Order Totalize in Reports Minimum in Reports Additional Information Chapter 2 Configuration EPA defines the MDL as the minimum concentration of a substance that can be measured and reported with a 99 chance that the analyte concentration is greater than zero The lowest concentration of an analyte that can be reliably measured within specified limits of precision and accuracy during rou
20. nandaan M editor select the data logger PADa in the tree diagram and select Modbus Instrument Name Primary O3 Add gt Logger Modbus Instrument Driver Type API_O3_400E v Modbus Code 40 Modbus Command Type 4 Poll Interval 100ms 20 eg 5 5s 10 1s 15 1 5s Tcp Ip Address 192 168 1 40 Top Ip Pott 502 Modbus Instrument Details in Logger Channels Enter the following fields Instrument Name a user defined label for the instrument Driver Type select from picklist of known analyzers Modbus Code also known as the Modbus Device ID this ID is set in the analyzer and is some value from 1 255 Modbus Command Type defines which Modbus command is used to read data from the analyzer 3 for TECO 4 for API consult instrument documentation for other brands Poll Interval how often data should be requested from the instrument in tenth of a second increments Generally a rate of 20 30 seconds is recommended TCP Address IP address of the instrument as viewed from the B Modbus El channet chanie x logger s perspective Channel Validation Misc TCP Port Port used by the ee instrument for Modbus requests Modbus Instrument Primary 03 v usually 502 Timeout MS Designates the Driver Ce time the logger will wait on an instrument fora Modbus response Typical values are 250 750 MS Misc tab in Add Modbus 25 Once the instrument is configured and saved you can then select Add gt
21. of the screen minimizes the selection criteria to make more room for the graph o rnr BLUE Retrieve Export Matrix linear Cross 98 Agilaive AV Trend Manval Chapter 4 Data Editors Use the mouse scroll wheel to zoom in or out right click and hold to drag the zoomed graph to a different data area Hover the cursor over a data point to see the specific date time and data value If there is a flag on the data point the flag will also be displayed You can toggle between hiding or showing invalid data e g data during calibration maintenance or analyzer failures When graphing parameters with two dramatically different full scale ranges you may choose to use the Dual Y Axis Scale option When choosing this option you must also choose the percentage e g 10 20 of the full scale range that is used as the breakpoint for the secondary Y axis A value of 20 is common Note that this function requires that Graph Maximum and Graph Minimum be set in the Parameter configuration Graphs that have any parameters without limits configured cannot use the Dual Y Axis function Suppress Flag Colors If not selected flagged data will be shown with dots with colors based on the Flag configuration If selected data will just be shown as the trend graph color In both cases hovering the cursor over the point will always show the flag and the flag colors are still represented in the tabular grid display oe Expo
22. pops up Enter filter criteria for Site Name Operator And condition r conditions Equals Does not equal Add a condition lt Less than Less than or equalto gt Greater than Greaterthan or equalto Like Cancel Matches Regular Expression v Custom filter criteria screen 66 Agilaive AV Trend Manval Chapter 4 Reports Click the box with the letter A in the left side of each filter field to change the filter field from the default of Starts With to one of the following Equals Does not equal Less than Less than or equal to Greater than or equal to Like Matches Regular Expression Starts with Contains Ends with Does not start with Does not contain Does not end with Does not match Not like For example if you imported E DAS data and used the option to put the channel number in front of the channel name you might end up with some ozone channels that were 01 OZONE while others were 03 OZONE and 04 OZONE Using the boxed A filter you could search for all parameters names that contain Ozone and more easily select them from a large list of parameters Using a filter makes it easy to see a Parameter Template for was not set for 3_AMB TEO AMB_ TEMP Parameter Selection Drag a column header here to group by that column Ea Site Name Patameter Name Parameter Template CB ee a e o Biount 11_AMB_TEMP AMBTEMP Blount2 12_AMB_TEMP AMBTEMP Br
23. procedures such as testing opacity instruments against standard filter Interactive Cal configuration screen has the following fields Calibration Type will be already filled in Interactive _M Calibration Name is required to identify the cal program Check Enabled if the calibration is to run Number of Calibration Records determines how many cals the data logger will store before overwriting Recovery Time specifies the time required to purge cal gas after phases Affected Channels determines which channels will be taken off line during cal Select from a list of previously configured parameters G Sequence Sequence X i 3 Sequence Phasefs Alatre s Sequence Colteation Type Interactive_M Affected Channels Select Name Calon Nane o m OZONE Enabled 7 Number of Caliteation Records 1 Recovery Time 5 Minutes p 4 Configuring Interactive Menu Calibrations 40 Agilaive AV Trend Manval Chapter 2 Configuration Configuri ng User Initiated Calibrations Suer initiated calibrations are started manually by linking to the data logger When the cal sequence is started each phase will be initiated in order The duration of each phase is configured with the same fields as automatic cals The User Initiated Cal configuration screen has the following fields Calibration Type will be already filled in UserInitiated_U Calibration Name is required to identify the cal program Check Enabled if the cali
24. sms sazo m A DOLZ 15 23 00 MAIZON 15 24 00 414 2012 19 28 00 444 2012 15 26 00 4 9 2012 15 27 00 AHARON 15 28 00 AJAO 15 2000 442012 15 30 00 AHAZOL 18 31 00 AJAZOLZ 15 32 00 AHANZOL2 15 39 00 AHOL 15 34 00 36 AJRON 18 35 00 a 4912012 15 36 00 s3 AAJZOL2 15 3700 st ARON 15 38 00 38 AHOL 15 99 09 39 AZOLE 15 45 00 s AJ420112 15 46 00 76 Right Click SEEE 114
25. to all configuration items at the topmost level and all sub tasks are permitted by inheritance For example to turn off Edit ADVP Rules first remove the overall Edit Configurations permission and then add the individual permissions Expand and Collapse the tree diagram using the buttons on the ribbon To define a group as having site specific access uncheck the Apply to All Sites in the lower left panel and then add sites using the list form below Abhity to confgzare the aoplcaten pecurty Edt Securty Tas ER User Groupa Securty ADNR y to edt CONLRE WOO elements ER ADP Res ER Alarm CORE WO ER Report Configration ER Tags ates parameters data sources etc Configuration for the file import tool Edt access to data Add ANN OG Date edtors and took ER PlagnAQs Codes Pamiers to acess database record from AAN o ADRY to create nen records Abity to delete records AbMty to wien recorde Abhity to change records Group Permissions from Configuration Editors gt Security gt Group Permissions Editor 63 Chapter 3 After data has been polled either by a scheduled task i f Configuration Editor gt Task Scheduler or manually Utilities gt Manual Poll AV Trend can run the following reports after the Criteria Pane has been configured Annotations Report Calibration Results e Calibration Trend Graph Configuration Calibration Configuration Report Channel Configu
26. 0 INHG 60 Miller NC OZ TEM INSTANT e x 60 Mille NCOZONE INSTANT o Rj 60 Miller NC 0Z_TEMP 60 Miller_ NC OZONE 11 23 2011 17 53 00 DEGC 11 23 2011 17 53 19 PPB Last Refreste 341 232013 17 5329 Prosle 6972 103 Versions 244 Bulld 201331231 14232011 Create a new layout by clicking the Select Display Elements icon from the ribbon 106 Agilaive AV Trend Manval Chapter 4 Data Editors You can use the filter fields to narrow parameter names and more importantly average intervals if needed The form supports standard Windows drag select shift select and CTRL select actions Note that the display will support multiple average intervals so it is possible to mix minute and hourly data e g analyzers and BAMs on the same screen Instantaneous data panels are selected on the next page Site Name Parameter Name E Time Interval PN 60 Miller NC 60 Miller_NC 60 Millee_NC 60 Millee NC 60 Miller NC Miller NC 60 Millee NC 60 Miller NC 60 Miller_ NC Miller NC 60 Miller_NC 60 Miller NC Realtime Element Selection Wizard Average Data Parameter Interval Selection 52 Rastie Benene Secon Wa pepr Instantansous Data Parameter Selection Select the Parameters you would like to see current Instantaneous non averaged date for and press the Next button Drag a column header here to group by that column Site Name Parameter Name Parameter Template Realtim
27. 01 21 Oooo v Mate WOOL A Bes OF tee OO a oe oo eee Updating Display with movable Panels 108 Agilaive AV Trend Manval Chapter 4 Data Editors The other panels will minimize and the selected parameters will expand into a trend chart with an LED panel still updating the current reading average For instantaneous data the duration of the display can be modified if needed Instantaneous readings default to show the previous 5 minutes while charts of averages are longer Instantaneous readings also have an option to show a trendline of the general direction of the newest readings al Crore im Trend tesime Tre Onc gi Rewtiene Oste Trondro x 60 Mer NC BAM PMISO0IM O n OMe uui o r Pe amene Dete Current besorg 60 Miller_NC RAM_ETMP Se Mie NC Peemeter BAM PHIS 1t232011 210000 Cece Copy to Optog Soos to Nes keosrgs 7 6 iher NC BAM R o x 00 a en 60 Millor_NC BAM_RH A g i i 11232011 21 0009 PERCENT OMe NMMY a 60 Miller_NC BAM_VOL 12 20 x ILALA 1400 19 11232011 210000 5 3123 2083 1900 39 OM NCOZA o z ILQLGQOLI 14660 26 aaa z 60 Miller_NCOZ_FLOW ILGAGI 1760 16 m lt si P S af ILOLAN 1900 10 9 n5 L 9 9 ho 11222011 2060 ALR 223930 uu E y O a ot S P 11 20 2018 2100 10 I Mieno o z 3 x 3 x n ee eee e een a nr Agrid of previous averages for averaged data To return the display to its previous mode click the resize button two stacked win
28. AV Trend Agilaire Produced by Agilaire LLC 2904 B Tazewell Pike Suite A Knoxville TN 37918 www agilairecorp com info agilairecorp com Support 865 927 9440 support agilairecorp com May 2014 Agilaive AV Trend Manval Table of Contents Chapter 1 Installing AV Trend 5 Installing Microsoft NET Framework 5 Installing SQL Server 5 Installing the AV Trend Database 6 First time Installation of the AV Trend Database 6 Installing AV Trend 7 Logging In to AV Trend 8 Accessing Profiles After Logging In 9 Chapter 2 Configuring AV Trend 10 Configuring System Preferences 11 Site and Parameter Setup 12 Adding a Site 13 Adding Parameters 16 Adding Loggers to Sites in Logger Channels 20 Adding an Instrument 21 Adding Channels to Data Loggers 22 Adding Communication Routes 26 Adding TCP IP Routes 26 Adding Serial Routes for Direct Communication 28 Configuring Communication Routes 29 Testing Your Connection Linking to Logger 30 Downloading Channel Configurations 31 Setting Up Calibrations 32 Calibration Expected Values Editor 33 Configuring Automatic Calibrations 34 Configuring Phases 35 Externally Initiated Calibration 36 Configuring Instrument Controlled Calibrations 38 Configuring Interactive Menu Calibrations 39 Agilaive AV Trend Manval Table of Contents Configuring User Initiated Calibrations Configuring Input Output Lines for Digital Events Configuring Digital Timed Events Configuring Digital Triggered Events Sched
29. Add Channel gt Modbus in the Logger Channels editor Under the Misc tab select the Modbus Instrument and Driver from the picklists If you need a parameter that is not in the picklist contact Agilaire Support support agilairecorp com and we will add it to your system Modbus channels in the 8872 will use the Modbus Scaling Factor to convert floating point data from the instrument before using it in averages calibrations etc This can be used to convert an analyzer that only provides PPB data on the Modbus link to PPM data or similar conversions This approach is preferred over Analyzer Units in the logger since the Analyzer Units conversion only takes place on averages and calibration data but causes inconsistency with other logger configuration settings alarm limits calibration expected values etc Favorites Data Source Details Bwuveo x P Close Modify Copy Paste Delete Add Change Calculate Parse active tab y Channel Type Memory Usage Config File Editor Options Add Tools 49 Data Source Details a Bi crannescozone Rf channetnor x Channel Validation Mise Modbus General Associated Source HamiltonCoNearRd Channel Neme No2 9 O3MuULTI O2PRCSN Enable Channel y 0 O3ZROSPN Round Precision Modbus Scale Factor Extended Average 2 Average Intervat 03h Storage Time 805 gt Houris gt ii Profie local Versiorc21010 Buiid 201340113 1013 2013 1032 26 Agilaive AV Trend Manval Cha
30. Ribbon bar to toggle between Data Editor displays To edit data in the Average Data Editor Data Editors gt Average Data Editor enter Start and End Date type dates or use arrow keys to select Average Interval for example 001h Hourly average of 60 minutes Parameter Selection for example Site Name NKNOX Parameter Name NO2 Parameter Template NO2 Click the Retrieve Data button in the ribbon at the top of the screen The Average Data Editor will open the Linear Data Editor by default Click buttons in the ribbon to change formats 93 Agilaive AV Trend Manval Chapter 4 Data Editors Linear Data Editor The Linear Data Editor Site Name Parameter Name Parameter Template Name Average Interval Start and End Dates Value Hover the mouse pointer over data values to see any annotations Raw Value can t be edited AQS Null Codes Data Logger Flags Qualifier Codes AV Trend Data Grade used by ADVP To edit data values double click in the Value cell or right click to bring up a pop up menu a C E C E C E C C 0425 2010 1408 0458160307 123 94 25 2080 15 08 0451269123 OA 123 04 25 2080 16 08 0284919432 123 ga7s2010 anoe 0 263952489 j 223 04 25 2010 18 00 o Ramu 0425 2010 150 oaner r 23 Average Data Editor from Data Editors menu 94 Agilaive AV Trend Manval Chapter 4 Data Editors Cell Color Codes All data is color coded based on the flag to color mappings li
31. ackground AV Trend service The Task Manager has three user interfaces Task Scheduler Configuration Editors gt Task Scheduler allows you to add review and edit individual and grouped task events Task Wizard Configuration Editors gt Task Scheduler gt Run Schedule Wizard button in ribbon at top of screen allows you to create grouped polling events as well as events triggered by polling gt Note This Wizard is ONLY used for setting a Model 8872 to poll another device like an instrument or another Model 8816 8832 data logger It is not related to another server polling the 8872 itself Task Display Utilities gt Scheduled Task Status is a constantly updating display of all tasks within the system including the last time run next execution time and errors experienced during the last run The following tasks can be configured in the Task Scheduler depending on your licensed options Alarm Processing Task Journal Message Purge Task Average Data Purge Task Logger Poll Task Average Rollup Task Scheduled Command Line Task e Database Sync Task Scheduled Report Task Fill Average Data Gaps Task SQL Execution Task Instrument Poll Task e New Task Group Task Scheduler The Task Scheduler screen has three sections Task Schedule displays all scheduled tasks and cannot be edited Task Schedule Details section is where you select an Executive and Start Time and a Repeat Interval Enabled must be check
32. ainerd 03_AMB_TEMP Roane 12_AMB_TEMP AMBTEMP Union 11_AM8_TEMP AMBTEMP Using a filter to determine which parameters don t have a template 67 Agilaive AV Trend Manval Chapter 5 Reports Additional Fields for Specific Reports For some reports the Criteria Panel is expanded with additional fields For the Maximum Hourly Averages report additional information is needed on how the data in the report should be filtered and calculated Rolling hours and time tagging type Report highest average only for any day Allow report of overlapping maximums for multiple hour rolling averages Number of maximum averages to report a Diag a column header here to group by that column Parameter Name Parameter Template g E Blount S 02_PM25_MC PM25 C Blount 03 _PM2SBRAW Blount S 04_PM2SRRAW 08_TEMP 09_Ws 20 WD 11 AMB TEMP AMBTEMP Additional Report Criteria required for Maximum Hourly Values report Other reports with additional criteria include Wind Pollution Rose requires you to designate which Wind Rose report profile to use AQS XML Report requires you to choose which kinds of records to be assembled Concentration Distribution Frequency Distribution Monthly Reports all allow you to designate an N hour rolling average as an option 68 Agilaive AV Trend Manval Chapter 4 Reports Annotations Report The Annotations report may be run on any list of parameters for any time range It provides a
33. al Chapter 1 Installation Instal ling AV Trend gt Note If you are upgrading AV Trend from version 2 1 or higher you no longer need to uninstall the old version before you run the new installation 1 If the AV Trend installation does not open automatically after you insert the installation CD double click to open My Computer then right click the CD drive and select Open Double click the Setup icon to begin 2 Accept the license agreement and click Next 3 Enter your User Name Company Name optional and the unique Product ID required supplied by Agilaire Click Next 4 Click Next to accept the default destination directory C Program Files Agilaire LLC Server or browse to change the directory and then click Next 5 The final screen will say AV Trend has been successfully installed Click Finish Agilaive AV Trend Manval Chapter 1 Installation Logging In to AV Trend AirVision Login The AV Trend Installer automatically creates a login profile for local host If that profile doesn t work e click the square button to open the Profiles screen In the Profiles screen click the Add Profile button and enter the name of your executive computer where the AV Trend Login AirVision server is installed for the Profile Name If you don t know the computer name right click the My Computer icon from the Windows AirVision Profiles Start menu on the computer where the AirVision server is installed Se
34. al Time Trend the user may drag select and right click a list of data points The user is then presented with two options Annotate Selected this will allow the user to add a text annotation to the data which will appear in future use of the Data Editor or can be recalled in the Annotations Report Analyze Selected this will bring up a box allowing the user to see an average or other statistics of only the selected data points This is commonly used to average calibration or test runs of data The results can also be printed or saved using the Print Export Grid button Home View Farranties Rasime Data trending Maral Skah J Egi Sec pomes i Sah Sack gg CD Reports pae opady one Cpacty 4 4 2012 15 21 00 AJ420142 15 06 00 44412012 15 07 00 vr 7 4J4 2012 15 22 00 444 2012 18 23 00 2 wre operation revert ajajzorz 15 28 00 zs Daly Summary Report 4 4 2012 15 25 00 AMBOIZ 18 1000 E Internat Reports ajejz0ne 15 26 00 7 4 4 2012 18 11 00 g Looper Rests 4 4 2012 15 27 00 za Azon 15 12 00 Ajaf2012 15 28 00 2 14 2012 85 13 00 4j4 2012 18 29 00 26 P Cortramessooes jazoz 15 30 00 2 os aoe 2 tres Une status Revert ayajzorz 15 91 00 2 ARON 18 1600 Pomer Fase Report 4 4 2082 15 32 00 20 HNZOLZ 15 17 00 ER airi Auat 44 2082 15000 2s 4 4 2012 15 10 00 gg awe Regarts rete ineen PETE TE D eo oa po NN 7 SSeUS eee bee A 4i2012 15121100 o
35. al in seconds minutes hours or days The Task must be named and a data logger must be selected Select a Logger Command from the following drop down list 56 Average Data Calibration Results Instantaneous Readings Poll Current Time Poll Input Status Lind Poll Current Digital Input Poll Alarm Journal Entries Synchronize Logger Time Poll Long Central Messages Poll Chart Memos Power Failure Log 50 Agilaive AV Trend Manval Chapter 2 Configuration gt Note The logger also can be polled manually via Utilities gt Manual Poll Scheduled Command Line Task allows you to automatically execute any DOS command line such as a batch file or exe file e g NTbackup exe Scheduled Report Task automatically sends scheduled reports to a designated printer emails reports to configured recipients or saves them to a file Click the green Add button and select Scheduled Report Task Inthe Task Schedule Details section select Executive Start Time and Repeat Interval In the Task Details section enter a Task Name and enter an optional Task Description and click to select Enabled Inthe Report Task Options section select a Report from the drop down list Click the Configure Report Query button to select Date Range Average Interval and Parameter s The Query String will be displayed near the bottom of the screen Click OK to save the configuration Inthe Output Options section click the Printing Options tab i
36. alibration Trend Graphs provide a long term view of calibration zero span results over a user defined period of time month quarter etc Select a Start and End Date and a Parameter Click the Generate Report icon on the ribbon Chapter 3 Reports If you select Raw Data Graph from the ribbon at the top of the screen you can view calibration data in a text table Drag a column header here to group by that column ISITEONE OZONE a1 Autocal sITEONE OZONE o Autocal stteoNe ozone ot Autocal stTEONE ozone o Autocal SITEONE OZONE o Autocal streoNe ozone o Autocal stTEONE ozoNE o Autocal SITEONE ozone a Autocal Raw Data Calibration Display 10 11 2009 3 15 AM 10 11 2009 3 15 AM 10 11 2009 3 15 AM 10 12 2009 3 15 AM 10 12 2009 3 15 AM 10 12 2009 3 15 AM 10 13 2009 3 15 AM 10 13 2009 3 15 AM 10 13 2009 3 15 AM 10 11 2009 3 20 AM 10 11 2009 3 25 AM 10 11 2009 3 30 AM 10 12 2009 3 20 AM 10 12 2009 3 25 AM 10 12 2009 3 30 AM 10 13 2009 3 20 AM 10 13 2009 3 25 AM 10 13 2009 3 30 AM 3 8957E 05 9 999958318 19 999972251 71 Agilaive AV Trend Manval Chapter 3 Reports If you select Historical Graph from the Ribbon you can view data in a graph Each color represents a different phase as shown in the legend You can change the color scheme by selecting a Graph Theme from the drop down list at the bottom of the screen rora P p AEAEE ENE ae Qe traome oeoo 259 gt
37. ame or Names Click the Generate Report icon on the Ribbon Daily Parameter Report 09 09 46 74 46 4 9 2 48 29 35 42 n Was Keane Baai nead matt Rill Bol BY bc hall Binard ciel laa 33 33 45 as as a 4 a 4s a 43 Vc era er a7 or or 46 46 asl aa 30 38 Teias 4 4 4 ais elalelal 36 as ne s as te nma sa oi se oe ea 105 Tar az ve aal az 43 selos Dalas tpl ts s sr we wa bs be be 3 M4 D3 MA Del alee wel os we Ga et ws at ae amp an aa lt lara POT ae see a ee es aa Ton r r2 3 33 a ba 2 33 33 33 86 a8 hto toetetetetetetetetetete tete Osiya 8 422 Mt WE M HW BA a w 48 on a 7 ona 06 EAEE EKAI CI CICALA 17 812 ee e wr Mt ME OM OO DI D w MA DI EY 2 az 33 38 P a LE E P 3s Teele laa la oe m aroa ase 1O 2706 200 5 227 002 tee NIA 16 TICAL 395 304 S D23 NI NEI 2968 DIR IA MS 2O 70S 7292 2102 2108 tite se tes pas 13 IEI CSP IIE IEF 115 1443 194 14O 1059 1012 ta te 2 te 24 22 22 za 22 2e 1s 27 22 18 16 7s 3 232 38 32 48 18 t8 1 118 44 2 Daily Parameter Report Reports gt Daily Parameter Report 79 Agilaive AV Trend Manval Chapter 4 Reports Daily Summary Report The Daily Summary Report is usually used for the daily summary of hourly data for all parameters at a site or sites but it can also be used to report any time range or average interval Statis
38. bration is to run Number of Calibration Records determines how many cals the data logger will store before overwriting Recovery Time specifies the time required to purge cal gas after phases Affected Channels determines which channels will be taken off line during cal Select from a list of previously configured parameters Sequence Sequence Sequence X o 3 Sequence Phase s Alarmi s Sequence Calibration Type Usedlnitiated_U Affected Channels Select Neme Catan Ge OZONE Enabled y Number of Calibration Records 1 Recovery Time 5 Minutesfs E Configuring User Initiated Calibrations 41 Agilaive AV Trend Manval Chapter 2 Configuration Configuring Input Output Lines for Digital Events The purpose of digital event programs is to control processes from 8816 or 8832 Data Loggers Digitally Timed Events will turn on specified Output Lines for the configured Starting Time Duration and Repeat Interval Digitally Triggered Events are initiated by a digital input pattern that will turn on one or more digital output lines The output lines will remain active for the specified duration at the end of this time the output lines will be turned off unless the triggering digital input pattern still matches Configuring Digital Timed Events 1 Highlight the Data Logger in Configuration Editors gt Logger Channels tree menu 2 Click the green Add button in the ribbon and select Add Digital Events gt Timed Event 3
39. ck Next to continue Agilaive AV Trend Manval Chapter 1 Installation The remaining setup screens are self explanatory Follow the directions and click Finish in the Completing Microsoft SQL Server Setup screen gt Note If you set up SQL in Windows Authentication mode you must must log in to SQL with Windows Authentication not SQL Server Authentication or the AV Trend Service won t start Install ng the AV Trend Database After you have installed SQL Server 1 From the Windows Start menu select All Programs gt SQL Server Management Studio 2 Right click the Databases folder and select New Database For the Database name enter AVData and click OK 3 Click to select the database you just created AVData First time Installation of the AV Trend Database 1 If you are installing AV Trend for the first time insert the installation CD and browse to open the folder AV Database_Freshinstall double click to open My Computer then right click the CD drive and select Open Within the folder Database_Freshinstall double click AVReleaseCreator sql The script should open in the AVData folder in SQL 2 Click Execute to run the query The query will install the SQL tables needed to run AV Trend The bottom of the query screen will display the results of the query Any error messages will be listed by line number Be sure to save any error messages in case you need to call Agilaire Support for help Agilaive AV Trend Manv
40. dabc3 eb90 dell 8455 001731 cheBfb amp Averageintervals c71a20a01 43f9 ddl 1 9b87 001e8 005352 Favorite Query tab from Add a Favorite 59 Agilaive AV Trend Manval Chapter 2 Configuration SI Driver Editor The purpose of the GSI Driver Editor Editors gt GSI Driver Editor is to provide a way to add delete or modify GSI driver entries in an editor similar to the Parameter Template editor for GSI entries and GSI instruments The GSI Driver Editor consists of an alphabetized pick list of existing GSI entries for modification Two editors are provided one for instruments and one for entries or two sections tabs of the forms Fields in the GSI Driver Entry tab include GSI Entry Associated GSI Instrument and GSI Entry pick list of configured instruments Send Name string Parse Name string up to 8 char AutoSend String string up to 8 char Autosend Repeat Interval 1 60 seconds Parse Sync String Modbus Register Fixed or Delimited Parsing Fixed Number of Chars to Data int up to 3 digits Data Field Width int up to 2 digits Number of Chars in string int up to 3 digits Delimited Number of Delimiter Chars string Number of Delimiters of Delimiters to Data int up to 3 digits Number of Delimiters In String int up to 3 digits Data Field Type pick list Hex Binary Float In the GSI Driver Instrument tab GSI Instrument Name Default TCP Port integer up to 6 digits Default Modbus Code i
41. default graph uses the graph maximum minimum from Configuration Editors gt Parameter Settings but you can check Override to set a custom max min specifically for the X axis of this graph Histogram from Data Editors menu with hover over displaying date time and data value 103 Agilaive AV Trend Manval Chapter 4 Data Editors Log Book Ent y Editor The LogBook Entry Editor allows you to make entries in a logbook that can then be seen in LogBook Reports To make a logbook entry open LogBook Entry Editor from the Editors menu Click the New Log Entry button in the upper left corner of the screen In the bottom section of the screen enter a Log Entry Time User Entry Time select a Category from the drop down list or select New Category and enter a different category select a User and a Site from the drop down lists Enter the LogBook message in the Entry Text box and click Save The new entry information will be displayed in a row in the top section of the screen 1 Ww AirVision amp X Home View Favorites LogBook Entry Editor New Log Entry Log Book Options Main Navigation vx T Logbook Entry Editor x a Data Editors F Ta Average Data Editor Site User Category Entry Time User Entry Time Entry TP Calibration Data Editor E S a a 5 Lock Unlock Data v2 Agilaire o Avision E Repair 06 02 2030 30 59 06 02 2010 10 9 testing gt Bey Avision ther 6022010 12 06 Tha deie ta ee tau fa LogBook Ent
42. dows next to the X close box 109 Agilaive AV Trend Manval Chapter 4 Data Editors Realtime Trend The Realtime Trend provides a time series view of data that continuously updates Any number of Realtime Trend tabs may be opened and they can graph any average interval available in the system most commonly 10 second and 1 minute trends gt Note Because Favorites can be used to store Realtime Trend settings and can be set to automatically open on startup it is simple to define some screens to open automatically on the client launch and by putting the Client in the startup folder and storing the login username and password the PC can be set to start up the client and the default trends on PC reboot To create a new trend select Status Displays gt Real Time Trending in the menu To query a report select parameters and averaging interval Select Automatic Refresh from the menu for a continuously updating trend By default the screen will show both a time series plot and a grid list of data points on the right side By using the Show Grid and Show Chart ribbon buttons you can define whether you want a chart a list of numeric readings good for a large number of parameters or both a chart and grid W Aaa mee v tonnes z a a S35 eS 3 ie bj a barber te Jeeta Cyrene BE SOE EM E heetee owu maage en ne raaye miens Dg t rakuna madee Aere te groaa Py ma Aay ERA eer mesage t 62 ssai A te wade men ae te loa
43. e Eventually the AV Trend database becomes so big that it takes a long time to back it up so it is helpful to remove and or save old data in particular minute data You can choose any average interval to be scheduled for Purge or Archive Purged data will be permanently deleted from the database Archived data is copied to an external file before purging Archived data is stored with all flags and annotations and can be re imported later AV Trend uses specialized data keys so sites and channels can be renamed or renumbered and archived data can still be correctly imported Select the age of the data to purge Purge Data Older Than a specified number of seconds minutes hours days weeks or years We recommend purging 1 minute data older than 1 year to keep the database within allowable size gt Note Average Data can be purged manually via the Utilities menu gt Purge Average Data A checkbox option allows you to retain data during calibrations If selected any data flagged with the C flag will not be purged This allows you to retain minute data from calibrations e g for use in the Calibration Trend Graph s Response Plot while still removing old minute data General Advanced Basic Task Information Task Name Average Data Purge Task Task Enabled V Task Description Average Data Purge Task Purge Options Archive Type erage Data Purge Data Older than 3 gt Year s v Alternate Archive Archive Data Before Purging Folde
44. e open Configuration Editors gt Favorites Editors Click the red Add Favorite button on the left side of the ribbon Favorite Detail Favorite Query gt Note Favorites can also be Favorite Details created inside Reports Menu tem hs by selecting the Favotite Name Average Data Editor Favorites tab and Favoiie DADR clicking the Save as September hourly 2009 Favorites icon Favorite Detail Tab Favore Scope User X Under the Favorite Detail tab of User the Favorites Editor select a Menu Item from the drop down list enter Launch on Application Startup a Favorite Name enter a Favorite Run Query on Launch Description optional select a Favorite Scope from the drop down list User or All Users an select from the following options Add a Favorite screen Launch on Application Startup to run the Favorite upon logging in to AV Trend Run Query on Launch to execute data retrieval when the Favorite is selected Favorite Query Tab Next open the Favorite Query tab if it is available gt Note The Favorite Query tab will only be in the Favorites Editor after a Menu Item is selected that requires a time range interval and parameter s such as the Average Data Report and the Average Data Editor 58 Agilaive AV Trend Manval Chapter 2 Configuration Select a Date Range choose an Average Interval and select a Parameter To select more than one parameter drag the arrow in the blue left column or hold down the C
45. e see Adding Loggers to Sites click the Add button select Add Channels select a Channel Type e g Standard Averaging GSI VWS etc select a Channel Number a channel number will automatically be added in order but it can be changed select a Parameter When you select a parameter the Channel Name will automatically be changed to match the Parameter name For the remainder of the prompts on the form consult the ESC Model 8816 8832 User Manual select an Average Interval and Storage for the Base Average Extended Average 1 and Extended Average 2 Click the Save button Follow the same procedure to add calibrations average alarms and digital event triggers Standard Avesgng Adding channels to loggers in the Data Source Configuration from Configuration Editors 22 Agilaive AV Trend Manval Chapter 2 Configuration Two channel types are handled differently in AV Trend than in previous systems both improve on digital data acquisition integration The first channel type the GSI Generic Serial Interface channel is used for RS 232 based instruments AV Trend includes GSI drivers for a wide variety of instruments Choose the instrument the parameter and designate which serial port is connected Using a dongle can be designated if the instrument connection requires a hardware dongle e g C Series Analyzers in a daisy chain configuration or Ecotech analyzers GSI channel configuration 23 A
46. e Element Selection Wizard Instantaneous Data Parameter Selection 107 Agilaive AV Trend Manval Chapter 4 Data Editors Finally the Wizard asks if you want to view the realtime status of any Select the Inout Lines you woukd lke eplayed and press the Next button digital input status lines Select lines by clicking Dreg a column header here to group by that column the left side check boxes E Selected Site Source tine Number Line une Description 1 Inputeds 3 Inpe 4 Inpureos 5 Inpweos 6 Inpwe0s 7 Inpweo B Inpureds 9 Ingus 10 Inpro 11 Inpwell 12 Inpitel Realtime Element Selection Wizard Digital Input Line Selection Once the wizard is finished the display will start and begin updating Panels can be dragged into any desired order arrangement by click drag click and drag from the title bar area at the top above the large font name Panels can be eliminated by clicking the X box in the upper right To zoom into a particular reading click the expand box to the left of the X Coone ba beng H iee me Taiu Ouray gi Hestine Duta Denaro kal gt Mae NC ODONI INSTANT o te WC LAN J e te nee een et footy OO Meher _NC BAM_ETMP j we Mee eree OOM 1833901 31 68 60 ee eo J seam ine Pepers ren O Om Mate hav e s a te WO ae NC ODM NCOBAM PNIS LL ODONI gt trent IUMO 322 ney 15793011 710000 gt Osis Vex Je Pa O te W hav e a ee 60 Mior NC BAM FO i 19392011 31 OCS POCIT 82d2
47. e click the System icon The System is the agency or area such as Knox County or State of Tennessee Typically each agency setup will only have one System a second system could be used to help separate for example air toxics or water quality data from the other quality data but it is possible to set up more than one by clicking the Add System button on the ribbon Verify that the Time Zone is correct The other fields listed below are optional and typically used only if your license includes full Ambient reporting System Name County Code Agency Code provided by EPA Click the Save button Parameter Settings x Li gs Em AV lend ele system AVTrend X oA Agilaire General Advanced 7 A NO system Details A No2 System Name AVTrend A NOX A wDR Country Code 093 A WSP Agency Code 9581 Time Zone GMT 05 00 Eastern Time US amp Canada Profile HP_SERVER Version 2 2 2 Build 2011 02 16 3 3 7 2011 17 15 System Configuration from Parameter Settings Editor 11 Agilaive AV Trend Manval Chapter 2 Configuration Site and Parameter Setup The Parameter Settings Editor from the Configuration Editors menu allows administrators to add edit and delete sites and parameters In AV Trend a Site is not necessarily a single data logger as it was in E DAS A Site is a logical organization of a physical monitoring area and can contain data from several sources such as data loggers PM samplers and directly poll
48. ear the suspect flag First you must select Enabled You have the option to combine scaling with one or more of the following Update Values Set Annotations Set AQS Code Set Qualifier Code and Set Flags If you select Set Flags you will have the option to Update Children Flags Show Children brings up another instance of the Data Editor with the selected parameters and time range for the Child parameter s of the selected parameter This function requires that Parent Child Parameter relationships are configured in Configuration Editors gt Parameter Settings Drill Down Interval allows you to drill down to minute averages from hourly averages Export to Excel exports the selected data range to an Excel document including color font and layout details This right click option is different from the Export to Excel button in the ribbon at the top of the screen because the button on the ribbon exports the entire data set in the data editor and the right click option exports only selected data Click a column heading to sort data by a different heading for example to group data according to flags Default is to sort by date Click hold drag columns to change the order of columns or to drag a column heading to the Drag a column header here to group by that column area 95 Agilaive AV Trend Manval Chapter 4 Data Editors Cross Tab Data Editor The Cross Tab Data Editor shows Parameters as columns and sequences rows by date time i
49. ection to Driver in Configuration Editors gt Logger Channels gt Communication tab 30 Agilaire AV Trend Manval Chapter 2 Configuration Testing Yovr Connection Linking to Logger To test your connection select Link to Logger from the Utilities menu Select a logger from the drop down list and click Connect Linking to the logger means that you connection is good but does not ensure that you will be able to download or poll amp Important Some configuration changes require you to restart the the AV Trend System If a System Restart is necessary you will be prompted by AV Trend when you click Save If you click Yes at the prompt AV Trend will restart the system automatically If a required system restart is not done you will not be able to link to logger Two system restarts may be necessary to synchronize the network for IP based connections gt Note If you need to restart the system manually open the Utilities menu and select System Restart Select an Executive in the System Restart screen then click the Restart Executive Service icon in the upper left corner bk Air Vision el ook gt Home View Favorites a r Bet 2 2 Ga Close Reports Utilities List Data Configuration X X Editors Edtors Editors Tasks amp Link To Logger x ESC 8816 v5 31 ID PD Hone Menu 64 68 69 15 11 20 H Help Screen L Login Set User Level 0 Log Out Exit Testing your connection from Utilities gt Link to L
50. ed analyzers N ERE add Dates Mocty Cose Active Pamreter Pyaneter Parameter Form GMT 16 00 Eastern Teme US amp Canada r A atta cease Site Configuration from Parameter Settings in Configuration Editors 12 Agilaive AV Trend Manval Chapter 2 Configuration Adding a Site To add a site single click Configuration Editors Parameter Settings In the Parameter Settings screen highlight your System in the tree diagram and click the Add Site button Required fields are Name and Time Zone Enter the name of your Site and select a Time Zone from the drop down list Select the Enabled box and click the Save icon To edit a site double click the Site name in the Parameter Settings tree diagram make changes and click the Save icon 13 Agilaive AV Trend Manval Name Required Description Abbreviation Time Zone Required Enabled Required for polling Latitude Longitude EPA Site AIRNow Mnemonic Surrogate Slope Surrogate Offset Chapter 2 Configuration The Site Editor contains the following fields for information about the site Alphanumeric characters to refer to the site e g NKnox Brief description of the site e g North Knoxville optional This field is used for special formats only File Import is not available in AV Trend Select from drop down list Check the box to enable the site If this box is not selected the site will not be p
51. ed in this section before you can select Enabled in the Scheduled Task Selection section An Advanced tab is provided next to the repeat interval to allow the user to specify if the task is only to run on certain days of the week or only in a window of certain hours of the day This is especially useful for polling tasks 47 Agilaive AV Trend Manval Chapter 2 Configuration Task Information Task Name Average Data Purge Task V Enabled Description Average Data Purge Task Executive ZENBOOK Start Time 12 06 2012 17 17 20 Repeat Interval 1 Day s Days to Run V Sunday V Monday V Tuesday V Wednesday Thursday V Friday V Saturday Time of Day Restriction Unrestricted Run only between Task Scheduler showing a Logger Poll Task Configuration Editors gt Task Scheduler 48 Agilaive AV Trend Manval Chapter 2 Configuration To configure an individual task in the Task Scheduler Configuration Editors gt Task Scheduler click the Add button in the ribbon at the top of the screen and select one of the following categories Alarm Processing Task reviews alarm Triggers for matches creates alerts and tells AV Trend when to process a particular alarm rule If you use task groups and designate tasks to run in sequence you can designate alarms to processed immediately after a data poll Alarm Processing is not used in AV Trend Average Data Purge Task purges or archives old data from the databas
52. end Manval Chapter 2 Configuration x Executive Task Name Task Enabled Task Type Start Time Repeat Interv aw 5 a HP_SERVER Logger Poll Task v Logger Poll Task 03 03 2011 12 34 10 gt Task Schedule Details Executive HP_SERVER v Start Time 03 02 2011 11 54 02 Repeat Interval 1 gt Day s ris Task Detail General ancec Basic Task Information Task Name Scheduled Report Task Task Enabled v Task Description Generates Report at assigned time for output Report Tas pt 15 Report Daily Summary Report X Configure Report Query Output Options Printing Options Notification Options File Output Options Output File Type Excel File File Name Construction File Output Base Name Daily Sum Append Date to File Name V Append Date to Name Date Format yyyMMddHHmm File Extension XLS Save File Options V SaveReportto FileEnabled File Output Path Browse pload File Via FIP Option FIP Upload Enabled FTP Transfer Program v v e gt Profile HP_SERVER Version 2 2 2 Build 2011 02 16 3 3 22 2011 16 08 Schedule Report Task Configuration Editors gt Task Scheduler gt Add Scheduled Report Task 52 Agilaive AV Trend Manval Chapter 2 Configuration SQL Execution Task To add a SQL Execution Task click the green Add button on the ribbon and select SQL Execution Task Select the Executive Start Time and Repeat Interval Name the SQL task or use the default name Enter the SQL Command Text Click
53. equired to identify the cal program Check Enabled if the calibration is to run Number of Calibration Records determines how many cals the data logger will store before overwriting Recovery Time specifies the time required to purge cal gas after phases Repeated Interval determines how often cal sequence will repeat Start Time determines what time cal sequence will start Affected Channels determines which channels will be taken off line during cal Select from a list of previously configured parameters 35 Agilaive ANV Trend Manval Chapter 2 Configuration Configuring Fhases To set up Phases click the Phase s tab behind the Sequence Cal tab To enter a phase name click the click the Add above the tabs and select Phase from the drop down list Enter a Phase Name Phase Number Duration Type Response Time and click to check the box in the Enabled column To configure a Status Pattern click in the Status Pattern column and a check list of Output Control Patterns will come up After the Phase table is configured click Add again and select Phase Channels Select a Channel from a drop down list and optionally enter an Expected Value Expected Value from Constant Warning Drift Limit EV for Auto Correct click to enable Store Cal Results click to enable Write Result to Constant Error Method Write Expected Value to Constant and Out of Control Limit ainia be Configuring calibratio
54. f the report will be printed Select Enable Printing and designate the Printer Path Ifthe report will be emailed select the Notifications Options tab check Enable Notifications and enter a Notification Publication Description Users and or User Groups must be designated in Configuration Editors gt Security before Notifications will be sent Ifthe report will be saved to a file open the File Output Options tab and select an Output File Type comma separated Excel image text HTML PDF or rich text from the drop down list This option can be used to write the scheduled report to a local or network drive and or to FTP the file to a particular FTP serve 66 99 Enter a File Output Base Name Windows does not allow or characters in file names The File Extension will be filled in automatically from the Output File Type selected To have the scheduled task append the current date time to the file name select Append Date to Name and a Date Format for example Daily_ Sum201106271900 Selecting this option ensures that new files do not overwrite existing files in the directory If this option not selected the task will overwrite the file each time the task runs To Save the file check Save Report to File Enabled and browse to a File Output Path To Upload File Via FTP Options select FTP Upload Enabled and select an FTP Transfer Program from the drop down list of configured FTP programs 51 Agilaive AV Tr
55. gilaive AV Trend Manval Chapter 2 Configuration The second channel type a better approach for digital data acquisition is the Modbus channel Designate an Instrument that has been previously configured in the Logger Channels editor and select a Parameter Rf channet chani1 x Channel Validation Misc al General Associated Source Logger Channel Name Chanll Parameter Channel Type Enable Channd v Base Average Average Interval 001m Channel Number es Storage Time Hold Data Between Updates Yes C No Extended Averages Extended Average 1 Extended Average 2 Average Interval 015m Average interval 00ih Storage Time 2 X amp Storage Time nl lt gt sss sss see Profile HP_SERVER Version 2 0 0Alpha Build 2010 06 26 1 9 23 2010 13 19 Modbus channel configuration Like the GSI channel AV Trend simplifies the configuration process by automatically creating and downloading the data logger s server configuration file in the background Since Modbus instruments have additional networking information that needs to be known you must create an instance of the Modbus instrument in the Logger Channels editor before creating the Modbus channels for that instrument This procedure prevents the need to repeat entry of the networking information for each channel 24 Agilaive AV Trend Manval Chapter 2 Configuration To create the instrument go to the Logger Channels os
56. ibration program Digital I O show the current status of all physical or remote Modbus digital input output points teen zee EYA sone EMAS 12520 EMAS 281e EYZ 199 00 Kea Arte JILDLI LOSTI Wro ietbos Verio 2A4 Rs MEILNZII ILJADOI IiE Realtime Graph in Status Displays gt RealTime DataTrending Graph showing both Chart and Grid 105 Agilaive AV Trend Manval Chapter 4 Data Editors Tabular Display The Tabular Display provides a series of LED like displays which can be zoomed in to time series charts The chart display is very useful for mixing multiple display averages instantaneous minute hourly etc on the same page Boxes can be dragged to create a custom layout and the layout can be saved for future recall Because of the complexity of the elements in the layout they are stored separately than the regular Favorites system RealTime Tabylar Display i Crore Im Trend FE Revit tabular Display g Realtime Date Trending 62 gt Miller NCAM ETMA OOM x 6O Miller NEAM PM25001H x 6O Mille NCBAM_RHOOLH 60 Miller NC BAM_ETMP 60 Miller_ NC BAM_PM25 60 Miller NC BAM_RH Emm E Eee EECeEEr er 44 23 2011 16 00 00 DEGC 11 23 2011 16 00 00 UG M3 11 23 2011 16 00 00 PERCENT 60 Miller NC BAM_VOL 01M a x 60 Mille_NCOZ FLOW INSTANT D 8 60 Miller_NC OZ_PRESS INSTANT 6 60 Miller NC BAM_VOL 60 Miller NC OZ FLOW ft NC OZ_PRESS 11 23 2011 16 00 00 M3 11 23 2011 17 53 00 11 23 2011 17 53 0
57. ing up the Add a Favorite screen Give the favorite a name a description optional and select User or All Users global and select from the following options Launch on Application Startup to run the Favorite upon logging in to AV Trend Run Query on Launch to execute data retrieval when the Favorite is selected Favorite Detail Favorite Query Favorite Details Menultem T X Favorite Name Average Data Editor Favorite Description September hourly 2009 Favorite Scope User X User z Launch on Application Startup Run Query on Launch Add a Favorite screen 90 Agilaive AV Trend Manval Chapter 4 Reports You can also configure the Favorite by selecting the Favorite Query tab after you select Save as Favorite From this screen you can adjust the site parameter list date range or average interval These values can also be adjusted later in the Favorites Editor in the Configuration menu To return to the ribbon controlling the current application select the top menu function above the ribbon for example Average Data Editor To use an existing Favorite select Favorites from the top menu above the ribbon bar select User Favorite or Global Favorites and the saved Favorite Add a Favorite Detail Favorite Query Parameter Selection Drag a column header here to group by that column a4 Site Name Parameter Name Parameter Template 4 amp Knox OZONE ZOME So O Average interva
58. ion types Automatic Externally Initiated Instrument Controlled Interactive Menu User Initiated For details about the remaining prompts Consult the ESC Model 8816 8832 Data Logger Manual gt Note Configuration information must be downloaded to the data logger before a new sequence can be initiated El Average Alarm EN Add Channels gt fce Details Data Source Details Ti Add Digital Events gt Automatic Externally Initiated as Instrument Controlled B Logger Modbus Instrument k Interactive Menu User Initiated DBaDBDG Calibrations L Cait Digital Event Programs Modbus Instruments Adding calibrations in Configuration Editors gt Logger Channels 33 Agilaive AV Trend Manval Chapter 2 Configuration Calibration Expected Values Editor This mimics the Quick Expected Values editor in the Model 8832 data logger that allows the user to quickly update target values for the calibration without sorting through the Calibration configuration editor The system shows all configured calibrations as expandable collapsible boxes Once opened columns headers can be clicked to sort by phase name expected value etc for easier data entry oae uveeetev 0 amp Close Clove Cost Configuration Das Reports Usije lst Sts Helpand Al But Current Editors e Editors bd Editors Displays gt Support Tasks WH AQE Text import Toot PE SO trmcation Too S Datch
59. l Description ovid 24 hour areragefrom 24 hours p sonam Hour averogeor Se eRe memm 001m Minute averagefrom instantaneous 003d 3 day average from 1 day Query String DateRangeType CurrentQuarter amp SourceParameters 209400 5 b391 del 1 a519 00173 1c6edfb ecJdabc3 eb 90 del 1 8455 001731 cheBfb amp Averageintervals lt 71a20a1 43t9 dd11 9b87 001e8c005352 Favorite Query tab from Add a Favorite 91 Chapter 4 Data Editors Average Data Editor The AV Trend Average Data Editor Data Editors gt Average Data Editor combines multiple functions into a single tool Editing data point details Batch editing Comparison of current data with historical minimum maximum and mean Analyze Exported In addition you can toggle between the following six formats by clicking buttons in the ribbon at the top of the screen Linear Table the default display Cross Tab Table e Matrix Table Time Series Graph can be used for single or multiple parameters but the historical comparison tools in this X Y scatter plot only appear in single parameter queries Scatter Plot graph requires queries of two or more parameters Histogram for single parameter queries 92 Agilaive AV Trend Manval Chapter 4 Data Editors View Favorites Average Data Editor i B Retrieve Export Cross Matrix Time Series Scatter Histogram Data to Excel Tab Data Data Graph Plot Average Data Options i Presentation Options
60. lect ones sara 1 1472161209 tep 17216 1 203 3885 Properties and open the Computer gt E Name tab Loginto HP_SERVER Usemame admin Password COLLLLLI Enter admin as the Username click Set Password and enter Agilaire Click the Test Connection button to Protie Infomation see if AV Trend is communicating with Profle Name HP_SERVER the database Uinn prera Service Gateway URL Example tep MYSERVER S885 Leave blank for deect chent no server features se 8 Cenoman Z Automatically choose this profile AV Trend Profiles Agilaive AV Trend Manval Chapter 1 Installation Accessing Frofiles After Logging In After you are logged into AirVision you can access the Profiles screen by clicking the AirVision icon in the upper left corner of the screen beside the Save icon From this Profiles screen you can Save Capture the AirVision screen Print Close the Profiles screen You can also open AirVision Options which brings up the same Profiles screen you saw when you logged in You can close AirVision altogether by selecting the Exit button Ge a Save Ctrl S e Refresh lt Screen Capture Form gt P Print gt Ea Close AirVision Options If Exit AV Trend Profiles seen by clicking the AirVison icon in the upper left corner of the AirVision screen after you have logged in Chapter 2 AV Trend provides nearly unlimited flexibility in setting u
61. lue The Days selector can be used to compile nearby days for the same hour into the comparison statistics An example of how this is applied would be Current Data 1 15 09 Number of Years 3 Days 1 1 5 09 data at hour 00 would be compared against statistics using the following points 1 4 06 hour 00 1 5 06 hour 00 1 6 06 hour 00 1 4 07 hour 00 1 5 07 hour 00 1 6 07 hour 00 1 4 08 hour 00 1 5 08 hour 00 1 6 08 hour 00 Obviously selection of a large data set with a long look back period and large skews can be very processor intensive for the client and the SQL server for large data sets Agilaire recommends this tool be used for data sets of roughly a week or less 101 Agilaive AV Trend Manval Chapter 4 Data Editors Scatter Flot raph The Scatter Plot Graph allows any two parameters in the existing chart to be plotted in an X Y chart The Y axis parameter is the primary parameter and all data points are color coded according to the Data Flags color mappings to help distinguish outliers that have already been flagged Come en ae ar Scatter Plot Graph from Data Editors menu with hover over displaying date time and data value 102 Agilaive AV Trend Manval Chapter 4 Data Editors H Stomram The Histogram provides a graph of the distribution of values for the entire data set but it is designed to display only one parameter at a time so be careful not to use multiple parameters The
62. n ascending order and provides the same right click menu as the Linear Data Editor Paremetet Avenge Interval Vibe Rew Valor AQS Nai Code Quabtier Codes ute Grade t Cross Tab Data Editor from Data Editors menu gt Note You can sort data by any column by clicking on a column header You can find all flagged data easily for example data grouped by data logger flag Each group can then be expanded and individually sorted When you change editor modes the groupings are not kept Also you can click hold and drag columns to change the order and click drag columns to the Drag a column header here to group area to group data If you do this accidentally or change your mind you can drag it back 96 Agilaive AV Trend Manval Chapter 4 Data Editors Matrix Pata Editor The Matrix Data Editor presents data in a format similar to the monthly report If you select multiple parameters they are grouped with a plus symbol for expansion E Ei 02 Oth N m Nkana Matrix Data Editor from Data Editors menu 97 Agilaive AV Trend Manval Chapter 4 Data Editors Time Series raph You can generate the Time Series Graph in two modes for one or more parameters In multi parameter mode you can group different parameters together for any time period With the tools at the bottom or the screen you can change the color scheme remove or restore the legend and print the graph The minus sign in the upper left corner
63. n be installed the following software must be installed on your computer SQL Express 2008 with all available service packs as well as NET Framework version 3 5 AND 4 0 SQL will request that the Windows Component Internet Information Services IIS be added but IIS is NOT necessary for AV Trend and does not have to be enabled Install ng Microsoft NET Framework If you don t already have the latest version NET Framework installed on your computer you can download it from the Microsoft website Follow the instructions in the installation wizard Install ng SRL Server Before SQL Server can be installed NET Framework version 3 5 must be installed To install SQL Server Express insert the CD or DVD and follow the instructions in the wizard In the first screen check the box to accept the license agreement and click Next The default features are sufficient in the Feature Selection screen but you can select the program features you want installed The most important feature to install is Client Tools Click Next Agilaire recommends Windows Authentication Mode The purpose of Authentication Mode is to specify the security used when connecting to SQL Server If you select Windows Authentication Mode a password is not required If you select Mixed Mode a combination of Windows Authentication and SQL Server Authentication you must enter and confirm a password for the System Administrator logon user name sa Cli
64. n change their own Password Email and Name but not their User Name in the My User Info screen in Configuration Editors gt Security If a User Name needs to be changed for example if a name is misspelled an Administrator would have to delete the original User Name and add a new one amp My User Info s User Details Account UserName r Email Set User Password Name Fist Midde Last Tile Contact Addresses Task Report Alarm ADVP Ure Label Addr Notifications Notifications Notifications Notifications Bw A 5 T o o Add Contact Address Profile HP_SERVER Version 2 2 2 Build 2011 02 16 3 3 29 2011 14 49 x merr My User iNFO screen in Configuration Editors gt Security 62 Agilaive AV Trend Manval Chapter 2 Configuration Arovp Fermissions Finally define the permissions for each User Group using the Configuration Editors gt Security gt Group Permissions Editor Select a Group in the drop down list The list of configured users is displayed and users can be added here as well The right panel shows the various rights available in the system and the status for the current group Grayed access disabled Black underlined access enabled Black italic access enabled by inheriting from another granted access In this example access has been granted to certain Security permissions Groups Users and User Groups but not Edit Tasks Access is granted
65. n phases in Configuration Editors gt Logger Channels 36 Agilaive AV Trend Manval Chapter 2 Configuration Externally Initiated Calibration Externally initiated calibration is identical to an automatic calibration except for the way it is initiated The sequence is started when a specified pattern of input control lines is met To configure the Start Pattern Line Status Pattern click the Start Pattern button Individual phases are then initiated sequentially As with an automatic calibration the duration of each phase in the sequence can be specified Configuring Externally Initiated Calibrations in Configuration Editors gt Logger Channels 37 Agilaive AV Trend Manval Chapter 2 Configuration When you click the Start Pattern button in the Externally Initiation Calibration screen you will see a Line Status Pattern screen Check the Select box to select an Input Line and select a Status of On or Off The Externally Initiated Cal will begin when the Start Pattern is met Line Status Pattern X Start Pattern Select Line Number Name Status W 1 Input Line 1 Off On Vv 2 Input Line 2 Off On A 3 Input Line 3 Off On F 4 Input Line 4 Off On mH is Input Line 5 Goff On P 6 Input Line 6 Off On mM 7 Input Line 7 Off On rl s Input Line 8 Off on F 9 Input Line 9 Off On F 10 Input Line 10 Off On AH 11 Input Line 11 Off On A 12 Input Line 12 Off On F
66. nce to tree line and a Value for example 70 feet When you have completed your entry press the Enter key on your computer keyboard Your entry will be moved to the next row in the Additional Information section 15 Agilaive AV Trend Manval Chapter 2 Configuration Adding Farameters To add a parameter configuration highlight a Site from the Parameter Settings tree diagram and click the Add Parameter button near the top of the AV Trend screen To edit a parameter select a Site and then double click a Parameter amp Site 01_KN Parameter X Site Parameter Template E3 bd Parameter o Parent Parameter s X Enabled a Enable AIRN ow Reporting r Truncate Round Rule Round Truncate Fiker From Web Site O Reported Units 7 Parameter Data Type Average Continuous Analyzet Units if different a a Composite Sample C Particulate Sample Graph Minimum Datoriali Graph Marimum EPA POC Calibration Span Instr ion Li TE Instrument Detection Limit Limit Of Quantization EPA Units Minimum Detectable Limit EPA Parameter ag oane Practical Quantization Lirnit Reported Digits di Parameter Report Order Precision pe x Totalize in Reports Minimum in Reports Additional Information Parameter Configuration from Parameter Settings in Configuration Editors 16 Agilaive AV Trend Manval Chapter 2 Configuration The Parameter screen displays the following fields Some of the EPA Code fields a
67. ne 8 Input Line 9 Input Line 10 Input Line 11 Input Line 12 Input Line 13 Input Line 14 e OR AND Cancel OK Trigger Digital Input Line Status Pattern with OR AND selection 44 Agilaive AV Trend Manval Chapter 2 Configuration gt Note AV Trend version 2 1 and up supports download of logger I O labels with a different number of inputs and of outputs If the number of input and output cards on your data logger are not equal you may encounter some download errors when downloading the labels If this happens define the actual number of physical inputs and outputs using the IO Labels tab If you are using pseudo inputs outputs do NOT accept allowing the system to change the number of labels Profile HP_SERVER Version 2 2 2 Build 2033 02 163 3 9 20 Different number of Inputs and Outputs Configuration Editors gt Logger Channels gt doubl Logger in tree menu gt I O Labels tab 203 e click 45 Agilaive AV Trend Manval Chapter 2 Configuration Configuring Di Triggered GSI Events These events are used to send GSI strings based on the transition of a digital input or of a pseudo DI DO pair in the logger Commonly these are used to control RS 232 based calibrators or other devices For this device a digital input pattern is defined When the logger sees the digital input transition to match this pattern the GSI string is sent out the designated serial port just once The string i
68. nteger 0 255 Default Modbus Command Type 3 or 4 Consult the Model 8816 8832 Data Logger Manual for details on the use of these fields 60 Agilaive AV Trend Manval Chapter 2 Configuration Configuring Security User security in AV Trend is set up by administrative personnel and is similar to Microsoft Windows Each system user has an identity including a username and password A User may be a member of one or more User Groups Access and rights are assigned to User Groups User Groups in AV Trend are usually assigned by job responsibility e g Data QA Site Technicians System Administrators A group can optionally have its access limited to only certain monitoring sites Users can be members of more than one Group and each site can have a different access group User Editor Administrators can add or delete users open Configuration Editors gt Security gt User Editor and click Add User or Delete User button Enter an Email address optional Click Save a User Editor x Users User Details Account SiteOperator User Name Email Set User Password Name Fist Middle Last Title Contact Addresses Task Report Alarm ADVP Ure label Address Notifications Notifications Notifications Notifications a E a a a a a Add Contact Address User Editor from Configuration Editors gt Security gt User Editor 61 Agilaive AV Trend Manval Chapter 2 Configuration My User Setti nas Non administrative personnel ca
69. o to to to to te to to a ee ey ae By ee mi ka t To Go Bo Show Legend Graph Theme Northen Lights Print 8 Matching Records Retrieved Query Duration 62 Miiseconds Profle HP_SERVER Verior 20090823004 8 25 2009 459PM 2 Time Series Graph with a single parameter selected and hover over displaying date time data value and flag 100 Agilaive AV Trend Manval Chapter 4 Data Editors If the database contains data from previous years for the same parameter those previous years can be graphed in the Time Series Graph alongside the current data by selecting Show History and the number of years you want to graph Each previous year is graphed individually Select Refresh to update the graph eae TEL ee atego Patten te stew age Date ate z Seton oem Ecoren beman ete Series neno mo reg o istana toote tne te pap by Ad aama wea onser e as vane o emae xeme wee me ege reve Zi com i a meg rie s OO orn ma e meege nee tee gt Summer ppe E lt lt e gt tanto aseton atwemens SN ane I Ia o CO Deen feet Oane OD ee of ere J Om ai i Se a a i a a KA KA n i 4 ES B lt t k lt Ke 4 4 4 4 gt YY ey to to to to il inoa i ogma Get Dene aH gt owe 1 muenmgioa Heer rev tunter Mersan i atte fost Vorwar EAE S PETE Time Series Graph with a single parameter and Show History option and hover over displaying date and time data va
70. of polling tasks running in a single system To set up task groups Open the Task Wizard Configuration Editors gt Task Scheduler gt Run Schedule Wizard button on ribbon at top of screen and click Next Select Site and Source including Source Type Description and click Next i Task Wizard Source Polling Select data sources to poll Source Name Source Type Description a Selecting Site and Source Name in Task Scheduler Wizard Configuration Editors gt Task Scheduler gt Run Schedule Wizard 55 Agilaive AV Trend Manval Chapter 2 Configuration Select Poll Types types of data to poll from the following checklist Sync time Averages Calibrations Input line changes Alarm journal Power failures Chart memos Central messages Click Next ES Task Wizard Poll Types Select the types of data to poll Syne time Average Interval Description 001d 24 hour average from 24 hours gt i ainisg Minute average from instantaneous Input line changes 003d 3 day average from 1 day V Averages VY Calibrations 001m 005m 5 minute average from 5 minutes 006d 6 day average from 1 day 006m minute average from 6 minutes Central messages 010m 10 Minute Average from 10 Minutes 015m 15 minute average from 15 minutes Power failures Chart memos Poll Types in Task Scheduler Wizard Configuration Editors gt Task Scheduler gt Run Schedule Wizard 56 Agilaive AV Trend Manval Select the f
71. ogger 31 Agilaive ANV Trend Manval Chapter 2 Configuration Downloading Channel Configurations To download channel configurations open Utilities gt Logger Download Configuring channels was explained in the section Adding Channels to Data Loggers select the Site Source Name and Channels for the Download Type click Download The Log Viewer will display details of the download in the bottom section of the screen gt Note The Log Viewer can also be accessed directly from the Utilities menu gt Note Multiple loggers can be downloaded at the same time without a cold start 07727 2009 13 20 TOPOL Standard Averaging Channel l Parmeter 70OTONE 077 2772009 t3 20 TCHOL Standard Averaging Charmei Parmeter 17KO 07 29 2009 13 20 TCPOL Standard aes C Charnel c Parmeter 170302 4 Tere ot 13 2048 373 lt Response Ola bb s 132048403 gt Requeiteg TCPO S017802 OAPPM ONMOTONON 122048523 ca lt Reiponie Ola bd BABS o Requesting JTCPO GONTIVWOR O4ADEG OMI MOO7DNOV 132048713 et oma ie at m Channel Download in Utilities gt Channel Download 32 Agilaive AV Trend Manval Chapter 2 Configuration Setting Up Calibrations To configure calibrations open Configuration Editors gt Logger Channels highlight the Logger in the tree diagram click the small arrow under the Add button select Calibrations from the drop down list select one of the following calibrat
72. olled or appear in report editor selections To comply with EPA standards enter latitude in decimal format For example 75 degrees 15 minutes and 0 seconds would be entered as 75 250000 Enter up to 2 places and a minus sign if needed to the left of the decimal and up to 6 places to the right of the decimal To comply with EPA standards enter longitude in decimal format For example 75 degrees 15 minutes and 0 seconds would be entered as 75 250000 Enter up to 2 places and a minus sign if needed to the left of the decimal and up to 6 places to the right of the decimal Two character site code provided by EPA Optional reference for internal use only not used by EPA Used to calculate a projected forward rolling eight hour average for ozone if needed computed with the slope intercept formula required by EPA Used to calculate a projected forward rolling eight hour average for ozone if needed computed with the slope intercept formula required by EPA 14 Agilaive AV Trend Manval File Import Code EPA County or Tribal Code Address Additional Information Chapter 2 Configuration Single character used for file import templates in special cases only File Import is not available in AV Trend County or Tribal code provided by EPA Physical address of the Site You can add notes at the bottom of the Site Editor by clicking on the asterisk at the bottom of the screen Enter a Name for example Dista
73. ollowing configurations from drop down lists when the task will start how often it will be repeated and which server will execute the task The next screen will ask you to Confirm Task Creation Click Next to save new task to database The last screen will say you have successfully completed the wizard Click Finish Chapter 2 Configuration Beles ES Task Wizard Task Schedule Configure when this task will be executed When should this task start 08 05 2009 10 01 30 How often should this task be repeated 1 Hourfs v Fi Which server should execute this task AGILAIRE 7912B9 Task Schedule in Task Scheduler Wizard Configuration Editors gt Task Scheduler gt Run Schedule Wizard 57 Agilaive AV Trend Manval Chapter 2 Configuration Favorites Editor AV Trend simplifies regular tasks with a list of user ETA defined Favorites which function like Favorites in 7 khi Internet browsers Favorites can be created for most Ded l l Home View Favorites menu items including reports editors configurations journals calibration functions security settings logger E g B functions emails and task scheduling Favorites canbe M G J saved for different sites parameters average intervals 53e as My Global and date ranges They can be saved for all users or for Favore Fovortes m avortes oneuser Favorite Tasks Favorites menu Creati nga Favorite To create a favorit
74. p n n systems and configuring servers This chapter explains how to set up the following parts of AV Trend Configuring System Preferences Ay Tren Configuration Editors gt Parameter Settings Lea Configuring Server Preferences Configuration Editors gt PC Configuration Setting up Sites and Parameters Configuration Editors gt Parameter Settings Configuring Parameter Templates Configuration Editors gt Parameter Template Editor Adding Loggers to Sites Configuration Editors gt PC Configuration Adding Channels to Data Loggers Configuration Editors gt Logger Channels Adding Communication Routes Configuration Editors gt PC Configuration Associating a Logger to a Logger Driver Configuration Editors gt PC Configuration Testing Your Connection Utilities gt Link to Logger Downloading Channel Configurations Utilities gt Logger Download Setting up Calibrations Configuration Editors gt Logger Channels Scheduling Tasks Configuration Editors gt Task Scheduler Adding Users Configuration Editors gt Security gt User Editor e Adding Favorites Configuration Editors gt Favorites Editor For information about starting the AV Trend Service and logging in to AV Trend see Chapter 1 Installation 10 Agilaive AV Trend Manval Chapter 2 Configuration Configuring System Freferences To set up system preferences open Parameter Settings from Configuration Editors and doubl
75. pter 2 Configuration Adding Communication Rovtes The next step is to identify to the AV Trend Server how to communicate with each logger by Communication Routes Typically for AV Trend Systems this would be a TCP IP or a direct Serial Connection After you configure the Source data logger or instrument Go to Configuration Editors gt Logger Channels and double click the Logger icon Click the Communication tab to configure a Communication Route for each logger If your logger doesn t appear in the drop down list click the Device Route button in the bottom of the screen of the Communication tab to select one of the communication routes described below Normally AV Trend uses only TCP or Serial Routes Adding TEF IF Rovtes gt Note TCP IP connections are easier and faster than modems For sites with a TCP IP connection in the TCP Connection Details section of the screen Click the Device Route button in the Communication tab and select TCP Enter a Route Name e g Agilaire Enter a Network Address e g 172 16 1 The defaults are set for 8832 defaults but can be changed based on your network route definitions Polling Port at 9881 Emulation Port at 9887 In the Advanced section of the screen Select Read Timeout from the drop down list if directed by Agilaire Support Select Write Timeout from the drop down list if directed by Agilaire Support Select Disconnect After from the drop down list if directed by Agilai
76. r On Serverk Average Data Purge Options onmieanensonnenreseveooananenensssesneniegesesssnonsensnanseciecsnessenasoneensoepeniey Interval to Purge 001m Minute average from instantaneous V Retain Readings During Calibrations Parameter Selection All Parameters Drag a column header here to group by that column C Selected Parameters a Selected Site Name Parameter Name Parameter Template Name lt Z E Purge or archive data in Configuration Editors gt Task Scheduler 43 Agilaive AV Trend Manval Chapter 2 Configuration Fill Average Data Gaps Task prepopulates Average Data Records to make them continuous where data is missing This task inserts top of the day blank records in the database to improve reporting and data query performance Filling average data gaps is critical for optimizing the performance of AV Trend reporting and should be configured to run every day after midnight in every system Each system needs only one of these tasks The screen defaults to a repeat interval of one day and a time to run of 00 00 00 midnight Journal Message Purge Task removes Event Log journal messages internal error logs that are older than a specified age in seconds minutes hours days weeks or years The purge occurs at a specified Repeat Interval An option is available to Archive Data Before Purging Agilaire recommends purging entries older than 2 weeks Logger Poll Task polls a data logger at a specified Repeat Interv
77. r Settings Monthly Reports will show a minimum of data rather than an average or a total Totalize in Reports and Minimum in Reports are most commonly used for rainfall za Monthly Report x Report Criteria Start Date 03 01 2011 00 00 Drag a column header here to group by that column End Date 03 07 2011 23 59 Ay Site Name Parameter Name Parameter Template Options Aw A A s Agilaire NO NO Hours for Rolling Average oo Agilaire NO2 NO2 Rolling Type Backward Agilaire NOX NOX C Forward Agilaire WOR WOR_HIGH gt Atte AA Pr ANSPHIGH Flags V lt Monthly Report Query 87 Agilaive AV Trend Manval Chapter 3 Reports Monthly Reber with Parameter ee If AQS Null Codes have been set for invalidated data they are displayed in the Monthly Report If Site Codes and or Parameter codes have been selected in the Configuration Menu they will be included in the Header Options are provided to show null codes or flags when an invalid hour is shown on the report These options are also available in the Scheduled Task options Agilaive AV Trend Manval Chapter 4 Reports CurentOate 1018 2010 TEP eae a yoo a EL ee SN non ems OM poe ae py me 7 SiteName Ag aire ER T Avg imterval 1 hour Parameter OZONE Units PPM ai n a nin Spppppggogpogangp aninj n sj jre o n n ecm ay l i i i l l SEN aail banad Baad or 006 005 005 005 s s
78. rate Report icon A Power Failure Report will be displayed in the bottom section of the screen Each site logger is shown in a separate page Logger Power Failure Report Site Name SITEONE Site Description SITE 01 Logger Name Logger01 Logger identifier Failure Time Restored Time 11 25 2007 12 00 00 4M 11 25 2007 12 01 00 AM 11 25 2007 12 01 00 AM 11 25 2007 12 01 00 AM 7 2 2008 10 56 00 AM 7 2 2008 10 56 00 AM Power Failure Report 86 Agilaive AV Trend Manval Chapter 4 Reports Monthly Report Monthly reports provide a matrix view of a single parameter showing values for the entire month Invalid or flagged data is shown with a color background or font change defining the data condition Statistics are provided for each row day and column hour To run a Monthly Report 1 Select Reports gt Monthly Report 2 Select a Start and End date 3 Select number of Hours for Rolling Average 4 Select a Rolling Type Backward or Forward 5 Select the Parameters that will be displayed in the report 6 If you want the Flags Legend to be shown in the report click to select Flags You may have to scroll down to see the Flags option 7 Click the Generate Report button on the Ribbon gt Note If Totalize in Reports was selected in Configuration Editors gt Parameter Settings Monthly Reports will show a total of data rather than an average If Minimum in Reports was this option was selected in Configuration Editors gt Paramete
79. ration Report e Parameter Configuration Report Scheduled Tasks Report Site Configuration Report Internal Reports Journal Message Log Software Version Report LogBook Report Logger Reports Alarm Journal Input Line Status Report Power Failure Report Monthly Report 64 Agilaive AV Trend Manval Chapter 4 Reports Criteria Fane All reports use a Criteria Pane to select a time range and list of pollutants for the report Minute average from instantaneous 3 day average from 1 day 003m Ts minute average from 5 minutes 6 day average from 1 day 6 minute average from 6 minutes 10 Minute Average from 10 Minutes 15 minute average from 15 minutes Report Criteria pane in Reports gt Daily Summary Report You can select the Date Range any of the following ways Manually type in a month day year and time Click in a date field the month date year hour minute and click the small up or down arrow keys to raise or lower that field month day year hour minute It isn t necessary to highlight the field just put the cursor in it Use the bigger down arrow control to bring up a Calendar You can click the arrows to change the month or click the name of the month or year to bring up a list Use the Star button to select from a pre defined date range Current Day Yesterday Current Week Last Week Current Month Last Month Current Quarter Last Quarter Current Year
80. re Support Select Inter byte Delay ms to slow the inter character transmission speed Click the Save button 27 Agilaive AV Trend Manval Chapter 2 Configuration Adding a TCP Route in Configuration Editors gt Logger Channels 28 Agilaive AV Trend Manval Chapter 2 Configuration Adding Serial Rovtes for Direct Communication After you configure the Source data logger or instrument Go to Configuration Editors gt Logger Channels and double click the Logger icon Click the Communication tab to configure a Communication Route for each logger Click the Create New Route button in the Communication tab to select Serial route In the Serial Connection Details section of the screen Enter a Route Name e g Agilaire Enter a Comm Port Select a Baud Rate from the drop down list The default is 9600 Select Data Bits from the drop down list The default is 8 Select Stop Bits from the drop down list The default is 1 Select Parity from the drop down list The default is None In the Advanced section of the screen Select Read Timeout from the drop down lis if directed by Agilaire Support Select Write Timeout from the drop down list if directed by Agilaire Support Select Disconnect After from the drop down list if directed by Agilaire Support Inter byte Delay ms can be used to slow the inter character transmission speed Click the Save button gt Note Communication Routes can also be added in Configuration Editors
81. re used only if your license supports full Ambient Reporting Site Parameter Parent Parameter Parameter Template Enabled Enable AIRNow Reporting Filter from Web Site Parameter Data Type Description EPA POC EPA Method The Site you selected in the Parameter Settings tree diagram will automatically be displayed Alphanumeric characters to identify the Parameter A Parent Parameter can be designated to form relationships that can be used for drill down in the Data Editor For example a primary analyzer pollutant such as NOx could be a parent and designated diagnostic parameters such as sample flow or box temperature could be children Another example would be to assign particulate parameters as parents and metals for XRF X ray fluorescence analysis as children If the parameter has a parent parameter select it from the drop down list Parameter information can be filled in automatically by selecting a Parameter Template which will set up EPA codes and units Basic Parameter Templates are provided in AV Trend If you want to automatically fill in parameter information using a template select a parameter template from the drop down list and click Apply If you have converted your data from E DAS and the information is already filled in you can still select a template but if you click Apply or it will be overwritten Check the box to enable the parameter Not used in AV Trend Check the box to
82. rt Lines QualRangeExample _ Range ole i gE id OD Cross Matrix Scatter Histogram Display Toggle k Excel Dats Tob Date Date Plot NuliCede Sold Ruk Presentation Options Pl ousthangefxampie Selection Critera J Show inalid 25 Empty C Use Dynamic Scaling Leeren J 7 Use Dusi Ranges Dusi Range Threshold 20 O OMPRIDGE 42_WSSCAL 00ih O OMRIDGE 44_WOSCAL 001h e gt fii A aot 2 ee 9 D a ha ay wa Pra EN N ye z z amp ty Se a o KS eq Kn os w w ta a ta yon a ww e Mi wW Me wN a I Prie Profile E6S00 Vertion 2611 Bull 201206071 6 11 2012 MU Dual Y Axis function 99 Agilaive AV Trend Manval Chapter 4 Data Editors For one parameter you can choose previous intervals to be other than one year by selecting Show History from the options above the graph If you bring up the Time Series Graph in single parameter mode you get additional options at the top of the graph Show History displays N previous years of data alongside main graph Show Statistics displays cumulative statistics of N previous years min max avg Number of Years Days allows rolling average of additional days in historical statistics Refresh J Show Invalid ac Empty ShowHistorey O Show Statistics Number of Years 07 A D 0 Refresh 100 O Nox OZONE 01h 0 7o 60 4 SS SS so J pa aom Stewie 40 2 4 20 4 10 4 ot p t
83. rt Time Repeat Interval Scheduled Report Task Generates Report at assigned time for True 3 2 2011 11 5402 AM 1D output Logger Poll Task Data Logger Polling Task Tre 332011 123432 PM ID Thursday March 17 2011 Page lof Scheduled Task Report Reports gt Configuration folder gt Scheduled Tasks Report T1 Agilaive AV Trend Manval Chapter 4 Reports Site Configuration Keport To run a Site Configuration Report Reports gt Configuration folder gt Site Configuration Report select a Site or Sites and click the Generate Report icon on the Ribbon Site Con fi gurati on Report Agilaire Latitude 35 9605 Longtude 83 9208 Time Zone EST Descnpton man site Abbreviation 01 904 Astros aia Agency Code 0581 City Knoxville State Code 47 County Knox CountyCode 093 Zip Code 37918 Site Code Thursday March 17 2011 Page 1 of 1 Site Configuration Report Reports gt Configuration folder gt Site Configuration Report 78 Agilaive AV Trend Manval Chapter 4 Reports Daily Favameter Report The Daily Parameter Report shows a single day summary for the entire monitoring network grouping parameters together by the Parameter Template but showing all sites sharing that parameter template Parameters that do not have a parameter template designated are not reported To generate a Daily Parameter Report Reports gt Daily Parameter Report select Start and End Dates an Average Interval Site Name or Names and Parameter N
84. ry Editor ally Sample Data Editor Log Book Entry Details EJ ust eors Log Enty Time 06 02 2010 11 06 User AirVision X User Enty Time 06 02 2010 11 06 Sie Agilaire lt gt Profile HP_SERVER Version 1 0 S Build 2010 04 25 1 6 2 2010 11 08 _ Adding LogBook entries in the LogBook Entry Editor from the Editors menu By default the logbook entries do not accept changes or addendums after the record has been saved A system option is available to allow addendums to be made To enable this contact support agilairecorp com 104 Agilaive AV Trend Manval Chapter 4 Data Editors Realtime Display The Model 8872 has three main realtime display programs to keep you informed of the realtime status of the readings calibrations I O status and averages Realtime Trend is the same display used by AV Trend to provide strip chart likes trends and basic tabular displays Tabular Display provides a series of LED like displays which can be zoomed in to time series charts This display is very useful for mixing of multiple display averages instantaneous minute hourly etc on the same page Site Node Logger Tool Box is a blend of three tools Readings current readings and buttons to control display maintenance or offline status of the channels used to mark channels online offline or in out of maintenance Calibration shows the current status of calibrations and allows you to start or abort a cal
85. s oos oos cos mos sos oos mos m05 mos sos os os mos mos sos ses os os oms oss 2s 02 006 005 005 005 ws 006 005 005 005 005 ss oos oos os 00S as oos oos oos 00S mos s oos oos OOS Oos NO Co os os os os we e oos oos oos os ws oos oos oos oos we oos oos ee oos we oos oos 0005 Oos 24 04 ows os os oos as os oos oos oos sos as oos oos oos oos se oos oos oos oos aos RM 26 2007 oma aaa as os 3401 asta acer 3s0r 2000 aam 3em 30 3000 gt 3406 3473 3438 2427 3922 3910 3872 242 34m 3405 390 341 asn asn asa 342 300 s EEEE EIEEE Or 358 3608 36 Sed JEN J04 305 305 JOT JT 3408 348 3S7 3 39 3528 342 JSD 942 9519 3411 3500 3SN 3S IS IMS N JEEE ET Ds 390 7 0 3007 9510 MM 222 350 a508 9000 asta ere ney 351 2402 2 408 200 200 20 24 2405 242 2a Dae D4 De 94 36M 28 WO 3402 34m 2907 2510 2526 259 260 2645 ASAT ISIT 2402 249 2407 IST 2510 3522 3522 ISW 3615 2814 2509 2501 251 250 36 367 24 MO 3437 3495 344 3444 3506 3572 3482 2400 3408 2482 3461 244 9437 9494 94 9431 2439 ISN 940 2497 2597 2472 9421 ISH IM J N n 3sm asa 3442 3501 3507 3 678 aama 3400 2401 3477 3444 asm 2408 390 398 aan asn 3404 aan asn ase aa aan amn a98 am a BO Sm 3495 3SM JAT 340 349 35 9642 3 590 w 003 003 203 200 oo 2m a N 4 0 0 002 002 eo oe oe 902 902 003 003 200 oor ow ows 4 002 00 00 004 Os ooa D04 00s Oe oe 002 lws 903 009 0003 oo
86. s 26 wo om OO oo p04 Tw 002 T 903 secrete mie at m oe ete ae a Ei 7 178 1 8 1 Monthly Report gt SomeDataMissing Max Exceeded Min Exceeded lt Logger Invalid Suspect a Audit B Bad Status C Calibration c Ceiling Limi D Channel Disabled E Edited e Site Malfunction f Floor Limit H High HighAlamn h High Alarm l Invalidated By Edit J RateofChangeAlarm L Low LowAlarm I Low Alarm M Maintenance m Marked Maint by edit O Overrange o Other P PowerFailure p Precision Check Q Quality Assured R RateofChange v Diginfo i Exceeded W Dig Info 2 X Diginfo 3 Y Dig Info 4 Z COD ig Info 5 z Zero Adjusted Flags Legend in Monthly Report 89 Agilaive AV Trend Manval Favorites AV Trend simplifies regular tasks with a list of user defined Favorites which function like Favorites in Internet browsers such as Internet Explorer You can save a selection of sites parameters average intervals and date ranges for the Average Data Editor or any Data Report Favorites can be saved as a global favorite for all users or as a favorite for an individual user To create a favorite go into any data editor or report complete a query and select Favorites from the top menu The ribbon bar will change to show the favorites menu Chapter 4 Reports mo E Home View Favorites Save as My Global Favorite Favorites Favorites 7 Favorite Tasks Favorites menu Select Save as Favorite to br
87. s not resent until the logger goes to a non matching input state and then back to the matching state E zago x Y 4 Gose Modity Copy Paste Deste Change Calculate Parte active twb Channel Type Memory Usage Config File Editor Options El Average Alarm P Data Source Detads fy Cattreation Expected vi BB Ace Cannas FT DM Ade Calibrations WR Add Digital Ev woz Peremeter Conyers NO2 ai Enable Channel v Base Average Mach Poachers Average Intent in Seite Factor 100000 StorapeTine 115 gt Minste 13 Extended Average 1 Extended Average 2 Average Intervet cise hg Average irtenak corn b StongeTime slis stosgeTime 805 2 Hows ie KON ee a AiVision N Home View Favorites DataSource Details a GZO o E i a2 x P Close Modify Copy Paste Delete Add Change Calculate Parse active tab gt Channel Type Memory Usage Config File Editor Options Add Tools GP Data Source Details R Calibration Expected Values Editor Triggered GSI Event 5 Bl crarneiozone Bii cromeinoe EN tiggerea cst event x Digital Event Details Digital Event Program Name STARTCAL TWioger Digitat input Pattem Enabled Serial Port as Output String START ZERO x0d Profile local Digital Event details 46 Agilaive AV Trend Manval Chapter 2 Configuration Sched ng Tasks All automatic actions in AV Trend are managed by the Task Manager which runs as part of the b
88. sted in the Flags Editor AV Trend is loaded with some default mappings but you can customize this for your system The color mappings are global to all users for consistency In addition AV Trend uses two font changes to represent data in the data editor Bold values represent data that does not match the raw database edited values Italics values represent data that has an annotation Hover the mouse pointer over data values to see details of annotations Right Click Options Each of the three non graphical data editors support select shift select CTRL select click drag selection capabilities and a right click menu options Right click a data point in the Value column to bring up the following menu Restore from Raw copies value from the raw database to the final Value and resets flags Set to Minimum Detectable Limit sets data value to MDL configured in Parameter Editor Set AQS Code brings up a pick list to apply new AQS null codes Set Qualifier Code brings up a selection box for AQS qualifier exception codes View All Flags for single data points only shows all data logger and system flags and allows you to change or clear flags Multiple flags can be displayed in each cell Set Annotations brings up an annotation screen so you can add an annotation Batch Edit allows you to scale two or more selected data values as mX b Original Value times a Multiplier plus a Constant Value for example divide by 10 and cl
89. the Save button New Task Group Task Groups allow multiple tasks to be grouped together in one polling process instead of multiple individual tasks A Task Group consists of Sub Tasks Tasks can be defined to run groups in parallel sequentially or as sub tasks of other task groups to allow mixing of parallel and sequential operations To create a Task Group click the green Add button on the Ribbon in the Task Scheduler and select New Task Group In the Task Schedule Details section of the Task Scheduler select an Executive Start Time and Repeat Interval In the Task Details section of the screen enter a Task Name The Task Description will be filled in automatically but it can be modified Check Enabled if you want the Task Group to be activated when you save it In the Group Options section check the box if you want to Execute the Tasks in Parallel otherwise they will be executed sequentially or as sub tasks of other task groups If the sub tasks are to be run sequentially leave the Execute the Tasks in Parallel box unselected and enter a number in the Execution Order column in the Sub Tasks section To create the Task Group add a Sub Task to the Task Group Click the green Add Sub Task button in the Task Details section and select a task from the drop down list The Sub Task drop down list has the same options as the Add task button at the top of the Task Scheduler When you select a Sub Task from the list
90. tics Average Maximum Minimum and Count are at the bottom of each column To generate a Daily Summary Report Reports gt Daily Summary Report select Start and End Dates an Average Interval Site Name or Names and Parameter Name or Names Click the Generate Report icon on the Ribbon Current Time 3 9 2009 2 18 57 PM Daily Summary Report Site SITEONE 9 1 2007 Interval OO1h Daily Summary Report 80 Agilaive AV Trend Manval Chapter 3 Reports Internal Report The Internal Reports folder contains the Journal Message Log and the Software Version Report Jovrnal Message Log The Journal Message Log Reports gt Internal Reports gt Journal Message Log displays messages about selected Logging Types Logging Types are displayed in a drop down check list when you click the arrow in the Logging Type field Type selections are Fatal Exception Error Warning Startup Shutdown Information Communication Verbose Debug Timed Event or Select all gt Note To log detailed information about a specific problematic Logging Type or Types select that Logging Type in addition to Verbose from the drop down menu before you generate the Journal Message Report Journal Message Report Time Stamp Computer Name Program Name BrentLogType Message Text 0928 2010 10M BIF HP Sara Arsia Cliet Drgum Bo cormection could be made because the target mathine actively refwsed it ATE 16 2 109 9888 09 28 2010 1003390 HP Sara Ars oe
91. tine laboratory operating conditions Parameters in reports are printed in the same order that they are shown under each site Select Parameter Report Order to change the order parameters appear in reports Report Order only applies to Daily Summary and Monthly Reports If this option is selected Monthly Reports will show a total of data rather than an average Totalize in Reports is most commonly used for rainfall If this option is selected Monthly Reports will show a minimum of data rather than a Maximum Minimum in Reports is most commonly used for temperature You can add notes at the bottom of the Parameter Editor by clicking on the asterisk at the bottom of the screen Enter a Name for example Data Last Certified and a Value for example 9 1 2008 To add another row when you have completed your entry press the Tab key on your computer keyboard A blank row will be displayed 19 Agilaive AV Trend Manval Chapter 2 Configuration Adding Loggers to Sites in Logger Channels The next step after configuring sites and parameters is to add Loggers to sites gt Note Data loggers must be added to sites BEFORE channels are configured Channels are added to loggers after the loggers are set up Still in the Configuration Editor single click Logger Channels highlight a Site click the Add button and select Logger enter a Source Name e g 01 Logger enter the Logger ID e g 01 This field is required
92. trl key while you select parameters To save a favorite when you re in any data editor or report complete a query and select Favorites from the top menu The ribbon bar will change to show the favorites menu Select Save as Favorite to bring up the Add a Favorite screen You can also configure the Favorite by selecting the Favorite Query tab after you select Save as Favorite From this screen you can adjust the site parameter list date range or average inter val These values can also be adjusted later in the Favorites Editor in the Configuration menu To return to the ribbon controlling the current application select the top menu function above the ribbon for example Average Data Editor To use an existing Favorite select Favorites from the top menu above the ribbon bar select User Favorite or Global Favorites and the saved Favorite A copy button on the ribbon allows you to copy an existing favorite for slight modification if needed Add a Favorite Favorite Detail Favorite Query C Current Oay Parameter Selection Drag a column header here to group by that column 4 Site Name Parameter Name Parameter Template ala amp a EKknox OZONE QON p i oR SOF Average interval Description Old 24 hour average trom 24 hours 001m Minuteaveragefrom instantaneous 0934 3 day average from 1 day Query String DateRange Type CurrentQuarter amp SourceParameters 209400c5 b391 del 1 a519 001731 c6estb eci
93. uling Tasks Task Scheduler Schedule Task Wizard Favorites Editor Creating a Favorite Favorite Detail Tab Favorite Query Tab GSI Driver Editor Configuring Security User Editor My User Settings Group Permissions Chapter 3 Reports Criteria Pane Filters Additional Fields for Specific Reports Annotations Report Calibration Results Calibration Trend Graph Configuration Reports Calibration Configuration Report __ Channel Configuration Report Parameter Configuration Report Scheduled Tasks Report Site Configuration Report 40 41 41 42 45 45 53 56 56 56 56 58 59 59 60 61 62 63 64 66 67 68 69 72 73 74 75 76 Agilaive AV Trend Manval Table of Contents Daily Parameter Report TT Daily Summary Report 78 Internal Reports 79 Journal Message Log 79 Software Version Report 80 LogBook Report 81 Logger Reports 82 Alarm Journal 82 Input Line Status Report 83 Power Failure Report 84 Monthly Report 85 Favorites 87 Chapter 4 Data Editors 89 Average Data Editor 89 Linear Data Editor 91 Cell Color Codes 92 Right Click Options 92 Cross Tab Data Editor 93 Matrix Data Editor 94 Time Series Graph 95 Scatter Plot Graph 99 Histogram 100 LogBook Entry Editor 101 Realtime Display 102 Tabular Display 103 Realtime Trend 107 Right Click Data 111 installing AV Trend AV Trend can be installed on XP Pro Server 2003 or better through Windows 7 8 or Server 2008R2 4GB of RAM is recommended Before AV Trend ca
94. un an Input Line Status Report select Reports gt Logger Reports gt Input Line Status Report In the Report Criteria screen select a Start End Date and a Site Source Name Click the Generate Report icon An Input Line Status Report will be displayed in the bottom section of the screen Each site logger is shown in a separate page Input Line Report Site Name SITEONE Logger Name Logger01 Logger Identifier 01 Line Number Line N ame Line State Time Of Change Line Description 4 OutPut Line4 v 245 2009 1 38 45 PM 4 OutPut Line 4 2 5 2008 1 38 46 PM 37 OutPut Line37 iv 6 5 2009 12 00 02 AM 37 OutPut Line37 C 5 2009 12 05 01 AM 37 OutPut Line37 y 576 2009 12 00 02 AM DIGUO2 a 6 6 2009 12 00 02 AM DIGOOZ E 5 6 2009 12 05 01 AM 37 OutPut Line37 C 5 6 2009 12 05 01 AM 37 OutPut Line37 v 6 7 2009 12 00 02 AM DIGOO2 Pj 5 71 2009 12 00 02 AM DIGOO2 Bw 6 7 2009 12 05 01 AM 37 OutPut Line37 ry 5 7 2009 12 05 01 AM 37 OutPut Lines N 6 8 2008 12 00 02 AM DIGOO2 Vv 6 8 2008 12 00 02 AM DIGOO2 G 6 8 2009 12 05 01 AM 37 OutPut Line37 6 8 2009 12 05 01 AM Input Line Report 85 Agilaive AV Trend Manval Chapter 4 Reports Pwer Failure Report The Power Failure Report displays Site and Logger Name Logger ID Failure Time and Restored Time To run a Power Failure Report select Reports gt Logger Reports gt Power Failure Report In the Report Criteria screen select a Start End Date and a Site Source Name Click the Gene

AVTrend Manual

Contents

Download Pdf Manuals

Related Search

Related Contents