EVE Search - Research Order Management

Check My IP Information

All Channels

Science and Industry

Research Order Management - Spreadsheet Goodness

» 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)
Brock Nelson Caldari Flux Technologies Inc	Posted - 2009.10.18 22:34:00 - [1] I've been running Flux Technologies Inc for well over a year and I've had some people asking me how I manage my research order. I thought I'd make my spreadsheet available for anyone who runs a research business. Including in the zip file is the spreadsheet and a quick guide on how to use it. Download I'm not a VB programmer, so don't expect me to clean up my coding for you expert programmers. It's free, donations are appreciated but not needed. You can make any changes you want, just as long as the credit goes back to me. If you use it, please be kind enough to leave comments or suggestions to improve it.
Brock Nelson Caldari Flux Technologies Inc	Posted - 2009.10.19 03:01:00 - [2] I forgot to mention in my quick guide, the Max Allowable Day value refers to how long you prefer the blueprint to be for sale. For example, I don't like it when I have a researched blueprint that's been on the market for 100 days, so when that 100 day is reached, the order will be highlighted in red. At that point, its up to you on what you want to do. Usually I just drop the price to NPC price and never research it again. Tools for Research Business
Maestro Del'Tirith Space Exploration Forward Motion Industries	Posted - 2009.10.19 12:59:00 - [3] You, sir, are my new hero. This is great - thanks a ton for making available. ------------- Looking for a mature group to play with? Recruitment Thread
Lucian Saranni Gallente Center for Advanced Studies	Posted - 2009.10.19 13:33:00 - [4] Nice sheet. One minor problem I noticed is that the contract value and the PE/ME prices on the Research Data Entry tab are not being use in your formulas/code. It seems to be using invisible values from rows 6/7 on the Research Orders tab instead.
Maestro Del'Tirith Space Exploration Forward Motion Industries	Posted - 2009.10.19 13:38:00 - [5] On the first screen there are some inventory values, research orders stock/market. What is the purpose of these? Are they supposed to update from somewhere, or where you entering manually? ------------- Looking for a mature group to play with? Recruitment Thread
Brock Nelson Caldari Flux Technologies Inc	Posted - 2009.10.19 21:15:00 - [6] Thanks for the comments. As for the invisible value, I'm not sure why they're still there, will make the change. For the Stock/Market, it was part of my analysis of ROI on the total NAV along with other spreadsheets including manufacturing, trade, investment, etc. Some people may or may not find it relevant. Tools for Research Business
Maestro Del'Tirith Space Exploration Forward Motion Industries	Posted - 2009.10.20 01:21:00 - [7] Originally by: Brock Nelson For the Stock/Market, it was part of my analysis of ROI on the total NAV along with other spreadsheets including manufacturing, trade, investment, etc. Some people may or may not find it relevant. I would find it extremely valuable and relevant if there was a way to have it calculate off of the current stock vs sales or something similar? ------------- Looking for a mature group to play with? Recruitment Thread
Brock Nelson Caldari Flux Technologies Inc	Posted - 2009.10.20 12:27:00 - [8] That's what the 'Total Market' and 'Total Stock' values on the top of Research Orders tab are for. Tools for Research Business
Brock Nelson Caldari Flux Technologies Inc	Posted - 2009.10.21 02:49:00 - [9] Fixed exceptions that were thrown when the invisible values were moved. Fixed the total stock and total market calculation and linked them to Overview page. Tools for Research Business
Brock Nelson Caldari Flux Technologies Inc	Posted - 2009.10.24 02:17:00 - [10] Fixed the injection of orders into the excel sheet that were using the wrong cell data. Tools for Research Business

Aesynil Caldari The Unit...	Posted - 2009.10.25 06:29:00 - [11] That's an amazing tool, and I swiped it. Thanks so much! The Unit pursues invention, manufacturing, mining, and research. Evemail us if you need anything related to Science and Industry.


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.