Spreadsheet: 162204d1339767519-lookup-zero-then-return-value-from-another-cell-test
Sheet: 10 Weeks

Account | 2012-04-11 00:00:00 | 2012-04-12 00:00:00 | 2012-04-15 00:00:00 | 2012-04-16 00:00:00 | 2012-04-17 00:00:00 | 2012-04-18 00:00:00 | 2012-04-19 00:00:00 | 2012-04-22 00:00:00 | 2012-04-23 00:00:00 | 2012-04-24 00:00:00 | 2012-04-25 00:00:00 | 2012-04-26 00:00:00 | 2012-04-29 00:00:00 | 2012-04-30 00:00:00 | 2012-05-01 00:00:00 | 2012-05-02 00:00:00 | 2012-05-03 00:00:00 | 2012-05-09 00:00:00 | 2012-05-10 00:00:00 | 2012-05-13 00:00:00 | 2012-05-14 00:00:00 | 2012-05-15 00:00:00 | 2012-05-16 00:00:00 | 2012-05-17 00:00:00 | 2012-05-20 00:00:00 | 2012-05-21 00:00:00 | 2012-05-22 00:00:00 | 2012-05-23 00:00:00 | 2012-05-24 00:00:00 | 2012-05-27 00:00:00 | 2012-05-28 00:00:00 | 2012-05-29 00:00:00 | 2012-05-30 00:00:00 | 2012-05-31 00:00:00 | 2012-06-05 00:00:00 | 2012-06-06 00:00:00 | 2012-06-07 00:00:00 | 2012-06-10 00:00:00 | 2012-06-11 00:00:00 | 2012-06-12 00:00:00 | 2012-06-13 00:00:00 | Count of CIP (41)
97937 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
97940 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
97948 | 0 | 0 | 0 | 0 | 0 | 19172.02 | 0 | 0 | 10135.05 | 10135.05 | 10135.05 | 0 | 0 | 0 | 0 | 205.7 | 0 | 0 | 0 | 0 | 0 | 416.13 | 416.13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3525.27 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8
98001 | 0 | 0 | 0 | 0 | 0 | 23000 | 0 | 0 | 0 | 0 | 15000 | 0 | 0 | 0 | 25000 | 44891.03 | 0 | 0 | 0 | 0 | 0 | 0 | 20452.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3156.45 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 39385 | 7
98005 | 0 | 0 | 0 | 0 | 0 | 6426.74 | 0 | 13950 | 13950 | 13950 | 34100 | 0 | 0 | 0 | 0 | 8890 | 0 | 16340 | 0 | 0 | 0 | 0 | 11756 | 0 | 0 | 0 | 0 | 10990 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7285 | 10
98023 | 0 | 0 | 0 | 0 | 13900 | 0 | 0 | 0 | 0 | 10000 | 0 | 0 | 0 | 0 | 14000 | 0 | 0 | 0 | 0 | 0 | 0 | 10250 | 0 | 0 | 0 | 0 | 6671.3 | 0 | 0 | 0 | 0 | 11950 | 0 | 0 | 5600 | 0 | 0 | 0 | 0 | 24400 | 0 | 8
98033 | 20500 | 20500 | 0 | 25000 | 0 | 0 | 12228.5 | 0 | 25000 | 0 | 0 | 20000 | 0 | 25000 | 0 | 0 | 9000 | 0 | 16000 | 0 | 25000 | 0 | 0 | 11950 | 25000 | 25000 | 0 | 0 | 13000 | 0 | 50000 | 0 | 0 | 25000 | 0 | 0 | 56822 | 0 | 0 | 0 | 0 | 17
98116 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 126.07 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
98129 | 11000 | 11000 | 25000 | 25000 | 0 | 0 | 0 | 335 | 335 | 0 | 0 | 0 | 21000 | 21000 | 0 | 0 | 0 | 0 | 11000 | 11000 | 29000 | 0 | 0 | 0 | 9000 | 9000 | 0 | 0 | 0 | 10500 | 10500 | 0 | 0 | 10000 | 20000 | 32000 | 32000 | 32000 | 42000 | 0 | 0 | 21
98130 | 0 | 0 | 0 | 1050 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 775 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2
98134 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40000 | 0 | 0 | 0 | 0 | 20000 | 0 | 0 | 0 | 38000 | 0 | 0 | 39320 | 0 | 0 | 0 | 0 | 41000 | 0 | 0 | 0 | 0 | 51000 | 0 | 0 | 0 | 0 | 300000 | 0 | 0 | 0 | 0 | 0 | 7
98136 | 4640 | 4640 | 0 | 0 | 0 | 0 | 2355 | 0 | 0 | 0 | 0 | 1765 | 0 | 0 | 0 | 0 | 2840 | 0 | 2961 | 0 | 0 | 0 | 0 | 3305 | 0 | 0 | 0 | 0 | 4645 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6330 | 0 | 0 | 0 | 0 | 9
98137 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
98140 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2750 | 0 | 0 | 0 | 0 | 1600 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2
98900 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4250 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3500 | 3500 | 3500 | 3500 | 3500 | 6
98907 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2500 | 2500 | 2500 | 2500 | 2500 | 5
98908 | 36840.25 | 36840.25 | 0 | 0 | 0 | 18503.43 | 18503.43 | 0 | 0 | 0 | 0 | 17523.32 | 0 | 0 | 15000 | 15000 | 27781.02 | 0 | 15792.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16450.91 | 0 | 0 | 0 | 22497 | 22497 | 0 | 0 | 17420 | 0 | 0 | 0 | 20653.75 | 14
98909 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
98923 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1914.66 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2230.05 | 2230.05 | 0 | 0 | 0 | 5000 | 5000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8000 | 0 | 6
98946 | 0 | 0 | 18386.61 | 18386.61 | 18386.61 | 31386.61 | 0 | 1471.24 | 1471.24 | 1471.24 | 1471.24 | 0 | 623 | 25623 | 25623 | 45623 | 0 | 28659 | 0 | 0 | 0 | 0 | 22665 | 0 | 0 | 17000 | 17000 | 18250.16 | 0 | 0 | 0 | 0 | 16064.61 | 0 | 12500 | 24500 | 0 | 12000 | 12000 | 27500 | 29210.1 | 24
98948 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4715 | 0 | 0 | 0 | 0 | 2970 | 0 | 0 | 0 | 0 | 0 | 0 | 2085 | 0 | 0 | 0 | 0 | 3350 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13030 | 0 | 0 | 5
99001 | 0 | 0 | 16000 | 32000 | 0 | 0 | 0 | 31065 | 0 | 0 | 0 | 0 | 0 | 15000 | 0 | 0 | 0 | 0 | 0 | 25000 | 0 | 0 | 0 | 0 | 9000 | 16000 | 0 | 0 | 0 | 16550 | 0 | 0 | 0 | 0 | 0 | 66000 | 0 | 16500 | 25000 | 0 | 0 | 11
99002 | 30295 | 30295 | 30295 | 30295 | 25000 | 25000 | 0 | 0 | 0 | 28900 | 28900 | 10000 | 10000 | 10000 | 30535 | 30535 | 20000 | 15000 | 45590.88 | 45590.88 | 45590.88 | 34500 | 34500 | 10000 | 10000 | 10000 | 35000 | 35000 | 10800 | 10800 | 10800 | 22000 | 22000 | 45605 | 45605 | 45605 | 45605 | 45605 | 45605 | 33000 | 33000 | 38
99005 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
99007 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
99012 | 0 | 0 | 0 | 0 | 21000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
99033 | 25500 | 25500 | 0 | 0 | 0 | 25750 | 25750 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20000 | 0 | 0 | 0 | 0 | 0 | 0 | 21000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6
99112 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 590.53 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
99116 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 500 | 0 | 0 | 0 | 3
99134 | 12500 | 12500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15005 | 18000 | 26005 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10270 | 0 | 0 | 0 | 0 | 6
99136 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
99137 | 0 | 0 | 44720 | 0 | 25280 | 0 | 0 | 35000 | 0 | 0 | 0 | 19000 | 53065 | 0 | 36000 | 0 | 20500 | 0 | 17500 | 42000 | 18000 | 27435 | 0 | 16500 | 16500 | 23000 | 43000 | 0 | 22000 | 47710 | 23000 | 31500 | 0 | 0 | 60530 | 0 | 42500 | 81525 | 24000 | 25690 | 0 | 24
99904 | 0 | 0 | 25000 | 41050 | 0 | 26000 | 0 | 25000 | 47600 | 0 | 45350 | 0 | 25000 | 47165 | 0 | 36310 | 0 | 30750 | 0 | 0 | 26000 | 0 | 40955 | 0 | 25000 | 51425 | 0 | 25000 | 0 | 25000 | 49190 | 0 | 0 | 0 | 0 | 39410 | 0 | 0 | 35220 | 0 | 36860 | 20
99907 | 0 | 0 | 0 | 18000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 47000 | 47000 | 0 | 0 | 9
99923 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1065 | 0 | 0 | 0 | 0 | 0 | 0 | 990 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1715 | 0 | 0 | 3
99925 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
99935 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 220 | 1
99937 | 0 | 0 | 0 | 0 | 2597.22 | 2597.22 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2
100002 | 53350 | 53350 | 0 | 44500 | 65500 | 0 | 19500 | 19500 | 20000 | 66750 | 0 | 26000 | 24000 | 72500 | 122000 | 0 | 35000 | 0 | 19500 | 14000 | 14000 | 48000 | 0 | 36500 | 0 | 0 | 40000 | 0 | 0 | 20000 | 40000 | 86000 | 0 | 26000 | 0 | 0 | 55330 | 25000 | 25000 | 57000 | 0 | 27
100003 | 25000 | 25000 | 25000 | 50000 | 0 | 0 | 49360 | 49000 | 74000 | 0 | 25000 | 94500 | 43120 | 0 | 64707 | 0 | 90490 | 0 | 0 | 50000 | 50000 | 25000 | 0 | 52115 | 39000 | 64000 | 12000 | 12000 | 34000 | 32625 | 66640 | 25000 | 24665 | 57360 | 58000 | 41000 | 98500 | 46900 | 66095 | 20000 | 29665 | 33
100005 | 0 | 0 | 45000 | 70000 | 0 | 25000 | 0 | 45000 | 65000 | 23440 | 33440 | 0 | 20000 | 65000 | 0 | 0 | 45000 | 65000 | 0 | 45000 | 85000 | 0 | 0 | 0 | 25000 | 70000 | 20000 | 20000 | 25000 | 45000 | 45000 | 0 | 0 | 0 | 85000 | 85000 | 0 | 65000 | 110000 | 0 | 0 | 24
100006 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15000 | 15000 | 15000 | 15000 | 15000 | 0 | 0 | 0 | 0 | 0 | 10000 | 6
100007 | 0 | 0 | 25000 | 28000 | 0 | 6000 | 0 | 31500 | 15000 | 0 | 8500 | 0 | 24000 | 25000 | 0 | 8000 | 0 | 37000 | 0 | 26000 | 25000 | 31000 | 6500 | 0 | 19500 | 20500 | 0 | 14000 | 0 | 36000 | 37000 | 0 | 10000 | 0 | 34500 | 64500 | 0 | 22000 | 25000 | 0 | 8100 | 25
100012 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
100013 | 0 | 0 | 47000 | 47000 | 0 | 0 | 0 | 39000 | 39000 | 0 | 0 | 13735 | 0 | 41500 | 0 | 1000 | 1000 | 48000 | 48000 | 94145 | 94145 | 0 | 17000 | 17000 | 19580 | 19580 | 0 | 0 | 0 | 31080 | 31080 | 0 | 7500 | 7500 | 23500 | 98000 | 98000 | 50000 | 52000 | 0 | 16120 | 26
100014 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0