Can someone please advise how to transform this exel sheet into App sheet, Mainly formulas

@Trevwiller Nope, i wasnt sure which functions to use as we need to use the data from the spread sheet.