Jev for Excel adds five functions that read the text in your cells and answer yes or no, pick one of your categories, pick the one entry in a list that fits, or place it on a scale. Every answer comes with a probability, so you decide what counts as sure.
Coming soon to Excel add-ins. Answers are powered by Jev, TypeSafe's decision model.
| A | B | C |
|---|
Five 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.
A plain yes or no for every row. Set how sure Jev must be to say yes, and if yes could mean several things, say which in the question.
=JEV.YESNO(A2:A50, "Is this a complaint?", 0.7)
The probability of yes for every row. Sort by it to check the close calls first.
=JEV.PROB(A2:A50, "Is this a complaint?")
Give options as a list, a column, or two columns with a description for each. Below your minimum confidence, a row shows Unsure instead of a guess.
=JEV.CHOICE(A2:A50, "Main topic?", "Bugs, Pricing, UX, Other")
Reads the whole list together and picks one entry. Ask for its position to use with INDEX, or spill a probability next to every entry.
=JEV.PICK(A2:A50, "Which review is the angriest?")
Use 2 to 10 levels, lowest first, or just a number for a 1 to n scale. The score is weighted by probability.
=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.
Answers are normal cell values. Filter on them, feed them into a pivot table, or count them with COUNTIF.
The details
Ask for the probability or confidence behind any answer, or spill one probability per option into its own column.
Tell JEV.YESNO how confident it must be before it says TRUE, and let JEV.CHOICE answer Unsure instead of guessing on a close call.
Type them into the formula, like "Bug, Praise, Question", or point at a range with a short description beside each one.
If a single row fails, only that row shows an error. The rest of the column keeps its answers.
Freeze in the Jev sidebar turns the selected formulas into plain values, so finished answers never change again.
Install the add-in and type a formula. There is nothing to sign up for and no key to paste in.
Use it for
If you would otherwise read every row yourself, Jev can take the first pass.
Five functions, plain questions, an answer for every row.
Jev for Excel