Rarebreed Purchase Orders
We receive PO's from rarebreeds once a month and some of that equipment is co-owned by Christian Klein. We do not need to send Rarebreeds an invoice but we need to go through the PO and see what amount we owe christian and send him a breakdown. To do this we will have to convert the PDF to a google sheet and then run it through our formula to have the sheet figure out the amounts for us and Christian.
Preparing the Data
- Download the PDF
Use the PDF to Excel Converter to convert the file.
- Import to Google Sheets
Open the Rarebreeds PO Tool Google Sheet.
- File > Import > Insert as New Sheet, delete the old one.
Clean the Sheet
- Delete the first row and all rows containing the word "Description."
also the final totals at the bottom, anything not a line item
- Select the cells under columns A-D (do not select entire columns).
- Unmerge cells in A-D and tax exempt column using the unmerge tool.
Format > merge cells > unmerge
- Delete empty columns (e.g., "Description" and "Tax Exempt"). and logo
- Copy and Paste Values
- delete all data in formated pasted data before pasting
- Copy the sheet and paste it into the "Formatted Pasted Values" sheet using
Command + Shift + V.
Copy and paste the final table from the summary page to an email to Christian Klein. Ask him to respond back with an invoice and let him know this is what we found from the PO. He can check it to and get back to us.
Look for Personally Owned Gear
There is gear that is owned personally by Ryan and is in the process of being paid back, look for these items and add up the total.
This spreadsheet contains all the information for what items are personally owned.
Ryan will update this as he creates invoices.
Send these figures in an email to Ryan.