AnsweredAssumed Answered

Accesing AF Element Hierarchy Structure from Excel

Question asked by DaniDava on Feb 26, 2016
Latest reply on Mar 3, 2016 by gregor

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:

 

 

Element:           Pumps

Status               Off

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,

 

Daniel Davalillo

Outcomes