Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to johnstevens77,Bhoddhisatva,scotia,Anonymous,Cornytiv34, for Donating to support the site

Which spreadsheet SW ?

Discussions regarding financial software
jaizan
Lemon Slice
Posts: 386
Joined: September 1st, 2018, 10:21 pm
Has thanked: 213 times
Been thanked: 113 times

Which spreadsheet SW ?

#347942

Postby jaizan » October 15th, 2020, 11:46 am

Which spreadsheet software is everyone using these days ?

I'm on Excel 2010. Microsoft now have an irritating banner reminding me it's no longer supported, which of course I can close.
I did try setting it to not appear again until October 2070 in the registry, but that failed.

I tried Open Office spreadsheet, but am clearly not going to get on with this. I'm not going to pay any kind of recurring Office 365 subscription, so the remaining options seem to be muddling on with Excel 2010, or buying a newer version at a reasonable price.

scrumpyjack
Lemon Quarter
Posts: 4816
Joined: November 4th, 2016, 10:15 am
Has thanked: 606 times
Been thanked: 2675 times

Re: Which spreadsheet SW ?

#347947

Postby scrumpyjack » October 15th, 2020, 11:55 am

I use Excel 2007 but also still use Lotus 123 a lot (shows how long I have been a spreadsheet user!)

Also use Office 365 as there are some useful facilities (eg Stock data)

kiloran
Lemon Quarter
Posts: 4092
Joined: November 4th, 2016, 9:24 am
Has thanked: 3234 times
Been thanked: 2827 times

Re: Which spreadsheet SW ?

#347956

Postby kiloran » October 15th, 2020, 12:27 pm

jaizan wrote:Which spreadsheet software is everyone using these days ?

I'm on Excel 2010. Microsoft now have an irritating banner reminding me it's no longer supported, which of course I can close.
I did try setting it to not appear again until October 2070 in the registry, but that failed.

I tried Open Office spreadsheet, but am clearly not going to get on with this. I'm not going to pay any kind of recurring Office 365 subscription, so the remaining options seem to be muddling on with Excel 2010, or buying a newer version at a reasonable price.

I use LibreOffice as my default.
Portable version at: https://portableapps.com/apps/office/li ... e_portable
Standard desktop version at: https://www.libreoffice.org/download/download/

Very similar to OpenOffice so maybe you won't get on with it. No idea why not, it does virtually anything Excel can do.

I had Office 2010 and needed to update it (mainly to support HYPTUSS), so I bought a licence for Office 2016 from https://pckeys.uk/

--kiloran

Urbandreamer
Lemon Quarter
Posts: 3122
Joined: December 7th, 2016, 9:09 pm
Has thanked: 347 times
Been thanked: 1025 times

Re: Which spreadsheet SW ?

#347974

Postby Urbandreamer » October 15th, 2020, 1:00 pm

I and my wife regularly use more than one.

At work she uses the latest excel 365, while I currently use excel 2013.
At home she keeps accounts using LibreOffice and I use the same for HYPTUSS.

I also use google sheets many times a week to track my full portfolio and predict my financial future.

LibreOffice is slightly different from excel, but not enough to cause most people issues. The only issue would be other people, or if you demand that it has to be Microsoft excel.

Google sheets has limit's, but I wouldn't expect a home user to run into problems. It's free (like Libre) but great if you have to colaberate with others. Which again gets back to other people. I showed it's advantages to the wife, whoes response was "Billy wouldn't use it". So they are emailing excel files!

If you have a google account (ie an android phone) then give google sheets a go. You can use it anywhere that you can access the web using a standard browser though I'ed avoid using other peoples computers to do so.

SalvorHardin
Lemon Quarter
Posts: 2049
Joined: November 4th, 2016, 10:32 am
Has thanked: 5300 times
Been thanked: 2465 times

Re: Which spreadsheet SW ?

#347976

Postby SalvorHardin » October 15th, 2020, 1:01 pm

I've been using Excel 2016 ever since it was released, as part of Office 2016.

Amazon sells single home user copies of Office 2016 for less than £60, with no subscription required.

Darka
Lemon Slice
Posts: 773
Joined: November 4th, 2016, 2:18 pm
Has thanked: 1819 times
Been thanked: 704 times

Re: Which spreadsheet SW ?

#347992

Postby Darka » October 15th, 2020, 1:40 pm

I took out the subscription to Microsoft 365 which I think is worth it.

I get all the latest apps, and 1TB of storage too and I'm happy to pay for that.

bluedonkey
Lemon Quarter
Posts: 1791
Joined: November 13th, 2016, 3:41 pm
Has thanked: 1394 times
Been thanked: 652 times

Re: Which spreadsheet SW ?

#348006

Postby bluedonkey » October 15th, 2020, 2:30 pm

scrumpyjack wrote:I use Excel 2007 but also still use Lotus 123 a lot (shows how long I have been a spreadsheet user!)

Also use Office 365 as there are some useful facilities (eg Stock data)

In days of yore, I loved Lotus 1-2-3 macros. So easy.

spiderbill
Lemon Slice
Posts: 543
Joined: November 4th, 2016, 9:12 am
Has thanked: 156 times
Been thanked: 182 times

Re: Which spreadsheet SW ?

#348020

Postby spiderbill » October 15th, 2020, 3:18 pm

I second kiloran's rec of Libre Office, which I found slightly better than Open Office when I switched a few years ago. It does the vast majority of things I need and I like the interface. I still use Excel 2007 for some things but there's very little I really need it for. I firmly believe that Microsoft has made Office worse with every "upgrade" since 2003 - I detest the ribbon - so have no intention of getting anything newer.

Libre Office will save in Excel formats and I've found very few cases of any incompatibility.

Spiderbill

monabri
Lemon Half
Posts: 8396
Joined: January 7th, 2017, 9:56 am
Has thanked: 1539 times
Been thanked: 3428 times

Re: Which spreadsheet SW ?

#348033

Postby monabri » October 15th, 2020, 3:49 pm

As long as it runs HYPTUSS......... ;)

servodude
Lemon Half
Posts: 8271
Joined: November 8th, 2016, 5:56 am
Has thanked: 4435 times
Been thanked: 3564 times

Re: Which spreadsheet SW ?

#348129

Postby servodude » October 16th, 2020, 12:18 am

I was going to say Libre Office
- but then I realised I haven't installed it on this PC because I've been using Google Sheets

by the way if you're asking on behalf of "Test and Trace" it's not a Spreadsheet you need ;)

- sd

moorfield
Lemon Quarter
Posts: 3523
Joined: November 7th, 2016, 1:56 pm
Has thanked: 1546 times
Been thanked: 1402 times

Re: Which spreadsheet SW ?

#348170

Postby moorfield » October 16th, 2020, 9:27 am

Another vote for Google Sheets, which I have now migrated all of my various Excels onto. I'm hugely impressed with it, I can use it anywhere on any PC, and one less set of files I have to worry about keeping backed up. Quite handy that I can share the important stuff with Lady M too.

jaizan
Lemon Slice
Posts: 386
Joined: September 1st, 2018, 10:21 pm
Has thanked: 213 times
Been thanked: 113 times

Re: Which spreadsheet SW ?

#348333

Postby jaizan » October 16th, 2020, 6:03 pm

Thanks for the advice.

In addition to Excel, I have been using google sheets for activities like live tracking of portfolios & allocations. Including script to log daily data. Plus another sheet with my watchlist.

However, I find the graphs and some of the other functions don't meet my needs, hence the use of Excel on my PC. After reading the advice above, I've installed Libre Office. It's behaved closer to expectations on a couple of test tasks, so I'm going to give it a longer trial.
Thank you for the advice.

AleisterCrowley
Lemon Half
Posts: 6381
Joined: November 4th, 2016, 11:35 am
Has thanked: 1880 times
Been thanked: 2026 times

Re: Which spreadsheet SW ?

#348350

Postby AleisterCrowley » October 16th, 2020, 6:53 pm

scrumpyjack wrote:I use Excel 2007 but also still use Lotus 123 a lot (shows how long I have been a spreadsheet user!)

...


Crikey... I thought Lotus 123 expired about 20 years ago ?

seagles
Lemon Slice
Posts: 490
Joined: August 19th, 2017, 8:37 am
Has thanked: 153 times
Been thanked: 235 times

Re: Which spreadsheet SW ?

#348360

Postby seagles » October 16th, 2020, 7:20 pm

AleisterCrowley wrote:
scrumpyjack wrote:I use Excel 2007 but also still use Lotus 123 a lot (shows how long I have been a spreadsheet user!)

...


Crikey... I thought Lotus 123 expired about 20 years ago ?


I used it 28 years ago, loved it.

Urbandreamer
Lemon Quarter
Posts: 3122
Joined: December 7th, 2016, 9:09 pm
Has thanked: 347 times
Been thanked: 1025 times

Re: Which spreadsheet SW ?

#348363

Postby Urbandreamer » October 16th, 2020, 7:25 pm

AleisterCrowley wrote:Crikey... I thought Lotus 123 expired about 20 years ago ?


Whatever happened to Visicalc. I understood that it was Apple's killer app.
https://www.youtube.com/watch?v=2a5ex5QlocQ

ReformedCharacter
Lemon Quarter
Posts: 3120
Joined: November 4th, 2016, 11:12 am
Has thanked: 3591 times
Been thanked: 1509 times

Re: Which spreadsheet SW ?

#348365

Postby ReformedCharacter » October 16th, 2020, 7:32 pm

Spreadsheets are one of the best inventions. First I used was SuperCalc.

RC

scrumpyjack
Lemon Quarter
Posts: 4816
Joined: November 4th, 2016, 10:15 am
Has thanked: 606 times
Been thanked: 2675 times

Re: Which spreadsheet SW ?

#348372

Postby scrumpyjack » October 16th, 2020, 7:51 pm

seagles wrote:
AleisterCrowley wrote:
scrumpyjack wrote:I use Excel 2007 but also still use Lotus 123 a lot (shows how long I have been a spreadsheet user!)

...


Crikey... I thought Lotus 123 expired about 20 years ago ?


I used it 28 years ago, loved it.


Yes I liked it and still do. It works under Win 10 and why rewrite things that still work perfectly well?

scrumpyjack
Lemon Quarter
Posts: 4816
Joined: November 4th, 2016, 10:15 am
Has thanked: 606 times
Been thanked: 2675 times

Re: Which spreadsheet SW ?

#348374

Postby scrumpyjack » October 16th, 2020, 7:55 pm

Incredibly it was originally written in x86 assembly language (by Jonathan Sachs) and released in 1983. That made it much much faster than Visicalc.

uspaul666
2 Lemon pips
Posts: 232
Joined: November 4th, 2016, 6:35 am
Has thanked: 195 times
Been thanked: 111 times

Re: Which spreadsheet SW ?

#348500

Postby uspaul666 » October 17th, 2020, 4:36 pm


staffordian
Lemon Quarter
Posts: 2298
Joined: November 4th, 2016, 4:20 pm
Has thanked: 1887 times
Been thanked: 869 times

Re: Which spreadsheet SW ?

#348523

Postby staffordian » October 17th, 2020, 7:13 pm

I've only very recently upgraded from Excel 2007 to 2019 (I say upgraded, but I've yet to find anything that's better in the latter version).

I too have fond memories of Lotus 1-2-3, when even I could add macros by simply recording them, and I created a multi sheet file for our cash office which not only reduced the time it took to balance the monies each evening from about half an hour to around five minutes, but gave us clues where to look when things didn't balance first time. It then, at the press of a button spat out a few pages of (correctly calculated!) paperwork which we previously had to write out by hand and double check before passing to the accountancy team. All this before networks were a thing and paper still ruled...


Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: No registered users and 7 guests