From ceaa5f2895b71b9dedfe543ae3a0927f912556ab Mon Sep 17 00:00:00 2001
From: xyc <jc_xiong@hotmail.com>
Date: 星期一, 21 九月 2026 17:28:35 +0800
Subject: [PATCH] docs: 仓库约定改为只用公司 gitea 单仓库（AGENTS 第3/4条）

---
 docs/问题汇总/汇总大表问题交接_2026-09-21.md |  256 +++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 256 insertions(+), 0 deletions(-)

diff --git "a/docs/\351\227\256\351\242\230\346\261\207\346\200\273/\346\261\207\346\200\273\345\244\247\350\241\250\351\227\256\351\242\230\344\272\244\346\216\245_2026-09-21.md" "b/docs/\351\227\256\351\242\230\346\261\207\346\200\273/\346\261\207\346\200\273\345\244\247\350\241\250\351\227\256\351\242\230\344\272\244\346\216\245_2026-09-21.md"
new file mode 100644
index 0000000..38cdcc2
--- /dev/null
+++ "b/docs/\351\227\256\351\242\230\346\261\207\346\200\273/\346\261\207\346\200\273\345\244\247\350\241\250\351\227\256\351\242\230\344\272\244\346\216\245_2026-09-21.md"
@@ -0,0 +1,256 @@
+# 姹囨�诲ぇ琛紙閬撹矾杩愯緭閲忔眹鎬昏〃锛夐棶棰樹氦鎺ヨ鏄�
+
+> 浜ゆ帴鏃ユ湡锛�2026-09-21銆�浜ゆ帴浜猴細閮戠帀娲併��鎺ユ墜浜猴細寰呭畾
+> 鑼冨洿锛氭姤琛ㄧ敓鎴� 鈫� 姹囨�诲ぇ琛紙`鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃.xlsx`锛�19 涓〉绛撅級涓�閿敓鎴愬姛鑳藉強鍏跺叏閮ㄩ仐鐣欓棶棰�
+> 鏈枃鍙啓銆屾帴鎵嬩汉鍔ㄦ墜鍓嶅繀椤荤煡閬撶殑浜嬨�嶏紝鍔熻兘鍏ㄨ矊瑙佺 1 鑺傚垪鐨勫墠缃枃妗ｃ��
+
+## 0. 涓�鍙ヨ瘽鐜扮姸
+
+8 鏈堟眹鎬诲ぇ琛ㄥ凡鑳藉仛鍒般�屽鍏ュ熀纭�鏁版嵁 鈫� 涓�閿敓鎴愩�嶏紝涓庝汉宸ユ瘝鐗堥�愭牸姣斿鍩烘湰涓�鑷淬�備絾鏈変袱涓珮鍗遍仐鐣欙細
+
+1. ~~**鍘嗗彶鍚屾湡锛�2025 骞达級鍒楀湪涓ゅ鍙ｅ緞涔嬮棿娌℃湁缁熶竴** 鈥斺�� 銆屼腑鍙ｅ緞鎺掑悕銆嶉〉涓庛�屼腑鍙ｅ緞鏄庣粏銆嶉〉鐨勭疮璁″悓姣斿涓嶄笂锛堥粍鍐� 7.74% vs 7.64%锛夛紝**杩欐槸绗竴浼樺厛闂**銆倊~ **宸蹭簬 2026-09-21 鎸夋柟妗� A 瑙ｅ喅锛岃绗� 4 绔犮��**
+2. **姣忔湀瑕佷汉宸ュ噯澶囦竴浠芥柊姣嶇増**锛岀▼搴忎笉浼氳嚜宸辨墿鍒楋紝9 鏈堝強浠ュ悗涓嶈В鍐冲氨浼氬崱浣忓嚭琛ㄣ��
+
+## 1. 鍓嶇疆闃呰锛堝厛鐪嬭繖 5 浠斤紝绾� 30 鍒嗛挓寤虹珛姒傚康锛�
+
+| 鏂囨。 | 浣滅敤 |
+| --- | --- |
+| `docs/鐢熸垚姹囨�诲ぇ琛�/杈撳叆杈撳嚭涓庨�昏緫鍏崇郴鎬昏〃_2026-09-03.md` | 姣忎釜椤电鐨勮緭鍏ャ�佽緭鍑恒�佸彇鏁版潵婧� |
+| `docs/鐢熸垚姹囨�诲ぇ琛�/椤电閫昏緫鍏崇郴璇存槑.md` | 椤电涔嬮棿鐨勫叕寮忎緷璧栧叧绯� |
+| `docs/姹囨�诲ぇ琛ㄦ暟鎹┍鍔ㄦ敼閫犳柟妗坃2026-09-07.md` | 鏁版嵁椹卞姩鏀归�犵殑鏁翠綋璁捐 |
+| `docs/闂姹囨��/姹囨�昏〃闂姹囨�籣2026-09-17.md` | 绗竴鎵癸紙8 鏈堢┖鐧�/鎺掑悕涓嶅锛夌殑闂涓庢牴鍥� |
+| `docs/闂姹囨��/姹囨�昏〃涓夋潯涓荤嚎淇鏂规_2026-09-18.md` | 銆屽叕寮忎笉閲嶇畻銆嶄富绾跨殑淇鏂规 |
+
+瀵瑰/瀵瑰悓浜嬭В閲婄敤锛歚D:\妗岄潰\鎶ヨ〃鐢熸垚鍘熺悊璇存槑_2026-09-20.md`銆乣D:\妗岄潰\绯荤粺瀹炵幇姹囨�昏鏄巁2026-09-20.md`銆�
+
+## 2. 鐢熸垚鍘熺悊閫熻锛�6 姝ワ級
+
+鍏ュ彛锛氬墠绔� `traffic-audit-web/src/views/ReportExport.vue`锛堟姤琛ㄧ敓鎴愰〉鍕鹃�夈�屾眹鎬诲ぇ琛ㄣ�嶏級鈫� 鍚庣 `ReportExportController` 鈫� `ReportExportTaskService`锛堝紓姝ヤ换鍔� + 杩涘害 + 10 鍒嗛挓鍐呭瓨缂撳瓨锛夆啋 `ReportExportService.exportSummaryWorkbook()`锛坄ReportExportService.java:3522`锛夈��
+
+1. **鎵炬瘝鐗�**锛歚resolveSummaryMother()`锛�:4464锛夊湪 `docs/鐢熸垚姹囨�诲ぇ琛�/` 涓嬫寜鏂囦欢鍚� `{yyyy}骞磠M}鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx` **绮剧‘鏌ユ壘**锛屾壘涓嶅埌鐩存帴鎶ャ�屾湭鎵惧埌妯℃澘鏂囦欢銆嶃�傛瘝鐗�**涓嶅叆搴撱�佷笉闅忕▼搴忓垎鍙�**銆�
+2. **鍥炲～鍙拌处椤靛綋鏈堝��**锛歚SummaryWorkbookFiller.fillMonthlyLedger()`锛坄SummaryWorkbookFiller.java:54`锛夊洖濉� 6 寮犲彴璐﹂〉 鈥斺�� 鐝嚎鍖呰溅/鍏氦/鍑虹锛坄fillCityRows()`锛屽啓 1~褰撴湀鍏ㄦ湀锛夈�佽建閬撹疆娓°�佽揣杩愩�佺綉绾﹁溅锛堝悗涓よ��**鍙啓褰撴湀**锛屽巻鍙叉湀娌跨敤姣嶇増锛夈��
+3. **琛ラ綈鍏紡**锛歚ensureMonthFormulas()`锛�:432锛�+ `ensureMonthYoyFormulas()`锛�:549锛夋寜鏈堟妸銆屽綋鏈堝��/鍚屾瘮/绱銆嶅叕寮忓彸绉伙紱`repairCumulativeYoyFormulas()`锛�:777锛変慨绱鍚屾瘮鍒嗘瘝銆�
+4. **鐜扮畻鎴愬搧椤�**锛歚refreshSummaryCumulativeSheets()`锛�:3984锛夐噸绠� 鍩庡競姹囨�� / 鍩庡競鍒嗗競宸� / 涓彛寰勫垎鏋� / 閬撹矾杩愯緭鍛ㄨ浆閲� 鍥涢〉銆�
+5. **鎼�兼帓鍚嶉〉**锛歚refreshSummaryRankSheets()`锛�:3753锛夆啋 `copyRankValues()`锛�:3766锛夋妸 `exportFreightRank / exportTurnoverRank / exportPassengerMidRank` 涓変釜鐙珛鐢熸垚鍣ㄧ殑缁撴灉鎷疯繘 璐ц繍閲忔帓鍚� / 璐ц繍鍛ㄨ浆閲忔帓鍚� / 涓彛寰勬帓鍚嶃��
+6. **鏀跺熬**锛歚applyTwoDecimalFormat()`锛堝叏绮惧害瀛樺偍 + 鏄剧ず涓や綅灏忔暟锛夆啋 `recalcWorkbookFormulas()`锛�:3601锛宍evaluateAll` 鍐欏洖缂撳瓨鍊硷級鈫� `fullCalcOnLoad=true` 鈫� 杈撳嚭銆�
+
+> **鍏抽敭璁ょ煡**锛氭瘝鐗堟湰韬氨鏄叕寮忛┍鍔ㄧ殑銆傚叏鐪佽 = 危17 甯傚窞锛涘煄甯傚杩� / 涓彛寰勬槑缁� = 璺ㄨ〃寮曠敤锛堝 `鍩庡競瀹㈣繍!C9 = =鍏氦!C16+鍑虹!C16+缃戠害杞�!C16+'杞ㄩ亾銆佽疆娓�'!C9`锛夈�傛墍浠ヨ繖涓ら〉**涓嶉渶瑕佸崟鐙啓鏁�**锛屽彧瑕佸叕寮忔寜鏈堣ˉ榻� + 閲嶇畻鍗冲彲銆�
+
+## 3. 闂鎬昏
+
+| 缂栧彿 | 闂 | 鐘舵�� | 浼樺厛绾� |
+| --- | --- | --- | --- |
+| P0-1 | 鍘嗗彶鍚屾瘮鍩烘暟銆屽弻杞ㄥ埗銆嶏細涓彛寰勬帓鍚� vs 涓彛寰勬槑缁� 绱鍚屾瘮鍏ㄥ競宸炰笉涓�鑷� | **宸茶В鍐筹紙2026-09-21锛屾柟妗� A锛�** | 楂� |
+| P0-2 | 姣嶇増渚濊禆锛氭瘡鏈堣浜哄伐鍑嗗鏂版瘝鐗堬紝绋嬪簭涓嶄細鑷繁鎵╁垪 | **鏈В鍐�** | 楂� |
+| P1-1 | 鍩庡競瀹㈣繍椤� AJ 鍒楋紙2025骞�1-7鏈堢疮璁★級娈嬬暀鍦ㄧ敓鎴愯〃 | 宸蹭慨澶� 09-20 | - |
+| P1-2 | 涓彛寰勬帓鍚嶅懆杞噺鍙ｅ緞涓庝汉宸ュ垪涓嶄竴鑷� | 宸蹭慨澶� 09-19 | - |
+| P1-3 | 涓彛寰勬帓鍚嶅悓姣斾笌鍩庡競瀹㈣繍鍒楅敊浣� | 宸蹭慨澶� 09-18 | - |
+| P1-4 | 鍏紡鍐欎簡浣嗘棤缂撳瓨鍊硷紝棰勮/浜屾澶勭悊鐪嬪埌鏃у�� | 宸蹭慨澶� 09-18 | - |
+| P2-1 | 瀵煎嚭鍓嶅熀鏁颁綋妫� + 寮圭獥 +銆婃暟鎹己澶辨竻鍗曘�嬮〉锛圔4锛� | 寰呮帓鏈� | 涓� |
+| P2-2 | 澧為�熸帓鍚嶆帾杈烇紙D 缁勶級 | 寰呮帓鏈� | 浣� |
+| P2-3 | 涓彛寰勬槑缁� 4 鏍� `#DIV/0!`锛�2025 骞� 8 鏈堝熀鏁颁负 0锛� | 寰呬笟鍔＄‘璁� | 浣� |
+| P2-4 | 缂烘瘝鐗堟彁绀烘湭瀹炴祴锛涢儴缃插寘鍐呮槸甯� AJ 鍒楃殑鏃ф瘝鐗� | 寰呭鐞� | 浣� |
+
+## 4. P0-1 鍘嗗彶鍚屾瘮鍩烘暟銆屽弻杞ㄥ埗銆嶏紙鏈浜ゆ帴閲嶇偣锛�
+
+> **鐘舵�佹洿鏂帮紙2026-09-21锛夛細鐢ㄦ埛閲囩敤鏂规 A锛屽凡瀹炴柦骞跺洖褰掗�氳繃銆�** 鎺掑悕椤电殑 2025 绱鍩烘暟鏀硅姣嶇増銆婁腑鍙ｅ緞鏄庣粏銆嬮潤鎬佸垪锛涢粍鍐� 1-8 鏈堢疮璁″悓姣旂敱 7.744917% 淇涓� 7.641733%锛屼笌鏄庣粏椤典竴鑷淬��
+
+### 4.1 鐜拌薄
+
+`D:\妗岄潰\鐢熸垚鏁版嵁\鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃 (3).xlsx`锛�2026-09-20 14:42 鐢熸垚锛夛細
+
+- 銆屼腑鍙ｅ緞鎺掑悕銆峂13 榛勫唸 1-8 鏈堢疮璁″悓姣� = **7.744917%**
+- 銆屼腑鍙ｅ緞鏄庣粏銆峊55 鍚屼竴鏍� = **7.641733%**
+- 涓ら〉褰撴湀绱鍊煎畬鍏ㄧ浉鍚岋紙`3480.930066022`锛夛紝宸殑鍙槸**鍘诲勾鍚屾湡鍩烘暟**锛氭帓鍚嶉〉 `3230.713965` vs 鏄庣粏椤� `3233.810859`锛屽樊 `3.096894`銆�
+
+### 4.2 鏍瑰洜锛氫袱椤电殑鍘诲勾鍚屾湡鍩烘暟鏉ユ簮涓嶅悓
+
+| 椤电 | 鍘诲勾鍚屾湡锛�2025锛夋�庝箞鏉ョ殑 | 浠ｇ爜浣嶇疆 |
+| --- | --- | --- |
+| 涓彛寰勬帓鍚� | **鏌ュ簱鐜扮畻**锛屽洓涓淮搴﹀叏閮ㄧ幇绠楋紙鍚綉绾﹁溅鎷嗗垎锛� | `loadMidClassMap()` `ReportExportService.java:2441`锛涚綉绾﹁溅缁村害 :2531锛涘悓姣� `midCumYoy()` :2404 |
+| 涓彛寰勬槑缁� | 2025 鍒楀湪姣嶇増閲屾槸**鍐欐鐨勯潤鎬佹暟鍊硷紙鏃犲叕寮忥級**锛岀▼搴忎笉閲嶇畻 | 鐢熸垚浠躲�屼腑鍙ｅ緞鏄庣粏銆峍/X/Z鈥J 鍒楋紱`fillMonthlyLedger()` 涓嶅啓 2025 鍒� |
+
+### 4.3 宸紓瀹氫綅锛堝凡閫愬眰楠岃瘉鍒板崟鍏冩牸锛�
+
+1. 鍥涗釜缁村害鍒嗗埆姣斿 2025 骞� 1-8 鏈堬細鐝嚎+涓綋銆佸煄闄呭煄涔″叕浜ゃ�佸煄闄呭煄涔″贰娓稿嚭绉� **鍏ㄩ儴閫愪綅涓�鑷�**锛涘彧鏈�**鍩庨檯鍩庝埂缃戠害杞�**涓�缁翠笉鍚屻��
+2. 璇ョ淮鍙湁 **2025 骞� 3銆�4 鏈�**涓嶅悓锛堝叾浣� 6 涓湀閫愪綅涓�鑷达級锛�
+
+| | 姣嶇増闈欐�佸�� | 搴撶幇绠� | 宸� |
+| --- | --- | --- | --- |
+| 2025-03 榛勫唸 | 5.203089147 | 3.938965484 | 1.264123663 |
+| 2025-04 榛勫唸 | 6.585331252 | 4.752560757 | 1.832770495 |
+| 鍚堣 | 56.317159454 | 53.220265295 | **3.096894158** |
+
+   涓庝袱椤靛熀鏁板樊 `3.096894` 瀹屽叏鍚诲悎銆�
+
+3. 鐢�**姣嶇増鑷繁鐨勫嚭绉熷垪**锛堜笌搴撻�愭牸涓�鑷达級+ 璁㈠崟 + pin 濂楃幇绠楁硶澶嶇畻锛�**1/2/5/6/7/8 鏈堥�愪綅澶嶇幇锛堝亸宸� 0.000000000锛�**锛�3/4 鏈堝鐜颁笉鍑烘潵 鈫� 绠楁硶娌￠棶棰橈紝鏄偅涓ゆ牸鍙︽湁鏉ユ簮銆�
+
+### 4.4 閭ｄ袱鏍煎埌搴曟槸浠�涔堬紙閲嶈锛岄伩鍏嶆帴鎵嬪悗璧板集璺級
+
+- 姣嶇増锛堝惈 **9/8 绋嬪簭灏氭湭鏀瑰姩鍓嶇殑鍘熷姣嶇増** `docs/鐢熸垚姹囨�诲ぇ琛�/_bak_202608姣嶇増淇敼鍓峗20260916/2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx`锛夐噷锛岃繖涓ゆ牸**鏈潵灏辨槸** `5.203089147` / `6.585331252` 鈥斺�� 涓嶆槸绋嬪簭绠楀嚭鏉ョ殑锛屾槸鐪侀噷鎻愪緵鐨勬ā鏉胯嚜甯︾殑銆�
+- **涓嶆槸 9/16 鍑虹琛ュ綍瀵艰嚧鐨�**锛�9/8 鍘熷姣嶇増鐨勫嚭绉熷垪锛�417.01/404.51銆�410.7/398.38锛夊氨宸茬粡鍜岀幇鍦ㄥ簱閲屼竴妯′竴鏍枫��
+- 鍙嶆帹杩欎袱鏍奸殣鍚殑杈撳叆锛堝墠鎻愬凡楠岃瘉锛氭瘝鐗� 17 甯傚窞銆屽煄甯傚唴銆嶅姞鎬� = `2504.28` = 鍏ㄧ渷 pin 鍩庡競鍐咃紝鍒嗘涓嶅樊锛屾姹夎嚜鐣� 鈫� **鍒嗘憡瑙勫垯涓庣幇绠楁硶瀹屽叏鐩稿悓**锛夛細
+
+| 甯傚窞 | 鐜板簱鍑虹鍩庡競鍐� | 鍙嶆帹褰撴椂鍊� | 宸� |
+| --- | --- | --- | --- |
+| 鑽嗗窞 | 755.90 | 714.52 | -41.38 |
+| 鎭╂柦 | 496.19 | 461.54 | -34.65 |
+| **榛勫唸** | **404.51** | **378.38** | **-26.13** |
+| 鍗佸牥 | 339.59 | 319.28 | -20.31 |
+| 瀹滄槍 | 649.59 | 651.86 | +2.27 |
+
+   锛�2025-04 鍚岄噺绾э細鑽嗗窞 -43.71銆侀粍鍐� -28.11銆佹仼鏂� -27.20鈥︼級
+
+- **缁撹**锛氭瘝鐗� 2025 骞� 3銆�4 鏈堢殑缃戠害杞︽媶鍒嗭紝鏄敤**鍙︿竴浠姐�屽贰娓稿嚭绉熷煄甯傚唴瀹㈣繍閲忋��**锛�16 涓競宸為噷 15 涓兘姣旂幇鍦ㄤ綆锛夌畻鍑烘潵鐨勶紝鑰屾瘝鐗�/搴撻噷鍚屼竴寮犺〃鐨勫嚭绉熷垪鍗存槸璋冩暣鍚庣殑鍊� 鈥斺�� **姣嶇増杩欎袱鍒楄嚜鐩哥煕鐩�**銆�9/16 鍑虹鍏ュ簱鍚庯紝鎺掑悕椤典竴鐜扮畻锛岀煕鐩炬墠绗竴娆℃樉鎬у寲銆�
+
+### 4.5 褰卞搷闈�
+
+- **涓嶅彧榛勫唸**锛氶櫎姝︽眽锛堢綉绾﹁溅鍩庡競鍐呭崰姣� = 100%锛屼笉鍙備笌鍒嗘憡锛夊锛�**16 涓競宸炲叏閮芥湁宸�**銆�
+
+| 甯傚窞 | 鍚屾瘮宸�(鐧惧垎鐐�) | 甯傚窞 | 鍚屾瘮宸�(鐧惧垎鐐�) |
+| --- | --- | --- | --- |
+| 瀹滄槍 | +0.5476 | 鑽嗗窞 | -0.3187 |
+| 鍗佸牥 | -0.3529 | 閯傚窞 | -0.2986 |
+| 榛勫唸 | -0.1032 | 鑽嗛棬 | -0.2524 |
+| 鎭╂柦 | -0.1342 | 榛勭煶 | +0.0914 |
+| 瀛濇劅 | -0.0662 | 鍜稿畞 | -0.0526 |
+| 闅忓窞 | -0.0349 | 瑗勯槼 | -0.0352 |
+| 浠欐 | -0.0020 | 娼滄睙 | -0.0174 |
+| 澶╅棬 | -0.0236 | 绁炲啘鏋� | -0.0031 |
+
+- **鍏ㄧ渷琛屼袱椤靛畬鍏ㄤ竴鑷�**锛�31528.0607 / 5.810558%锛夛紝鍥犱负杩欐槸**甯傚窞涔嬮棿鐨勫垎鎽婂樊寮�**锛屽叏鐪佸姞鎬荤浉浜掓姷娑堛��
+
+### 4.6 澶勭疆鏂规锛�2026-09-21锛氭柟妗� A 宸插疄鏂斤級
+
+**瀹炴柦缁撴灉**锛歚exportPassengerMidRank()` 鍦ㄦ眹鎬诲鍑轰腑澶嶇敤鍐呭瓨姣嶇増锛屽湪鐙珛鎺掑悕琛ㄥ鍑轰腑鎵撳紑瀵瑰簲姣嶇増锛屾寜琛ㄥご璇诲彇銆婁腑鍙ｅ緞鏄庣粏銆�2025 骞淬�屾�诲杩愰噺銆嶃�屾�绘梾瀹㈠懆杞噺銆�1..N 鏈堥潤鎬佸�硷紱鍏ㄧ渷鍩烘暟鐢� 17 甯傚窞姹傚拰銆傞潤鎬佸垪涓嶅畬鏁存椂鑷姩鍥為��鍘熷簱鍐呯幇绠楀苟鍐� WARN 鏃ュ織銆�
+
+鍥炲綊璇佹嵁锛�2026-08 姹囨�诲ぇ琛ㄩ粍鍐堝杩愰噺绱鍚屾瘮鎺掑悕/鏄庣粏鍧囦负 `7.641733%`锛�17 甯傚窞 脳 瀹㈣繍閲�/鍛ㄨ浆閲忕殑绱鍊间笌绱鍚屾瘮鍏� 68 涓暟鍊煎鍏ㄩ儴涓�鑷达紝鏈�澶х粷瀵瑰樊 `2.91e-11`锛涘綋鏈堝悓姣� 34 涓暟鍊煎鏈�澶у樊 `5.48e-15`銆傝瑙併�婂姛鑳芥祴璇曟姤鍛奯涓彛寰勬帓鍚嶅悓姣斿熀鏁版柟妗圓_2026-09-21.md銆嬨��
+
+- **鏂规 A锛堟帹鑽愶紝鏀瑰姩灏忥級**锛氳 `exportPassengerMidRank()` 鍙栥�屽幓骞村悓鏈熺疮璁°�嶆椂锛屾敼鐢ㄦ瘝鐗堥偅浠� 2025 闈欐�佸垪锛堜笌涓彛寰勬槑缁嗗悓婧愶級銆�
+  - 鐞嗙敱锛氬澶栧彂甯冪殑鍚屾瘮锛屽熀鏁版湰璇ョ敤鍘诲勾瀹氱鍊硷紱鍙姩鎺掑悕椤� `midCumYoy/midCumClass` 鐨勫彇鏁版潵婧愶紝2026 褰撴湀鍊间笉鍙楀奖鍝嶃��
+  - 瑕佺偣锛氭妸姣嶇増 2025 鍒楄鎴愬唴瀛樻槧灏勶紙鎸夈�屽競宸�+鎸囨爣+鏈堛�嶏級渚涙帓鍚嶉〉鍙栫敤锛涙垨鐩存帴璁╂帓鍚嶉〉鍚屾瘮鏍兼敼鎴愬紩鐢ㄤ腑鍙ｅ緞鏄庣粏椤电殑鍏紡銆�
+- **鏂规 B**锛氭妸涓彛寰勬槑缁� 2025 鍒椾篃鏀规垚搴撳唴鐜扮畻锛屼袱椤甸兘鐢ㄥ簱銆�
+  - 浠ｄ环锛氫細鏀瑰姩**鎵�鏈夊凡瀹氱鐨� 2025 鍩烘暟**锛屽繀椤荤渷灞�纭銆�
+- **闄勫甫寤鸿**锛氬姞涓�鏉″鍑烘牎楠� 鈥斺�� 涓ら〉鍚屽煄鍚屾湀鍩烘暟涓嶄竴鑷村氨鍐欒繘 `problems`锛圔4 浣撴宸叉湁妗嗘灦锛岃 P2-1锛夈��
+
+### 4.7 鍥炲綊楠岃瘉鏂规硶锛堟敼瀹屽繀椤昏窇锛�
+
+1. 鐢熸垚 2026-08 姹囨�昏〃锛�
+2. 瀵� 17 甯傚窞 脳 瀹㈣繍閲�/鍛ㄨ浆閲忥紝閫愭牸姣斿銆屼腑鍙ｅ緞鎺掑悕銆嶄笌銆屼腑鍙ｅ緞鏄庣粏銆嶇殑绱鍚屾瘮锛岃姹�**鍏ㄩ儴涓�鑷�**锛�
+3. 鍙嶅悜鏍￠獙鍏ㄧ渷琛屼粛绛変簬 危17 甯傚窞銆佷笖鍏ㄧ渷鍚屾瘮涓ら〉涓�鑷达紱
+4. 椤哄甫纭 2026 骞� 1-8 鏈堝悇鏈堝綋鏈堝悓姣斾袱椤典粛涓�鑷达紙褰撳墠鏄竴鑷寸殑锛屽埆鏀瑰潖锛夈��
+
+## 5. P0-2 姣嶇増渚濊禆涓庛�屾瘡鏈堟崲姣嶇増銆�
+
+### 5.1 鐜扮姸鏈哄埗
+
+- 姣嶇増鐩綍 `docs/鐢熸垚姹囨�诲ぇ琛�/`锛屽悎娉曟枃浠跺悕鍙湁 `{yyyy}骞磠M}鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx` 涓�绉嶏紙`resolveSummaryMother()` :4464锛夈��
+- 绋嬪簭**鍙寜鏂囦欢鍚嶇簿纭尮閰�**锛屾壘涓嶅埌鍗虫姤銆屾湭鎵惧埌妯℃澘鏂囦欢銆嶏紝**涓嶄細鑷繁寤烘ā鏉�**銆�
+- 鍙︽湁 `_澶囦唤_` 鍓嶇紑鐨勫巻鍙插悓鏈熸瘝鐗堣繕鍘熼�昏緫锛坄resolveSummaryDonor`锛夊拰涓�鎵� `_bak_` 澶囦唤鏂囦欢锛�**鍒贡鍒�**銆�
+
+### 5.2 鐥涚偣
+
+- 瑕佸嚭 9 鏈堣〃锛屽氨蹇呴』浜哄伐鍏堝仛涓�浠姐��2026骞�9鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx銆嬫斁杩涙瘝鐗堢洰褰曪紱鐢ㄦ埛鏄庣‘琛ㄧず銆岃繖鏍峰緢楹荤儲銆嶃��
+- 姣忓姞涓�涓湀瑕佸姩鐨勫湴鏂癸紙缁忔牳瀹炲彧鏈� 3 澶勶級锛�
+  1. 鏂版湀浠藉垪鐨勫悓姣斿叕寮忥紙`=Q{row}/AJ{row}-1` 杩欑被锛屽彸绉� 2 鍒楋級锛�
+  2. 绱鍒楃殑鏋氫妇瑕佽ˉ褰撴湀锛堝 `SUM(V,X,Z,AB,AD,AF,AH,AJ)` 鈫� 鍐嶈ˉ AL锛夛紱
+  3. **鎻掑垪鍙充晶鐨� 2025/2024/2023 涓夊潡鍘嗗彶鍖哄強鍏跺嚑鍗冩潯鍏紡寮曠敤闇�瑕� +2** 鈥斺�� POI 涓嶄細鍍� Excel 閭ｆ牱鑷姩鏀瑰啓寮曠敤锛屽繀椤荤▼搴忔樉寮忓钩绉汇��
+
+### 5.3 鏂规锛堝緟鎷嶆澘锛�
+
+- **鏂规 A锛堢▼搴忚嚜鍔ㄦ墿鍒楋級**锛氶璁� 2-3 澶┿�傜涓�姝ュ彧鍋氥�屾墿鍒楀櫒 + 鐢� 7 鏈堟瘝鐗堟墿鍑� 8 鏈堛�佷笌鐪熷疄 8 鏈堟瘝鐗堥�愭牸 diff銆嶇殑楠岃瘉鎶ュ憡锛岃瘉鏄庢墿鍒楀櫒鍙潬鍚庡啀鍋氭暣閾俱��
+- **鏂规 B锛堟湰鏈� Excel 灏忓伐鍏蜂竴閿墿鍒楋級**锛氶璁� 1 澶┿�傜敤 Excel COM 鎻掑垪锛堝紩鐢ㄧ敱 Excel 鑷姩璋冩暣锛岀渷鎺夌 3 澶勫钩绉伙級锛岀敓鎴愭柊姣嶇増銆�
+- 寤鸿锛氬厛 B 搴旀�ワ紙淇濊瘉 9 鏈堝嚭琛級锛屽啀 A 鍋氶暱鏁堛��
+
+### 5.4 楠岃瘉鏂规硶
+
+鐢� 7 鏈堟瘝鐗堟墿鍒楀嚭 8 鏈堢粨鏋勶紝涓� `docs/鐢熸垚姹囨�诲ぇ琛�/2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx`锛堝凡浜哄伐鍒犺繃 AJ 鍒楋級閫愭牸 diff锛屽樊寮傚繀椤讳负 0 鎴栧叏閮ㄥ彲瑙ｉ噴銆�
+
+## 6. 宸蹭慨澶嶄絾蹇呴』鐭ユ倝鐨勫巻鍙插潙锛堥伩鍏嶆敼鍥炲幓锛�
+
+1. **鍩庡競瀹㈣繍椤� AJ 鍒�**锛�09-20锛夛細8 鏈堟瘝鐗堝煄甯傚杩愰〉澶氫簡涓�鍒椼��2025骞�1-7鏈堢疮璁°�嶏紝鎶� 2025 骞� 8 鏈堝垪鎸ゅ埌 AK锛屽鑷� 8 鏈堝悓姣斿彉鎴愩��8鏈� 梅 1-7鏈堢疮璁°�嶃�佺疮璁″悓姣旀紡璁°�傚凡鐢� Excel COM 鏁村垪鍒犻櫎 AJ 骞惰繕鍘� 36 澶勮 `#REF!` 鐨勫叕寮忥紱澶囦唤 `_bak_202608姣嶇増鍒犻櫎AJ鍒楀墠_20260920.xlsx`銆�**娉ㄦ剰锛氱敤鎴峰綋鏃跺垹鐨勬槸 7 鏈堟瘝鐗堬紝鑰� 8 鏈堝鍑虹敤鐨勬槸 8 鏈堟瘝鐗� 鈥斺�� 姣嶇増鏈変袱鏈紝鏀逛箣鍓嶅厛纭鏀瑰鍝湰銆�**
+2. **鍒楀彿 0 鍩�/1 鍩�**锛�09-20锛夛細`colIndexOf()` 鏇捐繑鍥� 1 鍩哄垪鍙凤紝POI 瑕� 0 鍩猴紝瀵艰嚧鍏紡鍙崇Щ 2 鍒楀彉鎴愯嚜寮曠敤銆�360 鏍煎惊鐜紩鐢ㄣ�傚凡淇紝鏂板啓鍒楀彿鎹㈢畻鏃跺姟蹇呭娴嬨��
+3. **`setCellFormula` 涓嶆帴鍙楀甫 `=` 鍓嶇紑**锛�09-20锛夛細寮傚父鍙堣 `catch (Exception ignore)` 鍚炴帀锛屽鑷寸疮璁″悓姣斿垎姣嶄慨姝ｉ潤榛樺け鏁堛�傚凡鏀规垚 WARN 鏃ュ織锛�**鎺ユ墜鍚庢柊鍐欏叕寮忔椂涓嶈鍐嶅悶寮傚父**銆�
+4. **鍏紡蹇呴』閲嶇畻鍐欑紦瀛樺��**锛�09-18锛夛細POI 鍐欐枃浠朵笉绠楀叕寮忥紝Excel 鎵撳紑闈� `fullCalcOnLoad` 浼氱畻锛屼絾绯荤粺棰勮銆佷簩娆″鐞嗐�侀儴鍒� WPS 鐪嬩笉鍒般�傜幇宸插湪鏀跺熬缁熶竴 `evaluateAll`锛坄recalcWorkbookFormulas()` :3601锛夈��
+5. **涓彛寰勬帓鍚嶅懆杞噺鍙ｅ緞缁熶竴**锛�09-19锛夛細鍩庨檯鍩庝埂涓�寰嬬敤銆屾�婚噺 - 鍩庡競鍐呫�嶇幇绠楋紙`ReportExportService.java:2504` 闄勮繎娉ㄩ噴锛夛紝鍘熴�屽瓧娈靛�间紭鍏堛�嶄細鍦ㄤ釜鍒紒涓氳宸� 卤0.01銆�
+6. **`setValOrBlank()` 閬囧埌鍏紡鍗曞厓鏍肩洿鎺� return**锛坄ReportExportService.java:2740`锛夛細鎵�浠ヤ腑鍙ｅ緞鎺掑悕鍏ㄧ渷琛岀殑 `SUM` 鍏紡涓嶄細琚鐩栵紝鍒瘯鍥剧敤鍐欏�煎幓鏀瑰畠銆�
+
+## 7. P2 鍏朵粬寰呭姙
+
+- **B4 瀵煎嚭鍓嶅熀鏁颁綋妫�**锛氬鍑哄墠妫�鏌ュ悇椤电鍩烘暟/鏈熸鏄惁榻愬锛岀己澶卞氨寮圭獥 + 鐢熸垚銆婃暟鎹己澶辨竻鍗曘�嬮〉銆傚凡鏈� `midIssues`锛�:2435锛夊拰 `dbProblems` 涓や釜闂娓呭崟鍙寕銆�
+- **D 缁� 澧為�熸帓鍚嶆帾杈�**锛氬緟鎺掓湡銆�
+- **涓彛寰勬槑缁� 4 鏍� `#DIV/0!`**锛�2025 骞� 8 鏈堝熀鏁颁负 0锛屼笉鍙瘮锛屾槸鍚︽敼绌虹櫧寰呬笟鍔″彛寰勭‘璁ゃ��
+- **缂烘瘝鐗堟彁绀猴紙T08锛夋湭瀹炴祴**銆�
+- **閮ㄧ讲鍖呮瘝鐗堟槸鏃х増**锛坄deploy/traffic-audit-deploy-20260913/backend/docs/鐢熸垚姹囨�诲ぇ琛�/`銆乣_deploytest/`锛夛細鐢ㄦ埛 09-20 鏄庣‘銆岄儴缃插寘鍏堜笉绠°�嶏紝鍙戝寘鍓嶉渶鍚屾銆�
+- 鍚屾湡瀛樺湪鐨勫叾浠栫嚎锛氬ぉ闂ㄧ墿娴佹簮鏂囦欢缂哄け銆佽崋宸�/榛勭煶銆岃鍒掑唴/瑙勫垝澶栥�嶅彛寰勫緟纭銆�
+
+## 8. 鍏抽敭浠ｇ爜鍦板浘
+
+| 鏂囦欢 | 浣嶇疆 | 鑱岃矗 |
+| --- | --- | --- |
+| `reportexport/service/ReportExportService.java` | :139 | `checkExportReady()` 瀵煎嚭灏辩华鏍￠獙 |
+| | :285 | `reportPreview()` 棰勮 |
+| | :2209 | `exportPassengerMidDetail()` 涓彛寰勬槑缁嗙嫭绔嬬敓鎴愬櫒 |
+| | :2441 | `loadMidClassMap()` 涓彛寰勪簲缁达紙0 鎬婚噺 / 1 鐝嚎+涓綋 / 2 鍩庨檯鍩庝埂鍏氦 / 3 鍩庨檯鍩庝埂宸℃父鍑虹 / 4 鍩庨檯鍩庝埂缃戠害杞︼級鈥斺�� **鍏ㄩ儴鏌ュ簱鐜扮畻** |
+| | :2531 | 缁村害 4 缃戠害杞� = `WycSplitCalc.calc()` |
+| | :2683 | `exportPassengerMidRank()` 涓彛寰勬帓鍚嶇嫭绔嬬敓鎴愬櫒 |
+| | :3522 | `exportSummaryWorkbook()` 姹囨�诲ぇ琛ㄤ富鍏ュ彛 |
+| | :3753 / :3766 | `refreshSummaryRankSheets()` / `copyRankValues()` 鎺掑悕椤垫惉鍊� |
+| | :3984 | `refreshSummaryCumulativeSheets()` 鍥涢〉鎴愬搧椤电幇绠� |
+| | :4464 | `resolveSummaryMother()` 姣嶇増瀹氫綅 |
+| | :4476 | `exportWycSplit()` 缃戠害杞︽媶鍒� |
+| `reportexport/calc/SummaryWorkbookFiller.java` | :54 | `fillMonthlyLedger()` 鍏紶鍙拌处椤靛洖濉� |
+| | :432 / :549 / :777 | `ensureMonthFormulas()` / `ensureMonthYoyFormulas()` / `repairCumulativeYoyFormulas()` 鍏紡鎸夋湀琛ラ綈涓庝慨鍒嗘瘝 |
+| | :586 / :589 | `isMonthLedgerSheet()` / `isFilledLedgerSheet()` **椤佃寖鍥村垽鏂紝鏇惧洜涓よ�呬笉涓�鑷村嚭 bug** |
+| | :864 | `monthColumnCapacity()` 姣嶇増鑳藉绾崇殑鏈堜唤鍒楁暟 |
+| `reportexport/calc/WycSplitCalc.java` | :93 | `calc()` 缃戠害杞︽媶鍒嗭紙璁㈠崟鍗犳瘮 脳 鍏ㄧ渷 pin锛涘煄甯傚唴鐢ㄥ贰娓稿嚭绉熴�屽煄甯傚唴鍗犳瘮銆嶄唬鐞嗭紝姝︽眽鑷暀銆佸叾浣欐寜鍓╀綑鍗犳瘮閲嶅垎鎽婏級 |
+| | :201 / :241 | `loadMonthlyInput()` 鍙栨暟锛�**鍏堟煡搴� `wyc_order_monthly`锛屽簱閲屾病鏈夋墠鍥炶惤鍒� `docs/鍩庡競瀹㈣繍/缃戠害杞﹁鍗曞強鍏ㄧ渷鎬婚噺.xlsx`** |
+| `reportexport/service/ReportExportTaskService.java` | - | 寮傛瀵煎嚭浠诲姟 + 杩涘害 + 10 鍒嗛挓鍐呭瓨缂撳瓨 + 鏁版嵁鐗堟湰瀹堝崼锛坄import_batch.id` 鍙樺寲鍗冲け鏁堬級 |
+| `traffic-audit-web/src/views/ReportExport.vue` | - | 鎶ヨ〃鐢熸垚椤碉紙棰勮/涓嬭浇/杩涘害寮圭獥/缂撳瓨鎻愮ず锛� |
+
+## 9. 鏁版嵁涓庣幆澧�
+
+- 鍚庣 Spring Boot 绔彛 `8090`锛涘墠绔� Vue2 + ElementUI 绔彛 `8080`锛坄/api` 浠ｇ悊鍒� 8090锛夈��
+- 涓�閿惎鍋滐細`start-dev.ps1`锛堥」鐩牴鐩綍锛夛紝**蹇呴』鍦ㄦ矙绠卞杩愯**銆�
+- 鏁版嵁搴擄細MySQL 8.0 `127.0.0.1:3308/traffic_audit`锛坮oot/123456锛夛紱瀹㈡埛绔� `D:\mysql\mysql-5.7.41-winx64\bin\mysql.exe`銆�
+- 姹囨�诲ぇ琛ㄧ敤鍒扮殑琛細
+
+| 琛� | 鐢ㄩ�� |
+| --- | --- |
+| `h2031_enterprise_monthly` | 鍏矾瀹㈣繍浼佷笟鏈堟姤锛堢彮绾�/鍖呰溅锛屼腑鍙ｅ緞缁村害 1锛� |
+| `passenger_individual_monthly` | 涓綋瀹㈣繍锛堝苟鍏ョ淮搴� 1锛� |
+| `city_bus_monthly` | 鍩庡競鍏氦锛堢淮搴� 2 = 鎬婚噺 - 鍩庡競鍐咃級 |
+| `city_taxi_monthly` | 宸℃父鍑虹锛堢淮搴� 3 = 鎬婚噺 - 鍩庡競鍐咃紱涔熸槸缃戠害杞︽媶鍒嗙殑浠ｇ悊杈撳叆锛� |
+| `wyc_order_monthly` / `wyc_total_monthly` | 缃戠害杞﹁鍗曞崰姣斾笌鍏ㄧ渷 pin锛堢淮搴� 4锛� |
+| `h2032_enterprise_monthly` | 璐ц繍閲忎笌鍛ㄨ浆閲� |
+
+- 姣嶇増鐩綍锛歚docs/鐢熸垚姹囨�诲ぇ琛�/`锛堝惈 `_bak_`/`_澶囦唤_` 鍘嗗彶浠讹紝**鏈粡鍚屾剰涓嶈鍒�**锛夈��
+- 鍗曚綅绾﹀畾锛氬簱鍐呬负鍘熷鍗曚綅锛屽啓鍏ヨ〃鏍兼椂 梅10000 寰椼�屼竾浜� / 涓囧惃 / 涓囦汉鍏噷銆嶏紱**鍏ㄧ簿搴﹀啓鍏ワ紝鏄剧ず涓や綅灏忔暟**锛坄applyTwoDecimalFormat()`锛夈��
+
+## 10. 鏈鎺掓煡浜х敓鐨勮瘉鎹枃浠讹紙鍦ㄩ」鐩牴鐩綍锛屽皻鏈竻鐞嗭級
+
+| 鏂囦欢 | 鍐呭 |
+| --- | --- |
+| `_chk_mid.txt`銆乣_chk_hg*.txt` | 涓彛寰勬槑缁�/鎺掑悕椤甸粍鍐堟暟鎹笌鍏紡 dump |
+| `_chk_wyc.txt` ~ `_chk_wyc7.txt` | 缃戠害杞︽媶鍒嗛�愬競閫愭湀澶嶇畻涓庢瘝鐗堟瘮瀵� |
+| `_chk_taxidiff.txt` | 鍑虹椤� vs 搴撳嚭绉熼�愭牸姣斿 |
+| `_chk_lineage.txt`銆乣_chk_lineage2.txt` | 姣嶇増鍘嗗彶鐗堟湰琛�缂橈紙7 浠芥瘝鐗堢殑 2025-03/04 鍊硷級 |
+| `_chk_backsolve.txt` | 鐢辨瘝鐗堢綉绾﹁溅鍙嶆帹褰撴椂鐨勫嚭绉熻緭鍏� |
+| `_chk_rule.txt` | 鍊欓�夊垎鎽婂叕寮忔嫙鍚堢粨鏋滐紙鎺掗櫎娉曪級 |
+| `_chk_orig.txt` | 9/8 鍘熷姣嶇増鍏抽敭鏍� |
+| `_chk_all_pref.txt` | 17 甯傚窞涓ら〉鍚屾瘮宸紓娓呭崟 |
+| `_chk_code*.txt`銆乣_chk_wyccalc.txt`銆乣_chk_wycdb.txt`銆乣_chk_filler.txt`銆乣_chk_freight.txt` | 鐩稿叧浠ｇ爜娈垫憳褰� |
+
+## 11. 寰呯敤鎴�/涓氬姟纭娓呭崟锛堟帴鎵嬩汉鍏堝埆鑷繁鎷嶏級
+
+1. ~~P0-1 璧版柟妗� A 杩樻槸 B锛燂紙寤鸿 A锛墌~ 鐢ㄦ埛宸查�夋嫨鏂规 A锛�2026-09-21 宸插疄鏂藉苟鍥炲綊閫氳繃銆�
+2. P0-2 璧版柟妗� A锛堢▼搴忚嚜鍔ㄦ墿鍒楋級杩樻槸 B锛圗xcel 灏忓伐鍏凤級锛�9 鏈堟槸鍚﹀厛鐢� B 搴旀�ワ紵
+3. 涓彛寰勬槑缁� 4 鏍� `#DIV/0!` 鏄惁鏀圭┖鐧斤紵
+4. B4 鍩烘暟浣撴鐨勮Е鍙戞椂鏈轰笌寮圭獥鏂囨銆�
+
+## 12. 寤鸿鐨勬帴鎵嬮『搴�
+
+1. 璺戦�氱幆澧� + 鐢熸垚涓�娆� 2026-08 姹囨�诲ぇ琛紝纭鑳藉鐜版湰鏂囨墍鏈夌幇璞★紙鍗婂ぉ锛夈��
+2. ~~澶勭悊 P0-1 鏂规 A锛�1 澶╋紝鍚洖褰掞級銆倊~ 宸蹭簬 2026-09-21 瀹屾垚銆�
+3. 澶勭悊 P0-2 鏂规 B 鍑� 9 鏈堟瘝鐗堬紙1 澶╋級锛岄殢鍚庢帓 A銆�
+4. 琛� B4 鍩烘暟浣撴锛�1-2 澶╋級銆�

--
Gitblit v1.9.1