# 火龙果办公软件入门 (@109808704348) on douyin

- id: koinon:creator:douyin_109808704348
- url: https://koinonlink.com/kol/douyin/109808704348
- schema_version: 1.4

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

## Reach
- followers: 14217
- posts_observed: 4
- verified: false
- size_tier: koc

## Engagement
- status: average_measured
- engagement_rate: 0.01688
- engagement_rate_basis: average_of_observed_posts
- avg_interactions_per_post: 240
- 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: engagement_rate is a MEAN over the posts we observed (posts_in_average says how many).
- 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.8
- category_source: derived_from_recent_content
- topics: Excel基础函数(SUM/SUMIF/SUMIFS), 表格制作与格式化技巧, 快捷键与效率工具, 数据透视表与多表汇总, 会计记账与实用表格模板
- bio: 15年实操办公经验
每天分享电脑办公软件知识
学会办公软件事半功倍，工作更轻松
0基础学办公自动化知识

## Audience (inferred)
- status: present
- description: Office clerks, accountants, and administrative staff who need to master basic Excel/WPS operations
- roles: none
- seniority: practitioner
- pain_points: Don't know how to use functions like SUMIF to quickly process data, Spending too much time creating common templates like attendance sheets or ID card layouts, Complex and error-prone processes when merging multiple tables or summarizing data, Lack of knowledge about keyboard shortcuts and auto-save features leads to low efficiency and lost files
- posts_analysed: 40
- confidence: 0.75

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

## Quality signals
- authenticity_score: 58
- authenticity_basis: engagement_observed
- credibility_score: 46
- 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_109808704348#3cae5982] 一分钟学会制作考勤表#wps #职场加分技能 #office办公技巧 #电脑基础表格教程 #表格 (https://www.douyin.com/user/MS4wLjABAAAAGsXn8gNe0wlIWU_By2D8SCKKJZTW8oYyGJjENv918HE)
- [douyin_109808704348#4b3ad00c] @火龙果办公软件入门创作的原声
- [douyin_109808704348#a07e5f92] 文员必会三大求和公式 #office办公技巧 #excel#excel函数 #excel公式 #文员
- [douyin_109808704348#7a648d5c] SUM函数
- [douyin_109808704348#410164da] SUMIF函数
- [douyin_109808704348#820d9cbc] SUMIFS函数
- [douyin_109808704348#0af6e19c] #office办公技巧 #excel#excel函数 #excel公式 #文员
- [douyin_109808704348#72c4f51f] 3秒快速生成1-12月份工作表#office办公技巧 #excel #wps #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=67, method=llm_persona_from_recent_content
- audience.roles: source_type=ai_inferred, confidence=0.75, freshness_days=67, method=llm_persona_from_recent_content
- audience.seniority: source_type=ai_inferred, confidence=0.75, freshness_days=67, method=llm_persona_from_recent_content
- commercial.audience_buyer_fit: source_type=ai_inferred, confidence=0.6, freshness_days=67, 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=67, method=llm_scorer
- quality.anomaly_flags: source_type=heuristic, confidence=0.5, freshness_days=95, 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=67, 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=95, 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=95, method=platform_profile

## Freshness
- profile_checked_days_ago: 95
- content_analysed_days_ago: 67
- audience_updated_days_ago: 67

## 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_109808704348
- Request removal: https://koinonlink.com/claim?k=douyin_109808704348
- Terms: https://koinonlink.com/for-ai