Answer:
see picture
Explanation:
There is no need to store all the values, you can just keep track of the highest. Up to you to create a numbers file with 100 values.
You use the Alignment sheet in the format cells dialog box to position data in a cell by centering it, for example. Generally along the middle branch is a line or centerline of the definite pipeline on a scale of whatever is indicated.