• 0 Posts
  • 24 Comments
Joined 8 months ago
cake
Cake day: January 25th, 2024

help-circle
  • There are basically two types of files. Text files and binary files.

    Most information are stored in text files so humans can easily understand it, and it’s easier to find errors, review, parse. But text storage takes more space than binary files. And many complicated softwares normally need multiple text files or data files, many of them just store them together as a zip file so that it’s easier to handle. Examples are .docx,.pptx, etc files in MS Office, try unzipping them and see what they contain. Zipping also has advantages of reducing file sizes.
















  • You know how people say “Devil you know is better than God you don’t”?

    Excel is that Devil people know. It’s not the best tool for a lot of stuffs but it let’s people do things.

    I saw a co-worker generate sequence for formula in excel for another cell in excel. They wanted to do average of all January data, instead of averageif/sumif/countif etc, they generated a sequence a1+a13+a25… And used excels’ drag down thing to make the formula. I’m like who could even verify it.