From a08c70db67e49bf6cd125df04ebaf68c26f0d8dd Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期日, 20 九月 2026 16:19:16 +0800
Subject: [PATCH] feat(投资): 市州月报统一填报模板 + 县(市、区)列解析 + 表头行判定收紧

---
 docs/功能测试报告/功能测试报告_全精度存储与两位小数显示_2026-09-20.md |   86 +++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 86 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_\345\205\250\347\262\276\345\272\246\345\255\230\345\202\250\344\270\216\344\270\244\344\275\215\345\260\217\346\225\260\346\230\276\347\244\272_2026-09-20.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_\345\205\250\347\262\276\345\272\246\345\255\230\345\202\250\344\270\216\344\270\244\344\275\215\345\260\217\346\225\260\346\230\276\347\244\272_2026-09-20.md"
new file mode 100644
index 0000000..ec18ab4
--- /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_\345\205\250\347\262\276\345\272\246\345\255\230\345\202\250\344\270\216\344\270\244\344\275\215\345\260\217\346\225\260\346\230\276\347\244\272_2026-09-20.md"
@@ -0,0 +1,86 @@
+# 鍔熻兘娴嬭瘯鎶ュ憡_鍏ㄧ簿搴﹀瓨鍌ㄤ笌涓や綅灏忔暟鏄剧ず_2026-09-20
+
+## 涓�銆佸姛鑳借鏄�
+
+**闇�姹傦紙鐢ㄦ埛 2026-09-20 鎸囦护锛�**锛氭墍鏈夌殑鏁版嵁閮藉叏閮ㄥ叏绮惧害淇濈暀锛岃绠楀緱鍒扮殑缁撴灉鏄剧ず涓や綅灏忔暟銆�
+
+**鏀瑰墠闂**锛�
+
+1. 鍚庣鍦�**鍐欏崟鍏冩牸涔嬪墠**灏卞仛浜嗗洓鑸嶄簲鍏ワ紝搴曞眰瀛樺偍鍊艰鎻愬墠鎴柇锛�
+   - `round(v, 4)`锛氳揣杩愯涓�/瑙勪笅/鍚屾瘮銆佺疮璁′笌褰撴湀銆佷腑鍙ｅ緞鎺掑悕/鍒嗘瀽銆乣梅10000` 鍗曚綅鎹㈢畻銆佹姇璧勮繘搴︺�佺墿娴佸崰姣斻�佹姇璧勮鍒掍竾鍚紱
+   - `round(v, 2)`锛氶�氱敤鏁版嵁鏍� `setDataCell`銆佸钩鍧囪繍璺濆厹搴曘�佸杩愯浆杩愬啓鍏ワ紱
+   - `round(v, 1)`锛氭帓鍚嶉〉鍗犳瘮锛坄setFreightShare`銆佽揣杩愰噺鎺掑悕/鍛ㄨ浆閲忔帓鍚嶅潡锛夈��
+   璇樊铏藉皬锛屼絾灞炰簬銆岃绠楀彛寰勮鍐欐銆嶏紝涓庝汉宸ョ敤鍏ㄧ簿搴﹂噸绠楃殑缁撴灉澶╃劧瀵逛笉涓婏紙姝ｆ槸 09-19 涓彛寰勫樊寮傞棶棰樼殑鍚屾簮椋庨櫓锛夈��
+2. 姣嶇増涓埆鏍艰嚜甯� 3~4 浣嶅皬鏁�**鏄剧ず鏍煎紡**锛坄0.0000_);[Red]\(0.0000\)`銆乣0.000_ `锛夛紝灞曠ず浣嶆暟涓嶇粺涓�銆�
+
+**鏀瑰悗瀹炵幇**锛�
+
+1. **鍏ㄧ簿搴�**锛氬彇娑堟墍鏈夊啓鍏�/杩愮畻鍓嶇殑棰勮垗鍏ワ紝鏁板�间互 `double` 鍘熷�煎弬涓庤繍绠楀苟鍐欏叆锛沗/10000`銆佸崰姣斻�佸悓姣斻�佸钩鍧囪繍璺濆厹搴曠瓑涓�寰嬩笉鎴柇銆�
+2. **涓や綅灏忔暟灞曠ず**锛氱敱鍗曞厓鏍兼暟瀛楁牸寮忔壙鎷呫�傞噸鍐� `applyTwoDecimalFormat()`锛�
+   - 鏁板�兼牸鏍煎紡缁熶竴涓� `0.00`锛坄cloneStyleFrom` 淇濈暀杈规/瀛椾綋/瀵归綈锛屽彧鎹㈡暟瀛楁牸寮忥紝`;[Red]\(...\)` 绛夊墠鍚庣紑鍘熸牱淇濈暀锛夛紱
+   - **3 浣嶅強浠ヤ笂灏忔暟鐨勬牸寮�**锛坄0.000_ `銆乣0.0000_);[Red]\(0.0000\)`锛夌敤姝ｅ垯 `\.0{3,}` 鏀舵暃涓� `.00`锛�
+   - 鐧惧垎姣旓紙`%`锛夈�佺瀛﹁鏁帮紙`E`锛夈�佹枃鏈紙`@`锛夈�佹棩鏈熸牸寮�**涓嶅姩**锛�
+   - 鏁存暟鍊兼牸娌跨敤鏃㈡湁绾﹀畾涓嶆樉绀� `.00`锛堝骞翠唤銆佹帓鍚嶏級銆�
+3. 鎺у埗鍙�/鎺ュ彛杩斿洖鐨�**棰勮鎽樿**閲岀殑 `round`锛坄addSum(...)`锛変繚鐣欙紝瀹冧笉杩涙姤琛ㄦ暟鎹��
+
+**鏀瑰姩鏂囦欢**锛�
+
+| 鏂囦欢 | 鏀瑰姩 |
+| --- | --- |
+| `traffic-audit-server/src/main/java/com/trafficaudit/reportexport/service/ReportExportService.java` | 鍘婚櫎 40 澶勯鑸嶅叆锛涢噸鍐� `applyTwoDecimalFormat()`锛堟柊澧� `DEC_MORE_THAN_TWO` 姝ｅ垯甯搁噺锛� |
+| `traffic-audit-server/src/main/java/com/trafficaudit/reportexport/calc/WycSplitCalc.java` | 骞冲潎杩愯窛鍏滃簳鏀瑰叏绮惧害锛涘垹闄ゅ凡鏃犲紩鐢ㄧ殑绉佹湁 `round(double,int)` |
+
+## 浜屻�佹祴璇曠幆澧�
+
+| 椤� | 鍐呭 |
+| --- | --- |
+| 鍚庣 | Spring Boot `localhost:8090`锛宍mvn -q -o compile` 閫氳繃鍚庣敱 `start-dev.ps1` 閲嶅惎锛圥ID 15568锛� |
+| 鍓嶇 | Vue `localhost:8080`锛圥ID 28608锛夛紝涓庡悗绔竴骞堕噸鍚� |
+| 鏁版嵁搴� | MySQL `localhost:3308/traffic_audit` |
+| 鎶ヨ〃鏈� | 2026-08锛�1-8 鏈堢疮璁″潡 + 8 鏈堝崟鏈堝潡锛� |
+| 瀵圭収浠� | 鏀瑰墠鐢熸垚浠� `_after_busfix_2026-08.xlsx`锛�09-19 鍙ｅ緞淇鍚庛�佹湰娆℃敼閫犲墠锛� |
+| 鏀瑰悗鐢熸垚浠� | `_after_precision_2026-08.xlsx`銆乣_after_precision_midrank/midana/middetail.xlsx`锛屼互鍙� `_out_precision\` 涓� 22 涓帴鍙ｄ骇鐗� |
+| 鍙栬瘉鑴氭湰 | `_qa_prec_*.py`銆乣_regen_precision.ps1`銆乣_regen_all.ps1` |
+
+## 涓夈�佺敤渚嬩笌缁撴灉
+
+| 缂栧彿 | 绫诲瀷 | 杈撳叆 | 棰勬湡 | 瀹為檯 | 缁撹 |
+| --- | --- | --- | --- | --- | --- |
+| T1 | 姝ｅ悜 | `mvn -q -o compile` | 缂栬瘧閫氳繃 | exit=0锛屾棤鍛婅 | 閫氳繃 |
+| T2 | 姝ｅ悜 | 22 涓鍑烘帴鍙ｏ紙period=2026-08锛� | 鍏ㄩ儴 200 涓旈潪绌� | 21 涓� OK锛沗wycSplit` 500锛堢己杈撳叆鏂囦欢锛岃銆屽洓-5銆嶏級 | 閫氳繃 |
+| T3 | 姝ｅ悜 | 鏀瑰墠/鏀瑰悗銆婇亾璺繍杈撻噺姹囨�昏〃銆嬮�愭牸鏁板�煎姣旓紙66205 涓叡鏈夋暟鍊兼牸锛� | 浠呯洰鏍囨牸鍑虹幇宸紓 | 瀹為檯鍙樺寲 **249 鏍�**锛屽叏閮ㄨ惤鍦ㄣ�岃揣杩愰噺鎺掑悕銆�107 +銆屼腑鍙ｅ緞鎺掑悕銆�142 | 閫氳繃 |
+| T4 | 姝ｅ悜 | 鏈�澶у彉鍖栭噺 | 鍙簲鏄幓鎺夎垗鍏ュ甫鏉ョ殑灏炬暟宸� | **0.00022 涓囦汉鍏噷**锛�=2 浜哄叕閲岋級锛屼綅缃�屼腑鍙ｅ緞鎺掑悕銆嶅叏鐪佽 O3 | 閫氳繃 |
+| T5 | 姝ｅ悜 | 姝︽眽绱鍛ㄨ浆閲� | 鍏ㄧ簿搴︿繚鐣欙紝4 浣嶅皬鏁颁綅浠嶄负 8912 | 涓彛寰勬槑缁� S104 = 152330.89119999998锛涙帓鍚嶉〉 O4 / 閬撹矾杩愯緭鍛ㄨ浆閲� Q5 = 152330.8912 | 閫氳繃 |
+| T6 | 姝ｅ悜 | 瀛濇劅绱鍛ㄨ浆閲� | 涓嶅啀鎴柇鍒� 64429.9445 | 64429.944543113306锛堟帓鍚嶉〉涓庢槑缁嗛〉閫愪綅涓�鑷达級 | 閫氳繃 |
+| T7 | 姝ｅ悜 | 銆屼腑鍙ｅ緞鎺掑悕銆嶆敼鍓�/鏀瑰悗鎸変袱浣嶅皬鏁板姣� | 瀹屽叏涓�鑷达紙涓嶅簲鏀瑰彉鍙缁撴灉锛� | 涓嶄竴鑷存牸 **0** | 閫氳繃 |
+| T8 | 姝ｅ悜 | 鍏ㄧ渷琛� `=SUM(O4:O20)` 闂悎 | 缂撳瓨鍊� = 17 甯傚窞鍏ㄧ簿搴︽眰鍜� | 1227147.4890200002锛�**宸� 0.0**锛�09-19 鐨� 0.0002 娈嬬暀宸叉秷闄わ級 | 閫氳繃 |
+| T9 | 姝ｅ悜 | 姹囨�诲ぇ琛ㄣ�屾湁鍊兼暟鍊�/鍏紡鏍笺�嶇殑 3 浣嶄互涓婂皬鏁版牸寮� | 0 鏍� | 鏀瑰墠 108 鏍� 鈫� 鏀瑰悗 **0 鏍�** | 閫氳繃 |
+| T10 | 姝ｅ悜 | 涓彛寰勬槑缁嗭紙鐙珛浠讹級`0.000_ ` 鏍煎紡鏍� | 鏀舵暃涓轰袱浣� | 鏀瑰墠 134 鏍� 鈫� 鏀瑰悗 **0 鏍�**锛汣19 鍊� 13.599765541547498 涓嶅彉锛屾牸寮忓彉 `0.00_ ` | 閫氳繃 |
+| T11 | 姝ｅ悜 | 22 涓骇鐗╃殑 3 浣嶄互涓婂皬鏁版牸寮忔眹鎬� | 鍏ㄤ负 0 | 15 涓彲瑙ｆ瀽浜х墿鍚堣 **0 鏍�** | 閫氳繃 |
+| T12 | 鍥炲綊 | 琛ㄥ唴閿欒鍊硷紙`#DIV/0!`/`#VALUE!`/`#REF!`锛夋暟閲� | 涓嶆柊澧� | 鏀瑰墠 589 = 鏀瑰悗 589锛堝垎甯冮�愰」鐩稿悓锛� | 閫氳繃 |
+| T13 | 鍥炲綊 | 鐧惧垎姣旀牸 / 涓や綅灏忔暟鏍兼暟閲� | 涓嶅彈褰卞搷 | 25665 / 39552锛屼笌鏀瑰墠涓�鑷� | 閫氳繃 |
+| T14 | 鍥炲綊 | 鐙珛浠� `passengerMidRank`銆乣passengerMidAnalysis` | 鏃� 3 浣嶄互涓婂皬鏁版牸寮� | 0 鏍硷紙鏀瑰墠鏈氨 0锛� | 閫氳繃 |
+| T15 | 杈圭晫 | 绌哄�兼牸銆佹枃鏈牸锛堝鏈堜唤鏂囨湰銆�2023骞�4鏈堛�嶏級 | 涓嶅姩 | 浠嶅甫 4 浣嶅皬鏁版牸寮� 274 鏍硷紙260 绌哄�� + 14 鏂囨湰锛夛紝鏃犳樉绀哄�硷紝涓嶅鐞� | 閫氳繃 |
+| T16 | 杈圭晫 | 鏁存暟鍊兼牸锛堝勾浠�/鎺掑悕锛� | 涓嶆樉绀� `.00` | 娌跨敤鏃㈡湁銆屾暣鏁颁笉鏄剧ず .00銆嶄繚鎶わ紝鏈鏈鏀瑰姩鐮村潖 | 閫氳繃 |
+| T17 | 杈圭晫 | 涓� `round(鏀瑰悗,4)` 涓嶄竴鑷寸殑 30 鏍� | 灞炰簩闃堕噸绠楄�岄潪閿欒 | 鍚屾瘮鍒楃敱鍏ㄧ簿搴﹀垎瀛愬垎姣嶉噸绠楋紝閲忕骇 1e-9~1e-8锛堝 0.0712378390 鈫� 0.0712378363锛� | 閫氳繃 |
+| T18 | 璐熷悜 | 姣嶇増鎺掑悕椤� Q 鍒楀叕寮� `=ROUND(B/L*10,1)` | 鏈涓嶆敼姣嶇増 | 浠嶄繚鐣欙紙36脳2 鏍硷級锛孍xcel 鎵撳紑浼氭寜鍏紡閲嶇畻鍒� 1 浣嶅悗鍐嶆寜 `0.00` 灞曠ず | 瑙併�屽洓-4銆嶅緟鎷嶆澘 |
+
+## 鍥涖�佸彂鐜扮殑闂涓庡缃�
+
+1. **姣嶇増甯� 4 浣嶅皬鏁版牸寮忕殑鏈夊�兼牸 108 涓�**锛坄璐ц繍!EO90/EO93/EO108/EO111` 绛� SUM 鍏紡鏍笺�乣鍏矾鎬诲杩�!DE2` 绛夛級鈫� 宸茬敱鏍煎紡褰掍竴澶勭悊涓� `0.00`锛涘墿浣欏甫璇ユ牸寮忕殑 274 鏍煎潎涓虹┖鍊�/鏂囨湰鏍硷紝鏃犳樉绀哄�笺��
+2. **銆屾暣鏁颁笉鏄剧ず .00銆嶄繚鎶ゅ厛鎶婂叕寮忔牸璺宠繃浜�**锛氶杞敼閫犲悗 `璐ц繍!EO90/EO93/EO108/EO111` 浠嶆槸 `0.0000`锛堢紦瀛樺�间负 0锛岃鍒ゅ畾涓烘暣鏁拌�岃烦杩囷級銆傚凡鎶娿��3 浣嶄互涓婂皬鏁版牸寮忓綊涓�銆嶇殑鍒ゆ柇**鎻愬埌鏁存暟淇濇姢涔嬪墠**鈥斺�旇繖绫绘牸鏈潵灏辫蛋鏁板�兼牸寮忓睍绀猴紝涓庛�孏eneral 鐨勬暣鏁板�间笉鏄剧ず .00銆嶄笉鍐茬獊銆�
+3. **3 浣嶅皬鏁版牸寮忔湭琚瘑鍒�**锛坄0.000_ `锛夛細鍘熷垽鏂敤 `f.contains("0.00")` 璁や负宸叉槸涓や綅锛岃�� `0.000_ ` 鎭板ソ鍖呭惈瀛愪覆 `0.00` 鑰岃璺宠繃锛屽鑷翠腑鍙ｅ緞鏄庣粏 134 鏍兼紡鏀广�傚凡鏀逛负姝ｅ垯 `\.0{3,}` 缁熶竴鏀舵暃銆�
+4. **姣嶇増鎺掑悕椤� Q 鍒椾粛鏄� `=ROUND(B/L*10,1)`**锛堣揣杩愰噺鎺掑悕 Q4:Q42銆佽揣杩愬懆杞噺鎺掑悕 Q5:Q44锛屽叡 72 鏍硷級锛�
+   绋嬪簭瀵瑰叕寮忔牸涓�寰嬩笉瑕嗗啓锛堜繚鐣欐瘝鐗堝叕寮忚璁★級锛孍xcel/WPS 鎵撳紑鏃朵細鎸夊叕寮忛噸绠楀洖 1 浣嶅皬鏁板啀浠� `0.00` 鏍煎紡灞曠ず銆�
+   鑻ヨ杩炶繖 72 鏍间篃鍏ㄧ簿搴︼紝闇�瑕佹妸涓変釜姣嶇増鐨勫叕寮忔敼鎴� `=B/L*10`锛堝苟鍚屾 R 鍒� `=10-Q`锛夆�斺��**寰呯敤鎴风‘璁ゅ悗鍐嶅姩姣嶇増**銆�
+5. **`wycSplit` 鎺ュ彛 500**锛歚loadWycMonthlyInput()` 鎶涖�屾湭鎵惧埌缃戠粶绾﹁溅锛堝叏鐪侊級姹囨��.xlsx锛岃鏀惧埌 docs/缃戠粶瀹㈣繍 鐩綍銆嶏紝鑰� `docs\缃戠粶瀹㈣繍` 鐩綍褰撳墠涓嶅瓨鍦ㄢ�斺�斿睘**缂鸿緭鍏ユ暟鎹殑鏃㈡湁鐜拌薄**锛屼笌鏈鏀归�犳棤鍏炽��
+
+## 浜斻�佺粨璁�
+
+- 鎶ヨ〃鏁板�煎凡鍏ㄩ儴鏀逛负**鍏ㄧ簿搴﹀啓鍏�/杩愮畻**锛屽睍绀轰綅鏁扮粺涓�鐢卞崟鍏冩牸鏍煎紡鎵挎媴锛堜袱浣嶅皬鏁帮紱鐧惧垎姣斻�佹棩鏈熴�佹枃鏈牸寮忎笉鍙橈級銆�
+- 閫愭牸瀵规瘮璇佸疄锛氭敼鍚庝笌鏀瑰墠鐨勫彲瑙佺粨鏋滐紙涓や綅灏忔暟鍙ｅ緞锛�**瀹屽叏涓�鑷�**锛屽樊寮備粎鍑虹幇鍦ㄨ鍘绘帀鑸嶅叆鐨勫熬鏁颁綅锛屾渶澶� 0.00022 涓囦汉鍏噷銆�
+- 椤哄甫娑堥櫎浜� 09-19 閬楃暀鐨勩�屽叏鐪佽 0.0002 涓囦汉鍏噷銆嶏細鍚勫競宸炴敼涓哄叏绮惧害鍚庯紝姣嶇増鍏紡 `=SUM(O4:O20)` 涓庢槑缁嗗叏绮惧害姹傚拰**閫愪綅闂悎**銆�
+- 22 涓鍑烘帴鍙ｅ洖褰掗�氳繃锛坄wycSplit` 涓烘棦鏈夌己鏁版嵁闂锛夛紱閿欒鍊兼暟閲忋�佺櫨鍒嗘瘮鏍兼暟閲忓潎鏃犲彉鍖栥��
+- 閬楃暀涓�椤瑰緟鎷嶆澘锛氭瘝鐗堟帓鍚嶉〉 Q/R 鍗犳瘮鍏紡鐨� `ROUND(...,1)`銆�
+
+娴嬭瘯浜猴細Codex锛圓I锛夈��娴嬭瘯鏃ユ湡锛�2026-09-20

--
Gitblit v1.9.1