window._wpemojiSettings = {"baseUrl":"https:\/\/s.w.org\/images\/core\/emoji\/16.0.1\/72x72\/","ext":".png","svgUrl":"https:\/\/s.w.org\/images\/core\/emoji\/16.0.1\/svg\/","svgExt":".svg","source":{"concatemoji":"https:\/\/simplifysheets.com\/wp-includes\/js\/wp-emoji-release.min.js?ver=6.8.3"}}; /*! This file is auto-generated */ !function(s,n){var o,i,e;function c(e){try{var t={supportTests:e,timestamp:(new Date).valueOf()};sessionStorage.setItem(o,JSON.stringify(t))}catch(e){}}function p(e,t,n){e.clearRect(0,0,e.canvas.width,e.canvas.height),e.fillText(t,0,0);var t=new Uint32Array(e.getImageData(0,0,e.canvas.width,e.canvas.height).data),a=(e.clearRect(0,0,e.canvas.width,e.canvas.height),e.fillText(n,0,0),new Uint32Array(e.getImageData(0,0,e.canvas.width,e.canvas.height).data));return t.every(function(e,t){return e===a[t]})}function u(e,t){e.clearRect(0,0,e.canvas.width,e.canvas.height),e.fillText(t,0,0);for(var n=e.getImageData(16,16,1,1),a=0;a<n.data.length;a++)if(0!==n.data[a])return!1;return!0}function f(e,t,n,a){switch(t){case"flag":return n(e,"\ud83c\udff3\ufe0f\u200d\u26a7\ufe0f","\ud83c\udff3\ufe0f\u200b\u26a7\ufe0f")?!1:!n(e,"\ud83c\udde8\ud83c\uddf6","\ud83c\udde8\u200b\ud83c\uddf6")&&!n(e,"\ud83c\udff4\udb40\udc67\udb40\udc62\udb40\udc65\udb40\udc6e\udb40\udc67\udb40\udc7f","\ud83c\udff4\u200b\udb40\udc67\u200b\udb40\udc62\u200b\udb40\udc65\u200b\udb40\udc6e\u200b\udb40\udc67\u200b\udb40\udc7f");case"emoji":return!a(e,"\ud83e\udedf")}return!1}function g(e,t,n,a){var r="undefined"!=typeof WorkerGlobalScope&&self instanceof WorkerGlobalScope?new OffscreenCanvas(300,150):s.createElement("canvas"),o=r.getContext("2d",{willReadFrequently:!0}),i=(o.textBaseline="top",o.font="600 32px Arial",{});return e.forEach(function(e){i[e]=t(o,e,n,a)}),i}function t(e){var t=s.createElement("script");t.src=e,t.defer=!0,s.head.appendChild(t)}"undefined"!=typeof Promise&&(o="wpEmojiSettingsSupports",i=["flag","emoji"],n.supports={everything:!0,everythingExceptFlag:!0},e=new Promise(function(e){s.addEventListener("DOMContentLoaded",e,{once:!0})}),new Promise(function(t){var n=function(){try{var e=JSON.parse(sessionStorage.getItem(o));if("object"==typeof e&&"number"==typeof e.timestamp&&(new Date).valueOf()<e.timestamp+604800&&"object"==typeof e.supportTests)return e.supportTests}catch(e){}return null}();if(!n){if("undefined"!=typeof Worker&&"undefined"!=typeof OffscreenCanvas&&"undefined"!=typeof URL&&URL.createObjectURL&&"undefined"!=typeof Blob)try{var e="postMessage("+g.toString()+"("+[JSON.stringify(i),f.toString(),p.toString(),u.toString()].join(",")+"));",a=new Blob([e],{type:"text/javascript"}),r=new Worker(URL.createObjectURL(a),{name:"wpTestEmojiSupports"});return void(r.onmessage=function(e){c(n=e.data),r.terminate(),t(n)})}catch(e){}c(n=g(i,f,p,u))}t(n)}).then(function(e){for(var t in e)n.supports[t]=e[t],n.supports.everything=n.supports.everything&&n.supports[t],"flag"!==t&&(n.supports.everythingExceptFlag=n.supports.everythingExceptFlag&&n.supports[t]);n.supports.everythingExceptFlag=n.supports.everythingExceptFlag&&!n.supports.flag,n.DOMReady=!1,n.readyCallback=function(){n.DOMReady=!0}}).then(function(){return e}).then(function(){var e;n.supports.everything||(n.readyCallback(),(e=n.source||{}).concatemoji?t(e.concatemoji):e.wpemoji&&e.twemoji&&(t(e.twemoji),t(e.wpemoji)))}))}((window,document),window._wpemojiSettings);
https://simplifysheets.com/wp-includes/js/jquery/jquery.min.js
https://simplifysheets.com/wp-includes/js/jquery/jquery-migrate.min.js
Skip to content
  • Home
  • About
  • Functions
  • Basics
    • Data Validation
    • Conditional Formatting
    • Dynamic Dropdown Menus
  • Blog
Simplify Sheets
  • About
  • Functions
  • Basics
    • Data Validation
    • Conditional Formatting
    • Dynamic Dropdown Menus
  • Blog

Personal Finance

Formulas pertaining to personal finance

How to track & graph utilities with Google Sheets

Track and graph your utility bills and discover how temperature affects your bills.

Categories Formulas, Design Tips, Personal Finance Tags Practice Sheet Leave a comment

Tracking gas mileage with Google Sheets

Track your gas mileage with simple formulas.

Categories Formulas, Personal Finance Tags Practice Sheet 1 Comment

Topics

Popular Posts

  1. INDEX MATCH vs. VLOOKUP in Google Sheets
  2. Convert temperatures with Google Sheets
  3. Find a person's age with Google Sheets
  4. Separate first & last names with Google Sheets
  5. Track your car's MPG with Google Sheets

Newsletter

    Support

    If you enjoy our content, please consider donating.
    We currently don't run ads on the site.



    Donate
                
    © 2026 Simplify Sheets
    Privacy Policy | Sitemap | Contact Us
    Manage Consent
    To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
    Functional Always active
    The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
    Preferences
    The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
    Statistics
    The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
    Marketing
    The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
    • Manage options
    • Manage services
    • Manage {vendor_count} vendors
    • Read more about these purposes
    View preferences
    • {title}
    • {title}
    • {title}
    (function() { var dropdown = document.getElementById( "cat" ); function onCatChange() { if ( dropdown.options[ dropdown.selectedIndex ].value > 0 ) { dropdown.parentNode.submit(); } } dropdown.onchange = onCatChange; })();
    !function(){"use strict";if("querySelector"in document&&"addEventListener"in window){var e=document.body;e.addEventListener("pointerdown",(function(){e.classList.add("using-mouse")}),{passive:!0}),e.addEventListener("keydown",(function(){e.classList.remove("using-mouse")}),{passive:!0})}}();
    https://simplifysheets.com/wp-content/plugins/gp-premium/menu-plus/functions/js/sticky.min.js
    https://simplifysheets.com/wp-includes/js/dist/hooks.min.js
    https://simplifysheets.com/wp-includes/js/dist/i18n.min.js
    wp.i18n.setLocaleData( { 'text direction\u0004ltr': [ 'ltr' ] } );
    https://simplifysheets.com/wp-content/plugins/contact-form-7/includes/swv/js/index.js
    var wpcf7 = { "api": { "root": "https:\/\/simplifysheets.com\/wp-json\/", "namespace": "contact-form-7\/v1" }, "cached": 1 };
    https://simplifysheets.com/wp-content/plugins/contact-form-7/includes/js/index.js
    var mPS2id_params = {"instances":{"mPS2id_instance_0":{"selector":"a[href*='#']:not([href='#'])","autoSelectorMenuLinks":"true","excludeSelector":"a[href^='#tab-'], a[href^='#tabs-'], a[data-toggle]:not([data-toggle='tooltip']), a[data-slide], a[data-vc-tabs], a[data-vc-accordion], a.screen-reader-text.skip-link","scrollSpeed":800,"autoScrollSpeed":"true","scrollEasing":"easeInOutQuint","scrollingEasing":"easeOutQuint","forceScrollEasing":"false","pageEndSmoothScroll":"true","stopScrollOnUserAction":"false","autoCorrectScroll":"false","autoCorrectScrollExtend":"false","layout":"vertical","offset":"130","dummyOffset":"false","highlightSelector":"","clickedClass":"mPS2id-clicked","targetClass":"mPS2id-target","highlightClass":"mPS2id-highlight","forceSingleHighlight":"false","keepHighlightUntilNext":"false","highlightByNextTarget":"false","appendHash":"false","scrollToHash":"true","scrollToHashForAll":"true","scrollToHashDelay":0,"scrollToHashUseElementData":"true","scrollToHashRemoveUrlHash":"false","disablePluginBelow":0,"adminDisplayWidgetsId":"true","adminTinyMCEbuttons":"true","unbindUnrelatedClickEvents":"false","unbindUnrelatedClickEventsSelector":"","normalizeAnchorPointTargets":"false","encodeLinks":"false"}},"total_instances":"1","shortcode_class":"_ps2id"};
    https://simplifysheets.com/wp-content/plugins/page-scroll-to-id/js/page-scroll-to-id.min.js
    var generatepressMenu = {"toggleOpenedSubMenus":true,"openSubMenuLabel":"Open Sub-Menu","closeSubMenuLabel":"Close Sub-Menu"};
    https://simplifysheets.com/wp-content/themes/generatepress/assets/js/menu.min.js
    var generatepressNavSearch = {"open":"Open Search Bar","close":"Close Search Bar"};
    https://simplifysheets.com/wp-content/themes/generatepress/assets/js/navigation-search.min.js
    var generatepressBackToTop = {"smooth":true};
    https://simplifysheets.com/wp-content/themes/generatepress/assets/js/back-to-top.min.js
    https://simplifysheets.com/wp-content/plugins/google-site-kit/dist/assets/js/googlesitekit-consent-mode-bc2e26cfa69fcd4a8261.js
    https://simplifysheets.com/wp-includes/js/dist/vendor/wp-polyfill.min.js
    var wpcf7_recaptcha = { "sitekey": "6LfIYr4ZAAAAAKI2e76Y-_LnyfLO117gjK7UssUv", "actions": { "homepage": "homepage", "contactform": "contactform" } };
    https://simplifysheets.com/wp-content/plugins/contact-form-7/modules/recaptcha/index.js
    var consent_api = {"consent_type":"optout","waitfor_consent_hook":"","cookie_expiration":"30","cookie_prefix":"wp_consent","services":[]};
    https://simplifysheets.com/wp-content/plugins/wp-consent-api/assets/js/wp-consent-api.min.js
    var complianz = {"prefix":"cmplz_","user_banner_id":"1","set_cookies":[],"block_ajax_content":"","banner_version":"31","version":"7.4.4","store_consent":"","do_not_track_enabled":"","consenttype":"optout","region":"us","geoip":"","dismiss_timeout":"","disable_cookiebanner":"","soft_cookiewall":"","dismiss_on_scroll":"1","cookie_expiry":"365","url":"https:\/\/simplifysheets.com\/wp-json\/complianz\/v1\/","locale":"lang=en&locale=en_US","set_cookies_on_root":"","cookie_domain":"","current_policy_id":"28","cookie_path":"\/","categories":{"statistics":"statistics","marketing":"marketing"},"tcf_active":"","placeholdertext":"Click to accept {category} cookies and enable this content","css_file":"https:\/\/simplifysheets.com\/wp-content\/uploads\/complianz\/css\/banner-{banner_id}-{type}.css?v=31","page_links":{"us":{"cookie-statement":{"title":"","url":"https:\/\/simplifysheets.com\/blog\/formulas\/graph-utilities-google-sheets"},"privacy-statement":{"title":"Privacy Policy","url":"https:\/\/simplifysheets.com\/privacy-policy"}}},"tm_categories":"1","forceEnableStats":"","preview":"","clean_cookies":"","aria_label":"Click to accept {category} cookies and enable this content"};
    https://simplifysheets.com/wp-content/plugins/complianz-gdpr/cookiebanner/js/complianz.min.js