SSM Tracker

	A	B	C	D
1	Hello! Welcome to my SSM tracker.
2	My IGN and reddit username is MikotoMaki. I think I made this when I returned from quite a long hiatus from SSM, because I was so confused about the game and wanted to be more systematic.
3	It was very barebones at first. It was originally just a card tracker since I always lost track of which cards I could use to upgrade (yeah, this was made before locking cards was a thing lol), but over time I slowly added all of the stuff you see now.
4	Anyway, you guys probably aren't interested in that lol so I'll just get to it.
5
6	First off, there are also notes in cells in the sheets themselves. If you need guidance, they might be able to help, so check them out first after reading this sheet! :)
7	*Columns/rows with headers colored purple are user input (should be edited by you), black/white cells may contain needed values or formulas and you are advised to edit them carefully or not at all
8
9	Sheet	Description	Action Item
10	Cards	All cards in the group are R99	N/A; indicator only	Sample
11		All cards in the group are R	N/A; indicator only	Sample
12		R card	N/A; indicator only	Sample
13		2 or more S5 cards (same group + member)	can be upgraded to R	Sample
14		2 or more A5 cards (same group + member)	can be upgraded to S	Sample
15		2 or more S cards (same group + member)	can be powered up & upgraded	Sample
16		2 or more A cards (same group + member)	can be powered up & upgraded	Sample
17		S card with 2 A cards (same group + member)	can be powered up & upgraded	Sample
18		S card with 1 A card (same group + member)	can buy A-card selector	Sample
19
20		To add a card: - Insert the row where you want to put it - Fill in the other details (Group, Card, Rank, Stars, Theme) - Click the "No" cell of the previous row - Click the blue corner then drag it until AFTER the added row (important!!) to fix the numbers To delete a card, just delete the row and then do the third step to fix the numbers again (there'll be #REF! errors otherwise) * Sometimes the color of the rows will get messed up after dragging the values. That's okay, no need to do anything, it'll fix itself once you refresh or change some values
21
22	Stats	All cards in the group are R99		Sample
23		Group is part of your Top 5		Sample
24		All cards in the group are R		Sample
25
26		Provides some stats and overview; has data on the ff: - How many members and songs each group has - Which groups are better to upgrade for SSL - If you've upgraded a group to R - How far you've upgraded your R groups - What fodder to feed your cards *It is possible to sort them by index, group name, efficiency, etc if you want. Just right click the column letter and click "Sort sheet A-Z/Z-A"
27
28	Challenge Calculator	Calculates the stats you need to beat a challenge, assuming you get a full Super Perfect play This is a general guide ONLY. It does not take any bonuses or good/bad card rotations into account. Credits to u/Clearbluecrystal, I followed their scoring system from this post: https://www.reddit.com/r/SuperstarJYPNation/comments/4xaijn/scoring_system_analytical/
29
30	Fodder	Used for "Stats" sheet. This is to set which fodder cards you want to feed for cards under the specified "tiers". You can change the tiers to whatever you want, it'll automatically change to what you put. Ex. feed B1 cards to R31-R50, S5 cards to R81-R90, etc (Note: All cards under the first tier will automatically get C1 as fodder value)
31
32	Changelog	List of changes made to the spreadsheet
33
34	Formulas (Hidden)	Where the values get computed; used by other sheets
35
36	Groups (Hidden)	Used for "Challenge Calculator" sheet. Just a list of all the groups in the game. Hid it because it doesn't really do anything except list all the groups' names in ascending order.
37
38	Songs (Hidden)	Used for "Stats" sheet. Just a list of all the songs in the game.
39
40	If you have comments, suggestions, and/or clarifications, feel free to drop a comment on the thread, thanks! ^^
41