AutoCollect - Creating User Defined DELTA Rowsets › Create a Sample Empty Excel Sheet

Create a Sample Empty Excel Sheet

To make the import as easy as possible, you can create a blank master for AutoCollect spreadsheets.

To create a sample empty Excel spreadsheet for MS-EXCEL 2003

1. Go to Excel and open a new spreadsheet.
2. Right-click the tab SHEET1 and rename this tab to BVM.
3. Right-click the tab SHEET2 and rename this tab to BVD.
4. Right-click the tab SHEET3 and rename this tab to MFS.
5. Click INSERT and choose WORKSHEET

   A new worksheet table is created.

6. Right-click the new tab and rename this tab to MFA.

Repeat as needed for each of the DSV output datasets you want to import from the mainframe.

To create a sample empty Excel spreadsheet for MS-EXCEL 2007

1. Go to Excel and open a new spreadsheet.
2. Right-click the tab SHEET1 and rename this tab to BVM.
3. Right-click the tab SHEET2 and rename this tab to BVD.
4. Right-click the tab SHEET3 and rename this tab to MFS.
5. Place your cursor on one of the worksheet tabs and right-click.
6. Click INSERT and choose WORKSHEET

   A new worksheet tab is created.

7. Right-click the new tab and rename this tab to MFA.

Repeat as needed for each of the DSV output datasets you want to import from the mainframe.

Save this Excel spreadsheet as your "empty" master.