sagedavis

This isn't so much a programming question as it is a math question.

I am getting heavy into counting my calories, and have built a spreadsheet in excel to keep track of everything as I go to the gym and everything. Counting what I eat, and some of the activities that I do to burn the calories.

Anyway, I guess that isn't exactly soo important to my question.

I have been doing this for a couple of weeks now and have been successful.

However, I want to be able to easily calculate how long it would take for me to get from my current weight, to my destination weight.

Here is the formula that I am working with (and tested, this formula is pretty close to accurate).

3500/((12.96*300)-2000) Tells you that, if you weigh 300 lbs, and you eat only 2000 calories a day (and live a sedentary life), it will take you 1.85 days to loose 1 lb

3500/((12.96*299)-2000) says that (given all of the same conditions) a 299 lb person will take 1.87 days to loose 1 lbs

So, in order to figure out how long it will take a 300 lb man to weigh 298 lbs while eating only 200 calories, all you must do is add 1.85+1.87 and you get 3.72

In excel however 2 of these numbers are variables, so that I can test what would happen if a 300 lb man ate only 1500 calories rather than 2000... and other combinations as I see fit.

What my formula looks like in excel is
3500/((12.96*A1)-A3)

A2 will end up being the target weight.

How would I finish off this equasion so that, it would repeat the formula and then add the results of each.
as I have done above, but with only 1 equasion?

Is this even possible to do in excel?

I am currently having a whole bunch of running totals and so on, and it just looks messy and is difficult to navigate.

Any thoughts or help on this would be greatly appretiated.
Thanks in advance.
Sage

__________________
I reject your reality and substitute my own.

If you aren't learning, you aren't living.
www.an8search.com

grimpirate

If you want to vary the caloric amount then I would suggest you create one cell with the caloric amount and refer back to it by doing something along the lines of 3500/((12.96*B1)-$A$1) the $ sign locks both row and column position, such as in the use of a constant. Then all you would simply have to do is create a decrementing column of weights in column B where you state the heighest weight in cell B1 then make the formula in B2 = B1 - 1 and then just drag it down as far as you see fit then in column C paste the formula stated previously and at its end create a summation of all those amounts and you know how much time it takes to get to that target weight. Then of course you could just use different sheets for different caloric amounts. Hope that helps.

__________________
Lo, there do I see my father. 'Lo, there do I see My mother, and my sisters, and my brothers. 'Lo, there do I see The line of my people... Back to the beginning. 'Lo, they do call to me. They bid me take my place among them. In the halls of Valhalla... Where the brave... May live... ...forever.. GrimBB | Mimesis

Seif

Please remove the link from your signature sagedavis. I'm sure nobody here is particulary interested in seeing pornos with shemales. :/

sagedavis

Seif,
Actually, that site is MY site, and it's a constant battle to get rid of all of those spammers, as folks are supposed to be able to add links to site related to anim8or. I was trying to do it maintainance free, but, apparently the porn industry thinks it's funny to taint my site. So, I am constantly denying ip addresses and deleting those records in the database.

I will fix it this weekend so that all entries need to be approved by me. Which will fix the problem. Anyway, so, if you don't mind, I will keep my link up there, since it actually is a useful site.

Grimpirate... actualy, the way that you describe is the way that I am doing it (sort of), I had to water down my explination because I am not good enough to paint a good picture of it in words... Was hoping there was another way, or an easier way.

Granted, this would be easy as heck to do as a PHP web page, but, I was really hoping there was a more mathematical way to do this, rather than all these fields. Mostly for my own need to understand the math behind a lot of this stuff.

Anyway, I'll await other answers just to see, but your suggestion is right on target with what I am currently doing.

Thanks
Sage

__________________
I reject your reality and substitute my own.

If you aren't learning, you aren't living.
www.an8search.com

DaWei

The rules clearly state:
Therefore, remove your link UNTIL you fix it, rather than just SAY you'll fix it.

__________________
Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code.
Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

sagedavis

Fixed.

Thanks for the reminder DaWei,

also, thanks for bringing to my attention that they had bombarded my site again.

I just made it so that all entries need to be approved before they will be viewed by the general public.

Now, any math geniuses with further information as to my origional problem?
Thanks

__________________
I reject your reality and substitute my own.

If you aren't learning, you aren't living.
www.an8search.com

grumpy

The formula you want to code up is: sum from {weight = end_weight + 1} to {start_weight} of {3500/((12.96*weight)-calories_eaten)}

That doesn't exactly require a mathematical genius. I'll leave the problem of implementing that formula in Excel as an exercise.

Duck

With respect sagedavis, just how fat are you? How much do you weight?

Jessehk

Hardly a respectful question.

__________________
Dr. Zoidberg: [ecstatic] I'm going to a movie... with FRIENDS!

Fall Back Son

I don't know much about excel. But if you want, I can do this for you in C and give you the results (just an offer - probably not what you're looking for though). Also, since you would have a different weight (supposedly) after each calculation, the new calculation would be different each time for the weight - it wouldn't be a 300 lb man anymore (not sure if you figured that into the formula, but you probably did).

Also, a 300 lb man eating 1500 calories ? im not sure how realistic that is, but put some limitations on your formula for weight loss and for caloric intake. pz