Spreadsheet: 742221d1627592326-get-calculations-to-spill-along-with-the-filtered-or-uniqued-data-samplez-tms-v2
Sheet: Other Sheet

PLATE | Date | TYPE | AMOUNT |  |  |  |  | TabData
AAB111 | 2020-12-06 00:00:00 | First Load | 100
AAB111 | 2021-01-07 00:00:00 | Passing | 20
AAB111 | 2021-02-27 00:00:00 | Passing | 20
AAB111 | 2021-03-07 00:00:00 | Passing | 20
AAB111 | 2021-03-26 00:00:00 | Closing | 40
ADB153 | 2020-10-10 00:00:00 | First Load | 100
ADB153 | 2020-11-05 00:00:00 | Passing | 15
ADB153 | 2020-12-06 00:00:00 | Add. Load | 90
ADB153 | 2020-12-06 00:00:00 | Passing | 90
ADB153 | 2021-01-11 00:00:00 | Closing | 85 |  |  | =TabData
ACF458 | 2020-12-14 00:00:00 | First Load | 100 |  |  |  | 44171 | First Load | 100
ACF458 | 2021-01-16 00:00:00 | Passing | 15 |  |  | AAB111 | 44203 | Passing | 20
ACF458 | 2021-02-13 00:00:00 | Passing | 15 |  |  | AAB111 | 44254 | Passing | 20
ACF458 | 2021-03-22 00:00:00 | Passing | 20 |  |  | AAB111 | 44262 | Passing | 20
ACF458 | 2021-04-27 00:00:00 | Closing | 50 |  |  | AAB111 | 44281 | Closing | 40
BND225 | 2020-10-19 00:00:00 | First Load | 100 |  |  | ADB153 | 44114 | First Load | 100
BND225 | 2020-10-31 00:00:00 | Passing | 10 |  |  | ADB153 | 44140 | Passing | 15
BND225 | 2020-11-23 00:00:00 | Passing | 15 |  |  | ADB153 | 44171 | Add. Load | 90
BND225 | 2021-01-13 00:00:00 | Passing | 35 |  |  | ADB153 | 44171 | Passing | 90
BND225 | 2021-02-08 00:00:00 | Closing | 40 |  |  | ADB153 | 44207 | Closing | 85
BHF321 | 2020-11-28 00:00:00 | First Load | 100 |  |  | ACF458 | 44179 | First Load | 100
BHF321 | 2020-12-21 00:00:00 | Passing | 25 |  |  | ACF458 | 44212 | Passing | 15
BHF321 | 2021-01-27 00:00:00 | Add. Load | 120 |  |  | ACF458 | 44240 | Passing | 15
BHF321 | 2021-01-27 00:00:00 | Passing | 120 |  |  | ACF458 | 44277 | Passing | 20
BHF321 | 2021-03-03 00:00:00 | Passing | 45 |  |  | ACF458 | 44313 | Closing | 50
BGH854 | 2020-11-25 00:00:00 | First Load | 100 |  |  | BND225 | 44123 | First Load | 100
BGH854 | 2021-01-06 00:00:00 | Add. Load | 150 |  |  | BND225 | 44135 | Passing | 10
BGH854 | 2021-01-06 00:00:00 | Passing | 150 |  |  | BND225 | 44158 | Passing | 15
BGH854 | 2021-01-22 00:00:00 | Passing | 40 |  |  | BND225 | 44209 | Passing | 35
BGH854 | 2021-02-02 00:00:00 | Closing | 60 |  |  | BND225 | 44235 | Closing | 40
CLD589 | 2020-11-23 00:00:00 | First Load | 100 |  |  | BHF321 | 44163 | First Load | 100
CLD589 | 2021-01-06 00:00:00 | Passing | 10 |  |  | BHF321 | 44186 | Passing | 25
CLD589 | 2021-01-09 00:00:00 | Passing | 35 |  |  | BHF321 | 44223 | Add. Load | 120
CLD589 | 2021-01-24 00:00:00 | Add. Load | 70 |  |  | BHF321 | 44223 | Passing | 120
CLD589 | 2021-01-24 00:00:00 | Passing | 70 |  |  | BHF321 | 44258 | Passing | 45
CFY414 | 2020-10-15 00:00:00 | First Load | 100 |  |  | BGH854 | 44160 | First Load | 100
CFY414 | 2020-11-19 00:00:00 | Passing | 15 |  |  | BGH854 | 44202 | Add. Load | 150
CFY414 | 2020-12-13 00:00:00 | Passing | 15 |  |  | BGH854 | 44202 | Passing | 150
CFY414 | 2020-12-27 00:00:00 | Passing | 25 |  |  | BGH854 | 44218 | Passing | 40
CFY414 | 2021-01-04 00:00:00 | Passing | 20 |  |  | BGH854 | 44229 | Closing | 60
DDE220 | 2020-12-20 00:00:00 | First Load | 100 |  |  | CLD589 | 44158 | First Load | 100
DDE220 | 2020-12-27 00:00:00 | Passing | 50 |  |  | CLD589 | 44202 | Passing | 10
DDE220 | 2021-01-05 00:00:00 | Passing | 20 |  |  | CLD589 | 44205 | Passing | 35
DDE220 | 2021-01-18 00:00:00 | Passing | 15 |  |  | CLD589 | 44220 | Add. Load | 70
DDE220 | 2021-02-21 00:00:00 | Closing | 15 |  |  | CLD589 | 44220 | Passing | 70
EFS309 | 2020-12-07 00:00:00 | First Load | 100 |  |  | CFY414 | 44119 | First Load | 100
EFS309 | 2020-12-15 00:00:00 | Passing | 40 |  |  | CFY414 | 44154 | Passing | 15
EFS309 | 2021-01-10 00:00:00 | Add. Load | 75 |  |  | CFY414 | 44178 | Passing | 15
EFS309 | 2021-01-10 00:00:00 | Passing | 75 |  |  | CFY414 | 44192 | Passing | 25
EFS309 | 2021-01-21 00:00:00 | Passing | 50 |  |  | CFY414 | 44200 | Passing | 20
TMS |  | Passing | 20 |  |  | DDE220 | 44185 | First Load | 100
 |  |  |  |  |  | DDE220 | 44192 | Passing | 50
 |  |  |  |  |  | DDE220 | 44201 | Passing | 20
 |  |  |  |  |  | DDE220 | 44214 | Passing | 15
 |  |  |  |  |  | DDE220 | 44248 | Closing | 15
 |  |  |  |  |  | EFS309 | 44172 | First Load | 100
 |  |  |  |  |  | EFS309 | 44180 | Passing | 40
 |  |  |  |  |  | EFS309 | 44206 | Add. Load | 75
 |  |  |  |  |  | EFS309 | 44206 | Passing | 75
 |  |  |  |  |  | EFS309 | 44217 | Passing | 50
 |  |  |  |  |  | TMS | 0 | Passing | 20