McPIQ Tips/Help
McPIQ On-Line is based on a database containing two types of information on crop varieties:
McPIQ is best described as a Variety Decision Support Tool, which growers use to identify varieties which suit their agronomic and management requirements. While growers can select varieties directly from a list of all varieties for a crop, McPIQ is best used to pre-select varieties which match agronomic or other descriptive criteria. Further, more detailed comparison is then conducted on these varieties. Thus the grower decides which variety characteristics are most important, and finds information to support a decision as to which variety (or varieties) is best suited for the grower's needs.
McPIQ involves the following basic steps:

How would you like to choose varieties?
The two options are:
Which attribute would you like to use to select varieties?
Begin with the attribute which is most important to you as a management consideration. In the selection box, attributes appear in order of common importance—for example, in oats, lodging and crown rust would be considered by many growers to be among the most important attributes, so they appear at the top of the list; in canola, blackleg resistance commonly would be considered to be of primary importance, so blackleg appears at the top of the list for canola. There are three types of descriptive attributes, each of which will result in the next screen step being slightly different (further explanation with next screen).
What attribute value or level would you like to use to select varieties?
There are three types of descriptive attributes, each of which will result in the action of this screen being slightly different. They are: ratings, descriptions, or numeric ranges, which differ as follows:
[Test weight in lb/bu measure of density, relative to check (currently AC Assiniboia)]
In this case, you will choose to do selections on a "equal or greater" or "equal or less" basis. For example, if for oat-test weight you specify "equal or greater than" and "1", you will get varieties with a test weight that exceeds that of AC Assiniboia by at least 1 lb/bu.
The result of the selection above will be a screen that lists varieties which match the chosen criterion. If no varieties match, you will be given opportunity to select another attribute or attribute value.
Whether you chose the direct selection option or the attribute matching option, you will now have a list of varieties on the screen. Choose up to five for which you wish detailed comparative performance and/or descriptive information. You are currently restricted to five varieties so that data processing time does not become excessive.
Which check variety would you like to use?
A check (or reference variety) is a variety you wish to compare the performance of the others against. The best choice for a check variety would be one with which you have some experience and has been on the market for at least two or three previous seasons.
Which performance measure would you like to see?
Performance measures or attributes are data which has been collected in field trials across Manitoba. Average yield in kg/ha is always determined. Where resources allowed, data such as test weight, height, days to maturity, protein content, pod height, etc. have also been collected, and if available were included in the database.
What output would you like to see?
and Which trials would you like to use in the performance analysis?
There are two types of output from which to choose:
You may also choose which trials (location-years) to include in the calculation of variety performance. The options are:
Note that performance data will only be provided if there are at least two applicable trials (location-years) in the database.
The output will look something like:
|
Variety |
Performance compared to check. |
Number of Trials |
Variety average performance |
Check average performance |
|
AC Carnduff |
107 |
19 |
1,996.9 |
1,859.5 |
|
AC Emerson |
102 |
52 |
2,011.0 |
1,980.0 |
|
AC Watson |
104 |
25 |
1,945.9 |
1,878.2 |
|
CDC Valour |
90 |
24 |
1,724.9 |
1,918.8 |
|
NorLin |
100 |
102 |
1,922.9 |
1,922.9 |
|
1084 |
113 |
10 |
1,905.3 |
1,687.4 |
|
Variety |
Lodging |
Height |
Maturity |
Oil |
SeedSize |
|
AC Carnduff |
good |
tall |
late |
high |
large |
|
AC Emerson |
fair |
medium |
medium |
medium |
large |
|
AC Watson |
good |
medium |
medium |
medium |
large |
|
CDC Valour |
fair |
medium |
early |
medium |
large |
|
NorLin |
good |
medium |
medium |
medium |
medium |
|
1084 |
good |
tall |
medium |
high |
medium |
For which location would you like to use all available years in performance analysis?
A caution: only a few locations have sufficient data for this option to be valuable (i.e. multiple years of experience for varieties in question). Those most likely to have multiple years of data are indicated in the location list with a "*" at the end of the town name, but whether or not there is sufficient data will depend on the variety. Output will not be provided if there are less than two trials to include.
For which year would you like to use all locations in performance analysis?
Output will not be provided if there are less than two trials to include.
MCPIQ Variety Performance and Description Output
The output table looks like:
|
Variety |
Performance compared to check. |
Number of Trials |
Variety average performance |
Check average performance |
|
AC Carnduff |
107 |
19 |
1,996.9 |
1,859.5 |
|
AC Emerson |
102 |
52 |
2,011.0 |
1,980.0 |
|
AC Watson |
104 |
25 |
1,945.9 |
1,878.2 |
|
CDC Valour |
90 |
24 |
1,724.9 |
1,918.8 |
|
NorLin |
100 |
102 |
1,922.9 |
1,922.9 |
|
1084 |
113 |
10 |
1,905.3 |
1,687.4 |
An important feature of the reported data is that "all available trials" means all trials in which both the variety being calculated and the check variety appeared. The premise is that two varieties can be compared only if they were grown in the same trial.
Thus the "check average performance" is based only on the same trials as the variety being compared, even though the check variety may also have been grown in many other trials—this is why the check average frequently differs depending on the variety being compared.
The "number of trials" in the table is the number of trials in which both the variety and the check variety appeared.
"Performance compared to check" is given as a percent of check for yield, and as a difference from check for all other performance measures.