This video contains the instuctions to use this analyzer spreadsheet on google sheets
Go to file -> settings -> calculation tab -> Iterative calculation (change to Yes) -> Save settings (bottom right)
Go to file -> settings -> calculation tab -> Iterative calculation (change to Yes) -> Save settings (bottom right)