cumulative

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