Copying a Dataset-Budget

In

Budgeting

Copying datasets/budgets can save time and/or preserve data for reference purposes. You can copy one full dataset or you can add a second dataset and copy specific periods from one dataset and different periods from another dataset. For example, you can copy periods 1-9 from the first dataset and periods 10-12 from the second dataset. If the end period for dataset 1 overlaps with the start period for dataset 2, the overlapping periods will be summed. In essence, you are merging two datasets into one new dataset.

To create a new budget by copying existing datasets:

1. In the toolbar, click the Main Menu icon ( 

   

    ).
2. From the drop-down list, under the Financial section, select Budgeting.
   The Budgeting screen appears in a separate tab.
   For more information, see Budgeting.
3. Click the Utilities button ( 

   

    ).
4. From the drop-down list, select Copy Dataset.
   The Copy Dataset dialog box appears.
5. In the To Dataset section, complete the following steps to define the dataset to which information will be copied:
   1. From the Year drop-down list, select the year to which you will copy datasets. 
   2. From the Type drop-down list, select the type of dataset that information will be copied to.
6. In the From Dataset section, complete the following steps to define the dataset from which information will be copied:
   1. Click the First Period cell and select a period from the drop-down list.
   2. Click the Last Period cell and select a period from the drop-down list.
   3. Click the Year cell and select a year from the drop-down list.
   4. Click the Dataset cell and select a dataset from the drop-down list.
7. Optionally, to add another dataset from which to copy, complete the following steps:
   1. Click Add Dataset.
      A new row appears.
   2. Repeat steps 6a to 6d. 
8. Optionally, to delete a dataset, click to highlight the row and then click Delete Dataset.
9. Select the appropriate check boxes if you want to exclude KBIs, hours, and/or rate adjustments in the new dataset.

10. Click OK.
    The dialog box closes, and the dataset is created. It is named using the year and type that you selected in the To Dataset section.

     

Related topics:

• Budgets
• Configuring-Viewing Budgets
• Copying a Database
• EPEP
• Flex Budgets & Actuals
• Forecasting KBIs
• New Budgets
• Opening Budgets
• Rebuilding the Cost Structure
• Re-Forecasting
• User-Defined Types