Excel experts, need help

I've heard from the author of carbcheck, my prefered pda program, and
he says he probably won't get around to finishing the usda file for
inclusion in the program anytime soon, and sent me some tools to do it
myself. Alas, alack, I do not have excel which I need to do the job.
I have looked at the sample and compared it to the usda file, so it's
mostly deleting a lot of unused columns and rearranging some things,
except the usda file doesn't have the numbers for serving sizes
smaller than 100 grams (yet lists grams per cup and such). A colum or
two showing smaller serving sizes would help us poor math-deficient
types avoid trying to divide in our heads. A lot of tedious work, I
know. Any takers?

revek


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.530 / Virus Database: 325 - Release Date: 10/22/2003

"revek" wrote in message
...
I've heard from the author of carbcheck, my prefered pda program, and
he says he probably won't get around to finishing the usda file for
inclusion in the program anytime soon, and sent me some tools to do it
myself. Alas, alack, I do not have excel which I need to do the job.
I have looked at the sample and compared it to the usda file, so it's
mostly deleting a lot of unused columns and rearranging some things,
except the usda file doesn't have the numbers for serving sizes
smaller than 100 grams (yet lists grams per cup and such). A colum or
two showing smaller serving sizes would help us poor math-deficient
types avoid trying to divide in our heads. A lot of tedious work, I
know. Any takers?

revek


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.530 / Virus Database: 325 - Release Date: 10/22/2003



If you are on broadband, go to www.openoffice.org and download the program.
It will read and write all MS Office files and it is free. If you have
trouble with it, you can email it to me at http://tinyurl.com/se39 and I'll
have a look at it and see if it is something I have time to do.

Chris

"revek" wrote in news:bnftvu$10ekb5$1@ID-
190183.news.uni-berlin.de:

I've heard from the author of carbcheck, my prefered pda program, and
he says he probably won't get around to finishing the usda file for
inclusion in the program anytime soon, and sent me some tools to do it
myself. Alas, alack, I do not have excel which I need to do the job.
I have looked at the sample and compared it to the usda file, so it's
mostly deleting a lot of unused columns and rearranging some things,
except the usda file doesn't have the numbers for serving sizes
smaller than 100 grams (yet lists grams per cup and such). A colum or
two showing smaller serving sizes would help us poor math-deficient
types avoid trying to divide in our heads. A lot of tedious work, I
know. Any takers?


If you can post the instructions he gave you, I'll take a look at it. I
use OpenOffice, and am pretty good at spreadsheets. I'd also like to have
the USDA database in spreadsheet form.


Chakolate

--

On sadness:
The cure for this ill is not to sit still,
Or to frowst with a book by the fire,
But to take a large hoe and a shovel also,
And to dig till you gently perspire.
--Rudyard Kipling

"Chakolate" wrote in message
.4...
"revek" wrote in news:bnftvu$10ekb5$1@ID-
190183.news.uni-berlin.de:

I've heard from the author of carbcheck, my prefered pda program,
and
he says he probably won't get around to finishing the usda file
for
inclusion in the program anytime soon, and sent me some tools to
do it
myself. Alas, alack, I do not have excel which I need to do the
job.
I have looked at the sample and compared it to the usda file, so
it's
mostly deleting a lot of unused columns and rearranging some
things,
except the usda file doesn't have the numbers for serving sizes
smaller than 100 grams (yet lists grams per cup and such). A
colum or
two showing smaller serving sizes would help us poor
math-deficient
types avoid trying to divide in our heads. A lot of tedious work,
I
know. Any takers?


If you can post the instructions he gave you, I'll take a look at
it. I
use OpenOffice, and am pretty good at spreadsheets. I'd also like
to have
the USDA database in spreadsheet form.

It is a 2.5 meg file. The tools (zipped) are only 64k in comparison,
and the instructions are zipped with the tools. I can send them to
you email, or you can send me a throwaway yahoo id which I can add to
the access list for yahoo breifcase (yahoo is getting greedy and will
only allow yahoo ids to access the page unless you pay for premium
service-- as if. They can't even stop the swen virus from flooding my
account every two hours). Your call.

revek


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.530 / Virus Database: 325 - Release Date: 10/22/2003

"revek" wrote in news:bnhaap$vvdah$1@ID-
190183.news.uni-berlin.de:

It is a 2.5 meg file. The tools (zipped) are only 64k in comparison,
and the instructions are zipped with the tools. I can send them to
you email, or you can send me a throwaway yahoo id which I can add to
the access list for yahoo breifcase (yahoo is getting greedy and will
only allow yahoo ids to access the page unless you pay for premium
service-- as if. They can't even stop the swen virus from flooding my
account every two hours). Your call.


I only need the tools, I already have the database. I'm not sure what the
yahoo id is, but you can e-mail the file to chakolate AT hotmail DOT com.

Thanks!

Chakolate

--

On sadness:
The cure for this ill is not to sit still,
Or to frowst with a book by the fire,
But to take a large hoe and a shovel also,
And to dig till you gently perspire.
--Rudyard Kipling

Chakolate at wrote on 10/26/03 3:04 PM
about :

If you can post the instructions he gave you, I'll take a look at it. I
use OpenOffice, and am pretty good at spreadsheets. I'd also like to have
the USDA database in spreadsheet form.

You can get it here
http://www.nal.usda.gov/fnic/foodcom...SR15/sr15.html

There are a few other neat links there as well


--
Kitty =^..^=
168/161.6/130
Start: September 2003

I'm not an Excel "expert," but for your needs I may do. I'm coming into
this thread with this post. What are you trying to do?


"Qiltkitty" wrote in message
...
Chakolate at wrote on 10/26/03 3:04
PM
about :

If you can post the instructions he gave you, I'll take a look at it. I
use OpenOffice, and am pretty good at spreadsheets. I'd also like to
have
the USDA database in spreadsheet form.

You can get it here
http://www.nal.usda.gov/fnic/foodcom...SR15/sr15.html

There are a few other neat links there as well


--
Kitty =^..^=
168/161.6/130
Start: September 2003

"Gary Rimar" wrote in message
.com...
I'm not an Excel "expert," but for your needs I may do. I'm coming
into
this thread with this post. What are you trying to do?

The author of a pda program I like to use has moved to another
platform and isn't going to finish what he started (grr). It's a
simple carb counter, combining the ADA's carb lists with some fastfood
restaraunts and *was* going to contain the USDA database too -- and
nothing else, no meal plans no calorie watch, no excercise journal.
But it needs to be cleaned up and converted to a format usable by the
program. Adding custom foods doesn't sound difficult (just input into
already created fields), but cleaning up the USDA database looks to be
a headache to me (because all of the commas in the name fields will
screw up the comma separated value file it has to be converted to, for
one), and I've never actually used excel before so I don't know all
the little tricks.

revek




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.530 / Virus Database: 325 - Release Date: 10/23/2003

Qiltkitty wrote in
:

Chakolate at wrote on 10/26/03
3:04 PM about :

If you can post the instructions he gave you, I'll take a look at it.
I use OpenOffice, and am pretty good at spreadsheets. I'd also like
to have the USDA database in spreadsheet form.

You can get it here
http://www.nal.usda.gov/fnic/foodcom...SR15/sr15.html

There are a few other neat links there as well



Thanks, but I already have the USDA database. What I was hoping for was a
spreadsheet form for it. The interface they already have is nice, but
doesn't copy well.

Chakolate

--

On sadness:
The cure for this ill is not to sit still,
Or to frowst with a book by the fire,
But to take a large hoe and a shovel also,
And to dig till you gently perspire.
--Rudyard Kipling

"Chakolate" wrote in message
. 4...
Qiltkitty wrote in
:

Chakolate at wrote on
10/26/03
3:04 PM about :

If you can post the instructions he gave you, I'll take a look at
it.
I use OpenOffice, and am pretty good at spreadsheets. I'd also
like
to have the USDA database in spreadsheet form.

You can get it here
http://www.nal.usda.gov/fnic/foodcom...SR15/sr15.html

There are a few other neat links there as well



Thanks, but I already have the USDA database. What I was hoping for
was a
spreadsheet form for it. The interface they already have is nice,
but
doesn't copy well.

? There is a file for use with excel and other spreadsheets. It's in
the abbreviated section under the download link

revek


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.530 / Virus Database: 325 - Release Date: 10/23/2003