Friday, March 28, 2014

yogi_Compute Stats In Form Responses From Commuter Survey Responses

                                         Google Spreadsheet   Post  #1578
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Mar-28-2014
post by dtwilder (!category-topic/docs/spreadsheets/2gcB5SNEaxY)
calculations on data from form
I'm trying to develop a commuter survey to capture driving distances, mile per gallon, vehicle type and other variables to be used to calculate total emissions for my office building. I keep getting tripped up on how google handles form responses in that calculated fields I add to the response spreadsheet don't calculate for new responses. I did see a thread on this forum about having to use an "arrayformula" but I'm not sure that''ll work for me.

Also, I want the user input form to use a lookup table for one of the questions but it does not seem to be grabbing the correct value from the look up table.  

The link for the spreadsheet is below if anyone has time to lend a helping hand. Thanks.