If you want to create the HexViz like this,
you won't use the actually latitude and longitude.
I downloaded the above workbook and checked how the HexViz goes on,
then the setting was like below...
So this viz is not used the actual lat and long, but just simplified location for each state as simple numbers.
Alternatively, if you want to create the HexViz from the actual lat and long like this,
your calculation is almost correct like...
To make the above, I didn't change any calculation. I just put the calculation on the map.
Thanks you for your help!
Thanks for kindly help.