Types of worksheets in Integrated Operational Planning:
Report Worksheets—Provide access to Integrated Operational Planning class modules that call Integrated Operational Planning queries. To use a report worksheet, create a query that retrieves and filters data from the Integrated Operational Planning database. You then use design tools and the Visual Basic Editor in Excel to create the report layout and specify the query to use.
Data Collection Worksheets—Report worksheets that allow data providers to update forecast data. These worksheets reference a pre-existing load specification that defines how updated forecast data is staged and loaded into the Integrated Operational Planning database. The worksheets include information used to filter and display forecast data for individual data providers.
Planning Worksheets—Created by customizing XML worksheet template files outside Integrated Operational Planning.