Sunday Tables

I keep track of unit positions, losses, men in hospital, quality, etc. on spreadsheets. In the B & O WINTER command simulation, Sundays will be the most complicated days (in-game), because I will track weekly movement into, out of, and between field and district hospitals. The draft spreadsheets look like this, but are likely to include minor changes. Each row will be for an individual unit.

This is the beginning part of the table for the day, and it marks an opening position with the last town and unit passed through and how many miles. It also has morale and some other information related to the day's march. 

This part of the table tracks movement into and out of field hospitals. When a soldier is wounded or becomes ill, his first stop is to the regimental field hospital and the care of the regimental surgeon and hospital steward. This table adjusts those in the hospital the previous Sunday and wounded through the week with those who have left the hospital in one way or another and those that entered with an illness during the week. It gives the number of men in the field hospital on Sunday morning. 

Men can be transferred from a field hospital to a District Hospital, directly overseen by the Chief Medical Officer. This has slightly better care. Men only enter on transfer from a field hospital and regimental surgeon. In this case, the hospital was started on January 1st and there were no men to be discharged on January 5th. The hospital will start showing discharges, returned convalescents and deaths on the following Sunday. 

This section of the table concludes the data for the Sunday. It takes into account combat losses during the day and the regimental strength at the end of the day, as well as the total in the hospital system at the end of the day (inclusive of those wounded during the day).