Inventory Data Comparison
Budget: $10 – $30 USD
I am looking for a freelancer to compare inventory data from two Excel files that contain data for over 500 products.
Files to be processed:
- File 1: Contains old data for product name and inventory quantity.
- File 2: Contains updated data for product name and inventory quantity within 24 hours.
Required from freelancer:
- Create a new Excel file that contains a comparison of inventory data from the first and second files.
- Add a new column to the new file that shows the inventory shortage for each product.
- Handle new products that may exist in the second file but not in the first file.
Notes:
- The new file must be well-organized and tidy.
- The data in the new file must be accurate and correct.
Additional notes:
- The freelancer can use any appropriate method to compare inventory data.
- The freelancer can use any appropriate method to add an inventory shortage column to the new file
Files to be processed:
- File 1: Contains old data for product name and inventory quantity.
- File 2: Contains updated data for product name and inventory quantity within 24 hours.
Required from freelancer:
- Create a new Excel file that contains a comparison of inventory data from the first and second files.
- Add a new column to the new file that shows the inventory shortage for each product.
- Handle new products that may exist in the second file but not in the first file.
Notes:
- The new file must be well-organized and tidy.
- The data in the new file must be accurate and correct.
Additional notes:
- The freelancer can use any appropriate method to compare inventory data.
- The freelancer can use any appropriate method to add an inventory shortage column to the new file