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.
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.
To Edit/View: https://docs.
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.
Wow! Thank You for your thorough and thoughtful explanation!
ReplyDeleteOne more question.. how can I copy the amounts contained in AT2-AX2 down the page automatically as well?
Hi Edster:
ReplyDeleteYou 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