# Energy usage chart with graph

**URL:** <https://community.glideapps.com/t/energy-usage-chart-with-graph/43993>\
**Category:** Project Showcase\
**Created:** [July 6, 2022, 8:01pm UTC](https://community.glideapps.com/t/energy-usage-chart-with-graph/43993 "2022-07-06T20:01:21Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\
**Post date:** [July 6, 2022, 8:01pm UTC](https://community.glideapps.com/t/energy-usage-chart-with-graph/43993/1 "2022-07-06T20:01:21Z")

</div>

Hi, I needed to send my energy usage to a company to see how we can start to save some energy.

I had all the info in an Excel spreadsheet.

I threw it into a Glide Page in about 15 minutes! FUN!

The only thing that bothers me is in the data table, if I change the width of the columns at design time, the width does not “stick”.  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/6/b6aeb5acbaedc58495cb9d21cae34c208491ff63.png)

I would like to see the columns at the width set at design time like so:  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/1/a1d2d7caabe75b6d629bebee770cba04436a67c6.png)

I normalized the KWH totals for the graph in order to better see the correlation between usage and cost.

> **[Energy Use 2021/2022](https://youthful-run-6301.glide.page/)**
>
> Energy use for Household

---

<div class="post-metadata">

**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\
**Post date:** [September 3, 2022, 4:24pm UTC](https://community.glideapps.com/t/energy-usage-chart-with-graph/43993/2 "2022-09-03T16:24:26Z")

</div>

The original link has probably been unpublished, so if you want to see a similar page, here you go:

[Historical Weather for the United States 1875 - 2021](https://weather-1875-2021.glide.page/dl/d0a5f4)

This one took a bit longer than 15 minutes because I had to appropriate the data from a PDF publicly available from [weather.gov](http://weather.gov)

I had to first extract the data, then massage it a bit and, finally, import it into Excel.

The graph on this page shows the average yearly temperature along with a 7-year moving average to get an idea of how the temperature change looks over time (in other words, is it going up?)

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [September 3, 2022, 7:16pm UTC](https://community.glideapps.com/t/energy-usage-chart-with-graph/43993/3 "2022-09-03T19:16:00Z")

</div>

Interesting!

Have you ever tested their API to save a bit of effort? [api.weather.gov: General FAQs](https://weather-gov.github.io/api/general-faqs)

Saludos!

---

<div class="post-metadata">

**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\
**Post date:** [September 3, 2022, 8:17pm UTC](https://community.glideapps.com/t/energy-usage-chart-with-graph/43993/4 "2022-09-03T20:17:44Z")

</div>

> [@gvalero](#):
>
> Have you ever tested their API

No, and since this was a one-off project just for my own curiosity, I didn’t even look for that info. Thanks, though. I am sure someone in this forum needs that!