{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions (Part B)","Option 1 (Part B)","Option 2 (Part B)","Option 3 (Part B)","Instructions (Preschool)","Option 1 (Preschool)","Option 2 (Preschool)","Option 3 (Preschool)"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":6,"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 (Part B)","index":0,"n_rows":77,"n_cols":4,"rows_kept":77,"cut":false,"hidden":false,"merged":[[76,2,76,10],[22,5,22,7],[74,2,74,10],[38,12,38,13],[42,2,42,10],[36,2,36,6],[3,1,3,7],[26,2,26,16],[28,3,28,16],[30,3,30,16],[32,3,32,16],[20,5,20,7],[13,2,13,7],[15,5,15,7],[16,5,16,7],[19,5,19,7],[24,2,24,16],[7,1,7,16],[5,3,5,16],[34,2,34,10],[34,12,34,13],[40,2,40,10],[38,2,38,10]]}
[null,"INSTRUCTIONS FOR SPECIAL EDUCATION, PART B (611)"]
[null,null,"ASSISTANCE LISTING NUMBER (ALN) 84.027"]
[]
[null,"DUE DATE: 7/31/2025"]
[]
[null,"BEGIN HERE: ",null,"PLEASE READ ALL INSTRUCTIONS BELOW IN THEIR ENTIRETY VERY CAREFULLY PRIOR TO STARTING, AS MOST QUESTIONS YOU MAY HAVE WILL BE ANSWERED WITHIN THESE INSTRUCTIONS.\nInstructions for saving your worksheet are included below in Step 6."]
[]
[null,"NOTE: If you have a yellow bar up above that says \"Security Warning\" with a white button that says \"Enable Content,\" you MUST click the white \"Enable Content\" button for this worksheet to function properly. You must do this before beginning the worksheet. If you do not, this worksheet will not function as intended. "]
[]
[null,"NOTE: The blue boxes below and within this worksheet are for you to enter information."]
[]
[]
[null,"1.","Name of Special Education Cooperative, Joint Service or Interlocal: "]
[]
[]
[null,"2.","Name of Person Completing Form:"]
[null,null,"Title of Person:"]
[]
[null,null,"Contact Information"]
[null,null,"Email Address:"]
[null,null,"Phone Number:"]
[]
[null,null,"Date of Completion: "]
[]
[null,"3.","Read each of the three options below carefully."]
[]
[null,null,"ONLY ONE of the following options will apply to your Cooperative, Joint Service or Interlocal. The options presented determine the allocation for Special Education, Part B (ALN 84.027) funds to member schools based on the way your cooperative operates."]
[]
[null,null,"Option 1:","(a) Use this tab if your cooperative allows the member schools to spend the Part B grant funds and request reimbursement from the fiscal agent, who then will request reimbursement from IDOE.  Once IDOE reimburses the grant funds, the fiscal agent disburses the monies back to the member schools.  If this is how your cooperative operates, the amounts received and disbursed by each member school for a specified school year will appear on their respective Grant Schedule within Gateway.\n\n  OR\n\n(b) Use this tab if the fiscal agent of the cooperative spends all the Part B grant funds on behalf of the member schools AND the accounting records, both receipts and disbursements, are broken out and can be separately identified for each member school.  Receipts and disbursements must be specifically designated to a particular member school; these amounts for each member school for a specified school year will appear on their respective Grant Schedule within Gateway.\n\n  OR\n\n(c) Use this tab if the cooperative operates based on a combination of the two methods above, Option1(a) and Option1(b).  Actual receipts and expenditures must be specifically designated to a particular member school, and not based on an estimated allocation."]
[]
[null,null,"Option 2:","Use this tab if the fiscal agent of the cooperative spends all the Part B grant funds on behalf of the member schools AND the accounting records, both receipts and disbursements, are not broken out by each member school.  The fiscal agent will have to reasonably allocate the receipts and disbursements for the year to each of the member schools.  Examples of ways to reasonably allocate receipts and disbursements to each member school include: (1) allocating based on the percent of children served at each member school using a consistent date; (2) allocating based on the percentage of the member school's original allocation in relation to the cooperative's original allocation; (3) any other reasonable way as long as it is documented for audit by the SBOA.  The member schools will use the amounts provided by this allocation method for inclusion in their respective Grant Schedule within Gateway."]
[]
[null,null,"Option 3:","Use this tab if the member schools can spend the Part B grant funds and request reimbursement OR the cooperative spends all the Part B grant funds on behalf of the schools but has accounting records, both receipts and disbursements, broken out by each member school AND the fiscal agent of the cooperative also spends Part B grant funds on behalf of the member schools but does not have accounting records broken out to assign receipts and disbursements by member school.  The member schools will use the amounts disbursed and reimbursed by the member school in addition to an allocated amount provided to each member school by the fiscal agent for inclusion in their respective Grant Schedule within Gateway."]
[]
[null,"4.","Which of the three options above describes the way your Cooperative, Joint Service or Interlocal operates the Part B funds?\n    [Once you make your selection, the appropriate tab will then become visible for you to complete.]"]
[]
[null,null,{"$f":"IF(M35=\"\",\"\",IF(M35=\"Option 1\",\"You will need to complete the provided Option 1 (Part B) tab.\",IF(M35=\"Option 2\",\"You will need to complete the provided Option 2 (Part B) tab.\",\"You will need to complete the provided Option 3 (Part B) tab.\")))","v":""}]
[]
[null,"5.","Does your Cooperative, Joint Service or Interlocal also have Preschool awards?"]
[]
[null,null,{"$f":"IF(M39=\"\",\"\",IF(M39=\"Yes\",\"Proceed to the 'Instructions (Preschool)' tab before continuing to Step 6 below.\",\"Continue to Step 6 below.\"))","v":""}]
[]
[null,"6.","SAVING YOUR WORKSHEET AFTER COMPLETION - IMPORTANT - DO NOT SKIP THIS STEP!"]
[]
[null,null,{"$f":"IF(M39=\"\",\"\",IF(M39=\"Yes\",\"When you have completed the appropriate tabs for both, Part B and Preschool, you MUST follow the below steps to save your worksheet:\",\"When you have completed the appropriate Part B tab, you MUST follow the below steps to save your worksheet:\"))","v":""}]
[null,null,"6a. Click \"File\" > \"Save a Copy\""]
[null,null,"6b. Choose the location you would like to save your worksheet (i.e., your Desktop)."]
[null,null,"6c. You must change the file extension type (\"Save as type\") from an 'Excel Macro-Enabled Workbook (*.xlsm)' to an 'Excel Workbook (*.xlsx).'"]
[]
[null,null,"Original file extension type:"]
[]
[]
[]
[]
[]
[null,null,"New file extension type:"]
[]
[]
[]
[]
[null,null,"6d. Click \"Save.\""]
[null,null,"6e. A gray pop-up box as shown below may appear for you. If it does, click \"Save.\" "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"7.","Upload this file to Gateway along with the additional documentation as now required under Amended State Examiner Directive 2018-1 (Amended April 2025). All documentation is required to be uploaded by July 31st."]
[]
[null,"8.","Send a copy of this FY2025 Allocation Form to each of your member schools, so each may complete its own Grant Schedule within Gateway."]

{"sheet":"Option 1 (Part B)","index":1,"n_rows":79,"n_cols":7,"rows_kept":79,"cut":false,"hidden":true,"merged":[[75,2,75,4],[76,2,76,4],[77,2,77,4],[55,2,55,4],[56,2,56,4],[57,2,57,4],[58,2,58,4],[59,2,59,4],[65,2,65,4],[66,2,66,4],[62,1,62,6],[64,1,64,3],[72,2,72,4],[73,2,73,4],[74,2,74,4],[67,2,67,4],[26,1,26,6],[17,5,17,7],[28,1,28,3],[29,2,29,4],[54,2,54,4],[44,1,44,6],[46,1,46,3],[47,2,47,4],[48,2,48,4],[49,2,49,4],[19,5,19,7],[50,2,50,4],[51,2,51,4],[52,2,52,4],[53,2,53,4],[30,2,30,4],[5,1,5,7],[10,2,10,7],[12,5,12,7],[13,5,13,7],[16,5,16,7],[31,2,31,4],[32,2,32,4],[33,2,33,4],[39,2,39,4],[40,2,40,4],[34,2,34,4],[35,2,35,4],[36,2,36,4],[37,2,37,4],[38,2,38,4],[68,2,68,4],[69,2,69,4],[70,2,70,4],[71,2,71,4],[41,2,41,4]]}
["Expenditure Report of Federal Dollars for Member School SEFA Completion"]
[]
[null,"SPECIAL EDUCATION, PART B (611)"]
[null,null,"ASSISTANCE LISTING NUMBER (ALN) 84.027"]
[]
[null,"DUE DATE: 7/31/2025"]
[]
[null,"Ensure items in 1. and 2. below are correct before continuing to section 3. below."]
[]
[null,"1.","Name of Special Education Cooperative, Joint Service or Interlocal: "]
[null,null,{"$f":"'Instructions (Part B)'!C14","v":0}]
[]
[null,"2.","Name of Person Completing Form:",null,null,{"$f":"'Instructions (Part B)'!F16","v":0}]
[null,null,"Title of Person:",null,null,{"$f":"'Instructions (Part B)'!F17","v":0}]
[]
[null,null,"Contact Information"]
[null,null,"Email Address:",null,null,{"$f":"'Instructions (Part B)'!F20","v":0}]
[null,null,"Phone Number:",null,null,{"$f":"'Instructions (Part B)'!F21","v":0}]
[]
[null,null,"Date of Completion: ",null,null,{"$f":"'Instructions (Part B)'!F23","v":"00:00:00"}]
[]
[null,"3.","Please fill in the blue boxes."]
[null,null,"- Enter the name and the corporation number of each member school."]
[null,null,"- Enter the Part B grant award number assigned to the group."]
[null,null,"- Enter all actual expenditures and reimbursements for each member school for the time period noted."]
[]
[null,"FY 2023 Federal Part B (611) Grant Totals"]
[]
[null,"Grant Award Identifying Number:",null,null,"23611-___-PN01","Expenditures","Reimbursements"]
[null,"Corp #","Member School Name",null,null,"07/01/24 - 06/30/25","07/01/24 - 06/30/25"]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,"Grand Totals",null,null,{"$f":"SUBTOTAL(9,F31:F42)","v":0},{"$f":"SUBTOTAL(9,G31:G42)","v":0}]
[]
[null,"FY 2024 Federal Part B (611) Grant Totals"]
[]
[null,"Grant Award Identifying Number:",null,null,"24611-___-PN01","Expenditures","Reimbursements"]
[null,"Corp #","Member School Name",null,null,"07/01/24 - 06/30/25","07/01/24 - 06/30/25"]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,"Grand Totals",null,null,{"$f":"SUBTOTAL(9,F49:F60)","v":0},{"$f":"SUBTOTAL(9,G49:G60)","v":0}]
[]
[null,"FY 2025 Federal Part B (611) Grant Totals"]
[]
[null,"Grant Award Identifying Number:",null,null,"25611-___-PN01","Expenditures","Reimbursements"]
[null,"Corp #","Member School Name",null,null,"07/01/24 - 06/30/25","07/01/24 - 06/30/25"]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,"Grand Totals",null,null,{"$f":"SUBTOTAL(9,F67:F78)","v":0},{"$f":"SUBTOTAL(9,G67:G78)","v":0}]

{"sheet":"Option 2 (Part B)","index":2,"n_rows":85,"n_cols":9,"rows_kept":85,"cut":false,"hidden":true,"merged":[[82,2,82,4],[83,2,83,4],[84,2,84,4],[77,2,77,4],[78,2,78,4],[79,2,79,4],[80,2,80,4],[81,2,81,4],[72,2,72,4],[73,2,73,4],[74,2,74,4],[75,2,75,4],[76,2,76,4],[64,2,64,4],[65,2,65,4],[66,2,66,4],[68,1,68,8],[70,1,71,3],[70,4,71,4],[70,5,71,5],[70,6,71,6],[70,7,71,7],[70,8,71,8],[59,2,59,4],[60,2,60,4],[61,2,61,4],[62,2,62,4],[63,2,63,4],[54,2,54,4],[55,2,55,4],[56,2,56,4],[57,2,57,4],[58,2,58,4],[50,1,50,8],[52,1,53,3],[52,4,53,4],[52,5,53,5],[52,6,53,6],[52,7,53,7],[52,8,53,8],[48,2,48,4],[34,7,35,7],[34,8,35,8],[34,1,35,3],[34,4,35,4],[36,2,36,4],[37,2,37,4],[38,2,38,4],[39,2,39,4],[40,2,40,4],[41,2,41,4],[42,2,42,4],[43,2,43,4],[44,2,44,4],[45,2,45,4],[46,2,46,4],[47,2,47,4],[5,1,5,7],[10,2,10,7],[12,5,12,7],[13,5,13,7],[16,5,16,7],[17,5,17,7],[19,5,19,7],[21,5,21,7],[32,1,32,8],[34,5,35,5],[34,6,35,6],[23,2,23,8]]}
["Expenditure Report of Federal Dollars for Member School SEFA Completion"]
[]
[null,"SPECIAL EDUCATION, PART B (611)"]
[null,null,"ASSISTANCE LISTING NUMBER (ALN) 84.027"]
[]
[null,"DUE DATE: 7/31/2024"]
[]
[null,"Ensure items in 1. and 2. below are correct before continuing to question 3. below."]
[]
[null,"1.","Name of Special Education Cooperative, Joint Service or Interlocal: "]
[null,null,{"$f":"'Instructions (Part B)'!C14","v":0}]
[]
[null,"2.","Name of Person Completing Form:",null,null,{"$f":"'Instructions (Part B)'!F16","v":0}]
[null,null,"Title of Person:",null,null,{"$f":"'Instructions (Part B)'!F17","v":0}]
[]
[null,null,"Contact Information"]
[null,null,"Email Address:",null,null,{"$f":"'Instructions (Part B)'!F20","v":0}]
[null,null,"Phone Number:",null,null,{"$f":"'Instructions (Part B)'!F21","v":0}]
[]
[null,null,"Date of Completion: ",null,null,{"$f":"'Instructions (Part B)'!F23","v":"00:00:00"}]
[]
[null,"3.","Specify allocation method:"]
[null,null,"If \"Other\", please specify the allocation method in the box below:"]
[]
[]
[null,"4.","Please fill in the blue boxes."]
[null,null,"- Enter the Part B grant award number assigned to the group."]
[null,null,"- Enter the name and the corporation number of each member school."]
[null,null,"- Enter the grant award allocation amount for each member school based on the allocation method selected in Step 3 above."]
[null,null,"- Enter the total actual expenditures and reimbursements for the time period noted."]
[]
[]
[null,"FY 2023 Federal Part B (611) Grant Totals"]
[]
[null,"Grant Award Identifying Number:",null,null,"23611-___-PN01","Grant Allocation","Percent of Grant Award","Expenditures 07/01/24 - 06/30/25","Reimbursements 07/01/24 - 06/30/25"]
[]
[null,"Corp #","Member School Name",null,null,{"$f":"SUM(F38:F49)","v":0},{"$f":"SUM(G38:G49)","v":0},0,0]
[null,null,null,null,null,0,{"$f":"IF(F37=0,0,F38/F37)","v":0},{"$f":"H37*G38","v":0},{"$f":"I37*G38","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F37=0,0,F39/F37)","v":0},{"$f":"H37*G39","v":0},{"$f":"I37*G39","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F37=0,0,F40/F37)","v":0},{"$f":"H37*G40","v":0},{"$f":"I37*G40","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F37=0,0,F41/F37)","v":0},{"$f":"H37*G41","v":0},{"$f":"I37*G41","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F37=0,0,F42/F37)","v":0},{"$f":"H37*G42","v":0},{"$f":"I37*G42","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F37=0,0,F43/F37)","v":0},{"$f":"H37*G43","v":0},{"$f":"I37*G43","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F37=0,0,F44/F37)","v":0},{"$f":"H37*G44","v":0},{"$f":"I37*G44","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F37=0,0,F45/F37)","v":0},{"$f":"H37*G45","v":0},{"$f":"I37*G45","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F37=0,0,F46/F37)","v":0},{"$f":"H37*G46","v":0},{"$f":"I37*G46","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F37=0,0,F47/F37)","v":0},{"$f":"H37*G47","v":0},{"$f":"I37*G47","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F37=0,0,F48/F37)","v":0},{"$f":"H37*G48","v":0},{"$f":"I37*G48","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F37=0,0,F49/F37)","v":0},{"$f":"H37*G49","v":0},{"$f":"I37*G49","v":0}]
[]
[null,"FY 2024 Federal Part B (611) Grant Totals"]
[]
[null,"Grant Award Identifying Number:",null,null,"24611-___-PN01","Grant Allocation","Percent of Grant Award","Expenditures 07/01/24 - 06/30/25","Reimbursements 07/01/24 - 06/30/25"]
[]
[null,"Corp #","Member School Name",null,null,{"$f":"SUM(F56:F67)","v":0},{"$f":"SUM(G56:G67)","v":0},0,0]
[null,null,null,null,null,0,{"$f":"IF(F55=0,0,F56/F55)","v":0},{"$f":"H55*G56","v":0},{"$f":"I55*G56","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F55=0,0,F57/F55)","v":0},{"$f":"H55*G57","v":0},{"$f":"I55*G57","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F55=0,0,F58/F55)","v":0},{"$f":"H55*G58","v":0},{"$f":"I55*G58","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F55=0,0,F59/F55)","v":0},{"$f":"H55*G59","v":0},{"$f":"I55*G59","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F55=0,0,F60/F55)","v":0},{"$f":"H55*G60","v":0},{"$f":"I55*G60","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F55=0,0,F61/F55)","v":0},{"$f":"H55*G61","v":0},{"$f":"I55*G61","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F55=0,0,F62/F55)","v":0},{"$f":"H55*G62","v":0},{"$f":"I55*G62","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F55=0,0,F63/F55)","v":0},{"$f":"H55*G63","v":0},{"$f":"I55*G63","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F55=0,0,F64/F55)","v":0},{"$f":"H55*G64","v":0},{"$f":"I55*G64","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F55=0,0,F65/F55)","v":0},{"$f":"H55*G65","v":0},{"$f":"I55*G65","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F55=0,0,F66/F55)","v":0},{"$f":"H55*G66","v":0},{"$f":"I55*G66","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F55=0,0,F67/F55)","v":0},{"$f":"H55*G67","v":0},{"$f":"I55*G67","v":0}]
[]
[null,"FY 2025 Federal Part B (611) Grant Totals"]
[]
[null,"Grant Award Identifying Number:",null,null,"25611-___-PN01","Grant Allocation","Percent of Grant Award","Expenditures 07/01/24 - 06/30/25","Reimbursements 07/01/24 - 06/30/25"]
[]
[null,"Corp #","Member School Name",null,null,{"$f":"SUM(F74:F85)","v":0},{"$f":"SUM(G74:G85)","v":0},0,0]
[null,null,null,null,null,0,{"$f":"IF(F73=0,0,F74/F73)","v":0},{"$f":"H73*G74","v":0},{"$f":"I73*G74","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F73=0,0,F75/F73)","v":0},{"$f":"H73*G75","v":0},{"$f":"I73*G75","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F73=0,0,F76/F73)","v":0},{"$f":"H73*G76","v":0},{"$f":"I73*G76","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F73=0,0,F77/F73)","v":0},{"$f":"H73*G77","v":0},{"$f":"I73*G77","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F73=0,0,F78/F73)","v":0},{"$f":"H73*G78","v":0},{"$f":"I73*G78","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F73=0,0,F79/F73)","v":0},{"$f":"H73*G79","v":0},{"$f":"I73*G79","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F73=0,0,F80/F73)","v":0},{"$f":"H73*G80","v":0},{"$f":"I73*G80","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F73=0,0,F81/F73)","v":0},{"$f":"H73*G81","v":0},{"$f":"I73*G81","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F73=0,0,F82/F73)","v":0},{"$f":"H73*G82","v":0},{"$f":"I73*G82","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F73=0,0,F83/F73)","v":0},{"$f":"H73*G83","v":0},{"$f":"I73*G83","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F73=0,0,F84/F73)","v":0},{"$f":"H73*G84","v":0},{"$f":"I73*G84","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F73=0,0,F85/F73)","v":0},{"$f":"H73*G85","v":0},{"$f":"I73*G85","v":0}]

{"sheet":"Option 3 (Part B)","index":3,"n_rows":84,"n_cols":15,"rows_kept":84,"cut":false,"hidden":true,"merged":[[81,2,81,4],[83,2,83,4],[73,2,73,4],[74,2,74,4],[75,2,75,4],[76,2,76,4],[82,2,82,4],[24,2,24,7],[17,5,17,7],[19,5,19,7],[21,5,21,7],[36,2,36,4],[35,1,35,3],[34,1,34,14],[35,12,49,12],[37,2,37,4],[38,2,38,4],[39,2,39,4],[40,2,40,4],[41,2,41,4],[42,2,42,4],[43,2,43,4],[44,2,44,4],[5,1,5,7],[10,2,10,7],[12,5,12,7],[13,5,13,7],[16,5,16,7],[52,1,52,3],[46,2,46,4],[47,2,47,4],[49,2,49,4],[35,7,49,7],[51,1,51,14],[48,2,48,4],[45,2,45,4],[61,2,61,4],[62,2,62,4],[63,2,63,4],[64,2,64,4],[66,2,66,4],[65,2,65,4],[56,2,56,4],[57,2,57,4],[58,2,58,4],[59,2,59,4],[60,2,60,4],[52,7,66,7],[77,2,77,4],[78,2,78,4],[79,2,79,4],[80,2,80,4],[68,1,68,14],[69,1,69,3],[69,7,83,7],[69,12,83,12],[70,2,70,4],[71,2,71,4],[72,2,72,4],[52,12,66,12],[53,2,53,4],[54,2,54,4],[55,2,55,4]]}
["Expenditure Report of Federal Dollars for Member School SEFA Completion"]
[]
[null,"SPECIAL EDUCATION, PART B (611)"]
[null,null,"ASSISTANCE LISTING NUMBER (ALN) 84.027"]
[]
[null,"DUE DATE: 7/31/2025"]
[]
[null,"Ensure items in 1. and 2. below are correct before continuing to question 3. below."]
[]
[null,"1.","Name of Special Education Cooperative, Joint Service or Interlocal: "]
[null,null,{"$f":"'Instructions (Part B)'!C14","v":0}]
[]
[null,"2.","Name of Person Completing Form:",null,null,{"$f":"'Instructions (Part B)'!F16","v":0}]
[null,null,"Title of Person:",null,null,{"$f":"'Instructions (Part B)'!F17","v":0}]
[]
[null,null,"Contact Information"]
[null,null,"Email Address:",null,null,{"$f":"'Instructions (Part B)'!F20","v":0}]
[null,null,"Phone Number:",null,null,{"$f":"'Instructions (Part B)'!F21","v":0}]
[]
[null,null,"Date of Completion: ",null,null,{"$f":"'Instructions (Part B)'!F23","v":"00:00:00"}]
[]
[null,"3.","Specify allocation method:"]
[]
[null,null,"If \"Other\", please specify the allocation method in the box below:"]
[]
[]
[null,"4.","Please fill in the blue boxes."]
[null,null,"- Enter the Part B grant award number assigned to the group."]
[null,null,"- Enter the name and the corporation number of each member school."]
[null,null,"- Enter the direct expenditure and reimbursement amounts for each member school."]
[null,null,"- Enter the grant award allocation amount for each member school based on the allocation method selected in Step 3 above."]
[null,null,"- Enter the total allocated expenditures and reimbursements for the time period noted."]
[null,null,"- The \"Total Reimbursements\" column contains the amount the member schools should report on their Grant Schedule in Gateway for each respective grant award number."]
[]
[null,"FY 2023 Federal Part B (611) Grant Totals"]
[null,"Grant Award Identifying Number:",null,null,"23611-___-PN01","Direct Expenditures","Direct Reimbursements",null,"Grant Allocation","Percent of Grant Award","Allocated Expenditures 07/01/24 - 06/30/25","Allocated Reimbursements 07/01/24 - 06/30/25",null,"Total\nExpenditures","Total Reimbursements"]
[null,"Corp #","Member School Name",null,null,"07/01/24 - 06/30/25","07/01/24 - 06/30/25",null,{"$f":"SUM(I38:I50)","v":0},{"$f":"SUM(J38:J50)","v":0},0,0,null,"07/01/24 - 06/30/25","07/01/24 - 06/30/25"]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I37=0,0,I38/I37)","v":0},{"$f":"K37*J38","v":0},{"$f":"L37*J38","v":0},null,{"$f":"SUM(F38,K38)","v":0},{"$f":"SUM(G38,L38)","v":0}]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I37=0,0,I39/I37)","v":0},{"$f":"K37*J39","v":0},{"$f":"L37*J39","v":0},null,{"$f":"SUM(F39,K39)","v":0},{"$f":"SUM(G39,L39)","v":0}]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I37=0,0,I40/I37)","v":0},{"$f":"K37*J40","v":0},{"$f":"L37*J40","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I37=0,0,I41/I37)","v":0},{"$f":"K37*J41","v":0},{"$f":"L37*J41","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I37=0,0,I42/I37)","v":0},{"$f":"K37*J42","v":0},{"$f":"L37*J42","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I37=0,0,I43/I37)","v":0},{"$f":"K37*J43","v":0},{"$f":"L37*J43","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I37=0,0,I44/I37)","v":0},{"$f":"K37*J44","v":0},{"$f":"L37*J44","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I37=0,0,I45/I37)","v":0},{"$f":"K37*J45","v":0},{"$f":"L37*J45","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I37=0,0,I46/I37)","v":0},{"$f":"K37*J46","v":0},{"$f":"L37*J46","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I37=0,0,I47/I37)","v":0},{"$f":"K37*J47","v":0},{"$f":"L37*J47","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I37=0,0,I48/I37)","v":0},{"$f":"K37*J48","v":0},{"$f":"L37*J48","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I38=0,0,I49/I38)","v":0},{"$f":"K38*J49","v":0},{"$f":"L38*J49","v":0},null,{"$f":"SUM(F49,K49)","v":0},{"$f":"SUM(G49,L49)","v":0}]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I37=0,0,I50/I37)","v":0},{"$f":"K37*J50","v":0},{"$f":"L37*J50","v":0},null,0,0]
[]
[null,"FY 2024 Federal Part B (611) Grant Totals"]
[null,"Grant Award Identifying Number:",null,null,"24611-___-PN01","Direct Expenditures","Direct Reimbursements",null,"Grant Allocation","Percent of Grant Award","Allocated Expenditures 07/01/24 - 06/30/25","Allocated Reimbursements 07/01/24 - 06/30/25",null,"Total\nExpenditures","Total Reimbursements"]
[null,"Corp #","Member School Name",null,null,"07/01/24 - 06/30/25","07/01/24 - 06/30/25",null,{"$f":"SUM(I55:I67)","v":0},{"$f":"SUM(J55:J67)","v":0},0,0,null,"07/01/24 - 06/30/25","07/01/24 - 06/30/25"]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I54=0,0,I55/I54)","v":0},{"$f":"K54*J55","v":0},{"$f":"L54*J55","v":0},null,{"$f":"SUM(F55,K55)","v":0},{"$f":"SUM(G55,L55)","v":0}]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I54=0,0,I56/I54)","v":0},{"$f":"K54*J56","v":0},{"$f":"L54*J56","v":0},null,{"$f":"SUM(F56,K56)","v":0},{"$f":"SUM(G56,L56)","v":0}]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I54=0,0,I57/I54)","v":0},{"$f":"K54*J57","v":0},{"$f":"L54*J57","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I54=0,0,I58/I54)","v":0},{"$f":"K54*J58","v":0},{"$f":"L54*J58","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I54=0,0,I59/I54)","v":0},{"$f":"K54*J59","v":0},{"$f":"L54*J59","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I54=0,0,I60/I54)","v":0},{"$f":"K54*J60","v":0},{"$f":"L54*J60","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I54=0,0,I61/I54)","v":0},{"$f":"K54*J61","v":0},{"$f":"L54*J61","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I54=0,0,I62/I54)","v":0},{"$f":"K54*J62","v":0},{"$f":"L54*J62","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I54=0,0,I63/I54)","v":0},{"$f":"K54*J63","v":0},{"$f":"L54*J63","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I54=0,0,I64/I54)","v":0},{"$f":"K54*J64","v":0},{"$f":"L54*J64","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I54=0,0,I65/I54)","v":0},{"$f":"K54*J65","v":0},{"$f":"L54*J65","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I55=0,0,I66/I55)","v":0},{"$f":"K55*J66","v":0},{"$f":"L55*J66","v":0},null,{"$f":"SUM(F66,K66)","v":0},{"$f":"SUM(G66,L66)","v":0}]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I54=0,0,I67/I54)","v":0},{"$f":"K54*J67","v":0},{"$f":"L54*J67","v":0},null,0,0]
[]
[null,"FY 2025 Federal Part B (611) Grant Totals"]
[null,"Grant Award Identifying Number:",null,null,"25611-___-PN01","Direct Expenditures","Direct Reimbursements",null,"Grant Allocation","Percent of Grant Award","Allocated Expenditures 07/01/24 - 06/30/25","Allocated Reimbursements 07/01/24 - 06/30/25",null,"Total\nExpenditures","Total Reimbursements"]
[null,"Corp #","Member School Name",null,null,"07/01/24 - 06/30/25","07/01/24 - 06/30/25",null,{"$f":"SUM(I72:I84)","v":0},{"$f":"SUM(J72:J84)","v":0},0,0,null,"07/01/24 - 06/30/25","07/01/24 - 06/30/25"]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I71=0,0,I72/I71)","v":0},{"$f":"K71*J72","v":0},{"$f":"L71*J72","v":0},null,{"$f":"SUM(F72,K72)","v":0},{"$f":"SUM(G72,L72)","v":0}]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I71=0,0,I73/I71)","v":0},{"$f":"K71*J73","v":0},{"$f":"L71*J73","v":0},null,{"$f":"SUM(F73,K73)","v":0},{"$f":"SUM(G73,L73)","v":0}]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I71=0,0,I74/I71)","v":0},{"$f":"K71*J74","v":0},{"$f":"L71*J74","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I71=0,0,I75/I71)","v":0},{"$f":"K71*J75","v":0},{"$f":"L71*J75","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I71=0,0,I76/I71)","v":0},{"$f":"K71*J76","v":0},{"$f":"L71*J76","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I71=0,0,I77/I71)","v":0},{"$f":"K71*J77","v":0},{"$f":"L71*J77","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I71=0,0,I78/I71)","v":0},{"$f":"K71*J78","v":0},{"$f":"L71*J78","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I71=0,0,I79/I71)","v":0},{"$f":"K71*J79","v":0},{"$f":"L71*J79","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I71=0,0,I80/I71)","v":0},{"$f":"K71*J80","v":0},{"$f":"L71*J80","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I71=0,0,I81/I71)","v":0},{"$f":"K71*J81","v":0},{"$f":"L71*J81","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I71=0,0,I82/I71)","v":0},{"$f":"K71*J82","v":0},{"$f":"L71*J82","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I72=0,0,I83/I72)","v":0},{"$f":"K72*J83","v":0},{"$f":"L72*J83","v":0},null,{"$f":"SUM(F83,K83)","v":0},{"$f":"SUM(G83,L83)","v":0}]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I71=0,0,I84/I71)","v":0},{"$f":"K71*J84","v":0},{"$f":"L71*J84","v":0},null,0,0]

{"sheet":"Instructions (Preschool)","index":4,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[22,2,22,16],[30,2,30,10],[30,12,30,13],[3,1,3,7],[8,2,8,7],[11,5,11,7],[12,5,12,7],[15,5,15,7],[16,5,16,7],[20,2,20,16],[18,5,18,7],[34,2,34,10],[28,3,28,16],[26,3,26,16],[24,3,24,16],[32,2,32,6]]}
[null,"INSTRUCTIONS FOR SPECIAL EDUCATION, PRESCHOOL (619)"]
[null,null,"ASSISTANCE LISTING NUMBER (ALN) 84.173"]
[]
[null,"DUE DATE: 7/31/2025"]
[]
[null,"Ensure items in 1. and 2. below are correct before continuing to section 3. below."]
[]
[null,"1.","Name of Special Education Cooperative, Joint Service or Interlocal: "]
[null,null,{"$f":"'Instructions (Part B)'!C14","v":0}]
[]
[null,"2.","If different from the Part B Instruction tab, you may override the formulas below."]
[null,null,"Name of Person Completing Form:",null,null,{"$f":"'Instructions (Part B)'!F16","v":0}]
[null,null,"Title of Person:",null,null,{"$f":"'Instructions (Part B)'!F17","v":0}]
[]
[null,null,"Contact Information"]
[null,null,"Email Address:",null,null,{"$f":"'Instructions (Part B)'!F20","v":0}]
[null,null,"Phone Number:",null,null,{"$f":"'Instructions (Part B)'!F21","v":0}]
[]
[null,null,"Date of Completion: ",null,null,{"$f":"'Instructions (Part B)'!F23","v":"00:00:00"}]
[]
[null,"3.","Read each of the three options below carefully."]
[]
[null,null,"ONLY ONE of the following options will apply to your Cooperative, Joint Service or Interlocal. The options presented determine the allocation for Special Education, Preschool (ALN 84.173) funds to member schools based on the way your cooperative operates."]
[]
[null,null,"Option 1:","(a) Use this tab if your cooperative allows the member schools to spend the Preschool grant funds and request reimbursement from the fiscal agent, who then will request reimbursement from IDOE.  Once IDOE reimburses the grant funds, the fiscal agent disburses the monies back to the member schools.  If this is how your cooperative operates, the amounts received and disbursed by each member school for a specified school year will appear on their respective Grant Schedule within Gateway.\n\n  OR\n\n(b) Use this tab if the fiscal agent of the cooperative spends all the Preschool grant funds on behalf of the member schools AND the accounting records, both receipts and disbursements, are broken out and can be separately identified for each member school.  If ALL receipts and disbursements are assigned to a specific member school, the amounts assigned to each member school for a specified school year will appear on their respective Grant Schedule within Gateway.\n\n  OR\n\n(c) Use this tab if the cooperative operates based on a combination of the two methods above, Option1(a) and Option1(b).  Actual receipts and expenditures must be specifically designated to a particular member school, and not based on an estimated allocation."]
[]
[null,null,"Option 2:","Use this tab if the fiscal agent of the cooperative spends all the Preschool grant funds on behalf of the member schools AND the accounting records, both receipts and disbursements, are not broken out by each member school.  The fiscal agent will have to reasonably allocate the receipts and disbursements for the year to each of the member schools.  Examples of ways to reasonably allocate receipts and disbursements to each member school include: (1) allocating based on the percent of children served at each member school using a consistent date; (2) allocating based on the percentage of the member school's original allocation in relation to the cooperative's original allocation; (3) any other reasonable way as long as it is documented for audit by the SBOA.  The member schools will use the amounts provided by this allocation method for inclusion in their respective Grant Schedule within Gateway."]
[]
[null,null,"Option 3:","Use this tab if the member schools can spend the Preschool grant funds and request reimbursement or the cooperative spends all the Preschool grant funds on behalf of the schools but has accounting records, both receipts and disbursements, broken out by each member school AND the fiscal agent of the cooperative also spends Preschool grant funds on behalf of the member schools but does not have accounting records broken out to assign receipts and disbursements by member school.  The member schools will use the amounts disbursed and reimbursed by the member school in addition to an allocated amount provided to each member school by the fiscal agent for inclusion in their respective Grant Schedule within Gateway."]
[]
[null,"4.","Which of the three options above describes the way your Cooperative, Joint Service or Interlocal operates the Preschool funds?\n    [Once you make your selection, the appropriate tab will then become visible for you to complete.]"]
[]
[null,null,{"$f":"IF(M31=\"\",\"\",IF(M31=\"Option 1\",\"You will need to complete the provided Option 1 (Preschool) tab.\",IF(M31=\"Option 2\",\"You will need to complete the provided Option 2 (Preschool) tab.\",\"You will need to complete the provided Option 3 (Preschool) tab.\")))","v":""}]
[]
[null,"5.","Return to Step 6 on the 'Instructions (Part B)' tab."]

{"sheet":"Option 1 (Preschool)","index":5,"n_rows":79,"n_cols":7,"rows_kept":79,"cut":false,"hidden":true,"merged":[[75,2,75,4],[76,2,76,4],[77,2,77,4],[70,2,70,4],[71,2,71,4],[72,2,72,4],[73,2,73,4],[74,2,74,4],[65,2,65,4],[66,2,66,4],[67,2,67,4],[68,2,68,4],[69,2,69,4],[49,2,49,4],[50,2,50,4],[51,2,51,4],[62,1,62,6],[64,1,64,3],[52,2,52,4],[53,2,53,4],[54,2,54,4],[55,2,55,4],[56,2,56,4],[57,2,57,4],[58,2,58,4],[59,2,59,4],[17,5,17,7],[19,5,19,7],[26,1,26,6],[28,1,28,3],[34,2,34,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[29,2,29,4],[30,2,30,4],[5,1,5,7],[10,2,10,7],[12,5,12,7],[13,5,13,7],[16,5,16,7],[37,2,37,4],[38,2,38,4],[39,2,39,4],[40,2,40,4],[35,2,35,4],[36,2,36,4],[47,2,47,4],[48,2,48,4],[41,2,41,4],[44,1,44,6],[46,1,46,3]]}
["Expenditure Report of Federal Dollars for Member School SEFA Completion"]
[]
[null,"SPECIAL EDUCATION, PRESCHOOL (619)"]
[null,null,"ASSISTANCE LISTING NUMBER (ALN) 84.173"]
[]
[null,"DUE DATE: 7/31/2025"]
[]
[null,"Ensure items in 1. and 2. below are correct before continuing to section 3. below."]
[]
[null,"1.","Name of Special Education Cooperative, Joint Service or Interlocal: "]
[null,null,{"$f":"'Instructions (Part B)'!C14","v":0}]
[]
[null,"2.","Name of Person Completing Form:",null,null,{"$f":"'Instructions (Preschool)'!F12","v":0}]
[null,null,"Title of Person:",null,null,{"$f":"'Instructions (Preschool)'!F13","v":0}]
[]
[null,null,"Contact Information"]
[null,null,"Email Address:",null,null,{"$f":"'Instructions (Preschool)'!F16","v":0}]
[null,null,"Phone Number:",null,null,{"$f":"'Instructions (Preschool)'!F17","v":0}]
[]
[null,null,"Date of Completion: ",null,null,{"$f":"'Instructions (Preschool)'!F19","v":"00:00:00"}]
[]
[null,"3.","Please fill in the blue boxes."]
[null,null,"- Enter the name and the corporation number of each member school."]
[null,null,"- Enter the Preschool grant award number assigned to the group."]
[null,null,"- Enter all actual expenditures and reimbursements for each member school for the time period noted."]
[]
[null,"FY 2023 Federal Preschool (619) Grant Totals"]
[]
[null,"Grant Award Identifying Number:",null,null,"23619-___-PN01","Expenditures","Reimbursements"]
[null,"Corp #","Member School Name",null,null,"07/01/24 - 06/30/25","07/01/24 - 06/30/25"]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,"Grand Totals",null,null,{"$f":"SUBTOTAL(9,F31:F42)","v":0},{"$f":"SUBTOTAL(9,G31:G42)","v":0}]
[]
[null,"FY 2024 Federal Preschool (619) Grant Totals"]
[]
[null,"Grant Award Identifying Number:",null,null,"24619-___-PN01","Expenditures","Reimbursements"]
[null,"Corp #","Member School Name",null,null,"07/01/24 - 06/30/25","07/01/24 - 06/30/25"]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,"Grand Totals",null,null,{"$f":"SUBTOTAL(9,F49:F60)","v":0},{"$f":"SUBTOTAL(9,G49:G60)","v":0}]
[]
[null,"FY 2025 Federal Preschool (619) Grant Totals"]
[]
[null,"Grant Award Identifying Number:",null,null,"25619-___-PN01","Expenditures","Reimbursements"]
[null,"Corp #","Member School Name",null,null,"07/01/24 - 06/30/25","07/01/24 - 06/30/25"]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,"Grand Totals",null,null,{"$f":"SUBTOTAL(9,F67:F78)","v":0},{"$f":"SUBTOTAL(9,G67:G78)","v":0}]

{"sheet":"Option 2 (Preschool)","index":6,"n_rows":85,"n_cols":9,"rows_kept":85,"cut":false,"hidden":true,"merged":[[81,2,81,4],[82,2,82,4],[83,2,83,4],[84,2,84,4],[76,2,76,4],[77,2,77,4],[78,2,78,4],[79,2,79,4],[80,2,80,4],[70,8,71,8],[72,2,72,4],[73,2,73,4],[74,2,74,4],[75,2,75,4],[70,1,71,3],[70,4,71,4],[70,5,71,5],[70,6,71,6],[70,7,71,7],[63,2,63,4],[64,2,64,4],[65,2,65,4],[66,2,66,4],[68,1,68,8],[58,2,58,4],[59,2,59,4],[60,2,60,4],[61,2,61,4],[62,2,62,4],[52,8,53,8],[54,2,54,4],[55,2,55,4],[56,2,56,4],[57,2,57,4],[52,1,53,3],[52,4,53,4],[52,5,53,5],[52,6,53,6],[52,7,53,7],[45,2,45,4],[46,2,46,4],[47,2,47,4],[48,2,48,4],[50,1,50,8],[40,2,40,4],[41,2,41,4],[42,2,42,4],[43,2,43,4],[44,2,44,4],[34,8,35,8],[36,2,36,4],[37,2,37,4],[38,2,38,4],[39,2,39,4],[34,1,35,3],[34,4,35,4],[34,5,35,5],[34,6,35,6],[34,7,35,7],[17,5,17,7],[19,5,19,7],[21,5,21,7],[23,2,23,8],[32,1,32,8],[5,1,5,7],[10,2,10,7],[12,5,12,7],[13,5,13,7],[16,5,16,7]]}
["Expenditure Report of Federal Dollars for Member School SEFA Completion"]
[]
[null,"SPECIAL EDUCATION, PRESCHOOL (619)"]
[null,null,"ASSISTANCE LISTING NUMBER (ALN) 84.173"]
[]
[null,"DUE DATE: 7/31/2025"]
[]
[null,"Ensure items in 1. and 2. below are correct before continuing to section 3. below."]
[]
[null,"1.","Name of Special Education Cooperative, Joint Service or Interlocal: "]
[null,null,{"$f":"'Instructions (Part B)'!C14","v":0}]
[]
[null,"2.","Name of Person Completing Form:",null,null,{"$f":"'Instructions (Preschool)'!F12","v":0}]
[null,null,"Title of Person:",null,null,{"$f":"'Instructions (Preschool)'!F13","v":0}]
[]
[null,null,"Contact Information"]
[null,null,"Email Address:",null,null,{"$f":"'Instructions (Preschool)'!F16","v":0}]
[null,null,"Phone Number:",null,null,{"$f":"'Instructions (Preschool)'!F17","v":0}]
[]
[null,null,"Date of Completion: ",null,null,{"$f":"'Instructions (Preschool)'!F19","v":"00:00:00"}]
[]
[null,"3.","Specify allocation method:"]
[null,null,"If \"Other\", please specify the allocation method in the box below:"]
[]
[]
[null,"4.","Please fill in the blue boxes."]
[null,null,"- Enter the Preschool grant award number assigned to the group."]
[null,null,"- Enter the name and the corporation number of each member school."]
[null,null,"- Enter the grant award allocation amount for each member school based on the allocation method selected in Step 3 above."]
[null,null,"- Enter the total actual expenditures and reimbursements for the time period noted."]
[]
[]
[null,"FY 2023 Federal Preschool (619) Grant Totals"]
[]
[null,"Grant Award Identifying Number:",null,null,"23619-___-PN01","Grant Allocation","Percent of Grant Award","Expenditures 07/01/24 - 06/30/25","Reimbursements 07/01/24 - 06/30/25"]
[]
[null,"Corp #","Member School Name",null,null,{"$f":"SUM(F38:F49)","v":0},{"$f":"SUM(G38:G49)","v":0},0,0]
[null,null,null,null,null,0,{"$f":"IF(F37=0,0,F38/F37)","v":0},{"$f":"H37*G38","v":0},{"$f":"I37*G38","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F37=0,0,F39/F37)","v":0},{"$f":"H37*G39","v":0},{"$f":"I37*G39","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F37=0,0,F40/F37)","v":0},{"$f":"H37*G40","v":0},{"$f":"I37*G40","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F37=0,0,F41/F37)","v":0},{"$f":"H37*G41","v":0},{"$f":"I37*G41","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F37=0,0,F42/F37)","v":0},{"$f":"H37*G42","v":0},{"$f":"I37*G42","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F37=0,0,F43/F37)","v":0},{"$f":"H37*G43","v":0},{"$f":"I37*G43","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F37=0,0,F44/F37)","v":0},{"$f":"H37*G44","v":0},{"$f":"I37*G44","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F37=0,0,F45/F37)","v":0},{"$f":"H37*G45","v":0},{"$f":"I37*G45","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F37=0,0,F46/F37)","v":0},{"$f":"H37*G46","v":0},{"$f":"I37*G46","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F37=0,0,F47/F37)","v":0},{"$f":"H37*G47","v":0},{"$f":"I37*G47","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F37=0,0,F48/F37)","v":0},{"$f":"H37*G48","v":0},{"$f":"I37*G48","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F37=0,0,F49/F37)","v":0},{"$f":"H37*G49","v":0},{"$f":"I37*G49","v":0}]
[]
[null,"FY 2024 Federal Preschool (619) Grant Totals"]
[]
[null,"Grant Award Identifying Number:",null,null,"24619-___-PN01","Grant Allocation","Percent of Grant Award","Expenditures 07/01/24 - 06/30/25","Reimbursements 07/01/24 - 06/30/25"]
[]
[null,"Corp #","Member School Name",null,null,{"$f":"SUM(F56:F67)","v":0},{"$f":"SUM(G56:G67)","v":0},0,0]
[null,null,null,null,null,0,{"$f":"IF(F55=0,0,F56/F55)","v":0},{"$f":"H55*G56","v":0},{"$f":"I55*G56","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F55=0,0,F57/F55)","v":0},{"$f":"H55*G57","v":0},{"$f":"I55*G57","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F55=0,0,F58/F55)","v":0},{"$f":"H55*G58","v":0},{"$f":"I55*G58","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F55=0,0,F59/F55)","v":0},{"$f":"H55*G59","v":0},{"$f":"I55*G59","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F55=0,0,F60/F55)","v":0},{"$f":"H55*G60","v":0},{"$f":"I55*G60","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F55=0,0,F61/F55)","v":0},{"$f":"H55*G61","v":0},{"$f":"I55*G61","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F55=0,0,F62/F55)","v":0},{"$f":"H55*G62","v":0},{"$f":"I55*G62","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F55=0,0,F63/F55)","v":0},{"$f":"H55*G63","v":0},{"$f":"I55*G63","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F55=0,0,F64/F55)","v":0},{"$f":"H55*G64","v":0},{"$f":"I55*G64","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F55=0,0,F65/F55)","v":0},{"$f":"H55*G65","v":0},{"$f":"I55*G65","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F55=0,0,F66/F55)","v":0},{"$f":"H55*G66","v":0},{"$f":"I55*G66","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F55=0,0,F67/F55)","v":0},{"$f":"H55*G67","v":0},{"$f":"I55*G67","v":0}]
[]
[null,"FY 2025 Federal Preschool (619) Grant Totals"]
[]
[null,"Grant Award Identifying Number:",null,null,"25619-___-PN01","Grant Allocation","Percent of Grant Award","Expenditures 07/01/24 - 06/30/25","Reimbursements 07/01/24 - 06/30/25"]
[]
[null,"Corp #","Member School Name",null,null,{"$f":"SUM(F74:F85)","v":0},{"$f":"SUM(G74:G85)","v":0},0,0]
[null,null,null,null,null,0,{"$f":"IF(F73=0,0,F74/F73)","v":0},{"$f":"H73*G74","v":0},{"$f":"I73*G74","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F73=0,0,F75/F73)","v":0},{"$f":"H73*G75","v":0},{"$f":"I73*G75","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F73=0,0,F76/F73)","v":0},{"$f":"H73*G76","v":0},{"$f":"I73*G76","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F73=0,0,F77/F73)","v":0},{"$f":"H73*G77","v":0},{"$f":"I73*G77","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F73=0,0,F78/F73)","v":0},{"$f":"H73*G78","v":0},{"$f":"I73*G78","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F73=0,0,F79/F73)","v":0},{"$f":"H73*G79","v":0},{"$f":"I73*G79","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F73=0,0,F80/F73)","v":0},{"$f":"H73*G80","v":0},{"$f":"I73*G80","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F73=0,0,F81/F73)","v":0},{"$f":"H73*G81","v":0},{"$f":"I73*G81","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F73=0,0,F82/F73)","v":0},{"$f":"H73*G82","v":0},{"$f":"I73*G82","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F73=0,0,F83/F73)","v":0},{"$f":"H73*G83","v":0},{"$f":"I73*G83","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F73=0,0,F84/F73)","v":0},{"$f":"H73*G84","v":0},{"$f":"I73*G84","v":0}]
[null,null,null,null,null,0,{"$f":"IF(F73=0,0,F85/F73)","v":0},{"$f":"H73*G85","v":0},{"$f":"I73*G85","v":0}]

{"sheet":"Option 3 (Preschool)","index":7,"n_rows":84,"n_cols":15,"rows_kept":84,"cut":false,"hidden":true,"merged":[[24,2,24,7],[81,2,81,4],[83,2,83,4],[66,2,66,4],[68,1,68,14],[69,1,69,3],[69,7,83,7],[69,12,83,12],[70,2,70,4],[71,2,71,4],[72,2,72,4],[73,2,73,4],[74,2,74,4],[75,2,75,4],[76,2,76,4],[77,2,77,4],[78,2,78,4],[79,2,79,4],[80,2,80,4],[51,1,51,14],[52,1,52,3],[52,7,66,7],[52,12,66,12],[53,2,53,4],[54,2,54,4],[55,2,55,4],[56,2,56,4],[57,2,57,4],[58,2,58,4],[59,2,59,4],[60,2,60,4],[61,2,61,4],[62,2,62,4],[63,2,63,4],[64,2,64,4],[35,1,35,3],[44,2,44,4],[45,2,45,4],[46,2,46,4],[47,2,47,4],[49,2,49,4],[48,2,48,4],[5,1,5,7],[10,2,10,7],[12,5,12,7],[13,5,13,7],[16,5,16,7],[65,2,65,4],[82,2,82,4],[17,5,17,7],[19,5,19,7],[21,5,21,7],[34,1,34,14],[35,7,49,7],[35,12,49,12],[36,2,36,4],[37,2,37,4],[38,2,38,4],[39,2,39,4],[40,2,40,4],[41,2,41,4],[42,2,42,4],[43,2,43,4]]}
["Expenditure Report of Federal Dollars for Member School SEFA Completion"]
[]
[null,"SPECIAL EDUCATION, PRESCHOOL (619)"]
[null,null,"ASSISTANCE LISTING NUMBER (ALN) 84.173"]
[]
[null,"DUE DATE: 7/31/2025"]
[]
[null,"Ensure items in 1. and 2. below are correct before continuing to question 3. below."]
[]
[null,"1.","Name of Special Education Cooperative, Joint Service or Interlocal: "]
[null,null,{"$f":"'Instructions (Part B)'!C14","v":0}]
[]
[null,"2.","Name of Person Completing Form:",null,null,{"$f":"'Instructions (Preschool)'!F12","v":0}]
[null,null,"Title of Person:",null,null,{"$f":"'Instructions (Preschool)'!F13","v":0}]
[]
[null,null,"Contact Information"]
[null,null,"Email Address:",null,null,{"$f":"'Instructions (Preschool)'!F16","v":0}]
[null,null,"Phone Number:",null,null,{"$f":"'Instructions (Preschool)'!F17","v":0}]
[]
[null,null,"Date of Completion: ",null,null,{"$f":"'Instructions (Preschool)'!F19","v":"00:00:00"}]
[]
[null,"3.","Specify allocation method:"]
[]
[null,null,"If \"Other\", please specify the allocation method in the box below:"]
[]
[]
[null,"4.","Please fill in the blue boxes."]
[null,null,"- Enter the Preschool grant award number assigned to the group."]
[null,null,"- Enter the name and the corporation number of each member school."]
[null,null,"- Enter the direct expenditure and reimbursement amounts for each member school."]
[null,null,"- Enter the grant award allocation amount for each member school based on the allocation method selected in Step 3 above."]
[null,null,"- Enter the total allocated expenditures and reimbursements for the time period noted."]
[null,null,"- The \"Total Reimbursements\" column contains the amount the member schools should report on their Grant Schedule in Gateway for each respective grant award number."]
[]
[null,"FY 2023 Federal Preschool (619) Grant Totals"]
[null,"Grant Award Identifying Number:",null,null,"23619-___-PN01","Direct Expenditures","Direct Reimbursements",null,"Grant Allocation","Percent of Grant Award","Allocated Expenditures 07/01/24 - 06/30/25","Allocated Reimbursements 07/01/24 - 06/30/25",null,"Total\nExpenditures","Total Reimbursements"]
[null,"Corp #","Member School Name",null,null,"07/01/24 - 06/30/25","07/01/24 - 06/30/25",null,{"$f":"SUM(I38:I50)","v":0},{"$f":"SUM(J38:J50)","v":0},0,0,null,"07/01/24 - 06/30/25","07/01/24 - 06/30/25"]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I37=0,0,I38/I37)","v":0},{"$f":"K37*J38","v":0},{"$f":"L37*J38","v":0},null,{"$f":"SUM(F38,K38)","v":0},{"$f":"SUM(G38,L38)","v":0}]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I37=0,0,I39/I37)","v":0},{"$f":"K37*J39","v":0},{"$f":"L37*J39","v":0},null,{"$f":"SUM(F39,K39)","v":0},0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I37=0,0,I40/I37)","v":0},{"$f":"K37*J40","v":0},{"$f":"L37*J40","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I37=0,0,I41/I37)","v":0},{"$f":"K37*J41","v":0},{"$f":"L37*J41","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I37=0,0,I42/I37)","v":0},{"$f":"K37*J42","v":0},{"$f":"L37*J42","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I37=0,0,I43/I37)","v":0},{"$f":"K37*J43","v":0},{"$f":"L37*J43","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I37=0,0,I44/I37)","v":0},{"$f":"K37*J44","v":0},{"$f":"L37*J44","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I37=0,0,I45/I37)","v":0},{"$f":"K37*J45","v":0},{"$f":"L37*J45","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I37=0,0,I46/I37)","v":0},{"$f":"K37*J46","v":0},{"$f":"L37*J46","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I37=0,0,I47/I37)","v":0},{"$f":"K37*J47","v":0},{"$f":"L37*J47","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I37=0,0,I48/I37)","v":0},{"$f":"K37*J48","v":0},{"$f":"L37*J48","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I38=0,0,I49/I38)","v":0},{"$f":"K38*J49","v":0},{"$f":"L38*J49","v":0},null,{"$f":"SUM(F49,K49)","v":0},{"$f":"SUM(G49,L49)","v":0}]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I37=0,0,I50/I37)","v":0},{"$f":"K37*J50","v":0},{"$f":"L37*J50","v":0},null,0,0]
[]
[null,"FY 2024 Federal Preschool (619) Grant Totals"]
[null,"Grant Award Identifying Number:",null,null,"24619-___-PN01","Direct Expenditures","Direct Reimbursements",null,"Grant Allocation","Percent of Grant Award","Allocated Expenditures 07/01/24 - 06/30/25","Allocated Reimbursements 07/01/24 - 06/30/25",null,"Total\nExpenditures","Total Reimbursements"]
[null,"Corp #","Member School Name",null,null,"07/01/24 - 06/30/25","07/01/24 - 06/30/25",null,{"$f":"SUM(I55:I67)","v":0},{"$f":"SUM(J55:J67)","v":0},0,0,null,"07/01/24 - 06/30/25","07/01/24 - 06/30/25"]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I54=0,0,I55/I54)","v":0},{"$f":"K54*J55","v":0},{"$f":"L54*J55","v":0},null,{"$f":"SUM(F55,K55)","v":0},{"$f":"SUM(G55,L55)","v":0}]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I54=0,0,I56/I54)","v":0},{"$f":"K54*J56","v":0},{"$f":"L54*J56","v":0},null,{"$f":"SUM(F56,K56)","v":0},0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I54=0,0,I57/I54)","v":0},{"$f":"K54*J57","v":0},{"$f":"L54*J57","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I54=0,0,I58/I54)","v":0},{"$f":"K54*J58","v":0},{"$f":"L54*J58","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I54=0,0,I59/I54)","v":0},{"$f":"K54*J59","v":0},{"$f":"L54*J59","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I54=0,0,I60/I54)","v":0},{"$f":"K54*J60","v":0},{"$f":"L54*J60","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I54=0,0,I61/I54)","v":0},{"$f":"K54*J61","v":0},{"$f":"L54*J61","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I54=0,0,I62/I54)","v":0},{"$f":"K54*J62","v":0},{"$f":"L54*J62","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I54=0,0,I63/I54)","v":0},{"$f":"K54*J63","v":0},{"$f":"L54*J63","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I54=0,0,I64/I54)","v":0},{"$f":"K54*J64","v":0},{"$f":"L54*J64","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I54=0,0,I65/I54)","v":0},{"$f":"K54*J65","v":0},{"$f":"L54*J65","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I55=0,0,I66/I55)","v":0},{"$f":"K55*J66","v":0},{"$f":"L55*J66","v":0},null,{"$f":"SUM(F66,K66)","v":0},{"$f":"SUM(G66,L66)","v":0}]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I54=0,0,I67/I54)","v":0},{"$f":"K54*J67","v":0},{"$f":"L54*J67","v":0},null,0,0]
[]
[null,"FY 2025 Federal Preschool (619) Grant Totals"]
[null,"Grant Award Identifying Number:",null,null,"25619-___-PN01","Direct Expenditures","Direct Reimbursements",null,"Grant Allocation","Percent of Grant Award","Allocated Expenditures 07/01/24 - 06/30/25","Allocated Reimbursements 07/01/24 - 06/30/25",null,"Total\nExpenditures","Total Reimbursements"]
[null,"Corp #","Member School Name",null,null,"07/01/24 - 06/30/25","07/01/24 - 06/30/25",null,{"$f":"SUM(I72:I84)","v":0},{"$f":"SUM(J72:J84)","v":0},0,0,null,"07/01/24 - 06/30/25","07/01/24 - 06/30/25"]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I71=0,0,I72/I71)","v":0},{"$f":"K71*J72","v":0},{"$f":"L71*J72","v":0},null,{"$f":"SUM(F72,K72)","v":0},{"$f":"SUM(G72,L72)","v":0}]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I71=0,0,I73/I71)","v":0},{"$f":"K71*J73","v":0},{"$f":"L71*J73","v":0},null,{"$f":"SUM(F73,K73)","v":0},0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I71=0,0,I74/I71)","v":0},{"$f":"K71*J74","v":0},{"$f":"L71*J74","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I71=0,0,I75/I71)","v":0},{"$f":"K71*J75","v":0},{"$f":"L71*J75","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I71=0,0,I76/I71)","v":0},{"$f":"K71*J76","v":0},{"$f":"L71*J76","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I71=0,0,I77/I71)","v":0},{"$f":"K71*J77","v":0},{"$f":"L71*J77","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I71=0,0,I78/I71)","v":0},{"$f":"K71*J78","v":0},{"$f":"L71*J78","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I71=0,0,I79/I71)","v":0},{"$f":"K71*J79","v":0},{"$f":"L71*J79","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I71=0,0,I80/I71)","v":0},{"$f":"K71*J80","v":0},{"$f":"L71*J80","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I71=0,0,I81/I71)","v":0},{"$f":"K71*J81","v":0},{"$f":"L71*J81","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I71=0,0,I82/I71)","v":0},{"$f":"K71*J82","v":0},{"$f":"L71*J82","v":0},null,0,0]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I72=0,0,I83/I72)","v":0},{"$f":"K72*J83","v":0},{"$f":"L72*J83","v":0},null,{"$f":"SUM(F83,K83)","v":0},{"$f":"SUM(G83,L83)","v":0}]
[null,null,null,null,null,0,0,null,0,{"$f":"IF(I71=0,0,I84/I71)","v":0},{"$f":"K71*J84","v":0},{"$f":"L71*J84","v":0},null,0,0]