Jev for Excel adds three functions that read the text in your cells and answer yes or no, pick one of your categories, or place it on a scale. Every answer comes with a probability, so you decide what counts as sure.
Install it from Excel add-ins. Answers are powered by Jev, TypeSafe's decision model.
| A | B | C |
|---|
Three functions
Point a function at a cell or a column of cells, ask your question in plain words, and each row gets its own answer. Results spill down next to your data like any other Excel formula.
Flag the rows that match. Set your own threshold, or ask for the probability of yes. Replace TRUE and FALSE with your own words, like Bug and OK.
=JEV.YESNO(A2:A50, "Is this a complaint?", 0.7)
Give options as a list, a column, or two columns with a description for each. Below your minimum confidence, a row shows a fallback instead of a guess.
=JEV.CHOICE(A2:A50, "Main topic?", "Bugs, Pricing, UX, Other")
Use 2 to 10 levels, lowest first, or just a number for a 1 to n scale. The score is weighted by probability, so 3.6 means somewhere between 3 and 4.
=JEV.SCORE(A2:A50, "How urgent is this?", 5)
How it works
No scripts, no exports, no new tool to learn. If you can write a SUM, you can use Jev.
Get Jev for Excel from Excel add-ins. The functions appear under the JEV. prefix with help for every argument.
Type =JEV.YESNO(A2, "Is something broken?") in any cell. Use a range like A2:A500 for one answer per row.
Answers are normal cell values. Filter on them, feed them into a pivot table, or count them with COUNTIF.
The details
Messy ranges, empty rows and long columns are the normal case, so the add-in handles them for you.
Ask for the probability or confidence behind any answer, or spill one probability per option into its own column.
A range gives one answer for each row. Cells in the same row, like A2:C2, are judged together as one item.
Blank rows stay blank and never make a request. Point at A2:A1000 without worrying about the empty tail.
Several questions about the same text are sent together, and repeated questions are answered from the session cache.
If a single row fails, only that row shows an error. The rest of the column keeps its answers.
Hover over a #N/A or #VALUE! cell to see what went wrong, in plain words.
Use it for
If you would otherwise read every row yourself, Jev can take the first pass.
Three functions, plain questions, an answer for every row.
Jev for Excel