As said already best to learn how to use the spreadsheets.
For a new general you basically need a model a unit and an event to introduce him.
I tend to copy an existing line on model/unit spreadsheet and then alter to suit, similarly with events.
In the attached I have used Marmaduke as the basis for a new general JO Shelby ( see newgeneral xls) making a new model, unit and leader event. I've also made a new string for the local strings.
After adding these to the base spreadsheets (after the "reserved" for unit and model) in with similar entries for leader event and local string, I saved as a .csv and then used the splitter to make the necessary files.
I find it easier to make a folder for models and units and point the splitter to them, remember to copy out the alias files for the aliases folder.
I hope you can add your ancestor to the game, it would be a link that few of us could claim. Then all we would need is an Appomattox scenario.