Category Archives: Work

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

[SOLVED] Lenovo BSOD on Windows 7, Windows has recovered from an unexpected shutdown

One my clients uses a number of Lenovo mini PC systems. The systems perform very well for their intended purposes, however, some of the systems were sporadically shutting down (blue screen of death). Thankfully, disabling Bluetooth devices/adapters in Device Manager seems to have permanently resolve the issue. The client did not need the bluetooth capability in the first place, so now all is well 🙂 For reference, here is the error message and assorted diagnostic info: Problem signature: Problem Event Name:

How to cancel business registration on GoDaddy

To Cancel Business Registration: Login to your GoDaddy account. Go to My Account Account Settings Renewal & Billing Check the box next to the Business Registration account that you want to cancel, and then click Cancel Item. Confirm. Screenshots of the process: Further explanation: I had a client that was getting billed $4.99 for Business Registration and they were not using the service (it had never even been set up). They asked me to help them cancel it and I did

When closing TeamViewer it automatically locks my PC back to the logon screen?! [SOLVED]

Recently I had a client dealing with a Windows PC always being locked when they logged into their machine via TeamViewer. They wanted to be able to login directly to the machine without a password prompt so they tried disabling automatic lock via Windows Power Settings, no luck. They tried auto logon via control userpasswords2, no luck. Thankfully, I was able to fix the issue by utilizing the following TeamViewer option: Actions -> Lock -> UNCHECK Lock on session end Screenshot:

How long to file for & receive an EIN online? [SOLVED]

Q. How long does it take to file for and receive an EIN??? A. Generally, it takes less than 15 minutes to receive an EIN. Here are the details: If you visit the IRS website during normal hours of operation and your principal business is located in the United States: You can complete the process online at the offical IRS website: https://www.irs.gov/businesses/small-businesses-self-employed/apply-for-an-employer-identification-number-ein-online It takes about 5-10 minutes, after which the IRS will assign you an EIN You will immediately receive your EIN

Orange solid status light on Synology NAS? [SOLVED]

Q. What does a solid orange status light on my Snology DS 1813+ mean? -Sean T. A. Great question! Here are the meanings of the status lights Green Static Status LED Volume Normal Orange Static Status LED Available volume space < 1GB Available volume space < 1 % Orange Blinking Status LED Volume degraded or crashed DSM not installed Green/Orange Alternating Status LED No internal disk No Color / Status LED Off  HDD Hibernation In your instance, it would appear that

Best (low cost) digital signage solution w/remote centralized management

Recently I was tasked with recommending a digital signage solution for a client. Specifically, they needed centralized maintenance and control of approximately 20-30 signs covering 10-12 locations. Another paramount goal was cost effectiveness via no recurring/subscriptions costs. Here is my digital signage recommendation: Specific unit recommendation: Mvix Xhibit Myrko   Mvix Xhibit Myrko   http://direct.mvixusa.com/product/xhibit-mykro-digital-signage $259 single time cost to purchase device No additional license cost, no subscription fees Remote management Single HDMI output My recommendation is for one of the

Drawbacks of Mvix Amazon Fire TV app

As best I can tell, for digital signage there are two main drawbacks to the Mvix Amazon Fire TV app solution:   #1 Monthly fee They charge a $30 per month fee per account. However, that does cover all the devices/displays that are in use (it is NOT a per unit fee). For more details: http://signagecreator.com/pricing (click the “Amazon Fire TV” button for that pricing, or see my attached screenshot) #2 Performance or content limitations I am  also worried about the