From 84819d1bded641ad111a456e4e88a2810dea310f Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期四, 17 九月 2026 14:17:30 +0800
Subject: [PATCH] feat(投资): 新增市州月报解析引擎（Step1 地基）+ 回填用户口径确认

---
 docs/问题汇总/问题与注意事项汇总_2026-09-16.md |  106 +++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 106 insertions(+), 0 deletions(-)

diff --git "a/docs/\351\227\256\351\242\230\346\261\207\346\200\273/\351\227\256\351\242\230\344\270\216\346\263\250\346\204\217\344\272\213\351\241\271\346\261\207\346\200\273_2026-09-16.md" "b/docs/\351\227\256\351\242\230\346\261\207\346\200\273/\351\227\256\351\242\230\344\270\216\346\263\250\346\204\217\344\272\213\351\241\271\346\261\207\346\200\273_2026-09-16.md"
index 0a57680..a4ecacb 100644
--- "a/docs/\351\227\256\351\242\230\346\261\207\346\200\273/\351\227\256\351\242\230\344\270\216\346\263\250\346\204\217\344\272\213\351\241\271\346\261\207\346\200\273_2026-09-16.md"
+++ "b/docs/\351\227\256\351\242\230\346\261\207\346\200\273/\351\227\256\351\242\230\344\270\216\346\263\250\346\204\217\344\272\213\351\241\271\346\261\207\346\200\273_2026-09-16.md"
@@ -181,3 +181,109 @@
 | 6 | 浠撳簱鏍圭洰褰曞ぇ閲� `_*.*` 涓存椂鏂囦欢 | 浣撶Н/鍙鎬� | 缁忕敤鎴峰悓鎰忓悗鍐嶆竻鐞� |
 
 > 2026-09-16 鍌嶆櫄鏇存柊锛氶仐鐣欓棶棰� 4锛堥瑙堝脊绐椼�屽叡 0 琛屻�嶆枃妗堬級宸叉寜鐢ㄦ埛纭淇敼瀹屾瘯鈥斺�旀眹鎬诲ぇ琛ㄦ敼涓烘樉绀恒�屾寚鏍� N 椤广�嶏紝鍏跺畠鎶ヨ〃鏄剧ず銆屽叡 N 琛屾槑缁嗐�嶃��
+
+---
+
+## 鍗佷簩銆�2026-09-16 琛ュ厖锛氳揣杩愰〉绛俱�岀疮璁°�嶅垪淇锛堥噸瑕佸彛寰勶級
+
+### 12.1 姣嶇増娲剧敓鍙ｅ緞锛堝繀椤婚伒瀹堬級
+
+銆� 璐ц繍銆嬮〉琛岀粨鏋勶細
+- 鍏ㄧ渷鍧楋細r5 璐ц繍閲� / r6 鍛ㄨ浆閲� / r7 鍏朵腑瑙勪笂璐ц繍閲� / r8 鍏朵腑瑙勪笂鍛ㄨ浆閲� / r9 鍏朵腑瑙勪笅璐ц繍閲� / r10 鍏朵腑瑙勪笅鍛ㄨ浆閲忥紱
+- 17 涓競宸炲潡姣忓潡 6 琛岋紝棣栬 11,17,23,...,107锛堟姹夊競...鏋楀尯锛夛紝鍧楀唴椤哄簭锛氬悎璁¤揣杩愰噺 / 瑙勪笂璐ц繍閲� / 瑙勪笅璐ц繍閲� / 鍚堣鍛ㄨ浆閲� / 瑙勪笂鍛ㄨ浆閲� / 瑙勪笅鍛ㄨ浆閲忋��
+
+**瑙勫垯锛氬叏鐪佽蹇呴』瀹屽叏鐢� 17 甯傚窞琛屾淳鐢熴��**
+- r7 / r8 / r9 / r10 = SUM(17 甯傚窞瀵瑰簲琛�)锛�
+- r5 = m7+m9锛宺6 = m8+m10銆�
+
+鍘嗗彶鏁欒锛歳9/r10锛堝叏鐪佽涓嬶級鏇炬槸**鍐欐甯搁噺**锛屼笌 17 甯傚窞瑙勪笅涔嬪拰涓嶇瓑 鈥斺�� 2023 宸� 4.6e-3銆�2022 宸� 3.1e-3銆�2021 宸� 1.5e-4锛�2024/2025/2026 鎭板ソ涓� 0锛夛紝瀵艰嚧 6 涓疮璁″垪閲� 2022/2023 姣旀簮鏂囦欢浜哄伐鏍哥畻宸� 0.003 宸﹀彸銆�2021 鏁村垪涓虹┖銆�2026-09-16 宸插叏閮ㄦ敼涓哄叕寮忋��
+
+绱鍒楃幇鐘讹紙鍏ㄧ渷琛岋紝4 浣嶅皬鏁颁笌婧愭枃浠朵竴鑷达級锛�
+
+| 鍒� | 骞村害 | 鍏紡 |
+|---|---|---|
+| S | 2026(1-8鏈�) | C+E+G+I+K+M+O+Q |
+| AT | 2025 | V+X+...+AR |
+| BV | 2024 | AX+AZ+...+BT |
+| CW | 2023 | BY+CA+...+CU |
+| DZ | 2022 | =SUM(DM:DX)锛堝師涓哄啓姝诲父閲忥級 |
+| EO | 2021 | =SUM(EC:EN)锛堝師涓�**绌�**锛� |
+| EP | 2021 绱鍚屾瘮 | 淇濇寔涓虹┖锛堥〉鍐呮棤 2020 鍧楋紝鏃犲熀鏈燂級 |
+| EA | 2022 绱鍚屾瘮 | =IFERROR(DZ/SUM(EC:EN)-1, 绌轰覆)锛堝師涓哄啓姝诲父閲忥級 |
+
+### 12.2 姣嶇増鏀瑰姩鏂瑰紡涓庢枃浠惰亴璐�
+
+- **蹇呴』鐢� Excel COM**锛堟敼鍏紡 -> CalculateFullRebuild -> Save锛夛紝**涓嶅彲鐢� openpyxl 鍙﹀瓨**锛氫細娓呯┖鍏ㄦ湰鍏紡缂撳瓨鍊硷紙鏇惧鑷� 2021 骞存箹鍖楃渷琛屽彉 0锛夈��
+- 瀵煎嚭浠堕噷鐨勫叕寮�**鏃犵紦瀛樺��**锛歰penpyxl(data_only=True) 璇诲嚭鏉ュ叏鏄� None锛屾牳瀵规暟鍊煎繀椤荤敤 Excel COM 閲嶇畻鎴栬嚜鍐欐眰鍊煎櫒銆�
+- 鏂囦欢鑱岃矗锛�
+  - YYYY骞碝鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx = **姣嶇増**锛堝敮涓�鏁版嵁鏉ユ簮锛夛紱
+  - 鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃.xlsx = **鍙綔鍒楀鍙傜収**锛坅pplySummaryReferenceLayout 鍙鍒楀/闅愯棌鏍囪锛屼笉璇绘暟鍊硷級锛�
+  - 2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃_鐗堝紡鍘熷瀷.xlsx = 杩愯鏃�**鏃犱换浣曚唬鐮佸紩鐢�**銆�
+- 鍚屾湡澶囦唤姣嶇増杩樺師鏈哄埗锛歳esolveSummaryDonor 鍙鏂囦欢鍚�**浠� `_澶囦唤_` 寮�澶翠笖鍚�寋骞磢鏈堛��**鐨勬枃浠讹紝鍛戒腑鍗虫暣鏍煎洖濉鐩栨瘝鐗堛��=> 鑷缓鐨勫浠芥枃浠�/鐩綍**涓嶈**鐢� `_澶囦唤_` 鍓嶇紑锛屽惁鍒欏彲鑳借褰撴垚 donor 鎶婃瘝鐗堟敼鍥炴棫鍊笺��
+
+### 12.3 鏂囨湰澶勭悊鐨勫潙锛堟湰鏈� PowerShell / git锛�
+
+| 闂 | 鍘熷洜 | 澶勭疆 |
+|---|---|---|
+| 鍏紡琚啓鎴� =SUM(DM5) | "$m7" 琚В鏋愪负鍙橀噺 m7锛�"$r:DX" 閲岀殑 $r:DX 琚綋鎴愩�岄┍鍔ㄥ櫒 r:銆嶈�屽悶鎺� | 涓�寰嬬敤 ${m} / ${r} 瀹氱晫 |
+| 鍛戒护鏁翠綋涓嶆墽琛屻�佹棤杈撳嚭銆侀��鍑虹爜 1 | 涓�涓懡浠ら噷鍑虹幇**宓屽鐨勫崟寮曞彿 here-string**锛屽灞傚湪绗竴涓粨鏉熺澶勬彁鍓嶇粨鏉� | 涓�涓懡浠ゅ彧鏀句竴涓� here-string锛涙垨鍏� Out-File 鍐欒ˉ涓佹枃浠讹紝鍐嶇敤 Get-Content -Raw |
+| apply_patch 浼犲琛屽弬鏁板け璐� | .bat 鍖呰鍣ㄧ牬鍧忎簡澶氳鍙傛暟 | 鐩存帴璋� codex.exe --codex-run-as-apply-patch $patch |
+| git commit -m 鎶� "outside repository" | PowerShell 鐢ㄥ弽寮曞彿杞箟锛屾秷鎭噷鐨勫弽鏂滄潬+寮曞彿浼氭彁鍓嶇粨鏉熷瓧绗︿覆 | 鐢� git commit -F <娑堟伅鏂囦欢> |
+| PS5.1 鎶ヤ贡鐮佽矾寰勩�屾棤娉曟壘鍒� ...銆� | PS7 鐨� Out-File -Encoding utf8 鍐欑殑鏄�**鏃� BOM** UTF-8锛孭S5.1 鎸� GBK 璇昏剼鏈� | 鍐� .ps1 鏃剁敤 -Encoding utf8BOM |
+
+### 12.4 閬楃暀闂澧為噺锛堟埅鑷� 2026-09-16 鏅氾級
+
+| # | 闂 | 褰卞搷 | 鐘舵�� |
+|---|---|---|---|
+| 7 | h2032_enterprise_monthly 2026-09 鑴忔湡锛堝疄涓� 8 鏈堟枃浠惰瀛樹负 9 鏈堬級 | 636 琛� + import_batch 302 | **宸插垹闄�**锛岀暀鍙繕鍘� SQL 澶囦唤 |
+| 8 | 銆� 璐ц繍銆嬮〉绱鍒� 2021/2022/2023 瀵逛笉涓婁汉宸ユ牳绠� | 宸蹭慨姣嶇増娲剧敓鍙ｅ緞锛�6 鍒楀叏閮ㄥ涓� | **宸茶В鍐�** |
+| 9 | 2026-09 鏈熻繕鍦� h204_vehicle_quarterly(1284 琛�) / investment_monthly(31 琛�) / audit_result(2061 琛�) / audit_run(3 琛�) | 鑻ユ寜 2026-09 鍑烘姤琛ㄤ細鍙栧埌鑴忔暟鎹� | 寰呯敤鎴风‘璁ゆ槸鍚︽竻鐞� |
+| 10 | 2026-07 瀵煎嚭浠躲�� 璐ц繍銆嬮〉涓� 118x145锛堟瘮 8 鏈堝皯 2 鍒楋級 | 7 鏈堟瘝鐗堟槸銆�1-4 鏈堥鏋躲�嶏紝闈炲畬鏁存瘝鐗� | 寰� 7 鏈堟瘝鐗堝畾绋� |
+| 11 | 2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃_鐗堝紡鍘熷瀷.xlsx 鐨� S 鍒楁紡 8 鏈堬紙缂� Q5锛� | 杩愯鏃舵湭琚紩鐢紝鏆傛棤褰卞搷 | 寰呯‘璁よ鏂囦欢鍘荤暀 |
+| 12 | 姣嶇増缁� Excel 閲嶅瓨鍚庝綋绉� 959,706 -> 1,492,121 瀛楄妭锛堝鍑轰欢 950,186 -> 1,331,599锛� | 绾牸寮忓紑閿�锛屾暟鎹棤褰卞搷 | 璁板綍 |
+
+璇﹁銆婂姛鑳芥祴璇曟姤鍛�/鍔熻兘娴嬭瘯鎶ュ憡_璐ц繍椤电绱鍒椾慨澶嶄笌鑴忔湡娓呯悊_2026-09-16.md銆嬨��
+
+---
+
+## 鍗佷笁銆�2026-09-16 琛ュ厖锛�2026-07 姣嶇増琛ラ綈 & 瀵煎嚭浠躲�孍xcel 鎵撲笉寮�銆嶆牴鍥狅紙P0锛�
+
+### 13.1 鐥囩姸涓庢牴鍥�
+
+| 椤� | 鍐呭 |
+|---|---|
+| 鐥囩姸 | `GET /api/report/export/summaryWorkbook?period=2026-07&mode=month` 鐢熸垚鐨� xlsx锛�**Excel 鎵撲笉寮�**锛圕OM 鎶ャ�屼笉鑳藉彇寰楃被 Workbooks 鐨� Open 灞炴�с�嶏紱`CorruptLoad=1` 淇妯″紡鍚屾牱鎵撲笉寮�锛夛紱2026-08 鍚屾帴鍙ｆ甯� |
+| 鐩存帴鍘熷洜 | 瀵煎嚭浠堕噷鏈� **19 涓ā寮忛潪娉曟牸**锛歚<c r="E15" s="111" t="n"><v>67.0</v><is><t>67.00</t></is></c>` 鈥斺�� `t="n"` 涓嶅厑璁稿甫 `<is>`锛坕nlineStr 涓撶敤锛� |
+| 娣卞眰鍘熷洜 | 7 鏈堟瘝鐗堢敱 **openpyxl** 鍐欏嚭锛坄docProps/app.xml` = `Microsoft Excel Compatible / Openpyxl 3.1.5`锛屾枃鏈瓨 `<is>`锛夛紱8 鏈堟瘝鐗堟槸 **Excel 鍘熺敓**锛堟枃鏈蛋 sharedStrings锛夈�侾OI 鐨勯儴鍒嗗啓鍏ヨ矾寰勫彧鏀� `t`/`<v>`銆佷笉娓呮棫 `<is>` |
+| 瑙﹀彂璺緞 | 7 鏈堝瓨鍦� `_澶囦唤_2026骞�7鏈堥亾璺繍杈撻噺姹囨�昏〃_娓呯悊鍓峗20260904.xlsx` 鈫� `restoreSummaryMonthlyBlocks` 鏁存牸鍥炲～ 鈫� 寰� inlineStr 鏍奸噷鍐欏�肩暀涓嬫棫 `<is>`銆�8 鏈堟棤 `_澶囦唤_*`锛屼笉璧板洖濉紝鏁呮甯� |
+| 鍛戒腑浣嶇疆 | leave-one-out 瀹氫綅鍒� **sheet9銆婂叕浜ゃ��17 鏍� + sheet12銆婅建閬撱�佽疆娓°��2 鏍�** |
+
+### 13.2 淇锛坄traffic-audit-server`锛�
+
+1. **`exportSummaryWorkbook` 鏂板 `normalizeStaleInlineStrings(wb)`**锛氳惤鐩樺墠娓呮帀鎵�鏈夈�岄潪 `inlineStr` 鍗存畫鐣� `<is>`銆嶇殑鏍煎瓙锛堝箓绛夛級锛屽懡涓嵆鎵� warn 鏃ュ織銆�
+2. **`restoreSummaryMonthlyBlocks` 鏂板 `skipFreightHistoryBlocks`**锛氥�� 璐ц繍銆嬮〉 **T 鍒楀強浠ュ悗**锛�2025/2024/2023/2022/2021 骞村害鍧� + 鍚勫勾绱/绱鍚屾瘮鍒楋級**姘镐笉浠庡浠芥瘝鐗堝洖濉�** 鈥斺�� 涓庢棦鏈夈�屼腑鍙ｅ緞鎺掑悕宸﹀潡姘镐笉鍥炲～銆嶅悓涓�鎬濊矾锛岄伩鍏嶈ˉ榻愯銆岀敓鎴愬張澶嶆椿銆嶃��
+
+### 13.3 2026-07 姣嶇増琛ラ綈锛堝彛寰勪笌 8 鏈堟瘝鐗堝榻愶級
+
+- 骞村害鍧楋紙姣忓垪锛夛細`r7/r9/r8/r10 = SUM(17 甯傚窞瀵瑰簲琛�)`銆乣r5 = r7+r9`銆乣r6 = r8+r10` 鈫� 360 鏍硷紱
+- 绱鍒楋細`DX = SUM(DK:DV)`锛�2022锛夈�乣EM = SUM(EA:EL)`锛�2021锛屽師**鏁村垪涓虹┖**锛夈�乣DY = IFERROR(DX/SUM(EA:EL)-1,"")`锛�2022 绱鍚屾瘮锛屽師涓�**鍐欐甯搁噺**锛夆啋 324 鏍硷紱
+- 2023 绱 `CU = BW+BY+鈥�+CS` 鏈潵灏辨纭紝鏈敼锛沗EN`锛�2021 绱鍚屾瘮锛夋寜鍙ｅ緞淇濇寔涓虹┖銆�
+- 涓�鎵嬭瘉鎹細姣嶇増 `DX5=144979.2825`锛堟棫甯搁噺 `144979.285376043`锛屽樊 0.0029 = 鍏ㄧ渷瑙勪笅甯搁噺涓� 17 甯傚窞涔嬪拰鐨勫樊锛夈�乣EM5=161309.53162`銆乣CU5=173045.296428512`锛屼笌 8 鏈堟瘝鐗� `DZ5/EO5/CW5` **瀹屽叏鐩哥瓑**銆�
+- 澶囦唤锛歚docs/鐢熸垚姹囨�诲ぇ琛�/_bak_2026骞�7鏈堥亾璺繍杈撻噺姹囨�昏〃_琛ラ綈鍓峗20260916.xlsx`銆�**鍒囧嬁鏀瑰悕涓� `_澶囦唤_` 寮�澶�**锛屽惁鍒欎細琚� `resolveSummaryDonor` 褰� donor 鍥炲～銆�
+
+### 13.4 鏈鏂板鐨勬帓鏌ュ潙
+
+| 闂 | 鍘熷洜 | 澶勭疆 |
+|---|---|---|
+| Excel COM **闂存瓏鎬�**鎶ュ悓涓�涓敊锛屽鑷磋鍒ゃ��8 鏈堜欢涔熸墦涓嶅紑銆� | 姣忔 `New-Object -ComObject Excel.Application` 鐣欎笅鐨�**瀛ゅ効 EXCEL 杩涚▼**浼氭薄鏌撳悗缁疄渚� | 姣忎緥娴嬪畬鎶娿�屾湰娆℃柊寤虹殑 EXCEL 杩涚▼銆嶅己鏉�鍐嶆祴涓嬩竴渚嬶紱`Quit()`+`ReleaseComObject` 骞朵笉澶� |
+| 缂栬瘧鎶ャ�屾壘涓嶅埌 isSetSheetData()銆� | `CTWorksheet.sheetData` 鏄� XSD **蹇呭～**鍏冪礌锛屼笉鐢熸垚 `isSetXxx` | 鏀圭敤 `ctw.getSheetData() != null` |
+| 閮ㄤ欢绾� diff 澶ぇ璺戜笉鍔� | 瀵� 519KB 鐨� `styles.xml` 鐩存帴 `difflib` 鏄� O(n虏) | 鍏堟寜閮ㄤ欢姣斿瓧鑺傚昂瀵�/鏄惁鐩哥瓑锛屽彧鍦ㄥ繀瑕佺殑灏忛儴浠朵笂鍋� diff |
+
+### 13.5 閬楃暀闂澧為噺
+
+| # | 闂 | 褰卞搷 | 鐘舵�� |
+|---|---|---|---|
+| 13 | 2026-06 / 2026-09 鏃犳瘝鐗� | 棰勮 `ready=False`銆屾湭鎵惧埌妯℃澘鏂囦欢銆嶏紝鏃犳硶鍑烘暟 | 闇�鍏堝缓姣嶇増锛堢敤鎴风 5 闂殑寤朵几锛� |
+| 14 | 浠撳簱鏍� `_*.*` 涓存椂鏂囦欢缁х画澧炲锛坄_hyb_*` / `_loo_*` / `_v2_*` / `_final_*` / `_fixed_*` / `_t7_*` / `_poijar`锛� | 浣撶Н/鍙鎬� | 缁忕敤鎴峰悓鎰忓悗鍐嶆竻鐞� |
+
+> 绗� 10 椤癸紙2026-07 瀵煎嚭浠跺皯 2 鍒� / 7 鏈堟瘝鐗堟槸銆�1-4 鏈堥鏋躲�嶏級鏈妭宸插鐞嗭細瀵煎嚭绔細**鑷姩琛ュ嚭 5/6/7 鏈堣〃澶翠笌鍏紡**骞堕噸绠楃疮璁″叕寮忥紝姣嶇増宸茶ˉ榻� 2021/2022/2023 绱鍒楋紝鏁呭叧闂椤广��

--
Gitblit v1.9.1