- Based on the two CSV files CUrrent Stock, Sales for the last 14 days and the logic that needs to identify the the stock that needs to be reordered from the respective supplier can be generated.
- Solution could be built on Excel or MS Access based on the complete understanding.
- Have done very complex solutions in Excel and also in MS Access
- Am not sure how WaWi works but we can have a threshold value set, for each item or make it generic so that at any point of time if the stock reaches the reorder level then we can list all those itmes for the day.
- Have it segreggated to be sent to respective supplier.
My Skills:
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Extensively the macros/VBA to automate:
- Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells
- Data camparision using formulas, lookups and bringing up summaries.,
- Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them.
- With summary data plotting graphs, bringing pivot tables