{"id":46662,"date":"2024-06-03T06:00:07","date_gmt":"2024-06-03T04:00:07","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=46662"},"modified":"2024-06-02T09:28:31","modified_gmt":"2024-06-02T07:28:31","slug":"use-count-for-cost-analysis","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/use-count-for-cost-analysis\/","title":{"rendered":"How to Use COUNT for Cost Analysis in Excel"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/Use-COUNT-for-Cost-Analysis.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-46971 size-large\" title=\"Use COUNT for Cost Analysis\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/Use-COUNT-for-Cost-Analysis-1024x576.png\" alt=\"Use COUNT for Cost Analysis\" width=\"640\" height=\"360\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/Use-COUNT-for-Cost-Analysis-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/Use-COUNT-for-Cost-Analysis-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/Use-COUNT-for-Cost-Analysis-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/Use-COUNT-for-Cost-Analysis-180x100.png 180w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/Use-COUNT-for-Cost-Analysis.png 1280w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><br \/>\nUsing the COUNT function in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\">Microsoft Excel<\/a> for cost analysis allows you to quickly quantify the number of entries in a dataset, facilitating the evaluation of cost-related data. By counting cells that meet specific criteria, you can identify the frequency of expenses, occurrences of cost overruns, or instances of budget adherence. This approach on how to use count for cost analysis enhances your ability to analyze spending patterns, allocate resources efficiently, and make informed financial decisions.<\/p>\n<p><strong>Key Takeaways:<\/strong><\/p>\n<ul>\n<li>The COUNT function in Excel enables rapid quantification of entries, facilitating the evaluation of cost-related data and simplifying complex financial datasets.<\/li>\n<li>By using COUNT, COUNTIF, and COUNTIFS functions, you can identify the frequency of expenses, instances of cost overruns, and adherence to budget, providing insights into spending patterns.<\/li>\n<li>Cost analysis with COUNT functions supports informed financial decisions by highlighting areas of waste, forecasting future expenditures, and aligning investments with strategic goals.<\/li>\n<li>COUNTIF and COUNTIFS functions offer advanced capabilities to count cells based on single or multiple criteria, enhancing the precision of your cost analysis.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/use-count-for-cost-analysis\/#Introduction_to_Cost_Analysis\" title=\"Introduction to Cost Analysis\">Introduction to Cost Analysis<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/use-count-for-cost-analysis\/#Fundamentals_of_COUNT_Formulas\" title=\"Fundamentals of COUNT Formulas\">Fundamentals of COUNT Formulas<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/use-count-for-cost-analysis\/#Advanced_Tips_and_Tricks\" title=\"Advanced Tips and Tricks\">Advanced Tips and Tricks<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/use-count-for-cost-analysis\/#FAQ_Mastering_the_COUNT_Formula_in_Excel\" title=\"FAQ: Mastering the COUNT Formula in Excel\">FAQ: Mastering the COUNT Formula in Excel<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Introduction_to_Cost_Analysis\"><\/span>Introduction to Cost Analysis<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Unveiling the Power of Count Formulas in Excel<\/h3>\n<p>Cost analysis can often seem like a daunting task, but with Excel&#8217;s <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/formulas\/math\/count\/\" target=\"_blank\" rel=\"noopener\">COUNT formulas<\/a> at your disposal, it becomes a walk in the park. These functions are nifty tools for quick calculations, allowing you to derive meaningful insights from heaps of data with a few keystrokes.<\/p>\n<p>Think of them as your data-crunching assistants, ready to tally up whatever you need without breaking a sweat.<\/p>\n<h3>The Relevance of Cost Analysis in Business Decision-Making<\/h3>\n<p>Cost analysis is a cornerstone in business decision-making, providing a clear snapshot of financial health and guiding choices that can make or break a <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-budget-spreadsheet\/\" target=\"_blank\" rel=\"noopener\">company&#8217;s budget<\/a>. By dissecting the inflows and outflows, organizations can pinpoint areas of waste, forecast future spending, and align investments with strategic goals. Essential for growth, cost analysis illuminates the path toward efficient resource allocation and better profitability.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Fundamentals_of_COUNT_Formulas\"><\/span>Fundamentals of COUNT Formulas<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Grasping the Basics: What is the COUNT Function?<\/h3>\n<p>The COUNT function is an Excel savior when you want to tally the number of cells filled with numerical data. They make it a breeze to quantify entries in any given spreadsheet, aiding in tasks ranging from inventory management to <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-data-validation\/\" target=\"_blank\" rel=\"noopener\">data validation<\/a>.<\/p>\n<p>Simple yet powerful, the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/count-formula-excel\/\" target=\"_blank\" rel=\"noopener\">COUNT formula<\/a> is entered as =COUNT(range), and voil\u00e0, it swiftly provides the total number of cells in a range that contains numbers. Remember, it&#8217;s the first step in turning raw data into actionable insights.<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span> <\/strong>Enter the data into cells.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Use COUNT for Cost Analysis\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia649007362024-05-27T193A033A13.148420_Count_for_cost_analysis_1.png\" alt=\"Use COUNT for Cost Analysis\" width=\"399\" height=\"263\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2: <\/strong><\/span>In cell B6, type =COUNT(B2:B5). Press Enter.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia649007362024-05-27T193A033A27.846779_Streamline_Cost_Analysis_in_Excel_Using_COUNT_Formula_-2.png\" alt=\"\" title=\"\"><\/p>\n<p>The COUNT function in cell B6 returns 3, meaning there are 3 cells with numerical data in the range B2. This helps in quickly determining the quantity of numerical entries within the specified data range.<\/p>\n<h3>Diving Deeper: Variations like COUNTIF and COUNTIFS<\/h3>\n<p>Diving deeper into Excel&#8217;s toolbox reveals COUNTIF and COUNTIFS, the formula&#8217;s more specific and sophisticated relatives. COUNTIF is ideal when you need to count cells based on a single criterion, such as how many products exceed a certain sales figure.<\/p>\n<p>On the other hand, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/countifs-function-in-excel\/\" target=\"_blank\" rel=\"noopener\">COUNTIFS <\/a>expands on that capability, letting you apply multiple criteria across different ranges \u2014 an absolute game-changer for complex datasets. With these functions, you can filter and count in a way that&#8217;s tailored to pinpoint accuracy in your data analysis.<\/p>\n<p><strong>=COUNTIF(range, criteria)<\/strong><\/p>\n<p>Let\u2019s look at the example below:<\/p>\n<p><strong>Scenario:<\/strong><\/p>\n<p>A small fruit store wants to analyze its sales data to understand the popularity of different fruits. The store records the sales of various fruits in a spreadsheet and needs to count how many times each type of fruit appears in their sales data.<\/p>\n<p><strong>Objective:<\/strong><\/p>\n<p>Count the number of times &#8220;Apple&#8221; appears in the product list to gauge its popularity.<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span> <\/strong>Enter the sales data into cells of the spreadsheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Use COUNT for Cost Analysis\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia649007362024-05-27T193A043A35.168484_Streamline_Cost_Analysis_in_Excel_Using_COUNT_Formula_-3.png\" alt=\"Use COUNT for Cost Analysis\" width=\"429\" height=\"266\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2: <\/strong><\/span>In cell D2, type =COUNTIF(A2:A6, &#8220;Apple&#8221;). Press Enter to run the formula.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Use COUNT for Cost Analysis\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia649007362024-05-27T193A043A57.784191_Streamline_Cost_Analysis_in_Excel_Using_COUNT_Formula_-4.png\" alt=\"Use COUNT for Cost Analysis\" width=\"577\" height=\"265\" \/><\/p>\n<p>The result in cell D2 will be 2, indicating that &#8220;Apple&#8221; appears 2 times in the range A2:A6.<\/p>\n<p><strong>Scenario:<\/strong> Cost Analysis Using COUNTIFS Function<\/p>\n<p>COUNTIFS Syntax: =COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2],\u2026)<\/p>\n<p>A fruit store wants to analyze its sales data to determine the number of high-value transactions for specific products. The goal is to count the number of transactions where the product is &#8220;Apple&#8221; and the sales amount exceeds $100. This will help in understanding the frequency of high-value sales and optimizing inventory management.<\/p>\n<p><strong>Objective:<\/strong><\/p>\n<p>Count the number of &#8220;Apple&#8221; transactions where the sales amount is greater than $100 and calculate the total cost of these transactions.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span>Enter the sales data into cells.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Use COUNT for Cost Analysis\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia649007362024-05-27T193A063A03.050698_Streamline_Cost_Analysis_in_Excel_Using_COUNT_Formula_-5.png\" alt=\"Use COUNT for Cost Analysis\" width=\"289\" height=\"216\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2: <\/strong><\/span> In cell E1, type =COUNTIFS(A2:A7, &#8220;Apple&#8221;, B2:B7, &#8220;&gt;100&#8221;). Press Enter to run the formula. The result in cell E1 will be 2, indicating there are 2 high-value &#8220;Apple&#8221; transactions.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Use COUNT for Cost Analysis\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia649007362024-05-27T193A063A19.282602_Streamline_Cost_Analysis_in_Excel_Using_COUNT_Formula_-6.png\" alt=\"Use COUNT for Cost Analysis\" width=\"748\" height=\"291\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3: <\/strong><\/span>In cell E5, type =SUMIFS(C2:C7, A2:A7, &#8220;Apple&#8221;, B2:B7, &#8220;&gt;100&#8221;) to calculate the total cost of these transactions. Press Enter. The result will be $540.00.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Use COUNT for Cost Analysis\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia649007362024-05-27T193A063A35.700084_Streamline_Cost_Analysis_in_Excel_Using_COUNT_Formula_-7.png\" alt=\"Use COUNT for Cost Analysis\" width=\"750\" height=\"317\" \/><\/p>\n<p><u>Note:<\/u> Don\u2019t forget to <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/custom-number-formats-in-excel\/\" target=\"_blank\" rel=\"noopener\">format your numbers<\/a> into currency\/number format, or else the SUMIF formula will not give the correct value.<\/p>\n<p><strong>Conclusion:<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/the-countif-function-for-beginners\/\" target=\"_blank\" rel=\"noopener\">The COUNTIFS function<\/a> reveals there are 2 transactions where &#8220;Apple&#8221; sales exceeded $100. <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-use-sumifs-function-in-excel\/\" target=\"_blank\" rel=\"noopener\">Using the SUMIFS function<\/a>, the total cost of these transactions is calculated to be $540.00. This cost analysis helps the store understand the financial impact of high-value sales, guiding inventory management and pricing strategies.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Advanced_Tips_and_Tricks\"><\/span>Advanced Tips and Tricks<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Debugging Common Issues with COUNT Formulas<\/h3>\n<p>It&#8217;s a truth universally acknowledged that even the best-laid Excel plans can face hiccups. Maybe you&#8217;ve been scratching your head wondering why the COUNT function isn&#8217;t spitting out the right numbers. Often, the issue lies in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-different-ways-to-format-data-using-power-query\/\" target=\"_blank\" rel=\"noopener\">data formatting<\/a> \u2014 perhaps those numbers are actually text, or vice versa.<\/p>\n<p>It&#8217;s also a good idea to check for sneaky spaces or non-visible characters. And remember, COUNT won&#8217;t consider logical values or text unless specifically told to do so. Start by ensuring that all data conforms to the expected format, and employ the trusty <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/counta-formula-excel\/\" target=\"_blank\" rel=\"noopener\">COUNTA function<\/a> for a broad sweep of non-empty cells.<\/p>\n<p><strong>Quick Tips:<\/strong><\/p>\n<ol>\n<li data-list=\"ordered\">Verify data format types (General, Text, Number).<\/li>\n<li data-list=\"ordered\">Look out for hidden spaces or characters.<\/li>\n<li data-list=\"ordered\">Check if cells contain errors which COUNT will ignore.<\/li>\n<li data-list=\"ordered\">Use COUNTA to count all non-blank values if needed.<\/li>\n<li data-list=\"ordered\">Ensure criteria in COUNTIF\/COUNTIFS are correctly quoted and match the data exactly.<\/li>\n<\/ol>\n<p>If debugging is still giving you trouble, take a deep breath and step back for a moment. Sometimes a fresh set of eyes after a cup of coffee is all it takes to spot that one pesky problem.<\/p>\n<h3>Speed up Calculation and Data Processing in Excel<\/h3>\n<p>Efficiency is key when using Excel, especially with large datasets that could potentially slow down your workflow. To keep Excel light on its feet, consider converting your data to <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/analysis\/excel-tables\/\" target=\"_blank\" rel=\"noopener\">Excel Tables<\/a> for enhanced performance in automatic calculations.<\/p>\n<p>Switch off automatic calculations while you&#8217;re inputting data to avoid recalculations after each entry. You&#8217;re in the driver&#8217;s seat\u2014take control by manually recalculating (F9 is your friend) when you&#8217;re ready. And for the speed-seeking Excel geeks, embrace <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\">PivotTables <\/a>for summary reports and learn the art of array formulas for multiple calculations in a single swoop.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"FAQ_Mastering_the_COUNT_Formula_in_Excel\"><\/span>FAQ: Mastering the COUNT Formula in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>What is the count function?<\/h3>\n<p>The <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34\" target=\"_blank\" rel=\"nofollow noopener\">COUNT function is a formula<\/a> in Excel that tallies up the total number of cells in a specified range that contain numbers. It\u2019s great for quickly getting a count of quantitative <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-data-entry-form-excel\/\" target=\"_blank\" rel=\"noopener\">data entries<\/a> in spreadsheets, providing a simple yet effective way to measure data points.<\/p>\n<h3>What is the formula for cost analysis in Excel?<\/h3>\n<p>The formula for cost analysis in Excel isn&#8217;t a one-size-fits-all; it varies depending on the complexity of your analysis. Generally, you might combine SUM for total costs, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sumproduct-weighted-averages\/\" target=\"_blank\" rel=\"noopener\">SUMPRODUCT for weighted<\/a> sums, and COUNTIFS for counting specific cost-related conditions. One example formula could be =SUMPRODUCT(cost_range, quantity_range) to calculate total expenses.<\/p>\n<h3>How do you use Countif analysis in Excel?<\/h3>\n<p>Using COUNTIF in Excel lets you count cells that meet a specific condition you define. To use it, input your range and set the criteria \u2013 like counting sales over a target amount \u2013 and COUNTIF does the tallying for you. For example, to count sales over $500 in range A1:A10, you would use =COUNTIF(A1:A10, &#8220;&gt;500&#8221;).<\/p>\n<h3>How can I use the COUNT function to aid in cost analysis?<\/h3>\n<p>The COUNT function aids in cost analysis by giving you a quick count of how many numerical entries you have. For example, you could count how many items you&#8217;re paying for in a budget line. This helps in assessing the volume of transactions and gauging the extent of your cost-related data points.<\/p>\n<h3>Can you give an example of using COUNTIF for analyzing costs?<\/h3>\n<p>Certainly! Use COUNTIF for cost analysis by setting conditions relevant to your financial data. For instance, to count the number of transactions exceeding $1000 in a list from B2 to B100, the formula is =COUNTIF(B2:B100, &#8220;&gt;1000&#8221;). You&#8217;ll instantly know how many high-value expenditures you&#8217;ve made.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Learn to use COUNT for cost analysis in Excel. Manage prices &amp; items efficiently with our quick guide!<\/p>\n","protected":false},"author":1,"featured_media":46971,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"How to Use COUNT for Cost Analysis in Excel","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[3,15],"tags":[2804,326,329,2803],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/46662"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=46662"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/46662\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/46971"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=46662"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=46662"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=46662"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}