Spreadsheet: 168059d1342203635-ranking-price-with-varying-criteria-excel_test
Sheet: After

 |  | Item | Plant | Supplier | 2013 | 2013 Rank | 2014 | 2014 Rank | 2015 | 2015 Rank
 |  | 1136 | Granada | CARGILL | 1.421 | 2 | 1.421 | 2 | 1.421 | 2
 |  |  |  | Tereos Syral | 0.914 | 1 | 0.914 | 1 | 0.914 | 1
 |  |  | Zwolle | CARGILL | 1.421 | 2 | 1.421 | 2 | 1.421 | 2
 |  |  |  | Tereos Syral | 0.914 | 1 | 0.914 | 1 | 0.914 | 1
 |  | 1302 | Altavista | CARGILL | 0.1633 | 1 | 0.164 | 1 | 0.1647 | 1
 |  |  |  | Grain Processing Corp | 0.313 | 2 | 0.323 | 2 | 0.333 | 3
 |  |  |  | Tate & Lyle |  | NA | 0.395 | 3 |  | NA
 |  |  | Casa/Fairfield | CARGILL | 0.2216 | 1 | 0.2226 | 1 | 0.2235 | 1
 |  |  |  | Grain Processing Corp | 0.313 | 2 | 0.323 | 2 | 0.333 | 2
 |  |  | Columbus | CARGILL | 0.1633 | 1 | 0.164 | 1 | 0.1647 | 1
 |  |  |  | Grain Processing Corp | 0.313 | 2 | 0.323 | 2 | 0.333 | 2
 |  |  | EU TPM | Tate & Lyle | 0.735 | 1 |  | NA |  | NA
 |  |  |  | Tereos Syral | 0.74 | 2 | 0.834 | 1 | 0.834 | 1
 |  |  | Sturgis | CARGILL | 0.2216 | 1 | 0.2226 |  | 0.2235
 |  |  |  | Grain Processing Corp | 0.313 | 2 | 0.323 |  | 0.333
 |  |  | Zwolle | CARGILL | 0.925 | 3 | 0.925 | 2 | 0.925 | 2
 |  |  |  | Tate & Lyle | 0.85 | 2 |  | NA |  | NA
 |  |  |  | Tereos Syral | 0.834 | 1 | 0.834 | 1 | 0.834 | 1
 |  | 1305 | Altavista | CARGILL | 0.1633 | 1 | 0.164 | 1 | 0.1647 | 1
 |  |  |  | Grain Processing Corp | 0.313 | 2 | 0.323 | 2 | 0.333 | 2
 |  |  |  | Tate & Lyle | 0.365 | 3 |  | NA | 0.375 | 3
 |  |  | Casa/Fairfield | CARGILL | 0.235 |  | 0.2361 |  | 0.2371
 |  |  |  | Grain Processing Corp | 0.313 |  | 0.323 |  | 0.333
 |  |  |  | Tate & Lyle | 0.367 |  | 0.3699 |  | 0.3729
 |  |  | Columbus | CARGILL | 0.1633 |  | 0.164 |  | 0.1647
 |  |  |  | Grain Processing Corp | 0.313 |  | 0.323 |  | 0.333
 |  |  |  | Tate & Lyle | 0.312 |  | 0.312 |  | 0.3145
 |  |  | Sturgis | CARGILL | 0.235 |  | 0.2361 |  | 0.2371
 |  |  |  | Grain Processing Corp | 0.313 |  | 0.323 |  | 0.333
 |  |  |  | Tate & Lyle | 0.369 |  | 0.37 |  | 0.3729
 |  | 1310 | Altavista | CARGILL | 0.2675
 |  |  | Casa/Fairfield | CARGILL | 0.29
 |  |  | Columbus | CARGILL | 0.25
 |  |  |  | Tate & Lyle | 0.255
 |  |  | EU TPM | CARGILL |  |  | 0.476
 |  |  |  | Tate & Lyle | 0.85
 |  |  |  | Tereos Syral | 0.564 |  | 0.564 |  | 0.564
 |  |  | Sturgis | CARGILL | 0.2525
 |  |  |  | Tate & Lyle | 0.2506 |  | 0.38
 |  |  | Zwolle | CARGILL | 0.476 |  | 0.476 |  | 0.476
 |  |  |  | Roquette | 0.535
 |  |  |  | Tereos Syral | 0.525 |  | 0.564 |  | 0.564
 |  | 1313 | Altavista | Grain Processing Corp | 0.313 |  | 0.323 |  | 0.333
 |  |  | Casa/Fairfield | Grain Processing Corp | 0.313 |  | 0.323 |  | 0.333
 |  |  |  | Tate & Lyle | 0.3676 |  | 0.3706 |  | 0.3736
 |  |  | Columbus | Grain Processing Corp | 0.313 |  | 0.323 |  | 0.333
 |  |  |  | Tate & Lyle | 0.367 |  | 0.368 |  | 0.3736
 |  |  | Sturgis | Grain Processing Corp | 0.313 |  | 0.323 |  | 0.333
 |  |  |  | Tate & Lyle | 0.367 |  | 0.3699 |  | 0.3736
 |  | 1315 | Altavista | Grain Processing Corp | 0.313 |  | 0.323 |  | 0.333
 |  |  |  | Tate & Lyle | 0.3675 |  | 0.4 |  | 0.39
 |  |  | Casa/Fairfield | Grain Processing Corp | 0.313 |  | 0.323 |  | 0.333
 |  |  |  | Tate & Lyle | 0.367 |  | 0.3699 |  | 0.3729
 |  |  | Sturgis | Grain Processing Corp | 0.313 |  | 0.323 |  | 0.335
 |  |  |  | Tate & Lyle | 0.367 |  | 0.3699 |  | 0.3729
 |  | 1316 | Altavista | Grain Processing Corp | 0.363 |  | 0.373 |  | 0.383
 |  |  | Casa/Fairfield | Grain Processing Corp | 0.363 |  | 0.373 |  | 0.383
 |  |  | Columbus | Grain Processing Corp | 0.363 |  | 0.373 |  | 0.383
 |  |  | Sturgis | Grain Processing Corp | 0.363 |  | 0.373 |  | 0.383
 |  | 13691 | Granada | Tereos Syral | 0.914 |  | 0.914 |  | 0.914
 |  |  | Zwolle | Tereos Syral | 0.914 |  | 0.914 |  | 0.914
 |  | 20893 | Cootehill | CARGILL | 0.925 |  | 0.925 |  | 0.925
 |  |  |  | Roquette | 0.99
 |  |  |  | Tereos Syral | 0.834 |  | 0.834 |  | 0.834
 |  |  | EU TPM | Tate & Lyle | 0.755
 |  |  |  | Tereos Syral | 0.765 |  | 0.834 |  | 0.834
 |  | 23235 | Columbus | Roquette | 0.442
 |  | 31961 | Granada | Roquette | 1.82
 |  |  |  | Tate & Lyle | 1.565
 |  |  |  | Tereos Syral | 1.5846 |  | 1.668 |  | 1.668
 |  |  | Zwolle | Roquette | 0.915
 |  |  |  | Tate & Lyle | 0.8
 |  |  |  | Tereos Syral | 0.834 |  | 0.834 |  | 0.834
 |  | 32098 | Zwolle | CARGILL | 0.501 |  | 0.501 |  | 0.501
 |  |  |  | Tereos Syral | 0.598 |  | 0.834 |  | 0.834
 |  | 36668 | China | Tereos Syral | 909.3 |  | 920 |  | 930
 |  |  | EU TPM | Tate & Lyle | 1.51
 |  |  |  | Tereos Syral | 1.524 |  | 1.668 |  | 1.668
 |  |  | Singapore | CARGILL | 0.787 |  | 0.823 |  | 0.854
 |  |  |  | Roquette | 0.99
 |  |  |  | Tereos Syral | 0.982 |  | 1.034 |  | 1.034
 |  | 39298 | Zwolle | Grain Processing Corp | 1.0978 |  | 1.1199 |  | 1.142
 |  |  |  | Tereos Syral | 0.834 |  | 0.834 |  | 0.834
 |  | 43940 | Granada | CARGILL | 1.56 |  | 1.56 |  | 1.56
 |  |  |  | Roquette | 2.18
 |  |  |  | Tereos Syral | 1.746 |  | 1.746 |  | 1.746
 |  |  | Zwolle | CARGILL | 1.56 |  | 1.56 |  | 1.56
 |  |  |  | Roquette | 2.18
 |  |  |  | Tereos Syral | 1.66 |  | 1.746 |  | 1.746
 |  | 55832 | Granada | CARGILL | 1.85 |  | 1.85 |  | 1.85
 |  |  |  | Roquette | 1.82
 |  |  |  | Tate & Lyle | 1.58
 |  |  |  | Tereos Syral | 1.6263 |  | 1.668 |  | 1.668
 |  | 72139 | Zwolle | CARGILL | 0.925 |  | 0.925 |  | 0.925
 |  |  |  | Grain Processing Corp | 1.0978 |  | 1.1199 |  | 1.142
 |  |  |  | Tereos Syral | 0.834 |  | 0.834 |  | 0.834
 |  | 73914 | Zwolle | Grain Processing Corp | 1.0978 |  | 1.1199 |  | 1.142
 |  |  |  | Tereos Syral | 0.834 |  | 0.834 |  | 0.834
 |  | 81589 | Granada | CARGILL | 0.19 |  | 0.19 |  | 0.19
 |  |  |  | Roquette | 0.53
 |  |  |  | Tereos Syral | 0.525 |  | 0.564 |  | 0.564
 |  | 87543 | China | Tereos Syral | 909.3 |  | 920 |  | 930
 |  |  | Singapore | CARGILL | 0.787 |  | 0.823 |  | 0.854
 |  |  |  | Roquette | 0.98
 |  |  |  | Tereos Syral | 0.982 |  | 1.034 |  | 1.034
 |  | 73914A | Zwolle | Grain Processing Corp | 1.0978
 |  |  |  | Tereos Syral | 0.834
 |  | R0587 | Sturgis | Grain Processing Corp | 0.548 |  | 0.558
 |  | R0587. | Sturgis | Grain Processing Corp |  |  |  |  | 0.568
 |  | 1136B | Zwolle | CARGILL | 1.421 |  | 1.421 |  | 1.421
 |  |  |  | Tereos Syral | 0.914 |  | 0.914 |  | 0.914
 |  | 13691B | Zwolle | Tate & Lyle |  |  |  |  | 0.85
 |  |  |  | Tereos Syral | 0.914 |  | 0.914 |  | 0.914
 |  | 31961B | Zwolle | CARGILL | 0.925 |  | 0.925 |  | 0.925
 |  |  |  | Roquette | 0.915
 |  |  |  | Tate & Lyle | 0.8
 |  |  |  | Tereos Syral | 0.834 |  | 0.834 |  | 0.834
 |  | 39298A | Zwolle | Grain Processing Corp | 1.0978 |  | 1.1199 |  | 1.142
 |  |  |  | Tereos Syral | 0.834 |  | 0.834 |  | 0.834
 |  | 43940B | Zwolle | Roquette | 2.18
 |  |  |  | Tereos Syral | 1.746 |  | 1.746 |  | 1.746
 |  | 72139A | Zwolle | CARGILL | 0.925 |  | 0.925 |  | 0.925
 |  |  |  | Grain Processing Corp | 1.0978 |  | 1.1199 |  | 1.142
 |  |  |  | Tereos Syral | 0.834 |  | 0.834 |  | 0.834
 |  | 73914A | Zwolle | Grain Processing Corp |  |  | 1.1199 |  | 1.142
 |  |  |  | Tereos Syral |  |  | 0.834 |  | 0.834
 |  | R0424 | Casa/Fairfield | CARGILL | 0.2915
 |  | Grand Total |  |  | 1910.8343 |  | 1906.738 |  | 1927.1319