≡v≡ ­ Production
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEF
1
2
Important!
3
With the introduction of Refineries right around the corner this sheet will need updating once they are live. I have decided not to use the SISI test environment as CCP have a habit of changing things once they go live on Tranquility, so I will update this sheet as soon as I can, once the update is live on TQ. It will be a fairly large update as I plan to condense the data input down to a single config page as I have talked about in the changelog.
4
5
SPACERSPACERSPACER
6
This spreadsheet is designed to help towards maximum efficiency when building Capital Ships, Capital Components and Sub-Capital ships.
7
How to access:
8
Load Price Data?NoGo: File > Make a Copy
9
TURN OFF WHEN NOT USING!!!This will copy the sheet into your Google Drive. Rename the sheet from there and access the copy to make changes.
10
(Price data may not work, check changelog to updates)
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".
11
Is the sheet being worked on RIGHT NOW?If the sheet is currently being worked on (you can see if it is to the left) hold off from making a copy for now. As soon as it says "No" again feel free to go ahead and make a copy.
12
No
13
When should I copy over the latest version?
14
Version 1.7If the version number has increased by a hole number (2.x) update immediately as a large portion of data has either been added, updated or removed.
15
08/09/2017 18:45 EVEIf the version number has increased by a decimal (x.1) update whenever you have the time as only minor changes have been made. This includes bug fixes.
16
You can subscribe to a mailing list to receive e-mail notifications for when the spreadsheet is updated by clicking the link below:
17
http://www.subliminallyfamous.com/newsletter/
18
19
How to use:
20
Begin by changing the settings on each of the "CapCalc", "ComponentCalc" and "SubCalc" sheets. Throughout the entire spreadsheet only change RED text.
21
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 is also on this sheet and not the respective "Calc" sheets.
22
You will see LIVE Mineral, Ore and Component values on the "Tracker" sheet.
23
Remember: Every time you reprocess your Ore or put Capital Components into build, update the Stored Ore, Minerals and Capital Comonents values.
24
25
Access is free, Donations are welcome.
26
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.
27
28
Things to know:
29
- 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.
30
- Entered skill data is assumed to be accurate. No errors will be thrown if inacurate data is entered, but you will receive inacurate results.
31
- 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.
32
- Remember Ore values fluctuate in Jita, especially the basic Ore values which are being pulled.
33
- 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.
34
- Refinary costs are not currently calculated. See Changelog date 01/07/2017 for more details.
35
- 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.
36
- 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.
37
- When updating the sheet to a new version simply follow "How to access:" and update your skill/facility data and stored minerals/ore/component values.
38
39
Plans for the future:
40
- As of around May 2018 CCP will turn off the current XML API. This sheet uses the Eve-Central API so I would imagine no changes will be needed on our end and they will simply update their own end. (Touch wood). That being said, around that time I will probably need to remove all traces of the XML API and replace them with the new Swagger API. The new system is proving interesting to use so this may take some time and tinkering. This sheet does however directly use the XML API to pull the Estimated Item Value (EIV). Thankfully price data isn't something required to get the hard figures out of the calculators, so if we go without price data for a while so be it - the primary function of calculating required ore and minerals etc. will still function.
41
- T2 Production will require a lot of additional data and calculations. It is my intention to add these to the sheet but I have no timeframe as of now. If you see notes about T2 data in the changelog you know it will be happening soon(tm).
42
- New capital ships: Currently the Blood Raider Capital ships are included in this spreadsheet as they literally require ore and the blueprint (like any other faction/pirate sub-cap). The other faction/pirate capitals will be added at some point for their mineral/ore requirements with side-notes for the extra required materials.
43
- I've been toying with the idea of adding a fourth calculator which would simply work by plugging in the required minerals to be shown how much ore is required. I'm not sure how frequently this would be used but wouldn't take much time to add. The trouble with adding yet another calculator means adding another batch of skill/blueprint/facility data and keeping that updated. It might be worth merging them all together as it's unlikely your skill data would be different between building a subcapital and capital ship and you'd probably be using the same facilities. Something I'll think more on.
44
45
Credit to https://www.fuzzwork.co.uk for Price data script and invTypes, https://github.com/nuadi/googlecrestscript for system cost index, and https://evewho.com/pilot/Ascenity for initial calculator structure.
46
Loading...
 
 
 
Main
CapCalc
ComponentCalc
SubCalc
TypeID
Tracker
BPC
Data
Changelog