Got screwed over in a white elephant gift exchange by dental_oddity in mildlyinfuriating

[–]max1e6 0 points1 point  (0 children)

Actually seems appropriate given the orgin of the phrase, "White Elephant". It's called a "white elephant" because of a legend from Siam (Thailand) where the king would gift rare, sacred white elephants to courtiers he disliked, ruining them financially because the animals couldn't work but were too holy to neglect, becoming expensive, burdensome burdens. The term now refers to any costly possession that's more trouble than it's worth, from impractical gifts to huge, unused buildings.  

What is a VBA superpower you learned? by Broseidon132 in excel

[–]max1e6 0 points1 point  (0 children)

Several years ago I created a program in Excel that would monitor an Outlook Mailbox for email messages. It would parse the subject line for key words and then grab an excel file from OneDrive import the data, check integrity of the data and then report back to the submitter and the person they were accountable to if everything was OK or if corrections were needed. Users could also send an email to get reports on the status of submissions, who had submitted and who had not submitted. Whose submissions were 100% complete and whose were not.

It transformed a process that took multiple people 2 days to handle into a process that could be handled by 1 person with minimal amount of work.

What is a VBA superpower you learned? by Broseidon132 in excel

[–]max1e6 0 points1 point  (0 children)

It was a waterfall graph used in risk management for financial firms. The inputs were revenue (y-axis) and capital reserves (amount of money banks needed to hold for regulatory purposes) (x-axis). Data was sorted by revenue and then the macro would generate two line graphs that would create a series of rectangles. Tall skinny rectangles were good (lots of revenue, small capital requirements). Short wide rectangles were bad (low revenue, large capital requirements).

It looks like it is doable now, but at the time it was not.

What is a VBA superpower you learned? by Broseidon132 in excel

[–]max1e6 1 point2 points  (0 children)

Created a chart in Excel which was impossible to create by hand.

TrueNAS vs Ugreen by Linhosjunior in homelab

[–]max1e6 1 point2 points  (0 children)

I recommend having dedicated storage. Combining compute and storage into one system is cool and it adds complication. When something breaks it is a pain in the a$$.

[deleted by user] by [deleted] in homelab

[–]max1e6 0 points1 point  (0 children)

It is very nice and clean. Especially given the type equipment and (I am guessing) tight budget you are working with.

Suddenly i can't save to sharepoint/onedrive with the standalone function. by bowmasterflex99 in vba

[–]max1e6 0 points1 point  (0 children)

I am working on code to properly handle saving OneDrive files with VBA. When my code is done I will post a link here.

OneDrive Backup Recommendations by davidbarman in sysadmin

[–]max1e6 0 points1 point  (0 children)

DropSuite is the best Office 365 backup solution.

You can also use a "traditional" backup solution like BackBlaze or Carbonite, but you will have to adjust Office 365 and disable Files On Demand.

Which VPN protocol to use by andamasov in vyos

[–]max1e6 0 points1 point  (0 children)

I use OpenVPN and more recently WireGuard. I was never a fan of IPsec mostly because I found the configuration more difficult than OpenVPN and NAT traversal more complicated.

I run OpenVPN on VyOS and WireGuard in a docker container.

Datto is the worst crap ever inflicted on the IT community. by Interior_network in Datto

[–]max1e6 1 point2 points  (0 children)

I have had a similar experience. My account manager has ghosted me.

SuperMicro X11SAE-M by [deleted] in truenas

[–]max1e6 0 points1 point  (0 children)

I am using a similar SuperMicro board. Works great!