Did You Know?
I always name my coding sheet 'fish'.
Xuebing Du
Monterey Bay Aquarium

if i look back, i am lost
Today's Document
Three Goblin Art
AnasAbdin

#extradirty
DEAR READER
I'd rather be in outer space 🛸
cherry valley forever
sheepfilms
🪼
2025 on Tumblr: Trends That Defined the Year
hello vonnie
No title available
Not today Justin
KIROKAZE

izzy's playlists!
Cosmic Funnies
Alisa U Zemlji Chuda
seen from United States

seen from United States
seen from United States

seen from United States

seen from Japan
seen from United States

seen from United States
seen from United States

seen from United States
seen from United States

seen from United States
seen from France

seen from United States

seen from United States
seen from United States
seen from France

seen from South Korea

seen from United States
seen from Kazakhstan

seen from United States
@fuck-yeah-spreadsheets
Did You Know?
I always name my coding sheet 'fish'.
Easter egg for office workers: if you go onto Excel and press ctrl+right, then ctrl+down, you will reach cell XFD1048576. If you put a dot in there, then ctrl+A and fill every cell in black, you can then print 34 million black pages from your office printer and get fired
birth of venus
this is in excel btw. and this image is exactly half green and half pink. and for each shade of green there is an equal number of "opposite" pink pixels. and this represents a major leap forward in excel macro use by me
the origin of this concept was, oh, what if you were trying to recreate an image as a tapestry? and you had, say, 24 colors of yarn? and you wanted the image to have equal amounts of each color of yarn? how would you effectively use the yarn you had to create the image? you'd have to look at all the colors of the original image, then look at your yarn colors, and find some consistent method for choosing what original colors are replaced with what yarn colors. but then it turns out there's a lot of different rules you could imagine or follow, which produce different-looking images. and you can end up with something like this:
which is cool. and it would be cool to say, find a granny square cardigan pattern with 24 squares, knit these squares, make a sick cardigan. but then i realized i don't know how to knit or anything. and once you accept that there isn't really a clear "application" and this concept lives on a screen, you open yourself up to more possibilities. a la birth of venus.
step 1: python script that looks at the original image and generates an excel spreadsheet the same dimensions (793 x 1322 pixels = 793 x 1322 cells), and each cell is populated with the hex code of the color that appears in that pixel of the original image
step 2: excel macro to generate list of every unique hex code that appears in the excel spreadsheet.
step 3: excel macro to calculate the R, G, B values of each of those hex codes.
step 4: excel macro to fill each cell with the color of that hex code (not necessary, i just like to do it).
step 5: I add in Saturation (the difference between the largest and smallest RGB value) and Lightness (average of all RGB values).
step 6: pick a color palette. i always find myself gravitating towards groovy seventies palettes with warm reds and oranges, so i decided not to do that this time. i looked on coolors and found a color palette that was all dark greens that were similar to each other. there were only like four colors or something in this palette. and to make it truly different from the other project, there should be a small gradient. so i determined the smallest possible change between colors and used an excel macro to color it. i was going to stop here and do the entire image in shades of green (inspired by that guy on tiktok that paints using only one color) but then. idk. i realized the "opposite" of each color was an equally subtly changing pink. so i imagined that the end of this process would be an "abstract" image, with subtle variations of pink and green, that would end up suggesting birth of venus.
so all told, i had 502 unique replacement colors, 251 of which are green, 251 of which are pink. (793 x 1322) / 502 = either 2088 or 2089 of each color.
step 7: find some method for finding the difference between the original colors of the image and my new color palette. I use a method of comparing, R, G, B, S and L:
((abs(R1 - R2) + abs(G1 - G2) + abs(B1 - B2)) / 3) + abs(S1 - S2) + abs(L1 - L2)
and you come up with something like this. on the left, those are colors that appear in the original image. across the top, those greens are the colors i'm replacing it with. in blue, that's the number of each new color i have to work with (it's just blue for contrast). and in the center, this pink area, that's a giant spreadsheet with the "objective" difference between each original color and each replacement color. it's pink because i have some conditional formatting applied, ignore that part.
and in this situation, you have some choices to make. in the original image up there, i used a schema prioritizing light and dark--i.e., i looked at the darkest color (pure black) that appeared in the original image, then found the closest replacement color (i.e., the replacement color with the smallest number). then did the same with the lightest color. then the next darkest, next lightest.
but i'm going to do it slightly differently this time. and i don't know how this image will come out looking.
if you look at the "first" green, closest to the left, and sort by smallest to largest:
you can see that these colors on the left are closest to the "first" green i've decided to work with. that might seem odd. i mean, #7F9800--> #00a94f are pretty close, but #A95400 is red. but that's just a difference in hue. really, #A95400 and #00a94f are very similar in lightness and saturation.
and this also calculates the number of times that color actually appears in the original image. that first specific green, #7F9800, only appears twice. but some colors, like actual black #000000, appear something like 46,000 times. and if you add all the numbers in the "frequency" column, it should exactly equal the sum of each replacement color (2088 ish x 502).
step 8: excel macro again. this one is complicated. basically it sorts that first "green" column (column E in my spreadsheet) from smallest to largest. then it adds each cell in the "frequency" column until it reaches or surpasses the blue cell above column E, which for this particular color is 2089. it copies those "original image" colors and their respective frequencies over to another sheet. for the color that surpassed 2089, it splits in two. then it deletes that column E. Then it makes sure "frequency" and "replacement color sum" still total. then it runs again on the new column E, until the whole spreadsheet is used up. and it generates something like:
[color from original image] [number of times that color appears] [replacement color, filled in]
and there's approximately 8000 lines of that.
i have the replacement colors in the order above. starting with vivid green, slowing transitioning to dark green, switching abruptly to bright pink, slowly transitioning to pale pink.
step 9: another excel macro. this one looks at original image broken down into hex codes, then looks at the generated list and replaces each [original] color with the replacement color, that exact number of times.
end result of these macros, following different "rules" of assigning replacement colors to original colors, is this:
which looks different, obviously. but it is the exact replacement colors, and same number of each replacement color, as the original up there.
at maximum efficiency, it took about 20 minutes to complete step 8 and 9. i have a vision of creating a series of these, each time "starting" with the next replacement color, and then making a gif of it. idk how to make gifs though
@magnetictapedatastorage seems up your alley
when all youve got is spreadsheets the whole world looks like data
*voice of someone craving even the tiniest sliver of control* i could make a spreadsheet,
Context, right!
This is a spreadsheet based on Settlement Statblocks for the Pathfinder RPG. I write it years ago and it still sees regular use and new users, so I'm rather proud of it.
https://docs.google.com/spreadsheets/d/106qx338ZyQgEwuo4ZR0grbFRpLC1gtBtabR8c90SVP8/edit?usp=drivesdk
(context for other readers, originally received the link with no message so I just responded asking for context - this is the context)
ooooooh RPG spreadsheet!!
we love a game spreadsheet. i've never played pathfinder so I'm not sure it will mean anything to me xD proud of you though!!!
Did anyone ever like attempt to document and compile the variations of Barney the dinosaur murder ballads across the elementary school system in the early 2000s. Like legit it has always fascinated me as a phenomena and I would love to know if there were like traceable regional variations or what.
Looking at the tags so far I’m kind of fascinated by how much the ‘I Love You’ parodies vary in their phrasing/murder weapons but the ‘Joy to the World’ ones are nearly identical
here is my collection of barney murder songs as they appeared in the notes and comments of this post at about 4 pm pacific 7/25, somewhat arbitrarily color coded to show similar memes. it appears that "baseball bat and 2x4" is the mode configuration but there is so much variation that that exact phrasing only makes up a small part of the set. if i knew more about statistical modeling i would turn this into some kind of data tree that shows which phrases are most likely to follow other phrases.
Hey - You Should Check Out My Character Sheets
I've been making character sheets for various roleplaying games over the past few years, and I've gotten pretty fucking good at it. I've got everything from small, simple, sheets...
...to complex beasts with clocks that tick and self-populating sections that pull from numbers you put in specific boxes.
I've got big, trad-like games with lots of pieces...
...and more abstract story-games.
And I include more than just character sheets! I include mission clocks, world-building tools...
... and safety sheets with a list of common safety tools!
So check out my play-kits - you might find that game you want to play just a little bit easier to do!
Can we find a sun god or diety from every timezone and make a map of them all?
We probably can, but the question is should we?
How else will ship captains know who to pray to when they circumnavigate the globe?
…Give me until the end of the weekend.
I actually had some unexpected free time today so I was able to create this a lot faster than I expected.
It isn’t perfect, but following the initial post I assigned each timezone one sun deity, so travelers know who they might pray to while exploring the world.
This was a lot of fun to create and to research mythologies from across the world, and I think I learned a couple of things doing so!
Well, there you have it folks. Safe travels.
"cozy game" maybe for YOU. I have spreadsheets
So many of y'all in notes chatting about loving spreadsheets but you're not even following the spreadsheet tag. Fakers.
about to make another spreadsheet. truly one of life's great joys
Fuck yeah
guy who makes a spreadsheet to figure out if his crush likes him back
When I was in my teens, I used to make an entire magic system with 360+ unique spells, ordered in magic schools and categories, and it boggles my mind that I basically reinvented DnD mechanics, even down to metamagic.
I wanted to make a wiki about it but I don't have time for it.
The point was to try to encompass every "superpower" I could think of into a magic system.
I even got lore related to it all, I'm pretty sure I'm gonna simply reuse it all for OC worldbuilding. Ngl the fun part was naming all the spells, symbols and coming up with the logic of it all.
and before you ask, you see all those individual cells in that spreadsheet ? They're all either a spell or a category. And they ALL have a paragraph attached to them describing what it does.
Not many people realized this but if you flip the Alchemy symbol upside down, you get a potion flask.
Also I think the old term of Alchemy is a bit too imprecise, in the new updated version it's called Substance (you can already see it already in the pixelated spreadsheet if you zoom in lmao)