Thanks Ed. I assume from this it must be your spreadsheet.Thanks for clarifying the conversion to sq M. I am piggy in the middle here, I haven't seen the spreadsheet, just have the data in the question to go on.
I assume it is the emf formula that you want me to elaborate on.
Total flux per pole (phi) is B x A. B is flux density in Tesla and area is square Meters if we use SI units.
In each rotation each conductor cuts (phi) lines of flux and p is the number of poles.
Each turn has 2 active sides so the average emf is 2(phi)Pn where n is in revs/sec.
I prefer to work in frequency and f=pn/2
That gives the average emf as 4(phi)f volts per turn
The average volts per phase is 4(phi)f x N where N is the total number of turns per phase.
These type machines give a close approximation to a sine wave and we are justified to use the sine wave form factor of 1.1
That gives the rms volts per phase as 4.4(phi)fN.
For star connection the line volts ( between a pair of terminals) will be root3 times this. When used with a 3 phase rectifier charging a battery the dc will be almost the peak value of the rms.
Near enough, the dc voltage will be 4.4(phi)fN x 1.7 x 1.4
I find that this works out fairly closely with these air gap alternators. It works for slotted iron cores but you need to take various distribution factors into account depending on the winding.
Although slightly different, the same emf equation still works with the transformer. That is why I prefer to work in frequency then one formula does the lot.
Flux