How do you keep your resource stock under control

[Leeloo Miner]

This is a question many people ask me.

First of all, it takes a good knowledge of where to mine what.
That is why I make averages of many different places first and calculate the TT return and TT+%.
Also using different finders is important as you can find different resources at different depths.
This is mainly preparation.

Now keep control of your stock for sale.
First and foremost, my priority is to stock it for a year maximum.
But how do you calculate this?

For example, Garcen.
Looking at the year total, 1.2 Million ped TT is sold annually.
Since there are 12 months in a year, I divide this by 12 and arrive at 100000 ped / month.
This of course is not the amount I want to stock ...
The amount you want to stock now also largely depends on your ped card.

Let's say you have 1K ped at your disposal.
Then start stocking, say, 0.20% of 100000 in garcen because you're not only going to get garcen in your return but also other resources.
EDIT : I started @ 0,05% and you'll need about 10K TT to start stocking but that amount depends on your sales %.
Once I reached all amounts needed for 0,05% I went up 1% and I keep doing that.
Do the same for all other resources that you get from the same place, then expand to your next zone etc ...

Remember, the more different resources you get, the more peds you will need to reach the calculated maximums, but also the more you can sell due to diversity.

This can be a start, and since you will also get other resources, you can also calculate here how much you want to stockpile maximum.
Oil is best ignored as you will get that in abundance.

Meanwhile, the sale is going on and you keep mining until you have the maximum of all resources of this place in stock.
You are going to have more of some resources than you want, but using different finders can help you with this.

As soon as the garcen stock now drops below the predetermined stock, so in this case 1,000 garcen, I go back to the place that gives the most garcen and start mining here again to fill the shortfall.

Suppose at a certain point you have sold your entire stock of garcen, or cannot replenish enough because the economy has changed and sales are accelerating due to shortages at auction.
At that point, I adjust my stock to instead of 0.20% to 0.30% and continue like that until I never sell out for garcen and can keep my stock up to date.
Time to calculate another resource and keep mining.

Hope all this is clear, but if you still have questions, feel free to ask.

Have fun mining

 

[Leeloo Miner]

I have been using this way of mining for several months now and I must say, it works great for keeping my stock under control.

It is also much clearer to me which resources I am always short and which I am not.

As a surprise, I see that my amount of lyst, is always below the minimum (thanks to unamped mining) ...


By adding +1% (global) each time one of the resources falls below the minimum limit, my stock grows and I mine only what I need for selling.


Also the stock, which I am not selling at the moment because the % is too low, is growing, so that I can sell it when it reach the minimum % I calculated.

Remember, all goes up and down, globals/hofs are NOT profit, MU is.


During the time I have been using this way of working, I have gone from a minimum stock of 0,05% to 0,08%.


Several resources are easier to mine on other planets than Caly.

Once I see that my stock on caly stays up to date, the next step will be to apply this to other planets as well.

This is a slow process that works, at least for me.

 

[Leeloo Miner]

Keeping your stock under control also means paying great attention to sales.

This weekend the impossible happened ... all my lyst was sold, and by that I mean for a nice price of at least 108% net ...
I was already struggling to keep my lyst stock up in recent weeks.

How to solve this (with advice from a friend miner, who makes even more profit than me).

Since I am selling 3 different stacks of lyst, he advised me to leave out the cheapest one and keep the 2 more expensive ones. So I promptly took his advice to heart as soon as the cheapest stack was sold today.

It is constantly ‘fine tuning’ and adjusting your sales to get the most out of them.

But this is also an advantage because I have the impression that there is more and more playing with selling % read more volatile mining.

 

[Leeloo Miner]

Like most miners, I have recently found that you get a lot of ‘fillers’, at any depth.

Since I am trying to build a a stock, I have set myself limits according to the quantities that sold globally monthly at auction, taking into account availability.

Some examples for my fillers resource stock :
Belkar 10K - Blaus 5K - Iron 5K - Lyst 60K - Oil 20K - Nexus 20K
From the moment these quantities are reached, I will stop mining where you can find them.

The selling % of these fillers becomes more and more important as they usually make up 50-60% of your return (unamped)
Also your general costs like extraction and refining become more and more important.
To mine as cheaply as possible, I have also started comparing costs with UNL finders + depth enhancers VS L finders, more on that after I have more results.

Furthermore, there are the uncommon and rare resources.
These are stored until the % is high enough to sell.

Also, I currently have the impression that sales are very slow ... which of course has as a consequence ... less sales = less mining.

 

[Leeloo Miner]

Of course, if you want to keep your stock under control, you need to know exactly where to find/mine everything.
Instead of mining to do my missions, my goal is to update my stock. Mission goals come naturally.

Especially in the beginning you will be looking for places to mine, maybe a good idea to make a spreadsheet or something similar already then that you know where AND how much you can find.

That way you know exactly where you will find the most amount of those resources you want to mine to fill up your stock.

This is what my spreadsheet looks like for now, which is linked to all the places I'm going to mine (servers) and keeps getting expanded.
Obviously, it is different for everyone, even if you mine on the same server, other places on the same server give different results, which is why I left out the server name. As soon as the values or quantities change (by MA or availability), this is also automatically updated.

As soon as the numbers in the table drop below my amount (NEED) of stock, I start mining it at the place where I find it the most.

Any questions? Feel free to ask.

	TT	Need	Stock
			ped
Adomasite	1,80	43	78						3,27%
Alferix	2,85	4	11						2,07%								2,61%	7,37%
Alic	0,10	107	11		24,19%		11,43%	10,69%		7,61%							4,09%
Alternative			0
Angelic	1,00	36	36									0,27%
Ares	0,52	157	82	0,90%											7,91%
Azur pearls	1,92	20	38	1,07%												16,21%
Azzurdite	3,60	45	161	11,45%	1,87%				8,02%		0,15%
Banite	0,24	26	6														24,68%
Belkar	0,06	9722	583	15,83%		12,21%	10,13%	3,96%	5,11%	12,57%		12,41%						1,54%	1,94%
Binary	1,50	28	42	1,13%
Blaus	0,12	4167	500		19,69%	40,59%	38,80%	21,98%	23,02%	33,60%								1,95%	4,45%
Bodai			0													3,38%
Caldo	0,51	1144	583							0,94%		9,28%	32,59%					0,00%	11,56%
Chalmon	0,94	17	16									0,20%				23,81%
Cobalt	0,60	58	35
Copper	0,48	76	37	6,27%														0,00%	0,00%
Cumbriz	0,45	593	267		20,03%				12,56%			8,74%
Dark Lyst			0															0,69%
Dianthus	0,60	37	22							2,32%
Dianum	3,75	25	94		6,80%				2,81%
Duru	2,40	90	217		3,34%		7,63%	3,51%		10,43%								0,00%
Edres			0
Energized crystal	0,60	240	144	2,07%	0,00%	0,76%				8,81%		1,24%			0,91%
Erdo	1,20	42	50	1,26%						0,00%							6,67%	0,00%
Erionite	0,60	26	15							6,56%
Frakite	0,90	2	2
Frigulite	0,36	92	33						8,63%									0,00%	1,43%
Ganga	0,36	312	112				10,96%	15,55%
Garcen	0,20	1000	200	4,57%	9,72%	12,65%	4,03%	4,46%		6,99%	10,45%
Gazz	0,75	289	217		8,29%		2,02%	2,11%		0,00%								0,00%
Gold	3,00	32	97						1,23%	0,00%	0,00%	0,45%	0,00%					0,73%	0,38%
Growth	0,47	79	37						4,40%	4,18%	68,73%	15,50%				19,05%
Hebredite			0										7,15%
Henren	1,26	17	22	1,81%								0,27%
Hydrogen	0,04	138	6													0,00%
Igni	2,10	79	167	2,46%						0,00%								0,85%	2,90%
Iolite	0,60	10	6		0,47%					0,00%									0,87%
Iron	0,39	2778	1083		30,49%					23,73%		61,72%						3,15%	18,90%
Kanerium	7,50	3	26					0,00%	0,68%
Kirtz			0
Langotz	2,70	0	1									0,03%	0,00%
Lano	0,66	4	3						0,00%			0,77%
Light liquid	0,84	18	15						0,52%
Lotium			0												1,91%
Lyst	0,03	66111	1983	21,69%	7,58%	36,73%	30,53%	15,43%	23,35%	8,31%	46,38%	13,87%	45,10%				9,35%	73,38%	41,79%
Lyta	0,38	200	76	0,32%	3,36%					0,88%
Maganite	3,15	0	1														0,37%		0,16%
Magerian	0,50	104	52	3,71%	0,00%		2,16%	2,01%								20,26%
Megan	0,54	105	57		0,25%													0,00%	0,36%
Melchi	0,04	5000	200	20,93%	14,76%	41,16%				16,78%					22,21%
Narc	0,24	1667	400							0,00%	23,39%	8,44%						1,38%	3,03%
Nexus	0,01	7233	72	10,78%	5,35%		9,15%	5,07%	54,37%	1,72%		30,51%
Niksarium	1,95	73	143	26,74%						3,85%			20,01%						3,34%
Oil	0,02	20000	400	45,61%	42,62%	27,49%	42,94%	41,53%	20,68%	36,32%	20,82%	20,41%
Petonium	5,37	8	42						3,42%
Platinum	9,00	1	11															2,91%	2,30%
Praetorium			0															1,46%
Putty	0,78	127	99	2,20%			1,72%	2,02%
Pyrite	0,60	833	500		5,38%
Quantum	1,80	27	49															0,00%	1,98%
Redu	6,60	2	16				0,13%	0,00%
Root acid	0,64	150	96	5,66%								28,83%			23,02%	12,97%
Solis	1,56	8	13												7,99%
Somin	0,12	8	1												18,19%
Sorensen			0															0,93%
Stardust			0													4,32%
Sweet Nutrio	0,01	5717	57						19,92%	6,86%
Terrudite	3,30	14	45						0,82%	0,00%								1,33%	0,76%
Typo	0,30	326	98	0,96%	0,00%		5,91%	6,41%		1,27%
Valurite	18,00	0	6	0,23%
Vegatation	0,80	1	1				0,21%	0,00%
Vesp	5,40	3	15							0,00%							2,05%	0,87%	0,00%
Wenrex	0,51	40	21										2,37%
Xere			0										0,00%
Zanderium	7,50	0	0						0,17%
Zinc	0,30	343	103			10,47%					17,44%							1,48%	3,87%

 

[an old fart]

Any questions? Feel free to ask.

i have a question

in another thread you were using maps from a mining tool which, if i understand correctly, basically does the same thing as your spreadsheet but with the data of multiple players.

why did you switch to using your own spreadsheet vs using tools based on shared data? this is the thread i am referring to https://www.planetcalypsoforum.com/forum/index.php?threads/leeloos-mining-guide.254877/

thanks

 

[Leeloo Miner]

i have a question

in another thread you were using maps from a mining tool which, if i understand correctly, basically does the same thing as your spreadsheet but with the data of multiple players.

why did you switch to using your own spreadsheet vs using tools based on shared data? this is the thread i am referring to https://www.planetcalypsoforum.com/forum/index.php?threads/leeloos-mining-guide.254877/

thanks

Good question and thanks.

The link, to which you refer, I still use for all the different zones where I mine and on that spreadsheet I can see what finder is best to use, with or without enhancers (testing expense comparisons also now), to mine what I want and if needed, to avoid resources I do not want depending depth.

I also still use all kinds of finders to find differences.

Here I would mine for melchi and to avoid energized, I would mine with any finder lower than F-103.

	Energized	Garcen	Melchi	Oil
Peds	12,30	217,12	698,44	471,89
%	0,73%	12,86%	41,36%	27,95%

What you see on the last spreadsheet here is actually the result of all finders, in a particular zone, where I still mine, but where I aggregate all the date what is mineable and the average resources that I can find there.
At the top of this spreadsheet, I see where I can find these resouces the best, which I left out here, for obvious reasons.

All my spreadsheets are connected.

 

[an old fart]

thank you!

 

[Vill]

I was always wondering if you know where and at what depth to find better mu resources, what is the point to try mine all materials? I mean what is the point to target mine some low mu fillers? Isn't it better to try to mine for better mu resources all the time and whatever fillers you get they all have quite similar mu (low mu).
This seems like more profitable strategy in long term.

 

[Leeloo Miner]

I see : fillers, common, uncommon and rare resources.

Actually, the profit margin of fillers is very much underestimated, and you cannot avoid them during mining.
If I look at my profit margins, and I mostly mean fillers, they are much higher than all the rest because they also sell much faster. Fillers can easily sell between 105-110% net and you get large quantities of them, sell super fast and remain fairly stable in sales.

The common resources, you still find quite a lot and the profit margin of these goes up and down slightly.

Uncommon, you get much less again and the % of these fluctuates much more.

I am not even interested in rare as the quantity is so low that it takes a long time before you have a stack that can be sold and it yields much less than the rest. If I find them while mining, I'll stock them here again of course, but it's certainly not a requirement to mine them.

Everything depends on the way you sell and of course on the % as well
For fillers for example, I always have 3-5 different stacks on auction (for each different filler) that sell fast daily, several times even, while for the common I sometimes sell 1-2 different stacks depending on the %.
The uncommon as well as rare, is really waiting for the right moment to get such a high %, so dormant peds, where you have to wait a long time for returns.

Now if you start mining pre-amped/amped, your costs are much higher and you have to sell cheaper to get your money back faster to continue mining, so you're never going to reach the % in sales I set as a minimum because the quantities are much higher.

My biggest profit is in the fillers due to the quantities and quick easy sales that I would never achieve with uncommon and rare

I would even dare say that I continue to mine with high net profit only with the sale of fillers.

 

[Leeloo Miner]

But how do you determine the price to sell ?

For myself, I have created a spreadsheet that is most clear to me, but that might be different for everybody.
I do have to confess that this was much simpler in the beginning, but over the years I made adjustments that I thought would be interesting.

As I have said many times, the TT value is of no importance, only the sales% and I am going to try to demonstrate that with this in a simple zone with enmatter.

Below is a simple table, minded with the F-102 (without amps/depth enh)

100 drops, so 50 ped, cost 1.15%

Add to that extraction and refining then 100 drops cost 51,82 ped, in this case 2,44%, using only UNL gear cause payed MU is ALWAYS lost.

In this case, the TT return was 48,58 ped so 93,75%.
As I said earlier, the TT return means absolutely nothing.

F-102			0,0115	refiner	extractor
Date	Probes	Drops	F-102	T-105	RRR	Enh	Totall	TT return	Return	50,97
	50	100	1,15	0,3218	0,3452	0,0000	50	48,58	97,16%	-1,42
	Probes	100	F-102	T-105	RRR	Enh	Totall	TT return		Sales
	50		1,15	0,3218	0,3452	0,0000	51,817	48,58		54,69
	2,44%		1,15%	0,62%	0,67%	0,00%	Cost	51,82
							TT return	48,58	93,75%	-3,24
							Sales return	54,69	105,54%	2,87

Let's take a look at what the sales% actually means.

Energized	Garcen	Melchi	Oil
min-max depth	139-465	71-535	5-520
	8,7	23	16,88
Energized	Garcen	Melchi	Oil
0	8,7	23	16,88
0,00%	17,91%	47,34%	34,75%
sales%	sales%	sales%	sales%
0,00	11,26	25,27	18,16

Sales % is what you want/need after sales, this means all costs including fee when selling on auc.
After a run, this way you can calculate the price you need/want to be left with AFTER SALE NETTO to make a profit.

Finally, you can see that the run ended up with a small gain.

You decide the sales % of course, but with that, you decide your profit % and how fast you will grow.

As prices keep fluctuating, you will discover that it is not always possible to sell your resources at the price you want/need to make a profit.

Therefore, it is a necessity to know this % well and wait until you can sell when the price is high on auc high.

 

[R4tt3xx]

Interesting......

Your MU% is what makes you your profit. Feeding the crafters.... In that case your hitrate% does not really matter as it can be offset by MU, as long as that hitrate% for that resource is uniform between all miners at the same time. IE if mining is bad for me, it should be bad for everyone else in this area at this time...

 

[Leeloo Miner]

Interesting......

Your MU% is what makes you your profit. Feeding the crafters.... In that case your hitrate% does not really matter as it can be offset by MU, as long as that hitrate% for that resource is uniform between all miners at the same time. IE if mining is bad for me, it should be bad for everyone else in this area at this time...

I'm afraid you have no clue how mining works ... really ... nor how to make a profit.

 

[Leeloo Miner]

December 2024 ...

This is usually 1 of the best months to sell your resources following the MM event.

Mining is still ok, it's the economy falling apart and at the same time the amount of fillers has increased even more.

I completely understand the effect of what is happening and this is certainly not the fault of the hunters.
When you spend so much and hunt for certain weapons/armor and it is not possible to obtain them ...

Therefore, as a miner, you have to be prepared for highs and lows.

In my case this means, slowly reducing my stock to lower levels as I adjust stacksizes to smaller ones to sell with ever, minimum the same profit margin as my larger stacks.
It makes absolutely no sense to keep mining and selling at dumping prices cause your costs stay the same.

As a result, I mine less and above all, to maintain profits, sell in smaller stacks.

My stock list was built up to 0.20% of monthly sales of all resources but has now been adjusted back to 0.10%.

This does mean that I am freeing up more and more peds again, to mine certain resources on other planets which gives the opportunity to bring the more uncommon resources back to a decent stock.

As a miner, it's always adjusting and recognising the market and above all counting.

January/February has always been a very bad sales month ... hopefully it will not fall completely flat.