Excel: SUM If Greater Than

Formula to compute for values if cells have values greater than a specified amount

Formula

=SUMIF(range, expression)

Add the values in cells if the value is greater than 4000

=SUMIF(A1:A8,">4000")

Add the values in cells if the value is greater than 2000

=SUMIF(A1:A8,">2000")

Add the values in cells if the value is greater than 1000

=SUMIF(A1:A8,">1000")

Formula Parameters

  • Range – The first part of the formula lets you specify the range to add.
  • Expression – The second part of the formula lets you specify the condition. The condition is in string form. You can use multiple logical operators.
=SUMIF(A1:A8,">=1000")
=SUMIF(A1:A8,"<=1000")

Screen shot 2016 10 03 at 8.11.00 am

 Download Streaming Video TS files

Streaming videos are all around us now. Our simple video downloaders cannot download most of them.

Here’s a way to download streaming video without any other software.

Open the site on your browser.

Just open the web page where the video is located. The video shouldn’t be playing yet. We would miss some part of the video if you play it sooner.

Get the source of the video

The source can normally be seen by going through the menu. View > Developer > Developer Tools. If you aren’t on the network tab, press Network. Here you’ll be able to view resources currently being downloaded on your system.

Play the video

You will notice the video being downloaded by your browser. You notice things like this.

https://cdn.yourvideos.com/34243/f34234/bheop1.ts
https://cdn.yourvideos.com/34243/f34234/bheop2.ts
https://cdn.yourvideos.com/34243/f34234/bheop3.ts
https://cdn.yourvideos.com/34243/f34234/bheop4.ts
https://cdn.yourvideos.com/34243/f34234/bheop5.ts

This will load a few seconds at a time.

Right-click and press, Copy Link Address

Open your terminal

Make sure you have wget. Type in the following.

wget -r https://cdn.yourvideos.com/34243/f34234/bheop{1..6}.ts

The above commands will download the ts files. Press Enter and wait for the process to finish. This would have downloaded the files.

Combine the files

Go to the location of the ts files. You might need to get through many folders to get to the location.

cd 34243/f34234/

Type in the following, assuming the filename of your ts files start with bheop1 and end with bheop6

echo 'bheop1'{1..6}.ts | tr " " "\n" > tslist
while read line; do cat $line >> your_new_video.ts; done < tslist

Your finished and combined video would be named your_new_video.ts. It will also be ready for viewing using VLC

Screen shot 2016 06 25 at 5.00.34 am

 Top 5 Text Editors for Programmers

I have been a programmer for about 14 years. Jumping from one programming language to another. More often, jumping from a text editor to another, discovering the best text editor to help me with the speed of development process.

My list does include Windows variations, as well as Linux and Mac ones.

Atom Editor

This is the latest editor that I have been using. It’s speed has increased from what it was. It was so slow that I had to go back to TextMate 2. Now, I love it so much I have built a list of shortcuts for the Atom Editor

Sublime Text Editor

This has to be the one of the most used GUI programming text editor used right now. The reason is the speed and practicality, since you can use it on virtually all of the platforms. A lot of the former TextMate users shifted to Sublime Text due to the speed of releases of the former.

TextMate 2

TextMate 2 is free unlike it’s little brother, TextMate 1. It has dramatically sped up probably because of the help it’s been getting from the number of open-source contributors.

TextMate brings Apple’s approach to operating systems into the world of text editors. By bridging UNIX underpinnings and GUI, TextMate cherry-picks the best of both worlds to the benefit of expert scripters and novice users alike.

PSPad

PSPad is a Windows only editor. It is so versatile and speed is impressive.

PSPad is a freeware programmer’s editor for Microsoft Windows operating systems, useful for people who:
* work with various programming environments
* like highlighted syntax in their source code
* need a small tool with simple controls and the capabilities of a mighty code editor
* are looking for a tool that handles plain text
* want to save time – PSPad offers rich text formatting functions
* need a tool that offers user extension capabilities
* want to save money and still have the functionality of professional products because PSPad is free for commercial and government purposes too

Notepad ++

If you ever come from a Windows environment, you would have definitely handled files through Notepad++.

Notepad++ is a free (as in “free speech” and also as in “free beer”) source code editor and Notepad replacement that supports several languages. Running in the MS Windows environment, its use is governed by GPL License.

 Atom Editor Comprehensive Shortcut List

I have been an avid Textmate user since about 5 years ago. I have worked with it for so long that I have been so familiar with it. In the past few months I have been trying out Atom. Atom is an open-source editor created by Github. I always say that an editor is only as good as how you use it. Shortcuts are one of the ways to enhance speed with coding.

Here is a comprehensive shortcut list used in Atom

Atom Editor Shortcuts

Case

Task Command
convert to lowercase Command-k-L
convert to uppercase Command-k-U

Comments

Task Command
Toggle Comment Command-/

File Management

Task Command
Find File Command-t
Open File Command-b
Toggle Tree View Pane Command-\
Reopen Last File Command-Shift-t

Code Management

Task Command
Join Lines Command-j
Indent Selected Line Command-]
Outdent Selected Line Command-[
Select Line Command-L