Emerson Exchange 365

• Not Answered

Batch historian data to excel report through excel-addin?

Hi. 

i know excel add-in able to achieve DeltaV database data to excel and generate excel report for plant operators.

wondering if any method for excel add-in to achieve Batch history data? e.g)Batch ID/Batch start time/end time so.on..

Thanks!

chanwoopark

• 28 Mar 2019 4:22 AM
• Cancel

4 Replies

• Martin v. Bergeijk

  

  • 28 Mar 2019 11:29 AM

  I did create a .NET app some time ago to create such reports...

  • Cancel
• Anas Mustafa

  

  • 28 Mar 2019 8:01 PM

  Hi Chan,
  We had to do some data mining to streamline our processes couple of months ago. We used PI BatchView Excel Add-in to fetch last 10 years of data. The nice thing about it is that you can filter all the way to the phase level if you know your filter parameters i.e BatchID, Recipe Name etc...We were able to pin point the issues in our process by modeling the data we received from PI Historian and we used PI Datalink for our process history to create charts side by side. So, PI Batchview is the Add-in you should use you have to configure it obviously to use your PI Historian database. Hope this helps!

  • Cancel
• chanwoopark

  

  • 29 Mar 2019 1:58 AM

  In reply to Martin v. Bergeijk:

  Thanks Martin for your comments. Could you please tell details abt .net app?

  • Cancel
• chanwoopark

  

  • 29 Mar 2019 2:00 AM

  In reply to Anas Mustafa:

  Thanks Anas!. let me google PI excel addin! Cheers!

  • Cancel