yogi_From A Table of Tasks And Completion Status Compute Percent COMPLTE And NOT COMPLETE

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #735   Sep 05, 2012     www.energyefficientbuild.com.

user Daltonj said: (http://productforums.google.com/forum/?zx=4xb2p2lt76nu#!category-topic/docs/spreadsheets/8du8FD2TO-c)
Code to figure percentage complete

Hey

I'm setting up a to-do list and I'd like to have a piece of code in one cell that counts all the cells with a task in them in the task column, say B2;B(however you say infinity). It's also going to need to have some kind of SumIf statement, because it needs to check an adjacent column to see if I've said that "Yes" I have completed the task. I think I could use this code for multiple things, but that's what I need it for at the moment.

To sum it up. I have two adjacent columns with values starting in the second row and I have an open ended number of rows it could contain. I need it to check all of the tasks to see if I have completed them and then in one cell of my choice it will display the percent out of 100 that I've completed. So if I have 10 tasks and I've completed 6, then I'll have the string "Yes" beside the completed task and one cell will display 60%. Also, just for knowledge sake, I'd like to know how to inverse that correctly and be able to say 40% left. Thanks everyone.

Daltonj

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

following is a solution to the problem

yogi_Publish Two Sheets Of A Spreadsheet As separate Web Pages

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #734   Sep 05, 2012     www.energyefficientbuild.com.

user jjspierx said: (http://productforums.google.com/forum/?zx=alk42vs49d24#!category-topic/docs/spreadsheets/KUrDGzDtC_A)
Export 2 sheets in same spreadsheet as web pages - I can only get one to export 
....
I have two worksheets that have linked data.  I would like to be able to publish both sheets to embed on a website, on 2 different pages, but only the most recently published page linked works.  So I can't just hide an sheet, as I need the info from both sheets.  And I can't separate the sheets into two workbooks, because I am linking data between the sheets.  Is my only option here to have the data combined onto one webpage?  This would be highly undesirable, but if need be, I guess that is what I will have to do.  I was hoping somebody else had another idea that would allow me to display the data from both worksheets separately on 2 different web pages.  

Thanks in advance for any suggestions anyone has to offer.

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

following is a solution to the problem

This is Sheet1 -----------------------------------------------------------------------
and here is Sheet2 -----------------------------------------------------------------------

Publish Sheet1 and Sheet2

This is Sheet1 -----------------------------------------------------------------------
and here is Sheet2 -----------------------------------------------------------------------

yogi_Compute In Column G Average Of values In Column C Based On Standings In Column D

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #733   Sep 04, 2012     www.energyefficientbuild.com.

user meph2u said: (http://productforums.google.com/forum/?zx=alk42vs49d24#!category-topic/docs/spreadsheets/sBi3-oPax2M)
How to lookup up values depending on Averaging when Duplicates (ties) exist
Two questions....
1) is there a simpler or more elegant way of stripping the "T"s from column D than the formula in E3  =arrayformula(if(left(D3:D)="T",Value(replace(D3:D,1,1,"")),D3:D))

2) the real reason for this post - how can I fill out Column G based on the values in Column C when ties are averaged (see examples in column H)?

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

following is a solution to the problem

yogi_ Extract Into Column C Only Numbers From Srings In Column A Corrupted With Other Superfluous Characters

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #732   Sep 04, 2012     www.energyefficientbuild.com.

user meph2u said: (http://productforums.google.com/forum/?zx=alk42vs49d24#!category-topic/docs/spreadsheets/wpLgBqwMfNE)
Getting rid of letters
I am getting data from an external source that should be numeric but sometimes has one or two letters (or spaces) at the beginning, in the middle or the end such as:
A889

8B26

89I22_

B82A6

7C2_2Q

6789Z
Is there any way to get rid of the letter and spaces and leave the remaining numbers in number format?

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

following is a solution to a bit more generalized problem

yogi_Clean Up Strings In Column C By Removing All Superfluous Characters

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #731   Sep 04, 2012     www.energyefficientbuild.com.

user meph2u said: (http://productforums.google.com/forum/?zx=alk42vs49d24#!category-topic/docs/spreadsheets/vd_F4sx0R_E)
trimming trailing spaces.
I am getting external data "Lastname, first name,________" where the underscore signifies trailing spaces.   I need to take these off because of a lookup function.   I can find the TRIM function which seems to take of preceding spaces but have not been able to find a way to take of the trailing spaces.  Any ideas?
----
 I have put the problem in this spreadsheet on the TRIM tab:
https://docs.google.com/spreadsheet/ccc?key=0Atrb4wVf_dsSdG8tT2xER2lfS0lYbUdvNUM3UVZaMnc#gid=1 When I copy the result of the trim function and past special in a third column, the original spaces persist.  I realize this is not exactly the question I asked, but it is a distinction I was not aware of until now.
I appreciate your help.
In this case, I don't think the SUBSTITUTE function will work as there are blanks in the middle of the names either after the comma, or before Jr, III, etc.
-------------------------------------------------------------------------------------------
I present solution in the following

yogi_Consolidate Names And Numbers From August And September Columns And Sort In Descending Order By Numbers

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #730   Sep 03, 2012     www.energyefficientbuild.com.

This is an extension to the solution I had posted in response to a question from user DanielL in my following blog post:
yogi_Add To August Column Numbers From September Column And Sort In Descending Order, 
http://yogi--anand-consulting.blogspot.com/2012/09/yogiadd-to-august-column-numbers-from.html