Re: Calculations Across Tables

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks for the input. I would combine all of the data, but it helps in
other calculations to leave them separate.

For example, right now I have 5 separate queries, one for each table,
that does the same percentage calculation, but based on the maximum
within the table - instead of across all 5 tables. It seemed to me
that it would be easier to analyze the data if the current
distinctions are maintained.

On the other hand, I can keep the idea of merging the data as a
backup, because I'm pretty sure I'm capable of handling those
statements.

Do you have any suggestions for my original question?

.

Relevant Pages

  • Re: Optimizing the Speed / Design tradeoff in numeric applications
    ... calculations to arrive at three values, named d2, t0 and theta. ... it's obvious in intent and can share common subcalculations. ... Only if you want to calculate any one of d2, t0 and theta in isolation from the other two does it really make sense to have separate functions for each. ...
    (comp.programming)
  • Re: How can I create this formula?
    ... Expand B6 so that it all fits. ... The subtraction doesn't seem to quite work properly, ... to separate out months/days/hours/seconds into different calculations ...
    (microsoft.public.excel.programming)
  • Re: Web Interface and index.pl separated?!?
    ... Do you think that i must separate the page's interface in a file ... One way would be to do the calculations required and then print all the ... HTML with any results inserted as a 'here' document (or several to keep ...
    (comp.lang.perl.misc)
  • Re: Web Interface and index.pl separated?!?
    ... "Do you think that i must separate the page's interface in a file by itself ... business layer i.e. your calculations seperate. ... Prev by Date: ...
    (comp.lang.perl.misc)
  • Re: Help with formula - ranking & high values from un-sorted numbers
    ... The original question WAS pretty vague, as to what you wanted to calculate: ... the formula into the cell, type Control-Shift-Enter to activate. ... NEXT highest velue would be given 7th place ranking. ... that combines calculations from $F and $C above. ...
    (microsoft.public.excel.worksheet.functions)