.. Financial Operations Departmental Financial Planning Create a Plan for Multiple Cost Objects Using a Spreadsheet Contents Overview and Uploading Tips Enter Planning Data into Spreadsheet Format Rules Save File Overview This transaction allows planning for multiple cost objects with multiple plan versions using the same spreadsheet. You can upload for more than one fiscal year (current + 5 future years), planning for an entire year or portions of a year down to a single month. Also you can plan either individual amounts per fiscal period or having amounts distribute equally across all fiscal periods, or both. Uploading Tips Users need to include EB and OH in the worksheet since SAP will not calculate these charges automatically. Users can’t change plan versions 0 (Institute Budget), 1 (Recurring Budget), 2 (Non-recurring Budget), 3 (Carry Forward Budget), or AF (Annual Forecast Budget). Upload worksheets contains whole dollars only, no cents. Values from the spreadsheet are the final value in SAP and will overwrite any existing values in the plan version. Upload values are not incremental value to be added/subtracted from the existing value. The spreadsheet upload will not check the cost collector effective date & expiration date. Processing immediately method is recommended unless the users try to upload more than 1000 lines. top Enter Planning Data into Spreadsheet Type your data into a spreadsheet file using an application such as Excel. Follow the example below. See Format Rules for a description of what to enter. top Format Rules Use the following rules when entering the data for your upload file: Col Description Rules A Cost Object (7 digits) Enter the cost center, internal order, or WBS element. You can enter multiple cost objects. B Cost Element (6 digits) Type in the cost element number. C Fiscal Year (4 digits) Mulitple years: current year + up to 5 years in the future. D Plan Version The version for which you wish to plan and have authorization to update the plan. Note: Versions 0 (zero), 1 (one), 2 (two), 3 (three) or AF are updated by the Budget Office only. E First Planning Period (1-12) First fiscal period (month) to be budgeted. Planning periods begin with 1 (July) and end with 12 (June). Users may plan anywhere from a single month to an entire year. F Last Planning Period (1-12) Last fiscal period (month) to be budgeted. Same rule as first planning period. G Overall/Annual Amount The amount in this column will be evenly distributed from the first to last planning period during the plan year. No cents will be planned, whole dollars only. If it is blank, you can plan individual amount per fiscal period. Note: Positive or negative values are all allowed H - S Individual Period Amount Enter the plan amount for each G/L account. No dollar signs ($) and commas. No cents will be planned, whole dollars only. Note: Data can be entered either in the Overall columns or the Individual Period Amount columns. If data is entered in both, only the Overall value will be updated in SAP.                   top Save File Save your file as type: TEXT (Tab-Delimited Format). Note Be sure to close out of the spreadsheet file before uploading. top Upload your File After you complete the spreadsheet, upload the file to SAP. >>Go to Upload Your File top   Copyright 2001 © Massachusetts Institute of Technology SAP for MIT Documentation on the Web Valid From: 03/15/2001