关于「零培训防呆表单:约束、默认值、即时校验、确认撤销与批量保护」,《数据后台减负与防呆表单》给出的定量结论是什么?

结论:防错表单的顺序是固定的:能推导的不让填,能选择的不让敲,能学来的才预填,格式交给掩码,号码自带校验,金额看数量级,提示在离开字段时给,撤回比确认优先,批量先看半径。p61 说明默认值省手不一定省错;p62 说明每敲一键都查完整格式,一天会制造 46,800 次假错;p60 说明多一位 Damm 校验码就能查出全部相邻对调;p63 说明分层之后对话框从一天 4,411 个降到 29 个;p64 说明 50 行的键入门槛用 0.1037 的批次摩擦覆盖 0.5866 的风险行数。第七章把这些做法装进对账、订单、库存与客户资料四种后台,并在末节把它们写成样式库可以执行的检查。

数据口径:本书不是会计、审计或法律意见。 书中以标注框区分已发表的证据、可运行的计算、原典与作者的假说,每条假说都写明什么结果会推翻它;原典考辨取唐代刘晏的报数制度,原文只转述大意。

English version

对照数据表

下表数字由本章 Python 程序原样打印,可重新运行复现。 程序只用 Python 标准库与结论吻合的打印值: 0.1037, 0.5866, 50

batches 1,080; rows touched 25,133; median 8; mean 23.3; largest 906
Tbatches typing countshare of batchesshare of rows at risk covered
104660.43150.9073
252470.22870.7713
501120.10370.5866
100420.03890.3889
200180.01670.2628
largest 1% of batches (10) carry 0.1878 of rows at risk
cap 300 rows per batch: 9 batches split into 12 extra runs; worst single wrong batch 906 -> 300
查看完整验算程序
# Chapter 6. p64: Blast radius of batch actions: where a typed-count confirmation pays for its friction.
# A fictional 30-day log of batch actions at Harbourbridge (seed 6464): 36 batches a day, sizes drawn
# from a log-normal (median 8 rows, sigma 1.5, capped at 1,200 = one day of rows). Assumption, not data.
# If a batch is run on a wrong filter, every row in it is wrong, so rows at risk scale with batch size.
# For each threshold T: share of batches that must type their row count (the friction), and share of
# rows at risk that such batches carry (the protection). Then the effect of a per-batch cap of 300.
import math
import random

DAYS, PER_DAY, CAP_LOG = 30, 36, 1200

if __name__ == "__main__":
    rng = random.Random(6464)
    sizes = []
    for _ in range(DAYS * PER_DAY):
        s = int(round(math.exp(math.log(8) + 1.5 * rng.gauss(0.0, 1.0))))
        sizes.append(min(CAP_LOG, max(1, s)))
    sizes.sort()
    n, rows = len(sizes), sum(sizes)
    print("batches {:,}; rows touched {:,}; median {}; mean {:.1f}; largest {:,}"
          .format(n, rows, sizes[n // 2], rows / n, sizes[-1]))
    print("   T   batches typing count  share of batches  share of rows at risk covered")
    for t in (10, 25, 50, 100, 200):
        big = [s for s in sizes if s >= t]
        print("  {:3d}  {:20d}  {:16.4f}  {:29.4f}".format(t, len(big), len(big) / n, sum(big) / rows))
    top = sizes[-max(1, n // 100):]
    print("largest 1% of batches ({}) carry {:.4f} of rows at risk".format(len(top), sum(top) / rows))
    cap = 300
    split = [s for s in sizes if s > cap]
    extra = sum(math.ceil(s / cap) - 1 for s in split)
    worst_before, worst_after = sizes[-1], min(sizes[-1], cap)
    print("cap {} rows per batch: {} batches split into {} extra runs; worst single wrong batch {:,} -> {}"
          .format(cap, len(split), extra, worst_before, worst_after))

唯一数据源与引用

范雅福(Fan, Y.). (2026). 《高密度数据工作台视觉减负、条件格式显著性与零培训防呆表单工程》第 6 章「零培训防呆表单:约束、默认值、即时校验、确认撤销与批量保护」(版本 0.1.0). 5D Library. DOI 待发布

DOI 待发布 · 专著页正式发布后上线(本站暂无专著页) · 5DL-B-138 · v0.1.0 · CC-BY-NC-ND-4.0

BibTeX
@book{fan2026138,
  author    = {Fan, Yafu},
  title     = {Cognitive Unloading of Dense Data Workbenches, Conditional-Format Salience and Zero-Training Error-Proof Form Engineering},
  year      = {2026},
  publisher = {5D Library},
  edition   = {0.1.0},
  note      = {DOI pending}
}

本书其他章节结论