Spreadsheet: 98713d1297557537-excel-2007-combo-box-formula-calculation-room-pickup
Sheet: Multiple Hotel Pickup Tracker

 | MULTIPLE HOTEL PICKUP TRACKER
 | Dates | 2011-07-24 00:00:00 | 2011-07-25 00:00:00 | 2011-07-26 00:00:00 | 2011-07-27 00:00:00 | 2011-07-28 00:00:00 | 2011-07-29 00:00:00 | 2011-07-30 00:00:00 | 2011-07-31 00:00:00 | 2011-08-01 00:00:00 | 2011-08-02 00:00:00 | 2011-08-03 00:00:00 | 2011-08-04 00:00:00 | 2011-08-06 00:00:00 | 2011-08-07 00:00:00
 |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Sat | Sun | TOTAL | % Block | $
 | [NAME] |  |  |  |  |  |  | Do not enter in grey areas
Block |  | 15 | 25 | 59 | 74 | 169 | 174 | 184 | 37 | 22 | 4 | 0 | 0 | 0 | 0 | 735 |  | 86730
14 weeks | 2011-02-17 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 weeks | 2011-02-24 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
12 weeks | 2011-03-03 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
11 weeks | 2011-03-10 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10 weeks | 2011-03-17 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
9 weeks | 2011-03-24 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 weeks | 2011-03-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 weeks | 2011-04-07 00:00:00 | 0 | 0 | 0 | 2 | 2 | 14 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 32 | 0.04353741496598639 | 3904
6 weeks | 2011-04-14 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 weeks | 2011-04-21 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 weeks | 2011-04-28 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 weeks | 2011-05-05 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 weeks | 2011-05-12 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 weeks | 2011-05-19 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 weeks | 2011-05-26 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Final |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | 0.005442176870748299 | 488
ES-CC | Dates | 2011-07-24 00:00:00 | 2011-07-25 00:00:00 | 2011-07-26 00:00:00 | 2011-07-27 00:00:00 | 2011-07-28 00:00:00 | 2011-07-29 00:00:00 | 2011-07-30 00:00:00 | 2011-07-31 00:00:00 | 2011-08-01 00:00:00 | 2011-08-02 00:00:00 | 2011-08-03 00:00:00 | 2011-08-04 00:00:00 | 2011-08-06 00:00:00 | 2011-08-07 00:00:00
 |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Sat | Sun
Block | 122 | 0 | 0 | 4 | 9 | 19 | 22 | 22 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 80 |  | 9760
14 weeks | 2010-12-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
13 weeks | 2010-12-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
12 weeks | 2011-01-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
11 weeks | 2011-01-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10 weeks | 2011-01-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
9 weeks | 2011-01-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
8 weeks | 2011-02-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
7 weeks | 2011-02-10 00:00:00 |  |  |  | 2 | 2 | 14 | 14 |  |  |  |  |  |  |  | 32 | 0.4 | 3904
6 weeks | 2011-02-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
5 weeks | 2011-02-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
4 weeks | 2011-03-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
3 weeks | 2011-03-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
2 weeks | 2011-03-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
1 weeks | 2011-03-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
0 weeks | 2011-03-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Final |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 4 | 0.05 | 488
[NAME] | Dates | 2011-07-24 00:00:00 | 2011-07-25 00:00:00 | 2011-07-26 00:00:00 | 2011-07-27 00:00:00 | 2011-07-28 00:00:00 | 2011-07-29 00:00:00 | 2011-07-30 00:00:00 | 2011-07-31 00:00:00 | 2011-08-01 00:00:00 | 2011-08-02 00:00:00 | 2011-08-03 00:00:00 | 2011-08-04 00:00:00 | 2011-08-06 00:00:00 | 2011-08-07 00:00:00
 |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Sat | Sun
Block | 179 | 15 | 25 | 40 | 40 | 40 | 40 | 40 | 0 | 0 | 0 | 0 |  |  |  | 225
14 weeks | 2011-02-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
13 weeks | 2011-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
12 weeks | 2011-03-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
11 weeks | 2011-03-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10 weeks | 2011-03-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
9 weeks | 2011-03-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
8 weeks | 2011-04-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
7 weeks | 2011-04-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
6 weeks | 2011-04-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
5 weeks | 2011-04-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
4 weeks | 2011-05-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
3 weeks | 2011-05-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
2 weeks | 2011-05-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
1 weeks | 2011-05-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
0 weeks | 2011-05-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Final |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Four Points CC | Dates | 2011-07-24 00:00:00 | 2011-07-25 00:00:00 | 2011-07-26 00:00:00 | 2011-07-27 00:00:00 | 2011-07-28 00:00:00 | 2011-07-29 00:00:00 | 2011-07-30 00:00:00 | 2011-07-31 00:00:00 | 2011-08-01 00:00:00 | 2011-08-02 00:00:00 | 2011-08-03 00:00:00 | 2011-08-04 00:00:00 | 2011-08-06 00:00:00 | 2011-08-07 00:00:00
 |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Sat | Sun
Block | 179 | 0 | 0 | 15 | 25 | 125 | 125 | 125 | 15 | 0 | 0 | 0 | 0 |  |  | 430 |  | 76970
14 weeks | 2011-02-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
13 weeks | 2011-02-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
12 weeks | 2011-03-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
11 weeks | 2011-03-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10 weeks | 2011-03-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
9 weeks | 2011-03-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
8 weeks | 2011-03-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
7 weeks | 2011-04-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
6 weeks | 2011-04-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
5 weeks | 2011-04-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
4 weeks | 2011-04-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
3 weeks | 2011-05-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
2 weeks | 2011-05-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
1 weeks | 2011-05-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
0 weeks | 2011-05-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Final |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Embassy Suites DC | Dates | 2011-07-24 00:00:00 | 2011-07-25 00:00:00 | 2011-07-26 00:00:00 | 2011-07-27 00:00:00 | 2011-07-28 00:00:00 | 2011-07-29 00:00:00 | 2011-07-30 00:00:00 | 2011-07-31 00:00:00 | 2011-08-01 00:00:00 | 2011-08-02 00:00:00 | 2011-08-03 00:00:00 | 2011-08-04 00:00:00 | 2011-08-06 00:00:00 | 2011-08-07 00:00:00
 |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Sat | Sun
Block | 229 | 0 | 0 | 25 | 40 | 40 | 40 | 40 | 0 | 0 | 0 | 0 |  |  |  | 185
14 weeks | 2011-02-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
13 weeks | 2011-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
12 weeks | 2011-03-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
11 weeks | 2011-03-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10 weeks | 2011-03-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
9 weeks | 2011-03-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
8 weeks | 2011-04-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
7 weeks | 2011-04-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
6 weeks | 2011-04-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
5 weeks | 2011-04-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
4 weeks | 2011-05-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
3 weeks | 2011-05-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
2 weeks | 2011-05-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
1 weeks | 2011-05-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
0 weeks | 2011-05-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Final |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Sheraton Crystal City | Dates | 2011-07-24 00:00:00 | 2011-07-25 00:00:00 | 2011-07-26 00:00:00 | 2011-07-27 00:00:00 | 2011-07-28 00:00:00 | 2011-07-29 00:00:00 | 2011-07-30 00:00:00 | 2011-07-31 00:00:00 | 2011-08-01 00:00:00 | 2011-08-02 00:00:00 | 2011-08-03 00:00:00 | 2011-08-04 00:00:00 | 2011-08-06 00:00:00 | 2011-08-07 00:00:00
 |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Sat | Sun
Block | 170 | 15 | 25 | 40 | 40 | 40 | 40 | 40 | 0 | 0 | 0 | 0 |  |  |  | 225
14 weeks | 2011-02-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
13 weeks | 2011-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
12 weeks | 2011-03-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
11 weeks | 2011-03-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
10 weeks | 2011-03-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
9 weeks | 2011-03-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
8 weeks | 2011-04-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
7 weeks | 2011-04-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
6 weeks | 2011-04-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
5 weeks | 2011-04-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
4 weeks | 2011-05-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
3 weeks | 2011-05-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
2 weeks | 2011-05-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
1 weeks | 2011-05-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
0 weeks | 2011-05-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Final |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0