PI World 2020 Lab PI DataLink with Excel’s Advanced Features 2 | P a g e OSIsoft, LLC 1600 Alvarado Street San Leandro, CA 94577 USA Tel: (01) 510-297-5800 Web: http://www.osisoft.com © 2020 by OSIsoft, LLC. All rights reserved. OSIsoft, the OSIsoft logo and logotype, Analytics, PI ProcessBook, PI DataLink, ProcessPoint, Asset Framework (AF), IT Monitor, MCN Health Monitor, PI System, PI ActiveView, PI ACE, PI AlarmView, PI BatchView, PI Vision, PI Data Services, Event Frames, PI Manual Logger, PI ProfileView, PI WebParts, ProTRAQ, RLINK, RtAnalytics, RtBaseline, RtPortal, RtPM, RtReports and RtWebParts are all trademarks of OSIsoft, LLC. All other trademarks or trade names used herein are the property of their respective owners. U.S. GOVERNMENT RIGHTS Use, duplication or disclosure by the U.S. Government is subject to restrictions set forth in the OSIsoft, LLC license agreement and as provided in DFARS 227.7202, DFARS 252.227-7013, FAR 12.212, FAR 52.227, as applicable. OSIsoft, LLC. Published: May 27, 2020 Table of Contents Contents Table of Contents ........ 3 1. INTRODUCTION ....... 6 Workspace & File Locations ...... 6 The Fictitious Plant Used in This Lab ..... 6 How to use this Workbook ...... 9 Useful Resources ....... 9 2. EXERCISE: Create a Report using PI DataLink ...... 10 Objectives ...... 10 Background ....... 10 Calculation Functions in PI DataLink ..... 11 Solutions ...... 13 3. EXERCISE: Analyze Downtime Events using PivotCharts and PivotTables .... 15 Object