Page 1 of 1
Hole Viewer utility spreadsheet
Posted: Thu Apr 11, 2019 9:50 pm
by JMK59
I made this utility for myself, but I'd like to make it available to everyone in the PGLS community - the Hole Viewer.
It started as a virtual Caddy assistant, but it can also provide a quick way to make a scorecard.jpeg.
It reads any course.description file, and creates a graphical output of the pin locations, all combinations of Tee-Pin yardages, and a rough hole layout with elevation changes. And it also makes scorecards (for RandyG).
I've been running it on a second monitor while I watch R1 of the Masters on my main. Have fun with it.
https://mega.nz/#!upxg3KjY!LoYHX2nDCxJq ... GKMxrr54kU
Here's a pic:
[/attachment]
This works with EXCEL 2007 and newer, but not any of the Online Excel's that don't support the Visual Basic Language (VBA).
JMK59
Re: Hole Viewer utility spreadsheet
Posted: Fri Apr 12, 2019 6:56 am
by Mwh65
Thanks JMK59,
Great utility

Re: Hole Viewer utility spreadsheet
Posted: Fri Apr 12, 2019 3:00 pm
by JMK59
Mark,
I take it you've downloaded, and tried out the utility? Were the instructions easy enough to follow, and did all the buttons and pull-downs work as expected? Only course I found to not work as expected was 9_at_Mistmore.
John
Re: Hole Viewer utility spreadsheet
Posted: Sat Apr 13, 2019 11:45 am
by Mwh65
Hi,
I had no issues with it using Office 365.
Re: Hole Viewer utility spreadsheet
Posted: Sun May 05, 2019 6:19 pm
by JMK59
The next version of the Hole Viewer will be out before the PGA Championship.
One of the new features is a Course Route Map (below). I'm working on a way to show the wind direction wrt each hole.
Below is the Pro Visualizer website satellite view.
Re: Hole Viewer utility spreadsheet
Posted: Wed Jun 19, 2019 12:01 am
by JMK59
A new version of the Hole Viewer Utility is available here:
http://www.perfectparallel.com/topic/11 ... t-utility/
John
or....download from link below.
Re: Hole Viewer utility spreadsheet
Posted: Wed Jun 26, 2019 5:23 am
by OnyxCarp
John, this is very well done. As a GIS consultant I am licking my paws after exploring this utility!
Re: Hole Viewer utility spreadsheet
Posted: Wed Jun 26, 2019 5:18 pm
by JMK59
Onyx,
Glad you like it. I originally made it to help me select and play exact pins at the Masters. My hope is that more course designers will want to use it, along with actual pin sheets, to plant the pins we see Thursday thru Sunday at other Majors. The hardest part (on my part) is the "scanning in" of all 18 greens of a particular course - takes about 15 min. for each green.
John
Re: Hole Viewer utility spreadsheet
Posted: Wed Jun 26, 2019 5:49 pm
by OnyxCarp
Being spoiled with working with hi-res pointclouds I am very impressed how you managed to derive meaningful information out of the meagre geodata and made it very accessible. Indeed, if course designers would be willing to include some extra green 3d points into the .description file (may be too much clutter for the game setup) that would heighten the resolution. Or - some kind of ETL that simply filters out georefdata from the unity package. Could be that the opendata course designer environment already has this functionality - haven't even thought about that... Anyways, intriguing work!