A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Timestamp | Date of Reservation | Time of Reservation (Convert to EST Please!!!) | Location? | Common_reservation_id # | Reservation Bucket | Date | First 2 days of Reservations? | Date & Time for first 2 days | Date | Conversion | ||||||||||||||
2 | 6/7/2016 18:42:00 | 3/31/2015 | 1:30:00 PM | Houston | 5013XX | 501 | 3/31/2015 13:30:00 | 0 | 0 | 3/31/2016 | 42460 | ||||||||||||||
3 | 6/8/2016 0:10:38 | 3/6/2016 | 1:00:00 PM | Chicago Grand Avenue | 342XXX | 342 | 3/6/2016 13:00:00 | 0 | 0 | 4/1/2016 | 42461 | ||||||||||||||
4 | 6/7/2016 17:53:28 | 3/15/2016 | 10:30:00 AM | Porsgrunn, Norway | 3728xx | 372 | 3/15/2016 10:30:00 | 0 | 0 | ||||||||||||||||
5 | 6/7/2016 14:19:39 | 3/17/2016 | 7:00:00 AM | California | 385462 | 385 | 3/17/2016 7:00:00 | 0 | 0 | ||||||||||||||||
6 | 6/7/2016 13:21:16 | 3/17/2016 | 12:20:00 PM | California | 352xxx | 352 | 3/17/2016 12:20:00 | 0 | 0 | ||||||||||||||||
7 | 6/7/2016 8:56:40 | 3/21/2016 | 1:00:00 PM | Europe | 355XXX | 355 | 3/21/2016 13:00:00 | 0 | 0 | ||||||||||||||||
8 | 6/7/2016 10:47:12 | 3/30/2016 | 6:30:00 PM | Melbourne, Austrailia | 363497 | 363 | 3/30/2016 18:30:00 | 0 | 0 | ||||||||||||||||
9 | 6/7/2016 12:15:30 | 3/30/2016 | 11:00:00 PM | China | 15019462 | 150 | 3/30/2016 23:00:00 | 0 | 0 | ||||||||||||||||
10 | 6/7/2016 11:00:16 | 3/31/2016 | 12:00:00 AM | edmonton alberta | 436058 | 436 | 3/31/2016 0:00:00 | 1 | 3/31/2016 0:00:00 | ||||||||||||||||
11 | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | ||||||||||||||||
12 | 6/7/2016 17:49:54 | 3/31/2016 | 12:00:00 AM | California | 467835 | 467 | 3/31/2016 0:00:00 | 1 | 3/31/2016 0:00:00 | ||||||||||||||||
13 | 6/7/2016 15:40:16 | 3/31/2016 | 12:20:00 AM | Montreal | 380xxx | 380 | 3/31/2016 0:20:00 | 1 | 3/31/2016 0:20:00 | ||||||||||||||||
14 | 6/7/2016 22:33:31 | 3/31/2016 | 12:30:00 AM | Short Hills, NJ | 381XXX | 381 | 3/31/2016 0:30:00 | 1 | 3/31/2016 0:30:00 | ||||||||||||||||
15 | 6/7/2016 15:13:55 | 3/31/2016 | 12:40:00 AM | Minnesota | 388xxx | 388 | 3/31/2016 0:40:00 | 1 | 3/31/2016 0:40:00 | ||||||||||||||||
16 | 6/7/2016 15:30:26 | 3/31/2016 | 12:47:00 AM | Bellevue, WA | 382468 | 382 | 3/31/2016 0:47:00 | 1 | 3/31/2016 0:47:00 | ||||||||||||||||
17 | 6/7/2016 8:53:40 | 3/31/2016 | 1:00:00 AM | United Kingdom | 386679 | 386 | 3/31/2016 1:00:00 | 1 | 3/31/2016 1:00:00 | ||||||||||||||||
18 | 6/7/2016 16:35:12 | 3/31/2016 | 1:10:00 AM | Sunnyvale | 383900 | 383 | 3/31/2016 1:10:00 | 1 | 3/31/2016 1:10:00 | ||||||||||||||||
19 | 6/8/2016 7:57:55 | 3/31/2016 | 1:10:00 AM | Stockholm, Sweden | 366449 | 366 | 3/31/2016 1:10:00 | 1 | 3/31/2016 1:10:00 | ||||||||||||||||
20 | 6/7/2016 18:33:02 | 3/31/2016 | 2:50:00 AM | Anaheim,CA | 491xx5 | 491 | 3/31/2016 2:50:00 | 1 | 3/31/2016 2:50:00 | ||||||||||||||||
21 | 6/7/2016 8:41:07 | 3/31/2016 | 2:50:00 AM | Bergen | 3647XX | 364 | 3/31/2016 2:50:00 | 1 | 3/31/2016 2:50:00 | ||||||||||||||||
22 | 6/8/2016 9:36:28 | 3/31/2016 | 3:02:00 AM | Drammen, Norway | 364902 | 364 | 3/31/2016 3:02:00 | 1 | 3/31/2016 3:02:00 | ||||||||||||||||
23 | 6/7/2016 15:16:00 | 3/31/2016 | 3:10:00 AM | Norway | 365056 | 365 | 3/31/2016 3:10:00 | 1 | 3/31/2016 3:10:00 | ||||||||||||||||
24 | 6/7/2016 10:40:39 | 3/31/2016 | 3:15:00 AM | Norway | 365XXX | 365 | 3/31/2016 3:15:00 | 1 | 3/31/2016 3:15:00 | ||||||||||||||||
25 | 6/7/2016 15:53:59 | 3/31/2016 | 3:15:00 AM | Norway | 365688 | 365 | 3/31/2016 3:15:00 | 1 | 3/31/2016 3:15:00 | ||||||||||||||||
26 | 6/7/2016 9:19:17 | 3/31/2016 | 3:17:00 AM | Switzerland | 365XXX | 365 | 3/31/2016 3:17:00 | 1 | 3/31/2016 3:17:00 | ||||||||||||||||
27 | 6/7/2016 9:19:00 | 3/31/2016 | 3:19:00 AM | Zurich | 3654xx and 3654xx+2 for 2 reservations | 365 | 3/31/2016 3:19:00 | 1 | 3/31/2016 3:19:00 | ||||||||||||||||
28 | 6/7/2016 14:55:14 | 3/31/2016 | 3:55:00 AM | Norway | 366XXX | 366 | 3/31/2016 3:55:00 | 1 | 3/31/2016 3:55:00 | ||||||||||||||||
29 | 6/7/2016 14:15:08 | 3/31/2016 | 4:00:00 AM | Amsterdam | 368670 | 368 | 3/31/2016 4:00:00 | 1 | 3/31/2016 4:00:00 | ||||||||||||||||
30 | 6/7/2016 14:16:41 | 3/31/2016 | 4:00:00 AM | Amsterdam, the Netherlands | 368670 | 368 | 3/31/2016 4:00:00 | 1 | 3/31/2016 4:00:00 | ||||||||||||||||
31 | 6/7/2016 9:20:29 | 3/31/2016 | 4:04:00 AM | Belgium | 3663xx | 366 | 3/31/2016 4:04:00 | 1 | 3/31/2016 4:04:00 | ||||||||||||||||
32 | 6/7/2016 15:35:22 | 3/31/2016 | 4:10:00 AM | Berlin | 367764 | 367 | 3/31/2016 4:10:00 | 1 | 3/31/2016 4:10:00 | ||||||||||||||||
33 | 6/7/2016 15:59:47 | 3/31/2016 | 4:17:00 AM | Norway | 3668xx | 366 | 3/31/2016 4:17:00 | 1 | 3/31/2016 4:17:00 | ||||||||||||||||
34 | 6/7/2016 12:43:28 | 3/31/2016 | 4:20:00 AM | Norway | 365505 | 365 | 3/31/2016 4:20:00 | 1 | 3/31/2016 4:20:00 | ||||||||||||||||
35 | 6/7/2016 9:00:05 | 3/31/2016 | 4:26:00 AM | NAtick Mall, Natick, MA | 495XXX | 495 | 3/31/2016 4:26:00 | 1 | 3/31/2016 4:26:00 | ||||||||||||||||
36 | 6/7/2016 10:45:14 | 3/31/2016 | 4:30:00 AM | England | 3652XX | 365 | 3/31/2016 4:30:00 | 1 | 3/31/2016 4:30:00 | ||||||||||||||||
37 | 6/7/2016 16:31:15 | 3/31/2016 | 4:30:00 AM | Denmark | 367XXX | 367 | 3/31/2016 4:30:00 | 1 | 3/31/2016 4:30:00 | ||||||||||||||||
38 | 6/7/2016 16:36:55 | 3/31/2016 | 4:30:00 AM | Norway | 368XXX | 368 | 3/31/2016 4:30:00 | 1 | 3/31/2016 4:30:00 | ||||||||||||||||
39 | 6/7/2016 11:06:28 | 3/31/2016 | 4:47:00 AM | EU - Vienna | 3661XX | 366 | 3/31/2016 4:47:00 | 1 | 3/31/2016 4:47:00 | ||||||||||||||||
40 | 6/7/2016 10:36:54 | 3/31/2016 | 4:50:00 AM | Denmark | 367963 | 367 | 3/31/2016 4:50:00 | 1 | 3/31/2016 4:50:00 | ||||||||||||||||
41 | 6/7/2016 8:42:37 | 3/31/2016 | 4:53:00 AM | Germany | 367863 | 367 | 3/31/2016 4:53:00 | 1 | 3/31/2016 4:53:00 | ||||||||||||||||
42 | 6/8/2016 2:29:35 | 3/31/2016 | 4:54:00 AM | Germany | 367970 | 367 | 3/31/2016 4:54:00 | 1 | 3/31/2016 4:54:00 | ||||||||||||||||
43 | 6/7/2016 10:37:22 | 3/31/2016 | 4:56:00 AM | Germany | 367970 | 367 | 3/31/2016 4:56:00 | 1 | 3/31/2016 4:56:00 | ||||||||||||||||
44 | 6/7/2016 12:39:26 | 3/31/2016 | 5:00:00 AM | Czech Republic | 432896 | 432 | 3/31/2016 5:00:00 | 1 | 3/31/2016 5:00:00 | ||||||||||||||||
45 | 6/7/2016 14:22:51 | 3/31/2016 | 5:30:00 AM | New Jersey | 404871 | 404 | 3/31/2016 5:30:00 | 1 | 3/31/2016 5:30:00 | ||||||||||||||||
46 | 6/7/2016 16:15:37 | 3/31/2016 | 6:00:00 AM | Lausanne Switzerland | 369132 | 369 | 3/31/2016 6:00:00 | 1 | 3/31/2016 6:00:00 | ||||||||||||||||
47 | 6/7/2016 8:56:33 | 3/31/2016 | 6:25:00 AM | Brussels | 369XXX | 369 | 3/31/2016 6:25:00 | 1 | 3/31/2016 6:25:00 | ||||||||||||||||
48 | 6/7/2016 8:46:14 | 3/31/2016 | 7:12:00 AM | United Kingdom | 370XXX | 370 | 3/31/2016 7:12:00 | 1 | 3/31/2016 7:12:00 | ||||||||||||||||
49 | 6/7/2016 9:06:16 | 3/31/2016 | 7:15:00 AM | Palo Alto (El Camino) | 5008xx | 500 | 3/31/2016 7:15:00 | 1 | 3/31/2016 7:15:00 | ||||||||||||||||
50 | 6/7/2016 9:06:53 | 3/31/2016 | 7:15:00 AM | Palo Alto (El Camino) | 5008xx | 500 | 3/31/2016 7:15:00 | 1 | 3/31/2016 7:15:00 | ||||||||||||||||
51 | 6/7/2016 21:21:29 | 3/31/2016 | 7:35:00 AM | Chicago | 378xxx | 378 | 3/31/2016 7:35:00 | 1 | 3/31/2016 7:35:00 | ||||||||||||||||
52 | 6/8/2016 9:20:37 | 3/31/2016 | 7:55:00 AM | Denver, CO | 4969xx | 496 | 3/31/2016 7:55:00 | 1 | 3/31/2016 7:55:00 | ||||||||||||||||
53 | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | ||||||||||||||||
54 | 6/7/2016 11:25:36 | 3/31/2016 | 8:00:00 AM | United Kingdom | 3647XX | 364 | 3/31/2016 8:00:00 | 1 | 3/31/2016 8:00:00 | ||||||||||||||||
55 | 6/7/2016 12:55:06 | 3/31/2016 | 8:00:00 AM | Denver, CO | 381421 | 381 | 3/31/2016 8:00:00 | 1 | 3/31/2016 8:00:00 | ||||||||||||||||
56 | 6/7/2016 19:46:56 | 3/31/2016 | 8:00:00 AM | Denver, CO | 379xxx | 379 | 3/31/2016 8:00:00 | 1 | 3/31/2016 8:00:00 | ||||||||||||||||
57 | 6/7/2016 12:18:33 | 3/31/2016 | 9:00:00 AM | Montreal, QC, Canada | 3703XX | 370 | 3/31/2016 9:00:00 | 1 | 3/31/2016 9:00:00 | ||||||||||||||||
58 | 6/7/2016 21:11:53 | 3/31/2016 | 9:00:00 AM | Toronto, Canada | 370,3XX | 370 | 3/31/2016 9:00:00 | 1 | 3/31/2016 9:00:00 | ||||||||||||||||
59 | 6/7/2016 17:41:54 | 3/31/2016 | 9:04:00 AM | Munich | 370342 | 370 | 3/31/2016 9:04:00 | 1 | 3/31/2016 9:04:00 | ||||||||||||||||
60 | 6/7/2016 20:16:52 | 3/31/2016 | 9:05:00 AM | Toronto | 3704xx | 370 | 3/31/2016 9:05:00 | 1 | 3/31/2016 9:05:00 | ||||||||||||||||
61 | 6/7/2016 20:43:53 | 3/31/2016 | 9:05:00 AM | Toronto | 4704xx | 470 | 3/31/2016 9:05:00 | 1 | 3/31/2016 9:05:00 | ||||||||||||||||
62 | 6/7/2016 23:13:53 | 3/31/2016 | 9:10:00 AM | Toronto | 370510 | 370 | 3/31/2016 9:10:00 | 1 | 3/31/2016 9:10:00 | ||||||||||||||||
63 | 6/7/2016 8:38:55 | 3/31/2016 | 9:15:00 AM | Toronto, Canada | 3705xx | 370 | 3/31/2016 9:15:00 | 1 | 3/31/2016 9:15:00 | ||||||||||||||||
64 | 6/8/2016 3:46:37 | 3/31/2016 | 9:30:00 AM | Norway | 382xxx | 382 | 3/31/2016 9:30:00 | 1 | 3/31/2016 9:30:00 | ||||||||||||||||
65 | 6/7/2016 8:42:13 | 3/31/2016 | 9:33:00 AM | Montréal, Canada | 370xxx | 370 | 3/31/2016 9:33:00 | 1 | 3/31/2016 9:33:00 | ||||||||||||||||
66 | 6/7/2016 10:05:14 | 3/31/2016 | 9:35:00 AM | Shorthills Mall, NJ | 371461 | 371 | 3/31/2016 9:35:00 | 1 | 3/31/2016 9:35:00 | ||||||||||||||||
67 | 6/8/2016 14:43:23 | 3/31/2016 | 9:35:00 AM | Washington, DC | 410787 & 410788 | 410 | 3/31/2016 9:35:00 | 1 | 3/31/2016 9:35:00 | ||||||||||||||||
68 | 6/8/2016 14:26:36 | 3/31/2016 | 9:45:00 AM | Toronto | 370850 | 370 | 3/31/2016 9:45:00 | 1 | 3/31/2016 9:45:00 | ||||||||||||||||
69 | 6/8/2016 8:39:34 | 3/31/2016 | 9:58:00 AM | Maryland | 414xxx | 414 | 3/31/2016 9:58:00 | 1 | 3/31/2016 9:58:00 | ||||||||||||||||
70 | 6/7/2016 10:31:06 | 3/31/2016 | 10:00:00 AM | Atlanta, GA | 373XXX | 373 | 3/31/2016 10:00:00 | 1 | 3/31/2016 10:00:00 | ||||||||||||||||
71 | 6/7/2016 15:57:16 | 3/31/2016 | 10:00:00 AM | King Of Prussia Mall, PA | 371074 | 371 | 3/31/2016 10:00:00 | 1 | 3/31/2016 10:00:00 | ||||||||||||||||
72 | 6/7/2016 20:16:15 | 3/31/2016 | 10:00:00 AM | Monterey | 499045 | 499 | 3/31/2016 10:00:00 | 1 | 3/31/2016 10:00:00 | ||||||||||||||||
73 | 6/7/2016 15:41:53 | 3/31/2016 | 10:04:00 AM | New York, NY | 3710xx | 371 | 3/31/2016 10:04:00 | 1 | 3/31/2016 10:04:00 | ||||||||||||||||
74 | 6/7/2016 10:41:51 | 3/31/2016 | 10:05:00 AM | Cleveland, OH | 372XXX | 372 | 3/31/2016 10:05:00 | 1 | 3/31/2016 10:05:00 | ||||||||||||||||
75 | 6/7/2016 10:49:13 | 3/31/2016 | 10:05:00 AM | Pittsburgh PA | 371XXX | 371 | 3/31/2016 10:05:00 | 1 | 3/31/2016 10:05:00 | ||||||||||||||||
76 | 6/7/2016 12:04:16 | 3/31/2016 | 10:05:00 AM | Quebec | 4121xx | 412 | 3/31/2016 10:05:00 | 1 | 3/31/2016 10:05:00 | ||||||||||||||||
77 | 6/7/2016 12:06:00 | 3/31/2016 | 10:05:00 AM | Toronto | 371xxx | 371 | 3/31/2016 10:05:00 | 1 | 3/31/2016 10:05:00 | ||||||||||||||||
78 | 6/7/2016 14:18:50 | 3/31/2016 | 10:05:00 AM | Tysons | 371XXX | 371 | 3/31/2016 10:05:00 | 1 | 3/31/2016 10:05:00 | ||||||||||||||||
79 | 6/8/2016 1:43:54 | 3/31/2016 | 10:05:00 AM | Orlando | 371xxx | 371 | 3/31/2016 10:05:00 | 1 | 3/31/2016 10:05:00 | ||||||||||||||||
80 | 6/7/2016 9:30:51 | 3/31/2016 | 10:06:00 AM | Boston | 371500 | 371 | 3/31/2016 10:06:00 | 1 | 3/31/2016 10:06:00 | ||||||||||||||||
81 | 6/7/2016 17:59:03 | 3/31/2016 | 10:07:00 AM | Tyson's Corner VA store | 3758XX | 375 | 3/31/2016 10:07:00 | 1 | 3/31/2016 10:07:00 | ||||||||||||||||
82 | 6/7/2016 9:17:19 | 3/31/2016 | 10:09:00 AM | Dedham, Ma | 371xxx | 371 | 3/31/2016 10:09:00 | 1 | 3/31/2016 10:09:00 | ||||||||||||||||
83 | 6/7/2016 8:54:13 | 3/31/2016 | 10:10:00 AM | Mt. Kisco, NY | 371xxx | 371 | 3/31/2016 10:10:00 | 1 | 3/31/2016 10:10:00 | ||||||||||||||||
84 | 6/7/2016 9:03:27 | 3/31/2016 | 10:10:00 AM | Kansas City | 37xxxx | #VALUE! | 3/31/2016 10:10:00 | 1 | 3/31/2016 10:10:00 | ||||||||||||||||
85 | 6/7/2016 10:07:19 | 3/31/2016 | 10:10:00 AM | Shorthills Mall, NJ | 371461 | 371 | 3/31/2016 10:10:00 | 1 | 3/31/2016 10:10:00 | ||||||||||||||||
86 | 6/7/2016 10:42:24 | 3/31/2016 | 10:10:00 AM | NJ | 371XXX | 371 | 3/31/2016 10:10:00 | 1 | 3/31/2016 10:10:00 | ||||||||||||||||
87 | 6/7/2016 11:28:29 | 3/31/2016 | 10:10:00 AM | Waterloo, Ontario (Online) | 4127xx | 412 | 3/31/2016 10:10:00 | 1 | 3/31/2016 10:10:00 | ||||||||||||||||
88 | 6/7/2016 11:30:59 | 3/31/2016 | 10:10:00 AM | new york | 371820 | 371 | 3/31/2016 10:10:00 | 1 | 3/31/2016 10:10:00 | ||||||||||||||||
89 | 6/7/2016 11:43:42 | 3/31/2016 | 10:10:00 AM | Online | 4127** | 412 | 3/31/2016 10:10:00 | 1 | 3/31/2016 10:10:00 | ||||||||||||||||
90 | 6/7/2016 14:09:12 | 3/31/2016 | 10:10:00 AM | Portland, OR | 384xxx | 384 | 3/31/2016 10:10:00 | 1 | 3/31/2016 10:10:00 | ||||||||||||||||
91 | 6/7/2016 16:26:12 | 3/31/2016 | 10:10:00 AM | Mt. Kisco | 372XXX | 372 | 3/31/2016 10:10:00 | 1 | 3/31/2016 10:10:00 | ||||||||||||||||
92 | 6/7/2016 9:15:31 | 3/31/2016 | 10:15:00 AM | Paramus, NJ | 372XXX | 372 | 3/31/2016 10:15:00 | 1 | 3/31/2016 10:15:00 | ||||||||||||||||
93 | 6/7/2016 10:49:29 | 3/31/2016 | 10:15:00 AM | East Coast | 371XXX | 371 | 3/31/2016 10:15:00 | 1 | 3/31/2016 10:15:00 | ||||||||||||||||
94 | 6/7/2016 11:59:32 | 3/31/2016 | 10:15:00 AM | Tyson's Corner, VA | 371XXX | 371 | 3/31/2016 10:15:00 | 1 | 3/31/2016 10:15:00 | ||||||||||||||||
95 | 6/7/2016 12:37:12 | 3/31/2016 | 10:15:00 AM | Charlotte NC | 371965 | 371 | 3/31/2016 10:15:00 | 1 | 3/31/2016 10:15:00 | ||||||||||||||||
96 | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | ||||||||||||||||
97 | 6/7/2016 12:38:26 | 3/31/2016 | 10:15:00 AM | Mt. Kisco, NY | 372xxx | 372 | 3/31/2016 10:15:00 | 1 | 3/31/2016 10:15:00 | ||||||||||||||||
98 | 6/7/2016 17:58:32 | 3/31/2016 | 10:15:00 AM | Slovenia | 377497 | 377 | 3/31/2016 10:15:00 | 1 | 3/31/2016 10:15:00 | ||||||||||||||||
99 | 6/8/2016 7:04:37 | 3/31/2016 | 10:15:00 AM | Devon, PA | 372XXX | 372 | 3/31/2016 10:15:00 | 1 | 3/31/2016 10:15:00 | ||||||||||||||||
100 | 6/8/2016 15:13:57 | 3/31/2016 | 10:15:00 AM | Bethesda, MD | 374749 | 374 | 3/31/2016 10:15:00 | 1 | 3/31/2016 10:15:00 |