13,775 reputation
1679147
bio website sensefulsolutions.com
location United States
age
visits member for 4 years, 5 months
seen Nov 26 at 21:02

May
13
comment Are Google Shortened URLs (goo.gl) Publicized, Sequential, or Secret?
The way I defined the 4 states, they should be mutually exclusive. So it should be exactly one of them. I would not consider the tip about going into your own account to see the list you created as being publicized because only you can see that page, right? From your example, it seems that it is not sequential. So that only leaves "secret" or "publicized". I know that you can replace the letter in a URL and arrive at the link, but I would still consider that secret. I mentioned that with a secret URL there still is a chance that someone will land on it, but it's unlikely.
Apr
11
comment What does Treat as an alias do in Gmail?
So even if I don't have gmail set up to read mail (e.g. via pop3 or forwarding) from an aliased account, the aliased account's email messages will appear in my inbox if I send mail to it?
Dec
22
comment Is there a webapp to create ASCII art tables?
@KevinVermeer: I made it so that you can type the tab character in the edit box. Does that solve the problem, or do you still want other delimiters?
Jan
5
comment How to generate HTML for syntax highlighted code?
Do the html styles need to be inline (e.g. <span style="font-weight:bold; color:blue">i</span>) or is importing/creating a stylesheet fine (e.g. <span class="variable">i</span>)?
Dec
31
comment Wildcard search in Gmail
Could you please accept a different answer? The one that is currently accepted does not work.
Dec
25
comment Is it possible to use a loop in Google Spreadsheets?
I guess the problem is that I'm asking two questions in one. This answer answers my first question. I'll ask another question about the eval.
Dec
25
comment How to pass a range into a custom function in Google Spreadsheets?
I think I'm not explaining myself clearly... look at your answer to this question. You recommended that I use =weightedAverage(B3:D3,$B$2:$D$2), I would like to make the function more error proof by not having to send the 2nd argument (i.e. I want to call it as =weightedAverage(B3:D3)), and then have the code automatically know that the range starts at B and ends at D, so it gets the corresponding values from the 2nd row. Note: the value "2" can be hardcoded, but "B" should not be hardcoded.
Dec
25
comment How to calculate weighted averages in Google Spreadsheets?
Thanks for that link and the answer.
Dec
24
comment How to calculate weighted averages in Google Spreadsheets?
What do the $ signs mean?
Dec
24
comment Is it possible to use a loop in Google Spreadsheets?
Any idea if I can pass the function to run? In this case it would be REGEXEXTRACT(CELL, "\d+") and then run it with something equivalent to an eval function?
Dec
24
comment How to pass a range into a custom function in Google Spreadsheets?
I'm trying to find out what the first column in the range is. For example, in the range C1:F1, I want to know that the range starts on column C.
Dec
24
comment Clearing watch history for television episodes on Netflix
See Also: webapps.stackexchange.com/questions/6267/…
Dec
24
comment Move Google Calendar Gmail gadget to top right
I tried using this, but it doesn't look right. Could you explain which settings you are using? Is the chat panel displayed? It the lab which places in on the right enabled? Did you drag the Google Calendar widget up or down in the list of panels on the left?
Dec
24
comment Is there a bookmarklet that can toggle my Google search settings?
You probably already know this, but many modern browsers allow you to open a link in a new window by: middle clicking the link, right-clicking the link, or ctrl+clicking the link.
Dec
22
comment Is there a free photo competition hosting software?
This sounds similar to the website crowdspring.com, however, it's not a free service. It was used to find a logo for SuperUser.
Dec
16
comment How do I lookup a value from another sheet in Google Docs?
Thanks, that works. The confusing part was that you don't specify which column to use to look up the information on the second sheet. Instead, it uses the first column in the range specified as the second parameter. I ended up duplicating the columns at the end of my spreadsheet so that they can be used for lookup.
Dec
16
comment How do I lookup a value from another sheet in Google Docs?
Could you please explain which range you are using for LookupValues? I also modified the example a bit to reflect my actual problem better.
Nov
26
comment What useful bookmarklets do you use?
@phunehehe: I updated the article to include instructions. If you have anymore questions, please let me know.
Nov
23
comment Web app for prototype sitemaps (visio replacement)
See also: webapps.stackexchange.com/questions/757/…
Nov
21
comment How can I filter Amazon.com results to exclude 3rd party merchants?
posting a non-webapp solution is perfectly fine. See this for more info.