It's time to update my Google Apps Script that exports calendar events into a spreadsheet. I use it to comparison my worked hours with the month payroll, so putting all my shifts on Google Calendar I have in automatic a sheet with all the shifts data. I added how to extract night and holiday hours and count the worked days in a range of dates.
This is the third article on the topic and if you want to know more I suggest you to read the previous posts:
Are you tired of having to load, place and resize the programs you normally use every time you start your computer? Would you like to have a simple program that does it for you automatically? Do you wish easily to switch from a series of programs oriented to different uses (office, internet, multimedia, CAD and 3D)? In the article I propose all this by presenting an easy-to-use Python script for Ubuntu and derivatives.
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.
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.
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.
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.
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).
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.
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!).
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.