The Excel spreadsheet is compatible with many versions of Microsoft Excel. It is recommended that you use a version that is newer than version 5. The Open Office software provided by Sun Systems will not be supported by U.S. District Court.
Please download the CJA 20 Hourly Spreadsheet Setup and Instruction Guide and follow the steps for changing your security settings. The CJA-20 Hourly Spreadsheet has embedded macros that assist with print settings (i.e., it prevents the printing of empty lines and ensures that any line that has data will be included in the printed document) and sorting entries by date. (Note: Macros do not apply to MAC users, but security settings should be set to accept them, to enable the checkboxes on the Voucher tab). The instructions will provide step-by-step directions to ensure settings are correct on the PC being used for voucher preparation.
Yes. Data sorting is possible with the CJA 20 Hourly Spreadsheet. There is a gray button ON the spreadsheet around cell A1that reads Sort by Date. When this button is clicked, both the Services and Expenses entries will be sorted by date in ascending order (the Sort by Date button does not apply to MAC users).
Because this is a DATE driven spreadsheet, entries for time spent on tasks must be input on the same line as the date. This problem commonly occurs when several lines are used to describe work performed. The date ends up on the first line and the time claimed ends up on the last line. Excel formulates dollar amounts based on the rate in effect on the date entered. Please check your work, and be sure the dates and times claimed are accurate and that every line has a date.
No. Deleting rows is a locked function. Information can be removed only by highlighting and clearing the contents of cells in a particular row to get rid of the information or it can be pasted into another range of cells within the worksheet. However, if you inserted an empty row by mistake and would like to delete it, you can UNDO the action as an option of deleting the inserted row.
No. Text wrapping is set only for the description field on both the Services and the Expenses worksheets.
In order to protect the worksheet formulas, it was necessary to lock the CJA 20 Hourly Spreadsheet. Therefore, spell check is no longer an available option.
Yes. All worksheets must accompany a completed CJA-20 voucher. The CJA 20 Hourly Spreadsheet has an included tab that is the ACTUAL CJA-20 voucher form and the information entered on the Services, Expenses and VoucherRet2 tabs automatically transfers to the CJA-20 Voucher tab. The second tab (VoucherRet2) is used only for the older pay rates. The Print /PDF Setup macro then prepares each worksheet for print preview and printing (the Print / PDF Setup button does not apply to MAC users).
Most likely, you have neglected to click on Enable Macros when launching the spreadsheet. Close the spreadsheet and re-open to get the message again and choose Enable Macros. If you do not get this message, refer to the CJA-20 Hourly Spreadsheet Setup and Instruction Guide. If you have Excel 2007, refer to the CJA-20 Hourly Spreadsheet Setup and Instruction Guide, Addendum (page 12).
We encourage Panel Attorneys and staff to periodically visit the Court's website and retrieve the most current version of the automated spreadsheet. New versions are posted and named with the current date of their posting. The current version is CJA-20 Hourly Spreadsheet 10-17-2008. There is also a MAC version CJA-20 Hourly Spreadsheet 10-17-2008 - MAC. This version date is also found in the spreadsheet on the footer of the Services and Expenses tabs.
There is a known PDF issue using Microsoft Excel 2007. Microsoft is aware of the issue and have published an add-in that may be downloaded from Microsoft's website. Once you have downloaded the add-in, go back into Microsoft Excel 2007 and open the CJA-20 Hourly Spreadsheet. Click on the Print/PDF Setup button to set the formatting (the Print / PDF Setup button does not apply to MAC users), wait for the Print window to display and then click on Cancel. Click on the Office button and go down to Save As... (DO NOT CLICK). Save As options will display on the right panel, click on the PDF or XPS option. Next, a Publish as PDF or XPS window will display with the spreadsheet already named. Click the Save in down arrow to store the PDF file in the desired directory. Below the Save as Type box, there will be a checkbox labeled Open file after publishing (this enables the file to launch once it is saved for you to see it). Please make sure that box is checked (only needs to be checked once and then will stay checked). Next, click on the Options button. Under the Publish what section, click Entire Workbook (this needs to be done every time). Click OK. Click Publish. The PDF file will automatically launch for viewing.
No. The CJA 20 Hourly Spreadsheet includes the CJA 20 voucher form and automatically enters data into the CJA-20 voucher as it is typed on the Services and Expenses tabs of the spreadsheet. Only the Court-developed Excel version of the CJA 20 Hourly Spreadsheet is acceptable.
CJA20 vouchers and all documentation can either be emailed to OHNDdb_CJA@ohnd.uscourts.gov or mailed to the Cleveland Court House at 801 W. Superior Ave, Attn: CJA, Cleveland, OH 44113.
Please call the Leeann Weber at (216) 357-7025 or Deborah Barath at (216)357-7023.