Problem calculating transmissions in SANS spreadsheet
When sample transmissions are missing, the calculated transmissions are associated consecutively to samples 1, 2, 3, etc., so they do not appear in the right row (see screenshot).
It does not make sense to have a sample and no transmission, so this could be considered bad user input, but check if something can be done.