{"id":47,"date":"2012-05-08T01:23:30","date_gmt":"2012-05-08T01:23:30","guid":{"rendered":"http:\/\/convergedsystems.com\/blog\/?p=47"},"modified":"2018-10-09T11:57:35","modified_gmt":"2018-10-09T16:57:35","slug":"four-great-google-spreadsheet-functions","status":"publish","type":"post","link":"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/","title":{"rendered":"Four Great Google Spreadsheet Functions"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-10506\" src=\"http:\/\/convergedsystems.com\/blog\/wp-content\/plugins\/RSSPoster_PRO\/cache\/af489_GoogleApps_Apr02_C.jpg\" alt=\"\" width=\"170\" height=\"170\" \/>Office suites like the one offered by Google, Google Docs, are one of the important production tools for managers and business owners. One of the useful tools of the Google office suite is the versatile spreadsheet. A skilled user of spreadsheets can make the finding and viewing of information easy. The rest of us could always benefit from learning extra functions that will make our jobs more efficient.<\/p>\n<p>Spreadsheet is simple and straightforward, but sometimes it appears to be a little too plain. There are however a large amount of incredibly useful features hidden away. Here are a few:<\/p>\n<p><strong>=GoogleFinance:<\/strong> This function provides you with practical options including the ability to convert currency and track stocks. The standard formula is<strong>=GoogleFinance(\u201cSymbol\u201d, \u201cAttribute\u201d)<\/strong> Where\u00a0<strong>Symbo<\/strong>l is the stock symbol and\u00a0<strong>Attribute<\/strong> is what you would like to follow e.g., price.<\/p>\n<p>You can also use this function for currency rates and conversions. If you want to know what the current exchange rate is between the Canadian Dollar and the US Dollar put:\u00a0<strong>=GoogleFinance(\u201cCADUSD\u201d)<\/strong> to get the current exchange rate. Like stocks, this will be updated whenever the exchange rate changes. For a full list of =GoogleFinance functions check out this\u00a0<a href=\"http:\/\/support.google.com\/docs\/bin\/answer.py?hl=enanswer=155178\" class=\"external external_icon\" rel=\"nofollow\">page<\/a>.<\/p>\n<p><strong>Translate a cell:<\/strong> From time to time you may get a spreadsheet that contains more than one language. Usually you would have to send it back to the author for translation, which could take more time than anticipated. Did you know that you can get Google to translate a cell from one language to another? In an empty cell enter:\u00a0<strong>=GoogleTranslate(CELL, \u201cSource Language\u201d, \u201c Target Language\u201d)<\/strong> Where:\u00a0<strong>CELL<\/strong> is the cell you want to translate;\u00a0<strong>Source Language<\/strong> is the language the cell is currently in;\u00a0<strong>Target language<\/strong> is the language you\u2019d like to translate into. For the languages you have to use the two letter\u00a0<a href=\"http:\/\/www.loc.gov\/standards\/iso639-2\/php\/code_list.php\" class=\"external external_icon\" rel=\"nofollow\">ISO 639-2 language codes<\/a>.<\/p>\n<p><strong>Split a Cell: <\/strong>If you want to create a table that has the days of the week in columns you can easily do so. In the first cell enter:\u00a0<strong>=Split(\u201cMonday Tuesday Wednesday Thursday Friday Saturday Sunday\u201d, \u201c \u201c)<\/strong> Spreadsheet will automatically put the days into separate columns. To spread data out in a row enter:\u00a0<strong>=transpose(Split(\u201cMonday Tuesday Wednesday Thursday Friday Saturday Sunday\u201d, \u201c \u201c))<\/strong>. Be sure to have spaces between the data you want in different cells, and a space between the quotation marks at the end of the function.<\/p>\n<p><strong>Concatenate:<\/strong> This function acts as the opposite of =Split. If you have data in a number of cells you want to bring together e.g., data in cells A2, A5, A6, B7, enter\u00a0<strong>=concatenate(A2, A5, A6, B7)<\/strong> The data will be put into one cell.<\/p>\n<p>There are many more handy functions out there that will make your life easier and take some of the work out of spreadsheet creation. If you have any questions regarding Spreadsheet, Google Docs or other Google Apps please let us know, we are happy to help.<\/p>\n<a class=\"synved-social-button synved-social-button-share synved-social-size-32 synved-social-resolution-single synved-social-provider-facebook nolightbox external\" data-provider=\"facebook\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Facebook\" href=\"https:\/\/www.facebook.com\/sharer.php?u=https%3A%2F%2Fwww.convergedsystems.com%2Fblog%2Fwp-json%2Fwp%2Fv2%2Fposts%2F47&#038;t=Four%20Great%20Google%20Spreadsheet%20Functions&#038;s=100&#038;p&#091;url&#093;=https%3A%2F%2Fwww.convergedsystems.com%2Fblog%2Fwp-json%2Fwp%2Fv2%2Fposts%2F47&#038;p&#091;images&#093;&#091;0&#093;=http%3A%2F%2Fconvergedsystems.com%2Fblog%2Fwp-content%2Fplugins%2FRSSPoster_PRO%2Fcache%2Faf489_GoogleApps_Apr02_C.jpg&#038;p&#091;title&#093;=Four%20Great%20Google%20Spreadsheet%20Functions\" style=\"font-size: 0px;width:32px;height:32px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"Facebook\" title=\"Share on Facebook\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"32\" height=\"32\" style=\"display: inline;width:32px;height:32px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/www.convergedsystems.com\/blog\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/64x64\/facebook.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-32 synved-social-resolution-single synved-social-provider-twitter nolightbox external\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fwww.convergedsystems.com%2Fblog%2Fwp-json%2Fwp%2Fv2%2Fposts%2F47&#038;text=Hey%20check%20this%20out\" style=\"font-size: 0px;width:32px;height:32px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"32\" height=\"32\" style=\"display: inline;width:32px;height:32px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/www.convergedsystems.com\/blog\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/64x64\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-32 synved-social-resolution-single synved-social-provider-linkedin nolightbox external\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fwww.convergedsystems.com%2Fblog%2Fwp-json%2Fwp%2Fv2%2Fposts%2F47&#038;title=Four%20Great%20Google%20Spreadsheet%20Functions\" style=\"font-size: 0px;width:32px;height:32px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"32\" height=\"32\" style=\"display: inline;width:32px;height:32px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/www.convergedsystems.com\/blog\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/64x64\/linkedin.png\" \/><\/a>","protected":false},"excerpt":{"rendered":"<p>Office suites like the one offered by Google, Google Docs, are one of the important production tools for managers and business owners. One of the useful tools of the Google office suite is the versatile spreadsheet. A skilled user of spreadsheets can make the finding and viewing of information easy. The rest of us could&#8230; <a class=\"moretag\" href=\"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-47","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Four Great Google Spreadsheet Functions - Converged Systems Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Four Great Google Spreadsheet Functions - Converged Systems Blog\" \/>\n<meta property=\"og:description\" content=\"Office suites like the one offered by Google, Google Docs, are one of the important production tools for managers and business owners. One of the useful tools of the Google office suite is the versatile spreadsheet. A skilled user of spreadsheets can make the finding and viewing of information easy. The rest of us could... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/\" \/>\n<meta property=\"og:site_name\" content=\"Converged Systems Blog\" \/>\n<meta property=\"article:published_time\" content=\"2012-05-08T01:23:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-10-09T16:57:35+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/convergedsystems.com\/blog\/wp-content\/plugins\/RSSPoster_PRO\/cache\/af489_GoogleApps_Apr02_C.jpg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.convergedsystems.com\/blog\/#\/schema\/person\/0ef3bbc784661644315f0d1ccedc2d49\"},\"headline\":\"Four Great Google Spreadsheet Functions\",\"datePublished\":\"2012-05-08T01:23:30+00:00\",\"dateModified\":\"2018-10-09T16:57:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/\"},\"wordCount\":498,\"commentCount\":1,\"image\":{\"@id\":\"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/convergedsystems.com\/blog\/wp-content\/plugins\/RSSPoster_PRO\/cache\/af489_GoogleApps_Apr02_C.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/\",\"url\":\"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/\",\"name\":\"Four Great Google Spreadsheet Functions - Converged Systems Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.convergedsystems.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/convergedsystems.com\/blog\/wp-content\/plugins\/RSSPoster_PRO\/cache\/af489_GoogleApps_Apr02_C.jpg\",\"datePublished\":\"2012-05-08T01:23:30+00:00\",\"dateModified\":\"2018-10-09T16:57:35+00:00\",\"author\":{\"@id\":\"https:\/\/www.convergedsystems.com\/blog\/#\/schema\/person\/0ef3bbc784661644315f0d1ccedc2d49\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/#primaryimage\",\"url\":\"http:\/\/convergedsystems.com\/blog\/wp-content\/plugins\/RSSPoster_PRO\/cache\/af489_GoogleApps_Apr02_C.jpg\",\"contentUrl\":\"http:\/\/convergedsystems.com\/blog\/wp-content\/plugins\/RSSPoster_PRO\/cache\/af489_GoogleApps_Apr02_C.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.convergedsystems.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Four Great Google Spreadsheet Functions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.convergedsystems.com\/blog\/#website\",\"url\":\"https:\/\/www.convergedsystems.com\/blog\/\",\"name\":\"Converged Systems Blog\",\"description\":\"Converged Communication Systems (CCS) provides best-in-class IP Telephony \/ Unified Communications solutions.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.convergedsystems.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.convergedsystems.com\/blog\/#\/schema\/person\/0ef3bbc784661644315f0d1ccedc2d49\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/973de09019523f7fecbb85949d10db6082cc841dc1612acccf7d55141750325c?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/973de09019523f7fecbb85949d10db6082cc841dc1612acccf7d55141750325c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/973de09019523f7fecbb85949d10db6082cc841dc1612acccf7d55141750325c?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\/\/www.convergedsystems.com\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Four Great Google Spreadsheet Functions - Converged Systems Blog","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.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/","og_locale":"en_US","og_type":"article","og_title":"Four Great Google Spreadsheet Functions - Converged Systems Blog","og_description":"Office suites like the one offered by Google, Google Docs, are one of the important production tools for managers and business owners. One of the useful tools of the Google office suite is the versatile spreadsheet. A skilled user of spreadsheets can make the finding and viewing of information easy. The rest of us could... Read more","og_url":"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/","og_site_name":"Converged Systems Blog","article_published_time":"2012-05-08T01:23:30+00:00","article_modified_time":"2018-10-09T16:57:35+00:00","og_image":[{"url":"http:\/\/convergedsystems.com\/blog\/wp-content\/plugins\/RSSPoster_PRO\/cache\/af489_GoogleApps_Apr02_C.jpg","type":"","width":"","height":""}],"author":"admin","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/#article","isPartOf":{"@id":"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/"},"author":{"name":"admin","@id":"https:\/\/www.convergedsystems.com\/blog\/#\/schema\/person\/0ef3bbc784661644315f0d1ccedc2d49"},"headline":"Four Great Google Spreadsheet Functions","datePublished":"2012-05-08T01:23:30+00:00","dateModified":"2018-10-09T16:57:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/"},"wordCount":498,"commentCount":1,"image":{"@id":"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/#primaryimage"},"thumbnailUrl":"http:\/\/convergedsystems.com\/blog\/wp-content\/plugins\/RSSPoster_PRO\/cache\/af489_GoogleApps_Apr02_C.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/","url":"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/","name":"Four Great Google Spreadsheet Functions - Converged Systems Blog","isPartOf":{"@id":"https:\/\/www.convergedsystems.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/#primaryimage"},"image":{"@id":"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/#primaryimage"},"thumbnailUrl":"http:\/\/convergedsystems.com\/blog\/wp-content\/plugins\/RSSPoster_PRO\/cache\/af489_GoogleApps_Apr02_C.jpg","datePublished":"2012-05-08T01:23:30+00:00","dateModified":"2018-10-09T16:57:35+00:00","author":{"@id":"https:\/\/www.convergedsystems.com\/blog\/#\/schema\/person\/0ef3bbc784661644315f0d1ccedc2d49"},"breadcrumb":{"@id":"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/#primaryimage","url":"http:\/\/convergedsystems.com\/blog\/wp-content\/plugins\/RSSPoster_PRO\/cache\/af489_GoogleApps_Apr02_C.jpg","contentUrl":"http:\/\/convergedsystems.com\/blog\/wp-content\/plugins\/RSSPoster_PRO\/cache\/af489_GoogleApps_Apr02_C.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.convergedsystems.com\/blog\/four-great-google-spreadsheet-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.convergedsystems.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Four Great Google Spreadsheet Functions"}]},{"@type":"WebSite","@id":"https:\/\/www.convergedsystems.com\/blog\/#website","url":"https:\/\/www.convergedsystems.com\/blog\/","name":"Converged Systems Blog","description":"Converged Communication Systems (CCS) provides best-in-class IP Telephony \/ Unified Communications solutions.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.convergedsystems.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.convergedsystems.com\/blog\/#\/schema\/person\/0ef3bbc784661644315f0d1ccedc2d49","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/973de09019523f7fecbb85949d10db6082cc841dc1612acccf7d55141750325c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/973de09019523f7fecbb85949d10db6082cc841dc1612acccf7d55141750325c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/973de09019523f7fecbb85949d10db6082cc841dc1612acccf7d55141750325c?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/www.convergedsystems.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.convergedsystems.com\/blog\/wp-json\/wp\/v2\/posts\/47","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.convergedsystems.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.convergedsystems.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.convergedsystems.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.convergedsystems.com\/blog\/wp-json\/wp\/v2\/comments?post=47"}],"version-history":[{"count":3,"href":"https:\/\/www.convergedsystems.com\/blog\/wp-json\/wp\/v2\/posts\/47\/revisions"}],"predecessor-version":[{"id":179,"href":"https:\/\/www.convergedsystems.com\/blog\/wp-json\/wp\/v2\/posts\/47\/revisions\/179"}],"wp:attachment":[{"href":"https:\/\/www.convergedsystems.com\/blog\/wp-json\/wp\/v2\/media?parent=47"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.convergedsystems.com\/blog\/wp-json\/wp\/v2\/categories?post=47"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.convergedsystems.com\/blog\/wp-json\/wp\/v2\/tags?post=47"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}