Calculating Timing Delay Constants & Timeouts

Hello everyone,

I’m stuck with the constants “magic numbers” in the API examples 05a and 05b when I want to use the two way ranging example for different frequencies, preamble lengths and so on.

#define POLL_TX_TO_RESP_RX_DLY_UUS 300
#define RESP_RX_TO_FINAL_TX_DLY_UUS 3100
#define RESP_RX_TIMEOUT_UUS 2700
#define POLL_RX_TO_RESP_TX_DLY_UUS 2750
#define RESP_TX_TO_FINAL_RX_DLY_UUS 500
#define FINAL_RX_TIMEOUT_UUS 3300

Apparently in the past there has been a 2WR calculator spreadsheet that appears to be offline. Could anyone please post the XLSX or demystify on how these numbers are calculated?

Thank you a lot in advance.

Link to my archived copy of the old excel sheet: