Spreadsheet: 167764d1342098131-excel-2007-index-match-formula-but-i-need-the-data-to-change-depening-on-what-date-i-put-in-sample-t2
Sheet: 6-29-12

Date | Time | Receiver # | Receiving Station | Grower # | [NAME] | # of Tanks | Block | Weight | Avg. [NAME] | Decay | Soft | Wind Whip | Undersize | Hail | Splits | Other | Comments | Grader | Sample Size | Grade | Grade | Sample size | Grader | Decay | Soft | Wind Whip | Undersize | Hail | Splits | Other | Comments
2012-06-29 00:00:00 | 16:10:00 | 59994 |  | 1 | Benona Hills Farm Inc | 8 | 10 and 22 | 7728 |  | 2 |  | 9 |  |  |  |  |  | TG | 500 | 86
2012-06-29 09:42:37.050000 | 2012-06-29 09:42:37.050000 | 59982 |  | 25 | Riley Orchards | 12 | L.F. AND U.F. | 11284 |  |  |  | 5 |  |  |  |  |  | TG | 500 | 94
2012-06-29 00:00:00 | 10:45:00 | 59983 |  | 25 | Riley Orchards | 12 | U.F. | 11590 |  |  |  | 3 |  |  |  |  |  | TG | 500 | 97
2012-06-29 00:00:00 | 12:42:00 | 59988 |  | 25 | Riley Orchards | 12 | U.F. | 11711 |  |  |  | 7 |  |  |  |  |  | RZ | 500 | 94
2012-06-29 00:00:00 | 14:55:00 | 59991 |  | 25 | Riley Orchards | 12 | U.F. | 10974 |  |  |  | 5 |  |  |  |  |  | TG | 500 | 96
2012-06-29 00:00:00 | 16:45:00 | 59996 |  | 25 | Riley Orchards | 12 | U.F. | 11516 |  | 1 |  | 6 |  |  |  |  |  | RZ | 500 | 93
2012-06-29 00:00:00 | 19:51:00 | 60007 |  | 25 | Riley Orchards | 14 | U.F. | 11990 |  |  |  | 7 |  |  |  |  |  | RZ | 500 | 93
2012-06-29 09:42:37.050000 | 12:52:00 | 59713 |  | 27 | [NAME], [NAME] | 16 | KELLY HOME | 16342 |  |  |  | 11 |  |  |  |  |  | RZ | 500 | 90
2012-06-29 00:00:00 | 16:05:00 | 59993 |  | 27 | [NAME], [NAME] | 16 | KELLY HOME | 15655 |  |  |  | 22 |  |  |  |  |  | TG | 500 | 86
2012-06-29 00:00:00 | 17:15:00 | 59997 |  | 27 | [NAME], [NAME] | 16 | KELLY HOME | 15838 |  |  |  | 14 |  |  |  |  |  | RZ | 500 | 89
2012-06-29 00:00:00 | 19:34:00 | 60017 |  | 27 | [NAME], [NAME] | 16 | KELLY HOME | 15526 |  |  |  | 14 |  |  |  |  |  | RZ | 500 | 89
2012-06-29 00:00:00 | 19:58:00 | 60016 |  | 27 | [NAME], [NAME] | 14 | SOUTH BULL | 13672 |  |  |  | 6 |  |  |  |  |  | RZ | 500 | 95
2012-06-29 00:00:00 | 21:15:00 | 60014 |  | 27 | [NAME], [NAME] | 16 | SOUTH BULL | 14943 |  |  |  | 8 |  |  |  |  |  | BG | 500 | 94
2012-06-29 00:00:00 | 11:05:00 | 59984 |  | 33 | Vanagtmael & Sons | 8 | 1 | 7880 |  | 6 |  | 11 |  |  |  |  |  | CG | 500 | 89
2012-06-29 00:00:00 | 20:14:00 | 60001 |  | 33 | Vanagtmael & Sons | 1 | 12 | 560 |  |  |  | 14 |  |  |  |  |  | RZ | 500 | 90
2012-06-29 00:00:00 | 20:21:00 | 60002 |  | 33 | Vanagtmael & Sons | 8 | 8 | 8231 |  |  |  | 14 |  |  |  |  |  | RZ | 500 | 91
2012-06-29 00:00:00 | 14:47:00 | 59990 |  | 45 | Rennhack Orchards | 12 | T 93 | 11785 |  | 1 |  | 5 |  |  |  |  |  | TG | 500 | 95
2012-06-29 00:00:00 | 17:55:00 | 59998 |  | 45 | Rennhack Orchards | 10 | T93 | 10467 |  |  |  | 4 |  |  |  |  |  | RZ | 500 | 96
2012-06-29 09:42:37.050000 | 11:15:00 | 59985 |  | 83 | [NAME], Inc. | 7 | WAGNER | 6810 |  |  |  | 9 |  |  |  |  |  | TG | 500 | 92
2012-06-29 00:00:00 | 7:20PM | 59981 |  | 167 | Dietrich, Leo & Sons LLC. | 16 | LAKTON | 17199 |  |  |  | 13 |  |  |  |  |  | RZ | 1000 | 95
2012-06-29 00:00:00 | 19:20:00 | 60003 |  | 167 | Dietrich, Leo & Sons LLC. | 16 | LAKETON | 17519 |  |  |  | 13 |  |  |  |  |  | RZ | 1000 | 95
2012-06-29 00:00:00 | 19:20:00 | 60004 |  | 167 | Dietrich, Leo & Sons LLC. | 4 | LAKETON | 4226 |  |  |  | 13 |  |  |  |  |  | RZ | 1000 | 95
2012-06-29 00:00:00 | 23:31:00 | 60013 |  | 603 | [NAME], LLC. | 11 | FRANDSTANDS/CARDS6/MINNOW TANK/BAILEYS | 8931 |  |  |  | 9 |  |  |  |  |  | RZ | 500 | 91
2012-06-29 00:00:00 | 20:03:00 | 60015 |  | 646 | Great Lakes Fruit Farms | 14 | KC12 | 13645 |  |  |  | 7 |  |  |  |  |  | RZ | 500 | 91
2012-06-29 00:00:00 | 11:54:00 | 59986 | PFI Tarts | 647 | Brandel Farms LLC | 16 | [NAME] | 17838 |  | 1 | 14 | 8 |  |  |  |  |  | AG | 1000 | 91
2012-06-29 09:42:37.050000 | 11:54:00 | 59987 | PFI Tarts | 647 | Brandel Farms LLC | 9 | Avery 20 | 10162 |  | 1 | 14 | 8 |  |  |  |  |  | AG | 1000 | 91
2012-06-29 00:00:00 | 18:13:00 | 59999 |  | 647 | Brandel Farms LLC | 16 | AVERY 20/BACK HILL | 16016 |  |  |  | 8 |  |  |  |  |  | RZ | 1000 | 97
2012-06-29 00:00:00 | 18:13:00 | 60000 |  | 647 | Brandel Farms LLC | 16 | AVERY 20/BACK HILL | 16374 |  |  |  | 8 |  |  |  |  |  | RZ | 1000 | 97
2012-06-29 00:00:00 | 11:15:00 | 59712 |  | 674 | [NAME], Louis | 12 | BC2 | 11115 |  | 4 |  | 6 |  |  |  |  |  | CG | 500 | 90
2012-06-29 00:00:00 | 16:32:00 | 59995 |  | 674 | [NAME], Louis | 11 | BC2 | 10191 |  |  |  | 6 |  |  |  |  |  | TG | 500 | 93
2012-06-29 00:00:00 | 14:18:00 | 59989 |  | 1205 | [NAME], [NAME] | 6 | HEGGIES | 6465 |  | 1 |  | 16 |  |  |  |  |  | AG | 500 | 90
2012-06-29 00:00:00 | 21:01:00 | 60005 |  | 1205 | [NAME], [NAME] | 2 | HOME/OLD | 1525 |  |  |  | 19 |  |  |  |  |  | RZ | 500 | 87
 |  | 59992 | Voided |  |  |  |  | 0