Arduino reading a database based on user input

Projects General Guidance
1

So I am in need of creating a database consisting of 23 different part names and their respective pressure setpoint and time setpoints. For example:

Part 1 20 psi 5 seconds
Part 2 25 psi 3 seconds

Would I use excel? etc?

I will need Arduino to be able to read and access the setpoints for a part number that a user will type in using a keypad.

How would I create such a directory and how could I write a script to have the Arduino read a value based on user input?

Thanks

2

you could easily write the data to the EEPROM thats on the arduino..

3

Will this work even though I am pulling setpoint data from a 'database' and having Arduino apply those setpoints to my application?

The goal is to have:

  1. operator enters part number
  2. arduino recalls setpoints associated with part number entered
  3. arduino applies corresponding oil pressure and oil flow time duration setpoint to system

Arduino would be controlling oil flow and time duration for a pump system.

4

For such a small amount of data, it doesn't really matter where you put it. EEPROM is fine, but you could just as easily put it in RAM or progmem.

How will the operator be able to confirm that the correct tool was selected?

5

The operator accesses the directory of setpoints using a keypad and LCD display. The LCD will show the selected setpoints, and Arduino will apply them to the system when the operator presses a button.