I’ve adjusted this nice sheet a bit, to split application payload and LoRaWAN headers, to show the results of all spread factors, and to include the maximum number of messages to adhere to the TTN Fair Access Policy.
Good to see how the number of symbols decreases when the connection quality drops (assuming that is correct…), and how it only partly depends on the application payload. And scary how on low data rates the TTN Fair Access Policy is really limiting.
@matthijs, if you like these changes then maybe copy them into your sheet, to keep the existing URL? I can then delete this very post.
See https://docs.google.com/spreadsheets/d/1QvcKsGeTTPpr9icj4XkKXq4r2zTc2j0gsHLrnplzM3I/edit?usp=sharing