Tsum Tsum Coin Stats (originally by sarahtsumtsum/sunshinegirl909)

	B	D	E	F	I	J	K	L	M	N	O	P	Q	R	S	T	U
1
2		HELP!			WIP	Protips for data entry
3					WIP	● Select a cell and hit Ctrl + Down Arrow to jump to the last filled cell in that chunk!
4		Hello and welcome! Here's a quick guide to what this spreadsheet is and does!			WIP	● Ctrl + Shift + V to "Paste values only"
5					WIP	● Thanks to kftgr2, we now have a form so you can submit data without even opening the spreadsheet! You can find it by going to "Form > Go to live form" in the menu up top.
6		This spreadsheet mainly exists because everyone loves maximizing their profits. More specifically, the meat of this sheet is about helping you to...			WIP	If you'd like to get a link you can reuse to have parts of the form pre-filled for you, (for example, when submitting a lot of runs with the same Tsum)
7					WIP	vvv this sheet should help!
8		- Use the coin bonus wisely			WIP	Tsum Tsum Coin Form Custom Link Generator
9	S	- Pick the best Tsums			WIP
10					WIP	Available rows in Raw Data:	1465
11		Also, see the thread on /r/TsumTsum for the latest updates about this spread sheet.			WIP	Available rows in TsumTrials:	2828
12		Help collect color data at the TsumTsum Background Color Sheet by koneko.teo/ShifterCat!			WIP
13		Quick Reference Chart by winniethegyu!			WIP
14					WIP
15		"Table" of "contents"			WIP
16					WIP
17			START
18
19		1: "?"			WIP
20			You are here. This is a designated help page. Read it for a summary of how to use the sheet!		WIP
21
22
23					WIP
24			THE DATA COLLECTION SHEETS		WIP
25					WIP
26		2: "Raw Data"		> > > > > > > > > > > >	A	B	C	D	E	F	G	H	I	J	K	L	M
27		#REF!	This sheet is where you enter data for games where you use the Coin Bonus. The main difference between this sheet and "TsumTrials" is that you will be recording two coin values: The coins before the bonus is applied (G), And your coins after the coin bonus is applied (H). You will also indicate 5>4 runs here, indicated by a Y in the "Used Other Boost" column (C).		Game	Username	Used Other Boost	JP Version	MyTsum	Skill (Out Of 6)	Coin Before Bonus	Coin After Bonus	Bonus	Coin Percentage	Net Gain/Loss	Avg Benefit	Gain/Loss Based on Avg Benefit
28					Calculated for you. Just a numerical ID for your entry. Currently not functioning beyond row 3997.	Enter your username in this column! In other words, the name you want your fun personalized stats to be attached to!	While this does say "other boost," a Y here is basically treated as a 5>4 (cost of 1800) when calculating your profit.	"Y" to indicate you used the JP version on this play, or just leave it blank otherwise.	The name of the Tsum you used. If you want to check exactly how to shorten it, check the list in TsumInfo+, column BI, "Recording as."	The skill level of the Tsum you used.	The coins you earned by the end of the round, but before the final score screen appears.	Your coins on the final score screen (coin bonus applied)	Calculated for you. This is the difference between your "Coin After Bonus" and "Coin Before Bonus." Also subtracts 1800 if you used 5>4. (?)	Calculated for you. The +% bonus you got, based on how big the difference was between your Coins Before (G) and Coins After (H). (10% to 5000%)	Calculated for you. This is the total coins you got (H) minus the cost of the bonuses you used. -500 for coin bonus -1800 for 5>4	Calculated for you. Total coins (H), minus pre-bonus coins (G), minus cost of boosts (-500, and -1800 if you used 5>4).	Calculated for you. If "Avg Benefit" (L) turned up positive, this says GAIN. Otherwise, it says LOSS.
29										The skill level of the Tsum you used.	#REF!	#REF!
30
31		3: "TsumTrials"		> > > > > > > > > > > >	A	B	There is no "other boost" column on this sheet. If you want to use 5>4, you'd be crazy not to use the coin boost along with it! ;)	C	D	E	F
32		#REF!	This sheet is where you enter data for plain-Jane games where you used no coin bonuses, no boosts, no nothin'. Just you and the Tsum. Alone. ;) If you want to use boosts like 5>4, you may as well use the coin boost along with it, which would make it more fitting for entry in the "Raw Data" tab. You only need to enter the singular final coin score here.		Game	Username		JP Version	MyTsum	Skill (Out Of 6)	Coins Earned
33					Numerical ID for your entry. Not calculated for you, so that the numbering isn't lost when sorting the data. Select two adjacent cells in the column, then drag the corner handle down to fill auto-incrementing numbers.	Enter your username in this column! In other words, the name you want your fun personalized stats to be attached to!		"Y" to indicate you used the JP version on this play, or just leave it blank otherwise.	The name of the Tsum you used. If you want to check exactly how to shorten it, check the list in TsumInfo+, column BI, "Recording as."	The skill level of the Tsum you used.	Your coins at the end of the round, or on the final score screen--they should be the same!
34										The skill level of the Tsum you used.	#REF!
35
36
37
38			THE DATA CRUNCHER SHEETS		WIP
39					WIP
40		4: "User Ranks" (coin bonus data)			WIP
41		#REF!	Summarizes who has been the luckiest and unluckiest of everyone who has been recording runs with the coin bonus. Not interactive, but fun stats to look at! Uses "Raw Data" only. Formerly named "WALL OF SHAME AND GLORY" but I felt like the name was too long.		WIP
42
43		5: "Play With Me" (coin bonus data)
44		Interactive Game Statistics		> > > > > > > > > > > >	B3	B4	B5	B6	B7	B8	B9	B10	B11	B12
45		#REF!	Enter your user name on this sheet for a summary of your coin bonus runs. Also has a section showing breakeven points. Uses "Raw Data" only.		Username	Current Ranking	No. of Games Played	Avg Coin Before Bonus	Avg Coin Bonus	Avg Net Gain	Expected Net Gain	Actual Return	Expected Return	Should I Use Coin Bonus?
46					ninatsum	Calculated for you. Your coin bonus ranking is straight from the WALL OF SHAME AND GLORY.	Calculated for you. How many games you've recorded in the sheet. Uses "Raw Data" only.	Calculated for you. How many coins you average without the coin bonus applied. Uses "Raw Data" only.	Calculated for you. Your average % coin bonus. Uses "Raw Data" only.	Calculated for you. Your average of column K in "Raw Data," I think.	Calculated for you. From your "Avg Coin Before Bonus" and the current bonus frequency data, calculates how much you should expect to average WITH the coin bonus.	Calculated for you. The % difference between your average pre-bonus coins (6) and actual average net gain (8).	Calculated for you. The % difference between your average pre-bonus coins (6) and the expected average net gain (9).	Calculated for you. If you have positive expected returns, then this will recommend that you do use the coin bonus.
47
48		Coin Bonus Distribution Table			WIP
49		#REF!	Shows how often each coin bonus occurs. Uses "Raw Data" only.		WIP
50		#REF!
51		Side by Side Comparison			WIP
52		#REF!	Compare the average coin gains of up to four Tsums, right next to each other! Uses "Raw Data" only.		WIP
53
54		6: "What's My Return?" (coin bonus data)
55		What is my return with NO boosts?		> > > > > > > > > > > >	B3	B4	B5	B6	B7	B8	B9
56		#REF!	Enter a theoretical average of coins per game, and find out how much the coin bonus could earn you with that average. Uses "Raw Data" only.		Coin Per Game	Expected Coin Bonus %	Expected Total Coin	Expected Net Gain	Expected Return	Expected Return in %	Use Coin Boost?
57					Enter a coin amount in the Coin Per Game block on the "Whats My Return?" tab to see expected returns based on it.	Calculated for you. Just the current overall average coin bonus %.	Calculated for you. Your coin amount (B3) multiplied by the current bonus % (B4).	Calculated for you. Your expected total coins (B5), minus the cost of using the coin bonus (500).	Calculated for you. Your expected net gain (B6) minus your non-bonus coins (B3). Or, how much of a difference in your income the coin bonus would make.	Calculated for you. Shows your expected return (B7) as a percentage of the original coins (B3).	Calculated for you. Recommends that you use the coin bonus if your returns are positive.
58
59		What is my return WITH boosts?		> > > > > > > > > > > >	B13	B14	B15	B16	B17	B18	B19	B20	B21	B22
60		#REF!	Similar, but also takes into consideration the costs of using the other boosts. Uses "Raw Data" only.		Coin Per Game	Additional Boost From 5->4	Additional Boost From Bubble	Additional Boost From Time	Additional Coin Boost	Total Coin Per Game	Expected Net Gain with Boosts	Expected Return	Expected Return in %	Use All These Boosts?
61		#REF!			Enter a coin amount in the Coin Per Game block on the "Whats My Return?" tab to see expected returns based on it.	Enter the amount of additional coins you'd expect the 5>4 boost to get you. Any non-zero value will count as usage of the 5>4 boost and will deduct 1800 from your net gain (B19).	Enter the amount of additional coins you'd expect the Bubble boost to get you. Any non-zero value will count as usage of the Bubble boost and will deduct 1000 from your net gain (B19).	Enter the amount of additional coins you'd expect the Time boost to get you. Any non-zero value will count as usage of the Time boost and will deduct 1000 from your net gain (B19).	Enter Y or N to indicate whether the coin boost would also be active. A Y here will deduct 500 from your net gain (B19).	Calculated for you. This is the sum of all your theoretical coins gained from playing AND using the boosts (sum of B13 to B16), and then multiplied by the current coin bonus if you indicated a Y in B17.	Calculated for you. This will be your total coins (B18) minus all the costs of the boosts. P	Calculated for you. Your expected net gain (B19) minus your non-bonus coins (B13). Or, how much of a difference in your income all these boosts would make.	Calculated for you. Shows your expected return (B20) as a percentage of the original coins (B13).	Calculated for you. Recommends that you use the coin bonus if your returns are positive.
62
63		7: "TsumInfo+" (tsum data)
64		Personalized Tsum Stats		> > > > > > > > > > > >	H	I	J	K	L	M	N	O	P
65		#REF!	In the purple section, enter your username in the large yellow box to see a list of your personal Tsums and your average for each. You may also choose to sort the data differently using the other yellow box next to "Sort by." - "Tsum" sorts them by name and level. - "L" sorts them by level and then by profitability (not average). - "5>4" puts 5>4 data at the top, and then sorts them by profitability. - "Safety" sorts them by their "*" rating. So basically sorted by profitability. - "AVG" sorts them by their coin averages. - "Lame/Your/Norm Profit" sorts them by profitability. Accounts for costs of boosts, and uses %bonus and breakeven data from the table at B14 to D22. The Tsums that make you the most coins will be at the top.		Tsum	L	5>4	Plays	Safety	AVG	Lame Profit	Your Profit	Norm Profit
66					Calculated for you. The names of all the Tsums that recorded under the chosen username in the yellow box.	Calculated for you. The levels of these Tsums.	Calculated for you. "Y" indicates data taken from 5>4 runs. Blank if it's just normal.	Calculated for you. Number of plays under this username, with this Tsum, at this level, and with or without 5>4 as indicated by column J.	Calculated for you. Gives you more stars if using the Tsum in this state is profitable enough. More detailed explanation in the the purple box at B4 in TsumInfo+.	Calculated for you. The average number of coins you've gotten with this Tsum. 5>4 runs will typically have higher averages, but that doesn't necessarily mean they're more profitable--that boost costs 1800 coins, after all.	Calculated for you. How profitable your Tsum is based on the pessimistic 30% coin bonus average. Boost costs are also accounted for.	Calculated for you. How profitable your Tsum is based on your personal coin bonus average. This will be blank if you haven't recorded any coin-boosted runs. Boost costs are also accounted for.	Calculated for you. How profitable your Tsum is based on the actual ~50% coin bonus average. Boost costs are also accounted for.
67
68		Detailed Tsum Stats		> > > > > > > > > > > >	AB2	V3	Y3	AB3	AE3	AJ3
69		#REF!	In the gray section, pick a Tsum in the central yellow box to see detailed stats for it--coin averages, play counts, and a list of the top 10 players with that Tsum--all split up by Tsum skill level. Also separated into two sections: "NORMAL" (black) for runs without the 5>4 boost, and "5>4" (red) for runs with it. With this, it's easier to see a breakdown of the Tsum's overall average, and also who you should ask for tips about playing a certain Tsum.		DETAILED TSUM STATS FOR....	And also...				Use 5>4?
70		#REF!			The Tsum in this box is the "primary" Tsum for which the most detailed stats will be displayed.	A Tsum in this box will appear in the graph only.	A Tsum in this box will appear in the graph only.	A Tsum in this box will appear in the graph only.	A Tsum in this box will appear in the graph only.	If this is any sort of n-word (or blank), this will use normal data for the non-primary Tsums in the graph. If this is any sort of y-word, this will use 5>4 data for the non-primary Tsums in the graph.
71		#REF!	These numbers for the primary tsum are also reflected in the line graph (black and red lines respectively). You can pick four other Tsums in the green, blue, purple, and red boxes and this will make their average data show up in the graph as well, so you can have a more visual comparison between them.
72		#REF!			WIP
73		#REF!	Just for fun, if you entered your username in the purple section, it will be highlighted if you show up in the top 10s here!		WIP
74					WIP
75					WIP
76		Top Tsums		> > > > > > > > > > > >	AO	AQ / AW	AR / AX	AS / AY	AZ	BA	AT / BB
77		#REF!	The blue section is the master list of all Tsums/levels recorded so far, sorted by their coin averages.		#	L	Tsum	AVG	Diff	%	Plays
78		#REF!			The ranking number.	The level of the Tsum.	The name of the Tsum.	The coin average of the Tsum.	If data exists for this Tsum in both normal and 5>4 runs, then this is the difference between the coin averages of those runs. (5>4 average minus normal average)	The difference (AZ) as a percentage of the normal (non 5>4) coin average of the Tsum (AR).	The number of plays recorded for this Tsum at this level.
79		#REF!	If you entered your name in the purple section, special highlighting will be applied to the Tsums based on what you've recorded. More detailed explanation in column BD of TsumInfo+. Tsums that are entered in the gray section will also have color-matching arrows to help point out where they are.		The ranking number.	The level of the Tsum.	The name of the Tsum.	The coin average of the Tsum.			The number of plays recorded for this Tsum at this level.
80		#REF!			WIP
81		Data Counts Per Tsum and Level			NAMES		LEVEL
82		#REF!	This plain white section is the master table of play counts for each Tsum. Tsums with low play counts are redder. For a list of them from least to most plays, you can find the link in the table's top right corner where it says "Click for count-sorted version."		Full	Recording as	1	2	3	4	5	6
83		#REF!			The full name of the Tsum as it appears in-game.	The shortened name of the Tsum for ease of recording in the spreadsheet.	Play counts for this Tsum at Skill Level 1.	Play counts for this Tsum at Skill Level 2.	Play counts for this Tsum at Skill Level 3.	Play counts for this Tsum at Skill Level 4.	Play counts for this Tsum at Skill Level 5.	Play counts for this Tsum at Skill Level 6.
84					WIP
85		8: "SxS Compare" (tsum data)			WIP
86		#REF!	An isolated copy of the side-by-side (SxS) Tsum comparison table from the "Play With Me" sheet. Uses "Raw Data" only. Formerly called "Compare MyTsums by Coin" but I felt like the name was too long.		WIP
87					WIP
88					WIP
89					(work in progress)
90			????? ????
91		?: ????? ??
92		#REF!	2016.11.03 - 2016.11.06
93		#REF!
94		#REF!
95		#REF!	2016.11.08 - 2016.11.10
96		#REF!
97		#REF!
98		#REF!	2016.11.11 - 2016.11.13
99		#REF!
100		#REF!