Spreadsheet: 129321d1321545966-if-then-statements-for-dates-aging-copy-report_approvers_2011-11-17_15-34
Sheet: Recovered_Sheet1

Approvers
Report generated on: 11/17/2011 6:34 AM
Data type | Jobs and messages
Job and message type | Vendor invoices |  |  |  |  |  |  |  | ENTER FORMULA HERE | CORRECT ANSWER - DATE | CORRECT ANSWER - AGE
Operations | Number of record(s)...
Status | Document number | Vendor number | Invoice number | Invoice date | Total amount | Currency | Current owner | Date/time submitted |  |  |  | Level 1 approver | Level 1 approval date | Time at Approver 1 | Approval Waiting Time 1 | Level 2 approver | Level 2 approval date | Time at Approver 2 | Approval Waiting Time 2 | Level 3 approver | Level 3 approval date | Time at Approver 3 | Approval Waiting Time 3 | Level 4 approver | Level 4 approval date | Time at Approver 4 | Approval Waiting Time 4 | Level 5 approver | Level 5 approval date | Time at Approver 5 | Approval Waiting Time 5 | Level 6 approver | Level 6 approval date | Time at Approver 6 | Approval Waiting Time 6 | Level 7 approver | Level 7 approval date | Time at Approver 7 | Approval Waiting Time 7
Being processed | [PHONE]-2601-2011 | 1008181 | 29430374 | 2011-01-31 00:00:00 | 34.11 | GBP | [EMAIL] | 2011-02-07 03:33:56 |  | 2011-02-09 08:20:37 |  | [EMAIL] | 2011-02-09 08:20:37 | 2 days 04:46:41 | 283 days 02:56:53 | [EMAIL] |  | 00:00:00 | 280 days 22:10:12 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
Being processed | [PHONE]-1001-2011 | 1007518 | 2011-11 | 2011-02-07 00:00:00 | 20000 | USD | [EMAIL] | 2011-02-12 05:49:48 |  | 2011-02-12 05:49:48 |  | [EMAIL] |  | 0 | 278 days 00:41:01 | [EMAIL] |  | 00:00:00 | 0 | [EMAIL] |  | 00:00:00 | 00:00:00 | [EMAIL] |  | 00:00:00 | 00:00:00 | [EMAIL] |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
Being processed | [PHONE]-2601-2011 | 1009480 | 800615325 | 2011-02-22 00:00:00 | 7530 | USD | [EMAIL] | 2011-02-23 07:16:46 |  | 2011-04-07 07:21:03 |  | [EMAIL] | 2011-04-06 16:46:46 | 42 days 08:30:00 | 266 days 23:14:03 | [EMAIL] | 2011-04-07 07:21:03 | 14:34:17 | 224 days 14:44:03 | [EMAIL] |  | 00:00:00 | 224 days 00:09:46 | [EMAIL] |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
Being processed | [PHONE]-2011 | 1005710 | APRIL2011 | 2011-01-27 00:00:00 | 375 | USD | [EMAIL] | 2011-03-10 13:10:52 |  | 2011-05-19 16:36:13 |  | [EMAIL] | 2011-05-19 16:36:13 | 70 days 02:25:21 | 251 days 17:19:57 | [EMAIL] |  | 00:00:00 | 181 days 14:54:36 | [EMAIL] |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
Being processed | [PHONE]-2011 | 1006923 | 53404876 | 2011-03-02 00:00:00 | 1472.26 | USD | [EMAIL] | 2011-03-14 09:15:22 |  | 2011-03-14 09:15:22 |  | [EMAIL] |  | 0 | 247 days 22:15:27 | [EMAIL] |  | 00:00:00 | 0 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
Being processed | [PHONE]-2601-2011 | 1009601 | [PHONE] | 2011-03-07 00:00:00 | 239.27 | EUR | [EMAIL] | 2011-03-16 03:59:47 |  | 2011-03-16 03:59:47 |  | [EMAIL] |  | 0 | 246 days 03:31:02 | [EMAIL] |  | 00:00:00 | 0 | [EMAIL] |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
Being processed | [PHONE]-1001-2011 | 1010662 | 13804868 | 2011-02-08 00:00:00 | 310.26 | USD | [EMAIL] | 2011-03-23 06:25:45 |  |  |  | [EMAIL] |  | 0 | 239 days 01:05:04 | [EMAIL] |  | 00:00:00 | 0 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
Being processed | [PHONE]-1001-2011 | 1010643 | 294834 | 2011-02-28 00:00:00 | 100 | USD | [EMAIL] | 2011-03-23 13:44:27 |  |  |  | [EMAIL] |  | 0 | 238 days 17:46:22 | [EMAIL] |  | 00:00:00 | 0 | [EMAIL] |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
Being processed | [PHONE]-2601-2011 | 1009601 | [PHONE] | 2011-02-01 00:00:00 | 421.17 | EUR | [EMAIL] | 2011-03-29 08:00:00 |  |  |  | [EMAIL] | 2011-04-08 06:22:02 | 9 days 22:22:02 | 232 days 23:30:49 | [EMAIL] |  | 00:00:00 | 223 days 01:08:47 | [EMAIL] |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
Being processed | [PHONE]-1001-2012 | 1000786 | 3158733 | 2010-01-07 00:00:00 | 2604.71 | USD | [EMAIL] | 2011-03-29 13:13:13 |  |  |  | [EMAIL] |  | 0 | 232 days 18:17:36 | [EMAIL] |  | 00:00:00 | 0 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
Being processed | [PHONE]-1001-2012 | 1000786 | 3090474 | 2009-09-30 00:00:00 | 636.5 | USD | [EMAIL] | 2011-04-05 13:50:11 |  |  |  | [EMAIL] |  | 0 | 225 days 17:40:38 | [EMAIL] |  | 00:00:00 | 0 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
Being processed | [PHONE]-1001-2012 | 1000786 | 3108085 | 2009-10-23 00:00:00 | 4493.5 | USD | [EMAIL] | 2011-04-05 13:57:45 |  |  |  | [EMAIL] |  | 0 | 225 days 17:33:04 | [EMAIL] |  | 00:00:00 | 0 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
Being processed | [PHONE]-1001-2012 | 1000786 | 3104471 | 2009-10-20 00:00:00 | 331.04 | USD | [EMAIL] | 2011-04-05 13:56:16 |  |  |  | [EMAIL] |  | 0 | 225 days 17:34:33 | [EMAIL] |  | 00:00:00 | 0 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
Being processed | [PHONE]-2011 | 1006716 | 1103158 | 2011-04-05 00:00:00 | 2220 | USD | [EMAIL] | 2011-04-14 18:38:26 |  |  |  | [EMAIL] | 2011-04-21 11:49:57 | 6 days 17:11:31 | 216 days 12:52:23 | [EMAIL] |  | 00:00:00 | 209 days 19:40:52 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
Being processed | [PHONE]-1001-2011 | 1006277 | 100051944 | 2011-04-13 00:00:00 | 1572.76 | USD | [EMAIL] | 2001-04-14 00:00:00 |  |  |  | [EMAIL] |  | 0 | 216 days 12:26:37 | [EMAIL] |  | 00:00:00 | 0 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
Being processed | [PHONE]-1001-2011 | 1005710 | JUNE2011 | 2011-01-27 00:00:00 | 300 | USD | [EMAIL] | 2011-04-15 11:58:54 |  |  |  | [EMAIL] |  | 0 | 215 days 19:31:55 | [EMAIL] |  | 00:00:00 | 0 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
Being processed | [PHONE]-1001-2011 | 1004477 | 0153-1545 | 2011-04-14 00:00:00 | 9.83 | USD | [EMAIL] | 2011-04-18 06:41:16 |  |  |  | [EMAIL] |  | 0 | 213 days 00:49:33 | [EMAIL] |  | 00:00:00 | 0 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
Being processed | [PHONE]-2011 | 1010059 | [PHONE]-068 | 2011-06-22 12:44:49 | 2727.2 | USD | [EMAIL] | 2011-04-21 06:49:35 |  |  |  | [EMAIL] | 2011-06-22 12:44:49 | 62 days 05:55:14 | 210 days 00:41:14 | [EMAIL] |  | 00:00:00 | 147 days 18:46:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
Being processed | [PHONE]-1001-2011 | 1009648 | 10010061 | 2011-04-29 00:00:00 | 905 | USD | [EMAIL] | 2011-04-28 08:08:16 |  |  |  | [EMAIL] | 2011-05-05 14:02:01 | 7 days 05:53:45 | 202 days 23:22:33 | [EMAIL] |  | 00:00:00 | 195 days 17:28:48 | [EMAIL] |  | 00:00:00 | 00:00:00 | [EMAIL] |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
Being processed | [PHONE]-2011 | 1005710 | April 11 | 2011-04-29 00:00:00 | 375 | USD | [EMAIL] | 2011-05-03 08:52:57 |  |  |  | [EMAIL] |  | 0 | 197 days 22:37:52 | [EMAIL] |  | 00:00:00 | 0 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00