Excel’s Hidden N Function Lets You Add Comments Inside Formulas

Embed Excel formula comments directly into your math using the N and REPT functions to keep your spreadsheet documentation ...
eLife

Inferring variant-specific effective reproduction numbers from combined case and sequencing data

Integrating case counts with genomic sequences quantifies real-time transmission advantages of viral variants.
MUO on MSN

Excel’s MOD function is weird, but now I use it everywhere

The more I learned MOD, the more excuses I found to use it.

Excel’s AGGREGATE Fails on Arrays but Works with Grid Ranges

Learn why the Excel AGGREGATE function fails with arrays and how to fix value errors using helper columns or dynamic LAMBDA and BYROW formulas.
GitHub

HTTP request logger middleware for node.js

Named after Dexter, a show you should not watch until completion. Write log line on request instead of response. This means that a requests will be logged even if the server crashes, but data from the ...
IEEE

Fuzzy Dynamic Event-Triggered Containment Control for Human-in-the-Loop MASs With Error Constraints

Abstract: In this article, the fuzzy dynamic event-triggered (DET) containment control problem for human-in-the-loop (HiTL) multiagent systems (MASs) with error ...
IEEE

Extremum Seeking Control With an Adaptive Gain Based on Gradient Estimation Error

Abstract: This article presents an extremum-seeking control (ESC) algorithm with an adaptive step size that adjusts the aggressiveness of the controller based on the quality of estimates obtained ...