{"id":479,"date":"2020-02-04T19:46:37","date_gmt":"2020-02-04T19:46:37","guid":{"rendered":"https:\/\/expressmileage.com\/pages\/?post_type=ufaq&#038;p=479"},"modified":"2020-02-04T19:46:37","modified_gmt":"2020-02-04T19:46:37","slug":"how-do-i-modify-the-xls-spreadsheet-after-i-download-the-driving-log","status":"publish","type":"ufaq","link":"https:\/\/expressmileage.com\/pages\/ufaqs\/how-do-i-modify-the-xls-spreadsheet-after-i-download-the-driving-log\/","title":{"rendered":"How do I modify the XLS Spreadsheet after I download the driving log?"},"content":{"rendered":"<div  class=\"ewd-ufaq-faq-list ewd-ufaq-page-type-load_more\" id='ewd-ufaq-faq-list'>\n\n\t<input type='hidden' name='show_on_load' value='' id='ewd-ufaq-show-on-load' \/>\n<input type='hidden' name='include_category' value='' id='ewd-ufaq-include-category' \/>\n<input type='hidden' name='exclude_category' value='' id='ewd-ufaq-exclude-category' \/>\n<input type='hidden' name='orderby' value='date' id='ewd-ufaq-orderby' \/>\n<input type='hidden' name='order' value='desc' id='ewd-ufaq-order' \/>\n<input type='hidden' name='post_count' value='-1' id='ewd-ufaq-post-count' \/>\n<input type='hidden' name='current_url' value='\/pages\/wp-json\/wp\/v2\/ufaq\/479' id='ewd-ufaq-current-url' \/>\n\t\n\t\n\t<div class='ewd-ufaq-faqs'>\n\n\t\t<div  class=\"ewd-ufaq-faq-div ewd-ufaq-faq-column-count-one ewd-ufaq-faq-responsive-columns- ewd-ufaq-faq-display-style-default ewd-ufaq-can-be-toggled\" id='ewd-ufaq-post-479-aTDGwTE7TP' data-post_id='479'>\n\n\t<div class='ewd-ufaq-faq-title ewd-ufaq-faq-toggle'>\n\t\n\t<a class='ewd-ufaq-post-margin'  href='#'>\n\n\t\t<div class='ewd-ufaq-post-margin-symbol ewd-ufaq-square'>\n\t\t\t<span >A<\/span>\n\t\t<\/div>\n\n\t\t<div class='ewd-ufaq-faq-title-text'>\n\n\t\t\t<h4>\n\t\t\t\tHow do I modify the XLS Spreadsheet after I download the driving log?\t\t\t<\/h4>\n\n\t\t<\/div>\n\n\t\t<div class='ewd-ufaq-clear'><\/div>\n\n\t<\/a>\n\t\n<\/div>\n\t\n\t<div class='ewd-ufaq-faq-body ' >\n\n\t\t\n\t\t\t<div class='ewd-ufaq-author-date'>\n\n\tPosted\n\tby\n<span class='ewd-ufaq-author'>\n\tExpressMileage<\/span>\n\t\n<\/div>\n\t\t\n\t\t\t<div class='ewd-ufaq-post-margin ewd-ufaq-faq-post'>\n\t<div id=\"bloop_customfont\">The website interface is awesome for generating driving logs but certain driving log requirements are best suited for editing within the XLS Spreadsheet.\u00a0 For example, if you need to have your log read an exact Odometer reading on certain dates.\u00a0 \u00a0In this case, adjusting mileage values is more efficient if you edit the XLS (Excel) spreadsheet file directly.<\/div>\n<div id=\"bloop_customfont\"><\/div>\n<div id=\"bloop_customfont\"><\/div>\n<div id=\"bloop_customfont\">To edit the distances &#8211; open the XLS file in Excel (or Google Sheets) and adjust Column D (\u201cDistance\u201d).\u00a0 Because the spreadsheet is built using formulas &#8211; when you adjust a distance, all of the subsequent values for your Odometer will adjust accordingly.\u00a0 So, you might do a \u201csplit\u201d window in Excel and watch the desired date \u00a0(ie: <a href=\"http:\/\/airmail.calendar\/2020-02-15%2012:00:00%20PST\">Feb 15<\/a>) and adjust previous drives to hit the desired value: 88073kms.<\/div>\n<div><img loading=\"lazy\" class=\"aligncenter size-full wp-image-480\" src=\"https:\/\/expressmileage.com\/pages\/wp-content\/uploads\/2020\/02\/mceclip0-1.png\" alt=\"\" width=\"986\" height=\"546\" \/><\/div>\n<\/div>\n\t\t\n\t\t\t<div class='ewd-ufaq-faq-custom-fields'>\n\n\t\n<\/div>\n\t\t\n\t\t\t<div class='ewd-ufaq-faq-categories'>\n\t\n\tCategory:\n\t\n\t\tDownloading \/ Printing\n\t\n<\/div>\n\t\t\n\t\t\t\n\t\t\n\t\t\t\n\t\t\n\t\t\t\n\t\t\n\t\t\t<div class='ewd-ufaq-permalink'>\n\t\n\t<a href='https:\/\/expressmileage.com\/pages\/ufaqs\/how-do-i-modify-the-xls-spreadsheet-after-i-download-the-driving-log\/?Display_FAQ=479'>\n\t\t\n\t\tPermalink\t\t <div class='ewd-ufaq-permalink-image'><\/div> \t\n\t<\/a>\n\n<\/div>\n\t\t\n\t\t\t\n\t\t\n\t\t\t\n\t\t\n\t<\/div>\n\n<\/div>\n\t<\/div>\n\n\t\n<\/div>","protected":false},"excerpt":{"rendered":"<p>A How do I modify the XLS Spreadsheet after I download the driving log? Posted by ExpressMileage The website&hellip;<\/p>\n","protected":false},"author":1,"comment_status":"open","ping_status":"closed","template":"","ufaq-category":[93],"ufaq-tag":[],"_links":{"self":[{"href":"https:\/\/expressmileage.com\/pages\/wp-json\/wp\/v2\/ufaq\/479"}],"collection":[{"href":"https:\/\/expressmileage.com\/pages\/wp-json\/wp\/v2\/ufaq"}],"about":[{"href":"https:\/\/expressmileage.com\/pages\/wp-json\/wp\/v2\/types\/ufaq"}],"author":[{"embeddable":true,"href":"https:\/\/expressmileage.com\/pages\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expressmileage.com\/pages\/wp-json\/wp\/v2\/comments?post=479"}],"wp:attachment":[{"href":"https:\/\/expressmileage.com\/pages\/wp-json\/wp\/v2\/media?parent=479"}],"wp:term":[{"taxonomy":"ufaq-category","embeddable":true,"href":"https:\/\/expressmileage.com\/pages\/wp-json\/wp\/v2\/ufaq-category?post=479"},{"taxonomy":"ufaq-tag","embeddable":true,"href":"https:\/\/expressmileage.com\/pages\/wp-json\/wp\/v2\/ufaq-tag?post=479"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}