I built a spreadsheet of the 54 closest stars (including known brown dwarves) off Wikipedia's page and then added 14 additional near systems with known exoplanets within 31 LY.
I did some Excel magic to convert the right ascension, declination, and distance to X, Y, Z coordinates with Sol at 0,0,0.
I turned that into a matrix that shows the distance from each of those stars to each other, in parsecs.
I applied highlighting rules to call out the stars that were within 1 parsec of another star. With some COUNTIF rules, I was able to make a column for each star to show how many stars it could reach within 1.0, 1.5, 1.7, 1.9, 2.0, and 3.0 parsecs.
Of the 66 stars on my chart (including Sol), there are 2145 pairs of stars.
I can calculate how many (what %) of stars have a pair within a given distance. Furthermore, I can count how many stars are entirely unreachable.
12 pairs (0.56%) are within 1 parsec of one another. 55 (83%) are unreachable.
32 (1.5%) are within 1.5 pc. 40 (61%) are unreachable.
46 (2.1%) are within 1.7 pc. 35 (53%) are unreachable.
52 (2.4%) are within 1.8 pc. 33 (50%) are unreachable.
141 (6.6%) are within 2.0 pc. 0 (0%) are unreachable.
It's like our galactic neighborhood was built for jump-2.
I did some Excel magic to convert the right ascension, declination, and distance to X, Y, Z coordinates with Sol at 0,0,0.
I turned that into a matrix that shows the distance from each of those stars to each other, in parsecs.
I applied highlighting rules to call out the stars that were within 1 parsec of another star. With some COUNTIF rules, I was able to make a column for each star to show how many stars it could reach within 1.0, 1.5, 1.7, 1.9, 2.0, and 3.0 parsecs.
Of the 66 stars on my chart (including Sol), there are 2145 pairs of stars.
I can calculate how many (what %) of stars have a pair within a given distance. Furthermore, I can count how many stars are entirely unreachable.
12 pairs (0.56%) are within 1 parsec of one another. 55 (83%) are unreachable.
32 (1.5%) are within 1.5 pc. 40 (61%) are unreachable.
46 (2.1%) are within 1.7 pc. 35 (53%) are unreachable.
52 (2.4%) are within 1.8 pc. 33 (50%) are unreachable.
141 (6.6%) are within 2.0 pc. 0 (0%) are unreachable.
It's like our galactic neighborhood was built for jump-2.