Home
Home
RSS
Rss
Change Font Size
Font
Print
Print

FAQs

 
 

IS A SPECIFIC EXCEL PROGRAM NEEDED TO USE THE CJA 20 HOURLY SPREADSHEET?

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.

WHEN ATTEMPTING TO OPEN THE DOCUMENT, I RECEIVE A MESSAGE THAT MY SECURITY SETTINGS ARE TOO HIGH. WHY?

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.

ENTRIES WERE ADDED AT THE BOTTOM OF THE WORKSHEET AND ARE OUT OF SEQUENCE. CAN I SORT THE WORKSHEET SO THAT ALL THE ENTRIES ARE IN DATE ORDER?

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).

TIME ENTERED ON THE SERVICES TAB IS NOT CALCULATING PROPERLY ON THE SUMMARY SHEET. WHY?

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.

CAN ROWS BE DELETED FROM EITHER THE SERVICES OR THE EXPENSES WORKSHEETS?

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.

IS TEXT WRAP SET FOR EVERY FIELD?

No. Text wrapping is set only for the description field on both the Services and the Expenses worksheets.

WHY IS SPELLING GRAYED OUT (UNDER THE TOOLS MENU) WHEN I TRY TO SPELL CHECK MY WORK?

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.

SINCE THE WORKSHEETS ARE AUTOMATED, IS IT STILL NECESSARY TO SUBMIT A CHA-20 VOUCHER?

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).

I AM TRYING TO CHECK THE BOXES ON THE VOUCHER, BUT NO MATTER HOW I CLICK, I CAN'T GET A CHECKMARK. WHAT AM I DOING WRONG?

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).

HOW DO I KNOW IF I AM USING THE MOST CURRENT VERSION OF THE SPREADSHEET?

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.

WHEN I CREATE A PDF FROM EXCEL 2007, WHY ARE THERE PAGES IN THE PDF FILE THAT ARE BLANK?

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.

I HAVE A COMMERCIALLY PROCURED PROGRAM THAT CALCULATES TIME. CAN I STILL USE MY PROGRAM TO FILE MY VOUCHERS?

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.

DO I SUBMIT THE VOUCHER VIA U.S. MAIL OR CAN I E-FILE IT USING ECF?

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.

WHAT DO I DO IF I DISCOVER A PROBLEM WITH A SPREADSHEET THAT THE FAQ'S HAVE NOT ADDRESSED AND THE SETUP AND INSTRUCTION GUIDE HAS NOT DESCRIBED?

Please call the Leeann Weber at (216) 357-7025 or Deborah Barath at (216)357-7023.