I've never seen such a spread sheet, and I imagine most players after a few games will not be missing one either.
First off, each 'piece' on the map, or in a stack on the map, is a Unit, often a brigade if it's a land unit. Some units contain > 1 sub-units, or elements. Each element can, and often will, have completely different characteristics from the other elements in the unit. For example, one might be an infantry regiment and the other a light artillery battery, etc., etc.
The types of units, ie their composition, is limited, simply because that's the way the game was made. So after going to the build menu to pick units to purchase a couple of dozen times, a spread sheet will only be getting in the way, because all of this will be in your head.
I nearly always build division using a specific TOE, and using units which can be produced in the theater. So I know I need one of these, three of that one, 2 of this one, and one of that one. If one unit-type runs out, which it will, I just change the recipe a little to fit the units available.
Create a TOE for your division, because that's practically all you will be doing, is building divisions and corps. Look at the largest units you can build nearby first, and then look for the units you will need to fit in with that to create your TOE. Stick with that recipe for as long as all of those unit-types are available, and then adjust your recipe accordingly.
That's about it. Feel free to ask if you have any questions.