If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Excel experts, need help
"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 |
#3
|
|||
|
|||
Excel experts, need help
"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 |
#4
|
|||
|
|||
Excel experts, need help
"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 |
#5
|
|||
|
|||
Excel experts, need help
"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 |
#6
|
|||
|
|||
Excel experts, need help
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 |
#7
|
|||
|
|||
Excel experts, need help
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 |
#8
|
|||
|
|||
Excel experts, need help
"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 |
#9
|
|||
|
|||
Excel experts, need help
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 |
#10
|
|||
|
|||
Excel experts, need help
"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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Spreadsheet For Tracking Your Weight Loss | Dean S. Lautermilch©²ºº³ | General Discussion | 0 | April 18th, 2004 12:25 AM |
Excel Spreadsheet For Tracking Weight Loss | Dean S. Lautermilch©²ºº³ | General Discussion | 0 | April 2nd, 2004 09:41 PM |
Excel Weight Chart.. Anyone made one before? | Dan B | General Discussion | 3 | October 2nd, 2003 03:46 PM |