How to Download and Install Pi Datalink 2013 for Excel
Pi Datalink is a Microsoft Excel add-in that enables you to retrieve and analyze data from your Pi System directly into a spreadsheet. With Pi Datalink, you can create flexible reports, view data in context, perform complex analysis, and gain new perspectives on your operations data[^1^] [^2^].
If you want to download and install Pi Datalink 2013 for Excel, here are the steps you need to follow:
Go to the OSIsoft website and log in with your username and password.
Navigate to the Downloads section and select Pi DataLink.
Choose the version 2013.1.0.0 and click on Download.
Save the file PiDatalink_2013_Install_Kit.zip to your computer and extract it.
Run the setup.exe file and follow the instructions on the screen.
When prompted, enter your license key or choose to activate later.
Restart Excel and check if the Pi DataLink tab appears on the ribbon.
Congratulations! You have successfully downloaded and installed Pi Datalink 2013 for Excel. Now you can start using it to access and work with your Pi System data in a familiar spreadsheet environment.
If you need more help or have any questions, you can refer to the Pi DataLink user guide[^3^] or contact OSIsoft technical support.
Pi DataLink Examples
To help you get started with Pi DataLink, here are some examples of how you can use it to create different types of reports and analyses for your operations data.
Example 1: Daily Production Report
In this example, you can see how to create a daily production report that shows the total production, average temperature, and maximum pressure for each product line in a plant. The report uses the Current Value function to get the latest values of the PI tags and AF attributes, and the Compressed Data function to get the historical values for a specified time range. The report also uses Excel formulas and charts to calculate and display the key performance indicators (KPIs) for each product line.
Example 2: Event Frame Analysis
In this example, you can see how to use Pi DataLink to retrieve and analyze event frame data from your Pi System. Event frames are a way of capturing and storing important events that occur in your operations, such as downtimes, batches, or alarms. The report uses the Event Frame Search function to find and filter event frames based on their name, template, start time, end time, or attribute values. The report also uses the Event Frame Details function to get the information about each event frame, such as its duration, status, or attribute values. The report then uses Excel pivot tables and charts to summarize and visualize the event frame data.
Example 3: Energy Consumption Report
In this example, you can see how to use Pi DataLink to monitor and report on your energy consumption data from your Pi System. Energy consumption is an important aspect of sustainability and efficiency for any organization. The report uses the Time Filtered Data function to get the energy consumption data for water, electricity, and thermal energy for a specified time range and filter expression. The filter expression can be used to exclude data that is not relevant or reliable, such as zero values or bad quality data. The report also uses Excel formulas and charts to calculate and display the total and average energy consumption for each type of energy. 061ffe29dd