Hey guys.
The past week I've been working on a spreadsheet that compares all the craftable items in the hideout to their respective prices on the flea market.
The spreadsheet has three sheets: Net profit, Profit per hour and Detailed.
Net profit will show you the overall profit per craft.
Profit / hour will show you the estimated profits per hour spent.
Detailed includes all the fields used for the calculations including tax and fuel cost. This sheet also shows you the net and per hour profits side by side.
The problem with similar efforts by others in the past is that these often don't take into consideration fuel cost, time to craft, and the market fee. The fact that the prices are static can also introduce additional inaccuracies.
And so the goal was to create a tool that can more accurately estimate the real profit margins, and help maximize your profits.
In the background I'm running a server that fetches a selection of the offers for each of the items (crafting materials and crafted products), makes a weighted average of each offer and finally updates the spreadsheet.
What this spreadsheet does not do is take into account cost of upgrading your hideout.
It also does not account for other means of profits such as the bitcoin farm and the Scav Case. If it's feasible, I hope to update the spreadsheet with these at a later time.
I'm also planning to make a summary sheet with the absolute minimum included, likely only the produced product and it's profits.
Anyway, I would love to hear what you guys think! Of course, I welcome any constructive criticism that can help this be the best possible tool for the job 🙂
Oh almost forgot, here's the link:
