From 47a873454ed83a184c55dd7ee904375cee3d7386 Mon Sep 17 00:00:00 2001 From: xyc <jc_xiong@hotmail.com> Date: 星期一, 21 九月 2026 13:08:00 +0800 Subject: [PATCH] docs: 新增汇总大表软件输出与手工定稿差异报告 --- docs/功能测试报告/功能测试报告_汇总大表软件输出与手工定稿差异_2026-09-21.md | 181 +++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 181 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\350\275\257\344\273\266\350\276\223\345\207\272\344\270\216\346\211\213\345\267\245\345\256\232\347\250\277\345\267\256\345\274\202_2026-09-21.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\350\275\257\344\273\266\350\276\223\345\207\272\344\270\216\346\211\213\345\267\245\345\256\232\347\250\277\345\267\256\345\274\202_2026-09-21.md" new file mode 100644 index 0000000..fe440b4 --- /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\350\275\257\344\273\266\350\276\223\345\207\272\344\270\216\346\211\213\345\267\245\345\256\232\347\250\277\345\267\256\345\274\202_2026-09-21.md" @@ -0,0 +1,181 @@ +# 姹囨�诲ぇ琛ㄨ蒋浠惰緭鍑轰笌鎵嬪伐瀹氱宸紓锛�2026-08锛� + +> 姣斿鏃ユ湡锛�2026-09-21 +> 鑼冨洿锛氭姤琛ㄧ敓鎴� 鈫� 姹囨�诲ぇ琛� +> 鍘熷垯锛氭寜鈥滃湴鍖� + 鎸囨爣 + 鏃堕棿鍙ｅ緞鈥濆榻愶紝蹇界暐鍒楀銆佸悎骞跺崟鍏冩牸銆侀〉绛鹃『搴忋�佸湴鍖哄悕鈥滃競/宸炩�濆悗缂�绛夌函鐗堝紡宸紓 + +## 涓�銆佹瘮瀵规簮鏂囦欢 + +| 绫诲瀷 | 鏂囦欢 | SHA256 | +| --- | --- | --- | +| 杞欢杈撳嚭 | `D:\03_鍏徃\02_椤圭洰\27_婀栧寳鐪侀亾璺繍杈撲簨涓氬彂灞曚腑蹇僜05_寮�鍙戞祴璇昞01_娴嬭瘯\01_鎶ヨ〃鐢熸垚\姹囨�诲ぇ琛╘杞欢杈撳嚭\鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃_2026-08 (5).xlsx` | `7FC047FA5B64B377798072ECFBC157F9F1CFA2D4D7651A6069A5AC9E4FE05F44` | +| 鎵嬪伐瀹氱 | `D:\03_鍏徃\02_椤圭洰\27_婀栧寳鐪侀亾璺繍杈撲簨涓氬彂灞曚腑蹇僜05_寮�鍙戞祴璇昞01_娴嬭瘯\01_鎶ヨ〃鐢熸垚\姹囨�诲ぇ琛╘鎵嬪伐璁＄畻\2026骞�8鏈堝杩愰噺銆佽揣杩愰噺瀹氱.xlsx` | `3C96F2EC286CFAC0C966FE0C403924F1E2E8C3691E17E553F24B22E52737F1FD` | + +涓や唤鏂囦欢鍧囨湁 19 涓〉绛撅紝鍚嶇О涓�鑷淬�� + +## 浜屻�佺粨璁烘憳瑕� + +1. 2026 骞� 1-8 鏈堟湰鏈熸牳蹇冩暟鎹湭鍙戠幇鏂扮殑涓氬姟鍐茬獊銆� +2. `涓彛寰勬帓鍚峘 榛勫唸瀹㈣繍閲忕疮璁″悓姣斿綋鍓嶄负 `7.641733%`锛屼笌鎵嬪伐瀹氱涓�鑷达紝鍘� `7.74%` 闂鏈湪杩欎唤杞欢杈撳嚭涓鐜般�� +3. 涓昏闂闆嗕腑鍦細 + - `鍏氦`銆乣鍑虹`銆乣缃戠害杞 鐨� 2025 骞寸疮璁″垪 `U` 灏戝姞 7 鏈堛��8 鏈堛�� + - `鐝嚎鍖呰溅` 2019-2020 骞村巻鍙插悓姣斻�佺疮璁″叕寮忓ぇ閲忚繑鍥� `#VALUE!`銆� + - ` 璐ц繍` 2022 骞翠粰妗冦�佹綔姹熴�佸ぉ闂ㄣ�佹灄鍖虹殑绱鍚屾瘮瀛樺湪鏄庢樉宸紓銆� + - 杞欢棰濆鍖呭惈閮ㄥ垎 8 鏈堝潡鍜屽競宸炶揣杩愯銆� + +## 涓夈�侀�愰〉娓呭崟 + +| 椤电 | 鏁版嵁宸紓 | 缁撴瀯/鐗堝紡宸紓 | +| --- | --- | --- | +| ` 璐ц繍` | 鍏卞悓涓氬姟閿樊寮� 82 涓� | 姣忎釜甯傚窞杞欢澶� 2 琛屾寚鏍� | +| `璐ц繍閲忔帓鍚峘 | 鏈彂鐜板叡浜暟鍊煎樊寮� | 绱鍧椼��8 鏈堝潡椤哄簭涓嶅悓锛屾爣棰樺拰琛ㄥご鏂囧瓧涓嶅悓 | +| `璐ц繍鍛ㄨ浆閲忔帓鍚峘 | 鏈彂鐜板叡浜暟鍊煎樊寮� | 鍧楅『搴忋�佹爣棰樸�佽〃澶存枃瀛椾笉鍚� | +| `鍏矾鎬诲杩恅 | 鏈彂鐜颁笟鍔″樊寮� | 鍩烘湰涓�鑷� | +| `鐝嚎鍖呰溅` | 212 涓巻鍙插叡鍚屼笟鍔￠敭涓嶅悓 | 杞欢閿欒鍊兼暟閲忔槑鏄炬洿澶� | +| `鍩庡競瀹㈣繍` | 2026 骞村綋鏈熴�佺疮璁′竴鑷� | 灏戦噺鍗曞厓鏍肩被鍨嬨�佺┖鐧藉垪宸紓 | +| `鍩庡競姹囨�籤 | 鍏变韩鏁版嵁涓�鑷� | 杞欢澶� 2026 骞� 8 鏈堝潡 | +| `鍩庡競鍒嗗競宸瀈 | 鍏变韩鏁版嵁涓�鑷� | 杞欢澶� 8 鏈堝杩愰噺銆佸懆杞噺鍧� | +| `鍏氦` | `U5:U76` 鍏� 72 涓�间笉鍚� | 灏戦噺鈥滄暟鍊� vs 鍚屽�兼枃鏈�濆樊寮� | +| `鍑虹` | `U5:U76` 鍏� 72 涓�间笉鍚� | 鍩烘湰涓�鑷� | +| `缃戠害杞 | `U5:U76` 鍏� 72 涓�间笉鍚� | `BW3` 澶氫竴涓┖鏍� | +| `杞ㄩ亾銆佽疆娓 | 鏁板�间竴鑷� | `R2/R11` 琛ㄥご鏂囧瓧涓嶅悓 | +| `涓彛寰勬槑缁哷 | 鏈彂鐜版柊澧炰笟鍔″樊寮� | 涓よ竟鍘熸湁 `#DIV/0!`銆乣#REF!` 鐩稿悓 | +| `涓彛寰勬帓鍚峘 | 鏁板�间竴鑷� | 绱鍧椼��8 鏈堝潡鏀剧疆浣嶇疆涓嶅悓 | +| `涓彛寰勫垎鏋恅 | 1-8 鏈堝叡浜暟鍊间竴鑷� | 杞欢澶� 8 鏈堝潡 | +| `2025骞村煄甯傚杩愰噺` | 涓�鑷� | 鏈彂鐜板樊寮� | +| `閬撹矾杩愯緭鍛ㄨ浆閲廯 | 鏁板�间竴鑷� | 杞欢 `A23` 灏戔�滅疮璁♀�濅簩瀛� | +| `涓彛寰勫杩愰噺` | 鏈彂鐜版柊澧炰笟鍔″樊寮� | 鍘熸湁閿欒鍊肩浉鍚� | +| `涓彛寰勮绠楄繃绋媊 | 涓�鑷� | 鏈彂鐜板樊寮� | + +## 鍥涖�侀渶瑕佸鐞嗙殑鏁板�煎樊寮� + +### 4.1 鍏氦銆佸嚭绉熴�佺綉绾﹁溅 2025 骞寸疮璁″垪 + +涓変釜椤电鐨� `U5:U76` 鍧囨湁宸紓銆傝蒋浠跺叕寮忓皯鍔� 2025 骞� 7 鏈堛��8 鏈堛�� + +- 杞欢鍏紡锛歚=V5+X5+Z5+AB5+AD5+AF5` +- 鎵嬪伐鍏紡锛歚=V5+X5+Z5+AB5+AD5+AF5+AH5+AJ5` + +浠ｈ〃鍊硷細 + +| 椤电/鍗曞厓鏍� | 杞欢 | 鎵嬪伐 | +| --- | ---: | ---: | +| `鍏氦!U5` | 88908.91 | 114285.68 | +| `鍑虹!U5` | 39797.94 | 52461.16 | +| `缃戠害杞�!U5` | 16384.07 | 22474.11 | + +褰卞搷鑼冨洿锛氬叏鐪佽鍙� 17 涓競宸炶銆� + +### 4.2 鐝嚎鍖呰溅鍘嗗彶鍏紡 + +`鐝嚎鍖呰溅` 鍏变韩涓氬姟閿樊寮傚叡 212 涓紝闆嗕腑鍦� 2019-2020 骞达細 + +| 鏃堕棿/鍙ｅ緞 | 鏁伴噺 | 杞欢 | 鎵嬪伐 | +| --- | ---: | --- | --- | +| 2020 骞� 7-12 鏈堝悓姣� | 101 | `#VALUE!` | 鏁板�� | +| 2020 骞寸疮璁″悓姣� | 18 | `#VALUE!` | 鏁板�� | +| 2019 骞� 10-12 鏈堝悓姣� | 51 | `#VALUE!` | 鏁板�� | +| 2019 骞寸疮璁� | 18 | `#VALUE!` | 鏁板�� | +| 2019 骞寸疮璁″悓姣� | 18 | `#VALUE!` | 鏁板�� | +| 2019 骞� 7-12 鏈堝叏鐪佹梾瀹㈠懆杞噺 | 6 | `#VALUE!` | 鏁板�� | + +涓昏琛屽彿锛� + +```text +5,9,11,15,19,23,27,29,33,37,39,43,45,49,51,53,55,57 +``` + +閿欒鍊兼�绘暟锛� + +| 鏂囦欢 | `#VALUE!` | `#DIV/0!` | `#REF!` | +| --- | ---: | ---: | ---: | +| 杞欢杈撳嚭 | 220 | 228 | 8 | +| 鎵嬪伐瀹氱 | 0 | 228 | 14 | + +`#DIV/0!` 涓よ竟鍚屼綅缃浉鍚岋紝涓嶄綔涓烘柊澧炲樊寮傘�� + +### 4.3 璐ц繍鍘嗗彶绱鍚屾瘮 + +` 璐ц繍` 鍏卞悓涓氬姟閿樊寮� 82 涓紝鍏朵腑 12 涓緝鏄庢樉锛岄泦涓负 2022 骞寸疮璁″悓姣旓細 + +| 鍦板尯 | 鎸囨爣 | 杞欢 | 鎵嬪伐 | 宸紓 | +| --- | --- | ---: | ---: | ---: | +| 浠欐 | 瑙勪笂+瑙勪笅鍛ㄨ浆閲� | -1.471689% | 8.617594% | 10.089283pp | +| 澶╅棬 | 瑙勪笂+瑙勪笅鍛ㄨ浆閲� | -4.232817% | 5.926169% | 10.158987pp | +| 娼滄睙 | 瑙勪笂+瑙勪笅鍛ㄨ浆閲� | -5.808659% | 2.480550% | 8.289209pp | +| 鏋楀尯 | 瑙勪笂+瑙勪笅鍛ㄨ浆閲� | -4.778444% | 9.515814% | 14.294258pp | +| 浠欐 | 瑙勪笅璐х墿鍛ㄨ浆閲� | -1.471689% | 8.617594% | 10.089283pp | +| 澶╅棬 | 瑙勪笅璐х墿鍛ㄨ浆閲� | -6.256225% | 3.550085% | 9.806311pp | +| 娼滄睙 | 瑙勪笅璐х墿鍛ㄨ浆閲� | -11.356123% | -3.697089% | 7.659034pp | +| 鏋楀尯 | 瑙勪笅璐х墿鍛ㄨ浆閲� | -22.284817% | -10.618542% | 11.666275pp | +| 澶╅棬 | 瑙勪笂璐ц繍閲� | 7.614997% | 19.730403% | 12.115406pp | +| 娼滄睙 | 瑙勪笂璐ц繍閲� | 17.927552% | 28.216438% | 10.288885pp | +| 浠欐 | 瑙勪笂璐х墿鍛ㄨ浆閲� | 绌虹櫧 | `#DIV/0!` | 鍏紡閿欒澶勭悊涓嶅悓 | +| 鏋楀尯 | 瑙勪笂璐х墿鍛ㄨ浆閲� | 绌虹櫧 | `#DIV/0!` | 鍏紡閿欒澶勭悊涓嶅悓 | + +鍏朵綑 70 涓樊寮備綅浜� 2021-2024 骞村叏鐪佹眹鎬汇�佸悓姣旇緟鍔╁垪锛屾渶澶х粷瀵瑰樊绾� `0.0047`锛屽鏁版樉绀轰袱浣嶅皬鏁板悗鐪嬩笉鍑哄樊鍒�� + +### 4.4 璐ц繍缁撴瀯宸紓 + +杞欢姣忎釜甯傚窞鏈� 6 琛屾寚鏍囷細 + +- 瑙勪笂+瑙勪笅璐ц繍閲� +- 瑙勪笂璐ц繍閲� +- 瑙勪笅璐ц繍閲� +- 瑙勪笂+瑙勪笅鍛ㄨ浆閲� +- 瑙勪笂璐х墿鍛ㄨ浆閲� +- 瑙勪笅璐х墿鍛ㄨ浆閲� + +鎵嬪伐姣忎釜甯傚窞鍙湁 4 琛岋細 + +- 瑙勪笂璐ц繍閲� +- 瑙勪笂+瑙勪笅鍛ㄨ浆閲� +- 瑙勪笂璐х墿鍛ㄨ浆閲� +- 瑙勪笅璐х墿鍛ㄨ浆閲� + +杞欢澶氬嚭鐨勫競宸炴寚鏍囦负鈥滆涓�+瑙勪笅璐ц繍閲忊�濆拰鈥滆涓嬭揣杩愰噺鈥濓紝鍏� 17 涓競宸� 脳 2 琛屻�� + +## 浜斻�佺粨鏋勫樊寮� + +| 椤电 | 杞欢杈撳嚭 | 鎵嬪伐瀹氱 | 璇存槑 | +| --- | --- | --- | --- | +| `鍩庡競姹囨�籤 | 澶� `A12:E20` | 鏃� | 杞欢澶� 2026 骞� 8 鏈堟眹鎬诲潡 | +| `鍩庡競鍒嗗競宸瀈 | 澶� `A46:Y89` | 鍒扮 44 琛� | 杞欢澶� 8 鏈堝杩愰噺銆佸懆杞噺鍧� | +| `涓彛寰勫垎鏋恅 | 澶� `A10:H16` | 鍒扮 7 琛� | 杞欢澶� 8 鏈堜腑鍙ｅ緞鍧� | +| `涓彛寰勬帓鍚峘 | `J1:R20` 绱銆乣J22:R41` 8 鏈� | `J1:R20` 绱銆乣A2:H20` 8 鏈� | 鏁版嵁瀵瑰簲锛屼粎甯冨眬涓嶅悓 | +| `璐ц繍閲忔帓鍚峘 | 绱鍧楀湪鍓� | 8 鏈堝潡鍦ㄥ墠 | 鍏变韩鏁板�间竴鑷� | +| `璐ц繍鍛ㄨ浆閲忔帓鍚峘 | 绱鍧楀湪鍓� | 8 鏈堝潡鍦ㄥ墠 | 鍏变韩鏁板�间竴鑷� | + +## 鍏�佷粎鐗堝紡鎴栨枃鏈樊寮� + +- `閬撹矾杩愯緭鍛ㄨ浆閲�!A23` + - 杞欢锛歚2026骞�8鏈堝叏鐪佸畬鎴愪氦閫氬懆杞噺鎯呭喌` + - 鎵嬪伐锛歚2026骞�8鏈堝叏鐪佺疮璁″畬鎴愪氦閫氬懆杞噺鎯呭喌` +- `杞ㄩ亾銆佽疆娓�!R2/R11` + - 杞欢锛歚8鏈堜笌鍘诲勾鍚屾瘮` + - 鎵嬪伐锛歚鍚屾瘮` +- 鍦板尯鍚嶁�滄姹� / 姝︽眽甯傗�濈瓑鍚庣紑宸紓銆� +- 鏁板�煎崟鍏冩牸涓庡悓鍊兼枃鏈崟鍏冩牸宸紓銆� +- 鍒楀銆佸悎骞跺崟鍏冩牸銆佺┖鐧藉垪銆侀〉绛惧唴灏戦噺澶氫綑绌烘牸銆� +- ` 璐ц繍`銆乣鐝嚎鍖呰溅`銆乣璐ц繍閲忔帓鍚峘銆乣璐ц繍鍛ㄨ浆閲忔帓鍚峘 鐨勬爣棰樺拰琛ㄥご鎺緸宸紓銆� + +## 涓冦�佹湭鍙戠幇鏂板涓氬姟宸紓鐨勯〉绛� + +浠ヤ笅椤电鍦ㄦ湰杞瘮瀵逛腑鏈彂鐜版柊澧炰笟鍔℃暟鍊煎樊寮傦細 + +- `鍏矾鎬诲杩恅 +- `鍩庡競瀹㈣繍`锛�2026 骞存湰鏈熸暟鎹級 +- `涓彛寰勬槑缁哷 +- `涓彛寰勫杩愰噺` +- `2025骞村煄甯傚杩愰噺` +- `涓彛寰勮绠楄繃绋媊 + +鍏朵腑 `涓彛寰勬槑缁哷銆乣涓彛寰勫杩愰噺` 涓よ竟鍘熸湁 `#DIV/0!`銆乣#REF!` 浣嶇疆涓�鑷达紝涓嶅睘浜庢湰杞柊澧炲樊寮傘�� + +## 鍏�佸缓璁紭鍏堢骇 + +1. 淇� `鍏氦`銆乣鍑虹`銆乣缃戠害杞 鐨� 2025 骞寸疮璁″叕寮忥紝琛� 7 鏈堛��8 鏈堛�� +2. 淇� `鐝嚎鍖呰溅` 2019-2020 骞村巻鍙插悓姣斿拰绱鍏紡锛屽厛澶勭悊 212 涓叡浜笟鍔￠敭宸紓銆� +3. 鏍� ` 璐ц繍` 2022 骞村洓涓湴鍖虹殑绱鍚屾瘮鍩烘暟銆� +4. 纭 ` 璐ц繍` 甯傚窞鏄惁淇濈暀鈥滆涓�+瑙勪笅璐ц繍閲忊�濃�滆涓嬭揣杩愰噺鈥濅袱琛屻�� +5. 鍏朵綑涓昏涓虹増寮忓拰鍘嗗彶杈呭姪灏惧樊锛屽彲鎸変笟鍔＄‘璁ゅ悗鍐嶅鐞嗐�� \ No newline at end of file -- Gitblit v1.9.1