{"id":2443,"date":"2006-09-08T17:41:52","date_gmt":"2006-09-09T01:41:52","guid":{"rendered":"http:\/\/www.inmff.net\/peidm2\/2006\/09\/08\/my-faith-in-excel-is-shattered\/"},"modified":"2006-09-08T17:41:52","modified_gmt":"2006-09-09T01:41:52","slug":"my-faith-in-excel-is-shattered","status":"publish","type":"post","link":"https:\/\/www.inmff.net\/peidm\/2006\/09\/08\/my-faith-in-excel-is-shattered\/","title":{"rendered":"My Faith in Excel is shattered"},"content":{"rendered":"<p>Anyone who has known me for long enough knows that while I&#8217;m no fan of Microsoft I love Microsoft Excel.  I&#8217;ve long believed it is the best written Microsoft product.<\/p>\n<p>My faith in Excel just got smashed.<\/p>\n<p>So I took a list of numbers from a CSV file that should add up to 0.  (If you must know I&#8217;m mucking with a bill from a service provider thats all fucked up.  They missed giving me the proper credit, so I&#8217;m detailing for them what the additional credits should be, so we should get to a zero sum.)<\/p>\n<p>For those of you who want to check up on my the initial list is:<br \/>99.9<br \/>0<br \/>3.52<br \/>3.24<br \/>0.02<br \/>1.24<br \/>0.26<br \/>5.94<br \/>-0.23<br \/>-0.02<br \/>-2.87<br \/>-1.1<br \/>-3.12<br \/>-88.62<br \/>-5.27<br \/>-0.03<br \/>0<br \/>-0.37<br \/>-0.14<br \/>-0.4<br \/>-11.28<br \/>-0.67<\/p>\n<p>So when I add this list up I get 0.00.  Excel gets -0.00000000000001609823385706480.  I even tried the other way round this and did two intermediate sums where I got 12.89 and -12.89, which Excel Adds up to -0.00000000000001598721155460230.  <\/p>\n<p>I can&#8217;t figure out what the hell is going on, although I have checked every number to make sure there isn&#8217;t a some rounded number being displayed with two digits..  So I&#8217;m stumped, and my faith is shattered.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anyone who has known me for long enough knows that while I&#8217;m no fan of Microsoft I love Microsoft Excel. I&#8217;ve long believed it is the best written Microsoft product. My faith in Excel just got smashed. So I took a list of numbers from a CSV file that should add up to 0. (If [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2443","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.inmff.net\/peidm\/wp-json\/wp\/v2\/posts\/2443","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmff.net\/peidm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmff.net\/peidm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmff.net\/peidm\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmff.net\/peidm\/wp-json\/wp\/v2\/comments?post=2443"}],"version-history":[{"count":0,"href":"https:\/\/www.inmff.net\/peidm\/wp-json\/wp\/v2\/posts\/2443\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inmff.net\/peidm\/wp-json\/wp\/v2\/media?parent=2443"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmff.net\/peidm\/wp-json\/wp\/v2\/categories?post=2443"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmff.net\/peidm\/wp-json\/wp\/v2\/tags?post=2443"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}