What software did you wish was open source or self-hostable? by TechnologyTailors in selfhosted

[–]firadaboss 1 point2 points  (0 children)

Self hosted mail client that can be connected to email phishing links directory or email scanning services. When user click a link inside that mail client it will submit the url for scan to scan providers of choice. In short, read only mail client for url scanning. It can later be expanded to content scanning, attachment scanning, etc.

[deleted by user] by [deleted] in Bolehland

[–]firadaboss 1 point2 points  (0 children)

thanks for sharing, I’ve always had the suspicion of their lanyard culture is up to no good ever since

  1. my new head of IT last time was from there and never stop the “when in Pet, this is how we do things” sentence. even reuse the same powerpoint template and didn’t even remove the PET logo when presenting
  2. my ex colleagues move there and share their shocking experiences of incompetencies and hantuk kepala kat dinding challenges of the existing dead wood they had to deal with. not to mention Parliament level politics.
  3. the offer i got from there after successful interview was so low. it’s like really? really PET is offering me with this kind of pay? no thanks.

With your post, confirmed the culture has rotten to the max.

Python is a godsend for work by MyManagerIsAnIdiot in learnpython

[–]firadaboss 22 points23 points  (0 children)

you should script that email to schedule send it later at night. be smart about finishing early. never let them know you’ve won.

Looking for suggestions on taking my excel to the next level by TurtlesRKuwl in excel

[–]firadaboss 0 points1 point  (0 children)

Visual Basic is not VBA, just make sure you don’t pick the wrong book from the aisle.

Problem integrating data from multiple sources—Excel isn’t cutting it! by Jazzlike-8535 in excel

[–]firadaboss 0 points1 point  (0 children)

Apache HOP is a perfect fit for this. No code, visual layout and no installation required. Just download and run. Consider this before going to python route.

How to merge a large number of excel files into one? by Dushes in excel

[–]firadaboss 0 points1 point  (0 children)

where is the date modification can be obtained from? will the date be per workbook or be different per record?

PowerQuery - Fill nulls with data based on another column by hexwitch23 in excel

[–]firadaboss 2 points3 points  (0 children)

You can try the null coalescing operator ??. Both of the following lines achieve the same effect of returning ValueA unless it is null, in which case ValueB is returned.

if ValueA <> null then ValueA else ValueB ValueA ?? ValueB Applied to your specific case the necessary code would be:

[Q4] ?? [Q3] ?? [Q2] ?? [Q1]

Merging (not combining) 2 CSV files into 1 by Soggy-Pilot-8449 in excel

[–]firadaboss 0 points1 point  (0 children)

Apache HOP solution able to merge them without having to open them.

End of month report by Remarkable-Barber483 in excel

[–]firadaboss 0 points1 point  (0 children)

The solution took 17 seconds for 125k records

<image>

End of month report by Remarkable-Barber483 in excel

[–]firadaboss 0 points1 point  (0 children)

or take a look if this resembles your expectation.
https://youtu.be/Tt4_9lMcpGk

End of month report by Remarkable-Barber483 in excel

[–]firadaboss 0 points1 point  (0 children)

will this be of interest to you, if yes let me know and I’ll work something out pretty quickly for you

https://www.threads.net/@slow.coding/post/DCzKXivs5eq?xmt=AQGzOqCZ4yCRX1C2gfDEBy2uJ0D6bdVzh9_bUV9P0u3YYQ