View Single Post
 
Old 12-20-2013, 01:10 AM
NewPuppy NewPuppy is offline Windows XP Office 2007
Novice
 
Join Date: Dec 2013
Posts: 10
NewPuppy is on a distinguished road
Default

There is no way I could discuss with my organization what I am asking here. Noone knows that, thats why they are wasting time with manual analysis.
I apologize but I disagree on your comment saying I cannot analyze what isn't defined. In above example, I haven't defined color of skin, favourite sport, favourite book, etc. However it is very possible that (random chosen SUBexample on previous example) people, whos favourite sport on parameter ''Indoor Team Sports'' (parameter of filter) is Volleyball (value), are too many (too many persons) and cannot accept all of them for (randomely saying) membership from X country (given filter) in Y continent (given parameter of filter).

Here I just proved you what isn't defined can have major impact on results. Surely I must input what I am interested for BUT when I said ''what isn't defined'' I was referring to all high number of filters, their parameters, values of those parameters that are NOT enabled to be filtered. With ''to be filtered'' I mean where the datas on worksheet are shown only if meeting criteria of enabled filter. But as said I know I definitely have to define what I am interested for. However definitely must be compared everything.

However defining what I am interested for (=getting report from what data I want to get in order to see out of ordinary related data, one filter/parameter/value with another for purpose of getting the answer on question ''Where further work/improvement must be done?'') can be giant trouble if I want to see in general for entire Excel file what is going on. Even such definition of interest might be bigger waste of time than doing this procedure manually (without tool I am asking for) - I might need to define hundreds or thousands of interests (relations: e.g.: What is causing the Sale to be Reduced In particular month and year in X country) with same amount of defined boundaries (e.g. Sale is reduced if it goes below $500,000). The answer could be wrong material (filter = material) on wrong location (filter = manufactory's location) used, although I wouldn't filter the data based on those two filters.

Anyway my question still remains. Which tool could I use for this? Obviously tool has to be able to access everything from extremly isolated (but entirely located within Excel, except files aren't opened from hard drive but from some internal networking point) and customized addon: BW.
Reply With Quote