| Pages: 1 2 3 4 :: [one page] |
|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Dragonol
   |
Posted - 2005.12.31 22:33:00 -
[1]
The Complete Excel Sheet v1.21
-This spreadsheet is currently protected.
--You can only modify blue cells
--FormulaÆs are hidden
-Has 9 different sheets used for:
--Mining
--Production
--Combat
--Refining
-I would like anyone who wants to try this out to report back on any errors found.
--grammar
--spelling
--formula/calculation
--format
-Also, please let me know how I can improve the spreadsheet.
--adding new sheets.
--improving existing sheets.
--et cetera
Any help and/or suggestions would be great.
Download Here
-Enjoy the spreadsheet!
-Dragonol-
______________________________________
-Director of Production-
-Universal Exports- |
DeathOnAStick
|
Posted - 2005.12.31 22:49:00 -
[2]
looks good but cant enter any figures in cos its all protected.
|
Dragonol
|
Posted - 2005.12.31 22:51:00 -
[3]
Edited by: Dragonol on 31/12/2005 22:52:22
You should be able to modify all cells that are shaded blue. All other cells are protected.
*Edit: For example: you should be able to change the prices for minerals, etc, but not the actual mineral name.
______________________________________
-Director of Production-
-Universal Exports- |
DeathOnAStick
|
Posted - 2005.12.31 22:52:00 -
[4]
blue ones too at least for me
|
Dragonol
|
Posted - 2005.12.31 22:54:00 -
[5]
Edited by: Dragonol on 31/12/2005 22:55:54
Hmmm, In all sheets? (all tabs?)
Edit: Can anyone else modify the blue cells?
______________________________________
-Director of Production-
-Universal Exports- |
DeathOnAStick
|
Posted - 2005.12.31 22:59:00 -
[6]
 Originally by: Dragonol
Edited by: Dragonol on 31/12/2005 22:55:54
Hmmm, In all sheets? (all tabs?)
Edit: Can anyone else modify the blue cells?
yup cant edit any
|
DeathOnAStick
|
Posted - 2005.12.31 23:01:00 -
[7]
screenshot
Linkage
|
DeathOnAStick
|
Posted - 2005.12.31 23:04:00 -
[8]
Edited by: DeathOnAStick on 31/12/2005 23:04:31
excel 97 used other types of sheets that do the same sort of thing and are protected too
|
Dragonol
|
Posted - 2005.12.31 23:04:00 -
[9]
Ah, It could be your version of excel. It might not support the "Allow users to edit ranges.." function. When was your excel released?
______________________________________
-Director of Production-
-Universal Exports- |
Dragonol
|
Posted - 2005.12.31 23:06:00 -
[10]
Edited by: Dragonol on 31/12/2005 23:08:15
Link removed.
______________________________________
-Director of Production-
-Universal Exports- |
|
|
DeathOnAStick
|
Posted - 2005.12.31 23:07:00 -
[11]
excellent. Thanks works a treat
|
Stylez Gomez
|
Posted - 2006.01.01 00:23:00 -
[12]
Great spreadsheet!
I think I may have found a problem, though it could be an error on my part.
I'm having problems with the Mining Calculator sheet. I entered 10 names, and just plugged in some random numbers into mineral amounts and mining times. It calculates the ISK share for the first person okay, but the next 2 cells contain "0" in the first one, and "#VALUE!" in the second. The next cell has a correct ISK Share, then the next 2 are screwy like the others. This pattern repeats down the list.
This is just a problem I found when playing with the sheet, I wasn't entering any "actual" data. 
I'm using MS Office 2003.
|
Dragonol
|
Posted - 2006.01.01 00:36:00 -
[13]
Edited by: Dragonol on 01/01/2006 00:36:11
Thank for your input. Both problems should not be fixed. Link updated. =)
-Dragonol
______________________________________
-Director of Production-
-Universal Exports- |
Obi'yer
|
Posted - 2006.01.01 01:08:00 -
[14]
The ship calculator is great. I'm new but it's the first time I've ever seen a DPS tool. Thank you for releasing it to the community.
|
Dragonol
|
Posted - 2006.01.01 01:29:00 -
[15]
Yeah, I just threw stuff into that ship calculator sheet (there could be moreà). I think my next task should be to add more to the DPS section and maybe calculators for different combat areas. I didn't want to get skills involved (where you have to select your skill levels). In my opinion, the more values the user has to change and refer to his character sheet, the more likely he will stick to his trusty hand calculator.
If you guys/gals think adding skills wouldn't make a huge hassle for the user, I can implement that.
(For example: Select your missile skill levels, etc... and it will output the amount of damage a selected launcher/ammo would do. OR adding a refining calculator that you have to input your skill levels and standings into?)
______________________________________
-Director of Production-
-Universal Exports- |
Raymos
|
Posted - 2006.01.01 02:27:00 -
[16]
Edited by: Raymos on 01/01/2006 02:33:05
Nice tool
While morphite prices are listed and editable on the prices sheet, there is no morphite listed on the build calculator sheet(s).
edit-(NM, it's listed on the T2 side)
I do like it though, thank you for sharing it.
|
Peter Armstrong
|
Posted - 2006.01.01 02:59:00 -
[17]
Great sheet but i cant edit too asking for Password
|
Dragonol
|
Posted - 2006.01.01 03:02:00 -
[18]
Aye, no problem. As for the morphite - The tech 1 side of the build sheet is for the tech 1 variant of the module or ship you are building. The tech 2 side is what you would need to turn that T1 item into a T2 item. (For Example: The build requirements for a Rupture go into the left side (where only minerals are), and the requirements for the Muninn go under the right side. The total build is the price of both the T1 variant and the T2 materials.) Hope that explain my thought process :).
______________________________________
-Director of Production-
-Universal Exports- |
Dragonol
|
Posted - 2006.01.01 03:03:00 -
[19]
@Peter - You cannot change any of the blue-shaded cells? (Excel date please?)
______________________________________
-Director of Production-
-Universal Exports- |
Peter Armstrong
|
Posted - 2006.01.01 03:05:00 -
[20]
Originally by: Dragonol
@Peter - You cannot change any of the blue-shaded cells? (Excel date please?)
umm Excel 2000 and yer blue.
|
|
|
Dragonol
|
Posted - 2006.01.01 03:07:00 -
[21]
Are you in game right now?
______________________________________
-Director of Production-
-Universal Exports- |
Basada
|
Posted - 2006.01.01 06:29:00 -
[22]
I can modify in Excel 2003
|
Mysticaa
|
Posted - 2006.01.01 07:37:00 -
[23]
Edited by: Mysticaa on 01/01/2006 07:42:32
Nice :)
How about adding some ice stuff on there as well :)
*Edit*
Also on the POS setup page - How about letting us chose which control tower we want to use. Right now only Minmater control tower is available.
|
Dragonol
|
Posted - 2006.01.01 08:07:00 -
[24]
Edited by: Dragonol on 01/01/2006 08:07:41
Will add both tomorrow. Tis 3:07, and I'm off to bed. =S
______________________________________
-Director of Production-
-Universal Exports- |
Dragonol
|
Posted - 2006.01.01 18:04:00 -
[25]
Added ice refining sheet.
Working on the other 3 POS types and related structures.
~Enjoy~
-Dragonol-
______________________________________
-Director of Production-
-Universal Exports- |
Komisches
|
Posted - 2006.01.01 18:27:00 -
[26]
Looks good. Haven't used it yet. But will attempt that next time i need to cost something out.
Any possibility of only having the mineral prices on one page instead of just about every page? That's something that we added into the spreadsheet that i usually use - get's annoying after a while if you have to change mineral prices on 9 sheets :( (Plus, that spreadsheet only deals with ship construction).
More later.
---
|
Luther Kincaid
|
Posted - 2006.01.01 20:01:00 -
[27]
Nice! that'll definately come in handy! well done!
Luther
|
Hunter Lightspeed
|
Posted - 2006.01.01 20:20:00 -
[28]
Thanks man, like so many other i¦ll need to figure out what to fly after they frelled up my gankageddon setup  DPS calcutator sure comes in handy.
|
Dragonol
|
Posted - 2006.01.01 21:34:00 -
[29]
@Komi -> There are prices on 9 different sheets, but you only modify the "Prices" sheet. Changing those values changes every other price in the spreadsheet. The one page controls them all =). The prices on other sheets are protected, and cannot be modified.
______________________________________
-Director of Production-
-Universal Exports- |
Juwi Kotch
|
Posted - 2006.01.01 22:46:00 -
[30]
Does it work with OpenOffice?
Juwi
|
|
|
BillyBong2
|
Posted - 2006.01.02 00:35:00 -
[31]
Excell 2000 and I can not edit the prices page.
Siggy by Esturary |
Dragonol
|
Posted - 2006.01.02 01:14:00 -
[32]
Open office:
I cannot currently check to see if OpenOffice does work. I sent you a different excel sheet in game, let me know if it works. I'm going to download and install OO to see if it can be used.
@BillyBong:
I sent you a different sheet in game. Your excel should let you modify the values now.
______________________________________
-Director of Production-
-Universal Exports- |
Alexei Djukov
|
Posted - 2006.01.02 01:41:00 -
[33]
Mmm, looks nice, but you've missed a few things...
For example, your capacitor and shield regeneration calculations are incorrect, as it's not linear....it changes based on how full your ships capacitor/shield is.
Your reprocessing sheet does not support any of the new rocks...only the base versions.
Your POS calculations..what if someone wanted to do something crazy like..stick the wrong race guns on?
It needs some work, but it looks like a good start.
Feel free to look at the way I've solved some of the issues when I've made my own sheet <points down to sig for download link>
-----
My Excel Sheet
Black Lance Forums |
Dragonol
|
Posted - 2006.01.02 04:32:00 -
[34]
For example, your capacitor and shield regeneration calculations are incorrect, as it's not linear....it changes based on how full your ships capacitor/shield is.
-I didn't really want to calculate the actual cap recharge during each step of the way. I used the formula to calculate it at peak.
Your reprocessing sheet does not support any of the new rocks...only the base versions.
- I used a 5% increase on all ore values to take the average between standard ore and rich ore (+10%). It is not meant to include normal, +5% and +10% ore types, otherwise the sheet starts to get overcrowded with three times the amount of rows it has now.
Your POS calculations..what if someone wanted to do something crazy like..stick the wrong race guns on?
-Putting the wrong guns on will not give you the control tower bonuses for those guns. (If applicable) I could include all structures on each sheet, but then we get into the crowded issue again. It is possible that someone might want to stick amarr lasers on a minmatar control tower - but that is asking for those freedom fighters out there to come and blow up your POS. If people request the ability (majority) û I can add it.
-> Thanks for your advice though.
I'm not sure if I should change it to the 3 ore types, etc... If that needed by the people using it û it can be done.
______________________________________
-Director of Production-
-Universal Exports- |
Peter Armstrong
|
Posted - 2006.01.02 13:44:00 -
[35]
mm weird i cant find it on com and when i look back on down load its not there anymore. can i have it again?
Dark Skyes Website Under Construct |
Laticia
|
Posted - 2006.01.02 16:33:00 -
[36]
Originally by: Dragonol
Open office:
I cannot currently check to see if OpenOffice does work. I sent you a different excel sheet in game, let me know if it works. I'm going to download and install OO to see if it can be used.
@BillyBong:
I sent you a different sheet in game. Your excel should let you modify the values now.
can¦t edit the blue cell¦s with Open Office 2.0 /
Star Office 6
popup message: ¦blocked cell¦s can¦t be changed.
Laticia
|
Dragonol
|
Posted - 2006.01.02 23:29:00 -
[37]
@Peter and Laticia
-You should both have eve-mails, make sure you check them. =)
-Dragonol
______________________________________
-Director of Production-
-Universal Exports- |
Juwi Kotch
|
Posted - 2006.01.04 13:40:00 -
[38]
Could not go online earlier and the link you sent does not work anymore... Anything new about your tableau and OpenOffice?
Juwi
|
Juwi Kotch
|
Posted - 2006.01.04 13:59:00 -
[39]
Just downloaded the standard excel file now and opened it with OpenOffice. This tables are huge! Did a bit testing and so far everything worked, but do not have the time right now to thoroughly test it. Where should I look for malfunctions?
Juwi
|
Dragonol
|
Posted - 2006.01.05 06:28:00 -
[40]
Here's the newest version that works with old excels and should work with OO.
::: http://www.sitesled.com/members/darkspace/EvE_Excel/unproComplete_Excel_Sheet_v1.23.xls :::
If you're looking for errors, I would look at anything wrong with the cruiser and battleship sheets. Calculations are also a source of error, even missing a single "$" could mean the entire column is off.
______________________________________
-Director of Production-
-Universal Exports- |
|
|
Principe
|
Posted - 2006.01.05 07:49:00 -
[41]
cool, hopefully your formulas are correct 
----------------------------------------------
Support the superior Khanid technology
----------------------------------------------
[IMG]http://www.darkmagician.co.uk/images/sigs/principesig.jpg[/ |
Fridge oblivion
|
Posted - 2006.01.05 10:46:00 -
[42]
Nice tool but I miss many options to fit out a POS, Silos and moon harvesters seem to be missing as well as laser batteries and such.
Will there be an update?
When I was young I wanted to be me, my childhood dream came true |
Dragonol
|
Posted - 2006.01.06 03:35:00 -
[43]
The requests have been added to the sheet. I hope it is what you wanted, if not, feel free to post again. =)
______________________________________
-Director of Production-
-Universal Exports- |
Dragonol
|
Posted - 2006.01.06 15:10:00 -
[44]
Added a new "Trading Route Calculator" sheet. Let me know if it is useful. I can add or make changes as people bring new idea's to me. Thanks...
-Dragonol
______________________________________
-Director of Production-
-Universal Exports- |
Glassback
|
Posted - 2006.01.06 15:18:00 -
[45]
The Ore refine calculator doesnt have Mercoxit.
I havnt read the other posts, so sorry if I've missed it.
G.
I've got an idea--an idea so smart that my head would explode if I even began to know what I'm talking about
|
Dragonol
|
Posted - 2006.01.07 15:30:00 -
[46]
Edited by: Dragonol on 07/01/2006 15:31:33
Mercoxit added - I would have never guessed that a mercoxite miner would be using the sheet. If you need more exact values (such as a row for each level of ore (5%, 10%, normal) - Let me know.
______________________________________
-Director of Production-
-Universal Exports- |
Dragonol
|
Posted - 2006.01.07 20:44:00 -
[47]
If you are getting a "do you want to link this to another", or "update from another excel doument" message, please download the new excel document, and delete the old one.
______________________________________
-Director of Production-
-Universal Exports- |
Retsil Evad
|
Posted - 2006.01.09 05:29:00 -
[48]
When will the link be back up?
|
Peter Armstrong
|
Posted - 2006.01.09 06:32:00 -
[49]
Hey i have an Idea. I think the sheets great but i was thinking on the mining Share calculator! have on for the Corp share as well. Like i put 10% corp taxs and takes it out on money before it splite to the people? or also have on for 10% take out of minerals for corp etc? u see where i coming from?
Just a few ideas i thought i give. I dont have a clue how to use excel so i dont know
Dark Skyes Website Under Construct |
FreeHansje
|
Posted - 2006.01.09 07:49:00 -
[50]
So where can I download? I see no link to this tool. Been on the site, can't find it there either...
-----
FreeHansje
Yes, I'm a Newby. So sue me! |
|
|
Dragonol
|
Posted - 2006.01.11 00:49:00 -
[51]
Edited by: Dragonol on 11/01/2006 00:53:00
Link back up!!
Sorry for the downtime, the hosting service had a large number of uploads and their servers went down. I have made changes to reflect what people want up to this point. I will continue to update the sheet.
Another note: The missile DPS calculator has been deleted from the sheet at some point, and will be added again - soon.
P.S. - The corp share has been added. No value needs to be put in, but if the corp does get something, please enter the number as if it were the percent. ( Example: "20" for 20%, without the quotes.) - Don't include the "%" sign.
Enjoy!
-Dragonol-
______________________________________
-Director of Production-
-Universal Exports- |
Lord Flashheart
|
Posted - 2006.01.12 18:01:00 -
[52]
Hi dragnol and thanks for the sheet - already found very useful
A thought...
As we are primarily a mining corp and we pay our members for ORE before refining, would it be possible to add an ORE section to the group mining page? Along with this if there was a ORE price section in blue cells like the mineral prices then it would save on having to recalculate via the ore refining sheet...
Just a thought :)
Flash
|
Dragonol
|
Posted - 2006.01.12 22:05:00 -
[53]
Could add that. What would make the entire process easier would be:
-linking the ore prices with the ore refine sheet, so when you modify the mineral prices on the prices sheet, the ore prices change, which also change the mining shares.
Mineral Prices will influence the price per unit of ore. The cells which contain the price per unit of ore will be directly linked to the mining share calculator.
I can start working on adding this. :) - soon.
-Dragonol
______________________________________
-Director of Production-
-Universal Exports- |
Essence Region
|
Posted - 2006.01.12 23:11:00 -
[54]
nice sheet :)
dunno if you're aware (couldn't see anyone else mention) you missed out Crokite from the ores for refining.
|
Dragonol
|
Posted - 2006.01.13 23:27:00 -
[55]
Crokite added and ore added to group share calc. Fixed some calculations and added the missile dmg calc again. Enjoy.
-Dragonol
______________________________________
-Director of Production-
-Universal Exports- |
Dragonol
|
Posted - 2006.01.19 21:13:00 -
[56]
Fixed a forumla and added the days to build all runs of any production item on the Build Cost sheet.
______________________________________
-Director of Production-
-Universal Exports- |
StinkFinger
|
Posted - 2006.01.20 01:59:00 -
[57]
Anyone have a excel with the mineral value of most if not all modules?
--
|
Flyhard
|
Posted - 2006.06.19 10:39:00 -
[58]
Seems like the link is down again....
|
Splagada
|
Posted - 2006.06.19 10:41:00 -
[59]
if you want it hosted on eve-corps.net
just evemail me
-
Member of [AAST]
Owner of eve-corps.net
evemail me if you need a free forum for your corp
|
Idara
|
Posted - 2006.06.19 11:44:00 -
[60]
Aww...I wanted to DL this this morning...
|
|
|
Dragonol
|
Posted - 2006.06.27 12:56:00 -
[61]
Edited by: Dragonol on 27/06/2006 12:57:04
Didn't think anyone still wanted it :( - Sniff* sniff*...
Here ya go:
Excel Sheet v1.235
--* While re-uploading, I've fixed some things contained in the sheet, (on the BS tab). Seemed the BPC cost wasn't adding correctly. *--
______________________________________
-Universal Exports- |
Idara
|
Posted - 2006.06.27 13:09:00 -
[62]
OOh..DL now...
|
Dragonol
|
Posted - 2006.06.27 13:11:00 -
[63]
Edited by: Dragonol on 27/06/2006 13:12:37
Don't be dissapointed :P
- I have also eve-mailed everyone who posted for the link to be put up again.
-Dragonol
______________________________________
-Universal Exports- |
Dragonol
|
Posted - 2006.06.27 13:19:00 -
[64]
Hmmm... Just occurred to me..
If you want to calculate a certain ME level from the eve-online site (which are perfect builds at ME infinate :P).
Goto the "ME&PE Calculator" page, and view the chart...
use those waste percentages to add onto 100%. I'll show below.
Waste Percentage Chart
Waste % / ME Level
10.00% / 0
5.00% / 1
3.33%/ 2
2.50%/ 3
2.00%/ 4
1.67%/ 5
1.43%/ 6
1.25%/ 7
1.11%/ 8
0.91%/ 10
0.77%/ 12
0.67%/ 14
0.59%/ 16
0.53%/ 18
0.48%/ 20
Add the above percet for the ME you want to 100%, so for Ex, take ME 5.
Add 100% + 1.67% = 101.67% and divide by 100. This decimal can then be used to multiply the perfect build mineral values to get the modified waste builds.
10000 trit perfect build X 1.0167 = 10167 Trit to build it, wasting 167 trit.
Round to nearest "one" place holder when doing this.
______________________________________
-Universal Exports- |
Therem Harth
|
Posted - 2006.06.27 16:56:00 -
[65]
Nice tool. You probably want to add a "sovereignity" checkbox on all POS calculators to account for sov-holding savings in fuel.
--
|
Dragonol
|
Posted - 2006.07.02 13:38:00 -
[66]
I might be able to do that. Not too familar with the internal functions of Excel, but it seems simple enough, where I can just say "If True, Perform 0.75x Fuel Values.
______________________________________
-Universal Exports- |
Dragonol
|
Posted - 2006.07.05 01:12:00 -
[67]
Added:
-Freighter sheet
-Dread sheet
-Capital Components sheet.
-- Now you get to see the real price of a freighter --
-- Download to find out how much the markup is, and how much profit can be made --
-Dragonol-
______________________________________
-Universal Exports- |
Dragonol
|
Posted - 2006.07.05 14:58:00 -
[68]
Edited by: Dragonol on 05/07/2006 14:58:33
Added Carriers to it, as well as the extra capital components needed to produce them.
______________________________________
-Universal Exports- |
Dragonol
|
Posted - 2006.07.07 14:17:00 -
[69]
Fixed several issues:
-Issues:
-Fixed Large POS power formula, it wasn't showing the correct usage.
-Fixed missile range and damages on the ship calculators.
-Added some mining calculations for percents instead of time. (3 spaces)
______________________________________
-Universal Exports- |
Levi Calthian
|
Posted - 2006.07.07 14:42:00 -
[70]
i am unable to download the file
|
|
|
Eli Cardassa
|
Posted - 2006.07.08 00:08:00 -
[71]
Same here, the link seems to be dead.
__________________________________________
|
Dragonol
|
Posted - 2006.07.08 04:02:00 -
[72]
Should be back up, sorry about that. There was a problem with having brackets in a link. Eve-mailed both of the above with the link.
______________________________________
-Universal Exports- |
Dragonol
|
Posted - 2006.07.08 04:08:00 -
[73]
Also - If anyone has a problem, feel free to contact me in-game to tell me about the situation.
I check the boards once a day or so but if you need the sheet, let me know and I can fix it right away.
-Dragonol-
______________________________________
-Universal Exports- |
Diverse Diver
|
Posted - 2006.07.12 11:52:00 -
[74]
Escellent mate I use it every day, please continue as this is a very valuable tool.
BTW do you know of anything that has the up to date prices of the components of ICE once it is refined? Something like the Matari index would be marvellous.
Cheers DD
|
Dragonol
|
Posted - 2006.07.14 01:55:00 -
[75]
Not that I know of. However, one of that nature would require more work than a mineral index. Alts would either have to be placed in 2 regions of each race, or there would have to be an update by a single person flying around EvE. Ice fields in the regions would vary, and would require a check for all four races, and 2-3 regions for accuracy.
:) - My response.
______________________________________
-Universal Exports- |
Quick Bid
|
Posted - 2006.12.19 04:58:00 -
[76]
Have any newer versions of this been produced since July? I'm hoping to see something with the new ship types since Rev.
-Q
|
Zugor Ikatin
Synergy.
Imperial Republic Of the North
|
Posted - 2006.12.30 00:21:00 -
[77]
^^ Exactly what he said.
------------------------------------------------------------
"We that are strong ought to bear the infirmities of the weak but not to please ourselves." - Romans 15:1 |
Dragonol
Minmatar
Universal Exports
Namtz'aar k'in
|
Posted - 2007.01.06 18:50:00 -
[78]
Will get on it :P (I guess).
Need to get on the other computer for excel, will have it done soonish.
-Dragonol
______________________________________
-Universal Exports- |
Dragonol
Minmatar
Universal Exports
Namtz'aar k'in
|
Posted - 2007.01.06 19:00:00 -
[79]
OK list of changes planned:
-An ME space above every print, so you can manually enter in the ME you want to use (instead of a constant 10 / 20)
-New Battlecruisers and Old.
-New Battleships
Let me know if there's anything else.
______________________________________
-Universal Exports- |
Rakeris
Legio VIII
|
Posted - 2007.01.06 19:08:00 -
[80]
Looking forward to it. ^^
----------
I gave up on sigs. As all the beatings are starting to hurt and leave nasty bruises. |
|
|
Dragonol
Minmatar
Universal Exports
Namtz'aar k'in
|
Posted - 2007.01.06 20:15:00 -
[81]
Edited by: Dragonol on 06/01/2007 20:18:21
Excel Sheet Version 1.3 Revelations
Thanks to Chribba for the host 
Let me know if there's more to add. New errors to.
I would suggest copying the new sheets, just Battleship Builds, Title and Battlecruiser Builds into your excel file, so prices and other modifications you might have made remain. Otherwise, it's ready to go after a quick price update.
-Dragonol
Edit: Made the fixes in Open Office, let me know if it doesn't work well in Excel :).
______________________________________
-Universal Exports- |
Behedwin
RSP Enterprises
|
Posted - 2007.01.06 20:29:00 -
[82]
dont know if there is an error or if i missed something
when using the mining share calculator i fill out my mining teams name. then i fill in the amount of ore we have mined. then i fill out how long eatch member have mined (in minutes). after that i hoped to se how mutch isk eatch person would get... but i dont se that...
but when i try to fill out on the minerals column i get the price per miner info.
-----
-----
Behedwin
Dedicated industrialist
Hard working miner.
|
Dragonol
Minmatar
Universal Exports
Namtz'aar k'in
|
Posted - 2007.01.06 20:36:00 -
[83]
Sent a mail to everyone who has posted so far with the new link. Enjoy.
______________________________________
-Universal Exports- |
Dragonol
Minmatar
Universal Exports
Namtz'aar k'in
|
Posted - 2007.01.06 20:39:00 -
[84]
UH oh, indeed you have found an error. No one download while i fix :P. Thank you for the report.
______________________________________
-Universal Exports- |
Behedwin
RSP Enterprises
|
Posted - 2007.01.06 20:40:00 -
[85]
in the Module/Ship Cost Calculator section. i dont se morphite as an option for the t1 minerals.
-----
-----
Behedwin
Dedicated industrialist
Hard working miner.
|
Dragonol
Minmatar
Universal Exports
Namtz'aar k'in
|
Posted - 2007.01.06 20:46:00 -
[86]
Edited by: Dragonol on 06/01/2007 20:44:38
Hmm, Didn't know tech 1 required morphite. I'll add it.
EvE Files seems to be taking forever to load now :S.
______________________________________
-Universal Exports- |
Behedwin
RSP Enterprises
|
Posted - 2007.01.06 20:48:00 -
[87]
some do afaik and imo t1 means that you only need minerals that you can find frome astroids in belts and morphite can be mined.
-----
-----
Behedwin
Dedicated industrialist
Hard working miner.
|
Dragonol
Minmatar
Universal Exports
Namtz'aar k'in
|
Posted - 2007.01.06 20:58:00 -
[88]
Temporary Link:
File Front Link (TEMP)
______________________________________
-Universal Exports- |
Behedwin
RSP Enterprises
|
Posted - 2007.01.06 21:04:00 -
[89]
when i click the link on the front page i get an error message that tells me "incorect value"
-----
-----
Behedwin
Dedicated industrialist
Hard working miner.
|
Dragonol
Minmatar
Universal Exports
Namtz'aar k'in
|
Posted - 2007.01.07 00:10:00 -
[90]
Which link? In the Excel sheet or the Forum front page?
You mean hyperlinks within the excel sheet? (On the title page)
______________________________________
-Universal Exports- |
|
|
Dragonol
Minmatar
Universal Exports
Namtz'aar k'in
|
Posted - 2007.01.07 00:25:00 -
[91]
Fixed:
-Battleship prices were doubled when entering a build amount.
-Mining shares for ore amounts was fixed.
______________________________________
-Universal Exports- |
Behedwin
RSP Enterprises
|
Posted - 2007.01.07 07:07:00 -
[92]
Edited by: Behedwin on 07/01/2007 07:03:42
i meant the links in the excell file, the links at the first page!
greate work!!
-----
-----
Behedwin
Dedicated industrialist
Hard working miner.
|
Dragonol
Minmatar
Universal Exports
Namtz'aar k'in
|
Posted - 2007.01.15 01:50:00 -
[93]
Edited by: Dragonol on 15/01/2007 01:49:22
Fixed the hyperlink errors on the title page.
Let me know if anything else goes wrong.
Edit: If you have customized already and don't know how to fix the errors, simply right click on the cell(s) that produced the error (one at a time) and click edit hyperlink. From there remove "A1" from the text bar which has caused the error, and double click on the correct sheet within the document. Any problems let me know in game. :)
-Dragonol-
______________________________________
-Universal Exports- |
Behedwin
RSP Enterprises
|
Posted - 2007.01.16 05:58:00 -
[94]
looks nice! good work...
(friendly bump to the top) :)
-----
-----
Behedwin
Dedicated industrialist
Hard working miner.
|
Solid Wilko
Minmatar
Temptation inc.
|
Posted - 2007.02.08 23:07:00 -
[95]
Uber Excel. best ive ever seen!!
- Feature upgrade: Capital ME levels adjustable? cant really use it for much as-is on that part.
- It seems some of the cells on BC¦s ME are faulty, ie they dont "activate" a change in costs.
- Also please add Capital Maintenance array and Capital Assembly Array to your POS configuration tab.
Please do not stop updating this sheet!.
If you need anything let me know.
|
Solid Wilko
Minmatar
Temptation inc.
|
Posted - 2007.02.08 23:07:00 -
[96]
Uber Excel. best ive ever seen!!
- Feature upgrade: Capital ME levels adjustable? cant really use it for much as-is on that part.
- It seems some of the cells on BC¦s ME are faulty, ie they dont "activate" a change in costs.
- Also please add Capital Maintenance array and Capital Assembly Array to your POS configuration tab.
Please do not stop updating this sheet!.
If you need anything let me know.
|
Dragonol
Minmatar
Universal Exports
Namtz'aar k'in
|
Posted - 2007.02.11 21:44:00 -
[97]
Thanks for the error report!!
-------------------
Version "1.3u"
-Fixed Battlecruiser ME cell issues, added ME cells to carrier, freighter, dreadnought and capital component sheets.
-Added the capital maintenance array and the capital ship assembly array to the POS sheets.
-------------------
Let me know if any more bugs are hiding in the sheet.
-Dragonol-
______________________________________
-Universal Exports- |
Dragonol
Minmatar
Universal Exports
Namtz'aar k'in
|
Posted - 2007.02.11 23:15:00 -
[98]
Going to modify an existing program to show almost all of the tech 1 item build prices from an export based on my corporations' mineral prices. Is anyone interested in downloading a program like this?
The system requirements are not friendly because it was intended for my use only. It's an invoice program that can show almost all tech 1 prices for our production. It has a mineral calculator as well....
Program requirements:
-C: Drive
-Internet Access
-.Net Framework 2.0 (or later)
What the program will create in your "c" drive:
a folder named "MineralCalc", It will also create anywhere from 2 to 5 text files, which will take up no more than 100 kilobytes.
If you have any security concerns, let me know.
This does not contain any "malicious" code. It does not access anything besides the export from the internet (updates the text file when you open the program).
Let me know if it sounds "interesting" :).
-Dragonol
______________________________________
-Universal Exports- |
Dragonol
Minmatar
Universal Exports
Namtz'aar k'in
|
Posted - 2007.03.24 18:40:00 -
[99]
Next update coming soon.
- Adding Capital modules, fighters and a total cost sheet.
______________________________________
-Universal Exports- |
Dragonol
Minmatar
Universal Exports
Namtz'aar k'in
|
Posted - 2007.04.09 15:59:00 -
[100]
Update made...
Coming soon:
Rigs!
______________________________________
-Universal Exports- |
|
|
bosCage
|
Posted - 2007.04.12 01:42:00 -
[101]
This is absolutely excellent! Keep up the great work!
|
Dragonol
Minmatar
Universal Exports
Namtz'aar k'in
|
Posted - 2007.04.12 03:45:00 -
[102]
Thanks!
With the help of a sheet user, we've found a small error on the capital ship mineral readouts...
Seems I've ignored the way excel rounds parts when ME comes into play.
Need to edit a large number of formulas, will have it done soon.
(causes up to 3% error in some cases when dealing with ME'd prints.)
-Dragonol-
______________________________________
-Universal Exports- |
Claudia Grant
Gallente
Quantum Synergies
Eternal Rapture
|
Posted - 2007.04.14 16:02:00 -
[103]
Absolutely awesome sheet. Not 2 ways about it.
Once ME is tuned it will be the only sheet I have that can do everything I want.
Dragonol youre a hero
Keep it up!
|
Death's Embrace
Amarr
United Concordia
|
Posted - 2007.04.14 16:46:00 -
[104]
Yay!!! Thanks :D
|
Dragonol
Minmatar
Universal Exports
Namtz'aar k'in
|
Posted - 2007.04.14 21:19:00 -
[105]
Minerals/ME calculations fixed... 1 million isk off on the carriers (non-Mothership).
Will investigate.
-Dragonol-
______________________________________
-Universal Exports- |
Barbaro55a
Caldari
Os Lobos
Ethereal Dawn
|
Posted - 2007.04.23 10:48:00 -
[106]
I love it, you've just saved me hours of trying to remember how to add!
..............................................................................................
We come in peace, FIRE AT WILL! |
Nazdarovie
Minmatar
Macabre Votum
INVICTUS.
|
Posted - 2007.07.12 20:51:00 -
[107]
Will this bve updated to reflect the new mineral compesitions of alloys e.g the zyd nerf?
|
Diverse Diver
The Mighty All Blacks
|
Posted - 2007.09.02 17:27:00 -
[108]
any updates since February matey
Diverse Diver
|
Lunch Money
Teylas Inc.
Rare Faction
|
Posted - 2007.11.25 19:16:00 -
[109]
Edited by: Lunch Money on 25/11/2007 19:16:29
nvm. thx for that nice worksheet
|
Stefx
Gallente
Moons of Pluto
|
Posted - 2007.11.25 19:28:00 -
[110]
Just curious as to why you zip it.
It's 96kB wether zipped or not.
-----------
MOP recruiting Industrialists/miners/traders/missioners/etc |
|
|
Amarr Menza
Amarr
Freelance Co-Operative
|
Posted - 2007.12.01 13:39:00 -
[111]
Hi
you are missing Rocket Fuel - I need this to produce Hellfire Javelin Assault Missiles
Cheers
------
EVE Online Devs Wiki
Triangle Solutions
------ |
Sol Flare
Caldari
Tenth Legion Holdings
Tenth Legion
|
Posted - 2007.12.02 09:39:00 -
[112]
Edited by: Sol Flare on 02/12/2007 09:43:02
Awesome job on the layout and functionality Dragonol!
Noticed there is no Faction POS towers included. Any chance you will include these later?
Not a big deal to personally add them or change existing information for it but I see that as something people will utilize as well.
Thanks for all hard work,
o/
--------------------------------------------------
-=Student of Sun Tzu=- |
Diashi
|
Posted - 2007.12.02 11:34:00 -
[113]
Excellent tool, well done!
|
Freya Runestone
Minmatar
Brutor tribe
|
Posted - 2007.12.02 12:13:00 -
[114]
you do realize just how old this thread is... right?
|
Amarr Menza
Amarr
Freelance Co-Operative
|
Posted - 2007.12.03 01:49:00 -
[115]
Dragonol
I have re-formatted your file a little to make it a little easier on the eye - and used Name referencing. Also used base minerals so the formulas can be constructed correctly, and the user the just has to update the wastage factor instead of all the minerals.
Manufacturing v1.00
At the moment this is only for Modules and Tech 1 Ships as that is all I needed - keep up the good work and hope you find some of the stuff I did useful
------
EVE Online Devs Wiki
Triangle Solutions
------ |
|
|
| |
|
| Pages: 1 2 3 4 :: [one page] |