I asked for one minute data in Excel, but PHD is only giving me data every 5 minutes! What's up?

Q&A ForumCategory: QuestionsI asked for one minute data in Excel, but PHD is only giving me data every 5 minutes! What's up?
Guest asked 4 years ago

I have the Excel Addin version 320 for PHD 321.  I requested 1 minute data and it keeps giving me data every 5 minutes.  I know this tag is collected every 30 seconds.  Why is it doing this?  I have had this spreadsheet for years and it never did that before upgrading.

1 Answers
Jason Baum answered 3 years ago

There is a crazy default Honeywell sets up for you for the Excel add-in which gives almost everyone grief – and that is the culprit!  
 
To alter this setting for the Excel add-in, click on Uniformance in the menu, then click on the gray gear icon “Options”.  Next click, Configuration, Local, Application Defaults, Performance, Enable performance optimization:  Change to False
 
This one is the MOST FRUSTRATING setting in the Excel addin.  It will limit the number of results, inexplicably, to the “Maximum Data Values” setting just below it!  So, let’s say you are wanting to see the tag values every minute for the last 5 days, this should return 60min x 24 hours x 5 days = 7,200 data values.  However, because of this setting, which is, by default, 1000, it will only return 1000 values during that time frame.  It will, therefore, say, “I know they asked for 1 minute data, but since I have the limit of 1000, I will only give them data every 7.2 minutes to reduce the number to something acceptable.”  The user either doesn’t notice, possibly making incorrect assumptions, or gets frustrated about why there isn’t data every minute!  Do yourself a favor and turn this setting off!  

Your Answer

3 + 1 =