A step by step walkthrough for turning a spreadsheet of questions into a published, embeddable calculator in PlotSet, with a formula that computes a result from visitors' answers.
约 10 分钟A short sequence of questions followed by a computed result, such as a score, an estimate or a recommendation, ready to embed on your page: that is what you will have. Each row of a spreadsheet becomes one question, and a formula you write turns the answers into a number.
Expect about ten minutes. Most of it is deciding the questions and the formula, since the template does the rest. Test it with a few known inputs before you publish.
One row per question with a question text and type, then optional answer options, a default answer, help text, an image URL and extra numeric columns such as a weight.
| question_text | question_type | answers_raw | fallback_value | context_text | image | weight_co2 | ||
|---|---|---|---|---|---|---|---|---|
| How many miles do you drive per week? | number | 50 | Include commuting and errands | 0.4 | ||||
| How often do you fly each year? | slider | "0 | 10 | 1" | 2 | Return trips count as two | 250 | |
| What is your diet? | dropdown | Vegan|Vegetarian|Mixed|Meat heavy | Mixed | 1 | ||||
| How many people live in your home? | rating | 5 | 2 |
Question type must be one of text, number, dropdown, date, rating, slider or buttons. Anything else becomes a text box.
For dropdown and buttons, separate options with a pipe. Use label=value to store a value different from the label.
For rating, give the number of icons. For slider, give min,max,step, such as 0,10,1.
Extra numeric columns, such as a weight, are available in the formula as q1_weight, named by question number and column header.
PlotSet 中从空白模板到完成图表的具体点击路径。
From the PlotSet dashboard, start a new project and choose Calculator from the Other category. It loads with an eight-question sample so you can see every question type working.
Give each question a prompt and a type, then add options, a sensible default and a line of help text where it helps. Keep each question short and answerable in one move.
Import a CSV or .xlsx file from the data panel, paste rows from a spreadsheet, or connect a Google Sheet so changes to the questions flow through. The first row is read as the headers.
Confirm which column is the question text, type, options, default, help text, image and extra data. This is usually right automatically when the headers are clear.
Open the Submit and result tab. In the variables box add one name equals expression line per value, referring to answers as q1, q2 and so on. Then write the result text and put the names in double curly brackets.
In the Flow and design tab, show one question at a time with Back and Next buttons, or all questions on one page. Style the card, buttons and inputs to match your site.
The Question types tab styles each control separately: text and number inputs, dropdowns, rating icons, sliders and button groups.
Answer every question with known values and check the result against a hand calculation. Then publish and copy the embed code from the Share dialog.
从已加载示例数据的 Calculator 模板开始，再替换成你自己的数据。
打开模板最后一段路对每种图表都一样：「Share」（分享）把图表变成一个在线的公开链接和一段嵌入代码，「Export」（导出）把它输出成静态文件。
打开嵌入代码和公开链接的开关，图表就发布出去了。链接可以放心发给任何人；嵌入代码以 iframe 的形式放进任意页面，悬停提示和交互效果都会保留。之后修改了图表，点「Recreate」就能把改动同步到链接和嵌入代码两边。
「Export」会按你需要的尺寸输出一份静态副本。SVG 放到多大都清晰，还能在设计工具里继续编辑；幻灯片和文档用 PNG 或 JPG 最稳妥。想让图片在高分屏上够锐利，关键就是那个倍数设置。
Use inputs whose answer you can work out in your head, so a wrong formula is obvious.
An untouched question uses its default, so pick the most common answer rather than zero.
Build the result in named steps, such as driving, flights and total, so the formula stays readable.
Use the Number and date format tab to set prefixes, suffixes and decimals so the result reads as a cost, a percentage or a weight.
A line in the formula is probably malformed, and a bad line silently evaluates to zero. Check the spelling of each name and bracket.
The type was misspelled or missing, so it fell back to text. Check it matches one of the seven types exactly.
Formulas use q1, q2 and so on by sheet order. If you move rows, update the formula.
The static export redraws the current state approximately. Use the live embed for the real experience.
不确定 Calculator 是否是正确选择？查看它是什么、何时使用以及何时不使用。
A question text and a question type for each row. Options, defaults, help text, an image and extra numeric columns are optional.
免费开始，300+ 模板任选。无需信用卡。
