My first post on leaflet turned out to be about MygoAve and spreadsheet

I'm considering moving away from Notion because who wouldn't? I don't usually write a long-form post or blog, but since leaflet's right here and I can easily set up one with my bsky account I decide to mess around. It's pretty fun seeing how versatile leaflet is actually!

I don't have anything to write about as of now, so maybe I'll just post something silly I made on the weekend.

Anon Tokyo conversations database

I got into Bang Dream Our Notes closed beta and poured most of my interests into the newest minigame: Anon Tokyo. So far, it seems to be a replacement of Area Conversations in Bang Dream GBP which kind of disappoints me, but I invested in Anon Tokyo nonetheless!

I found the conversations between characters in Anon Tokyo hilarious and as a collector/perfectionist type of casual gamer I couldn't help but wished there'd be a repository of conversations in-game. The biggest let-down of my life 😞 เราคงต้องเริ่มที่ตัวเอง I decided to take matters into my own hands and created a very basic spreadsheet consisted of just 5 columns: Employee, Position, Customer, Line1 and Line2. The 6th column is a basic IF formula that displays Line1 for monologues and Line1&Char(10)&Line2 for dialogues.

It started with manual input so I could've used just 1 column for both lines, but it's always better to be cautious just in case!

Thanks to Katzereithe and anonsbelle on twitter, I got hold of all conversations in Anon Tokyo mode in Bang Dream Our Notes. The range is small with just 110 rows (30 monologues and 80 dialogues) but it's near impossible to collect all of them on my own during the closed beta.

After it's completed I started sharing conversations I like, but long strip of image always displays badly on any SNS. I was frustrated enough to create a new sheet right on the public file lmao

Conversation reader

Creating a reader with a spreadsheet is just forcing a square peg through a round hole, but it's all I have 🤷 I'm highly familiar with these applications though since I worked in an industry that doesn't allow fun on a company laptop, yet I INSISTED to brighten my workspace. But I digressed. Creative spreadsheet is always 80% formatting, 15% XLOOKUP and 1% IFNA. Luckily this project is tiny so this much is sufficient.

The most time-consuming process is probably finding the character avatars, cropping them and inserting cropped images into the sheet 1-by-1 😭

In order to create some visual-appealing effect I created a CHARACTERS table, listing attributes like their avatars and colour codes. The reader simply uses character's name to look up the table and return matched values. The character's colour strip is TOTALLY UNCESSARY but I really love sparklines. The formula is elegant for the use case considering how inconvenient conditional formatting is.

=IFNA(SPARKLINE(1,{"charttype","column";"color",INDEX(Characters,MATCH($D$4,Characters[Character],0),2)}))

this looks up character's colour code then feeds the hex code to sparkline in-cell chart.

I'm quite certain INDEX+MATCH is now considered obsolete. Please bear with my barbaric formula.

More cosmetic adjustment, more conditional formatting to switch background colours between Sky and Maroon based on the displayed band (again, totally unnecessary but I like it), and the reader is finished.

Too bad Google Sheet doesn't support concurrent interactions with multiple users; however, the content in the sheet is not mine so the solution is easy: everyone, just duplicates the sheet and does whatever you want!

Anon Tokyo Conversations

My original post on bsky:

View post on Bluesky