I need an application to perform quite a simple task.
(A) Must work under Windows XP and over and on Windows server 2003 and over
(B) Need an open source database
(C) Must have a code to be installed on a computer
(1) The application will permit to create an unlimited number of set of items.(estimed between 30 and 40 sets)
(2) Every and each item will have a code (letters and/or numbers) and will have a numeric value (estimed between 400 and 500 items)
(3) Every set created will have a numeric value
(4) Equivalence must be permitted ( UREA = UREE or POT = K or NA = SOD …)
A user will pick a non specific number of item in the list of (2) and the application will try to match the closest set
and compare the value of the sum of each item and the value of the set. It will provide the lowest value.
Let’s have an example:
(1)
GH50 = FSC + E + CREA + AMY + LIP + CHO
LIPI = CHO + TG
(2)
DEA75 = 25
FSC = 35
E = 40
U = 50
OT = 32
AT = 32
CREA = 30
AMY = 32
LIP = 32
UR = 32
CHO = 45
TG = 32
CK = 32
(3)
GH50 = 140
LIPI = 70
So, let’s select items FSC, CREA, AMY, CHO
The value would be 35 + 30 + 32 + 45 = 142
The items are found in the set GH50 and the value is 140.
The application will give the results and underline the lowest value
GH50 = FSC + E + CREA + AMY + LIP + CHO = 140
FSC + CREA + AMY+ CHO = 142
The result must be printed out