Hi,
I seeking for a report from raw data which is coming to my system automatically from OEM software. Raw data consist of every 5 min ( Date format is mm:dd:yyyy hh:mm:ss AM/PM)reading/value of meter. But I wan to generate daily , weekly , monthly report from Raw data. Here 1st I want to pull data every one hour. Please find the attached sample sheet for the same. Sample sheet having 3 sheets. Trend sheet is my raw data and I want to extract data to daily report sheet based on date. If I enter date manually in daily report sheet B2 , data has to come from trend sheet for every 1 hour only( Hour mentioned in A5 to A28. ). Please kindly help me to save my most of the time.
Please find the below file link
https://drive.google.com/file/d/0B9BAL8N1VndhellKNGpsNXo4aG8/view?usp=sharing
Thanks in Advance.
Santosh
I seeking for a report from raw data which is coming to my system automatically from OEM software. Raw data consist of every 5 min ( Date format is mm:dd:yyyy hh:mm:ss AM/PM)reading/value of meter. But I wan to generate daily , weekly , monthly report from Raw data. Here 1st I want to pull data every one hour. Please find the attached sample sheet for the same. Sample sheet having 3 sheets. Trend sheet is my raw data and I want to extract data to daily report sheet based on date. If I enter date manually in daily report sheet B2 , data has to come from trend sheet for every 1 hour only( Hour mentioned in A5 to A28. ). Please kindly help me to save my most of the time.
Please find the below file link
https://drive.google.com/file/d/0B9BAL8N1VndhellKNGpsNXo4aG8/view?usp=sharing
Thanks in Advance.
Santosh