<aside>
🗣 What is cost-benefit analysis? A process used to measure the benefits of a decision in comparrison to its cost. Essentially, benefit should always outweigh cost.
- In this example, every month there is a select property that asks for the value of a subscription's benefit. That value correlates with a number between -2 ... 0 ... 2.
- Using the monetary value of the same subscription, I created a benchmark formula to help me determine if the subscription is still worth the cost.
- There is a new cost property that collects all subscriptions to keep and provides a new monthly cost as a SUM at the bottom of the table.
</aside>
Subscriptions
Formula (Each Month's Value)
- Replacing "1st Month" with 2nd for cooresponding formula
CONDITIONS
- Essential Tool ==
2
- Increased Revenue ==
1
- Encouraged Innovation ==
1
- Strengthened Relationships ==
1
- Increased Productivity ==
1
- Mood Boost ==
0
- Increased Learning ==
0
- Roadblock Breakthrough ==
0
- Used ≤ 3 Times ==
-1
- Decreased Revenue ==
-1
- Lack of Features ==
-1
- No Interest ==
-2
if(contains(prop("1st Month"), "Essential Tool"), 2, 0) + if(contains(prop("1st Month"), "Increased Revenue"), 1, 0) + if(contains(prop("1st Month"), "Encouraged Innovation"), 1, 0) + if(contains(prop("1st Month"), "Strengthened Relationships"), 1, 0) + if(contains(prop("1st Month"), "Used ≤ 3 Times"), -1, 0) + if(contains(prop("1st Month"), "Decreased Revenue"), -1, 0) + if(contains(prop("1st Month"), "Lack of Features"), -1, 0) + if(contains(prop("1st Month"), "No Interest"), -2, 0)
Formula For Keep?
CONDITIONS