Cloud Computing -- Google Docs Way

With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.

https://productforums.google.com/forum/#!topic/docs/fBGgRCXyc8I;context-place=mydiscussionsLooking for Help Filtering Data by Linking the Filtering Action to a Cell's CriteriaI'm looking to filter specific data out of a table when I mark an "x" in a cell. For instance, if I have a list of names as shown below, I would like to enter an "x" in the cell, which would filter out the person's name from my table. Any suggestions? Thank you in advance for your help.

Calculating Last Month's Income

I'm trying to dynamically calculate the income for last month. There will continue to be a dynamic data set with new values each month, typically with multiple entries per month so the rows of data will continue to expand. I'm looking for the formula to always sum the total income for the month prior to this current month.

Additionally, I'm also looking to calculate the historical average monthly income.

a function for checking a list of names against a subset list of names?

Hi! I have a list of names in a spreadsheet, and a smaller second list of names which is a subset of the first. (both in two columns ie first name, surname). I need a function/formula that will simply check each full name in the complete list (ie both columns) to see if it appears in the subset list (which is also in two columns), and if it does, to note that somehow ie put some value/symbol/text in the column next to the name in the complete list. Any tips on which formula/function will do this? [If necessary I can merge the first name/surname columns but I'd rather not.]

How to Create a Variable SUM Range Formula

I'd love some help with a Google Sheet Formula if anyone has any ideas. I make my own hours and I created a simple Google Form to help me track my hours throughout the week. It only asks for the weekday and hours worked that day. The form filters all my answers to a spreadsheet. I'm trying to make a formula that automatically calculates the hours worked for that current week. It looks for the most recent occurrence "Monday", then sums all the hours after that.

I worked out this to return the address of the cell next to Monday that logs the hours worked that day, but then it won't work when I put that in a SUM formula. Ideas?

=cell("address",index(B4:C11,match("Monday",C4:C11,0),1))

-As a side note, this doesn't search the whole range either. It's only the last 8 entries. That way I don't have two occurrences of Monday. If there's a way to pull only the most recent week that would be nice too. Nor can it just be the last 5 days because some days I work 4 hours in the morning and a more in the evening as in my sample sheet. It's nice to enter my hours right after I work so I don't forget. The only day I couldn't do this is Monday if it's searching for the most recent occurrence.

https://productforums.google.com/forum/#!topic/docs/Ce5zTEX0f8g;context-place=forum/docsConverting Time

Hi all, I was wondering if there's a formula in Google Sheets that lets me take range of time (for example: 2-4p) and automatically convert that time to express that the project took 2 hours long? Please let me know if that's doable. I also have a sample sheet if that's helpful in anyway? Thank you in advance.

Need to pull data from one sheet into another but also filter it

Hi,I am new to the world of spread sheets and am trying to setup some sheets to auto fill off the main sheet.

What I have done is created a master sheet with different categories (venue, address, phone number, day of special etc.)

I would like to be able to pull out the data for each given day onto a new sheet.This would have Venue, suburb & specials for the given day on each particular sheet.

Some venues do not contain specials for every day of the week so when they are pulled into the monday sheet I have many venues listed with blank spcials.

I would just like to pull across the relevant venues that have data located in the monday specials column on the master sheet so that when I am on the Monday sheet only venues with specials on Monday are listed.

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/XGGHbo0tmHM;context-place=mydiscussionscalculating number of classes - please help

I have individual students enrolling for classes with a minimum of 2 and maximum of 8. As such, 2 or more to 8 is 1 class. 8 is 1 class. 9 is 2 classes of less than 8. 37 students is 4 classes of 8 and 1 class of less than 8. And so on. So I will have a cell for individual students, a cell of classes of 8 and a cell for classes of 2 of more and less than 8. Can someone suggest and efficient way/arrangement of cells and formulas to for me to calculate this?