Last active
June 9, 2023 19:01
-
-
Save nicovalencia/759df4507642ed35ac979723c1b3f9da to your computer and use it in GitHub Desktop.
Indie Metrics Analysis Prompt
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Given this CSV of goal metrics, please analyze progress according to the requirements below: | |
``` | |
Committee,Goal Name,Goal Target,June 9th,June 16,June 23,June 30,July 7,July 14,July 21,July 28,August 4,August 11,August 18,August 25,September 1,September 8,September 15,September 22,September 29,October 6,October 13,October 20,October 27,November 3,November 10,November 17,November 24,December 1,December 8,December 15,December 22,December 29 | |
Strategy / Partnerships,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | |
,Revenue (per season),"$500,000","$10,000",,,,,,,,,,,,,,,,,,,,,,,,,,,,, | |
Product,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | |
,Tasks (per season),25,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | |
,% Indies Completed Tasks,35%,10%,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | |
Growth,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | |
,Conferences (per season),1,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | |
,Blog Posts (per season),5,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | |
Community,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | |
,Indies Accepted (per season),2,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | |
,Indies on Calls (average),4,4,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | |
,NPS,10,5,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | |
``` | |
Requirements: | |
* The current date is today | |
* Each goal is measured over a single quarter | |
* Calculate "CURRENT PROGRESS" as percentage complete as of the current date out of the total quarter | |
* Calculate "IDEAL PROGRESS" as how far each metric should be, based on the current date compared to the total quarter | |
* Calculate "RELATIVE PROGRESS" as how far ahead or behind the goal is compared to the calculated IDEAL PROGRESS | |
* Skip goals that have no progress | |
* Ignore the committee column | |
* Add a ✅ status to the goals that are on schedule or ahead of schedule | |
* Add a ❌ status to the goals that are behind schedule | |
* Show Goal Name, Goal Target, current metric, CURRENT PROGRESS, IDEAL PROGRESS, RELATIVE PROGRESS, and status in a table |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment