agrē exports a spreadsheet (referred to as a template or worksheet) for you to enter new rates and shrinkage values, then imports the new values to your database.

 

Creating Grading Factor Rates Worksheets

Navigate to Grain > Manage > Import Grading Factor Rates.
The Import Grading Factor Rates window opens.

To create an empty worksheet (column headers only):
Select Export Worksheet  

To create a worksheet with your existing rates:
Optionally change the Export Rate selection criteria, then select Export  

Export to Excel as you normally would.
(config U) Remember to save the file on a local drive or a local network drive.

 

Filling in the Grading Factor Rates Worksheet

Follow the usual worksheet rules: don't add or remove rows or columns; leave fully empty rows and fully empty columns blank.

Once the new values have been entered, save the spreadsheet. The data can now be imported into agrē.

 

Business Rules for Worksheet Values

Commodity Code field and GF Rate must always be populated.

Since shrink is not linked to a location in the same way that a normal grading factor rate is, shrink % can be imported only for the <Company> location.

A row can have only a Shrink Pct without an Adjustment Code or Rate - but - if you do enter an Adjustment Code you must also a Rate.

The worksheet can contain values for only one location.

Min and Max limits for adjustment rates apply.

Shrink Pct is only applicable for the Moisture Grading Factor (and <Company Location>).

You can have Shrink rates that do not have a corresponding Adjustment rate.

 

Importing Grading Factor Rates into agrē

Use the worksheet you created and edited to bring your updated rates into agrē.

To import grading factor rates into agrē:
* indicates a required field

Navigate to Grain > Manage > Import Grading Factor Rates.
The Import Grading Factor Rates window opens.

In the Import Rates section, select browse files  to select a worksheet to import.

(config U) Navigate to where your worksheet is stored, select the File Name*, then click Open.

Select Remove Existing Rates First to delete existing rates for all Commodity/Adjustment/Location combinations in the worksheet.
For <Company>, this will delete all the shrink percentages for all commodities in the list (if a value for shrink % is entered) before updating with new values from the worksheet.

Select Only Update Existing Rates to add or update only the rates in the worksheet and leave other rates unchanged.

Select Import  and confirm the number of rows.

The new rates imported and an Import Completed message appears.
Click OK to continue.