In Progress

EEPROM Compiler - VBA Program running in EXCEL

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.

Skills: Excel, Visual Basic

See more: eeprom compiler, eeprom vba, excel eeprom, vba eeprom, excel eeprom configuration, eeprom excel, write compiler excel vba binary, excel compiler, compiler written excel, visual workflow, vba with, starting with visual basic, c program template, binary to text, 55 in binary, vba binary file, vba for, in vba, vba, vba excel, interpreting, fill in excel, fill excel sheet, excel to vba, excel table

About the Employer:
( 3 reviews ) Löffingen, Germany

Project ID: #1263390