{"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: Cyfrifiannell cyfraniad dileu ffioedd"]
[null,"Cyfarwyddiadau ar gyfer cyfrifiad sy’n seiliedig ar incwm:"]
[null,"Rhowch eich gwybodaeth ac (os yw'n berthnasol) gwybodaeth eich partner yn y blychau melyn isod. Bydd uchafswm y cyfraniad y byddwch yn ei wneud tuag at ffi’r llys neu’r tribiwnlys yn cael ei ddangos yn y blwch glas."]
[null,"Yr uchafswm cyfraniad yw faint y bydd yn rhaid i chi ei dalu tuag at unrhyw ffi yn seiliedig ar eich incwm. Er enghraifft, am ffi o £100 byddai uchafswm y cyfraniad o £80 yn golygu y byddai disgwyl i chi dalu £80 tra byddai'r £20 sy'n weddill yn cael ei ddileu."]
[]
[]
[null,"Eich incwm misol gros ac (os yw'n berthnasol) incwm misol gros eich partner (£)","Faint o blant sydd gennych chi rhwng 0 a 13 oed?","Faint o blant sydd gennych chi sy’n 14 neu’n hŷn?","Ydych chi’n un rhan o gwpl (heb unrhyw fudd sy’n gwrthdaro)?\nDewiswch ymateb o'r gwymplen","Income for Calculation (£)","Uchafswm y Cyfraniad (£)"]
[null,0,0,0,"Oes",{"$f":"IF($B$9-(1420+C9*425+D9*710+IF($E$9=\"Oes\",710,0))>3000,\"Not Eligible\",MAX(ROUNDDOWN(($B$9-(1420+C9*425+D9*710+IF($E$9=\"Oes\",710,0)))/10,0)*10*1,))","v":0},{"$f":"Calc!D10","v":0}]
[]
[null,"Cyfarwyddiadau ar gyfer cyfrifo gwariant yn seiliedig ar gyfalaf:"]
[null,"Noder: Os ydych chi, neu (os yw'n berthnasol) eich partner o dan 66 oed"]
[null,"Rhowch eich gwybodaeth a (os yw'n berthnasol) gwybodaeth eich partner yn y blychau melyn isod. Bydd y blwch glas yn nodi a ydych chi'n gymwys neu ddim yn gymwys i gael help i dalu ffioedd yn seiliedig ar eich cyfalaf gwario a'ch ffi llys."]
[]
[null,"Eich cyfalaf gwario, a (os yw'n berthnasol) cyfalaf gwario eich partner (£)\n","Ffi llys neu dribiwnlys (£)\n","Cymhwysedd"]
[null,0,0,{"$f":"Calc!F21","v":"Cymwys"}]
[]
[null,"Noder: Os ydych chi, neu (os yw'n berthnasol) eich partner yn 66 oed neu'n hŷn, ni fyddwch yn gymwys i gael dileu ffi os na fyddwch yn pasio'r prawf cyfalaf gwario, fel yr amlinellir yn y tabl isod."]
[]
[null,null,"Ffi’r llys neu’r tribiwnlys","Trothwy Cyfalaf Gwario"]
[null,null,"Eich ffi llys neu dribiwnlys yw:","Mae eich cyfalaf gwario, a (os yw'n berthnasol) cyfalaf gwario eich partner yn llai na:"]
[null,null,"Unrhyw ffi",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\",\"Ddim yn gymwys\",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\"),\"Cymwys\",\"Ddim yn gymwys\")","v":"Cymwys"}]
[]
[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"]