Ah ok, glad it wasn't just me being a plum. It's understandable about Endowments, they seem fiddly on paper let alone in excel.
I found after converting over from Ultimate Campaign that our Fame was considerably lower and played with the calculation to find out why. I think I spotted it, but I can't tell if that was our incorrect formula. Currently the total fame modifier for a kingdom doesn't include the base 1 + 1 per kingdom size (11, 26, 51, 101, and 201 hexes) so I've just added it in as a modifier. In theory that's a simple If statement though based on Hex number.
Ok so (sorry I did a bit of fiddling to work stuff through) I think there is a cell reference that's pointing at the wrong cell. After working through the fame calculation, it seems to be doing (Law + Society)/10 instead of (Lore + Society)/10 in cell F16 on the OVERALL sheet (I might be wrong!). If I'm right it should be referencing cell J27 instead of I27 on the CITY OVERVIEW sheet. I truly hope this helps and isn't just me stepping on your feet.