Excel Export of Conjoint Simulations

Conjoint.ly now supports exporting simulation charts to Excel, to make it easier than ever to include your simulations into documents or presentation decks. Even the colours assigned in the online simulator will be carried over to the exported charts!

This walk-through demonstrates how to export beautiful charts from the Conjoint.ly 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 Conjoint.ly 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 Conjoint.ly’s default formula for a market index of 1000 products.

Revenue and profit projections with online tool

Step 3 - Export simulation charts

Under the market overview tab, select export to Excel. Enable the option to export simulation charts. This will only take a couple of minutes.

Export conjoint simulator to Excel

Step 4 - Open excel file

Moving 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 5 - 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 Conjoint.ly 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 6 - 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.

Ability to export simulator for BPTOs

Brand Price Trade Off Simulator

With Conjoint.ly, you can now export the Excel simulator for Brand Price Trade-Offs. The Excel simulator allows you to calculate the preference share of up to 150 SKUs, at varying prices, both before and after an adcept is shown.

Conjoint.ly’s Excel Plugin

Conjoint.ly Excel Plugin

To improve your Excel charting experience, the Conjoint.ly Excel Add-in is now available online. The add-in contains multiple functions that help with charting Conjoint.ly outputs.

Some of these functions include:

  • The ability to automatically recolour charts from data cells, for quick and easy chart-making
  • A function that enables quick calculation of the price elasticity of demand between two price points
  • A button that transforms conditional formatting to static formatting with ease, allowing you to combine multiple forms of conditional formatting.

Download Excel Plugin