I have the task of creating a simple Excel sheet that takes an unspecified number of rows in Column A like this:  1234 123461 123151 11321   And make them into a comma-separated list in another cell that the user can easily copy and paste into another program like so:  1234,123461,123151,11321   What is the easiest way to do this?
I have the task of creating a simple Excel sheet that takes an unspecified number of rows in Column A like this:  1234 123461 123151 11321   And make them into a comma-separated list in another cell that the user can easily copy and paste into another program like so:  1234,123461,123151,11321   What is the easiest way to do this?
Why can't the Klein-Gordon equation with a Couloumb potential describe the hydrogen atom?  Why can the first order Dirac equation explain it? What are the failures? Why do I have to specify runat="server" on all my ASP.NET controls when it is a mandatory attribute and server is the only option available in my limited knowledge of ASP.NET, and I get an error if I don't use it?  I do understand that I can optionally use it on my HTML tags, and I do understand the client/server paradigm and what it is actually specifying.  Is it a redundant tag that could just be implied by the control being an ASP.NET control, or is there an underlying reason? Already the early papers on supergravity were written using computer algebra software to do some calculations. What modern packages do people normally use for doing such calculations? Of course Mathematica and presumable a lot of other programs can be made to do such calculations, I am wondering if there are special packages or tutorials how to do such calculations in them. Searching for questions that have ONLY a given tag (i.e. add a range operator for tags) Why does HDD activity slow the whole System down (on Windows 7)? If I copy a large amount of data from on drive to another (physical) drive my whole system is running slow.  I am using Windows 7 64bit version on an Intel Core 2 Duo 3 GHz.  This is the situation:   Very fast copying between two SATA disks.  Resource Monitor shows 80MB/s read, 70MB/s writes and 150MB/s total The total CPU load is about 3% There is plenty (>2GB) of free physical RAM left All partitions have enough (>10gb, >10%) of free space left and show low fragmentation Anti-Virus software is not active   This is the problem: No matter what I want to do while copying, it takes forever. Even tasks that do not need a lot of disk access (as they should work from RAM only), are extremely slow. The moment I stop the copying process, all the unfinished tasks finish at once. For example trying to open a new browser windows or explorer window will not work. If the copying is stopped 5 explorer windows popup at once.  My question is: why? What resource is exhausted, if CPU and memory are idle? And what part of my computer hardware I need to upgrade to get better behavior? Also read Psycogeek's comment for further questions in this direction.  If your answer is, that everything needs HDD Access, which is blocked by such an activity, then my question is: Is there a way to copy something on your system without rendering it unusable until its done? (which can be hours, if >500g have to be copied). I am trying to identify a sci-fi movie from the 80's or 90's, with the following parameters:  Setting:    Scenes of a red desert planet   Culture:    Either people roam fairly solo and try to acquire resources to survive, or you live in a weird society where if a stranger is captured he needs to play in a game of fight to the death.  Mobility:      One foil character has a giant battle-bot-looking tank as his form of transportation through the desert. Protagonist has a car that has a plastic half bubble on top to look out from.   Robot:      The protagonist runs around in the beginning of the film with a female robot/android whose face is melted off after it has acid touch its face.(This scene happens next to the protagonist's rover)  Love interest:      Somehow protagonist comes across female protagonist in desert. She smells really bad and is hungry. They sleep outside, and he tells her to sleep away from him. He uses a thermal blanket(the first I ever saw in my life). She wakes up next to him, smelling horrible. He bathes her in some water hole they find(as if water were not scarce and they could just waste water.)   Pupa monsters:      Scene where they are in a building and they are trying to get out. They come across a room that is white, in which multiple giant, white, snot, pupa are hanging securely from the ceiling. Through curiosity, they disturb them, and now they have to get out of that room fast.  Boss Antagonist:      Pervert bionic man, that is actually attached to a giant robotic arm, as only form of movement. He is in black and has a pale bald head as his most human looking part. Stop all active ajax requests in jQuery Merging two pictures Is there a tool in Ubuntu to automatically merge two images having a common strip? I need to scan a large image, which will not fit at once in the scanner. I was thinking about scanning it in two parts and hand-editing the result in Gimp to join them. But probably an automatic tool can do the same more quickly and better.  EDIT I think I may have not made my point clear. My difficulty is not aligning two images. My problem is that one has to compensate for the rotation or distortion introduced by the manual process of putting the sheet into the scanner, and an automatic tool should obtain more precise results at analyzing common patterns in the two images to rotate and align them seamlessly. I am getting the following error in the top menu bar:     An error occurred.Please run the Package Manger form the right-click menu or apt-get in a terminal to see what is wrong.The error message was:'Error:BrokenCount>0'.This usually means that your installed packages have unmet dependencies. Is there a command to delete all the files in a directory that haven't been modified in N days?  I need to clean up some old logs. $$A=\begin{array}{ccc} 0 &amp; 1/2 &amp; 0 &amp; \cdots &amp; 0 \\ 1/2 &amp; 0 &amp; 1/2 &amp;\cdots&amp; 0\\ 0 &amp; 1/2 &amp; 0 &amp; \cdots &amp; 0\\ \vdots &amp; \vdots &amp; \vdots &amp;\ddots &amp; 1/2\\ 0 &amp; 0 &amp; 0 &amp; 1/2 &amp; 0 \end{array}$$  I need to know the spectral radius of $A$ in function of the dimension of the matrix $n$. I know only one way to know the spectral radius, using the definition I find all eigenvalues and then find the maximum. but it very hard if $n$ is changing. Some help please!  I did some iteration by   $$det(\lambda I-A)$$  $$n=2 \quad r=\frac{\sqrt{1}}{2}$$ $$n=3 \quad r=\frac{\sqrt{2}}{2}$$  for $n=2$ and $n=3$ are correct.  and if we take this rule, for   $$n=5\quad \quad r=\frac{\sqrt{4}}{2}$$  but this isn´t true since I know radius for this matrix should be $&lt; 1$ and if we take this rule  for $n=5$ we have  $$\frac{\sqrt4}{2}=1$$   Some hint? How can I block all ports except some? I am trying to use iptables but I am clueless in understanding the documentation even so that I've locked myself out of my server twice already whilst trying to implement it.  These are the simple rules that I want to implement:   Allow ports 80, 6667 and 6697 to everyone Allow port 22 to just my IP for example 10.10.10.10   Please can someone help me implement these simple rules, without locking myself out? Does Blender have different languages (language as in speech language as english, not computer language as python)? Sometimes it's more convenient for me to use Blender in another language. Does Blender have different languages (language as in speech language as english, not computer language as python)? I was wondering how light or any electromagnetic radiation can be "absorbed" if it consists of electric and magnetic fields. For example if there is a charge at point A, and the  light reaches point A, it will cause that charge to move depending on the value of the electric field. However, why wouldn't this electric field continue on and influence others particles everywhere else? For example, if you have a static charge creating an electric field, then if you put a charge at point A it will feel its effects and then if you bring a charge at another location B it will also feel its effects, namely it will not have been absorbed. Please shed some light on this. Thanks  edit: Does this mean the electron that absorbs this light moves in such a way that it creates an electric field of its own canceling the initial one? Or am I way off? Why is Apache executing .php.html files as PHP? I have an odd problem...I'm using a documentation generator which generates a lot of output like docs/foo.php.html. It's XHTML, and thus contains &lt;?xml...&gt; tags at the beginning of file. The problem is, Apache has somehow decided to run it through the PHP interpreter, even though ".php" appears in the middle of the filename, and not at the end. This, in turn, triggers a PHP error, because it sees "&lt;?" as the command to start executing PHP code, and immediately gets confused by the "xml..." which follows it.  How do I configure Apache to ONLY execute .php files and not .php.html files? The string "php.html" does not appear explicitly anywhere in my Apache config files. There is a line "AddHandler php5-script .php", but I don't see how that would also include ".php.html" files. GUI to CLI command translator Is there any application (or sequence of commands) for this function: seeing the result of the actions, while using a GUI interface, being automatically translated into a Terminal (or similar CLI environment) on the same machine.  I saw this in action long years ago in VBA for Applications (for example the Macros in Excel). I wonder if there is same function in Linux. so someone tells me i need to call a few people.  they send me a vCard called contacts.vcf.  i import it.  i open my phone app and start to dial, but wait...i don't know their names.  How do i look up a recent vCard on my phone?  How do i know who's contact i've been sent?  when i navigate to a .vcf file, i can't open it.  all i can do is import it.  polaris office won't import/open it.  is there an android txt editor i can use to peruse a vCard?  yours truly, Confused by vCards Note 3, kit kat How to Remove URLs from Google Search Engine I have used so many things like url removal request and deleted the pages etc., but still the errors are shown in my webmaster tools.  How can I remove the urls completely from Google? I am fairly sure that I understand the how Monte Carlo integration works but I am not understanding the formulation of how it is used to estimate Pi.  I am going by the procedure outlined in the 5th slide of this presentation   I understand the preliminary steps.  Pi is equal to 4 times the area of a quarter of the unit circle.  And the area of the top-right quarter of the unit circle centered at (0,0) is equivalent to the integral of the curve that is the top-right quarter of the unit circle in $0&lt;x&lt;1$ and $0&lt;y&lt;1$.    What I don't understand is how this integral is  $\iint I((x^2+y^2)&lt;1)P(x,y)dxdy$  where $P(x,y)$ is uniformly distributed in the unit square around the quarter circle (i.e. it is always equal to 1 if $0&lt;x&lt;1$ and $0&lt;y&lt;1$ and 0 otherwise).  So this would mean that  $I((x^2+y^2)&lt;1)P(x,y)$ is the function that is the top-right quadrant of the unit circle at $0&lt;x&lt;1$ and $0&lt;y&lt;1$ but I do not understand how this is true since the indicator function can only be 1 or 0.  I understand that it is probably written in this way to make Monte Carlo sampling easy (i.e. it is an expectation so just sample from $P(x,y)$ and get the average of the samples applied to $I((x^2+y^2)&lt;1)$) but it just does not make intuitive sense to me why that integral represents the area under that curve.  Could someone provide an intuitive explanation of this.  Maybe show how that integral was derived in a step-by-step way?  EDIT:  I was able to gain a better understanding by relating the expectation to an area.  I will explain it here in case it helps anyone.  First start with relating Pi to the area of the top-right quadrant of the unit circle  $\pi=4\times A_{tr}$  Then we place the top-right quadrant into the unit square.  And under a uniform distribution over the unit square, the area of the circle quadrant is proportional to the probability of obtaining a sample from it.  It follows that the following equality holds  $P(x^2+y^2&lt;1)=\frac{A_{tr}}{A_{square}}$  and $A_{square}=1$ so  $P(x^2+y^2&lt;1)=A_{tr}$  And substituting into the original equation  $\pi=4\times P(x^2+y^2&lt;1)$  and it is also true that $P(x^2+y^2&lt;1)=E[I(x^2+y^2&lt;1)]$ which is equal to the original double integral.  So I understood it by relating the area to a probability then relating that probability to an expectation that is equivalent to the integral.  Let me know if I have made any mistakes. Who are the 3 men who would have a chance against Jaime Lannister in a sword fight? In Game of Thrones season 2, episode 8, "The Prince of Winterfell" , Jaime Lannister says to Brienne:     There are three men in the kingdoms who might have a chance against me [in a sword fight]   Who are those three people?                                  I don't believe this quote, or any variation, appears in the books. There was this quote from A Storm of Swords when he is fighting Brienne:     She is stronger than I am.      The realization chilled him. Robert had been stronger than him, to be sure. The White Bull Gerold Hightower as well, in his heyday, and Ser Arthur Dayne. Amongst the living, Greatjon Umber was stronger, Strongboar of Crakehall most likely, both Cleganes for a certainty. The Mountain’s strength was like nothing human. It did not matter. With speed and skill, Jaime could beat them all.   So in the books it suggest that Jaime can beat anyone, though he is only referring to people of great strength, not necessarily of great skill (somebody such as Barristan Selmy, who is not considered to be exceptionally strong but is exceptionally skillful, may be able to beat him).  Is there any canon evidence to suggest who these three people may be?  I won't accept any purely speculative answers. However if there is no direct canon quote answering the question (which I believe to be the case) I will consider answers that are strongly inferred from canonical sources (such as a canon quote saying X is the greatest fighter in the kingdom, for example).