Related

Garmin R10 csv data all weird?

Daniel102017
over 1 year ago

Hello all
- hoping for som ehelp here. I have just completed my first ever Garmin range session and shared the .csv data to excel. After having nomralised the data from comma-seperated into columns I can now see very odd data results eg for club head speed and ball speeds? How do I convert the data to usable data stats? Example: (Danish language)

[km/t] Club head speed [deg] Attack angle [deg] Club path [deg] Club face [deg] [km/t] Ball speed Smach factor [deg] attack angle
06/19/23 11:10:02 AM Carsten [edited] 7j Taylormade M2 Tour  7-jern 1.338.134.490.966.790 -15.018.465.518.951.400 -0.5069372653961182 0.678464949131012 11.854.022.145.271.300 18.459.044.494.628.900 13.794.610.795.281.300 15.353.713.035.583.400

I know that I am not striking my ball with a club head speed of billions og km/t :-) Nor is my smash factor above 13 billion (I wish), nor is my :

Dist af carry
[m]
1.413.203.125

Sooo... how do I get usable data out of these??
Best Carsten

Edit made to remove full name for the privacy and maintaining public anonymity of forums use per terms of use. 

  • 0 over 1 year ago

    Hi Carsten (PS: I just visited Denmark and loved the courses!) How are you importing the csv into Excel? 

    Below is the best method to avoid any transformations in data. 

    For me the result is a file that "only" is misalgined on the decimal separator, which makes sense, as my regional settings on my laptop are USA.  

    (and a spectacular R10 clubspeed misread on the last line :-)) 

    If you just attempt to leave it to let Excel decide on how to convert and open the CSV by double clicking on it, you could end up with numbers that are harder to convert - even though in my case (Excel 365 Enterprise edition) it's still not far off: 

     

  • 0 over 1 year ago in reply to Pierre1969

    Tip for both:

    If You have a windows pc do a Google search for Marc Overmars, golf shot analysis.

    If You ask me a must have for all r10 users wanting to improve their game.

    And for reasons I really don't understand I can't link to the program here.

  • 0 over 1 year ago in reply to odd tore

    Thank God that's really Mark Overmars, not the ex-Ajax football player Marc. He wouldn't be able to write a (VB?) code to convert the csv for us. Anyhow, I am fine with my own imports 

  • 0 over 1 year ago in reply to Pierre1969

    VB code, or any other code, shouldn't be necessary.  It's not as if CSV is particularly challenging.  If Garmin isn't creating/exporting CSV in a format such that it can just be read in to Excel, LibreOffice Calc, or any other capable spreadsheet program in such a manner that one ends up with usable data, then they're doing it wrong.

  • 0 over 1 year ago in reply to SEMI Duffer

    The Garmin Golf app allows export of the session data which translates into basic text formatted .CSV where the cells are formatted to display the session data by Date, Player, Club Name, Club Type, Club Speed, and the rest of the metrics provided in the app during the session. 

    Depending on the source you save the .CSV file to from the Garmin Golf app > To smartphone ...the .CSV could be altered depending on the app used to store file. 

  • 0 over 1 year ago in reply to Pierre1969

    This program is not for import of data, but analyse them.

    Really useful actually.

  • 0 over 1 year ago in reply to odd tore

    I understand part of the conversation is regarding virtual basic, ..etc. I was simply elaborating on the .CSV file exportable. Anything past the .CSV being sent from the app falls to the user to figure out what/where/how they would like to use the info from the file. 

  • 0 over 1 year ago in reply to Garmin-Cody

    So why is it not allowed to link to a program that use the data?

    This is what I don't understand.

    Garmin golf app is not very useful for analysing data, I think most can agree on that. Golf Shot Analysis program is.