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 MI     www.energyefficientbuild.com.    Dec 18, 2012
user David Funes said:(https://productforums.google.com/forum/#!mydiscussions/docs/-Q9BVHn3mE0)
Forms-Preset Calculations
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?
Here is a sample of what I am working on:

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.

Would it be better to use multiple sheets?
following is a solution for a bit more generalized problem