{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["header","in court","out of court","travel expenses","other expenses","summary","voucher","cumulative","cja26","court use","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":14,"comments":2,"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":"header","index":0,"n_rows":39,"n_cols":3,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[14,2,14,4],[2,0,2,5],[8,10,8,11],[8,2,8,4],[10,2,10,4],[12,2,12,4],[29,10,29,11],[27,2,27,4],[29,2,29,4],[16,2,16,4],[23,6,23,8],[29,7,29,8],[23,2,23,4],[25,2,25,4],[21,2,21,4],[19,2,19,4],[17,2,17,4]]}
["UNITED STATES DISTRICT COURT"]
["MIDDLE DISTRICT OF NORTH CAROLINA"]
["CJA WORKSHEETS"]
[]
[null,"To start the billing process, please complete the following information:"]
[]
[]
[]
[null,"Case Number:"]
[]
[null,"Case Name:"]
[]
[null,"Defendant:"]
[]
[null,"District Judge:"]
[]
[null,null,"Appointed Attorney"]
[null,"Full Name:"]
[]
[null,"Firm Name:"]
[]
[null,"Street or PO Box:"]
[]
[null,"City, State, ZIP:"]
[]
[null,"Phone#:"]
[]
[null,"Fax#:"]
[]
[null,"E-mail:"]
[]
[]
[]
[]
[null,"To clear only time and expenses"]
[null,"and to cumulate totals:"]
[]
[null,"To clear the entire file,"]
[null,"including cumulative totals:"]

{"sheet":"in court","index":1,"n_rows":9,"n_cols":20,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["CJA 20 Worksheet - In Court Hourly Worksheet"]
["MDNC (4/8/15)"]
[]
["Attorney:  ",{"$f":"IF(header!C18=\"\",\"\",header!C18)","v":""}]
["Defendant:  ",{"$f":"IF(header!C13=\"\",\"\",header!C13)","v":""}]
["Case No:  ",{"$f":"IF(header!C9=\"\",\"\",header!C9)","v":""}]
["Judge:  ",{"$f":"IF(header!C15=\"\",\"\",header!C15)","v":""}]
[]
["Date","Description",null,"15.a.  Arraignment/Plea","Court Adjustments","15.b.  Bail/Detention","Court Adjustments","15.c.  Motions","Court Adjustments","15.d.  Trial","Court Adjustments","15.e.  Sentencing","Court Adjustments","15.f.  Revocation","Court Adjustments","15.g.  Appeals Court","Court Adjustments","15.h.  Other","Court Adjustments","Adjustment Explanation"]

{"sheet":"out of court","index":2,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["CJA 20 Worksheet - Out Of Court Hourly Worksheet"]
["MDNC (4/8/15)"]
[]
["Attorney:  ",{"$f":"IF(header!C18=\"\",\"\",header!C18)","v":""}]
["Defendant:  ",{"$f":"IF(header!C13=\"\",\"\",header!C13)","v":""}]
["Case No:  ",{"$f":"IF(header!C9=\"\",\"\",header!C9)","v":""}]
["Judge:  ",{"$f":"IF(header!C15=\"\",\"\",header!C15)","v":""}]
[]
[]
["Date","Description","Doc Number (CM/ECF)","Pages",null,"16.a.  Interviews and Conferences","Court Adjustments","16.b.  Obtaining and Reviewing Records","Court Adjustments","16.c.  Legal Reseach\\Writing and Brief","Court Adjustments","16.d. Travel Time","Court Adjustments","16.e. Investigative/Other Work","Court Adjustments","Adjustment Explanation"]

{"sheet":"travel expenses","index":3,"n_rows":10,"n_cols":20,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["CJA 20 Worksheet - Travel Expense Worksheet"]
["MDNC (4/8/15)"]
[]
["Attorney:  ",{"$f":"IF(header!C18=\"\",\"\",header!C18)","v":""}]
["Defendant:  ",{"$f":"IF(header!C13=\"\",\"\",header!C13)","v":""}]
["Case No:  ",{"$f":"IF(header!C9=\"\",\"\",header!C9)","v":""}]
["Judge:  ",{"$f":"IF(header!C15=\"\",\"\",header!C15)","v":""}]
[]
[]
["Date","Expense Description",null,"Mileage","Court Adj.","Parking","Court Adj.","Airfare","Court Adj.","Rental Car","Court Adj.","Taxi/ Shuttle","Court Adj.","Lodging","Court Adj.","Meals","Court Adj.","Other","Court Adj.","Adjustment Explanation"]

{"sheet":"other expenses","index":4,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["CJA 20 Worksheet -  Other Expenses Worksheet"]
["MDNC (4/8/15)"]
[]
["Attorney:  ",{"$f":"IF(header!C18=\"\",\"\",header!C18)","v":""}]
["Defendant:  ",{"$f":"IF(header!C13=\"\",\"\",header!C13)","v":""}]
["Case No:  ",{"$f":"IF(header!C9=\"\",\"\",header!C9)","v":""}]
["Judge:  ",{"$f":"IF(header!C15=\"\",\"\",header!C15)","v":""}]
[]
[]
["Date","Expense Description",null,"Facsimile","Court Adj.","Toll Calls","Court Adj.","Copying","Court Adj.","Postage","Court Adj.","Other","Court Adj.","Adjustment Explanation"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N10:O11)","v":0}]

{"sheet":"summary","index":5,"n_rows":49,"n_cols":10,"rows_kept":49,"cut":false,"hidden":false,"merged":[[23,0,23,1],[24,0,24,1],[21,0,21,1],[9,2,9,3],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[22,0,22,1],[13,0,13,1],[0,0,0,9],[9,0,9,1],[10,0,10,1],[15,0,15,1],[8,0,8,1],[11,0,11,1],[12,0,12,1],[14,0,14,1],[8,4,8,5],[8,2,8,3],[9,4,9,5],[9,6,9,7],[9,8,9,9],[8,6,8,7],[8,8,8,9],[46,0,46,1],[39,0,39,1],[41,0,41,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[40,0,40,1],[33,0,33,1],[32,0,32,1],[25,0,25,1],[28,0,28,1],[26,0,26,1],[27,0,27,1]]}
["CJA 20 - Voucher Summary"]
["MDNC (4/8/15)"]
[]
["Attorney:  ",{"$f":"'in court'!B4","v":""}]
["Defendant:  ",{"$f":"'in court'!B5","v":""}]
["Case No:  ",{"$f":"'in court'!B6","v":""}]
["Judge:  ",{"$f":"'in court'!B7","v":""}]
[]
[null,null,"1/1/2015 - current",null,"3/1/2014 - 12/31/2014",null,"9/1/2013 - 2/28/2014",null,"1/1/2010 - 8/31/2013"]
["Rate",null,127,null,126,null,110,null,125]
["Categories",null,"Hours Claimed","Court Adjustment","Hours Claimed","Court Adjustment","Hours Claimed","Court Adjustment","Hours Claimed","Court Adjustment"]
["15a - Arraignment/Plea",null,{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2014\",'in court'!D:D))","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2014\",'in court'!E:E))","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">2/28/2014\",'in court'!D:D)) - C12","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">2/28/2014\",'in court'!E:E)) - D12","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">8/31/2013\",'in court'!D:D)) - C12-E12","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">8/31/2013\",'in court'!E:E)) - F12 - D12","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2009\",'in court'!D:D)) - G12 -E12 -C12","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2009\",'in court'!E:E)) - H12 -F12 -D12","v":0}]
["15b - Bail/Detention",null,{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2014\",'in court'!F:F))","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2014\",'in court'!G:G))","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">2/28/2014\",'in court'!F:F)) - C13","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">2/28/2014\",'in court'!G:G)) - D13","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">8/31/2013\",'in court'!F:F)) - C13-E13","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">8/31/2013\",'in court'!G:G)) - F13 - D13","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2009\",'in court'!F:F)) - G13 -E13 -C13","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2009\",'in court'!G:G)) - H13 -F13 -D13","v":0}]
["15c - Motions",null,{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2014\",'in court'!H:H))","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2014\",'in court'!I:I))","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">2/28/2014\",'in court'!H:H)) - C14","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">2/28/2014\",'in court'!I:I)) - D14","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">8/31/2013\",'in court'!H:H)) - C14-E14","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">8/31/2013\",'in court'!I:I)) - F14 - D14","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2009\",'in court'!H:H)) - G14 -E14 -C14","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2009\",'in court'!I:I)) - H14 -F14 -D14","v":0}]
["15d - Trial",null,{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2014\",'in court'!J:J))","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2014\",'in court'!K:K))","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">2/28/2014\",'in court'!J:J)) - C15","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">2/28/2014\",'in court'!K:K)) - D15","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">8/31/2013\",'in court'!J:J)) - C15-E15","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">8/31/2013\",'in court'!K:K)) - F15 - D15","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2009\",'in court'!J:J)) - G15 -E15 -C15","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2009\",'in court'!K:K)) - H15 -F15 -D15","v":0}]
["15e - Sentencing",null,{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2014\",'in court'!L:L))","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2014\",'in court'!M:M))","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">2/28/2014\",'in court'!L:L)) - C16","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">2/28/2014\",'in court'!M:M)) - D16","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">8/31/2013\",'in court'!L:L)) - C16-E16","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">8/31/2013\",'in court'!M:M)) - F16 - D16","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2009\",'in court'!L:L)) - G16 -E16 -C16","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2009\",'in court'!M:M)) - H16 -F16 -D16","v":0}]
["15f - Revocation",null,{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2014\",'in court'!N:N))","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2014\",'in court'!O:O))","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">2/28/2014\",'in court'!N:N)) - C17","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">2/28/2014\",'in court'!O:O)) - D17","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">8/31/2013\",'in court'!N:N)) - C17-E17","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">8/31/2013\",'in court'!O:O)) - F17 - D17","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2009\",'in court'!N:N)) - G17 -E17 -C17","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2009\",'in court'!O:O)) - H17 -F17 -D17","v":0}]
["15g - Appeals Court",null,{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2014\",'in court'!P:P))","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2014\",'in court'!Q:Q))","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">2/28/2014\",'in court'!P:P)) - C18","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">2/28/2014\",'in court'!Q:Q)) - D18","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">8/31/2013\",'in court'!P:P)) - C18-E18","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">8/31/2013\",'in court'!Q:Q)) - F18 - D18","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2009\",'in court'!P:P)) - G18 -E18 -C18","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2009\",'in court'!Q:Q)) - H18 -F18 -D18","v":0}]
["15h - Other",null,{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2014\",'in court'!R:R))","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2014\",'in court'!S:S))","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">2/28/2014\",'in court'!R:R)) - C19","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">2/28/2014\",'in court'!S:S)) - D19","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">8/31/2013\",'in court'!R:R)) - C19-E19","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">8/31/2013\",'in court'!S:S)) - F19 - D19","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2009\",'in court'!R:R)) - G19 -E19 -C19","v":0},{"$f":"(SUMIF('in court'!$A:$A,\">12/31/2009\",'in court'!S:S)) - H19 -F19 -D19","v":0}]
["Total 15a - 15h (Hours)",null,{"$f":"SUM(C12:C19)","v":0},0,0,0,0,0,{"$f":"SUM(I12:I19)","v":0},{"$f":"SUM(J12:J19)","v":0}]
["Total In-Court x Rate Per Hour",null,{"$f":"C20*C10","v":0},{"$f":"D20*C10","v":0},{"$f":"E20*E10","v":0},{"$f":"F20*E10","v":0},{"$f":"G20*G10","v":0},{"$f":"H20*G10","v":0},{"$f":"I20*I10","v":0},{"$f":"J20*I10","v":0}]
[]
["16a - Interviews",null,{"$f":"(SUMIF('out of court'!$A:$A,\">12/31/2014\",'out of court'!F:F))","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">12/31/2014\",'out of court'!G:G))","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">2/28/2014\",'out of court'!F:F)) - C23","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">2/28/2014\",'out of court'!G:G)) - D23","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">8/31/2013\",'out of court'!F:F)) - E23 - C23","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">8/31/2013\",'out of court'!G:G)) - F23 - D23","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">12/31/2009\",'out of court'!F:F))-E23-C23-G23","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">12/31/2009\",'out of court'!G:G))-D23-F23-H23","v":0}]
["16b - Records",null,{"$f":"(SUMIF('out of court'!$A:$A,\">12/31/2014\",'out of court'!H:H))","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">12/31/2014\",'out of court'!I:I))","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">2/28/2014\",'out of court'!H:H)) - C24","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">2/28/2014\",'out of court'!I:I)) - D24","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">8/31/2013\",'out of court'!H:H)) - E24 - C24","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">8/31/2013\",'out of court'!I:I)) - F24 - D24","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">12/31/2009\",'out of court'!H:H))-E24-C24-G24","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">12/31/2009\",'out of court'!I:I))-F24-D24-H24","v":0}]
["16c - Research/Writing",null,{"$f":"(SUMIF('out of court'!$A:$A,\">12/31/2014\",'out of court'!J:J))","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">12/31/2014\",'out of court'!K:K))","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">2/28/2014\",'out of court'!J:J)) - C25","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">2/28/2014\",'out of court'!K:K)) - D25","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">8/31/2013\",'out of court'!J:J)) - E25 - C25","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">8/31/2013\",'out of court'!K:K)) - F25 - D25","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">12/31/2009\",'out of court'!J:J))-C25-E25-G25","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">12/31/2009\",'out of court'!K:K))-D25-F25-H25","v":0}]
["16d - Travel Time",null,{"$f":"(SUMIF('out of court'!$A:$A,\">12/31/2014\",'out of court'!L:L))","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">12/31/2014\",'out of court'!M:M))","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">2/28/2014\",'out of court'!L:L)) - C26","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">2/28/2014\",'out of court'!M:M)) - D26","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">8/31/2013\",'out of court'!L:L)) - E26 - C26","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">8/31/2013\",'out of court'!M:M)) - F26 - D26","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">12/31/2009\",'out of court'!L:L))-C26-E26-G26","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">12/31/2009\",'out of court'!M:M))-D26-F26-H26","v":0}]
["16e - Investigative/Other",null,{"$f":"(SUMIF('out of court'!$A:$A,\">12/31/2014\",'out of court'!N:N))","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">12/31/2014\",'out of court'!O:O))","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">2/28/2014\",'out of court'!N:N)) - C27","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">2/28/2014\",'out of court'!O:O)) - D27","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">8/31/2013\",'out of court'!N:N)) - E27 - C27","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">8/31/2013\",'out of court'!O:O)) - F27 - D27","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">12/31/2009\",'out of court'!N:N))-C27-E27-G27","v":0},{"$f":"(SUMIF('out of court'!$A:$A,\">12/31/2009\",'out of court'!O:O))-F27-D27-H27","v":0}]
["Total 16a - 16e (Hours)",null,{"$f":"SUM(C23:C27)","v":0},{"$f":"SUM(D23:D27)","v":0},0,{"$f":"SUM(F23:F27)","v":0},0,{"$f":"SUM(H23:H27)","v":0},{"$f":"SUM(I23:I27)","v":0},{"$f":"SUM(J23:J27)","v":0}]
["Total Out-of-Court x Rate Per Hour",null,{"$f":"C28*C10","v":0},{"$f":"D28*C10","v":0},{"$f":"E28*E10","v":0},{"$f":"F28*E10","v":0},{"$f":"G28*G10","v":0},{"$f":"H28*G10","v":0},{"$f":"I28*I10","v":0},{"$f":"J28*I10","v":0}]
[]
[]
[]
["17. Travel Miles",null,"1/1/2015 - current","1/1/2014 - 12/31/2014","1/1/2013 - 12/31/2013","4/17/2012 - 12/31/2012","1/1/2011 - 4/16/2012","1/1/2010 - 12/31/2010","2/1/2009 - 12/31/2009","3/19/2008 - 1/31/2009"]
["Rate per mile:     ",null,0.57499999999999996,0.56000000000000005,0.56499999999999995,0.55500000000000005,0.51,0.5,0.55000000000000004,0.58499999999999996]
["Total Miles Claimed",null,{"$f":"(SUMIF('travel expenses'!A:A,\">12/31/2014\",'travel expenses'!D:D))","v":0},{"$f":"(SUMIF('travel expenses'!A:A,\">12/31/2013\",'travel expenses'!D:D))-C35","v":0},{"$f":"(SUMIF('travel expenses'!A:A,\">12/31/2012\",'travel expenses'!D:D))-C35-D35","v":0},{"$f":"(SUMIF('travel expenses'!A:A,\">4/16/2012\",'travel expenses'!D:D))-E35-D35-C35","v":0},{"$f":"(SUMIF('travel expenses'!A:A,\">12/31/2010\",'travel expenses'!D:D))-F35-E35-D35-C35","v":0},{"$f":"(SUMIF('travel expenses'!A:A,\">12/31/2009\",'travel expenses'!D:D))-G35-F35-E35-D35-C35","v":0},{"$f":"(SUMIF('travel expenses'!A:A,\">1/31/2009\",'travel expenses'!D:D))-H35-G35-F35-E35-D35-C35","v":0},{"$f":"(SUMIF('travel expenses'!A:A,\">1/31/2009\",'travel expenses'!D:D))-C35-D35-E35-F35-G35-H35-I35","v":0}]
["Miles Adjustmented by Court",null,{"$f":"(SUMIF('travel expenses'!A:A,\">12/31/2014\",'travel expenses'!E:E))","v":0},{"$f":"(SUMIF('travel expenses'!A:A,\">12/31/2013\",'travel expenses'!E:E))-C36","v":0},{"$f":"(SUMIF('travel expenses'!A:A,\">12/31/2012\",'travel expenses'!E:E))-C36-D36","v":0},{"$f":"(SUMIF('travel expenses'!A:A,\">4/16/2012\",'travel expenses'!E:E))-E36-D36-C36","v":0},{"$f":"(SUMIF('travel expenses'!A:A,\">12/31/2010\",'travel expenses'!E:E))-F36-E36-D36-C36","v":0},{"$f":"(SUMIF('travel expenses'!A:A,\">12/31/2009\",'travel expenses'!E:E))-G36-F36-E36-D36-C36","v":0},{"$f":"(SUMIF('travel expenses'!A:A,\">1/31/2009\",'travel expenses'!E:E))-H36-G36-F36-E36-D36-C36","v":0},{"$f":"(SUMIF('travel expenses'!A:A,\">11/31/2009\",'travel expenses'!E:E))-C36-D36-E36-F36-G36-H36-I36","v":0}]
["Total Adusted Mileage x Rate Per Mile",null,{"$f":"(C35+C36)*C34","v":0},0,0,0,0,0,0,0]
[]
[null,null,"Atty Request","Court Adj. (if any)","Total Approved"]
["17. Travel Misc.",null,{"$f":"(SUMIF('travel expenses'!$A:$A,\">1/1/2005\",'travel expenses'!F:F))+(SUMIF('travel expenses'!$A:$A,\">1/1/2005\",'travel expenses'!H:H))+(SUMIF('travel expenses'!$A:$A,\">1/1/2005\",'travel expenses'!J:J))+(SUMIF('travel expenses'!$A:$A,\">1/1/2005\",'travel expenses'!L:L))+(SUMIF('travel expenses'!$A:$A,\">1/1/2005\",'travel expenses'!N:N))+(SUMIF('travel expenses'!$A:$A,\">1/1/2005\",'travel expenses'!P:P))+(SUMIF('travel expenses'!$A:$A,\">1/1/2005\",'travel expenses'!R:R))","v":0},{"$f":"(SUMIF('travel expenses'!$A:$A,\">1/1/2005\",'travel expenses'!G:G))+(SUMIF('travel expenses'!$A:$A,\">1/1/2005\",'travel expenses'!I:I))+(SUMIF('travel expenses'!$A:$A,\">1/1/2005\",'travel expenses'!K:K))+(SUMIF('travel expenses'!$A:$A,\">1/1/2005\",'travel expenses'!M:M))+(SUMIF('travel expenses'!$A:$A,\">1/1/2005\",'travel expenses'!O:O))+(SUMIF('travel expenses'!$A:$A,\">1/1/2005\",'travel expenses'!Q:Q))+(SUMIF('travel expenses'!$A:$A,\">1/1/2005\",'travel expenses'!S:S))","v":0},{"$f":"C40+D40","v":0}]
["17. Total Travel Expenses",null,{"$f":"(C35*C34)+(D35*D34)+(E35*E34)+(F35*F34)+(G35*G34)+(H35*H34)+(I35*I34)+(J35*J34)+C40","v":0},{"$f":"((D36*D34)+(E36*E34)+(F36*F34)+(G36*G34)+(H36*H34)+(I36*I34)+(J36*J34))+D40","v":0},0]
["18. Facsimile",null,{"$f":"(SUMIF('other expenses'!$A:$A,\">1/1/2005\",'other expenses'!D:D))","v":0},{"$f":"(SUMIF('other expenses'!$A:$A,\">1/1/2005\",'other expenses'!E:E))","v":0},0]
["18. Long Distance Charges",null,{"$f":"(SUMIF('other expenses'!$A:$A,\">1/1/2005\",'other expenses'!F:F))","v":0},{"$f":"(SUMIF('other expenses'!$A:$A,\">1/1/2005\",'other expenses'!G:G))","v":0},0]
["18. Photo Copies",null,{"$f":"(SUMIF('other expenses'!$A:$A,\">1/1/2005\",'other expenses'!H:H))","v":0},{"$f":"(SUMIF('other expenses'!$A:$A,\">1/1/2005\",'other expenses'!I:I))","v":0},0]
["18. Postage",null,{"$f":"(SUMIF('other expenses'!$A:$A,\">1/1/2005\",'other expenses'!J:J))","v":0},{"$f":"(SUMIF('other expenses'!$A:$A,\">1/1/2005\",'other expenses'!K:K))","v":0},0]
["18. Other Expenses",null,{"$f":"(SUMIF('other expenses'!$A:$A,\">1/1/2005\",'other expenses'!L:L))","v":0},{"$f":"(SUMIF('other expenses'!$A:$A,\">1/1/2005\",'other expenses'!M:M))","v":0},0]
["18. Total Other Expenses",null,{"$f":"SUM(C42:C46)","v":0},{"$f":"SUM(D42:D46)","v":0},{"$f":"SUM(E42:E46)","v":0}]
[]
["Amounts transferred to voucher:",null,{"$f":"C21+E21+G21+I21+C29+E29+G29+I29+C41+C47","v":0},{"$f":"D21+F21+H21+J21+D29+F29+H29+J29+D41+D47","v":0},{"$f":"C49+D49","v":0}]

{"sheet":"voucher","index":6,"n_rows":119,"n_cols":41,"rows_kept":119,"cut":false,"hidden":false,"merged":[[29,59,29,62],[29,53,29,56],[40,6,40,7],[39,6,39,7],[31,8,31,11],[30,5,30,11],[25,59,25,62],[27,59,27,62],[15,53,15,56],[26,9,26,10],[13,6,17,11],[38,6,38,7],[36,6,36,7],[10,58,10,62],[11,59,11,62],[13,59,13,62],[14,59,14,62],[10,52,10,56],[11,53,11,56],[28,59,28,62],[19,53,19,56],[25,53,25,56],[27,53,27,56],[28,53,28,56],[15,59,15,62],[17,59,17,62],[19,59,19,62],[17,53,17,56],[2,9,2,11],[10,5,10,7],[24,6,24,10],[6,9,6,11],[41,6,41,7],[13,53,13,56],[14,53,14,56],[11,10,11,11],[4,9,4,10],[8,0,9,11],[12,5,12,8],[32,6,32,7],[37,6,37,7],[2,0,2,2],[4,0,4,2],[4,6,4,8],[4,3,4,4],[2,3,2,8],[25,1,25,4],[6,0,6,2],[6,3,6,5],[6,6,6,8],[11,5,11,8],[33,6,33,7],[84,1,86,7],[58,0,59,6],[64,4,64,6],[64,2,64,3],[62,0,62,11],[64,0,64,1],[61,2,61,6],[61,9,61,10],[12,10,12,11],[64,10,64,11],[66,0,66,2],[66,3,66,6],[52,8,53,8],[56,8,57,9],[58,9,59,11],[52,9,53,11],[64,7,64,8],[13,1,13,4],[14,1,14,4],[15,1,15,4],[17,1,17,4],[51,0,51,5],[31,0,31,7],[27,9,27,10],[48,6,48,7],[22,6,23,10],[47,6,47,7],[43,6,43,7],[28,1,28,4],[29,1,29,4],[46,6,46,7],[44,6,44,7],[34,6,34,7],[26,6,26,7],[42,6,42,7],[27,6,27,7],[10,8,10,11],[10,0,10,4],[11,1,11,4],[70,0,71,6],[68,7,68,8],[68,10,68,11],[70,7,71,8],[70,10,71,11],[68,0,68,1],[68,2,68,3],[68,4,68,6],[66,10,66,11],[66,7,66,8],[56,0,57,4],[50,6,50,7],[52,6,53,7],[45,6,45,7],[43,0,47,0],[19,1,19,4],[27,1,27,4],[49,6,49,7],[32,0,32,3],[34,0,41,0],[35,6,35,7]]}
["     CJA 20 (Electronic Form) APPOINTMENT OF AND AUTHORITY TO PAY COURT APPOINTED COUNSEL (Rev. 12/03)"]
["1.  CIR./ DIST./ DIV. CODE",null,null,"2. PERSON REPRESENTED",null,null,null,null,null,"VOUCHER NUMBER"]
[null,null,null,{"$f":"header!C13","v":0}]
["3. MAG. DKT./ DEF. NUMBER",null,null,"4. DIST. DKT./ DEF. NUMBER",null,null,"5. APPEALS DKT./ DEF. NUMBER",null,null,"6. OTHER DKT. NUMBER"]
[null,null,null,{"$f":"header!C9","v":0}]
["7. IN CASE/MATTER OF (Case Name)",null,null,"8. PAYMENT CATEGORY",null,null,"9. TYPE PERSON REPRESENTED",null,null,"10. REPRESENTATION TYPE"]
[{"$f":"header!C11","v":0}]
["11. OFFENSE(S) CHARGED (Cite U.S. Code, Title & Section)  If more than one offense, list (up to five) major offenses charged, according to severity of offense."]
[]
[]
["12. ATTORNEY'S NAME (First Name, M.I., Last Name, including any suffix), AND MAILING ADDRESS:",null,null,null,null,"13.  COURT ORDER:     "]
["Name:",{"$f":"header!C18","v":0}]
[null,null,null,null,null,"Prior Attorney's Name",null,null,null,null,"Appointment Dates"]
["Address:",{"$f":"header!C20","v":0},null,null,null,null,"Because the above-named person represented has testified under oath or has otherwise satisfied this Court that he or she (1) is financially unable to employ counsel and (2) does not wish to waive counsel, and because the interests of justice so require, the attorney whose name appears in Item 12 is appointed to represent this person in his case, OR"]
[null,{"$f":"header!C22","v":0}]
[null,{"$f":"header!C24","v":0}]
[]
["Phone #",{"$f":"header!C26","v":0}]
[]
["Fax #",{"$f":"header!C28","v":0},null,null,null,null,"Other (See Instructions)"]
[]
["14.  NAME AND ADDRESS OF LAW FIRM"]
["      (Only provide per instructions)"]
[null,null,null,null,null,"      "]
[null,null,null,null,null,null,"Signature of presiding Judicial Officer or By Order of the Court"]
["Name:"]
[]
["Address:",0,null,null,null,null,"Date of Order",null,null,"Nunc Pro Tunc Date"]
[null,0]
[null,0]
[null,null,null,null,null,"Repayment or partial repayment ordered from the person represented for this service at time of appointment."]
["CLAIM FOR SERVICES AND EXPENSES",null,null,null,null,null,null,null,"FOR COURT USE ONLY"]
["Categories (Attach itemization of services w/ dates)",null,null,null,"HOURS CLAIMED",null,"TOTAL AMOUNT CLAIMED",null,"Math/Tech. Adjusted Hrs","Math/Tech. Adjusted Amounts","Additional Review","Amount Authorized"]
["15.","  a.  Arraignment and/or Plea",null,null,{"$f":"summary!C12+summary!E12+summary!G12+summary!I12","v":0},null,{"$f":"(summary!C12*summary!$C$10)+(summary!E12*summary!$E$10)+(summary!G12*summary!$G$10)+(summary!I12*summary!$I$10)","v":0},null,{"$f":"(summary!D12+summary!F12+summary!H12+summary!J12)","v":0},{"$f":"((summary!D12*summary!$C$10)+(summary!F12*summary!$E$10)+(summary!H12*summary!$G$10)+(summary!J12*summary!$I$10))","v":0},null,{"$f":"G34+J34+K34","v":0}]
["In Court","  b.  Bail and Detention Hearings",null,null,{"$f":"summary!C13+summary!E13+summary!G13+summary!I13","v":0},null,{"$f":"(summary!C13*summary!$C$10)+(summary!E13*summary!$E$10)+(summary!G13*summary!$G$10)+(summary!I13*summary!$I$10)","v":0},null,{"$f":"(summary!D13+summary!F13+summary!H13+summary!J13)","v":0},{"$f":"((summary!D13*summary!$C$10)+(summary!F13*summary!$E$10)+(summary!H13*summary!$G$10)+(summary!J13*summary!$I$10))","v":0},null,{"$f":"G35+J35+K35","v":0}]
[null,"  c.  Motion Hearings",null,null,{"$f":"summary!C14+summary!E14+summary!G14+summary!I14","v":0},null,{"$f":"(summary!C14*summary!$C$10)+(summary!E14*summary!$E$10)+(summary!G14*summary!$G$10)+(summary!I14*summary!$I$10)","v":0},null,{"$f":"(summary!D14+summary!F14+summary!H14+summary!J14)","v":0},{"$f":"((summary!D14*summary!$C$10)+(summary!F14*summary!$E$10)+(summary!H14*summary!$G$10)+(summary!J14*summary!$I$10))","v":0},null,0]
[null,"  d.  Trial",null,null,{"$f":"summary!C15+summary!E15+summary!G15+summary!I15","v":0},null,{"$f":"(summary!C15*summary!$C$10)+(summary!E15*summary!$E$10)+(summary!G15*summary!$G$10)+(summary!I15*summary!$I$10)","v":0},null,{"$f":"(summary!D15+summary!F15+summary!H15+summary!J15)","v":0},{"$f":"((summary!D15*summary!$C$10)+(summary!F15*summary!$E$10)+(summary!H15*summary!$G$10)+(summary!J15*summary!$I$10))","v":0},null,0]
[null,"  e.  Sentencing Hearings",null,null,{"$f":"summary!C16+summary!E16+summary!G16+summary!I16","v":0},null,{"$f":"(summary!C16*summary!$C$10)+(summary!E16*summary!$E$10)+(summary!G16*summary!$G$10)+(summary!I16*summary!$I$10)","v":0},null,{"$f":"(summary!D16+summary!F16+summary!H16+summary!J16)","v":0},{"$f":"((summary!D16*summary!$C$10)+(summary!F16*summary!$E$10)+(summary!H16*summary!$G$10)+(summary!J16*summary!$I$10))","v":0},null,0]
[null,"  f.  Revocation Hearings",null,null,{"$f":"summary!C17+summary!E17+summary!G17+summary!I17","v":0},null,{"$f":"(summary!C17*summary!$C$10)+(summary!E17*summary!$E$10)+(summary!G17*summary!$G$10)+(summary!I17*summary!$I$10)","v":0},null,{"$f":"(summary!D17+summary!F17+summary!H17+summary!J17)","v":0},{"$f":"((summary!D17*summary!$C$10)+(summary!F17*summary!$E$10)+(summary!H17*summary!$G$10)+(summary!J17*summary!$I$10))","v":0},null,0]
[null,"  g.  Appeals Court",null,null,{"$f":"summary!C18+summary!E18+summary!G18+summary!I18","v":0},null,{"$f":"(summary!C18*summary!$C$10)+(summary!E18*summary!$E$10)+(summary!G18*summary!$G$10)+(summary!I18*summary!$I$10)","v":0},null,{"$f":"(summary!D18+summary!F18+summary!H18+summary!J18)","v":0},{"$f":"((summary!D18*summary!$C$10)+(summary!F18*summary!$E$10)+(summary!H18*summary!$G$10)+(summary!J18*summary!$I$10))","v":0},null,0]
[null,"  h.  Other (Specify on add'l sheets)",null,null,{"$f":"summary!C19+summary!E19+summary!G19+summary!I19","v":0},null,{"$f":"(summary!C19*summary!$C$10)+(summary!E19*summary!$E$10)+(summary!G19*summary!$G$10)+(summary!I19*summary!$I$10)","v":0},null,{"$f":"(summary!D19+summary!F19+summary!H19+summary!J19)","v":0},{"$f":"((summary!D19*summary!$C$10)+(summary!F19*summary!$E$10)+(summary!H19*summary!$G$10)+(summary!J19*summary!$I$10))","v":0},null,0]
[null,null,0,"TOTALS",{"$f":"SUM(E34:E41)","v":0},null,{"$f":"SUM(G34:H41)","v":0},null,{"$f":"SUM(I34:I41)","v":0},{"$f":"SUM(J34:J41)","v":0},null,{"$f":"SUM(L34:L41)","v":0}]
["16.","  a.  Interviews and Conferences",null,null,{"$f":"summary!C23+summary!E23+summary!G23+summary!I23","v":0},null,{"$f":"(summary!C23*summary!$C$10)+(summary!E23*summary!$E$10)+(summary!G23*summary!$G$10)+(summary!I23*summary!$I$10)","v":0},null,{"$f":"(summary!D23+summary!F23+summary!H23+summary!J23)","v":0},{"$f":"((summary!D23*summary!$C$10)+(summary!F23*summary!$E$10)+(summary!H23*summary!$G$10)+(summary!J23*summary!$I$10))","v":0},null,{"$f":"G43+J43+K43","v":0}]
["Out of Court","  b.  Obtaining and reviewing records",null,null,{"$f":"summary!C24+summary!E24+summary!G24+summary!I24","v":0},null,{"$f":"(summary!C24*summary!$C$10)+(summary!E24*summary!$E$10)+(summary!G24*summary!$G$10)+(summary!I24*summary!$I$10)","v":0},null,{"$f":"(summary!D24+summary!F24+summary!H24+summary!J24)","v":0},{"$f":"((summary!D24*summary!$C$10)+(summary!F24*summary!$E$10)+(summary!H24*summary!$G$10)+(summary!J24*summary!$I$10))","v":0},null,{"$f":"G44+J44+K44","v":0}]
[null,"  c.  Legal Research and brief writing",null,null,{"$f":"summary!C25+summary!E25+summary!G25+summary!I25","v":0},null,{"$f":"(summary!C25*summary!$C$10)+(summary!E25*summary!$E$10)+(summary!G25*summary!$G$10)+(summary!I25*summary!$I$10)","v":0},null,{"$f":"(summary!D25+summary!F25+summary!H25+summary!J25)","v":0},{"$f":"((summary!D25*summary!$C$10)+(summary!F25*summary!$E$10)+(summary!H25*summary!$G$10)+(summary!J25*summary!$I$10))","v":0},null,{"$f":"G45+J45+K45","v":0}]
[null,"  d.  Travel time",null,null,{"$f":"summary!C26+summary!E26+summary!G26+summary!I26","v":0},null,{"$f":"(summary!C26*summary!$C$10)+(summary!E26*summary!$E$10)+(summary!G26*summary!$G$10)+(summary!I26*summary!$I$10)","v":0},null,{"$f":"(summary!D26+summary!F26+summary!H26+summary!J26)","v":0},{"$f":"((summary!D26*summary!$C$10)+(summary!F26*summary!$E$10)+(summary!H26*summary!$G$10)+(summary!J26*summary!$I$10))","v":0},null,{"$f":"G46+J46+K46","v":0}]
[null,"  e. Investigative & other work (Specify)",null,null,{"$f":"summary!C27+summary!E27+summary!G27+summary!I27","v":0},null,{"$f":"(summary!C27*summary!$C$10)+(summary!E27*summary!$E$10)+(summary!G27*summary!$G$10)+(summary!I27*summary!$I$10)","v":0},null,{"$f":"(summary!D27+summary!F27+summary!H27+summary!J27)","v":0},{"$f":"((summary!D27*summary!$C$10)+(summary!F27*summary!$E$10)+(summary!H27*summary!$G$10)+(summary!J27*summary!$I$10))","v":0},null,{"$f":"G47+J47+K47","v":0}]
[null,null,{"$f":"C42","v":0},"TOTALS",{"$f":"SUM(E43:E47)","v":0},null,{"$f":"SUM(G43:H47)","v":0},null,{"$f":"SUM(I43:I47)","v":0},{"$f":"SUM(J43:J47)","v":0},null,{"$f":"SUM(L43:L47)","v":0},null,{"$f":"SUM(G42+G48)","v":0}]
["17.  Travel Expenses (lodging, parking, meals, mileage, etc.)",null,null,null,null,null,{"$f":"summary!C41","v":0},null,null,{"$f":"summary!D41","v":0},null,{"$f":"G49+J49+K49","v":0}]
["18.  Other Expenses (other than expert, transcripts, etc.)",null,null,null,null,null,{"$f":"summary!C47","v":0},null,null,{"$f":"summary!D47","v":0},null,{"$f":"G50+J50+K50","v":0}]
["GRAND TOTALS (CLAIMED AND ADJUSTED):",null,null,null,null,null,{"$f":"G42+G48+G49+G50","v":0},null,null,{"$f":"J42+J48+J49+J50","v":0},null,{"$f":"L42+L48+L49+L50","v":0}]
["19.  CERTIFICATION OF ATTORNEY/PAYEE FOR THE PERIOD OF SERVICE",null,null,null,null,null,"20.  APPOINTMENT TERMINATION",null,null,"21.  CASE DISPOSITION"]
["From:",{"$f":"MIN('in court'!A:A, 'out of court'!A:A)","v":"00:00:00"},"to:",{"$f":"MAX('in court'!A:A,'out of court'!A:A)","v":"00:00:00"},null,null," DATE IF OTHER THAN CASE COMPLETION:"]
[]
["22.  CLAIM STATUS: "]
[null,null,null,null,null,null,null,"(Payment #)"]
["Have you previously applied to the court for compensation and/or reimbursement for this case? ",null,null,null,null,null,null,null,"If yes, were you paid?"]
[]
["Other than from the court, have you, or to your knowledge has anyone else, received payment (compensation or anything of value) from any other source in connection with this representation?",null,null,null,null,null,null,null,null,"If yes, give details on additional sheets."]
[]
["I swear or affirm the truth or correctness of the above statements."]
["Signature of Attorney",null,null,null,null,null,null,null,null,"Date"]
["APPROVED FOR PAYMENT--COURT USE ONLY"]
["23. IN COURT COMP.",null,"24. OUT OF COURT COMP",null,"25. TRAVEL EXPENSES",null,null,"26. OTHER EXPENSES",null,"27. TOTAL AMT. APPR. -- Check if Certified"]
[{"$f":"L42","v":0},null,{"$f":"L48","v":0},null,{"$f":"L49","v":0},null,null,{"$f":"L50","v":0},null,null,{"$f":"L51","v":0}]
["28. SIGNATURE OF THE PRESIDING JUDGE",null,null,null,null,null,null,"DATE",null,"28a. JUDGE CODE"]
[null,null,null,{"$f":"IF(header!C15=\"\",\"\",header!C15)","v":""}]
["29. IN COURT COMP.",null,"30. OUT OF COURT COMP",null,"31. TRAVEL EXPENSES",null,null,"32. OTHER EXPENSES",null,"33. TOTAL AMT. APPR./CERT."]
[]
["34. SIGNATURE OF THE CHIEF JUDGE, COURT OF APPEALS (OR DELEGATE)",null,null,null,null,null,null,"DATE",null,"34a. JUDGE CODE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type of Person Represented:",null,null,"Representation Type:",null,null,null,"Court Order:",null,null,null,"Payment Category:",null,null,"Disposition:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adult Defendant",null,null,"AF  Appeal of civil asset forfeiture",null,null,null,"O - Appointing Counsel",null,null,null,"Felony",null,null,"Acquitted by Court"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Juvenile Defendant",null,null,"AP  Appeal from magistrate's decision",null,null,null,"F - Subs for Federal Defender",null,null,null,"Misdemeanor",null,null,"Acquitted by Jury"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appellant",null,null,"BP  Bail presentment",null,null,null,"P - Subs for Panel Attorney",null,null,null,"Appeal",null,null,"Affirmed in Part/Reversed in Part"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appellee",null,null,"CA  Other types of appeals",null,null,null,"C - Co-Counsel",null,null,null,"Petty Offense",null,null,"Affirmed in Part/Reversed in Part"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other",null,null,"CC  Criminal case",null,null,null,"R - Subs for Retained Attorney",null,null,null,"Other",null,null,"Affirmed on Appeal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CF  Civil asset forfeiture",null,null,null,"Y - Standby Counsel",null,null,null,null,null,null,"Convicted/Court Trial"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CH  Mental competency hearings",null,null,null,null,null,null,null,null,null,null,"Convicted/Final plea guilty"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CK  Crack retroactive amendment",null,null,null,null,null,null,null,null,null,null,"Convicted/Final plea nolo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EW  Extraordinary writs",null,null,null,null,null,null,null,null,null,null,"Convicted/Jury Trial"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EX   Extradition cases (foreign)",null,null,null,null,null,null,null,null,null,null,"Dismissed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HC  Habeas corpus, non-capital",null,null,null,null,null,null,null,null,null,null,"Dismissed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MA  Motion attacking a sentence",null,null,null,null,null,null,null,null,null,null,"Dismissed on Appeal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MC Motion to correct/reduce sentence",null,null,null,null,null,null,null,null,null,null,"Guilty/insane/court trial"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NT  New trial",null,null,null,null,null,null,null,null,null,null,"Guilty/insane/jury trial"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OT  Other types (line-ups, consults, transfers)",null,null,null,null,null,null,null,null,null,null,"Mistrial"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PA  Parole revocation",null,null,null,null,null,null,null,null,null,null,"Not guilty/insane/court trial"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PR  Probation revocation",null,null,null,null,null,null,null,null,null,null,"Not guilty/insane/jury trial"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PT  Pretrial diversion",null,null,null,null,null,null,null,null,null,null,"Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SR Supervised release hearing",null,null,null,null,null,null,null,null,null,null,"Probation Restored"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TD  Appeal of a trial disposition",null,null,null,null,null,null,null,null,null,null,"Probation Revoked"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WI  Material witness",null,null,null,null,null,null,null,null,null,null,"Probation Revoked"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WW  Witnesses",null,null,null,null,null,null,null,null,null,null,"Remanded"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reversed in Part/Affirmed in part"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reversed on Appeal"]

{"sheet":"cumulative","index":7,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["CUMULATIVE TOTALS"]
["Start Date","End Date","Interim Payment Number","Service Comp. Requested","Travel Expenses Requested","Other Expenses Requested","Total Requested","Court Adjustments","Total Paid","Cumulative Total"]

{"sheet":"cja26","index":8,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,5,36,9],[36,11,36,12],[14,12,14,13],[7,2,7,4],[26,2,26,13],[27,9,27,11],[24,2,24,13],[35,1,35,13],[34,1,34,13],[33,0,33,1],[33,2,33,13],[22,1,22,13],[24,0,24,1],[16,10,16,11],[7,7,7,11],[8,8,8,11],[31,0,31,1],[31,2,31,13],[26,0,29,1],[21,0,21,1],[11,4,12,13],[32,1,32,13],[17,2,17,13],[17,0,17,1],[30,1,30,13],[4,1,4,2],[5,10,5,12],[4,3,4,13],[5,1,5,2],[20,1,20,13],[21,2,21,13],[28,6,28,7],[27,6,27,7],[27,2,27,5],[28,10,28,11],[25,1,25,13],[28,3,28,5],[1,1,1,13],[2,1,2,13],[3,1,3,2],[3,3,3,5],[5,5,5,8],[5,3,5,4],[6,0,6,1],[9,3,9,4],[11,0,11,1],[19,2,19,13],[6,11,6,12],[6,5,6,8],[18,1,18,13],[19,0,19,1],[11,2,11,3],[15,12,15,13]]}
[null,"CJA 26 (Rev. 10/00)"]
[null,"SUPPLEMENTAL INFORMATION STATEMENT FOR A COMPENSATION CLAIM IN EXCESS OF THE STATUTORY CASE COMPENSATION MAXIMUM:  DISTRICT COURT"]
[null,"THIS FORM PROVIDES INFORMATION TO SUPPORT COUNSEL'S CLAIM THAT THE REPRESENTATION GIVEN WAS IN AN EXTENDED OR COMPLEX CASE, AND THAT THE EXCESS PAYMENT IS NECESSARY TO PROVIDE FAIR COMPENSATION.  PARAGRAPH 2.22B(3) OF THE GUIDELINES FOR THE ADMINISTRATION OF THE CRIMINAL JUSTICE ACT, VOLUME VII, GUIDE TO JUDICIARY POLICIES AND PROCEDURES, DEFINES THE TERMS \"EXTENDED\" AND \"COMPLEX,\" AND SUGGESTS CRITERIA FOR DETERMINING \"FAIR COMPENSATION.\"  THIS FORMS SERVES AS COUNSEL'S MEMORANDUM REQUIRED BY PARAGRAPH 2.22C(2) OF THOSE GUIDELINES, AND DOES NOT REPLACE ANY OTHER DOCUMENTATION REQUIRED TO SUPPORT THE PAYMENT REQUEST. "]
[null,"ATTORNEY NAME:",null,{"$f":"IF(header!C18=\"\",\"\",header!C18)","v":""}]
[null,"CASE NAME:",null,{"$f":"IF(header!C11=\"\",\"\",header!C11)","v":""}]
[null,"DOCKET NUMBER:",null,{"$f":"IF(header!C9=\"\",\"\",header!C9)","v":""},null,null,null,null,null,null,"VOUCHER NUMBER:"]
[1,null,"PERIOD OF APPOINTMENT (DATES):",null,null,null,null,null,null,null,"TO"]
[null,null,"TOTAL NUMBER OF IN-COURT HOURS:  ",null,null,null,null,"SPECIFYING:  PRETRIAL HEARINGS:  "]
[null,null,null,null,"TRIAL:  ",null,null,null,"SENTENCING HEARINGS:  "]
[null,null,null,"ALL OTHER IN-COURT:  ",null,null,"  TOTAL NUMBER OF OUT-OF-COURT HOURS:  "]
[]
[2,2,"OFFENSES CHARGED:"]
[]
[null,null,"NUMBER OF COUNTS CHARGED:",null,null,null,null,null,null,"NUMBER OF CO-DEFENDANTS:"]
[null,null,"OTHER PENDING CASES (DOCKET NUMBERS) OF DEFENDANT DURING REPRESENTATION:"]
[null,null,"IF APPLICABLE, SENTENCING GUIDELINE RANGE FOUND BY THE COURT FOR SENTENCING:"]
[null,null,"WAS A MANDATORY MINIMUM FOUND OR AT ISSUE AT SENTENCING?"]
[3,null,"DESCRIBE DISCOVERY MATERIALS (NATURE AND VOLUME) AND/OR DISCOVERY PRACTICES WHICH ARE A NOTEWORTHY FACTOR IN THE NUMBER OF HOURS CLAIMED:"]
[]
[4,null,"LIST AND DESCRIBE MOTIONS, LEGAL MEMORANDA, JURY INSTRUCTIONS, AND SENTENCING DOCUMENTS, OR LEGAL RESEARCH NOT RESULTING IN SUCH, WHICH ARE A NOTEWORTHY FACTOR IN THE NUMBER OF HOURS CLAIMED AND WHICH WERE DRAFTED ORIGINALLY FOR THIS CASE (DO NOT INCLUDE STANDARDIZED MOTIONS, ETC., UNLESS CONTENT WAS MODIFIED SIGNIFICANTLY):"]
[]
[5,null,"SUMMARIZE INVESTIGATION AND CASE PREPARATION (E.G., NUMBER AND ACCESSIBILITY OF WITNESSES INTERVIEWED, RECORD COLLECTION, DOCUMENT ORGANIZATION) WHICH ARE A NOTEWORTHY FACTOR IN THE NUMBER OF HOURS CLAIMED:"]
[]
[null,"CJA 26 (Rev. 10/00) "]
[6,null,"EXPLAIN, IF NOTEWORTHY, IMPACT ON THE NUMBER OF HOURS CLAIMED OF INVESTIGATIVE, EXPERT, OR OTHER SERVICES USED (CJA 21 VOUCHER)"]
[]
[7,null,"CHECK WHETHER ANY OF THE FOLLOWING CLIENT CONSIDERATIONS ARE A NOTEWORTHY FACTOR IN THE NUMBER OF HOURS CLAIMED AND EXPLAIN EACH:"]
[null,null,"COMMUNICATION WITH CLIENT/FAMILY:  ",null,null,null,null,null,null,"  LANGUAGE DIFFERENCE:  "]
[null,null,null,"  ACCESSIBILITY OF CLIENT:  ",null,null,null,null,null,null,"OTHER:  "]
[]
[]
[8,null,"EXPLAIN ANY EXPENSE (ITEMS 17 AND 18 OF THE CJA 20 VOUCHER) GREATER THAN $500:"]
[]
[9,null,"EXPLAIN ANY OTHER NOTEWORTHY CIRCUMSTANCES REGARDING THE CASE AND THE REPRESENTATION PROVIDED TO SUPPORT THIS COMPENSATION REQUEST:"]
[null,"INCLUDE, IF APPLICABLE:  (A) NEGOTIATIONS WITH U.S. ATTORNEY'S OFFICE OR LAW ENFORCEMENT AGENCY; (B) COMPLEXITY OR NOVELTY OF LEGAL ISSUES AND FACTUAL COMPLEXITY; (C) RESPONSIBILITIES INVOLVED MEASURED BY THE MAGNITUDE AND IMPORTANCE OF THE CASE; (D) MANNER IN WHICH DUTIES WERE PERFORMED AND KNOWLEDGE, SKILL, EFFICIENCY, PROFESSIONALISM, AND JUDGMENT REQUIRED OF AND USED BY COUNSEL; (E) NATURE OF COUNSEL'S PRACTICE AND HARDSHIP OR INJURY RESULTING FROM THE REPRESENTATION; AND (F) ANY EXTRAORDINARY PRESSURE OF TIME OR OTHER FACTORS UNDER WHICH SERVICES WERE RENDERED."]
[]
[null,"SIGNATURE OF APPOINTED ATTORNEY:",null,null,null,null,null,null,null,null,"DATE:"]

{"sheet":"court use","index":9,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"IMPORTANT!",null,"REMEMBER to press the \"Protect all worksheets\" button"]
[null,null,null,"before returning a file to the attorney."]
[]
[]
[]
[null,null,null,"To hide court use page = control + x"]
[]
[null,null,null,"To reveal court use page = control + y"]

{"sheet":"Sheet1","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}