{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Guidance","Group Submission","Individual Family Outcomes Form","National Outcomes Framework","Family Outcomes April-May 2024","Stuff to Do","SourceData"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":45,"comments":2,"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":"Guidance","index":0,"n_rows":54,"n_cols":5,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[null,"Overall Process Flow Chart",null,null,"General Guidance"]
[]
[null,null,null,null,"·     Please ensure that you edit this file in the Excel Desktop App."]
[null,null,null,null,"·     Please ensure that you allow Macros to work on this workbook if requested to do so."]
[null,null,null,null,"Click here for instructions on how to Enable Macros"]
[null,null,null,null,"·     We have included checks within this Multiple Submissions Form that entries are of the appropriate type, please ensure that any instructions in pop ups are followed to aid in the processing of the form as efficiently as possible."]
[null,null,null,null,"·     Enter the Name, and DFEE number, of the Education Setting on the Group Submission tab first."]
[null,null,null,null,"·     Note each individual claim is for working with the Entire Family, and should be completed using the Individual Family Outcomes form. "]
[null,null,null,null,"·     For your guidance Comments have been added to the Group Submission tab. Cells that have a Comment have a Red Triangle in the top left Corner of the cell. When you rest your mouse pointer on the cell, the comment will appear."]
[null,null,null,null,"·         Each submitted case has the potential to be submitted if the following can be demonstrated:"]
[null,null,null,null,"o   The work with the Family was either started or finished within 2 years.\n\no   The work with the Family was either  finished for at least 6 months.\n\n[There is a table on the Individual Family Outcomes Form showing the months of the Closure Date relative to when the TF Data Team can potentially  claim the submission. \nAny submissions that can not be claimed, as they have not be closed for 6 months will be retained until they can be claimed.] "]
[null,null,null,null,"o   The needs of the whole family must have been investigated and then addressed."]
[null,null,null,null,"o   Case recordings need to show that needs were assessed and plans put in place"]
[null,null,null,null,"Some needs may have been addressed to the best of a worker’s capacity but the long term solution was not available\n\ne.g. temporary accommodation\n\nIn these circumstances, the worker will have done everything they can to improve the impact/ issue without in many circumstances finding a new tenancy and the family will remain in temporary accommodation after the case closed.  The fact that the worker has taken all steps available to improve the outcome is evidence of progress on this need."]
[null,null,null,null,"·    Only one row needs to completed on the Group submission form, or one Individual Family Outcomes form, per family"]
[null,null,null,null,"·     Plans can come in various forms:"]
[null,null,null,null,"·         Email lists"]
[null,null,null,null,"·         List of actions in word"]
[null,null,null,null,"·         Handwritten notes"]
[null,null,null,null,"·         case notes"]
[null,null,null,null,"·      Our Family Plans"]
[null,null,null,null,"·         Early Help Plans"]
[null,null,null,null,"·      3 Houses"]
[null,null,null,null,"·         Complete all of the appropriate fields for each family. "]
[null,null,null,null,"·         Upon submission the case will be reviewed by the Think Family Data Team to confirm eligibility for Family Outcomes.  If the Certificate is not complete then it will be returned for completion and resubmission"]
[null,null,null,null,"·         Around 10% of all cases put forward to Submission will be audited, if sufficient evidence of the Work performed is included on this form then the TF Data Team will not need to contact you for further evidence.\ne.g. if the need recognised was around \"Parenting Support\" then if it was noted that the work Performed was \"work performed was around Routines and Boundaries\" then we will not need to contact you for further evidence."]
[null,null,null,null,"·         Ensure the information entered is accuarate, to ensure that it can be matched to the information on the Think Family Databases."]
[null,null,null,null,"·         The Spreadsheet is to be locked using the button as this checks that the appropriate cells have values, prior to being emailed to the Think Family Data Team at TFDATA@birminghamchildrenstrust.co.uk"]
[]
[null,null,null,null,"Needs Identified"]
[null,null,null,null,"·         A Need has to be indentified in at  least 3 of the Need Categories listed below:"]
[null,null,null,null,"1.Getting a Good Education"]
[null,null,null,null,"2. Good Early Years Development"]
[null,null,null,null,"3. Improved Mental and Physical Health"]
[null,null,null,null,"4. Promoting Recovery and Reducing Harm from Substance Use"]
[null,null,null,null,"5. Improved Family Relationships"]
[null,null,null,null,"6. Children Safe from Abuse and Exploitation"]
[null,null,null,null,"7. Crime Prevention and Tackling Crime"]
[null,null,null,null,"8. Safe from Domestic Abuse"]
[null,null,null,null,"9. Secure Housing"]
[null,null,null,null,"10. Financial Stability"]
[null,null,null,null,"·         select specific Needs from the drop down boxes"]
[null,null,null,null,"For further details please click here for the National Outcomes Framework\n[Note: that this will automatically open the associated pdf.]"]
[null,null,null,null,"For further details please click here for the presentation: Family Outcomes April - May 2024\n[Note: that this will automatically open the associated pdf.]"]
[]
[null,null,null,null,"Needs Resolved"]
[]
[null,null,null,null,"·         All needs identified for the family must have improved at the time the case was closed"]
[null,null,null,null,"·         If new needs have been identified during the intervention they should also have been resolved."]
[null,null,null,null,"·         You must have no further / ongoing concerns about this family"]
[]
[null,null,null,null,"Declaration"]
[]
[null,null,null,null,"·         This form must be signed by the Dedicated Safeguarding Lead (DSL) or Deputy DSL/lead worker for the case. This is achieved by typing the appropriate name in the signature field."]

{"sheet":"Group Submission","index":1,"n_rows":50,"n_cols":65,"rows_kept":50,"cut":false,"hidden":false,"merged":[[8,12,8,21],[7,2,7,21],[4,9,4,10],[5,9,5,10],[8,26,8,35],[0,1,2,10],[0,14,0,22],[7,22,7,23],[4,7,4,8],[5,7,5,8],[5,1,5,2],[5,5,5,6],[4,5,4,6],[4,1,4,2],[4,3,4,4],[5,3,5,4],[2,12,2,21],[3,12,3,21],[4,12,4,21],[5,12,5,21]]}
[null,"Payment by Results Group Certificate",null,null,null,null,null,null,null,null,null,null,null,"data","This Form is Unlocked, Lock the Form, prior to submitting."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Declaration"]
[null,null,null,null,null,null,null,null,null,null,null,null,"I confirm that all the family’s needs were identified / resolved for each of the interventions recorded below  and the information below is accurate"]
[null,"Name of School, Nursery or Children's Centre",null,"DFEE Number\ne.g. 330 -1234",null,"Contracted Agency Name",null,"Date Form Completed",null,"Submission is for",null,null,"An assessment and action plan (even if this is the same document) was in place to meet these needs of the family. \n    Examples include:  Three houses, My Concern case recording or Early Help Assessment / Education Health Care Plans."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Signature\n                    (Please enter the Name of the individual Authorising this submission)"]
[null,null,null,{"$f":"VLOOKUP(TODAY(),quarter,2,TRUE)","v":"2023-01-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-05-01"]
[null,null,"Complete the Information in the Area below.\nThe Row will be red whilst there is insufficient Information for a Valid Submission, with the missing information highlighted.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please do not enter any information in the cells below"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Needs Identified and Resolved",null,null,null,null,null,null,null,null,null,null,null,null,null,"work performed"]
[null,"ID Number","Key Worker","Date Interv'n Opened","Date Interv'n Closed","Pupils First Name","Pupils Middle Name(s)","Pupils Family Name","Pupil UPN","Date of Birth","First Line of the Address, incl Flat Address","Post Code","Getting a Good Education","Good Early Years Development","Improved Mental and Physical Health","Promoting Recovery and Reducing Harm from Substance Use","Improved Family Relationships","Children Safe from Abuse and Exploitation","Crime Prevention and Tackling Crime","Safe from Domestic Abuse","Secure Housing","Financial Stability","Valid Subm'n","Additional Inform'n Added",null,null,"Getting a Good Education","Good Early Years Development","Improved Mental and Physical Health","Promoting Recovery and Reducing Harm from Substance Use","Improved Family Relationships","Children Safe from Abuse and Exploitation","Crime Prevention and Tackling Crime","Safe from Domestic Abuse","Secure Housing","Financial Stability",{"$f":"SUM(needs_check)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,AV11:AV40)","v":""}]
[{"$f":"IF(COUNTA(C11:V11)>0,ROW(A11)-10,\"\")","v":""},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA($C11:$V11)=0,\n\"\",\nIF(AND(\nNOT(ISBLANK($C11)),\nNOT(ISBLANK($D11)),\nCOUNTA($M11:$V11)>=3,\n$E11>=$D$7,\n$F11<>\"\",\n$H11<>\"\",\n$K11<>\"\",\n$L11<>\"\",\n$X11=\"Yes\",\nOR(NOT(ISBLANK($I11)),NOT(ISBLANK($J11)))\n),\"Yes\",\"No\"))","v":""},{"$f":"IF(COUNTA($AA11:$AJ11)>=3,\"Yes\",\"no\")","v":"no"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AND(ISBLANK(M11),ISBLANK(AA11)),AND(NOT(ISBLANK(M11)),NOT(ISBLANK(AA11)))),0,1)","v":0},{"$f":"IF(OR(AND(ISBLANK(N11),ISBLANK(AB11)),AND(NOT(ISBLANK(N11)),NOT(ISBLANK(AB11)))),0,1)","v":0},0,0,0,0,0,0,0,0,{"$f":"IF(SUM(AL11:AU11)>0,B11,\"\")","v":""}]
[{"$f":"IF(COUNTA(C12:V12)>0,ROW(A12)-10,\"\")","v":""},2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA($C12:$V12)=0,\n\"\",\nIF(AND(\nNOT(ISBLANK($C12)),\nNOT(ISBLANK($D12)),\nCOUNTA($M12:$V12)>=3,\n$E12>=$D$7,\n$F12<>\"\",\n$H12<>\"\",\n$K12<>\"\",\n$L12<>\"\",\n$X12=\"Yes\",\nOR(NOT(ISBLANK($I12)),NOT(ISBLANK($J12)))\n),\"Yes\",\"No\"))","v":""},"no",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AND(ISBLANK(M12),ISBLANK(AA12)),AND(NOT(ISBLANK(M12)),NOT(ISBLANK(AA12)))),0,1)","v":0},{"$f":"IF(OR(AND(ISBLANK(N12),ISBLANK(AB12)),AND(NOT(ISBLANK(N12)),NOT(ISBLANK(AB12)))),0,1)","v":0},{"$f":"IF(OR(AND(ISBLANK(O12),ISBLANK(AC12)),AND(NOT(ISBLANK(O12)),NOT(ISBLANK(AC12)))),0,1)","v":0},{"$f":"IF(OR(AND(ISBLANK(P12),ISBLANK(AD12)),AND(NOT(ISBLANK(P12)),NOT(ISBLANK(AD12)))),0,1)","v":0},{"$f":"IF(OR(AND(ISBLANK(Q12),ISBLANK(AE12)),AND(NOT(ISBLANK(Q12)),NOT(ISBLANK(AE12)))),0,1)","v":0},{"$f":"IF(OR(AND(ISBLANK(R12),ISBLANK(AF12)),AND(NOT(ISBLANK(R12)),NOT(ISBLANK(AF12)))),0,1)","v":0},{"$f":"IF(OR(AND(ISBLANK(S12),ISBLANK(AG12)),AND(NOT(ISBLANK(S12)),NOT(ISBLANK(AG12)))),0,1)","v":0},{"$f":"IF(OR(AND(ISBLANK(T12),ISBLANK(AH12)),AND(NOT(ISBLANK(T12)),NOT(ISBLANK(AH12)))),0,1)","v":0},{"$f":"IF(OR(AND(ISBLANK(U12),ISBLANK(AI12)),AND(NOT(ISBLANK(U12)),NOT(ISBLANK(AI12)))),0,1)","v":0},{"$f":"IF(OR(AND(ISBLANK(V12),ISBLANK(AJ12)),AND(NOT(ISBLANK(V12)),NOT(ISBLANK(AJ12)))),0,1)","v":0},{"$f":"IF(SUM(AL12:AU12)>0,B12,\"\")","v":""}]
[{"$f":"IF(COUNTA(C13:V13)>0,ROW(A13)-10,\"\")","v":""},3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
["",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(COUNTA($AA14:$AJ14)>=3,\"Yes\",\"no\")","v":"no"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
[{"$f":"IF(COUNTA(C15:V15)>0,ROW(A15)-10,\"\")","v":""},5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
[{"$f":"IF(COUNTA(C16:V16)>0,ROW(A16)-10,\"\")","v":""},6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
["",7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
["",8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
["",9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
["",10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
["",11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
["",12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
[{"$f":"IF(COUNTA(C23:V23)>0,ROW(A23)-10,\"\")","v":""},13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
["",14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
["",15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
["",16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
["",17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
["",18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
["",19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
["",20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
["",21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
["",22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
[{"$f":"IF(COUNTA(C33:V33)>0,ROW(A33)-10,\"\")","v":""},23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
["",24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
["",25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
["",26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
["",27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
["",28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
["",29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
[{"$f":"IF(COUNTA(C40:V40)>0,ROW(A40)-10,\"\")","v":""},30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","no",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COLUMN(AJ47)","v":36},{"$f":"COLUMN(AK47)","v":37},{"$f":"COLUMN(AL47)","v":38}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ID",1,2,3,4,5,6,7,8,9,10,11,12,null,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]

{"sheet":"Individual Family Outcomes Form","index":2,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[16,8,17,10],[21,4,21,6],[22,4,22,6],[23,4,23,6],[24,4,24,6],[20,2,20,3],[0,7,1,8],[28,4,28,6],[29,4,29,6],[17,4,18,6],[10,8,11,8],[0,1,0,6],[1,1,1,6],[14,1,14,2],[15,1,15,2],[6,1,6,6],[27,2,27,3],[28,2,28,3],[29,2,29,3],[19,2,19,3],[19,4,19,6],[20,4,20,6],[10,9,11,9],[10,10,11,10],[13,8,14,8],[13,9,14,9],[13,10,14,10],[25,4,25,6],[26,4,26,6],[27,4,27,6],[25,2,25,3],[26,2,26,3]]}
[null,"This Form is Unlocked, Lock the Form, prior to submitting.",null,null,null,null,null,null,null,"COUNT OF TOTAL VALID SUBMISSIONS",{"$f":"COUNTIF('Group Submission'!$W$11:$W$40,\"Yes\")","v":0}]
[null,{"$f":"IF(AND(\nCOUNTA($B$13,$D$13,'Individual Family Outcomes Form'!$E$13:$F$13,'Individual Family Outcomes Form'!$B$16:$F$16)>=8,\nCOUNTA('Individual Family Outcomes Form'!$C$21:$C$30)>=3,\nCOUNTA('Individual Family Outcomes Form'!$E$21:$E$30)>=3,\nCOUNTIFS(NeedsVsWork,2)>=3),\n\"This Claim is Valid for Submission\",\"This Claim is not Valid for Submission\")","v":"This Claim is not Valid for Submission"},null,null,null,null,null,null,null,"COUNT OF TOTAL INVALID SUBMISSIONS",{"$f":"COUNTIF('Group Submission'!$W$11:$W$40,\"No\")","v":0}]
[]
[]
[]
[]
[null,"Individual Payment by Results Certificate",null,null,null,null,null,null,"PROCESSING MONTH BY TF DATA TEAM","INTERVENTION CLOSED AFTER START OF","INTERVENTION CLOSED BEFORE END OF",null,"data"]
[null,null,null,null,null,null,null,null,"2024-10-01","2022-10-01","2024-04-01"]
[null,"Submission ID No","Key Worker","Agency","School","DFEE Number",null,null,"2024-11-01","2022-11-01","2024-05-01"]
[null,1,null,null,null,null,null,null,"2024-12-01","2022-12-01","2024-06-01"]
[null,null,null,null,null,null,null,null,"2025-01-01","2023-01-01","2024-07-01"]
[null,"Pupils First Name","Pupils Middle Name(s)","Pupils Family Name","Pupil UPN","Date of Birth"]
[null,null,null,null,null,null,null,null,"2025-02-01","2023-02-01","2024-08-01"]
[null,null,null,null,null,null,null,null,"2025-03-01","2023-03-01","2024-09-01"]
[null,"First Line of the Address, incl Flat Address",null,"Post Code","Date Interv'n Opened","Date Interv'n Closed"]
[]
[null,null,null,null,null,null,null,null,"Controls\nPlease Use to Operate the Form\n[These are not printed]"]
[null,null,null,null,"Notes: Please note that this area is obligatory \n(To enter a return in the Text press Alt and Enter simultaneously)"]
[]
[null,"Category","Need",null,"Work Performed for Need"]
[null,"Getting a Good Education",null,null,null,null,null,{"$f":"COUNTA(C21:G21)","v":0}]
[{"$f":"IF(OR(COUNTIF($C22:$G22,D$22)>1,COUNTIF($C22:$G22,E$22)>1,COUNTIF($C22:$G22,F$22)>1,COUNTIF($C22:$G22,F$22)>1,COUNTIF($C22:$G22,G$22)>1,COUNTIF($C22:$D22,H$22)>1),\"Select different Problems for this Category!\",\"\")","v":""},"Good Early Years Development",null,null,null,null,null,{"$f":"COUNTA(C22:G22)","v":0}]
[null,"Improved Mental and Physical Health",null,null,null,null,null,0]
[null,"Promoting Recovery and Reducing Harm from Substance Use",null,null,null,null,null,0]
[null,"Improved Family Relationships",null,null,null,null,null,0]
[null,"Children Safe from Abuse and Exploitation",null,null,null,null,null,0]
[{"$f":"IF(OR(COUNTIF($C27:$G27,C$27)>1,COUNTIF($C27:$G27,D$27)>1,COUNTIF($C27:$G27,E$27)>1,COUNTIF($C27:$G27,E$27)>1,COUNTIF($C27:$G27,F$27)>1,COUNTIF($C27:$D27,G$27)>1),\"Select different Problems for this Category!\",\"\")","v":""},"Crime Prevention and Tackling Crime",null,null,null,null,null,0]
[{"$f":"IF(OR(COUNTIF($C28:$G28,C$28)>1,COUNTIF($C28:$G28,D$28)>1,COUNTIF($C28:$G28,E$28)>1,COUNTIF($C28:$G28,E$28)>1,COUNTIF($C28:$G28,F$28)>1,COUNTIF($C28:$D28,G$28)>1),\"Select different Problems for this Category!\",\"\")","v":""},"Safe from Domestic Abuse",null,null,null,null,null,0]
[null,"Secure Housing",null,null,null,null,null,0]
[{"$f":"IF(OR(COUNTIF($C30:$G30,C$30)>1,COUNTIF($C30:$G30,D$30)>1,COUNTIF($C30:$G30,E$30)>1,COUNTIF($C30:$G30,E$30)>1,COUNTIF($C30:$G30,F$30)>1,COUNTIF($C30:$D30,G$30)>1),\"Select different Problems for this Category!\",\"\")","v":""},"Financial Stability",null,null,null,null,null,0]

{"sheet":"National Outcomes Framework","index":3,"n_rows":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,0,31,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["National Outcomes Framework - Double Click to Open In pdf Reader"]

{"sheet":"Family Outcomes April-May 2024","index":4,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,1,30,12]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Presentation - Family Outcomes April-May 2024 - Double Click to Open In pdf Reader"]

{"sheet":"Stuff to Do","index":5,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[1]
[2]
[3]
[4]
[5]
[6,"All data to be copied onto one worksheet, probably hidden, to allow for easy extraction"]
[7]
[8,"locked so little that they can do outside of the stuff that we want them to do"]
[9,"password protect the macros"]
[10,"lock the buttons so that they cant be moved or changed"]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]

{"sheet":"SourceData","index":6,"n_rows":12,"n_cols":45,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[null,"cat 1","cat 2","cat 3","cat 4","cat 5","cat 6","cat 7","cat 8","cat 9","cat 10"]
[null,"Educ","Early_Yeara","Health","Substance","Relationships","Abuse","Crime","DV","Housing","Finance"]
[null,"Getting a Good Education","Good Early Years Development","Improved Mental and Physical Health","Promoting Recovery and Reducing Harm from Substance Use","Improved Family Relationships","Children Safe from Abuse and Exploitation","Crime Prevention and Tackling Crime","Safe from Domestic Abuse","Secure Housing","Financial Stability",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-01-01","2022-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-04-01","2022-04-01"]
["Yes","Average of less than 90% attendance including authorised absence is optional for 2 consecutive terms","Expectant or new parent/carers who require additional or specialist support e.g. young parents parents who have been in care parents with learning needs","Baby / Child needs support with their mental health","An adult has a drug and/or alcohol problem","Parent / carers require parenting support","Emotional physical sexual abuse or neglect historic or current within the household","Adult 18+ involved in crime and/or ASB at least one offence/arrest/named as a suspect/ASB incident in the last 12 months","Family affected by domestic abuse or inter-personal violence and abuse - historic recent current or at risk victim","Families who are in local authority temporary accommodation and are at risk of losing this","Adult in the family is workless",null,"School",null,{"$f":"\".Add Item \"\"\"&C5&\"\"\"\"","v":".Add Item \"Expectant or new parent/carers who require additional or specialist support e.g. young parents parents who have been in care parents with learning needs\""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-07-01","2022-07-01"]
["No","Average of less than 50% attendance unauthorised and authorised for 2 consecutive terms","Child’s 0-5 yrs physical health needs not met e.g. immunisations not up to date concerning accidental injuries dental hygiene","Adult needs support with their mental health","A child or young person has a drug and/or alcohol problem","Harmful levels of parental conflict i.e. when it is frequent intense or poorly resolved","Child going missing from home","Young person u18 at risk of crime – including gangs serious violence and weapons carrying or involved in harmful risk taking behaviour","Adult in the family is a perpetrator of domestic abuse","Families not in suitable sustainable housing and/or threatened with eviction /at risk of homelessness","Family require support with their finances and / or have unmanageable debt e.g. rent arrears",null,"Children's Centre",null,{"$f":"\".Add Item \"\"\"&C6&\"\"\"\"","v":".Add Item \"Child’s 0-5 yrs physical health needs not met e.g. immunisations not up to date concerning accidental injuries dental hygiene\""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-10-01","2022-10-01"]
[null,"Not able to participate and engage with education – motivation emotional regulation and behaviour difficulties","Child's 0-5 yrs developmental needs not being met e.g. communication skills/speech and language problems solving school readiness personal social and emotional development","Child and/or parent/carer require support with learning disabilities neurodiverse conditions and/or physical health needs that affect the family e.g. long-standing health conditions requiring management physical disabilities requiring adaptations",null,"Child / young person violent or abusive in the home to parents/carers or siblings","Child identified as at risk of or experiencing sexual exploitation","Young person u18 involved in crime and/or ASB at least one offence/arrest/ named as a suspect/ASB incident in the last 12 months","Child currently or historically affected by domestic abuse","Young people aged 16/17 at risk of or who have been excluded from the family home","Young person is NEET",null,"School and Agency carried out work",null,{"$f":"\".Add Item \"\"\"&C7&\"\"\"\"","v":".Add Item \"Child's 0-5 yrs developmental needs not being met e.g. communication skills/speech and language problems solving school readiness personal social and emotional development\""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-01-01","2023-01-01"]
[null,"Risk of or subject to exclusions",null,null,null,"Unsupported young carer or caring circumstances changed requiring additional support","Child identified as at risk of or experiencing criminal or pre-criminal exploitation e.g. county lines",null,null,null,null,null,null,null,{"$f":"\".Add Item \"\"\"&C8&\"\"\"\"","v":".Add Item \"\""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-04-01","2023-04-01"]
[null,"Concerns around suitability of Elective Home Education",null,null,null,null,"Child identified as at risk of or being affected by radicalisation",null,null,null,null,null,null,null,{"$f":"\".Add Item \"\"\"&C9&\"\"\"\"","v":".Add Item \"\""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-07-01","2023-07-01"]
[null,"Child is off-roll and not receiving an education otherwise risk of NEET",null,null,null,null,"Child experiencing harm outside of the family e.g. peer to peer abuse bullying online harassment sexual harassment/offences",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-10-01","2023-10-01"]
[null,"Child's special educational needs not being met",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-01-01","2024-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-04-01","2024-04-01"]