Thanks for taking the time to look at my file and for writing a comprehensive reply. I have books by Sapherson, Schorr, Condray and others giving me ORBATs and unit strengths for most participants but I don't pretend any depth of knowledge on the WSS so I am grateful for the advice of my fellow gamers and people with an interest in the period.
Somehow or other I have to come up with a ground scale and basing widths for units. What I'm doing now is like someone trying to figure out a Chinese puzzle by initially trying the pieces in various combinations to get a feeling for the puzzle. My approach wil change as I learn more.
I've put together models for Computational Neuroscience in the past which is considered a black art. You put together a model of part of the brain and come up with some sort of result. How it relates to actual brain activity is totally up for grabs. So I'm not expecting too much from my Excel sheet
I'm starting by saying that I will aim to have a standard French Battalion made up of three one inch stands and make everything else relative to that. It could be that I'll add/remove bases to represent units of different sizes. This is just my starting point.
Now on to my most obvious problems which you pointed out in your post
1. My unit strengths were off. Now I'll correct this and make them more reasonable in my excel sheet.
2. You pointed out that infantry took up more space (about double).
3. I will have to take account of gaps between units and the presence of artillery support (but I won't base including the gaps)
4. I haven't factored in the ranks for French and other correctly
From my limited understanding I'd guess that the Cavalry of different nations would take up different widths based upon their charging doctrine. Those charging knee to knee may have taken perhaps 43 inches and perhaps double that for those with other doctrines? I'm probably on controversial ground here!
Cheers
Neil