I make extensive use of the advanced features of the spreadsheet in org tables, specifically having a first column that indicates which rows should be calculated or not. Check out the org info manual
(org) Advanced features and the token you want in the first column would be '#' for those rows that should be calculated. this will allow you to exclude the second row from any updates. -- : Eric S Fraga, with org release_9.6.1-278-ge52c53 in Emacs 30.0.50