Hi,
I have created and use a spreadsheet that has a massive table of data. When I input 2 values into separate input cells in the spreadsheet, the spreadsheet cross references the 2 values and generates the correct data. This is not possible with a formula. Basically, a temperature value is entered and a sensor reading is entered and a corrected sensor output is given.
I have since made a digital version of the sensor with an esp32, this gives me the current sensor value from the sensor ( lets say voltage, but this is not important what the sensor is) and a temperature sensor.
What options is there to then have these 2 values sent into the spreadsheet and the result sent back to the esp32 to display the corrected value?
Is it possible to have the spreadsheet converted to a form and this form in the code through Arduino ide? or some other way to have the spreadsheet data on the esp32 to be referenced against?
It would need to be run locally on the esp32 and to be displayed on a tft display, not over Wifi or internet as the value would need to be updated every 5s and instanly.
Any help would be much appreciated.
Sorry if I have broken any posting rules.