|Version 4.2.2||This workbook is designed to help towards maximum efficiency when building any Ship Hull.|
|14/04/2018 19:10 UTC+1||How to access:|
|Go: File > Make a Copy|
|This will copy the workbook into your Google Drive. Access that workbook to make changes.|
|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".|
|When should I copy over the latest version?|
|You can subscribe to a mailing list to receive e-mail notifications for when the workbook is updated (details via the link below).|
|Please check your spam folder - if the e-mail is filtered as spam please mark it as "not spam" so they go to your Inbox in the future, or create a filter rule to ensure they make it to your inbox.|
|If you do not want to do this, which is fine, you will need to periodically check the website linked above. To be clear, your copy will not automatically update when I make changes to the master sheet.|
To update, follow the link above to access the most recent version of the sheet and copy it over to your Google Drive as detailed in "How to access". Don't forget to reconfigure your Config sheet when you do.
The most recent version will always be accessible on the page linked above.
|g||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, Donations are welcome.|
|Do not pay anybody for access to this spreadsheet, it is free for all use as long as appropriate credit is given where due. ISK donations can go to the character linked below and all questions and suggestions can go to my Discord handle "[NGMH] Subliminally Famous#1256". Thank you.|
|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.
|Plans for the future: (The current plan!)|
|- Phase 3 of the Version 4 rollout:|
-- Fighter and Drone production,
-- Structure Production,
-- T3 Production.
- Version 5:
-- Complete re-write to clean the backend up and enable personal versions of the sheet to automatically update.
Version 5 is a long way off, (months, not weeks, not days, months) but the plan is to perfect the backend of the workbook and enable automatic updates by inserting numerous references to a master spreadsheet where the updates are added to, thus removing the need to copy a new version over each time an upate is released. This is theoretically possible, however due to the vast number of calls to the master spreadsheet it may cause long loading times. A re-write will still happen to optimize the data sheet, we'll just have to see how it handles calling vast amounts of data from an external source.
|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.|