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.
Tuesday, December 18, 2012
yogi_Create Computed Columns In Form Fed Data For Prices Using Specified MarkUp And SpecialDiscount
Google Spreadsheet Post #929
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MIwww.energyefficientbuild.com. Dec 18, 2012 user David Funes said:(https://productforums.google.com/forum/#!mydiscussions/docs/-Q9BVHn3mE0)
I am trying to create a form that will drop static figures into a spreasheet that will use that information to do calculations (like a price markup).
I am noticing that whenever I make an entry on the form, however, it pushes down the entire row down one, instead of populating the available fields in the given row.
Is there a way for me to use forms to drop in a static figure and continue to do calculations in the same row, without moving all my equations down a whole row with each entry?
I had looked at the array formulas, and they look like what I need, altho I don't see an option for dividing figures using the array, is there a way I can use inverse and multiplication? Or is there simply an option for division that I may have missed.
Also, I am still noticing that when I submit a response from the form, the existing row still moves down,In the given example columns A,B, and C are populated by the form, and columns D,E,F consist of a static figure, the product of C and D, and a fraction of E (respectively).
The goal is to create a form that will drop all the information i need into a single sheet, and have the formulas create the markups and discounts i need.