Expedition Navigation Software 
1 of 1
- tscan08
- Expert
Offline - Registered: 11/10/2021
- Posts: 11
Historical routing / sail analysis -- sail changes
Does anyone attempt to look at the prevalence of specific sail changes across a set of historical routes? And if so, how?
I'm not sure this is that valuable, but I've been asked if it is possible. Exporting individual routes works for a couple, but not a couple hundred routes.
Thanks
- sparky
- Expert
Offline
- From: Cambridge UK
- Registered: 4/27/2018
- Posts: 224
Re: Historical routing / sail analysis -- sail changes
I've run 40 years worth of routing for the Fastnet and the PacCup and used it for sail selection last year choosing between our kite selection to match our rating cert.
I think after shmooing a bunch of variables I had a couple hundred routes. I was able to export the whole thing as a CSV with a sail selection charts. You can build different charts and load them and export the same routes and get different sail selections charts each export.
- tscan08
- Expert
Offline
- Registered: 11/10/2021
- Posts: 11
Re: Historical routing / sail analysis -- sail changes
Thanks Sparky. Are you looking at the cumulative hours of utilization by sail or at the sail change?
What I'm looking to do is some sort of ranking for which sail changes are most common to inform crew practice. Is there is a way to export step/grid level sail detail from a large batch of routes at once? Again, this is overcomplicating things, but was asked if it's possible.
- •
Thread Starter- Nick
- Moderator
Offline
- Registered: 9/16/2015
- Posts: 2,742
Re: Historical routing / sail analysis -- sail changes
Yes, you can with the Analysis/Filter option.
Campbell field had a video on his web site about a way to use Excel to visualise it nicely.
- tscan08
- Expert
Offline
- Registered: 11/10/2021
- Posts: 11
Re: Historical routing / sail analysis -- sail changes
Thanks. Unless I'm missing something, I can only find a way to export the underlying step / grid data for a single route.
The analysis / filter option seems to only show an aggregate look at how many total hours you're in a sail (or tws/twa bucket) not how many times you switched to the A2.
- •
Thread Starter- sparky
- Expert
Offline
- From: Cambridge UK
- Registered: 4/27/2018
- Posts: 224
Re: Historical routing / sail analysis -- sail changes
From the base window of expedition to export the routing summary for all active routes you select Analysis from the Optimal tool bar. It is in the same group as Results, Clear, and Tooltip (right above Tooltip).
Campbell's website has a great video on it:
Creating an Excel Macro for filter outputs
- tscan08
- Expert
Offline
- Registered: 11/10/2021
- Posts: 11
Re: Historical routing / sail analysis -- sail changes
Much appreciate the responses. I'm familiar with the Analysis tool. While very useful, it doesn't provide what I'm getting at.
Bit of a silly question to begin with and from these responses it seems like no one else feels the need to over-analyze historical routes to tell them what maneuvers to practice...
Best
- •
Thread Starter- sparky
- Expert
Offline
- From: Cambridge UK
- Registered: 4/27/2018
- Posts: 224
Re: Historical routing / sail analysis -- sail changes
Oh - are you looking to generate a list of peels to practice/sails to gybe with?
- tscan08
- Expert
Offline
- Registered: 11/10/2021
- Posts: 11
Re: Historical routing / sail analysis -- sail changes
Yes, that's what I was asked for. We ran historical routing to inform some sail build decisions and as a follow up I was asked if I could help prioritize sail change practice...
- •
Thread Starter
1 of 1