I do so love it when Excel is used for electonics purposes. However in your case I see it was only a tool to support your insight.
I hope you don't mind if I subvert the thread and point your readers to my blogs on the use of Excel in electronics on Planet Analog. There are at least 4 more to come over the next 6 months. One is due out any day now.
What are the engineering and design challenges in creating successful IoT devices? These devices are usually small, resource-constrained electronics designed to sense, collect, send, and/or interpret data. Some of the devices need to be smart enough to act upon data in real time, 24/7. Are the design challenges the same as with embedded systems, but with a little developer- and IT-skills added in? What do engineers need to know? Rick Merritt talks with two experts about the tools and best options for designing IoT devices in 2016. Specifically the guests will discuss sensors, security, and lessons from IoT deployments.