I would like to use this code :  function onEdit(e) {   if(e.range.rowStart === 1 &amp;&amp; e.range.columnStart === 1) {      e.range.offset(0,1).clearContent();   } }   but only on a tab called 'Inventory'. Could you kindly help?
I'm currently using the below script to timestamp when an edit is made to column 7 on a sheet named "Sheet 1".  function onEdit(e) {    if ([7].indexOf(e.range.columnStart) != -1) {    e.range.offset(0, 7).setValue(new Date()).setNumberFormat("dd.MM.yyyy at HH:mm");    }   }     I have a second sheet "Sheet 2" which I need to run the same script on but against column 5.  function onEdit(e) {    if ([5].indexOf(e.range.columnStart) != -1) {    e.range.offset(0, 7).setValue(new Date()).setNumberFormat("dd.MM.yyyy at HH:mm");    }   }     I've tried .getSheetByName("Sheet1") but just cant seem to get it working correctly.
I have an excel file with 2 attribute columns, 1-feature info 2-Number of color (RGB) that the current feature should be symbolize. This file file can be joined with the layer using the "feature info" field which is unique (join by attribute table). So i have as attribute the color number attribute for every polygon feature.  How can  i use this this information to symbolize every feature with their attributed color already imported from the excel sheet? Proper way to Plot a single function in two different styles? How to get rid of navigation symbols in beamer? Linear independence of $\sin(x)$ and $\cos(x)$ In the vector space of $f:\mathbb R \to \mathbb R$, how do I prove that functions $\sin(x)$ and $\cos(x)$ are linearly independent. By def., two elements of a vector space are linearly independent if $0 = a\cos(x) + b\sin(x)$ implies that $a=b=0$, but how can I formalize that? Giving $x$ different values? Thanks in advance. Will Stack Overflow's engine be (someday, or ever) open sourced? How do I make environment variable changes stick in Python? From what I've read, any changes to the environment variables in a Python instance are only available within that instance, and disappear once the instance is closed.  Is there any way to make them stick by committing them to the system?  The reason I need to do this is because at the studio where I work, tools like Maya rely heavily on environment variables to configure paths across multiple platforms.  My test code is  import os os.environ['FAKE'] = 'C:\\'   Opening another instance of Python and requesting os.environ['FAKE'] yields a KeyError.  NOTE: Portability will be an issue, but the small API I'm writing will be able to check OS version and trigger different commands if necessary.  That said, I've gone the route of using the Windows registry technique and will simply write alternative methods that will call shell scripts on other platforms as they become requirements. What is the difference between 'located in' and 'located on'? Can someone tell me what is wrong with this loop?    The error that I have is on the line 107 (first line of the loop). It says:      [V2016057174800: command not found.    I am trying to associate two the same filename from two different documents (if that makes sense). What are the assumptions for applying a quantile regression model? The question has been asked (one time) on CV before, but the answer is really imprecise and does not really answer the question in my opinion.  So: What are the assumptions for estimating a linear regression model via quantile regression?  To my understanding (and as several CV users have mentioned), quantile regression does not assume any specific distribution of the error terms - does that mean that, in a time series model, autocorrelation and heteroscedasticity do not have to be accounted for?  What about the other Gauss-Markov assumptions? I would assume that the assumption of no perfect multicollinearity has to be met when applying quantile regression, but do the parameters have to be linear? The linearity assumption only has to hold for the specific quantile I would assume.  Anyways - I do not find any backup for any of my thoughts in the scientific literature and I would appreciate a comprehensive answer. Thank you! So I tried deleting a question, my question. I'm not a mod, but I have reputation above 10k. I received this message after hitting delete, asking me to make sure I wanted to:    But after clicking Delete Question, I saw this:    It turns out that because the question has answers, I'm prohibited from deleting it. If I can't actually delete this question at all, could it just tell me immediately, and only show me the warning if I can actually delete it?  This is akin to the following analogy.     You see a flyer in your local paper stating there's a new burger shop   opening.  Great, you think to yourself, and rush over to get yourself   some burgers.  On your way into the parking lot, you see a huge banner   proclaiming one of their newest burgers. You see some employees walk   in and out of the restaurant, with T-Shirt with pictures of burgers on   them.  Great, you think to yourself, and walk in.   You get in line,   and after what seems like ages, you finally make it to the front.  You   look up at the menu.  You see that they also sell sandwiches. No, you   tell yourself, I'm looking for burgers.  You see that they also sell   burritos! No, you tell yourself, I'm looking for burgers.  Then you   see that they sell burgers. Great! You pick out a burger, then tell   the employee at the register, "Sir, I'd like to get a regular burger   please." Immediately, the employee looks up, with a quizzical look on   his face, saying "Sir? We don't sell burgers here.".   It's the same situation. I've come to that prompt so that I can delete a question.  After repeated messages and windows letting me know the consequences of deleting, what will happen after I have it deleted, I am told that the option of having it deleted by my own hand never existed in the first place. The Wikipedia  has a derivation of the Klein-Gordon equation.  It gets to this step:  $$\sqrt{\textbf{p}^2 c^2 + m^2 c^4} = E$$  and inserts the QM operators to get  $$\left( \sqrt{ (-i \hbar \nabla)^2 c^2 + m^2 c^4 } \right) \psi = i\hbar\frac{\partial}{\partial t} \psi$$  The article then says     This, however, is a cumbersome expression to work with because the differential operator cannot be evaluated while under the square root sign. In addition, this equation, as it stands, is nonlocal.   To fix this, the first equation is squared instead to get  $$\textbf{p}^2 c^2 + m^2 c^4 = E^2$$  after which the QM operators are inserted and the expression is simplified to get  $$-\hbar^2 c^2 \nabla^2 \psi + m^2 c^4 \psi = -\hbar^2 \frac{\partial^2}{\partial t^2} \psi$$  A couple things I don't understand.  First, are the solutions to this differential equation not exactly the same as the solutions to the first differential equation?  Both sides of the starting equation were squared, so it seems to me that regardless of the particular form of the resulting differential equation, both of them should have the exact same set of solutions.  Secondly, why is the first differential equation cumbersome to work with?  It seems like it would in fact be easier to work with, since the operator under the square root could be expanded in terms of a Taylor series and then you have an equation that is first order in time.  And finally, can someone elaborate on what nonlocal means? The linked article on the Wikipedia page didn't entirely help me understand it. How do I deal with "unauthenticated sources" errors in the Software Center? Closed-form expression for $\sum_{k=0}^n\binom{n}kk^p$ for integers $n,\,p$ Is there a closed-form expression for the sum $\sum_{k=0}^n\binom{n}kk^p$ given positive integers $n,\,p$? Earlier I thought of this series but failed to figure out a closed-form expression in $n,\,p$ (other than the trivial case $p=0$).  $$p=0\colon\,\sum_{k=0}^n\binom{n}kk^0=2^n$$  I know that $\sum_{k=0}^n\binom{n}k=2^n$ and $\sum_{k=0}^nk^n=\frac{k^{n+1}-1}{k-1}$ but I am unsure of whether these would be of much use now.    Additionally, what about the similar series $\sum_{k=0}^n\binom{n}kk^n$ where $p=n$? Polite or unrectified placement of the word please Possible Duplicate:          I have recently seen this image:    Should "a" have been used instead of "an" in the "...an $100,000 apartment" part? 3/4 circle with plus in it? Example of mailmerge package with an Excel spreadsheet I am looking for an example for using the  package to write a cover letter, with names and addresses on a spreadsheet. The package comes with an example, but you have to manually enter all the data. Sum of indepedent random variables and a constant Let $X_1$ and $X_2$ be independent Normal random variables with mean $\mu_1$ and $\mu_2$, and variances $\sigma_1$ and $\sigma_2$. Let $Y = X_2-X_1 + c$, where $c$ is a constant. For notational simplicity, let $Y = X' + c$, where $X' = X_2-X_1$ The moment generating function of a Normal random variable $X_n\sim N(μ_n,σ_n^2)$ is $$M_{X_n } (t)=\text{exp}\Big(μ_n t+\frac{σ_n^2 t^2}{2}\Big)$$ Then, $$M_{X'} (t)=\text{exp}\Big[t(\mu_1+\mu_2)+\frac{t^2}{2}(\sigma^2_1+\sigma^2_2)\Big]$$ Thus, by the uniqueness property of moment generating function, $X'$ is said to follow a Normal distribution with mean $(\mu_1+\mu_2)$ and variance $(\sigma^2_1+\sigma^2_2)$. How do I proceed from here to derive the following:  First, I want to establish that $Y$ is also a Normal random variable using the moment generating function. The constant $c$ bugs me, but I cannot ignore it. As per my understanding, $Y\sim N\big(c+\mu_1+\mu_2,\sigma^2_1+\sigma^2_2\big)$ (and I could be completely wrong). But I don't understand how to apply the moment generating function to prove that.  Secondly, I want to derive $P(Y \leq a)$, where $a$ is a constant. If I am not mistaken, $P(Y \leq a)$ can be written as $$P(Y \leq a)=\Phi\Bigg(\frac{a-X_2-X_1 + c}{\sqrt{2(\sigma^2_1+\sigma^2_2)}}\Bigg).$$ But how do I arrive at that.   Any help is high solicited and appreciated. C# vertical label in a Windows Forms Hi i want to put this simbol "%" in the tick labels only in the x axis how can i do?