Excel Reporting Tool
Hi,
I need your help with a.m. tool. I don't know how to clever write an formula for "vlookup" or "match" in excel without downloading all data to Excel.
What I need is, to find I max value of my vibrations, it is not problem "=max(ds.ch....)", but I also need to know on what speed is this highest peak. Means I need to search for index. In excel I will solve it with "vlookup" and/or "match". But without downloading I am not able to define table or search area.
Thx
PH
Application Engineer for Control and Automation
If you don't want to export the complete data to Excel and need to find the speed at the time of maximum vibration in the whole measurement, you can use a few math functions in DEWESoft and then export that speed only as a single number.
You need the maximum vibration in any case, so you can then also use the "time of max" in the basic statistics. Once you have that you can use the following formula to get the speed at the time of max vibration:
if('elapsed time' = 'vibrations/TIME OF MAX', 'speed', 0)
Then you just need the maximum of this formula and you have the speed at the time of maximum vibration as a single value, which can then be exported to Excel.
Please check the attached data file for more information. If that's not what you had in mind, let me know.
Attached files: