Spreadsheet: 148895d1333601842-indirect-sumproduct-counting-symbols-with-conditions-help-sample-pcr
Sheet: Jan

Period: | January | Year: | 2012 | Month #: | 01 | Ttl. Internal QE: |  | Missed:
Ttl. QE: |  | Ttl. Email |  | Capture:
Staff ID | [NAME] | [NAME] | Departure | Nts | Name | Conf. No. | PCR No. | Rm Rate | [NAME], | Room Rev.. | [NAME] | [NAME] | M/M | Arr | Lvl
FOSHELLY | 2012-01-01 00:00:00 | 2012-01-01 00:00:00 | 2012-01-01 00:00:00 | 1 | Name1 | 1154539 | 200100300 | 1000 | 100 | 2000 | [EMAIL]
FODIANA | 2012-01-19 00:00:00 | 2012-01-02 00:00:00 | 2012-01-02 00:00:00 | 2 | [NAME] | 1154540 | 200100301 | 2000 | 200 | 4000 | [EMAIL]
FODIANA | 2012-01-19 00:00:00 | 2012-01-03 00:00:00 | 2012-01-03 00:00:00 | 3 | Name3 | 1154541 | 200100302 | 3000 | 300 | 6000 | [EMAIL]
FODIANA | 2012-01-19 00:00:00 | 2012-01-04 00:00:00 | 2012-01-04 00:00:00 | 4 | Name4 | 1154542 | 200100303 | 1000 | 400 | 8000 | [EMAIL]
FOERIC | 2012-01-19 00:00:00 | 2012-01-05 00:00:00 | 2012-01-05 00:00:00 | 5 | Name5 | 1154543 | 200100304 | 2000 | 500 | 10000 | [EMAIL]
FOSTEVEN | 2012-01-19 00:00:00 | 2012-01-06 00:00:00 | 2012-01-06 00:00:00 | 6 | Name6 | 1154544 | 200100305 | 3000 | 600 | 12000 | [EMAIL]
FOERIC | 2012-01-19 00:00:00 | 2012-01-07 00:00:00 | 2012-01-07 00:00:00 | 7 | Name7 | 1154545 | 200100306 | 1000 | 700 | 14000 | [EMAIL]
FOCHRIS | 2012-01-19 00:00:00 | 2012-01-08 00:00:00 | 2012-01-08 00:00:00 | 8 | Name8 | 1154546 | 200100307 | 2000 | 800 | 16000 | [EMAIL]
FOCHRIS | 2012-01-19 00:00:00 | 2012-01-09 00:00:00 | 2012-01-09 00:00:00 | 1 | Name9 | 1154547 | 200100308 | 3000 | 900 | 18000 | [EMAIL]
FOSARINA | 2012-01-19 00:00:00 | 2012-01-10 00:00:00 | 2012-01-10 00:00:00 | 1 | Name10 | 1154548 | 200100309 | 1000 | 1000 | 20000 | [EMAIL]
FOSHELLY | 2012-01-19 00:00:00 | 2012-01-11 00:00:00 | 2012-01-11 00:00:00 | 1 | Name11 | 1154549 | 200100310 | 2000 | 1100 | 22000 | [EMAIL]
FOANDRES | 2012-01-19 00:00:00 | 2012-01-12 00:00:00 | 2012-01-12 00:00:00 | 1 | Name12 | 1154550 | 200100311 | 3000 | 1200 | 24000 | [EMAIL]
FOEMMA | 2012-01-18 00:00:00 | 2012-01-13 00:00:00 | 2012-01-13 00:00:00 | 2 | Name13 | 1154551 | 200100312 | 1000 | 1300 | 26000 | [EMAIL]
FOVICKY | 2012-01-19 00:00:00 | 2012-01-14 00:00:00 | 2012-01-14 00:00:00 | 3 | Name14 | 1154552 | 200100313 | 2000 | 1400 | 28000 | [EMAIL]
FOVICKY | 2012-01-18 00:00:00 | 2012-01-15 00:00:00 | 2012-01-15 00:00:00 | 2 | Name15 | 1154553 | 200100314 | 3000 | 1500 | 30000 | [EMAIL]
FOVICKY | 2012-01-18 00:00:00 | 2012-01-16 00:00:00 | 2012-01-16 00:00:00 | 1 | [NAME] | 1154554 | 200100315 | 1000 | 1600 | 32000 | [EMAIL]
FOVICKY | 2012-01-18 00:00:00 | 2012-01-17 00:00:00 | 2012-01-17 00:00:00 | 1 | Name17 | 1154555 | 200100316 | 2000 | 1700 | 34000 | [EMAIL]
FOANDRES | 2012-01-18 00:00:00 | 2012-01-18 00:00:00 | 2012-01-18 00:00:00 | 1 | Name18 | 1154556 | 200100317 | 3000 | 1800 | 36000 | [EMAIL]
FOANDRES | 2012-01-18 00:00:00 | 2012-01-19 00:00:00 | 2012-01-19 00:00:00 | 1 | Name19 | 1154557 | 200100318 | 1000 | 1900 | 38000 | [EMAIL]
FOEMMA | 2012-01-18 00:00:00 | 2012-01-20 00:00:00 | 2012-01-20 00:00:00 | 1 | [NAME] | 1154558 | 200100319 | 2000 | 2000 | 40000 | [EMAIL]
FOEMMA | 2012-01-18 00:00:00 | 2012-01-21 00:00:00 | 2012-01-21 00:00:00 | 1 | Name21 | 1154559 | 200100320 | 3000 | 2100 | 42000 | [EMAIL]
FOEMMA | 2012-01-18 00:00:00 | 2012-01-22 00:00:00 | 2012-01-22 00:00:00 | 1 | Name22 | 1154560 | 200100321 | 1000 | 2200 | 44000 | [EMAIL]
FOSHELLY | 2012-01-18 00:00:00 | 2012-01-23 00:00:00 | 2012-01-23 00:00:00 | 1 | Name23 | 1154561 | 200100322 | 2000 | 2300 | 46000 | [EMAIL]
FOSHELLY | 2012-01-18 00:00:00 | 2012-01-24 00:00:00 | 2012-01-24 00:00:00 | 1 | Name24 | 1154562 | 200100323 | 3000 | 2400 | 48000 | [EMAIL]
FOSHELLY | 2012-01-18 00:00:00 | 2012-01-25 00:00:00 | 2012-01-25 00:00:00 | 1 | Name25 | 1154563 | 200100324 | 1000 | 2500 | 50000 | [EMAIL]
FOVICKY | 2012-01-18 00:00:00 | 2012-01-26 00:00:00 | 2012-01-26 00:00:00 | 1 | Name26 | 1154564 | 200100325 | 2000 | 2600 | 52000 | [EMAIL]
FOVICKY | 2012-01-18 00:00:00 | 2012-01-27 00:00:00 | 2012-01-27 00:00:00 | 2 | Name27 | 1154565 | 200100326 | 3000 | 2700 | 54000 | [EMAIL]
FOVICKY | 2012-01-18 00:00:00 | 2012-01-28 00:00:00 | 2012-01-28 00:00:00 | 0 | Name28 | 1154566 | 200100327 | 1000 | 2800 | 56000 | [EMAIL]
FOVICKY | 2012-01-18 00:00:00 | 2012-01-29 00:00:00 | 2012-01-29 00:00:00 | 3 | Name29 | 1154567 | 200100328 | 2000 | 2900 | 58000 | [EMAIL]
FOVICKY | 2012-01-18 00:00:00 | 2012-01-30 00:00:00 | 2012-01-30 00:00:00 | 6 | Name30 | 1154568 | 200100329 | 3000 | 3000 | 60000 | [EMAIL]
FOVICKY | 2012-01-18 00:00:00 | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 | 1 | Name31 | 1187816 | 200100330 | 1000 | 3100 | 62000 | [EMAIL]
FOCHRIS | 2012-01-18 00:00:00 | 2012-02-01 00:00:00 | 2012-02-01 00:00:00 | 1 | Name32 | 1156329 | 200100331 | 2000 | 3200 | 64000 | [EMAIL]
FOCHRIS | 2012-01-18 00:00:00 | 2012-02-02 00:00:00 | 2012-02-02 00:00:00 | 1 | Name33 | 1156328 | 200100332 | 3000 | 3300 | 66000 | [EMAIL]
FOANDRES | 2012-01-18 00:00:00 | 2012-02-03 00:00:00 | 2012-02-03 00:00:00 | 2 | [NAME] | 1178067 | 200100333 | 1000 | 3400 | 68000 | [EMAIL]
FOANDRES | 2012-01-18 00:00:00 | 2012-02-04 00:00:00 | 2012-02-04 00:00:00 | 1 | Name35 | 1160823 | 200100334 | 2000 | 3500 | 70000 | [EMAIL]
FOEMMA | 2012-01-18 00:00:00 | 2012-02-05 00:00:00 | 2012-02-05 00:00:00 | 1 | Name36 | 1188566 | 200100335 | 3000 | 3600 | 72000 | [EMAIL]
FOEMMA | 2012-01-18 00:00:00 | 2012-02-06 00:00:00 | 2012-02-06 00:00:00 | 1 | Name37 | 1188816 | 200100336 | 1000 | 3700 | 74000 | [EMAIL]
FOEMMA | 2012-01-18 00:00:00 | 2012-02-07 00:00:00 | 2012-02-07 00:00:00 | 1 | Name38 | 1187566 | 200100337 | 2000 | 3800 | 76000 | [EMAIL]
FOEMMA | 2012-01-18 00:00:00 | 2012-02-08 00:00:00 | 2012-02-08 00:00:00 | 1 | [NAME] | 1189068 | 200100338 | 3000 | 3900 | 78000 | [EMAIL]
FOEMMA | 2012-01-18 00:00:00 | 2012-02-09 00:00:00 | 2012-02-09 00:00:00 | 1 | Name40 | 1189070 | 200100339 | 1000 | 4000 | 80000 | [EMAIL]
FOBEN | 2012-01-18 00:00:00 | 2012-02-10 00:00:00 | 2012-02-10 00:00:00 | 1 | Name41 | 1184067 | 200100340 | 2000 | 4100 | 82000 | [EMAIL]
FOANDRES | 2012-01-18 00:00:00 | 2012-02-11 00:00:00 | 2012-02-11 00:00:00 | 3 | Name42 | 1182712 | 200100341 | 3000 | 4200 | 84000 | [EMAIL]
FOANDRES | 2012-01-18 00:00:00 | 2012-02-12 00:00:00 | 2012-02-12 00:00:00 | 4 | Name43 | 1182591 | 200100342 | 1000 | 4300 | 86000 | [EMAIL]
FOANDRES | 2012-01-18 00:00:00 | 2012-02-13 00:00:00 | 2012-02-13 00:00:00 | 1 | Name44 | 1190317 | 200100343 | 2000 | 4400 | 88000 | [EMAIL]
FODIANA | 2012-01-18 00:00:00 | 2012-02-14 00:00:00 | 2012-02-14 00:00:00 | 1 | Name45 | 1191070 | 200100344 | 3000 | 4500 | 90000 | [EMAIL]
FODIANA | 2012-01-18 00:00:00 | 2012-02-15 00:00:00 | 2012-02-15 00:00:00 | 1 | Name46 | 1133316 | 200100345 | 1000 | 4600 | 92000 | [EMAIL]
FOWENDY | 2012-01-18 00:00:00 | 2012-02-16 00:00:00 | 2012-02-16 00:00:00 | 1 | [NAME] | 1177317 | 200100346 | 2000 | 4700 | 94000 | [EMAIL]
FOBEN | 2012-01-18 00:00:00 | 2012-02-17 00:00:00 | 2012-02-17 00:00:00 | 2 | Name48 | 1064820 | 200100347 | 3000 | 4800 | 96000 | [EMAIL]
FOBEN | 2012-01-18 00:00:00 | 2012-02-18 00:00:00 | 2012-02-18 00:00:00 | 2 | Name49 | 1182658 | 200100348 | 1000 | 4900 | 98000 | [EMAIL]
FOBEN | 2012-01-18 00:00:00 | 2012-02-19 00:00:00 | 2012-02-19 00:00:00 | 4 | Name50 | 1182675 | 200100349 | 2000 | 5000 | 100000 | [EMAIL]
FOBEN | 2012-01-18 00:00:00 | 2012-02-20 00:00:00 | 2012-02-20 00:00:00 | 3 | Name51 | 1183635 | 200100350 | 3000 | 5100 | 102000 | [EMAIL]
FOBEN | 2012-01-18 00:00:00 | 2012-02-21 00:00:00 | 2012-02-21 00:00:00 | 2 | [NAME] | 1195570 | 200100351 | 1000 | 5200 | 104000 | [EMAIL]
FOCHRIS | 2012-01-18 00:00:00 | 2012-02-22 00:00:00 | 2012-02-22 00:00:00 | 2 | Name53 | 1183639 | 200100352 | 2000 | 5300 | 106000 | [EMAIL]
FOCHRIS | 2012-01-18 00:00:00 | 2012-02-23 00:00:00 | 2012-02-23 00:00:00 | 3 | Name54 | 1182625 | 200100353 | 3000 | 5400 | 108000 | [EMAIL]
FOCHRIS | 2012-01-18 00:00:00 | 2012-02-24 00:00:00 | 2012-02-24 00:00:00 | 3 | Name55 | 1182619 | 200100354 | 1000 | 5500 | 110000 | [EMAIL]
FOCHRIS | 2012-01-18 00:00:00 | 2012-02-25 00:00:00 | 2012-02-25 00:00:00 | 3 | Name56 | 1182617 | 200100355 | 2000 | 5600 | 112000 | [EMAIL]
FOCHRIS | 2012-01-18 00:00:00 | 2012-02-26 00:00:00 | 2012-02-26 00:00:00 | 4 | Name57 | 1182673 | 200100356 | 3000 | 5700 | 114000 | [EMAIL]
FOCHRIS | 2012-01-18 00:00:00 | 2012-02-27 00:00:00 | 2012-02-27 00:00:00 | 6 | Name58 | 1183681 | 200100357 | 1000 | 5800 | 116000 | [EMAIL]
FOCHRIS | 2012-01-18 00:00:00 | 2012-02-28 00:00:00 | 2012-02-28 00:00:00 | 3 | Name59 | 1141317 | 200100358 | 2000 | 5900 | 118000 | [EMAIL]
FODIANA | 2012-01-18 00:00:00 | 2012-02-29 00:00:00 | 2012-02-29 00:00:00 | 3 | Name60 | 1182633 | 200100359 | 3000 | 6000 | 120000 | [EMAIL]
FODIANA | 2012-01-18 00:00:00 | 2012-03-01 00:00:00 | 2012-03-01 00:00:00 | 3 | Name61 | 1183643 | 200100360 | 1000 | 6100 | 122000 | [EMAIL]
FODIANA | 2012-01-18 00:00:00 | 2012-03-02 00:00:00 | 2012-03-02 00:00:00 | 3 | Name62 | 1183642 | 200100361 | 2000 | 6200 | 124000 | [EMAIL]
FODIANA | 2012-01-18 00:00:00 | 2012-03-03 00:00:00 | 2012-03-03 00:00:00 | 3 | Name63 | 1182638 | 200100362 | 3000 | 6300 | 126000 | [EMAIL]
FODIANA | 2012-01-18 00:00:00 | 2012-03-04 00:00:00 | 2012-03-04 00:00:00 | 3 | Name64 | 1098066 | 200100363 | 1000 | 6400 | 128000 | [EMAIL]
FODIANA | 2012-01-18 00:00:00 | 2012-03-05 00:00:00 | 2012-03-05 00:00:00 | 2 | Name65 | 1064817 | 200100364 | 2000 | 6500 | 130000 | [EMAIL]
FODIANA | 2012-01-18 00:00:00 | 2012-03-06 00:00:00 | 2012-03-06 00:00:00 | 3 | Name66 | 1199566 | 200100365 | 3000 | 6600 | 132000 | [EMAIL]
FOVICKY | 2012-01-18 00:00:00 | 2012-03-07 00:00:00 | 2012-03-07 00:00:00 | 4 | [NAME] | 1182632 | 200100366 | 1000 | 6700 | 134000 | [EMAIL]
FOVICKY | 2012-01-18 00:00:00 | 2012-03-08 00:00:00 | 2012-03-08 00:00:00 | 4 | [NAME] | 1182626 | 200100367 | 2000 | 6800 | 136000 | [EMAIL]
FOVICKY | 2012-01-18 00:00:00 | 2012-03-09 00:00:00 | 2012-03-09 00:00:00 | 4 | Name69 | 1182603 | 200100368 | 3000 | 6900 | 138000 | [EMAIL]
FOVICKY | 2012-01-18 00:00:00 | 2012-03-10 00:00:00 | 2012-03-10 00:00:00 | 4 | Name70 | 1182692 | 200100369 | 1000 | 7000 | 140000 | [EMAIL]
FOVICKY | 2012-01-18 00:00:00 | 2012-03-11 00:00:00 | 2012-03-11 00:00:00 | 4 | Name71 | 1183634 | 200100370 | 2000 | 7100 | 142000 | [EMAIL]
FOCHARLENE | 2012-01-18 00:00:00 | 2012-03-12 00:00:00 | 2012-03-12 00:00:00 | 1 | Name72 | 1183093 | 200100371 | 3000 | 7200 | 144000 | [EMAIL]
FOCHARLENE | 2012-01-18 00:00:00 | 2012-03-13 00:00:00 | 2012-03-13 00:00:00 | 1 | [NAME] | 1183077 | 200100372 | 1000 | 7300 | 146000 | [EMAIL]
FOCHARLENE | 2012-01-18 00:00:00 | 2012-03-14 00:00:00 | 2012-03-14 00:00:00 | 1 | Name74 | 1183078 | 200100373 | 2000 | 7400 | 148000 | [EMAIL]
FOCHARLENE | 2012-01-18 00:00:00 | 2012-03-15 00:00:00 | 2012-03-15 00:00:00 | 1 | Name75 | 1203832 | 200100374 | 3000 | 7500 | 150000 | [EMAIL]
FOERIC | 2012-01-18 00:00:00 | 2012-03-16 00:00:00 | 2012-03-16 00:00:00 | 1 | Name76 | 1182645 | 200100375 | 1000 | 7600 | 152000 | [EMAIL]
FOCHRIS | 2012-01-18 00:00:00 | 2012-03-17 00:00:00 | 2012-03-17 00:00:00 | 1 | Name77 | 1184081 | 200100376 | 2000 | 7700 | 154000 | [EMAIL]
FOCHRIS | 2012-01-18 00:00:00 | 2012-03-18 00:00:00 | 2012-03-18 00:00:00 | 1 | Name78 | 1205317 | 200100377 | 3000 | 7800 | 156000 | [EMAIL]