|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Gamingloser1
   |
Posted - 2010.04.08 22:48:00 -
[1]
IS there something wrong with the components required to build a Rhea. It seems to take a lot more carbide than the other Jump Freighters?
|
Gamingloser1
|
Posted - 2010.04.09 14:25:00 -
[2]
Thanks for the quick update. Great work!
But it seems there is still something off. It appears that the total materials needed is still off. The Sylramic Fibers is only calculating based off the Sustained Shield Emitter, and is missing the amount needed for the Titanium Diborite Armor Plates. I think....
Also, I believe the the Titanium Carbide Calculation is off. I believe it should take around 8.4 million carbide units to make a Rhea from scratch (assuming Rhea bpc ME is -1, and all capital component blueprints ME are 15). Maybe the two issues are related? Maybe Titanium Diborite Plates aren't added to the calculation?
|
Gamingloser1
|
Posted - 2010.04.09 18:04:00 -
[3]
Your Spreadsheet Fu is strong. Cheers!
Next question:
On T2 Item production - When I choose T2 1600mm Steel plates (equipment/armor/Select plates - qty 10) it calculates the total minerals I need to build the t1 plates and R.A.M. However it says I need 53 Tungsten Carbide Armor Plates. Under that it says, "BluePrint not found" in red font, and the material needed to build those are not listed in to materials needed (tungsten carbide and Sylramic Fibers). I'm not sure if the spreadsheet queries your assets to see what BP's are present or not (I do own this BPO, in personal hangar). Is it safe to assume if the "Blueprint is found" then the materials will auto calculate?
Also, Covert Ops II and Improved Cloaking Device II has many N/A's in mineral required column. Build Price is #N/A too.
This truly is a great spreadsheet. I don't want to seem like I'm nit picking.
|
Gamingloser1
|
Posted - 2010.04.09 18:37:00 -
[4]
That did the trick for the t2 plates, but the minerals for the t2 cloaking still shows up as N/A. I noticed the T1 item is named "covert Ops Cloaking Device I" which technically doesn't exist in game. The t1 item should be a prototype cloaking device 1.
Note: the t1 worksheet for prototype cloaking device 1 works correctly.
|
Gamingloser1
|
Posted - 2010.12.10 01:49:00 -
[5]
I am getting the Run Time error'-2147217376 (80041020)': XML Parse Error.
WIN 7 64bit
Office Pro 2010 - Freshly installed today. All macros are enabled and tried both "trust access to the VBA project object model"
Microsoft .NET Framework 4 Client profile and extended (not sure if this matters).
Still love the SS. Cheers.
|
Gamingloser1
|
Posted - 2010.12.14 03:25:00 -
[6]
On the planet sheet I noticed the following:
When selecting a temperate planet, "aqueous liquid" is not highlighted green. Furthermore, the spreadsheet does not indicate that water can be made on a temperate planet. I'm sure these two problems are related (or same).
Also, I have a question on the same page. There are two "rows" for calulating POS fuel. What are the differences between the two (if any)? I noticed when I put the same size and race towers with the same amount of days the price pr day costs are different. When I change the raw material cost drop down box the cost per day changes but they never match.
|
Gamingloser1
|
Posted - 2010.12.14 05:07:00 -
[7]
Also on the planet sheet:
The materials need to build a complex reactor array is wrong. I believe it is pointing the materials needed for a simple reactor array.
Thanks for the great work!
|
Gamingloser1
|
Posted - 2011.01.15 01:41:00 -
[8]
Hello again Dedaf!
I noticed another oddity on the planet worksheet in regards to how it "pulls" prices from the Data worksheet. When you select the own pricing on Planet worksheet, the guidance system price (specialized commodities) is pulling prices from the hazmat detection systems from the Data sheet. Also Planetary Vehicles price on the Planet Sheet is pointing to the smart fab units pricing on the Data sheet.
A quick easy way to get a visual idea of what the results are set the prices of specialized commodities as 1-18 isk on the Data worksheet (H82-H99), set the guidance system (H70) price as something insane like 9999999 isk, and then change the price of hazmat detection system (H88) to something high (say 7777). Now go to the planet worksheet and use the own pricing. The guidance system will say cost 7777 isk and planetary vehicles will both cost 14 isk.
Secondly, Robotics are listed twice on the Data sheet. Once in Industrial goods (L74) and in Fuel (L22). I'm not sure how that can screw things up....is L74 even used to calculate anything (POS fuel cost/hr)?
Let me know if you have any questions.
Cheers!
|
Gamingloser1
|
Posted - 2011.01.22 04:59:00 -
[9]
The "own" prices for specialized commodities on the planet sheet are still pulled from the wrong cells on the data sheet. My previous post detailed this problem.
|
Gamingloser1
|
Posted - 2011.01.28 03:05:00 -
[10]
Some of the material requirements for T2 Cruise missiles are incorrect:
For example -4/-4 Paradise fury cruise BCP:
EMP Pulse Generator says 14 required, Spreadsheet says 9
Rocket fuel says 126, Spreadsheet say 86
Phenolic Composites says 59, Spreadsheet says 39
I'm pretty sure this applies to most, if not all t2 Cruise missiles.
|
|
|
Gamingloser1
|
Posted - 2011.01.28 03:43:00 -
[11]
Hey again Dedaf!
Found something else:
On the planet tab, None of the item slot work when you select the "Own" pricing from the drop down in advanced commodities. I believe it could be related to how the nano-factory is formatted within the cell (aligned left?). I think that breaks calculation of the price in the item slot one field (says #value!)
On a side note, any chance we could get the faction ships to the t1 item list?
|
Gamingloser1
|
Posted - 2011.02.08 20:32:00 -
[12]
On the planet tab:
Planetary vehicles should call for miniature electronics also. Currently, it is only using mechanical parts and supertensile plastics.
|
Gamingloser1
|
Posted - 2011.03.21 21:09:00 -
[13]
Hello again Dedaf!
On T1_production tab:
The Nightmare Battleship does not appear in the drop down box under Item Name.
As always....great work.
|
Gamingloser1
|
Posted - 2011.04.05 23:08:00 -
[14]
On T1_Production Tab:
The material requirements for Jump Portal Generator (Ship_equipment, Gang_Assist_modules) seems to have incorrect quantities. For example at ME:0, the spreadsheet says 158,950 nocxium is required. In game BPO says 602,031 is required. Isogen is the only material with the correct number.
|
Gamingloser1
|
Posted - 2011.04.10 01:49:00 -
[15]
Also on T1_production tab:
When I select pirate_ship category and then cruisers, the item list loads the regular (non pirate) cruisers.
|
Gamingloser1
|
Posted - 2011.04.12 18:01:00 -
[16]
On the data sheet:
There are two listings for transmitter, H77 and O94. Is there anyway to make them "link" like you did with Robotics?
|
Gamingloser1
|
Posted - 2011.04.12 19:55:00 -
[17]
 Originally by: Gamingloser1
On the data sheet:
There are two listings for transmitter, H77 and O94. Is there anyway to make them "link" like you did with Robotics?
Correction: One should be "high-tech transmitter," and the other is plan old "transmitter."
|
Gamingloser1
|
Posted - 2011.04.14 16:40:00 -
[18]
On the t3 production tab:
When I say I want to build 1 hull of a specific ship, the qty of T3 components (E7:E17) do not match the qty per hull on the blueprint. Specifically, Metafullerene Plating (15 vs. 17), Nanowire Composites (20 vs 22), and Fullerene Intercalated Sheets (8 vs 9).
|
Gamingloser1
|
Posted - 2011.06.10 03:03:00 -
[19]
Originally by: Dedaf
Hey guys, thanks for all the feed back, i will try to answer to some of your questions and remarks.
Gamingloser1: I have fixed the Jump Portal Generator mineral use and i have corrected the drop down menu for pirate cruisers
elioath & Gamingloser1: about the T3 production, i fixed the components in version 12,7,5 so it should be showing correct unless its a different bug. But could you make sure u are using 12,7,5 or newer.
Nebula Terron: I might add the backup function for the data sheet at some point. But its a really big task to do, so i dont see it in the near future. But i do have it in mine for the cold winter nights.
Wu Bei: i can not tell you what that error means, just make sure u are using a office PRO version.
Captain Akachi: No matter how many i add it wont ever be enough, some even request 300. The thing is there are huge formulas behind the calculations, some of then are almost at the limit at what excel can handle in one cell. So its not so much i dont want to , but i would have to redo alot of the calculations in to more than one cell * x-amount of cells, its a nightmare to me :) So im sorry to disappoint you, if only it was so easy to just allow the sheet to expand then i would gladly do it, but its not.
Felstaff Celium: I will look in to why you are getting wrong amount of ore when using standard lasers. But i know for sure that the strip miners are showing correctly. So there most have been some change at some point that i missed, cause i remember a long time beck when i used lasers that it was correct. So i will have a look at it at some point.
Joelixxx: The "How to" manual is not complete cause i lost the original word file :( so i couldn't be bothered to redo it. i think it is possible to convert the pdf back to word, but none of my attempts has worked out very good, so i have kind of given up on it. (maybe someone here knows how to?)
Though your idea of adding data cores to the price isn't bad, i will see if i can add that somehow in a future version.
I have just uploaded the latest version 12,7,6
Thanks again for all your nice feedback. enjoy the new version
I can confirm the t3 problem I listed before is present in both 12.7.6 and 12.7.5.
I downloaded a fresh 12.7.6. Set all skills to 5 on the data tab. Listed 1 "to be build" for a hull on t3 production, and zero'd all the subsystems at top and below. You should be able to see the incorrect missing items problem I described before.
Cheers as always.
|
Gamingloser1
|
Posted - 2011.08.02 20:12:00 -
[20]
On mining tab:
Isk/Hr is not working for Mercoxit
I purchased 250 spodumain in Jita- In game perfect refining of Spodumain yields:
140 Megacyte
410 Pyerite
3190 Tritanium
|
|
|
Gamingloser1
|
Posted - 2011.08.20 18:44:00 -
[21]
Originally by: Dedaf
Originally by: Gamingloser1
On mining tab:
Isk/Hr is not working for Mercoxit
I purchased 250 spodumain in Jita- In game perfect refining of Spodumain yields:
140 Megacyte
410 Pyerite
3190 Tritanium
Thanks a lot for clearing it out, i couldnt understand why they would change it back.
About the mercoxit, you need to select a skiff and modulated deep core mining laser for it to count. i believe you can only mine mercoxit like that. That is why it doesnt count when u have ex a Hulk with 3 lasers, cause then the mining pr/hour would be off.
Or am i wrong? can you mine it with other setups?
FYI: I purchased a hulk in Jita and fitted a modulated deep core strip miner II to the ship. I'm not sure how the calculations work out, but it appears that you can mine that ore with a hulk.
|
|
|
| |
|