💸

Subscription Cost-Benefit

🗣
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
$14.00
$ Yearly?
Mood Boost
Increased Productivity
Mood Boost
$23.00
$ Yearly?
Mood Boost
Roadblock Breakthrough
Yes
$9.00
$ Yearly?
Used ≤ 3 Times
Mood Boost
Used ≤ 3 Times
$1.60
$ Yearly?
Used ≤ 3 Times
Increased Learning
Used ≤ 3 Times
$8.00
$ Yearly?
Increased Learning
Increased Learning
$10.00
$ Yearly?
Increased Learning
Increased Productivity
Encouraged Innovation
Mood Boost
$5.00
$ Yearly?
Used ≤ 3 Times
No Interest
$12.00
$ Yearly?
Encouraged Innovation
Increased Revenue
Essential Tool
Strengthened Relationships
Increased Revenue
$6.00
$ Yearly?
No Interest
No Interest

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
  1. If 2nd Month is empty, show "Processing ..."
  1. If 3rd Month Keep is "Yes", show "Keep"
  1. If 3rd Month Keep is "No", show "Don't Keep"
  1. 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"
  1. If ☝condition 4 doesn't apply AND sum of 1st Value and 2nd Value is greater than or equal to 0, show "Keep"
  1. 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
  1. if Keep shows "Keep" OR shows "Try 1 More Month", show the subscription's 💲monthly price.
  1. Otherwise, show BLANK.
if(prop("Keep?") == "Keep" or prop("Keep?") == "Try 1 More Month", prop("Monthly"), toNumber(""))