Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Location: NC
Posts: 3
Default Percentage of Weight Loss/Gain

I am needing help with a weight loss or gain formula that will calculate the percentage of gain or loss in a patient over a period of time. For example:
January 130, February 133, March 127. What would be the percentage of gain between January and February and then the percentage of loss between February and March. I would like to calculate a total percentage of loss/gain of all three. I need to make this a running spreadsheet if possible.

Thanks in advance!
  #2   Report Post  
Senior Member
 
Location: Belo Horizonte, Brazil
Posts: 170
Thumbs up

Quote:
Originally Posted by cbarwick70 View Post
I am needing help with a weight loss or gain formula that will calculate the percentage of gain or loss in a patient over a period of time. For example:
January 130, February 133, March 127. What would be the percentage of gain between January and February and then the percentage of loss between February and March. I would like to calculate a total percentage of loss/gain of all three. I need to make this a running spreadsheet if possible.

Thanks in advance!
Good afternoon cbarwick70

I did an example for you.

Please tell me if it's what you desire.

Have a nice day.
Attached Files
File Type: zip CBARWICK70_Weight_Control_14-APRIL-2013.zip (5.2 KB, 37 views)
__________________
I hope it can help you.

Best regards,
Marcilio Lobão
---------------------------
Belo Horizonte, Brazil

Last edited by Mazzaropi : April 15th 13 at 01:24 PM Reason: mistyped
  #3   Report Post  
Junior Member
 
Location: NC
Posts: 3
Default

Thanks for this!! It is exactly what I needed and I appreciate you helping me with this!!

Thanks again!
  #4   Report Post  
Junior Member
 
Location: NC
Posts: 3
Default

OK, need some help. How can I get the formula to calculate the Total when I have a resident admitted in March or some other month besides January?
Thanks for your help again!


I did an example for you.

Please tell me if it's what you desire.

Have a nice day.[/quote]
  #5   Report Post  
Senior Member
 
Location: Belo Horizonte, Brazil
Posts: 170
Thumbs up

Quote:
Originally Posted by cbarwick70 View Post
OK, need some help. How can I get the formula to calculate the Total when I have a resident admitted in March or some other month besides January?
Thanks for your help again!
Hi cbarwick70
There´s a file with new formulas.
Tell if it´s what you desire now.

Have a nice day!
Attached Files
File Type: zip 16-04-2013_ExcelBanter_CBARWICK70_Weight_Control.zip (5.7 KB, 75 views)
__________________
I hope it can help you.

Best regards,
Marcilio Lobão
---------------------------
Belo Horizonte, Brazil
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
gain and loss gma Excel Worksheet Functions 1 March 2nd 09 08:43 PM
gain-loss gma Excel Worksheet Functions 5 February 23rd 09 10:07 PM
Weight Gain Loss JoeMNY Excel Discussion (Misc queries) 3 December 31st 06 10:32 PM
does anyone have a chart for weight gain or loss in kilos? Robynr Excel Discussion (Misc queries) 3 January 9th 06 12:01 PM
Weight loss line chart to monitor weight loss progress S Fox Charts and Charting in Excel 6 November 8th 05 05:10 PM


All times are GMT +1. The time now is 01:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"