Compare commits
14
Commits
| Author | SHA1 | Date | |
|---|---|---|---|
|
|
ca411e8315 | ||
|
|
b51a6c7039 | ||
|
|
d7befc8e18 | ||
|
|
98be27fc1f | ||
|
|
cd618d37d3 | ||
|
|
0ae29b5423 | ||
|
|
0df6b8d473 | ||
|
|
46c1f00150 | ||
|
|
ae370329e3 | ||
|
|
5f080e0a82 | ||
|
|
d0141f2d9c | ||
|
|
036c86a1d1 | ||
|
|
99563a59ea | ||
|
|
d606ed1651 |
@@ -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:
|
||||||
|
|||||||
@@ -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}"
|
||||||
@@ -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 }}"
|
||||||
@@ -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
@@ -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/
|
||||||
|
|||||||
@@ -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:
|
||||||
|
|||||||
@@ -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())
|
||||||
@@ -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
|
||||||
|
|
||||||
|
|||||||
@@ -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 } }
|
||||||
|
|||||||
@@ -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")
|
||||||
|
|
||||||
|
|||||||
@@ -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
|
||||||
|
|||||||
@@ -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)
|
||||||
|
|||||||
@@ -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"])
|
||||||
|
|||||||
@@ -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": [
|
||||||
|
|||||||
@@ -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
|
||||||
@@ -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:
|
||||||
|
|||||||
@@ -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:
|
||||||
|
|||||||
@@ -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()
|
||||||
|
|||||||
@@ -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:
|
||||||
|
|||||||
@@ -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
@@ -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",
|
||||||
|
|||||||
@@ -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
|
||||||
|
|||||||
@@ -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,
|
||||||
|
|||||||
@@ -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
@@ -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
@@ -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
@@ -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",
|
||||||
|
|||||||
@@ -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
@@ -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
@@ -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];
|
||||||
|
|||||||
@@ -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>
|
||||||
|
|||||||
@@ -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; }
|
||||||
|
|||||||
@@ -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
@@ -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
|
||||||
|
|||||||
@@ -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"]
|
||||||
|
|||||||
Reference in New Issue
Block a user