Skip to the content
Pragmatic Coders
  • Services
        • All Services
        • Software Development
          • Web & Cloud App Development
          • Mobile Application Development
          • No-Code Development
          • Blockchain Development
          • DevOps Services
        • Custom Fintech Software
          • Trading Software Development
          • Insurance Software Development
          • Custom Banking Software
          • Custom Financial Software
          • Mobile Banking App Development
        • Custom Healthcare Software
          • Patient Portal Development
          • Telehealth App Development
          • Custom Physical Therapy Apps
          • Custom Telemedicine Software
          • Custom Patient Engagement Apps
        • AI Software Development
          • AI Agents Development
          • AI Integration Services
          • AI Data Solutions
        • Product Design
          • UX Research
          • UX Design
          • UI Design
        • IT outsourcing
          • Nearshore Outsourcing
          • Offshore Outsourcing
          • Build Operate Transfer
  • Industries
        • All Industries
        • Fintech
        • Digital Health
        • E-commerce
        • Entertainment
        • Custom Software Development Services
        • Business Consulting
  • Case Studies
        • All Case Studies
        • FintechExplore our curated fintech case studies, showcasing the cutting-edge software solutions we’ve developed to revolutionize the financial technology landscape.
          • Atom Bank - One Of UK's Top Challenger Banks
          • KodyPay - Payment Platform
          • BLOC-X - OTC Commodity Trading
        • Blockchain
          • Common Wealth: Web3 investing platform
          • UltiArena: Play-to-Earn NFT Hub
          • EXCC - Developing New Blockchain
        • Digital HealthBrowse through our digital health case studies, illustrating how our technology innovations are transforming healthcare, enhancing patient outcomes, and streamlining medical processes with bespoke software solutions.
          • WithHealth - Medical Platform
          • AccentPharm - Medical Translations
          • Health Folder - Medical Documentation Management
        • E-commerce/RetailDiscover our e-commerce case studies, highlighting our development of scalable, user-centric platforms that boost sales, enhance the shopping experience, and streamline operations in the digital marketplace.
          • Kitopi - Smart Kitchen
          • Webinterpret - Cross-platform E-commerce
          • Photochain: Decentralized photo marketplace
        • EntertainmentExplore our case studies in entertainment projects, where creativity converges with technology to create immersive and engaging digital experiences that captivate audiences globally.
          • Unlocked - Events Management
          • Duel - Social Media App
          • OnLive: Decentralized streaming platform
        • AIDive into our AI case studies to discover how artificial intelligence is applied to solve complex challenges, improve decision-making, and increase efficiency across various industries with our advanced solutions.
          • Accounting Automation
          • US Patient Care Platform | AI & Data Science
  • About us
        • About us
        • Meet Our Team
        • How We Work
        • Become a Partner
        • News
        • Join Us!
  • Blog
        • All curated categories
        • FintechInterested in the development of a new custom fintech product? Check our articles about new fintech trends and fintech product development. If you are looking for experienced fintech software development partners do not forget to check our fintech software development services. You may also find interesting our blockchain development services.
        • Digital HealthDigital health encompasses the use of technology and data to improve healthcare delivery and patient outcomes. If you want to build a digital health app, check out our healthcare software development services.
        • Blockchain
        • AI
        • Product Development
        • Product Management
        • Product DesignA successful product needs to be well planned and tested by its users as early as possible. Here we share our knowledge and experience from more than 60 startups we helped build in the last years.
        • Agile & Scrum
        • Startup
        • Outsourcing & Collaboration
  • Resources
        • All Resources
        • Tools
          • Market Insights AI
        • Guides
          • Fintech guide
          • Digital health guide
          • Insurtech guide
          • AI trends
        • Other
          • Newsletter
          • Glossary
          • Product Health Checklist
          • Best AI for coding in 2025: AI tools for developers
          • 60 startup business model patterns for 2025
        • Ebooks
          • How to start a startup
          • How to go live with your product in less than 3 months
        • Video
          • Podcast
          • Webinars
  • Contact us
Congrats, you are up to date! Now you can impress your friends with your cutting-edge knowledge.
Mark all as read
Contact Us
Home Pragmatic Blog Agile Build your own Scrum tool
Agile
Mar 14,2016
4 min read

Build your own Scrum tool

Build your own Scrum tool

Have you ever considered that the tools which you are using may determine the way how do you work? Especially the Scrum tool which you use might determine how good your Scrum really is.

Most of the Scrum tools are the way too complex

I hate complexity. I hate unnecessary complexity. I hate unnecessary complexity, especially in Agile. This is why in my opinion most of the available “agile” and Scrum tools are not so Agile. For example tools like Jira have been created for top managers who like to watch charts and numbers which usually are far away from reality and to be honest, are not helpful at all. Of course, we use Jira if needed but we are trying to do this in the simplest way possible.

There are also a few good agile tools for example Trello. Trello is great as a task board but sometimes you may need something more. This is why I decided to try to use a simple google spreadsheet where we could keep our Sprint Backlog and track the progress. We have done a few tests with our teams and I would like to share with you the effect of two hours of playing with google scripts which might be helpful for you.

The spreadsheet you may find here. Please note that you have to be logged in to use this tool. If you want to play with it, it would be great if you could make a copy first and play with the copy.

You may notice that in the menu I’ve added two more options: Sprint -> Start Sprint and Sprint -> Archive Sprint this is what makes this spreadsheet a Scrum tool.

How does this Scrum tool work?

We are starting by creating Sprint Backlog. Sprint Backlog is a plan for the next iteration. From my experience, the best way to do that plan is to prepare a set of user stories and then split each of them into small tasks which you can estimate in hours [Hours Estimated]. Then copy the Hours Estimated column into the Hours Remaining column and you are ready to start Sprint by choosing from the menu Sprint->Start Sprint. It will create the starting point for your Sprint Burndown Chart. Every day your team should update the remaining hours for each task. Remember that in Scrum we are not tracking how many work hours were spent on each task but are rather focused on how much work still remains to be done. The spreadsheet which I have created will update the burndown chart every night. At the end of Sprint, you may archive it by clicking Sprint -> Archive Sprint – it will create a new tab with archived Sprint details and clean up the current Sprint.

How to build your own Scrum tool?

The spreadsheet which I’ve shared with you is just a demo – the starting point for you is to build your own tool which will be dedicated exactly to your team’s needs.

Below you can find the (ugly) code which I’ve used in this spreadsheet. You can copy it and paste it into Tools->Script Editor in your own spreadsheet. Then you can play with it as you want.

function recordHistory() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var backlog = ss.getSheetByName("Sprint Backlog");
var burndown = ss.getSheetByName("Burndown Chart");
var source = backlog.getRange("E1:F1");
var values = source.getValues();
var startingValue = values[0][1];
values[0][0] = new Date();
var lastValue = burndown.getRange("B1").getValue();

if (!lastValue) {
lastValue = values[0][1];
}

var expectedValue;
var lastRowNumber = burndown.getLastRow();
if (lastRowNumber == 0) {
expectedValue = lastValue;
} else {
expectedValue = startingValue - startingValue/9*(lastRowNumber-1);
}
values[0][2] = expectedValue;
values[0];
burndown.appendRow(values[0]);

}

function archiveSprint() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var backlog = ss.getSheetByName("Sprint Backlog");
var burndown = ss.getSheetByName("Burndown Chart");
var today = new Date();
var archivedSprint = ss.insertSheet();
var oldBacklogValues = backlog.getRange("A1:H99").getValues();
for (i=0; i< oldBacklogValues.length; i++) {
archivedSprint.appendRow(oldBacklogValues[i]);
<code>};
var oldBurndownChart = burndown.getRange("A1:H20").getValues();
for (i=0; i < oldBurndownChart.length; i++) {
archivedSprint.appendRow(oldBurndownChart[i]);
<code>};

backlog.getRange("A2:H99").clear();
burndown.getRange("A2:H20").clear();
}

function onOpen() {
var ui = SpreadsheetApp.getUi();
// Or DocumentApp or FormApp.
ui.createMenu('Sprint')
.addItem('Start Sprint', 'recordHistory')
.addItem('Archive Sprint', 'archiveSprint')
.addToUi();
}

And then you need to set up triggers for automatic update of the Spreadsheet every day. In the script’s editor go to Resources->Current project’s triggers and add new. For example, I have added 5 separate triggers for each weekday just before midnight.

And basically, that is all. Enjoy!

PS: The code and the tool might be done much better, especially those hard-coded values etc. This is just the very first proof of concept. I would ask you to tell me if it is helpful at all and if there is a point to developing it more. I would also love to see your implementation of such a Scrum tool.

Stop being limited by agile tools providers – build your own Scrum tool dedicated to your team!

PS: Read about how to start a challenger bank here.

Article author

Wiktor Żołnowski

Wiktor Żołnowski

Co-CEO at Pragmatic Coders

CEO & Co-Founder of Pragmatic Coders. Agile Coach, Scrum Master, Software Developer, Trainer, and Consultant with more than 15 years of experience in Agile Software Development.

Newsletter
Recent Topics
chess blockchain scam code
News, Product Development
Client sent us a repo with a backdoor. Security in software development
AI, Product Development, Industry Insights
Secure AI-Assisted Coding: A Definitive Guide
8 best healthcare software development companies
Digital Health, Product Development
Top healthcare software development companies (Top 8 in 2025)
Top AI Agent Development Companies in 2025 Cover
AI, Product Development
Top AI Agent Development Companies in 2025
Healthcare as a Service (HaaS): What it means and why it matters in 2025
Digital Health
Healthcare as a Service (HaaS): What it means and why it matters in 2025

Related articles

Check out our blog and collect knowledge on how to develop products with success.

Client sent us a repo with a backdoor. Security in software development chess blockchain scam code
News, Product Development
May 08,2025
3 min read

Client sent us a repo with a backdoor. Security in software development

Read More
Secure AI-Assisted Coding: A Definitive Guide
AI, Product Development, Industry Insights
May 08,2025
9 min read

Secure AI-Assisted Coding: A Definitive Guide

Read More
Top healthcare software development companies (Top 8 in 2025) 8 best healthcare software development companies
Digital Health, Product Development
Apr 30,2025
9 min read

Top healthcare software development companies (Top 8 in 2025)

Read More

Our Core Software Development Services

Custom Software Development Services

Custom Software Development Services

Custom Software Development Services for Startups & Tech. Bespoke software built by experts in contemporary software product development.
Learn More
Custom Fintech Software Development Services Company

Custom Fintech Software Development Services Company

Custom Fintech Software Development Services from industry experts. Scalable fintech apps, trading platforms, challenger banks, blockchain, and more.
Learn More
Healthcare Software Development Company

Healthcare Software Development Company

Healthcare software development services from industry experts. We have 10 years of experience in this highly regulated and demanding space.
Learn More
Custom AI Software Development Services & Solutions Company

Custom AI Software Development Services & Solutions Company

We can build your AI app from scratch or implement AI solutions to your existing product. Get a free consultation today!
Learn More

Newsletter

You are just one click away from receiving our 1-min business newsletter. Get insights on product management, product design, Agile, fintech, digital health, and AI.

LOOK INSIDE

Pragmatic times Newsletter
  • Business Consulting
  • Product Discovery Workshops
  • Product Management Consulting
  • Fundraising Consulting
  • Software Product Design
  • UX Design
  • UX Research
  • UI Design
  • Custom Software Development-services
  • Web & Cloud Application Development
  • Mobile Application Development
  • No-code Development
  • AI Software Development
  • Custom Blockchain Development
  • DevOps Services
  • Technology Consulting
  • Industries
  • Fintech
  • Digital Health
  • E-commerce
  • Entertainment
  • Custom Software Development Services
  • About Us
  • Meet Our Team
  • How We Work
  • Become a Partner
  • Newsroom
  • Featured Case Studies
  • Atom Bank
  • Kitopi
  • WithHealth
  • UltiArena
  • Resources
  • Digital Health Guide
  • Fintech Guide
  • Insurtech Guide
  • Newsletter
  • E-books
  • Podcast & Webinars
  • Blog
  • Product Development
  • Fintech
  • Digital Health
  • AI
  • Product Management
  • Agile & Scrum
  • Outsourcing & Collaboration
  • Blockchain
  • Startup
Pragmatic Coders Logo

ul. Opolska 100

31-323 Kraków, Poland

VAT ID: PL 6772398603

Contact

[email protected]

+48 783 871 783

Follow Us
Facebook Linkedin Github Behance Dribbble
© 2025 Pragmatic Coders. All right reserved.
  • Privacy policy
  • Terms of use
  • Sitemap