Skip to content
XP ConsultingFree Brief

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.

  1. 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
    ScoreAnchorWhere you check it
    5Three or more papers in the last 24 months share your method and your question typeJournal site, last 8 issues, read titles and abstracts
    4Papers share your question type, method appears but is not commonSame, plus a site search on your method term
    3The topic is in scope, no close methodological precedentAims and scope, plus the last 8 issues
    2Adjacent field. You are arguing for scope rather than showing itAims and scope only
    1You cannot name a published paper you would cite as precedentThe 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.

  2. 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
    ScoreAnchorWhere you check it
    5Median time to first decision published by the journal, and under 6 weeksJournal’s own metrics page or annual editorial
    4Published, and 6 to 12 weeksSame
    3Not published, but three recent papers show received-to-accepted under 6 monthsReceived and accepted dates printed on recent articles
    2Received-to-accepted runs 6 to 12 months on recent papersSame
    1Over 12 months, or no dates printed anywhereThe 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.

  3. 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
    ScoreAnchorWhere you check it
    5The people who must cite this are on the editorial board or in the last 8 issuesEditorial board list, reference lists of recent issues
    4Read by that group, not the venue they publish in firstYour own reading of who cites what
    3Reaches the field broadly, not the specific groupGeneral reputation, indexing
    2Reaches a related field. Your group would find it by search, not by habitIndexing coverage
    1Outside the reading path of anyone who has to act on thisSay 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.

  4. 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
    ScoreAnchorWhat it rests on
    5Published acceptance rate above 40%, or your last two submissions there were reviewedJournal’s published rate, your own record
    4Published rate 25 to 40%, and your fit score is 4 or 5Published rate
    3Rate not published; the journal publishes work at your career stage and scaleAuthor affiliations and data scale in recent issues
    2Rate under 15%, or the journal publishes mostly large-team or large-sample workPublished rate, recent issues
    1Rate under 10% and no precedent for your designBoth

    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.

Six kill switches, how to check each, and why it removes the venue
ConditionHow you checkWhy it removes the venue
The article-processing charge is above what you have, and no waiver appliesThe journal’s own APC page, and its waiver policyAn acceptance you cannot pay for is a rejection with extra steps
The licence or embargo conflicts with your funder’s open-access conditionYour grant terms, then the journal’s archiving policyThe compliance failure surfaces after acceptance, when you have no options left
The journal fails a basic legitimacy checkNamed indexes, publisher’s COPE membership, whether the editorial board members confirm they serveA 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 missThe index’s own coverage or master list, checked this month, with the date written in the sheetIndexing 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 missNamed guest editors, their institutional pages, and whether the parent journal is currently indexedThe fast route and the risky route are the same route
Scope explicitly excludes your designAims and scope, read to the endThe 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.

  1. 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.
  2. The parent journal is indexed today. In the index your panel counts, and you have written the date you checked.
  3. 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.

The sixteen columns of the sheet, and what each holds
ColumnHeaderContent
AVenueJournal name
BPrecedent paperAuthor and year of the paper you would cite as precedent, or blank
CFit (1–5)Scored against the axis 1 anchors
DSpeed (1–5)Scored against the axis 2 anchors
EAudience (1–5)Scored against the axis 3 anchors
FAcceptance, raw (1–5)Scored against the axis 4 anchors, before the fit cap
GAcceptance, capped=MIN(F3,IF(C3<=2,2,5))
HWeighted score=C3*$C$1+D3*$D$1+E3*$E$1+G3*$F$1
IKill switchPASS, or the name of the switch it failed
JSpecial issue?No, or Yes plus the guest editors’ names
KIndex statusListed · Under evaluation · Delisted · Not indexed, with the date you checked
LDecision time (weeks)The figure, or the median you read off five articles
MAPCThe charge, or zero
NTransfer offered?Blank, or the title offered and the date
OEvidence linkURL of the page you took the numbers from
PNotesOne 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.

Six invented venues, their scores on each axis, and the rank the sheet gives them
VenueFitSpeedAud.Acc. rawAcc. cappedWeightedSpecial issueIndexKill switchRank
A255423.2NoListedPASS3
B525334.0NoListedPASS1
C443333.6NoListedPASS2
D545444.6NoListedAPC €2,400, no waiverEXCLUDED
E332332.8Yes, guest editors named and verifiedListedPASS4
F154112.4Yes, guest editors not findableUnder evaluationGuest editors unverifiableEXCLUDED

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.

No ghostwriting, ever · Human-led, PhD-signed