Folks,

Much obliged if anyone can give me some pointers - as I am a rank amateur with what I am trying to do.

My local solar system has 15 minute interval consolidated data coming from the local Envoy-S metered device that controls the micro inverters on the back of each of my 31 solar cells on our house.

If one queries the unit by calling:

http://192.168.0.12/...ction/inverters

then it returns some important information including: each inverters serial number, last reported output in Watts and Maximum every achieved output in watts:

[ { "serialNumber": "121440006252", "lastReportDate": 1484971459, "devType": 1, "lastReportWatts": 172, "maxReportWatts": 255 }, { "serialNumber": "121440009848", "lastReportDate": 1484971423, "devType": 1, "lastReportWatts": 220, "maxReportWatts": 251 }, { "serialNumber": "121440009469", "lastReportDate": 1484971461, "devType": 1, "lastReportWatts": 216, "maxReportWatts": 250 }, { "serialNumber": "121440006298", "lastReportDate": 1484971424, "devType": 1, "lastReportWatts": 222, "maxReportWatts": 254 }, { "serialNumber": "121440000591", "lastReportDate": 1484971428, "devType": 1, "lastReportWatts": 220, "maxReportWatts": 250 }, { "serialNumber": "121440006299", "lastReportDate": 1484971427, "devType": 1, "lastReportWatts": 217, "maxReportWatts": 251 }, { "serialNumber": "121440009439", "lastReportDate": 1484971435, "devType": 1, "lastReportWatts": 222, "maxReportWatts": 254 }, { "serialNumber": "121621032153", "lastReportDate": 1484971438, "devType": 1, "lastReportWatts": 161, "maxReportWatts": 265 }, { "serialNumber": "121621032758", "lastReportDate": 1484971447, "devType": 1, "lastReportWatts": 161, "maxReportWatts": 265 }, { "serialNumber": "121621031898", "lastReportDate": 1484971448, "devType": 1, "lastReportWatts": 238, "maxReportWatts": 268 }, { "serialNumber": "121621032709", "lastReportDate": 1484971453, "devType": 1, "lastReportWatts": 235, "maxReportWatts": 267 }, { "serialNumber": "121621032560", "lastReportDate": 1484971441, "devType": 1, "lastReportWatts": 160, "maxReportWatts": 263 }, { "serialNumber": "121440005870", "lastReportDate": 1484971427, "devType": 1, "lastReportWatts": 177, "maxReportWatts": 255 }, { "serialNumber": "121621032935", "lastReportDate": 1484971455, "devType": 1, "lastReportWatts": 236, "maxReportWatts": 267 }, { "serialNumber": "121621032703", "lastReportDate": 1484971448, "devType": 1, "lastReportWatts": 237, "maxReportWatts": 265 }, { "serialNumber": "121621032713", "lastReportDate": 1484971452, "devType": 1, "lastReportWatts": 237, "maxReportWatts": 268 }, { "serialNumber": "121621032469", "lastReportDate": 1484971450, "devType": 1, "lastReportWatts": 236, "maxReportWatts": 267 }, { "serialNumber": "121440005872", "lastReportDate": 1484971457, "devType": 1, "lastReportWatts": 174, "maxReportWatts": 255 }, { "serialNumber": "121440003726", "lastReportDate": 1484971462, "devType": 1, "lastReportWatts": 172, "maxReportWatts": 255 }, { "serialNumber": "121440010087", "lastReportDate": 1484971424, "devType": 1, "lastReportWatts": 168, "maxReportWatts": 254 }, { "serialNumber": "121440006244", "lastReportDate": 1484971433, "devType": 1, "lastReportWatts": 175, "maxReportWatts": 248 }, { "serialNumber": "121440010065", "lastReportDate": 1484971431, "devType": 1, "lastReportWatts": 216, "maxReportWatts": 252 }, { "serialNumber": "121440005652", "lastReportDate": 1484971435, "devType": 1, "lastReportWatts": 217, "maxReportWatts": 250 }, { "serialNumber": "121621032648", "lastReportDate": 1484971444, "devType": 1, "lastReportWatts": 157, "maxReportWatts": 262 }, { "serialNumber": "121621032643", "lastReportDate": 1484971443, "devType": 1, "lastReportWatts": 159, "maxReportWatts": 264 }, { "serialNumber": "121621032476", "lastReportDate": 1484971438, "devType": 1, "lastReportWatts": 159, "maxReportWatts": 264 }, { "serialNumber": "121440000313", "lastReportDate": 1484971437, "devType": 1, "lastReportWatts": 217, "maxReportWatts": 253 }, { "serialNumber": "121440006254", "lastReportDate": 1484971430, "devType": 1, "lastReportWatts": 221, "maxReportWatts": 253 }, { "serialNumber": "121440010058", "lastReportDate": 1484971459, "devType": 1, "lastReportWatts": 173, "maxReportWatts": 251 }, { "serialNumber": "121440009443", "lastReportDate": 1484971421, "devType": 1, "lastReportWatts": 223, "maxReportWatts": 253 }, { "serialNumber": "121440006266", "lastReportDate": 1484971432, "devType": 1, "lastReportWatts": 221, "maxReportWatts": 253 } ]

What is the simplest way to achieve a spreadsheet or local webpage that if I go to it will exectue this call and graphically display a bar / number of how much power each solar cell is producing?

Many thanks,

Matthew