How do i get ioio input signals into excel(any spreadsheet) in realtime and control the outputs with excel?
Spreadsheets are just text
Spreadsheets are just text files with different encoding and extension. Parse it to get info. Read and edit the file, send message to the ioio that something has changed, ioio parses it and execute. Or never just give commands to the ioio and keep track of io ports as a CSV.
Is it easy to do this, my
Is it easy to do this, my speciality is Chemical Engineering, the closest I ever came to coding was batch files in DOS.
By the way what data
By the way what data manipulation you need to do? if you need an easy and graphical programming language you can try Processing.
Data Manipulation
I want to use the logic built into spreadsheets to use the sensor data to control the outputs, here is a full description.
all the ioio inputs to be imported into a spreadsheet like enviroment and readings logged, frequency of logging should be adjustable.
Thus all inputs need own spreadsheet cell dedicated for that input.
All outputs also need to be controlled via the spreadsheet, each ioio output having its own dedicated cell.
1.Colomn A should be for sensor inputs where row no correspond with ioio no
thermo couples,
load cell sensors
temperatures sensors
ultra sonic distance values
ph
conductivity
volt meter
signals from distance meters
flow meters ( thus the app should be able to count signals)
2.column B should be for control for outputs where row no correspond with ioio no
Commands ‘True’ = output of 3.3 volts
Commands ‘false’ = output of 0 volts
Command ‘5’ = output 5 volts (here you can tell me what command or wiring is needed for 5v)
Commands ‘0.x’ (where x is a percentage for Pwm 0.6 = 60% on) = on for x% of time
Of secondary importance
3.There should be a counting clock (for time) in the spreadsheet
4.a setting for frequenzy of data logging wich should also display in a realtime graph in seconds
5.-If possible, if cell A47 is tRUE send an email with text of cell B47 as heading to recipient cell C47
the spreadsheet cells should be excessable while it is runing remotly but hosted on the ioio or android device.
spreadsheet also startup automatically if android device reboots and be the only app accessible. the access to other functions must be password protected
data manipulation
I want to use the logic built into spreadsheets to use the sensor data to control the outputs, here is a full description.
all the ioio inputs to be imported into a spreadsheet like enviroment and readings logged, frequency of logging should be adjustable.
Thus all inputs need own spreadsheet cell dedicated for that input.
All outputs also need to be controlled via the spreadsheet, each ioio output having its own dedicated cell.
1.Colomn A should be for sensor inputs where row no correspond with ioio no
thermo couples,
load cell sensors
temperatures sensors
ultra sonic distance values
ph
conductivity
volt meter
signals from distance meters
flow meters ( thus the app should be able to count signals)
2.column B should be for control for outputs where row no correspond with ioio no
Commands ‘True’ = output of 3.3 volts
Commands ‘false’ = output of 0 volts
Command ‘5’ = output 5 volts (here you can tell me what command or wiring is needed for 5v)
Commands ‘0.x’ (where x is a percentage for Pwm 0.6 = 60% on) = on for x% of time
Of secondary importance
3.There should be a counting clock (for time) in the spreadsheet
4.a setting for frequenzy of data logging wich should also display in a realtime graph in seconds
5.-If possible, if cell A47 is tRUE send an email with text of cell B47 as heading to recipient cell C47
the spreadsheet cells should be excessable while it is runing remotly but hosted on the ioio or android device.
spreadsheet also startup automatically if android device reboots and be the only app accessible. the access to other functions must be password protected