The Scholar's Vault · Spreadsheet, with worked example
Six venues, scored before you write the cover letter.
Journal selection matrix: fit, speed, audience and realistic acceptance in one sheet
Most submission decisions are made in an afternoon, from memory, under deadline. This sheet takes 90 minutes and replaces the memory with six numbers you can check.
No ghostwriting, ever · Human-led, PhD-signed
The page is the content. The download is the working copy — the sheet with the formulas live, the weights adjustable in row 1, and the six-venue example already filled in as a second tab. It comes as an .xlsx and as a Google Sheets copy (opens in a new tab), because most of you will use the second one. One email covers all six Vault resources.
What this is for
The output is not a ranking.
The output is the moment you discover that the venue you already chose scores 2 out of 5 on fit and has never published your method.
That discovery costs 90 minutes here and eleven weeks at the other journal. The whole design of the sheet is aimed at making it happen early enough to be useful.
Choosing a venue badly is not a failure of ambition or of nerve. It is a matching problem with five variables, and matching problems are solvable on a page.
The four axes
Four axes, twenty anchors, and a source for each.
Every candidate is scored 1 to 5 on four axes. Each axis has anchors, and each anchor names where the evidence comes from, because a score you cannot source is a preference wearing a number.
The weights are yours. The defaults below are 40 / 20 / 20 / 20, and they sit in row 1 of the sheet so you can change them. A researcher with a contract ending in nine months moves weight onto speed; somebody building a tenure case moves it onto audience. Change them once, before you score, and write the reason in the notes cell.
Axis 1 · Fitdefault weight 40%
Not “is this journal in my field”. The question is whether this journal has published a paper that does what yours does.
Fit: the five anchors, and where you check each one Score Anchor Where you check it 5 Three or more papers in the last 24 months share your method and your question type Journal site, last 8 issues, read titles and abstracts 4 Papers share your question type, method appears but is not common Same, plus a site search on your method term 3 The topic is in scope, no close methodological precedent Aims and scope, plus the last 8 issues 2 Adjacent field. You are arguing for scope rather than showing it Aims and scope only 1 You cannot name a published paper you would cite as precedent The absence is the evidence The one-line test. Write the sentence: “This is the journal that published [AUTHOR, YEAR], which did [THING] for [OTHER LITERATURE].” If you cannot fill the brackets from memory or from ten minutes of looking, the score is 2 or below.
Axis 2 · Speeddefault weight 20%
Score against your real deadline, not against impatience. A contract ending in nine months and a probation review in four years are different problems.
Speed: the five anchors, and where you check each one Score Anchor Where you check it 5 Median time to first decision published by the journal, and under 6 weeks Journal’s own metrics page or annual editorial 4 Published, and 6 to 12 weeks Same 3 Not published, but three recent papers show received-to-accepted under 6 months Received and accepted dates printed on recent articles 2 Received-to-accepted runs 6 to 12 months on recent papers Same 1 Over 12 months, or no dates printed anywhere The absence is the evidence Three is the honest score for most journals. Because most journals publish no decision times. Read the dates off five recent articles and take the middle one.
Axis 3 · Audiencedefault weight 20%
Who has to read this for the paper to do its job. Answer that before you score, in one sentence, and write it in the sheet.
Audience: the five anchors, and where you check each one Score Anchor Where you check it 5 The people who must cite this are on the editorial board or in the last 8 issues Editorial board list, reference lists of recent issues 4 Read by that group, not the venue they publish in first Your own reading of who cites what 3 Reaches the field broadly, not the specific group General reputation, indexing 2 Reaches a related field. Your group would find it by search, not by habit Indexing coverage 1 Outside the reading path of anyone who has to act on this Say so plainly and score it Indexing is part of this axis, not a separate one. If your assessment panel counts only indexed venues, an unindexed journal scores 1 on audience regardless of who reads it. Check the index your institution actually uses, then record the coverage.
Axis 4 · Realistic acceptancedefault weight 20%
This is an estimate, and the sheet labels it as one. Nobody can compute your probability of acceptance, and any tool that offers to is selling something.
Realistic acceptance: the five anchors, and where you check each one Score Anchor What it rests on 5 Published acceptance rate above 40%, or your last two submissions there were reviewed Journal’s published rate, your own record 4 Published rate 25 to 40%, and your fit score is 4 or 5 Published rate 3 Rate not published; the journal publishes work at your career stage and scale Author affiliations and data scale in recent issues 2 Rate under 15%, or the journal publishes mostly large-team or large-sample work Published rate, recent issues 1 Rate under 10% and no precedent for your design Both The correction that makes this axis honest. If fit scores 2, cap realistic acceptance at 2. Fit is the binding constraint on acceptance, and a matrix that lets a poor-fit venue score well on acceptance is telling you what you want to hear.
The kill switches
Run these first. Twenty minutes.
Six conditions remove a venue from the sheet before scoring. They are not scored, because a weighted average would otherwise hide them.
| Condition | How you check | Why it removes the venue |
|---|---|---|
| The article-processing charge is above what you have, and no waiver applies | The journal’s own APC page, and its waiver policy | An acceptance you cannot pay for is a rejection with extra steps |
| The licence or embargo conflicts with your funder’s open-access condition | Your grant terms, then the journal’s archiving policy | The compliance failure surfaces after acceptance, when you have no options left |
| The journal fails a basic legitimacy check | Named indexes, publisher’s COPE membership, whether the editorial board members confirm they serve | A publication in a venue your panel does not recognise is worse than no publication |
| The journal is delisted, or flagged as under evaluation, by the index your panel countsRecent, and easy to miss | The index’s own coverage or master list, checked this month, with the date written in the sheet | Indexing is withdrawn during the months your paper is in review, and a delisted venue is discovered by your panel rather than by you |
| A special issue whose guest editors you cannot verifyRecent, and easy to miss | Named guest editors, their institutional pages, and whether the parent journal is currently indexed | The fast route and the risky route are the same route |
| Scope explicitly excludes your design | Aims and scope, read to the end | The desk reject is already written |
It takes twenty minutes and removes one or two candidates most of the time.
On special issues
Special issues are the biggest change in how journals take submissions in the last three years, and they cut both ways. They are genuinely faster, they are genuinely easier to place a slightly off-centre paper in, and they are also where mass delistings and retraction waves have concentrated.
Three checks, and a special issue passes or it is out.
- The guest editors are named, and you can find them. Institutional page, recent publications in the area, an ORCID with a history. An unnamed or unfindable guest editor is the switch.
- The parent journal is indexed today. In the index your panel counts, and you have written the date you checked.
- The call reads like scholarship rather than recruitment. A call with no methodological boundary, an implausible deadline, and an invitation that arrived by mass email is a different product from a special issue.
Score a passing special issue on the same four axes as anything else, and record it in the flag column so the ranking does not hide what it is.
Transfer and cascade offers
Publishers increasingly answer a rejection with an offer to move the manuscript to another title in the same group, reviews included. That is a real second path and it is worth a column, because the decision comes fast and under fatigue.
Score the offered venue on the sheet before answering. A transfer offer is a venue like any other, and the reviews travelling with it change the speed score, not the fit score.
The sheet
Sixteen columns, and four of them calculate.
Six venues, one tab. Weights live in row 1, headers in row 2, data from row 3.
| Column | Header | Content |
|---|---|---|
| A | Venue | Journal name |
| B | Precedent paper | Author and year of the paper you would cite as precedent, or blank |
| C | Fit (1–5) | Scored against the axis 1 anchors |
| D | Speed (1–5) | Scored against the axis 2 anchors |
| E | Audience (1–5) | Scored against the axis 3 anchors |
| F | Acceptance, raw (1–5) | Scored against the axis 4 anchors, before the fit cap |
| G | Acceptance, capped | =MIN(F3,IF(C3<=2,2,5)) |
| H | Weighted score | =C3*$C$1+D3*$D$1+E3*$E$1+G3*$F$1 |
| I | Kill switch | PASS, or the name of the switch it failed |
| J | Special issue? | No, or Yes plus the guest editors’ names |
| K | Index status | Listed · Under evaluation · Delisted · Not indexed, with the date you checked |
| L | Decision time (weeks) | The figure, or the median you read off five articles |
| M | APC | The charge, or zero |
| N | Transfer offered? | Blank, or the title offered and the date |
| O | Evidence link | URL of the page you took the numbers from |
| P | Notes | One line. What you learned that the numbers do not carry |
Row 1 holds the weights. C1 fit, D1 speed, E1 audience, F1 acceptance. The defaults are 0.4, 0.2, 0.2 and 0.2.
The four formulas that do the work
Written for row 3, so you can rebuild the sheet anywhere. This is the whole instrument, published: a formula you cannot see is a black box, and the point of this resource is that the scoring is inspectable.
The fit cap, in column G:
=MIN(F3,IF(C3<=2,2,5))
The weighted score, in column H:
=C3*$C$1+D3*$D$1+E3*$E$1+G3*$F$1
Ranking, among survivors only, in column I onward:
=IF(I3<>"PASS","EXCLUDED",SUMPRODUCT(($I$3:$I$8="PASS")*($H$3:$H$8>H3))+1)
The weights guard, in anywhere in row 1:
=IF(SUM($C$1:$F$1)<>1,"WEIGHTS DO NOT SUM TO 1","")
- Why the ranking does not use RANK. RANK scores an excluded venue against the survivors, so a killed candidate with the highest weighted score pushes everything below it down a place. Counting how many passing venues beat you, and adding one, ranks the venues you can actually submit to.
- Why the cap needs its own column. Capping a score inside the cell that holds it makes the formula refer to itself, and the sheet either errors or silently stops capping. Column F holds what you scored, column G holds what the ranking uses, and the difference between the two is visible, which is the point.
- Why column O is not optional. A score with no link beside it is a memory, and the entire point of the sheet is to stop you submitting on a memory.
Worked example
What 90 minutes buys.
Six venues, scored by an author with a nine-month contract and a mixed-methods paper. Weights left at the defaults.
The venues are labelled A to F, and every figure below is invented for the illustration. Your own sheet takes real numbers from column O.
| Venue | Fit | Speed | Aud. | Acc. raw | Acc. capped | Weighted | Special issue | Index | Kill switch | Rank |
|---|---|---|---|---|---|---|---|---|---|---|
| A | 2 | 5 | 5 | 4 | 2 | 3.2 | No | Listed | PASS | 3 |
| B | 5 | 2 | 5 | 3 | 3 | 4.0 | No | Listed | PASS | 1 |
| C | 4 | 4 | 3 | 3 | 3 | 3.6 | No | Listed | PASS | 2 |
| D | 5 | 4 | 5 | 4 | 4 | 4.6 | No | Listed | APC €2,400, no waiver | EXCLUDED |
| E | 3 | 3 | 2 | 3 | 3 | 2.8 | Yes, guest editors named and verified | Listed | PASS | 4 |
| F | 1 | 5 | 4 | 1 | 1 | 2.4 | Yes, guest editors not findable | Under evaluation | Guest editors unverifiable | EXCLUDED |
What this author learned in 90 minutes
- Venue A was the plan. It scores 5 on audience and 5 on speed, which is why it felt right, and 2 on fit, which is why it would have come back as a desk reject in nine days. The precedent cell in column B was empty and stayed empty.
- The cap did visible work on venue A. Self-scored acceptance was a 4, on the strength of a friendly editor and a published rate above 40%. Fit of 2 caps it at 2, and the gap between columns F and G is the sheet telling the author what they were doing.
- Venue D was the best paper-to-venue match on the sheet. And it is unaffordable. Knowing that now means the author can ask about a waiver this week rather than after an acceptance.
- Venue F was the fastest route on the sheet. And it left the sheet on a kill switch rather than on a score. Two of the three guest editors had no institutional page and the parent journal was flagged as under evaluation. Nothing about that shows up in a weighted average, which is why it is a switch.
- Venue B wins on a 5 for fit. Despite the slowest decision time in the set. Whether that is the right answer depends on the nine-month contract, which is why the sheet ranks and the author decides.
The line to write in column P for venue A:
“No precedent paper. Chose it because two people in the group publish there.”
That sentence is the output of this exercise. The ranking is a side effect.
How to read your own sheet
The winner is the least interesting cell.
Six readings, and none of them is “take the top row”.
- Read column B before column H. An empty precedent cell beside a high weighted score means the score came from reputation rather than from evidence.
- Read F against G. Where the capped acceptance is well below the raw one, you scored acceptance on hope and fit on evidence. The gap is the most useful number on the sheet.
- Look at the spread, not the winner. Six venues within 0.4 of each other means the axes are not discriminating and your anchors were scored generously. Rescore fit against the last eight issues, strictly.
- Recheck column K on the day you submit. Index status changes during the weeks a paper sits in review, and the check costs two minutes.
- Check what your top two share. If your first and second choices differ on every axis, you have two different papers in mind, and the cover letter will show it.
- Keep the sheet after you submit. When the rejection arrives, the second choice is already scored, sourced and ranked, and the resubmission takes an afternoon rather than a fortnight.
The failure this sheet is built against
The question that stops getting asked.
Venue choice usually happens at the end, when the manuscript is finished, and the author is tired.
At that point the honest question, whether this journal has ever published anything like this, feels like an attack on work that is already done.
So it does not get asked, and the answer arrives eleven weeks later from an editor who took nine days to send it.
The sheet moves the question to a point where the answer is still useful. That is the whole mechanism.
Where this stops, and what we do
It cannot tell you that your fit score of 4 is a 2.
The sheet ranks what you put in it.
And self-scored fit is generous roughly as often as authors are hopeful.
Manuscript MRI — a 23-point structural and logic diagnostic with a journal-fit analysis and the Reviewer #2 simulation, in a colour-coded report of 12 to 18 pages with a 15-minute video walk-through.
- €459· 5 to 7 day turnaround · up to 10,000 words
One price, no retainer, and no scoping call, because the scope is fixed and published.
Or start with the free route. A written strategy brief: tell us where you are stuck, and within 3 working days we send a three-step plan, including which service fits, or that none of ours does. No follow-up sequence.
We have no relationships with editors, journals or panels, and we would not tell you that a submission was safe. What we do is read the work against the criteria that will decide it, and rank what we find.
