How to Sort using Background color of cells in a column

It is very difficult to do it in first attempt. you need to be innovative to do so. To sort by background color , first fetch the color code through script in corresponding neighbour column. Fetching color through app script is easy. Create a function like below

function getHexValue(range) {
  return SpreadsheetApp.getActiveSheet().getRange(range).getBackground();

Now use formula like =getHexValue(A2) where A2 is range of sample cell. This will populate a column and based on value in this column, sort it . Now detailed in steps:

Step 1: Go to tools > Script Editor and create a new function.

script getHexValue to fetch background color of Google sheet cell

Step 2: Apply formula =getHexValue(A2)

Step 3: Sort 

Why do exercise in office hours?

When most of us sit continuously for long hours at work. Long hours of sitting is bad for health ,therefore it is advisable to do some walk and excercise to remove the stress and improve the health outcomes.

Excercise could be very simple and all have a purpose – look away from screen, reduce stress level and perform some muscle relaxing activities.

  1. Close eyes for 1 minute and do nothing.
  2. Walk every 2nd hours for 5 minute
  3. Turn necks left and right slowly to relieve neck pain.
  4. Stretch leg and relax muscle. 
  5. Stretch arms 
  6. Twist body to relieve back pain

Beside it, consume water at regular interval.

Why you should use sqlite as portable database

Most of time when we need some tasks to run for long hours in a loop, sqlite is ideal solution to use as a database.

  1. sqlite is available in most of system. No need to install big binary files.
  2. You can easily use it with multiple programming language using simple apis.
  3. You can transport it as file to other system. No need to export and import files to recreate the same
    I use sqlite too much in smaller long running batch tasks to store data and use across different cli apps. I can run this on smallest and tiniest machine easily

Why deploy nginx as most preferred proxy server?

Nginx define itself as open-source, high-performance HTTP server and reverse proxy engine. It is simple to configure proxy server, effective load balancer. 
Nginx is super easy to configure. Multiple types of proxy configuration is possible – round robin, least connected , ip bound , fail over connection, path based.

It is easy to host a rails app on mail domain and wordpress on /blog path. Run an analytic engine using R (shiny apps) and do some smart system tasks using python backend.

nginx is free and open source . It is much robust than apache and first choice for proxy. I love it when need to operate a bunch of service varied by different type of services .

What is mobile first indexing and why adhere to it?

Mobile first Indexing (MFI) is now becoming to core of search snippets because mobile search in increasing ( voice + text ) . It is highly recommended to shift focus on mobile first and mobile friendly content. 

Use adaptive layout(responsive layout) with similar static content . More interactive content could be loaded over ajax. Proper usages of schema will content of your pages to be index smoother. 

Schema are data-points embedded in your page. Separate business logic, business data and business presentation separate , so any crawler could easily evaluate the source code and map useful data instantly. Schema is for carry data , independent of visual representation.

Outcome of this message is – 

  1. Make mobile first strategy ( UI + UX)
  2. Use Schema to embed data in your page
  3. Static version (initial load) content should be closely identical.