If you have the 3D CAD, just produce a 2D drawing from that and dimension the holes as needed. I would suggest X and Y from the middle.

As Fusion is the offspring of AutoCAD, ACAD has a ‘list’ command, that you could select entities and it would write their properties into the text window.

Put a point entity at the centre of each hole, select all of them and ‘list’ to the console.

A variation on this is to save just the point entities into an ASCII dxf file and open that in a text editor to extract the information.

The utility of the textual information might be dependent on the order in which you create the points. they would list in creation order, so create them systematically and they will list systematically.

If you tell us PCD, first hole bearing from due north and angular increment, we could do the maths independently as a check on your own work.

The easiest way to obtain these in a spreadsheet is to use polar coordinates. x = r cos(theta) and y = r sin(theta). The angle is measured anticlockwise from the horizontal positive x-axis (mathematical and navigational angles are measured in different directions). For the Ox one, with two hole circles, the outer thetas would be 0, 2/127 * 360, 4/127 *360, 6/127 * 360 etc. The first hole on that outer circle would be at three o’clock. For the first hole on the inner circle, start at 1/127 * 360 and then 3/127 * 360, 5/127 * 360 etc.

I do not know if this might help with displaying the results, but you can use the MOD() (remainder from division) function to show or hide stuff automagically.

On the first one, if you do MOD(hole_number, 2) you see 0 or 1 depending on if the number is odd or even. So if you multiply the cell result by this, it either gives what you want or shows zero. To do the ‘opposite hand’ of this, use MOD(hole_number-1, 2) to flip the correspondence of 0 and 1 with odd and even.

You can combine or substitute this with an IF statement to show a completely blank cell instead of a zero:

IF(MOD(hole_number, 2), <formula to display value>, “”)

This logic can be extended to accommodate the ‘show one in five’ option – IF(MOD(hole_number, 5), etc.) would get you all non-multiples of five – IF(NOT(MOD(hole_number, 5), etc.) should get all exact multiples of five.