From 0acd500f0a2e2e34ff199472dd5575723afb6358 Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期日, 27 九月 2026 17:48:04 +0800
Subject: [PATCH] fix(汇总表母版): 157 格文本型数字改为数值(公交 AF/M 各68 + G 17、轨道轮渡 4)；重新生成验证仅 68 格类型变化、值不变。并记录排名页块顺序/辅助列定位

---
 HANDOFF.md |   25 +++++++++++++++++++++++++
 1 files changed, 25 insertions(+), 0 deletions(-)

diff --git a/HANDOFF.md b/HANDOFF.md
index eec213e..2da0b05 100644
--- a/HANDOFF.md
+++ b/HANDOFF.md
@@ -31,7 +31,32 @@
         路 鍋氭硶锛氱洿鎺ユ敼 xlsx 鍐呴儴 XML锛堝彧鍘诲搴斿崟鍏冩牸鐨� `<f>/<v>`銆佷繚鐣欐牱寮忥級锛�**閬垮厤 openpyxl 淇濆瓨瀵艰嚧鍏ㄧ翱鍏紡缂撳瓨鍊间涪澶�**锛堣鍧戝凡瀹炴祴澶嶇幇锛氱敤 openpyxl 瀛樹竴娆″悗 `鍏氦!S5` 鐢� 98460.97 鍙� None锛屼細鐮村潖"涓彛寰勬帓鍚嶇敤姣嶇増 2025 闈欐�佸垪"锛夈��
         路 楠岃瘉锛氶噸鏂扮敓鎴� 2026-08锛堟瘝鐗堝彉鏇翠娇缂撳瓨鑷姩澶辨晥锛宍staleCache=true`锛夆啋 鏂版棫鐢熸垚浠堕�愭牸姣斿锛�**浠呰繖 577 鏍煎彉涓虹┖锛�19 椤电涓庡昂瀵镐笉鍙橈紝鍏跺畠涓�寰嬩笉鍔�**锛涗緷璧栨瘝鐗堢紦瀛樺�肩殑鍙ｅ緞锛堜腑鍙ｅ緞鎺掑悕 M3銆侀亾璺繍杈撳懆杞噺 G4銆佽揣杩愰噺鎺掑悕 B4銆佸煄甯傛眹鎬� B3銆佸叕浜� S5/Q5銆佷腑鍙ｅ緞鏄庣粏 C99銆佺彮绾垮寘杞� Q4锛�**鍏ㄩ儴涓�鑷�**銆�
         路 澶囦唤锛堟湰鍦颁繚鐣欍�佷笉鍏ュ簱锛夛細`docs/鐢熸垚姹囨�诲ぇ琛�/_bak_202608姣嶇増娓呯┖鑽夌绱鍒楀墠_20260927.xlsx`锛涙柊鐢熸垚浠跺凡瀛� `D:\妗岄潰\鐢熸垚鏁版嵁\鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃_2026-08 (4).xlsx`銆�
+        路 **琛ㄥご鎺緸淇锛堟寜浜哄伐瀹氱涓哄噯锛�**锛歚杞ㄩ亾銆佽疆娓�!R2`銆乣R11` 鐢辨瘝鐗堣嚜甯︾殑"8鏈堜笌鍘诲勾鍚屾瘮"鏀逛负"鍚屾瘮"锛堜笌璇ラ〉 `T2/T11`"绱鍚屾瘮"浣撲緥涓�鑷淬�佷笌鎵嬪伐瀹氱涓�鑷达紱绋嬪簭涓嶅啓杩欎袱鏍硷紝鏁呭彧鏀规瘝鐗堬級銆�
+          楠岃瘉锛氶噸鏂扮敓鎴� 2026-08 鈫� 鏂版棫鐢熸垚浠堕�愭牸姣斿 **浠呰繖 2 鏍兼枃瀛楀彉鍖栵紝19 椤电涓庡昂瀵镐笉鍙樸�佸叾瀹冧竴寰嬩笉鍔�**銆�
+        路 **鍒ゅ畾涓�"绋嬪簭姝ｇ‘銆佷笉鏀�"鐨勪袱澶�**锛氣憼 `閬撹矾杩愯緭鍛ㄨ浆閲�!A23` 绋嬪簭"2026骞�8鏈堝叏鐪佸畬鎴愪氦閫氬懆杞噺鎯呭喌"锛堣鍧楁槸**褰撴湀鍊�**锛氬叏鐪� 2,301,720 vs 绱鍧� 17,749,657 涓囧惃鍏噷锛夆啋 鎵嬪伐瀹氱澶氬啓浜�"绱"锛涒憽 ` 璐ц繍!EA92:EA112` 2022 骞寸疮璁″悓姣� 10 鏉★紙涓氬姟宸茬‘璁よ蒋浠跺彛寰勬纭級銆�
+        路 **鏂囨湰鍨嬫暟瀛楃粺涓�涓烘暟鍊硷紙鐢ㄦ埛鍙ｅ緞"鎸夌▼搴忓鐨勬敼"锛�**锛氭瘝鐗� 157 鏍兼枃鏈瀷鏁板瓧 鈫� 鏁板�硷紙`鍏氦` 153 = AF 68 + M 68 + G 17锛沗杞ㄩ亾銆佽疆娓 4 = M 2 + E 2锛夛紝浠嶇敤 XML 绮惧噯鏀圭被鍨嬶紙缂撳瓨鍊煎叏閮ㄤ繚鐣欙級銆傞噸鏂扮敓鎴� 2026-08 鈫� 涓庝笂涓�鐗堟瘮瀵癸細**浠� 68 鏍肩被鍨嬪彉鍖栵紙str鈫掓暟鍊笺�佹暟鍊肩浉鍚岋級锛屾棤浠讳綍鍊�/灏哄鍙樺寲**锛堝叾浣� 89 鏍肩▼搴忔湰灏变細鍐欐暟鍊硷級銆傛敞锛氭瘮瀵归噷鍙︽湁 286 鏉�"鏂囨湰鍨嬫暟瀛�"宸紓鍦�**鎵嬪伐瀹氱渚�**锛堟墜宸ュ瓨鏂囨湰锛夛紝闇�鎵嬪伐渚х粺涓�鎴栧拷鐣ャ��
+        路 **鎺掑悕椤�"涓や釜鍧楅『搴忓璋�"锛堝疄涓洪『搴忛棶棰橈紝涓嶆槸澶氫簡涓�寮犺〃锛�**锛氱▼搴� 浠ユā鏉� `docs/璐ц繍/鐢熸垚_璐ц繍閲忔帓鍚�.xlsx`锛堟ā鏉挎湰韬�=绱鍧楀湪琛�1銆佸綋鏈堝潡鍦ㄨ23锛夊～鍏� 鈫� `璐ц繍閲忔帓鍚峘 绋嬪簭=琛�1绱/琛�22褰撴湀锛屾墜宸�=琛�1褰撴湀锛�"2026骞�8鏈堝悇甯傚窞璐ц繍閲忔帓鍚�"锛�/琛�22绱锛沗璐ц繍鍛ㄨ浆閲忔帓鍚峘 绋嬪簭 44脳18锛堢疮璁″湪鍓嶏級vs 鎵嬪伐 51脳18锛堝綋鏈堝湪鍓嶃�佷笖澶� 7 琛屽緟缁嗙湅锛夈��**鐢ㄦ埛鍙ｅ緞锛氭墜宸ヤ负鍑�** 鈫� 闇�鏀规ā鏉匡紙涓ゅ潡瀵硅皟锛�+ 鐩稿簲浠ｇ爜锛堝潡瀹氫綅/鏍囬鍐欐硶 `ReportExportService:961-966/1315/1575-1583`锛�+ 甯傚窞鍚嶇敱 `RegionUtil.shortName()` 鏀瑰叏鍚嶏紱浼� 0.5~1 澶╁惈鍥炲綊锛屽緟寮�宸ャ��
+        路 **鎵嬪伐澶氬嚭鐨�"杈呭姪鍒�"娓呭崟**锛歚 璐ц繍` 澶� 1 鍒楋紙鏃犺〃澶达紝浣嶄簬"鍚屾瘮"涔嬪悗銆�2025 骞� 1 鏈堜箣鍓� 鈫� 瀹炰负 `U` 鍒�"2025 骞� 1-8 鏈堢疮璁�"杈呭姪鍒楋紝74 鏍硷紝浠� V 鍒楄捣鎵嬪伐鏁翠綋鍙崇Щ锛夛紱`鍩庡競瀹㈣繍` 澶� `AJ`="2025骞�1-7鏈堢疮璁�"锛堟瘝鐗� 09-20 宸插垹銆佺▼搴忓凡涓嶈緭鍑猴級锛沗鐝嚎鍖呰溅` 澶� `DU`="1-3鏈堢疮璁�"锛堝嵆鏈娓呯┖鐨勮崏绋垮垪锛夛紱`閬撹矾杩愯緭鍛ㄨ浆閲廯 鏈熬澶� 2 鍒楋紙Z/AA锛�**琛ㄥご涓庡唴瀹瑰潎涓虹┖**锛夈��
+        路 鍙栨暣灏惧樊 194 鏉★細鐢ㄦ埛鏄庣‘"涓嶇敤绠�"銆�
+
+        路 **浠嶅緟涓氬姟瀹氱殑鐗堝紡/鎺緸椤�**锛歚璐ц繍閲忔帓鍚峘/`璐ц繍鍛ㄨ浆閲忔帓鍚峘 鐨勬爣棰樸�佽〃澶达紙绋嬪簭"绱瀹屾垚(涓囧惃)" vs 鎵嬪伐"瑙勪笂璐ц繍閲�(涓囧惃锛�"锛変笌甯傚窞鍚嶏紙绋嬪簭鎸夎璁＄敤鐭悕"姝︽眽/鎭╂柦/鏋楀尯"銆佹墜宸ョ敤"姝︽眽甯�"绛夊叏鍚嶏級鈥斺�旈渶涓氬姟纭浠ュ摢鐗堜负鍑嗐��
+
         路 鈿� **寰呭悓浜嬬‘璁�**锛氭墜宸ュ畾绋夸晶涔熸妸杩欎簺鑽夌鍒楃暀绌猴紝鍚﹀垯姣斿浼氫粠"绋嬪簭鏈夊��/鎵嬪伐鏈夊��"鍙樻垚"绋嬪簭绌�/鎵嬪伐鏈夊��"锛堝悓绫诲樊寮傘�佹柟鍚戠浉鍙嶏級銆�
+
+        路 **娓呯┖鐨� 7 鍒楀鐓ц〃锛堜緵鍚屼簨澶嶆牳锛涘紩鐢ㄦ暟涓烘竻绌哄墠鐨勫叏绨挎壂鎻忥級**锛�
+
+        | 椤电 | 鍒� / 鑼冨洿 | 娓呯┖鏍兼暟 | 鍘熻〃澶� | 鍏紡璇箟 | 娓呯┖鍓嶇紦瀛樺�硷紙棣栬鏍蜂緥锛� | 鍚岄〉寮曠敤 | 璺ㄩ〉寮曠敤 |
+        | --- | --- | ---: | --- | --- | --- | ---: | ---: |
+        | 鍏氦 | `U`锛圲5:U76锛� | 72 | 锛堟棤琛ㄥご锛� | `=V5+X5+Z5+AB5+AD5+AF5` 鈫� 2025 骞� 1~6 鏈堢疮璁� | 88908.91 | 0 | 0 |
+        | 鍑虹 | `U`锛圲5:U76锛� | 72 | 锛堟棤琛ㄥご锛� | `=V5+X5+Z5+AB5+AD5+AF5` 鈫� 2025 骞� 1~6 鏈堢疮璁� | 39797.94 | 0 | 0 |
+        | 缃戠害杞� | `U`锛圲5:U76锛� | 72 | 锛堟棤琛ㄥご锛� | `=V5+X5+Z5+AB5+AD5+AF5` 鈫� 2025 骞� 1~6 鏈堢疮璁� | 16384.07 | 0 | 0 |
+        | 鍩庡競瀹㈣繍 | `U`锛圲4:U39锛� | 36 | 锛堟棤琛ㄥご锛� | `=V4+X4+Z4+AB4+AD4+AF4` 鈫� 2025 骞� 1~6 鏈堢疮璁� | 206639.67 | 0 | 0 |
+        | 鐝嚎鍖呰溅 | `DU`锛圖U4:DU57锛� | 54 | 1-3鏈堢疮璁� | `=DO4+DQ4+DS4` 鈫� 1~3 鏈堢疮璁� | 5566.8922 | 0 | 0 |
+        | 涓彛寰勬槑缁� | `U`锛圲99:U188锛� | 90 | 锛堟棤琛ㄥご锛� | `=V99+X99+Z99+AB99+AD99+AF99+AH99` 鈫� 2025 骞� 1~7 鏈堢疮璁� | 1102278.385724 | 0 | 0 |
+        | 涓彛寰勫杩愰噺 | `AB`锛圓B5:AB188锛� | 184 | 锛堟棤琛ㄥご锛� | `=AC5+AE5` 鈫� 2024 骞� 1~2 鏈堢疮璁� | 6088.1871 | 0 | 0 |
+
+        路 **鈿� 鍚屽悕鍒楀埆娓呴敊锛堝弽渚嬪鐓э級**锛歚涓彛寰勬槑缁�!AB3 = "2025骞�4鏈�"` 鏄�**姝ｅ父鏈堜唤鍒�**锛岃 **700+ 澶勫悓椤� + 34 澶勮法椤靛叕寮忓紩鐢�**锛堜緥濡� `涓彛寰勬槑缁�!J5 = I5/AB5-1` 2026 骞� 4 鏈堝悓姣斻�乣T5 = S5/SUM(V5,X5,Z5,AB5,鈥�)-1` 绱鍚屾瘮銆乣AT5 = X5+V5+Z5+AB5+鈥 2025 绱銆乣涓彛寰勫杩愰噺!I11 = 涓彛寰勬槑缁�!AB11`锛夛紝**鏈鏈姩銆佷篃涓嶈兘娓�**銆傚垽鎹細璇ュ垪**鏈夎〃澶�**銆�**琚紩鐢ㄦ暟杩滃ぇ浜� 0**銆佸叕寮忚涔夋槸"琚埆鐨勬牸寮曠敤"鑰屼笉鏄紩鐢ㄥ叾瀹冩湀浠藉垪銆�
+
       - **鐢熸垚浠堕噷閿欒鍊� 356 涓� `#DIV/0!` + 13 涓� `#REF!`**锛氱彮绾垮寘杞� 228+8銆佷腑鍙ｅ緞鏄庣粏 64+2銆佽揣杩� 38+3銆佷腑鍙ｅ緞瀹㈣繍閲� 26锛涗笟鍔″彛寰勬湭瀹氾紙鏄惁娓呮垚绌虹櫧锛夈��
       - **鍩庡競瀹㈣繍椤佃〃澶翠粛鏄棩鏈熷簭鍒楀彿锛堢‘璇佹湭淇級**锛氭瘝鐗堜笌鐢熸垚浠剁 2 琛岀 3 涓湀璧峰潎涓哄簭鍒楀彿锛圙2=46082銆両2=46113鈥︼級锛�1銆�2 鏈堟槸鏂囧瓧锛沗fixCityMonthHeaderText()` 鏈鐩栬椤� 鈫� "鎸夎〃澶存枃瀛楀尮閰嶅垪"鏂规鍦ㄨ椤靛け鏁堛�傦紙姝ゅ墠鏂囨。鏍�"寰呮牳瀹�"锛岀幇宸茬‘璇併�傦級
       - 缂� 2026-09 姣嶇増锛堢洰褰曚粎 7 鏈�/8 鏈�/鐗堝紡鍘熷瀷 + 2 涓� `_bak_*`锛夆啋 9 鏈堝嚭琛ㄤ細 `ready=false`锛岄渶鎷嶆澘鏂规 A锛堢▼搴忔墿鍒楋級/ B锛圗xcel 灏忓伐鍏凤級銆�

--
Gitblit v1.9.1