I have a formula to subtract several cells from 1 cell and I am getting a result of -2.27374E-13. The formula is D235-E235-F235-G235-H235-I235-J235, each column has a dollar value and no matter how I try to calculate it it still comes out (0.00).   D235 = 2386.16 E235 =    0.00 F235 = 1431.70 G235 =    0.00 H235 =    0.00 I235 =  954.46 J235 =    0.00
It's supposed to be zero but for some reason the result produces a peculiar series of digits at the end.  Also, here's the .xlsx of it: http://83.212.111.36/Book1.xlsx
How do the Chitauri "ships" propel themselves? In the 2012 The Avengers film, the Chitauri army arrives through the portal along with these big robot alien whale Chitauri dudes. Here's one chasing Iron Man:  These guys basically swim through the air like... giant robot alien whales. I don't see any means of propulsion. Other, more humanoid Chitauri soldiers fly around on things that seem to be mechanical &quot;speeders&quot; of sorts. What are these guys? Are they ships, creatures, or both? Is there an explanation anywhere in the Avengers universe for how they defy gravity and swim through the air? Partial SSL in rails Can anybody please help me to prove this:  Let $p$ be greater than or equal to $1$. Show that for the space $\ell_p=\{(u_n):\sum_{n=1}^\infty |u_n|^p&lt;\infty\}$ of all $p$-summable sequences (with norm $||u||_p=\sqrt[p]{\sum_{n=1}^\infty |u_n|^p}\ )$, there is an inner product $&lt;\_\,|\,\_&gt; $ s.t. $||u||^2=&lt;u\,|\,u&gt;$ if and only if $p=2$. Shell command to sum integers, one per line? I am looking for a command that will accept (as input) multiple lines of text, each line containing a single integer, and output the sum of these integers.  As a bit of background, I have a log file which includes timing measurements. Through grepping for the relevant lines and a bit of sed reformatting I can list all of the timings in that file.  I would like to work out the total. I can pipe this intermediate output to any command in order to do the final sum.  I have always used expr in the past, but unless it runs in RPN mode I do not think it is going to cope with this (and even then it would be tricky).  How can I get the summation of integers? The roots of the equation $z^n=(1+z)^n$... The complex roots of the equation      $$z^{n}=(1+z)^{n}$$   $A.$ are vertices of a regular polygon  $B.$ lie on a circle  $C.$ are collinear  $D.$ none of these  Don't know where to start.. Please help.!  NOTE:  $z$ is a complex number. How to convert from one grading scheme to another? English questions and negation with *do* in syntax MBR recovery - Corrupted MBR after it changed to dynamic & testdisk gives up . No backup sector found I had a Windows 7 installation on my 1TB SSD laptop with 4 primary partitions. I wanted to install Lubuntu Linux but the process failed with an error which kind of said:     cannot write MBR   It gave me an option to put an MBR somewhere else or to boot without MBR. None of these options worked and it became a useless install. After this failed dual boot attempt, Windows would give a BSOD wit Code 007 ending - translated to inaccessible boot device. That is a huge NTFS partition and I don't think I have any other media to back it up before formatting it.  My only option is somehow rebuilding the old MBR. Hence I started creating a whole bunch of live USB boot environments  including Super GRUB Disk and MiniTool Partition Editor Live CD, but none of this could ever help me recover my lost MBR.  Win PE 4.0 reported the partition as bad disc and the latest version did not even have an option for MBR. I managed to create a live USB with Testdisk Running on Ubuntu. Whatever partition was seen as HPFS on quick  search was written in the MBR and after this the disc is totally unreadable. Earlier I could see my data through Linux and now I can see nothing.  Here are my questions:   When some data could be read (but Windows would not boot) the MBR was shown as dynamic MBR. As far as I know dynamic MBR is a Windows concept and my Linux attempt would not have converted it. While installing Linux I tried to delete 2 primary partitions which I found to be not really useful (I backed up their data first). So I am not sure what created the dynamic MBR.  Did my dual install convert those basic MBR to dynamic MBR? How did that happen? Here is a screenshot of my deep search attempt with TestDisk which is still in progress. I can see 4 NTFS partitions and one of these two system partitions should be the original MBR. When I tried to write both these system partitions (after stopping the deep search momentarily) I got an error like "partition not found". The file system utility showed me that there is no backup sector and that may be the reason why it cannot be read.  What other Resorts do I have, other than doing a plain format and then using some recovery tool to recover all my lost data? I am not even sure I will recover the folder names.  What other options should I be trying to restore my old MBR so Windows can boot?      Update  as of last I managed to create a live USB w/ W7  I used AOMEI Partition assistant 6.0 and on deeper  search I can see the 909 gb partition - it wont let me select it for recovery. I am sorry if my earlier Q was not clear. I referred to restoring an MBR from a partition . What happened earlier  - superficial search revealed all old partitions but NOT this one   and the later partitions showed up on Deep search &amp; I can select Other partitions for recovery but for this one. It wont let me select the partition I want  Here are some more screen shots    So in summary all that happened is   4 primary windows 7 partition -->  wanted to install Linux so I deleted 2 non bootable partitions after backing them up  ended up with BSOD ( inaccessible boot device ) and noticed that some windows partitions showed up as Dynamic MBR  (using Live USB Linux,gparted )  Use standard testdisk procedure to write MBR from the superficial NTFS-HDFS partition.  this is where I screwed up . Hindsight I should have really done a deep search and caught the 901gb partition to write MBR. I am not sure if I can undo this action  after this - life gets worse. I am  on a ventilator ! Now C is unreadable by windows and linux both and testdisk cannot list file ( see screenshots ) and I have been using a series of live USB's with some recovery s/w but no luck. ALL I want is to recreate that 901gb partition and the boot partition and put the MBR on the latter so I can get my windows 7 back again Copy Physics To Multiple Objects Using the cell fracture addon, I created many objects from my mesh. I want to have a rigid body physics on all of them. How would I copy one of the fractured pieces physics to all the pieces? I tired ctrl L and the copy attributes addon, but none of them have the option. Any help is great. Fisher Information of a function of a parameter Nice looking progress bar in java Computing the Galois group of polynomials $x^n-a \in \mathbb{Q}[x]$ I have some problems with this exercise. I don't know if it can be done. Consider the polynomial $ x^n - a \in \mathbb{Q} $ Can I compute the Galois group of this over $\mathbb{Q}$? Maybe having a nice "basis.  The splitting field is given by $\mathbb{Q}(\zeta_n,\alpha)$ , where $\zeta_n$ is a primitive root of unity , and $\alpha$ is some number such that $\alpha^n = a $. Well first of all, I want a $\underline{"good basis"}$ for the splitting field. In the sense that the minimal polynomials, of the adjoined elements, are different (in this case the computation of the galois group is very simple).  For example one easy case, it's when $a&gt;0$, then $(a)^{\frac{1}{n}} \in \mathbb{R}$ , so clearly the minimal polynomial of $(a)^{\frac{1}{n}} , \zeta_n$ are distincs, and I'm done. If $n$ is odd then , it's also easy, since one root it's also real, for example $x^3-3 $, the real root is $ \root 3 \of { - 3}  =  - \root 3 \of 3  $ , so I can consider the splitting field as $\mathbb{Q}(-\root 3 \of 3 , \zeta_3 )=\mathbb{Q}(\root 3 \of 3 , \zeta_3 )$. The difficult case is when $n$ is even and $a&lt;0$ , for example  $x^8+20$ or $x^4+20$ in some cases as in the second, there are particular cases since there exist algorithms for the Galois group of quartics, but in general. It can be done?  $\underline{Remark}$ I'm searching a $\underline{"good basis"}$ for the splitting field. In the sense that the minimal polynomials, of the adjoined elements, are different since in this case the computation of the galois group is very simple. Define a new block environment in LaTeX beamer I have two kinds of examples in my document. I want to use different colors, say, red and blue. This is what I am doing now.  \documentclass[]{beamer} \usetheme{Madrid} \begin{document}  \begin{frame} \frametitle{Test} \setbeamercolor{block title}{fg=white,bg=red!75!black} \begin{block}{First Kind Example} This is example of the first kind. \end{block} \setbeamercolor{block title}{fg=white,bg=blue!75!black} \begin{block}{Second Kind Example} This is example of the second kind. \end{block} \end{frame}  \end{document}   I know this is kind of stupid. I want to define two new block environments, one for each color, so I don't need to use setbeamercolor every time I use them.   \begin{block1}{First Kind Example} ... \end{block1} \begin{block2}{Second Kind Example} ... \end{block2}   I know I need to define these two new environments in the preamble, but don't know how. Thanks for the help.  By the way, what is a good reference on these kinds of tricks in LaTeX/beamer? Any recommendations? Advantages of ROC curves What is the advantages of the ROC curves?  For example I am classifying some images which is a binary classification problem. I extracted about 500 features and applied a features selection algorithm to select a set of features then I applied SVM for classification. In this case how can I get a ROC curve? Should I change the threshold values of my feature selection algorithm and get sensitivty and specificity of the output to draw a ROC curve?  In my case what is the purpose of creating a ROC curve? I've noticed this on occasion with a variety of applications. I've often thought it was because the output was cancelled early (ctrl+c, for example) or something similar, and zsh is filling in a new line character. But now curiosity has gotten the best of me, since it doesn't seem to do this in bash.   zsh    bash    The Sequence program is something I pulled from a book while reading on Java certifications and just wanted to see if it would compile and run. I did notice that it does not use the println() method from the System.out package/class. Instead it uses plain old print().  Is the lack of a new line character the reason I get this symbol? the relationship between maximizing the likelihood and minimizing the cross-entropy Contradicting Fubini's theorem I have a function defined as follows: $f(x,y)= \dfrac{x^2-y^2}{\left(x^2+y^2\right)^2}$, if $(x,y)\neq (0, 0)$ and $f(x,y)=0$ if $(x,y)=(0,0)$.  Now, $$\int_0^1\int_0^1 f(x,y)\,\text{d}x~\text{d}y=-\frac{\pi}{4}$$ and $$\int_0^1\int_0^1 f(x,y)\,\text{d}y~\text{d}x=\frac{\pi}{4}.$$   The question I have is this: why does this not contradict Fubini's theorem?    thanks. I heard using 'could' is for politeness. When I request something, should I say "Can you please" or "Could you please"? Does the latter sound over-polite and pretentious? Solving a six-degree polynomial of the form $ax^6+bx^3+g$. I read that it is not always possible to solve but from Wikipedia:      Some sixth degree equations, such as $ax^6 + dx^3 + g = 0$, can be solved   by factorizing into radicals, but other sextics cannot.   So how do you solve this? I've stumbled upon this equation where; $a = n^2$, $d=m^2n-2p^2$, and $g=m^4$. Where the $a,d,g$ corresponds to the above mentioned sextic-equation and $m,n,p$ are input variables. I apologize for that ton of variables in use, might cause some confusion. Is this possible using Galois Theory or by any other means? Restore SQL Server 2012 backup to a SQL Server 2008 database?