From e29485b922269f7cad2bfddfb1596c27edc9bbfb Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期三, 16 九月 2026 15:55:47 +0800
Subject: [PATCH] docs(问题汇总): 补充第十二节 —— 货运页签累计列派生口径、母版改动方式、PowerShell/git 文本坑与遗留问题增量

---
 docs/问题汇总/问题与注意事项汇总_2026-09-16.md |   62 +++++++++++++++++++++++++++++++
 1 files changed, 62 insertions(+), 0 deletions(-)

diff --git "a/docs/\351\227\256\351\242\230\346\261\207\346\200\273/\351\227\256\351\242\230\344\270\216\346\263\250\346\204\217\344\272\213\351\241\271\346\261\207\346\200\273_2026-09-16.md" "b/docs/\351\227\256\351\242\230\346\261\207\346\200\273/\351\227\256\351\242\230\344\270\216\346\263\250\346\204\217\344\272\213\351\241\271\346\261\207\346\200\273_2026-09-16.md"
index 0a57680..7a0bd86 100644
--- "a/docs/\351\227\256\351\242\230\346\261\207\346\200\273/\351\227\256\351\242\230\344\270\216\346\263\250\346\204\217\344\272\213\351\241\271\346\261\207\346\200\273_2026-09-16.md"
+++ "b/docs/\351\227\256\351\242\230\346\261\207\346\200\273/\351\227\256\351\242\230\344\270\216\346\263\250\346\204\217\344\272\213\351\241\271\346\261\207\346\200\273_2026-09-16.md"
@@ -181,3 +181,65 @@
 | 6 | 浠撳簱鏍圭洰褰曞ぇ閲� `_*.*` 涓存椂鏂囦欢 | 浣撶Н/鍙鎬� | 缁忕敤鎴峰悓鎰忓悗鍐嶆竻鐞� |
 
 > 2026-09-16 鍌嶆櫄鏇存柊锛氶仐鐣欓棶棰� 4锛堥瑙堝脊绐椼�屽叡 0 琛屻�嶆枃妗堬級宸叉寜鐢ㄦ埛纭淇敼瀹屾瘯鈥斺�旀眹鎬诲ぇ琛ㄦ敼涓烘樉绀恒�屾寚鏍� N 椤广�嶏紝鍏跺畠鎶ヨ〃鏄剧ず銆屽叡 N 琛屾槑缁嗐�嶃��
+
+---
+
+## 鍗佷簩銆�2026-09-16 琛ュ厖锛氳揣杩愰〉绛俱�岀疮璁°�嶅垪淇锛堥噸瑕佸彛寰勶級
+
+### 12.1 姣嶇増娲剧敓鍙ｅ緞锛堝繀椤婚伒瀹堬級
+
+銆� 璐ц繍銆嬮〉琛岀粨鏋勶細
+- 鍏ㄧ渷鍧楋細r5 璐ц繍閲� / r6 鍛ㄨ浆閲� / r7 鍏朵腑瑙勪笂璐ц繍閲� / r8 鍏朵腑瑙勪笂鍛ㄨ浆閲� / r9 鍏朵腑瑙勪笅璐ц繍閲� / r10 鍏朵腑瑙勪笅鍛ㄨ浆閲忥紱
+- 17 涓競宸炲潡姣忓潡 6 琛岋紝棣栬 11,17,23,...,107锛堟姹夊競...鏋楀尯锛夛紝鍧楀唴椤哄簭锛氬悎璁¤揣杩愰噺 / 瑙勪笂璐ц繍閲� / 瑙勪笅璐ц繍閲� / 鍚堣鍛ㄨ浆閲� / 瑙勪笂鍛ㄨ浆閲� / 瑙勪笅鍛ㄨ浆閲忋��
+
+**瑙勫垯锛氬叏鐪佽蹇呴』瀹屽叏鐢� 17 甯傚窞琛屾淳鐢熴��**
+- r7 / r8 / r9 / r10 = SUM(17 甯傚窞瀵瑰簲琛�)锛�
+- r5 = m7+m9锛宺6 = m8+m10銆�
+
+鍘嗗彶鏁欒锛歳9/r10锛堝叏鐪佽涓嬶級鏇炬槸**鍐欐甯搁噺**锛屼笌 17 甯傚窞瑙勪笅涔嬪拰涓嶇瓑 鈥斺�� 2023 宸� 4.6e-3銆�2022 宸� 3.1e-3銆�2021 宸� 1.5e-4锛�2024/2025/2026 鎭板ソ涓� 0锛夛紝瀵艰嚧 6 涓疮璁″垪閲� 2022/2023 姣旀簮鏂囦欢浜哄伐鏍哥畻宸� 0.003 宸﹀彸銆�2021 鏁村垪涓虹┖銆�2026-09-16 宸插叏閮ㄦ敼涓哄叕寮忋��
+
+绱鍒楃幇鐘讹紙鍏ㄧ渷琛岋紝4 浣嶅皬鏁颁笌婧愭枃浠朵竴鑷达級锛�
+
+| 鍒� | 骞村害 | 鍏紡 |
+|---|---|---|
+| S | 2026(1-8鏈�) | C+E+G+I+K+M+O+Q |
+| AT | 2025 | V+X+...+AR |
+| BV | 2024 | AX+AZ+...+BT |
+| CW | 2023 | BY+CA+...+CU |
+| DZ | 2022 | =SUM(DM:DX)锛堝師涓哄啓姝诲父閲忥級 |
+| EO | 2021 | =SUM(EC:EN)锛堝師涓�**绌�**锛� |
+| EP | 2021 绱鍚屾瘮 | 淇濇寔涓虹┖锛堥〉鍐呮棤 2020 鍧楋紝鏃犲熀鏈燂級 |
+| EA | 2022 绱鍚屾瘮 | =IFERROR(DZ/SUM(EC:EN)-1, 绌轰覆)锛堝師涓哄啓姝诲父閲忥級 |
+
+### 12.2 姣嶇増鏀瑰姩鏂瑰紡涓庢枃浠惰亴璐�
+
+- **蹇呴』鐢� Excel COM**锛堟敼鍏紡 -> CalculateFullRebuild -> Save锛夛紝**涓嶅彲鐢� openpyxl 鍙﹀瓨**锛氫細娓呯┖鍏ㄦ湰鍏紡缂撳瓨鍊硷紙鏇惧鑷� 2021 骞存箹鍖楃渷琛屽彉 0锛夈��
+- 瀵煎嚭浠堕噷鐨勫叕寮�**鏃犵紦瀛樺��**锛歰penpyxl(data_only=True) 璇诲嚭鏉ュ叏鏄� None锛屾牳瀵规暟鍊煎繀椤荤敤 Excel COM 閲嶇畻鎴栬嚜鍐欐眰鍊煎櫒銆�
+- 鏂囦欢鑱岃矗锛�
+  - YYYY骞碝鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx = **姣嶇増**锛堝敮涓�鏁版嵁鏉ユ簮锛夛紱
+  - 鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃.xlsx = **鍙綔鍒楀鍙傜収**锛坅pplySummaryReferenceLayout 鍙鍒楀/闅愯棌鏍囪锛屼笉璇绘暟鍊硷級锛�
+  - 2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃_鐗堝紡鍘熷瀷.xlsx = 杩愯鏃�**鏃犱换浣曚唬鐮佸紩鐢�**銆�
+- 鍚屾湡澶囦唤姣嶇増杩樺師鏈哄埗锛歳esolveSummaryDonor 鍙鏂囦欢鍚�**浠� `_澶囦唤_` 寮�澶翠笖鍚�寋骞磢鏈堛��**鐨勬枃浠讹紝鍛戒腑鍗虫暣鏍煎洖濉鐩栨瘝鐗堛��=> 鑷缓鐨勫浠芥枃浠�/鐩綍**涓嶈**鐢� `_澶囦唤_` 鍓嶇紑锛屽惁鍒欏彲鑳借褰撴垚 donor 鎶婃瘝鐗堟敼鍥炴棫鍊笺��
+
+### 12.3 鏂囨湰澶勭悊鐨勫潙锛堟湰鏈� PowerShell / git锛�
+
+| 闂 | 鍘熷洜 | 澶勭疆 |
+|---|---|---|
+| 鍏紡琚啓鎴� =SUM(DM5) | "$m7" 琚В鏋愪负鍙橀噺 m7锛�"$r:DX" 閲岀殑 $r:DX 琚綋鎴愩�岄┍鍔ㄥ櫒 r:銆嶈�屽悶鎺� | 涓�寰嬬敤 ${m} / ${r} 瀹氱晫 |
+| 鍛戒护鏁翠綋涓嶆墽琛屻�佹棤杈撳嚭銆侀��鍑虹爜 1 | 涓�涓懡浠ら噷鍑虹幇**宓屽鐨勫崟寮曞彿 here-string**锛屽灞傚湪绗竴涓粨鏉熺澶勬彁鍓嶇粨鏉� | 涓�涓懡浠ゅ彧鏀句竴涓� here-string锛涙垨鍏� Out-File 鍐欒ˉ涓佹枃浠讹紝鍐嶇敤 Get-Content -Raw |
+| apply_patch 浼犲琛屽弬鏁板け璐� | .bat 鍖呰鍣ㄧ牬鍧忎簡澶氳鍙傛暟 | 鐩存帴璋� codex.exe --codex-run-as-apply-patch $patch |
+| git commit -m 鎶� "outside repository" | PowerShell 鐢ㄥ弽寮曞彿杞箟锛屾秷鎭噷鐨勫弽鏂滄潬+寮曞彿浼氭彁鍓嶇粨鏉熷瓧绗︿覆 | 鐢� git commit -F <娑堟伅鏂囦欢> |
+| PS5.1 鎶ヤ贡鐮佽矾寰勩�屾棤娉曟壘鍒� ...銆� | PS7 鐨� Out-File -Encoding utf8 鍐欑殑鏄�**鏃� BOM** UTF-8锛孭S5.1 鎸� GBK 璇昏剼鏈� | 鍐� .ps1 鏃剁敤 -Encoding utf8BOM |
+
+### 12.4 閬楃暀闂澧為噺锛堟埅鑷� 2026-09-16 鏅氾級
+
+| # | 闂 | 褰卞搷 | 鐘舵�� |
+|---|---|---|---|
+| 7 | h2032_enterprise_monthly 2026-09 鑴忔湡锛堝疄涓� 8 鏈堟枃浠惰瀛樹负 9 鏈堬級 | 636 琛� + import_batch 302 | **宸插垹闄�**锛岀暀鍙繕鍘� SQL 澶囦唤 |
+| 8 | 銆� 璐ц繍銆嬮〉绱鍒� 2021/2022/2023 瀵逛笉涓婁汉宸ユ牳绠� | 宸蹭慨姣嶇増娲剧敓鍙ｅ緞锛�6 鍒楀叏閮ㄥ涓� | **宸茶В鍐�** |
+| 9 | 2026-09 鏈熻繕鍦� h204_vehicle_quarterly(1284 琛�) / investment_monthly(31 琛�) / audit_result(2061 琛�) / audit_run(3 琛�) | 鑻ユ寜 2026-09 鍑烘姤琛ㄤ細鍙栧埌鑴忔暟鎹� | 寰呯敤鎴风‘璁ゆ槸鍚︽竻鐞� |
+| 10 | 2026-07 瀵煎嚭浠躲�� 璐ц繍銆嬮〉涓� 118x145锛堟瘮 8 鏈堝皯 2 鍒楋級 | 7 鏈堟瘝鐗堟槸銆�1-4 鏈堥鏋躲�嶏紝闈炲畬鏁存瘝鐗� | 寰� 7 鏈堟瘝鐗堝畾绋� |
+| 11 | 2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃_鐗堝紡鍘熷瀷.xlsx 鐨� S 鍒楁紡 8 鏈堬紙缂� Q5锛� | 杩愯鏃舵湭琚紩鐢紝鏆傛棤褰卞搷 | 寰呯‘璁よ鏂囦欢鍘荤暀 |
+| 12 | 姣嶇増缁� Excel 閲嶅瓨鍚庝綋绉� 959,706 -> 1,492,121 瀛楄妭锛堝鍑轰欢 950,186 -> 1,331,599锛� | 绾牸寮忓紑閿�锛屾暟鎹棤褰卞搷 | 璁板綍 |
+
+璇﹁銆婂姛鑳芥祴璇曟姤鍛�/鍔熻兘娴嬭瘯鎶ュ憡_璐ц繍椤电绱鍒椾慨澶嶄笌鑴忔湡娓呯悊_2026-09-16.md銆嬨��

--
Gitblit v1.9.1