# Help with Electricity Plan Comparison App

**URL:** https://community.glideapps.com/t/help-with-electricity-plan-comparison-app/1260
**Category:** Ask for Help
**Created:** [October 19, 2019, 1:28am UTC](https://community.glideapps.com/t/help-with-electricity-plan-comparison-app/1260 "2019-10-19T01:28:20Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Richard\_Sanders](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/richard_sanders/32/95_2.png) [@Richard\_Sanders](https://community.glideapps.com/u/Richard_Sanders)
#### Post date: [October 19, 2019, 1:28am UTC](https://community.glideapps.com/t/help-with-electricity-plan-comparison-app/1260/1 "2019-10-19T01:28:20Z")

</div>

I am trying to build an app to compare electricity plans. I have created the sheet that does the behind the scenes calculations but can’t find a suitable template.

Basically 10 items from a bill showing usage data need to be entered into one column of the finished app and 10 data items from the Electricity Plan being considered to be entered into a second column for the spreadsheet to generate and show what the bill would be for that usage on that plan.

I hope that makes sense. Are you able to help me?

Thanking you for any assistance you can provide.

---

<div class="post-metadata">

### Author: ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [October 19, 2019, 1:51am UTC](https://community.glideapps.com/t/help-with-electricity-plan-comparison-app/1260/2 "2019-10-19T01:51:06Z")

</div>

You haven’t given a lot to go on but I would suggest that you turn your calcs around and make the data in a single row. This way all of the data can be entered from the App in one record. Glide treats a row as an item.

For example if you had three numbers and wanted to add them together every day, you would create a sheet and title the columns: Date, Num1, Num2, Num2, Result.  
You would then put data into your sheet on row 2, with a formula in column E that says =B2+C2+D2.  
In your Glide app you would be able to edit and/or add rows, entering the date and those 3 numbers and your spreadsheet would do the math to get the result.

I would suggest a second sheet in the spreadsheet that has the different plans. You would have a row for each plan type and pull the data in from the other sheets single row to make the calculation for each plan type.

---

<div class="post-metadata">

### Author: ![Richard\_Sanders](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/richard_sanders/32/95_2.png) [@Richard\_Sanders](https://community.glideapps.com/u/Richard_Sanders)
#### Post date: [October 19, 2019, 2:04am UTC](https://community.glideapps.com/t/help-with-electricity-plan-comparison-app/1260/3 "2019-10-19T02:04:15Z")

</div>

Many thanks George. I’ll give that a go.
