Edited by: Aidan Patrick on 30/04/2011 10:08:46
Ok, so I recently updated my spreadsheet, and I'm also updating the post to be a little bit more thorough and not so TL;DR.What is this?
This is a spreadsheet calculator for mineral/resource yields on Ore, Ice and Drone Poo. You type in the quantities that you have, it figures out how many batches you have to refine and gives you the mineral yield as well as some other semi-useful data. (leftover units, volume etc)
In addition to the mineral actual yield calculator it has a built in profit calculator (You need to enter the prices yourself) and a third calculator that is for the system I'm using for my corporation when splitting everyones cut from a group mining op. (More on that later if you're interested).The FilesPreview it
with random data pre-entered.Download it
in .xlsx format (contained within a .zip) from EVEFiles.Copy it
from Google Docs.Mineral Yield Calculator (MYC) Sheet
This sheet is extremely simple. You're only supposed to edit the light gray fields for each of the ore/drone/ice quantities. Manually editing the other fields will screw up all the other formulas. The calculations for each yield pull from the Yield Reference Chart sheet.Yield Reference Chart Sheet
This sheet shows the information on the volume (m3/unit) of each ore/ice/poo, as well as the batch, and the volume of an entire batch. On top of that it also shows what products the source refines into. Should there be a patch changing the yields, m3, or batch size, editing this sheet will suffice for updating the entire spreadsheet. With that said however, errors on this sheet will screw everything up.Mineral Value Calculator (MVC) Sheet
This sheet is pretty straight forward as well. Light gray fields are all you should edit. The top table is for entering the ISK/Unit price for all the refined goods, which once done the sheet will auto-calculate the value of the refined product from the MYC on an individual level, and give you the total value.
The Cut Calculator below is also pretty straight forward, just enter a custom name (if desired) on any of the cuts to track what it is, then enter a plain number (no decimals required) for the percentage (IE 15) and it will auto-calculate that cut from the combined mineral value. A breakdown of the cut information is available at the bottom of this table.Participation Point Calc. (PPC) SheetThis sheet is not required. It is used for the method in which I divy up isk/mineral cuts at the end of an op.
ISK calculations on this sheet are calculated based on the remaining value from the MVC sheet to enable you to take out cuts (such as a corp tax) out before using the PP System. If you plan to divy out minerals instead of ISK however, please note the sheet does not account for pre-removed cuts from the MVC sheet.
The PPC Sheet uses my Participation Point method to distribute either an ISK or mineral cut post-op (more on this in a separate post). For tracking purposes you enter each persons name and their ship. You then enter the PPR for that ship, and the times they started, and stopped participating in the op. It will then show you the PPE (Participation Points Earned) and calculate their cut via ISK. Additionally if you are going to split the minerals at the end instead, there is a column for each mineral (including for the resources yielded by ice) that shows you how much of each material they are to receive.
At the bottom of this sheet there is some data that shows how much ISK/Minerals you yielded total, as well as showing how many (if any) units are left over after giving everyone a cut.