Posts

How to build your own Cost Calculator with Excel

In this how-to article, you will learn how you can build your very own Cost Calculator. Having the ability to calculate the cost is important in educating consumers and potential customers.

Gather the Tools

What you will need to build your own Cost Calculator:

Microsoft Excel – Excel will allow you to add the input and output labels and formulas for your calculator.

LeadDoubler – LeadDoubler is a web-based software that will allow you to turn the raw .xls (Excel file) into a beautiful and fully-functional online calculator.

Ready? Let’s go!

The process:

  • Step 1: Create Excel Document
  • Step 2: Launch LeadDoubler and Choose a Template
  • Step 3: Edit Page and Publish

Step 1: Create Excel Document

Our example Cost Calculator will be “How much do you spend on coffee?”

I saw this on a USA Today Article and thought it would be a great example to use for this how-to article.

Let’s start by opening Microsoft Excel and creating a new worksheet.

First, we have the Inputs, the Labels and the Values for our Excel file. Column A will have our labels, Column B our default values, and Column C will define the range of the values (and types of input).

Cost Calculator Excel Document

Next, we add the label “calculate” to separate the inputs and outputs. Anything listed after the “calculate” cell will be considered outputs.

Cost Calculator Setup

In Column B, below “Calculate” label, we can add our formulas. In this Coffee Cost Calculator we will just do a basic multiplication of the input values.

Cost Calculator Formula

Now we are ready to upload our Excel Sheet in Step 2.

Step 2: Launch LeadDoubler and Choose a Template

  • Go to LeadDoubler.com
  • Click the green “Signup” button and Register for a free account.

Cost Calculator Registration

Now, once you are in your dashboard, click the green “New Project” button on the right.

Cost Calculator Dashboard

You are now in the template gallery, click the “simple white landing page”.

Cost Calculator Gallery

Now, you are at the template preview page, click the “choose” link on the right to get started editing your landing page and calculator.

Cost Calculator Template Preview Page

This brings us to Step 3.

Step 3: Edit Page and Publish

Now, click “Edit landingpage” on the top right

Cost Calculator Landing Page

Select “Upload Spreadsheet to change form” and upload the Excel document you created earlier.

Cost Calculator Change form

Next, we can click “preview” to test and see how your calculator will work and see how it will look before its live.

Cost Calculator is uploaded

Now our Calculator is active and ready to calculate.

Live Cost Calculator Demo

Now, when you are ready to publish, click “publish” in the upper right corner of the dashboard and it will bring you to the publish page. Cost Calculator Preview

From here you can create your landing page url or connect it to your own existing domain. The choice is yours.

Alt text

Well, Congratulations you now have your very own Cost Calculator!

Alt text

LeadDoubler Free Trial