# Excel办公技巧 (@qijingoffice) on douyin

- id: koinon:creator:douyin_qijingoffice
- url: https://koinonlink.com/kol/douyin/qijingoffice
- schema_version: 1.4

## Identity
- platform: douyin
- handle: qijingoffice
- platform_url: https://www.douyin.com/user/MS4wLjABAAAAorkBxlf8Pft2530AKX0-5JBr7qmSwIkelTtgYOcgnKc
- country: China
- entity_type: creator
- person_id: Cross-platform identity not resolved for this creator.

## Reach
- followers: 61128
- following: 46
- posts_total: 121
- posts_observed: 3
- verified: true
- size_tier: koc

## Engagement
- status: peak_post_only
- peak_post_engagement_rate: 0.00471
- best_post_interactions: 288
- 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: app
- category_confidence: 0.85
- category_source: derived_from_recent_content
- topics: Excel函数与技巧, Word文档快速操作, WPS办公软件使用, 表格数据处理与格式, 零基础办公学习
- bio: 学习办公技巧，提高工作效率！
👍👍拍系统课程发私信👍👍

## Audience (inferred)
- status: present
- description: Office clerks, administrative staff, and beginners learning office software, primarily those who need to handle Excel/Word documents daily as executors and newcomers
- roles: none, data
- seniority: practitioner
- pain_points: Struggling with Excel functions slows down data processing, Repetitive formatting errors in Word, like alignment issues, Time-consuming manual work when adjusting rows and columns in spreadsheets, No basic computer office software skills as a complete beginner
- posts_analysed: 36
- confidence: 0.75

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

## Quality signals
- authenticity_score: 60
- authenticity_basis: engagement_observed
- credibility_score: 72
- flagged_for_review: false
- koinon_bd_grade: B — 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_qijingoffice#7e3df657] 手机如何看课？通过短信激活的方法！ (https://www.douyin.com/user/MS4wLjABAAAAorkBxlf8Pft2530AKX0-5JBr7qmSwIkelTtgYOcgnKc)
- [douyin_qijingoffice#4a40d037] @Excel办公技巧创作的原声
- [douyin_qijingoffice#20b492f0] 零基础学电脑办公#Word#Excel#PPT#零基础学电脑
- [douyin_qijingoffice#1589d660] 快速对齐姓名 #word #办公技巧 #wps #电脑
- [douyin_qijingoffice#02d21dcb] #word #办公技巧 #wps #电脑
- [douyin_qijingoffice#912686a8] 快速删除不连续的行列 #excel技巧 #办公技巧 #office办公技巧 #表格
- [douyin_qijingoffice#f451d08c] #excel技巧 #办公技巧 #office办公技巧 #表格
- [douyin_qijingoffice#ca2bab73] 批量对齐文本 #word #办公技巧 #wps

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

- audience.description: source_type=ai_inferred, confidence=0.75, freshness_days=84, method=llm_persona_from_recent_content
- audience.roles: source_type=ai_inferred, confidence=0.75, freshness_days=84, method=llm_persona_from_recent_content
- audience.seniority: source_type=ai_inferred, confidence=0.75, 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: 8
- 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_qijingoffice
- Request removal: https://koinonlink.com/claim?k=douyin_qijingoffice
- Terms: https://koinonlink.com/for-ai