From 8bae58f904c5a53ddc54a6ccb0d14f5f9f877c2d Mon Sep 17 00:00:00 2001
From: zyj <zyj@local>
Date: 星期一, 21 九月 2026 17:23:44 +0800
Subject: [PATCH] fix(汇总表母版): 班线包车页 196 格文本格式数值改为数值(8-57行 FV/FW/FX/FY/GA/GC/IT/IV/IX)

---
 docs/工作日结/工作日结_2026-09-21.md |   58 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 57 insertions(+), 1 deletions(-)

diff --git "a/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-21.md" "b/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-21.md"
index 7bf8000..2bd9adf 100644
--- "a/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-21.md"
+++ "b/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-21.md"
@@ -167,4 +167,60 @@
 - 鍏朵綑椤靛樊寮傚睘 Excel 鍙﹀瓨褰掍竴鍖栵紝闈炰笟鍔℃敼鍔細`鍏矾鎬诲杩恅 104 鏍笺�乣鍩庡競瀹㈣繍` 126 鏍兼槸鍏紡鍘绘帀宸ヤ綔琛ㄥ悕寮曞彿锛坄'杞ㄩ亾銆佽疆娓�'` 鈫� `杞ㄩ亾銆佽疆娓锛岃涔変笉鍙橈級锛沗 璐ц繍` 23銆乣璐ц繍鍛ㄨ浆閲忔帓鍚峘 3銆乣鍩庡競姹囨�籤 4銆乣鍩庡競鍒嗗競宸瀈 17銆乣涓彛寰勬帓鍚峘 11銆乣涓彛寰勫垎鏋恅 3 鏍兼槸娴偣閲嶅啓锛�15 浣嶆湁鏁堟暟瀛楋紝鐩稿宸害 1e-15锛夈��
 - 鑳屾櫙锛氬搴斿悓浜嬪樊寮傛姤鍛� 搂4.2 涓�屾暟鍊� vs 鍚屽�兼枃鏈�嶈繖涓�绫诲樊寮傘��
 - 璇ュ師鍨嬫枃浠跺湪浠ｇ爜涓棤寮曠敤锛坄rg 鐗堝紡鍘熷瀷` 鏃犲懡涓級锛屽睘鍙傝�冧欢锛涙湰娆℃棤浠ｇ爜鏀瑰姩銆�
-- 鏍稿鏂瑰紡锛氱敤 `git show HEAD:<file>` 鍙栧嚭鏃х増鍒� `_tmp_proto_head.xlsx`锛屽啀鐢� openpyxl 閫愭牸姣斿绫诲瀷涓庡�硷紙涓存椂鏂囦欢淇濈暀锛屾湭鍒狅級銆�
\ No newline at end of file
+- 鏍稿鏂瑰紡锛氱敤 `git show HEAD:<file>` 鍙栧嚭鏃х増鍒� `_tmp_proto_head.xlsx`锛屽啀鐢� openpyxl 閫愭牸姣斿绫诲瀷涓庡�硷紙涓存椂鏂囦欢淇濈暀锛屾湭鍒狅級銆�
+
+## 涔濄�佽拷鍔狅細姹囨�诲ぇ琛ㄣ�岃蒋浠惰緭鍑� vs 鎵嬪伐瀹氱銆嶅叏閲忛�愭牸姣斿锛堢敤鎴� 09-21 鍌嶆櫄浠诲姟锛�
+
+鐢ㄦ埛缁欏畾涓や唤鏂囦欢锛岃姹傘�屾瘮杈冭蒋浠惰緭鍑轰笌鎵嬪伐璁＄畻鐨勭粨鏋滐紝鍒楀嚭鎵�鏈変笉涓�鑷寸殑鍦版柟锛堜袱鑰呮牸寮忓彲鑳界暐鏈変笉鍚岋級銆嶏細
+
+- 绋嬪簭锛堣蒋浠惰緭鍑猴級锛歚D:\妗岄潰\鐢熸垚鏁版嵁\鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃_2026-08 (2).xlsx`锛�09-21 16:49锛�
+- 鎵嬪伐锛堟墜宸ヨ绠�/瀹氱锛夛細`D:\05_鏁版嵁鍒嗙被\姹囨�昏〃\8鏈堟眹鎬诲畾绋縗2026骞�8鏈堝杩愰噺銆佽揣杩愰噺瀹氱.xlsx`锛�09-13锛�
+
+**浜у嚭**
+
+- `docs/闂姹囨��/姹囨�诲ぇ琛╛杞欢杈撳嚭涓庢墜宸ュ畾绋垮樊寮傛竻鍗昣2026-08.md`锛堝垎绫绘竻鍗曪細鏁板��/缁撴瀯/鏂囧瓧锛�
+- `docs/闂姹囨��/姹囨�诲ぇ琛╛宸紓鏄庣粏_2026-08.csv`锛�943 鏉￠�愭牸鏄庣粏锛�
+
+**姣斿鏂规硶**锛堝彲澶嶇幇锛岃剼鏈� `_tmp_cmpG.py` 淇濈暀鍦ㄩ」鐩牴锛�
+
+1. openpyxl 鍙岃锛堢紦瀛樺�� + 鍏紡锛夛紱鎸夈�屽潡鏍囬锛堢疮璁�/褰撴湀锛�+ 琛屾爣绛� + 鍒楀ご銆嶈涔夊榻愩��
+2. 鍏堢敤琛ㄥご鏂囨湰搴忓垪姹傚垪鍋忕Щ锛歚 璐ц繍` 浠� V 鍒楄捣 +1銆乣鍩庡競瀹㈣繍` 浠� AJ 鍒楄捣 +1銆乣鐝嚎鍖呰溅` 灏鹃儴 2015/2016 鍖� 鈭�3锛涗笁椤佃〃澶存牎楠屽潎 0 澶勪笉涓�鑷淬��
+3. 琛屾寜銆屽競宸烇紙鍒� A 鍓嶅悜濉厖锛�+ 鎸囨爣锛堝垪 B锛夈�嶅尮閰嶏紝甯傚窞鍚嶅幓銆屽競/宸炪�嶅悗缂�锛涙爣绛惧垪鍗曠嫭鍋氭枃瀛楁牳瀵癸紙閬垮厤鍚堝苟鍗曞厓鏍煎亣宸紓锛夈��
+4. 鍒ゅ畾鍒嗘。锛氱浉瀵瑰樊 鈮�1e-12 瑙嗕负鍚屽�笺��1e-12~1e-6 璁般�屽彇鏁村樊寮傘�嶃��>1e-6 璁般�屾暟鍊煎樊寮傘�嶃��
+
+**缁撴灉锛�943 鏉★級**
+
+| 绫诲埆 | 鏉℃暟 |
+| --- | ---: |
+| 鏁板�煎樊寮傦紙>1e-6锛� | 315 |
+| 鏂囨湰鍨嬫暟瀛楋紙鍊肩浉鍚屻�佹牸寮忎笉鍚岋級 | 286 |
+| 鍙栨暣宸紓锛堚墹1e-6锛� | 207 |
+| 浠呯▼搴忔湁鍊� | 129 |
+| 閿欒鍊煎樊寮� | 4 |
+| 鏂囨湰涓嶅悓 | 2 |
+
+鍏抽敭缁撹锛�
+
+1. **304 鏉℃暟鍊煎樊寮傛槸鍚屼竴涓瘝鐗堥棶棰�**锛歚鍏氦/鍑虹/缃戠害杞 `U5:U76`锛堝悇 72 鏍硷級涓� `涓彛寰勬槑缁哷 `U99:U188`锛�88 鏍硷級鈥斺�旂▼搴忔部鐢ㄦ瘝鐗堝叕寮忓彧绱姞鍒� 6/7 鏈堬紝鎵嬪伐绱姞鍒� 8 鏈堛�備笌绗竷鑺傚洖鎵у彛寰勪竴鑷达紙璇ュ垪鍙竻绌虹暀绌猴級銆�
+2. ` 璐ц繍` `EA92:EA112` 10 鏍� 2022 骞寸疮璁″悓姣旓紙浠欐/娼滄睙/澶╅棬/鏋楀尯锛夊樊寮傝緝澶э紝姝ゅ墠涓氬姟宸茬‘璁ゃ�岃蒋浠跺銆嶃��
+3. ` 璐ц繍`銆�2021 骞寸疮璁°�峘EO5:EO112` 74 鏍硷細绋嬪簭鏈夊�笺�佹墜宸�**璇ュ垪鏁版嵁鍖哄叏绌�**锛堣〃澶� `EP4` 鏈夈�岀疮璁°�嶏級銆�
+4. `鐝嚎鍖呰溅` `IL4:IL57` 34 鏍硷細鎵嬪伐璇ュ垪 31 鏍肩┖鐧姐��2 鏍� `#REF!`锛堝叕寮� `=(IK4-#REF!)/#REF!`锛夈��1 鏍兼槸鏉傚瓧绗︺�宍銆嶃��
+5. ` 璐ц繍` 鍘嗗彶鏈堜唤锛�2021-2024锛�139 鏍煎皬鏁板熬鏁板樊寮傦紝鐩稿鍋忓樊鏈�澶� 7.7e-7锛堟墜宸ュ彇鏁达級锛屼笉褰卞搷缁撹锛涘熬閮ㄦ牳绠楀潡 63 澶勪袱杈归兘鏄� 1e-10 閲忕骇娈嬪樊锛屽疄璐ㄤ负 0銆�
+6. **缁撴瀯宸紓**锛歚 璐ц繍` 绋嬪簭姣忓競宸炲 2 琛岋紙瑙勪笂+瑙勪笅璐ц繍閲忋�佽涓嬭揣杩愰噺锛夛紳澶� 34 琛岋紝涓斾粠 V 鍒楄捣鎵嬪伐鏁翠綋鍙崇Щ 1 鍒楋紙鎵嬪伐 V 鍒楀涓�涓棤琛ㄥご鐨勩��2025 骞� 1-8 鏈堢疮璁°�嶈緟鍔╁垪锛�74 鏍硷級锛沗鍩庡競姹囨�籤 绋嬪簭澶� 8 鏈堝潡锛�41 鏍硷級锛沗鍩庡競鍒嗗競宸瀈 绋嬪簭澶氫袱涓� 8 鏈堝潡锛沗涓彛寰勫垎鏋恅 绋嬪簭澶� 8 鏈堝潡锛沗涓彛寰勬帓鍚峘 甯冨眬瀹屽叏涓嶅悓浣�**鏁版嵁涓�鑷�**锛沗鍩庡競瀹㈣繍` 鎵嬪伐澶氫竴鍒椼��2025 骞� 1-7 鏈堢疮璁°�嶏紱`鐝嚎鍖呰溅`/`閬撹矾杩愯緭鍛ㄨ浆閲廯 鎵嬪伐鍚勫鍒椼��
+7. **鏂囨湰鍨嬫暟瀛�**锛氭墜宸� `鐝嚎鍖呰溅` 196 鏍硷紙`FV8:IX57`锛夆�斺��**涓庣鍏妭鐢ㄦ埛鍦ㄣ�婄増寮忓師鍨嬨�嬮噷鍒氭敼鎺夌殑 196 鏍煎畬鍏ㄦ槸鍚屼竴鎵瑰崟鍏冩牸**锛涙墜宸� `鍏氦` 153 鏍笺�乣杞ㄩ亾銆佽疆娓 5 鏍笺�傜▼搴忎晶 `鍏氦` `AF` 鍒� 68 鏍煎悓涓烘枃鏈瀷鏁板瓧锛堜袱杈逛竴鑷达級銆�
+8. **绾枃瀛楀樊寮� 2 澶�**锛歚閬撹矾杩愯緭鍛ㄨ浆閲�!A23`锛堢▼搴忋��2026骞�8鏈堝叏鐪佸畬鎴愪氦閫氬懆杞噺鎯呭喌銆峷s 鎵嬪伐澶氫簡銆岀疮璁°�嶄簩瀛楋級銆乣杞ㄩ亾銆佽疆娓�!R2/R11`锛堛��8鏈堜笌鍘诲勾鍚屾瘮銆峷s銆屽悓姣斻�嶏級銆�
+9. 閫愭牸 0 宸紓鐨勯〉绛撅細`鍏矾鎬诲杩恅銆乣2025骞村煄甯傚杩愰噺`銆乣涓彛寰勫杩愰噺`銆乣涓彛寰勮绠楄繃绋媊锛屼互鍙婂叾浣欓〉绛剧殑鍏辨湁閮ㄥ垎銆�
+
+鏈涓烘瘮瀵�/鏂囨。绫诲伐浣滐紝鏃犱唬鐮佹敼鍔ㄣ��
+
+## 鍗併�佽拷鍔狅細姣嶇増銆�2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx銆嬬彮绾垮寘杞﹂〉 196 鏍兼枃鏈敼鏁板�硷紙鎻愪氦锛�
+
+鐢ㄦ埛 15:59 鎵嬪伐鏀圭殑宸ヤ綔鍖烘敼鍔紝鏍稿鍚庢彁浜ゃ�傛鍓嶆彁鍒扮殑銆屽叕璺彮绾块噷鐨勬暟瀛楁枃鏈牸寮忔敼涓烘暟鍊笺�嶅嵆鎸囨湰鏂囦欢 `鐝嚎鍖呰溅` 椤碉紙璇ラ〉 A1 = 銆屽叕璺彮绾垮杩愰噺銆嶏級銆�
+
+- 鏂囦欢锛歚docs/鐢熸垚姹囨�诲ぇ琛�/2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx`锛�**姣嶇増**锛�1,486,884 鈫� 1,355,960 瀛楄妭锛�
+- 鏀瑰姩鑼冨洿锛歚鐝嚎鍖呰溅` 椤电 **8-57 琛� 脳 `FV`/`FW`/`FX`/`FY`/`GA`/`GC`/`IT`/`IV`/`IX` 鍒楋紝鍏� 196 鏍� `鏂囨湰 鈫� 鏁板�糮**锛坄'374.0000'` 鈫� `374`銆乣'33,437.0000'` 鈫� `33437`锛夈��
+- 鏍稿鏂瑰紡锛歚git show HEAD:docs/鐢熸垚姹囨�诲ぇ琛�/2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx > _tmp_mother_head2.xlsx`锛屼笌宸ヤ綔鍖洪�愭牸姣斿绫诲瀷涓庡�硷細
+  - `str 鈫� 鏁板�糮 = **196 鏍�**锛屾暟鍊奸�愭牸绛変环锛�0 澶勪笉绛夛級锛�
+  - 鍙︽湁 32,092 澶� `float 鈫� float`锛屾槸 Excel 鍙﹀瓨鎶婃诞鐐归噸鍐欎负 15 浣嶆湁鏁堟暟瀛楋紙鐩稿宸� ~1e-15锛夛紝闈炰笟鍔℃敼鍔ㄣ��
+- 涓庣鍏妭銆婄増寮忓師鍨嬨�嬬殑鏀瑰姩鍚屾簮锛氫袱浠芥枃浠跺湪鍚屼竴鎵� 196 鏍间笂鍋氳繃鍚屾牱鐨勬枃鏈啋鏁板�兼暣鏀癸紱鏈鎶�**姣嶇増**杩欎唤涔熷叆搴撱��
+- 鏈鏃犱唬鐮佹敼鍔紝灞炴瘝鐗堟暟鎹牸寮忔暣鐞嗭紝涓嶅彟鍑恒�婂姛鑳芥祴璇曟姤鍛娿�嬨��

--
Gitblit v1.9.1