@Nick, with your better understanding of the data logged - what are your thoughts on trying to "uncalibrate" / "recalibrate" the logfile in excel ... would it even be possible? I'm think both in terms of how the logging frequency would affect calculating backwards and also if I have all the information needed. I'm for example not fully sure of how, when or what the 3D motion sensor would change the logged data and if it would be a problem.
I understand it's not super simple - but is it even worth a try?
My first go would be to be able to recalculate TWA and CURRENT SET & DRIFT after changing "simple" calibrations to AWA/MHU, TWS, BSP, heading offset and Leeway ... but obviously I would have a go at TWA calibrations as well and possibly look in to heel corrected speed and possibly other calibrations I can't even think for now :-)
I'm thinking if I load the recalibrated log in expedition, looking at currents in the track and using the stripcharts would be really helpful to evaluate any changes made.
I need to spend some time uncovering all the calculations done and I know B&G use cubic spline interpolation for TWA - but that should be possible to recreate.
I'm a statistical data analyst by trade - so as long as I have the data and can find the calculations I'm thinking I should be able to do the math ... but before I dig to deep - do you think there has been so many calculations applied by the time the data ends up in the logfile that it can't be "recalibrated" or do you think it can be done using the log file alone? Would it be worth a try to improve calibrations?
I do have a Yacht Devices Voyage Recorder YDVR-04 in the system .... I haven't really spend to much time with the logs from that as I typically use expedition .... but possibly there could be more/ other data recorded from that.