I am looking to understand more about how to translate rf parameters to an estimated range, for radios operating in the subGHz ISM band (such as the CC1314R10). I found a nice tool at the URL below that provides this information, but I am hoping to understand more about the underlying calculations. The majority of the form is behind locked cells, so I cannot directly view or edit the content. I am wondering if the sheet lock/unlock password is available such that I can deconstruct and tweak the calculator.
Link to tool: