|This workbook is designed to help towards maximum efficiency when building Capital Ships, Capital Components and Sub-Capital ships.|
|How to access:|
|Load Price Data?||No||Go: File > Make a Copy|
|TURN OFF WHEN NOT USING!!!||This will copy the workbook into your Google Drive. Rename the copy in your Google Drive and access it 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".|
|Version 3.3: Lifeblood|
|31/12/2017 15:57 UTC||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).|
|If you do not want to do this, which is fine, you will need to periodically check the master workbook at for version changes. To be clear, your copy will not automatically update when I make changes to the master sheet.|
To update, access the workbook from the link above and simply follow the "How to access" steps again as you will be cloning a new version over to work from rather than applying updates to your current copy.
The most recent version will always be accessable on the page linked above.
|How to use:|
|Begin by changing the settings on the "Config" sheet. Throughout the entire workbook change only RED text.|
Having changed these settings go to the "Tracker" sheet. This is the sheet you will use the majority of the time for your builds which is why the ship selection and blueprint data is also on this sheet and not the respective "Calc" sheets.
|You will see LIVE Mineral, Ore and Component values on the "Tracker" sheet.|
|Remember: Every time you reprocess your Ore or put Capital Components into build, update the Stored Ore, Minerals and Capital Comonents values.|
Throughout the workbook you will see cells with a black triangle in the top-right hand side corner. This signifies a note is attached to this cell which likely better explains what it's for. Mouse-over that cell for the note to appear. Try it with this cell.
Alternatively you may see a link you can click which will open a specific part of the changelog which will provide a detailed overview which otherwise couldn't be included in a note. To click these links mouse-over them and click the pop-up.
|Set up the price script:|
|Go: Tools > Script Editor.|
|In the Script Editor, Go: Select Function: InitializeGetMarketPrice. Hit the Play button (Triangle next to the bug icon). You may need to authorize the action.|
|Still in the Script Editor, Go: Edit > Current Project's Triggers. Add a new trigger for the "increment" function. This will add a force refresh for price data. I have it set to run every ten minutes and suggest you do the same.|
|Warning! Having price data constantly updating can cause you to reach your Google Quota of 20,000 URL Fetch calls per day. Only run price data when you need it, turn it off when not in use.|
You do not need to run the InitializeGetMarketPrice function more than once. Simply toggle price data on/off after you've run the function and it will load prices. You may need to run the function again after updating your sheet to a newer version.
|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. All questions, concerns and ISK donations can go to https://evewho.com/pilot/Subliminally+Famous in-game. 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, 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.|
|- Remember Ore values fluctuate in Jita, especially the basic Ore values which are being pulled.|
|- 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.|
|- Refinary costs are not currently calculated. See Changelog date 01/07/2017 for more details.|
|- Price data causes heavy Load on the Google useage limits. Turn it off when not in use, allow a few minutes for data to fully load each time when turned on.|
There is a function called "increment2" you can set to auto-trigger which will force the "Load Price Data?" to switch to "No" to turn it off. Set this up if you think you will accidentially leave it on - it will prevent you from unintentionally hitting the Google Quota Limit.
|- The BPC sheet currently holds no function other than to track how many runs you have. See Changelog date 21/06/2017 for more details.|
|Plans for the future:|
|- As of May 2018 CCP will be removing the XML API. The primary function of this sheet (calculating required minerals/ore/components) will not be effected but I may need to update some areas so price data can continue to be calculated accurately. There are currently a lot of IMPORTXML cells in this workbook which is inefficient and will probably cause the job costs to take a long time to load. I plan on optimizing this as much as possible.|
|- T2/T3 production requires a huge amount of extra data input and calculations. I do plan on adding this but have no estimate for when this may be.|
|Credit to https://www.fuzzwork.co.uk for invTypes, https://github.com/nuadi/googlecrestscript for system cost index and price data, eve-industry.org for EIV's, https://github.com/pyfa-org/pyfa/releases for basic m3/s ore calculations and https://evewho.com/pilot/Ascenity for initial calculator structure.|