# office办公技巧 (@1212722759) on douyin

- id: koinon:creator:douyin_1212722759
- url: https://koinonlink.com/kol/douyin/1212722759
- schema_version: 1.4

## Identity
- platform: douyin
- handle: 1212722759
- platform_url: https://www.douyin.com/user/MS4wLjABAAAAwRvp2r6uOEzY1nRgg-xtzCo3BwskIOgzAbi279Dvn8s
- country: China
- entity_type: creator
- person_id: Cross-platform identity not resolved for this creator.

## Reach
- followers: 86755
- following: 45
- posts_total: 761
- posts_observed: 3
- verified: true
- size_tier: koc

## Engagement
- status: peak_post_only
- peak_post_engagement_rate: 0.1085
- best_post_interactions: 9413
- measurement_source: cn_posts_max
- measurement_formula: likes + comments + shares (douyin) or likes + comments + collects (xiaohongshu), max over observed posts
- comparable_pool: peak_interactions
- status_note: We have only the single best observed post, so no mean exists. peak_post_engagement_rate is an UPPER BOUND, systematically higher than an average — never compare it against an average rate.
- unit_note: engagement_rate and peak_post_engagement_rate are ratios (0-1); avg_interactions_per_post and best_post_interactions are absolute counts. Read status before reading any number: a null rate has several different causes and status says which one applies here.

## Content
- category: software
- subcategory: devtools
- category_confidence: 0.9
- category_source: derived_from_recent_content
- topics: Excel函数嵌套应用, VLOOKUP与MATCH组合查询, SUMPRODUCT/SUMIF多条件计算, Word格式调整技巧, 成都本地Excel培训与考证
- bio: 分享office技巧，提高办公效率，转岗加薪
分享演示版本为：office365

## Audience (inferred)
- status: present
- description: Office workers and data processing staff, primarily employed professionals and exam candidates who rely on Excel for daily reporting, data lookup, and analysis
- roles: data
- seniority: practitioner
- pain_points: Struggling with complex formula nesting leads to incorrect results, Multi-condition summing and counting are cumbersome and error-prone, Difficult to manage sorting and formatting issues with merged cells, Insufficient Excel skills hinder productivity and career advancement opportunities
- posts_analysed: 27
- confidence: 0.6

## Commercial (inferred)
- audience_buyer_fit: 0.3
- promotion_intent: 0.2
- open_to_collaboration: false
- contact: Koinon does not publish creator contact details.

## Quality signals
- authenticity_score: 70
- authenticity_basis: engagement_observed
- credibility_score: 74
- flagged_for_review: false
- koinon_bd_grade: C — measures Koinon partner-outreach fit, not creator quality
- interpretation: Signals for triage, not verdicts. A flag means the profile is worth a manual check.

## Evidence
- [douyin_1212722759#bc37c562] #excel技巧 #excel函数 #excel教学  vlookup和match函数嵌套运用？ (https://www.douyin.com/user/MS4wLjABAAAAwRvp2r6uOEzY1nRgg-xtzCo3BwskIOgzAbi279Dvn8s)
- [douyin_1212722759#9ea57ba4] @office办公技巧创作的原声
- [douyin_1212722759#df9aea87] vlookup函数函数从简单运用到复杂嵌套案例
- [douyin_1212722759#f6ace5b6] 这么有趣的合集，不能只有我一个人知道吧
- [douyin_1212722759#ac6c1536] #excel技巧 #excel函数 #excel vlookup函数和match的嵌套查询结果的多列数据？
- [douyin_1212722759#34e1c560] #excel函数 #excel技巧 #上热门 如何用vlookup函数返回同一查询结果的多列数据？
- [douyin_1212722759#9c109139] 成都excel内训：批注批量添加修改作者和内容 #excel #excel #excel #如何添加
- [douyin_1212722759#d9158b60] #word办公技巧 #成都电脑培训 #office培训   在word中点击u命令不出现下划线的原因？

## Provenance
Every inferred field below carries how it was produced. Facts stay facts; inferences stay inferences.

- audience.description: source_type=ai_inferred, confidence=0.6, freshness_days=84, method=llm_persona_from_recent_content
- audience.roles: source_type=ai_inferred, confidence=0.6, freshness_days=84, method=llm_persona_from_recent_content
- audience.seniority: source_type=ai_inferred, confidence=0.6, freshness_days=84, method=llm_persona_from_recent_content
- commercial.audience_buyer_fit: source_type=ai_inferred, confidence=0.6, freshness_days=85, method=llm_scorer — Relative signal within Koinon indexing, not a market-wide score.
- commercial.promotion_intent: source_type=ai_inferred, confidence=0.6, freshness_days=85, method=llm_scorer
- quality.anomaly_flags: source_type=heuristic, confidence=0.5, freshness_days=107, method=profile_snapshot_and_engagement_ratio_heuristic — Means "worth a manual check", NOT confirmed fraud. Flags can be wrong and are not a verdict about the person.
- quality.authenticity_score: source_type=heuristic, confidence=0.5, freshness_days=85, method=Starts at 60; interactions-per-follower on collected posts then adds or subtracts (large following with near-zero engagement is penalised heavily). — The input set differs by platform; do not compare this score across platforms.
- quality.koinon_bd_grade: source_type=ai_inferred, confidence=0.5, freshness_days=107, method=llm_partner_fit_classifier + authenticity >= 55 AND fit_score >= 0.45 => A; authenticity >= 40 AND fit_score >= 0.3 => B; else C. authenticity < 30 or a promotional-pattern flag => quarantine. — Koinon partner-outreach fit, not creator quality.
- reach.followers: source_type=observed, confidence=0.95, freshness_days=107, method=platform_profile

## Freshness
- profile_checked_days_ago: 107
- content_analysed_days_ago: 85
- audience_updated_days_ago: 84

## AI retrieval
- indexing_requests: 12
- user_triggered_requests: 0
- note: Being indexed in bulk is not the same as being retrieved to answer a question.

## This profile
- Claim or correct: https://koinonlink.com/claim?k=douyin_1212722759
- Request removal: https://koinonlink.com/claim?k=douyin_1212722759
- Terms: https://koinonlink.com/for-ai