Automate Powerpoint Generation

  • Status: Closed
  • Prize: $10
  • Entries Received: 3
  • Winner: Banze94

Contest Brief

Hello Everyone,

The goal of this contest is to build a tool that will generate a slide with three graphs that come from two different workbooks. The presentation must have one slide per "Bucket" (China, US, EM ASIA, etc) and the three graphs for each slide must be consistent with the Bucket of the slide. The two workbooks contain a data base, which is then used to generate a pivot table, which then is used to generate a graph or a table.

In the file you will find an excel file of how the the two graphs of the upper section of the slide were manually generated. In the other excel file you will find how the lower table of the slide is generated. In Orange I highlighted the actual input data, all the others sheets of both workbooks are just an illustration of how the process is currently done using Bucket EM ASIA as an example.

The goal is by using the information on orange tabs of each workbook, generate one slide per Bucketucket in a single powerpoint.

Thank you!

Cristobal

Recommended Skills

Employer Feedback

“Very good experience, hire him!”

Profile image cbucher, United States.

Top entries from this contest

View More Entries

Public Clarification Board

  • postairech
    postairech
    • 5 years ago

    Hello, so, basically you want to combine excel with power point? If is this, send me the tables and i'll make it work!

    • 5 years ago
    1. cbucher
      Contest Holder
      • 5 years ago

      Thank you for your interest in the contest, that is exactly what I wanted. Nowadays is a manual process, where I generate one pivot table per graph, create the graph, paste it as an Excel Object (As a link because otherwise the ppt gets too large in MBs). I am looking a way of automatizing the process of generating the powerpoint. Could you submit an entry so we can start a private chat? Thank you!

      • 5 years ago
    2. postairech
      postairech
      • 5 years ago

      Ok, let me see those files and i'll send you something tonight, here in brazil :D

      • 5 years ago
  • Asianexperts
    Asianexperts
    • 5 years ago

    Hi there I would help you but this budget is not sufficient. If this pay is equal for just 600usd then it would be fine to work on

    • 5 years ago
    1. Asianexperts
      Asianexperts
      • 5 years ago

      ok

      • 5 years ago
    2. Asianexperts
      Asianexperts
      • 5 years ago

      waiting for your chat request

      • 5 years ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!