Recent searches

No recent searches

Search options

Not available on photog.social.
photog.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
A place for your photos and banter. Photog first is our motto Please refer to the site rules before posting.

Administered by:

Server stats:

247
active users

photog.social: AboutProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.4.3

#spreadsheets

0 posts0 participants0 posts today
Johan van der Knijff

New bloggage - in 2014 I tried to read some old #QuattroPro for #DOS #spreadsheets in modern software, and concluded the format was effectively obsolete.

More than ten years onward, things are looking much better now, thanks to @libreoffice. But my latest tests also highlight some gnarly issues.

bitsgalore.org/2025/05/28/quat

bitsgalore.orgQuattro Pro for DOS revisited: an obsolete format no more?This post provides an update to my 2014 attempts at reading old Quattro Pro for DOS spreadsheets with modern software.
Yvonne Perkins

I need to set up a private spreadsheet that is viewable and editable by an elderly relation (who uses spreadsheets all the time) and a couple of younger family members, one of whom lives interstate.

The obvious answer is Google Sheets. Is there an alternative that is usable for these people?
#spreadsheet #spreadsheets

Replied in thread
JdeBP

@eduqate

Possibly, although one would need to check the requirements to see whether it is all non-negative or just the strictly positive values that are supposed to have the 10% floor applied to them.

Indeed, that's an extreme edge case that possibly isn't even in the requirements. In the data set that I saw someone else using, there was no row where the X cell value precisely equalled the M cell value.

But to be future-proof, one would probably need to consider having an error margin where X and M, which are rounded figures anyway after all, are close enough.

(Note, by the way, that I was coding this in a minuscule edit field in a WWW form that performs word wrap very inconveniently, not actually in Excel. If I had done it in Excel, I wouldn't have forgotten the brackets. (-:)

#spreadsheets#ComputerProgramming
Replied in thread
JdeBP

@Codhisattva @cstross

As long as you remember, as I forgot when posting, to put brackets around the numerator:

=IF(X2<M2,MAX((M2-X2)/M2,0.1),0)

A relative who used to work in the U.K. civil service and did spreadsheets pointed out to me today that xyr form of the formula would instead have been

=IF(X2<M2,MAX(1-X2/M2,0.1),0)

and would have not had the bracket bug.

(-:

#spreadsheets#ComputerProgramming
*
JdeBP

A tip for spreadsheet users that I have learned from watching a mistake made by others:

When you use
=MAX(M2-X2/M2,0.1)
to place a floor of 10% on how low you want your calculation to be of a fractional positive gap to reduce M2 to X2 by, please try to remember that the X2 cell value could be *already greater* than the M2 cell value.

You probably want
=IF(X2<M2,MAX(M2-X2/M2,0.1),0)
or similar.

Because if (say) M2 is 6.81E+10 and X2 is 7.99E+10, then your calculation is going to come up with 10% instead of 0%, let alone the correct -17%.

Which might be embarrassing. (-:

#spreadsheets#ComputerProgramming
Replied in thread
AzureCerulean

@nixCraft

#LibreOffice

The #free and #private office suite is a powerful, free and private office suite the successor project to #OpenOffice used by people around the world. It's #compatible with Microsoft Office (#365) and is backed by a non-profit organization, The Document Foundation. LibreOffice includes Writer (word processing), Calc (#spreadsheets), Impress (presentations), Draw (vector graphics and #flowcharts), Base (#databases), and Math (formula editing).

libreoffice.org/discover/libre

www.libreoffice.orgWhat is LibreOffice? | LibreOffice - Free and private office suite - Based on OpenOffice - Compatible with MicrosoftLibreOffice, Free Office Suite, Fun Project, Fantastic People, Writer, Calc, Impress, Draw, Base, Charts, Diagrams, extensions, templates, word processor, text editor, spreadsheet, presentation, database, documents, Document Foundation
Flipboard Culture Desk

Canada has a lot to be proud of — maple syrup, glorious scenery, publicly funded healthcare. A new one to add to the list? Toronto-based Michael Jarman has won the Microsoft Excel World Championship. The tournament, in which competitors played a simulated game of World of Warcraft via spreadsheet, took place at the HyperX Arena in Las Vegas last week. Here's more from @Gizmodo.

flip.it/XHx0EJ

Gizmodo · Canadian Man Crowned King of Spreadsheets at the 2024 Microsoft Excel World ChampionshipGuess you could say this guy really excels at spreadsheets.
#Gaming#WorldOfWarcraft#Excel
*
Ciarán

"Some years ago, I was involved in a somewhat heated online disagreement with an eminent professor of spreadsheet risk. I inadvertently provoked my adversary to describe me as an idiot and to compare me to a member of the Italian inquisition. The idiot accusation was probably fair enough, but I didn’t expect the Italian inquisition…"

icaew.com/technical/technology

www.icaew.comCan spreadsheets show us how to deal with online misinformation?We seem to have learned to live with spreadsheets, despite them giving us the wrong answer 90% of the time. Are there any lessons to be learnt from our ability to adapt to fallible spreadsheets that can help us deal with online misinformation?
#spreadsheets#accounting#excel
Replied in thread
Darius

@kkarhan @nixCraft sorry but I have to disagree by a long shot.

1. There are still many games that don't run on #Linux mainly due #ClientSideAnticheat

2. Currently, no #spreadsheets app fully replaces #MicrosoftExcel plus compatibility is an issue AFAIK

3. More importantly, #engineering software are almost exclusively developed for Windows devices. And that barely runs due heavy requirements.

You gonna tell me and everyone to change profession as well?!

Live feeds
About