Monday, November 26, 2012

yogi_TimeSheet Related Calculations In Computed Columns In Form Responses Sheet


                                          Google Spreadsheet   Post  #894

              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 26, 2012
user Eddieb0s said:(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/BmCqesnFcGI)
Auto calculate a complex daily timesheet
I am developing a somewhat complex daily timesheet for my employees.  I have linked a copy of it here for anyone of you developers out there to help me with.


Everything works great!  Columns AT-BF automatically calculate the employees payout, HOWEVER, when a new form entry is added I have to copy those formulas to the next line because the form adds a new row!  It's quite tedius!  Is there a way that I can get the spreadsheet to automatically pull the formulas down when a new form is submitted?
-----------------------------------------------------------------------------------------------------
there are a number of redundant columns in this spreadsheet -- however I have made no attempt to reduce the number of columns; I have marked the computed columns with light brown background color and I have shown the formula that needs to be used for each of the computed columns -- ideallt the formula for the computed column should be written in row 1 so that the formulas are aploicable from Get Go.

2 comments:

  1. Wow! Thank You for your thorough and thoughtful explanation!

    One more question.. how can I copy the amounts contained in AT2-AX2 down the page automatically as well?

    ReplyDelete
  2. Hi Edster:

    You Are Very Welcome.

    You may not want the figures in cells AT2:AX replicated all the way down ... you may want those to be input as variables. However if you do want those replicated down colums AT:AX can also be made computed columns using array formulas as I have done for other columns.

    Cheers!
    Yogi

    ReplyDelete