{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Title","Initial","Full","Crown Court"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":1,"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":"Title","index":0,"n_rows":55,"n_cols":11,"rows_kept":55,"cut":false,"hidden":false,"merged":[[52,2,52,7],[54,4,54,6]]}
[]
[null,null,null,null,null,null,null,null,null,null,"NB : NCCTProtected1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"LAA Criminal Legal Aid Eligibility Web Page"]
[]
[null,null,null,null,"Start Assessment"]

{"sheet":"Initial","index":1,"n_rows":42,"n_cols":17,"rows_kept":42,"cut":false,"hidden":false,"merged":[[2,10,2,13],[12,4,12,5],[12,10,12,11],[19,4,19,5],[19,10,19,11],[20,4,20,5],[20,10,20,11],[35,11,35,14],[36,11,36,14],[38,6,38,14],[39,6,39,14],[41,1,41,2],[41,12,41,14],[36,8,36,9],[35,6,35,9],[36,3,36,4]]}
[null,"Initial Assessment"]
[]
[null,null,null,null,null,null,null,null,null,null,"Include Partner?",null,null,null,"no",null,"yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"no"]
[null,"Actual Income Values"]
[null,"Categories","Applicant",null,null,null,null,null,"Partner",null,null,null,null,null,"Total Annual"]
[null,null,"Amount","Frequency","x","Annual",null,null,"Amount","Frequency","x","Annual"]
[null,"Employment Income",0,"weekly",{"$f":"52*(D8=\"weekly\")+26*(D8=\"fortnightly\")+13*(D8=\"four-weekly\")+12*(D8=\"monthly\")+1*(D8=\"annually\")","v":52},{"$f":"C8*E8","v":0},null,null,0,"weekly",{"$f":"52*(J8=\"weekly\")+26*(J8=\"fortnightly\")+13*(J8=\"four-weekly\")+12*(J8=\"monthly\")+1*(J8=\"annually\")","v":52},{"$f":"I8*K8*(O$3=\"yes\")","v":0},null,null,{"$f":"F8+L8","v":0},null,"weekly"]
[null,"Self employed",0,"weekly",{"$f":"52*(D9=\"weekly\")+26*(D9=\"fortnightly\")+13*(D9=\"four-weekly\")+12*(D9=\"monthly\")+1*(D9=\"annually\")","v":52},{"$f":"C9*E9","v":0},null,null,0,"weekly",{"$f":"52*(J9=\"weekly\")+26*(J9=\"fortnightly\")+13*(J9=\"four-weekly\")+12*(J9=\"monthly\")+1*(J9=\"annually\")","v":52},{"$f":"I9*K9*(O$3=\"yes\")","v":0},null,null,{"$f":"F9+L9","v":0},null,"fortnightly"]
[null,"Private Pensions",0,"weekly",{"$f":"52*(D10=\"weekly\")+26*(D10=\"fortnightly\")+13*(D10=\"four-weekly\")+12*(D10=\"monthly\")+1*(D10=\"annually\")","v":52},{"$f":"C10*E10","v":0},null,null,0,"weekly",{"$f":"52*(J10=\"weekly\")+26*(J10=\"fortnightly\")+13*(J10=\"four-weekly\")+12*(J10=\"monthly\")+1*(J10=\"annually\")","v":52},{"$f":"I10*K10*(O$3=\"yes\")","v":0},null,null,0,null,"four-weekly"]
[null,"Maintenance",0,"weekly",{"$f":"52*(D11=\"weekly\")+26*(D11=\"fortnightly\")+13*(D11=\"four-weekly\")+12*(D11=\"monthly\")+1*(D11=\"annually\")","v":52},{"$f":"C11*E11","v":0},null,null,0,"weekly",{"$f":"52*(J11=\"weekly\")+26*(J11=\"fortnightly\")+13*(J11=\"four-weekly\")+12*(J11=\"monthly\")+1*(J11=\"annually\")","v":52},{"$f":"I11*K11*(O$3=\"yes\")","v":0},null,null,0,null,"monthly"]
[null,"Other Income",0,"weekly",{"$f":"52*(D12=\"weekly\")+26*(D12=\"fortnightly\")+13*(D12=\"four-weekly\")+12*(D12=\"monthly\")+1*(D12=\"annually\")","v":52},{"$f":"C12*E12","v":0},null,null,0,"weekly",{"$f":"52*(J12=\"weekly\")+26*(J12=\"fortnightly\")+13*(J12=\"four-weekly\")+12*(J12=\"monthly\")+1*(J12=\"annually\")","v":52},{"$f":"I12*K12*(O$3=\"yes\")","v":0},null,null,0,null,"annually"]
[null,"Non Benefits Total",null,"weekly",{"$f":"SUM(F8:F12)","v":0},null,null,null,null,"weekly",{"$f":"SUM(L8:L12)*(O3=\"yes\")","v":0},null,null,null,{"$f":"E13+K13","v":0}]
[null,"Child Benefit",0,"weekly",{"$f":"52*(D14=\"weekly\")+26*(D14=\"fortnightly\")+13*(D14=\"four-weekly\")+12*(D14=\"monthly\")+1*(D14=\"annually\")","v":52},{"$f":"C14*E14","v":0},null,null,0,"weekly",{"$f":"52*(J14=\"weekly\")+26*(J14=\"fortnightly\")+13*(J14=\"four-weekly\")+12*(J14=\"monthly\")+1*(J14=\"annually\")","v":52},{"$f":"I14*K14*(O3=\"yes\")","v":0},null,null,{"$f":"F14+L14","v":0}]
[null,"Tax Credits",0,"weekly",52,0,null,null,0,"weekly",52,{"$f":"I15*K15*(O3=\"yes\")","v":0},null,null,{"$f":"F15+L15","v":0}]
[null,"Incapacity Benefit",0,"weekly",52,0,null,null,0,"weekly",52,{"$f":"I16*K16*(O$3=\"yes\")","v":0},null,null,0]
[null,"State Pension",0,"weekly",52,0,null,null,0,"weekly",52,{"$f":"I17*K17*(O$3=\"yes\")","v":0},null,null,0]
[null,"Industrial Injuries ",0,"weekly",52,0,null,null,0,"weekly",52,{"$f":"I18*K18*(O$3=\"yes\")","v":0},null,null,0]
[null,"Other benefits",0,"weekly",52,0,null,null,0,"weekly",52,{"$f":"I19*K19*(O3=\"yes\")","v":0},null,null,0]
[null,"Benefits Total",null,"weekly",{"$f":"SUM(F14:F19)","v":0},null,null,null,null,"weekly",{"$f":"SUM(L14:L19)*(O3=\"yes\")","v":0},null,null,null,{"$f":"E20+K20","v":0}]
[null,"Total Income",null,"weekly",{"$f":"E13+E20","v":0},null,null,null,null,"weekly",{"$f":"(K13+K20)*(O3=\"yes\")","v":0},null,null,null,{"$f":"E21+K21","v":0}]
[]
[null,"Adjusted Income Details"]
[null,"No. of children 0-1",0.15,0,{"$f":"C24*D24","v":0}]
[null,"No. of children 2-4",0.3,0,0]
[null,"No. of children 5-7",0.34,0,0]
[null,"No. of children 8-10",0.38,0,0]
[null,"No. of children 11-12",0.41,0,0]
[null,"No. of children 13-15",0.44,0,0]
[null,"No. of children 16-18",0.59,0,0]
[null,"partner",0.64,{"$f":"IF(O3=\"yes\",1,0)","v":0},{"$f":"C31*D31","v":0}]
[null,"applicant",1,1,1]
[null,"Equivalisation factor",null,null,{"$f":"SUM(E24:E32)","v":1}]
[]
[null,"Initial Assessment Eligibility Result"]
[null,"Lower Threshold",null,"Upper Threshold",null,null,"Adjusted Income Value",null,null,null,null,"Magistrates' Outcome"]
[null,12475,null,22325,null,null,null,null,{"$f":"O21/E33","v":0},null,null,{"$f":"IF(I37<=B37,\"Eligible\",IF(AND(I37>B37,I37<D37)=TRUE,\"Full Assessment\",IF(I37>=D37,\"Ineligible\")))","v":"Eligible"}]
[]
[null,null,null,null,null,null,"Crown Court Outcome"]
[null,null,null,null,null,null,{"$f":"IF(L37=\"eligible\",\"Eligible, no income contribution\",\"Proceed to Full Assessment & Crown Court Assessment\")","v":"Eligible, no income contribution"}]
[]
[null,"Return to Title Screen",null,null,null,null,null,null,null,null,null,null,"To Full Assessment"]

{"sheet":"Full","index":2,"n_rows":36,"n_cols":18,"rows_kept":36,"cut":false,"hidden":false,"merged":[[40,1,40,3],[35,8,35,10],[33,8,33,11],[11,5,11,6],[11,11,11,12],[16,5,16,6],[16,11,16,12],[21,3,21,4],[21,5,21,6],[22,5,22,6],[24,5,24,6],[26,5,26,6],[28,5,28,6],[32,5,32,6]]}
[null,{"$f":"IF(Initial!L37=\"Full Assessment\",\"Full Assessment\",\"Full Assessment  - not required as initial assessment was decisive\")","v":"Full Assessment  - not required as initial assessment was decisive"}]
[]
[null,0,null,"0",null,null,"Applicant",null,null,null,null,null,"Partner",null,null,"Total"]
[null,"Gross Annual Income",null,null,null,null,{"$f":"Initial!E21","v":0},null,null,null,null,null,{"$f":"Initial!K21","v":0},null,null,{"$f":"G4+M4","v":0},null,"yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"no"]
[null,"Allowable Deductions"]
[null,"Categories",null,"Applicant",null,null,null,null,null,"Partner",{"$f":"IF(Initial!O3=\"no\",\"Not included\",\"\")","v":"Not included"},null,null,null,null,"Total Annual"]
[null,null,null,"Amount","Frequency","x","Annual",null,null,"Amount","Frequency","x","Annual"]
[null,"Rent/Mortgage (net of any Housing Benefit)",null,0,"weekly",{"$f":"52*(E9=\"weekly\")+26*(E9=\"fortnightly\")+13*(E9=\"four-weekly\")+12*(E9=\"monthly\")+1*(E9=\"annually\")","v":52},{"$f":"D9*F9","v":0},null,null,0,"weekly",{"$f":"52*(K9=\"weekly\")+26*(K9=\"fortnightly\")+13*(K9=\"four-weekly\")+12*(K9=\"monthly\")+1*(K9=\"annually\")","v":52},{"$f":"J9*L9*(Initial!O$3=\"yes\")","v":0},null,null,{"$f":"G9+M9","v":0},null,"weekly"]
[null,"Council Tax",null,0,"annually",{"$f":"52*(E10=\"weekly\")+26*(E10=\"fortnightly\")+13*(E10=\"four-weekly\")+12*(E10=\"monthly\")+1*(E10=\"annually\")","v":1},{"$f":"D10*F10","v":0},null,null,0,"weekly",{"$f":"52*(K10=\"weekly\")+26*(K10=\"fortnightly\")+13*(K10=\"four-weekly\")+12*(K10=\"monthly\")+1*(K10=\"annually\")","v":52},{"$f":"J10*L10*(Initial!O$3=\"yes\")","v":0},null,null,0,null,"fortnightly"]
[null,"Board/Lodging",null,0,"weekly",{"$f":"52*(E11=\"weekly\")+26*(E11=\"fortnightly\")+13*(E11=\"four-weekly\")+12*(E11=\"monthly\")+1*(E11=\"annually\")","v":52},{"$f":"D11*F11","v":0},null,null,0,"weekly",52,{"$f":"J11*L11*(Initial!O$3=\"yes\")","v":0},null,null,0,null,"four-weekly"]
[null,"Housing Costs Total",null,null,null,{"$f":"SUM(G9:G11)","v":0},null,null,null,null,null,{"$f":"SUM(M9:M11)","v":0},null,null,null,{"$f":"F12+L12","v":0},null,"monthly"]
[null,"Income Tax",null,0,"weekly",{"$f":"52*(E13=\"weekly\")+26*(E13=\"fortnightly\")+13*(E13=\"four-weekly\")+12*(E13=\"monthly\")+1*(E13=\"annually\")","v":52},{"$f":"D13*F13","v":0},null,null,0,"weekly",52,{"$f":"J13*L13*(Initial!O$3=\"yes\")","v":0},null,null,0,null,"annually"]
[null,"National Insurance",null,0,"weekly",{"$f":"52*(E14=\"weekly\")+26*(E14=\"fortnightly\")+13*(E14=\"four-weekly\")+12*(E14=\"monthly\")+1*(E14=\"annually\")","v":52},{"$f":"D14*F14","v":0},null,null,0,"weekly",52,{"$f":"J14*L14*(Initial!O$3=\"yes\")","v":0},null,null,{"$f":"G14+M14","v":0}]
[null,"Childcare Costs",null,0,"weekly",{"$f":"52*(E15=\"weekly\")+26*(E15=\"fortnightly\")+13*(E15=\"four-weekly\")+12*(E15=\"monthly\")+1*(E15=\"annually\")","v":52},{"$f":"D15*F15","v":0},null,null,0,"weekly",52,{"$f":"J15*L15*(Initial!O$3=\"yes\")","v":0},null,null,0]
[null,"Maintenance",null,0,"weekly",{"$f":"52*(E16=\"weekly\")+26*(E16=\"fortnightly\")+13*(E16=\"four-weekly\")+12*(E16=\"monthly\")+1*(E16=\"annually\")","v":52},{"$f":"D16*F16","v":0},null,null,0,"weekly",52,{"$f":"J16*L16*(Initial!O$3=\"yes\")","v":0},null,null,0]
[null,"Total deductions",null,null,null,{"$f":"SUM(G9:G11)+SUM(G13:G16)","v":0},null,null,null,null,null,{"$f":"(SUM(M9:M11)+SUM(M13:M16))*(Initial!O3=\"yes\")","v":0},null,null,null,{"$f":"F17+L17","v":0}]
[]
[null,"Full Means Test Eligibility Result"]
[]
[null,"Adjusted Living Allowance"]
[null,"Base Amount",null,"Equivalisation",null,"Adjusted Value"]
[null,5676,null,null,{"$f":"Initial!$E$33","v":1},{"$f":"B23*E23","v":5676}]
[]
[null,"Total Annual Aggregated Expenditure",null,null,null,{"$f":"P17+F23","v":5676}]
[]
[null,"Total Annual Disposable Income",null,null,null,{"$f":"P4-P17-F23","v":-5676}]
[]
[null,"Threshold",null,null,null,3398]
[]
[null,"Magistrates' courts Full Means Assessment Outcome"]
[null,{"$f":"IF(Initial!L37<>\"Full Assessment\",\"No full assessment - initial assessment was decisive.\",IF($F$27<=$F$29,\"PASSED\",\"FAILED\"))","v":"No full assessment - initial assessment was decisive."}]
[null,"Crown Court Threshold",null,null,null,37500]
[null,"Crown Court Full Means Assessment Outcome",null,null,null,null,null,null,"Return to Initial Assessment"]
[]
[null,{"$f":"IF($F$27>37499,\"Ineligible - Exceeds max disposable income\",IF($F$27<=$F$29,\"Eligible - Nil contribution\",\"Eligible, Contribution Required\"))","v":"Eligible - Nil contribution"},null,null,null,null,null,null,"Return to Title Screen"]

{"sheet":"Crown Court","index":3,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[[13,22,14,22],[13,23,14,23],[13,18,14,18],[13,19,14,19],[13,20,14,20],[13,21,14,21],[26,1,26,5],[27,1,27,5],[3,1,3,11],[4,1,4,11],[24,5,24,6],[24,11,24,12],[16,3,16,9],[5,1,6,11],[25,1,25,5],[14,1,14,9],[46,1,46,3],[46,8,46,11],[32,1,32,9],[41,1,41,9],[30,1,30,5],[37,1,37,9],[39,1,39,9]]}
[null,"Crown Court Assessment"]
[]
[]
[null,"Crown Court Legal Aid Eligibility"]
[null,{"$f":"IF(K14>37499, \"Ineligible\",\"Eligible, subject to receipt of a completed application form\")","v":"Eligible, subject to receipt of a completed application form"}]
[null,"NB: All indictable and either way cases that are sent, committed or transferred to the Crown Court automatically pass the Interest of Justice test"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monthly disposable income",{"$f":"K14/12*0.9","v":-425.7}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"no"]
[null,"Crown Court Means Test Result"]
[]
[null,"Trials - Income Contribution"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Offence Type","Offence Type Cap Amounts",null,"Month 1 Contribution Amount","Month 2 Contribution Amount","Month 3 Contribution Amount","Month 4 Contribution Amount","Month 5 Contribution Amount","Month 6 Contribution Amount"]
[null,"Annual Disposable income",null,null,null,null,null,null,null,null,{"$f":"Full!F27","v":-5676},null,null,null,null,null,null,null,{"$f":"IF($K$14<$R$7,\"\",IF($R$7*6>VLOOKUP($D$17,$P$15:$Q$25,2,0),$R$7,\"\"))","v":""},{"$f":"IF(S$14=\"\",\"\",IF((VLOOKUP($D$17,$P$15:$Q$25,2,0)-SUM($S$14:S$14))<=$G$19,VLOOKUP($D$17,$P$15:$Q$25,2,0)-SUM($S$14:S$14),$G$19))","v":""},{"$f":"IF(T$14=\"\",\"\",IF((VLOOKUP($D$17,$P$15:$Q$25,2,0)-SUM($S$14:T$14))<=$G$19,VLOOKUP($D$17,$P$15:$Q$25,2,0)-SUM($S$14:T$14),$G$19))","v":""},{"$f":"IF(U$14=\"\",\"\",IF((VLOOKUP($D$17,$P$15:$Q$25,2,0)-SUM($S$14:U$14))<=$G$19,VLOOKUP($D$17,$P$15:$Q$25,2,0)-SUM($S$14:U$14),$G$19))","v":""},{"$f":"IF(V$14=\"\",\"\",IF((VLOOKUP($D$17,$P$15:$Q$25,2,0)-SUM($S$14:V$14))<=$G$19,VLOOKUP($D$17,$P$15:$Q$25,2,0)-SUM($S$14:V$14),$G$19))","v":""},{"$f":"IF(W$14=\"\",\"\",IF((VLOOKUP($D$17,$P$15:$Q$25,2,0)-SUM($S$14:W$14))<=$G$19,VLOOKUP($D$17,$P$15:$Q$25,2,0)-SUM($S$14:W$14),$G$19))","v":""}]
[null,"Payment required from income pending outcome required?",null,null,null,null,null,null,null,null,{"$f":"IF(K14>37499,\"Ineligible\",IF(K14>3398,\"YES\",\"NO\"))","v":"NO"},null,null,null,null,"Class A - Homicide and related grave offences",185806,"yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Class B - Offences involving serious violence or damage, and serious drugs offences",29453,"weekly"]
[null,"Offence Type",null,"Class A - Homicide and related grave offences",null,null,null,null,null,null,null,null,null,null,null,"Class C - Lesser offences involving violence or damage, and less serious drugs offences",7970,"fortnightly"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Class D - Sexual offences and offences against children",13776,"four-weekly"]
[null,"Monthly Contribution Amount",null,null,null,null,{"$f":"IF(K15=\"yes\",M19,\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"ROUNDDOWN(IF(K14/12*0.9>=VLOOKUP($D17,$P12:$Q25,2,0),VLOOKUP($D17,$P12:$Q25,2,0),K14/12*0.9),0)","v":-425},null,null,"Class E - Burglary",6731,"monthly"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Class F - Other offences of dishonesty (£30k or less)",6754,"annually"]
[null,"Upfront Contribution Amount",null,null,null,null,{"$f":"IF(K15=\"yes\",M24,\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"ROUNDDOWN(IF(SUM(S13:X14)=0,G19*5,SUM(S13:X14)),0)","v":{"$error":"#VALUE!"}},null,null,"Class G - Other offences of dishonesty (Over £30k but less than £100k)",117368]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Class H - Miscellaneous other offences",7427]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M21<G19,G19,(M19*5))","v":{"$error":"#VALUE!"}},null,null,"Class I - Offences against public justice and similar offences",28023]
[null,"Trials - Capital and Equity Contribution - If eligible for legal aid",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M23>M21,M21,M23)","v":{"$error":"#VALUE!"}},null,null,"Class J - Serious sexual offences",17892]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Class K - Other offences of dishonesty (over £100k)",153039]
[null,null,null,null,null,null,"Amount"]
[null,"Total of capital and equity held by applicant",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"fortnightly"]
[null,"Total of capital and equity held by applicant's partner",null,null,null,null,0]
[null,"Total Household Capital and Equity",null,null,null,null,{"$f":"SUM(G27:G28)","v":0}]
[]
[null,"Total Household Capital and Equity above £30k threshold",null,null,null,null,{"$f":"IF(N33<=0,\"Nil\",N33)","v":"Nil"}]
[]
[null,"Payment required from Capital and Equity if eligible applicant found guilty and payments already made (if any) have not covered actual defence costs?",null,null,null,null,null,null,null,null,{"$f":"IF(G31=\"nil\",\"No\",\"Yes\")","v":"No"},null,"Equity above 30K",{"$f":"G29-30000","v":-30000}]
[]
[]
[null,"Appeal against magistrates' court conviction, sentence or order"]
[]
[null,"Payment required if appeal against conviction adanboned or dismissed",null,null,null,null,null,null,null,null,{"$f":"IF(Full!F27>3898,\"£500\",\"Nil\")","v":"Nil"}]
[]
[null,"Payment required if appeal against conviction dismissed but sentence is reduced",null,null,null,null,null,null,null,null,{"$f":"IF(Full!F27>3898,\"£250\",\"Nil\")","v":"Nil"}]
[]
[null,"Payment required if appeal against sentence or order (eg ASBO) abandoned or dismissed",null,null,null,null,null,null,null,null,{"$f":"IF(Full!F27>3898,\"£250\",\"Nil\")","v":"Nil"}]
[]
[]
[]
[]
[null,"Return to Title Screen",null,null,null,null,null,null,"Return to Initial Assessment"]