• Skip to main content
  • Skip to header right navigation
  • Skip to site footer
Foster Solutions (FSI)

Foster Solutions (FSI)

The Solution is in the Process

  • Home
  • What We Do
    • Websites / Hosting
      • Author’s Sites
      • Boutique Websites
      • Corporate Websites
      • Open Source CMS
      • Quick and Dirty Websites
    • SQL Databases / VBA Automation
    • GIS / Market Research
    • Government/Planning
  • Case Studies
    • Databases/Automation Case Studies
    • GIS/Market Research Case Studies
    • Local Government Case Studies
    • FSI – crosspollination – examples
  • Clients
  • Articles
  • Contact Us

Automating PowerPoint

Populating data-rich PowerPoint presentations (Phoenix Healthcare).

Phoenix Healthcare conducts an international tracking study (now in its sixth year) for a major pharmaceutical client. The study analyzes customer satisfaction of a drug treatment. After the analysis is complete, the deliverable is a 200 slide PowerPoint file for each of 7 countries, full of graphs and tables.

The analyst has the overwhelming job of populating the 300 graphs, 70 tables and hundreds of variables embedded in the text for each PowerPoint file. Not only does this take a huge amount of time but is prone to human error.

The challenge was to find a process that was flexible enough to handle the changing environment as graphs/tables were modified at the client’s request. The automation process was complicated, since of all the Microsoft Office applications, VBA is rarely used to automate PowerPoint.

FSI built an innovative system using Excel and PowerPoint to manage the automatic population of the thousands of variables in each of the seven reports. It was the best solution for this challenging situation.

Ready to get started?

Client Survey

Please take this survey if you are interested in a new or modified website. We will assess and get back with you as soon as possible.

Finding Solutions

We work with you to make things faster, easier and better.

Sites

  • Home
  • Blog
  • About
  • Features
  • Contact
  • Marketing

Features

  • Home
  • Blog
  • About
  • Features
  • Contact
  • Marketing

Support

  • Home
  • Blog
  • About
  • Features
  • Contact
  • Marketing

Copyright © 2021 · Foster Solutions (FSI) · All Rights Reserved

Back to top