cumulative

I have a PivotChart that graphs performance by month for each doctor. For example, DOCTOR A has a stacked bar for February, March, and for April. DOCTOR B has the same months and is right next to DOCTOR A and so on. The pivot table summarizes performance by month AND gives a cumulative rate...

I would like to build a query that will rank the data by dates, average the values for the corresponding dates, and also show a running total (cumulative) average value. Assume the table below, and desired output examples. Can anyone show me an example SQL statement to do this?

Hi all, Apologies if this question seams disjointed but I am having trouble organising my thoughts. I've decided just to put what I can into words a hope someone can help. I have a cumulative data set as follows. I have graphed this data and created a 3rd order polynomial regression equation...

Dear All, I hope it is possible that you could help me with the following problem. This has been bugging me for some time now. I have a table that lists days spent on an activity by month (D7:D17). The next column keeps a running total of these days (E7:E17). From the cumulative totals...

I need to display basic performance of the recovery department in operating theatres. Ideally... I'd like to see <TBODY> Hour Patients Admitted Patients Discharged Avg Patient LoS Patients In Recovery ... ... ... ... ... 08:00 10 8 01:34:20 15 09:00 5 7 02:24:04 13...

A company gets paid, on product sales one quarter in arrears, the following royalties: Less than $100M in annual sales: 4.7% From $100M to $200M: 6.6% From $200M to $400M: 7.5% From $400M to $1,500M: 9.4% More than $1,500M: 9.3% Sales in a given year are: Q1: $43M Q2: $47M Q3: $55M Q4: $62M...

Hi guys I must admit Im pretty amateur with Excel and am trying to do something that's way over my head. Basically, all I need to do is have a cumulative total in one cell that adds the same figure each fortnight. ie, adding 100 each fortnight would give me 500 after five fortnights. Im...

Trying to setup a cumulative sum but cant get it right. a b c d Denom Qty Total Qty Total 1.00 1 1 1.00 But on day 2 b2 changes and i put 4, c2 changes to 5 and d2 changes to 5.00. on day 3 b2 changes to 4, c2 becomes 9...

Hi, I'm using Excel 2010 and need some help making a graph. I have 3 groups of people (13-15, 16-18, 19-23), and for each 1 person in each group I have a time they signed up. Sample input: 13-15 <TABLE style="WIDTH: 81pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0...

I have a plot with set phi grain size values on the X-axis, and percent on the Y axis. The plot is made by calculated cumulative values. What I need is a way to determine what the grain size value (X) is at any point (n'th percentile) on the "cumulative curve" (see picture). I should add that...

I start out a workweek with one tab for Monday's date. Each day I duplicate the tab and change the numbers. Then I start all over the next week. I would like to create a formula on Monday's worksheet that will sum up one cell. For instance, cell C22 would contain a formula that will...

In this spreadsheet start and stop times are clocked in [h:mm] format in specific columns. The row has nine such available start/stop iterations. Each row represents a complete 24-hr day. In most cases only a few Time columns will have data. The first Time column is presumed to always be a...

Hello, all Experts! Does anybody know how to add a calculated field showing cumulative percentages per row on a Pivot Table? I'm working on a delivery report showing delivery times (=delivered before 8:00 AM, delivered before 9:00 AM etxc.) and I can see the actual percentages per customers /...