Spreadsheet: 151161d1334813830-count-sumproduct-in-data-range-only-with-condition-new-sample
Sheet: Individual WUXHA

 |  |  |  |  |  |  |  |  |  | Annual Summary
 |  |  |  |  |  | YTD |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Q1 | Q2 | Q3 | Q4
 |  |  |  |  |  | YTD |  | 一月 |  | 二月 |  | 三月 |  | 四月 |  | 五月 |  | 六月 |  | 七月 |  | 八月 |  | 九月 |  | 十月 |  | [NAME] |  | 十二月 |  | 第一季 | 第二季 | 第三季 | 第四季
 |  |  |  | 年初至今总合格接受报名 | Ttl. Qualified Enrolments YTD
 |  |  |  | 年初至今共有电邮捕捉 | Ttl. Email Capture YTD
 |  |  |  | 年初至今％的比率在 | Email Capture Ratio YTD (%)
 |  |  |  | 采取行动。合格的参赛名额（英法俄） | Act. Qualified Enrolments (EFR)
 |  |  |  | 采取行动。电子邮件捕捉（英法俄） | Act. Email Capture (EFR)
 |  |  |  | [NAME]） | [NAME] (bounceback)
REVENUE GENERATION |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QUARTLERY PERFORMANCE - REVENUE
创收 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 季度表现最佳 - 收入
Item |  |  |  |  |  | YTD |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Q1 | Q2 | Q3 | Q4
项目 |  |  |  |  |  | YTD |  | 一月 |  | 二月 |  | 三月 |  | 四月 |  | 五月 |  | 六月 |  | 七月 |  | 八月 |  | 九月 |  | 十月 |  | [NAME] |  | 十二月 |  | 第一季 | 第二季 | 第三季 | 第四季
 |  |  |  | [NAME] | Room Revenue
 |  |  |  | 餐饮乙收入 | F&B Revenue
 |  |  |  | 牧师共有房间 | Ttl. Rooms Rev.
 |  |  |  | 总收入
 |  |  |  | 共有夜 | Total Nights
 |  |  |  | 平均价格/夜 | Avg. Rate/Night
SECTION ENROLMENT PERFORMANCE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QUARTLERY TOP PERFORMER - SECTION
部门表现 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 季度表现最佳 - 第部门
Name | Section | Section | Target |  |  | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | Q1 | Q2 | Q3 | Q4
部分 | 部分 | 人员编制 | 目标 |  |  | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | 第一季 | 第二季 | 第三季 | 第四季
Front Desk |  | FD | 15
Guest Relations |  | GRO | 15
Club IC |  | CI | 15
GSM |  | GSM | 15
Managers |  | MGR | 15
INDIVIDUAL ENROLMENT PERFORMANCE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QUARTLERY TOP PERFORMER - INDIVIDUAL
个人表现 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 季度表现最好的 - 个人
Staff ID |  | Section | Target | PCR ID | EMP ID | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | Q1 | Q2 | Q3 | Q4
员工编号 |  | 部分 | 目标 | PCR ID | EMP ID | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | QE | @ | 第一季 | 第二季 | 第三季 | 第四季
FOVICKY | [NAME] | FD | 15 | 369078788 | 999765667
FOCHRIS | [NAME] - 周 渊 | FD | 15 | 289795717 | 231087199
FOANDRES | [NAME] - 赵 军 | FD | 15 | 813015310 | 824930253
FOCHARLENE | Charlene-郝雯 | FD | 15 | 329898018 | 297124781
FODIANA | Diana - 胡梦莉 | FD | 15 | 369077816 | 999766018
FOBEN | [NAME] | FD | 15 | 369077500 | 999766425
FOEMMA | Emma - 吴益能 | FD | 15 | 379144939 | 999767254
FOERIC | [NAME] | FD | 15 | 379144926 | 999767573
FOSHELLEY | Shelley - 张妍雯 | FD | 15 | 824970752 | 231087492
FOSUNNY | Sunny - 廖玲玲 | FD | 15 | 289788031
FOYUKI | [NAME] | FD | 10
FOCATHERINE | [NAME] | FD | 10
FOSARAH | [NAME] | CI | 10
FOWENDY | [NAME] | CI | 10
FOSOPHIA | Sophia-  戚茹平 | CI | 10
FOEMILY | Emily -廖妮 | CI | 10
FOAMANDA | Amanda -陆叶 | CI | 10
FOJUICY | Juicy - 黄珏 | CI | 10
FOELLEN | ELLEN-胡小玲 | GSM | 5
FOSTEVEN | STEVEN-姚鸿 | GRO | 5
FOSARINA | SARINA-黄建美 | GRO | 5
FONICK | NICK-李成成 | GRO | 5
FOANGELA | ANGELA-温岩 | GSM | 5
FOTERRY | TERRY-张晨 | GSM | 5