Home

Metrix 4.5 User Manual

Contents

1. 83 TUNING FOR HEATING AND COOLING 85 CLOSING THE BASELINE TUNING PERIOD eee 87 CHAPTER 5 SPECIAL ADVANCED TOPICS 89 QUALITY 89 UB WE TERING 4 MM rm 89 DEMAND DELTA T 0 0 0 00 0 91 How USE GROUPING IN 0 00 92 APPENDIX GLOSSARY OF TERMS 96 APPENDIX B ONLINE SUPPORT INFORMATION 104 APPENDIX C IMPORT FILE FORMATS 106 MT1 METER REGISTER FILE FORMAT 106 HTL WEATHER FILE FORMAT 2 02ccecceeececcececeececceeececceeecueceecaeeseeceeeaeeeeeens 110 SM1 SUB METER FILE FORMAT 00000 00 111 VA1 VARIABLE FILE FORMAT 0 1 2 113 5 ENERGY CONSULTING Metrix 4 User s Guide Chapter 1 Introduction Chapter 1 Introduction What is Metrix Welcome to Metrix Utility Accounting System the ultimate utility accounting software package Metrix offers easy importing of bill data rigorous cost avoidance methodology and Excel based
2. 27 28 CHAPTER 3 POPULATING THE DATABASES 33 FUNCTIONS AVAILABLE FOR ALL DATA 6 65 222 33 METER S rore aba E 38 WEATPEE E EE E E EEE 43 MODIFICATIONS e 46 C 5b VARIABLES WC 60 61 RATES AND CHARGES 290 2 22 9 9 55 9 9 9 95 9 5 5 98 9 62 FUELADJUSTMENT S 52 55 LIU PIU DUUM OUT R 70 CLOSING ACCESS 71 S ERGY CONSULTING CHAPTER 4 COMPLETE METER TUNING 72 STATISTICAL INDICATORS 0eccecceceeeccecceeececcueceecceccaeeceecaeeaecceeeaeeceeceeeaeeseeens 72 SELECTING THE TUNING 73 SELECTING THE TUNING 5 0 0 76 SELECTING THE BALANCE POINT 5 2 0 2 78 BASELINE EQUATION ccceccceccecceeccecceeeceececeaeeceeceecaeeceeeaeeceeseeaueceeeteeseesaees 82 SELECTING AND DESELECTING 16 82 BILL 0 0 0
3. 04 15 1935 38 770 125 0 1884 25 562 435 000 05 17 1995 42941 125 06 16 1995 45554 125 07 15 1995 45323 125 08 14 1995 45995 125 2190 34000 614 000 09 16 1995 48847 125 2 328 36 525 675 000 10 15 1995 43569 1251 88 000 11 16 1995 44472 125 Add Row 12 14 1995 37760 125 01 17 1996 43285 125 02 15 1996 40 468 125 Select All Rows Ctrl A 03 16 1996 39447 125 Copy All Rows 2045 29 777 512 000 2163 32 385 575 000 32 882 587 000 N pare cen eo Delete Row Figure 3 10 Meter Register Data Form Important If you are missing one or more inputs enter 0 This displays a 0 in the register for that input Do not enter them as 0 in order to avoid confusion with bills that are genuinely zero All inputs that are 0 are treated as missing data by Metrix which automatically excludes them from ENERGY CONSULTING 42 Metrix 4 User s Guide Chapter 3 Populating the Databases the tuning regression For example if on peak kWh usage is missing for one bill in an electric meter enter 0 You will also notice that this bill is automatically excluded from any tuning analysis Weather For Metrix projects weather will affect electric and gas usage in the baseline scenario Weather is stored at the Site level When laying out a project understand that Sites are usually unique geographical locations that have their own weather patterns Weather Information Tab Met
4. GY CONSULTING 15 Metrix 4 User s Guide Chapter 2 General Project Layout Save Projects As Metrix 4 4 will save all projects as Metrix 4 4 compatible The new Metrix 4 5 features such as Monthly Minimum costs are not available in a project saved as 4 4 compatible For projects created in Metrix 4 4 this box will be checked by default New projects will have this option un checked Tuning Preferences Tab The Tuning Preferences Tab allows users to adjust how auto tuning finds the optimal regression equation The default values are recommended unless the user has good reason to change the preferences Options General Tuning Preferences File Locations User Information Multiplier R2 07 A 1 lt 25 B 1 Mean Bias lt 0000 C HE Diff from 3 bills D Equation Formula Score R2 0 75 0 75 25 5 25 0 001 MeanBias 0 001 100 abs BaseLoad Diff 100 100 DeSelectedBills 7 100 Diff 100 amp ve Bsload Day Tuning Constant Ave Bsload Day Ave Bsload Day is the average of the lowest 3 Energy Day values Default Values X Cancel Figure 2 3 Tuning Preferences Tab of Metrix Settings Equation Formula When you select auto tune Metrix will tune many different ways The tuning which results in the largest score for the equation formula is used The equation formula can be adjusted to the users liking by
5. ERGY CONSULTING 67 Metrix 4 User s Guide Chapter 3 Populating the Databases 0 0640 kWh for the first 75 hours of use multiplied by the Billed Demand for the period This means the billed kW for the period is multiplied by 75 to get the size of the first KWh tier So if the billed demand is 1 200 kW then the first 90 000 kWh are 0 0640 kWh 0 0572 kWh for the next 300 hours of use multiplied by the Billed Demand for the period This means the billed kW for the period is multiplied by 300 to get the size of the second kWh tier So if the billed demand is 1 200 kW then the next 360 000 kWh are 0 0572 kWh 0 0414 kWh for the all remaining kWh So if the billed demand is 1 200 kW then all kWh above 450 000 kWh are 0 0414 kWh Billed Demand is the greater of the metered demand for the current period or 9096 of the highest metered demand in the preceding 11 months This is called a Demand Ratchet Click the Energy Charge Item to open its Setup Data Form as shown in Figure 3 37 Click on the Charge Detail tab to display the Charge Detail Data Form shown in Figure 3 38 Look at the Utility Tier Fields in the Detail Data Form The costs per kWh are entered in the Charge column and the hours of use are entered in the Size column However the values in the Size column can either be interpreted as hours of use or as fixed kWh tiers To specify which interpretation is to be used look at the Special Load factor Provisions field
6. Figure 2 7 Right Click Options to add new project items Metrix names the new Item with its Item type which may be followed by a number and a set of empty quotation marks To give it an actual name click once on the Item to display its Data Form on the right and fill in the Name field Deleting Project Items 1 Click the Item you want to delete 2 From the Edit menu choose Delete or press Delete on your keyboard You can also try right clicking on the Item and selecting Delete from the menu that appears 3 The Delete Block dialog box appears as shown in Figure 2 8 4 Click Yes to delete the Item AN Do you want to delete Area2 7 from the current project Figure 2 8 The Delete Block dialog box Using Elements from Existing Projects If you start from an existing Project you can transform it into a new Project quickly by opening the existing Project and saving it to a different name This may be the best approach when you are creating a new Project that is similar to an existing Project From the File menu choose Open The File Open dialog box appears as shown in Figure 2 9 ENERGY CONSULTING 20 Metrix 4 User s Guide Chapter 2 General Project Layout Select project to open amp ex File name GULFMED Files of type Metrix Project File piy M Cancel Figure 2 9 Opening a File Select and open the old Project you would like to use as the basis of the new Pr
7. A Project must have at least one Site Area and Meter Sub meters are optional and rarely used The simplest Project is a single building with a single meter which would consist of just one Site one Area and one Meter Item As a general rule you can make reports at the Project Site Area and Meter level When laying out your project keep this in mind See Chapter 4 for examples of different Project layouts including complex configurations Adding Project Items Before adding an Item use the Tree Structure to find the desired location and select the Parent Item above which you want to attach the additional Item For example in the Tree Structure the Area Item is attached to a Parent Site Item as shown in Figure 2 6 Thus to add a new Area Item you must first click the Parent Site Item that you want to attach the Area to Show Tree Structure x C Only Show Sites Y Sort By Parent z 1 4 Project New Project m Ot Weatherl NEWI Useri YOU Figure 2 6 Tree Structure From the Edit menu choose New or right click on the Site Item and choose New A drop down list displays the types of Items you may add in this location as shown in Figure 2 7 Choose to add a new Area GY CONSULTING 19 Metrix 4 User s Guide Chapter 2 General Project Layout Mew 4 Area Weather Cut Ctrl Copy Ctrl C Paste Cry Delete Del Reload Tree Expand Collapse All Details
8. nnn 33 183 000C 33 283 000 v n 74 nnnc 5 7 2007 10 5 2007 2 2 2008 64 2008 9 29 2008 1 27 2009 5 27 2009 Days Figure 3 30 Variable History Data Form Sub Meters See the section for Sub meters in the Advanced Topics section ENERGY CONSULTING 61 Metrix 4 User s Guide Chapter 3 Populating the Databases Rates and Charges Metrix calculates utility costs for the SimActual Baseline and Target Scenarios using rate tariffs which contain the formulas for calculating costs from the physical units These are compared to the utility costs from monthly bills in the Actual Scenario to determine if the Project is performing better or worse than expected Normally these rate tariffs should match the actual tariff that your local utility uses to calculate your bill In some cases you may wish to use an alternate tariff if exploring the possibility of switching to a new rate You can also skip the use of tariffs altogether and use simplified average utility costs This is specified in the Cost Calculation Method field in the Meter Setup Data Form Usually you want the SimActual Baseline and Target costs calculated with the same rate tariffs This is the case if you select Single Utility Rate Schedules in the Cost Calculation Method field in the Meter Setup Data Form If you wish to use different tariffs for some Scenarios select Multiple Utility Rate Schedules in the Cost Calculation Method field It
9. gt IEA XYZ Electric1 Electricity XYZ Electricl Gas 1 XYZ Gasl Natural Gas Gas 1 XYZ BGasl Updated Selected Project Meter from Selected Import Meter s Skip Selected Import Meters Create New Project Meter s From Selected Import Meter s v OK X Cancel Help Figure 3 9 Match Import Meters to Project Meters Dialog Box Note You will not be able to select OK until you have dealt with ALL of the unmatched meters Option 1 Update Selected Project Meter from Selected Import Meter a Select a meter in the Import Records box and match it to the correct meter in the Project Records box Click on Update Selected Project Meter from Selected Import Meter b Continue matching meters in the Import and Project Records boxes until you have imported all the meters you want Option 2 Skip Selected Import Meters a If there are any meters in the Import Records box you do not wish to import select them in the Import Records field b Click Skip Selected Import Meters Option 3 Create New Project Meter s From Selected Import Meter s a If there are any meters in the Import Records box you do not wish to import select the meters b Click Create New Project Meter s From Selected Import Meter s This creates a new Site Item at the bottom of your project called NEW METERS which contains all the unmatched meters Hidden Option 4 Cancel ENERGY CONSULTING 41 Metrix 4 User s Gui
10. Secondary Metering Secondary Power Electrical service that is metered after the transformer Primary Service is metered upstream of the transformer or on the primary side Shoulder Shoulder is another name for Park Peak or Mid Peak which are TOU Periods A shoulder period might be from 8am to 10am and from 4pm to 6pm on weekdays Solid Waste Garbage 102 ENERGY CONSULTING Metrix 4 User s Guide Appendix A Glossary of Terms Super Off Peak A few rates have a Super Off Peak Time of Use TOU Period This is a fourth TOU period that would probably represent night hours and weekends Surcharge A special charge tax or fee billed to a customer that is not a standard part of a utility s tariff Storm Water Water originating from rain or other outside sources that does not enter the sewer Tariff A document or schedule filed by a utility company with its federal or state regulatory agencies that presents the rates charged to its customers for the services or commodity delivered Temperature Sensitive Usage The energy used that is related to weather This would mean air conditioning equipment chillers cooling towers boilers hot water pumps etc Therm 100 000 Btu s Time of Use Some rates bill their customers based upon the time of day the energy was used For example a rate may have On Peak and Off Peak Charges On Peak would represent the period of time in which energy is most in demand and most expensive and
11. Setup Data Form as shown in Figure 3 35 Note that On Peak is selected for the Period field ERGY CONSULTING 65 Metrix 4 User s Guide Chapter 3 Populating the Databases This means that this set of charges will be applied to the On Peak electric usage for the Meter to which this rate is attached e Click on the Off Peak kWh Charges Item The Period field is Off Peak You can create as many Charges Items as you need You can have up to four different TOU periods On Peak Off Peak Partial Peak shoulder and Super Off Peak If the TOU periods differ over seasons you can set up Summer On Peak Winter On Peak etc To see an example of a TOU rate which varies seasonally see the 2 Seas TOU Rate Items in the Library Charge Setup Charge Detail Name on Peak kWh Type Consumption Period 0n Peak Units Time Period Utility Unit kWh Startson 1 1 Unit Content 3413 0 Btu Endson 112 31 Figure 3 35 The On Peak kWh Charge Seasonal Rates In seasonal rates the price schedule varies regularly during the year Usually there are two seasons summer and winter In most cases only the price changes e g in summer the price is 0 09 kWh and in winter it is 0 05 kWh However the entire structure can change as well e g winter charges may be flat while summer charges are tiered or even vary by time of day Metrix enables you to vary rates by season as needed Our example shows a simple
12. The OnPkCo column shows the kWh costs for each billing period The BilkW1 column shows the Billed Demand for each period which is multiplied by the hours of use ERGY CONSULTING 68 Metrix 4 User s Guide Charge Setup Charge Detail Chapter 3 Populating the Databases Name Energy Type Consumption Period On Peak Units Time Period Utility Unit Statson 1 H Unit Content Endson 112 31 Figure 3 37 The Charge Setup Data Form for a Tiered Rate Charge Setup Charge Detail Monthly Service Charge 125 00 Daily Service Charge 0 00 Bill Limits Minimum Charge 0 0000 kwh Maximum Charge 0 0000 kWh Minimum Bill 0 00 Maximum Bill 0 00 Charges are per utility unit Utility Tier Te Charge Tier Charge Size 1 00640 5 hr 6 o 0000 0 2 00572 m D hr z 0 0000 0 3 0 0414 8 0 0000 J 0 4 00000 0 9 00000 0 5 40 0000 0 10 0 0000 Sizes are in units or hrs Special LoadF actor Provisions Part 1 n First Tier is 071 Load factor uu Threshold 0 0000 Part 2 Part 3 128 n 24 24 2 LF Figure 3 38 Rate Detail Data form for Tiered Rate Pre Loaded Rate Tariffs in Resource Folder From the Tree Structure select the existing Meter Item to which the Rate Item will apply From the File menu choose Open Library Select the
13. consumption demand etc and 2 refrain from using the cut function when moving data from Excel to Metrix If there is an error using copy there is still a backup in Excel Meters Clearly there must already be a meter set up users are encouraged to carefully examine project and meter preferences Keep in mind what sort of cost calculation methods will be appropriate Utility Bill Register Utility bill data is the primary data that exists at the meter level and it is stored in the Register tab of the meter item in Metrix 1 Click the next to the items in the tree until you navigate to your meter 2 Single left click on the meter item to display all information pertaining to that meter in the right hand of the screen 3 Then select the Register tab to display the Bill Register ERGY CONSULTING 38 Metrix 4 User s Guide Chapter 3 Populating the Databases Meter Setup Register Tuning Scenario Inspection SimActual Import Total TOU Detailed 3 Periods Cost 1 Day of First Bill E Automatically Calculated 1 c Consumption 1 m Manually Entered Demand 1 RkVAh Power Factor 0 Estmated PeiodEnd Credis Tas oerkcotej onPeskewni one cot onPesktew ovk 03 15 1995 35 134 125 0 1 673 21 386 362 000 11 350 1 000 0 04 15 1995 39 770 125 0 1 894 25 562 435 000 12 189 1 020 0 05 17 1935 42 341 125 0 2 045 29 777 512 000 10 994 920 0 06 16 1935
14. most recent bills available For example many commercial facilities are experiencing plug creep as more and more PC s are installed over time As a result non weather sensitive electric usage is increasing This is difficult to quantify but the good news is these meters can still be tuned to meet the criteria for statistical indicators and therefore be a good fit to the facility Again it is important to use the most recent year or more of past electric bills in the tuning period 3 Ifa one time event causes unusually high or low usage for a billing period you should exclude that individual bill from the tuning period For example if a facility is shut down for a few weeks for remodeling the utility bill for that period may be unusually low and should not be included In the Tuning Period field shown in Figure 4 4 enter the number of bills you wish to view then enter the number of the bill you wish to start with Look at the starting on and ending on dates to ensure they reflect your Tuning Period For example for one year starting with the first bill in the Register enter 12 in the bills field and 1 in the start at 7 field In other words use 12 bills starting with the first If you wanted to tune for a period starting three months after the first bill in the register enter 12 in the bills field and 3 in the start at 7 field In other words use 12 bills but start with the third The bills included in the
15. step by step guide to working with Metrix It is organized as follows Setting Up a New Project Set up the Project layout by defining its Sites Buildings and Meters Enter historic data tune the meters and establish performance targets Tracking Utility Performance Enter monthly data and track performance vs expected savings Modify the Project layout if necessary NOTE This manual does not cover making reports For information on making reports please see the Report Maker Manual Should you like some hands on training see the Metrix Tutorials section on page 9 of this manual Overview A project is the equivalent of a Workbook in MS Excel or a Document in MS Word You can set up and maintain hundreds of projects if you want but you will likely only have one or a few A Project can consist of one building with one meter or of dozens of buildings and meters Below is an overview of what is involved in project set up Each item listed below is treated in sections that follow Once the Project has been laid out and historic information has been entered you are ready to analyze its past utility performance patterns and enter expected savings if any from your facility improvement measures as follows 1 Tune the Baseline to establish typical past utility performance based on historic bills and variables 2 Enter performance measures that represent anticipated savings from facility improvements 3 Estab
16. 0 0 657492 19 67 Y 25 E Fae Auto Tune 250 18857 Bies 0000 Y 32 Bil Match LI Set Fit to 0 Regression Equation kWh 251388 7 Days 6574 92 CDD 235 0 UPr 100 000 50 000 Figure 4 9 de selecting an outlier point If the bill is a legitimate outlier caused by unusually high or low usage during one month then it may be excluded from the regression If there is a bill that Metrix did not deselect but that is causing the fit to fall outside acceptable parameters it should also be excluded Bill Matching De selected bills and weather insensitive data can still be used in your Baseline through bill matching This is the process of directly comparing the value of a specified bill or group of bills as the baseline value of a corresponding bill at a future date Often times there are meters that have zero correlation to weather One such notoriously hard to tune meter is the lighting meter For example a parking lot timer sensor might catch a few cloudy ENERGY CONSULTING 83 Metrix 4 User s Guide Chapter 4 Complete Meter Tuning days but itis really matching sunrise and sunset more than temperature These meters can be good candidates for a complete bill match How Metrix calculates the Baseline when Bill matching 1 Abill match modification is added to the meter good supplementary reading would be the section on modifications 2 Users may
17. 00 20 00 0 00 25 00 0 00 15 00 0 00 15 00 0 00 10 00 0 00 0 00 0 00 The last 365 days of change s offset s entered in the first 122 rows through x will auto repeat thereafter on a 365 day cycle except in manual rows Figure 3 25 Measure History Tab Time Periods The Time Periods field designates how the dates are delimited in the End Dates column In Figure 3 25 the Monthly option designates the End Dates to fall at the end of every month The Quarterly option would cause dates to fall at the end of every quarter The Billing Periods option causes the End Dates to reflect the bill dates in the Register Note that changing the Time Periods field after you have entered Measure values causes them to be reset or offset to different months Auto Repeat Rather than requiring you to copy the Measure into every year that it applies to you must only fill in the first year Metrix will copy the Measure into the corresponding time period every year thereafter for the life of the Measure The Measure must however cover 365 days of bills Near the bottom of Figure 3 25 is a message which reads The last 365 days of changes or offsets entered in the first 12 rows through 1 31 1994 will auto repeat thereafter on a 365 day cycle except in manual rows This field allows you to offset the beginning of the Measure In Figure 3 25 the last or most recent 365 days contained in the first 13 bills endi
18. 45 554 125 0 2 169 32 385 575 000 10 875 910 0 07 15 1995 45 323 125 0 2 158 32 882 587 000 10 158 850 0 08 14 1995 4589588 0 2190 34000 614 000 9 680 810 0 09 16 1995 48 897 125 0 2 328 36 525 675 000 3 313 830 0 10 15 1995 43 568 125 0 2 075 30 853 538 000 10 516 880 0 11 16 1995 44472 125 0 2 118 30 398 527 000 11 831 990 0 12 14 1995 37 760 125 0 1 738 22 831 383 000 12 306 1 080 0 01 17 1336 43285 125 0 2 061 28 193 481 000 12 306 1 080 0 02 15 1996 40 468 125 0 1 327 25 390 432 000 13 026 1 090 0 03 16 1996 39 447 125 0 1 878 24 418 415 000 13 026 1 090 0 04 17 1936 42817 125 0 2 039 28 822 492 000 11 831 990 0 05 15 1936 42 054 125 0 2 003 23 051 496 000 10 875 910 0 06 14 1996 45 047 125 0 2 145 32 261 572 000 10 516 880 0 07 15 1396 45 532 125 0 2 221 34 248 620 000 10 038 840 0 08 17 1396 46 908 125 0 2 234 34 863 535 000 3 680 810 0 09 14 1996 43 763 125 0 2 084 31 516 554 000 10 038 840 0 Bill Cut Off Date for Reporting Purposes Metrix will assign bills to months using the following rule All bills falling in the one month Period Starting Ending on H day of the Month will be considered that month s bill Figure 3 6 Historic Electric Bill Data The electric meter in this sample measures consumption kWh and demand kW but not reactive energy or power factor There is only 1 time of use period designated by the number 1 in the TOU Periods Because the fictitious utility company provided bill data with c
19. 500 000 400 000 300 000 200 000 100 000 2009910 snnost Time 11 1 1990 E Actual Baseline 8 99 Tuning Closed Manual 3 Bil Match Tune with HDD F Bal Point Thresh Regr coeffic T Stats Baseload CDD wid D SetFitto0 Regression Equation kWh 12232 4 amp Days 1138 8 Wid Statistical Indicators CVRMSE 288 Y 04934 Bias 0 000 Figure 4 3 Tuning for a User Defined Variable ENERGY CONSULTING 75 Metrix 4 User s Guide Chapter 4 Complete Meter Tuning Selecting the Tuning Periods The first step of tuning is selecting which time frame to use for the regression analysis You should try to use periods in multiples of a year not 18 months or 7 months but rather 12 months or 24 months As a general rule you should use as many bills as you can with the following guidelines 1 Ifchanges were made to the facility which significantly alter the usage patterns for the meter from that time on do not include bills from both before and after the changes in the tuning period Choose all before or all after bills For example if a natural gas meter measured a facility in which the fifty year old boiler was replaced you should only tune to gas bills before the replacement so you can find the savings with the new boiler 2 If there are continuous changes in a facility which affect meter usage patterns use the
20. 5121811213 3121811213 2121811213 Figure 3 21 Regression Modifiers for Summer Coefficients Here you can see the percentage adjustments which change the school year coefficients to equal the summer vacation coefficients For example the Base load coefficient changes from 1204 7 to 157 4 a reduction of 86 9 The heating degree day coefficient changes to 0 which is a 100 adjustment The cooling degree day coefficient is reduced by 29 84 To see the effect of these adjustments click the Modification History tab to see the Modification History Data Form also known as the Factor History as shown in Figure 3 22 Here you see a list of billing periods which correspond to each electric bill entered for the meter The column labeled On Peak 96 shows the overall adjustment in each bill resulting from the change in the coefficients Note that only the summer vacation bills have the adjustment The school year months are checked as Manual and 096 has been manually entered for these months Metrix assumes that any changes in regression coefficients will adjust a bills in the effective period so you must manually turn off the adjustment for those months you do not want changed You must update this data form as new bills are entered to be sure the modification is implemented as desired ENERGY CONSULTING 53 Metrix 4 User s Guide Chapt
21. Off Peak would represent the period of time in which energy is least in demand and least expensive For example in California On Peak would be during week days and Off Peak would be week day nights and weekends Some TOU rates have 4 Time of Use periods TOU Time of Use Transformer Power is transferred along transmission lines at very high voltage Transformers are then used to step down or reduce the voltage to a usable voltage level Tuning Tuning is the process of performing a regression and is the term used in Metrix A Tuning Graph is a graph that shows the points and the best fit line Tuning and Regressing are synonyms as verbs Tuning and Regression are synonyms as nouns Unit Some water companies charge for water in units which is the same as a CCF and represents about 748 gallons Watt A unit of measurement of electrical consumption The power used when one ampere of direct current DC flows through a resistance of one Ohm 103 ENERGY CONSULTING Metrix 4 User s Guide Appendix B Online Support Information Appendix B Online Support Information Metrix Lessons on Our Homepage http www abraxasenergy com metrix 4 tutorials php e Lesson 1 A First Look at Metrix 4 e Lesson 2 Laying Out Your Metrix Project e Lesson 3 Importing Bill Data into Your Metrix Project e Lesson 4 Importing Weather Data into Your Metrix Project e Lesson 5 Tuning Your Data for Weather e Lesson 6 Entering Savi
22. Temp 81 2002 8 12 2002 8 24 2002 9 4 2002 9 15 2002 9 27 2002 10 9 2002 10 22 2002 Days 2F Lo 2t F Hi Lo 3 F Hi 4 F Lo 4 F Hi 5 F Lo 5 F Hi 4 2002 January 270 80 20 110 310 40 350 130 420 230 2390 2002 February 66 0 31 0 370 20 400 280 2340 210 350 180 350 2002 March 490 230 510 390 490 170 240 40 510 240 61 0 2002 April 56 0 350 770 460 510 360 470 300 500 280 450 2002 May 730 530 730 480 600 420 660 440 710 490 700 2002 June 870 590 990 660 910 670 930 710 880 60 700 2002 July 920 710 930 700 940 660 960 690 90 720 870 2002 August 95 0 690 580 710 990 720 980 690 840 2002 September 880 68 0 90 0 AddRow New 71 0 890 570 920 2002 October 800 650 830 BEES 670 680 530 740 2002 November 47 0 320 47 0 DeleteRow 420 540 440 460 2002 December 20 170 450 220 280 140 240 2003 January 500 330 390 T 220 430 350 370 2003 February 360 330 590 340 570 460 490 250 320 170 390 Figure 3 12 Weather History Data Form Degree Day Tab Metrix versions 4 4 and later include a Degree Day Tab that allows users the ability to quickly analyze weather data with respect to the ASHRAE standard balance point of 65 F Users will use this information for analyzing weather data independently of meter tunings For the purpose of comparing different locations years or months it is important to have identical balance points Note Meters may need to have a different balanc
23. The following Options Dialog Box will appear as shown in Figure 2 1 Tuning Preferences File Locations User Information Units Default Currency Diii United States USD x SI Units View project tree when open Show Tuning Marks for Meters Tuning M Default Meter Page Show Item Numbers Allow Decimals in Bill Register X Cancel Figure 2 1 User Options General Field General Tab Units If using Metric Units choose SI units North American users can choose IP for English Units Currency Selecting Default Currency will adjust all costs to this currency regardless of what currency bills are entered in ENERGY CONSULTING 14 Metrix 4 User s Guide Chapter 2 General Project Layout Example 1 a US utility bill of 100 would be viewed by a user in China as 680 Yuan 1 dollar 6 8 Yuan approx Equal value bill amounts mean less confusion for users Example 2 if the user in China adds bills to the US project then they would add a Yuan value because they are viewing Yuan If they are holding bill data for the US customer in dollars then it may be better to open the project in dollars view dollars add dollars and then be able to send the project back to the US without errors NOTE if your Metrix settings are different than those of a project you want to open you will automatically be prompted by the window shown below
24. adjusting the statistical indicators within the formula the values they are compared to and the multipliers Multipliers will weigh the statistical indicators within the equation formula to your preferences If you think having a low mean bias is twice as important as all of the other statistical indicators you should put C 3 If you do not want a statistical indicator in the equation simply uncheck the box to the left of it File Locations Tab Carefully select the default locations where you would like to save your projects to prevent losing your work Templates are sample project files There are several pre loaded into the Metrix software in the Resources folder You may wish to create some templates of your own for particular jobs customers fuel types etc GY CONSULTING 16 Metrix 4 User s Guide Chapter 2 General Project Layout Report Maker tells Metrix where to find the Report Maker Program so it may be started through Metrix It does not tell Report Maker where to save reports this is done through the Report Maker Settings Metrix Data address allows the user to set the default location for where to save projects created in Metrix This will also be applied to data which is exported from projects NOTE there is an important sample project named GULFMED PJY in the default folder data It is highly recommended that users save a copy of this project as a reference or learning tool User Information Tab Contact I
25. among them Functions Available for All Data Registers Most common is the manual form of data entry directly into the cell where it is viewed A single left click on the desired cell is sufficient to begin editing For correcting typos small amounts of data this is fine Note Data entry or editing for medium to large projects should involve copy paste functions from Excel or creating import files Manual Entry A single left click on any cell of a data register opens it for editing This is very straight forward Good for small adjustments but definitely not the preferred method for project level data entry Continue reading for more powerful data entry tools like copy paste and import files ERGY CONSULTING 33 Metrix 4 User s Guide Chapter 3 Populating the Databases Meter Setup Register Tuning Scenario Inspection SimActual Import Total TOU Detailed 3 Periods Cost 1 Day of First Bill E Automatically Calculated S ie Consumption 1 m Manually Entered Demand 1 RkVAh Power Factor 0 Estimated Period End Total Credit DnPkCo nPeak kwh OnPkBillkW 03 15 1995 35 134 125 0 1 673 21 386 362 000 11 350 1 000 0 04 15 1995 39 770 125 0 1 894 25 562 435 000 12 189 1 020 0 05 17 1995 42 341 125 0 2045 29 777 512 000 10 994 920 0 06 16 1995 45 554 125 0 2169 32 385 575 000 10 875 310 0 07 15 1995 45
26. column The Data Intervals field designates how the dates are delimited in the End Date column The default End Dates are those in the Bill Register By checking the Demand Box you can adjust demand pricing The Scenario Field is used when the meter is on a Multiple Utility Rate Schedule You can select Baseline Actual SimActual or Target as the scenario for which your Fuel Adjustment is applied If a meter is on a Single Utility Rate Schedule this box becomes grayed out and the Fuel Adjustment is applied to the SimActual Scenario GY CONSULTING 70 Metrix 4 User s Guide Chapter 3 Populating the Databases Closing Access to Data Entry After all utility bill and independent variable data have been entered for the current billing period you can close the data entered through that period so that it is not inadvertently modified Only a System Administrator can close or open access to current data From the Tree Structure select the Project Item to display the Project Information Data Form In the Current and Entry Close Dates field enter the Entry Close date Any billing period weather data or other variable data entered on or before this date will be closed e Select the Close as Of check box next to the Entry Close date Metrix automatically fills in the As Of field with the current date entered earlier in this Data Form as shown in Figure 3 40 Project Information Contact Information Project Preferences Tuning
27. easily add modifications to the Baseline scenario which will result in a correct comparison of Baseline and Actual or SimActual data Q Target Scenarios You can easily set up Target scenarios which you can compare to Baseline Actual and SimActual scenarios Q Rate Modeling Metrix has a rate engine that can handle most utility rates Whereas average costs can sometimes lead to erroneous results the rate engine allows you to correctly apply costs to utility bills Q Average Costs or Rate Modeling Metrix allows you to use average costs or model your rates You can choose either method Q Multiple Utility Rates Metrix allows you to assign different rates to different scenarios This comes in handy when your meter was previously on one rate and you moved it to another rate to save money Moving From a Previous Version of Metrix NOTE Before any install make a complete back up copy of your work This is just good practice for any software upgrade NOTE Metrix 3 projects saved in Metrix 4 are not backwards compatible By all means evaluate our software but only open copies of your Metrix 3 projects when doing so NOTE All versions of Metrix 4 are compatible among other versions of Metrix 4 but must be saved as compatible version Changes made to a project using the latest features may be lost during the save Users sharing projects in collaborative efforts are strongly encouraged to use the same version of Metrix Evaluators
28. efficiency projects Are all savings truly at the mercy of the weather Of course not all of the top performance contracting companies normalize their savings for weather to show savings and reduce risk They use analysis tools such as Metrix to remove weather from the savings equation so they can accurately quantify savings The Cost Avoidance approach compares a Baseline to the actual bills The Baseline is a normalized value that represents the expected usage for a given set of conditions That is how much energy a building would have used based on this year s conditions Using your billing history historical weather and any other significant variables a user enters Metrix will create a regression equation that relates then all together thereby making it possible to predict an accurate expected usage Users can adjust or tune the equation for the best possible fit to the data Hot summer It might be good to know how many kWh the previous air conditioner consumed per degree outdoor temp Busy month Let s compare utilities to production volume Crazy calendar Occupancy might the key The Cost Savings approach does not normalize for weather there is only a head to head comparison of corresponding months between years This leaves several questions unanswered In the real world of energy analysis this is completely inadequate ENERGY CONSULTING 7 Metrix 4 User s Guide Chapter 1 Introduction Table 1 1 Cost Savings vs Co
29. if the power factor drops below a certain threshold like 8596 and sometimes credited for higher power factors Power Factor problems can be fixed using capacitors Pressure Factor A billing factor that may be used to calculate the price of gas delivered to the customer at higher pressure Primary Metering See Primary Service Primary Service aka Primary Power Primary Service is electrical service that is metered before the transformer which will step down the voltage to a usable level Utility customers who receive Primary Power usually own or rent their own transformers rather than have the utility provide them When electrical service is provided through this type of metering the meter is measuring raw power rather than transformed power Electrical power in order to be useful must be converted to the correct voltage for the intended application This is accomplished through transformers When this type of conversion occurs there is a slight loss of electrical energy through heat that is a by product of the conversion process or transformation Primary Electrical service is less expensive than 101 ENERGY CONSULTING Metrix 4 User s Guide Appendix A Glossary of Terms Secondary Service which is more common Private Carrier An interstate gas pipeline company that owns the gas it carries PSC Public Service Commission PSI Pound per Square Inch This is a measurement of pressure PUC Public Utility Commissi
30. is then possible to add Rate Items to this meter which is specific to a given Scenario as shown in the picture of the Tree Structure in Figure 3 31 This is explained in more detail the Adding Rate Tariff section below This is useful if you wish to compare the utility costs under different tariffs Metrix has a very powerful tariff module that enables you to model almost any utility rate structure including load factor rates time of use rates demand ratchets seasonally or monthly varying rates etc You can also compare what ifs such as what is the impact of switching utility tariffs As you create rate tariffs you should store them in the Metrix Library for use in your Projects Procedures for selecting existing tariffs from the Library and for creating new tariffs in Projects are described below Meter Setup Register Tuning Scenario Inspection Sim ctual Import Name Primary Elec Account XvZ Electiic Description Primary Electric Meter r Degree D ay Calculation Method Daily Degree Days 7 Degree Hours 24 Utility Electricity m Delta T Demand Tuning Utility Pricing Cost Calculation Method Min kWh kw Single Utility Rate Schedule 0 0000 Single Utility Rate Schedule _ r Multiple Utility Rate Schedule Avg Cost Consumption amp Cost Demand Total Cost per Consumption Figure 3 31 Selecting the Cost Calcul
31. location within the Tree Structure you may make additions by right clicking on the Parent Item above which you want the new Item to appear Then from the drop down menu click New and then select the Item you want to add Please view Figures 2 6 and 2 7 for more detail A Project s layout is the organization of its Sites Areas Meters and Sub meters which are defined as follows Site the geographic location for one or more facilities A Project may have just one site a hospital for example or it may have multiple sites for example a school district might choose one site per school All areas attached to a site share the same weather data You may add as many Areas in a Site as needed but remember Sites contain weather Areas do not If your Areas require different weather stations you might want to make them Sites instead Area the portion of a site that has its own meters Often an area is a building but it may be part of a building such as one wing or floor or it may be a different type of facility such as an outdoor swimming pool If the meters measures utility use for the whole building the area should represent the whole building but if the building is divided into sections with different meters each could be a separate area If you are planning on adding your own Variables to your Project then be advised that Variables are attached to Areas For example if you have a factory that produces Bolts and Widgets yo
32. meter The Contract Demand is the capacity in kW that the utility has judged the customer might use at peak conditions Customers are often billed for contract demand indirectly such as billed kW the maximum of 5096 of contract demand or current month s metered demand Cooling Balance Point The cooling balance point is the temperature at which the building starts cooling This is a crude but effective definition CDD s are calculated using the cooling balance point Cooling Degree Day CDD CDD s are a way to measure how much cooling is required for a given period of time They are calculated as follows CDD s for one day difference between the balance point and average of the high and low temp Note there can be no negative CDD s if the daily average is less than the balance point then CDD 0 When CDD s are reported for a bill period this is the sum of the daily CDD Cost Avoidance Almost the same as Cost Savings but different Cost Avoidance is the difference between what 97 ENERGY CONSULTING Metrix 4 User s Guide Appendix A Glossary of Terms how much utility usage would have cost had no ECM s been installed and how much utility usage did cost now that ECM s have been installed Customer Charge Many rates have a monthly or daily charge that customers pay whether they use energy or not Different utilities will call it customer charge monthly charge facilities charge service charge etc Cubic Foot A Cubi
33. or severe weather conditions These must be substituted with values from nearby weather station or averages User discretion is required NOTE leaving gaps in a weather file results in a fatal error during quality control checks they must be addressed Appendix C Import File Formats The name and account fields must be less than 22 characters To properly save the file in Excel save the file with the type Comma Separated Values but type the filename inside quotes with HLT appended to it so that Excel saves the file using the correct extension For example in the filename dialog you can name your file WEATHER HLT Table C 4 Columns for HLT Format Col Col Column Name Field Value Data Source Example 1 A WBAN Code Analogous to 3 letter airport code 24233 2 B Airport Code 3 4 Letters SEA 3 C Weather Site Name Up to 22 characters SEATTLE 4 D Year Year 2010 5 E Month Month 2 6 Hi Temp for 1 day 68 7 G LoTemp for 1 day 45 8 H Hi Temp for 27 day 70 BR Continues until end of month Continues until end of month 39 110 NN ENERGY CONSULTING Metrix 4 User s Guide Appendix C Import File Formats SM1 Sub Meter File Format Some restrictions that should be noted No commas should be in any field No dollar signs First 10 columns must have data The name and account fields must be less
34. select the box that says demand When this box is checked you will be tuning to demand Instead of using HDD and CDD demand is tuned to Heating Delta T and Cooling Delta T It is recommended that users first be very familiar with tuning consumption data weather before tuning to demand Tuning to demand is not quite the same as tuning for consumption Typically utility companies bill for the highest demand recorded in a given billing period This may or may not correspond well to weather For example a special holiday event could draw far more power in a short time than a weather event User knowledge of the facility operations could make the difference Metrix gives users the option to tune demand according to the Maximum temperature difference achieved in a billing period Go to the project information tabs gt project preferences gt check the box for max demand delta T tuning For demand data with a high weather correlation this may 91 ENERGY CONSULTING Metrix 4 User s Guide provide a better fit to the data It is based on the assumption that the maximum demand will Chapter 5 Special Advanced Topics coincide with the day having the greatest temperature extremes How to Use Grouping in Metrix You can add any number of Groups to Metrix For example Region Cost Code Building Type Leased Owned etc For each of these groups you will have Sub Groups to which Sites Areas or Meters may belong For example
35. than 22 characters Fields with no value should be left blank example if there is no demand leave it blank To properly save the file in Excel save the file with the type Comma Separated Values but type the filename inside quotes with SM1 appended to it so that Excel saves the file using the correct extension For example in the filename dialog you can name your file SUBMETER SM1 Table C 5 Columns for SM1 Format Col Col Column Name Field Value Data Source Example 1 A Format ID SM1 SM1 2 B Sub Meter Name Sub Meter Name Submeter 3 3 C Account Account Name 0012345 See Fuel Code column in Table 4 D Utility 3 2 or for the appropriate fuel E code How many Btu s in the Energy 5 E BTU unit Factor Unit i e there are 3413 Btu sina 3413 kWh How many Btuh s in the Energy 6 F BTUH unit Unit i e there are 3413 Btuh s in 3413 a kW 7 G_ Year Meter read date year 1999 8 H Month Meter read date month 3 9 Day Meter read date day 10 J Number of days in bill period Number of days in bill period 29 11 Leave Blank Leave Blank Leave Blank 12 L Leave Blank Leave Blank Leave Blank 13 M Leave Blank Leave Blank Leave Blank 14 N Leave Blank Leave Blank Leave Blank 15 O Leave Blank Leave Blank Leave Blank 16 On Peak Quantity On Peak Qua
36. the Metrix 4 Tutorials These tutorials are located online at http www abraxasenergy com metrix 4 tutorials php There are eight lessons that cover most of the topics in this manual This is a great tool to get some hands on Metrix training FAQ s At our website we have provided a list of FAQ s that covers most of the common issues encountered by users Check out the FAQ s at the URL below Q Abraxas Energy Consulting Metrix FAQ s http www abraxasenergy com faq php Email Questions Ask questions and receive detailed answers from the Technical Support Department Send emails to the address listed below If you think the problem is associated with your project send your Metrix project and we will look it over ERGY CONSULTING 11 Metrix 4 User s Guide Chapter 1 Introduction Q Abraxas Energy Consulting Technical Support Email helpdesk abraxasenergy com Fax Questions or comments can be faxed to Abraxas Energy Consulting Just send to the fax number listed below You will receive a reply by phone or email Q Abraxas Energy Consulting Technical Support Fax 805 456 0180 Telephone Abraxas Energy Consulting can be reached by phone between 8 AM and 5 PM Pacific Time Monday through Friday Q Abraxas Energy Consulting Technical Support Phone 805 547 2050 ENERGY CONSULTING 12 Metrix 4 User s Guide Chapter 2 General Project Layout Chapter 2 General Project Layout The rest of this manual is a detailed
37. to the time period to which you want this Measure to apply Measure Setup Measure History Name HVAC amp Chillers Utility Description HVAC Controls amp Chiller Upgrade Effective Dates Start 8 171994 v End 12 31 2004 Setup Specification Options Utility Cost C Enter Regression Modifiers of periodic changes in utility usage Power Factor TOU periods 5 eu affecting tuning coefficients Snnt Metrix automatically enters Demand equivalent Factor History Directly Enter Factor History Figure 3 24 Measure Setup Data Form 3 Click on the Measure History tab to view the Measure History Data Form also known as the Factor History Form shown in Figure 3 25 This Measure shows a 10 to 25 percent decrease in consumption per month and a 0 to 30 percent decrease in demand per month An ECM that might require this type of measure be added might be improved air conditioning or chillers as savings peaks in the warm months and is down in the cooler months GY CONSULTING 56 Metrix 4 User s Guide Chapter 3 Populating the Databases Measure Setup Measure History Time Periods Monthly Y OnPk kw 20 00 0 00 25 00 0 00 15 00 0 00 15 00 0 00 10 00 0 00 0 00 0 00 10 00 0 00 0 00 0 00 10 00 0 00 0 00 0 00 10 00 0 00 0 00 0 00 15 00 0 00 0 00 0 00 20 00 0 00 20 00 0 00 20 00 0 00 20 00 0 00 20 00 0 00 20 00 0 00 25 00 0 00 30 00 0 00 25 00 0 00 30 00 0
38. with either an Error or a Warning Item attached to it To run Quality Control Open a project file go to Performance Quality Control Errors conditions that are not acceptable a Metrix analysis is not correct until ALL errors are eliminated Warnings items that are abnormal or might need attention Items such as an un tuned meter or atypical bill duration are very common but not necessarily fatal Example perhaps a meter is billed bi monthly Some warnings that do cause serious problems include items not attached to the project orphan items meters with the same name Sub metering Let s assume you are tracking a medical center Your Project is achieving excellent savings surpassing your target Then a new wing is brought on line and your utility bills increase 20 2596 There go your savings unless you can correct for the increased usage Metrix can handle this in two ways a Modification or Sub meter Here we discuss sub meters If a sub meter is installed to measure utility usage for the new wing it is easy to correct for the change Simply set up a Sub meter Item and enter the usage measured by the sub meter Metrix subtracts it from the SimActual Scenario and calculates what the utility costs would have been without the new wing From the File menu choose Open Example and click SUBMETER TPY This is a fictitious medical center The Performance Period began in late 1992 In early 1995 a new wing came on line A sub m
39. 0 000 Y 3 Bil Match Dy SetFitto 0 Regression Equation KWh 238642 3 Days 7494 21 CDD 2449 UPr Figure 4 4 The Tuning Data Form Tuning Period ENERGY CONSULTING 77 Metrix 4 User s Guide Chapter 4 Complete Meter Tuning Selecting the Balance Point Temperatures If you have chosen heating or cooling degree days as tuning variables then you must also select the corresponding Balance Point Temperatures There are separate Balance Point Temperatures for heating and cooling The Heating Balance Point Temperature is defined as the outdoor temperature above which no space heating is required Similarly the Cooling Balance Point Temperature is defined as the outdoor temperature below which no space cooling is required Since the Balance Point Temperature is used in calculating Degree Days you can have a significant impact on the regression line by changing the Balance Point Temperature During the Auto Tune process Metrix makes a first guess at the Balance Point Temperature Sometimes this value is optimized and cannot be improved upon In other situations particularly when selecting or deselecting some bills changing the Balance Point Temperature can affect the fit dramatically The Balance Point Temperature is adjusted with the arrow buttons in the row corresponding to that variable Check the CVRMSE and the value to monitor if the fit is improving Note If you are tuning for a single weat
40. 07 28 2003 08 27 2003 0 03 26 2003 99 99 ENERGY CONSULTING 35 Metrix 4 User s Guide Chapter 3 Populating the Databases Bd File Edit Insert Format Tools Data Window Help d d xj A Y fe 9 26 2009 1 Period End Total Misc Credit Tax OnPeak kWh OnPeak kwW 2728 2009 0 0 D 0 0 0 8 27 2009 0 0 0 0 0 0 9 9 26 2009 E Figure 3 3 Copy from Data Register to Excel The paste function can be used very similar to how one would expect to use it in Excel but with a couple of important differences Notice both what it can and cannot be used for Users may paste into a data register in the following ways e Value of a single cell e Replace entire rows e Replace partial rows e Replace the entire register e Add any number of rows While very close to a typical paste function it is not completely identical For example e May not add columns column and type must match before the paste operation e May not paste in between rows e May not subtract rows they must be manually deleted Sample Copy Paste into Metrix from Excel ENERGY CONSULTING 36 Metrix 4 User s Guide Chapter 3 Populating the Databases E3 Microsoft Excel Book a File Edit Insert Format Tools Data Window Help Uedbag hae 4 Ri Ha Bi A2 v f 7 28 2008 TOU Detailed m rotas Periods Cost jst Day of First Bill 8 15 1992 E omatically um ula Consumption 12 ped Demand 18 RkVah oe Pow
41. 2 y 0271571992 659415 649995 610018 667028 697574 919550 843963 921501 983436 756758 655575 680354 635834 675621 E T Electricity Meter Primary Elec 311991 Time W Actual Baseline Fit 7 S91 1144991 3 992 Tune with F Bal Point Thresh Regr coeffic T Stats 630 400 34014 11884 Closed Statistical Indicators Manual a Manual olf 6304 00 3576 v 3 Bil Match 115 Y 0 994 0 000 Days x CVRMSE R2 Bias 1 D SetFitto0 Regression Equation kWh 17680 7 Days 340 19 HDD 655 33 CDD Figure 4 12 Tuning for Heating and Cooling Degree Days Switch the X axis from Time to Outdoor Temp to dis V shaped line is common of Outdoor Temperature gra to Heating and Cooling Degree Days This is also a con select those points that do not fit into the V shape play the graph shown in Figure 4 13 The phs when the bill data has a relationship venient place to identify outliers Simply It is wise to check this graph every time the Auto Tune function identifies a fit relating to Heating and Cooling Degree Days Some plots which are scatte incorrectly identified by Auto Tune as Heating and Cool ENERGY CONSULTING red and should be Bill Matched are ing Degree Day relations 86 Metrix 4 User s Guide Chapter 4 Complete Meter Tuning Meter Setup Register Tuning Scenari
42. 3 Click on the Modification Item The Modification Setup Data Form will appear Uncheck the Included Bills option in the Match field leaving only Excluded Bills checked This means that only excluded or deselected bills will be Bill Matched 4 You select Absolute Offsets of Percent Offsets In our example we will select Absolute Offsets Bill Matching All Bills It may be possible to deselect one or more bills to improve the fit but deselecting too many bills will render the regression meaningless The only option left is to Bill Match all bills Each future bill will be compared to its respective month in the Tuning Period to determine savings IMPORTANT Do not Bill match unless you have a complete 365 days of bills in the base year Follow these steps ERGY CONSULTING 84 Metrix 4 User s Guide Chapter 4 Complete Meter Tuning 1 Click the Set Fit to O button to clear out any tuning 2 Then click the Bill Match button 3 Checkthe Tree Structure to see that a Bill Matching Modification appears beneath the meter as shown in Figure 4 11 BMQ Meter THREE GAS 32 Modification Bill Matching Figure 4 11 Tree Diagram for Bill Matched Meter 4 Click on the Meter Item to display the Tuning Data Form Change the graph x axis to be Time See how the baseline exactly matches all points in the base year Tuning for Heating and Cooling Degree Days If a given meter which serves both space heati
43. 323 125 0 2 158 32 882 587 000 10 158 850 0 08 14 1995 4589588 0 2190 34000 614 000 9 680 810 0 09 16 1995 48 897 125 0 2 328 36 525 675 000 3 919 830 0 10 15 1995 43 563 125 0 207 30 853 538 000 10 516 880 0 11 16 1995 44472 125 0 2 118 30 398 527 000 11 831 990 0 12 14 1995 37 760 125 0 1 798 22 831 383 000 12 306 1 080 0 01 17 1336 43285 125 0 2 061 28 193 481 000 12 306 1 080 0 02 15 1996 40 468 125 0 1 327 25 390 432 000 13 026 1 090 0 03 16 1996 39 447 125 0 1 878 24 418 415 000 13 026 1 090 0 04 17 1396 42817 125 0 2034 28822 492 000 11 831 330 0 05 15 1996 42 054 125 0 200 29 051 496 000 10 875 910 0 06 14 1996 45 047 125 0 2145 32261 572 000 10 516 880 0 07 15 1396 46 632 125 0 2 221 34 248 620 000 10 038 840 0 08 17 1396 46 908 125 0 2234 34 869 535 000 3 680 810 0 09 14 1996 43 763 125 0 2084 31 516 554 000 10 038 840 0 Bill Cut Off Date for Reporting Purposes Metrix will assign bills to months using the following rule All bills falling in the one month Period Starting Ending on H E day of the Month will be considered that month s bill Figure 3 1 Editing the Bill Register Right Click Options A standard palate of 5 options is available by right clicking anywhere in register window pane They are e Add Row New Creates a new blank row beneath the last data entry e Add Row Copy Copies any highlighted row and pastes it beneath the last entry The dates will need to be changed to avoid having a duplicate bil
44. 3413 Btuh s in 3413 a kW 7 G Year Meter read date year 1999 8 H Month Meter read day month Y 9 Day Meter read date day 10 J Number of days in bill period Number of days in bill period 29 11 K Total Cost Billed amount for the account 1234 56 12 L Miscellaneous Service charges late fees etc 1234 56 13 M Credit Credits rebates etc 1234 56 14 Tax Tax 1234 56 15 On Peak Quantity Cost Where available from utility co 1234 56 16 P On Peak Quantity On Peak Quantity 1234 56 17 Q Off Peak Quantity Cost Where available from utility co 1234 56 18 R Off Peak Quantity On Peak Quantity 1234 56 HY SAB 106 ENERGY CONSULTING Metrix 4 User s Guide Appendix C Import File Formats 19 S Partial Peak Cost 20 T Partial Peak Quantity 21 U Super Off Peak Cost 22 V Super Off Peak Quantity 23 W Peak Demand Cost 24 X On Peak Demand 25 Y Off Peak Demand Cost 26 2 Off Peak Demand AA Partial Peak Demand Cost 28 AB Partial Peak Demand 29 AC Super Off Peak Demand Cost 30 AD Super Off Peak Demand 31 AE On Peak Supply Cost 32 AF On Peak Supply 33 AG Off Peak Supply Cost 34 AH Off Peak Supply 35 Al Partial Peak Supply Cost 36 AJ Partial Peak Supply 37 AK Super Off Peak Supply Cost 38 AL S
45. 671471991 49995 y 0771371991 22978 y 0871271991 25900 y 09 15 1991 30745 1144990 20991 5 7991 8 1 1991 3 10 18 1991 Time Mo Yr Tune with F Bal Point Thresh Regr coeffic T Stats Closed M HDD 850 4 00 72843 13134 Baseload Statistical Indicators Manual Days 11581 CVRMSE Izd 82 Auto Tune Bias 0 3 Bill Match 3 SetFitto0 Regression Equation kWh 1158 1 Days 235 03 HDD Figure 3 16 Tuning Data Form Modification Line Expand the Tree Structure to show the Summer Shutdown Modification attached to the Primary Elec Meter as shown in Figure 3 17 Show Tree Structure x C Only Show Sites Sort By Parent lt Project Gm Valley Elem E Sitel Green Valley Campus Areal All Buildings Meterl Primary Elec 4 Patel Electricity amp k Charges Energy 3 Modification Summer Shutdown ot Weatherl MOBILE User YOU Figure 3 17 Tree Structure Modification Item Click on the Modification Item to display the Modification Setup Data Form shown in Figure 3 18 Notice that in the Specification Options field the selected option states Directly Enter Factor History of periodic changes in utility usage This is the default option for Modifications ENERGY CONSULTING 48 Metrix 4 User s Guide Chapter 3 Populating th
46. 690 90 720 870 2002 August 950 690 980 710 990 720 980 690 840 2002 September 880 680 90 0 AddRow New 71 0 890 570 920 2002 October 800 660 630 4 Row 670 680 530 740 2002 November 47 0 320 470 DeleteRow 420 540 440 460 2002 December 320 170 450 220 280 140 240 2003 January 500 330 390 U 220 430 350 370 2003 February 360 330 590 340 570 460 480 250 320 170 390 Figure 3 15 Weather History Data Form Modifications During the life of a facility there will inevitably be changes in usage patterns If savings are to be calculated properly these changes must be accounted for Modifications let you modify your Baseline for changes in utility usage due to facility modifications and special events that would otherwise inaccurately influence your Cost Avoidance these may occur once periodically or consistently ENERGY CONSULTING 46 Metrix 4 User s Guide Chapter 3 Populating the Databases Modifications let you account for miscellaneous changes in the Project that affect utility usage They will usually but not always increase utility usage and costs Modifications affect the Baseline Scenario and thereby also the Target Scenarios If you create a modification for a natural gas meter that increases usage by 2596 per month because for example a ceramics plant adds a large gas fired kiln then both the Target and Baseline Scenarios will show a 2596 increase in therms over what they would have been without the modif
47. 7 Metrix 4 User s Guide Chapter 2 General Project Layout gt Metrix 4 0 C PROGRAM FILES METRIX 4 Resource New_Proj TPY 81 x File Edit Performance Tools View Window Help 8 x v m I D HN bI 80 Show Tree Structure x Project Information Contact Information Project Preferences Tuning Requirements Only Show Site r SotBy Psent 7 E Project New Project Proiect 9 BE e Sitel Description T emplate for creating new project User vou Reference Year Year Label Calendar EndMonth December z M Current and Entry Close Dates Curent Date 8 15 2005 IV Use System Date Entry Close 7 30 1995 Close as O 1 1 1800 gt Milestone Dates Start Date End Date Closed As OF Tuning 1 52 5 Fr vie amp Installation 7 30 1997 77307998 wi 51 Perfomance 773071998 75023 m 17 ine 21 Figure 2 5 New Project Created from Scratch If the Project is not yet expanded you can expand the Project Item and any other item in the Tree Structure by clicking on the plus symbol The Project contains one or more Sites each Site contains one or more Areas each Area contains one or more Meters and each Meter could contain one or more Sub meters You may add as many of each Item in a Project as necessary Each time you add a new Item fill in the Data Form associated with it In any
48. 94 8 1 1994 Time Mo Yr Figure 3 28 Regression Modifier Effects on the Target After this point measures can be created in much the same way as a modification You can either enter Regression Modifiers which affect the tuning coefficients and then have Metrix automatically enter in the appropriate Factor History or you can click the Measure History tab and enter periodic changes in utility usage directly in the Factor History Data Form So you can refer to the section on Modifications to see further details about how to create different types of Measures But remember Measures are used to calculate the Target scenario from the Baseline whereas Modifications are used to adjust or modify the Baseline scenario itself Variables Examples of Variables are the number of meals served per month at a cafeteria may affect water usage or the weekly production quantity at a manufacturing plant may affect electric usage Variables can be used to normalize the meter or just for benchmarking reports for example number of students would not directly affect energy consumption but you may want to compare the student in one school to another one Manually Entering Historic Independent Variable Data If you haven t added a Variable Item yet to add a new Variable Item right click on an existing Area ltem and from the drop down menu select New then Variable Clicking on the Variable Item in the Tree Structure should open the Variable Informat
49. Base Year period given today s conditions where today s conditions for the most part means weather and number of billing days Different utility accounting systems have different meanings for Baseline unfortunately Baseline Equation The Fit Line which was created in Metrix when a regression was performed has an equation which is called the Fit Line Equation The Baseline Equation is the same as the Fit Line Equation except it can also have Baseline adjustments tacked onto it Baseline Equation Fit Line Equation Baseline Adjustments Billed Demand Billed Demand is not the same as Metered Demand Metered Demand is the highest kW value measured over a 15 minute interval or some variation of this Utilities often will charge their customers not on Metered Demand what they used but rather on Billed Demand Billed Demand is calculated for each billing period based upon several factors which can include Billing Period The billing period is the time period for which a customer has been billed The Billing Period stretches from the bill s start date to the bill s end date and these dates typically reflect when the meter was read BTU British Thermal Unit The BTU is the standard unit of measurement for heat A BTU is defined as the amount of energy needed to raise the temperature of one pound of water 1 degree Fahrenheit from 58 5 to 59 5 degrees under standard pressure One kWh has 3413 Btu s 96 ENERGY CONSULTIN
50. Fit Line Fit Line is another term for best fit line or the line that comes closest to all the points in the Metrix tuning graph Fit Line Equation Every line can be defined by an equation such as y mx b The Fit Line Equation is the equation for the Fit Line in Metrix FIM Facility Improvement Measure This term is widely used to represent any energy efficiency project that will reduce expenditures associated with running the facility This often means reducing energy usage but could mean reducing cost of toilet paper or garbage service Similar acronyms include ECM energy conservation measure ECO energy conservation opportunity Firm Service Customers usually pay more for gas or electricity that is sold with a guarantee Firm Service for delivery The opposite is Non Firm service for electricity or interruptible service for gas In times of shortage Non Firm customers may not receive energy This happened to many non firm customers during California s notorious summer of 2001 Fuel Adjustment The additional charges or credits that some utility companies include in their bills to offset the variance in the price of the fuel used to generate electricity This adjustment is typically represented as cents per kWh It is not uncommon for fuel adjustments to be negative Gas Cost Recovery Most utility companies define Gas Cost Recovery as the average cost per thousand cubic feet of gas purchased or produced for sale to the custo
51. G Metrix 4 User s Guide Appendix A Glossary of Terms CCF An abbreviation for One Hundred Cubic Feet CCF are used to measure consumption of water or natural gas Sometimes a CCF of water is called a Unit A CCF of water is about 748 gallons CDD See Cooling Degree Day Commodity Charge aka Energy Charge Gas bills sometimes are broken up into commodity charges and transportation charges The Commodity Charge is the charge associated with the amount of energy purchased from the supplier Co Generation Facility Privately owned electric generation plant that produces electricity and heat by burning fossil fuels Constant Meters do not directly measure energy or power but rather measure some other factor which is then multiplied by a constant in order to determine the amount of energy or power used Consumption The measured amount of energy or water used during a given period This is different from demand which can be thought of as the greatest rate at which the energy or water is delivered at any one time during the billing period In terms of electricity Consumption Meter Some electricity meters measure consumption only and not demand These meters are called consumption meters Contract Carrier A contract carrier is an oil or gas pipeline company that sells its services to the customer on a contractual basis Contract Demand Some electricity rates require the utility to establish a Contract Demand for each individual
52. GROUP SUBGROUPS Region Western Region Eastern Region Central Region GROUP SUBGROUPS Building Type Elementary Schools Jr High Schools High Schools Administration Buildings You can find Groups in the Project level in the Report Groups tab Select Add in the Group section GY CONSULTING Metrix 4 User s Guide Chapter 5 Special Advanced Topics El Metrix 4 0 C MY DATA Consulting Customers MtascaderoATO62706 MX4 PJY JE X H Fie Edt Performance Tools View Window Bx DS WHN E 2 teers BD Project Information Contact Information Project Preferences Tuning Requirements Report Groups Show Tree Structure C Only Show 7 Sort By ent E Groups lt gt Project Atascadero USD Site Atascadero High School x c Site Atascadero Junior High ETRAS Area Junior High E ve Meter JR HS G VQ Meter IR HS G2 Meter JR HS ET Meter JR HS E2 XQ Meter JR HS E3 EQ Meter JR HS E4 Meter JR HS E5 9 BM Meter JR HS E6 BM Meter JR HS E8 Add Edi zu Variable Junior HS Students Variable School Days Area HS Irrigation Ot Weather BAKERSFIELD CA 9 Site Santa Rosa ES 9 88 Site Santa Margarita ES Site San Gabriel ES d Site San Benito ES 68 Site Monterey Rd ES Site Fine Arts Acad Site Cr
53. Irrigation areas 93 ENERGY CONSULTING Metrix 4 User s Guide Chapter 5 Special Advanced Topics Project Atascadero USD Site Atascadero High School Site Atascadero Junior High Site Santa Rosa ES Area Santa Rosa ES Area Santa Rosa Ir Site Santa Margarita ES Area Santa Margarita ES Site San Gabriel ES Area San Gabriel ES Site San Benito ES rea San Benito ES Site Monterey Rd ES Site Fine Arts Acad Site Creston ES Area Creston ES Site Carisa Plains ES Area Carisa Plains Es Site Del Rio Continuation Site Maint Trans Site Technology Services Site Log Cabin t EH w Il a K wv OK X Cancel 3 To add the other subgroups in this case Jr High Schools High Schools and Administration Buildings click on the Add button in the Sub Groups section Then you can name the new Sub Group and select which Sites Areas Meters are associated with the Sub Group Subgroup Name Administration Buildings Project Atascadero USD Site Atascadero High School Site Atascadero Junior High Site Santa Rosa ES Site Santa Margarita ES Site San Gabriel ES Site San Benito ES Site Monterey Rd ES Site Fine Arts Acad Site Creston ES S
54. Library file you want to open and click Open Inside you will find a project with several Meter Items each with several Rate Items attached ENERGY CONSULTING 69 Metrix 4 User s Guide Chapter 3 Populating the Databases Fuel Adjustments Fuel Adjustments are particularly useful when a rate varies often For example gas companies often charge a commodity charge that fluctuates monthly Instead of making a new rate for each month a Fuel Adjustment can be used How to create a Fuel Adjustment Item From the Tree Structure select the existing Meter Item to which the Fuel Adjustment will apply To add a new Fuel Adjustment Item right click on the Meter Item and from the drop down menu select New then Fuel Adjustment Click the new Fuel Adjustment Item to open the Fuel Adjustment Data Form shown in Figure 3 39 Name Electric Supply Scenario Tare Y Description Electric POLR Supply Charges Demand Charges Data Intervals other 3 Static Values 0 67 2007 9 5 2007 12 4 2007 3 3 2008 6 1 2008 8 30 2008 11 28 2008 Days Figure 3 39 Fuel Adjustment Data Form Enter the data requested in the Data Form this is simply a series of dates and price adjustments The adjustments are unit for example therm and can be positive or negative You can also select the Static Values option so that you can just enter a fixed amount if necessary The Adjustments are entered into the Value
55. Metrix 4 L1ser s ENERGY CONSULTING Documentation Revision 8 18 2011 Copyright 2011 Abraxas Energy Consulting 811 Palm St San Luis Obispo CA 93401 All rights reserved Abraxas Energy is a registered trademark of Abraxas Energy Consulting The Abraxas Energy logo is a trademark of Abraxas Energy Consulting All other trademarks are the property of their respective owners TABLE OF CONTENTS CHAPTER 1 INTRODUCTION 2 22 5 WHAT IS METRI T oie dee ta 5 WHO USES METRI I pecia Basanca asuma Kfz nennen nennen 5 LESSONS 5 COST SAVINGS VS COST AVOIDANCE eese 6 ESTABLISHED METRIX 5 8 MOVING FROM A PREVIOUS VERSION OF 10 CONTACT PEO HERR DR 11 CHAPTER 2 GENERAL PROJECT LAYOUT 13 OVERVIEW MM 13 PRE PROJECT SETTINGS iei ane bricup matin dri Rm adr 14 BUILDING A PROJECT TREE STRUCTURE tex cens cexx reus Feb cea Cond ceo Cox eden keen 17 PROJECT DATA PANES 22 USER DATA PANE f 26 SME DATA PANE DLE MEE AE 27 AREA DATA PANES
56. OBILE AL Daily Temperatures Max Temp Min Temp 14182 1 7 82 17 14 92 1 21 92 1 28 92 2 4 92 270 92 247 92 2 24 82 3 2 92 3 8 82 3 15 92 3 22 92 3 2992 Days Year Month HiI F Lo 1CF Hi2CF Lo zer ni aC F Lo aC F Hi aC F Lo ACF Hi5 F Lo sce Hi en er Hi 7UF Lo rita 0 580 400 630 380 530 390 650 340 670 380 6 1992 January 61 0 41 0 60 0 46 1992 February 700 380 6101 380 680 410 600 480 630 450 580 440 630 430 5 1992 March 740 501 800 5101 740 490 760 510 650 590 740 590 820 590 8 1992 April 750 470 640 400 650 460 720 420 740 470 650 500 770 570 7 1882 May 840 560 860 560 870 620 820 570 86 0 510 700 500 710 450 7 1992 June 830 650 820 660 870 680 850 670 880 660 880 690 860 740 8 Figure 3 14 Historic Weather Data Important If you are missing one or more inputs DO NOT LEAVE BLANKS IN WEATHER DATA If you have no way of finding the correct data for that day average the high temperatures from the day before and after the gap and use that value Do the same for the low temperatures Leaving blanks will result in an incorrect baseline calculation This type of error will also be flagged during Quality Control which will be discussed in a later section How to easily Obtain Weather Data As an option users can purchase weather data from Abraxas Energy Consulting Hi lo weather data is emailed to you monthly and the user simply clicks import to import the weather You can search for weather data by fol
57. Requirements Name New Project ID Description Template for creating a new project Reference Year Year Label Calendar End Month December Current and Entry Close Dates Current Date 2 15 2005 Lore e v Close as Of Entry Close Milestone Dates Start Date End Date Closed As OF Tuning 7 30 1995 8 15 2005 E 8 Installation 7 30 1997 7 30 1388 8 15 2005 Performance 7 30 1338 7 30 2003 p v 8 15 2005 Figure 3 40 Closing Current Data Access Note Once data access is closed adding modifications and measures becomes very difficult Feel free to close data access but if you do add a modification later be sure to re open data access first ENERGY CONSULTING 71 Metrix 4 User s Guide Chapter 4 Complete Meter Tuning Chapter 4 Complete Meter Tuning Tuning a meter is a process which combines your knowledge of a facility with statistical analysis Tuning consists of identifying the relationship if any between historic utility performance and weather or other variables For example does a meter s usage depend on heating degree days or cooling degree days or occupancy hours or some combination of these variables The end result of tuning is a set of coefficients which Metrix will use each month to calculate the Baseline Scenario what your utility bill would have been if no changes were made to the facility Accurate met
58. S kBtu 1 000 00 kBtuh 1 000 00 Gasoline L gal 114 000 00 gal hr 114 000 00 Diesel D gal 130 000 00 gal hr 130 000 00 Water W Unit 748 0519 Unit day 31 1688 Waste Water R Mgal 1 000 000 00 Mgd 41 666 67 Garbage B 27 yd 27 Biomass Q Ton 16 000 000 Ton hr 16 000 000 Sy 108 ENERGY CONSULTING Metrix 4 User s Guide Appendix C Import File Formats Table C 3 Default Quantity and Demand SI Units Quantity Demand Utility Fuel Btu Unit Btuh Unit Code SI Unit Conversion SI Unit Conversion Factor Factor Chilled Water C kWh 3 413 kW 3 413 Electricity E kWh 3 413 kW 3 413 Natural Gas G MJ 948 06 kW 3 413 N Gas Vol V m 36 020 96 kW 3 413 N Gas LgVol U m 36 020 96 kW 3 413 Propane P L 24 171 74 L hr 241 71 74 Fuel Oil L 36 878 41 L hr 36 878 41 Wood X MJ 948 06 kW 3413 Steam T Ton 2 292 807 5 kW 3413 Solid Fuel S MJ 948 06 kW 3413 Gasoline L L 30 115 61 L hr 30 115 61 Diesel D L 34 342 36 L hr 34 342 36 Water 264 17 m day 11 01 Waste Water R 264 17 m day 11 01 Garbage B 35 31 35 31 Mtr Ton Biomass Q Mtr Ton 17 633 834 hr 17 633 834 Wi I OS NN ENERGY CONSULTING 109 Metrix 4 User s Guide HLT Weather File Format Some restrictions that should be noted No commas should be in any field Gaps in weather are represented by 99 the weather station did not report due to technical difficulty
59. Tuning Period are shown in bold with a gray background in the Register field of the Tuning Data Form This area is highlighted in Figure 4 4 ERGY CONSULTING 76 Metrix 4 User s Guide Chapter 4 Complete Meter Tuning Meter Setup Register Tuning Scenario Inspection Simctual Import Tuning Period dt ad EE 5 172 stat at X axis CoolngDD Moving S A starting on 4 3 2002 ending on 4 2 2003 Electricity cx Period On Peak Demand Meter SECOND E W Actual rogo RbeeMR LL Show Eng Day DearDays 650 000 7 fe i r 600 000 4 i ngarit t 4 70000000000 500 000 1 i i a E 18414561 400000 a a a awra omoi pii 20640161 f 300 000 4 t t 4 4 250 000 M MEME MEE OM REA y 12 31 2002 35n oO nce y 0203 2003 100 000 NND m TN m Len M NC m i y 03 04 2003 UC NR y 04 02 2003 E UNE NUN IE VE SUNL NE NEUE 05 02 2003 15265179 0 2 4 B8 8 10 12 14 16 18 f 06 03 2003 16600543 a Cooling D Days day M Tuning Tune with F Bal Point Thresh Regr coeffic T Stats Closed HDD Baseload Statistical Indicators T Manal RCDD 0 4 0 8347 Daysx 2386423 CVRMSE 3107 Du ee 0936 Auto Tune P 244 6907 Bias
60. applied following the follow rules o Ifthe bills are not near the 15 of the month Starting on 15 will be used o Ifthe bills are near the 15 of the month but mostly higher Starting on 25 will be used o Ifthe bills are near the 15 of the month but mostly lower Starting on the 5 will be used Tuning Requirements Tab These are numbered as they appear in the Metrix screen Note the default settings are highly recommended 1 R Quality of fit 0 75 or higher with 1 00 as perfect fit 2 CVRMSE Eng Coefficient of Variation Root Mean Squared Error 25 or lower for consumption meters 3 CVRMSE Dmd Coefficient of Variation Root Mean Squared Error 35 or lower for consumption meters 4 Abs Mean bias Must be equal to or less than 0 005 ERGY CONSULTING 25 Metrix 4 User s Guide Chapter 2 General Project Layout 5 Abs T Stats Positive 2 0 or higher for CDD and HDD and greater than 2 0 or less than 2 0 for any user variable 6 HDD and CDD T Stat gt 0 This box must be checked to be ASHRAE and IPMVP compliant The reasoning behind this is that an increase in HDD or CDD should correlate with an increased amount of energy use 7 Tuning Constant gt 0 This box must be checked to be ASHRAE and IPMVP compliant A negative tuning constant implies that when all variables tuned to are zero there is negative energy usage Report Groups Tab See section How to Use Grouping in Metrix Notes Tab Clic
61. arisons of utility bills Q Correction for User Supplied Variables Metrix allows you to correct their utility bills for changes in user supplied variables as well This includes occupancy school schedule production etc ENERGY CONSULTING 8 Metrix 4 User s Guide Chapter 1 Introduction Q Multivariable Regression Metrix allows users to correct their utility bills for not just one variable i e weather but allows you to make corrections for up to 5 variables Some meters may supply energy for heating and cooling that is 2 variables and may vary based upon occupancy a 3 variable Q Variable Balance Point Degree Days Weather is imported or entered into Metrix as daily high and low temperatures This allows Metrix to calculate degree days based upon different balance points rather than just 65 F Different buildings start heating and cooling at different balance points and itis less accurate to assume all buildings start heating or cooling at 65 F Q Tuning Statistics Metrix supplies R values and T Statistics on the Tuning data form and CVRMSE and Mean Bias Error values on the Tuning Report These statistics can guide you towards performing reasonable regressions Bill Matching If you cannot tune your meter Metrix allows you to instead compare usage from year to year without any correction for weather or user supplied variables Q Meets IPMVP and FEMP Guidelines criteria for Option C Monitoring and Verif
62. art of the billing period is in summer and part is in winter Metrix calculates the charges as follows Two separate charges are calculated one as if the entire bill fell in the summer season and the other as if the entire bill fell in the winter season The final bill is the average of the two separate charges weighted by the number of days in each season For example if the billing period is 30 days and 11 days fall in the summer season and the remaining 19 days are in the winter season then the summer bill from step 1 above is multiplied by the factor 11 30 and the winter bill by 19 30 The products are added for the final bill To verify that the seasonal rate has been entered correctly click on the Primary Gas Meter Item to which it is attached Click the Register tab to see that the Meter Register Data Form displays the calculated costs for the SimActual The OnPkCo column shows the therm costs for each billing period Load factor Rates Load factor rates usually only apply to electric tariffs These are kWh tiered rates where the size of the kWh tiers is a function of demand for the billing period They are also known as hours use schedules To see our example load factor rate from the File menu choose Open Example and click rate ex2 Note that the Mobile LF M5 Rate Item attached to the electric meter has two Charge Items labeled Energy and Demand The kWh charges for this rate tariff are calculated as follows
63. ate for the Measure Figure 3 27 shows the new Measure History tab Measure Setup Measure History Regression Modifiers Time Periods Monthly 0 00 0 00 11 93 0 00 0 00 0 00 10 27 0 00 0 00 0 00 10 01 0 00 0 00 0 00 10 03 0 00 0 00 0 00 10 03 0 00 0 00 0 00 10 19 0 00 0 00 0 00 11 17 0 00 0 00 0 00 12 74 0 00 0 00 0 00 313 81 0 00 0 00 0 00 14 65 0 00 0 00 0 00 14 64 0 00 0 00 0 00 13 42 0 00 0 00 0 00 11 27 0 00 0 00 0 00 The last 365 days of change s or offset s entered in the first 0 rows through 1 11 1989 will auto repeat thereafter on a 355 day cycle except in manual rows Figure 3 27 Measure History Tab after Regression Modifiers are added ENERGY CONSULTING 59 Metrix 4 User s Guide Chapter 3 Populating the Databases Figure 3 28 shows the effect these Regression Modifications have had on the Target For the first 12 months the Baseline and Target are equal However after the Measure is effective the Target is smaller than the Baseline The difference varies with Days and CDD Electricity Meter Primary Elec 1 050 000 i i i Baseline 1 000 000 4 950 000 900 000 850 000 800 000 750 000 700 000 650 000 600 000 550 000 500 000 450 000 400 000 350 000 5 2 300 000 250 000 200 000 150 000 100 000 50 000 kWh 114 1992 2 1 1993 5 1 1993 8 1 1993 11 1 1993 2 1 1994 5 1 19
64. ation Method ERGY CONSULTING 62 Metrix 4 User s Guide Chapter 3 Populating the Databases gt Project New Project B Sitel 2 44 Areal i p Meter 9 48 Ratel lt lt Actual gt gt 9 48 Rate2 lt lt SimActual gt 9 48 Rate3 lt lt Baseline gt gt Hif Rated lt lt Target gt gt iof Weatherl NEW i fp User YOU Figure 3 32 Rates View with Multiple Utility Rate Schedules Creating Rate Tariffs To create a rate tariff you must create a Rate Item which comes attached with a Charge Item As many Charge Items as necessary be added to a single rate Name Utility Electricity 71 Description Utility Rate Type Standard Rate Setup Rate Details Consumption 3413 0 Btu 7 from 1 1 1900 Demand 34130 Btuh ew Eff thru 12 31 2098 Monthly Bill Limits Minimum Charge 0000 kWh Consumption Maximum Charge kWh Consumption Minimum Charge kW Demand Maximum Charge 7 kw Demand Minimum Total Bil 000 Maximum TotalBil 0 00 Figure 3 33 Rate Setup Data Form ENERGY CONSULTING 63 Metrix 4 User s Guide Chapter 3 Populating the Databases How to create a Rate Item 1 From the Tree Structure select the existing Meter Item to which the rate tariff will apply 2 To add a new Rate Item right click on the Meter Item and from the drop down menu se
65. bill data of the Tuning Period plotted versus a different independent variable Viewing these graphs can help you identify which variables have strong relationships with the bill data and which do not T Stats Metrix also gives a statistical indication of which variables have strong correlations The T Stats column underneath each graph indicates which of the selected variables have a strong fit with the bill data and which do not A value of 2 0 or higher for CDD or HDD or greater than ERGY CONSULTING 73 Metrix 4 User s Guide Chapter 4 Complete Meter Tuning 2 0 or less than 2 0 indicates the variable is valid Again trying several combinations is important because each iteration will yield different T Stats Meter Setup Register Tuning Scenario Inspection Simctual Import r Tuning Period 12 bills start at E starting on 4 3 2002 ending on 4 2 2003 Period on Peak Demand Show Eng Day Degr Days y 0570272002 y 06 03 2002 10220272002 30870172002 y 08 30 2002 10 01 42002 10 31 42002 11122722002 11223172002 y 02 03 2003 10370422003 10470272003 110520272003 y 06 03 2003 Tuning Closed 19374923 19496874 21188940 18414561 20487724 20640161 18246878 15504257 16631031 17713344 15198110 15411524 16265179 16600543 ee El Grap
66. c Foot is the volume of gas required to fill one cubic foot of space at 60 degrees Fahrenheit at sea level 14 73 psi Deduct Meter A Deduct Meter is a special in line water meter used to measure water consumption that does not enter the sewer system and for which an adjustment is given in calculating sewer charges Demand Charges Therms A charge for service that allows a customer to receive an unlimited or specified supply or volume of gas at any time throughout the year Demand Electric The amount of electricity needed at any one moment in time more so any 15 or 30 minute period of time in order to meet a meter s energy needs Suppose you drove 100 mph for gt hour You drove 50 miles at 100 mph You can equate the concept of demand to speed In this case mph is like demand and miles driven is like energy Remember ECM Energy Conservation Measure This term is widely used to represent any energy efficiency project that will reduce energy expenditures Similar acronyms include FIM facility improvement measure ECO energy conservation opportunity ECO Energy Conservation Opportunity This term is widely used to represent any energy efficiency project that will reduce energy expenditures Similar acronyms include FIM facility improvement measure ECM energy conservation measure Energy Accounting The process of monitoring and recording the consumption of energy and demand Energy Accounting is a great first step in set
67. create a measure which sets a Target at 15 below the Baseline Then you can compare the actual usage to the target to see if you are meeting the target In a performance contract you can use Measures to represent the guaranteed savings goals GY CONSULTING 55 Metrix 4 User s Guide Chapter 3 Populating the Databases You can establish separate measures for each meter The monthly impacts can be positive or negative in absolute values or percentages A meter can have more than one measure impact it the effects are cumulative Each measure has a beginning and end date so you can specify when they take effect This section discusses how to apply Measures Each subsection explains the important points of each type of Measure Direct Entry Enter changes to individual bills manually Regression Modifiers Enter modifiers to the fit line to change the regression equation directly Creating Measures 1 Usethe Tree Structure to select the existing Meter Item which the measure will affect Right click on the Meter Item and from the drop down menu select then Measure 2 Click the new Measure Item to open its Measure Setup Data Form as shown in Figure 3 24 Notice that in the Specification Options field the selected option states Directly Enter Factor History of periodic changes in utility usage This is the default option for Measures Notice the Effective Dates for this Measure These dates should be set
68. de Chapter 3 Populating the Databases Chances are if you get this screen you have done something wrong in your import file For this reason we recommend a Select Cancel b Go back to your import file and double check that you did everything correctly Manually Entering Bill Data You can enter current bill data manually in the Meter Register Data Form This is a spreadsheet like input format Each row contains all the cost and usage data for one period 1 From the Tree Structure click the Meter you want to add data to 2 Click the Register tab to view the Meter Register Data Form shown in Figure 3 10 3 Scroll down to the end of the existing bill data and enter a new row for the current period Enter the end date for each period in the Period End column and charges and usage for that period to its right To add new rows right click anywhere in the data form Select Add Row New to add a blank row with today s date Select Add Row to add a copy of the row you right clicked on You must change the date before moving on You may also use the arrow keys to move about the form To add a new row move to the last row and hit enter or the down arrow Meter Setup Register Tuning Scenario Inspection Sim amp ctual Import Periods 1st Day of First Bill z oe Sa Consumption 1 zi anually Entere Demand 0 RKVAh Power Factor 0 E TOU Detailed Total
69. e Databases Madification Setup Modification History Name Summer Shutdown Description Shutdown of classrooms for June 15 Sept 15 Utility Electricity 71 Effective Dates Start 1 1 1333 End 12 31 2002 Setup Consumption Demand Power Factor Utility Cost TOU periods 1 Specification Options Specify Modiification on of four ways Enter Regression Modifiers which act on the tuning coeff I xil i OLT x Directly Enter Factor History of periodic changes in utility usage Let Metrix automatically enter the Factor history which exactly matches utility bills during tuning Use 7 absolute offset 7 fractional 2 offsets Match Apply to Excluded Bills Guantity Included Bills Demand Notice the Effective Dates for this Modification These dates should be set to the time period to Figure 3 18 Modification Setup Data Form which you want this Modification to apply Generally Modifications should not apply to dates within the Tuning Period Modification dates should only be applied to the Performance Period In the example project shown the Modification Period begins the January after the Performance Period and extends until the end of the Performance Period This value could be changed later if necessary Click on the Modification History tab to view the Modification History Data Form a
70. e R value and T statistics keeping them in the range as detailed above This was the recognized practice in the energy analysis industry In the 2002 ASHRAE came out with Guideline 14 which specified not an R value but instead a CVRMSE and a Mean Bias Error along with T statistics The energy analysis industry has been slow to catch on still relying mostly on the R value This was mostly due to the fact that Metrix 3 never had the CVRMSE and Mean Bias Error on the tuning screen making it hard for energy analysts to tune to these values However more and more energy analysts are now minding the CVRMSE and the Mean Bias Error ERGY CONSULTING 72 Metrix 4 User s Guide Chapter 4 Complete Meter Tuning Tune with F Bal Point Thresh Regr coeffic T Stats HDD CDD Cig 61 0 0 0 UPr Regression Equation kWh 238642 3 Days 7494 21 CDD 244 9 Figure 4 1 The Tuning Data Form Statistical Indicators Selecting the Tuning Variables The key to meter tuning is determining which variables are most important in predicting utility performance For example if a gas meter is only measuring the usage of a space heating furnace then gas usage would show a strong dependence upon weather specifically heating degree days Other meters may not be dependent upon weather at all For example water meter may solely be dependent upon occupancy This tuning step consists of selecting those variables whic
71. e point based on the intended application example industrial meat packing facility could be tuned 40 F MOBILE AL HDD Jan Feb Mar Apr May Jun Jul Aug Sep Oct Mov Dec 71982 1993 1994 1995 1996 Figure 3 13 HDD in the Degree Day Tab ENERGY CONSULTING 44 Metrix 4 User s Guide Chapter 3 Populating the Databases Importing Weather Data You can import historic weather patterns for a given city from an external file It is very important to enter the correct Source Location ID as shown in the exercise because Metrix uses this ID to match the external data with the Item when the data was imported From the Tools Menu choose Import Select Weather Import Files hlt avt from the Files of Type list In the Files list double click rmobh ist h t and mobtrak hltto import them A dialog box will appear indicating the import was successful Note The Source Location ID in the Weather Information tab must match the import code in the weather file If Metrix finds a Site in the project without a Weather Item attached you are notified that a specific sight has no weather and you are asked to assign it a Source Location ID from all those available in the import file s Double click the Weather Item to display the Weather Setup data form again and click its Weather History tab to see the history of the daily temperatures that you have imported as shown in Figure 3 14 Weather Information Weather History M
72. e start date of all meters and ends at the latest end date of all meters ENERGY CONSULTING 87 Metrix 4 User s Guide Chapter 4 Complete Meter Tuning Closing a Tuning Period for a Single Meter From the Tree Structure select the Meter Item and click on the Tuning tab to open the Tuning Data Form After you have finished tuning the meter select the Closed check box in the Tuning field in the lower left corner of the Data Form While the Closed check box is selected any bill data or independent variable data for this meter which occurs in the tuning period cannot be edited Closing a Tuning Period for the Entire Project Only a System Administrator can close a tuning period for an entire project From the Tree Structure select the Project Item to open the Project Information Data Form In the Milestone Dates section the Project tuning period start and end dates are automatically filled in based on the individual meter baseline start and end dates To close the Project tuning period select the Closed check box next to the start and end dates Metrix automatically fills in the As Of field with the current date entered earlier in this Data Form as shown in Figure 4 14 Project Information Contact Information Project Preferences Tuning Requirements Name New Project ID Description Template for creating a new project Reference Year Year Label Calendar End Month December Md r Current and Entry Close Date
73. ecial in line water meter used to measure water used for irrigation and thus for reducing water consumption assigned to sewer charges Kilowatt 1 000 Watts or 3413 Btu s kVA Kilovolt Amperes often referred to as the Total Power it is the sum of working power KW and the non working power KVAR Non working power is the current that is needed to electrify the system to reduce resistance and line loss kW kiloWatt The measure of demand or the rate at which electricity is used Remember kWh kiloWatt hour The measurement of consumption of electricity for a given time period One kWh equals one kW of electricity used for one hour Remember Late Charge A fixed or percentage amount charged by the utility company when a customer fails to meet the utility s predetermined payment deadline LF See Load Factor Load Factor Electricity Load Factor is a way to measure how the facility is using energy Meters with high load factors represent meters that use nearly the same amount of energy all hours of the day Meters with low load factors have a very high usage during peak times and low usage during off peak times Load Factor is calculated as follows LF kWh kW Days 24 hrs Day MCF One thousand cubic feet natural gas and perhaps water can be measured in billed in MCF One MCF equals the heating value of 1 000 000 Btu MMBtu Meter A device used for measuring consumption or demand 100 ENERGY CONSULTING Metri
74. ect Layout Metrix 4 0 C METRIX data GULFMED PJY xl Eile Edit Performance Tools Yiew Window Help E a x 5 tt U4 R BQ Show Tree Structure x Only Show Meters Sort By Parent Primary Gas Med Ctr Building Figure 2 11 List Style View allows users to sort project items Project Data Panes Project Information Tab Typically the project information tab only needs to be set during initial project build up Users can also refer to Metrix Lessons for more information Project Information Contact Information Project Preferences Tuning Requirements Report Groups Notes Name Gulf Med iD Description Gul Medical Center Country v Reference Year Year Label Calendar End Month December Current and Entry Close Dates Current Date Use System Date Enty Close 7 30 1995 v 7 s Milestone Dates Start Date End Date Closed As OF Tuning E E r Installation 2717 1994 v 87311994 v 71 Performance 9 1194 12 312004 Figure 2 12 Project Information Tab Name Description ID descriptive information concerning the scope of the project The ID field is optional Country it is highly recommended this field not be left blank Metrix checks this against the user settings on the computer it is being opened on to adjust for currency Reference Year allows users to set
75. ed an energy efficient HVAC retrofit in a customer s store More efficient means less energy and everyone is expecting to see energy costs go down For June the customer might expect savings from June s utility bill as shown in the Figures below June 2001 179 359 kWh June 2002 152 455 kWh Savings 26 904 kWh 250 000 200 000 150 000 x 100 000 50 000 June 2001 June 2002 Figure 1 1 Expected Pre and Post Retrofit usage for HAVC retrofit example Now let s change the numbers a bit What if the customer saw this June 2001 179 359 kWh June 2002 197 295 kWh Increase 17 936 kWh ERGY CONSULTING 6 Metrix 4 User s Guide Chapter 1 Introduction 250 000 200 000 pu i 00 150 000 iy 7 777 2 77 100 000 if 50 000 Wy yy 7 June 2001 June 2002 Figure 1 2 Pre and Post Retrofit usage for retrofit example The customer is likely going to be looking for a very good explanation as to why bills were higher Was the wrong equipment installed Should the energy manager be fired Energy efficient equipment can t possibly make bills go up right Or is there something else causing this Perhaps the temperatures in June 2002 were record setting highs but the previous June had been subject to thunderstorms and more moderate temperatures One would expect the air conditioning load to be much higher in the latter year So how could you ever measure savings from energy
76. elation is very different than it is during non summer months So what we need for this meter are two sets of tuning coefficients one set for the school year and a different set for summer vacation Metrix lets you set this up using a Modification To illustrate this consider an elementary school in which some classrooms are closed throughout each summer from about June 15 September 15 The remaining classrooms and administrative offices are air conditioned throughout the summer In the Tuning Data Form we determine that there are separate fits for summer vacation months and school months From the File menu choose Open Example and click db _reg tpy From the Tree Structure select the Primary Elec Meter Item then click the Tuning tab to view the Tuning Data Form as shown in Figure 3 20 From the 18 bills available in this tuning deselect the 6 summer bills July August and September of 1990 and 1991 At the very bottom of the Tuning Data Form you can see that the regression equation becomes kWh 1204 7x Days 232 21 x HDD 43 15x CDD kWh baseline usage for the given month 1204 7 Base load constant Days number of days in this month 232 21 regression coefficient for use per heating degree day HDD heating degree days in this month 43 15 regression coefficient for use per cooling degree day CDD cooling degree days in this month Now deselect all bills except those in the summer months Now the regression equation beco
77. er 3 Populating the Databases Modification Setup Modification History Regression Modifiers Time Periods Biling Periods Manual End Dates OnPk OnPk G 07 14 1330 08 15 1990 09 12 1990 0 11 1990 Ic Ic lO Ice Ie lO IO IO OD oOo c lo lo lo lo I The last 365 days of change s or offset s entered in the first o rows through 5 14 1390 will auto repeat thereafter on a 355 day cycle except in manual rows Figure 3 22 Factor History for Summer Vacation Bills To see the effect of the Modification close the Modification Data Forms and open the Primary Elec Meter Item to which it is attached This is the Baseline Inspection Data Form for the meter whose graph is shown in Figure 3 23 Since there is no Measure for this meter the Target and Baseline lines on the graph are the same Note that the Baseline closely follows the Actual bills even for the summer vacation months You can also print out the Verification Summary report which contains the degree days for each billing period and confirm that the baseline usage for the summer vacation months is calculated using their coefficients ENERGY CONSULTING 54 Metrix 4 User s Guide Chapter 3 Populating the Databases Electricity Meter Primary Elec W Actual Baseline 120 000 Fit 110 000 100 000 90 000 80 000 70 000 kWh 60 000 50 000 40 000 30 000 20 000 10 000 0
78. er Factor 0 ually Figure 3 4 Pasting a single row with matching date from Excel E3 Microsoft Excel Book a File Edit View Insert Format Tools Data Window Help 2 amp 5 A0 Be i wi Reply with Changes nd Review D4 lt fe 444 ji aoa H ENERGY CONSULTING 37 Metrix 4 User s Guide Chapter 3 Populating the Databases Total TOU Detailed Periods Cost jstDay of First Bill 8 15 1992 Consumption 1 Demand 1 re z RkVv h 0 21 z Power Factor 0 ki 07 28 2008 21E 2 2 2 08 27 2009 0 444 444 0 0 0 09 26 2009 99 444 444 99 99 99 Estimated Period End Total Misc Credit s Taxis OnPeak kWwh nPeak kw 444 Figure 3 5 Pasting partial rows into data register Note Because data registers contain time dependant data they must always be handled sequentially Users must be conscious of the order of utility bills days in weather etc before pasting data into Metrix Failure to do so will result in the error Meter Reading Dates Are Not In Order It will be impossible to obtain results until this is corrected Note the number of columns pasted into Metrix will be truncated to match the existing number of TOU periods and corresponding detailed costs It is possible for information to be lost if they do not match For this reason users are recommended to 1 carefully inspect the number of TOU for
79. er tuning is very important for tracking utility performance Inaccurate tuning can result in inflated or underestimated cost savings We will look at the following Basic Tuning overview of the steps used to tune individual meters Tuning for Heating amp Cooling DD s tuning a meter which serves both space heating and cooling equipment Tuning for User Defined Variables tuning a meter which is affected by non weather variables such as production or occupancy hours Statistical Indicators Since linear regression is a statistical calculation there are several measures that Metrix uses to define a good fit To determine whether a meter is tuned well enough these measures are shown in the Tuning Data Form in the field titled Statistical Indicators The industry standards for these measures are described in ASHRAE Guideline 14 2002 1 CVRMSE Coefficient of Variation of the Root Mean Square of the Error 25 or lower for energy or water 35 or lower for demand 2 R Quality of fit 0 75 or higher with 1 00 as perfect fit 3 T Statistics T Stats Positive 2 0 or higher for CDD and HDD and greater than 2 0 or less than 2 0 for any user variable 4 Net Mean Bias Bias 96 Must be equal to or less than 0 005 For more information on these statistical indicators please refer to ASHRAE Guideline 14 2002 or a college statistics textbook 1 During the late 1990s and the early 2000s most Metrix users only heeded th
80. eston ES Site Carica Plains ES Site Del Rio Continuation Site Maint Trans Site Technology Services Site Log Cabin Area Log Cabin Meter LOG CABIN PSYCHE Variable School Days 307 Weather BAKERSFIELD CA Site District Office User YOU J 2j aT062706 Last Modified 6 30 2006 Field User You will then see a dialog box asking for the Group Name add it Enter Group Name Building Type Cancel Label it and select ok You will now see SubGroup in the SubGroup section Select it then press the Edit button Metrix 4 0 C MY DATA Consulting Customers Atascadero AT062706 MX4 PJY File Edit Performance Tools View Window Help DS E gt be eS Ri BQ Show Tree Structure Project Information Contact Information Project Preferences Tuning Requirements Report Groups C Only Show 51 Z Sort By Parent Groups Project Atascadero USD budno te 268 Site Atascadero High Schoo paioun EE pemn amp Site Atascadero Junior High Subgroups e Site Santa Rosa ES Site Santa Margarita ES e Site San Gabriel ES Site San Benito ES te Monterey Rd ES Fine Arts Acad Name the subgroup at the top of the form and then select which sites areas and meters belong to it Here we selected the school areas and sites but not the
81. eter was installed which measures electric usage and demand for the new wing In the Tree Diagram you can see that a Sub meter Item is attached to the Primary Electric meter Open the Sub meter Setup Data Form Note that this sub meter uses the same Setup and Reading Dates as its parent meter This means that whenever the parent meter is read so is the 89 ERGY CONSULTING Metrix 4 User s Guide Chapter 5 Special Advanced Topics sub meter so we won t have to enter read dates twice The setup indicates that the sub meter measures both kWh and kW just like its parent Open the Sub meter Register Data Form as shown in Figure 5 1 Note that the kWh and kW readings are 0 until the 1 14 95 bill This is when the first Sub meter reading occurred Show Tree Structure x SubMeter Setup SubMeter Register C Only Show Sort By Project Gulf Med Ctr 2 Site Center Site 06 14 1994 0 0 Area Med Ctr Building 07 15 1984 0 0 Meter Primary Elec 08 17 1994 0 0 Submeter New Wing Submeter Tr Jp Rate Mobile LCS M5 i Meter Primary Gas 10 15 1994 0 0 ipf Rate GNG GS1 11 16 1994 D JO Weather MOBILE 124571994 0 0 User GEA indiciis 01 14 1935 90400 270 27 95 97800 270 83500 273 88400 228 100600 223 D 35 128000 220 07 15 1995 117800 210 08 14 1935 99000 195 Figure 5 1 Data in the Sub meter Register The kWh and kW entered in the Sub meter Re
82. f 9414990 144991 544991 944991 144992 Time Figure 3 23 Resulting School and Summer Vacation Bills Measures Both Measures and Modifications affect the meter to which they are attached Though their inputs are very similar their impacts on a meter are very different The Target scenario is calculated using the Baseline plus Measures whereas Modifications are used to modify the Baseline scenario Measures represent actions taken to improve the utility performance of a facility They usually but not always decrease utility usage and costs Measures only affect the Target Scenario Initially the Target Scenario is equal to the Baseline Scenario If you create a Measure for an electric meter which reduces usage by 25 000 kWh per month for example for a lighting retrofit then the Target Scenario will have 25 000 kWh less per month than the Baseline Scenario If a meter has no attached Measures then the Target and Baseline Scenarios will be the same A measure represents an action taken to improve the utility performance of a facility that you want to track For example you might replace your existing lighting system with a more efficient fixture type Or you might upgrade your HVAC control system You can enter your expected savings in Metrix to see if you meet the target You do this by creating Measures As a simple example if you install flow restrictors which you expect to reduce water usage 15 each month you can
83. fields when importing or exporting meter data Note It is critical that these fields match their counterparts of the same name in the Meter Setup Tab Metrix offers the user to automatically synchronize these fields by prompting the user anytime there is a change made ERGY CONSULTING 32 Metrix 4 User s Guide Chapter 3 Populating the Databases Chapter 3 Populating the Databases Manual Entry vs Import Files When the term Manual Entry is used data is being added directly where it is viewed in the register where it is stored Pro simple intuitive Cons too slow for large projects Import Files allow users to add modify or transfer large amounts of data in one swift move Example an initial project build involving 10 years of billing history should not be entered one bit at a time All data registers can be modified manually or with an import file Types of Data Registers Registers are the row column spreadsheets of Metrix data There are different kinds designed for each type of data they are meant to contain Users can inspect or modify the data through the registers although there are other methods as well The types of registers are e Utility Bill Register e Weather History e Modification History e Measure History e Fuel Adjustment e Variable Information Register Sub Meter Register Each of these is discussed fully in their own respective sections the intent of this section is to introduce the commonalities
84. gister are subtracted from the parent Meter kWh and kW and the remainder is stored in the SimActual Scenario To see this go to the Scenario Inspection associated with the Electricity Meter as shown in Figure 5 2 In the Scenario Inspection graph we see the most recent two years of tracking results Note the Actual kWh points and SimActual kWh line match perfectly until the beginning of 1995 At that point the Actual values increase significantly as a result of the increased usage from the new wing The Actual usage even exceeds the Baseline line at several points However the SimActual usage shows what the actual kWh would have been without the new wing So the SimActual Scenario is now the one we should use for performance results 90 ERGY CONSULTING Metrix 4 User s Guide Chapter 5 Special Advanced Topics Meter Setup Register Tuning Scenario Inspection SimActual Import Graph 16 4 bi 45 bills start at este B E tarti p A idi Graph Series Actual SimActual TOU Period Baseline Target On Peak v V Demand BENE i Electric Demand 0 Meter Primary Elec Target Baseline SimActual E Actual 841994 11 994 211995 5 1995 8 1995 Time Mo Yr Figure 5 2 The SimActual Scenario Reflects the Sub meter Data Demand Delta T Tuning Tuning to demand can be done in the same manner as tuning to consumption Go to the Tuning Tab for your meter and
85. h X axis 700 000 650 000 600 000 550 000 500 000 450 000 amp 400 000 350 000 300 000 250 000 200 000 150 000 100 000 50 000 Cooling DD m Time Heating DD Cooling DD EREN Units Produced Moving S 4 4 4 4 4 4 1 Cooling D Days day F Electricity ter SECOND E 4 4 10 12 4 4 Manual Auto Tune 32 Bil Match ii E 7494 21 CDD Clg 61 0 f o0 7494 21 834 v 6 90 Baseload Days x 238642 3 Statistical Indicators CVRMSE Fe 04936 Bias 1 D SetFitto0 Regression Equation kWh 238642 3 Days 7494 21 CDD 244 8 Figure 4 2 The Tuning Data Form Tuning Variables ENERGY CONSULTING 74 Metrix 4 User s Guide Chapter 4 Complete Meter Tuning Variable Sample Project Some utility meters are dependent upon non weather variables such as occupancy production etc For example water usage is more likely to be sensitive to occupancy Metrix comes pre loaded with an example of such a meter We will look at an electric meter which serves manufacturing equipment instead of space heating or cooling systems 1 From the File
86. h are important and statistically valid for a given meter Users can select up to five variables to tune a single meter heating degree days cooling degree days and up to three user defined variables for example meals served tons of steel produced guest nights Your selection of variables should be guided by your knowledge of what areas the meter serves Consider a few examples e If the meter serves heating equipment and miscellaneous appliances but not cooling equipment you would not select cooling degree days as a variable e fthe meter serves both heating and cooling equipment for example an all electric facility or one with gas fired heating and cooling you might select both heating and cooling degree days e If the meter serves manufacturing or other equipment which is not sensitive to weather one or more production variables should be selected Variables If the Auto Tune function did not choose the correct variables to tune this meter specify which independent variables that should be used Select the appropriate check boxes in the Tune with area under the graphs For example if the current meter is a Natural Gas meter which is primarily serving heating equipment you would select HDD for heating degree days You can select both heating and cooling variables and up to three user defined variables Graphs Use the drop down menu at the top of the Graph area to switch between different graphs Each graph represents the
87. he controls displayed on this tab have very similar counterparts in the tuning tab However the main purpose for the scenario inspection tab is for users to be able to see a visual comparison of their Baseline Actual SimActual and Targets and values for each individual scenario Use the check boxes to add or remove any of these 4 scenarios to you graph Be sure to select the different x axis available as well Baseline Scenario utility usage for the meter is calculated by Metrix based on the meter s past typical performance The Baseline is usually compared with the Actual Scenario to see if any savings are being achieved or to see if utility usage is changing over time after correcting for weather and other variables The Baseline usage is calculated by Metrix with coefficients you derive from tuning the meter Costs for the Baseline Scenario are calculated by Metrix based on the Cost Calculation Method selected in the Meter Setup Data Form Target Scenario reflects the goal or budget you establish for utility usage and costs For example if you were implementing an energy management program which you expect to reduce your utility costs by 3096 you would set up the Target Scenario to be 3096 below the Baseline Then you can compare the Actual utility costs to the Target and determine if you are achieving your goals The Target usage is calculated by Metrix by applying Measures to the Baseline usage Costs are calculated by Metrix based on
88. he top the T day of bill will be locked To unlock simply scroll to the top of the bill register Note Another common error is to leave this field unadjusted resulting in an improper baseline for the first month Total e Automatically Calculated will over ride any pre existing costs in the Total Cost Column by summing any Detailed Costs Tax Credits or Misc Costs You must have at least one Detailed Cost column turned on in order to select this feature e Manually Entered Allows users to enter any amount into the Total Cost Column Bill Cut offs A bill cut off date is used in Report Maker to assign the bills to a month based on the day the bill ends This feature is necessary since bills do not always start on the first day of the month and end of the last If a bill ends on May 31 it is a May bill if it ends on June 15 it is also a May bill However when a bill ends on June 15 it becomes more difficult Metrix will determine how to assign these bills based on the options the user selects For example if the user has the options Starting and 15 this means that if you look at a bill end day the bill will be considered the month that the bill ends in if the bill end day is between the 15 of the month the bill ends in and the 14 of the next month Specifically if the bill end on 6 22 and the options Starting and 15 are selected the rule is ERGY CONSULTING 29 Metrix 4 User s Guide Chapter 2 General Projec
89. her variable the baseload days coefficient in the regression equation must be zero or higher ERGY CONSULTING 78 Metrix 4 User s Guide Chapter 4 Complete Meter Tuning Meter Setup Register Tuning Scenario Inspection Simctual Import r Tuning Period Graph 1228 bills start at E X axis Cooling DD x Moving 5 statingon 4 3 2000 ending on 4 2 2003 Electricity TOU Period Meter SECOND E On Peak Demand Show Eng Day DegrDays 0570272002 19374923 1 06 03 2002 19496874 1 02 02 2002 21188940 1 08 01 2002 18414561 1 08 30 2002 20487724 10 01 2002 20640161 1 10 31 2002 18246878 1111 27 2002 15504257 4 1273172002 16631031 1 02 03 2003 17713344 0370472003 15198110 1 04 02 20013 15411524 05 02 2003 16265178 40 12 06 03 2003 16600543 Cooling D Days day E gl Tuning Tune with F Bal Point Thresh Regr coeffic T Stats Closed HDD Baseload Statistical Indicators T Manal coD fool e10 f o0 834v Dose CVRMSE 310v 7 one T Ee 0336 2 Auto Tune A 245 6807 Bias 0000 3 Bil Match DS Set Fitto 0 Regression Equation KWh 238642 3 Days 7494 21 CDD 244 8 UPr Figure 4 5 The Tuning Data Form Balance Point Temperature Buildings have their own set of Balance Points for heating and for cooling and they may not be the same even within the same bu
90. ication This section discusses how to apply Modifications and mentions differences for applying Measures when necessary Each subsection explains the important points of each type of Modification Direct Entry Enter changes to individual bills manually Regression Modifiers Enter modifiers to the fit line to change the regression equation directly Modifications Direct Entry Direct entry modifications are the most common and the most useful way to modify the baseline to account for changes in usage that would otherwise obscure or magnify savings A convenient example is a school which experiences decreased operation during the summer The example file sch sum tpy illustrates this example From the File menu select Open Example Choose sch _sum tpy and click Open Click the Tuning tab to view the Tuning Data Form ERGY CONSULTING 47 Metrix 4 User s Guide Chapter 3 Populating the Databases Meter Setup Register Tuning Scenario Inspection Sim ctual Import Munira orog P Graph 12 bills start at m xai Time z Moving 5 starting on 874 4990 ending on 8 12 1881 Electricity cr Pri n Peri Meter Primary Elec on Peak Demand Baseline Fit Show Eng Day DearDays 24370 y 1071171990 44370 y 1171271990 60969 1271121990 88308 101211271991 92253 10221121991 124636 y 0371271991 33417 y 0471271991 58596 y 0571271931 44100 y 0
91. ication Metrix meets the International Performance Measurement and Verification Protocol and FEMP Guidelines criteria for Option C Monitoring and Verification Q Metrix has become the standard for Cost Avoidance for Energy Service Companies Metrix is routinely used by the largest Energy Service Companies to monitor their performance contracts Metrix is used because it is an unbiased industry accepted easy to use method for determining and presenting cost avoidance Q Hands on tuning screen The tuning screen keeps you from making poor correlations between independent variables and your utility bills Since you are manually performing the regressions you become aware of outliers poor tunings and can discover changes in utility usage during your Base Year Q Easy import of data You can easily import bill data weather data variable data and other data into Metrix Imported files are in comma separated variable CSV format and are easily created in Excel Q Export of data You can easily export bill data weather data variable data and other data out of Metrix into text files that you can open in Excel ERGY CONSULTING 9 Metrix 4 User s Guide Chapter 1 Introduction Q Export of reports You can export Metrix reports into Excel Word html or other formats Q Baseline modifications When the building has substantial changes to its energy usage pattern i e additional square feet or additional equipment you can
92. icts universities government entities property management firms utilities energy service companies and consultants Helpful Lessons Lessons are available on the Abraxas Energy Consulting website at http www abraxasenergy com metrix 4 tutorials php ENERGY CONSULTING 5 Metrix 4 User s Guide Chapter 1 Introduction It is a good idea to go through these lessons if you have not used Metrix before as they will give you a good practical look at the software Cost Savings vs Cost Avoidance Did you know that it is possible for utility bills to increase and still be able to demonstrate energy savings Similarly a reduced utility bill compared to last year s is actually not the true measure of energy savings If the weather was exactly the same during the two years being compared then a comparison of utility bills might yield accurate savings More often than not weather is not constant facility operations change equipment must be repaired and blizzards or hurricanes cause shut downs There is always a valid reason why corresponding months should have an adjusted expected usage for each year The question then becomes How on earth can I calculate an expected building usage Introducing the fundamental concepts of Cost Avoidance and Cost Savings The problem is we don t have any physical instruments that can directly measure Energy or Dollars not spent Example Scenario Suppose a performance contractor install
93. ies have a monthly adjustment to their tariffs based upon other costs For example a natural gas tariff may have a base price of 0 40 therm and an additional cost or credit of a few cents therm depending upon the wholesale price of natural gas each month To account for this in Metrix you do not need to add a new Charges ltem every month Instead the Charges ENERGY CONSULTING 64 Metrix 4 User s Guide Chapter 3 Populating the Databases Item contains the base price and you add a Fuel Adjustment Item to the Meter in which you can add to or subtract from the base price as often as needed Advanced Rate Tariffs Metrix must calculate utility costs for the SimActual Baseline and Target Scenarios These are compared to the actual costs from the utility bills to determine if the Project is performing better or worse than expected For each meter Metrix can calculate these costs based on either the average utility costs from the actual bills or based on utility rate tariffs you select in Rates View You use the Cost Calculation Method field in the Meter Setup Data Form to specify the method to be used If you select Single or Multiple Utility Rate Schedules in the Cost Calculation Method field the Rate and Charges Items which are attached to the Meter are used to calculate these costs rather than an average rate Utility rates especially some electric tariffs can be complex The examples in this section show how to set up some comple
94. ilding The Heating Balance Point can be defined as the outdoor temperature at which the building starts to heat In other words when the outdoor temperature drops below the Heating Balance Point the building s heating system kicks in Conversely when the outdoor temperature rises above the Cooling Balance Point the cooling equipment switches on ENERGY CONSULTING 79 Metrix 4 User s Guide Chapter 4 Complete Meter Tuning Electricity Meter ASHEVILLE NC 921 E 3 000 2850 1 1 4 1 2 300 i i 28504 1 ee E iMEey 2 800 2750 r 27004 1 1 1 1 Two d REED qe ovaetavnvcnneyeonesnentans ee ee ee 2 600 2550 e 2 450 2 400 2350 23001 2 1 4 2 2250 2450 35 40 45 50 55 60 65 70 Temperature F Figure 4 6 Determining the balance point using a kWh day vs Outdoor Temperature graph One way to find the balance point temperature of a building is to graph the Usage day vs average Outdoor Temperature of the billing period as shown in Figure 4 6 Notice that Figure 4 7 presents two trends One trend is flat and the other trend slopes up and to the right We have drawn red lines signifying the two trends in Figure 4 7 The flat trend represents Non Temperature Sensitive Consumption or Baseload which is electrical consu
95. in Figure 2 2 Currency Convertion Project D Program Files Metrix 4 D ata GULFMED_PJY Project File Default Metrix Setting County United States County Uruguay Currency Currency UYU Currency Exchange Rate United States 1 0000 UYU Uruguay Convert TE Figure 2 2 Currency Conversion Window Quality Control QC Check on Startup can make a quality control check standard when you open any project Quality Control is an extremely helpful tool All tech support queries will start here and a vast majority are resolved by addressing the errors found by Quality Control Users are highly encouraged to leave this box checked View This box allows the user to set view defaults to suit preference Expanding Project Tree when open will fully expand all project elements when a project is first opened Typically not a good idea for projects with more than 25 meters it results in too many scroll screens Show Tuning Marks for Meters deals with the red or green checkmarks that will appear next to a meter that is tuned Green meaning tuned red for un tuned Users who are not planning on tuning meters at all are very rare it is recommended to leave this box checked Default Meter Page selects the tab in the right pane that will be viewed first when selecting an item in the project tree Show Item Numbers will assign a number before the name of any project element Example Site 5 Center Building
96. ion Data Form shown in Figure 3 29 Enter the requested data GY CONSULTING 60 Metrix 4 User s Guide Chapter 3 Populating the Databases Variable Information Name Units Produced Abbreviation Beginning of Readings Description Units Produced Per Day 141241383 v Units Figure 3 29 Variable Information Data Form Note Beginning of Readings is an important field It is the first day of the first reading Suppose you had monthly production numbers you wanted to analyze with Metrix If your first monthly reading is 1 31 2005 then you would type in 1 1 2005 as Beginning of Readings The Variable History Data Form is shown in Figure 3 30 This Data Form lets you quickly enter past data for the variable To add new rows right click anywhere in the data form Select Add Row New to add a blank row with today s date Select Add Row to add a copy of the row you right clicked on You must change the date before moving on You may also use the arrow keys to move about the form To add a new row move to the last row and hit enter or the down arrow VarName A 08 22 2007 49 928 0000 09 21 2007 49 020 000C 10 21 2007 36 242 000 11 20 2007 33 208 000 12 20 2007 49 201 000C 01 19 2008 21 210 000 02 18 2008 22 314 000 Add Row New Add Row Copy Units Produced Delete Row Select Al Rows 08 16 2008 03 15 2008
97. irectly enter Baseline Equation Regression Coefficients Auto Tune see section on Complete Meter Tuning for details Bill Match see section on Bill Matching in Complete Meter Tuning for details Set Fit to Zero clears the Baseline Equation Coefficients Note all meter tuning will be lost Tune With Check boxes selecting these tells Metrix what variables to tune with The default boxes are HDD and CDD for heating and cooling degree days Additional boxes will appear for user defined variables when they are added Bal Point see section on Complete Meter Tuning for details Thresh Threshold the lowest number of HDD and CDD of the bills selected in the tuning period ERGY CONSULTING 30 Metrix 4 User s Guide Chapter 2 General Project Layout RegrCoeffic Regression Coefficient Matches the tuning variable coefficient in the Baseline Equation Tip compare to the numbers in the Baseline Equation displayed in blue T Stats see section Statistical Indicators in Complete Meter Tuning Baseload Regression Coefficient Matches the Days coefficient in the Baseline Equation Tip compare to the days coefficient in the Baseline Equation displayed in blue Graph X Axis select from the drop down menu the desired units for the graph see Complete Meter Tuning for details Moving S A Moving Smoothed Average helps to show general trends but should not be used while tuning Scenario Inspection Many of t
98. ite Carisa Plains ES Site Technology Services Site Log Cabin Site District Office X Cancel When you are done be sure to press Save below the Subgroups Section your Grouping will not be saved when you click out of the groups tab 94 ENERGY CONSULTING Metrix 4 User s Guide Chapter 5 Special Advanced Topics 4 0 File Edit Performance Tools View Window Help DS WA E ely t Et ermano _X Project Information Contact Information Project Preferences Tuning Requirements Report Groups C Only Show fSi E Sort Byf Parent EN Groups Project Atascadero USD uiine Add BEN DES amp 6 Site Atascadero High School Site Atascadero Junior High E f Area Junior High QQ Meter UR HS G Elementary Schools Meter JR HS G2 Jr High Schools Meter JR HS E1 High Schools 2 Administration Bi Meter JR HS E2 Meter JR HS E3 ow Meter IR HS E4 Meter JR HS E5 BMG Meter JR HS E6 4 BM Meter JR HS E8 Variable Junior HS Students Variable School Days Area JHS Irrigation Weather BAKERSFIELD CA Santa Rosa ES Soe Site Santa Margarita ES 5 4 It is not necessary to include all meters your Sub Groups some may be left out if you wa
99. ity bill data has to be formatted in a certain way in order to import into Metrix MT1 files are Comma Separated Value CSV files To create an MT1 file using Excel just create a new worksheet and fill in the columns according to the values in the table below Make sure that the worksheet doesn t have any headers just values Some restrictions that should be noted e Nocommas should be in any field No dollar signs First11 columns must have data e The name and account fields must be less than 22 characters e Fields with no value should be left blank example if there is no demand leave it blank e To properly save the file in Excel save the file with the type Comma Separated Values but type the filename inside quotes with MT1 appended to it so that Excel saves the file using the correct extension For example in the filename dialog you can name your file BILLDATA MT1 Table C 1 Columns for MT1 Format Col Col Column Name Field Value Data Source Example 1 A Format ID MT1 1 2 Meter Name Meter Name Electric 3 3 C Account Account Name 0012345 See Fuel Code column in Table 4 D Utility C2 or C 3 for the appropriate fuel E code How many Btu s in the Energy 5 E BTU unit Factor Unit i e there 3413 Btu s ina 3413 kWh How many Btuh s in the Energy 6 F BTUH unit Unit i e there are
100. k the Add Note Button and enter the Date User or Note as you wish Any portion of this information may be left blank if desired Any information entered into these fields many be changed at any time Note be sure to click Save Notes The asterisk indicates new changes have not yet been saved User Data Pane The operator s name contact email address and phone numbers will appear in the reports In the tree diagram click the User Item to display the User Information data form shown below X 515 User Information Initials MS Company Imperial Roman Schools 0000000 Department 7 mem Mange 000000000 Dear Address fi2sappianWay City 0 State Prov Country Zip Postal MCX EMail MxwGRomeog 002594502000 i Telephone Numbers Voice 122 333 3333 Fax 323 232 3222 Other 1 Figure 2 13 Project Information Tab Since all of these fields have been entered in the user form in the Pre Project settings this form can be auto populated by clicking on the button that says Copy from Options User Info ERGY CONSULTING 26 Metrix 4 User s Guide Chapter 2 General Project Layout Site Data Panes As a reminder sites are typically designated by their street address Sites have their own weather Many sites can all be in the same city and thus would have the same weather added at each site but that is not the same as making each b
101. l e Delete Row deletes the highlighted row e Select All Rows highlights all the rows in the data register so they may be copied without the column header useful for pasting to a larger list in Excel e Copy All Rows copies the entire data register including the column headers useful for pasting into Excel ENERGY CONSULTING 34 Metrix 4 User s Guide Chapter 3 Populating the Databases RkVAh op Power Factor 0 Estimated Period End Total Credit Tas nPeak kwh 07 28 2003 0 0 0 0 0 08 27 2003 0 0 0 0 09 26 2009 0 0 0 0 Add Row New Add Row Copy Delete Row Select All Rows Ctri A Copy All Rows Figure 3 2 Data Register options for blank space right click Copy Paste For Any Data Register Select the desired Metrix data to copy with a right click anywhere in the data register You can choose Copy All Data OR choose Select All Data then Ctrl C The entire data register can now be pasted into Excel by right clicking the cell where you want the top right column row cell to be and choose paste Individual rows may not be selected for a partial copy of data register but a single cell can Sample Copy Paste from Excel from Metrix Penoas Cost Tst Day of First Bil 8 15 1992 Consumption 1 t Demand 1 RkVAh 0 jer Power Factor D t E stimated Period End Totalts Misc Credits OnPesk Kwh OnPeakikw 0 0 0 0 0 0 0 0 0 0 39 39 39 99
102. lect New then Rate If Multiple Rate Utility Schedule is selected in the Cost Calculation Method field of the Meter Setup Data Form you will see an additional drop down menu Here you must specify which of the four Scenarios Actual SimActual Baseline or Target you want this Rate Item to apply to Click the Rate Detail tab for access to additional data Note that we have not yet entered the actual cost per utility unit yet such as KWh or therm This is done in the Charges Item s attached to the Rate Item you just created You will need separate Charges Item for each type of unit e g kWh vs kW for each seasonal variation in price for example summer versus winter gas prices or time of day variation for example on peak versus off peak electric prices How to create a Charge Item 1 From the Tree Structure select the existing Rate Item to which the Charge will apply 2 To add a new Charge Item right click on the Rate Item and from the drop down menu select New then Charges Charge Setup Charge Detail Name Type Consumption Period On Peak Units Time Period Utility Unit 027 EE 1 1 Unit Content 3413 0 Btu Endson 12 31 Figure 3 34 Charge Setup Data Form 3 Click the new Charges Item to display its Charge Setup Data Form as shown in Figure 3 34 4 Click the Charge Detail tab to specify more details about the charge Some utilit
103. lish rate tariffs that determine how utility costs and savings are calculated 4 Check quality control to catch any potential errors Note Keep in mind that if you are not performing cost avoidance and just want to compare year to year bills then you can skip Tuning the Baseline and entering Performance Measures You probably will skip Rates as well After completing these steps to set up a historic model of the Project it is a good idea to produce reports that summarize the Project so far Details of report making can be found in the Report Maker Manual Once you are satisfied with the Project set up it is time to start tracking ongoing utility performance as described in the section on Tracking Monthly Performance This section also tells you how to modify the layout of the Project if it changes during the tracking period ERGY CONSULTING 13 Metrix 4 User s Guide Chapter 2 General Project Layout Pre Project Settings IMPORTANT Currency Metric English Units Tuning Preferences File Locations and User Information are important to set before any projects have been opened Very common mistakes include e Adding bill data in the wrong currency e Saving to the wrong location Blank user info that causes collaboration errors across national borders and time zones Avoid costly mistakes and frustration by setting up your software before opening projects Go to Tools gt Options from the menu at the top of the Metrix screen
104. lowing the link below https www abraxasenergy com energytoolbox weathersearch php GY CONSULTING 45 Metrix 4 User s Guide Chapter 3 Populating the Databases Manually Entering Weather Data From the Tree Structure select the Weather Item you wish to add data to Click History to open the Weather History Data Form shown in Figure 3 15 This Data Form enables you to enter past weather data To add new rows right click anywhere in the data form Select Add Row New to add a blank row with today s date Select Add Row to add a copy of the row you right clicked on You must change the date before moving on You may also use the arrow keys to move about the form To add a new row move to the last row and hit enter or the down arrow Weather Information Weather History San Diego CA Daily Temperatures SM TS Min Temp 8 1 2002 8 2 2002 8 24 2002 9 4 2002 9 15 2002 9 27 2002 10 9 2002 10 22 2002 Days Hi 1 F Lo 1 F Hi 2F Lo 2tF Hi 3 F Lo 3 F Hi Lo 4 F Hi Lo S F Hi BF Lo 4 2002 January 270 80 280 10 310 140 350 130 420 230 390 2002 February 66 0 31 0 370 260 400 280 2340 210 350 180 350 2002 March 490 230 510 390 490 170 240 40 510 240 61 0 2002 April 560 350 70 460 510 360 470 300 500 280 450 2002 May 730 530 730 480 600 420 660 440 710 490 700 2002 June 870 690 890 660 910 670 930 710 980 670 700 2002 July 920 710 930 700 940 660 960
105. lso known as the Factor History Form shown in Figure 3 19 ENERGY CONSULTING 49 Metrix 4 User s Guide Chapter 3 Populating the Databases Modification Setup Modification History Time Periods Monthly The last 365 days of change s or offset s entered in the first fi 3 rows through d will auto repeat thereafter on a 5 44 except manual rows Figure 3 19 Modification History Data Form a k a Factor History Notice that the summer months have Modification values which subtract usage This represents the reduced amount of usage expected There are a number of important elements in this Data Form Time Periods The Time Periods field designates how the dates are delimited in the End Dates column The Monthly option designates the End Dates to fall at the end of every month The Quarterly option would cause dates to fall at the end of every quarter The Billing Periods option causes the End Dates to reflect the bill dates in the Register Note that changing the Time Periods field after you have entered Modification values causes them to be reset or offset to different months Auto Repeat Rather than requiring you to copy the Modification into every year that it applies to you must only fill in the first year Metrix will copy the Modification into the corresponding time period every year thereafter for the life of the Modification The Modification must however cover 365 days
106. menu choose Open Example and click var_tune tpy 2 From the Tree Structure click the Widgets Variable Item In the Variable History Data Form you can see the widget production inputs 3 Click the Primary Elec Meter Item and select the Tuning tab to see how the Widget production variable is included in the tuning regression as shown in Figure 4 3 4 Note that the Regression Variable check box for Widgets the check box to the immediate left of the Wid label is the only one selected This means this meter is only tuned to widget production and the resulting fit line in the Tuning graph matches the actual points quite closely Meter Setup Register Tuning Scenario Inspection Sim ctual Import Tuning Period starting on ending on fo Perio 12 bills start at ud 8 14 1930 8 12 1981 on Peak Demand Show Eng Day Degr Days Graph X axis Time hz I Moving S 30971271990 3 1071171990 y 1171271930 y 1271171930 3 0171171991 0271171991 303712713931 gt 04 12 1991 30571271991 gt 06 14 1991 07 13 1991 30871271991 09 15 1931 y 10 18 1381 1255000 1402500 1152500 1080000 1285000 1255000 1387500 1167500 1110000 1255000 1270000 1432500 1212500 1035000 mi xx Electricity Meter Primary Elec 1 400 000 4 1 300 000 1 200 000 1 100 000 1 000 000 900 000 800 000 700 000 600 000
107. mers of the utility In other words it is the difference between what the utility paid for the gas and what they sold it to their customers for HDD See Heating Degree Day Heating Balance Point The heating balance point is the temperature at which the building starts heating This is a crude but effective definition HDD s are calculated using the heating balance point Heating Degree Day HDD HDD s a way to measure how much heating is required for a given period of time They are calculated as follows HDD s for one day difference between the balance point and average of the high and low temp Note there can be no negative HDD s if the daily average is higher than the balance point then HDD 0 When HDD s are reported for a bill period this is the sum of the daily HDD 99 ENERGY CONSULTING Metrix 4 User s Guide Appendix A Glossary of Terms Horsepower A horsepower is unit of measurement used to determine the capacity of a mechanism to do work One Horsepower is the equivalent of raising 33 000 pounds one foot in one minute 1 horsepower equals 746 Watts of electricity at 10096 efficiency Interruptible Service Gas that is sold without any form of guarantee of delivery Utilities are able to curtail delivery to their interruptible customers to allow for seasonal or shortfall adjustments Gas billed to interruptible costs less than that sold on a Firm sales basis Irrigation Meter An Irrigation Meter is a sp
108. mes kWh 157 4x Days 0x HDD 61 49 x CDD ERGY CONSULTING 51 Metrix 4 User s Guide Chapter 3 Populating the Databases Heating Degree Days can be deselected in the Tune with field to correct the T Stats Meter Setup Register Tuning Scenario Inspection Sim amp ctual Import M Tuning Period 184 bills start at m X axis Time v 5 starting on 6 15 1990 ending on 12 17 1991 Electricity P _ Meter Primary Elec i i i Baseline 120 000 4 um annk DOE ricca Fit On Peak Demand Show Eng Day DegrDays 110 000 100 000 08 15 1990 09 12 1990 1 10 11 1990 90 000 3 1171271990 70 000 y 1271171990 60 000 30171171991 50000 1 02 11 1991 124636 1 03 12 1991 93417 30471271991 58596 30 000 30571271991 44100 20 000 06 14 1991 49995 10 000 07 13 1991 24173 i 0871271991 26965 9n 990 125 1990 3 1 1991 6 991 1991 12 1 1991 09 15 1991 Time Mo Yr 90 000 40 000 Tuning Tune with F Bal Point Thresh Regr coeffic T Stats Closed M HDD 660 00 23221 22517 Baseload Statistical Indicators Manual Cla 700 44 4315 2727 Dasx 12047 CVRMSE 354 Y Pe 0390 Auto Tune Bias 0 000 Y 3 Bil Match b Set Fit to 0 Regression Equation kWh 1204 7 Days 232 21 HDD 43 15 CDD Figure 3 20 Tuning Data F
109. mption that is not related to weather Non Temperature Sensitive Consumption is roughly the same every month about 2450 kWh per day Examples of Non Temperature Sensitive Consumption include lighting computers miscellaneous plug load industrial equipment and well pumps Any usage above the horizontal red line is called Temperature Sensitive Consumption which represents electrical usage associated with the building s cooling system The Temperature Sensitive Consumption only occurs at temperatures greater than 61 F The intersection of the two trends is called the Balance Point or Balance Point Temperature which is 61 F in this example Notice as the outdoor temperature increases consumption increases As it gets hotter outside the building uses more energy thus the meter is used for cooling but not heating The Balance Point Temperature we found is the Cooling Balance Point Temperature not the Heating Balance Point Temperature GY CONSULTING 80 Metrix 4 User s Guide Chapter 4 Complete Meter Tuning 3 000 2 950 2 900 Electricity Meter ASHEVILLE NC 921 E a ot ae ae 2 800 2 750 2 700 2 650 2 600 2 550 2500 2 450 2 400 2 350 1 2300 4 2250 2 200 2 150 Therm Day Temperature Sensitive Usage Non Temperature Balance Point Sensitive Usage A Temperature 35 40 45 50 55 6061 65 70 Temperature Figure 4 7 kWh day vs Average Outdoor Temperature Natu
110. nchmarking their facility this information is required Contact Information Tab These are self explanatory Enter contact info pertaining to that particular site where applicable This information is also used by the Metrix Report Maker when using the Email Report feature ERGY CONSULTING 27 Metrix 4 User s Guide Chapter 2 General Project Layout Meter Data Panes Meter Setup Tab Name Account Description Relatively self explanatory these determine the name for the selected meter assign an account to it and allow the user to enter a description Note the account you enter must exactly match the account on the Import Tab as well Metrix will automatically prompt users when a change occurs in the account in either tab and offer to synchronize them for you Utility Select the utility type from the drop down menu Notice the units associated with the meter type will also change accordingly Degree Day Calculation Method Daily Degree Days are the difference between the average temperature for a day and the selected balance point Degree Hours 24 when checked assumes a standard hourly temperature profile for a day when hi low weather is available Averages HDD and CDD separately based on this profile Can provide CDD and HDD for a given day Note not recommend for most projects e Max Delta T Demand Tuning Metrix will tune the meter according to the highest degree day recorded for a billing peri
111. nformation Contact Information Project Preferences Tuning Requirements Report Groups Name Gulf Med Do not change these items if this is a Metrix 3 project imported into Metrix 4 Project Preferences Tune only the sum of TOU periods Override User Bill Selection De selection Override User Tuning Variable Selection Max Delta T Demand Tuning Guarantee Zero Net Bias in Regression Use zero default degree day threshold Set All Bill Cutoff Dates to Starting Ending 15 GE of the Month Set All Tuning Periods to 12 bills statat 1 Automatic Bill Cutoff Dates Name sets the name of the project Project Preferences e Tune Only Sum TOU Periods Only for use when there are multiple Time Of Use Periods Metrix will sum all these periods and tunes to that value If unchecked users will need to tune each TOU period individually that can be difficult e Override User Bill Selection De Selection if Metrix is unable to tune the data with the user s selected bills it will select or de select any that would result in a better set of statistical indicators with a maximum number of bills selected Only bills within the total span chosen for the base year are considered for selection de selection ENERGY CONSULTING 24 Metrix 4 User s Guide Chapter 2 General Project Layout e Override User Tuning Variable Selection if Metrix is unable to tune to all or some of the users tuning variables it
112. nformation as including general global location can save much time and frustration in the future should your projects ever be involved in a collaborative effort over vast distances Even for the sake of technical support leaving contact info will be of great benefit It only needs to be done once Metrix will prompt any other user when opening a project with this information if it detects a change in time zone nationality currency or unit system This helps to prevent improper project modifications Options x General Tuning Preferences File Locations User Information Last Name Position Company Address 1 Address 2 City Country 8 Zip Postal Phone Fax E Mail X Cancel Figure 2 4 User Information Tab in Metrix Settings Building a Project Tree Structure If you create a new Project from scratch Metrix provides a shell Project as your starting point which is called New Proj This contains one each of the required Items for a Project one Site one Area one Meter and so on as shown in Figure 2 5 You may modify these Items and add new ones as needed to set up your actual Project From the File menu choose New Project This creates a new shell Project From the File menu choose Save Enter a new file name such as MYSCHOOL without any extension Metrix automatically adds to indicate that it is a Project file GY CONSULTING 1
113. ng and cooling equipment it will likely be tuned to both heating and cooling degree days From the File menu choose Open Example and click elec tpy From the Tree Structure select the Primary Elec Meter Item and click the Tuning tab to see its Baseline Tuning Data Form as shown in Figure 4 12 With the Graph X Axis set to Time note that the summer months have a big spike and the winter months have a smaller spike With more than one variable selected heating and cooling degree days the T Stats field becomes more important If either the Heating or Cooling Degree day T Stats were less than 2 0 then it should not be selected as a variable for tuning ENERGY CONSULTING 85 Metrix 4 User s Guide Meter Setup Register Tuning Scenario Inspection Simctual Import Chapter 4 Complete Meter Tuning Tuning Perio Graph 73 bills start at E Time Moving 5 3 12 1380 2 15 1992 starting on ending on TOU Period on Peak Demand Show Eng Day Degr Days 1 000 000 950 000 900 000 850 000 800 000 750 000 1 700 000 650 000 600 000 550 000 500 000 450 000 400 000 350 000 300 000 250 000 4 200 000 150 000 100 000 50 000 0 11 1 1990 y 0171171991 y 0271171991 y 0371271991 y 0471271991 1105 12 1991 y 0671471991 y 0771371991 y 0871271991 y 0971571991 y 1071871991 y 1171571991 1112 17 1991 y 017157199
114. ng on 1 31 1994 will be repeated until the end of the Measure which you set in the Effective Dates field in the Measure Setup Data Form ENERGY CONSULTING 57 Metrix 4 User s Guide Chapter 3 Populating the Databases Manual Entry To the left of the End Dates column the Manual column allows you to select specific bills If you check one of these bills anywhere except in the first year of the Measure you may make additional adjustments to account for special one time occurrences These changes will not be auto repeated and they will override the auto repeat function described in the previous item Measures Regression Modifiers In the preceding section for Direct Entry we saw how a Measure can be used to account for an air conditioning and chiller upgrade Obviously your energy savings is going to correlate strongly with cooling degree days Instead of estimating your energy savings as a percentage or offset you can estimate the effect on your regression equation Say you obtained the regression equation shown below from your tuning period kWh 1204 7x Days 43 15x CDD kWh baseline usage for the given month 1204 7 Base load constant Days number of days in this month 43 15 regression coefficient for use per cooling degree day You estimate that on average you will use 25 less energy per CDD and 10 less energy per day regardless of CDD Your target can be adjusted to your estimations by filling out the Regressi
115. ngs Projections into Your Metrix Project e Lesson 7 Tracking Usage in an Existing Metrix Project e Lesson 8 New Features in Metrix 4 Software Manuals http www abraxasenergy com metrixmanuals metrix4usersquide paf http www abraxasenergy com metrixmanuals reportmakerusersquide pdf You can also go to Hard Drive gt Program Files gt Metrix 4 gt Docs Folder FAQ s http www abraxasenergy com faq php Some else has probably wondered about the same thing Lots of great tips and common solutions for energy managers Weather Around the World https www abraxasenergy com energytoolbox weathersearch php Basically we offer every airport code in the US and Canada and about three thousand others around the world HVAC Rules of Thumb https www abraxasenergy com hvac rules of thumb ph Useful info for inspecting usage patterns OR creating realistic savings targets 104 ENERGY CONSULTING Metrix 4 User s Guide Appendix B Online Support Information Emissions Calculator https www abraxasenergy com emissions index htm Estimate based on state fuel type consumption and more returns emissions including CO2 CO NOx lead Conversion Calculators http www abraxasenergy com conversion calculator php From or to just about anything 105 ENERGY CONSULTING Metrix 4 User s Guide Appendix C Import File Formats MT1 Meter Register File Format Appendix C Import File Formats The util
116. nt ENERGY CONSULTING 95 Metrix 4 User s Guide Appendix A Glossary of Terms Appendix A Glossary of Terms Balance Point The cooling balance point is the temperature at which the building starts cooling The heating balance point is the temperature at which the building starts heating This is a crude but effective definition CDD s and HDD s are calculated using the balance point The Cooling Balance Point need not necessarily be the same as the Heating Balance Point Base Load Level on utility bills The base load level is the lowest load level measure during a company s annual or daily cycle Base Load the concept The energy used that has nothing to do with heating or cooling the building Baseload energy is usually composed of lights and computers and 24 7 fans and pumps Base Year Base Year means two different things to two types of Metrix users Base Year represents the year to which you are comparing current year s data If you are using Metrix to calculate savings due to energy projects then base year represents the period of time before the ECM s were installed If you are using Metrix to track your bills in general then base year represents some year in the past that was selected for comparison to current year s data Baseline Baseline is a confusing term because it appears to have many meanings in the energy industry For this discussion Baseline represents how much energy would have been used during the
117. nt The baseload constant It is very common for meter data to tune sufficiently well to weather using CDD or HDD In these instances the baseline equation simplifies to degree days and number of days components Selecting and Deselecting Bills Bills that are selected and included in the regression have a check mark next to the date in the tuning register not the bill register tab which is for estimated bills Their points are graphed in blue Deselected bills are unchecked and are graphed in white Users can click in either the column or on the graph to change selection status Selecting and deselecting bills should be approached with caution Each bill that is deselected for any reason is eliminated from the regression and causes the resulting baseline to represent the bill data less faithfully On the other hand without deselecting some bills it may be impossible to fit a statistically significant line to the data If you are approaching this bill tracking project as an Energy or Building Manager for a company it may be acceptable to deselect bills based on your knowledge of the facility It is important to deselect as few bills as possible to maintain the integrity of the project Remember the object is not to get the highest R value but rather to best represent the building energy usage patterns during the Tuning Period Metrix may determine some bills in the Tuning Period to be outliers or less statistically significant Bills that are
118. ntity 1234 56 17 Q Leave Blank Leave Blank 1234 56 18 R Off Peak Quantity Off Peak Quantity 1234 56 19 S Partial Peak Cost Where available from utility co 1234 56 20 T Partial Peak Quantity 21 U Super Off Peak Cost 22 V Super Off Peak Quantity 23 W On Peak Demand Cost 24 X On Peak Demand 25 Y Off Peak Demand Cost 26 2 Off Peak Demand HY e 111 ENERGY CONSULTING Metrix 4 User s Guide Appendix C Import File Formats 27 AA Partial Peak Demand Cost 28 AB Partial Peak Demand 29 AC Super Off Peak Demand Cost 30 AD Super Off Peak Demand 31 AE On Peak Supply Cost 32 AF On Peak Supply 33 AG Off Peak Supply Cost 34 AH Off Peak Supply 35 Partial Peak Supply Cost 36 AJ Partial Peak Supply 37 AK Super Off Peak Supply Cost 38 AL Super Off Peak Supply 39 AM On Peak Power Factor Cost 40 AN On Peak Power Factor 96 Integer 0 100 97 41 AO Off Peak Power Factor Cost 42 AP Off Peak Power Factor Integer 0 100 97 Partial Peak Power Factor 43 AQ Cost 44 AR Partial Peak Power Factor Integer 0 100 97 45 AS Super Off Peak PF Cost 46 AT Super Off Peak PF Integer 0 100 97 gt MNA S 112 ENERGY CONSULTING Metrix 4 User s Guide Appendix C Import File Formats VA1 Variable File Format S
119. o Import 4 34 xl Look in C3 Data x e ex GULFHIST MT1 GULFTRAK MT1 ja JuneOS ht MOBHIST HLT MOBTRAK HLT File name Junet5 hit Files of type Import Files Cancel i ALL Import Files Bill Data Import Files mt1 Time Series Data TS ts1 Weather Import Files hlt avt Figure 3 8 Selecting the Import File 2 Choose Bill Data mt1 Select the file you wish to import and click Open Case 1 Import file matches Import tab in the Meter item Metrix looks for a Meter Name and Account in the import file that matches up with a Name and Account of a preexisting meter in the project Any import meters that can be matched are imported automatically Case 2 Import file does not match Import tab in the Meter item Any meters that could not be matched are shown in the Match Import Meters to Project Meters Dialog Box as shown in Figure 3 9 ENERGY CONSULTING 40 Metrix 4 User s Guide Chapter 3 Populating the Databases gt Match Import Meters to Project Meters E m ni Metrix is not sure where to put the Import Records listed below Please either Match them up to Proiect Records Create New Project Records from the Import Records or Skip the Import Records Select All Primary Elec XYZ Electric Primary Gas XYZ Gas Clear All Import Records 2 Project Records Meter Name Account __ FuelType__ Import Meter Name
120. o Inspection Simctual Import M Tuning Period Graph aris Moving 5 yee 2 17 bills start at 1 starting on 9 12 1990 ending on 2 15 1992 Electricity m Period Meter Primary Elec 0n Peak Demand Show Eng Day Degr Days 101211271991 659415 102211271991 649995 30371271391 610018 304712713991 667028 y 0571271931 697574 30671471391 919550 10221371991 843963 30871271391 921501 309715713991 983436 310718713991 756758 11 15 1991 655575 11221271991 680354 30171571992 635834 65 70 30271571992 675621 Temperature F Tuning Tune with F Bal Point Thresh Regr coeffic T Stats Closed v HDD 63 0 00 34019 11 894 Baseload M 22 Manua MCDD Ci exo d oo 65533 23576 Daysx 33 Auto Tune 3 Bill Match D Set Fit tod Regression Equation kWh 17680 7 Days 340 19 HDD 655 33 CDD Figure 4 13 Tuning for Heating and Cooling Degree Days Closing the Baseline Tuning Period After all historic meter and independent variable data has been entered and after the baseline has been tuned for each meter you should close the baseline tuning period so that historic data is not inadvertently modified Any user can close tuning period data for an individual meter A System Administrator can close the tuning period for the whole Project The baseline tuning period for the Project begins at the earliest baselin
121. od Note this can be but not always be a more accurate way of correlating demand data to weather It is based on the idea that the highest demand will occur on the day of the highest weather differential While that is the case for many buildings it is not always perfectly reflected how the building is metered Utility Pricing e Single Utility Rate Schedule Applies the rate and charges to the meter most common user setting when rate tariffs are available e Multiple Utility Rate Schedule this allows users to set up to 3 different rates and charges for the same meter data and assign them separately to the Baseline Target and SimActual Cost Consumption amp Cost Demand if a rate has not been entered for this meter Metrix will calculate an average cost consumption unit or cost demand unit Where the cost has been entered in the On Peak Cost Column in the Bill Register Not to be confused with the Total Cost Column in the Bill Register This column is only available when the Detailed Cost Box is checked next the of TOU Periods box If the Do not prorate Misc Costs when calculating Ave Cost Energy and Ave Cost Demand box is checked the Misc amount will be identical in the Simactual and Baseline Otherwise the Misc charges are prorated based on whether the energy consumption and demand costs increase or decrease e Avg Total Cost per Consumption if a rate has not been entered for this meter and the only cost a
122. of bills Near the bottom of Figure 3 19 is a message which reads The last 365 days of 96 changes or offsets entered in the first lt 13 gt rows through 1 31 1994 will auto repeat thereafter on a 365 day cycle except in manual rows This field allows you to offset the beginning of the modification In Figure 3 19 the last or most recent 365 days contained in the first 13 bills GY CONSULTING 50 Metrix 4 User s Guide Chapter 3 Populating the Databases ending on 1 31 1994 will be repeated until the end of the modification which you set in the Effective Dates field in the Modification Setup Data Form Manual Entry To the left of the End Dates column the Manual column allows you to select specific bills If you check one of these bills anywhere except in the first year of the Modification you may make additional adjustments to account for special one time occurrences These changes will not be auto repeated and they will override the auto repeat function described in the previous item Modifications Regression Modifiers In the preceding section for Direct Entry we saw how a Modification can be used to account for a school which shuts down most operations in summer Here is a similar situation a school which is operated differently during summer vacation months However in this example the school is still in significant use during summer and the electric use in summer correlates well with cooling degree days But the corr
123. of the software should check over meter tunings to see if they have changed If resetting meter tunings Atthe project level under the project preferences tab un check Guarantee Zero Net Bias in Regression and Max Delta T Demand Tuning Q You may also encounter difficulties with bill matching modifications If so you may have to delete and re add the modifications ERGY CONSULTING 10 Metrix 4 User s Guide Chapter 1 Introduction Contact Info Mailing Address Abraxas Energy Consulting PO Box 230 Santa Margarita CA 93453 NOTE Abraxas Energy Consulting also has a network of international dealers Please contact the Abraxas Energy Consulting Sales Department for information about contacting an authorized dealer in your area Sales Department Sales Phone 805 547 2050 Sales Fax 805 456 0180 sales abraxasenergy com Technical Support We are working hard to provide you with intuitive technical products In addition we try to provide superior online and print documentation to enable you to work independently in creating your Metrix projects However should you find yourself with a technical question that cannot be answered with provided tools please contact our technical support department All of our Technical Support Engineers are eager to answer your questions and help you create the best Metrix projects possible Metrix Tutorials We highly recommend practicing the instruction you receive in this manual on
124. oject A Security Check message may appear noting who last modified the existing Project From the File menu choose Save As and save the Project under a new name Using the Pre made Project Elements Metrix has common projects elements such as rates meters etc pre made for users to copy paste into their projects Go to hard drive gt program files gt Metrix 4 folder gt Resource Folder The TPY files are template files NOTE use copies of these to avoid ruining the templates These files are typically very similar to Gulf Med but they have a project element within them Navigating Large Projects Projects may contain hundreds of meters For these instances navigating through the project tree is made simpler by sorting project elements by parent or by type The option to change from the standard tree structure to the sorting option is found just above the left hand pane Shown below in Figure 2 10 If you do not see these bubble options directly above the project tree go to the View Show List View to make it appear Show Tree Structure C Only Show Sites Y Sort By Parent Figure 2 10 View Options Items can be sorted by Meter Area or Site Figure 2 11 below shows a meter level view sorted by parent Notice in that the Tree Diagram has been replaced with a listing Click on each of the drop down menus to see what options are available ENERGY CONSULTING 21 Metrix 4 User s Guide Chapter 2 General Proj
125. ome restrictions that should be noted No commas should be in any field No dollar signs First 6 columns must have data The name and account fields must be less than 22 characters To properly save the file in Excel save the file with the type Comma Separated Values but type the filename inside quotes with VA1 appended to it so that Excel saves the file using the correct extension For example in the filename dialog you can name your file VARIABLE VA1 Table C 6 Columns for VA1 Format Col Col Column Name Field Value Data Source Example 1 A Format ID VAI VA1 2 B Variable Name Variable Name Widgets 3 C Year Meter read date year 1999 4 D Month Meter read day month 3 5 Meter read date day 5 6 F Quantity Variable Quantity 1234 56 TE TS A S 113 ENERGY CONSULTING
126. on Ratchet Some utilities charge customers for demand based upon not just the current billing period s metered demand kW but they also take into account previous months metered demand A typical ratchet may read like Rate Schedule A set of tariffs that present the prices to be charged to the customers of the utility company for services or supply of commodity It also lists the responsibilities of the utility company Read Date Calendar date on which meters were read and recorded Regression Regression is a statistical operation which graphically can be described as drawing a straight trend line or best fit line as close to all the points in a graph as possible The best fit line or regression then is said to represent the points in the graph Also called Tuning Rider A variant to a tariff or rate schedule Riders tend to make rates very confusing because bills don t always tell you that a rider is being applied As a result sometimes you cannot calculate your rate by hand because you don t know all the charges being applied Savings The reduction in the quantity of energy or water that can be discerned from utility bills This is similar but not the same as the term usage avoidance which some people use What makes it more confusing is that some people use the word savings to mean cost avoidance energy avoidance or the reduction in usage or cost that can be determined from utility bills Secondary Service
127. on Modifiers Tab as in Figure 3 26 Notice that 25 has been inserted into the CIgDD field and 10 has been entered into the Baseload field Notice the fields below you can also modify coefficients for HDD and custom variables Also you can apply a Regression Modification to a specific TOU period ERGY CONSULTING 58 Metrix 4 User s Guide Chapter 3 Populating the Databases Measure Setup Measure History Regression Modifiers Change in regression Parameters 0 Change Quantity Modifiers Demand Modifiers Coefficients p Offek PamPk SuOfPk OnPk OffPk PatPk SuDfPk Baseload 10 00 1 00 Of 1 00 0 00 0 01 0 0 HtgDD x 0 00 1 00 1 00 0 00 0 00 CDD 2500 Variable 1 2 0 00 0 00 Variable 2 Variable 3 x o Base Temps HtgDD ClgDD D Enter changes for regression coefficients and degree day base temps E g for a modification which increases annual space heating by 10 enter 10 for the HtgDD Coefficient under Quantity Modifiers Metrix will convert your inputs into an equavelent Factor History based on the time intervals that you select in the Factor History Subform 1 399999 RRIREEEEE dd ddd 111 29 333333 Figure 3 26 Regression Modifiers Tab Metrix will automatically fill out the Measure History form to adjust your Target The Measure History will begin with the first period of your effective d
128. onsumption and demand costs broken out from the total amount we can check the Detailed Cost box and add that data to our project For Supply and Power Factor a zero must be entered because we do not have data for those fields The Detailed Cost check box for Supply must be cleared also A feature in Metrix 4 4 is the estimated bill column It is useful when utility companies miss their meter read dates the bill is often an estimate based on the same month from the previous year bill matching only to be corrected after the next meter read Having the ability to indicate whether a bill is estimated or not can save a lot of headache when trying to explain an outlier month where usage was expected to be different than it appears RkVAh 054 Power Factor 0 Estimated Reriod End Tota Misc Credit 08 15 1936 Rill Cut Off Date far Rennrtinn Prmnses Figure 3 7 Indicating an Estimated Bill ENERGY CONSULTING 39 Metrix 4 User s Guide Chapter 3 Populating the Databases Importing Bill Data Utility bill data is imported in the mt1 file format This section covers how to import bill data that has already been formatted into the import file format For details how to create an mt1 file see Appendix C on Import file formats 1 From the Tools menu choose Import or click the Import button E on the Toolbar or go to Tools Import The File Select dialog box appears shown in Figure 3 8 Please Select file s t
129. orm All Points selected Reselect all except the summer months as described in step 2 Use the Tree Structure to select the Modification Item attached to this meter This will display the Modification Setup Data Form Note that the first Specification Option is selected This option tells Metrix to modify the regression coefficients for the period defined by the Effective Dates 6 15 1990 2 15 92 Click Regression Modifiers to view the Regression Modifier Data Form as shown in Figure 3 21 ENERGY CONSULTING 52 Metrix 4 User s Guide Chapter 3 Populating the Databases Modification Setup Modification History Regression Modifiers Change in regression Parameters 0 No Change Quantity Modifiers Demand Modifiers Coefficients 5 5 gHPk PartPk SuOfPk OnPk OffPk ParPk SuOfP Baseload 86 90 HtgDD 00 0 29 80 Variable 1 4 0 00 Variable 2 22 0 00 Variable 3 0 00 Base Temps HtgDD 0 0 ClaDD 0 0 Enter changes for regression coefficients and degree day base temps E g for a modification which increases annual space heating by 10 enter 10 for the HtgDD Coefficient under Quantity Modifiers Metrix will convert your inputs into an equavelent Factor History based on the time intervals that you select in the Factor History Subform
130. ral Gas Meter Primary Gas rx MEUS i CES iie 8001 7504 u ER dis Japan aD Japan 700 UR CE a ee oe en e Temperature Sensitive 85 o oO i Usage en en e en Balance Point Temperature Non Temperature Sensitive en RB e e 45 50 55 50 65 68 70 75 80 Temperature F Figure 4 8 Therm day vs Average Outdoor Temperature We can view the same type of graph for natural gas usage in Figure 4 8 Notice that the major difference between the two graphs electric and gas is that the Temperature Sensitive trend slopes up and to the left rather than up and the right As it gets cooler outside they use more gas therefore they use gas to heat the building GY CONSULTING 81 Metrix 4 User s Guide Chapter 4 Complete Meter Tuning Baseline Equation This is always displayed in blue font at the bottom of the Meter Tuning Tab Understanding the modifiers and coefficients in this equation can help you better tune your project Usage Coefuays Naays Coefcop CDD s Coefya var N var2 var3 Constant e Usage The baseline amount of a utility for a billing period The regression coefficient for this variable e Total quantity of the given variable during the billing period e Consta
131. reporting This power packed version of Metrix combines exciting new features with the established functionality that energy engineers and energy managers have come to rely on With Metrix you can e Identify problem areas or equipment failures in order to reduce operating cost overruns e Determine whether you are meeting your utility performance targets e Compare the operating costs of different facilities Compare the cost effectiveness of available utility tariffs for your usage profile e Track utilities for any type of facility commercial industrial institutional residential etc e Track almost any type of utility including electricity natural gas water heating oil propane LP gas solid waste sewage and so on e Track one meter or hundreds one building or many sites Who Uses Metrix Metrix is for anyone who tracks budgets and verifies utility operating costs and savings Metrix provides real answers for tough questions e Is our energy management program saving as much as we expected e Where is my best opportunity for reducing operating costs e we achieving our performance goals e Would be better off with a different rate tariff Metrix is used by facility managers energy managers property managers energy analysts and energy consultants who want to track utility usage and determine cost avoidance Some of our customers who have found the greatest benefit include school distr
132. rix needs to assign a name to the weather location This is defined by Source Location ID Enter in the 3 to 4 letter airport code where the weather data was collected Example LAX for Los Angeles California Major cities will have more than one airport user discretion is required to determine which is most appropriate Weather start and end dates must be entered as well Tip bill dates often do not perfectly align with the 365 day calendar year It may be necessary to add an additional month of weather at the start or end of the tuning period to cover any days that spill over into the previous following year Weather Information Weather History Degree Days Name MOBILE AL Source location ID MOB Description MOBILE AL Weather history Start Date End Date Figure 3 11 HDD in the Degree Day Tab Weather History The weather data is in Hi Lo format for this sample project A graphical representation of the data is at the top of the screen All data may be edited directly into this register This is useful for correcting errors or fill gaps that may be the result of severe meteorological events example hurricane tornado etc Typically users will use an import file to keep this information current Import files are discussed in a later section ENERGY CONSULTING 43 Metrix 4 User s Guide Chapter 3 Populating the Databases Weather Information Weather History San Diego CA Daily Temperatures Z Max Temp Min
133. s Because 0 is entered for the Standard First Tier Metrix knows that there are no standard tiers for this Charges item in a standard tier the Size is fixed kWh And because 1 is entered for the Load factor First Tier Metrix knows that starting with the first tier all tiers are to be interpreted as load factor tiers for this Charges item in a load factor tier the Size is hours of use Note As an added complication though not in our example some rates change back and forth between standard and load factor tiers For example a rate may start out with standard tiers let s say 0 06 kWh for the first 100 000 kWh and 0 05 kWh for all remaining kWh up to 400 hours of use after which the price is 0 04 KWh The Special Load factor Provisions fields would have 1 for the Standard First Tier 3 for the Load factor First Tier and 400 for the Load factor Threshold See the generic rate named Std Lf Combo to see how this rate is entered A very important variable in load factor rates is the demand which is multiplied by the hours of use In most rates this is the Billed demand but it can be the Metered demand You specify which type of demand to use in the Load factor Tier Limits field in the Utility Rate Details Data Sub form To verify that the load factor rate has been entered correctly open the Primary Elec Meter Item to which it is attached You see the Meter Register Data Form displaying the calculated costs for the SimActual Scenario
134. s Curent Date 5 15 2005 JV Use System Date Entry Close 7 30 1995 Close as Of 1 1 1900 Milestone Dates Start Date End Date Closed As Df Tuning 7 30 1935 8 15 2005 8 15 2005 Installation 7230 1997 7 30 1338 Performance 7 30 1838 7 30 2003 12 1 1800 Figure 4 14 Closing the Baseline Tuning Period ENERGY CONSULTING 88 Metrix 4 User s Guide Chapter 5 Special Advanced Topics Chapter 5 Special Advanced Topics Chapter 4 describes all the features of Metrix that you need to work with most Projects This chapter describes advanced features of Metrix that you need for unusual situations It covers advanced aspects of Project layout meter tuning measures modifications and rate tariffs Quality Control The Quality Control feature is based on a list of rules of thumb which you can use to check your Project at any time When you use this function Metrix checks to see if your Project violates any of these rules You run quality control by choosing Quality Control from the Performance menu or by clicking the Quality Control button of the toolbar It is advisable to run quality control periodically as you set up a new Project In addition Quality Control also runs every time Metrix is opened Immediately after you run Quality Control the Quality Control View appears below the Tree Structure Any Item that has a problem is displayed
135. select to apply it to included bills or excluded bills Both boxes checked means a full bill match Only checking the excluded bills is a partial bill match where selected bills are still being tuned with a regression equation 3 Then for the bill matched bills Metrix determines an average consumption value 25 days and 1000 kWh 40kWh day A common mistake is to expect the exact same amount for every bill in following months but not every time will corresponding annual bills have the same number of days For a fair comparison both bills must have the same number of days therefore estimation is necessary 4 An average cost value may be necessary if no rate has been attached to the bill matched meter The total cost of the utility is averaged in a similar manner total cost days or consumption cost days Bill Matching One Bill If a bill causes an unacceptable fit but your knowledge of the facility dictates that this usage is reasonable for this month and will be repeated in following years it is possible to compare future usage during this month without using the regression line Follow these steps 1 Click the Bill Match button on the Meter Tuning Tab 2 Find the meter you are tuning in the Tree Structure You will see that a Bill Matching Modification appears underneath the meter as shown in Figure 4 10 Meter SECOND E 32 Modification Bil Matching Figure 4 10 Meter with Bill Matching Modification Attached
136. st Avoidance Cost Savings Last Year s Bill This Years Bill Baseline what your building would have used before the This Year s Bill energy conservation measure Cost Avoidance There are benefits to both approaches The table below lists the benefits of both the Cost Avoidance and Cost Savings approaches Table 1 2 Utility Bill Comparison vs Utility Bill Analysis Cost Savings Cost Avoidance e Will not need to Tune meters e Will need to Tune meters e Simpler method to use e More complex method e Do not need to learn concepts behind or Need to understand the concepts behind how to use Baseline Target and how to use Baseline Target Modifications Measures Tuning Modifications Measures Tuning e Requires less work e Requires more work e Easy to explain to others e Can be difficult to explain to others e Less accurate representation of savings e More accurate representation of savings from energy conservation projects from energy conservation projects e Can compare a Baseline which is based SED year upon one year of data to current bills make Cost Savings reports but NOT e Can make both Cost Avoidance and Cost Cost Avoidance reports Savings reports Established Metrix Features Q Correction for weather data Metrix allows you to correct your utility bills for changes in weather This allows you to make fair annual comp
137. t Layout All bills that end between June 15 and July 14 will be considered a June bill Since the bill ends on June 22 it is between the period and the bill will be assigned to the month of June for reporting purposes In the Project Preferences tab there is an option to set all bill cut off dates for all meters manually or automatically Tuning Tab Also see Complete Meter Tuning for information concerning interpreting the data displayed in this data pane Tuning Period this is set by the of Bills and Start at Check the starting on and ending on dates to verify settings are correct e of Bills this is the of sequential bills that a user would like to use as the basis for the Baseline Equation not necessarily the total number of bills Start at sets the first bill of the of sequential bills based on the bill register i e if there are 13 bills and you tune for 12 months setting this to 1 excludes the last month TOU Period Only if Sum TOU periods has not been checked Choose the desired consumption data to tune for Show Eng Day displays the ratio of utility unit per day for each bill in the mini register Show Degr Days displays the number of Degree Days for each bill in the mini register Tuning Closed Check Box checking the box for closed will lock the current tune of the meter in whatever state it is in Tuning Manual Check Box checking the box for manual allows users to d
138. the Cost Calculation Method selected in the Meter Setup Data Form Actual Scenario reported usage and cost are taken directly from the utility bills for the meter These are entered by the user or automatically imported into Metrix if the bills are available in electronic format SimActual Scenario utility usage is taken directly from the utility bills as it is in the Actual Scenario But costs are calculated by Metrix based on the Cost Calculation Method selected in the Meter Setup Data Form You can use the SimActual Scenario to validate the utility billing or to compare the impact of alternative rate tariffs on utility bills SimActual Tab The cost values in this register are calculated using the Actual Consumption or Demand according the rate for that meter This is also subject to the cost calculation method selected see ENERGY CONSULTING 31 Metrix 4 User s Guide Chapter 2 General Project Layout Meter Setup Tab If no rate has been entered it will be a duplicate of the Actual Bill Register It will always display grey ed out data and users cannot directly edit the fields in the register This information is useful when comparing billed costs to published rate tariffs especially when there is a billing discrepancy Sometimes alternate rates are available for a given building by modeling both rates users can compare if to see if the alternate is more beneficial Import Tab Name Utility Account Metrix uses these
139. ting up an energy savings program for a facility Once you understand how much energy you are using and where it is being used you can determine where you can most easily save energy Energy Avoidance Almost the same as Energy Savings but different Energy Avoidance is the difference between what how much energy would have been used had no ECM s been installed and how much energy was used now that ECM s have been installed Not many energy analysts use this term for some reason Equipment Rental Equipment such as a water heater or a chiller that is rented from a utility company usually on a monthly basis Estimated Bill 98 ENERGY CONSULTING Metrix 4 User s Guide Appendix A Glossary of Terms Sometimes utilities cannot read a customer s meter due to factors such as employee illness equipment malfunction etc When this occurs the utility may choose to charge the customer for an estimated bill The estimated bill is determined based upon past usage history In most cases the Estimated Bill is corrected the following month Some gas utilities will send their customers monthly bills with Estimated charges for the past month and the Actual charges for the month before that Since the customer already paid the Estimated Bill for the prior month the Actual Bill is used to true up the account by charging or crediting the customer for the overage or underage that the customer did or did not use for the estimated bill period
140. two season gas rate From the File menu choose Open Example and click rafe_ex2 Switch to Rates View Note the GNG GS1 Rate Item which is attached to the natural gas meter It has two Charge Items labeled Winter and Summer Click the Winter Charge Item to display its Data Form as shown in Figure 3 36 The key fields for specifying the season are the Starts On and Ends On dates In this example the winter charges are in effect from October 1 through April 30 The prices for the winter months are 0 559 therm for the first 5 000 therms 0 513 therm for the next 5 000 therms and 0 478 for all additional therms If you open the Summer Charge Item you see its effective dates are May 1 through September 30 with lower prices per therm ERGY CONSULTING 66 Metrix 4 User s Guide Chapter 3 Populating the Databases Charge Setup Charge Detail Name winter Type Consumption Period Peak Units Time Period Utility Unit Therm Starts on 10 1 m Unit Content 100000 0 Ends on 4 30 ES Figure 3 36 The Winter On Peak Charge You can create as many Charge Items as you need If the rate differed over four seasons you could set up Charge Items for Summer Fall Winter and Spring If your effective dates overlap or if there is a gap a period uncovered by a Charge the Quality Control check issues a Warning or Error If a billing period straddles a change of season for example p
141. u might want to add the Bolts Produced Variable to the Bolt Assembly Line Area and the Widgets Variable to the Widget Assembly Line Area Meter the device which measures utility use and possibly demand You should have historic and current utility bills for each meter you wish to track electricity natural gas water solid waste etc Adding data to meters will be discussed in later sections GY CONSULTING 18 Metrix 4 User s Guide Chapter 2 General Project Layout Sub meter a meter which is attached to a meter for example it is downstream from a meter It is usually used to subtract utility use from its parent meter For example if the customer adds a new piece of process equipment in year three of a performance contract and you are sub metering its energy usage you can use a Sub meter Item to subtract that use from the parent meter Be aware Sub meters in Metrix are not like sub meters in real life Also you cannot make reports at the Sub meter level in Metrix Suppose you have a couple of main meters in your facility and a collection of sub meters In this case you might want to represent this configuration in Metrix by listing the real life sub meters as Meters in Metrix and ignoring the main meters There are many different ways to do this without double counting usage at the Project level The main reason for using a sub meter is to remove recently added new usage building additions from your savings equation
142. uilding at the same address its own site For an address with many buildings each building would be better designated as its own area within the same site Site Information Tab Name Description Country these are self explanatory Tip keep in mind that large projects can be sorted by description as well Current Floor Area Metrix automatically sums the Current Floor Area field from all building areas that are part of this Site Groups see section How to Use Grouping in Metrix on page 92 Contact Information Tab These are self explanatory Enter contact info pertaining to that particular site where applicable This information is also used by the Metrix Report Maker when using the Email Report feature Area Data Panes As a reminder all areas at a site will have the same weather of that site Typically they also have the same address but are unique in construction to warrant splitting the utility tracking An example east and west wings of a single campus where usage is not similar Area Information Tab Name Description Country State are all self explanatory Tip keep in mind that large projects can be sorted by description as well Type of Area select from the drop down menu Groups see section How to Use Grouping in Metrix on page 92 Current Floor Area this is editable only from the fields below with the column headers Date Total Area sqft Percent Condition Comments If a user is interested in be
143. underlined after auto tuning can be selected deselected which ever it currently isn t to get a better set of statistical indicators That does not necessarily mean the fit is better For example if half of winter bills are underlined for a gas meter that could only represent half the trend that would be improper You must determine whether these selections and de selections are valid ERGY CONSULTING 82 Metrix 4 User s Guide Chapter 4 Complete Meter Tuning Meter Setup Register Tuning Scenario Inspection SimActual Import Graph 12 bills start at X axis Cooling DD Moving 5 4 starting on 4 3 2002 ending on 4 2 2003 Electricity Period Meter SECOND E 7 2 2002 On Peak Demand 700 000 Show Eng Day DegrDays 650 200 600 000 50 000 500 000 nPeak kwh 4 05 02 2002 19374923 06 03 2002 19496874 07 02 2002 21188940 oo 4 08 01 2002 18414561 E 400 000 08 30 2002 20487724 350 000 10 01 2002 20640161 300 000 y 10 31 2002 18246878 250 000 y 11 27 2002 15504257 200 000 y 12731 2002 16631031 150 000 y 02703 2003 17713344 y 03 04 2003 15198110 y 04 02 2003 15411524 05 02 2003 16265179 8 10 12 06 03 2003 16600543 Cooling D Days day F Tuning Tune with Bal Point Thresh Regr coeffic T Stats Closed HDD Baseload Statistical Indicators Manual CDD Caf 61 0 H
144. uper Off Peak Supply 39 AM On Peak Power Factor Cost 40 AN On Peak Power Factor 96 Integer 0 100 97 41 AO Off Peak Power Factor Cost 42 AP Off Peak Power Factor 96 Integer 0 100 97 Partial Peak Power Factor 43 AQ Cost 44 AR Partial Peak Power Factor Integer 0 100 97 45 AS Super Off Peak PF Cost 46 AT Super Off Peak PF Integer 0 100 97 gt S 107 ENERGY CONSULTING Metrix 4 User s Guide Appendix C Import File Formats Default Conversion Factors and Energy Units in Metrix The tables below list the default conversion factors for the different fuel types The utility abbreviations can be used in column 4 in mt1 files and the conversion factors can be used in columns 5 and 6 of mt1 files Table C 2 Default Quantity and Demand U nits Quantity Demand Btu Unit Btuh Unit Utility Fuel Code IP Unit Conversion IP Unit Conversion Factor Factor Chilled Water 12 000 00 Tons 12 000 00 Electricity E kWh 3 413 00 kW 3 413 00 Natural Gas G Therm 100 000 00 Therm hr 1 000 00 N Gas Vol V CCF 102 000 000 KBtuh 1 000 00 N Gas LgVol U MCF 1 020 000 00 KBtuh 1 000 00 Propane P gal 91 500 00 gal hr 91 500 00 Fuel Oil O gal 139 600 00 gal hr 139 600 00 Wood X Cord 17 100 000 000 kBtuh 1 000 00 Steam T klb 1 040 000 00 kBtuh 1 000 00 Solid Fuel
145. vailable is the Total column Metrix will use the total cost consumption or cost demand Taxes Credits and Miscellaneous Costs are all included in this calculation ERGY CONSULTING 28 Metrix 4 User s Guide Chapter 2 General Project Layout method making it less precise It is helpful as an estimate tool or when rate tariffs are not available Min Unit over rides the any unit pricing below the set limit If the Monthly Minimum radio button is selected users may enter a monthly minimum cost e Min over rides any bill lower than the set limit Notes Allows users to record or communicate information of their choosing Register Tab This contains the Actual Utility Bill Data for the meter See section Entering Historical Data for more information concerning Data Entry and Feature Available to all Data Registers TOU Periods Time Of Use Periods Adds columns to the Bill Register when more than one consumption quantity is available Detailed Cost Adds a cost column next the consumption column in the Bill Register when utility bill data is available with the unit cost broken out from the total cost that is with no tax or service charges 1 Day of First Bill All of the bills in the register except the first contain only one date the end date Implicitly the start of each bill is the end of the previous A common question is how to ungray the 1 day of bill box When the bill register is not all the way at t
146. what month will be at the end of a 12 month year when reporting For example if your fiscal year ends September select that month from the drop down menu ENERGY CONSULTING 22 Metrix 4 User s Guide Chapter 2 General Project Layout Current and Entry Close Dates e Current Date Use System Date Metrix is asking the user what day today is By checking the Use System Date box the program will sync with the date on your computer It is recommended to leave this box checked e Entry Close Only if a project has been protected with a Read Only Password will this setting take effect Allows users to lock out data from being adjusted beyond a certain date Password settings are found under the File Set Password Milestone Dates serves as helpful reference information to users Most commonly associated with performance contracting This information is optional Contact Information Tab All of these fields are self explanatory Fill in company information and any contacts as desired This information is also used by the Metrix Report Maker when using the Email Report feature Note these fields are applied to the project file not to your installation of Metrix The contact information that can be entered in the Pre Project Settings under Tools Options is assigned to your installation of Metrix ENERGY CONSULTING 23 Metrix 4 User s Guide Chapter 2 General Project Layout Project Preferences Tab Project I
147. will select or de select any that would result in a better set of statistical indicators e Max Delta T Demand Tuning Metrix will only consider the day with the maximum number of Degree Days for a given bill This only applies to demand metering where the demand is billed for the highest value in a given period but is not a requirement for all demand situations e Guarantee Zero Net Bias in Regression Sets the net zero bias to zero Note may cause meter tunings to change Tunes the regression equation so that the Baseline values are within 00596 of Actual values in the Base Year It is highly recommended this remain checked e Use Zero Default Degree Day Threshold if unchecked the default degree day threshold is 2 degree days Any bill period containing less than 2 degree days will be automatically de selected Example a gas meter would have no HDD in summer so those months would be de selected Checking this box is optional but recommended The reason is that bills with few degree days will tend to have a zero for the weather related term in the Baseline Equation anyway so they can be left as selected e Set All Bill Cutoff Dates to Metrix will set all bill cut off dates to match the options that are selected Set All Tuning Periods to Metrix will set all tuning periods to match the setting selected i e number of bills and starting bills e Automatic Bill Cutoff Dates by pressing this button all bill cut off dates will be
148. x 4 User s Guide Appendix A Glossary of Terms Mid Peak Mid Peak is another name for Park Peak or Shoulder which are TOU Periods A Mid Peak period might be from 8am to 10am and from 4pm to 6pm on weekdays MMBTU One Million Btu Multiplier Often referred to as Meter Constant See Constant Non Firm Service Some utilities allow customers to receive Non Firm service as opposed to Firm service Non Firm Service means that the utility does not guarantee service all the time and therefore is less expensive However in times of power shortages non firm customers may not receive any power at all as happened to many non firm customers in California during the notorious summer of 2001 Non Temperature Sensitive Usage The energy used that is not related to weather This would include computers lights pumps kitchen equipment etc Off Peak A time period determined by a utility company to reflect the time of day when demand is at its minimum Usually Off Peak represents evenings nights and weekends On Peak A time period determined by a utility company to reflect the time of day when demand is at its maximum Usually On Peak represents weekday hours Power Factor A method of determining the quality of energy being used at your facility Facilities using large amounts of uncompensated fluorescent lighting or ac induction motors often have lower power factors Power factors are measured in percentage and customers are often billed
149. x tariffs Note that utility rates only need to be set up once The System Administrator can store rates in the Library Any time that rate is needed you can simply copy it from the Library and into your Project To explore some advanced uses of Utility Rates review the topics below Time of Use Rates setting up rates that vary with time of day for example on peak off peak Seasonal Rates setting up rates that change with the season for example summer versus winter Load factor Rates also known as hours use electric rates where kWh block sizes depend upon peak demand Differing Rates by Scenario selecting different rates for different Scenarios Replacing Rates over Time entering a time history of rates for a meter Time of Use Rates In time of use rates also known as TOU rates or time of day rates the price schedule varies with time of day and week These are almost exclusively electric rates To see an example of a simple TOU rate from the File menu open the Library file rates by Find the 2TOU w Dem Rate Item in the Generic Electric Rates section This is an example of an electric rate with two time of use periods On Peak and Off Peak During the on peak period the energy price is 0 048 kWh and during off peak it is 0 030 kWh There is also a demand charge of 4 833 kW which does not vary with time of use To see how this rate is set up in Metrix click the On Peak kWh Charge Item to open its Charge

Download Pdf Manuals

Related Search

Related Contents

NCV73830V1GEVB Manual  ENEOS 油膜取りウォッシャーR  Acronis True Image Home 2013  { 取扱説明書をよく読んで  Fedora8-Xen Installation Guide  SpiraTest User Manual Version 1.5 Inflectra Corporation  Imetec BELLISSIMA GH16 400  Profound Meditation Program 2.0 - User Manual  coupe-herbe/taille-bordure rechargeable au lithium  STEP Warmfloor™ Manuel d`installation  

Copyright © All rights reserved. Failed to retrieve file