{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Form 1 - EN","Form 1 - FR"],"not_rendered":{"charts":0,"images":1,"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":"Form 1 - EN","index":0,"n_rows":55,"n_cols":20,"rows_kept":55,"cut":false,"hidden":false,"merged":[[3,18,3,23],[34,0,35,11],[51,1,51,2],[51,8,51,10],[23,0,23,3],[25,0,25,3],[41,0,42,11],[30,0,32,11],[0,0,0,9],[24,0,24,3],[26,0,26,3],[27,0,27,3],[28,0,28,3],[21,0,21,3],[20,0,20,3],[2,0,2,9]]}
["Form 1 - Statement of Taxes Collected and Education Taxes Remitted"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Macro for \"is this the final remittance?\" 1 = Y"]
["as at the month ending",null,null,null,null,null,null,null,null,"Education and Early Childhood Learning",null,null,null,null,null,null,null,null,"DO NOT DELETE"]
[null,null,null,null,null,null,null,null,null,"System Peformance and Accountabiilty Division"]
["Municipality of",null,null,null,null,"No.",null,null,null,"Education Funding Branch"]
[null,null,null,null,null,null,null,null,null,"511-1181 Portage Avenue, Winnipeg, MB R3G 0T3"]
["A)","Tax due date"]
[]
["B)","Taxes Collected"]
[]
[null,"Tax Levy (Current Year)"]
[]
[null,"Total Taxes Collected To Date"]
[]
[null,"Collection as a Percentage of Levy",null,null,{"$f":"IF(E14=0,\"\",E14/E12)","v":""}]
[]
["C)","Education Taxes Remitted",null,null,"Is this the Final Remittance?"]
[]
[]
["EDUCATION AUTHORITY",null,null,null,"GROSS ESL",null,null,"TOTAL REQUIREMENTS\n(1)","% REMITTED\n(2)","YEAR TO DATE \n(3)","PRIOR MONTHS\n(4)","CURRENT MONTH \n(5)"]
["Education Support Levy (ESL)",null,null,null,null,null,null,{"$f":"E22","v":0},{"$f":"IF(S3=1,1,E16)","v":""},{"$f":"IF(I22=\"\",\"\",H22*I22)","v":""},null,{"$f":"IF(J22=\"\",\"\",J22-K22)","v":""}]
[]
["School Division",null,null,null,"GROSS SPECIAL LEVY","HOMEOWNERS AFFORDABILITY  TAX CREDIT","SCHOOL TAX REBATE"]
[null,null,null,null,null,null,null,{"$f":"E25-F25-G25","v":0},{"$f":"IF(ISBLANK(A25)=TRUE,\"\",$I$22)","v":""},{"$f":"IF(I25=\"\",\"\",H25*I25)","v":""},null,{"$f":"IF(J25=\"\",\"\",J25-K25)","v":""}]
[null,null,null,null,null,null,null,{"$f":"E26-F26-G26","v":0},{"$f":"IF(ISBLANK(A26)=TRUE,\"\",$I$22)","v":""},{"$f":"IF(I26=\"\",\"\",H26*I26)","v":""},null,{"$f":"IF(J26=\"\",\"\",J26-K26)","v":""}]
[null,null,null,null,null,null,null,{"$f":"E27-F27-G27","v":0},{"$f":"IF(ISBLANK(A27)=TRUE,\"\",$I$22)","v":""},{"$f":"IF(I27=\"\",\"\",H27*I27)","v":""},null,{"$f":"IF(J27=\"\",\"\",J27-K27)","v":""}]
[null,null,null,null,null,null,null,{"$f":"E28-F28-G28","v":0},{"$f":"IF(ISBLANK(A28)=TRUE,\"\",$I$22)","v":""},{"$f":"IF(I28=\"\",\"\",H28*I28)","v":""},null,{"$f":"IF(J28=\"\",\"\",J28-K28)","v":""}]
[null,null,null,null,null,null,null,{"$f":"E29-F29-G29","v":0},{"$f":"IF(ISBLANK(A29)=TRUE,\"\",$I$22)","v":""},{"$f":"IF(I29=\"\",\"\",H29*I29)","v":""},null,{"$f":"IF(J29=\"\",\"\",J29-K29)","v":""}]
[]
["(1) \"Total Requirements\" are the total amounts to be remitted for the year to each of the education authorities shown above. For ESL, this is the total remittance amount as per the Statement of Education Support Levy. For gross special levy by school division, the amount will be net of the Homeowners Affordability Tax Credit (HATC) and the School Tax Rebate."]
[]
[]
[]
["(2) \"% to be Remitted\" is the percentage of total current year taxes collected to date, as calculated in Section B.  For final payment, if taxes collected are less than 100% as calculated in Section B, this column will show 100% for remittance purposes."]
[]
[]
["(3) \"Year to Date\" is the total that must be remitted based on the percentage collected in the current period."]
[]
["(4) \"Prior Months\" are the amounts remitted to each of the education authorities to date."]
[]
["(5) \"Current Month\" is the amount owing for the current period which is to be paid the education authorites before the end of the month following the tax due date. In the final report, the \"Total Requirements\" must equal to the \"Year to Date\" amount.  If the final report is for the month ending December 31, payment must be made by January 31."]
[]
[]
["NOTE: In all cases, final payment must be made by January 31."]
["ESL remittances are payable to: Minister of Finance and mailed to 511-1181 Portage Avenue, Winnipeg, MB R3G 0T3"]
[]
[]
[null,"I certify the above to be a true and correct statement."]
[]
[]
[null,"Date",null,null,null,null,null,null,"Municipal Administrator"]
[]
[]
["This form is available on the Internet at http://www.edu.gov.mb.ca/k12/finance/forms/index.html"]

{"sheet":"Form 1 - FR","index":1,"n_rows":56,"n_cols":20,"rows_kept":56,"cut":false,"hidden":false,"merged":[[52,1,52,2],[52,8,52,10],[25,0,25,3],[24,0,24,3],[26,0,26,3],[27,0,27,3],[28,0,28,3],[30,0,32,11],[34,0,35,11],[41,0,42,11],[23,0,23,3],[0,0,0,9],[2,0,2,9],[3,18,3,23],[20,0,20,3],[21,0,21,3]]}
["Formule 1 - Relevé des taxes perçues et des taxes scolaires remises"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Macro for \"is this the final remittance?\" 1 = Y"]
["à la fin du mois se terminant le",null,null,null,null,null,null,null,null,"Éducation et Apprentissage de la petite enfance",null,null,null,null,null,null,null,null,"DO NOT DELETE"]
[null,null,null,null,null,null,null,null,null,"Direction des finances de l’éducation"]
["Municipalité de",null,null,null,null,"No.",null,null,null,"1181, avenue Portage, bureau 511"]
[null,null,null,null,null,null,null,null,null,"Winnipeg (Manitoba) R3G 0T3"]
["A)","Date d’exigibilité des taxes"]
[]
["B)","Taxes perçues"]
[]
[null,"Taxes à percevoir pour l’année courante"]
[]
[null,"Montant global des taxes perçues jusqu’à ce jour pendant l’année courante"]
[]
[null,"Taxes perçues exprimées en % des taxes à percevoir",null,null,null,null,{"$f":"IF(G14=0,\"\",G14/G12)","v":""}]
[]
["C)","Taxes scolaires remises",null,null,"Est-ce le versement final?"]
[]
[]
["\nADMINISTRATION SCOLAIRE",null,null,null,"TAXE D’AIDE À L’ÉDUCATION BRUTE",null,null,"EXIGENCES GLOBALES\n(1)","% À REMETTRE\n(2)","À CE JOUR  (3)","MOIS ANTÉRIEURS \n(4)","MOIS COURANT \n(5)"]
["Taxe d’aide à l’éducation",null,null,null,null,null,null,{"$f":"E22","v":0},{"$f":"IF(S3=1,1,G16)","v":""},{"$f":"IF(I22=\"\",\"\",H22*I22)","v":""},null,{"$f":"IF(J22=\"\",\"\",J22-K22)","v":""}]
[]
["Division scolaire",null,null,null,"TAXE SPÉCIALE BRUTE","CRÉDIT D`IMPORT POUR L`AIDE À LA PROPRIÉTÉ","REMISE DE TAXE SCOLAIRE"]
[null,null,null,null,null,null,null,{"$f":"E25-F25-G25","v":0},{"$f":"IF(ISBLANK(A25)=TRUE,\"\",$I$22)","v":""},{"$f":"IF(I25=\"\",\"\",H25*I25)","v":""},null,{"$f":"IF(J25=\"\",\"\",J25-K25)","v":""}]
[null,null,null,null,null,null,null,{"$f":"E26-F26-G26","v":0},{"$f":"IF(ISBLANK(A26)=TRUE,\"\",$I$22)","v":""},{"$f":"IF(I26=\"\",\"\",H26*I26)","v":""},null,{"$f":"IF(J26=\"\",\"\",J26-K26)","v":""}]
[null,null,null,null,null,null,null,{"$f":"E27-F27-G27","v":0},{"$f":"IF(ISBLANK(A27)=TRUE,\"\",$I$22)","v":""},{"$f":"IF(I27=\"\",\"\",H27*I27)","v":""},null,{"$f":"IF(J27=\"\",\"\",J27-K27)","v":""}]
[null,null,null,null,null,null,null,{"$f":"E28-F28-G28","v":0},{"$f":"IF(ISBLANK(A28)=TRUE,\"\",$I$22)","v":""},{"$f":"IF(I28=\"\",\"\",H28*I28)","v":""},null,{"$f":"IF(J28=\"\",\"\",J28-K28)","v":""}]
[null,null,null,null,null,null,null,{"$f":"E29-F29-G29","v":0},{"$f":"IF(ISBLANK(A29)=TRUE,\"\",$I$22)","v":""},{"$f":"IF(I29=\"\",\"\",H29*I29)","v":""},null,{"$f":"IF(J29=\"\",\"\",J29-K29)","v":""}]
[]
["(1) Les « exigences globales » représentent les montants totaux devant être remis à chacune des administrations scolaires indiquées ci-dessus. Dans le cas de la taxe d’aide à l’éducation, c’est le montant total des remises indiqué dans le relevé de la taxe d’aide à l’éducation moins la remise de taxe scolaire. Quant à la taxe spéciale par division scolaire, le crédit d’impôt l`aide a la propriete ainsi que la remise de taxe scolaire auront été déduits du montant."]
[]
[]
[]
["(2) Le « % à remettre » constitue le pourcentage du montant global des taxes perçues jusqu’à ce jour pour l’année courante, suivant le calcul prévu à la section B. Pour le paiement final, si les taxes perçues sont inférieures à 100 % des taxes à percevoir, un pourcentage de 100 %  est indiqué  à des fins de remise."]
[]
[]
["(3) Les « à ce jour » représentent le montant total à remettre en fonction du pourcentage des taxes perçues au cours de la période courante."]
[]
["(4) Les « mois antérieurs » représentent les montants remis à chaque administration scolaire à ce jour."]
[]
["(5) Les « mois courant » représentent le montant dû pour la période courante qui doit être versé aux administrations scolaires avant la fin du mois suivant la date d’exigibilité. Dans le rapport final, les « exigences globales » doivent équivaloir au montant des « à ce jour ». Si le rapport final renvoie au mois se terminant le 31 décembre, le paiement doit être fait au plus tard le 31 janvier. "]
[]
[]
[]
["NOTE : le paiement final doit, dans tous les cas, être fait au plus tard à cette date."]
["Remise de la taxe d’aide à l’éducation faite à l’ordre de : Ministre des Finances et envoyer le paiement au : 1181, avenue Portage, bureau 51, Winnipeg (Manitoba) R3G 0T3"]
[]
[]
[null,"Je déclare vrai et exact le présent relevé."]
[]
[]
[null,"Date",null,null,null,null,null,null,"Administrateur municipal"]
[]
[]
["La présente formule est disponible sur Internet : http://www.edu.gov.mb.ca/k12/finance/forms/index.html"]