There seems to be a bug with populating excel row formulas when a column is hidden. This works okay where the column is visible.
The duration tab of the attached spreadsheet has columns G,H & I hidden when the report is generated (they have been made visible prior to saving).
The excel row formula is populated into range G495:I495 but is missing from range G4:I494.
Also the named range "DurationData" only covers rows B3:I4 and not B3:I495. I believe v1.5.13 will fix this but I highlight it as this is not just missing one row but is missing 494 rows.