I have an excel file which gets generated from various database servers on fly by executing sql. Separate sheet gets generated for each server. Now I simply want to combine data of all sheets. Each sheet has same number of columns and headings. In combined sheet heading should appear at top only once.   For e.g North sheet  Sales Person | Item | Quantity | Sales | James | Ball | 100 | 2000| Jack | Bat | 50 | 100 | James | Bat | 25 | 50 |    South sheet Sales Person | Item | Quantity | Sales | Sara | Racket | 100 | 2000| Lucy | Ball | 50 | 100 | Sara | Racket | 25 | 50 |    Combined sheet    Sales Person | Item | Quantity | Sales | James | Ball | 100 | 2000| Jack | Bat | 50 | 100 | James | Bat | 25 | 50 | Sara | Racket | 100 | 2000| Lucy | Ball | 50 | 100 | Sara | Racket | 25 | 50 |
I have hundreds of excel files which are all of the same format (i.e. 4 worksheets per Excel file). I need to combine all the files into 1 all singing and dancing file which must have the same format as the originals (i.e. maintain the four separate worksheets, which are all identically named).  While each file is structured the same, the number of columns (and the heading names) between sheet 1 and 2 (for example) is different. So it can’t be combined into one file with everything in one sheet!  There are two complications:   I need to create an EXTRA column in the merged file (on EACH sheet) to identify the source file (“file name”). The files contain a lot of zero data entries (e.g. 55 rows of useful data followed by hundreds of rows of zeros) which I need to remove from the merged file.   I’ve never used VBA, but everyone has to start somewhere I suppose.
Is there a service that I can use to check if my machine will be able to run a certain game? I tried to add a new repository to software sources, but "add source" button is unavailable. I can't click on it.  I also tried to add a new software source from the terminal, but it didn't work.  sudo‬‬ ‫‪add-apt-repository‬‬ ‫‪ppa:n-muench/burg‬‬   s‫‪udo‬‬: command not found     I also tried these commands:  ‫‪sudo‬‬ ‫‪add-apt-repository‬‬ ‫‪deb‬‬ ‫‪http://ppa.launchpad.net/n-muench/burg/ubuntu‬‬ natty‬‬ ‫‪main‬‬   sudo‬‬: command not found Determine $\text{Aut}(S)$ where $S = \mathbb{Q}[x]/(x^2)$ Here's the problem: if $S = \mathbb{Q}[x]/(x^2)$, compute the group  of automorphisms $\mbox{Aut}(S)$.   First off, I have the solution and I know it's isomorphic to the multiplicative group $\mathbb{Q}\backslash\{0\}$, so I'm trying to understand it. It uses what is called the substitution principle and the fact that the restriction of any endomorphism $\phi: \mathbb{Q}[x]\to \mathbb{Q}[x]$ to $\mathbb{Q}$ is the identity. It says that these two facts implies that the endomorphisms of $\mathbb{Q}[x]$ are in 1-1 correspondence with $h \in \mathbb{Q}[x]$, where the endomorphism corresponding to $h$ is $\phi_h : \mathbb{Q}[x] \to \mathbb{Q}[x]$ given by $\phi_h(f) = f(h)$ for $f \in \mathbb{Q}[x]$. I guess I just don't understand how it applied the substitution principle? It's probably obvious, but for some reason I am not getting it.  An explanation would be greatly appreciated! Or if you have a different solution, that'd be cool too. Thanks!! Show that $d(z,a)=|\frac{z-a}{1-\overline{a}z}|$ is a metric on the unit disk For any $z, a$ in the open unit disk, we define$$d(z,a)=\left \vert \frac{z-a}{1-\overline{a}z} \right \vert$$  Show that $d$ is a metric on the open unit disk.     It is easy to show $d(z,a)=d(a,z)$ and $d(z,a)=0$ $\rm iff$ $z=a$. However, I am having trouble showing that it satisfies triangle inequality. Any help would be appreciated! using gedit through ssh connection - should I have gedit installed on the server? I wanted to try out using graphical tools over ssh. Just to learn a new thing :)  so my understanding is this, I connect like this: ssh -port -x user@server  But I'm running ubuntu server so it has no gui and thus no gui tools. My understanding is I've to install gedit on server. But also xserver?  Can someone clear up this concepts to me? I lost my house in minecraft. How can I find it? I was in creative mode on minecraft PE. I made this really awesome house plus a hotel! I was finishing up my house but decided to explore first. I explored for about 10 minutes and then stopped. Suddenly, I started worrying because I didn't know where I was. I couldn't find my house on a map, a compass, and I didn't make a beacon or keep track of what side of the sun it was on either. How can I find my house again??? how to plot two graphs in a single sheet? I am new to Latex. Cann some one tell me how can I plot two graphs in a single page and How can resize the legend. I have attached the picture how the legend looks. I need it out from the plot and how can i have gridded lines in the plot. Please help me. My code is as follows: \documentclass[12pt, a4paper]{report} \usepackage{filecontents,pgfplots}  \begin{filecontents}{mydata.dat} m0_FEED, AT 773.15K, AT 823.15K, AT 873.15K, AT 923.15K, AT 973.15K 0.005, 1.30E+04, 12959.71536,12959.71536,12959.71536,12959.71536 0.007, 1.81E+04, 18145.78478,18145.78478,18145.78478,18145.784 0.009, 2.33E+04, 23333.9541,23333.9541,23333.9541,23333.9541 0.011, 2.85E+04, 28524.71381,28524.71381,28524.71381,28524.71381 0.013, 3.37E+04, 33718.48576,33718.48576,33718.48576,33718.48576 0.015, 3.89E+04, 38915.61947,38915.61947,38915.61947,38915.61947 0.017, 4.41E+04, 44116.39602,44116.39603,44116.39603,44116.39603 0.019, 4.93E+04, 49321.02848,49321.02848,49321.02878,49321.02849 0.021, 5.45E+04, 54529.67237,54529.67238,54529.67238,54529.67238 \end{filecontents}  \begin{document}   \pgfplotstableread[col sep=comma]{mydata.dat}{\mydata} \begin{tikzpicture}[scale=1.8] \begin{axis}[minor tick num=1, xlabel=Degrees, ylabel = temperature] \addplot [black,very thick] table [x={m0_FEED}, y={AT 773.15K}] {\mydata}; \addplot [red,very thick] table [x={m0_FEED}, y={AT 823.15K}] {\mydata}; \addplot [blue,very thick] table [x={m0_FEED}, y={AT 873.15K}] {\mydata}; \addplot [green,very thick] table [x={m0_FEED}, y={AT 923.15K}] {\mydata}; \addplot [dashed,yellow,very thick] table [x={m0_FEED}, y={AT 973.15K}] {\mydata}; \legend{AT773.15K, AT823.15K, AT873.15K, AT923.15K, AT973.15K} \end{axis} \end{tikzpicture}  \begin{filecontents}{mydatax.dat} m0_FEED AT 773.15K  AT 823.15K  AT 873.15K  AT 923.15K  AT 973.15K 0.005   4.06E+03    4601.511738 5147.966831 5703.120845 6267.035737 0.007   5.69E+03    6439.241858 7204.278989 7981.494608 8625.923 0.009   7.31E+03    8274.205759 9257.824928 10257.10215 11272.14896 0.011   8.92E+03    10105.75535 11307.95656 12529.29539 13769.90815 0.013   1.05E+04    11933.33165 13354.1149  14797.51533 16263.69405 0.015   1.21E+04    13756.46929 15395.83457 17061.29661 18753.04129 0.017   1.37E+04    15574.79159 17432.7389  19320.26254 21237.57317 0.019   1.53E+04    17388.009   19464.53834 21574.12348 23717.00014 0.021   1.69E+04    19195.90581 21491.01717 23822.664   26191.10653 \end{filecontents}  \pgfplotstableread{mydatax.dat}{\mydatax} \begin{tikzpicture}[scale=2] \begin{axis}[minor tick num=1, xlabel=Degrees, ylabel = temperature] \addplot [black,very thick] table [x={m0_FEED}, y={AT 773.15K}] {\mydatax}; \addplot [red,very thick] table [x={m0_FEED}, y={AT 823.15K}] {\mydatax}; \addplot [blue,very thick] table [x={m0_FEED}, y={AT 873.15K}] {\mydatax}; \addplot [green,very thick] table [x={m0_FEED}, y={AT 923.15K}] {\mydatax}; \addplot [dashed,yellow,very thick] table [x={m0_FEED}, y={AT 973.15K}] {\mydatax}; \legend{AT773.15K, AT823.15K, AT873.15K, AT923.15K, AT973.15K} \end{axis} \end{tikzpicture}   \end{document} Why is the gravitational force always attractive? Is there another way to explain this without the curvature of space time?   PS: If the simple answer to this question is that mass makes space-time curve in a concave fashion, I can rephrase the question as why does mass make space-time always curve concavely? Static posts page with home.php For my website, I am using a static home page page Home (template front-page.php) and for posts- page News (template home.php)  I need to show all the post titles and exceprts on that page News (templ. home.php), but also show the original title and the_content from that page News itself.  This code below while statement shows all the posts, which is good, but the top the_title also shows the title from the first post, not from the News page itself.  How to achieve what I need?  &lt;?php get_header(); ?&gt;      &lt;?php     the_title();           the_content();     ?&gt;  &lt;?php if(have_posts()) while(have_posts()) : the_post(); ?&gt;          &lt;?php         the_title();         ?&gt;          &lt;?php         the_content();         ?&gt;      &lt;?php     endwhile;     ?&gt;    &lt;?php get_footer(); ?&gt; Using sed with an integer variable I want to sed using a variable.  For example, sed -n '1,10p' file. So, instead of 10, I want to use $k where k is an integer. The rules of Transfiguration: examples of making the inedible edible? Information from the official website of J.K.Rowling is generally considered canon. I remember at least one case when she 'changed her mind' after a particular rule has been  published on her website (what happens with a secret if a Secret Keeper dies). Nevertheless, the information from the website can generally be considered reliable.  A rather obscure piece of information is J.K.Rowling's Wizards' Ordinary Magic and Basic Aptitude Test () published on her website in 2007 and now accessible with a Time Turner.   In particular, we know that only one of the following options is correct (as the software allows you to choose only one option):     Which of the following is CORRECT?            a. Food can be conjured out of thin air.       b. Any object can be Transfigured into food.       c. Foodstuffs can be increased, Transfigured, summoned from a distance and magically cooked.       d. It is impossible to make the inedible, edible.   e. Food-related Charms are some of the simplest forms of magic.      W.O.M.B.A.T. Grade 3, 13 June 2007, question 8   The test appeared on J.K.Rowling's website before the release of Book 7, but we can almost safely assume that there was no time for J.K.Rowling to change her mind after compiling the test (though she must have submitted these questions weeks before they were eventually published).  As Hermione explained in Harry Potter and the Deathly Hallows:      Your mother can’t produce food out of thin air, no one can. Food is the first of the  to . It’s impossible to make good food out of nothing! You can Summon it if you know where it is, you can transform it, you can increase the quantity if you’ve already got some...   It means that the correct option is c, and therefore all other statements are false. So, apparently, you can make food out of something else, though not any object can be transfigured into food. Can you come up with any example of such transformation mentioned in the books? How to insert the content of a file into another file before a pattern (marker)? File1 contents:  line1-file1      "1"  line2-file1      "2" line3-file1      "3"  line4-file1      "4"    File2 contents:  line1-file2     "25"   line2-file2     "24"   Pointer-file2   "23"   line4-file2     "22"  line5-file2     "21"   After the execution of perl/shell script, File2 content should become:  line1-file2     "25"   line2-file2     "24"  line1-file1      "1"  line2-file1      "2" line3-file1      "3"  line4-file1      "4"  Pointer-file2   "23"  line4-file2     "22"  line5-file2     "21"   i.e  paste the contents of File1 in File2 before the line that contains "Pointer". How to detect Windows 64-bit platform with .NET? In a  2.0 C# application I use the following code to detect the operating system platform:  string os_platform = System.Environment.OSVersion.Platform.ToString();   This returns "Win32NT". The problem is that it returns "Win32NT" even when running on Windows Vista 64-bit.  Is there any other method to know the correct platform (32&nbsp;or 64&nbsp;bit)?  Note that it should also detect 64&nbsp;bit when run as a 32&nbsp;bit application on Windows 64&nbsp;bit. Do subdomains help/hurt SEO? If I have example.com, and blog.example.com, do search engines see those as one site or two? Will using subdomains hurt SEO? I have some technical reasons why I can't use example.com/blog. Started new job. Rollover previous employer 401k to new 401k, IRA or Roth IRA? I recently started a new job and have a 401k from my previous employer that I don't know what to do with.  Should I roll it into my new employer's 401k, a traditional IRA or a Roth IRA? how to add xsl attribute Is there a Stack Exchange site for architecture? Show that the function $g(x) = x^2 \sin(\frac{1}{x}) ,(g(0) = 0)$ is everywhere differentiable and that $g′(0) = 0$ Can't execute terminal commands: "the command 'sudo' is available in '/usr/bin/sudo'" The following exercise comes from Fulton's Algebraic Curves:     Let $k$ be an infinite field and $V = \{(t,t^2,t^3) \, ; \, t \in k \} \subset \mathbb{A}^3(k)$. Show that $V$ is algebraic and compute $I(V)$ by giving a finite set of generators.   Now, showing $V$ is algebraic is easy by noting that $V = V(X^2-Y, X^3-Z)$, but I can't find a way to describe $I(V)$ explicitly. Obviously $(X^2-Y)(X^3-Z) \in V$, but how can I find the actual generators of this ideal?