Category Archives: company tips

Keep formatting in Excel when copying/pasting from web page

Question from B.G.: Sorry to bother. How can I export and keep the integrity of the web page table columns? When I copy and paste to excel, it puts all data to 1 row. Answer:  Good question! Please find the steps below: Instructions In your web browser window showing the table/report, press CTRL+A (to select all) Then press CTRL+C (to copy) Switch to a blank spreadsheet in Excel, press CTRL+V (to paste) That should result in a nice separate set of

How to get Audible credits/books cheap

Audible offers an amazing assortment of audio books. However, with one credit a month it can be hard to get your full audio book fix. While you can always purchase audio books at “full price”, the cost is often quite expensive (i.e. $20-$40). Thankfully, Amazon added a new feature where you can find audio book versions of your favorite ebooks at a significant discount. Any existing purchase you have made on Amazon may be eligible for the sale price. I was surprised that

+Cancel FreedomPop Premier service [SOLVED!]

Question: Hello J.D., I have read your FreedomPop articles in the past and I really like their free internet services. I made sure to downgrade to the free plan and I love it. However, now I am getting a $9.99 bill for “Premier service” and I can not for the life of me figure out how to cancel it 🙁 Can you please help me cancel? Thank you, Tony K. Answer: Dear Tony, thank you for your message. Yes, I think I

How to reboot Amcrest IP security camera remotely [SOLVED]

Q. How do I reboot my Amcrest cameras remotely from my PC? I am on the same network but do not have physical access. A. Here is how to remotely reboot your Amcrest IP camera: Determine the IP address of the camera that you would like to reboot Use a web browser to navigate to the IP Login (admin username, admin password are the default login credentials) go to System -> Auto Maintain -> Manual Reboot   Your Amcrest IP

OnePlus 5 Return RMA Instructions

If you need to return your OnePlus 5 phone, please find below the official instructions from a OnePlus employee. First I tried their website’s support ticket section, and these are the specific instructions they gave me 🙂 I added screenshots to illustrate the process and I hope this helps! -J.D. […] if you really want to return your device since it’s still within our 15-day return warranty you need to create a return request. Once we approve your request and

EnGenius ECB350 Power Supply Voltage and Amperage [SOLVED]

The EnGenius Technology ECB350 is a very nice access point/bridge that can utilize either a “wall wart” power supply or a 802.3af POE connection for power. Recently I misplaced one of the wall wart power supplies and needed to find/replace it with an approriate model. As such, here are the power supply requirements for the ECB350: Active Ethernet (Power-over-Ethernet, IEEE 802.3af) 48VDC/0.375A -or- Wall Plug In Power Supply: 12V/1A TIP: If you need a replacement power supply, Amazon has them. 🙂 I hope