Excel Formal Stocktake Pinboards

• stocktake.value
  Total value of stocktake
• stocktake.productcount
  Total number of different products that were counted
• stocktake.totalcount
  Sum of counts for products. This counts does NOT consider units of measure and lumps everything together, so is somewhat meaningless if you use various ways of measuring products (weight, size, length, etc)

Arguments

Parameter	Name	Notes	Examples
1	Stocktake Id	Required	123
2
3
4
5
6	Restrictions		supplier=1245 department=34 uom=20

Examples

Formula	Output	Notes
=pinboard("stocktake.value", 2, "", "", , , "department=188")	18253.45	Total value (cost) for stocktake #2 and only products that are currently in department #188
=pinboard("stocktake.productcount", 2)	4823	Number of different products (not counts of them) that were counted.
=pinboard("stocktake.totalcount", 12,,,,,"department=16 supplier=4")	22317	Total number of products counted for stocktake #12, restricting to only those products currently supplied by supplier #4 AND in department #16
=pinboard("stocktake.totalcount", 12,,,,,"department=16 supplier=4 uom=1")	984	Total number of products counted for stocktake #12, restricting to only those products currently supplied by supplier #4 AND in department #16 AND are measured in units/eachs (which is the default)

Restrictions

The above pinboards are able to process 3 specific restrictions:

• supplier=N Restrict to products currently supplied by supplier id #N. A value of zero for N, will select products not assigned to any suppler
• department=D Restrict to products currently assigned to department id #N. A value of zero for D, will select products not assigned to any department
• uom=Q Restricts to products currently measured using the unit of measure with id Q. A value of 0 or 1 will select all unit based items.

  UOM id	Common Name
  0	Units/Each
  1	Units/Each
  20	Kilogram
  21	Grams
  30	Metre
  31	Centimetre
  40	Litre
  41	Millilitre