From 4792a6c11fd390ce36f71106f7f332ab6226489a Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期二, 22 九月 2026 10:06:58 +0800
Subject: [PATCH] docs: 数据查看冻结列与数据类型下拉框功能测试报告 + 日结补充
---
docs/工作日结/工作日结_2026-09-16.md | 215 +++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 215 insertions(+), 0 deletions(-)
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 36fde62..54a2c8d 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"
@@ -165,3 +165,218 @@
| 2銆屾槸涓嶆槸鎶� 23 骞翠篃瀵艰繘鍘汇�� | 鏄紝宸插鍏� `2023-12`锛�18 琛岋級銆傝嫢瑕佸洖濉� `2024-12` 鐨勪笂骞村悓鏈熷�硷紝闇�鍐嶉噸瀵间竴娆� 2024 骞存暟鎹紙寰呯敤鎴风‘璁わ級銆� |
| 3銆屽彲浠ャ�� | 棰勮寮圭獥鏂囨宸叉寜纭淇敼锛堟眹鎬诲ぇ琛ㄣ�屾寚鏍� N 椤广�嶏紡鍏跺畠鎶ヨ〃銆屽叡 N 琛屾槑缁嗐�嶏級锛屽苟宸插湪娴忚鍣ㄥ疄娴嬨�� |
| 4銆屼粈涔堟椂鍊欏紑濮嬭繛涓嶄笂鐨勩�� | 鍏徃 gitea **鑷� 2026-09-15 璧蜂笉鍙敤**锛�09-15 涓哄嚟鎹脊绐楁湭鎺ㄦ垚鍔燂紱09-16 璧峰彉涓� TCP 3000 鍙繛浣� HTTP 鏃犲搷搴斻�備粖鏃ュ娴� `Test-NetConnection` 涓� True銆乣curl` 25s 瓒呮椂 `code=000`銆� |
+
+## 鍗佸叚銆乬it 瀹為檯缁撴灉锛堟敹灏捐ˉ璁帮級
+
+- `git fetch origin`锛堜釜浜� gitee锛夛細`HEAD...origin/master = 0 0`锛屾棤鏂版彁浜わ紝鏃犻渶鍚堝苟銆�
+- 鎻愪氦 `e7cddc4`锛歚fix(report): 棰勮寮圭獥琛屾暟鏂囨鎸夋姤琛ㄧ被鍨嬪尯鍒哷锛�4 涓枃浠讹紝+25/-1锛夈��
+- 鎺ㄤ釜浜轰粨搴� `origin`锛歚git push origin main:master` 鎴愬姛锛坄b0c8b4f..e7cddc4`锛夈��
+- 鎺ㄥ叕鍙� `gitea`锛歚git fetch gitea` 浠嶅け璐ワ紝鎶� `fatal: unable to access ... Recv failure: Connection was reset`锛坄fetch_exit=128`锛夛紝鏈**鏈帹閫佹垚鍔�**锛岀户缁垪涓洪仐鐣欓棶棰橈紱琛ユ帹鍓嶅厛 `git fetch gitea` 涓庤繙绔� `main` 鍚堝苟锛�**绂佸己鎺�**銆�
+
+## 鍗佷竷銆佺敤鎴风 5 鏉★細姹囨�诲ぇ琛ㄤ笌 8 鏈堝畾绋块�愯〃姣斿
+
+**姣斿瀵硅薄**锛歚D:\妗岄潰\鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃.xlsx`锛堢敤鎴� 14:39 瀵煎嚭锛� vs `D:\05_鏁版嵁鍒嗙被\姹囨�昏〃\8鏈堟眹鎬诲畾绋縗2026骞�8鏈堝杩愰噺銆佽揣杩愰噺瀹氱.xlsx`銆傞噸鏂板鍑轰竴娆★紙`GET /api/report/export/summaryWorkbook?period=2026-08&mode=month`锛夊緱鍒扮殑鏂囦欢涓庢闈㈤偅浠�**瀛楄妭鏁板畬鍏ㄤ竴鑷达紙950,186锛�**锛屾帓闄も�滄枃浠惰繃鏈熲�濄��
+
+**韪╃殑鍧戯紙閲嶈锛�**锛�
+1. 涓よ竟**琛屽潡楂樺害涓嶅悓**锛堝鍑烘瘡甯傚窞 6 琛屻�佸畾绋� 4 琛岋紱瀵煎嚭 118 琛� vs 瀹氱 84 琛岋級锛岀洿鎺ユ寜鍗曞厓鏍煎潗鏍囨瘮浼氬緱鍑� 4.6 涓囦釜鈥滃樊寮傗�濓紝鍏ㄦ槸閿欎綅鍣０ 鈫� 鏀圭敤銆屽湴鍖�+鎸囨爣+鍒楁爣棰樸��**璇箟閿�**瀵归綈銆�
+2. 瀵煎嚭绔湁 **39,939 涓叕寮忔牸**锛坄=C7+C9`銆乣=C5/V5-1`銆乣RANK(...)`锛夛紝`openpyxl(data_only=True)` 璇诲嚭鏉ュ叏鏄� None 鈫� 璇垽鎴愨�滄暣琛ㄦ病鏁版嵁鈥濄�侲xcel COM 鎵撲笉寮�锛堢敤鎴峰凡寮�鐫� Excel锛屼笉鑳戒贡鍔級锛屾渶鍚�**鑷繁鍐欏叕寮忔眰鍊煎櫒**锛圫UM/RANK/ROUND+鍥涘垯+璺ㄨ〃寮曠敤锛夌畻鍑� 61,972 涓暟鍊兼牸鍐嶆瘮銆�
+
+**缁撹**锛氳涔夐敭涓�鑷� 28,567 涓紝涓嶄竴鑷� 4,742 涓��
+* ` 璐ц繍` 琛細瀵煎嚭姣忓競宸炴瘮瀹氱**澶氫袱琛�**锛堛�岃涓�+瑙勪笅璐ц繍閲忋�嶃�岃涓嬭揣杩愰噺銆嶏級锛屽悓鎸囨爣鏁板��**闆跺樊寮�**锛涘畾绋胯繕鏈夈�岃涓�+瑙勪笅鍛ㄨ浆閲忋�嶈鑰屽鍑鸿琛屼负绌恒��
+* **鏈�澶у樊寮傛潵婧�**锛歚city_bus_monthly / city_taxi_monthly / wyc_order_monthly / wyc_total_monthly` **鍙湁 2026-01~08锛屾病鏈� 2025 骞�** 鈫� 鍏氦/鍑虹/缃戠害杞�/涓彛寰勫嚑寮犺〃鐨勩�屼笌鍘诲勾鍚屾瘮銆嶈绠楁垚 `0`/`-1`銆�2025 骞寸疮璁″亸灏忋��
+* `h2031_enterprise_monthly` 缂� `2025-01`锛堟簮鏂囦欢鏈韩娌℃湁 1 鏈堬級銆�
+* 瀵煎嚭绔�屼腑鍙ｅ緞鍒嗘瀽銆嶅涓�娈靛綋鏈堝潡銆佺己 4 琛屸�滃崰姣斺�濄��
+璇﹁銆婂姛鑳芥祴璇曟姤鍛�/姹囨�诲ぇ琛ㄤ笌瀹氱姣斿_2026-09-16.md銆嬨��
+
+## 鍗佸叓銆佺敤鎴风 2 鏉★細2024 骞存暟鎹噸瀵硷紙鍥炲～涓婂勾鍚屾湡锛�
+
+**鑳屾櫙**锛歚last_*`锛堜笂骞村悓鏈燂級鍙粠**鍚屼竴涓伐浣滅翱鐨勪笂涓�骞� Sheet** 鍙栵紝8 鏈堟枃浠舵病鏈� `2023` Sheet锛屾墍浠� `2024-12` 鐨� `last_*` 涓�鐩存槸 NULL銆�
+
+**杩囩▼**锛氬厛鐢� 7 鏈堟枃浠讹紙鍚� `2023` Sheet锛夊彟瀛樺彧鐣� 4 涓勾搴� Sheet 鐨勪复鏃舵枃浠跺鍏� 鈫� `2024-12` 鐨� `last_*` 濉笂浜嗭紝浣� **`2021-12` 鐨勩�屾箹鍖楃渷銆嶈 1 鏈堝�间粠 14945.34 鍙樻垚浜� 0**銆傛帓鏌ュ彂鐜般�屾箹鍖楃渷銆嶈鏄� `=SUM()` **鍏紡**锛宱penpyxl 鍙﹀瓨浼�**涓㈡帀鍏紡鐨勭紦瀛樺��**锛孭OI 璇诲埌绌哄叕寮忓氨鍐� 0銆�
+
+**淇**锛氭敼鐢�**鍘熷 7 鏈堟枃浠�**鏁翠唤閲嶅锛坄POST /api/import/freightTurnover?period=2026-07`锛岃繑鍥炪�屽叡 108 鏉¤褰曘��= 6 鏈� 脳 18 琛岋級銆�
+
+**澶嶆牳**锛�7 鏈�/8 鏈堜袱涓枃浠剁殑 11 涓勾搴� Sheet 涓庡簱閫愭牸姣斿 **4,752 鏍煎叏閮� 0 涓嶄竴鑷�**锛涗笂骞村悓鏈熼摼鏉� 2022鈫�2021銆�2023鈫�2022銆�2024鈫�2023銆�2025鈫�2024銆�2026-07/08鈫�2025 **鍏ㄩ儴 0 涓嶄竴鑷�**銆�
+
+**鏁欒**锛氫互鍚庝笉鑳界敤 openpyxl 鍙﹀瓨 Excel 鍐嶅杺缁欏悗绔紝鍏紡缂撳瓨浼氫涪锛涜涔堢敤鍘熷鏂囦欢锛岃涔堢敤 Excel COM 鍙﹀瓨銆�
+
+
+## 鍗佷節銆佺敤鎴风 3 杞彁闂細璐ц繍椤电銆岀疮璁°�嶄负浠�涔堝彧鏈夊墠鍥涗釜瀵瑰緱涓� + 鏂板鍏ユ暟鎹綋妫�
+
+### 19.1 瀹氫綅杩囩▼
+1. 瑙ｅ墫瀵煎嚭浠躲�� 璐ц繍銆嶉〉绛撅細鍏� 6 涓疮璁″垪 鈥斺�� `S`(2026 1-8鏈�)銆乣AT`(2025)銆乣BV`(2024)銆乣CW`(2023)銆乣DZ`(2022)銆乣EO`(2021)銆�
+2. 璇绘瘝鐗� `docs/鐢熸垚姹囨�诲ぇ琛�/鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃.xlsx` 鐨勫悓鍚嶉〉锛歚S5/AT5/BV5/CW5` 鏄� **危鍏紡**锛宍DZ5` 鏄� **鏁板�煎父閲� 144979.285376043**锛宍EO5/EP5` **涓虹┖**銆�2021 骞� `EC5:EN5` 鍗佷簩涓湀閮芥湁鍊硷紙鍚堣 161309.5316锛夛紝鍙槸绱鍒楁紡浜嗐��
+3. 鐢ㄦ簮鏂囦欢锛坄D:\05_鏁版嵁鍒嗙被\楂橀�焅瀹氱-婀栧寳鐪佸悇甯傚窞杩愯緭閲忔暟鎹紙2026骞�1-8鏈堬級.xlsx`锛屽彟鏈� 7 鏈堟枃浠跺惈 2023 椤碉級澶嶇畻鍏ㄧ渷琛岋細
+
+| 骞村害 | 鍒� | 姹囨�昏〃 | 婧愭枃浠舵牳绠� | 宸紓 |
+|---|---|---|---|---|
+| 2026(1-8鏈�) | S | 130311.8927 | 130311.8927 | 0 |
+| 2025 | AT | 195433.2232 | 195433.2232 | 0 |
+| 2024 | BV | 184938.5780 | 184938.5780 | 0 |
+| 2023 | CW | 173045.2932 | 173045.2964 | 鈭�0.0033 |
+| 2022 | DZ | 144979.2854 | 144979.2825 | +0.0029 |
+| 2021 | EO | 绌� | 161309.5316 | 鏁村垪缂哄け |
+
+鍛ㄨ浆閲忚鍚岀悊锛�2023 鈭�0.0017銆�2022 +0.0025銆�2021 绌猴級銆傚競宸炶 2026~2022 閫愭牸涓�鑷达紝宸紓鍙湪銆屽叏鐪併�嶈鍜� 2021 鍒椼��
+
+### 19.2 鍘熷洜
+* **2021 绱鍒楋紙EO锛夊湪姣嶇増閲屽氨鏄┖鐨�** 鈥斺�� 婕忓～绱鍏紡锛�8 鏈堝畾绋垮悓鏍蜂负绌猴紝灞炲巻鍙查仐鐣欍��
+* **2022 绱鍒楋紙DZ锛夋槸鍐欐甯搁噺**锛屼笉浼氶殢瀵煎叆鏁版嵁鍒锋柊锛涘叾鍚勬湀鍊间篃鏄綋骞存墜宸ュ綍鍏ョ殑鏃х簿搴︼紙1 鏈� 10709.5265 vs 婧愭枃浠� 10709.5234锛夈��
+* **2023 绱鍒楋紙CW锛夋槸鍏紡锛屼絾杈撳叆鏉ヨ嚜姣嶇増**锛氭瘝鐗� 2023 鍏ㄧ渷琛� = 瑙勪笂+瑙勪笅涓よ鐩稿姞锛屼笌婧愭枃浠� `2023` 椤垫箹鍖楃渷琛岀簿搴︿笉鍚岋紝宸� 0.0033銆�
+* 浠ｇ爜姣忔瀵煎嚭鍙洖濉�岀洰鏍囧綋鏈堛�嶄竴鍒楋紙`SummaryWorkbookFiller.fillFreightSheet`锛夛紝鍘嗗彶鏈堜唤鍏ㄩ儴娌跨敤姣嶇増 鈫� 姣嶇増瀵逛笉涓婂氨鏁翠綋瀵逛笉涓娿��
+
+### 19.3 鏂板鍏ユ暟鎹綋妫�锛堥棶棰樻竻鍗曪級
+| # | 涓ラ噸搴� | 闂 |
+|---|---|---|
+| 1 | 楂� | `h2032_enterprise_monthly` 澶氬嚭涓�涓� **2026-09 鏈�**锛屾簮鏂囦欢鍚嶆槸銆岄亾璺揣鐗╄繍杈撴湀搴︾敓浜ф儏鍐碉紙2026骞�8鏈堬級.xls銆嶏紙batch 302锛夈�備笌 2026-08 鏈熼�愪紒涓氭瘮锛�636 鏉′紒涓氬畬鍏ㄥ悓闆嗐��90 涓尯鍒掞紝浠� 38 瀹朵紒涓氭暟鍊间笉鍚� 鈫� 鏄� 8 鏈堟暟鎹殑鍙︿竴鐗堟湰琚瓨鎴� 9 鏈� |
+| 2 | 楂� | `h2031_enterprise_monthly` **缂� 2025-01**锛堜粖澶╁彧瀵间簡 02~12锛夛紝2025 骞寸疮璁′細灏� 1 涓湀 |
+| 3 | 涓� | `passenger_individual_monthly` 2026-08 **缂洪粍鍐堝競**锛�7 鏉″彉 6 鏉★級 |
+| 4 | 浣� | PASSENGER_AUTH 11 鏈熷叏 0 琛岋紝闇�纭鏄惁姝ｅ父 |
+| 5 | 鎻愮ず | 2025-04 鐨� H2032 姝ゅ墠缂哄け锛屾湰娆″凡琛ラ綈锛坆atch 382锛�664 琛岋級锛沨2032 鍖哄垝鏁� 2025=87 / 2026=90锛屽睘浼佷笟杩涢��瑙勬甯稿彉鍔� |
+
+鍏ュ簱鎶芥煡锛欻2032 2025 鍏ㄥ勾瑙勪笂 50117.0940 涓囧惃 / 7435040.9971 涓囧惃鍏噷銆�2026 骞� 1-8 鏈堣涓� 31399.8248 涓囧惃锛岄�愬競宸� 17/17 涓庡鍑轰欢銆岃揣杩愰噺鎺掑悕銆嶇疮璁¤〃涓�鑷淬��
+
+璇﹁銆婂姛鑳芥祴璇曟姤鍛�/璐ц繍绱鍒楁牳瀵逛笌瀵煎叆鏁版嵁浣撴_2026-09-16.md銆嬨��
+
+### 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銆嬨��
+
+---
+
+## 浜屽崄涓�銆�2026-07 姣嶇増琛ラ綈 + 瀵煎嚭浠躲�孍xcel 鎵撲笉寮�銆嶆牴鍥犱慨澶�
+
+鏃ユ湡锛�2026-09-16锛堢 9 杞紝鎺ヤ簩鍗佽妭锛�
+
+### 21.1 浠婂ぉ鍋氫簡浠�涔�
+
+| # | 浜嬮」 | 缁撴灉 |
+|---|---|---|
+| 1 | 娓呯悊 2026-09 娈嬬暀鏁版嵁锛堢敤鎴风 1 鏉★級 | **瀹屾垚**锛歨204_vehicle_quarterly 1284 / investment_monthly 31 / audit_result 2061 / audit_run 3 / import_batch 5 / h2032 636锛屽叏閮ㄥ鏍镐负 0 娈嬬暀锛涘凡鐣欏彲杩樺師 SQL 澶囦唤 `_backup_2026-09_residual_all_20260916.sql` |
+| 2 | 淇� 2026-07 瀵煎嚭浠躲�孍xcel 鎵撲笉寮�銆� | **瀹屾垚**锛圥0锛岃 21.2锛� |
+| 3 | 琛ラ綈 2026-07 姣嶇増锛堢敤鎴风 3 鏉°�屽彲浠ヨˉ榻愩�嶏級 | **瀹屾垚**锛堣 21.3锛� |
+| 4 | 淇浠芥瘝鐗堝洖濉妸琛ラ綈銆屾墦鍥炲師褰€�� | **瀹屾垚**锛堣 21.4锛� |
+
+### 21.2 鏍瑰洜锛歰penpyxl 姣嶇増 + 澶囦唤鍥炲～ 鈫� 娈嬬暀 <is> 闈炴硶鏍�
+
+- 鍧忎欢閲� 19 涓牸瀛愬舰濡� `<c r="E15" s="111" t="n"><v>67.0</v><is><t>67.00</t></is></c>`锛歚t="n"` 鍗村甫 `<is>`锛屾ā寮忛潪娉曪紝Excel 鐩存帴鎷掑紑锛圕OM 鎶ャ�屼笉鑳藉彇寰楃被 Workbooks 鐨� Open 灞炴�с�嶏紝杩炰慨澶嶆ā寮� `CorruptLoad=1` 涔熸墦涓嶅紑锛夈��
+- 7 鏈堟瘝鐗堟槸 **openpyxl 鍐欏嚭**锛堟枃鏈瓨 `<is>`锛夛紝8 鏈堟瘝鐗堟槸 **Excel 鍘熺敓**锛堟枃鏈蛋 sharedStrings锛夆啋 鍚屼唬鐮佷笅鍙湁 7 鏈堝潖銆�
+- 瑙﹀彂鑰呮槸 `restoreSummaryMonthlyBlocks`锛�7 鏈堟湁 `_澶囦唤_2026骞�7鏈堚�︽竻鐞嗗墠鈥lsx`锛屾暣鏍煎洖濉椂寰� inlineStr 鏍奸噷鍐欏�硷紝鐣欎笅鏃� `<is>`锛�8 鏈堟病鏈� `_澶囦唤_*`锛屼笉璧板洖濉紝鎵�浠ヤ竴鐩存槸濂界殑銆�
+- 瀹氫綅鎵嬫硶锛堝�煎緱璁颁綇锛夛細鍧忎欢/濂戒欢**闄� worksheets/styles/sharedStrings 澶栧叏閮ㄩ儴浠堕�愬瓧鑺傜浉鍚�** 鈫� zip 鏉備氦 + Excel 閫愪竴寮�妗� leave-one-out 鈫� 閿佸畾 **sheet9銆婂叕浜ゃ��17 鏍� + sheet12銆婅建閬撱�佽疆娓°��2 鏍�**銆�
+
+### 21.3 淇
+
+1. `ReportExportService.exportSummaryWorkbook`锛氳惤鐩樺墠鏂板 `normalizeStaleInlineStrings(wb)`锛屾竻鎺夋墍鏈夈�岄潪 inlineStr 鍗存畫鐣� `<is>`銆嶇殑鏍煎瓙锛堝箓绛� + warn 鏃ュ織锛夈��
+2. `ReportExportService.restoreSummaryMonthlyBlocks`锛氭柊澧� `skipFreightHistoryBlocks`锛屻�� 璐ц繍銆嬮〉 **T 鍒楀強浠ュ悗**锛�2025..2021 浜斾釜骞村害鍧� + 鍚勫勾绱鍒楋級姘镐笉浠庡浠芥瘝鐗堝洖濉� 鈥斺�� 涓庢棦鏈夈�屼腑鍙ｅ緞鎺掑悕宸﹀潡銆嶄繚鎶ゅ悓涓�鎬濊矾锛岄槻銆岀敓鎴愬張澶嶆椿銆嶃��
+
+### 21.4 7 鏈堟瘝鐗堣ˉ榻愶紙Excel COM锛�360 + 324 鏍硷級
+
+鎸� `_fix_mother.ps1`锛�8 鏈堟瘝鐗堥偅鐗堬級**鏁翠綋宸︾Щ 2 鍒�**鏀瑰啓锛�
+
+- 骞村害鍧楋細2025 `T,V,X,Z,AB,AD,AF,AH,AJ,AL,AN,AP`锛�2024 `AV..BR` 闅斿垪锛�2023 `BW..CS` 闅斿垪锛�2022 `DK..DV` 杩炵画锛�2021 `EA..EL` 杩炵画锛涙瘡鍒楀啓 `r7/r9/r8/r10 = SUM(17 甯傚窞)`銆乣r5=r7+r9`銆乣r6=r8+r10` 鈫� **360 鏍�**锛�
+- 绱鍒楋細`DX=SUM(DK:DV)`銆乣EM=SUM(EA:EL)`銆乣DY=IFERROR(DX/SUM(EA:EL)-1,"")`锛岃 5..112 鈫� **324 鏍�**锛�
+- `CalculateFullRebuild` 鍚庝繚瀛樸�傛瘝鐗� 921,559 鈫� 1,440,038 瀛楄妭锛堣浆 Excel 鍘熺敓锛夈��
+
+### 21.5 娴嬭瘯缁撴灉鎽樿
+
+| 鐢ㄤ緥 | 缁撴灉 |
+|---|---|
+| 2026-07 瀵煎嚭锛堜慨澶嶅墠锛� | FAIL锛堝鐜帮級 |
+| 鐜/璺緞鎺掗櫎锛堝皬浠躲�佷袱鏈瘝鐗堛��09-08 鏃у鍑恒�佹敼鍚嶅鍒讹級 | 鍏ㄩ儴 OK锛岀‘璁ら潪鐜闂 |
+| 淇鍚� 2026-07 瀵煎嚭 | **OK sheets=19**锛宍DX5=144979.2825`銆乣DY5=-0.101235487797891`銆乣EM5=161309.53162`銆乣CU5=173045.296428512` |
+| 淇鍚� 2026-08 瀵煎嚭 | **OK sheets=19**锛宍DZ5=144979.2825`銆乣EO5=161309.53162`銆乣CW5=173045.296428512` |
+| 璺ㄦ湀涓�鑷存�� | 7 鏈堜笌 8 鏈堢殑 2022/2021/2023 绱**瀹屽叏鐩哥瓑** |
+| 闈炴硶鏍煎鎵� | 0 涓� |
+| 2026-09 娈嬬暀澶嶆牳 | 5 寮犺〃鍏� 0 |
+
+> 娉細8 鏈堟瘝鐗堣绠楀悗 `DZ5` 鐢辨棫鐨勫啓姝诲父閲� `144979.285376043` 鍙樹负 `144979.2825`锛屽樊 0.0029 鈥斺�� 姝ｆ槸绗崄浜岃妭璁板綍鐨勩�屽叏鐪佽涓嬪父閲� 鈮� 17 甯傚窞涔嬪拰銆嶉偅绗斿樊棰濓紝灞�**淇**鑰岄潪鍥為��銆�
+
+### 21.6 韪╁潙
+
+1. **Excel COM 瀛ゅ効杩涚▼浼氳 `Workbooks.Open` 闂存瓏鎬у亣鎶ュ悓涓�涓敊**锛氭瘡渚嬫祴瀹屽繀椤诲己鏉�鏈鏂板缓鐨� `EXCEL` 杩涚▼銆傛帓鏌ュ垵鏈熷氨鍥犲鍎胯繘绋嬭鍒ゃ��8 鏈堜欢涔熸墦涓嶅紑銆嶏紝娴垂浜嗕竴杞��
+2. `CTWorksheet` **娌℃湁** `isSetSheetData()`锛坰heetData 鏄繀濉級锛岃鐢� `getSheetData() != null`銆�
+3. 姣嶇増琛ラ綈鐨勫浠芥枃浠�**涓嶈兘**鐢� `_澶囦唤_` 鍓嶇紑锛堜細琚� `resolveSummaryDonor` 褰� donor 鍥炲～锛夛紝鏈鐢� `_bak_2026骞�7鏈堥亾璺繍杈撻噺姹囨�昏〃_琛ラ綈鍓峗20260916.xlsx`銆�
+
+### 21.7 閬楃暀
+
+- 2026-06 / 2026-09 鏃犳瘝鐗� 鈫� 棰勮 `ready=False`銆屾湭鎵惧埌妯℃澘鏂囦欢銆嶏紝闇�鍏堝缓姣嶇増銆�
+- 绗� 8 妫掗仐鐣欐湭鍔細`h2031` 缂� 2025-01銆乣passenger_individual_monthly` 2026-08 缂洪粍鍐堛�乣PASSENGER_AUTH` 11 鏈熷叏 0銆�
+- 浠撳簱鏍� `_*.*`锛堝惈鏈 `_hyb_*` / `_loo_*` / `_v2_*` / `_final_*` / `_fixed_*` / `_t7_*` / `_poijar`锛夋湭鍒狅紝寰呯敤鎴峰悓鎰忋��
+
+璇﹁銆婂姛鑳芥祴璇曟姤鍛�/鍔熻兘娴嬭瘯鎶ュ憡_2026-07姣嶇増琛ラ綈涓庡鍑轰欢鎵撲笉寮�淇_2026-09-16.md銆嬨��
+
+### 21.8 鏀跺伐璁板綍锛�2026-09-16锛�
+
+- 鏈疆浠ｇ爜/鏂囨。宸� commit `80e0879`锛屽苟 **push 鍒颁釜浜� gitee `origin/master`**锛坄e29485b..80e0879`锛夈��
+- 鍏徃 gitea 浠嶄笉閫氾細`git fetch gitea` 鎸傝捣绾� 5 鍒嗛挓鏃犲搷搴旓紝宸叉寜绾﹀畾**涓嶅己鎺�**锛屽緟缃戠粶鎭㈠鍚庤ˉ鎺紙鏈湴鐜� `ahead 16`锛夈��
+- 鏀跺伐鏃剁幆澧冿細鍚庣 8090銆佸墠绔� 8080 鍧囧湪璺戯紱Excel 瀛ゅ効杩涚▼宸叉竻骞插噣锛堝彧淇濈暀鐢ㄦ埛鑷繁鐨� 18564/25868锛夈��
+- 鏈彁浜ゅ唴瀹癸紙**鏈夋剰淇濈暀锛岀瓑鐢ㄦ埛纭**锛夛細`docs/鎶曡祫/` 涓嬬殑鏃㈡湁澧炲垹锛坄X鏈堚� 鏀瑰悕绛夛紝闈炴湰杞敼鍔級銆佷粨搴撴牴 `_*.*` 鎺掓煡涓存椂鏂囦欢銆�
+- 鏄庡ぉ鍙仛锛氭柊寤� 2026-09锛堝強 2026-06锛夋瘝鐗堬紝璁� 9 鏈堟簮鏁版嵁瀵煎叆鍚庤兘鐩存帴鍑烘眹鎬诲ぇ琛紱鍏徃 gitea 琛ユ帹銆�
--
Gitblit v1.9.1