{"id":21224,"date":"2026-07-27T11:03:39","date_gmt":"2026-07-27T16:03:39","guid":{"rendered":"https:\/\/upstreamreporting.app\/support\/?p=21224"},"modified":"2026-08-06T11:05:11","modified_gmt":"2026-08-06T16:05:11","slug":"cleaner-excel-exports-for-money-volume-and-empty-values","status":"publish","type":"post","link":"https:\/\/upstreamreporting.app\/support\/?p=21224","title":{"rendered":"Cleaner Excel Exports for Money, Volume, and Empty Values"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Upstream+ report exports now carry more information about each row\u2019s value type into the finished workbook. That allows Excel to distinguish financial amounts from production quantities instead of applying one number format too broadly.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Production quantities stay numeric<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Rows such as Monthly Volumes, Daily Average Volumes, Oil, Gas, Condensate, and NGL now export as plain quantities rather than currency. Financial rows continue to use currency formatting.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This makes exported LOS and Well Summary files easier to read and more useful for downstream analysis.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Zero remains a real number<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A value of zero is different from a value that is unavailable. Upstream+ now preserves that distinction in exported workbooks:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A real zero is exported as a numeric zero.<\/li>\n\n\n\n<li>An empty or unavailable value is displayed as a dash.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Because zeros remain numeric, they can be used naturally in Excel formulas, sorting, filtering, charts, and pivot tables.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Export formatting follows the report<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The export service uses the report\u2019s row types and current view to select an appropriate format for financial amounts, prices, volumes, and averages. This builds on the presentation-ready Excel and PDF exports introduced in July.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Before exporting, confirm the report mode, filters, and date range you want to share. The <a href=\"https:\/\/upstreamreporting.app\/support\/?p=21066\">Lease Operating Statement guide<\/a> and <a href=\"https:\/\/upstreamreporting.app\/support\/?p=21149\">Well Summary Report guide<\/a> explain how the current report setup carries into an export.<\/p>\n\r\n\t\t\t<div id=\"daexthefu-container\"\r\n\t\t\t\tclass=\"daexthefu-container daexthefu-layout-stacked daexthefu-alignment-center\"\r\n\t\t\t\tdata-post-id=\"21224\">\r\n\r\n\t\t\t\t<div class=\"daexthefu-feedback\">\r\n\t\t\t\t\t<div class=\"daexthefu-text\">\r\n\t\t\t\t\t\t<h3 class=\"daexthefu-title\">Was this article helpful?<\/h3>\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<div class=\"daexthefu-buttons-container\">\r\n\t\t\t\t\t\t<div class=\"daexthefu-buttons\">\r\n\t\t\t\t\t\t\t\r\n\t\t\t<div class=\"daexthefu-yes daexthefu-button daexthefu-button-type-icon\" data-value=\"1\">\r\n\t\t\t\t\r\n                <svg>\r\n                    <defs>\r\n                        <style>.thumb-up-cls-1{fill:#c9c9c9;}.thumb-up-cls-2{fill:#e1e1e1;}.thumb-up-cls-3{fill:#676767;}<\/style>\r\n                    <\/defs>\r\n                    <g id=\"thumb_up\">\r\n                        <path class=\"thumb-up-cls-2 daexthefu-icon-circle\" d=\"m24,3c11.58,0,21,9.42,21,21s-9.42,21-21,21S3,35.58,3,24,12.42,3,24,3m0-1C11.85,2,2,11.85,2,24s9.85,22,22,22,22-9.85,22-22S36.15,2,24,2h0Z\" \/>\r\n                        <g>\r\n                            <rect class=\"thumb-up-cls-3 daexthefu-icon-secondary-color\" x=\"10\" y=\"20\" width=\"6\" height=\"15\" rx=\"1.5\" ry=\"1.5\" \/>\r\n                            <path class=\"thumb-up-cls-1 daexthefu-icon-primary-color\" d=\"m30.57,9.06l-.49-.1c-.81-.17-1.61.35-1.78,1.16l-5.3,11.74c-.17.81,3.16,1.61,3.97,1.78l1.96.41c.81.17,1.61-.35,1.78-1.16l2.18-10.27c.34-1.61-.7-3.21-2.31-3.56Z\" \/>\r\n                            <path class=\"thumb-up-cls-1 daexthefu-icon-primary-color\" d=\"m38.17,20h-18.67c-.83,0-1.5.67-1.5,1.5v12c0,.83.67,1.5,1.5,1.5h16.27c.71,0,1.33-.5,1.47-1.21l2.4-12c.19-.93-.53-1.8-1.47-1.8Z\" \/>\r\n                        <\/g>\r\n                    <\/g>\r\n                <\/svg>\t\t\t<\/div>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t<div class=\"daexthefu-no daexthefu-button daexthefu-button-type-icon\" data-value=\"0\">\r\n\t\t\t\t\r\n                <svg>\r\n                    <defs>\r\n                        <style>.thumb-down-cls-1{fill:#c9c9c9;}.thumb-down-cls-2{fill:#e1e1e1;}.thumb-down-cls-3{fill:#676767;}<\/style>\r\n                    <\/defs>\r\n                    <g id=\"thumb_down\">\r\n                        <path class=\"thumb-down-cls-2 daexthefu-icon-circle\" d=\"m24,3c11.58,0,21,9.42,21,21s-9.42,21-21,21S3,35.58,3,24,12.42,3,24,3m0-1C11.85,2,2,11.85,2,24s9.85,22,22,22,22-9.85,22-22S36.15,2,24,2h0Z\" \/>\r\n                        <g>\r\n                            <rect class=\"thumb-down-cls-3 daexthefu-icon-secondary-color\" x=\"10\" y=\"13\" width=\"6\" height=\"15\" rx=\"1.5\" ry=\"1.5\" \/>\r\n                            <path class=\"thumb-down-cls-1 daexthefu-icon-primary-color\" d=\"m30.57,38.94l-.49.1c-.81.17-1.61-.35-1.78-1.16l-5.3-11.74c-.17-.81,3.16-1.61,3.97-1.78l1.96-.41c.81-.17,1.61.35,1.78,1.16l2.18,10.27c.34,1.61-.7,3.21-2.31,3.56Z\" \/>\r\n                            <path class=\"thumb-down-cls-1 daexthefu-icon-primary-color\" d=\"m38.17,28h-18.67c-.83,0-1.5-.67-1.5-1.5v-12c0-.83.67-1.5,1.5-1.5h16.27c.71,0,1.33.5,1.47,1.21l2.4,12c.19.93-.53,1.8-1.47,1.8Z\" \/>\r\n                        <\/g>\r\n                    <\/g>\r\n                <\/svg>\t\t\t<\/div>\r\n\r\n\t\t\t\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t<\/div>\r\n\r\n\t\t\t\t<div class=\"daexthefu-comment\">\r\n\t\t\t\t\t<div class=\"daexthefu-comment-top-container\">\r\n\t\t\t\t\t\t<label id=\"daexthefu-comment-label\" class=\"daexthefu-comment-label\"><\/label>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"daexthefu-comment-character-counter-container\">\r\n\t\t\t\t\t\t\t\t<div id=\"daexthefu-comment-character-counter-number\"\r\n\t\t\t\t\t\t\t\t\tclass=\"daexthefu-comment-character-counter-number\"><\/div>\r\n\t\t\t\t\t\t\t\t<div class=\"daexthefu-comment-character-counter-text\"><\/div>\r\n\t\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<textarea id=\"daexthefu-comment-textarea\" class=\"daexthefu-comment-textarea\"\r\n\t\t\t\t\t\t\t\tplaceholder=\"Is there anything else you&#039;d like to share?\"\r\n\t\t\t\t\t\t\t\tmaxlength=\"\r\n\t\t\t\t\t\t\t\t400\t\t\t\t\t\t\t\t\t\"><\/textarea>\r\n\t\t\t\t\t<div class=\"daexthefu-comment-buttons-container\">\r\n\t\t\t\t\t\t<button class=\"daexthefu-comment-submit daexthefu-button\">Send feedback<\/button>\r\n\t\t\t\t\t\t<button class=\"daexthefu-comment-cancel daexthefu-button\">Cancel<\/button>\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t<\/div>\r\n\r\n\t\t\t\t<div class=\"daexthefu-successful-submission-text\">Thanks for your feedback!<\/div>\r\n\r\n\t\t\t<\/div>\r\n\r\n\t\t\t","protected":false},"excerpt":{"rendered":"<p>Excel exports now keep currency and production quantities distinct while preserving numeric zeros for formulas, filters, and pivot tables.<\/p>\n","protected":false},"author":1,"featured_media":21218,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_helpful_status":1,"footnotes":""},"categories":[76],"tags":[51,55],"class_list":["post-21224","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-releases","tag-export","tag-import"],"wps_subtitle":"Exported reports now preserve the meaning of financial and production values more accurately in Excel.","_links":{"self":[{"href":"https:\/\/upstreamreporting.app\/support\/index.php?rest_route=\/wp\/v2\/posts\/21224","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/upstreamreporting.app\/support\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/upstreamreporting.app\/support\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/upstreamreporting.app\/support\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/upstreamreporting.app\/support\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=21224"}],"version-history":[{"count":2,"href":"https:\/\/upstreamreporting.app\/support\/index.php?rest_route=\/wp\/v2\/posts\/21224\/revisions"}],"predecessor-version":[{"id":21226,"href":"https:\/\/upstreamreporting.app\/support\/index.php?rest_route=\/wp\/v2\/posts\/21224\/revisions\/21226"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/upstreamreporting.app\/support\/index.php?rest_route=\/wp\/v2\/media\/21218"}],"wp:attachment":[{"href":"https:\/\/upstreamreporting.app\/support\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=21224"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/upstreamreporting.app\/support\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=21224"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/upstreamreporting.app\/support\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=21224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}