If this procedure is redone after the 2000 Census, USDA should use the base datasource as done with the Ag. WBNAagegender.xls, Hispanic.xls, and AOHagegender.xls. For some unknown reason, the dbf files did not load directly into Access. These total columns were then put into Clients.xls, sheet POPraceGender for total county population by race and gender. See the printouts for the totals.
Most counties have an exact match by category to total population.
The largest rounding error is LA County, with an extra 500 people out of 9 million. Then the percent Male was calculated for each category in AdjRaceSex. The spreadsheet OwnerOccupied.xls has Owner Occupied by Race, and Hispanic Owner Occupied by Race. Others were added to Whites. These Adjusted Owner-Occupied columns were copied to the worksheet OwnerOccupied in Clients.xls.