mikemathia, to Excel
@mikemathia@ioc.exchange avatar
jonathanmatthews, to Excel
@jonathanmatthews@fosstodon.org avatar

Here's a question: what -based "stuff" do you do with spreadsheets, outside the realm of grid-based tasks (eg a multiplication table) or texty lists (eg a todo list) or things producing graphs?

I'm interested in anything with a series of calculations that's /not/ a big grid!

Some of my ideas include calculating:

  • salary/tax/take-home pay
  • budgets
  • expenses

... but I'm being very money-centric! What else can you suggest? !

davidbisset, to markdown
@davidbisset@phpc.social avatar

Convert your tables back and forth between and via the clipboard.

https://github.com/MasayoshiSugimoto/md-excel-table

nmp, to random

Day 28: "Is this a chart or a map?"

I'm not sure why I've spent so many years learning how to use software when exists 😓

juandesant, to Excel
@juandesant@astrodon.social avatar

Public Service Announcement: when you upload spreadsheets to Confluence, if you want them to display properly, please set up a printing area, and the relevant zoom information. Most of the time, setting them up to fit into 1 by 1 page is enough to make them massively more readable than the default setup…

(This is a note for future me as much as for yourselves 😉)

paezha, to Excel
@paezha@mastodon.online avatar

"Who converted a random number into a date?"

mikemathia, to Excel
@mikemathia@ioc.exchange avatar
onghu, to Excel
@onghu@ruby.social avatar

In , the ability to do Data > From Web feels almost like a super-power!

jhilden, to Excel
@jhilden@vis.social avatar

Cursed behavior:
You CAN make hierarchical treemaps, BUT the order of the rows matter. I hate this.

NexusM, to Excel

Portugal. The Man Website entirely done with Google Sheets. Maybe this is a new trend I'm not aware of.

I've seen lots of crazy shit done with , like entire product specifications, but a Website is new for me.

https://www.portugaltheman.com/?frontpage=true

barubary, to programmerhumor in The future is now

@hstde @Spore Even better, the alphabetical index of function names was generated in English first and then translated, meaning the documentation looks like a scrambled mess in any other language because it is alphabetized according to what the English equivalent would be.

nicolasvivant, to linux French
@nicolasvivant@colter.social avatar

Certains partenaires nous demandent d'utiliser des outils qui ne sont pas compatibles avec . C'est un frein important à la migration vers .

Solution de contournement : un serveur avec RDP/RemoteApp sur lequel est exécuté de façon transparente. Sur nos PC sous Linux, un .desktop (avec l'icône d'Excel) lance et roule.

C'est le genre de ruse qu'il ne faut pas négliger dans un environnement hybride Microsoft/Linux.

chris, to Excel German

Gedanken zum Bildungsstand

Kürzlich hatte ich mal wieder ein Seminar “Excel Einführung” zu geben. Es war ein spontaner Einsatz, um den ich gebeten wurde, weil ein …

Weiterlesen

https://wp.me/p6W4IQ-3ao

jhilden, to Excel
@jhilden@vis.social avatar

This might be a particularly good case to convince someone camping in Land to try

Resampling time series. It is literally just one line, assuming that one has a table indexed on DateTime. Here resampling as mean, by hours:

my_dataframe.resample('H').mean()

https://pandas.pydata.org/pandas-docs/stable/user_guide/timeseries.html

versus

https://www.exceldemy.com/excel-resample-time-series/

pasqualeberesti, to microsoft French
@pasqualeberesti@piaille.fr avatar

power : en copiant un tableau dans , j'ai fait planter ! Y a une certaine cohésion finalement chez Microsoft ! 😂

keen456, to microsoft

Whoa- made a change to that gives you better control over CSV imports, and let you stop automatic conversions like stripping leading zeros.
https://insider.microsoft365.com/en-us/blog/control-data-conversions-in-excel-for-windows-and-mac

petersuber, to opensource
@petersuber@fediscience.org avatar

Yes, this bug fix is good news.
https://www.theverge.com/2023/10/21/23926585/microsoft-excel-misreading-dates-human-genes-conversion-fixed

But to me it's another reminder that researchers need tools. The alternative is to beg for bug fixes and see no progress for years, if ever.

BTW, I'm very aware that projects can't always fix bugs quickly either, because they're underfunded and understaffed. (I run one of these myself.) But if they can't, and if the bug is sufficiently annoying, the annoyed can take matters into their own hands.

gpollara, to Excel
@gpollara@med-mastodon.com avatar
williamgunn, to Excel
@williamgunn@mastodon.social avatar

Finally, after decades, Excel will let you opt-in to not having your data automatically mangled. A spreadsheet is still not a database.
https://insider.microsoft365.com/en-us/blog/control-data-conversions-in-excel-for-windows-and-mac

Kclemson, to Excel
@Kclemson@socialnotwork.net avatar

Remember these headlines from a few years ago?

This week my team started rolling out a new feature in that addresses it :-)

https://insider.microsoft365.com/en-us/blog/control-data-conversions-in-excel-for-windows-and-mac

jfmcgrath, to Excel

Write on the board 1000 times: " is not a database, and I hate myself for trying to make it behave like one."

dennisfaucher, to Excel

TIL: Convert Date to Epoch time in format: =(A2-DATE(1970,1,1))864001000000000
Save this as a CSV and tell telegraf.conf about it for import.
https://docs.influxdata.com/telegraf/v1/data_formats/input/csv/

Weirdaholic, to random German
@Weirdaholic@snowmans.land avatar

There is so much potential with using threaded comments in excel to turn cells into whole datasets, but no, microsoft doesn't want me to do just that, lol.

kkarhan,
@kkarhan@mstdn.social avatar

@Weirdaholic I wish I had the patience to deal with 's shit...

cs, to Excel
@cs@mastodon.sdf.org avatar

I don't often accidentally turn on in , but when I do, it is a bit disorienting for a couple of seconds.

For coworkers, it is the end of the world.

garry, to ObsidianMD
@garry@mstdn.social avatar

Has Excel come to Obsidian?

Well, while the answer is no, there's still quite a bit of functionality in this community plugin.

(By the way, anyone who keeps saying "go ahead and" instead of just doing it ought to be banned outright from YouTube, yes?)

https://www.youtube.com/watch?v=ZVMfYsipMHY

  • All
  • Subscribed
  • Moderated
  • Favorites
  • megavids
  • thenastyranch
  • rosin
  • GTA5RPClips
  • osvaldo12
  • love
  • Youngstown
  • slotface
  • khanakhh
  • everett
  • kavyap
  • mdbf
  • DreamBathrooms
  • ngwrru68w68
  • provamag3
  • magazineikmin
  • InstantRegret
  • normalnudes
  • tacticalgear
  • cubers
  • ethstaker
  • modclub
  • cisconetworking
  • Durango
  • anitta
  • Leos
  • tester
  • JUstTest
  • All magazines