From 06b1cb706387c3bc2ab7f6a525c26f9dd22a3bb4 Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期二, 22 九月 2026 14:16:37 +0800
Subject: [PATCH] docs(交接): 同步同事进展并修正仓库约定（P1-1 闭环标注提交号、单仓库、索引补差异报告）

---
 docs/工作日结/工作日结_2026-09-16.md |   71 +++++++++++++++++++++++++++++++++++
 1 files changed, 71 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 196259b..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"
@@ -309,3 +309,74 @@
 - 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