periodic

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

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

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

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?

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

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