+ Reply to Thread
Results 1 to 2 of 2

Automated Analyzer

  1. #1
    Registered User
    Join Date
    12-17-2013
    Location
    nowhere
    MS-Off Ver
    Excel 2007
    Posts
    2

    Automated Analyzer

    Hi,
    In my Excel is added addon/plugin called "bex bw" (NONenglish language, a lot of custom NONenglish filters) whos main purpose are very complicated filtering and refreshing datas based on new (or edited) datas/values in the same Excel files updated (in realtime with one click done only on file opening) by users who also have in network area access for such file and who have resources based on updates of files can be done. However my question doesn't have much to do with "bex bw" addon anyway.

    I would like to ask: Does exist any excel's addon (or any kind of software that can use Excel file extensions) which could analyze every single filter's (every single piece of chart's axis) parameter with every single cell (all columns/lines) within the same Excel file? So analyzed would be every cell with every other cell, including any and all (one by one) filters? I know such analysis would take weeks of frozen pc, operating on that task, due to many custom filters, and every single filter containing hundreds of parameters, every parameter containing thousands or even tens of thousands of cells, even in different worksheets within the same excel file. However such addon/software would save me months of work.

    I think I would clarify my question the most with defining ultimate goal of such addon/software: I would like get reports of uncommon variations/deviations seen on charts so I could get answer on the question similar to "Why is particular line in graph (or particular datas in tables) different/unusual than others?" or answer on the question similar to "Because of parameters of which filters and which conditions are some values in tables so much different than other ones?"

    I tried to search a lot for such:

    "Filter Analyzer"
    "Cell Reporter"
    "Tables Analyzer"
    "Variations/deviations Researcher"
    "Uncommon values Looker"
    etc

    But no luck so far. Some tool similar to this would really save minimum few months of work.

    ***NOTE: My question is more based on general Excel and NOT just "bex bw" addon where are my thousands of filters with tens of thousands of parameters, each containing hundreds of thousands of values (so quantity of analyis would go by far above 1 billion) so Please don't ignore my question just because you might not use/have "bex bw". I am asking for Excel in general.

  2. #2
    Registered User
    Join Date
    12-17-2013
    Location
    nowhere
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Automated Analyzer

    hmm, hello??

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 17
    Last Post: 08-04-2013, 05:22 PM
  2. Need Help Excel VBA Programming for Agilent ESA Spectrum Analyzer
    By varshneybhasker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-17-2013, 01:03 PM
  3. Excel Analyzer?
    By 123wc in forum Excel General
    Replies: 2
    Last Post: 12-06-2011, 09:47 AM
  4. Performance analyzer
    By gtmeloney in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-05-2009, 03:45 PM
  5. Excel sheet analyzer/generator
    By Tomasz Klim in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-10-2006, 05:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1