thehidden 0 Posted November 17, 2008 Share Posted November 17, 2008 Hi all,ok so i'm doing a math project, and well excel is not going to well.I need to figure out how to do a declining balance chart....basically to represent what I have saved at a time of retirement, declining based on a monthly wage paid to myself until the time i die!Any charts associated with the actual saving and paying out would help too.ThanksIra Link to post Share on other sites
thehidden 0 Posted November 17, 2008 Author Share Posted November 17, 2008 bump Link to post Share on other sites
LongLiveYorke 38 Posted November 17, 2008 Share Posted November 17, 2008 Hi all,ok so i'm doing a math project, and well excel is not going to well.I need to figure out how to do a declining balance chart....basically to represent what I have saved at a time of retirement, declining based on a monthly wage paid to myself until the time i die!Any charts associated with the actual saving and paying out would help too.ThanksIraI don't understand. Do you need help calculating the variable (meaning how much you have saved at the time of retirement) or how to make the chart of that variable? Link to post Share on other sites
strategy's_touch 0 Posted November 17, 2008 Share Posted November 17, 2008 I don't understand. Do you need help calculating the variable (meaning how much you have saved at the time of retirement) or how to make the chart of that variable?as a practice excercise let's get a declining balance chart displaying the time it takes for the ladiez to give it up for thehidden Link to post Share on other sites
thehidden 0 Posted November 17, 2008 Author Share Posted November 17, 2008 I don't understand. Do you need help calculating the variable (meaning how much you have saved at the time of retirement) or how to make the chart of that variable?no no, I am fine with the whole math part. what I need to show is what I have saved declining over a period of time with a static interest rate.chart form Link to post Share on other sites
thehidden 0 Posted November 17, 2008 Author Share Posted November 17, 2008 as a practice excercise let's get a declining balance chart displaying the time it takes for the ladiez to give it up for thehiddenold joke...used to be funny, been living with the same person for over a year now....bout time to drop it Link to post Share on other sites
speedz99 145 Posted November 17, 2008 Share Posted November 17, 2008 old joke...used to be funny, been living with the same person for over a year now....bout time to drop itOh NOW you admit it used to be funny. But be careful, you've been around the internets long enough to know that "bout time to drop it" only encourages us.Also, can anyone help with this?I need some help with a spreadsheet. On the first tab of the spreadsheet I have a table with very simple values. For example, one column has nothing but "Y" and "N". For that column, how can I create a pie chart on another tab that shows the "Y" vs "N" as well as a percentage for each?Anyone? Link to post Share on other sites
thehidden 0 Posted November 17, 2008 Author Share Posted November 17, 2008 Oh NOW you admit it used to be funny. But be careful, you've been around the internets long enough to know that "bout time to drop it" only encourages us.Also, can anyone help with this?can't you just use If statements to create this chart? Link to post Share on other sites
strategy's_touch 0 Posted November 17, 2008 Share Posted November 17, 2008 yeah you need a declining balance chart, speedz. hit insert, then chart, then... hold on something has come up Link to post Share on other sites
speedz99 145 Posted November 17, 2008 Share Posted November 17, 2008 can't you just use If statements to create this chart?Probably...but I don't know how to do that...pretend that I'm totally useless with excel.yeah you need a declining balance chart, speedz. hit insert, then chart, then... hold on something has come upDamn you Touch! Link to post Share on other sites
JubilantLankyLad 1,960 Posted November 17, 2008 Share Posted November 17, 2008 Also, can anyone help with this?countif Link to post Share on other sites
Tactical Bear 3 Posted November 18, 2008 Share Posted November 18, 2008 I remember I used to make fun of Ira for something, but I'm not exactly sure what it was. Something about him bragging about how many hot chicks slept with him or something? I dunno, it was something in that vein. Anybody want to track down quotes and refresh my memory? I think I could probably find out if I just search all posts by "Shimmering Wang" that contain the word "Ira," but I'm worried I'll end up with like 30 posts about retirements savings. Speaking of which, I have to make this spreadsheet....Wang Link to post Share on other sites
Dawson Leery 12 Posted November 18, 2008 Share Posted November 18, 2008 Oh NOW you admit it used to be funny. But be careful, you've been around the internets long enough to know that "bout time to drop it" only encourages us.Also, can anyone help with this?You get help first. Somewhere in your tab (maybe at the bottom or to the side) enter in a formula: =countif(the range your stuff's in probably like A1:A51,"Y"). That gets the total number of Y's in that column. Do the same for N then make a chart. Let me know if you need more info.Hi all,ok so i'm doing a math project, and well excel is not going to well.I need to figure out how to do a declining balance chart....basically to represent what I have saved at a time of retirement, declining based on a monthly wage paid to myself until the time i die!Any charts associated with the actual saving and paying out would help too.ThanksIraSo a line graph showing you have $10,000,000 at retirement going down to 0 over 20 years as you pay yourself X number of dollars a month? Link to post Share on other sites
speedz99 145 Posted November 18, 2008 Share Posted November 18, 2008 I remember I used to make fun of Ira for something, but I'm not exactly sure what it was. Something about him bragging about how many hot chicks slept with him or something? I dunno, it was something in that vein. Anybody want to track down quotes and refresh my memory? I think I could probably find out if I just search all posts by "Shimmering Wang" that contain the word "Ira," but I'm worried I'll end up with like 30 posts about retirements savings. Speaking of which, I have to make this spreadsheet....WangWe made fun of the claim that no woman had ever held out more than two dates before sleeping with him. Or was it one? I think it was two.You get help first. Somewhere in your tab (maybe at the bottom or to the side) enter in a formula: =countif(the range your stuff's in probably like A1:A51,"Y"). That gets the total number of Y's in that column. Do the same for N then make a chart. Let me know if you need more info.Thanks, ouchey already gave me a good link. Link to post Share on other sites
Tactical Bear 3 Posted November 18, 2008 Share Posted November 18, 2008 We made fun of the claim that no woman had ever held out more than two dates before sleeping with him. Or was it one? I think it was two.Thanks, ouchey already gave me a good link.Yeah, that sounds about right. Did he post a picture of himself with two mediocre-looking women on his arm at a bar or something? Link to post Share on other sites
speedz99 145 Posted November 19, 2008 Share Posted November 19, 2008 Yeah, that sounds about right. Did he post a picture of himself with two mediocre-looking women on his arm at a bar or something?I don't think so, but maybe. If only JJJ was around to dig it up... Link to post Share on other sites
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now