trend

Hi all, I have been learning from this forum for years, and now it is time for my first post. Thanks in advance for your help and for all these years of teaching :) I need to convert yearly figures to months, following a given trend, and then automate the workbook so it can be done as...

Good Afternoon, I am trying to calculate Trend to Target for Oct 1-Dec 31. So Cells A8:A99 are my dates, Cells B8:B99 are my daily sales, cell B4 has my target and I want to insert my trend in cell B6. As I enter my daily sales in B8:B99, B6 will automatically update my trend to target. For...

Hi, I have two columns of data : <tbody> A 23 A 33 B 12 B 44 </tbody> What I would like to be able to do is ask the user how many in column 1, cells are the same (what is the trend) in this case it would be two as we have Two As, Two Bs. Then I would like to be able to prompt the...

I have a PivotTable with sales data for years 2008 - 2016. I want to average 2008 - 2011 and compare each subsequent year to this average to see if there is a trend. Is this possible to average unique column headers and then add this as a base to which I can calculate the change of?

Hey hoping someone can help out with this. Im looking to use the Trend function but not in the traditional way such as instead of trending cells b1, c1, d1, etc... I want to trend the cells just mentioned plus the cells below (b2, c2, d1, etc.). Reason for this is the setup of the budget. 2016...

Hi - this is going to be a lengthy post. I've been researching the forecast and trend function. I have 3-4 questions numbered below: 1. Several other websites have indicated that the trend and forecast function generate the same results. Yet I haven't been able to. Am I doing something...

Hello all! I am working on a project that tracked participants eyes as they looked at various pictures. I now have several tables (for each of the different participants) and need a way to determine a trend. The tables currently have, where they looked (Location 1, 2, 3, 4, ext.) and how long...

Dear All, please can anyone help me with this question. I have a series of 5 known y values and five known x values. I have used the Excel in-built charting facility to plot a line graph / curve for these values, and have added a polynomial trend line projecting 6 further y values for a further...

Hello, I am a total newbie at forecasting and have a question about the forecasting function. I have three months worth of sales data for 8 SKUs. I need to predict the next six months of sales for these SKUs. Would the =FORECAST(x, known_y's, known_x's) function work for me here? Here's...

Hi All I'm creating a dashboard for reporting the sites performance and I would like to add a trend Arrow (Up, Down or Flat) What I want to do is trend the previous collected data points performance and visually see if there is an improvement: i:e Data points could be Months of the yr completed...

<dir>I would like to use fomulas to generate y-values on the fly to be used in a TREND function like =TREND({sum(5,A1),sum(1,A2)},{3,2},7). But this doesnt seem to work as it seems input array elements are not allowed to be formula themselves. Storing sum(5,A1) & sum(1,A2) on other cells and...

Good-day, I'm working on a small spreadsheet to analyse sales performance of some customers and I'm trying to compare the metrics for the last three years (2014, 2015, and 2016). What I would like to achieve is to show an UP, DOWN, or SIDEWAYS arrow indicating the trend of the numbers. I have...

Hello party people. I am trying to forecast/trend some safety metrics. The goal is to have 0 (zero) for the year or to be as low as possible. Each category started with zero, we had some incidents, but the metrics have been trending lower since. When I try using the forecast or trend...

Hi All, I've been struggling in how to come up with a decent formula in order to see the trending regarding weight loss/weight gain for our group over a duration of 12 weeks. I've used the if formula, but still unable to create a decent formula that would address our trending. we do weekly...

I'm trying to trend out some numbers. I have two sets of numbers: The first we can call a "local" projection and the second we can call a "national" projection. For the national projection I know all 3 numbers: Low, Medium, High For the local projection I know only 1 number: Low I would...

Everyday I send out a report of the number of items at certain sites broken down into age buckets of how long the item as been sitting at that specific location. These totals are calculated by simply pulling the number of items at each site and comparing the date they were moved there to today's...

I have a somewhat complicated problem that I was hoping some of you may have some ideas for, both in approach and execution in Excel. SITUATION: We have many accounts (70+) each of varying sizes and ticket volumes. Some accounts may have thousands of tickets per week, others may have 1 or less...

I'm stumped with trying to figure out how to determine the number of times multiple documents are overdue within a specific time period. I have a document issue date (Column A), and a document due date (Column B), that I need to group into monthly reports (e.g. how many were late this month)...

I am curious to know if one could create a "management overview" workbook containing live links to various other workbooks. As such, the values on the single management workbook would change immediately after values were changed in any linked supporting workbooks. The tricky part would be that...

Hi all! I would like to know if there is a way to set a coefficient in the trendline equation to zero. For example: The equation of the second order trendline is Ax^2 + Bx + C I want to find a way to set B = 0 I know it's possible to set C = 0 by setting the intercept, so I was wondering if...