Excel Lambda basic functions

lambdaBasicFunctions.txt

/*
Partly taken from samples to AFE
https://github.com/microsoft/advanced-formula-environment
more exactly from
https://github.com/microsoft/advanced-formula-environment/blob/main/examples/Lib.md
*/

// ======================================================================================================
// Timing a computation wrapped in a thunk

calculationTime = LAMBDA(thunk,
  LET( start, NOW()
     , value, thunk()
     , end, NOW()
     , days, end - start
     , ms, days * 24 * 60 * 60 * 1000 // milliseconds (resolution 10ms on desktop)
     , ms_round, round(ms,0)
     , "Calc time: " & ms_round & " ms"
     )
);
// ======================================================================================================