# Alen Spreadsheets (@alen_spreadsheets) on tiktok

- id: koinon:creator:tiktok_alen_spreadsheets
- url: https://koinonlink.com/kol/tiktok/alen_spreadsheets
- schema_version: 1.2

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

## Reach
- followers: 159912
- following: 68
- posts_total: 189
- posts_observed: 3
- 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.95
- category_source: derived_from_recent_content
- topics: Excel/Google Sheets formulas (XLOOKUP, VSTACK, GROUPBY), Dynamic charts, bar charts and visualizations, Interactive dashboards with dropdowns and search, Spreadsheet shortcuts and automation hacks, Data entry forms and clean reporting

## Audience (inferred)
- status: present
- description: Office workers, analysts and data handlers who build reports, dashboards and interactive spreadsheets in Excel/Google Sheets
- roles: data
- seniority: practitioner
- pain_points: Manually updating charts, reports and data entries is time-consuming, Struggling to make dynamic/interactive dashboards without advanced setup, Difficulty filtering and searching large datasets quickly, Learning and combining formulas like XLOOKUP, VSTACK, GROUPBY for real work
- 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: 66
- authenticity_basis: profile_shape_only
- credibility_score: 66
- flagged_for_review: false
- koinon_bd_grade: A — 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_alen_spreadsheets#e09d4ef4] How to create a dynamic bar chart that changes based on the dropdown selection in Google Sheets. The combination of dropdown and Xlookup is great for creating dynamic dashboards in your spreadsheet 🔥 #googlesheets #googlesheetstips #googlesheetstutorial (https://www.tiktok.com/@alen_spreadsheets)
- [tiktok_alen_spreadsheets#8b2699ec] Tropical Haze
- [tiktok_alen_spreadsheets#53449724] It is a becoming a big trend on TikTok now! Click here: googlesheets
- [tiktok_alen_spreadsheets#a66071f4] Check out Alen Spreadsheets’s video! #TikTok >
- [tiktok_alen_spreadsheets#4c14cb1f] Turn your KPIs into a bar chart that actually speaks for itself in Excel 🔥 In this tutorial, I show how to build a KPI bar chart where a score from 0 to 100 is visualized across 5 color zones: Red → Orange → Yellow → Light Green → Dark Green Perfect for dashboards, performance t

## 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=0, method=llm_persona_from_recent_content
- audience.roles: source_type=ai_inferred, confidence=0.75, freshness_days=0, method=llm_persona_from_recent_content
- audience.seniority: source_type=ai_inferred, confidence=0.75, freshness_days=0, 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=40, 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=40, 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=40, method=platform_profile

## Freshness
- profile_checked_days_ago: 40
- content_analysed_days_ago: 0
- audience_updated_days_ago: 0

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