Oilfield Auction Inventory Setup

I need help bringing order to the drilling equipment and the pipes & tubing I regularly pick up at auction. My goal is a mixed system: clear, well-structured spreadsheets for quick on-site data entry paired with a light software solution that can sync those sheets, flag duplicates, and let me run basic reports.

Here’s how I picture the workflow:

• You’ll design the spreadsheet layout—fields for lot number, purchase date, dimensions, condition, storage location, and resale notes—so my crew can fill it out the moment a pallet arrives.
• On the automated side, recommend and configure a user-friendly tool (Excel with Power Query, Airtable, or something similar) that pulls the sheet data, assigns unique IDs, and generates a dashboard I can review every month.
• Once everything is in place, document a simple step-by-step routine so that, at the end of each month, we can reconcile counts, spot shortages, and export an updated inventory PDF for the accountant.

Deliverables will be the master spreadsheet template, the configured software workspace, and clear written instructions. If you’ve set up hybrid inventory systems for oilfield gear before—or any heavy industrial assets—let me know; that experience will be invaluable.