Home

Cedar User Manual - Custom Instrumentation Services Corporation

1. Acknowledge Status Categor Severity Acknowledge 2 CEMS Turbine 3 Acknowledge CE CEMS Waming Turbine 3 This option only applies to the alarm window It does not apply to the alarm banner at the bottom of the main Data Monitor window The alarm banner only allows the user to acknowledge alarms individually 61 Cedar User Manual 62 User must enter additional text to acknowledge alarms When this option is checked the user is instructed to enter some text usually their name or initials in order to acknowledge an alarm Provide instructions for what the user needs to enter This window appears when a user acknowledges an alarm CORR Acnovadge Ans 1 Warming alarm No Opacity Cal in Over 24 Hrs Enter your name or initials J N Acknowledge Certain alarms can only be cleared with a password manual reset alarms This option is rarely used Cedar can be configured so that the user must enter a password to acknowledge certain alarms Click the question mark button to see the list of alarms that use this option If your facility needs this option to be configured please contact CiSCO software support Chapter 2 Data Monitor Data Monitor Options Alarms Displayed Units In the Data Monitor main window menu click Tools gt Options gt Alarms Displayed Units On this page the Data Monitor can be customized to display alarms only for selected units Dorie as Gener
2. 5 1 6 21 3490053330 11 866461 71 4231 033984 51 3 Everyone 5 1 1 0 BUILTIN Administrators 5 1 6 32 544 anes BUILTIN Users 5 1 5 32 545 aena NT AUTHORITYMNTERACTIYE 5 1 5 4 NT AUTHORITY Authenticated Users 5 1 5 11 BUILTIN Users 5 1 5 32 545 m Enter an account name to add MMyDomainwiohn Smith Remove OF Cancel The upper left box displays a partial list of existing groups Click the Add button to add an existing group to the box on the right You can enter the name of any account or group in the lower left box and click Add to add it to the box on the right When you click OK the account s and group s that are listed in the box on the right will be added to the privilege level SQL Logins To add a SQL Server login to a Cedar privilege level click the Add SQL Login button This window appears 231 Cedar User Manual Add SQL Logins Enter the SOL login to add Readritel ser Separate login names with conmp Enter the SQL Server logins Separate multiple logins with commas When you click OK the login s will be added to the privilege level Permissions After advanced Cedar security has been enabled and user accounts have been assigned to privilege levels you can set permissions for the privilege levels 232 Chapter 6 Cedar Security Advanced Cedar Security Permissions To configure advanced Cedar security open the Ceda
3. Bringing Giant Number Windows to the Front When a Giant Number window is opened and you select a different window the newly selected window may come in front The Giant Number window may become hidden because it is behind the newly selected window To bring the Giant Number windows to the front again click Giant Numbers gt Bring to Front or press Control G on the keyboard h CeDAR Data Monitor tut File View Giant Numbers Trends seca _Tools Window Help Boiler 1 Steam Flow klb hr Boiler Opacity 1181 3 2 2 Any open Giant Numbers windows come to the front of any other windows Any open trend windows and bar graph windows also come to the front If you select a different window the Giant Numbers may move behind the newly selected window again 23 Cedar User Manual Renaming a Giant Number Window In the main Data Monitor window menu click Giant Numbers gt Rename Delete A window lists all the giant number windows that have been created Highlight the name of a giant number window in the list and click Rename Type the new name and click OK Boiler 1 60 NOx Ib rmBtu Botler 1 Heat Input Rate roimBtu Hr Boiler 1 WO Br Delete Botler 1 Opacity Boiler 1 Stearn Flow klbHr Cancel Deleting a Giant Number Window 24 In the main Data Monitor window menu click Giant Numbers gt Rename Delete A window lists all the giant number windows that have been created B
4. When the Other box is checked the summary interval is always Day and the Detail interval must be one of the minute options Select the minutes between detail data 6 Minutes is typical for opacity Click Next The wizard does not show the pages for configuring columns column groups and summary row descriptions Instead the wizard shows the following page CeDAR 5 Report Designer Wizard Choose the parameter and time formats for your report Parameter D acity Ea B Min Avg Width points 36 138 Minute format column titles Range 00 06 06 12 12 18 Hour format row titles Hour 00 23 Width of Hour column points 36 10 colurmls with 1 rows for each hour Back Next gt Cancel Chapter 3 Report Generator Select the parameter to display on the report This report can only display data for a single parameter Select the minute format for the column titles Select the hour format for the row titles If the column widths would be wider than the maximum report width the wizard will create the report with multiple rows of data per hour Click Next to configure the header and footer Here is an example of this report Demo Facility Facility Location Unit 4 Daily Opacity Report October 1 2013 Hour 00 06 06 12 12 16 18 24 24 30 30 36 36 42 42 45 46 54 54 60 00 40 4 5 44 47 46 45 4 6 4 6 4 6 4 6 0i 43 4 9 5 1 D2 45 44 4 4 47 4 6 4 6 O02 46 4 9 4 6 5
5. You may customize header and footer information for your report Scroll down to view the footer The Report Wizard provides a default header including the facility name facility location report name and report date The report header appears at the top of the report If Show at top of every page is checked the header appears on each page To change the header or footer click on a cell The lower half of the window shows the configuration for the selected cell Enter the text you want to see on the report You can also click the pull down menu to access built in variables Selected Cell Text Bold Po ltaic Size 9 Facility Name Facility Address Report Name Report Year Report Quarter Report Month name Report Day Report Hour 135 Cedar User Manual There is no default report footer To edit the footer scroll down to the Report Footer section The footer cells can be edited just like the header cells Click Next CeDAR 5 Report Designer Wizard Tou may enter test that will appear in a grid at the top of your report rT Text Press Ctrl 5 for special Py Bold Italic Alignment Lett options in the textbox lt Back Ment gt Cancel This screen allows you to put additional information in a grid at the top of the report The grid is often used to display emission limits The grid appears below the header and above the data columns By default
6. 0 Order by parameter Only show failed cals E Only show most recent cals for each parameter Gas Cylinder Information oe ee 117 Cedar User Manual Auto Report Properties Event Reports These properties apply to event auto reports General Tab Select when the report should be printed ce Peper fee General Unit Parameters Options Report Event Report When Description Startup Shutdown Report Lancel Unit Parameters Tab Select the unit and parameters to include in the auto report 118 Chapter 3 Report Generator Auto Report Properties General Unit Parameters Options Parameters Boiler 1 Startup Boiler Shutdowr Boller 1 Offline x Options Tab Select additional options See the event report section for descriptions of these options Auto Report Properties General Unit Parameters Options Order by DateTime Combine similar events onto a single line C Order by Parameter New page for each parameter o 119 Cedar User Manual Auto Report Properties Excess Emissions These properties apply to excess emissions auto reports General Tab Select when the report should be printed Auto Report Properties General Unit Parameters Options Report Excess Emissions Report When F Only print if there are excess emissions Description Excess Emissions Report Unit Parameters Tab Select the unit and parameters
7. Chapter 4 Data Editor Show All Cals from Interval Start to Test End When this option is selected all calibration checks that occurred prior to and during the 7 day test are displayed in the results This includes offline calibration checks that occurred during the 7 day test Show Only Cals Used to Pass Drift Test When this option is selected only calibration checks that were necessary to pass the 7 day test are displayed in the results Show Drift Test Summary When this option is selected the results include an explanation of whether the 7 day test was passed or what additional calibration checks are needed to pass the 7 day test Results Select the Results tab and the tool searches for calibration checks and displays the results GP 7 Day Drift Setup Results 107 872013 06 18 Boller 3 o NOs ppm 10 9 2073 06 18 Calibration Time 1012 2013 06 18 Passed 10 10 2013 06 18 10 11 2013 06 18 Instrument Span 300 ae 10 12 2013 06 18 ero Gas Reference T Measured 0 07 rift 0 07 Lirnit Tia Spar Gas Reference 168 9 Hdeasured 166 99 Drift 1 91 Limit Pa Summar y Starting on 106 207 3 there are 4 on line calls counted in the 7 Day Drift Test 3 more on line daily calls are needed to pass the Drift Test Ww Pass On Line o Pass Off Line x Fail On Line 2 Fail Off Line 7 Preview Report After Saving Close The selected calibration checks appear in the list The icon nex
8. Interval to Test for 7 Day Drift appropriate From 1078 2013 A of Spar To foas203 l CO pori l 0 5 Absolute Scale 7 Day Drift Criteria 02 2 C02 2 0 Include Manual Cals Other of Span Bot Calibration Days Passed CO ppr ex Flow 3 3 Days Ondine 44 Days Offline Peaking Lirnit l Other Absolute Scale Display Options ex APS 5 Show All Cals in Selected Interval Limit Show All Cals from Interval Start to Test End Show Only Cals Used to Pass Dritt Test J Show Ont Test Summary 4 Preview Report After Saving Date Interval Enter the date range that Cedar should search for calibration checks Cedar will only examine calibration checks in the specified date range 201 Cedar User Manual 202 Include Manual Cals When this option is selected calibration checks that are marked as manually initiated are included in the search This option is selected by default 6 of 7 Calibration Days Passed CO ppm Most regulations require the CEMS to pass all calibration checks in the 7 day period Some regulations allow one failed calibration check in the 7 day period fora CO CEMS By default this option is not selected 3 Days Online 4 Days Offline Peaking Typically all calibration checks in the 7 day test must be performed while the unit is operating Part 75 allows a day test for a peaking unit to include up to 4 calibration checks on days when the unit was not operating The unit must meet the
9. Back Cancel Click Next CeDAR 5 Report Designer Wizard what do you want to do Create a new report C Modify an existing report CO Duplicate an existing report for another unit C Delete an existing report 127 Cedar User Manual Select Create a new report Click Next CeDAR 3 Report Designer Wizard Select the page characteristics for pour report Page Size Font Letter 8 5 x 11 Arial Ad 210 s 297 mm Times Legal 8 5 14 Courier 0 Tabloid 11 17 coe E Drentatian Vertical distance between sections in points Portrait l l Horizontal distance between Landscape columns in points lt Back Next gt Cancel Choose the page layout for your report Select the page size orientation font type and font size The font size is in points The distance between lines and columns can also be changed Click Next CeDAR 5 Report Designer Wizard Choose the time periods that your report will cover Detail interval Other The detail interval is the Minute d 3 Minutes amount of time between sae Hour 5 Nlinnise _ parameter The column tithes are each line in the body of minutes and the row titles are the report Day J amp Minutes hours This is often used for daily Honth 15 Minutes opacity reports Quarter This report will show only one Summary interval The summary interval is Hour Quarter the total amount of time l th
10. Only show failed cals When this option is selected only failed calibrations are displayed on the report If all calibration checks passed the report will not show any calibration checks Only show most recent cals for each parameter When this option is selected all other report options are disabled Only the most recent calibration check in the last 30 days for each parameter are displayed 79 Cedar User Manual 80 Online cals Offline cals These options allow online and or offline calibration checks to be displayed If neither box is checked the report includes both online and offline calibration checks Gas cylinder information When this option is selected gas cylinder information is displayed if available Here is an example of a calibration check report with gas cylinder information Date Time Parameter 6 1 2014 6 18 AM NOx ppm 75 6 1 2014 6 18 AM NOx ppm 75 8 1 2014 6 18 AM S02 ppm 75 8 1 2014 6 18 AM S02 ppm 75 Color Analyzer Test Scale Single Single High High Demo Facility Cal Checks for 6 1 2014 Reference Measured Allawable Instrument Level Value Value Actual Drift Drift Span Cylinder IO Exnration Dale EPA VendoariD EPA Gas Type Codes Zero 0 00 ppm 0 08 pom 0 08 pom 15 ppm 300 ppm AIR Mid 170 10ppm 171 79ppm 1 69 ppm 15 ppm 300 ppm Cos2 935 a S 2076 B22014 BALN 502 WO COZ Zero 0 00 ppm 1 01 ppm 1 01 ppm 50 ppm 1000 ppm Mid S567 20ppm 569 55 ppm 2 35 ppm 50 ppm 1000 ppm
11. Show hide Performance Specification To show or hide the Performance Specification click the colored box next to Perform Spec The performance specification is used when performing a 7 day drift check Show hide Performance Specification x 2 To show or hide the Performance Specification times two click the colored box next to Perform Spec x 2 The performance specification times 2 is typically the daily calibration drift limit However some regulations define a different daily calibration drift limit Cursor Click anywhere in the graph to display the cursor The values on the right side display the calibration data for the selected calibration check 167 Cedar User Manual 168 FE Calibration Check Graph co ee Analyzer From To 60 SO ppmL Boiler 3 2 7 2014 12 4M BEET TE 12 46 lec Span 7 FJES 57 820 P i ia Span Measured Value p2 038 Reference Value p2 a20 Difference 0 fee 1 Perform Spec a e 25 P Perform Spec 2 Ae oe 5 4r cel eCOC Sr 2flf2014 4 p fel fe0l4 2 17 2014 9 18 00 4M 9 18 4M 718 AM Online ero _ Reference Value Reference Value Difference 1 Perform Spec WY Perform Spec 2 Calibration check date time and Online offline indicator The date and time that correspond with the position of the cursor are displayed in the Time box on the right This box may also show whether the calibration check was performed while t
12. The General page provides the following options General Organize View menu by unit Confirm changes to settings Show free disk space in status bar Alarms Visual Alarms Audible Alarms Acknowledgement Use MDI environment requires restart Alarms Displayed Units Alarms Send Email Automatic Features Apples to all users Organize View menu by unit When this option is checked the facility specific windows in the Data Monitor View menu are organized into a two level menu by unit This option can be useful for a facility that has many units and windows If the facility has only one unit this option is not available Turbine 2 HRSG Emissions Turbine 3 Turbine 2 Bypass Emissions Turbine 2 Operations When this option is unchecked all the facility specific windows appear in the main View menu 56 Chapter 2 Data Monitor File View Giant Numbers Trends Bar Graphs Alarms Calibrations Turbine 1 HRSG Emissions Turbine 1 Bypass Emissions Turbine 1 Operations Turbine 2 HRSG Emissions Turbine 2 Bypass Emissions Turbine 2 Operations Turbine 3 HRSG Emissions Turbine 3 Bypass Emissions Turbine 3 Operations Confirm changes to settings When this option is checked Cedar asks the user to confirm any change to a setting A dialog box prompts the user to confirm that the setting value should be saved or the user can cancel the change This option
13. 06 49 ba o K Cancel Check the Use 24 Hour Format box if you prefer to enter the time in 24 hour format instead of 12 hour format Enter the new time and click OK Changing a Date Setting If you are changing a date value the following window appears Chapter 4 Data Editor Enter New Value Sun Mon Tue Wed Thu Fri 12 15 14 15 16 1 19 0 2 oe 23 zd 20 od 30 31 Check the No date box if the setting should not have any date at all Enter the new time and click OK Changing a Yes No or True False Setting If you are changing a Yes No or On Off value and the current value is Null the following window appears Enter New Value Select the appropriate option and click OK If the current value is already Yes No True or False then the value will simply toggle when you click Change Value 197 Cedar User Manual Analyzer Information Calibration checks CGAs and linearity checks require additional information about the analyzer In the Data Editor menu click Edit View Data gt Analyzer Information The Analyzer Information window opens CP Analyzer and Monitor Information Turbine 1 NOx ppm Instrument Spar Manufacturer Model Number Seral Humber Component ID System ID Comment amp 4 Turbine 1 02 Instrument Span Manubacturer Model Number Seral Humber Component ID System ID Comment Edt bbei ah 100 Therma 420 Peofo sdr a 110 M10 25 Semm
14. 1 Minute Data Turbine 2 ik HRSG Emissions Report 1 Minute Data Turbine 2 Hourly Operations Report 1 Minute Data Saved Lists When Saved Lists is selected the lists of pre selected parameters are available If the 1 Hour Data tab is selected there is also an entry for each daily report that has 1 hour detail data This allows you to print the same 1 hour data that is on a daily report but for a custom time period If the 1 Minute Data tag is selected there is also an entry for each hourly report that has 1 minute detail data Again this allows you to print the same 1 minute data that is on an hourly report but for a custom time period 92 Chapter 3 Report Generator 4 CeDAR Reports File Tools Help Hourly 1 Hour Data 1 Minute Data Operation Status 10 Audits Saved Lists Parameters Demo Facility Monthly Facility Daily Total Mass Emissions Report 1 Hour Data Turbine 1 Daily 400FR 75 Emissions Report 1 Hour Data Pelisneiter Clee es Turbine 1 Daily 400FR 5 Operations Report 1 Hour Data Turbine 1 Daily Bypass Emissions Report 1 Hour Data Turbine 1 Daily HRSG Emissions Report 1 Hour Data Turbine 1 Daily Operations Report 1 Hour Data Turbine 1 Daily Total Mass Emissions Report 1 Hour Data oie Denime Turbine 2 Daily 40CFR75 Emissions Report 1 Hour Data Turbine 2 Daily 400FR 5 Operations Report 1 Hour Data Turbine 2 Daily Bypass Emissions Report 1 Hour Data i Turbine 2 Dail
15. I O Audits I O audits collect CEMS data at a high frequency and can be useful for certification and diagnostics An I O audit can be started in the Data Monitor 90 Chapter 3 Report Generator Audit Reports 1 Hour and 1 Minute These reports display 1 hour and 1 minute data that is available in Cedar Here is an example of a 1 hour audit report CeDAR 1 Hour Data Demo Facility Data for 12 18 2013 7 AM thru 12 18 2013 10 AM Turbine 1 Turbine 1 Turbine 1 HRSG NOx Turbine 1 Turbine 1 Turbine 1 Process Code HRSG60NOx ppm 15 02 HRSGSONOx HRSGNOxlbs HRSG CO ppm Timestamp 1 Hr ppm 1 Hr 1 Hr IbimmBtu 1 Hr 1 Hr 1 Hr 12 18 13 7 AM B 2 21 1 87 0 0069 12 96 0 88 12 18 13 8 AM B 2 16 1 34 0 0068 11 46 0 93 12 18 13 9 AM 8 2 18 1 86 0 0068 11 68 117 1218 13 10 AM B 2 18 1 87 0 0069 11 00 1 00 Average all 2 18 1 86 0 0069 11 78 1 00 Total all 47 10 Minimum all 2 16 1 44 0 0068 11 00 0 88 Maximum all 2 21 1 87 0 0069 12 96 1 17 Average valid 2 18 1 86 0 0069 11 78 1 00 values only Total walid 47 10 values only Count valid 4 4 4 4 4 values only Parameters Select the Parameters option to display the available 1 hour or 1 minute parameters Select the unit from the drop down list Select All units to display parameters from multiple units on one report Select the parameters to include in the report The Select All and Deselect All buttons affect the e
16. Ready Click OK A message box cautions that more steps are required to completely remove the user from the database Microsoft SQL Server Management Studio i Deleting server logins does not delete the database users associated with the logins To complete the A process delete the users in each database It may be necessary to first transfer the ownership of schemas to new users i Click OK SSMS deletes the login Note To completely delete the user from SQL Server the user must also be deleted in each Cedar database Perform the following procedure for each Cedar database 238 Chapter 6 Cedar Security Delete User from Cedar Databases Active Directory Groups D A user may have access to Cedar because the user is a member of an Active Directory group A SQL Server login and database users are defined for the group rather than for the individual user If this is the case delete the user from the Active Directory group and ignore this step To delete an existing user navigate to Databases gt database name gt Security gt Users in the SSMS Object Explorer window Right click on the user that you want to delete 239 Cedar User Manual File Edit View Debug Jools Window Help Object Explorer re x Connect 37 3u T E E SQLEXPRESS SQL Server 11 Databases System Databases a J Cedar5Alarms Database Diagrams Tables Views Synonyms Programmabilit
17. The book icon followed by a regulatory reference such as 40CFR60 or 40CFR75 A blue check mark indicates a passed calibration A red X indicates a failed calibration The Results column gives a more detailed explanation of the fail status 165 Cedar User Manual Graph Calibration Checks Calibration checks can be displayed in graphical format In the Data Editor menu click Edit View Data gt Graph Calibration Checks A blank Calibration Check Graph window opens FE Calibration Check Graph co eee p bes Analyzer From To 2 1 201412 4M 2 22 2014 12 Al ea Span v Zero J Span Span Measured Value _ Reference Value Difference BB Perform Spec Perform Spec 2 Time ero _ Reference Value Reference Value Difference BB Ferom Spec IY Perform Spec 2 Select an analyzer from the pull down menu Enter the time period in the From and To boxes The values for Span and Zero are graphed 166 Chapter 4 Data Editor FE Calibration Check Graph o ED een Analyzer From To 60502 ppm L Boiler 3 A204 12AM a 2 22 2014 12 AW Span F FIS 57 820 P eae ia Span Measured Value Reference Value Difference BB FEto Spec IY Perform Spec x 2 4 920 SSS es ie er lf2014 4 gt 2r 2172014 fe 1 2014 7 18 00 4M 9 18 AM 718 AM Online ero Reference Value Reference Value Difference Perform Spec IY Perform Spec x 2
18. no grid information is configured A grid can take some time to configure but may be very useful for your report Click Next 136 Chapter 3 Report Generator CeDAR 5 Report Designer Wizard Enter a name for your report Preview this report now lt Back Finish Cancel Enter a name for your new report Check Preview this report now to see the report you just created Click Finish The report will simply be added to the appropriate category in the main Report Generator window If you checked the Preview this report now box the report will be generated Report with Other Time Interval The Other option is useful for specialized reports such as daily 6 minute Opacity reports 137 Cedar User Manual CeDAR 5 Report Designer Wizard Choose the time periods that your report will cover Detail interval The detail interval is the amount of tine between each line in the body of the report Summary interval The summary interval is the total amount of tine that the report will cover each time you ruri it C Minute Hour Dap Month Quarter Hour Day Month Other 3 Minutes This report will show only one 5 Minutes o parameter The column titles are minutes and the row titles are 6 Minutes hours This i often used for daily A 15 Minutes opacity reports Quarter Semi annual fear annual T2 Month Alling Back Next gt Cancel
19. 0 5 0 47 39 4 0 44 4 2 03 42 4 0 44 4 6 4 6 46 47 49 49 4 9 04 2 2 4 6 4 6 44 3 1 4 5 44 4 3 47 4 5 05 47 4 8 3 0 31 2 2 Dd a2 42 44 4 6 06 47 47 4 6 4 7 449 2 0 4 6 Cal Cal 2d Or 2 4 af 5 1 47 4 6 5 1 49 44 47 a 06 5 1 23 I2 5 2 55 55 5 6 6 4 2 6 139 Cedar User Manual Report Wizard Modify Report To open the Report Wizard click Tools gt Report Wizard in the Report Generator menu CeDAR 5 Report Designer Wizard This wizard helps you create or modify a custom report Click Next CeDAR 5 Report Designer Wizard What do you want to do Create a new report Modify an existing report C Duplicate an existing report for another unit C Delete an existing report Back Cancel Select Modify an existing report 140 Chapter 3 Report Generator Click Next CeDAR 5 Report Designer Wizard Choose a report to modify Unit 1 Daily NOs Report Urit 1 Daily Opacity Report Select the report to modify You can only modify custom reports that you have created If a report provided by CiSCO needs to be changed contact CiSCO software support Click Next The rest of the wizard screens are the same screens that are used to create a report 141 Cedar User Manual Report Wizard Duplicate Report To open the Report Wizard click Tools gt Report Wizard in the Report Generator menu CeDAR 5 Report Designer Wizard This wizard helps you create or modify a custom report Click Ne
20. 15 2013 8 24 AM 10 47 AM 1 hour 24 minutes Other known causes 85 Cedar User Manual 86 Options button Click the Options button to see additional options for CEMS downtime reports The options are also available by clicking the Tools gt Options menu and selecting the Excess Emissions and CEMS Downtimes tab Color CEMS downtime detail reports support color To enable color click the Tools gt Options menu and check the Use color on reports where appropriate box on the General tab When color is enabled excludable CEMS downtimes appear in blue on the report Conflicts Conflicts may appear on a separate page at the end of the report Conflicts indicate an inconsistency in the data and should be resolved Chapter 3 Report Generator Conflicts in Excess Emission and CEMS Downtime Reports When the Print log of any operating time conflicts option is selected the report generator checks for conflicts between the monitor codes and the excess emissions or CEMS downtimes Any conflicts appear on a separate page at the end of the report Unit 4 CEMS Downtime Conflicts Demo Facility Opacity 6 Min Avg CEMS Downtime Conflicts for 11 1 2013 thru 11 30 2013 There are 2 confitciz 17 15 2013 10 12 AM There is an CEMS downtime entry for Opacity 6 Min Avg but the monitor code indicates that the parameter was down offline 19 15 2013 10 18 AM There is an CEMS downtime entry for Opacity 6 Min Avg but the monitor code
21. 20 0 0069 14 01 12 20 7 30 2 22 0 0070 14 01 1320 7 31 2 88 lt 14 gt 0 0072 lt 14 gt 12 22 lt 14 gt 1720 7 32 0 58 lt 14 gt 0 0006 14 gt 1 20 lt 14 gt 12 20 7 33 0 00 14 gt 0 0000 14 gt 0 27 lt 14 gt 12 240 7 34 0 00 14 gt 0 0000 14 gt 0 14 lt 14 gt A legend at the end of the report shows the descriptions of all monitor codes that appear in the report lt 13 gt Down lt 14 gt Calibration Check 26 gt Formula Input Out Of Range 94 Chapter 3 Report Generator Audit Reports Operation Status Operation status reports summarize 1 minute process code and monitor code data 4 CeDAR Reports File Tools Help Hourly 1 Hour Data 1 Minute Data Operation Status 1 0 Audits Parameters Process Code 1 Min eet Process Code Crrit Hr Calibration Checks J HRSG EONO ppm 1 Min HRSG 60 NO ppm Cint Hour HRSG 75 M0x pom 1 Min CEMS Downtime HASG NOs ppm 15 02 1 Min HRSG NOs ppm 154 O2 Crit Hour Alarms Mormal Ops HASG NOx ppm 15 02 Crint Hr Combined Cycle Normal Ops HASG NOs ppm 152 O2 Crnt Hr Audits Simple Cycle Normal Ops HASG NOs ppm 154 O24 Crt Hr HRSG 60 NOe Ib mmBtu 1 Min CG4A Lineanty HASG 6O NOs lb mmBtu Crit Hour ame ae biG H Settings Select All Deselect All Portrait Monthly Excess Emissions From 12 18 2013 12 00 AM Landscape To 12 20 2013 11 59 PM m Show duration hours minutes l i Start new line at midnight of each day Here is an example of an oper
22. 5 klonthl w S02 lb mmbtu 30 S00 Alg Avg k i v Opacity 6 Min Avg J Tuesday 3 4 Quarterly Annual Last week 2 23 To 3 1 D Last month February C Last quarter 2013 4 Events Calibration Checks E One day Excess Emissions 3 5 2014 m CEMS Downtime 0 Several consecutive days yama i Alarms Fut emm c To 3 5 2014 m ae Select All Deselect All Options CG4 Linearit _ 2 Print summar only Print excluded exceedences Settings 5 Print summary and detail Combine adjacent times into one line d Print detail only Options Save As Preview Pririt Close Print summary only When this option is selected the report includes a summary page for each parameter Unit 4 Excess Emissions Summary Demo Facility Opacity Excess Emissions for 10 1 2013 thru 10 31 2013 Reason Duration Other known causes 1 hour amp minutes Total duration of Opacity excess emissions 1 hour 6 minutes Total operating time 542 hours 4 minutes Operating time with excess emissions 0 2 Note The total operating time is derived from the monitor codes Different parameters may display different operating times for the same date range This occurs if the monitor codes are inconsistent for example when one parameter has an online monitor code and a different parameter has an offline monitor code for the same 81 Cedar User Manual date time Print summary and detail When this option
23. As Preview Pririt Close Depending on the requirements for your facility pre configured reports may be available You can define new annual reports with the Report Wizard Here is an example of an annual report 73 Cedar User Manual Demo Facility Facility Location Example Annual Report 2013 Month NOxfons N Oxtons YTD SO2tons S02 tons YTD January 150 6 150 6 412 412 February 136 0 286 6 43 4 84 6 March 754 362 0 23 5 108 1 April 1221 4844 35 0 143 1 May 176 3 660 5 602 203 2 June 177 1 837 6 527 255 9 July 182 8 1020 4 575 313 4 August 178 5 1198 9 66 6 380 0 September 176 9 1375 6 49 9 429 9 October 101 3 1477 1 33 6 463 5 November 154 7 1631 9 494 513 0 December 149 7 1781 6 43 0 556 0 Total 1781 6 556 0 74 Chapter 3 Report Generator 12 Month Rolling Reports Quarterly annual semiannual and 12 month rolling reports all appear in the same list A 12 month rolling report displays data for 12 consecutive months 12 month rolling reports typically display 1 month detail data and 12 month aggregate data Fj CeDAR Reports File Tools Help Example Quarterly Report Month Example Semiannual Report This month February Example 12 Month Report Hourly Last month January Monthly 0 December 2013 i November 2013 One month Everts January 7 eUi4 Calibration Checks Quarterly Annual Excess Emissions CEMS Downtime Alarms Audits CG4 Linearity Settings
24. CEMS downtimes based on the underlying data Edit CGAs and Linearity Checks Allows you to view and edit data for CGAs and linearity checks 161 Cedar User Manual Evaluate Linearity Checks for Operating Hours Checks unit operating hours and linearity checks to determine whether the necessary linearity checks have been performed for the current quarter This feature is for sources that are subject to 40 CFR 75 Settings Displays the settings constants defined in Cedar With appropriate privileges the settings may be edited Analyzer and Monitor Information Displays basic information about the analyzers and monitors that are used for monitoring emissions 162 Chapter 4 Data Editor Alarm Log In the Data Editor menu click Edit View Data gt Alarm Log The Alarm log window opens E Alarm Log Date Time Range Severity Categories Units From 1 1 2014 Serious CEMS COMM DAS Demo Facility Turbine 1 To 1 1 2014 11 59 PM m Warming LIMIT BACKUP SECURITY Turbine 2 E Info STATUS CONFIG Enter the From and To dates and times for the date range you wish to view The date range automatically defaults to midnight of the previous day and the current date and time Check the boxes for the alarm severities and alarm categories you want to see Some alarms are specific to a plant unit Select the unit s you want to see Alarms which are not unit specific appear regardless of which unit
25. DAlaDASCS nan E A 211 PRESIONC ale aa a A E etuudeweiucnons 212 Restore Configuration ccccccccecceccsecceeeceeceeeeeeceeceeeseeeeeeseeeeeeseeseeeseeseeegeees 214 Aie e D fz E EA A E AE AT E EA A E A E E A 215 Extract Data FOr QUAE rri EE EEE ETE 217 Merge Dala crean E S 219 PUJE DAd orane a oa ahs ele aol ole 221 Chapter 6 Cedar Se Cumnty ins a a a 223 Basic Cedar Security Create User cc cccecccccsecceeeeeeseeeeeeeeeteeeseeseeseees 224 Basic Cedar Security Database Roles cccccecceeeeeeeeeceeceeeeeeeeeeeeeeeees 228 Advanced Cedar Security ACCOUNHS cccccceccseeceeeseeceeeseeeeeeeeeseeeeeeseees 229 Advanced Cedar Security PErMmiSSiONS ccccccceceeeceeeeeeceeeeeeeeeeeeees 233 ICICI WI SCs cas catches tee S 236 GOSS AN aoc sc cose a a a aced a se ceeseueves saber eeckstieede 243 vii Chapter 1 Introduction To Cedar What is Cedar Cedar is a software package for data acquisition and reporting It is designed primarily for use with continuous emission monitoring systems CEMS Cedar runs on a Microsoft Windows based computer The computer and software together are called a Data Acquisition System DAS or Data Acquisition and Handling System DAHS Cedar is a product of Custom Instrumentation Services CiSCO Cedar User Manual Cedar Applications Cedar has these applications and Windows services Application Data Monitor Data Editor Report Genera
26. Data Editor Feports Change options Level 3 Configure auto reports Level 3 Lreatesmodity delete user defined reports Level 3 235 Cedar User Manual Delete User To delete a user follow these steps 1 Delete the SQL Server login 2 Delete the user from each SQL Server Cedar database 3 If advanced Cedar security is enabled remove the user from any Cedar privilege levels Delete SQL Server Login 236 Active Directory Groups D A user may have access to Cedar because the user is a member of an Active Directory group A SQL Server login is defined for the group rather than for the individual user If this is the case delete the user from the Active Directory group and ignore this step Open SQL Server Management Studio SSMS To delete an existing login navigate to Security gt Logins in the SSMS Object Explorer window Right click on the login that you want to delete Chapter 6 Cedar Security Microsoft SQL Server Ma t Studic File Edt View Debug Tools Window Help De SQLEXPRESS SQL Server 11 Databases Security E Logins EE Smith New Login Script Login as Policies Facets Start PowerShell Reports Select Delete from the menu The Delete Object window appears 237 Cedar User Manual X Delete Object Script 5 Help Object to be deleted Object Name Object Type Owner Status Message Connechon Server SGLEXPRES Connection Progress
27. NOs lbs 1 Hr NOs lbs 1 Hr 40CFA 75 Date Time The first column of the report is normally a date and or time Select a date time option from the pull down menu Click OK The date time column is added to your report CeDAR 5 Report Designer Wizard Choose the columns to display in your report Also choose the summar data averages totals etc to display at the bottom of each column Hour gt Curent Column Summary Data Title Hour width points 36 Totale36 Width 540 Display a line after this column To add columns of data to the report click Add Column again 130 Chapter 3 Report Generator Select Data Source Parameter Process Code 1 Hr FS NO4 ppm 1 Hr f5 N Oe ppm 1 Hr Bias Adj 60 N 0x lb mmB tu 1 Hr FS NOe berm tu 1 Hr NOs lbs 1 Hr NOs lbs 1 Hr 40CFA 75 0 DateTime Cancel The detail interval that was selected for the report determines which parameters are available for this list The unit name and a dashed line separates the parameters for each unit Select a parameter to add to the report by clicking on the parameter To select multiple parameters use the Shift or Ctrl keys Click OK CeDAR 5 Report Designer Wizard Choose the columns to display in your report Also choose the summary data averages totals etc to display at the bottom of each column 6O NMOe ppr BO MOs Add Column lt Move Move gt Delete Current Col
28. NOx ppm Instrument Zero Zero Zero Zero Span Span Span Span Time Span Reference Measured Drift Drift Limit Reference Measured Drift Drift Limit Status 10 8 2013 06 18 300 0 00 0 08 0 08 T 50 168 90 166 74 2 16 7 50 On Line 10 9 2013 06 18 300 0 00 0 14 0 11 7 50 168 90 156 16 2 74 T 50 On Line 10 10 2013 06 18 300 0 00 0 07 0 07 7 50 168 90 156 88 2 02 7 50 On Line 10 71 2013 06 18 300 0 00 0 07 0 07 7 50 168 90 166 12 2 78 7 50 On Line 1012 2013 06 18 300 0 00 0 07 0 07 7 50 168 90 156 99 1 91 7 50 Off Line 10 19 2013 15 18 300 0 00 0 26 0 26 T 50 168 90 158 35 0 55 7 50 On Line 10 20 2013 00 19 300 0 00 0 05 0 05 7 50 168 90 159 98 1 08 7 50 Off Line 10 20 2013 06 18 300 0 00 0 07 0 07 7 50 168 90 170 08 1 18 T 50 Off Line 10 20 2013 15 29 300 0 00 0 05 0 05 7 50 168 90 170 98 2 08 7 50 On Line 10 21 2013 06 18 300 0 00 0 04 0 04 7 50 168 90 171 18 2 28 7 50 On Line The 7 Day Drift Test has been passed Offline calibration checks have a gray background in the report The options on the Setup tab affect how many calibration checks are included in the report and whether the test summary appears at the bottom of the report 205 Chapter 5 Database Backup amp Utility Cedar has a Backup application to make backup copies of data and to restore data to the Cedar databases Cedar also has a Database Utility application that provides other options to get selected data from and into the Cedar databases Cedar Backup Application The
29. Opacity Excess Emissions for 10 1 2013 thru 12 31 2013 Parameter Start End Duration Value Min Max Limit Reason Opacity 10 6 2013 3 42 PM 2 53 PM 12 minutes 16 0 14 0 18 0 13 Other known causes 82 Chapter 3 Report Generator Options button Click the Options button to see additional options for excess emission reports The options are also available by clicking the Tools gt Options menu and selecting the Excess Emissions and CEMS Downtimes tab Color Excess emission detail reports support color To enable color click the Tools gt Options menu and check the Use color on reports where appropriate box on the General tab When color is enabled excludable excess emissions appear in blue on the report Conflicts Conflicts may appear on a separate page at the end of the report Conflicts indicate an inconsistency in the data and should be resolved 83 Cedar User Manual CEMS Downtime Reports CEMS downtime reports display information for times when an emissions monitoring system or other monitor was not operating or collecting valid data F CeDAR Reports File Tools Help Hourly Monthly Calibration Checks Excess Emissions CEMS Downtime Alarms Audits CG4 Linearity Settings Parameters mHASG NOs pom 15 02 HRSG NOx lbs Bypass NOs ppm 154 02 w Bypass NOx Ibs w HASG CO ppm 15 02 w HRSG CO Ibs Bypass CO ppm 152 02 w Bypass CO lbs Options Print summary orly C Print summary a
30. Reports Reports can be configured to print at regular intervals To configure automatic reports click File gt Setup Auto Reports in the Report Generator menu These kinds of reports can be printed automatically Hourly Daily Monthly Calibration Checks Event Reports Excess Emissions CEMS Downtimes Alarms Start time for daily auto reports The time when daily auto reports run can be configured in the Report Generator Options window Disable auto reports For auto reports to run the Do NOT run auto reports box must be unchecked in the Data Monitor Options window In addition the specific auto reports must be enabled in the Auto Reports window PDF reader for auto reports The Cedar Report Generator creates most reports as PDF files A PDF reader application is required to automatically print reports Note AN Adobe Reader does not function properly under the built in special accounts such as Network Service Local Service and Local System Foxit Reader is required on the DAS if auto reports will be printed from one of the built in accounts Foxit Reader is available from www foxitsoftware com Adobe Reader may be used if automatic reports will run under an account that has a typical profile not a built in account Both Adobe Reader and Foxit Reader may be installed if desired 107 Cedar User Manual Configuring Auto Reports To configure automatic reports click File gt Setup Auto Reports i
31. SQL Server login locate the login under Security gt Logins in the SSMS Object Explorer window Right click on the login name and select Properties 225 Cedar User Manual 4s Microsoft SQL Server Management Studi File Edit View Debug Tools Window Help Pade gt a ied a i NewQuey Ly t ii fG rer are aa a T F i i D C a ig SQLEXPRESS SQL Server 11 0 71 E Databases O Security E Logins A F MS_PolicyEventProcessingLogin A M5 PolicyTsqlExecutionLogin fs BUILTIN Users ee NT AUTHORITY NETWORK SERVICE ty New Login amp I Script Login as A h At Policies As Facets E Lal Serv E Gap Cred Start PowerShell Server O at E Replicat m O Manage Rename Delete Refresh The Login Properties window appears Configure the user mapping Configure SQL Server Login User Mapping Use the Login Properties window to map a login to the predefined Database Roles 1 Select User Mapping on the left 2 Select the Cedar database such as Cedar5Alarms 3 Check the database role membership boxes to assign database roles to the login 4 Repeat steps 2 and 3 for each Cedar database 5 Click OK to save the changes 226 Chapter 6 Cedar Security g Login Properties NT AUTHORITY NETWORK SERVICE Select a page k R General S Soit Help AA Server Roles Mapping Users mapped to this login Map jatabase User NT AUTHORITY NET NT AUTHORIT NET
32. Select the unit and parameter from the pull down boxes Enter a maximum value to use for scaling the values To add additional parameters click on the other colored tabs Modifying a Trend To modify a trend right click on the graph Select Edit Graph from the drop down menu Or simply double click on one of the six black boxes with parameter names Show Hide Trend Scale To show the numbers on the scale click a parameter name The scale on the left side of the graph displays the numbers corresponding to the scale of the selected parameter The scale color matches the color of the selected parameter To see the scale of another parameter click on the parameter name To hide the scale numbers click the selected parameter again Resetting Trend Configuration To complete erase all configuration for a trend right click on one of the parameter names and select Clear Graph from the pop up menu 26 Chapter 2 Data Monitor Renaming a Trend Cedar automatically names the trend windows as Trend 1 Trend 2 etc To give a trend a descriptive name click Trends gt Rename Delete BarGraphs Tools Window Help Bring to Front Ctrl 6 Trend 1 Add New 10 second data Add New 1 minute data Rename Delete A window lists all the trend windows that have been created Highlight the name of a trend window in the list and click Rename Type the new name and click OK Deleting a Trend In the main Data M
33. Substituted Data max value in the previous 30 calendar days Substituted Data max value in the previous 365 calendar days Substituted Data max value since CEMS certification date Substituted Data other method Substituted Data 40CFR75 initial data substitution Substituted Data 40CFR75 90 percentile Substituted Data 40CFR75 95 percentile Substituted Data 40CFR75 maximum in lookback period Substituted Data 40CFR 5 average of lookback period Substituted Data 40CFR 75 maximum potential value gt Note l Monitor codes 53 58 62 63 and 66 apply to the South Coast Air Quality Management District SCAQMD only Process offline SCAQMD only Process offline value below 5 of range replaced with zero SCAQMD 2012 NOx only Value below 10 of range SCAQMD only Value below 10 of range replaced with 10 of range Valid Valid Valid Valid Valid Valid Valid Valid Valid Valid Valid Valid Valid Valid Valid Valid Cedar User Manual 57 58 59 60 61 62 63 64 65 66 67 68 70 71 72 SCAQMD only Value above 95 of range replaced with 10 of next certified range SCAQMD only Value above 95 of highest certified range SCAQMD only Invalid Data flagged by user this monitor code may not be affected when data points are rebuilt recalculated Data is not applicable N A used for special averaging requirements Diluent c
34. To open the Report Wizard click Tools gt Report Wizard in the Report Generator menu CeDAR 5 Report Designer Wizard This wizard helps you create or modify a custom report Back Cancel Click Next CeDAR 5 Report Designer Wizard What do you want to do i 4 Create a new report C Modify an existing report Duplicate an existing report for another unit Delete an existing report 145 Cedar User Manual Select Delete an existing report Click Next CeDAR 5 Report Designer Wizard Choose a report to delete Urit 1 Daily NOs Report Unit 1 Daily Opacity Report Select the reports you want to delete Click Finish A message box will ask you to confirm that you want to delete the reports Click Yes 146 Chapter 3 Report Generator Report Generator Options To open the Options window click the Tools gt Options menu The Options window has several tabs General Facility Info Data Validity Auto Reports Calibration Checks Excess Emissions and CEMS Downtimes 147 Cedar User Manual General 148 These options apply throughout the Report Generator Calibration Checks Excess Emissions and CEMS Downtimes General Facility Info Data Walidity Auto Reports Allow me to enter a comment for each report Use color on reports where appropriate VW Close the report generator after it has been open for 12 hours f Attempt to close POF Reader after clicking t
35. User Manual Manually add a CGA or Linearity Check For many CEMS a user pushes a button to initiate a CGA or linearity check and the CEMS automatically injects the reference gases Cedar then acquires the gas injection data from the CEMS This is the easiest and most common way that Cedar acquires CGA and linearity check data If Cedar cannot automatically acquire the CGA or linearity check data you can manually add a new check Click the book icon for the kind of CGA or linearity check that you need to create Then click the New CGA or New Linearity Check button CGAs and Linearity Checks Fl i Boiler 3 NOK CGA 4 NO Linearity 4 Stack CO CGA New Linearity Check i Stack COZ Linearity A window allows you to select the date of the new CGA or linearity check Then Cedar creates the new check and you can enter the data Delete a CGA or Linearity Check 192 To delete an unneeded CGA or linearity check select the test date in the tree and press the Del Delete key A message box asks you to confirm that you want to delete the test Warning AN Use caution when deleting a CGA or linearity check Environmental regulations including 40 CFR 75 require that all CGAs or linearity checks that affect data validity must be reported Chapter 4 Data Editor Edit Opacity Calibration Error Tests Calibration Error Tests for opacity monitors are similar to linearity checks Calibration error tests for opac
36. a limited number of files If the root folder contains the maximum number of files no more files can be created in the root folder even if the drive has a large amount of free space Other file systems such as NTFS and FAT32 do not have this limitation To determine the file system of a drive right click on the drive in 209 Cedar User Manual Windows Explorer and click Properties The Properties window displays the file system used for the drive Secondary backup location In addition to the backup location s specified in the Cedar5 ini file Cedar also writes backup files to the SecondaryBackup folder in the Cedar folder This path is typically C Cedar SecondaryBackup The path will be different if the Cedar5 ini file specifies a different path for the Cedar folder Alarm for low free space in backup location s Cedar creates an alarm if an automatic primary backup location is getting low on available space The daily automatic backup operation creates the alarm if the free space is less than 10 of the total drive space Disable auto backup For auto backup to run the Do NOT perform auto database backup everyday box must be unchecked in the Data Monitor Options window 210 Chapter 5 Database Backup amp Utility Backup Databases The Cedar Backup application allows you to backup data to the location of your choice J CeDAR Backup TESTSITE Backup Databases Restore Data Restore Configuration Lo
37. and has passed on offline calibration error demonstration check the 40CFR 75 CEMS Using Offline Cal Checks For Data Validation box Simple configuration This configuration will perform a calibration check at the same time each day whether the unit is operating or not Cedar will not start any additional calibration checks If this configuration is used the unit operator or CEMS technician may need to manually start additional calibration checks to meet the daily QA requirements Disable automatic calibration checks Daily Calibration Checks Perform calibration checks at 07 50 AM les T Skip the daily cal check if the unit is offline at this time Skip the daily cal check if an online cal check has already run during the day Calibration Checks At Unit Startup N TO the normally IT pri t tk mia h the CEMS J unit startup althougl Do not automatically perform cal checks for unit startup E Perform a cal check BU minutes after the unit begins running C Perform a cal check 60 E minutes atter the unit enters normal operation A Do NOT run a unit startup cal check if an online cal check has already occured during the day 40CFAR 75 CEMS Using Offline Cal Checks for Data Yalidation A Make sure that an online cal check rung at least every 26 unit operating 5 hours run addtional cal checks as needed The configuration is 42 Chapter 2 Data Monitor Set the daily cal start time to a con
38. applies to all users Show free disk space in status bar When this option is checked the Data Monitor displays the free disk space of the local machine in the status bar Use MDI environment When this option is unchecked the facility specific windows can be moved anywhere on the Windows desktop The windows are not confined to the main Data Monitor window This option can be useful for computers with multiple monitors When this option is changed the Data Monitor must be restarted for the change to take effect 57 Cedar User Manual Data Monitor Options Alarms Visual In the Data Monitor main window menu click Tools gt Options gt Alarms Visual The Alarms Visual page provides the following options Opens General Alarm window font size Alarms Yisual V Show info alarms Alarms Audible Pop up alarm window when an alarm needs to be acknowledged Display alarm banner in main window Alarms Acknowledgement me Displayed Units Flash when there is an unacknowledged alarm Flash when there is a communications problem seis eul Emel Flash main window background for unacknowledged alarms Automatic Features Flash color Serious ical Flash color Waring Flash color Comm Apples to all users Cancel Alarm window font size The font size of the text in the alarm window can be changed This affects both the alarm window and the alarm banner at the bottom of the m
39. be useful for monitoring system certification and diagnostics An I O audit can be started in the Data Monitor F CeDAR Reports File Tools Help Hourly 1 Hour Data 1 Minute Data Operation Status 1 0 Audits 170 Audits Unit Stat Time neers Monthly Turbine 1 CEMS 17872014 9 19 17 4M VI HASG NOx ppm Bupass NOx ppr Calibration Checks aa HRSG ai HASG CO ppm Excess Emissions Eppass CO ppr CEMS Downtime Bypass 02 CT Nat Gas Flow DB Nat Gas Flow CT Megawatts NH3 Injection Flow Alarms Audits CG4 Linearity Settings Select All Deselect All Alldata in O audit Portrait i Landscape Frome 9 19 17 4M m 1 Minimum interval secands To ES 9 27 AM fal E Only print summary values Here is an example of an I O Audit report VO Audit Data Demo Facility Data for 1 6 2014 9 19 17 AM thru 1 6 2014 9 19 27 AM Turbine 1 HRSG NOx Turbine 1 Timestamp ppm HRSG O2 9 19 17 AM 6 020 14 230 9 19 18 AM 6 020 14 230 9 19 19 AM 6 020 14 230 9 19 20 AM 6 020 14 230 9 19 22 AM 5 973 9 19 73 AM 5 973 14 241 9 19 24 AM 14 241 9 19 26 AM 5 973 14 241 Average 6 000 14 235 Minimum 5 973 14 230 Maximum 6 020 14 241 97 Cedar User Manual Note D Gaps in the data indicated by dashes or missing times are normal Cedar is limited by the communication speed and the quantity of data that it must read from the CEMS in addition to the I O audit data During an I O audit Cedar attempts to read the sel
40. box This is not common Warning A Use caution when editing data Values and Monitor Codes should only be edited when there is a sound technical basis for the change Editing data without valid justification violates environmental regulations Monitor Code Use the pull down menu to select a Monitor Code The Monitor Code fields are disabled for Operating Time parameters and Process Code parameters since they do not have monitor codes 173 Cedar User Manual Saving Changes After changing one or more data points the changes need to be saved to the database You must save or cancel the changes before selecting a different unit parameter or time period C Edit Data Points Long period data Short period data Unit Boiler 3 Farameter BU AOs ppm 1 Hr From 11 32013 7200 AM To 11 3 2013 11 00 PM Load Data SelectAll 112372013 12 00 4M Valid 11 3 2073 2 00 AM alid _Invett Selection 11737 2013 3 00 4M Walid 117372013 4 00 4M Walid Deselect Al 11 3 2073 5 00 AM Sample Intertace Malfunc 1173 2013 6 00 AM Sample Interface Maltunc 1132073 700 4M Sample Interlace Malfuric 1132073 8 00 4M Preventative Maintenance Ss 11 3 2073 9 00 4M Walid 11737 2013 10 00 AM Walid 1123 2013 11 00 AM Valid Cancel 11 37 2013 12 00 FM Walid 11 3 2073 1 00 PM l Walid 117 372013 2 00 PM Walid 11 37 2013 3 00 PM Walid 11432013 4 00 PM Walid 11ST PM Valid The Save
41. checked data points with any of these monitor codes are not Valid data generated by PLC or other non Cedar source Measured value has been replaced with 200 of Maximum Potential Concentration MPC or 200 of full scale range Valid Data generated by PLC or other non Cedar source Offline data generated by PLC or other non Cedar source Invalid Data flagged by user this monitor code may not be affected when data points are rebuilt recalculated D When the Overwrite all values and monitor codes box is not checked an existing data point is not modified if the recalculated data point has a Null blank empty value and monitor code 18 This can happen for example when attempting to rebuild 1 hour averages from 1 minute data but the 1 minute data has been purged from the Cedar database 181 Cedar User Manual 182 Caution A When the Overwrite all values and monitor codes box is checked and you are recalculating 1 hour data from 1 minute data make sure the 1 minute data has not been purged from the Cedar database If the 1 minute data has been purged the 1 hour data will be overwritten with Null values and monitor code 18 Caution AN When the Overwrite all values and monitor codes box is checked existing data that came from HDR may be overwritten with the recalculated data Click the Rebuild button A message box notifies you that the rebuild operation may take some time A progress window disp
42. edited or modified If many days have been modified the backup operation may take a long time Sometimes automatic backup can not be performed because for example the external backup device is full or disconnected Cedar stores the most recent date for which data was successfully backed up When the backup location is available again Cedar will back up all days since the date of the most recent successful backup The date of the most recent successful automatic backup is available from the Data Editor menu Select CISCO gt Change Last Backup Date Last Backup Date This window lets you change the last backup date in the UserContig table Existing last backup date 2014 05 01 Hew last backup date Change Close Configure automatic backup location s The location for the automatic backup files is specified in the Cedar5 ini file The BackupDir entry specifies the path for the backup files Cedar can copy backup files to multiple locations This can be useful to backup to both a local location and to a network server In the BackupDir entry separate multiple locations with a semicolon Here is an example of the BackupDir entry with multiple locations BackupDir F Backup C Cedar NetworkBackup Warning AN Do not use the root folder of a FAT formatted drive for a backup location Some USB stick drives are factory formatted as FAT Due to limitations of the FAT file system the root folder can hold
43. in the Part 75 Policy Manual For an hour to be valid both of these requirements must be met 1 The CEMS must have passed a calibration check online or offline within the previous 26 clock hours the current hour counts as one of the 26 hours If the CEMS failed a calibration check it is out of control until it passes a calibration check 2 The CEMS must have passed an online calibration check within the previous 26 unit operating hours Chapter 2 Data Monitor Keep these points in mind e An hour is considered a unit operating hour if the unit operates for any portion of the hour e The hour in which the most recent online calibration check completed is considered the first hour of the 26 unit operating hours allowed e Ifa CEMS fails an online calibration check it is out of control until it passes an online calibration check Cedar operation When the box is checked Cedar tracks the number of unit operating hours that have passed since the most recent online calibration check Cedar will start a calibration check if the unit is online and the number of unit operating hours is greater than 25 The box below the checkbox indicates the number of unit operating hours since the most recent online calibration check The border turns red when the number of unit operating hours is greater than 26 More than 99 unit operating hours have passed since the last online cal check Status Indicator The box at the bottom o
44. may optionally enter a title for the group in the second field The group title appears on the report centered above the columns that are in the group Use the Previous Group and Next Group buttons to select groups Click Next 133 Cedar User Manual 134 CeDAR 5 Report Designer Wizard You may change the description of the summary rows which appear at the bottom of the report Click on an Actual Description to change it Actual Description CeDAR Description Daily Average Daily Average 30 Day Rolling Average 30 Day Rolling Average Daily Total Daily Total lt Back Next gt Cancel lf you have selected summary data for one or more columns on the report this screen displays descriptions of the summary rows To change the summary row description click on the text in the Actual Description column CeDAR Description Daily Average Daily Average 30 Day Alg Avd 30 2 ay Rolling Average Daily Total Daily Total If a summary row title is too wide for the column it will be truncated on the report Click Next Chapter 3 Report Generator CeDAR 5 Report Designer Wizard Tou may enter test that will appear in the header and footer of your repart Lett Aligned Centered Aight Aligned Report Header Show at top of every page FACILIT VY MAME FACILITYLOCATION FIREPOR T NAME REPORTDAY Selected Cell Text REPORTNAME Bold ltalic Size 12 Back Next gt Cancel
45. only or read write Basic security is always enabled You may optionally configure advanced security for finer control of write permissions Advanced CeDAR security does not affect reading or viewing data 0 Disable advanced CeDAR security Enable advanced CeDAR security Level 0 Level 0 iz the default privilege level for non adrinistrator users with read write permissions in basic CeDAR security Read only users do not even have Level 0 privileges Level 1 Add Windows User Level 1 users have few AET ios Remove Level 2 jemith Add windows User Level 2 users have the privileges of both levels 1 and Add SOL Login a Windows Administrators Windows administratore may change CeDAR security settings Administratore have level 2 privileges if they are tead write users in basic CeDAR security Level 3 BUILTIN Administrators 5 1 5 32 544 mdame Veer Level 3 users have the privileges of levels 1 2 and Add SQL Login 3 Level 3 users may change CeDAR security settings Remove OF Cancel Look for the user in the list for each privilege level Highlight the user and click Remove Click OK to save the changes 242 Glossary 4 40 CFR 60 Part 60 of Chapter 40 of the U S Code of Federal Regulations Part 60 has many detailed requirements for monitoring handling and reporting air emissions data 40 CFR 75 Part 75 of Chapter 40 of the U S Code of F
46. operating and starts up again the 8 hour startup grace period begins with the first startup The grace period does not begin again for the second startup Chapter 2 Data Monitor Dual range analyzers When either range of a dual range analyzer fails a calibration check both ranges are out of control invalid until both ranges have successfully passed a calibration check See 40 CFR 75 Appendix B section 2 1 5 1 3 A passed but expired calibration check on one range does not affect the validation status of the other range For example if the high range passed its most recent calibration check but more than 26 hours have passed and the low range is up to date on its calibration requirement then data from the low range is considered valid Regulation references The requirements for data validation with respect to calibration checks are found in 40 CFR 75 Appendix B sections 2 1 1 and 2 1 5 The Part 75 Policy Manual contains additional clarifications and examples 45 Cedar User Manual Data Monitor Settings Settings are values that are specific to your facility Settings may include daily calibration start times fuel density settings for gas and or oil bias factors on line setpoints for fuel water and steam flows and backflush intervals Settings Window In the Data Monitor main window menu click Tools gt Settings The Settings window opens Bul BLAU Default Value Value R Sy Chimney Daily Cal Start Time 0
47. process code indicates the state of the process relative to certain permit conditions Typical process codes are Unit Offline Startup Shutdown and Normal Operation R RATA Relative Accuracy Test Audit Compares the CEMS emission data against emission data from a reference method Is typically performed by a third party test team Is commonly performed on an annual basis but shorter and longer intervals are possible Report EPS 1 PG 7 Revised CEMS requirements for Environment Canada titled Protocols and Performance Specifications for Continuous Monitoring of Gaseous Emissions from Thermal Power Generation S SCAQMD South Coast Air Quality Management District is the agency responsible for managing air pollution in the greater Los Angeles California area SCR Selective catalytic reduction SCR is a means of controlling NOx emissions with the aid of a catalyst by injecting ammonia or urea into a stream of exhaust gas SNCR Selective non catalytic reduction SNCR is a means of controlling NOx emissions in solid fuel power plants by injecting ammonia or urea into a stream of exhaust gas without the aid of a catalyst S02 Sulfur dioxide U USEPA United States Environmental Protection Agency 245
48. select Database Utilities gt Purge Old Data Security and permissions A purge operation will fail if the user does not have permissions The user must have the CedarBackupRestore CedarDataReader and CedarDataWriter database roles in basic Cedar security Alternatively the user may have administrator or database owner permissions for the Cedar databases 222 Chapter 6 Cedar Security Overview Cedar security has two parts basic and advanced Basic Cedar security determines a user s permissions for the Cedar database Basic security is configured in SQL Server Most importantly basic Cedar security determines whether a user has read only or read write permissions for the Cedar database Advanced Cedar security affects users with read write permissions It provides a finer level of control over Cedar features that can modify data Most facilities do not use advanced Cedar security SQL Server enforces basic security at the database level Advanced Cedar security is enforced at the application level Cedar User Manual Basic Cedar Security Create User Basic Cedar security is configured in SQL Server Management Studio SSMS SQL Server logins typically use Windows authentication or SQL Server authentication Windows authentication is more secure but requires Active Directory for access from remote computers SQL Server authentication is less secure but access from remote computers is easier to set up A full discussio
49. to include in the auto report 120 Chapter 3 Report Generator Auto Report Properties General Unite Parameters Options Parameter s Os Ibe rombtu 30 SOD Alg Avg w 502 lberimbtu 30 SOD Alg Avg w Opacity 2 6 Min avg x Options Tab Select additional options See the excess emissions report section for descriptions of these options Auto Report Properties General Unit Parameters Options C Print summar only C Print summary plus detail if needed Print detail only Print excluded exceedences Combine adjacent times into one line New page for each parameter Print log of any operating time conflicts Print total duration of exceedences ok 121 Cedar User Manual Auto Report Properties CEMS Downtimes These properties apply to CEMS downtimes auto reports General Tab Select when the report should be printed Auto Report Properties General Unit Parameters Options Report CEMS Downtime Report ven ry Orly print if there are CEMS downtimes Description CEMS Downtime Report Unit Parameters Tab Select the unit and parameters to include in the auto report 122 Chapter 3 Report Generator Auto Report Properties General Urnit Parameters Options Parameter s wl HMOs be rmbt Ww SO be rnimBtu w Opacity 2 6 Min Avg Options Tab Select additional options See the CEMS downtime report section for descriptions of thes
50. to prevent the linearity check from being included in the quarterly electronic submittal to USEPA If the CEMS fails the abbreviated linearity check the CEMS is out of control and the data is invalid The failed test must be reported to USEPA as an aborted linearity check Select a test reason Diagnostic is recommended and mark the test as aborted Offline Linearity Check Part 75 requires that linearity checks must be performed when the unit is operating If a linearity check is performed when the unit is not operating select the Unit Offline reason to prevent the linearity check from being included in the quarterly electronic submittal to USEPA Low Gas Mid Gas High Gas The gas tabs contain the gas injection data The High Gas tab usually does not apply to CGAs Cf CGAs and Linearity Checks Eb Boiler 3 i gA NOx CGA et NOx Linearity Run Time Reference Gas CEMS Response i bye Stack CO2 CGA 1 07 55 5 59 5 51 1 A Stack CO2 Linearity Test Info Low Gas Mid Gas High Gas Cylinder Into 2 0816 559 557 2 083 559 559 1173 2013 i Mean 6 59 5 56 5 1 5 2013 Difference of means A A ACO 0 0 Limit 05 Passed Linearity Error 2 0 6 Limit 50 Passed Recalculate Allowable Reference Walues 4 6 amp CO2 20 30 of span If the reference values or response values are changed click Recalculate to update the results 190 Chapter 4 Data Editor Passed appears next to the limit if one or
51. used for timeshare systems Value out of range Value out of range process offline Data not QA for example 26 hours passed without a calibration check or a linearity check is missing Not sufficient data used when there is insufficient data to create an average but creating an invalid monitor code would be difficult or irrelevant For example subpart Da and Db 30 operating day averages Valid data generated by Cedar Measured value has been replaced with 200 of Maximum Potential Concentration MPC or 200 of full scale range Valid data generated by PLC or other non Cedar source Measured value has been replaced with 200 of Maximum Potential Concentration MPC or 200 of full scale range Typically used with HDR data Invalid data generated by PLC or other non Cedar source Typically used with HDR data Valid Data generated by PLC or other non Cedar source Typically used with HDR data Offline data generated by PLC or other non Cedar source Typically used with HDR data Invalid Valid Invalid Invalid Offline Invalid Invalid Offline Invalid Invalid Valid Valid Invalid Valid Offline 40 41 42 43 44 45 46 47 48 49 50 51 53 54 55 56 Chapter 1 Introduction To Cedar Substituted Data average of hour before and hour after Substituted Data average of X hours before and X hours after where the missing data period is X hours
52. 0066 10 96 136 O73 0 0016 156 6 80 55 0 0079 13 12 Normal m 13 38 211 1 80 1 0066 10 87 Oar O74 0 0017 2 80 5 52 55 0 0076 12 52 Normal a2 13 97 215 16 1 0066 11 04 095 MER 0 0013 232 5 32 54 mioa 11 35 Normal a3 13 96 245 1 83 1 0067 10 95 094 0 30 1 0013 2 94 6 35 54 0 0073 11 93 Normal 68 Chapter 3 Report Generator Daily Reports A daily report displays data for one day Daily reports typically display 1 hour detail data and 1 day aggregate data F CeDAR Reports File Tools Help Turbine 1 Daily 40CFA75 Emissions Report Day s Turbine 1 Daily 400FR 75 Operations Report Today 1 8 Daily Turbine Z Daily 400FR 75 Emissions Report Turbine 3 Daily 40CFR75 Emissions Report Yesterday 1 7 Monthly Turbine 2 Daily 40CFA75 Operations Report Monday 1 6 Turbine 3 Daily 400FR 75 Operations Report Calibration Checks Turbine 1 Daily Operations Report Hourly D Last week 12 29 To 1 4 Turbine 3 Daily Operations Report Last month December Turbine 2 Daily Operations Report CEMS Downtime Turbine 1 Daily HRSG Emissions Report C Last quarter 2013 L4 Turbine 2 Daily HRSG Emissions Report S One day Alarms Turbine 3 Daily HASG Emissions Report ond a Excess Emissions Turbine 1 Daily Bypass Emissions Report Turbine 2 Daily Bypass Emissions Report D Several consecutive days Turbine 3 Daily Bypass Emissions Report ro ChA Linearity Turbine 1 Daily Total Mass Emissions Report Pei lla Le Turbine 2 Daily Total Mass E
53. 19 EXCESS EMISSIONS REPONS monia AE A 81 CEMS Downtime REDONS ontang a O A n 84 Conflicts in Excess Emission and CEMS Downtime Reports 0086 87 TENCE TAIUIG 2 8 0 8 oe ee eee eee ee ane ornare T 88 Audi 2 9 6 9 seen one ee ne en ee eee 90 Audit Reports 1 Hour and 1 Minute ccc cecccc ccc eeceeeeeeeeeeeeeceeseeseceeseeaees 91 Audit Reports Operation Status cc ccccccecceeceeeeeceeeeeeeeecsesseteesseeseeeeeeeeees 95 AUGIE REDONS VO AUAI sieaa ol cae ecttice eaten thai tee beatae needa 97 CGA Linearity Check Reports cccccccccceececceeeeeeceeeseeseeeseeseeeeeeseeseeeaeeees 100 Opacity Calibration Error Test Reports ccccccseceeseeeeeeeeseeeeeeeeeeeeeeeneees 102 CGT and Calibration Drift Test Reports Canada ccccccceceseeseeeeeeeeees 103 SOULS FROIN GS ces tet tech Soiree Pe heen a tation tegen 104 REDO COMNEN iacvaninnahucutdonsyatsunascgtntapeaesesiaanadetauveasrcaadansyadeweahadnadandeadacuvicd 106 AUO REDONS aranea AEO 107 Conngurmg AUTO FR CDOMS aessaet a a a a a o 108 Auto Report Properties Hourly Daily Monthly ccccceccecceeseeeeeeeeee ees 115 Auto Report Properties Calibration CN CKS cccceccecc eee eeeeeeeeeeeeeeeenees 116 Auto Report Properties Event Reports ccccccececseceeseeeeeeeeeeeeeseeseeaees 118 Auto Report Properties Excess EMISSIONS ccccccceceeeeeeeeeeeeeeeeeeeseeaees 120
54. 6 48 4M oy Chimney Backflush Interval minutes 720 A Enable Chimney Auto Cal es E3 Boiler 1 Chimney Calibration B ackflush Boiler Stack Flow Boller 1 Chimney CG4 Linearty Settings Boller Online amp Startup Settings Boller FGD Inlet CGA Settings Boiler 1 40CFA 5 Settings Boiler 1 Opacity Boiler 1 FGD Inlet Calibration B ack tush Boiler 1 Alarm Settings Boiler 1 Daily Cal Tri blend Gas Cylinder Boiler 1 Daily Cal Single blend Gas Cylinder Boiler 1 Daily Cal Bi blend Gas Cylinder Change Value Change To Default Value Settings are organized into groups in the left side of the window The settings and their associated values are listed in the right side of the window Settings with a red magnifying glass icon cannot be changed A lock near the icon indicates that the setting is locked This can occur if the setting is password protected or if the Settings window is offline If Cedar is unable to communicate with the CEMS the value reads Offline setting Default alue a Chimney Daily Cal Start Time Offline a Chimney Backflush Interval minutes 20 1440 A Enable Chimney Auto Cal Offline ves Changing a Setting 46 To change a setting select the setting group on the left side of the window and then select the setting in the list on the right side of the window If there is a default value and you want to change the setting to this default value click Change to Default
55. 7 2014 Type Pronty Date Time On Date Time Off LIMIT Waming 2 7 2014 10 40 AM same LIMIT Waming 2 7 2014 10 50 AM same LIMIT Waming 2 7 2014 11 10 AM same Turbine 1 HRSG NH3 Slip lb hr Cmt Hr Options alarm severity and category Several checkboxes list the alarm severities and categories The report only displays alarms with the selected alarm severities and categories Show acknowledgment info When Show acknowledgement info is checked the report displays acknowledgement information for alarms that were acknowledged The report displays the user s logon name and the time when the user acknowledged each alarm One alarm may be acknowledged by multiple users Serious and warning alarms can be acknowledged Info alarms do not need to be acknowledged Here is an example of an alarm report with acknowledgement information 88 Chapter 3 Report Generator Alarms Demo Facility CEMS LIMIT COMM STATUS Serious and Warning Alarms for 1 25 2014 Alarm Type Phonty Date Time On Date Time Off Loss of Communication with DAS in CEMS Shelter CEMS Senous 1 25 2014 1 40 PM 1 25 2014 2 00 PM Acknowledgement Operator 2014 01 25 13 42 50 750 Color Alarm reports support color To enable color click Tools gt Options and check the Use color on reports where appropriate box on the General tab Limit alarms appear in magenta Serious alarms appear in red 89 Cedar User Manual Audit Reports The Audit category includes re
56. Auto Report Properties CEMS DOWNntimes cccccecceeseeeeeseeeeeeeeeeeeaees 122 Auto Report Properties Alarms cccccccecceceeceeteeceeeeeeeseseeceeeeeneseeseees 124 PREDOMI WIZA sinc evans theasnesnssansesnenbevaiannpernieanmndeapehatns ienaalensereoannsarauinpsorsamannperegies 126 Report Wizard Create Custom Report ccccecccecseeeeeeeeseeeeeteeeeeeeeeeeees 127 Report Wizard Modify ReDo eienenn e E 140 Report Wizard Duplicate Report annnnanananennnnnnnnnnnnnrnrnrnrernrnrnnnrrrrnrnrnrnrnnnne 142 Report Wizard Delete ReEport cccccccccecceececeeteeceeeeeeeeeseeteeseeeseeseeeeees 145 Pe DOI Genero ODOM Si aoa AAAS 147 General arsso E E E acumen te EE medias 148 BAC MPO a E O a r 149 ATA Validiy scnieasacwantieeatenSeunseeneatioen eudewinabelcnaivhausen sued AEE eie 150 ATOTO Sosa eect se ee dascte E A 152 Calibration CHECKS eaea r E a ERGS 154 Excess Emissions and CEMS Downtimes c cccecceeceeseeeeeseseeeeeeeeeeeees 156 Chapter 4 Data Editor a nannnnannnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn ennnen 159 Data Editor File Men sernesta eE n ETERA E EN N 160 EIU VIEW Data MENU crunn a AEA de aun eaaaana ensues 161 Alarni LOD aac acces E TE TE oem ioam lace E 163 View Calibration CNecKS cccccceccecceeteeeeeeeeeeeeeeeeeeseeeeeeeeeeeeseeseeeeeeeeesees 164 Graph Calibration CHECKS ccccccecsecceeceeceeeeeeeeeseeeecseeseceeessesee
57. Cedar Backup application makes backup copies of the data in the Cedar databases Cedar performs an automatic backup every night You can also e Backup data manually e Restore data into the Cedar database e Restore the Cedar configuration Backup files Each backup file is compressed and contains the data and configuration for one day The filenames use the Cedar site ID the date that the data is for and the date and time that the backup file was generated Here is an example of a folder with backup files 4 TESTSITE_20131218 gen20131220_031603 zip 4 TESTSITE_20131219 gen20131221_031605 zip 4 TESTSITE_20131220 gen20131222_031605 zip 4 TESTSITE_20131221 gen20131223_031604 zip 4 TESTSITE_20131222 gen20131223_030926 zip 4 TESTSITE_20131222 gen20131224_031604 zip 4 TESTSITE_20131223 gen20131224_030926 zip Cedar Database Utility The Database Utility allows you to perform these operations on the Cedar databases e Extract copy data from the Cedar databases to a compressed file e Merge extracted data into the Cedar databases e Purge old data from the Cedar databases Extract and merge allow you to copy data from one SQL Server instance to another Purge allows you to permanently delete old data from the databases Cedar User Manual Database Tables 208 The restore extract merge and purge operations only affect the tables the user selects This section describes the type of data that is s
58. Cedar User Manual Copyright 2015 Custom Instrumentation Services Corporation All rights reserved This document is proprietary to Custom Instrumentation Services Corporation No part of this manual may be copied or reproduced in any form nor can its contents be revealed in any manner or to any person except to meet the purpose for which it was delivered without prior written approval of Custom Instrumentation Services Corporation The screen representations data and other figures used as examples herein are fictitious The information in this document applies to Cedar version 5 or greater and is subject to change Custom Instrumentation Services Corporation reserves the right to make changes to any part of the product herein to improve its function or design Revisions and updates may be issued from time to time to document changes and or additions Cedar is a trademark of Custom Instrumentation Services Corporation All other trademarks products or services mentioned in this document are trademarks or registered trademarks of their respective holders Custom Instrumentation Services Corporation 7841 S Wheeling Ct Englewood CO 80112 Tel 303 790 1000 Fax 303 790 7292 Document generated February 11 2015 Table of Contents Chapter 1 Introduction To Cedar cccccceccseceeeeeeeeeeneeseeeeseesensonsensensenseneees 1 Cedar AD DIIGAONS cia 2 cedar Database rianne ena ee so 3 DAA POM vacdacs it wo dina
59. Cedar5Data Stores data that must be retained for a long period of time several years This typically includes 1 hour averages 6 minute opacity and all averages that are longer than 1 minute Also stores QA data such as daily calibration checks and quarterly linearity checks Cedar5DataShortTerm Stores data that does not have to be retained for a long period of time This typically includes 1 minute averages Also stores I O audit data Cedar5Realtime Stores current data Cedar User Manual Data Points Cedar s primary purpose is to acquire store and display data Each data point may contain two pieces of information e The value is the numeric value of the data point e The monitor code indicates the validity of the data point The value and monitor code are stored together as a single data point Most parameters tags store both values and monitor codes For example a NOx ppm data point may have a value of 4 6 ppm with a monitor code of 00 Valid Operating time parameters tags only store values they do not have monitor codes The values represent hours as a decimal number For example 0 25 represents 15 minutes 1 00 represents 60 minutes and 24 00 represents a full day 24 hours Process codes are also stored as simple values with no monitor codes Warning A Use caution when editing data Values and Monitor Codes should only be edited when there is a sound technical basis for the change Editing data
60. Co2T 6060 Bay 207 6 B22014 SUZ BALA Boiler 3 Calibration Checks Resulis Unit online Passed Unit online Passed Unit online Passed Unit online Passed Calibration check reports support color To enable color click the Tools gt Options menu and check the Use color on reports where appropriate box on the General tab If color is enabled failed calibrations appear in red text Otherwise failed calibrations appear in bold text If color is enabled calibrations that occurred when the unit was offline appear in blue text Date Time Parameter 10152013 6 45 AM Opacity 10152013 amp 45 AM Opacity 10152013 10 30 AM Opacity 10152013 10 30 AM Opacity Analyzer Scale Single Single Single Single Test Level Zerg Span Zero Span Unit 4 Calibration Checks Demo Facility Cal Checks for 10 15 2013 Reference Value 0 00 35 00 0 00 35 00 Measured Value 3 29 36 05 0 07 34 00 Actual Drift 3 29 1 05 0 07 0 31 Allowable Drift 2 7 7 iri Instrument Span 100 100 100 100 Results Unit offline Fail Below Unit offfine Passed Unit offine Passed Unit offline Passed Chapter 3 Report Generator Excess Emissions Reports Excess emission reports display data for times when permit limits may have been exceeded F CeDAR Reports File Tools Help wee Unit oe Parameters 0 Today 36 AWM Os lbvrmimbtu 30 S00 Alg Avg esterday 3
61. Downtimes General Facility Info Data Validity Auto Reports Use bold test for invalid values Use bold test for down values W Use bold test for substituted values 5 show montor code numbers instead of names for invalid and down values Ignore data prior to zno date Cancel Use bold text for invalid values When this option is selected data points with invalid monitor codes appear in bold text Use bold text for down values When this option is selected data points with offline monitor codes appear in bold text This includes periods when the unit was offline and may include other offline conditions such as an inactive bypass stack Use bold text for substituted values When this option is selected data points with monitor codes that indicate substitute data appear in bold text Show monitor code numbers instead of names for invalid and down values When this option is selected the monitor code numbers are displayed instead of the short description of the monitor codes Chapter 3 Report Generator Ignore data prior to If this option is selected all data prior to the entered date is considered offline This is useful for example to disregard data points Such as 1 minute and 1 hour data prior to CEMS certification without having to edit the monitor codes for that data 151 Cedar User Manual Auto Reports 152 These options apply to automatic reports Calibration Checks Excess Emi
62. Edit Dave Cancel Loading Data Use the pull down menus to select a Unit Period and Parameter e Long period data is usually 1 hour data Opacity data is usually 6 minute or 3 minute data Other period lengths are possible such as 15 minute 3 hour and 24 hour data e Short period data is usually 1 minute data Short period data is typically read only and not available for editing Click the Load Data button The data points appear in the window 171 Cedar User Manual CP Edit Data Points Long period data Short period data Unit Boiler 3 Parameter EONOxppmtHr ss si CsSCSCi From 11 3 2013 1200AM To 1179 2013 11 00 PM Select Al 1173 2013 1 00 4M Valid 173020173 1 00 4M Valid Invert Selection 1175 2013 400 4M Valid _ 11320173 3 00 4M Valid 1775 2013 400 4M Valid Deselect Al 17302073 5 00 4M Valid 1773 2073 6 00 4M Valid 1132013 7 00 4M Valid 11 3 2013 8 00 AM Preventative Maintenance 1132073 9 00 4M Valid 11302073 10 00 4M Valid 1132073 17 00 4M Valid 1132073 12 00 PM Valid 1773 2073 1 00 PM Valid 1132013 4 00 PM Valid 1173 2013 3 00 PM Valid 11737 2013 4 00 PM Walid 113414 RAN PR Walid lf an operating time parameter is selected the values represent the portion of an hour when the process or parameter was operating A time value of 0 00 means the parameter did not operate during the hour A value of 1 00 means the p
63. NT AUTHORITYNET Cedar5Data Short Tem NT AUTHORITY NET Cedar5Realtime NT AUTHORITY NET master model msdb E E m E Connechon Server SGLEXPRES Connection a View connection properties Ready Read only User For a read only user assign only the CedarDataReader role to the login Do this for each of the Cedar databases Database role membership tor CedarhAlanms CedarBackup Restore CedarData Reader Read write User For a read write user assign the CedarDataReader and CedarDataWriter roles to the login Do this for each of the Cedar databases Database role membership for CedarbAlanms 227 Cedar User Manual Basic Cedar Security Database Roles 228 Database roles define a set of permissions which can easily be applied to logins in SQL Server Management Studio SSMS Cedar defines the following database roles Some databases do not define all these roles Role CedarDataReader CedarDataWriter CedarBackupRestore CedarWebApp Description Defines read permissions for the database This role is used for both read only and read write users This role allows read only users to acknowledge alarms but not to write or modify any other data Defines write permissions for the database This role is used for read write users This role is required for all users that will write or modify Cedar data Defines additional permissions required for restorin
64. New page for each parameter Here is an example of an event report Parameter Boiler 3 Offline Boiler 3 Startup Boiler 3 Offline Boiler 3 Startup Boiler 3 Offline Boiler 3 Startup Boiler 3 Offline Boiler 3 Startup Boiler 3 Offline Boiler 3 Startup Boiler 3 Shutdown Boiler 3 Offline Boiler 3 Events Demo Facility for 3 1 2014 thru 3 31 2014 Start End Duration Value 5 2014 1 57 PM 4 05 PM 2 10 52014 4 07 PM 11 45 PM 7 42 5 2014 11 49 PM 62014 1 22 AM 1 34 62014 1 23 AM 10 17 AM 6 55 6 2014 10 18 AM 4 11 PM 5 54 62014 4 12 PM T2014 12 24 AM 8 13 72014 12 25 AM 12 50 AM 0 26 72014 12 51 AM 10 25 AM 9 35 72014 10 26 AM 11 01 AM 0 36 7 2014 11 02 AM 4 35 PM 5 35 N1gf2014 12 27 AM 130 AM 1 04 16 2014 1 31 AM W3 1 2014 11 59 PM 382 29 77 Cedar User Manual In this example the events are configured to show the durations but there are no values associated with the events Events have values when for example the unit has an emission limit for pounds per startup or pounds per shutdown 78 Chapter 3 Report Generator Calibration Check Reports Calibration check reports display the results of CEMS calibration checks stack flow monitor interference checks and other types of daily quality assurance checks F CeDAR Reports File Tools Help D aple 0i Today 18 Yesterday 1 7 E Monday 176 C Last week 12729 To 1 4 Hourly Unit Parameters PAVHASG 60 NO ppr HASG 5 NOx ppr Bypass 6O MOx p
65. Part 75 definition of a peaking unit By default this option is not selected Performance Specification A CEMS passes a typical daily calibration check if the drift does not exceed two times the performance specification there are exceptions However to pass a 7 day calibration error test the daily calibration drift must not exceed the performance specification Select the performance specification that is appropriate for the analyzer e 2 5 of Span is typically used for NOx and SO2 e Check the Use APS of 5 if appropriate box to allow use of the Alternate Performance Specification APS The APS is typically allowed for Part 75 CEMS but not for other CEMS When this box is checked a CEMS passes a calibration check when the drift does not exceed 2 5 of span or 5 ppm whichever is less restrictive e 5 of Span is typically used for CO e 0 5 Absolute Scale is typically used for O2 and CO2 Calibration drift may not exceed 0 5 O2 or 0 5 CO2 e Other of Span is used for other CEMS For example a flow monitor typically uses 3 of span e Other Absolute Scale may be used for cases which are not covered by the other options Show All Cals in Selected Interval When this option is selected all calibration checks in the date range are displayed in the results This includes calibration checks that occurred before or after the 7 day test This also includes offline calibration checks that occurred during the 7 day test
66. Save As Preview Print Close Depending on the requirements for your facility pre configured reports may be available You can define new 12 month rolling reports with the Report Wizard Here is an example of a 12 month rolling report 75 Cedar User Manual Demo Facility Facility Location Example 12 Month Report October 2013 12 Month Rolling Month NOx tons S02 tons November 163 8 324 December 169 6 is January 150 6 412 February 136 0 43 4 March T54 235 April 122 1 35 0 May 176 3 60 2 June 17 f 1 52 7 July 182 8 575 August 178 5 66 6 September 176 9 49 9 October 101 3 33 6 76 Event Reports Chapter 3 Report Generator An event report displays durations and values for events Common events are unit startup and shutdown Event reports are available if they have been configured for your facility Fij CeDAR Reports File Tools Help Hourly Monthly Quarterp Annual Events Calibration Checks Excess Emissions CEMS Downtime Alarms Audits CG4 Linearity Settings Unit pis Parameters O Today 2 12 Yesterday 2 11 O Monday 2 10 O Last week 2 2 To 2 8 E oiler 3 Startup Boiler Shutdown Boiler 3 Offline Last month January O Last quarter 2013 G4 O One day 2 11 2014 C Several consecutive days From 27072014 a To 21 2014 emer meee J O Order by parameter Options Order by date time Combine similar events onto a single line
67. Steam Flow Start 1 0 Audit Choose the unit s and parameter s to audit Click the Start button to start the audit Within a minute of starting the audit the I O Audit window shows the audit that has been started and the time when the audit started Orona E sist LO auditing acquires raw data from the CEMS as quickly as possible and writes it to the database O Statl O Audit Active 1 0 Audits Started Turbine 1 CEMS 2014 02 08 17 13 28 Stop I0 Audit Stopping an I O Audit To stop an audit select the I O audit you wish to stop and click the Stop button 50 Chapter 2 Data Monitor If an I O audit was started from the CEMS shelter or cabinet it must be stopped from that location It cannot be stopped from this window I O Audit Status The Data Monitor status bar indicates when an I O audit is active if 0 Active Alarms O Audit 4CTIVE I O Audit Alarm Cedar generates an alarm if an I O audit remains active for more than 3 hours The alarm reappears every 20 minutes until the I O audit is stopped 51 Cedar User Manual Data Monitor File Menu 52 The File menu has these options Close Closes the current active window only It does not close the Data Monitor Reports Opens the Report Generator for displaying and printing reports Data Editor Opens the Data Editor to allow viewing and or editing of stored data Print Screen Prints a screen shot of the Data Monitor window to the d
68. To enter a new value click Change Value or double click on the setting in the list Chapter 2 Data Monitor After you enter a new value the list displays Updating until the new value has been saved hy Chimney Daily Cal Start Time UE 46 Ak hy Chimney Backflush Interval minutes Updating 1440 A Enable Chimney Auto Cal es es Changing a Numeric Setting If the setting is a numeric value the following window appears Enter New Value Current Value 87 3 Default Yalue New Value 93 6 Caneel Enter the new value and click OK Changing a Time Setting If you are changing a time value the following window appears Enter New Value M Use 24 hour format a 06 49 E a Cancel Check the Use 24 Hour Format box if you prefer to enter the time in 24 hour format instead of 12 hour format Enter the new time and click OK Changing a Date Setting If you are changing a date value the following window appears 47 Cedar User Manual 48 Enter New Value Sun Mon Tue Wed Thu Fri 12 15 14 15 16 1 19 0 2 oe 23 zd 20 od 30 31 Check the No date box if the setting should not have any date at all Enter the new time and click OK Changing a Yes No or True False Setting If you are changing a Yes No or On Off value and the current value is Null the following window appears Enter New Value Select the appropriate option and click OK If the current va
69. abases 220 Chapter 5 Database Backup amp Utility Purge Data The Cedar Database Utility allows you to purge delete old data from the Cedar databases _ Database Utility TESTSITE Earact Data For Quans Purge Data Data prior to the purge date will be pemnanently DELETED trom the Cedar database Data to Purge Long Tem and QA Data Other Data E DataPoints Alarms E GADaily E Real Time Data EF GATests Shot Term Data DataPoints E lO AuditDataPoints To purge old data from Cedar databases e Select the month and year Data prior to the selected month will be deleted Warning A All data prior to the purge date in the selected table s will be deleted Make sure you have backup files for data prior to the purge date e Select the tables to purge For help choosing the tables see the section that describes the data that is stored in each table e Check your selections carefully before clicking the Purge button 221 Cedar User Manual Caution AN Check the purge date carefully before clicking the Purge button Check the table selection carefully before clicking the Purge button e Click the Purge button If the button is disabled see below A window displays the status of the purge operation A message box appears when the operation is complete Purge button disabled The Purge button is disabled by default To enable the Purge button start the Cedar Data Editor From the menu
70. ads the Cedar configuration The CGAs and Linearity Checks window opens CGAs and Linearity Checks Click the to expand the unit and view the kinds of available CGAs and linearity checks Click the to expand one kind of CGA or linearity check and view the individual tests CP CGAs and Linearity Checks Bc ie H E NOx CGA i NOx Linearity H A Stack CO2 CGA T A Stack CO Linearity aes I A 102014 s E 1418 2014 H E 1143 2013 H E 741342013 H EJ 41472013 Click the date of a test to select that test The test data appears on the right side of the window 188 Chapter 4 Data Editor Test Info The Test Info tab includes basic data about the test and the analyzer J CGAs and Linearity Checks bie Boiler 3 Test Info Low Gas Mid Gas High Gas Cylinder Info Fg NOx CGA i HO Linearity Date ffl a 2013 H Stack CO2 CGA J Stack CO2 Linearity Reason for test F Test aborted ew E 1123 2013 Analyzer and Monitor Information Range SINGLE Manufacturer TEI Model 410l Serial Humber 110233377 rT Instrument Span 20 Component ID 171 System ID C10 Passed Recalculate Cancel Passed appears if the results are within the required tolerances for all gas levels Failed appears in red if the results failed for any gas level Cylinder Expired appears if any cylinder expiration date is prior to the test date The Component ID and System ID are defined in th
71. aeeeeseegeees 166 29 jl Fe WS ad G lt gt ern ro A eee ee ee ere 171 Chapter 1 Introduction To Cedar Bulk Edit Monitor Codes and OpTimess cccecceeeseeeeeeeeeeeeeneeeeeeseeeeeeees 175 Substitute Invalid Data Point cecsssssssescussessesccscceccersursursursursursarsasess 178 REDUI DAA POIN Soora A ned earenaeeees 180 Edit Excess Emissions and CEMS Downtimes cccccccecceeeeeeeeeeeeeeeees 183 Rebuild Excess Emissions and CEMS Downtimes cccccceeeeeeeeeeeeees 186 Edit CGAs and Linearity CN CKS ccccccccccecceeeceeceeeeeeseeeeeeseeeaeeseeeseeeaees 188 Edit Opacity Calibration Error Tests cccccccsccsscceeeeeeceeseeeeeeseeeeeeseeesees 193 Edit CGTs and Calibration Drift Tests Canada cccccccecceeeeeeeeeeeeneees 194 Datel Editor SENGS east gece csaracosactentenstecadcoad eaesedectdensy S 195 Analyzer Mormann Seca sale uid a aaa adati 198 Data Editor Database Utilities Menu ccc cccc eee eeee ese eeeeeeeeseeseeeeeeeees 199 GISCO Menaia E euuacioae waslncob Com muac a 200 P Day GaliDratlonnErrOn TES irrien been tecesaenued bite ecsncwetetant 201 Chapter 5 Database Backup amp Utility ee eeeeeeeeeeeeeeeeeesenseneeneeneees 207 Data DasSe Tables sciictes cis eatun awa Sensuctes weak dlepue avandia dade cwdnadobcae ys cakinecsnesd caasanaunensoees 208 Daly AULOMIAUIG Ba CK UD raaa a a Sateen tesa euend mies 209 BACKUD
72. ain Data Monitor window Show Info alarms When this option is checked Info alarms are displayed in the alarm window and alarm banner When this option is unchecked only Serious and Warning alarms are displayed Pop up alarm window when an alarm needs to be acknowledged When this option is checked the alarm window automatically pops up when the user needs to acknowledge a new alarm Display alarm banner in main window When this option is checked the alarm banner is visible at the bottom of the main Data Monitor window Flash when there is an unacknowledged alarm This box is always checked and cannot be unchecked This serves as a reminder that the Data Monitor flashes when the user needs to acknowledge an alarm 58 Chapter 2 Data Monitor Flash when there is a communications problem This box is always checked and cannot be unchecked This serves as a reminder that the Data Monitor flashes continuously when there is a communications failure This flash usually indicates that Cedar cannot communicate with a CEMS PLC Flash main window background for unacknowledged alarms When this option is checked the background of the main Data Monitor window flashes when there is an unacknowledged alarm Flash colors The alarm flash colors can be customized for serious alarms warning alarms and communication failures Click the colored box to display the available colors Click the color of your choice Flash color S
73. al Alarms are displayed for these units Demo Facility w Turbine 1 Turbine 2 Turbine 3 Alarms Visual Alarms Audible Alarms Acknowledgement Alarms Displayed Units Alarms Send Email Automatic Features Select All Deselect All Apples to all users A facility may have multiple control rooms and each control room operates certain units This page allows each control room to show only the alarms for units that are operated by that control room Alarms that are not unit specific always appear for all users 63 Cedar User Manual Data Monitor Options Alarms Send Email In the Data Monitor main window menu click Tools gt Options gt Alarms Send Email On this page Cedar can be customized to send email messages for new alarms Qorin iT General Send email for Serious alarms Alaris visual Send email for Warning alarms Send test email at 8 30 every day SAM o Combine multiple alarms into one email recommended Alarms Acknowledgement Recipients send emails tol Alarms Displayed Units Alarms Send Email Cre Alarm Per Email Multiple Alarns Per Email Automatic Features Command line for sending alarm emails Default a Apples to all users Configuring this feature often requires coordination with IT personnel who are responsible for the email server Please contact CiSCO software support if you need assistance setting up this feature 64 Chapt
74. and Cancel buttons are highlighted Click one of them to save or discard your changes Note After data points have been modified excess emission and or CEMS downtime data may need to be rebuilt recalculated 174 Chapter 4 Data Editor Bulk Edit Monitor Codes and OpTimes Monitor codes and operating time data can be quickly changed for multiple parameters and large time periods Only monitor codes and operating times may be changed in this window This tool is especially useful for marking data as offline or invalid for large periods of time In the Data Editor menu click Edit View Data gt Bulk Edit Monitor Codes and OpTimes The window may take a minute to appear while it loads the Cedar configuration The Bulk Edit Monitor Codes and OpTimes window opens CP Bulk Edit Monitor Codes and OpTimes From 3 1 2014 m To 33172014 11 59 PM m Unit Turbine 1 Parameters BO NOx ppm 1 Hr 7 Select All 75 NMOlx ppm 1 Hr a HO Ibs 1 Hr NOx Ibs 1 Hr 40CFR75 Msile S02 lbs 1 Hr Invert Selection CO ppm 1 Hr CO Ibe 1 Hr l NH3 Slip ppm 1 Hr Select OPTIME MH Ibs 1 Hr ee 60 023 1 Hr r5 02 1 Hr H Show PID numbers Kerosene Flow 1 Hr Ibr zec New monitor code for typical non OFTIME parameters O0 Valid New OPTIME value 0 00 1 00 Change Data Close Enter the time frame for the data points that will be changed Select a unit from the pull down menu The list displa
75. ap used in formula Process offline and CEMS in maintenance SCAQMD only Too many partial CEMS maintenance hours in day SCAQMD 2012 NOx only CEMS in maintenance process offline Backflush process offline Value below 10 of range but is not fully quality assured data will be valid once it is replaced with 10 of range and MC 56 SCAQMD only Sample not available typically used with gas chromatograph data Data is not applicable N A used for special averaging requirements may be redefined renamed for site specific requirements Realtime data is unavailable Realtime data is expired outdated Data does not exist in database Valid Invalid Invalid Offline Valid Invalid Invalid Offline Offline Invalid Invalid Offline Invalid Invalid Invalid Chapter 1 Introduction To Cedar 73 Data does not exist in database used for parameters Valid that do not store monitor codes Cedar User Manual Process Codes Process codes indicate the state of the unit or process relative to permit requirements and exemptions Typical Cedar Process Codes Process Code Description 01 Facility specific 02 Facility specific 03 Startup 04 Shutdown 05 Facility specific 06 Facility specific 07 Facility specific 08 Normal no special permit conditions are in effect 09 Facility specific 13 Process Offline Process codes 01 02 05 06 07 and 09 are reserved for facility specific permit req
76. ar security permissions for each of the Cedar privilege levels Print Screen Prints a screen shot of the Data Editor window to the default printer Reports Opens the Report Generator for displaying and printing reports Exit Closes the Data Editor Chapter 4 Data Editor Edit View Data Menu Alarm Log Displays alarms history View Calibration Checks Displays calibration check history Graph Calibration Checks Displays calibration checks in a graphical format Graph Data Displays minute hourly and daily data in a graphical format Edit Data Points Allows you to edit data points that are stored in the Cedar database Bulk Edit Monitor Codes and OpTimes Allows you to quickly change monitor codes and operating time data for multiple parameters and large time periods Only monitor codes and operating times may be changed with this feature Substitute Invalid Data Points Allows you to perform missing data substitution for invalid data points This feature is for sources that report substitute data per state or local requirements This feature is not used for reporting emissions to USEPA for Part 75 Rebuild data points Allows you to rebuild recalculate data points Edit Excess Emissions and CEMS Downtimes Displays excess emissions and CEMS downtimes data Allows you to edit descriptions of the reasons and actions Rebuild Excess Emissions and CEMS Downtimes Allows you to rebuild recalculate excess emissions and
77. arameter operated for the entire hour Operating Time parameters do not have Monitor Codes Process code parameters do not have monitor codes Editing Data Select data points to edit There are several ways to select data points e To select one data point click on the row e To select a block of data points click the first row Hold the Shift key and click the last row in the block e To select non contiguous data points hold the Ctrl key and click each row e Click the Select All button to select all the rows e Click the Invert Selection button to flip the selected unselected state of all the rows This is useful if you want to edit all the data points except for a few rows 172 Chapter 4 Data Editor Click the Edit button A window allows you to change the value and monitor code Edit Data Points Do not change the value s Current 178 95 Her Mull for new value Monitor Code Current O0 Valid New funehenged o Cancel The current parameter Value and Monitor Code are displayed If you have selected more than one data point to edit and the current Values and or Monitor Codes are not the same the field will display multiple Value When editing data points it is common to change only the monitor code and not change the value By default the Dont change the value s box is checked To edit the value uncheck the box To store no numeric value check the Null for new value
78. at the report will cover Day J Semi annual each time you rur t 5 Month Year annual 12 Month Rolling lt Back Next gt Cancel 128 Chapter 3 Report Generator Select time periods for your report The Summary interval determines the total amount of time the report will cover The Detail interval is the amount of time between each row of detail data in the report The Other option is useful for specialized reports such as daily 6 minute Opacity reports This creates a report that can compactly display minute level data for a single parameter for one day See the end of this section for the Other option This wizard screen appears only when the report is first created Once the report is created this screen is not available again Click Next CeDAR 5 Report Designer Wizard Choose the columns to display in your report Also choose the summary data averages totals etc to display at the bottom of each column Add Column Move Move gt Current Column Title Width points Total 0 Width 540 Summary Data Alignment Display a line after this colurnin lt Back Next gt Cancel This wizard page lets you configure the columns for the report Click Add Column 129 Cedar User Manual Select Data Source C Parameter Process Code 1 Hr BO NOs ppr 1 Hr FS NO4 ppm 1 Hr f5 N Oe ppm 1 Hr Bias Adj 60 N 0x lb mmB tu 1 Hr FS NOe berm tu 1 Hr
79. ation status report Operation Status Demo Facility 12 16 2013 thru 12 20 2013 Time Duration Turbine 1 Process Code Turbine 1 HRSG hr min 1 Min 60 NOx ppm 1 Min 12 18 2013 00 00 09 15 9 16 Normal Operation Valid 12 18 2013 09 16 09 35 0 20 Normal Operation Calibration Check 12 18 2013 09 36 10 00 0 25 Normal Operation Valid 12 18 2013 10 07 10 20 0 20 Nonmal Operation Calibration Check 1418 2013 10 21 20 47 10 27 Normal Operation Valid 12 16 2013 20 46 20 58 0 11 Shutdown Valid 12311872013 20 59 23 59 3 01 Process Down Down 12197 2013 00 00 23 59 24 00 Process Down Down 14 20 2013 00 00 04 45 4 46 Process Down Down 12 20 2013 04 46 05 31 0 46 Control Equipment Down Malfunction 14 20 2013 05 32 05 59 0 28 Process Down Down 12 20 2013 06 00 06 43 0 44 Control Equipment Valid Malfunction 12 20 2013 06 44 07 30 0 47 Normal Operation Valid 12 20 2013 07 31 07 50 0 20 Normal Operation Calibration Check 95 Cedar User Manual 96 Show duration When this option is selected the report includes a Duration column with hours and minutes Start new line at midnight When this box is checked adjacent data on the same day are combined Adjacent monitor codes on different days are not combined This option can make reports easier to read since it is very clear where a new day begins Chapter 3 Report Generator Audit Reports I O Audits I O audits collect CEMS data at a high frequency and can
80. bine 3 Bypass Emissions Turbine 3 Operations Check marks indicate which windows are open even if they are minimized or hidden To view a hidden or minimized window click View and the window you wish to see 21 Cedar User Manual Data Monitor Giant Numbers Giant number windows display the current values of your most critical parameters in a large format for quick and easy viewing The giant number windows can be resized and repositioned anywhere on the desktop Giant number windows are available from the Giant Numbers menu in the Data Monitor main window Adding a Giant Number Window To add a new parameter to the list click Giant Numbers gt Add New The Select Parameter window appears Select Parameter _ Select a unit and parameter to display Uri Parameter 6U NOx ppm 4 OK tance Use the pull down menus to select the Unit and Parameter and click OK A new giant number window appears Giant Number Display 22 The parameter name and current value are displayed in a large window The value refreshes every ten seconds The window can be resized and repositioned as desired The background and text of giant numbers change according to whether the value is good down or invalid Chapter 2 Data Monitor Alarm Flash When there is an unacknowledged alarm a bar at the bottom of each giant number window flashes with the appropriate color CP Boiler 1 Opacity Boiler 1 Opacity
81. both results are within the required tolerances Failed appears in red if neither result is within the required tolerances The window also calculates and displays the range of allowable reference gas values The text appears red if any reference values are outside the allowable range Cylinder Info The Cylinder Info tab includes data about the reference gas cylinders The cylinder information comes from the data sheet or cylinder tag provided by the gas vendor Cf CGAs and Linearity Checks lt Boiler 3 a NOx CGA E _ oon Low azm Beamose 10 14 2013 S02NO CO2BALN HIGH A22012 RAZED 11 27 2020 502NO CO2BALN Y m TestInfo LowGas MidGas HighGas Cylinder Info aa codes are from this list separated by commas Save Cancel Cylinder information is required for linearity checks that are reported to USEPA under Part 75 Cylinder information may be optional for CGAs Cylinder information may be optional for linearity checks for non Part 75 sources If the cylinder expiration date is prior to the test date a warning icon appears Cylinder Expired appears in red on the Test Info tab and the Low Mid or High Gas tab Test Info Low Gas Mid Gas High Gas Cylinder Info Low B22011 CC51036 10 14 2003 S02N0 COZ L JIM a aa aa T aa a a A d 40 MaA PS Cee ee ed Save changes Click the Save button to save any changes you have made Or click Cancel to discard the changes 191 Cedar
82. bration checks should be run See suggested configurations for this window CP Automatic Calibration Checks Turbine 1 HRSG Calibration Disable automatic calibration checks Check e EEE clo emence at balaita kluss Ferf librati hecke at 06 48 AM Turbine 1 Bypass Calibration Check eee eee Y Skip the daily cal check if the unit is offline at this time Turbine 2 HASG Calibration Check l l l l V Skip the daily cal check if an online cal check has already run during the day Turbine SCA Calibration Check tune Ghee soe tenga Pek Calibration Checks At Unit Startup Turbine 3 HASG Calibration Check Turbine 3 Bypass Calibration Check Do not automatically perform cal checks for unit startup Perform a cal check 50 minutes after the unit begins unning 50 Perform a cal check EA minutes after the unit enters normal operation Ei Do NOT run a unit startup cal check if an online cal check has already occured during the day 40CFR 75 CEMS Using Offline Cal Checks for Data Yalidation Make sure that an online cal check rune at least ever 26 unit operating 5 hours run addtional cal checks as needed More than 99 unit operating hours have passed since the last online cal check Unit online Unit is in narmal operation Start Cal Check Abort Cal Save Cancel Calibration checks are configured separately for each sample train The left pane allows you to select each sample train When y
83. cation For Backup Files Folder J SCedarBackup Browse Backup Datels One day J Several consecutive days From To Since Last AutoBackup Date on 12 17 2013 Faster speed Stat rae To backup data e Select the folder where the backup files will be created The default location is specified in the Cedar5 ini file e Select the day s to backup e Check the Faster Speed box to allow the backup operation to complete as quickly as possible In some cases backing up many days of data may interfere with the Cedar Data Recorder and prevent it from recording data while the backup operation is in progress e Click the Start button A window displays the status of the backup operation A message box appears when the operation is complete 211 Cedar User Manual Restore Data The Cedar Backup application allows you to restore data from Cedar backup files into the Cedar databases J CeDAR Backup TESTSITE Backup Databases Restore Data Restore Configuration Location For Backup Files Folder J SCedarBackup Browse Restore Datels Selection One day 5 1 2014 Fj Long Term and gA Data J Several consecutive days m short Term From m Data To am Alarms Faster speed Stat rae To restore data e Select the folder for the backup files The default location is specified in the Cedar5 ini file If the folder contains multiple backup file
84. ckground I 342014 Print Options Frint 18 00 AM 3 18 AM Linear Regression Print To Etri r 10 000 Sawe 45 ero _ Reference Value Reference Value Difference BB FEto Spec I Perform Spec 2 Hide date time Removes the selected calibration check from the graph This can be useful when you want to compare calibration checks that are not consecutive Unhide All Displays any calibration checks that have been hidden Perform Spec Shows or hides lines for the performance specification times 2 and times 4 Background color Changes the background color of the graph Print Options Allows you to print the graph on your default printer or send the graph to another printer You can also save the graph as a PDF file Linear Regression Displays a message that indicates whether the measured value is currently increasing or decreasing and projects when the value will exceed the daily drift limits if it drifts at a constant rate 170 Chapter 4 Data Editor Edit Data Points In the Data Editor menu click Edit View Data gt Edit Data Points The window may take a minute to appear while it loads the Cedar configuration The Edit Data Points window opens C Edit Data Points Long period data Short period data Unit Boiler 3 Parameter Process Code 1 Hr From 5 13 2014 12 00AM To 5 13 2014 11 00 PM TE SelectAll Invert Selection Deselect All
85. clicked If advanced Cedar security is enabled then privilege level 3 is required to enable this menu Change last backup date see the Daily Auto Backup section for an explanation of this item Retrieve manual historical data For some facilities Cedar is configured to acquire data from an external database or historian system This tool can be used to force Cedar to retrieve data from the external source again 7 day drift evaluation see the 7 Day Calibration Error Test section for an explanation of this item Chapter 4 Data Editor 7 Day Calibration Error Test A 7 day calibration error test also called a 7 day drift test is typically required when a CEMS is certified or recertified The test consists of calibration checks conducted over 7 consecutive operating days Cedar has a tool to easily find daily calibration checks to pass the day test This tool is not commonly used so it is in the CiSCO menu While this tool provides significant assistance for finding and reporting a 7 day drift tests a full discussion of these tests is outside the scope of this manual In the Data Editor menu click CiSCO gt 7 Day Drift Evaluation The window may take a minute to appear while it loads the Cedar configuration The 7 Day Drift window opens Setup The Setup tab is initially selected CP 7 Day Drift Setup Results Eoiler 2 Performance Specifications 2 52 of Span fo AOs ppr NOs ppm 502 ppm q Use APS of 5 if
86. ct Cals button The Select Cal Data window opens Select Cal Data From 12 20 2013 12 00AM To 12 20 2013 11 59PM Parameter all l InLast Hours S Most Recent limited to last 14 days The following options are available e Enter the time period you wish to view Select a specific parameter or view all parameters e View all calibration checks in the last 1 72 hours e View most recent calibration checks Cedar looks back up to 14 days Click OK to view the calibration checks The calibration checks are organized into groups by unit Each unit is identified with the smokestack icon and the name of the unit 34 Chapter 2 Data Monitor Units are divided into sections by regulations The book icon is used to depict regulation type followed by the name of the regulation such as 40CFR60 or 40CFR75 Each line displays the results of the calibrations for each parameter calibrated A blue check mark on the left edge indicates a passed calibration A red X indicates a failed calibration The Results column gives a more detailed explanation of the fail status 35 Cedar User Manual Auto Calibration Checks 36 In the Data Monitor main window menu click Tools gt Auto Calibration Checks This feature is available if it has been configured for your facility The CEMS automatically runs calibration checks at the same time every day This window provides additional options for when cali
87. d days the calendar will ignore days with CEMS downtimes when it determines which days to display in red Show Values Limits This option only applies to excess emissions This option shows or hides two additional columns which display the value and the limit that was exceeded Excludable of 1 2014 3 24 PM Unit 4 Opacity lt b Min Avg p aT f2014 3 30 PM United t Opacity 6 Min ig 21 3 20 Rule 185 Cedar User Manual Rebuild Excess Emissions and CEMS Downtimes 186 An excess emission occurs when a source exceeds a permit limit A CEMS downtime occurs when an emissions monitoring system or other monitor is not operating or collecting valid data Cedar performs the initial checks for excess emissions and CEMS downtimes as data points are collected and written to the database Excess emissions and CEMS downtimes may need to be rebuilt recalculated after data has been modified In the Data Editor menu click Edit View Data gt Rebuild Excess Emissions and CEMS Downtimes The window may take a minute to appear while it loads the Cedar configuration The Rebuild Excess Emissions and CEMS Downtimes window appears CP Rebuild Excess Emissions and CEMS Downtimes of 12 2014 5 12 2014 11 59 PM Unit d m Exceedences Monitor Downtimes Parameters Monitor Downtime NOs IberrimBty SelectAll w Exceedence NOs Ib rimbtu 30 S00 Alg Avg w Monitor Downtime S02 IberimBty Deselect All w E
88. e added to one window Removing a bar To remove a bar from the window select the tab for the bar to delete and click the Remove Bar button Color Example The bar graph color can be configured to change with normal high and high high conditions In this example the normal color is green the high color is orange and the high high color is red CF Configure Bar Graphs Window name Opacity Opacity Bar Bar Name Opacity Colors O gt 12 E Parameter REALTIME Opacity k A Normal Scale 0 ta 3 Mm The bar graph color changes with the value 31 Cedar User Manual 13 Renaming a Bar Graph Window Cedar automatically names the bar graph windows as Bar Graph 1 Bar Graph 2 etc To give a window a descriptive name click Bar Graphs gt Rename Delete 32 Chapter 2 Data Monitor File View Giant Numbers Trends Tools Window Help Bring te Front Ctri G v BarGraph1 Add New Rename Delete A window lists all the bar graph windows that have been created Bar Graph n i ows Bar Graph 1 Hi i Cm i Delete Highlight the name of a bar graph window in the list and click Rename Type the new name and click OK Deleting a Bar Graph Window In the main Data Monitor window menu click Bar Graphs gt Rename Delete Bar Graph Win 4 C 5 Bar Graph 1 Delete Highlight the name of the bar graph window you want to remove and click Delete The item di
89. e center section of the window Click on the report you wish to view in this center section and it becomes highlighted The right side of the window contains time frame selections The possible selections vary by report category Depending on the report category you select there may be additional options displayed underneath the list of reports for that category These options are explained separately in the following pages as each report category is discussed Cedar User Manual PDF Reader The Cedar Report Generator creates most reports as PDF files A PDF reader application is required to view and print the reports Foxit Reader www foxitsoftware com and Adobe Reader get adobe com reader are the most popular reader applications Note A Adobe Reader does not function properly under the built in special accounts such as Network Service Local Service and Local System Foxit Reader is required on the DAS if auto reports will be printed from one of the built in accounts Foxit Reader is available from www foxitsoftware com Adobe Reader may be used if automatic reports will run under an account that has a typical profile not a built in account Both Adobe Reader and Foxit Reader may be installed if desired Previewing a Report Click Preview to generate a report A progress bar appears while Cedar prepares the data and generates the report file The report is displayed in your PDF reader application Printing a Re
90. e monitor plan for a Part 75 source The Component ID and System ID are not required for non Part 75 sources Note O Cedar automatically fills in the analyzer information when the CGA or linearity check is created if the analyzer information has been provided in the Analyzer Information window in the Data Editor Aborted Linearity Check Part 75 generally requires that incomplete or aborted linearity checks are considered as though they failed and must be reported in the quarterly electronic submittal to USEPA Check the Test aborted box to mark the test as aborted The exception is linearity checks that are aborted for reasons other than the performance of the CEMS for example a power outage or a closed gas cylinder valve Such linearity checks are not considered aborted tests and should not be reported to USEPA You may want to delete such a linearity check to avoid confusion 189 Cedar User Manual Abbreviated Linearity Check Part 75 allows an abbreviated linearity check following certain CEMS maintenance procedures An abbreviated linearity check consists of one injection of each reference gas instead of the full set of three injections of each reference gas If the CEMS passes the abbreviated linearity check the data is valid Abbreviated linearity checks are never reported to USEPA in the quarterly electronic reports although the facility must maintain a record of them Select the Abbreviated Linearity reason
91. e options Auto Report Properties C Print summary only C Print summary plus detail if needed Print detail only Print excluded downtimes Combine adjacent times into one line New page for each parameter Print log of any operating time conflicts Print total duration of downtimes 123 Cedar User Manual Auto Report Properties Alarms These properties apply to alarm auto reports General Tab Select when the report should be printed Auto Report Properties General UnitO ptions Report Alarm Report When E Only print if there are alarma Description Alarm Report Cancel Options Tab Select additional options See the alarm report section for descriptions of these options 124 Chapter 3 Report Generator Auto Report Properties General Unit Cptions eee ry Serou CEMS Warning LIRAIT E Info STATUS COMM BACKLP CONFIG DAS SECURITY Show acknowledgment info 0K Conca 125 Cedar User Manual Report Wizard The Report Wizard allows you to perform the following Create a new report Modify an existing report Duplicate an existing report for another unit Delete an existing report 126 Chapter 3 Report Generator Report Wizard Create Custom Report To open the Report Wizard click Tools gt Report Wizard in the Report Generator menu CeDAR 5 Report Designer Wizard This wizard helps you create or modify a custom report
92. e window Settings with a red magnifying glass icon cannot be changed A lock near the icon indicates that the setting is locked This can occur if the setting is password protected or if the Settings screen is offline If Cedar is unable to communicate with the CEMS the value reads Offline setting Default alue oy Chimney Daily Cal Start Time Offline ay Chimney Backflush Interval minutes 20 1440 A Enable Chimney Auto Cal Offline res Changing a Setting To change a setting select the setting group on the left side of the screen and then select the setting in the list on the right side of the screen If there is a default value and you want to change the setting to this default value click Change to Default 195 Cedar User Manual 196 To enter a new value click Change Value or double click on the setting in the list After you enter a new value the list displays Updating until the new value has been saved hy Chimney Daily Cal Start Time DE 46 AM hy Chimney Backflush Interval minutes Updating 1440 A Enable Chimney Auta Cal es es Changing a Numeric Setting If the setting is a numeric value the following window appears Enter New Value Curent Value 87 3 Default Value New Value 93 6 Cancel Enter the new value and click OK Changing a Time Setting If you are changing a time value the following window appears Enter New Value W Use 24 hour format
93. ear in the same list A quarterly report displays data for one quarter Quarterly reports typically display 1 month or 1 day detail data and 1 quarter aggregate data Fij CeDAR Reports File Tools Help Example Quarterly Report Quarter Example Semiannual Report 0 This quarter 2014 01 Example 12 Month Report Last quarter 2013 04 Hourly Monthly 0 20303 i One quarter QuarterlysAnnual 2013 r Events Calibration Checks Excess Emissions CEMS Downtime Alarms Audits CG4 Linearity Settings Save As Preview Print Close Depending on the requirements for your facility pre configured reports may be available You can define new quarterly reports with the Report Wizard Here is an example of a quarterly report Demo Facility Facility Location Example Quarterly Report 2013 Q4 Month NOx Ibs S02 Ibs CO tons October 202692 67178 68588 November 309489 98896 98211 December 299426 86057 97411 71 Cedar User Manual Semiannual Reports Quarterly annual semiannual and 12 month rolling reports all appear in the same list A semiannual report displays data for six months January June or July December Semiannual reports typically display 1 month detail data and 6 month aggregate data Fj CeDAR Reports File Tools Help Semi 4nnual Example Quarterly Report Example semiannual Report 2014 January June Example 12 Month Report 2013 July December Example Annual Report Mont
94. ecent calibrations within the last 14 days Click OK The calibration checks are displayed in the window Chapter 4 Data Editor r Calibration Checks Refresh Select Cals Make duplicate calibration checks bold Parameter Range Gas Level Date Time Reference Measured Drift Allowable Drift Instrument Span Results Boiler 3 40CFR75 Y Stack Flow Delta Pressure in H20 Single Scale Zero 2 1 2014 6 02 AM QinH20 0 01inH20 0 01inH20 012inH20 2inH20 Passed Y Stack Flow Delta Pressure in H20 Single Scale Span 2 1 2014 6 02 AM 1 3inH20 1 33inH20 0 03imH20 0 12 in H20 2inH20 Passed Y Stack Interference Check N A N A 27172014 6 02 M 0 84inH20 0 77inH20 0 07 in H20 0 1 in H20 N A Passed 40CFRE0 Y Opacity Single Scale Zero 2 1 2014 6 45 AM 0 0 15 0 15 2 100 Passed v Opacity Single Scale Span 2 1 2014 6 45 4M 35 34 58 0 42 2 100 Passed v 60 NOx ppm Single Scale Zero 2 1 2014 9 18 AM 0 ppm 0 01 ppm 0 01 ppm 15 ppm 300 ppm Passed v 60 NOx ppm Single Scale Span 2 1 2014 9 18 AM 167 7 ppm 168 2 ppm 0 5 ppm 15 ppm 300 ppm Passed 40CFR75 v 75 NOx ppm Single Scale Zero 2 1 2014 9 18 AM 0 ppm 0 01 ppm 0 01 ppm 15 ppm 300 ppm Passed v 75 NOx ppm Single Scale Mid 2 1 2014 9 18 AM 167 7 ppm 168 2 ppm 0 5 ppm 15 ppm 300 ppm Passed The calibration checks are organized by unit Each unit is identified with the smokestack icon and the name of the unit Units are divided into sections by regulations
95. ected data as frequently as possible Cedar may not able to read all the CEMS data every second How to run an I O Audit report First select an I O audit in the list highlighted in blue Next select the unit and parameters for the report highlighted in orange The available unit s and parameter s were determined when the user started the I O audit in the Data Monitor Finally select the time range and options highlighted in green 1 Hour Data 1 Minuibe Data Operation Status 1O Audits 1 0 Audits nit Turbine 1 start Time arameters Turbine 1 CEMS 1 9 2014 9 19 17 AM 4 HRSG NOx porn Bypass NOs ppr SCR HASG NOs HASG CO ppm Bypass CO ppr Bypass U2 CT Nat Gas Flow DB Nat Gas Flow CT Megawatts NH3 Injection Flow Rename Delete Select ll Deselect Al All data in lO audit Portrait D Landscape m From 9 19 17 AM 1 Minimum interval seconds Ta Er 5 27 AM E Only print summary values Options 98 Time range If All data in I O audit is selected the report displays data for the entire duration of the I O audit I O audit reports can be very lengthy because they can include a large number of data points In many cases it is better to narrow the time range using the From and To boxes Chapter 3 Report Generator When you select an I O audit in the list the From and To boxes change to indicate the time of the earliest and latest data points in the I O audit If y
96. ederal Regulations Part 75 has many detailed requirements for monitoring handling and reporting air emissions data 40 CFR 98 Part 98 of Chapter 40 of the U S Code of Federal Regulations Part 98 has many detailed requirements for monitoring handling and reporting greenhouse gas emissions data C CEM Continuous Emission Monitor CEM and CEMS are often used interchangeably CEMS Continuous Emission Monitoring System CEM and CEMS are often used interchangeably CEMS Downtime CEMS downtime occurs when an emissions monitoring system or other monitor is not operating or collecting valid data CGA Cylinder Gas Audit A quarterly test required by 40 CFR 60 for many gas monitoring systems Typically requires 3 injections of 2 reference gases Is similar to a Linearity Check CGT Cylinder Gas Test Specified by Environment Canada Report EPS 1 PG 7 Is similar to a linearity check CO Carbon monoxide CO2 Carbon dioxide D DAHS Data Acquisition and Handling System This term is defined by Part 75 to include software that substitutes missing data according to the Part 75 routines DAS Data Acquistion System The combination of a computer and software that acquires data from measurement systems E EPA See USEPA Exceedence See Excess Emission Excess Emission An Excess Emission occurs when a source exceeds a permit limit Cedar User Manual 244 G GHG Greenhouse Gas Many gases contribute to the globa
97. efault printer Exit Closes the Data Monitor A dialog box asks you to confirm that you want to exit The exit operation may be password protected After clicking OK in the dialog box you may have to enter a password Chapter 2 Data Monitor Data Monitor View Menu The View menu has these options Turbine 1 Turbine 2 Turbine 2 HRSG Emissions Turbine 2 Bypass Emissions Turbine 2 Operations Alarms Opens the Alarms window Calibrations Opens the Calibration Checks window where you can view recent CEMS calibration checks Facility specific windows The remaining windows are specific to your facility A check mark next to the menu item indicates that the window is open although it may be minimized or hidden To view a hidden or minimized window click View and the window you wish to see 53 Cedar User Manual Data Monitor Tools Menu 54 The Tools menu has these options I O Auditing Allows you to start stop and change O auditing Settings Allows you to change seitings that affect the software and CEMS Auto Calibration Checks Allows you to configure auto calibration checks for the CEMS This menu item is disabled if the monitoring system does not support this feature Options Allows you to change options within the Data Monitor Software Support This menu is intended to assist CiSCO software support personnel Make Sure Last Cals Are In Database Forces Cedar to verify that the most recent ca
98. egins running C Perform a cal check 60 minutes atter the unit enters normal operation Do NOT run a unit startup cal check if an online cal check has already occured during the day 40CFAR 75 CEMS Using Offline Cal Checks for Data Yalidation Make sure that an online cal check runs at least every 26 unit operating 5 hours run addtional cal checks as needed The configuration is e Set the daily cal start time early in the morning before the unit is expected to run e Check the box for Skip the daily cal check if the unit is offline at this time e Select either Perform a cal check x minutes after the unit begins running or Perform a cal check x minutes after the unit enters normal operation 40 Chapter 2 Data Monitor e Check the box for Do NOT run a unit startup cal check if an online cal check has already occurred during the day e Ifthe CEMS is subject to Part 75 and has passed on offline calibration error demonstration check the 40CFR 5 CEMS Using Offline Cal Checks For Data Validation box Unit with regular operating schedule This configuration is for a base loaded unit operates 24 hours a day or for a unit that typically starts running about the same time each day The suggested configuration for a unit with irregular operating schedule see above is acceptable Alternatively this configuration may be used Disable automatic calibration checks Daily Calibration Check
99. elay period Cedar may not be able to prevent the calibration check from starting Perform a cal check x minutes after the unit enters normal operation If this option is selected Cedar will start a calibration check after the unit completes startup and enters normal operation The definition of normal operation is specific to the unit You can configure the delay period The delay is calculated from the time the unit enters normal operation If the unit stops running Cedar will not cancel the calibration check if it has already started If the unit stops running near the end of the delay period Cedar may not be able to prevent the calibration check from starting Do NOT run a unit startup cal check if an online cal check has already occurred during the day If this box is checked Cedar will skip the unit startup calibration check if online calibration checks have already been performed earlier in the day for all analyzers in the sample train This option generally makes Cedar run a calibration check for only the first startup in a day 40CFR75 CEMS Using Offline Cal Checks For Data Validation 38 Regulatory overview This option is for use with CEMS that have passed an offline calibration demonstration 40 CFR 75 Appendix B section 2 1 1 2 This provision allows the CEMS to use a combination of online and offline calibration checks to validate data 40 CFR 75 Appendix B section 2 1 5 and additional provisions
100. emove Bar Window name Enter a descriptive title for the bar graph window Unit and Parameter Select the unit and parameter that you want to display in the bar graph The parameter list includes both real time values and one minute values Enter the scale for the bar graph Colors Three colors can be configured for the bar graph The normal color is used when the value is between the upper and lower limits The high color is displayed when the value is above the upper limit The low color is used when the value is below the lower limit If the high or low limit is blank that color is not used Also see the example below Click the colored boxes to change the colors Color Line to LEFT of bar Check the Visible box to enable the bar graph to display a line to the left of the bar graph Enter a title name for the line Chapter 2 Data Monitor Choose the parameter that provides the value for the line This parameter list includes limits defined in the Cedar configuration Click the colored box to change the colors Line to RIGHT of bar This option is the same as the Line to LEFT of bar except the line extends to the right of the bar graph instead of the left Each bar may optionally have one or two lines displayed with it Adding another bar Click the Add Bar button to add another bar to the window Cedar allows a large number of bars in the window but the text may become illegible if too many bars ar
101. eport This month January Turbine 2 Monthly Operations Report Turbine 1 Monthly HASG Emissions Report i Monthly Turbine 2 Monthly HRSG Emissions Report DO Januar December 2014 Hourly Last month December Turbine 3 Monthly HRSG Emissions Report 2013 12 months Calibration Checks Turbine 1 Monthly Bypass Emissions Report One month eee Turbine 2 Monthly Bypass Emissions Report j 3 j Turbine 3 Monthly Bypass Emissions Report EMS Downtime Turbine 1 Monthly Total Mass Emissions Report 0i Several consecutive months Turbine 2 Monthly Total Mass Emissions Report a4 Alarms Turbine 3 Monthly Total Mass Emissions Report Facility Monthly Total Mags Emissions Report e3 CG4 Linearty Settings Depending on the requirements for your facility several pre configured reports are available You can define new monthly reports with the Report Wizard Here is an example of a monthly report Demo Facility Facility Location Unit 1 Monthly NOx Report November 2013 NOx lpvimmBtu Day NOx ppm NOx IimmBtu 30 Day Rolling NOx lbs CO2 01 186 25 0 375 0 310 462 38 10 97 02 183 23 0 319 0 311 496 42 12 34 03 187 96 0 325 0 311 209 36 12 41 04 192 00 0 324 0 311 315 95 1275 05 195 64 0 325 0 311 316 98 12 95 06 191 57 0 321 0 311 504 14 12 83 oF 191 01 0 320 0 311 205 48 12 83 70 Chapter 3 Report Generator Quarterly Reports Quarterly annual semiannual and 12 month rolling reports all app
102. equirements When a CEMS fails a calibration check all data prior to the completion of the failed calibration check and in the same hour that the calibration completed is invalid For example a calibration check begins at 8 30 and ends at 8 55 The CEMS fails the calibration check The data is invalid beginning at 8 00 Data prior to 8 00 is not affected by the 8 55 calibration check 8 Hour startup grace period A startup grace period may apply to the calibration check requirement when a unit begins operating There are two requirements to qualify for the startup grace period 1 The unit must have begun operating after being offline for at least one entire clock hour For example a unit begins operating at 5 20 To qualify for the startup grace period the unit must have been offline from 4 00 to 5 00 2 The CEMS must have passed the most recent online calibration check within 26 clock hours of the hour in which the unit ceased operating For example a unit ceases operating at 10 15 on Day 2 To qualify for the startup grace period when the unit starts up again the unit must have passed an online calibration check between 9 00 on Day 1 and 10 15 on Day 2 If both conditions are met then an 8 hour grace period applies starting with the first hour in which the unit resumes operating Data is considered valid during the startup grace period Only one 8 hour startup grace period is allowed per outage If the unit starts up stops
103. er 3 Report Generator Overview The Cedar Report Generator allows you to view and print reports Some reports are pre configured by CiSCO for your facility and you can create your own reports You can also set up reports to run automatically such as every day or after calibration checks are complete Main Window In the main window of the Cedar Report Generator the reports are grouped into categories listed on the left side of the window There may be more or fewer categories depending on how Cedar is configured for your facility F CeDAR Reports File Tools Help oa Unit oe Parameters J Today 1 5 RAFHASG 60 NO ppr Yesterday 1 7 Month w HASG o NOx ppm 3 w Bypass 6O NOx ppr Monday 1 6 Calibration Checks w Bypass o NOx ppm 5 Last week 12 29 To 1 4 w SCAR NOs ppr l Excess Emissions HASG CO ppm Last month December Bypass CO ppm ii 5 quarter 2013 Q4 CEMS Downtime HASG 60 02 7 HRSG 75 02 One day yraa f Alarms w Bypass 0 022 w Bypass 75 02 Audits Several consecutive days 18204 86 CGA Linearity From m m To 17772014 a Settings Select All Deselect All Options Order by datetime Only show failed cals Only show most recent cals for each parameter Order by parameter _ l ee Online Cals F Offline Cals Gat Cylinder Information Save As Preview Pririt Close When you click on a report category the reports for that category are displayed in th
104. erious ay ey Flash color z W amning z u Flash color Comm The selected alarm colors apply to all users 59 Cedar User Manual Data Monitor Options Alarms Audible 60 In the Data Monitor main window menu click Tools gt Options gt Alarms Audible The Alarms Audible page provides the following options Domn General Play WAY files when there are unacknowledged alarms Alarme Vizual WAWY file to play for unacknowledged Serious alarms Alarms Audible C Windows Mediading way Browse WA file to play for unacknowledged Warning alarme Alarms Acknowledgment B a Alarms Displayed Units DTOWSE are e EN WAW file to play for certain other alarms Automatic Features Apples to all users Cancel Play WAV files when there are unacknowledged alarms When this option is checked the Data Monitor can play WAV format audio files when the user needs to acknowledge an alarm WAV file to play for unacknowledged Serious alarms If a valid WAV file is selected in the box the Data Monitor will play the sound when the user needs to acknowledge a serious alarm WAV file to play for unacknowledged Warning alarms If a valid WAV file is selected in the box the Data Monitor will play the sound when the user needs to acknowledge a warning alarm If serious and warning alarms both need to be acknowledged the Data Monitor will play the serious sound WAV file to play
105. es 1440C 01420072533 120 H10 The window contains information records for every analyzer in the system Analyzers with two ranges dual range analyzers appear twice in the list Click an item to select it Click the Edit button to change the value Instrument Span 100 Cancel Enter the new value and click OK 198 Chapter 4 Data Editor Data Editor Database Utilities Menu This menu starts the Cedar Backup application and the Cedar Database Utility Backup Restore Data Opens the Cedar Backup application to backup data from the Cedar database or restore data to the Cedar database Extract Data From Database Opens the Cedar Database Utility to extract copy data from the Cedar database to a compressed file for a time range Extract Data From Database One Quarter Opens the Cedar Database Utility to extract copy data from the Cedar database to a compressed file for a calendar quarter Merge Data Into Database Opens the Cedar Database Utility to merge previously extracted data into the Cedar database from a compressed file Purge Old Data Opens the Cedar Database Utility to purge delete old data from the Cedar databases 199 Cedar User Manual CiSCO Menu 200 This menu provides access to features that are not commonly used and tools that provide diagnostic information for CiSCO software support personnel Enable this menu Most of this menu is disabled until this menu item is
106. f the window displays the current status of this feature It indicates whether the unit is operating and whether Cedar is preparing to start a calibration check Unit online Unit is in normal operation Buttons Start Cal Check and Abort Cal Click these buttons to start a calibration check or abort a calibration check that is currently running These buttons are available if they have been configured for your CEMS Save and Cancel After making any changes in this window click one of these buttons to save or cancel the changes When you make a change in the right pane of this window the buttons in the left pane are disabled until you click either Save or Cancel 39 Cedar User Manual Auto Calibration Checks Suggested Configurations This section describes suggested configurations for daily automatic calibration checks Unit with irregular operating schedule This configuration is for a unit that operates on an unpredictable schedule but generally does not run in the early morning hours Disable automatic calibration checks Daily Calibration Checks Perform calibration checks at 02 30 AM a Skip the daily cal check ifthe unit is offline at this time Skip the daily cal check if an online cal check has already run during the day Calibration Checks At Unit Startup I Poly L the normal Do not automatically perform cal checks for unit startup L Perform a cal check B minutes after the unit b
107. for certain other alarms This option is rarely used Cedar can be configured so that selected alarms play a third audio file separate from the serious and warning sounds Click the question mark button to see the list of alarms that use this audio file If your facility needs this option to be configured please contact CiSCO software support Chapter 2 Data Monitor Data Monitor Options Alarms Acknowledgement In the Data Monitor main window menu click Tools gt Options gt Alarms Acknowledgement The Alarms Acknowledgement page provides the following options OOo General User must acknowledge each alarm individually show ari Acknowledge button for each alarm Alarms Visual Alarme Audible F User must enter additional test such as name or initials to acknowledge alarme requires restart Al Ack led Ee E Mere i laa neni Se ne lnstruchions for the user tell the user what test to enter Alarms Displayed Units Enter your name or initials Alarme Send Email Certain alarme can only be cleared with a password Automatic Features New password Change Password Apples to all users a The options on this page apply to all users User must acknowledge each alarm individually When this option is checked the user must click on each alarm to acknowledge it When this option is unchecked the alarm window has an Acknowledge button that can acknowledge all alarms at once Acknowledge
108. g backup data merging extracted data and or purging old data ls used for Cedar web applications This database role is needed for the account which runs the IIS web site This role is not used for typical user accounts Chapter 6 Cedar Security Advanced Cedar Security Accounts To configure advanced Cedar security open the Cedar Data Editor and click File gt Security Setup gt Accounts First time configuration To configure advanced Cedar security for the first time the Cedar Data Editor must run with administrative privileges You may see this message box CeDAR Data Editor Access denied Account does not have A privileges DBE 0151 You must be a Cedar Level 3 user or you must be an Administrator to configure advanced Cedar security If Windows User Account Control is enabled then by default this program will not have administrative privileges even if you are an administrator To run this program with administrative privileges right click on the icon and select Run as administrator Close the Cedar Data Editor Right click on the Cedar Data Editor icon and click Run as administrator Open H Run as administrator Now you can configure advanced Cedar security In the Cedar Data Editor menu click File gt Security Setup gt Accounts This window appears 229 Cedar User Manual Advanced CeDAR Security Privilege Level Account Mapping b s s Basic CeDAR security classif
109. guration Location For Backup Files Folder 9 J SCedarBackup Browse Date for Restoring Contig Data Date 5 2 2014 Faster speed Stat ria Warning AN Restoring the Cedar configuration will completely replace the existing configuration This is only recommended after contacting CiSCO software support Security and permissions A restore operation will fail if the user does not have permissions The user must have the CedarBackupRestore CedarDataReader and CedarDataWriter database roles in basic Cedar security Alternatively the user may have administrator or database owner permissions for the Cedar databases 214 Chapter 5 Database Backup amp Utility Extract Data The Cedar Database Utility allows you to extract copy data from the Cedar database to a compressed file Data extraction is useful for transferring data from one SQL Server instance to another The selected data is copied from the Cedar database to a compressed file The extract operation only copies data it does not alter data or delete data from the database Database Utility TESTSITE Extract Data For Quarter Extract Data From 2014 5 1 00 00 00 lo 2014 5 2 23 59 59 Folder C Cedar5 ExtractedData Destination File TESTSITE_20140501 20140502 Tables Long Term and GA Data Configuration Constants E ConfigData Data Points E UserConfigData GADaily Alarms QATests E Alarms Shot Term Data E DataPoints E
110. he Print button o x Cancel Allow me to enter a comment for each report Check this box to enable comments on reports Use color on reports where appropriate Some reports support color when this box is checked Close the report generator after it has been open for 12 hours When this box is checked the Report Generator will close itself after 12 hours If users launch multiple Report Generator instances but do not close the instances this option can help clean up the stale instances Attempt to close PDF Reader after clicking the Print button When this box is checked the Report Generator tries to close any Adobe Reader or Foxit Reader windows after a PDF report has been printed by clicking the Print button Some versions of PDF reader applications do not automatically terminate themselves after a report has been printed Chapter 3 Report Generator Facility Info These options apply throughout the Report Generator Enter the name and location of the facility This information appears on many reports Calibration Checks Excess Emissions and CEMS Downtimes General Facility Info Data Validity Auto Reports Facility Name Demo Facility Facility Location Facility Location o K Cancel 149 Cedar User Manual Data Validity 150 These options apply to reports that display typical data points such as hourly daily and monthly reports Calibration Checks Excess Emissions and CEMS
111. he data for each parameter starts on a new page This option applies to summary reports and detail reports Print log of any operating time conflicts When this option is selected the report generator checks for conflicts between the monitor codes and the excess emissions or CEMS downtimes Any conflicts appear on a separate page at the end of the report Conflicts indicate an inconsistency in the data and should be resolved This option applies to summary reports and detail reports 157 Chapter 4 Data Editor Overview The Data Editor displays real time data alarms and graphs The main window shows a list of common tasks you can perform in the Data Editor Click an item in the list to begin a task y CeDAR Database Editor joc aS Emissions Data Edit Data Points Bulk edit data points Graph 1 minute data Graph 1 hour data Graph daily data Exceedences And Downtimes Edit Rebuild Daily Calbration Checks View calibrations Graph calibrations LIA Checks Ch s and Lineanty Checks fay dift evaluation Cedar User Manual Data Editor File Menu 160 Change DAHS This menu item is enabled if Cedar is configured for multiple DAHS computers Click this item to switch to a different DAHS Security Setup Accounts Click this item to enable advanced Cedar security features and assign accounts to each of the Cedar privilege levels Security Setup Permissions Click this item to configure advanced Ced
112. he unit was online or offline The box may show whether the calibration was started manually or automatically Show only Zero or Span You can view the Zero or Span values separately by checking or un checking the Zero and Span boxes Chapter 4 Data Editor FE Calibration Check Graph co ee Analyzer From To 60 SO ppmL Boiler 3 2 1 2014 12 4M Aradra 12 4h lec Span o J Span 57 820 E ele i Span Measured Value p2 038 Reference Value p2 a20 Difference 0 fee IY Perform Spec a e 25 IY Perform Spec 2 Ae oe 5 4 520 Time 21172014 2r 212014 2 17 2014 9 18 00 4M 9 18 4M 16 AM Online Line colors The legend on the right identifies the colors and values for each line displayed on the graph To change the color of a line double click on the color box Select a new color and click OK Time scroll The time range appears at the bottom of the graph Use the arrow buttons in the center of the window to scroll forward or scroll backward in time Menu Right click on the graph to display a menu with additional options 169 Cedar User Manual FE Calibration Check Graph co ee Analyzer From To 60 S02 ppm L Boiler 3 2 1 2014 12AM 2 22 2074 12 Ab Span F 5 62 820 2 lt Span Measured Value 51 984 Hide 2 6 2014 09 18 E Reference Value p2 oz ORS Diference 0 836 Unhide All B Perform Spec Ae ae eo Perform Spec I Perform Spec s 2 Aa oe 4 Ba
113. hly 2073 January June Hourly Choose Period Quarterly Annual 2014 January June Events Calibration Checks Excess Emissions CEMS Downtime Alarms Audits CG4 Linearity Settings Depending on the requirements for your facility pre configured reports may be available You can define new semiannual reports with the Report Wizard Here is an example of a semiannual report Demo Facility Facility Location Example Semiannual Report 2013 Semi Annual July Month NOx tons SO tons CO tons Jul 183 3 57 5 119393 Aug 178 5 66 6 119920 Sep Vii i 49 9 116007 Oct 102 9 34 0 68588 Nov 154 8 49 6 98211 Dec 149 9 43 1 Of411 72 Chapter 3 Report Generator Annual Reports Quarterly annual semiannual and 12 month rolling reports all appear in the same list An annual report displays data for one year Annual reports typically display 1 month or 1 quarter detail data and 1 year aggregate data If your facility has 365 day rolling values they typically appear on a daily report since the values change every day F CeDAR Reports File Tools Help Boller Quarterly E misions Report Year Boiler Quarterly 40CFA75 Stack Flow To Load O This year 2014 Boiler Annual NOx 7 S502 7 CUZ m3 Boiler 1 Annual GHG Emissions Monthly ane g 2011 Oneyear 2014 Hourly Quarterly Annual Everts Calibration Checks Excess Emissions CEMS Downtime Alarms Audits CG4 Linearity Settings Save
114. ies users as read only or read write Basic security is always enabled You may optionally configure advanced security for finer control of write permissions Advanced CeDAR security does not affect reading or viewing data 0 Disable advanced CeDAR security Enable advanced CeDAR security Level 0 Level Os the default privilege level for non administrator users with read write permissions in basic CeDAR security Read only users do not even have Level 0 privileges Level 1 Add Windows User Level 1 users have few privileges Add SQL Login Remove Level 2 Add windows User Level 2 users have the privileges of both levels 1 and Add SOL Login 2 ee Remove Windows Administrators Windows administrators may change CeDAR security settings Administrators have level 2 privileges if they are read write users in basic CeDAR security Level 3 BUILTIN Administrators 5 1 6 32 544 Judd Windows User Level 3 users have the privileges of levels 1 2 and Add SQL Login 3 Level 3 users may change CeDAR security settings Remove r Cancel Advanced Cedar security is disabled by default Basic Cedar security is always enabled and cannot be disabled Select the Enable option to enable advanced Cedar security Privilege levels Advanced Cedar security defines four privilege levels Level 0 has the least privileges and Level 3 has the
115. indicates that the parameter was dowmi offline A conflict exists when e There is an excess emission but the monitor code indicates the unit Is offline or the data is invalid e There is a CEMS downtime but the monitor code indicates the unit is offline or the data is valid Conflicts can be resolved by editing the monitor codes and or by rebuilding the excess emissions or CEMS downtimes This option applies to summary reports and detail reports 87 Cedar User Manual Alarm Reports Alarm reports display alarm data for a selected time period F CeDAR Reports File Tools Help Hourly Frue OOOO Turbine 2 Turbine 3 Monthly w Facility Calibration Checks Excess Emissions CEMS Downtime Alarms Audits CG4 Linearty Settings Options Serious Warning E Info Turbines 1 amp 2 Steam Turbine iv CEMS LIMIT W STATUS Here is an example of an alarm report Alarm Turbine 1 HRSG NH3 Slip Ib nr Gmit Hr Turbine 1 HRSG NH3 Slip Ib hr Cmit Hr C aple Today 16 Yesterday 1 7 Monday 1 6 C Last week 12729 To 1 4 d Last month December Last quarter 2013 04 One day 1 7 2014 Several consecutive days From 162014 a To 7204 Select All een W COMM W BACKUP CONFIG iw SECURITY Show acknowledgment info Save As Preview Pririt Close Alarms Demo Facility LIMIT COMM STATUS Senous and Waming Alarms for 2
116. ings Reports Settings reports display the current values of settings Settings are values that are specific to your facility Settings may include daily calibration start times fuel density settings for gas and or oil bias factors on line setpoints for fuel water and steam flows and backflush intervals Fij CeDAR Reports File Tools Help Hourly Parameters C Facility Fuel Constants F Turbine 1 Online Settings i o Turbine 1 CGA Lineanty Ref Yalues O Turbine 1 Startup Shutdown Settings EeWcneticn Checks H C Turbine 1 Emission Factor Settings C Turbine 1 40CFR75 Settings Excess Emissions C Turbine 1 Cylinder Settings F Turbine 2 Online Settings CEMS Downtime H C Turbine 2 CGA Linearity Ref Yalues O Turbine Startup Shutdown Settings H C Turbine 2 Emission Factor Settings C Turbine 2 40CFR75 Settings C Turbine 2 Cylinder Settings CRM Lines i Turbine 3 Online 5 ettings _ m r m mam rum u Settings Select All Deselect All Options Monthly Alarms Audits y W Include date time of last setting change Save As Preview Frint Close In the tree select the settings that you want to include in the report Click Select All or Deselect All to select or deselect all the settings in the tree Here is an example of a settings report Selected Settings Demo Facility Group Setting Value Last changed Turbine 1 Online Settings CT Gas Flow Online Set
117. ion Time 1 Hr OPTIME 1 show PID numbers Fercent Load 1 Hr New monitor code for typical ron OPTIME parameters 13 Down ha New OPTIME value 0 00 1 00 0 lt Click the Change Data button A message box notifies you that the edits may take some time Once the process has begun there is no way to cancel it It will continue until the data has been modified Click OK or Cancel A progress window displays the status of the operation A message box notifies you when the operation is complete The message box indicates the number of data points changed and the time it took to complete the operation This can be used to estimate the time required for further edits Chapter 4 Data Editor Note O After data points have been modified excess emission and or CEMS downtime data may need to be rebuilt recalculated 177 Cedar User Manual Substitute Invalid Data Points This feature is not applicable to most facilities This feature is configured for your facility if required by the permit Note D This window does not perform Part 75 missing data substitution for data that is submitted to USEPA in quarterly electronic reports The Part 75 reporting software substitutes missing data before it generates the quarterly report Some facilities are required to substitute missing data for periods when the CEMS data is invalid Cedar typically performs the missing data substitution while it acquires data b
118. is selected the report includes a summary page for each parameter The report also includes a detail page for each parameter that had excess emissions Print detail only When this option is selected the report includes a detail page for each parameter Unit 4 Excess Emissions Demo Facility Opacity Excess Emissions for 10 1 2013 thru 10 31 2013 Parameter Start End Duration Value Limit Reason Action Opacity 10 6 2013 3 42 PM 3 47 PM 6 minutes 14 0 13 Other known causes Lowered load and isolated baghouse compartment Print excluded exceedences Excess emissions can be marked as excluded in the Cedar Data Editor Excess emissions are commonly excluded due to startup and shutdown conditions Excluded items do not appear in this report unless this box is checked Combine adjacent times into one line When this box is checked excess emissions that are immediately adjacent in time are combined into one line on the report This option only applies to detail reports This example shows two excess emissions that are adjacent but on separate lines Unit 4 Excess Emissions Demo Facility Opacity Excess Emissions for 10 1 2013 thru 12 31 2013 Parameter Start End Duration Value Limit Reason Opacity 1062013 3 42 PM 347 PM 6 minutes 14 0 13 Other known causes Opacity 1062013 3 48 PM 3 53 PM 6 minutes 18 0 13 Other known causes This example shows the same two excess emissions combined on one line Unit 4 Excess Emissions Demo Facility
119. it the selected excess emissions or downtimes click the Edit button A window opens to allow you to edit the selected items Edit Excess Emissions and CEMS Downtimes Reason Startup Delete From List Add To List Achon Delete From List Add To List This tem can be escluded from reports Cera Enter a reason or select a reason from the list If an action is required enter a reason or select a reason from the list Use the Add To List button to add a reason or action to the drop down list Use the Delete From List button to remove a reason or action from the drop down list Check the This item can be excluded from reports box to prevent the item from appearing on reports An item may be excluded from reports if allowed by the source s permit Click Save to save the changes Alternatively reason text action text and the exclude status can be edited for single items directly in the grid Options 184 Click the Options button to see a menu of options Show Calendar Shows or hides the calendar This option is selected by default Show Excess Emissions Shows or hides excess emissions This option is selected by default When this option is not selected days the calendar will ignore days with excess emissions when it determines which days to display in red Chapter 4 Data Editor Show CEMS Downtimes Shows or hides CEMS downtimes This option is selected by default When this option is not selecte
120. its The Data Monitor also provides links to the Data Editor and the Report Generator Cedar User Manual Data Monitor Alarms The Data Monitor displays alarms several ways Alarm Banner The most recent one or two alarms are displayed in the alarm banner at the bottom of the main Data Monitor window Alarms disappear after they have been acknowledged and become inactive The alarm banner updates twice per minute Click the Acknowledge link to acknowledge an alarm The alarm banner can be enabled or disabled in the Options window da CeDAR Data Monitor File View GiantNumbers Trends BarGraphs Tools Window Help Acknowledge Ct CEMS Stack Auto Cal Disabled 10 18 21 PM Acknowledge 2 CEMS Warming Low Tri Blend Cylinder Pressure 10 18 21 PM oO 4 Active Alarms Audit On 12 24 2013 10 34 02 PM EST Alarm Window 18 All active and unacknowledged alarms are displayed in the alarm window Warning alarms appear in yellow and Serious alarms are displayed in red To open the alarm window you can e From the main Data Monitor menu choose View gt Alarms e Double click the alarm count in the lower left corner of the main Data Monitor window A Categor Severity Description Active Tine Inactive Time Acknowledge CEMS Warming stack Auto Cal Disabled 10 18 21 PM Acknowledge CEMS Warming Low Tri Blend Cylinder Pressure 10 18 21 PM Acknowledge CEMS Warming Low Dual Blend Cylinder Pressure 10 18 21 PM Ackno
121. ity monitors are specified in 40 CFR 60 Appendix B Performance Specification 1 The test may have 3 4 or 5 runs for each of 3 reference filters for a total of 9 12 or 15 runs CP CGAs and Linearity Checks EAE A TestInfo LowGas MidGas HighGas CylinderInfo i NOs Linearity GQ 502 Linearity Run Time Reference Gas CEMS Response og CO2 Linearity 1 07 00 20 000 20 300 vo a O2 Dry Linearity o QB 02 wet Linearity 2 07 45 20 000 20 200 E ga Opacity Linearity 3 08 30 20 000 20 500 on 12 31 2014 4 09 15 20 000 19 800 5 10 00 20 000 19 800 Mean 20 000 20 120 Calibration Error 2 07 Lirnit 3 0 Passed Recalculate Save Cancel Close Cylinder information does not apply to Opacity Calibration Error Tests 193 Cedar User Manual Edit CGTs and Calibration Drift Tests Canada Cylinder Gas Tests CGTs and Calibration Drift Tests are similar to linearity checks Quarterly CGTs For a Cylinder Gas Test CGT the test reason must be QA Environment Canada regulations require CGTs to be performed each quarter CGTs are specified in Report EPS 1 RG 7 Revised section 6 3 1 Calibration Drift Test for CEMS certification For a Calibration Drift Test the test reason must be Certification The Certification test reason indicates the test is a Calibration Drift Test and Cedar will use the appropriate equations and pass fail criteria CGTs and Calibration Drift Tests use different equations and
122. l greenhouse effect Common GHGs include CO2 carbon dioxide CH4 methane and N2O nitrous oxide H HDR Historical Data Retrieval A CEMS PLC may store backup averages which allows the DAS to acquire data for short periods when the DAS is not running Hg Mercury L Linearity Check A quarterly test required by 40 CFR 75 for many gas monitoring systems Typically requires 3 injections of 3 reference gases Is similar to a Cylinder Gas Audit M MER Maximum Emission Rate Is defined in a 40 CFR 75 monitoring plan Monitor Code A Cedar monitor code indicates the validity of a data point Monitor Downtime See CEMS Downtime MPC Maximum Potential Concentration Is defined in a 40 CFR 75 monitoring plan N NH3 Ammonia Is commonly used to control NOx emissions NOx Oxides of nitrogen Includes NO and NO2 O O2 Oxygen Opacity Calibration Error Check A quarterly test for opacity monitors specified in 40 CFR 60 Appendix B Performance Specification 1 Has 3 5 runs for each of 3 reference values Is similar to a Linearity Check p Part 60 See 40 CFR 60 Part 75 See 40 CFR 75 PLC Programmable Logic Controller often used to control CEMS hardware and provide data to a DAS Glossary PM Particulate matter PM10 Particulate matter with a nominal diameter of 10 microns PM2 5 Particulate matter with a nominal diameter of 2 5 microns PPM Parts per million 1 percent 10 000 ppm Process Code A
123. lO AudtData To extract data from the Cedar database to a compressed file e Enter the From and To dates e Select the folder where the compressed file will be created e The Destination File box indicates the name of the file The Database Utility provides a default file name You can enter a different file name e Select the tables to extract data from For help choosing the tables see the section that describes the data that is stored in each table e Click the Extract button 215 Cedar User Manual A window displays the status of the extract operation A message box appears when the operation is complete 216 Chapter 5 Database Backup amp Utility Extract Data For Quarter A common use of data extraction is to copy a quarter of data from the DAS to another computer where the quarterly Part 75 electronic report is prepared The Extract Data For Quarter tab in the Cedar Database Utility simplifies this common extraction scenario Gf Database Utility TESTSITE This tool extracts data to a compressed p file which is placed in the download folder Extract hourly data QA data and configuration data for one quarter 2m4 x a2_ Extract minute data for the selected day s LARGE FILE One Day Consecutive Days Custom List e g 7 3 2013 7 18 2013 7 20 2013 a To extract data for a quarter from the Cedar database to a compressed file e Check the extract minute data box to extrac
124. lays the status of the operation A message box notifies you when the operation is complete The message box indicates the number of data points changed and the time it took to complete the operation Note D After data points have been modified excess emission and or CEMS downtime data may need to be rebuilt recalculated Chapter 4 Data Editor Edit Excess Emissions and CEMS Downtimes In the Data Editor menu click Edit View Data gt Edit Excess Emissions and CEMS Downtimes The window may take a minute to appear while it loads the Cedar configuration The Edit Excess Emissions and CEMS Downtimes window opens CP Excess Emissions and CEMS Downtimes March 2014 o MT WIF OS April 201 SMTW oT J Excludable E 5 1 2014 9 06 4M 57172014 9 12 4M 5 1 2014 9 18 4M o 1 2014 9 24 4M 5 1 2014 3 24 PM 57172014 3 30 PM Calendar By default the window displays a 4 month calendar March 2014 o M TW TOF 5 The selected day s have a gray background Days with excess emissions or CEMS downtimes have red text t Exceedence Opacity 6 Min Avg Opacity 6 Min Avg Opacity 6 Min Avg Opacity 6 Min Avg Opacity 6 Min Avg 4 CEMS Downtime Edit Select Options Cedar assumes that a reason needs to be entered for all excess emissions and CEMS downtimes Days with excess emissions and CEMS downtimes that have a blank reason appear in red underline 183 Cedar User Manual Edit To ed
125. lect a 1 minute audit report if you need to see monitor codes 99 Cedar User Manual CGA Linearity Check Reports These reports display data for quarterly Cylinder Gas Audits CGA Linearity Checks and similar QA tests F CeDAR Reports File Tools Help Hourly a Unit 4 3 Print one CGA linearity toe NOx Linearity check it Stack SO2 L CGA H A Stack SO2 H CGA Print all CoAs linearity Monthly SEs Stack SO2 L Linearity ae for one unit in one QuarterlyAnnual Stack COA CGA stack CO2 Linearity Show allowable ranges for Calibration Checks w reference gases if available Events eae HG Stack 02 H Linearity 203 jas Excess Emissions CEMS Downtime Alarms Audits CGA Linearity Settings Save As Preview Pririt Close Each unit is identified with a smokestack icon and the name of the unit Click the to expand the tree below the unit and view the CGA and Linearity Checks defined for that unit Book icons represent each CGA or Linearity Check Click the to expand the tree below the CGA or Linearity Check and view the individual tests that have been performed Individual icons are represented with a page icon Click a specific test to preview or print that test Here is an example of a linearity check report Each CGA or linearity check appears on a separate page 100 Chapter 3 Report Generator Unit 4 Stack SO2 L Linearity Demo Facility Test Information Analyzer and Monitor I
126. libration checks from the CEMS has been stored in the database This feature is rarely used When the Cedar Data Recorder Service starts running it automatically retrieves the most recent calibration checks from the CEMS Make Sure Last CGAs Linearity Checks Are In Database Forces the software to verify that the most recent CGA or Linearity Check data has been stored in the database This feature is rarely used It is useful if Cedar was not running when a CGA or linearity check was performed and the data now needs to be retrieved from the CEMS Make Sure Historical PLC Data Is In Database For CEMS that store backup data in the PLC Cedar automatically retrieves the data every night to fill in any gaps in the data Use this menu item to manually start the historical data retrieval HDR process This feature is rarely needed but can be useful if Cedar was not running overnight Chapter 2 Data Monitor Data Monitor Options The Options window allows you to customize certain features and provide general information about system settings and file locations In the Data Monitor main window menu click Tools gt Options The Options window has these pages General Alarms Visual Alarms Audible Alarms Acknowledgement Alarms Displayed Units Alarms Send Email Automatic Functions 55 Cedar User Manual Data Monitor Options General In the Data Monitor main window menu click Tools gt Options gt General
127. lick one of the Set All buttons to set the minimum privilege level for all settings Right click on a setting to select the minimum privilege level 233 Cedar User Manual Right click to change Setting Groupslheme Privilege Level Facility Fuel Constants Mat GLY Gas Btursct Low Fail Limit Level 3 Nat GCW Gas Btu Level 1 or higher Nat GEV Gas Btu Level 0 or higher Level 3 Fd Factor Gas dsc Level 3 Level 1 or highe Gas Density lb sct oe tages Level 3 NH3 in aqueous Level 2 or higher Level 3 Turbine 1 Online Settir ii CT Gas Flow Online Setpoint bsec Level 3 DB Gas Flow Online Setpoint hectHr Level 3 Data Monitor These items apply to the Cedar Data Monitor Advanced CeDAR Security Permissions Settings Data Montor Data Editor Reports Data Editor These items apply to the Cedar Data Editor Advanced CeDAR Security Permissions Settings Data Monitor Data Editor Reports Enter reasons actions for NEW exceedences i and CEMS downtimes Level 3 Edit reasons actions for SLL exceedences and CEMS downtimes Level 3 Rebuild esceedences and CEMS downtimes Level 3 Edit data values Level 3 Rebuild data values Level 3 Change analyzer information Level 3 Edit CGAVlinearity data Level 3 234 Chapter 6 Cedar Security Report Generator These items apply to the Cedar Report Generator Advanced CeDAR Security Permissions Settings Data Monitor
128. lly group related columns together You cannot display a line after the last column in the report lf the highlighted column has summary information available it appears in the Summary Data list Current Column Summary Data Title NOs lbs 1 Hr i NOx lbs 24 Hr Total Width points 55 Total 256 Width 540 NOs Ibs 24 Hr Avg E NOx Ibs ear to Dap Total l NOs tons Year to Date T otal Display a line after this column NOs Ibs 365 Day Roling Total Check the box next to the summary data that should be displayed on the report Summary values will appear on the bottom of the report You may not select any summary data for the first leftmost column This column is reserved for descriptions of the summary data Click Next Chapter 3 Report Generator CeDAR 5 Report Designer Wizard You may enter a caption for each group of columns on your report The vertical lines separate the columns into groups Each caption is centered over its group Column titles MOs ppm NOs IberomBtu NOx Ibs Group title NOx Bold Italic Previous Group Next Group gt lt Back Next gt Cancel If you have separated columns into groups by checking the Display a line after this column boxes on the previous screen you have the option to add a title to each group of columns If you have not grouped the columns the fields on this screen will be disabled The column names for the group appear in the first field You
129. lue is already Yes No True or False then the value will simply toggle when you click Change Value Chapter 2 Data Monitor Data Monitor I O Auditing Cedar normally reads CEMS data every 10 seconds When an I O audit is active Cedar reads the selected parameters from the CEMS as quickly as possible The read frequency depends on the communication speed and the amount of other data that Cedar must read from the CEMS but may be as often as once per second I O auditing can be useful for troubleshooting and analyzer response time tests required for CEMS certification Once an I O audit is complete an audit report can be printed from the Cedar Report Generator I O Audit Window In the Data Monitor main window menu click Tools gt I O Auditing The I O Audit window appears An I O audit can be started from this window If the CEMS control panel supports it I O auditing may also be started with a button in the CEMS shelter or cabinet Multiple I O audits may be active at one time LO auditing acquires raw data from the CEMS as quickly as possible and writes it to the database Start VO Audit Active 1 0 Audits Started aa Starting an I O Audit Click the Start I O Audit button to start a new audit A window displays the parameters that can be audited 49 Cedar User Manual Select parameters to audit Unit 1 CEMS NOx pom Chimney 502 pom FED Inlet 02 pom Chimney CO2 FD Inlet CO2 Opacity Stack Flow
130. missions Report To 1 20T4 m settings Turbine 3 Daily Total Mass Emissions Report Facility Daily Total Mass Emissions Report Save As Preview Pririt Close Depending on the requirements for your facility several pre configured reports are available You can define new daily reports with the Report Wizard Here is an example of a daily report Demo Facility Facility Location Turbine 1 Daily HRSG Emissions Report December 18 2013 Hourly Emiasion Limite NOx ppm i5 02 NOx Ibs CO Ibs NHS Slip Combined Cycle 2 24 Hr Roling 24 9 52 2 25 3 Simple Cycle 3 52 2 Sanupshurdown 650 1900 NH3 Silp NOX ppm NOx CO pom co NH3 Sip pom is NH3 Slip Process Hour o2 NOxppm i5 02 ibimmiu NOxlbe COppm i5402 bimm tu CO lbs ppm o2 IbimmBtu NH3 Sipits status od 13 56 217 1 65 0 0066 11 50 LES 0 73 O 0017 2 65 4 71 TA THD 543 Nomal oi 13 99 217 1 85 0 0065 11 83 LES 75 o 0017 2 97 87a TS PERE 6 61 Normal Oo 13 99 A 1 65 0 0065 11 64 agi 7a ooir 2 96 4 45 TT ins 6 97 Nommial 03 14 00 216 1 85 0 0065 11 91 LES 76 ooir 2 98 5 95 TF Dib TDi Nomal g 13 57 2 15 1 64 0 0066 12 55 CLE is 0 0017 3 14 7 34 6 4 o0052 5 29 Nomal 69 Cedar User Manual Monthly Reports A monthly report displays data for one month Monthly reports typically display 1 day detail data and 1 month aggregate data F CeDAR Reports File Tools Help Turbine 1 Monthly Operations Report Month s Turbine 3 Monthly Operations R
131. most Each privilege level has all the permissions of the lower level plus any privileges defined for its level Only Level 3 users and Windows administrators may change the advanced Cedar security settings Non administrative users are assumed to be in Level O unless they have been assigned to a higher level Level O read write users are allowed to utilize Cedar features for which no minimum privilege level has been selected Windows administrators have Level 2 permissions by default plus they can change the advanced Cedar security settings Windows administrators may optionally be assigned to Level 3 230 Chapter 6 Cedar Security Recommended configuration For Active Directory accounts CiSCO s recommendation is to create an Active Directory group for each privilege level For example create three groups named Cedar Level 1 Cedar Level 2 and Cedar Level 3 Assign the Active Directory groups to their appropriate privilege levels in this Cedar window Then add individual users to the appropriate groups in Active Directory SQL logins cannot be managed by groups so each individual read write SQL login must be assigned to a privilege level in this window Windows user accounts To add a Windows or Active Directory user or user group to a Cedar privilege level click the Add Windows User button This window appears Add Accounts s Groups The current user is a member of these account groups Add these accounts
132. n anaa A T E EE 49 Data Monitor File Menu cccccccccecceceeceeceeseeseeeeeeeseeseeseceeseeseeeeeseeseseeseegess 52 Data Monitor View WISIN ics rorsimarei eand ereak Ea E a 53 Data MONITOR TOOlS M nU sssrin E TE 54 Data MONIKO OPIO S enun a ENE 55 Data Monitor Options General ccccecceeceeceeceeceeeeeeeeeeeeeeeceeceeeneeseseeeeeeees 56 Data Monitor Options Alarms Visual cccccecceeceeeeeeeeeseeseeeeeceeeeeeeeseeees 58 Data Monitor Options Alarms Audible cccccccecceceeeeeeceeteeeeeeeeeeeeeenees 60 Data Monitor Options Alarms Acknowledgement c cccceceeeeeeeeeeeeeeees 61 Data Monitor Options Alarms Displayed Units cccccccceecceeeeeeeeeeaeeees 63 Data Monitor Options Alarms Send Emall ccccccecseeeeeeeeeeeeeeeeeeaeeees 64 Chapter 3 Report Generator ccccccccseceeeeneceeceeeneeneseesencneeeeseesensonsoneoneoness 65 Hourly IRE DOIMS areeni ea Aa Saclersasnieaxtacia A 68 BAV REDON S arat E r dias aeaconladiad 69 WIOMUALY REPONS srerarssersiir apalen eE er E EEE EE EErEE RENEE NAE ENRETA R TEREN 70 Quarten REDONS aiies A 71 SSMANMUAl RED OMS raa OA 72 ANNUAL REPONS oen ck eos eaters a a a a a a aa aea 13 Cedar User Manual vi 12 M nth Rolling Reports seirene E EER 15 Event REPOS oaa EA N a ecen dain a el cwalaeuiaw nar tatenearets T1 calibration GHEGCK REDONS arsrniceinionanaenn e eindineunbentelecienttsaetanetaaaes
133. n of SQL Server login configuration is outside the scope of this manual See Microsoft s SQL Server documentation or other resources for more information New SQL Server Login 224 To add a new user or account navigate to Security gt Logins in the SSMS Object Explorer window Right click on Logins and select New Login x Microsoft SQL Server Management Studio File Edit View Debug Tools Window Help Py gt GS ied Sl NewQuey C t ES Object Explorer Connect A a m T us g SQLEXPRESS SQL Server 11 0 21 Databases a E Security E Logins Start Powershell Reports oh sa The Login Properties window appears Select a page A General 4 Server Roles i User Mapping AA Securables Status SQLEXPRES Connection 3 View connection properties Progress Ready For Windows authentication select the account or group For SQL Server Chapter 6 Cedar Security GA Script 4 Help Login name NT AUTHORITY Authenticated Users Windows authentication SQL Server authentication 6 Mapped to certificate Mapped to asymmetric key E Map to Credential Mapped Credentials Credential Provider Default database Default language authentication enter the name and password for the new login In the Login Properties window configure the user mapping see below Existing SQL Server Login To configure basic Cedar security for an account or group that has an existing
134. n string options is beyond the scope of this manual Cedar uses the SQL Native Client from Microsoft for database access The Provider value varies with the version of SQL Server SQL Server Q Provider value version SQL Server 2008 JSQLNCLI10 Server 2008 SQLNCLI10 SQL Server 2012 SQLNCLI11 SQL Server 2014 JSQLNCLI11 CedarDir This is the main Cedar folder Cedar creates additional subfolders in this folder LogsDir Cedar creates log files in this folder Cedar creates additional subfolders in this folder BackupDir Cedar creates daily backup files in this folder See the section on daily automatic backup for more details 13 Cedar User Manual Administrative rights to modify Cedar5 ini lf Windows User Account Control UAC is enabled administrative rights are required to modify files in the Program Files folder Without administrative rights you may view Cedar5 ini in Notepad but you may not modify it To run Notepad with administrative rights right click on the Notepad icon and click Run as administrator Ae Run as administrator 14 Chapter 1 Introduction To Cedar Historical Data Retrieval HDR For most CEMS where the CEMS PLC has been supplied by CiSCO the PLC also functions as a data logger to store a limited number of data points This historical backup data allows Cedar to acquire data for short periods when Cedar is not running This is useful for DAS maintenance such as software u
135. n the Report Generator menu Fi CeDAR Reports File Tools Help Hour Auto Reports _ al s o siaga lt Monthly QuarterlyAnnual Events Calibration Checks Excess Emissions CEMS Downtime Alarms Audits CG4 Linearity ok Cancel Click one of these report categories e Hourly e Daily e Monthly e Events e Calibration Checks e Excess Emissions e CEMS Downtimes e Alarms Adding a New Auto Report Click al to add a new auto report to the list In the Auto Report Properties window select the report to print Select when the report should be printed 108 Chapter 3 Report Generator Auto Report Properties General Report Unit 4 Daily Emissions Report k When Every day a Descriptions Unit Daily Emissions Report Change the description if necessary The report name is the default for the description You can change this description if you want to set up the same report to run automatically with different settings The description only appears in the auto reports listing and allows you to differentiate between modified versions of the same report The properties window has additional options for calibration checks excess emissions CEMS downtimes and alarms Click OK Cedar automatically sets the report to print to the default printer The new auto report appears in the list The report destinations appear under the description Auto Reports Al 210 2 Ble x E Uni
136. nd detail Select All Deselect All Print excluded CEMS downtimes Days 0i Today 18 Yesterday 1 7 E Monday 1 6 C Last week 12 29 To 1 4 E Last month December Ei Last quarter 2013 G4 O One day yz a D Several consecutive days From 16 2014 a To 17204 a Combine adjacent times into one line Options Save As Preview Pririt Close 0 Print detail only Print summary only When this option is selected the report includes a Summary page for each parameter Unit 4 CEMS Downtime Summary Demo Facility Opacity 6 Min Avg CEMS Downtime for 11 1 2013 thru 11 30 2013 Reason Duration Other known causes 1 hour 24 minutes Total duration of Opacity 6 Min Avg CEMS downtime Total operating time Operating time with CEMS downtime 1 hour 24 minutes 652 hours 54 minutes 0 2 Note The total operating time is derived from the monitor codes Different parameters may display different operating times for the same date range This occurs if the monitor codes are inconsistent for 84 Chapter 3 Report Generator example when one parameter has an online monitor code and a different parameter has an offline monitor code for the same date time Print summary and detail When this option is selected the report includes a Summary page for each parameter The report also includes a detail page for each parameter that had CEMS downtimes Print detail onl
137. nformation Test Date 12372013 Range Low Facility Demo Facility Instrument Span 100 ppm Unit nit 4 Component ID 150 ORIS Monitoring System ID 510 Test Reasonis OA Manufacturer TEI Aborted No e Seral Humber 430 124 678 Run Reference CEMS Nummer Time Gas Response Cylinder Information Low Gas l Allowable Reference Values 1 7243 AM 2543 25 53 i es i 20 30 ppm 20 30 of span 2 8 04 AM 2543 25 52 Cylinder ID WW881327 2 2 SA Expiration Date 10 23 2015 Mean ppm 25 43 25 00 EPA Vendor ID F12012 Mean Difference opm 0 17 Lim 5 Fassed Cylinder contains Linearity Enror 0 7 Lim 5 0 Passed SO NO CO2 BALN Mid Gas EE i B 11 AM 52 66 53 27 ae span Pima Mie La Show allowable ranges for reference gases When Show allowable ranges for references gases is checked the report calculates and displays the range of allowable reference values for each gas level To see the allowable ranges the analyzer information must have been entered in the Data Editor If color is enabled the reference gas text is displayed in red if the reference value is outside the allowable range To enable color click the Tools gt Options menu and check the Use color on reports where appropriate box on the General tab Print all CGAs linearity checks for one unit in one quarter Select this option to include all CGAs and linearity checks for one unit and one quarter in the report In the tree select the unit icon or select any book icon o
138. ntire list of parameters 91 Cedar User Manual 4 CeDAR Reports File Tools Help Hourly Monthly Calibration Checks Excess Emissions CEMS Downtime Alarm Audits CG4 Linearity Settings Save List button 1 Hour Data 1 Minute Data Operation Status IO Audits Turbine 1 g gt Saved Lists Parameters Process Code 1 Hr MaWHASG 60 0 ppm 1 Hr HRSG 75 MO0 ppm 1 Hr T5 H0 ppm 1 Hr tor 40CFRA7S Reporting HASG NHOs ppm tS 02 1 Hr Normal Ops HASG NOs ppm 15 OZ 1 Hr Combined Cycle Normal Ops HASG NOs ppm 154 02 1 Hr Simple Cycle Normal Ops HASG NOs ppm 152 O2 1 Hr Combined Cycle Normal Ops HASG NOs ppm 154 02 24 Hr Alling HRSG 60 MOs lb mmEBtu 1 Hr HRSG 75 MOe lb mmBtu 1 Hr HRSG 5 MOe Ib mmBtu 1 Hr Bias Adi f5 NO Ibe rmbtu 1 Hr for 40CFA 5 Reporting EE Select All Deselect All Weav2n412008M haan Heel l 5 0 Landscape To 17872014 9 20 AM z E Only print summary values Show valid non zero monitor codes Save As Preview Pririt Close To save the list of parameters for future use click Save List The parameter list is saved as a new entry under Saved Lists Enter a name for the new list 1 Hour Data 1 Minute Data Operation Status 0 Audits Saved Lists Parameters Turbine 1 Turbine 1 Hourly Bypass Emissions Report 1 Minute Data Turbine 1 Hourly HA SG Emissions Report 1 Minute Data eport 1 Minute Data ypas Emissions Report
139. oiler 1 60 H0 Ib mmB tu Fename Boiler 1 Heat Input Rate mmb tut Boiler 1 NO br Delete Botler 1 Opacity Boiler 1 Stearn Flow klbhr Highlight the name of the giant number window you want to remove and click Delete The item disappears from the list and is permanently deleted when you click OK Click Cancel to exit this window without deleting any giant number windows Chapter 2 Data Monitor Data Monitor Trends Trending allows you to view current and recent data as a graph Trends update at 10 second or 1 minute intervals Trend windows are available from the Trends menu in the Data Monitor main window Ee a 11 31 10 AM 11 41 10 AM 11 51 10 4M afffell4 ai ffeil af ffell Adding a New Trend In the main Data Monitor window menu click either Trends gt Add New 10 second data or Trends gt Add New 1 minute data A blank trend window opens Ea an SSE 1 aT oo 1 50 PM 0 47 50 PM 2 51 50 PR efffell4 arrr ld 25 Cedar User Manual To add a parameter to the graph right click on the graph Select Edit Graph from the drop down menu The other menu options are disabled until you have placed a parameter on the graph The Configure Trend window appears A trend can display up to six parameters Each tab represents one parameter to display and its color Configure Trend Parameter HRSG NOs ppm 1S Oe h Max Min Maximum Value Minumum Salue 30 0 gt foo F Use Zero O ce
140. onitor window menu click Trends gt Rename Delete 27 Cedar User Manual Tend Winions E Highlight the name of the trend window you want to remove and click Delete The item disappears from the list and is permanently deleted when you click OK Click Cancel to exit this window without deleting any trend windows 28 Chapter 2 Data Monitor Data Monitor Bar Graphs Bar graphs allow you to view current values with optional lines to show emission limits Bar graph windows are available from the Bar Graphs menu in the Data Monitor main window Limit Limit i E HE 0 91 0 0217 4 25 0 0095 NOx 15 02 NOx Ib mmbtu CO 15 02 PIETS Adding a Bar Graph In the main Data Monitor window menu click Bar Graphs gt Add New A blank Bar Graph window opens D So ali _ 3 Configuring a Bar Graph Click the button in the lower right corner to configure the bar graph 29 Cedar User Manual 30 Window name Bar Graph 1 NOx 15 02 NOx Ib mmbtu CO 15 02 CO Ib mmbtu Unit Turbine 1 Bar BarName NOx 15 02 Colors E gt Parameter REALTIME HRSG NOx ppm 15 02 Normal Scale 0 to 20 ppm a lt Line on LEFT of Bar Line on RIGHT of Bar Visible a Visible Name Limit NE Parameter LIMIT Simple Cycle Normal Ops HRSG NOx ppm 15 0 Y Parameter LIMIT Combined Cycle Normal Ops HRSG NOx ppm 15 Color iy Color E Add Bar R
141. ons or CEMS downtimes ended detail reports only Print total duration of excess emissions or CEMS downtimes detail reports onl J New page for each parameter Mf Print log of any operating time conflicts O xK Cancel Start a new line at midnight This option applies when the combine adjacent times into one line box on the main window is checked for excess emissions and CEMS downtime reports When this box is not checked adjacent items are combined without restriction When this box is checked adjacent items on the same day are combined Adjacent items on different days are not combined This option can make excess emission and CEMS downtime reports easier to read since it is very clear where a new day begins This option only applies to detail reports it does not apply to summary reports Print times when excess emissions or CEMS downtimes ended When this option is selected the report includes the date and time when the excess emission or CEMS downtime ended The report always displays the start time and the duration This option only applies to detail reports it does not apply to summary reports Chapter 3 Report Generator Print total duration of excess emissions or CEMS downtimes When this option is selected the report includes a total duration at the bottom This option only applies to detail reports it does not apply to summary reports New page for each parameter When this option is selected t
142. or Auto Report Properties Hourly Daily Monthly These properties apply to hourly daily and monthly auto reports Select the report to print Select when the report should be printed Auto Report Properties General Report Unit 4 Daily Emissions Report When Description Unit Daily Emissions Report 115 Cedar User Manual Auto Report Properties Calibration Checks These properties apply to calibration check auto reports General Tab Select when the report should be printed If a calibration check complete option is selected the Unit Parameters and Options tabs are disabled If Every day is selected the other tabs are enabled Auto Report Properties General Unit Parameters Options Report Calibration Report Wher United Stack Cal Complete sA E Only print if there are calibrations Description Unit 4 Stack Cal Complete ox Cancel Unit Parameters Tab Select the unit and parameters to include in the auto report 116 Chapter 3 Report Generator Auto Report Properties General Unit Parameters Options Parameter s w GO NOe ppr w 5 H Oe ppm w 60 Stack S502 pom W r 5 Stack S02 pom w 60 Stack COS w 6 Stack LOSS Options Tab Select additional options See the calibration checks report section for descriptions of these options Auto Report Properties General Unit Parameters Options Order by date time
143. ormal daily cal time Cedar checks whether online calibration checks have already been performed for the day Cedar skips the calibration check by temporarily adding one hour to the normal cal time and then changing it back after the normal daily cal time has passed Calibration Checks At Unit Startup These options may be used to start calibration checks after the unit begins operating Note These settings do not prevent the CEMS from performing a calibration check at the normal cal start time For example if the unit is in startup at the normal cal start time most CEMS will start a cal check Some CEMS have logic to prevent cals from running while the unit is starting up or to delay a cal check until the unit is in normal operation Please contact CiSCO if you need your CEMS to prevent auto calibration checks while the unit is starting 37 Cedar User Manual Do not automatically perform cal checks for unit startup If this option is selected Cedar will not start any additional calibration checks following unit startup Perform a cal check x minutes after the unit begins running If this option is selected Cedar will start a calibration check after the unit begins running You can configure the delay period The delay is calculated from the time the unit begins running If the unit stops running Cedar will not cancel the calibration check if it has already started If the unit stops running near the end of the d
144. ou enter a time range that is outside the range of the I O audit you will only see data points that are within the I O audit time frame Minimum interval seconds I O audit reports can be very lengthy because they can include a very large number of data points You may want to see a data point every 5 or 10 seconds to limit the length of the report The default value for this option is 1 If you enter 10 for example the data points displayed on the report will be at least 10 seconds apart Note AN When this option is greater than 1 some columns may appear to have many missing data points This is because Cedar could not read all the data points in the same second Change this setting to 1 to see all the data points Note Because I O audit reports often contain large amounts of data it can be very helpful to save the report in CSV format and open it ina spreadsheet such as Microsoft Excel Averages and totals can be easily calculated in a spreadsheet Only print summary values When Only print summary values is checked the report only displays the aggregate average minimum maximum values The report does not display the detail data Rename and Delete Click the Rename button to give an I O audit a descriptive name Click the Delete button to delete an I O audit that you no longer need Monitor Codes This report does not include monitor codes I O audits only collect data for real time analog values Se
145. ou make a change in the right pane the buttons in the left pane are disabled until you click either Save or Cancel Disable automatic calibration checks Check this box to disable all automatic calibration checks in the CEMS Chapter 2 Data Monitor Daily Calibration Checks Perform calibration checks at time This is the normal time when the CEMS runs a calibration check every day Skip the daily cal check if the unit is offline at this time If this box is checked Cedar will skip the daily calibration check if the unit is offline at the normal daily cal time Approximately 10 minutes before the normal daily cal time Cedar checks whether the unit is offline Cedar skips the calibration check by temporarily adding one hour to the normal cal time setting and then changing it back after the normal daily cal time has passed Note O If the unit starts operating after Cedar has decided to skip the daily calibration check but before the normal daily cal time Cedar may not be able to prevent the calibration check from being skipped even though the unit is online Skip the daily cal check if an online cal check has already run during the day If this box is checked Cedar will skip the daily calibration check if online calibration checks have already been performed earlier in the day for all analyzers in the sample train This feature is intended to minimize unnecessary online calibration checks Approximately 10 minutes before the n
146. ource file Tables Long Term and GA Data Configuration Constants E ConfigData Data Points E UserConfigData E GADaily Alarms F QATests Z Alarms Shot Tem Data E DataPoints E OAudtData To merge extracted data into the Cedar databases e Enter the From and To dates e Select the zip file that contains the extracted data Warning A Do not enter a time range that is larger than the data in the source file Existing data will be deleted and not replaced Note Do not unzip the extracted files The merge operation will unzip the files to get the necessary data e Select the tables that will receive the imported data For help choosing the tables see the section that describes the data that is stored in each table 219 Cedar User Manual e Click the Merge button If the button is disabled see below A window displays the status of the merge operation A message box appears when the operation is complete Merge button disabled The Merge button is disabled by default To enable the Merge button start the Cedar Data Editor From the menu select Database Utilities gt Merge Data Into Database Security and permissions A merge operation will fail if the user does not have permissions The user must have the CedarBackupRestore CedarDataReader and CedarDataWriter database roles in basic Cedar security Alternatively the user may have administrator or database owner permissions for the Cedar dat
147. pass fail criteria Environment Canada regulations require daily Calibration Drift Tests during the 168 hour Operational Test Period for CEMS certification A Calibration Drift Test involves 3 injections of 3 gases for a total of 9 injections Calibration Drift Tests are specified in Report EPS 1 RG 7 Revised section 5 3 2 194 Chapter 4 Data Editor Data Editor Settings Settings are values that are specific to your facility Settings include but are not limited to daily calibration start times for each sample train fuel density settings for gas and or oil bias factor settings on line setpoints for fuel water and steam flows and backflush intervals Settings Window In the Data Editor menu click Edit View Data gt Settings The Settings window opens J General Settings E3 Boiler 1 Chimney Calibration B ackflush Boiler 1 Stack Flow Boller 1 Chimney CG4 Linearty Settings Boiler 1 Online amp Startup Settings Boller FGD Inlet CGA Settings Boiler 1 40CFA 5 Settings Boiler 1 Opacity Boiler 1 FGD Inlet Calibration B acktlush Boiler 1 Alarm Settings Boiler 1 Daily Cal Tri blend Gas Cylinder Boiler 1 Daily Cal Single blend Gas Cylinder Boiler 1 Daily Cal Bi blend Gas Cylinder A Chimney ar ee tie 0 Enable Chimney Auto Cal es Change Value Change To Default Value Settings are organized into groups in the left side of the window The settings and their associated values are listed in the right side of th
148. pgrades and system reboots Newer PLCs with large memory capacities store 1 minute data usually for 7 days Older PLCs with less memory may store 1 hour averages for up to 7 days The actual amount of data stored varies with the system configuration The HDR process automatically runs every night shortly after midnight If the PLC provides 1 minute data the HDR process also recalculates 1 hour averages The HDR process automatically rebuilds excess emissions and CEMS downtimes for the previous day Replacement conditions D HDR replaces existing data only when one or more of the following conditions are true e The existing value is Null and the existing monitor code is 18 22 0 71 72 or 73 This includes the case where the data does not exist in the database e The existing value is Null and the existing monitor code is valid e The existing data has monitor code 18 22 70 71 72 or 73 and the historical data is valid or offline HDR does not replace existing process code data in the database 15 Chapter 2 Data Monitor Overview The Data Monitor displays real time data alarms and graphs You can perform these common functions in the Data Monitor e View Acknowledge alarms e View calibration checks e Change facility specific settings e Select facility specific windows e Set application options e Display giant numbers e Display real time graphs of data e Display bar graphs e Start stop I O aud
149. pm Bypass 75 08 ppm w SCAR NOs ppr HASG CO ppm Bypass CO ppm w HRSG 60 02 w HRSG 75 02 Bypass 0 022 w Bypass 75 02 Monthly Calibration Checks E Last month December 0 Last quarter 2013 04 Excess Emissions CEMS Downtime l 0 One day Alarms 1 7 2014 Z D Several consecutive daps From 1 6 2014 a an ars ta z204 ll Select All Deselect All O Only show failed cals Audits CG4 Linearity Settings Options Order by datetime Only show most recent cals for each parameter Online Cals Offline Cals Save As Preview Pririt Close Order by parameter ka l L Gas Cylinder Information Here is an example of a calibration check report Unit 4 Calibration Checks Demo Facility Cal Checks for 10 8 2013 Analyzer Test Reference Measured Allowable Instrument Date Time Parameter Scale Level Value Value Actual Dn Drift Span Results 10 8 2013 6 18 AM 60 NOs ppm Single Zero 0 00 ppm 0 08 ppm 0 08 ppm 15 ppm 300 ppm Unit online Passed 10 8 2013 6 18 AM 60 NO x ppm Single Span 1668 80 pom 160 74 ppm 2 16 ppm 215 ppm 300 ppm Unit online Passed 10 8 2013 6 18 AM T5 NOx ppm Single Zero 0 00 ppm 0 08 ppm 0 05 ppm 15 ppm 300 ppm Unit online Passed 10 8 2013 6 18 AM F5 NHOs ppm Single Mid 168 90 ppm 166 74 ppm 2 16 ppm 215 ppm 300 ppm Unit online Passed 10 8 2013 6 18 AM 60 Stack S02 High Zero 0 00 ppm 0 13 ppm 0 13 ppm 50 ppm 1000 ppm Unit online Passed ppm
150. point lb sec 2 5 10 1 2014 11 58 AM DB Gas Flow Online Setpoint hscfihr 33 10 1 2014 11 58 AM NH3 Flow Online Setpoint Ibir 44 10 1 2014 11 58 AM Turbine 2 Online Settings CT Gas Flow Online Setpoint lb sec 29 10 1 2014 11 58 AM DB Gas Flow Online Setpoint hscfihr 29 10 1 2014 11 58 AM NH3 Flow Online Setpoint lb hr 30 10 1 2014 11 59 AM 104 Chapter 3 Report Generator Include date time of last setting change When this box is checked the report includes the date and time the setting was most recently changed 105 Cedar User Manual Report Comments Users can optionally enter comments that appear on the bottom of a report To enable this feature click the Tools gt Options menu in the main Report Generator window Select the General tab and check the Allow me to enter a comment for each report box When this feature is enabled a window appears when the Print or Preview buttons are clicked Report Comment RATA from 08 31 to 14 15 7 Clear Bold talic Don t ask me for a comment again OK No Comment Cancel Enter a comment and click OK Here is an example of a comment on a report Comment RATA from 08 31 to 14 19 To create the report with no comment click the OK No Comment button To disable the comment feature click the Don t ask me for a comment again box Or disable it in the General tab in the Options window 106 Chapter 3 Report Generator Auto
151. port Click Print to print a report A progress bar appears while Cedar prepares the data and generates the report file Your PDF viewer application opens and prints the report The Print button sends the report to your default printer If you want to print to a different printer click the Preview button Once the report appears in your PDF viewer application use its print feature to choose a different printer Saving a Report The Save As option is useful for exporting data to Microsoft Excel or emailing a report in PDF format Click the Save As button The Save Report As window appears 66 Chapter 3 Report Generator Save Report As File Format Adobe Acrobat LComma separated values csv Filename to save az LC CedarsHourly Data pot Browse Open file after saving Cancel Select a file format Most reports can either be saved as PDF Adobe Acrobat or CSV Comma Separated Values Audit reports can also be saved as an Excel spreadsheet if Microsoft Excel is installed on the computer e PDF is useful for viewing printing and emailing reports e CSV is useful for importing data into a spreadsheet such as Microsoft Excel for further analysis Select a location to save the report Use the Browse button to choose a folder and filename If the Open file after saving box is checked the report will open in the associated application after it has been saved 67 Cedar User Manual Hourl
152. ports for several types of data F CeDAR Reports File Tools Help Hourly 1 Hour Data 1 Minute Data Operation Status 0 Audits Saved Lists Parameters Demo Facility Monthly Facility Daily Total Mass Emissions Report 1 Hour Data Turbine 1 Daily 400FR 5 Emissions Report 1 Hour Data Peliisnsiters Case ee Turbine 1 Daily 400FR 5 Operations Report 1 Hour Data Turbine 1 Daily Bypass Emissions Report 1 Hour Data at Turbine 1 Daily HRSG Emissions Report 1 Hour Data ia aL cl Turbine 1 Daily Operations Report 1 Hour Data Turbine 1 Daily Total Mass Emissions Report 1 Hour Datal Sa Turbine 2 Daily 40CFA75 Emissions Report 1 Hour Data Turbine 2 Daily 400FR 5 Operations Report 1 Hour Data Turbine 2 Daily Bypass Emissions Report 1 Hour Data Turbine 2 Daily HRSG Emissions Report 1 Hour O ataj Audits Turbine 2 Daily Operations Report 1 Hour Data a Turbine 2 Daily Total Mass Emissions Report 1 Hour Data CGA Linearity Turbine 3 Daily 40CFR75 Emissions Report 1 Hour Data Settings Rename Delete Alarms Portrait From 1 8 201412 00AM Landscape To 1872014 9 20 AM ye E Only print summary values Show valid non zero monitor codes Save As Preview Pririt Close 1 Hour Data and 1 Minute Data These reports provide the 1 hour and 1 minute data available in Cedar Operation Status Operation status reports are based on the monitor codes of 1 minute data
153. ports will run under an account that has a typical profile not a built in account Both Adobe Reader and Foxit Reader may be installed if desired Command line for sending auto reports via email Cedar uses this command line to send automatic reports via email The Default button provides the typical command line that Cedar uses Several items must be configured before the command line will work such as the SMTP mail server account name if any password if any and TCP port The Test button attempts to send a sample email to check whether the command line and mail server are configured correctly Contact CiSCO software support if you need assistance configuring this command line 153 Cedar User Manual Calibration Checks 154 These options apply to calibration check reports General Facility Info Data Validity Auto Reports Calibration Checks Excess Emissions and CEMS Downtimes Print signature line 7 on calibration check reports Description Supervisor signature L Print signature line 2 on calibration check reports Description i Also show drift as a percentage of instrument span show percentage of upscale reference value URW for Pe CEM Highlight duplicate calibration records Cancel Print signature line 1 on calibration check reports This option prints a signature line at the bottom of the calibration check report The description is printed below the signature line This feat
154. r individual test 101 Cedar User Manual Opacity Calibration Error Test Reports 102 Calibration Error Tests for opacity monitors are similar to linearity checks Calibration error tests for opacity monitors are specified in 40 CFR 60 Appendix B Performance Specification 1 The test may have 3 4 or 5 runs for each of 3 reference filters for a total of 9 12 or 15 runs Chapter 3 Report Generator CGT and Calibration Drift Test Reports Canada Cylinder Gas Tests CGTs and Calibration Drift Tests are similar to linearity checks Quarterly CGTs For a Cylinder Gas Test CGT the test reason must be QA Environment Canada regulations require CGTs to be performed each quarter CGTs are specified in Report EPS 1 RG 7 Revised section 6 3 1 Calibration Drift Test for CEMS certification For a Calibration Drift Test the test reason must be Certification The Certification test reason indicates the test is a Calibration Drift Test and Cedar will use the appropriate equations and pass fail criteria CGTs and Calibration Drift Tests use different equations and pass fail criteria Environment Canada regulations require daily Calibration Drift Tests during the 168 hour Operational Test Period for CEMS certification A Calibration Drift Test involves 3 injections of 3 gases for a total of 9 injections Calibration Drift Tests are specified in Report EPS 1 RG 7 Revised section 5 3 2 103 Cedar User Manual Sett
155. r Data Editor and click File gt Security Setup gt Permissions The Permissions menu item is disabled when advanced Cedar security is not enabled Use the Accounts window to enable advanced Cedar security and then the Permissions window will be enabled The Permissions window may take a minute to appear while it loads the Cedar configuration The Permissions window lists many operations that can change data or settings within Cedar You can configure the minimum privilege level required for these operations Settings The minimum privilege level can be set for each individual setting Advanced CeDAR Security Permissions settings Data Monitor Data Editor Reports Right click to change Facility Fuel Constants Nat GLY Gas Btursct Low Fail Lirit Level 3 Nat GCY Gas Btursct High Fail Lirit Level 1 or higher Nat GLY Gas Btursct Default Value Level 3 Fd Factor Gas dectmmBty Level 3 Gas Density lb sct Level 3 NH3 in aqueous solution Level 3 Turbine 1 Online Settings CT Gas Flow Online Setpoint lb sec Level 3 DB Gas Flow Online Setpoint hact hr Level 3 NH3 Flow Online Setpoint Ibhr Level 3 Turbine 1 CG4 Linearty Ref Values HRSG NOe L CGA Low Ret Value Level 3 HRSG NOL CGA Mid Ret Value Level 3 HRSG N s H Linearity Low Ref Value Level 3 HRSG NOH Linearity Mid Ret Value Level 3 Set all to Level 0 or Set all to Level 1 or Set all to Level 2 or Cot all to Level 3 higher higher higher pee Reon he ca C
156. r a unit exceeded an emission limit Warning Warning alarms indicate abnormal or undesirable conditions or that the user may need to take action to prevent a potential problem For example a value may be above an alarm setpoint Info Info alarms simply inform the user For example the daily automatic database backup completed successfully Log only Log only alarms are for diagnostic purposes and do not appear in the alarm displays or reports 12 Chapter 1 Introduction To Cedar Cedar5 ini File The Cedar5d ini file contains basic information that Cedar needs to operate such as folder paths and database connection strings This file is usually located in C Program Files x86 Ciscocems Cedar5 This file is configured when Cedar is installed and is rarely modified Below are some of the entries in the INI file Sitel D This entry identifies the Cedar configuration This is typically the name of the site Facilities with multiple DAHS computers will have multiple configurations each with a different Site ID The Site ID is limited to 10 characters DahsComputerName This is the name of the DAHS computer Cedar uses this name to determine whether an application is running on the DAHS or a remote computer DahsDescription This entry is optional and can provide a description of the DAHS Database connection strings Cedar uses the database connection strings to connect to the Cedar databases A full discussion of connectio
157. r importing data into spreadsheet applications such as Microsoft Excel To save the auto report as a CSV file in a folder select the auto report and click i The Edit Destination window appears 111 Cedar User Manual I Edit Destina Falder LC Cedar4uto Reports B c Acer ca Auto Reports Cancel Choose a folder and click OK The new CSV folder destination appears under the auto report Auto Reports al zlo sl B wel x Unit 4 Daily Emissions Report i default printer Add PDF Email Destination For auto report emails to work email settings must be configured in the Report Generator Options window To send the auto report as a PDF email attachment select the auto report and click Bl The Edit Destination window appears 112 Chapter 3 Report Generator I Edit Destinatia E mall address es user example com Useretoexample com Cancel Enter email addresses for the recipients and click OK The new PDF email destination appears under the auto report Auto Heports Al zlo o BBS x i Unit 4 Daily Emissions Report default printer ag HP Lasenet 1320 ae CCedar4uto Reports m C 4 Cedar4uto Reports User example com userMexample com Add CSV Email Destination For auto report emails to work email settings must be configured in the Report Generator Options window To send the auto report as a CSV email attachment select the a
158. rted when the DAS reboots or when a new version of Cedar is installed lf the alarms are still active the alarms will reappear Chapter 2 Data Monitor Data Monitor Facility Specific Windows Facility specific windows are customized for your facility EJ Turbine 1 HRSG Emissions o amp ss 1 Hr 24 Hr Rolling Rolling 10 Second Previous Minute Current Hour Previous Hour Limit 3 Hr CU Limit Process Status Normal Mormal Mormal Mormal Dz 14 25 14 25 Valid 14 32 Valid 14 36 Yalid NOx ppm 6 45 5 02 Walid 6 08 Walid 6 02 Walid NOx ppm 15 02 Irz 5 15 Valid 5 45 9 Valid 5 43 Valid NOs Ib mmEtu 0 0210 0 0189 Valid 0 0200 Valid O 0200 Valid NOx bhr 4 70 ofl Walid 3 20 Walid 3 22 Walid CO ppm B12 6 62 Walid 5 94 Valid 5 56 Walid CO ppm 154 02 5 43 5 86 Valid 4 97 Valid 5 02 Walid CO Ib mmEtu 0 0121 0 031 Valid 0 0111 Walid 0 0112 Valid CO Ib hr 5 55 6 04 Walid 5 11 Valid 5 16 Walid NH3 Slip ppm 3 70 10 86 Walid 5 934 Walid r J6 Walid NHS Slip ppm 15 2 02 2 6 3 6 Valid 8 0 Valid fe Walid NH3 Slip IbAramBtu 0 0117 0 0131 Walid 0 0103 Walid 0 0035 Walid NH3 Slip lbhr 5 40 6 04 Walid 30 Walid 452 Walid Facility specific windows are available from the View menu File View Giant Numbers Trends Bar Graphs Alarms Calibrations Turbine 1 HRSG Emissions Turbine 1 Bypass Emissions Turbine 1 Operations Turbine 2 HRSG Emissions Turbine 2 Bypass Emissions Turbine 2 Operations Turbine 3 HRSG Emissions Tur
159. s Perform calibration checks at 06 48 Abl Skip the daily cal check if the unit i offline at this time Skip the daily cal check if an online cal check has already run during the day Calibration Checks At Unit Startup Do not automatically perform cal checks for unit startup Leal Perform a cal check BU minutes after the unit begins running 0 Perform a cal check 60 ES minutes atter the unit enters normal operation Do NOT run a unit startup cal check if an online cal check has already occured during the day 40CFAR 75 CEMS Using Offline Cal Checks for Data Yalidation Make sure that an online cal check runs at least every 26 unit operating 5 hours run addtional cal checks as needed Selecting the daily cal start time is the most important aspect of this configuration e Set the daily cal start time at a convenient time when the unit is usually in normal operation The additional options below are useful for instances when the unit deviates from its typical operating schedule 41 Cedar User Manual e Check the box for Skip the daily cal check if the unit is offline at this time e Select either Perform a cal check x minutes after the unit begins running or Perform a cal check x minutes after the unit enters normal operation e Check the box for Do NOT run a unit startup cal check if an online cal check has already occurred during the day e Ifthe CEMS is subject to Part 75
160. s are selected Click the Refresh button The Alarm Log will display information for each alarm indicating the time an alarm came on when the alarm was cleared and when the alarm was acknowledged for the time range you selected Alarm Log o eE Date Time Range Severity Categories Units From 2 7 2014 M Serious CEMS COMM DAS RA To 2 7 2014 11 59 00 PM Waming LIMIT BACKUP SECURITY Turbine 2 Info STATUS CONFIG Category Acknowledgment Info Serious CEMS Turbine 1 HRSG Auto Daily Cals Disabled 227 2014 9 10 33 PM 2 7 2014 9 14 54 PM 163 Cedar User Manual View Calibration Checks 164 Calibration checks can be viewed from within the Database Editor without having to print a calibration checks report In the Data Editor menu click Edit View Data gt View Calibration Checks A blank Calibration Checks window opens Calibration Checks Refresh Select Cals Make duplicate calibration checks bold No Calibration Checks Click the Select Cals button The Select Cal Data window opens Select Cal Data From 2 1 20141200AM a To 2 2014 11 59PM Parameter all Z In Last Hours S E Most Recent limited to last 14 days The following options are available e Enter the time frame you wish to view Also select specific parameters from the pull down menu or view all parameters e View Parameters in the last 1 72 hours e View most r
161. s for the same day Cedar will use the latest file DA Note l Do not unzip the backup files The restore operation will unzip the files to get the necessary data e Select the day s to backup e Select the data to be restored For help choosing the tables see the section that describes the data that is stored in each table e Check the Faster Speed box to allow the restore operation to complete as quickly as possible In some cases restoring many days of data may interfere with the Cedar Data Recorder and prevent it from recording data while the restore operation is in progress e Click the Start button 212 Chapter 5 Database Backup amp Utility Warning AN Existing data for the selected day s will be deleted and replaced with data from the backup file A window displays the status of the restore operation A message box appears when the operation is complete Security and permissions A restore operation will fail if the user does not have permissions The user must have the CedarBackupRestore CedarDataReader and CedarDataWriter database roles in basic Cedar security Alternatively the user may have administrator or database owner permissions for the Cedar databases 213 Cedar User Manual Restore Configuration The Cedar Backup application allows you to restore the Cedar configuration that was in use on a specific date GS CeDAR Backup TESTSITE Backup Databases Restore Data Restore Confi
162. sage box notifies you that the substitution operation may take some time A progress window displays the status of the operation A message box notifies you when the operation is complete The message box indicates the number of data points changed and the time it took to complete the operation Note O After data points have been modified excess emissions data may need to be rebuilt recalculated if permit limits apply to the data that was substituted 179 Cedar User Manual Rebuild Data Points This tool allows some calculated data to be rebuilt recalculated from underlying data For example 1 hour data may need to be rebuilt recalculated from 1 minute data Or 1 hour data such as NOx lbs may need to be recalculated from underlying 1 hour data Caution This tool can make irreversible changes to data Not all data can be recalculated with this tool If you have any questions about the appropriate use of this tool please contact CiSCO software support In the Data Editor menu click Edit View Data gt Rebuild Data Points The window may take a minute to appear while it loads the Cedar configuration The Rebuild Data Points window appears D roo oma con TT From 42272014 m To 4 22 2014 11 59 PM am Farameters Process Code 1 Hr W HASG 60 NO ppm 1 Hr w Bypass 60 NOs ppm 1 Hr W SCA NOs ppm 1 Hr w HRSG CO ppr 1 Hr w Bypass CO ppm 1 Hr W HASG 60 022 1 Hr v HRSG 75 02 1 Hr Deselect Belo
163. sappears from the list and is permanently deleted when you click OK Click Cancel to exit this window without deleting any bar graph windows 33 Cedar User Manual Data Monitor Calibration Checks Window In this window you can view recent CEMS calibration checks In the Data Monitor main window menu click View gt Calibrations The Calibration Checks window appears i C Most Recent Cal Checks o E eE Select Cals Make duplicate calibration checks bold Parameter Range GasLevel Date Time Reference Measured Drift Allowable Drift Instrument Span Results Turbine 1 40CFRE0 Y Bypass 60 NOx ppm High Zero 12 20 2013 12 00 AM 0 ppm 0 05 ppm 0 05 ppm 10 ppm 200 ppm Passed Y Bypass 60 NOx ppm High Span 12 20 2013 12 00 AM 180 6 ppm 179 96 ppm 0 64 ppm 10 ppm 200 ppm Passed Y Bypass 60 NOx ppm Low Zero 12 20 2013 12 00 AM 0 ppm 0 05 ppm 0 05 ppm 1 ppm 10 ppm Passed Y Bypass 60 NOx ppm Low Span 12 20 2013 12 00 AM 39 89ppm 10 01 ppm O12 ppm 1 ppm 10 ppm Passed 40CFR75 Y Bypass 75 NOx ppm High Zero 12 20 2013 12 00 AM 0 ppm 0 05 ppm 0 05 ppm 10 ppm 200 ppm Passed Y Bypass 75 NOx ppm High Span 12 20 2013 12 00 AM 180 6 ppm 179 96 ppm 0 64 ppm 10 ppm 200 ppm Passed Y Bypass 75 NOx ppm Low Zero 12 20 2013 12 00 AM 0 ppm 0 05 ppm 0 05 ppm 5 ppm 10 ppm Passed Y Bypass 75 NOx ppm Low Span 12 20 2013 12 00 AM 39 89ppm 10 01 ppm 0 12 ppm 5 ppm 10ppm Passed Select Cals Click the Sele
164. ssions and CEMS Downtimes General Facility Info Data Validity Auto Reports Auto daily reports run at HH 28 every day HH 2 can be 2 15 Seconds to wait between processing each auto report 10 Command line for printing auto reports Default Defaut 2 CNProgram Files 86 F ost Software Fost ReadernF oxit Reader ene ft FILENAMES SPRINTER S Command line for sending auto reports via email Default Test a Automatic daily report hour Automatic daily reports run every day at 28 minutes after the hour The hour HH can be between 2 and 15 Seconds to wait between processing each auto report When automatic reports are being generated Cedar waits this amount of time between each report The default is 10 seconds A longer delay may be necessary for some printers Command line for printing auto reports Cedar uses this command line to print automatic reports One default is for Foxit Reader and the other default is for Adobe Reader Select the appropriate default for the reader that will be used to print automatic reports Chapter 3 Report Generator Note A Adobe Reader does not function properly under the built in special accounts such as Network Service Local Service and Local system Foxit Reader is required on the DAS if auto reports will be printed from one of the built in accounts Foxit Reader is available from www foxitsoftware com Adobe Reader may be used if automatic re
165. swatons aot psieainte id N aa eaunducbaaeutansiecees 4 Montor CodeS uian sine sid E T E Selassie edna A A ERR 5 Process Codes iueesiurini aa E aA 10 Ad M C alCOOES aiaa eee ee ent eee eee eee 11 Alarm Severity Levels sciczctstideoet Sieseeeeide a aaa e sides ae laeen 12 CG aA FS te tutratate E as haa ate lather ca ih etait atc 13 Historical Data Retrieval HDR cccccceccsecceeeeeeceeseeeceeceeeseeceeeseeseeeaeesaes 15 Chapter 2 Data Monitor oaicsseceinerepacatacseacinetecsccdetee ccna eetoneeci viel taanacrieceecnetons 17 Data MOMO AIAN S orner a e a inne usadteswaeanneniae 18 Data Monitor Facility Specific WiNdOWS cccccceecceeceeeceeceeeeeeceeeeeeeeeeaeenees 21 Data Monitor Giant Numbers cccccecc eee eeeeeceeeeeseeeeeseeeeeceeteeteeeneseeeeeeees 22 Da ta Monitor Trend S ivprsiresariar ree eae EET EEEa 25 Data Monitor Bar GraphS o nenonennensnnnnensnsrnnrerrrrnrsrrrrrrsrrnrernrerrrrererrrrersrrrrne 29 Data Monitor Calibration Checks WINdOW cccccceecseceeeeeeeeeeeeeeeeesseeeeeees 34 Auto Calibration Checks nonnnnennnnnnsnsnnnrerersrrnrerrrrnrsrrnrnrsrrrrernrerrnrnrerrnrerns 36 Auto Calibration Checks Suggested Configurations cccceceeeeeeceeeeeeees 40 Data Validation for 40 CFR 75 Calibration CNeCKS ccccceceeeeeeeeeeeeeeeeees 44 Data Monitor SEMINGS sieslose5 ce eset ie Seid cect once ies e aa eles wees 46 Data MONILOF VQAUdIUNO cesas ian a
166. t 4 Daily Emissions Report ag default printer Add Printer Destination To send the auto report to a printer select the auto report and click The Edit Destination window appears 109 Cedar User Manual ae Printer HF Laserlet 1320 eA Select the printer and click OK The new printer destination appears under the auto report Auto Reports Al zlo s DAAH x i Unit 4 Daily Emissions Report default printer meee FHP Laseret 1320 Note A Do not select the default printer if auto reports will be printed from the built in Network Service or Local Service accounts The default printer for these accounts is often a virtual printer such as an XPS document writer Select a specific printer instead of the default printer The Local System account uses the default printer that is defined for all users Add PDF Folder Destination To save the auto report as a PDF file in a folder select the auto report and click Bl The Edit Destination window appears 110 Chapter 3 Report Generator I Edit Destina Falder LC Cedar4uto Reports B c Acer ca Auto Reports Cancel Choose a folder and click OK The new PDF folder destination appears under the auto report Auto Reports a 28 oD le x I Urit 4 Daily Emissions Report l seen 8 default printer HP Lasenet 1320 C Cedar auto Reports Add CSV Folder Destination CSV files are useful fo
167. t a copy of the hourly data daily QA checks other QA checks and configuration data for an entire quarter e Check the extract minute data box to extract 1 minute data for a selected day or days Typically 1 minute data is only needed for quarters with a RATA If a RATA was performed during the quarter select the day s when the RATA was run This option generates a separate zip file for the 1 minute data The resulting file can be very large even with compression If one file is too large you can perform the extraction several times with shorter time periods to create multiple smaller files e Click the Extract button 217 Cedar User Manual A window displays the status of the extract operation A message box appears when the operation is complete The compressed file with the extracted data is placed in a the ExtractForDownloaad folder This folder is typically C Cedar5 ExtractForDownload The actual folder is determined by the Cedar 5 ini file 218 Chapter 5 Database Backup amp Utility Merge Data The Cedar Database Utility allows you to take data that was previously extracted from Cedar databases and import it into Cedar databases CF CeDAR Database Utility TESTSITE Extract Data For Quarter From 2014 5 1 00 00 00 To 2014 5 31 23 59 59 Source File C Cedard EdtractedData TESTSITE_2014501 A Data in the selected table s for the specified time period willbe REPLACED by the data in the s
168. t to each calibration check indicates the pass fail result and online offline status The date and time for offline calibration checks has a gray background 203 Cedar User Manual Click on a the date and time of a calibration check to see the data in the fields next to the list The Summary box indicates whether the CEMS passed the 7 day calibration error test based on the calibration checks in the date range If necessary select the Setup tab modify the date range or other options and then select the Results tab again The results are updated to reflect the new selections 7 Day Drift Setup Results 107 872013 06 18 Boller 3 5 H 0x ppm 10 9 2073 06 18 Calibration Time 10 8 2013 06 18 Passed 10 10 2013 06 18 10 11 2013 06 18 Instrument Span 300 OrLine 10 12 2013 06 18 Zero Gas 10 19 2013 15 18 Reference 0 10 20 2013 PEE TE s Wamms p T Le 75 v 10 20 2013 15 29 Span Gas 1072172013 06 185 Reference 165 9 Wleasured 166 74 Drift 2 16 Lirit 5 Summary The Day Dott Test has been passed W Pass On Line do Pass Off Line x Fail On Line 2 Fall Off Line M Preview Report After Saving Close Save Results The Save button is only enabled when the Results tab is selected Click Save to save the results to a PDF file If the Preview Report After Saving box is checked the report will open in a PDF reader 204 Chapter 4 Data Editor Demo Facility 7 Day Drift Test Boiler 3 75
169. tor Backup Utility Database Utility Cedar I O Service Cedar Data Recorder Service Description Displays real time data alarms and graphs Allows users to view and edit data Provides many utility functions Allows users to create view print and save reports Allows users to backup and restore data This utility runs only on the DAS and is not available on remote computers Allows users to extract copy and merge data This utility runs only on the DAS and is not available on remote computers Collects real time data from the CEMS and other devices Runs as a Windows service on the DAS This service must be running for Cedar to collect data Performs calculations on data and stores the data in the databases Runs as a Windows service on the DAS This service must be running for Cedar to collect data By default the Data Recorder Service runs under the Network Service account and the Cedar I O Service runs under the Local Service account The services can be configured to run under other accounts Microsoft SQL Server is installed on the DAS computer The SQL Server service must be running for Cedar to collect data Chapter 1 Introduction To Cedar Cedar Databases Cedar uses Microsoft SQL Server as its database platform Cedar defines five databases in SQL Server Database Description Cedar5Alarms Stores alarm data Cedar5Config Stores user settings and the facility specific configuration
170. tored in each table Constants The Constants table stores constants and similar data that has a constant value for a defined period of time DataPoints Long Term The long term DataPoints table stores data points that must be retained for a long period of time several years This typically includes 1 hour averages longer averages and 3 minute and 6 minute opacity QADaily The QADaily table stores data for daily QA checks such as calibration checks QATests The QATests table stores data for QA tests that are performed on a less frequent basis This includes CGAs and linearity checks DataPoints Short Term This table stores data that does not have to be retained for a long period of time This typically includes 1 minute averages lOAuditData The lIOAuditData table stores data for I O audits For more information see the sections on starting and stopping I O audits and generating reports for I O audit data ConfigData The ConfigData table stores facility specific configuration data UserConfigData The UserConfigData table stores user settings Alarms The Alarms table stores alarm data Realtime The Realtime tables store current data and history Realtime data can be purged Chapter 5 Database Backup amp Utility Daily Automatic Backup Cedar performs an automatic backup every night at approximately 3 00 AM Cedar backs up the data for the previous day Cedar also backs up days for which data has been
171. uirements or exemptions All process codes except 08 and 13 may be redefined for facility specific requirements 10 Chapter 1 Introduction To Cedar Alarm Categories Cedar supports several alarm categories Category Description CEMS Are related to emission monitoring equipment Limit Are usually related to emission limits defined by the source s permit Status Are usually informational status messages Communication or Are related to communication failures Comm Backup Are related to automatic daily database backup Config Are related to user settings DAS Are related to conditions that may affect how the DAS operates Security Indicate changes to security settings within Cedar CEMS alarms e Serious alarms alert you to conditions that may cause invalid data such as a Calibration check failure e Warning alarms alert you to other abnormal CEMS conditions including CEMS maintenance e Info alarms display other informational messages such as whether a unit is online or a calibration check is in progress Limit alarms e Serious alarms indicate that a permit limit has been exceeded e Warning alarms indicate that the unit could exceed a permit limit 11 Cedar User Manual Alarm Severity Levels Cedar alarms may have the following severity levels Severity Description Serious Serious alarms Indicate a condition where a user probably needs to take action For example an analyzer failed a calibration check o
172. umn Title ND lbs 1 Hr Sue ele HMOs Ibs 24 Hr Total Width points 55 Total 256 width 540 NOx Ibs 24 Hr Avg Al NOx lbs ear to Day Total es a NOx tons Year to Date Total F Display a line after this column NOs Ibs 365 Dap Rolling Total lt Back Next gt Cancel The parameters you chose have been added to the list of columns in the upper half of the window Use the Move buttons to move the highlighted column left or right Use the Delete button to remove the highlighted column from your report 131 Cedar User Manual 132 The lower half of the window allows you to configure the currently selected column You can change the column title width and alignment of the data If the column title is too long for the column width the title will automatically wrap To control where the title breaks to another line insert a pipe character where you want the title to wrap The pipe character is on the backslash key on the keyboard The window displays the total width of all columns and the maximum total width The current total updates as you change column widths and add columns If the total width of all columns exceeds the maximum the text turns red as in this example Current Column Tithe Stack Flow swichhr Width points 55 Total 576 width 540 Alignment Decimal Select Display a line after this column to put a vertical line to the right of the column This can help to visua
173. unication alarms The colors can be changed in the Options window Active Alarm Count The status bar in the lower left corner of the main Data Monitor window displays the number of alarms that are currently active In this example the Data Monitor shows 4 Active Alarms Stack Auto Cal Waning Low Tri Blend C Acknowledge f CEMS Acknowledge 2 CEMS a 4 Actyve Alarms 19 Cedar User Manual Audible Sound The Data Monitor can play a sound when there is an unacknowledged serious or warning alarm The computer must have audio capability and the audio must not be muted The sound can be configured in the Options window Alarm Acknowledgement with Multiple Users or Computers By default alarm acknowledgement is specific to each user account If multiple users are running the Data Monitor using different user accounts then each user must acknowledge alarms If one user acknowledges an alarm that alarm is not acknowledged for the other users If multiple users run the Data Monitor using the same account then an alarm acknowledgement is effective for all users sharing that account If you prefer that an acknowledgement by any user should acknowledge the alarm for all users please contact CiSCO to modify your Cedar configuration Cedar Data Recorder Service Restart 20 If the Cedar Data Recorder service is stopped and restarted all active alarms are deactivated The service may be stopped and resta
174. ure is useful for facilities that require a supervisor to sign off on a daily calibration check report Print signature line 2 on calibration check reports This option prints a second signature line on each calibration check report The description is printed below the signature line Also show drift as percentage of instrument span When this option is selected calibration check reports also display the drift as a percentage of instrument span For a PM CEMS the drift percentage is based on the upscale reference value URV The drift percentage is highlighted in this example Date Time 10 2 2013 6 18 AM Chapter 3 Report Generator Unit 4 Calibration Checks Demo Facility Cal Checks for 10 2 2013 Analyzer Test Reference Measured Allowable Parameter Scale Level Value Value Actual Drift Drift 60 NOx ppm Single Zeno 0 00 ppm 0 08 ppm Highlight duplicate calibration records When this option is selected any duplicate calibration records are highlighted on the report This can be useful for diagnosing uncommon situations involving duplicate calibration data 155 Cedar User Manual Excess Emissions and CEMS Downtimes 156 These options apply to excess emissions and CEMS downtimes reports General Facility Info Data Validity Auto Reports Calibration Checks Excess Emissions and CEMS Downtimes F When combining adjacent teme start a new line at midnight detail reports only q Print times when excess emissi
175. ut missing data substitution may need to be performed again especially if data is changed or edited In the Data Editor menu click Edit View Data gt Substitute Invalid Data Points The window may take a minute to appear while it loads the Cedar configuration The Substitute Invalid Data Points window opens 5 2 2014 10 00 AM 5 4 2014 3 59 PM Unit Combined Mill a Parameters Substitute Number of Compartments Operating 1 Hr c elect ll w Substitute WO ppr W Substitute SOs ppm W Substitute CO ppm w Substitute C02 2 W Substitute Stack Flow Per Compartment wect hr 1 Hr w Rebuild Stack Flow After Substitutions 4 Rebuild NOx lbs After Substitutions Deselect Below w Rebuild SOs lbs After Substitutions w Rebuild CO lbs After Substitutions is cowelernenbers w Rebuild COZ lbs After Substitutions Enter the time frame to rebuild Select a unit from the pull down menu Deselect All Deselect Shove The list displays the available parameters for the selected unit The parameter list is blank unless this feature is configured for your facility Select the parameters you wish to edit Select individual parameters by checking the box next to the parameter name The Select All Deselect All Deselect Above and Deselect Below buttons are also available 178 Chapter 4 Data Editor The Show PID Numbers box is used by CiSCO support personnel to display the internal parameter IDs Click the Substitute button A mes
176. uto report and click H The Edit Destination window appears Edit Destination E mall address es user example com Useretoexample com Cancel Enter email addresses for the recipients and click OK 113 Cedar User Manual The new CSV email destination appears under the auto report Auto Reports Al l0 s Daan x Unit d Daily Emissions Report a 36 default printer i HP Lasenlet 1320 ss F C Cedarv4uto Reports C CedarAuto Reports sesso eq user example com user texample com at user example com user example com Edit Report Destination To change a printer file or email destination click on the destination and click 4 A window will appear to edit the destination properties Remove Report Destination To remove a report destination a printer folder or email destination click on the destination and click x Be sure to click on the destination and not on the report Disable Enable Auto Report To disable an auto report without removing it from the list select the auto report and click aj When an auto report is disabled it appears with a red X and gray text Auto Reports Al 4 8 ol BBS x i Urit 4 Daily Emissions Report fa HF Lasenet 1320 bo C Cedar4uto Reports Bene User example com user example com Remove Auto Report To completely remove an auto report select the auto report and click z 114 Chapter 3 Report Generat
177. venient time when the unit is usually in normal operation Uncheck the box for Skip the daily cal check if the unit is offline at this time Uncheck the box for Skip the daily cal check if an online cal check has already run during the day Select either Do not automatically perform cal checks for unit startup Uncheck the box for Do NOT run a unit startup cal check if an online cal check has already occurred during the day Uncheck the 40CFR75 CEMS Using Offline Cal Checks For Data Validation box 43 Cedar User Manual Data Validation for 40 CFR 75 Calibration Checks 44 Online calibration checks Part 75 generally requires that calibration checks are performed when the unit is online Offline calibration checks cannot be used to validate data unless the CEMS has passed an offline calibration demonstration Prospective data validation When the CEMS passes a calibration check the data is prospectively validated for the next 26 clock hours The hour in which the calibration completes is considered the first hour of the 26 hour period After 26 hours the validation period expires and the data is invalid until another calibration check is passed Calibration check failure When a CEMS fails a calibration check the CEMS is out of control from that time forward and the data is invalid When the CEMS passes a calibration check it is in control again and the data is valid with respect to the calibration check r
178. w w Bupass 60 02 1 Hr Bupass 75 02 02 1 Hr W CT Gas Flow lIb zec 1 Hr W CT Gas On Time 1 Hr w DE Gas Flow hact hr 1 Hr w DE Gas On Time 1 Hr w Turbine On Time 1 Hr Select All Deselect All Deselect Shove Show PID numbers Overarite all values and monitor codes Taa Enter the time frame to rebuild Select a unit from the pull down menu The list displays the available parameters for the selected unit 180 Chapter 4 Data Editor Select the parameters you wish to edit Select individual parameters by checking the box next to the parameter name The Select All Deselect All Deselect Above and Deselect Below buttons are also available The Show PID Numbers box is used by CiSCO support personnel to display the internal parameter IDs Caution A Existing data that has already been edited may be overwritten with the recalculated data For example if some data points were originally valid and you have edited them to be invalid rebuilding that data will probably make the data valid again To force edited invalid data to remain invalid use monitor code 59 See additional notes below Check the Overwrite all values and monitor codes box to force all data points to be rebuilt in this operation When this box is not checked certain data points are not rebuilt Note rebuilt 36 38 39 59 Note D When the Overwrite all values and monitor codes box is not
179. without valid justification violates environmental regulations Chapter 1 Introduction To Cedar Monitor Codes Monitor Codes indicate the validity of a data point Every monitor code is in one of these three categories e Valid the unit or process is operating and the data is valid e Invalid the unit or process is operating and the data is not valid e Offline the unit or process is not operating Cedar Monitor Codes Monitor Code Description 00 Normal 11 Pollutant analyzer out of control 12 Diluent analyzer out of control 13 Process offline 14 Calibration check 15 Preventative maintenance 16 Pollutant analyzer malfunction 17 Diluent ancillary analyzer malfunction 18 DAHS malfunction also used as the default monitor code for invalid values 19 Sample handling system malfunction dryer fault etc 20 Corrective maintenance 21 Other 22 I O communications problem 23 Sample point not selected process offline used for Validity Valid Invalid Invalid Offline Invalid Invalid Invalid Invalid Invalid Invalid Invalid Invalid Invalid Offline Cedar User Manual 25 26 2 28 29 30 31 32 33 34 35 36 3 38 39 timeshare systems Backflush Value is calculated or derived from substituted data ODBC data not available data missing in an external database Formula input out of range Calibration check process offline Sample point not selected
180. wledge CEMS Low Single Blend Cylinder Pressure 10 18 21 PM 4 Active Alarms t ACTIVE no ack i ACTIVE ack D Inactive not ack lnachve ack The legend at the bottom of the window indicates the possible alarm status states There are four combinations of active inactive and acknowledged unacknowledged Chapter 2 Data Monitor Acknowledge Alarms Click the Acknowledge link next to an alarm to acknowledge it Alarms disappear after they have been acknowledged and become inactive The alarm window updates approximately twice per minute Optionally all alarms can be acknowledged at once by clicking the Acknowledge button aaa Acknowledge Acknowledge Status Category Acknowledge t CEMS Acknowledge 2 CEMS Turbine 33 Waning Turbine 3 The Acknowledge button can be enabled in the Data Monitor Options window Select the Alarms Acknowledgement page Uncheck the user must acknowledge each alarm individually box Alarm Window Popup The alarm window can automatically pop up when a new alarm becomes active This feature can be enabled or disabled in the Options window Flash Portions of the Data Monitor windows flash when there is a new serious or warning alarm The Data Monitor stops flashing once the new alarm has been acknowledged Info alarms do not need to be acknowledged The flash colors are typically red for serious alarms yellow for warning alarms and magenta for comm
181. xceedence S02 Ibe roimbtu 30 SOD Alg Avg w Monitor Downtime Opacity 6 Min Avg Deselect Abave Select All Select Al Deselect All Deselect All Exceedence Opacity 6 Min Avg Deselect Above Deselect Below Deselect Below Rebuild Rebuild Close ES Enter the time frame to rebuild Select a unit from the pull down menu Show PID numbers The list displays the exceedence and or CEMS downtime parameters for the selected unit Select the parameters you wish to edit Select individual parameters by checking the box next to the parameter name The Select All Deselect All and Invert Selection buttons are also available The Show PID Numbers box is used by CiSCO support personnel to display the internal parameter IDs Chapter 4 Data Editor Click the Rebuild button A message box notifies you that the rebuild operation may take some time A progress window displays the status of the operation A message box notifies you when the operation is complete The message box indicates the number of exceedences and CEMS downtimes that were added and or deleted Note D If the rebuild operation added new exceedences or CEMS downtimes you will need to edit the reason text for the new exceedences or CEMS downtimes 187 Cedar User Manual Edit CGAs and Linearity Checks In the Data Editor menu click Edit View Data gt Edit CGAs and Linearity Checks The window may take a minute to appear while it lo
182. xt CeDAR 5 Report Designer Wizard what do you want to do C Create a new report C Modify an existing report Duplicate an existing report for another unit C Delete an existing report Back Cancel Select Duplicate an existing report for another unit 142 Chapter 3 Report Generator Click Next CeDAR 5 Report Designer Wizard Choose a report to duplicate Turbine 1 Month lt Heat Input F ep ort Select the report to duplicate Click Next CeDAR 5 Report Designer Wizard For every unit number that is referenced in Turbine 1 Monthly Heat Input Report indicate what that unit number should be translated to for the new report Multiple units should be separated by a comma Report Name Unit Numbers Turbine 3 So a a a F Allowable Unit Numbers 1 2 3 8 9 143 Cedar User Manual The original report can be duplicated multiple times by this one screen In this example the original report is for Turbine 1 and will be duplicated for Turbine 2 and Turbine 3 The Allowable Unit Numbers are from the internal Cedar configuration and may not match the actual unit name or number Contact CiSCO software support if you need clarification for the unit numbers Note If you do not change the unit numbers or report name the wizard will make an exact duplicate of the existing report Click Finish 144 Chapter 3 Report Generator Report Wizard Delete Report
183. y When this option is selected the report includes a detail page for each parameter Unit 4 CEMS Downtime Demo Facility Opacity 6 Min Avg CEMS Downtime for 11 1 2013 thru 11 30 2013 Parameter Start End Duration Reason Auction Opacity G Min Avg 11 152013 8 24 AM 10 47 AM i hour 24 minutes Other known causes QA Audit Completed Quarterly Opacity Audit Total duration 1 hour 24 minutes Print excluded CEMS downtimes CEMS downtimes can be marked as excluded in the Cedar Data Editor Excluded items do not appear in this report unless this box is checked Combine adjacent times into one line When this box is checked CEMS downtimes that are immediately adjacent in time are combined into one line on the report This option only applies to detail reports This example shows some CEMS downtimes that are adjacent but on separate lines Unit 4 CEMS Downtime Demo Facility Opacity 6 Min Avg CEMS Downtime for 11 1 2013 thru 11 30 2013 Parameter Start End Duration Reason Opacity 6 Min Avg 11 15V2013 8 24 AM 9 29 AM 6 minutes Other known causes Opacity 6 Min Avg 11152013 8 30 AM 2 35 AM 6 minutes Other known causes Opacity 6 Min Avg 11715 2013 8 36 AM 9 41 AM 6 minutes Other known causes This example shows the same CEMS downtimes combined on one line Unit 4 CEMS Downtime Demo Facility Opacity 6 Min Avg CEMS Downtime for 11 1 2013 thru 11 30 2013 Parameter Start End Duration Reason Opacity 6 Min Avg 11
184. y Service Broker Storage Security Users Uk dbo A quest A INFORMATION_SCHEMA H HEAHEA A TEE W New User Script User as Policies Facets Start PowerShell J CedarSConf g Cedar5Data Cedar5Data Cedar5Realt Reports Select Delete from the menu The Delete Object window appears 240 Chapter 6 Cedar Security X Delete Object gS script Te Help Object to be deleted Object Name Object Type Owner Status Message User SQLEXPRES Connection 3 View connection properties Progress Ready Click OK SSMS deletes the user Repeat the above steps to delete the user from each Cedar database The databases are Cedar5Alarms Cedar5Config Cedar5Data Cedar5DataShortTerm Cedar5Realtime Delete User in Advanced Cedar Security Skip this step if advanced Cedar security is not enabled Active Directory Groups D A user may have access to Cedar because the user is a member of an Active Directory group The group may be assigned to a Cedar privilege level The individual user is not assigned to a Cedar 241 Cedar User Manual privilege level If this is the case delete the user from the Active Directory group and ignore this step Open the Cedar Data Editor In the Cedar Data Editor menu click File gt Security Setup gt Accounts This window appears Advanced CeDAR Security Privilege Level Account Mapping Basic CeDAR security classifies users as read
185. y HASG Emissions Report 1 Hour O ataj Audits Turbine 2 Daily Operations Report 1 Hour Data ee Turbine 2 Daily Total Mass Emissions Report 1 Hour Data CGA Linearity Turbine 3 Daily 40CFR75 Emissions Report 1 Hour Data Settings Rename Delete From 1 87 2014 12 00 AM Excess Emissions Alarms Portrait Landscape To 18 2014 9 20 4M mn E Only print summary values l l E Show valid non zero monitor codes Save As Preview Pririt Close Click Rename to rename a custom list of saved parameters Daily and hourly reports cannot be renamed from this window Options Only print summary values When Only print summary values is checked the report only displays the aggregate average total minimum maximum values The report does not display the detail data Show valid non zero monitor codes When this box is unchecked the default the report only displays monitor codes for data that is invalid or offline The report does not display monitor codes for valid data When this box is checked the report displays monitor codes for valid data except monitor code 00 Monitor Codes This report displays monitor codes in brackets next to the data point 93 Cedar User Manual Turbine 1 Turbine 1 Turbine 1 HRSG 60 NOx HRSG60 NOx HRSG 60 02 Timestamp ppm 1 Min libimmBtu 1 Min 1 Min 12320 7 26 2 20 0 0069 14 00 1220 7 27 2 19 0 0069 14 01 1320 7 28 2 19 0 0069 14 00 12320 7 29 2
186. y Reports An hourly report displays data for one hour Hourly reports typically display 1 minute detail data and 1 hour aggregate data fq CeDAR Reports File Tools Help Hourly Turbine 1 Hourly HRSG Emissions Report Hourls Turbine 2 Hourly HRSG Emissions Report i Previous Uou Daily Turbine 3 Hourly HRSG Emissions Report i Turbine 1 Hourly Bypass E missions Report O Yesterday 24 hours Monthly Turbine 2 Hourly Bypass E missions Report Turbine 3 Hourly Bypass E missions Report C Monday 24 hours Calibration Checks Turbine 1 Hourly Operations Report Turbine 2 Hourly Operations Report Turbine 3 Hourly Operations Report D One hour 18 20148AM Excess Emissions CEMS Downtime 0 Several consecutive hours 1 8 2014 12 4M Alarms 1 9 2014 8 AM m CG4 Linearty Settings Depending on the requirements for your facility several pre configured reports are available You can define new hourly reports with the Report Wizard Here is an example of an hourly report Demo Facility Facility Location Turbine 1 Hourly HRSG Emissions Report December 18 2013 Hour 8 Hourly Emission Limits NOx ppm 15 02 NOx Ibs CO Ibs NH3 Slip Combined Cycle 2 24 Hr Roling 24 9 52 2 26 3 Simple Cycle 3 E3 522 SianupShumdown 650 1900 NH3 Slip NOx ppm NOx CO ppm co NH3SIp pom is NH2Siip NH3Sip Process Minute ors NOxppn GiS O2 bmm NOxibhr COpom 15 02 IbimmStu CO lbh ppm o2 Ibm Eau Ibh Staius a0 13 98 211 1 80 1
187. ys the long period parameters usually 1 hour data for the selected unit Operating time parameters show OPTIME next to the parameter name Select the parameters you wish to edit Select individual parameters by checking the box next to the parameter name The Select All Deselect All and Invert Selection buttons are also available Click the Select OPTIME button to select only the operating time parameters 175 Cedar User Manual 176 When you select a normal non OPTIME parameter the New monitor code for normal parameters box is enabled Select a new monitor code from the pull down menu When you select an operating time OPTIME parameter the New OPTIME value 0 00 1 00 box is enabled Enter a value between 0 00 and 1 00 which represents the portion of the hour that the parameter operated Both OPTIME and non OPTIME parameters may be selected and changed in one operation The Show PID Numbers box is used by CiSCO support personnel to display the internal parameter IDs T Bulk Edit Monitor Codes and OpTimes From 31 2014 a To 3 31 2074 11 59 PM fecal Unit Turbine 1 Parameters MH3 Ibs 1 Hr Select All 60 023 1 Hr fo 02 1 Hr Kerosene Flow 1 Hr lb sec Pesci Kerosene Flow Time 1 Hr OPTIME l CT Gas Flow lb sec 1 Hr Invert selection CT Gas On Time 1 Hr OPTIME es Turbine On Time 1 Hr OPTIME Select OPTIME w Water Injection 1 Hr biser CT Megawatts 1 Hr Water Inject

Cedar User Manual - Custom Instrumentation Services Corporation

Contents

Download Pdf Manuals

Related Search

Related Contents