This issue does not care if you format the cells to numeric or not, but formatting them to numeric with 4 or more decimal places helps you see the issue without having to look at the Formula Bar.  Cell A1: Enter 104.19  Cell B1: Enter 98.98  Cell C1: Enter =A1-B1 (it shows 5.2100)  Copy Cell C1 and paste in Cell D1 as a value. It shows 5.2099. &lt;-- WTH?  Same thing happens for: 172.89 - 164.25 167.85 - 159.46  But not for: 63.67 - 60.49 300.98 - 285.93  Additional Step: If you add or multiply Cell D1 by another value, the resulting answer is as if you added or multiplied by 5.2100, not 5.2099.
Firstly I do not want to round my numbers, I am using base 10 figures so excel should have no bother doing simple add and subtract.  A|  665.110000000000000000000000000000 B|  4.990000000000000000000000000000 C|  =a1+b1 D|  670.790000000000000000000000000000 E|  1,335.890000000000000000000000000000 F|  =e1-(c1+d1)   I should get -5 however F1  returns   -4.999999999999770000000000000000   It is a financial document therefore I want to avoid rounding, more to the point. Why should I need to? I've put cell formatting to Currency with 2 decimal placed and I will get the correct display value but for all calculations I will still get -4.9999...7 which leads to further errors with conditional formatting etc.
Are  and the  really the same thing?  Not too long ago, Susskind and Bousso uploaded the article "" with the thesis that the many-worlds interpretation and the multiverse of eternal inflation are one and the same thing. The parallel worlds of one are exactly the same thing as the parallel worlds of the other.   First, they claim decoherence can't happen over a complete description of the future light-cone of the measurement. Then, they apply that principle to eternal inflation. Without decoherence, superpositions of nucleating bubbles and metastable vacua can't decohere. According to the anthropic principle, most bubbles have no conscious observers, but an exponentially small minority do. Apply black hole complementarity to causal horizons.  Then, somehow, in a way I can't follow, they combine causal diamond worlds into a global multiverse.  Then they claim decoherence is reversible.  My head is spinning. What are your opinions on this paper? Another domain name pointing to my server IP? I was checking out my reverse-DNS entry of my domain the other day which is run from a dedicated server.   I noticed that another person/company had their domain pointing to my server? I have no idea who this company is or why they are pointing their domain at my server IP?  How can I go about stopping this or forcing them to change? Beryllium Vacuum Sphere Boat/Aircraft Is it possible to make a solid rigid evacuated "balloon" out of Beryllium or other elements or alloys?  The critical buckling pressure at which an evacuated sphere is given as $$ P_1=\frac{2E\cdot\left(h/R\right)^2}{\sqrt{3\left(1-\nu^2\right)}} $$ where $E$ is , $h$ the shell's thickness, $R$ the radius to the midsurface shell, and $\nu$ is .  Of course this is theoretical and experimental and literature values for submersibles hover around 1/4 of the theoretical pressure.  Beryllium has the following properties:   Density=1.85 g/cm$^3$ Young's Modulus=287*10$^9$ Pa Poisson Ratio=0.032   Calculating the upward force, buoyancy at 101.3 kPa atmospheric pressure and Radius of 10m gives 4.24*10$^8$ N. The weight of this sphere with shell thickness 1mm has 2.32*10$^7$ N downward force of Beryllium material, so it will theoretically float at ground level.   Calculating the critical buckling stress of this beryllium sphere is 331.57 kPa, which is 3.27 times the atmospheric pressure of 101.3 kPa, so theoretically it won't buckle. But in experimentation done in earlier experiments as stated before, due to construction/material non-ideal situations, the critical buckling formula predicts about 4 times stronger than actual, so it would need about 400 kPa, not 331 kPa as Beryllium sphere with this specification would hold. Increasing the strength capability also increases weight and therefore lowers it's ability to float, but Beryllium is the closest element with this situation I have calculated that could work if ideal (I have only been using periodic table elements and household materials)  Is it possible with an alloy of elements? Using the equations for buckling and buoyancy, the following is needed. What alloys/materials come to your mind?  Material considerations:   Material with larger Poisson ratio Material with larger Young's Modulus Less dense material Construction (is it possible)   Material considerations affect on lift   Thickness can be larger, increases strength by the squared. But also increases weight. If a material with lower density with similar structural properties as Beryllium is used, it would help. Radius can be lower for same reason, but also lowers buoyancy (volume)   My other designs (don't worry about these just yet, just if you are curious is a vacuum sphere with a pressurized "outer tube" with spokes in tension (carbon fiber nanotubes maybe) to keep the 2 spheres in position. Another is a spherical truss out of carbon fiber nanotubes with a light membrane around. The truss prevents the outer membrane from collapsing due to the atmospheric pressure  The "point" of this if you ask, as to why not use a traditional balloon is it can be used as a boat by filling the sphere with air, and then used as a aircraft at will by evacuating the sphere. An alternative mode of transportation for sea vessels etc. Avoiding GeoServer/Java out of heap space error? I'm new to Geoserver, Ubuntu and Java, but have downloaded a virtual machine from gisvm.com and am getting up to speed. I got as far as configuring it with some fairly large shapefiles from a project I've worked on previously.  My question is related to a problem which I see if I show the shapefile using the OpenLayers layer preview option. I see an error:     OpenLayers map preview code="internalError" Rendering process failed.   java.lang.OutOfMemoryError: Java heap space   Googling has led me to plenty of Java command line options to increase heap space, but I have no idea if this should be applied to an environment variable, in a startup script or as a part of the Geoserver config.   Can you help me to understand what I need to edit to get this working?   I'm also wondering if I should be splitting my shapefile into smaller pieces. Is there a way to show the history of packages that were changed by apt-get via command line? Limits of sequences of sets I am starting to learn about the liminf and limsup of a sequence of sets. However, I do not understand the very basics, such as why $\lim\sup A_n=\bigcap_{n\in N}\bigcup_{k&gt;n} A_k,$ and why $\lim\sup A_n=\bigcup_{n\in N}\bigcap_{k&gt;n}A_k.$ Can someone break these definitions down for me?  Also, why is $\lim\inf\subseteq\lim\sup$? Why does the field of an electric dipole drop off as $1/r^3$? Electric field of a point charge drops off inverse squarely but that of a dipole varies as $1/r^3$. Why the field drops off more quickly for a dipole? How to calculate the number of days you can stay in Taiwan on a tourist visa? Tourist visas to Taiwan have an associated "maximum stay" of 30 days. For those visas, how are the days counted? Does the stay begin on the partial day that the traveler arrives or the first full day spent in the country? Does it end on the last full day spent in the country, or the actual day the traveler departs? What do I if I used "Reset All" or "Erase All Content and Settings" on a jailbroken iOS Device? I recently received an iOS device and it was jailbroken. When I wanted to unjailbreak it, I used "Erase All Content and Settings." The loading screen came on and it has not changed. After rebooting the device, it is now stuck at the Apple logo. What should I do? R code to solve for probability of normal distributions? I don't understand which R code I am supposed to be using to figure these problems out. I brief explanation of what the code is doing would be amazing. The problems below are two different applications I'm expected to understand and I don't get either. Thank you!  Problem 1. Let Z~N(0,1) For each of the following, find c such that the equation is true.   a) P(Z&lt;c) = 0.8413  b) P(0&lt;Z&lt;c) = 0.3051  c) P(-c&lt;Z&lt;c) = 0.8664   Problem 2. X~N(3,4) compute  a) P(X&gt;3)  b) P(1&lt;X&lt;8)  c) P(-1.5&lt;X&lt;1) Can ordered list produce result that looks like 1.1, 1.2, 1.3 (instead of just 1, 2, 3, ...) with css? What content type to force download of text response? I need to stream a file to the Response for saving on the end user's machine.  The file is plain text, so what content type can I use to prevent the text being displayed in the browser? Dispatcher.BeginInvoke: Cannot convert lambda to System.Delegate How to specify font size less than 10pt (or more than 12pt)? Iridescence In Cycles? Is it possible to create an  shader in Cycles? Specifically for something like , , , etc.. I have a polygon shapefile of many lakes, I also have a point shapefile of locations on those lakes where fish were caught.  The point shapefile contains the attributes: Fisherman_iD, Fish_Caught, Lat, Long.  The polygon shapefile contains the attributes Lake_name, Points_per_polygon(PNTCNT)  Each point obviously has differing entries under the fish_caught field.   What I want to get is the average fish caught per lake (polygon).  So I need to have a total number of fish caught, per individual polygon, and then I can divide that by the PNTCNT file I create using the Points in a Polygon tool.  Ideas? I am relatively new to QGIS. What is the typical post processing work flow for amateur photographers? I love photography; I hate postprocessing.  Seeing that I am an amateur, not just by virtue of not getting paid for it, but also being rather new to the whole affair, I already am used to most of my shots just not being that great. While reading blogs and websites I get the impression that condensing ~100 frames in maybe a handful of shareworthy photos is not rare.  But even so, after a vacation quite a few photos have accrued. What is a common workflow to sort, post-process and share photographs for a beginner? What are common postprocessing steps? What kind of automations do people use?    Edit: I phrased the question generically so that it can be of use to as many people as possible. But I understand that without anything to go by, it might be a bit hard to answer. Therefore, while I own no paid-for software, this is what I use:   I have an EOS 500D crop camera as picture source and I use  for development,  for any touching up I need to do. (Which is not much, so far.)  (in a VM) is my photo catalog. My destination is my Flickr stream for the most part, sometimes I send photos directly to family and friends.   On the input side, I mostly am in practice mode; shooting whatever I can place in front of my lens. I have not yet picked a specialty. I would like to minimize time spent fine-tuning photos in software. These sort of "batch processes" are a part I realize is important, but not much fun to me.  I am quite computer-literate, so I am not afraid of piecing together tools that can be of use, but the more "" this can be, the more people who don't spend their life in front of a PC can benefit too. :) If spending money on something will make my life easier, I am quite willing to consider it. However as photography does not bring any income, something as large as Photoshop (for example) is somewhat hard to justify as an investment. How to make a bootable ISO image from a bootable DVD? What is the cardinality of the set of all topologies on $\mathbb{R}$? This was  on Quora. I thought about it a little bit but didn't make much progress beyond some obvious upper and lower bounds. The answer probably depends on AC and perhaps also GCH or other axioms. A quick search also failed to provide answers. How to make X.org listen to remote connections on port 6000? This is on Ubuntu 10.10 (Maverick Meerkat) 64-bit desktop.  I want to make my X server listen to remote connections from clients in other machines on the local network. I know about ssh -X and that is not what I want. I vaguely remember changing something like TCPListen from no to yes, but I don't remember where this change should be applied.  I'm interested in either a GUI method or a CLI one.  PS editing /etc/X11/xinit/xserverrc to remove the -nolisten tcp option and rebooting does not work.