Guest guest Posted May 25, 2004 Report Share Posted May 25, 2004 Yes. I put it into a spreadsheet, and I can save a version each day of what I ate. Easy to calc. there is no program that does the "real work" anyway. You can download the USDA SR16.5 into MSAccess. By far the best and easiest way. There is a query in that download that allows you to get the whole db in a spreadsheet format. Copy that to an excel file. That will take a while. Then remove the 90% crap you will never need - prepared foods, baby foods, Trim the thousands of diff cuts of meats. You end up with maybe 3-4 megs. Then set up a second sheet where you select servings or grams or ounces in a list which will total to compare against the RDA's. I can't send you mine because it's too large (slow network), but I can tell you how to see a sample if you think you might want to goto the trouble of building one. If you don't have Access, get one - ebay's a good place. No one uses it much so they're cheap. Regards. ----- Original Message ----- From: chris Sent: Tuesday, May 25, 2004 3:07 AM Subject: [ ] PDA's and Computer Programs Since successful CRON is so dependent on careful calorie and nutritioncounting, I was wondering if anyone used their PDA's or computers as an aidin this process. I have a simple computer program that has a large databaseof different foods and their nutritional values. You simply input what youconsume on a given day and it calculates the total nutritional value ofeverything you have eaten. The problem is that it is only intended to usefor a short period of time while you analyze your eating patterns. I'd liketo find something that is similar but more tailored to the long term. Evenbetter if it is a Pocket PC program.Any suggestions?(|-|ri5 Quote Link to comment Share on other sites More sharing options...
Guest guest Posted May 26, 2004 Report Share Posted May 26, 2004 Thanks, that's a good suggestion. Also, in contrast to nutrition software, it is free if you have Access already. I might just try it, but I'm a little fuzzy on how you put your daily tallies together. Could you send me a little sample? thanks, (|-|ri5 -----Original Message-----From: jwwright [mailto:jwwright@...]Sent: Tuesday, May 25, 2004 3:47 PM Subject: Re: [ ] PDA's and Computer Programs Yes. I put it into a spreadsheet, and I can save a version each day of what I ate. Easy to calc. there is no program that does the "real work" anyway. You can download the USDA SR16.5 into MSAccess. By far the best and easiest way. There is a query in that download that allows you to get the whole db in a spreadsheet format. Copy that to an excel file. That will take a while. Then remove the 90% crap you will never need - prepared foods, baby foods, Trim the thousands of diff cuts of meats. You end up with maybe 3-4 megs. Then set up a second sheet where you select servings or grams or ounces in a list which will total to compare against the RDA's. I can't send you mine because it's too large (slow network), but I can tell you how to see a sample if you think you might want to goto the trouble of building one. If you don't have Access, get one - ebay's a good place. No one uses it much so they're cheap. Regards. Quote Link to comment Share on other sites More sharing options...
Guest guest Posted May 26, 2004 Report Share Posted May 26, 2004 I am an Access programmer and Internet programmer, on CRON for 3 years. If desired, I could do the programming to create a database or a web-enabled application for group members to use. Because it would be free I would work on it in between my other jobs, but if there's interest I would be willing to entertain suggestions. Best regards, Lee -----Original Message-----From: chris [mailto:motjuste@...]Sent: Tuesday, May 25, 2004 11:35 PM Subject: RE: [ ] PDA's and Computer Programs Thanks, that's a good suggestion. Also, in contrast to nutrition software, it is free if you have Access already. I might just try it, but I'm a little fuzzy on how you put your daily tallies together. Could you send me a little sample? thanks, (|-|ri5 -----Original Message-----From: jwwright [mailto:jwwright@...]Sent: Tuesday, May 25, 2004 3:47 PM Subject: Re: [ ] PDA's and Computer Programs Yes. I put it into a spreadsheet, and I can save a version each day of what I ate. Easy to calc. there is no program that does the "real work" anyway. You can download the USDA SR16.5 into MSAccess. By far the best and easiest way. There is a query in that download that allows you to get the whole db in a spreadsheet format. Copy that to an excel file. That will take a while. Then remove the 90% crap you will never need - prepared foods, baby foods, Trim the thousands of diff cuts of meats. You end up with maybe 3-4 megs. Then set up a second sheet where you select servings or grams or ounces in a list which will total to compare against the RDA's. I can't send you mine because it's too large (slow network), but I can tell you how to see a sample if you think you might want to goto the trouble of building one. If you don't have Access, get one - ebay's a good place. No one uses it much so they're cheap. Regards. Quote Link to comment Share on other sites More sharing options...
Guest guest Posted May 26, 2004 Report Share Posted May 26, 2004 Lee: thank you so much for your kind and generous offer. Assuming this will be different/better than the free programs listed in our file: " Nutrient Tracking Programs " under " IMPROVING YOUR CRON PROGRAM " , it sounds like an offer we can't refuse. on 5/26/2004 10:04 AM, Lee A. Shurie at lee@... wrote: > I am an Access programmer and Internet programmer, on CRON for 3 years. If > desired, I could do the programming to create a database or a web-enabled > application for group members to use. Because it would be free I would work > on it in between my other jobs, but if there's interest I would be willing > to entertain suggestions. > > Best regards, > Lee Quote Link to comment Share on other sites More sharing options...
Guest guest Posted May 26, 2004 Report Share Posted May 26, 2004 This would certainly be of benefit to me. As A mac user I can not use the more normal programs, and I could buy a PDA if that was what was available. Or if it was web based then I could still use it. Positive Dennis Lee A. Shurie wrote: I am an Access programmer and Internet programmer, on CRON for 3 years. If desired, I could do the programming to create a database or a web-enabled application for group members to use. Because it would be free I would work on it in between my other jobs, but if there's interest I would be willing to entertain suggestions. Best regards, Lee -----Original Message----- From: chris [mailto:motjuste@...] Sent: Tuesday, May 25, 2004 11:35 PM Subject: RE: [ ] PDA's and Computer Programs Thanks, that's a good suggestion. Also, in contrast to nutrition software, it is free if you have Access already. I might just try it, but I'm a little fuzzy on how you put your daily tallies together. Could you send me a little sample? thanks, (|-|ri5 -----Original Message----- From: jwwright [mailto:jwwright@...] Sent: Tuesday, May 25, 2004 3:47 PM Subject: Re: [ ] PDA's and Computer Programs Yes. I put it into a spreadsheet, and I can save a version each day of what I ate. Easy to calc. there is no program that does the "real work" anyway. You can download the USDA SR16.5 into MSAccess. By far the best and easiest way. There is a query in that download that allows you to get the whole db in a spreadsheet format. Copy that to an excel file. That will take a while. Then remove the 90% crap you will never need - prepared foods, baby foods, Trim the thousands of diff cuts of meats. You end up with maybe 3-4 megs. Then set up a second sheet where you select servings or grams or ounces in a list which will total to compare against the RDA's. I can't send you mine because it's too large (slow network), but I can tell you how to see a sample if you think you might want to goto the trouble of building one. If you don't have Access, get one - ebay's a good place. No one uses it much so they're cheap. Regards. Quote Link to comment Share on other sites More sharing options...
Guest guest Posted May 26, 2004 Report Share Posted May 26, 2004 That's an idea. The problem I found is the inet speed. It's possible to use the files section to add a spreadsheet, but I can tell you it can't be large with a slow net. You'd probably end up with something like the USDA appl? See the question is what would it do. Provide the data so folks can compute by hand what they ate? Or like the nutrition programs provide some adding up the components as you enter them? But a spreadsheet, you enter the serving and see the totals and with a comparison to the RDA (and additional feature) indicates the percent RDA ingested. Start by downloading the sr16-1 yourself and do the crosstab query. http://www.nal.usda.gov/fnic/foodcomp/ That will give you the data. Regards. ----- Original Message ----- From: Lee A. Shurie Sent: Wednesday, May 26, 2004 9:04 AM Subject: RE: [ ] PDA's and Computer Programs I am an Access programmer and Internet programmer, on CRON for 3 years. If desired, I could do the programming to create a database or a web-enabled application for group members to use. Because it would be free I would work on it in between my other jobs, but if there's interest I would be willing to entertain suggestions. Best regards, Lee -----Original Message-----From: chris [mailto:motjuste@...]Sent: Tuesday, May 25, 2004 11:35 PM Subject: RE: [ ] PDA's and Computer Programs Thanks, that's a good suggestion. Also, in contrast to nutrition software, it is free if you have Access already. I might just try it, but I'm a little fuzzy on how you put your daily tallies together. Could you send me a little sample? thanks, (|-|ri5 -----Original Message-----From: jwwright [mailto:jwwright@...]Sent: Tuesday, May 25, 2004 3:47 PM Subject: Re: [ ] PDA's and Computer Programs Yes. I put it into a spreadsheet, and I can save a version each day of what I ate. Easy to calc. there is no program that does the "real work" anyway. You can download the USDA SR16.5 into MSAccess. By far the best and easiest way. There is a query in that download that allows you to get the whole db in a spreadsheet format. Copy that to an excel file. That will take a while. Then remove the 90% crap you will never need - prepared foods, baby foods, Trim the thousands of diff cuts of meats. You end up with maybe 3-4 megs. Then set up a second sheet where you select servings or grams or ounces in a list which will total to compare against the RDA's. I can't send you mine because it's too large (slow network), but I can tell you how to see a sample if you think you might want to goto the trouble of building one. If you don't have Access, get one - ebay's a good place. No one uses it much so they're cheap. Regards. Quote Link to comment Share on other sites More sharing options...
Guest guest Posted May 26, 2004 Report Share Posted May 26, 2004 That's an idea. The problem I found is the inet speed. It's possible to use the files section to add a spreadsheet, but I can tell you it can't be large with a slow net. You'd probably end up with something like the USDA appl? See the question is what would it do. Provide the data so folks can compute by hand what they ate? Or like the nutrition programs provide some adding up the components as you enter them? But a spreadsheet, you enter the serving and see the totals and with a comparison to the RDA (and additional feature) indicates the percent RDA ingested. Start by downloading the sr16-1 yourself and do the crosstab query. http://www.nal.usda.gov/fnic/foodcomp/ That will give you the data. Regards. ----- Original Message ----- From: Dennis De Jarnette Sent: Wednesday, May 26, 2004 11:45 AM Subject: Re: [ ] PDA's and Computer Programs This would certainly be of benefit to me. As A mac user I can not use the more normal programs, and I could buy a PDA if that was what was available. Or if it was web based then I could still use it. Positive DennisLee A. Shurie wrote: I am an Access programmer and Internet programmer, on CRON for 3 years. If desired, I could do the programming to create a database or a web-enabled application for group members to use. Because it would be free I would work on it in between my other jobs, but if there's interest I would be willing to entertain suggestions. Best regards, Lee -----Original Message-----From: chris [mailto:motjuste@...]Sent: Tuesday, May 25, 2004 11:35 PM Subject: RE: [ ] PDA's and Computer Programs Thanks, that's a good suggestion. Also, in contrast to nutrition software, it is free if you have Access already. I might just try it, but I'm a little fuzzy on how you put your daily tallies together. Could you send me a little sample? thanks, (|-|ri5 -----Original Message-----From: jwwright [mailto:jwwright@...]Sent: Tuesday, May 25, 2004 3:47 PM Subject: Re: [ ] PDA's and Computer Programs Yes. I put it into a spreadsheet, and I can save a version each day of what I ate. Easy to calc. there is no program that does the "real work" anyway. You can download the USDA SR16.5 into MSAccess. By far the best and easiest way. There is a query in that download that allows you to get the whole db in a spreadsheet format. Copy that to an excel file. That will take a while. Then remove the 90% crap you will never need - prepared foods, baby foods, Trim the thousands of diff cuts of meats. You end up with maybe 3-4 megs. Then set up a second sheet where you select servings or grams or ounces in a list which will total to compare against the RDA's. I can't send you mine because it's too large (slow network), but I can tell you how to see a sample if you think you might want to goto the trouble of building one. If you don't have Access, get one - ebay's a good place. No one uses it much so they're cheap. Regards. Quote Link to comment Share on other sites More sharing options...
Guest guest Posted May 26, 2004 Report Share Posted May 26, 2004 What a glorious offer. Thank you Lee! I, too, am like Rodney and use a Mac so have difficulty with a lot of the programs out 'there'. My PDA is a Palm IIIxe, one of the older models, and hope that if you choose to do programming for a PDA it would work on that operating system as well as newer systems. Thank you, again, for your very generous offer. Ruth From: " Lee A. Shurie " <lee@...> Reply- Date: Wed, 26 May 2004 07:04:13 -0700 < > Subject: RE: [ ] PDA's and Computer Programs I am an Access programmer and Internet programmer, on CRON for 3 years. If desired, I could do the programming to create a database or a web-enabled application for group members to use. Because it would be free I would work on it in between my other jobs, but if there's interest I would be willing to entertain suggestions. Best regards, Lee -----Original Message----- From: chris [mailto:motjuste@...] Sent: Tuesday, May 25, 2004 11:35 PM Subject: RE: [ ] PDA's and Computer Programs Thanks, that's a good suggestion. Also, in contrast to nutrition software, it is free if you have Access already. I might just try it, but I'm a little fuzzy on how you put your daily tallies together. Could you send me a little sample? thanks, (|-|ri5 -----Original Message----- From: jwwright [mailto:jwwright@...] Sent: Tuesday, May 25, 2004 3:47 PM Subject: Re: [ ] PDA's and Computer Programs Yes. I put it into a spreadsheet, and I can save a version each day of what I ate. Easy to calc. there is no program that does the " real work " anyway. You can download the USDA SR16.5 into MSAccess. By far the best and easiest way. There is a query in that download that allows you to get the whole db in a spreadsheet format. Copy that to an excel file. That will take a while. Then remove the 90% crap you will never need - prepared foods, baby foods, Trim the thousands of diff cuts of meats. You end up with maybe 3-4 megs. Then set up a second sheet where you select servings or grams or ounces in a list which will total to compare against the RDA's. I can't send you mine because it's too large (slow network), but I can tell you how to see a sample if you think you might want to goto the trouble of building one. If you don't have Access, get one - ebay's a good place. No one uses it much so they're cheap. Regards. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You are posting as a guest. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.