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:
Hole_Viewer.JPG
[/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 :good:

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.
Hole Viewer 2.JPG
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.
Hole Viewer2.xlsm
(9.18 MiB) Downloaded 331 times

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!