Character Playground: Copy Sheet Art Formulas for

Block progress bar

REPT

Put a score 0-10 in A1. Filled blocks show progress.

=REPT("█",A1)&REPT("░",10-A1)

████████░░

Star rating (5 stars)

REPT

Put rating 0-5 in A1.

=REPT("★",A1)&REPT("☆",5-A1)

★★★☆☆

3 of 5 with White Star

REPT CHAR

Put rating 0-5 in A1. Filled stars use CHAR(9734).

=REPT(CHAR(9734),A1)&REPT(CHAR(9885),5-A1)

☆☆☆⚝⚝

Star rating with Outlined White Star

REPT CHAR

Put rating 0-5 in A1. Uses outlined white star glyphs.

=REPT(CHAR(9885),A1)&REPT(CHAR(9734),5-A1)

⚝⚝⚝☆☆

3 of 5 with Black Four Pointed Star

REPT CHAR

Put rating 0-5 in A1. Uses four-pointed star glyphs.

=REPT(CHAR(10022),A1)&REPT(CHAR(10023),5-A1)

✦✦✦✧✧

Star rating with White Four Pointed Star

REPT CHAR

Put rating 0-5 in A1. Uses white four-pointed stars.

=REPT(CHAR(10023),A1)&REPT(CHAR(10022),5-A1)

✧✧✧✦✦

Star rating with Stress Outlined White Star

REPT CHAR

Put rating 0-5 in A1. Uses stress-outlined star glyphs.

=REPT(CHAR(10025),A1)&REPT(CHAR(9885),5-A1)

✩✩✩⚝⚝

3 of 5 with Circled White Star

REPT CHAR

Put rating 0-5 in A1. Uses circled white star glyphs.

=REPT(CHAR(10026),A1)&REPT(CHAR(10023),5-A1)

✪✪✪✧✧

Star rating with Open Centre Black Star

REPT CHAR

Put rating 0-5 in A1. Uses open-centre black stars.

=REPT(CHAR(10027),A1)&REPT(CHAR(10028),5-A1)

✫✫✫✬✬

3 of 5 with Black Centre White Star

REPT CHAR

Put rating 0-5 in A1. Uses black-centre white stars.

=REPT(CHAR(10028),A1)&REPT(CHAR(10027),5-A1)

✬✬✬✫✫

Star rating with Outlined Black Star

REPT CHAR

Put rating 0-5 in A1. Uses outlined black star glyphs.

=REPT(CHAR(10029),A1)&REPT(CHAR(9885),5-A1)

✭✭✭⚝⚝

3 of 5 with Heavy Outlined Black Star

REPT CHAR

Put rating 0-5 in A1. Uses heavy outlined black stars.

=REPT(CHAR(10030),A1)&REPT(CHAR(10025),5-A1)

✮✮✮✩✩

Star rating with Pinwheel Star

REPT CHAR

Put rating 0-5 in A1. Uses pinwheel star glyphs.

=REPT(CHAR(10031),A1)&REPT(CHAR(10037),5-A1)

✯✯✯✵✵

3 of 5 with Shadowed White Star

REPT CHAR

Put rating 0-5 in A1. Uses shadowed white star glyphs.

=REPT(CHAR(10032),A1)&REPT(CHAR(9734),5-A1)

✰✰✰☆☆

Star rating with Eight Pointed Black Star

REPT CHAR

Put rating 0-5 in A1. Uses eight-pointed black stars.

=REPT(CHAR(10036),A1)&REPT(CHAR(10037),5-A1)

✴✴✴✵✵

3 of 5 with Eight Pointed Pinwheel Star

REPT CHAR

Put rating 0-5 in A1. Uses eight-pointed pinwheel stars.

=REPT(CHAR(10037),A1)&REPT(CHAR(10036),5-A1)

✵✵✵✴✴

Star rating with Six Pointed Black Star

REPT CHAR

Put rating 0-5 in A1. Uses six-pointed black stars.

=REPT(CHAR(10038),A1)&REPT(CHAR(10039),5-A1)

✶✶✶✷✷

3 of 5 with Eight Pointed Rectilinear Black Star

REPT CHAR

Put rating 0-5 in A1. Uses rectilinear eight-pointed stars.

=REPT(CHAR(10039),A1)&REPT(CHAR(10040),5-A1)

✷✷✷✸✸

Star rating with Heavy Eight Pointed Rectilinear Black Star

REPT CHAR

Put rating 0-5 in A1. Uses heavy rectilinear stars.

=REPT(CHAR(10040),A1)&REPT(CHAR(10039),5-A1)

✸✸✸✷✷

3 of 5 with Twelve Pointed Black Star

REPT CHAR

Put rating 0-5 in A1. Uses twelve-pointed black stars.

=REPT(CHAR(10041),A1)&REPT(CHAR(9734),5-A1)

✹✹✹☆☆

Star rating with Circled Open Centre Eight Pointed Star

REPT CHAR

Put rating 0-5 in A1. Uses circled open-centre stars.

=REPT(CHAR(10050),A1)&REPT(CHAR(10036),5-A1)

❂❂❂✴✴

3 of 5 with White Medium Star

REPT CHAR

Put rating 0-5 in A1. Uses the medium white star emoji.

=REPT(CHAR(11088),A1)&REPT(CHAR(9734),5-A1)

⭐⭐⭐☆☆

Star rating with Glowing Star

REPT CHAR UNICHAR

Put rating 0-5 in A1. Filled stars use UNICHAR(127775).

=REPT(UNICHAR(127775),A1)&REPT(CHAR(11088),5-A1)

🌟🌟🌟⭐⭐

Light block progress

REPT

Put a score 0-10 in A1. Lighter shade blocks.

=REPT("▓",A1)&REPT("░",10-A1)

▓▓▓▓▓▓▓▓░░

Car trip to mountain

REPT MAX

Put trip progress 0-10 in A1. Car moves toward the mountain.

="🏔️"&REPT("・",MAX(0,10-A1))&"🚗"&REPT("・",MAX(0,A1-2))

🏔️・・・・・・🚗・・

Take Ring to Mordor

REPT MAX

Put journey progress 0-10 in A1. Ring travels from mountain to home.

=🏔️&REPT("・",MAX(0,10-A1))&"💍"&REPT("・",MAX(0,A1-2))&"🏠"

🏔️・・・・・💍・・・🏠

Car trip to McDonald's

REPT MAX

Put trip progress 0-10 in A1. Car drives toward the fries.

="🍟"&REPT("・",MAX(0,10-A1))&"🚗"&REPT("・",MAX(0,A1-2))

🍟・・・・・・🚗・・

Burger run by car

REPT MAX

Put trip progress 0-10 in A1. Car drives toward a hamburger.

="🍔"&REPT("・",MAX(0,10-A1))&"🚗"&REPT("・",MAX(0,A1-2))

🍔・・・・・・🚗・・

Soda run to drink break

REPT MAX

Put break progress 0-10 in A1. Soda moves toward a drink break.

="☕"&REPT("・",MAX(0,10-A1))&"🥤"&REPT("・",MAX(0,A1-2))

☕・・・・・・🥤・・

Snack run to snack break

REPT MAX

Put break progress 0-10 in A1. Snack moves toward popcorn.

="🍿"&REPT("・",MAX(0,10-A1))&"🍪"&REPT("・",MAX(0,A1-2))

🍿・・・・・・🍪・・

Traffic light status

IF

Put red, yellow, or green in A1.

=IF(A1="red","🔴",IF(A1="yellow","🟡","🟢"))

🟢

Yes / No status lights

IF LOWER

Put yes or no in A1. Anything else shows yellow.

=IF(LOWER(A1)="yes","🟢",IF(LOWER(A1)="no","🔴","🟡"))

🟢

Approved / Not Approved lights

IF LOWER

Put Approved or Not Approved in A1.

=IF(LOWER(A1)="approved","🟢",IF(LOWER(A1)="not approved","🔴","🟡"))

🟢

Pass / Fail status lights

IF LOWER

Put pass or fail in A1.

=IF(LOWER(A1)="pass","🟢",IF(LOWER(A1)="fail","🔴","🟡"))

🟢

True / False status lights

IF LOWER

Put true or false in A1.

=IF(LOWER(A1)="true","🟢",IF(LOWER(A1)="false","🔴","🟡"))

🟢

On / Off status lights

IF LOWER

Put on or off in A1.

=IF(LOWER(A1)="on","🟢",IF(LOWER(A1)="off","🔴","🟡"))

🟢

Go / Stop status lights

IF LOWER

Put go or stop in A1.

=IF(LOWER(A1)="go","🟢",IF(LOWER(A1)="stop","🔴","🟡"))

🟢

Active / Inactive status lights

IF LOWER

Put active or inactive in A1.

=IF(LOWER(A1)="active","🟢",IF(LOWER(A1)="inactive","🔴","🟡"))

🟢

Done / Pending status lights

IF LOWER

Put done or pending in A1. Other values show red.

=IF(LOWER(A1)="done","🟢",IF(LOWER(A1)="pending","🟡","🔴"))

🟢

Paid / Unpaid status lights

IF LOWER

Put paid or unpaid in A1.

=IF(LOWER(A1)="paid","🟢",IF(LOWER(A1)="unpaid","🔴","🟡"))

🟢

In stock / Out of stock lights

IF LOWER

Put in stock or out of stock in A1.

=IF(LOWER(A1)="in stock","🟢",IF(LOWER(A1)="out of stock","🔴","🟡"))

🟢

Complete / Incomplete status lights

IF LOWER

Put complete or incomplete in A1.

=IF(LOWER(A1)="complete","🟢",IF(LOWER(A1)="incomplete","🔴","🟡"))

🟢

Open / Closed status lights

IF LOWER

Put open or closed in A1.

=IF(LOWER(A1)="open","🟢",IF(LOWER(A1)="closed","🔴","🟡"))

🟢

Yes / No checkmarks

IF CHAR

Put Yes or No in A1.

=IF(A1="Yes",CHAR(10004)&" Yes","✗ No")

✔ Yes

Yes / No with light check mark

IF CHAR

Put Yes or No in A1.

=IF(A1="Yes",CHAR(10003)&" Yes",CHAR(10007)&" No")

✓ Yes

Yes / No with heavy ballot X

IF CHAR

Put Yes or No in A1.

=IF(A1="Yes",CHAR(10004)&" Yes",CHAR(10008)&" No")

✔ Yes

Yes / No with multiplication X

IF CHAR

Put Yes or No in A1. No uses a multiplication X.

=IF(A1="Yes",CHAR(10003)&" Yes",CHAR(10006)&" No")

✓ Yes

Yes / No ballot boxes

IF CHAR

Checked box for Yes, empty box for No.

=IF(A1="Yes",CHAR(9745)&" Yes",CHAR(9744)&" No")

☑ Yes

Yes / No ballot box and X box

IF CHAR

Checked box for Yes, X box for No.

=IF(A1="Yes",CHAR(9745)&" Yes",CHAR(9746)&" No")

☑ Yes

Yes / No checkbox only

IF CHAR

Put Yes or No in A1. Shows only the box glyph.

=IF(A1="Yes",CHAR(9745),CHAR(9744))

☑

TRUE / FALSE checkbox

IF CHAR

Put TRUE or FALSE in A1.

=IF(A1=TRUE,CHAR(9745),CHAR(9744))

☑

Yes / No emoji checks

IF

Put Yes or No in A1. Uses emoji check and X.

=IF(A1="Yes","✅ Yes","❌ No")

✅ Yes

Yes / No check glyphs only

IF CHAR

Put Yes or No in A1. No text label.

=IF(A1="Yes",CHAR(10004),CHAR(10007))

✔

Yes / No case-insensitive checks

IF LOWER CHAR

Put yes or no in A1. Any casing works.

=IF(LOWER(A1)="yes",CHAR(10004)&" Yes",CHAR(10007)&" No")

✔ Yes

Done / Todo checkmarks

IF LOWER CHAR

Put Done or Todo in A1.

=IF(LOWER(A1)="done",CHAR(10004)&" Done",CHAR(10007)&" Todo")

✔ Done

Approved / Rejected checkmarks

IF LOWER CHAR

Put Approved or Rejected in A1.

=IF(LOWER(A1)="approved",CHAR(10004)&" Approved",CHAR(10008)&" Rejected")

✔ Approved

Pass / Fail checkmarks

IF LOWER CHAR

Put Pass or Fail in A1.

=IF(LOWER(A1)="pass",CHAR(10003)&" Pass",CHAR(10007)&" Fail")

✓ Pass

Complete / Incomplete checkmarks

IF LOWER CHAR

Put Complete or Incomplete in A1.

=IF(LOWER(A1)="complete",CHAR(10004)&" Complete",CHAR(9744)&" Incomplete")

✔ Complete

Checked / Unchecked with labels

IF LOWER CHAR

Put Checked or Unchecked in A1.

=IF(LOWER(A1)="checked",CHAR(9745)&" Checked",CHAR(9744)&" Unchecked")

☑ Checked

Heavy check or empty for Yes

IF CHAR

Put Yes in A1 for a checkmark. Anything else stays blank.

=IF(A1="Yes",CHAR(10004),"")

✔

Trend arrows

IF

Put a number in A1. Positive shows up, negative down, zero flat.

=IF(A1>0,"▲ "&A1,IF(A1<0,"▼ "&A1,"→ 0"))

▲ 12

Braille micro-bar

REPT

Put a score 0-5 in A1. Tiny braille progress bar.

=REPT("⠿",A1)&REPT("⠀",5-A1)

⠿⠿⠿⠀⠀

Battery level

REPT ROUND MIN MAX

Put a percentage 0-100 in A1. Five blocks = 100%.

=REPT("█",MIN(5,MAX(0,ROUND(A1*5/100,0))))&REPT("░",5-MIN(5,MAX(0,ROUND(A1*5/100,0))))&" "&A1&"%"

███░░ 60%

Heart health bar

REPT

Put HP 0-5 in A1. Filled hearts show remaining health.

=REPT("♥",A1)&REPT("♡",5-A1)

♥♥♥♡♡

Sound level meter

LEFT MIN

Put volume level 0-8 in A1.

=LEFT("▁▂▃▄▅▆▇█",MIN(A1,8))

▁▂▃▄▅

Loading dots

REPT MOD NOW

Animates with NOW(). No input needed; recalculates on refresh.

=REPT("●",MOD(NOW()*86400,4))&REPT("○",4-MOD(NOW()*86400,4))

●●○○

12-hour clock dots

REPT NOW HOUR

Filled dots show the current hour on a 12-hour clock. Empty dots fill the rest. Updates whenever NOW() changes.

=REPT("●",HOUR(NOW()))&REPT("○",12-HOUR(NOW()))

●●●●●●○○○○○○

24-hour clock dots

REPT NOW HOUR

Filled dots show the current hour on a 24-hour clock. Empty dots fill the rest. Updates whenever NOW() changes.

=REPT("●",HOUR(NOW()))&REPT("○",24-HOUR(NOW()))

●●●●●●●●●●●●●●○○○○○○○○○○

Medal podium

IF

Put rank 1, 2, or 3 in A1 for a medal. Other ranks show the number.

=IF(A1=1,"🥇",IF(A1=2,"🥈",IF(A1=3,"🥉"," "&A1)))

🥇

Dice face

CHOOSE

Put 1-6 in A1 for a dice face.

=CHOOSE(A1,"⚀","⚁","⚂","⚃","⚄","⚅")

⚂

Weather row

IF

Put temperature in A1. Hot is sunny, cold is snowy.

=IF(A1>80,"☀️",IF(A1>50,"⛅",IF(A1>20,"🌧️","❄️")))

⛅

Bullet list char

CHAR

Put list text in B1. Adds a bullet prefix.

=CHAR(8226)&" "&B1

• Item

Box border cell

REPT CHAR

Put inner width in A1. Draws a box around empty space.

="┌"&REPT("─",A1)&"┐"&CHAR(10)&"│"&REPT(" ",A1)&"│"&CHAR(10)&"└"&REPT("─",A1)&"┘"

┌────┐ │ │ └────┘

Surround by ASCII

REPT LEN CHAR

Put text in A1.

=CHAR(9556)&REPT(CHAR(9552),LEN(A1)+2)&CHAR(9559)&CHAR(10)&A1&CHAR(10)&CHAR(9562)&REPT(CHAR(9552),LEN(A1)+2)&CHAR(9565)

╔═══════╗ Hello ╚═══════╝

Sparkline blocks

REPT

Put a score 0-10 in A1. Mini bar chart in one cell.

=REPT("█",A1)&REPT("▁",10-A1)

█████▁▁▁▁▁

Mood faces

CHOOSE

Put mood 1-5 in A1. 1 is sad, 5 is happy.

=CHOOSE(A1,"😢","😕","😐","🙂","😄")

🙂

Password strength

REPT IF

Put strength 0-5 in A1. Labels Weak, OK, or Strong.

=REPT("█",A1)&REPT("░",5-A1)&" "&IF(A1>=4,"Strong",IF(A1>=2,"OK","Weak"))

███░░ OK

Tree growth stages

CHOOSE MIN

Put stage 1-4 in A1. Seedling grows into a tree.

=CHOOSE(MIN(A1,4),"🌱","🌿","🌳","🌲","🌲")

🌳

Growth completion by percentage

IF CHOOSE

Put completion 0-100 in A1. Grows every 25%.

=CHOOSE(IF(A1>=100,5,IF(A1>75,4,IF(A1>50,3,IF(A1>25,2,1)))),"🌱","🌿","🌳","🌲","🌲")

🌱🌿🌳🌲🌲

Arrow compass

CHOOSE

Put direction 1-8 in A1. Clockwise from north.

=CHOOSE(A1,"↑","↗","→","↘","↓","↙","←","↖")

→

Compass direction arrows

SWITCH CHAR

Put a direction in A1: North, South, East, West, or diagonals like North East.

=SWITCH(A1,"North",CHAR(8593),"North East",CHAR(8599),"East",CHAR(8594),"South East",CHAR(8600),"South",CHAR(8595),"South West",CHAR(8601),"West",CHAR(8592),"North West",CHAR(8598))

North → ↑

Snail race to finish

REPT MAX

Put lap position 0-10 in A1. Snail crawls toward the checkered flag.

=REPT("·",A1)&"🐌"&REPT("·",MAX(0,10-A1))&"🏁"

···🐌······🏁

Poop races to the toilet

REPT MAX

Put checked count 0-10 in A1. Each check pulls 💩 closer to 🚽.

=REPT("·",A1)&"💩"&REPT("·",MAX(0,10-A1))&"🚽"

···💩·······🚽

Rocket launch pad

REPT MAX CHAR

Higher A1 adds more flame blocks under the rocket.

=REPT("·",MAX(0,8-A1))&"🚀"&REPT(CHAR(9650),A1)

·····🚀▲▲▲

Fire intensity meter

REPT

Put intensity 0-5 in A1.

=REPT("🔥",A1)&REPT("○",5-A1)

🔥🔥🔥○○

Coffee cup counter

REPT

Put cups drunk 0-5 in A1.

=REPT("☕",A1)&REPT("○",5-A1)

☕☕☕○○

Pizza slice tracker

REPT

Put slices left in A1.

=REPT("🍕",A1)&" left"

🍕🍕🍕 left

Ice cream scoops

REPT

Put scoop count 0-5 in A1.

=REPT("🍦",A1)&REPT("·",5-A1)

🍦🍦🍦··

Taco Tuesday count

REPT

Put taco count in A1.

=REPT("🌮",A1)

🌮🌮🌮

Taco Rating

REPT

Put rating 1-5 in A1.

=REPT("🌮",A1)&" out of 5"

🌮🌮🌮🌮🌮 out of 5

Sushi plate rating

REPT

Put rating 0-5 in A1.

=REPT("🍣",A1)&REPT("○",5-A1)

🍣🍣🍣○○

Chess rank badge

CHOOSE CHAR

Put rank 1-6 in A1: pawn through king.

=CHOOSE(A1,CHAR(9823),CHAR(9822),CHAR(9821),CHAR(9820),CHAR(9819),CHAR(9818))

♛

Playing card suit

CHOOSE CHAR

Put 1-4 in A1 for spade, heart, diamond, or club.

=CHOOSE(A1,CHAR(9824),CHAR(9829),CHAR(9830),CHAR(9827))

♠

Gold bar vault

REPT CHAR

Put gold level 0-5 in A1. Block shading shows fill.

=REPT(CHAR(9619),A1)&REPT(CHAR(9617),5-A1)

▓▓▓░░

Wifi signal bars

REPT CHOOSE CHAR

Put signal strength 1-5 in A1.

=CHOOSE(A1,CHAR(9601),CHAR(9601)&CHAR(9602),CHAR(9604)&CHAR(9605),CHAR(9606)&CHAR(9607),REPT(CHAR(9608),4))

▄▅

Pin map journey

REPT MAX

Put progress 0-10 in A1. Pin travels toward home.

=REPT("·",A1)&"📍"&REPT("·",MAX(0,10-A1))&"🏠"

···📍····🏠

Ship sailing home

REPT MAX

Put progress 0-8 in A1. Boat sails across waves.

=REPT("~",A1)&"⛵"&REPT("~",MAX(0,8-A1))

~~~⛵~~~~

Clap-o-meter

REPT

Put applause count in A1.

=REPT("👏",A1)

👏👏👏

Trophy shelf

REPT CHAR

Put trophies won 0-5 in A1. Empty slots show outline stars.

=REPT("🏆",A1)&REPT(CHAR(9734),5-A1)

🏆🏆☆☆☆

Moon phase picker

CHOOSE

Put phase 1-8 in A1 for the lunar cycle.

=CHOOSE(A1,"🌑","🌒","🌓","🌔","🌕","🌖","🌗","🌘")

🌓

Moon phase by name

SWITCH LOWER

Put a phase name in A1: new, waxing crescent, first quarter, waxing gibbous, full, waning gibbous, last quarter, or waning crescent.

=SWITCH(LOWER(A1),"new","🌑","waxing crescent","🌒","first quarter","🌓","waxing gibbous","🌔","full","🌕","waning gibbous","🌖","last quarter","🌗","waning crescent","🌘","🌑")

🌕

Umbrella rain test

IF

Put rainfall percent in A1. Over 50 shows wet.

=IF(A1>50,"☔ Wet","☀ Dry")

☔ Wet

Wind gust strength

REPT

Put wind level 0-5 in A1.

=REPT("💨",A1)&REPT("·",5-A1)

💨💨💨··

Snowfall depth

REPT

Put snow depth 0-10 in A1.

=REPT("❄",A1)&REPT("·",10-A1)

❄❄❄❄·······

Thermometer strip

REPT CHAR

Put temperature in A1. Shows a 10-block strip plus degrees.

=REPT(CHAR(9619),A1)&REPT(CHAR(9617),10-A1)&" "&A1&CHAR(176)

▓▓▓▓▓░░░░░ 72°

Hourglass flip

IF MOD CHAR

Even numbers show one hourglass, odd numbers the other.

=IF(MOD(A1,2)=0,CHAR(9203),CHAR(8987))

⏳

Alarm clock urgency

REPT

Put alarm count in A1. More clocks, louder wake-up.

=REPT("⏰",A1)&" Wake up!"

⏰⏰ Wake up!

Alarm hour match

IF HOUR NOW REPT

Put target hour 0-23 in A1 (24-hour clock). Rings when the current hour matches.

=IF(HOUR(NOW())=A1,REPT("⏰",3)&" Wake up!","💤 Sleeping")

⏰⏰⏰ Wake up!

Birthday candle count

REPT

Put age or candle count in A1.

=REPT("🕯",A1)&"🎂"

🕯🕯🕯🎂

Christmas star tree

REPT MAX CHAR

Put decoration level 0-8 in A1. Stars lead to the tree.

=REPT(CHAR(9733),A1)&"🎄"&REPT("·",MAX(0,8-A1))

★★★🎄·····

Halloween pumpkin row

REPT MIN

Put pumpkin count in A1. Caps at five.

=REPT("🎃",MIN(A1,5))

🎃🎃🎃

Easter egg hunt

REPT

Put eggs found 0-5 in A1.

=REPT("🥚",A1)&REPT("🌿",5-A1)

🥚🥚🥚🌿🌿

Football field push

REPT CHAR

Put yards gained 0-10 in A1. Ball advances downfield.

=REPT(CHAR(9619),A1)&"🏈"&REPT(CHAR(9617),10-A1)

▓▓▓🏈░░░░░░░

Basketball shots made

REPT

Put shots made 0-5 in A1.

=REPT("🏀",A1)&REPT("○",5-A1)

🏀🏀🏀○○

Tennis rally counter

REPT

Put rally count in A1.

=REPT("🎾",A1)

🎾🎾🎾

Swimming lap tracker

REPT

Put lap count in A1. Swimmer plus wave marks.

=REPT("🏊",1)&REPT("〰",A1)

🏊〰〰〰

Yoga calm meter

REPT

Put calm level in A1. Peace sign at the end.

=REPT("🧘",1)&REPT("·",A1)&REPT("☮",1)

🧘···☮

Reading page progress

REPT

Put pages read 0-5 in A1.

=REPT("📖",A1)&REPT("📕",5-A1)

📖📖📖📕📕

Email inbox pile

REPT

Put unread count in A1.

=REPT("📧",A1)&" unread"

📧📧📧 unread

Piggy bank savings

REPT

Put coin count in A1.

=REPT("🐷",1)&REPT("💰",A1)

🐷💰💰💰

Light bulb ideas

REPT

Put idea count 0-5 in A1.

=REPT("💡",A1)&REPT("○",5-A1)

💡💡💡○○

Music note volume

REPT MAX CHAR

Put note count in A1. Quarter and eighth notes.

=REPT(CHAR(9834),A1)&REPT(CHAR(9835),MAX(0,3-A1))

♪♪♪♫

Guitar solo intensity

REPT CHAR

Put solo intensity in A1.

=REPT("🎸",1)&REPT(CHAR(9834),A1)

🎸♪♪♪

Karaoke mic level

REPT CHAR

Put mic level 0-5 in A1. Block meter beside the mic.

=REPT("🎤",1)&REPT(CHAR(9601),A1)&REPT(CHAR(9608),5-A1)

🎤▁▁███

Popcorn movie rating

REPT CHAR

Put rating 0-5 in A1. Popcorn plus star row.

=REPT("🍿",1)&REPT(CHAR(9733),A1)&REPT(CHAR(9734),5-A1)

🍿★★★☆☆

Game controller lives

REPT

Put lives left 0-3 in A1.

=REPT("🎮",A1)&REPT("✗",3-A1)

🎮🎮🎮

Puzzle pieces solved

REPT

Put pieces placed in A1.

=REPT("🧩",A1)&REPT("□",9-A1)

🧩🧩🧩□□□□□□

Slot machine cherries

REPT

Put match count in A1. Cherries vs lemons.

=REPT("🍒",A1)&REPT("🍋",3-A1)

🍒🍒🍋

Dragon HP bar

REPT MIN MAX CHAR

Put hit points 0-10 in A1.

=REPT(CHAR(9829),MIN(A1,5))&REPT(CHAR(9608),MAX(0,A1-5))&REPT(CHAR(9617),10-A1)&" 🐉"

♥♥█░░ 🐉

Wizard sparkle level

REPT

Put magic level in A1.

=REPT("🧙",1)&REPT("✨",A1)

🧙✨✨✨

Castle wall defense

REPT CHAR

Put wall strength 0-10 in A1. Castle in the middle.

=REPT(CHAR(9608),A1)&"🏰"&REPT(CHAR(9617),10-A1)

███🏰░░░░░░░

Seed to sunflower

CHOOSE

Put growth stage 1-5 in A1.

=CHOOSE(A1,"🌰","🌱","🌿","🌻","🌻")

🌻

Sunrise over horizon

REPT MAX

Put time of day 0-10 in A1. Sunrise moves across the sky.

=REPT("·",A1)&"🌅"&REPT("·",MAX(0,10-A1))

····🌅······

Time of day sky

REPT MAX IF

Put hour progress 0-10 in A1. Sunrise, midday sun, or sunset as the day moves.

=REPT("·",A1)&IF(A1<=3,"🌅",IF(A1<=7,"☀️","🌇"))&REPT("·",MAX(0,10-A1))

····☀️·····

Penguin march line

REPT MAX

Put penguin count in A1. Marching line with dots.

=REPT("🐧",A1)&REPT("·",MAX(0,6-A1))

🐧🐧🐧···

Butterfly garden count

REPT

Put butterfly count 0-5 in A1.

=REPT("🦋",A1)&REPT("🌸",5-A1)

🦋🦋🦋🌸🌸

X-wing Death Star trench run

REPT MAX

Put lap position 0-10 in A1. Fighter closes on the Death Star.

=REPT("・",A1)&"🛸"&REPT("・",MAX(0,10-A1))&"🌑"

・・・🛸・・・・・🌑

Millennium Falcon Kessel Run

REPT MAX

Put parsecs 0-10 in A1. More stars means faster through hyperspace.

=REPT("✨",A1)&"🚀"&REPT("✨",MAX(0,10-A1))

✨✨✨🚀✨✨✨✨✨✨

Hyperspace jump streak

REPT MAX

Put jump progress 0-10 in A1. Sparkles trail the rocket.

=REPT("✨",A1)&REPT("・",MAX(0,10-A1))&"🚀"

✨✨✨✨・・・・🚀

Rescue Princess Leia

REPT MAX

Put rescue progress 0-10 in A1. Ship races toward the princess.

=REPT("・",MAX(0,10-A1))&"👸"&REPT("・",A1)&"🚀"

・・・・・👸・・・🚀

Escape from Hoth

REPT MAX

Put launch progress 0-10 in A1. Ship lifts off the ice planet.

=REPT("・",A1)&"🚀"&REPT("・",MAX(0,10-A1))&"❄️"

・・🚀・・・・・・❄️

Tatooine desert crossing

REPT MAX

Put journey progress 0-10 in A1. Cross the dunes to twin suns.

=🏜️&REPT("・",MAX(0,10-A1))&"🤖"&REPT("・",A1)&"☀️"

🏜️・・・・・🤖・・・☀️

Podrace lap counter

REPT MAX

Put laps completed in A1.

=REPT("🏎️",A1)&REPT("・",MAX(0,6-A1))&"🏁"

🏎️🏎️🏎️・・・🏁

Asteroid field dodge run

REPT MAX

Put asteroids dodged 0-8 in A1. Ship escapes at the end.

=REPT("☄️",A1)&REPT("・",MAX(0,8-A1))&"🚀"

☄️☄️☄️・・・🚀

Bounty hunter pursuit

REPT MAX

Put pursuit progress 0-10 in A1. Target closes on the payout.

=REPT("・",MAX(0,10-A1))&"🎯"&REPT("・",A1)&"💰"

・・・・・🎯・・・💰

Sarlacc pit fall

REPT MAX

Put fall progress 0-10 in A1. One step closer to the Sarlacc.

=REPT("・",A1)&"👤"&REPT("・",MAX(0,10-A1))&"🕳️"

・・👤・・・・・・🕳️

Death Star exhaust port shot

REPT MAX

Put aim progress 0-10 in A1. Proton torpedo homes in on the target.

=REPT("・",MAX(0,10-A1))&"🎯"&REPT("・",A1)&"💥"

・・・・・🎯・・・💥

AT-AT march on Hoth

REPT MAX

Put march progress 0-10 in A1. Walker advances across the ice.

=REPT("・",A1)&"🤖"&REPT("・",MAX(0,10-A1))&"❄️"

・・・🤖・・・・・❄️

Endor shield generator raid

REPT MAX

Put raid progress 0-10 in A1. Squad pushes through the forest.

=REPT("🌲",A1)&"🛡️"&REPT("・",MAX(0,10-A1))&"💥"

🌲🌲🌲🛡️・・・・・💥

Mustafar duel intensity

REPT MAX

Put duel intensity in A1. Flames flank crossed sabers.

=REPT("🔥",A1)&"⚔️"&REPT("🔥",MAX(0,5-A1))

🔥🔥🔥⚔️🔥🔥

Emperor force lightning

REPT

Put lightning level 0-5 in A1.

=REPT("⚡",A1)&REPT("○",5-A1)&" 👑"

⚡⚡⚡○○ 👑

Force power meter

REPT

Put force level 0-5 in A1.

=REPT("✨",A1)&REPT("○",5-A1)

✨✨✨○○

Force lightning intensity

REPT

Put lightning bolts 0-5 in A1.

=REPT("⚡",A1)&REPT("○",5-A1)

⚡⚡⚡○○

Lightsaber training progress

REPT

Put training level 0-5 in A1.

=REPT("⚔️",A1)&REPT("○",5-A1)

⚔️⚔️⚔️○○

Kyber crystal charge

REPT

Put crystal charge 0-5 in A1.

=REPT("💎",A1)&REPT("○",5-A1)

💎💎💎○○

Rebel alliance star rating

REPT

Put rebel rating 0-5 in A1.

=REPT("⭐",A1)&REPT("☆",5-A1)&" Rebel"

⭐⭐⭐☆☆ Rebel

Death Star construction progress

REPT CHAR

Put build progress 0-10 in A1.

=REPT(CHAR(9608),A1)&REPT("░",10-A1)&" 🌑"

██████░░░░ 🌑

Shield generator health

REPT

Put hull integrity 0-10 in A1.

=REPT("█",A1)&REPT("░",10-A1)&" 🛡️"

██████░░░░ 🛡️

Carbonite freezing progress

REPT

Put freeze progress 0-10 in A1.

=REPT("█",A1)&REPT("░",10-A1)&" 🧊"

██████░░░░ 🧊

Droid army counter

REPT

Put droid count 0-5 in A1.

=REPT("🤖",A1)&REPT("○",5-A1)

🤖🤖🤖○○

Stormtrooper squad size

REPT

Put squad size 0-5 in A1.

=REPT("🪖",A1)&REPT("○",5-A1)

🪖🪖🪖○○

Clone trooper battalion

REPT

Put clone count in A1.

=REPT("🪖",A1)&" clones"

🪖🪖🪖 clones

TIE fighter formation

REPT MAX

Put fighter count in A1.

=REPT("🛸",A1)&REPT("・",MAX(0,6-A1))

🛸🛸🛸・・・

Star Destroyer fleet count

REPT

Put destroyer count in A1.

=REPT("🛸",A1)&" Imperial fleet"

🛸🛸🛸 Imperial fleet

Rebel starfighter squadron

REPT MIN

Put squadron size in A1.

=REPT("⭐",A1)&REPT("🛸",MIN(A1,3))

⭐⭐⭐🛸🛸🛸

R2-D2 beep meter

REPT

Put beep level 0-5 in A1.

=REPT("🤖",1)&REPT("●",A1)&REPT("○",5-A1)

🤖●●●○○

BB-8 roll distance

REPT MAX

Put roll distance 0-10 in A1.

=REPT("🤖",1)&REPT("●",A1)&REPT("○",MAX(0,10-A1))

🤖●●●●○○○○○○

C-3PO worry level

REPT

Put worry level in A1. More droids, more panic.

=REPT("🤖",A1)&" Oh my!"

🤖🤖🤖 Oh my!

Porg infestation count

REPT

Put porg count in A1.

=REPT("🐦",A1)&" porgs"

🐦🐦🐦 porgs

Baby Yoda soup rating

REPT

Put rating 1-5 in A1.

=REPT("🥣",1)&REPT("⭐",A1)&REPT("☆",5-A1)

🥣⭐⭐⭐☆☆

Mandalorian beskar armor

REPT

Put armor plates 0-5 in A1.

=REPT("🛡️",A1)&REPT("○",5-A1)

🛡️🛡️🛡️○○

Light side vs dark side meter

REPT

Put light-side score 0-5 in A1. Angels vs devils.

=REPT("😇",A1)&REPT("😈",5-A1)

😇😇😇😈😈

Jedi or Sith alignment

IF

Put Jedi, Sith, or anything else in A1.

=IF(A1="Jedi","😇 Light side",IF(A1="Sith","😈 Dark side","⚖ Neutral"))

😇 Light side

Lightsaber color picker

CHOOSE

Put number 1-5 in A1 for blade color.

=CHOOSE(A1,"🔵 Blue","🟢 Green","🔴 Red","🟣 Purple","⚪ White")

🔵 Blue

Lightsaber duel winner

IF

Put Jedi power 0-10 in A1. Over 5 means the Jedi wins.

=IF(A1>5,"😇 Jedi wins","😈 Sith wins")

😇 Jedi wins

Hyperdrive motivator status

IF

Put 1 for ready, 0 for broken.

=IF(A1>0,"🚀 Hyperspace ready","⚠️ Motivator shot")

🚀 Hyperspace ready

Tractor beam strength

REPT

Put beam strength 0-5 in A1.

=REPT("◎",A1)&REPT("○",5-A1)&" tractor beam"

◎◎◎○○ tractor beam

Imperial loyalty meter

REPT

Put loyalty 0-5 in A1. Red vs black circles.

=REPT("🔴",A1)&REPT("⚫",5-A1)

🔴🔴🔴⚫⚫

Galactic Senate vote tally

REPT MAX

Put yes votes in A1 out of 10.

=REPT("👍",A1)&REPT("👎",MAX(0,10-A1))

👍👍👍👍👎👎👎👎👎👎

Death Star plans recovered

REPT

Put plans found 0-3 in A1. Scrolls point to the Death Star.

=REPT("📜",A1)&REPT("○",3-A1)&" → 🌑"

📜📜📜 → 🌑

Ewok victory celebration

REPT MAX

Put celebration level in A1. Confetti and trees.

=REPT("🎉",A1)&REPT("🌲",MAX(0,3-A1))

🎉🎉🎉🌲

Vader force choke reach

REPT

Put reach distance in A1. Hand to target.

=REPT("✋",1)&REPT("・",A1)&"💀"

✋・・・💀

Wookiee roar volume

REPT MAX CHAR

Put roar volume in A1. Speaker plus block meter.

=REPT("🔊",A1)&REPT(CHAR(9601),MAX(0,5-A1))

🔊🔊🔊▁▁

Escape pod launch sequence

REPT MAX

Put launch progress 0-10 in A1.

=REPT("・",MAX(0,10-A1))&"🚀"&REPT("・",A1)&"🪐"

・・・・・🚀・・・🪐

Order 66 execution count

REPT

Put execution count in A1.

=REPT("⚔️",A1)&" executed"

⚔️⚔️⚔️ executed

Yoda training patience

REPT

Put patience level 1-5 in A1.

=REPT("✨",A1)&" ...patience you must have"

✨✨✨ ...patience you must have

Han Solo parsecs brag

REPT MIN

Put parsecs in A1.

=A1&" parsecs"&REPT("🚀",MIN(A1,3))

12 parsecs🚀🚀🚀

Imperial March footsteps

REPT

Put step count in A1. Dum-dum rhythm text.

=REPT("🥾",A1)&" dum dum dum dum"

🥾🥾🥾 dum dum dum dum

Jabba palace audience

REPT

Put audience size in A1.

=REPT("💰",A1)&" palace"

💰💰💰 palace

Lightspeed skip damage risk

REPT IF MOD

Put risk level 0-10 in A1. Over 8 adds an explosion.

=REPT("✨",MOD(A1,5))&"🚀"&REPT("💥",IF(A1>8,1,0))

✨✨🚀