Hello,

I am trying to create a table in PI Processbook. Until now I do it by drawing rectangles and arranging them so that it does look like a table. After that I add a text-field in every rectangle.

This is very time consuming. Is there a faster and maybe more elegant way to draw tables in PI Processbook?

The table is for comparing PI Tags with given specifications.

An other Problem that I have is, that I create PI-calculations in PI Processbook whoch work very good and always Show me the right results but These PI-calculations can't be reffered to when I create a new PI-calculation

E.g.:

'Feed' = (S + 3T)/2

'Loss' = ('Feed' - C)/20

How can I use a calculation within a calculation. Until now I can only use PI-Tags and have to create These calculations always from the beginning (that means: 'Loss' = ((S+3T)/2 - C)/20 ). The calculations in the example are simplyfied, for my real calculations there are a lot more tags and operations involved

Thank you for your help!!!

greetings

Jan-Niklas

Hi Jan,

You can embed an excel spreadsheet in a ProcessBook display. You could build your table in Excel and then have an embedded object linked to it in Processbook. Would this meet your needs? You can find more information starting on page 227 in the ProcessBook user guide https://techsupport.osisoft.com/Downloads/File/71ceb4c1-f7ea-4327-831a-0e38e30f551d

Creating calculations in PI ProcessBook is rather an old method of doing calculations. I would highly recommend to use AF and the Analysis Service to do this. To my knowledge there is no way of doing this in PI ProcessBook without a programmatic solution (using VBA).

Thanks,

Sebastien