What is the shortest method to get most gold pieces (gp)

Here's that same data readied for public consumption. Thanks for the info!

Code:

Level 10 adventure "Garnet Demon Portal"							
All							
Lv	C	U	R	E	L	Tot	%
7	15	2	0	0	0	17	2,0 %
8	20	6	0	2	0	28	3,3 %
9	421	105	22	3	0	551	64,4 %
10	100	20	2	2	1	125	14,6 %
11	66	16	3	1	0	86	10,1 %
12	29	9	2	0	1	41	4,8 %
13	6	1	0	0	0	7	0,8 %
Tot	657	159	29	8	2	855	
%	76,8 %	18,6 %	3,4 %	0,9 %	0,2 %		
							
Treasure							
Lv	C	U	R	E	L	Tot	
7	0	0	0	0	0	0	
8	0	0	0	0	0	0	
9	103	24	6	2	0	135	
10	0	0	0	0	0	0	
11	0	0	0	0	0	0	
12	0	0	0	0	0	0	
13	3	1	0	0	0	4	
Tot	106	25	6	2	0	139	16,3 %

 

Here are the numbers combined with the previous run:

Code:

Level 10 adventure "Garnet Demon Portal"							
All							
Lv	C	U	R	E	L	Tot	%
7	25	5	0	0	0	30	1,6 %
8	49	10	2	2	0	63	3,3 %
9	936	250	56	9	2	1253	66,0 %
10	205	39	5	2	1	252	13,3 %
11	125	43	9	1	0	178	9,4 %
12	67	21	7	0	1	96	5,1 %
13	22	5	0	0	0	27	1,4 %
Tot	1429	373	79	14	4	1899	
%	75,3 %	19,6 %	4,2 %	0,7 %	0,2 %		
							
Treasure							
Lv	C	U	R	E	L	Tot	
7	0	0	0	0	0	0	
8	0	0	0	0	0	0	
9	208	49	13	2	2	274	
10	0	0	0	0	0	0	
11	0	0	0	0	0	0	
12	0	0	0	0	0	0	
13	8	4	0	0	0	12	
Tot	216	53	13	2	2	286	15,1 %

 

Sorry if I'm being dense but why don't you just add a column or columns to your spreadsheet where you perform the subtraction yourself? That seems the path of least resistance. If it bothers you visually just change the text colour to white or the column width to zero .

 

Better late than never
That was actually easy, yes. I didn't even know before what $ symbol means in Excel (like $G$46), am smarter now lol.


Anyway I've attached version 2 of Adventures.ods.
(items = drops - treasures)

Changes:
1) Fixed a typo that caused lvl 8 adventures' score to be calculated incorrectly.
2) Changed the formula so that it now also considers the number of available (epic and legendary) items from every level.
3) Added more drop data from many levels.

 

Alright: who has unlocked the lvl 18 adventures, you could post some drop data of the non-final battles

 

Working on it. No ETA promised.

 

Even 10x3 drops would give an estimate already
But also: after the expansion, all item lvl/adventure level drop ratios might have changed...

 

I've 51 drops recorded so far. About 60% level 18 items, but those can be several percentage points off in sample sizes this small. Got two Legendaries and zero Epics, vagaries of randomness.

 

Data shoule be the same as MM

 

Mauve Manticore adjusts to your Renown or something but has it been equivalent to level 18 exactly, we don't know. Getting pure level 18 drop data is valuable new knowledge.

 

Here's what I have so far:

Code:

Level 18 adventure "Secret of the Elder Mind" battle 1 "Carrion Trenches"
All							
Lv	C	U	R	E	L	Tot	
14	0	0	0	0	0	0	0,0 %
15	7	2	0	0	0	9	5,8 %
16	6	2	0	0	0	8	5,1 %
17	34	9	1	0	0	44	28,2 %
18	78	14	1	0	2	95	60,9 %
19	0	0	0	0	0	0	0,0 %
Tot	125	27	2	0	2	156	
	80,1 %	17,3 %	1,3 %	0,0 %	1,3 %		
							
Treasure							
Lv	C	U	R	E	L	Tot	
14	0	0	0	0	0	0	
15	0	0	0	0	0	0	
16	0	0	0	0	0	0	
17	11	4	0	0	0	15	
18	0	0	0	0	0	0	
19	0	0	0	0	0	0	
Tot	11	4	0	0	0	15	9,6 %

 

I have been using Salt Shaker (with Mail Of Succor for the priest) for grinding the battle. It doesn't always win, a bad starting draw can lead to a defeat.

 

@Jarmo, Do you just the non-final battles from the new three 18 level dungeons? Specific names of items drops, or just the level and rarity?

@Lord Feleran

Is there anything that suggests they have done this? I haven't had that much luck farming lately but I just assumed it was the law of large numbers.

 

Yup only 2 items chests.
No need for names but the distinction between treasures and equips is made. Otherwise ya, just level and rarity. You can check his table three posts above.

 

"Is there anything that suggests they have done this?"

Well, they have added more items. Even if the dropping algorithm is the same, the amounts and %s of items in each level is now a little different. So the chances of getting level x drop from lvl y adventure should have also changed a little.

Edit: If anyone wishes to help log the drops from different adventures, using these tools is the easiest way:

1. this: http://neoncat.x10.mx/util/collection-export.php
then this: http://neoncat.x10.mx/util/equipment-xref.php
and last step: copy the last output here (before and after farming): http://forums.cardhunter.com/thread...ethod-to-get-most-gold-pieces-gp.4246/page-10, look for Jarmo's Excel workbook.

 

I just calculated something I hadn't calculated before:
average non-treasure drop is worth 1.67 gold;
average treasure drop is worth 8.3 gold;
If in Kobold mines treasure drop rate is ~43% then average drop is worth ~4.52 gold there. 3 drops per adventure makes ~13.56 gold per adventure.
I can complete 1st map in Kobold mines 120 times per hour, that's 120*13.56=1627.2

1600 gold per hour for unlimited time, not bad.

Edit: Ah, it's not this easy. Average treasure drop is worth less in mines because epic and legendary treasures doesn't seem to appear in that special drop table.

 

Wow. On my old machine I can't load the map 120 times per hour. Maybe 70 or 80, tops. It slows to about 50 when I actually play some Firestorms and get mostly 1 round battles.

 

Yeah, how? I can beat the map in <30 seconds of clicking, but loading the map and clicking on the buttons to reload takes ~30 seconds by itself.

 

Animation speed 1000 and fast clicking through everything. Haven't timed a full hour session yet but the estimate is good enough. 20 completions took me 602 seconds.
Also, you need to sell the excess items later...... which can take time.

Edit: and since you probably won't sell all the items you got, it's even less gold per minute.

Edit2: I don't always farm Kobold mines. But when I do: (btw uncommon treasures give the most gold when farming)

 

Okay, I did my own experiment: 20 minutes of speed farming the first two levels of the mine maps. (This minimizes the time spent getting the adventure to reload, at the cost of occasionally hitting armor on the pigs.)

Maps completed: 32
Avg time per map: ~40 seconds (includes loading, switching, etc.)

All Items
Drops: 75c 15u 4r 2e
GP: 457
GP/hour: ~1370

Treasure
Drops: 38c 3u 2r 1e
GP: 386
GP/hour: ~1160
Do note that I dropped a single epic treasure, which may have skewed my results somewhat. I also dropped a second Risky Trickery, so the experiment has more than paid for itself already. ^_^