From 8fd1e1134785eb20ff9640bf7b6f62a6d14df26e Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期三, 16 九月 2026 15:54:42 +0800
Subject: [PATCH] fix(summary): 货运页签累计列改为市州汇总派生，修 2021/2022/2023 累计对不上
---
docs/功能测试报告/功能测试报告_货运页签累计列修复与脏期清理_2026-09-16.md | 176 +++++++++++++++++++++++++++++++++++
docs/工作日结/工作日结_2026-09-16.md | 68 +++++++++++++
docs/生成汇总大表/2026年8月道路运输量汇总表.xlsx | 0
3 files changed, 244 insertions(+), 0 deletions(-)
diff --git "a/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_\350\264\247\350\277\220\351\241\265\347\255\276\347\264\257\350\256\241\345\210\227\344\277\256\345\244\215\344\270\216\350\204\217\346\234\237\346\270\205\347\220\206_2026-09-16.md" "b/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_\350\264\247\350\277\220\351\241\265\347\255\276\347\264\257\350\256\241\345\210\227\344\277\256\345\244\215\344\270\216\350\204\217\346\234\237\346\270\205\347\220\206_2026-09-16.md"
new file mode 100644
index 0000000..4a0f7f6
--- /dev/null
+++ "b/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_\350\264\247\350\277\220\351\241\265\347\255\276\347\264\257\350\256\241\345\210\227\344\277\256\345\244\215\344\270\216\350\204\217\346\234\237\346\270\205\347\220\206_2026-09-16.md"
@@ -0,0 +1,176 @@
+# 鍔熻兘娴嬭瘯鎶ュ憡 鈥� 璐ц繍椤电銆岀疮璁°�嶅垪淇 + H2032 鑴忔湡娓呯悊
+
+- **鍔熻兘鍚�**锛氭眹鎬诲ぇ琛ㄣ�� 璐ц繍銆嬮〉绛剧疮璁″垪淇锛沗h2032_enterprise_monthly` 2026-09 鑴忔湡娓呯悊
+- **鏃ユ湡**锛�2026-09-16
+- **缁撹**锛�**閫氳繃**锛�6/6 绱鍒椾笌婧愭枃浠朵汉宸ユ牳绠椾竴鑷达紱鑴忔湡宸叉竻闄や笖鐣欐湁鍙繕鍘熷浠斤級
+
+## 涓�銆佸姛鑳借鏄庝笌鑳屾櫙
+
+鐢ㄦ埛鍙嶉锛氭眹鎬诲ぇ琛ㄣ�� 璐ц繍銆嬮〉绛剧殑銆岀疮璁°�嶆暟鎹紝浜哄伐鏍稿鍚�**鍙湁鍓嶉潰鍥涗釜鑳藉涓�**銆�
+
+` 璐ц繍` 椤电鍏� 6 涓疮璁″垪锛堝叏鐪佽锛夛細
+
+| 鍒� | 骞村害 | 淇鍓� | 婧愭枃浠舵牳绠� | 宸紓 |
+|---|---|---|---|---|
+| S | 2026(1-8鏈�) | 130311.8927 | 130311.8927 | 0 |
+| AT | 2025 | 195433.2232 | 195433.2232 | 0 |
+| BV | 2024 | 184938.5780 | 184938.5780 | 0 |
+| CW | 2023 | 173045.2932 | 173045.2964 | -0.0033 |
+| DZ | 2022 | 144979.2854 | 144979.2825 | +0.0029 |
+| EO | 2021 | 绌� | 161309.5316 | 鏁村垪缂哄け |
+
+鍛ㄨ浆閲忚鍚岀悊锛�2023 -0.0017銆�2022 +0.0025銆�2021 绌猴級銆�
+
+## 浜屻�佹牴鍥犲畾浣�
+
+### 2.1 缁撴瀯涓庢枃浠惰亴璐�
+
+姣嶇増锛歚docs/鐢熸垚姹囨�诲ぇ琛�/2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx` 鈫� ` 璐ц繍` 椤碉紙118x147锛夈��
+
+- `鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃.xlsx` 浠呬綔**鍒楀鐗堝紡鍙傜収**锛坄applySummaryReferenceLayout` 鍙鍒楀涓庨殣钘忔爣璁帮紝涓嶈鏁板�硷級锛�
+- `2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃_鐗堝紡鍘熷瀷.xlsx` 杩愯鏃�**鏈浠讳綍浠ｇ爜寮曠敤**銆�
+
+鍏ㄧ渷鍧� 6 琛岋細r5 璐ц繍閲忋�乺6 鍛ㄨ浆閲忋�乺7 鍏朵腑瑙勪笂璐ц繍閲忋�乺8 鍏朵腑瑙勪笂鍛ㄨ浆閲忋�乺9 鍏朵腑瑙勪笅璐ц繍閲忋�乺10 鍏朵腑瑙勪笅鍛ㄨ浆閲忋��
+17 涓競宸炲潡姣忓潡 6 琛岋紝鍧楅琛� 11,17,...,107锛堟姹夊競...鏋楀尯锛夈��
+
+鍏抽敭锛氬叏鐪� r5 = `=<m>7+<m>9`锛堣涓�+瑙勪笅锛夛紝r7 = 17 甯傚窞瑙勪笂涔嬪拰锛堝叕寮忥級锛岃�� **r9锛堝叏鐪佽涓嬶級鏄啓姝荤殑甯搁噺**銆�
+
+### 2.2 鍐冲畾鎬ф祴閲忥紙Excel COM 閲嶇畻鍚庨�愭湀姣旇緝銆屽叏鐪佽銆嶄笌銆�17 甯傚窞琛屼箣鍜屻�嶏級
+
+| 骞村害 | 鍚堣宸� | 瑙勪笂宸� | 瑙勪笅宸� |
+|---|---|---|---|
+| 2026(1-8) | 2.8e-5 | 1.8e-12 | 2.8e-5 |
+| 2025 | 3.3e-11 | 9.1e-13 | 3.5e-11 |
+| 2024 | 1.5e-11 | 9.1e-13 | 1.3e-11 |
+| 2023 | **4.6e-3** | 4.5e-13 | **4.6e-3** |
+| 2022 | **3.1e-3** | 2.3e-13 | **3.1e-3** |
+| 2021 | 4.0e-5 | 4.0e-5 | 1.5e-4 |
+
+**缁撹锛氳涓婃案杩滃寰椾笂锛涘樊寮傚叏閮ㄦ潵鑷�屽叏鐪佽涓嬨�嶈繖涓�琛岀殑鍐欐甯搁噺涓� 17 甯傚窞瑙勪笅涔嬪拰涓嶇瓑銆�**
+
+鍚屾椂瀹炴祴銆�17 甯傚窞琛屼箣鍜屻�嶇瓑浜庢簮鏂囦欢婀栧寳鐪佽锛�2022 绱 144979.2825銆�2023 绱 173045.2964锛屼笌浜哄伐鏍哥畻**瀹屽叏涓�鑷�**銆�
+
+### 2.3 鍏朵綑鍘熷洜
+
+- **DZ锛�2022 绱锛夊啓姝诲父閲�**锛屼笉闅忔暟鎹埛鏂帮紙鍏跺�兼伆濂界瓑浜庤嚜韬� 12 涓湀涔嬪拰锛屾晠鏀规垚鍏紡灞炵瓑鍊兼敼鍔級锛�
+- **EO锛�2021 绱锛夋暣鍒椾负绌�**锛屾瘝鐗堜粠鏈～杩囩疮璁″叕寮忥紙2021 骞� `EC:EN` 鍗佷簩涓湀閮芥湁鍊硷級锛�
+- **EA锛�2022 绱鍚屾瘮锛変篃鏄啓姝诲父閲�**锛�
+- 瀵煎嚭浠ｇ爜鍙洖濉�岀洰鏍囧綋鏈堛�嶄竴鍒楋紙`SummaryWorkbookFiller.fillFreightSheet`锛夛紝鍘嗗彶鏈堜唤涓�寰嬫部鐢ㄦ瘝鐗� 鈫� 姣嶇増瀵逛笉涓婂氨鏁翠綋瀵逛笉涓娿��
+
+## 涓夈�佷慨鏀瑰唴瀹�
+
+### 3.1 姣嶇増銆�2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx銆嬧啋 ` 璐ц繍` 椤�
+
+| # | 浣嶇疆 | 鏀瑰墠 | 鏀瑰悗 |
+|---|---|---|---|
+| 1 | r7 鍏朵腑瑙勪笂璐ц繍閲忥紙2021-2025 鍚勬湀锛� | 甯搁噺/閮ㄥ垎鍏紡 | `=SUM(<17 甯傚窞瑙勪笂璐ц繍閲忚>)` |
+| 2 | r9 鍏朵腑瑙勪笅璐ц繍閲忥紙2021-2025 鍚勬湀锛� | **鍐欐甯搁噺** | `=SUM(<17 甯傚窞瑙勪笅璐ц繍閲忚>)` |
+| 3 | r8 鍏朵腑瑙勪笂鍛ㄨ浆閲忥紙2021-2025 鍚勬湀锛� | 甯搁噺/閮ㄥ垎鍏紡 | `=SUM(<17 甯傚窞瑙勪笂鍛ㄨ浆閲忚>)` |
+| 4 | r10 鍏朵腑瑙勪笅鍛ㄨ浆閲忥紙2021-2025 鍚勬湀锛� | **鍐欐甯搁噺** | `=SUM(<17 甯傚窞瑙勪笅鍛ㄨ浆閲忚>)` |
+| 5 | r5 璐ц繍閲忥紙2021-2025 鍚勬湀锛� | 甯搁噺/鍏紡 | `=<m>7+<m>9` |
+| 6 | r6 鍛ㄨ浆閲忥紙2021-2025 鍚勬湀锛� | 甯搁噺/鍏紡 | `=<m>8+<m>10` |
+| 7 | DZ 鍒楋紙2022 绱锛岃 5-112锛� | 鍐欐甯搁噺 | `=SUM(DM<r>:DX<r>)` |
+| 8 | EO 鍒楋紙2021 绱锛岃 5-112锛� | **绌�** | `=SUM(EC<r>:EN<r>)` |
+| 9 | EA 鍒楋紙2022 绱鍚屾瘮锛岃 5-112锛� | 鍐欐甯搁噺 | `=IFERROR(DZ<r>/SUM(EC<r>:EN<r>)-1,"")` |
+
+鍏辨敼鍐欐湀鍧楀崟鍏� 360 涓�佺疮璁″崟鍏� 324 涓��
+
+- 2026 骞村潡锛圕..Q锛�**涓嶅姩**锛氬綋鏈堝�肩敱瀵煎嚭浠ｇ爜鍥炲～锛屼笖鍏剁疮璁″凡涓庢簮鏂囦欢涓�鑷达紱
+- EP锛�2021 绱鍚屾瘮锛�**淇濇寔涓虹┖**锛氶〉鍐呮病鏈� 2020 骞村害鍧楋紝鏃犲悓姣斿熀鏈熷彲寮曠敤锛�
+- 鍙敼姣嶇増杩欎竴涓枃浠躲�俙鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃.xlsx` 鏄垪瀹藉弬鐓т欢锛堟敼瀹冨弽鑰屾湁鍒楀琚� Excel 閲嶅啓甯﹀亸鐨勯闄╋級锛宍_鐗堝紡鍘熷瀷.xlsx` 杩愯鏃舵湭琚紩鐢紝涓よ�呭潎涓嶅姩锛�
+- 鍚屾湡澶囦唤姣嶇増杩樺師鏈哄埗**涓嶄細**鍐叉帀鏈鏀瑰姩锛歚resolveSummaryDonor(2026,8)` 瑕佹眰鏂囦欢鍚嶄互 `_澶囦唤_` 寮�澶翠笖鍚��2026骞�8鏈堛�嶏紝鐩綍涓嬫棤鍖归厤鏂囦欢锛涘鍑烘棩蹇椾害纭銆屾湭鎵惧埌鍚屾湡澶囦唤姣嶇増銆嶃��
+
+鏀瑰姩鍓嶅浠斤細`docs/鐢熸垚姹囨�诲ぇ琛�/_bak_202608姣嶇増淇敼鍓峗20260916/`锛�3 涓師鏂囦欢锛夈��
+
+> 瀹炵幇鏂瑰紡鐢� **Excel COM** 鎵撳紑姣嶇増鏀瑰叕寮忓苟 `CalculateFullRebuild` 鍚庝繚瀛樸��**涓嶅彲鐢� openpyxl 鍙﹀瓨**锛氫細娓呯┖鍏ㄦ湰鍏紡缂撳瓨鍊硷紙2026-09-16 鏇惧洜姝よ 2021 骞存箹鍖楃渷琛屽彉鎴� 0锛岃宸ヤ綔鏃ョ粨绗崄鍏妭锛夈��
+
+### 3.2 鏁版嵁搴�
+
+| 鎿嶄綔 | 瀵硅薄 | 褰卞搷琛屾暟 |
+|---|---|---|
+| DELETE | `h2032_enterprise_monthly` WHERE `report_period='2026-09'` | 636 |
+| DELETE | `import_batch` WHERE `id=302` | 1 |
+
+渚濇嵁锛歜atch 302 鐨勬枃浠跺悕鏄�岄亾璺揣鐗╄繍杈撴湀搴︾敓浜ф儏鍐碉紙2026骞�8鏈堬級.xls銆嶏紝鍗磋瀛樻垚 `2026-09`锛�2026-09-10 09:03:29 瀵煎叆锛夛紱2026-09-11 17:48 宸茬敤姝ｇ‘鐨� 8 鏈堟枃浠堕噸瀵间负 `2026-08`锛坆atch 320锛屽悓涓� 636 琛� / 90 鍖哄垝锛夈��
+
+澶囦唤锛堝彲杩樺師锛夛細`_backup_h2032_2026-09_rows_20260916.sql`锛�636 涓厓缁勶級銆乣_backup_h2032_2026-09_batch302_20260916.sql`銆�
+
+## 鍥涖�佹祴璇曠幆澧�
+
+| 椤� | 鍊� |
+|---|---|
+| 鍚庣 | Spring Boot锛宍http://127.0.0.1:8090`锛堣繍琛屼腑锛� |
+| 鏁版嵁搴� | MySQL 8.0锛宍127.0.0.1:3308`锛屽簱 `traffic_audit` |
+| 瀵煎嚭鎺ュ彛 | `GET /api/report/export/summaryWorkbook?period=2026-08&mode=month` |
+| 棰勮鎺ュ彛 | `GET /api/report/preview?period=2026-08&mode=month&types=summaryWorkbook` |
+| 鍏紡姹傚�� | Excel COM锛坄CalculateFullRebuild`锛夆�斺�斿鍑轰欢鍏紡**鏃犵紦瀛樺��**锛宱penpyxl 璇诲嚭鏉ュ叏鏄� None锛屽繀椤荤敤 Excel 閲嶇畻 |
+| 婧愭枃浠� | `D:\05_鏁版嵁鍒嗙被\楂橀�焅瀹氱-婀栧寳鐪佸悇甯傚窞杩愯緭閲忔暟鎹紙2026骞�1-8鏈堬級.xlsx`锛�2021/2022/2024/2025/2026 椤碉級+ `D:\05_鏁版嵁鍒嗙被\璐ц繍\7鏈圽瀹氱-婀栧寳鐪佸悇甯傚窞杩愯緭閲忔暟鎹紙2026骞�1-7鏈堬級.xlsx`锛�2023 椤碉級 |
+
+## 浜斻�佺敤渚嬭〃
+
+### 5.1 姝ｅ悜鐢ㄤ緥
+
+| # | 杈撳叆/鎿嶄綔 | 棰勬湡 | 瀹為檯 | 缁撹 |
+|---|---|---|---|---|
+| P1 | 閲嶅鍑� 2026-08 姹囨�诲ぇ琛紝Excel 閲嶇畻鍚庤 ` 璐ц繍` 鍏ㄧ渷琛� 6 涓疮璁″垪 | 2021/2022/2023 涓庢簮鏂囦欢涓�鑷� | 2026 宸� -1.8e-6銆�2025 +4.1e-5銆�2024 -2.1e-5銆�2023 +2.9e-5銆�2022 -2.9e-11銆�2021 +2.0e-5锛堝懆杞噺鍚岄噺绾э級 | 閫氳繃 |
+| P2 | 鍚屼笂锛岃 2021 绱鍒� EO | 鏈夊�间笖绛変簬 161309.5316 | 161309.5316 | 閫氳繃 |
+| P3 | 瀵煎嚭浠躲�屽叏鐪佽銆嶉�愭湀 vs銆�17 甯傚窞琛屼箣鍜屻�� | 宸害绛変簬 0 | 2021<=5.5e-12銆�2022<=5.5e-12銆�2023<=3.6e-12銆�2025<=5.5e-12锛堝懆杞噺 <=9.3e-10锛� | 閫氳繃 |
+| P4 | 姣嶇増閲嶇畻鍚庡悓涓� | 宸害绛変簬 0 | 2021-2025 鍏ㄩ儴 <=9.3e-10 | 閫氳繃 |
+| P5 | 瀵煎嚭浠� 2026 骞� 8 鏈堝綋鏈堝�� | 鍏ㄧ渷璐ц繍閲� 16888.76 | Q5=16888.7615锛孮11(姝︽眽甯�)=5173.1802 | 閫氳繃 |
+| P6 | 棰勮鎺ュ彛 `types=summaryWorkbook` | 杩斿洖姹囨�绘寚鏍� | `ready=true`銆乣rows=159`銆�20 椤规寚鏍囷紙褰撴湀璐ц繍閲� 16888.76銆佺疮璁� 130311.89锛� | 閫氳繃 |
+| P7 | 2021 绱鍚屾瘮 EA 鎶芥煡 | 鍒嗘瘝涓� 0 鐨勮涓嶆樉绀洪敊璇� | EA5=-0.1012355銆丒A11=-0.0886607銆丒A90 绌恒�丒A111 绌� | 閫氳繃 |
+
+### 5.2 璐熷悜鐢ㄤ緥 / 鍥炲綊鐢ㄤ緥
+
+| # | 杈撳叆/鎿嶄綔 | 棰勬湡 | 瀹為檯 | 缁撹 |
+|---|---|---|---|---|
+| N1 | 鐢� openpyxl 鍙﹀瓨姣嶇増鍐嶅鍑猴紙鍘嗗彶韪╁潙澶嶇幇锛� | 浼氫涪鍏紡缂撳瓨鍊硷紝鏁�**涓嶉噰鐢�**璇ュ疄鐜� | 鏈噰鐢紱鏀圭敤 Excel COM锛岀紦瀛樺�间繚鐣� | 瑙勯伩 |
+| N2 | 鏀规瘝鐗堟椂鎶婂叕寮忓啓鎴� `SUM(DM5)` 涔嬬被娈嬬己寮曠敤锛堥娆¤剼鏈� `"$m7"` 琚� PowerShell 褰撳彉閲忓悕锛� | 搴斿彂鐜板苟鍥炴粴 | 宸插彂鐜帮細浠� `_bak` 澶囦唤杩樺師鍚庯紝鏀圭敤 `${r}`/`${m}` 瀹氱晫閲嶈窇 | 閫氳繃 |
+| N3 | 2026-07 鏈熷鍑猴紙鍥炲綊锛屾瘝鐗堟湭鏀癸級 | 浠嶈兘姝ｅ父瀵煎嚭 | `_regress_summary_2026-07.xlsx` 941,969 瀛楄妭锛宍 璐ц繍` 椤� 118x145 | 閫氳繃 |
+| N4 | 瀵煎嚭鍚庢煡璇� `h2032_enterprise_monthly` 鏄惁杩樻湁 2026-09 | 鏃� | 2026-01...2026-08 鍚� 636 琛岋紝鏃� 2026-09 | 閫氳繃 |
+| N5 | `import_batch` 鏄惁杩樻湁 id=302 | 鏃� | 宸插垹闄� | 閫氳繃 |
+| N6 | 澶囦唤 SQL 鍙繕鍘熸�� | 鍏冪粍鏁板簲涓� 636 | 瀹炴祴 636 涓厓缁� | 閫氳繃 |
+
+### 5.3 鍏ュ簱鎶芥煡
+
+| # | 鎶芥煡椤� | 缁撴灉 |
+|---|---|---|
+| D1 | `h2032_enterprise_monthly` 2026 骞村悇鏈熻鏁� / 鍖哄垝鏁� | 2026-01 636/91锛�2026-02...08 鍚� 636/90 |
+| D2 | 鍒犻櫎鍓嶅悗 rowcount | 鍒� 636 琛岋紙`ROW_COUNT()` 瀹炴祴 636锛夈�佸垹 batch 1 琛� |
+| D3 | 澶囦唤鏂囦欢瀛楄妭鏁� | rows 725,989 瀛楄妭 / batch 1,624 瀛楄妭 |
+
+## 鍏�佷慨澶嶅墠鍚庡姣旓紙瀵煎嚭浠跺疄娴嬶級
+
+| 骞村害 | 鍒� | 淇鍓� | 淇鍚� | 婧愭枃浠舵牳绠� | 淇鍚庡樊寮� |
+|---|---|---|---|---|---|
+| 2026(1-8鏈�) | S | 130311.8927 | 130311.8927 | 130311.8927 | -1.8e-6 |
+| 2025 | AT | 195433.2232 | 195433.2232 | 195433.2232 | +4.1e-5 |
+| 2024 | BV | 184938.5780 | 184938.5780 | 184938.5780 | -2.1e-5 |
+| 2023 | CW | 173045.2932 | **173045.2964** | 173045.2964 | +2.9e-5 |
+| 2022 | DZ | 144979.2854 | **144979.2825** | 144979.2825 | -2.9e-11 |
+| 2021 | EO | 绌� | **161309.5316** | 161309.5316 | +2.0e-5 |
+
+鍛ㄨ浆閲忚锛�2021 `21961780.4134`銆�2022 `20587594.6295`銆�2023 `24243256.5443`銆�2024 `25071499.8353`銆�2025 `26403562.8772`銆�2026 `17492129.0479`锛屼笌婧愭枃浠跺樊寮傚潎 <=2.1e-4銆�
+
+**6/6 绱鍒楀湪 4 浣嶅皬鏁版樉绀哄彛寰勪笅涓庢簮鏂囦欢浜哄伐鏍哥畻瀹屽叏涓�鑷淬��**
+
+## 涓冦�佸彂鐜扮殑闂涓庡缃�
+
+| # | 涓ラ噸搴� | 闂 | 澶勭疆 |
+|---|---|---|---|
+| 1 | 楂� | `h2032_enterprise_monthly` 澶氬嚭 2026-09 鏈燂紙瀹炰负 8 鏈堟枃浠讹級 | **宸插垹闄�**锛堝惈 batch 302锛夛紝鐣欏彲杩樺師澶囦唤 |
+| 2 | 楂� | 姣嶇増銆屽叏鐪佽涓嬨�嶈鍐欐甯搁噺锛屽鑷� 2022/2023 绱鍚勫樊绾� 0.003 | **宸叉敼涓� 17 甯傚窞姹傚拰鍏紡** |
+| 3 | 涓� | 姣嶇増 2021 绱鍒� EO 鏁村垪涓虹┖ | **宸茶ˉ `=SUM(EC:EN)`** |
+| 4 | 涓� | 姣嶇増 2022 绱鍒� DZ銆佺疮璁″悓姣� EA 涓哄啓姝诲父閲� | **宸叉敼涓哄叕寮�** |
+| 5 | 浣� | 姣嶇増 Excel 閲嶅瓨鍚庡鍑轰欢浣撶Н鐢� 950,186 -> 1,331,599 瀛楄妭锛圗xcel 鑷韩鏍煎紡寮�閿�锛宍_鐗堝紡鍘熷瀷.xlsx` 鍚屼负 1.48MB 閲忕骇锛� | 璁板綍锛屼笉褰卞搷鏁版嵁 |
+| 6 | 浣� | 瀵煎嚭浠� ` 璐ц繍` 椤靛瓨鍦� <=2.1e-4 鐨勬诞鐐圭疮鍔犲櫔澹� | 璁板綍锛�4 浣嶅皬鏁版樉绀轰竴鑷� |
+| 7 | 鎻愮ず | 鍙﹀彂鐜� 2026-09 鏈熻繕鏈夛細`h204_vehicle_quarterly` 1284 琛岋紙batch 142锛屼笌 2026-08 鐨� batch 144 鍚屾枃浠讹級銆乣investment_monthly` 31 琛岋紙batch 107锛屼笌 batch 108 鍚屾簮锛夈�乣audit_result` 2061 琛屻�乣audit_run` 3 琛� | **鏈鏈姩**锛堜笉鍦ㄦ巿鏉冭寖鍥达級锛屽緟鐢ㄦ埛纭鏄惁涓�骞舵竻鐞� |
+| 8 | 鎻愮ず | 2026-07 鏈熷鍑轰欢鐨� ` 璐ц繍` 椤典负 118x145锛堟瘮 8 鏈堝皯 2 鍒楋級锛屽洜 7 鏈堟瘝鐗堟槸銆�1-4 鏈堥鏋躲�� | 鍗曠嫭璁锛屽緟 7 鏈堟瘝鐗堝畾绋� |
+
+## 鍏�佺粨璁�
+
+1. 鐢ㄦ埛闂銆岀疮璁″彧鏈夊墠闈㈠洓涓寰椾笂銆�**宸插畾浣嶅苟瑙ｅ喅**锛氭牴鍥犱笉鍦ㄧ疮璁″叕寮忔湰韬紝鑰屽湪姣嶇増銆屽叏鐪佽涓嬨�嶈鏄笌 17 甯傚窞涓嶇鐨勫啓姝诲父閲忥紱鍙犲姞 2021 绱鍒楁紡濉��2022 绱鍒楀啓姝诲父閲忋��
+2. 淇鍚� 6 涓疮璁″垪锛圫/AT/BV/CW/DZ/EO锛夊湪 4 浣嶅皬鏁板彛寰勪笅涓庢簮鏂囦欢浜哄伐鏍哥畻**鍏ㄩ儴涓�鑷�**銆�
+3. `h2032_enterprise_monthly` 2026-09 鑴忔湡宸叉竻闄わ紝澶囦唤鍙繕鍘熴��
+4. 2026-07 瀵煎嚭鍥炲綊閫氳繃锛涢瑙堟帴鍙ｆ甯搞��
+5. 閬楃暀锛�2026-09 鍦� `h204_vehicle_quarterly` / `investment_monthly` / `audit_result` / `audit_run` 涓粛鏈夋暟鎹紝寰呯敤鎴风‘璁ゆ槸鍚︽竻鐞嗐��
diff --git "a/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-16.md" "b/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-16.md"
index 5092143..196259b 100644
--- "a/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-16.md"
+++ "b/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-16.md"
@@ -241,3 +241,71 @@
### 19.4 git 缁撴灉锛堟湰杞級
- 鎻愪氦 `27574bc`锛堝姛鑳芥祴璇曟姤鍛� + 鏈妭 + .gitignore 琛� `_pylibs/`銆佷慨姝� `~$*` 鍓嶅绌烘牸锛夆啋 **宸叉帹 origin锛坓itee master锛�**锛歚559e937..27574bc`銆�
- **鍏徃 gitea 浠嶄笉鍙敤**锛歚Test-NetConnection 61.183.254.94:3000` 杩斿洖 True锛圱CP 閫氾級锛屼絾 `GET /r/trafficAudit.git/info/refs?service=git-upload-pack` 25 绉掓棤浠讳綍鍝嶅簲锛圚TTP 000锛夛紝`git fetch gitea` 鎶� `Operation too slow. Less than 1000 bytes/sec`銆傚垽鏂负鏈嶅姟绔湭姝ｅ父鎻愪緵 HTTP 鍝嶅簲锛屽緟鎭㈠鍚庤ˉ鎺紝**绂佸己鎺�**銆�
+
+## 浜屽崄銆佺敤鎴枫�屽彲浠ャ�嶆巿鏉冮」钀藉疄锛氳揣杩愰〉绛剧疮璁″垪淇 + H2032 鑴忔湡娓呯悊
+
+### 20.1 鍏抽敭鍙戠幇锛氭牴鍥犱笉鏄疮璁″叕寮忥紝鑰屾槸銆屽叏鐪佽涓嬨�嶈
+
+涓婁竴鑺傛垜鍒ゅ畾涓恒��2021 绱鍒楃┖ + 2022 鍐欐甯搁噺 + 2023 绮惧害宸�嶏紝鏈疆鐢� Excel COM 閫愭湀瀹炴祴鍚�**淇浜嗙粨璁�**銆傚 6 涓勾搴﹀潡閫愭湀姣旇緝銆屽叏鐪佽銆嶄笌銆�17 甯傚窞琛屼箣鍜屻�嶏細
+
+| 骞村害 | 鍚堣宸� | 瑙勪笂宸� | 瑙勪笅宸� |
+|---|---|---|---|
+| 2026(1-8) | 2.8e-5 | 1.8e-12 | 2.8e-5 |
+| 2025 | 3.3e-11 | 9.1e-13 | 3.5e-11 |
+| 2024 | 1.5e-11 | 9.1e-13 | 1.3e-11 |
+| 2023 | **4.6e-3** | 4.5e-13 | **4.6e-3** |
+| 2022 | **3.1e-3** | 2.3e-13 | **3.1e-3** |
+| 2021 | 4.0e-5 | 4.0e-5 | 1.5e-4 |
+
+- 銆岃涓娿�嶅叏鐪佽姘歌繙鏄� 17 甯傚窞涔嬪拰锛堝叕寮忥級锛�**涓�澶勪笉宸�**锛�
+- 宸紓 100% 鏉ヨ嚜銆屽叏鐪佽涓嬨�嶈 鈥斺�� 瀹冩槸**鍐欐鐨勫父閲�**锛屼笌 17 甯傚窞瑙勪笅涔嬪拰涓嶇瓑锛�
+- 鑰屻��17 甯傚窞琛屼箣鍜屻�嶆伆濂界瓑浜庢簮鏂囦欢婀栧寳鐪佽锛�2022 = 144979.2825銆�2023 = 173045.2964锛夛紝姝ｆ槸鐢ㄦ埛浜哄伐鏍哥畻鐨勯偅涓暟銆�
+
+鎵�浠ュ彧瑕佹妸銆屽叏鐪� 瑙勪笂/瑙勪笅銆嶄袱琛岄兘鏀规垚 17 甯傚窞姹傚拰鍏紡锛屽叏鐪佽鑷劧绛変簬甯傚窞涔嬪拰锛岀疮璁″垪闅忎箣鑷姩瀵逛笂銆�
+
+### 20.2 姣嶇増鏀瑰姩锛坉ocs/鐢熸垚姹囨�诲ぇ琛�/2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx 鐨勩�� 璐ц繍銆嶉〉锛�
+
+| 浣嶇疆 | 鏀瑰墠 | 鏀瑰悗 |
+|---|---|---|
+| r7/r8/r9/r10锛堝叏鐪� 瑙勪笂/瑙勪笅 璐ц繍閲徛峰懆杞噺锛�2021-2025 鍚勬湀锛� | 鍐欐甯搁噺 | SUM(17 甯傚窞瀵瑰簲琛�) |
+| r5/r6锛堝叏鐪� 璐ц繍閲�/鍛ㄨ浆閲忥紝2021-2025 鍚勬湀锛� | 甯搁噺 | m7+m9 / m8+m10 |
+| DZ锛�2022 绱锛岃 5-112锛� | 鍐欐甯搁噺 | SUM(DM:DX) |
+| EO锛�2021 绱锛岃 5-112锛� | 绌� | SUM(EC:EN) |
+| EA锛�2022 绱鍚屾瘮锛岃 5-112锛� | 鍐欐甯搁噺 | IFERROR(DZ/SUM(EC:EN)-1,"") |
+
+鍏� 360 + 324 涓崟鍏冦��2026 骞村潡涓嶅姩锛堝綋鏈堝�肩敱瀵煎嚭浠ｇ爜鍥炲～锛夛紱EP锛�2021 绱鍚屾瘮锛変繚鎸佷负绌猴紙椤靛唴娌℃湁 2020 鍧楋紝鏃犲悓姣斿熀鏈燂級銆傛敼鍓嶅浠� docs/鐢熸垚姹囨�诲ぇ琛�/_bak_202608姣嶇増淇敼鍓峗20260916/銆�
+
+**鍙敼姣嶇増杩欎竴涓枃浠�**锛氱敓鎴恄閬撹矾杩愯緭閲忔眹鎬昏〃.xlsx 鏄垪瀹藉弬鐓т欢锛堜唬鐮佸彧璇诲垪瀹�/闅愯棌鏍囪锛夛紝_鐗堝紡鍘熷瀷.xlsx 杩愯鏃舵棤浠讳綍浠ｇ爜寮曠敤锛涘悓鏈熷浠芥瘝鐗� resolveSummaryDonor(2026,8) 瑕佹眰鏂囦欢鍚嶄互 _澶囦唤_ 寮�澶翠笖鍚��2026骞�8鏈堛�嶏紝鐩綍涓嬫棤鍖归厤锛堝鍑烘棩蹇楃‘璁ゃ�屾湭鎵惧埌鍚屾湡澶囦唤姣嶇増銆嶏級锛屼笉浼氬啿鎺夋敼鍔ㄣ��
+
+### 20.3 鏁版嵁搴撴竻鐞�
+
+- DELETE FROM h2032_enterprise_monthly WHERE report_period='2026-09' 鈫� 636 琛岋紙ROW_COUNT() 瀹炴祴锛�
+- DELETE FROM import_batch WHERE id=302 鈫� 1 琛�
+- 澶囦唤锛歘backup_h2032_2026-09_rows_20260916.sql锛�636 鍏冪粍锛夈�乢backup_h2032_2026-09_batch302_20260916.sql
+
+### 20.4 淇鍚庡疄娴嬶紙閲嶅鍑� 2026-08锛孍xcel 閲嶇畻锛�
+
+| 骞村害 | 鍒� | 淇鍓� | 淇鍚� | 婧愭枃浠舵牳绠� |
+|---|---|---|---|---|
+| 2026(1-8鏈�) | S | 130311.8927 | 130311.8927 | 130311.8927 |
+| 2025 | AT | 195433.2232 | 195433.2232 | 195433.2232 |
+| 2024 | BV | 184938.5780 | 184938.5780 | 184938.5780 |
+| 2023 | CW | 173045.2932 | **173045.2964** | 173045.2964 |
+| 2022 | DZ | 144979.2854 | **144979.2825** | 144979.2825 |
+| 2021 | EO | 绌� | **161309.5316** | 161309.5316 |
+
+鍏ㄩ儴 4 浣嶅皬鏁颁竴鑷达紙鏈�澶ф畫宸� 4.1e-5锛屼负娴偣绱姞鍣０锛夈�傚鍑轰欢銆屽叏鐪佽銆峷s銆�17 甯傚窞琛屼箣鍜屻�嶉�愭湀 灏忎簬绛変簬 9.3e-10銆傞瑙堟帴鍙� types=summaryWorkbook 杩斿洖 ready=true銆�20 椤规寚鏍囷紙褰撴湀璐ц繍閲� 16888.76銆佺疮璁� 130311.89锛夈��2026-07 瀵煎嚭鍥炲綊閫氳繃銆�
+
+### 20.5 韪╁潙
+
+1. **PowerShell 鍙屽紩鍙烽噷鐨� "$m7" 浼氳褰撴垚鍙橀噺 m7**锛氬叕寮忎覆 "=SUM(DM$r:DX$r)" 涓殑 $r:DX 琚綋鎴愩�岄┍鍔ㄥ櫒 r:銆嶈�屽悶鎺夛紝鍏紡琚啓鎴� =SUM(DM5) 鈥斺�� 棣栨鑴氭湰宸叉妸姣嶇増鏀瑰潖锛岄潬澶囦唤杩樺師鍚庢敼鐢� ${m}/${r} 瀹氱晫閲嶈窇銆�
+2. **宓屽鐨勫崟寮曞彿 here-string 浼氭彁鍓嶇粓姝㈠灞� here-string** 鈫� 鏀逛负銆屽厛 Out-File 鍐欒ˉ涓佹枃浠讹紝鍐� Get-Content -Raw 浼犵粰 codex.exe --codex-run-as-apply-patch銆嶃��
+3. 姣嶇増琚� Excel 閲嶅瓨鍚庝綋绉� 959,706 鈫� 1,480,392 瀛楄妭锛屽鍑轰欢 950,186 鈫� 1,331,599锛圗xcel 鑷韩鏍煎紡寮�閿�锛屼笉褰卞搷鏁版嵁锛夈��
+4. 2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃_鐗堝紡鍘熷瀷.xlsx 鐨� S 鍒楁紡浜� 8 鏈堬紙=C+E+G+I+K+M+O锛岀己 Q5锛夛紝浣嗗畠杩愯鏃朵笉琚紩鐢紝鏈鏈敼銆�
+
+### 20.6 閬楃暀
+
+- 2026-09 鏈熷湪 h204_vehicle_quarterly锛�1284 琛岋紝batch 142/144 鍚屾枃浠讹級銆乮nvestment_monthly锛�31 琛岋紝batch 107/108 鍚屾簮锛夈�乤udit_result锛�2061 琛岋級銆乤udit_run锛�3 琛岋級涓粛鍦紝鏈鏈姩锛屽緟鐢ㄦ埛纭鏄惁娓呯悊銆�
+- 2026-07 鏈熷鍑轰欢銆� 璐ц繍銆嶉〉涓� 118x145锛堟瘮 8 鏈堝皯 2 鍒楋級锛屽洜 7 鏈堟瘝鐗堟槸銆�1-4 鏈堥鏋躲�嶃��
+
+璇﹁銆婂姛鑳芥祴璇曟姤鍛�/鍔熻兘娴嬭瘯鎶ュ憡_璐ц繍椤电绱鍒椾慨澶嶄笌鑴忔湡娓呯悊_2026-09-16.md銆嬨��
diff --git "a/docs/\347\224\237\346\210\220\346\261\207\346\200\273\345\244\247\350\241\250/2026\345\271\2648\346\234\210\351\201\223\350\267\257\350\277\220\350\276\223\351\207\217\346\261\207\346\200\273\350\241\250.xlsx" "b/docs/\347\224\237\346\210\220\346\261\207\346\200\273\345\244\247\350\241\250/2026\345\271\2648\346\234\210\351\201\223\350\267\257\350\277\220\350\276\223\351\207\217\346\261\207\346\200\273\350\241\250.xlsx"
index c7cccde..c5c9d42 100644
--- "a/docs/\347\224\237\346\210\220\346\261\207\346\200\273\345\244\247\350\241\250/2026\345\271\2648\346\234\210\351\201\223\350\267\257\350\277\220\350\276\223\351\207\217\346\261\207\346\200\273\350\241\250.xlsx"
+++ "b/docs/\347\224\237\346\210\220\346\261\207\346\200\273\345\244\247\350\241\250/2026\345\271\2648\346\234\210\351\201\223\350\267\257\350\277\220\350\276\223\351\207\217\346\261\207\346\200\273\350\241\250.xlsx"
Binary files differ
--
Gitblit v1.9.1