open All Channels
seplocked Out of Pod Experience
blankseplocked Calling all EXCEL maestro's (I need help)
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Jin Jurat
Posted - 2008.06.02 15:49:00 - [1]
 

Im currently building up a spreadsheet that will be pulling data from various lists. Now im fairly confident I can get 1 list to work. However I hope to be able to pull information out of multiple lists simultanously. As it will save me alot of time.

An example would be how capital ships are built.

I would have a list that shows all the mineral requirements for a singular components.

I would then have a list of the ships and the quantity of each component required.

And on the user end. I would simply have a drop down list to select the ship and a cell for the quantity.

The result would be the user selecting a ship and quantity and the spreadsheet calculating the total number of each mineral type.

That's the best EVE example I can come up with!

Can anyone help, shed some light or point me in the direction of one thats already doing a similar function.

Thanks in advance!

Rutoo
Gallente
Interstellar eXodus
BricK sQuAD.
Posted - 2008.06.02 15:54:00 - [2]
 

Edited by: Rutoo on 02/06/2008 15:53:47
Originally by: Jin Jurat
Im currently building up a spreadsheet that will be pulling data from various lists. Now im fairly confident I can get 1 list to work. However I hope to be able to pull information out of multiple lists simultanously. As it will save me alot of time.

An example would be how capital ships are built.

I would have a list that shows all the mineral requirements for a singular components.

I would then have a list of the ships and the quantity of each component required.

And on the user end. I would simply have a drop down list to select the ship and a cell for the quantity.

The result would be the user selecting a ship and quantity and the spreadsheet calculating the total number of each mineral type.

That's the best EVE example I can come up with!

Can anyone help, shed some light or point me in the direction of one thats already doing a similar function.

Thanks in advance!


Use Microsoft Access

Jin Jurat
Posted - 2008.06.02 15:56:00 - [3]
 

I have absolutely no experience with MS Access so im sure it will take me longer in the long run. Also as im inexperienced with it i can't be certain that it can be used within my work the way it needs to be.

Kazuo Ishiguro
House of Marbles
Posted - 2008.06.02 16:24:00 - [4]
 

I suggest you get to know how the MMULT array function works, as it's the most efficient way of doing what you want to do. You might find this spreadsheet useful:
http://dl.eve-files.com/media/corp/KzIg/jfs.zip

For the drop down list, you'll need to use the cell validation settings, set to 'list' and specifying a cell range, and to retrieve the mineral values you'll probably want a vlookup.

You could save yourself the bother, though, and just use this instead:
http://eve.smith-net.org.uk/

AlleyKat
Gallente
The Unwanted.
Posted - 2008.06.02 17:58:00 - [5]
 

Originally by: Rutoo
Edited by: Rutoo on 02/06/2008 15:53:47
Originally by: Jin Jurat
Im currently building up a spreadsheet that will be pulling data from various lists. Now im fairly confident I can get 1 list to work. However I hope to be able to pull information out of multiple lists simultanously. As it will save me alot of time.

An example would be how capital ships are built.

I would have a list that shows all the mineral requirements for a singular components.

I would then have a list of the ships and the quantity of each component required.

And on the user end. I would simply have a drop down list to select the ship and a cell for the quantity.

The result would be the user selecting a ship and quantity and the spreadsheet calculating the total number of each mineral type.

That's the best EVE example I can come up with!

Can anyone help, shed some light or point me in the direction of one thats already doing a similar function.

Thanks in advance!


Use Microsoft Access


This.

If you need/want to view the information inside a spreadsheet, just create a pivot table running from a series of queries inside your access database onto your spreadsheet. Every time you want to update the spreadsheet, just click refresh - job done.

AK.

Fink Angel
Caldari
The Merry Men
Posted - 2008.06.02 19:38:00 - [6]
 

What you are describing OP sounds very much like a relational database. If budget allows I'd strongly recommend you consider Access as other posters have said.

It's very straightforward to use at the table / field level you need. One table containing (from your example) component parts and prices. One table containing ships and quantities of components per ship. Link the two tables together, and hey presto, you can pull pricing per ship etc.

You can actually link that data into Excel if you like, or pull reports straight from Access.

Excel is a wonderful tool, but if you need to hammer in some nails it doesn't matter how good your drill is, you need a hammer!


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only