Hello all,
Our very old Warehouse Management System exports .CSV files that I try to use Excel to garner certain insights out of them.
One of our reports gives us an assortment of data about all of our products in our warehouse, including quantity on-hand, how many we should have, the cost per item, etc. I've used straightforward equations to multiply values together (e.g. we have 2 items on hand when we should have 12. They come in packs of four at $10 apiece. So we have to buy 2.5 packs [rounds up to 3], so it'll be $30 to get us to our level). We can only do orders if the cost is above a certain amount, and it's a laborious process for all the guys to go over printouts(!) and manually compile this.
The problem is that each vendor has a different number of SKUs, meaning there isn't a standardized way to set up arguments to add things together:
What I'm hoping to be able to do is to have Excel repeatedly find the sum of values between two endpoints (in this case, the word END). The light green box above would sum out to -76.64 while the second one would be $-69.97.
Any thoughts or advice appreciated, and thank you in advance!
- Steve
Our very old Warehouse Management System exports .CSV files that I try to use Excel to garner certain insights out of them.
One of our reports gives us an assortment of data about all of our products in our warehouse, including quantity on-hand, how many we should have, the cost per item, etc. I've used straightforward equations to multiply values together (e.g. we have 2 items on hand when we should have 12. They come in packs of four at $10 apiece. So we have to buy 2.5 packs [rounds up to 3], so it'll be $30 to get us to our level). We can only do orders if the cost is above a certain amount, and it's a laborious process for all the guys to go over printouts(!) and manually compile this.
The problem is that each vendor has a different number of SKUs, meaning there isn't a standardized way to set up arguments to add things together:
What I'm hoping to be able to do is to have Excel repeatedly find the sum of values between two endpoints (in this case, the word END). The light green box above would sum out to -76.64 while the second one would be $-69.97.
Any thoughts or advice appreciated, and thank you in advance!
- Steve
