Microsoft Office Excel Integration

Open-Plant Excel Addin

Studies show that 67.5% of plant engineers can't perform day-to-day jobs without Microsoft Excel.

In any field of engineering, whether it's civil, electrical, mechanical, instrumentation, chemical, process, and etc, Microsoft Excel has been the dominant engineering and reporting tool for decades.

For this reason, Open-Plant includes an 'Excel Addin' which is a basic feature of Open-Plant. The Open-Plant Excel addin supports Microsoft Excel 2007 and above.
(The stats above was derived from a study conducted by CSU in conjuntion with Engineers Australia)

Easy 3-Step Setup

1

Launch Setup Excel Addin

After installing Open-Plant, from the Windows Start menu, select 'Setup Excel Add-In'
Excel Add-In in Windows Start Menu

2

Click 'Click to Auto Install'

On the 'Auto Install' tab, click on 'Click to Auto Install'. This automatically installs the Excel Add-In to MS Excel.
Excel Add-In Setup Window

3

Setup Open-Plant Login

Click on the 'Setup Login' tab and type in your connection details to Open-Plant. Click 'Save'. You may test connection to check if it connects to Open-Plant.
Excel Add-In Login Window

Excel Add-In ready to go!

Open-Plant Excel Add-In Ribbon

Excel Add-In basic functions

OPValue()

Gets the current value of a tag.

Usage examples:
//This gets the most recent value
=OPValue("FIC101.Value")


//This gets the value at a specific date/time
=OPValue("FIC101.Value","2019-11-27 16:50")
=OPValue("FIC101.Value","2019-11-27 16:50:32")


//This gets the value at D3
//D3 is another cell with a Date/Time Value
=OPValue("FIC101.Value",D3)		


//This gets the value base on current time
=OPValue("FIC101.Value","Now")
=OPValue("FIC101.Value","Now-1day")
=OPValue("FIC101.Value","Now-10hour")
=OPValue("FIC101.Value","Now-30mins")
=OPValue("FIC101.Value","Now-180secs")

OPLive()

Gets the live value of a tag which refreshes every 2 seconds.

Usage example:
=OPLive("FIC101.Value")




















OPNow()

OPNow() is an important function as it gets the current date and time, which is typically used when generating reports. Due to the volatility of Excel's built it Now() function, it is not suitable to be used together with other Open-Plant Excel functions. Use OPNow() instead.

The value of OPNow() can be refreshed by clicking on the 'Refresh' button or by pressing 'Ctrl + R'
OPNow() fixes the common problem with Excel's Now() function
Usage example:
=OPNow()


Open-Plant is a revolutionary Industrial IOT Platform software, used to create and deploy Industrial IT apps/solutions. It is an all-encompassing solution offering both back-end and front-end components i.e. the full stack. From our user's experience, creating and deploying Industrial IT apps became 10x faster and 10x less cost. We serve the mining, energy, oil & gas, construction and manufacturing industry. 

Vlix

Perth, Australia

EMAIL

info@vlix.me
homedownloadtagtagsbookmarkcogsenvelopewechatline-chart