#excel

kuchinster@rusx.org

Damn Excel! How the 'most important software application of all time' is ruining the world

In 2017, Adobe's CFO banned his employees from using Excel (all of them switched to Adaptive Insights EPM, other alternatives include Anaplan and Workiva). The same bans were issued by the management of China Bistro, ABM Industries, Wintrust Financial and many other companies. Abandoning Excel reduces the risk of errors in calculations and simplifies document flow.

The EuSpRIG (European Spreadsheet Risk Group) study showed that more than 90% of spreadsheets contain errors, and half of corporate spreadsheets have “material defects”.

And then there are the traditional auto-formatting glitches that cause even biologists to have to rename human genes such as MARCHF1 (formerly MARCH1) and SEPTIN1 (formerly SEPT1) so that Excel doesn't mistake them for dates. A study of 3,597 published scientific articles found that about 20% of the accompanying materials (spreadsheets) to the articles had errors in gene names:

Leading zeros are removed from identifiers and other values in cells by default - this is also a standard Excel behavior that often leads to problems. Importing any data from CSV into Excel runs the risk of corrupting it. And that data can be vital, necessary to save those same patients in hospitals.

That's why Excel is sometimes called “the most dangerous program on the planet.” Too much depends on it. And too many errors.

https://habr.com/ru/companies/ruvds/articles/835390/

#Microsoft #Windows #software #Excel #computing #fail #economy #history

metal@federatica.space

EXCEL переиздают альбом

19 июля у всех поклонников EXCEL вновь появится шанс услышать пластинку 1995 года "Seeking Refuge".

Shaun Ross: «Многие люди, которые знают EXCEL, не всегда знают об этой пластинке. Она не издавалась с 95-го года, и о ней просто забыли!»

Трек-лист:

01. Unenslaved

02. Hair Like Christ

03. Plastic Cracks

04. Take Your Part Gotta Encourage

05. Drowned Out

06. United Naturally in True Youth

07. Riptide

08. Overview

09. Downpressor

#Excel

Видео: https://www.youtube.com/watch?v=AKl1xxv4qOk

#lang_ru #метал #darksideru

utzer@social.yl.ms

I have a X-Y-Diagram in #Excel, it is a unity circle (not so important) and I need a pointer that I can drag to any point in the diagram, and it should show me the X and Y value and the length of the pointer.
The Pointer should be defined by its starting point, the length should be calibrated to the length from 0 to 1/Xd, and 1/Xd should be the starting point of the pointer which should be fixed. 1/Xd is a point on the X axis, it is always y=0, so it lays on the x axis.

All values needed will be available in a table in Excel.

Anyone any idea how to “program” this?

christophs@diaspora.glasswings.com

I Will Fucking Dropkick You If You Use That Spreadsheet — Ludicity

Anything. I am begging you on my hands and knees, anything. Write a SQLite database on your local hard drive. Do some garbage in Python. Encode the data in binary using a series of pebbles on your front lawn. If necessary, I will personally call your manager and explain the problem. I will actually do this. It's easy, I swear. They're all definitely easier than being defenestrated, which is the only alternative I am offering.

#excel #spreadsheets #database

https://ludic.mataroa.blog/blog/i-will-fucking-dropkick-you-if-you-use-that-spreadsheet/

mrg@diaspora-fr.org

Bonjour Diaspora* !

Je suis un cours sur excel sur openclassroom mais étant sous linux, je le fais sur libreoffice calc. J’aimerais savoir s’il est possible d’importer des modèles ou des exemples de classeurs avec de gros tableaux, afin que je puisse m’exercer sur les différentes manip que propose le cour ? Car si je dois tout taper à la main… Merci de votre aide !

#libreoffice #libreofficecalc #excel #openclassroom #linux