programming | Rainnic in the Clouds

programming

How to alternate colours when changes day

Submitted by Nicola Rainiero on 2018-07-02 (last updated on 2018-07-03)
How to alternate colours when changes day

I am continuing the development of my script to auto-transfer Calendar entries into a spreadsheet. In this article I show you a convenient function to change the colour of the row when changes the day of the event, useful when for example you have more than one shifts and you want to improve the readability of the table.


5 steps to auto-transfer your Calendar entries into a spreadsheet

Submitted by Nicola Rainiero on 2018-06-03 (last updated on 2018-06-10)
Instructions to generate a Google sheet from your Calendar entries

In the article and more accurately described in the video, I explain you how to export your calendar events into a spreadsheet using the Google Apps Script. Besides I show you the use of triggers to automate the update of the sheet when you change, add or remove an event.


An example on transfer entries from Calendar to Sheet through Google Apps Script

Submitted by Nicola Rainiero on 2018-04-22 (last updated on 2018-05-29)
An example on transfer entries from Calendar to Sheet through Google Apps Script

I want to introduce you with a video, that show how fast and efficient is the use of Google Apps Script to automate the export of Google Calendar data into Google Sheet. Besides it is possible to instruct the code to make some calculation, change the style and do everything you want.


A little Python program to follow the 20-20-20 rule and prevent eye strain

Submitted by Nicola Rainiero on 2018-04-15 (last updated on 2018-07-09)
A little Python program to follow the 20-20-20 rule and prevent eye strain

I have recently started to complain some eye strain and headache, after remaining many hours in front of my laptop screen. Hence I discovered the 20-20-20 rule and wrote a script in Python to automatic show a black fullscreen every 20 minutes for 20 seconds in order to force me to look away at something that is 20 feet (about 6,10 meters) from me. Besides the program makes a sound when the screen turns on again.


An improved bash script to shuffle files and the MP3 tags too

Submitted by Nicola Rainiero on 2018-04-01 (last updated on 2018-04-02)
An improved bash script to shuffle files and the MP3 tags too

The script removes empty spaces and special characters (i.e. ', " and -) from a directory of defined files and then it shuffles them by adding a random number followed by an underscore. For the MP3 files it mixes-up also the ID3 tags and it has a special feature to add them if missing, starting from the filename (only if it is renamed like this: Album_name-Artist_name-Title_name.mp3 or Artist_name-Title_name.mp3).


How to shuffle slyly a list of file with a bash script

Submitted by Nicola Rainiero on 2017-02-12 (last updated on 2017-02-13)
How to shuffle slyly a list of file with a bash script

I present a little bash script to change the alphabetical order in a specified or working folder of files, simply adding a random prefix and checking that the resulting one differs from a fixed number of previous elements. I wrote it to shuffle a list of songs that I usually listen to my poor car radio, but I think that it could be useful also for presentation of a series of pictures via usb pen and a TV. In addition this script has a clean option that can rename the files to the original version, useful for make another mix.


A bash script multi-tool and easy editable

Submitted by Nicola Rainiero on 2013-05-20 (last updated on 2013-05-23)
A bash script multi-tool and easy editable

I happen very often to convert/resize/rename a directory of files, so sometimes I can fix manually file by file or if there are many of the ones, I can modify an existent bash for accelerating the process. However it is a waste of time the changing the whole file to adapt it at the new commands (hazards are always lurking!).


Software to design a storm sewer system

Submitted by Nicola Rainiero on 2012-07-02 (last updated on 2013-06-26)
Open source software to design a storm sewer system

I publish an open source code that calculates line by line the suitable diameter for a given sewer system, using the linear reservoir model. It can design according to three different variables: speed, shear stress or slope of the line. It gives a final report, useful for calculus relations or following elaborations.


Programming saved me from calculus

Submitted by Nicola Rainiero on 2012-06-17 (last updated on 2012-07-30)
Programming wiht Sharp PC-E500S

At the beginning for necessity: I needed a tool to speed and to check the exercises at the University, today I reduced drastically times in designing.

Sometimes a casual event leads to a surprising result, like the finding of an twelve years old calculator, a Sharp PC-E500S in the original box and yet in a good state of conservation.