{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Calculator","Lookup","Rates"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Calculator","index":0,"n_rows":146,"n_cols":13,"rows_kept":146,"cut":false,"hidden":false,"merged":[[25,10,32,10],[1,10,2,10],[2,0,2,4],[9,0,9,2],[4,10,11,10],[12,2,12,5],[16,4,18,5],[13,2,13,5],[20,10,21,10],[16,10,18,10],[11,2,11,8],[3,0,4,2],[24,2,24,5],[52,2,52,5],[29,2,29,5],[36,2,36,5],[19,2,19,5],[33,4,35,5],[49,4,51,5],[30,2,30,5],[46,2,46,5],[28,2,28,8],[44,2,44,8],[26,2,26,4],[42,2,42,5],[45,2,45,5],[132,2,132,5],[97,4,99,5],[100,2,100,5],[109,2,109,5],[110,2,110,5],[113,4,115,5],[124,2,124,8],[116,2,116,5],[125,2,125,5],[126,2,126,5],[129,4,131,5],[140,2,142,2],[21,4,21,6],[60,2,60,8],[76,2,76,8],[92,2,92,8],[108,2,108,8],[78,2,78,5],[81,4,83,5],[84,2,84,5],[93,2,93,5],[94,2,94,5],[61,2,61,5],[62,2,62,5],[65,4,67,5],[68,2,68,5],[77,2,77,5]]}
["Early Childhood Teacher Supplement Calculator"]
[]
["How much early childhood teacher supplement can this service expect to receive?"]
["PLEASE NOTE: THE ECTS FOR RURAL SERVICES WITH ROTATIONAL GROUPS MAY NOT CALCULATE CORRECTLY IN THIS CALCULATOR",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,"This tool calculates the amount of early childhood teacher supplement (ECTS) an eligible service provider can receive for each group taught by an eligible teacher. \n\nIf you wish to clear the information you have entered in this calculator and re-calculate the ECTS for another service, please click the \"CLEAR ALL\" button.\n\nPlease note that the ECTS amount produced by this calculator are indicative only and if you want confirmation of the amount to be received, you should contact your regional office.\n"]
[]
[]
["Is your service funded at the Standard or Rural rate?\nPlease select one of the following options:\n1. ST for Standard service\n2. RU for Rural service"]
[]
["For each group, please enter below the names of the teachers who are delivering the kindergarten program and who are eligible for the early childhood teacher supplement*."]
[]
["Group 1","Name of group:"]
["Total number of children in this group"]
["Total number of kindergarten hours received by this group",15,"The Early Childhood Teacher Supplement is capped at 15 hours per group "]
[]
["Teacher Name","Level \n(select from the drop down list)","Total contact hours delivered by teacher to this group","Terms"]
[null,null,null,null,"Contact hours per teacher cannot be more than 'total number of kindergarten hours received by the group'",null,null,null,null,null,"* To be eligible for the early childhood teacher supplement, the teacher must be classified and validated as level 2.3 or above under the VECTEA or EEEA 2016 (or equivalent). For the full eligibility criteria please refer to page the Kindergarten Guide"]
[]
[]
[]
[null,"% of Grant","Applicable rate **","Breakdown",null,null,null,null,null,null,"**  For a list of the annual supplement rates and their definitions, please click HERE"]
["Supplement at level 3 rate",{"$f":"MIN(1,SUMPRODUCT((B17:B19>3)*C17:C19*D17:D19)/60)","v":0},{"$f":"IF($B$8=\"\",0,(IF(AND(B13>9,B13<18),INDEX(Lookup!$F$3:$F$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(3=Lookup!$D$3:$D$6),0)),(IF(B13<10,INDEX(Lookup!$G$3:$G$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(3=Lookup!$D$3:$D$6),0)),INDEX(Lookup!$E$3:$E$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(3=Lookup!$D$3:$D$6),0)))))))","v":0},{"$f":"IF(AND(B$8=\"RU\",B$13<18),(C22*B22),(B22*C22*B$13))","v":0},"The proportion of the grant allocated to Level 3 teachers is calculated first   "]
["Supplement at level 2.4 & 2.5 rate",{"$f":"MIN(SUMPRODUCT((B17:B19>2.3)*(B17:B19<3)*C17:C19*D17:D19)/60,1-B22)","v":0},{"$f":"IF($B$8=\"\",0,(IF(AND(B13>9,B13<18),INDEX(Lookup!$F$3:$F$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(2=Lookup!$D$3:$D$6),0)),(IF(B13<10,INDEX(Lookup!$G$3:$G$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(2=Lookup!$D$3:$D$6),0)),INDEX(Lookup!$E$3:$E$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(2=Lookup!$D$3:$D$6),0)))))))","v":0},{"$f":"IF(AND(B$8=\"RU\",B$13<18),(C23*B23),(B23*C23*B$13))","v":0}]
["Supplement at level 2.3 rate",{"$f":"MIN(SUMPRODUCT((B17:B19>2.2)*(B17:B19<2.4)*C17:C19*D17:D19)/60,1-(B22+B23))","v":0},{"$f":"IF($B$8=\"\",0,(IF(AND(B13>9,B13<18),INDEX(Lookup!$F$3:$F$8,MATCH(1,($B$8=Lookup!$C$3:$C$8)*(4=Lookup!$D$3:$D$8),0)),(IF(B13<10,INDEX(Lookup!$G$3:$G$8,MATCH(1,($B$8=Lookup!$C$3:$C$8)*(4=Lookup!$D$3:$D$8),0)),INDEX(Lookup!$E$3:$E$8,MATCH(1,($B$8=Lookup!$C$3:$C$8)*(4=Lookup!$D$3:$D$8),0)))))))","v":0},{"$f":"IF(AND(B$8=\"RU\",B$13<18),(C24*B24),(B24*C24*B$13))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"The ECTS amount is capped at 15 hours for 4 terms for each group, irrespective of the number of teachers.\n\nThe grant amount is proportionally reduced if an eligible teacher delivers the program to the group for fewer than 15 hours per week or fewer than four terms.\n\nWhen more than one eligible teacher is delivering the program during the year, the proportion of hours and terms delivered by Level 3 teachers is calculated first and then the proportion at Level 2. \n\nThe proportion for each level is multiplied by the number of children in the group at the appropriate rate. \n"]
["Supplement Amount - Group 1",{"$f":"IF(OR(B14=0,COUNTIF(C17:C19,0)=\">0\"),0,IF(AND($B$8=\"RU\", B13>9,B13<18),SUMPRODUCT(B22:B24,C22:C24),IF(AND($B$8= \"RU\",B13<10),SUMPRODUCT(B22:B24,C22:C24),SUMPRODUCT(B22:B24,C22:C24)*B13)))","v":0},"The amount calculated is based on the capped limit of 15 hours for 4 terms per group"]
[]
["Group 2"]
["Total number of children in this group"]
["Total number of kindergarten hours received by this group",15]
[]
["Teacher Name","Level \n(select from the drop down list)","Total contact hours delivered by teacher to this group","Terms"]
[]
[]
[]
[]
[null,"% of Grant","Applicable rate **","Breakdown"]
["Supplement at level 3 rate",{"$f":"MIN(1,SUMPRODUCT((B34:B36>3)*C34:C36*D34:D36)/60)","v":0},{"$f":"IF($B$8=\"\",0,(IF(AND(B30>9,B30<18),INDEX(Lookup!$F$3:$F$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(3=Lookup!$D$3:$D$6),0)),(IF(B30<10,INDEX(Lookup!$G$3:$G$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(3=Lookup!$D$3:$D$6),0)),INDEX(Lookup!$E$3:$E$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(3=Lookup!$D$3:$D$6),0)))))))","v":0},{"$f":"IF(AND(B$8=\"RU\",B$30<18),(C39*B39),(B39*C39*B$30))","v":0}]
["Supplement at level 2.4 & 2.5 rate",{"$f":"MIN(SUMPRODUCT((B34:B36>2.3)*(B34:B36<3)*C34:C36*D34:D36)/60,1-B39)","v":0},{"$f":"IF($B$8=\"\",0,(IF(AND(B30>9,B30<18),INDEX(Lookup!$F$3:$F$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(2=Lookup!$D$3:$D$6),0)),(IF(B30<10,INDEX(Lookup!$G$3:$G$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(2=Lookup!$D$3:$D$6),0)),INDEX(Lookup!$E$3:$E$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(2=Lookup!$D$3:$D$6),0)))))))","v":0},{"$f":"IF(AND(B$8=\"RU\",B$30<18),(C40*B40),(B40*C40*B$30))","v":0}]
["Supplement at level 2.3 rate",{"$f":"MIN(SUMPRODUCT((B34:B36>2.2)*(B34:B36<2.4)*C34:C36*D34:D36)/60,1-(B39+B40))","v":0},{"$f":"IF($B$8=\"\",0,(IF(AND(B30>9,B30<18),INDEX(Lookup!$F$3:$F$8,MATCH(1,($B$8=Lookup!$C$3:$C$8)*(4=Lookup!$D$3:$D$8),0)),(IF(B30<10,INDEX(Lookup!$G$3:$G$8,MATCH(1,($B$8=Lookup!$C$3:$C$8)*(4=Lookup!$D$3:$D$8),0)),INDEX(Lookup!$E$3:$E$8,MATCH(1,($B$8=Lookup!$C$3:$C$8)*(4=Lookup!$D$3:$D$8),0)))))))","v":0},{"$f":"IF(AND(B$8=\"RU\",B$30<18),(C41*B41),(B41*C41*B$30))","v":0}]
[]
["Supplement Amount - Group 2",{"$f":"IF(OR(B31=0,COUNTIF(C34:C36,0)=\">0\"),0,IF(AND($B$8=\"RU\", B30>9,B30<18),SUMPRODUCT(B39:B41,C39:C41),IF(AND($B$8= \"RU\",B30<10),SUMPRODUCT(B39:B41,C39:C41),SUMPRODUCT(B39:B41,C39:C41)*B30)))","v":0}]
[]
["Group 3"]
["Total number of children in this group"]
["Total number of kindergarten hours received by this group",15]
[]
["Teacher Name","Level \n(select from the drop down list)","Total contact hours delivered by teacher to this group","Terms"]
[]
[]
[]
[]
[null,"% of Grant","Applicable rate **","Breakdown"]
["Supplement at level 3 rate",{"$f":"MIN(1,SUMPRODUCT((B50:B52>3)*C50:C52*D50:D52)/60)","v":0},{"$f":"IF($B$8=\"\",0,(IF(AND(B46>9,B46<18),INDEX(Lookup!$F$3:$F$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(3=Lookup!$D$3:$D$6),0)),(IF(B46<10,INDEX(Lookup!$G$3:$G$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(3=Lookup!$D$3:$D$6),0)),INDEX(Lookup!$E$3:$E$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(3=Lookup!$D$3:$D$6),0)))))))","v":0},{"$f":"IF(AND(B$8=\"RU\",B$46<18),(C55*B55),(B55*C55*B$46))","v":0}]
["Supplement at level 2.4 & 2.5 rate",{"$f":"MIN(SUMPRODUCT((B50:B52>2.3)*(B50:B52<3)*C50:C52*D50:D52)/60,1-B55)","v":0},{"$f":"IF($B$8=\"\",0,(IF(AND(B46>9,B46<18),INDEX(Lookup!$F$3:$F$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(2=Lookup!$D$3:$D$6),0)),(IF(B46<10,INDEX(Lookup!$G$3:$G$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(2=Lookup!$D$3:$D$6),0)),INDEX(Lookup!$E$3:$E$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(2=Lookup!$D$3:$D$6),0)))))))","v":0},{"$f":"IF(AND(B$8=\"RU\",B$46<18),(C56*B56),(B56*C56*B$46))","v":0}]
["Supplement at level 2.3 rate",{"$f":"MIN(SUMPRODUCT((B50:B52>2.2)*(B50:B52<2.4)*C50:C52*D50:D52)/60,1-(B55+B56))","v":0},{"$f":"IF($B$8=\"\",0,(IF(AND(B46>9,B46<18),INDEX(Lookup!$F$3:$F$8,MATCH(1,($B$8=Lookup!$C$3:$C$8)*(4=Lookup!$D$3:$D$8),0)),(IF(B46<10,INDEX(Lookup!$G$3:$G$8,MATCH(1,($B$8=Lookup!$C$3:$C$8)*(4=Lookup!$D$3:$D$8),0)),INDEX(Lookup!$E$3:$E$8,MATCH(1,($B$8=Lookup!$C$3:$C$8)*(4=Lookup!$D$3:$D$8),0)))))))","v":0},{"$f":"IF(AND(B$8=\"RU\",B$46<18),(C57*B57),(B57*C57*B$46))","v":0}]
[]
["Supplement Amount - Group 3",{"$f":"IF(OR(B47=0,COUNTIF(C50:C52,0)=\">0\"),0,IF(AND($B$8=\"RU\", B46>9,B46<18),SUMPRODUCT(B55:B57,C55:C57),IF(AND($B$8= \"RU\",B46<10),SUMPRODUCT(B55:B57,C55:C57),SUMPRODUCT(B55:B57,C55:C57)*B46)))","v":0}]
[]
["Group 4"]
["Total number of children in this group"]
["Total number of kindergarten hours received by this group",15]
[]
["Teacher Name","Level \n(select from the drop down list)","Total contact hours delivered by teacher to this group","Terms"]
[]
[]
[]
[]
[null,"% of Grant","Applicable rate **","Breakdown"]
["Supplement at level 3 rate",{"$f":"MIN(1,SUMPRODUCT((B66:B68>3)*C66:C68*D66:D68)/60)","v":0},{"$f":"IF($B$8=\"\",0,(IF(AND(B62>9,B62<18),INDEX(Lookup!$F$3:$F$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(3=Lookup!$D$3:$D$6),0)),(IF(B62<10,INDEX(Lookup!$G$3:$G$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(3=Lookup!$D$3:$D$6),0)),INDEX(Lookup!$E$3:$E$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(3=Lookup!$D$3:$D$6),0)))))))","v":0},{"$f":"IF(AND(B$8=\"RU\",B$62<18),(C71*B71),(B71*C71*B$62))","v":0}]
["Supplement at level 2.4 & 2.5 rate",{"$f":"MIN(SUMPRODUCT((B66:B68>2.3)*(B66:B68<3)*C66:C68*D66:D68)/60,1-B71)","v":0},{"$f":"IF($B$8=\"\",0,(IF(AND(B62>9,B62<18),INDEX(Lookup!$F$3:$F$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(2=Lookup!$D$3:$D$6),0)),(IF(B62<10,INDEX(Lookup!$G$3:$G$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(2=Lookup!$D$3:$D$6),0)),INDEX(Lookup!$E$3:$E$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(2=Lookup!$D$3:$D$6),0)))))))","v":0},{"$f":"IF(AND(B$8=\"RU\",B$62<18),(C72*B72),(B72*C72*B$62))","v":0}]
["Supplement at level 2.3 rate",{"$f":"MIN(SUMPRODUCT((B66:B68>2.2)*(B66:B68<2.4)*C66:C68*D66:D68)/60,1-(B71+B72))","v":0},{"$f":"IF($B$8=\"\",0,(IF(AND(B62>9,B62<18),INDEX(Lookup!$F$3:$F$8,MATCH(1,($B$8=Lookup!$C$3:$C$8)*(4=Lookup!$D$3:$D$8),0)),(IF(B62<10,INDEX(Lookup!$G$3:$G$8,MATCH(1,($B$8=Lookup!$C$3:$C$8)*(4=Lookup!$D$3:$D$8),0)),INDEX(Lookup!$E$3:$E$8,MATCH(1,($B$8=Lookup!$C$3:$C$8)*(4=Lookup!$D$3:$D$8),0)))))))","v":0},{"$f":"IF(AND(B$8=\"RU\",B$62<18),(C73*B73),(B73*C73*B$62))","v":0}]
[]
["Supplement Amount - Group 4",{"$f":"IF(OR(B63=0,COUNTIF(C66:C68,0)=\">0\"),0,IF(AND($B$8=\"RU\", B62>9,B62<18),SUMPRODUCT(B71:B73,C71:C73),IF(AND($B$8= \"RU\",B62<10),SUMPRODUCT(B71:B73,C71:C73),SUMPRODUCT(B71:B73,C71:C73)*B62)))","v":0}]
[]
["Group 5"]
["Total number of children in this group"]
["Total number of kindergarten hours received by this group",15]
[]
["Teacher Name","Level \n(select from the drop down list)","Total contact hours delivered by teacher to this group","Terms"]
[]
[]
[]
[]
[null,"% of Grant","Applicable rate **","Breakdown"]
["Supplement at level 3 rate",{"$f":"MIN(1,SUMPRODUCT((B82:B84>3)*C82:C84*D82:D84)/60)","v":0},{"$f":"IF($B$8=\"\",0,(IF(AND(B78>9,B78<18),INDEX(Lookup!$F$3:$F$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(3=Lookup!$D$3:$D$6),0)),(IF(B78<10,INDEX(Lookup!$G$3:$G$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(3=Lookup!$D$3:$D$6),0)),INDEX(Lookup!$E$3:$E$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(3=Lookup!$D$3:$D$6),0)))))))","v":0},{"$f":"IF(AND(B$8=\"RU\",B$78<18),(C87*B87),(B87*C87*B$78))","v":0}]
["Supplement at level 2.4 & 2.5 rate",{"$f":"MIN(SUMPRODUCT((B82:B84>2.3)*(B82:B84<3)*C82:C84*D82:D84)/60,1-B87)","v":0},{"$f":"IF($B$8=\"\",0,(IF(AND(B78>9,B78<18),INDEX(Lookup!$F$3:$F$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(2=Lookup!$D$3:$D$6),0)),(IF(B78<10,INDEX(Lookup!$G$3:$G$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(2=Lookup!$D$3:$D$6),0)),INDEX(Lookup!$E$3:$E$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(2=Lookup!$D$3:$D$6),0)))))))","v":0},{"$f":"IF(AND(B$8=\"RU\",B$78<18),(C88*B88),(B88*C88*B$78))","v":0}]
["Supplement at level 2.3 rate",{"$f":"MIN(SUMPRODUCT((B82:B84>2.2)*(B82:B84<2.4)*C82:C84*D82:D84)/60,1-(B87+B88))","v":0},{"$f":"IF($B$8=\"\",0,(IF(AND(B78>9,B78<18),INDEX(Lookup!$F$3:$F$8,MATCH(1,($B$8=Lookup!$C$3:$C$8)*(4=Lookup!$D$3:$D$8),0)),(IF(B78<10,INDEX(Lookup!$G$3:$G$8,MATCH(1,($B$8=Lookup!$C$3:$C$8)*(4=Lookup!$D$3:$D$8),0)),INDEX(Lookup!$E$3:$E$8,MATCH(1,($B$8=Lookup!$C$3:$C$8)*(4=Lookup!$D$3:$D$8),0)))))))","v":0},{"$f":"IF(AND(B$8=\"RU\",B$78<18),(C89*B89),(B89*C89*B$78))","v":0}]
[]
["Supplement Amount - Group 5",{"$f":"IF(OR(B79=0,COUNTIF(C82:C84,0)=\">0\"),0,IF(AND($B$8=\"RU\", B78>9,B78<18),SUMPRODUCT(B87:B89,C87:C89),IF(AND($B$8= \"RU\",B78<10),SUMPRODUCT(B87:B89,C87:C89),SUMPRODUCT(B87:B89,C87:C89)*B78)))","v":0}]
[]
["Group 6"]
["Total number of children in this group"]
["Total number of kindergarten hours received by this group",15]
[]
["Teacher Name","Level \n(select from the drop down list)","Total contact hours delivered by teacher to this group","Terms"]
[]
[]
[]
[]
[null,"% of Grant","Applicable rate **","Breakdown"]
["Supplement at level 3 rate",{"$f":"MIN(1,SUMPRODUCT((B98:B100>3)*C98:C100*D98:D100)/60)","v":0},{"$f":"IF($B$8=\"\",0,(IF(AND(B94>9,B94<18),INDEX(Lookup!$F$3:$F$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(3=Lookup!$D$3:$D$6),0)),(IF(B94<10,INDEX(Lookup!$G$3:$G$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(3=Lookup!$D$3:$D$6),0)),INDEX(Lookup!$E$3:$E$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(3=Lookup!$D$3:$D$6),0)))))))","v":0},{"$f":"IF(AND(B$8=\"RU\",B$94<18),(C103*B103),(B103*C103*B$94))","v":0}]
["Supplement at level 2.4 & 2.5 rate",{"$f":"MIN(SUMPRODUCT((B98:B100>2.3)*(B98:B100<3)*C98:C100*D98:D100)/60,1-B103)","v":0},{"$f":"IF($B$8=\"\",0,(IF(AND(B94>9,B94<18),INDEX(Lookup!$F$3:$F$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(2=Lookup!$D$3:$D$6),0)),(IF(B94<10,INDEX(Lookup!$G$3:$G$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(2=Lookup!$D$3:$D$6),0)),INDEX(Lookup!$E$3:$E$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(2=Lookup!$D$3:$D$6),0)))))))","v":0},{"$f":"IF(AND(B$8=\"RU\",B$94<18),(C104*B104),(B104*C104*B$94))","v":0}]
["Supplement at level 2.3 rate",{"$f":"MIN(SUMPRODUCT((B98:B100>2.2)*(B98:B100<2.4)*C98:C100*D98:D100)/60,1-(B103+B104))","v":0},{"$f":"IF($B$8=\"\",0,(IF(AND(B94>9,B94<18),INDEX(Lookup!$F$3:$F$8,MATCH(1,($B$8=Lookup!$C$3:$C$8)*(4=Lookup!$D$3:$D$8),0)),(IF(B94<10,INDEX(Lookup!$G$3:$G$8,MATCH(1,($B$8=Lookup!$C$3:$C$8)*(4=Lookup!$D$3:$D$8),0)),INDEX(Lookup!$E$3:$E$8,MATCH(1,($B$8=Lookup!$C$3:$C$8)*(4=Lookup!$D$3:$D$8),0)))))))","v":0},{"$f":"IF(AND(B$8=\"RU\",B$94<18),(C105*B105),(B105*C105*B$94))","v":0}]
[]
["Supplement Amount - Group 6",{"$f":"IF(OR(B95=0,COUNTIF(C98:C100,0)=\">0\"),0,IF(AND($B$8=\"RU\", B94>9,B94<18),SUMPRODUCT(B103:B105,C103:C105),IF(AND($B$8= \"RU\",B94<10),SUMPRODUCT(B103:B105,C103:C105),SUMPRODUCT(B103:B105,C103:C105)*B94)))","v":0}]
[]
["Group 7"]
["Total number of children in this group"]
["Total number of kindergarten hours received by this group",15]
[]
["Teacher Name","Level \n(select from the drop down list)","Total contact hours delivered by teacher to this group","Terms"]
[]
[]
[]
[]
[null,"% of Grant","Applicable rate **","Breakdown"]
["Supplement at level 3 rate",{"$f":"MIN(1,SUMPRODUCT((B114:B116>3)*C114:C116*D114:D116)/60)","v":0},{"$f":"IF($B$8=\"\",0,(IF(AND(B110>9,B110<18),INDEX(Lookup!$F$3:$F$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(3=Lookup!$D$3:$D$6),0)),(IF(B110<10,INDEX(Lookup!$G$3:$G$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(3=Lookup!$D$3:$D$6),0)),INDEX(Lookup!$E$3:$E$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(3=Lookup!$D$3:$D$6),0)))))))","v":0},{"$f":"IF(AND(B$8=\"RU\",B$110<18),(C119*B119),(B119*C119*B$110))","v":0}]
["Supplement at level 2.4 & 2.5 rate",{"$f":"MIN(SUMPRODUCT((B114:B116>2.3)*(B114:B116<3)*C114:C116*D114:D116)/60,1-B119)","v":0},{"$f":"IF($B$8=\"\",0,(IF(AND(B110>9,B110<18),INDEX(Lookup!$F$3:$F$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(2=Lookup!$D$3:$D$6),0)),(IF(B110<10,INDEX(Lookup!$G$3:$G$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(2=Lookup!$D$3:$D$6),0)),INDEX(Lookup!$E$3:$E$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(2=Lookup!$D$3:$D$6),0)))))))","v":0},{"$f":"IF(AND(B$8=\"RU\",B$110<18),(C120*B120),(B120*C120*B$110))","v":0}]
["Supplement at level 2.3 rate",{"$f":"MIN(SUMPRODUCT((B114:B116>2.2)*(B114:B116<2.4)*C114:C116*D114:D116)/60,1-(B119+B120))","v":0},{"$f":"IF($B$8=\"\",0,(IF(AND(B110>9,B110<18),INDEX(Lookup!$F$3:$F$8,MATCH(1,($B$8=Lookup!$C$3:$C$8)*(4=Lookup!$D$3:$D$8),0)),(IF(B110<10,INDEX(Lookup!$G$3:$G$8,MATCH(1,($B$8=Lookup!$C$3:$C$8)*(4=Lookup!$D$3:$D$8),0)),INDEX(Lookup!$E$3:$E$8,MATCH(1,($B$8=Lookup!$C$3:$C$8)*(4=Lookup!$D$3:$D$8),0)))))))","v":0},{"$f":"IF(AND(B$8=\"RU\",B$110<18),(C121*B121),(B121*C121*B$110))","v":0}]
[]
["Supplement Amount - Group 7",{"$f":"IF(OR(B111=0,COUNTIF(C114:C116,0)=\">0\"),0,IF(AND($B$8=\"RU\", B110>9,B110<18),SUMPRODUCT(B119:B121,C119:C121),IF(AND($B$8= \"RU\",B110<10),SUMPRODUCT(B119:B121,C119:C121),SUMPRODUCT(B119:B121,C119:C121)*B110)))","v":0}]
[]
["Group 8"]
["Total number of children in this group"]
["Total number of kindergarten hours received by this group",15]
[]
["Teacher Name","Level \n(select from the drop down list)","Total contact hours delivered by teacher to this group","Terms"]
[]
[]
[]
[]
[null,"% of Grant","Applicable rate **","Breakdown"]
["Supplement at level 3 rate",{"$f":"MIN(1,SUMPRODUCT((B130:B132>3)*C130:C132*D130:D132)/60)","v":0},{"$f":"IF($B$8=\"\",0,(IF(AND(B126>9,B126<18),INDEX(Lookup!$F$3:$F$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(3=Lookup!$D$3:$D$6),0)),(IF(B126<10,INDEX(Lookup!$G$3:$G$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(3=Lookup!$D$3:$D$6),0)),INDEX(Lookup!$E$3:$E$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(3=Lookup!$D$3:$D$6),0)))))))","v":0},{"$f":"IF(AND(B$8=\"RU\",B$126<18),(C135*B135),(B135*C135*B$126))","v":0}]
["Supplement at level 2.4 & 2.5 rate",{"$f":"MIN(SUMPRODUCT((B130:B132>2.3)*(B130:B132<3)*C130:C132*D130:D132)/60,1-B135)","v":0},{"$f":"IF($B$8=\"\",0,(IF(AND(B126>9,B126<18),INDEX(Lookup!$F$3:$F$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(2=Lookup!$D$3:$D$6),0)),(IF(B126<10,INDEX(Lookup!$G$3:$G$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(2=Lookup!$D$3:$D$6),0)),INDEX(Lookup!$E$3:$E$6,MATCH(1,($B$8=Lookup!$C$3:$C$6)*(2=Lookup!$D$3:$D$6),0)))))))","v":0},{"$f":"IF(AND(B$8=\"RU\",B$126<18),(C136*B136),(B136*C136*B$126))","v":0}]
["Supplement at level 2.3 rate",{"$f":"MIN(SUMPRODUCT((B130:B132>2.2)*(B130:B132<2.4)*C130:C132*D130:D132)/60,1-(B135+B136))","v":0},{"$f":"IF($B$8=\"\",0,(IF(AND(B126>9,B126<18),INDEX(Lookup!$F$3:$F$8,MATCH(1,($B$8=Lookup!$C$3:$C$8)*(4=Lookup!$D$3:$D$8),0)),(IF(B126<10,INDEX(Lookup!$G$3:$G$8,MATCH(1,($B$8=Lookup!$C$3:$C$8)*(4=Lookup!$D$3:$D$8),0)),INDEX(Lookup!$E$3:$E$8,MATCH(1,($B$8=Lookup!$C$3:$C$8)*(4=Lookup!$D$3:$D$8),0)))))))","v":0},{"$f":"IF(AND(B$8=\"RU\",B$126<18),(C137*B137),(B137*C137*B$126))","v":0}]
[]
["Supplement Amount - Group 8",{"$f":"IF(OR(B127=0,COUNTIF(C130:C132,0)=\">0\"),0,IF(AND($B$8=\"RU\", B126>9,B126<18),SUMPRODUCT(B135:B137,C135:C137),IF(AND($B$8= \"RU\",B126<10),SUMPRODUCT(B135:B137,C135:C137),SUMPRODUCT(B135:B137,C135:C137)*B126)))","v":0}]
[]
["Grand Total Amount at Level 3 Rate",{"$f":"D22+D39+D55+D71+D87+D103+D119+D135","v":0},"Breakdown of the payments"]
["Grand Total Amount at Level 2.5 & 2.5 Rate",{"$f":"D23+D40+D56+D72+D88+D104+D120+D136","v":0}]
["Grand Total Amount at Level 2.3 Rate",{"$f":"D24+D41+D57+D73+D89+D105+D121+D137","v":0}]
[]
["Early Childhood Teacher supplement "]
["TOTAL TEACHER SUPPLEMENT AMOUNT",{"$f":"SUM(B27,B43,B59,B75,B91,B107,B123,B139)","v":0}]

{"sheet":"Lookup","index":1,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"18 or More","10 to 17","9 or less"]
[null,"Level","Funding Category","Code","Rate","Rate","Rate"]
[null,"Level 2.4 & 2.5","ST",2,237,237,237]
[null,"Level 2.4 & 2.5","RU",2,294,5292,5292]
[null,"level 3","ST",3,593,593,593]
[null,"level 3","RU",3,736,13248,13248]
[null,"level 2.3","ST",4,91,91,91]
[null,"level 2.3","RU",4,113,2034,2034]
[]
[null,"Drop down lists"]
[]
[null,"hours","Funding","Level","Group delivery type","Terms"]
[null,10.75,"ST",2.2999999999999998,"Yes",1]
[null,15,"RU",2.4,"No",2]
[null,null,null,2.5,null,3]
[null,null,null,3.1,null,4]
[null,null,null,3.2]
[null,null,null,3.3]
[null,null,null,3.4]
[null,null,null,3.5]

{"sheet":"Rates","index":2,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[3,1,5,4],[13,1,13,4]]}
[]
[null,"ANNUAL EARLY CHILDHOOD TEACHER SUPPLEMENT RATES"]
[]
[null,"Outlined below are the rates, per child, for service providers offering a kindergarten program in 2017"]
[]
[]
[]
[null,"Type of early childhood teacher supplement","Annual Level 2.3 supplement rate from 1 January 2018","Annual Level 2.4 & 2.5 supplement rate from 1 January 2018","Annual Level 3 supplement rate from 1 January 2018","Comments"]
[null,"Standard ",91,237,593]
[null,"Rural  18 or more children",113,294,736]
[null,"Rural  up to 17 children",2034,5292,13248,"Flat Rate per service"]
[]
[]
[null,"CLICK HERE TO RETURN TO FUNDING CALCULATOR"]