{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["CTL Calculator","Instructions","Sheet2","Instructions For Use"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":2,"comments":0,"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":"CTL Calculator","index":0,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,9,1,10],[4,2,5,3],[10,7,10,8],[12,3,12,4],[4,5,4,9],[17,5,17,9],[19,7,19,8],[4,11,8,11],[13,3,13,4],[13,7,13,8],[12,7,12,8],[5,7,5,8],[6,7,6,8],[7,7,7,8],[23,7,23,8],[27,7,27,8],[32,5,33,9],[0,1,0,13],[21,11,23,11],[25,11,27,11],[32,2,33,3],[5,5,5,6],[18,11,19,11],[1,3,1,5],[15,3,15,4],[14,3,14,4],[14,7,14,8],[15,7,15,8],[29,5,29,6],[29,7,29,8]]}
[]
[null,null,"Defendant Name:",null,null,null,"URN:"]
[]
[]
[null,null,"Please see \"Instructions For Use\" tab for guidance on using this CTL Calculator"]
[null,null,null,null,null,"Magistrates' Court CTLs",null,"All Cases Sent",null,"Other Crown \nCourt CTL"]
[null,null,null,null,null,56,70,182,null,112]
[null,null,"1st Custody Remand",null,null,{"$f":"[0]!CTL.CTL($D$8,F7)","v":"1900-02-24"},{"$f":"[0]!CTL.CTL($D$8,G7)","v":"1900-03-09"},{"$f":"[0]!CTL.CTL($D$8,H7)","v":"1900-06-29"},null,{"$f":"[0]!CTL.CTL($D$8,J7)","v":"1900-04-20"}]
[null,null,null,null,null,{"$f":"NOT(ISERROR(MATCH(F8,$C$41:$C$46,0)))","v":false},{"$f":"NOT(ISERROR(MATCH(G8,$C$41:$C$46,0)))","v":false},{"$f":"NOT(ISERROR(MATCH(H8,$C$41:$C$46,0)))","v":false},null,{"$f":"NOT(ISERROR(MATCH(J8,$C$41:$C$46,0)))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,"CTL Extended To "]
[null,null,null,null,null,"56 Days","70 Days","182 Days",null,"112 Days"]
[]
[null,null,null,"28 Day Review",null,{"$f":"CreateValidDate($F$8-27)","v":"1900-01-27"},{"$f":"CreateValidDate($G$8-27)","v":"1900-02-10"},{"$f":"CreateValidDate($H$8-27)","v":"1900-06-01"},null,{"$f":"CreateValidDate($J$8-27)","v":"1900-03-23"},null,{"$f":"IF(CreateValidDate($L$11-27)<NOW(),\"\",CreateValidDate($L$11-27))","v":{"$error":"#NAME?"}}]
[null,null,null,"21 Day Review",null,{"$f":"CreateValidDate($F$8-20)","v":"1900-02-03"},{"$f":"CreateValidDate($G$8-20)","v":"1900-02-17"},{"$f":"CreateValidDate($H$8-20)","v":"1900-06-08"},null,{"$f":"CreateValidDate($J$8-20)","v":"1900-03-30"},null,{"$f":"IF(CreateValidDate($L$11-20)<NOW(),\"\",CreateValidDate($L$11-20))","v":{"$error":"#NAME?"}}]
[null,null,null,"14 Day Review",null,{"$f":"CreateValidDate($F$8-13)","v":"1900-02-10"},{"$f":"CreateValidDate($G$8-13)","v":"1900-02-24"},{"$f":"CreateValidDate($H$8-13)","v":"1900-06-15"},null,{"$f":"CreateValidDate($J$8-13)","v":"1900-04-06"},null,{"$f":"IF(CreateValidDate($L$11-13)<NOW(),\"\",CreateValidDate($L$11-13))","v":{"$error":"#NAME?"}}]
[null,null,null,"7 Day Review",null,{"$f":"CreateValidDate($F$8-6)","v":"1900-02-17"},{"$f":"CreateValidDate($G$8-6)","v":"1900-03-02"},{"$f":"CreateValidDate($H$8-6)","v":"1900-06-22"},null,{"$f":"CreateValidDate($J$8-6)","v":"1900-04-13"},null,{"$f":"IF(CreateValidDate($L$11-6)<NOW(),\"\",CreateValidDate($L$11-6))","v":{"$error":"#NAME?"}}]
[]
[]
[null,null,"Date admitted to bail",null,"`",null,null,null,null,null,null,{"$f":"IF(D19<>\"\",Days_In_Custody(M20,FALSE),\"\")","v":""},null,"running total","Days out of custody"]
[null,null,"First Return to Custody Date",null,{"$f":"SUM(D20)-D19","v":"00:00:00"},{"$f":"IF($D$20<>\"\",[0]!CTL.CTL($D$20,(F7-$M$20)-1),\"\")","v":""},{"$f":"IF($D$20<>\"\",[0]!CTL.CTL($D$20,(G7-$M$20)-1),\"\")","v":""},{"$f":"IF($D$20<>\"\",[0]!CTL.CTL($D$20,(H7-$M$20)-1),\"\")","v":""},null,{"$f":"IF($D$20<>\"\",[0]!CTL.CTL($D$20,(J7-$M$20)-1),\"\")","v":""},null,null,{"$f":"SUM(D19)-D8","v":0},{"$f":"IF(D19<>\"\",SUM(D19)-D8,0)","v":0},{"$f":"IF(D19<>\"\",SUM(D20)-D19-1,0)","v":0}]
[null,null,null,{"$f":"(AND(D19<>0,D20=0))","v":false},null,{"$f":"NOT(ISERROR(MATCH(F20,$C$41:$C$46,0)))","v":false},{"$f":"NOT(ISERROR(MATCH(G20,$C$41:$C$46,0)))","v":false},{"$f":"NOT(ISERROR(MATCH(H20,$C$41:$C$46,0)))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D23<>\"\",Days_In_Custody(M24,TRUE, M20),\"\")","v":""}]
[null,null,"Second date admitted to bail",null,null,{"$f":"SUM(F7)-$M$24-$M$20-1","v":54},{"$f":"SUM(G7)-$M$24-$M$20-1","v":68},{"$f":"SUM(H7)-$M$24-$M$20-1","v":180},null,{"$f":"SUM(J7)-$M$24-$M$20-1","v":110}]
[null,null,"Second Return to Custody Date",null,"`",{"$f":"IF($D$24<>\"\",[0]!CTL.CTL($D$24,F23),\"\")","v":""},{"$f":"IF($D$24<>\"\",[0]!CTL.CTL($D$24,G23),\"\")","v":""},{"$f":"IF($D$24<>\"\",[0]!CTL.CTL($D$24,H23),\"\")","v":""},null,{"$f":"IF($D$24<>\"\",[0]!CTL.CTL($D$24,J23),\"\")","v":""},null,null,{"$f":"SUM(D23)-D20+1","v":1},{"$f":"IF(D23<>\"\",D23-D20+1+N20,0)","v":0},{"$f":"IF(D23<>\"\",SUM(D24)-D23-1,0)","v":0}]
[null,null,null,{"$f":"(AND(D23<>0,D24=0))","v":false},null,{"$f":"NOT(ISERROR(MATCH(F24,$C$41:$C$46,0)))","v":false},{"$f":"NOT(ISERROR(MATCH(G24,$C$41:$C$46,0)))","v":false},{"$f":"NOT(ISERROR(MATCH(H24,$C$41:$C$46,0)))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D27<>\"\",Days_In_Custody(M28,TRUE, M24+M20),\"\")","v":""}]
[null,null,"Third date admitted to bail",null,null,{"$f":"SUM(F7)-$M$20-$M$24-$M$28-1","v":53},{"$f":"SUM(G7)-$M$20-$M$24-$M$28-1","v":67},{"$f":"SUM(H7)-$M$20-$M$24-$M$28-1","v":179},null,{"$f":"SUM(J7)-$M$20-$M$24-$M$28-1","v":109}]
[null,null,"Third Return to Custody Date",null,null,{"$f":"IF($D$28<>\"\",[0]!CTL.CTL($D$28,F27),\"\")","v":""},{"$f":"IF($D$28<>\"\",[0]!CTL.CTL($D$28,G27),\"\")","v":""},{"$f":"IF($D$28<>\"\",[0]!CTL.CTL($D$28,H27),\"\")","v":""},null,{"$f":"IF($D$28<>\"\",[0]!CTL.CTL($D$28,J27),\"\")","v":""},null,null,{"$f":"SUM(D27)-D24+1","v":1},{"$f":"IF(D27<>\"\",D27-D24+1+N24,0)","v":0},{"$f":"IF(D27<>\"\",SUM(D28)-D27-1,0)","v":0}]
[null,null,{"$f":"OR(D21=TRUE,D25=TRUE,D29=TRUE)","v":false},{"$f":"(AND(D27<>0,D28=0))","v":false},null,{"$f":"NOT(ISERROR(MATCH(F28,$C$41:$C$46,0)))","v":false},{"$f":"NOT(ISERROR(MATCH(G28,$C$41:$C$46,0)))","v":false},{"$f":"NOT(ISERROR(MATCH(H28,$C$41:$C$46,0)))","v":false},null,"Number of Days in Custody (Optional)"]
[null,null,"  Sending Date",null,null,{"$f":"IF(C29=TRUE,\"Defendant is not in custody\",\"182 days minus \" & G31 & \" \" & L31 & \" in custody\")","v":"182 days minus 0 days in custody"},null,{"$f":"IF($C$29 <> FALSE,\"\",IF(D30<>\"\",IF(J30<>\"\",[0]!CTL.CTL(D30,182-J30),[0]!CTL.CTL($D$30,(H7-L30))),\"\"))","v":""},null,null,null,{"$f":"SUM(M30)-O30","v":0},{"$f":"SUM(D30-D8)","v":0},{"$f":"IF(D19<>0,MAX(N20,N24,N28),0)","v":0},{"$f":"SUM(O20:O28)","v":0}]
[null,null,null,null,null,{"$f":"IF(J30<>\"\",J30,IF(OR(D23>D30,D19>D30,D27>D30),N30,L30))","v":0},{"$f":"IF(D30<>\"\",IF(OR(D30=D20,D30=D24,D30=D28),F31-1,F31),F31)","v":0},{"$f":"NOT(ISERROR(MATCH(H30,$C$41:$C$46,0)))","v":false},null,null,null,{"$f":"IF(L30 = 1, \"day\", \"days\")","v":"days"}]
[null,null,null,null,null,null,null,null,null,null,null,"Case Lawyer………………"]
[null,null,null,null,null,"Cells Marked In Blue Indicate Privilige Days Where There May Be A Reduction In Court Cover. ",null,null,null,null,null,"Date………………………."]
[null,null,null,null,null,null,null,null,null,null,null,"B2 BM…………………….."]
[null,null,null,null,null,null,{"$f":"MAXA(F9:I9,F21:I21,F25:I25,F29:I29)","v":0},null,null,null,null,"Date…………………………"]
[]
[]
[]
[]
[null,null,"Priv Days"]
[null,null,{"$f":"SUM(Sheet2!G4)","v":"2012-04-05"}]
[null,null,{"$f":"SUM(Sheet2!G5)","v":"2012-06-06"}]
[null,null,{"$f":"SUM(Sheet2!G6)","v":"2012-12-24"}]
[null,null,{"$f":"SUM(Sheet2!G7)","v":"2013-03-28"}]
[null,null,{"$f":"SUM(Sheet2!G8)","v":"2013-05-28"}]
[null,null,{"$f":"SUM(Sheet2!G9)","v":"2013-12-24"}]

{"sheet":"Instructions","index":1,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[]
["• The calculator will not work unless you click ‘enable macros’ when asked. If necessary, where the calculator has been used on a different case, click on the ‘Reset Values’ box to re-set the calculator and clear the date boxes.  The first remand is automatically set to the current date. If the calculator does not fit on the screen, pressing ‘Reset Values’ will cause it to resize to your particular screen.  Provided accurate dates are inserted, the calculator will provide 100% accuracy."]
["• The first custody remand date will always default to the current date.  If necessary, this date can be changed to another date using the format dd/mm/yy e.g. 25/05/2017 or d/m/yy. Dates cannot be input using other date formats for example: dd.mm.yy.\n• The four dates that head the ‘Time Limit Days’ columns are the CTL expiry dates which correspond with the dates exactly as you would find in the ‘paper’ CTL ready-reckoner. In accordance with the Regulations, the date of the first remand only is not counted (including the 182 day CTL to avoid double counting if in custody), but in any subsequent remands, the first and last dates are.  Dates that expire at weekends or bank holidays have been brought forward to the previous working day. You do not have to make any adjustments. All these adjustments take place automatically. "]
["• If D is granted bail, insert again the date when he was first remanded into custody in the ‘First Custody Remand’ box, click outside the box or press ‘Tab’ and then insert the date bail was granted into the ‘Date Admitted to Bail’ box. Pressing ‘Enter’, ‘Tab', or clicking outside this box will calculate the number of days that D has spent in custody. Keep a record of this for the future."]
["• If D has been bailed but is then re-remanded back into custody, it will first be necessary to re-enter the case history: i.e. the first remand date and the first release date to bail as above.  Then, pressing ‘Tab’, the ‘First Return to Custody Date’ box should be completed.  Clicking outside the box pressing ‘Enter’ or ‘Tab’ will result in a recalculation of the CTL expiry dates in the ‘Amended Dates’ tables.  Again, this calculation has been designed to take into account all public holidays, weekends and any notified court closure dates bringing the time forward in each case."]
["• Either way offences in the magistrates’ court will have a 56 day CTL until allocation (or 70 days if allocation has not taken place before the end of the 56th day).  For summary only cases, the CTL is 56 days."]
["• Under the Criminal Procedure Rules, the sending usually takes place at the first hearing. For remands in custody, enter the date of the first remand into custody in the ‘First Custody Remand’ box. Click outside the box and the CTL expiry date will appear under the 182 column.\n• Where the sending takes place following an adjournment and D has remained in custody, the CTL expiry date can be calculated by entering the first remand date into the ‘First Custody Remand’ box and clicking outside the box as time from the first remand must be calculated. The 182 column will show the CTL expiry date. \n• Should you wish to determine the number of days spent in custody for your records, enter again the first remand date in the ‘First Custody Remand’ box, then enter the date of sending in the ‘Sending Date’ box. Pressing ‘Enter’ or clicking outside the box will reveal the expiry date (which will be the same as the date under the 182 column opposite the ‘First Custody Remand’ box), but the number of days in custody will be revealed. \n"]
["• Where a case is sent to the CC at the first hearing or at an adjourned hearing and D has been remanded in custody, insert the date of the first remand into custody in the ‘First Custody Remand’ box: the 182 date can be found in the ‘Cases Sent’ column. \n• Where D has been on bail but is remanded in custody at a later stage, enter the first remand into custody date in the ‘First Custody Remand’ box and press ‘Enter’ or click outside the box. The relevant CTL expiry (under the 56 day column before sending or the 182 day column after sending) will appear in one of the columns alongside.\n• If you wish to record the number of days spent in custody before sending for your records, the date of the first remand in custody should be entered in the ‘First Custody Remand’ box and the date of sending entered into the ‘Sending Date’ box. The CTL expiry date will of course be the same as is shown in the ‘Cases Sent’ box. The difference here is that the number of days in custody will be revealed.\n"]
["•The 112 CTL is now reserved for two specific instances: where a voluntary bill is granted by a High Court Judge or the Court of Appeal quash a conviction and direct a new trial on a fresh indictment. In each case, the 112 day CTL starts at the time the indictment is preferred."]
["• If you already know the total number of days a defendant has spent in custody up to the day of sending, you can calculate the CTL expiry date without having to enter all the bail and remand dates.  Reset the calculator, and enter the sending date in Cell D30.  Entering the number of days spent in custody in the box marked ‘Number of days in custody (optional)’ in Cell J30 will then override the calculation using the number of custody days you have entered."]
["• The 28; 21; 14 and 7 day review dates can be viewed by clicking the ‘Show/Hide Review Dates’ box. Clicking it again will hide these dates. If a CTL has been extended, the revised review dates can be determined by clicking the ‘Show/Hide Review’ box and inserted the new expiry date in the ‘CTL Extended To’ box."]
["• A cell that appears in orange indicates the dates that are beyond the CTL expiry dates.  For example, if D has been in custody for more than 56 days, the cells in the 56 days column will be highlighted in orange.\n• The calculator can be used for calculations for any date in 2020. It should not be used for dates beyond that date. An updated version will be published for 2021 in December on the Infonet when public holiday dates for the following year have been settled. It can also be used to check calculations in 2019. Users who download the calculator to a laptop will need to exercise caution at the end of the year and upload the right calculator.\n"]
["• Should you wish to do so, a copy of the calculator can be printed and retained on your file by clicking on the ‘Save as Word Doc’ box. You may find it useful to enter the D’s name and case URN.  However, as a move away from storing paper, save the page on CMS under the relevant case.\n\nThese instructions can be printed by clicking the 'Print Instructions' button and then using the 'Print' command in MS Word in the normal way.\n\nDavid Evans\nOperations Directorate"]

{"sheet":"Sheet2","index":2,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":true,"merged":[[3,0,10,0],[11,0,18,0],[19,0,26,0],[11,4,18,4],[3,4,10,4]]}
[]
[]
[null,"Bank Holidays","Date",null,null,null,"Dates","Privilege Days"]
[2019,"New Year's Day","2019-01-01",null,"www.gov.uk/bank-holidays",null,"2012-04-05","1/2 Maundy Thursday"]
[null,"Good Friday","2019-04-19",null,null,null,"2012-06-06","Queen's Birthday"]
[null,"Easter Monday","2019-04-22",null,null,null,"2012-12-24","Christmas"]
[null,"Early May Bank Holiday","2019-05-06",null,null,null,"2013-03-28","1/2 Maundy Thursday"]
[null,"Spring Bank Holiday","2019-05-27",null,null,null,"2013-05-28","Queen's Birthday"]
[null,"Summer Bank Holiday","2019-08-26",null,null,null,"2013-12-24","Christmas"]
[null,"Christmas Day","2019-12-25"]
[null,"Boxing Day","2019-12-26"]
[2020,"New Year's Day","2020-01-01",null,"www.gov.uk/bank-holidays"]
[null,"Good Friday","2020-04-10"]
[null,"Easter Monday","2020-04-13"]
[null,"Early May Bank Holiday","2020-05-08"]
[null,"Spring Bank Holiday","2020-05-25"]
[null,"Summer Bank Holiday","2020-08-31"]
[null,"Christmas Day","2020-12-25"]
[null,"Boxing Day","2020-12-28"]
[2021,"New Year's Day","2021-01-01"]
[null,"Good Friday","2021-04-02",null,"https://publicholidays.co.uk/england/2021-dates/"]
[null,"Easter Monday","2021-04-05"]
[null,"Early May Bank Holiday","2021-05-03"]
[null,"Spring Bank Holiday","2021-05-31",null,"https://www.ukbankholidays.co.uk/year/2021"]
[null,"Summer Bank Holiday","2021-08-30"]
[null,"Christmas Day","2021-12-27"]
[null,"Boxing Day","2021-12-28",null,"http://www.year-planner-calendar.co.uk/2021-public-holidays-bank-holiday-dates.htm"]

{"sheet":"Instructions For Use","index":3,"n_rows":113,"n_cols":7,"rows_kept":113,"cut":false,"hidden":false,"merged":[[92,1,92,9],[98,1,98,9],[104,1,104,9],[68,1,68,9],[70,1,70,9],[72,1,72,10],[74,1,74,9],[80,1,80,9],[86,1,86,9],[62,1,62,4],[1,1,1,9],[3,1,3,9],[5,1,5,9],[13,1,13,9],[22,1,22,9],[32,1,32,9],[52,1,52,5],[53,1,53,5],[54,1,54,5],[55,1,55,5],[61,1,61,9]]}
[]
[null,"CPS Custody Time Limit Calculator"]
[]
[null,"This calculator should only be used for defendants that were first remanded in custody before 28 September 2020"]
[]
[null,"• The calculator will not work unless you click ‘enable content’ when asked. \n\n• Where the calculator has been used on a different case, click on the ‘Reset Values’ box to re-set the calculator and     clear the date boxes.  \n\n• If the calculator does not fit on the screen, pressing ‘Reset Values’ will cause it to resize to your particular screen.  Provided accurate dates are inserted, the calculator will provide 100% accuracy."]
[]
[]
[]
[null,"First Remand Date"]
[]
[null,"Enter the date of first remand into “1st custody remand” box and press enter."]
[]
[null,"•   The first remand is automatically set to the current date but the date can be changed to another date using the format dd/mm/yy e.g. 25/05/2017 or d/m/yy only.\n \n•   The four dates that head the ‘Time Limit Days’ columns are the CTL expiry dates which correspond with the dates exactly as you would find in the ‘paper’ CTL ready-reckoner. \n\n•   In accordance with the Regulations, the date of the first remand is not counted but in any subsequent remands, the first and last dates are. \n\n•   Dates that expire at weekends or bank holidays have been brought forward to the previous working day. All these adjustments take place automatically. "]
[]
[]
[]
[null,"Release from custody"]
[]
[null,"1.   Enter the date of first remand into “1st custody remand” box and press enter"]
[null,"2.   Enter the date bail granted in “Date admitted to bail” box and press enter"]
[]
[null,"On the righthand side is a box displaying the number of days that the defendant has spent in custody. At the bottom the calculator will show “Defendant not in custody”\n\nConvert to word and upload this to CMS."]
[]
[]
[]
[null,"Remand back into custody"]
[]
[null,"1.   Enter the date of first remand into “1st custody remand” box and press enter"]
[null,"2.   Enter the date bail granted in “Date admitted to bail” box and press enter"]
[null,"3.   Enter the date of re-remand into “first return to custody date” box and press enter"]
[]
[null,"The new expiry date will appear in the “Amended dates box”.  The note indicating that the defendant is no longer in custody will have disappeared. The calculator automatically takes into account weekends and bank holidays bringing the time forward in each case."]
[]
[]
[]
[null,"Further remands into custody"]
[]
[null,"1.   Enter the date of first remand into “1st custody remand” box and press enter"]
[null,"2.   Enter the date bail granted in “Date admitted to bail” box and press enter"]
[null,"3.   Enter the date of re-remand into “first return to custody date” box and press enter"]
[null,"4.   Enter the date bail granted in “second date admitted to bail” box and press enter"]
[null,"5.   Enter the date of re-remand into “second return to custody date” box and press enter"]
[null,"6.   Enter the date bail granted in “third date admitted to bail” box and press enter"]
[null,"7.   Enter the date of re-remand into “third return to custody date” box and press enter"]
[]
[null,"ANY FURTHER RE-REMANDs WILL HAVE TO BE MANUALLY CALCULATED"]
[]
[]
[]
[null,"FURTHER CTL GUIDANCE BELOW"]
[]
[null,"Summary Only Offences",null,null,null,null,"56 Days"]
[null,"Either Way offences trial in the Magistrates’",null,null,null,null,"56 Days"]
[null,"Indictable offences (indictable only and E/W offences for trial in the CC)",null,null,null,null,"182 Days"]
[null,"Indictable offences (indictable only and E/W offences for trial in the CC) with a first remand on or after 28 September 2020 and up to 28 June 2021",null,null,null,null,"238 Days"]
[]
[]
[]
[null,"CTL Principles"]
[]
[null,"Each defendant and each count/charge attracts its own CTL expiry.  The CPS Legal Guidance must be referred to for full details and more complex scenarios. For any queries, contact:"]
[null,"ComplianceandAssurranceTeam@cps.gov.uk"]
[]
[]
[]
[null,"Calculation"]
[]
[null,"CTLs start the day after the first appearance and end at midnight of the 56/182/238 day. If the last day falls on a bank holiday or a Saturday or Sunday the expiry date is taken back to the last working day. The CTL Calculator and the Ready Reckoner take all this into account and give an accurate expiry date."]
[]
[null,"For cases sent to the Crown Court the 182/238 days technically starts the day it is sent less any period already spent in custody. This does not change the fact that it is 182/238 days from the day after the first appearance. "]
[]
[null,"•   Offender first appears and is sent on 28/09/2020 – CTL is 24/05/2021. (238 days)\n•   Compare with:-\n                  o   Offender is RIC at MC on 28/09/2020 for 10 days to 08/10/19 when the case is sent to the Crown Court.\n                  o   The CTL is 238 days from 08/10/2020 less the 10 days on remand in the MC = 03/10/2021 minus 10 days = 24/05/2021"]
[]
[null,"If you already know the total number of days a defendant has spent in custody up to the day of sending, you can calculate the CTL expiry date without having to enter all the bail and remand dates.  Reset the calculator, and enter the sending date in Cell D30.  Entering the number of days spent in custody in the box marked ‘Number of days in custody (optional)’ in Cell J30 will then override the calculation using the number of custody days you have entered."]
[]
[]
[]
[null,"Adding Counts"]
[]
[null,"They start from the day the draft indictment is served on the Crown Court (the day of preferment) that is 182/238 days less time already spent in custody (there are exceptions when re-trials ordered by Court of Appeal or High Court Judge - refer to Legal guidance for full details)"]
[]
[]
[]
[null,"CTL Exceptions"]
[]
[null,"CTLs cease to apply:\n\n1.   Grant of bail AND release from custody\n2.   Guilty Plea\n3.   Magistrates’ or Youth trial started (hearing of prosecution evidence)\n4.   Crown Court Trial started – Jury is sworn (even when trial aborted thereafter) and preparatory hearings in serious & complex cases (see guidance for full details)\n5.   Discontinuance or when ONE\n6.   We treat cases where the Judge has ordered a count to lie on file as ceasing as there are no specific regulations dealing with this situation\n7.   When a defendant having been RIC escapes from custody before the expiry of the CTLS- on re-arrest and re-remand no CTLS apply *\n8.   When a defendant has been released on bail following expiry of the CTLs and is re-arrested for breach of bail or failure to surrender and is re-remanded no CTLs apply*\n\n*In these circumstances the case should be prepared with all due diligence as if it were a CTL case"]
[]
[]
[]
[null,"Review Dates"]
[]
[null,"•   The 28; 21; 14 and 7 day review dates can be viewed by clicking the ‘Show/Hide Review Dates’ box. Clicking it again will hide these dates. If a CTL has been extended, the revised review dates can be determined by clicking the ‘Show/Hide Review’ box and inserted the new expiry date in the ‘CTL Extended To’ box."]
[]
[]
[]
[null,"Other Information"]
[]
[null,"•   A cell that appears in orange indicates the dates inputted are beyond the CTL expiry dates.  For example, if D has been in custody for more than 56 days, the cells in the 56 days column will be highlighted in orange. Immediate action must be taken in accordance with our national standards if this should occur.\n\n•   The calculator can be used for calculations for any date  up to 28 September 2020. It should not be used for dates beyond that date. It can also be used to check calculations in 2019. Users who download the calculator to a laptop will need to exercise caution at the end of the year and upload the right calculator."]
[]
[]
[]
[null,"Keeping a record"]
[]
[null,"•   A copy of the calculator should be uploaded to CMS by clicking on the ‘Save as Word Doc’ box. You may find it useful to enter the D’s name and case URN and forward to CMS."]
[]
[]
[]
[null,"Contact details"]
[]
[null,"Compliance and Assurance Team (Legal)"]
[null,"Operations Directorate"]
[null,"Email:","ComplianceandAssuranceTeam@cps.gov.uk"]