{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Calculator Sheet","Scheme F 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":[[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],[26,2,26,3],[27,2,27,3],[24,2,24,3],[23,2,23,4],[32,2,32,5],[31,2,31,3],[30,2,30,3],[1,9,1,15],[7,8,7,9],[8,8,8,9],[5,14,6,15],[5,12,6,13],[11,6,11,7],[11,8,11,9],[12,6,12,7],[12,8,12,9],[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],[10,2,10,4],[10,6,10,9],[17,8,17,9],[17,6,17,7],[19,6,19,7],[16,8,16,9],[13,6,13,7],[15,8,15,9],[14,8,14,9],[13,8,13,9],[14,6,14,7],[15,6,15,7],[16,6,16,7]]}
[]
[null,null,null,null,null,null,null,null," "]
[null,"URN","Case Name",null,null,null,"Advocates Name",null,null,null,null,null,"CPS Graduated Fees Calculator - Scheme F (x28)"]
[]
[]
[null,"Date","Case Type","Offence Class","Advocate Type","NO. of Defts","NO. of Cases","NO. of Pages","NO. of Witnesses","Standard/ Enhanced"]
[null,null,null,null,null,1,1]
[null,null,"Length of Trial/Crack (incl Meaningful Progress)",null,"No. of days attended (TDF/CDF days 1-40)",null,"No. of days attended (TDF/CDF days 40+)",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,"Date","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,"Unused (UM1)"]
[null,null,"Unused (UM2)"]
[null,null,"Travelling Expenses (THE)"]
[null,null,"VAT Rate (%)",null,null,null,0.2]
[]
[]
[]
[]
[]
[]
[]
[null,"GFS Scheme 'F' Calculator 12/01/24"]

{"sheet":"Scheme F Rates","index":1,"n_rows":88,"n_cols":17,"rows_kept":88,"cut":false,"hidden":false,"merged":[[0,1,0,7],[50,1,50,6],[52,1,52,6],[51,1,51,6]]}
[]
[null,"Offence Class","Page Cut-off","Standard Base Fee","Enhanced Base Fee","Daily Fee (days 2 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,2185,4025,713,713,0,989,1817,316,173,575,863,1150,1725,46]
[null,"B",500,1242,2461,552,552,0,564,1104,316,173,575,863,1150,1725,46]
[null,"C",500,776,1162,523,523,0,345,518,316,173,575,863,1150,1725,46]
[null,"D",500,1438,1967,552,552,0,644,886,316,173,575,863,1150,1725,46]
[null,"E",500,776,1104,460,460,0,345,495,316,173,575,863,1150,1725,46]
[null,"F",500,776,1311,460,460,0,345,587,316,173,575,863,1150,1725,46]
[null,"G",2500,1311,4589,495,495,0,587,2070,316,173,575,863,1150,1725,46]
[null,"H",500,776,1093,495,495,0,345,495,316,173,575,863,1150,1725,46]
[null,"I",500,1012,2024,581,581,0,460,909,316,173,575,863,1150,1725,46]
[null,"J",500,1875,2519,598,598,0,840,1139,316,173,575,863,1150,1725,46]
[null,"K",2500,2254,5141,598,598,0,1012,2312,316,173,575,863,1150,1725,46]
[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,3876,9120,713,713,0,1748,4106,316,173,431,646,863,1294,46]
[null,"B",2500,3059,8303,552,552,0,1380,3738,316,173,431,646,863,1294,46]
[null,"C",2500,2737,7981,523,523,0,1231,3600,316,173,431,646,863,1294,46]
[null,"D",2500,2898,8142,552,552,0,1300,3657,316,173,431,646,863,1294,46]
[null,"E",2500,2404,7648,460,460,0,1081,3439,316,173,431,646,863,1294,46]
[null,"F",2500,2404,7648,460,460,0,1081,3439,316,173,431,646,863,1294,46]
[null,"G",10000,2680,7924,518,518,0,1208,3565,316,173,431,646,863,1294,46]
[null,"H",2500,2680,7924,518,518,0,1208,3565,316,173,431,646,863,1294,46]
[null,"I",2500,2783,8142,581,581,0,1254,3657,316,173,431,646,863,1294,46]
[null,"J",2500,3278,8522,633,633,0,1472,3830,316,173,431,646,863,1294,46]
[null,"K",10000,3278,8522,633,633,0,1472,3830,316,173,431,646,863,1294,46]
[null,"Leading Junior Counsel [D]",null,null,"Effective Trial and Cracked Trial",null,null,null,"Guilty Plea",null,"Confiscation Hearing"]
[null,"A",5000,5819,13685,1070,1070,0,2622,6164,460,259,719,1079,1438,2156,66]
[null,"B",2500,4589,12455,817,817,0,2070,5601,460,259,719,1079,1438,2156,66]
[null,"C",2500,4094,11960,788,788,0,1852,5382,460,259,719,1079,1438,2156,66]
[null,"D",2500,4347,12213,828,828,0,1955,5497,460,259,719,1079,1438,2156,66]
[null,"E",2500,3611,11477,690,690,0,1633,5164,460,259,719,1079,1438,2156,66]
[null,"F",2500,3611,11477,690,690,0,1633,5164,460,259,719,1079,1438,2156,66]
[null,"G",10000,4014,11880,782,782,0,1806,5348,460,259,719,1079,1438,2156,66]
[null,"H",2500,4014,11880,782,782,0,1806,5348,460,259,719,1079,1438,2156,66]
[null,"I",2500,4175,12213,874,874,0,1875,5497,460,259,719,1079,1438,2156,66]
[null,"J",2500,4922,12788,943,943,0,2220,5762,460,259,719,1079,1438,2156,66]
[null,"K",10000,4922,12788,943,943,0,2220,5762,460,259,719,1079,1438,2156,66]
[null,"Kings Counsel [E]",null,null,"Effective Trial and Cracked Trial",null,null,null,"Guilty Plea",null,"Confiscation Hearing"]
[null,"A",5000,7763,18251,1426,1426,0,3496,8211,661,345,863,1294,1725,2588,86]
[null,"B",2500,6118,16606,1093,1093,0,2749,7475,661,345,863,1294,1725,2588,86]
[null,"C",2500,5463,15951,1047,1047,0,2461,7176,661,345,863,1294,1725,2588,86]
[null,"D",2500,5796,16284,1104,1104,0,2611,7326,661,345,863,1294,1725,2588,86]
[null,"E",2500,4807,15295,920,920,0,2162,6889,661,345,863,1294,1725,2588,86]
[null,"F",2500,4807,15295,920,920,0,2162,6889,661,345,863,1294,1725,2588,86]
[null,"G",10000,5359,15847,1035,1035,0,2415,7130,661,345,863,1294,1725,2588,86]
[null,"H",2500,5359,15847,1035,1035,0,2415,7130,661,345,863,1294,1725,2588,86]
[null,"I",2500,5578,16284,1162,1162,0,2519,7326,661,345,863,1294,1725,2588,86]
[null,"J",2500,6555,17043,1254,1254,0,2956,7671,661,345,863,1294,1725,2588,86]
[null,"K",10000,6555,17043,1254,1254,0,2956,7671,661,345,863,1294,1725,2588,86]
[]
[]
[null,"Fixed Fees"]
[null,"Type","Kings Counsel","Leading Advocate","Junior or Sole Advocate","Notes"]
[null,"Hourly Rate",86,66,46,"Hourly work except cons"]
[null,"CWC",93,70,46,"Conference rate"]
[null,"BPD",291,221,145]
[null,"FCM",232,175,116]
[null,"PAW",577,401,276,"1 - 10 day trial"]
[null,"PAH",302,227,151,"1 - 10 day trial"]
[null,"PAW",577,431,308,"        11 day trial onwards"]
[null,"PAH",319,242,172,"       11 day trial onwards"]
[null,"DSE",376,276,201]
[null,"SHR",291,221,145]
[null,"OHA",209,156,105]
[null,"ACV",760,570,380]
[null,"ASE",573,429,288]
[null,"CSE",348,261,175]
[null,"BRE",251,176,125]
[null,"NEF",437,437,437]
[null,"BCH",58,58,58]
[null,"X28",670,670,670]
[null,"S28",1000,1000,1000]
[null,"BPD"]
[null,"NEF"]
[null,"PAW"]
[null,"PAH"]
[null,"DSE"]
[null,"SHR"]
[null,"OHA"]
[null,"ACV"]
[null,"ASE"]
[null,"CSE"]
[null,"BRE"]
[null,"FCM"]
[null,"BCH"]
[null,"S28"]
[null,"X28"]

{"sheet":"Fixed Fees and Calculated Fees","index":2,"n_rows":43,"n_cols":8,"rows_kept":43,"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],[41,1,41,6],[28,1,28,6],[7,3,13,3],[23,1,23,7],[24,1,24,7],[16,1,16,7],[17,1,17,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 ","Kings Counsel ","Leading Junior ","Junior or Sole Advocate ","Code "]
[null,1,"PTPH",null,291,221,145,"BPD "]
[null,2,"Further Case Management Hearing",null,232,175,116,"FCM"]
[null,3,"Admissibility, Abuse of Process, Disclosure, PII ",null,577,401,276,"PAW "]
[null,null,"1-10 day trial (full day) "]
[null,4,"Admissibility, Abuse of Process, Disclosure, PII 1-10 day trial (half day) ",null,302,227,151,"PAH "]
[null,5,"As Number 3 for trials more than 10 days ",null,577,431,308,"PAW "]
[null,null,"(Full day) "]
[null,6,"As Number 4 for trials more than 10 days ",null,319,242,172,"PAH "]
[null,null,"(Half day) "]
[null,7,"Deferred Sentence ",null,376,276,201,"DSE "]
[null,8,"Standard Appearance ",null,209,156,105,"OHA "]
[]
[null,"FIXED FEES WHERE UPLIFTS ARE PAID FOR ADDITIONAL DEFENDANTS AND ADDITIONAL CASES"]
[null,9,"Appeal against Conviction ",null,760,570,380,"ACV "]
[null,10,"Appeal against Sentence",null,573,429,288,"ASE "]
[null,11,"Breach of a Crown Court Order",null,251,176,125,"BRE"]
[null,12,"'Ordinary 'Sentence ",null,291,221,145,"SHR "]
[null,13,"Committal for Sentence ",null,348,261,175,"CSE "]
[]
[null,"FIXED FEES WHERE NO UPLIFT IS PAID FOR ADDITIONAL DEFENDANTS OR ADDITIONAL CASES"]
[null,14,"Trial Stood Out ",null,437,437,437,"NEF "]
[null,15,"Bad Character/Hearsay Applications",null,58,58,58,"BCH"]
[null,16,"S.28 Hearing Additional Fee",null,670,670,670,"S28"]
[null,"CALCULATED FEES"]
[null,null,"Fee","Para of MOG","Kings Counsel","Leading Junior","Junior or Sole Advocate"]
[null,16,"Special Preparation Fee 1 to 10 day trials",null,86,66,46]
[null,17,"As number 16 for trials more than 10 days",null,86,66,46]
[null,18,"Wasted Preparation Fee ",null,86,66,46]
[null,19,"As number 18 for trials more than 10 days",null,86,66,46]
[null,20,"Conference Fee ",null,93,70,46]
[null,21,"As number 20 for trials more than 10 days",null,86,66,46]
[null,22,"Travel Time ",null,86,66,46]
[null,23,"As number 22 for trials more than 10 days",null,86,66,46]
[null,24,"‘Other’ ",null,86,66,46]
[null,25,"As number 24 for trials more than 10 days",null,86,66,46]
[null,26,"Unused Material Payment - Hourly Rate",null,86,66,46]
[null,"NOTING JUNIOR FEE"]
[null,27,"Noting junior fee daily rate",null,"N/A ","N/A ",125]