Mastodon

JdeBP<a href="https://mastodon.social/@eduqate" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@eduqate</a> 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. (-:)<a href="https://mastodonapp.uk/tags/spreadsheets" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#spreadsheets</a> <a href="https://mastodonapp.uk/tags/ComputerProgramming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ComputerProgramming</a>

JdeBP<a href="https://mastodon.social/@Codhisattva" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@Codhisattva</a> <a href="https://wandering.shop/@cstross" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@cstross</a> 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.(-:<a href="https://mastodonapp.uk/tags/spreadsheets" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#spreadsheets</a> <a href="https://mastodonapp.uk/tags/ComputerProgramming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ComputerProgramming</a>

JdeBPA 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. (-:<a href="https://mastodonapp.uk/tags/spreadsheets" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#spreadsheets</a> <a href="https://mastodonapp.uk/tags/ComputerProgramming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ComputerProgramming</a>

ExcelAnalyticsDo 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 <a href="https://mastodon.org.uk/@EuSpRIG" class="u-url mention">@EuSpRIG</a> annual conference in Greenwich, London, UK, on July 3 & 4, 2025.<a href="https://eusprig.org/conferences/call-for-papers-presentations/" target="_blank" rel="nofollow noopener noreferrer" translate="no">https://eusprig.org/conferences/call-for-papers-presentations/</a><a href="https://mastodon.world/tags/Eusprig" class="mention hashtag" rel="tag">#Eusprig</a> <a href="https://mastodon.world/tags/Excel" class="mention hashtag" rel="tag">#Excel</a> <a href="https://mastodon.world/tags/Spreadsheets" class="mention hashtag" rel="tag">#Spreadsheets</a> <a href="https://mastodon.world/tags/Risk" class="mention hashtag" rel="tag">#Risk</a> <a href="https://mastodon.world/tags/Conference" class="mention hashtag" rel="tag">#Conference</a>

Scott WilsonTOTALLY getting a set of these <a href="https://infosec.exchange/tags/spreadsheets" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#spreadsheets</a> <a href="https://infosec.exchange/tags/lol" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#lol</a> <a href="https://infosec.exchange/tags/infosec" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#infosec</a> <a href="https://vis.social/@infobeautiful/114274133861273281" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://vis.social/@infobeautiful/114274133861273281</a>

AzureCerulean<a href="https://mastodon.social/@nixCraft" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@nixCraft</a> <a href="https://4bear.com/tags/LibreOffice" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LibreOffice</a> The <a href="https://4bear.com/tags/free" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#free</a> and <a href="https://4bear.com/tags/private" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#private</a> office suite is a powerful, free and private office suite the successor project to <a href="https://4bear.com/tags/OpenOffice" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OpenOffice</a> used by people around the world. It's <a href="https://4bear.com/tags/compatible" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#compatible</a> with Microsoft Office (#365) and is backed by a non-profit organization, The Document Foundation. LibreOffice includes Writer (word processing), Calc (<a href="https://4bear.com/tags/spreadsheets" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#spreadsheets</a>), Impress (presentations), Draw (vector graphics and <a href="https://4bear.com/tags/flowcharts" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#flowcharts</a>), Base (<a href="https://4bear.com/tags/databases" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#databases</a>), and Math (formula editing).<a href="https://www.libreoffice.org/discover/libreoffice/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://www.libreoffice.org/discover/libreoffice/</a>

AzureCerulean<a href="https://4bear.com/tags/LibreOffice" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LibreOffice</a> The <a href="https://4bear.com/tags/free" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#free</a> and <a href="https://4bear.com/tags/private" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#private</a> office suite is a powerful, free and private office suite the successor project to <a href="https://4bear.com/tags/OpenOffice" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OpenOffice</a> used by millions of people around the world. It's <a href="https://4bear.com/tags/compatible" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#compatible</a> with Microsoft Office (#365) and is backed by a non-profit organization, The Document Foundation. LibreOffice includes Writer (word processing), Calc (<a href="https://4bear.com/tags/spreadsheets" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#spreadsheets</a>), Impress (presentations), Draw (vector graphics and <a href="https://4bear.com/tags/flowcharts" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#flowcharts</a>), Base (<a href="https://4bear.com/tags/databases" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#databases</a>), and Math (formula editing).<a href="https://www.libreoffice.org/discover/libreoffice/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://www.libreoffice.org/discover/libreoffice/</a>

usbs-usaTurns out <a href="https://glasgow.social/tags/GiantMachines" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#GiantMachines</a> that fly through the air need a lot more than <a href="https://glasgow.social/tags/spreadsheets" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#spreadsheets</a> where boxes on maintenance tasks are auto completed

pvergain (framapiaf)<a href="https://github.com/gristlabs/grist-core#:~:text=the%20grist-core%20repo%20is%20the%20heart%20of%20grist%2C" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://github.com/gristlabs/grist-core#:~:text=the%20grist-core%20repo%20is%20the%20heart%20of%20grist%2C</a>Grist is the evolution of <a href="https://framapiaf.org/tags/spreadsheets" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#spreadsheets</a>.The grist-core repo is the heart of Grist, including the hosted services offered by Grist Labs, an NYC-based company 🇺🇸 and Grist's main developer. The French government 🇫🇷 organizations ANCT Données et Territoires and DINUM (Direction Interministérielle du Numérique) have also made significant contributions to the codebase.- <a href="https://github.com/gristlabs/grist-core/commit/7bfe88bb3ee08d2393210e26bbc240aba4a0f5a7" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://github.com/gristlabs/grist-core/commit/7bfe88bb3ee08d2393210e26bbc240aba4a0f5a7</a><a href="https://framapiaf.org/tags/grist" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#grist</a> <a href="https://framapiaf.org/tags/excel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#excel</a> <a href="https://framapiaf.org/tags/databases" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#databases</a> <a href="https://framapiaf.org/tags/slalite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#slalite</a> <a href="https://framapiaf.org/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgresql</a> <a href="https://framapiaf.org/tags/dinum" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dinum</a> <a href="https://framapiaf.org/tags/communs" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#communs</a>

datum (n=1)And no, it doesn't make me happy that <a href="https://mamot.fr/@pluralistic" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://mamot.fr/@pluralistic</a> gave the warningknowing, as a society, hasn't stopped this from happeninghasn't made us, the collective us, reject assaults on reality<a href="https://zeroes.ca/tags/AI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#AI</a> <a href="https://zeroes.ca/tags/AIIsGoingGreat" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#AIIsGoingGreat</a> <a href="https://zeroes.ca/tags/spreadsheets" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#spreadsheets</a> <a href="https://zeroes.ca/tags/AIturds" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#AIturds</a> <a href="https://zeroes.ca/tags/EpistemologicalCollapse" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#EpistemologicalCollapse</a> <a href="https://zeroes.ca/tags/EpistemologicCollapse" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#EpistemologicCollapse</a> <a href="https://zeroes.ca/tags/Enturdification" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Enturdification</a> <a href="https://zeroes.ca/tags/Doctorow" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Doctorow</a> <a href="https://zeroes.ca/tags/CoryDoctorow" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#CoryDoctorow</a>

datum (n=1)These turds in an important data source make me upset!Just about everything about it makes me upset!And it really makes me worry about epistemological collapse - this kind of thing absolutely WILL make its way into datasheets for components that human lives ride on,Without the backing spreadsheet to spot the error sources.How often will something be unreliable outside of a design's operating range? (👈 free Master's thesis topic)<a href="https://zeroes.ca/tags/AI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#AI</a> <a href="https://zeroes.ca/tags/AIIsGoingGreat" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#AIIsGoingGreat</a> <a href="https://zeroes.ca/tags/spreadsheets" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#spreadsheets</a> <a href="https://zeroes.ca/tags/AIturds" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#AIturds</a> <a href="https://zeroes.ca/tags/EpistemologicalCollapse" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#EpistemologicalCollapse</a> <a href="https://zeroes.ca/tags/EpistemologicCollapse" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#EpistemologicCollapse</a> <a href="https://zeroes.ca/tags/Enturdification" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Enturdification</a>

datum (n=1)it's like someone did "magic infill" in Krita or Photoshop or GIMP, and it flawlessly echoed the textures and colours and even the light transitions, but with zero global context - like infilling the centre of a face with more cheeks and chins.Only in a spreadsheet.Which is NOT inherently fully discoverable in an instant's glance or touch.<a href="https://zeroes.ca/tags/AI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#AI</a> <a href="https://zeroes.ca/tags/AIIsGoingGreat" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#AIIsGoingGreat</a> <a href="https://zeroes.ca/tags/spreadsheets" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#spreadsheets</a> <a href="https://zeroes.ca/tags/waste" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#waste</a> <a href="https://zeroes.ca/tags/AIturds" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#AIturds</a> <a href="https://zeroes.ca/tags/EpistemologicalCollapse" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#EpistemologicalCollapse</a> <a href="https://zeroes.ca/tags/EpistemologicCollapse" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#EpistemologicCollapse</a> <a href="https://zeroes.ca/tags/Enturdification" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Enturdification</a>

datum (n=1)AAAAAHThat moment way too late into trying to do work with someone else's spreadsheet when you realizeit was not a human who did thisall of these subtle mistakes are not because of failures to update as reality shifted over time<a href="https://zeroes.ca/tags/AI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#AI</a> <a href="https://zeroes.ca/tags/AIIsGoingGreat" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#AIIsGoingGreat</a> <a href="https://zeroes.ca/tags/spreadsheets" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#spreadsheets</a> <a href="https://zeroes.ca/tags/waste" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#waste</a> <a href="https://zeroes.ca/tags/AIturds" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#AIturds</a> <a href="https://zeroes.ca/tags/EpistemologicalCollapse" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#EpistemologicalCollapse</a> <a href="https://zeroes.ca/tags/EpistemologicCollapse" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#EpistemologicCollapse</a>

N-gated Hacker News👨‍💻 Behold, the groundbreaking revelation: a programmer discovers that <a href="https://mastodon.social/tags/spreadsheets" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#spreadsheets</a> can have scripts! 📝✨ Witness the epic saga of someone who bravely redefines "accounting" by manually parsing their coffee and Amazon expenses—truly, a triumph of <a href="https://mastodon.social/tags/Clojure" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Clojure</a> over common sense. 💸☕📈 <a href="https://www.scattered-thoughts.net/writing/the-program-is-the-database-is-the-interface/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://www.scattered-thoughts.net/writing/the-program-is-the-database-is-the-interface/</a> <a href="https://mastodon.social/tags/programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#programming</a> <a href="https://mastodon.social/tags/accounting" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#accounting</a> <a href="https://mastodon.social/tags/expenses" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#expenses</a> <a href="https://mastodon.social/tags/innovation" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#innovation</a> <a href="https://mastodon.social/tags/HackerNews" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#HackerNews</a> <a href="https://mastodon.social/tags/ngated" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ngated</a>

Isaac WyattI wrote a blog post about creating a custom formula function in Google Sheets that lets me ask an "AI", about data in the spreadsheet. [1] eg: `=spits("get the website and primary phone number for each of the following organization names: ", A1:A300)`Where cells A1:A300 contains a list of organizations I want the website and primary phone number for. There are other uses cases for B2B Lead Gen, Data Quality, etc and personal use cases like getting ideas for stock portfolio and personal budgeting.<a href="https://hachyderm.io/tags/GoogleSheets" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#GoogleSheets</a> <a href="https://hachyderm.io/tags/GoogleGemini" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#GoogleGemini</a> <a href="https://hachyderm.io/tags/AI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#AI</a> <a href="https://hachyderm.io/tags/LLM" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LLM</a> <a href="https://hachyderm.io/tags/Spreadsheets" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Spreadsheets</a>[1] <a href="https://www.isaacwyatt.com/posts/2025-03-07/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://www.isaacwyatt.com/posts/2025-03-07/</a>

ResearchBuzz: FirehoseThe New Stack: Convert a Google Spreadsheet to JSON-Formatted Text. “This article provides a step-by-step guide on how to convert data from a Google Sheet into JSON-formatted text. The author explains the importance of JSON as a lightweight and easy-to-understand file format used for data interchange. They then walk through creating a Google Sheets document with sample data, freezing the […]<a href="https://rbfirehose.com/2025/03/07/the-new-stack-convert-a-google-spreadsheet-to-json-formatted-text/" class="" rel="nofollow noopener noreferrer" target="_blank">https://rbfirehose.com/2025/03/07/the-new-stack-convert-a-google-spreadsheet-to-json-formatted-text/</a>

ResearchBuzz: FirehoseDiscovered on LinkedIn: meaningfully. That link goes to a GitHub repository. From the readme: “Meaningfully is a semantic search tool for text data in spreadsheets. Keyword searching in Excel or Google Sheets is painful because text data is displayed awkwardly and because keywords miss circumlocutions, typos, unexpected wording and foreign-language data. Semantic search solves all of that. […]<a href="https://rbfirehose.com/2025/03/06/semantic-search-in-spreadsheet-data-meaningfully/" class="" rel="nofollow noopener noreferrer" target="_blank">https://rbfirehose.com/2025/03/06/semantic-search-in-spreadsheet-data-meaningfully/</a>

Jeff Fortin T.While I'm asking for a pony, I might as well ask for the reverse mechanism too… the ability to paste <a href="https://mastodon.social/tags/Markdown" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Markdown</a> plaintext tables into <a href="https://mastodon.social/tags/LibreOffice" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LibreOffice</a> Calc <a href="https://mastodon.social/tags/spreadsheets" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#spreadsheets</a> and Writer text documents: <a href="https://bugs.documentfoundation.org/show_bug.cgi?id=165590" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://bugs.documentfoundation.org/show_bug.cgi?id=165590</a>

Jeff Fortin T.I bet most of you <a href="https://mastodon.social/tags/Markdown" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Markdown</a> enthusiasts didn't know you can paste <a href="https://mastodon.social/tags/LibreOffice" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LibreOffice</a> <a href="https://mastodon.social/tags/spreadsheets" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#spreadsheets</a> as Markdown tables in <a href="https://mastodon.social/tags/GitLab" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#GitLab</a>.Pretty cool, right? Now, imagine if we could also do that in <a href="https://mastodon.social/tags/GNOME" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#GNOME</a>'s Markdown editor, Apostrophe (or even, any GNOME text editor that recognizes Markdown for syntax highlighting…) :blobaww:Ponies-on-rainbows feature request here: <a href="https://gitlab.gnome.org/World/apostrophe/-/issues/598" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://gitlab.gnome.org/World/apostrophe/-/issues/598</a>

Jake in the desertJust, the most insane shit at work, nothing bad, but a total weird pain in the ass with data and fucked up spreadsheets, and I should probably write about this because I CANNOT be the only person dealing with crap like this.<a href="https://c.im/tags/Excel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Excel</a> <a href="https://c.im/tags/spreadsheets" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#spreadsheets</a> <a href="https://c.im/tags/Microsoft" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Microsoft</a> <a href="https://c.im/tags/MicrosoftOffice" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MicrosoftOffice</a> <a href="https://c.im/tags/Salesforce" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Salesforce</a>

Recent searches

Search options

Administered by:

Server stats:

#spreadsheets