qiusuo0226/chrono-pm-skill / governance-shared/baselines/1.16.2
1.16.2
Verifiedreferences/12-excel-generation-rules.md
View on GitHub# Excel 鐢熸垚瑙勮寖
鏈鍒欏畾涔?ChronoPM 鍚勬枃妗g被鍨嬪鍑轰负 Excel 鏂囦欢鏃剁殑缁撴瀯瑙勮寖銆侫I 鐢熸垚 Excel 鏂囦欢鏃跺繀椤婚伒寰湰瑙勮寖锛岀‘淇濆鍑烘枃浠朵笌鐢ㄦ埛鍘熷椤圭洰绠$悊 Excel 缁撴瀯涓€鑷淬€?
---
## 0. 閫氱敤鍘熷垯
### 0.1 涓?xlsx 鎶€鑳介厤鍚?
鐢熸垚 Excel 鏂囦欢鏃讹紝蹇呴』鍚屾椂鍔犺浇 xlsx 鎶€鑳斤紙SKILL.md锛夛紝閬靛惊鍏舵牳蹇冨師鍒欙細
- **鍏紡浼樺厛**锛氱敤 Excel 鍏紡鑰岄潪纭紪鐮佸€?- **闆跺叕寮忛敊璇?*锛氱敓鎴愬悗蹇呴』閫氳繃 recalc 鏍¢獙
- **瑙嗚缇庤**锛氱粺涓€瀛椾綋銆佽〃澶存牱寮忋€佸垪瀹介€傞厤
- **淇濈暀妯℃澘**锛氱紪杈戝凡鏈夋枃浠舵椂鍖归厤鍘熸湁鏍煎紡
### 0.2 鐢熸垚璺緞
Excel 鏂囦欢鐢熸垚鍒?`outputs/{batch_id}/files/` 鐩綍涓嬶紙閬靛惊 `11-output-artifact-rules.md`锛夈€?
### 0.3 鏂囦欢鍛藉悕
鏍煎紡锛歚{scope}-{document_type}-{period_or_date}-{version}.xlsx`
### 0.4 閫氱敤鏍峰紡
| 鍏冪礌 | 瑙勮寖 |
|---|---|
| 瀛椾綋 | 寰蒋闆呴粦 10pt锛堣〃澶村姞绮?11pt锛?|
| 琛ㄥご琛?| 鑳屾櫙鑹?#4472C4锛岀櫧鑹插瓧浣擄紝灞呬腑瀵归綈 |
| 鏁版嵁琛?| 鑷姩琛岄珮锛岄《绔榻?|
| 鍐荤粨绐楁牸 | 鍐荤粨棣栬锛圓1锛?|
| 缃戞牸绾?| 鏄剧ず |
| 鍒楀 | 鏍规嵁鍒楀唴瀹硅嚜鍔ㄩ€傞厤锛屾渶灏?8锛屾渶澶?50 |
| 鏃ユ湡鏍煎紡 | YYYY-MM-DD锛堟枃鏈牸寮忥紝閬垮厤 Excel 鑷姩杞崲锛?|
| 鐧惧垎姣?| 0% 鏍煎紡 |
| 绌哄€?| 鐣欑┖锛屼笉濉?N/A 鎴?- |
### 0.5 鏁版嵁楠岃瘉涓嬫媺妗嗛€氱敤瑙勫垯
鍑℃槸鐘舵€佺被銆佺被鍒被銆佹槸鍚︾被瀛楁锛屽繀椤昏缃暟鎹獙璇佷笅鎷夋锛屼笉鍏佽鑷敱杈撳叆銆?
---
## 1. 闇€姹傝窡韪煩闃?Excel 瑙勮寖
### 1.1 Sheet 缁撴瀯
| Sheet 鍚?| 鍐呭 |
|---|---|
| 闇€姹傝窡韪煩闃?| 鍏ㄩ儴闇€姹傛竻鍗?|
### 1.2 鍒楀畾涔夛紙14鍒楋紝涓庡師濮?Excel 瀹屽叏涓€鑷达級
| 鍒楀簭 | 鍒楀ご | 鍒楀 | 鏁版嵁楠岃瘉 | 璇存槑 |
|---|---|---|---|---|
| A | 灞炴€?| 10 | 涓嬫媺锛氬姛鑳介渶姹?闈炲姛鑳介渶姹?绾︽潫闇€姹?鎺ュ彛闇€姹?鏁版嵁闇€姹?| |
| B | 鍔熻兘鍩?| 12 | - | 濡傦細鎴戣娉ㄩ攢銆佹垜瑕佸彉鏇?|
| C | 鍔熻兘妯″潡 | 15 | - | 濡傦細甯傚満涓讳綋娉ㄩ攢 |
| D | 鍔熻兘鍐呭 | 20 | - | 鍏蜂綋鍔熻兘鐐?|
| E | 鍔熻兘鎻忚堪 | 40 | - | 璇︾粏鎻忚堪 |
| F | 浜у搧 | 10 | - | 浜у搧璐熻矗浜哄鍚?|
| G | 鏄惁瑙勫垝 | 10 | 涓嬫媺锛氭槸/鍚?绾夸笂涓嶆敮鎸?| |
| H | 璇勫鏃堕棿 | 12 | - | YYYY-MM-DD |
| I | 瑙勫垝澶囨敞 | 20 | - | |
| J | 鏄惁寮€鍙?| 10 | 涓嬫媺锛氭槸/鍚?| |
| K | 鏄惁娴嬭瘯 | 10 | 涓嬫媺锛氭槸/鍚?| |
| L | 浜や粯鎴愭灉 | 20 | - | |
| M | 楠屾敹鏍囧噯 | 30 | - | |
| N | 澶囨敞 | 20 | - | |
### 1.3 鎵╁睍鍒楋紙Markdown 妯℃澘涓湁浣嗗師濮?Excel 娌℃湁鐨勫垪锛屽鍑烘椂鍙€夎拷鍔狅級
| 鍒楀簭 | 鍒楀ご | 璇存槑 |
|---|---|---|
| O | Req ID | 闇€姹傜紪鍙?REQ-XXX-NNN |
| P | 浼樺厛绾?| 涓嬫媺锛歁ust/Should/Could/Wont |
| Q | 鏉ユ簮 | 涓嬫媺锛歝ontract/document/meeting/implied |
| R | 鐘舵€?| 涓嬫媺锛歱roposed/confirmed/in_progress/delivered/accepted/changed/cancelled |
| S | 鍏宠仈浠诲姟 | T-YYYYMMDD-NNN |
| T | 鍏宠仈閲岀▼纰?| M-NN |
### 1.4 鍐荤粨涓庣瓫閫?
- 鍐荤粨棣栬
- 棣栬鍚敤鑷姩绛涢€?
---
## 2. 椋庨櫓鐧昏鍐?Excel 瑙勮寖
### 2.1 Sheet 缁撴瀯
| Sheet 鍚?| 鍐呭 |
|---|---|
| 椋庨櫓鐧昏鍐?| 鍏ㄩ儴椋庨櫓璁板綍 |
### 2.2 鍒楀畾涔夛紙15鍒楋級
| 鍒楀簭 | 鍒楀ご | 鍒楀 | 鏁版嵁楠岃瘉 | 璇存槑 |
|---|---|---|---|---|
| A | 椋庨櫓缂栧彿 | 12 | - | R-NNN |
| B | 鍏宠仈闂 | 12 | - | I-NNN |
| C | 椋庨櫓绫诲埆 | 12 | 涓嬫媺锛氬閮?鎶€鏈?璧勬簮/璐ㄩ噺/闇€姹?杩涘害/鎴愭湰/鍚堣 | |
| D | 鐘舵€?| 10 | 涓嬫媺锛氳瘑鍒腑/鐩戞帶涓?宸插叧闂?宸插彂鐢?| |
| E | 椋庨櫓鎻忚堪 | 35 | - | |
| F | 鍙戠敓姒傜巼 | 10 | 涓嬫媺锛氶珮/涓?浣?| |
| G | 褰卞搷绋嬪害 | 10 | 涓嬫媺锛氶珮/涓?浣?| |
| H | 椋庨櫓绛夌骇 | 10 | 涓嬫媺锛氶珮/涓?浣?| |
| I | 瑙﹀彂鏉′欢 | 25 | - | |
| J | 搴斿绛栫暐 | 12 | 涓嬫媺锛氳閬?杞Щ/鍑忚交/鎺ュ彈 | |
| K | 搴斿鎺柦 | 30 | - | |
| L | 璐d换浜?| 10 | - | |
| M | 鍏宠仈璁″垝缂栧彿 | 15 | - | |
| N | 鐘舵€佸彉鏇磋褰?| 25 | - | 濡傦細3/26 璇嗗埆 -> 鐩戞帶涓?-> 6/12 鍙戠敓 |
| O | 澶囨敞 | 20 | - | |
### 2.3 鏉′欢鏍煎紡
| 鍒?| 鏉′欢 | 鏍煎紡 |
|---|---|---|
| H锛堥闄╃瓑绾э級 | 鍊?= "楂? | 绾㈣壊鑳屾櫙 #FFC7CE锛岀孩鑹插瓧浣?|
| H锛堥闄╃瓑绾э級 | 鍊?= "涓? | 榛勮壊鑳屾櫙 #FFEB9C |
| H锛堥闄╃瓑绾э級 | 鍊?= "浣? | 缁胯壊鑳屾櫙 #C6EFCE |
| D锛堢姸鎬侊級 | 鍊?= "宸插彂鐢? | 绾㈣壊鑳屾櫙 #FFC7CE |
| D锛堢姸鎬侊級 | 鍊?= "宸插叧闂? | 鐏拌壊瀛椾綋 #808080 |
---
## 3. 闂璺熻釜琛?Excel 瑙勮寖
### 3.1 Sheet 缁撴瀯
| Sheet 鍚?| 鍐呭 |
|---|---|
| 闂璺熻釜琛?| 鍏ㄩ儴闂璁板綍 |
### 3.2 鍒楀畾涔夛紙15鍒楋級
| 鍒楀簭 | 鍒楀ご | 鍒楀 | 鏁版嵁楠岃瘉 | 璇存槑 |
|---|---|---|---|---|
| A | 闂缂栧彿 | 12 | - | I-NNNN |
| B | 鍏宠仈椋庨櫓 | 12 | - | R-NNN |
| C | 鏉ユ簮 | 15 | 涓嬫媺锛氭棩甯镐緥浼氬彂鐜?璇勫鍙戠幇/椋庨櫓杞寲/娴嬭瘯鍙戠幇/瀹㈡埛鍙嶉 | |
| D | 闂绫诲埆 | 12 | 涓嬫媺锛氭妧鏈被/杩涘害绫?璧勬簮绫?闇€姹傜被/璐ㄩ噺绫?| |
| E | 鐘舵€?| 10 | 涓嬫媺锛氬緟澶勭悊/澶勭悊涓?宸插叧闂?| |
| F | 闂鎻忚堪 | 35 | - | |
| G | 浼樺厛绾?| 15 | 涓嬫媺锛氱揣鎬ワ紙褰撳ぉ蹇呴』瑙e喅锛?楂橈紙鏈懆鍐咃級/涓紙涓ゅ懆鍐咃級/浣庯紙鏈夌┖鍐嶅鐞嗭級 | |
| H | 褰卞搷鑼冨洿 | 20 | - | |
| I | 璐d换浜?| 10 | - | |
| J | 鎻愬嚭鏃ユ湡 | 12 | - | YYYY-MM-DD |
| K | 瑙e喅鏂规 | 30 | - | |
| L | 璁″垝瑙e喅鏃ユ湡 | 12 | - | YYYY-MM-DD |
| M | 瀹為檯瑙e喅鏃ユ湡 | 12 | - | YYYY-MM-DD |
| N | 鏄惁寤舵湡 | 10 | - | 鍏紡锛?IF(AND(L2<>"",M2<>"",M2>L2),"鏄?,"鍚?) |
| O | 澶囨敞 | 25 | - | 鍚窡韪褰?(1)(2)(3) |
### 3.3 鍏紡
**N鍒楋紙鏄惁寤舵湡锛夊叕寮忥細**
```
=IF(AND(L2<>"",M2<>"",M2>L2),"鏄?,"鍚?)
```
鑻ュ疄闄呰В鍐虫棩鏈熶负绌轰絾宸茶秴杩囪鍒掓棩鏈燂紝鍏紡鍙樹綋锛?
```
=IF(L2="","",IF(M2<>"",IF(M2>L2,"鏄?,"鍚?),IF(TODAY()>L2,"鏄?,"鍚?)))
```
### 3.4 鏉′欢鏍煎紡
| 鍒?| 鏉′欢 | 鏍煎紡 |
|---|---|---|
| G锛堜紭鍏堢骇锛?| 鍖呭惈"绱ф€? | 绾㈣壊鑳屾櫙 #FFC7CE |
| E锛堢姸鎬侊級 | 鍊?= "寰呭鐞? | 榛勮壊鑳屾櫙 #FFEB9C |
| E锛堢姸鎬侊級 | 鍊?= "宸插叧闂? | 鐏拌壊瀛椾綋 #808080 |
| N锛堟槸鍚﹀欢鏈燂級 | 鍊?= "鏄? | 绾㈣壊鑳屾櫙 #FFC7CE |
---
## 4. 璁″垝琛?Excel 瑙勮寖
### 4.1 Sheet 缁撴瀯
| Sheet 鍚?| 鍐呭 |
|---|---|
| 杩唬涓€ | 绗竴杩唬浠诲姟 |
| 杩唬浜?| 绗簩杩唬浠诲姟 |
| 杩唬涓?| 绗笁杩唬浠诲姟 |
| 杩唬鍥?| 绗洓杩唬浠诲姟 |
### 4.2 鍒楀畾涔夛紙11鍒楋紝姣忎釜 Sheet 鐩稿悓锛?
| 鍒楀簭 | 鍒楀ご | 鍒楀 | 鏁版嵁楠岃瘉 | 璇存槑 |
|---|---|---|---|---|
| A | 涓€绾т换鍔?| 15 | - | 闃舵鍒嗙被 |
| B | 浜岀骇浠诲姟 | 25 | - | 鍏蜂綋浠诲姟 |
| C | 瀹屾垚鐧惧垎姣?| 10 | - | 0%-100%锛岀櫨鍒嗘瘮鏍煎紡 |
| D | 浜哄憳 | 12 | - | 濮撳悕 |
| E | 璁″垝璧峰鏃堕棿 | 12 | - | YYYY/MM/DD |
| F | 璁″垝鎴鏃堕棿 | 12 | - | YYYY/MM/DD |
| G | 杩涘害鐘舵€?| 10 | 涓嬫媺锛氬凡瀹屾垚/杩涜涓?鏈紑濮?宸叉悂缃?| |
| H | 杈炬垚鏍囧噯 | 20 | - | |
| I | 浜や粯鐗?| 20 | - | |
| J | 鍋忓樊璇存槑/椋庨櫓澶囨敞 | 20 | - | 鏃犲亸宸~ / |
| K | 鏁存敼鎺柦/瀹屾垚鎯呭喌 | 20 | - | 鏃犲~ / |
### 4.3 鏉′欢鏍煎紡
| 鍒?| 鏉′欢 | 鏍煎紡 |
|---|---|---|
| G锛堣繘搴︾姸鎬侊級 | 鍊?= "宸插畬鎴? | 缁胯壊鑳屾櫙 #C6EFCE |
| G锛堣繘搴︾姸鎬侊級 | 鍊?= "杩涜涓? | 钃濊壊鑳屾櫙 #BDD7EE |
| G锛堣繘搴︾姸鎬侊級 | 鍊?= "宸叉悂缃? | 鐏拌壊鑳屾櫙 #D9D9D9 |
| C锛堝畬鎴愮櫨鍒嗘瘮锛?| 鍊?< 0.5 涓?鐘舵€?!= "鏈紑濮? | 榛勮壊瀛椾綋 |
---
## 5. 鎴愭湰娴嬬畻琛?Excel 瑙勮寖
### 5.1 Sheet 缁撴瀯
| Sheet 鍚?| 鍐呭 |
|---|---|
| 鎴愭湰娴嬬畻 | 鎴愭湰缁撴瀯姹囨€伙紙浜哄姏/绗笁鏂?鍏朵粬/绋庨噾/椋庨櫓棰勫閲戯級 |
| 浜哄姏鎴愭湰鏄庣粏 | 鎸変汉鍛樺垪鍑烘槑缁嗚锛堝鍚?鏃ヨ柂/澶╂暟/灏忚锛夆€?璇㈤棶寮忕粏鍖?|
| 瀛愰」鐩姣?| 3涓瓙椤圭洰鐨勫悎鍚岄/鎴愭湰绾?浜烘湀/浜烘棩瀵规瘮 |
### 5.2 鎴愭湰娴嬬畻 Sheet
| 琛?| A鍒?| B鍒?| C鍒?| D鍒?|
|---|---|---|---|---|
| 1 | 鎴愭湰绫诲埆 | 鎴愭湰鏄庣粏 | 娴嬬畻閲戦锛堝厓锛?| 娴嬬畻璇存槑 |
| 2 | 浜哄姏鎴愭湰 | 椤圭洰绠$悊宀?| =浜哄姏鎴愭湰鏄庣粏!D2 | X浜?x XX鍏?鏈?x XX鏈?|
| 3 | | 浜у搧涓庨渶姹傚矖 | =浜哄姏鎴愭湰鏄庣粏!D3 | |
| 4 | | 寮€鍙戝矖 | =浜哄姏鎴愭湰鏄庣粏!D4 | |
| 5 | | 娴嬭瘯涓庡畨鍏ㄥ矖 | =浜哄姏鎴愭湰鏄庣粏!D5 | |
| 6 | 浜哄姏灏忚 | | =SUM(C2:C5) | |
| 7 | 绗笁鏂规垚鏈?| 绗笁鏂瑰伐鍏?缁勪欢 | | |
| 8 | 绗笁鏂瑰皬璁?| | =SUM(C7:C7) | |
| 9 | 鍏朵粬鐩存帴鎴愭湰 | 宸梾涓庢嫑寰?| | |
| 10 | 鍏朵粬灏忚 | | =SUM(C9:C9) | |
| 11 | 绋庨噾 | 澧炲€肩◣鍙婇檮鍔?| =C6*绋庣巼 | 鎸塜%澧炲€肩◣+闄勫姞 |
| 12 | 椋庨櫓棰勫閲?| 闇€姹傚彉鏇?杩斿伐 | =C6*棰勫閲戞瘮渚?| 鎸変汉鍔涙垚鏈琗%璁℃彁 |
| 13 | 鎬绘垚鏈悎璁?| | =C6+C8+C10+C11+C12 | |
| 14 | 椤圭洰姣涘埄 | | =鍚堝悓棰?C13 | |
**鍏紡璇存槑锛?*
- C鍒楅噾棰濆繀椤讳娇鐢ㄥ叕寮忓紩鐢?`浜哄姏鎴愭湰鏄庣粏` Sheet锛屼笉鍙‖缂栫爜
- 绋庣巼鍜岄澶囬噾姣斾緥搴旀斁鍦ㄧ嫭绔嬪崟鍏冩牸锛堝 D11 娉ㄦ槑绋庣巼鍊硷級锛屽叕寮忓紩鐢ㄨ鍗曞厓鏍?- C6 浜哄姏灏忚 = `=SUM(C2:C5)`
- C13 鎬绘垚鏈?= `=C6+C8+C10+C11+C12`
- C14 姣涘埄 = `=鍚堝悓棰濆崟鍏冩牸-C13`
### 5.3 浜哄姏鎴愭湰鏄庣粏 Sheet锛堣闂紡缁嗗寲锛?
**AI 鍦ㄧ敓鎴愭垚鏈祴绠楄〃鏃跺簲璇㈤棶鐢ㄦ埛锛?*
```markdown
鎴愭湰娴嬬畻琛ㄩ渶瑕佸~鍐欎汉鍔涙垚鏈槑缁嗐€傝鎻愪緵浠ヤ笅淇℃伅锛堝彲鎸夎鑹叉眹鎬绘垨鎸変釜浜哄垪鍑猴級锛?
1. 鎸夎鑹叉眹鎬绘ā寮忥細
- 椤圭洰绠$悊宀楋細X浜猴紝XX鍏?鏈堬紝XX鏈? - 寮€鍙戝矖锛歑浜猴紝XX鍏?鏈堬紝XX鏈?
2. 鎸変釜浜烘槑缁嗘ā寮忥細
- 濮撳悕 / 瑙掕壊 / 鏃ヨ柂(鍏? / 鎶曞叆澶╂暟 / 灏忚(=鏃ヨ柂脳澶╂暟)
鏄惁闇€瑕佹寜涓汉鍒楀嚭鏄庣粏锛熻繕鏄寜瑙掕壊姹囨€诲嵆鍙紵
```
**鎸変釜浜烘槑缁嗘ā寮忕粨鏋勶細**
| 鍒楀簭 | 鍒楀ご | 鏁版嵁楠岃瘉 | 璇存槑 |
|---|---|---|---|
| A | 濮撳悕 | - | |
| B | 瑙掕壊 | 涓嬫媺锛氶」鐩鐞?浜у搧/鍚庣寮€鍙?鍓嶇寮€鍙?娴嬭瘯/DBA/鍏朵粬 | |
| C | 鏃ヨ柂锛堝厓锛?| - | 钃濊壊瀛椾綋锛堢‖缂栫爜杈撳叆鍊硷級 |
| D | 鎶曞叆澶╂暟 | - | 钃濊壊瀛椾綋 |
| E | 灏忚锛堝厓锛?| 鍏紡锛?C2*D2 | 榛戣壊瀛椾綋锛堝叕寮忚绠楃粨鏋滐級 |
**E鍒楀叕寮忥細** `=C2*D2`锛堥€愯锛?
**鎴愭湰娴嬬畻Sheet鐨凜2鍗曞厓鏍煎紩鐢細** `=SUMIF(浜哄姏鎴愭湰鏄庣粏!B:B,"椤圭洰绠$悊",浜哄姏鎴愭湰鏄庣粏!E:E)`
### 5.4 瀛愰」鐩姣?Sheet
| 鍒楀簭 | 鍒楀ご | 璇存槑 |
|---|---|---|
| A | 瀛愰」鐩?| 鍏ㄩ摼閫氶噸鏋?浼佷笟閫氶噸鏋?淇$敤鐩戠鐧昏娉ㄥ唽閲嶆瀯 |
| B | 鍚堝悓閲戦锛堜竾锛?| 钃濊壊瀛椾綋锛堢‖缂栫爜锛?|
| C | 50%鎴愭湰绾匡紙涓囷級 | 鍏紡锛?B2*0.5 |
| D | 鎷熸姇鍏ヤ汉鏈?| 钃濊壊瀛椾綋 |
| E | 宸蹭娇鐢ㄤ汉鏃?| 钃濊壊瀛椾綋 |
| F | 浜哄姏鎴愭湰锛堜竾锛?| 鍏紡鎴栧紩鐢?|
| G | 浜哄姏鎴愭湰鍗犳瘮 | 鍏紡锛?F2/B2锛岀櫨鍒嗘瘮鏍煎紡 |
| H | CPI | 鍏紡锛?B2/F2 |
**鏉′欢鏍煎紡锛?*
- G鍒楋紙浜哄姏鎴愭湰鍗犳瘮锛? 50% 鏃剁孩鑹茶儗鏅?- H鍒楋紙CPI锛? 1 鏃剁孩鑹插瓧浣?
---
## 6. 鍛ㄦ姤 Excel 瑙勮寖
### 6.1 Sheet 缁撴瀯
| Sheet 鍚?| 鍐呭 |
|---|---|
| 鍛ㄦ姤 | 2鍒?key-value 鏍煎紡 |
### 6.2 鏍煎紡
2鍒楃粨鏋勶紝闈炰紶缁熻〃鏍硷細
| 琛?| A鍒?| B鍒?|
|---|---|---|
| 1 | **椤圭洰鍛ㄦ姤** | 锛堝悎骞跺崟鍏冩牸 A1:B1锛屾爣棰樿锛?|
| 2 | 椤圭洰鍚嶇О | [鍊糫 |
| 3 | 鎵垮缓鍗曚綅 | [鍊糫 |
| 4 | 鎶ュ憡鍛ㄦ湡 | YYYY骞碝M鏈圖D鏃?- YYYY骞碝M鏈圖D鏃?|
| 5 | 鎶ュ憡鏃ユ湡 | YYYY骞碝鏈圖鏃?|
| 6 | 椤圭洰缁忕悊 | [濮撳悕]锛圼鑱旂郴鐢佃瘽]锛?|
| 7 | | |
| 8 | **涓€銆侀」鐩鍐?* | 锛堝悎骞跺崟鍏冩牸锛屾爣棰樿锛?|
| 9 | 褰撳墠椤圭洰闃舵 | [鎻忚堪] |
| 10 | 閲岀▼纰戝畬鎴愭儏鍐?| [鎸夋ā鍧楀垎娈垫弿杩癩 |
| 11 | 鏁翠綋杩涘害-璁″垝 | XX% |
| 12 | 鏁翠綋杩涘害-瀹為檯 | XX% |
| 13 | 鍋忓樊璇存槑 | [鎻忚堪] |
| 14 | | |
| 15 | **浜屻€佹湰鍛ㄩ」鐩繘灞曟儏鍐?* | 锛堝悎骞跺崟鍏冩牸锛屾爣棰樿锛?|
| 16 | 涓昏宸ヤ綔鍐呭 | [鎸夋ā鍧楀垎缁勯€愭潯鍒楀嚭] |
| 17 | 鎴愭灉/杈撳嚭鐗?| [鍒楀嚭鍙氦浠樻垚鏋淽 |
| 18 | | |
| 19 | **涓夈€佸緟鍗忚皟闂** | 锛堝悎骞跺崟鍏冩牸锛屾爣棰樿锛?|
| 20 | 闂1 | [鎻忚堪] / 寤鸿瑙e喅鏂规鍙婃椂闂?|
| 21 | 闂2 | [鎻忚堪] / 寤鸿瑙e喅鏂规鍙婃椂闂?|
| 22 | | |
| 23 | **鍥涖€佷笅鍛ㄥ伐浣滆鍒?* | 锛堝悎骞跺崟鍏冩牸锛屾爣棰樿锛?|
| 24 | 浠诲姟鐩爣 | [鎸夋ā鍧楀垎缁勯€愭潯鍒楀嚭] |
| 25 | 闇€閰嶅悎浜嬮」 | [搴忓彿/浜嬮」/閰嶅悎鏂筣 |
**鏍峰紡锛?*
- A鍒楀搴?20锛孊鍒楀搴?70
- 鏍囬琛岋紙鍚堝苟鍗曞厓鏍硷級锛氳儗鏅?#4472C4锛岀櫧鑹插姞绮楀瓧浣?- A鍒楁爣绛撅細鍔犵矖锛岄《绔榻?- B鍒楀唴瀹癸細椤剁瀵归綈锛岃嚜鍔ㄦ崲琛?
### 6.3 椤圭洰闆嗘眹鎬诲懆鎶?
椤圭洰闆嗘眹鎬诲懆鎶ヤ笉浣跨敤 key-value 鏍煎紡锛屼娇鐢ㄨ〃鏍兼牸寮忥紙鍙傝 `portfolio-weekly-template.md` 鐨勭粨鏋勶級锛屽寘鍚悇瀛愰」鐩繘灞曟眹鎬昏〃銆佽法椤圭洰浜嬮」琛ㄣ€佷汉鍛樿祫婧愬叏鏅〃銆佹暣浣揚&L琛ㄣ€?
---
## 7. 缁忛獙鏁欒璁板綍鍗?Excel 瑙勮寖
### 7.1 Sheet 缁撴瀯
| Sheet 鍚?| 鍐呭 |
|---|---|
| 缁忛獙鏁欒璁板綍鍗?| 鍏ㄩ儴缁忛獙鏁欒 |
### 7.2 鍒楀畾涔夛紙9鍒楋級
| 鍒楀簭 | 鍒楀ご | 鍒楀 | 鏁版嵁楠岃瘉 |
|---|---|---|---|
| A | 缂栧彿 | 8 | - |
| B | 缁忛獙涓婚 | 20 | - |
| C | 绫诲埆 | 10 | 涓嬫媺锛氳川閲?璧勬簮/鎶€鏈?闇€姹?绠$悊/杩涘害/鎴愭湰 |
| D | 閫傜敤鍦烘櫙 | 20 | - |
| E | 鍏稿瀷鐜拌薄 | 30 | - |
| F | 鍘熷洜 | 25 | - |
| G | 缁忛獙缁撹 | 25 | - |
| H | 鎺ㄨ崘鍋氭硶 | 30 | - |
| I | 鍙鐢ㄨ祫浜?| 20 | - |
---
## 8. 椤圭洰鍩烘湰淇℃伅 Excel 瑙勮寖
### 8.1 Sheet 缁撴瀯
| Sheet 鍚?| 鍐呭 |
|---|---|
| 椤圭洰鍩烘湰淇℃伅 | 鐜淇℃伅銆佽祫婧愰摼鎺?|
| 骞茬郴浜?| 骞茬郴浜烘竻鍗?|
### 8.2 椤圭洰鍩烘湰淇℃伅 Sheet
2鍒?key-value 鏍煎紡锛屽垎缁勶細
| 鍒嗙粍 | 瀛楁 |
|---|---|
| 鍩烘湰淇℃伅 | 椤圭洰鍚嶇О/鎵垮缓鍗曚綅/鍚堝悓鎬婚/椤圭洰缁忕悊 |
| 鐜淇℃伅 | 鍘熸祴璇曠幆澧?淇″垱娴嬭瘯鐜/寮€鍙戠幆澧?鏁版嵁搴?瀹瑰櫒绠$悊/閰嶇疆涓績/CI-CD |
| 璧勬簮閾炬帴 | 鍘熷瀷鍥?璁捐鍥?鎺ュ彛鏂囨。/浠g爜浠撳簱/SFTP澶囦唤 |
**瀹夊叏瑙勫垯锛?* 瀵嗙爜鍒椾笉瀵煎嚭锛屼粎淇濈暀璁块棶璺緞鍜岃处鍙峰悕銆?
---
## 9. 鐢熸垚娴佺▼涓庣‘璁?
### 9.1 鐢熸垚鍓嶇‘璁?
AI 鐢熸垚 Excel 鍓嶅繀椤伙細
1. 璇诲彇 `project-brief.md` 纭椤圭洰淇℃伅
2. 璇诲彇瀵瑰簲 Markdown 浜嬪疄婧愭枃浠惰幏鍙栨暟鎹?3. 璇㈤棶鐢ㄦ埛闇€瑕佺殑 Excel 绫诲瀷锛堝弬瑙?`11-output-artifact-rules.md` 鏍煎紡纭瑙勫垯锛?4. 鎴愭湰娴嬬畻琛ㄩ澶栬闂?鎸夎鑹叉眹鎬昏繕鏄寜涓汉鏄庣粏"
5. 鍒涘缓杈撳嚭鎵规鐩綍
### 9.2 鐢熸垚鍚庨獙璇?
Excel 鏂囦欢鐢熸垚鍚庡繀椤伙細
1. 浣跨敤 xlsx 鎶€鑳界殑 `recalc` 妯″潡鏍¢獙鍏紡
2. 浣跨敤 xlsx 鎶€鑳界殑 `audit` 妯″潡瀹¤鍏紡缁撴瀯
3. 纭鎵€鏈夋暟鎹獙璇佷笅鎷夋宸茶缃?4. 纭鎵€鏈夋潯浠舵牸寮忓凡搴旂敤
5. 纭鍐荤粨绐楁牸宸茶缃?6. 鏇存柊 `manifest.md` 鍜?`outputs/index.md`
### 9.3 鐜鍏煎
鑻ュ綋鍓嶇幆澧冩棤娉曠敓鎴?.xlsx 鏂囦欢锛屾寜 `11-output-artifact-rules.md` 绗?14 鑺傜幆澧冨吋瀹硅鍒欏鐞嗐€?
---
## 10. 涓?Markdown 妯℃澘鐨勫搴斿叧绯?
| Excel 鏂囦欢 | Markdown 浜嬪疄婧?| 璇存槑 |
|---|---|---|
| 闇€姹傝窡韪煩闃?| requirements/requirement-register.md | 鍒楃粨鏋勫畬鍏ㄥ搴旓紝Excel 棰濆鏈夋暟鎹獙璇佸拰绛涢€?|
| 椋庨櫓鐧昏鍐?| risks/risk-register.md | Excel 棰濆鏈夋潯浠舵牸寮?|
| 闂璺熻釜琛?| issues/issue-register.md | Excel 棰濆鏈夊欢鏈熷叕寮忓拰鏉′欢鏍煎紡 |
| 璁″垝琛?| tasks/board.md | Excel 鎸夎凯浠e垎 Sheet |
| 鎴愭湰娴嬬畻琛?| plans/budget.md | Excel 鏈変汉鍔涙垚鏈槑缁?Sheet 鍜屽叕寮?|
| 鍛ㄦ姤 | reports/weekly/褰撳墠鍛?md | Excel 鐢?key-value 鏍煎紡 |
| 缁忛獙鏁欒璁板綍鍗?| reviews/lessons-learned.md | 鍒楃粨鏋勫畬鍏ㄥ搴?|
| 椤圭洰鍩烘湰淇℃伅 | context/project-context.md | Excel 鐢?key-value 鏍煎紡 |
| 椤圭洰闆嗘眹鎬诲懆鎶?| portfolio/reports/weekly/褰撳墠鍛?md | Excel 鐢ㄨ〃鏍兼牸寮?|
| 浜哄憳璧勬簮鐧昏琛?| portfolio/resources/resource-register.md | Excel 鏈夊蹇嶅害鍏紡鍜屾潯浠舵牸寮?|
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack." | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |