• 0 Posts
  • 37 Comments
Joined 1 year ago
cake
Cake day: June 21st, 2023

help-circle

  • It’s not worth the effort and testing. People would only experience it once every 3-4 years, depending on when they get a new laptop. Must still shouldn’t have to worry since other software would install that version of .NET already.

    Plus, people don’t bother to read error messages anyways. Another tool I created would create PDFs of the financials. The first section would be pulled from the EPM and the second would be a data dump of every transaction for each cost center. If the totals don’t match to the dollar, the script would throw an error.

    90% of the time, it was because the EPM data was being refreshed as it’s scheduled to do so every half hour and takes 3-4 minutes. So I had the error message tell the person to just go take a quick break and come back. Still, people would email me saying they don’t understand why they’re getting the error and it would always be fixed if they just wait.


  • I don’t even work in IT but I make complex Excel tools for my Finance team.

    I get an email about once every week or two from one of my coworkers asking what to do about an issue. Nearly every single issue would have been resolved if they just read even the first few instructions.

    My favorite is a specific tool we use to review the financials. It relies on Scripting.Dictionary which is only present in .NET 3.5.1 or prior. The very first instruction on the file says you need to download it. There’s even a very handy button right there which will take you to our software center to install it.

    Yet every single time someone gets a new laptop, they immediately assume that the file is broken.







  • OpnSense would be the easiest way if you wanted to go. It’s still not easy, but the articles online should help you out.

    First you’d need a machine. I’ve got an m920q I bought off eBay for $135 after shipping.

    The computer will likely only have one Ethernet port. And it’s likely the port is Realtek which isn’t supported well.

    So, you’ll need to get yourself a NIC (a fancy term for a network card). There are good forum posts and articles online about the best NICs to buy for your needs. Intel is a must. However, you can find many of their NICs online labeled as another brand - usually HP, Lenovo, or Dell. Again, the forum posts will tell you what to look for.

    If you bought the same computer I mentioned above, you’ll also need a riser and a bezel. Amazon and eBay will have a good selection.

    Now assemble it. Flash the computer with OpnSense. Don’t plug it in as your router yet. Follow along with some basic setup guides online to figure out how you want it configured.

    Once you’re happy, plug it in as your router and test that it works. If not, you’ll need to put your old router back in place until you can figure out what you need to change.