Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-17-2013, 01:44 AM
NewPuppy NewPuppy is offline Automated Analyzer Windows XP Automated Analyzer Office 2007
Novice
Automated Analyzer
 
Join Date: Dec 2013
Posts: 10
NewPuppy is on a distinguished road
Default 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.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Portfolio Analyzer Cube - Cost Resource Question seanpears99 Project 2 03-07-2013 06:59 PM
Automated Analyzer Common mailbox analyzer/statistics NoStr0m0 Outlook 3 09-23-2011 05:22 AM
Automated reminders paulgy80 Outlook 1 08-21-2010 04:35 PM
Automated Letter Sections gladfan Word 0 08-11-2010 01:53 AM
Automated Functions?? nickypatterson Outlook 0 08-27-2009 01:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:37 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft