If you’re looking at too many numbers on the screen and they are large enough to be reduced by thousands you can reduce them using a simple custom number format in Google Sheets. A B C D E 1 719,568 947,834 1,028,012 1,075,867 1,426,528 2 61,898 70,544 84,735 96,244 111,498 3 98,370 100,337 110,341 112,221 114,139 4 100,150 118,869 143,510 163,357 198,662 5 979,986 1,237,584 1,366,599 1,447,688 1,850,817 Too many numbers on a spreadsheet can make it difficult to read. ...

There are three main ways within Python on how to remove specific characters from a string in Python, and I’ve clustered these approaches based on the following methods: Built-in string methods By pattern By position Each approach has its own unique way of being able to perform the task required, so we will explore each with the use of examples to illustrate what might suit your use case best. Remove Characters Using Built-In String Methods The most popular methods of removing specific characters from a string in Python is through the use of 2 string methods: ...

WARNING – The content contained in this article no longer works per Bitnami’s deprecation of modules – their announcement is here if you want to find out more. I found it tedious trying to change all of my websites (6 in total) to Amazon’s Lightsail Bitnami WordPress box. There are many instructions on how to do this using the WordPress Multisite feature, but not if you actually need individual WordPress installations on the same box. ...

The DATEDIF function calculates the number of periods between two dates. The best way to remember this function is it calculates the DATE DIFference between two dates. What Is DATEDIF? The DATEDIF formula calculates the difference between two dates according to a third parameter determining the type of difference needed, for example, days, months, years (etc). The DATEDIF function is a popular formula that has 3 parameters that are all required. If you encounter any error when using this function check you have populated all three fields correctly. ...

I was once connecting my Dropbox account to a Windows VPS to try and sync files from the server to my computer. While I ran into a few problems initially with probably the biggest problem being NOT selecting which folders TO sync and as a result I fried a few Windows boxes. And the software doing the pushing needs to be lightweight. Store your images on Amazon’s S3 It is relatively cheap to store your photos on Amazon S3 with each GB costing around 2.5 cents! That’s correct, a whopping 2.5 cents to store all your files per gigabyte. ...

If you have a custom domain and want to be able to send email through your personal Gmail account without having to register for a Business Gmail account then here’s how you can do it using Amazon’s SES. Prerequisite If you haven’t done so already you will need to set up your custom domain in Amazon’s SES. Here is a detailed step-by-step guide on how to create your email accounts using Amazon SES, Lambda and S3. ...

If you’ve created your own custom domain and want to be able to create custom email accounts, but don’t want to register for a Gmail Business account due to cost then there’s an easy way to manage an email server within Amazon called Simple Email Service (SES). In this article you will learn how to register a domain within SES ready for receiving email, then you will see how we can create an S3 bucket to be your simple inbox storage system, followed by creating a Lambda function to forward any email through to your personal account. ...

If you’ve created a static site using the wonderful Hugo package and need to create some simple redirect HTML web pages then you’ll need to do the following: Create your HTML template and place it in your main layout folder. Create an archetype template file. Create a file using the archetype and fill in all the meta header information. Publish your page. Creating a simple redirect layout in Hugo is relatively easy and can help if you are transitioning from other content providers such as WordPress where your Hugo website structure may slightly change for some posts and pages. ...

In our previous post on clasp and Google App Script code we discovered how we can pull code down locally, do our edits and then push it back to Google Apps. This is great when we’re working on code on the back-end of Google Sheets, or Google Forms, or any of the other great Google Apps. However, what do you do when you want to write code, but you don’t want someone ‘accidentally’ editing your code? ...

Previously I posted how you can use the INDEX() function to obtain the fields needed for a simple SUM() function. Then I came across another handy Google Sheet function ARRAY_CONSTRAIN(). What ARRAY_CONSTRAIN Does There are three parameters with this formula: range – insert the range for the formula to operate on. num_rows – set the number of rows to compress. num_cols – set the number of columns to compress. All are required fields. ...