How can I PM people on this site?
Any way to send a personal message to another user?
How can I display only the unique values in one column in Excel? Is there a way to display the unique values in a column ONLY?  Example:   AAPL AAPL AAPL AAPL AKAM AMZN AMZN AMZN AMZN AMZN AMZN  Expected result:   AAPL AKAM AMZN  I have already done a sort for multiple factors, and the first match for each is the best match.  I'm not sure if this is a vlookup or something else. What's the scope of a variable initialized in an if statement? Object selection box in addon In my addon panel, how can I have an object selection box?  And what data type would I use to store the the selected object?  It should look like this: \texttt overfull hbox problem I asked a question earlier about \verb and overfull hbox :   And regarding the solution there, changed many of my \verbs to \texttt{}s.  I have come up with a new problem now.  An example:  \documentclass {article} \begin{document} \section {Introduction}      The entry point is in \texttt{TRCS.Main()} (\texttt{TRCS\char`\\TRCS.cs}).    The stateless (see \S 3.4.3) forms are started immediately, then another controller   is invoked, namely  \texttt{Workflow}. \end{document}   Compiling this example will show my problem.  \texttt{Workflow} causes an overflow, and a rather significant one.  What should I do to alleviate the problem?  Thanks in advance for your help! How to be sure API calls are using TLS 1.2 We are using .Net to make web service calls the Salesforce API. Is there a way to know for sure that the calls are using TLS 1.2? Are there any API logs or records of the protocol is use in Salesforce we can review to be confident the change is working? What is a primary decomposition of the ideal $I = \langle xy, x - yz \rangle$? I tried to update Grub so I run:  sudo update-grub  Generating grub configuration file ... Warning: Setting GRUB_TIMEOUT to a non-zero value when GRUB_HIDDEN_TIMEOUT is set is no longer supported.   What exactly this warning wants to be changed? (I upgraded from 12.04 to 14.04 before)  This is my /etc/default/grub file:  GRUB_DEFAULT="0" GRUB_HIDDEN_TIMEOUT="0" GRUB_HIDDEN_TIMEOUT_QUIET="true" GRUB_TIMEOUT="10" GRUB_DISTRIBUTOR="`lsb_release -i -s 2&gt; /dev/null || echo Debian`" GRUB_CMDLINE_LINUX_DEFAULT="quiet splash" GRUB_CMDLINE_LINUX="" How can I make an overset symbol at the same size and height as \bar except with a different symbol? Apologies for the cryptic title, but I was not sure how best to phrase the question in one sentence. I am essentially trying the create a vector symbol with \rightharpoonup as the top instead of the arrow.  The output to the following code will feature an overset harpoon over x, next to a simple \bar{x}. Observe that on the left, the top symbol is significantly higher and bigger than on the right one.  \documentclass{article}  \usepackage{amsmath,amsfonts,amsthm,amssymb}  \newcommand{\vect}[1]{\overset{\rightharpoonup}{#1}}  \begin{document} $$ \vect{x} \quad \bar{x} $$ \end{document}   I would like to create something that looks in every way like the right hand symbol, except using something that looks like \rightharpoonup at the top.  If this command sequence already exists in LaTeX, please use that as an answer, because I have searched for and failed to find it so far. How could I place objects (buildings) on a flat surface in the BGE? I'm working on an  in BGE, and I am not sure how I could make it so you can place buildings on flat surfaces (or unless there is an easier way). I would love to know how to place buildings when you click a certain button to place it.  I don't really need anything fancy like price and stuff like that yet. I really have no idea if  is required to do this. How to configure Ubuntu as an LDAP client? How to configure Ubuntu 12.04 as LDAP client with PAM modules? windows 7 desktop icons: new icon placement When moving/saving/etc a new file on the desktop, the icon appears second (just after "Computer"). I find it annoying, since I want my "special" icons to be first (such as the recycle bin, "Network", etc.).  Can this behavior be changed? Bash One Liner: copy template_*.txt to foo_*.txt? Say I have three files (template_*.txt):   template_x.txt template_y.txt template_z.txt   I want to copy them to three new files (foo_*.txt).    foo_x.txt  foo_y.txt  foo_z.txt   Is there some simple way to do that with one command, e.g.   cp --enableAwesomeness template_*.txt foo_*.txt Do gravitational lenses work on gravitational waves? Do gravitational lenses work on gravitational waves? Could we get an Einstein cross of gravity? I'm trying to include a file with a specific shape (cup) into another TikZ image, in order to use the cup as a "stamp" to draw more complex figure. The file is located in /usr/share/tikzit/shapes/cap.tikz  \documentclass{article} \usepackage[svgnames]{xcolor} \usepackage{tikz} \usetikzlibrary{decorations.markings} \usetikzlibrary{shapes.geometric} \pagestyle{empty}  \pgfdeclarelayer{edgelayer} \pgfdeclarelayer{nodelayer} \pgfsetlayers{edgelayer,nodelayer,main}  \tikzstyle{none}=[inner sep=0pt] \tikzstyle{node1}=[cap,fill=White,draw=Black]  \tikzstyle{simple}=[-,draw=Black,line width=2.000] \tikzstyle{arrow}=[-,draw=Black,postaction={decorate},decoration={markings,mark=at position .5 with {\arrow{&gt;}}},line width=2.000] \tikzstyle{tick}=[-,draw=Black,postaction={decorate},decoration={markings,mark=at position .5 with {\draw (0,-0.1) -- (0,0.1);}},line width=2.000]  \usepackage[graphics,tightpage,active]{preview} \PreviewEnvironment{tikzpicture} \newlength{\imagewidth} \newlength{\imagescale}  \begin{document} \begin{tikzpicture}     \begin{pgfonlayer}{nodelayer}         \node [style=node1] (0) at (-2.5, 1.5) {};     \end{pgfonlayer} \end{tikzpicture}  \end{document}   The code i want to include is the following:  \begin{tikzpicture}         \path [use as bounding box] (-2,-2) rectangle (2,2);         \begin{pgfonlayer}{nodelayer}                 \node [style=none] (0) at (0, 0.75) {};                 \node [style=none] (1) at (-0.5, 0) {};                 \node [style=none] (2) at (0.5, 0) {};         \end{pgfonlayer}         \begin{pgfonlayer}{edgelayer}                 \draw [in=0, out=90] (2.center) to (0.center);                 \draw [in=270, out=-90, looseness=0.75] (1.center) to (2.center);                 \draw [in=90, out=180] (0.center) to (1.center);         \end{pgfonlayer} \end{tikzpicture}   But it seems I miss how to specify the directory of cup. I get this error:     Package pgfkeys Error: The key '/tikz/cap' requires a value. I am   going to ignore this key.   It seems like I have to deal with tikzstyle or pgfkey, but I don't know how to specify an external file. Pygame - blitting from x and y cordinates of image Determining ethnicity according to ancestry? My sister, cousins, and other relatives speculate that my mom's grandmother was Jewish (for various reasons). I've heard people say at times things like, for example, "I'm 50% German" or "I'm 25% Swedish." This has to do with their ancestry. But, how exactly is this calculated? Say for example that my mother's paternal grandmother was indeed 100% Jewish, what would that make me and my siblings, and how is it calculated? Applying Arzela-Ascoli to show pointwise convergence on $\mathbb{R}$. The statement I am trying to prove:  Let $\{ f_n \}$ be a sequence of equicontinuous, real valued, uniformly bounded   continuous functions on $\mathbb{R}$. Show that $\{ f_n \}$ has a convergent subsequence   which converges uniformly on any bounded subset of $\mathbb{R}$ and pointwise on all   of $\mathbb{R}$ to a continuous function. (Royden pg 210, problem 9).  I believe the first portion follows directly by Arzela Ascoli, once it is noted that if we are given some bounded subset $E$, we can look at $\overline{E}$ a compact set on which the family is equicontinuous and uniformly bounded.  For pointwise convergence on all of $\mathbb{R}$, the question seems to require some sort of diagonalization argument: Take some dense sequence of $\{x_i\}$ (the reals are separable) and write columns of $f_n$ applied to each individual point. There will be a convergent subsequence by Bolzano-Weirstrass and since the outputs are real and bounded by the uniform boundedness of the family. I am a bit fuzzy on this part: Repeating this literally pointwise and moving far enough diagonally, we can correct for different convergence "speeds" pluck out a single convergent subsequence for any given epsilon and have $\sup|f_n(x)-f(x)|&lt;\epsilon$ for any given epsilon. Finally, continuity should follow from an $\epsilon/3$ argument and equicontinuity of the family.  However, in formalizing the above, I am getting caught up in the notation of that sort of argument and am hoping for a more elegant solution. Is there a better way? Am I just generally confused and that's why I'm having trouble writing things down formally?   Thanks! Prove that $6$ divides $n(n + 1)(n + 2)$ I am stuck on this problem, and was wondering if anyone could help me out with this. The question is as follows:  Let $n$ be an integer such that $n ≥ 1$. Prove that $6$ divides $n(n + 1)(n + 2)$. Note: An integer $a$ divides an integer $b$, written $a|b$, if there exists $q ∈ Z$ such that $b = qa$. Alternatively, $a|b$ if dividing $b$ by $a$, $b ÷ a$, results in an integer.  Should I do a proof by induction? All help/input is appreciated! What are the shortcomings of the Mean Absolute Percentage Error (MAPE)? The  () is a common accuracy or error measure for time series or other predictions,  $$ \text{MAPE} = \frac{100}{n}\sum_{t=1}^n\frac{|A_t-F_t|}{A_t}\%,$$  where $A_t$ are actuals and $F_t$ corresponding forecasts or predictions.  The MAPE is a percentage, so we can easily compare it between series, and people can easily understand and interpret percentages.  However, I hear that the MAPE has drawbacks. I'd like to understand these drawbacks better so I can make an informed decision about whether to use the MAPE or some alternative like the MSE (), the MAE () or the MASE (). How do you run a 32-bit program on a 64-bit version of Ubuntu? I have a 64-bit version of Ubuntu 13.10.  I want to run a 32-bit version of a program.  However I see ia32-libs is not included in 13.10.  Is there a replacement package for this or what?