Can anyone help with This chart for Excel? I do not know how to divide the rows and columns. In column F, enter formulas that use a function to calculate % Caught with Table (fish caught with Table hook divided by the total number of fish caught).

Format the % Caught with Table values as a percent with one decimal place.

answer:

function processpath(data)

begin

initialize total to zero

initialize a to zero

initialize ea to zero

initialize b to zero

initialize eb to zero

initialize diff to zero

while a is less or equal to the number of elements of data - 2

set b to equal a + 1

set ea to the elevation from data element #a

set eb to the elevation from data element #b

set diff to the value of absdiff(ea,ab)  

add diff to the total

increase a by 1

return total

end