{"id":9769,"date":"2017-02-03T18:51:12","date_gmt":"2017-02-03T18:51:12","guid":{"rendered":"https:\/\/www.process.st\/templates\/how-to-generate-upc-audit-data\/"},"modified":"2024-02-28T20:49:46","modified_gmt":"2024-02-28T20:49:46","slug":"how-to-generate-upc-audit-data","status":"publish","type":"post","link":"https:\/\/www.process.st\/templates\/how-to-generate-upc-audit-data\/","title":{"rendered":"How to Generate UPC Audit Data"},"content":{"rendered":"
\n

Excel steps <\/h2>\n
\n

Copy\/Paste table of data into TransparencyUPC sheet<\/p>\n<\/p><\/div>\n

\n
\n <\/a>
\n drag the table range to fit the pasted data if necessary
\n <\/figcaption><\/figure>\n<\/p><\/div>\n
\n

Go to the Data tab and click on Refresh All<\/p>\n<\/p><\/div>\n

\n
\n <\/a>
\n <\/figure>\n<\/p><\/div>\n
\n

Go to the Dates Sent Pivot and Rcvd Date Pivot sheets and right-click in each pivot table, choose refresh<\/p>\n<\/p><\/div>\n

\n
\n <\/a>
\n <\/figure>\n<\/p><\/div>\n
\n
\n <\/a>
\n <\/figure>\n<\/p><\/div>\n
\n

Copy all columns of the Dates Sent Pivot and paste it into the first 4 columns of the FinalCopyPasted table<\/p>\n<\/p><\/div>\n

\n
\n <\/a>
\n <\/figure>\n<\/p><\/div>\n
\n

Go to the Rcvd Data Pivot sheet and copy the Most Recent Rcvd Date column; paste into last column of FinalCopyPasted Table<\/p>\n<\/p><\/div>\n

\n
\n <\/a>
\n <\/figure>\n<\/p><\/div>\n
\n

Filter out blanks in the Received Date column<\/p>\n<\/p><\/div>\n

\n
\n <\/a>
\n <\/figure>\n<\/p><\/div>\n
\n

After table is filtered, delete data in 2 Most Recent Dates Sent column<\/p>\n<\/p><\/div>\n

\n
\n <\/a>
\n <\/figure>\n<\/p><\/div>\n
\n

Clear the filter in the Received Date column<\/p>\n<\/p><\/div>\n

\n
\n <\/a>
\n <\/figure>\n<\/p><\/div>\n
\n

Highlight the 2 Most Recent Dates Sent column, choose Text to Columns under the Data tab, and select 'Delimited' radio button, then click Next<\/p>\n<\/p><\/div>\n

\n
\n <\/a>
\n <\/figure>\n<\/p><\/div>\n
\n

Choose Semicolon, then Next<\/p>\n<\/p><\/div>\n

\n
\n <\/a>
\n <\/figure>\n<\/p><\/div>\n
\n

Choose the Date format and change the Destination to $F<\/strong>$3, then click Finish<\/p>\n<\/p><\/div>\n

\n
\n <\/a>
\n <\/figure>\n<\/p><\/div>\n<\/section>\n","protected":false},"excerpt":{"rendered":"

Excel steps Copy\/Paste table of data into TransparencyUPC sheet drag the table range to fit the pasted data if necessary Go to the Data tab and click on Refresh All Go to the Dates Sent Pivot and Rcvd Date Pivot sheets and right-click in each pivot table, choose refresh Copy all columns of the Dates […]<\/p>\n","protected":false},"author":3,"featured_media":9770,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"ep_exclude_from_search":false,"cover_icon_emoji":"","cover_icon_url":"","tasks_count":"1","template_description":"","template_id":"ujCIiyyQHsdgudst-C9AgA","task_0":"Excel steps","task_slug_0":"excel-steps","task_1":"","task_slug_1":"","task_2":"","task_slug_2":"","task_3":"","task_slug_3":"","task_4":"","task_slug_4":"","task_5":"","task_slug_5":"","task_6":"","task_slug_6":"","task_7":"","task_slug_7":"","task_8":"","task_slug_8":"","task_9":"","task_slug_9":"","task_10":"","task_slug_10":"","task_11":"","task_slug_11":"","task_12":"","task_slug_12":"","task_13":"","task_slug_13":"","task_14":"","task_slug_14":"","task_15":"","task_slug_15":"","task_16":"","task_slug_16":"","task_17":"","task_slug_17":"","task_18":"","task_slug_18":"","task_19":"","task_slug_19":"","task_20":"","task_slug_20":"","task_21":"","task_slug_21":"","task_22":"","task_slug_22":"","task_23":"","task_slug_23":"","task_24":"","task_slug_24":"","task_25":"","task_slug_25":"","task_26":"","task_slug_26":"","task_27":"","task_slug_27":"","task_28":"","task_slug_28":"","task_29":"","task_slug_29":"","task_30":"","task_slug_30":"","task_31":"","task_slug_31":"","task_32":"","task_slug_32":"","task_33":"","task_slug_33":"","task_34":"","task_slug_34":"","task_35":"","task_slug_35":"","task_36":"","task_slug_36":"","task_37":"","task_slug_37":"","task_38":"","task_slug_38":"","task_39":"","task_slug_39":"","task_40":"","task_slug_40":"","task_41":"","task_slug_41":"","task_42":"","task_slug_42":"","task_43":"","task_slug_43":"","task_44":"","task_slug_44":"","task_45":"","task_slug_45":"","task_46":"","task_slug_46":"","task_47":"","task_slug_47":"","task_48":"","task_slug_48":"","task_49":"","task_slug_49":"","task_50":"","task_slug_50":"","task_51":"","task_slug_51":"","task_52":"","task_slug_52":"","task_53":"","task_slug_53":"","task_54":"","task_slug_54":"","task_55":"","task_slug_55":"","task_56":"","task_slug_56":"","task_57":"","task_slug_57":"","task_58":"","task_slug_58":"","task_59":"","task_slug_59":"","task_60":"","task_slug_60":"","task_61":"","task_slug_61":"","task_62":"","task_slug_62":"","task_63":"","task_slug_63":"","task_64":"","task_slug_64":"","task_65":"","task_slug_65":"","task_66":"","task_slug_66":"","task_67":"","task_slug_67":"","task_68":"","task_slug_68":"","task_69":"","task_slug_69":"","task_70":"","task_slug_70":"","task_71":"","task_slug_71":"","task_72":"","task_slug_72":"","task_73":"","task_slug_73":"","task_74":"","task_slug_74":"","task_75":"","task_slug_75":"","task_76":"","task_slug_76":"","task_77":"","task_slug_77":"","task_78":"","task_slug_78":"","task_79":"","task_slug_79":"","task_80":"","task_slug_80":"","task_81":"","task_slug_81":"","task_82":"","task_slug_82":"","task_83":"","task_slug_83":"","task_84":"","task_slug_84":"","task_85":"","task_slug_85":"","task_86":"","task_slug_86":"","task_87":"","task_slug_87":"","task_88":"","task_slug_88":"","task_89":"","task_slug_89":"","task_90":"","task_slug_90":"","task_91":"","task_slug_91":"","task_92":"","task_slug_92":"","task_93":"","task_slug_93":"","task_94":"","task_slug_94":"","task_95":"","task_slug_95":"","task_96":"","task_slug_96":"","task_97":"","task_slug_97":"","task_98":"","task_slug_98":"","task_99":"","task_slug_99":"","footnotes":""},"categories":[7,1],"tags":[],"class_list":["post-9769","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-miscellaneous","category-uncategorized"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/posts\/9769","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/comments?post=9769"}],"version-history":[{"count":0,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/posts\/9769\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/media\/9770"}],"wp:attachment":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/media?parent=9769"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/categories?post=9769"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/tags?post=9769"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}