From 0acd500f0a2e2e34ff199472dd5575723afb6358 Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期日, 27 九月 2026 17:48:04 +0800
Subject: [PATCH] fix(汇总表母版): 157 格文本型数字改为数值(公交 AF/M 各68 + G 17、轨道轮渡 4)；重新生成验证仅 68 格类型变化、值不变。并记录排名页块顺序/辅助列定位

---
 docs/问题汇总/问题与注意事项汇总_2026-09-16.md |   44 ++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 44 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 7a0bd86..a4ecacb 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"
@@ -243,3 +243,47 @@
 | 12 | 姣嶇増缁� Excel 閲嶅瓨鍚庝綋绉� 959,706 -> 1,492,121 瀛楄妭锛堝鍑轰欢 950,186 -> 1,331,599锛� | 绾牸寮忓紑閿�锛屾暟鎹棤褰卞搷 | 璁板綍 |
 
 璇﹁銆婂姛鑳芥祴璇曟姤鍛�/鍔熻兘娴嬭瘯鎶ュ憡_璐ц繍椤电绱鍒椾慨澶嶄笌鑴忔湡娓呯悊_2026-09-16.md銆嬨��
+
+---
+
+## 鍗佷笁銆�2026-09-16 琛ュ厖锛�2026-07 姣嶇増琛ラ綈 & 瀵煎嚭浠躲�孍xcel 鎵撲笉寮�銆嶆牴鍥狅紙P0锛�
+
+### 13.1 鐥囩姸涓庢牴鍥�
+
+| 椤� | 鍐呭 |
+|---|---|
+| 鐥囩姸 | `GET /api/report/export/summaryWorkbook?period=2026-07&mode=month` 鐢熸垚鐨� xlsx锛�**Excel 鎵撲笉寮�**锛圕OM 鎶ャ�屼笉鑳藉彇寰楃被 Workbooks 鐨� Open 灞炴�с�嶏紱`CorruptLoad=1` 淇妯″紡鍚屾牱鎵撲笉寮�锛夛紱2026-08 鍚屾帴鍙ｆ甯� |
+| 鐩存帴鍘熷洜 | 瀵煎嚭浠堕噷鏈� **19 涓ā寮忛潪娉曟牸**锛歚<c r="E15" s="111" t="n"><v>67.0</v><is><t>67.00</t></is></c>` 鈥斺�� `t="n"` 涓嶅厑璁稿甫 `<is>`锛坕nlineStr 涓撶敤锛� |
+| 娣卞眰鍘熷洜 | 7 鏈堟瘝鐗堢敱 **openpyxl** 鍐欏嚭锛坄docProps/app.xml` = `Microsoft Excel Compatible / Openpyxl 3.1.5`锛屾枃鏈瓨 `<is>`锛夛紱8 鏈堟瘝鐗堟槸 **Excel 鍘熺敓**锛堟枃鏈蛋 sharedStrings锛夈�侾OI 鐨勯儴鍒嗗啓鍏ヨ矾寰勫彧鏀� `t`/`<v>`銆佷笉娓呮棫 `<is>` |
+| 瑙﹀彂璺緞 | 7 鏈堝瓨鍦� `_澶囦唤_2026骞�7鏈堥亾璺繍杈撻噺姹囨�昏〃_娓呯悊鍓峗20260904.xlsx` 鈫� `restoreSummaryMonthlyBlocks` 鏁存牸鍥炲～ 鈫� 寰� inlineStr 鏍奸噷鍐欏�肩暀涓嬫棫 `<is>`銆�8 鏈堟棤 `_澶囦唤_*`锛屼笉璧板洖濉紝鏁呮甯� |
+| 鍛戒腑浣嶇疆 | leave-one-out 瀹氫綅鍒� **sheet9銆婂叕浜ゃ��17 鏍� + sheet12銆婅建閬撱�佽疆娓°��2 鏍�** |
+
+### 13.2 淇锛坄traffic-audit-server`锛�
+
+1. **`exportSummaryWorkbook` 鏂板 `normalizeStaleInlineStrings(wb)`**锛氳惤鐩樺墠娓呮帀鎵�鏈夈�岄潪 `inlineStr` 鍗存畫鐣� `<is>`銆嶇殑鏍煎瓙锛堝箓绛夛級锛屽懡涓嵆鎵� warn 鏃ュ織銆�
+2. **`restoreSummaryMonthlyBlocks` 鏂板 `skipFreightHistoryBlocks`**锛氥�� 璐ц繍銆嬮〉 **T 鍒楀強浠ュ悗**锛�2025/2024/2023/2022/2021 骞村害鍧� + 鍚勫勾绱/绱鍚屾瘮鍒楋級**姘镐笉浠庡浠芥瘝鐗堝洖濉�** 鈥斺�� 涓庢棦鏈夈�屼腑鍙ｅ緞鎺掑悕宸﹀潡姘镐笉鍥炲～銆嶅悓涓�鎬濊矾锛岄伩鍏嶈ˉ榻愯銆岀敓鎴愬張澶嶆椿銆嶃��
+
+### 13.3 2026-07 姣嶇増琛ラ綈锛堝彛寰勪笌 8 鏈堟瘝鐗堝榻愶級
+
+- 骞村害鍧楋紙姣忓垪锛夛細`r7/r9/r8/r10 = SUM(17 甯傚窞瀵瑰簲琛�)`銆乣r5 = r7+r9`銆乣r6 = r8+r10` 鈫� 360 鏍硷紱
+- 绱鍒楋細`DX = SUM(DK:DV)`锛�2022锛夈�乣EM = SUM(EA:EL)`锛�2021锛屽師**鏁村垪涓虹┖**锛夈�乣DY = IFERROR(DX/SUM(EA:EL)-1,"")`锛�2022 绱鍚屾瘮锛屽師涓�**鍐欐甯搁噺**锛夆啋 324 鏍硷紱
+- 2023 绱 `CU = BW+BY+鈥�+CS` 鏈潵灏辨纭紝鏈敼锛沗EN`锛�2021 绱鍚屾瘮锛夋寜鍙ｅ緞淇濇寔涓虹┖銆�
+- 涓�鎵嬭瘉鎹細姣嶇増 `DX5=144979.2825`锛堟棫甯搁噺 `144979.285376043`锛屽樊 0.0029 = 鍏ㄧ渷瑙勪笅甯搁噺涓� 17 甯傚窞涔嬪拰鐨勫樊锛夈�乣EM5=161309.53162`銆乣CU5=173045.296428512`锛屼笌 8 鏈堟瘝鐗� `DZ5/EO5/CW5` **瀹屽叏鐩哥瓑**銆�
+- 澶囦唤锛歚docs/鐢熸垚姹囨�诲ぇ琛�/_bak_2026骞�7鏈堥亾璺繍杈撻噺姹囨�昏〃_琛ラ綈鍓峗20260916.xlsx`銆�**鍒囧嬁鏀瑰悕涓� `_澶囦唤_` 寮�澶�**锛屽惁鍒欎細琚� `resolveSummaryDonor` 褰� donor 鍥炲～銆�
+
+### 13.4 鏈鏂板鐨勬帓鏌ュ潙
+
+| 闂 | 鍘熷洜 | 澶勭疆 |
+|---|---|---|
+| Excel COM **闂存瓏鎬�**鎶ュ悓涓�涓敊锛屽鑷磋鍒ゃ��8 鏈堜欢涔熸墦涓嶅紑銆� | 姣忔 `New-Object -ComObject Excel.Application` 鐣欎笅鐨�**瀛ゅ効 EXCEL 杩涚▼**浼氭薄鏌撳悗缁疄渚� | 姣忎緥娴嬪畬鎶娿�屾湰娆℃柊寤虹殑 EXCEL 杩涚▼銆嶅己鏉�鍐嶆祴涓嬩竴渚嬶紱`Quit()`+`ReleaseComObject` 骞朵笉澶� |
+| 缂栬瘧鎶ャ�屾壘涓嶅埌 isSetSheetData()銆� | `CTWorksheet.sheetData` 鏄� XSD **蹇呭～**鍏冪礌锛屼笉鐢熸垚 `isSetXxx` | 鏀圭敤 `ctw.getSheetData() != null` |
+| 閮ㄤ欢绾� diff 澶ぇ璺戜笉鍔� | 瀵� 519KB 鐨� `styles.xml` 鐩存帴 `difflib` 鏄� O(n虏) | 鍏堟寜閮ㄤ欢姣斿瓧鑺傚昂瀵�/鏄惁鐩哥瓑锛屽彧鍦ㄥ繀瑕佺殑灏忛儴浠朵笂鍋� diff |
+
+### 13.5 閬楃暀闂澧為噺
+
+| # | 闂 | 褰卞搷 | 鐘舵�� |
+|---|---|---|---|
+| 13 | 2026-06 / 2026-09 鏃犳瘝鐗� | 棰勮 `ready=False`銆屾湭鎵惧埌妯℃澘鏂囦欢銆嶏紝鏃犳硶鍑烘暟 | 闇�鍏堝缓姣嶇増锛堢敤鎴风 5 闂殑寤朵几锛� |
+| 14 | 浠撳簱鏍� `_*.*` 涓存椂鏂囦欢缁х画澧炲锛坄_hyb_*` / `_loo_*` / `_v2_*` / `_final_*` / `_fixed_*` / `_t7_*` / `_poijar`锛� | 浣撶Н/鍙鎬� | 缁忕敤鎴峰悓鎰忓悗鍐嶆竻鐞� |
+
+> 绗� 10 椤癸紙2026-07 瀵煎嚭浠跺皯 2 鍒� / 7 鏈堟瘝鐗堟槸銆�1-4 鏈堥鏋躲�嶏級鏈妭宸插鐞嗭細瀵煎嚭绔細**鑷姩琛ュ嚭 5/6/7 鏈堣〃澶翠笌鍏紡**骞堕噸绠楃疮璁″叕寮忥紝姣嶇増宸茶ˉ榻� 2021/2022/2023 绱鍒楋紝鏁呭叧闂椤广��

--
Gitblit v1.9.1