On Sat, 16 Feb 2002 10:38:47 +1100, Richard Archer <[log in to unmask]>
wrote:

>At 9:16 AM -0500 15/2/02, Amadeus Schmidt wrote:
>
>>Roasted beaver? Which database is it? Where can I get it?
>
>This is the USDA database, version SR14.
>
>http://www.nal.usda.gov/fnic/foodcomp/Data/SR14/sr14.html

Thank you Richard.
Meanwhile I have sr14 version.
They have a lot of interesting new features, but alas few additional data.
For example only few items have data for the added sugar types and TFAs.

I have started to convert a few of my queries.
Alas they have renamed some of the Fields, so that you have constantly to
change the names in the reports.
Furtunately I have  entered my new own data in seperate tables which were
easy to add after name changes
(e.g. the text in german, a bit for paleo or not, the RDA).

I've uploaded one query example with a EFA/Prostaglandin example.
I tried to address the following facts:
1.EPA and AA are more rapidly converted to PG's, so I multiplied the
corresponding parameter with 10.
2.To provide for fats with competing MUFA and SFA against EFAs (less than 5%
) I added a factor. For relations with MUFA and SFA > 10% or so, this will
increase the "value" more than necessary.

After all I tried to gain a "EFA activity (meaning positive, omega-3
activity) of all items.

Winner was salmon oil.
http://www.geocities.com/paleolix/PG_weighted.html

Another example the tryptophan to total protein ratio.
Vitamin b3 is interesting because body tends to use TRY from it, if
necessary.
http://www.geocities.com/paleolix/TRY_PROTEIN_RATIO.html

regards,

Amadeus
here are the SQLs (sorry non IT-chinese people):
SELECT FOOD_DES.Desc, [PUFAfactorPG]*[w36weighted]*[Abbrev]![Tot_Lipid] AS
pgactivity, [add_2Abbrev]![w3pg]/[add_2Abbrev]![w6pg] AS w36weighted,
add_2Abbrev.w3pg, add_2Abbrev.w6pg, add_2Abbrev.PUFAfactorPG,
Abbrev.Tot_Lipid, add_2FOOD.detext, add_2Abbrev.LNA, add_2Abbrev.LA,
add_2Abbrev.EPA, add_2FOOD.basic, add_2FOOD.paleo
FROM (Abbrev INNER JOIN add_2Abbrev ON Abbrev.NDB_No = add_2Abbrev.[NDB No])
INNER JOIN (FOOD_DES INNER JOIN add_2FOOD ON FOOD_DES.NDB_No =
add_2FOOD.NDB_No) ON add_2Abbrev.[NDB No] = FOOD_DES.NDB_No
WHERE (((add_2Abbrev.w6pg)>0) AND ((add_2FOOD.paleo)=True))
ORDER BY [add_2Abbrev]![w3pg]/[add_2Abbrev]![w6pg] DESC;

and

SELECT FOOD_DES.Desc, TRY.Value AS Try, B3.Value AS B3,
[TRY]![Value]/[Abbrev]![Protein] AS Ratio,
[Ratio]*2400/[Abbrev]![Energ_Kcal] AS Ratioprokcal, Abbrev.Energ_Kcal,
Abbrev.Protein, add_2FOOD.detext
FROM Abbrev INNER JOIN (B3 INNER JOIN ((FOOD_DES INNER JOIN add_2FOOD ON
FOOD_DES.NDB_No = add_2FOOD.NDB_No) INNER JOIN TRY ON FOOD_DES.NDB_No =
TRY.NDB_No) ON B3.NDB_No = FOOD_DES.NDB_No) ON Abbrev.NDB_No =
FOOD_DES.NDB_No
WHERE (((Abbrev.Energ_Kcal)>0) AND ((Abbrev.Protein)>0) AND
((add_2FOOD.basic)=True))
ORDER BY [TRY]![Value]/[Abbrev]![Protein] DESC;