Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
Old 04-19-2013, 02:14 PM   #21
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: May 2005
Posts: 13,271
One thing that I try to do in important worksheets is to have a check number... IOW, you can usually calculate things in a couple of ways... so I do it both ways and have a cell that should either equal the other one or a cell that equals zero (subtract the two)... this has helped me out a number of times when something gets moved and a formula is not what you think it is... ie, it has a fixed cell when you thought it was dynamic...
__________________

__________________
Texas Proud 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!

Old 04-19-2013, 03:20 PM   #22
Thinks s/he gets paid by the post
heeyy_joe's Avatar
 
Join Date: Nov 2012
Location: Madeira Beach Fl
Posts: 1,403
__________________

__________________
_______________________________________________
"A man is a success if he gets up in the morning and goes to bed at night and in between does what he wants to do" --Bob Dylan.
heeyy_joe is offline   Reply With Quote
Old 04-19-2013, 04:13 PM   #23
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Midpack's Avatar
 
Join Date: Jan 2008
Location: Chicagoland
Posts: 11,971
I find errors in my spreadsheets about 12% of the time, and it's shocking every time!

Seriously, I find it hard to believe it's really as high as 88%, but I can't prove it...unless the rest of you are really careless.
__________________
No one agrees with other people's opinions; they merely agree with their own opinions -- expressed by somebody else. Sydney Tremayne
Retired Jun 2011 at age 57

Target AA: 60% equity funds / 35% bond funds / 5% cash
Target WR: Approx 2.5% Approx 20% SI (secure income, SS only)
Midpack is offline   Reply With Quote
Old 04-20-2013, 06:52 AM   #24
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
pb4uski's Avatar
 
Join Date: Nov 2010
Location: Vermont & Sarasota, FL
Posts: 16,424
Quote:
Originally Posted by sengsational View Post
....... I got to be really good at (don't laugh) Lotus 1-2-3.
I liked VisiCalc and MultiPlan better.
__________________
If something cannot endure laughter.... it cannot endure.
Patience is the art of concealing your impatience.
Slow and steady wins the race.
pb4uski is online now   Reply With Quote
Old 04-20-2013, 08:37 AM   #25
gone traveling
 
Join Date: Jul 2007
Posts: 333
I still have a copy of Multi-Plan and an early version of Lotus 123. - Ah, those were the days
__________________
HighRoller is offline   Reply With Quote
Old 04-20-2013, 08:44 AM   #26
Moderator
MichaelB's Avatar
 
Join Date: Jan 2008
Location: Rocky Inlets
Posts: 24,445
I still use Lotus 1-2-3 as my primary spreadsheet.
__________________
MichaelB is offline   Reply With Quote
Old 04-20-2013, 08:46 AM   #27
Thinks s/he gets paid by the post
obgyn65's Avatar
 
Join Date: Sep 2010
Location: midwestern city
Posts: 4,061
I like the "what if" and optimizing functions in Excel. Not sure if Lotus has these ?
Quote:
Originally Posted by MichaelB View Post
I still use Lotus 1-2-3 as my primary spreadsheet.
__________________
Very conservative with investments. Not ER'd yet, 48 years old. Please do not take anything I write or imply as legal, financial or medical advice directed to you. Contact your own financial advisor, healthcare provider, or attorney for financial, medical and legal advice.
obgyn65 is offline   Reply With Quote
Old 04-20-2013, 09:01 AM   #28
Thinks s/he gets paid by the post
 
Join Date: Oct 2006
Posts: 3,820
Quote:
Originally Posted by heeyy_joe View Post
The error rate was actually found to be 89%, there was an error in his spreadsheet.
__________________
Independent is offline   Reply With Quote
Old 04-20-2013, 09:08 AM   #29
Recycles dryer sheets
 
Join Date: Sep 2009
Posts: 353
Quote:
Originally Posted by Texas Proud View Post
One thing that I try to do in important worksheets is to have a check number... IOW, you can usually calculate things in a couple of ways... so I do it both ways and have a cell that should either equal the other one or a cell that equals zero (subtract the two)... this has helped me out a number of times when something gets moved and a formula is not what you think it is... ie, it has a fixed cell when you thought it was dynamic...
+1

I also find that whenever I can compute same thing in two ways, I do so, and put in "Check" fields that have to be either green 0 or red non-zero. (I use conditional formatting for the fonts of these Check fields and then just copy paste this formatting to all other "check" fields. I found a few times I needed to round the results or consider anything between -0.001 and 0.001 as 0, but this is all minor.)

I try to search out such opportunities to double check the work. A number of times, the reds caught something that needed to be fixed. It's not a 100% method by any means since it's only as good as the number of cells being double-checked and original data itself could be erroneous, but it's better than nothing I think.
__________________
smjsl is offline   Reply With Quote
Old 04-20-2013, 09:19 AM   #30
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Midpack's Avatar
 
Join Date: Jan 2008
Location: Chicagoland
Posts: 11,971
Quote:
Originally Posted by sengsational View Post
I got to be really good at (don't laugh) Lotus 1-2-3.
Lotus 1-2-3 was so ubiquitous at one time (and I thought it was excellent) I'd have never imagined Excel would 'run them out of town.' Same with WordStar and WordPerfect, I never would have imagined Word would kill them off. MS Office has 'owned' their space for a long time.

Not inviting comments re: Microsoft pro or con, just making an observation.
__________________
No one agrees with other people's opinions; they merely agree with their own opinions -- expressed by somebody else. Sydney Tremayne
Retired Jun 2011 at age 57

Target AA: 60% equity funds / 35% bond funds / 5% cash
Target WR: Approx 2.5% Approx 20% SI (secure income, SS only)
Midpack is offline   Reply With Quote
Old 04-20-2013, 10:11 AM   #31
Thinks s/he gets paid by the post
Tadpole's Avatar
 
Join Date: Jul 2004
Posts: 1,170
Quote:
Originally Posted by Texas Proud View Post
One thing that I try to do in important worksheets is to have a check number... IOW, you can usually calculate things in a couple of ways... so I do it both ways and have a cell that should either equal the other one or a cell that equals zero (subtract the two)... this has helped me out a number of times when something gets moved and a formula is not what you think it is... ie, it has a fixed cell when you thought it was dynamic...
That is exactly what I do when I can. I find more errors in my simple spreadsheets than in my more complex. I think this is often the case for people.
__________________

__________________
Tadpole 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


 

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