| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
1 | A3! D3! Act! Addict! Actors! Data! Digits! ...Dossiers? (The title is a work-in-progress...) | ||||||||
2 | Description | ||||||||
3 | Current Time: | 9/3/2025 10:29:03 | Wednesday | Today's Daily Practice: | Ouka High - Autumn Training Items | ||||
4 | This sheet is a repository for information about A3's characters and in-game events. The event timeline is more applicable to EN server players, but please note that all projections are unofficial estimates which will change! Note: Spoilers abound, so turn back if you don't want to know what's coming in EN's future... (May 2022: Haha what future) | ||||||||
5 | |||||||||
6 | Information | ||||||||
7 | Hello, Minion here! I'm a spreadsheet nerd who recently sold their soul to A3... This spreadsheet was initially an attempt to condense all the information I could get from the A3! wikis into a chart-friendly format (for random analysis of character traits/event patterns). One thing led to another and I ended up with this embarrasingly large spreadsheet (oh no I'm in too deep)... anyway, here's a short description of the tables you'll find here: | ||||||||
8 | Part 1: Information Repository (mostly from the A3 Yaycupcake Wiki, links to the wiki pages included wherever possible) My apologies in advance if the names I use are inconsistent with EN, the spreadsheet originally used JP translations! Character Information: ✿ Basic information for Mankai's members (main cast, ensemble cast and backstage crew). (For fanfic purposes, perhaps?) ✿ Play around with the sorting filters to compare heights/ages/occupations/eye or hair colour etc. ✿ Hex codes for each character's image colour and troupe colours are included, if you're interested in that sort of thing. ✿ Characters by birthday: The same sheet but arranged by birthday so you don't forget your best boy's special day! Play Information: ✿ Who played what in which play? Who were the leads? ✿ Wait... was that my best boy in a dress?! ✿ I really like this song... but which play was it from? Find your answers here! Character Pairs: What is this 24-cell by 24-cell monstrosity?! Glad you asked... Have a favourite pair of characters? Use these tables to check their: ✿ Earn Cash pairing name and conversations (linked to Yaycupcake Wiki) ✿ Honorifics, or the lack of them (otherwise known as what does X call Y and vice-versa) ✿ Duet songs (have they sung together or do I need to make my own remix...) Mankai Timeline: A horribly incomplete timeline of the Mankai's actors' lives pre-Mankai. Attempts to make sense of the game's timeline and numerous seasonal events are also included. This is perhaps the most speculative and incomplete sheet in the whole workbook, suggestions/screaming about how messed up the timeline is would be greatly appreciated, thank you! | ||||||||
9 | Part 2: Event Guide (Wiki information and my own predictions/math attempts. Please read with healthy skepticism.) Event List: Okay, I definitely want this card. No matter what... but when will the event come? Which events would I want to prepare for? Why am I so stressed out over a game?! As Citron would say, relapse, relapse~ (relax, relax)... Find answers for: ✿ Start and end dates for previous EN server events. ✿ Predicted start and end dates for future EN events, based on the JP server's event order. ✿ Event and Gacha SSR card characters for each event (cells colored by attribute for quick reference, links to wiki included) ✿ My attempt at figuring out which character is more gacha or event-friendly in terms of collecting SSR cards. ✿ Previous EN Event Results: I calculated the average event points/items per tier across all event types. Events are sorted in chronological order based on the Event List spreadsheet, and non-ranking events are omitted. Each tier has a color scale, and the highest point cutoff is the cell with the darkest color. Feel free to sort the tables, there are a few interesting trends to see here! This sheet might be updated in the future, but no promises so please check the Reddit page first (only cutoffs up to the top 40% are shown)! Kudos to the A3! subreddit moderators who collate the results! ✿ Previous JP Event Results: Essentially the same format as the previous sheet, but the data here is based on all JP events. Do note that JP's ranking uses individual ranks compared to percentage tiers to determine tier cutoffs! The tables here also include the Event SR characters for each event! This sheet also includes a JP version of the Event List and the only differences are in the event order for previous events + links to the JP event pages instead of EN. ✿ Previous JP Event Results (Combined): My attempt at combining the results from both event types by using the a conversion rate of 1 seasonal item = 100 points, since 11,500 items would get you the 1,150,000 point SSR reward. Previous EN Event Results (Combined) does the same thing for EN! (NEW!) Gacha and Event Reward Cards: ✿ I tracked down almost every card in the game, all the way up to JP! But WHY... to crunch numbers, mostly, and to curse the miserable number of event Chikage cards. Note that initial Friend Tryout and login gift cards aren't included. ✿ Every cell is linked to the wiki entry for the corresponding card, and hovering your cursor over linked cells will show you a preview with the unbloomed art as the thumbnail. ✿ Added together with these sheets: Conditional formatting to automate some of the tables, so be careful if you download a copy of this sheet for yourself! Credits to @_rfeb (on Instagram) for their help in figuring out the formatting! ✿ Gacha Cards (Event Boost Only): Excludes the non-event gachas, and shows my attempt at making a character meta list... all hail Kazu? Note: As of May 2022, this sheet is retired since event boosts only apply during an event's original run and with all the other servers gone... Just ask me if you want to see the sheet and I'll update it for you~ Event Calendar: ✿ A prettier version of the Event List, currently updated with event predictions for 2021, as well as character birthdays! Note that the most recent predictions will only be reflected in the Event List sheet. ✿ Blank 2021 Calendar: Exactly what it says on the tin. Feel free to make a copy of this Mankai-themed calendar for yourself! Team-Building Information: My personal cheatsheet for teambuilding, collated from various sources. Need that final boost to pass an Encore? ✿ The infographic many players swear by, Yaycupcake's optimal link skills are the bread and butter of your event teams. Try to use SR and SSR cards to stack link skills! ✿ If you like numbers, u/Misakisa's unbelievably comprehensive event guide has you covered. I highly recommend giving the website visit as it details a variety of ways to efficiently play events. The tables here are what I use for finetuning before hitting that "Start Show" button. ✿ u/Noscos' innovative tierlist helps more with future planning: Which cards should you aim for if you want a really strong team? Use this tierlist together with the Event List for more informative planning. ✿ A picture showing all the birthday cards with seasonal boosts from April 2021 to June 2022. ✿ Lastly, my attempt at ranking the characters by their "metaness" according to the tierlist. Take this with a pinch of salt. Link Skills by Character: An extremely messy attempt at listing every single link skill in the game by character. Skills are roughly sorted by the number of characters involved as well as skill attribute. I highly recommend using the Team-Building Information sheet to find the best link skills before using this sheet to finetune your teams (before the event, not when a show is expiring)! Inventory Tracker Template: My personal method for tracking my card inventory at a glance. The more green/blue you see, the better. Might help with planning your card wishlist... The tracker also automatically counts the number of cards you own, so you don't need to keep fiddling with the in-game filters. Additionally, this tracker's structure was actually adapted from my original tracker for another game, so feel free to make a copy of this sheet for your own purposes or other games! 26/06/2021 Update: I've revamped the spreadsheet such that all you need to do is edit the cells with the number codes (e.g. 1-2-4-0), and the spreadsheet will handle all other calculations/formatting automatically! Rank Tracker: Enjoying your time in ranking hell? Use this rank tracker to keep tabs on your progress! Rank, event points and items are tracked separately for easier reading. Currently the template has a few dummy values to show how the charts look like. Phew, that's pretty much all I have for now. The sheet's contents will be updated every now and then to account for new events, and perhaps some new features might be added someday... if you made it this far, thank you for reading and have fun! | ||||||||
10 | If you liked this spreadsheet, check this out: ✿ A3! Budget Calculator: A supercharged version of the Event List, with a built-in expenditure tracker that can help you budget your gems and predict how many gems you'll have when the event you're waiting for comes to EN! ✿ Character Birthday Calendar: Add this calendar to your Google account so you'll never miss your best boy's birthday again! A downloadable version can be found here! ✿ A3! Resources and Card Art: This folder contains all the A3!-related spreadsheets and edits that I've created so far, as well as shortcuts to other useful A3! resources. ✿ I've linked most of my work to my Carrd for easier reference! | ||||||||
11 | Feedback is always appreciated, or you could just say hi using these: ✿ Discord: @OrdinaryTwilight#3488 ✿ Reddit: u/OrdinaryTwilight ✿ Instagram: @ordinarytwilight ✿ Twitter: OrdinaryTwil More stuff can be found on my Carrd! | ||||||||
12 | |||||||||
13 | Acknowledgement | ||||||||
14 | Thanks to everyone who runs/contributes to the A3 Yaycupcake/Fandom wikis, this sheet wouldn't have been possible without the information there! Kudos to the translators too for making JP content accessible to those who can't read Japanese! Thanks to r/A3ActorsinTraining for all the feedback on the earlier versions of this spreadsheet! Special shoutout to u/a_rietty for being a fellow A3 spreadsheet nerd, and thanks for all the suggestions! | ||||||||
15 | |||||||||
16 | References (JP spoilers in sources marked with *) | ||||||||
17 | A3! EN Event Points Tracker (Seriously amazing spreadsheet by Cami and Ritsu) | ||||||||
18 | A3! EN Server Timeline (Much prettier Event List by Arietty)* | ||||||||
19 | Character Meta Tierlist by u/Nocsos | ||||||||
20 | EN Borders by A3! Subreddit Moderators | ||||||||
21 | EN Event List by Yaycupcake | ||||||||
22 | EN Gacha List by Yaycupcake | ||||||||
23 | Event Guide by Yaycupcake | ||||||||
24 | In-depth Event Guide Website by u/Misakisa | ||||||||
25 | JP Event List by Yaycupcake* | ||||||||
26 | JP Gacha List by Yaycupcake* | ||||||||
27 | Official EN A3! Twitter | ||||||||
28 | Official JP A3! Twitter* | ||||||||
29 | |||||||||
30 | |||||||||
31 | |||||||||