GParted - Cannot open display
Why don't gksu/gksudo or launching a graphical application with sudo work with Wayland?
Excel-Count number of visible cells containing certain string I have a sheet in which I first apply a filter to a certain column to show "Unique records only". Now I have a column which contains, for e.g., values like:  Applepie Applesauce Crabapple Banana Mango   What I need is the count of all visible cells containing the word "Apple". Note that this should exclude the hidden (filtered out) cells. Now I have found out a formula:  `=SUMPRODUCT(SUBTOTAL(3,OFFSET(Sheet1!A:A,ROW(Sheet1!A:A)-MIN(ROW(Sheet1!A:A)),,1))*(Sheet1!A:A="&lt;Text to search&gt;"))`   However the problem with this one is this formula searches for the entire text. NOT just a part of it. How do I modify this formula to return count of cells containing "Apple" i.e. for this example it should return 3 as the result. I have an excel spreadsheet with header and survey drill data. Header data contains hole ID, and location coordinates, and the survey data contains related downhole survey with Distance, Azimuth and Dip values.   Since I know the hole location and surface elevation, I would like to be able to convert the survey table to XYZ coordinates as well.  Does anyone has a function / procedure / example?  (VB &amp; ArcObjects)  Header Data:    Survey Data: How do I find the common ratio of a geometric sequence? A geometric sequence has its first term equal to $12$ and its fourth term equal to $-96$.   How do I find the common ratio? And find the sum of the first $14$ terms Could a ship equipped with Alcubierre drive theoretically escape from a black hole? Could a ship equipped with Alcubierre drive theoretically escape from a black hole?  Also, could it reach parts of the universe that are receding faster than the speed of light from us? When should a supervisor be an author? I understand that in a lot of big-lab fields it is common for the principal investigator to append their name to a paper even if they did not write the paper, design the experiment, or collect data since they spend energy securing funding, and managing the whole lab. What about for small labs?  What are the requirements for a supervisor to be included as an author on a paper, as opposed to just appearing in the acknowledgements? If you are working on your own projects independently of your supervisor, but using funding provided by your supervisor (how does this change when the funding provides resources versus just your salary), are you suppose to add them as authors or just acknowledge the source of funding? Why does list(my_list) modify the object? Does $G\times K\cong H\times K$ imply $G\cong H$? I know that if (p) is maximal then Z/(p) is a field which implies its an integral domain which then implies that (p) is a prime ideal and p is prime. I'm having trouble going the forward direction assuming that p is prime and then showing it's a prime ideal. I just created my new character 2 hours ago and I've reached a town. Sometimes random guards will comment that I look ill, or that I should rest. "You look sick, honey. Do you want to lie down?", isn't uncommon.  Did I unexpectedly get vampirism? I didn't fight any vampires, only a couple of wolves and bandits.  I'm a dark elf, so maybe my race isn't seen much around Skyrim and the remarks are more roleplay than actual illness.  Any ideas? I'm using 13.04 for the first time and I am using proxy base server that's why I can't download anything while I use apt-get update then it shows this message  coolmonter@coolmonter-HP-ProBook-4431s:~$ apt-get update E: Could not open lock file /var/lib/apt/lists/lock - open (13: Permission denied) E: Unable to lock directory /var/lib/apt/lists/ E: Could not open lock file /var/lib/dpkg/lock - open (13: Permission denied) E: Unable to lock the administration directory (/var/lib/dpkg/), are you root?   any suggestion How to describe "object" arguments in jsdoc? Why aren’t my villagers breeding? I’ve got one villager up 7 blocks surrounded with 6 doors. On ground level I have villagers who are supposed to breed. They are willing, their inventories are full of potatoes, and I’ve been sitting here for hours.  Hearts are popping up above their heads but nothing happens. I am playing on Xbox One. Find all $n\in\mathbb{N}$ so that there exist $x,y,z\in \mathbb{N}$ that solve:   $$(x+y+z)^2=nxyz$$   I tried to attack it finding solutions, but all the solutions doesn't seem to have something in common. For example:  $$ (x,y,z,n)=(1,1,1,9)$$ $$ (x,y,z,n)=(1,2,3,6)$$ $$ (x,y,z,n)=(1,4,5,5)$$ $$ (x,y,z,n)=(2,2,4,4)$$ $$ (x,y,z,n)=(8,8,16,1)$$  I was trying to solve this problem, but someone told me that a hint to solve it is using Vieta Jumping. I don't know how to use Vieta Jumping, so can anyone help me to understand how to apply Vieta Jumping and solve the problem? Add parenthesis as an accepted Markdown ordered list delimiter The Markdown editor knows that an empty line, followed by a number, followed by a period, followed by a space, is a list item.  This works great It's almost magic  The problem is that I almost always use a close parenthesis for my lists. I think it's a pretty common practice, but the problem is that the editor / Markdown parser doesn't accept parenthesis as an acceptable list delimiter:  This fails horribly This is on the next line I swear Integrating $\int\frac{x^3}{\sqrt{9-x^2}}dx$ via trig substitution What I have done so far: Substituting $$x=3\sin(t)\Rightarrow dx=3\cos(t)dt$$ converting our integral to  $$I=\int\frac{x^3}{\sqrt{9-x^2}}dx=\int \frac{27\sin^3(t) dt}{3\sqrt{\cos^2(t)}}3\cos(t)dt\\ \Rightarrow \frac{I}{27}=\int \sin^3(t)dt=-\frac{\sin^2(t)\cos(t)}{3}+\frac{2}{3}\int\sin(t)dt\\ \Rightarrow I=18\cos(t)-9\sin^2(t)\cos(t)+c$$ Which is where I'm stuck. I can substitute back in for the $\sin(t)$ terms but don't know hot to deal with the $\cos(t)$ terms and back out information about $x$.   edited: because I miswrote the problem, I am sorry. Is this sentence grammatically correct?  Anyone who loves the English language should have a copy of this book in their bookcase.  or should it be:  Anyone who loves the English language should have a copy of this book in his or her bookcase. How to set a maximum execution time for a mysql query? This is result of who -uH:  NAME     LINE         TIME             IDLE          PID COMMENT me    :0           2013-08-29 01:29   ?          1686 (:0) me    pts/0        2013-08-29 01:42  old         2905 (:0) me    pts/1        2013-08-29 01:45  old         2905 (:0) me    pts/2        2013-08-29 01:52  old         2905 (:0) me    pts/3        2013-08-29 02:26  old         2905 (:0) me    pts/4        2013-08-30 18:37 00:07        2905 (:0) me    pts/5        2013-08-29 10:34  old         2905 (:0) me    pts/6        2013-08-29 11:05  old         2905 (:0) me    pts/7        2013-08-29 13:34  old         2905 (:0) me    pts/8        2013-08-30 15:56 02:45        2905 (:0) me    pts/9        2013-08-30 18:27 00:17        2905 (:0) me    pts/10       2013-08-30 17:34   .          2905 (:0) me    pts/11       2013-08-30 17:37 00:13        2905 (:0) me    pts/12       2013-08-30 18:28 00:17        2905 (:0) me    pts/13       2013-08-30 18:38 00:07        2905 (:0)   Why it lists my username in 15 lines? How do I know If someone has connected to my system remotely? Checking out  and  (and some papers) was a bit difficult for understanding Group Action. The closest to understanding was this part:    I understand the definition of homomorphism (a structure-preserving map between two algebraic structures of the same type). And from what I understand the symmetric group is a group of functions (bijective functions) mapping elements of a set $X$ onto itself.  However I get confused at this line:     ...an action of $G$ on $X$ may be formally defined as a group homomorphism $\phi$ from $G$ to the symmetric group of $X$.   That seems to be the definition of group action, but I am having trouble understanding how to apply that.  What that says to me is it is a homomorphism (function) $f \colon X \rightarrow S$ where $S$ is a set of bijective functions on $X$. That itself seems weird, I thought a group action would result in a number or something related to $\{1, 2, 3\}$ (defined next).  Continuing, if we have a set $X = \{1, 2, 3\}$ and a group $(*,\{4, 5, 6\})$, then the symmetric group of $X$ would be something like $S = \{1 \rightarrow 2, 2 \rightarrow 3, \dots \}$, and $\phi$ would be something like $f : \{4, 5, 6\} \rightarrow S$. That doesn't make sense to me and I feel like I'm interpreting something wrong. I don't see how mapping to a set of functions $S$ will result in an action on the set. Why massless particles have zero chemical potential?