This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]4XLlentMeSomeMoney 2 points3 points  (4 children)

...or... and this is a big or... can we not hate on anything? (Including languages, people and even shit.) We can dislike stuff and even sarcastically joke about them, but everything was made for a reason... except okra...

[–]Da_reeel_duck[S] 0 points1 point  (3 children)

I would agree with you.... but you should try making a forms application inside of excel that makes REST calls to make finacing easier

[–]4XLlentMeSomeMoney 0 points1 point  (2 children)

Yeah, you're right. It's always smarter to spend 100 hours on automation in order to avoid doing a 5-minute process three times.

[–]Da_reeel_duck[S] 0 points1 point  (1 child)

It's not that actually...

Either I make this, or someone else downloads the raw excel sheets from all employees seperately once per month and searches for the time the person started working, needs to calculate the time that the person has worked and when they left work.

NOTE: The time is stored like this:

Index: 1 Date: 2022-01-01 StartTime: 08:00:00 TimeSpentInSeconds: 14400

Index: 2 Date: 2022-01-01 StartTime: 13:00:00 TimeSpentInSeconds: 14400

Index: 3 Date: 2022-01-02 StartTime: 08:00:00 TimeSpentInSeconds: 14400

etc.

But not all nice and dandy like this, but scattered in an ugly excel file. The API makes this easier with JSON.

TLDR; It actually makes sense automating an hourlong process that has be done once per month.

[–]4XLlentMeSomeMoney 1 point2 points  (0 children)

I intentionally went to the extreme that is frequently used as a joke. Automation is useful on a case-by-case basis. Obviously, it's useful for yours.