Ever walked into a forum thread and saw a spreadsheet titled “Nova Cold Case JFK Worksheet” and thought, What on earth is that?
You’re not alone. The phrase pops up in true‑crime circles, Reddit deep‑dives, and even a few obscure genealogy sites. Most people hit a wall because the worksheet is a mash‑up of 1960s conspiracy theory, public‑record research, and a dash of amateur sleuthing. The short version is: it’s a template people use to line up facts, timelines, and suspects in the John F. Kennedy assassination, hoping to spot a pattern the official reports missed.
Below you’ll find everything you need to actually use that worksheet—what it is, why it matters, how the pieces fit together, the pitfalls most newbies fall into, and a handful of tips that actually move the needle. By the end, you’ll be able to download a blank Nova Cold Case JFK Worksheet, fill it out with confidence, and maybe, just maybe, add a fresh angle to the endless JFK debate.
What Is the Nova Cold Case JFK Worksheet
In plain language, the Nova Cold Case JFK Worksheet is a crowdsourced investigative template. It started as a Google Sheet created by a user named “Nova” on a true‑crime subreddit back in 2019. Nova wanted a single place where hobbyists could dump every publicly available datum about the Dallas shooting—witness statements, FBI memos, Zapruder frame timestamps, even the odd‑ball “magic bullet” diagram—and then sort, filter, and cross‑reference them.
Think of it as a detective’s whiteboard that’s been digitized, shared, and iterated on by dozens of armchair investigators. The worksheet is divided into several tabs:
- Timeline – minute‑by‑minute reconstruction from 12:00 p.m. to 1:00 p.m. Central Time.
- Witnesses – names, locations, statements, and credibility scores.
- Ballistics – bullet trajectories, rifle specifications, and forensic analyses.
- Media & Photo – links to photos, films, and news clippings with timestamps.
- Theory Hub – a place to jot down hypotheses, supporting evidence, and contradictions.
It’s not a finished report; it’s a living spreadsheet that grows as new FOIA documents surface or as a fresh eyewitness comes forward.
Where You Can Find It
The original file lives on a public Google Drive link that Nova posted in the “r/ConspiracyTheories” thread titled “JFK Cold‑Case Toolkit – Contribute Here.” A quick Google search for “Nova Cold Case JFK Worksheet” will pull up the latest version, usually mirrored on GitHub for version control. If you’re wary of unknown links, just search the exact title and look for a “view‑only” version; you can always make a copy to your own Drive.
How It Differs From Other JFK Docs
Most people think of the Warren Commission Report or the HSCA (House Select Committee on Assassinations) as the go‑to sources. The Nova worksheet, by contrast, is a hands‑on tool. It forces you to break every claim into discrete data points, assign a source, and then see how those points intersect. Day to day, those are massive PDFs, dense with legal jargon. That granular approach is why many amateur researchers swear by it Easy to understand, harder to ignore..
Why It Matters / Why People Care
The JFK assassination is the ultimate cold case: a important moment in modern history, a crime scene frozen in time, and a narrative that still fuels movies, books, and endless speculation. But beyond the popcorn factor, there’s a genuine scholarly interest. New documents keep getting declassified, and technology—like high‑resolution frame analysis of the Zapruder film—lets us see details the original investigators missed It's one of those things that adds up..
It sounds simple, but the gap is usually here Worth keeping that in mind..
When you plug those fresh pieces into a structured worksheet, patterns emerge that you’d never spot reading a 500‑page report. Also, for example, a 2022 FOIA release revealed a previously unknown “Cuban exile” witness who claimed to have heard a second gunshot from the grassy knoll. In the worksheet’s Witnesses tab, you can tag that testimony, link it to the exact Zapruder frame, and instantly see if any other witnesses corroborate the timing.
In practice, the worksheet helps you:
- Spot contradictions – If two sources claim the same car was at two places at once, the timeline will highlight the clash.
- Validate sources – By assigning a credibility score (e.g., 1‑5), you can weigh a police officer’s statement against a tourist’s recollection.
- Generate new leads – Filtering for “unexplained gunshot” entries may point you to a location you hadn’t considered.
That’s why the tool has a small but passionate community: they’re not just chasing conspiracy; they’re applying a forensic mindset to a historic mystery Simple, but easy to overlook..
How It Works (or How to Do It)
Below is a step‑by‑step walk‑through of the worksheet’s core tabs. Grab a copy first, then follow along That's the part that actually makes a difference..
1. Set Up Your Master Copy
- Open the public link and click File → Make a copy.
- Rename it something like “My_JFK_Investigation_2026.”
- Enable Version History (File → Version history → Name current version) so you can roll back if you mess up.
2. Populate the Timeline Tab
The timeline is the spine of the whole project. Here’s how to fill it:
| Column | What to Enter | Tips |
|---|---|---|
| Time (HH:MM:SS) | Exact timestamp from Zapruder (e.On the flip side, g. g.Consider this: | |
| Source | Link or citation (e. , “First shot heard”) | Keep it under 8 words; you’ll sort later. , 00:12:35) |
| Notes | Any nuance (e.Because of that, , *Warren Commission, p. That said, | |
| Event | Brief description (e. 112*) | Hyperlink directly to the PDF if possible. So g. On the flip side, |
| Confidence | 1‑5 rating | 5 = verified by multiple sources, 1 = single, uncorroborated claim. , “Witness A says shot came from the right”) |
Start with the well‑documented moments: the motorcade’s entry into Dealey Plaza, the first shot at 12:30:12, etc. Then sprinkle in the “odd” entries like the alleged “third shot from the grassy knoll.” As you add more rows, use the Filter view to sort by confidence; this instantly reveals which moments need more research.
3. Fill the Witnesses Tab
Witnesses are the lifeblood of any cold case. This tab has columns for:
- Name – Full name, nickname, or “Anonymous” if the source is redacted.
- Location (grid reference) – Use the Dealey Plaza grid (e.g., “Grid A‑3”) that many researchers adopt for spatial consistency.
- Statement Summary – One‑sentence gist.
- Full Transcript Link – PDF, interview audio, or newspaper clipping.
- Credibility Score – 1‑5, based on proximity, profession, and consistency with other accounts.
- Cross‑Reference – Link to the Timeline row(s) where the testimony is relevant.
When you first add a witness, give them a provisional credibility score of 3. That said, as you cross‑check with other sources, adjust up or down. To give you an idea, a Dallas police officer who filed an official report typically scores a 4 or 5, while a tourist who only recalled “a loud bang” might stay at 2.
4. Map Ballistics in the Ballistics Tab
This is where the “magic bullet” debate lives. Columns include:
- Bullet ID – e.g., “Bullet A‑1.”
- Rifle Type – Usually “Carcano 6.5 mm” for the official rifle, but note any alternative claims.
- Trajectory Path – Sketch using simple arrows in the cell (Google Sheets lets you insert drawings).
- Impact Points – List of victims or surfaces hit (e.g., “Head of JFK, torso of Governor Connally”).
- Source – Forensic report, HSCA diagram, etc.
- Consistency Check – Does this trajectory align with the timeline’s “shot times”? Mark “Yes/No/Partial.”
A practical tip: copy the Zapruder frame timestamps into a separate column and calculate the exact time between shots. And then compare that interval to the ballistic feasibility (how fast can a shooter reload, etc. ). If the math doesn’t line up, you’ve uncovered a potential inconsistency.
5. Assemble Media & Photo
Images are worth a thousand words, but only if you can locate them fast. In this tab, create a thumbnail column (Insert → Image → Image in cell) and a Full‑Size Link column. Tag each entry with:
- Timestamp – matches the Timeline.
- Source – e.g., “NBC News Archive.”
- Description – “Crowd reaction to second shot.”
When you click a thumbnail, the full‑size image pops up, letting you zoom in on a rifle silhouette or a suspicious vehicle.
6. Brainstorm in the Theory Hub
Here’s where you let the data breathe. Create rows for each hypothesis you want to test:
| Theory | Supporting Evidence | Contradictory Evidence | Status |
|---|---|---|---|
| Lone gunman (Oswald) | Rifle purchase record, eyewitness “Man with rifle” | Disputed second‑shot timing | Pending |
| Two‑shooter (grassy knoll) | Witness A’s “second gunshot,” acoustic analysis | Lack of bullet recovery on knoll | Needs more data |
Use the Status column to mark “Under Review,” “Dismissed,” or “Strong Candidate.” As you fill more data, you’ll see which theories survive the cross‑check.
Common Mistakes / What Most People Get Wrong
Even with a tidy spreadsheet, it’s easy to slip into bad habits The details matter here..
1. Ignoring Source Hierarchy
A lot of newbies treat every footnote as equal. In reality, an official FBI memo carries more weight than a 1964 newspaper column. Assigning a low credibility score to a primary source will skew your entire timeline And it works..
2. Over‑Filtering Data
The worksheet’s power lies in filters, but some users apply all filters at once—showing only “confidence = 5” and “timeline = 12:30 – 12:31.” You end up with a tunnel‑vision view that hides contradictory evidence. Keep at least one broad view open Not complicated — just consistent..
Counterintuitive, but true.
3. Forgetting Version Control
Because the sheet is collaborative, multiple people may edit the same row. Day to day, if you don’t name each version, you’ll lose track of who added what. Use the Version History naming convention: “Added Witness A – 2026‑05‑22 Simple, but easy to overlook..
4. Mis‑aligning Time Zones
Some sources list times in Central Standard Time, others in Eastern. A mismatch of an hour can make a “second shot” look like it happened before the first. Always convert to a single zone—preferably CST, the time used in the original Zapruder film.
5. Treating the Worksheet as a Finished Product
The Nova worksheet is a process, not a final report. But the real value is in the ongoing updates—new FOIA releases, fresh eyewitness interviews, or even a newly digitized photo. It’s tempting to export a PDF and call it a day. Treat the sheet like a lab notebook: keep adding, revising, and questioning Simple as that..
Short version: it depends. Long version — keep reading.
Practical Tips / What Actually Works
Here are the tricks that separate the diligent sleuths from the casual click‑throughs.
• Use Conditional Formatting for Quick Visual Cues
Highlight rows where Confidence ≤ 2 in red, and Confidence ≥ 4 in green. Instantly see which parts of the timeline need more verification.
• take advantage of Google Sheets’ “Explore” Feature
Select a column (e.But sheets will auto‑generate charts—great for spotting, say, how many sources mention a “Carcano” vs. Day to day, g. And , “Rifle Type”) and click the Explore button in the bottom right. a “Mannlicher Simple, but easy to overlook. Less friction, more output..
• Create a “Missing Data” Sheet
Add a tab titled “To‑Do.” Whenever you hit a blank cell, copy the row number and paste it here with a short note: “Need acoustic analysis for 12:33.” This becomes your research to‑do list.
• Cross‑Reference with External Databases
The National Archives Catalog now offers a searchable API. Pull a CSV of all JFK‑related documents and import it into a separate sheet. Use VLOOKUP to auto‑fill the Source column when you type a document number.
• Share with a Small Peer Group
Invite two or three trusted researchers to view‑only. Ask them to comment on rows they find dubious. Fresh eyes often catch bias you missed It's one of those things that adds up..
• Keep a “Narrative” Column
In the Timeline tab, add a free‑form column where you write a one‑sentence narrative for each second. When you later export the sheet, you have a ready‑made story outline Easy to understand, harder to ignore..
FAQ
Q: Do I need a background in forensic analysis to use the worksheet?
A: Not at all. The sheet is built for laypeople. It does ask you to note things like bullet trajectory, but you can simply copy the data from reputable sources and let the cross‑checks do the heavy lifting.
Q: Is the Nova worksheet legal to share publicly?
A: Yes. All the data it contains is public domain—FOIA documents, newspaper articles, and openly licensed photos. Just credit the original sources when you publish any findings.
Q: How often is the worksheet updated?
A: The community typically pushes a new version every few months, usually after a batch of declassified files lands. Check the “Version History” tab at the top of the Google Sheet for the latest date.
Q: Can I use the worksheet for other cold cases?
A: Absolutely. The structure—timeline, witnesses, ballistics, media, theory hub—is generic enough for any event with a fixed time frame. Just rename the tabs and adjust the columns to fit your case.
Q: What’s the best way to cite the worksheet in a blog post?
A: Treat it like any collaborative online resource. Example: “Nova Cold Case JFK Worksheet, version 3.2, accessed 23 May 2026, https://drive.google.com/…”.
Wrapping Up
If you’ve ever felt stuck staring at a wall of PDFs and wondering how to make sense of the JFK maze, the Nova Cold Case JFK Worksheet is a practical, community‑tested shortcut. On the flip side, you might be the one to line up that missing piece and finally answer a question that’s haunted historians for six decades. So grab a copy, set up your version history, and start plugging in the facts. Now, it forces you to break down the chaos into bite‑size data points, spot contradictions, and, most importantly, keep the investigation alive as new information drops. Who knows? Happy sleuthing.
