We have two csv files that we want to import into excel to have formulas applied to ::: .
The CSVs we use have static number of columns, and static column names, if that helps. We want formulas applied to compare quantity sold (which is on one csv) against current re-order points (on the other csv) and create a result in the format of second csv. Here's a crude breakdown of what the end result should be:
reorder point = quantity sold/2 + 20%
reorder amount = quantity sold
This is based on a given time frame of product turnover. We also have turnover percentages on the first csv which may be helpful to avoid missing a valid re-order point.
The csv files will vary in rows.
I will provide sample CSVs file once the project has been awarded.