Gnomes EXP Distribution

	A	B	C	D	E	F	G	H	I	J	K	L	M
1		Card	Combat	Assassin	Speed	Awareness	Willpower	Manipulation	Intelligence	Defense	Total Exp	Exp/Hr
2		Battle Weights	8	9	8	10	8	9	8	8	68
3	Insert your current card stats->		11865	10486	10308	9603	15751	14054	10245	15088	97,400	117	<-insert your pet staking EXP per hour

4		Current Ratio	0.1218	0.1077	0.1058	0.0986	0.1617	0.1443	0.1052	0.1549
5		Ideal Ratio	0.1176	0.1324	0.1176	0.1471	0.1176	0.1324	0.1176	0.1176		Calculated Current Level:	44
6		Ideal EXP based on Total EXP	11,459	12,891	11,459	14,324	11,459	12,891	11,459	11,459
7		Ideal as Percent of Current EXP	96.58%	122.94%	111.16%	149.16%	72.75%	91.73%	111.85%	75.95%		Created and maintained by @Zelazni (ekuqw.wam). The latest version can be found here:
8		Equivalent Total EXP	100853	79228	87618	65300	133884	106186	87083	128248		https://docs.google.com/spreadsheets/d/1Tu6ZiGSjumykD4Sim-wpKCKOk0iFHMTsw9fOjP8sgWg/edit?usp=sharing
9
10		Level Attained at Ideal Ratio	45	40	42	36	52	46	42	51		CREDIT TO @GNOliver for the spreadsheet I extended for this update:
11												https://docs.google.com/spreadsheets/d/1g1MuE3hx--oUaRHH2hwFElWHmf_n9MtESFh5wCbBUcw/edit#gid=0
12
13		Select Skill to Use as Baseline:	Manipulation		This is the skill you will align your other skills to match. Typically, it should be the highest skill but you can choose, especially if one skill is particularly high it might not make sense to use that as a baseline to match everything else to; at least not initially. Skills already higher than the ideal ratio will have 0 EXP to apply.
14
15			Combat	Assassin	Speed	Awareness	Willpower	Manipulation	Intelligence	Defense
16		Hours of EXP to Apply	5	30	19	51	0	0	19	0	New Total Exp	Total Time	Level When Reached
17		New Ratio	0.1113	0.1251	0.1120	0.1391	0.1407	0.1256	0.1114	0.1348	111,908	124	47
18		Targeted Variance from Ideal	5.44%	5.50%	4.82%	5.39%	-19.64%	5.11%	5.30%	-14.60%	65.80%	Total Variance
19
20	UPDATED 3/5/2022 to account for changes to weights. Thanks to @KenDoG for providing some feedback and pointing out the wrong values I had! For Now, copy this spreadsheet into your own Google Drive environment to edit it. You should only NEED to modify the blue fields in row 3 and the blue skill dropdown selector. Please let me know if you have any thoughts on how this could be improved! Zelazni on Telegram or Zelazni#9797 on Discord! This Table will calculate the best changes to make to your Gnome to reach an ideal balance of PvP Skills. Entering your card's current stats and EXP/hour earned from pet staking (in the blue fields above) will allow you to see which skills are too high and which are too low. Because EXP can't be removed from a skill, the only way to re-align your skill EXP is to add it to the skills that are below the ideal ratio. Doing this, of course, changes the ratios further. This table attempts to guide you to the hours of pet staking EXP (the most prevalent passive EXP source) that should be applied to each skill. Furthermore, because you might have a situation where one skill is too high (relative to the ideal) to reasonably align the rest of your skills to, you can select different skills to use as your baseline. You can use the "Ideal as Percent of Current EXP" and "Level Attained at Ideal Ratio" calculations to help decide which skill to select as your baseline. Ideally, start with the skill that has the lowest "Ideal as Percent of Current EXP" value. If the reccommended EXP to apply when choosing that skill is too high then try the next lowest and continue until you find a configuration that is reasonable to reach. NOTE: If your gnome's current level is higher than the calculated level that means that you likely have EXP applied to a non-PVP skill. That EXP is basically wasted when it comes to the Gnome's PVP success as it will cause it to battle higher level opponents which will likely have higher skills. If you have too much EXP assigned to non-PVP skills, consider focusing the tuning of your gnomes on cards with skills dedicated to PVP. Original Instructions from @GNOliver: Your goal is to bring all "changes" closer to zero (light green). You can only add Exp, so you start by applying hours to the highest "change", then to the second highest, and so on, usually adding fewer each time, but not always. The total variance is the sum of all absolute values of "changes" so the lesser the better and it is a general indicator of how close you are from the perfect ratio. After you reach all light greens (<10%) you can try to minimize the total time by removing hours from attributes that are negative, but sometimes at the cost of total variance.
21
22	DON'T Edit below this line unless you know what you're doing!
23		Combat
24		Normalized EXP	100853	Deviation of Target:		96.58%
25		Lesser of Current EXP or Ideal EXP	11865	10486	10308	9603	11865	13348.125	10245	11865	89585.125
26		Ideal EXP	11865.0	13348.1	11865.0	14831.3	11865.0	13348.1	11865.0	11865.0
27		EXP Needed	0.0	2862.1	1557.0	5228.3	0.0	0.0	1620.0	0.0
28		Hours needed	0	24	13	45	0	0	14	0	96.0000
29
30		Assassin
31		Normalized EXP	79228	Deviation of Target:		122.94%
32		Lesser of Current EXP or Ideal EXP	9320.888889	10486	9320.888889	9603	9320.888889	10486	9320.888889	9320.888889	77179.44444
33		Ideal EXP	9320.9	10486.0	9320.9	11651.1	9320.9	10486.0	9320.9	9320.9
34		EXP Needed	0.0	0.0	0.0	2048.1	0.0	0.0	0.0	0.0
35		Hours needed	0	0	0	18	0	0	0	0	18.0000
36
37		Speed
38		Normalized EXP	87618	Deviation of Target:		111.16%
39		Lesser of Current EXP or Ideal EXP	10308	10486	10308	9603	10308	11596.5	10245	10308	83162.5
40		Ideal EXP	10308.0	11596.5	10308.0	12885.0	10308.0	11596.5	10308.0	10308.0
41		EXP Needed	0.0	1110.5	0.0	3282.0	0.0	0.0	63.0	0.0
42		Hours needed	0	9	0	28	0	0	1	0	38.0000
43
44		Awareness
45		Normalized EXP	65300	Deviation of Target:		149.16%
46		Lesser of Current EXP or Ideal EXP	7682.4	8642.7	7682.4	9603	7682.4	8642.7	7682.4	7682.4	65300.4
47		Ideal EXP	7682.4	8642.7	7682.4	9603.0	7682.4	8642.7	7682.4	7682.4
48		EXP Needed	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
49		Hours needed	0	0	0	0	0	0	0	0	0.0000
50
51		Willpower
52		Normalized EXP	133884	Deviation of Target:		72.75%
53		Lesser of Current EXP or Ideal EXP	11865	10486	10308	9603	15751	14054	10245	15088	97400
54		Ideal EXP	15751.0	17719.9	15751.0	19688.8	15751.0	17719.9	15751.0	15751.0
55		EXP Needed	3886.0	7233.9	5443.0	10085.8	0.0	3665.9	5506.0	663.0
56		Hours needed	33	62	47	86	0	31	47	6	312.0000
57
58		Manipulation
59		Normalized EXP	106186	Deviation of Target:		91.73%
60		Lesser of Current EXP or Ideal EXP	11865	10486	10308	9603	12492.44444	14054	10245	12492.44444	91545.88889
61		Ideal EXP	12492.4	14054.0	12492.4	15615.6	12492.4	14054.0	12492.4	12492.4
62		EXP Needed	627.4	3568.0	2184.4	6012.6	0.0	0.0	2247.4	0.0
63		Hours needed	5	30	19	51	0	0	19	0	124.0000
64
65		Intelligence
66		Normalized EXP	87083	Deviation of Target:		111.85%
67		Lesser of Current EXP or Ideal EXP	10245	10486	10245	9603	10245	11525.625	10245	10245	82839.625
68		Ideal EXP	10245.0	11525.6	10245.0	12806.3	10245.0	11525.6	10245.0	10245.0
69		EXP Needed	0.0	1039.6	0.0	3203.3	0.0	0.0	0.0	0.0
70		Hours needed	0	9	0	27	0	0	0	0	36.0000
71
72		Defense
73		Normalized EXP	128248	Deviation of Target:		75.95%
74		Lesser of Current EXP or Ideal EXP	11865	10486	10308	9603	15088	14054	10245	15088	96737
75		Ideal EXP	15088.0	16974.0	15088.0	18860.0	15088.0	16974.0	15088.0	15088.0
76		EXP Needed	3223.0	6488.0	4780.0	9257.0	0.0	2920.0	4843.0	0.0
77		Hours needed	28	55	41	79	0	25	41	0	269.0000
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100