Hello,
Am seeking expert assistance in creating a spreadsheet that will convert recorded raw decimal values to latitude and longitude degrees decimal (Lat XX.xxxxxxxx, Long XXX.xxxxxxxx) format.
The recorder records data this way:
4 words per frame
4 sub frames per frame
12 bits per word
Parameters:
Latitude
Lat1, word 26, sub frame 1,2,3, and 4, 12 bits used, and raw decimal value is 279.
Lat2, word 58, sub frame 1,2,3, and 4, 12 bits used, and raw decimal value is 279.
Lat3, word 90, sub frame 1,2,3, and 4, 12 bits used, and raw decimal value is 279.
Lat4, word 122, sub frame 1,2,3, and 4, 12 bits used, and raw decimal value is 279.
Longitude
Lon1, word 10, sub frame 1,2,3, and 4, 12 bits used, and raw decimal value is -318.
Lon2, word 42, sub frame 1,2,3, and 4, 12 bits used, and raw decimal value is -318.
Lon3, word 74, sub frame 1,2,3, and 4, 12 bits used, and raw decimal value is -318.
Lon4, word 106, sub frame 1,2,3, and 4, 12 bits used, and raw decimal value is -318.
With the above information, the lat coefficient is 0.125 and the lon is 0.25
Thanks for the help anyone can provide.
Respectfully,
Tim
Am seeking expert assistance in creating a spreadsheet that will convert recorded raw decimal values to latitude and longitude degrees decimal (Lat XX.xxxxxxxx, Long XXX.xxxxxxxx) format.
The recorder records data this way:
4 words per frame
4 sub frames per frame
12 bits per word
Parameters:
Latitude
Lat1, word 26, sub frame 1,2,3, and 4, 12 bits used, and raw decimal value is 279.
Lat2, word 58, sub frame 1,2,3, and 4, 12 bits used, and raw decimal value is 279.
Lat3, word 90, sub frame 1,2,3, and 4, 12 bits used, and raw decimal value is 279.
Lat4, word 122, sub frame 1,2,3, and 4, 12 bits used, and raw decimal value is 279.
Longitude
Lon1, word 10, sub frame 1,2,3, and 4, 12 bits used, and raw decimal value is -318.
Lon2, word 42, sub frame 1,2,3, and 4, 12 bits used, and raw decimal value is -318.
Lon3, word 74, sub frame 1,2,3, and 4, 12 bits used, and raw decimal value is -318.
Lon4, word 106, sub frame 1,2,3, and 4, 12 bits used, and raw decimal value is -318.
With the above information, the lat coefficient is 0.125 and the lon is 0.25
Thanks for the help anyone can provide.
Respectfully,
Tim