{"id":895,"date":"2014-04-10T08:27:36","date_gmt":"2014-04-10T08:27:36","guid":{"rendered":"http:\/\/agile.logihelgu.com\/?p=895"},"modified":"2014-04-10T08:37:50","modified_gmt":"2014-04-10T08:37:50","slug":"online-sprint-burndown-chart","status":"publish","type":"post","link":"https:\/\/logihelgu.com\/agile\/online-sprint-burndown-chart\/","title":{"rendered":"Online Sprint Burndown chart"},"content":{"rendered":"<p><a href=\"http:\/\/logihelgu.com\/agile\/wp-content\/uploads\/2014\/04\/photo-2.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/logihelgu.com\/agile\/wp-content\/uploads\/2014\/04\/photo-2.png\" alt=\"Daily Scrum\" width=\"1024\" height=\"768\" class=\"alignleft size-full wp-image-897\" srcset=\"https:\/\/logihelgu.com\/agile\/wp-content\/uploads\/2014\/04\/photo-2.png 1024w, https:\/\/logihelgu.com\/agile\/wp-content\/uploads\/2014\/04\/photo-2-600x450.png 600w, https:\/\/logihelgu.com\/agile\/wp-content\/uploads\/2014\/04\/photo-2-188x141.png 188w, https:\/\/logihelgu.com\/agile\/wp-content\/uploads\/2014\/04\/photo-2-494x370.png 494w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a>When keeping track of the sprint burndown it&#8217;s often good (or ever required) that you show that process on a daily bases.  In my case I have a wiki page for each sprint and want to have the daily burndown there updated every day.<\/p>\n<p>So I created a simple <a href=\"https:\/\/docs.google.com\/spreadsheet\/ccc?key=0AplH3SVTsdUbdHNIZENjSXM5NE1KQU5DRG5UVHBPX0E&#038;usp=sharing\">Google Spreadsheet for Sprint Daily Burndown<\/a>.  There I create a new tab for each sprint using the TEMPLATE as the base (or just duplicate an old one).  <\/p>\n<h3>How to set this up<\/h3>\n<p>We were running weekly sprints so there are only 5 days on the template now.  <\/p>\n<ul>\n<li>Start off by duplicating the TEMPLATE sheet (the small triangle on the right site of the Sheets name).\n<li>Set the Sprint name\n<li>Fill out the total plan (story points) in the first <strong>Planned remaining<\/strong> column (C3), this is your total burndown &#8220;plan&#8221; for the sprint.\n<li>Then you have to set how much you plan to have burnt the first day in the second column of <strong>Planned Daily Burndown<\/strong> (D4).  <i>The reason for this is that we had SPM on Mondays so the planned burndown was always lower on Mondays and we decided that each sprint \ud83d\ude09<\/i>\n<li>The rest of the Planned Daily Burndown is just divided evenly automatically, but you can change that if you need to.\n<li>Then every day you insert the <strong>Daily Burndown<\/strong> on your Daily Standup Meeting (Daily Scrum) accordingly and the Chart below is updated.\n<\/ul>\n<h3>Sharing the Chart<\/h3>\n<p>The sweet part is that you can publish the Chart as an image and place on your wiki or webpage and the image is update each time you fill out new numbers.  <i>Very handy when you have a sprint page that you wan&#8217;t to display the process of the sprint =)<\/i><\/p>\n<ul>\n<li>Click the chart and in the right corner click the triangle and select <strong>Publish chart<\/strong>\n<li>In the <i>Select a publish format<\/i> select <strong>Image<\/strong>\n<li>Copy the URL for the image and pate wherever you desire =)\n<\/ul>\n<p>Feel free to <i>make a copy<\/i> and edit your own, I&#8217;d love to hear if this helps or if you anything else to tell me about this \ud83d\ude09<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When keeping track of the sprint burndown it&#8217;s often good (or ever required) that you show that process on a daily bases. In my case I have a wiki page for each sprint and want to have the daily burndown there updated every day. So I created a simple Google Spreadsheet for Sprint Daily Burndown. [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[63,58],"tags":[],"class_list":["post-895","post","type-post","status-publish","format-standard","hentry","category-scrum","category-tools"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Online Sprint Burndown chart - Logi Helgu<\/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:\/\/logihelgu.com\/agile\/online-sprint-burndown-chart\/\" \/>\n<meta property=\"og:locale\" content=\"is_IS\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Online Sprint Burndown chart - Logi Helgu\" \/>\n<meta property=\"og:description\" content=\"When keeping track of the sprint burndown it&#8217;s often good (or ever required) that you show that process on a daily bases. In my case I have a wiki page for each sprint and want to have the daily burndown there updated every day. So I created a simple Google Spreadsheet for Sprint Daily Burndown. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/logihelgu.com\/agile\/online-sprint-burndown-chart\/\" \/>\n<meta property=\"og:site_name\" content=\"Logi Helgu\" \/>\n<meta property=\"article:published_time\" content=\"2014-04-10T08:27:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-04-10T08:37:50+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/logihelgu.com\/agile\/wp-content\/uploads\/2014\/04\/photo-2.png\" \/>\n<meta name=\"author\" content=\"Logi Helgu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Logi Helgu\" \/>\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:\\\/\\\/logihelgu.com\\\/agile\\\/online-sprint-burndown-chart\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/logihelgu.com\\\/agile\\\/online-sprint-burndown-chart\\\/\"},\"author\":{\"name\":\"Logi Helgu\",\"@id\":\"https:\\\/\\\/logihelgu.com\\\/agile\\\/#\\\/schema\\\/person\\\/e1fbe6bdbfc88ffb91456d1795cfb191\"},\"headline\":\"Online Sprint Burndown chart\",\"datePublished\":\"2014-04-10T08:27:36+00:00\",\"dateModified\":\"2014-04-10T08:37:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/logihelgu.com\\\/agile\\\/online-sprint-burndown-chart\\\/\"},\"wordCount\":354,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/logihelgu.com\\\/agile\\\/#\\\/schema\\\/person\\\/e1fbe6bdbfc88ffb91456d1795cfb191\"},\"image\":{\"@id\":\"https:\\\/\\\/logihelgu.com\\\/agile\\\/online-sprint-burndown-chart\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/logihelgu.com\\\/agile\\\/wp-content\\\/uploads\\\/2014\\\/04\\\/photo-2.png\",\"articleSection\":[\"Scrum\",\"Tools\"],\"inLanguage\":\"is\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/logihelgu.com\\\/agile\\\/online-sprint-burndown-chart\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/logihelgu.com\\\/agile\\\/online-sprint-burndown-chart\\\/\",\"url\":\"https:\\\/\\\/logihelgu.com\\\/agile\\\/online-sprint-burndown-chart\\\/\",\"name\":\"Online Sprint Burndown chart - Logi Helgu\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/logihelgu.com\\\/agile\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/logihelgu.com\\\/agile\\\/online-sprint-burndown-chart\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/logihelgu.com\\\/agile\\\/online-sprint-burndown-chart\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/logihelgu.com\\\/agile\\\/wp-content\\\/uploads\\\/2014\\\/04\\\/photo-2.png\",\"datePublished\":\"2014-04-10T08:27:36+00:00\",\"dateModified\":\"2014-04-10T08:37:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/logihelgu.com\\\/agile\\\/online-sprint-burndown-chart\\\/#breadcrumb\"},\"inLanguage\":\"is\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/logihelgu.com\\\/agile\\\/online-sprint-burndown-chart\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"is\",\"@id\":\"https:\\\/\\\/logihelgu.com\\\/agile\\\/online-sprint-burndown-chart\\\/#primaryimage\",\"url\":\"http:\\\/\\\/logihelgu.com\\\/agile\\\/wp-content\\\/uploads\\\/2014\\\/04\\\/photo-2.png\",\"contentUrl\":\"http:\\\/\\\/logihelgu.com\\\/agile\\\/wp-content\\\/uploads\\\/2014\\\/04\\\/photo-2.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/logihelgu.com\\\/agile\\\/online-sprint-burndown-chart\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/logihelgu.com\\\/agile\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Online Sprint Burndown chart\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/logihelgu.com\\\/agile\\\/#website\",\"url\":\"https:\\\/\\\/logihelgu.com\\\/agile\\\/\",\"name\":\"Logi Helgu\",\"description\":\"Being Agile\",\"publisher\":{\"@id\":\"https:\\\/\\\/logihelgu.com\\\/agile\\\/#\\\/schema\\\/person\\\/e1fbe6bdbfc88ffb91456d1795cfb191\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/logihelgu.com\\\/agile\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"is\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/logihelgu.com\\\/agile\\\/#\\\/schema\\\/person\\\/e1fbe6bdbfc88ffb91456d1795cfb191\",\"name\":\"Logi Helgu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"is\",\"@id\":\"https:\\\/\\\/logihelgu.com\\\/agile\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/logihelgu_gamlirokkarinn.jpg\",\"url\":\"https:\\\/\\\/logihelgu.com\\\/agile\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/logihelgu_gamlirokkarinn.jpg\",\"contentUrl\":\"https:\\\/\\\/logihelgu.com\\\/agile\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/logihelgu_gamlirokkarinn.jpg\",\"width\":716,\"height\":501,\"caption\":\"Logi Helgu\"},\"logo\":{\"@id\":\"https:\\\/\\\/logihelgu.com\\\/agile\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/logihelgu_gamlirokkarinn.jpg\"},\"url\":\"https:\\\/\\\/logihelgu.com\\\/agile\\\/author\\\/logihelgu\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Online Sprint Burndown chart - Logi Helgu","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:\/\/logihelgu.com\/agile\/online-sprint-burndown-chart\/","og_locale":"is_IS","og_type":"article","og_title":"Online Sprint Burndown chart - Logi Helgu","og_description":"When keeping track of the sprint burndown it&#8217;s often good (or ever required) that you show that process on a daily bases. In my case I have a wiki page for each sprint and want to have the daily burndown there updated every day. So I created a simple Google Spreadsheet for Sprint Daily Burndown. [&hellip;]","og_url":"https:\/\/logihelgu.com\/agile\/online-sprint-burndown-chart\/","og_site_name":"Logi Helgu","article_published_time":"2014-04-10T08:27:36+00:00","article_modified_time":"2014-04-10T08:37:50+00:00","og_image":[{"url":"http:\/\/logihelgu.com\/agile\/wp-content\/uploads\/2014\/04\/photo-2.png","type":"","width":"","height":""}],"author":"Logi Helgu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Logi Helgu","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/logihelgu.com\/agile\/online-sprint-burndown-chart\/#article","isPartOf":{"@id":"https:\/\/logihelgu.com\/agile\/online-sprint-burndown-chart\/"},"author":{"name":"Logi Helgu","@id":"https:\/\/logihelgu.com\/agile\/#\/schema\/person\/e1fbe6bdbfc88ffb91456d1795cfb191"},"headline":"Online Sprint Burndown chart","datePublished":"2014-04-10T08:27:36+00:00","dateModified":"2014-04-10T08:37:50+00:00","mainEntityOfPage":{"@id":"https:\/\/logihelgu.com\/agile\/online-sprint-burndown-chart\/"},"wordCount":354,"commentCount":1,"publisher":{"@id":"https:\/\/logihelgu.com\/agile\/#\/schema\/person\/e1fbe6bdbfc88ffb91456d1795cfb191"},"image":{"@id":"https:\/\/logihelgu.com\/agile\/online-sprint-burndown-chart\/#primaryimage"},"thumbnailUrl":"http:\/\/logihelgu.com\/agile\/wp-content\/uploads\/2014\/04\/photo-2.png","articleSection":["Scrum","Tools"],"inLanguage":"is","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/logihelgu.com\/agile\/online-sprint-burndown-chart\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/logihelgu.com\/agile\/online-sprint-burndown-chart\/","url":"https:\/\/logihelgu.com\/agile\/online-sprint-burndown-chart\/","name":"Online Sprint Burndown chart - Logi Helgu","isPartOf":{"@id":"https:\/\/logihelgu.com\/agile\/#website"},"primaryImageOfPage":{"@id":"https:\/\/logihelgu.com\/agile\/online-sprint-burndown-chart\/#primaryimage"},"image":{"@id":"https:\/\/logihelgu.com\/agile\/online-sprint-burndown-chart\/#primaryimage"},"thumbnailUrl":"http:\/\/logihelgu.com\/agile\/wp-content\/uploads\/2014\/04\/photo-2.png","datePublished":"2014-04-10T08:27:36+00:00","dateModified":"2014-04-10T08:37:50+00:00","breadcrumb":{"@id":"https:\/\/logihelgu.com\/agile\/online-sprint-burndown-chart\/#breadcrumb"},"inLanguage":"is","potentialAction":[{"@type":"ReadAction","target":["https:\/\/logihelgu.com\/agile\/online-sprint-burndown-chart\/"]}]},{"@type":"ImageObject","inLanguage":"is","@id":"https:\/\/logihelgu.com\/agile\/online-sprint-burndown-chart\/#primaryimage","url":"http:\/\/logihelgu.com\/agile\/wp-content\/uploads\/2014\/04\/photo-2.png","contentUrl":"http:\/\/logihelgu.com\/agile\/wp-content\/uploads\/2014\/04\/photo-2.png"},{"@type":"BreadcrumbList","@id":"https:\/\/logihelgu.com\/agile\/online-sprint-burndown-chart\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/logihelgu.com\/agile\/"},{"@type":"ListItem","position":2,"name":"Online Sprint Burndown chart"}]},{"@type":"WebSite","@id":"https:\/\/logihelgu.com\/agile\/#website","url":"https:\/\/logihelgu.com\/agile\/","name":"Logi Helgu","description":"Being Agile","publisher":{"@id":"https:\/\/logihelgu.com\/agile\/#\/schema\/person\/e1fbe6bdbfc88ffb91456d1795cfb191"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/logihelgu.com\/agile\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"is"},{"@type":["Person","Organization"],"@id":"https:\/\/logihelgu.com\/agile\/#\/schema\/person\/e1fbe6bdbfc88ffb91456d1795cfb191","name":"Logi Helgu","image":{"@type":"ImageObject","inLanguage":"is","@id":"https:\/\/logihelgu.com\/agile\/wp-content\/uploads\/2020\/12\/logihelgu_gamlirokkarinn.jpg","url":"https:\/\/logihelgu.com\/agile\/wp-content\/uploads\/2020\/12\/logihelgu_gamlirokkarinn.jpg","contentUrl":"https:\/\/logihelgu.com\/agile\/wp-content\/uploads\/2020\/12\/logihelgu_gamlirokkarinn.jpg","width":716,"height":501,"caption":"Logi Helgu"},"logo":{"@id":"https:\/\/logihelgu.com\/agile\/wp-content\/uploads\/2020\/12\/logihelgu_gamlirokkarinn.jpg"},"url":"https:\/\/logihelgu.com\/agile\/author\/logihelgu\/"}]}},"_links":{"self":[{"href":"https:\/\/logihelgu.com\/agile\/wp-json\/wp\/v2\/posts\/895","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/logihelgu.com\/agile\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/logihelgu.com\/agile\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/logihelgu.com\/agile\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/logihelgu.com\/agile\/wp-json\/wp\/v2\/comments?post=895"}],"version-history":[{"count":5,"href":"https:\/\/logihelgu.com\/agile\/wp-json\/wp\/v2\/posts\/895\/revisions"}],"predecessor-version":[{"id":901,"href":"https:\/\/logihelgu.com\/agile\/wp-json\/wp\/v2\/posts\/895\/revisions\/901"}],"wp:attachment":[{"href":"https:\/\/logihelgu.com\/agile\/wp-json\/wp\/v2\/media?parent=895"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/logihelgu.com\/agile\/wp-json\/wp\/v2\/categories?post=895"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/logihelgu.com\/agile\/wp-json\/wp\/v2\/tags?post=895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}