From af67ad6147800468ab2b101c5a4cc361cb1fd35b Mon Sep 17 00:00:00 2001
From: zyj <zyj@local>
Date: 星期日, 13 九月 2026 23:39:44 +0800
Subject: [PATCH] docs(工作日结): 补记 2026-09-13 《运距异常分析》分析报告（出版）重写与文件误覆盖恢复
---
docs/功能测试报告/功能测试报告_汇总大表四页数据驱动_2026-09-13.md | 146 ++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 146 insertions(+), 0 deletions(-)
diff --git "a/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_\346\261\207\346\200\273\345\244\247\350\241\250\345\233\233\351\241\265\346\225\260\346\215\256\351\251\261\345\212\250_2026-09-13.md" "b/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_\346\261\207\346\200\273\345\244\247\350\241\250\345\233\233\351\241\265\346\225\260\346\215\256\351\251\261\345\212\250_2026-09-13.md"
new file mode 100644
index 0000000..cb8d2b2
--- /dev/null
+++ "b/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_\346\261\207\346\200\273\345\244\247\350\241\250\345\233\233\351\241\265\346\225\260\346\215\256\351\251\261\345\212\250_2026-09-13.md"
@@ -0,0 +1,146 @@
+# 鍔熻兘娴嬭瘯鎶ュ憡_姹囨�诲ぇ琛ㄥ洓椤垫暟鎹┍鍔╛2026-09-13
+
+## 涓�銆佸姛鑳借鏄�
+
+### 1. 鑳屾櫙
+
+鐢ㄦ埛鍙嶉锛氬鍑� 2026 骞� 8 鏈堛�婇亾璺繍杈撻噺姹囨�昏〃銆嬪悗锛屼互涓� 4 寮�**璺ㄩ〉鍚堟垚椤�**浠嶆槸涓婁竴鎶ヨ〃鏈熺殑闈欐�佸�硷紙鏍囬鍐欍��2026骞�1-7鏈� / 2026骞�7鏈堛�嶏紝鏁板�间篃鏄� 7 鏈堢殑锛屼笉闅忔姤琛ㄦ湡鍙樺寲锛夛細
+
+| 椤靛悕 | 姣嶇増鍘熺姸鎬� |
+| --- | --- |
+| `鍩庡競姹囨�籤 | 鏁撮〉闈欐�侊紙1-7 鏈堢疮璁� + 7 鏈堝綋鏈堬級 |
+| `鍩庡競鍒嗗競宸瀈 | 4 鍧楁暣椤甸潤鎬� |
+| `涓彛寰勫垎鏋恅 | 2 鍧楁暣椤甸潤鎬� |
+| `閬撹矾杩愯緭鍛ㄨ浆閲廯 | 2 鍧楁暣椤甸潤鎬� |
+
+鐢ㄦ埛閫夊畾**鏂规 A**锛氭部鐢ㄨ揣杩愭帓鍚嶉〉鐨勫仛娉曗�斺�旂敤姣嶇増鍙拌处椤佃嚜甯︾殑 2025 骞村悓鏈熷垪缂撳瓨鍊煎綋鍚屾瘮鍩烘暟锛屾妸銆屽綋骞寸疮璁″�笺�嶅埛鎴� 1-8 鏈堬紙鍚屾瘮鍒楁部鐢ㄦ瘝鐗堝彛寰勶級锛�4 椤典竴娆℃�у仛鍑烘潵銆�
+
+### 2. 鍙ｅ緞锛堝厛楠岃瘉銆佸悗缂栫爜锛�
+
+缂栫爜鍓嶅厛鐢ㄦ瘝鐗堝彴璐﹂〉閫愭牸鑱氬悎鍙嶆帹鍥涢〉鍙ｅ緞锛屼笌鍥涢〉鎴愬搧閫愭牸姣斿 **0 宸紓**鍚庣‘璁わ細
+
+| 鎸囨爣 | 鍙ｅ緞 |
+| --- | --- |
+| 鍩庡競瀹㈣繍閲� | 鍏氦鍩庡競鍐呭杩愰噺 + 宸℃父鍑虹鍩庡競鍐呭杩愰噺 + 缃戠害杞﹀煄甯傚唴瀹㈣繍閲� + 杞ㄩ亾瀹㈣繍閲� + 杞浮瀹㈣繍閲� |
+| 鍩庡競瀹㈣繍鍛ㄨ浆閲� | 鍚屼笂锛屾崲鎴愬悇鑷梾瀹㈠懆杞噺 |
+| 涓彛寰勫杩愰噺/鍛ㄨ浆閲� | 鍏矾鐝嚎鍖呰溅 + 鍩庨檯鍩庝埂鍏氦 + 鍩庨檯鍩庝埂宸℃父鍑虹 + 鍩庨檯鍩庝埂缃戠害杞︼紝鍏朵腑銆屽煄闄呭煄涔� X = X 鎬婚噺 鈭� X 鍩庡競鍐呫�嶏紙浠呭叕浜�/鍑虹/缃戠害杞︼紱鐝嚎鍖呰溅鏃犲煄甯傚唴姒傚康锛岀洿鎺ョ敤鎬婚噺锛� |
+| 閬撹矾璐ц繍鍛ㄨ浆閲� | 璐ц繍椤靛競宸炪�岃涓婅揣鐗╁懆杞噺 + 瑙勪笅璐х墿鍛ㄨ浆閲忋�嶏紙**涓嶇敤**姣嶇増銆岃涓�+瑙勪笅銆嶅叕寮忚锛� |
+| 閬撹矾杩愯緭鍛ㄨ浆閲忛〉銆岄亾璺杩愬懆杞噺銆� | 鐝嚎鍖呰溅鍛ㄨ浆閲� + 鍩庨檯鍩庝埂鍏氦/鍑虹/缃戠害杞﹀懆杞噺 |
+| 鍚屾瘮 | 褰撴湡 梅 姣嶇増鍙拌处椤� 2025 骞村悓鏈熷垪 鈭� 1 |
+
+**鍏充簬 2025 鍚屾湡鍩烘暟**锛氬簱涓彧鏈� 2026 骞村煄甯傚杩�/缃戠害杞︽暟鎹紝娌℃湁 2025 骞存暟鎹紝鏁� 2025 鍚屾湡涓�寰嬪彇**姣嶇増鍙拌处椤佃嚜甯︾殑 2025 骞撮�愭湀鍒楃紦瀛樺��**锛圴=1鏈堛�乆=2鏈� 鈥� AJ=8鏈堬級銆傝繖涔熸鏄柟妗� A 鐨勫彇宸х偣锛氭瘝鐗堝彴璐﹂〉鏈韩甯﹀叏 2025 閫愭湀鍒楋紝鏃犻渶绛� 2025 鏁版嵁鍏ュ簱銆�
+
+### 3. 瀹炵幇
+
+鏀瑰姩鏂囦欢锛歚traffic-audit-server/src/main/java/com/trafficaudit/reportexport/service/ReportExportService.java`锛�+494 鈭�2锛夈��
+
+- 鏂板鍏ュ彛 `refreshSummaryCumulativeSheets(XSSFWorkbook wb, int year, int month)`锛涙帴鍦ㄥ鍑洪摼璺殑 `refreshSummaryRankSheets(...)` 涔嬪悗銆乣applySummaryReferenceLayout(wb)` 涔嬪墠璋冪敤銆�
+- 鍙拌处鍙栨暟 `smReadLedgerMetrics`锛�**鎸夎鏍囩璇嗗埆銆佷笉鍐欐琛屽彿**
+ - `鍏氦`/`鍑虹`/`缃戠害杞锛氭瘡甯傚窞銆屽杩愰噺 / 鏃呭鍛ㄨ浆閲� / 鍏朵腑鍩庡競鍐呭杩愰噺 / 鍏朵腑鍩庡競鍐呮梾瀹㈠懆杞噺銆�4 琛岋紱
+ - `杞ㄩ亾銆佽疆娓锛氳建閬擄紙鍏ㄧ渷/姝︽眽/榛勭煶锛変笌杞浮锛堝叏鐪�/姝︽眽锛夊垎鍧楋紱
+ - `鐝嚎鍖呰溅`锛氬叏鐪佷笌 17 甯傚窞瀹㈣繍閲�/鍛ㄨ浆閲忥紙銆屽叾涓釜浣撱�嶈涓嶉噸澶嶈鍏ワ級锛�
+ - ` 璐ц繍`锛堥〉鍚嶅甫鍓嶅绌烘牸锛夛細甯傚窞銆岃涓婅揣鐗╁懆杞噺 + 瑙勪笅璐х墿鍛ㄨ浆閲忋�嶃��
+- 鏈堜唤鍒楋細2026 骞撮�愭湀鍒� C=1鏈� 鈥� Q=8鏈堬紙`SM_CUR_COL0=2`锛夛紝2025 骞村悓鏈熷垪 V=1鏈� 鈥� AJ=8鏈堬紙`SM_LAST_COL0=21`锛夛紝姣忔湀闂撮殧 2 鍒楋紙鍊煎垪 + 鍚屾瘮鍒楋級銆�
+- 19 缁存寚鏍囦綅锛坄SM_DIM=19`锛夛細鍏氦/鍑虹/缃戠害杞� 鍚� 4 缁达紙鎬婚噺銆佸懆杞噺銆佸煄甯傚唴鎬婚噺銆佸煄甯傚唴鍛ㄨ浆閲忥級+ 杞ㄩ亾 2 缁� + 杞浮 2 缁� + 鐝嚎鍖呰溅 2 缁� + 璐ц繍鍛ㄨ浆閲� 1 缁淬��
+- 鍐欏�艰鍒� `smSetVal`锛�**鐩爣鏍煎師鏈槸鍏紡 鈫� 淇濈暀姣嶇増鍏紡涓嶈鐩�**锛堟墦寮�鍗抽噸绠楋級锛涚洰鏍囨牸涓虹┖涓旀柊鍊间负 0 鈫� 涓嶆柊澧烇紱鍏朵綑鍏� `setBlank()` 鍐嶅啓锛岄伩鍏� inlineStr 娈嬬暀銆�
+- 鍥涢〉瀹為檯鍐欏叆 **1056 鏍�**銆�
+
+## 浜屻�佹祴璇曠幆澧�
+
+- 鍚庣 `http://localhost:8090`锛坄start-dev.ps1` 鍚姩锛孭ID 27840锛夛紝鍓嶇 `http://localhost:8080`锛圥ID 23416锛夊潎灏辩华銆�
+- 姣嶇増锛歚docs/鐢熸垚姹囨�诲ぇ琛�/2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx`锛涚増寮忓弬鐓э細`docs/鐢熸垚姹囨�诲ぇ琛�/鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃.xlsx`銆�
+- 瀵煎嚭鎺ュ彛锛歚GET /api/report/export/summaryWorkbook?period=YYYY-MM`锛圔earer token锛夈��
+- 娴嬭瘯鏃堕棿锛�2026-09-13銆�
+- 娴嬭瘯浜х墿锛歚_t3_2026-08.xlsx`锛�950,783 瀛楄妭 / HTTP 200 / 36.8 绉掞級銆乣_t3_2026-07.xlsx`锛�942,691 瀛楄妭 / HTTP 200 / 25.7 绉掞級锛涘綊妗ｄ欢 `docs/鐢熸垚姹囨�诲ぇ琛�/杈撳嚭/鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃_2026-08_鍥涢〉鏁版嵁椹卞姩_2026-09-13.xlsx`锛�950,783 瀛楄妭锛夈��
+- 鐙珛澶嶆牳鑴氭湰锛歚_v5_four.py`锛堣緭鍑� `_v5_four.txt`锛夈�乣_verify_four.py`锛堣緭鍑� `_verify_four.txt`锛夈��
+
+## 涓夈�佺敤渚嬭〃
+
+### 3.1 姝ｅ悜鐢ㄤ緥
+
+| 缂栧彿 | 杈撳叆 | 棰勬湡 | 瀹為檯 | 缁撹 |
+| --- | --- | --- | --- | --- |
+| TC-1 | 瀵煎嚭 `period=2026-08` | HTTP 200锛屾甯镐骇鍑� | 950,783 瀛楄妭锛�36.8 绉� | 閫氳繃 |
+| TC-2 | 涓� 09-13 13:06 褰掓。浠舵瘮瀵� | 鍚屽弬鏁板鍑虹粨鏋滅‘瀹� | 涓ゆ浜х墿鍚屼负 950,783 瀛楄妭 | 閫氳繃 |
+| TC-3 | 鍚庣鍥炲～鏃ュ織 | 鏈夊洓椤靛埛鏂扮粺璁°�佹棤缂烘暟鎻愮ず銆佹棤寮傚父 | 銆屽埛鏂板洓椤碉紙鍩庡競姹囨��/鍩庡競鍒嗗競宸�/涓彛寰勫垎鏋�/閬撹矾杩愯緭鍛ㄨ浆閲忥級鏁板�兼牸鏁�=1056銆嶃�屽埛鏂版帓鍚嶉〉鏁板�兼牸鏁�=711銆嶃�岀己鏁版彁绀�=[]銆嶏紱鏈�杩� 4MB 鏃ュ織鏃� `ERROR`/`Exception`/`WARN` | 閫氳繃 |
+| TC-4 | `鍩庡競姹囨�籤 鏍囬 | 闅忔姤琛ㄦ湡鏀逛负 1-8 鏈� / 8 鏈� | `A1=2026骞�1-8鏈堝叏鐪佺疮璁″畬鎴愬煄甯傚杩愰噺鎯呭喌`銆乣A12=2026骞�8鏈堝叏鐪佸畬鎴愬煄甯傚杩愰噺鎯呭喌` | 閫氳繃 |
+| TC-5 | `鍩庡競姹囨�籤 绱鍧楋紙B3:E9锛� | 瀹㈣繍閲�/鍚屾瘮/鍛ㄨ浆閲�/鍚屾瘮 鍚� 7 琛� | 28 鏍煎叏閮ㄤ竴鑷达紙濡� B3=269628.07銆丆3=0.00117銆丏3=1681467.65銆丒3=0.00835锛� | 閫氳繃 |
+| TC-6 | `鍩庡競姹囨�籤 褰撴湀鍧楋紙B14:E20锛� | 鍚屼笂锛屽綋鏈堝彛寰� | 28 鏍煎叏閮ㄤ竴鑷达紙濡� B14=32215.74銆丆14=0.0444锛� | 閫氳繃 |
+| TC-7 | `鍩庡競鍒嗗競宸瀈 鏍囬 脳4 | 4 鍧楁爣棰橀殢鎶ヨ〃鏈� | `A1=鈥�1-8鏈堢疮璁℃儏鍐礰銆乣A23=鈥�1-8鏈堢疮璁℃儏鍐礰銆乣A46=鈥�8鏈堟儏鍐礰銆乣A68=鈥�8鏈堟儏鍐礰 | 閫氳繃 |
+| TC-8 | `鍩庡競鍒嗗競宸瀈 4 鍧� 脳 17 甯傚窞 脳 6 鍊煎垪 | 6 缁勫�� = 鎬婚噺/鍏氦/鍑虹/缃戠害杞�/杞ㄩ亾/杞浮 | 408 鏍煎叏閮ㄤ竴鑷� | 閫氳繃 |
+| TC-9 | `涓彛寰勫垎鏋恅 鏍囬 + 鏁板�� | 2 鍧楁爣棰� + 姣忓潡 鎬�/鐝嚎/鍩庝埂鍏氦/鍩庝埂鍑虹/鍩庝埂缃戠害杞� | `A1=1-8鏈堜腑鍙ｅ緞瀹㈣繍閲忓強鍛ㄨ浆閲廯銆乣A10=8鏈堜腑鍙ｅ緞瀹㈣繍閲忓強鍛ㄨ浆閲廯锛汢3=31528.0607銆丗3=1227147.4890 绛� 10 鏍煎叏閮ㄤ竴鑷� | 閫氳繃 |
+| TC-10 | `閬撹矾杩愯緭鍛ㄨ浆閲廯 鏍囬 + 鏁板�� | 2 鍧楁爣棰� + 17 甯傚窞 G/L/Q/W/X/Y | `A1=2026骞�1-8鏈堝叏鐪佺疮璁″畬鎴愪氦閫氬懆杞噺鎯呭喌`銆乣A23=2026骞�8鏈堝叏鐪佸畬鎴愪氦閫氬懆杞噺鎯呭喌`锛�102 鏍煎叏閮ㄤ竴鑷达紙濡� G4=17492129.04788293銆丩4=269628.07銆丵4=1227147.48902锛沇/X/Y 鍚屾湡鍒楀彇 2025 骞村悓鏈熺疮璁★紝濡� W4=17492068.4575銆乆4=269312.48銆乊4=1256684.2157锛� | 閫氳繃 |
+
+### 3.2 璐熷悜鐢ㄤ緥
+
+| 缂栧彿 | 杈撳叆 | 棰勬湡 | 瀹為檯 | 缁撹 |
+| --- | --- | --- | --- | --- |
+| TC-N1 | 鐩爣鏍兼槸姣嶇増鍏紡锛坄鍩庡競鍒嗗競宸瀈 鍏ㄧ渷琛� `B5=G5+L5+Q5+V5+X5`銆乣閬撹矾杩愯緭鍛ㄨ浆閲廯 `J4=G4/W4-1`锛� | 涓嶈鍐欏�艰鐩栵紝淇濈暀姣嶇増鍏紡 | 涓よ�呬粛涓哄叕寮忥紱鍥涢〉鍐欏叆鏍兼暟 1056 < 鍥涢〉鐞嗚鏍兼暟锛岃鏄庡叕寮忔牸琚烦杩� | 閫氳繃 |
+| TC-N2 | 鐩爣鏍间负绌轰笖鏂板�间负 0 | 涓嶆柊澧� 0锛岄伩鍏嶆妸鎴愬搧椤靛啓鎴愭弧椤� 0 | `SM_璐ц繍` 鏃犳暟鎹殑甯傚窞杞ㄩ亾/杞浮鍊兼湭浜х敓鏂板 0 鏍� | 閫氳繃 |
+| TC-N3 | 2025 鍚屾湡鏃犲簱鏁版嵁 | 鍙栨瘝鐗堝彴璐﹂〉 2025 鍒楃紦瀛橈紝涓嶅嚭鐜� NaN/Inf | 鍚屾瘮鍏ㄩ儴涓烘湁闄愭暟锛堝 `鍩庡競姹囨�� C7=0.4870`銆乣C14=0.0444`锛� | 閫氳繃 |
+| TC-N4 | 鍙拌处椤佃涓嶅埌甯傚窞鏁版嵁锛堟瀬绔儏鍐碉級 | 璁� `WARN` 骞�**淇濇寔姣嶇増鍘熷��**銆佷笉鍐欏潖椤� | 浠ｇ爜璺緞 `curCum.isEmpty()` 鈫� `log.warn("鈥﹀彴璐﹂〉鏈鍒板競宸炴暟鎹紝璺宠繃锛堜繚鎸佹瘝鐗堝師鍊硷級")`锛涙湰杞彴璐﹂〉鏁版嵁榻愬叏锛屾湭瀹為檯瑙﹀彂锛�**浠ｇ爜瀹℃煡鐢ㄤ緥**锛� | 閫氳繃锛堝鏌ワ級 |
+| TC-N5 | 姣嶇増鏍囬涓� inlineStr | 鏍囬蹇呴』鐪熸钀界洏鏇存柊锛屼笉鑳藉彧鏀� `<v>` | `smSetTitle` 鍏� `setBlank()` 鍐嶅啓锛屾爣棰樻牎楠屽叏閮ㄨ鍙栧埌鏂版枃妗� | 閫氳繃 |
+
+### 3.3 鍥炲綊鐢ㄤ緥
+
+| 缂栧彿 | 杈撳叆 | 棰勬湡 | 瀹為檯 | 缁撹 |
+| --- | --- | --- | --- | --- |
+| TC-R1 | 瀵煎嚭 `period=2026-07` | 涓嶅穿锛屼笖鍥涢〉搴斿洖閫�鎴愩��1-7 鏈堛�嶅彛寰� | HTTP 200 / 942,691 瀛楄妭 / 25.7 绉掞紱鏍囬 `鍩庡競姹囨�� A1=2026骞�1-7鏈堚�銆乣鍩庡競瀹㈣繍瀹㈣繍閲忓垎甯傚窞1-7鏈堢疮璁℃儏鍐礰銆乣1-7鏈堜腑鍙ｅ緞瀹㈣繍閲忓強鍛ㄨ浆閲廯銆乣2026骞�1-7鏈堝叏鐪佺疮璁″畬鎴愪氦閫氬懆杞噺鎯呭喌` | 閫氳繃 |
+| TC-R2 | 2026-07 瀵煎嚭鍊� vs 姣嶇増 1-7 鏈堥潤鎬佹潈濞佸�� | **搴斿畬鍏ㄤ竴鑷�**锛堣瘉鏄庡彛寰勪笌姣嶇増涓�鑷达紝鍙槸闅忔湀浠藉欢闀匡級 | 鍩庡競姹囨�� B3=237412.33000000002锛堟瘝鐗� 237412.33锛夈�佷腑鍙ｅ緞 B3=27524.4906銆侀亾璺繍杈撳懆杞噺 G4=15222118.44638293銆佸煄甯傚垎甯傚窞 B6=135474.77989442425 鈥斺�� 涓庢瘝鐗堥�愰」涓�鑷� | 閫氳繃 |
+| TC-R3 | 鍚庣鏈嶅姟鍙敤鎬� | 鍓嶇棣栭〉鍙闂� | `http://localhost:8080/` HTTP 200锛屾爣棰樸�屼氦閫氱粺璁℃姤琛ㄥ鏍哥郴缁熴�� | 閫氳繃 |
+
+### 3.4 閫愭牸鐙珛澶嶆牳锛堝叧閿瘉鎹級
+
+**鏂规硶**锛氫粠鐢熸垚浠�**鑷韩鐨勫彴璐﹂〉**閲嶆柊鑱氬悎锛堜笉璇诲簱銆佷笉鍙傝�冧换浣曞叾瀹冩枃浠讹級锛屽啀涓庡洓椤甸�愭牸姣斿銆�
+
+| 澶嶆牳鑼冨洿 | 鏍兼暟 |
+| --- | --- |
+| 鏍囬锛堝煄甯傛眹鎬� 2 + 鍩庡競鍒嗗競宸� 4 + 涓彛寰� 2 + 閬撹矾杩愯緭鍛ㄨ浆閲� 2锛� | 10 |
+| 鍩庡競姹囨�� 绱鍧楋紙7 琛� 脳 瀹㈣繍閲�/鍚屾瘮/鍛ㄨ浆閲�/鍚屾瘮锛� | 28 |
+| 鍩庡競姹囨�� 褰撴湀鍧楋紙鍚屼笂锛� | 28 |
+| 鍩庡競鍒嗗競宸� 4 鍧� 脳 17 甯傚窞 脳 6 鍊煎垪 | 408 |
+| 涓彛寰勫垎鏋� 2 鍧� 脳 5 琛� 脳 2 鍒� | 10 |
+| 閬撹矾杩愯緭鍛ㄨ浆閲� 2 鍧� 脳 17 甯傚窞 脳 6 鍒楋紙G/L/Q + J/O/T + W/X/Y锛� | 102 |
+| **鍚堣** | **586** |
+
+缁撴灉锛�**姣斿 586 鏍硷紝宸紓 0 鏍�**锛坄_v5_four.txt` 鏈熬銆屾眹鎬伙細姣斿鏍兼暟 = 586锛屽樊寮傛牸鏁� = 0銆嶏級銆�
+
+琛ュ厖鑷唇鏍￠獙锛堝叏鐪佽 = 危17 甯傚窞锛夛細閬撹矾杩愯緭鍛ㄨ浆閲� G4=17492129.04788293 = 危(G5:G21)銆丩4=269628.07 = 危(L5:L21)銆丵4=1227147.48902 = 危(Q5:Q21)銆乄4/X4/Y4 鍚岀悊锛堝樊 鈮� 6e-11锛屾诞鐐硅宸骇锛夈��
+
+鍙︼細13:06 閭ｄ竴鐗堝綊妗ｄ欢鐢� `_verify_four.py` 澶嶆牳锛堝惈銆屼笌姣嶇増 1-7 鏈堥潤鎬佸�煎鐓с�嶅皬鑺傦級锛屽悓鏍�**宸紓 0 鏍�**銆�
+
+涓庢瘝鐗堥潤鎬佸�肩殑瀵圭収锛堣瘉鏄庛�岀‘瀹炰粠闈欐�佸彉鍔ㄦ�併�嶏級锛�
+
+| 鍗曞厓鏍� | 姣嶇増锛�1-7 鏈堥潤鎬侊級 | 鐢熸垚浠讹紙1-8 鏈堬級 |
+| --- | --- | --- |
+| 鍩庡競姹囨�� B3 | 237412.33 | 269628.07 |
+| 鍩庡競姹囨�� A12 | 2026骞�7鏈堝叏鐪佸畬鎴愬煄甯傚杩愰噺鎯呭喌 | 2026骞�8鏈堝叏鐪佸畬鎴愬煄甯傚杩愰噺鎯呭喌 |
+| 鍩庡競鍒嗗競宸� B6 | 135474.779894424 | 153695.70483259356 |
+| 涓彛寰勫垎鏋� B3 | 27524.4906 | 31528.060700000005 |
+| 閬撹矾杩愯緭鍛ㄨ浆閲� G4 | 15222118.4463982 | 17492129.04788293 |
+
+## 鍥涖�佸彂鐜扮殑闂涓庡缃�
+
+1. **姣嶇増鏍囬鏄� inlineStr**锛歅OI 鐩存帴 `setCellValue` 鍙啓 `<v>`銆佷笉鏀� `<is>`锛孍xcel 浠嶆樉绀烘棫鏂囨锛�7 鏈堬級銆傗啋 `smSetTitle` 鏀逛负鍏� `setBlank()` 鍐嶅啓銆�
+2. **鎴愬搧椤甸噷娣锋湁姣嶇増鍏紡**锛堝煄甯傚垎甯傚窞鍏ㄧ渷琛屻�侀亾璺繍杈撳懆杞噺 J 鍒楀悓姣旂瓑锛夛細鑻ヤ竴寰嬪啓鍊间細鐮村潖姣嶇増鑷唇鍏紡銆傗啋 `smSetVal` 閬� `FORMULA` 鐩存帴璺宠繃锛屽啓鍏ユ牸鏁� 1056 灏忎簬鍥涢〉鐞嗚鏍兼暟鍗充负姝ゃ��
+3. **鍩庡競姹囨�荤 5 琛屾槸銆屽嚭绉�+缃戠害杞︺�嶅悎璁�**锛屼笉鏄崟鍑虹銆傗啋 浠ｇ爜鎸夈�屽嚭绉� + 缃戠害杞︺�嶅啓鍏ワ紙姣嶇増绗� 6 琛屾墠鏄崟鍑虹锛夛紝涓庢瘝鐗堝彛寰勪竴鑷淬��
+4. **涓彛寰勭殑銆屽煄闄呭煄涔°�嶄笉鑳界洿鎺ュ彇鍙拌处鎬婚噺**銆傗啋 鎸夈�屾�婚噺 鈭� 鍩庡競鍐呫�嶈绠楋紙浠呭叕浜�/鍑虹/缃戠害杞︼級銆�
+5. **搴撲腑鏃� 2025 骞村煄甯傚杩�/缃戠害杞︽暟鎹�**銆傗啋 鍚屾瘮鍩烘暟鍙栨瘝鐗堝彴璐﹂〉 2025 骞撮�愭湀鍒楃紦瀛樺�硷紙鏂规 A 鐨勬牳蹇冿級锛屽悗缁� 2025 鏁版嵁鍏ュ簱鍚庡彲鍐嶅垏鎹负璇诲簱銆�
+
+## 浜斻�佺粨璁�
+
+- 姝ｅ悜 10 渚嬨�佽礋鍚� 5 渚嬨�佸洖褰� 3 渚嬨�侀�愭牸鐙珛澶嶆牳 586 鏍硷紝鍏ㄩ儴閫氳繃銆�
+- 鍥涘紶璺ㄩ〉鍚堟垚椤靛凡浠�**闈欐��**鍙樹负**闅忔姤琛ㄦ湡鏁版嵁椹卞姩**锛氬鍑� 2026-08 鏃舵爣棰樹笌鏁板�煎潎涓� 1-8 鏈�/8 鏈堝彛寰勶紱瀵煎嚭 2026-07 鏃跺張鑳界簿纭洖閫�鎴愪笌姣嶇増涓�鑷寸殑 1-7 鏈堟潈濞佸�笺��
+- 姣嶇増鍏紡淇濈暀銆佸悓姣斿熀鏁版部鐢ㄦ瘝鐗� 2025 缂撳瓨锛屾姤琛ㄦ墦寮�鍚庝粛璧版瘝鐗堣嚜甯︾殑閲嶇畻閾捐矾锛坄fullCalcOnLoad`锛夈��
+- 閬楃暀锛氫腑鍙ｅ緞鎺掑悕椤电殑銆屽悓姣斿閫熴�嶅垪浠嶆槸姣嶇増鏃у�硷紙搴撲腑鏃� 2025 骞翠腑鍙ｅ緞瀹氱鏁版嵁锛岀畻涓嶅嚭鍚屾瘮锛夛紝寰� 2025 鏁版嵁鍏ュ簱鍚庡埛鏂般��
+
+## 鍏�佸彂甯冧笌浜屾鐙珛楠岃瘉锛�2026-09-13锛�
+
+- 鎻愪氦 `ea7cc07`锛坄ReportExportService.java` + 鏈姤鍛� + 銆婂伐浣滄棩缁揰2026-09-13銆嬪叡 3 鏂囦欢锛�+689 鈭�2锛夊凡鎺ㄩ�佸弻浠撳簱锛�
+ `git push gitea main`锛坄09e612a..ea7cc07`锛夈�乣git push origin main:master`锛坄09e612a..ea7cc07`锛夛紝骞� `git branch -f master main`銆�
+- 鎺ㄩ�佸墠 `git fetch gitea` / `git fetch origin` 鍧囩‘璁よ繙绔棤鏂版彁浜わ紙`git rev-list --left-right --count` 鍧囦负 `0 0`锛夛紝鏈鐩栧悓浜嬩唬鐮併��
+- **鍙戝竷鍚庡璺�**锛氶噸鏂板鍑� `period=2026-08` 鈫� HTTP 200 / 950,783 瀛楄妭 / 29.2 绉掞紙绗笁娆″悓灏哄锛夛紱瀵瑰彂甯冨悗浜х墿 `_t4_2026-08.xlsx`
+ 鍐嶈窇涓�娆� 586 鏍肩嫭绔嬪鏍� 鈫� **宸紓 0 鏍�**锛坄_v6_four.txt`锛夈��
+- **瀹瑰櫒绾ф瘮瀵�**锛氭妸鍙戝竷鍓嶄骇鐗� `_t3_2026-08.xlsx` 涓庡彂甯冨悗浜х墿 `_t4_2026-08.xlsx` 閫� zip 鏉＄洰姣斿锛�**鍏ㄩ儴鍐呴儴鏉＄洰
+ 锛坄xl/worksheets/*`銆乣xl/sharedStrings.xml` 绛夛級瀛楄妭瀹屽叏涓�鑷�**锛涗袱鑰� MD5 涓嶅悓浠呮簮浜� xlsx 瀹瑰櫒鐨� zip 澶存椂闂存埑锛屽姛鑳界瓑浠枫��
+- 杩愯涓殑鍚庣锛圥ID 27840锛夋墽琛岀殑浠ｇ爜鍗冲凡鎻愪氦鐗堟湰锛堝伐浣滃尯瀵硅 Java 鏂囦欢 `git diff HEAD` 涓虹┖锛夈��
--
Gitblit v1.9.1