| Pages: [1] 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 .. 19 :: one page |
|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Dedaf
United Brothers Of Eve
Seventh Sanctum.
1
   |
Posted - 2011.09.09 18:32:00 -
[1] - Quote
Hi
I have tried to build a industrial tool that covers most of EVE-Online's industry.
You will find tools for mining, building T1, T2, T3, Capitals and Rigs, and latest the Planet interaction
Latest:
The Capital sheet has had a makeover, you now have 5 slots instead where any capital ship can be build from.
The sheet is build in MS office 2010, so users of 2003 and earlier office versions needs to download Microsoft Office Compatibility Pack
Download: Version 12,8,1
Mediafire or EVE files
HowTo manual 1,7
In this sheet you will find the following Industrial tools:
- Ore Mining
- Ice Mining.
- Ore to mine, calculated from mineral-need.
- Ice to mine, calculated from fuel-need.
- Ore Corp Mining calculator.
- Ice Corp Mining calculator.
- Planet Interaction
- POS Fueling/Reaction.
- T1 Ship, items & Rig Production.
- T2 Ship, Items & Rig Production.
- Tech III production.
- Capital Production
- Jump Freighter production
To upload your oven skills to this sheet, do like this.
1st. log in to this forum
2nd. click this link APIKEY site
3th. Enter the ApiKey and UserID in to the sheet, then click update. Thats it
The XML price and skill update is supported only in Office 2003-2010 Pro.
Office 2003 and earlier, needs to download Microsoft Office Compatibility Pack
Open office do not support direct XML update
Anyway let me know what you think of it or maybe even new idea's, ofcause isk donations is always appreciatedVery Happy
enjoy
NB: Don't Update prices every 5min, then you will be blocked by the firewall. Ones a day should be enough.
FAQ.
1) Which API key does this sheet require?
Normally you only need the simple API key, this key can be used for skills and price updates.
You only need the full API key if you need to import your CORP towers to the POS production sheet, for monitoring the towers fuel.
2) When I click update, my skills are not upgraded?
You need Microsoft Office 2003pro 2007pro or 2010pro to use the API skill import.
Open Office or none Pro MS office version, do not support XML import, therefore you can not do import of skills or price information when using OpenOffice or none Pro. MS office, but you do have the option to enter skills and price info manually.
3) Why do I get the error: This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.
Your Excel ActiveX security is too high. You have 2 options, either lower the security or put the sheet in to a trusted folder.
opt.1 Activex link
opt.2 Trusted folder link
4) My CORP TowerGÇÖs are not listed in the POS production sheet?
To be able to see you CORP towerGÇÖs in the POS production sheet, then you need 2 things.
- You need the full API key, the simple key is not enough.
- You need to be Director or CEO
OLD forum post |
themaker1971
Neutral Industries L8
0
|
Posted - 2011.09.09 22:22:00 -
[2] - Quote
Well done on a great program. :) |
Type Mismatch
Hedion University
Amarr Empire
0
|
Posted - 2011.09.10 12:24:00 -
[3] - Quote
Are POS modules such as silos and towers inculded in the manufacturing sheets? I could not find them but i may just be blind. Superb tool anyways, thanks for sharing it. |
Roland Schlosser
THE EXOGEN CONSORTIUM
0
|
Posted - 2011.09.10 17:51:00 -
[4] - Quote
Hands down the best spreadsheet I've ever had the pleasure of working with  |
Dedaf
United Brothers Of Eve
Seventh Sanctum.
1
|
Posted - 2011.09.10 18:50:00 -
[5] - Quote
Type Mismatch wrote:Are POS modules such as silos and towers inculded in the manufacturing sheets? I could not find them but i may just be blind. Superb tool anyways, thanks for sharing it.
You will find those items in the Planet interaction tool. The reason for this is, that they do not using standard minerals to build but Planet material. Scroll down to cell D72 and select Tower or array's. |
ICU Andshutup
Science and Trade Institute
Caldari State
0
|
Posted - 2011.09.12 15:26:00 -
[6] - Quote
Great tool Dedaf!! I have not experimented yet, but do the new API keys work? |
Dedaf
United Brothers Of Eve
Seventh Sanctum.
3
|
Posted - 2011.09.18 20:33:00 -
[7] - Quote
ICU Andshutup wrote:Great tool Dedaf!! I have not experimented yet, but do the new API keys work?
Im working on correcting the sheet so it will run with the new API keys. I have it working already, but i just want to add some more features before releasing it. I will upload it in a few days, or at least before the old key's stop working.
Enjoy |
stavrious
Plovdiv Inc
0
|
Posted - 2011.09.20 08:57:00 -
[8] - Quote
nicely done dedaf. i think i ll be using this a lot |
Dusty Meg
Redbull Air Race Inc
0
|
Posted - 2011.09.30 10:26:00 -
[9] - Quote
Just wondering how the updates going with having the new keys put in? Other then that great spreadsheet been using it for ages now and barely had any problems with it.
Ow and the evelopedia article needs updating to this new thread. |
Dedaf
United Brothers Of Eve
Seventh Sanctum.
7
|
Posted - 2011.09.30 16:46:00 -
[10] - Quote
Dusty Meg wrote:Just wondering how the updates going with having the new keys put in? Other then that great spreadsheet been using it for ages now and barely had any problems with it.
Ow and the evelopedia article needs updating to this new thread.
H, good to hear you like the tool. The new Key is working great already, i just wanted to add the option of a 2nd character API to the sheet. This is what takes a bit longer than expected. But im almost there now, my goal is to release a new version this weekend.
Dedaf |
|
|
Raziphan Rebular
Perkone
Caldari State
0
|
Posted - 2011.10.01 02:16:00 -
[11] - Quote
Does this work in open office? |
Wa'roun
Quantum Cats Syndicate
8
|
Posted - 2011.10.02 07:21:00 -
[12] - Quote
Sinq Laison is not in the region list |
Dedaf
United Brothers Of Eve
Seventh Sanctum.
11
|
Posted - 2011.10.02 09:09:00 -
[13] - Quote
Wa'roun wrote:Sinq Laison is not in the region list (home to Dodixie).
Hi Wa'roun
It is in the list, it it just because i put the 3 most used regions in the top, so people wont have to scroll so much.
Since The Forge is listed in the sheet by default, then Essence and Sinq Laison will be in the list a bow it, so just scroll up in the list and you will find it :)
I will upload a new version with the new API key and other nice things today.
Dedaf
|
Wa'roun
Quantum Cats Syndicate
9
|
Posted - 2011.10.02 09:29:00 -
[14] - Quote
I was scrolling by alphabetical order.
I guess I am weird. |
Dedaf
United Brothers Of Eve
Seventh Sanctum.
11
|
Posted - 2011.10.02 20:13:00 -
[15] - Quote
I finally completed the sheet to be released with the new API key system of INCARNA.
You are now able to upload 2 character APi keys and 1 Corp API key.
And also i have build a backup/restore option for the DATA sheet, so in future version of this tool you will be able to restore you API keys and market info, that you have entered in the DATA sheet of the old version.
New Version 14
Enjoy guys
|
ICU Andshutup
Science and Trade Institute
Caldari State
0
|
Posted - 2011.10.03 19:53:00 -
[16] - Quote
With v14 I am getting an XMP Parse Error when I try to add my characters into the data sheet. Runtime Error '-2147217376 (80041020)'
Tis odd as I am doing it the same way that previous sheets took it |
M Kernel
Karma Tec
Intrepid Crossing
0
|
Posted - 2011.10.04 19:51:00 -
[17] - Quote
Hey!
Great Work with the new version! I really love this Sheet!
However, there's a small mistake:
On the T2 Items Sheet, Minerals in Stock, it says "Importet from T1 Production Sheet", but it is not!
On the same Sheet, the field "Industrial Character" should be a Dropdown I think.
Also, on the T3 Production Sheet it would be nice if the "Minerals In Stock" would be importet as well!
Keep up the great work! |
Wa'roun
Quantum Cats Syndicate
12
|
Posted - 2011.10.04 20:16:00 -
[18] - Quote
M Kernel wrote:Hey!
Great Work with the new version! I really love this Sheet!
However, there's a small mistake:
On the T2 Items Sheet, Minerals in Stock, it says "Importet from T1 Production Sheet", but it is not!
On the same Sheet, the field "Industrial Character" should be a Dropdown I think.
Also, on the T3 Production Sheet it would be nice if the "Minerals In Stock" would be importet as well!
Keep up the great work!
imported?
|
M Kernel
Karma Tec
Intrepid Crossing
0
|
Posted - 2011.10.04 20:22:00 -
[19] - Quote
imported ;-) |
Dedaf
United Brothers Of Eve
Seventh Sanctum.
13
|
Posted - 2011.10.06 05:06:00 -
[20] - Quote
M Kernel wrote:Hey!
Great Work with the new version! I really love this Sheet!
However, there's a small mistake:
On the T2 Items Sheet, Minerals in Stock, it says "Importet from T1 Production Sheet", but it is not!
On the same Sheet, the field "Industrial Character" should be a Drop-down I think.
Also, on the T3 Production Sheet it would be nice if the "Minerals In Stock" would be importet as well!
Keep up the great work!
Hi M Kernel
Thank you for the idea's with the linking of minerals in stock to the t1 sheet. It a thing i have been thinking about doing. But it limits the user to having only one stock of minerals, so i cant decide if i want to do it. The note in the t2 item sheet saying that is importing from t1 is a leftover from when i build it i guess, cause its not meant to do it. So i removed the note.
you write about a problem with the drop-down menu for selecting characters in the t2 item sheet? i don't see the problem, i have the drop-down in my sheet.
Anyway, im glad you like the sheet and you are always welcome to submit idea's and bugs.
Dedaf |
|
|
M Kernel
Karma Tec
1
|
Posted - 2011.10.06 07:38:00 -
[21] - Quote
Hey Dedaf
Ah, makes sense... My Industry Branch is too small to have multiple Mineral Stocks ;-)
As with the Dropdown: Checked again, they're working indeed... Must have been asleep :O
Anyway, thanks for the Feedback! |
FootyMD
Rig's industry
0
|
Posted - 2011.10.07 17:01:00 -
[22] - Quote
So i have Microsoft 2010 pro plus, and i am still unable to update my skills or input them.
Any ideas? is it anything to do with the new api system? |
M Kernel
Karma Tec
1
|
Posted - 2011.10.07 17:20:00 -
[23] - Quote
FootyMD wrote:So i have Microsoft 2010 pro plus, and i am still unable to update my skills or input them.
Any ideas? is it anything to do with the new api system?
Did you use the NEW API-Keys? The ones you have to create manually first... |
FootyMD
Rig's industry
0
|
Posted - 2011.10.07 17:22:00 -
[24] - Quote
M Kernel wrote:FootyMD wrote:So i have Microsoft 2010 pro plus, and i am still unable to update my skills or input them.
Any ideas? is it anything to do with the new api system? Did you use the NEW API-Keys? The ones you have to create manually first...
Yes i did create new ones, but i think may have found the issue. |
Princess Cellestia
Friendship is Podding
Test Alliance Please Ignore
58
|
Posted - 2011.10.11 04:33:00 -
[25] - Quote
A problem I've found is there are things missing, most notably you have the Capital Ship Maintenance Array, but not the Assembly array. Also the meta cap mods, and a few others. Will these be added at some point? |
Jake Dykes
Dakini Rising
0
|
Posted - 2011.10.11 10:31:00 -
[26] - Quote
Dedaf wrote:
Hi M Kernel
Thank you for the idea's with the linking of minerals in stock to the t1 sheet. It a thing i have been thinking about doing. But it limits the user to having only one stock of minerals, so i cant decide if i want to do it. The note in the t2 item sheet saying that is importing from t1 is a leftover from when i build it i guess, cause its not meant to do it. So i removed the note.
you write about a problem with the drop-down menu for selecting characters in the t2 item sheet? i don't see the problem, i have the drop-down in my sheet.
Anyway, im glad you like the sheet and you are always welcome to submit idea's and bugs.
Dedaf
did you change that back in 14? Because I just installed 14 and the T2 Minerals are still greyed out and are linked with the T1 Production sheet.
|
BuntyJ0y
FAUR INDUSTRIES
Nulla Clementia
0
|
Posted - 2011.10.23 10:41:00 -
[27] - Quote
Hi
It seems that is some problem in T1 rig sheet, because when i change BP from original to a BPC with a number of runs and added BPC price is not taken in consideration and addes at final production cost of the rig.
Please check that.
|
Zanban
Stealth Sector
The Revenant Order
3
|
Posted - 2011.10.23 14:19:00 -
[28] - Quote
Dedaf this is a great tool thanks you for your hard work on it.
Have you any plans to make this into a app for iPhones or androids? |
Dedaf
United Brothers Of Eve
Seventh Sanctum.
14
|
Posted - 2011.10.23 17:55:00 -
[29] - Quote
BuntyJ0y wrote:Hi
It seems that is some problem in T1 rig sheet, because when i change BP from original to a BPC with a number of runs and added BPC price is not taken in consideration and addes at final production cost of the rig.
Please check that.
Hi Bontyj0y. very well spotted, i will make sure it is corrected in the next release.
Thanks for bringing it up.
Zanban wrote:Dedaf this is a great tool thanks you for your hard work on it.
Have you any plans to make this into a app for iPhones or androids?
Hi zanban
Im very happy you like the program. To be honest i haven't thought about it until you bring it up. But its diffidently something i will look in to if there is a market for it. I'm not sure how user able it will be on the small screen. But its a good idea. |
Don Tiberon
The Home Depot
0
|
Posted - 2011.10.30 01:32:00 -
[30] - Quote
Dedaf
as always you are the best. i truly love your program.
Now to business. under the capital production tab there is a question i am hoping you can shine a light on.
Using Titan -> Erebus me 0 as example: you will notice that it requires 550 units of jump bridge arrays as one of its required components. You see it up top with everything else that is needed to create one but towards the bottom it does not show up in red like the others. is this a glitch? line 146 to be exact does not show the 550 units in red.
Let me know would ya
Thanks
Don Tiberon |
|
|
|
|
| |
|
| Pages: [1] 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 .. 19 :: one page |
| First page | Previous page | Next page | Last page |