Spreadsheet: 14e3cca6-6b04-4d98-894a-cd4e66e2ac55
Sheet: Instruction Sheet

Instructions for § 1353 Travel Report
The United States Office of Government Ethics (OGE) is required by 31 U.S.C. § 1353 to collect and make publicly available the information submitted in the semiannual  § 1353 travel reports.  OGE's acceptance of this information does not constitute a determination that the information is adequate or concurrence with the submitting agency’s conflict of interest analysis.  (See 41 CFR §304-6.9).
Starting with the October 1, 2010-March 31, 2011 reporting period, OGE will only accept § 1353 Travel Reports that are submitted electronically in this OGE-approved electronic form (OGE Form-1353) or on the SF-326.   To the extent possible, agencies are strongly encouraged to submit their semiannual reports using the OGE Form-1353.  All submissions must be made via email to [EMAIL] in XLS, XLSX, or PDF format.
If your agency has not accepted payments under 31 U.S.C. § 1353 for the applicable reporting period, your agency must still submit a negative report.  Negative reports are indicated by an electronic submission of the OGE Form-1353 (in excel format) or the SF-326 (in PDF Format).
Completing the OGE Form-1353
Saving the [NAME]
 | Name the [NAME] using your agency acronym and the reporting period using this convention:  1353Report_[AgencyAcronym]_[Reporting Period].xls, for example 1353Report_OGE_OctMarch2011.xls.
 | - | Select the Microsoft Button and choose "Save As" Excel Workbook from the menu. When typing the file name, use the naming convention: 1353Report_[AgencyAcroynm]_[Reporting Period].xls
 | - | Use OctMarch[Year] for the October 1- March 31st reporting cycle and AprSept[Year] for the April 1-September 30th reporting cycle.
 | - | Note that your agency acronym can be found on the worksheet titled "Agency Acronym" (tab located at the bottom of the workbook).
Preparing Blank Report Forms for Each Sub-Agency (if applicable)
 | For each individual sub-agency report, copy the "RENAME BLANK FORM" spreadsheet (tab located at the bottom of the workbook) and rename it to describe the sub-agency.
 | - | Ensure use of standardized acronyms where applicable.
 | - | Spreadsheets can easily be copied by right-clicking on the sheet tab for the sheet you wish to copy.  After you right click, select "Move or Copy", which will open a dialogue box.  When the dialogue box appears, click the "Create a Copy" checkbox at the bottom of the dialogue box.  To determine the placement of the new sheet within your workbook, left click the name of an existing sheet in the "Before Sheet" area; your new sheet will be placed before the sheet selected.  Select "OK".  A new sheet will appear (e.g. "RENAME BLANK FORM (2)") that you can rename.
 | - | To rename the spreadsheet tab, simply double-click on the spreadsheet tab name and type the new name. Note that each tab must have a unique name.
Completing the General Information
 | Fill in the applicable information.  Note that information to be completed by the agency always appears in white-colored cells.  Information located in the colored cells should not be manipulated. The worksheet has been protected so that you can tab between the fillable cells.
 | Renaming the Spreadsheet Tabs
 | - | Rename the spreadsheet tab with your agency name, using standardized acronyms where applicable.
 | - | To rename the spreadsheet tab, simply double-click on the spreadsheet tab name and type the new name. Note that each tab must have a unique name.
 | Filling in Page, Of Pages and Year
 | - | Fill in the white-colored cells found below Page, Of Pages, and Year.
 | - | Page refers to the numerical position of the current sheet relative to the other sheets in the workbook and Of Pages refer to the total number of report pages in the entire workbook.
 |  | - | For example, if the Department of Example 1353 Travel Report had submissions from its only two sub-agencies: Department ABC and [NAME], there would be 2 total reports (2 worksheets).  On the Department ABC worksheet/report, the agency would enter 1 for Page-- referring to the Department ABC's position in the [NAME] and 2 for Of Pages-- referring to the total number of worksheets/reports.  The Department [NAME] report would read 2 for Page-- referring to its order as the second report-- and 2 for Of Pages-- referring to the total number of sheets in the workbook.
 | Filling in Agency Name, Sub-Component Name, and Contact Information
 | - | In the fillable cells below the Title, replace [Replace with Reporting Agency Name], [Replace with Sub-Agency Name], [Replace with Agency Contact Name], and [Replace with Agency Contact Email] with the appropriate information. If there is no sub-agency, then delete [Sub-Agency] from that cell.
 | - | Once the identifying information is completed correctly, the report title should automatically read correctly at the top of the spreadsheet.
 | Indicating Reporting Period
 | - | Indicate the reporting period by placing an X in the white cell to left of the correct reporting period.
Filling in Travel Specific Information
 | Indicating a Negative Report
 | - | If there is no information to report for this reporting period, indicate the negative report by placing an X in the white cell to the left of negative report.
 | Indicating 1353 Travel
 | - | Fill in the applicable information in the report in the same method as illustrated by the example. You must enter the information in the cell below the description of the type of information.  For example, type "[NAME]" in the cell below "Name."
Submitting the Report to OGE
 | Ensure the file is saved using the naming convention discussed in the instruction for saving the workbook, and email the excel file as an attachment to [EMAIL].
Printing Reports for Internal Agency Use and Record Keeping
While reports must be submitted electronically, your agency may find it useful to print its 1353 Travel Reports for record-keeping purposes. The following instructions provide guidance for printing in Excel 2003 and Excel 2007.
In Excel 2007
- | Highlight the portion of the report on each spreadsheet you would like to print.  Do this by left-clicking with the mouse and holding the button as you drag the cursor over the cells that you wish to highlight. Release the mouse button when you are finished and the area that you selected will remain highlighted. Click on the Page Layout Tab on the Microsoft Excel Ribbon.
- | With the printing area highlighted, click the "Print Area" button, which should provide a drop-down menu including the option to "Set Print Area". Select "Set Print Area".
- | On the Page Layout Tab, locate the "Scale to Fit" option.  Use the drop-down menu to restrict the width to "1 page".
- | To verify the margins are correct on your printing job, use the Print Preview option.  Click on the Microsoft button in the upper right-hand corner and hover over Print.  Select "Print Preview" from the right-hand menu.
- | You can select Print from the Print Preview view or Print as you traditionally would.
In Excel 2003
- | Highlight the desired print area. Do this by left-clicking with the mouse and holding the button as you drag the cursor over the cells that you wish to highlight. Release the mouse button when you are finished and the area that you selected will remain highlighted.
- | Access the print properties menu. Scroll to the “File” tab on the command bar and select “Print Area.”
- | Set the print area. A submenu will open. Scroll to “Set Print Area” and left-click to set the print area. The print area will be outlined with a dashed border inside of the spreadsheet.
- | Check the print area in the preview screen. Scroll to the “File” tab on the command bar and select “Print Preview” to see how the file will look when it is printed.
- | Adjust the print area. To make any changes, just hover the mouse over a corner of the dashed border surrounding the print area. When the cursor turns to a cross-sectioned arrow, left-click and hold. Drag the print area to the desired size.