Currently we have an Excel report selected via web site. The engineer will select an area of the plant to (AF element structure) and an Excel spreadsheet is created pulling the equipment values (i.e. pump) for all equipment pumps with the scope selected below:
Time Frame: Daily
Values: Status Discharge Pressure Discharge Temperature Suction Pressure Suction Temperature Flow Rate
Date Range: From: 02/01/2016 To 02/15/2016
Run Report (button to generate the excel report)
The report generates in Excel a report like this;
Equipment Timestamp Status Discharge Pressure Discharge Temperature Suction Pressure Suction Temperature Flow Rate
ESP-Pump1 02/01/2016 Off 1472 174 537 192 68
ESP-Pump2 02/07/2016 Off 1279 153 435 179 59
We want to get rid of the web site and try to generate the Excel report directly from MS Excel. For this new approach, we want to explore the possibility to perform the selection of the Pumps in Excel (Driven by the AF Element hierarchy structure). This would allow users to select a plant area and pull in data for all relevant pumps belonging to the selected area in a report with the same format to the Excel report generated via web site.
Based on the above, I would be grateful if you can provide me some recommendations to approach the new desire solution to generate the Excel report directly from Excel. The idea is to connect directly to AF element hierarchy structure from Excel.
Looking forward to hearing from you soon,
All the best,