{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Instructions","Data Field Requirements","Student Codes","Data","L-School","Data Summary","Validation result","Sign off Approval","Contact","School Boards"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":9,"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","index":0,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,0,16,1],[5,3,5,19]]}
["Instructions"]
[]
["Student Reporting"]
[1,"Include one record per student with a unique ID. "]
[2,"Consortia are required to create a unique identifier for this data submission. The unique identifier should not be a number that relates to the identity of a student i.e., do not use the student ID number or OEN number. Consortia must keep a record of this ID and be able to use it to link back to the student record in the transportation database."]
[3,"Include all students for the member school boards in your geographic area that your consortia serves; this means both transported and non-transported students.\nNote: Consortia should report all students (transported or not) that fall within their jurisdiction or are travelling into and are attending schools within their jurisdiction.",null,"`"]
[4," For students with multiple addresses, (e.g. dual custody, child care, spec ed.), report the distance associated with the primary transportation address."]
[5,"All students should be coded based on the student categories provided.  If a student does not fit into any of the categories listed they should be classified as general."]
[]
["Data and Data Template"]
[1,"Data will be provided directly in this template."]
[2,"Data should be an extract of your current 2019-20 school year data as of October 31 2019.  "]
[3,"See the Data Field Requirements tab for detailed instructions for each field requested."]
[4,"Ensure that there are no blank records in the following fields: Unique ID, School Board, School Code, Grade, Postal Code, Distance(school of attendance), Student Code, Eligible, Transported, Out of Board District, Out of Catchment Area."]
[5,"An L-School tab has been created in the template to support additional details on school code/BSID/address. "]
[6,"Use the Data Entry Validation button on the 'Data' tab prior to submission to identify potential data errors (e.g., blanks or invalid values). Note that macros must be enabled for the data entry validation. Detail results of the data entry validation check can be viewed on the 'Validation result' tab."]
["If you have any questions, please contact your site analyst. Contact information is provided in the Contact Tab. "]

{"sheet":"Data Field Requirements","index":1,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,0,1,1],[16,0,16,1],[18,0,18,1]]}
["Data Field Requirements"]
["The data field requirement is the data extract from the transportation software. Please ensure that all data fields are provided based on the instructions and in the order included in the template."]
[]
["Field","Notes"]
["Unique ID","Consortia are required to create a unique identifier for this data submission. The unique identifier should not be a number that relates to the identity of a student i.e., do not use the student ID number or OEN number.\n\nConsortia must keep a record of this ID and be able to use it to link back to the student record in the transportation database."]
["School Board","Provide the 5-digit financial number for the board in which the students are attending school. (See XXXX tab for school board list).\n\nConsortia that transport Indigenous students from a Reserve to a member school board should also report these students. To do so, use the Board Financial #22222 and report the other fields as you would for other transported students.\n\nInclude Section 23 and Provincial School students with appropriate coding (see Student Categories tab)."]
["School Code","Student school of attendance.  Consortia may use the school BSID or the school code from the transportation system. If a school code is used, the L-School tab must be completed to match the school code to the school number in the Board School Identification Database (BSID)[1]"]
["Grade","Student grade (JK – 12) Valid inputs are: JK, SK, 1,2,3,4,5,6,7,8,9,10,11,12,NA"]
["Postal Code","Postal code for student’s primary transportation address"]
["Distance (school of attendance)","Distance from primary transportation address to school of attendance.  Distance unit will be in kilometers."]
["Student Code","See Student Categories tab "]
["Eligible","Y/N (Is student eligible for transportation by board policy)"]
["Transported","Y/N (Is student receiving transportation)"]
["Transit","Y/N (Is student receiving fully subsidized transit passes/tickets for transportation)"]
["Out of Board District","Y/N (Is student primary transportation address within board jurisdiction)"]
["Out of Catchment Area","Y/N (Is this the designated school for this student based on their address and program)"]
["[1] A full list of schools and Board School Identification Database (BSID) numbers are available through the Ontario data catalogue: https://www.ontario.ca/data/ontario-public-school-contact-information"]
[]
["If you have any questions, please contact your site analyst. Contact information is provided in the Contact Tab. "]

{"sheet":"Student Codes","index":2,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[20,0,20,2],[7,4,9,16]]}
["Classification Hierarchy;  Students should be classified in the following order:"]
["1. Students Excluded from GSN Calculation"]
["2. Transportation Requirement"]
["3. Student Type"]
[]
["Student Classification Category","Abbreviation/Code ","Definition"]
["Provincial School and Demonstration School Student","PS","Student enrolled in a provincial school."]
["Section 23","S23","Student enrolled in a program in Care and/or Treatment, Custody and Correctional (CTCC) Facilities"]
["Indigenous","IN","Indigenous student attending DSB school via tuition agreement."]
["International/Visa","VIN","International student paying tuition to attend public school"]
["Students over 21 years old","XX21","Student over 21 years of age"]
["Wheelchair Accessible","WC","Any student who requires a vehicle specifically adapted to allow wheelchair access; typically a vehicle equipped with lift for wheelchair. Could be a student in a wheelchair or student with other equipment or need requiring an adapted vehicle equipped with a lift. "]
["Special Transportation Needs (STN)","STN","Students requiring specialized transportation. (E.g. congregated and integrated spec ed students that require dedicated routes and/or vehicles, students that must ride alone, students that require an attendant on the vehicle, or any other special transportation needs). This is a transportation-related need and may not be applicable to all spec ed students (e.g. a student with an individualized education plan(IEP) but no additional transportation requirements)."]
["Hazard","HA","These students reside within the walk boundary but are eligible for transportation because the area within the walk boundary has been defined by the board as hazardous to walk to school for certain grades of students"]
["Courtesy","CO","These students are not eligible for transportation but are receiving transportation due to spare capacity on the vehicle. These do not include students that are eligible due to board exceptions (e.g. grandfathering). "]
["French Immersion (FI)","FI","These students attend a French  program (includes the Extended French programs and French Immersion)."]
["Gifted","GI","Students who attend gifted programs. "]
["Magnet","MA","Students who attend a choice school/program. (i.e. International Baccalaureate (IB), special arts, music, or technical programs) "]
["General ","GEN","These are students who do not have any special transportation needs and may or may not be eligible or receiving transportation services.  These do not include students attending French Immersion, \"Magnet\" programs, Gifted programs or STN  students. Any board approved exceptions, other than courtesy riders, such as grandfathered student should be included in this category."]

{"sheet":"Data","index":3,"n_rows":1,"n_cols":12,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Unique ID","School Board","School Code","Grade","Postal Code","Distance(school of attendance)","Student Code","Eligible","Transported","Transit","Out of Board District","Out of Catchment Area"]

{"sheet":"L-School","index":4,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Note: A full list of schools and Board School Identification Database (BSID) numbers are available through the Ontario data catalogue: "]
["https://www.ontario.ca/data/ontario-public-school-contact-information"]
[]
["School code","BSID Number","Full School Name","School Address"]

{"sheet":"Data Summary","index":5,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Consortia Name"]
[null,null,"Total Student Summary"]
[null,"Board Financial #","School Board","Total Number of Schools","Total Number of Students"," Transported Students"," Non-transported Students"]
[null,null,{"$f":"_xlfn.IFNA(VLOOKUP($B5, 'School Boards'!$A$2:$C$73, 3, FALSE), \"\")","v":""},null,{"$f":"IF($B5<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B5), \"\")","v":""},{"$f":"IF($B5<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B5, INDIRECT(\"Data!$I:$I\"), \"Y\"), \"\")","v":""},{"$f":"IF($B5<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B5, INDIRECT(\"Data!$I:$I\"), \"N\"), \"\")","v":""}]
[null,null,{"$f":"_xlfn.IFNA(VLOOKUP($B6, 'School Boards'!$A$2:$C$73, 3, FALSE), \"\")","v":""},null,{"$f":"IF($B6<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B6), \"\")","v":""},{"$f":"IF($B6<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B6, INDIRECT(\"Data!$I:$I\"), \"Y\"), \"\")","v":""},{"$f":"IF($B6<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B6, INDIRECT(\"Data!$I:$I\"), \"N\"), \"\")","v":""}]
[null,null,{"$f":"_xlfn.IFNA(VLOOKUP($B7, 'School Boards'!$A$2:$C$73, 3, FALSE), \"\")","v":""},null,"","",""]
[null,null,{"$f":"_xlfn.IFNA(VLOOKUP($B8, 'School Boards'!$A$2:$C$73, 3, FALSE), \"\")","v":""},null,"","",""]
[null,null,{"$f":"_xlfn.IFNA(VLOOKUP($B9, 'School Boards'!$A$2:$C$73, 3, FALSE), \"\")","v":""},null,"","",""]
[null,null,{"$f":"_xlfn.IFNA(VLOOKUP($B10, 'School Boards'!$A$2:$C$73, 3, FALSE), \"\")","v":""},null,"","",""]
[null,null,"Consortium Total",{"$f":"SUM(D5:D10)","v":0},{"$f":"SUM(E5:E10)","v":0},0,0]
[]
[null,null,"Student Summary by Type (Transported and Non-Transported Students)"]
[null,"Board Financial #","School Board","Non GSN Students*","Wheelchair Accessible","Special Transportation Needs (STN)","Hazard","Courtesy","French Immersion (FI)*","Gifted*","Magnet*","General *"]
[null,null,{"$f":"C5","v":""},{"$f":"IF($B15<>\"\",\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B15, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$7) +\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B15, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$8) +\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B15, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$9) +\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B15, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$10) +\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B15, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$11), \"\")","v":""},{"$f":"IF($B15<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B15, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$12), \"\")","v":""},{"$f":"IF($B15<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B15, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$13), \"\")","v":""},{"$f":"IF($B15<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B15, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$14), \"\")","v":""},{"$f":"IF($B15<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B15, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$15), \"\")","v":""},{"$f":"IF($B15<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B15, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$16), \"\")","v":""},{"$f":"IF($B15<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B15, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$17), \"\")","v":""},{"$f":"IF($B15<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B15, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$18), \"\")","v":""},{"$f":"IF($B15<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B15, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$19), \"\")","v":""}]
[null,null,{"$f":"C6","v":""},{"$f":"IF($B16<>\"\",\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B16, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$7) +\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B16, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$8) +\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B16, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$9) +\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B16, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$10) +\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B16, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$11), \"\")","v":""},{"$f":"IF($B16<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B16, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$12), \"\")","v":""},{"$f":"IF($B16<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B16, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$13), \"\")","v":""},{"$f":"IF($B16<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B16, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$14), \"\")","v":""},{"$f":"IF($B16<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B16, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$15), \"\")","v":""},{"$f":"IF($B16<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B16, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$16), \"\")","v":""},{"$f":"IF($B16<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B16, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$17), \"\")","v":""},{"$f":"IF($B16<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B16, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$18), \"\")","v":""},{"$f":"IF($B16<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B16, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$19), \"\")","v":""}]
[null,null,"",{"$f":"IF($B17<>\"\",\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B17, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$7) +\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B17, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$8) +\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B17, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$9) +\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B17, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$10) +\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B17, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$11), \"\")","v":""},{"$f":"IF($B17<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B17, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$12), \"\")","v":""},{"$f":"IF($B17<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B17, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$13), \"\")","v":""},{"$f":"IF($B17<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B17, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$14), \"\")","v":""},{"$f":"IF($B17<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B17, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$15), \"\")","v":""},{"$f":"IF($B17<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B17, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$16), \"\")","v":""},{"$f":"IF($B17<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B17, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$17), \"\")","v":""},{"$f":"IF($B17<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B17, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$18), \"\")","v":""},{"$f":"IF($B17<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B17, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$19), \"\")","v":""}]
[null,null,"",{"$f":"IF($B18<>\"\",\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B18, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$7) +\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B18, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$8) +\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B18, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$9) +\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B18, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$10) +\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B18, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$11), \"\")","v":""},{"$f":"IF($B18<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B18, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$12), \"\")","v":""},{"$f":"IF($B18<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B18, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$13), \"\")","v":""},{"$f":"IF($B18<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B18, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$14), \"\")","v":""},{"$f":"IF($B18<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B18, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$15), \"\")","v":""},{"$f":"IF($B18<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B18, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$16), \"\")","v":""},{"$f":"IF($B18<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B18, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$17), \"\")","v":""},{"$f":"IF($B18<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B18, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$18), \"\")","v":""},{"$f":"IF($B18<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B18, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$19), \"\")","v":""}]
[null,null,"",{"$f":"IF($B19<>\"\",\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B19, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$7) +\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B19, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$8) +\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B19, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$9) +\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B19, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$10) +\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B19, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$11), \"\")","v":""},{"$f":"IF($B19<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B19, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$12), \"\")","v":""},{"$f":"IF($B19<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B19, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$13), \"\")","v":""},{"$f":"IF($B19<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B19, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$14), \"\")","v":""},{"$f":"IF($B19<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B19, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$15), \"\")","v":""},{"$f":"IF($B19<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B19, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$16), \"\")","v":""},{"$f":"IF($B19<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B19, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$17), \"\")","v":""},{"$f":"IF($B19<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B19, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$18), \"\")","v":""},{"$f":"IF($B19<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B19, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$19), \"\")","v":""}]
[null,null,"",{"$f":"IF($B20<>\"\",\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B20, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$7) +\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B20, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$8) +\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B20, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$9) +\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B20, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$10) +\nCOUNTIFS(INDIRECT(\"Data!$B:$B\"), $B20, INDIRECT(\"Data!$G:$G\"), \"=\"&'Student Codes'!$B$11), \"\")","v":""},{"$f":"IF($B20<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B20, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$12), \"\")","v":""},{"$f":"IF($B20<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B20, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$13), \"\")","v":""},{"$f":"IF($B20<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B20, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$14), \"\")","v":""},{"$f":"IF($B20<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B20, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$15), \"\")","v":""},{"$f":"IF($B20<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B20, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$16), \"\")","v":""},{"$f":"IF($B20<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B20, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$17), \"\")","v":""},{"$f":"IF($B20<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B20, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$18), \"\")","v":""},{"$f":"IF($B20<>\"\", COUNTIFS(INDIRECT(\"Data!$B:$B\"), $B20, INDIRECT(\"Data!$G:$G\"), 'Student Codes'!$B$19), \"\")","v":""}]
[null,null,"Consortium Total",{"$f":"SUM(D15:D20)","v":0},{"$f":"SUM(E15:E20)","v":0},0,0,0,0,0,0,0]
[]
[null,null,"* Includes: Provincial and Demonstration Schools, Section 23, Indigenous, International/Visa, Students over 21 years old"]

{"sheet":"Validation result","index":6,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,"# of students without  ID","# of students without  board ID","# of students without  school ID","# of students without grade","# of students without distance or with non-numeric distance","# of students without student code","# of students with blanks in columns H to L","# of students without postal code"]
[null,0,0,0,0,0,0,0,0]
[null,"# of  duplicate  student IDs","# of invalid board IDs","# of invalid school IDs","# of invalid student grade","# of students with negative distance","# of students with invalid student code","# of students with invalid y/n code in columns  H to L","# of postal codes that are not 6 digits or the second digit is not numeric"]
[null,null,null,null,null,0,null,null,0]
[null,"Duplicate student ID list","Invalid board ID list","Invalid school ID list","Invalid student grade list","# of students with distance over 200","Invalid student code list","Invalid y/n code list in columns  H to L","List of postal codes that are not 6 digits or the second digit is not numeric"]
[null,null,null,null,null,0]

{"sheet":"Sign off Approval","index":7,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[[15,1,15,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[13,1,13,3],[14,1,14,3],[12,1,12,3],[0,1,0,5],[1,1,1,5],[3,2,3,5],[5,2,5,5],[7,1,7,3],[7,4,7,5]]}
[null,"Student Transportation Funding Formula Review"]
[null,"Student and Distance Data Submission"]
[]
[null,"Consortium Name:"]
[]
[null,"Date:"]
[]
[null,"Member School Boards"]
[null,null,null,null,"Number of Schools","Number of Students"]
[null,{"$f":"'Data Summary'!$C5","v":""},null,null,{"$f":"IF(B10<>\"\", 'Data Summary'!$D5, \"\")","v":""},{"$f":"'Data Summary'!$E5","v":""},"  "]
[null,{"$f":"'Data Summary'!$C6","v":""},null,null,{"$f":"IF(B11<>\"\", 'Data Summary'!$D6, \"\")","v":""},{"$f":"'Data Summary'!$E6","v":""},"  "]
[null,{"$f":"'Data Summary'!$C7","v":""},null,null,{"$f":"IF(B12<>\"\", 'Data Summary'!$D7, \"\")","v":""},{"$f":"'Data Summary'!$E7","v":""},"  "]
[null,{"$f":"'Data Summary'!$C8","v":""},null,null,{"$f":"IF(B13<>\"\", 'Data Summary'!$D8, \"\")","v":""},{"$f":"'Data Summary'!$E8","v":""}]
[null,{"$f":"'Data Summary'!$C8","v":""},null,null,{"$f":"IF(B14<>\"\", 'Data Summary'!$D9, \"\")","v":""},{"$f":"'Data Summary'!$E9","v":""},"  "]
[null,{"$f":"'Data Summary'!$C10","v":""},null,null,{"$f":"IF(B15<>\"\", 'Data Summary'!$D10, \"\")","v":""},{"$f":"'Data Summary'!$E10","v":""},"  "]
[null,"Consortium Total",null,null,{"$f":"SUM(E10:E15)","v":0},{"$f":"SUM(F10:F15)","v":0}]
[]
[]
[]
[]
[null,"Signatures Required:"]
[]
[]
[]
[]
[]
[null,"Director of Education",null,null,null,"Director of Education"]
[null,"[Enter Name]",null,null,null,"[Enter Name]"]
[null,{"$f":"$B$10","v":""},null,null,null,{"$f":"$B$11","v":""}]
[]
[]
[]
[]
[]
[null,"Director of Education",null,null,null,"Director of Education"]
[null,"[Enter Name]",null,null,null,"[Enter Name]"]
[null,{"$f":"$B$12","v":""},null,null,null,{"$f":"$B$13","v":""}]
[]
[]
[]
[]
[]
[null,"Director of Education",null,null,null,"Consortium Manager"]
[null,"[Enter Name]",null,null,null,"[Enter Name]"]
[null,{"$f":"$B$14","v":""},null,null,null,{"$f":"$B$15","v":""}]

{"sheet":"Contact","index":8,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Consortium#","Consortium Name","Portfolio Analyst ","Email","Phone"]
["Column1","Column2","Column3","Column4","Column5"]
[1,"Windsor-Essex Student Transportation Services/Service de transport des élèves – Windsor-Essex","Christine","Christine.Kouremenos@ontario.ca","(416) 212-3178"]
[2,"Chatham Kent & Lambton Administrative School Services (C.L.A.S.S.)","Christine","Christine.Kouremenos@ontario.ca","(416) 212-3178"]
[3,"Southwestern Ontario Student Transportation Services","Christine","Christine.Kouremenos@ontario.ca","(416) 212-3178"]
[4,"Huron Perth Student Transportation Services","Christine","Christine.Kouremenos@ontario.ca","(416) 212-3178"]
[5,"Student Transportation Service Consortium of Grey-Bruce","Christine","Christine.Kouremenos@ontario.ca","(416) 212-3178"]
[6,"Student Transportation Services of Brant Haldimand Norfolk","Vanissa","Vanissa.Szeto@ontario.ca","(416) 325-4906"]
[7,"Student Transportation Services of Waterloo Region (STSWR)","Christine","Christine.Kouremenos@ontario.ca","(416) 212-3178"]
[8,"Niagara Student Transportation Services","Vanissa","Vanissa.Szeto@ontario.ca","(416) 325-4906"]
[9,"Hamilton-Wentworth Student Transportation Services (HWSTS)","Christine","Christine.Kouremenos@ontario.ca","(416) 212-3178"]
[10,"Service de transport de Wellington - Dufferin Student Transportation Services","Christine","Christine.Kouremenos@ontario.ca","(416) 212-3178"]
[11,"Halton Student Transportation Services ","Nancy","Nancy.Huynh@ontario.ca","416-326-6181"]
[12,"Student Transportation of Peel Region","Nancy","Nancy.Huynh@ontario.ca","416-326-6181"]
[13,"Toronto Student Transportation Group ","Vanissa","Vanissa.Szeto@ontario.ca","(416) 325-4906"]
[14,"Student Transportation Services of York Region","Nancy","Nancy.Huynh@ontario.ca","416-326-6181"]
[15,"Simcoe County Student Transportation Consortium","Nancy","Nancy.Huynh@ontario.ca","416-326-6181"]
[16,"Durham Student Transportation Services","Vanissa","Vanissa.Szeto@ontario.ca","(416) 325-4906"]
[17,"Trillium Lakelands District School Board","Nancy","Nancy.Huynh@ontario.ca","416-326-6181"]
[18,"Student Transportation Services of Central Ontario","Vanissa","Vanissa.Szeto@ontario.ca","(416) 325-4906"]
[19,"Tri-board Student Transportation Services","Vanissa","Vanissa.Szeto@ontario.ca","(416) 325-4906"]
[20,"Renfrew County Joint Transportation Consortium","Sarah","Sarah.Guarino@ontario.ca","(416)314-3465"]
[21,"Student Transportation of Eastern Ontario (STEO)","Vanissa","Vanissa.Szeto@ontario.ca","(416) 325-4906"]
[22,"Ottawa Student Transportation Authority","Sarah","Sarah.Guarino@ontario.ca","(416)314-3465"]
[23,"Nipissing Parry-Sound Student Transportation Services/Services de transport scolaire Nipissing-Parry Sound","Vanissa","Vanissa.Szeto@ontario.ca","(416) 325-4906"]
[24,"North East Tri-Board Student Transportation","Vanissa","Vanissa.Szeto@ontario.ca","(416) 325-4906"]
[25,"Sudbury Student Services Consortium/Consortium de services aux élèves de Sudbury","Nancy","Nancy.Huynh@ontario.ca","416-326-6181"]
[26,"Algoma & Huron Superior Transportation Services","Sarah","Sarah.Guarino@ontario.ca","(416)314-3465"]
[27,"East of Thunder Bay Transportation Consortium","Sarah","Sarah.Guarino@ontario.ca","(416)314-3465"]
[28,"Student Transportation  Services of Thunder Bay","Sarah","Sarah.Guarino@ontario.ca","(416)314-3465"]
[29,"Rainy River District Transportation Services Consortium","Sarah","Sarah.Guarino@ontario.ca","(416)314-3465"]
[30,"Northwestern Ontario Student Services Consortium","Sarah","Sarah.Guarino@ontario.ca","(416)314-3465"]
[31,"Service de transport Francobus","Nancy","Nancy.Huynh@ontario.ca","416-326-6181"]
[32,"Consortium de transport scolaire de l'Est","Sarah","Sarah.Guarino@ontario.ca","(416)314-3465"]
[33,"Consortium de Transport Scolaire d'Ottawa","Sarah","Sarah.Guarino@ontario.ca","(416)314-3465"]
[34,"CSD catholique des Grandes Rivières","Vanissa","Vanissa.Szeto@ontario.ca","(416) 325-4906"]

{"sheet":"School Boards","index":9,"n_rows":74,"n_cols":12,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
["DSB_ID","DSB_NO","Board Names","NorthSouth","UrbanRural","Support","Language","Region",null,"Grade List","Long distance","Language"]
[28002,1,"DSB Ontario North East","North","Northern Ont rural/urban","Public","English","North East",null,"JK",200,"English"]
[28010,2,"Algoma DSB","North","Northern Ont rural/urban","Public","English","North East",null,"SK",null,"change to \"French\" in french version "]
[28029,3,"Rainbow DSB","North","Northern Ont rural/urban","Public","English","North East",null,1,null,"and hide columns J to L"]
[28037,4,"Near North DSB","North","Northern Ont rural/urban","Public","English","North East",null,2]
[28045,5.0999999999999996,"Keewatin-Patricia DSB","North","Northern Ont rural","Public","English","North West",null,3]
[28053,5.2,"Rainy River DSB","North","Northern Ont rural","Public","English","North West",null,4]
[28061,6.1,"Lakehead DSB","North","Northern Ont rural/urban","Public","English","North West",null,5]
[28070,6.2,"Superior-Greenstone DSB","North","Northern Ont rural","Public","English","North West",null,6]
[66001,7,"Bluewater DSB","South","Southern Ont rural","Public","English","South West",null,7]
[66010,8,"Avon Maitland DSB","South","Southern Ont rural","Public","English","South West",null,8]
[66028,9,"Greater Essex County DSB","South","Southern Ont rural/urban","Public","English","South West",null,9]
[66036,10,"Lambton Kent DSB","South","Southern Ont rural/urban","Public","English","South West",null,10]
[66044,11,"Thames Valley DSB","South","Southern Ont rural/urban","Public","English","South West",null,11]
[66052,12,"Toronto DSB","South","Urban - Toronto boards","Public","English","GTA",null,12]
[66060,13,"Durham DSB","South","Suburban - GTA excluding French boards","Public","English","GTA",null,"NA"]
[66079,14,"Kawartha Pine Ridge DSB","South","Southern Ont rural/urban","Public","English","Central"]
[66087,15,"Trillium Lakelands DSB","South","Southern Ont rural","Public","English","Central"]
[66095,16,"York Region DSB","South","Suburban - GTA excluding French boards","Public","English","GTA"]
[66109,17,"Simcoe County DSB","South","Southern Ont rural/urban","Public","English","Central"]
[66117,18,"Upper Grand DSB","South","Southern Ont rural/urban","Public","English","Central"]
[66125,19,"Peel DSB","South","Suburban - GTA excluding French boards","Public","English","GTA"]
[66133,20,"Halton DSB","South","Suburban - GTA excluding French boards","Public","English","GTA"]
[66141,21,"Hamilton-Wentworth DSB","South","Southern Ont rural/urban","Public","English","Central"]
[66150,22,"DSB of Niagara","South","Southern Ont rural/urban","Public","English","Central"]
[66168,23,"Grand Erie DSB","South","Southern Ont rural/urban","Public","English","Central"]
[66176,24,"Waterloo Region DSB","South","Southern Ont rural/urban","Public","English","Central"]
[66184,25,"Ottawa-Carleton DSB","South","Southern Ont rural/urban","Public","English","East"]
[66192,26,"Upper Canada DSB","South","Southern Ont rural","Public","English","East"]
[66206,27,"Limestone DSB","South","Southern Ont rural/urban","Public","English","East"]
[66214,28,"Renfrew County DSB","South","Southern Ont rural","Public","English","East"]
[66222,29,"Hastings & Prince Edward DSB","South","Southern Ont rural/urban","Public","English","East"]
[29009,30.1,"Northeastern Catholic DSB","North","Northern Ont rural/urban","Separate","English","North East"]
[29017,30.2,"Nipissing-Parry Sound Cath DSB","North","Northern Ont rural/urban","Separate","English","North East"]
[29025,31,"Huron-Superior Catholic DSB","North","Northern Ont rural/urban","Separate","English","North East"]
[29033,32,"Sudbury Catholic DSB","North","Northern Ont rural/urban","Separate","English","North East"]
[29041,33.1,"Northwest Catholic DSB","North","Northern Ont rural","Separate","English","North West"]
[29050,33.200000000000003,"Kenora Catholic DSB","North","Northern Ont rural","Separate","English","North West"]
[29068,34.1,"Thunder Bay Catholic DSB","North","Northern Ont rural/urban","Separate","English","North West"]
[29076,34.200000000000003,"Superior North Catholic DSB","North","Northern Ont rural","Separate","English","North West"]
[67008,35,"Bruce-Grey Catholic DSB","South","Southern Ont rural","Separate","English","South West"]
[67016,36,"Huron-Perth Catholic DSB","South","Southern Ont rural","Separate","English","South West"]
[67024,37,"Windsor-Essex Catholic DSB","South","Southern Ont rural/urban","Separate","English","South West"]
[67032,38,"London Dist. Catholic School","South","Southern Ont rural/urban","Separate","English","South West"]
[67040,39,"St. Clair Catholic DSB","South","Southern Ont rural/urban","Separate","English","South West"]
[67059,40,"Toronto Catholic DSB","South","Urban - Toronto boards","Separate","English","GTA"]
[67067,41,"PVNC Catholic DSB","South","Southern Ont rural/urban","Separate","English","Central"]
[67075,42,"York Catholic DSB","South","Suburban - GTA excluding French boards","Separate","English","GTA"]
[67083,43,"Dufferin-Peel Catholic DSB","South","Suburban - GTA excluding French boards","Separate","English","GTA"]
[67091,44,"Simcoe Muskoka Catholic DSB","South","Southern Ont rural/urban","Separate","English","Central"]
[67105,45,"Durham Catholic DSB","South","Suburban - GTA excluding French boards","Separate","English","GTA"]
[67113,46,"Halton Catholic DSB","South","Suburban - GTA excluding French boards","Separate","English","GTA"]
[67121,47,"Hamilton-Wentworth Cath DSB","South","Southern Ont rural/urban","Separate","English","Central"]
[67130,48,"Wellington Catholic DSB","South","Southern Ont rural/urban","Separate","English","Central"]
[67148,49,"Waterloo Catholic DSB","South","Southern Ont rural/urban","Separate","English","Central"]
[67156,50,"Niagara Catholic DSB","South","Southern Ont rural/urban","Separate","English","Central"]
[67164,51,"Brant Haldimand Norfolk CDSB","South","Southern Ont rural/urban","Separate","English","Central"]
[67172,52,"Cath DSB of Eastern Ontario","South","Southern Ont rural","Separate","English","East"]
[67180,53,"Ottawa Catholic DSB","South","Southern Ont rural/urban","Separate","English","East"]
[67199,54,"Renfrew County Catholic DSB","South","Southern Ont rural","Separate","English","East"]
[67202,55,"Algonquin & Lakeshore Cath DSB","South","Southern Ont rural/urban","Separate","English","East"]
[28100,56,"CSD du Nord-Est de l'Ontario","North","Northern Ont rural/urban","Public","French","North East"]
[28118,57,"CSP du Grand Nord de l'Ontario","North","Northern Ont rural/urban","Public","French","North East"]
[66303,58,"Conseil scolaire Viamonde","South","Southern Ont rural/urban","Public","French","GTA"]
[66311,59,"CEP de l'Est de l'Ontario","South","Southern Ont rural/urban","Public","French","East"]
[29106,60.1,"CSD cath. des Grandes Rivières","North","Northern Ont rural","Separate","French","North East"]
[29114,60.2,"CSD catholique Franco-Nord","North","Northern Ont rural/urban","Separate","French","North East"]
[29122,61,"CSD cath. du Nouvel-Ontario","North","Northern Ont rural/urban","Separate","French","North East"]
[29130,62,"CSD cath. des Aurores boréales","North","Northern Ont rural/urban","Separate","French","North West"]
[67300,63,"CSC Providence","South","Southern Ont rural/urban","Separate","French","South West"]
[67318,64,"CSC MonAvenir","South","Southern Ont rural/urban","Separate","French","GTA"]
[67326,65,"CSD cath. de l'Est ontarien","South","Southern Ont rural","Separate","French","East"]
[67334,66,"CSD cath. Centre-Est de l'Ont.","South","Southern Ont rural/urban","Separate","French","East"]
[22222,99,"Indigenous Students","N/A","N/A","N/A","N/A","N/A"]