{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":[" Instructions WEG App","Wage Enhancement Application","WEG Expansion Application"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":2,"comments":0,"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":" Instructions WEG App","index":0,"n_rows":294,"n_cols":7,"rows_kept":294,"cut":false,"hidden":false,"merged":[]}
["Provincial Wage Enhancement Application Instructions - Child Care Centre & Home Visitors (2018)"]
[]
["The purpose of these instructions is to support operators in completing their wage enhancement application. "]
["If you have any questions related to your application please contact Pam Kent by calling 613-354-0957 ext. 2401,"]
["or by emailing pkent@lennox-addington.on.ca.   "]
[]
["Wage enhancement applications must be submitted no later than March 16, 2018, "]
["in order to be considered for wage enhancement funds. Late applications will not be accepted."]
[]
["You are only required to enter data in the green cells.  All other calculations will be performed automatically."]
[]
["The application form contains 100 rows to allow you to enter data for all eligible positions.  At step 8, you will be"]
["provided with instructions on how to only show the rows where data has been entered for printing purposes."]
[]
["Please note that definitions/explanations have been included for certain fields to help you complete this form.  You can "]
["activate these definitions/explanations by clicking on the cell.  You can also move these cells to a different location"]
["on the application form if its placement makes it difficult for you to see other information on the application form."]
[]
["STEP 1:  DETERMINE ELIGIBILITY"]
["In order to successfully complete your wage enhancement application you must determine which of the positions as of December 31, 2017"]
["in your licensed child care centre / agency are eligible for the enhancement to generate your 2018 funding entitlement.            "]
["                         "]
["Full Wage Enhancement"]
["To be eligible to receive the full 2018 wage enhancement of $2 an hour plus 17.5 per cent in benefits, staff must:"]
["·   Be employed in a licensed child care centre or agency;"]
["·   Have an associated base wage excluding prior year’s wage enhancement of less than $25.07 per hour"]
["     (i.e. $2 below the wage cap of $27.07); and"]
["·    Be in a position categorized as a child care supervisor, RECE, home child care visitor, or otherwise counted toward adult to child "]
["ratios under the Child Care Early Years Act (CCEYA)."]
["Child care program positions that are in place to maintain lower adult-child ratios than required under the CCEYA, "]
[" and meet the eligibility outlined above, are also eligible for wage enhancement."]
[]
["Partial Wage Enhancement"]
["Where an eligible centre-based or home visitor position has an associated base wage rate excluding prior year’s wage enhancement"]
["between $25.08 and $27.07 per hour, the position is eligible for a partial wage enhancement. The partial wage enhancement will increase"]
[" the wage of the qualifying position to $27.07 per hour without exceeding the cap."]
["·         For example, if an RECE position has a base wage rate, excluding the previous year’s wage enhancement, of $25.50 per hour, the"]
[" position would be eligible for wage enhancement of $1.57 per hour."]
[]
["Now that you have determined which of the positions in your licensed child care centre / agency qualified for the wage "]
["enhancement in 2018 you can begin completing the form."]
[]
["STEP 2:  ENTER CENTRE / AGENCY INFORMATION"]
["Open the wage enhancement application form in excel and complete the centre / agency information shown below as "]
["well as the contact person who is able to answer questions about the application form being submitted."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["STEP 3: CHILD CARE CENTRE / AGENCY OPERATING INFORMATION"]
["Please provide the number of weeks your centre was open during 2017. Next, proceed to entering the standard work"]
["week for centre staff in 2017, total operating capacity and total licensed capacity. For Home Child Care"]
["Agencies, the operating capacity and licensed capacity fields should remain blank."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["STEP 4: CHILD CARE CENTRE / AGENCY OPERATING INFORMATION"]
["Please indicate the number of ineligible RECEs, Non-RECEs, Supervisors, and home visitors, i.e. hourly rate exceeds $27.07."]
["The actual number of staff ineligible (not FTE's)"]
[]
[]
[]
[]
[]
[]
[]
[]
["STEP 5:  MANADATORY BENEFITS"]
[]
["Next proceed to entering the mandatory benefits provided to the employees.  The Ministry of Education is funding"]
["17.5% for mandatory benefits.  There are six benefit categories as noted below:"]
["1)  CPP (Canada Pension Plan), funded at 4.95% for employer contribution"]
["2)  EI (Employment Insurance), funded at 2.63% for employer contribution, which is 1.4 times the employee contribution"]
["3)  WSIB (Workers Safety & Insurance Board), funded at 1.10%.  WSIB is optional for certain employers."]
["4)  EHT (Employer Health Tax), funded at 1.23%.  Certain employers are exempt.  Where they are not, the following "]
["ranges exist based on total remuneration:"]
[null,"Total Remuneration",null,null,null,null,"Rate"]
[null,"Up to $200,000.00",null,null,null,null,9.7999999999999997E-3]
[null,"$200,000.01 to $230,000.00",null,null,null,null,1.1010000000000001E-2]
[null,"$230,000.01 to $260,000.00",null,null,null,null,1.223E-2]
[null,"$260,000.01 to $290,000.00",null,null,null,null,1.3440000000000001E-2]
[null,"$290,000.01 to $320,000.00",null,null,null,null,1.465E-2]
[null,"$320,000.01 to $350,000.00",null,null,null,null,1.5859999999999999E-2]
[null,"$350,000.01 to $380,000.00",null,null,null,null,1.7080000000000001E-2]
[null,"$380,000.01 to $400,000.00",null,null,null,null,1.8290000000000001E-2]
[null,"Over $400,000.00",null,null,null,null,1.95E-2]
["5)  Vacation Pay, funded at 4% of gross pay per the Employment Standards Act."]
["6)  Public Holiday Pay, funded at 3.59%, representing the following 9 days:  New Year's Day, Family Day, Good Friday,"]
["Victoria Day, Canada Day, Labour Day, Thanks Giving, Christmas and Boxing Day."]
[]
["The illustrated sample below shows the mandatory benefits of a child care centre / agency that does not pay WSIB, is at "]
["the top end of the EHT scale and has a higher public holiday pay rate.  As the total is equal to 17.51%, this centre would "]
["be entitled to receive the maximum benefit rate of 17.50% ONLY."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["STEP 6:  EMPLOYEE INFORMATION"]
["Enter the following information for the eligible positions in the licensed child care centre or eligible home child care "]
["visitors working in a licensed agency:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Position Description"]
["This field should contain sufficient information to allow you to provide additional information to the CMSM/DSSAB"]
["should it be requested"]
["New Position Created during Jan 1 - Dec 31, 2017 (select Yes or No)"]
["If a new position has been created due to the expansion of a program during the year, then please provide an estimate"]
["for the equivalent # of hours that the position would work during the Jan 1 - Dec 31, 2017 period."]
["Enter the estimated hours in the # of Hours Worked column (column J). "]
["Please do not select YES if it is a new staff person just if it is a new position."]
[]
["Category"]
["From the drop-down listing, please select from the eligible positions categories of RECE, Non-RECE, Supervisor, or Home Visitor."]
[]
["Hourly Wage "]
["Hourly wage paid to the position as of December 31, 2017 (excluding prior year wage enhancement amounts)."]
["If the position is on an annual salary, take the annual salary and divide it by the standard hours of work per year."]
[]
["# of Hours Worked"]
["This field should include the total number of hours worked in the eligible position between January 1, 2017 and December 31, 2017.  "]
["Overtime hours can be included in the application form."]
["Please note that the operator has two options in terms of reporting the hours worked in an eligible position by both regular and "]
["supply staff in the application form to generate their 2018 funding entitlement."]
["1.    If all hours worked by a supply staff are to replace the regular staff’s hours (sick days, vacations days, etc.), the operator can"]
["report all hours worked by the regular staff including their sick days and vacation days on one line on the application and exclude "]
["the hours worked by the supply staff. This option is suggested to reduce some administrative burden on having to keep"]
["track of the hours worked by all individuals in the same eligible position separately."]
["2.    If operators decided to report the hours worked by a supply staff on a separate line, then the hours worked by the regular staff"]
["during 2017 should include actual hours worked only (i.e. exclude sick days, vacation days, other leaves, etc.). "]
["The 2018 entitlement is then used to make payments to the eligible staff for hours worked in 2018. "]
[]
["% of Time in Eligible Position"]
["If the position covers ratio at all times, please enter 100%. If a position covers ratio for 30% of the time, please report 30%. "]
["Please note that the position must work at least 25% of the day in a position that can be counted toward adult to "]
["child ratio."]
["Supervisors are required under the CCEYA, and are therefore eligible to receive the wage enhancement for 100% of the time they are working "]
["in a licensed child care program, regardless of the amount of time they are working directly with children, provided they earn less than the cap"]
[]
["The following table is an illustration of 5 positions at Child Care Centre ABC and of particular interest position # 3"]
["that works 50% of the time in an eligible position."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Once you’ve entered the information above the application template will generate the following information:"]
["• Eligibility status = partial or full, depending on the wage enhancement eligiblity rate ($) per hour"]
["• Eligibility rate = up to $2.00"]
["• Annual Funded FTE = could be higher than 1.0 if the total hours worked from Jan 1st to December 31, 2017 exceeds 1,754.50 hours "]
["• Salary component of the enhancement = up to $2.00 per hour for hours worked, including overtime "]
["• Statutory benefit component of the enhancement = 17.5% of the salary component"]
["• Total compensation = maximum wage enhancement entitlement which is the sum of the salary and benefit component"]
["The following table is an illustration of the wage enhancement funding for the 5 positions applicable to Child Care Centre "]
["Centre ABC. The calculation in the form now automatically gives you the maximum benefit entitlement of 17.5%."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["STEP 6: REVIEW OF APPLICATION FORM"]
[]
[]
["STEP 7: REVIEW OF APPLICATION FORM"]
["Prior to leaving the middle section of the application form, please review the \"Summary\" section.  It contains "]
["a summary of the centre’s / agency's eligible positions and the total funding you are applying for in regards to salaries "]
["and benefits pending approval. This section will also generate the operators' supplemental grant of $150 for each "]
["eligible centre based FTE and home visitor FTE."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["STEP 8: CERTIFICATION"]
["Please complete the certification section stating that the information you have included in the application is accurate by "]
["selecting \"Yes\" in the box and completing your signing authority's information. "]
[]
[]
[]
[]
[]
["STEP 9:  PAGE LAYOUT & PRINTING"]
["Prior to printing or submitting your application form, please go to cell A41 and left click on the symbol to the right of the  "]
["\"Filter\" button.  This gives you the ability to only show the rows that contain information.  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Please ensure that only the \"Show\" option contains a check mark.  You can remove the other checkmark, by left clicking "]
["on the box beside \"hide\"."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["STEP 9: SUBMISSION "]
["Submit the completed electronic Excel file to Pam Kent at pkent@lennox-addington.on.ca no later than March 16, 2018."]
["in order to be considered for wage enhancement funds. Late applications will not be accepted."]
["A signed hard copy must be received by March 31, 2018. "]
[]
["The information that you have provided is subject to review by the CMSM/DSSAB prior to/or after granting the wage "]
["enhancement funding to the centre / agency."]
[]
[]
[]
[]
[]
[]
["New for 2018"]
[]
["NEW centres and agencies that open in 2018 or expand their operating capacity in 2018 will be eligible for WEG, if applied"]
["for by July 3, 2018.  If you are opening a new centre and/or expanding your program in 2018 please include these positions on the WEG  "]
["Expansion Application Form.  You may apply for these postions at the same time as the 2018 WEG application of March 16, 2018, if the "]
["information is known, or you may apply for these positions up until July 3, 2018."]
[]
["Expansion Wage enhancement applications must be submitted no later than July 3, 2018, "]
["in order to be considered for wage enhancement funds. Late applications will not be accepted."]

{"sheet":"Wage Enhancement Application","index":1,"n_rows":188,"n_cols":26,"rows_kept":188,"cut":false,"hidden":false,"merged":[[170,14,170,15],[169,14,169,15],[143,9,143,12],[45,3,45,5],[46,3,46,5],[47,3,47,5],[48,3,48,5],[49,3,49,5],[40,3,40,5],[65,3,65,5],[66,3,66,5],[67,3,67,5],[68,3,68,5],[69,3,69,5],[60,3,60,5],[61,3,61,5],[62,3,62,5],[63,3,63,5],[64,3,64,5],[75,3,75,5],[76,3,76,5],[77,3,77,5],[78,3,78,5],[79,3,79,5],[42,3,42,5],[43,3,43,5],[44,3,44,5],[55,3,55,5],[56,3,56,5],[57,3,57,5],[58,3,58,5],[59,3,59,5],[50,3,50,5],[51,3,51,5],[52,3,52,5],[53,3,53,5],[54,3,54,5],[70,3,70,5],[71,3,71,5],[72,3,72,5],[73,3,73,5],[74,3,74,5],[85,3,85,5],[86,3,86,5],[87,3,87,5],[88,3,88,5],[89,3,89,5],[80,3,80,5],[81,3,81,5],[82,3,82,5],[83,3,83,5],[84,3,84,5],[95,3,95,5],[96,3,96,5],[97,3,97,5],[98,3,98,5],[99,3,99,5],[90,3,90,5],[91,3,91,5],[92,3,92,5],[93,3,93,5],[94,3,94,5],[105,3,105,5],[106,3,106,5],[107,3,107,5],[108,3,108,5],[109,3,109,5],[100,3,100,5],[101,3,101,5],[102,3,102,5],[103,3,103,5],[104,3,104,5],[115,3,115,5],[116,3,116,5],[117,3,117,5],[118,3,118,5],[119,3,119,5],[110,3,110,5],[111,3,111,5],[112,3,112,5],[113,3,113,5],[114,3,114,5],[125,3,125,5],[126,3,126,5],[127,3,127,5],[128,3,128,5],[129,3,129,5],[120,3,120,5],[121,3,121,5],[122,3,122,5],[123,3,123,5],[124,3,124,5],[140,3,140,5],[141,3,141,5],[135,3,135,5],[136,3,136,5],[137,3,137,5],[138,3,138,5],[139,3,139,5],[130,3,130,5],[131,3,131,5],[132,3,132,5],[133,3,133,5],[134,3,134,5],[161,16,162,16],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[16,8,16,9],[17,8,17,9],[18,8,18,9]]}
["V1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"v3"]
[null,null,"Application for Provincial Wage Enhancement Funding - Child Care Centres & Home Visitors (2018)"]
[]
[]
[null,null,null,"CHILD CARE CENTRE / AGENCY INFORMATION"]
[null,null,null,"Child Care Centre / Agency Name:"]
[null,null,null,"Operator Name:"]
[null,null,null,"Licence Number"]
[null,null,null,"Auspice Type:"]
[null,null,null,"Centre / Agency Mailing Address:"]
[]
[]
[]
[]
[]
[null,null,null,"CONTACT INFORMATION"]
[null,null,null,"Name:"]
[null,null,null,"Phone Number:"]
[null,null,null,"Email Address:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"MANDATORY BENEFITS (FUNDED TO A MAX OF 17.5%)"]
[null,null,null,"CHILD CARE CENTRE / AGENCY OPERATING INFORMATION",null,null,null,null,null,null,null,"CPP (4.95%)"]
[null,null,null,"How many weeks was your centre open during 2017",null,null,null,null,null,null,null,"EI (2.63%)"]
[null,null,null,"Standard work week (hours)",null,null,null,null,null,null,null,"WSIB (1.10%, where applicable)"]
[null,null,null,"Total Operating Capacity (N/A for Home Child Care Provider agencies)",null,null,null,null,null,null,null,"EHT (up to 1.95%)"]
[null,null,null,"Total Licensed Capacity (N/A for Home Child Care Provider agencies)",null,null,null,null,null,null,null,"Vacation Pay (4.00%)"]
[null,null,null,null,null,null,null,null,null,null,null,"Public Holiday Pay (3.59%)"]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL",null,null,{"$f":"SUM(O23:O28)","v":0}]
[]
[]
[null,null,null,"SERVICE DATA "]
[null,null,null,"Number of ineligible* RECEs"]
[null,null,null,"Number of ineligible* Non-RECEs"]
[null,null,null,"Number of ineligible* Supervisors"]
[null,null,null,"Number of ineligible* Home Visitors"]
[null,null,null,"*Hourly rate exceeds cap of $27.07."]
[]
[]
[null,null,"EMPLOYEE / POSITION INFORMATION",null,null,null,null,null,null,null,null,"WAGE ENHANCEMENT DETERMINATION"]
[null,null,null,"Position Description",null,null,"New Position created during Jan 1 - Dec 31, 2017? (Y/N) (If Yes,  provide an estimate for the number of hours that the position would work during the year in Column J)","Category","Base Hourly Wage \n(excluding prior year wage enhancement)","# of Hours Worked\n (Jan 1- Dec 31, 2017)","% of Time in Eligible Position","Eligibility Status","Eligibility Rate per Hour ($)","FTE","Salary Component","Statutory Benefit Component (17.5%) ","Total Compensation"]
["Filter"]
[{"$f":"IF(OR(D43<>\"\",H43<>\"\",I43<>\"\",J43<>\"\",K43<>\"\"),\"Show\",\"Hide\")","v":"Hide"},null,1,null,null,null,null,null,null,null,null,{"$f":"IF(I43<>\"\",IF(I43<24.69,\"Full\",IF(I43>26.67,\"None\",\"Partial\")),\"\")","v":""},{"$f":"IF(OR(I43=0,G43=\"\",H43=\"\"),\"\",IF(I43>26.67,0,MIN(2,(26.68-I43))))","v":""},{"$f":"IFERROR(IF(OR(O43=\"\",P43=\"\"),\"\",+(O43)/((1754.5)*M43)), \" \")","v":""},{"$f":"IF(OR(I43=\"\",G43=\"\",H43=\"\"),\"\",J43*M43*K43)","v":""},{"$f":"IFERROR(IF(OR(J43=\"\",M43=\"\"),\"\",O43*0.175),\" \")","v":""},{"$f":"SUM(O43:P43)","v":0},null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(H43,$D$185:$E$188,2,FALSE)),\"\",VLOOKUP(H43,$D$185:$E$188,2,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($L43,$H$185:$I$187,2,FALSE)),\"\",VLOOKUP($L43,$H$185:$I$187,2,FALSE))","v":""},{"$f":"IF(M43<>\"\",VALUE(M43),0)","v":0},{"$f":"IF(N43<>\"\",VALUE(N43),0)","v":0}]
["Hide",null,2,null,null,null,null,null,null,null,null,{"$f":"IF(I44<>\"\",IF(I44<24.69,\"Full\",IF(I44>26.67,\"None\",\"Partial\")),\"\")","v":""},{"$f":"IF(OR(I44=0,G44=\"\",H44=\"\"),\"\",IF(I44>26.67,0,MIN(2,(26.68-I44))))","v":""},{"$f":"IFERROR(IF(OR(O44=\"\",P44=\"\"),\"\",+(O44)/((1754.5)*M44)), \" \")","v":""},{"$f":"IF(OR(I44=\"\",G44=\"\",H44=\"\"),\"\",J44*M44*K44)","v":""},{"$f":"IFERROR(IF(OR(J44=\"\",M44=\"\"),\"\",O44*0.175),\" \")","v":""},0,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(H44,$D$185:$E$188,2,FALSE)),\"\",VLOOKUP(H44,$D$185:$E$188,2,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($L44,$H$185:$V$187,2,FALSE)),\"\",VLOOKUP($L44,$H$185:$V$187,2,FALSE))","v":""},{"$f":"IF(M44<>\"\",VALUE(M44),0)","v":0},0]
["Hide",null,3,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,4,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,5,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,6,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,7,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,8,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,9,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,10,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,11,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,12,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,13,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,14,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,15,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,16,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,17,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,18,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,19,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,20,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,21,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,22,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,23,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,24,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,25,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,26,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,27,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,28,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,29,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,30,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,31,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,32,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,33,null,null,null,null,null,null,null,null,"","","","","",{"$f":"SUM(O75:P75)","v":0},null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(H75,$D$185:$E$188,2,FALSE)),\"\",VLOOKUP(H75,$D$185:$E$188,2,FALSE))","v":""},"",{"$f":"IF(M75<>\"\",VALUE(M75),0)","v":0},{"$f":"IF(N75<>\"\",VALUE(N75),0)","v":0}]
[{"$f":"IF(OR(D76<>\"\",H76<>\"\",I76<>\"\",J76<>\"\",K76<>\"\"),\"Show\",\"Hide\")","v":"Hide"},null,34,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"",{"$f":"IF(ISNA(VLOOKUP($L76,$H$185:$V$187,2,FALSE)),\"\",VLOOKUP($L76,$H$185:$V$187,2,FALSE))","v":""},0,0]
["Hide",null,35,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,36,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,37,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,38,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,39,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,40,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,41,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,42,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,43,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,44,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,45,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,46,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,47,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,48,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,49,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,50,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,51,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,52,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,53,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,54,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,55,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,56,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,57,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,58,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,59,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,60,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,61,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,62,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,63,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,64,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,65,null,null,null,null,null,null,null,null,"","","","","",{"$f":"SUM(O107:P107)","v":0},null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(H107,$D$185:$E$188,2,FALSE)),\"\",VLOOKUP(H107,$D$185:$E$188,2,FALSE))","v":""},"",{"$f":"IF(M107<>\"\",VALUE(M107),0)","v":0},{"$f":"IF(N107<>\"\",VALUE(N107),0)","v":0}]
[{"$f":"IF(OR(D108<>\"\",H108<>\"\",I108<>\"\",J108<>\"\",K108<>\"\"),\"Show\",\"Hide\")","v":"Hide"},null,66,null,null,null,null,null,null,null,null,{"$f":"IF(I108<>\"\",IF(I108<24.69,\"Full\",IF(I108>26.67,\"None\",\"Partial\")),\"\")","v":""},{"$f":"IF(OR(I108=0,G108=\"\",H108=\"\"),\"\",IF(I108>26.67,0,MIN(2,(26.68-I108))))","v":""},{"$f":"IFERROR(IF(OR(O108=\"\",P108=\"\"),\"\",+(O108)/((1754.5)*M108)), \" \")","v":""},{"$f":"IF(OR(I108=\"\",G108=\"\",H108=\"\"),\"\",J108*M108*K108)","v":""},{"$f":"IFERROR(IF(OR(J108=\"\",M108=\"\"),\"\",O108*0.175),\" \")","v":""},0,null,null,null,null,null,"",{"$f":"IF(ISNA(VLOOKUP($L108,$H$185:$V$187,2,FALSE)),\"\",VLOOKUP($L108,$H$185:$V$187,2,FALSE))","v":""},0,0]
["Hide",null,67,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,68,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,69,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,70,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,71,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,72,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,73,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,74,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,75,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,76,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,77,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,78,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,79,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,80,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,81,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,82,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,83,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,84,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,85,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,86,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,87,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,88,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,89,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,90,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,91,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,92,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,93,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,94,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,95,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,96,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,97,null,null,null,null,null,null,null,null,"","","","","",{"$f":"SUM(O139:P139)","v":0},null,null,null,null,null,"","",0,0]
["Hide",null,98,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,99,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,100,null,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
[]
[null,null,null,null,null,null,null,null,null,"SUMMARY",null,null,null,"FTE","Salary Component","Statutory Benefit Component (17.5%) ","Total Compensation"]
[]
[null,null,null,null,null,null,null,null,null,null,null," Fully Eligible Positions","RECE",{"$f":"SUMPRODUCT(($W$43:$W$142=2)*($X$43:$X$142=1),$N$43:$N$142)","v":0},{"$f":"SUMPRODUCT(($W$43:$W$142=2)*($X$43:$X$142=1),$O$43:$O$142)","v":0},{"$f":"SUMPRODUCT(($W$43:$W$142=2)*($X$43:$X$142=1),$P$43:$P$142)","v":0},{"$f":"+P146+O146","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Non-RECE",{"$f":"SUMPRODUCT(($W$43:$W$142=1)*($X$43:$X$142=1),$N$43:$N$142)","v":0},{"$f":"SUMPRODUCT(($W$43:$W$142=1)*($X$43:$X$142=1),$O$43:$O$142)","v":0},{"$f":"SUMPRODUCT(($W$43:$W$142=1)*($X$43:$X$142=1),$P$43:$P$142)","v":0},{"$f":"+P147+O147","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Supervisor",{"$f":"SUMPRODUCT(($W$43:$W$142=4)*($X$43:$X$142=1),$N$43:$N$142)","v":0},{"$f":"SUMPRODUCT(($W$43:$W$142=4)*($X$43:$X$142=1),$O$43:$O$142)","v":0},{"$f":"SUMPRODUCT(($W$43:$W$142=4)*($X$43:$X$142=1),$P$43:$P$142)","v":0},{"$f":"+P148+O148","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Home Visitor",{"$f":"SUMPRODUCT(($W$43:$W$142=3)*($X$43:$X$142=1),$N$43:$N$142)","v":0},{"$f":"SUMPRODUCT(($W$43:$W$142=3)*($X$43:$X$142=1),$O$43:$O$142)","v":0},{"$f":"SUMPRODUCT(($W$43:$W$142=3)*($X$43:$X$142=1),$P$43:$P$142)","v":0},{"$f":"+P149+O149","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"SUB-TOTAL",{"$f":"SUM(N146:N149)","v":0},{"$f":"SUM(O146:O149)","v":0},{"$f":"SUM(P146:P149)","v":0},{"$f":"+P150+O150","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Partially Eligible Positions","RECE",{"$f":"SUMPRODUCT(($W$43:$W$142=2)*($X$43:$X$142=2),$N$43:$N$142)","v":0},{"$f":"SUMPRODUCT(($W$43:$W$142=2)*($X$43:$X$142=2),$O$43:$O$142)","v":0},{"$f":"SUMPRODUCT(($W$43:$W$142=2)*($X$43:$X$142=2),$P$43:$P$142)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Non-RECE",{"$f":"SUMPRODUCT(($W$43:$W$142=1)*($X$43:$X$142=2),$N$43:$N$142)","v":0},{"$f":"SUMPRODUCT(($W$43:$W$142=1)*($X$43:$X$142=2),$O$43:$O$142)","v":0},{"$f":"SUMPRODUCT(($W$43:$W$142=1)*($X$43:$X$142=2),$P$43:$P$142)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Supervisor",{"$f":"SUMPRODUCT(($W$43:$W$142=4)*($X$43:$X$142=2),$N$43:$N$142)","v":0},{"$f":"SUMPRODUCT(($W$43:$W$142=4)*($X$43:$X$142=2),$O$43:$O$142)","v":0},{"$f":"SUMPRODUCT(($W$43:$W$142=4)*($X$43:$X$142=2),$P$43:$P$142)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Home Visitor",{"$f":"SUMPRODUCT(($W$43:$W$142=3)*($X$43:$X$142=2),$N$43:$N$142)","v":0},{"$f":"SUMPRODUCT(($W$43:$W$142=3)*($X$43:$X$142=2),$O$43:$O$142)","v":0},{"$f":"SUMPRODUCT(($W$43:$W$142=3)*($X$43:$X$142=2),$P$43:$P$142)","v":0},{"$f":"+P154+O154","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"SUB-TOTAL",{"$f":"SUM(N151:N154)","v":0},{"$f":"SUM(O151:O154)","v":0},{"$f":"SUM(P151:P154)","v":0},{"$f":"+P155+O155","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL",null,{"$f":"+N155+N150","v":0},{"$f":"+O155+O150","v":0},{"$f":"+P155+P150","v":0},{"$f":"+P156+O156","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"SUPPLEMENTAL GRANT",null,null,null,null,{"$f":"IFERROR(IF(N156=\" \", \" \",N156*150),\" \")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"GRAND TOTAL",null,null,null,null,{"$f":"+Q156+Q157","v":0}]
[]
[]
[null,null,null,"CERTIFICATION",null,null,null,null,null,null,null,null,null,null,null,null,"Please click and select:"]
[null,null,null,"As a signing authority for this organization, I certify that the information included in this application is accurate to the best of my knowledge and represents the "]
[null,null,null,"positions that can be counted toward adult to child ratios under the Child Care and Early Years Act (CCEYA) as of December 31, 2017. "]
[null,null,null,"Name of Signing Authority:"]
[null,null,null,"Title:"]
[null,null,null,"Date:"]
[]
[]
[null,null,"(To be completed by CMSM/DSSAB only)"]
[null,null,null,"APPROVAL",null,null,null,null,null,null,null,"# of FTE","Salary","Benefit","Supplemental Grant",null,"Total"]
[null,null,null,"The child care centre / agency is approved for the following:"]
[]
[]
[null,null,null,null,null,"APPLICATION DEADLINE IS March 16, 2018 - ANY APPLICATIONS RECEIVED AFTER THIS DATE WILL NOT BE ELIGIBLE FOR FUNDING IN 2018"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Non-RECE",1,null,null,"Full",1]
[null,null,null,"RECE",2,null,null,"Partial",2]
[null,null,null,"Home Visitor",3,null,null,"None",3]
[null,null,null,"Supervisor",4]

{"sheet":"WEG Expansion Application","index":2,"n_rows":122,"n_cols":25,"rows_kept":122,"cut":false,"hidden":false,"merged":[[5,7,5,8],[6,7,6,8],[7,7,7,8],[8,7,8,8],[9,7,9,8],[10,7,10,8],[57,3,57,5],[58,3,58,5],[59,3,59,5],[60,3,60,5],[61,3,61,5],[62,3,62,5],[11,7,11,8],[16,7,16,8],[17,7,17,8],[18,7,18,8],[54,3,54,5],[56,3,56,5],[74,3,74,5],[63,3,63,5],[64,3,64,5],[65,3,65,5],[66,3,66,5],[67,3,67,5],[68,3,68,5],[69,3,69,5],[70,3,70,5],[71,3,71,5],[72,3,72,5],[73,3,73,5],[75,3,75,5],[104,13,104,14],[77,8,77,11],[95,15,96,15],[103,13,103,14]]}
["V1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"v3"]
[null,null,"Expansion Application for Provincial Wage Enhancement Funding - Child Care Centres & Home Visitors (2018)"]
[]
[]
[null,null,null,"CHILD CARE CENTRE / AGENCY INFORMATION"]
[null,null,null,"Child Care Centre / Agency Name:"]
[null,null,null,"Operator Name:"]
[null,null,null,"Licence Number"]
[null,null,null,"Auspice Type:"]
[null,null,null,"Centre / Agency Mailing Address:"]
[]
[]
[]
[]
[]
[null,null,null,"CONTACT INFORMATION"]
[null,null,null,"Name:"]
[null,null,null,"Phone Number:"]
[null,null,null,"Email Address:"]
[]
[]
[]
[null,null,null,"EXPANSION INFORMATION"]
[null,null,"Is the expansion application due to a new Centre/Program that opened in 2018?"]
[null,null,"Is the expansion application due to an expansion to an existing Centre/Program in 2018?"]
[]
[]
[]
[null,null,null,"CHILD CARE CENTRE / AGENCY OPERATING INFORMATION"]
[null,null,null,"How many weeks do you expect that your centre will be open during 2018"]
[null,null,null,"Standard work week (hours)"]
[null,null,null,"Total Operating Capacity (N/A for Home Child Care Provider agencies)"]
[null,null,null,"Total Licensed Capacity (N/A for Home Child Care Provider agencies)"]
[]
[]
[]
[null,null,null,"CHILD CARE CENTRE / AGENCY OPERATING INFORMATION"]
[null,null,null,"How many weeks do you expect to be operating at the expanded capacity during 2018"]
[null,null,null,"Standard work week (hours)"]
[null,null,null,"Total Expanded Operating Capacity (N/A for Home Child Care Provider agencies)"]
[null,null,null,"Total Expanded Licensed Capacity (N/A for Home Child Care Provider agencies)"]
[]
[]
[null,null,null,"SERVICE DATA ",null,null,null,null,null,null,"MANDATORY BENEFITS (FUNDED TO A MAX OF 17.5%)"]
[null,null,null,"Number of ineligible* RECEs",null,null,null,null,null,null,"CPP (4.95%)"]
[null,null,null,"Number of ineligible* Non-RECEs",null,null,null,null,null,null,"EI (2.63%)"]
[null,null,null,"Number of ineligible* Supervisors",null,null,null,null,null,null,"WSIB (1.10%, where applicable)"]
[null,null,null,"Number of ineligible* Home Visitors",null,null,null,null,null,null,"EHT (up to 1.95%)"]
[null,null,null,"*Hourly rate exceeds cap of $27.07.",null,null,null,null,null,null,"Vacation Pay (4.00%)"]
[null,null,null,null,null,null,null,null,null,null,"Public Holiday Pay (3.59%)"]
[null,null,null,null,null,null,null,null,null,null,"TOTAL",null,null,{"$f":"SUM(N45:N50)","v":0}]
[]
[]
[null,null,"EMPLOYEE / POSITION INFORMATION",null,null,null,null,null,null,null,"WAGE ENHANCEMENT DETERMINATION"]
[null,null,null,"Position Description",null,null,"Category","Base Hourly Wage \n(excluding prior year wage enhancement)","# of Hours Estimated to be worked\n (Jan 1- Dec 31, 2018)","% of Time in Eligible Position","Eligibility Status","Eligibility Rate per Hour ($)","FTE","Salary Component","Statutory Benefit Component (17.5%) ","Total Compensation"]
["Filter"]
[{"$f":"IF(OR(D57<>\"\",G57<>\"\",H57<>\"\",I57<>\"\",J57<>\"\"),\"Show\",\"Hide\")","v":"Hide"},null,1,null,null,null,null,null,null,null,{"$f":"IF(H57<>\"\",IF(H57<24.69,\"Full\",IF(H57>26.67,\"None\",\"Partial\")),\"\")","v":""},{"$f":"IF(OR(H57=0,G57=\"\"),\"\",IF(H57>27.07,0,MIN(2,(27.07-H57))))","v":""},{"$f":"IFERROR(IF(OR(N57=\"\",O57=\"\"),\"\",+(N57)/((1754.5)*L57)), \" \")","v":""},{"$f":"IF(OR(H57=\"\",G57=\"\"),\"\",I57*L57*J57)","v":""},{"$f":"IFERROR(IF(OR(I57=\"\",L57=\"\"),\"\",N57*0.175),\" \")","v":""},{"$f":"SUM(N57:O57)","v":0},null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(G57,$D$119:$E$122,2,FALSE)),\"\",VLOOKUP(G57,$D$119:$E$122,2,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($K57,$G$119:$H$121,2,FALSE)),\"\",VLOOKUP($K57,$G$119:$H$121,2,FALSE))","v":""},{"$f":"IF(L57<>\"\",VALUE(L57),0)","v":0},{"$f":"IF(M57<>\"\",VALUE(M57),0)","v":0}]
["Hide",null,2,null,null,null,null,null,null,null,{"$f":"IF(H58<>\"\",IF(H58<24.69,\"Full\",IF(H58>26.67,\"None\",\"Partial\")),\"\")","v":""},{"$f":"IF(OR(H58=0,G58=\"\"),\"\",IF(H58>27.07,0,MIN(2,(27.07-H58))))","v":""},{"$f":"IFERROR(IF(OR(N58=\"\",O58=\"\"),\"\",+(N58)/((1754.5)*L58)), \" \")","v":""},{"$f":"IF(OR(H58=\"\",G58=\"\"),\"\",I58*L58*J58)","v":""},{"$f":"IFERROR(IF(OR(I58=\"\",L58=\"\"),\"\",N58*0.175),\" \")","v":""},0,null,null,null,null,null,"",{"$f":"IF(ISNA(VLOOKUP($K58,$G$119:$U$121,2,FALSE)),\"\",VLOOKUP($K58,$G$119:$U$121,2,FALSE))","v":""},{"$f":"IF(L58<>\"\",VALUE(L58),0)","v":0},0]
["Hide",null,3,null,null,null,null,null,null,null,"",{"$f":"IF(OR(H59=0,G59=\"\"),\"\",IF(H59>27.07,0,MIN(2,(27.07-H59))))","v":""},"","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,4,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,5,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,6,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,7,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,8,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,9,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,10,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,11,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,12,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,13,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,14,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,15,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,16,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,17,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,18,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,19,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
["Hide",null,20,null,null,null,null,null,null,null,"","","","","",0,null,null,null,null,null,"","",0,0]
[]
[null,null,null,null,null,null,null,null,"SUMMARY",null,null,null,"FTE","Salary Component","Statutory Benefit Component (17.5%) ","Total Compensation"]
[]
[null,null,null,null,null,null,null,null,null,null," Fully Eligible Positions","RECE",{"$f":"SUMPRODUCT(($V$57:$V$76=2)*($W$57:$W$76=1),$M$57:$M$76)","v":0},{"$f":"SUMPRODUCT(($V$57:$V$76=2)*($W$57:$W$76=1),$N$57:$N$76)","v":0},{"$f":"SUMPRODUCT(($V$57:$V$76=2)*($W$57:$W$76=1),$O$57:$O$76)","v":0},{"$f":"+O80+N80","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Non-RECE",{"$f":"SUMPRODUCT(($V$57:$V$76=1)*($W$57:$W$76=1),$M$57:$M$76)","v":0},{"$f":"SUMPRODUCT(($V$57:$V$76=1)*($W$57:$W$76=1),$N$57:$N$76)","v":0},{"$f":"SUMPRODUCT(($V$57:$V$76=1)*($W$57:$W$76=1),$O$57:$O$76)","v":0},{"$f":"+O81+N81","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Supervisor",{"$f":"SUMPRODUCT(($V$57:$V$76=4)*($W$57:$W$76=1),$M$57:$M$76)","v":0},{"$f":"SUMPRODUCT(($V$57:$V$76=4)*($W$57:$W$76=1),$N$57:$N$76)","v":0},{"$f":"SUMPRODUCT(($V$57:$V$76=4)*($W$57:$W$76=1),$O$57:$O$76)","v":0},{"$f":"+O82+N82","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Home Visitor",{"$f":"SUMPRODUCT(($V$57:$V$76=3)*($W$57:$W$76=1),$M$57:$M$76)","v":0},{"$f":"SUMPRODUCT(($V$57:$V$76=3)*($W$57:$W$76=1),$N$57:$N$76)","v":0},{"$f":"SUMPRODUCT(($V$57:$V$76=3)*($W$57:$W$76=1),$O$57:$O$76)","v":0},{"$f":"+O83+N83","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"SUB-TOTAL",{"$f":"SUM(M80:M83)","v":0},{"$f":"SUM(N80:N83)","v":0},{"$f":"SUM(O80:O83)","v":0},{"$f":"+O84+N84","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Partially Eligible Positions","RECE",{"$f":"SUMPRODUCT(($V$57:$V$76=2)*($W$57:$W$76=2),$M$57:$M$76)","v":0},{"$f":"SUMPRODUCT(($V$57:$V$76=2)*($W$57:$W$76=2),$N$57:$N$76)","v":0},{"$f":"SUMPRODUCT(($V$57:$V$76=2)*($W$57:$W$76=2),$O$57:$O$76)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,"Non-RECE",{"$f":"SUMPRODUCT(($V$57:$V$76=1)*($W$57:$W$76=2),$M$57:$M$76)","v":0},{"$f":"SUMPRODUCT(($V$57:$V$76=1)*($W$57:$W$76=2),$N$57:$N$76)","v":0},{"$f":"SUMPRODUCT(($V$57:$V$76=1)*($W$57:$W$76=2),$O$57:$O$76)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,"Supervisor",{"$f":"SUMPRODUCT(($V$57:$V$76=4)*($W$57:$W$76=2),$M$57:$M$76)","v":0},{"$f":"SUMPRODUCT(($V$57:$V$76=4)*($W$57:$W$76=2),$N$57:$N$76)","v":0},{"$f":"SUMPRODUCT(($V$57:$V$76=4)*($W$57:$W$76=2),$O$57:$O$76)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,"Home Visitor",{"$f":"SUMPRODUCT(($V$57:$V$76=3)*($W$57:$W$76=2),$M$57:$M$76)","v":0},{"$f":"SUMPRODUCT(($V$57:$V$76=3)*($W$57:$W$76=2),$N$57:$N$76)","v":0},{"$f":"SUMPRODUCT(($V$57:$V$76=3)*($W$57:$W$76=2),$O$57:$O$76)","v":0},{"$f":"+O88+N88","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"SUB-TOTAL",{"$f":"SUM(M85:M88)","v":0},{"$f":"SUM(N85:N88)","v":0},{"$f":"SUM(O85:O88)","v":0},{"$f":"+O89+N89","v":0}]
[null,null,null,null,null,null,null,null,null,null,"TOTAL",null,{"$f":"+M89+M84","v":0},{"$f":"+N89+N84","v":0},{"$f":"+O89+O84","v":0},{"$f":"+O90+N90","v":0}]
[null,null,null,null,null,null,null,null,null,null,"SUPPLEMENTAL GRANT",null,null,null,null,{"$f":"IFERROR(IF(M90=\" \", \" \",M90*150),\" \")","v":0}]
[null,null,null,null,null,null,null,null,null,null,"GRAND TOTAL",null,null,null,null,{"$f":"+P90+P91","v":0}]
[]
[]
[null,null,null,"CERTIFICATION",null,null,null,null,null,null,null,null,null,null,null,"Please click and select:"]
[null,null,null,"As a signing authority for this organization, I certify that the information included in this application is accurate to the best of my knowledge and represents the "]
[null,null,null,"positions that can be counted toward adult to child ratios under the Child Care and Early Years Act (CCEYA). "]
[null,null,null,"Name of Signing Authority:"]
[null,null,null,"Title:"]
[null,null,null,"Date:"]
[]
[]
[null,null,"(To be completed by CMSM/DSSAB only)"]
[null,null,null,"APPROVAL",null,null,null,null,null,null,"# of FTE","Salary","Benefit","Supplemental Grant",null,"Total"]
[null,null,null,"The child care centre / agency is approved for the following:"]
[]
[]
[null,null,null,null,null,"APPLICATION DEADLINE IS July 3, 2018 - ANY APPLICATIONS RECEIVED AFTER THIS DATE WILL NOT BE ELIGIBLE FOR FUNDING IN 2018"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Non-RECE",1,null,"Full",1]
[null,null,null,"RECE",2,null,"Partial",2]
[null,null,null,"Home Visitor",3,null,"None",3]
[null,null,null,"Supervisor",4]