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

I ended up clipping, parsing, and pasting before leaving each adventure to help preserve data integrity. Once I got into a rhythm it took about 5-10 seconds per update.
My crashes usually occur when I select "Return To Map", but I lost a few drops due to lockups on the Collect Loot page after the treasure dropped. I also lost some because I forgot to turn 'verbose' back on after a crash. I sometimes ran into a problem in chrome where the data could be highlighted, but could not be copied to the clipboard. Ctrl-c still worked in other programs when this happened.
My old 32-bit vista laptop is not a prime test-bed for this, and I expect (hope?) newer and more robust machines will perform better. I haven't tried a lengthy run in FF, so I'll probably give that a shot.
I look forward to seeing the excel spreadsheet in action!

 

Ok, thanks for the blow-by-blow! Sounds like a bit of a bother. I'm even more thankful for your diligent data collecting after hearing the pains you've needed to take.

Might I suggest another way? The new "reverse merge" option of Neoncat's item data xref tool makes it easy to
1) export your inventory before a grinding session
2) export it again after the session
3) copy the two count columns side-by-side and add a simple subtraction column
4) filter the new column for values > 0
Voilà! A sum total of the run, works even when you got some item you never had before (because the "reverse merge" export already has a line for each possible item).

Best of all, you can keep the verbose mode off during the run to not fill the meagre Flash memory allocation with the ballooning log and avoid the related crashes (grey exclamation mark within a circle).

The only thing to watch out for is to not fight any other battles during the session than the ones you want to include in the data, as there's no way to filter them out based on the full inventory exports alone.

All in all, I think this method is a lot more robust and trouble-free than using the catch-them-as-they-drop-verbose-log way.

 

This sounds like the option I was hoping for! I really don't do spreadsheets, but this sounds pretty easy to figure out.
I just did 3 runs of 1-4 on Garnet Demon Portal, and the log was 146,920 lines long. This could soon get to be a problem, I suppose.

 

Here's your data, newly formatted with the new Excel tool. I'll post the tool once I've tested it with another batch of loot data.

Level 4 adventures "Dungeon of the Lizard Priest" and "Ruby Demon Portal"

Code:

All							
Lv	C	U	R	E	L	Tot	%
1	19	6	2	0	0	27	5,5 %
2	44	3	1	0	0	48	9,8 %
3	152	40	1	0	0	193	39,5 %
4	53	23	2	1	1	80	16,4 %
5	83	30	1	2	0	116	23,7 %
6	20	2	0	0	0	22	4,5 %
7	3	0	0	0	0	3	0,6 %
Tot	374	104	7	3	1	489	
%	76,5 %	21,3 %	1,4 %	0,6 %	0,2 %		
							
Treasure							
Lv	C	U	R	E	L	Tot	
1	5	3	2	0	0	10	
2	16	0	0	0	0	16	
3	0	0	0	0	0	0	
4	0	0	0	0	0	0	
5	40	15	0	1	0	56	
6	0	0	0	0	0	0	
7	0	0	0	0	0	0	
Tot	61	18	2	1	0	82	16,8 %

 

Formatted:

Code:

All							
Lv	C	U	R	E	L	Tot	%
9	9	1	0	0	0	10	1,0 %
10	14	3	0	0	0	17	1,7 %
11	32	5	1	1	0	39	3,9 %
12	294	70	20	2	0	386	38,6 %
13	338	71	11	3	1	424	42,4 %
14	23	26	4	0	0	53	5,3 %
15	54	7	6	1	0	68	6,8 %
16	2	1	0	0	0	3	0,3 %
Tot	766	184	42	7	1	1000	
%	76,6 %	18,4 %	4,2 %	0,7 %	0,1 %		
							
Treasure							
Lv	C	U	R	E	L	Tot	
9	9	1	0	0	0	10	
10	0	0	0	0	0	0	
11	0	0	0	0	0	0	
12	0	0	0	0	0	0	
13	120	32	3	1	1	157	
14	0	0	0	0	0	0	
15	0	0	0	0	0	0	
16	0	0	0	0	0	0	
Tot	129	33	3	1	1	167	16,7 %

 

Time to format the data with the Excel and Neoncat's CH item xref tools starting from the raw data: 10 minutes. That's the advantage of automated tools.

 

Here's the Excel workbook I use to format the loot drop data.

Instructions:
1) before starting to grind for loot, export your inventory with Neoncat's Inventory Export tool
2) transform its output with Neoncat's Item Data Xref Tool (with the "reverse merge" option checked).
3) paste the transformed data into the "Before" tab of the Excel tool
4) after grinding is finished for the day, repeat steps 1-3 but this time paste the data into the After tab
5) see the results on the "Formatted Data" tab.
Enjoy!

 

Formatted:

Code:

All							
Lv	C	U	R	E	L	Tot	%
5	66	2	2	0	0	70	7,0 %
6	102	21	7	2	0	132	13,2 %
7	123	42	8	1	0	174	17,4 %
8	66	25	2	3	0	96	9,6 %
9	369	113	22	4	0	508	50,8 %
10	12	3	0	0	0	15	1,5 %
11	4	0	1	0	0	5	0,5 %
Tot	742	206	42	10	0	1000	
%	74,2 %	20,6 %	4,2 %	1,0 %	0,0 %		
							
Treasure							
Lv	C	U	R	E	L	Tot	
5	47	1	2	0	0	50	
6	0	0	0	0	0	0	
7	0	0	0	0	0	0	
8	0	0	0	0	0	0	
9	83	32	4	1	0	120	
10	0	0	0	0	0	0	
11	0	0	0	0	0	0	
Tot	130	33	6	1	0	170	17,0 %

 

Formatted:

Code:

Level 6 adventure "The Defense of Woodhome"							
All							
Lv	C	U	R	E	L	Tot	%
3	23	5	2	0	0	30	6,0 %
4	16	4	0	0	0	20	4,0 %
5	106	28	7	0	0	141	28,2 %
6	151	43	13	3	1	211	42,2 %
7	62	20	5	0	0	87	17,4 %
8	2	1	1	0	0	4	0,8 %
9	5	2	0	0	0	7	1,4 %
Tot	365	103	28	3	1	500	
%	73,0 %	20,6 %	5,6 %	0,6 %	0,2 %		
							
Treasure							
Lv	C	U	R	E	L	Tot	
3	0	0	0	0	0	0	
4	0	0	0	0	0	0	
5	58	15	4	0	0	77	
6	0	0	0	0	0	0	
7	0	0	0	0	0	0	
8	0	0	0	0	0	0	
9	1	1	0	0	0	2	
Tot	59	16	4	0	0	79	15,8 %
							
Level 6 adventure "The White Star"							
All							
Lv	C	U	R	E	L	Tot	%
3	13	1	0	0	0	14	2,8 %
4	19	4	0	0	0	23	4,6 %
5	200	47	2	0	0	249	49,8 %
6	109	26	8	1	0	144	28,8 %
7	40	14	1	0	0	55	11,0 %
8	1	0	0	0	0	1	0,2 %
9	3	11	0	0	0	14	2,8 %
Tot	385	103	11	1	0	500	
%	77,0 %	20,6 %	2,2 %	0,2 %	0,0 %		
							
Treasure							
Lv	C	U	R	E	L	Tot	
3	0	0	0	0	0	0	
4	0	0	0	0	0	0	
5	163	39	1	0	0	203	
6	0	0	0	0	0	0	
7	0	0	0	0	0	0	
8	0	0	0	0	0	0	
9	2	11	0	0	0	13	
Tot	165	50	1	0	0	216	43,2 %

 

I've just updated my notes here. Some of that data was available earlier at that link, and also here.
Format key: Red text is club reward, Bold is guaranteed drop or quest-rare, Yellow highlight is first time (per account), Italics is from beta.

 

I just realised I can spare you that chore. I'll add new pages (tabs, worksheets, whatever) to the Excel tool for the Before and After full inventories and calculate the difference with the tool. That way you only need to paste the Xref transformed Before and After inventories on their pages and the tool will take care of the rest. I'll add that feature when I get the chance.

 

Easier is better. Thanks much!

 

I updated the original CH Loot Drop Data Format Tool post with version 2. Now with added Before and After! Have fun!

 

If I click to another adventure after the 1st battle somewhere else and then choose the "no" option (can't remember the wording, but was not "cancel"), my party won't start moving there. What am I missing?

 

"Cancel" == "Yes, abandon the adventure"

 

Ah, yes, that works =) Thanks!

 

I played the Level 12 adventure "The Tomb of Tvericus" battles 1 - 3 (mostly 1) for a combined 500 times.

Code:

All							
Lv	C	U	R	E	L	Tot	
9	129	18	4	2	0	153	10,2 %
10	82	6	0	0	0	88	5,9 %
11	144	40	12	0	0	196	13,1 %
12	389	140	32	4	2	567	37,8 %
13	348	86	26	2	0	462	30,8 %
14	5	4	1	0	0	10	0,7 %
15	17	2	5	0	0	24	1,6 %
Tot	1114	296	80	8	2	1500	
	74,3 %	19,7 %	5,3 %	0,5 %	0,1 %		
							
Treasure							
Lv	C	U	R	E	L	Tot	
9	49	6	2	1	0	58	
10	0	0	0	0	0	0	
11	0	0	0	0	0	0	
12	0	0	0	0	0	0	
13	130	33	9	2	0	174	
14	0	0	0	0	0	0	
15	0	0	0	0	0	0	
Tot	179	39	11	3	0	232	15,5 %

 

Adding the latest runs to the totals documented so far we get

Code:

Level	Common	Uncomm.	Rare	Epic	Legend.	Total	Player
2	151	42	4	2	1	200	Jarmo
3	210	59	24	6	1	300	Jarmo
3	60	11	0	1	0	72	Arondight
3	223	66	8	2	1	300	Jarmo
3	231	54	13	2	0	300	Jarmo
4	374	104	7	3	1	489	Sir Veza
5	156	36	6	2	0	200	Jarmo
6	75	20	4	1	0	100	Andrew Talbot
6	238	45	12	5	0	300	Jarmo
6	208	71	15	6	0	300	Jarmo
6	218	66	12	4	0	300	Jarmo
6	365	103	28	3	1	500	Sir Veza
7	230	59	8	2	1	300	Jarmo
7	234	59	5	2	0	300	Jarmo
7	212	66	19	3	0	300	Jarmo
8	742	206	42	10	0	1000	Sir Veza
9	76	20	4	0	0	100	Tempo
12	15	5	0	0	0	20	Hatchhermit
12	87	10	6	1	0	104	ArtificerProdigy
12	1114	296	80	8	2	1500	Jarmo
13	82	19	3	1	0	105	ArtificerProdigy
13	766	184	42	7	1	1000	Sir Veza
15	109	28	11	0	2	150	Astropsica
16	77	18	4	1	0	100	Jarmo
17	95	31	7	1	1	135	Aldones
17	67	16	4	0	0	87	Piotras
17	226	63	9	2	0	300	Jarmo
17	226	54	14	6	0	300	Jarmo
Total	6867	1811	391	81	12	9162	
%	74,95 %	19,77 %	4,27 %	0,88 %	0,13 %		

The percentages seem to be stabilising nicely. The biggest difference to last time (at 4,673 items) was -0.19 percentage points.

 

This is my first attempt with CH Loot Drop Data Format Tool.v2. It wouldn't run in my ancient copy of excel, but works in OpenOffice4 (which is free, and therefore acceptable - even if it is a bit wonky). Let me know if this works okay.

 

Thanks for the data, Veza! It works fine. Does it come from one or more level 5 adventures?

Which version of Excel do you have? I don't think I use any advanced features in the tool. I might easily be able to save it as an old Excel version and streamline the process for you. Did you have any other problems using the tool? Was using it an improvement over earlier data logging methods?