Paul Software Home
Rollever Text


Hasbro Interactive's Vice President of Product Development needed to keep track of several vendors (game developers) who were building new interactive CD-ROM games. He needed a way to easily manage and quickly summarize information about vendors responsible for one or more projects by delivery date, estimated product revenue, development cost, platform, and other criteria.


Since the VP of Product Development wanted to manage the data and needed to have it available 'off-line' during business trips, we developed a schema to organize the raw data in one worksheet of an Excel 97 spreadsheet, and a series of Pivot Tables in separate worksheets that provided detailed and summary ('roll up') views of products and vendors.


Microsoft Access 97

Microsoft Excel 97 Pivot Tables and VBA

Return to Main Client List
Forward to Next Case Study


Services | About Us | Clients | Products | News | Contact Us | Home

Copyright © 2000, 2003 Paul Software