Spreadsheet: 178976d1346970480-amount-to-be-allocated-but-with-upper-limit-sample_for_upload
Sheet: Sheet1

ITEM | TRANSACTION_DATE | ENTERING_BRANCH | Sum of Value | Maximum for Each Item | Value Expected
0433AT62A0020^JOHANSON-CSP1 | 2012-07-11 23:59:59 | 40611 | 603.835685802902 | 905.753528704352
0433AT62A0020^JOHANSON-CSP1 | 2012-07-24 23:59:59 | 40611 | 905.753528704353 | 905.753528704352
[PHONE]^MOLEX-DFC1 | 2012-07-30 23:59:59 | 40100 | 25.45138558672645 | 25.4513855867265
[PHONE]^MOLEX-DFC1 | 2012-08-30 23:59:59 | 40100 | 63.62846396681612 | 25.4513855867265 | 0
100BN.HMWG 909752^INTEL_MIC | 2012-07-16 23:59:59 | 47071 | 6647.302379692 | 6647.302379692
100BN.HMWG 909752^INTEL_MIC | 2012-08-10 23:59:59 | 47071 | 6647.302379692 | 6647.302379692
100-CG2266^AMD | 2012-07-26 23:59:59 | 40110 | 39.8698765650429 | 29.2379094810315
100-CG2266^AMD | 2012-08-23 23:59:59 | 40110 | 29.23790948103146 | 29.2379094810315
112BN.HMWG 903341^INTEL_MIC | 2012-07-05 23:59:59 | 47080 | 2.517061076486313 | 28.7664123027007
112BN.HMWG 903341^INTEL_MIC | 2012-07-09 23:59:59 | 47071 | 16.54068707405292 | 28.7664123027007
112BN.HMWG 903341^INTEL_MIC | 2012-07-11 23:59:59 | 47080 | 3.59580153783759 | 28.7664123027007
112BN.HMWG 903341^INTEL_MIC | 2012-07-17 23:59:59 | 47071 | 6.472442768107663 | 28.7664123027007
112BN.HMWG 903341^INTEL_MIC | 2012-07-24 23:59:59 | 47071 | 5.034122152972627 | 28.7664123027007 | 0
112BN.HMWG 903341^INTEL_MIC | 2012-08-10 23:59:59 | 47071 | 17.40367944313394 | 28.7664123027007 | 0
112BN.HMWG 903341^INTEL_MIC | 2012-08-16 23:59:59 | 47080 | 1.797900768918795 | 28.7664123027007 | 0
1410454C^MURATAPS | 2012-07-06 23:59:59 | 43215 | 73.30950797038504 | 9.16368849629814
1410454C^MURATAPS | 2012-07-12 23:59:59 | 43715 | 1.008005734592794 | 9.16368849629814 | 0
1410454C^MURATAPS | 2012-07-24 23:59:59 | 40130 | 9.16368849629813 | 9.16368849629814 | 0
1410454C^MURATAPS | 2012-07-27 23:59:59 | 43215 | 73.30950797038504 | 9.16368849629814 | 0
1410454C^MURATAPS | 2012-08-16 23:59:59 | 43715 | 19.24374584222607 | 9.16368849629814 | 0
1410454C^MURATAPS | 2012-08-24 23:59:59 | 43215 | 9.16368849629813 | 9.16368849629814 | 0
1468420C^MURATAPS | 2012-07-20 23:59:59 | 40651 | 21.56360902552802 | 21.563609025528
1468420C^MURATAPS | 2012-08-01 23:59:59 | 43015 | 25.87633083063363 | 21.563609025528 | 0
1468420C^MURATAPS | 2012-08-24 23:59:59 | 40651 | 23.71996992808083 | 21.563609025528 | 0
1-770743-1^TYCO-CSP1 | 2012-07-11 23:59:59 | 40350 | 104.9533935582423 | 10.9326451623169
1-770743-1^TYCO-CSP1 | 2012-07-16 23:59:59 | 40350 | 209.9067871164845 | 10.9326451623169 | 0
1-770743-1^TYCO-CSP1 | 2012-07-18 23:59:59 | 40350 | 17.49223225970704 | 10.9326451623169 | 0
1-770743-1^TYCO-CSP1 | 2012-07-20 23:59:59 | 40350 | 168.3627354996803 | 10.9326451623169 | 0
1-770743-1^TYCO-CSP1 | 2012-08-03 23:59:59 | 40350 | 548.8187871483084 | 10.9326451623169 | 0
1-770743-1^TYCO-CSP1 | 2012-08-31 23:59:59 | 40350 | 89.64769033099859 | 10.9326451623169 | 0
202R18W102KV4E^JOHANSON | 2012-07-04 23:59:59 | 40601 | 2.324179508861676 | 8.13462828101586
202R18W102KV4E^JOHANSON | 2012-07-12 23:59:59 | 43715 | 4.648359017723352 | 8.13462828101586
202R18W102KV4E^JOHANSON | 2012-07-27 23:59:59 | 40060 | 11.62089754430838 | 8.13462828101586
202R18W102KV4E^JOHANSON | 2012-08-03 23:59:59 | 43715 | 1.162089754430838 | 8.13462828101586 | 0
202R18W102KV4E^JOHANSON | 2012-08-30 23:59:59 | 43715 | 1.162089754430838 | 8.13462828101586 | 0