I am thinking about packet collision. Everything I found so far about this is highly academical (I have no objection to this). Still, some numbers would be pretty interesting. I am totally aware that a perfect calculation is highliy complex (in reality, the 8 channels available are not used evenly, is it a full duplex gateway or not? If no, how many downlinks per uplink will the gateway send?), but having some rough numbers would be nice to get a feeling. Maybe someone even coded a calculator?
What I am looking for is something like:
Assumption1: Indoor Monitoring of a big building using 500 sensors. 50% send on SF7, 25% on SF8 and 25% on SF9. Each sensor sends each 10 minutes. The payload length is 15 Bytes. Question: How many packets (0.01%, 0.1%, 1%, 10%) will get lost due to collision?
Calculating the airtime for an uplink is easy, but calculating the probability that 2 packets will be sent simultaneously seems the complex part - but is it really that complex or a rather simple formula?
What are your experiences regading this very theoretical topic?
Thanks & best regards