The Excel ComponentThe Excel Component-Screen Shots--Screen Shots-

Excel Menu Showing All FunctionalityExcel Menu Showing All Functionality

You Can Select a Measure to Chart By You Can Select a Measure to Chart By Pointing & Clicking Competitive ChartsPointing & Clicking Competitive Charts

Resulting Chart That Was Produces Showing Target’s Resulting Chart That Was Produces Showing Target’s Performance Within Its Competitive SetPerformance Within Its Competitive Set

Note: Function Buttons Are Located Below & to Side of ChartNote: Function Buttons Are Located Below & to Side of Chart

Function ButtonsFunction Buttons

• Save Graph Button – Saves the chart in a specific directory. The file name includes the source, date, time and description of the chart

• Print Graph Button – Prints the chart horizontally• Increase Font Size Button – Increases the font size of data and category

labels• Decrease Font Size Button – Decreases the font size of data and category labels

• Increase Title Size Button – Increases the font size of chart title• Decrease Title Size Button – Decreases the font size of chart title• Use Old Size – Uses the original font size for chart title• Edit Chart Title Button – Allows you edit each line of the chart’s title• Use New Title Button – Replaces the original chart title with the edited chart

title• Use Old Title Button – Restores the original chart title• Unprotect Charts Button – Removes the protection and let’s you edit chart • Protect Charts Button – Restores the chart protection

Function Buttons Cont.Function Buttons Cont.

• Abbreviate Names Button – This option abbreviates the publication name. It could be extended to abbreviate other measures if you let the vendor know what you want abbreviated, and what abbreviations you want to use.

• Full Names Button – This option restores the original publication names.

• Move Title Left – This option moves the chart title to the left

• Move Title Right – This options moves the chart title to the right

• Graph Menu Button – This option displays the graph menu for the current table

• Depending on the table, there are buttons that allow you to go to following selected tables:– Display Table– Sorted “Display Table– Top List “Measure Table– Strength Table

You Can Also Use a Menu to Create a ChartYou Can Also Use a Menu to Create a ChartNote: The Chart Produced Will Be Identical to the Prior Chart Except the Target’s

Performance Will Be Charted With Respect to All Brands in the Analysis

Chart Produced From Prior Menu SelectionsChart Produced From Prior Menu SelectionsThis Chart Can Be Transformed into a Vertical Bar Chart With A Click of a ButtonThis Chart Can Be Transformed into a Vertical Bar Chart With A Click of a Button

Resulting Vertical Bar Chart Produced By Clicking Resulting Vertical Bar Chart Produced By Clicking Vertical Bar Chart Button on Previous PageVertical Bar Chart Button on Previous Page

You Can Filter the Input Display Table You Can Filter the Input Display Table Based on up to 10 User-Defined CriteriaBased on up to 10 User-Defined Criteria

Resulting “Filtered” TableResulting “Filtered” TableNote: Filters Used to Create Table Are Shown in Row 6

Once the Filtered Table is Created The Once the Filtered Table is Created The User Can Select the Metric to ChartUser Can Select the Metric to Chart

Note: IDEAS Will Generate A Chart For Each Measure Meeting Specified Criteria And Save it in Dedicated DirectoryNote: IDEAS Will Generate A Chart For Each Measure Meeting Specified Criteria And Save it in Dedicated Directory

An Example of a “Filtered” ChartAn Example of a “Filtered” ChartNote: Up to 300 Filtered Charts Can Be Created in 5 MinutesNote: Up to 300 Filtered Charts Can Be Created in 5 Minutes

The Sort Function The Sort Function Note: Display Table Can be Simultaneously Sorted on 6 Measures/Columns

You Can Ask IDEAS To Show You the Top 10 Measures You Can Ask IDEAS To Show You the Top 10 Measures for Each of up to 30 Categories for 8 Media Metricsfor Each of up to 30 Categories for 8 Media Metrics

The Table That Was Created When Top 10 The Table That Was Created When Top 10 Demographic Index Measures Was SelectedDemographic Index Measures Was Selected

Once a Top 10 Table is Created, The Data Can Be Charted with a Once a Top 10 Table is Created, The Data Can Be Charted with a Click of the “Graph Top 10” Button on the Previous PageClick of the “Graph Top 10” Button on the Previous Page

By Clicking the “Read Table” Button, IDEAS By Clicking the “Read Table” Button, IDEAS Will Actually Talk to You And Explain How To Will Actually Talk to You And Explain How To

Read & Interpret the DataRead & Interpret the Data

You Can Also Ask IDEAS to Show You The Top 100 You Can Also Ask IDEAS to Show You The Top 100 Measures Across All Categories for Each of 8 Media MetricsMeasures Across All Categories for Each of 8 Media Metrics

The Resulting Chart That Was Created When The Resulting Chart That Was Created When Top 100 Index Measures Was SelectedTop 100 Index Measures Was Selected

You Can Ask IDEAS to Create A Table And Create You Can Ask IDEAS to Create A Table And Create Charts Showing The Target’s Top 100 Strengths & Top Charts Showing The Target’s Top 100 Strengths & Top

100 Weaknesses Vs. Any Given Competitor100 Weaknesses Vs. Any Given Competitor

Table Produced Showing Target’s Top 100 Table Produced Showing Target’s Top 100 Strengths Vs. Brand 3Strengths Vs. Brand 3

Note: Strengths & Weaknesses Are Based on Compositional DifferencesNote: Strengths & Weaknesses Are Based on Compositional Differences

IDEAS Let You Chart the Top 100 Strengths & Top 100 IDEAS Let You Chart the Top 100 Strengths & Top 100 Weaknesses in Groups of 10 By The Click of the ButtonWeaknesses in Groups of 10 By The Click of the Button

With the Click of A Button You Can Determine With the Click of A Button You Can Determine Share, Loyalty, & Other Key Measures For All Share, Loyalty, & Other Key Measures For All

Brands in The AnalysisBrands in The Analysis

Once The Prior Table is Created You Can Plot the Once The Prior Table is Created You Can Plot the Top 10 Brands For Each Column in the TableTop 10 Brands For Each Column in the Table

Chart Produced By Selecting Top 10 Brands in Chart Produced By Selecting Top 10 Brands in Analysis Based on LoyaltyAnalysis Based on Loyalty

With the Click of A Button You Can Determine With the Click of A Button You Can Determine Share, Loyalty, & Other Key Measures For All Share, Loyalty, & Other Key Measures For All

Brands in The Target’s Competitive SetBrands in The Target’s Competitive Set

If You Do Not Understand a Marketing or Statistical Term Just Ask Ideas And The Program

Will Talk to You And Explain

By Using This Menu You Can Eliminate One or More By Using This Menu You Can Eliminate One or More Charts From All Subsequent Charts That Are ProducedCharts From All Subsequent Charts That Are Produced

Chart Produced Prior to Eliminating Chart Produced Prior to Eliminating Brand 8 Using Prior MenuBrand 8 Using Prior Menu

Chart Produced After Eliminating Chart Produced After Eliminating Brand 8 Using Prior MenuBrand 8 Using Prior Menu