You might also find the Python library pandas useful. Its “DataFrames” can mirror your excel data 1:1 and you have convenience methods like to_excel(). Easy to combine with numpy for performant matrix math.
XLSX just becomes a container for storing/sharing your data, and while Python is used for analysis. I would use matplotlib for plotting rather than embedding in the sheet.
Seems over-complicated…
I could imagine an autonomous, on-demand rural train service. Due to the low expected traffic, it seems like you could just build some additional sidings and use a more conventional design.