| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Daelin Blackleaf
Naqam
   |
Posted - 2008.06.23 01:03:00 -
[1]
I plan to create a spreadsheet that will allow me to compare my set-ups as opposed to individual weapon systems. I plan for the spreadsheet not to make my eyes bleed like many of the others available do (no offense meant to anyone).
However I am still an Excel noob.
Albeit a persistent one.
How would I be able to select something from a drop down list and have the sheet enter the relevant numbers in a group of cells? I've scoured the web but keep getting data validation and filtering help for lists.
Sig removed, inappropriate content. If you would like further details please mail [email protected] ~Saint |
Daelin Blackleaf
Naqam
|
Posted - 2008.06.23 01:03:00 -
[2]
I plan to create a spreadsheet that will allow me to compare my set-ups as opposed to individual weapon systems. I plan for the spreadsheet not to make my eyes bleed like many of the others available do (no offense meant to anyone).
However I am still an Excel noob.
Albeit a persistent one.
How would I be able to select something from a drop down list and have the sheet enter the relevant numbers in a group of cells? I've scoured the web but keep getting data validation and filtering help for lists.
Sig removed, inappropriate content. If you would like further details please mail [email protected] ~Saint |
Micheal Dietrich
Terradyne Networks
|
Posted - 2008.06.23 04:40:00 -
[3]
Access is the path you want to take.
 Originally by: El'tar
I WOULD WARRIOR FOR WOMAN BELONG TO ME!
|
Lexx Jonlan
The Funkalistic
SMASH Alliance
|
Posted - 2008.06.23 06:12:00 -
[4]
Use VLOOKUP Padawan. Check Excel help for more info.
Very easy to use & perfect for what you want here.
Si Hoc Legere Scis Nimium Eruditionis Habes |
Victor Valka
Kissaki Corporation
|
Posted - 2008.06.23 07:22:00 -
[5]
For the dropdown, you need to use data validation from list. For the second part, use lookups (HLOOKUP, VLOOKUP) that depend on the dropdown field.
If you want the dropdown to be conditional (i.e. to depend on another dropdown), well, that's more complex and trust me, you do not want to go there. 
Originally by: Roxanna Kell
You are insane.
|
Kazuo Ishiguro
House of Marbles
Zzz
|
Posted - 2008.06.23 11:09:00 -
[6]
Conditional dropdowns can still be done in excel, but you might end up with a few blank options at the bottom of the input list. One way to do it is to validate from a list of cells whose values are in turn given by vlookup functions.
Zzz research towers
Direrie
NEW: Liekuri
20:1 low-end compression |
SoftRevolution
|
Posted - 2008.06.23 11:17:00 -
[7]
One thing you could try is having all the data on one sheet/sheets and using a "pivot table" to choose which set of data to display / summarise it onto a seperate sheet.
They use a drop-down or drop-downs for selecting categories. It's quite a powerful tool.
IF formulas might also be useful for this.
You can have some True / False cells (or just a 0/1 in the cell) which other formulas then depend on and you can use IF formulas as a category for sorting data for a pivot table.
EVE RELATED CONTENT |
Victor Valka
Kissaki Corporation
|
Posted - 2008.06.23 12:32:00 -
[8]
Originally by: Kazuo Ishiguro
Conditional dropdowns can still be done in excel, but you might end up with a few blank options at the bottom of the input list. One way to do it is to validate from a list of cells whose values are in turn given by vlookup functions.
That's why you use OFFSET in conjunction with COUNT/COUNTM
Originally by: Roxanna Kell
You are insane.
|
Nyphur
Pillowsoft
|
Posted - 2008.06.23 12:35:00 -
[9]
In my experience making spreadsheets, you tend to end up using a lot of lookups and nested IF statements. Really you can do anything with enough IF statements. My advice is to create a sheet that has all the rough work and calculations and such and then create a front-end sheet that simply displays the results you're interested in with a nice UI.
Pillowsoft - Join the Pillowsoft Gallente Militia, get free ships and support. |
Daelin Blackleaf
Naqam
|
Posted - 2008.06.23 14:42:00 -
[10]
Thankyou all especially Lexx and Victor. Darned easy once you know what to actually look for. I guess I should take some time and go through the alphabetical list of functions to see what else I'm missing.
Originally by: Nyphur
My advice is to create a sheet that has all the rough work and calculations and such and then create a front-end sheet that simply displays the results you're interested in with a nice UI.
That's pretty much the plan.
I very much enjoy making spreadsheets (that little statement could cost me my RL rep  ) but I've only ever learned to use them for administration purposes, never anything this... "scientific".
Another question then, for a chart how can I have an axis display, using our earlier example, range without having to provide cells stating the value at each range? How do I get a chart to show a calculation rather than a number? Is there a way to get the chart to scale with the results?
Sig removed, inappropriate content. If you would like further details please mail [email protected] ~Saint |
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |