Auto-translated
I took a close look at PhysMiG – it's clear that someone has already done this. The city descriptions state: on page 46, "Castle has the most powerful attack among upgraded units"; on page 55, "Tower has an average attack value, but when attacking a target with 10 defense, it is second only to Castle" – but this is all just words and relative comparisons; the actual attack values are not given anywhere! That's a shame. :(
Page 30 in Excel is quite convenient for inserting a formula to calculate the peasant damage and peasant hit points of each unit, based on the calculations from page 21, and then multiplying by the growth rate from the dwelling, and summing it up for the city... But I don't have time for that right now.