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

Sum of Price Per Unit |  |  | Lot Name
Item | Plant | Supplier | 2013 | 2014 | 2015 | Grand Total
1136 | Granada | CARGILL | 1.421 | 1.421 | 1.421 | 4.263
 |  | Tereos Syral | 0.914 | 0.914 | 0.914 | 2.742
 | Zwolle | CARGILL | 1.421 | 1.421 | 1.421 | 4.263
 |  | Tereos Syral | 0.914 | 0.914 | 0.914 | 2.742
1302 | Altavista | CARGILL | 0.1633 | 0.164 | 0.1647 | 0.492
 |  | Grain Processing Corp | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 |  | Tate & Lyle |  | 0.395 |  | 0.395
 | Casa/Fairfield | CARGILL | 0.2216 | 0.2226 | 0.2235 | 0.6677
 |  | Grain Processing Corp | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 | Columbus | CARGILL | 0.1633 | 0.164 | 0.1647 | 0.492
 |  | Grain Processing Corp | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 | EU TPM | Tate & Lyle | 0.735 |  |  | 0.735
 |  | Tereos Syral | 0.74 | 0.834 | 0.834 | 2.408
 | Sturgis | CARGILL | 0.2216 | 0.2226 | 0.2235 | 0.6677
 |  | Grain Processing Corp | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 | Zwolle | CARGILL | 0.925 | 0.925 | 0.925 | 2.775
 |  | Tate & Lyle | 0.85 |  |  | 0.85
 |  | Tereos Syral | 0.834 | 0.834 | 0.834 | 2.502
1305 | Altavista | CARGILL | 0.1633 | 0.164 | 0.1647 | 0.492
 |  | Grain Processing Corp | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 |  | Tate & Lyle | 0.365 |  | 0.375 | 0.74
 | Casa/Fairfield | CARGILL | 0.235 | 0.2361 | 0.2371 | 0.7081999999999999
 |  | Grain Processing Corp | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 |  | Tate & Lyle | 0.367 | 0.3699 | 0.3729 | 1.1098
 | Columbus | CARGILL | 0.1633 | 0.164 | 0.1647 | 0.492
 |  | Grain Processing Corp | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 |  | Tate & Lyle | 0.312 | 0.312 | 0.3145 | 0.9385
 | Sturgis | CARGILL | 0.235 | 0.2361 | 0.2371 | 0.7081999999999999
 |  | Grain Processing Corp | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 |  | Tate & Lyle | 0.369 | 0.37 | 0.3729 | 1.1119
1310 | Altavista | CARGILL | 0.2675 |  |  | 0.2675
 | Casa/Fairfield | CARGILL | 0.29 |  |  | 0.29
 | Columbus | CARGILL | 0.25 |  |  | 0.25
 |  | Tate & Lyle | 0.255 |  |  | 0.255
 | EU TPM | CARGILL |  | 0.476 |  | 0.476
 |  | Tate & Lyle | 0.85 |  |  | 0.85
 |  | Tereos Syral | 0.564 | 0.564 | 0.564 | 1.692
 | Sturgis | CARGILL | 0.2525 |  |  | 0.2525
 |  | Tate & Lyle | 0.2506 | 0.38 |  | 0.6306
 | Zwolle | CARGILL | 0.476 | 0.476 | 0.476 | 1.428
 |  | Roquette | 0.535 |  |  | 0.535
 |  | Tereos Syral | 0.525 | 0.564 | 0.564 | 1.653
1313 | Altavista | Grain Processing Corp | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 | Casa/Fairfield | Grain Processing Corp | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 |  | Tate & Lyle | 0.3676 | 0.3706 | 0.3736 | 1.1118
 | Columbus | Grain Processing Corp | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 |  | Tate & Lyle | 0.367 | 0.368 | 0.3736 | 1.1086
 | Sturgis | Grain Processing Corp | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 |  | Tate & Lyle | 0.367 | 0.3699 | 0.3736 | 1.1105
1315 | Altavista | Grain Processing Corp | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 |  | Tate & Lyle | 0.3675 | 0.4 | 0.39 | 1.1575
 | Casa/Fairfield | Grain Processing Corp | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 |  | Tate & Lyle | 0.367 | 0.3699 | 0.3729 | 1.1098
 | Sturgis | Grain Processing Corp | 0.313 | 0.323 | 0.335 | 0.9710000000000001
 |  | Tate & Lyle | 0.367 | 0.3699 | 0.3729 | 1.1098
1316 | Altavista | Grain Processing Corp | 0.363 | 0.373 | 0.383 | 1.119
 | Casa/Fairfield | Grain Processing Corp | 0.363 | 0.373 | 0.383 | 1.119
 | Columbus | Grain Processing Corp | 0.363 | 0.373 | 0.383 | 1.119
 | Sturgis | Grain Processing Corp | 0.363 | 0.373 | 0.383 | 1.119
13691 | Granada | Tereos Syral | 0.914 | 0.914 | 0.914 | 2.742
 | Zwolle | Tereos Syral | 0.914 | 0.914 | 0.914 | 2.742
20893 | Cootehill | CARGILL | 0.925 | 0.925 | 0.925 | 2.775
 |  | Roquette | 0.99 |  |  | 0.99
 |  | Tereos Syral | 0.834 | 0.834 | 0.834 | 2.502
 | EU TPM | Tate & Lyle | 0.755 |  |  | 0.755
 |  | Tereos Syral | 0.765 | 0.834 | 0.834 | 2.433
23235 | Columbus | Roquette | 0.442 |  |  | 0.442
31961 | Granada | Roquette | 1.82 |  |  | 1.82
 |  | Tate & Lyle | 1.565 |  |  | 1.565
 |  | Tereos Syral | 1.5846 | 1.668 | 1.668 | 4.9206
 | Zwolle | Roquette | 0.915 |  |  | 0.915
 |  | Tate & Lyle | 0.8 |  |  | 0.8
 |  | Tereos Syral | 0.834 | 0.834 | 0.834 | 2.502
32098 | Zwolle | CARGILL | 0.501 | 0.501 | 0.501 | 1.503
 |  | Tereos Syral | 0.598 | 0.834 | 0.834 | 2.266
36668 | China | Tereos Syral | 909.3 | 920 | 930 | 2759.3
 | EU TPM | Tate & Lyle | 1.51 |  |  | 1.51
 |  | Tereos Syral | 1.524 | 1.668 | 1.668 | 4.86
 | Singapore | CARGILL | 0.787 | 0.823 | 0.854 | 2.464
 |  | Roquette | 0.99 |  |  | 0.99
 |  | Tereos Syral | 0.982 | 1.034 | 1.034 | 3.05
39298 | Zwolle | Grain Processing Corp | 1.0978 | 1.1199 | 1.142 | 3.3597
 |  | Tereos Syral | 0.834 | 0.834 | 0.834 | 2.502
43940 | Granada | CARGILL | 1.56 | 1.56 | 1.56 | 4.68
 |  | Roquette | 2.18 |  |  | 2.18
 |  | Tereos Syral | 1.746 | 1.746 | 1.746 | 5.238
 | Zwolle | CARGILL | 1.56 | 1.56 | 1.56 | 4.68
 |  | Roquette | 2.18 |  |  | 2.18
 |  | Tereos Syral | 1.66 | 1.746 | 1.746 | 5.151999999999999
55832 | Granada | CARGILL | 1.85 | 1.85 | 1.85 | 5.55
 |  | Roquette | 1.82 |  |  | 1.82
 |  | Tate & Lyle | 1.58 |  |  | 1.58
 |  | Tereos Syral | 1.6263 | 1.668 | 1.668 | 4.9623
72139 | Zwolle | CARGILL | 0.925 | 0.925 | 0.925 | 2.775
 |  | Grain Processing Corp | 1.0978 | 1.1199 | 1.142 | 3.3597
 |  | Tereos Syral | 0.834 | 0.834 | 0.834 | 2.502
73914 | Zwolle | Grain Processing Corp | 1.0978 | 1.1199 | 1.142 | 3.3597
 |  | Tereos Syral | 0.834 | 0.834 | 0.834 | 2.502
81589 | Granada | CARGILL | 0.19 | 0.19 | 0.19 | 0.57
 |  | Roquette | 0.53 |  |  | 0.53
 |  | Tereos Syral | 0.525 | 0.564 | 0.564 | 1.653
87543 | China | Tereos Syral | 909.3 | 920 | 930 | 2759.3
 | Singapore | CARGILL | 0.787 | 0.823 | 0.854 | 2.464
 |  | Roquette | 0.98 |  |  | 0.98
 |  | Tereos Syral | 0.982 | 1.034 | 1.034 | 3.05
73914A | Zwolle | Grain Processing Corp | 1.0978 |  |  | 1.0978
 |  | Tereos Syral | 0.834 |  |  | 0.834
R0587 | Sturgis | Grain Processing Corp | 0.548 | 0.558 |  | 1.106
R0587. | Sturgis | Grain Processing Corp |  |  | 0.568 | 0.568
1136B | Zwolle | CARGILL | 1.421 | 1.421 | 1.421 | 4.263
 |  | Tereos Syral | 0.914 | 0.914 | 0.914 | 2.742
13691B | Zwolle | Tate & Lyle |  |  | 0.85 | 0.85
 |  | Tereos Syral | 0.914 | 0.914 | 0.914 | 2.742
31961B | Zwolle | CARGILL | 0.925 | 0.925 | 0.925 | 2.775
 |  | Roquette | 0.915 |  |  | 0.915
 |  | Tate & Lyle | 0.8 |  |  | 0.8
 |  | Tereos Syral | 0.834 | 0.834 | 0.834 | 2.502
39298A | Zwolle | Grain Processing Corp | 1.0978 | 1.1199 | 1.142 | 3.3597
 |  | Tereos Syral | 0.834 | 0.834 | 0.834 | 2.502
43940B | Zwolle | Roquette | 2.18 |  |  | 2.18
 |  | Tereos Syral | 1.746 | 1.746 | 1.746 | 5.238
72139A | Zwolle | CARGILL | 0.925 | 0.925 | 0.925 | 2.775
 |  | Grain Processing Corp | 1.0978 | 1.1199 | 1.142 | 3.3597
 |  | Tereos Syral | 0.834 | 0.834 | 0.834 | 2.502
73914A | Zwolle | Grain Processing Corp |  | 1.1199 | 1.142 | 2.2619
 |  | Tereos Syral |  | 0.834 | 0.834 | 1.668
R0424 | Casa/Fairfield | CARGILL | 0.2915 |  |  | 0.2915
Grand Total |  |  | 1910.8343 | 1906.738 | 1927.1319 | 5744.704200000001