[Spreadsheet] A Pocket Manual For Upgrading Your Heroes (Gemmers Edition!)

Hey guys, I made this spreadsheet to see how many gems were required for hero upgrades! This was requested by joebates26 on the Farmer's Edition of upgrading heroes. This guide is broken down into Barbarian King, Archer Queen, and Combined below, due to size restrictions. Enjoy:)

Quote:

---

Originally Posted by joebates26

Could you do a Excel sheet of how many gems would be needed per upgrade for DE and Down Time?

---

You can find the Farmer's Edition here! http://forum.supercell.net/showthrea...59#post1281659

Barbarian King.

Level	Upgrade Cost (DE)	Upgrade Cost (Gems)	Upgrade Time	Upgrade Time (Gems)
Level 1	10,000	600	-	-
Level 2	12,500	667	0.5d	134
Level 3	15,000	733	1d	260
Level 4	17,500	800	1.5d	321
Level 5	20,000	867	2d	383
Level 6	22,500	933	2.5d	445
Level 7	25,000	1,000	3d	506
Level 8	30,000	1,133	3.5d	568
Level 9	35,000	1,267	4d	630
Level 10	40,000	1,400	4.5d	691
Level 11	45,000	1,533	5d	753
Level 12	50,000	1,667	5.5d	815
Level 13	55,000	1,800	6d	876
Level 14	60,000	1,933	6.5d	938
Level 15	65,000	2,067	7d	1,000
Level 16	70,000	2,200	7d	1,000
Level 17	75,000	2,333	7d	1,000
Level 18	80,000	2,467	7d	1,000
Level 19	85,000	2,600	7d	1,000
Level 20	90,000	2,733	7d	1,000
Level 21	95,000	2,867	7d	1,000
Level 22	100,000	3,000	7d	1,000
Level 23	105,000	3,133	7d	1,000
Level 24	110,000	3,267	7d	1,000
Level 25	115,000	3,400	7d	1,000
Level 26	120,000	3,533	7d	1,000
Level 27	125,000	3,667	7d	1,000
Level 28	130,000	3,800	7d	1,000
Level 29	135,000	3,933	7d	1,000
Level 30	140,000	4,067	7d	1,000
Level 31	145,000	4,200	7d	1,000
Level 32	150,000	4,333	7d	1,000
Level 33	155,000	4,467	7d	1,000
Level 34	160,000	4,600	7d	1,000
Level 35	165,000	4,733	7d	1,000
Level 36	170,000	4,867	7d	1,000
Level 37	175,000	5,000	7d	1,000
Level 38	180,000	5,133	7d	1,000
Level 39	185,000	5,267	7d	1,000
Level 40	190,000	5,400	7d	1,000

Archer Queen.

Level	Upgrade Cost (DE)	Upgrade Cost (Gems)	Upgrade Time	Upgrade Time (Gems)
Level 1	40,000	1,400	-	-
Level 2	22,500	933	0.5d	134
Level 3	25,000	1,000	1d	260
Level 4	27,500	1,067	1.5d	321
Level 5	30,000	1,133	2d	383
Level 6	32,500	1,200	2.5d	445
Level 7	35,000	1,267	3d	506
Level 8	40,000	1,400	3.5d	568
Level 9	45,000	1,533	4d	630
Level 10	50,000	1,667	4.5d	691
Level 11	55,000	1,800	5d	753
Level 12	60,000	1,933	5.5d	815
Level 13	65,000	2,067	6d	876
Level 14	70,000	2,200	6.5d	938
Level 15	75,000	2,333	7d	1,000
Level 16	80,000	2,467	7d	1,000
Level 17	85,000	2,600	7d	1,000
Level 18	90,000	2,733	7d	1,000
Level 19	95,000	2,867	7d	1,000
Level 20	100,000	3,000	7d	1,000
Level 21	105,000	3,133	7d	1,000
Level 22	110,000	3,267	7d	1,000
Level 23	115,000	3,400	7d	1,000
Level 24	120,000	3,533	7d	1,000
Level 25	125,000	3,667	7d	1,000
Level 26	130,000	3,800	7d	1,000
Level 27	135,000	3,933	7d	1,000
Level 28	140,000	4,067	7d	1,000
Level 29	145,000	4,200	7d	1,000
Level 30	150,000	4,333	7d	1,000
Level 31	155,000	4,467	7d	1,000
Level 32	160,000	4,600	7d	1,000
Level 33	165,000	4,733	7d	1,000
Level 34	170,000	4,867	7d	1,000
Level 35	175,000	5,000	7d	1,000
Level 36	180,000	5,133	7d	1,000
Level 37	185,000	5,267	7d	1,000
Level 38	190,000	5,400	7d	1,000
Level 39	195,000	5,533	7d	1,000
Level 40	200,000	5,667	7d	1,000

Combined. (BK+AQ)

Hero Level	Gems for DE	Gems for Time	Gems Total
Level 1	2,000	-	2,000
Level 2	1,600	268	1,868
Level 3	1,733	520	2,253
Level 4	1,867	642	2,509
Level 5	2,000	766	2,766
Level 6	2,133	890	3,023
Level 7	2,267	1,012	3,279
Level 8	2,533	1,136	3,669
Level 9	2,800	1,260	4,060
Level 10	3,067	1,382	4,449
Level 11	3,333	1,506	4,839
Level 12	3,600	1,630	5,230
Level 13	3,867	1,752	5,619
Level 14	4,133	1,876	6,009
Level 15	4,400	2,000	6,400
Level 16	4,667	2,000	6,667
Level 17	4,933	2,000	6,933
Level 18	5,200	2,000	7,200
Level 19	5,467	2,000	7,467
Level 20	5,733	2,000	7,733
Level 21	6,000	2,000	8,000
Level 22	6,267	2,000	8,267
Level 23	6,533	2,000	8,533
Level 24	6,800	2,000	8,800
Level 25	7,067	2,000	9,067
Level 26	7,333	2,000	9,333
Level 27	7,600	2,000	9,600
Level 28	7,867	2,000	9,867
Level 29	8,133	2,000	10,133
Level 30	8,400	2,000	10,400
Level 31	8,667	2,000	10,667
Level 32	8,933	2,000	10,933
Level 33	9,200	2,000	11,200
Level 34	9,467	2,000	11,467
Level 35	9,733	2,000	11,733
Level 36	10,000	2,000	12,000
Level 37	10,267	2,000	12,267
Level 38	10,533	2,000	12,533
Level 39	10,800	2,000	12,800
Level 40	11,067	2,000	13,067

Quote:

---

Originally Posted by rsiro

Hey guys, I made this spreadsheet to see how many gems each hero level takes in order to upgrade! This was requested on my previous thread about upgrading heroes by joebates26.

Uploading...

---

Thanks a bunch. I appreciate this information. Kudos

Well done 🍻