Ever walked into a forum thread and saw a spreadsheet titled “Nova Cold Case JFK Worksheet” and thought, *What on earth is that?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 phrase pops up in true‑crime circles, Reddit deep‑dives, and even a few obscure genealogy sites. *
You’re not alone. 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 That's the part that actually makes a difference. But it adds up..
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 The details matter here. Took long enough..
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. Those are massive PDFs, dense with legal jargon. In real terms, it forces you to break every claim into discrete data points, assign a source, and then see how those points intersect. In real terms, the Nova worksheet, by contrast, is a hands‑on tool. That granular approach is why many amateur researchers swear by it Which is the point..
Why It Matters / Why People Care
The JFK assassination is the ultimate cold case: a central 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.
When you plug those fresh pieces into a structured worksheet, patterns emerge that you’d never spot reading a 500‑page report. To give you an idea, 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 Most people skip this — try not to..
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.
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. | |
| Confidence | 1‑5 rating | 5 = verified by multiple sources, 1 = single, uncorroborated claim. g.112*) |
| Notes | Any nuance (e., “First shot heard”) | Keep it under 8 words; you’ll sort later. And |
| Event | Brief description (e. g.And g. Worth adding: | |
| Source | Link or citation (e. In practice, g. Consider this: , 00:12:35) | Use the Zapruder frame list as a reference; each frame is 1/18. 3 sec. , “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. But 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. Also, as you cross‑check with other sources, adjust up or down. Take this: 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 It's one of those things that adds up. That's the whole idea..
Easier said than done, but still worth knowing.
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. Also, ). Think about it: 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 Simple as that..
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 Not complicated — just consistent. Nothing fancy..
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 Took long enough..
Common Mistakes / What Most People Get Wrong
Even with a tidy spreadsheet, it’s easy to slip into bad habits Worth keeping that in mind..
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.
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.
3. Forgetting Version Control
Because the sheet is collaborative, multiple people may edit the same row. 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.
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. It’s tempting to export a PDF and call it a day. But the real value is in the ongoing updates—new FOIA releases, fresh eyewitness interviews, or even a newly digitized photo. Treat the sheet like a lab notebook: keep adding, revising, and questioning.
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 And that's really what it comes down to..
• make use of Google Sheets’ “Explore” Feature
Select a column (e.g., “Rifle Type”) and click the Explore button in the bottom right. Sheets will auto‑generate charts—great for spotting, say, how many sources mention a “Carcano” vs. a “Mannlicher And it works..
• Create a “Missing Data” Sheet
Add a tab titled “To‑Do.But ” 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 Less friction, more output..
• 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 Small thing, real impact. And it works..
• 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.
• 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 And that's really what it comes down to..
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/…” No workaround needed..
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. That's why 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. Consider this: grab a copy, set up your version history, and start plugging in the facts. Who knows? You might be the one to line up that missing piece and finally answer a question that’s haunted historians for six decades. Happy sleuthing Easy to understand, harder to ignore..
