Advertisement -- Learn more about ads on this site.
 

team1111forum


  Team Forum
At Goal & Maintaining + Transition to Maintenance

A Guide to Posting in Your SparkTeam Forum

  FORUM:   General Team Discussion Forum
TOPIC:   Question about Moving average tool 


Search
Reply Create A New Topic Subscribe to this Discussion
Advertisement -- Learn more about ads on this site.
Author: Message: Sorting Last Post on Top


4A-HEALTHY-BMI
4A-HEALTHY-BMI's Photo Posts: 5,853
3/24/14 8:27 P

4A-HEALTHY-BMI's SparkPage
Send Private Message
Reply
Here is a whole list of the tools used by folks in our current maintenance challenge:
docs.google.com/spreadsheet/ccc?key=0Ah4Kr
A4GkhKgdEJyRkNpSEhYbmJwSEhrVVJaX3BwT1E
&usp=drive_web#gid=5


...and here are some other threads about such methods:
www.sparkpeople.com/myspark/team_messagebo
ard_thread.asp?board=-1x1111x53074736


www.sparkpeople.com/myspark/team_messagebo
ard_thread.asp?board=681x1111x53148587


Edited by: 4A-HEALTHY-BMI at: 3/24/2014 (20:37)
Never, ever, EVER give up!

From BMI 53 (336 lbs) to under 30. Now aiming for less than 20% body fat.

Media
tinyurl.com/4a-healthy-bmi-me
dia


Weight chart
tinyurl.com/4A-HEALTHY-BMI-graph

Blogs
tinyurl.com/4a-healthy-bmi-bl
og-index


Goal 155 +/- 3%


223 Maintenance Weeks
 
0
60
120
180
240


4A-HEALTHY-BMI
4A-HEALTHY-BMI's Photo Posts: 5,853
9/3/12 9:46 P

4A-HEALTHY-BMI's SparkPage
Send Private Message
Reply
It isn't actually all my personal info, but if that's an overwhelming number of links, then you can look at just these.

They are all online places where you just put in your weight every day and see what the trend line (the moving average number) does. No need to know anything about how spreadsheets work, or the formulas in them, etc.

myhackerdiet.com/

www.myweightracker.com

www.physicsdiet.com/

www.fourmilab.ch/hackdiet/online/hdo.html

www.google.com/ig/directory?type=gadgets&u
rl=www.google.com/ig/modules/google15.
xml


(Just some options in case the spreadsheet is too confusing - I don't actually know what it's doing.)

Never, ever, EVER give up!

From BMI 53 (336 lbs) to under 30. Now aiming for less than 20% body fat.

Media
tinyurl.com/4a-healthy-bmi-me
dia


Weight chart
tinyurl.com/4A-HEALTHY-BMI-graph

Blogs
tinyurl.com/4a-healthy-bmi-bl
og-index


Goal 155 +/- 3%


223 Maintenance Weeks
 
0
60
120
180
240


BESTSUSIEYET
BESTSUSIEYET's Photo Posts: 3,493
9/3/12 9:38 P

BESTSUSIEYET's SparkPage
Send Private Message
Reply
@4AHealthyBMI ... I clicked on the link & those on Hackers Diet Team, and they all have lots of personal info already filled in. They have far more info than I have a clue what to do with or make sense of ... But thanks for sharing. Guess you have to have read the book for any of it to make any sense...

Edited by: BESTSUSIEYET at: 9/3/2012 (21:40)
"Be diligent in these matters; give yourself wholly to them, so that everyone may see your progress." I Timothy 4:15

1 Cor. 10:23 "Everything is permissable, but not everything is beneficial."
(NIV)



 current weight: 7.0  over
 
10
5
0
-5
-10


LJR4HEALTH
LJR4HEALTH's Photo Posts: 32,265
9/3/12 9:16 P

LJR4HEALTH's SparkPage
Send Private Message
Reply
I use the google 15 for tracking my weight daily its a good one

Linda (Florida - Eastern Standard Time )

I am " (we are) spiritual beings having a human experience " Pierre Teilhard de Chardin

Amethyst BLC Fall 2012 to Summer 2013

2012 Fall 5% Challenge Community Team Casual Travelers t0
2013 Spring & summer 5% Challenge Community Casual Travelers

BLC22 CAMO CREW Squad Violet Assassins

Previous BLC 17 to BLC 20

“Fail to plan, plan to fail.” Carl W. Buechner




4A-HEALTHY-BMI
4A-HEALTHY-BMI's Photo Posts: 5,853
9/3/12 3:38 P

4A-HEALTHY-BMI's SparkPage
Send Private Message
Reply
@ BESTSUSIEYET
I think you probably want to use the number in column F (Moving Average) for today.
I'm not really sure what they're doing there, or why you'd have numbers showing up for days ahead of now, unless they are projecting what your average would be if your weight for the days in the future were zero (because you haven't filled them in yet).


@All: for more tools, try the links at the hacker's diet team. Which is all about using a moving average.
www.sparkpeople.com/myspark/groups_links.a
sp?gid=31785


:-)


Edited by: 4A-HEALTHY-BMI at: 9/3/2012 (19:07)
Never, ever, EVER give up!

From BMI 53 (336 lbs) to under 30. Now aiming for less than 20% body fat.

Media
tinyurl.com/4a-healthy-bmi-me
dia


Weight chart
tinyurl.com/4A-HEALTHY-BMI-graph

Blogs
tinyurl.com/4a-healthy-bmi-bl
og-index


Goal 155 +/- 3%


223 Maintenance Weeks
 
0
60
120
180
240


THECRAZYMANGO
THECRAZYMANGO's Photo Posts: 6,438
9/3/12 3:29 P

THECRAZYMANGO's SparkPage
Send Private Message
Reply
What a cool idea!! Might have to try it!!!

-Savannah

Not worth having is easy!




 current weight: 203.0 
 
205
191.25
177.5
163.75
150


BESTSUSIEYET
BESTSUSIEYET's Photo Posts: 3,493
9/3/12 3:25 P

BESTSUSIEYET's SparkPage
Send Private Message
Reply
The Moving average is more than just the "mean" (which is what you get if you add the last few entries & divide the sum by the number of entries.). MathDude had an explanation ... But I sure couldn't explain it! Here is the link to the moving average tool I downloaded and have been tracking on for a few weeks. (It's an Excel spreadsheet and opens with the QuickOffice app on my iPad.)
quickanddirtytips.com/static/moving-averag
e-calculator.xlsx


Edited by: BESTSUSIEYET at: 9/3/2012 (15:30)
"Be diligent in these matters; give yourself wholly to them, so that everyone may see your progress." I Timothy 4:15

1 Cor. 10:23 "Everything is permissable, but not everything is beneficial."
(NIV)



 current weight: 7.0  over
 
10
5
0
-5
-10


CAROLJEAN64
CAROLJEAN64's Photo Posts: 11,175
9/3/12 3:18 P

CAROLJEAN64's SparkPage
Send Private Message
Reply
I would use the one that shows up after you weigh for the day. I think what's important is to use the same most recent number. BTW, I use a phone app called Libra.

Lost 65 lbs and maintained since 2006.


 current weight: 5.0  over
 
10
5
0
-5
-10


THECRAZYMANGO
THECRAZYMANGO's Photo Posts: 6,438
9/3/12 3:02 P

THECRAZYMANGO's SparkPage
Send Private Message
Reply
Okay I am super confused. What do you mean moving average tool? Do you take the mean of what you weigh?

-Savannah

Not worth having is easy!




 current weight: 203.0 
 
205
191.25
177.5
163.75
150


BESTSUSIEYET
BESTSUSIEYET's Photo Posts: 3,493
9/3/12 2:59 P

BESTSUSIEYET's SparkPage
Send Private Message
Reply
Hi all. I can't seem to find the thread that had the link to the moving average calculator for weight loss & for maintenance, so I'll ask my question here. I started tracking on that spreadsheet a little over 2 weeks ago and am going to adjust my ticker to reflect this from now on. (the gym I used for 3+ years had a good scale and I weighed weekly there & counted it as my "official" weight. It was generally a couple pounds heavier than my bathroom digital scale reads in the morning. Now that the gym closed, I'm going to have to rely on the bathroom scale.) so, here is my question ... On the chart, the moving average doesn't show until day 15, and then has numbers that column for each day for the coming 2 weeks. Which number do I use? The one for today ( which showed up 14 days ago) or the most recent number in that column (which showed up after I posted today's weight)? The new one is lower than the old, since I have been trending downward ever so slowly. I like this idea because it takes out the daily fluctuations ... But want to be accurate in what I post, too!

"Be diligent in these matters; give yourself wholly to them, so that everyone may see your progress." I Timothy 4:15

1 Cor. 10:23 "Everything is permissable, but not everything is beneficial."
(NIV)



 current weight: 7.0  over
 
10
5
0
-5
-10


 
Page: 1 of (1)  
   
Report Innappropriate Post

Other At Goal & Maintaining + Transition to Maintenance General Team Discussion Forum Posts


Thread URL: http://www.sparkpeople.com/myspark/team_messageboard_thread.asp?board=0x1111x49752078

Review our Community Guidelines