{"id":3652,"date":"2022-12-01T22:40:17","date_gmt":"2022-12-01T21:40:17","guid":{"rendered":"https:\/\/kalkulacija.com\/wordpress\/?p=3652"},"modified":"2022-12-06T11:52:28","modified_gmt":"2022-12-06T10:52:28","slug":"excel-dashboard","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/","title":{"rendered":"Excel Dashboards Tutorial &#038; Templates"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #0d590e;color:#0d590e\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #0d590e;color:#0d590e\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Izrada_Excel_Dashboard_kontrolne_table\" >Izrada Excel (Dashboard) kontrolne table<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Izvor_podataka_za_prikazivanje_na_kontrolnoj_tabli\" >Izvor podataka za prikazivanje na kontrolnoj tabli<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Auditorijum_%E2%80%93_kome_je_namenjena_kontrolna_tabla\" >Auditorijum &#8211; kome je namenjena kontrolna tabla<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Vrsta_informacija_po_vaznosti_koje_prikazujete\" >Vrsta informacija po va\u017enosti koje\u00a0prikazujete<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Pojednostavite_prikaz_svega_posebno_brojeva_u_redu_velicina_hilj_mil_mlrd\" >Pojednostavite prikaz svega, posebno brojeva u redu veli\u010dina, hilj. mil. mlrd;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#_Grupisite_informacije\" >\u00a0Grupi\u0161ite informacije<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Izbegavajte_dekorativne_elemente_%E2%80%93_neopterecujte_ekran_sa_nepotrebnim_stvarima\" >Izbegavajte dekorativne elemente &#8211; neoptere\u0107ujte ekran sa nepotrebnim stvarima;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Koristite_crvenu_i_zelenu_boju_da_auditorijum_zna_da_li_je_u_redu_ili_ne\" >Koristite crvenu i zelenu boju da auditorijum zna da li je u redu ili ne.<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Najbol%D1%98e_prakse_za_dizajn_kontrolne_table\" >Najbol\u0458e prakse za dizajn kontrolne table<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Odredite_svrhu_kontrolne_table\" >Odredite svrhu kontrolne table<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Jednostavan_oblik\" >Jednostavan oblik<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Doslednost_%E2%80%93_tipsko_resenje\" >Doslednost &#8211; tipsko re\u0161enje<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Blizina\" >Blizina<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Uskladivanje\" >Uskla\u0111ivanje<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Razmak\" >Razmak<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Boja\" >Boja<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Fontovi\" >Fontovi<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Formati_brojeva\" >Formati brojeva<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Etikete\" >Etikete<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Personalizacija_i_prilagodavanje\" >Personalizacija i prilago\u0111avanje<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Tabele_ili_liste_podataka\" >Tabele ili liste podataka<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Da_sumiram\" >Da sumiram<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#EXCEL_DASHBOARD_CONTROL_PANEL_INSTRUCTIONS_AND_SAMPLE_FILES\" >EXCEL (DASHBOARD) CONTROL PANEL INSTRUCTIONS AND SAMPLE FILES<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Creating_an_Excel_Dashboard_control_panel\" >Creating an Excel (Dashboard) control panel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Best_practices_for_dashboard_design\" >Best practices for dashboard design<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Determine_the_purpose_of_the_dashboard\" >Determine the purpose of the dashboard<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Simple_shape\" >Simple shape<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-28\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Consistency_%E2%80%93_type_solution\" >Consistency &#8211; type solution<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-29\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Vicinity\" >Vicinity<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-30\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Harmonization\" >Harmonization<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-31\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Space\" >Space<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-32\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Color\" >Color<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-33\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Fontovi-2\" >Fontovi<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-34\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Number_formats\" >Number formats<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-35\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Labels\" >Labels<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-36\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Personalization_and_customization\" >Personalization and customization<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-37\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#Tables_or_lists_of_data\" >Tables or lists of data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-38\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/excel-dashboard\/#They_disappeared\" >They disappeared<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<header class=\"entry-header\">\n<h2 class=\"entry-title\"><span class=\"ez-toc-section\" id=\"EXCEL_DASHBOARD_CONTROL_PANEL_INSTRUCTIONS_AND_SAMPLE_FILES\"><\/span><span><span class=\"\">EXCEL (DASHBOARD) CONTROL PANEL INSTRUCTIONS AND SAMPLE FILES<\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/header>\n<div class=\"entry-content clearfix\">\n<p><span>The Excel (Dashboard) control panel allows you to see all important parameters that you monitor in business on one screen.\u00a0We should certainly not forget the definition: &#8220;A dashboard is a visual representation of the most important information needed to achieve a goal or goals.&#8221;\u00a0Consolidated and organized on one screen for one view.\u201d\u00a0if you want to delve deeper into this topic do so from\u00a0<\/span><a href=\"https:\/\/www.amazon.com\/Stephen-Few\/e\/B001H6IQ5M\"><span>Stephen Few<\/span><\/a><span>\u00a0father of the dashboard.<\/span><\/p>\n<p><span>Now I have to say that in the &#8220;endless&#8221; sea of \u200b\u200bwebsites you can find just as many smart tips on how to make a good Excel dashboard.\u00a0A lot of that content more or less states the basic principles.\u00a0Which should be followed when creating a dashboard.\u00a0That&#8217;s why I will list here those principles that, in our opinion, are sufficient to create a control panel.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Creating_an_Excel_Dashboard_control_panel\"><\/span><span id=\"Izrada_Excel_Dashboard_kontrolne_table\" class=\"ez-toc-section\"><\/span><span>Creating an Excel (Dashboard) control panel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Keep in mind that you don&#8217;t have to be a designer to create a useful dashboard, so keep in mind:<\/span><\/p>\n<ol>\n<li><span>Auditorium &#8211; for whom it is intended;<\/span><\/li>\n<li><span>Which information is important and which is desirable;<\/span><\/li>\n<li><span>Display numbers in thousands.\u00a0million billion;<\/span><\/li>\n<li><span>\u00a0Group information;<\/span><\/li>\n<li><span>Avoid decorative elements but use red and green to let the audience know if it&#8217;s okay or not;<\/span><\/li>\n<\/ol>\n<h2><span class=\"ez-toc-section\" id=\"Best_practices_for_dashboard_design\"><\/span><span id=\"Najbol%D1%98e_prakse_za_dizajn_kontrolne_table\" class=\"ez-toc-section\"><\/span><strong><span>Best practices for dashboard design<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>So we strive for a dashboard design that displays actionable metrics from real-time data sources and displays business goals in a single window.<\/span><\/p>\n<p><span>It sounds quite challenging, and it is.\u00a0But with these basic dashboard design tips, you&#8217;ll be presenting your data professionally in no time.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Determine_the_purpose_of_the_dashboard\"><\/span><span id=\"Odredite_svrhu_kontrolne_table\" class=\"ez-toc-section\"><\/span><strong><span>Determine the purpose of the dashboard<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span>To accurately display information on a dashboard, you must first determine the purpose it will serve.\u00a0Dashboards are divided into several categories based on their purpose.\u00a0The broadest and most common categories are analytical dashboards and operational dashboards.\u00a0They can also have a narrower category, such as financial dashboards,\u00a0\u00a0<\/span><strong><span>sales dashboards<\/span><\/strong><span>\u00a0, and even strategic dashboards.<\/span><\/p>\n<p><span>The main goal of operational dashboards is to quickly and clearly convey relevant information to users who need to take immediate action.\u00a0They are time sensitive and help users to be proactive and efficient.<\/span><\/p>\n<p><strong><span>Dashboard Example:<\/span><\/strong><span>\u00a0\u00a0This Shopifi + Google Analytics dashboard was created to track the achievement of sales goals.\u00a0From it, you can easily read data about your website&#8217;s active users, total sales and sales goals, conversion rate, and more &#8211; all in one window.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.whatagraph.com\/storage\/photos\/shares\/website\/dashboard-design-for-shopify.png\" alt=\"Dashboard design for Shopify\" width=\"1419\" height=\"810\" \/><\/p>\n<p><span>Analytical dashboards, on the other hand, are less time-sensitive and focus on helping readers analyze trends, make the most of data, and\u00a0\u00a0\u00a0<\/span><a href=\"https:\/\/whatagraph.com\/blog\/articles\/sales-dashboard\"><span>drive decision-making<\/span><\/a><span>\u00a0\u00a0.\u00a0These two categories can have two completely different approaches to dashboard design.<\/span><\/p>\n<p><span>When designing any of these dashboard formats, think about what users expect to see.\u00a0If their focus is on time-sensitive data, choose appropriate metrics with a visual-first approach without going into too much detail.<\/span><\/p>\n<p><span>On the other hand, if your dashboard is analytical and used to drive business strategies, you can afford to go into more detail.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Simple_shape\"><\/span><span id=\"Jednostavan_oblik\" class=\"ez-toc-section\"><\/span><strong><span>Simple shape<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span>For a great dashboard design, one of the main goals is to present relevant information in a simple and easy-to-understand form.<\/span><\/p>\n<p><span>So don&#8217;t present too much information or use multiple columns to do this.\u00a0Get rid of all the redundant information.\u00a0Use white space, leaving just enough for the viewer to understand the structure of the data.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Consistency_%E2%80%93_type_solution\"><\/span><span id=\"Doslednost_-_tipsko_resenje\" class=\"ez-toc-section\"><\/span><strong><span>Consistency &#8211; type solution<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span>Your overall dashboard design must remain consistent.\u00a0Once you determine the purpose of the dashboard, establish its visual hierarchy and form, you cannot suddenly change these rules.\u00a0Data is only one part of the overall consistency.\u00a0You can&#8217;t control what marketing channels produce as data, but you can control how you design and present relevant data.<\/span><\/p>\n<p><span>Consistency comes in many forms.\u00a0Little things like following consistent date formatting and naming conventions can make things easier for the user.\u00a0Presenting data in line charts, pie charts,\u00a0\u00a0<\/span><a href=\"https:\/\/chartexpo.com\/charts\/radar-chart\"><span>radar charts<\/span><\/a><span>\u00a0, and bar charts of the same style will also help the user process the data more accessible.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Vicinity\"><\/span><span id=\"Blizina\" class=\"ez-toc-section\"><\/span><strong><span>Vicinity<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span>To help readers understand information more easily and quickly, you should display related details closer together instead of scattering them all over the dashboard.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Harmonization\"><\/span><span id=\"Uskladivanje\" class=\"ez-toc-section\"><\/span><strong><span>Harmonization<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span>Dashboard elements should be coordinated with each other for a balanced look that allows for a good user experience.\u00a0Grids allow you to achieve effective consistency and alignment and create a template for your dashboard design.<\/span><\/p>\n<p><strong><span>Example dashboard:<\/span><\/strong><span>\u00a0\u00a0here you see a perfectly aligned grid.\u00a02\/3 of the dashboard shows performance over a longer period of time across different dimensions.\u00a0The 1\/3 of the dashboard on the right is neatly stacked to display only the most relevant statistics needed for insight.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.whatagraph.com\/storage\/photos\/shares\/website\/youtube-dashboard-design.png\" alt=\"Control panel design for YouTube channel\" width=\"1440\" height=\"824\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Space\"><\/span><span id=\"Razmak\" class=\"ez-toc-section\"><\/span><strong><span>Space<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span>Spacing plays an important role in the design of your dashboard.\u00a0It allows the reader to take a break from looking at all the information and leaves more time to process the data.\u00a0Using white space prevents clutter and helps you visually group related information.\u00a0You may have heard it referred to as negative space.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Color\"><\/span><span id=\"Boja\" class=\"ez-toc-section\"><\/span><strong><span>Color<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span>Color plays a significant role in effective dashboard design.\u00a0Choosing the right colors and using maximum contrast can help you guide the reader through information in a simple and easy-to-understand way.\u00a0It can make content easier to read.\u00a0So, take care of contrasting colors and avoid using ineffective gradients.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Fontovi-2\"><\/span><span id=\"Fontovi\" class=\"ez-toc-section\"><\/span><strong><span>Fontovi<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span>Unless there is a reason to use a specific font, use the standard ones for dashboard content.\u00a0They are easier to scan, read and understand.\u00a0Don&#8217;t use ALL caps as it makes it harder to read.<\/span><\/p>\n<p><span>So, choose a standard font of an appropriate size to present the information.\u00a0Fonts like Times New Roman, Arial, Roboto and Calibri will do the trick.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Number_formats\"><\/span><span id=\"Formati_brojeva\" class=\"ez-toc-section\"><\/span><strong><span>Number formats<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span>Use round numbers instead of long numbers whenever possible to avoid confusing the reader.\u00a0Don&#8217;t forget to add the note that &#8220;numbers may not add up due to rounding&#8221;.\u00a0It&#8217;s a simple way to explain why sometimes pie charts don&#8217;t contain a hundred or so cases.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Labels\"><\/span><span id=\"Etikete\" class=\"ez-toc-section\"><\/span><strong><span>Labels<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span>Rotated labels are generally harder to read and absorb for the human mind.\u00a0So use labels that communicate information quickly and efficiently.\u00a0Standard abbreviations should be used whenever possible.<\/span><\/p>\n<p><strong><span>Dashboard Example:<\/span><\/strong><span>\u00a0In this LinkedIn dashboard, all the numbers and charts are labeled with a word or two.\u00a0This makes the dashboard look uncluttered and less intimidating, while still providing essential information.<\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.whatagraph.com\/storage\/photos\/shares\/website\/linkedin-dashboard-design.png\" alt=\"Dashboard design for LinkedIn channel\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Personalization_and_customization\"><\/span><span id=\"Personalizacija_i_prilagodavanje\" class=\"ez-toc-section\"><\/span><strong><span>Personalization and customization<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span>Readers expect to find relevant information on their dashboard, and two techniques that make this happen are personalization and customization.<\/span><\/p>\n<p><span>Personalization is when you create a dashboard design that adheres to your client&#8217;s brand image.\u00a0This could mean adding\u00a0\u00a0<\/span><a href=\"https:\/\/designcrowd.com\/logo-design\/\"><span>a logo design<\/span><\/a><span>\u00a0\u00a0, choosing appropriate chart colors, or adding specific labels to metrics or channels.<\/span><\/p>\n<p><span>Customization is adjusting the dashboard design to display relevant data and various key metrics.\u00a0This may mean rearranging the dashboard assets to present the data in a different way.\u00a0Or select and highlight different KPIs to suit the client&#8217;s interest.<\/span><\/p>\n<p><span>When designing dashboards, both personalization and customization should work in tandem.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tables_or_lists_of_data\"><\/span><span id=\"Tabele_ili_liste_podataka\" class=\"ez-toc-section\"><\/span><strong><span>Tables or lists of data<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span>Integrating\u00a0\u00a0\u00a0<\/span><span>data tables\u00a0<\/span><span>\u00a0\u00a0is useful when you have a lot of information for different items to present.\u00a0They are the best way to present information such as a list of clients with their ID, last activity, contacts, status, etc.<\/span><\/p>\n<p><span>Data tables provide easy scalability, good space utilization and can make the design process less complicated.\u00a0They are easy to work with, as most people have experience working with Microsoft Excel.\u00a0Just make tables and lists less intimidating!<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"They_disappeared\"><\/span><span id=\"Da_sumiram\" class=\"ez-toc-section\"><\/span><strong><span>They disappeared<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span>Dashboards should deliver complex data in a simple way that would save time and effort.\u00a0They should be structured in a way that will maintain a visual hierarchy.\u00a0Whether or not it will serve this purpose depends on the design of the dashboard, which should be goal and user oriented.<\/span><\/p>\n<p><span>While every dashboard has a unique goal, limitations, and requirements, following these best practices will help you create great dashboard designs.<\/span><\/p>\n<p><span>To avoid\u00a0<\/span><a href=\"https:\/\/kalkulacija.com\/wordpress\/dashboard\/\"><span>Dashboard &#8211; Beginner mistakes<\/span><\/a><span>\u00a0, see the text of the same name on our website.<\/span><\/p>\n<\/div>\n\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-right kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;right&quot;,&quot;id&quot;:&quot;3652&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;2&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (2 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;Excel Dashboards Tutorial \\u0026amp; Templates&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (2 votes)    <\/div>\n    <\/div>","protected":false},"excerpt":{"rendered":"<p>EXCEL (DASHBOARD) CONTROL PANEL INSTRUCTIONS AND SAMPLE FILES The Excel (Dashboard) control panel allows you to see all important parameters<\/p>\n","protected":false},"author":1,"featured_media":3651,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[46,15,62],"tags":[],"class_list":["post-3652","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dashboard","category-kalkulacija","category-microsoft-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel Dashboard kontrolna tabla uputstvo i primer datoteke<\/title>\n<meta name=\"description\" content=\"Excel (Dashboard) kontrolna tabla omogu\u0107ava da na jednom ekranu vidite sve bitne parametre koje pratite u poslovanju.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Dashboard kontrolna tabla uputstvo i primer datoteke\" \/>\n<meta property=\"og:description\" content=\"Excel (Dashboard) kontrolna tabla omogu\u0107ava da na jednom ekranu vidite sve bitne parametre koje pratite u poslovanju.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/\" \/>\n<meta property=\"og:site_name\" content=\"Calculation in essence of everything!\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-01T21:40:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-06T10:52:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/kt00.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1103\" \/>\n\t<meta property=\"og:image:height\" content=\"655\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\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=\"17 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"Excel Dashboards Tutorial &#038; Templates\",\"datePublished\":\"2022-12-01T21:40:17+00:00\",\"dateModified\":\"2022-12-06T10:52:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/\"},\"wordCount\":3423,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/kt00.png\",\"articleSection\":[\"Dashboard - command desk\",\"Calculation\",\"Microsoft\u00ae Excel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/\",\"name\":\"Excel Dashboard kontrolna tabla uputstvo i primer datoteke\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/kt00.png\",\"datePublished\":\"2022-12-01T21:40:17+00:00\",\"dateModified\":\"2022-12-06T10:52:28+00:00\",\"description\":\"Excel (Dashboard) kontrolna tabla omogu\u0107ava da na jednom ekranu vidite sve bitne parametre koje pratite u poslovanju.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/kt00.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/kt00.png\",\"width\":1103,\"height\":655,\"caption\":\"Dashboard - po\u010detni\u010dke gre\u0161ke\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/excel-dashboard\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel (Dashboard) kontrolna tabla uputstvo i primer datoteke\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\",\"name\":\"Calculation in essence of everything!\",\"description\":\"Go ahead! Improve your data processing skills!\",\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"width\":128,\"height\":128,\"caption\":\"admin\"},\"logo\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Dashboard kontrolna tabla uputstvo i primer datoteke","description":"Excel (Dashboard) kontrolna tabla omogu\u0107ava da na jednom ekranu vidite sve bitne parametre koje pratite u poslovanju.","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:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/","og_locale":"en_US","og_type":"article","og_title":"Excel Dashboard kontrolna tabla uputstvo i primer datoteke","og_description":"Excel (Dashboard) kontrolna tabla omogu\u0107ava da na jednom ekranu vidite sve bitne parametre koje pratite u poslovanju.","og_url":"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/","og_site_name":"Calculation in essence of everything!","article_published_time":"2022-12-01T21:40:17+00:00","article_modified_time":"2022-12-06T10:52:28+00:00","og_image":[{"width":1103,"height":655,"url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/kt00.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"17 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"Excel Dashboards Tutorial &#038; Templates","datePublished":"2022-12-01T21:40:17+00:00","dateModified":"2022-12-06T10:52:28+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/"},"wordCount":3423,"commentCount":0,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/kt00.png","articleSection":["Dashboard - command desk","Calculation","Microsoft\u00ae Excel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/","url":"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/","name":"Excel Dashboard kontrolna tabla uputstvo i primer datoteke","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/kt00.png","datePublished":"2022-12-01T21:40:17+00:00","dateModified":"2022-12-06T10:52:28+00:00","description":"Excel (Dashboard) kontrolna tabla omogu\u0107ava da na jednom ekranu vidite sve bitne parametre koje pratite u poslovanju.","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#primaryimage","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/kt00.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/kt00.png","width":1103,"height":655,"caption":"Dashboard - po\u010detni\u010dke gre\u0161ke"},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/excel-dashboard\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Excel (Dashboard) kontrolna tabla uputstvo i primer datoteke"}]},{"@type":"WebSite","@id":"https:\/\/kalkulacija.com\/wordpress\/#website","url":"https:\/\/kalkulacija.com\/wordpress\/","name":"Calculation in essence of everything!","description":"Go ahead! Improve your data processing skills!","publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kalkulacija.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","width":128,"height":128,"caption":"admin"},"logo":{"@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png"}}]}},"_links":{"self":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/3652","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/comments?post=3652"}],"version-history":[{"count":28,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/3652\/revisions"}],"predecessor-version":[{"id":3684,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/3652\/revisions\/3684"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media\/3651"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media?parent=3652"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/categories?post=3652"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/tags?post=3652"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}