| | |
| | | - ç¬ç«ãçæ_ä¸å£å¾æå.xlsxã乿åä¸éæå£å¾å¯¼åºï¼ç»æä¸æç»é¡µä¸è´ã |
| | | - æµè¯äº§ç©ï¼`_tmp/qa_plan_a_20260921/çæ_éè·¯è¿è¾éæ±æ»è¡¨_202608_æ¹æ¡A.xlsx`ã`_tmp/qa_plan_a_20260921/çæ_ä¸å£å¾æå_202608_æ¹æ¡A.xlsx`ï¼æçº¦å®ä¿çï¼ã |
| | | - æµè¯æ¥åï¼`docs/åè½æµè¯æ¥å/åè½æµè¯æ¥å_ä¸å£å¾æååæ¯åºæ°æ¹æ¡A_2026-09-21.md`ã |
| | | |
| | | |
| | | ## ä¸ã追å ï¼åäºãæ±æ»å¤§è¡¨è½¯ä»¶è¾åºä¸æå·¥å®ç¨¿å·®å¼ãäººå·¥æ ¸å¯¹ |
| | | |
| | | åäºï¼xycï¼æ¨é差弿¥åï¼æäº¤ `47a8734`ï¼å¹¶å£å¤´è¦æ±ãäººå·¥æ£æ¥ä¸ä¸æ¥çå·®å¼ãï¼æ¬æ¬¡å®ææ ¸å¯¹ï¼ |
| | | |
| | | - 产åºåæ§ï¼`docs/é®é¢æ±æ»/æ±æ»å¤§è¡¨å·®å¼æ ¸å¯¹åæ§_2026-09-21.md`ï¼æå¯¹æ¹ç¼å·éæ¡åçï¼ã |
| | | - 夿 ¸æ¹å¼ï¼æ¬å°æ¯ç `2026å¹´8æéè·¯è¿è¾éæ±æ»è¡¨.xlsx` + çæä»¶ `çæ_éè·¯è¿è¾éæ±æ»è¡¨.xlsx`ï¼9/18ï¼éæ ¼è¯»å
¬å¼ä¸ç¼åå¼ï¼å
è Pythonï¼æªè½çï¼ã |
| | | - ç»è®ºï¼ |
| | | 1. `å
¬äº¤/åºç§/ç½çº¦è½¦` `U5:U76`ï¼æ¥å §4.1ï¼ï¼ä¸å¡å£å¾ç¡®è®¤**坿¸
空ç空**ãæ ¹å æ¯æ¯çèªç¸çç¾ââ`U5` åªç®å° 2025 å¹´ 6 æï¼èåé¡µç´¯è®¡åæ¯ `T5` çåæ¯å« 1-8 æï¼è¡¥ 7ã8 æå䏿工å¼éä½å»åï¼å
¬äº¤ 114285.68 / åºç§ 52461.16 / ç½çº¦è½¦ 22474.11ï¼ï¼å½±å 3 页 à 72 è¡ã |
| | | 2. `轨éã轮渡` `R2/R11`ï¼ç¡®è®¤å·®å¼ï¼è½¯ä»¶ã8æä¸å»å¹´åæ¯ãvs 人工ã忝ãï¼â æäººå·¥æªè¾æ¹ã |
| | | 3. `ä¸å£å¾æå`ï¼äººå·¥é£ä»½éèè¡¨æ°æ®ä¸å¯¹ãå±ç¤ºä»
1-8 æç´¯è®¡ â 以软件è¾åºä¸ºåã |
| | | 4. `ç线å
车`ï¼Â§4.2ï¼ï¼2021 å¹´ 3 æèµ·ç´¯è®¡åæ¯å¤§é `#DIV/0!`ï¼ä¸ä¸¤è¾¹ååºé´ä¸ä¸è´ï¼çæ `DU:EP` / æå·¥ `TD:EO`ï¼ï¼æ¥åé 220 个 `#VALUE!` æ¬æºå¤ç°ä¸åºæ¥ï¼æ¬å°æ¯çä¸ 9/18 çæä»¶å为 `#DIV/0! 228 + #REF! 8`ï¼ä¸æ¥åã软件è¾åºã两项å®å
¨ä¸è´ï¼ï¼å¤ä¸ºè¯»ç¼åå¼äº§ççåéå¼ï¼å¾
对æ¹ç¨ 9/21 å件夿 ¸ã |
| | | 5. ` è´§è¿` 2022 å¹´ç´¯è®¡åæ¯ï¼Â§4.3ï¼ï¼è½¯ä»¶å¯¹ã |
| | | - å¾
对æ¹åå¤ï¼`è´§è¿å¨è½¬éæå` çãæ é¢ãæåªä¸æ ¼ã`åå¸å®¢è¿` 差弿 ¼å¨åªãå¹¶æä¸¤ä»½æºæä»¶æ¾å
±äº«ä½ç½®ä»¥ä¾¿åæºå¤æ ¸ã |
| | | - æ¬æ¬¡æ ä»£ç æ¹å¨ï¼å±æ ¸å¯¹/ææ¡£ç±»å·¥ä½ï¼ä¸å¦åºãåè½æµè¯æ¥åãï¼ä¸è¿°åæ§å³æ ¸å¯¹è®°å½ã |
| | | |
| | | ## å
«ã追å ï¼ä¿®æ£ã2026å¹´8æéè·¯è¿è¾éæ±æ»è¡¨_çå¼ååãç线å
è½¦é¡µææ¬æ°å¼ |
| | | |
| | | ç¨æ·æå·¥æè¯¥ååæä»¶ãç线å
车ã页鿿¬æ ¼å¼çæ°å¼åå
æ ¼æ¹ææ°å¼æ ¼å¼ï¼æ ¸å¯¹åæäº¤ã |
| | | |
| | | - æä»¶ï¼`docs/çææ±æ»å¤§è¡¨/2026å¹´8æéè·¯è¿è¾éæ±æ»è¡¨_çå¼åå.xlsx`ï¼1,487,539 â 1,354,428 åèï¼ |
| | | - æ¹å¨èå´ï¼`ç线å
车` 页第 8-57 è¡ Ã `FV:IX` åï¼å
± **196 æ ¼ `ææ¬ â æ°å¼`**ï¼å¦ `'33,437.0000'` â `33437`ï¼ï¼éæ ¼æ¯å¯¹æ°å¼**å®å
¨çä»·ï¼0 å¤ä¸å¹é
**ã |
| | | - å
¶ä½é¡µå·®å¼å± 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 éæ ¼æ¯å¯¹ç±»åä¸å¼ï¼ä¸´æ¶æä»¶ä¿çï¼æªå ï¼ã |