{"text_format":"2","workbook":"xlsx","n_sheets":8,"sheets":["Contact ","Admin","Differentials","Clinical","Benefits","Recruitment","Time Off","DoNotUse"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"1904"}

{"sheet":"Contact ","index":0,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[[21,0,21,3],[25,0,25,3],[0,0,0,3],[1,1,1,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[15,2,16,2],[17,2,18,2],[5,1,5,3],[6,1,6,3],[7,0,7,3],[19,0,19,3],[13,2,13,3],[14,0,14,3]]}
["Section 1: Your Contact Information"]
["Full Name:",{"$f":"IF(ISBLANK(DoNotUse!B3)=FALSE,DoNotUse!B3,\"\")","v":""}]
["Title:",{"$f":"IF(ISBLANK(DoNotUse!B4)=FALSE,DoNotUse!B4,\"\")","v":""}]
["Organization/Company Name:",{"$f":"IF(ISBLANK(DoNotUse!B5)=FALSE,DoNotUse!B5,\"\")","v":""}]
["Telephone:",{"$f":"IF(ISBLANK(DoNotUse!B6)=FALSE,DoNotUse!B6,\"\")","v":""}]
["Email Address for Questionnaire:",{"$f":"IF(ISBLANK(DoNotUse!B7)=FALSE,DoNotUse!B7,\"\")","v":""}]
["Email Address for Report:",{"$f":"IF(ISBLANK(DoNotUse!B8)=FALSE,DoNotUse!B8,\"\")","v":""}]
["Demographic Areas - number of locations per each district represented by this data \n(If wages or benefits vary by location, please submit separate file for each.) "]
["District 1:",{"$f":"IF(ISBLANK(DoNotUse!B9)=FALSE,DoNotUse!B9,\"\")","v":""},"District 7:",{"$f":"IF(ISBLANK(DoNotUse!B15)=FALSE,DoNotUse!B15,\"\")","v":""}]
["District 2:",{"$f":"IF(ISBLANK(DoNotUse!B10)=FALSE,DoNotUse!B10,\"\")","v":""},"District 8:",{"$f":"IF(ISBLANK(DoNotUse!B16)=FALSE,DoNotUse!B16,\"\")","v":""}]
["District 3:",{"$f":"IF(ISBLANK(DoNotUse!B11)=FALSE,DoNotUse!B11,\"\")","v":""},"District 9:",{"$f":"IF(ISBLANK(DoNotUse!B17)=FALSE,DoNotUse!B17,\"\")","v":""}]
["District 4:",{"$f":"IF(ISBLANK(DoNotUse!B12)=FALSE,DoNotUse!B12,\"\")","v":""},"District 10:",{"$f":"IF(ISBLANK(DoNotUse!B18)=FALSE,DoNotUse!B18,\"\")","v":""}]
["District 5:",{"$f":"IF(ISBLANK(DoNotUse!B13)=FALSE,DoNotUse!B13,\"\")","v":""},"District 11:",{"$f":"IF(ISBLANK(DoNotUse!B19)=FALSE,DoNotUse!B19,\"\")","v":""}]
["District 6:",{"$f":"IF(ISBLANK(DoNotUse!B14)=FALSE,DoNotUse!B14,\"\")","v":""}]
["Business Type - What type of home care business is your company? \n(If wages or benefits vary by business type, please submit separate file for each.) "]
["Medicare or Medicaid Certified:",{"$f":"IF(ISBLANK(DoNotUse!B20)=FALSE,DoNotUse!B20,\"(Select from List)\")","v":"(Select from List)"},"Number of Medicaid Private Duty Nurses (PDN):"]
["Private Care/Private Duty:",{"$f":"IF(ISBLANK(DoNotUse!B21)=FALSE,DoNotUse!B21,\"(Select Yes or No)\")","v":"(Select Yes or No)"},null,{"$f":"IF(ISBLANK(DoNotUse!B23)=FALSE,DoNotUse!B24,\"\")","v":""}]
["Homemaker & Companion Agency:",{"$f":"IF(ISBLANK(DoNotUse!B22)=FALSE,DoNotUse!B22,\"(Select Yes or No)\")","v":"(Select Yes or No)"},"Average Per Hour Wage of Medicaid PDNs:"]
["Nurse Registry:",{"$f":"IF(ISBLANK(DoNotUse!B23)=FALSE,DoNotUse!B23,\"(Select Yes or No)\")","v":"(Select Yes or No)"},null,{"$f":"IF(ISBLANK(DoNotUse!B27)=FALSE,DoNotUse!B25,\"\")","v":""}]
["Productivity Standards - How many vists are normally expected of your full time workers? "]
["HH Aides, CNAs & Companions:",{"$f":"IF(ISBLANK(DoNotUse!B26)=FALSE,DoNotUse!B26,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B27)=FALSE,DoNotUse!B27,\"(Select Per Day or Week)\")","v":"(Select Per Day or Week)"}]
["Average Visit Length - How long are your normal clinical visits?"]
["Start of Care (Nurse or Therapist)",{"$f":"IF(ISBLANK(DoNotUse!B28)=FALSE,DoNotUse!B28,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B29)=FALSE,DoNotUse!B29,\"(Select Minutes or Hours)\")","v":"(Select Minutes or Hours)"}]
["Eval Visit (Nurse or Therapist)",{"$f":"IF(ISBLANK(DoNotUse!B30)=FALSE,DoNotUse!B30,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B31)=FALSE,DoNotUse!B31,\"(Select Minutes or Hours)\")","v":"(Select Minutes or Hours)"}]
["Revisit (Nurse or Therapist)",{"$f":"IF(ISBLANK(DoNotUse!B32)=FALSE,DoNotUse!B32,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B33)=FALSE,DoNotUse!B33,\"(Select Minutes or Hours)\")","v":"(Select Minutes or Hours)"}]
["Pay Models Used - How do you predominately pay your clinical staff?"]
["Salaried Staff",{"$f":"IF(ISBLANK(DoNotUse!B34)=FALSE,DoNotUse!B34,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Per Visit",{"$f":"IF(ISBLANK(DoNotUse!B35)=FALSE,DoNotUse!B35,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Per Hour",{"$f":"IF(ISBLANK(DoNotUse!B36)=FALSE,DoNotUse!B36,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]

{"sheet":"Admin","index":1,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[[23,1,23,2],[24,1,24,2],[14,0,14,2],[0,0,0,2],[1,0,1,2],[3,0,3,2],[6,0,6,1]]}
["Section 2: Office Staff & Support Staff (as of June 30, 2024)"]
["Instructions for Sections 2 and 3:\n* Please provide the info requested in these sections on an FTE basis. Definition of FTE: Salaried staff considered to be full-time staff under the agency's policies; or each 2,080 hours paid per year to part-time salaried staff; or each 2,080 hours paid per year to hourly paid staff or staff paid by the visit, or contractors paid pursuant to a contract.  \n* Refer to \"Definitions of Job Descriptions\" to ensure the questionnaire position matches the position in your organization.  \n* Convert salary info to an hourly rate. Formula: Salary / 52 weeks / number of hours per week. Example: $30,000 / 52 weeks / 40 hours  = $14.42  \n* Please report average wage info for positions with more than one incumbent.  "]
[]
["Office Staff - HOURLY RATES"]
[null,"Starting HOURLY Rate","Current HOURLY Rate"]
["1. Administrator / Exec. Director",{"$f":"IF(ISBLANK(DoNotUse!B38)=FALSE,DoNotUse!B38,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B39)=FALSE,DoNotUse!B39,\"\")","v":""}]
["# of branches or locations overseen by Admin/Exec. Dir:",null,{"$f":"IF(ISBLANK(DoNotUse!B40)=FALSE,DoNotUse!B40,\"\")","v":""}]
["2. Chief Financial Officer (CFO)",{"$f":"IF(ISBLANK(DoNotUse!B41)=FALSE,DoNotUse!B41,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B42)=FALSE,DoNotUse!B42,\"\")","v":""}]
["3. Director of Nursing",{"$f":"IF(ISBLANK(DoNotUse!B43)=FALSE,DoNotUse!B43,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B44)=FALSE,DoNotUse!B44,\"\")","v":""}]
["4. Scheduling Coordinator",{"$f":"IF(ISBLANK(DoNotUse!B45)=FALSE,DoNotUse!B45,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B46)=FALSE,DoNotUse!B46,\"\")","v":""}]
["5. Business / Office Manager",{"$f":"IF(ISBLANK(DoNotUse!B47)=FALSE,DoNotUse!B47,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B48)=FALSE,DoNotUse!B48,\"\")","v":""}]
["6. Director, Business Development",{"$f":"IF(ISBLANK(DoNotUse!B49)=FALSE,DoNotUse!B49,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B50)=FALSE,DoNotUse!B50,\"\")","v":""}]
["7. Administrative Assistant",{"$f":"IF(ISBLANK(DoNotUse!B51)=FALSE,DoNotUse!B51,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B52)=FALSE,DoNotUse!B52,\"\")","v":""}]
[]
["Support Staff - HOURLY RATES"]
[null,"Starting HOURLY Rate","Current HOURLY Rate"]
["1. Accountant/Bookkeeper",{"$f":"IF(ISBLANK(DoNotUse!B53)=FALSE,DoNotUse!B53,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B54)=FALSE,DoNotUse!B54,\"\")","v":""}]
["2. Billing Clerk",{"$f":"IF(ISBLANK(DoNotUse!B55)=FALSE,DoNotUse!B55,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B56)=FALSE,DoNotUse!B56,\"\")","v":""}]
["3. Clerical/Secretarial/Filing",{"$f":"IF(ISBLANK(DoNotUse!B57)=FALSE,DoNotUse!B57,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B58)=FALSE,DoNotUse!B58,\"\")","v":""}]
["4. Intake / Home Care Coordinator",{"$f":"IF(ISBLANK(DoNotUse!B59)=FALSE,DoNotUse!B59,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B60)=FALSE,DoNotUse!B60,\"\")","v":""}]
["5. Nursing Supervisor",{"$f":"IF(ISBLANK(DoNotUse!B61)=FALSE,DoNotUse!B61,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B62)=FALSE,DoNotUse!B62,\"\")","v":""}]
["6. Personnel Manager",{"$f":"IF(ISBLANK(DoNotUse!B63)=FALSE,DoNotUse!B63,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B64)=FALSE,DoNotUse!B64,\"\")","v":""}]
["7. Marketing/Facility Liaison",{"$f":"IF(ISBLANK(DoNotUse!B65)=FALSE,DoNotUse!B65,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B66)=FALSE,DoNotUse!B66,\"\")","v":""}]
["7a.Please describe quota requirements for marketing staff's base pay:",{"$f":"IF(ISBLANK(DoNotUse!B67)=FALSE,DoNotUse!B67,\"\")","v":""}]
["7b.Please describe potential additional compensation for marketing staff. This may be % of base salary. ",{"$f":"IF(ISBLANK(DoNotUse!B68)=FALSE,DoNotUse!B68,\"\")","v":""}]

{"sheet":"Differentials","index":2,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4],[2,0,7,2],[2,3,9,4]]}
["Section 3: Clinical Staff - DIFFERENTIALS BY AMOUNTS & PERCENTAGES  (as of June 30, 2024)"]
["DIFFERENTIALS are ONLY the amount ABOVE and BEYOND what your usual payment is."]
["AMOUNT examples: \n* Hourly Differential = $3 if normal hourly rate is $20 and you pay $23 for evening hours. \n* Per Visit Differential = $5 if normal visit rate is $13 and you pay $18 for evening visits.",null,null,"PERCENTAGE examples: \n* Hourly Differential = 50% if normal rate is $20 and you pay $30 for evenings. (time & 1/2).\n* Per Visit Differential = 15% if normal visit rate is $20 and you pay $23 for evening visits."]
[]
[]
[]
[]
[]
["1. Travel Reimbursement","Diff. Amount","Amount Per"]
["Paid to Field Staff",{"$f":"IF(ISBLANK(DoNotUse!B70)=FALSE,DoNotUse!B70,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B71)=FALSE,DoNotUse!B71,\"(select from list)\")","v":"(select from list)"}]
["2. Nursing Field Staff","Diff. Amount","Amount Per","Diff. Percentage","% Per"]
["Holiday",{"$f":"IF(ISBLANK(DoNotUse!B72)=FALSE,DoNotUse!B72,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B73)=FALSE,DoNotUse!B73,\"(select from list)\")","v":"(select from list)"},{"$f":"IF(ISBLANK(DoNotUse!B114)=FALSE,DoNotUse!B114,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B115)=FALSE,DoNotUse!B115,\"(select from list)\")","v":"(select from list)"}]
["Evening",{"$f":"IF(ISBLANK(DoNotUse!B74)=FALSE,DoNotUse!B74,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B75)=FALSE,DoNotUse!B75,\"(select from list)\")","v":"(select from list)"},{"$f":"IF(ISBLANK(DoNotUse!B116)=FALSE,DoNotUse!B116,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B117)=FALSE,DoNotUse!B117,\"(select from list)\")","v":"(select from list)"}]
["Weekend",{"$f":"IF(ISBLANK(DoNotUse!B76)=FALSE,DoNotUse!B76,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B77)=FALSE,DoNotUse!B77,\"(select from list)\")","v":"(select from list)"},{"$f":"IF(ISBLANK(DoNotUse!B118)=FALSE,DoNotUse!B118,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B119)=FALSE,DoNotUse!B119,\"(select from list)\")","v":"(select from list)"}]
["3. On-Call RNs","Diff. Amount","Amount Per","Diff. Percentage","% Per"]
["Evening",{"$f":"IF(ISBLANK(DoNotUse!B78)=FALSE,DoNotUse!B78,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B79)=FALSE,DoNotUse!B79,\"(select from list)\")","v":"(select from list)"},{"$f":"IF(ISBLANK(DoNotUse!B120)=FALSE,DoNotUse!B120,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B121)=FALSE,DoNotUse!B121,\"(select from list)\")","v":"(select from list)"}]
["Weekend",{"$f":"IF(ISBLANK(DoNotUse!B80)=FALSE,DoNotUse!B80,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B81)=FALSE,DoNotUse!B81,\"(select from list)\")","v":"(select from list)"},{"$f":"IF(ISBLANK(DoNotUse!B122)=FALSE,DoNotUse!B122,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B123)=FALSE,DoNotUse!B123,\"(select from list)\")","v":"(select from list)"}]
["Week",{"$f":"IF(ISBLANK(DoNotUse!B82)=FALSE,DoNotUse!B82,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B83)=FALSE,DoNotUse!B83,\"(select from list)\")","v":"(select from list)"},{"$f":"IF(ISBLANK(DoNotUse!B124)=FALSE,DoNotUse!B124,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B125)=FALSE,DoNotUse!B125,\"(select from list)\")","v":"(select from list)"}]
["4. On-Call LPNs","Diff. Amount","Amount Per","Diff. Percentage","% Per"]
["Evening",{"$f":"IF(ISBLANK(DoNotUse!B84)=FALSE,DoNotUse!B84,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B85)=FALSE,DoNotUse!B85,\"(select from list)\")","v":"(select from list)"},{"$f":"IF(ISBLANK(DoNotUse!B126)=FALSE,DoNotUse!B126,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B127)=FALSE,DoNotUse!B127,\"(select from list)\")","v":"(select from list)"}]
["Weekend",{"$f":"IF(ISBLANK(DoNotUse!B86)=FALSE,DoNotUse!B86,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B87)=FALSE,DoNotUse!B87,\"(select from list)\")","v":"(select from list)"},{"$f":"IF(ISBLANK(DoNotUse!B128)=FALSE,DoNotUse!B128,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B129)=FALSE,DoNotUse!B129,\"(select from list)\")","v":"(select from list)"}]
["Week",{"$f":"IF(ISBLANK(DoNotUse!B88)=FALSE,DoNotUse!B88,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B89)=FALSE,DoNotUse!B89,\"(select from list)\")","v":"(select from list)"},{"$f":"IF(ISBLANK(DoNotUse!B130)=FALSE,DoNotUse!B130,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B131)=FALSE,DoNotUse!B131,\"(select from list)\")","v":"(select from list)"}]
["5. Physcial Therapsits","Diff. Amount","Amount Per","Diff. Percentage","% Per"]
["Holiday",{"$f":"IF(ISBLANK(DoNotUse!B90)=FALSE,DoNotUse!B90,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B91)=FALSE,DoNotUse!B91,\"(select from list)\")","v":"(select from list)"},{"$f":"IF(ISBLANK(DoNotUse!B132)=FALSE,DoNotUse!B132,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B133)=FALSE,DoNotUse!B133,\"(select from list)\")","v":"(select from list)"}]
["Evening",{"$f":"IF(ISBLANK(DoNotUse!B92)=FALSE,DoNotUse!B92,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B93)=FALSE,DoNotUse!B93,\"(select from list)\")","v":"(select from list)"},{"$f":"IF(ISBLANK(DoNotUse!B134)=FALSE,DoNotUse!B134,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B135)=FALSE,DoNotUse!B135,\"(select from list)\")","v":"(select from list)"}]
["Weekend",{"$f":"IF(ISBLANK(DoNotUse!B94)=FALSE,DoNotUse!B94,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B95)=FALSE,DoNotUse!B95,\"(select from list)\")","v":"(select from list)"},{"$f":"IF(ISBLANK(DoNotUse!B136)=FALSE,DoNotUse!B136,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B137)=FALSE,DoNotUse!B137,\"(select from list)\")","v":"(select from list)"}]
["6. Physical Therapist Assistants","Diff. Amount","Amount Per","Diff. Percentage","% Per"]
["Holiday",{"$f":"IF(ISBLANK(DoNotUse!B96)=FALSE,DoNotUse!B96,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B97)=FALSE,DoNotUse!B97,\"(select from list)\")","v":"(select from list)"},{"$f":"IF(ISBLANK(DoNotUse!B138)=FALSE,DoNotUse!B138,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B139)=FALSE,DoNotUse!B139,\"(select from list)\")","v":"(select from list)"}]
["Evening",{"$f":"IF(ISBLANK(DoNotUse!B98)=FALSE,DoNotUse!B98,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B99)=FALSE,DoNotUse!B99,\"(select from list)\")","v":"(select from list)"},{"$f":"IF(ISBLANK(DoNotUse!B140)=FALSE,DoNotUse!B140,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B141)=FALSE,DoNotUse!B141,\"(select from list)\")","v":"(select from list)"}]
["Weekend",{"$f":"IF(ISBLANK(DoNotUse!B100)=FALSE,DoNotUse!B100,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B101)=FALSE,DoNotUse!B101,\"(select from list)\")","v":"(select from list)"},{"$f":"IF(ISBLANK(DoNotUse!B142)=FALSE,DoNotUse!B142,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B143)=FALSE,DoNotUse!B143,\"(select from list)\")","v":"(select from list)"}]
["7. Home Health Aides","Diff. Amount","Amount Per","Diff. Percentage","% Per"]
["Holiday",{"$f":"IF(ISBLANK(DoNotUse!B102)=FALSE,DoNotUse!B102,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B103)=FALSE,DoNotUse!B103,\"(select from list)\")","v":"(select from list)"},{"$f":"IF(ISBLANK(DoNotUse!B144)=FALSE,DoNotUse!B144,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B145)=FALSE,DoNotUse!B145,\"(select from list)\")","v":"(select from list)"}]
["Evening",{"$f":"IF(ISBLANK(DoNotUse!B104)=FALSE,DoNotUse!B104,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B105)=FALSE,DoNotUse!B105,\"(select from list)\")","v":"(select from list)"},{"$f":"IF(ISBLANK(DoNotUse!B146)=FALSE,DoNotUse!B146,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B147)=FALSE,DoNotUse!B147,\"(select from list)\")","v":"(select from list)"}]
["Weekend",{"$f":"IF(ISBLANK(DoNotUse!B106)=FALSE,DoNotUse!B106,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B107)=FALSE,DoNotUse!B107,\"(select from list)\")","v":"(select from list)"},{"$f":"IF(ISBLANK(DoNotUse!B148)=FALSE,DoNotUse!B148,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B149)=FALSE,DoNotUse!B149,\"(select from list)\")","v":"(select from list)"}]
["8. Homemaker/Companions","Diff. Amount","Amount Per","Diff. Percentage","% Per"]
["Holiday",{"$f":"IF(ISBLANK(DoNotUse!B108)=FALSE,DoNotUse!B108,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B109)=FALSE,DoNotUse!B109,\"(select from list)\")","v":"(select from list)"},{"$f":"IF(ISBLANK(DoNotUse!B150)=FALSE,DoNotUse!B150,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B151)=FALSE,DoNotUse!B151,\"(select from list)\")","v":"(select from list)"}]
["Evening",{"$f":"IF(ISBLANK(DoNotUse!B110)=FALSE,DoNotUse!B110,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B111)=FALSE,DoNotUse!B111,\"(select from list)\")","v":"(select from list)"},{"$f":"IF(ISBLANK(DoNotUse!B152)=FALSE,DoNotUse!B152,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B153)=FALSE,DoNotUse!B153,\"(select from list)\")","v":"(select from list)"}]
["Weekend",{"$f":"IF(ISBLANK(DoNotUse!B112)=FALSE,DoNotUse!B112,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B113)=FALSE,DoNotUse!B113,\"(select from list)\")","v":"(select from list)"},{"$f":"IF(ISBLANK(DoNotUse!B154)=FALSE,DoNotUse!B154,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B155)=FALSE,DoNotUse!B155,\"(select from list)\")","v":"(select from list)"}]

{"sheet":"Clinical","index":3,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,6,1,7],[1,8,1,9],[26,3,26,5],[29,3,29,5],[1,1,1,2],[1,3,1,5],[18,3,18,5],[23,3,23,5],[15,1,15,9]]}
["Section 4: Clinical Staff - PER HOUR & PER VISIT RATES (as of June 30, 2024)"]
["Field Staff Positions","PER HOUR\nEmployees\n\n* Please only report regular weekday hours here. Special hours should be reported in Section 3.",null,"PER VISIT\nEmployees\n\n* Please only report regular weekday visits here. Special visits should be reported in Section 3.",null,null,"PER DAY/PER DIEM\nEmployees",null,"PER DAY/PER DIEM\nContracted 1099 Workers"]
[null,"Starting Wage","Current Wage","Starting Rate","Current Rate","High-Tech Rate\ni.e. complex wound","Starting Rate","Current Rate","Starting Rate","Current Rate"]
["1. Registered Nurse",{"$f":"IF(ISBLANK(DoNotUse!B157)=FALSE,DoNotUse!B157,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B158)=FALSE,DoNotUse!B158,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B173)=FALSE,DoNotUse!B173,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B174)=FALSE,DoNotUse!B174,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B175)=FALSE,DoNotUse!B175,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B190)=FALSE,DoNotUse!B190,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B191)=FALSE,DoNotUse!B191,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B198)=FALSE,DoNotUse!B198,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B199)=FALSE,DoNotUse!B199,\"\")","v":""}]
["2. Licensed Practical Nurse",{"$f":"IF(ISBLANK(DoNotUse!B159)=FALSE,DoNotUse!B159,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B160)=FALSE,DoNotUse!B160,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B176)=FALSE,DoNotUse!B176,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B177)=FALSE,DoNotUse!B177,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B178)=FALSE,DoNotUse!B178,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B192)=FALSE,DoNotUse!B192,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B193)=FALSE,DoNotUse!B193,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B200)=FALSE,DoNotUse!B200,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B201)=FALSE,DoNotUse!B201,\"\")","v":""}]
["3. Case Manager",{"$f":"IF(ISBLANK(DoNotUse!B161)=FALSE,DoNotUse!B161,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B162)=FALSE,DoNotUse!B162,\"\")","v":""}]
["4. Home Health Aide (receives benefits)",{"$f":"IF(ISBLANK(DoNotUse!B163)=FALSE,DoNotUse!B163,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B164)=FALSE,DoNotUse!B164,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B179)=FALSE,DoNotUse!B179,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B180)=FALSE,DoNotUse!B180,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(DoNotUse!B202)=FALSE,DoNotUse!B202,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B203)=FALSE,DoNotUse!B203,\"\")","v":""}]
["5. Home Health Aide (does not receive benefits)",{"$f":"IF(ISBLANK(DoNotUse!B165)=FALSE,DoNotUse!B165,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B166)=FALSE,DoNotUse!B166,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B181)=FALSE,DoNotUse!B181,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B182)=FALSE,DoNotUse!B182,\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK(DoNotUse!B204)=FALSE,DoNotUse!B204,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B205)=FALSE,DoNotUse!B205,\"\")","v":""}]
["6. Physical Therapist (PT)",{"$f":"IF(ISBLANK(DoNotUse!B167)=FALSE,DoNotUse!B167,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B168)=FALSE,DoNotUse!B168,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B183)=FALSE,DoNotUse!B183,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B184)=FALSE,DoNotUse!B184,\"\")","v":""},null,{"$f":"IF(ISBLANK(DoNotUse!B194)=FALSE,DoNotUse!B194,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B195)=FALSE,DoNotUse!B195,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B206)=FALSE,DoNotUse!B206,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B207)=FALSE,DoNotUse!B207,\"\")","v":""}]
["7. Physical Therapist Assistant (PTA)",{"$f":"IF(ISBLANK(DoNotUse!B169)=FALSE,DoNotUse!B169,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B170)=FALSE,DoNotUse!B170,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B185)=FALSE,DoNotUse!B185,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B186)=FALSE,DoNotUse!B186,\"\")","v":""},null,{"$f":"IF(ISBLANK(DoNotUse!B196)=FALSE,DoNotUse!B196,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B197)=FALSE,DoNotUse!B197,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B208)=FALSE,DoNotUse!B208,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B209)=FALSE,DoNotUse!B209,\"\")","v":""}]
["8. Homemaker/Companion",{"$f":"IF(ISBLANK(DoNotUse!B171)=FALSE,DoNotUse!B171,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B172)=FALSE,DoNotUse!B172,\"\")","v":""},{"$nulls":5},{"$f":"IF(ISBLANK(DoNotUse!B210)=FALSE,DoNotUse!B210,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B211)=FALSE,DoNotUse!B211,\"\")","v":""}]
[]
["Exception Rates:",null,null,"Sign-Up Admission Rate","Evaluation Rate"]
["1a. Registered Nurse",null,null,{"$f":"IF(ISBLANK(DoNotUse!B187)=FALSE,DoNotUse!B187,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B188)=FALSE,DoNotUse!B188,\"\")","v":""}]
["9. Live-In Aide, how do you structure compensation and how much do you pay? "]
[null,{"$f":"IF(ISBLANK(DoNotUse!B189)=FALSE,DoNotUse!B189,\"\")","v":""}]
[]
[{"$nulls":4},"b. Current Rate",{"$f":"IF(ISBLANK(DoNotUse!E182)=FALSE,DoNotUse!E182,\"\")","v":""}]
[null,null,null,"11. Physical Therapist - PAID PER VISIT"]
[{"$nulls":4},"a. Starting PER VISIT RATE",{"$f":"IF(ISBLANK(DoNotUse!E183)=FALSE,DoNotUse!E183,\"\")","v":""}]
[{"$nulls":4},"b. Current Rate",{"$f":"IF(ISBLANK(DoNotUse!E184)=FALSE,DoNotUse!E184,\"\")","v":""}]
[{"$nulls":4},"c. Sign-up/Admission",{"$f":"IF(ISBLANK(DoNotUse!#REF!)=FALSE,DoNotUse!#REF!,\"\")","v":{"$error":"#REF!"}}]
[{"$nulls":4},"d. Evaluation PER VISIT",{"$f":"IF(ISBLANK(DoNotUse!#REF!)=FALSE,DoNotUse!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,null,null,"12. Physical Therapist Assistant (PTA) - PAID PER VISIT"]
[{"$nulls":4},"a. Starting PER VISIT RATE",{"$f":"IF(ISBLANK(DoNotUse!E185)=FALSE,DoNotUse!E185,\"\")","v":""}]
[{"$nulls":4},"b. Current Rate",{"$f":"IF(ISBLANK(DoNotUse!E186)=FALSE,DoNotUse!E186,\"\")","v":""}]
[null,null,null,"15.Homemaker - PAID PER VISIT"]
[{"$nulls":4},"a. Starting PER VISIT RATE",{"$f":"IF(ISBLANK(DoNotUse!#REF!)=FALSE,DoNotUse!#REF!,\"\")","v":{"$error":"#REF!"}}]
[{"$nulls":4},"b. Current Rate",{"$f":"IF(ISBLANK(DoNotUse!#REF!)=FALSE,DoNotUse!#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,null,null,"16. Companion/Escort"]
[{"$nulls":4},"a. Starting PER VISIT RATE",{"$f":"IF(ISBLANK(DoNotUse!#REF!)=FALSE,DoNotUse!#REF!,\"\")","v":{"$error":"#REF!"}}]
[{"$nulls":4},"b. Current Rate",{"$f":"IF(ISBLANK(DoNotUse!#REF!)=FALSE,DoNotUse!#REF!,\"\")","v":{"$error":"#REF!"}}]

{"sheet":"Benefits","index":4,"n_rows":48,"n_cols":2,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,2],[4,0,4,2],[15,0,15,2],[40,0,40,2],[19,0,19,2],[21,0,22,0],[28,0,28,2],[30,0,31,0]]}
["Section 5: Employee Benefits (as of June 30, 2024)"]
["Office Staff",{"$f":"IF(ISBLANK(DoNotUse!B213)=FALSE,DoNotUse!B213,\"(select from list)\")","v":"(select from list)"}]
["30+ Hours per week Clinical Staff",{"$f":"IF(ISBLANK(DoNotUse!B214)=FALSE,DoNotUse!B214,\"(select from list)\")","v":"(select from list)"}]
["Full Time Clinical Staff",{"$f":"IF(ISBLANK(DoNotUse!B215)=FALSE,DoNotUse!B215,\"(select from list)\")","v":"(select from list)"}]
["Insurance (select all of those that you provide):"]
["Health/Medical",{"$f":"IF(ISBLANK(DoNotUse!B216)=FALSE,DoNotUse!B216,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Dental",{"$f":"IF(ISBLANK(DoNotUse!B217)=FALSE,DoNotUse!B217,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Life",{"$f":"IF(ISBLANK(DoNotUse!B218)=FALSE,DoNotUse!B218,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Vision",{"$f":"IF(ISBLANK(DoNotUse!B219)=FALSE,DoNotUse!B219,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Automobile",{"$f":"IF(ISBLANK(DoNotUse!B220)=FALSE,DoNotUse!B220,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Personal Liability",{"$f":"IF(ISBLANK(DoNotUse!B221)=FALSE,DoNotUse!B221,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Short Term Disability",{"$f":"IF(ISBLANK(DoNotUse!B222)=FALSE,DoNotUse!B222,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Long Term Disability",{"$f":"IF(ISBLANK(DoNotUse!B223)=FALSE,DoNotUse!B223,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Supplemental ",{"$f":"IF(ISBLANK(DoNotUse!B224)=FALSE,DoNotUse!B224,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Other Insurance:",{"$f":"IF(ISBLANK(DoNotUse!B225)=FALSE,DoNotUse!B225,\"\")","v":""}]
["Technology (select all that you provide):"]
["Cell/Mobile Phone",{"$f":"IF(ISBLANK(DoNotUse!B226)=FALSE,DoNotUse!B226,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Laptop/PDA/Tablet",{"$f":"IF(ISBLANK(DoNotUse!B227)=FALSE,DoNotUse!B227,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Phys Portal for eSignatures",{"$f":"IF(ISBLANK(DoNotUse!B228)=FALSE,DoNotUse!B228,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Salary/Pay increase based on MERIT"]
["Do you offer merit increases?",{"$f":"IF(ISBLANK(DoNotUse!B229)=FALSE,DoNotUse!B229,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["What was your recent average MERIT PAY increase %?","If no, skip to COLA"]
[null,{"$f":"IF(ISBLANK(DoNotUse!B230)=FALSE,DoNotUse!B230,\"\")","v":""}]
["If so, on what are they based?"]
["Performance",{"$f":"IF(ISBLANK(DoNotUse!B231)=FALSE,DoNotUse!B231,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Productivity",{"$f":"IF(ISBLANK(DoNotUse!B232)=FALSE,DoNotUse!B232,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Budget/Available Funds",{"$f":"IF(ISBLANK(DoNotUse!B233)=FALSE,DoNotUse!B233,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Other Merit:",{"$f":"IF(ISBLANK(DoNotUse!B234)=FALSE,DoNotUse!B234,\"\")","v":""}]
["Cost of Living Adjustment (COLA) Increase"]
["Do you give an annual COLA?",{"$f":"IF(ISBLANK(DoNotUse!B235)=FALSE,DoNotUse!B235,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["If yes, what was your COLA % increase last year?","If no, skip to Staff Bonues"]
[null,{"$f":"IF(ISBLANK(DoNotUse!B236)=FALSE,DoNotUse!B236,\"\")","v":""}]
["Staff Bonuses"]
["Do you provide staff bonuses?",{"$f":"IF(ISBLANK(DoNotUse!B237)=FALSE,DoNotUse!B237,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["If so, what are they based?","If no, skip to Retirement Plans"]
["Performance",{"$f":"IF(ISBLANK(DoNotUse!B238)=FALSE,DoNotUse!B238,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Productivity",{"$f":"IF(ISBLANK(DoNotUse!B239)=FALSE,DoNotUse!B239,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Budget/Available Funds",{"$f":"IF(ISBLANK(DoNotUse!B240)=FALSE,DoNotUse!B240,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Other Bonus:",{"$f":"IF(ISBLANK(DoNotUse!B241)=FALSE,DoNotUse!B241,\"\")","v":""}]
[]
["Retirement Plans (select all that you provide)"]
["Do you offer retirement plans?",{"$f":"IF(ISBLANK(DoNotUse!B242)=FALSE,DoNotUse!B242,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["If so, what type?","If no, skip to section 6"]
["401K",{"$f":"IF(ISBLANK(DoNotUse!B243)=FALSE,DoNotUse!B243,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["403-B",{"$f":"IF(ISBLANK(DoNotUse!B244)=FALSE,DoNotUse!B244,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["SEP",{"$f":"IF(ISBLANK(DoNotUse!B245)=FALSE,DoNotUse!B245,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Pension",{"$f":"IF(ISBLANK(DoNotUse!B246)=FALSE,DoNotUse!B246,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Other",{"$f":"IF(ISBLANK(DoNotUse!B247)=FALSE,DoNotUse!B247,\"\")","v":""}]

{"sheet":"Recruitment","index":5,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,2,25,3],[0,0,0,3],[23,2,23,3],[24,2,24,3],[1,0,1,2],[18,0,18,3],[20,0,20,2],[3,0,3,3],[8,0,8,3],[13,0,13,3],[22,2,22,3],[21,0,21,3]]}
["Section 6: Recruitment Incentive Bonuses (as of June 30, 2024)"]
["Do you offer $ incentives to current staff to find new employees? (If no, skip to Sign-On Bonuses)",null,null,{"$f":"IF(ISBLANK(DoNotUse!B249)=FALSE,DoNotUse!B249,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
[]
["Nurse Positions"]
["Amount:",{"$f":"IF(ISBLANK(DoNotUse!B250)=FALSE,DoNotUse!B250,\"\")","v":""}]
["On Hire:",{"$f":"IF(ISBLANK(DoNotUse!B251)=FALSE,DoNotUse!B251,\"(Select Yes or No)\")","v":"(Select Yes or No)"},"After 90 Days: ",{"$f":"IF(ISBLANK(DoNotUse!B254)=FALSE,DoNotUse!B254,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["After 30 Days:",{"$f":"IF(ISBLANK(DoNotUse!B252)=FALSE,DoNotUse!B252,\"(Select Yes or No)\")","v":"(Select Yes or No)"},"After 6 months:",{"$f":"IF(ISBLANK(DoNotUse!B255)=FALSE,DoNotUse!B255,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["After 60 Days:",{"$f":"IF(ISBLANK(DoNotUse!B253)=FALSE,DoNotUse!B253,\"(Select Yes or No)\")","v":"(Select Yes or No)"},"After 1 Year:",{"$f":"IF(ISBLANK(DoNotUse!B256)=FALSE,DoNotUse!B256,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Therapist Positions"]
["Amount:",{"$f":"IF(ISBLANK(DoNotUse!B257)=FALSE,DoNotUse!B257,\"\")","v":""}]
["On Hire:",{"$f":"IF(ISBLANK(DoNotUse!B258)=FALSE,DoNotUse!B258,\"(Select Yes or No)\")","v":"(Select Yes or No)"},"After 90 Days: ",{"$f":"IF(ISBLANK(DoNotUse!B261)=FALSE,DoNotUse!B261,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["After 30 Days:",{"$f":"IF(ISBLANK(DoNotUse!B259)=FALSE,DoNotUse!B259,\"(Select Yes or No)\")","v":"(Select Yes or No)"},"After 6 months:",{"$f":"IF(ISBLANK(DoNotUse!B262)=FALSE,DoNotUse!B262,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["After 60 Days:",{"$f":"IF(ISBLANK(DoNotUse!B260)=FALSE,DoNotUse!B260,\"(Select Yes or No)\")","v":"(Select Yes or No)"},"After 1 Year:",{"$f":"IF(ISBLANK(DoNotUse!B263)=FALSE,DoNotUse!B263,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["HHA/CNA Positions"]
["Amount:",{"$f":"IF(ISBLANK(DoNotUse!B264)=FALSE,DoNotUse!B264,\"\")","v":""}]
["On Hire:",{"$f":"IF(ISBLANK(DoNotUse!B265)=FALSE,DoNotUse!B265,\"(Select Yes or No)\")","v":"(Select Yes or No)"},"After 90 Days:",{"$f":"IF(ISBLANK(DoNotUse!B268)=FALSE,DoNotUse!B268,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["After 30 Days:",{"$f":"IF(ISBLANK(DoNotUse!B266)=FALSE,DoNotUse!B266,\"(Select Yes or No)\")","v":"(Select Yes or No)"},"After 6 months:",{"$f":"IF(ISBLANK(DoNotUse!B269)=FALSE,DoNotUse!B269,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["After 60 Days:",{"$f":"IF(ISBLANK(DoNotUse!B267)=FALSE,DoNotUse!B267,\"(Select Yes or No)\")","v":"(Select Yes or No)"},"After 1 Year:",{"$f":"IF(ISBLANK(DoNotUse!B270)=FALSE,DoNotUse!B270,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Sign-On Bonuses"]
[]
["Do you offer $$ sign-on bonuses to newly hired employees?\n(If no, skip to Section 7.)",null,null,{"$f":"IF(ISBLANK(DoNotUse!B271)=FALSE,DoNotUse!B271,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
[]
[null,"Sign-on Amount"]
["Nurses",{"$f":"IF(ISBLANK(DoNotUse!B272)=FALSE,DoNotUse!B272,\"\")","v":""}]
["Therapists",{"$f":"IF(ISBLANK(DoNotUse!B273)=FALSE,DoNotUse!B273,\"\")","v":""}]
["HHAs/CNAS",{"$f":"IF(ISBLANK(DoNotUse!B274)=FALSE,DoNotUse!B274,\"\")","v":""}]

{"sheet":"Time Off","index":6,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,0,33,3],[9,1,9,3],[10,2,10,3],[11,0,11,3],[12,0,12,3],[28,0,28,3],[30,0,30,3],[32,0,32,2],[0,0,0,3],[27,0,27,3],[1,0,1,2],[2,0,2,2],[3,0,3,2],[4,0,4,3]]}
["Section 7: Time Off (as of June 30, 2024)"]
["What kind of time off system do you have?",null,null,{"$f":"IF(ISBLANK(DoNotUse!B276)=FALSE,DoNotUse!B276,\"(select from list)\")","v":"(select from list)"}]
["Who is eligible for time off?",null,null,{"$f":"IF(ISBLANK(DoNotUse!B277)=FALSE,DoNotUse!B277,\"(select from list)\")","v":"(select from list)"}]
["If PTO system, do you offer paid holidays in addition to PTO?",null,null,{"$f":"IF(ISBLANK(DoNotUse!B278)=FALSE,DoNotUse!B278,\"(select from list)\")","v":"(select from list)"}]
["Holidays (select all that you offer):"]
["New Year's Day",{"$f":"IF(ISBLANK(DoNotUse!B279)=FALSE,DoNotUse!B279,\"(Select Yes or No)\")","v":"(Select Yes or No)"},"Labor Day",{"$f":"IF(ISBLANK(DoNotUse!B283)=FALSE,DoNotUse!B283,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["MLK Jr Day",{"$f":"IF(ISBLANK(DoNotUse!B280)=FALSE,DoNotUse!B280,\"(Select Yes or No)\")","v":"(Select Yes or No)"},"Veteran's Day",{"$f":"IF(ISBLANK(DoNotUse!B284)=FALSE,DoNotUse!B284,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Memorial Day",{"$f":"IF(ISBLANK(DoNotUse!B281)=FALSE,DoNotUse!B281,\"(Select Yes or No)\")","v":"(Select Yes or No)"},"Thanksgiving",{"$f":"IF(ISBLANK(DoNotUse!B285)=FALSE,DoNotUse!B285,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Independence Day",{"$f":"IF(ISBLANK(DoNotUse!B282)=FALSE,DoNotUse!B282,\"(Select Yes or No)\")","v":"(Select Yes or No)"},"Christmas",{"$f":"IF(ISBLANK(DoNotUse!B286)=FALSE,DoNotUse!B286,\"(Select Yes or No)\")","v":"(Select Yes or No)"}]
["Other Holidays",{"$f":"IF(ISBLANK(DoNotUse!B287)=FALSE,DoNotUse!B287,\"\")","v":""}]
["# of Personal Days",{"$f":"IF(ISBLANK(DoNotUse!B288)=FALSE,DoNotUse!B288,\"\")","v":""}]
[]
["Seniority System:"]
["Time to Quality","# of Vacation Days","# of Sick Days","Or # of PTO hours accrued per 2-week payroll"]
["Upon Hire",{"$f":"IF(ISBLANK(DoNotUse!B289)=FALSE,DoNotUse!B289,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B290)=FALSE,DoNotUse!B290,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B291)=FALSE,DoNotUse!B291,\"\")","v":""}]
["After 30 days",{"$f":"IF(ISBLANK(DoNotUse!B292)=FALSE,DoNotUse!B292,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B293)=FALSE,DoNotUse!B293,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B294)=FALSE,DoNotUse!B294,\"\")","v":""}]
["After 90 days",{"$f":"IF(ISBLANK(DoNotUse!B295)=FALSE,DoNotUse!B295,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B296)=FALSE,DoNotUse!B296,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B297)=FALSE,DoNotUse!B297,\"\")","v":""}]
["After 6 months",{"$f":"IF(ISBLANK(DoNotUse!B298)=FALSE,DoNotUse!B298,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B299)=FALSE,DoNotUse!B299,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B300)=FALSE,DoNotUse!B300,\"\")","v":""}]
["After 1 year",{"$f":"IF(ISBLANK(DoNotUse!B301)=FALSE,DoNotUse!B301,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B302)=FALSE,DoNotUse!B302,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B303)=FALSE,DoNotUse!B303,\"\")","v":""}]
["After 2 years",{"$f":"IF(ISBLANK(DoNotUse!B304)=FALSE,DoNotUse!B304,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B305)=FALSE,DoNotUse!B305,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B306)=FALSE,DoNotUse!B306,\"\")","v":""}]
["After 3 years",{"$f":"IF(ISBLANK(DoNotUse!B307)=FALSE,DoNotUse!B307,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B308)=FALSE,DoNotUse!B308,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B309)=FALSE,DoNotUse!B309,\"\")","v":""}]
["After 4 years",{"$f":"IF(ISBLANK(DoNotUse!B310)=FALSE,DoNotUse!B310,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B311)=FALSE,DoNotUse!B311,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B312)=FALSE,DoNotUse!B312,\"\")","v":""}]
["After 5 years",{"$f":"IF(ISBLANK(DoNotUse!B313)=FALSE,DoNotUse!B313,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B314)=FALSE,DoNotUse!B314,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B315)=FALSE,DoNotUse!B315,\"\")","v":""}]
["After 6 years",{"$f":"IF(ISBLANK(DoNotUse!B316)=FALSE,DoNotUse!B316,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B317)=FALSE,DoNotUse!B317,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B318)=FALSE,DoNotUse!B318,\"\")","v":""}]
["After 10 years",{"$f":"IF(ISBLANK(DoNotUse!B319)=FALSE,DoNotUse!B319,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B320)=FALSE,DoNotUse!B320,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B321)=FALSE,DoNotUse!B321,\"\")","v":""}]
["After 15 years",{"$f":"IF(ISBLANK(DoNotUse!B322)=FALSE,DoNotUse!B322,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B323)=FALSE,DoNotUse!B323,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B324)=FALSE,DoNotUse!B324,\"\")","v":""}]
["After 20 years",{"$f":"IF(ISBLANK(DoNotUse!B325)=FALSE,DoNotUse!B325,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B326)=FALSE,DoNotUse!B326,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B327)=FALSE,DoNotUse!B327,\"\")","v":""}]
[]
["If you cap at a maximum amount, what is that max amount?"]
[null,{"$f":"IF(ISBLANK(DoNotUse!B328)=FALSE,DoNotUse!B328,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B329)=FALSE,DoNotUse!B329,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B330)=FALSE,DoNotUse!B330,\"\")","v":""}]
["If there's a limit for carrying over to next year, what is the max you can carry? "]
[null,{"$f":"IF(ISBLANK(DoNotUse!B331)=FALSE,DoNotUse!B331,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B332)=FALSE,DoNotUse!B332,\"\")","v":""},{"$f":"IF(ISBLANK(DoNotUse!B333)=FALSE,DoNotUse!B333,\"\")","v":""}]
[]
["Thank you for participating in our survey! Please send completed surveys to Monica Smith by email, msmith@homecarefla.org or fax 888-259-6274. Results will be released in October."]

{"sheet":"DoNotUse","index":7,"n_rows":333,"n_cols":5,"rows_kept":333,"cut":false,"hidden":false,"merged":[]}
["PLEASE DO NOT USE - This worksheet is used to prefill with last year's data and pull results from this year.","PREFILL Last Year's Data","PULL-RESULTS"]
["CONTACT TAB"]
["Full Name:",null,{"$f":"'Contact '!B2","v":""},null,{"$f":"IF(B3<>C3, \"MISMATCH\",\"\")","v":""}]
["Title:",null,{"$f":"'Contact '!B3","v":""}]
["Organization/Company Name:",null,{"$f":"'Contact '!B4","v":""}]
["Telephone:",null,{"$f":"'Contact '!B5","v":""}]
["Email Address for Questionnaire:",null,{"$f":"'Contact '!B6","v":""}]
["Email Address for Report:",null,{"$f":"'Contact '!B7","v":""}]
["District 1:",null,{"$f":"'Contact '!B9","v":""}]
["District 2:",null,{"$f":"'Contact '!B10","v":""}]
["District 3:",null,{"$f":"'Contact '!B11","v":""}]
["District 4:",null,{"$f":"'Contact '!B12","v":""}]
["District 5:",null,{"$f":"'Contact '!B13","v":""}]
["District 6:",null,{"$f":"'Contact '!B14","v":""}]
["District 7:",null,{"$f":"'Contact '!D9","v":""}]
["District 8:",null,{"$f":"'Contact '!D10","v":""}]
["District 9:",null,{"$f":"'Contact '!D11","v":""}]
["District 10:",null,{"$f":"'Contact '!D12","v":""}]
["District 11:",null,{"$f":"'Contact '!D13","v":""}]
["Medicare or Medicaid Certified",null,{"$f":"'Contact '!B16","v":"(Select from List)"}]
["Privately Funded:",null,{"$f":"'Contact '!B17","v":"(Select Yes or No)"}]
["Homemaker & Companion Agency:",null,{"$f":"'Contact '!B18","v":"(Select Yes or No)"}]
["Nurse Registry:",null,{"$f":"'Contact '!B19","v":"(Select Yes or No)"}]
["Number of Medicaid Private Duty Nurses (PDN):",null,{"$f":"'Contact '!D17","v":""}]
["Average Per Hour Wage of Medicaid PDNs:",null,{"$f":"'Contact '!D19","v":""}]
["Prod HH Aides, CNAs & Companions value",null,{"$f":"'Contact '!B21","v":""}]
["Prod HH Aides, CNAs & Companions per",null,{"$f":"'Contact '!C21","v":"(Select Per Day or Week)"}]
["Start of Care (Nurse or Therapist)",null,{"$f":"'Contact '!B23","v":""}]
["(Select Minutes or Hours)",null,{"$f":"'Contact '!C23","v":"(Select Minutes or Hours)"}]
["Eval Visit (Nurse or Therapist)",null,{"$f":"'Contact '!B24","v":""}]
["(Select Minutes or Hours)",null,{"$f":"'Contact '!C24","v":"(Select Minutes or Hours)"}]
["Revisit (Nurse or Therapist)",null,{"$f":"'Contact '!B25","v":""}]
["(Select Minutes or Hours)",null,{"$f":"'Contact '!C25","v":"(Select Minutes or Hours)"}]
["Salaried Staff",null,{"$f":"'Contact '!B27","v":"(Select Yes or No)"}]
["Per Visit",null,{"$f":"'Contact '!B28","v":"(Select Yes or No)"}]
["Per Hour",null,{"$f":"'Contact '!B29","v":"(Select Yes or No)"}]
["HOURLY ADMIN TAB"]
["1. Administrator / Exec. Director (starting)",null,{"$f":"Admin!B6","v":""}]
["1. Administrator / Exec. Director (current)",null,{"$f":"Admin!C6","v":""}]
["# of branches or locations overseen by Admin/Exec. Dir:",null,{"$f":"Admin!C7","v":""}]
["2. Chief Financial Officer (CFO) (starting)",null,{"$f":"Admin!B8","v":""}]
["2. Chief Financial Officer (CFO) (current)",null,{"$f":"Admin!C8","v":""}]
["3. Director of Nursing (starting)",null,{"$f":"Admin!B9","v":""}]
["3. Director of Nursing (current)",null,{"$f":"Admin!C9","v":""}]
["4. Scheduling Coordinator (starting)",null,{"$f":"Admin!B10","v":""}]
["4. Scheduling Coordinator (current)",null,{"$f":"Admin!C10","v":""}]
["5. Business / Office Manager (starting)",null,{"$f":"Admin!B11","v":""}]
["5. Business / Office Manager (current)",null,{"$f":"Admin!C11","v":""}]
["6. Director, Business Development (starting)",null,{"$f":"Admin!B12","v":""}]
["6. Director, Business Development (current)",null,{"$f":"Admin!C12","v":""}]
["7. Administrative Assistant (starting)",null,{"$f":"Admin!B13","v":""}]
["7. Administrative Assistant (current)",null,{"$f":"Admin!C13","v":""}]
["1. Accountant/Bookkeeper (starting)",null,{"$f":"Admin!B17","v":""}]
["1. Accountant/Bookkeeper (current)",null,{"$f":"Admin!C17","v":""}]
["2. Billing Clerk (starting)",null,{"$f":"Admin!B18","v":""}]
["2. Billing Clerk (current)",null,{"$f":"Admin!C18","v":""}]
["3. Clerical/Secretarial/Filing (starting)",null,{"$f":"Admin!B19","v":""}]
["3. Clerical/Secretarial/Filing (current)",null,{"$f":"Admin!C19","v":""}]
["4. Intake / Home Care Coordinator (starting)",null,{"$f":"Admin!B20","v":""}]
["4. Intake / Home Care Coordinator (current)",null,{"$f":"Admin!C20","v":""}]
["5. Nursing Supervisor (starting)",null,{"$f":"Admin!B21","v":""}]
["5. Nursing Supervisor (current)",null,{"$f":"Admin!C21","v":""}]
["6. Personnel Manager (starting)",null,{"$f":"Admin!B22","v":""}]
["6. Personnel Manager (current)",null,{"$f":"Admin!C22","v":""}]
["7. Marketing/Facility Liaison (starting)",null,{"$f":"Admin!B23","v":""}]
["7. Marketing/Facility Liaison (current)",null,{"$f":"Admin!C23","v":""}]
["7a.Quota for marketing staff's base pay",null,{"$f":"Admin!B24","v":""}]
["7b.Potential additional compensation for marketing staff. This may be % of base salary. ",null,{"$f":"Admin!B25","v":""}]
["DIFFERENTIALS TAB"]
["Paid to Field Staff (Travel Reimbursement Amount)",null,{"$f":"Differentials!B10","v":""}]
["Paid to Field Staff (Travel Reimbursement Per)",null,{"$f":"Differentials!C10","v":"(select from list)"}]
["Holiday (Nursing Field Staff Differential Amount)",null,{"$f":"Differentials!B12","v":""}]
["Holiday (Nursing Field Staff Per)",null,{"$f":"Differentials!C12","v":"(select from list)"}]
["Evening (Nursing Field Staff Differential Amount)",null,{"$f":"Differentials!B13","v":""}]
["Evening (Nursing Field Staff Per)",null,{"$f":"Differentials!C13","v":"(select from list)"}]
["Weekend (Nursing Field Staff Differential Amount)",null,{"$f":"Differentials!B14","v":""}]
["Weekend (Nursing Field Staff Per)",null,{"$f":"Differentials!C14","v":"(select from list)"}]
["Evening (On-Call RNs Differential Amount)",null,{"$f":"Differentials!B16","v":""}]
["Evening (On-Call RNs Per)",null,{"$f":"Differentials!C16","v":"(select from list)"}]
["Weekend (On-Call RNs Differential Amount)",null,{"$f":"Differentials!B17","v":""}]
["Weekend (On-Call RNs Per)",null,{"$f":"Differentials!C17","v":"(select from list)"}]
["Week (On-Call RNs Differential Amount)",null,{"$f":"Differentials!B18","v":""}]
["Week (On-Call RNs Per)",null,{"$f":"Differentials!C18","v":"(select from list)"}]
["Evening (On-Call LPNs Differential Amount)",null,{"$f":"Differentials!B20","v":""}]
["Evening (On-Call LPNs Per)",null,{"$f":"Differentials!C20","v":"(select from list)"}]
["Weekend (On-Call LPNs Differential Amount)",null,{"$f":"Differentials!B21","v":""}]
["Weekend (On-Call LPNs Per)",null,{"$f":"Differentials!C21","v":"(select from list)"}]
["Week (On-Call LPNs Differential Amount)",null,{"$f":"Differentials!B22","v":""}]
["Week (On-Call LPNs Per)",null,{"$f":"Differentials!C22","v":"(select from list)"}]
["Holiday (Physical Therapists Differential Amount)",null,{"$f":"Differentials!B24","v":""}]
["Holiday (Physical Therapists Per)",null,{"$f":"Differentials!C24","v":"(select from list)"}]
["Evening (Physical Therapists Differential Amount)",null,{"$f":"Differentials!B25","v":""}]
["Evening (Physical Therapists Per)",null,{"$f":"Differentials!C25","v":"(select from list)"}]
["Weekend (Physical Therapists Differential Amount)",null,{"$f":"Differentials!B26","v":""}]
["Weekend (Physical Therapists Per)",null,{"$f":"Differentials!C26","v":"(select from list)"}]
["Holiday (Physical Therapist Assistants Differential Amount)",null,{"$f":"Differentials!B28","v":""}]
["Holiday (Physical Therapist Assistants Per)",null,{"$f":"Differentials!C28","v":"(select from list)"}]
["Evening (Physical Therapist Assistants Differential Amount)",null,{"$f":"Differentials!B29","v":""}]
["Evening (Physical Therapist Assistants Per)",null,{"$f":"Differentials!C29","v":"(select from list)"}]
["Weekend (Physical Therapist Assistants Differential Amount)",null,{"$f":"Differentials!B30","v":""}]
["Weekend (Physical Therapist Assistants Per)",null,{"$f":"Differentials!C30","v":"(select from list)"}]
["Holiday (Home Health Aides Differential Amount)",null,{"$f":"Differentials!B32","v":""}]
["Holiday (Home Health Aides Per)",null,{"$f":"Differentials!C32","v":"(select from list)"}]
["Evening (Home Health Aides Differential Amount)",null,{"$f":"Differentials!B33","v":""}]
["Evening (Home Health Aides Per)",null,{"$f":"Differentials!C33","v":"(select from list)"}]
["Weekend (Home Health Aides Differential Amount)",null,{"$f":"Differentials!B34","v":""}]
["Weekend (Home Health Aides Per)",null,{"$f":"Differentials!C34","v":"(select from list)"}]
["Holiday (Homemaker/Companion Differential Amount)",null,{"$f":"Differentials!B36","v":""}]
["Holiday (Homemaker/Companion Per)",null,{"$f":"Differentials!C36","v":"(select from list)"}]
["Evening (Homemaker/Companion Differential Amount)",null,{"$f":"Differentials!B37","v":""}]
["Evening (Homemaker/Companion Per)",null,{"$f":"Differentials!C37","v":"(select from list)"}]
["Weekend (Homemaker/Companion Differential Amount)",null,{"$f":"Differentials!B38","v":""}]
["Weekend (Homemaker/Companion Per)",null,{"$f":"Differentials!C38","v":"(select from list)"}]
["Holiday (Nursing Field Staff Differential Percentage)",null,{"$f":"Differentials!D12","v":""}]
["Holiday (Nursing Field Staff Per)",null,{"$f":"Differentials!E12","v":"(select from list)"}]
["Evening (Nursing Field Staff Differential Percentage)",null,{"$f":"Differentials!D13","v":""}]
["Evening (Nursing Field Staff Per)",null,{"$f":"Differentials!E13","v":"(select from list)"}]
["Weekend (Nursing Field Staff Differential Percentage)",null,{"$f":"Differentials!D14","v":""}]
["Weekend (Nursing Field Staff Per)",null,{"$f":"Differentials!E14","v":"(select from list)"}]
["Evening (On-Call RNs Differential Percentage)",null,{"$f":"Differentials!D16","v":""}]
["Evening (On-Call RNs Per)",null,{"$f":"Differentials!E16","v":"(select from list)"}]
["Weekend (On-Call RNs Differential Percentage)",null,{"$f":"Differentials!D17","v":""}]
["Weekend (On-Call RNs Per)",null,{"$f":"Differentials!E17","v":"(select from list)"}]
["Week (On-Call RNs Differential Percentage)",null,{"$f":"Differentials!D18","v":""}]
["Week (On-Call RNs Per)",null,{"$f":"Differentials!E18","v":"(select from list)"}]
["Evening (On-Call LPNs Differential Percentage)",null,{"$f":"Differentials!D20","v":""}]
["Evening (On-Call LPNs Per)",null,{"$f":"Differentials!E20","v":"(select from list)"}]
["Weekend (On-Call LPNs Differential Percentage)",null,{"$f":"Differentials!D21","v":""}]
["Weekend (On-Call LPNs Per)",null,{"$f":"Differentials!E21","v":"(select from list)"}]
["Week (On-Call LPNs Differential Percentage)",null,{"$f":"Differentials!D22","v":""}]
["Week (On-Call LPNs Per)",null,{"$f":"Differentials!E22","v":"(select from list)"}]
["Holiday (Physical Therapists Differential Percentage)",null,{"$f":"Differentials!D24","v":""}]
["Holiday (Physical Therapists Per)",null,{"$f":"Differentials!E24","v":"(select from list)"}]
["Evening (Physical Therapists Differential Percentage)",null,{"$f":"Differentials!D25","v":""}]
["Evening (Physical Therapists Per)",null,{"$f":"Differentials!E25","v":"(select from list)"}]
["Weekend (Physical Therapists Differential Percentage)",null,{"$f":"Differentials!D26","v":""}]
["Weekend (Physical Therapists Per)",null,{"$f":"Differentials!E26","v":"(select from list)"}]
["Holiday (Physical Therapist Assistants Differential Percentage)",null,{"$f":"Differentials!D28","v":""}]
["Holiday (Physical Therapist Assistants Per)",null,{"$f":"Differentials!E28","v":"(select from list)"}]
["Evening (Physical Therapist Assistants Differential Percentage)",null,{"$f":"Differentials!D29","v":""}]
["Evening (Physical Therapist Assistants Per)",null,{"$f":"Differentials!E29","v":"(select from list)"}]
["Weekend (Physical Therapist Assistants Differential Percentage)",null,{"$f":"Differentials!D30","v":""}]
["Weekend (Physical Therapist Assistants Per)",null,{"$f":"Differentials!E30","v":"(select from list)"}]
["Holiday (Home Health Aides Differential Percentage)",null,{"$f":"Differentials!D32","v":""}]
["Holiday (Home Health Aides Per)",null,{"$f":"Differentials!E32","v":"(select from list)"}]
["Evening (Home Health Aides Differential Percentage)",null,{"$f":"Differentials!D33","v":""}]
["Evening (Home Health Aides Per)",null,{"$f":"Differentials!E33","v":"(select from list)"}]
["Weekend (Home Health Aides Differential Percentage)",null,{"$f":"Differentials!D34","v":""}]
["Weekend (Home Health Aides Per)",null,{"$f":"Differentials!E34","v":"(select from list)"}]
["Holiday (Homemaker/Companion Differential Percentage)",null,{"$f":"Differentials!D36","v":""}]
["Holiday (Homemaker/Companion Per)",null,{"$f":"Differentials!E36","v":"(select from list)"}]
["Evening (Homemaker/Companion Differential Percentage)",null,{"$f":"Differentials!D37","v":""}]
["Evening (Homemaker/Companion Per)",null,{"$f":"Differentials!E37","v":"(select from list)"}]
["Weekend (Homemaker/Companion Differential Percentage)",null,{"$f":"Differentials!D38","v":""}]
["Weekend (Homemaker/Companion Per)",null,{"$f":"Differentials!E38","v":"(select from list)"}]
["CLINICAL TAB"]
["1. Registered Nurse (starting)",null,{"$f":"Clinical!B4","v":""}]
["1. Registered Nurse (current)",null,{"$f":"Clinical!C4","v":""}]
["2. Licensed Practical Nurse (starting)",null,{"$f":"Clinical!B5","v":""}]
["2. Licensed Practical Nurse (current)",null,{"$f":"Clinical!C5","v":""}]
["3. Case Manager (starting)",null,{"$f":"Clinical!B6","v":""}]
["3. Case Manager (current)",null,{"$f":"Clinical!C6","v":""}]
["4. Home Health Aide (receives benefits) (starting)",null,{"$f":"Clinical!B7","v":""}]
["4. Home Health Aide (receives benefits) (current)",null,{"$f":"Clinical!C7","v":""}]
["5. Home Health Aide (does not receive benefits) (starting)",null,{"$f":"Clinical!B8","v":""}]
["5. Home Health Aide (does not receive benefits) (current)",null,{"$f":"Clinical!C8","v":""}]
["6. Physical Therapist (PT) (starting)",null,{"$f":"Clinical!B9","v":""}]
["6. Physical Therapist (PT) (current)",null,{"$f":"Clinical!C9","v":""}]
["7. PT Assistant (starting)",null,{"$f":"Clinical!B10","v":""}]
["7. PT Assistant (current)",null,{"$f":"Clinical!C10","v":""}]
["8. Homemaker/Companion (starting)",null,{"$f":"Clinical!B11","v":""}]
["8. Homemaker/Companion (current)",null,{"$f":"Clinical!C11","v":""}]
["1. Starting PER VISIT RATE (Registered Nurse)",null,{"$f":"Clinical!D4","v":""}]
["1. Current PER VISIT RATE (Registered Nurse)",null,{"$f":"Clinical!E4","v":""}]
["1. High-Risk/Tech Visit (Registered Nurse)",null,{"$f":"Clinical!F4","v":""}]
["2. Starting PER VISIT RATE (Licensed Practical Nurse)",null,{"$f":"Clinical!D5","v":""}]
["2. Current PER VISIT RATE (Licensed Practical Nurse)",null,{"$f":"Clinical!E5","v":""}]
["2. High-Risk/Tech Visit (Licensed Practical Nurse)",null,{"$f":"Clinical!F5","v":""}]
["4. Starting PER VISIT RATE (Home Health Aide - receives benefits)",null,{"$f":"Clinical!D7","v":""}]
["4. Current Rate (Home Health Aide - receives benefits)",null,{"$f":"Clinical!E7","v":""}]
["5. Starting PER VISIT RATE (Home Health Aide - does not receive benefits)",null,{"$f":"Clinical!D8","v":""}]
["5. Current Rate (Home Health Aide - does not receive benefits)",null,{"$f":"Clinical!E8","v":""}]
["6. Starting PER VISIT RATE (Physical Therapist)",null,{"$f":"Clinical!D9","v":""}]
["6. Current Rate (Physical Therapist)",null,{"$f":"Clinical!E9","v":""}]
["7. Starting PER VISIT RATE (Physical Therapist Assistant)",null,{"$f":"Clinical!D10","v":""}]
["7. Current Rate (Physical Therapist Assistant)",null,{"$f":"Clinical!E10","v":""}]
["1a. Sign-Up Admission Rate (RN)",null,{"$f":"Clinical!D14","v":""}]
["1a. Evaluation Rate (RN)",null,{"$f":"Clinical!E14","v":""}]
["9. Live-In Aide, how do you structure compensation and how much do you pay? ",null,{"$f":"Clinical!B16","v":""}]
["1. Per Diem Starting EE RN",null,{"$f":"Clinical!G4","v":""}]
["1. Per Diem Current EE RN",null,{"$f":"Clinical!H4","v":""}]
["2. Per Diem Starting EE LPN",null,{"$f":"Clinical!G5","v":""}]
["2. Per Diem Current EE LPN",null,{"$f":"Clinical!H5","v":""}]
["6. Per Diem Starting EE PT",null,{"$f":"Clinical!G9","v":""}]
["6. Per Diem Current EE PT",null,{"$f":"Clinical!H9","v":""}]
["7. Per Diem Starting EE PTA",null,{"$f":"Clinical!G10","v":""}]
["7. Per Diem Current EE PTA",null,{"$f":"Clinical!H10","v":""}]
["1. Per Diem Starting 1099 RN",null,{"$f":"Clinical!I4","v":""}]
["1. Per Diem Current 1099 RN",null,{"$f":"Clinical!J4","v":""}]
["2. Per Diem Starting 1099 LPN",null,{"$f":"Clinical!I5","v":""}]
["2. Per Diem Current 1099 LPN",null,{"$f":"Clinical!J5","v":""}]
["4. Per Diem Starting 1099 HHAide (receives benefits)",null,{"$f":"Clinical!I7","v":""}]
["4. Per Diem Current 1099 HHAide (receives benefits)",null,{"$f":"Clinical!J7","v":""}]
["5. Per Diem Starting 1099 HHAide (does not receive benefits)",null,{"$f":"Clinical!I8","v":""}]
["5. Per Diem Current 1099 HHAide (does not receive benefits)",null,{"$f":"Clinical!J8","v":""}]
["6. Per Diem Starting 1099 PT",null,{"$f":"Clinical!I9","v":""}]
["6. Per Diem Current 1099 PT",null,{"$f":"Clinical!J9","v":""}]
["7. Per Diem Starting 1099 PTA",null,{"$f":"Clinical!I10","v":""}]
["7. Per Diem Current 1099 PTA",null,{"$f":"Clinical!J10","v":""}]
["8. Per Diem Starting 1099 Homemaker/Companion",null,{"$f":"Clinical!I11","v":""}]
["8. Per Diem Current 1099 Homemaker/Companion",null,{"$f":"Clinical!J11","v":""}]
["BENEFITS TAB"]
["Office Staff",null,{"$f":"Benefits!B2","v":"(select from list)"}]
["30+ Hours per week Clinical Staff",null,{"$f":"Benefits!B3","v":"(select from list)"}]
["Full Time Clinical Staff",null,{"$f":"Benefits!B4","v":"(select from list)"}]
["Health/Medical",null,{"$f":"Benefits!B6","v":"(Select Yes or No)"}]
["Dental",null,{"$f":"Benefits!B7","v":"(Select Yes or No)"}]
["Life",null,{"$f":"Benefits!B8","v":"(Select Yes or No)"}]
["Vision",null,{"$f":"Benefits!B9","v":"(Select Yes or No)"}]
["Automobile",null,{"$f":"Benefits!B10","v":"(Select Yes or No)"}]
["Personal Liability",null,{"$f":"Benefits!B11","v":"(Select Yes or No)"}]
["Short Term Disability",null,{"$f":"Benefits!B12","v":"(Select Yes or No)"}]
["Long Term Disability",null,{"$f":"Benefits!B13","v":"(Select Yes or No)"}]
["Supplemental ",null,{"$f":"Benefits!B14","v":"(Select Yes or No)"}]
["Other Insurance:",null,{"$f":"Benefits!B15","v":""}]
["Cell/Mobile Phone",null,{"$f":"Benefits!B17","v":"(Select Yes or No)"}]
["Laptop/PDA/Tablet",null,{"$f":"Benefits!B18","v":"(Select Yes or No)"}]
["Phys Portal for eSignatures",null,{"$f":"Benefits!B19","v":"(Select Yes or No)"}]
["Do you offer merit increases?",null,{"$f":"Benefits!B21","v":"(Select Yes or No)"}]
["What was your recent average MERIT PAY increase %?",null,{"$f":"Benefits!B23","v":""}]
["Performance",null,{"$f":"Benefits!B25","v":"(Select Yes or No)"}]
["Productivity",null,{"$f":"Benefits!B26","v":"(Select Yes or No)"}]
["Budget/Available Funds",null,{"$f":"Benefits!B27","v":"(Select Yes or No)"}]
["Other Merit:",null,{"$f":"Benefits!B28","v":""}]
["Do you give an annual COLA?",null,{"$f":"Benefits!B30","v":"(Select Yes or No)"}]
["If yes, what was your COLA % increase last year?",null,{"$f":"Benefits!B32","v":""}]
["Do you offer bonuses?",null,{"$f":"Benefits!B34","v":"(Select Yes or No)"}]
["Performance",null,{"$f":"Benefits!B36","v":"(Select Yes or No)"}]
["Productivity",null,{"$f":"Benefits!B37","v":"(Select Yes or No)"}]
["Budget/Available Funds",null,{"$f":"Benefits!B38","v":"(Select Yes or No)"}]
["Other Bonus:",null,{"$f":"Benefits!B39","v":""}]
["Do you offer retirement plans?",null,{"$f":"Benefits!B42","v":"(Select Yes or No)"}]
["401K",null,{"$f":"Benefits!B44","v":"(Select Yes or No)"}]
["403-B",null,{"$f":"Benefits!B45","v":"(Select Yes or No)"}]
["SEP",null,{"$f":"Benefits!B46","v":"(Select Yes or No)"}]
["Pension",null,{"$f":"Benefits!B47","v":"(Select Yes or No)"}]
["Other",null,{"$f":"Benefits!B48","v":""}]
["RECRUITMENT TAB"]
["Do you offer $ incentives to current staff to find new employees?",null,{"$f":"Recruitment!D2","v":"(Select Yes or No)"}]
["Nurse Positions (Amount)",null,{"$f":"Recruitment!B5","v":""}]
["On Hire:",null,{"$f":"Recruitment!B6","v":"(Select Yes or No)"}]
["After 30 Days:",null,{"$f":"Recruitment!B7","v":"(Select Yes or No)"}]
["After 60 Days:",null,{"$f":"Recruitment!B8","v":"(Select Yes or No)"}]
["After 90 Days: ",null,{"$f":"Recruitment!D6","v":"(Select Yes or No)"}]
["After 6 months:",null,{"$f":"Recruitment!D7","v":"(Select Yes or No)"}]
["After 1 Year:",null,{"$f":"Recruitment!D8","v":"(Select Yes or No)"}]
["Therapist Positions (Amount)",null,{"$f":"Recruitment!B10","v":""}]
["On Hire:",null,{"$f":"Recruitment!B11","v":"(Select Yes or No)"}]
["After 30 Days:",null,{"$f":"Recruitment!B12","v":"(Select Yes or No)"}]
["After 60 Days:",null,{"$f":"Recruitment!B13","v":"(Select Yes or No)"}]
["After 90 Days: ",null,{"$f":"Recruitment!D11","v":"(Select Yes or No)"}]
["After 6 months:",null,{"$f":"Recruitment!D12","v":"(Select Yes or No)"}]
["After 1 Year:",null,{"$f":"Recruitment!D13","v":"(Select Yes or No)"}]
["HHA/CNA Positions (Amount)",null,{"$f":"Recruitment!B15","v":""}]
["On Hire:",null,{"$f":"Recruitment!B16","v":"(Select Yes or No)"}]
["After 30 Days:",null,{"$f":"Recruitment!B17","v":"(Select Yes or No)"}]
["After 60 Days:",null,{"$f":"Recruitment!B18","v":"(Select Yes or No)"}]
["After 90 Days: ",null,{"$f":"Recruitment!D16","v":"(Select Yes or No)"}]
["After 6 months:",null,{"$f":"Recruitment!D17","v":"(Select Yes or No)"}]
["After 1 Year:",null,{"$f":"Recruitment!D18","v":"(Select Yes or No)"}]
["Do you offer $$ sign-on bonuses to newly hired employees?  ",null,{"$f":"Recruitment!D21","v":"(Select Yes or No)"}]
["Sign-on Amount (Nurses)",null,{"$f":"Recruitment!B24","v":""}]
["Sign-on Amount (Therapists)",null,{"$f":"Recruitment!B25","v":""}]
["Sign-on Amount (HHAs/CNAs)",null,{"$f":"Recruitment!B26","v":""}]
["TIME OFF TAB"]
["What kind of system do you have?",null,{"$f":"'Time Off'!D2","v":"(select from list)"}]
["Who is eligible for time off?",null,{"$f":"'Time Off'!D3","v":"(select from list)"}]
["If PTO system, do you also offer paid holidays in addition to PTO?",null,{"$f":"'Time Off'!D4","v":"(select from list)"}]
["New Year's Day",null,{"$f":"'Time Off'!B6","v":"(Select Yes or No)"}]
["MLK Jr Day",null,{"$f":"'Time Off'!B7","v":"(Select Yes or No)"}]
["Memorial Day",null,{"$f":"'Time Off'!B8","v":"(Select Yes or No)"}]
["Independence Day",null,{"$f":"'Time Off'!B9","v":"(Select Yes or No)"}]
["Labor Day",null,{"$f":"'Time Off'!D6","v":"(Select Yes or No)"}]
["Veteran's Day",null,{"$f":"'Time Off'!D7","v":"(Select Yes or No)"}]
["Thanksgiving",null,{"$f":"'Time Off'!D8","v":"(Select Yes or No)"}]
["Christmas",null,{"$f":"'Time Off'!D9","v":"(Select Yes or No)"}]
["Other Holidays",null,{"$f":"'Time Off'!B10","v":""}]
["# of Personal Days",null,{"$f":"'Time Off'!B11","v":""}]
["Upon hire (Vacation Days)",null,{"$f":"'Time Off'!B15","v":""}]
["Upon hire (Sick Days)",null,{"$f":"'Time Off'!C15","v":""}]
["Upon hire (PTO hours)",null,{"$f":"'Time Off'!D15","v":""}]
["After 30 days (Vacation Days)",null,{"$f":"'Time Off'!B16","v":""}]
["After 30 days (Sick Days)",null,{"$f":"'Time Off'!C16","v":""}]
["After 30 days (PTO hours)",null,{"$f":"'Time Off'!D16","v":""}]
["After 90 days (Vacation Days)",null,{"$f":"'Time Off'!B17","v":""}]
["After 90 days (Sick Days)",null,{"$f":"'Time Off'!C17","v":""}]
["After 90 days (PTO hours)",null,{"$f":"'Time Off'!D17","v":""}]
["After 6 months (Vacation Days)",null,{"$f":"'Time Off'!B18","v":""}]
["After 6 months (Sick Days)",null,{"$f":"'Time Off'!C18","v":""}]
["After 6 months (PTO hours)",null,{"$f":"'Time Off'!D18","v":""}]
["Afer 1 year (Vacation Days)",null,{"$f":"'Time Off'!B16","v":""}]
["Afer 1 year (Sick Days)",null,{"$f":"'Time Off'!C19","v":""}]
["After 1 year (PTO hours)",null,{"$f":"'Time Off'!D19","v":""}]
["After 2 years (Vacation Days)",null,{"$f":"'Time Off'!B20","v":""}]
["After 2 years (Sick Days)",null,{"$f":"'Time Off'!C20","v":""}]
["After 2 years (PTO hours)",null,{"$f":"'Time Off'!D20","v":""}]
["After 3 years (Vacation Days)",null,{"$f":"'Time Off'!B21","v":""}]
["After 3 years (Sick Days)",null,{"$f":"'Time Off'!C21","v":""}]
["After 3 years (PTO hours)",null,{"$f":"'Time Off'!D21","v":""}]
["After 4 years (Vacation Days)",null,{"$f":"'Time Off'!B22","v":""}]
["After 4 years (Sick Days)",null,{"$f":"'Time Off'!C22","v":""}]
["After 4 years (PTO hours)",null,{"$f":"'Time Off'!D22","v":""}]
["After 5 years (Vacation Days)",null,{"$f":"'Time Off'!B23","v":""}]
["After 5 years (Sick Days)",null,{"$f":"'Time Off'!C23","v":""}]
["After 5 years (PTO hours)",null,{"$f":"'Time Off'!D23","v":""}]
["After 6 years (Vacation Days)",null,{"$f":"'Time Off'!B24","v":""}]
["After 6 years (Sick Days)",null,{"$f":"'Time Off'!C24","v":""}]
["After 6 years (PTO hours)",null,{"$f":"'Time Off'!D24","v":""}]
["After 10 years (Vacation Days)",null,{"$f":"'Time Off'!B25","v":""}]
["After 10 years (Sick Days)",null,{"$f":"'Time Off'!C25","v":""}]
["After 10 years (PTO hours)",null,{"$f":"'Time Off'!D25","v":""}]
["After 15 years (Vacation Days)",null,{"$f":"'Time Off'!B26","v":""}]
["After 15 years (Sick Days)",null,{"$f":"'Time Off'!C26","v":""}]
["After 15 years (PTO hours)",null,{"$f":"'Time Off'!D26","v":""}]
["After 20 years (Vacation Days)",null,{"$f":"'Time Off'!B27","v":""}]
["After 20 years (Sick Days)",null,{"$f":"'Time Off'!C27","v":""}]
["After 20 years (PTO hours)",null,{"$f":"'Time Off'!D27","v":""}]
["Cap vacation days",null,{"$f":"'Time Off'!B30","v":""}]
["Cap sick days",null,{"$f":"'Time Off'!C30","v":""}]
["Cap PTO hours",null,{"$f":"'Time Off'!D30","v":""}]
["Carry max vacation days",null,{"$f":"'Time Off'!B32","v":""}]
["Carry max sick days",null,{"$f":"'Time Off'!C32","v":""}]
["Carry May PTO hours",null,{"$f":"'Time Off'!D32","v":""}]