From ae47753f77690615762a77bde38a34e9ff0fa4ae Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期一, 12 十月 2026 17:12:24 +0800
Subject: [PATCH] feat(汇总大表): 缺数清单可见且缺数期不沿用上一期旧值（排名页按源侧留空）（待验收）
---
docs/汇总大表M0版式重建器规格_2026-10-06.md | 180 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 178 insertions(+), 2 deletions(-)
diff --git "a/docs/\346\261\207\346\200\273\345\244\247\350\241\250M0\347\211\210\345\274\217\351\207\215\345\273\272\345\231\250\350\247\204\346\240\274_2026-10-06.md" "b/docs/\346\261\207\346\200\273\345\244\247\350\241\250M0\347\211\210\345\274\217\351\207\215\345\273\272\345\231\250\350\247\204\346\240\274_2026-10-06.md"
index 6e4a14f..353de6d 100644
--- "a/docs/\346\261\207\346\200\273\345\244\247\350\241\250M0\347\211\210\345\274\217\351\207\215\345\273\272\345\231\250\350\247\204\346\240\274_2026-10-06.md"
+++ "b/docs/\346\261\207\346\200\273\345\244\247\350\241\250M0\347\211\210\345\274\217\351\207\215\345\273\272\345\231\250\350\247\204\346\240\274_2026-10-06.md"
@@ -99,8 +99,184 @@
## 鍗併�侀闄╀笌寰呯‘璁�
1. **寰呯‘璁わ細浠ュ摢鏈綔鎵╁垪钃濇湰銆�** 寤鸿浠ョ敤鎴锋墜宸ョ殑 9 鏈堟瘝鐗堜负鍑嗭紙鐗堝紡宸茬敱鐢ㄦ埛鍥哄寲锛夈��
-2. **寰呯‘璁わ細鏄惁涓�娆″缓鎴� 12 鏈堟弧鐗堝紡銆�** 鏂规 v1 寤鸿婊＄増寮忋�佸悗缁湀浠藉彧鍋氥�岄殣钘�/缃伆鏈埌鏈堜唤 + 绱閲嶇畻 + 濉綋鏈堛�嶏紝鍙樉钁楅檷浣庡悗缁闄╋紱鑻ュ潥鎸侀�愭湀鎻掑叆锛屽鏉傚害涓庡洖褰掓垚鏈洿楂樸��
+2. ~~寰呯‘璁わ細鏄惁涓�娆″缓鎴� 12 鏈堟弧鐗堝紡銆倊~ **宸茶瀹氾紙2026-10-09锛夛細閲囩敤 F10銆屾寜鏈堟寜闇�鎵╁垪銆嶃�佷笉棰勭暀绌哄垪锛涙湰椤逛綔搴燂紝瑙佺鍗佷笁/鍗佸洓鑺傘��**
3. **姣嶇増鍘嗗彶鍧戣涓�骞惰鐩�**锛氭瘝鐗堢敱 openpyxl 鍐欏嚭锛屽瓨鍦ㄩ珮鍘嬬缉锛堝凡鐢� `ZipSecureFile.setMinInflateRatio` 缁曡繃锛変笌娈嬬暀 `<is>` 闈炴硶鏍硷紙`normalizeStaleInlineStrings` 娓呯悊锛変袱绫婚棶棰橈紝閫愬垪鍏嬮殕鏃堕渶淇濇寔杩欎袱澶勫鐞嗐��
4. **鍩庡競瀹㈣繍椤靛弬鐓х粍鏄帇缂╃粨鏋�**锛堝悓姣� + 1-X 鏈堢疮璁★級锛屼笌鍏跺畠闀胯〃椤典笉鍚岋紝闇�鍗曠嫭瑙勫垯銆�
5. **璺ㄥ勾寮�鏂版湰锛�2027锛変笉鍦� M0 鑼冨洿**锛岄渶鍙﹀畾"鏂板勾鍧�"瑙勫垯銆�
-6. **鏈鐩栭〉**锛氫腑鍙ｅ緞鍒嗘瀽绛� 3 涓潤鎬侀〉浠嶆部鐢ㄦ瘝鐗堥潤鎬佸唴瀹癸紝鏈樁娈典笉鏀广��
\ No newline at end of file
+6. **鏈鐩栭〉**锛氫腑鍙ｅ緞鍒嗘瀽绛� 3 涓潤鎬侀〉浠嶆部鐢ㄦ瘝鐗堥潤鎬佸唴瀹癸紝鏈樁娈典笉鏀广��
+## 鍗佷竴銆佸弬鐓у悓浜嬨�屼笓椤圭粺璁°�嶇殑璁捐鏄犲皠涓庤惤鍦拌矾绾匡紙2026-10-08锛�
+
+### 11.1 瀵归綈琛細浠栦负浠�涔堣兘涓�涓瘝鐗堬紝鎴戜滑瀵瑰簲鎬庝箞鍋�
+
+| 鍚屼簨涓撻」缁熻鐨勫仛娉� | 浠栦负浠�涔堣兘鎴愮珛 | 姹囨�诲ぇ琛ㄧ殑瀵瑰簲鍋氭硶 |
+|---|---|---|
+| 涓�浠芥瘝鐗堬紙`2026骞村崄涓�鏁版嵁.xlsx`锛夛紝**澶╀负琛屻�佸勾涓哄垪** | 澧為暱缁村害鏄�屽勾銆嶏紝涓�骞村姞涓�缁勫垪锛涘ぉ鏁板浐瀹� 8 | 鎸� **F10**銆屾寜鏈堟寜闇�鎵╁垪銆嶏細璇� N 鏈堟瘝鐗堣嚜鍔ㄤ骇鍑� N+1 鏈堢増寮忥紙涓嶉鐣欑┖鍒楋級锛屾瘝鐗堝彧褰撶増寮忔潵婧� |
+| 姣嶇増鍚屾椂鏄暟鎹鍣紙鍘嗗彶骞翠唤鐨勫�煎氨鍦ㄥ苟鎺掑勾鍒楅噷锛� | 鍘嗗彶鍊奸殢妯℃澘涓�璧疯蛋 | **鍙嶈繃鏉ュ仛**锛氬巻鍙插弬鐓у�煎叆搴擄紝姣嶇増鍙暀鐗堝紡锛屽弬鐓х粍鐢� DB 鍥炲～ |
+| 琛ㄥご/琛屾爣绛捐涔夊畾浣嶏紙`findYearColumn` / `parseDayIndex`锛� | 鍒楀簭鍙樹簡涔熻兘瀵� | 鏂板椤佃鍒欒〃 `SummarySheetRule`锛氭寜琛ㄥご璁ゆ湀浠界粍銆佹寜琛屾爣绛捐甯傚窞/鎸囨爣锛屼笉鐢ㄧ‖缂栫爜鍒楅敋鐐� |
+| 鏄撴紓绉诲彛寰勫缃垚琛紙`holiday_calendar` / `passenger_coefficient` / `vehicle_adjustment`锛� | 瑙勫垯涓嶆暎鍦ㄤ唬鐮佷笌鍗曞厓鏍奸噷 | 鍙傜収骞翠繚鐣欑粍鏁般�佹帓鍚嶅彛寰勶紙鍏ㄧ渷涓嶆帓鍚嶏級銆佸懆杞噺绯绘暟 B=G+L/2+Q/10銆佺己鏁扮疆绌鸿鍒� 澶栫疆 |
+| `DECIMAL(30,15)` + `BigDecimal` + 鎸� Excel 鏄剧ず绮惧害鍙栧�� | 绮惧害鍙ｅ緞缁熶竴锛屾棤娴偣灏惧樊 | 鎵挎帴闀挎湡寰呭姙銆�16 寮犺〃 228 涓� double 鍒楁敼 DECIMAL + BigDecimal銆� |
+| 瀵煎叆涓ら樁娈电‘璁� + 鍏ㄧ▼鍙鏍稿 | 鍘嗗彶鏁版嵁涓嶈璇鐩� | 鐢熸垚鍓嶅厛鍑虹己鏁�/宸紓娓呭崟锛屼汉宸ョ‘璁ゅ悗鍐嶅嚭琛紙鐜版湁 B4 鍩烘暟浣撴琛ラ綈锛� |
+| 杈撳嚭璧版ā鏉挎枃浠讹紙docx / PNG锛� | 鐗堝紡鏉ユ簮鍗曚竴 | 淇濈暀鐜版湁鍋氭硶锛堝揩鎶ユ敼 `word/document.xml`銆丣FreeChart 鍑� PNG锛� |
+
+### 11.2 钀藉湴璺嚎锛堝洓闃舵锛�
+
+- **闃舵 1锛�= M0锛�3.5鈥�5 澶╋級**锛氬疄鐜�**鎸夋湀鎸夐渶鎵╁垪鍣�**锛堣 N 鏈堟瘝鐗� 鈫� 浜у嚭 N+1 鏈堢増寮忥紝涓嶉鐣欑┖鍒楋級锛� 椤佃鍒欒〃锛堝榻� F10 / D1锛夈��
+ 鏂板 `SummaryLayoutRebuilder` / `SummarySheetRule` / 鍗曟祴銆�
+ 鍑哄彛锛�7 鏈堝洖褰� diff=0锛�9 鏈堝鐓ф墜宸ョ増 diff=0锛�10 鏈堣捣鍙洿鎺ュ嚭琛ㄣ��
+- **闃舵 2锛�+1鈥�2 澶╋級**锛氭妸鐜版湁涓変唤鏂囦欢渚濊禆鍚堝苟涓轰竴浠姐��
+ 鐜扮姸渚濊禆锛氭湀搴︽瘝鐗堬紙`resolveSummaryMother`锛�+ `_澶囦唤_` donor锛坄resolveSummaryDonor` / `restoreSummaryMonthlyBlocks`锛�+ 鐗堝紡鍙傜収浠讹紙`resolveSummaryLayoutRef`锛夈��
+ 鐩爣锛氬彧鐣欍�婇亾璺繍杈撻噺姹囨�昏〃_鏍囧噯姣嶇増.xlsx銆嬶紝鍙傜収鍊间粠搴撳洖濉紝鍋滅敤 donor 涓庤繕鍘熸満鍒躲��
+ 鍑哄彛锛歚docs/鐢熸垚姹囨�诲ぇ琛�/` 涓嬪彧鍓� 1 涓ā鏉挎枃浠� + 杈撳嚭鐩綍锛坄_bak_*` 绛夋湰鍦扮暀瀛樸�佷笉鍏ュ簱锛夈��
+- **闃舵 3锛堝彲閫夛紝+2鈥�3 澶╋級**锛氭瘝鐗堝唴鐢ㄥ懡鍚嶅尯鍩�/鍗犱綅绗︽爣娉ㄩ渶濉牸锛岀▼搴忔寜鍚嶅～鍐欙紱姣嶇増琚尓鍒�/鎻掕鏃舵槑纭姤閿欍��
+- **闃舵 4锛堝彲閫夛紝+5鈥�10 澶╋級**锛氭妸 10 涓暱琛ㄩ〉鐨勭増寮忓弬鏁板寲锛堝垪缁勮鍒� + 鍚堝苟鍖� + 鍒楀 + 鏁板瓧鏍煎紡 + 鎵撳嵃鍖猴級锛岀▼搴忎粠鐗堝紡瀹氫箟娓叉煋锛屾瘝鐗堟枃浠堕檷绾т负涓�娆℃�ф牱寮忔彁鍙栨簮锛�
+ 3 涓殣钘忓叕寮忛〉锛堜腑鍙ｅ緞璁＄畻杩囩▼ / 2025骞村煄甯傚杩愰噺 / 涓彛寰勫垎鏋愶級淇濈暀鏂囦欢褰㈡�併��
+
+### 11.3 涓ゆ潯涓嶇収鎼�
+
+1. **涓嶆妸 Excel 褰撴暟鎹簮**锛氬悓浜嬮偅杈逛笟鍔℃瘡澶╁～鍚屼竴褰㈢姸鐨� Excel 鏂囦欢锛涙眹鎬诲ぇ琛ㄦ暟鎹繀椤昏蛋 DB 瀵煎叆 + 涓ら樁娈电‘璁わ紝涓嶈兘閫�鍥�"鎵嬪伐濉瘝鐗�"銆�
+2. **蹇呴』鏈夈�屾柊骞寸粍銆嶉�昏緫**锛氫粬鐨勫ぉ鏁版槸甯告暟锛�8 澶╋級锛岃法骞村彧鏄姞涓�缁勫勾鍒楋紱鎴戜滑璺ㄥ勾瑕佹柊澧炰笅涓�骞村害鍒楃粍骞舵妸褰撳勾缁勯檷绾т负鍙傜収缁勶紝杩欎竴姝ヤ粬娌℃湁瀵瑰簲瀹炵幇銆�
+
+### 11.4 搴曠嚎涓庨闄�
+
+- 3 涓殣钘忓叕寮忛〉渚濊禆姣嶇増鐜版垚鍏紡锛岄樁娈� 1鈥�2 蹇呴』鍘熸牱淇濈暀锛岄樁娈� 4 鎵嶈皥閲嶅缓銆�
+- 鎵撳嵃鍖恒�侀〉鐪夐〉鑴氥�佹潯浠舵牸寮忋�佸垪瀹藉繀椤婚�愰〉鏍稿锛屾槸"鑲夌溂鐗堝紡"鏈�鏄撴紡鐨勭偣銆�
+- 涓氬姟鏀规寚鏍囪/椤电/杈规灞炰簬闇�姹傚彉鏇达紝浠讳綍鏂规閮借涓�娆￠�傞厤锛涙湰鏂规鎶婇鐜囦粠銆屾瘡鏈堜竴娆°�嶉檷鍒般�屽伓灏斾竴娆°�嶃��
+- 姣嶇増鏀逛负鍙锛屽彲椤哄甫瑙勯伩 WPS/openpyxl 閲嶅瓨甯︽潵鐨勯珮鍘嬬缉涓庢畫鐣� `<is>` 闈炴硶鏍间袱绫诲巻鍙插潙銆�
+## 鍗佷簩銆佸瓨鍌ㄥ眰/灞曠ず灞傜害瀹氾細鍙傜収鍚屼簨銆屼簩缁磋〃銆嶆ā寮忥紙2026-10-09锛�
+
+### 12.1 涓夊眰鑱岃矗
+
+- **瀛樺偍灞傦紙DB锛�**锛氫竴寮犲紶浜岀淮琛紝閿笌鍊兼槑纭紱瀛樹笁绫诲唴瀹光�斺�斿師濮嬪�笺�侀厤缃�笺�佷汉宸ヨ皟鏁村�笺��
+- **璁＄畻灞�**锛氬鍑烘椂鎸夊彛寰勮绠楋紙绱銆佸悓姣斻�佺幆姣斻�佸崰姣斻�佹帓鍚嶏級銆�
+- **灞曠ず灞傦紙Excel锛�**锛氬彧鎶婂�煎拰鍏紡鎸夌増寮忔憜鍑烘潵锛屼笉鎵挎媴瀛樺偍鑱岃矗銆�
+
+### 12.2 銆屼竴琛ㄤ竴绮掑害銆嶇害瀹氾紙绀轰緥鍙栬嚜鍚屼簨鐨勪笓椤圭粺璁★級
+
+| 琛� | 涓婚敭锛堢矑搴︼級 | 鍊� | 绫诲埆 |
+|---|---|---|---|
+| holiday_passenger_flow | 骞� + 鏃ユ湡 + 杩愯緭鏂瑰紡 | 瀹㈣繍閲� | 鍘熷鍊� |
+| holiday_vehicle_flow | 骞� + 鏃ユ湡 + 閬撹矾绫诲埆 + 杞﹀瀷 | 杞︽祦閲忋�佺幆姣斿熀鏈� | 鍘熷鍊� |
+| holiday_calendar | 骞� + 鑺傚亣鏃ョ被鍨� + 绗嚑鏃� | 鏃ユ湡 | 閰嶇疆鍊� |
+| holiday_passenger_coefficient | 骞� + 鏃ユ湡绫诲埆 | 瀹㈣繍绯绘暟 | 閰嶇疆鍊� |
+| holiday_vehicle_adjustment | 骞� + 鏃ユ湡 | 璋冩暣鍚庡�� + 鍘熷洜 | 浜哄伐璋冩暣鍊� |
+
+鎴戜滑鐜版湁瀵煎叆琛ㄥ悓鏍锋弧瓒宠绾﹀畾锛歚city_bus_monthly`锛堟姤琛ㄦ湡 + 鍦板尯 + 浼佷笟锛夈�乣city_taxi_monthly`锛堟姤琛ㄦ湡 + 鍦板尯锛夈�乣freight_turnover_import`锛堟姤琛ㄦ湡 + 鍦板尯锛夈�乣scale_split_transport`锛堟姤琛ㄦ湡 + 鍦板尯 + 鏈�/绱锛夈�乣h2031_enterprise_monthly`锛堟姤琛ㄦ湡 + 浼佷笟锛夈�乣h2032_enterprise_monthly`銆乣wyc_order_monthly` / `wyc_total_monthly`銆乣passenger_individual_monthly`銆傚瓨鍌ㄥ眰褰㈡�佹槸瀵圭殑銆�
+
+### 12.3 浜哄伐璋冩暣鍊间竴寰嬪崟鐙缓琛紙瑕嗙洊灞傦級
+
+- 妯″紡锛�**鍘熷璁板綍涓嶅姩**锛屽彟琛ㄥ瓨銆岃鐩栧�� + 鍘熷洜 + 鏃堕棿銆嶏紝鍞竴閿笌鎵�瑕嗙洊瀵硅薄涓�鑷达紙鍙傜収鍚屼簨鐨� `holiday_vehicle_adjustment`锛夈��
+- 鎴戜滑鐨勯�傜敤瀵硅薄锛�2025 鍙傜収鍊间慨姝ｃ�佸紓甯哥珯鍓旈櫎銆佷笟鍔′复鏃舵敼鏁扮瓑銆�
+
+### 12.4 鐜扮姸鏍搁獙锛�2026-10-09 瀹炴祴锛屼慨姝ｆ棭鏈熷垽鏂級
+
+瀹炴祴搴� `127.0.0.1:3308 / traffic_audit`锛圡ySQL 8.0.29锛夛細
+
+| 琛� | 2025 鏈堜唤鏁� | 缁撹 |
+|---|---|---|
+| city_bus_monthly | 12/12 | 榻愬叏 |
+| city_taxi_monthly | 12/12 | 榻愬叏 |
+| wyc_order_monthly / wyc_total_monthly | 12/12 | 榻愬叏 |
+| h2031_enterprise_monthly / h2032_enterprise_monthly | 12/12 | 榻愬叏 |
+| passenger_individual_monthly | 12/12 | 榻愬叏 |
+| freight_turnover_import | 1/12锛堜粎 2025-12锛� | **涓嶆瀯鎴愮己鍙�**锛氳〃甯� `last_freight_m01..m12` / `last_turnover_m01..m12`锛�2026 鍚勬湡鏂囦欢鑷甫鍘诲勾鍚屾湀鍊� |
+| scale_split_transport | 0/12 | **涓嶆瀯鎴愮己鍙�**锛氳〃甯� `above/below/total_yoy`锛屽悓姣斿凡闅� 2026 鍚勬湡鍏ュ簱 |
+
+- 鏃╂湡"搴撻噷娌℃湁 2025 骞村煄甯傚杩愭暟鎹�"鐨勬敞閲婁笌鎻愮ず鏂囨锛坄ReportExportService.java:499 / 558 / 561`锛�**宸茶繃鏈�**锛岃Е鍙戞潯浠朵笉鍐嶆垚绔嬶紱鍚屾瘮鍙栨暟璧扮殑鏄簱鍐呭幓骞村悓鏈燂紙`aggOf(data, year-1, m, "婀栧寳鐪�")`锛岀害 540 琛岋級銆�
+- **鐪熸閬楃暀鐨勬槸鍙ｅ緞闂锛屼笉鏄己鏁版嵁**锛氫腑鍙ｅ緞鎺掑悕/鏄庣粏鐨� 2025 鍒椾粛浠�**姣嶇増闈欐�佸畾绋垮��**涓哄噯锛坄readMidDetailLastYearCumulative`锛宍ReportExportService.java:2745` 璧凤級锛屼唬鐮佹敞閲婏紙2686-2689 琛岋級璇存槑鍘熷洜鈥斺��"鎺掑悕椤靛師鍏堟煡搴撶幇绠楋紝涓よ�呭湪 **2025-03/04 缃戠害杞︽媶鍒�**涓婁笉鍚�"銆�
+- 澶勭疆锛�**2026-10-09 淇**锛夛細璇�"寰呯‘璁�"鍒ゆ柇鏈夎鈥斺�斿悓姣斿熀鍑嗗凡鍦� 2026-09-07 鎷嶆澘涓恒��**姣嶇増缂撳瓨浼樺厛锛屽簱浠呬綔鏍￠獙**銆嶏紙`docs/瑕佹眰涓庨獙鏀跺熀绾挎竻鍗�.md` F8銆佺‘璁ゅ洖鎵� Q1锛夛紱搴撳唴 2025 鐜扮畻鍊�**涓嶅緱**鐩存帴鏇夸唬姣嶇増闈欐�佸畾绋垮�硷紝浠呭綋浜哄伐鏍稿骞堕噸瀵间竴鑷村悗鎵嶅垏搴撳�笺�傝瑙佺鍗佷笁鑺傘��
+
+### 12.5 缁撴灉灞傦紙姣斿悓浜嬫洿杩涗竴姝ワ紝鍙�夛級
+
+- 鍚屼簨搴撻噷**涓嶅瓨璁＄畻缁撴灉**锛氱疮璁°�佸悓姣斻�佸崰姣斻�佺幆姣斿潎瀵煎嚭鏃剁畻锛孍xcel 鍐呰〃鐜颁负鍏紡銆�
+- 鎴戜滑鍙�夊鍔犱竴寮犵粨鏋滆〃锛岀矑搴� = 鏈熼棿 + 椤� + 鎸囨爣 + 甯傚窞 + 褰撴湀/绱锛汣alc 鍐欏叆銆丗iller 璇诲彇銆�
+- 鏀剁泭锛氬皬琛ㄤ笌璺ㄩ〉鍚堟垚椤靛叡鐢ㄤ竴濂楃粨鏋滐紱閫愭牸 diff 鏃惰兘鐩存帴鍖哄垎銆岀畻閿欍�嶈繕鏄�屽～閿欍�嶃��
+- 绾﹀畾锛氭寜鏈熼棿**骞傜瓑閲嶇畻**锛堝厛鍒犺鏈熼棿鍐嶆彃锛夛紱鏄剧ず鍙栨暣涓嶄笅娌夊埌搴擄紝鍙湪灞曠ず灞傝垗鍏ャ��
+
+### 12.6 鑷绾緥锛堢孩绾匡級
+
+> **姣嶇増閲屼笉鍏佽瀛樺湪銆屽彧鏈夊畠鎵嶆湁鐨勬暟鎹�嶃��**
+
+鍒ゅ畾鏂规硶锛氭妸姣嶇増鎵�鏈夊�兼竻绌哄悗锛岀▼搴忚兘鍚﹂噸鏂扮敓鎴愪竴寮犲畬鍏ㄤ竴鑷寸殑琛紵鑳� 鈫� 鏁版嵁閮藉湪搴擄紱涓嶈兘 鈫� 杩樻湁鏁版嵁钘忓湪 Excel 閲岋紝缁х画寰�搴撻噷鎼��
+
+### 12.7 涓� M0 鐨勫叧绯伙紙渚濊禆椤哄簭锛�
+
+- 12.4 鐨勫彛寰勬牳瀵逛笉闃诲 M0 闃舵 1锛堢増寮忛噸寤猴級銆�
+- M0 闃舵 2銆屽仠鐢� `_澶囦唤_` donor 杩樺師銆嶇殑鏁版嵁鍓嶆彁**宸插熀鏈弧瓒�**锛�2025 宸插湪搴擄級锛涗絾浠嶉渶鍏堝叧闂� 12.4 鐨勫樊寮傦紝鍚﹀垯鍒囨崲鍙栨暟鏉ユ簮浼氳鏁板瓧鍙樺姩銆佹棤娉曢�氳繃 diff=0 鍥炲綊銆�
+## 鍗佷笁銆佹棦鏈夋媿鏉挎牳楠岋紙2026-10-09 鏌ヨ瘉锛夆�斺�旀湰鑺備紭鍏堢骇楂樹簬鍓嶈堪鍚勮妭锛屽啿绐佷互鏈妭涓哄噯
+
+### 13.1 鍚屾瘮鍩哄噯锛氫互姣嶇増缂撳瓨涓哄噯锛堝凡纭锛屼笉鏄緟瀹氶」锛�
+
+| 鍑哄 | 鍘熸枃瑕佺偣 | 鐘舵�� |
+|---|---|---|
+| `docs/瑕佹眰涓庨獙鏀跺熀绾挎竻鍗�.md` F8 | 2025 骞村墠鏁版嵁浠ユ瘝鐗堢紦瀛樹负鍑嗭紱**姣嶇増缂撳瓨浼樺厛浣滃悓姣斿熀鍑嗭紝搴撳彧鍋氭牎楠�**锛屼汉宸ユ牳瀵归噸瀵间竴鑷村悗鎵嶅垏搴撳�硷紙Q1锛� | 鉁� 鍙ｅ緞纭 |
+| `docs/纭鍥炴墽姹囨�讳笌鍓╀綑鐤戦棶_姹囨�诲ぇ琛ㄦ暟鎹┍鍔ㄦ敼閫燺2026-09-07.md` Q1 | 浠ユ瘝鐗堢紦瀛樹负鍚屾瘮鍩哄噯骞朵粎鎻愮ず锛涘緟浜哄伐鏍稿鍚庨噸瀵间竴鑷村啀鍒囨崲涓哄簱鍊硷紙"姣嶇増缂撳瓨浼樺厛锛屽簱浠呬綔鏍￠獙鍙傝��"锛� | 宸茬‘璁� |
+| `docs/姹囨�诲ぇ琛ㄦ暟鎹┍鍔ㄦ敼閫犳柟妗坃2026-09-07.md` 绗節鑺� | 2025 瀹氱鏁版嵁"鍓嶅彴瀵煎叆鏍￠獙"鍙︾珛浠诲姟锛�**鏈湡鍚屾瘮涓�寰嬩互姣嶇増缂撳瓨涓哄熀鍑�** | 鈥� |
+| `docs/寰呯‘璁姹囨�诲ぇ琛ㄦ暟鎹┍鍔ㄦ敼閫犻棶棰樻竻鍗昣2026-09-07.md` A1 | 2025 鍙婁互鍓嶅巻鍙插垪涓�寰�**淇濈暀姣嶇増缂撳瓨銆佷笉閲嶇畻** | 鈥� |
+| `docs/闂姹囨��/姹囨�诲ぇ琛ㄩ棶棰樹氦鎺2026-09-21.md` 鏂规 A | 涓彛寰勬帓鍚嶅彇鍘诲勾鍚屾湡绱鏀圭敤姣嶇増 2025 闈欐�佸垪锛堜笌涓彛寰勬槑缁嗗悓婧愶級锛屽凡瀹炴柦 | 宸插疄鏂� |
+
+缁撹锛�**搴撳唴 2025 鐜扮畻鍊间笉鑳界洿鎺ユ浛浠ｆ瘝鐗� 2025 闈欐�佸畾绋垮��**锛涘垏鎹㈢殑鍞竴鍓嶆彁鏄�"浜哄伐鏍稿骞堕噸瀵间竴鑷�"銆傜鍗佷簩鑺� 12.4 涓�"浜や笟鍔＄‘璁や互鍝竟涓哄噯"鐨勮〃杩版嵁姝や慨姝ｏ紙瑙佽鑺� 2026-10-09 淇琛岋級銆�
+
+### 13.2 鎵╁垪鏂瑰紡锛氭寜鏈堟寜闇�锛堝凡鎷嶆澘锛夆�斺�斾笌鏈枃妗�"婊＄増寮�"寤鸿鍐茬獊
+
+| 鍑哄 | 鍘熸枃瑕佺偣 | 鐘舵�� |
+|---|---|---|
+| `docs/瑕佹眰涓庨獙鏀跺熀绾挎竻鍗�.md` F10 | **鎵╁垪鎸夋湀鎸夐渶锛堝姞鏈堜唤鎵嶆墿鍒楋紝涓嶉鍋� 12 鏈堟弧鐗堬級**锛涙柊澧炲垪"褰撴湀/鍚屾瘮"鏍囬涓轰袱琛屽悎骞跺崟鍏冩牸锛屾墿鍒楅』淇濈暀 | 鉁� M0 v4 |
+| `docs/姹囨�诲ぇ琛ㄦ暟鎹┍鍔ㄦ敼閫犳柟妗坃2026-09-07.md` v1.1 淇锛�2026-09-08 鐢ㄦ埛鎷嶆澘锛� | 姝ｆ枃"12 鏈堟弧鐗堝垪鐗堝紡"寤鸿**浣滃簾**锛涙墿鍒楁寜"姣忔湀闇�澧炴湀浠芥椂鍐嶆墿鍒�"鎵ц锛�=D1 鍘熷彛寰勶級 | 宸叉媿鏉� |
+
+鈫� **宸茶瀹氾紙2026-10-09 鐢ㄦ埛纭锛�**锛氭部鐢ㄦ棦鏈夊彛寰� F10銆屾寜鏈堟寜闇�銆嶏紝鏈枃妗ｇ涔�/鍗佷竴鑺傜殑"婊＄増寮�"寤鸿**浣滃簾**锛堜笂鏂囧凡灏卞湴鏍囨敞锛夈��
+
+### 13.3 宸叉湁鐨� 09-29 鎵╁垪宸ヤ綔浜х墿锛堟湰鍦版湭鍏ュ簱锛沗docs/闂姹囨��/_*.md` 宸茶 gitignore 鍛戒腑锛�
+
+- `docs/闂姹囨��/_鎵╁垪瑙勬牸琛╛2026-09-29.md` / `.csv`锛�19 椤甸�愰〉瑙勬牸鈥斺�旂被鍨嬶紙A 鏈堜唤瀵�+绱 / B 閮ㄥ垎鏈堜唤瀵� / C 鏈瘑鍒湀浠藉锛夈�佸悇椤垫湀浠藉鍒椾綅銆佺疮璁″垪銆佸缓璁彃鍏ヤ綅缃�佹暟鎹鑼冨洿銆佹爣棰樺啓娉曘��
+- `docs/闂姹囨��/_鎵╁垪閰嶇疆鍒濈_20260929.md` / `.csv`銆乣_鎵╁垪璁″垝_v3..v10.json`锛氶厤缃笌璁″垝杩唬锛坴10 浠呭墿 `杞ㄩ亾銆佽疆娓 涓�椤碉級銆�
+- `docs/闂姹囨��/_鎵╁垪杩涘害_20260929.md`锛�8 鏈堚啋9 鏈堟墿鍒楄繘搴︹�斺��8 椤靛凡鎻掑垪锛�6 椤瑰緟淇紙琛ㄥご鏄剧ず/鍚堝苟鍖�/绱鍙埌 8 鏈堜笖澶氬啓 +Q/绱鍚屾瘮鍘诲勾鍩烘暟鍙埌 8 鏈�/鏍囬鏈堜唤鏈� +1/杞ㄩ亾杞浮闇�鎸夊潡鍒嗗埆鎻掑垪锛夛紱鑻ュ共椤垫彃鍏ヤ綅缃緟纭銆�
+- 璇曞仛浠� `docs/鐢熸垚姹囨�诲ぇ琛�/2026骞�9鏈堥亾璺繍杈撻噺姹囨�昏〃_璇曞仛_20260929.xlsx`锛堢粨鏋勫彲鐪嬨�佹暟鍊兼湭淇畬锛屽嬁鐢ㄤ簬鍑鸿〃锛夈��
+
+鈫� 鏈鏍煎簲涓庝笂杩颁骇鐗╁榻愭帹杩涳紝涓嶅啀鍙﹁璁捐銆�
+
+### 13.4 姣嶇増缁存姢鐩爣锛堟棦鏈夊彛寰勶級
+
+- `docs/寰呯‘璁姹囨�诲ぇ琛ㄦ暟鎹┍鍔ㄦ敼閫犻棶棰樻竻鍗昣2026-09-07.md` A4锛�**"绋冲畾鍚庢瘝鐗堝彧褰撶増寮忔ā鏉匡紝鏈堝害鏁版嵁涓�寰嬬▼搴忓～"**鈥斺�斾笌鏈枃妗ｇ洰鏍囦竴鑷淬��
+## 鍗佸洓銆佹渶缁堟墽琛屽彛寰勶紙2026-10-09 鐢ㄦ埛纭锛屽彇浠ｅ墠杩板啿绐佽〃杩帮級
+
+**鍋氭硶**锛氭湰娆″彧鍋氫竴浠朵簨鈥斺��**鎶�"鎵╁垪"鍙樻垚绋嬪簭鐨勫父瑙勮兘鍔�**锛屽叾浣欏凡纭鍙ｅ緞涓�寰嬩笉鍔ㄣ��
+
+| # | 鍔ㄤ綔 | 渚濇嵁 |
+|---|---|---|
+| 1 | 瀹炵幇**鎸夋湀鎸夐渶鎵╁垪鍣�**锛氳 N 鏈堟瘝鐗� 鈫� 鍏嬮殕 N+1 鏈�"鍊煎垪+鍚屾瘮鍒�"涓�瀵� 鈫� 绱鍒楀悗绉� 鈫� 鏄惧紡閲嶅啓绱/绱鍚屾瘮 鈫� 鍚屾琛ㄥご锛堜袱琛岀旱鍚戝悎骞舵爣棰橈級涓庨〉闈㈡爣棰� 鈫� 杈撳嚭锛�**鍙埌褰撴湀銆佷笉棰勭暀绌哄垪**锛夛紱鍚屾椂鎶婄粨鏋滆惤鐩樹负涓嬫湡姣嶇増 | F10 / D1 / D2 / 纭鍥炴墽鍏�.4 |
+| 2 | 涓夋潯蹇呮敼鐐瑰仛鍏細鈶� 鏂版湀浠藉悓姣斿叕寮忥紱鈶� 绱鍒楁灇涓捐ˉ褰撴湀锛涒憿 **鎻掑垪鍙充晶 2025/2024/2023 鍘嗗彶鍖哄嚑鍗冩潯鍏紡寮曠敤 +2** | 09-21 浜ゆ帴 搂5.2 |
+| 3 | **鍏堜慨涓ゅ鍐欐鐨勫垪浣嶇疆**锛歚SM_CUR_COL0=2`锛�2026骞�1鏈�=C锛夈�乣SM_LAST_COL0=21`锛�2025骞�1鏈�=V锛夋敼涓�**鎸夎〃澶村姩鎬佸畾浣�**锛涘惁鍒� 2025 鍧椾竴鍙崇Щ锛屽洓寮犺法椤靛悎鎴愰〉浼氳閿欏幓骞村熀鏁� | `docs/姹囨�诲ぇ琛ㄦ瘝鐗堟墿鍒楅厤缃垵绋縚2026-09-29.md` 绗簲鑺� |
+| 4 | 绱鍚屾瘮鍒嗘瘝**鎸夎〃澶村畾浣�"鍘诲勾 M 鏈�"鍒�**閲嶅啓鍏紡锛堝彧绱姞濂囨暟鍒楋級锛屼笉鍐欐鍒楁竻鍗曪紱鐗堝紡瀵归綈鏀逛负鎸夎〃澶存枃瀛楀尮閰嶅垪 | C3 / C4锛�09-18 闀挎晥鏂规锛� |
+| 5 | **鍚屾瘮鍩哄噯涓嶅姩**锛�2025 鍒楀師鏍蜂繚鐣欙紱搴撳彧鍋氭牎楠岋紙B4 鍩烘暟浣撴鍙綔鏍￠獙浣嶏級锛�**涓嶅垏搴撳��**锛沗_澶囦唤_` donor 杩樺師鍏堜繚鐣欎綔鍥炲綊瀵圭収 | F8 / Q1 / A3 / 09-21 鏂规 A |
+| 6 | 姣忛〉瑙勫垯鐢ㄩ厤缃拤姝汇�佷笉闈犺嚜鍔ㄨ瘑鍒紱璇嗗埆涓嶄簡鐨勯〉璺宠繃骞舵姤鍛� | 閰嶇疆鍒濈 搂鍏�.3 |
+
+**楠屾敹锛堟部鐢ㄦ棦鏈� E1 / 搂5.4锛�**
+
+1. 7 鏈堟瘝鐗堟墿鍑� 8 鏈� 鈫� 涓庣湡瀹炪��2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx銆嬮�愭牸 diff=0锛�
+2. 8 鏈堟瘝鐗堟墿鍑� 9 鏈� 鈫� 涓庣敤鎴锋墜宸ャ��2026骞�9鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx銆媎iff=0锛坄_璇曞仛_20260929.xlsx` 鍙綔缁撴瀯鍙傝�冿紝涓嶄綔鏁板�肩湡鍊硷級锛�
+3. 鑷锛歚#REF!`=0銆�8 鏈堝強浠ュ墠鍒楅�愭牸鏈彉銆佺疮璁�=1~M 鏈堛�佺疮璁″悓姣斿惈 2025 骞寸 M 鏈堛�佷袱琛屽悎骞舵爣棰樹繚鐣欍�侀敊璇�间笉澧炪��
+
+**瑙勬牸鏉ユ簮锛�2026-10-09 鐢辨湰鍦拌繃绋嬩骇鐗╄浆姝ｅ叆搴擄級**
+
+- `docs/姹囨�诲ぇ琛ㄦ瘝鐗堟墿鍒楄鏍糭2026-09-29.md` / `.csv` 鈥斺�� 19 椤甸�愰〉瑙勬牸锛圓/B/C 绫诲瀷銆佹湀浠藉鍒椾綅銆佺疮璁″垪銆佹彃鍏ヤ綅缃�佹暟鎹鑼冨洿銆佹爣棰橈級
+- `docs/姹囨�诲ぇ琛ㄦ瘝鐗堟墿鍒楅厤缃垵绋縚2026-09-29.md` 鈥斺�� 閫愰〉鍒椾綅閰嶇疆 + 纭墠鎻愶紙鍐欐鍒椾綅缃級+ 寤鸿鏂规
+
+**宸插畾锛�2026-10-09 鐢ㄦ埛纭锛�**
+
+- **鎵╁垪鏂瑰紡锛氱▼搴忔墿鍒�**锛�09-28/09-29 宸查�夛紝2026-10-09 鐢ㄦ埛鍐嶆纭锛夈�傗殸锔� 瀛楁瘝闄烽槺锛�09-21 浜ゆ帴 搂5.3 鐨�"鏂规 B锛滶xcel 灏忓伐鍏�"涓� 09-28/09-29 宸ヤ綔鏃ョ粨鐨�"鏂规 B锛濇墿鍒楀櫒"**瀛楁瘝鐩稿弽**锛屽悗缁粺涓�鍐�"**鎵╁垪鍣紙绋嬪簭锛�**"锛屼笉鍐嶄娇鐢� A/B 瀛楁瘝銆�
+- **鎵╁垪鑼冨洿 = 8 涓彲瑙佸彴璐﹂〉**锛歚 璐ц繍`銆乣鐝嚎鍖呰溅`銆乣鍩庡競瀹㈣繍`銆乣鍏氦`銆乣鍑虹`銆乣缃戠害杞銆乣杞ㄩ亾銆佽疆娓銆乣涓彛寰勬槑缁哷銆�
+- **4 涓殣钘忛〉淇濈暀骞剁户缁殣钘忋�佷笉绾冲叆鏁版嵁鍔犲伐**锛歚鍏矾鎬诲杩恅銆乣2025骞村煄甯傚杩愰噺`銆乣涓彛寰勫杩愰噺`銆乣涓彛寰勮绠楄繃绋媊锛堢敤鎴� 2026-10-09 鎷嶆澘锛涗緷鎹� 09-03銆婅嚜鍔ㄧ敓鎴愭眹鎬诲伐浣滅翱钀藉湴鏂规銆嬄�1锛夈��**涓嶆彃鍒椼�佷笉鏀瑰叕寮�**锛堢嫭绔� sheet锛屽埆鐨勯〉鎻掑垪涓嶄細甯﹂敊瀹冧滑锛夈�傛湰鎷嶆澘鍚屾椂娑堣В 09-29 瑙勬牸琛ㄦ妸 `涓彛寰勫杩愰噺` 鏍囦负 A 绫汇�侀厤缃垵绋挎爣涓�"鏃� 2026 鏈堜唤瀵�"鐨勭煕鐩俱��
+- C 绫�**鍙**椤典笉鎵╁垪锛歚鍩庡競姹囨�籤/`鍩庡競鍒嗗競宸瀈/`涓彛寰勫垎鏋恅/`閬撹矾杩愯緭鍛ㄨ浆閲廯 鐢辩▼搴忓埛鏂帮紙`refreshSummaryCumulativeSheets`锛夛紱`璐ц繍閲忔帓鍚峘/`璐ц繍鍛ㄨ浆閲忔帓鍚峘/`涓彛寰勬帓鍚峘 鎸夋ā鏉垮～鏁般��
+- 姣嶇増瀹為檯鏋勬垚瀹炴祴锛�2026-10-09锛夛細**15 涓彲瑙侀〉绛� + 4 涓殣钘忛〉绛�**锛圶ML `state="hidden"`锛岄潪 veryHidden锛屽彸閿爣绛惧彲鍙栨秷闅愯棌锛夈��
+
+**钀界洏涓庢枃浠剁鐞嗭紙2026-10-09 鐢ㄦ埛纭锛涢潪寰呯‘璁ら」锛�**
+
+- 钀界洏锛氭墿鍒椾骇鐗�**鍏堣惤 `docs/鐢熸垚姹囨�诲ぇ琛�/杈撳嚭/`**锛堝懡鍚� `_鎵╁垪_YYYY骞碝鏈坃寰呯‘璁�.xlsx`锛夛紝**浜哄伐纭鍚�**鎵嶉噸鍛藉悕钀界洏涓哄綋鏈熸瘝鐗� `{骞磢骞磠鏈坿鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx`銆�
+- 鐩綍鍙繚鐣�**褰撴湡涓�鏈瘝鐗�**锛涘巻鍙叉湡绉诲叆 `docs/鐢熸垚姹囨�诲ぇ琛�/褰掓。/`锛沗2026骞�8鏈堚�鐗堝紡鍘熷瀷.xlsx` 涓�骞跺綊妗ｃ��
+- 鐗堝紡鍙傜収浠� `鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃.xlsx`锛�**鎵╁垪鍣ㄨ窇閫氬悗褰掓。**锛涘綊妗ｅ墠瀹屾垚 C4 涓ゆ鈥斺�斺憼 鎶婂弬鐓т欢鐨勫垪瀹�/闅愯棌涓�娆℃�у浐鍖栬繘褰撴湡姣嶇増锛涒憽 `applySummaryReferenceLayout`锛坄:3785`锛夋敼鎸�**琛ㄥご鏂囧瓧鍖归厤鍒�**锛堢幇涓烘寜鍒楀簭鍙凤紝涓�鎻掑垪鍗抽敊浣嶏級銆�
+- `_澶囦唤_*` / `_bak_*`锛氭寜 A3 淇濈暀鍒板洖褰掗獙璇侀�氳繃鍚庡啀娓呯悊銆�
+
+**瀹炴柦瑕佺偣锛堝疄娴嬪緱鍑猴紝闈炲喅绛栭」锛�**
+
+- 姣嶇増 vs 鍙傜収浠跺疄娴嬪樊寮傦細**鍒楀 320 澶勩�侀殣钘忔爣璁� 31 澶�**涓嶅悓锛坄 璐ц繍` 77+8銆佺彮绾垮寘杞� 109銆佷腑鍙ｅ緞鏄庣粏 32+14銆佷腑鍙ｅ緞鎺掑悕 17+9 绛夛級鈫� 鍥哄寲涓嶆槸绌烘搷浣溿��
+- `copyColumnWidth`锛坄ReportExportService.java:1186`锛�**鍙鍒跺搴︺�佷笉澶嶅埗 hidden** 鈫� 鎵╁垪鍣ㄥ厠闅嗘湀浠藉垪鏃堕』琛� hidden锛屽惁鍒欐柊鍒楁案杩滆闈犲弬鐓т欢琛ョ増寮忋��
\ No newline at end of file
--
Gitblit v1.9.1