G
geoff.durham
If I have a spreadsheet as below:
(App) (Env) (Type) (Model) (Cap) (Cost) (ID)
A B C D E F G
1 App1 Prod Citrix BL2x220 50 $5,003 App1-Prod-Citrix
2 App1 Prod Citrix VM 40 $0 App1-Prod-Citrix
3 App1 DR Citrix BL2x220 50 $5,003 App1-DR-Citrix
4 App2 Prod Citrix BL2x220 50 $5,003 App2-Prod-Citrix
5 App2 Prod File BL465G1 150 $6,353 App2-Prod-File
6 App2 Prod File DL585G5 300 $9,293 App2-Prod-File
Where
A=The application
B=Environment
C=Server Type
D=Hardware Model
E=Server Capacity
F=Cost
G=Server Identifier
Cells in G1 are calculated by =A1&"-"&B1&"-"&C1 (and so on for
subsequent rows)
I have within the same sheet, another table that has all the different
server types for all the environments for each application.
For example (see below) on the row for App1, Prod, Citrix servers, I
have a pull down box that I want users to use select one of the
supported types of hardware available, i.e. BL2x220 or VM. When users
select a hardware type that is possible for that config, the
applicable number of servers required to support a customer (with
defined users) is calculated using the respective capacity value in
column E. Similar calculations are also conducted to calculate costs,
BTUs, power reqs, build and ongoing costs, etc.
(App) (Env) (Type) (Model) (# Svrs)(Cost) (BTU) (ID)
A B C D E F G z
124 App1 Prod Citrix App1-Prod-Citrix
My question is how can I configure the Data Validation for D124 to
provide a pull down box that should show the hardware models
appropriate for App1-Prod-Citrix servers, i.e. BL2x220 or VM??? I
tried using the value in Z and G rows to use V/Hlookups but can't seem
to get it anything to work.
Any ideas greatly appreciated.
(App) (Env) (Type) (Model) (Cap) (Cost) (ID)
A B C D E F G
1 App1 Prod Citrix BL2x220 50 $5,003 App1-Prod-Citrix
2 App1 Prod Citrix VM 40 $0 App1-Prod-Citrix
3 App1 DR Citrix BL2x220 50 $5,003 App1-DR-Citrix
4 App2 Prod Citrix BL2x220 50 $5,003 App2-Prod-Citrix
5 App2 Prod File BL465G1 150 $6,353 App2-Prod-File
6 App2 Prod File DL585G5 300 $9,293 App2-Prod-File
Where
A=The application
B=Environment
C=Server Type
D=Hardware Model
E=Server Capacity
F=Cost
G=Server Identifier
Cells in G1 are calculated by =A1&"-"&B1&"-"&C1 (and so on for
subsequent rows)
I have within the same sheet, another table that has all the different
server types for all the environments for each application.
For example (see below) on the row for App1, Prod, Citrix servers, I
have a pull down box that I want users to use select one of the
supported types of hardware available, i.e. BL2x220 or VM. When users
select a hardware type that is possible for that config, the
applicable number of servers required to support a customer (with
defined users) is calculated using the respective capacity value in
column E. Similar calculations are also conducted to calculate costs,
BTUs, power reqs, build and ongoing costs, etc.
(App) (Env) (Type) (Model) (# Svrs)(Cost) (BTU) (ID)
A B C D E F G z
124 App1 Prod Citrix App1-Prod-Citrix
My question is how can I configure the Data Validation for D124 to
provide a pull down box that should show the hardware models
appropriate for App1-Prod-Citrix servers, i.e. BL2x220 or VM??? I
tried using the value in Z and G rows to use V/Hlookups but can't seem
to get it anything to work.
Any ideas greatly appreciated.