Visual Basic for Apps Job by tonyb1

Hello, I am interested in following inventory patterns of a suppliers inventory levels.

We receive an hourly excel feed and would like to upload this daily into a program that will gauge the progress and digression of all inventory levels of each sku/part # over time. (There are 1000's)

The idea:

Notify us of all inventory that reaches a level of 0 twice in say a 60 day period (option to select a 30 day period ect.) for at least 5 days or more both times.

Example - Notify us on the 5th day that SKU A is without inventory for the 2nd time within a 60 day period.

Then notify us when the inventory replenishes to 100% for these SKU's (this is when we want to start following the pattern to buy on the 3rd time).

Then notify us when inventory has 30% remaining during the 3rd occurence

Then repeat process for 4th occurrence ect.

Sort by price feature would be nice

Sort ability for length/total # of days without inventory from greatest number of days to least. SKU A - total number of days 16, SKU B total number of days 14.

We also have popular sku's we presently monitor manually to see when inventory is replenished. We would like to be able to input these sku's/part numbers into a program so we can be notified the day the inventory arrives/replenishes.

Can we implement this into an interactive dashboard? I'm not sure if this is the correct terminology. Is this referred to as VBA Excel?

Please let me know your thoughts on this and and an estimate of hours this will take. Any ideas are welcomed and clarification of what I am trying to do.



Skills: Visual Basic for Apps

See more: price for vba for excel, what is vba in excel, vba project f, VBA excel dashboard, tony, sku inventory, project on vba, pattern repeat, gauge, excel feed price, sku inventory dashboard, custom hello program, interactive excel, program project inventory, implement 2012, inventory dashboard, 504, excel project idea, excel custom number, interactive inventory excel, excel number custom, repeat patterns, program inventory part, inventory daily excel, day day inventory excel

About the Employer:
( 0 reviews ) United States

Project ID: #2552821

1 freelancer is bidding on average $200 for this job


Hired by the Employer

$200 USD in 20 days
(5 Reviews)