Here is part 2 in my series about the Microsoft Excel Addition Bug. I demonstrate 2 ways of working around the problem.<\/p>\n
<\/iframe><\/p>\n<p>Please watch\u00a0the <a href=\"http:\/\/www.itguaranteed.com.au\/blog\/index.php\/excel-addition-bug-video\/\">Microsoft Excel Bug video<\/a>\u00a0first so that you know what the heck I am talking about.<\/p>\n<h2>\u00a0Transcript of\u00a0Microsoft Excel Addition Bug Workaround<\/h2>\n<p>1<br \/>\n00:00:00,972 –> 00:00:02,483<br \/>\n– Good day, I’m Jay Burleigh<\/p>\n<p>2<br \/>\n00:00:02,483 –> 00:00:04,625<br \/>\nand have I got a workaround for you.<\/p>\n<p>3<br \/>\n00:00:04,625 –> 00:00:07,625<br \/>\n(slow techno music)<\/p>\n<p>4<br \/>\n00:00:13,826 –> 00:00:17,071<br \/>\nHi, I’m Jay Burleigh<br \/>\nfrom the Excel bug video.<\/p>\n<p>5<br \/>\n00:00:17,071 –> 00:00:19,465<br \/>\nWhat, you haven’t seen it yet?<\/p>\n<p>6<br \/>\n00:00:19,465 –> 00:00:22,500<br \/>\nStop, go back, and have<br \/>\na look at it first.<\/p>\n<p>7<br \/>\n00:00:22,500 –> 00:00:23,792<br \/>\nYou’ll be glad you did.<\/p>\n<p>8<br \/>\n00:00:23,792 –> 00:00:26,609<br \/>\nIn the last video, I looked at an error<\/p>\n<p>9<br \/>\n00:00:26,609 –> 00:00:30,969<br \/>\nthat had been in Microsoft<br \/>\nExcel for the 30 years.<\/p>\n<p>10<br \/>\n00:00:30,969 –> 00:00:34,373<br \/>\nI’ve had heaps of<br \/>\ncomments about that video<\/p>\n<p>11<br \/>\n00:00:34,373 –> 00:00:38,979<br \/>\nand lots of people have<br \/>\nsuggested ways to work around it,<\/p>\n<p>12<br \/>\n00:00:38,979 –> 00:00:42,035<br \/>\nbut they’re all wrong and<br \/>\nI’m gonna show you why.<\/p>\n<p>13<br \/>\n00:00:42,035 –> 00:00:44,853<br \/>\nSo the most frequent comment<br \/>\nI got on the last video<\/p>\n<p>14<br \/>\n00:00:44,853 –> 00:00:47,683<br \/>\nwas simply format the cell<\/p>\n<p>15<br \/>\n00:00:47,683 –> 00:00:49,796<br \/>\nand if we do that everything looks great<\/p>\n<p>16<br \/>\n00:00:49,796 –> 00:00:53,171<br \/>\nuntil we perform a calculation on it<\/p>\n<p>17<br \/>\n00:00:53,171 –> 00:00:56,042<br \/>\nand you can see immediately<br \/>\nthe error’s back.<\/p>\n<p>18<br \/>\n00:00:56,042 –> 00:00:57,803<br \/>\nSo the next most frequent comment<\/p>\n<p>19<br \/>\n00:00:57,803 –> 00:01:00,820<br \/>\nwas format the entire spreadsheet<\/p>\n<p>20<br \/>\n00:01:00,820 –> 00:01:04,864<br \/>\nand when we do that<br \/>\neverything looks hunky-dory,<\/p>\n<p>21<br \/>\n00:01:04,864 –> 00:01:09,618<br \/>\nup until we do some accounting<br \/>\ntype calculations on it,<\/p>\n<p>22<br \/>\n00:01:09,618 –> 00:01:12,429<br \/>\nsuch as balancing two columns of figures,<\/p>\n<p>23<br \/>\n00:01:12,429 –> 00:01:14,497<br \/>\nwhich is quite common.<\/p>\n<p>24<br \/>\n00:01:14,497 –> 00:01:16,780<br \/>\nSo what we’ll do is in the second column<\/p>\n<p>25<br \/>\n00:01:16,780 –> 00:01:19,162<br \/>\nwe’re gonna put the same figures back in,<\/p>\n<p>26<br \/>\n00:01:19,162 –> 00:01:20,849<br \/>\nbut in a different order<\/p>\n<p>27<br \/>\n00:01:20,849 –> 00:01:24,794<br \/>\nand then we’ll put a sum<br \/>\nunderneath them to add them up.<\/p>\n<p>28<br \/>\n00:01:24,794 –> 00:01:27,250<br \/>\nAnd lo and behold they look identical,<\/p>\n<p>29<br \/>\n00:01:27,250 –> 00:01:31,520<br \/>\nbut what we’ll do is we’ll<br \/>\nput in an if calculation<\/p>\n<p>30<br \/>\n00:01:31,520 –> 00:01:33,046<br \/>\njust to compare the two numbers<\/p>\n<p>31<br \/>\n00:01:33,046 –> 00:01:36,747<br \/>\nto see if in fact they are identical.<\/p>\n<p>32<br \/>\n00:01:36,747 –> 00:01:39,830<br \/>\nSo, our little if statement will say,<\/p>\n<p>33<br \/>\n00:01:41,707 –> 00:01:46,068<br \/>\nif the two numbers are the<br \/>\nsame, show the word balanced<\/p>\n<p>34<br \/>\n00:01:46,068 –> 00:01:50,054<br \/>\nand if they’re not, show not balanced.<\/p>\n<p>35<br \/>\n00:01:50,054 –> 00:01:54,129<br \/>\nAnd lo and behold, it says, not balanced.<\/p>\n<p>36<br \/>\n00:01:54,129 –> 00:01:57,594<br \/>\nThe real way to fix the<br \/>\nproblem, is quite simply,<\/p>\n<p>37<br \/>\n00:01:57,594 –> 00:02:01,927<br \/>\nto wrap a round statement<br \/>\naround every sum in excel.<\/p>\n<p>38<br \/>\n00:02:03,730 –> 00:02:08,613<br \/>\nSo in this case, we’ll put<br \/>\nin equals round, bracket,<\/p>\n<p>39<br \/>\n00:02:08,613 –> 00:02:11,542<br \/>\nand then at the end of the<br \/>\nsum we’ll put in comma two<\/p>\n<p>40<br \/>\n00:02:11,542 –> 00:02:15,082<br \/>\nfor two decimal places<br \/>\nand close the bracket off.<\/p>\n<p>41<br \/>\n00:02:15,082 –> 00:02:17,255<br \/>\nAnd that appears to have worked.<\/p>\n<p>42<br \/>\n00:02:17,255 –> 00:02:18,985<br \/>\nNow, to be entirely correct,<\/p>\n<p>43<br \/>\n00:02:18,985 –> 00:02:20,703<br \/>\nwe need to have it on both sums,<\/p>\n<p>44<br \/>\n00:02:20,703 –> 00:02:24,786<br \/>\nso we’ll just drag it<br \/>\nacross and that fixed that,<\/p>\n<p>45<br \/>\n00:02:26,505 –> 00:02:28,109<br \/>\nso that’s one way of fixing the problem,<\/p>\n<p>46<br \/>\n00:02:28,109 –> 00:02:32,009<br \/>\nthere is another way and it’s way quicker.<\/p>\n<p>47<br \/>\n00:02:32,009 –> 00:02:35,362<br \/>\nSo we’ll just undo the<br \/>\nchanges we’ve made there.<\/p>\n<p>48<br \/>\n00:02:35,362 –> 00:02:39,444<br \/>\nAnd now we’ve formatted<br \/>\nthe entire spreadsheet.<\/p>\n<p>49<br \/>\n00:02:39,444 –> 00:02:43,027<br \/>\nSo now what we’re going to<br \/>\ndo is simply go in to file,<\/p>\n<p>50<br \/>\n00:02:43,027 –> 00:02:47,975<br \/>\noptions, advanced, scroll<br \/>\nall the way to the bottom,<\/p>\n<p>51<br \/>\n00:02:47,975 –> 00:02:51,292<br \/>\nand click set precision as displayed.<\/p>\n<p>52<br \/>\n00:02:51,292 –> 00:02:55,789<br \/>\nAnd we when click ok, it’s<br \/>\nall fixed and correct.<\/p>\n<p>53<br \/>\n00:02:55,789 –> 00:02:58,463<br \/>\nNow you’re probably<br \/>\nwatching this video thinking<\/p>\n<p>54<br \/>\n00:02:58,463 –> 00:03:00,457<br \/>\nwhy do I need to go to all that trouble<\/p>\n<p>55<br \/>\n00:03:00,457 –> 00:03:02,554<br \/>\nwhen I know what scientific notation is<\/p>\n<p>56<br \/>\n00:03:02,554 –> 00:03:06,258<br \/>\nand if it’s a problem, I<br \/>\ncan just format it anyway.<\/p>\n<p>57<br \/>\n00:03:06,258 –> 00:03:09,492<br \/>\nWell, that’s well and good<br \/>\nif it’s just you using it,<\/p>\n<p>58<br \/>\n00:03:09,492 –> 00:03:12,730<br \/>\nbut so many times I get<br \/>\ncalled out to a situation<\/p>\n<p>59<br \/>\n00:03:12,730 –> 00:03:16,668<br \/>\nwhere some I.T. guru has<br \/>\ncreated a spreadsheet<\/p>\n<p>60<br \/>\n00:03:16,668 –> 00:03:18,809<br \/>\nfor some poor staff member to use<\/p>\n<p>61<br \/>\n00:03:18,809 –> 00:03:21,426<br \/>\nand they’re completely confused<\/p>\n<p>62<br \/>\n00:03:21,426 –> 00:03:23,145<br \/>\nthey don’t know why it doesn’t work<\/p>\n<p>63<br \/>\n00:03:23,145 –> 00:03:25,453<br \/>\nand before you know it<br \/>\nthey’re off on stress leave<\/p>\n<p>64<br \/>\n00:03:25,453 –> 00:03:27,329<br \/>\nbecause they’re being forced to use<\/p>\n<p>65<br \/>\n00:03:27,329 –> 00:03:29,245<br \/>\nthis thing that’s just useless.<\/p>\n<p>66<br \/>\n00:03:29,245 –> 00:03:31,007<br \/>\nSo in my professional experience<\/p>\n<p>67<br \/>\n00:03:31,007 –> 00:03:33,384<br \/>\nit’s better to get it right, first time.<\/p>\n<p>68<br \/>\n00:03:33,384 –> 00:03:36,583<br \/>\nSo there you have two<br \/>\nways to solve the problem<\/p>\n<p>69<br \/>\n00:03:36,583 –> 00:03:40,932<br \/>\nto work around it till<br \/>\nMicrosoft finally fix the bug.<\/p>\n<p>70<br \/>\n00:03:40,932 –> 00:03:42,074<br \/>\nThank you for watching.<\/p>\n<p>71<br \/>\n00:03:42,074 –> 00:03:45,921<br \/>\nI hope you’ve enjoyed<br \/>\nthis video, if you have,<\/p>\n<p>72<br \/>\n00:03:45,921 –> 00:03:48,944<br \/>\nplease share it with your<br \/>\nfriends and colleagues,<\/p>\n<p>73<br \/>\n00:03:48,944 –> 00:03:51,515<br \/>\nlike and subscribe, and I’ll<br \/>\nsee you in the next video.<\/p>\n<p>74<br \/>\n00:03:51,515 –> 00:03:53,163<br \/>\nThanks for watching.<\/p>\n<p>75<br \/>\n00:03:53,163 –> 00:03:56,163<br \/>\n(slow techno music)<\/p>\n<p>76<br \/>\n00:04:00,633 –> 00:04:02,248<br \/>\nGood day, I’m Jay Burleigh,<\/p>\n<p>77<br \/>\n00:04:02,248 –> 00:04:04,644<br \/>\nhave I got a workaround for you.<\/p>\n<p>78<br \/>\n00:04:04,644 –> 00:04:07,644<br \/>\n(slow techno music)<\/p>\n<p>79<br \/>\n00:04:16,433 –> 00:04:18,327<br \/>\nI’m not doing that again.<\/p>\n<p>80<br \/>\n00:04:18,327 –> 00:04:21,327<br \/>\n(slow techno music)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here is part 2 in my series about the Microsoft Excel Addition Bug. I demonstrate 2 ways of working around the problem.<\/p>\n","protected":false},"author":1,"featured_media":777,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"video","meta":{"inline_featured_image":false,"mc4wp_mailchimp_campaign":[],"footnotes":""},"categories":[20],"tags":[],"class_list":["post-773","post","type-post","status-publish","format-video","has-post-thumbnail","hentry","category-microsoft-excel","post_format-post-format-video"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>Microsoft Excel Addition Bug Workaround - I.T. Guaranteed<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/microsoft-excel-addition-bug-workaround\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Microsoft Excel Addition Bug Workaround - I.T. Guaranteed\" \/>\r\n<meta property=\"og:description\" content=\"Here is part 2 in my series about the Microsoft Excel Addition Bug. I demonstrate 2 ways of working around the problem.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/microsoft-excel-addition-bug-workaround\/\" \/>\r\n<meta property=\"og:site_name\" content=\"I.T. Guaranteed\" \/>\r\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/I.T.Guaranteed\" \/>\r\n<meta property=\"article:published_time\" content=\"2018-05-08T01:24:49+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2018-12-03T04:49:13+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/www.itguaranteed.com.au\/blog\/wp-content\/uploads\/2018\/05\/Microsoft-Excel_Addition-Bug-Workaround.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"700\" \/>\r\n\t<meta property=\"og:image:height\" content=\"393\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"Jay Burleigh\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jay Burleigh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/microsoft-excel-addition-bug-workaround\/\",\"url\":\"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/microsoft-excel-addition-bug-workaround\/\",\"name\":\"Microsoft Excel Addition Bug Workaround - I.T. Guaranteed\",\"isPartOf\":{\"@id\":\"https:\/\/www.itguaranteed.com.au\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/microsoft-excel-addition-bug-workaround\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/microsoft-excel-addition-bug-workaround\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.itguaranteed.com.au\/blog\/wp-content\/uploads\/2018\/05\/Microsoft-Excel_Addition-Bug-Workaround.png\",\"datePublished\":\"2018-05-08T01:24:49+00:00\",\"dateModified\":\"2018-12-03T04:49:13+00:00\",\"author\":{\"@id\":\"https:\/\/www.itguaranteed.com.au\/blog\/#\/schema\/person\/ff702ca7cb4c7573ea3676dee72796ea\"},\"inLanguage\":\"en-AU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/microsoft-excel-addition-bug-workaround\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/microsoft-excel-addition-bug-workaround\/#primaryimage\",\"url\":\"https:\/\/www.itguaranteed.com.au\/blog\/wp-content\/uploads\/2018\/05\/Microsoft-Excel_Addition-Bug-Workaround.png\",\"contentUrl\":\"https:\/\/www.itguaranteed.com.au\/blog\/wp-content\/uploads\/2018\/05\/Microsoft-Excel_Addition-Bug-Workaround.png\",\"width\":700,\"height\":393,\"caption\":\"Microsoft Excel Addition Bug Workaround\"},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.itguaranteed.com.au\/blog\/#website\",\"url\":\"https:\/\/www.itguaranteed.com.au\/blog\/\",\"name\":\"I.T. Guaranteed\",\"description\":\"- Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.itguaranteed.com.au\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-AU\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.itguaranteed.com.au\/blog\/#\/schema\/person\/ff702ca7cb4c7573ea3676dee72796ea\",\"name\":\"Jay Burleigh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\/\/www.itguaranteed.com.au\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/82a28fb608f00f74a687d37d3a6c98d7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/82a28fb608f00f74a687d37d3a6c98d7?s=96&d=mm&r=g\",\"caption\":\"Jay Burleigh\"},\"sameAs\":[\"https:\/\/www.facebook.com\/I.T.Guaranteed\",\"https:\/\/x.com\/ITGuaranteed\"],\"url\":\"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/author\/jay\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft Excel Addition Bug Workaround - I.T. Guaranteed","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/microsoft-excel-addition-bug-workaround\/","og_locale":"en_US","og_type":"article","og_title":"Microsoft Excel Addition Bug Workaround - I.T. Guaranteed","og_description":"Here is part 2 in my series about the Microsoft Excel Addition Bug. I demonstrate 2 ways of working around the problem.","og_url":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/microsoft-excel-addition-bug-workaround\/","og_site_name":"I.T. Guaranteed","article_author":"https:\/\/www.facebook.com\/I.T.Guaranteed","article_published_time":"2018-05-08T01:24:49+00:00","article_modified_time":"2018-12-03T04:49:13+00:00","og_image":[{"width":700,"height":393,"url":"https:\/\/www.itguaranteed.com.au\/blog\/wp-content\/uploads\/2018\/05\/Microsoft-Excel_Addition-Bug-Workaround.png","type":"image\/png"}],"author":"Jay Burleigh","twitter_misc":{"Written by":"Jay Burleigh","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/microsoft-excel-addition-bug-workaround\/","url":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/microsoft-excel-addition-bug-workaround\/","name":"Microsoft Excel Addition Bug Workaround - I.T. Guaranteed","isPartOf":{"@id":"https:\/\/www.itguaranteed.com.au\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/microsoft-excel-addition-bug-workaround\/#primaryimage"},"image":{"@id":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/microsoft-excel-addition-bug-workaround\/#primaryimage"},"thumbnailUrl":"https:\/\/www.itguaranteed.com.au\/blog\/wp-content\/uploads\/2018\/05\/Microsoft-Excel_Addition-Bug-Workaround.png","datePublished":"2018-05-08T01:24:49+00:00","dateModified":"2018-12-03T04:49:13+00:00","author":{"@id":"https:\/\/www.itguaranteed.com.au\/blog\/#\/schema\/person\/ff702ca7cb4c7573ea3676dee72796ea"},"inLanguage":"en-AU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.itguaranteed.com.au\/blog\/index.php\/microsoft-excel-addition-bug-workaround\/"]}]},{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/microsoft-excel-addition-bug-workaround\/#primaryimage","url":"https:\/\/www.itguaranteed.com.au\/blog\/wp-content\/uploads\/2018\/05\/Microsoft-Excel_Addition-Bug-Workaround.png","contentUrl":"https:\/\/www.itguaranteed.com.au\/blog\/wp-content\/uploads\/2018\/05\/Microsoft-Excel_Addition-Bug-Workaround.png","width":700,"height":393,"caption":"Microsoft Excel Addition Bug Workaround"},{"@type":"WebSite","@id":"https:\/\/www.itguaranteed.com.au\/blog\/#website","url":"https:\/\/www.itguaranteed.com.au\/blog\/","name":"I.T. Guaranteed","description":"- Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.itguaranteed.com.au\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-AU"},{"@type":"Person","@id":"https:\/\/www.itguaranteed.com.au\/blog\/#\/schema\/person\/ff702ca7cb4c7573ea3676dee72796ea","name":"Jay Burleigh","image":{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/www.itguaranteed.com.au\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/82a28fb608f00f74a687d37d3a6c98d7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/82a28fb608f00f74a687d37d3a6c98d7?s=96&d=mm&r=g","caption":"Jay Burleigh"},"sameAs":["https:\/\/www.facebook.com\/I.T.Guaranteed","https:\/\/x.com\/ITGuaranteed"],"url":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/author\/jay\/"}]}},"_links":{"self":[{"href":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/wp-json\/wp\/v2\/posts\/773"}],"collection":[{"href":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=773"}],"version-history":[{"count":7,"href":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/wp-json\/wp\/v2\/posts\/773\/revisions"}],"predecessor-version":[{"id":785,"href":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/wp-json\/wp\/v2\/posts\/773\/revisions\/785"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/wp-json\/wp\/v2\/media\/777"}],"wp:attachment":[{"href":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=773"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=773"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=773"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}