{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","1st Quarter Report","Sheet1","2nd Quarter Report","3rd Quarter Report","4th Quarter Report"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":6,"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":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[10,2,10,9],[11,2,11,9],[17,1,17,9],[18,1,18,9],[12,2,12,9],[13,1,13,9],[14,2,14,9],[15,2,15,9],[16,1,16,9],[5,2,5,9],[6,2,6,9],[7,1,7,9],[8,1,8,9],[9,1,9,9],[0,0,0,9],[1,1,1,9],[2,1,2,9],[3,1,3,9],[4,1,4,9]]}
["INSTRUCTIONS FOR COMPLETING THE FAMILY COURT GRANT QUARTERLY REPORT"]
[1,"Every instruction on this sheet must be followed.  If any are not followed, the report will be returned to the sender with instructions to correct the report and resubmit a properly completed report."]
[2,"Every yellow-tinted cell on each quarter's report sheet must have information added.  If no information is necessary, you must enter either a zero for numerical responses or a statement that no information has been collected and why, or that no efforts have been made and why."]
[3,"Date Report Prepared: This is the date when the properly completed report has been emailed to the Family Court Grant Manager as an excel (.xls, xlsx, or .xlsm) spreadsheet attached to an email.  If a report has been sent back for failure to follow the instructions, the \"Date Report Prepared\" must be changed to match this instruction."]
[4,"Project Aims section: This section is where the reporting county describes the specific aims that are detailed in its approved grant application."]
[null,null,"Left Column: Each specific aim of the project is summarized and identified in the left-hand column."]
[null,null,"Right Column: The progress that has been made during the reporting period toward each of those aims is summarized and identified in the right-hand column."]
[5,"Applications Submitted this Quarter for Additional Family Court Funding: This section is where the reporting county identifies if the county has made any additional requests during the reporting period for additional Family Court grant monies from the Indiana Office of Court Services."]
[6,"Applications Submitted this Quarter for Additional Funding from Other Sources: This section is where the reporting county identifies if the county has made any additional requests during the reporting period for additional monies from any source other than the Family Court grant."]
[7,"Income: This section is where the reporting county accounts for Family Court grant monies that are included as income for the reporting period."]
[null,null,"Beginning Balance: As stated, this number is the balance of Family Court grant monies at the end of the previous reporting period.  For the 1st Quarter Report on a previously existing grant, use the end-of-year balance on your previous year's Annual Report.  For the 1st Quarter Report on a new grant, enter zero."]
[null,null,"Family Court Grant Funds Received: this number is the amount of any Family Court grant monies awarded during the reporting period."]
[null,null,"Other Funds Received: this number is the amount of any other monies received by the county during the reporting period, specifically accounted for use by the Family Court grant only."]
[8,"Expenditures: This section is where the reporting county accounts for Family Court grant monies that were spent on allowable expenses during the reporting period."]
[null,null,"Personnel Expenditures: This number is the total of Family Court grant monies that were spent and actually paid out of the Family Court grant account for expenses foe personnel, which could include payments to contractors, salaries, benefits, and/or taxes for such payments."]
[null,null,"Non-Personnel Expenditures: This number is the total of Family Court grant monies that were spent and actually paid out of the Family Court grant account for expenses not related to personnel, which could include equipment, travel, fees, and/or other allowable expenses."]
[9,"Data: Enter the number of new families that the project provided some service to that required the expenditure of Family Court grant monies during the reporting period.  The service need not have happened during the reporting period, but the expenditure of monies must have."]
[10,"Efforts to Disseminate the Project/Program Findings to benefit Others in the Field: One of the most important aspects of the Family Court grants is the ability for the benefits of the specific projects from the various counties to be reproduced in other counties.  Identify what efforts your project or county has made to disseminate or detail the work that is being done through its Family Court grant project, to whom such information was provided, and when."]
[11,"Reporting Period: For the 1st Quarter Report, the first quarter is the reporting preiod."]

{"sheet":"1st Quarter Report","index":1,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,3,2],[4,0,4,2]]}
["Fields in yellow are for data entry.  "]
["Indiana Supreme Court"]
["Office of Court Services"]
["Family Court"]
["QUARTERLY REPORT 2022"]
[null,"                 "]
["Court Name"]
["Person(s) Preparing Report"]
[]
["Date Report Prepared"]
["STATED PROJECT AIMS (from approved grant application)",null,"PROGRESS MADE ON EACH AIM"]
["EX: Aim 1: Provide free mediation to low income families",null,"EX: Aim complete - We contracted four part-time mediators to provide free mediation services for low income families. "]
["Aim 1: (Fill in your project aims here)",null,"(Fill in your progress made toward achieving your Aim here)"]
["Aim 2: (Fill in your project aims here)",null,"(Fill in your progress made toward achieving your Aim here)"]
["Aim 3: (Fill in your project aims here)",null,"(Fill in your progress made toward achieving your Aim here)"]
["Aim 4: (Fill in your project aims here)",null,"(Fill in your progress made toward achieving your Aim here)"]
["If any aims were modified since the proposal was written, please explain briefly"]
["APPLICATIONS SUBMITTED THIS QUARTER FOR ADDITIONAL FAMILY COURT GRANT FUNDING",null,"AMOUNT REQUESTED, DATE SUBMITTED"]
["EX: APPLICATION 1:",null,"Ex: $5,000, January 20, 2021"]
["APPLICATION 1:",null,"(Enter information about any application submitted, or that none were)"]
["APPLICATION 2:",null,"(Enter information about any application submitted, or that none were)"]
["APPLICATIONS SUBMITTED THIS QUARTER FOR ADDITIONAL FUNDING FROM OTHER SOURCES (i.e., not requests to IOCS for the Family Court grant)",null,"TITLE OF GRANT, AMOUNT REQUESTED, DATE SUBMITTED, OUTCOME (funding obtained or not)"]
["EX: APPLICATION 1:",null,"National Science Foundation Law & Social Sciences Grant, $100,000, January 10, 2021, no funding obtained so will reapply"]
["APPLICATION 1:",null,"(Enter information about any application submitted, or that none were)"]
["APPLICATION 2:",null,"(Enter information about any application submitted, or that none were)"]
["INCOME (Do NOT include in-kind income)"]
["Beginning Balance (should be carryover balance from prior year Annual Report, if any)",0]
["Family Court grant funds received",0]
["Other funds received",0]
["TOTAL",{"$f":"SUM(B27:B29)","v":0}]
["EXPENDITURES (Do NOT include in-kind expenditures)"]
["Personnel Expenditures",0]
["Non-Personnel Expenditures",0]
["TOTAL",{"$f":"SUM(B32:B33)","v":0}]
["ENDING BALANCE",{"$f":"SUM(B30-B34)","v":0}]
["If major changes from proposed budget, briefly explain why such changes were necessary"]
["DATA ",null,"(only include families that are related to expenditures of FC monies)"]
["New Families Served (or Matriculated into Study) this Quarter"]
["EFFORTS TO DISSEMINATE THE PROJECT/PROGRAM FINDINGS TO BENEFIT OTHERS IN THE FIELD",null,"TITLE OF PRESENTATION/REPORT/ARTICLE, PLACE PRESENTED/PUBLISHED, DATE, AUTHORS "]
["EX: Dissemination Effort 1",null,"Panel: Community Partnerships in Family Law, Association of Family and Conciliation Courts, January 2021, Smith, James, & Johnson "]
["Dissemination Effort 1"]
["Dissemination Effort 2"]
["ADDITIONAL COMMENTS"]

{"sheet":"Sheet1","index":2,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["(Select One)"]
["Allen"]
["Bartholomew, Brown, Jackson, Lawrence"]
["Clark"]
["Crawford, Martin, Orange"]
["Henry"]
["Johnson"]
["Lake Circuit"]
["Lake Superior Room 3"]
["Lake Juvenile"]
["LaPorte"]
["Madison"]
["Marion"]
["Monroe"]
["Owen"]
["Parke"]
["Porter"]
["Putnam"]
["St. Joseph"]
["Tippecanoe"]
["Vanderburgh"]

{"sheet":"2nd Quarter Report","index":3,"n_rows":44,"n_cols":3,"rows_kept":44,"cut":false,"hidden":false,"merged":[[44,0,44,1],[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,3,2],[4,0,4,2]]}
["Fields in yellow are for data entry.  "]
["Indiana Supreme Court"]
["Office of Court Services"]
["Family Court"]
["QUARTERLY REPORT 2022"]
[null,"                 "]
["Court Name",null,{"$f":"'1st Quarter Report'!C7","v":0}]
["Person(s) Preparing Report"]
[]
["Date Report Prepared"]
["STATED PROJECT AIMS (from approved grant application)",null,"PROGRESS MADE ON EACH AIM"]
["EX: Aim 1: Provide free mediation to low income families",null,"EX: Aim complete - We contracted four part-time mediators to provide free mediation services for low income families. "]
["Aim 1: (Fill in your project aims here)",null,"(Fill in your progress made toward achieving your Aim here)"]
["Aim 2: (Fill in your project aims here)",null,"(Fill in your progress made toward achieving your Aim here)"]
["Aim 3: (Fill in your project aims here)",null,"(Fill in your progress made toward achieving your Aim here)"]
["Aim 4: (Fill in your project aims here)",null,"(Fill in your progress made toward achieving your Aim here)"]
["If any aims were modified since the proposal was written, please explain briefly"]
["APPLICATIONS SUBMITTED THIS QUARTER FOR ADDITIONAL FAMILY COURT FUNDING",null,"AMOUNT REQUESTED, DATE SUBMITTED"]
["EX: APPLICATION 1:",null,"Ex: $5,000, May 20, 2021"]
["APPLICATION 1:",null,"(Enter information about any application submitted, or that none were)"]
["APPLICATION 2:",null,"(Enter information about any application submitted, or that none were)"]
["APPLICATIONS SUBMITTED THIS QUARTER FOR ADDITIONAL FUNDING FROM OTHER SOURCES (i.e., not requests to the IOCS for Family Court grants)",null,"TITLE OF GRANT, AMOUNT REQUESTED, DATE SUBMITTED, OUTCOME (funding obtained or not)"]
["EX: APPLICATION 1:",null,"National Science Foundation Law & Social Sciences Grant, $100,000, May 10, 2021, no funding obtained so will reapply"]
["APPLICATION 1:",null,"(Enter information about any application submitted, or that none were)"]
["APPLICATION 2:",null,"(Enter information about any application submitted, or that none were)"]
["INCOME (Do NOT include in-kind income)"]
["Beginning Balance",{"$f":"'1st Quarter Report'!B35","v":0}]
["Family Court grant funds received",0]
["Other funds received",0]
["TOTAL",{"$f":"SUM(B27:B29)","v":0}]
["EXPENDITURES (Do NOT include in-kind expenditures)"]
["Personnel Expenditures",0]
["Non-Personnel Expenditures",0]
["TOTAL",{"$f":"SUM(B32:B33)","v":0}]
["ENDING BALANCE",{"$f":"SUM(B30-B34)","v":0}]
["If major changes from proposed budget, briefly explain why such changes were necessary"]
["DATA ",null,"(only include families that are related to expenditures of FC monies)"]
["New Families Served (or Matriculated into Study) this Quarter"]
["New Families Served  (or Matriculated into Study) this Year",null,{"$f":"SUM(C38, '1st Quarter Report'!C38)","v":0}]
["EFFORTS TO DISSEMINATE THE PROJECT/PROGRAM FINDINGS TO BENEFIT OTHERS IN THE FIELD",null,"TITLE OF PRESENTATION/REPORT/ARTICLE, PLACE PRESENTED/PUBLISHED, DATE, AUTHORS "]
["EX: Dissemination Effort 1",null,"Panel: Community Partnerships in Family Law, Association of Family and Conciliation Courts, May 2021, Smith, James, & Johnson "]
["Dissemination Effort 1"]
["Dissemination Effort 2"]
["ADDITIONAL COMMENTS"]

{"sheet":"3rd Quarter Report","index":4,"n_rows":44,"n_cols":3,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,0,0,2],[3,0,3,2],[4,0,4,2],[44,0,44,1],[1,0,1,2],[2,0,2,2]]}
["Fields in yellow are for data entry.  "]
["Indiana Supreme Court"]
["Office of Court Services"]
["Family Court"]
["QUARTERLY REPORT 2022"]
[null,"                 "]
["Court Name",null,{"$f":"'1st Quarter Report'!C7","v":0}]
["Person(s) Preparing Report"]
[]
["Date Report Prepared"]
["STATED PROJECT AIMS (from approved grant application)",null,"PROGRESS MADE ON EACH AIM"]
["EX: Aim 1: Provide free mediation to low income families",null,"EX: Aim complete - We contracted four part-time mediators to provide free mediation services for low income families. "]
["Aim 1: (Fill in your project aims here)",null,"(Fill in your progress made toward achieving your Aim here)"]
["Aim 2: (Fill in your project aims here)",null,"(Fill in your progress made toward achieving your Aim here)"]
["Aim 3: (Fill in your project aims here)",null,"(Fill in your progress made toward achieving your Aim here)"]
["Aim 4: (Fill in your project aims here)",null,"(Fill in your progress made toward achieving your Aim here)"]
["If any aims were modified since the proposal was written, please explain briefly"]
["APPLICATIONS SUBMITTED THIS QUARTER FOR ADDITIONAL FAMILY COURT FUNDING",null,"AMOUNT REQUESTED, DATE SUBMITTED"]
["EX: APPLICATION 1:",null,"Ex: $5,000, September 20, 2021"]
["APPLICATION 1:",null,"(Enter information about any application submitted, or that none were)"]
["APPLICATION 2:",null,"(Enter information about any application submitted, or that none were)"]
["APPLICATIONS SUBMITTED THIS QUARTER FOR ADDITIONAL FUNDING FROM OTHER SOURCES (i.e., not requests to the IOCS for Family Court grants)",null,"TITLE OF GRANT, AMOUNT REQUESTED, DATE SUBMITTED, OUTCOME (funding obtained or not)"]
["EX: APPLICATION 1:",null,"National Science Foundation Law & Social Sciences Grant, $100,000, September 10, 2021, no funding obtained so will reapply"]
["APPLICATION 1:",null,"(Enter information about any application submitted, or that none were)"]
["APPLICATION 2:",null,"(Enter information about any application submitted, or that none were)"]
["INCOME (Do NOT include in-kind income)"]
["Beginning Balance",{"$f":"'2nd Quarter Report'!B35","v":0}]
["Family Court grant funds received",0]
["Other funds received",0]
["TOTAL",{"$f":"SUM(B27:B29)","v":0}]
["EXPENDITURES (Do NOT include in-kind expenditures)"]
["Personnel Expenditures",0]
["Non-Personnel Expenditures",0]
["TOTAL",{"$f":"SUM(B32:B33)","v":0}]
["ENDING BALANCE",{"$f":"SUM(B30-B34)","v":0}]
["If major changes from proposed budget, briefly explain why such changes were necessary"]
["DATA ",null,"(only include families that are related to expenditures of FC monies)"]
["New Families Served (or Matriculated into Study) this Quarter"]
["New Families Served  (or Matriculated into Study) this Year",null,{"$f":"SUM(C38, '2nd Quarter Report'!C39)","v":0}]
["EFFORTS TO DISSEMINATE THE PROJECT/PROGRAM FINDINGS TO BENEFIT OTHERS IN THE FIELD",null,"TITLE OF PRESENTATION/REPORT/ARTICLE, PLACE PRESENTED/PUBLISHED, DATE, AUTHORS "]
["EX: Dissemination Effort 1",null,"Panel: Community Partnerships in Family Law, Association of Family and Conciliation Courts, September 202, Smith, James, & Johnson "]
["Dissemination Effort 1"]
["Dissemination Effort 2"]
["ADDITIONAL COMMENTS"]

{"sheet":"4th Quarter Report","index":5,"n_rows":45,"n_cols":3,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,0,0,2],[4,0,4,2],[45,0,45,1],[1,0,1,2],[2,0,2,2],[3,0,3,2],[35,2,36,2]]}
["Fields in yellow are for data entry.  "]
["Indiana Supreme Court"]
["Office of Court Services"]
["Family Court"]
["QUARTERLY REPORT 2022"]
[null,"                 "]
["Court Name",null,{"$f":"'1st Quarter Report'!C7","v":0}]
["Person(s) Preparing Report"]
[]
["Date Report Prepared"]
["STATED PROJECT AIMS (from approved grant application)",null,"PROGRESS MADE ON EACH AIM"]
["EX: Aim 1: Provide free mediation to low income families",null,"EX: Aim complete - We contracted four part-time mediators to provide free mediation services for low income families. "]
["Aim 1: (Fill in your project aims here)",null,"(Fill in your progress made toward achieving your Aim here)"]
["Aim 2: (Fill in your project aims here)",null,"(Fill in your progress made toward achieving your Aim here)"]
["Aim 3: (Fill in your project aims here)",null,"(Fill in your progress made toward achieving your Aim here)"]
["Aim 4: (Fill in your project aims here)",null,"(Fill in your progress made toward achieving your Aim here)"]
["If any aims were modified since the proposal was written, please explain briefly"]
["APPLICATIONS SUBMITTED THIS QUARTER FOR ADDITIONAL FAMILY COURT FUNDING",null,"AMOUNT REQUESTED, DATE SUBMITTED"]
["EX: APPLICATION 1:",null,"Ex: $5,000, November 20, 2021"]
["APPLICATION 1:",null,"(Enter information about any application submitted, or that none were)"]
["APPLICATION 2:",null,"(Enter information about any application submitted, or that none were)"]
["APPLICATIONS SUBMITTED THIS QUARTER FOR ADDITIONAL FUNDING FROM OTHER SOURCES (i.e., not requests to the IOCS for Family Court grants)",null,"TITLE OF GRANT, AMOUNT REQUESTED, DATE SUBMITTED, OUTCOME (funding obtained or not)"]
["EX: APPLICATION 1:",null,"National Science Foundation Law & Social Sciences Grant, $100,000, November 10, 2021, no funding obtained so will reapply"]
["APPLICATION 1:",null,"(Enter information about any application submitted, or that none were)"]
["APPLICATION 2:",null,"(Enter information about any application submitted, or that none were)"]
["INCOME (Do NOT include in-kind income)"]
["Beginning Balance",{"$f":"'3rd Quarter Report'!B35","v":0}]
["Family Court grant funds received",0]
["Other funds received",0]
["TOTAL",{"$f":"SUM(B27:B29)","v":0}]
["EXPENDITURES (Do NOT include in-kind expenditures)"]
["Personnel Expenditures",0]
["Non-Personnel Expenditures",0]
["TOTAL",{"$f":"SUM(B32:B33)","v":0}]
["ENDING BALANCE",{"$f":"SUM(B30-B34)","v":0}]
["If major changes from proposed budget, briefly explain why such changes were necessary"]
[]
["DATA ",null,"(only include families that are related to expenditures of FC monies)"]
["New Families Served (or Matriculated into Study) this Quarter"]
["New Families Served  (or Matriculated into Study) this Year",null,{"$f":"SUM(C39, '3rd Quarter Report'!C39)","v":0}]
["EFFORTS TO DISSEMINATE THE PROJECT/PROGRAM FINDINGS TO BENEFIT OTHERS IN THE FIELD",null,"TITLE OF PRESENTATION/REPORT/ARTICLE, PLACE PRESENTED/PUBLISHED, DATE, AUTHORS "]
["EX: Dissemination Effort 1",null,"Panel: Community Partnerships in Family Law, Association of Family and Conciliation Courts, November 2021, Smith, James, & Johnson "]
["Dissemination Effort 1"]
["Dissemination Effort 2"]
["ADDITIONAL COMMENTS"]