Wednesday, June 28, 2017

Space Opera Vs!

Here is a cool little thing I like to do... Get a genre. Find the main TV series and Films in that genre and add up all their scores and compare....

Where do I get the scores? of course. So all of the numbers below that have a year beside them are from IMDB. The first box is my total averages... enjoy!

(Space opera is a subgenre of science fiction that emphasizes space warfare, melodramatic adventure, interplanetary battles, as well as chivalric romance, and often risk-taking.)

Star Trek7.267
Star Wars7.825
Star Gate7.771
Battlestar Galactica7.660
Babylon 56.988

Firefly Wins Of course....

The OBVIOUS winner here is Firefly with  8.5/10. I was wondering if I should have added in Starship Troopers? What do you think? I have added Andromeda as an "also ran". But when I was looking into Andromeda I was surprised how many of its cast would turn up in other Space Opera.

But there is a breakdown below: 

Star Trek
Star Trek (1966–1969)8.4
Star Trek: The Motion Picture (1979)6.4
Star Trek II: The Wrath of Khan (1982)7.7
Star Trek III: The Search for Spock (1984)6.6
Star Trek IV: The Voyage Home (1986)7.3
Star Trek: The Next Generation (1987–1994)8.6
Star Trek V: The Final Frontier (1989)5.4
Star Trek VI: The Undiscovered Country(1991)7.2
Star Trek: Deep Space Nine(1993–1999)7.9
Star Trek: Generations(1994)6.6
Star Trek: Voyager (1995–2001)7.7
Star Trek: First Contact(1996)7.6
Star Trek: Insurrection(1998)6.4
Star Trek: Enterprise(2001–2005)7.7
Star Trek: Nemesis (2002)6.4
Star Trek (2009)8
Star Trek Into Darkness(2013)7.8
Star Trek Beyond (2016)7.1
Star Wars
Star Wars: Episode IV - A New Hope (1977)8.7
Star Wars: Episode V - The Empire Strikes Back(1980)8.8
Star Wars: Episode VI - Return of the Jedi (1983)8.4
Star Wars: Episode I - The Phantom Menace (1999)6.5
Star Wars: Episode II - Attack of the Clones (2002)6.6
Star Wars: Episode III - Revenge of the Sith (2005)7.6
Star Wars: The Force Awakens (2015)8.1
Rogue One (2016)7.9
Star Gate
Stargate (1994)7.1
Stargate SG-1 (1997–2007)8.4
Stargate: Atlantis (2004–2009)8.1
Stargate: Continuum (2008)7.6
Stargate: The Ark of Truth(2008)7.4
Stargate SG-1: Children Of Gods - Final Cut (2009)8.1
SGU Stargate Universe(2009–2011)7.7
Firefly (2002–2003)9.1
Serenity (2005)7.9
Battlestar Galactica
Battlestar Galactica (1978 - 1979)7.1
Battlestar Galactica (2003)8.6
Battlestar Galactica (2004 - 2009)8.7
Battlestar Galactica : The Resistance (2006)7.9
Battlestar Galactica : Razor (2007)7.7
Battlestar Galactica : Razor Flashbacks (2007)7.7
Battlestar Galactica : The Face Of The Enemy (2008)7.7
Caprica (2009 - 2010)7.1
Battlestar Galactica : The Plan (2009)7.1
Battlestar Galactica : Blood And Chrome (2012)7
Farscape (1999 - 2003)8.3
Farscape : The Peacekeeper Wars (2004)8.2
Babylon 5
Babylon 5 : The Gathering (1993)6.6
Babylon 5 (1994 - 1998)8.3
Babylon 5 : In The Beginning (1998)7.7
Babylon 5 : Thirdspace (1998)6.9
Babylon 5 : The River Of Souls (1998)6.6
Babylon 5 : A Call To Arms (1999)7.2
Babylon 5 : The Legend Of The Rangers (2002)6.1
Babylon 5 : The Lost Tales (2007)6.5
Andromeda (2000 - 2005)6.6

Star Wars should have scored higher... Thanks Lucas!

Have I left any out? Please tell me what you think at

Monday, June 26, 2017

A Handmaid's Tale

Going to cut to the chase here. This could have been called "A 'Vision Of Donald Trump's World In The Future' Tale".

Bloody horrible existance. Welcome to Saudi Arabia.  
Have you been watching "A Handmaid's Tale"? It is very good. Well acted. You know all the usual stuff, the sets are well lit. The sound is good. These are things you take for granted but they need alot of work in television and film production. What else is important? Hmmm... Well the continuity is good. You know what continuity is? That is when someone is for example holding a cup in, lets say, their right hand in a scene, the camera cuts away from them and then back to them and all of a sudden they are holding the cut in their left hand. You know? What else is important?


Well set costumes are important. All the clothes look well, Gives a certain look and feel to the program. A feeling of doom and utter hopelessness. A feeling that everything is shit in this world and that there is no hope for anyone. Wait a second, this is reminding me of one more thing that I have left out of my "what makes a good TV or Movie" list.

Yes, that's it. The story. You know like a quality story. Not like Eastenders or Home and Away story. I mean a real story that actually has something to say. Like real meaning kind of stuff. So I don't want to give too many spoilers away so if you do not want any spoilers look away now... go to another webpage. Close this tab on your browser and go elsewhere. Go on....

If your still reading. Ask yourself this. What countries support female genital mutilation? What countries is it illegal to be gay in? Would you visit these countries? Would you support their governments? Support their economies? Well I did some research.

Here is a link to the Wiki page on the trendy FGM...

Percentage of the 15–49 group who have undergone FGM in 29 countries for which figures were available in 2016

How about countries that are illegal to be gay in? Lets look into that....

(going away doing some research...)

  1. Yemen
  2. Iran
  3. Mauritania
  4. Nigeria
  5. Qatar
  6. Saudi Arabia
  7. Afghanistan
  8. Somalia
  9. Sudan
  10. United Arab Emirates
Boy oh boy... scary isn't it. Saudi Arabia... UAE. These are countries that we trade with! These are countries that America have done massive arms deals with lately. USA have signed an arms deal worth $110 billion with SA that will increase to around $350 billion in the coming years (click here for link). You telling me that a man as crazy as Trump might not make the Handmaid's tale come true?

I love the series A Handmaid's Tale so much because I hate the point of the story of the Handmaid's tale so much.
Existence is horrible for 100's of millions of women because of religion.
If you are not watching A Handmaid's Tale already, watch it now I would advise. Link to the IMDB page is below.

Friday, June 23, 2017

Keyboard shortcuts for Google Sheets

Whats All This Then?

Well what this is, is an extremely helpful list of keyboard shortcuts in Google Sheets. Google Sheets is the equalivant to Microsoft Excel. So these commands are for Windows and boy to I love them. 

Want to insert a row in Sheets?
Insert rows aboveCtrl + Alt + Shift + =
Ctrl + Alt + =

(with rows selected)

Want to delete a row?
Delete rowsCtrl + Alt + - (with rows selected)

Full Page is here with links to Windows, Chrome OS and Mac

Common actions
Select column Ctrl + Space
Select row Shift + Space
Select all Ctrl + a
Ctrl + Shift + Space
Undo Ctrl + z
Redo Ctrl + y
Ctrl + Shift + z
Find Ctrl + f
Find and replace Ctrl + h
Fill range Ctrl + Enter
Fill down Ctrl + d
Fill right Ctrl + r
(every change is saved automatically in Drive)
Ctrl + s
Open Ctrl + o
Print Ctrl + p
Copy Ctrl + c
Cut Ctrl + x
Paste Ctrl + v
Paste values only Ctrl + Shift + v
Show common keyboard shortcuts Ctrl + /
Insert new sheet Shift + F11
Compact controls Ctrl + Shift + f
Input tools on/off
(available in spreadsheets in non-Latin languages)
Ctrl + Shift + k
Select input tools Ctrl + Alt + Shift + k
Format cells
Bold Ctrl + b
Underline Ctrl + u
Italic Ctrl + i
Strikethrough Alt + Shift + 5
Center align Ctrl + Shift + e
Left align Ctrl + Shift + l
Right align Ctrl + Shift + r
Apply top border Alt + Shift + 1
Apply right border Alt + Shift + 2
Apply bottom border Alt + Shift + 3
Apply left border Alt + Shift + 4
Remove borders Alt + Shift + 6
Apply outer border Alt + Shift + 7
Ctrl + Shift + 7
Insert link Ctrl + k
Insert time Ctrl + Shift + ;
Insert date Ctrl + ;
Insert date and time Ctrl + Alt + Shift + ;
Format as decimal Ctrl + Shift + 1
Format as time Ctrl + Shift + 2
Format as date Ctrl + Shift + 3
Format as currency Ctrl + Shift + 4
Format as percentage Ctrl + Shift + 5
Format as exponent Ctrl + Shift + 6
Clear formatting Ctrl + \
Navigate spreadsheet
Move to beginning of row Home
Move to beginning of sheet Ctrl + Home
Move to end of row End
Move to end of sheet Ctrl + End
Scroll to active cell Ctrl + Backspace
Move to next sheet Ctrl + Shift + Page Down
Move to previous sheet Ctrl + Shift + Page Up
Display list of sheets Alt + Shift + k
Open hyperlink Alt + Enter
Open Explore Alt + Shift + x
Move focus out of spreadsheet Ctrl + Alt + Shift + m
Move to quicksum
(when a range of cells is selected)
Alt + Shift + q
Move focus to popup
(for links, bookmarks, and images)
holding Ctrl + Alt, press e then p
Open drop-down menu on filtered cell Ctrl + Alt + r
Open revision history Ctrl + Alt + Shift + h
Open chat inside the spreadsheet Shift + Esc
Close drawing editor Shift + Esc
Edit notes and comments
Insert/edit note Shift + F2
Insert/edit comment Ctrl + Alt + m
Open comment discussion thread Ctrl + Alt + Shift + a
Enter current comment holding Ctrl + Alt, press e then c
Move to next comment holding Ctrl + Alt, press n then c
Move to previous comment holding Ctrl + Alt, press p then c
Open a menu
File menu in Google Chrome: Alt + f
other browsers: Alt + Shift + f
Edit menu in Google Chrome: Alt + e
other browsers: Alt + Shift + e
View menu in Google Chrome: Alt + v
other browsers: Alt + Shift + v
Insert menu in Google Chrome: Alt + i
other browsers: Alt + Shift + i
Format menu in Google Chrome: Alt + o
other browsers: Alt + Shift + o
Data menu in Google Chrome: Alt + d
other browsers: Alt + Shift + d
Tools menu in Google Chrome: Alt + t
other browsers: Alt + Shift + t
Open insert menu Ctrl + Alt + Shift + =
Ctrl + Alt + = 

(with cells selected)
Open delete menu Ctrl + Alt + - (with cells selected)
Form menu
(present when the spreadsheet is connected to a form)
in Google Chrome: Alt + m
other browsers: Alt + Shift + m
Add-ons menu in Google Chrome: Alt + n
other browsers: Alt + Shift + n
Help menu in Google Chrome: Alt + h
other browsers: Alt + Shift + h
Accessibility menu
(present when screen reader support is enabled)
in Google Chrome: Alt + a
other browsers: Alt + Shift + a
Sheet menu
(copy, delete, and other sheet actions)
Alt + Shift + s
Context menu Ctrl + Shift + \
Insert, delete, hide, or unhide rows or columns
Insert rows above Ctrl + Alt + Shift + =
Ctrl + Alt + =

(with rows selected)
in Google Chrome: Alt + i, then r
other browsers: Alt + Shift + i, then r
Insert rows below in Google Chrome: Alt + i, then w
other browsers: Alt + Shift + i, then w
Insert columns to the left Ctrl + Alt + Shift + =
Ctrl + Alt + = 

(with columns selected)
in Google Chrome: Alt + i, then c
other browsers: Alt + Shift + i, then c
Insert columns to the right in Google Chrome: Alt + i, then o
other browsers: Alt + Shift + i, then o
Delete rows Ctrl + Alt + - (with rows selected)
in Google Chrome: Alt + e, then d
other browsers: Alt + Shift + e, then d
Delete columns Ctrl + Alt + - (with columns selected)
in Google Chrome: Alt + e, then e
other browsers: Alt + Shift + e, then e
Hide row Ctrl + Alt + 9
Hide column Ctrl + Alt + 0
Unhide row Ctrl + Shift + 9
Unhide column Ctrl + Shift + 0
Use formulas
Show all formulas Ctrl + ~
Insert array formula Ctrl + Shift + Enter
Collapse an expanded array formula Ctrl + e
Show/hide formula help
(when entering a formula)
Shift + F1
Full/compact formula help
(when entering a formula)
Absolute/relative references
(when entering a formula)
Toggle formula result previews
(when entering a formula)
Resize formula bar
(move up or down)
Ctrl + Up / Ctrl + Down
Help for screen readers
Turn on screen reader support
Learn more about using Google Sheets with a screen reader
Ctrl + Alt + z
Read column Ctrl + Alt + Shift + c
Read row Ctrl + Alt + Shift + r

Wednesday, June 21, 2017

Search Concepts We All Should Know - From Google

This is actually pretty reading. I am signing websites up to Googles Search Console and this was one of the pages that was on it. Considering it is Google that supplied this document I consider it very worth reading.

And here goes...

The reports in Search Console are organized according to the general outline of the Google Search pipeline: Content is first crawled (discovered), then it is indexed (parsed and analyzed for content), after which you, the website owner, analyze the search traffic to your site and also consider how search results are displayed to the user or linked to by other sites.


Google’s web crawlers follow links and sitemaps to generate a list of publicly available URLs to visit and index for content. This is the first step in the process of being added to Google’s search results.
  • Property
    A generic term for a website or an app that you have added to your Search Console account. You can see a list of your properties on your account homepage.
  • Verify
    To prove that you own the website or app referred to in your Search Console account. A property must be verified before you can start seeing any data for it. You’ll be asked to verify a site after you add it to your Search Console account.
  • Googlebot
    Google’s web crawler. Google has a few different Googlebots that request your pages as different device types (a smartphone, a feature phone, or a desktop computer) to calculate different search results for users searching on these devices.
  • Canonical
    If you host the same page at different URLs, your search results can be diluted across these duplicate pages. For example, you might have the same page at and; a search might then show separate, lower ranked results for each page than if you had only a single page. In this case, you should indicate to Google that these pages are the same, and choose one to be canonical (the official page) to show in search results. Indicate canonical pages or sites using a Sitemap, HTML tags, or Search Console settings.
  • robots.txt
    The name of a file on your site that tells Google which pages not to index or show in search results.
  • Sitemap
    A list of URLs in your site that Google uses as starting locations to begin crawling a website. A sitemap is contained in one or more files stored on your website.


The process of visiting URLs and analyzing the content and meaning of each page. This helps Google determine the best search results for a user’s query.
  • Resource
    A web page typically loads many additional resources such as CSS, JavaScripts, and images. Be sure that Googlebot isn’t blocked from accessing any resources that affect the meaning of the page during the indexing process.
  • Render
    Google tries to display all pages that it indexes in order to view the page as a user would. Rendering is the process of displaying the page with the images and layout to help Google analyze the meaning of the page.

Search traffic

  • Manual action
    If your page violates one of Google’s quality guidelines, such as spammy content, it can be subject to a manual action, which will demote it in Google search results.
  • International targeting
    Explicitly targeting your search results at users by language or country. This can be done using hreflang link tags or the country targeting setting in Search Console.

Search appearance

How your page or app appears in search.
  • Structured data
    A public XML standard way of describing information about your pages in a format that the Google crawling engine understands. For instance, you can add ratings, event information, or video information. Some types of structured data are used to create rich snippets.
  • Snippets
    The small descriptive lines of text that appear under each result in Google search results. These are generated programmatically by Google during indexing, and can have visual characteristics known as rich snippets.
  • Rich snippet
    A visually enhanced Google search result, such as star ratings or event times. Rich snippets are often generated from structured data added by the page author.
  • Sitelink
    If your website has a logical hierarchy or structure, Google might display a set of sub-links below the main search result. For example, for an airline site, the main result will be the airline home page, and the smaller links below would be direct links to the booking page, the flight status page, the baggage policies page, and so on. You cannot specify sitelinks for your site.

The Reality Of The News

There have been a few times where I have clicked on a news article only to realise that I have been hit with a paywall. I don't mean thi...