Using lookup function
 

Hi,

I am trying to code a spdsht that can be used to monitor diskspace across
multiple servers and logical drives per server.

The data acquisition is complete and i have no problems automating the
collection of the data using a wmi script and feeding it into excel and
generated basic time vs diskspace charts.

What i want to create is a simple dashboard style chart that will show any
logical drive that is below a certain threshold to provide a clear visual
warning to the operator.

At the moment I have a simple min() function using if() to remove servers
whose free space is great than 50%. however .... if a server recovers space
the chart will still only show the min() value.

How can I use a lookup function to generate this chart only for the current
days data set (Did i mention that the spdsht is archived once a month?) so
that.

I have so far been unsucessful in creating this.

my data set looks something like this...

//server/drive,1-jan,2-jan,3-jan,
//svr1/c,65,63,40,38,
//sv1/d,80,80,80,80,
//svr2/c,20,15,5,60,

As you can see ... if i use min() then for //svr2/c it will only ever report
as 5% free even though the following day diskspace increased to 60%

Any help greatfully accepted.

G.

Hi!

A combination Vlookup/Match should work:

=VLOOKUP(server,table_array,MATCH(date,lookup_arra y,0))

Biff

"Gary" wrote in message
...
Hi,

I am trying to code a spdsht that can be used to monitor diskspace across
multiple servers and logical drives per server.

The data acquisition is complete and i have no problems automating the
collection of the data using a wmi script and feeding it into excel and
generated basic time vs diskspace charts.

What i want to create is a simple dashboard style chart that will show any
logical drive that is below a certain threshold to provide a clear visual
warning to the operator.

At the moment I have a simple min() function using if() to remove servers
whose free space is great than 50%. however .... if a server recovers
space
the chart will still only show the min() value.

How can I use a lookup function to generate this chart only for the
current
days data set (Did i mention that the spdsht is archived once a month?) so
that.

I have so far been unsucessful in creating this.

my data set looks something like this...

//server/drive,1-jan,2-jan,3-jan,
//svr1/c,65,63,40,38,
//sv1/d,80,80,80,80,
//svr2/c,20,15,5,60,

As you can see ... if i use min() then for //svr2/c it will only ever
report
as 5% free even though the following day diskspace increased to 60%

Any help greatfully accepted.

G.