AnsweredAssumed Answered

Variable batch time control limits in Batch View

Question asked by ACielinski on Apr 18, 2018

I would like to use Batchview in Pi Process book to display past batch times to operators.

How would I add control limits to display in Batch view Gant chart when a batch time is over the expected batch time for that specific product.

I have the "desired" batch times in a spreadsheet correlated to product name. Product name for each batch is already pulled to batch view.

 

Is there a way to reference/vlookup in a spreadsheet or create a table in Pi so batch view knows what expected batch time should be for each product to display control limits/conditional formatting?

Outcomes