{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Calculator Sheet","Scheme D Rates","Fixed Fees and Calculated Fees"],"not_rendered":{"charts":0,"images":9,"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":"Calculator Sheet","index":0,"n_rows":42,"n_cols":16,"rows_kept":42,"cut":false,"hidden":false,"merged":[[10,2,10,4],[36,2,38,7],[20,6,20,7],[21,6,21,7],[28,2,28,3],[29,2,29,3],[33,2,33,5],[25,2,25,3],[24,4,24,9],[31,2,31,5],[26,2,26,3],[27,2,27,3],[24,2,24,3],[23,2,23,4],[19,6,19,7],[10,6,10,9],[1,9,1,15],[7,8,7,9],[8,8,8,9],[5,14,6,15],[5,12,6,13],[2,2,2,5],[2,6,2,9],[3,6,3,9],[8,4,8,5],[8,6,8,7],[7,4,7,5],[7,6,7,7],[3,2,3,5],[7,2,7,3],[8,2,8,3],[11,6,11,7],[11,8,11,9],[12,6,12,7],[12,8,12,9],[16,8,16,9],[17,8,17,9],[17,6,17,7],[16,6,16,7],[15,6,15,7],[13,6,13,7],[15,8,15,9],[14,8,14,9],[13,8,13,9],[14,6,14,7]]}
[]
[null,null,null,null,null,null,null,null," "]
[null,null,"Case Name",null,null,null,"Advocates Name",null,null,null,null,null,"CPS Graduated Fees Calculator - Scheme D"]
[]
[]
[null,null,"Case Type","Offence Class","Advocate Type","NO. of Defts","NO. of Cases","NO. of Pages","NO. of Witnesses","Standard/ Enhanced"]
[]
[null,null,"Length of trial               (inc 1st day)",null,"No. of days attended (between 1 & 40 days)",null,"No. of days attended (over 40 days)",null,"Elected Cracked Trial (Y/N)",null,null,null,"Code","Quantity","Rate","Amount"]
[null,null,1]
[]
[null,null,"Fixed Fees",null,null,null,"Confiscation Hearing"]
[null,null,"Fixed Fees","NO Defts","NO Cases",null,"POCA Pages"]
[null,null,null,null,null,null,"First Day (full/half)"]
[null,null,null,null,null,null,"Subsequent days full"]
[null,null,null,null,null,null,"Subsequent days half"]
[null,null,null,null,null,null,"Hours (hh:mm)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Calculated Fees"]
[null,null,"Hourly rate work",null,"Give time in Hours:Minutes (hh:mm) for each fee incurred"]
[null,null,"Conferences (CWC)"]
[null,null,"Special Prep (SPP)"]
[null,null,"Wasted Prep (WPF)"]
[null,null,"Travel Time (TCT)"]
[null,null,"Other (Specify) (OTH)"]
[]
[null,null,"Travelling Expenses (THE)"]
[]
[null,null,"VAT Rate (%)",null,null,null,0.2]
[]
[]
[]
[]
[]
[]
[]
[null,"GFS Scheme 'D' Calculator 11/07/2019"]

{"sheet":"Scheme D Rates","index":1,"n_rows":84,"n_cols":17,"rows_kept":84,"cut":false,"hidden":false,"merged":[[0,1,0,7],[50,1,50,6],[52,1,52,6],[53,5,53,6],[54,5,54,6],[55,5,55,6],[56,5,56,6],[57,5,57,6],[58,5,58,6],[59,5,59,6],[60,5,60,6],[61,5,61,6],[62,5,62,6],[63,5,63,6],[64,5,64,6],[65,5,65,6],[70,5,70,6],[66,5,66,6],[67,5,67,6],[68,5,68,6],[69,5,69,6]]}
[]
[null,"Offence Class","Page Cut-off","Standard Base Fee","Enhanced Base Fee","Daily Fee \n(days 3 to 40)","Daily Fee \n(days 41+)","Witness Uplift (first 10 excluded)","Standard Guilty Plea Base Fee","Enhanced Guilty Plea Base Fee","0-50 pages\nFirst Day Whole","0-50 pages\nFirst Day Half","51-250 pages\nFirst Day","251-500 pages\nFirst Day","501-750 pages\nFirst Day","More than 750\nFirst Day","Hourly Rate\nMore than 1000"]
[null,"Junior Counsel [A]",null,null,"Effective Trial and Cracked Trial",null,null,null,"Guilty Plea",null,"Confiscation Hearing"]
[null,"A",1000,1760,3040,620,330,3.33,790,1370,275,150,500,750,1000,1500,33.5]
[null,"B",500,1000,2140,480,330,3.33,450,960,275,150,500,750,1000,1500,33.5]
[null,"C",500,570,950,430,330,3.33,260,430,275,150,500,750,1000,1500,33.5]
[null,"D",500,860,1710,430,330,3.33,390,770,275,150,500,750,1000,1500,33.5]
[null,"E",500,480,950,330,330,3.33,220,430,275,150,500,750,1000,1500,33.5]
[null,"F",500,480,1140,330,330,3.33,220,510,275,150,500,750,1000,1500,33.5]
[null,"G",2500,1140,3990,430,330,3.33,510,1800,275,150,500,750,1000,1500,33.5]
[null,"H",500,520,950,430,330,3.33,240,430,275,150,500,750,1000,1500,33.5]
[null,"I",500,670,1760,430,330,3.33,300,790,275,150,500,750,1000,1500,33.5]
[null,"J",500,1330,2190,520,330,3.33,600,990,275,150,500,750,1000,1500,33.5]
[null,"K",2500,1570,4470,520,330,3.33,700,2010,275,150,500,750,1000,1500,33.5]
[null,"Led Junior Counsel [B and C]",null,null,"Effective Trial and Cracked Trial",null,null,null,"Guilty Plea",null,"Confiscation Hearing"]
[null,"A",5000,3370,7930,620,360,3.56,1520,3570,275,150,375,562,750,1125,33.5]
[null,"B",2500,2660,7220,480,360,3.56,1200,3250,275,150,375,562,750,1125,33.5]
[null,"C",2500,2380,6940,450,360,3.56,1070,3130,275,150,375,562,750,1125,33.5]
[null,"D",2500,2520,7080,450,360,3.56,1130,3180,275,150,375,562,750,1125,33.5]
[null,"E",2500,2090,6650,360,360,3.56,940,2990,275,150,375,562,750,1125,33.5]
[null,"F",2500,2090,6650,360,360,3.56,940,2990,275,150,375,562,750,1125,33.5]
[null,"G",10000,2330,6890,450,360,3.56,1050,3100,275,150,375,562,750,1125,33.5]
[null,"H",2500,2330,6890,450,360,3.56,1050,3100,275,150,375,562,750,1125,33.5]
[null,"I",2500,2420,7080,450,360,3.56,1090,3180,275,150,375,562,750,1125,33.5]
[null,"J",2500,2850,7410,550,360,3.56,1280,3330,275,150,375,562,750,1125,33.5]
[null,"K",10000,2850,7410,550,360,3.56,1280,3330,275,150,375,562,750,1125,33.5]
[null,"Leading Junior Counsel [D]",null,null,"Effective Trial and Cracked Trial",null,null,null,"Guilty Plea",null,"Confiscation Hearing"]
[null,"A",5000,5060,11900,930,530,5.35,2280,5360,400,225,625,938,1250,1875,47]
[null,"B",2500,3990,10830,710,530,5.35,1800,4870,400,225,625,938,1250,1875,47]
[null,"C",2500,3560,10400,680,530,5.35,1610,4680,400,225,625,938,1250,1875,47]
[null,"D",2500,3780,10620,680,530,5.35,1700,4780,400,225,625,938,1250,1875,47]
[null,"E",2500,3140,9980,530,530,5.35,1420,4490,400,225,625,938,1250,1875,47]
[null,"F",2500,3140,9980,530,530,5.35,1420,4490,400,225,625,938,1250,1875,47]
[null,"G",10000,3490,10330,680,530,5.35,1570,4650,400,225,625,938,1250,1875,47]
[null,"H",2500,3490,10330,680,530,5.35,1570,4650,400,225,625,938,1250,1875,47]
[null,"I",2500,3630,10620,680,530,5.35,1630,4780,400,225,625,938,1250,1875,47]
[null,"J",2500,4280,11120,820,530,5.35,1930,5010,400,225,625,938,1250,1875,47]
[null,"K",10000,4280,11120,820,530,5.35,1930,5010,400,225,625,938,1250,1875,47]
[null,"King's Counsel [E]",null,null,"Effective Trial and Cracked Trial",null,null,null,"Guilty Plea",null,"Confiscation Hearing"]
[null,"A",5000,6750,15870,1240,710,7.13,3040,7140,575,300,750,1125,1500,2250,62.5]
[null,"B",2500,5320,14440,950,710,7.13,2390,6500,575,300,750,1125,1500,2250,62.5]
[null,"C",2500,4750,13870,900,710,7.13,2140,6240,575,300,750,1125,1500,2250,62.5]
[null,"D",2500,5040,14160,900,710,7.13,2270,6370,575,300,750,1125,1500,2250,62.5]
[null,"E",2500,4180,13300,710,710,7.13,1880,5990,575,300,750,1125,1500,2250,62.5]
[null,"F",2500,4180,13300,710,710,7.13,1880,5990,575,300,750,1125,1500,2250,62.5]
[null,"G",10000,4660,13780,900,710,7.13,2100,6200,575,300,750,1125,1500,2250,62.5]
[null,"H",2500,4660,13780,900,710,7.13,2100,6200,575,300,750,1125,1500,2250,62.5]
[null,"I",2500,4850,14160,900,710,7.13,2190,6370,575,300,750,1125,1500,2250,62.5]
[null,"J",2500,5700,14820,1090,710,7.13,2570,6670,575,300,750,1125,1500,2250,62.5]
[null,"K",10000,5700,14820,1090,710,7.13,2570,6670,575,300,750,1125,1500,2250,62.5]
[]
[]
[null,"Fixed Fees"]
[null,"Type","Kings Counsel","Leading Advocate","Junior or Sole Advocate","Notes"]
[null,null,62.5,47,33.5,"1 - 10 day trial"]
[null,null,75,56.4,40.200000000000003,"11 - 25 day trial"]
[null,"BPD",253,192,126]
[null,"FCM",202,152,101]
[null,"PAW",502,349,240,"1 - 10 day trial"]
[null,"PAH",263,197,131,"1 - 10 day trial"]
[null,"PAW",502,375,267.45,"11 day trial onwards"]
[null,"PAH",277.5,210,149.25,"11 day trial onwards"]
[null,"DSE",327,240,175]
[null,"SHR",253,192,126]
[null,"OHA",182,136,91]
[null,"ACV",661,496,330]
[null,"ASE",498,373,250]
[null,"CSE",303,227,152]
[null,"BRE",218,153,109]
[null,"NEF",380,380,380]
[]
[]
[null,"BPD"]
[null,"NEF"]
[null,"PAW"]
[null,"PAH"]
[null,"DSE"]
[null,"SHR"]
[null,"OHA"]
[null,"ACV"]
[null,"ASE"]
[null,"CSE"]
[null,"BRE"]
[null,"FCM"]

{"sheet":"Fixed Fees and Calculated Fees","index":2,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[12,6,13,6],[3,1,3,7],[7,1,8,1],[7,4,8,4],[7,5,8,5],[7,6,8,6],[7,7,8,7],[39,1,39,6],[27,1,27,6],[7,3,13,3],[23,1,23,7],[24,1,24,7],[17,1,17,7],[18,1,18,7],[10,7,11,7],[12,1,13,1],[12,7,13,7],[10,1,11,1],[10,4,11,4],[10,5,11,5],[10,6,11,6],[12,4,13,4],[12,5,13,5]]}
[]
[null,null,"For cases over 10 days"]
[]
[null,"FIXED FEES WHERE UPLIFTS ARE PAID FOR ADDITIONAL DEFENDANTS"]
[null,"No. ","Fee ","Para of MOG ","King's Counsel ","Leading Junior ","Junior or Sole Advocate ","Code "]
[null,1,"PCMH",null,253,192,126,"BPD "]
[null,2,"Further Case Management Hearing",null,202,152,101,"FCM"]
[null,3,"Admissibility, Abuse of Process, Disclosure, PII ",null,502,349,240,"PAW "]
[null,null,"1-10 day trial (full day) "]
[null,4,"Admissibility, Abuse of Process, Disclosure, PII 1-10 day trial (half day) ",null,263,197,131,"PAH "]
[null,5,"As Number 3 for trials more than 10 days ",null,502,375,267.45,"PAW "]
[null,null,"(Full day) "]
[null,6,"As Number 4 for trials more than 10 days ",null,277.5,210,149.25,"PAH "]
[null,null,"(Half day) "]
[null,7,"Deferred Sentence ",null,327,240,175,"DSE "]
[null,8,"'Ordinary 'Sentence ",null,253,192,126,"SHR "]
[null,9,"Standard Appearance ",null,182,136,91,"OHA "]
[]
[null,"FIXED FEES WHERE UPLIFTS ARE PAID FOR ADDITIONAL DEFENDANTS AND ADDITIONAL CASES"]
[null,10,"Appeal against Conviction ",null,661,496,330,"ACV "]
[null,11,"Appeal against Sentence",null,498,373,250,"ASE "]
[null,12,"Breach of a Crown Court Order",null,218,153,109,"BRE"]
[null,13,"Committal for Sentence ",null,303,227,152,"CSE "]
[]
[null,"FIXED FEES WHERE NO UPLIFT IS PAID FOR ADDITIONAL DEFENDANTS OR ADDITIONAL CASES"]
[null,14,"Trial Stood Out - on application by Pros./Def. ",null,380,380,380,"NEF "]
[]
[null,"CALCULATED FEES"]
[null,null,"Fee","Para of MOG","Kings's Counsel","Leading Junior","Junior or Sole Advocate"]
[null,16,"Special Preparation Fee 1 to 10 day trials",null,62.5,47,33.5]
[null,17,"As number 16 for trials more than 10 days",null,75,56.4,40.200000000000003]
[null,18,"Wasted Preparation Fee ",null,62.5,47,33.5]
[null,19,"As number 18 for trials more than 10 days",null,75,56.4,40.200000000000003]
[null,20,"Conference Fee ",null,62.5,47,33.5]
[null,21,"As number 20 for trials more than 10 days",null,75,56.4,40.200000000000003]
[null,22,"Travel Time ",null,62.5,47,33.5]
[null,23,"As number 22 for trials more than 10 days",null,75,56.4,40.200000000000003]
[null,24,"‘Other’ ",null,62.5,47,33.5]
[null,25,"As number 24 for trials more than 10 days",null,75,56.4,40.200000000000003]
[null,"NOTING JUNIOR FEE"]
[null,26,"Noting junior fee daily rate",null,"N/A ","N/A ",109]