Without knowing how your Excel templates are structured or built it would be difficult to give a pertinent answer. So take my answer with a grain of salt please.
From my experience, anyone using Excel to manage a specific area of the business is for the lack of a better and a more specialized tool.
Excel is great because is so versatile and you can implement virtually any solution fairly easily. But as soon as you want manage and centralize the information stored that way it becomes problematic. It would be helpful if you could post one of the templates but it doesn't sound like BPC is what you need.
It sounds like you need a form system (a simple web page(s) can do it) to capture the information the users normally submit via Excel. Then all the entries can be stored directly into a structured format (usually a relational /SQL database) and once it's there you can virtually do anything with it - report from it, track it, summarize it, prioritize it, etc.
Any web developer should be able to do this in a couple of days. Obviously you will then want manage (track, route, approve) these submissions and that may take a little longer to implement. The key to this is to have clear requirements and what features you actually need from such a system. Then prioritize the requirements and implement them step by step so each step that is implemented has an actual tangible business value (for example having a form the users can use and submit has a directly tangible business value, designing the database back end does not).
I hope this helps.
Stefan
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.