Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
Re: Spreadsheets
Old 07-22-2005, 10:44 AM   #21
Dryer sheet aficionado
dandan14's Avatar
 
Join Date: Jul 2005
Posts: 39
Re: Spreadsheets

I'm really impressed with the level of spreadsheet sophistication here. I've used excel to track networth and such for years, but not quite as detailed as what some of you have listed.

Whats the possibility of getting some of these spreadsheets posted to the board? I would love to take a look at some of these!!

Thanks.
__________________

__________________
dandan14 is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Re: Spreadsheets
Old 07-22-2005, 11:02 AM   #22
Thinks s/he gets paid by the post
SteveR's Avatar
 
Join Date: Jul 2005
Posts: 2,803
Re: Spreadsheets

I use Money....I know I know, Microsoft sucks but I have been using it for too long to even think about moving data to another program.

I track just about everything...I have no life I have to admit but with my DW working crazy hours it keeps me off the streets and out of trouble and gives me DATA from which to make better guesses.

I have also created a number of spreadsheets in Excel to run more detailed What If's about expenses, future raises, stock options, 72(t) distributions, IRA income-distributions and to keep track of my DVDs and CDs.

Is anal retentive spelled with a hypen? :
__________________

__________________
Work? I don't have time to work....I'm retired.
SteveR is offline   Reply With Quote
Re: Spreadsheets
Old 07-22-2005, 11:11 AM   #23
 
Posts: n/a
Re: Spreadsheets

Here's a spreadsheet that I use a lot:

*http://members.cox.net/macymusic/GroceryPriceList.xls

Others:

Propane price
Propane usage
Health insurance plan comparisons (scenario testing)
Annual expenses
True cost of college (e.g. subtract driving costs, etc.)
Determine when to take SS
Calculate cost to heat a room with space heater
Evaluate Roth conversion
Evaluate whether Rottentomatoes.com reviews are accurate for us

For the last one, I plot my rating of a movie (0-100) against the rottentomatoes.com rating of that movie. *The result was that there was not a very good correlation:


Attached Images
File Type: jpg Movies.jpg (19.9 KB, 84 views)
__________________
  Reply With Quote
Re: Spreadsheets
Old 07-22-2005, 11:36 AM   #24
Thinks s/he gets paid by the post
 
Join Date: Jun 2005
Posts: 4,005
Re: Spreadsheets

Quote:
Originally Posted by SteveR
Is anal retentive spelled with a hypen? :
Not sure. Hyphen is spelled with an "h" though.

Al,

It looks like you and rottentomatoes are using different rating scales. You appear to rate from 0-100. From your plot, rottentomatoes generally rates from 60-100 it seems. What is the r squared on that plot? 0.1??
__________________
justin is offline   Reply With Quote
Re: Spreadsheets
Old 07-22-2005, 01:45 PM   #25
Thinks s/he gets paid by the post
SteveR's Avatar
 
Join Date: Jul 2005
Posts: 2,803
Re: Spreadsheets

Justin,

I was not sure who would take the bait but I guess you win the prize as the most anal-retentive one here so far. Yes, I do know that hyphen does have an h in it. Glad to see there are folks here with nothing better to do than spell check others' posts.

Keep up the good work.
__________________
Work? I don't have time to work....I'm retired.
SteveR is offline   Reply With Quote
Re: Spreadsheets
Old 07-22-2005, 02:42 PM   #26
 
Posts: n/a
Re: Spreadsheets

Quote:
It looks like you and rottentomatoes are using different rating scales.
No, there's is from 0-100, but I just didn't happen to go to any movies with a rating below 60.

Rottentomatoes checks reviews of many reviewers, and the rating is the percentage of reviewers who gave the movie a positive rating. I thought that would be a great way to avoid seeing movies that I didn't like, but as you see, the correlation isn't high.
__________________
  Reply With Quote
Re: Spreadsheets
Old 07-22-2005, 02:44 PM   #27
Thinks s/he gets paid by the post
 
Join Date: Jun 2005
Posts: 4,005
Re: Spreadsheets

Quote:
Originally Posted by SteveR
Justin,

I was not sure who would take the bait but I guess you win the prize as the most anal-retentive one here so far. Yes, I do know that hyphen does have an h in it. Glad to see there are folks here with nothing better to do than spell check others' posts.

Keep up the good work.
I thought it was funny. I've seen other message boards where people will correct other people's spelling and grammar. Usually by saying "You're speling sucks" "You mispelled hyphen" or "You're grammer is horible". This is some funy stuff.

I also noticed that you made other speling mistakes on this board in the past. Either you were bateing me, or you made a mistake and now your trying to pretend that you mispelled hyphen on purpose.

Al has my back here on mispellings.
__________________
justin is offline   Reply With Quote
Re: Spreadsheets
Old 07-22-2005, 02:48 PM   #28
Thinks s/he gets paid by the post
SteveR's Avatar
 
Join Date: Jul 2005
Posts: 2,803
Re: Spreadsheets

Justin,
I usually don't bait anybody but in this case it was intentional as part of the anal retentive remark.

I can't spell worth a darn most of the time but in this case I really I was trying to make a joke. Glad you have a good sence of humor. 8)
__________________
Work? I don't have time to work....I'm retired.
SteveR is offline   Reply With Quote
Re: Spreadsheets
Old 07-22-2005, 03:27 PM   #29
Recycles dryer sheets
 
Join Date: Feb 2005
Posts: 454
Re: Spreadsheets

Quote:
Originally Posted by TromboneAl

No, there's is from 0-100, but I just didn't happen to go to any movies with a rating below 60.

Rottentomatoes checks reviews of many reviewers, and the rating is the percentage of reviewers who gave the movie a positive rating. I thought that would be a great way to avoid seeing movies that I didn't like, but as you see, the correlation isn't high.
Hmm... I wouldn't count them out just yet. Maybe if you saw some movies RottenTomatoes rated below 60, you'd find some correlation.

I used to do something similar, favoring movies with good ratings on critics.com, metactritic.com, and rottentomatoes.com. But now I hardly go to the movies anymore.
I did find (without a spreadsheet) a huge correlation. Anything rated in the top 20%ile or so I was perhaps 75% sure to like. If I picked a movie at random, I'd guess the odds would be about 1/3 I'd like it.

Actually, I still do use the websites, to pick dvd's, again with pretty good success.

I've heard the best method is to find which critics you agree with, and use them. I'm too lazy.
The websites work ok for me because I like most types of movies, if they are well done. I especially like good "art films" and good foreign films which tend to be favored by the critics. If your tastes aren't in line with those of the movie snobs, the websites won't help as much.

(Not calling you a Phillistine, Al... maybe your tastes are more sophisticated than the critics.
__________________
lazyday is offline   Reply With Quote
Re: Spreadsheets
Old 07-22-2005, 03:41 PM   #30
 
Posts: n/a
Re: Spreadsheets

Right, LD, I've come to exactly the same conclusion. If the rottentomatoes rating is less than 35 or so, I'm quite confident that I won't like the movie. Most of the movies I record with my DVR have RT ratings in the teens, and I usually delete them after only a few minutes of watching.

__________________
  Reply With Quote
Re: Spreadsheets
Old 07-22-2005, 05:19 PM   #31
Thinks s/he gets paid by the post
 
Join Date: Dec 2002
Posts: 3,875
Re: Spreadsheets

Quote:
Originally Posted by TromboneAl


No, there's is from 0-100, but I just didn't happen to go to any movies with a rating below 60.

Rottentomatoes checks reviews of many reviewers, and the rating is the percentage of reviewers who gave the movie a positive rating.* I thought that would be a great way to avoid seeing movies that I didn't like, but as you see, the correlation isn't high.
One thing I do not do is listen to DW. Every time she says, "You will love this
movie!" it's been a stinker. She is 100% so far............

JG
__________________
MRGALT2U is offline   Reply With Quote
Re: Spreadsheets
Old 07-23-2005, 06:07 PM   #32
Thinks s/he gets paid by the post
 
Join Date: Jan 2005
Posts: 2,556
Re: Spreadsheets

I don't use spreadsheets and don't really track the money that much. Hmmm, I wonder if that is why I am still working and not ER? I bought the Quicken program several years back and started to use it, but screwed something up and quit, thinking that I would get back to it at a later time, but never did. I don't know if I could even still use it or if I would need to get updated program. I do not have Excel.

Dreamer
__________________
Dreamer is online now   Reply With Quote
Re: Spreadsheets
Old 07-23-2005, 06:57 PM   #33
Thinks s/he gets paid by the post
 
Join Date: Dec 2002
Posts: 3,875
Re: Spreadsheets

Quote:
Originally Posted by Dreamer
I don't use spreadsheets and don't really track the money that much.* Hmmm, I wonder if that is why I am still working and not ER?* I bought the Quicken program several years back and started to use it, but screwed something up and quit, thinking that I would get back to it at a later time, but never did.* I don't know if I could even still use it or if I would need to get updated program.* I do not have Excel.

Dreamer
I don't have EXCEL or Quicken and would not know how to use them if I did.

JG
__________________
MRGALT2U is offline   Reply With Quote
Re: Spreadsheets
Old 07-24-2005, 12:05 AM   #34
Recycles dryer sheets
 
Join Date: Jan 2005
Posts: 77
Re: Spreadsheets

I have been using quicken for many years. I am not too impressed with its investment download and reports. Recently I am doing a free trail of Mvelopes. Has anybody tried this program? Its basically mainly for budgeting, but I am impressed with its downloading ability. Better then quicken.
__________________
xprinter is offline   Reply With Quote
Re: Spreadsheets
Old 08-08-2005, 01:37 AM   #35
Recycles dryer sheets
 
Join Date: May 2005
Posts: 115
Re: Spreadsheets

I use Money but I must say the annual update crap really irritates me. First, there's no real reason to update it annually and second, every version seems to get heftier and slower and more built in ads.

But there are lots of things I still track in Excel. Me being a spreadsheet junkie too. My most used spreadsheet tells me how far I'm digging into my ER savings every month (or adding to them) and why (e.g. exceptional items).
__________________
Professional slacker, traveler and builder of a few websites: <br />Mexico: PuertoVallartaSatellite.com<br />Costa Rica: PuertoViejoSatellite.com<br />My personal blog: dougdo.com
dougdo is offline   Reply With Quote
Re: Spreadsheets
Old 08-14-2005, 04:32 PM   #36
Thinks s/he gets paid by the post
maddythebeagle's Avatar
 
Join Date: Jun 2005
Posts: 2,450
Re: Spreadsheets

I have been working on my spreadsheet and got it up to around 6 worksheets with savings rates and where I need to be at the end of each year and to see how I am progressing. I recently added a mortgage worksheet with early payments getting my mortgage paid off before FIRE. It is all aggressive, but with a good base in my early 30s and a good income, high savings rates, and LBYM, I think it can be done and not feel deprived at all. I am mainly targeting waste in my budget.
__________________

__________________
- Hurry! to the cliffs of insanity!
maddythebeagle is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Google Spreadsheets Rich_by_the_Bay Other topics 30 08-03-2006 09:09 PM
Google Spreadsheets mickj Other topics 1 08-02-2006 12:42 PM

 

 
All times are GMT -6. The time now is 10:58 PM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.