I keep my data in a spreadsheet as well, but if you run a business supporting this, or have many devices in your house, I can see a use for this, and you can't beat the price.
It also seems like a good start on a control GUI.
But as I understand it, I would need to manually rekey all the data in. Or do I misunderstand?
Having to manually key in 70+ addresses and names even once (eg for Homeseer) is tedious. It is part of the/my disapointment in INSTEON that auto-discovery techniques have been so slow in becoming reliable. And having to manually re-enter data all over again using a tiny touchscreen keypad is beyond what I am willing to do if the interface doesn't actually communicate with the system (at this time).
("Machines should work; people should think" ;-)
Here's a jpg of the page in my HA spreadsheet used to manage INSTEON:
www.ECOntrol.org/INSTEON_SS_MFHult_1.jpg
Column 1 has the Group assignment
Column 2 has the assigned device name which in many cases are also hyperlinks to photos on file of the installed switches and(or) associated wiring. This is especially useful in keeping track of what is whom in multiswitch, multiway switch boxes.
Column 3 describes the particular hardware used with a hyperlink to the INSTEON documentation for that device. This is very handy in (eg) refreshing your memory on how to manually un/program devices.
Column 4 is the INSTEON address xx:yy:zz ( Details removed in this picture for security reasons. )
Columns 5 and 6 show the Rev/version number reported by query and as physically labelled. This is _very_ helpful in keeping track of issues/returns/bad micros/ etc
Column 7 is a general purpose remarks section.
Color coded (blue yellow, etc) fill in the individual cells is used to annotate and define status. Explanation is at the bottom of the page along with additional notes and ToDo's.
Note that this version of the spread sheet doesn't show links between devices. This is still on my ToDo list
It is unfortunate in my opinion that one has to resort to such detailed bookkeeping on INSTEON installations, but my experience is that if you don't take the time initially, you will spend even more time down the road ...
HTH ... Marc
