Approach R10 sim session data to my bag.

Glad to share the ideas.

Yeah I sort by club. So I import the data from each session on one big page called “Imported Data”. Then I have separate pages (“sheets”) for each club. All the formulas on each of those pages looks at the imported data and the “club type” column that Garmin includes in the data. For example, to find the standard deviation on the Lob Wedge sheet I use =STDEV(IF('Imported Data'!$D:$D="Lob Wedge",'Imported Data'!E:E))

Using commas to separate each argument in the function, this function basically says “find the standard deviation of the data, if, on the Imported Data sheet, column D says “Lob Wedge”, include the associated Imported Data column E”.

I don’t yet have a good way of filtering by date, but I just got lazy and didn’t really try. I can give it a go tomorrow and see if I come up with something reasonable. Then you could plot it onto a trend… that would be sweet.

You may be a novice programmer but you definitely know your way around a spreadsheet. This is starting to get interesting. Next question: is each session a separate file and the “imported” sheet and the “club” sheets are part of that file? You must have a “template” file with all the formulas and sheets created, is that correct? I haven’t done much with multiple sheets in one file, although I did use the LOOKUP function to manually adjust quota points for a 50 person league a few years ago. And have forgotten everything I learned doing it. But that’s just being 78 and a long way from my programming days. Thank heavens for spreadsheets - they are programming enough for this old bird…

Get ready to read a novel...

I thought I was good with spreadsheets until I saw some of the things my peers can do. People write formulas that absolutely blow my mind haha. I messed around for a bit today, but getting the data to sort itself by date is proving to be beyond my ability. It's like the whole sheet needs to be pre-built with all the days I plan to hit in advance.

Each session is imported into a folder in my Drive, then I have to manually copy-paste it into the first sheet in my analytics file (titled "Imported Data"). I'm sure there's a way to automate this, or do it differently (you can write a function that will pull data from different files entirely). The first page of my analytics file has all of my sessions in one big list, but each session also exists as a separate file that isn't used in calculations.

I use something like a template file... basically I have a sheet for each club in my bag (all of these sheets are in the analytics file, not their own files). All the formulas on the club sheets are looking for data ONLY for the associated club. So the 7 Iron page has a lot of: IF('Imported Data'!$D:$D="7 Iron"... and the 3 Wood page is all: IF('Imported Data'!$D:$D="3 Wood". Lastly, I have a "Data Presentation" sheet that combines all the clubs and displays the final numbers in a comparative list. Each of the columns in this list pull data from the individual club sheets. So my 7 Iron column in the "Data Presentation" sheet is just a bunch of functions like ='7 Iron'!C$10, ='7 Iron'!D$10, ='7 Iron'!E$10.

So its a three step process. Import the data into the main sheet, filter outliers and sort by clubs on more sheets, look at each of the filtered sheets and conglomerate the final numbers together.

All of this is barely scratching the surface of what programs like Google Sheets and Excel can do. If you haven't already done so, check out ChatGPT. It's intelligence is mostly just algorithmic logic, so its VERY good at writing out formulas in Excel and Sheets for you. You just have to be very specific and clear with what you're looking for. You also need to have a fair idea of exactly what you're looking to do, and a logic path to the end-goal. Basically, you need to be ably to write out a formula in plain language, and ChatGPT can convert it to Sheets language for you. Here's an example I just did:

ME: "Write me a Google Sheets formula that finds the range of values in column E, excluding any values that fall outside of 2 standard deviations, so long as the phrase "5 Hybrid" is in column D."

ChatGPT: "To find the range of values in column E, excluding any values that fall outside of 2 standard deviations, so long as the phrase "5 Hybrid" is in column D, you can use the following formula in Google Sheets: [ =MAX(FILTER(E:E, D:D="5 Hybrid")) - MIN(FILTER(E:E, D:D="5 Hybrid")) ]"

ChatGPT then goes on to explain what each portion of the function does and why. I notice no standard deviations...

ME: You forgot to include the 2 standard deviation filter.

ChatGPT: Apologies for the oversight. To include the 2 standard devi...blah blah... use this formula: [ =MAX(FILTER(E:E, D:D="5 Hybrid", E:E <= AVERAGE(FILTER(E:E, D:D="5 Hybrid")) + 2 * STDEV(FILTER(E:E, D:D="5 Hybrid")))) - MIN(FILTER(E:E, D:D="5 Hybrid", E:E >= AVERAGE(FILTER(E:E, D:D="5 Hybrid")) - 2 * STDEV(FILTER(E:E, D:D="5 Hybrid")))) ]"

This formula is insanely long and complicated for my noggin, but I copy-pasted it into a test sheet and lo and behold, it works.

I’d love to have a copy of the spreadsheet.  I’m pretty excel savvy, but no need to re-invent the wheel.

Hey 1400 (I hope you don’t mind if I use your nick number) - Wow, double wow, and triple wow. And, hold your horses, we may be chasing the wrong rabbit. Check out Golf Shot Analytics. It used to be R10 Analytics but now supports three other monitors besides the R10. It looks like it does a lot but I’m going to have to pull out my old Windows system to try it out. Best feature: it’s FREE! How someone can develop something like this and then not charge for it boggles my mind. Link below…

[Link removed]

Edited 7/7/2023: Per terms of use and use external 3rd party links. 

Jaws, I can’t share a link here. Id be happy to share the spreadsheet with you though. Not sure how to get a link to you on this site.

But, like KC says- Golf Shot Analytics. I’ve heard of it, and I guarantee it’s going to 100x superior to anything I scrape together in Sheets.

Then create a new area that averages sim session data. We can export the data and quite easily do this so I'm not sure your dev team is actually understanding the ask of many of its customers. Hopefully they figure something out

I read some thing where they said they don’t want to include driving range data because it isn’t accurate, because you’re not actually on the course. So I don’t know if this means you’re supposed to carry the R10 with you when you play around and set it up before every shot?

The shot data is a simulation based on radar derived metrics for each shot, and is programmed to give an estimate as accurately as possible with the information available recorded within the space available. 

The club list in the My Bag section will only display distances recorded during an actual round of golf using GPS with the AutoShot feature detecting the shot, measuring distance using GPS, and then sensors or manual assignment of shots to the club used during an actual round. 

Per your comment, the simulated shot distances derived through radar on the Approach R10 are not enabled towards My Bag max/average distances, because distance on the R10 is calculated via radar...vs GPS distance for actual shot to shot distances during a real round.