Define custom report templates

Assay data is retrieved using two special strings defined in the Excel worksheet. The two supported retrieval calls are:

• Info("Info Field Code") - used to obtain reference information for the assay

• Recut(Property("Property Code"), Stream("Stream Code")) - used to obtain recut property values for the assay

where:

• Info Field Code is the DLL code of the required information field. For example, 'SampleDate' to request the sample date the assay and 'PIMSCode' to retrieve the PIMS Tag associated with the crude.

• Property Code is the DLL code for the property in the form 'DLL Property Code, Temperature (where appropriate) or Basis, Unit'. For example, 'API, none' to request the API of the entered stream, 'Den, 15C, g/cc' to request the density @ 15°C of the entered stream or 'ARO,V,%' to request the aromatics content (by volume) of the stream. See Property codes.

• Stream Code is the code for the cut points of the stream in the form 'IVT, FVT, Unit'. For example, 'IBP, FBP, C' returns the property value for the whole crude, and '60, 150, F' returns the property value for the light naphtha (60 - 150°F, 15 - 65°C) stream.

During report generation the product will replace the above strings in the Excel workbook with the information or recut property value defined by the string. If the workbook contains multiple worksheets Assay will iterate over each different worksheet. To control the formatting of the output numbers use the formatting options present in Microsoft Excel. For example, to output density to four decimal places set the cell to use the Number format with four decimal places. Graphs may be drawn using the functions of Excel, plotting values calculated by the product.

Example

To calculate the whole crude density:

Recut(Property("DEN,15C,g/cc"),Stream("IBP,FBP,C"))

To calculate the paraffins content (by weight) of the 100-150°C cut:

Recut(Property("PAR,W,%"),Stream("100,150,C"))

To calculate the kinematic viscosity at 130°C of the 1000°F+ vacuum residue cut:

Recut(Property("VIS,130C,cSt"),Stream("1000,FBP,F"))

To obtain the country of origin of the assay:

Info("Origin")