Attached is a new copy of the spreadsheet with added comments and formatting.
The green cells are all the required inputs. The cell to the left of each input has a comment, which is displayed when you place the cursor on that cell and describes the input. For example, for my engine, the master rod Center of Gravity is input as 12.726/177, because its CoG is located 12.726mm from the crankpin axis and the centre to centre length of the master rod is 177mm. This gives the cell value 0.07 (displayed to 2 decimal places).
The object is to minimise the value in the Balance Error cell (orange).
How does it work? - The spreadsheet calculates the location of CoG of each of the moving parts at intervals of 5 degrees of crankshaft rotation, through a full 360 degree rotation.
Next, each of those locations are multiplied by the part mass to give the moment of that part about the crankshaft axis. These moments are then added up to give the total moment of the moving parts at each crank angle interval.
The total moments are then compared to the counterweight moment at that crank angle to give the balance error. The figure displayed in the Balance Error cell is the maximum of all those balance error values.
In my engine, the Balance Error is 15218gmm, the equivalent of a 15.218kg mass orbiting at 1mm radius. This seems large, but in a 120kg engine, it is tiny, generating a free vibration amplitude of just over 0.1mm (15.218/120).