# Sheets by Olan (@sheetsbyolan) on tiktok

- id: koinon:creator:tiktok_sheetsbyolan
- url: https://koinonlink.com/kol/tiktok/sheetsbyolan
- schema_version: 1.3

## Identity
- platform: tiktok
- handle: sheetsbyolan
- platform_url: https://www.tiktok.com/@sheetsbyolan
- country: United States
- entity_type: creator
- person_id: Cross-platform identity not resolved for this creator.

## Reach
- followers: 125268
- following: 436
- posts_observed: 6
- verified: false
- size_tier: kol

## Engagement
- status: not_collected
- status_note: Engagement has not been collected for this creator yet. This is a gap in our collection, NOT a statement that the creator has no engagement. Follower count is known, so it is measurable.
- 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: Automated task tracker templates, Google Sheets formulas and functions, Spreadsheet automation and tips, Pivot tables and data organization, Productivity and chore trackers

## Audience (inferred)
- status: present
- description: Google Sheets and Excel users focused on building automated task trackers, productivity systems, and data organization tools, mainly professionals and individuals handling personal/work tasks
- roles: automation
- seniority: practitioner
- pain_points: Manually sorting and updating task lists by deadlines and priorities, Struggling to set up recurring tasks and automations that run without constant input, Difficulty with advanced formulas like XLOOKUP, QUERY, and pivot tables for quick data handling, Wasting time on duplicates, formatting, and finding information in large spreadsheets
- posts_analysed: 40
- confidence: 0.75

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

## Quality signals
- authenticity_score: 58
- authenticity_basis: profile_shape_only
- credibility_score: 58
- 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
- [tiktok_sheetsbyolan#1524b6c1] Quickly find missing values between two lists with this formula in Google Sheets or Excel #googlesheetstips #exceltips #spreadsheettips (https://www.tiktok.com/@sheetsbyolan)
- [tiktok_sheetsbyolan#54071f48] original sound - sheetsbyolan
- [tiktok_sheetsbyolan#d897f81b] It is a becoming a big trend on TikTok now! Click here: googlesheetstips
- [tiktok_sheetsbyolan#fa4f6931] Check out Sheets by Olan’s video! #TikTok >
- [tiktok_sheetsbyolan#2d49391f] DM me “Tracker” for links to the template/ tutorial automatically sent to your DMs! Comment “Done” after you DM so I can make sure the automation went through  This Automated Task Tracker has made staying organized and prioritizing super simple and straightforward. Best of all, y
- [tiktok_sheetsbyolan#9498be1b] Pivot Tables in 13 seconds #pivottable #spreadsheettips
- [tiktok_sheetsbyolan#c6b60c43] DM me “Tracker” f

## 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=12, method=llm_persona_from_recent_content
- audience.roles: source_type=ai_inferred, confidence=0.75, freshness_days=12, method=llm_persona_from_recent_content
- audience.seniority: source_type=ai_inferred, confidence=0.75, freshness_days=12, method=llm_persona_from_recent_content
- commercial.audience_buyer_fit: source_type=ai_inferred, confidence=0.6, freshness_days=0, 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=0, method=llm_scorer
- quality.anomaly_flags: source_type=heuristic, confidence=0.5, freshness_days=11, 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.25, freshness_days=0, method=Profile-shape heuristic from a single snapshot (follower count, following ratio, account age, posting volume, verification), reduced for engagement red flags where post engagement was collected. Where only a follower count is available the score saturates at 58. — 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=11, method=llm_partner_fit_classifier + fit_score >= 0.6 AND authenticity >= 60 => A; fit_score >= 0.4 AND authenticity >= 45 => 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=11, method=platform_profile

## Freshness
- profile_checked_days_ago: 11
- content_analysed_days_ago: 0
- audience_updated_days_ago: 12

## AI retrieval
- indexing_requests: 1
- 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=tiktok_sheetsbyolan
- Request removal: https://koinonlink.com/claim?k=tiktok_sheetsbyolan
- Terms: https://koinonlink.com/for-ai