PriceWaste
PriceWaste[protocol]⟹table
provides a table listing the pricing information for all waste generated by the protocol.
PriceWaste[notebook]⟹table
provides a table listing the pricing information for all waste generated by all completed protocols in notebook within the last month.
PriceWaste[notebook, dateRange]⟹table
provides a table listing the pricing information for all waste generated by completed protocols in notebook in the time period defined by the dateRange.
PriceWaste[team]⟹table
provides a table listing the pricing information for all waste generated by all completed protocols in notebooks financed by team within the last month.
PriceWaste[team, dateRange]⟹table
provides a table listing the pricing information for all waste generated by all completed protocols in notebooks financed by team in the time period defined by the dateRange.
Details
- The pricing is based upon the PricingRate of each type of laboratory waste and how much was generated in the protocol.
- Pricing information is only calculated for Completed parent protocols.
- For the Team or Notebook overloads, non-Completed and non-parent protocols are filtered out and not displayed.
- By default, if teams or notebooks are specified and no date range is provided, function defaults to showing protocols completed in the past 30 days.
- Note that the prices displayed in this documentation are only for the sake of example and do not represent actual prices.
- In order to find the real pricing rate for a type of waste, please Download the PricingRate field from the corresponding Model[Sample] object.
-
MissingPricingRate The following waste models used do not have a listed pricing rate: `1`. These waste models have been filtered out of the displayed results. Please contact ECL to ensure this field is properly populated for all waste models. ParentProtocolRequired The following provided protocol(s) are subprotocols: `1`. These protocols' prices are already included in the price of their parent protocols. Please provide only completed parent protocols to the inputs of PriceWaste. ProtocolNotCompleted The following provided protocol(s) are not yet completed and thus waste pricing cannot be calculated: `1`. Please wait until these protocols are completed and then call this function again.
Input

Output

General Options

Messages
Examples
Basic Examples (10)
Displays the pricing information for each waste type used in a protocol and its subprotocols:


Displays the pricing information for a list of protocols as one large table:


Displays the waste pricing information for all protocols tied to a given notebook:


Displays the pricing information for all protocols tied to a given financing team:


Specifying a date span excludes protocols that fall outside that range:


Displays the pricing information for each waste type used in a protocol and its subprotocols:


Displays the pricing information for a list of protocols as one large table:


Displays the waste pricing information for all protocols tied to a given notebook:


Displays the pricing information for all protocols tied to a given financing team:


Specifying a date span excludes protocols that fall outside that range:


Additional Examples (4)
Options (14)
Consolidation (10)
Specifying Consolidation -> Notebook groups all items by Notebook and sums their prices in the output table:


Specifying Consolidation -> Protocol groups all items by Protocol and sums their prices in the output table:


Specifying Consolidation -> WasteType groups all items by WasteType and sums their prices in the output table:


If OutputFormat -> TotalPrice is specified, this overrides the Consolidation option and returns the total summed price:


If OutputFormat -> Association is specified, this overrides the Consolidation option and returns a list of associations matching WastePriceTableP:


Specifying Consolidation -> Notebook groups all items by Notebook and sums their prices in the output table:


Specifying Consolidation -> Protocol groups all items by Protocol and sums their prices in the output table:


Specifying Consolidation -> WasteType groups all items by WasteType and sums their prices in the output table:


If OutputFormat -> TotalPrice is specified, this overrides the Consolidation option and returns the total summed price:


If OutputFormat -> Association is specified, this overrides the Consolidation option and returns a list of associations matching WastePriceTableP:


OutputFormat (4)
If OutputFormat -> Association, returns a list of associations matching WastePriceTableP:


If OutputFormat -> TotalPrice, returns a single price summing the cost of every waste type:


If OutputFormat -> Association, returns a list of associations matching WastePriceTableP:


If OutputFormat -> TotalPrice, returns a single price summing the cost of every waste type:

