Spreadsheet: 42823d1241472275-pulling-detailed-data-from-one-sheet-to-another-keyedsearch
Sheet: Variance Tracking

Employee | ID | Total | 2009-03-01 00:00:00 | 2009-03-02 00:00:00 | 2009-03-03 00:00:00 | 2009-03-04 00:00:00 | 2009-03-05 00:00:00 | 2009-03-06 00:00:00 | 2009-03-07 00:00:00 | 2009-03-08 00:00:00 | 2009-03-09 00:00:00 | 2009-03-10 00:00:00 | 2009-03-11 00:00:00 | 2009-03-12 00:00:00 | 2009-03-13 00:00:00 | 2009-03-14 00:00:00 | 2009-03-15 00:00:00 | 2009-03-16 00:00:00 | 2009-03-17 00:00:00 | 2009-03-18 00:00:00 | 2009-03-19 00:00:00 | 2009-03-20 00:00:00 | 2009-03-21 00:00:00 | 2009-03-22 00:00:00 | 2009-03-23 00:00:00 | 2009-03-24 00:00:00 | 2009-03-25 00:00:00 | 2009-03-26 00:00:00 | 2009-03-27 00:00:00 | 2009-03-28 00:00:00 | 2009-03-29 00:00:00 | 2009-03-30 00:00:00 | 2009-03-31 00:00:00 | 2009-04-01 00:00:00 | 2009-04-02 00:00:00 | 2009-04-03 00:00:00 | 2009-04-04 00:00:00 | 2009-04-05 00:00:00 | 2009-04-06 00:00:00 | 2009-04-07 00:00:00 | 2009-04-08 00:00:00 | 2009-04-09 00:00:00 | 2009-04-10 00:00:00 | 2009-04-11 00:00:00 | 2009-04-12 00:00:00 | 2009-04-13 00:00:00 | 2009-04-14 00:00:00 | 2009-04-15 00:00:00 | 2009-04-16 00:00:00 | 2009-04-17 00:00:00 | 2009-04-18 00:00:00 | 2009-04-19 00:00:00 | 2009-04-20 00:00:00 | 2009-04-21 00:00:00 | 2009-04-22 00:00:00 | 2009-04-23 00:00:00 | 2009-04-24 00:00:00 | 2009-04-25 00:00:00 | 2009-04-26 00:00:00 | 2009-04-27 00:00:00 | 2009-04-28 00:00:00 | 2009-04-29 00:00:00 | 2009-04-30 00:00:00 | 2009-05-01 00:00:00 | 2009-05-02 00:00:00 | 2009-05-03 00:00:00 | 2009-05-04 00:00:00 | 2009-05-05 00:00:00 | 2009-05-06 00:00:00 | 2009-05-07 00:00:00 | 2009-05-08 00:00:00 | 2009-05-09 00:00:00 | 2009-05-10 00:00:00 | 2009-05-11 00:00:00 | 2009-05-12 00:00:00 | 2009-05-13 00:00:00 | 2009-05-14 00:00:00 | 2009-05-15 00:00:00 | 2009-05-16 00:00:00 | 2009-05-17 00:00:00 | 2009-05-18 00:00:00 | 2009-05-19 00:00:00 | 2009-05-20 00:00:00 | 2009-05-21 00:00:00 | 2009-05-22 00:00:00 | 2009-05-23 00:00:00 | 2009-05-24 00:00:00 | 2009-05-25 00:00:00 | 2009-05-26 00:00:00 | 2009-05-27 00:00:00 | 2009-05-28 00:00:00 | 2009-05-29 00:00:00 | 2009-05-30 00:00:00 | 2009-05-31 00:00:00 | 2009-06-01 00:00:00 | 2009-06-02 00:00:00 | 2009-06-03 00:00:00 | 2009-06-04 00:00:00 | 2009-06-05 00:00:00 | 2009-06-06 00:00:00 | 2009-06-07 00:00:00 | 2009-06-08 00:00:00 | 2009-06-09 00:00:00 | 2009-06-10 00:00:00 | 2009-06-11 00:00:00 | 2009-06-12 00:00:00 | 2009-06-13 00:00:00 | 2009-06-14 00:00:00 | 2009-06-15 00:00:00 | 2009-06-16 00:00:00 | 2009-06-17 00:00:00 | 2009-06-18 00:00:00 | 2009-06-19 00:00:00 | 2009-06-20 00:00:00 | 2009-06-21 00:00:00 | 2009-06-22 00:00:00 | 2009-06-23 00:00:00 | 2009-06-24 00:00:00 | 2009-06-25 00:00:00 | 2009-06-26 00:00:00 | 2009-06-27 00:00:00 | 2009-06-28 00:00:00 | 2009-06-29 00:00:00 | 2009-06-30 00:00:00 | 2009-07-01 00:00:00 | 2009-07-02 00:00:00 | 2009-07-03 00:00:00 | 2009-07-04 00:00:00 | 2009-07-05 00:00:00 | 2009-07-06 00:00:00 | 2009-07-07 00:00:00 | 2009-07-08 00:00:00 | 2009-07-09 00:00:00 | 2009-07-10 00:00:00 | 2009-07-11 00:00:00 | 2009-07-12 00:00:00 | 2009-07-13 00:00:00 | 2009-07-14 00:00:00 | 2009-07-15 00:00:00 | 2009-07-16 00:00:00 | 2009-07-17 00:00:00 | 2009-07-18 00:00:00 | 2009-07-19 00:00:00 | 2009-07-20 00:00:00 | 2009-07-21 00:00:00 | 2009-07-22 00:00:00 | 2009-07-23 00:00:00 | 2009-07-24 00:00:00 | 2009-07-25 00:00:00 | 2009-07-26 00:00:00 | 2009-07-27 00:00:00 | 2009-07-28 00:00:00 | 2009-07-29 00:00:00 | 2009-07-30 00:00:00
Employee #1 | 1 | 40.85 |  |  |  |  |  |  | 31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  | -0.05 | 0 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.1
Employee #2 | 2 | 0
Employee #3 | 3 | -288.94 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -299.25 |  |  |  |  |  | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -9 |  |  |  |  |  | 5.15 |  |  |  |  |  | 9 |  |  | 0.01 |  |  |  | 5.05
Employee #4 | 4 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
Employee #5 | 5 | -13.46999999999999 |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  | 5.01 |  | 30.29 |  |  |  |  |  |  |  | -10 | -1 |  |  |  | 20.1 |  |  | 1 |  |  | 0.04 |  | 0.05 |  | -3.9 | 0.09 |  |  |  | 0.01 | 5 |  |  |  | -0.05 |  | -0.4 | 0.2 | -49.91 |  |  |  |  | -20
Employee #6 | 6 | 3.06 |  | 25 |  |  |  |  |  |  | -10 |  |  |  |  |  |  |  |  |  |  |  | -8.55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.8 |  |  |  |  |  |  | -5.34 |  |  |  |  | -0.2 | 1.35
Employee #7 | 7 | -113 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -10 |  |  |  |  |  |  |  |  |  |  |  | -100
Employee #8 | 8 | -20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -19.95 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.05
Employee #9 | 9 | 0
Employee #10 | 10 | 0
Employee #11 | 11 | -9.99 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -9.99
Employee #12 | 12 | 0
Employee #13 | 13 | 0
Employee #14 | 14 | 24.11 |  |  |  |  |  |  |  |  |  | -1 |  |  |  |  |  | 1 |  | 23.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.1 |  |  |  |  | 0.1 |  |  |  |  |  |  | 0.31
Employee #15 | 15 | 0.9400000000000001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.1 | 0.04
Employee #16 | 16 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Employee #17 | 17 | -1.259999999999998 | -0.25 |  |  |  |  |  |  | -20 |  | 5 |  |  |  |  | -1 |  | 0.1 |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.1 |  |  | -0.01 |  |  |  |  |  |  |  |  |  |  |  | 5
Employee #18 | 18 | 0
Employee #19 | 19 | 24.09 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.2 |  |  |  |  |  |  | -0.48 |  |  |  |  |  |  |  |  |  | 25
Search Key Row | 2
(leave blank) |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 3 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6