Genuine protip: Use a database. Look for MS Access alternatives; having table references and "proper" referencing will come in handy way faster than you'd think.
That said, prepared statements/queries (like, "Will I have more BTC in x at tredectory y?") are basically prepared questions :)
Calc/Excel reaches it's limits fast once you start working across multiple named zones and cross-references...
Been there, done that. x)