{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["EX160C","Calc"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":17,"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":"EX160C","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[3,1,3,4],[4,1,5,4],[17,1,17,4],[12,1,12,4]]}
[]
[null,"EX160C: Fee remissions contribution calculator"]
[null,"Instructions for income based calculation:"]
[null,"Enter your and (if applicable) your partner's information in the yellow boxes below. The maximum contribution you will make towards a court or tribunal fee will be shown in the blue box."]
[null,"The maximum contribution is how much you would have to pay towards any fee based on your income. For example for a fee of £100 a maximum contribution of £80 would mean that you would be expected to pay £80 while the remaining £20 would be remitted."]
[]
[]
[null,"Your and (if applicable) your partner's gross monthly income (£)","How many children do you have 0-13?","How many children do you have 14+?","Are you in a couple (without contrary interest)?\nSelect response from the drop-down list","Income for Calculation (£)","Maximum Contribution (£)"]
[null,0,0,0,"No",{"$f":"IF($B$9-(1420+C9*425+D9*710+IF($E$9=\"Yes\",710,0))>3000,\"Not Eligible\",MAX(ROUNDDOWN(($B$9-(1420+C9*425+D9*710+IF($E$9=\"Yes\",710,0)))/10,0)*10*1,))","v":0},{"$f":"Calc!D10","v":0}]
[]
[null,"Instructions for disposable capital based calculation:"]
[null,"Note: If you or (if applicable) your partner are under 66 years old"]
[null,"Enter your and (if applicable) your partner's information in the yellow boxes below. The blue box will state if you are eligible or not eligible for help with fees based on your disposable capital and court fee."]
[]
[null,"Your and (if applicable) your partner's disposable capital (£)\n","Court or tribunal fee (£)\n","Eligibility"]
[null,0,0,{"$f":"Calc!F21","v":"Eligible"}]
[]
[null,"Note: If you or (if applicable) your partner are 66 years old or over, you will not be eligible for a fee remission if you do not pass the disposable capital test, as outlined in the table below. "]
[]
[null,null,"Court or Tribunal Fee ","Disposable Capital Threshold "]
[null,null,"Your court or tribunal fee is:","You, and (if applicable) your partner's disposable capital is less than:"]
[null,null,"Any fee",16000]

{"sheet":"Calc","index":1,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[]
[{"$f":"EX160C!F9","v":0}]
[]
[1000,2000,3000]
[]
[0.5,0.7,0.9]
[]
[{"$f":"IF(A2>=A4,A4,A2)","v":0},{"$f":"IF((A2-A8)>=A4,A4,(A2-A8))","v":0},{"$f":"A2-A8-B8","v":0}]
[]
[{"$f":"A8*A6","v":0},{"$f":"B8*B6","v":0},{"$f":"C8*C6","v":0},{"$f":"IF(A2=\"Not Eligible\",\"Not Eligible\",SUM(A10:C10))","v":0}]
[]
[]
[null,"Threshold","Band 1","Band 2","Band 3","Threshold cap"]
["Income","Up to £1,420","£0 - £1000 above Threshold","£1,001 - £2000 above Threshold","£2,001 - £3000 above Threshold",4420]
[null,null,"50% of inc payable","70% of inc payable","90% of inc payable"]
[]
[]
[{"$f":"EX160C!B16","v":0},{"$f":"EX160C!C16","v":0}]
[]
[null,null,{"$f":"IF(OR($A18<($B18*3),($A18=$B18*3)), \"Band 2 Pass\", \"Band 2 Fail\")","v":"Band 2 Pass"}]
[null,{"$f":"IF(AND($B18<1421,$A18<4251),\"Band 1 Eligible\",\"Not Applicable\")","v":"Band 1 Eligible"},{"$f":"IF(AND($B18>1401,$B18<5001, ($C20=\"Band 2 Pass\")), \"Band 2 Eligible\",\"Not Applicable\")","v":"Not Applicable"},{"$f":"IF(AND($B18>5000,$A18<16001),\"Band 3 Eligible\",\"Not Applicable\")","v":"Not Applicable"},null,{"$f":"IF(OR($B21=\"Band 1 Eligible\",$C21=\"Band 2 Eligible\",$D21=\"Band 3 Eligible\"),\"Eligible\",\"Not Eligible\")","v":"Eligible"}]
[]
[null,"Band 1","Band 2","Band 3 "]
["Savings & Investments","£0 to £4,250","3 x Fee amount","Up to £16,000"]
["Fee amount","Up to £1,420","£1,421 to £5,000","£5,001 and over"]