1. R

    How to track when project spending has slowed for 2 months in a row?

    Hello, I'm wanting to create an indicator that shows me when a project has overspent for multiple months or under spent by multiple months. I want to do this for over 50 projects. I have monthly spending by project. I'm considering using outlier formulas to show me when spending is abnormal...
  2. M

    Incrementing worksheet number in a formula ?

    I have data in workbooks and on worksheets and I would like to show some of it on another workbook. I understand how to get the values from the cell I want but is there a way to copy and paste the formula so that it changes incrementally. I have a workbook called Trends, with numbered...
  3. E

    Tracking Multiple Trends in a Worksheet

    I am looking to create a worksheet where I can track trends within a row. There are about 20 different optional trends and each user can pick up to 5 trends per row. However, I want to be able to analyse these trends as a whole in a pivot table (rather than separated as trend 1, trend 2 etc). It...
  4. T

    VBA to get Google trends automatically.

    Hi all, I've been searching for a way to use VBA code to get Google Trends data automatically on to a spreadsheet. Does anyone know how to do this? I can't seem to find a way at all. Thanks :)
  5. I

    Multiple Budgets over a range of months and years, with monthly cost/estimate showing by month for each project

    I have hundreds of rows of data. Each row is a project and cost with start date and end date. Some projects are old and complete, others have started and are ongoing and some have not even started. Using the full range of dates, I want to show the cost of each project by month. I've added the...
  6. R

    Advice on using .NET programming to create Custom Excel reports tied to SQL Server

    This is more of a career question for general advice on Excel Object Model Programming. Not that I have been looking for it, I have not seen .NET applications that utilize Excel Object Model Programming. Is this a niche' market? Would it be something worth pursuing? Does Mr Excel have training...
  7. M

    Trend (?) tutorial

    Can someone point me to a good tutorial? I have very simple data - On certain dates, I measure how much hard drive space I am taking up. I would like to project when, based upon date and the rate I will be out of space. I think that is Trend, but could it be "Linear"?? <TABLE...
  8. C

    Graphs, trends and series data Help needed

    <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p>:confused: </o:p> Hi All,<o:p></o:p> <o:p></o:p> I currently have a graph based on 7 data sets, 5 are similar. 2 are % trends. I have a column graph, with values on top of each other, in weekly...

Some videos you may like

This Week's Hot Topics