EVE Search - The old UES thread (from beta to 1.12)

Pages: [1] 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 30 40 .. 43 :: one page
Author	Thread Statistics \| Show CCP posts - 2 post(s)
T'el'Alana Luathin	Posted - 2004.03.31 21:46:00 - [1] Edited by: T''el''Alana Luathin on 03/03/2005 13:49:14 Edited by: T''el''Alana Luathin on 03/03/2005 02:07:16 This is just temporary until I make a new thread. The 2.00 is out! I've sent the people who've patiently been waiting for it.. god it's good to finally have it out. I'm estimating that the next few weeks members will find bugs and have suggestions on how to improve the sheet even further, and I'll do my best to release bugfixes as soon as possible. Then I'll continue developing the other goodies for it :) T. -- always look on the bright side of the cloning facility.
Fubar	Posted - 2004.03.31 22:32:00 - [2] Edited by: Fubar on 21/04/2004 16:26:31 Edited by: Fubar on 31/03/2004 22:33:27 Tel, most of the cells with red backgrounds are protected. Only page that appears ok List of Productions. Edit: Link removed
T'el'Alana Luathin	Posted - 2004.03.31 23:36:00 - [3] lol, ok sorry about that. I've changed it. Check it out now :) -- always look on the bright side of the cloning facility.
Elithiomel	Posted - 2004.04.01 07:06:00 - [4] mineral-ore-owned, cell E15 need to be changed to D15*'basicstats'!E18 --------------------------------------------- Engineers motto; If it doesn't fit, force it. If it breaks it needed replacing anyway.
T'el'Alana Luathin	Posted - 2004.04.01 11:13:00 - [5] Edited by: T'el'Alana Luathin on 01/04/2004 11:19:33 Ok, thanks for catching that. I've fixed and updated the sheet. If anything else, just lemme know. How do you like the excel sheet btw? K. -- always look on the bright side of the cloning facility.
Fubar	Posted - 2004.04.01 18:02:00 - [6] Quote: If anything else, just lemme know. Your results would be more accurate on the mineral-ore owned page if your calculations were: =floor(<number_of_refines><base_mineral_value>(<base_yield>/100)*(1-(<station_fee>/100)),1) Rounding is a problem if done before the final calculation. Is there a circular reference on the production-estimates page?
Orion Yoda	Posted - 2004.04.02 02:49:00 - [7] Hey this is great! thanks. You say you are lying. But if everything you say is a lie, then you are telling the truth. You cannot tell the truth because everything you say is a lie. You lie, you tell the truth ... but you cannot, for you lie.-- Norman the android, "I, Mudd", stardate 4513.3
T'el'Alana Luathin	Posted - 2004.04.02 14:32:00 - [8] Fubar: "Your results would be more accurate on the mineral-ore owned page if your calculations were: =floor(<number_of_refines><base_mineral_value>(<base_yield>/100)*(1-(<station_fee>/100)),1)" - Hmm, I'm not totally sure what you're talking about.. What column/row are you referring to? "Is there a circular reference on the production-estimates page?" - That sheet was hell to create so it gave me what I wanted it to give me. I wouldn't be surprised to know there are some bugs in there, but I thought I had ironed them all out. Circular references was one of the problems I did have, so if you can let me know how you created the error, then I can check it out and correct it. Orion Yoda: "Hey this is great! thanks." - No probs. I was going to let people pay for this, but I was too lasy in trying to advertise it. If you like it and use it alot, then don't hesitate to donate some isk my way :) Would love to make profit in-game from this work :D T. -- always look on the bright side of the cloning facility.
Caeli Maren	Posted - 2004.04.02 17:08:00 - [9] Edited by: Caeli Maren on 02/04/2004 17:27:04 Your ore list is missing Spodumanium (sp?) When you're in adding this, could you perhaps capitalize the ore names all the same? and decide whether you want the : or not? Its a bit annoying to me. The Mercoxit value per unit doesn't have the /C32, so its listing the value per refine. Also, because you've locked the columns so we can't resize them, there are some that are too narrow for their data, and just display ####### instead. N32 O32 P32 are examples, on the Mining Stats page.
Caeli Maren	Posted - 2004.04.02 18:49:00 - [10] Quote: Your results would be more accurate on the mineral-ore owned page if your calculations were: =floor(<number_of_refines><base_mineral_value>(<base_yield>/100)*(1-(<station_fee>/100)),1) Rounding is a problem if done before the final calculation. I didn't get this for a minute, but I agree. The loss from station and waste should be calculated after adding the batches together. Just to clarify the formula above, the <base_mineral_value> is not the isk value, but the trit/pyer/etc per refine, before waste or fee.
Fubar	Posted - 2004.04.02 20:18:00 - [11] Edited by: Fubar on 05/05/2004 23:36:54 Quote: "Your results would be more accurate on the mineral-ore owned page if your calculations were: =floor(<number_of_refines><base_mineral_value>(<base_yield>/100)(1-(<station_fee>/100)),1)" - Hmm, I'm not totally sure what you're talking about.. What column/row are you referring to? Here is an example of what I mean: 'Basic Stats'!e18 = 1000 'mineral-ore owned'!e15=floor($D15'basic stats'!E18('basic stats'!$N22/100)(1-('basic stats'!$L$13/100)),1) Quote: "Is there a circular reference on the production-estimates page?" Edit:link removed. A minor correction:scordite has a density of 0.15 m3 Spudomain Density:16 Batch:250 Tritanium:700 Pyerite:140 Megacyte:140 Morphite:7 ** I am not trying to be overly critical but am just trying to help.
Orion Yoda	Posted - 2004.04.02 23:39:00 - [12] I got a circular reference on the production estimates page too. You say you are lying. But if everything you say is a lie, then you are telling the truth. You cannot tell the truth because everything you say is a lie. You lie, you tell the truth ... but you cannot, for you lie.-- Norman the android, "I, Mudd", stardate 4513.3
Delacho	Posted - 2004.04.03 07:53:00 - [13] Very nice mining sheet indeed. but the locking of the pages is sort of annoying to me, so i just worked my way around it Ill keep that unlocked file for myself though. anyway, way better then anything i could have done myself without spending days on it.
T'el'Alana Luathin	Posted - 2004.04.03 15:44:00 - [14] Fubar: Thanks alot for your input, it's great to see someone who is interested in this and wants to help out. I appreciate it :) I checked the ore owned columns, and it doesn't make any difference if I multiply the total batches with a floored calculation or if I first multiply the whole thing and then floor it. I checked out the production-estimates sheet regarding your recommendations, and found the problem with the circular reference. I've corrected D16 and J28. I've also added Morphite, spodumain and mercoxit stats and variables, so they work. I've also added a version number to it, beta 1 :) Let's see if it isn't working like it should now. http://eve.pc.is/eve-mining-guide-public.xls T. -- always look on the bright side of the cloning facility.
T'el'Alana Luathin	Posted - 2004.04.03 15:53:00 - [15] delacho: Thanks for ruining all my hard work :( you could have just told me how you wanted it here on this forum, and I would have fixed what was bugging you. Please delete the hacked file, and tell me what you want fixed, and I'll do it for you. I've updated the mining sheet anyway so you can resise the columns and added spodumain and other stuff. If there was anything else you feel uncomfortable with, lemme know and I'll change it. Don't just rip off all my hard work, which took weeks to do btw, and gloat about it. T. -- always look on the bright side of the cloning facility.
Delacho	Posted - 2004.04.03 20:26:00 - [16] how did i ruined your hard work? just i wanted some very specific stuff added that nobody else would care about. also note that i noted that i will never give this unlocked file to anyone. what i added basicly was more subtotals everywhere, and added more columns then just the 'needed' cause i got some different people i'm got orders from. also i changed the colors a bit to my liking. I'm sure lots of other people just use your file and never even told you how they were impressed by it, and others then me must have unlocked it as well.
Ruindar	Posted - 2004.04.03 22:56:00 - [17] Uhm.... why would anyone not unlock an Excel sheet they wanted to change? I do have a tough time seeing how that "ruins" someone elses work.
T'el'Alana Luathin	Posted - 2004.04.04 02:06:00 - [18] Well, in as few words, I felt really deflated from reading about someone hacking the sheet. It doesn't have to be logical, emotions never really are. Somehow I expected that people would leave it as it is, and reply with any changes they wanted or needed. But I guess that'll never really happen. Oh well. BTW, delacho. I'd be interested in seeing the changes you made. Could you perhaps e-mail me the changed excel sheet to [email protected]? I'm already thinking about implementing alot more to this excel sheet regarding the production side of the coin and having an easier to use database of owned blueprints which takes in skill levels and such.. Then there's tech 2 to think of and so on and so forth. I'm also thinking about a combat-fitting excel sheet, inspired by some of the fine experimental work on the ships and modules forum. Most combat sheets I've found stop only half-way or show the data in a very uncognitive form, so that'll be fun. T. -- always look on the bright side of the cloning facility.
Fubar	Posted - 2004.04.04 17:24:00 - [19] Quote: I checked the ore owned columns, and it doesn't make any difference if I multiply the total batches with a floored calculation or if I first multiply the whole thing and then floor it. Consider these examples: floor((10000.912510),1) = 9125 floor((10000.9125),1) = 912 10 = 9120 Your formulas will work if you have a perfect refining percentage.
T'el'Alana Luathin	Posted - 2004.04.05 12:03:00 - [20] Ok, I'll update the sheet with more specific values. You absolutely sure that EVE doesn't floor it first, and then multiply it with number of batches? 100%? T. -- always look on the bright side of the cloning facility.
Caeli Maren	Posted - 2004.04.05 16:41:00 - [21] Quote: Ok, I'll update the sheet with more specific values. You absolutely sure that EVE doesn't floor it first, and then multiply it with number of batches? 100%? T. I am certain of this. When you are recycling loot that contains like 1 megacyte, if you recycle only one at a time, you lose the megacyte every time. But if you refine a batch of 100, you can retrieve much of it.
DeathGrip	Posted - 2004.04.05 20:31:00 - [22] I just want to say thank you for the Great Spread Sheet. I have created some myself, but nothing that I could even compare to this. THX again for all your hard work and your willingness to share it. [i]Everyone needs to bring PVP to the table, Miners, Builders, Researchers, Get yourself a Frig, and help out some, You may even
Fubar	Posted - 2004.04.05 20:31:00 - [23] Edited by: Fubar on 05/04/2004 20:38:09 Quote: You absolutely sure that EVE doesn't floor it first, and then multiply it with number of batches? 100%? Scordite Refining Quote Screenshot <number_of_refines> = 709993/333 = 2132.111 floored = 2132 <base_mineral_value> = 833 (Tritanium) <base_yield> = (50+(37.5(1+(50.02)(1+(50.04))(1+(20.05)))/100 = 1.00445 = 1 <base_yield> has a maximum of 1 <station_fee>= 1-0.049962335 = 0.950037665 Example #1 =<number_of_refines>floor(<base_mineral_value><base_yield><station_fee>),1) =2132 * floor(83310.950037665,1) = 2132 * 791 = 1686412 Example #2 =floor(<number_of_refines><base_mineral_value><base_yield><station_fee>),1) =floor(213283310.950037665,1) = floor(1687225.09138274,1) = 1687225 So, yes I am absolutely sure. Edit: Provided a link to the screenshot instead of posting the screenshot.
Finraer	Posted - 2004.04.05 22:27:00 - [24] Wow - fantastic spreadsheet! Thanks for sharing. Spod skill is still protected.
Mrmuttley	Posted - 2004.04.06 07:48:00 - [25] Hey T'el'Alana Luathin thanks for producing this spreadsheet I recently started buying ores for refining and was doing these calculations by hand. This saves me a lot of time I'm sure it will be usefull for other ventures i have planned as well ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Hmmm I need a Sig
The Chef	Posted - 2004.04.06 10:42:00 - [26] Edited by: The Chef on 06/04/2004 10:45:54 I'm just wondering why you didn't use a Vlookup table instead of that huge array of IF statements... would definately have made it easier for you in the long run (eg: updating stats). But quite a nice little tool you've got there! * EDIT * Cell L10 on the Basic stats page is locked/protected. This makes it impossible to change your "Spodumain skill" level. ==================================== EVEkill Visit our homepage
T'el'Alana Luathin	Posted - 2004.04.06 12:12:00 - [27] Thanks for your replies ^_^ I've changed the sheet to your recommendations, also changed the glaring red, so it should look a little better. Also made skill input into drop-down lists. upped the version number to beta 2 and added future additions I'm thinking about. Link is still http://eve.pc.is/eve-mining-guide-public.xls T. -- always look on the bright side of the cloning facility.
T'el'Alana Luathin	Posted - 2004.04.06 12:18:00 - [28] The chef: I started making this excel sheet without any real knowledge of excel. Today I might have done a few things differently (learned alot), but 'if' statements are always simple in execution, although maybe long-winded. T. -- always look on the bright side of the cloning facility.
Orion Shurtak	Posted - 2004.04.06 15:43:00 - [29] Just wanted to say, Well Done on the spreadsheet! Has many more features than the one I made. Think I will switch to yours! -------------------------------------------------- You wouldn't shoot an old man would you?
Orion Yoda	Posted - 2004.04.07 02:57:00 - [30] It's a great spreadsheet and looking better with every revision. Thanks and I'll be sure to send you a donation when I am next online. How much is a good donation do you think? You say you are lying. But if everything you say is a lie, then you are telling the truth. You cannot tell the truth because everything you say is a lie. You lie, you tell the truth ... but you cannot, for you lie.-- Norman the android, "I, Mudd", stardate 4513.3

Pages: [1] 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 30 40 .. 43 :: 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.