Author SHA1 Message Date
kathleen cd618d37d3 Merge pull request 'Publish the built site to a pages branch for Ken's server' (#43) from infra/pages-branch into main
Publish the site (pages branch) / publish (push) Successful in 6s
CI / test (push) Successful in 40s
2026-11-19 16:37:04 +00:00
kathleenandClaude Opus 5.5 0ae29b5423 Publish the built site to a pages branch for Ken's server to serve (#27)
CI / test (pull_request) Successful in 39s
Every push to main builds the static site (npm run build -> dist/) and force-pushes it as the only commit of
the `pages` branch. Ken's web server serves that branch (a git-sync sidecar or a pull on a timer): nothing
on his server needs a secret, since the repository is public, and the site updates within minutes of every
merge, data PRs included.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01UCzTd31GphpMXDhQqWrCMQ
2026-11-19 16:36:08 +00:00
kathleen 0df6b8d473 Merge pull request 'Impossible runs: one definition, left out of the route model and the site statistics' (#42) from atlas/impossible-runs into main
Send the route model to the bot / send (push) Successful in 7s
CI / test (push) Successful in 2m8s
2026-11-19 16:32:10 +00:00
ekcSchianoandClaude Opus 5.5 46c1f00150 Impossible runs: one definition, left out of the route model and the site statistics (#21, #22)
CI / test (pull_request) Successful in 41s
- core/spec/form.yaml impossible_flags: the flags that mean a run cannot have happened as recorded (a dragon an
  encounter does not have, a Green or the Black in the valley, two bonds, two burns, a cadet path that does not
  follow, an early death that still reached the hour...). atlas.runs.impossible() reads it.
- The route model and the site statistics (and the riders' paths) leave those runs out, from every source; every
  other run is used, however partial. The runs stay in runs_clean.csv, flagged. 80 runs: 75 form, 5 Reddit.
  Route-model odds move by at most 0.2 points.
- collection/etl/runs.py: the community form gets the same game-rule checks as "Report a run" and the Reddit
  comments (10 form rows newly flagged); new rule: the Black in the valley.
- The first-sighting pool stays a flag only: it is what riders have seen, not a rule.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01UCzTd31GphpMXDhQqWrCMQ
2026-11-19 16:03:45 +00:00
kathleen ae370329e3 Merge pull request 'Infrastructure: stop the queued bot cycle, one source check at a time, track site/' (#41) from infra/settings into main
CI / test (push) Successful in 2m6s
2026-11-19 15:17:57 +00:00
kathleenandClaude Opus 5.5 5f080e0a82 Infrastructure: stop the queued bot cycle, one source check at a time, track site/ (#27)
CI / test (pull_request) Successful in 39s
- bot-cycle.yml: no schedule. It needs a runner on the bot's machine that no one has added, so every 4 hours
  a run queued forever. The bot's data already arrives through the daily source check (it reads
  DragonKind/DragonKind) and the model goes back through push-policy. Still runnable by hand.
- update-sources.yml: a concurrency group, so two dispatches never build and push at once.
- .gitignore: drop `/site` (a Python template's mkdocs line). site/ is the Atlas page; new files there were
  silently ignored.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01UCzTd31GphpMXDhQqWrCMQ
2026-11-19 15:16:59 +00:00
kathleen d0141f2d9c Merge pull request 'Reddit comments and the bot in the route model and the site odds; chosen deaths never count as failed bonds' (#40) from atlas/reddit-in-model into main
CI / test (push) Successful in 44s
Send the route model to the bot / send (push) Successful in 1m7s
2026-11-19 15:00:39 +00:00
ekcSchianoandClaude Opus 5.5 036c86a1d1 Site statistics: the bot's runs, every source labelled as itself, chosen deaths never counted as failed bonds
CI / test (pull_request) Successful in 39s
- analysis/stats/measures.yaml: the bot is a statistics source. A deliberate death (`_deliberate`, the route
  model's rule: burned at an encounter the rider was not attempting) is left out of every bond rate, encounter
  rate and route ranking, for every source, as the model and the summary cards already did. Biggest moves (all
  runs): two Greens 8.9% -> 29.1%, meadow Orange 9.2% -> 25.2%, meadow Brown 14.3% -> 28.3%, valley Red 79.2% ->
  93.3%; mostly from form riders who burned on purpose, not from the bot.
- analysis/stats/site_stats.py: runs that are not from the spreadsheet are grouped as their own source
  ("Reddit comments", "DragonKind bot", "Reported on the Atlas"), not as bulk logs; two new presets (Reddit
  comments only, DragonKind bot only); the route map's bond denominators skip deliberate deaths.
- site/atlas/app.js: the bulk-import share counts only spreadsheet imports.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01UCzTd31GphpMXDhQqWrCMQ
2026-11-19 14:58:17 +00:00
kathleen 99563a59ea Merge pull request 'Runs from the Reddit megathread comments' (#38) from data/reddit-comments into main
CI / test (push) Successful in 39s
2026-11-19 14:50:14 +00:00
ekcSchianoandClaude Opus 5.5 d606ed1651 Reddit comment runs in the route model and the odds; Black report gate wording; cite both megathreads
- planner/policy.yaml: `reddit comment` is a model source. Only runs that break a game rule (the rule_flags
  checks) are left out; partial runs are kept. Its own reporting-bias group, and out of the low-bias sample
  (riders posting a run pick the notable ones). 77 of the 82 runs are used.
- analysis/stats/measures.yaml: the site statistics use every source answered in the form's terms (form,
  "Report a run", Reddit comments).
- analysis/black/evidence.py: a shadow run is "off the gates" only when an answer contradicts a gate (3); runs
  that do not say are counted separately (14).
- croissant isBasedOn lists both megathreads (pipeline.yaml `cite`).
- Rebuilt: policy.json, stats.json, BLACK.md, black.json, croissant.json.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01UCzTd31GphpMXDhQqWrCMQ
2026-11-19 14:50:08 +00:00
ekcSchiano 75f11378e2 data: keep main's route model (Reddit comment runs are not a model source yet)
CI / test (pull_request) Successful in 2m13s
2026-11-19 09:45:17 -05:00
kathleenandClaude Opus 5.5 b82ef16a9f data: croissant checksum for the rebuilt runs_clean.csv
CI / test (pull_request) Successful in 2m2s
Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01UCzTd31GphpMXDhQqWrCMQ
2026-11-19 14:14:50 +00:00
kathleenandClaude Opus 5.5 e30825ec84 data: rebuild the Reddit comment runs with the game-rule checks from #37
CI / test (pull_request) Failing after 9s
6 of the 82 runs now carry rule flags (Brown/Red at the shadow, Green after
jumping on the Red, Red in the meadow, Orange first for Alone/Center, fight
answers on an ignored scream). Only their data_flags change.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01UCzTd31GphpMXDhQqWrCMQ
2026-11-19 14:14:16 +00:00
kathleen 93dab0b963 Merge branch 'main' into data/reddit-comments
CI / test (pull_request) Failing after 1m22s
2026-11-19 14:10:13 +00:00
kathleen fdb603f5a4 Merge pull request 'Game-rule checks for runs answered through "Report a run"' (#37) from data/report-rule-checks into main
CI / test (push) Successful in 41s
2026-11-19 14:10:08 +00:00
kathleen e06fd46e15 Merge pull request 'Known answers for the bot: the guide's encounter answers and the bot's own results, by choice text' (#39) from atlas/known-answers into main
Send the route model to the bot / send (push) Successful in 7s
CI / test (push) Successful in 1m58s
2026-11-19 14:00:17 +00:00
Atlas Reddit reader 7b0a01efb0 data: runs from the Reddit megathread comments
CI / test (pull_request) Successful in 39s
2026-11-19 08:57:59 -05:00
ekcSchianoandClaude Opus 5.5 e10312ab02 Known answers for the bot: the guide's encounter answers and the bot's own results, by choice text (#35)
CI / test (pull_request) Successful in 2m3s
analysis/known/build_known.py writes data/public/known_answers.json from pdf_encounters.json and tree.json;
solver.js knownAnswer(known, offered, { target, sceneColour }) matches a screen's choices against it (the guide's
paraphrases by their words, the bot's texts exactly) and returns a pick when one choice is clearly on the guide's
recommended path to the target, plus the evidence for every choice to hand to Clef. Rebuilt daily, checked in CI,
and sent to the bot with the route model.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01UCzTd31GphpMXDhQqWrCMQ
2026-11-19 13:32:09 +00:00
32 changed files with 2847 additions and 98 deletions
+4 -2
View File
@@ -10,9 +10,11 @@
# DK_ACCOUNT_SALT the salt account names are hashed with (the same one every time) # DK_ACCOUNT_SALT the salt account names are hashed with (the same one every time)
# ATLAS_BOT_TOKEN as in update-sources.yml # ATLAS_BOT_TOKEN as in update-sources.yml
name: Bot cycle name: Bot cycle
# Not scheduled: no runner has the `bot-host` label yet (issue #27), and the bot's data already arrives through the
# daily source check. Put the schedule back once Ken adds a runner on the bot's machine:
# schedule:
# - cron: "41 */4 * * *"
on: on:
schedule:
- cron: "41 */4 * * *"
workflow_dispatch: workflow_dispatch:
jobs: jobs:
cycle: cycle:
+37
View File
@@ -0,0 +1,37 @@
# The published Atlas page. Every push to main builds the static site (npm run build -> dist/) and force-pushes it
# as the single commit of the `pages` branch. Ken's server serves that branch as plain files (a web server whose
# folder is kept in step with the branch: a git-sync sidecar, or `git pull` on a timer). The repository is public,
# so his server needs no token. Only the build output is on `pages`, never the raw data.
#
# Secrets: ATLAS_BOT_TOKEN (as in update-sources.yml), to push the branch.
name: Publish the site (pages branch)
on:
push:
branches: [main]
workflow_dispatch:
concurrency:
group: pages
cancel-in-progress: true
jobs:
publish:
runs-on: ubuntu-latest
steps:
- uses: actions/checkout@v4
- uses: actions/setup-node@v4
with:
node-version: 20
- run: npm run build
- name: Push dist/ as the pages branch
env:
ATLAS_BOT_TOKEN: ${{ secrets.ATLAS_BOT_TOKEN }}
run: |
cd dist
git init -q -b pages
git config user.name "Atlas data bot"
git config user.email "atlas-bot@noreply.localhost"
git add -A
git commit -q -m "site built from ${GITHUB_SHA::8}"
GIT_CONFIG_COUNT=1 GIT_CONFIG_KEY_0="http.https://git.kenschiano.net/.extraheader" \
GIT_CONFIG_VALUE_0="AUTHORIZATION: token $ATLAS_BOT_TOKEN" \
git push -q -f "https://git.kenschiano.net/${GITHUB_REPOSITORY}.git" pages
echo "pages branch updated from ${GITHUB_SHA::8}"
+4 -3
View File
@@ -1,6 +1,6 @@
# When the route model changes on main, send it to the bot: open (or update) a pull request on the bot's repo, # When the route model changes on main, send it to the bot: open (or update) a pull request on the bot's repo,
# DragonKind/DragonKind, that replaces vendor/threshing-atlas/{policy.json,solver.js,graph.js} with this repo's # DragonKind/DragonKind, that replaces vendor/threshing-atlas/{policy.json,solver.js,graph.js,known_answers.json} with
# data/public/policy.json, core/solver.js and core/graph.js. The three always travel together, so the policy and the # this repo's data/public/policy.json, core/solver.js, core/graph.js and data/public/known_answers.json. They always travel together, so the policy and the
# solver that reads it never get out of step. Ken reviews and merges it; the running bot reloads the files after a pull. # solver that reads it never get out of step. Ken reviews and merges it; the running bot reloads the files after a pull.
# #
# Secrets: ATLAS_BOT_TOKEN (repository: read and write, with write access to DragonKind/DragonKind). # Secrets: ATLAS_BOT_TOKEN (repository: read and write, with write access to DragonKind/DragonKind).
@@ -12,6 +12,7 @@ on:
- data/public/policy.json - data/public/policy.json
- core/solver.js - core/solver.js
- core/graph.js - core/graph.js
- data/public/known_answers.json
workflow_dispatch: workflow_dispatch:
jobs: jobs:
send: send:
@@ -34,7 +35,7 @@ jobs:
GIT_CONFIG_VALUE_0="AUTHORIZATION: token $ATLAS_BOT_TOKEN" GIT_CONFIG_VALUE_0="AUTHORIZATION: token $ATLAS_BOT_TOKEN"
git clone --quiet --depth 1 https://git.kenschiano.net/DragonKind/DragonKind.git "$dst" git clone --quiet --depth 1 https://git.kenschiano.net/DragonKind/DragonKind.git "$dst"
mkdir -p "$dst/vendor/threshing-atlas" mkdir -p "$dst/vendor/threshing-atlas"
cp data/public/policy.json core/solver.js core/graph.js "$dst/vendor/threshing-atlas/" cp data/public/policy.json core/solver.js core/graph.js data/public/known_answers.json "$dst/vendor/threshing-atlas/"
id=$(python3 -c "import json; print(json.load(open('data/public/policy.json')).get('id', ''))") id=$(python3 -c "import json; print(json.load(open('data/public/policy.json')).get('id', ''))")
sha=$(git rev-parse --short HEAD) sha=$(git rev-parse --short HEAD)
cd "$dst" cd "$dst"
+4
View File
@@ -16,6 +16,10 @@ on:
schedule: schedule:
- cron: "23 10 * * *" # daily - cron: "23 10 * * *" # daily
workflow_dispatch: workflow_dispatch:
# one check at a time: a second dispatch waits instead of building and pushing alongside the first
concurrency:
group: update-sources
cancel-in-progress: false
jobs: jobs:
check: check:
runs-on: ubuntu-latest # a runner label on the server (act_runner) runs-on: ubuntu-latest # a runner label on the server (act_runner)
+1 -2
View File
@@ -166,8 +166,7 @@ venv.bak/
# Rope project settings # Rope project settings
.ropeproject .ropeproject
# mkdocs/Zensical documentation # (mkdocs' /site is not ignored: site/ here is the Atlas page)
/site
# mypy # mypy
.mypy_cache/ .mypy_cache/
+14 -3
View File
@@ -186,9 +186,20 @@ def build():
("combat_second", "The dagger"), ("resolution", "The bullies' fate"), ("post_path", "The fork")): ("combat_second", "The dagger"), ("resolution", "The bullies' fate"), ("post_path", "The fork")):
t = collections.Counter(r[col] for r in S1) t = collections.Counter(r[col] for r in S1)
L.append(f"- **{label}:** " + ", ".join(f"{k} {v}" for k, v in t.most_common())) L.append(f"- **{label}:** " + ", ".join(f"{k} {v}" for k, v in t.most_common()))
outside = [r for r in runs if r["saw_shadow"] and not (r["scream"] == "Investigate & help" and r["hour"] == "Tree")] # a gate counts as missed only when the run answers it otherwise; a run that does not say (a short Reddit
facts["shadow_routes"] = {"runs": len(S1), "routes": len({tuple(r[k] for k in ROUTE) for r in S1}), "off_gate": len(outside)} # comment, a blank form answer) is not a contradiction
L += ["", f"Shadows reported without both gates: {len(outside)} (likely mis-entered).", ""] def stated(v):
return bool(v) and v != "Unknown" and not str(v).startswith("(")
def contradicts(r):
return (stated(r["scream"]) and r["scream"] != "Investigate & help") or (stated(r["hour"]) and r["hour"] != "Tree")
outside = [r for r in runs if r["saw_shadow"] and contradicts(r)]
unstated = [r for r in runs if r["saw_shadow"] and not contradicts(r)
and not (r["scream"] == "Investigate & help" and r["hour"] == "Tree")]
facts["shadow_routes"] = {"runs": len(S1), "routes": len({tuple(r[k] for k in ROUTE) for r in S1}),
"off_gate": len(outside), "gates_unstated": len(unstated)}
L += ["", f"Shadows reported with an answer that contradicts a gate: {len(outside)} (likely mis-entered or misread). "
f"Another {len(unstated)} do not say whether they passed both gates.", ""]
# 5. after the shadow # 5. after the shadow
SH = [r for r in runs if r["saw_shadow"]] SH = [r for r in runs if r["saw_shadow"]]
+131
View File
@@ -0,0 +1,131 @@
"""Known answers: what the Atlas knows about every answer the bot can be offered, for screens its other sources don't
cover (issue #35). The bot looks the screen's choices up here first (solver.js `knownAnswer`), and passes what it finds
to Clef as evidence when nothing is certain.
python analysis/known/build_known.py [--check] -> data/public/known_answers.json
Two sources, keyed by the answer text normalised exactly as the bot does (collection/etl/transform/bot.py normalize):
guide every answer in the community route PDF's encounter trees (data/public/pdf_encounters.json): the
encounter, how it ends there (or "continues"), the guide's rate, whether the guide marks it unconfirmed,
and `on_path`: the colours whose recommended path in the guide goes through it
bot every answer in the bot's screen tree (data/public/tree.json): times played, times it died straight
after, and the bonds the runs that took it ended in
"""
import argparse
import json
import sys
from pathlib import Path
ROOT = Path(__file__).resolve().parents[2]
sys.path.insert(0, str(ROOT))
from collection.etl.transform.bot import normalize # noqa: E402
GUIDE = ROOT / "data/public/pdf_encounters.json"
TREE = ROOT / "data/public/tree.json"
OUT = ROOT / "data/public/known_answers.json"
# the colours each of the guide's encounters can end in a bond with (the two Greens can also end with an Orange or a
# Brown swooping in), and the encounter a colour's route continues to from there (the shadow leads on to the Black)
ENC_COLOURS = {"valley-Red": ["Red"], "tree-Red": ["Red"], "tree-Greens": ["Green", "Brown", "Orange"],
"meadow-Orange": ["Orange"], "meadow-Brown": ["Brown"], "meadow-Blue": ["Blue"],
"shadow": ["Black", "Blue"], "black": ["Black"]}
ONWARD = {("shadow", "Black"): "Black"}
def is_goal(end, colour, onward):
end = end or ""
if onward:
return end.startswith(f"On to the {onward}")
if not (end.startswith("Bonded") or "Bonded (" in end):
return False
return "(" not in end or colour in end
def leads_to(o, colour, onward):
if "end" in o:
return is_goal(o["end"], colour, onward)
return any(not c.get("roll") and leads_to(c, colour, onward) for c in o.get("then", []))
def guide_path(options, colour, onward):
"""The guide's recommended answers toward `colour` (the same walk as the page's encounter panel)."""
out, opts = [], options
while opts:
live = [o for o in opts if not o.get("roll")]
pick = next((o for o in live if o.get("best") and leads_to(o, colour, onward)), None) \
or next((o for o in live if leads_to(o, colour, onward)), None)
if not pick:
break
out.append(id(pick))
if "end" in pick:
break
opts = pick.get("then", [])
return out
def walk(options, enc, on_path, out):
"""Every answer of an encounter, with its colours (where it happens) and on_path (whose recommended path)."""
for o in options:
if o.get("roll"):
continue
entry = {"encounter": enc, "colours": ENC_COLOURS.get(enc, []), "end": o.get("end", "continues")}
if o.get("pct"):
entry["pct"] = o["pct"]
if o.get("best"):
entry["best"] = True
if o.get("unconfirmed"):
entry["unconfirmed"] = True
cols = sorted(c for c, ids in on_path.items() if id(o) in ids)
if cols:
entry["on_path"] = cols
for text in [s.strip() for s in o["say"].split(", or ")]: # "Jump on its back, or jump to land…"
out.setdefault(normalize(text), {"text": text, "guide": []})["guide"].append(entry)
walk(o.get("then", []), enc, on_path, out)
def build():
g = json.loads(GUIDE.read_text(encoding="utf-8"))
out = {}
for enc, E in g["encounters"].items():
on_path = {c: set(guide_path(E["options"], c, ONWARD.get((enc, c)))) for c in ENC_COLOURS.get(enc, [])}
walk(E["options"], enc, on_path, out)
t = json.loads(TREE.read_text(encoding="utf-8")) if TREE.exists() else {"screens": {}}
for sc in t["screens"].values():
for o in sc["options"].values():
if not o.get("n"):
continue
k = normalize(o["text"])
e = out.setdefault(k, {"text": o["text"], "guide": []})
b = e.setdefault("bot", {"n": 0, "died": 0, "bonded": {}})
b["n"] += o["n"]
for dest, d in o.get("to", {}).items():
if dest == "DIED":
b["died"] += d["n"]
elif dest.startswith("BONDED:"):
c = dest.split(":", 1)[1]
b["bonded"][c] = b["bonded"].get(c, 0) + d["n"]
for e in out.values():
if not e["guide"]:
del e["guide"]
src = g["source"]
return {"schema": 1, "guide": {"title": src["title"], "version": src["version"], "link": src["link"]},
"bot": {"runs": (t.get("builtFrom") or {}).get("runs")}, "answers": dict(sorted(out.items()))}
def main(argv=None):
ap = argparse.ArgumentParser(description=__doc__, formatter_class=argparse.RawDescriptionHelpFormatter)
ap.add_argument("--check", action="store_true")
a = ap.parse_args(argv)
text = json.dumps(build(), ensure_ascii=False, indent=1) + "\n"
if a.check:
if not OUT.exists() or OUT.read_text(encoding="utf-8") != text:
print(f"{OUT.relative_to(ROOT)} is out of date (run python analysis/known/build_known.py)", file=sys.stderr)
return 1
return 0
OUT.write_text(text, encoding="utf-8")
print(f"wrote {OUT.relative_to(ROOT)}")
return 0
if __name__ == "__main__":
sys.exit(main())
+3 -3
View File
@@ -56,14 +56,14 @@ The 97 form runs with a shadow (all attempts) took 47 different recorded routes:
- **The bullies' fate:** Squadmate's revenge 61, Left bullies to the dragons 25, Killed the bullies yourself 9, Unknown 2 - **The bullies' fate:** Squadmate's revenge 61, Left bullies to the dragons 25, Killed the bullies yourself 9, Unknown 2
- **The fork:** West 46, Forest 36, East 14, Unknown 1 - **The fork:** West 46, Forest 36, East 14, Unknown 1
Shadows reported without both gates: 3 (likely mis-entered). Shadows reported with an answer that contradicts a gate: 3 (likely mis-entered or misread). Another 14 do not say whether they passed both gates.
## 5. After the shadow: the Blue, then the Black ## 5. After the shadow: the Blue, then the Black
The riders' notes describe one sequence: follow the shadow, a Blue lands and burns another cadet, the Blue leaves, then the Black appears. The Blue is a trial on the way, not an alternative to the Black. The riders' notes describe one sequence: follow the shadow, a Blue lands and burns another cadet, the Blue leaves, then the Black appears. The Blue is a trial on the way, not an alternative to the Black.
- Runs that reached the Black: 79, bonded 57. - Runs that reached the Black: 89, bonded 65.
- Runs that died at the Blue: 16. What their notes say they did: approached the Blue 11, warned the other cadet / intervened 4. - Runs that died at the Blue: 19. What their notes say they did: approached the Blue 11, warned the other cadet / intervened 4.
- The answer given to the Black, where the note says (bonded / runs): held its gaze 29/41; lowered eyes 0/7; ignored the sound 0/1. - The answer given to the Black, where the note says (bonded / runs): held its gaze 29/41; lowered eyes 0/7; ignored the sound 0/1.
Holding its gaze is the only answer recorded with a bond, and it still fails about a quarter of the time. The developer says a rider who knows the system bonds with certainty, so those failures are not explained yet: the notes of the riders who died are too short to show what else they did differently. Holding its gaze is the only answer recorded with a bond, and it still fails about a quarter of the time. The developer says a rider who knows the system bonds with certainty, so those failures are not explained yet: the notes of the riders who died are too short to show what else they did differently.
+17 -13
View File
@@ -6,10 +6,12 @@
# (not blank), {any: [condition, ...]} (at least one). Several fields in one condition must all hold. # (not blank), {any: [condition, ...]} (at least one). Several fields in one condition must all hold.
version: 1 version: 1
# Which runs of data/public/runs_clean.csv the statistics use (its `source` column). Runs from the other sources # Which runs of data/public/runs_clean.csv the statistics use (its `source` column): every source that records the
# (reported, bot, Reddit result pages) are in the published file but not in these statistics yet: they are coded # route (the community form, "Report a run", the Reddit megathread comments, the DragonKind bot). The Reddit result
# from different questions, and the bot follows a strategy, so pooling them needs its own review. # pages and the register record only the end, so they stay out. The bot plays to a strategy and burns on purpose at
sources: [reddit spreadsheet] # encounters it is not chasing: like every rider's deliberate death (`_deliberate`, the route model's rule), those
# burns are left out of the bond rates, never counted as failed bonds.
sources: [reddit spreadsheet, reported, reddit comment, bot]
colours: [Red, Green, Orange, Brown, Blue, Black] colours: [Red, Green, Orange, Brown, Blue, Black]
@@ -25,7 +27,7 @@ outcomes:
event: { saw_shadow: true } event: { saw_shadow: true }
bond_blue_meadow: bond_blue_meadow:
label: Bond, given you approached the meadow Blue label: Bond, given you approached the meadow Blue
denom: { branch: "Passed the Red: meadow", enc_Blue: { in: ["Bonded!", "Incinerated"] } } denom: { branch: "Passed the Red: meadow", enc_Blue: { in: ["Bonded!", "Incinerated"] }, _deliberate: { not: true } }
event: { enc_Blue: "Bonded!" } event: { enc_Blue: "Bonded!" }
reach_hour: reach_hour:
label: Survive to the hour (tree/valley choice) label: Survive to the hour (tree/valley choice)
@@ -34,7 +36,7 @@ outcomes:
# one more outcome per colour: "Run ends bonded to <colour>", among runs that reached the hour # one more outcome per colour: "Run ends bonded to <colour>", among runs that reached the hour
bonded_outcome: bonded_outcome:
label: Run ends bonded to {colour} label: Run ends bonded to {colour}
denom: { hour: { in: [Tree, Valley] } } denom: { hour: { in: [Tree, Valley] }, _deliberate: { not: true } }
event: { outcome: Bonded, outcome_color: "{colour}" } event: { outcome: Bonded, outcome_color: "{colour}" }
# Factors compared in the factor tables (each answer against the other answers to the same question) # Factors compared in the factor tables (each answer against the other answers to the same question)
@@ -43,15 +45,15 @@ factors: [company, direction, first_sighting, scream, resolution, combat_first,
# Route targets: the outcome (event) and which runs could have reached it at all (pool) # Route targets: the outcome (event) and which runs could have reached it at all (pool)
targets: targets:
bond_Blue: { label: Bond Blue, colour: Blue, event: { outcome: Bonded, outcome_color: Blue }, pool: { hour: Valley } } bond_Blue: { label: Bond Blue, colour: Blue, event: { outcome: Bonded, outcome_color: Blue }, pool: { hour: Valley, _deliberate: { not: true } } }
bond_Black: { label: Bond Black, colour: Black, event: { outcome: Bonded, outcome_color: Black }, pool: { hour: Tree } } bond_Black: { label: Bond Black, colour: Black, event: { outcome: Bonded, outcome_color: Black }, pool: { hour: Tree, _deliberate: { not: true } } }
see_Blue: { label: Meet a Blue (meadow), colour: Blue, event: { saw_blue_meadow: true }, pool: { branch: "Passed the Red: meadow" } } see_Blue: { label: Meet a Blue (meadow), colour: Blue, event: { saw_blue_meadow: true }, pool: { branch: "Passed the Red: meadow" } }
see_shadow: { label: Get the tree shadow, colour: Black, event: { saw_shadow: true }, pool: { hour: Tree, branch: { exists: true } } } see_shadow: { label: Get the tree shadow, colour: Black, event: { saw_shadow: true }, pool: { hour: Tree, branch: { exists: true } } }
bond_Red: { label: Bond Red, colour: Red, event: { outcome: Bonded, outcome_color: Red }, pool: { hour: { in: [Tree, Valley] } } } bond_Red: { label: Bond Red, colour: Red, event: { outcome: Bonded, outcome_color: Red }, pool: { hour: { in: [Tree, Valley] }, _deliberate: { not: true } } }
bond_Green: { label: Bond Green, colour: Green, event: { outcome: Bonded, outcome_color: Green }, pool: { hour: Tree } } bond_Green: { label: Bond Green, colour: Green, event: { outcome: Bonded, outcome_color: Green }, pool: { hour: Tree, _deliberate: { not: true } } }
bond_Orange: { label: Bond Orange, colour: Orange, event: { outcome: Bonded, outcome_color: Orange }, pool: { hour: { in: [Tree, Valley] } } } bond_Orange: { label: Bond Orange, colour: Orange, event: { outcome: Bonded, outcome_color: Orange }, pool: { hour: { in: [Tree, Valley] }, _deliberate: { not: true } } }
bond_Brown: { label: Bond Brown, colour: Brown, event: { outcome: Bonded, outcome_color: Brown }, pool: { hour: { in: [Tree, Valley] } } } bond_Brown: { label: Bond Brown, colour: Brown, event: { outcome: Bonded, outcome_color: Brown }, pool: { hour: { in: [Tree, Valley] }, _deliberate: { not: true } } }
bond_any: { label: Bond any dragon, colour: null, event: { outcome: Bonded }, pool: { hour: { in: [Tree, Valley] } } } bond_any: { label: Bond any dragon, colour: null, event: { outcome: Bonded }, pool: { hour: { in: [Tree, Valley] }, _deliberate: { not: true } } }
# Bonding encounters: which recorded attempt (column) belongs to which in-game encounter (where) # Bonding encounters: which recorded attempt (column) belongs to which in-game encounter (where)
encounters: encounters:
@@ -80,6 +82,8 @@ presets:
all: { label: All runs, filters: { source: all, goal: all, excludeFlagged: false } } all: { label: All runs, filters: { source: all, goal: all, excludeFlagged: false } }
form: { label: Form submissions only, filters: { source: form, goal: all, excludeFlagged: false } } form: { label: Form submissions only, filters: { source: form, goal: all, excludeFlagged: false } }
bulk: { label: Bulk logs only (imports), filters: { source: bulk, goal: all, excludeFlagged: false } } bulk: { label: Bulk logs only (imports), filters: { source: bulk, goal: all, excludeFlagged: false } }
reddit: { label: Reddit comments only, filters: { source: reddit, goal: all, excludeFlagged: false } }
bot: { label: DragonKind bot only, filters: { source: bot, goal: all, excludeFlagged: false } }
not_chasing: { label: Not chasing Blue/Black, filters: { source: all, goal: exclude_rare, excludeFlagged: false } } not_chasing: { label: Not chasing Blue/Black, filters: { source: all, goal: exclude_rare, excludeFlagged: false } }
chasing: { label: Chasing Blue/Black, filters: { source: all, goal: only_rare, excludeFlagged: false } } chasing: { label: Chasing Blue/Black, filters: { source: all, goal: only_rare, excludeFlagged: false } }
unflagged: { label: Rows without data-quality flags, filters: { source: all, goal: all, excludeFlagged: true } } unflagged: { label: Rows without data-quality flags, filters: { source: all, goal: all, excludeFlagged: true } }
+36 -10
View File
@@ -95,7 +95,18 @@ def is_rare(goal):
return goal in M["rare_goals"] return goal in M["rare_goals"]
# sources other than the community spreadsheet: their own group wherever runs are split by where they came from
SOURCE_LABEL = {"reddit comment": "Reddit comments", "bot": "DragonKind bot", "reported": "Reported on the Atlas"}
def entry_group(r):
"""Where a run came from: the spreadsheet's entry type (Form, Data Import, ...) or the source's own label."""
return SOURCE_LABEL.get(r["source"]) or r["entry"]
def stratum(r): def stratum(r):
if r["source"] in SOURCE_LABEL:
return SOURCE_LABEL[r["source"]]
if r["entry"] != "Form": if r["entry"] != "Form":
return "Bulk logs (imports)" return "Bulk logs (imports)"
g = r["goal"] g = r["goal"]
@@ -108,9 +119,14 @@ def goal2(r):
def apply_filters(runs, f): def apply_filters(runs, f):
def ok(r): def ok(r):
if f.get("source") == "form" and r["entry"] != "Form": sheet = r["source"] == "reddit spreadsheet"
if f.get("source") == "form" and not (sheet and r["entry"] == "Form"):
return False return False
if f.get("source") == "bulk" and r["entry"] == "Form": if f.get("source") == "bulk" and not (sheet and r["entry"] != "Form"):
return False
if f.get("source") == "reddit" and r["source"] != "reddit comment":
return False
if f.get("source") == "bot" and r["source"] != "bot":
return False return False
if f.get("goal") == "exclude_rare" and is_rare(r["goal"]): if f.get("goal") == "exclude_rare" and is_rare(r["goal"]):
return False return False
@@ -197,7 +213,7 @@ def analyse(all_runs, filters):
dates = sorted(r["date"] for r in runs if r.get("date")) dates = sorted(r["date"] for r in runs if r.get("date"))
outs = group_by(runs, lambda r: r["outcome"] + (" " + r["outcome_color"] if r.get("outcome_color") else "")) outs = group_by(runs, lambda r: r["outcome"] + (" " + r["outcome_color"] if r.get("outcome_color") else ""))
res["meta"] = { res["meta"] = {
"sources": {k: len(v) for k, v in group_by(runs, "entry").items()}, "sources": {k: len(v) for k, v in group_by(runs, entry_group).items()},
"date_min": dates[0] if dates else None, "date_max": dates[-1] if dates else None, "date_min": dates[0] if dates else None, "date_max": dates[-1] if dates else None,
"n_flagged": sum(1 for r in runs if r["data_flags"]), "flag_counts": flag_counts, "n_flagged": sum(1 for r in runs if r["data_flags"]), "flag_counts": flag_counts,
"outcomes": {k: len(v) for k, v in outs.items()}, "outcomes": {k: len(v) for k, v in outs.items()},
@@ -220,13 +236,14 @@ def analyse(all_runs, filters):
res["encounters"] = [] res["encounters"] = []
for e in M["encounters"]: for e in M["encounters"]:
col, colour = e["column"], e["colour"] col, colour = e["column"], e["colour"]
A = [r for r in runs if match(r, e["where"]) and r.get(col) in ("Bonded!", "Incinerated")] # a rider who chose to burn here (chasing another colour) did not fail this encounter
A = [r for r in runs if match(r, e["where"]) and r.get(col) in ("Bonded!", "Incinerated") and not r.get("_deliberate")]
win = lambda r, col=col: r.get(col) == "Bonded!" # noqa: E731 win = lambda r, col=col: r.get(col) == "Bonded!" # noqa: E731
intent = [r for r in A if r["goal"] == colour or r["goal"].startswith("Any") or (r["goal"] == "Blue or Black" and colour in ("Blue", "Black"))] intent = [r for r in A if r["goal"] == colour or r["goal"].startswith("Any") or (r["goal"] == "Blue or Black" and colour in ("Blue", "Black"))]
res["encounters"].append({"context": e["context"], "color": colour, "overall": rate(A, win), "intent_matched": rate(intent, win), res["encounters"].append({"context": e["context"], "color": colour, "overall": rate(A, win), "intent_matched": rate(intent, win),
"by_stratum": {s: rate(g, win) for s, g in sorted(group_by(A, stratum).items())}}) "by_stratum": {s: rate(g, win) for s, g in sorted(group_by(A, stratum).items())}})
greens_where = next(e["where"] for e in M["encounters"] if e["colour"] == "Green") greens_where = next(e["where"] for e in M["encounters"] if e["colour"] == "Green")
greens = [r for r in runs if match(r, greens_where) and r.get("enc_Green")] greens = [r for r in runs if match(r, greens_where) and r.get("enc_Green") and not r.get("_deliberate")]
g = {"green_encounters": len(greens), g = {"green_encounters": len(greens),
"bonded_green": sum(1 for r in greens if r["enc_Green"] == "Bonded!"), "bonded_green": sum(1 for r in greens if r["enc_Green"] == "Bonded!"),
"rescued_orange": sum(1 for r in greens if r["rescued"] and r.get("outcome_color") == "Orange"), "rescued_orange": sum(1 for r in greens if r["rescued"] and r.get("outcome_color") == "Orange"),
@@ -240,7 +257,7 @@ def analyse(all_runs, filters):
first2 = lambda r: r["first_sighting"] if r["first_sighting"] in ("Red", "Brown", "Orange", "Green") else None # noqa: E731 first2 = lambda r: r["first_sighting"] if r["first_sighting"] in ("Red", "Brown", "Orange", "Green") else None # noqa: E731
known = lambda f: (lambda r: None if is_missing(r.get(f)) else r[f]) # noqa: E731 known = lambda f: (lambda r: None if is_missing(r.get(f)) else r[f]) # noqa: E731
src2 = lambda r: "Form submission" if r["entry"] == "Form" else "Bulk log (import)" # noqa: E731 src2 = lambda r: SOURCE_LABEL.get(r["source"]) or ("Form submission" if r["entry"] == "Form" else "Bulk log (import)") # noqa: E731
res["models"] = { res["models"] = {
"blue_meadow": fit_model(runs, "blue_meadow", {"source": src2, "goal": goal2, "direction": known("direction"), "blue_meadow": fit_model(runs, "blue_meadow", {"source": src2, "goal": goal2, "direction": known("direction"),
"first_sighting": first2, "resolution": known("resolution"), "company": known("company")}), "first_sighting": first2, "resolution": known("resolution"), "company": known("company")}),
@@ -257,7 +274,7 @@ def analyse(all_runs, filters):
"blue": W(bk, len(m)), "shadow": W(sk, len(t))}) "blue": W(bk, len(m)), "shadow": W(sk, len(t))})
res["source_rates"] = {key: {s: rate([r for r in g if match(r, OUTCOMES[key]["denom"])], lambda r, k=key: match(r, OUTCOMES[k]["event"])) res["source_rates"] = {key: {s: rate([r for r in g if match(r, OUTCOMES[key]["denom"])], lambda r, k=key: match(r, OUTCOMES[k]["event"]))
for s, g in group_by(runs, "entry").items()} for key in ("blue_meadow", "shadow")} for s, g in group_by(runs, entry_group).items()} for key in ("blue_meadow", "shadow")}
return res return res
@@ -302,9 +319,11 @@ def route_map(runs):
"""The route map: nodes and links with run counts, and for every target the hits and their Wilson interval.""" """The route map: nodes and links with run counts, and for every target the hits and their Wilson interval."""
nodes, links = {}, {} nodes, links = {}, {}
hits = {t: {} for t in TARGETS} hits = {t: {} for t in TARGETS}
tries = {t: {} for t in TARGETS} # runs that count for the target (no deliberate deaths for a bond)
for r in runs: for r in runs:
prev = None prev = None
hit = {t: match(r, T["event"]) for t, T in TARGETS.items()} hit = {t: match(r, T["event"]) for t, T in TARGETS.items()}
counts = {t: not (r.get("_deliberate") and t.startswith("bond_")) for t in TARGETS}
for si, s in enumerate(STAGES): for si, s in enumerate(STAGES):
v = stage_value(r, s["key"]) v = stage_value(r, s["key"])
if v is None: if v is None:
@@ -314,15 +333,18 @@ def route_map(runs):
nd["n"] += 1 nd["n"] += 1
for t in TARGETS: for t in TARGETS:
hits[t][nid] = hits[t].get(nid, 0) + hit[t] hits[t][nid] = hits[t].get(nid, 0) + hit[t]
tries[t][nid] = tries[t].get(nid, 0) + counts[t]
if prev: if prev:
lid = prev + "→" + nid lid = prev + "→" + nid
ln = links.setdefault(lid, {"id": lid, "source": prev, "target": nid, "n": 0, "chance": bool(s.get("chance"))}) ln = links.setdefault(lid, {"id": lid, "source": prev, "target": nid, "n": 0, "chance": bool(s.get("chance"))})
ln["n"] += 1 ln["n"] += 1
for t in TARGETS: for t in TARGETS:
hits[t][lid] = hits[t].get(lid, 0) + hit[t] hits[t][lid] = hits[t].get(lid, 0) + hit[t]
tries[t][lid] = tries[t].get(lid, 0) + counts[t]
prev = nid prev = nid
nl, ll = list(nodes.values()), list(links.values()) nl, ll = list(nodes.values()), list(links.values())
by_target = {t: {"nodes": [W(hits[t][n["id"]], n["n"]) for n in nl], "links": [W(hits[t][l["id"]], l["n"]) for l in ll]} for t in TARGETS} by_target = {t: {"nodes": [W(hits[t][n["id"]], tries[t][n["id"]]) for n in nl],
"links": [W(hits[t][l["id"]], tries[t][l["id"]]) for l in ll]} for t in TARGETS}
return {"nodes": nl, "links": ll, "by_target": by_target} return {"nodes": nl, "links": ll, "by_target": by_target}
@@ -550,8 +572,12 @@ def main(argv=None):
ap.add_argument("--data", default=str(runs_io.PATH)) ap.add_argument("--data", default=str(runs_io.PATH))
ap.add_argument("--out", default=str(ROOT / "data/public/stats.json")) ap.add_argument("--out", default=str(ROOT / "data/public/stats.json"))
a = ap.parse_args(argv) a = ap.parse_args(argv)
runs = runs_io.read(a.data, sources=M["sources"]) # a run that cannot have happened as recorded (core/spec/form.yaml impossible_flags) is left out, as in the model
out = build(runs, len(runs), exported(), every_run=runs_io.read(a.data)) runs = [r for r in runs_io.read(a.data, sources=M["sources"]) if not runs_io.impossible(r)]
for r in runs:
r["_deliberate"] = deliberate(r)
every = [r for r in runs_io.read(a.data) if not runs_io.impossible(r)]
out = build(runs, len(runs), exported(), every_run=every)
Path(a.out).write_text(json.dumps(out, separators=(",", ":"), ensure_ascii=False), encoding="utf-8") Path(a.out).write_text(json.dumps(out, separators=(",", ":"), ensure_ascii=False), encoding="utf-8")
print(f"{a.out}: {len(runs)} runs, {len(out['presets'])} presets, {Path(a.out).stat().st_size / 1e6:.1f} MB") print(f"{a.out}: {len(runs)} runs, {len(out['presets'])} presets, {Path(a.out).stat().st_size / 1e6:.1f} MB")
+1
View File
@@ -87,6 +87,7 @@ def rebuild():
_step("experiment plan", [py, "planner/build_experiments.py"]) _step("experiment plan", [py, "planner/build_experiments.py"])
_step("what the runs show about the Black", [py, "analysis/black/evidence.py"]) _step("what the runs show about the Black", [py, "analysis/black/evidence.py"])
_step("screen tree", [py, "analysis/tree/build_tree.py"]) _step("screen tree", [py, "analysis/tree/build_tree.py"])
_step("known answers for the bot (guide + screen tree)", [py, "analysis/known/build_known.py"])
try: try:
import scipy # noqa: F401 import scipy # noqa: F401
_step("statistics", [py, "analysis/stats/site_stats.py"]) _step("statistics", [py, "analysis/stats/site_stats.py"])
+4 -1
View File
@@ -112,10 +112,13 @@ def build(dictionary=None):
"citeAs": ds["citation"].format(repository=forge.repo_url(fg)), "citeAs": ds["citation"].format(repository=forge.repo_url(fg)),
"isLiveDataset": True, "isLiveDataset": True,
"isBasedOn": [ "isBasedOn": [
{"@type": "sc:CreativeWork", "name": s["label"], "url": next(iter(s["links"].values()))} {"@type": "sc:CreativeWork", "url": s["links"][k],
"name": s["label"] + (f" ({k.replace('part', 'part ')})" if len(s.get("cite") or ()) > 1 else "")}
for s in sources.values() for s in sources.values()
# the route PDF is only fingerprinted, never redistributed; the bot's repo is private # the route PDF is only fingerprinted, never redistributed; the bot's repo is private
if (s.get("privacy") or {}).get("redistribute", True) and s.get("links") if (s.get("privacy") or {}).get("redistribute", True) and s.get("links")
# `cite` (collection/pipeline.yaml) names the links the source is based on; default: the first link
for k in (s.get("cite") or [next(iter(s["links"]))])
], ],
"distribution": distribution, "distribution": distribution,
"recordSet": [ "recordSet": [
+8 -2
View File
@@ -52,7 +52,8 @@ def encounter_columns(row, intentional=False):
# ---------------------------------------------------------------- coders, by pipeline.yaml `runs:` # ---------------------------------------------------------------- coders, by pipeline.yaml `runs:`
def spreadsheet(name, spec): def spreadsheet(name, spec):
"""The community form: core/spec/form.yaml + core/atlas/coding.py, unchanged.""" """The community form: core/spec/form.yaml + core/atlas/coding.py, plus the game-rule checks every source that
answers the form's questions gets (rule_flags; a flag the coder already set is not repeated)."""
from atlas import coding from atlas import coding
df, missing = coding.code_frame(coding.read_export(path(spec["load"]))) df, missing = coding.code_frame(coding.read_export(path(spec["load"])))
if missing: if missing:
@@ -62,7 +63,10 @@ def spreadsheet(name, spec):
for rec in df.astype(object).where(df.notna(), None).to_dict("records"): for rec in df.astype(object).where(df.notna(), None).to_dict("records"):
n = rec.pop("run_id") n = rec.pop("run_id")
entry = rec.pop("source") entry = rec.pop("source")
rows.append({**{c: None for c in COLUMNS}, **rec, "run_id": f"sheet-{n}", "source": spec["run_source"], "entry": entry}) row = {**{c: None for c in COLUMNS}, **rec, "run_id": f"sheet-{n}", "source": spec["run_source"], "entry": entry}
have = [f for f in (row["data_flags"] or "").split("; ") if f]
row["data_flags"] = "; ".join(have + [f for f in rule_flags(row) if f not in have])
rows.append(row)
return rows return rows
@@ -231,6 +235,8 @@ def rule_flags(row):
flags.append(f"{colour} at the {branch} encounter, which has only {'/'.join(sorted(enc_colours[branch]))}") flags.append(f"{colour} at the {branch} encounter, which has only {'/'.join(sorted(enc_colours[branch]))}")
if row["hour"] == "Valley" and colour == "Green": if row["hour"] == "Valley" and colour == "Green":
flags.append("Green recorded on a Valley run (no Greens in the valley)") flags.append("Green recorded on a Valley run (no Greens in the valley)")
if row["hour"] == "Valley" and colour == "Black":
flags.append("Black recorded on a Valley run (the Black is only reached from the tree)")
scream, res = row["scream"], row["resolution"] scream, res = row["scream"], row["resolution"]
if scream in ("Investigate & help", "Ignore the scream", "Investigate & leave"): if scream in ("Investigate & help", "Ignore the scream", "Investigate & leave"):
if res in CADET_PATH and CADET_PATH[res] != scream: if res in CADET_PATH and CADET_PATH[res] != scream:
+2
View File
@@ -57,6 +57,7 @@ sources:
runs: null # a flowchart of the routes, not a log of runs (see collection/README.md) runs: null # a flowchart of the routes, not a log of runs (see collection/README.md)
reddit_thread: reddit_thread:
cite: [part3, part4] # both megathreads, in the dataset's isBasedOn
label: Runs posted in the r/fourthwing Dragonkind megathreads label: Runs posted in the r/fourthwing Dragonkind megathreads
run_source: reddit thread run_source: reddit thread
links: links:
@@ -70,6 +71,7 @@ sources:
runs: reddit_results runs: reddit_results
reddit_comments: reddit_comments:
cite: [part3, part4] # both megathreads, in the dataset's isBasedOn
label: Runs riders describe in the r/fourthwing Dragonkind megathread comments label: Runs riders describe in the r/fourthwing Dragonkind megathread comments
run_source: reddit comment run_source: reddit comment
links: links:
+7
View File
@@ -25,6 +25,13 @@ def _parse(col, v):
return v return v
def impossible(r):
"""A run that cannot have happened as recorded: one of its flags is in core/spec/form.yaml impossible_flags."""
from . import spec
rules = spec.form()["impossible_flags"]
return any(rule in f for f in (r.get("data_flags") or "").split("; ") for rule in rules)
def read(path=PATH, sources=None, drop=("run_id",)): def read(path=PATH, sources=None, drop=("run_id",)):
"""Typed records, optionally only from some sources (the `source` column).""" """Typed records, optionally only from some sources (the `source` column)."""
with open(path, encoding="utf-8", newline="") as f: with open(path, encoding="utf-8", newline="") as f:
+64 -1
View File
@@ -15,6 +15,9 @@
* shadow odds), `fix` (hold some decisions to given options: an experiment arm) and sampling "uniform" (mapping); * shadow odds), `fix` (hold some decisions to given options: an experiment arm) and sampling "uniform" (mapping);
* assign(plan, { accountSeq, attempt }) reads the experiment plan (experiments.json) and says what an attempt is for; * assign(plan, { accountSeq, attempt }) reads the experiment plan (experiments.json) and says what an attempt is for;
* screenPick(tree, sceneId, offered, { mode }) picks from the screen tree (tree.json): least-tried, or Thompson. * screenPick(tree, sceneId, offered, { mode }) picks from the screen tree (tree.json): least-tried, or Thompson.
* knownAnswer(known, offered, { target, sceneColour }) looks a screen's choices up in known_answers.json (the guide's
* encounter answers and the bot's own results) for screens nothing else covers: a pick when the evidence is clear,
* and the evidence for every choice either way, to hand to Clef (issue #35).
* UMD: window.ThreshSolver in the browser, module.exports in Node. No dependencies. * UMD: window.ThreshSolver in the browser, module.exports in Node. No dependencies.
*/ */
(function (root, factory) { (function (root, factory) {
@@ -446,8 +449,68 @@
reason: mode === "thompson" ? `survived ${pick.survived} of ${pick.n} so far` : `played ${pick.n} times, the fewest on this screen` }; reason: mode === "thompson" ? `survived ${pick.survived} of ${pick.n} so far` : `played ${pick.n} times, the fewest on this screen` };
} }
/* ---------- known answers (analysis/known/build_known.py -> data/public/known_answers.json) ---------- */
const STOP = new Set("a an the to and or of your you its it is for at in on with this that be".split(" "));
const words = (t) => norm(t).split(" ").filter((w) => w && !STOP.has(w));
/** The guide labels a game text carries: the guide paraphrases ("Touch its talon"), the game says it in full ("Reach a
* hand slowly to touch its talon"), so a label matches when every word of it that matters is in the text. Labels of
* fewer than two such words ("Is your dragon") only match a text that is exactly the label. */
function guideMatches(known, text) {
const n = norm(text), have = new Set(words(text)), out = [];
for (const [k, e] of Object.entries(known.answers || {})) {
if (!e.guide) continue;
const w = words(e.text);
const exact = k === n;
if (exact || (w.length >= 2 && w.every((x) => have.has(x)))) e.guide.forEach((g) => out.push({ ...g, label: e.text, exact }));
}
return out;
}
/**
* A screen nothing else covers: what the Atlas knows about each choice, and a pick when it is clear.
* known data/public/known_answers.json
* offered the choice texts on screen, in order
* target the colour the account is after ("Blue"); sceneColour: the colour of this scene's dragon, if the
* bot knows it (only the guide's answers for that dragon's encounters are used then)
* Returns { pick, confidence, reason, choices }: pick is the index to take (null if nothing is clear), confidence
* "strong" (exactly one choice is on the guide's recommended path toward the target, and the bot's own runs don't
* contradict it) or "weak" (several fit, or only the bot's own record speaks for it). choices[i].verdict is "good",
* "bad" (the guide ends it in incineration, or the bot died on it at least 3 times in 4) or "unknown", with the
* evidence behind it. Anything weak or unknown goes to Clef with this evidence; a pick never skips the bot's guard.
*/
function knownAnswer(known, offered, { target, sceneColour = null } = {}) {
const T = target ? target[0].toUpperCase() + target.slice(1).toLowerCase() : null;
const choices = offered.map((text, index) => {
const e = (known.answers || {})[norm(text)] || {};
const bot = e.bot || null;
const guide = guideMatches(known, text).filter((g) => !sceneColour || (g.colours || []).includes(sceneColour));
const onPath = guide.filter((g) => T && (g.on_path || []).includes(T));
const botBad = bot && bot.n >= 2 && bot.died / bot.n >= 0.75;
const botGood = bot && bot.n >= 3 && bot.died === 0;
const guideBad = guide.length > 0 && guide.every((g) => /^Incinerated/.test(g.end));
const verdict = onPath.length && !botBad ? "good" : guideBad || botBad ? "bad" : "unknown";
return { index, text, verdict, guide, bot, onPath: onPath.length > 0, botGood: !!botGood };
});
const good = choices.filter((c) => c.verdict === "good");
let pick = null, confidence = null, reason = "nothing the Atlas knows covers these choices";
if (good.length === 1) {
pick = good[0].index; confidence = "strong";
reason = `on the guide's recommended path to the ${T} ("${good[0].onPath && good[0].guide.find((g) => (g.on_path || []).includes(T)).label}")`;
} else if (good.length > 1) {
const best = good.find((c) => c.botGood) || good[0];
pick = best.index; confidence = "weak"; reason = `${good.length} choices are on the guide's paths; the bot's record favours none clearly`;
} else {
const safe = choices.filter((c) => c.botGood && c.verdict !== "bad");
if (safe.length) {
const b = safe.reduce((x, y) => (y.bot.n > x.bot.n ? y : x));
pick = b.index; confidence = "weak"; reason = `the bot got through it ${b.bot.n} of ${b.bot.n} times`;
}
}
return { pick, confidence, reason, choices };
}
return Object.assign(api, { return Object.assign(api, {
advisor, recommendOption, solverHistory, norm, assign, armFor, givenFor, screenPick, advisor, recommendOption, solverHistory, norm, assign, armFor, givenFor, screenPick, knownAnswer,
makeParams: (T, { alphas, game } = {}) => makeParams(T, { alphas, game: game || api.game }), makeParams: (T, { alphas, game } = {}) => makeParams(T, { alphas, game: game || api.game }),
/** remember the game of a policy sample (sets ENCOUNTERS) without solving anything */ /** remember the game of a policy sample (sets ENCOUNTERS) without solving anything */
useGame(sample) { api.game = sample.model.game; api.ENCOUNTERS = api.game.by_colour; return api.game; }, useGame(sample) { api.game = sample.model.game; api.ENCOUNTERS = api.game.by_colour; return api.game; },
+20
View File
@@ -156,6 +156,26 @@ sighting_pool:
# The dragons each bonding encounter can end with (bond or burn), from the community PDF. Only used to FLAG runs # The dragons each bonding encounter can end with (bond or burn), from the community PDF. Only used to FLAG runs
# answered through "Report a run" (reported, reddit comment) that end with a dragon the encounter does not have. # answered through "Report a run" (reported, reddit comment) that end with a dragon the encounter does not have.
# Orange and Brown after the two Greens: a Green's rescue, then the Orange or Brown. # Orange and Brown after the two Greens: a Green's rescue, then the Orange or Brown.
# Flags (data_flags, matched as text inside a flag) that mean a run cannot have happened as recorded: the game's own
# rules, from the form coder (core/atlas/coding.py) and the checks of collection/etl/runs.py rule_flags. A run with one
# is kept in runs_clean.csv, flagged, and left out of the route model and the site statistics (atlas.runs.impossible).
# Everything else, however partial, is used. Not here on purpose: a first sighting outside the documented pool (the
# pool is what riders have seen, not a rule), a missing direction, several wings, a missing Green before a rescue.
impossible_flags:
- "Green recorded on a Valley run"
- "Black recorded on a Valley run"
- "encounter, which has only"
- "more than one dragon marked Bonded"
- "more than one dragon marked Incinerated"
- "tree run with both the Red and the two Greens attempted"
- "died in combat on a path without combat"
- "rare-dragon answer does not match the path"
- "does not follow"
- "fight answers on a run that did not help"
- "a path after the fight on a run without a fight"
- "a second fight move without pausing to assess"
- "died before the hour, yet reached"
encounter_colours: encounter_colours:
"Shadow (rare)": [Blue, Black] "Shadow (rare)": [Blue, Black]
"Descend quickly: Red": [Red] "Descend quickly: Red": [Red]
+28 -18
View File
@@ -66,23 +66,33 @@
"isBasedOn": [ "isBasedOn": [
{ {
"@type": "sc:CreativeWork", "@type": "sc:CreativeWork",
"name": "Threshing Routes form and spreadsheet (u/ClumsyBadger, linked from the r/fourthwing megathreads)", "url": "https://docs.google.com/spreadsheets/d/1gnw1AdRg1XT4JsOfRM6QTA0jSaS3n9ZF-rPWnYewzv0",
"url": "https://docs.google.com/spreadsheets/d/1gnw1AdRg1XT4JsOfRM6QTA0jSaS3n9ZF-rPWnYewzv0" "name": "Threshing Routes form and spreadsheet (u/ClumsyBadger, linked from the r/fourthwing megathreads)"
}, },
{ {
"@type": "sc:CreativeWork", "@type": "sc:CreativeWork",
"name": "Unofficial Dragon Register (which dragon each rider bonded)", "url": "https://docs.google.com/spreadsheets/d/1KMiE9sec0l597Pzue1OhGYf07NF4howtQ_lPeqx7jXQ",
"url": "https://docs.google.com/spreadsheets/d/1KMiE9sec0l597Pzue1OhGYf07NF4howtQ_lPeqx7jXQ" "name": "Unofficial Dragon Register (which dragon each rider bonded)"
}, },
{ {
"@type": "sc:CreativeWork", "@type": "sc:CreativeWork",
"name": "Runs posted in the r/fourthwing Dragonkind megathreads", "url": "https://www.reddit.com/r/fourthwing/comments/1wvwfp9/",
"url": "https://www.reddit.com/r/fourthwing/comments/1wvwfp9/" "name": "Runs posted in the r/fourthwing Dragonkind megathreads (part 3)"
}, },
{ {
"@type": "sc:CreativeWork", "@type": "sc:CreativeWork",
"name": "Runs riders describe in the r/fourthwing Dragonkind megathread comments", "url": "https://www.reddit.com/r/fourthwing/comments/1wz5cnj/",
"url": "https://www.reddit.com/r/fourthwing/comments/1wvwfp9/" "name": "Runs posted in the r/fourthwing Dragonkind megathreads (part 4)"
},
{
"@type": "sc:CreativeWork",
"url": "https://www.reddit.com/r/fourthwing/comments/1wvwfp9/",
"name": "Runs riders describe in the r/fourthwing Dragonkind megathread comments (part 3)"
},
{
"@type": "sc:CreativeWork",
"url": "https://www.reddit.com/r/fourthwing/comments/1wz5cnj/",
"name": "Runs riders describe in the r/fourthwing Dragonkind megathread comments (part 4)"
} }
], ],
"distribution": [ "distribution": [
@@ -93,8 +103,8 @@
"description": "Every run from every source, one per row, coded into the same columns (collection/etl/runs.py; the form's rules are core/spec/form.yaml). The `source` column says where each run came from.", "description": "Every run from every source, one per row, coded into the same columns (collection/etl/runs.py; the form's rules are core/spec/form.yaml). The `source` column says where each run came from.",
"contentUrl": "https://git.kenschiano.net/DragonKind/threshing-atlas/raw/branch/main/data/public/runs_clean.csv", "contentUrl": "https://git.kenschiano.net/DragonKind/threshing-atlas/raw/branch/main/data/public/runs_clean.csv",
"encodingFormat": "text/csv", "encodingFormat": "text/csv",
"sha256": "e1cb9c0c0ab525c9fab393844ca00aaa6bbafa470c348f5035779c6b303b1137", "sha256": "b5e121cf5deab5f8bc1420b34a5bc434d6f933c7452e200eed4891c35de45122",
"contentSize": "3720698 B" "contentSize": "3748768 B"
}, },
{ {
"@type": "cr:FileObject", "@type": "cr:FileObject",
@@ -113,8 +123,8 @@
"description": "Runs described in the r/fourthwing megathread comments, read into the \"Report a run\" answers: comment id, day and answers only, no usernames or comment text.", "description": "Runs described in the r/fourthwing megathread comments, read into the \"Report a run\" answers: comment id, day and answers only, no usernames or comment text.",
"contentUrl": "https://git.kenschiano.net/DragonKind/threshing-atlas/raw/branch/main/data/public/reddit_comments.json", "contentUrl": "https://git.kenschiano.net/DragonKind/threshing-atlas/raw/branch/main/data/public/reddit_comments.json",
"encodingFormat": "application/json", "encodingFormat": "application/json",
"sha256": "c180f8b82ed1119d4ff28697fcf45d0c7f22859597cd10f5e82a2e50ca1dc51a", "sha256": "b169d157e731db23c99f2f8317a9718d31801b7d64336b3d414511ac13f32493",
"contentSize": "105 B" "contentSize": "23174 B"
}, },
{ {
"@type": "cr:FileObject", "@type": "cr:FileObject",
@@ -143,8 +153,8 @@
"description": "Every number the Atlas page shows, for six filter presets (analysis/stats/site_stats.py; what is measured is analysis/stats/measures.yaml).", "description": "Every number the Atlas page shows, for six filter presets (analysis/stats/site_stats.py; what is measured is analysis/stats/measures.yaml).",
"contentUrl": "https://git.kenschiano.net/DragonKind/threshing-atlas/raw/branch/main/data/public/stats.json", "contentUrl": "https://git.kenschiano.net/DragonKind/threshing-atlas/raw/branch/main/data/public/stats.json",
"encodingFormat": "application/json", "encodingFormat": "application/json",
"sha256": "01047d7f9404d689eb688d04d6473d4705de84b112f0671464d4bcef46a49596", "sha256": "89a6246da2495685733e20f2de9897299bd19d469aaeadbd8883972856787ce5",
"contentSize": "5496605 B" "contentSize": "5151910 B"
}, },
{ {
"@type": "cr:FileObject", "@type": "cr:FileObject",
@@ -153,8 +163,8 @@
"description": "The route model: the game (core/spec/game.yaml), the count tables behind every roll, and the best decision tree for every dragon colour under two goals, with posterior intervals (planner/build_policy.py).", "description": "The route model: the game (core/spec/game.yaml), the count tables behind every roll, and the best decision tree for every dragon colour under two goals, with posterior intervals (planner/build_policy.py).",
"contentUrl": "https://git.kenschiano.net/DragonKind/threshing-atlas/raw/branch/main/data/public/policy.json", "contentUrl": "https://git.kenschiano.net/DragonKind/threshing-atlas/raw/branch/main/data/public/policy.json",
"encodingFormat": "application/json", "encodingFormat": "application/json",
"sha256": "f65aaebb23cb3f56dad0387a94113857eb44c4ba077cfe5fc6215c202546588c", "sha256": "eec67140c63f028d31553be4f2310d92c9378293488aecd73a41ba1700b9e646",
"contentSize": "987411 B" "contentSize": "987412 B"
}, },
{ {
"@type": "cr:FileObject", "@type": "cr:FileObject",
@@ -163,8 +173,8 @@
"description": "The route graph over every run in runs_clean.csv, counted per source (analysis/network/build-graph.js).", "description": "The route graph over every run in runs_clean.csv, counted per source (analysis/network/build-graph.js).",
"contentUrl": "https://git.kenschiano.net/DragonKind/threshing-atlas/raw/branch/main/data/public/graph.json", "contentUrl": "https://git.kenschiano.net/DragonKind/threshing-atlas/raw/branch/main/data/public/graph.json",
"encodingFormat": "application/json", "encodingFormat": "application/json",
"sha256": "3b11d237468198458453a6066d69d85f5b3bef99e58241bb83a4ab313e3e2969", "sha256": "f9d1a86f84fcc10ef906af686ce624355ffd729440460288406ba97177ff05da",
"contentSize": "75548 B" "contentSize": "84575 B"
} }
], ],
"recordSet": [ "recordSet": [
+5 -4
View File
@@ -116,12 +116,13 @@
"shadow_routes": { "shadow_routes": {
"runs": 97, "runs": 97,
"routes": 47, "routes": 47,
"off_gate": 3 "off_gate": 3,
"gates_unstated": 14
}, },
"after_shadow": { "after_shadow": {
"reached_black": 79, "reached_black": 89,
"bonded_black": 57, "bonded_black": 65,
"died_at_blue": 16, "died_at_blue": 19,
"answers": { "answers": {
"held its gaze": [ "held its gaze": [
29, 29,
File diff suppressed because one or more lines are too long
File diff suppressed because it is too large Load Diff
File diff suppressed because one or more lines are too long
File diff suppressed because one or more lines are too long
+92 -10
View File
@@ -1181,7 +1181,7 @@ sheet-1135,reddit spreadsheet,Form,,2026-10-09,First,Tail,Third,4,Later attempt,
sheet-1136,reddit spreadsheet,Form,,2026-10-09,Multiple,,Second,,Later attempt,Blue or Black,Alone,False,East,Orange,Unknown,Investigate & help,Left bullies to the dragons,Assess the situation,(not recorded),Forest,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Unknown,,multiple wings,jump on its back, sheet-1136,reddit spreadsheet,Form,,2026-10-09,Multiple,,Second,,Later attempt,Blue or Black,Alone,False,East,Orange,Unknown,Investigate & help,Left bullies to the dragons,Assess the situation,(not recorded),Forest,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Unknown,,multiple wings,jump on its back,
sheet-1137,reddit spreadsheet,Form,,2026-10-09,Third,Claw,First,1,First attempt,Any (for fun),Alone,False,Center,Green,Unknown,Ignore the scream,Tourniquet,(not recorded),(not recorded),(no fork),Tree,Descend slowly: two Greens,,Incinerated,,,,,Incinerated,Green,False,False,False,No,Unknown,,first sighting Green not in documented pool for Alone/Center,looking down and letting them choose, sheet-1137,reddit spreadsheet,Form,,2026-10-09,Third,Claw,First,1,First attempt,Any (for fun),Alone,False,Center,Green,Unknown,Ignore the scream,Tourniquet,(not recorded),(not recorded),(no fork),Tree,Descend slowly: two Greens,,Incinerated,,,,,Incinerated,Green,False,False,False,No,Unknown,,first sighting Green not in documented pool for Alone/Center,looking down and letting them choose,
sheet-1138,reddit spreadsheet,Form,,2026-10-09,Third,Flame,Third,,Unknown,Blue or Black,Alone,False,East,Orange,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),Forest,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Unknown,,,jump on its back, sheet-1138,reddit spreadsheet,Form,,2026-10-09,Third,Flame,Third,,Unknown,Blue or Black,Alone,False,East,Orange,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),Forest,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Unknown,,,jump on its back,
sheet-1139,reddit spreadsheet,Form,,2026-10-09,Second,Claw,Third,,Later attempt,Blue or Black,Alone,False,West,Green,Unknown,Ignore the scream,Took their weapons,(not recorded),(not recorded),(no fork),Valley,Passed the Red: meadow,,Incinerated,Incinerated,,,,Incinerated,Green,False,False,False,No,Unknown,,Green recorded on a Valley run (no Greens in the valley); more than one dragon marked Incinerated,Ran, sheet-1139,reddit spreadsheet,Form,,2026-10-09,Second,Claw,Third,,Later attempt,Blue or Black,Alone,False,West,Green,Unknown,Ignore the scream,Took their weapons,(not recorded),(not recorded),(no fork),Valley,Passed the Red: meadow,,Incinerated,Incinerated,,,,Incinerated,Green,False,False,False,No,Unknown,,"Green recorded on a Valley run (no Greens in the valley); more than one dragon marked Incinerated; Green at the Passed the Red: meadow encounter, which has only Blue/Brown/Orange",Ran,
sheet-1140,reddit spreadsheet,Form,,2026-10-09,First,Tail,Second,,Later attempt,Blue or Black,Alone,False,Center,Red,Unknown,Investigate & help,Squadmate's revenge,Assess the situation,(not recorded),Forest,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Unknown,,,Descended quickly > jumped on its back > lowered gaze, sheet-1140,reddit spreadsheet,Form,,2026-10-09,First,Tail,Second,,Later attempt,Blue or Black,Alone,False,Center,Red,Unknown,Investigate & help,Squadmate's revenge,Assess the situation,(not recorded),Forest,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Unknown,,,Descended quickly > jumped on its back > lowered gaze,
sheet-1141,reddit spreadsheet,Form,,2026-10-09,Second,Tail,Third,,Later attempt,Blue or Black,Alone,False,Center,Red,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),Forest,Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Unknown,,,Run away - Trying to bond a blue here, sheet-1141,reddit spreadsheet,Form,,2026-10-09,Second,Tail,Third,,Later attempt,Blue or Black,Alone,False,Center,Red,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),Forest,Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Unknown,,,Run away - Trying to bond a blue here,
sheet-1142,reddit spreadsheet,Form,,2026-10-09,Second,Tail,Third,,Later attempt,Blue or Black,Alone,False,Center,Brown,Unknown,Investigate & help,Squadmate's revenge,Assess the situation,(not recorded),Forest,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Unknown,,,Jump now onto the red - Trying to bond a blue here, sheet-1142,reddit spreadsheet,Form,,2026-10-09,Second,Tail,Third,,Later attempt,Blue or Black,Alone,False,Center,Brown,Unknown,Investigate & help,Squadmate's revenge,Assess the situation,(not recorded),Forest,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Unknown,,,Jump now onto the red - Trying to bond a blue here,
@@ -1668,7 +1668,7 @@ sheet-1586,reddit spreadsheet,Form,,2026-10-14,First,Tail,Third,,Later attempt,A
sheet-1587,reddit spreadsheet,Form,,2026-10-14,First,Tail,Third,1,First attempt,Any (for fun),Alone,False,Center,Red,Unknown,Investigate & help,Left bullies to the dragons,Even the numbers (smaller cadet),(not recorded),Forest,Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Unknown,,,Roar, sheet-1587,reddit spreadsheet,Form,,2026-10-14,First,Tail,Third,1,First attempt,Any (for fun),Alone,False,Center,Red,Unknown,Investigate & help,Left bullies to the dragons,Even the numbers (smaller cadet),(not recorded),Forest,Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Unknown,,,Roar,
sheet-1588,reddit spreadsheet,Form,,2026-10-14,Second,Claw,Second,,Later attempt,Blue or Black,Alone,False,Center,Brown,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),Forest,Valley,Passed the Red: meadow,,,,,Incinerated,,Incinerated,Blue,False,True,False,Blue (valley),No,,,Hold glare and watch, sheet-1588,reddit spreadsheet,Form,,2026-10-14,Second,Claw,Second,,Later attempt,Blue or Black,Alone,False,Center,Brown,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),Forest,Valley,Passed the Red: meadow,,,,,Incinerated,,Incinerated,Blue,False,True,False,Blue (valley),No,,,Hold glare and watch,
sheet-1589,reddit spreadsheet,Form,,2026-10-14,Fourth,Claw,First,,Later attempt,Blue or Black,Alone,False,Center,Red,Unknown,Ignore the scream,Tourniquet,(not recorded),(not recorded),(no fork),Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Unknown,,,try brown instead, sheet-1589,reddit spreadsheet,Form,,2026-10-14,Fourth,Claw,First,,Later attempt,Blue or Black,Alone,False,Center,Red,Unknown,Ignore the scream,Tourniquet,(not recorded),(not recorded),(no fork),Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Unknown,,,try brown instead,
sheet-1590,reddit spreadsheet,Form,,2026-10-14,First,Tail,Third,,Later attempt,Blue or Black,Alone,False,East,Red,Unknown,Ignore the scream,Took their weapons,(not recorded),(not recorded),(no fork),Tree,Descend slowly: two Greens,Incinerated,Changed my mind,,,,,Incinerated,Red,False,False,False,No,Unknown,,tree run with both the Red and the two Greens attempted,Jumping beside Red's tail, sheet-1590,reddit spreadsheet,Form,,2026-10-14,First,Tail,Third,,Later attempt,Blue or Black,Alone,False,East,Red,Unknown,Ignore the scream,Took their weapons,(not recorded),(not recorded),(no fork),Tree,Descend slowly: two Greens,Incinerated,Changed my mind,,,,,Incinerated,Red,False,False,False,No,Unknown,,"tree run with both the Red and the two Greens attempted; Red at the Descend slowly: two Greens encounter, which has only Brown/Green/Orange",Jumping beside Red's tail,
sheet-1591,reddit spreadsheet,Form,,2026-10-14,Fourth,Claw,Second,31,Later attempt,Blue or Black,Alone,False,Center,Brown,Unknown,Ignore the scream,Tourniquet,(not recorded),(not recorded),(no fork),Valley,Passed the Red: meadow,,,,,Incinerated,,Incinerated,Blue,False,True,False,Blue (valley),No,,,"Died doing nothing when blue grabbed the cadet, followed right path and still died (again)", sheet-1591,reddit spreadsheet,Form,,2026-10-14,Fourth,Claw,Second,31,Later attempt,Blue or Black,Alone,False,Center,Brown,Unknown,Ignore the scream,Tourniquet,(not recorded),(not recorded),(no fork),Valley,Passed the Red: meadow,,,,,Incinerated,,Incinerated,Blue,False,True,False,Blue (valley),No,,,"Died doing nothing when blue grabbed the cadet, followed right path and still died (again)",
sheet-1592,reddit spreadsheet,Form,,2026-10-14,First,Claw,First,,Later attempt,Blue or Black,Alone,False,West,Brown,Unknown,Investigate & help,Squadmate's revenge,Assess the situation,(not recorded),Forest,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Unknown,,,jumped on its back, sheet-1592,reddit spreadsheet,Form,,2026-10-14,First,Claw,First,,Later attempt,Blue or Black,Alone,False,West,Brown,Unknown,Investigate & help,Squadmate's revenge,Assess the situation,(not recorded),Forest,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Unknown,,,jumped on its back,
sheet-1593,reddit spreadsheet,Form,,2026-10-14,Third,Flame,First,,Later attempt,Blue or Black,Alone,False,West,Brown,Unknown,Investigate & help,Squadmate's revenge,Assess the situation,(not recorded),Forest,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Unknown,,,"successfully landed on its back, but then lowered eyes and was still scorched", sheet-1593,reddit spreadsheet,Form,,2026-10-14,Third,Flame,First,,Later attempt,Blue or Black,Alone,False,West,Brown,Unknown,Investigate & help,Squadmate's revenge,Assess the situation,(not recorded),Forest,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Unknown,,,"successfully landed on its back, but then lowered eyes and was still scorched",
@@ -1707,7 +1707,7 @@ sheet-1625,reddit spreadsheet,Form,,2026-10-14,Third,Claw,Second,,Later attempt,
sheet-1626,reddit spreadsheet,Form,,2026-10-14,Third,Claw,Second,,Later attempt,Blue or Black,Alone,False,East,Red,Unknown,Unknown,Unknown,(not recorded),(not recorded),,Valley,Passed the Red: meadow,,,,,Bonded!,,Bonded,Blue,False,True,False,Blue (valley),Unknown,,,,Absolutely- hold glare and advance- do nothing- hold glare and watch- straighten- launch yourself- bring down- move slowly sheet-1626,reddit spreadsheet,Form,,2026-10-14,Third,Claw,Second,,Later attempt,Blue or Black,Alone,False,East,Red,Unknown,Unknown,Unknown,(not recorded),(not recorded),,Valley,Passed the Red: meadow,,,,,Bonded!,,Bonded,Blue,False,True,False,Blue (valley),Unknown,,,,Absolutely- hold glare and advance- do nothing- hold glare and watch- straighten- launch yourself- bring down- move slowly
sheet-1627,reddit spreadsheet,Form,,2026-10-14,Second,Claw,Don't know,1,First attempt,Any (for fun),Alone,False,Center,Red,Unknown,Investigate & help,DIED in combat,Put yourself in the middle (bigger cadet),(not recorded),,,,,,,,,,Died before the hour,,False,False,False,No,Unknown,,,, sheet-1627,reddit spreadsheet,Form,,2026-10-14,Second,Claw,Don't know,1,First attempt,Any (for fun),Alone,False,Center,Red,Unknown,Investigate & help,DIED in combat,Put yourself in the middle (bigger cadet),(not recorded),,,,,,,,,,Died before the hour,,False,False,False,No,Unknown,,,,
sheet-1628,reddit spreadsheet,Form,,2026-10-14,Second,Claw,Don't know,2,Later attempt,Any (for fun),Alone,False,Center,Red,Unknown,Investigate & help,Left bullies to the dragons,Assess the situation,(not recorded),Forest,Valley,Valley Red,Bonded!,,,,,,Bonded,Red,False,False,False,No,No,,,, sheet-1628,reddit spreadsheet,Form,,2026-10-14,Second,Claw,Don't know,2,Later attempt,Any (for fun),Alone,False,Center,Red,Unknown,Investigate & help,Left bullies to the dragons,Assess the situation,(not recorded),Forest,Valley,Valley Red,Bonded!,,,,,,Bonded,Red,False,False,False,No,No,,,,
sheet-1629,reddit spreadsheet,Form,,2026-10-14,First,Flame,Second,,Later attempt,Any (for fun),Alone,False,Center,Unsure,Unknown,Ignore the scream,Left injured cadet,(not recorded),(not recorded),(no fork),Valley,Passed the Red: meadow,,Incinerated,Incinerated,,,,Incinerated,Green,False,False,False,No,Unknown,,direction taken from the older sighting column; Green recorded on a Valley run (no Greens in the valley); more than one dragon marked Incinerated,Running away, sheet-1629,reddit spreadsheet,Form,,2026-10-14,First,Flame,Second,,Later attempt,Any (for fun),Alone,False,Center,Unsure,Unknown,Ignore the scream,Left injured cadet,(not recorded),(not recorded),(no fork),Valley,Passed the Red: meadow,,Incinerated,Incinerated,,,,Incinerated,Green,False,False,False,No,Unknown,,"direction taken from the older sighting column; Green recorded on a Valley run (no Greens in the valley); more than one dragon marked Incinerated; Green at the Passed the Red: meadow encounter, which has only Blue/Brown/Orange",Running away,
sheet-1630,reddit spreadsheet,Form,,2026-10-14,Fourth,Tail,First,2,Later attempt,Blue or Black,Alone,False,East,Red,Unknown,Ignore the scream,Tourniquet,(not recorded),(not recorded),(no fork),Tree,Descend slowly: two Greens,,Incinerated,,,,,Incinerated,Green,False,False,False,No,Unknown,,,I turned left, sheet-1630,reddit spreadsheet,Form,,2026-10-14,Fourth,Tail,First,2,Later attempt,Blue or Black,Alone,False,East,Red,Unknown,Ignore the scream,Tourniquet,(not recorded),(not recorded),(no fork),Tree,Descend slowly: two Greens,,Incinerated,,,,,Incinerated,Green,False,False,False,No,Unknown,,,I turned left,
sheet-1631,reddit spreadsheet,Form,,2026-10-14,First,Tail,Second,,Later attempt,Any (for fun),Alone,False,Center,Orange,Unknown,Ignore the scream,Left injured cadet,(not recorded),(not recorded),(no fork),Valley,Passed the Red: meadow,,,,Incinerated,,,Incinerated,Brown,False,False,False,No,Unknown,,first sighting Orange not in documented pool for Alone/Center,"Dragon flicked mud at me, I chose to flick it back", sheet-1631,reddit spreadsheet,Form,,2026-10-14,First,Tail,Second,,Later attempt,Any (for fun),Alone,False,Center,Orange,Unknown,Ignore the scream,Left injured cadet,(not recorded),(not recorded),(no fork),Valley,Passed the Red: meadow,,,,Incinerated,,,Incinerated,Brown,False,False,False,No,Unknown,,first sighting Orange not in documented pool for Alone/Center,"Dragon flicked mud at me, I chose to flick it back",
sheet-1632,reddit spreadsheet,Form,,2026-10-14,Third,Tail,Third,,Later attempt,Blue or Black,Unknown,False,East,Orange,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),East,Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Unknown,,,ran. no blue, sheet-1632,reddit spreadsheet,Form,,2026-10-14,Third,Tail,Third,,Later attempt,Blue or Black,Unknown,False,East,Orange,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),East,Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Unknown,,,ran. no blue,
@@ -1995,7 +1995,7 @@ sheet-1892,reddit spreadsheet,Form,,2026-10-18,Third,Flame,First,,Later attempt,
sheet-1893,reddit spreadsheet,Form,,2026-10-18,Fourth,Claw,Third,5,Later attempt,Any (for fun),Alone,False,East,Red,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),East,Valley,Passed the Red: meadow,,,Bonded!,,,,Bonded,Orange,False,False,False,No,No,,,,"Do not approach the red dragon who incinerated someone else. When you get to choose Brown vs Orange, choose Orange. He will roar at you. Roar back! (Really!) He will then spread his talons. Take it as an invitation to mount and you will bond :)" sheet-1893,reddit spreadsheet,Form,,2026-10-18,Fourth,Claw,Third,5,Later attempt,Any (for fun),Alone,False,East,Red,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),East,Valley,Passed the Red: meadow,,,Bonded!,,,,Bonded,Orange,False,False,False,No,No,,,,"Do not approach the red dragon who incinerated someone else. When you get to choose Brown vs Orange, choose Orange. He will roar at you. Roar back! (Really!) He will then spread his talons. Take it as an invitation to mount and you will bond :)"
sheet-1894,reddit spreadsheet,Form,,2026-10-18,Second,Claw,First,,Later attempt,Blue or Black,Alone,False,Center,Red,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),Forest,Valley,Passed the Red: meadow,,,,,Incinerated,,Incinerated,Blue,False,True,False,Blue (valley),No,,,"Hold glare and advance, do nothing, hold glare and watch, straighten spine, instantly incinerated", sheet-1894,reddit spreadsheet,Form,,2026-10-18,Second,Claw,First,,Later attempt,Blue or Black,Alone,False,Center,Red,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),Forest,Valley,Passed the Red: meadow,,,,,Incinerated,,Incinerated,Blue,False,True,False,Blue (valley),No,,,"Hold glare and advance, do nothing, hold glare and watch, straighten spine, instantly incinerated",
sheet-1895,reddit spreadsheet,Form,,2026-10-18,First,Don't know,Don't know,,Later attempt,Blue or Black,Alone,False,Center,Red,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),Forest,Valley,,,Saved by another,,,,,No outcome recorded,,False,False,False,No,Unknown,,Green recorded on a Valley run (no Greens in the valley),,"Told the two greens (took the left one) that I'm always right even if I'm not, green tried to burn me, orange swept in" sheet-1895,reddit spreadsheet,Form,,2026-10-18,First,Don't know,Don't know,,Later attempt,Blue or Black,Alone,False,Center,Red,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),Forest,Valley,,,Saved by another,,,,,No outcome recorded,,False,False,False,No,Unknown,,Green recorded on a Valley run (no Greens in the valley),,"Told the two greens (took the left one) that I'm always right even if I'm not, green tried to burn me, orange swept in"
sheet-1896,reddit spreadsheet,Form,,2026-10-18,Second,Claw,Third,,Later attempt,Blue or Black,Alone,False,West,Green,Unknown,Investigate & help,Squadmate's revenge,Assess the situation,(not recorded),East,Valley,Valley Red,Incinerated,Incinerated,,,,,Incinerated,Green,False,False,False,No,Unknown,,Green recorded on a Valley run (no Greens in the valley); more than one dragon marked Incinerated,lowered eyes, sheet-1896,reddit spreadsheet,Form,,2026-10-18,Second,Claw,Third,,Later attempt,Blue or Black,Alone,False,West,Green,Unknown,Investigate & help,Squadmate's revenge,Assess the situation,(not recorded),East,Valley,Valley Red,Incinerated,Incinerated,,,,,Incinerated,Green,False,False,False,No,Unknown,,"Green recorded on a Valley run (no Greens in the valley); more than one dragon marked Incinerated; Green at the Valley Red encounter, which has only Red",lowered eyes,
sheet-1897,reddit spreadsheet,Form,,2026-10-18,Fourth,Flame,First,,Later attempt,Blue or Black,Alone,False,West,Green,Unknown,Investigate & help,Killed the bullies yourself,Even the numbers (smaller cadet),(not recorded),East,Valley,Passed the Red: meadow,,,,,Bonded!,,Bonded,Blue,False,True,False,Blue (valley),Unknown,,,,Followed the Google PDF for the Blue sheet-1897,reddit spreadsheet,Form,,2026-10-18,Fourth,Flame,First,,Later attempt,Blue or Black,Alone,False,West,Green,Unknown,Investigate & help,Killed the bullies yourself,Even the numbers (smaller cadet),(not recorded),East,Valley,Passed the Red: meadow,,,,,Bonded!,,Bonded,Blue,False,True,False,Blue (valley),Unknown,,,,Followed the Google PDF for the Blue
sheet-1898,reddit spreadsheet,Form,,2026-10-18,Fourth,Claw,First,,Later attempt,Blue or Black,Alone,False,East,Orange,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),East,Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Unknown,,,nvm go for brown, sheet-1898,reddit spreadsheet,Form,,2026-10-18,Fourth,Claw,First,,Later attempt,Blue or Black,Alone,False,East,Orange,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),East,Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Unknown,,,nvm go for brown,
sheet-1899,reddit spreadsheet,Form,,2026-10-18,First,Claw,Third,,Later attempt,Blue or Black,Alone,False,Center,Brown,Unknown,Ignore the scream,Left injured cadet,(not recorded),(not recorded),(no fork),Valley,Passed the Red: meadow,,,,,Bonded!,,Bonded,Blue,False,True,False,Blue (valley),Unknown,,,,Followed the pdf dark shaded route exactly (absolutely>hold glare>do nothing>hold glare and watch>straighten>launch right>bring down an empire>move slowly forward> bonded!!!!) sheet-1899,reddit spreadsheet,Form,,2026-10-18,First,Claw,Third,,Later attempt,Blue or Black,Alone,False,Center,Brown,Unknown,Ignore the scream,Left injured cadet,(not recorded),(not recorded),(no fork),Valley,Passed the Red: meadow,,,,,Bonded!,,Bonded,Blue,False,True,False,Blue (valley),Unknown,,,,Followed the pdf dark shaded route exactly (absolutely>hold glare>do nothing>hold glare and watch>straighten>launch right>bring down an empire>move slowly forward> bonded!!!!)
@@ -2031,7 +2031,7 @@ sheet-1928,reddit spreadsheet,Form,,2026-10-19,First,Flame,Third,,Later attempt,
sheet-1929,reddit spreadsheet,Form,,2026-10-19,Fourth,Flame,Third,,Later attempt,Blue or Black,Alone,False,Center,Brown,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),Forest,Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Unknown,,,run! intentional death, sheet-1929,reddit spreadsheet,Form,,2026-10-19,Fourth,Flame,Third,,Later attempt,Blue or Black,Alone,False,Center,Brown,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),Forest,Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Unknown,,,run! intentional death,
sheet-1930,reddit spreadsheet,Form,,2026-10-19,First,Flame,Third,,Later attempt,Blue or Black,Alone,False,Center,Brown,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),East,Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Unknown,,,run! intentional death, sheet-1930,reddit spreadsheet,Form,,2026-10-19,First,Flame,Third,,Later attempt,Blue or Black,Alone,False,Center,Brown,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),East,Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Unknown,,,run! intentional death,
sheet-1931,reddit spreadsheet,Form,,2026-10-19,Fourth,Flame,Third,,Later attempt,Blue or Black,Alone,False,Center,Brown,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),Forest,Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Unknown,,,run! intentional death, sheet-1931,reddit spreadsheet,Form,,2026-10-19,Fourth,Flame,Third,,Later attempt,Blue or Black,Alone,False,Center,Brown,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),Forest,Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Unknown,,,run! intentional death,
sheet-1932,reddit spreadsheet,Form,,2026-10-19,Fourth,Claw,First,5,Later attempt,Any (for fun),Alone,False,East,Orange,Unknown,Investigate & leave,Left them to it,(not recorded),(not recorded),(no fork),Valley,Passed the Red: meadow,,Bonded!,,Changed my mind,,,Bonded,Green,False,False,False,No,No,,Green recorded on a Valley run (no Greens in the valley),,"Mount on foreleg, hit the ground and hoped its claw misses" sheet-1932,reddit spreadsheet,Form,,2026-10-19,Fourth,Claw,First,5,Later attempt,Any (for fun),Alone,False,East,Orange,Unknown,Investigate & leave,Left them to it,(not recorded),(not recorded),(no fork),Valley,Passed the Red: meadow,,Bonded!,,Changed my mind,,,Bonded,Green,False,False,False,No,No,,"Green recorded on a Valley run (no Greens in the valley); Green at the Passed the Red: meadow encounter, which has only Blue/Brown/Orange",,"Mount on foreleg, hit the ground and hoped its claw misses"
sheet-1933,reddit spreadsheet,Form,,2026-10-19,First,Flame,Third,,Later attempt,Blue or Black,Alone,False,Center,Brown,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),Forest,Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Unknown,,,run! intentional death, sheet-1933,reddit spreadsheet,Form,,2026-10-19,First,Flame,Third,,Later attempt,Blue or Black,Alone,False,Center,Brown,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),Forest,Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Unknown,,,run! intentional death,
sheet-1934,reddit spreadsheet,Form,,2026-10-19,Fourth,Flame,Third,,Later attempt,Blue or Black,Alone,False,Center,Brown,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),Forest,Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Unknown,,,run! intentional death, sheet-1934,reddit spreadsheet,Form,,2026-10-19,Fourth,Flame,Third,,Later attempt,Blue or Black,Alone,False,Center,Brown,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),Forest,Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Unknown,,,run! intentional death,
sheet-1935,reddit spreadsheet,Form,,2026-10-19,Fourth,Flame,Third,,Later attempt,Blue or Black,Alone,False,Center,Brown,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),Forest,Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Unknown,,,run! intentional death, sheet-1935,reddit spreadsheet,Form,,2026-10-19,Fourth,Flame,Third,,Later attempt,Blue or Black,Alone,False,Center,Brown,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),Forest,Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Unknown,,,run! intentional death,
@@ -2350,7 +2350,7 @@ sheet-2238,reddit spreadsheet,Form,,2026-10-21,First,Flame,Second,2,Later attemp
sheet-2239,reddit spreadsheet,Form,,2026-10-21,Fourth,Claw,First,,Later attempt,Blue or Black,Alone,False,East,Orange,Unknown,Ignore the scream,Tourniquet,(not recorded),(not recorded),(no fork),Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Yes,,,a nice brown, sheet-2239,reddit spreadsheet,Form,,2026-10-21,Fourth,Claw,First,,Later attempt,Blue or Black,Alone,False,East,Orange,Unknown,Ignore the scream,Tourniquet,(not recorded),(not recorded),(no fork),Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Yes,,,a nice brown,
sheet-2240,reddit spreadsheet,Form,,2026-10-21,First,Tail,Second,,Later attempt,Blue or Black,1 Squadmate,,East,Orange,Unknown,Investigate & help,Left bullies to the dragons,Assess the situation,(not recorded),West,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,No,,,"jump on tail, dead", sheet-2240,reddit spreadsheet,Form,,2026-10-21,First,Tail,Second,,Later attempt,Blue or Black,1 Squadmate,,East,Orange,Unknown,Investigate & help,Left bullies to the dragons,Assess the situation,(not recorded),West,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,No,,,"jump on tail, dead",
sheet-2241,reddit spreadsheet,Form,,2026-10-21,First,Tail,Third,,Later attempt,Any (for fun),Alone,False,West,Green,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),West,Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,No,,,There were two dragons a brown one and an orange one. First I tried to bond with the brown but it went away and when I tried to bond the orange I got incinerated, sheet-2241,reddit spreadsheet,Form,,2026-10-21,First,Tail,Third,,Later attempt,Any (for fun),Alone,False,West,Green,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),West,Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,No,,,There were two dragons a brown one and an orange one. First I tried to bond with the brown but it went away and when I tried to bond the orange I got incinerated,
sheet-2242,reddit spreadsheet,Form,,2026-10-21,Second,Flame,Second,2,Later attempt,Any (for fun),Alone,False,West,Brown,Unknown,Ignore the scream,Tourniquet,(not recorded),(not recorded),(no fork),Valley,Passed the Red: meadow,Bonded!,,,Changed my mind,,,Bonded,Red,False,False,False,No,No,,,,"I approached red dragon, then got a whole lot of: are you sure? Are you sure? Are you sure. With the option to run." sheet-2242,reddit spreadsheet,Form,,2026-10-21,Second,Flame,Second,2,Later attempt,Any (for fun),Alone,False,West,Brown,Unknown,Ignore the scream,Tourniquet,(not recorded),(not recorded),(no fork),Valley,Passed the Red: meadow,Bonded!,,,Changed my mind,,,Bonded,Red,False,False,False,No,No,,"Red at the Passed the Red: meadow encounter, which has only Blue/Brown/Orange",,"I approached red dragon, then got a whole lot of: are you sure? Are you sure? Are you sure. With the option to run."
sheet-2243,reddit spreadsheet,Form,,2026-10-21,Third,Flame,Second,,Later attempt,Blue or Black,Alone,False,West,Green,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),Forest,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Yes,,,Jumped on its back, sheet-2243,reddit spreadsheet,Form,,2026-10-21,Third,Flame,Second,,Later attempt,Blue or Black,Alone,False,West,Green,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),Forest,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Yes,,,Jumped on its back,
sheet-2244,reddit spreadsheet,Form,,2026-10-21,First,Tail,Third,,Later attempt,Blue or Black,Alone,False,West,Brown,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),Forest,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Yes,,,Jumped on its back, sheet-2244,reddit spreadsheet,Form,,2026-10-21,First,Tail,Third,,Later attempt,Blue or Black,Alone,False,West,Brown,Unknown,Investigate & help,Killed the bullies yourself,Assess the situation,(not recorded),Forest,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Yes,,,Jumped on its back,
sheet-2245,reddit spreadsheet,Form,,2026-10-21,Third,Tail,Second,1,First attempt,Any (for fun),1 Squadmate,,West,Red,Unknown,Investigate & help,Squadmate's revenge,Assess the situation,(not recorded),Forest,Valley,Passed the Red: meadow,,,Bonded!,,,,Bonded,Orange,False,False,False,No,No,,,,"Roared right back at it, charged with intent to mount, bonded" sheet-2245,reddit spreadsheet,Form,,2026-10-21,Third,Tail,Second,1,First attempt,Any (for fun),1 Squadmate,,West,Red,Unknown,Investigate & help,Squadmate's revenge,Assess the situation,(not recorded),Forest,Valley,Passed the Red: meadow,,,Bonded!,,,,Bonded,Orange,False,False,False,No,No,,,,"Roared right back at it, charged with intent to mount, bonded"
@@ -4691,7 +4691,7 @@ sheet-4568,reddit spreadsheet,Form,,2026-11-03,Second,Flame,Third,2,Later attemp
sheet-4569,reddit spreadsheet,Form,,2026-11-03,Third,Tail,Third,1,First attempt,Blue or Black,Alone,False,Center,Brown,Respect / face it,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,West,Tree,Shadow (rare),,,,,,Incinerated,Incinerated,Black,False,False,True,Shadow,Yes,,,Lower eyes > Dead, sheet-4569,reddit spreadsheet,Form,,2026-11-03,Third,Tail,Third,1,First attempt,Blue or Black,Alone,False,Center,Brown,Respect / face it,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,West,Tree,Shadow (rare),,,,,,Incinerated,Incinerated,Black,False,False,True,Shadow,Yes,,,Lower eyes > Dead,
sheet-4570,reddit spreadsheet,Form,,2026-11-03,Third,Tail,Third,2,Later attempt,Blue or Black,Alone,False,Center,Red,Hide,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,West,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Yes,,,Tail > Gaze > Dead, sheet-4570,reddit spreadsheet,Form,,2026-11-03,Third,Tail,Third,2,Later attempt,Blue or Black,Alone,False,Center,Red,Hide,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,West,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Yes,,,Tail > Gaze > Dead,
sheet-4571,reddit spreadsheet,Form,,2026-11-03,Second,Claw,Second,1,First attempt,Blue or Black,Alone,False,West,Brown,Respect / face it,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,Forest,Tree,Shadow (rare),,,,,Incinerated,,Incinerated,Blue,False,False,True,Shadow,Yes,,,Follow Shadow > Approach Blue > Sure > Dead, sheet-4571,reddit spreadsheet,Form,,2026-11-03,Second,Claw,Second,1,First attempt,Blue or Black,Alone,False,West,Brown,Respect / face it,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,Forest,Tree,Shadow (rare),,,,,Incinerated,,Incinerated,Blue,False,False,True,Shadow,Yes,,,Follow Shadow > Approach Blue > Sure > Dead,
sheet-4572,reddit spreadsheet,Form,,2026-11-03,First,Claw,Third,1,First attempt,Blue or Black,Alone,False,Center,Red,Hide,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,Forest,Tree,Shadow (rare),,,Changed my mind,Incinerated,Changed my mind,,Incinerated,Brown,False,False,True,Shadow,Yes,,,Follow shadow > Last Chance to escape Blue > Valley > Orange > Brown > Change > Dead, sheet-4572,reddit spreadsheet,Form,,2026-11-03,First,Claw,Third,1,First attempt,Blue or Black,Alone,False,Center,Red,Hide,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,Forest,Tree,Shadow (rare),,,Changed my mind,Incinerated,Changed my mind,,Incinerated,Brown,False,False,True,Shadow,Yes,,"Brown at the Shadow (rare) encounter, which has only Black/Blue",Follow shadow > Last Chance to escape Blue > Valley > Orange > Brown > Change > Dead,
sheet-4573,reddit spreadsheet,Form,,2026-11-03,Third,Flame,First,,Later attempt,Blue or Black,Alone,False,East,Red,Respect / face it,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,Forest,Valley,Passed the Red: meadow,,,,,Bonded!,,Bonded,Blue,False,True,False,Blue (valley),Yes,Clubtail,,, sheet-4573,reddit spreadsheet,Form,,2026-11-03,Third,Flame,First,,Later attempt,Blue or Black,Alone,False,East,Red,Respect / face it,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,Forest,Valley,Passed the Red: meadow,,,,,Bonded!,,Bonded,Blue,False,True,False,Blue (valley),Yes,Clubtail,,,
sheet-4574,reddit spreadsheet,Form,,2026-11-03,Third,Claw,Third,,Later attempt,Daily run data,Alone,False,Center,Brown,Respect / face it,Investigate & help,Left bullies to the dragons,Assess the situation,Daggers or not (protect squadmate),East,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Yes,,,, sheet-4574,reddit spreadsheet,Form,,2026-11-03,Third,Claw,Third,,Later attempt,Daily run data,Alone,False,Center,Brown,Respect / face it,Investigate & help,Left bullies to the dragons,Assess the situation,Daggers or not (protect squadmate),East,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Yes,,,,
sheet-4575,reddit spreadsheet,Form,,2026-11-03,Second,Tail,Third,,Later attempt,Daily run data,Alone,False,East,Red,Respect / face it,Investigate & help,Left bullies to the dragons,Assess the situation,Engage the smaller cadet,West,Tree,Descend quickly: Red,Bonded!,,,,,,Bonded,Red,False,False,False,No,No,Swordtail,,,"Tail, gaze, stomach, crawl" sheet-4575,reddit spreadsheet,Form,,2026-11-03,Second,Tail,Third,,Later attempt,Daily run data,Alone,False,East,Red,Respect / face it,Investigate & help,Left bullies to the dragons,Assess the situation,Engage the smaller cadet,West,Tree,Descend quickly: Red,Bonded!,,,,,,Bonded,Red,False,False,False,No,No,Swordtail,,,"Tail, gaze, stomach, crawl"
@@ -5129,7 +5129,7 @@ sheet-5006,reddit spreadsheet,Form,,2026-11-05,First,Claw,First,1,First attempt,
sheet-5007,reddit spreadsheet,Form,,2026-11-05,Fourth,Tail,First,32,Later attempt,Blue or Black,Alone,False,Center,Brown,Hold still,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,Forest,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Yes,,,Jumped on the red's back - Meet gaze - Drop (died), sheet-5007,reddit spreadsheet,Form,,2026-11-05,Fourth,Tail,First,32,Later attempt,Blue or Black,Alone,False,Center,Brown,Hold still,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,Forest,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Yes,,,Jumped on the red's back - Meet gaze - Drop (died),
sheet-5008,reddit spreadsheet,Form,,2026-11-05,Third,Tail,Second,,Later attempt,Daily run data,Alone,False,East,Orange,Retreat / run,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,East,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,No,,,, sheet-5008,reddit spreadsheet,Form,,2026-11-05,Third,Tail,Second,,Later attempt,Daily run data,Alone,False,East,Orange,Retreat / run,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,East,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,No,,,,
sheet-5009,reddit spreadsheet,Form,,2026-11-05,Fourth,Tail,First,34,Later attempt,Blue or Black,Alone,False,Center,Brown,Hold still,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,Forest,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Yes,,,Jumped on the red's back, sheet-5009,reddit spreadsheet,Form,,2026-11-05,Fourth,Tail,First,34,Later attempt,Blue or Black,Alone,False,Center,Brown,Hold still,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,Forest,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Yes,,,Jumped on the red's back,
sheet-5010,reddit spreadsheet,Form,,2026-11-05,Second,Claw,First,1,First attempt,Blue or Black,Alone,False,Center,Brown,Hold still,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,West,Tree,Shadow (rare),Incinerated,,,,,,Incinerated,Red,False,False,True,Shadow,Yes,,,Jumped on the reds back - Meet gaze (died), sheet-5010,reddit spreadsheet,Form,,2026-11-05,Second,Claw,First,1,First attempt,Blue or Black,Alone,False,Center,Brown,Hold still,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,West,Tree,Shadow (rare),Incinerated,,,,,,Incinerated,Red,False,False,True,Shadow,Yes,,"Red at the Shadow (rare) encounter, which has only Black/Blue",Jumped on the reds back - Meet gaze (died),
sheet-5011,reddit spreadsheet,Form,,2026-11-05,Second,Claw,First,,Later attempt,Blue or Black,Alone,False,East,Red,Respect / face it,Investigate & help,Killed the bullies yourself,Assess the situation,Engage the smaller cadet,East,Valley,Passed the Red: meadow,,,,Incinerated,,,Incinerated,Brown,False,False,False,No,Yes,,,, sheet-5011,reddit spreadsheet,Form,,2026-11-05,Second,Claw,First,,Later attempt,Blue or Black,Alone,False,East,Red,Respect / face it,Investigate & help,Killed the bullies yourself,Assess the situation,Engage the smaller cadet,East,Valley,Passed the Red: meadow,,,,Incinerated,,,Incinerated,Brown,False,False,False,No,Yes,,,,
sheet-5012,reddit spreadsheet,Form,,2026-11-05,Fourth,Claw,Second,50,Later attempt,Blue or Black,Alone,False,Center,Brown,Respect / face it,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,West,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,No,,,Jumping on risky tree reds back, sheet-5012,reddit spreadsheet,Form,,2026-11-05,Fourth,Claw,Second,50,Later attempt,Blue or Black,Alone,False,Center,Brown,Respect / face it,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,West,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,No,,,Jumping on risky tree reds back,
sheet-5013,reddit spreadsheet,Form,,2026-11-05,Fourth,Tail,Third,1,First attempt,Daily run data,1 Squadmate,True,East,Red,Hold still,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,East,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Yes,,,, sheet-5013,reddit spreadsheet,Form,,2026-11-05,Fourth,Tail,Third,1,First attempt,Daily run data,1 Squadmate,True,East,Red,Hold still,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,East,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Yes,,,,
@@ -5391,7 +5391,7 @@ sheet-5268,reddit spreadsheet,Form,,2026-11-06,Third,Claw,Third,19,Later attempt
sheet-5269,reddit spreadsheet,Form,,2026-11-06,Second,Flame,Third,,Later attempt,Blue or Black,Alone,False,Center,Red,Hide,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,West,Tree,Descend slowly: two Greens,,Incinerated,,,,,Incinerated,Green,False,False,False,No,Yes,,,, sheet-5269,reddit spreadsheet,Form,,2026-11-06,Second,Flame,Third,,Later attempt,Blue or Black,Alone,False,Center,Red,Hide,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,West,Tree,Descend slowly: two Greens,,Incinerated,,,,,Incinerated,Green,False,False,False,No,Yes,,,,
sheet-5270,reddit spreadsheet,Form,,2026-11-06,Second,Flame,Third,,Unknown,Blue or Black,Alone,False,Center,Brown,Respect / face it,Investigate & help,Killed the bullies yourself,Assess the situation,Daggers or not (protect squadmate),Forest,Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Yes,,,Ran, sheet-5270,reddit spreadsheet,Form,,2026-11-06,Second,Flame,Third,,Unknown,Blue or Black,Alone,False,Center,Brown,Respect / face it,Investigate & help,Killed the bullies yourself,Assess the situation,Daggers or not (protect squadmate),Forest,Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,False,False,False,No,Yes,,,Ran,
sheet-5271,reddit spreadsheet,Form,,2026-11-06,Fourth,Flame,Second,147,Later attempt,Blue or Black,1 Squadmate,False,East,Green,Hold still,Investigate & help,Left bullies to the dragons,Assess the situation,Engage the smaller cadet,East,Tree,Descend slowly: two Greens,,Incinerated,,,,,Incinerated,Green,False,False,False,No,Yes,,,Neutral on purpose, sheet-5271,reddit spreadsheet,Form,,2026-11-06,Fourth,Flame,Second,147,Later attempt,Blue or Black,1 Squadmate,False,East,Green,Hold still,Investigate & help,Left bullies to the dragons,Assess the situation,Engage the smaller cadet,East,Tree,Descend slowly: two Greens,,Incinerated,,,,,Incinerated,Green,False,False,False,No,Yes,,,Neutral on purpose,
sheet-5272,reddit spreadsheet,Form,,2026-11-06,Second,Claw,First,67,Later attempt,Blue or Black,Alone,False,Center,Red,Respect / face it,Ignore the scream,Tourniquet,(not recorded),(not recorded),(no fork),Valley,Passed the Red: meadow,,Incinerated,Incinerated,,,,Incinerated,Green,False,False,False,No,Yes,,Green recorded on a Valley run (no Greens in the valley); more than one dragon marked Incinerated,Approached orange -> said I was sure -> decided to run away (in order to die and try again) -> incinerated, sheet-5272,reddit spreadsheet,Form,,2026-11-06,Second,Claw,First,67,Later attempt,Blue or Black,Alone,False,Center,Red,Respect / face it,Ignore the scream,Tourniquet,(not recorded),(not recorded),(no fork),Valley,Passed the Red: meadow,,Incinerated,Incinerated,,,,Incinerated,Green,False,False,False,No,Yes,,"Green recorded on a Valley run (no Greens in the valley); more than one dragon marked Incinerated; Green at the Passed the Red: meadow encounter, which has only Blue/Brown/Orange",Approached orange -> said I was sure -> decided to run away (in order to die and try again) -> incinerated,
sheet-5273,reddit spreadsheet,Form,,2026-11-06,Fourth,Claw,Third,1,First attempt,Daily run data,1 Squadmate,True,East,Orange,Retreat / run,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,East,Tree,Shadow (rare),,,,,,Bonded!,Bonded,Black,False,False,True,Shadow,Yes,Scorpiontail,,,Followed the spreadsheet options for the Shadow choice EXACTLY. sheet-5273,reddit spreadsheet,Form,,2026-11-06,Fourth,Claw,Third,1,First attempt,Daily run data,1 Squadmate,True,East,Orange,Retreat / run,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,East,Tree,Shadow (rare),,,,,,Bonded!,Bonded,Black,False,False,True,Shadow,Yes,Scorpiontail,,,Followed the spreadsheet options for the Shadow choice EXACTLY.
sheet-5274,reddit spreadsheet,Form,,2026-11-06,First,Flame,First,87,Later attempt,Blue or Black,1 Squadmate,True,Center,Brown,Respect / face it,Investigate & help,Squadmate's revenge,Assess the situation,Daggers or not (protect squadmate),Forest,Valley,Passed the Red: meadow,,,,Bonded!,,,Bonded,Brown,False,False,False,No,No,Scorpiontail,,,"Followed, tail mount immediately grabbed, told them they are already talkin to me" sheet-5274,reddit spreadsheet,Form,,2026-11-06,First,Flame,First,87,Later attempt,Blue or Black,1 Squadmate,True,Center,Brown,Respect / face it,Investigate & help,Squadmate's revenge,Assess the situation,Daggers or not (protect squadmate),Forest,Valley,Passed the Red: meadow,,,,Bonded!,,,Bonded,Brown,False,False,False,No,No,Scorpiontail,,,"Followed, tail mount immediately grabbed, told them they are already talkin to me"
sheet-5275,reddit spreadsheet,Form,,2026-11-06,Third,Flame,First,2,Later attempt,Daily run data,1 Squadmate,False,West,Red,Hold still,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,Forest,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Yes,,,, sheet-5275,reddit spreadsheet,Form,,2026-11-06,Third,Flame,First,2,Later attempt,Daily run data,1 Squadmate,False,West,Red,Hold still,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,Forest,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Yes,,,,
@@ -6067,7 +6067,7 @@ sheet-5940,reddit spreadsheet,Form,,2026-11-10,First,Flame,Third,,Later attempt,
sheet-5941,reddit spreadsheet,Form,,2026-11-10,Second,Claw,Second,,Later attempt,Blue or Black,Alone,False,East,Orange,Respect / face it,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,East,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Yes,,,Jumped on its back, sheet-5941,reddit spreadsheet,Form,,2026-11-10,Second,Claw,Second,,Later attempt,Blue or Black,Alone,False,East,Orange,Respect / face it,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,East,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Yes,,,Jumped on its back,
sheet-5942,reddit spreadsheet,Form,,2026-11-10,First,Claw,First,,Later attempt,Blue or Black,Alone,False,East,Red,Respect / face it,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,East,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Yes,,,Lowered eyes, sheet-5942,reddit spreadsheet,Form,,2026-11-10,First,Claw,First,,Later attempt,Blue or Black,Alone,False,East,Red,Respect / face it,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,East,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Yes,,,Lowered eyes,
sheet-5943,reddit spreadsheet,Form,,2026-11-10,Second,Flame,Second,,Later attempt,Blue or Black,Alone,False,East,Orange,Respect / face it,Investigate & help,Left bullies to the dragons,Assess the situation,Engage the smaller cadet,East,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Yes,,,Lowered eyes, sheet-5943,reddit spreadsheet,Form,,2026-11-10,Second,Flame,Second,,Later attempt,Blue or Black,Alone,False,East,Orange,Respect / face it,Investigate & help,Left bullies to the dragons,Assess the situation,Engage the smaller cadet,East,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Yes,,,Lowered eyes,
sheet-5944,reddit spreadsheet,Form,,2026-11-10,First,Claw,Third,1,First attempt,Blue or Black,1 Squadmate,True,East,Green,Hold still,Ignore the scream,Tourniquet,(not recorded),(not recorded),(no fork),Tree,Shadow (rare),,Bonded!,,,,,Bonded,Green,False,False,True,Shadow,No,Morningstartail,,, sheet-5944,reddit spreadsheet,Form,,2026-11-10,First,Claw,Third,1,First attempt,Blue or Black,1 Squadmate,True,East,Green,Hold still,Ignore the scream,Tourniquet,(not recorded),(not recorded),(no fork),Tree,Shadow (rare),,Bonded!,,,,,Bonded,Green,False,False,True,Shadow,No,Morningstartail,"Green at the Shadow (rare) encounter, which has only Black/Blue",,
sheet-5945,reddit spreadsheet,Form,,2026-11-10,Second,Tail,First,,Later attempt,Blue or Black,Alone,False,East,Orange,Retreat / run,Investigate & help,Killed the bullies yourself,Assess the situation,Engage the smaller cadet,Forest,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Yes,,,Jumped onto reds back from tree and fell off, sheet-5945,reddit spreadsheet,Form,,2026-11-10,Second,Tail,First,,Later attempt,Blue or Black,Alone,False,East,Orange,Retreat / run,Investigate & help,Killed the bullies yourself,Assess the situation,Engage the smaller cadet,Forest,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Yes,,,Jumped onto reds back from tree and fell off,
sheet-5946,reddit spreadsheet,Form,,2026-11-10,First,Claw,Third,,Later attempt,Blue or Black,Alone,False,Center,Brown,Respect / face it,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,Forest,Valley,Passed the Red: meadow,,,,,Bonded!,,Bonded,Blue,False,True,False,Blue (valley),Unknown,Clubtail,,,Followed the PDF on blue decisions and make my choices quickly - no hesitations. sheet-5946,reddit spreadsheet,Form,,2026-11-10,First,Claw,Third,,Later attempt,Blue or Black,Alone,False,Center,Brown,Respect / face it,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,Forest,Valley,Passed the Red: meadow,,,,,Bonded!,,Bonded,Blue,False,True,False,Blue (valley),Unknown,Clubtail,,,Followed the PDF on blue decisions and make my choices quickly - no hesitations.
sheet-5947,reddit spreadsheet,Form,,2026-11-10,Third,Tail,First,47,Later attempt,Daily run data,2 Squadmates,False,East,Orange,Retreat / run,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,West,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Unknown,,,"Leapt onto back, survived for once, got roasted when held gaze", sheet-5947,reddit spreadsheet,Form,,2026-11-10,Third,Tail,First,47,Later attempt,Daily run data,2 Squadmates,False,East,Orange,Retreat / run,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,West,Tree,Descend quickly: Red,Incinerated,,,,,,Incinerated,Red,False,False,False,No,Unknown,,,"Leapt onto back, survived for once, got roasted when held gaze",
@@ -9590,6 +9590,88 @@ thread-THRESH-W99DB29MG16QA,reddit thread,,,,Unknown,,Unknown,,Unknown,(not aske
thread-THRESH-XCJCY7HW7QSSP,reddit thread,,,,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Unknown,,,,,,Bonded!,,Bonded,Blue,,,,(not asked),(not asked),Clubtail,,, thread-THRESH-XCJCY7HW7QSSP,reddit thread,,,,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Unknown,,,,,,Bonded!,,Bonded,Blue,,,,(not asked),(not asked),Clubtail,,,
thread-THRESH-XR6G68VPGT48M,reddit thread,,,,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Unknown,,,,,Bonded!,,,Bonded,Brown,,,,(not asked),(not asked),Morningstartail,,, thread-THRESH-XR6G68VPGT48M,reddit thread,,,,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Unknown,,,,,Bonded!,,,Bonded,Brown,,,,(not asked),(not asked),Morningstartail,,,
thread-THRESH-YQC97TK34214E,reddit thread,,,,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Unknown,,,,Bonded!,,,,Bonded,Orange,,,,(not asked),(not asked),Clubtail,,, thread-THRESH-YQC97TK34214E,reddit thread,,,,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Unknown,,,,Bonded!,,,,Bonded,Orange,,,,(not asked),(not asked),Clubtail,,,
comment-pdfnm69,reddit comment,,,2026-10-02,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Hold still,Unknown,Unknown,(not recorded),(not recorded),Unknown,Tree,Descend slowly: two Greens,,Incinerated,,,,,Incinerated,Green,,,False,(not asked),(not asked),Clubtail,"read from a Reddit comment automatically, not checked by hand",,
comment-pdg3xv8,reddit comment,,,2026-10-02,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,West,Unknown,Unknown,Investigate & help,Squadmate's revenge,Put yourself in the middle (bigger cadet),(not recorded),Unknown,Unknown,,,,,,,Bonded!,Bonded,Black,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdiy5if,reddit comment,,,2026-10-03,Unknown,,Unknown,1,First attempt,(not asked/blank),Alone,,East,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Tree,,,,,,Bonded!,,Bonded,Blue,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdj3z04,reddit comment,,,2026-10-03,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Ignore the scream,Tourniquet,(not recorded),(not recorded),Unknown,Unknown,,,,Bonded!,,,,Bonded,Orange,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdjfd2e,reddit comment,,,2026-10-03,Unknown,,Unknown,,Unknown,(not asked/blank),1 Squadmate,,Unknown,Unknown,Unknown,Ignore the scream,Tourniquet,(not recorded),(not recorded),Unknown,Valley,Passed the Red: meadow,,,Bonded!,,,,Bonded,Orange,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdjiliu,reddit comment,,,2026-10-03,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Tree,Shadow (rare),,,,,Incinerated,,Incinerated,Blue,,,True,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdjjp1e,reddit comment,,,2026-10-03,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,True,Unknown,Unknown,Unknown,Investigate & help,Squadmate's revenge,(not recorded),(not recorded),Unknown,Tree,Descend slowly: two Greens,,Incinerated,,,,,Incinerated,Green,,,False,(not asked),(not asked),Daggertail,"read from a Reddit comment automatically, not checked by hand",,
comment-pdjq69x,reddit comment,,,2026-10-03,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Ignore the scream,Tourniquet,(not recorded),(not recorded),Unknown,DIED before the hour,,,,,,,,Died before the hour,,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdjr7gm,reddit comment,,,2026-10-03,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Investigate & help,Squadmate's revenge,(not recorded),(not recorded),Unknown,Valley,Passed the Red: meadow,,,,Bonded!,,,Bonded,Brown,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdjwbor,reddit comment,,,2026-10-03,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Hold still,Unknown,Unknown,(not recorded),(not recorded),Unknown,Tree,Descend quickly: Red,,Bonded!,,,,,Bonded,Green,,,False,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand; Green at the Descend quickly: Red encounter, which has only Red",,
comment-pdk7mvv,reddit comment,,,2026-10-03,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Ignore the scream,Tourniquet,(not recorded),(not recorded),Unknown,Unknown,,Bonded!,,,,,,Bonded,Red,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdk9i0o,reddit comment,,,2026-10-03,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Ignore the scream,Took their weapons,(not recorded),(not recorded),Unknown,Unknown,,,,,,Incinerated,,Incinerated,Blue,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdkgyrf,reddit comment,,,2026-10-03,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Tree,Descend slowly: two Greens,,,Bonded!,,,,Bonded,Orange,,,False,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdl54dv,reddit comment,,,2026-10-03,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Investigate & help,Unknown,Even the numbers (smaller cadet),(not recorded),Unknown,Tree,,,Bonded!,,,,,Bonded,Green,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdls2j2,reddit comment,,,2026-10-03,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Ignore the scream,Tourniquet,(not recorded),(not recorded),Unknown,Unknown,,Bonded!,,,,,,Bonded,Red,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdlxp8y,reddit comment,,,2026-10-03,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Ignore the scream,Tourniquet,(not recorded),(not recorded),Unknown,Unknown,,Bonded!,,,,,,Bonded,Red,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdm0zdh,reddit comment,,,2026-10-03,Unknown,,Unknown,1,First attempt,(not asked/blank),Alone,,Center,Unknown,Hold still,Unknown,Unknown,(not recorded),(not recorded),Unknown,Valley,Passed the Red: meadow,,,,,Incinerated,,Incinerated,Blue,,True,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdmav0n,reddit comment,,,2026-10-03,Unknown,,Unknown,,Unknown,(not asked/blank),Alone,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Valley,,Bonded!,,,,,,Bonded,Red,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdmlrmp,reddit comment,,,2026-10-03,Unknown,,Unknown,,Unknown,(not asked/blank),Alone,,Center,Unknown,Hold still,Investigate & help,Squadmate's revenge,(not recorded),(not recorded),Unknown,Tree,Shadow (rare),,,,,Incinerated,,Incinerated,Blue,,,True,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdnfito,reddit comment,,,2026-10-03,Unknown,,Unknown,,Unknown,(not asked/blank),Alone,,Unknown,Unknown,Unknown,Ignore the scream,Took their weapons,(not recorded),(not recorded),Unknown,Tree,Descend slowly: two Greens,,Incinerated,,,,,Incinerated,Green,,,False,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdnvj9y,reddit comment,,,2026-10-03,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Investigate & help,Unknown,(not recorded),(not recorded),Unknown,Tree,,,,Bonded!,,,,Bonded,Orange,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdo03nr,reddit comment,,,2026-10-03,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Hide,Ignore the scream,Tourniquet,(not recorded),(not recorded),Unknown,Tree,,Bonded!,,,,,,Bonded,Red,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdo11wv,reddit comment,,,2026-10-03,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Ignore the scream,Tourniquet,(not recorded),(not recorded),Unknown,Unknown,,Bonded!,,,,,,Bonded,Red,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdo5xoa,reddit comment,,,2026-10-03,Unknown,,Unknown,,Unknown,(not asked/blank),Alone,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Tree,Descend slowly: two Greens,,,,Bonded!,,,Bonded,Brown,,,False,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdp4ip2,reddit comment,,,2026-10-03,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Brown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Tree,Descend slowly: two Greens,,,,Bonded!,,,Bonded,Brown,,,False,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdpxkly,reddit comment,,,2026-10-04,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Investigate & help,Unknown,(not recorded),(not recorded),Unknown,Valley,,,,,,Bonded!,,Bonded,Blue,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdq6tsw,reddit comment,,,2026-10-04,Unknown,,Unknown,,Unknown,(not asked/blank),Alone,,Center,Unknown,Unknown,Ignore the scream,Took their weapons,(not recorded),(not recorded),Unknown,Unknown,,Bonded!,,,,,,Bonded,Red,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdr0rmb,reddit comment,,,2026-10-04,Unknown,,Unknown,2,Later attempt,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Investigate & help,DIED in combat,(not recorded),(not recorded),Unknown,DIED before the hour,,,,,,,,Died before the hour,,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdr0zac,reddit comment,,,2026-10-04,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Center,Unknown,Respect / face it,Unknown,Unknown,(not recorded),(not recorded),Unknown,Tree,Descend quickly: Red,Bonded!,,,,,,Bonded,Red,,,False,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdskglg,reddit comment,,,2026-10-04,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Ignore the scream,Tourniquet,(not recorded),(not recorded),Unknown,Unknown,,,,Bonded!,,,,Bonded,Orange,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdss1rq,reddit comment,,,2026-10-04,Unknown,,Unknown,,Unknown,(not asked/blank),Alone,,Center,Unknown,Respect / face it,Unknown,Unknown,(not recorded),(not recorded),Unknown,Tree,,,Bonded!,,,,,Bonded,Green,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdtu6ls,reddit comment,,,2026-10-04,Unknown,,Unknown,1,First attempt,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Tree,Descend slowly: two Greens,,,Incinerated,,,,Incinerated,Orange,,,False,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdtv0ow,reddit comment,,,2026-10-04,Unknown,,Unknown,2,Later attempt,(not asked/blank),Alone,,West,Green,Unknown,Investigate & help,Unknown,(not recorded),(not recorded),Unknown,Unknown,,,,,Bonded!,,,Bonded,Brown,,,,(not asked),(not asked),Swordtail,"read from a Reddit comment automatically, not checked by hand",,
comment-pduqz9x-1,reddit comment,,,2026-10-04,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,West,Unknown,Unknown,Investigate & help,Unknown,(not recorded),(not recorded),Unknown,Unknown,,,,,,Incinerated,,Incinerated,Blue,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pduqz9x-2,reddit comment,,,2026-10-04,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,West,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Valley,,,,,,Incinerated,,Incinerated,Blue,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pdvkjqs,reddit comment,,,2026-10-04,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Tree,Shadow (rare),,,,Bonded!,,,Bonded,Brown,,,True,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand; Brown at the Shadow (rare) encounter, which has only Black/Blue",,
comment-pe0gyqi,reddit comment,,,2026-10-05,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Center,Red,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Unknown,,Incinerated,,,,,,Incinerated,Red,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pe0id6k,reddit comment,,,2026-10-05,Unknown,,Unknown,,Unknown,(not asked/blank),Alone,,Center,Red,Meet its gaze,Investigate & help,Squadmate's revenge,Assess the situation,(not recorded),West,Unknown,,,,,Bonded!,,,Bonded,Brown,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pe0kwol,reddit comment,,,2026-10-05,Unknown,,Unknown,,Unknown,(not asked/blank),Alone,,West,Unknown,Unknown,Investigate & help,Squadmate's revenge,(not recorded),(not recorded),Forest,Tree,,,,,,,Bonded!,Bonded,Black,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pe1xkz4,reddit comment,,,2026-10-05,Unknown,,Unknown,,Unknown,(not asked/blank),Alone,,Center,Unknown,Unknown,Investigate & help,Unknown,Assess the situation,(not recorded),Unknown,Unknown,,,,,,Bonded!,,Bonded,Blue,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pe2gjj3,reddit comment,,,2026-10-05,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Brown,Hold still,Unknown,Unknown,(not recorded),(not recorded),Unknown,DIED before the hour,,,,,,,,Died before the hour,,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pe2i0lc,reddit comment,,,2026-10-05,Unknown,,Unknown,,Unknown,Blue,Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Valley,Passed the Red: meadow,,,,,Bonded!,,Bonded,Blue,,True,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pe2l6mz,reddit comment,,,2026-10-05,Unknown,,Unknown,,Unknown,(not asked/blank),Alone,,Center,Unknown,Unknown,Ignore the scream,Unknown,(not recorded),(not recorded),Unknown,Valley,,,,,Incinerated,,,Incinerated,Brown,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pe2n3j1,reddit comment,,,2026-10-05,Unknown,,Unknown,,Unknown,(not asked/blank),Alone,,Center,Unknown,Unknown,Investigate & help,Squadmate's revenge,(not recorded),(not recorded),Unknown,Tree,,,,,,,Bonded!,Bonded,Black,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pe2rdxu,reddit comment,,,2026-10-05,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Tree,Shadow (rare),,,,,,Bonded!,Bonded,Black,,,True,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pe52dlj,reddit comment,,,2026-10-06,Unknown,,Unknown,,Unknown,(not asked/blank),Alone,,Unknown,Red,Respect / face it,Ignore the scream,Tourniquet,(not recorded),(not recorded),Unknown,Valley,Valley Red,Bonded!,,,,,,Bonded,Red,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pe5o1sx,reddit comment,,,2026-10-06,Unknown,,Unknown,,Unknown,(not asked/blank),Alone,,East,Unknown,Unknown,Investigate & help,Unknown,Assess the situation,Engage the smaller cadet,East,Valley,Passed the Red: meadow,,,Incinerated,,,,Incinerated,Orange,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pe9z1u1,reddit comment,,,2026-10-06,Unknown,,Unknown,2,Later attempt,(not asked/blank),Alone,,Center,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Unknown,,,,,Bonded!,,,Bonded,Brown,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pea2ha6,reddit comment,,,2026-10-06,Unknown,,Unknown,,Unknown,(not asked/blank),Alone,,Center,Unknown,Unknown,Ignore the scream,Unknown,(not recorded),(not recorded),Unknown,Unknown,,,,,,Bonded!,,Bonded,Blue,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pec5k9m,reddit comment,,,2026-10-07,Unknown,,Unknown,1,First attempt,(not asked/blank),Alone,,West,Unknown,Unknown,Unknown,Unknown,Even the numbers (smaller cadet),(not recorded),West,Unknown,,,,,,Incinerated,,Incinerated,Blue,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pecco10,reddit comment,,,2026-10-07,Unknown,,Unknown,,Unknown,Blue,Alone,,Center,Orange,Unknown,Investigate & help,Unknown,Assess the situation,(not recorded),Unknown,Unknown,,,,,,Bonded!,,Bonded,Blue,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand; first sighting Orange not in documented pool for Alone/Center",,
comment-peckg7u,reddit comment,,,2026-10-07,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Tree,Shadow (rare),,,,Bonded!,,,Bonded,Brown,,,True,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand; Brown at the Shadow (rare) encounter, which has only Black/Blue",,
comment-pefrzyp,reddit comment,,,2026-10-07,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Center,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Valley,,Bonded!,,,,,,Bonded,Red,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-peg9ove,reddit comment,,,2026-10-07,Unknown,,Unknown,,Unknown,(not asked/blank),2 Squadmates,,Center,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Unknown,,Bonded!,,,,,,Bonded,Red,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pei8c2d,reddit comment,,,2026-10-07,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,East,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Valley,,,,Bonded!,,,,Bonded,Orange,,,,(not asked),(not asked),Scorpiontail,"read from a Reddit comment automatically, not checked by hand",,
comment-pekeccv,reddit comment,,,2026-10-08,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Center,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Valley,Passed the Red: meadow,Incinerated,,,,,,Incinerated,Red,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand; Red at the Passed the Red: meadow encounter, which has only Blue/Brown/Orange",,
comment-pemrjhj,reddit comment,,,2026-10-08,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Tree,Descend slowly: two Greens,,Incinerated,,,,,Incinerated,Green,,,False,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-peuv3i2,reddit comment,,,2026-10-09,Unknown,,Unknown,,Unknown,Blue,Alone,,West,Unknown,Unknown,Investigate & help,Unknown,Assess the situation,Engage the smaller cadet,Forest,Valley,Passed the Red: meadow,,,Bonded!,,,,Bonded,Orange,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pev3uge,reddit comment,,,2026-10-09,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Investigate & help,Killed the bullies yourself,(not recorded),(not recorded),Unknown,Valley,Passed the Red: meadow,,,,,Incinerated,,Incinerated,Blue,,True,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pew84ij,reddit comment,,,2026-10-09,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,East,Unknown,Respect / face it,Unknown,Unknown,(not recorded),(not recorded),Unknown,Tree,,,,,,Incinerated,,Incinerated,Blue,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pez3j5x,reddit comment,,,2026-10-10,Unknown,,Unknown,4,Later attempt,(not asked/blank),Unknown,True,West,Green,Hold still,Ignore the scream,Tourniquet,(not recorded),(not recorded),Unknown,Unknown,,Bonded!,,,,,,Bonded,Red,,,,(not asked),(not asked),Swordtail,"read from a Reddit comment automatically, not checked by hand",,
comment-pezqz38,reddit comment,,,2026-10-10,Unknown,,Unknown,1,First attempt,(not asked/blank),Alone,,Center,Unknown,Unknown,Investigate & help,Squadmate's revenge,(not recorded),(not recorded),Unknown,Tree,Shadow (rare),,,,,,Incinerated,Incinerated,Black,,,True,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pf1qs3z,reddit comment,,,2026-10-10,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Investigate & help,Squadmate's revenge,(not recorded),(not recorded),Unknown,Unknown,,,,,,Bonded!,,Bonded,Blue,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pf22tpj,reddit comment,,,2026-10-10,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Center,Unknown,Unknown,Investigate & help,Squadmate's revenge,Assess the situation,(not recorded),Unknown,Unknown,,Incinerated,,,,,,Incinerated,Red,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pf3yvgt,reddit comment,,,2026-10-10,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Investigate & help,Unknown,Even the numbers (smaller cadet),(not recorded),Unknown,Unknown,,,,,,Incinerated,,Incinerated,Blue,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pfd3knx,reddit comment,,,2026-10-12,Unknown,,Unknown,1,First attempt,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Tree,Shadow (rare),,,,,,Bonded!,Bonded,Black,,,True,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pfdilgs,reddit comment,,,2026-10-12,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,East,Unknown,Retreat / run,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,East,Valley,,,,,,Bonded!,,Bonded,Blue,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pffp9no,reddit comment,,,2026-10-12,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Tree,Shadow (rare),,,,,,Bonded!,Bonded,Black,,,True,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pfhmw5d,reddit comment,,,2026-10-12,Unknown,,Unknown,,Unknown,(not asked/blank),2 Squadmates,,East,Unknown,Unknown,Ignore the scream,Unknown,(not recorded),(not recorded),Unknown,Valley,,,,,,Incinerated,,Incinerated,Blue,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pgjsk65,reddit comment,,,2026-10-13,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Tree,Shadow (rare),,,,,,Incinerated,Incinerated,Black,,,True,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pgso2fs,reddit comment,,,2026-10-14,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Tree,Shadow (rare),,,,,,Bonded!,Bonded,Black,,,True,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pgtvzmg,reddit comment,,,2026-10-15,Unknown,,Unknown,,Unknown,(not asked/blank),Alone,,Center,Unknown,Respect / face it,Ignore the scream,Tourniquet,(not recorded),(not recorded),Unknown,Valley,Passed the Red: meadow,,,,Bonded!,,,Bonded,Brown,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pgxewrr,reddit comment,,,2026-10-15,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Tree,Shadow (rare),,,,,Incinerated,,Incinerated,Blue,,,True,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-pgy120f,reddit comment,,,2026-10-15,Unknown,,Unknown,,Unknown,(not asked/blank),Alone,,West,Unknown,Hold still,Investigate & help,Unknown,(not recorded),(not recorded),East,Valley,Passed the Red: meadow,,,,,Bonded!,,Bonded,Blue,,True,,(not asked),(not asked),Swordtail,"read from a Reddit comment automatically, not checked by hand",,
comment-pgzz9hc,reddit comment,,,2026-10-15,Unknown,,Unknown,,Unknown,(not asked/blank),2 Squadmates,,East,Unknown,Unknown,Ignore the scream,Unknown,(not recorded),(not recorded),Unknown,Valley,,Bonded!,,,,,,Bonded,Red,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-ph1hedk,reddit comment,,,2026-10-16,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Tree,Shadow (rare),,,,,,Bonded!,Bonded,Black,,,True,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-19rel13734hsy,reddit comment,,,2026-10-20,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Ignore the scream,Tourniquet,(not recorded),(not recorded),Unknown,Unknown,,,,,,Bonded!,,Bonded,Blue,,,,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-19rf49thaysdd,reddit comment,,,2026-10-21,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,East,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Tree,Shadow (rare),,,,,Bonded!,,Bonded,Blue,,,True,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-19rgusco0p4bo,reddit comment,,,2026-10-22,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,East,Red,Hide,Ignore the scream,Tourniquet,Even the numbers (smaller cadet),(not recorded),East,Tree,Shadow (rare),Bonded!,,,,,,Bonded,Red,,,True,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand; Red at the Shadow (rare) encounter, which has only Black/Blue; fight answers on a run that did not help; a path after the fight on a run without a fight",,
comment-19rjhp6b7kz6r,reddit comment,,,2026-10-23,Unknown,,Unknown,,Unknown,(not asked/blank),Alone,,West,Unknown,Unknown,Investigate & help,Squadmate's revenge,Assess the situation,Engage the smaller cadet,West,Tree,Shadow (rare),,,,,,Bonded!,Bonded,Black,,,True,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-19rlnakulqgbp,reddit comment,,,2026-10-24,Unknown,,Unknown,1,First attempt,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Tree,Shadow (rare),,,,,,Bonded!,Bonded,Black,,,True,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
comment-19s5unmw28lr7,reddit comment,,,2026-11-05,Unknown,,Unknown,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Tree,Shadow (rare),,,,,,Bonded!,Bonded,Black,,,True,(not asked),(not asked),,"read from a Reddit comment automatically, not checked by hand",,
register-1,register,,,2026-10-06,First,Claw,Second,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Unknown,,Bonded!,,,,,,Bonded,Red,,,,(not asked),(not asked),Daggertail,outcome only (register): the same run may also be in the spreadsheet,, register-1,register,,,2026-10-06,First,Claw,Second,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Unknown,,Bonded!,,,,,,Bonded,Red,,,,(not asked),(not asked),Daggertail,outcome only (register): the same run may also be in the spreadsheet,,
register-2,register,,,2026-10-06,Second,Tail,Third,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Unknown,,,Bonded!,,,,,Bonded,Green,,,,(not asked),(not asked),Clubtail,outcome only (register): the same run may also be in the spreadsheet,, register-2,register,,,2026-10-06,Second,Tail,Third,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Unknown,,,Bonded!,,,,,Bonded,Green,,,,(not asked),(not asked),Clubtail,outcome only (register): the same run may also be in the spreadsheet,,
register-3,register,,,2026-10-06,Third,Flame,Third,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Unknown,,,,Bonded!,,,,Bonded,Orange,,,,(not asked),(not asked),Swordtail,outcome only (register): the same run may also be in the spreadsheet,, register-3,register,,,2026-10-06,Third,Flame,Third,,Unknown,(not asked/blank),Unknown,,Unknown,Unknown,Unknown,Unknown,Unknown,(not recorded),(not recorded),Unknown,Unknown,,,,Bonded!,,,,Bonded,Orange,,,,(not asked),(not asked),Swordtail,outcome only (register): the same run may also be in the spreadsheet,,
Can't render this file because it is too large.
File diff suppressed because one or more lines are too long
+2 -2
View File
@@ -13,8 +13,8 @@ branch: main
# public, limited (only people signed in to this server) or private: who can open the links below # public, limited (only people signed in to this server) or private: who can open the links below
visibility: limited visibility: limited
# the published page, when it is hosted somewhere (GitHub Pages is paused while the GitHub account is suspended; # the published page: Ken's server serves the `pages` branch (.gitea/workflows/pages.yml). Set this to its address
# the page is viewed locally or as a Claude artifact meanwhile) # once it is up (then `python -m collection build`): the page's links and the dataset metadata use it.
site: null site: null
# other copies of the repository (informational) # other copies of the repository (informational)
+3 -3
View File
@@ -6,11 +6,11 @@
"scripts": { "scripts": {
"build": "node site/build.js", "build": "node site/build.js",
"dev": "node site/build.js && python3 -m http.server 8000 -d dist", "dev": "node site/build.js && python3 -m http.server 8000 -d dist",
"test:py": "python3 -m collection build --check && python3 planner/build_experiments.py --check && python3 analysis/black/evidence.py --check && python3 analysis/tree/build_tree.py --check && PYTHONPATH=core python3 -m unittest discover -s tests/core -p 'test_*.py' && python3 -m unittest discover -s tests/collection -p 'test_*.py'", "test:py": "python3 -m collection build --check && python3 planner/build_experiments.py --check && python3 analysis/black/evidence.py --check && python3 analysis/tree/build_tree.py --check && python3 analysis/known/build_known.py --check && PYTHONPATH=core python3 -m unittest discover -s tests/core -p 'test_*.py' && python3 -m unittest discover -s tests/collection -p 'test_*.py'",
"test:unit": "node --test tests/core/graph.test.js tests/core/advisor.test.js", "test:unit": "node --test tests/core/graph.test.js tests/core/advisor.test.js tests/core/known.test.js",
"test": "npm run test:py && npm run test:unit", "test": "npm run test:py && npm run test:unit",
"graph": "node analysis/network/build-graph.js", "graph": "node analysis/network/build-graph.js",
"policy": "python3 planner/build_policy.py && python3 planner/policy_report.py && python3 planner/build_experiments.py && python3 analysis/black/evidence.py && python3 analysis/tree/build_tree.py", "policy": "python3 planner/build_policy.py && python3 planner/policy_report.py && python3 planner/build_experiments.py && python3 analysis/black/evidence.py && python3 analysis/tree/build_tree.py && python3 analysis/known/build_known.py",
"cycle": "python3 -m collection cycle", "cycle": "python3 -m collection cycle",
"stats": "python3 analysis/stats/site_stats.py", "stats": "python3 analysis/stats/site_stats.py",
"collect": "python3 -m collection update", "collect": "python3 -m collection update",
+6 -7
View File
@@ -31,18 +31,17 @@ def low_bias(r, lb=CONFIG["low_bias"]):
"""Kept in the low-bias sample: every run of an always-kept source, bulk logs, and riders not chasing a rare dragon.""" """Kept in the low-bias sample: every run of an always-kept source, bulk logs, and riders not chasing a rare dragon."""
if r["source"] in lb["always"]: if r["source"] in lb["always"]:
return True return True
if r["source"] in (lb.get("never") or ()):
return False
if r["source"] == "reddit spreadsheet" and "bulk" in lb["entries_kept"] and r["entry"] not in (None, "Form"): if r["source"] == "reddit spreadsheet" and "bulk" in lb["entries_kept"] and r["entry"] not in (None, "Form"):
return True return True
return r["goal"] not in lb["rare_goals"] return r["goal"] not in lb["rare_goals"]
def drop_flagged(runs, cfg=CONFIG.get("drop_flagged") or {}): def drop_flagged(runs, on=CONFIG.get("drop_impossible", True)):
"""Without the flagged runs of the sources read automatically from free text (planner/policy.yaml drop_flagged).""" """Without the runs that cannot have happened as recorded (atlas.runs.impossible; planner/policy.yaml
sources, keep = set(cfg.get("sources") or ()), tuple(cfg.get("except") or ()) drop_impossible): every other run is kept, however partial."""
return [r for r in runs if not (on and runs_io.impossible(r))]
def problems(r):
return [f for f in (r.get("data_flags") or "").split("; ") if f and not f.startswith(keep)] if keep else [f for f in (r.get("data_flags") or "").split("; ") if f]
return [r for r in runs if r["source"] not in sources or not problems(r)]
def clean(o): def clean(o):
+7 -8
View File
@@ -6,21 +6,19 @@
version: 1 version: 1
# the `source` values of data/public/runs_clean.csv the model learns from # the `source` values of data/public/runs_clean.csv the model learns from
sources: [reddit spreadsheet, reported, bot] sources: [reddit spreadsheet, reported, bot, reddit comment]
# Sources read automatically from free text: a run with any data flag (a broken game rule, an unrecognised answer) # Every run of the sources above is used, however partial, except a run that cannot have happened as recorded
# is left out of the model, since the flag may mean the text was misread or misremembered. Flags that only say where # (core/spec/form.yaml impossible_flags: it breaks one of the game's rules). Such runs stay in runs_clean.csv, flagged;
# the run came from (`except`, matched at the start of a flag) do not count. A hand fix that clears the flags # a hand fix that clears the flag brings a Reddit or reported run back. The site statistics use the same rule.
# brings the run back. Applies once the source is also listed in `sources` above. drop_impossible: true
drop_flagged:
sources: [reddit comment]
except: ["read from a Reddit comment"]
# Two samples. "all" is every run above. "lowBias" leaves out runs where a rare sighting is more likely to have # Two samples. "all" is every run above. "lowBias" leaves out runs where a rare sighting is more likely to have
# been reported than a miss: form submissions and reports from riders chasing Blue or Black. The bot logs every # been reported than a miss: form submissions and reports from riders chasing Blue or Black. The bot logs every
# run, and bulk-pasted logs record every run of the players who kept them, so both stay in. # run, and bulk-pasted logs record every run of the players who kept them, so both stay in.
low_bias: low_bias:
always: [bot] # sources whose every run is kept always: [bot] # sources whose every run is kept
never: [reddit comment] # riders posting a run in a thread pick the notable ones, like rare-chasers
entries_kept: [bulk] # spreadsheet rows whose `entry` is not "Form" (bulk-pasted logs) entries_kept: [bulk] # spreadsheet rows whose `entry` is not "Form" (bulk-pasted logs)
rare_goals: [Blue, Black, Blue or Black] rare_goals: [Blue, Black, Blue or Black]
@@ -46,3 +44,4 @@ reporting_bias:
- { name: "form, chasing Blue/Black", when: { source: reddit spreadsheet, goal: rare } } - { name: "form, chasing Blue/Black", when: { source: reddit spreadsheet, goal: rare } }
- { name: "form, other", when: { source: reddit spreadsheet } } - { name: "form, other", when: { source: reddit spreadsheet } }
- { name: reported, when: { source: reported }, same_as: "form, other" } - { name: reported, when: { source: reported }, same_as: "form, other" }
- { name: reddit comments, when: { source: reddit comment } } # self-selected: its own reporting rate
+1 -1
View File
@@ -554,7 +554,7 @@
</tbody></table></div><p class="small">Bulk logs come from players who recorded every run, so they are the least selective rows. Their rare-dragon rates are several times lower than the form's, which is the strongest sign of reporting bias in this data.</p></div> </tbody></table></div><p class="small">Bulk logs come from players who recorded every run, so they are the least selective rows. Their rare-dragon rates are several times lower than the form's, which is the strongest sign of reporting bias in this data.</p></div>
<div class="panel"><h3>Rows flagged for contradictions</h3><p class="small muted">${m.n_flagged} of ${r.n} rows (${pct(m.n_flagged / r.n)}). Flagged rows stay in unless you pick "Rows without data-quality flags" above.</p><div class="tbl-wrap"><table><tbody>${flags.map(([f, n]) => `<tr><td>${esc(f)}</td><td class="num">${n}</td></tr>`).join("") || `<tr><td>None</td></tr>`}</tbody></table></div></div> <div class="panel"><h3>Rows flagged for contradictions</h3><p class="small muted">${m.n_flagged} of ${r.n} rows (${pct(m.n_flagged / r.n)}). Flagged rows stay in unless you pick "Rows without data-quality flags" above.</p><div class="tbl-wrap"><table><tbody>${flags.map(([f, n]) => `<tr><td>${esc(f)}</td><td class="num">${n}</td></tr>`).join("") || `<tr><td>None</td></tr>`}</tbody></table></div></div>
<div class="panel"><h3>How runs ended</h3><div class="tbl-wrap"><table><tbody>${outs.map(([f, n]) => `<tr><td>${esc(f)}</td><td class="num">${n}</td><td class="num">${pct(n / r.n)}</td></tr>`).join("")}</tbody></table></div><p class="small muted">"No outcome recorded" rows reached the hour but the form shows no Bonded or Incinerated. They count toward reaching a branch but not toward bond rates.</p></div> <div class="panel"><h3>How runs ended</h3><div class="tbl-wrap"><table><tbody>${outs.map(([f, n]) => `<tr><td>${esc(f)}</td><td class="num">${n}</td><td class="num">${pct(n / r.n)}</td></tr>`).join("")}</tbody></table></div><p class="small muted">"No outcome recorded" rows reached the hour but the form shows no Bonded or Incinerated. They count toward reaching a branch but not toward bond rates.</p></div>
<div class="panel"><h3>Independence</h3><p class="small">The form has no player ID. One player's 50 runs count as 50 independent runs, so intervals are somewhat narrower than they should be. ${pct((r.n - (m.sources["Form"] || 0)) / r.n, 0)} of rows arrived as bulk imports, each probably one player's or one group's log.</p></div> <div class="panel"><h3>Independence</h3><p class="small">The form has no player ID. One player's 50 runs count as 50 independent runs, so intervals are somewhat narrower than they should be. ${pct(Object.entries(m.sources).filter(([k]) => !["Form", "Reddit comments", "DragonKind bot", "Reported on the Atlas"].includes(k)).reduce((s, [, n]) => s + n, 0) / r.n, 0)} of rows arrived as bulk imports, each probably one player's or one group's log.</p></div>
<div class="panel"><h3>What the form does not ask</h3><p class="small">The redesigned form asks how you reacted to the first dragon (answered in ${r.factors.reach_hour.rows.filter((x) => x.factor === "sighting_action" && !["Unknown", "(not asked)"].includes(x.level)).reduce((a, x) => a + x.n, 0)} rows; most riders answer "Unsure") and how the bully fight went (${r.factors.reach_hour.rows.filter((x) => x.factor === "combat_first" && x.level !== "(not recorded)").reduce((a, x) => a + x.n, 0)} rows). It still does not record most choices inside the bonding encounters. Theories that rely on those choices cannot be confirmed or refuted here.</p></div>`; <div class="panel"><h3>What the form does not ask</h3><p class="small">The redesigned form asks how you reacted to the first dragon (answered in ${r.factors.reach_hour.rows.filter((x) => x.factor === "sighting_action" && !["Unknown", "(not asked)"].includes(x.level)).reduce((a, x) => a + x.n, 0)} rows; most riders answer "Unsure") and how the bully fight went (${r.factors.reach_hour.rows.filter((x) => x.factor === "combat_first" && x.level !== "(not recorded)").reduce((a, x) => a + x.n, 0)} rows). It still does not record most choices inside the bonding encounters. Theories that rely on those choices cannot be confirmed or refuted here.</p></div>`;
} }
const sourceRate = (outKey, source) => state.res.source_rates[outKey][source]; const sourceRate = (outKey, source) => state.res.source_rates[outKey][source];
+3 -1
View File
@@ -308,6 +308,8 @@ class RedditComments(unittest.TestCase):
dict(branch="Valley: passed the Red, the meadow", outcome="Incinerated at a bonding encounter", outcome_color="Red"), dict(branch="Valley: passed the Red, the meadow", outcome="Incinerated at a bonding encounter", outcome_color="Red"),
"Green recorded on a Valley run": "Green recorded on a Valley run":
dict(hour="Went to the valley centre", outcome="Bonded", outcome_color="Green"), dict(hour="Went to the valley centre", outcome="Bonded", outcome_color="Green"),
"Black recorded on a Valley run":
dict(hour="Went to the valley centre", outcome="Bonded", outcome_color="Black"),
"does not follow 'Ignore the scream'": "does not follow 'Ignore the scream'":
dict(scream="Kept walking (ignored it)", resolution="Bullies: my squadmate's revenge", outcome="Died before the hour"), dict(scream="Kept walking (ignored it)", resolution="Bullies: my squadmate's revenge", outcome="Died before the hour"),
"fight answers on a run that did not help": "fight answers on a run that did not help":
@@ -331,7 +333,7 @@ class RedditComments(unittest.TestCase):
{"source": "reddit spreadsheet", "data_flags": "multiple wings"}, {"source": "reddit spreadsheet", "data_flags": "multiple wings"},
{"source": "reported", "data_flags": "Green recorded on a Valley run (no Greens in the valley)"}] {"source": "reported", "data_flags": "Green recorded on a Valley run (no Greens in the valley)"}]
kept = build_policy.drop_flagged(rows) kept = build_policy.drop_flagged(rows)
self.assertEqual([r["source"] for r in kept], ["reddit comment", "reddit spreadsheet", "reported"]) self.assertEqual([r["source"] for r in kept], ["reddit comment", "reddit spreadsheet"])
def test_delivered_not_extracted(self): def test_delivered_not_extracted(self):
spec = read_yaml("collection/pipeline.yaml")["sources"]["reddit_comments"] spec = read_yaml("collection/pipeline.yaml")["sources"]["reddit_comments"]
+32
View File
@@ -0,0 +1,32 @@
// knownAnswer (core/solver.js) against the published data/public/known_answers.json: the guide's recommended answers
// are found on the game's full texts, wrong colours and deadly answers are not picked, and unknown screens stay open.
const test = require("node:test");
const assert = require("node:assert/strict");
const path = require("node:path");
const S = require("../../core/solver.js");
const known = require(path.join(__dirname, "../../data/public/known_answers.json"));
test("the Black: 'Hold its gaze' is the strong pick, 'Lower your eyes' is bad", () => {
const r = S.knownAnswer(known, ["Lower your eyes", "Hold its gaze"], { target: "black", sceneColour: "Black" });
assert.equal(r.pick, 1);
assert.equal(r.confidence, "strong");
assert.equal(r.choices[0].verdict, "bad");
});
test("a guide paraphrase matches the game's full text", () => {
const r = S.knownAnswer(known, ["Climb onto its foreleg", "Reach a hand slowly to touch its talon"], { target: "Red", sceneColour: "Red" });
assert.equal(r.pick, 1);
assert.match(r.reason, /Touch its talon/);
});
test("the two Greens: the answer for the right Green is not the pick for a Brown target", () => {
const offered = ["You respect their nature", "You don't know", "Intellect match"];
assert.equal(S.knownAnswer(known, offered, { target: "Green" }).pick, 0);
assert.equal(S.knownAnswer(known, offered, { target: "Brown" }).pick, 2);
});
test("a screen nobody has seen: no pick, every choice unknown", () => {
const r = S.knownAnswer(known, ["Whistle a tune", "Count the clouds"], { target: "Blue" });
assert.equal(r.pick, null);
assert.deepEqual(r.choices.map((c) => c.verdict), ["unknown", "unknown"]);
});