I'm trying to create an Excel spreadsheet that takes a 3D bolt group with x y and z coordinates, applied loading, and determines the distribution of forces into each bolt based on weighting by the distances from the centroid and bolt diameter. By "3D bolt group" I mean a pattern of bolts existing in 3 dimensions, not just in 2. I know this complicates the calculation because now there are 3 dimensions to consider. And I've seen quite a few spreadsheets that only take into account a 2D bolt group.
I found the following program (http://www.chestnutpens.co.uk/misc/boltgroup.html) that does exactly what I'm trying to do, but I'm having trouble replicating the results in my spreadsheet. I'm able to replicate almost the entire program, up until the last step that adds the forces due to direct loading and rotation. And I'm not sure why I'm getting the results I'm getting. Note: I've created in FEM the bolt group and matched the results of the program.
Has anyone ever tried to create something like this, or can help me understand where I'm going wrong? I know its a complicated method and its difficult to understand without seeing my spreadsheet. Actually, am I able to share my spreadsheet here? I'm not entire sure on all the rules here.