{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["1| Select Titles","2| FTE Counts","3| Compensation","Sheet1","4| Retirement & Other Benefits","5a| Health Plan Summary","5b| Health Plan Details","Benefits Upload","Comp Upload","CB USE ONLY"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":5,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1| Select Titles","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[8,1,8,3],[7,1,7,3],[6,1,6,3],[1,3,1,5],[2,2,2,4],[3,1,3,2],[4,1,4,2],[3,3,3,4],[4,3,4,4]]}
[]
[null,null,null,"Executive Team Worksheet "]
[null,null,"      \n"]
[null,"Club Name:"]
[null,"Fiscal Year End Month:"]
[]
[null,"How frequent are the club's pay periods? ",null,null,"Click to Select"]
[null,"When do annual compensation reviews happen?",null,null,"Click to Select"]
[null,"When do annual pay raises go into effect? ",null,null,"Click to Select"]
[null,null,null,"Does the GM oversee the POA/HOA?","Yes or No? "]

{"sheet":"2| FTE Counts","index":1,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[[10,1,10,2],[4,1,4,2],[5,1,5,2],[1,1,1,2],[2,1,2,2],[3,1,3,2]]}
[]
[null,"Full Time Equivalent Worksheet                                "]
[null,"Instructions"]
[null,"Full Time Equivalent is calculated based on 40 hours per week times 52 weeks or 2,080 hours."]
[null,"Please enter the total number of hours, including overtime hours,  worked by all staff in the club and/or specified department."]
[null,"If your payroll system does not track hours for salaried employees please add a calculation of 40 hours for every week they were employed by the club that year. "]
[null,"Clubwide Metrics","FTE Count"]
[null,"FTE Count Across all departments in Club"]
[null,"Peak Employee Count throughout year"]
[null,"FTE Count per Affordable Care Act Definition"]
[null,"Department Metrics"]
[null,"Department Title","Total Hours Worked","Calculated FTE Count\nDo Not Enter Text in this Column"]
[null,"General & Administration\nIncluding General Manager, AGM & Clubhouse Manager, Finance, Marketing/Membership, IT, HR and Office Staff.",null,{"$f":"IF((C13/2080)=0,\"\",(C13/2080))","v":""}]
[null,"Security Staff",null,{"$f":"IF((C14/2080)=0,\"\",(C14/2080))","v":""}]
[null,"Clubhouse - Facilities Support Staff",null,""]
[null,"Clubhouse - Guest Rooms",null,""]
[null,"FTE Count Across All HOA/POA Departments",null,""]
[null,"Food & Beverage Front and Back of House",null,""]
[null,"Community Grounds and Road Maintenance\nExcluding any course maintenance staff if a separate crew",null,""]
[null,"Tennis/Racquets Department",null,""]
[null,"Fitness Department",null,""]
[null,"Aquatics Department",null,""]
[null,"Yacht/Waterfront Department",null,""]

{"sheet":"3| Compensation","index":2,"n_rows":23,"n_cols":27,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,2],[21,1,22,1],[15,1,16,1],[17,1,20,1],[9,1,14,1],[3,1,5,1],[6,1,8,1]]}
[]
[null,"Executive Compensation",null,null,"Head of Club",null,"Head of Finance\n(CFO/Controller)",null,"Executive Chef",null,"F&B Director",null,"Assistant General Manager",null,"Fitness Director",null,"Head of Facilities Maintenance",null,"Events & Catering Director",null,"Head of Human Resources",null,"Membership Director",null,"Head of Tennis/Racquets",null,"Clubhouse Manager"]
[null,null,"Previous Calendar Year"]
[null,"Completed Year Compensation\nBase Salary","Base rate\n   (Enter the base salary rate for the calendar year)"]
[null,null,"Lesson Compensation"]
[null,null,"Commission Compensation"]
[null,"Variable Pay","Performance/Discretionary Bonuses \n    (Excluding holiday bonus)"]
[null,null,"Holiday Bonus"]
[null,null,"Maximum bonus amount employee is eligible for \n(As a percent of base salary)"]
[null,"Allowances (in completed year)","Auto Allowance"]
[null,null,"Housing Allowance"]
[null,null,"Clothing Allowance\n(Include dry cleaning)"]
[null,null,"Education Allowance "]
[null,null,"Competitive Dining Allowance"]
[null,null,"Other Allowance\n (i.e. cell phone, child care, professional planning?)"]
[null,"Deferred Compensation","Club’s Contribution to Employee’s 457b Plan"]
[null,null,"Club’s Contribution to Employee’s 457f Plan"]
[null,"Benefits","Does this Employee receive club privileges? Y/N",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select"]
[null,null,"Is employee eligible for short term disability? Y/N",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select"]
[null,null,"Is employee eligible for long term disability? Y/N",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select",null,"Click to Select"]
[null,null,"Face value of the employee's life insurance policy"]
[null,"Employee Information","Age"]
[null,null,"How many years has the employee \nheld their current position at your club?"]

{"sheet":"Sheet1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"4| Retirement & Other Benefits","index":4,"n_rows":49,"n_cols":3,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Retirement & Other Benefits"]
[null,"401(k) Plans"]
[null,"Do you offer a 401k retirement plan? ","Click to Select"]
[null,"After how many months are employees eligible to participate?","Click to Select"]
[null,"What is the maximum matching contribution by the Club?\n(If no match select \"no match\")","Click to Select"]
[null,"Is there a vesting schedule on matching?","Click to Select"]
[null,"     If yes, what is the vesting period?","Click to Select"]
[null,"Does the Club make a profit-sharing contribution?","Click to Select"]
[null,"Deferred Compensation Plans"]
[null,"Do you offer a deferred compensation plan?","Click to Select"]
[null,"Performance Bonus Plans"]
[null,"Which employees are eligible for performance bonus?\n(Check all that apply)"]
[null,"           General Manager"]
[null,"           Executive Staff"]
[null,"           Salaried Staff"]
[null," No employee receives performance bonus"]
[null,"If applicable, what percentage of base salary can be earned in\nperformance bonus for the following employees?"]
[null,"                         General Manager","Click to Select"]
[null,"                         Executive Staff","Click to Select"]
[null,"                         Salaried Staff","Click to Select"]
[null,"What criteria determine General Manager bonus?\n(Check all that apply)"]
[null,"           Discretionary"]
[null,"           Specific Goals"]
[null,"           Club-wide Quantitative Metrics"]
[null,"           Club-wide Qualitative Metrics"]
[null,"           Department Quantitative Metrics"]
[null,"           Department Qualitative Metrics"]
[null,"What criteria determine staff & department head bonuses?\n(Check all that apply.)"]
[null,"           Discretionary"]
[null,"           Specific Goals"]
[null,"           Club-wide Quantitative Metrics"]
[null,"           Club-wide Qualitative Metrics"]
[null,"           Department Quantitative Metrics"]
[null,"           Department Qualitative Metrics"]
[]
[null,"Other Benefits"]
[null,"What is included in your club's benefit packages? "]
[null,"           Disability Insurance"]
[null,"           Life Insurance"]
[null,"Maximum days of vacation after one year of full time employment"]
[null,"Maximum days of vacation a full time employee can earn in given year"]
[null,"Years of full time employment required for maximum vacation days"]
[null,"Who is eligible for sick days?\n(Check all that apply.)"]
[null,"           Full time employees"]
[null,"           Part time employees"]
[null,"           Seasonal employees"]
[null,"           No employees"]
[null,"What is the maximum number of annual sick days allowed for an employee?"]

{"sheet":"5a| Health Plan Summary","index":5,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Health Insurance Plan Summary"]
[null,"Plan Summary"]
[null,"Total Number of Full Time Equivalents per Affordable Care Act Definition"]
[null,"Total Number of Employees Electing Club's Plan"]
[null,"Which of the following are included in the healthcare plan?"]
[null,"           Dental"]
[null,"           Vision Care"]
[null,"           Health Savings Account"]
[null,"           Long Term Care"]
[null,"           Cafeteria Plan"]
[]
[null,"Does the Club contribute to the employee's health savings account?","Click to Select"]
[null,"     If yes, how much does the Club contribute?"]
[null,"Club's Total Healthcare Insurance Expense - if zero enter zero \n(Annual total club contribution for all enrolled employees in all departments.) "]
[]
[null,"Which describes the Club’s approach to managing health insurance expenses?"]
[null,"           Shifting more of burden to employee"]
[null,"           Making plan better for Employee as a way to attract and retain"]
[null,"           Moving employees to healthcare exchanges and paying penalties"]
[null,"           No change in current strategy"]

{"sheet":"5b| Health Plan Details","index":6,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Health Insurance Plan Details",null,"Traditional HMO",null,"Traditional PPO",null,"High Deductible Plan"]
[null,"Healthcare Plan Expenses"]
[null,"Total Annual Premium for an 'Individual Plan' (total paid annually by Club and Employee)","$"]
[null,"Total Annual Premium for a 'Family Plan' (total paid annually by Club and Employee) ","$"]
[null,"Typical Plan Premium percentage paid by Club for Employee Only Coverage","%"]
[null,"Typical Plan Premium percentage paid by Club for Family Coverage","%"]
[null,"Typical Plan Premium percentage paid by Club for Employee and Spouse Coverage","%"]
[null,"Employee Out of Pocket Schedule for In-Network"]
[null,"Annual Maximum Deductible for an 'Individual' Plan","$"]
[null,"Annual Maximum Deductible for a 'Family' Plan","$"]
[null,"Do you reimburse any of the employee’s deductible?",null,"Click to Select",null,"Click to Select",null,"Click to Select"]
[null,"Annual Maximum Out of Pocket for an 'Individual' Plan","$"]
[null,"Annual Maximum Out of Pocket for a 'Family' Plan","$"]
[null,"Employee Copay for a Doctor Visit","$"]
[null,"Employee Copay for a Generic Prescription","$"]
[null,"Employee Copay for an Emergency Room Visit","$"]
[null,"Employee Copay for a Hospital Visit","$"]
[null,"Employee Copay for Mail Order Prescription","$"]
[null,"Employee Coinsurance Percentage for Hospital Visit","%"]

{"sheet":"Benefits Upload","index":7,"n_rows":128,"n_cols":15,"rows_kept":128,"cut":false,"hidden":true,"merged":[]}
["Company Name"," ",{"$f":"'1| Select Titles'!D4:D4","v":0}]
["CompanyID"," ",null,null,"Dental;",false,{"$f":"COUNTIF(F$2, TRUE)","v":0},null,"Shifting more of burden to employee",false,{"$f":"COUNTIF(J$2, TRUE)","v":0}]
[null,null,null,null,"Vision Care;",false,{"$f":"COUNTIF(F$2:F3, TRUE)","v":0},null,"Making plan better for Employee as a way to attract and retain",false,{"$f":"COUNTIF(J$2:J3, TRUE)","v":0}]
["Health Insurance Plans","Plan Summary"," ",null,"Health Savings Account;",false,{"$f":"COUNTIF(F$2:F4, TRUE)","v":0},null,"Moving employees to healthcare exchanges and paying penalties",false,{"$f":"COUNTIF(J$2:J4, TRUE)","v":0}]
[1381,"Total Number of Full Time Equivalents per Affordable Care Act Definition",{"$f":"IF('5a| Health Plan Summary'!C4=\"\",\"\",'5a| Health Plan Summary'!C4)","v":""},null,"Long Term Care;",false,{"$f":"COUNTIF(F$2:F5, TRUE)","v":0},null,"No change in current strategy",false,{"$f":"COUNTIF(J$2:J5, TRUE)","v":0}]
[1382,"Total Number of Employees Electing Club's Plan",{"$f":"IF('5a| Health Plan Summary'!C5=\"\",\"\",'5a| Health Plan Summary'!C5)","v":""},null,"Cafeteria Plan",false,{"$f":"COUNTIF(F$2:F6, TRUE)","v":0}]
[616,"Which of the following are included in the healthcare plan?",{"$f":"CONCATENATE(F8,F9,F10,F11,F12)","v":""},null,null,null,null,null,null,{"$f":"IFERROR(INDEX(I2:I5,MATCH(K7,K2:K5,)),\"\")","v":""},1]
[1422,"Does your club contribute to the Employee’s Health Savings Account?",{"$f":"_xlfn.IFS('5a| Health Plan Summary'!C13=\"Click to Select\",\"\",'5a| Health Plan Summary'!C13=\"N/A\",\"\",'5a| Health Plan Summary'!C13=\"Yes\",\"Yes\",'5a| Health Plan Summary'!C13=\"No\",\"No\")","v":""},null,null,{"$f":"IFERROR(INDEX($E$2:$E$6,MATCH(G8,$G$2:$G$6,)),\"\")","v":""},1]
[1423,"If Yes  how much does the club contribute?",{"$f":"IF('5a| Health Plan Summary'!C14=\"\",\"\",'5a| Health Plan Summary'!C14)","v":""},null,null,{"$f":"IFERROR(INDEX($E$2:$E$6,MATCH(G9,$G$2:$G$6,)),\"\")","v":""},2]
[174,"Club’s Total Healthcare Insurance Expense",{"$f":"IF('5a| Health Plan Summary'!C15=\"\",\"\",'5a| Health Plan Summary'!C15)","v":""},null,null,"",3]
[1384,"Which best describes your club’s approach to managing health care insurance expenses",{"$f":"J7","v":""},null,null,"",4]
[null,null,null,null,null,"",5]
["Health Insurance Plans","Traditional HMO"," "]
[619,"Total Annual Premium for an 'Individual Plan'",{"$f":"IF('5b| Health Plan Details'!D4=\"\",\"\",'5b| Health Plan Details'!D4)","v":""}]
[622,"Total Annual Premium for a 'Family Plan'",{"$f":"IF('5b| Health Plan Details'!D5=\"\",\"\",'5b| Health Plan Details'!D5)","v":""}]
[620,"Typical Individual Plan Premium percentage paid by club",{"$f":"IF('5b| Health Plan Details'!D6=\"\",\"\",'5b| Health Plan Details'!D6)","v":""}]
[623,"Typical Family Plan Premium percentage paid by club for employee coverage",{"$f":"IF('5b| Health Plan Details'!D7=\"\",\"\",'5b| Health Plan Details'!D7)","v":""}]
[666,"Typical Family Plan Premium percentage paid by club for spouse/family coverage",{"$f":"IF('5b| Health Plan Details'!D8=\"\",\"\",'5b| Health Plan Details'!D8)","v":""}]
[625,"Annual Maximum Deductible for an 'Individual' Plan",{"$f":"IF('5b| Health Plan Details'!D10=\"\",\"\",'5b| Health Plan Details'!D10)","v":""}]
[626,"Annual Maximum Deductible for a 'Family' Plan",{"$f":"IF('5b| Health Plan Details'!D11=\"\",\"\",'5b| Health Plan Details'!D11)","v":""}]
[627,"Do you Reimburse any of the Employee’s Deductible?",{"$f":"IF('5b| Health Plan Details'!D12=\"Click to Select\",\"\",'5b| Health Plan Details'!D12)","v":""}]
[703,"Annual Maximum Out of Pocket for an 'Individual' Plan",{"$f":"IF('5b| Health Plan Details'!D13=\"\",\"\",'5b| Health Plan Details'!D13)","v":""}]
[704,"Annual Maximum Out of Pocket for a 'Family' Plan",{"$f":"IF('5b| Health Plan Details'!D14=\"\",\"\",'5b| Health Plan Details'!D14)","v":""}]
[628,"Employee Co-Pay for a Doctor Visit",{"$f":"IF('5b| Health Plan Details'!D15=\"\",\"\",'5b| Health Plan Details'!D15)","v":""}]
[629,"Employee Co-Pay for a Generic Prescription",{"$f":"IF('5b| Health Plan Details'!D16=\"\",\"\",'5b| Health Plan Details'!D16)","v":""}]
[630,"Employee Co-Pay for an Emergency Room Visit",{"$f":"IF('5b| Health Plan Details'!D17=\"\",\"\",'5b| Health Plan Details'!D17)","v":""}]
[631,"Employee Co-Pay for a Hospital Visit",{"$f":"IF('5b| Health Plan Details'!D18=\"\",\"\",'5b| Health Plan Details'!D18)","v":""}]
[1402,"Employee Co-Pay for Mail Order Prescription",{"$f":"IF('5b| Health Plan Details'!D19=\"\",\"\",'5b| Health Plan Details'!D19)","v":""}]
[705,"Employee Co-Insurance Percentage for Hospital Visit",{"$f":"IF('5b| Health Plan Details'!D20=\"\",\"\",'5b| Health Plan Details'!D20)","v":""}]
[]
["Health Insurance Plans","Traditional PPO"," "]
[1404,"Total Annual Premium for an 'Individual Plan'",{"$f":"IF('5b| Health Plan Details'!F4=\"\",\"\",'5b| Health Plan Details'!F4)","v":""}]
[1405,"Total Annual Premium for a 'Family Plan'",{"$f":"IF('5b| Health Plan Details'!F5=\"\",\"\",'5b| Health Plan Details'!F5)","v":""}]
[1406,"Typical Individual Plan Premium percentage paid by club",{"$f":"IF('5b| Health Plan Details'!F6=\"\",\"\",'5b| Health Plan Details'!F6)","v":""}]
[1407,"Typical Family Plan Premium percentage paid by club for employee coverage",{"$f":"IF('5b| Health Plan Details'!F7=\"\",\"\",'5b| Health Plan Details'!F7)","v":""}]
[1408,"Typical Family Plan Premium percentage paid by club for spouse/family coverage",{"$f":"IF('5b| Health Plan Details'!F8=\"\",\"\",'5b| Health Plan Details'!F8)","v":""}]
[1409,"Annual Maximum Deductible for an 'Individual' Plan",{"$f":"IF('5b| Health Plan Details'!F10=\"\",\"\",'5b| Health Plan Details'!F10)","v":""}]
[1410,"Annual Maximum Deductible for a 'Family' Plan",{"$f":"IF('5b| Health Plan Details'!F11=\"\",\"\",'5b| Health Plan Details'!F11)","v":""}]
[1415,"Do you Reimburse any of the Employee’s Deductible?",{"$f":"IF('5b| Health Plan Details'!F12=\"Click to Select\",\"\",'5b| Health Plan Details'!F12)","v":""}]
[1413,"Annual Maximum Out of Pocket for an 'Individual' Plan",{"$f":"IF('5b| Health Plan Details'!F13=\"\",\"\",'5b| Health Plan Details'!F13)","v":""}]
[1414,"Annual Maximum Out of Pocket for a 'Family' Plan",{"$f":"IF('5b| Health Plan Details'!F14=\"\",\"\",'5b| Health Plan Details'!F14)","v":""}]
[1416,"Employee Co-Pay for a Doctor Visit",{"$f":"IF('5b| Health Plan Details'!F15=\"\",\"\",'5b| Health Plan Details'!F15)","v":""}]
[1417,"Employee Co-Pay for a Generic Prescription",{"$f":"IF('5b| Health Plan Details'!F16=\"\",\"\",'5b| Health Plan Details'!F16)","v":""}]
[1418,"Employee Co-Pay for an Emergency Room Visit",{"$f":"IF('5b| Health Plan Details'!F17=\"\",\"\",'5b| Health Plan Details'!F17)","v":""}]
[1419,"Employee Co-Pay for a Hospital Visit",{"$f":"IF('5b| Health Plan Details'!F18=\"\",\"\",'5b| Health Plan Details'!F18)","v":""}]
[1420,"Employee Co-Pay for Mail Order Prescription",{"$f":"IF('5b| Health Plan Details'!F19=\"\",\"\",'5b| Health Plan Details'!F19)","v":""}]
[1421,"Employee Co-Insurance Percentage for Hospital Visit",{"$f":"IF('5b| Health Plan Details'!F20=\"\",\"\",'5b| Health Plan Details'!F20)","v":""}]
[]
["Health Insurance Plans","High Deductible Plan"," "]
[1426,"Total Annual Premium for an 'Individual Plan'",{"$f":"IF('5b| Health Plan Details'!H4=\"\",\"\",'5b| Health Plan Details'!H4)","v":""}]
[1427,"Total Annual Premium for a 'Family Plan'",{"$f":"IF('5b| Health Plan Details'!H5=\"\",\"\",'5b| Health Plan Details'!H5)","v":""}]
[1428,"Typical Individual Plan Premium percentage paid by club",{"$f":"IF('5b| Health Plan Details'!H6=\"\",\"\",'5b| Health Plan Details'!H6)","v":""}]
[1429,"Typical Family Plan Premium percentage paid by club for employee coverage",{"$f":"IF('5b| Health Plan Details'!H7=\"\",\"\",'5b| Health Plan Details'!H7)","v":""}]
[1430,"Typical Family Plan Premium percentage paid by club for spouse/family coverage",{"$f":"IF('5b| Health Plan Details'!H8=\"\",\"\",'5b| Health Plan Details'!H8)","v":""}]
[1431,"Annual Maximum Deductible for an 'Individual' Plan",{"$f":"IF('5b| Health Plan Details'!H10=\"\",\"\",'5b| Health Plan Details'!H10)","v":""}]
[1432,"Annual Maximum Deductible for a 'Family' Plan",{"$f":"IF('5b| Health Plan Details'!H11=\"\",\"\",'5b| Health Plan Details'!H11)","v":""}]
[1435,"Do you Reimburse any of the Employee’s Deductible?",{"$f":"IF('5b| Health Plan Details'!H12=\"Click to Select\",\"\",'5b| Health Plan Details'!H12)","v":""}]
[1433,"Annual Maximum Out of Pocket for an 'Individual' Plan",{"$f":"IF('5b| Health Plan Details'!H13=\"\",\"\",'5b| Health Plan Details'!H13)","v":""}]
[1434,"Annual Maximum Out of Pocket for a 'Family' Plan",{"$f":"IF('5b| Health Plan Details'!H14=\"\",\"\",'5b| Health Plan Details'!H14)","v":""}]
[1436,"Employee Co-Pay for a Doctor Visit",{"$f":"IF('5b| Health Plan Details'!H15=\"\",\"\",'5b| Health Plan Details'!H15)","v":""}]
[1437,"Employee Co-Pay for a Generic Prescription",{"$f":"IF('5b| Health Plan Details'!H16=\"\",\"\",'5b| Health Plan Details'!H16)","v":""}]
[1438,"Employee Co-Pay for an Emergency Room Visit",{"$f":"IF('5b| Health Plan Details'!H17=\"\",\"\",'5b| Health Plan Details'!H17)","v":""}]
[1439,"Employee Co-Pay for a Hospital Visit",{"$f":"IF('5b| Health Plan Details'!H18=\"\",\"\",'5b| Health Plan Details'!H18)","v":""}]
[1440,"Employee Co-Pay for Mail Order Prescription",{"$f":"IF('5b| Health Plan Details'!H19=\"\",\"\",'5b| Health Plan Details'!H19)","v":""}]
[1441,"Employee Co-Insurance Percentage for Hospital Visit",{"$f":"IF('5b| Health Plan Details'!H20=\"\",\"\",'5b| Health Plan Details'!H20)","v":""}]
[]
["Retirement Plans & Benefits","401K & Deferred Comp. Plans"," "]
[1393,"Do you offer a 401K retirement plan?",{"$f":"IF('4| Retirement & Other Benefits'!C4=\"Click to Select\",\"\",'4| Retirement & Other Benefits'!C4)","v":""}]
[1424,"After how many months are employees eligible to participate?",{"$f":"IF('4| Retirement & Other Benefits'!C5=\"Click to Select\",\"\",'4| Retirement & Other Benefits'!C5)","v":""}]
[1396,"What is the Maximum Matching Contribution by the Club?",{"$f":"IF('4| Retirement & Other Benefits'!C6=\"Click to Select\",\"\",'4| Retirement & Other Benefits'!C6)","v":""}]
[1397,"Is there a Vesting schedule on matching?",{"$f":"IF('4| Retirement & Other Benefits'!C7=\"Click to Select\",\"\",'4| Retirement & Other Benefits'!C7)","v":""}]
[1398,"If yes  what is the vesting period?",{"$f":"IF('4| Retirement & Other Benefits'!C8=\"Click to Select\",\"\",'4| Retirement & Other Benefits'!C8)","v":""}]
[1399,"Does the club make a Profit Sharing contribution?",{"$f":"IF('4| Retirement & Other Benefits'!C9=\"Click to Select\",\"\",'4| Retirement & Other Benefits'!C9)","v":""}]
[1400,"Do you offer a Deferred Compensation Plan?",{"$f":"IF('4| Retirement & Other Benefits'!C11=\"Click to Select\",\"\",'4| Retirement & Other Benefits'!C11)","v":""}]
[]
["Retirement Plans & Benefits","Performance Bonus Plans"," ",null,"General Manager;",false,{"$f":"COUNTIF(F$76, TRUE)","v":0},null,"Discretionary;",false,{"$f":"COUNTIF(J$76, TRUE)","v":0},null,"Discretionary;",false,{"$f":"COUNTIF(N$76, TRUE)","v":0}]
[1481,"Which employees are eligible for Performance Bonus",{"$f":"CONCATENATE(F81,F82,F83)","v":""},null,"Executive Staff;",false,{"$f":"COUNTIF(F$76:F77, TRUE)","v":0},null,"Specific Goals;",false,{"$f":"COUNTIF(J$76:J77, TRUE)","v":0},null,"Specific Goals;",false,{"$f":"COUNTIF(N$76:N77, TRUE)","v":0}]
[1482,"General Manager",{"$f":"IF('4| Retirement & Other Benefits'!C19=\"Click to Select\",\"\",'4| Retirement & Other Benefits'!C19)","v":""},null,"Salaried Staff;",false,{"$f":"COUNTIF(F$76:F78, TRUE)","v":0},null,"Clubwide Quantitative Metrics;",false,{"$f":"COUNTIF(J$76:J78, TRUE)","v":0},null,"Clubwide Quantitative Metrics;",false,{"$f":"COUNTIF(N$76:N78, TRUE)","v":0}]
[1483,"Executive Staff",{"$f":"IF('4| Retirement & Other Benefits'!C20=\"Click to Select\",\"\",'4| Retirement & Other Benefits'!C20)","v":""},null,"No employee receives performance bonus",false,{"$f":"COUNTIF(F$76:F79, TRUE)","v":0},null,"Clubwide Qualitative Metrics;",false,{"$f":"COUNTIF(J$76:J79, TRUE)","v":0},null,"Clubwide Qualitative Metrics;",false,{"$f":"COUNTIF(N$76:N79, TRUE)","v":0}]
[1484,"Salaried Staff",{"$f":"IF('4| Retirement & Other Benefits'!C21=\"Click to Select\",\"\",'4| Retirement & Other Benefits'!C21)","v":""},null,null,null,null,null,"Department Quantitative Metrics;",false,{"$f":"COUNTIF(J$76:J80, TRUE)","v":0},null,"Department Quantitative Metrics;",false,{"$f":"COUNTIF(N$76:N80, TRUE)","v":0}]
[1485,"What criteria are used to determine General Manager bonus?",{"$f":"CONCATENATE(I83,I84,I85,I86,I87,I88)","v":""},null,null,{"$f":"IFERROR(INDEX($E$76:$E$79,MATCH(G81,$G$76:$G$79,)),\"\")","v":""},1,null,"Department Qualitative Metrics;",false,{"$f":"COUNTIF(J$76:J81, TRUE)","v":0},null,"Department Qualitative Metrics",false,{"$f":"COUNTIF(N$76:N81, TRUE)","v":0}]
[1486,"What criteria are used to determine staff and department head bonus?",{"$f":"CONCATENATE(M83,M84,M85,M86,M87,M88)","v":""},null,null,{"$f":"IFERROR(INDEX($E$76:$E$79,MATCH(G82,$G$76:$G$79,)),\"\")","v":""},2]
[null,null,null,null,null,"",3,null,{"$f":"IFERROR(INDEX($I$76:$I$81,MATCH(K83,$K$76:$K$81,)),\"\")","v":""},null,1,null,{"$f":"IFERROR(INDEX($M$76:$M$81,MATCH(O83,$O$76:$O$81,)),\"\")","v":""},null,1]
["Retirement Plans & Benefits","Other Benefits"," ",null,null,null,null,null,{"$f":"IFERROR(INDEX($I$76:$I$81,MATCH(K84,$K$76:$K$81,)),\"\")","v":""},null,2,null,{"$f":"IFERROR(INDEX($M$76:$M$81,MATCH(O84,$O$76:$O$81,)),\"\")","v":""},null,2]
[615,"Do your benefits include?",{"$f":"CONCATENATE(F88,F89)","v":""},null,"Disability Insurance;",false,{"$f":"COUNTIF(F$85, TRUE)","v":0},null,"",null,3,null,"",null,3]
[1388,"Maximum days of vacation after one year full time employment",{"$f":"IF('4| Retirement & Other Benefits'!C41=0,\"\",'4| Retirement & Other Benefits'!C41)","v":""},null,"Life Insurance",false,{"$f":"COUNTIF(F$85:F86, TRUE)","v":0},null,"",null,4,null,"",null,4]
[1389,"Maximum days of vacation full time employee can earn in given year",{"$f":"IF('4| Retirement & Other Benefits'!C42=0,\"\",'4| Retirement & Other Benefits'!C42)","v":""},null,null,null,null,null,"",null,5,null,"",null,5]
[1390,"Years of full time employment required for maximum vacation days",{"$f":"IF('4| Retirement & Other Benefits'!C43=0,\"\",'4| Retirement & Other Benefits'!C43)","v":""},null,null,{"$f":"IFERROR(INDEX($E$85:$E$86,MATCH(G88,$G$85:$G$86,)),\"\")","v":""},1,null,"",null,6,null,"",null,6]
[1391,"Who is eligible for sick days?",{"$f":"CONCATENATE(I95,I96,I97)","v":""},null,null,{"$f":"IFERROR(INDEX($E$85:$E$86,MATCH(G89,$G$85:$G$86,)),\"\")","v":""},2]
[1392,"What is the maximum number of annual sick days allowed for an employee?",{"$f":"IF('4| Retirement & Other Benefits'!C49=0,\"\",'4| Retirement & Other Benefits'!C49)","v":""},null,null,null,null,null,"Full time employees;",false,{"$f":"COUNTIF(J$90, TRUE)","v":0}]
[null,null,null,null,null,null,null,null,"Part time employees;",false,{"$f":"COUNTIF(J$90:J91, TRUE)","v":0}]
["Club Profile","Profile Information"," ",null,null,null,null,null,"Seasonal employees;",null,{"$f":"COUNTIF(J$90:J92, TRUE)","v":0}]
[1660,"Fiscal Year Ending Month",{"$f":"'1| Select Titles'!D5","v":0},null,null,null,null,null,"No employees;",false,{"$f":"COUNTIF(J$90:J93, TRUE)","v":0}]
[1853,"When do your club's annual compensation reviews happen?",{"$f":"IF('1| Select Titles'!E8=\"Click to Select\",\"\",'1| Select Titles'!E8)","v":""}]
[1854,"When do the club's annual pay raises go into effect?",{"$f":"IF('1| Select Titles'!E9=\"Click to Select\",\"\",'1| Select Titles'!E9)","v":""},null,null,null,null,null,{"$f":"IFERROR(INDEX($I$90:$I$93,MATCH(K95,$K$90:$K$93,)),\"\")","v":""},null,1]
[1860,"How frequent are the club's pay periods?",{"$f":"IF('1| Select Titles'!E7=\"Click to Select\",\"\",'1| Select Titles'!E7)","v":""},null,null,null,null,null,{"$f":"IFERROR(INDEX($I$90:$I$93,MATCH(K96,$K$90:$K$93,)),\"\")","v":""},null,2]
[null,null,null,null,null,null,null,null,"",null,3]
[516,"Total FTE Count Across All Departments",{"$f":"'2| FTE Counts'!C8","v":0}]
[439,"Peak Employees Count Across All Departments",{"$f":"'2| FTE Counts'!C9","v":0}]
[1381,"Total FTE Count per Affordable Care Act Definition",{"$f":"'2| FTE Counts'!C10","v":0}]
[438,"FTE Count General & Adminitrative Department",{"$f":"'2| FTE Counts'!D13","v":""}]
[1127,"FTE Count Security Staff",{"$f":"'2| FTE Counts'!D14","v":""}]
[1863,"FTE Count Clubhouse - Support Staff",{"$f":"'2| FTE Counts'!D15","v":""}]
[369,"FTE Count Clubhouse Staff - Guest Rooms",{"$f":"'2| FTE Counts'!D16","v":""}]
[1121,"FTEs Across All HOA/POA Departments",{"$f":"'2| FTE Counts'!D17","v":""}]
[327,"FTE Count Food & Beverage Front and Back of House",{"$f":"'2| FTE Counts'!D18","v":""}]
[1116,"FTE Count Community Grounds and Road Maintenance",{"$f":"'2| FTE Counts'!D19","v":""}]
[474,"FTE Count Tennis/Racquets Department",{"$f":"'2| FTE Counts'!D20","v":""}]
[476,"FTE Count Fitness Department",{"$f":"'2| FTE Counts'!D21","v":""}]
[477,"FTE Count Aquatics Department",{"$f":"'2| FTE Counts'!D22","v":""}]
[2132,"FTE Count Yacht/Waterfront Department",{"$f":"'2| FTE Counts'!D23","v":""}]
[]
[null,null,"Head of Club; "]
[null,null,"General Manager",false,{"$f":"COUNTIF(D$114, TRUE)","v":0}]
[null,null,"COO",false,{"$f":"COUNTIF(D$114:D115, TRUE)","v":0}]
[null,null,"CEO",false,{"$f":"COUNTIF(D$114:D116, TRUE)","v":0}]
[null,null,"Head of Finance; ",null,{"$f":"COUNTIF(D$114:D117, TRUE)","v":0}]
[null,null,"Controller",false,{"$f":"COUNTIF(D$114:D118, TRUE)","v":0}]
[null,null,"CFO",true,{"$f":"COUNTIF(D$114:D119, TRUE)","v":1}]
[null,null,"Head of Golf; ",null,{"$f":"COUNTIF(D$114:D120, TRUE)","v":1}]
[null,null,"Director of Golf",true,{"$f":"COUNTIF(D$114:D121, TRUE)","v":2}]
[null,null,"Head Golf Professional",true,{"$f":"COUNTIF(D$114:D122, TRUE)","v":3}]
[null,null,"Director of Agronomy/Supt; ",null,{"$f":"COUNTIF(D$114:D123, TRUE)","v":3}]
[null,null,"Head Superintendent",false,{"$f":"COUNTIF(D$114:D124, TRUE)","v":3}]
[null,null,"Superintendent",true,{"$f":"COUNTIF(D$114:D125, TRUE)","v":4}]
[null,null,"Head of Tennis/Racquets ",null,{"$f":"COUNTIF(D$114:D126, TRUE)","v":4}]
[null,null,"Director of Tennis",true,{"$f":"COUNTIF(D$114:D127, TRUE)","v":5}]
[null,null,"Head Tennis Professional",true,{"$f":"COUNTIF(D$114:D128, TRUE)","v":6}]

{"sheet":"Comp Upload","index":8,"n_rows":13,"n_cols":51,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Club ID","Employee Number","Year of Data","Month Received (0-12)","Platform: Instance ID","Club Name","Club Department Name - 1923","Position Title # - 1924","Platform: Position ID - 1900","Club Position Title - 1925","Birthdate","Hire Date","Termination Date","Employment Status # - 1926","Club Employment Status -1927","Platform: Employee Status # - 1922","Pay Basis (Hourly/Salary) - 1928","Platform: Pay Basis # - 1921","FLSA Status (Exempt/Non-exempt) - 1929","Platform FLSA Status - 1920","Gross Pay - 1930","Original Pay Rate - 1931","Adjusted Salary Rate - 1901","Adjusted Hourly Rate - 1902","Total Hours Worked - 1934","Overtime Hours Worked - 1933","Gratuities - 1904","Lessons Income - 1932","Commissions - 1935","SumLessonCommission - 1903"," Effective Rate (Salary) - 1905","Effective Rate (Hourly) - 1906","Performance & Discretionary Bonuses Paid - 1907","Holiday Bonus - 1909","Performance Bonus Target - 1908","Housing Allowance - 1914","Auto Allowance - 1910","Education Allowance - 1913","Clothing Allowance - 1911","Competitive Dining Allowance - 1912","Other Allowance - 1915","Club Privileges - 1936","Club Contribution to 457 (f) - 1916","Club Contribution to 457 (b) - 1917","401K - 1937","403B - 1938","Life Insurance Value - 1918","Short Term Disability - 1939","Long Term Disability - 1940","Total Compensation - 1919","Date Received"]
[{"$f":"'Benefits Upload'!$C$2","v":0},{"$f":"CONCATENATE(A2,\"|\",\"01\")","v":"0|01"},2024,0,null,{"$f":"'1| Select Titles'!$D$4","v":0},"Executive Team",74,null,"Head of Club",{"$f":"CONCATENATE(\"01/01/\",(2024-'3| Compensation'!E22))","v":"01/01/2024"},{"$f":"CONCATENATE(\"01/01/\",(2024-'3| Compensation'!E23))","v":"01/01/2024"},null,3,"YRFT",null,"Salary",null,"Exempt",null,null,{"$f":"'3| Compensation'!E4","v":0},{"$f":"V2","v":0},{"$f":"V2/2080","v":0},2080,null,null,{"$f":"'3| Compensation'!E5","v":0},{"$f":"'3| Compensation'!E6","v":0},{"$f":"SUM(AB2,AC2)","v":0},null,null,{"$f":"'3| Compensation'!E7","v":0},{"$f":"'3| Compensation'!E8","v":0},{"$f":"'3| Compensation'!E9","v":0},{"$f":"'3| Compensation'!E11","v":0},{"$f":"'3| Compensation'!E10","v":0},{"$f":"'3| Compensation'!E13","v":0},{"$f":"'3| Compensation'!E12","v":0},{"$f":"'3| Compensation'!E14","v":0},{"$f":"'3| Compensation'!E15","v":0},{"$f":"'3| Compensation'!E18","v":"Click to Select"},{"$f":"'3| Compensation'!E17","v":0},{"$f":"'3| Compensation'!E16","v":0},null,null,{"$f":"'3| Compensation'!E21","v":0},{"$f":"'3| Compensation'!E19","v":"Click to Select"},{"$f":"'3| Compensation'!E20","v":"Click to Select"},null,{"$f":"TODAY()","v":45756}]
[{"$f":"'Benefits Upload'!$C$2","v":0},{"$f":"CONCATENATE(A3,\"|\",\"04\")","v":"0|04"},2024,0,null,{"$f":"'1| Select Titles'!$D$4","v":0},"Executive Team",75,null,"Head of Finance",{"$f":"CONCATENATE(\"01/01/\",(2024-'3| Compensation'!G22))","v":"01/01/2024"},{"$f":"CONCATENATE(\"01/01/\",(2024-'3| Compensation'!G23))","v":"01/01/2024"},null,3,"YRFT",null,"Salary",null,"Exempt",null,null,{"$f":"'3| Compensation'!G4","v":0},{"$f":"V3","v":0},{"$f":"V3/2080","v":0},2080,null,null,{"$f":"'3| Compensation'!G5","v":0},{"$f":"'3| Compensation'!G6","v":0},{"$f":"SUM(AB3,AC3)","v":0},null,null,{"$f":"'3| Compensation'!G7","v":0},{"$f":"'3| Compensation'!G8","v":0},{"$f":"'3| Compensation'!G9","v":0},{"$f":"'3| Compensation'!G11","v":0},{"$f":"'3| Compensation'!G10","v":0},{"$f":"'3| Compensation'!G13","v":0},{"$f":"'3| Compensation'!G12","v":0},{"$f":"'3| Compensation'!G14","v":0},{"$f":"'3| Compensation'!G15","v":0},{"$f":"'3| Compensation'!G18","v":"Click to Select"},{"$f":"'3| Compensation'!G17","v":0},{"$f":"'3| Compensation'!G16","v":0},null,null,{"$f":"'3| Compensation'!G21","v":0},{"$f":"'3| Compensation'!G19","v":"Click to Select"},{"$f":"'3| Compensation'!G20","v":"Click to Select"},null,{"$f":"TODAY()","v":45756}]
[{"$f":"'Benefits Upload'!$C$2","v":0},{"$f":"CONCATENATE(A4,\"|\",\"05\")","v":"0|05"},2024,0,null,{"$f":"'1| Select Titles'!$D$4","v":0},"Executive Team",63,null,"Food & Beverage Director",{"$f":"CONCATENATE(\"01/01/\",(2024-'3| Compensation'!K22))","v":"01/01/2024"},{"$f":"CONCATENATE(\"01/01/\",(2024-'3| Compensation'!K23))","v":"01/01/2024"},null,3,"YRFT",null,"Salary",null,"Exempt",null,null,{"$f":"'3| Compensation'!K4","v":0},0,0,2080,null,null,{"$f":"'3| Compensation'!K5","v":0},{"$f":"'3| Compensation'!K6","v":0},0,null,null,{"$f":"'3| Compensation'!K7","v":0},{"$f":"'3| Compensation'!K8","v":0},{"$f":"'3| Compensation'!K9","v":0},{"$f":"'3| Compensation'!K11","v":0},{"$f":"'3| Compensation'!K10","v":0},{"$f":"'3| Compensation'!K13","v":0},{"$f":"'3| Compensation'!K12","v":0},{"$f":"'3| Compensation'!K14","v":0},{"$f":"'3| Compensation'!K15","v":0},{"$f":"'3| Compensation'!K18","v":"Click to Select"},{"$f":"'3| Compensation'!K17","v":0},{"$f":"'3| Compensation'!K16","v":0},null,null,{"$f":"'3| Compensation'!K21","v":0},{"$f":"'3| Compensation'!K19","v":"Click to Select"},{"$f":"'3| Compensation'!K20","v":"Click to Select"},null,45756]
[{"$f":"'Benefits Upload'!$C$2","v":0},{"$f":"CONCATENATE(A5,\"|\",\"06\")","v":"0|06"},2024,0,null,{"$f":"'1| Select Titles'!$D$4","v":0},"Executive Team",33,null,"Executive Chef",{"$f":"CONCATENATE(\"01/01/\",(2024-'3| Compensation'!I22))","v":"01/01/2024"},{"$f":"CONCATENATE(\"01/01/\",(2024-'3| Compensation'!I23))","v":"01/01/2024"},null,3,"YRFT",null,"Salary",null,"Exempt",null,null,{"$f":"'3| Compensation'!I$4","v":0},0,0,2080,null,null,{"$f":"'3| Compensation'!I$5","v":0},{"$f":"'3| Compensation'!I$6","v":0},0,null,null,{"$f":"'3| Compensation'!I$7","v":0},{"$f":"'3| Compensation'!I$8","v":0},{"$f":"'3| Compensation'!I$9","v":0},{"$f":"'3| Compensation'!I$11","v":0},{"$f":"'3| Compensation'!I$10","v":0},{"$f":"'3| Compensation'!I$13","v":0},{"$f":"'3| Compensation'!I$12","v":0},{"$f":"'3| Compensation'!I$14","v":0},{"$f":"'3| Compensation'!I$15","v":0},{"$f":"'3| Compensation'!I$18","v":"Click to Select"},{"$f":"'3| Compensation'!I$17","v":0},{"$f":"'3| Compensation'!I$16","v":0},null,null,{"$f":"'3| Compensation'!I$21","v":0},{"$f":"'3| Compensation'!I$19","v":"Click to Select"},{"$f":"'3| Compensation'!I$20","v":"Click to Select"},null,45756]
[{"$f":"'Benefits Upload'!$C$2","v":0},{"$f":"CONCATENATE(A6,\"|\",\"07\")","v":"0|07"},2024,0,null,{"$f":"'1| Select Titles'!$D$4","v":0},"Executive Team",70,null,"Assistant General Manager",{"$f":"CONCATENATE(\"01/01/\",(2024-'3| Compensation'!M22))","v":"01/01/2024"},{"$f":"CONCATENATE(\"01/01/\",(2024-'3| Compensation'!M23))","v":"01/01/2024"},null,3,"YRFT",null,"Salary",null,"Exempt",null,null,{"$f":"'3| Compensation'!M$4","v":0},{"$f":"V6","v":0},{"$f":"V6/2080","v":0},2080,null,null,{"$f":"'3| Compensation'!M$5","v":0},{"$f":"'3| Compensation'!M$6","v":0},0,null,null,{"$f":"'3| Compensation'!M$7","v":0},{"$f":"'3| Compensation'!M$8","v":0},{"$f":"'3| Compensation'!M$9","v":0},{"$f":"'3| Compensation'!M$11","v":0},{"$f":"'3| Compensation'!M$10","v":0},{"$f":"'3| Compensation'!M$13","v":0},{"$f":"'3| Compensation'!M$12","v":0},{"$f":"'3| Compensation'!M$14","v":0},{"$f":"'3| Compensation'!M$15","v":0},{"$f":"'3| Compensation'!M$18","v":"Click to Select"},{"$f":"'3| Compensation'!M$17","v":0},{"$f":"'3| Compensation'!M$16","v":0},null,null,{"$f":"'3| Compensation'!M$21","v":0},{"$f":"'3| Compensation'!M$19","v":"Click to Select"},{"$f":"'3| Compensation'!M$20","v":"Click to Select"},null,45756]
[{"$f":"'Benefits Upload'!$C$2","v":0},{"$f":"CONCATENATE(A7,\"|\",\"08\")","v":"0|08"},2024,0,null,{"$f":"'1| Select Titles'!$D$4","v":0},"Executive Team",126,null,"Fitness Director",{"$f":"CONCATENATE(\"01/01/\",(2024-'3| Compensation'!O22))","v":"01/01/2024"},{"$f":"CONCATENATE(\"01/01/\",(2024-'3| Compensation'!O23))","v":"01/01/2024"},null,3,"YRFT",null,"Salary",null,"Exempt",null,null,{"$f":"'3| Compensation'!O$4","v":0},0,0,2080,null,null,{"$f":"'3| Compensation'!O$5","v":0},{"$f":"'3| Compensation'!O$6","v":0},0,null,null,{"$f":"'3| Compensation'!O$7","v":0},{"$f":"'3| Compensation'!O$8","v":0},{"$f":"'3| Compensation'!O$9","v":0},{"$f":"'3| Compensation'!O$11","v":0},{"$f":"'3| Compensation'!O$10","v":0},{"$f":"'3| Compensation'!O$13","v":0},{"$f":"'3| Compensation'!O$12","v":0},{"$f":"'3| Compensation'!O$14","v":0},{"$f":"'3| Compensation'!O$15","v":0},{"$f":"'3| Compensation'!O$18","v":"Click to Select"},{"$f":"'3| Compensation'!O$17","v":0},{"$f":"'3| Compensation'!O$16","v":0},null,null,{"$f":"'3| Compensation'!O$21","v":0},{"$f":"'3| Compensation'!O$19","v":"Click to Select"},{"$f":"'3| Compensation'!O$20","v":"Click to Select"},null,45756]
[{"$f":"'Benefits Upload'!$C$2","v":0},{"$f":"CONCATENATE(A8,\"|\",\"09\")","v":"0|09"},2024,0,null,{"$f":"'1| Select Titles'!$D$4","v":0},"Executive Team",11,null,"Head of Facilities",{"$f":"CONCATENATE(\"01/01/\",(2024-'3| Compensation'!Q22))","v":"01/01/2024"},{"$f":"CONCATENATE(\"01/01/\",(2024-'3| Compensation'!Q23))","v":"01/01/2024"},null,3,"YRFT",null,"Salary",null,"Exempt",null,null,{"$f":"'3| Compensation'!Q$4","v":0},0,0,2080,null,null,{"$f":"'3| Compensation'!Q$5","v":0},{"$f":"'3| Compensation'!Q$6","v":0},0,null,null,{"$f":"'3| Compensation'!Q$7","v":0},{"$f":"'3| Compensation'!Q$8","v":0},{"$f":"'3| Compensation'!Q$9","v":0},{"$f":"'3| Compensation'!Q$11","v":0},{"$f":"'3| Compensation'!Q$10","v":0},{"$f":"'3| Compensation'!Q$13","v":0},{"$f":"'3| Compensation'!Q$12","v":0},{"$f":"'3| Compensation'!Q$14","v":0},{"$f":"'3| Compensation'!Q$15","v":0},{"$f":"'3| Compensation'!Q$18","v":"Click to Select"},{"$f":"'3| Compensation'!Q$17","v":0},{"$f":"'3| Compensation'!Q$16","v":0},null,null,{"$f":"'3| Compensation'!Q$21","v":0},{"$f":"'3| Compensation'!Q$19","v":"Click to Select"},{"$f":"'3| Compensation'!Q$20","v":"Click to Select"},null,45756]
[{"$f":"'Benefits Upload'!$C$2","v":0},{"$f":"CONCATENATE(A9,\"|\",\"10\")","v":"0|10"},2024,0,null,{"$f":"'1| Select Titles'!$D$4","v":0},"Executive Team",59,null,"Events & Catering Director",{"$f":"CONCATENATE(\"01/01/\",(2024-'3| Compensation'!S22))","v":"01/01/2024"},{"$f":"CONCATENATE(\"01/01/\",(2024-'3| Compensation'!S23))","v":"01/01/2024"},null,3,"YRFT",null,"Salary",null,"Exempt",null,null,{"$f":"'3| Compensation'!S$4","v":0},0,0,2080,null,null,{"$f":"'3| Compensation'!S$5","v":0},{"$f":"'3| Compensation'!S$6","v":0},0,null,null,{"$f":"'3| Compensation'!S$7","v":0},{"$f":"'3| Compensation'!S$8","v":0},{"$f":"'3| Compensation'!S$9","v":0},{"$f":"'3| Compensation'!S$11","v":0},{"$f":"'3| Compensation'!S$10","v":0},{"$f":"'3| Compensation'!S$13","v":0},{"$f":"'3| Compensation'!S$12","v":0},{"$f":"'3| Compensation'!S$14","v":0},{"$f":"'3| Compensation'!S$15","v":0},{"$f":"'3| Compensation'!S$18","v":"Click to Select"},{"$f":"'3| Compensation'!S$17","v":0},{"$f":"'3| Compensation'!S$16","v":0},null,null,{"$f":"'3| Compensation'!S$21","v":0},{"$f":"'3| Compensation'!S$19","v":"Click to Select"},{"$f":"'3| Compensation'!S$20","v":"Click to Select"},null,45756]
[{"$f":"'Benefits Upload'!$C$2","v":0},{"$f":"CONCATENATE(A10,\"|\",\"11\")","v":"0|11"},2024,0,null,{"$f":"'1| Select Titles'!$D$4","v":0},"Executive Team",78,null,"Head of Human Resources",{"$f":"CONCATENATE(\"01/01/\",(2024-'3| Compensation'!U22))","v":"01/01/2024"},{"$f":"CONCATENATE(\"01/01/\",(2024-'3| Compensation'!U23))","v":"01/01/2024"},null,3,"YRFT",null,"Salary",null,"Exempt",null,null,{"$f":"'3| Compensation'!U$4","v":0},{"$f":"V$10","v":0},0,2080,null,null,{"$f":"'3| Compensation'!U$5","v":0},{"$f":"'3| Compensation'!U$6","v":0},0,null,null,{"$f":"'3| Compensation'!U$7","v":0},{"$f":"'3| Compensation'!U$8","v":0},{"$f":"'3| Compensation'!U$9","v":0},{"$f":"'3| Compensation'!U$11","v":0},{"$f":"'3| Compensation'!U$10","v":0},{"$f":"'3| Compensation'!U$13","v":0},{"$f":"'3| Compensation'!U$12","v":0},{"$f":"'3| Compensation'!U$14","v":0},{"$f":"'3| Compensation'!U$15","v":0},{"$f":"'3| Compensation'!U$18","v":"Click to Select"},{"$f":"'3| Compensation'!U$17","v":0},{"$f":"'3| Compensation'!U$16","v":0},null,null,{"$f":"'3| Compensation'!U$21","v":0},{"$f":"'3| Compensation'!U$19","v":"Click to Select"},{"$f":"'3| Compensation'!U$20","v":"Click to Select"},null,45756]
[{"$f":"'Benefits Upload'!$C$2","v":0},{"$f":"CONCATENATE(A11,\"|\",\"12\")","v":"0|12"},2024,0,null,{"$f":"'1| Select Titles'!$D$4","v":0},"Executive Team",84,null,"Membership Director",{"$f":"CONCATENATE(\"01/01/\",(2024-'3| Compensation'!W22))","v":"01/01/2024"},{"$f":"CONCATENATE(\"01/01/\",(2024-'3| Compensation'!W23))","v":"01/01/2024"},null,3,"YRFT",null,"Salary",null,"Exempt",null,null,{"$f":"'3| Compensation'!W$4","v":0},{"$f":"V$11","v":0},{"$f":"V11/2080","v":0},2080,null,null,{"$f":"'3| Compensation'!W$5","v":0},{"$f":"'3| Compensation'!W$6","v":0},{"$f":"SUM(AB11,AC11)","v":0},null,null,{"$f":"'3| Compensation'!W$7","v":0},{"$f":"'3| Compensation'!W$8","v":0},{"$f":"'3| Compensation'!W$9","v":0},{"$f":"'3| Compensation'!W$11","v":0},{"$f":"'3| Compensation'!W$10","v":0},{"$f":"'3| Compensation'!W$13","v":0},{"$f":"'3| Compensation'!W$12","v":0},{"$f":"'3| Compensation'!W$14","v":0},{"$f":"'3| Compensation'!W$15","v":0},{"$f":"'3| Compensation'!W$18","v":"Click to Select"},{"$f":"'3| Compensation'!W$17","v":0},{"$f":"'3| Compensation'!W$16","v":0},null,null,{"$f":"'3| Compensation'!W$21","v":0},{"$f":"'3| Compensation'!W$19","v":"Click to Select"},{"$f":"'3| Compensation'!W$20","v":"Click to Select"},null,45756]
[{"$f":"'Benefits Upload'!$C$2","v":0},{"$f":"CONCATENATE(A12,\"|\",\"13\")","v":"0|13"},2024,0,null,{"$f":"'1| Select Titles'!$D$4","v":0},"Executive Team",140,null,"Head of Tennis/Racquets",{"$f":"CONCATENATE(\"01/01/\",(2024-'3| Compensation'!Y22))","v":"01/01/2024"},{"$f":"CONCATENATE(\"01/01/\",(2024-'3| Compensation'!Y23))","v":"01/01/2024"},null,3,"YRFT",null,"Salary",null,"Exempt",null,null,{"$f":"'3| Compensation'!Y4","v":0},{"$f":"V$12","v":0},{"$f":"V12/2080","v":0},2080,null,null,{"$f":"'3| Compensation'!Y$5","v":0},{"$f":"'3| Compensation'!Y$6","v":0},{"$f":"SUM(AB12,AC12)","v":0},null,null,{"$f":"'3| Compensation'!Y$7","v":0},{"$f":"'3| Compensation'!Y$8","v":0},{"$f":"'3| Compensation'!Y$9","v":0},{"$f":"'3| Compensation'!Y$11","v":0},{"$f":"'3| Compensation'!Y$10","v":0},{"$f":"'3| Compensation'!Y$13","v":0},{"$f":"'3| Compensation'!Y$12","v":0},{"$f":"'3| Compensation'!Y$14","v":0},{"$f":"'3| Compensation'!Y$15","v":0},{"$f":"'3| Compensation'!Y$18","v":"Click to Select"},{"$f":"'3| Compensation'!Y$17","v":0},{"$f":"'3| Compensation'!Y$16","v":0},null,null,{"$f":"'3| Compensation'!Y$21","v":0},{"$f":"'3| Compensation'!Y$19","v":"Click to Select"},{"$f":"'3| Compensation'!Y$20","v":"Click to Select"},null,45756]
[{"$f":"'Benefits Upload'!$C$2","v":0},{"$f":"CONCATENATE(A13,\"|\",\"14\")","v":"0|14"},2024,0,null,{"$f":"'1| Select Titles'!$D$4","v":0},"Executive Team",71,null,"Clubhouse Manager",{"$f":"CONCATENATE(\"01/01/\",(2024-'3| Compensation'!AA22))","v":"01/01/2024"},{"$f":"CONCATENATE(\"01/01/\",(2024-'3| Compensation'!AA23))","v":"01/01/2024"},null,3,"YRFT",null,"Salary",null,"Exempt",null,null,{"$f":"'3| Compensation'!AA4","v":0},{"$f":"V$13","v":0},{"$f":"V13/2080","v":0},2080,null,null,{"$f":"'3| Compensation'!AA$5","v":0},{"$f":"'3| Compensation'!AA$6","v":0},0,null,null,{"$f":"'3| Compensation'!AA$7","v":0},{"$f":"'3| Compensation'!AA$8","v":0},{"$f":"'3| Compensation'!AA$9","v":0},{"$f":"'3| Compensation'!AA$11","v":0},{"$f":"'3| Compensation'!AA$10","v":0},{"$f":"'3| Compensation'!AA$13","v":0},{"$f":"'3| Compensation'!AA$12","v":0},{"$f":"'3| Compensation'!AA$14","v":0},{"$f":"'3| Compensation'!AA$15","v":0},{"$f":"'3| Compensation'!AA$18","v":"Click to Select"},{"$f":"'3| Compensation'!AA$17","v":0},{"$f":"'3| Compensation'!AA$16","v":0},null,null,{"$f":"'3| Compensation'!AA$21","v":0},{"$f":"'3| Compensation'!AA$19","v":"Click to Select"},{"$f":"'3| Compensation'!AA$20","v":"Click to Select"},null,45756]

{"sheet":"CB USE ONLY","index":9,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[null,"How frequent are the club's pay periods?",null,"When do your club's annual compensation reviews happen?",null,"When do the club's annual pay raises go into effect?"]
[null,"Click to Select",null,"Click to Select",null,"Click to Select"]
[null,"Weekly",null,"Anniversary Date",null,"Anniversary Date"]
[null,"Bi-weekly",null,"January",null,"January"]
[null,"Semi-monthly",null,"February",null,"February"]
[null,"Monthly",null,"March",null,"March"]
[null,null,null,"April",null,"April"]
[null,null,null,"May",null,"May"]
[null,null,null,"June",null,"June"]
[null,null,null,"July",null,"July"]
[null,null,null,"August",null,"August"]
[null,null,null,"September",null,"September"]
[null,null,null,"October",null,"October"]
[null,null,null,"November",null,"November"]
[null,null,null,"December",null,"December"]
[null,null,null,"N/A or Other"]