Trade Report
The trade report is a daily recurring task that must be completed first thing in the morning. The trade report is a Google Sheets page that tracks the buying and selling of local and competitor product through contracts known as “Take-or-Pay” contracts. These contracts state that each entity must pick up an agreed upon amount of volume within a specific timeframe, normally months, quarters, or semesters, or they will be charged for any product not picked up. Agreements are normally based on product swaps or trades, or whole sale prices at a discounted rate.
Process
Step 1 pulling Take or Pay and Pickup Reports
Open Alto
Select Report
Search for US_TAKEORPAYREPORTAMG_2 and double click on it.
Change Maximum Result to “0”
Check the box to Convert dates to Current Timezone
Start date = 1st day of month;
End date = Today
Click Enter to run report
Export to Excel
put aside.
Navigate back to ALTO Reports section and search for: ALUS_PICKUP_EXTRACT
Change Maximum Result to “0”
Shift Status = ALL
Start date = 1st day of month;
End date = Today
Distrib Org = US
Click Enter to run report
Export to Excel
Step 2 Data Manipulation
Open up the Trade Report Automated Excel File
Copy exported Take Or Pay excel data and paste into cell A1 on the first tab titled “Raw Data” of the Trade Report Automated file.
Click “Let's get tradin'!!
Navigate over to the pivot table tab, copy and then paste into the “Alto Take or Pay Report” tab in the Active Google Sheets Trade Report file, ensure you overwrite all information.
Clear all information on the Trade Report Automated Excel file then copy all the information from the pick up alto report extract and paste it into the Trade Report Automated raw data tab.
Click “Let's get some Pickups!”
Navigate over to the Pivot Table tab and capy the information.
Paste the information into the “Alto Competitor Pickup Report” tab in the active Competitor trade report tab on the active google sheets trade report ensuring all data is overwritten.
Step 3 Finalize and Send
Navigate over to the “Current” tab on the active google sheets Competitor Trade Report file and update the date in cell L3 to todays date.
Email a link to the trade report stating it has been updated for the day to the following people:
brendan.murphy@airgas.com
danielle.hays@airgas.com
jason.gage@airgas.com
jason.pflugh@airgas.com
justin.ross@airgas.com
mariyam.pybus@airgas.com
mark.rich@airgas.com
michelle.piech@airgas.com
Mike.Gentile@airgas.com
mike.switzer@airgas.com
patrick.nichols@airgas.com
peyton.marek@airgas.com
ww-nlc-cleveland@airgas.com
This can be copy and pasted into the to: field of the email.
Files Database