| | |
| | | - è¾åº `æ ¡éªæ¥é_<å¹´æ>.xlsx` ä¸ `è¿è¡æ¥å¿_<å¹´æ>.md`ã |
| | | 3. å便¬¡æ¥ Step2ï¼æ±æ»è¡¨ï¼ãStep3ï¼ä¸å¼ åºå®è¡¨ + 亿å
æèµé¡¹ç®ä¸å±åè§åï¼ã |
| | | 4. è¥ç¨æ·ç¡®è®¤ `docs\æèµ\` çæä»¶æ´çï¼ä¸å¹¶æäº¤å¹¶è¡¥æ¨å
¬å¸ giteaï¼è¥æ¢å¤ï¼ã |
| | | |
| | | --- |
| | | |
| | | ## äºãä¸å追å ï¼ç¨æ·æ ¸å¯¹æºæä»¶åï¼ |
| | | |
| | | ### 5.1 ç¨æ· 4 ç¹åé¦çæ ¸æ¥ä¸å¤ç½® |
| | | |
| | | | ç¨æ·åé¦ | æ ¸æ¥ç»è®º | å¤ç½® | |
| | | | --- | --- | --- | |
| | | | â â¡ãä½ æè¡¨è¯´æ¸
æ¥ï¼æ¯å®¢è¿ç«è¿æ¯ç©æµååºï¼æçåå °ç表没æä½ 说çæ
åµã | **ç¨æ·æ²¡çé**ï¼é£äºå
容æ¯**éèè¡ / éè表**ãä¾ï¼åå °ç©æµ R11âR63ï¼53 è¡ï¼æ¯éèè¡ï¼å
å®¹ä¸ºãæ¦æ±ãåå²åºåï¼æ½æ± 26/27 å¼ è¡¨è¢«éè | æ°å¢åªè¯»å·¥å
· `éèé¡¹æ¢æµ.py` + æ¸
åãéèæ°æ®æ ¸å®æ¸
å_2026-07.mdãï¼éæä»¶åæ¸
ï¼åç±»/æä»¶/å·¥ä½è¡¨/éèè¡åºé´/éèå
容/æä¹åæ¶éèèªå·±éªè¯ï¼ | |
| | | | â¢ã`.et` å³ç§»ä¸ç¨ç®¡ï¼æä»¬åªç®¡è¦æ´æ°çåæ®µã | ä¸ç¨åºå®ç°æ¹åä¸è´ | 差弿¥åãæ å°è¡¨åæ æ³¨ãä¸åå¤çã | |
| | | | â£ãæ©æ½åé»ç³ä¹æ¯åäºçï¼åªæ¯æ²¡å¨è¡¨å¤´åï¼ä¸æ´æ°å»ºè®¾é¶æ®µåã | 䏿ºæä»¶ç¸ç¬¦ | 该é£é©é¡¹**å
³é** | |
| | | |
| | | ### 5.2 æ¬è½®æéè¦çææ¯ç»è®º |
| | | |
| | | - **ãéèè¡ / éèå·¥ä½è¡¨ãä¸è½ä½ä¸ºè¿æ»¤æ¡ä»¶**ï¼é»ç³ç©æµéèè¡ R10 æ¯çå®é¡¹ç®è¡ã鳿°å¿ç¦å±±ç©æµä»å¨ä¸å¿ãï¼æ åºå·ï¼ï¼ä¸**已计å
¥**第 5 è¡ãé»ç³ãå¸å·å计ââå项æ°å¼éé¡¹æ ¸å¯¹ç¸çï¼è®¡åæ»æèµ 564,991.69 / èªå¼å§å»ºè®¾ç´¯è®¡ 59,500.20 / èªå¹´å累计 34,978.15 / æ¬æå®æ 7,088.90ï¼ã |
| | | - åè¿æ¥ï¼ãå¯è§ãä¹ä¸çäºãæ¬ææ°æ®ãï¼æ½æ± `æ½æ±2026.07.xlsx` åªæ 1 å¼ å¯è§è¡¨ï¼è¡¨åå« `æ½æ±ä¼ å2022.3`ï¼è£
çå´æ¯ 2026 å¹´ 7 ææ°æ®ã |
| | | - æä»¥åæ°å¤å®åªç¨ä¸æ¡ï¼**â è¡¨å¤´æ¥æé表ï¼â¡ å¸å·è¡å段ï¼â¢ 项ç®è¡å¤å®ï¼åºå·/åç§°/æ°å¼éç¹ï¼**ã |
| | | - é带åç°ï¼å¸å®å®¢è¿éè表 `RQYQRYQS` å« Excel 4.0 å®ç
æ¯æ®çåæ ·ï¼`Classic.Poppy by Vic` / `Infect Workbook`ï¼ï¼å·²å»ºè®®ç¨æ·ææ¯ï¼æä¸å¨æºæä»¶ï¼ã |
| | | |
| | | ### 5.3 ä¿®å¤ä¸éªè¯ |
| | | |
| | | - `æ ¼å¼æ¢æµ.py` å¢å **å¸å·å段**ï¼`CITIES` + `city_segments()`ï¼ï¼åå °ç©æµé¡¹ç®è¡ç± **38 è¡ä¿®æ£ä¸º 7 è¡**ï¼ä¸æ§ç»æéæä»¶ diffï¼å
¶ä½ 26 个æä»¶**é¶åå**ï¼æ åå½ï¼ã |
| | | - 差弿¥åæ°å¢ H5 é£é©é¡¹ä¸ãä¸ãæ´æ£è®°å½ãï¼åè½æµè¯æ¥åæ°å¢ TC12âTC15ï¼**å
¨é¨éè¿**ã |
| | | |
| | | ### 5.4 éçï¼æ¬è½®æªéç¯ï¼ |
| | | |
| | | - **æ å°è¡¨ xlsx æªåå
¥**ï¼`åæ®µæ å°è¡¨_èæ¡_2026-07.xlsx` 被 WPS æå¼å ç¨ï¼ç®å½ä¸åå¨ `~$åæ®µæ å°è¡¨_èæ¡_2026-07.xlsx` éæä»¶ï¼ï¼`PermissionError`ã订æ£èæ¬ `_qa_out\patch_map.py` å·²å¤å¥½ï¼**å
³é该æä»¶åéè·å³å¯**ï¼ä¼è¡¥ä¸ Sheet3 çãéèé¡¹æ ¸å®ãåãä¿®æ£åå °/æåº/æ½æ±/é»ç³çè¡ï¼Sheet6 æ´æ°åå °ãæ½æ±æåºãè¥é³ãæ©æ½é»ç³ï¼å¹¶æ°å¢ãéèè¡ä¸è½å½è¿æ»¤æ¡ä»¶ã䏿¡ï¼ã |
| | | - å
¬å¸ gitea ä»ä¸éã |
| | | |
| | | --- |
| | | |
| | | ## å
ãåæè¿½å ï¼`.et` å¯è¯»æ§è®¢æ£ + å¾
确认æ¸
åï¼ |
| | | |
| | | ### 6.1 æ ¸å®ãä»åºé 4 个被æ¹å¨çæä»¶ã |
| | | |
| | | ç¨æ·ç¡®è®¤è¦æå
æ ¸å®ãé个æ HEAD çæ¬ä¸å·¥ä½åºçæ¬å**éåå
æ ¼æ¯å¯¹**ï¼ |
| | | |
| | | | æä»¶ | ç»æ | |
| | | | --- | --- | |
| | | | `è¾å
¥\客è¿ï¼å®¢è¿ç«ï¼\7æ\2026å¹´7æç«åºåºæï¼åå±±ãæ±å£ç«ï¼.xlsx` | æ°æ® **0 å¤å·®å¼**ï¼10Ã15 å
¨åï¼ | |
| | | | `è¾å
¥\客è¿ï¼å®¢è¿ç«ï¼\7æ\è¥é³å¸éè·¯è¿è¾æå¡ä¸å¿2026å¹´6ææèµ (1).et` | 7 å¼ åæè¡¨**éå¼ 0 å¤å·®å¼** | |
| | | | `模æ¿\模æ¿_å
¨çé¢å®æè®¡åè¿åº¦æ
嵿±æ».xls` | æ°æ® **0 å¤å·®å¼**ï¼272Ã28 å
¨åï¼ | |
| | | | `模æ¿\模æ¿_ç»æµå¼ºå¿æèµç»è®¡æ¥è¡¨.xls` | æ°æ® **0 å¤å·®å¼**ï¼45Ã17 å
¨åï¼ | |
| | | |
| | | â åèå·®å¼åªæ¯ Excel/WPS éæ°ä¿åé æçæ ¼å¼éåï¼**æ²¡ææ°æ®é£é©**ï¼æ¯å¦è¿åçç¨æ·ææ¿ã |
| | | |
| | | ### 6.2 订æ£ä¸ä¸ªéè¯¯å¤æï¼`.et` å
¶å®è½è¯» |
| | | |
| | | ä¹åæ `.et` 彿ãxlrd/openpyxl é½è¯»ä¸äºï¼å¿
é¡» Excel COMãã宿µæä»¶å¤´æ¯ `D0CF11E0A1B11AE1`ââ**OLE2 å¤åææ¡£ / BIFF8**ï¼`xlrd` ç´æ¥å°±è½è¯»ï¼è¥é³å®¢è¿ `.et` ç 7 å¼ åæè¡¨å
¨é¨è¯»åºï¼`2026å¹´1æ`â`2026å¹´7æ `ï¼ã已修两个工å
·ä¸å·®å¼æ¥å/æ ¸å®æ¸
å/æ å°è¡¨ï¼éèé¡¹æ¢æµè¦çç± 26 个æä»¶æ©å° **27/27**ã |
| | | |
| | | ### 6.3 产åºãå¾
确认æ¸
å_2026-09-17.mdã |
| | | |
| | | æç¨æ·è¦æ±æå¼å·¥åå¿
é¡»å®çå£å¾åæãå¾éçã确认表ï¼13 æ¡ï¼ï¼æ¯æ¡é½ç»ç°ç¶ + é项 + æçå»ºè®®ï¼ |
| | | - **é»å¡ Step1 ç 5 æ¡**ï¼æç»è¡¨æ´æ°åªå åã客è¿ç¼º 7 å¸å·æä¹å¤çãæ ¡éªçä¸æåºæ°ä»åªæ¥ãæ½æ±åªæ 1 个项ç®è¡ãæ¦æ±ç®è¡¨æ å»ºè®¾é¶æ®µåï¼ |
| | | - Step2/3 ç 4 æ¡ï¼æ±æ»è¡¨æ´æ°åªäºåï¼å« `W=1-7æç´¯è®¡` 表头è¦ä¸è¦è·çæä»½æ¹ï¼ã亿å
æèµé¡¹ç®ã3 é¡¹ãæ¯åªä¸é¡¹ã1 æåºæ°ååªåãç¼å· 3/4 æ¯å¦åä¸ä»½æä»¶ï¼ |
| | | - æ¶å°¾ 4 æ¡ï¼è¾åºç®å½/å½å/å¤ä»½ã4 ä¸ªè¢«æ¹æä»¶æ¯å¦è¿åã`docs\æèµ\` æªæäº¤æ¹å¨æ¯å¦æäº¤ã"æ¯ææ¯å¦è¿è¦å模æ¿"ï¼ç¨æ·è¯´è¦è¯·æåäºï¼æç¼ï¼ã |
| | | |
| | | ### 6.4 å¾
å |
| | | |
| | | - çç¨æ·æç¡®è®¤è¡¨å¾å® â åå¡«æ å°è¡¨ Sheet6 â ç«å³è½å° **Step1**ã |
| | | |