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.04.17 04:08:00 - [61] bigbrowncow: Well, u made me install 602tab.. I brung mine.. lemme see you bring yours! Btw.. To all y'all people who're watching this thread, on sunday there might be a pretty big newsflash on upcoming developments with the ultimate mining excel sheet, so tune in on sunday.. probably evening time GMT. T. -- always look on the bright side of the cloning facility.
Mrmuttley	Posted - 2004.04.17 12:07:00 - [62] Hey Tel Like the new and improved version can we make a small change to list of productions when you next update. When i enter data into the blank cells i end up with black texk on dark brown background. If you can change one or other of these it will make it easier to read Many thanks Muttley ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Hmmm I need a Sig
T'el'Alana Luathin	Posted - 2004.04.17 12:57:00 - [63] MrMuttley: Done. T. -- always look on the bright side of the cloning facility.
Max Hardcase	Posted - 2004.04.18 09:51:00 - [64] Could you make a version that works with the MS works spreadsheat ? All those protected cells make works go boom.
RealUnReal	Posted - 2004.04.18 18:04:00 - [65] Edited by: RealUnReal on 18/04/2004 18:05:49 If u want to create a custom type in your excel spreadsheets for isk then goto format cells and custom type and enter the following for isk. ###,###,###.00" isk";[red]"-"###,###,###.00" isk";0.00" isk" Cut and paste would work best so you don't miss any spaces. you only have to enter it once and it would be available for the whole workbook. Just my two isk on spreadsheets RealUnReal
T'el'Alana Luathin	Posted - 2004.04.19 10:25:00 - [66] Well, was gonna post this yesterday, but the forums were down so.. I've finally started on a huge undertaking, that is putting all the BPs into a single BP sheet, meaning I'll go over each and every single BP to check the info on them. Then I'll have another sheet where you can easily pick the ones you have. This will allow me to do cool things with the mining calculator, as well as create totally new production sheets, and hauling sheets [dramatic voice] As you've never seen before![/dramatic voice] The best thing about it is that this will have solid, confirmed Tech 2 data for y'all to gawk at and use for your production estimates. I'll even try to see if I can't create loot-reprocessing overview for the rat hunters out there. Now this is what seriously annoys me.. only 3 people donated any money for my mining sheet, and the total was under a million isk. I'm guessing more of you wanted to donate, but found it much easier not to, so I'm thinking that maybe a fair price should be in order now that you know you'd have donated anyway (right?). The ones who already donated money before will get a hefty discount to reward them for it. The ones who donate money between now and when I post my new sheet will get a discount on my new sheet, and the others just have to buy at full price. Lemme know what you think is fair price for all this and I'll take that into consideration. This will probably be a month or more in scripting, where I'm taking away precious EVE-time to do this, so take that into consideration I'm not trying to make a billion isk from this, I just want to see that my sheet is appreciated, and the best way for you guys to do that is to donate/pay isk for it. Lemme know what u think. T. -- always look on the bright side of the cloning facility.
Palx	Posted - 2004.04.19 10:55:00 - [67] Im not sure if I understodd your last post - you want us to BUY the sheet? Anyway, I like the sheet and i am using it alot, but on the latest version (beta4) On the "Mining Stats" Page where it tells you how much ore you miner with a Miner II per min etc, all the cells text is in white so i cant read them.Can you try to fix this before you start selling your sheet pls? Good work though! Palx
T'el'Alana Luathin	Posted - 2004.04.19 13:21:00 - [68] Palx: Could you be more specific about what's column/row is giving you the problems? If it's column C, then it's not something you have to worry about.. Just choose the ore from F3, I3, and M3 and see the stats there per ore. Lemme know what u want to know, and I'll implement it. About the buying comment: yeah, why not? I'd love to be able to invest my time in fixing the sheet instead of mining, but mining is right now a helluvalot more profitable. Think of it as a new way of trying to make a profit with this game by doing something you enjoy instead of something you mildly dislike. A few things straight though, the mining sheet which I have now publicised is of course free, no change there. I will update it and not ask a price for that, no probs there. But I'll be adding a whole lot over the next few weeks to a new ultimate sheet which will take alot of time, and alot of effort, and it'll make the mining sheet look small and insignificant in comparison. So I'm just asking for what people think. I think the highest appreciation you can show is to donate/pay isk for my sheet. What do you think? T. -- always look on the bright side of the cloning facility.
Palx	Posted - 2004.04.19 19:36:00 - [69] Edited by: Palx on 19/04/2004 19:38:13 Yes i agree with haveing to buy an improved/updated version of the sheet which you will have put alot of work and effort in, how much will you be charging anyway? (oh and donation on its way ) And the column is the C & D 3-15 where the writing is invisible and (since it is locked) i cannot change it to black. (this is on the mining stats page)
T'el'Alana Luathin	Posted - 2004.04.19 22:43:00 - [70] Palx: Ah, thought as much. Could you tell me why those stats are important to you, what info are you getting from them which isn't covered by the 3 ore lists? Would you be satisfied with a total amount of m3 from turrets and drones instead? I did make them invisible for a reason, would be very interested in getting your reasons for wanting 'em back up :) T. -- always look on the bright side of the cloning facility.
Orion Yoda	Posted - 2004.04.20 03:22:00 - [71] Hi T'el, could you please add a "quantity" multiplier into your production page. like I want to make 5 pieces of 425 rails what is the total amount of minerals required. And did you get my donation to you? 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.20 10:13:00 - [72] Orion Yoda: I did add a number of Prod. batches in the mining calculator. Did you see that? Do you want another one in the 'list of productions' sheet? You can see the multiplied value in 'totals left' column. Orion, yup I did get your donation, thanks man, highly appreciate it Wished more people did the same as you, then I wouldn't have to worry. T. -- always look on the bright side of the cloning facility.
Orion Yoda	Posted - 2004.04.20 11:06:00 - [73] I'll have another closer look T'el, thanks for the nice spreadsheet. 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
Gwarnina	Posted - 2004.04.20 14:00:00 - [74] Hi Tel, Thanks a lot for the spreadsheet, you do a much better job in Excel that I ever hoped I could. This certainly saves a lot of time and effort for me, not to mention that I love to know just how much money I've made since I've been sitting in this belt... I think your one hour's donation is right on target - I would have wasted away a lot more than an hour to come up with a spredsheet that's no way as flexible as yours. Once I get home and start my thing, I'll wire you the money. I'm a noob, so don't expect big bucks, but based on your chart, I can pull in over 500k's worth of minerals in an hour. Hell, just knowing this made mining more attractive again - last night I made a little over 100k running an agent. I guess I'll go back to what I do best... I'd love to help you with the blueprint project. Let us know what kind of information you need and how you'd like to receive it. Perhaps put up an Excel template that we can fill out and shoot back your way for merging. . EVE University is committed to helping newcomers to EVE get settled right in. Join our ingame channel EVE University to learn more.
Palx	Posted - 2004.04.20 18:32:00 - [75] I just wanted to know what the ore rate was compared to the original (ie with my skills) that is all.
Rodge	Posted - 2004.04.21 10:08:00 - [76] Edited by: Rodge on 21/04/2004 10:12:13 Edited by: Rodge on 21/04/2004 10:11:05 Hi T'el'Alana, I've just viewed the thread and downloaded the spreadsheet and just wanted to say "wow!" I've seen one or two other spreadsheets that looked prettier, but what's more important is that all the info and data is much easier to get at in yours and there's not as much scrolling involved. Functionality is much more important to me than window dressing. Top notch work! I'll definitely make good use of this, so I definitely think it's worth an hour's worth of my mining time in cash. And I fly a thorax too I have a little request, that I'm sure is pretty easy to do. The "Buy" columns on your spreadsheet seem to be more decorative than anything else. I sometimes go into stations and see that they have ore for sale. I'd love to just be able to put in the amount of ore for sale, use your "Buy value for ore", link it with the "sell value for mins", mix in my refining skill and get a total out that tells me if I could make an instant profit at that station by just buying the ore, refining and selling. With the likes of plag, which refines into 3 seperate mins, I can never be bothered calculating it out myself. This would expand the sheet to be useful to trader/refiner type people. It would also provide a great link in with your idea for the large project to add in the refine values for all items. So you see something nice on the market for 10,000 isk, and you know you can bring it back, refine it for 20,000 all just using your spreadsheet. Great idea, btw, to incorporate refines of all the items. It's a huge undertaking and I hope more people support you so you do go ahead with it! Let me know if I can help in any way towards such a plan. I'd also like to see a display of your calculation of the total percentage refine with skills I'll get, say under the recyling constant? That's the "Station efficiency is 50%, but with your skills you get 91%". Not that I distrust your calculations , it would just be nice that I could check that what you get is what the game displays as well. And finally, a small thanks to everyone who's posted here and kept all the posts constructive. * Edit - typo [ 2005.04.17 00:34:30 ] Nagilam > u better leave Rodge, u will not gank any1 else 2nite......
T'el'Alana Luathin	Posted - 2004.04.21 12:16:00 - [77] Rodge: ..my spreadsheet ain't pretty?? ;P Hey, I think you've got something there about the refining thing. It's too bad that buy values isn't being used right now, so a brand spanking new refining sheet is just what it needs, then I can justify putting it up to beta 5. Of course I need a few days to think my way through it. Right now I just want to finish inputting all the BP data.. all the tech 2 BPs are slowing down work considerably.. they have alot of requirements! I'd be seriously surprised but very happy if someone would actually donate one hours worth of mining veld or scord, so please do! :) I don't think it's too much to ask. I'll check the "You get X%" thing and add it. Verification is always good. T. -- always look on the bright side of the cloning facility.
T'el'Alana Luathin	Posted - 2004.04.21 14:29:00 - [78] Updated sheet to beta 5. status. Mainly fixed little things and added a few things. No great big improvement, except 'mining stats' had an error that it didn't round down, but that's all fixed. Added m3/cycle in 'mining stats' added "Your efficiency" in 'basic stats' - I'm wondering if anyone is using the 'group mining' sheet.. If so, I want input from users. If not, then why not? Anything useless will be thrown out. T. -- always look on the bright side of the cloning facility.
Rodge	Posted - 2004.04.21 20:08:00 - [79] There's a wee donation from me waiting for you (wanted to give a bit more, but i'm a little skint atm ). I can't wait to see the release of this when you've got the refine values of items. I never really know what to do with tech 2 items I get and since there's no supply on the market, it's hard to tell what it's worth. And it does look pretty. But the way it's user friendly and I can see all the data at once on screen is much more important to me. As far as the group mining part, can't be much help with constructive posting. It looks good, but I generally just donate all my share to the corp so I don't bother with tracking various people's shares myself [ 2005.04.17 00:34:30 ] Nagilam > u better leave Rodge, u will not gank any1 else 2nite......
Joran Nexus	Posted - 2004.04.22 07:49:00 - [80] T'el I stumbled across your spreadsheet recently and I love it. Expect to see a donation as soon as I can get on. The best bit for me is the mining calculator, makes planning for mining ops very easy. Just fiddle around with the various ores and see how it effects the time needed. I like that alot. Anyway when I mine with miner 2's, having mining 4 and astrogeology 3 I get 81.6m¦/laser, your sheet calculates 82m¦/laser, this may be due to rounding and truncation, though I'm not sure. Secondly is it possible on the mining calculator to not include some minerals when determining the ore to mine? What I mean is I am not setup to mine in 0.0. I can only get zyd and mega by buying them from the market, so when determining the time needed to mine for the various ores, whatever ores are chosen by default for zyd and mega impact on trit, pye etc. My workaround is too change the mega and zyd values to 0. Ideally I would like to leave them in so I know how much it will cost me too buy them.
T'el'Alana Luathin	Posted - 2004.04.22 12:37:00 - [81] Joran: Could you reply with how much ore you're getting per cycle? Would like to see if that reflects the same error. Interesting note on the mining thang. I'll change it, will let u know when that's done. T. -- always look on the bright side of the cloning facility.
Fubar	Posted - 2004.04.22 14:59:00 - [82] Edited by: Fubar on 23/04/2004 06:18:39 Originally by: Joran Nexus Anyway when I mine with miner 2's, having mining 4 and astrogeology 3 I get 81.6m¦/laser, your sheet calculates 82m¦/laser, this may be due to rounding and truncation, though I'm not sure. Are you sure you don't mean 82.6m¦/laser? Anyway, when calculating ore received per minute per laser anything right of the decimal point is dropped. So if mining Veldspar (volume 0.1) you should get 820 veldspar per laser per minute. If the decimals were not dropped you would get 826 veldspar per laser per minute.
Satoyo Akuiro	Posted - 2004.04.22 21:18:00 - [83] could someone tell me how i make a listbox like in this document i have often needed to make a list to choose from like that. - Thank you, Satoyo Akuiro -- Visit www.explore-eve.net for POIs in eve :)
Fubar	Posted - 2004.04.22 21:52:00 - [84] Originally by: Satoyo Akuiro could someone tell me how i make a listbox like in this document i have often needed to make a list to choose from like that. - Thank you, Satoyo Akuiro This site has the info you are looking for.
Joran Nexus	Posted - 2004.04.23 04:46:00 - [85] Fubar & T'el: Will investigate further. Unfortunately I'm GMT +8 so will not be able to check until after the hardware update today (work ). Expect to see a reply in about 24hrs. Joran
Joran Nexus	Posted - 2004.04.24 08:49:00 - [86] Edited by: Joran Nexus on 24/04/2004 08:54:41 My investigation: Megathron 7 x miner 2's, Mining 4 and Astrogeology 3. Veldspar: 82.0m¦/laser, 574m¦ full cycle (820, 5740 units) Scordite: 81.9m¦/laser, 573.3m¦ (546, 3822 units) Pyroxeres: 81.9m¦, 573.3m¦ (273, 1911 units) Kernite: 81.6m¦, 571.2m¦ (68, 476 units) I don't understand why this occurs. Joran Edit: typo
Lucci	Posted - 2004.04.24 10:52:00 - [87] Edited by: Lucci on 24/04/2004 10:53:50 Originally by: Joran Nexus Megathron 7 x miner 2's, Mining 4 and Astrogeology 3. Veldspar: 82.0m¦/laser, 574m¦ full cycle (820, 5740 units) Scordite: 81.9m¦/laser, 573.3m¦ (546, 3822 units) Pyroxeres: 81.9m¦, 573.3m¦ (273, 1911 units) Kernite: 81.6m¦, 571.2m¦ (68, 476 units) I don't understand why this occurs. It's like Fubar said, decimals get dropped. So, with your skills the yield of one miner 2 is 82.8 m3 -> you get maxmimum of 82 m3 of ore per minute. Thus, the maximum units of e.g. Scordite you'll get in one minute is 546, anything else would go over the 82 m3 limit. Same goes for other ores as well, only the volume changes (because the volume of one unit between ores is different, too). And thank you, T'el'Alana Luathin, for your wonderful work on the sheet, a donation is on the way. =) - Luc
T'el'Alana Luathin	Posted - 2004.04.25 14:54:00 - [88] Ok, Beta 6! Ultimate Mining Guide - Beta 6 Added a new sheet 'buying&refining' check it out, and see what you thnk of it. Added an option to not select an one in the mining calculator. added a slight cargo thing to the 'mining stats' which might be nice if you're solo mining BTW a small update on the new ultimate sheet, the blueprint database is coming along nicely. Already I have 265 tech 1 items, and 33 tech 2 items catalogued. T. -- always look on the bright side of the cloning facility.
Suzie Evans	Posted - 2004.04.25 18:37:00 - [89] Hi, First off: thank you very much for all your effort mate, this is amazing! Any chance of unlocking the red cell that lets you enter the ships max cargo hold on the mining stats page? Once again: wicked effort!!! Su
T'el'Alana Luathin	Posted - 2004.04.25 22:09:00 - [90] Suzie: Bah! always one slips through. There it's fixed. T. -- always look on the bright side of the cloning facility.

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.