# 一凡轻松学办公课堂 (@tj19810315) on douyin

- id: koinon:creator:douyin_tj19810315
- url: https://koinonlink.com/kol/douyin/tj19810315
- schema_version: 1.4

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

## Reach
- followers: 1783300
- following: 50
- posts_total: 265
- posts_observed: 3
- verified: true
- size_tier: kol

## Engagement
- status: peak_post_only
- peak_post_engagement_rate: 0.00065
- best_post_interactions: 1155
- 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函数应用（MIN、COUNTIFS等）, 表格格式设置与美化, 数据快速处理与转换, Office快捷操作技巧, 职场Excel实用场景
- bio: 多年职场办公经验🙈
每天分享Excel等办公软件小技巧💕
每天不定时直播分享办公软件操作哦😍

## Audience (inferred)
- status: present
- description: Office workers, especially administrative staff, clerks, data entry personnel, and general employees who frequently handle Excel spreadsheets
- roles: none
- seniority: practitioner
- pain_points: Don't know how to use Excel formulas or can't remember them, Formatting tables is cumbersome and prone to errors, Low efficiency in data processing and format conversion, Lack systematic learning resources, forced to learn tips and tricks in a scattered way
- posts_analysed: 36
- confidence: 0.75

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

## Quality signals
- authenticity_score: 38
- authenticity_basis: engagement_observed
- credibility_score: 84
- 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_tj19810315#bc220221] 大礼包下载方法 (https://www.douyin.com/user/MS4wLjABAAAAlr46pNGsYH4Fw-1AIWsKhjwfRD6XL7NjwqYRt86AI5o)
- [douyin_tj19810315#374103aa] 自带流量的音乐
- [douyin_tj19810315#3de84559] 领取大礼包
- [douyin_tj19810315#182d2bd7] 解压资料包
- [douyin_tj19810315#5b66064d] 资料使用说明
- [douyin_tj19810315#dfcea182] 观看课程的方法
- [douyin_tj19810315#1601a73a] 跟随老师 秒变职场高手#excel技巧 #office办公技巧 #办公技巧 Min函数获取最小数值 你学废了吗?#轻松学办公课堂
- [douyin_tj19810315#50176626] @一凡轻松学办公课堂创作的原声

## 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=68, method=llm_persona_from_recent_content
- audience.roles: source_type=ai_inferred, confidence=0.75, freshness_days=68, method=llm_persona_from_recent_content
- audience.seniority: source_type=ai_inferred, confidence=0.75, freshness_days=68, method=llm_persona_from_recent_content
- commercial.audience_buyer_fit: source_type=ai_inferred, confidence=0.6, freshness_days=68, 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=68, 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=68, 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: 68
- audience_updated_days_ago: 68

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