mathstodon.xyz is one of the many independent Mastodon servers you can use to participate in the fediverse.
A Mastodon instance for maths people. We have LaTeX rendering in the web interface!

Server stats:

2.7K
active users

#spreadsheets

0 posts0 participants0 posts today

#spreadsheets #Linux #stunting

'Developer NSG650 has succeeded in his attempt to get “Linux running in Excel.” The GitHub-hosted and aptly named LinuxInExcel project was uploaded to the cloud-based developer platform earlier this week, and updated with input support just yesterday.'

tomshardware.com/software/linu

Tom's Hardware · Developer gets Linux running inside Microsoft Excel, 'mostly for fun'By Mark Tyson

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

Ever hidden Excel rows or columns only to forget what's tucked away? 🤔 Stop playing hide-and-seek with your data! 🙈

Discover how Excel's grouping feature lets you easily collapse and expand sections. No more guessing or endless scrolling to find what you need. 👁️ Bring clarity and control back to your spreadsheets. ✨

Check out my latest video on how to effectively use this often overlooked feature of Excel: youtu.be/1rvnSAEynYA

📊 Turn numbers into insights—instantly!

Sparklines in Collabora Online let you visualize trends right inside your spreadsheet—no bulky charts needed!

Swipe through to see how easy it is to insert, customize, and format them in just 3 simple steps.

🔗 Want more details? Check out the full blog post: collaboraonline.com/blog/how-t

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. (-:

Do you know how to make spreadsheets safer? Do you have ideas to improve how ordinary users can find errors faster and correct them more easily? Do you provide spreadsheet training which includes recommendations for good practices? There is still a chance to offer a talk to the European Spreadsheet Risk and Productivity Interest Group @EuSpRIG annual conference in Greenwich, London, UK, on July 3 & 4, 2025.

eusprig.org/conferences/call-f

eusprig.orgCall for Papers & Presentations | European Spreadsheet Risk Interest Group

If you're still manually parsing text in Excel with complex formulas, you're living in the past. (Un)Perplexed Spready uses AI to extract specific information from text cells with natural language commands. No regex needed, just results!
matasoft.hr/qtrendcontrol/inde

Tired of manually categorizing products one by one? (Un)Perplexed Spready's AI integration analyzes thousands of product descriptions and automatically sorts them into categories like "meat, dairy, bakery, or other" with just one formula. This is AI doing REAL work!
matasoft.hr/qtrendcontrol/inde

While everyone's playing with AI chatbots asking for jokes, (Un)Perplexed Spready is revolutionizing spreadsheet data. It extracts specific product measures from dirty product descriptions and converts them to metric units with a single formula. That's practical AI!
matasoft.hr/qtrendcontrol/inde