EVE Search - Need a Small amount of Excel Help

All Channels

Science and Industry

Need a Small amount of Excel Help

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

Monitor this thread via RSS [?]

Pages: [1] :: one page
Author	Thread Statistics \| Show CCP posts - 0 post(s)
ishmeiil Hello Kitty Island Adventure Club 8	Posted - 2012.07.05 15:43:00 - [1] - Quote I am trying to create an excel spreadsheet for my future industrial business (doing my research before I jump into it). Currently, I am stuck on the formula for production time. So far, my equation reads as: BaseTime * (1 - (ProductivityModifier / BaseTime) * (PE / (1 + PE))) * ((1 - (.04 * IndustrySkill)) * Implant * SlotModifier) What is the Productivity Modifer, I cant seem to find reference to it on any blueprints I've been looking at, unless its call something different?
Zifrian Licentia Ex Vereor Intrepid Crossing 359	Posted - 2012.07.05 15:59:00 - [2] - Quote It's from the Datadump for the blueprint you are using. Here's my code if it helps: ' PTM (Production Time Modifier) = (1-(0.04IndustrySkill)) ImplantModifier * ProductionSlotModifier ' Implants that modify ProductionTime => Zainou 'Beancounter' BX-801/BX-802/BX-804 1%/2%/4% PTM = (1 - (0.04 * Industry)) * PEImplantValue * StationTimeMod ' ProductionTime (PE >= 0) = BaseProductionTime * (1 - (ProductivityModifier/BaseProductionTime) * (PE/(1+PE))) * PTM ' ProductionTime (PE < 0) = BaseProductionTime * (1 - (ProductivityModifier/BaseProductionTime) * (PE-1)) * PTM If iPE >= 0 Then PEModifier = iPE / (1 + iPE) Else PEModifier = iPE - 1 End If ' For 1 run of this item ProductionTime = BaseProductionTime * (1 - (BaseProductionMod / BaseProductionTime) * PEModifier) * PTM Maximze your Industry Potential! - Get EVE Isk per Hour!
ishmeiil Hello Kitty Island Adventure Club 8	Posted - 2012.07.05 16:09:00 - [3] - Quote I dont suppose there is an easy way to get at that value from the data dump is there? I'm not bad with sql, but I cant seem to get the database to import and in any event, I really dont want to look up each item and hard code that value in
Steve Ronuken Fuzzwork Enterprises 486	Posted - 2012.07.05 18:01:00 - [4] - Quote http://www.fuzzwork.co.uk/blueprints/xml/1236/-4/5 might be of interest to you typeid/ME/(Production Efficiency skill) alternatively, http://www.fuzzwork.co.uk/dump/inferno11/ has all the tables from 1.1 in excel/csv(when >65000 rows) format. you'll just need 7zip or similar to unzip them. invBlueprintTypes has the times. invTypes has all the typeids for each item type. And if you're comfortable in mysql, there's a full dump that you can import, in the directory above that. FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities.
ishmeiil Hello Kitty Island Adventure Club 8	Posted - 2012.07.05 18:15:00 - [5] - Quote Excellent! Thank you, that was exactly what i needed. It looks like for the current scope of my project, I'm likely to have to hardcode the values into the formulas, but I think my project may be growing soon anyway. Am I the only one who finds projects to be...organic, in that they take a life of their own and expand far past what you set out for in the first place?
Zifrian Licentia Ex Vereor Intrepid Crossing 361	Posted - 2012.07.05 23:22:00 - [6] - Quote ishmeiil wrote: Excellent! Thank you, that was exactly what i needed. It looks like for the current scope of my project, I'm likely to have to hardcode the values into the formulas, but I think my project may be growing soon anyway. Am I the only one who finds projects to be...organic, in that they take a life of their own and expand far past what you set out for in the first place? EVE IPH (the program I developed in my sig) started out as a shopping list program. So no you aren't the only one Maximze your Industry Potential! - Get EVE Isk per Hour!
Steve Ronuken Fuzzwork Enterprises 489	Posted - 2012.07.05 23:31:00 - [7] - Quote Anything I'm coding, when it's touching on manufacturing, hooks up to the blueprint calculator. Like my new stockpile management thing. (Far from release ready. 2 scripts, 4 tables, and SQL when I want to stick in stockpile requirements. All facilities of a type treated the same.) So I can check on if it's worth building or buying. The blueprint calculator started off pretty simple, but it's expanding as I run into other things. Like the invention costs. That /was/ done on a spreadsheet. FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities.
Skorpynekomimi 233	Posted - 2012.07.07 20:35:00 - [8] - Quote ishmeiil wrote: Excellent! Thank you, that was exactly what i needed. It looks like for the current scope of my project, I'm likely to have to hardcode the values into the formulas, but I think my project may be growing soon anyway. Am I the only one who finds projects to be...organic, in that they take a life of their own and expand far past what you set out for in the first place? Excel encourages project bloat, in my experience. My simple spreadsheet for production turned into a mini database of blueprints and assets. Really, the only thing stopping it from bloating further is that I don't remember how to make nested IF statements. As soon as I winkle it out my memory (or find my GCSE notes), the sky's the limit.
Steve Ronuken Fuzzwork Enterprises 489	Posted - 2012.07.07 20:38:00 - [9] - Quote Skorpynekomimi wrote: ishmeiil wrote: Excellent! Thank you, that was exactly what i needed. It looks like for the current scope of my project, I'm likely to have to hardcode the values into the formulas, but I think my project may be growing soon anyway. Am I the only one who finds projects to be...organic, in that they take a life of their own and expand far past what you set out for in the first place? Excel encourages project bloat, in my experience. My simple spreadsheet for production turned into a mini database of blueprints and assets. Really, the only thing stopping it from bloating further is that I don't remember how to make nested IF statements. As soon as I winkle it out my memory (or find my GCSE notes), the sky's the limit. IF( condition1, value_if_true1, IF( condition2, value_if_true2, value_if_false2 )) Though you could also put the second if in as the value_if_true1 FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities.
Jalfresi3 EastEnd Industries 1	Posted - 2012.07.08 17:04:00 - [10] - Quote hi everyone, i am using excel 1997 version, can anyone tell me how to import the eve market prices automatically,or can it not be done thnx
DeltaW7 FACTS on EVE 1	Posted - 2012.07.09 07:42:00 - [11] - Quote Not from eve directly, but you can do it from eve-central or eve marketdata
ishmeiil Hello Kitty Island Adventure Club 8	Posted - 2012.09.19 20:56:00 - [12] - Quote So, after dropping the project for a while, I think I'm going back to it. But I think I'm going to use Google Docs since there's an importXML function I can use to hook into eve-central for my market-median database, and I think I can also use SQL from there to access hosted databases for other information. On the other hand, I'm also thinking of writing this in some other language entirely, perhaps PHP, or perhaps I'll design it into a phone app, I really need to decide that first I guess. In any event, my original intent is kind of gone. I originally wanted a spreadsheet that could exist offline except for a simple import function to bring in current prices, but I'm not entirely sure that's a realistic expectation at this point.

Pages: [1] :: 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.