From 4dbecfc85c689a2ca2801f2f220a4e11f4fc5201 Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期一, 28 九月 2026 16:50:02 +0800 Subject: [PATCH] fix(汇总表母版): 班线包车 EO36/FN36/FO36 改静态值（防生成时重算覆盖），连带静态化 35 个共享公式孤儿子格；生成验证生成件/母版/定稿三边一致；HANDOFF 记录收尾与剩余 16 条 --- HANDOFF.md | 16 ++++++++++------ 1 files changed, 10 insertions(+), 6 deletions(-) diff --git a/HANDOFF.md b/HANDOFF.md index 047d24b..eb2710d 100644 --- a/HANDOFF.md +++ b/HANDOFF.md @@ -13,12 +13,16 @@ - **楠岃瘉**锛氱敓鎴愪袱娆★紙绾� 15 绉�/娆★級锛岀浜屾鐩稿绗竴娆�**浠� 78 鏍� 0鈫掔┖**锛岄敊璇�兼暟閲忎笉鍙橈紱`鍏氦!S5=98460.97` 绛夌紦瀛樺�兼娊鏌ヤ繚鐣欍�� - **杩愯鐘舵��**锛氬悗绔凡鎸� `start-dev.ps1` 閲嶅惎锛堟柊 PID锛�8090/8080 鍦ㄨ窇锛夛紱鏈満搴撲粛涓� `localhost:3308/traffic_audit`銆� - **鉁� 鐝嚎鍖呰溅鍥炶ˉ瀹屾垚锛�09-28 涓嬪崍锛�**锛氱敤鎴风‘璁ゅ悗鎸� 09-27 姣嶇増澶囦唤锛坄_bak_202608姣嶇増鏂囨湰鏁板瓧杞暟鍊煎墠_20260927.xlsx`锛塜ML 绮惧噯鍥炶ˉ銆婄彮绾垮寘杞︺��2019/2020 鍧� 鈥斺�� **璇ラ〉涓� 09-27 姣嶇増閫愭牸涓�鑷达紙0 宸紓锛�**锛岄敊璇�煎洖鍒� `#REF!` 8 / `#DIV/0!` 228锛涙瘝鐗堝叾瀹冮〉鏈彈褰卞搷銆傞獙鏀剁敓鎴愶細涓� 09-27 鐢熸垚浠� (6) 姣斿閿欒鍊奸�愰〉涓�鑷达紝宸紓浠呭墿鏃㈠畾鏀瑰姩锛坄 璐ц繍` 78 鏍兼竻 0銆佷腑鍙ｅ緞鏄庣粏 4915 鏍煎垹鍒椾綅绉汇�佷腑鍙ｅ緞鎺掑悕 672 鏍煎潡浣嶇Щ銆佺彮绾垮寘杞� 82 鏍兼诞鐐瑰熬宸�/0-绌猴級銆� -- **鏂板宸紓娓呭崟宸ュ叿锛�09-28锛�**锛歚docs/宸ュ叿/姹囨�诲ぇ琛ㄥ樊寮傛瘮瀵�.py`锛堥�愰〉鎸夎鏍囩/鍒楄〃澶村簭鍒楀榻愶紝鍙鐞嗗鍒�/澶氳/閲嶅琛ㄥご锛夛紝浜х墿 `docs/闂姹囨��/姹囨�诲ぇ琛╛宸紓鏄庣粏_2026-08_20260928.md` + `.csv`锛�1401 鏉℃槑缁嗭紝鎸� 瀹炶川鏁板�煎樊寮傦綔浠呮墜宸ユ湁锝滀粎绋嬪簭鏈夛綔鍙栨暣灏惧樊锝滄枃鏈瀷鏁板瓧锝滄枃鏈笉鍚岋綔閿欒鍊� 鍒嗙被锛夈�� - - 缁撹锛歚 璐ц繍` 瀹炶川鏁板�煎樊寮� **10 鏉�**锛�2022 骞村悇甯傚窞绱鍚屾瘮锛屼笟鍔″凡纭杞欢瀵癸級锛沗鍏氦/鍩庡競瀹㈣繍/涓彛寰勬槑缁�/涓彛寰勫杩愰噺` 鐨�"浠呮墜宸ユ湁"鍗虫墜宸ヤ晶**鑽夌鍒�**锛�72/36/90/180 鏍硷級锛沗鍏氦/杞ㄩ亾杞浮` 鐨�"鏂囨湰鍨嬫暟瀛�"= 鍊肩浉鍚屼粎绫诲瀷涓嶅悓锛沗璐ц繍閲忔帓鍚�/璐ц繍鍛ㄨ浆閲忔帓鍚�/鐝嚎鍖呰溅` 鐨勫樊寮傚惈**琛屽潡閿欎綅鍋囧樊寮�**锛堝凡鍦ㄨ娓呭崟"闃呰鎻愮ず"涓爣娉紝闇�鎸夎鏍囩鏍稿锛夈�� - - 鏇存锛�09-28 涓婂崍涓�搴﹁涓�"2020 绱/绱鍚屾瘮"鏈夊樊寮傦紝瀹炰负瀵归綈鑴氭湰璇厤鍒楁墍鑷粹�斺�旀寜浣嶇疆閫愭牸鏍稿涓よ竟涓�鑷达紝鏈仛鏀瑰姩銆� -- **宸紓娓呭崟宸插疄璺戯紙09-28 鏅氾級**锛氭寜褰撳墠姣嶇増閲嶆柊鐢熸垚 2026-08锛堢敓鎴愪欢瀛� `docs/鐢熸垚姹囨�诲ぇ琛�/杈撳嚭/_澶嶆牳鐢熸垚_2026-08_20260928.xlsx`锛岃鐩綍琚拷鐣ヤ笉鍏ュ簱锛夛紝浜у嚭涓や唤娓呭崟锛� - - `docs/闂姹囨��/姹囨�诲ぇ琛╛宸紓鏄庣粏_2026-08_20260928.md/.csv`锛堟瘝鐗堟渶鏂扮敓鎴愪欢 vs 鎵嬪伐瀹氱锛�1401 鏉★級 - - `docs/闂姹囨��/姹囨�诲ぇ琛╛宸紓鏄庣粏_2026-08_20260928_妗岄潰瀵煎嚭鐗�.md/.csv`锛堟闈㈠鍑虹増 vs 鎵嬪伐瀹氱锛�1333 鏉★紱璇ヤ唤瀵煎嚭杈冩棭銆乣 璐ц繍` 鍗曡竟鏍煎皯 74 鏍硷紝澶嶆牳浠ユ瘝鐗堟渶鏂扮敓鎴愪欢涓哄噯锛� +- **宸紓娓呭崟鍙ｅ緞鏇存柊锛�09-28锛岀敤鎴风‘璁わ級**锛氣憼 ` 璐ц繍` 鏂板鐨勩�岃涓�+瑙勪笅璐ц繍閲忋�嶃�岃涓嬭揣杩愰噺銆嶅悇 17 琛岋紙姣嶇増璁捐锛屽叡 34 琛岋級涓嶈宸紓锛涒憽 ` 璐ц繍!U5:U112` 鏃犺〃澶磋崏绋垮垪涓嶈锛涒憿 鎺掑悕琛ㄣ�屽綋鏈堝潡銆嶄负姣嶇増璁捐涓嶈锛涒懀 甯傚窞鐭悕/鍏ㄥ悕涓嶅奖鍝嶏紙宸ュ叿褰掍竴鍖栵級锛涒懁 灏忓樊寮傦紙鍙栨暣灏惧樊/鏂囨湰鍨嬫暟瀛楋級鍙鏁帮紝鍙垪宸紓澶х殑骞堕檮鍘熷洜銆傚伐鍏� `docs/宸ュ叿/姹囨�诲ぇ琛ㄥ樊寮傛瘮瀵�.py` 宸叉寜姝ゆ洿鏂帮紝涓や唤娓呭崟宸查噸鐢熸垚銆� +- **鏂板彂鐜帮紙寰呮牳瀵癸級**锛歚鐝嚎鍖呰溅!EO36/FN36/FO36`锛堣崋闂� 瀹㈣繍閲� 2020 绱/绱鍚屾瘮锛�**绋嬪簭鐢熸垚鏃堕噸绠椾负 -2731.41 / -1.0008 / -1.0002**锛岃�屾瘝鐗堜笌鎵嬪伐瀹氱鍧囦负 0.181777 / 2312.2199 / -0.586419 鈫� 鐤戞瘝鐗� 2020 骞村潡鍒嗘瘝涓� 0锛岄渶鏍稿鍏紡涓庢暟鎹�� +- **姹囨�诲ぇ琛ㄥ樊寮傛瘮瀵癸紙09-28锛屽伐鍏峰凡鍥哄寲鍙ｅ緞锛�**锛歚docs/宸ュ叿/姹囨�诲ぇ琛ㄥ樊寮傛瘮瀵�.py`锛堥�愰〉鎸夎/鍒楁爣绛惧簭鍒楀榻愶紝鍙鐞嗗鍒�/澶氳/閲嶅琛ㄥご锛夈��**娓呭崟灞炶繃绋嬩骇鐗╁彧鐣欐湰鍦�**锛坄docs/闂姹囨��/_娓呭崟_*.md/.csv`锛屽凡 gitignore 涓嶅叆搴擄級銆� + - 宸茬‘璁ゅ彛寰勶紙涓嶅啀閲嶅纭/涓婃姤锛夛細鈶� 璐ц繍姣忓競宸� 6 琛� vs 鎵嬪伐 4 琛岋紙鏂板銆岃涓�+瑙勪笅璐ц繍閲忋�嶃�岃涓嬭揣杩愰噺銆嶅悇 17 琛岋級灞炴瘝鐗堣璁★紝琛屽彿鍋忕Щ鎸�"鍦板尯+鎸囨爣"瀵归綈鍚庝竴鑷达紱鈶� ` 璐ц繍` U 鍒楋紙U2:U118锛変负浜哄伐鑽夌锛涒憿 浠呮墜宸ユ湁涓�**鏃犺〃澶�**鐨勫垪 = 鑽夌锛涒懀 娴偣灏惧樊銆佹枃鏈瀷鏁板瓧蹇界暐锛涒懁 鎺掑悕琛ㄣ�屽綋鏈堝潡銆嶄负姣嶇増璁捐锛涒懃 甯傚窞鐭悕/鍏ㄥ悕涓嶅奖鍝嶃�� + - **闇�澶勭悊锛堟暟鍊硷級**锛歚鐝嚎鍖呰溅!EO36/FN36/FO36`锛堣崋闂� 瀹㈣繍閲� 2020 绱/绱鍚屾瘮锛夆�斺�旂▼搴忕敓鎴愭椂閲嶇畻涓� -2731.41 / -1.0008 / -1.0002锛屾瘝鐗堜笌鎵嬪伐瀹氱鍧囦负 0.181777 / 2312.2199 / -0.586419锛堢枒姣嶇増 2020 骞村潡鍒嗘瘝涓� 0锛夛紝寰呮牳瀵癸紱` 璐ц繍` 2022 骞村悇甯傚窞銆岀疮璁″悓姣斻��10 鏉★紙涓氬姟宸茬‘璁�**杞欢瀵�**锛屼笉鏀癸級銆� + - 鍏朵綑寰呭姙锛氭墜宸ヤ晶 4 澶勮剰鏁版嵁锛坄鐝嚎鍖呰溅!IL4/IL5` 鏂摼銆乣IL50` 鍙嶅紩鍙枫�乣 璐ц繍!EA93/EA111` 鐨� `#DIV/0!`锛夈��286 鏍兼枃鏈瀷鏁板瓧銆�304 鏍艰崏绋垮垪锛涙瘝鐗� 11 涓� `#REF!` + 356 涓� `#DIV/0!`锛沗鍩庡競瀹㈣繍` 绗� 2 琛岀 3 涓湀璧疯〃澶翠负鏃ユ湡搴忓垪鍙凤紱缂� 2026-09 姣嶇増锛涘鍑哄墠鍩烘暟浣撴锛圥0-3锛夈�� +- **09-28 鏀跺熬锛歚鐝嚎鍖呰溅` 3 鏍奸噸绠楅棶棰樺凡淇�**锛歚EO36`/`FN36`/`FO36` 鍦ㄦ瘝鐗堥噷鏀逛负**闈欐�佸��**锛�0.181777001400256 / 2312.2199 / -0.586418964965219锛屼笌鎵嬪伐瀹氱涓�鑷达級锛屽苟鎶婂彈褰卞搷鐨勫叡浜叕寮忕粍瀛ゅ効瀛愭牸锛�35 鏍硷級涓�骞堕潤鎬佸寲锛堝�奸浂鍙樺寲锛夈�傞噸鏂扮敓鎴愰獙璇侊細鐢熸垚浠�/姣嶇増/瀹氱涓夎竟涓�鑷达紝涓庝笂涓�鐗堢敓鎴愪欢浠� 34 鏍间负绮惧害琛ㄧず宸紓銆佹棤鏁板�煎彉鍖栥�� +- **褰撳墠"闇�澶勭悊"浠呭墿 16 鏉�**锛堝潎灞炴墜宸ヤ晶/涓氬姟宸茬‘璁わ紝闈炵▼搴忛棶棰橈級锛歚 璐ц繍` EA92~EA112 鍏� 12 鏉★紙2022 鍚勫競宸炵疮璁″悓姣旓紝2021 骞村熀鏁板彛寰勪笉鍚岋紝涓氬姟宸茬‘璁よ蒋浠跺锛涘惈鎵嬪伐 `#DIV/0!` 2 鏉★級銆乣鐝嚎鍖呰溅` IL4/IL5锛堟墜宸� `#REF!`锛�/IL50锛堟墜宸ュ弽寮曞彿锛�3 鏉°�乣鍩庡競姹囨��!G20` 琛ㄥご鎺緸 1 鏉°�傚叾浣欏叏閮ㄦ寜鍙ｅ緞蹇界暐锛堣崏绋垮垪/琛屽彿鍋忕Щ/褰撴湀鍧�/娴偣灏惧樊/鏂囨湰鍨嬫暟瀛楋級銆� +- **鏈竻椤癸紙鏈夋剰淇濈暀锛�**锛氭瘝鐗� 11 涓� `#REF!` + 356 涓� `#DIV/0!` 鍘嗗彶閿欒鍊兼湭娓呪�斺�旀墜宸ュ畾绋垮悓绫荤害 15 + 358锛屽崟娓呬竴杈逛細鍑┖澶氬嚭鍗曡竟宸紓锛涜娓呴渶涓よ竟涓�璧枫�� +- **纭宸紓娓呭崟锛堟湰鍦帮級**锛歚docs/闂姹囨��/_宸茬‘璁ゅ樊寮傛竻鍗昣2026-08_20260928.md`锛堜笉鍏ュ簱锛夈�� - **寰呭姙**锛氣憼 鎺掑悕椤电粨鏋勶紙鍧楅『搴忋�佹爣棰樻帾杈炪�佸競宸炲悕鐭悕/鍏ㄥ悕銆佸懆杞噺鎺掑悕澶� 7 琛岋級锛涒憽 鎺掑悕椤电粨鏋勶紙鍧楅『搴忋�佹爣棰樻帾杈炪�佸競宸炲悕鐭悕/鍏ㄥ悕銆佸懆杞噺鎺掑悕澶� 7 琛岋級锛涒憿 缂� 2026-09 姣嶇増銆佸鍑哄墠鍩烘暟浣撴锛圥0-3锛夈�� ## 鏈�鏂帮紙2026-09-27锛� -- Gitblit v1.9.1