Retrieve data items with Excel functions

To retrieve data, and arrays of data, from your case (to use in Microsoft Excel), use the CaseItem and CaseItemArray formula add-ins.

Note: For the formula add-in to work, a working connection must be established with a local installation of AVEVA Unified Supply Chain via the Plan Excel Add-In.

Retrieve single items from your case

The CaseItem function allows you to retrieve data items from your case to use in Microsoft Excel.

The syntax of the CaseItem function is the following:

=CaseItem(shareName, modelName, casePath, itemFormula, valueName, UoM)

where:

• shareName is the share containing the model you want to get data from.

• modelName is the name of the model.

• casePath is the path to a particular case, for example "Master Case/Sub Case/Sub Sub Case". You can easily copy a case path from the Model Explorer of AVEVA Unified Supply Chain.

• itemFormula is the unique expression identifying the watch item/data item you want to retrieve. An example is "Purchase(Agbami)". This can be found in any watch set containing the item, by looking under the Formula column of the watch window.

• valueName is the name of the particular value you want to retrieve for the watch item. An example is "Solution". See Retrievable Values below for a list of supported value names.

• UoM is the unit of measure for the value, for example "kbbl/d".

Note that all the function arguments are case sensitive and must be enclosed within double quotes. If a case name in the casePath argument contains slashes or double quotes, these additional rules apply:

• Double quotes in a case name must be typed twice.

• If a case name contains a slash character (/) the whole case name must be surrounded by additional double quotes.

  Example: Suppose you have a subcase called Apr/May "special" case. The casePath argument will look like this:
  "Master Case/"Apr/May ""special"" case"/SubSubCase"
  The double quotes around special are typed twice, and the whole subcase name is enclosed within another set of double quotes, so that the / character is not interpreted as a path separator.

If the value cannot be retrieved, for example because of a misspelling in one of the arguments, a #VALUE error is returned.

CaseItem function examples

Differentiate between crudes with the same watch set formula

By default, the CaseItem function accepts either the name or reference of a crude to identify it. For example Purchase(Agbami) uses the name Agbami. However, there may be cases when different crudes have the same watch item formula in your Watch window. To differentiate between these crudes, the following itemFormula types have additional identifiers to help make your formulae unique:

Retrieve multiple items from your case

The CaseItemArray function allows you to retrieve multiple data items from your case to use in Microsoft Excel. While you could use CaseItem multiple times, CaseItemArray is quicker because the item only needs to be queried from AVEVA Unified Supply Chain once.

The CaseItemArrayExact function has the same syntax and mostly works in the same way as CaseItemArray, but it only retrieves enough items to fill the selected rows in Excel. This can result in better performance if the formula you use matches a large number of items.

In the remainder of this topic, statements about CaseItemArray also apply to CaseItemArrayExact unless noted otherwise.

The syntax of the CaseItemArray function is similar to that of CaseItem:

=CaseItemArray(shareName, modelName, cases, itemFormulae, fields, UoMs)

where:

• shareName is the share containing the model you want to get data from.

• modelName is the name of the model.

• cases is a list of paths to the cases you want to retrieve data from. You must pass this argument as an Excel range. You can easily copy a case path from the Model Explorer of AVEVA Unified Supply Chain.

• itemFormulae is a list of expressions identifying the data item you want to retrieve. An example is "Purchase(Agbami)". These expressions can be found in any watch set containing the item, by looking under the Formula column of the watch window. You must pass this argument as an Excel range.

• fields is a list of names of the particular values you want to retrieve, for example "Min,Max,Solution". This can be a comma-separated list, as in the previous example, or an Excel range. See Retrievable Values below for a list of supported value names.

• UoMs is the unit of measure for the values specified in the previous argument.

The range of values returned by CaseItemArray has as many rows as the number of item formulae, and as many columns as the number of cases multiplied by the number of fields.

Example: The range returned by CaseItemArray in the previous image has three rows and nine columns.
The three rows correspond to the three item formulae Purchase(Agbami), Purchase(Dalia) and Purchase(Mars).
The nine columns correspond to three cases each returning three fields (Min, Max and Solution).

As when retrieving single items, you can differentiate between crudes with the same watch set formula.

Wildcard characters for item formulae

You can use wildcard characters in the formulae you include in the itemFormulae function argument, to retrieve multiple watch items at once. For example, this formula retrieves all transport link material results in a Network case:

"TransportLink(*).Material(*).Departing.Period(*)"

Note: Using wildcard characters may result in an error when the items returned by AVEVA Unified Supply Chain are more than the maximum number of rows Microsoft Excel can process. In this case, use the CaseItemArrayExact function to limit the number of returned items to the number of selected rows.
You can also try splitting the request into two or more requests, each returning fewer items.
For example, suppose that the model in the previous example has transport links named to reflect their corresponding plant. You could then create a formula specific to each plant, as follows:
"TransportLink(*Corsicana*).Material(*).Departing.Period(*)"
"TransportLink(*LakeCharles*).Material(*).Departing.Period(*)"

Supported watch items

The following is a list of all the watch item expressions you can use in the itemFormula argument of CaseItem, and in the itemFormulae item of CaseItemArray and CaseItemArrayExact. Replace the portions in italics, such as name, with actual values from your model.

• Supply(name)

• Supply(name).Period(name)

• Supply(name).Period(name).Property(name)

• Demand(name)

• Demand(name).Period(name)

• Demand(name).Period(name).Property(name)

• TransportLink(name)

• TransportLink(name).Departing.Period(name)

• TransportLink(name).InTransit.Period(name)

• TransportLink(name).Arriving.Period(name)

• TransportLink(name).Material(name).Departing.Period(name)

• TransportLink(name).Material(name).InTransit.Period(name)

• TransportLink(name).Material(name).Arriving.Period(name)

• TransportLink(name).Material(name).Property(name).Period(name)

• TransportLink(name).TradedMaterial(name).Departing.Period(name)

• TransportLink(name).TradedMaterial(name).InTransit.Period(name)

• TransportLink(name).TradedMaterial(name).Arriving.Period(name)

• TransportLink(name).TradedMaterial(name).Property(name).Period(name)

• TerminalInventory(name).Opening

• TerminalInventory(name).Opening.Period(name)

• TerminalInventory(name).Closing

• TerminalInventory(name).Closing.Period(name)

• TerminalInventory(name).Closing.Property(name).Period(name)

• TerminalBlend(name).Period(name)

• TerminalBlend(name).Property(name).Period(name)

• TerminalBlend(name).TradedMaterial(name).Period(name)

• TerminalBlend(name).TradedMaterial(name).Property(name).Period(name)

• TerminalBlend(name).Component(name).Period(name)

• TerminalBlend(name).Component(name).Property(name).Period(name)

• NetworkCalculation(name)

• NetworkCalculation(name).Period(name)

• NetworkGlobalParameter(name)

• NetworkGlobalParameter(name).OpeningValue

• NetworkGlobalParameter(name).Closing.Period(name)

• Group(name)

• Group(name).Period(name)

• Group(name).Member(name)

• Group(name).Member(name).Period(name)

• Group(transport link group).Journeys

• Group(transport link group).JourneyDays

• Shipment(name)

• Shipment(name).Period(name)

• Period(name)

• Period(name).Feedstock(name)

• Period(name).Feedstock(name).ProductionMinusConsumption

• Period(name).Feedstock(name).ConsumptionMinusProduction

• Period(name).Feedstock(name).Property(name)

• Period(name).MaterialType(name).ProductionMinusConsumption

• Period(name).MaterialType(name).ConsumptionMinusProduction

• Period(name).Mode(name)

• Period(name).Purchase(name)

• Period(name).Sale(name)

• Period(name).Purchase.MaterialType(name)

• Period(name).Sale.MaterialType(name)

• Period(name).PlantGroup(name)

• Period(name).PlantGroup(name).Member(name)

• Period(name).Inventory(name).Opening

• Period(name).Inventory(name).Opening.Feedstock(name)

• Period(name).Inventory(name).Opening.InventoryMaterial(name)

• Period(name).Inventory(name).Opening.Property(name)

• Period(name).Inventory(name).Feedstock(name)

• Period(name).Inventory(name).Final

• Period(name).Inventory(name).Final.Feedstock(name)

• Period(name).Inventory(name).Final.Property(name)

• Period(name).Inventory(name).Final.ResidualMaterial.Weight

• Period(name).Inventory(name).Final.ResidualMaterial.Volume

• Period(name).Inventory(name).Final.SourceMaterial(processUnit, mode).Weight

• Period(name).Inventory(name).Final.SourceMaterial(processUnit, mode).Volume

• Period(name).Inventory.Opening.Feedstock(name).Total

• Period(name).Inventory.Opening.MaterialType(name)

• Period(name).Inventory.Final.Feedstock(name).Total

• Period(name).Inventory.Final.MaterialType(name)

• Period(name).Calculation(name)

• Period(name).GlobalParameter(name)

• Period(name).GlobalParameter(name).OpeningValue

• Period(name).FeedstockGroup(name)

• Period(name).FeedstockGroup(name).Feedstock(name).Composition

• Period(name).FeedstockGroup(name).Feedstock(name).Disposition

• Period(name).ProcessUnit(name).Loss

• Period(name).ProcessUnit(name).Mode(name).Loss

• Period(name).ProcessUnit(name).Mode(name).Utility(name)

• Period(name).ProcessUnit(name).Mode(name).ProcessModel(name).OperatingParameter(name)

• Period(name).ProcessUnit(name).Utility(name)

• Period(name).Grade(name).Property(name)

• Period(name).Blender(name).Composition(input, output, mode)

• Period(name).Blender(name).Composition(input, output)

• Period(name).Asset(name).Input(name)

• Period(name).Asset(name).Input(name).Mode(name)

• Period(name).Asset(name).Input(name).Mode(name).Feedstock(name)

• Period(name).Asset(name).Input(name).Mode(name).Property(name)

• Period(name).Asset(name).Input(name).Feedstock(name)

• Period(name).Asset(name).Input(name).Property(name)

• Period(name).Asset(name).Output(name)

• Period(name).Asset(name).Output(name).Mode(name)

• Period(name).Asset(name).Output(name).Mode(name).Feedstock(name)

• Period(name).Asset(name).Output(name).Mode(name).Property(name)

• Period(name).Asset(name).Output(name).Feedstock(name)

• Period(name).Asset(name).Output(name).Property(name)

• Period(name).Splitter(name).Output(name)

• Period(name).Splitter(name).Mode(name).Output(name)

• Period(name).Mixer(name).Output(name)

• Period(name).Mixer(name).Mode(name).Output(name)

• Period(name).Tank(name).Output(name)

• Period(name).Tank(name).Mode(name).Output(name)

• Period(name).Manifold(name).Output(name)

• Period(name).Manifold(name).Mode(name).Output(name)

• Summary.ObjectiveFunction

• Summary.TotalPurchasesFlow

• Summary.TotalPurchasesCost

• Summary.TotalSalesFlow

• Summary.TotalSalesCost

• Summary.TotalUtilityPurchases

• Summary.TotalUtilitySales

• Summary.OverallMassBalance

• Summary.OverallVolumeBalance

• Summary.TotalSuppliesFlow.Period(name)

• Summary.TotalSuppliesCost.Period(name)

• Summary.TotalDemandsFlow.Period(name)

• Summary.TotalDemandsCost.Period(name)

• Summary.TotalTransportLinksCost.Period(name)

• PriceSet(name).Scenario(name).Price(name)

• PriceSet(name).Scenario(name).Parameter(name)

• PriceSet(name).Scenario(name).Parameter(name).Price(name)

• Plant(name).TotalInputs.Period(name)

• Plant(name).TotalOutputs.Period(name)

• Plant(name).Feedstock(name)

• Plant(name).Feedstock(name).ProductionMinusConsumption

• Plant(name).Feedstock(name).ConsumptionMinusProduction

• Plant(name).Feedstock(name).Property(name)

• Plant(name).Period(name).Feedstock(name)

• Plant(name).Period(name).Feedstock(name).ProductionMinusConsumption

• Plant(name).Period(name).Feedstock(name).ConsumptionMinusProduction

• Plant(name).Period(name).Feedstock(name).Property(name)

• Plant(name).Period(name).MaterialType(name).ProductionMinusConsumption

• Plant(name).Period(name).MaterialType(name).ConsumptionMinusProduction

• Plant(name).Period(name).Mode(name)

• Plant(name).Period(name).Purchase(name)

• Plant(name).Period(name).Sale(name)

• Plant(name).Period(name).Purchase.MaterialType(name)

• Plant(name).Period(name).Sale.MaterialType(name)

• Plant(name).Period(name).PlantGroup(name)

• Plant(name).Period(name).PlantGroup(name).Member(name)

• Plant(name).Period(name).Inventory(name).Opening

• Plant(name).Period(name).Inventory(name).Opening.Feedstock(name)

• Plant(name).Period(name).Inventory(name).Opening.InventoryMaterial(name)

• Plant(name).Period(name).Inventory(name).Opening.Property(name)

• Plant(name).Period(name).Inventory(name).Feedstock(name)

• Plant(name).Period(name).Inventory(name).Final

• Plant(name).Period(name).Inventory(name).Final.Feedstock(name)

• Plant(name).Period(name).Inventory(name).Final.Property(name)

• Plant(name).Period(name).Inventory(name).Final.ResidualMaterial.Weight

• Plant(name).Period(name).Inventory(name).Final.ResidualMaterial.Volume

• Plant(name).Period(name).Inventory(name).Final.SourceMaterial(processUnit, mode).Weight

• Plant(name).Period(name).Inventory(name).Final.SourceMaterial(processUnit, mode).Volume

• Plant(name).Period(name).Inventory.Opening.Feedstock(name).Total

• Plant(name).Period(name).Inventory.Opening.MaterialType(name)

• Plant(name).Period(name).Inventory.Final.Feedstock(name).Total

• Plant(name).Period(name).Inventory.Final.MaterialType(name)

• Plant(name).Period(name).Calculation(name)

• Plant(name).Period(name).GlobalParameter(name)

• Plant(name).Period(name).GlobalParameter(name).OpeningValue

• Plant(name).Period(name).FeedstockGroup(name)

• Plant(name).Period(name).FeedstockGroup(name).Feedstock(name).Composition

• Plant(name).Period(name).FeedstockGroup(name).Feedstock(name).Disposition

• Plant(name).Period(name).ProcessUnit(name).Loss

• Plant(name).Period(name).ProcessUnit(name).Mode(name).Loss

• Plant(name).Period(name).ProcessUnit(name).Mode(name).Utility(name)

• Plant(name).Period(name).ProcessUnit(name).Mode(name).ProcessModel(name).OperatingParameter(name)

• Plant(name).Period(name).ProcessUnit(name).Utility(name)

• Plant(name).Period(name).Grade(name).Property(name)

• Plant(name).Period(name).Blender(name).Composition(input, output, mode)

• Plant(name).Period(name).Blender(name).Composition(input, output)

• Plant(name).Period(name).Asset(name).Input(name)

• Plant(name).Period(name).Asset(name).Input(name).Mode(name)

• Plant(name).Period(name).Asset(name).Input(name).Mode(name).Feedstock(name)

• Plant(name).Period(name).Asset(name).Input(name).Mode(name).Property(name)

• Plant(name).Period(name).Asset(name).Input(name).Feedstock(name)

• Plant(name).Period(name).Asset(name).Input(name).Property(name)

• Plant(name).Period(name).Asset(name).Output(name)

• Plant(name).Period(name).Asset(name).Output(name).Mode(name)

• Plant(name).Period(name).Asset(name).Output(name).Mode(name).Feedstock(name)

• Plant(name).Period(name).Asset(name).Output(name).Mode(name).Property(name)

• Plant(name).Period(name).Asset(name).Output(name).Feedstock(name)

• Plant(name).Period(name).Asset(name).Output(name).Property(name)

• Plant(name).Period(name).Splitter(name).Output(name)

• Plant(name).Period(name).Splitter(name).Mode(name).Output(name)

• Plant(name).Period(name).Mixer(name).Output(name)

• Plant(name).Period(name).Mixer(name).Mode(name).Output(name)

• Plant(name).Period(name).Tank(name).Output(name)

• Plant(name).Period(name).Tank(name).Mode(name).Output(name)

• Plant(name).Period(name).Manifold(name).Output(name)

• Plant(name).Period(name).Manifold(name).Mode(name).Output(name)

• Plant(name).MaterialType(name).ProductionMinusConsumption

• Plant(name).MaterialType(name).ConsumptionMinusProduction

• Plant(name).Mode(name)

• Plant(name).Purchase(name)

• Plant(name).Sale(name)

• Plant(name).Purchase.MaterialType(name)

• Plant(name).Sale.MaterialType(name)

• Plant(name).PlantGroup(name)

• Plant(name).PlantGroup(name).Member(name)

• Plant(name).Inventory(name).Opening

• Plant(name).Inventory(name).Opening.Feedstock(name)

• Plant(name).Inventory(name).Opening.InventoryMaterial(name)

• Plant(name).Inventory(name).Opening.Property(name)

• Plant(name).Inventory(name).Feedstock(name)

• Plant(name).Inventory(name).Final

• Plant(name).Inventory(name).Final.Feedstock(name)

• Plant(name).Inventory(name).Final.Property(name)

• Plant(name).Inventory(name).Final.ResidualMaterial.Weight

• Plant(name).Inventory(name).Final.ResidualMaterial.Volume

• Plant(name).Inventory(name).Final.SourceMaterial(processUnit, mode).Weight

• Plant(name).Inventory(name).Final.SourceMaterial(processUnit, mode).Volume

• Plant(name).Inventory.Opening.Feedstock(name).Total

• Plant(name).Inventory.Opening.MaterialType(name)

• Plant(name).Inventory.Final.Feedstock(name).Total

• Plant(name).Inventory.Final.MaterialType(name)

• Plant(name).Calculation(name)

• Plant(name).GlobalParameter(name)

• Plant(name).GlobalParameter(name).OpeningValue

• Plant(name).FeedstockGroup(name)

• Plant(name).FeedstockGroup(name).Feedstock(name).Composition

• Plant(name).FeedstockGroup(name).Feedstock(name).Disposition

• Plant(name).ProcessUnit(name).Loss

• Plant(name).ProcessUnit(name).Mode(name).Loss

• Plant(name).ProcessUnit(name).Mode(name).Utility(name)

• Plant(name).ProcessUnit(name).Mode(name).ProcessModel(name).OperatingParameter(name)

• Plant(name).ProcessUnit(name).Utility(name)

• Plant(name).Grade(name).Property(name)

• Plant(name).Blender(name).Composition(input, output, mode)

• Plant(name).Blender(name).Composition(input, output)

• Plant(name).Asset(name).Input(name)

• Plant(name).Asset(name).Input(name).Mode(name)

• Plant(name).Asset(name).Input(name).Mode(name).Feedstock(name)

• Plant(name).Asset(name).Input(name).Mode(name).Property(name)

• Plant(name).Asset(name).Input(name).Feedstock(name)

• Plant(name).Asset(name).Input(name).Property(name)

• Plant(name).Asset(name).Output(name)

• Plant(name).Asset(name).Output(name).Mode(name)

• Plant(name).Asset(name).Output(name).Mode(name).Feedstock(name)

• Plant(name).Asset(name).Output(name).Mode(name).Property(name)

• Plant(name).Asset(name).Output(name).Feedstock(name)

• Plant(name).Asset(name).Output(name).Property(name)

• Plant(name).Splitter(name).Output(name)

• Plant(name).Splitter(name).Mode(name).Output(name)

• Plant(name).Mixer(name).Output(name)

• Plant(name).Mixer(name).Mode(name).Output(name)

• Plant(name).Tank(name).Output(name)

• Plant(name).Tank(name).Mode(name).Output(name)

• Plant(name).Manifold(name).Output(name)

• Plant(name).Manifold(name).Mode(name).Output(name)

• Feedstock(name)

• Feedstock(name).ProductionMinusConsumption

• Feedstock(name).ConsumptionMinusProduction

• Feedstock(name).Property(name)

• MaterialType(name).ProductionMinusConsumption

• MaterialType(name).ConsumptionMinusProduction

• Mode(name)

• Sale(name)

• Sale.MaterialType(name)

• Purchase.MaterialType(name)

• PlantGroup(name)

• PlantGroup(name).Member(name)

• Inventory(name).Opening

• Inventory(name).Opening.Feedstock(name)

• Inventory(name).Opening.InventoryMaterial(name)

• Inventory(name).Opening.Property(name)

• Inventory(name).Feedstock(name)

• Inventory(name).Final

• Inventory(name).Final.Feedstock(name)

• Inventory(name).Final.Property(name)

• Inventory(name).Final.ResidualMaterial.Weight

• Inventory(name).Final.ResidualMaterial.Volume

• Inventory(name).Final.SourceMaterial(processUnit, mode).Weight

• Inventory(name).Final.SourceMaterial(processUnit, mode).Volume

• Inventory.Opening.Feedstock(name).Total

• Inventory.Opening.MaterialType(name)

• Inventory.Final.Feedstock(name).Total

• Inventory.Final.MaterialType(name)

• Calculation(name)

• GlobalParameter(name)

• GlobalParameter(name).OpeningValue

• FeedstockGroup(name)

• FeedstockGroup(name).Feedstock(name).Composition

• FeedstockGroup(name).Feedstock(name).Disposition

• ProcessUnit(name).Loss

• ProcessUnit(name).Mode(name).Loss

• ProcessUnit(name).Mode(name).Utility(name)

• ProcessUnit(name).Mode(name).ProcessModel(name).OperatingParameter(name)

• ProcessUnit(name).Utility(name)

• Grade(name).Property(name)

• Blender(name).Composition(input, output, mode)

• Blender(name).Composition(input, output)

• Asset(name).Input(name)

• Asset(name).Input(name).Mode(name)

• Asset(name).Input(name).Mode(name).Feedstock(name)

• Asset(name).Input(name).Mode(name).Property(name)

• Asset(name).Input(name).Feedstock(name)

• Asset(name).Input(name).Property(name)

• Asset(name).Output(name)

• Asset(name).Output(name).Mode(name)

• Asset(name).Output(name).Mode(name).Feedstock(name)

• Asset(name).Output(name).Mode(name).Property(name)

• Asset(name).Output(name).Feedstock(name)

• Asset(name).Output(name).Property(name)

• Splitter(name).Output(name)

• Splitter(name).Mode(name).Output(name)

• Mixer(name).Output(name)

• Mixer(name).Mode(name).Output(name)

• Tank(name).Output(name)

• Tank(name).Mode(name).Output(name)

• Manifold(name).Output(name)

• Manifold(name).Mode(name).Output(name)

The following watch item expressions support complex arguments. Replace the dots within double quotes with actual values from your model.

• Supply(name="..." active="..." market="..." materialname="..." ref="..." reference="..." share="..." tradedmaterial="...")

• Demand(name="..." active="..." market="..." grade="..." share="..." tradedmaterial="...")

• Feedstock(ref="..." reference="..." name="..." share, tradedmaterial="...")

• Purchase(name="..." active="..." materialname="..." ref="..." reference="..." share="..." tradedmaterial="...")

• Sale(name="..." active="..." market="..." materialtype="..." grade="..." share="..." tradedmaterial="...")

  Retrievable values

  The following valueNames or fields are retrievable using the CaseItem, CaseItemArray and CaseItemArrayExact functions:

  valueName / field	Description	Example
  Active	Active check box	TRUE
  Alert	Alert status	Warning
  Destination	Destination Name	Corsicana
  End	End Date	11/03/2016
  Feedstock	Feedstock Name	Arab Light
  Fixed	Fixed Value	25
  FixedActive	Fixed active check box	TRUE
  Formula	Formula for the 'watch item'	Purchase(Arab Light)
  Grade	Grade Name	Gasoline Regular
  Index	Index of 'watch item' in watch set	5
  Locked	Whether Watch Item is Locked	TRUE
  Marginal	Marginal	-5
  Market	Market Name	Central America
  MaterialType	Material Type Name	Crude
  Max	Maximum Value	100
  Maximum	Maximum Value	100
  MaxActive	Maximum active check box	TRUE
  MaximumActive	Maximum active check box	TRUE
  Min	Minimum Value	2
  Minimum	Minimum Value	2
  MinActive	Minimum active check box	TRUE
  MinimumActive	Minimum active check box	TRUE
  Name	'Watch Item' name	Arab Light Purchase
  Origin	Origin Name	Lake Charles
  Period	Period Name	03 Mar
  Plant	Plant Name	Corsicana
  Price	Price Value	45
  PriceSet	Price Set Name	Corsicana March 16
  PriceSetScenario	Price Set Scenario Name	Low Crude
  PriceUoM	Price Unit of Measurement	$/bbl
  PriceUoMSymbol	Price UoM Symbol	$/bbl
  ReferenceName	Reference Name	ARAL2016A
  Share	Share Name	Training
  Solution	Solution	25
  Start	Start Date	11/02/16
  StreamValue	Stream Value	10 $/bbl
  TradedMaterialName	Traded Material Name	Arab Light
  TransportLink	Transport Link Name	Corsicana Crude Supply
  UoM	Unit of Measurement	kbbl/d
  UoMSymbol	UoM Symbol	kbbl/d