homeGeek CultureWebstoreeCards!Forums!Joy of Tech!AY2K!webcam

The Geek Culture Forums


Post New Topic  New Poll  Post A Reply
my profile | directory login | | search | faq | forum home
  next oldest topic   next newest topic
» The Geek Culture Forums   » Other Geeky Stuff   » Ask a Geek!   » Lotus 123...Need for Speed

 - UBBFriend: Email this page to someone!    
Author Topic: Lotus 123...Need for Speed
TheWitchdoctor
Newbie Larva
Member # 46854

Rate Member
Icon 1 posted April 03, 2012 16:07      Profile for TheWitchdoctor     Send New Private Message       Edit/Delete Post   Reply With Quote 
Actually a question. 123 vs Excel. Which is faster?

I go back to NCR 500's, Honeywell GCOS6 and my pleasure was doing shit on a Wang C88 w/ibm imm.

My skill was with Lotus 123.

Prior to the first Gulf War, I had all the data a Transportation Brigade commander needed for him to go to war. Even a Mattel canteen @ $ .73 each. 90% of this command did go.

I was a CW4, trained as a test pilot but had to fix logistics which I knew very well. Line ID numbers, stock numbers, source, cost, inventory controls, reorder control and I had Manager Over Ride controls. BTW we didn't have modems at the office then, 1990. Command briefings were done at my house and besides a well stocked bar...projector screen off my 286 Zenith...I could do any "What If" command in seconds.

Well my brother, another test pilot, got into the insurance industry, insures most of the hotel/motels in the country, personel, life insurance. At the cost of Zeos 386, I build him a billing system for him that showed every penny.

Well he had ADP IT's come in and changed thing a bit and cost him a bundle.

15 years later he wants me to come out of retirement and make his Excel program better. It's too damn slow for one that can type 60wpm or better with backslash commands.

When it gets down getting things done and extremely fast and accurate, Am I wrong to make him revert to Lotus 123? or whatever? Show and tell can always be done.

Thanks

Posts: 5 | Registered: Apr 2012  |  IP: Logged
Ashitaka

SuperFan!
Member # 4924

Member Rated:
4
Icon 1 posted April 03, 2012 22:45      Profile for Ashitaka     Send New Private Message       Edit/Delete Post   Reply With Quote 
I have no idea what calculations are being done. Exel becomes slow if the amount of data being processed becomes too large.

As far as I know, lotus 123 hasn't been around in 14 years. IT is way too out of date.

Your friend needs modern database software programed for his business. Reverting to old technology is a bad idea in my opinion.

on anouther note, what does the rate at which someone types have to do with the performance of the current software.

--------------------
"If they're not gonna make a distinction between Muslims and violent extremists, then why should I take the time to distinguish between decent, fearful white people and racists?"

-Assif Mandvi

Posts: 3089 | From: Switzerland | Registered: Feb 2006  |  IP: Logged
dragonman97

SuperFan!
Member # 780

Member Rated:
4
Icon 1 posted April 04, 2012 01:20      Profile for dragonman97   Author's Homepage     Send New Private Message       Edit/Delete Post   Reply With Quote 
quote:
Originally posted by Ashitaka:

on anouther note, what does the rate at which someone types have to do with the performance of the current software.

I suspect it's not so much the performance of the software, so much as the reaction and user flow. i.e. If every time you enter data, you have to jump through hoops to proceed, or something of the sort, it's perceived as being slower.

Mind you, I suspect some of that is simply due to the fact that Excel can be a real pain sometimes in doing annoying things that you really don't want it to do. You simply have to learn what those things are, and how to either work around them, modernize to take advantage of them, or just grit your teeth and put up with them. I fall squarely in the latter category every time I open a .csv/.txt file in Excel, hit Save, get nagged about how I should really choose an Excel format, and then when I exit, immediately after going through that dance, get a warning that I might lose unsaved changes.

Perhaps it's worth trying OpenOffice.org / LibreOffice?

Personally, I have a love/hate relationship with Excel. I find it to be a great tool for quickly manipulating data -- I often munge stuff with Perl/bash and then kick it into Excel to find neat details. However, it's /meant/ to be a spreadsheet for dealing with numbers, so I find it a bit textually deficient...but that's what vim is for! The Save quirk above falls squarely in my 'hate' category, as does its utterly idiotic form of Copy/Paste. Still, the pros outweigh the cons for me, and I actually love the easier access to certain functions in the Ribbon. (Freeze Top Row is a big improvement, as is the conditional formatting 'quick menu.')

I use OpenOffice.org at home and it does a perfectly fine job of things. Nothing comes to mind that I can do in Excel that I can't do in OO.o. The only differences to me are cosmetic, and mostly stuff from habit. (e.g. In Excel, the 'cell border' button remembers the last style applied unless you hit the down arrow. In OO.o, it never remembers.) It doesn't have my pet peeve about Save As, but instead, I find its cluttered "Open" dialog irksome. (To open a .txt file as a spreadsheet, you have to scroll down a _huge_ list to get to the spreadsheet formats, as OO.o lists all the formats for each 'app' in one box.)

OTOH, Lotus 1-2-3 is an utter relic, and while it was my first spreadsheet, I don't miss it save for some nostalgia. (I got a little wistful looking at the Wikipedia article and seeing the DOS version. Those were the days...)

Rambling posts of mine today aside, I definitely agree with Ash that a spreadsheet is probably the wrong way to go here. There's no reason an appropriate off-the-shelf (comm. or open source) program shouldn't be able to get the job done, and one that uses a database is probably the right approach. If it's indeed a small business and involves payroll and business operations, QuickBooks might be the way to go. I was a bit skeptical of it until I helped someone whose small business revolves around it -- it looks to be a damned handy program. Spreadsheets can do a lot of things, but just like hammers, they shouldn't be used for everything.

--------------------
There are three things you can be sure of in life: Death, taxes, and reading about fake illnesses online...

Posts: 9332 | From: Westchester County, New York | Registered: May 2001  |  IP: Logged
quantumfluff
BlabberMouth, a Blabber Odyssey
Member # 450

Member Rated:
5
Icon 1 posted April 04, 2012 10:53      Profile for quantumfluff     Send New Private Message       Edit/Delete Post   Reply With Quote 
Speed for the programmer is a non-issue.
The only things that matter are:
- does it do what the customer needs
- is it convenient for them
- is it reliable

From what you've described, you understand the functions required and have made it convenient enough so the user (your brother) does not have much data entry to do. So, input speed for him is a non-issue. Any deployment environment will do.

As far as reliable - the best way to get that is to not use a spreadsheet. Build a web based system and run it in the cloud - on Amazon EC2 or Google AppEngine. Then, when there is a fire in his office, there is no data loss.

No small business does adequate backups. Keeping your data locally is a liability - something an insurance agent should understand well.

Posts: 2902 | From: 5 to 15 meters above sea level | Registered: Jun 2000  |  IP: Logged
TheWitchdoctor
Newbie Larva
Member # 46854

Rate Member
Icon 1 posted April 05, 2012 14:09      Profile for TheWitchdoctor     Send New Private Message       Edit/Delete Post   Reply With Quote 
Thanks for the input. Didn't really want to come out of retirement (1994) to fix anothers problem. Bro thinks I have too much time on my hands. Little does he knows what it takes to be on an island, 30 minutes by boat, your it to fix everything there.

I'll have a drink for all of you.

Posts: 5 | Registered: Apr 2012  |  IP: Logged
Serenak

Member # 2950

Member Rated:
4
Icon 1 posted April 07, 2012 20:52      Profile for Serenak     Send New Private Message       Edit/Delete Post   Reply With Quote 
Not really my field at all, and i concur with all the above comments... but would it not be better to avoid a spreadsheet altogether and build what you need using a database?

Seems to me (unless I am totally not getting the point of this) that using Excel (or an equivalent) is a problem - without more information I am not able to see why you need to do this - for bigger projects spreadsheets are not the solution, a database is what you need

I know almost nothing about SSs or DBs but I do know that if you want to manhandle any amount of data on a regular and repeated basis that a DB is what you want to use... and that you can even (in effect) build a customised application that way - I believe FileMaker and Access (on Windows) secured their positions as "major players" that way...

--------------------
"So if you want my address - it's No. 1 at the end of the bar, where I sit with the broken angels, clutching at straws and nursing my scars..."

Posts: 1937 | From: Suffolk England | Registered: Sep 2004  |  IP: Logged
Serenak

Member # 2950

Member Rated:
4
Icon 1 posted April 07, 2012 20:53      Profile for Serenak     Send New Private Message       Edit/Delete Post   Reply With Quote 
bugger - double posted... ignore this one please... TY

--------------------
"So if you want my address - it's No. 1 at the end of the bar, where I sit with the broken angels, clutching at straws and nursing my scars..."

Posts: 1937 | From: Suffolk England | Registered: Sep 2004  |  IP: Logged
zorgon
Assimilated
Member # 546

Rate Member
Icon 14 posted April 10, 2012 15:35      Profile for zorgon     Send New Private Message       Edit/Delete Post   Reply With Quote 
I can hear the General now:

"Men, we've got a Y3K problem. Contact Cryo and have them defrost another programmer, assuming they have one that knows Lotus 1-2-3!"

Posts: 385 | From: Beautiful Uptown Goleta | Registered: Sep 2000  |  IP: Logged


All times are Eastern Time  
Post New Topic  New Poll  Post A Reply Close Topic    Move Topic    Delete Topic next oldest topic   next newest topic
 - Printer-friendly view of this topic
Hop To:

Contact Us | Geek Culture Home Page

2015 Geek Culture

Powered by Infopop Corporation
UBB.classicTM 6.4.0



homeGeek CultureWebstoreeCards!Forums!Joy of Tech!AY2K!webcam