MP-Web Factor Tables

How to manage MP-Web Factors

Introduction

Factor Tables can be used to reference changing values consistently in MonitorPro calculations. These could be Emissions Factors or commonly well top or ground survey levels. Changes over time can be recorded, so historical updates can be accounted for and correct values referenced if historical data is imported or updated.  

The example below for Groundwater Wells and their corresponding changes over time.

Adding a new Factor Table

Complete the General Tab with a suitable name for later referencing. Do so in a manageable way. For example it won't be ideal to add every Sample Point in the database to one table. Break this up into more manageable subgroups around for example Sample Point Group or type/area of the locations. 

Factors can be applied as a single value applicable to all locations. This might be the case with examples such as Emission Factors which would be applicable at any/all locations where they are referenced. 

This can be made more granular with reference to a specific Location (Site/Data Type), a Sample Point Group, or most commonly for well top surveys, at individual Sample Points. 

Depending on the option chosen, the unselected will update with the required Objects to select from the left (unselected) to the right (selected). Once these have been added, Save and you'll be prompted if you'd like to edit the Grid. Confirm and then proceed to set up your Grid. 

You'll first be required to select a date from which the Factors will be applicable. In the example of well tops, this is generally the survey date. 

Users can manually add the values cell by cell. Equally, the Export Sheet option can be used to update the values in Excel. The Import Sheet can then be used to mass update the Factor Table.