I never cared for the layout or errors of Army creator and have used this Excel sheet Its based on the 5th Edition roster layout and has been well received in groups I have played in.

To fill out:
1. All fields to the left of "Points" are text fields to be filled out/formatted to your satisfaciton.

2. "Points" is a calculated field. Typing anything in this column will cause the sheet not to work.

3. To the right of "Points" are the unit information fields.
For Heroes:
a) Model Points are the base points of the model
b) Equipment is for non-magical equipment (Lances, Heavy Armor, etc)
c) Magic Items is for any Magic equipment (split out for percentages at the bottom of the sheet)

For Other Units:
a) Number is the number of models in the unit
b) Base Cost are the base points of the model
c) Model Up is the point cost of model upgrades for each model (ie: shields or improved armor
d) Unit Up is for unit upgrades (Banners, Marks, etc)
e) Magic Items is for any Magic equipment (split out for percentages at the bottom of the sheet)

The first tab is an example of a small army. The second is a blank roster to be copied at your leisure.