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.
Unos 10 minutosA 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.
El camino exacto en PlotSet, desde una plantilla en blanco hasta el gráfico terminado.
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.
Empieza con la plantilla de Calculator, que ya trae datos de ejemplo cargados, y sustitúyelos por los tuyos.
Abrir la plantillaEl último tramo es igual en todos los tipos de gráfico: Share convierte el gráfico en un enlace público en vivo y un código de incrustación, y Export lo guarda como un archivo estático.
Al activar el código de incrustación y el enlace público, el gráfico queda publicado. El enlace se lo puedes enviar a cualquiera sin problema, y el código de incrustación se coloca en cualquier página como un iframe que conserva los tooltips al pasar el cursor y toda la interactividad. Si editas el gráfico más adelante, haz clic en Recreate para llevar esos cambios a ambos.
Export guarda una copia estática en el tamaño que necesites. El SVG se mantiene nítido a cualquier escala y se puede seguir editando en una herramienta de diseño; PNG y JPG son la opción segura para diapositivas y documentos. El multiplicador de escala es lo que te da una imagen nítida en una pantalla retina.
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.
¿No estás seguro de que el Calculator sea la opción correcta? Descubre qué es, cuándo usarlo y cuándo no.
A question text and a question type for each row. Options, defaults, help text, an image and extra numeric columns are optional.
Gratis para empezar con más de 300 plantillas. No se necesita tarjeta de crédito.
