Print

Print


Message
To clarify, I have 7 time periods:
 
Inpatient Surgeries        100    121    113    155    101    122    114
Outpatient Surgeries      233    302    188    177    222    244    201
 
I need a calc that takes into account the fluctuation up/down of the data points. The end result I need is a % rate of growth (or decline) over the 7 periods.


From: Excel Visual Basic for Applications. [mailto:[log in to unmask]] On Behalf Of Rushton, Martin
Sent: Thursday, August 02, 2007 10:34
To: [log in to unmask]
Subject: Re: Growth Rate calculation

If  we are talking about a simple monthly growth/decline (based on previous month) 
=(2350-2300)/2300 
replace values with cell references, format as percentage and copy across or down as appropriate.  Or are e you looking for something more complicated?
-----Original Message-----
From: Excel Visual Basic for Applications. [mailto:[log in to unmask]] On Behalf Of Gerena, Dan
Sent: 02 August 2007 15:04
To: [log in to unmask]
Subject: Growth Rate calculation

Let's say I have a series of monthly numbers for an item...
 
Surgeries: 2300, 2350, 2100, 2650, 2750, etc.
 
Is there a calc that would tell me if the rate of growth (or decline) over those periods (assuming I have 12 periods, thus 12 data points)?
 
 

Kaleida Health's economic impact on Western NY exceeds $2.2 BILLION annually.

Check us out at: www.WesternNYshospitalofchoice.org

CONFIDENTIALITY NOTICE: This email transmission and any documents, files, or previous e-mail messages attached to it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any further review, disclosure, copying, dissemination, distribution, or use of any of the information contained in or attached to this e-mail transmission is strictly prohibited. If you have received this message in error, please notify the sender immediately by e-mail, discard any paper copies, and delete all electronic files of the message. If you are unable to contact the sender or you are not sure as to whether you are the intended recipient, please e-mail [log in to unmask] or call (716) 859-7777.


To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm


Kaleida Health's economic impact on Western NY exceeds $2.2 BILLION annually.

Check us out at: www.WesternNYshospitalofchoice.org

CONFIDENTIALITY NOTICE: This email transmission and any documents, files, or previous e-mail messages attached to it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any further review, disclosure, copying, dissemination, distribution, or use of any of the information contained in or attached to this e-mail transmission is strictly prohibited. If you have received this message in error, please notify the sender immediately by e-mail, discard any paper copies, and delete all electronic files of the message. If you are unable to contact the sender or you are not sure as to whether you are the intended recipient, please e-mail [log in to unmask] or call (716) 859-7777.