Spreadsheet: 679611d1590517988-match-model-and-pay-bonus-based-on-sale-amount-aft13564-match-model-and-pay-bonus-based-on-sale-amount
Sheet: Sheet1

Collections |  |  |  |  |  |  |  |  |  |  |  |  | Bonus tiers
date | sw_id | amt_collected | wh_model |  | [NAME] | sale_min3 |  | bonus_amt2 | bonus_amt3 | bonus | bonus - single formula |  | wh_model | sale_min1 | bonus_amt1 | [NAME] | bonus_amt2 | sale_min3 | bonus_amt3
2020-04-27 00:00:00 | DANK | 3700 | URG2100H6N |  |  |  |  |  |  |  |  |  | RG130T6N | 3000 | 300 | 3500 | 400 | 4000 | 500
2020-04-26 00:00:00 | CHRISF | 3699 | URG150 |  | 3500 | 4000 |  | 400 | 500 |  |  |  | RG140T6X | 3000 | 300 | 3500 | 400 | 4000 | 500
2020-04-26 00:00:00 | [NAME] | 3692 | URG140 |  | 3500 | 4000 |  | 400 | 500 |  |  |  | RG150T6X | 3000 | 300 | 3500 | 400 | 4000 | 500
2020-05-03 00:00:00 | CHRISF | 3650 | URG150 |  | 3500 | 4000 |  | 400 | 500 |  |  |  | RE330 | 3000 | 300 | 3500 | 400 | 4000 | 500
2020-05-01 00:00:00 | JOHNAZ | 3612 | URG150 |  | 3500 | 4000 |  | 400 | 500 |  |  |  | [NAME] | 3000 | 300 | 3500 | 400 | 4000 | 500
2020-04-30 00:00:00 | SCOTTR | 3603 | URG150 |  | 3500 | 4000 |  | 400 | 500 |  |  |  | RE350 | 3000 | 300 | 3500 | 400 | 4000 | 500
2020-04-25 00:00:00 | JOHNAZ | 3592 | URG150 |  | 3500 | 4000 |  | 400 | 500 |  |  |  | URG130 | 3000 | 300 | 3500 | 400 | 4000 | 500
2020-04-29 00:00:00 | [NAME] | 3582 | URG150 |  | 3500 | 4000 |  | 400 | 500 |  |  |  | URG140 | 3000 | 300 | 3500 | 400 | 4000 | 500
2020-05-02 00:00:00 | SCOTTR | 3569 | URG150 |  | 3500 | 4000 |  | 400 | 500 |  |  |  | URG150 | 3000 | 300 | 3500 | 400 | 4000 | 500
2020-04-27 00:00:00 | MIKEC | 3564 | URG150 |  | 3500 | 4000 |  | 400 | 500 |  |  |  | [NAME] | 3000 | 300 | 3500 | 400 | 4000 | 500
2020-04-25 00:00:00 | CRISD | 3558 | URG140 |  | 3500 | 4000 |  | 400 | 500 |  |  |  | URG250L6N | 3500 | 300 | 4000 | 400 | 4500 | 500
2020-05-05 00:00:00 | CRISD | 3558 | URG150 |  | 3500 | 4000 |  | 400 | 500 |  |  |  | URG250S6N | 3500 | 300 | 4000 | 400 | 4500 | 500
2020-04-25 00:00:00 | NAM | 3500 | [NAME] |  | 3500 | 4000 |  | 400 | 500 |  |  |  | URG250H6N | 3500 | 300 | 4000 | 400 | 4500 | 500
2020-04-28 00:00:00 | CRISD | 3500 | URG150 |  | 3500 | 4000 |  | 400 | 500 |  |  |  | RE230L6 | 3500 | 300 | 4000 | 400 | 4500 | 500
2020-04-30 00:00:00 | MARROY | 3500 | URG150 |  | 3500 | 4000 |  | 400 | 500 |  |  |  | RE240LN6 | 3500 | 300 | 4000 | 400 | 4500 | 500
2020-04-30 00:00:00 | NAM | 3500 | URG150 |  | 3500 | 4000 |  | 400 | 500 |  |  |  | RE250LN6 | 3500 | 300 | 4000 | 400 | 4500 | 500
2020-05-08 00:00:00 | [NAME] | 3453 | URG140 |  | 3500 | 4000 |  | 400 | 500 |  |  |  | [NAME] | 4000 | 300 | 4500 | 400 | 5000 | 500
2020-04-26 00:00:00 | [NAME] | 3450 | URG150 |  | 3500 | 4000 |  | 400 | 500 |  |  |  | URG2DV50S6N | 4000 | 300 | 4500 | 400 | 5000 | 500
2020-04-28 00:00:00 | ANGEL | 3424 | URG150 |  | 3500 | 4000 |  | 400 | 500 |  |  |  | URG2DV50H6N | 4000 | 300 | 4500 | 400 | 5000 | 500
2020-05-04 00:00:00 | [NAME] | 3419 | URG150 |  | 3500 | 4000 |  | 400 | 500 |  |  |  | URG2PV40T6N | 4000 | 300 | 4500 | 400 | 5000 | 500
2020-04-25 00:00:00 | [NAME] | 3410 | [NAME] |  | 3500 | 4000 |  | 400 | 500 |  |  |  | URG2PV50T6N | 4000 | 300 | 4500 | 400 | 5000 | 500
2020-05-02 00:00:00 | MIKEC | 3404 | URG150 |  | 3500 | 4000 |  | 400 | 500 |  |  |  | 65 Electric | 4000 | 300 | 4500 | 400 | 5000 | 500
2020-04-26 00:00:00 | CHRISF | 3400 | URG150 |  | 3500 | 4000 |  | 400 | 500 |  |  |  | URG275H6N | 4000 | 300 | 4500 | 400 | 5000 | 500
2020-05-08 00:00:00 | SCOTTR | 3400 | URG275H6N |  | 4500 | 5000 |  | 400 | 500 |  |  |  | URG1PV50S6N | 4500 | 300 | 5000 | 400 | 5000 | 500
2020-05-04 00:00:00 | [NAME] | 3386 | URG140 |  | 3500 | 4000 |  | 400 | 500 |  |  |  | URG2PV50H6N | 4500 | 300 | 5000 | 400 | 5000 | 500