1053
you are viewing a single comment's thread
view the rest of the comments
[-] Oddbin@lemmy.world 88 points 11 months ago* (last edited 11 months ago)

It will live in a folder with:

Spreadsheet(1).xls Spreadsheet - shortcut.lnk Spreadsheet(2) - Copy.xls New Spreadsheet - DO NOT USE.xls

[-] blackbirdbiryani@lemmy.world 34 points 11 months ago

I have colleagues who have 20 copies of the same document with slight variations named like this in a folder. I honestly don't understand how they function at work.

[-] EatYouWell@lemmy.world 19 points 11 months ago

Sort by last modified

[-] droans@lemmy.world 16 points 11 months ago

I work in Finance at my company and we always save revised copies for Excel files instead of saving over.

But we also have strict rules on it. File name is always "xxxx_Workbook Template Name_MMDDYY.xlsx" or "_YYYY_MM.xlsx", depending on how often it gets updated.

Older versions get moved to a subfolder. It helps us go back and find out what something was if there was a mistake or revert back if Excel done fucks up.

[-] timbuck2themoon@sh.itjust.works 10 points 11 months ago
[-] lars@lemmy.sdf.org 24 points 11 months ago

using git on a bunch of XML files saved into a binary ZIP file with a .xlsx filename extension is a hell whose circle we have not yet discovered

[-] gazter@aussie.zone 4 points 11 months ago

Almost 24 hours and no one has commented on MMDDYY? I don't know whether to be proud or disappointed.

[-] WhiteHotaru@feddit.de 2 points 11 months ago

As an European I just sigh and read on.

[-] blackbirdbiryani@lemmy.world 3 points 11 months ago

Honestly this is one I the reasons why I love Google sheets (controversial I know) as it has a built in version control system.

[-] freebee@sh.itjust.works 4 points 11 months ago

Excel has it too if you store it in onedrive or a sharepoint library with versioning enabled

[-] Matriks404@lemmy.world 2 points 11 months ago

Do people in your company know that there's something called Windows File History?

[-] Blue_Morpho@lemmy.world 2 points 11 months ago

It never works when you need it. Like "that file was too big", that file was on a network share, that file is outside the window of how many old changes are saved. It's like using an undelete utility. Sometimes you get lucky.

It's better to save every change as a dated/numbered file or use a real source control system.

[-] CommanderCloon@lemmy.ml 0 points 11 months ago

If there's "Windows" or "Microsoft" in its name, you're risking your business by relying on it

[-] Hellstormy@lemmy.world 8 points 11 months ago* (last edited 11 months ago)

That's just version control but worse!

[-] freebee@sh.itjust.works 7 points 11 months ago

Could be they don't.

[-] pineapplelover@lemm.ee 7 points 11 months ago

Every tech noob user I see. Worse if it's mac because 1) I cannot use it for the life of me and 2) almost every Mac user stores it in the same default downloads folder and won't know what path it's in unless they use the Finder tool.

[-] banneryear1868@lemmy.world 2 points 11 months ago

I just sort by date modified on my work folder and purge stuff older than a year. Anything of value was moved to its permanent home and properly document controlled.

It's a river of trash yes but anything of value floats to the surface.

[-] blackbirdbiryani@lemmy.world 3 points 11 months ago

My files are all perfectly stored but it's impossible to enforce proper naming on your colleagues... No matter how clearly you spell it out they will always mess it up.

[-] banneryear1868@lemmy.world 1 points 11 months ago

We have a document repository managed by corporate governance and to file documents in it they need to go through a workflow which enforces naming convention/category and establishes approval chain, version control, and review intervals. Anything that is actively used for things should be captured in this system, there's some that aren't of course but it's the standard and you're laughed at if you reference documentation outside of this system basically. We do this to comply with audit requirements but it's also just good practice and everyone basically sees the value in it, despite the mild annoyance of dragging your document in to a webpage and filling out some fields.

That's why I don't care about my personal document organization too much, because anything of value is getting liberated into a controlled doc template meant for it's specific purpose and put into the system where it lives it's life.

[-] gazter@aussie.zone 0 points 11 months ago

It probably makes sense to them. I'm sure they're looking at your git workflow wondering how you function!

[-] blackbirdbiryani@lemmy.world 2 points 11 months ago

Nah, because when I ask them for info they stare at their directory and have to randomly open files for 20 minutes until they land on the item of interest...

[-] banneryear1868@lemmy.world 0 points 11 months ago

I routinely scan file shares to find the top oldest modified dates on files.

load more comments (12 replies)
this post was submitted on 12 Dec 2023
1053 points (98.9% liked)

Lemmy Shitpost

26965 readers
2749 users here now

Welcome to Lemmy Shitpost. Here you can shitpost to your hearts content.

Anything and everything goes. Memes, Jokes, Vents and Banter. Though we still have to comply with lemmy.world instance rules. So behave!


Rules:

1. Be Respectful


Refrain from using harmful language pertaining to a protected characteristic: e.g. race, gender, sexuality, disability or religion.

Refrain from being argumentative when responding or commenting to posts/replies. Personal attacks are not welcome here.

...


2. No Illegal Content


Content that violates the law. Any post/comment found to be in breach of common law will be removed and given to the authorities if required.

That means:

-No promoting violence/threats against any individuals

-No CSA content or Revenge Porn

-No sharing private/personal information (Doxxing)

...


3. No Spam


Posting the same post, no matter the intent is against the rules.

-If you have posted content, please refrain from re-posting said content within this community.

-Do not spam posts with intent to harass, annoy, bully, advertise, scam or harm this community.

-No posting Scams/Advertisements/Phishing Links/IP Grabbers

-No Bots, Bots will be banned from the community.

...


4. No Porn/ExplicitContent


-Do not post explicit content. Lemmy.World is not the instance for NSFW content.

-Do not post Gore or Shock Content.

...


5. No Enciting Harassment,Brigading, Doxxing or Witch Hunts


-Do not Brigade other Communities

-No calls to action against other communities/users within Lemmy or outside of Lemmy.

-No Witch Hunts against users/communities.

-No content that harasses members within or outside of the community.

...


6. NSFW should be behind NSFW tags.


-Content that is NSFW should be behind NSFW tags.

-Content that might be distressing should be kept behind NSFW tags.

...

If you see content that is a breach of the rules, please flag and report the comment and a moderator will take action where they can.


Also check out:

Partnered Communities:

1.Memes

2.Lemmy Review

3.Mildly Infuriating

4.Lemmy Be Wholesome

5.No Stupid Questions

6.You Should Know

7.Comedy Heaven

8.Credible Defense

9.Ten Forward

10.LinuxMemes (Linux themed memes)


Reach out to

All communities included on the sidebar are to be made in compliance with the instance rules. Striker

founded 1 year ago
MODERATORS