关于「零培训防呆表单:约束、默认值、即时校验、确认撤销与批量保护」,《数据后台减负与防呆表单》给出的定量结论是什么?
结论:防错表单的顺序是固定的:能推导的不让填,能选择的不让敲,能学来的才预填,格式交给掩码,号码自带校验,金额看数量级,提示在离开字段时给,撤回比确认优先,批量先看半径。p61 说明默认值省手不一定省错;p62 说明每敲一键都查完整格式,一天会制造 46,800 次假错;p60 说明多一位 Damm 校验码就能查出全部相邻对调;p63 说明分层之后对话框从一天 4,411 个降到 29 个;p64 说明 50 行的键入门槛用 0.1037 的批次摩擦覆盖 0.5866 的风险行数。第七章把这些做法装进对账、订单、库存与客户资料四种后台,并在末节把它们写成样式库可以执行的检查。
数据口径:本书不是会计、审计或法律意见。 书中以标注框区分已发表的证据、可运行的计算、原典与作者的假说,每条假说都写明什么结果会推翻它;原典考辨取唐代刘晏的报数制度,原文只转述大意。
对照数据表
下表数字由本章 Python 程序原样打印,可重新运行复现。 程序只用 Python 标准库与结论吻合的打印值: 0.1037, 0.5866, 50
| batches 1,080; rows touched 25,133; median 8; mean 23.3; largest 906 | |||
| T | batches typing count | share of batches | share of rows at risk covered |
| 10 | 466 | 0.4315 | 0.9073 |
| 25 | 247 | 0.2287 | 0.7713 |
| 50 | 112 | 0.1037 | 0.5866 |
| 100 | 42 | 0.0389 | 0.3889 |
| 200 | 18 | 0.0167 | 0.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}
}