The pictures below show how I’ve laid out my CT Paddle Planner. Total Miles cells, Average PD Miles cells, and all color coding and stop lights in specific cells are automated. I use Tide Graph Pro to get all the future tide, sun and moon info. I’ll have this accessible in an iPad Mini and on the phone. Updates will happen as the route changes due to weather and or desire to explore.
All data in the pictures below are good data but are there for example only. You’ll have to “piece” the pictures together to get an idea of the total spreadsheet layout.