Spreadsheet: 123346d1317591514-excel-2007-calculating-bonus-formula-orders
Sheet: September

September Phone
 |  |  |  |  |  |  |  |  | Amt$ till 30K | Amt$ till 50K
Date | Order # | Amount | Item # | Qty | Type | Payment | $20 Bonus
2011-09-01 00:00:00 | 3108 | 1107 | D150B | 1 | Phone | Recv'd
2011-09-04 00:00:00 | 3196 | 797 | JL8 | 1 | Phone | Recv'd
2011-09-04 00:00:00 | 3207 | 1107 | D150C | 1 | Phone | Recv'd
2011-09-04 00:00:00 | 3210 | 927 | JL4C | 1 | Phone | Recv'd |  |  | Bonus | Bonus |  | $20 Bonus
2011-09-04 00:00:00 | 3201 | 1665.27 | ZN150T9 | 1 | Phone | Recv'd
2011-09-05 00:00:00 | 3226 | 1208 | ZS_E | 1 | Walkin | Recv'd
2011-09-05 00:00:00 | 3230 | 1837 | D50TKA | 1 | Phone | Recv'd
2011-09-06 00:00:00 | 3257 | 1087 | D150D | 1 | Phone | Recv'd
2011-09-06 00:00:00 | 3255 | 2367 | D150TKA | 1 | Phone | Recv'd
2011-09-06 00:00:00 | 3254 | 742 | JL8 | 1 | Walkin | Recv'd
2011-09-06 00:00:00 | 3266 | 2067 | SL22 | 1 | Phone | Recv'd
2011-09-06 00:00:00 | 3267 | 1126 | D150A | 1 | Phone | Recv'd
2011-09-13 00:00:00 | 3454 | 1167 | WYT16 | 1 | Phone | Recv'd
2011-09-14 00:00:00 | 3489 | 2097 | SL22 | 1 | Phone | Recv'd
2011-09-15 00:00:00 | 3506 | 767 | JL5A | 1 | Phone | Recv'd
2011-09-15 00:00:00 | 3511 | 767 | JL5A | 1 | Phone | Recv'd
2011-09-18 00:00:00 | 3595 | 767 | JL5A | 1 | Phone | Recv'd
2011-09-18 00:00:00 | 3603 | 947 | JL5 | 1 | Phone | Recv'd
2011-09-19 00:00:00 | 3632 | 1087 | 110N | 1 | Phone | Recv'd
2011-09-19 00:00:00 | 3636 | 1107 | [NAME] | 1 | Phone | Recv'd
2011-09-20 00:00:00 | 3656 | 767 | JL5A | 1 | Phone | Recv'd
2011-09-21 00:00:00 | 3680 | 1057 | D150G | 1 | Phone | Recv'd
2011-09-22 00:00:00 | 3696 | 1007 | D150C | 1 | Phone | Recv'd
2011-09-25 00:00:00 | 3798 | 947 | JL5 | 1 | Phone | Recv'd
2011-09-25 00:00:00 | 3801 | 997 | D150E | 1 | Phone | Recv'd
2011-09-26 00:00:00 | 3823 | 2427 | D250B | 1 | Phone | Recv'd
2011-09-26 00:00:00 | 3828 | 951.02 | JL5A | 1 | Phone | Recv'd
2011-09-26 00:00:00 | 3832 | 1017 | JL6 | 1 | Phone | Recv'd
2011-09-27 00:00:00 | 3851 | 2097 | D250RTC | 1 | Phone | Recv'd | 20
2011-09-28 00:00:00 | 3870 | 2142 | D150E/D150C | 1 | Phone | Recv'd
2011-09-28 00:00:00 | 3873 | 2157 | D250RTC | 1 | Phone | Recv'd
Total
September Online
Date | Order # | Amount | Item # | Qty | Type | Payment | $20 Bonus
2011-09-01 00:00:00 | 52803 | 1007 | D150E | 1 | Online | Recv'd
2011-09-01 00:00:00 | 3107 | 757 | JL4 | 1 | Online | Recv'd
2011-09-04 00:00:00 | 3197 | 1087 | [NAME] | 1 | Online | Recv'd
2011-09-04 00:00:00 | 3192 | 1126 | D150A | 1 | Online | Recv'd
2011-09-04 00:00:00 | 3180 | 69 | D009 | 1 | Online | Recv'd
2011-09-05 00:00:00 | 3228 | 2027 | D250RTA | 1 | Online | Recv'd
2011-09-06 00:00:00 | 3269 | 797 | JL8 | 1 | Online | Recv'd
2011-09-07 00:00:00 | 3286 | 1176 | D150G | 1 | Online | Recv'd
2011-09-07 00:00:00 | 3285 | 927 | JL4C | 1 | Online | Recv'd
2011-09-08 00:00:00 | 2999 | 866 | JL8 | 1 | Online | Recv'd
2011-09-08 00:00:00 | 3300 | 1057 | D150A | 1 | Online | Recv'd
2011-09-08 00:00:00 | 3291 | 927 | JL4B | 1 | Online | Recv'd
2011-09-08 00:00:00 | 3313 | 1057 | D150A | 1 | Online | Recv'd
2011-09-11 00:00:00 | 3393 | 797 | JL8 | 1 | Online | Recv'd
2011-09-11 00:00:00 | 3396 | 1087 | 110N | 1 | Online | Recv'd
2011-09-11 00:00:00 | 3394 | 1367 | ZN150TF | 1 | Online | Recv'd
2011-09-12 00:00:00 | 3416 | 1337 | ZN150TF | 1 | Online | Recv'd
2011-09-12 00:00:00 | 3425 | 767 | JL5A | 1 | Online | Recv'd
2011-09-13 00:00:00 | 3462 | 797 | JL8 | 1 | Online | Recv'd
2011-09-13 00:00:00 | 3464 | 1417 | D150H | 1 | Online | Recv'd
2011-09-14 00:00:00 | 3479 | 947 | JL5 | 1 | Online | Recv'd
2011-09-14 00:00:00 | 3486 | 947 | JL5 | 1 | Online | Recv'd
2011-09-15 00:00:00 | 3500 | 1057 | D150A | 1 | Online | Recv'd
2011-09-18 00:00:00 | 3597 | 927 | JL4C | 1 | Online | Recv'd
2011-09-18 00:00:00 | 3605 | 927 | JL4C | 1 | Online | Recv'd
2011-09-19 00:00:00 | 3627 | 2157 | D250RTC | 1 | Online | Recv'd
2011-09-19 00:00:00 | 3637 | 767 | JL5A | 1 | Online | Recv'd
2011-09-20 00:00:00 | 3664 | 767 | JL5A | 1 | Online | Recv'd
2011-09-22 00:00:00 | 3684 | 138 | D008 | 2 | Online | Recv'd
2011-09-22 00:00:00 | 3685 | 797 | JL5A | 1 | Online | Recv'd
2011-09-22 00:00:00 | 3687 | 1057 | D150G | 1 | Online | Recv'd
2011-09-25 00:00:00 | 3778 | 2467 | D150TKB | 1 | Online | Recv'd
2011-09-25 00:00:00 | 3786 | 1167 | WYT16 | 1 | Online | Recv'd
2011-09-25 00:00:00 | 3788 | 947 | JL5 | 1 | Online | Recv'd
2011-09-25 00:00:00 | 3794 | 947 | JL5 | 1 | Online | Recv'd
2011-09-26 00:00:00 | 3825 | 767 | JL5A | 1 | Online | Recv'd
2011-09-26 00:00:00 | 3771 | 757 | JL4 | 1 | Online | Recv'd
2011-09-26 00:00:00 | 3833 | 4978 | Multiple | 1 | Online | Recv'd
2011-09-27 00:00:00 | 3856 | 1636 | ZN150T9 | 1 | Online | Recv'd
2011-09-27 00:00:00 | 3858 | 757 | JL4 | 1 | Online | Recv'd
2011-09-28 00:00:00 | 3871 | 927 | JL4B | 1 | Online | Recv'd
2011-09-28 00:00:00 | 3783 | 1057 | D150G | 1 | Online | Recv'd
2011-09-28 00:00:00 | 3819 | 767 | JL5A | 1 | Online | Recv'd
Total