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.
Subscriptions
Service/Product
Monthly
$ Yearly?
1st Month
2nd Month
Keep?
3rd Month Keep
New Cost
$12.00
$ Yearly?
Encouraged Innovation
Increased Revenue
Essential Tool
Strengthened Relationships
Increased Revenue
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
- If 2nd Month is empty, show "Processing ..."
- If 3rd Month Keep is "Yes", show "Keep"
- If 3rd Month Keep is "No", show "Don't Keep"
- If the sum of 1st Value and 2nd Value is equal to
0
AND monthly price is greater than or equal to$20
, show "Try 1 More Month"
- If ☝condition 4 doesn't apply AND sum of 1st Value and 2nd Value is greater than or equal to
0
, show "Keep"
- If all ☝️above conditions DO NOT apply, show "Don't Keep"
if(empty(prop("2nd Month")), "Processing ...", if(prop("3rd Month Keep") == "Yes", "Keep", if(prop("3rd Month Keep") == "No", "Don't Keep", if(prop("1st Value") + prop("2nd Value") == 0 and prop("Monthly") >= 20, "Try 1 More Month", if(prop("1st Value") + prop("2nd Value") >= 0, "Keep", "Don't Keep")))))
Formula For New Cost
CONDITIONS
- if Keep shows "Keep" OR shows "Try 1 More Month", show the subscription's 💲monthly price.
- Otherwise, show BLANK.
if(prop("Keep?") == "Keep" or prop("Keep?") == "Try 1 More Month", prop("Monthly"), toNumber(""))