Spreadsheet: 679606d1590516055-match-model-and-pay-bonus-based-on-sale-amount-example-10
Sheet: Sheet1

date | sw_id | amt_collected | wh_model | bonus_amt |  |  |  |  | wh_model | sale_min1 | bonus_amt1 | [NAME] | bonus_amt2 | sale_min3 | bonus_amt3
43948 | DANK | 3700 | URG2100H6N |  |  |  |  |  | RG130T6N | 3000 | 300 | 3500 | 400 | 4000 | 500
43947 | CHRISF | 3699 | URG150 |  |  |  |  |  | RG140T6X | 3000 | 300 | 3500 | 400 | 4000 | 500
43947 | [NAME] | 3692 | URG140 |  |  |  |  |  | RG150T6X | 3000 | 300 | 3500 | 400 | 4000 | 500
43954 | CHRISF | 3650 | URG150 |  |  |  |  |  | RE330 | 3000 | 300 | 3500 | 400 | 4000 | 500
43952 | JOHNAZ | 3612 | URG150 |  |  |  |  |  | [NAME] | 3000 | 300 | 3500 | 400 | 4000 | 500
43951 | SCOTTR | 3603 | URG150 |  |  |  |  |  | RE350 | 3000 | 300 | 3500 | 400 | 4000 | 500
43946 | JOHNAZ | 3592 | URG150 |  |  |  |  |  | URG130 | 3000 | 300 | 3500 | 400 | 4000 | 500
43950 | [NAME] | 3582 | URG150 |  |  |  |  |  | URG140 | 3000 | 300 | 3500 | 400 | 4000 | 500
43953 | SCOTTR | 3569 | URG150 |  |  |  |  |  | URG150 | 3000 | 300 | 3500 | 400 | 4000 | 500
43948 | MIKEC | 3564 | URG150 |  |  |  |  |  | [NAME] | 3000 | 300 | 3500 | 400 | 4000 | 500
43946 | CRISD | 3558 | URG140 |  |  |  |  |  | URG250L6N | 3500 | 300 | 4000 | 400 | 4500 | 500
43956 | CRISD | 3558 | URG150 |  |  |  |  |  | URG250S6N | 3500 | 300 | 4000 | 400 | 4500 | 500
43946 | NAM | 3500 | [NAME] |  |  |  |  |  | URG250H6N | 3500 | 300 | 4000 | 400 | 4500 | 500
43949 | CRISD | 3500 | URG150 |  |  |  |  |  | RE230L6 | 3500 | 300 | 4000 | 400 | 4500 | 500
43951 | MARROY | 3500 | URG150 |  |  |  |  |  | RE240LN6 | 3500 | 300 | 4000 | 400 | 4500 | 500
43951 | NAM | 3500 | URG150 |  |  |  |  |  | RE250LN6 | 3500 | 300 | 4000 | 400 | 4500 | 500
43959 | [NAME] | 3453 | URG140 |  |  |  |  |  | [NAME] | 4000 | 300 | 4500 | 400 | 5000 | 500
43947 | [NAME] | 3450 | URG150 |  |  |  |  |  | URG2DV50S6N | 4000 | 300 | 4500 | 400 | 5000 | 500
43949 | ANGEL | 3424 | URG150 |  |  |  |  |  | URG2DV50H6N | 4000 | 300 | 4500 | 400 | 5000 | 500
43955 | [NAME] | 3419 | URG150 |  |  |  |  |  | URG2PV40T6N | 4000 | 300 | 4500 | 400 | 5000 | 500
43946 | [NAME] | 3410 | [NAME] |  |  |  |  |  | URG2PV50T6N | 4000 | 300 | 4500 | 400 | 5000 | 500
43953 | MIKEC | 3404 | URG150 |  |  |  |  |  | 65 Electric | 4000 | 300 | 4500 | 400 | 5000 | 500
43947 | CHRISF | 3400 | URG150 |  |  |  |  |  | URG275H6N | 4000 | 300 | 4500 | 400 | 5000 | 500
43959 | SCOTTR | 3400 | URG275H6N |  |  |  |  |  | URG1PV50S6N | 4500 | 300 | 5000 | 400 | 5000 | 500
43955 | [NAME] | 3386 | URG140 |  |  |  |  |  | URG2PV50H6N | 4500 | 300 | 5000 | 400 | 5000 | 500
43953 | CHRISF | 3300 | URG150 |  |  |  |  |  | 80 Electric | 4500 | 300 | 5000 | 400 | 5000 | 500
43947 | [NAME] | 3288 | URG150 |  |  |  |  |  | 65 Solar | 4500 | 300 | 5000 | 400 | 5000 | 500
43954 | [NAME] | 3283 | URG150 |  |  |  |  |  | 80 Solar | 4500 | 300 | 5000 | 400 | 5000 | 500
43958 | LUISV | 3254 | URG140 |  |  |  |  |  | 120 Electric | 5000 | 300 | 5500 | 400 | 6000 | 500
43954 | GERARD | 3248 | URG150 |  |  |  |  |  | 120 Solar | 5000 | 300 | 5500 | 400 | 6000 | 500
43957 | [NAME] | 3239 | URG140 |  |  |  |  |  | URG2100H6N | 5000 | 300 | 5500 | 400 | 6000 | 500
43954 | SCOTTR | 3237 | URG150 |  |  |  |  |  | URG2PV75H6N | 5000 | 300 | 5500 | 400 | 6000 | 500
43954 | [NAME] | 3211 | URG150 |  |  |  |  |  | URG140URG150 | 6000 | 600 | 7000 | 800 | 8000 | 1000
43953 | CHRISF | 3203 | URG250H6N |  |  |  |  |  | URG150URG140 | 6000 | 600 | 7000 | 800 | 8000 | 1000
43948 | SCOTTR | 3200 | URG140 |  |  |  |  |  | URG140URG140 | 6000 | 600 | 7000 | 800 | 8000 | 1000
43955 | [NAME] | 3177 | URG140 |  |  |  |  |  | URG150URG150 | 6000 | 600 | 7000 | 800 | 8000 | 1000
43957 | LUISV | 3165 | URG140 |  |  |  |  |  | EZTR 40 | 6000 | 500 | 7000 | 800 | 8000 | 1000
43947 | [NAME] | 3150 | URG150 |  |  |  |  |  | EZTR 50 | 6000 | 500 | 7000 | 800 | 8000 | 1000
43953 | GERARD | 3150 | URG140 |  |  |  |  |  | EZTR 75 | 6000 | 500 | 7000 | 800 | 8000 | 1000
43959 | [NAME] | 3150 | URG150 |  |  |  |  |  | NR 98 | 6000 | 500 | 7000 | 800 | 8000 | 1000
 |  |  |  |  |  |  |  |  | NRC | 6000 | 500 | 7000 | 800 | 8000 | 1000