{"id":185,"date":"2007-10-18T14:42:42","date_gmt":"2007-10-18T14:42:42","guid":{"rendered":"http:\/\/snee.wordpress.com\/2007\/10\/18\/corina-vs-excel\/"},"modified":"2007-10-18T14:42:42","modified_gmt":"2007-10-18T14:42:42","slug":"corina-vs-excel","status":"publish","type":"post","link":"https:\/\/sneesh.com\/?p=185","title":{"rendered":"Corina vs. Excel"},"content":{"rendered":"<p>Oh I know everyone who reads this is aware who Corina is&#8230;my co-worker and the person who single handedly ensures mucho hilarity in the workplace \ud83d\ude42<\/p>\n<p>Well, today she didn&#8217;t fail to (almost) make me wet myself laughing&#8230;<\/p>\n<p>It all started on Thursday last week &#8211; she was wanting to close off the accounts for the end of September (our year end too) and was having trouble balancing the totals &#8211; she was 5p out.<\/p>\n<p>Now, personally, I&#8217;d have just shrugged and written it off, but for some reason Corina thought she&#8217;d find it. And so Thursday, Friday and Monday she tried &#8211; to no avail.<\/p>\n<p>This morning, I (being the helpful soul I am) asked if there was anything I could do to help. &#8220;Yes,&#8221; she says &#8220;&#8216;If you wouldn&#8217;t mind adding these figures to make sure I didn&#8217;t total them wrong.&#8221;<\/p>\n<p>So I fire up Excel and enter the figures &#8211; credits, debits and total them &#8211; getting the correct figure.<\/p>\n<p>\ud83d\ude42<\/p>\n<p>Now when I tell Corina, she doesn&#8217;t believe me, so I print off the page. She checks the list of figures and can&#8217;t work out why she has a different total.<\/p>\n<p>Did I mention I&#8217;m a helpful chap? well, I tell her to give me her list and I&#8217;ll compare it to mine.<\/p>\n<p>Within 10 seconds of me getting her list I said &#8220;I&#8217;ve solved your problem&#8230;&#8221;<\/p>\n<blockquote><p>&#8220;What was it?&#8221; says Corina.<br \/>\n&#8220;Well, you never specified Excel to treat the columns as having 2 decimal places, so it&#8217;s rounded up the total.&#8221;<\/p><\/blockquote>\n<p>I then formatted her columns as 2 decimal places and lo and behold &#8211; the correct figure appeared.<\/p>\n<p>Poor girl didn&#8217;t know whether to thank me or cry&#8230;<\/p>\n<p>Bless her.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oh I know everyone who reads this is aware who Corina is&#8230;my co-worker and the person who single handedly ensures mucho hilarity in the workplace \ud83d\ude42 Well, today she didn&#8217;t fail to (almost) make me wet myself laughing&#8230; It all started on Thursday last week &#8211; she was wanting to close off the accounts for the end of September (our year end too) and was having trouble balancing the totals &#8211; she was 5p out. Now, personally, I&#8217;d have just shrugged and written it off, but for some reason Corina thought she&#8217;d find it. And so Thursday, Friday and Monday [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-185","post","type-post","status-publish","format-standard","hentry","category-ramblings"],"_links":{"self":[{"href":"https:\/\/sneesh.com\/index.php?rest_route=\/wp\/v2\/posts\/185","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sneesh.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sneesh.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sneesh.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sneesh.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=185"}],"version-history":[{"count":0,"href":"https:\/\/sneesh.com\/index.php?rest_route=\/wp\/v2\/posts\/185\/revisions"}],"wp:attachment":[{"href":"https:\/\/sneesh.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=185"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sneesh.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=185"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sneesh.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}