{"id":95,"date":"2020-10-13T11:12:23","date_gmt":"2020-10-13T15:12:23","guid":{"rendered":"https:\/\/www.smartoilgauge.com\/blog\/?p=95"},"modified":"2020-10-13T11:12:23","modified_gmt":"2020-10-13T15:12:23","slug":"exporting-data-from-smart-oil-gauge","status":"publish","type":"post","link":"https:\/\/www.smartoilgauge.com\/blog\/exporting-data-from-smart-oil-gauge\/","title":{"rendered":"Exporting Data From Smart Oil Gauge"},"content":{"rendered":"\n

If you enjoy crunching numbers like me, you’ll be happy to know that you can export the tank readings from your Smart Oil Gauge. In this post we’ll walk through how to export data into Excel.<\/p>\n\n\n\n

Smart Oil Gauge Tank Readings<\/h2>\n\n\n\n

Your Smart Oil Gauge records a level reading from your tank every hour of the day. It uploads these readings after a certain time interval has elapsed. This interval is known as the upload interval. An upload interval of 4 means that every four hours the Smart Oil Gauge connects to WiFi to upload the latest batch of readings to the cloud. An upload interval of 1 means every hour, and an interval of 24 means once per day. An interval of 12 or 24 will improve battery life over the long run.<\/p>\n\n\n\n

When you open your app, the app checks the cloud for new readings. Pressing the refresh button in the app also checks for new readings in the cloud. It does not, however, trigger a new reading from the gauge itself. To manually force a reading, press the configure button on the Smart Oil Gauge for half a second. Then, refresh the app and look for a new ‘Last Reading’ time stamp.<\/p>\n\n\n\n

Smart Oil Gauge Records 24 Readings Per Day<\/h2>\n\n\n\n

Regardless of your upload interval setting, the Smart Oil Gauge still takes 24 readings per day. After many months or years, this adds up to a LOT of data points. For this reason, we have added an Export Data feature to our site. Just go to the My Tanks<\/a> page and follow the instructions below to export data.<\/p>\n\n\n\n

\"\"
Log into the My Tanks page at www.SmartOilGauge.com. Once there, select the tank you would like to view (if you have multiple Smart Oil Gauges). Then, click the hamburger menu in the top right (three lines) and click Export Data. <\/figcaption><\/figure>\n\n\n\n
\"\"
Choose a date range for the Smart Oil Gauge readings you would like to export. The system will include all the data back to when it was first installed. Click Export and it will generate a .CSV file which can be viewed in Excel.<\/figcaption><\/figure>\n\n\n\n

Start Crunching Numbers!<\/h2>\n\n\n\n

Once you’ve downloaded your Smart Oil Gauge data, feel free to start crunching numbers! If you would like to see how much oil you are burning each day based on outdoor air temperature, check out Weather Underground<\/a>. This website lets you download historical low, average, and high temperatures by zip code. You can overlay this data with your Smart Oil Gauge data and have some real fun!<\/p>\n\n\n\n

Happy heating,<\/p>\n\n\n\n

Steve<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

If you enjoy crunching numbers like me, you’ll be happy to know that you can export the tank readings from your Smart Oil Gauge. In this post we’ll walk through how to export data into Excel. Smart Oil Gauge Tank Readings Your Smart Oil Gauge records a level reading from your tank every hour of … <\/p>\n

Continue reading “Exporting Data From Smart Oil Gauge”<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":98,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[6,4],"tags":[],"yoast_head":"\nExporting Data From Smart Oil Gauge - Smart Oil Gauge<\/title>\n<meta name=\"description\" content=\"Smart Oil Gauge data can be exported directly into a .CSV file that can be viewed in Excel. The data includes hourly readings from the day of installation!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.smartoilgauge.com\/blog\/exporting-data-from-smart-oil-gauge\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exporting Data From Smart Oil Gauge - Smart Oil Gauge\" \/>\n<meta property=\"og:description\" content=\"Smart Oil Gauge data can be exported directly into a .CSV file that can be viewed in Excel. The data includes hourly readings from the day of installation!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.smartoilgauge.com\/blog\/exporting-data-from-smart-oil-gauge\/\" \/>\n<meta property=\"og:site_name\" content=\"Smart Oil Gauge\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-13T15:12:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.smartoilgauge.com\/blog\/wp-content\/uploads\/2020\/10\/Export-data-blog-post.png\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Steve Williams\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Steve Williams\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.smartoilgauge.com\/blog\/exporting-data-from-smart-oil-gauge\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.smartoilgauge.com\/blog\/exporting-data-from-smart-oil-gauge\/\"},\"author\":{\"name\":\"Steve Williams\",\"@id\":\"https:\/\/www.smartoilgauge.com\/blog\/#\/schema\/person\/1c8ed2a0175853ddd99760e2d6696b79\"},\"headline\":\"Exporting Data From Smart Oil Gauge\",\"datePublished\":\"2020-10-13T15:12:23+00:00\",\"dateModified\":\"2020-10-13T15:12:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.smartoilgauge.com\/blog\/exporting-data-from-smart-oil-gauge\/\"},\"wordCount\":429,\"publisher\":{\"@id\":\"https:\/\/www.smartoilgauge.com\/blog\/#organization\"},\"articleSection\":[\"data\",\"Heating Oil\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.smartoilgauge.com\/blog\/exporting-data-from-smart-oil-gauge\/\",\"url\":\"https:\/\/www.smartoilgauge.com\/blog\/exporting-data-from-smart-oil-gauge\/\",\"name\":\"Exporting Data From Smart Oil Gauge - Smart Oil Gauge\",\"isPartOf\":{\"@id\":\"https:\/\/www.smartoilgauge.com\/blog\/#website\"},\"datePublished\":\"2020-10-13T15:12:23+00:00\",\"dateModified\":\"2020-10-13T15:12:23+00:00\",\"description\":\"Smart Oil Gauge data can be exported directly into a .CSV file that can be viewed in Excel. The data includes hourly readings from the day of installation!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.smartoilgauge.com\/blog\/exporting-data-from-smart-oil-gauge\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.smartoilgauge.com\/blog\/exporting-data-from-smart-oil-gauge\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.smartoilgauge.com\/blog\/exporting-data-from-smart-oil-gauge\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.smartoilgauge.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exporting Data From Smart Oil Gauge\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.smartoilgauge.com\/blog\/#website\",\"url\":\"https:\/\/www.smartoilgauge.com\/blog\/\",\"name\":\"Smart Oil Gauge\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.smartoilgauge.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.smartoilgauge.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.smartoilgauge.com\/blog\/#organization\",\"name\":\"Smart Oil Gauge\",\"url\":\"https:\/\/www.smartoilgauge.com\/blog\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.smartoilgauge.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.smartoilgauge.com\/blog\/wp-content\/uploads\/2020\/01\/logo-1.png\",\"contentUrl\":\"https:\/\/www.smartoilgauge.com\/blog\/wp-content\/uploads\/2020\/01\/logo-1.png\",\"width\":193,\"height\":70,\"caption\":\"Smart Oil Gauge\"},\"image\":{\"@id\":\"https:\/\/www.smartoilgauge.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.smartoilgauge.com\/blog\/#\/schema\/person\/1c8ed2a0175853ddd99760e2d6696b79\",\"name\":\"Steve Williams\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.smartoilgauge.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/275713ca6a917dd2d9e9abd0d8bc61a8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/275713ca6a917dd2d9e9abd0d8bc61a8?s=96&d=mm&r=g\",\"caption\":\"Steve Williams\"},\"url\":\"https:\/\/www.smartoilgauge.com\/blog\/author\/wpwilliams\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Exporting Data From Smart Oil Gauge - Smart Oil Gauge","description":"Smart Oil Gauge data can be exported directly into a .CSV file that can be viewed in Excel. The data includes hourly readings from the day of installation!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.smartoilgauge.com\/blog\/exporting-data-from-smart-oil-gauge\/","og_locale":"en_US","og_type":"article","og_title":"Exporting Data From Smart Oil Gauge - Smart Oil Gauge","og_description":"Smart Oil Gauge data can be exported directly into a .CSV file that can be viewed in Excel. The data includes hourly readings from the day of installation!","og_url":"https:\/\/www.smartoilgauge.com\/blog\/exporting-data-from-smart-oil-gauge\/","og_site_name":"Smart Oil Gauge","article_published_time":"2020-10-13T15:12:23+00:00","og_image":[{"width":300,"height":400,"url":"https:\/\/www.smartoilgauge.com\/blog\/wp-content\/uploads\/2020\/10\/Export-data-blog-post.png","type":"image\/png"}],"author":"Steve Williams","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Steve Williams","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.smartoilgauge.com\/blog\/exporting-data-from-smart-oil-gauge\/#article","isPartOf":{"@id":"https:\/\/www.smartoilgauge.com\/blog\/exporting-data-from-smart-oil-gauge\/"},"author":{"name":"Steve Williams","@id":"https:\/\/www.smartoilgauge.com\/blog\/#\/schema\/person\/1c8ed2a0175853ddd99760e2d6696b79"},"headline":"Exporting Data From Smart Oil Gauge","datePublished":"2020-10-13T15:12:23+00:00","dateModified":"2020-10-13T15:12:23+00:00","mainEntityOfPage":{"@id":"https:\/\/www.smartoilgauge.com\/blog\/exporting-data-from-smart-oil-gauge\/"},"wordCount":429,"publisher":{"@id":"https:\/\/www.smartoilgauge.com\/blog\/#organization"},"articleSection":["data","Heating Oil"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.smartoilgauge.com\/blog\/exporting-data-from-smart-oil-gauge\/","url":"https:\/\/www.smartoilgauge.com\/blog\/exporting-data-from-smart-oil-gauge\/","name":"Exporting Data From Smart Oil Gauge - Smart Oil Gauge","isPartOf":{"@id":"https:\/\/www.smartoilgauge.com\/blog\/#website"},"datePublished":"2020-10-13T15:12:23+00:00","dateModified":"2020-10-13T15:12:23+00:00","description":"Smart Oil Gauge data can be exported directly into a .CSV file that can be viewed in Excel. The data includes hourly readings from the day of installation!","breadcrumb":{"@id":"https:\/\/www.smartoilgauge.com\/blog\/exporting-data-from-smart-oil-gauge\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.smartoilgauge.com\/blog\/exporting-data-from-smart-oil-gauge\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.smartoilgauge.com\/blog\/exporting-data-from-smart-oil-gauge\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.smartoilgauge.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Exporting Data From Smart Oil Gauge"}]},{"@type":"WebSite","@id":"https:\/\/www.smartoilgauge.com\/blog\/#website","url":"https:\/\/www.smartoilgauge.com\/blog\/","name":"Smart Oil Gauge","description":"","publisher":{"@id":"https:\/\/www.smartoilgauge.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.smartoilgauge.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.smartoilgauge.com\/blog\/#organization","name":"Smart Oil Gauge","url":"https:\/\/www.smartoilgauge.com\/blog\/","sameAs":[],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.smartoilgauge.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.smartoilgauge.com\/blog\/wp-content\/uploads\/2020\/01\/logo-1.png","contentUrl":"https:\/\/www.smartoilgauge.com\/blog\/wp-content\/uploads\/2020\/01\/logo-1.png","width":193,"height":70,"caption":"Smart Oil Gauge"},"image":{"@id":"https:\/\/www.smartoilgauge.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.smartoilgauge.com\/blog\/#\/schema\/person\/1c8ed2a0175853ddd99760e2d6696b79","name":"Steve Williams","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.smartoilgauge.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/275713ca6a917dd2d9e9abd0d8bc61a8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/275713ca6a917dd2d9e9abd0d8bc61a8?s=96&d=mm&r=g","caption":"Steve Williams"},"url":"https:\/\/www.smartoilgauge.com\/blog\/author\/wpwilliams\/"}]}},"_links":{"self":[{"href":"https:\/\/www.smartoilgauge.com\/blog\/wp-json\/wp\/v2\/posts\/95"}],"collection":[{"href":"https:\/\/www.smartoilgauge.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.smartoilgauge.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.smartoilgauge.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.smartoilgauge.com\/blog\/wp-json\/wp\/v2\/comments?post=95"}],"version-history":[{"count":1,"href":"https:\/\/www.smartoilgauge.com\/blog\/wp-json\/wp\/v2\/posts\/95\/revisions"}],"predecessor-version":[{"id":99,"href":"https:\/\/www.smartoilgauge.com\/blog\/wp-json\/wp\/v2\/posts\/95\/revisions\/99"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.smartoilgauge.com\/blog\/wp-json\/wp\/v2\/media\/98"}],"wp:attachment":[{"href":"https:\/\/www.smartoilgauge.com\/blog\/wp-json\/wp\/v2\/media?parent=95"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.smartoilgauge.com\/blog\/wp-json\/wp\/v2\/categories?post=95"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.smartoilgauge.com\/blog\/wp-json\/wp\/v2\/tags?post=95"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}