EVE Search - [EvE] Excel Sheet Production/Mining/Combat

Check My IP Information

All Channels

EVE General Discussion

[EvE] Excel Sheet Production/Mining/Combat - v1.21

» Click here to find additional results for this topic using Google

Monitor this thread via RSS [?]

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



Pages: [1] 2 3 4 :: one page
First page \| Previous page \| Next page \| Last page

COPYRIGHT NOTICE
EVE Online, the EVE logo, EVE and all associated logos and designs are the intellectual property of CCP hf. All artwork, screenshots, characters, vehicles, storylines, world facts or other recognizable features of the intellectual property relating to these trademarks are likewise the intellectual property of CCP hf. EVE Online and the EVE logo are the registered trademarks of CCP hf. All rights are reserved worldwide. All other trademarks are the property of their respective owners. CCP hf. has granted permission to EVE-Search.com to use EVE Online and all associated logos and designs for promotional and information purposes on its website but does not endorse, and is not in any way affiliated with, EVE-Search.com. CCP is in no way responsible for the content on or functioning of this website, nor can it be liable for any damage arising from the use of this website.