Exporting your scenarios from the simulator

Do you want to make an interactive Excel simulator instead?.

This walk-through demonstrates how to export beautiful charts from the Conjointly simulator in less than two minutes.

To follow the instructions, navigate to your experiments page and open the Report for Example experiment 8: Subscription plan optimisation for a streaming service.

Step 1 - Assign colours to SKUs

Within the Conjointly online simulator, assign colours to your tested SKUs in a meaningful way. Here we have two separate brands, so we are assigning all SKUs of one brand different shades of red, and the other different shades of blue.

Online simulator for conjoint analysis

Step 2 - Check revenue/profit calculations

Specify the formula used in calculating the revenue/profit. Here we are going to follow Conjointly’s default formula for a market index of 1000 products.

Revenue and profit projections with online tool

Step 3 - Export simulation charts

Add the desired scenario to your analysis cart by clicking on the “Add to export” button similar to adding other outputs to the cart and download the Excel by clicking on the “Make Excel” button.

Export the PowerPoint presentation

Step 4 - Export to PowerPoint or Excel

Click on the “Make PowerPoint file” button to download the selected output charts directly to PowerPoint.

Export the PowerPoint presentation

Alternatively, You can click on the “Make Excel file” button to download an Excel workbook instead.

Export the PowerPoint presentation

Step 5 - Open Excel file

Exporting a PowerPoint file automatically creates slides with formatted charts for you.

To create nice looking slides from the Excel exports, open up the Excel file and move to the simulation tab. We see that the preference share graph has already been built, following the colours specified in the online simulator.

Preference share in excel

Step 6 - Create revenue graph

Now let’s also create the revenue graph from scratch. We will select all of the revenue data and insert a new stacked column chart. Using the Conjointly Excel Add-in, we will:

  • Use the function Re-colour chart from cells to apply the colours set in the online simulator to our new chart
  • Use the function Hide Zeros to hide all values approaching zero, to remove clutter from the charts.
Revenue graph styling

Step 7 - Insert graph into presentation deck

Finally we can add turn out charts into a presentation slide. By simply adding titles, the charts are transformed into a professional looking presentation slide.

Powerpoint slide with profit and revenue

Would you like to try new excel export functionality? Log in to explore simulation reports.