Skip to content

Instantly share code, notes, and snippets.

@pbartxl
pbartxl / Inventory library
Created July 18, 2024 15:51
FIFO Lambda in Excel
/* FUNCTION NAME: Calculateλ
DESCRIPTION:*//**Builds tables of output costs from input and output tables*/
/* REVISIONS: Date Developer Description
01 Mar 2024 Peter Bartholomew Original Component
17 Jul 2024 Peter Bartholomew Major revision to tracking entries in combined table
*/
Calculateλ
=LAMBDA(
// Parameter Declarations
[outFlow], [inFlow], [unitCost], [option],