Tips

1. Use https://sheet.new/ for creating a new sheet
2. If it is not very private at-least make it readable, commentable, editable by anybody who has access to the link.
   1. Create a revision of the file at a point where you want to preserve it. Use named revisions
3. If you are working with numbers,
   1. always use a pivot table
      1. Pivot table gives you a good summary of the aggregates
   2. Use column summaries to get insights
4. Use pandas to get some basic insights using data-EDA
   1. https://towardsdatascience.com/read-data-from-google-sheets-into-pandas-without-the-google-sheets-api-5c468536550
5. Recommendations
   1. https://twitter.com/blakeaburge/status/1560959860216193024

Sorting a range by two columns

1. https://www.wikihow.com/Sort-by-Multiple-Columns-in-Google-Spreadsheets

Filter

1. =TRANSPOSE(FILTER(villagedata!1:1),villagedata!1:1<>"" )

TODO

1. Convert spreadsheet to json.

Conditional Formatting

To format an entire row based on the value of one of the cells in that row: Source - https://support.google.com/docs/answer/78413

1. On your computer, open a spreadsheet in Google Sheets.
2. Select the range you want to format, for example, columns A:E.
3. Click Format Conditional formatting.
4. Under the "Format cells if" drop-down menu, click Custom formula is. If there's already a rule, click it or Add new rule  Custom formula is.
5. Write the rule for the first row. For example, if you want to make the whole row green if the value in column B is "Yes", write a formula like =$B1="Yes"
6. Choose other formatting properties.
7. Click Done.

https://www.benlcollins.com/spreadsheets/conditional-formatting-entire-row/