What's your growth rate?

Guys! During the YC Startup School I gradually started to implement different ideas to track primary metrics and I have involved my team to set OKR (Objectives and Key Results) and track their important metrics too. Eventually it has been structured on a dashboard using just google spreadsheets and formulas and charts.

I'd like to share this framework with you and hope you'll find it helpful: https://docs.google.com/spreadsheets/d/1zKKajgd1YUom4oiALpxWA87eiJxllx_MCzx78_HFcwk/edit?usp=sharing

Just make a copy of this spreadsheet and you'll be able to edit and play with numbers.

What you can do with this spreadsheet stuffed with automatic formulas:

* Choose your CWGR (Compound Weekly Growth Rate) and get your Point B after 10 weeks.

* Weekly update your primary metric and see your weekly change (with color coding) + CWGR (an answer to investor's favourite question - "What's your growth rate?").

* Track your 10th week prediction given your current CWGR. Track your min, max range of weekly growth fluctuation.

* Track your Point B threshold, ideal growth curve and current progress - all in one chart

Another benefit is as a motivational system. If your employees hit their weekly target growth rate, they earn scores that turn into $$ depending on how many times they hit the target during the 4 week period. You will find details in comments to the specific cells.

Also, I've programmed 2 calculators:

Calculator A: What CWGR do I need to get from A to B for N weeks?

Calculator B: How long will it take to get from A to B given my CWGR?

I would appreciate your thoughts, feedback, critics and comments!

* * *

Telegram: @badgerhoneymoon

Facebook: https://www.facebook.com/denis.burkatsky