Optimizing the worksheet

[ED_12686351]

I am fairly new to this software and would like to understand if there is any better way to perform the things that I am trying to do my belief is there should be some way I am not just getting that 

Could someone from experts help me to make the content small and cleaner ?

[terryhendicott]

Like this is more ordered.

[terryhendicott · Accepted solution]

And with a bit more understanding of zero based indexing

[LucMeekes]

More compact, and ready for any expansion of either of the two tables.

(Note that Terry's sheet contains a typing error on Length₂.)

Success!
Luc