6Step 6 of 6

Analyse and export results in QB-EDGE™

Answers become figures. Figures go to Excel.

Analyse and export is the part of QB-EDGE™ by Generation Impact Global (GIG) that turns questionnaire answers into figures. QB-EDGE™ calculates scores, a Benchmark and KPIs, shows them in results views and tables, and exports them to Excel. It is built for teams that send questionnaires to portfolio companies, suppliers or borrowers and need to compare what comes back.

Explore QB-EDGE™

At a glance

  • 4

    results views

    By question, by respondent, by KPIs, comparative.

  • 5

    chart types per question

    Bar, donut, line, radar, word cloud.

  • 0 to 100

    score scale

    When weights run from 0 to 100.

  • Excel

    exports (XLSX)

    Results, one respondent’s answers, the Benchmark.

QB-EDGE™ gives you five ways to read the answers to a questionnaire. Scores and KPIs are calculated by rules you set.

OutputWhat it isCalculated from
ScoreA number for each respondentThe weights you put on answer options
BenchmarkThe average score of your panel, overall and per groupThe questionnaires you have accepted
KPIA figure with a unit, for each respondentOne answer, or a formula over several answers
Results viewsAnswers by question, by respondent, by KPIs or side by sideThe answers to one questionnaire
Results tablesYour own tables in the Analytics area, with thresholdsThe questions and formulas you choose

Four views, one set of answers

QB-EDGE™ shows the answers to a questionnaire in four views.

  • By question: every answer to the same question, as a bar, donut, line, radar or word cloud chart.
  • By respondent: all answers from one respondent.
  • By KPIs: the KPIs of each respondent.
  • Comparative view: the same questions, with respondents side by side.

You set the weights, QB-EDGE™ calculates the score

QB-EDGE™ calculates a score from the weights you put on answer options. An option without a weight stays out of the score.

  • Single choice and multiple choice: one weight per option.
  • Yes/no: one weight for the positive answer and one for the negative.
  • Multiple choice: the highest weight among the chosen options counts.
  • Scale: with weights from 0 to 100, scores read on a 0 to 100 scale.

Compare within your own panel

The Benchmark in QB-EDGE™ is the average score of your own panel: the companies that answered your questionnaire. It uses no outside market data.

  • What counts: only questionnaires you have accepted.
  • Groups: averages for the whole panel and per group, for example per sector. The group comes from a single choice question.
  • Levels: averages per question, per section and overall.
  • Empty answers: skipped or counted as zero. You choose.
  • Views: a matrix or a table by question, with up to eight colour ranges.
  • Visibility: off until you switch it on. Once its questionnaire is accepted, each company sees its own score beside the panel and group averages, and never another company’s score.
  • Preview as company: check what one company would see before you switch visibility on.

From answer weights to the Benchmark

Your formulas, calculated for every respondent

A KPI in QB-EDGE™ is a figure calculated from questionnaire answers, for example a renewable energy share in %. QB-EDGE™ calculates it for every respondent.

  • Two methods: copy the value of one question, or write a formula over several questions.
  • Formulas: spreadsheet-style, with functions such as IF, SUM and ROUND.
  • Periods: a formula can use answers from the current or the previous period.
  • Units: each KPI has a unit of measure.
  • Check: the formula is checked before you save.
  • Respondents: you can show a KPI inside the questionnaire and let respondents add an explanation.

Building a KPI formula

Build the table you need, let colour flag the values

The Analytics area of QB-EDGE™ holds your own pages, and each page holds results tables. You choose the rows, and thresholds colour the values.

  • Rows: a question or a formula.
  • Thresholds: value ranges, each with a colour and a label such as “Low” or “High”. A value in a range takes its colour.
  • Aggregate columns: with a breakdown of what went into each figure, and an optional grand total.
  • Filters: tags and categories filter the rows.
  • Palettes: save colour palettes and reuse them.

A results table with thresholds

Example with fictional data. The six companies do not exist.

  1. The questionnaire asks each company for its total energy use and its renewable energy use, in MWh.
  2. A formula row in a QB-EDGE™ results table calculates: renewable energy share = renewable energy / total energy × 100.
  3. Two thresholds are set on that row: 0 to 20 is “Low” (red) and 50 to 100 is “High” (green).
CompanyTotal energy (MWh)Renewable (MWh)Renewable share
Demo company A8,4002,94035%
Demo company B3,90058515% Low
Demo company C1,15069060% High
Demo company D12,6002,27018% Low
Demo company E21016880% High
Demo company F76053270% High

Result: two companies show as Low and three as High. Company A, at 35%, sits between the two ranges and has no colour. The clip above shows the same figures in QB-EDGE™.

This period next to the last one

Yes. For a questionnaire that recurs, QB-EDGE™ puts the previous period next to the current one.

  • Setting: switch on “Comparability with previous period” when you set up a recurring questionnaire.
  • Respondents: “Previous period reported” sits beside each answer. On number questions, the change shows in per cent.
  • Results: previous values appear next to the current ones.
  • KPIs: a formula can use answers from the previous period.
  • Results tables: a table can compare with the previous period or the previous questionnaire.
  • Frequency: a questionnaire can recur annually, semi-annually, quarterly or monthly.

Comparing with the previous period

Take the figures with you

QB-EDGE™ exports to Excel (XLSX). There is no PDF export. You can export three things, and which features you get depends on your plan.

  • Results for the respondents you select: answers, rows per location and KPIs.
  • One respondent’s answers: from the overview.
  • The Benchmark.

Exporting results to Excel

Which result views does QB-EDGE™ offer?

How are scores calculated in QB-EDGE™?

What is a KPI in QB-EDGE™?

Can a KPI use last period’s values?

Which answers count in the Benchmark?

Can companies see each other’s results?

What do thresholds do?

Can I filter what a table shows?

Can I compare results with the previous period?

Which formats can I export to?

Does QB-EDGE™ use AI to calculate scores or KPIs?

Open a free account, or ask us for a walk-through.

Some features depend on your plan. See pricing.

Keep up with changes on policies, legislations and technologies.

Subscribe to our Newsletter!

The latest news and events related to impact, risk, and sustainability around the world.

Privacy policy provides additional information on how your data is processed.