periodic

  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...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top