yogi_Update Original Record With Latest Submitted Updates

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user morphe said:
Any help with the following would be hugely appreciated :)
Data: A-fieldname / B-value
Log Records: C-date / D-fieldname / E-new value
Is there a simple way of updating A-B with the most recent log entries in C-E? There are about 50 fixed fields in A.
Any help with this would be much appreciated; I can't seem to find the right example through the search function.
Sorry, I've explained that poorly, so I've created a spreadsheet which hopefully clarifies what I mean.
https://docs.google.com/spreadsheet/ccc?key=0ArR5E9JS2LFVdFVjX2pwVkZsNno0bzZ6ci1sMFdmTXc
----------------------------
following is one way ... my solution to the problem

yogi_Sum Rows 2-14 For Every Column In Row 15

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user skkaiser said:
Sum rows 2-14 for every column in row 15?
I can't believe I'm asking this, but I'm doing a simple expenses spreadsheet and I just want to have rows 2-14 be my expenses and I want row 15 to automatically calculate the sum of rows 2-14. Row 1 says the month and column 1 says the title what the expenses are. I can manually sum each month, but I'd rather just have it do it automatically. I don't understand all the array formula stuff that google's posting. I'm just an average joe schmoe who wants to be able to use google docs and there don't seem to be any help forums for me.
-----------------------------------

yogi_Compute In Rows Sum Of Data In Successive Columns

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user Kelemvor said:
So I tried to use the Continue command for this but wasn't having any luck,
I have some columns of data that I want to total up in a separate column.
So in Column A I have entries for C, D, E, F
In columns C - F I have numbers.
In column B I want to have the total for the columns so it'd look like this:
A, B, C, D, E
C, 10, 3, 9, 5
D, 15, 4, 3, 3
E, 12, 3, 3, 4
In Cell B1 I have =sum(c:c) which works fine.  I want to them fill in downward so that B2 would get =sum(d:d).  Problem is I'm dragging down and want it to increment the column going across.
Does that make sense?  Can I do this somehow?

----------------------------------

following are couple of arrayformulas for solution to the problem
in the first sheet I have considered a fixed number of coumns but an openended row range
in the second sheet I have considered an openended row range as well as an open ended column range

yogi_Compute Start Time Of Next Job From End Time Of Previous Job

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

user on.llc said:
I have the following formulas (crude and primitive as they may be) that works. But I have new data coming in sometimes by the minute, an arrayfomula function would sure help. But mixing indexing and arrayformula combination does not generate the intended result. Any help would be greatly appreciated.
=if(D32<2,iferror(INDEX( FILTER( C33:C ; A33:A=A32;B33:B=B32;D33:D<2) ; 1 );""),"") and =if(D32=0,if(E32=1,index(sort(filter(C1:E31,E1:E31>1,A1:A31=A32),1,false),1,3),""),if(D32>1,"",E32))
The link is https://docs.google.com/spreadsheet/ccc?key=0Ara_-4ohkGQYdERpRVdidWkxbGZJRjVlRUp6dGZqV2c
Col D-F are incoming data where employees key in with text messages. Col A-F are stamped by the system.
Col G & H are the formulas seeking guidance here.
Basically the end time (Code 0) of one Work Order becomes the start time (Code 1) of the next Work Order except when lunch (Work Order 1) gets in the way. The continuation of the Work Order prior to lunch needs to be resumed when lunch stops. Remarks (Code 2) can be ignored for calculation. And (Code 0) and (Work Order 0) together means end of day. Hence when the spreadsheet is tabulated, all the rows with blank Col G & H can be skipped. The spreadsheet has only one sheet but may contain 10,000 rows of data.
Ditto to you gentleman's sentiments about Andre. I hope all is well with him and look forward to his continued insightful comments.
Jim
-----------------------------------

yogi_Make A Budget (Expense) List And Allocate Amounts To Associated Categories

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user Kelemvor said:

So, I'm thinking about making a spreadsheet that I can use as a check register and budgeting tool.  I know there are some out there but I didn't see any that combined these two into one sheet.
My initial thought is that I will enter the information into the sheet (date, description, category, amount, etc).  I then want the spreadsheet to look at the value I chose for category.  It would then go find the column for that category and add the value of the amount box to the end of the list
Sample Spreadsheet:  http://goo.gl/VjvHZ
In the above sample, I'd want the spreadsheet to automatically put 20 and 30 under clothing and 50 under gas as I type them in.  I know I can do this sort of thing in Excel with VBA but I'm not sure if Google Spreadsheets have the same sort of programming capability.

-----------------------------------------------------

following is one solution to the problem

yogi_Separate First And Last Names In Column A And Then Sort The Data By Last Name

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user Bubbles 1960 said:
I want to alphabetize on the last name and keep the information in the adjacent cells with the name.  I just realized I need to separate first and last names into two columns, and sort on column B.  For the sample purpose, please just tell me how to complete the task at hand.  I'll manage the first/last on the real list.  Thanks!
------------------------------------------
following are couple of ways for solution to the problem
Sheet1 shows the original data ... Sheet1a shows the needed solution
Sheet2 shows the original data ... Sheet2a shows the needed solution
In the original data sheets I have added 2 intermdiary columns shown with light brown background

yogi_Combine Contents Of A Row In A Single Cell With A Specified Separator

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
I want to combine contents of a row in column C and beyond in column A with cell B2 housing the separator character
----------------------------------
following is one solution to the problem