With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
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 MIwww.energyefficientbuild.com. Mar-28-2014 post by dtwilder (https://productforums.google.com/forum/#!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.