Google Sheets Progress Bar Formulas (Copy-Paste REPT

Year Progress block bar

Shows how far through the current year based on TODAY(). Ten blocks fill left to right. Updates daily. No input needed.

=REPT("█",MIN(10,MAX(0,ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*10,0)))))

█████░░░░░

REPT DATE YEAR TODAY ROUND MIN MAX

Year Progress block bar with percent

Shows year progress from TODAY() as a block bar plus a rounded percent label. Updates daily. No input needed.

=REPT("█",MIN(10,MAX(0,ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*10,0)))))&" "&ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*100,0)&"%"

█████░░░░░ 53%

REPT DATE YEAR TODAY ROUND MIN MAX

Year Progress month block bar

Shows year progress from TODAY() as twelve month blocks. One block per month of the year. No input needed.

=REPT("█",MIN(12,MAX(0,ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*12,0))))&REPT("░",MAX(0,12-MIN(12,MAX(0,ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*12,0)))))

██████░░░░░░

REPT DATE YEAR TODAY ROUND MIN MAX

Year Progress dot checkpoint bar

Shows year progress from TODAY() as filled and empty dots. Ten checkpoints mark the year. No input needed.

=REPT("●",MIN(10,MAX(0,ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*10,0))))&REPT("○",MAX(0,10-MIN(10,MAX(0,ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*10,0)))))

●●●●●○○○○○

REPT DATE YEAR TODAY ROUND MIN MAX

Block progress bar

Put current value in A1 and goal in B1 (use 100 for percent). Ten blocks fill from empty to done.

=REPT("█",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))

████████░░

REPT

Battery level

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%

REPT ROUND MIN MAX

Percent bar template

Put current value in A1 and goal in B1 (use 100 for a full percent scale). Ten blocks fill from 0% to done.

=REPT("█",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))

██████░░░░

REPT ROUND MIN MAX

Dark shade progress bar

Put current value in A1 and goal in B1 (use 100 for percent). Ten shaded blocks fill left to right.

=REPT(CHAR(9619),MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT(CHAR(9617),MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))

▓▓▓▓▓▓▓▓░░

REPT CHAR ROUND MIN MAX

Medium block progress bar

Put current value in A1 and goal in B1 (use 100 for percent). Medium blocks with light empty slots.

=REPT(CHAR(9604),MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT(CHAR(9617),MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))

▄▄▄▄▄▄░░░░

REPT CHAR ROUND MIN MAX

Green circle progress bar

Put current value in A1 and goal in B1 (e.g. 10). Green circles fill, white circles stay empty.

=REPT("🟢",MIN(A1,B1))&REPT("⚪",MAX(0,B1-A1))

🟢🟢🟢🟢🟢⚪⚪⚪⚪⚪

REPT MIN MAX

Blue square progress bar

Put current value in A1 and goal in B1 (e.g. 10). Blue squares fill the bar toward the goal.

=REPT("🟦",MIN(A1,B1))&REPT("⬜",MAX(0,B1-A1))

🟦🟦🟦🟦🟦⬜⬜⬜⬜⬜

REPT MIN MAX

Red alert progress bar

Put current value in A1 and goal in B1 (e.g. 10). Red squares show how close you are to the limit.

=REPT("🟥",MIN(A1,B1))&REPT("⬜",MAX(0,B1-A1))

🟥🟥🟥🟥🟥⬜⬜⬜⬜⬜

REPT MIN MAX

Rainbow segment progress bar

Put current value in A1 and goal in B1 (e.g. 6). Color segments fill in rainbow order.

=REPT("🟥",MIN(A1,1))&REPT("🟧",MIN(MAX(0,A1-1),1))&REPT("🟨",MIN(MAX(0,A1-2),1))&REPT("🟩",MIN(MAX(0,A1-3),1))&REPT("🟦",MIN(MAX(0,A1-4),1))&REPT("🟪",MIN(MAX(0,A1-5),1))&REPT("⬜",MAX(0,B1-A1))

🟥🟧🟨🟩🟦🟪

REPT MIN MAX

Water tank fill bar

Put current value in A1 and goal in B1 (e.g. 10). Droplets fill the tank from left to right.

=REPT("💧",MIN(A1,B1))&REPT("░",MAX(0,B1-A1))

💧💧💧💧💧░░░░░

REPT MIN MAX

Brick wall progress bar

Put current value in A1 and goal in B1 (e.g. 10). Bricks stack until the wall is complete.

=REPT("🧱",MIN(A1,B1))&REPT("░",MAX(0,B1-A1))

🧱🧱🧱🧱🧱░░░░░

REPT MIN MAX

Charging bolt progress bar

Put current value in A1 and goal in B1 (e.g. 10). Lightning bolts show charge building up.

=REPT("⚡",MIN(A1,B1))&REPT("░",MAX(0,B1-A1))

⚡⚡⚡⚡⚡░░░░░

REPT MIN MAX

Goal flag progress bar

Put current value in A1 and goal in B1 (e.g. 10). Blocks fill toward a finish flag.

=REPT("█",MIN(A1,B1))&REPT("░",MAX(0,B1-A1))&"🏁"

█████░░░░░🏁

REPT MIN MAX

Trophy goal progress bar

Put current value in A1 and goal in B1 (e.g. 10). Blocks fill toward a trophy at the end.

=REPT(CHAR(9608),MIN(A1,B1))&REPT(CHAR(9617),MAX(0,B1-A1))&"🏆"

█████░░░░░🏆

REPT CHAR MIN MAX

Percent label progress bar

Put current value in A1 and goal in B1 (use 100 for percent). Blocks plus a rounded percent label.

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

████████░░ 80%

REPT ROUND MIN MAX

Dot checkpoint progress bar

Put current value in A1 and goal in B1 (e.g. 10). Filled dots mark completed checkpoints.

=REPT("●",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))

●●●●●○○○○○

REPT MIN MAX

Year Progress dark shade bar

Shows year progress from TODAY() with dark shaded blocks. Ten segments fill as the year advances. No input needed.

=REPT(CHAR(9619),MIN(10,MAX(0,ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*10,0))))&REPT(CHAR(9617),MAX(0,10-MIN(10,MAX(0,ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*10,0)))))

▓▓▓▓▓░░░░░

REPT CHAR DATE YEAR TODAY ROUND MIN MAX

Year Progress dark shade bar with percent

Shows year progress from TODAY() as a dark shade bar plus a percent label. Updates daily. No input needed.

=REPT(CHAR(9619),MIN(10,MAX(0,ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*10,0))))&REPT(CHAR(9617),MAX(0,10-MIN(10,MAX(0,ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*10,0)))))&" "&ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*100,0)&"%"

▓▓▓▓▓░░░░░ 53%

REPT CHAR DATE YEAR TODAY ROUND MIN MAX

Year Progress dot checkpoint bar with percent

Shows year progress from TODAY() as dot checkpoints plus a percent label. Updates daily. No input needed.

=REPT("●",MIN(10,MAX(0,ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*10,0))))&REPT("○",MAX(0,10-MIN(10,MAX(0,ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*10,0)))))&" "&ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*100,0)&"%"

●●●●●○○○○○ 53%

REPT DATE YEAR TODAY ROUND MIN MAX

Year Progress green circle bar

Shows year progress from TODAY() as green and white circles. Ten circles fill through the year. No input needed.

=REPT("🟢",MIN(10,MAX(0,ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*10,0))))&REPT("⚪",MAX(0,10-MIN(10,MAX(0,ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*10,0)))))

🟢🟢🟢🟢🟢⚪⚪⚪⚪⚪

REPT DATE YEAR TODAY ROUND MIN MAX

Year Progress green circle bar with percent

Shows year progress from TODAY() as green circles plus a percent label. Updates daily. No input needed.

=REPT("🟢",MIN(10,MAX(0,ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*10,0))))&REPT("⚪",MAX(0,10-MIN(10,MAX(0,ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*10,0)))))&" "&ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*100,0)&"%"

🟢🟢🟢🟢🟢⚪⚪⚪⚪⚪ 53%

REPT DATE YEAR TODAY ROUND MIN MAX

Year Progress month block bar with percent

Shows year progress from TODAY() as twelve month blocks plus a percent label. Updates daily. No input needed.

=REPT("█",MIN(12,MAX(0,ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*12,0))))&REPT("░",MAX(0,12-MIN(12,MAX(0,ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*12,0)))))&" "&ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*100,0)&"%"

██████░░░░░░ 53%

REPT DATE YEAR TODAY ROUND MIN MAX

Light block progress

Put current value in A1 and goal in B1 (use 100 for percent). Lighter shade blocks fill left to right.

=REPT("▓",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))

▓▓▓▓▓▓▓▓░░

REPT ROUND MIN MAX

Braille micro-bar

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

=REPT("⠿",MIN(A1,B1))&REPT("⠀",MAX(0,B1-A1))

⠿⠿⠿⠀⠀

REPT

Sound level meter

Put volume level 0-8 in A1.

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

▁▂▃▄▅

LEFT MIN

Sparkline blocks

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

=REPT("█",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("▁",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))

█████▁▁▁▁▁

REPT

Fire intensity meter

Put intensity 0-5 in A1.

=REPT("🔥",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))

🔥🔥🔥○○

REPT

Gold bar vault

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

=REPT(CHAR(9619),MIN(A1,B1))&REPT(CHAR(9617),MAX(0,B1-A1))

▓▓▓░░

REPT CHAR

Wifi signal bars

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))

▄▅

REPT CHOOSE CHAR

Clap-o-meter

Put applause count in A1.

=REPT("👏",A1)

👏👏👏

REPT

Book reading progress

Put progress 1-4 in A1. Closed, reading, almost done, finished.

=CHOOSE(A1,"📕","📖","📗","✅")

📖

CHOOSE

Cat affection levels

Put level 1-4 in A1. Grumpy, curious, happy, loving.

=CHOOSE(A1,"😾","😼","😸","😻")

😸

CHOOSE

Wind gust strength

Put wind level 0-5 in A1.

=REPT("💨",MIN(A1,B1))&REPT("·",MAX(0,B1-A1))

💨💨💨··

REPT

Snowfall depth

Put snow depth 0-10 in A1.

=REPT("❄",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("·",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))

❄❄❄❄·······

REPT

Reading page progress

Put pages read 0-5 in A1.

=REPT("📖",MIN(A1,B1))&REPT("📕",MAX(0,B1-A1))

📖📖📖📕📕

REPT

Guitar solo intensity

Put solo intensity in A1.

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

🎸♪♪♪

REPT CHAR

Karaoke mic level

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

=REPT("🎤",1)&REPT(CHAR(9601),A1)&REPT(CHAR(9608),MAX(0,B1-A1))

🎤▁▁███

REPT CHAR

Dragon HP bar

Put hit points 0-10 in A1.

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

♥♥█░░ 🐉

REPT MIN MAX CHAR

Wizard sparkle level

Put magic level in A1.

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

🧙✨✨✨

REPT

Castle wall defense

Put wall strength 0-10 in A1. Solid blocks build up to the castle.

=REPT(CHAR(9608),MIN(A1,B1))&"🏰"&REPT(CHAR(9617),MAX(0,B1-A1))

███🏰░░░░░░░

REPT CHAR

Fence perimeter defense

Put fence strength 0-10 in A1. Blocks stack toward the barrier.

=REPT(CHAR(9608),MIN(A1,B1))&"🚧"&REPT(CHAR(9617),MAX(0,B1-A1))

███🚧░░░░░░░

REPT CHAR

Home fortification

Put fortify progress 0-10 in A1. Wall builds toward home.

=REPT(CHAR(9608),MIN(A1,B1))&"🏠"&REPT(CHAR(9617),MAX(0,B1-A1))

███🏠░░░░░░░

REPT CHAR

Forest tree line

Put clearance 0-10 in A1. Cleared path reaches the tree line.

=REPT(CHAR(9608),MIN(A1,B1))&"🌲"&REPT(CHAR(9617),MAX(0,B1-A1))

███🌲░░░░░░░

REPT CHAR

Bank vault barrier

Put security level 0-10 in A1. Dark blocks seal the vault.

=REPT(CHAR(9619),MIN(A1,B1))&"🏦"&REPT(CHAR(9617),MAX(0,B1-A1))

▓▓▓🏦░░░░░░░

REPT CHAR

Garden fence gate

Put fence progress 0-10 in A1. Blocks reach the garden gate.

=REPT(CHAR(9608),MIN(A1,B1))&"🌷"&REPT(CHAR(9617),MAX(0,B1-A1))

███🌷░░░░░░░

REPT CHAR

Camp perimeter wall

Put camp defense 0-10 in A1. Wall closes in on the tent.

=REPT(CHAR(9608),MIN(A1,B1))&"⛺"&REPT(CHAR(9617),MAX(0,B1-A1))

███⛺░░░░░░░

REPT CHAR

Treasure hoard guard

Put guard level 0-10 in A1. Blocks protect the gold.

=REPT(CHAR(9608),MIN(A1,B1))&"💰"&REPT(CHAR(9617),MAX(0,B1-A1))

███💰░░░░░░░

REPT CHAR

Beehive barrier

Put hive defense 0-10 in A1. Wall shields the honey.

=REPT(CHAR(9608),MIN(A1,B1))&"🍯"&REPT(CHAR(9617),MAX(0,B1-A1))

███🍯░░░░░░░

REPT CHAR

Harbor dock wall

Put dock progress 0-10 in A1. Pier builds toward the anchor.

=REPT(CHAR(9608),MIN(A1,B1))&"⚓"&REPT(CHAR(9617),MAX(0,B1-A1))

███⚓░░░░░░░

REPT CHAR

Barn paddock fence

Put fence progress 0-10 in A1. Rails close around the barn.

=REPT(CHAR(9608),MIN(A1,B1))&"🐄"&REPT(CHAR(9617),MAX(0,B1-A1))

███🐄░░░░░░░

REPT CHAR

Hospital ward barrier

Put safety level 0-10 in A1. Barrier reaches the ward.

=REPT(CHAR(9608),MIN(A1,B1))&"🏥"&REPT(CHAR(9617),MAX(0,B1-A1))

███🏥░░░░░░░

REPT CHAR

School yard fence

Put fence progress 0-10 in A1. Wall rings the school.

=REPT(CHAR(9608),MIN(A1,B1))&"🏫"&REPT(CHAR(9617),MAX(0,B1-A1))

███🏫░░░░░░░

REPT CHAR

Wood to fire to ash

Put burn progress 0-10 in A1. Logs catch fire, then cool to gray ash.

=IF(A1<=3,REPT("🪵",A1)&REPT("░",MAX(0,B1-A1)),IF(A1<=7,REPT("🪵",3)&REPT("🔥",A1-3)&REPT("░",MAX(0,B1-A1)),REPT("🪵",3)&REPT("🔥",4)&REPT("⬛",A1-7)&REPT("░",MAX(0,B1-A1))))

🪵🪵🪵🔥🔥🔥🔥⬛⬛░

IF REPT

Seedling to flower bloom

Put growth progress 0-10 in A1. Sprouts become plants, then blossoms.

=IF(A1<=3,REPT("🌱",A1)&REPT("░",MAX(0,B1-A1)),IF(A1<=6,REPT("🌱",3)&REPT("🌿",A1-3)&REPT("░",MAX(0,B1-A1)),REPT("🌱",3)&REPT("🌿",3)&REPT("🌸",A1-6)&REPT("░",MAX(0,B1-A1))))

🌱🌱🌱🌿🌿🌿🌸🌸░░

IF REPT

Cow herd to milk

Put dairy progress 0-10 in A1. Cows fill the bar, then milk takes over.

=IF(A1<=5,REPT("🐄",A1)&REPT("░",MAX(0,B1-A1)),REPT("🐄",5)&REPT("🥛",A1-5)&REPT("░",MAX(0,B1-A1)))

🐄🐄🐄🐄🐄🥛🥛🥛░░

IF REPT

Egg to chicken

Put hatch progress 0-10 in A1. Eggs crack, chicks emerge, hens rule the roost.

=IF(A1<=3,REPT("🥚",A1)&REPT("░",MAX(0,B1-A1)),IF(A1<=6,REPT("🥚",3)&REPT("🐣",A1-3)&REPT("░",MAX(0,B1-A1)),REPT("🥚",3)&REPT("🐣",3)&REPT("🐔",A1-6)&REPT("░",MAX(0,B1-A1))))

🥚🥚🥚🐣🐣🐣🐔🐔░░

IF REPT

Grapes to wine

Put ferment progress 0-10 in A1. Clusters crush down into glasses of wine.

=IF(A1<=5,REPT("🍇",A1)&REPT("░",MAX(0,B1-A1)),REPT("🍇",5)&REPT("🍷",A1-5)&REPT("░",MAX(0,B1-A1)))

🍇🍇🍇🍇🍇🍷🍷🍷░░

IF REPT

Dough to bread

Put bake progress 0-10 in A1. Dough rises in the oven, then comes out as loaves.

=IF(A1<=3,REPT("🫓",A1)&REPT("░",MAX(0,B1-A1)),IF(A1<=6,REPT("🫓",3)&REPT("🔥",A1-3)&REPT("░",MAX(0,B1-A1)),REPT("🫓",3)&REPT("🔥",3)&REPT("🍞",A1-6)&REPT("░",MAX(0,B1-A1))))

🫓🫓🫓🔥🔥🔥🍞🍞░░

IF REPT

Caterpillar to butterfly

Put metamorphosis progress 0-10 in A1. Larva cocoons, then wings unfurl.

=IF(A1<=3,REPT("🐛",A1)&REPT("░",MAX(0,B1-A1)),IF(A1<=6,REPT("🐛",3)&REPT("🛌",A1-3)&REPT("░",MAX(0,B1-A1)),REPT("🐛",3)&REPT("🛌",3)&REPT("🦋",A1-6)&REPT("░",MAX(0,B1-A1))))

🐛🐛🐛🛌🛌🛌🦋🦋░░

IF REPT

Wheat to toast

Put harvest progress 0-10 in A1. Grain becomes dough, then golden toast.

=IF(A1<=3,REPT("🌾",A1)&REPT("░",MAX(0,B1-A1)),IF(A1<=6,REPT("🌾",3)&REPT("🫓",A1-3)&REPT("░",MAX(0,B1-A1)),REPT("🌾",3)&REPT("🫓",3)&REPT("🍞",A1-6)&REPT("░",MAX(0,B1-A1))))

🌾🌾🌾🫓🫓🫓🍞🍞░░

IF REPT

Bean to coffee cup

Put brew progress 0-10 in A1. Beans grind down into steaming cups.

=IF(A1<=5,REPT("🫘",A1)&REPT("░",MAX(0,B1-A1)),REPT("🫘",5)&REPT("☕",A1-5)&REPT("░",MAX(0,B1-A1)))

🫘🫘🫘🫘🫘☕☕☕░░

IF REPT

Cocoa to chocolate

Put melt progress 0-10 in A1. Pods and beans become chocolate bars.

=IF(A1<=5,REPT("🌰",A1)&REPT("░",MAX(0,B1-A1)),REPT("🌰",5)&REPT("🍫",A1-5)&REPT("░",MAX(0,B1-A1)))

🌰🌰🌰🌰🌰🍫🍫🍫░░

IF REPT

Ice cube to puddle

Put melt progress 0-10 in A1. Ice thaws into water.

=IF(A1<=5,REPT("🧊",A1)&REPT("░",MAX(0,B1-A1)),REPT("🧊",5)&REPT("💧",A1-5)&REPT("░",MAX(0,B1-A1)))

🧊🧊🧊🧊🧊💧💧💧░░

IF REPT

Snow to snowman

Put build progress 0-10 in A1. Flakes pile up into a finished snowman.

=IF(A1<=6,REPT("❄️",A1)&REPT("░",MAX(0,B1-A1)),REPT("❄️",6)&REPT("⛄",A1-6)&REPT("░",MAX(0,B1-A1)))

❄️❄️❄️❄️❄️❄️⛄⛄⛄░

IF REPT

Cloud to rainfall

Put storm progress 0-10 in A1. Clouds darken, then rain pours down.

=IF(A1<=5,REPT("☁️",A1)&REPT("░",MAX(0,B1-A1)),REPT("☁️",5)&REPT("🌧️",A1-5)&REPT("░",MAX(0,B1-A1)))

☁️☁️☁️☁️☁️🌧️🌧️🌧️░░

IF REPT

Fish to sushi

Put prep progress 0-10 in A1. Fresh catch becomes plated sushi.

=IF(A1<=5,REPT("🐟",A1)&REPT("░",MAX(0,B1-A1)),REPT("🐟",5)&REPT("🍣",A1-5)&REPT("░",MAX(0,B1-A1)))

🐟🐟🐟🐟🐟🍣🍣🍣░░

IF REPT

Potato to fries

Put fry progress 0-10 in A1. Spuds slice up into crispy fries.

=IF(A1<=5,REPT("🥔",A1)&REPT("░",MAX(0,B1-A1)),REPT("🥔",5)&REPT("🍟",A1-5)&REPT("░",MAX(0,B1-A1)))

🥔🥔🥔🥔🥔🍟🍟🍟░░

IF REPT

Tomato to pizza

Put cook progress 0-10 in A1. Tomatoes sauce up into a hot pizza.

=IF(A1<=5,REPT("🍅",A1)&REPT("░",MAX(0,B1-A1)),REPT("🍅",5)&REPT("🍕",A1-5)&REPT("░",MAX(0,B1-A1)))

🍅🍅🍅🍅🍅🍕🍕🍕░░

IF REPT

Bees to honey

Put pollination progress 0-10 in A1. Bees buzz, then honey fills the jar.

=IF(A1<=5,REPT("🐝",A1)&REPT("░",MAX(0,B1-A1)),REPT("🐝",5)&REPT("🍯",A1-5)&REPT("░",MAX(0,B1-A1)))

🐝🐝🐝🐝🐝🍯🍯🍯░░

IF REPT

Milk to cheese

Put aging progress 0-10 in A1. Milk curdles into cheese wheels.

=IF(A1<=5,REPT("🥛",A1)&REPT("░",MAX(0,B1-A1)),REPT("🥛",5)&REPT("🧀",A1-5)&REPT("░",MAX(0,B1-A1)))

🥛🥛🥛🥛🥛🧀🧀🧀░░

IF REPT

Corn to popcorn

Put pop progress 0-10 in A1. Kernels heat up and burst into popcorn.

=IF(A1<=4,REPT("🌽",A1)&REPT("░",MAX(0,B1-A1)),IF(A1<=7,REPT("🌽",4)&REPT("🔥",A1-4)&REPT("░",MAX(0,B1-A1)),REPT("🌽",4)&REPT("🔥",3)&REPT("🍿",A1-7)&REPT("░",MAX(0,B1-A1))))

🌽🌽🌽🌽🔥🔥🔥🍿🍿░

IF REPT

Apple to pie

Put bake progress 0-10 in A1. Apples slice up into a fresh pie.

=IF(A1<=5,REPT("🍎",A1)&REPT("░",MAX(0,B1-A1)),REPT("🍎",5)&REPT("🥧",A1-5)&REPT("░",MAX(0,B1-A1)))

🍎🍎🍎🍎🍎🥧🥧🥧░░

IF REPT

Pig to bacon

Put cook progress 0-10 in A1. Pork sizzles into crispy bacon strips.

=IF(A1<=5,REPT("🐷",A1)&REPT("░",MAX(0,B1-A1)),REPT("🐷",5)&REPT("🥓",A1-5)&REPT("░",MAX(0,B1-A1)))

🐷🐷🐷🐷🐷🥓🥓🥓░░

IF REPT

Coal to diamond

Put pressure progress 0-10 in A1. Black coal compresses into diamonds.

=IF(A1<=5,REPT("⬛",A1)&REPT("░",MAX(0,B1-A1)),REPT("⬛",5)&REPT("💎",A1-5)&REPT("░",MAX(0,B1-A1)))

⬛⬛⬛⬛⬛💎💎💎░░

IF REPT

Lemon to lemonade

Put squeeze progress 0-10 in A1. Lemons juice up into cold lemonade.

=IF(A1<=5,REPT("🍋",A1)&REPT("░",MAX(0,B1-A1)),REPT("🍋",5)&REPT("🥤",A1-5)&REPT("░",MAX(0,B1-A1)))

🍋🍋🍋🍋🍋🥤🥤🥤░░

IF REPT

Seed to pumpkin

Put grow progress 0-10 in A1. Sprouts vine out into a giant pumpkin.

=IF(A1<=5,REPT("🌱",A1)&REPT("░",MAX(0,B1-A1)),REPT("🌱",5)&REPT("🎃",A1-5)&REPT("░",MAX(0,B1-A1)))

🌱🌱🌱🌱🌱🎃🎃🎃░░

IF REPT

Trash to recycling

Put sort progress 0-10 in A1. Waste bins empty into green recycling.

=IF(A1<=5,REPT("🗑️",A1)&REPT("░",MAX(0,B1-A1)),REPT("🗑️",5)&REPT("♻️",A1-5)&REPT("░",MAX(0,B1-A1)))

🗑️🗑️🗑️🗑️🗑️♻️♻️♻️░░

IF REPT

Letter to mailbox

Put delivery progress 0-10 in A1. Envelopes travel to the mailbox.

=IF(A1<=5,REPT("✉️",A1)&REPT("░",MAX(0,B1-A1)),REPT("✉️",5)&REPT("📬",A1-5)&REPT("░",MAX(0,B1-A1)))

✉️✉️✉️✉️✉️📬📬📬░░

IF REPT

Ore to gold

Put mining progress 0-10 in A1. Pickaxes strike rock, then gold appears.

=IF(A1<=3,REPT("⛏️",A1)&REPT("░",MAX(0,B1-A1)),IF(A1<=6,REPT("⛏️",3)&REPT("🪨",A1-3)&REPT("░",MAX(0,B1-A1)),REPT("⛏️",3)&REPT("🪨",3)&REPT("💰",A1-6)&REPT("░",MAX(0,B1-A1))))

⛏️⛏️⛏️🪨🪨🪨💰💰░░

IF REPT

Brick to house

Put build progress 0-10 in A1. Bricks stack up into a finished home.

=IF(A1<=6,REPT("🧱",A1)&REPT("░",MAX(0,B1-A1)),REPT("🧱",6)&REPT("🏠",A1-6)&REPT("░",MAX(0,B1-A1)))

🧱🧱🧱🧱🧱🧱🏠🏠🏠░

IF REPT

Yarn to sweater

Put knit progress 0-10 in A1. Balls of yarn become a cozy sweater.

=IF(A1<=5,REPT("🧶",A1)&REPT("░",MAX(0,B1-A1)),REPT("🧶",5)&REPT("🧥",A1-5)&REPT("░",MAX(0,B1-A1)))

🧶🧶🧶🧶🧶🧥🧥🧥░░

IF REPT

Water to tea

Put steep progress 0-10 in A1. Water heats, brews, then pours into cups.

=IF(A1<=3,REPT("💧",A1)&REPT("░",MAX(0,B1-A1)),IF(A1<=6,REPT("💧",3)&REPT("🫖",A1-3)&REPT("░",MAX(0,B1-A1)),REPT("💧",3)&REPT("🫖",3)&REPT("🍵",A1-6)&REPT("░",MAX(0,B1-A1))))

💧💧💧🫖🫖🫖🍵🍵░░

IF REPT

Rock to gem

Put polish progress 0-10 in A1. Rough stone cuts into a sparkling gem.

=IF(A1<=5,REPT("🪨",A1)&REPT("░",MAX(0,B1-A1)),REPT("🪨",5)&REPT("💎",A1-5)&REPT("░",MAX(0,B1-A1)))

🪨🪨🪨🪨🪨💎💎💎░░

IF REPT

Egg to omelette

Put cook progress 0-10 in A1. Eggs crack, hit the pan, then plate up.

=IF(A1<=3,REPT("🥚",A1)&REPT("░",MAX(0,B1-A1)),IF(A1<=6,REPT("🥚",3)&REPT("🍳",A1-3)&REPT("░",MAX(0,B1-A1)),REPT("🥚",3)&REPT("🍳",3)&REPT("🍽️",A1-6)&REPT("░",MAX(0,B1-A1))))

🥚🥚🥚🍳🍳🍳🍽️🍽️░░

IF REPT

Sand to sandcastle

Put sculpt progress 0-10 in A1. Beach sand piles into a castle.

=IF(A1<=5,REPT("🏖️",A1)&REPT("░",MAX(0,B1-A1)),REPT("🏖️",5)&REPT("🏰",A1-5)&REPT("░",MAX(0,B1-A1)))

🏖️🏖️🏖️🏖️🏖️🏰🏰🏰░░

IF REPT

Flour to cake

Put bake progress 0-10 in A1. Flour mixes, bakes, then becomes cake.

=IF(A1<=3,REPT("🌾",A1)&REPT("░",MAX(0,B1-A1)),IF(A1<=6,REPT("🌾",3)&REPT("🔥",A1-3)&REPT("░",MAX(0,B1-A1)),REPT("🌾",3)&REPT("🔥",3)&REPT("🎂",A1-6)&REPT("░",MAX(0,B1-A1))))

🌾🌾🌾🔥🔥🔥🎂🎂░░

IF REPT

Cash to bank

Put deposit progress 0-10 in A1. Bills stack up, then land in the bank.

=IF(A1<=3,REPT("💵",A1)&REPT("░",MAX(0,B1-A1)),IF(A1<=6,REPT("💵",3)&REPT("💰",A1-3)&REPT("░",MAX(0,B1-A1)),REPT("💵",3)&REPT("💰",3)&REPT("🏦",A1-6)&REPT("░",MAX(0,B1-A1))))

💵💵💵💰💰💰🏦🏦░░

IF REPT

Coins to piggy bank

Put savings progress 0-10 in A1. Coins clink in until the piggy bank is full.

=IF(A1<=6,REPT("🪙",A1)&REPT("░",MAX(0,B1-A1)),REPT("🪙",6)&REPT("🐷",A1-6)&REPT("░",MAX(0,B1-A1)))

🪙🪙🪙🪙🪙🪙🐷🐷🐷░

IF REPT

Paycheck to savings

Put save progress 0-10 in A1. Pay arrives, cash stacks, then hits the vault.

=IF(A1<=3,REPT("💼",A1)&REPT("░",MAX(0,B1-A1)),IF(A1<=6,REPT("💼",3)&REPT("💵",A1-3)&REPT("░",MAX(0,B1-A1)),REPT("💼",3)&REPT("💵",3)&REPT("🏦",A1-6)&REPT("░",MAX(0,B1-A1))))

💼💼💼💵💵💵🏦🏦░░

IF REPT

Wallet to bank

Put transfer progress 0-10 in A1. Cash leaves the wallet and reaches the bank.

=IF(A1<=5,REPT("👛",A1)&REPT("░",MAX(0,B1-A1)),REPT("👛",5)&REPT("🏦",A1-5)&REPT("░",MAX(0,B1-A1)))

👛👛👛👛👛🏦🏦🏦░░

IF REPT

Cart to checkout

Put shop progress 0-10 in A1. Groceries fill the cart, then you pay at checkout.

=IF(A1<=6,REPT("🛒",A1)&REPT("░",MAX(0,B1-A1)),REPT("🛒",6)&REPT("💳",A1-6)&REPT("░",MAX(0,B1-A1)))

🛒🛒🛒🛒🛒🛒💳💳💳░

IF REPT

Invoice to paid

Put billing progress 0-10 in A1. Invoices clear, then payment lands.

=IF(A1<=4,REPT("📄",A1)&REPT("░",MAX(0,B1-A1)),IF(A1<=7,REPT("📄",4)&REPT("✅",A1-4)&REPT("░",MAX(0,B1-A1)),REPT("📄",4)&REPT("✅",3)&REPT("💰",A1-7)&REPT("░",MAX(0,B1-A1))))

📄📄📄📄✅✅✅💰💰░

IF REPT

Rain to rainbow

Put clearing progress 0-10 in A1. Storm clouds break into a rainbow.

=IF(A1<=5,REPT("🌧️",A1)&REPT("░",MAX(0,B1-A1)),REPT("🌧️",5)&REPT("🌈",A1-5)&REPT("░",MAX(0,B1-A1)))

🌧️🌧️🌧️🌧️🌧️🌈🌈🌈░░

IF REPT

Night to day

Put dawn progress 0-10 in A1. Moon fades as the sun rises.

=IF(A1<=5,REPT("🌙",A1)&REPT("░",MAX(0,B1-A1)),REPT("🌙",5)&REPT("☀️",A1-5)&REPT("░",MAX(0,B1-A1)))

🌙🌙🌙🌙🌙☀️☀️☀️░░

IF REPT

Candle to light bulb

Put upgrade progress 0-10 in A1. Candle flame gives way to electric light.

=IF(A1<=5,REPT("🕯️",A1)&REPT("░",MAX(0,B1-A1)),REPT("🕯️",5)&REPT("💡",A1-5)&REPT("░",MAX(0,B1-A1)))

🕯️🕯️🕯️🕯️🕯️💡💡💡░░

IF REPT

Wood to paper

Put mill progress 0-10 in A1. Logs pulp down into sheets of paper.

=IF(A1<=5,REPT("🪵",A1)&REPT("░",MAX(0,B1-A1)),REPT("🪵",5)&REPT("📄",A1-5)&REPT("░",MAX(0,B1-A1)))

🪵🪵🪵🪵🪵📄📄📄░░

IF REPT

Sheep to yarn

Put shear progress 0-10 in A1. Wool clips off the flock into yarn balls.

=IF(A1<=5,REPT("🐑",A1)&REPT("░",MAX(0,B1-A1)),REPT("🐑",5)&REPT("🧶",A1-5)&REPT("░",MAX(0,B1-A1)))

🐑🐑🐑🐑🐑🧶🧶🧶░░

IF REPT

Oil barrel to gas pump

Put refine progress 0-10 in A1. Crude oil becomes fuel at the pump.

=IF(A1<=5,REPT("🛢️",A1)&REPT("░",MAX(0,B1-A1)),REPT("🛢️",5)&REPT("⛽",A1-5)&REPT("░",MAX(0,B1-A1)))

🛢️🛢️🛢️🛢️🛢️⛽⛽⛽░░

IF REPT

Seed to apple tree

Put orchard progress 0-10 in A1. Sprouts grow into trees heavy with apples.

=IF(A1<=3,REPT("🌱",A1)&REPT("░",MAX(0,B1-A1)),IF(A1<=6,REPT("🌱",3)&REPT("🌳",A1-3)&REPT("░",MAX(0,B1-A1)),REPT("🌱",3)&REPT("🌳",3)&REPT("🍎",A1-6)&REPT("░",MAX(0,B1-A1))))

🌱🌱🌱🌳🌳🌳🍎🍎░░

IF REPT

Idea to rocket launch

Put startup progress 0-10 in A1. Lightbulb moments lift off into launch.

=IF(A1<=5,REPT("💡",A1)&REPT("░",MAX(0,B1-A1)),REPT("💡",5)&REPT("🚀",A1-5)&REPT("░",MAX(0,B1-A1)))

💡💡💡💡💡🚀🚀🚀░░

IF REPT

Pen to published book

Put writing progress 0-10 in A1. Drafts scribble out into a finished book.

=IF(A1<=5,REPT("🖊️",A1)&REPT("░",MAX(0,B1-A1)),REPT("🖊️",5)&REPT("📖",A1-5)&REPT("░",MAX(0,B1-A1)))

🖊️🖊️🖊️🖊️🖊️📖📖📖░░

IF REPT

Grapes to jam jar

Put preserve progress 0-10 in A1. Grape clusters cook down into jam.

=IF(A1<=5,REPT("🍇",A1)&REPT("░",MAX(0,B1-A1)),REPT("🍇",5)&REPT("🫙",A1-5)&REPT("░",MAX(0,B1-A1)))

🍇🍇🍇🍇🍇🫙🫙🫙░░

IF REPT

Clay to pottery

Put kiln progress 0-10 in A1. Wet clay fires into finished pottery.

=IF(A1<=4,REPT("🟤",A1)&REPT("░",MAX(0,B1-A1)),IF(A1<=7,REPT("🟤",4)&REPT("🔥",A1-4)&REPT("░",MAX(0,B1-A1)),REPT("🟤",4)&REPT("🔥",3)&REPT("🏺",A1-7)&REPT("░",MAX(0,B1-A1))))

🟤🟤🟤🟤🔥🔥🔥🏺🏺░

IF REPT

Homework to diploma

Put study progress 0-10 in A1. Books stack up into a graduation diploma.

=IF(A1<=6,REPT("📚",A1)&REPT("░",MAX(0,B1-A1)),REPT("📚",6)&REPT("🎓",A1-6)&REPT("░",MAX(0,B1-A1)))

📚📚📚📚📚📚🎓🎓🎓░

IF REPT

Question to answer

Put solve progress 0-10 in A1. Puzzles click from questions into answers.

=IF(A1<=5,REPT("❓",A1)&REPT("░",MAX(0,B1-A1)),REPT("❓",5)&REPT("✅",A1-5)&REPT("░",MAX(0,B1-A1)))

❓❓❓❓❓✅✅✅░░

IF REPT

Maple sap to syrup

Put boil progress 0-10 in A1. Sap drips from leaves into golden syrup.

=IF(A1<=5,REPT("🍁",A1)&REPT("░",MAX(0,B1-A1)),REPT("🍁",5)&REPT("🍯",A1-5)&REPT("░",MAX(0,B1-A1)))

🍁🍁🍁🍁🍁🍯🍯🍯░░

IF REPT

Rep counter bar

Put reps completed in A1 and rep goal in B1 (e.g. 12). Muscle emoji fills the bar.

=REPT("💪",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))

💪💪💪💪💪💪💪💪○○○○

REPT MIN MAX

Set tracker bar

Put sets done in A1 and sets planned in B1 (e.g. 5). Checkmarks track your working sets.

=REPT("✅",MIN(A1,B1))&REPT("⬜",MAX(0,B1-A1))&" "&A1&"/"&B1&" sets"

✅✅✅⬜⬜ 3/5 sets

REPT MIN MAX

Volume load meter

Put session volume in A1 and weekly target in B1. Block bar tracks total load.

=REPT("█",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))&" kg"

███████░░░ kg

REPT ROUND MIN MAX

Run distance progress

Put miles logged in A1 and weekly goal in B1. Runners fill the distance bar.

=REPT("🏃",MIN(A1,B1))&REPT("·",MAX(0,B1-A1))&" "&A1&"/"&B1&" mi"

🏃🏃🏃🏃🏃·· 5/7 mi

REPT MIN MAX

Weekly mileage bar

Put miles this week in A1 and weekly target in B1. Ten blocks scale to your mileage goal.

=REPT("█",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))&" "&A1&"/"&B1&" mi"

████████░░ 18/20 mi

REPT MIN MAX

5K training countdown

Put miles logged in A1 toward a 3.1-mile 5K. Shows miles remaining to the finish.

=MAX(0,3.1-A1)&" mi to 5K 🏁"

1.1 mi to 5K 🏁

MAX

10K training countdown

Put miles logged in A1 toward a 6.2-mile 10K. Shows miles remaining to the finish.

=MAX(0,6.2-A1)&" mi to 10K 🏁"

2.2 mi to 10K 🏁

MAX

Gym streak flame

Put streak days in A1 and goal in B1. Flames track consecutive gym days.

=REPT("🔥",MIN(A1,B1))&REPT("·",MAX(0,B1-A1))&" "&A1&" days"

🔥🔥🔥🔥🔥·· 5 days

REPT MIN MAX

Macro protein bar

Put protein grams in A1 and daily target in B1. Ten steak marks scale to your macro goal.

=REPT("🥩",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("○",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))&" "&A1&"g protein"

🥩🥩🥩🥩🥩🥩🥩🥩○○ 120g protein

REPT MIN MAX

Meal prep containers

Put meals prepped in A1 and meals planned in B1. Bento boxes fill the prep row.

=REPT("🍱",MIN(A1,B1))&REPT("⬜",MAX(0,B1-A1))&" meals prepped"

🍱🍱🍱🍱🍱⬜⬜ meals prepped

REPT MIN MAX

Calorie budget meter

Put calories eaten in A1 and daily budget in B1. Blocks show calories remaining.

=REPT("█",MIN(10,MAX(0,ROUND((B1-A1)/B1*10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND((B1-A1)/B1*10,0)))))&" cal left"

███████░░░ cal left

REPT ROUND MIN MAX

Water intake drops

Put glasses drunk in A1 and daily goal in B1. Water drops track hydration.

=REPT("💧",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))&" "&A1&"/"&B1&" glasses"

💧💧💧💧💧💧○○ 6/8 glasses

REPT MIN MAX

Prep Sunday checklist

Put prep tasks done in A1 and tasks planned in B1. Checkmarks track meal prep Sunday.

=REPT("✅",MIN(A1,B1))&REPT("📋",MAX(0,B1-A1))&" prep tasks"

✅✅✅📋📋 prep tasks

REPT MIN MAX

Income vs expense bar

Put income in A1 and expenses in B1. Dollar blocks show surplus left after bills.

=IF(A1>=B1,REPT("💵",MIN(10,MAX(0,ROUND((A1-B1)/A1*10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND((A1-B1)/A1*10,0)))))&" surplus","⚠️ overspent")

💵💵💵💵💵💵░░░░ surplus

IF REPT MIN MAX ROUND

Savings goal percent bar

Put saved in A1 and savings goal in B1. Piggy blocks track your goal percent.

=REPT("🐷",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("○",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))&" "&ROUND(A1/B1*100,0)&"% saved"

🐷🐷🐷🐷🐷🐷○○○○ 62% saved

REPT ROUND MIN MAX

Tax refund countdown

Put days until refund in A1. Hourglasses count down to refund day.

=REPT("⏳",MIN(A1,5))&" "&A1&" days to refund"

⏳⏳⏳ 3 days to refund

REPT MIN

Estimated tax owed meter

Put tax owed in A1 and safe harbor in B1. Red blocks rise as owed tax climbs.

=REPT("🔴",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))&" tax owed"

🔴🔴🔴🔴🔴🔴░░░░ tax owed

REPT ROUND MIN MAX

Revenue cumulative counter

Put total revenue in A1. Money bags stack as cumulative sales grow.

=REPT("💰",MIN(10,MAX(1,ROUND(A1/1000,0))))&" $"&TEXT(A1,"#,##0")

💰💰💰💰💰 $12,500

REPT MIN MAX ROUND TEXT

Debt payoff snowball progress

Put paid down in A1 and total debt in B1. Snowballs melt debt blocks away.

=REPT("❄️",MIN(A1,B1))&REPT("🧊",MAX(0,B1-A1))&" $"&A1&" paid"

❄️❄️❄️❄️🧊🧊🧊 $4,000 paid

REPT MIN MAX

Emergency fund blocks

Put fund balance in A1 and three-month target in B1. Vault blocks fill the cushion.

=REPT("🏦",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))&" fund"

🏦🏦🏦🏦🏦🏦░░░░ fund

REPT ROUND MIN MAX

Subscription leak counter

Put active subscriptions in A1. Dripping taps count recurring leaks.

=REPT("🚰",MIN(A1,10))&" "&A1&" subs"

🚰🚰🚰🚰🚰 5 subs

REPT MIN

Side hustle income bar

Put side income in A1 and monthly target in B1. Laptop blocks track hustle revenue.

=REPT("💻",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("○",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))&" $"&A1

💻💻💻💻💻💻○○○○ $600

REPT ROUND MIN MAX

Paycheck allocation bar

Put allocated dollars in A1 and paycheck in B1. Slices show where pay went.

=REPT("🍕",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("○",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))&" allocated"

🍕🍕🍕🍕🍕🍕🍕○○○ allocated

REPT ROUND MIN MAX

Budget burn rate meter

Put days left in month in A1 and budget percent used in B1. Flame tracks burn pace.

=REPT("🔥",MIN(10,MAX(0,ROUND(B1/10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND(B1/10,0)))))&" "&B1&"% used"

🔥🔥🔥🔥🔥🔥░░░░ 62% used

REPT ROUND MIN MAX

Cash reserve thermometer

Put reserve months in A1 (0-6). Thermometer blocks show runway cushion.

=REPT("🌡️",MIN(A1,6))&REPT("○",MAX(0,6-A1))&" "&A1&" mo runway"

🌡️🌡️🌡️🌡️○○ 4 mo runway

REPT MIN MAX

Don't break chain streak bar

Put streak days in A1 and goal in B1. Green checks mark your unbroken chain.

=REPT("✅",MIN(A1,B1))&REPT("⬜",MAX(0,B1-A1))&" "&A1&" day streak"

✅✅✅✅✅⬜⬜ 5 day streak

REPT MIN MAX

Habit dot grid 7 days

Put habits done 0-7 in A1. Filled dots mark completed days this week.

=REPT("●",MIN(A1,7))&REPT("○",MAX(0,7-A1))&" "&A1&"/7 days"

●●●●●○○ 5/7 days

REPT MIN MAX

Habit dot grid 30 days

Put habits done 0-30 in A1. Thirty dots show your monthly consistency.

=REPT("●",MIN(A1,30))&REPT("○",MAX(0,30-A1))

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

REPT MIN MAX

Morning routine checklist

Put morning tasks done in A1 and tasks planned in B1. Sun icons fill the AM row.

=REPT("☀️",MIN(A1,B1))&REPT("⬜",MAX(0,B1-A1))&" AM routine"

☀️☀️☀️☀️⬜⬜ AM routine

REPT MIN MAX

Anxiety level meter

Put anxiety 0-10 in A1. Storm clouds thicken as anxiety rises.

=REPT("🌧️",MIN(A1,10))&REPT("☀️",MAX(0,10-A1))&" level "&A1

🌧️🌧️🌧️🌧️☀️☀️☀️☀️☀️☀️ level 4

REPT MIN MAX

Manifestation affirmation tick

Put affirmations read today in A1 and daily goal in B1. Sparkles mark intention work.

=REPT("✨",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))&" affirmed"

✨✨✨○○ affirmed

REPT MIN MAX

Weekly planning progress

Put planning tasks done in A1 and tasks total in B1. Calendar blocks fill the week plan.

=REPT("📅",MIN(A1,B1))&REPT("⬜",MAX(0,B1-A1))&" planned"

📅📅📅📅⬜⬜ planned

REPT MIN MAX

Goal intention bar

Put intention actions in A1 and weekly target in B1. Target emojis track goal follow-through.

=REPT("🎯",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))&" "&A1&"/"&B1

🎯🎯🎯🎯○○ 4/6

REPT MIN MAX

Gratitude counter

Put gratitude lines written in A1 and daily goal in B1. Hearts count thankful notes.

=REPT("💛",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))&" grateful"

💛💛💛○○ grateful

REPT MIN MAX

Meditation minutes bar

Put minutes meditated in A1 and daily goal in B1. Lotus blocks fill as minutes stack.

=REPT("🧘",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("○",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))&" "&A1&" min"

🧘🧘🧘🧘🧘🧘○○○○ 12 min

REPT ROUND MIN MAX

Screen time shame bar

Put screen hours in A1 and daily limit in B1. Phone blocks shame-scroll past your cap.

=REPT("📱",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))&" "&A1&"h screen"

📱📱📱📱📱📱📱░░░ 4.2h screen

REPT ROUND MIN MAX

Habit stack flame streak

Put stacked habit days in A1 and goal in B1. Flames track consecutive stack days.

=REPT("🔥",MIN(A1,B1))&REPT("·",MAX(0,B1-A1))&" "&A1&" stack days"

🔥🔥🔥🔥· 4 stack days

REPT MIN MAX

Focus time pomodoro bar

Put pomodoros done in A1 and daily goal in B1. Tomato blocks track deep work sessions.

=REPT("🍅",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))&" "&A1&" pomos"

🍅🍅🍅🍅○○ 4 pomos

REPT MIN MAX

Self-care checklist

Put self-care acts done in A1 and acts planned in B1. Spa icons fill the care row.

=REPT("🛁",MIN(A1,B1))&REPT("⬜",MAX(0,B1-A1))&" self-care"

🛁🛁🛁⬜⬜ self-care

REPT MIN MAX

Intentions vs actions bar

Put actions taken in A1 and intentions set in B1. Checks show follow-through gap.

=REPT("✅",MIN(A1,B1))&REPT("💭",MAX(0,B1-A1))&" "&A1&"/"&B1&" done"

✅✅✅💭💭 3/5 done

REPT MIN MAX

Cumulative sales counter

Put total deals closed in A1. Trophy stacks celebrate cumulative wins.

=REPT("🏆",MIN(A1,10))&" "&A1&" deals closed"

🏆🏆🏆🏆🏆 5 deals closed

REPT MIN

Monthly quota percent bar

Put sales in A1 and monthly quota in B1. Bar blocks track quota percent.

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

███████░░░ 72% quota

REPT ROUND MIN MAX

Commission progress bar

Put commission earned in A1 and target in B1. Money blocks track payout progress.

=REPT("💵",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("○",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))&" $"&A1

💵💵💵💵💵💵○○○○ $3,200

REPT ROUND MIN MAX

Sales funnel progress

Put funnel stage 0-5 in A1. Funnel blocks fill from top to closed deal.

=REPT("▼",MIN(A1,5))&REPT("▽",MAX(0,5-A1))&" stage "&A1

▼▼▼▽▽ stage 3

REPT MIN MAX

Closing probability bar

Put close percent in A1. Ten blocks scale to deal win likelihood.

=REPT("█",MIN(10,MAX(0,ROUND(A1/10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND(A1/10,0)))))&" "&A1&"% close"

███████░░░ 72% close

REPT ROUND MIN MAX

Outreach email counter

Put emails sent in A1 and daily target in B1. Envelope blocks track outreach volume.

=REPT("✉️",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))&" "&A1&" sent"

✉️✉️✉️✉️✉️○○○ 5 sent

REPT MIN MAX

Annual sales milestone counter

Put annual revenue in A1. Star bursts mark each $10K milestone crossed.

=REPT("🌟",MIN(10,MAX(0,ROUND(A1/10000,0))))&" $"&TEXT(A1,"#,##0")&" YTD"

🌟🌟🌟🌟🌟 $52,000 YTD

REPT MIN MAX ROUND TEXT