|Your Version:||This workbook is designed to help towards maximum efficiency when building any Ship Hull.|
|Version 4.2.6||How to access:|
|12/11/2018 17:17 UTC||Go: File > Make a Copy|
|This will copy the workbook into your Google Drive. Access that workbook to make changes.|
|Most Recent Version:|
Alternitavely, Go: File > Download As > Microsoft Excel (.xlsx) Then create a new, blank Google Sheet and: Import > Upload (Select downloaded .xlsx file) and "Replace spreadsheet".
To update to the most recent version go to www.subliminallyfamous.com, click the link and follow the process above again.
|12/11/2018 17:17 UTC||How to use:|
|Begin by changing the settings on the "Config" sheet. Throughout the entire workbook change only RED text.|
|- Use the "Tracker" sheets to track the progress of your builds. "Required" values will update as you enter your stored materials.|
- The "Reprocessing" sheet is for when you have a stockpile of ore and would like to know what you can build with it. You can plug in Basic Ore, Moon Ore and Ice to see what the reprocessed outcome will be, as well as what T1 hulls (and how many) you can build.
|How to read the Tracker sheets:|
|- The T1 Tracker is split into three sections vertically: Capitals, Capital Components and Sub Caps. Start at the bottom of a section and work your way up. For example with Capital Hulls you see what Components you need at the bottom, the Minerals required to make those components above and then the Ore required to get those minerals above that. If you click the "Clear Data" button* it will reset all stored values for that section to 0 and "Quantity" to 1.|
|- The T2 tracker should be read from right to left for the different stages. You can start production at any stage. For example if you start at Stage 4 you would purchase the Reaction Outcomes from Stage 3, Mine the required Ice in Stage 4 to build the Fuel blocks and then use those Fuel blocks and the purchased Reaction Outcomes to create the Components. You wouldn't need to mine/buy Ice/Fuel Blocks from Stage 3, as you will have already purchased the outcome. The most cost effective stage to start at for the majority of builds will be Stage 1 even after considering the surplus of remaining components/reaction outcomes from minimum required job runs.|
|- Fuel Blocks (and the Ice required to build them) are split into Stage 3 and Stage 4. This is because if you start at Stage 4, you will not need the Fuel Blocks required to react the Moon Goo in Stage 3. If you plan on starting your production line at Stage 1 you can get away with mining all of the Ore and Ice from different stages, adding the stored values into those stages** and then return to Stage 1 to continue your production line.|
- Required amounts of Minerals/Ore will not dynamically update as they do on the T1 Tracker for Stages 1 and 2 as they are technically listed in reverse order. They will, however, update dynamically on Stage 5 as it's within the same Stage.
|Prior to Version 4.2 you had to manually enable, update and save Price Data. You no longer need to do this.|
|Price data is automatically pulled from a master spreadsheet and will automatically update, so expect to occasionally see price values error out for a few seconds whilst they refresh.|
|If the master spreadsheet fails to load price data you will see errors for price values. The most likely cause of this is if CCP's ESI is experiencing down-time.|
|On the "Config" sheet you can configure your mining fleet. The fittings used for these calculations can be found in the "Fittings" sheet. As it isn't the main purpose of this workbook I have not added complete customization for the fleet (this would basically require putting Pyfa into spreadsheet format) but you should be able to set your configuration to resemble your fleet in a fairly accurate way. It can at least give you a basic understanding of how many hours of mining you need to put into your build.|
|Some cells will have notes attached, mainly to explain how the figures are calculated. This is signified by a black triangle in the upper, right corner of that cell.|
|* The "Clear Data" buttons may need to be configured once you copy over your version. Right click the buttons, left click the "three dots" in their upper-right corner and select "Assign Script". Ensure the following scripts are assigned to each button: |
clearCapTracker - "Clear Data" for Capital Hull builds,
clearComponentTracker - "Clear Data" for Capital Component Builds,
clearSubTracker - "Clear Data" for Sub Capital Builds,
clearT2Tracker - "Clear Data" for T2 Builds,
clearT2CapTracker - "Clear Data" for T2 Cap Builds.
If you do not see these buttons, maximise your window and refresh the page.
|An example can be seen in the screengrab below make sure the text is exact (also CaSe SeNsItIvE):|
|** If entering stored materials/ore into the Fuel Block requirements in Stages 3 and 4 remember to split your figures between the two. For example, if 10 Hydrogen Fuel Blocks are required for Stage 3 and 20 for Stage 4 and you have 50, do not enter 50 into both stored values. Enter 10 in Stage 3 and 20 in Stage 4 (remainders don't matter, so you'd also be able to enter 25 for both).|
|Access is free.|
|Do not pay anybody for access to this spreadsheet, it is free to use for everyone. You are welcome to expand upon this project providing all appropriate credit is given.|
|Things to know:|
|- Numbers are calculated via your data input. If a single BPC for a cap build has a different ME/TE than what you enter, a facility doesn't have the rigs you select, or you forget to update the stored minerals on the "Tracker" sheet, you're going to get inaccurate data.|
|- Entered skill data is assumed to be accurate. No errors will be thrown if inacurate data is entered, but you will receive inacurate results.|
|- Ore and Compressed Ore Values are priced at the basic Ore price as mining a higher mineral yielding rock does not take any longer. This will result in left over minerals after the build.|
- All values will be displayed as the Jita BUY value unless specifically stated otherwise.
|- Remember Ore values fluctuate in Jita, especially the basic Ore values which are being pulled and the Moon Ore values will be grossly inflated which is why the BUY value will be displayed.|
|- If all of the Ore you mine is a +10% yielding Ore you will have 10% extra (based on the sheet calculations) minerals left over and therefore more potential profit.|
|- The calculator structure for the T1 tracker is "as optimized as possible". By this I mean rather than calculating the Ore's Mineral yield in alphabetical order, it calculates them starting with Gneiss, then Dark Ochre, Crokite, Bistot, Arkonor and Spodumain. (Spodumain twice, once for Tritanium and again for Pyerite). This is because each ore provides smaller yields of other minerals. Currently (for T1 builds) if you're starting with no stored minerals it should be possible to ignore the required Dark Ochre quantities as the required Spodumain should yield the Isogen required for your build. To save time whilst mining, gather all required ore (excluding Dark Ochre), reprocess it and plug your stored mineral data into the tracker. You'll then see if you still need some Dark Ochre to top your Isogen supplies up. The reason Dark Ochre is still calculated is for if you start with an abundance of Tritanium and Pyerite - it would in that instance be more efficient to mine the Dark Ochre rather than Spodumain for the Isogen.|
-- The new T2 calculators are not as optimized as the T1 ones. It calculates in alphabetical order. You'll still have the required minerals/goo after your build, however a different order of calculating them may mean you have less Moon Goo after the build (and therefore it would be more efficient). I will monitor how the calculator handles after the release and play around with different orders for it to optimize it as much as possible. If I do change it (which is likely) it'll be released in a new update just as any other change is.
- Price data (specifically profit calculations) on the Tracker sheets may seem a little off. They are calculated in a very simple manner and more ofen than not from a complete build starting from the first stage. For example for a T2 build it considers the cost to buy the ore required from stage 1 to work your way up to the final product (and build costs). In version 5 of this workbook I will probably change how it is calculated, but as price data isn't the primary function of this workbook it is not a priority - in most places you can copy/paste into evepraisal.
|Plans for the future:|
|The original plan for version 5 was a complete re-write to tidy up the code and bring more features to the workbook.|
Unfortunately I do not see this being finished in the near future and I have decided to step away from the game indefinitely.
I would like to continue work on v5 when I can, but would not be able to provide an ETA (or even guarantee its release).
Thank you all for your support as this workbook has evolved.
Fly safe o7
|Credit to https://www.fuzzwork.co.uk for invTypes and Buy Values, https://github.com/Blacksmoke16/GESI for Cost Index and Adjusted Prices, https://github.com/pyfa-org/pyfa/releases for basic m3/s ore calculations and https://evewho.com/pilot/Ascenity for initial calculator structure.|
|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. 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. CCP hf. does not endorse, and is not in any way affiliated with this workbook. CCP is in no way responsible for the content on or functioning of this workbook, nor can it be liable for any damage arising from the use of this website.|