yogi_Selecting Item Randomly From Filtered List

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

ahs004 said:

I want to select a name from a list in a column after filtering the data using other columns

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

Let us assume the filtered list is as shown in the following illustration in column A. I use the RAND function to generate a random number assuting that there is a potential to generate a positive integer with a value varying from 1 to the total number of items in the filtered list.

So here we go ...

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

yogi_Spreadsheet ForDeclining Balance For Starting Amount And Periodic Payments

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

55418UND said ...

I'm planning on buying an expensive machine for my woodworking business.

I want to enter the starting amount I need to save followed by the amount I saved, at which point I want the spreadsheet to show the new amount still owing. With that amount at the end of the first line, I want it to begin with that amount on line two. and so on down the page until I reach zero dollars.

Not complicated, but a steady decline in balance based on the amount I enter for the amount saved.

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

---------------------------------------------------------------------------------------------------------------------
55418UND said ...
I looked at the illustration and it's perfect for what I'm looking for.
But in using Google Doc's spreadsheet, where can I enter the data you've shown to get the spreadsheet to function as requested?

As shown in the illustration ...
Starting Balance is entered in cell B2
and periodic payments are entered in cells C2 through C11

for further clarification, I have added the following image ...

yogi_Computation Involving Multiple And Or Conditions

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

question is ...
my conditions sound like this:
IF D2 is >0 or D2 is <=100, then value is 0-100
IF D2 is >100 or D2 is <=500, then value is 100-500
IF D2 is >500 or D2 is <=1000, then value is 500-1000
IF D2 is >1000 or D2 is <=10000, then value is 1000-10000
IF D2 is >10000 or D2 is <=1000000, then value is 10000-1000000
----------------------------------------------------------------------------------

In the following solution, I have used the VLOOKUP function by setting up a table in cells A1:B7 ... when the LookUp value is entered in cell D2, the value is LookedUp in column A and the result from column B is put in cell E2.



The table in cells A1:B7 can be moved to another location in the same sheet or even to another sheet of the same spreadsheet.

yogi_ComputePayFromTimeSheet

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

Chris1989 said:

How do I make my time sheet automatically calculate my total pay for the day. I have Time started in column C, Time stoped in column D, Total worked in column E, Pay rate in column F, and Daily total in column G. i am currently using formula  =ArrayFormula( IFERROR(D2:D - C2:C) ) in E2 and formula =ArrayFormula( IF(LEN(E2:E&F2:F) ; E2:E*F2:F ; IFERROR(1/0) ) ) in G2

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

Here we go Chris ...

yogi_TableGadget_SimpleExample

Google Spreadsheet

yogi_TableChartInteractive_SimpleExample