Skip to main content
How to Write Formulas?
Pratham Mittal avatar
Written by Pratham Mittal
Updated over 2 years ago

Simple Cost Calculators

Lets say the calculator is about calculating the cost of building a video campaign. Here are 4 sample questions:

The first two questions are simple sliders. So the user will use the sliders to select a value. Pretty simple.

The third question is about where the video needs to be posted. If the video needs to be posted on the web, then let's say it needs $5000 worth of editing. So, we will add $5000 as the "value" for web. For TV, we have assumed that it will require $20000 worth of editing.

Question 4 is about the length of the video. Here, we are assuming that a 20 minute video takes 4 times the effort of a <1 minute video.

Now that we have the questions out of the way, we have to build the formula. Handling the first 2 questions is easy.

For Q1, say the cost of each actor is $500. So we just multiply the input of Q1 (number of actors) with the cost of each calculator. We create a similar formula for Q2 as well.

To handle for Q3, we will just simply add the editing cost for web or for TV which has already been assigned while creating the question.

For Q4 (length of the video), we have assumed that the length of the video will determine the overall effort put in by the actors and editors. So we can simply multiply the input for Q4 with the rest of the formula.

And that's about it.

Did this answer your question?