Hach WIMS Client will be updated in the next release (currently at version 7.4.1) to include these two statistical base codes.

If one of the following messages appear when locating Michigan eDMR entries for NPDES Row Values (Part A), then follow the steps below.

	MAX MONTHLY GEOMETRIC MEAN
	MAX 7-DAY GEOMETRIC MEAN

First of all, let's get in the right place.

1. Run Hach WIMS Client
2. From the menu bar, select Design
3. From that list, select Spread Report
4. Click on a cell to begin the entry and select:
• Locate
• eDMR / Electronic Report Link
• Michigan eDMR
• NPDES Row Values
5. Now you should see the following display for the Michigan eDMR Part A
   
6. The top window may be blank, to fill this in:
• Click Load button in top right corner
• Navigate to your latest Michigan DMR Part A XML file (something like DMR_PartA_2014_10.xml where 2014 is the year and 10 is the month).
• Select that file and click Open button
7. When we selected Fecal Coliform, we had two entries in the lower right in our example:
• AVERAGE requests the statistic Max Monthly Geometric Mean
• MAXIMUM requests the statistic Max 7-Day Geometric Mean
8. Select the variables for the entries, in our example we selected variable 4021 - Effluent Fecal Coliform, you may need to select something different
9. To show the symbols, click the "Print <,>" box.
10. Click Ok button

Spread Report Design will go through and create necessary formulas and format the report for you. However, in our case, we get both of the messages and we need to fix that.

The Quick Change:

Change the formulas according to the following:

How To Change the Formula:

Once the Michigan Part A entry is created for the parameter, you will need to locate the cell to be changed.

1. Look for the statistical base code, it will be the second column, first row of each significant area of the parameter (our example parameter is Fecal Coliform).
2. Move the cursor to the next column and down one cell at a time, while watching the Formula Bar.
3. Find the cell with the above Formula Inserted in the Formula Bar.
4. Click the elipse [...] button to the left of the Formula Bar to open the Spread Formula Editor.
5. Edit the formula to match the text in Change To This column for your variable.
6. Click OK button.
7. Repeat these steps for any parameters using either of the two statistics mentioned above.

Don't foget - save the form when you finish making changes.

So in the picture example above, I have "Max 7-Day Geometric Mean" in cell D28, and my formula in E29 is GAVGZ(4201,1,"R",0,1). I click on the elipse button and change it to GMAXZ(4201,1,"R",0,1) and click OK button.

You are done!