If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

TypeScript, VBA, and the Graham Scan

Thread starter Worf
Start date Mar 9, 2024

Overview Discussion

Worf

Well-known Member

Mar 9, 2024

Worf submitted a new Excel article:

TypeScript, VBA, and the Graham Scan - This article shows a method to determine the convex hull for a set of points.

Typescript is the language of Excel scripts, available at certain Office 365 licenses. Unfortunately, my company chose to disable this feature, so at this time I cannot use it.
However, we can write TS outside of Excel. This article shows how to output TS data to a text file that Excel can read.
The code finds the convex hull for a bidimensional set of points; read more about the Graham algorithm in the link below.
Here are the main features of this project:

The points can be code...