We need a VBA Program that runs in EXCEL to generate EEPROM contents.
This memory (EEPROM) will be used for sensor configuration. The EEPROM will contain the sensor properties and calibration data as an „electronic data sheet“.
For automized generation of this EEPROM contents a VBA Program that runs in EXCEL is needed. The memory contents is written in a mnemonic style in a EXCEL table. A sample of such a EXCEL sheet is attached.
The task that has to be done is to write this particular VBA Program. The program is mainly calculating the HEX values from other data types, calculating the adresses and is generating the textfile and binary file.
The needed VBA Program is a kind of compiler that needs four runs over the sourcecode (=EXCEL Table) to generate all informations and at least the output file (=HEX file). After the four runs - which will be Interpreting, Determining, Calculating and Generating - the result should be a complete buffer with all the data, ready for output. All values are stored as little endian - first byte is the LSB.
The ideal workflow is, for a new sensor configuration, to create a new spreadsheet in an Excel document (perhaps starting from a template), fill-out all the values needed from the user (not calculatable values), and „compile“ this spreadsheet to generate a text file / binary file.
Detailled documentation is attached below. It includes a project description, a sample excel sheet and the EEPROM module's build up.