| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
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
Interstellar eXodus
R0ADKILL
|
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
_________________________________________________________
My Second EvE Video
Club Seals Not Sandwichs
|
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
Zzz
|
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/
My research services
Mineral compression for carrier/Rorqual pilots |
AlleyKat
White-Noise
Atrum Tempestas Foedus
|
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.
EVE-ONLINE VIDEO-MAKING TUTORIALS |
Fink Angel
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!
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |