Powerpoint 2016 Flashes Table Before It Appears

This is not a post with a solution, just noting I'm not the only one seeing it: https://answers.microsoft.com/en-us/msoffice/forum/all/table-flashes-in-powerpoint-2016-presentation/214e3675-eacb-4a5d-89e1-2c001f53dbc4

Display or Hide Zero Values in Excel

Annoying issue where when I changed the formatting to Scientific, all the blank cells became 00E00. I didn't want that crowding my spreadsheet.

Solution:

• File > Options > Advanced 
• Under Display options for this worksheet, select a worksheet, and then do one of the following:
• To display zero (0) values in cells, check the Show a zero in cells that have zero value check box.
• To display zero (0) values as blank cells, uncheck the Show a zero in cells that have zero value check box.

Source

Github Backup for Organization with Script

I'm not a github wizard, but I needed to backup the repos on our organization by cloning them all, where most of the repositories are private. After playing around I found a script that would work in the windows git console below. The text in read is what you change.

1. Go to: https://github.com/settings/tokens and generate a personal access token. Make sure you write it down because it will disappear afterwards
2. In the below code, orgname is the name of your organization, and your_access_token is the token you just generated, you will also need to run it for each page.

CNTX=orgs; NAME=orgname; ACCESS_TOKEN=your_access_token; PAGE=1
curl "https://api.github.com/$CNTX/$NAME/repos?page=$PAGE&per_page=100&access_token=$ACCESS_TOKEN" |
  grep -e 'clone_url*' |
  cut -d \" -f 4 |
  xargs -L1 git clone

Echo Dots Not Turning On After Switching Location, Solid Blue Ring

When I moved, my Echo Dots were only giving me a solid blue line instead of activating. Turns out you really need to use the USB cables that come with them. I had tried to use some random ones that were lying around.

Comcast Xfinity Illogical Equipment Transfer

Long story short, I moved from one location to another and tried to use my modem. Because Comcast services are incredibly unhelpful, instead of allowing me to use my original account, they made me create a new account and transfer the credentials. When they removed my modem off my old account and I tried to activate the services at the new location they got 'illogical equipment transfer'

I spent over an hour on the phone with them not being able to figure it out. This is more or less the same issue documented on reddit here, they wanted me to drive to a service center and have it scanned :(

The solution? Use the Chat tool! The person in the chat window managed to resolve the problem in like 15 min.  

Password Protect a PDF

Unfortunately, the one really awesome feature Foxit Reader does NOT have is protecting a PDF with a Password. The next best option is to use https://www.pdfmate.com/download.html PDFMate!

If you are applying a signature in Foxit Follow the Below Steps:

1. Finish Editing the Form in Foxit
2. Save a new version of the document if desired and [Apply Signatures] 
3. Print the Document using Foxit PDF Printer
4. In PDF Mate use the Foxit PDF printed version, use the settings "Letter" and "1N1" 

Stolen PS4 Reporting

Just putting this down for reference.


You need to file a police report, it is the very first thing you need to do. Now, grab your PS4 MAC address from your router and contact Sony customer support. Sony will ask you for your PS4’s MAC address and mark the machine as stolen. From there, Sony will give you a case number once you provide them details of your police report.

Contact the officer in-charge of the case and give them the same details you provided Sony. Give the case number of the officer who will contact Sony and request instant alert as soon as someone logs into your console.

As soon as someone logs in to PlayStation Network, Sony will be able to track the console via its IP address. Sony will provide the obtained location to the officer who will then go ahead and request a warrant. From here on, the officer will go to the location provided by Sony and obtained the PS4 as well as arrest the thief.

It will take a couple of weeks for the console to clear as evidence before you can get your hands on it. Keep in mind that the entire process depends on how long it takes for the thief to log in to the PlayStation Network. It could take a couple of days or a couple of months even. However, whenever he does, it is best that you and Sony are prepared to catch him.

Source: https://segmentnext.com/2017/07/17/can-track-stolen-ps4-heres-situation/

https://www.reddit.com/r/PS4/comments/7bjlv4/ps4_stolen_what_do_i_do/