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 instruction you can view and export 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.
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.
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.
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.
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.
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.
Would you like to try new excel export functionality? Log in to explore simulation reports.
Ability to export simulator for BPTOs
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
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.