Please help me with setting up a tool to analyze a food frequency questioner

julianhg · 23. November 2018

Dear Community,

I would like to set up a tool to analyze a nutrition survey.

There are about 40 different foods. For each food the subjects are asked about the times eaten in the last month (from never to a couple of times a day) and about the amount of portions (from 1/4 to 3)

There is a list to translate the question about the frequency into a number (times per month) and a list of how big a portion is for each food. From these data one can calculate the amount eaten by the subject.

I don't want to type everything in by hand. My idea was to have two list boxes with the possible answers, one for the frequency and one for the portion size.

Can you program them to spit out something else then 1, 2, 3,...? But actually the numbers in the list like 168 a week for the answer 5 times a week. Or can you set up another field with a what if function like: if 1 then 0, if 2 then 1, ..., if 11 then 168?

I appreciate your help

Andreas Killer

No problem, I'm German. But there is something wrong with your screenshot, I can see only a white square on black background...

Can you please check that and post it again?

Andreas.

julianhg

this is what I got so far in excel. I hope you can understand what I am up to from this. The food frequency questioner is in German.

thank you

Andreas Killer

You misunderstood me, that really is what you are looking for.

I suggest you show us the paper form, then we can show you an example how to setup an Excel file for that.

Andreas.

julianhg

Thank you for the quick answer, but that is not what I am looking for. The questioner is give to the participants in paper form. I would like to have a quick way to digitalis them.

Claus Busch

Hi Julian,

try it with a Pivot table.

Drag Date and Food to the rows and the portions to the value and group the date by month and year.

Claus

Hi,

willkommen im Windows Forum!

Please help me with setting up a tool to analyze a food frequency questioner - Similar Threads - Please help with	Forum	Datum
Help me sign in to OneDrive Help me sign in to OneDrive: Die Anmeldung auf meinem Notebook in One Drive klappt nicht mehr. Wenn ich mich anmelden will, heisst es es hat nicht geklappt. Dann melde wähle ich abmelden aus und will mich neu anmelden und das...	Microsoft Office	19. Mai 2025
Help me sign in to OneDrive Help me sign in to OneDrive: ich kann One Drive nicht anmelden am PC	Microsoft Office	23. September 2024
Help me sign in to OneDrive Help me sign in to OneDrive: Hallo zusammen,Ich habe Probleme mich bei der onedrive auf meinem iPhone anzumelden. Hier bekomme ich eine Auswahl zum anmelden. Privat oder Business. Hier erhalte ich dann die folgende...	Microsoft Office	10. Januar 2024
Help me sign in to OneDrive Help me sign in to OneDrive: I cannot login to one drive even once rebooted the system. Whenever I try to login to one drive I get the following errror messge:Da hat etwas nicht geklappt. [1200]	Microsoft Office	30. Oktober 2023
Help me sign in to OneDrive Help me sign in to OneDrive: Seit dem ich am 21.09.2023 Microsoft Office 2021 Proffesional zuvor Office Proffesional 2013 deinstalliert auf meinem Windows 10 Laptop Version 22H2 installiert habe, ist das OneDrive Symbol...	Microsoft Office	22. September 2023
Can you help me please with my Windows 10? Can you help me please with my Windows 10?: Hello MicrosoftI need help with my Windows 10, i once started a Windows update while i started a game Apex Legends and when the update was finished i got stuck in the Startup repair loop and i...	Apps	15. Mai 2023
Can you help me please with my Windows 10? Can you help me please with my Windows 10?: Hello MicrosoftI need help with my Windows 10, i once started a Windows update while i started a game Apex Legends and when the update was finished i got stuck in the Startup repair loop and i...	Games und Spiele	15. Mai 2023

Please help me with setting up a tool to analyze a food frequency questioner