EVE Search - [Spreadsheet Calculator] Raw Ore to Mineral Value

Check My IP Information

All Channels

EVE Technology Lab

[Spreadsheet Calculator] Raw Ore to Mineral Value

» Click here to find additional results for this topic using Google

Monitor this thread via RSS [?]

Pages: [1] :: one page

Author	Thread Statistics \| Show CCP posts - 0 post(s)
Aidan Patrick Emerald Fusion Shadow of xXDEATHXx	Posted - 2011.04.16 15:36:00 - [1] Hello everyone! I recently found myself in a position of not being able to refine my goods myself and relying on others to haul those goods elsewhere and refine them on their time. Now obviously as I'm not refining them myself I can't just turn around and say "Hey I've got this much Mexallon, let me calculate it's price.". Lacking those numbers means I can't calculate my expected income from my business partners, leaving the mathematics entirely in their hands. Now, do I want to calculate every time they come to pick up the ore what the refined mineral value is? No... not really - theres tons of equations to do, even though they are all very basic. What this spreadsheet does is takes the actual batch size on ore refining and takes a perfect yield rate and calculates the refining efficiency minus refinery tax on that "100% refine" value for each ores batch size. It runs these numbers with a calculation of how many batches your quantity of ore refines into. So what's it do? It gives you a breakdown of how much of each mineral (Trit, Pyerite, Mex, Isogen, Nocxium, Zydrine, MEgacite & Morphite) refining of the entered quantity of the BASE ORES you enter will yield on a per-ore level. Then it combines them all. Then it takes user-defined prices and calculates the value of the minerals, then it has 5 customizable cuts you can set as a percentage. Then, it can give you the remaining value of whats left after all the other cuts you take out of it! In addition to the calculation of financial data it also breaks down from your current amount of ore, what quantity you need to use to meet the refining efficiency so you can give your business partner that, instead of giving them those extra 'bonus ore' pieces from an incomplete batch. The tool also calculates the m3 weight of all the ore entered and displays it in two methods. First is the entire weight of all the ore entered. The second is the weight of all the ore if you give only the amount required to complete the batches providing no 'leftover'. Additionally you get two pie charts and one bar graph. The first pie chart provides you a breakdown of which raw ores your stock breaks down into percentage wise. The second is a bar graph that gives you an at a glance to see which of the refined minerals you are making the most ISK out of. The third is a pie chart that shows you what the percentages of the refined minerals are. Overall there is a ton of information and all the calculation is done automatically. So what do I change? The 'fields' that you can change are the near-white ones. For entering your ore quantities you'll use the "My Qty" column. to change the tax rate of a refinery use the "Refinery Tax" field (just type in the percentage as a direct number, decimals are not needed if using google docs). At the bottom of the breakdown of minerals gained from each ore, it provides your totals for each mineral. Directly below those totals you can set the Mineral Unit Value on a per/unit basis. Editing those fields alone will give you your mineral value. Additionally you can change the cut percentage (taking a percentage towards whatever you want, such as corp tax, the percentage taken by your business partner(s) etc.) on five options. The value of each of the 5 cuts is broken down, a total percentage of the cuts is shown so you can see how much of the ore value is being cut out for others. Then it shows the Total Value Remaining that's left after all the cuts. Let Me See It! You can preview it here with some basic data entered. You can access the public (non-editable) google doc here. Opinions and feedback are welcomed! (Refining batch data is from the ISK 3.0 guide) - Aidan Patrick
Aidan Patrick Emerald Fusion Shadow of xXDEATHXx	Posted - 2011.04.16 17:43:00 - [2] Updated the yield reference chart to highlight the best yield for each mineral to show the ore needed to obtain that mineral the quickest. Did the same for drone poo. Also, if you use this spreadsheet and edit the values on the yield reference, it will effect the math on the calculation sheet and mess up your numbers. You've been warned. - Aidan Patrick
Sidrat Flush Caldari Vannbros Shipyards	Posted - 2011.04.17 08:05:00 - [3] Nice layout. Could you list your formula for the refine tax, I may implement it instead of using the perfect numbers. Hopefully ingame rounds to 2 decimal places and not 10. View The Eve Industrial Organiser Site
Aidan Patrick Emerald Fusion Shadow of xXDEATHXx	Posted - 2011.04.17 13:22:00 - [4] Edited by: Aidan Patrick on 17/04/2011 13:26:21 Edited by: Aidan Patrick on 17/04/2011 13:23:47 Thanks! The formula I use for the tax rate is this: =SUM(('Yield Reference'!C2G4)I4) The way I have the formula working is it pulls the batch yield from the second page of the spreadsheet for that specific mineral (so they can be changed across the board easily should an update change mineral yields). Then it multiplies that amount by the G column (contains: =SUM(E4-F4) ) which I have hidden. The G Column contains the sum of Q2 (manually entered tax rate, you can enter it with as many decimals as needed) and the E column which is a manually entered refine rate. Eventually I'll likely program in the refining skill levels some how, but for now you have to manually adjust the refine % on each ore type, same thing here - you can use as many decimals as needed. Once the calculation in the formula is ran on the per-batch yield, I multiply the resulting value by the I column, which is the resulting calculation of how many actual refinable batches you have. Edit: I updated the coloring on the Refine % field so it's more noticeably a user-editable field. - Aidan Patrick
Sidrat Flush Caldari Vannbros Shipyards	Posted - 2011.04.17 14:35:00 - [5] Edited by: Sidrat Flush on 17/04/2011 14:37:55 Thanks for the reply. Although very useful to be able to enter your skills and standings I have to say it's usually better to put Ore on the market at mineral prices than refining for less than perfect amounts. But I reckon that's just me. You know what would be useful for your sheet though. A mineral to Ore calculator. Reverse it in other words, e.g you need 1000 trit and 2000 pyerite - what do you mine in the least number of batches that you can access (bad example of course given that the minerals are ultra common). My sheet had it, wonder what you'd come up with. Good luck and have fun. Edit : Did you type the data values manually! Ouch. View The Eve Industrial Organiser Site
Aidan Patrick Emerald Fusion Shadow of xXDEATHXx	Posted - 2011.04.17 16:18:00 - [6] I'm not into production yet so I don't have target intake for specific minerals... however I eventually will be. Thanks for the idea - It'll take me a bit to figure out a good way to implement it though as I'm far from pro at Excel.. but I like the idea. and yeah I agree on the refining. If I wasn't able to get it done perfectly I wouldn't bother with it myself. - Aidan Patrick
Sidrat Flush Caldari Vannbros Shipyards	Posted - 2011.04.19 16:08:00 - [7] Originally by: Aidan Patrick I'm not into production yet so I don't have target intake for specific minerals... however I eventually will be. Thanks for the idea - It'll take me a bit to figure out a good way to implement it though as I'm far from pro at Excel.. but I like the idea. and yeah I agree on the refining. If I wasn't able to get it done perfectly I wouldn't bother with it myself. I believe you can find an example on the Tyrannis version of the Eve Industrial Organiser available in the link below. I can't remember exactly what I did to get the information but you should be able to follow it quite easily from the formula. http://dl.eve-files.com/media/corp/Sidrat/EIO_Tyrannis.zip View The Eve Industrial Organiser Site
Aidan Patrick Viziam	Posted - 2011.04.19 23:31:00 - [8] Thanks Sid! I'll check it out. - Aidan Patrick
Aidan Patrick Aldebaran Securities Tauri Federation	Posted - 2011.04.30 10:38:00 - [9] Edited by: Aidan Patrick on 30/04/2011 10:38:58 Changelog & Bump Spreadhseet Updated Thread name Updated Information on my Participation Point system added to explain what the 4th sheet is used for. EVE FIles Download link added Initial post made easier for the TD;LR - Aidan Patrick The Resurrection: Support the Revised Dead Horse Pos thread in Assembly Hall


Pages: [1] :: one page
First page \| Previous page \| Next page \| Last page

COPYRIGHT NOTICE
EVE Online, the EVE logo, EVE and all associated logos and designs are the intellectual property of CCP hf. All artwork, screenshots, characters, vehicles, storylines, world facts or other recognizable features of the intellectual property relating to these trademarks are likewise the intellectual property of CCP hf. EVE Online and the EVE logo are the registered trademarks of CCP hf. All rights are reserved worldwide. All other trademarks are the property of their respective owners. CCP hf. has granted permission to EVE-Search.com to use EVE Online and all associated logos and designs for promotional and information purposes on its website but does not endorse, and is not in any way affiliated with, EVE-Search.com. CCP is in no way responsible for the content on or functioning of this website, nor can it be liable for any damage arising from the use of this website.