Author SHA1 Message Date
kathleen ca411e8315 Merge pull request 'The Black on the page: a first-attempt range marked low evidence; the Black panels load again' (#45) from site/black-low-evidence into main
CI / test (push) Successful in 2m9s
Publish the site (pages branch) / publish (push) Successful in 5s
2026-11-19 18:42:22 +00:00
kathleenandClaude Opus 5.5 b51a6c7039 The Black on the page: a first-attempt range marked low evidence; the Black panels load again
CI / test (pull_request) Successful in 40s
- The odds card for the Black: "Low evidence", "about 1 in N" first attempts, the 95% range written as
  "between 1 in X and 1 in Y", later attempts effectively never, why it is uncertain (every logged shadow is a
  rider who chose to post), and the steps (shadow -> reached the Black -> bonded). Dashed border.
- Valley map: the Black's routes are solved for a first attempt (they showed ~0% per attempt), labelled "on a first
  attempt", and "Why this route?" gives the same range and caveat.
- "The Black is not dice" panel: why the odds are uncertain, and what replaces the assumption (fresh-account bot
  runs to the tree).
- analysis/black/evidence.py wrote "odds_ratio": Infinity (no later-attempt shadow at all), which is not JSON:
  the page's two Black panels showed "could not be loaded". Now null, and the report says "unbounded".

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01UCzTd31GphpMXDhQqWrCMQ
2026-11-19 18:40:01 +00:00
kathleen d7befc8e18 Merge pull request 'Review summary on Reddit scraper PRs; measure the form/Reddit overlap' (#44) from atlas/reddit-review into main
Publish the site (pages branch) / publish (push) Successful in 6s
CI / test (push) Successful in 40s
2026-11-19 16:50:48 +00:00
ekcSchianoandClaude Opus 5.5 98be27fc1f Reddit scraper PRs get a review summary; the form/Reddit overlap is measured (#23, #24)
CI / test (pull_request) Successful in 40s
- collection/etl/review_reddit.py (`python -m collection review-reddit`) and .gitea/workflows/reddit-review.yml:
  on every scraper pull request, one comment (refreshed on each push) listing the runs added, changed and gone, the
  runs that break a game rule (left out of the model and stats until corrected), other flags, runs that may also
  be in the form, and result pages already counted; plus how to reject / fix / add. forge.upsert_comment keeps it
  to one comment. collection/README.md: "Reviewing Reddit runs".
- analysis/overlap/overlap.py -> data/public/overlap.json: a Reddit run with at least 4 route answers "matches" a
  form row giving the same answers within a day; chance is the same test a few weeks off. 9 of 36 comparable runs
  match, ~7.3 by chance: about 2 of 82 look reported twice, too few to matter. Nothing is removed. Shown on the
  page's Data & methods tab; in the dataset metadata; checked in test:py; part of `rebuild`.
- Neither the form nor the register records a result-page id, so the only proven copy (comment <-> result page)
  stays the one #18 applies.
- data/public/stats.json: the statistics of #42 (impossible runs left out), which did not make it into that merge.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01UCzTd31GphpMXDhQqWrCMQ
2026-11-19 16:44:52 +00:00
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
37 changed files with 731 additions and 94 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}"
+31
View File
@@ -0,0 +1,31 @@
# A review summary on every Reddit scraper pull request (issue #23): the runs added, changed and gone, the ones that
# break a game rule, other flags, possible copies of form rows, and result pages already counted. Posted as one
# comment on the pull request, refreshed on every push. The reviewer corrects runs in
# collection/manual/reddit_comments.yaml (collection/README.md, "Reviewing Reddit runs"), then merges.
#
# Secrets: ATLAS_BOT_TOKEN (as in update-sources.yml), to post the comment.
name: Review Reddit runs
on:
pull_request:
paths:
- data/public/reddit_comments.json
- collection/manual/reddit_comments.yaml
jobs:
summary:
runs-on: ubuntu-latest
steps:
- uses: actions/checkout@v4
- uses: actions/setup-python@v5
with:
python-version: "3.12"
- run: pip install -r requirements.txt
- name: The file as it is on main
run: |
git fetch --depth 1 origin "${{ github.base_ref }}"
git show FETCH_HEAD:data/public/reddit_comments.json > "$RUNNER_TEMP/base.json" || echo '{"runs": []}' > "$RUNNER_TEMP/base.json"
- name: Build the runs and post the summary
env:
ATLAS_BOT_TOKEN: ${{ secrets.ATLAS_BOT_TOKEN }}
run: |
python -m collection build
python -m collection review-reddit --base "$RUNNER_TEMP/base.json" --out "$RUNNER_TEMP/review.md" --pr "${{ github.event.pull_request.number }}"
+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/
+18 -6
View File
@@ -141,7 +141,8 @@ def build():
c[i + 1] += 1 c[i + 1] += 1
orr, obs, exp, z = mantel_haenszel(by.values()) orr, obs, exp, z = mantel_haenszel(by.values())
facts["same_route"] = {"routes": len(by), "first_shadows": round(obs), "expected": round(exp, 1), facts["same_route"] = {"routes": len(by), "first_shadows": round(obs), "expected": round(exp, 1),
"odds_ratio": round(orr, 1), "z": round(z, 1)} "odds_ratio": round(orr, 1) if math.isfinite(orr) else None, # JSON has no Infinity
"z": round(z, 1)}
facts["form_first"] = [sum(c[0] for c in by.values()), sum(c[1] for c in by.values())] facts["form_first"] = [sum(c[0] for c in by.values()), sum(c[1] for c in by.values())]
facts["form_later"] = [sum(c[2] for c in by.values()), sum(c[3] for c in by.values())] facts["form_later"] = [sum(c[2] for c in by.values()), sum(c[3] for c in by.values())]
L += ["## 2. The same route on a first attempt and on a later one", "", L += ["## 2. The same route on a first attempt and on a later one", "",
@@ -153,7 +154,7 @@ def build():
L.append(f"| {' / '.join(key)} | {frac(y1, n1)} | {frac(y0, n0)} |") L.append(f"| {' / '.join(key)} | {frac(y1, n1)} | {frac(y0, n0)} |")
L += ["", f"Across all {len(by)} recorded routes, comparing first and later attempts on the same route: " L += ["", f"Across all {len(by)} recorded routes, comparing first and later attempts on the same route: "
f"{obs:.0f} first-attempt shadows where {exp:.1f} would be expected if the attempt did not matter " f"{obs:.0f} first-attempt shadows where {exp:.1f} would be expected if the attempt did not matter "
f"(odds ratio {orr:.1f}, z = {z:.1f}). First and later attempts choose almost the same routes, so the " f"(odds ratio {f'{orr:.1f}' if math.isfinite(orr) else 'unbounded: no later-attempt shadow at all'}, z = {z:.1f}). First and later attempts choose almost the same routes, so the "
"difference is not in the recorded choices: it is something about the account, or a choice the form does " "difference is not in the recorded choices: it is something about the account, or a choice the form does "
"not record.", ""] "not record.", ""]
@@ -186,9 +187,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"]]
@@ -255,7 +267,7 @@ def main(argv=None):
ap.add_argument("--check", action="store_true") ap.add_argument("--check", action="store_true")
a = ap.parse_args(argv) a = ap.parse_args(argv)
text, facts = build() text, facts = build()
data = json.dumps(facts, ensure_ascii=False, indent=1) + "\n" data = json.dumps(facts, ensure_ascii=False, indent=1, allow_nan=False) + "\n"
if a.check: if a.check:
for path, want in ((OUT, text), (OUT_JSON, data)): for path, want in ((OUT, text), (OUT_JSON, data)):
if not path.exists() or path.read_text(encoding="utf-8") != want: if not path.exists() or path.read_text(encoding="utf-8") != want:
+112
View File
@@ -0,0 +1,112 @@
"""Is the same attempt reported twice, in the community form and in a Reddit comment? (issue #24)
python analysis/overlap/overlap.py [--check]
There are no player ids, so a copy can only be proven by a shared dragonkind.com result-page id. Neither the form
nor the register records one, and the comment-to-result-page link is already applied when the runs are built
(collection/etl/runs.py). Everything else is measured, never removed:
- a Reddit comment run is *comparable* when it is dated and gives at least MIN_ANSWERS route answers besides how it
ended (fewer answers match dozens of form rows by chance on a busy day);
- it *matches* a form row submitted within WINDOW days when every answer it gives is the form row's answer;
- the same test with the comment's date shifted by a few weeks (SHIFTS, only where the form has rows that week) is
what chance alone produces, so matched - expected is the estimate of runs reported twice.
Writes data/public/overlap.json (the page's Data & methods tab, and the scraper pull-request summary). Nothing is
dropped: identical routes are expected, and the Reddit runs already have their own reporting-bias group in the
route model (planner/policy.yaml).
"""
import argparse
import collections
import datetime as dt
import json
import sys
from pathlib import Path
ROOT = Path(__file__).resolve().parents[2]
sys.path.insert(0, str(ROOT / "core"))
from atlas import runs as runs_io # noqa: E402
OUT = ROOT / "data/public/overlap.json"
FIELDS = ["company", "left_squadmates", "direction", "first_sighting", "sighting_action", "scream", "resolution",
"combat_first", "combat_second", "post_path", "hour", "branch", "outcome", "outcome_color", "tail", "attempt"]
ENDING = ("outcome", "outcome_color")
MIN_ANSWERS = 4
WINDOW = 1
SHIFTS = (-28, -21, -14, 14, 21, 28)
def given(v):
return v not in (None, "") and v != "Unknown" and not (isinstance(v, str) and v.startswith("("))
def answers(r):
return [k for k in FIELDS if given(r.get(k))]
def comparable(r):
return bool(r.get("date")) and len([k for k in answers(r) if k not in ENDING]) >= MIN_ANSWERS
def days(date, shift=0, window=WINDOW):
d = dt.date.fromisoformat(date[:10]) + dt.timedelta(days=shift)
return [(d + dt.timedelta(days=i)).isoformat() for i in range(-window, window + 1)]
def form_index(runs):
by_day = collections.defaultdict(list)
for r in runs:
if r["source"] == "reddit spreadsheet" and r.get("date"):
by_day[r["date"][:10]].append(r)
return by_day
def matches(c, by_day, shift=0):
"""Form rows within the window that give every answer the comment gives."""
keys = answers(c)
return [f for d in days(c["date"], shift) for f in by_day.get(d, []) if all(f.get(k) == c[k] for k in keys)]
def measure(runs):
by_day = form_index(runs)
comments = [r for r in runs if r["source"] == "reddit comment"]
comp = [c for c in comments if comparable(c)]
found = {c["run_id"]: [f["run_id"] for f in matches(c, by_day)] for c in comp}
matched = sum(1 for v in found.values() if v)
# chance: each comment's match rate on shifted dates, over the shifts whose window has form rows at all
expected = 0.0
for c in comp:
valid = [s for s in SHIFTS if any(by_day.get(d) for d in days(c["date"], s))]
if valid:
expected += sum(1 for s in valid if matches(c, by_day, s)) / len(valid)
return {
"schema": 1,
"rule": {"min_answers": MIN_ANSWERS, "window_days": WINDOW, "baseline_shifts_days": list(SHIFTS)},
"comment_runs": len(comments),
"comparable": len(comp),
"matched": matched,
"expected_by_chance": round(expected, 1),
"likely_double": round(max(0.0, matched - expected), 1),
"matches": [{"comment": k, "form": v} for k, v in sorted(found.items()) if v],
}
def main(argv=None):
ap = argparse.ArgumentParser(description=__doc__, formatter_class=argparse.RawDescriptionHelpFormatter)
ap.add_argument("--check", action="store_true", help="fail if data/public/overlap.json is out of date")
a = ap.parse_args(argv)
text = json.dumps(measure(runs_io.read(drop=())), indent=1, ensure_ascii=False) + "\n"
if a.check:
if not OUT.exists() or OUT.read_text(encoding="utf-8") != text:
print(f"out of date (run `python {Path(__file__).relative_to(ROOT)}`): {OUT.relative_to(ROOT)}")
return 1
return 0
OUT.write_text(text, encoding="utf-8")
m = json.loads(text)
print(f"{OUT.relative_to(ROOT)}: {m['matched']} of {m['comparable']} comparable Reddit runs match a form row "
f"(~{m['expected_by_chance']} by chance; ~{m['likely_double']} likely reported twice)")
return 0
if __name__ == "__main__":
sys.exit(main())
+2 -2
View File
@@ -31,7 +31,7 @@ If the shadow depended only on the choices the form records (company, first dire
| Alone / Center / Assess the situation / Daggers or not (protect squadmate) / Left bullies to the dragons / Forest | 1 / 28 (3.6%) | 0 / 64 (0.0%) | | Alone / Center / Assess the situation / Daggers or not (protect squadmate) / Left bullies to the dragons / Forest | 1 / 28 (3.6%) | 0 / 64 (0.0%) |
| Alone / Center / Assess the situation / Engage the smaller cadet / Squadmate's revenge / West | 2 / 9 (22.2%) | 0 / 81 (0.0%) | | Alone / Center / Assess the situation / Engage the smaller cadet / Squadmate's revenge / West | 2 / 9 (22.2%) | 0 / 81 (0.0%) |
Across all 326 recorded routes, comparing first and later attempts on the same route: 93 first-attempt shadows where 38.8 would be expected if the attempt did not matter (odds ratio inf, z = 12.5). First and later attempts choose almost the same routes, so the difference is not in the recorded choices: it is something about the account, or a choice the form does not record. Across all 326 recorded routes, comparing first and later attempts on the same route: 93 first-attempt shadows where 38.8 would be expected if the attempt did not matter (odds ratio unbounded: no later-attempt shadow at all, z = 12.5). First and later attempts choose almost the same routes, so the difference is not in the recorded choices: it is something about the account, or a choice the form does not record.
## 3. On one route, is the shadow decided by the cadet's wing, section and squad? ## 3. On one route, is the shadow decided by the cadet's wing, section and squad?
@@ -56,7 +56,7 @@ 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: 17 (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
+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")
+19
View File
@@ -41,6 +41,25 @@ The route PDF is a flowchart of the choices, not a log of runs, so it adds no ro
fingerprint tells us when the routes it documents change. The register lists bonded dragons without the route that fingerprint tells us when the routes it documents change. The register lists bonded dragons without the route that
led there, so it adds no rows either. led there, so it adds no rows either.
## Reviewing Reddit runs
Ken's scraper opens (or updates) a pull request from `data/reddit-comments` that changes
`data/public/reddit_comments.json`. The **Review Reddit runs** workflow (`.gitea/workflows/reddit-review.yml`) posts a
summary on it, refreshed on every push (`python -m collection review-reddit --base <main's file>` locally):
- runs added, changed and gone since main;
- **runs that break a game rule** (`core/spec/form.yaml` `impossible_flags`): left out of the route model and the
statistics until corrected. Open the comment and decide;
- other flags on the new runs (kept);
- runs that may also be in the community form: the same answers within a day, with how many chance alone gives
(`analysis/overlap/overlap.py`, `data/public/overlap.json`). Measured only, never removed;
- runs whose result page is already a `reddit thread` row (counted once automatically).
Corrections go in `manual/reddit_comments.yaml`, applied at build time, so they never wait for the threads:
`reject: [id]` (not a run), `fix: {id: {question: answer}}` (misread; `null` removes an answer) and
`add: [{id, thread, posted, answers}]` (missed). A corrected run loses the "not checked by hand" note. No usernames:
the comment id is enough to find the comment again. Then merge, once CI passes.
## Raw files and privacy ## Raw files and privacy
`data/raw/` is git-ignored and never published. It holds the current raw file of each source and the one before `data/raw/` is git-ignored and never published. It holds the current raw file of each source and the one before
+12
View File
@@ -131,6 +131,18 @@ def open_issue(title, body, env=None, f=None):
return _call("POST", f"{api_base(f)}/issues", {"title": title, "body": body}, tok, f)["number"] return _call("POST", f"{api_base(f)}/issues", {"title": title, "body": body}, tok, f)["number"]
def upsert_comment(number, marker, body, env=None, f=None):
"""Post `body` on issue or pull request `number`, replacing an earlier comment that starts with `marker`
(so a summary refreshed on every push stays one comment)."""
f = f or config()
tok = token(env)
comments = _call("GET", f"{api_base(f)}/issues/{number}/comments?limit=50&per_page=100", tok=tok, f=f) or []
mine = [c for c in comments if (c.get("body") or "").startswith(marker)]
if mine:
return _call("PATCH", f"{api_base(f)}/issues/comments/{mine[-1]['id']}", {"body": body}, tok, f)["id"]
return _call("POST", f"{api_base(f)}/issues/{number}/comments", {"body": body}, tok, f)["id"]
def ensure_label(name, color, env=None, f=None): def ensure_label(name, color, env=None, f=None):
f = f or config() f = f or config()
tok = token(env) tok = token(env)
+1
View File
@@ -88,6 +88,7 @@ def rebuild():
_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"]) _step("known answers for the bot (guide + screen tree)", [py, "analysis/known/build_known.py"])
_step("runs reported twice (form + Reddit)", [py, "analysis/overlap/overlap.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": [
+133
View File
@@ -0,0 +1,133 @@
"""A review summary for a Reddit scraper pull request (issue #23).
python -m collection review-reddit --base BASE.json [--out summary.md] [--pr N]
Compares the pull request's data/public/reddit_comments.json with `BASE.json` (the same file on main) and reads the
runs as built from it (data/public/runs_clean.csv, so run `python -m collection build` first). The summary lists
what a reviewer needs to decide on, before merging:
- runs added, changed (answers differ) and gone;
- runs that break a game rule: left out of the route model and the statistics until corrected;
- other flags on the new or changed runs (kept, for information);
- runs that may also be in the community form (analysis/overlap/overlap.py: same answers within a day);
- runs whose result page is already a "reddit thread" row (counted once, automatically).
Corrections go in collection/manual/reddit_comments.yaml (reject / fix / add; see collection/README.md). With
`--pr N` the summary is posted on the pull request, replacing the previous one.
"""
import importlib.util
import json
import sys
from .common import ROOT, path, pipeline, read_yaml
MARKER = "<!-- atlas:reddit-review -->"
PROVENANCE = "read from a Reddit comment"
def _overlap():
spec = importlib.util.spec_from_file_location("overlap", ROOT / "analysis/overlap/overlap.py")
mod = importlib.util.module_from_spec(spec)
spec.loader.exec_module(mod)
return mod
def link(run_id, thread):
cid = str(run_id).split("-")[0]
return f"[{run_id}](https://www.reddit.com/r/fourthwing/comments/{thread}/_/{cid}/)"
def diff(base, head):
"""(added, changed, gone) comment-run ids between two reddit_comments.json documents."""
b = {str(r["id"]): r for r in base.get("runs", [])}
h = {str(r["id"]): r for r in head.get("runs", [])}
added = sorted(set(h) - set(b))
gone = sorted(set(b) - set(h))
changed = sorted(k for k in set(h) & set(b) if h[k].get("answers") != b[k].get("answers"))
return added, changed, gone
def summary(base, head, runs, known_results=(), overlap=None):
"""The Markdown summary. `runs`: typed records of runs_clean.csv (with run_id)."""
sys.path.insert(0, str(ROOT / "core"))
from atlas import runs as runs_io
added, changed, gone = diff(base, head)
focus = set(added) | set(changed)
thread = {str(r["id"]): r.get("thread") for r in head.get("runs", [])}
result = {str(r["id"]): r.get("result") for r in head.get("runs", [])}
rows = {r["run_id"][len("comment-"):]: r for r in runs if r["source"] == "reddit comment"}
flags = {k: [f for f in (r.get("data_flags") or "").split("; ") if f and not f.startswith(PROVENANCE)]
for k, r in rows.items()}
impossible = sorted(k for k in rows if runs_io.impossible(rows[k]))
L = [MARKER, "## Reddit comment runs: review summary", ""]
L.append(f"**{len(head.get('runs', []))} runs** in this file: **{len(added)} new**, {len(changed)} changed, "
f"{len(gone)} gone since main. {head.get('unread', 0)} comments mention a bond or a burn but could not "
"be read as a run.")
L.append("")
L += ["### Runs that break a game rule", "",
"Left out of the route model and the statistics until corrected. Check the comment: `fix` a misread "
"answer, or `reject` a run that is not one.", ""]
bad = [k for k in impossible if k in focus] + [k for k in impossible if k not in focus]
if bad:
L += ["| Run | New? | Rule |", "|---|---|---|"]
L += [f"| {link(k, thread.get(k) or '')} | {'yes' if k in focus else ''} | "
f"{'; '.join(f for f in flags[k] if runs_io.impossible({'data_flags': f}))} |" for k in bad]
else:
L.append("None.")
L.append("")
other = [k for k in sorted(focus) if k in flags and flags[k] and k not in impossible]
L += ["### Other flags on new or changed runs (kept)", ""]
L += [f"- {link(k, thread.get(k) or '')}: {'; '.join(flags[k])}" for k in other] or ["None."]
L.append("")
if overlap is not None:
twice = {m["comment"][len("comment-"):]: m["form"] for m in overlap.get("matches", [])}
hits = [k for k in sorted(focus) if k in twice]
L += ["### May also be in the community form", "",
f"Same answers as a form row submitted within {overlap['rule']['window_days']} day(s). Over all Reddit "
f"runs: {overlap['matched']} of {overlap['comparable']} comparable runs match, about "
f"{overlap['expected_by_chance']} by chance, so about {overlap['likely_double']} look reported twice. "
"Nothing is removed: identical routes are expected.", ""]
L += [f"- {link(k, thread.get(k) or '')}: {', '.join(twice[k][:5])}" for k in hits] or ["None among the new runs."]
L.append("")
counted = [k for k in sorted(focus) if result.get(k) and str(result[k]).upper() in known_results]
L += ["### Result pages already counted", "",
"Their result page is also a \"reddit thread\" row; the run is counted once, with its route.", ""]
L += [f"- {link(k, thread.get(k) or '')}: {result[k]}" for k in counted] or ["None."]
L.append("")
L += ["### How to correct", "",
"In `collection/manual/reddit_comments.yaml` (applied at build time, on this branch or later):",
"- `reject: [comment id]`: not a run (a joke, a friend's run, two runs told as one);",
"- `fix: {comment id: {question: answer}}`: answers read wrong (`null` removes one);",
"- `add: [{id, thread, posted, answers}]`: a run the reader missed.",
"", "A corrected run loses the \"not checked by hand\" note. Then merge."]
return "\n".join(L) + "\n"
def main(base_file, out=None, pr=None):
sys.path.insert(0, str(ROOT / "core"))
from atlas import runs as runs_io
spec = pipeline()["sources"]["reddit_comments"]
base = json.loads(open(base_file, encoding="utf-8").read()) if base_file else {"runs": []}
head = json.loads(path(spec["load"]).read_text(encoding="utf-8"))
runs = runs_io.read(drop=())
thread_spec = pipeline()["sources"].get("reddit_thread") or {}
manual = (thread_spec.get("transform") or {}).get("manual")
known = {str(r["id"]).upper() for r in (read_yaml(manual)["results"] if manual else [])}
text = summary(base, head, runs, known, _overlap().measure(runs))
if out:
open(out, "w", encoding="utf-8").write(text)
else:
print(text)
if pr:
from . import forge
forge.upsert_comment(int(pr), MARKER, text)
print(f"summary posted on #{pr}")
return 0
+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
@@ -132,6 +132,10 @@ def main(argv=None):
k.add_argument("--out", default="exports") k.add_argument("--out", default="exports")
sub.add_parser("rebuild", help="rebuild everything made from the runs: graph, route model, plan, reports, statistics, build") sub.add_parser("rebuild", help="rebuild everything made from the runs: graph, route model, plan, reports, statistics, build")
sub.add_parser("send-pdf", help="open a pull request on the bot's repo when the route PDF changed (private copy only)") sub.add_parser("send-pdf", help="open a pull request on the bot's repo when the route PDF changed (private copy only)")
rv = sub.add_parser("review-reddit", help="a review summary for a Reddit scraper pull request (run `build` first)")
rv.add_argument("--base", help="data/public/reddit_comments.json as it is on main")
rv.add_argument("--out", help="write the summary here (default: print it)")
rv.add_argument("--pr", help="also post it on this pull request, replacing the previous summary")
r = sub.add_parser("refresh", help="update every source, then rebuild everything (the daily workflow, locally)") r = sub.add_parser("refresh", help="update every source, then rebuild everything (the daily workflow, locally)")
r.add_argument("--bot", action="append", default=[], help="a bot folder or a .zip of its data (repeatable)") r.add_argument("--bot", action="append", default=[], help="a bot folder or a .zip of its data (repeatable)")
c = sub.add_parser("cycle", help="the loop with the bot: import its runs, refit, re-plan, deliver (safe on a timer)") c = sub.add_parser("cycle", help="the loop with the bot: import its runs, refit, re-plan, deliver (safe on a timer)")
@@ -155,6 +159,9 @@ def main(argv=None):
if a.cmd == "rebuild": if a.cmd == "rebuild":
from .etl.handoff import rebuild from .etl.handoff import rebuild
return rebuild() return rebuild()
if a.cmd == "review-reddit":
from .etl.review_reddit import main as review
return review(a.base, a.out, a.pr)
if a.cmd == "send-pdf": if a.cmd == "send-pdf":
from .etl.send_pdf import send from .etl.send_pdf import send
return send() return send()
+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:
+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]
+34 -14
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": "657da20e614160d2a44d8854937270c7867fb9ae470509de1e12516f07d2af23", "sha256": "b5e121cf5deab5f8bc1420b34a5bc434d6f933c7452e200eed4891c35de45122",
"contentSize": "3748021 B" "contentSize": "3748768 B"
}, },
{ {
"@type": "cr:FileObject", "@type": "cr:FileObject",
@@ -116,6 +126,16 @@
"sha256": "b169d157e731db23c99f2f8317a9718d31801b7d64336b3d414511ac13f32493", "sha256": "b169d157e731db23c99f2f8317a9718d31801b7d64336b3d414511ac13f32493",
"contentSize": "23174 B" "contentSize": "23174 B"
}, },
{
"@type": "cr:FileObject",
"@id": "overlap",
"name": "overlap",
"description": "How many Reddit comment runs may also be in the community form (the same answers within a day), against what chance alone gives (analysis/overlap/overlap.py). Measured only: no run is removed.",
"contentUrl": "https://git.kenschiano.net/DragonKind/threshing-atlas/raw/branch/main/data/public/overlap.json",
"encodingFormat": "application/json",
"sha256": "04280a52f028334451c505ddc35004d98cc1f4595b2294c3746a09e34454e8b0",
"contentSize": "1976 B"
},
{ {
"@type": "cr:FileObject", "@type": "cr:FileObject",
"@id": "reports", "@id": "reports",
@@ -143,8 +163,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": "bb401225065ae17311bbd02fd63acd4010f4e325d7eab74e044115b98d04bec4", "sha256": "7431173d9b667d4914d17bbc299d994d14c3104e3e89a1eb75d690c1b21ade6a",
"contentSize": "5498476 B" "contentSize": "5110214 B"
}, },
{ {
"@type": "cr:FileObject", "@type": "cr:FileObject",
@@ -153,8 +173,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",
+6
View File
@@ -41,6 +41,12 @@ files:
description: >- description: >-
Runs described in the r/fourthwing megathread comments, read into the "Report a run" answers: comment id, day 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. and answers only, no usernames or comment text.
overlap:
path: data/public/overlap.json
format: application/json
description: >-
How many Reddit comment runs may also be in the community form (the same answers within a day), against what
chance alone gives (analysis/overlap/overlap.py). Measured only: no run is removed.
reports: reports:
path: data/public/reports.json path: data/public/reports.json
format: application/json format: application/json
+3 -2
View File
@@ -84,7 +84,7 @@
"routes": 326, "routes": 326,
"first_shadows": 93, "first_shadows": 93,
"expected": 38.8, "expected": 38.8,
"odds_ratio": Infinity, "odds_ratio": null,
"z": 12.5 "z": 12.5
}, },
"form_first": [ "form_first": [
@@ -116,7 +116,8 @@
"shadow_routes": { "shadow_routes": {
"runs": 97, "runs": 97,
"routes": 47, "routes": 47,
"off_gate": 17 "off_gate": 3,
"gates_unstated": 14
}, },
"after_shadow": { "after_shadow": {
"reached_black": 89, "reached_black": 89,
+134
View File
@@ -0,0 +1,134 @@
{
"schema": 1,
"rule": {
"min_answers": 4,
"window_days": 1,
"baseline_shifts_days": [
-28,
-21,
-14,
14,
21,
28
]
},
"comment_runs": 82,
"comparable": 36,
"matched": 9,
"expected_by_chance": 7.3,
"likely_double": 1.7,
"matches": [
{
"comment": "comment-pdjr7gm",
"form": [
"sheet-8",
"sheet-38"
]
},
{
"comment": "comment-pdq6tsw",
"form": [
"sheet-168",
"sheet-190",
"sheet-398"
]
},
{
"comment": "comment-pe0kwol",
"form": [
"sheet-224"
]
},
{
"comment": "comment-pe2l6mz",
"form": [
"sheet-5",
"sheet-25",
"sheet-107",
"sheet-292",
"sheet-393",
"sheet-471",
"sheet-483",
"sheet-514",
"sheet-520"
]
},
{
"comment": "comment-pe2n3j1",
"form": [
"sheet-195",
"sheet-276"
]
},
{
"comment": "comment-pev3uge",
"form": [
"sheet-870",
"sheet-916",
"sheet-934",
"sheet-960",
"sheet-961",
"sheet-962",
"sheet-975",
"sheet-984",
"sheet-999",
"sheet-1008",
"sheet-1009",
"sheet-1019",
"sheet-1023",
"sheet-1068",
"sheet-1069",
"sheet-1077",
"sheet-1081",
"sheet-1089",
"sheet-1097",
"sheet-1101",
"sheet-1110",
"sheet-1129",
"sheet-1194",
"sheet-1200",
"sheet-1201",
"sheet-1235",
"sheet-1238",
"sheet-1257",
"sheet-1259",
"sheet-1264",
"sheet-1271",
"sheet-1278",
"sheet-1283",
"sheet-1290",
"sheet-1292"
]
},
{
"comment": "comment-pf22tpj",
"form": [
"sheet-1031",
"sheet-1042",
"sheet-1048",
"sheet-1140",
"sheet-1142",
"sheet-1143",
"sheet-1144",
"sheet-1171",
"sheet-1261",
"sheet-1262",
"sheet-1303",
"sheet-1304",
"sheet-1364"
]
},
{
"comment": "comment-pfhmw5d",
"form": [
"sheet-1504"
]
},
{
"comment": "comment-pgzz9hc",
"form": [
"sheet-1714"
]
}
]
}
File diff suppressed because one or more lines are too long
+10 -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",
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)
+2 -2
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 && 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: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 && python3 analysis/overlap/overlap.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 tests/core/known.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 && python3 analysis/known/build_known.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 && python3 analysis/overlap/overlap.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
+3 -1
View File
@@ -84,6 +84,7 @@
// ------------------------------------------------------------ data loading // ------------------------------------------------------------ data loading
async function loadStats() { async function loadStats() {
state.stats = await (await fetch("data/stats.json")).json(); state.stats = await (await fetch("data/stats.json")).json();
try { state.overlap = await (await fetch("data/overlap.json")).json(); } catch { state.overlap = null; }
const sel = $("#f-preset"); const sel = $("#f-preset");
sel.innerHTML = Object.entries(META().presets).map(([k, l]) => `<option value="${k}">${esc(l)}</option>`).join(""); sel.innerHTML = Object.entries(META().presets).map(([k, l]) => `<option value="${k}">${esc(l)}</option>`).join("");
sel.value = state.preset; sel.value = state.preset;
@@ -554,7 +555,8 @@
</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> ${state.overlap && state.overlap.comparable ? `<div class="panel"><h3>The same run reported twice?</h3><p class="small">A rider may log a run in the form and post it in a megathread comment too. With no player IDs, a copy can only be measured, not proven, so nothing is removed. Of ${state.overlap.comparable} Reddit runs detailed enough to compare, ${state.overlap.matched} give the same answers as a form row sent within ${state.overlap.rule.window_days} day; chance alone (the same test a few weeks off) gives about ${state.overlap.expected_by_chance}. So about ${Math.round(state.overlap.likely_double)} of ${state.overlap.comment_runs} Reddit runs look reported twice${state.overlap.likely_double < 0.1 * state.overlap.comment_runs ? ", too few to matter" : ""}.</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];
+7 -6
View File
@@ -92,7 +92,8 @@
const model = () => st.policy.samples[st.sample]; const model = () => st.policy.samples[st.sample];
function advisorFor(enc, colour = st.colour) { function advisorFor(enc, colour = st.colour) {
const k = `${st.sample}|${colour}|${st.objective}|${enc}`; const k = `${st.sample}|${colour}|${st.objective}|${enc}`;
if (!st.cache.has(k)) st.cache.set(k, S.advisor(model(), colour, st.objective, { only: [enc] })); // the Black needs the shadow, which (almost) only shows on a first attempt: its routes are solved for that attempt
if (!st.cache.has(k)) st.cache.set(k, S.advisor(model(), colour, st.objective, { only: [enc], attempt: colour === "Black" ? "First attempt" : null }));
return st.cache.get(k); return st.cache.get(k);
} }
let encParams = null; let encParams = null;
@@ -530,7 +531,7 @@
}); });
// destination label // destination label
const end = pts[pts.length - 1]; const end = pts[pts.length - 1];
pill(gLab, end.P.x, end.P.y + 30, `${pct(r.value.x)} per attempt`, { edge: tc, strong: rel === 1 }); pill(gLab, end.P.x, end.P.y + 30, `${pct(r.value.x)} ${st.colour === "Black" ? "on a first attempt" : "per attempt"}`, { edge: tc, strong: rel === 1 });
// choice points on the focused route: one diamond per place, even when several choices are made there // choice points on the focused route: one diamond per place, even when several choices are made there
// (at the bully fight: help or walk away, your first move, the dagger, then the bullies' fate) // (at the bully fight: help or walk away, your first move, the dagger, then the bullies' fate)
if (focus) { if (focus) {
@@ -841,7 +842,7 @@
function panelRoutes(routes) { function panelRoutes(routes) {
const best = Math.max(1e-12, ...routes.map((r) => r.value.x)); const best = Math.max(1e-12, ...routes.map((r) => r.value.x));
const T = model().targets[st.colour], b = T[st.objective]; const T = model().targets[st.colour], first = st.colour === "Black" && T.firstAttempt, b = first ? T.firstAttempt.thisAttempt : T[st.objective];
const focus = routes.find((r) => r.enc === st.focus) || routes[0]; const focus = routes.find((r) => r.enc === st.focus) || routes[0];
const card = (r) => { const card = (r) => {
const rel = r.value.x / best, o = encOutcome(r.enc), c = encColour(r.enc); const rel = r.value.x / best, o = encOutcome(r.enc), c = encColour(r.enc);
@@ -851,7 +852,7 @@
return `<button type="button" class="ex-route-card${r.enc === focus.enc ? " on" : ""}" data-enc="${r.enc}" aria-pressed="${r.enc === focus.enc}"> return `<button type="button" class="ex-route-card${r.enc === focus.enc ? " on" : ""}" data-enc="${r.enc}" aria-pressed="${r.enc === focus.enc}">
<i class="ex-swatch ${style}" style="--c: var(${DV[st.colour]}); opacity:${(0.3 + 0.7 * rel).toFixed(2)}"></i> <i class="ex-swatch ${style}" style="--c: var(${DV[st.colour]}); opacity:${(0.3 + 0.7 * rel).toFixed(2)}"></i>
<span class="nm">${esc(ENC_NAME[r.enc])}${RESCUE[st.colour] === r.enc && st.colour !== "Green" ? " <em>(rescue)</em>" : ""}</span> <span class="nm">${esc(ENC_NAME[r.enc])}${RESCUE[st.colour] === r.enc && st.colour !== "Green" ? " <em>(rescue)</em>" : ""}</span>
<b>${pct(r.value.x)}</b><small>per attempt · ${bond}${n < 30 ? ` · only ${n} attempts logged` : ""}${r.value.o > 0.005 ? ` · ends on another dragon ${pct(r.value.o)}` : ""}</small></button>`; <b>${pct(r.value.x)}</b><small>${st.colour === "Black" ? "on a first attempt" : "per attempt"} · ${bond}${n < 30 ? ` · only ${n} attempts logged` : ""}${r.value.o > 0.005 ? ` · ends on another dragon ${pct(r.value.o)}` : ""}</small></button>`;
}; };
const steps = focus.steps.filter((s) => s.kind === "decision" || s.kind === "chance").map((s) => { const steps = focus.steps.filter((s) => s.kind === "decision" || s.kind === "chance").map((s) => {
if (s.kind === "chance") return `<li class="chance"><span>${esc(s.label)}</span><b>${esc(String(s.taken))}</b><small>roll ${pct(s.probs[s.taken])}</small></li>`; if (s.kind === "chance") return `<li class="chance"><span>${esc(s.label)}</span><b>${esc(String(s.taken))}</b><small>roll ${pct(s.probs[s.taken])}</small></li>`;
@@ -862,7 +863,7 @@
return `<li class="dec${open ? " open" : ""}"><button type="button" class="ex-step" data-var="${s.var}" aria-expanded="${open}"><span>${esc(s.label)}</span><b>${esc(String(s.taken))}</b><small>${s.userSet ? "your choice" : "best"} · ${s.var === "encounter" ? pct(s.options[s.taken].pX) : pct(s.options[s.taken].pX)}</small></button>${opts}${inside}</li>`; return `<li class="dec${open ? " open" : ""}"><button type="button" class="ex-step" data-var="${s.var}" aria-expanded="${open}"><span>${esc(s.label)}</span><b>${esc(String(s.taken))}</b><small>${s.userSet ? "your choice" : "best"} · ${s.var === "encounter" ? pct(s.options[s.taken].pX) : pct(s.options[s.taken].pX)}</small></button>${opts}${inside}</li>`;
}).join(""); }).join("");
const risks = focus.steps.filter((s) => s.risk && s.risk.p > 0.0005).map((s) => `${s.risk.label.toLowerCase()} ${pct(s.risk.p)}`); const risks = focus.steps.filter((s) => s.risk && s.risk.p > 0.0005).map((s) => `${s.risk.label.toLowerCase()} ${pct(s.risk.p)}`);
const lb = st.policy.samples.lowBias.targets[st.colour].thisAttempt; const lbT = st.policy.samples.lowBias.targets[st.colour], lb = first && lbT.firstAttempt ? lbT.firstAttempt.thisAttempt : lbT.thisAttempt;
return `<div class="ex-head" style="--c: var(${DV[st.colour]})">${mini(st.colour, POSE_OF[st.colour])}<div><span class="eyebrow">Routes to a</span><h2 id="h-valley">${st.colour} dragon</h2></div> return `<div class="ex-head" style="--c: var(${DV[st.colour]})">${mini(st.colour, POSE_OF[st.colour])}<div><span class="eyebrow">Routes to a</span><h2 id="h-valley">${st.colour} dragon</h2></div>
<button type="button" class="ex-close" id="ex-clear" aria-label="Back to the whole valley">×</button></div> <button type="button" class="ex-close" id="ex-clear" aria-label="Back to the whole valley">×</button></div>
${chooser()} ${chooser()}
@@ -874,7 +875,7 @@
<ol class="ex-steps">${steps}</ol> <ol class="ex-steps">${steps}</ol>
<p class="small muted">Diamonds on the map are choices: click one to see where the other options lead. ${st.blocked ? "" : `Your choices apply to every route to this dragon. Changed your mind? <button type="button" class="linklike" id="ex-reset-route">Reset your choices</button>`}</p> <p class="small muted">Diamonds on the map are choices: click one to see where the other options lead. ${st.blocked ? "" : `Your choices apply to every route to this dragon. Changed your mind? <button type="button" class="linklike" id="ex-reset-route">Reset your choices</button>`}</p>
<details class="ex-why"><summary>Why this route?</summary> <details class="ex-why"><summary>Why this route?</summary>
<p class="small">Best route for any ${st.colour}: <b>${pct(b.pX.mean)}</b> per attempt (95% interval ${pct(b.pX.lo)}–${pct(b.pX.hi)}), about ${isFinite(b.expectedAttempts.mean) ? Math.round(b.expectedAttempts.mean) : "–"} attempts. Riders who logged every run suggest ${pct(lb.pX.mean)}.</p> ${first ? `<p class="small"><span class="pill warn">Low evidence</span> Best route for the Black, on a <b>first attempt</b>: about <b>1 in ${Math.round(1 / Math.max(b.pX.mean, 1e-9))}</b>, somewhere between 1 in ${Math.round(1 / Math.max(b.pX.hi, 1e-9))} and 1 in ${Math.round(1 / Math.max(b.pX.lo, 1e-9))} (95%). Later attempts almost never see the shadow. The low-bias sample suggests about 1 in ${Math.round(1 / Math.max(lb.pX.mean, 1e-9))}. Every logged shadow comes from riders who chose to post their run, so the shadow's odds rest on an assumption until complete first-attempt logs exist.</p>` : `<p class="small">Best route for any ${st.colour}: <b>${pct(b.pX.mean)}</b> per attempt (95% interval ${pct(b.pX.lo)}–${pct(b.pX.hi)}), about ${isFinite(b.expectedAttempts.mean) ? Math.round(b.expectedAttempts.mean) : "–"} attempts. Riders who logged every run suggest ${pct(lb.pX.mean)}.</p>`}
<p class="small">Each roll's odds may depend on your earlier choices, as far as the data support it. Choices marked "no clear winner" in <a href="#deep">Deep Dive</a> are within the noise.${risks.length ? ` Risks on this route: ${risks.join(", ")}.` : ""}</p> <p class="small">Each roll's odds may depend on your earlier choices, as far as the data support it. Choices marked "no clear winner" in <a href="#deep">Deep Dive</a> are within the noise.${risks.length ? ` Risks on this route: ${risks.join(", ")}.` : ""}</p>
<p class="small">The bond chance at each encounter is the community average: the form does not record the answers riders gave there.</p> <p class="small">The bond chance at each encounter is the community average: the form does not record the answers riders gave there.</p>
<div class="seg" role="group" aria-label="Data"><button type="button" data-s="all" aria-pressed="${st.sample === "all"}">All runs</button><button type="button" data-s="lowBias" aria-pressed="${st.sample === "lowBias"}">Low-bias</button></div> <div class="seg" role="group" aria-label="Data"><button type="button" data-s="all" aria-pressed="${st.sample === "all"}">All runs</button><button type="button" data-s="lowBias" aria-pressed="${st.sample === "lowBias"}">Low-bias</button></div>
+2
View File
@@ -182,6 +182,8 @@ section h2 { font-family: var(--font-crest); letter-spacing: 0.03em; }
.odd .big { font-family: var(--font-crest); font-weight: 700; font-size: 2.1rem; line-height: 1; color: var(--c, var(--ink)); } .odd .big { font-family: var(--font-crest); font-weight: 700; font-size: 2.1rem; line-height: 1; color: var(--c, var(--ink)); }
.odd .what { font-weight: 600; } .odd .what { font-weight: 600; }
.odd .how { font-size: var(--step--1); color: var(--muted); } .odd .how { font-size: var(--step--1); color: var(--muted); }
.odd-low { border-style: dashed; }
.odd-low .big { opacity: 0.85; }
.odd svg { display: block; width: 100%; max-width: 220px; height: auto; } .odd svg { display: block; width: 100%; max-width: 220px; height: auto; }
.odd::before { content: ""; position: absolute; inset: 0 auto 0 0; width: 4px; background: var(--c, var(--line)); } .odd::before { content: ""; position: absolute; inset: 0 auto 0 0; width: 4px; background: var(--c, var(--line)); }
.combo { display: grid; grid-template-columns: repeat(auto-fit, minmax(min(100%, 320px), 1fr)); gap: 16px; } .combo { display: grid; grid-template-columns: repeat(auto-fit, minmax(min(100%, 320px), 1fr)); gap: 16px; }
+10
View File
@@ -159,6 +159,8 @@
if (!b) { if (t2) t2.innerHTML = '<h3>Your first attempt is different</h3><p class="small muted">The shadow evidence could not be loaded.</p>'; return; } if (!b) { if (t2) t2.innerHTML = '<h3>Your first attempt is different</h3><p class="small muted">The shadow evidence could not be loaded.</p>'; return; }
const ff = b.form_first, fl = b.form_later, sr = b.same_route, as = b.after_shadow, gaze = as.answers["held its gaze"]; const ff = b.form_first, fl = b.form_later, sr = b.same_route, as = b.after_shadow, gaze = as.answers["held its gaze"];
if (t2) t2.innerHTML = `<h3>Your first attempt is different</h3><p class="small">Among riders who helped their squadmate and climbed the tree, the shadow came in <b>${frac(ff)}</b> first attempts (${pct(ff[0] / ff[1], 1)}) and <b>${frac(fl)}</b> later ones. On the very same routes, first attempts saw it about ${Math.round(sr.first_shadows / Math.max(sr.expected, 1) * 10) / 10}× as often as chance would give. The shadow is not a dice roll you can repeat.</p>`; if (t2) t2.innerHTML = `<h3>Your first attempt is different</h3><p class="small">Among riders who helped their squadmate and climbed the tree, the shadow came in <b>${frac(ff)}</b> first attempts (${pct(ff[0] / ff[1], 1)}) and <b>${frac(fl)}</b> later ones. On the very same routes, first attempts saw it about ${Math.round(sr.first_shadows / Math.max(sr.expected, 1) * 10) / 10}× as often as chance would give. The shadow is not a dice roll you can repeat.</p>`;
const steps = $("#black-steps");
if (steps) steps.innerHTML = `How it breaks down: the shadow came in ${frac(ff)} reported first attempts (over-reported); after it, ${as.reached_black} riders reached the Black and <b>${as.bonded_black}</b> bonded (${pct(as.bonded_black / Math.max(as.reached_black, 1))}).`;
if (!box) return; if (!box) return;
const br = b.best_route; const br = b.best_route;
box.hidden = false; box.hidden = false;
@@ -170,6 +172,7 @@
${gaze ? `<li>At the Black, riders who held its gaze bonded in <b>${frac(gaze)}</b> logged answers.</li>` : ""} ${gaze ? `<li>At the Black, riders who held its gaze bonded in <b>${frac(gaze)}</b> logged answers.</li>` : ""}
<li>The bot has made ${b.bot.attempts.toLocaleString()} attempts on ${b.bot.accounts} accounts, ${b.bot.gated_tree} on the gated path, and seen the shadow ${b.bot.shadows} times: none of them was a first attempt${b.bot.earliest_attempt ? ` (its earliest was attempt ${b.bot.earliest_attempt})` : ""}, which fits.</li> <li>The bot has made ${b.bot.attempts.toLocaleString()} attempts on ${b.bot.accounts} accounts, ${b.bot.gated_tree} on the gated path, and seen the shadow ${b.bot.shadows} times: none of them was a first attempt${b.bot.earliest_attempt ? ` (its earliest was attempt ${b.bot.earliest_attempt})` : ""}, which fits.</li>
</ul> </ul>
<p class="small"><b>Why the Black's odds are uncertain.</b> The Black comes only after the shadow, and every logged shadow comes from riders who chose to post their run. Riders are much more likely to post a run with a shadow than one without, and no complete log (the bot, bulk logs) has a first attempt with a shadow yet, so the estimate assumes riders over-report the shadow as much as the meadow Blue. Fresh accounts the bot plays to the tree on their first attempt will replace that assumption; until then the odds are a range, not a figure.</p>
<p class="small muted">Method and every table: <code>analysis/reports/BLACK.md</code>; the numbers: <a href="data/black.json">data/black.json</a>.</p>`; <p class="small muted">Method and every table: <code>analysis/reports/BLACK.md</code>; the numbers: <a href="data/black.json">data/black.json</a>.</p>`;
} }
@@ -189,6 +192,13 @@
const art = (c) => window.DragonArt ? `<svg class="odd-art" viewBox="0 0 200 160" aria-hidden="true">${window.DragonArt.svg(POSE[c], { fill: `var(${DV[c]})`, eyeFill: "var(--bg)", dark: c === "Black" })}</svg>` : ""; const art = (c) => window.DragonArt ? `<svg class="odd-art" viewBox="0 0 200 160" aria-hidden="true">${window.DragonArt.svg(POSE[c], { fill: `var(${DV[c]})`, eyeFill: "var(--bg)", dark: c === "Black" })}</svg>` : "";
$("#odds-colours").innerHTML = cols.map(({ c, first, p, pAll, lo, hi }) => { $("#odds-colours").innerHTML = cols.map(({ c, first, p, pAll, lo, hi }) => {
const e = enc(c); const e = enc(c);
// The Black rests on one roll no complete log has measured (the shadow on a first attempt): a range, not a figure
if (first) return `<a class="odd odd-colour odd-low" href="#valley/${c.toLowerCase()}" style="--c: var(${DV[c]})">${art(c)}
<span class="pill warn">Low evidence</span>
<span class="big">about 1 in ${oneIn(p)}</span><span class="what">first attempts end bonded to a Black, on the best route</span>
${dots(Math.round(p * 1000), 1000, cssVar(DV[c]))}
<span class="how">Somewhere between <b>1 in ${oneIn(hi)}</b> and <b>1 in ${oneIn(lo)}</b> (95%). Later attempts: no shadow has ever been logged, so effectively never.${Math.abs(pAll - p) / p > 0.25 ? ` All form posts suggest about 1 in ${oneIn(pAll)}.` : ""} Every logged shadow comes from riders who chose to post their run, so this rests on an assumption until complete first-attempt logs exist. <span id="black-steps"></span></span>
<span class="go">See the route →</span></a>`;
return `<a class="odd odd-colour" href="#valley/${c.toLowerCase()}" style="--c: var(${DV[c]})">${art(c)} return `<a class="odd odd-colour" href="#valley/${c.toLowerCase()}" style="--c: var(${DV[c]})">${art(c)}
<span class="big">${p >= 0.5 ? pct(p) : `1 in ${oneIn(p)}`}</span><span class="what">${p >= 0.5 ? "of runs" : "runs"} end bonded to ${/^[AEIOU]/.test(c) ? "an" : "a"} ${c}, on the best route${first ? ", on your first attempt" : ""}</span> <span class="big">${p >= 0.5 ? pct(p) : `1 in ${oneIn(p)}`}</span><span class="what">${p >= 0.5 ? "of runs" : "runs"} end bonded to ${/^[AEIOU]/.test(c) ? "an" : "a"} ${c}, on the best route${first ? ", on your first attempt" : ""}</span>
${dots(Math.round(p * 1000), 1000, cssVar(DV[c]))} ${dots(Math.round(p * 1000), 1000, cssVar(DV[c]))}
+1 -1
View File
@@ -27,7 +27,7 @@ for (const f of fs.readdirSync(path.join(root, "site/atlas"))) copy(`site/atlas/
copy("core/graph.js", "graph.js"); copy("core/graph.js", "graph.js");
copy("core/solver.js", "solver.js"); copy("core/solver.js", "solver.js");
// The numbers the page shows (all computed in Python) and the published data // The numbers the page shows (all computed in Python) and the published data
for (const f of ["stats.json", "register.json", "graph.json", "policy.json", "black.json", "tree.json", "experiments.json", "pdf_encounters.json"]) copy(`data/public/${f}`, `data/${f}`); for (const f of ["stats.json", "register.json", "graph.json", "policy.json", "black.json", "tree.json", "experiments.json", "pdf_encounters.json", "overlap.json"]) copy(`data/public/${f}`, `data/${f}`);
copy("data/public/runs_clean.csv", "data/runs_clean.csv"); copy("data/public/runs_clean.csv", "data/runs_clean.csv");
for (const f of ["croissant.json", "dictionary.yaml"]) copy(`data/${f}`, `data/${f}`); for (const f of ["croissant.json", "dictionary.yaml"]) copy(`data/${f}`, `data/${f}`);
// Source files shown in the page's "view the code" panel // Source files shown in the page's "view the code" panel
+27 -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,31 @@ 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_review_summary_and_overlap(self):
sys.path.insert(0, str(ROOT / "core"))
from collection.etl import review_reddit
ov = review_reddit._overlap()
base = {"runs": [{"id": "a1", "thread": "t", "answers": {"outcome": "Bonded"}}]}
head = {"runs": [{"id": "a1", "thread": "t", "answers": {"outcome": "Incinerated at a bonding encounter"}},
{"id": "b2", "thread": "t", "answers": {}}, {"id": "c3", "thread": "t", "answers": {}, "result": "THRESH-X1"}]}
self.assertEqual(review_reddit.diff(base, head), (["b2", "c3"], ["a1"], []))
route = dict(company="Alone", direction="East", scream="Ignore the scream", hour="Tree", outcome="Bonded",
outcome_color="Red", date="2026-10-05")
runs = [{"run_id": "comment-b2", "source": "reddit comment", "data_flags": "read from a Reddit comment; "
"Black recorded on a Valley run (the Black is only reached from the tree)", **{k: None for k in ov.FIELDS}, "date": None},
{"run_id": "comment-c3", "source": "reddit comment", "data_flags": "", **{k: None for k in ov.FIELDS}, **route},
{"run_id": "sheet-1", "source": "reddit spreadsheet", "data_flags": "", **{k: None for k in ov.FIELDS}, **route}]
m = ov.measure(runs)
self.assertEqual((m["comparable"], m["matched"]), (1, 1))
self.assertEqual(m["matches"], [{"comment": "comment-c3", "form": ["sheet-1"]}])
text = review_reddit.summary(base, head, runs, {"THRESH-X1"}, m)
self.assertIn("**2 new**, 1 changed", text)
self.assertIn("Black recorded on a Valley run", text)
self.assertIn("sheet-1", text)
self.assertIn("THRESH-X1", text)
self.assertTrue(text.startswith(review_reddit.MARKER))
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"]