1. T

    help building an expression

    Hi! I need help building an expression for a field in a query I'm designing. I have columns of dates and types of reviews. Example: SiteID SiteDate Purpose 03500000 05/09/13 Initial Full Scope 03500000 08/17/15 Periodic Full Scope 03500001 05/09/13 Initial Full...
  2. K

    Calculate Cumulative Return from Periodic Returns not in Percentage Format

    I have a column of numbers representing periodic returns (but expressed without the %): 1.31 0.21 -0.33 I want to calculate a cumulative return of the "% changes" above (the answer is 1.1877% in this simplified case), but with some restrictions that make this hard for me to figure out: I'd...
  3. D

    How to identify a period of defined monthly performance

    Hi Everyone, I'm using Excel 2007 on Windows 7 I'm not sure how to best describe this with the appropriate terminology. I appreciate the patience of you experts. I have a range of monthly performance for a benchmark and my portfolio. I am looking to identify periods where I can set the...
  4. Y

    Periodic Macro

    Hi there, I'm wanting to have a macro that will run on a certain day of the week, every week. How can i do this?
  5. A

    Intermittent Forecasting

    This is a unique problem I have never encountered and I wanted to see if I could get some thoughts. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I am working on 5-year monthly projections in a clinical trial environment. Each trial will have different...
  6. N

    working out the frequency of a periodic function

    Hi i have some data that shows a sawtooth like periodic shape with time.Column a is the time, hh:mm:ss.00, column b is the data, with one point every second. The data increases for about a minute, then drops back to its original value I would like to work out the frequency of this sawtooth...

Some videos you may like

This Week's Hot Topics