Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup function returning reference, not value | Excel Worksheet Functions | |||
How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions | |||
Lookup Function Error | Excel Worksheet Functions | |||
Lookup Function Problem | Excel Discussion (Misc queries) | |||
Lookup function w/Text and Year | Excel Worksheet Functions |