I need a very basic application that can scan a spreadsheet and identify cell content patterns in columns.
There is a limit of 6 different words that will appear in each cell. Let's say 'dog', 'cat', 'mouse', 'boy', 'man', 'woman'.
If you go down a column, one of these words will be in each cell in a random pattern.
I need to be able to run this app to discover patterns that i identify by a name. Like, the pattern 'dog-cat-man' would have a name, 'mouse-woman-boy' would have a different name. with the app runs, it tells me by number how many of each of these patterns have occurred in the spreadsheet.
I would like to be able to manually enter these names and patterns and run searches like this.
The spreadsheet is also divided by agent ID so the app would have to be able to separate that as well. See the attachment to fully understand.
The description sounds much more complicated than the actual product i am looling for. Look on the 'Activity Patterns' tab for further directions. The name of the app should be 'RM App'.
This App may tie into a simple access Dbase also in the future to store data and run reports. if you can do both, give a prices for with and without the dbase.