Hi Chemlak I'm looking over the Ultimate Rulership 5.7a sheet.
I believe there are some errors on the Trade Routes sheet.
Trade Routes sheet, Column Z (hidden), appears to exist to check if Consumption is less than 0. But it is only checking to see if the consumption value listed on the Kingdom sheet (D14) is less than the number of Hexes (D2 on Kingdom sheet) + number of districts (E27 no hidden sheet City Overview).
This is erroneous since D14 is only counting consumption from Terrain Improvements and ignores the hexes themselves which each add 1 Consumption.
Wouldn't it just make more sense to check the actual Consumption value (P50) from the Overall sheet?
Trade Routes sheet, Column AA, this appears to check if a Granary or Stockyard is present in the settlement, but with the specified VLOOKUP array - column values 11 and 12 refer to Lore and Society. It should be 13 and 14 for Granaries and Stockyards.
That being said, City Overview sheet, columns N and O. These are looking at the wrong cells on the City sheets. For example Granary is cell M22 and Stockyard is cell U40.
(I didn't check all of the rest, but some of the other cell references looked OK)
(Likewise from #2) Columns AE, AI, and AM on the Trade Routes sheet. These are looking at the wrong column values from the array specified by VLOOKUP on the City Overview sheet.
On the Trade Routes sheet under column W ("Route Allowed?") there is a part at the end of the nested IF statements that checks the number of Quarries and Sawmills on the Kingdom sheet:
Wh at is the purpose of this as it pertains to checking if the route is allowed?
BTW, it looks like some of the erroneous values might just have gotten copied over from the Ultimate Campaign sheet.